EDUCBA

EDUCBA

MENUMENU
  • Blog
  • Free Courses
  • All Courses
  • All in One Bundle
  • Login
Home Finance Finance Resources Finance Formula Horizontal Analysis Formula

Horizontal Analysis Formula

Madhuri Thakur
Article byMadhuri Thakur

Updated July 1, 2023

What is the Horizontal Analysis Formula?

Horizontal Analysis Formula

The term “Horizontal Analysis” refers to the method of analyzing financial statements where historical data from the income statement, balance sheet, and cash flow statement are subject to comparison. This comparison shows how each line item has changed in absolute terms or as a percentage change year over year (Y-o-Y).

Using this formula, the analyst can determine the percentage change between two years for any given financial statement line item.  This calculation helps identify trends and fluctuations in financial performance, which is useful in making informed business decisions.

Start Your Free Investment Banking Course

Download Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

Formula

We can derive the formula for horizontal analysis (absolute terms) by deducting the amount in the base year from the amount in the comparison year. Mathematically, we represent it as,

Horizontal Analysis (absolute) = Amount in Comparison Year – Amount in Base Year

The formula for horizontal analysis (% change) can be derived by dividing the difference between the amount in the comparison year and the base year’s amount in the base year. Mathematically, we represent it as,

Horizontal Analysis (%) = [(Amount in Comparison Year – Amount in Base Year) / Amount in Base Year] * 100

Example of Horizontal Analysis Formula (With Excel Template)

You can download this Horizontal Analysis Formula Excel Template here – Horizontal Analysis Formula Excel Template

Example #1

ASD Inc. manufactures precision components for Tier-I OEMs (Original equipment manufacturers). We have the data of its income statement from its latest annual report. Let’s perform a horizontal analysis.

Given,

Horizontal Analysis Formula-Eg1 Given

Solution:
To perform a horizontal analysis of ASD Inc.’s income statement data, we will use the following formula:

Horizontal Analysis (absolute) = Amount in Comparison Year – Amount in Base Year

Eg 1 Sol-1

We will apply this formula to each line item to calculate its absolute change.

Eg1 sol-2

To calculate the percentage change, we will use the following formula:

Horizontal Analysis (%) = [(Amount in Comparison Year – Amount in Base Year) / Amount in Base Year] * 100

Eg1 sol-3

We will also apply this formula to each line item to calculate its percentage change.

Eg1 sol-4

Based on the results, we can conclude that:

  • The percentage change in gross profit has been relatively higher than that of net sales due to a lower increase in the cost of goods sold.
  • Operating income and net income have also witnessed higher growth due to a lower increase in SG&A expense and income tax, respectively.

Example #2

Let us take the annual report of Apple Inc. for the year 2022 to illustrate the financial statement’s preparation of horizontal analysis. In this case, we will be using the income statement, and accordingly, the following information is taken from the annual report:

Horizontal Analysis Formula-Eg2

(Source: Annual Report of Apple Inc. for FY22)

Given,

Horizontal Analysis Formula-Eg2 given

Solution:
First of all, we will calculate the gross profit:
Gross Profit = Net Sales – Cost of Sales
= $394,328 – $223,456
= $170,872 (for FY22)

Eg2 sol-1

Similarly, we will do the calculation for FY2021 and FY2020:

Eg2 sol-2

Next, we will calculate the operating income:
Operating Income = Gross Profit – Research and Development – SG&A Expense
= $170,872 – $26,251 – $25,094
= $119,527 (for FY22)

Eg2 sol-3

Similarly, we will do the calculation for FY2021 and FY2020:

Eg2 sol-4

Now, we will calculate the Net Income:
Net Income = Operating Income + Other Income + Provision for Income Tax
= $119,527 + $334 + $19,300
= $139,161 (for FY22)

Eg2 sol-5

Similarly, we will calculate Net income for FY2021 and FY2020:

Eg2 sol-6

Now, we will calculate the horizontal analysis using the formula given below:
Horizontal Analysis (%) = [(Amount in Comparison Year – Amount in Base Year) /
Amount in Base Year] * 100
=  [($394,328 – $297,515)/ $297,515]*100
= 32.60%

Eg2 sol-7

Similarly, we will calculate for the further items too by dragging the formula vertically:

Eg2 sol-8

Similarly, we will calculate for FY2021:

