Horizontal Analysis Definition

what is horizontal analysis

This causes difficulties since it’s hard to compare companies of different sizes. DisclaimerAll content on this website, including dictionary, thesaurus, literature, geography, and other reference data is for informational purposes only. This information should not be considered complete, up to date, and is not intended to be used in place of a visit, consultation, or advice of a legal, medical, or any other professional. Get a daily selection of our top stories based on your reading preferences.

First, we need to take the previous year as the base year and last year as the comparison year. The method also enables the analysis of relative changes in different product lines and projections into the future. By seeing the trend, which is a remarkable growth of over 100% from one year to the next, we can also see that the trend itself is not that remarkable of only 10% change from 2013 at 110% to 120% in 2014. Which could show, that perhaps growth is starting to stagnate or level-off. In a Horizontal Analysis, we state both the dollar amount of change and the percentage of change, because either one alone might be misleading.

Trends in gross margin generally reveal how much pricing power a company has. We can even take this one step further by calculating the compound annual growth rate for each line item from 2014 to 2018. Add horizontal analysis to one of your lists below, or create a new one. Thanks to everyone that has a clear and detail explanation about the horizontal analysis with a best eg. What is vertical analysis if possible mention 1 or 2 examples here too. Please carry out common size analysis on multiple years i.e 2008,2007,2006, 2005. Regardless of how useful trend analysis may be, it is regularly criticized.

Run A Finance Blog? See How You Can Partner With Us

Hi , i am supposed to do trend analysis of last 10 years of two companies between them so should i take one year as base year and calculate changes according to that or do it taking 2 2 years. The comparative condensed income statements of SPENCER Corporation are shown below.

  • For example, a company’s management may establish that the robust growth of revenues or the decline of the cost of goods sold as the cause for rising earnings per share.
  • When proportionate changes in the same figure over a given time period expressed as a percentage is known as horizontal analysis.
  • You can perform horizontal analysis on any financial statement metric, financial ratio, or financial statement line item.
  • These ratios demonstrate how long it takes for a company to pay off its accounts payable and how long it takes for a company to receive payments, respectively.
  • Hi, I know how to calculate the change, but im not sure how to explain the change in words.
  • This type of presentation makes it easier to spot declining margins and/or liquidity problems early and make corrections before they can become serious concerns.

Horizontal Analysis is undertaken to ascertain how the company performed over the years or what is its financial status, as compared to the prior period. As against, vertical analysis is used to report the stakeholder about the portion of line items to the total, in the current financial year. Comparison of financial statements or specific items in a financial statement that covers two or more periods. Ideally, the horizontal and vertical analysis are combined to paint a comprehensive picture of a company’s financial performance over time.

Boundless Accounting

Horizontal analysis is the comparison of historical financial information over various reporting periods. When creating a Vertical Analysis of an Income Statement, the amounts of individual items are calculated as a percentage of Total Sales. A Vertical Analysis can be completed on both an Income Statement and a Balance Sheet. Unlike Horizontal Analysis, a Vertical Analysis is confined within one year ; so we only need one period of data to derived the percentages and completed the analysis. By identifying a problem, businesses can then devise a strategy to cope with it. The key to analysis is to identify potential problems provide the necessary data to legitimize change. Vertical Analysis – compares the relationship between a single item on the Financial Statements to the total transactions within one given period.

what is horizontal analysis

Now we can assume a sales growth percentage based on the historical trends and project the revenues under each segment. Therefore, total net sales are the Oral, Personal https://www.bookstime.com/ & Home Care, andPet Nutrition Segment. To illustrate, consider an investor who wishes to determine Company ABC’s performance over the past year before investing.

The Usefulness Of Horizontal Analysis

17,0007.4%A horizontal analysis of Jonick’s 2018 and 2019 income statements appears above. The first two columns show income statement amounts for two consecutive years.

  • As opposed, the vertical analysis is used to compare the results of one company’s financial statement with that of another, of the same industry.
  • For example, you may show merchandise inventory or accounts receivable as a percentage of total assets.
  • Cost Of SalesThe costs directly attributable to the production of the goods that are sold in the firm or organization are referred to as the cost of sales.
  • For a better picture of performance, the analysis should be expressed as a percentage as opposed to currency.
  • It can be used to assess the performance of a company over a period of time.
  • The above example of Horizontal analysis shows us that a 66% increase in sales led to a 60% increase in net profits.
  • A 66% increase in sales in a year speaks that the business is growing rapidly.

If the analyst wanted to investigate the income statement, one could suggest the net earnings and expenses as sections to study. The most obvious benefit of horizontal analysis is that helps paint a picture of how a business has performed over time.

For example, let us assume that we are interested in comparing gross sales of a business quarter-over-quarter for the last year. Using the financial statements, we could take the gross sales from the first quarter as our beginning period’s value. The component of “time” in financial statement analysis holds a great deal of weight.

Management Accounting

