Having identified a trend, the next step is to try and understand the reasons behind it by carrying out a more detailed investigation. In the above example, some of the expenses were increasing at a much faster rate than the revenue resulting in a reduction in net income. Either way it is important to identify the reason and correct the problem as necessary. Both methods are complementary and offer unique insights into a company’s financial health. These metrics reveal consistent growth and profitability, which are key insights for investors evaluating Apple’s performance over time.

• Horizontal analysis is a versatile tool with a wide range of practical uses in various aspects of finance and business.
• A $10,000 increase in revenue is impressive for a small business, but negligible for a large corporation.
• An alternate method of performing horizontal analysis calculations is to simply calculate the percentage change between two years as shown in the following example.
• We will explore how ManufacturingCo, Inc. uses horizontal analysis for internal performance evaluation and regulatory compliance.
• This makes it easy to see how your company performs over time and identify trends or patterns.

Step 4: Document the Change Amount

• After determining the nominal changes, you then convert these into percentage changes.
• There are two primary methods for analysing trends from horizontal analysis.
• Now, let’s dive into the specifics of performing horizontal analysis on income statements.
• Broader macroeconomic conditions can have a significant impact on your company’s performance.
• It depends on the choice of the base year and the chosen accounting periods on which the analysis starts.
• Horizontal analysis of Wipro’s financial statements over two years provides insights into the company’s changing financial performance.
• It’s much less costly and more flexible than a full-time CFO, but can provide the same level of analytical depth and strategic guidance when you need it most.

He has been a manager and an auditor with Deloitte, a big 4 accountancy firm, and holds a https://www.bookstime.com/ degree from Loughborough University. Learn how to use the Stockhistory function in Excel to retrieve historical data quickly for horizontal analysis. Anyone can use the horizontal analysis formula to uncover insights that go beyond surface-level stats. By applying these advanced techniques, you can refine your horizontal analysis and provide more accurate insights and recommendations to stakeholders. This example demonstrates the calculator’s utility in providing quick and accurate assessments of financial performance changes.

Absolute Comparison

Horizontal analysis is also known as trend analysis where individuals compare the change in the financial statements of one accounting year with another. Just like the above comparative balance sheet, these balances obtained from income statements are collected from different periods; 2020 as the base year and 2021 as the comparison year. Trend analysis is the evaluation of financial performance based on a restatement of financial statement dollar amounts to percentages. Horizontal analysis and vertical analysis are two types of trend analyses. Both techniques provide valuable insights for financial analysis and decision-making, but they serve different purposes and offer distinct perspectives on a company’s financial performance.

• This visual makes it easy to see, at a glance, that while revenue grew by X%, expenses only grew by Y%—a positive sign.
• Horizontal analysis evaluates performance trends, while vertical analysis allows benchmarking to industry averages.
• And remember, horizontal analysis isn’t just about identifying trends—it’s about understanding the story your financial data is telling you.
• Operating expenses rose from $3.5 million to $4 million during the same period.
• Here, for the sake of illustration, we have shown the absolute change (in US$) and percentage change (%) of all line items in the income statement between year 1 and year 2 only.
• In order to improve the horizontal analysis accounting, a variance column could be added for each year showing the change in absolute amount between each year.
• Rather than comparing revenues from 2019, Horizontal Analysis still compares the revenues of 2020 to 2018 (the base year).

Data Visualization

The latter two recording transactions tend to go hand-in-hand because the most useful benchmark against which to compare recent performance is most often the preceding period. Learn how small businesses can handle bookkeeping effectively and scale faster with clean books. By subscribing you agree to our Privacy Policy and provide consent to receive updates from our company. Either way, you first need to gather the relevant data for the years you want to analyze. The 50% still represents a positive outcome from 2018 even though it still represents an overall decline in the growth of revenue. Thus, performing Horizontal Analysis helps in many ways, especially when we are planning to investment or buying a business.

• By looking at past performance, it can help assess growth rates, spot trends (by comparing changes from period to period), generate forecasts, or project the insights gained into the future.
• This allows a business to see what percentage of cash (the comparison line item) makes up total assets (the other line item) during the period.
• Horizontal analysis is used to improve and enhance these constraints during financial reporting.
• Balance sheet horizontal analysis reveals how companies deploy capital and manage financial risk over time.
• Vertical analysis compares line items within a statement in the current year.

AI Fundamentals Every Finance Pro Needs To Know

By looking at past performance, it can help assess growth rates, spot trends (by comparing changes from period to period), generate forecasts, horizontal analysis formula or project the insights gained into the future. Horizontal analysis can help evaluate a company’s financial standing or position vis-à-vis its competitors. Financial statement analysis can be used to evaluate a company’s liquidity, solvency, profitability, and overall financial position.