Horizontal Analysis Meaning, Formula, Examples

However, this method provides only an overview of the financial health of the business and it is often performed by external stakeholders. For example, if Mistborn Trading set total assets as the base amount and wanted to see what percentage of total assets were made up of cash in the current year, the following calculation would occur. In this first example, I will be doing a horizontal analysis of Company A’s revenue based on its annual income statement. 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.

Trends

This is because vertical analysis expresses each line in the financial statements as a percentage of a base value, like sales. Using this example, vertical analysis takes the income statement and expresses every line item as a percentage of sales, whereas horizontal analysis is concerned with the percentage change in total sales over a period. Horizontal analysis is one Food Truck Accounting approach used in financial statement analysis that helps to compare information over a specific time horizon.

• Using the financial statements, we could take the gross sales from the first quarter as our beginning period’s value.
• If you happen to choose a particularly bad time period for your base values, the values for your comparison period may look much better than they are.
• However, this method provides only an overview of the financial health of the business and it is often performed by external stakeholders.
• Now we can assume a sales growth percentage based on the historical trends and project the revenues under each segment.
• In this article, you will learn about the horizontal analysis of financial statements and how to incorporate it into your company’s accounting practices.
• A horizontal analysis of Jonick’s 2018 and 2019 income statements appears above.

Horizontal Analysis vs. Vertical Analysis

This comparison of income statements will give the manager not only a benchmark for future performance; it will also help him understand what needs to be changed in the future. If we take historical data of the financial statements of a company for year 1 and year 2, then one can compare each item and how it has changed year-over-year. For example, let’s take the case of the income statement – if the gross profit in year 1 was US$40,000 and in year 2 the gross profit was US$44,000, the difference between the two is $4,000. For example, a horizontal analysis of the cost of insurance might list the cost on a quarterly basis for the past few years, while a vertical analysis would present it as a percentage of sales only for the current period. Horizontal analysis of the balance sheet is also usually in a two-year format, such as the one shown below, with a variance showing the difference between the two years for each line item. An alternative format is to add as many years as will fit on the page, without showing a variance, so that you can see general changes by account over multiple years.

Horizontal Analysis Formula

If you are an investor considering investing in a company, only a year-end balance sheet or income statement would not be enough to judge how a company is doing. Better yet, you can see many years of balance sheets and income statements and compare them. On the other horizontal analysis formula hand, comparability constraint dictates that a company’s financial statements and other documentation be such that they can be evaluated against other similar companies within the same industry. Horizontal analysis is used to improve and enhance these constraints during financial reporting.

Advance Your Accounting and Bookkeeping Career

• The same dollar change and percentage change calculations would be used for the income statement line items as well as the balance sheet line items.
• However, it would be best if you had diligence, attention to detail, and a logical mind to decipher why the change happens.
• Trends or changes are measured by comparing the current year’s values against those of the base year.
• In this sample comparative income statement, sales increased 20.0% from one year to the next, yet gross profit and income from operations increased quite a bit more at 33.3% and 60.0%, respectively.
• The horizontal analysis will provide an overview of the historic financial performance of the stock for a specified period.
• For example, let us assume that we are interested in comparing gross sales of a business quarter-over-quarter for the last year.

For this business, the 2020 net income is 97% of the base year, and the 2021 net income is only 46% of the base year. In order to improve the horizontal analysis accounting, income summary a variance column could be added for each year showing the change in absolute amount between each year. The horizontal analysis formula in this case for the variance column is shown in the example below for the revenue line item.

Double Entry Bookkeeping

For instance, if a company records a decrease in its sales, the analysis will show its impact on cash flows as well. If certain historical eras of underperformance are chosen as a comparison, horizontal analysis can be used to make the current period appear better. Now that you know how to calculate percentage change, you can read about all the steps involved in horizontal analysis in the next section. Such analysis provides valuable insights into why any of these line items rose or fell sharply or markedly in year 2, compared to year 1.