The formula for percentage change is the absolute change divided by the base period value, multiplied by 100. Using the previous revenue example, the percentage change would be ($20,000 / $100,000) 100, resulting in a 20% increase. This percentage allows for easier comparison of growth or decline across different accounts, regardless of their absolute values. Two popular methods that cover different needs are horizontal and vertical analysis.
What is Horizontal Analysis? (A Beginner’s Guide)
Revenue growth is often the first metric examined, as it provides a clear picture of how a company’s sales are evolving over time. By comparing revenue figures from different periods, analysts can gauge whether the company is expanding its market presence or facing challenges in maintaining its sales levels. This metric is especially useful for identifying seasonal trends or the impact of market conditions on the company’s performance. In other words, one can take year-on-year or quarter-on-quarter growth rates of all the items of the income statement or the balance sheet – based on the historical data. 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.
- For this, we compare the absolute change ($) and percentage change (%) in all the line items from one period to the other.
- The base year serves as the reference point for comparisons, while the current year represents the year under scrutiny.
- From forecasting future performance to planning for different scenarios or managing costs, this method makes it easier to stay on top of changes.
- The horizontal analysis of the balance sheet examines changes in accounts such as cash, accounts receivable, inventory, fixed assets, accounts payable, and long-term debt.
- Market conditions shift, one-time contracts materialize, or cost-cutting measures create temporary margin improvements.
For companies involved in mergers and acquisitions, horizontal analysis becomes crucial for evaluating integration success, identifying synergy realization, and measuring strategic initiative performance. Horizontal analysis enables meaningful comparisons against industry peers, internal budgets, and historical performance. It’s one thing to grow revenue 10% in a booming market; it’s entirely different to achieve that same growth in a declining industry. Consistent equity growth through retained earnings suggests profitable operations and reinvestment, while equity dilution from new stock issuances might indicate growth financing or financial stress. Always use the same accounting periods, ensure data comes from comparable timeframes, and watch for seasonal businesses where quarter-to-quarter comparisons might mislead more than they illuminate.
Sometimes you may find horizontal analysis reports, saving you the calculations, but you can always calculate the percentage change yourself using publicly available financial data. Remember to choose companies with similar characteristics for useful comparisons. A notable problem with the horizontal analysis is that the compilation of financial information may vary over time. Now we’ll look at what trends we can observe over time with horizontal analysis. Vertical analysis is when we compare data in the same period (months, quarters, years). Gross profit margins are an example of vertical analysis where we determine our gross profit and divide it by our total revenue.
In the next section, you have step-by-step instructions on how to do horizontal analysis with examples using a balance sheet and an income statement. First, decide which periods you will be comparing, carefully choosing comparable periods. For example, if your industry is seasonal, comparing consecutive quarters would provide misleading results. It would make more sense to compare the values for a specific quarter to the same quarter from past years. 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. Select the base and comparison periods and the values for your chosen variable, then calculate the percentage change between them.
Company Valuation: How to Value Your Business?
An increase in assets might indicate growth and expansion, while a rise in liabilities could signal potential financial stress or increased borrowing. By analyzing these metrics together, a more comprehensive picture of the company’s financial health emerges. This helps in understanding how efficiently a company is managing its costs relative to its revenue.
- This method allows stakeholders to easily spot changes in key financial metrics such as revenue, expenses, and net income.
- Remember that no single ratio tells the whole story; it’s essential to consider them collectively and in context.
- Whether you’re an investor, a financial professional, or a business owner, mastering horizontal analysis can be a game-changer.
The growth came entirely from new store openings, suggesting potential market saturation or operational challenges at existing locations. The most effective financial analysis combines both methods, using vertical analysis to understand current state and horizontal analysis to track evolution and trends. Liability analysis through horizontal analysis exposes financial strategy and risk management. Short-term loan increases might indicate temporary cash flow challenges, while long-term debt growth could signal expansion financing or strategic acquisitions.
Many factors can affect business performance, and it’s impossible to predict the future with 100% accuracy. Horizontal analysis is the process of comparing financial data across multiple periods to measure changes over time. Whether you’re an individual investor, a portfolio manager, or part of an investment team, horizontal analysis provides valuable insights into what is horizontal analysis a company’s financial health and growth prospects. When conducting horizontal analysis on balance sheets, the analysis of asset trends is of paramount importance. Assets represent the resources owned by the company and can include cash, accounts receivable, inventory, and property, among others.
A horizontal analysis is used to see if any numbers are unusually high or low in comparison to the information for bracketing periods, which may then trigger a detailed investigation of the reason for the difference. It can also be used to project the amounts of various line items into the future. Horizontal analysis can help you identify trends in your data using your financial statements. Using Excel or Google Sheets is a great way to carry out a horizontal analysis of financial statements, especially if you use a pre-made template. If you use Layer, you can even automate parts of this process, including the control of data flows, calculations, and sharing the results. In horizontal analysis, the changes in specific financial statement values are expressed as a percentage and in U.S. dollars.