A manager, on the other hand, is concerned with the day-to-day operations of the company, so he uses this evaluation technique to pinpoint areas for improvement. For instance, a manager might compare cost of goods sold and profit margin over a two or three-year span to see how efficient the company is becoming. 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.

Key Learning Points

Horizontal analysis is the comparison of historical financial information over a series of reporting periods. In the final section, we’ll perform a horizontal analysis on our company’s historical balance sheet. We’ll start by inputting our historical income statement and balance sheet into an Excel spreadsheet. In fact, there must be a bare minimum of at least data from two accounting periods for horizontal analysis to even be plausible.

Common Size Analysis of Financial Statements

• Horizontal analysis focuses on comparing absolute amounts and percentages across different time periods, typically over the course of years.
• Carrying out horizontal analysis of the income statement and balance sheet helps investors and creditors to determine the current financial position of a company.
• For example, a $1 million increase in General Motors’ cash balance is likely to represent a much smaller percentage increase than a corresponding $1 million increase in American Motors’ cash balance.
• Similarly, if a company’s operating expenses are higher than those of its competitors, it might highlight areas where efficiency improvements are needed.
• Using the variance analysis method, the variance or discrepancy between quantities is determined.
• First, a direction comparison simply looks at the results from one period and comparing it to another.

Look for major fluctuations that may indicate critical events or shifts in the company’s operations. If inflation has influenced the financial data, it is essential to adjust the figures to account for its impact. One common method is using an inflation index or Consumer Price Index (CPI) to calculate the inflation-adjusted values. 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 this example, I will carry out the analysis of the data reported for 2021 and 2022.

E-Commerce Profit and Loss Statement

Skip complex spreadsheet formulas and let the AI assistant handle trend analysis and forecasting automatically. With Sourcetable’s AI chatbot interface, analysts can perform complex horizontal analysis without spreadsheet expertise. The platform automatically generates insights, creates visualizations, and performs calculations unearned revenue based on natural language requests, making financial analysis more accessible and efficient. Simply upload your financial data or connect your database, then tell the AI what analysis you need.

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. For this, we compare the absolute change ($) and percentage change (%) in all the line items from one period to the other. One should ideally take three or more accounting periods/years to identify trends and how a company is performing from one year/accounting period to the next year/accounting period. Interpreting the results of horizontal analysis requires a nuanced understanding of both the numbers and https://www.bookstime.com/articles/tax-filings the broader context in which they exist.

• Looking to streamline your business financial modeling process with a prebuilt customizable template?
• By examining the historical data and calculating percentage changes, horizontal analysis helps in understanding the direction and magnitude of changes, enabling informed decision-making and strategic planning.
• However, the percentage increase in sales was greater than the percentage increase in the cost of sales.
• This approach reduces errors, improves accuracy, and allows analysts to focus on interpreting results rather than managing spreadsheet formulas and functions.
• Once you have gathered the necessary financial statements, the next step is to calculate the dollar amount changes for key financial metrics between the base year and the current year.
• In the same way, the absolute change is as described below if the cost of products sold was Rs. 60,000 in 2019 and Rs. 90,000 in 2020.
• The cash and cash equivalents as of March 31, 2024, were Rs 96,951 million compared to Rs 91,861 million as of March 31, 2023.

This article provides an in-depth overview of horizontal and vertical analysis, explaining the key differences, formulas, and benefits of each technique. Looking at percentage or absolute changes across periods makes it easier to model different financial scenarios. With horizontal analysis, companies can simulate how rising costs or economic downturns affect future performance. Vertical analysis focuses on a single period and expresses each line item as a percentage of a base figure, such as total revenue or assets. It’s great for assessing cost structures or understanding how individual components contribute to overall performance within one period. It can be revenue, COGS, expenses or any other financial ratio you want to track.

Before you can embark on a horizontal analysis journey, you need to gather the relevant financial statements. These typically include income statements, balance sheets, and cash flow statements for the years you wish to analyze. Ensure that the financial statements are accurate, complete, and horizontal analysis formula from a reliable source, as the quality of your analysis relies heavily on the integrity of the data. Horizontal analysis is a financial analysis technique that compares financial information over multiple periods to identify trends and changes. Horizontal analysis is used to assess a sequence of financial statement data over a specified time frame.

A significant increase in revenue, for instance, might initially seem positive, but it’s essential to examine whether this growth is sustainable. If the revenue spike is due to a one-time event, such as a large contract or seasonal demand, it may not indicate long-term growth. Similarly, a decline in operating expenses could be a sign of improved efficiency, but it might also result from cost-cutting measures that could impact future operations.