Horizontal Analysis Formula-Eg2 sol-9

Likewise, we will then calculate % change for other particulars by dragging the formula vertically:

Eg2 sol-10

From the analysis done above, we can draw the following conclusions:

  • The overall growth has been relatively higher in the year 2022 compared to that of the year 2021. Nevertheless, it indicates that the company has witnessed continuous growth in the last two years.
  • Further, it is also noticed that the operating income moves in tandem with the revenue growth, which is a good sign.

Relevance and Use of Horizontal Analysis Formula

It is important to understand the horizontal analysis concept for the following reasons:

  • It helps in determining the trend in each line item Y-o-Y. Any sharp deviation in trend may indicate some anomaly in reporting that requires immediate investigation. It is useful in assessing a company’s performance over a period. This analysis technique can provide an overall picture of where the subject company stands regarding financial matters.
  • Horizontal analysis helps analyze trends in financial statements and identify areas of strength or weakness in a company’s performance over time.
  • We can apply the formula to various financial statements, including balance sheets, income statements, and cash flow statements. It is helpful in comparing the performance of different companies in the same industry.
  • It is a valuable tool for financial analysts and investors seeking to understand a company’s financial performance over time. Using this formula, analysts can identify trends and patterns in financial data that can inform their investment decisions and help them make more informed decisions about the company’s prospects.

Horizontal Analysis Formula Calculator

Use the following calculator for Horizontal Analysis Formula calculations.

Amount in Comparison Year
Amount in Base Year
Horizontal Analysis (absolute) =
 

Horizontal Analysis (absolute) = (Amount in Comparison Year - Amount in Base Year)
=(0 - 0 ) = 0

Frequently Asked Questions (FAQs)

Q1. How do you calculate a horizontal analysis?
Answer: To calculate a horizontal analysis, you can use the following formula:
 (Current Year Amount – Base Year Amount) / Base Year Amount x 100% 
The formula calculates the percentage change between the current year amount and the base year amount for each line item in a financial statement. The percentage change indicates how much the line item has increased or decreased over time.

Q2. What is the formula for horizontal and vertical analysis?
Answer: The formulas for horizontal and vertical analysis are as follows:
Horizontal Analysis= (Current Year Amount – Base Year Amount) / Base Year Amount x 100% 
Refer to the prior sections to learn more about the horizontal analysis formula.
Vertical Analysis: (Line Item Amount / Total Amount) x 100% 
The vertical analysis formula calculates the proportion or percentage of a line item relative to the total amount on a financial statement. This analysis compares line items within the same financial statement and identifies each item’s relative importance.

Q3. How are the results of horizontal and vertical analysis interpreted?
Answer: The interpretation of the results of horizontal and vertical analysis involves analyzing the changes and trends in a company’s financial statements over time and understanding the significance of these changes.

Recommended Articles

This is a guide to Horizontal Analysis Formula. Here we discuss how to calculate the Horizontal Analysis along with practical examples. We also provide a Horizontal Analysis calculator with a downloadable Excel template. You may also look at the following articles to learn more –

  1. Cost-Benefit Analysis Formula
  2. Break-Even Analysis Formula
  3. Vertical Analysis of Income Statement
  4. Variance Analysis Formula
  5. Different Types of Balance Sheet Ratios
All in One Excel VBA Bundle
500+ Hours of HD Videos
15 Learning Paths
120+ Courses
Verifiable Certificate of Completion
Lifetime Access
Financial Analyst Masters Training Program
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
All in One Data Science Bundle
2000+ Hour of HD Videos
80 Learning Paths
400+ Courses
Verifiable Certificate of Completion
Lifetime Access
All in One Software Development Bundle
5000+ Hours of HD Videos
149 Learning Paths
1050+ Courses
Verifiable Certificate of Completion
Lifetime Access
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Investment Banking Jobs Offer
  • Finance Formula
  • All Tutorials
Certification Courses
  • All Courses
  • Financial Analyst All in One Bundle
  • Investment Banking Training
  • Financial Modeling Course
  • Equity Research Course
  • Private Equity Training Course
  • Business Valuation Course
  • Mergers and Acquisitions Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

Download Horizontal Analysis Formula Excel Template

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA
Free Investment Banking Course

Corporate Valuation, Investment Banking, Accounting, CFA Calculator & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

डाउनलोड Horizontal Analysis Formula Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more