WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 250+ Courses All In One Bundle
  • Login
Home » Investment Banking Tutorials » Financial Statement Analysis » Horizontal Analysis

Horizontal Analysis

What is Horizontal Analysis?

Horizontal Analysis of Financial Statements is one of the most important techniques to find out how a company is doing financially. It is used for evaluating trends year over year (YoY) or quarter over quarter (QoQ).

If you are an investor and thinking about investing in a company, only a year-end balance sheet or income statement wouldn’t be enough for you to judge how a company is doing. You need to look at a couple of years at least to be sure. Better yet, if you can see many years of balance sheets and income statements and make a comparison among them.

Through horizontal analysis of financial statements, you would be able to see two actual data for consecutive years and would be able to compare each and every item. And on the basis of that, you can forecast the future and understand the trend.

You don’t need any special financial skill to ascertain the difference between the previous year’s data and last year’s data. All you need is diligence, attention to details, and a logical mind to decipher why the change happens.

Horizontal Analysis

In this GKSR example above, we are able to identify the YoY growth rate using Horizontal Analysis. It helps us identify potentials areas of growth and concerns.

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course

For example, in GKSR, we note that the provision for income tax has increased by 12.6%; however, revenues have increased by only 5.5%. Why did provisions increase at a higher rate? Also, there has been a comparatively higher growth of 9.1% in Selling and Admin costs. What could have contributed to this increase?

As we see, we are able to correctly identify the trends and also come up with relevant areas to target for further analysis.

Horizontal Analysis Formula

First, we need to take the previous year as the base year and last year as the comparison year. For example, let’s say we are comparing between 2015 and 2016; we will take 2015 as the base year and 2016 as the comparison year.

Horizontal Analysis formula = [(Amount in comparison year – Amount in the base year)/ Amount in a base year]  x 100

Horizontal Analysis

Horizontal Analysis Example (Basic)
Let us assume that we are provided with the Income Statement data of company ABC. We need to horizontal analysis on this company.

Details 2016 (In US $) 2015 (In US $) Amount Percentage
Sales 30,00,000 28,00,000 200,000 * 7.14% **
(-) Cost of Goods Sold (COGS) (21,00,000) (20,00,000) 100,000 5%
Gross Profit 900,000 800,000 100,000 12.50%
General Expenses 180,000 120,000 60,000 50%
Selling Expenses 220,000 230,000 (10,000) (4.35%)
Total Operating Expenses (400,000) (350,000) 50,000 14.29%
Operating Income 500,000 450,000 50,000 11.11%
Interest expenses (50,000) (50,000) § §
Profit before Income Tax 450,000 400,000 50,000 12.50%
Income Tax (125,000) (100,000) 25,000 25%
Net Income 325,000 300,000 25,000 8.33%

This is a basic example, where we have divided our approach into two parts. First, we found the absolute difference between the comparative years.

  • For example, Change in Sales = (30, 00,000 – 28, 00,000) = 200,000
  • We find the percentage change = 200,000/28, 00,000 * 100 = 7.14%

Likewise, we can do the same for all the other entries in the Income Statement.

Colgate Horizontal Analysis Example

Let us now look at the horizontal analysis of Colgate. Here we have the YoY growth rates of Colgate’s Income statement from 2008 until 2015. We calculate the growth rate of each of the line items with respect to the previous year.

For example, to find the growth rate of Net Sales of 2015, the formula is (Net Sales 2015 – Net Sales 2014) / Net Sales 2014.
Horizontal Analysis - Income Statement Colgate

Here are the following observations from Colgate’s.

  • In the last two years, Colgate has seen a dip in Net Sales figures. In 2015, Colgate saw a de-growth of -7.2% in 2015. Why?
  • Cost of Sales, however, has decreased (positive from the company’s point of view). Why is this so?
  • Net Income decreased in the last three years, with as much as 36.5% decline in 2015.

Interpretation

  • From the income statements and balance sheets, a company may portray a pretty good hold on their financial affairs. But as an investor, it’s your responsibility to check each item and understand why there is a difference. Your minute attention to details may help you discover something about the company which the company wanted to hide from all the potential investors.
  • Companies can inflate profit or show an undervalued statement by changing a few things here and there. But if you pay attention to details, you would be able to discover what’s actually going on within the company.
  • With such analysis, you would be able to understand how this company may do in the upcoming years, what they are trying to accomplish over the years, and what’s their recent purchase, sales, revenue, net income, fixed assets, current assets, capital structure and every minute data mentioned in the balance sheet and income statement.
  • Unlike other ratios, this technique gives investors an overall picture of where a company stands in terms of financial matters, what they are trying to do with the funds, and how profitable the company can be in the near future.

Horizontal Analysis in Forecasting and Financial Modeling

Horizontal Analysis is very useful for Financial Modeling and Forecasting. The approach used here is fairly simple.

  • Step 1 – Perform the horizontal analysis on the historical data.
  • Step 2 – Based on the YoY or QoQ growth rates, you can make an assumption about future growth rates.

Let us now look at Colgate 10K 2013 report. We note that in the income statement, Colgate has not provided segmental information; however, as additional information, Colgate has provided some details of segments on Page 87 Colgate Segment InformationSource – Colgate 2013 – 10K, Page 86

Since we do not have any further information about the segments, we will project the future sales of Colgate on the basis of this available data. We will use the sales growth approach across segments to derive the forecasts. Please see the below picture. We have calculated the year-over-year growth rate for each segment. Colgate - Revenue ProjectionsNow we can assume a sales growth percentage based on the historical trends and project the revenues under each segment. Total Net sales are the sum total of the Oral, Personal & Home Care, and Pet Nutrition Segment. Colgate - Revenue Projections - complete

Conclusion

From the above examples, it’s clear that through horizontal analysis of financial statements, you need to look at each and every item in the income statement and balance sheet, and you would get a holistic picture of how a company is doing.

So before investing in any company, you should do the horizontal analysis of the company’s financial statements and go ahead and do what seems appropriate to you.

Horizontal Analysis of Financial Statements Video

Recommended Article

This article has been a guide to what is horizontal analysis. Here we discuss the formula of horizontal analysis along with practical examples and how it is useful in financial statement analysis. You may go through the following articles for further readings on financial analysis

  • What is Horizontal Analysis Formula?
  • Examples of Horizontal Merger
  • Components of Financial Statements
  • Operating Income Formula
4 Shares
Share
Tweet
Share
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

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

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

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

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

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

Login

Forgot Password?

WallStreetMojo

Free Ratio Analysis Course

Step by Step Guide to Calculating Financial Ratios in excel

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More