Vertical analysis also makes it easy to compare companies of different sizes by allowing you to analyze their financial data vertically as a percentage of a base figure. Consider that a company’s net income last year, the base year, was $400,000, and this year it’s $500,000. Dividing the difference ($100,000) by the base year’s amount ($400,000) equals 0.25. This means that the company’s net income increased by 25% from last year to this year. How detailed your initial financial statements are depends largely on the accounting software application you’re using.

  • Common methods of financial statement analysis include fundamental analysis, DuPont analysis, horizontal and vertical analysis and the use of financial ratios.
  • There are two methods for doing a horizontal analysis, which is sometimes referred to as a trend analysis.
  • Structured Query Language is a specialized programming language designed for interacting with a database….
  • All such information is provided solely for convenience purposes only and all users thereof should be guided accordingly.
  • The value of horizontal analysis enables analysts to assess the company’s past performance and current financial position or growth and project the useful insights gained into the future.
  • You do not need any special financial skill to ascertain the difference between previous and last year’s data.

The only limiting factor in choosing ratios is that the items used to construct a ratio must have a logical relationship to one another. The horizontal method is comparative, and shows the same company’s financial statements for one or two successive periods in side-by-side columns. The side-by-side display reveals changes in a company’s performance and highlights trends.


First, we noted that Colgate has not provided segmental information in the income statement. However, as additional information, Colgate has provided some details of segments on page 87.

We have no way of knowing, because we don’t know the cash positions of Companies A and B, how profitable Companies A and B are, etc. To know about strengths and weaknesses of a company, different combinations of financial ratios are used. The investor now needs to make a decision based on their analysis of the figures, as well as a comparison to other similar figures.

Horizontal Analysis Formula

Therefore, horizontal analysis is extremely useful for businesses to understand how the numbers in their income statement are moving. Percentage analysis as a method of horizontal analysis is usually preferred over dollar analysis for a simple reason. It is always easy to understand the change in percentage terms rather than in terms of actual values. E.g., If Smith tells his friends that he has increased his ice-cream sales by an amount of $20,000, they may not be much impressed. However, if Smith tells his friends that he has increased the sales by 66.67%, now he is talking! A 66% increase in sales in a year speaks that the business is growing rapidly.

Comparability means that a company’s financial statements can be compared to those of another company in the same industry. An absolute comparison involves comparing the amount of the same line of the item to its amounts in the other accounting periods. For example, comparing the accounts receivables of one year to those of the previous year. The horizontal method of analysis is used to identify changes in financial statements over time and assess those changes. Calculating the horizontal analysis of a balance sheet is a similar process. You can choose to run a comparative balance sheet for the periods desired, or complete a side-by-side comparison of two years. Let us now look at the horizontal analysis of Colgate’s income statement.

what is horizontal analysis

No company lives in a bubble, so it is also helpful to compare these results with those of competitors to determine whether the problem is industry-wide, or just within the company itself. If no problems exist industry-wide, one will observe a shortfall in Sales and rise in the dollar amount of Sales returns. For instance, a large increase in Sales returns and allowances coupled with a decrease in Sales over two years would be cause for concern.

When proportionate changes in the same figure over a given time period expressed as a percentage is known as horizontal analysis. To isolate the reason for the net income decline, look at the change in total dollars, as well as the percentage change. The repair expense is the largest percentage change — an increase in costs. But note that the dollar amount of change is only $1,650 ($4,150 to $5,800).

Comparative Retained Earnings Statement With Horizontal Analysis:

These stakeholders have different interests and apply a variety of different techniques to meet their needs. For example, equity investors are interested in the long-term earnings power of the organization horizontal analysis formula and perhaps the sustainability and growth of dividend payments. Creditors want to ensure the interest and principal is paid on the organizations debt securities (e.g., bonds) when due.

Next Steps In Financial Statement Analysis

This formula for evaluation is typically done by either investors and internal company management since both need to understand how well a company is doing in order to make decisions. Investors have to make the decision whether or not they want to invest or sell their current investment; while management needs to know what moves to make in order to improve the future performance of the company. You can also choose to calculate income statement ratios such as gross margin and profit margin.

Horizontal Analysis refers to the process of comparing the line of items over the period, in the comparative financial statement, to track the overall trend and performance. In vertical analysis, the line of items on a balance sheet can be expressed as a proportion or percentage of total assets, liabilities or equity. However, in the case of the income statement, the same may be indicated as a percentage of gross sales, while in cash flow statement, the cash inflows and outflows are denoted as a proportion of total cash inflow. Financial statement analysis, also known as financial analysis, is the process of understanding the risk and profitability of a company through the analysis of that company’s reported financial information. This information includes annual and quarterly reports, such as income statements, balance sheets, and statements of cash flows. It involves identifying the co-relation of items relating to a company’s financial information and how they affect the overall performance of an organization.

Let’s assume that we have $100,000 in assets, including our equipment, building, inventory, and land. Our balance sheet would show that our ice cream shop is worth $25,000. Using horizontal analysis, we can compare this equity to our equity from a previous point in time, which will tell us whether it’s time to invest in more assets or pay down our liabilities.

Leave a Comment

Your email address will not be published. Required fields are marked *