horizontal analysis formula

However, when using the analysis technique, the comparison (current) period can be made to appear uncommonly bad or good. It depends on the choice of the base year and the chosen accounting periods on which the analysis starts. In horizontal analysis, the changes in specific financial statement values are expressed as a percentage and in U.S. dollars.

Analysis on the horizontal level allows investors and analysts to examine a firm’s performance over several years and identify trends and growth patterns. This sort of study permits analysts to observe changes in various line items over time and project them into the future. To perform horizontal analysis, you will need to gather financial data for your company over a specific period. This data can be pulled from your company’s financial statements, such as the balance sheet, income statement, and cash flow statement. To conduct horizontal analysis i.e. evaluate underlying trends, it’s essential to compare financial statements of a company or companies over two or more accounting periods.

What is the Horizontal Analysis Formula?

While industry dictates what is an acceptable number of days to sell inventory, 243 days is unsustainable long-term. Banyan Goods will need to better manage their inventory and sales strategies to move inventory more quickly. The dollar change is found by taking the dollar amount in the base year and subtracting that from the year of analysis. For this example, the analysis will be carried out on the data reported for 2021 and 2022. However, you can do this very quickly for multiple years, particularly if you’re interested in long-term trends.

  • 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 looks at certain line items, ratios, or factors over several periods to determine the extent of changes and their trends.
  • The Horizontal Analysis Formula is a very useful tool for comparing different years and understanding how a company is performing.
  • However, you can do this very quickly for multiple years, particularly if you’re interested in long-term trends.
  • Horizontal analysis also makes it easier to compare growth rates and profitability among multiple companies in the same industry.
  • These percentages are considered common-size because they make businesses within industry comparable by taking out fluctuations for size.

How detailed your initial financial statements are depends largely on the accounting software application you’re using. If you’re using an entry-level application, it’s likely you’ll need to use spreadsheets in order to complete the horizontal analysis. A stakeholder needs to keep in mind that past performance does not always dictate future performance. Attention Top 5 Legal Accounting Software for Modern Law Firms must be given to possible economic influences that could skew the numbers being analyzed, such as inflation or a recession. Additionally, the way a company reports information within accounts may change over time. For example, where and when certain transactions are recorded may shift, which may not be readily evident in the financial statements.

Horizontal Analysis of the Income Statement

The highlighted part of the figure shows the number used as the base to create the common-sizing. The image below shows the common-size calculations on the comparative income statements and comparative balance sheets for Banyan Goods. Indeed, sometimes companies change the way they break down their business segments to make the horizontal analysis of growth and profitability trends more difficult to detect.

horizontal analysis formula

Depending on their expectations, Mistborn Trading could make decisions to alter operations to produce expected outcomes. For example, MT saw a 50% accounts receivable increase from the prior year to the current year. If they were only expecting a 20% increase, they may need to explore this line item further to determine what caused this difference and how to correct it going forward. It could possibly be that they are extending credit to customers more readily than anticipated or not collecting as rapidly on outstanding accounts receivable.

Master Personal Finance Management: Tips for Secure Future

For example, if a company’s current year (2022) revenue is $50 million in 2022 and its revenue in the base period, 2021, was $40 million, the net difference between the two periods is $10 million. If you’re looking to invest in a company, horizontal analysis can be a helpful tool in your decision-making process. Understanding how the company has changed over time can better comprehend its potential future performance. However, always consider other factors, as no single tool can give you a perfect prediction of what will happen in the future. The Horizontal Analysis Formula is a very useful tool for comparing different years and understanding how a company is performing.

Horizontal analysis is often referred to as trend analysis, but the latter term has broader applications 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 https://quickbooks-payroll.org/bookkeeping-for-nonprofits-a-basic-guide-best/ periods. Two popular methods that cover different needs are horizontal and vertical analysis. Vertical analysis, on the other hand, focuses on a specific period of time and studies the proportions of the total amount represented by the different variables for that period.


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. Horizontal analysis is an approach used to analyze financial statements by comparing specific financial information for a certain accounting period with information from other periods.

  • Horizontal analysis, or “time series analysis”, is oriented around identifying trends and patterns in the revenue growth profile, profit margins, and/or cyclicality (or seasonality) over a predetermined period.
  • Horizontal analysis is one of the most fundamental financial analyses that you can perform.
  • Secondly, in the second type of horizontal analysis, we are interested in knowing about the underlying trends in the line items of the income statement.
  • This type of question guides itself to selecting certain horizontal analysis methods and specific trends or patterns to seek out.
  • For example, in the income statement, we can, based on historical data and trends, make assumptions about sales growth and then forecast the sales growth rates through the forecast periods.
  • If you’d rather see both variances and percentages, you can add columns in order to display changes in both.

It’s used in the review at a company financial statement over multiple periods it’s usually depicted as percentage growth over the same line items from the base year. Horizontal analysis allows financial statements used to easily spot trends and growth patterns. It’s important to note that horizontal analysis can be conducted for various financial statement items, such as revenues, expenses, assets, or liabilities. By comparing financial data across periods, it helps identify patterns, variations, and potential areas of concern or improvement. The Horizontal Analysis Calculator is a tool used to analyze and compare financial statements over multiple periods. This calculator helps identify trends, changes, and growth rates in financial data, allowing for meaningful comparisons and insights.

Horizontal Analysis of Balance Sheets

By using this formula, businesses can identify areas where they need to make changes to improve their performance. The example from Safeway Stores shows a comparative balance sheet for 2018 and 2019 following a similar format to the income statement above. Horizontal, or trend, analysis is used to spot and evaluate trends over a specific period of time. In this case, current assets were $200,000, and current liabilities were $100,000. Current assets were far greater than current liabilities for Banyan Goods and they would easily be able to cover short-term debt. For example, an analyst may get excellent results when the current period’s income is compared with that of the previous quarter.

horizontal analysis formula

An analysis of the income statement, balance sheet, and cash flow statement over time gives a complete picture of operational results and reveals what is driving a company’s performance and whether it is operating efficiently and profitably. Financial statement analysis reviews financial information found on financial statements to make informed decisions about the business. The income statement, statement of retained earnings, balance sheet, and statement of cash flows, among other financial information, can be analyzed.

Hinterlassen Sie eine Antwort