Horizontal Analysis Definition, Formula, Example in Excel



horizontal analysis formula

The analysis computes the percentage changes in each income statement amount at the far right. A fundamental part of financial statement analysis is comparing a company’s results to its performance in the past and to the average industry benchmark set by comparable peers in the same (or adjacent) industry. A stakeholder needs to keep in mind that past performance does not always dictate future performance.

Horizontal analysis also makes it easier to compare growth rates and profitability among multiple companies in the same industry. 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. Conceptually, the premise of horizontal analysis is that tracking a company’s financial performance in real time and comparing those figures to its past performance (and that of industry peers) can be very practical. Finally, it is important to compare the horizontal analysis results with industry averages, as well as with the company’s competitors. This will help you determine whether the company is performing better or worse than its peers in similar industries and provide you with a more complete picture of its financial performance.

Advantages and Disadvantages of Financial Statement Analysis

The horizontal analysis formula is typically expressed as the percentage change in a financial ratio from one year to the next or as a dollar amount. At least two accounting periods are required for a valid comparison, though in order to spot actual trends, it’s better to include three or more accounting periods when calculating horizontal analysis. To use this formula, you need to know the financial data amounts for both the current period and the base period.

  • Another option is to simply add as many years as would fit on the screen without presenting a variance, allowing you to monitor overall changes by account over time.
  • In addition, the use of horizontal analysis makes it easier to project trends into the future.
  • For example, a statement that says revenues have increased by 10% this past quarter is based on horizontal analysis.
  • For example, Banyan saw a 50% accounts receivable increase from the prior year to the current year.
  • A company that wants to budget properly, control costs, increase revenues, and make long-term expenditure decisions may want to use financial statement analysis to guide future operations.

This type of analysis in the balance sheet is typically done in a two-year manner, as illustrated below, with a variance indicating the difference between the two years for each line item. To acquire relevant insights into how a firm is operating, it’s important to use several years of historical data for this analysis. This can assist in determining what is a definite pattern and what is a one-time occurrence. However, an extra vertical analysis approach is required for management and innovators to make better-informed judgments. When it comes to management, it determines the actions to take in order to improve the future performance of the firm. In general, the method aids in understanding a company’s performance so that educated decisions may be made.

Better stock investments one article a time

This allows a company to see what percentage of cash (the comparison line item) makes up total assets (the other line item) during the period. This can help a business to know how much of one item is contributing to overall operations. For example, a company may want to know how much inventory contributes to total assets.

horizontal analysis formula

Looking at and comparing the financial performance of your business from period to period can help you spot positive trends, such as an increase in sales, as well as red flags that need to be addressed. Horizontal analysis is often referred to as trend analysis, but the latter term has broader applications https://simple-accounting.org/bookkeeping-for-nonprofits-do-nonprofits-need/ and is not specific to financial statements. As the name suggests, trend analysis involves identifying trends and predicting outcomes, which requires analyzing data from multiple consecutive periods. Two popular methods that cover different needs are horizontal and vertical analysis.

Horizontal Analysis Examples

Horizontal analysis trend percentage can be found by finding the balance sheet, income statement and cash flow statement by the scheduling of current and fixed assets and statement of retained earnings. These formulas are used to evaluate trends which can either be quarter-on-quarter or year-on-year depending on the accounting period from which the data is sourced. For horizontal analysis, it’s best to take several years of historical data to gain useful insights into how a company is performing. This can help determine what is a clear trend and what may be a one-off event. A company that wants to budget properly, control costs, increase revenues, and make long-term expenditure decisions may want to use financial statement analysis to guide future operations. As long as the company understands the limitations of the information provided, financial statement analysis is a good tool to predict growth and company financial strength.

It is used to compare two different years by taking the difference of the amounts in each year and dividing it by the amount in the base year. This can be used to compare different aspects of a company, such as sales, profits, and expenses. To illustrate, consider an investor who wishes to determine Company ABC’s performance over the past year before investing.

Difference between Horizontals and Verticals analysis

Second, a variance analysis determines not only the dollar amount but the direction of change for a given general ledger account. Creditors and investors use vertical analysis to compare a company’s financial performance to that of others in the same industry. These formulas are used to compare trends across time, which might be quarter-to-quarter or year-to-year, depending Accounting for a Non-Profit Organization on the accounting period from which the data is derived. Horizontal analysis is the evaluation of an organization’s financial performance over many reporting periods. Side by side they do this to determine if the company’s performance is improving or declining. In the final section, we’ll perform horizontal analysis on our company’s historical balance sheet.

horizontal analysis formula


Jonas Johansen Adventure Trio

Jonas Johansens nye gruppe Adventure Trio er en guitartrio, med musik baseret på enkle, iørefaldende linjer…
Skt. Nikolaigården, Vestergade 21, 8000 Aarhus C

Antonio Zambrini Trio (IT/DK)

Den fantastiske italienske pianist og komponist Antonio Zambrini gæster Aarhus i fint selskab med de to internationalt…
Gyngens Maritza-sal, FO-byen, Frederiksgade 78C, 8000 Aarhus C

Music for Bees

Music for Bees er Benita Haastrups nyetablerede sekstet. Tanken er, at musikken skal opfordre til eftertanke…
Gyngens Maritza-sal, FO-byen, Frederiksgade 78C, 8000 Aarhus C


CLASH er saxofonisten Michael Bladts helt nye projekt, der fik debut under Aarhus Jazzfestival 2022. Med…
Gyngens Maritza-sal, FO-byen, Frederiksgade 78C, 8000 Aarhus C

Gilbert Holmström Quintet

Gilbert Holmström, den banebrydende saxofonist og komponist med et helt eget energifelt i svensk jazzhistorie, modtog…
Gyngens Maritza-sal, FO-byen, Frederiksgade 78C, 8000 Aarhus C


''This is not just one of Europe's most interesting drummers, but one of Europe's most interesting…
Gyngens Maritza-sal, FO-byen, Frederiksgade 78C, 8000 Aarhus C

Blood Sweat Drum + Bass, Strings & Electronica

Til Vinterjazz 2024 præsenterer Danmarks ”ubetinget største, mest eksperimenterende og ikke mindst mest legesyge rytmiske ensemble”…
Musikhuset Aarhus, Rytmisk Sal