Horizontal analysis evaluates performance trends, while vertical analysis allows benchmarking to industry averages. Smith’s 2021 study revealed that companies employing both techniques reduced financial discrepancies by over 30% compared to relying on just one. This article provides an in-depth overview of horizontal and vertical analysis, explaining the key differences, formulas, and benefits of each technique. Given below is a horizontal analysis in excel of a comparative income statement (i.e. year 1 – base, year 2, and year 3). As it is majorly carried out on a single time period, Vertical analysis is also known as static analysis.
Income Statement and Balance Sheet Assumptions
This method is useful for identifying trends and changes in horizontal analysis formula a company’s financial performance. These examples demonstrate how horizontal analysis enables us to identify trends and patterns in various financial metrics. By analyzing changes in revenue, expenses, and assets over time, companies can make informed decisions and better understand their financial performance.
- Through horizontal analysis, we can observe that while the absolute increase in net income remained the same ($20,000), the rate of growth slowed down in the third year compared to the second year.
- This way, companies willfully maneuver and change their growth and profitability trends to their advantage.
- However, it is difficult to establish a definitive trend based on only two or three periods of data.
- From a general view, it could be seen that the company made considerable growth in its income between the years.
- In the event that revenue was Rs. 100,000 in 2019 and Rs. 150,000 in 2020, the absolute change is Rs. 50,000; that is, Rs. 150,000 – Rs. 100,000.
Example 1: Revenue Analysis for Company A
One essential technique in financial analysis https://www.bookstime.com/articles/what-are-income-statement-accounts is horizontal analysis, which allows you to analyze and interpret changes in financial statement data over time. In this guide, we will provide you with a comprehensive understanding of horizontal analysis, its significance, and how to conduct it effectively. Horizontal analysis of Wipro’s financial statements over two years provides insights into the company’s changing financial performance. While revenues declined slightly, Wipro improved gross profit margins and operational cash flows, indicating effective financial management despite a marginal drop in overall profitability. Just like horizontal analysis, vertical analysis shows useful information and insights about the health of your finances. Vertical analysis is conducted on financial statements over multiple periods and can be used to identify ratio changes.
Do you own a business?
A horizontal analysis of Jonick’s 2018 and 2019 income statements appears above. The amount and percentage differences for each line are listed in the final two columns, respectively. Every single item is compared with its counterpart in the alternative income statement.
One common method is using an inflation index or Consumer Price Index (CPI) to calculate the income statement inflation-adjusted values. Ratios such as earnings per share, return on assets, and return on equity are similarly invaluable. These ratios make problems related to the growth and profitability of a company evident and clear.
Horizontal Analysis and % of Base Year
Finance Strategists has an advertising relationship with some of the companies included on this website. We may earn a commission when you click on a link or make a purchase through the links on our site. All of our content is based on objective analysis, and the opinions are our own. The investor now needs to make a decision based on their analysis of the figures, as well as a comparison to other similar figures. Ratios such as asset turnover, inventory turnover, and receivables turnover are also important because they help analysts to fully gauge the performance of a business.
- For instance, Horizontal Analysis through direct comparison involves comparing your $4.5 million 2019 revenue with your 2020 revenue of $6 million.
- 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, in the case of the income statement, each line item might be calculated as a percentage of the revenue line.
- Ensure the accuracy and completeness of the data, as any inaccuracies can affect the analysis results.
- Horizontal analysis is the use of financial information over time to compare specific data between periods to spot trends.
Most horizontal analysis entail pulling quarterly or annual financial statements, though specific account balances can be pulled if you’re looking for a specific type of analysis. An absolute comparison involves comparing the amount of the same line of the item to its amounts in the other accounting periods. For example, comparing the accounts receivables of one year to those of the previous year. An example of horizontal analysis is comparing amounts from a company’s balance sheet or income statement over subsequent time periods to observe trends.
Horizontal Analysis using Balance Sheet
There were rises of more than 12% in all categories of property other than transport equipment. Either the data of the rest of the years is expressed as a percentage of the base year or an absolute comparison is performed. The revenue decreased by 0.8% from Rs 604,234 million in 2023 to Rs 599,327 million in 2024. The cost of revenues also declined by 2.2%, from Rs 430,297 million to Rs 420,998 million during the same period. However, the gross profit increased by 2.6% from Rs 173,937 million in 2023 to Rs 178,329 million in 2024.
Select the Time Period
The earliest period is usually used as the base period and the items on the statements for all later periods are compared with items on the statements of the base period. A company’s financial performance over the years is assessed and changes in different line items and ratios are analyzed. Horizontal analysis provides insight into the direction in which a company’s financial data is moving. For example, we perform a horizontal analysis on the balance sheet of Wipro, an Indian information technology company. The consolidated financial statement of Wipro Limited and its subsidiaries for the year ended March 31, 2024 is uploaded below.