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. It might be that this is planned expenditure for future payroll growth, or maybe the revenue expected from the additional expenditure did not materialize, or possibly there has been a re-classification of expenditure between the different years. Either way it is important to identify the reason and correct the problem as necessary. A more useful horizontal analysis can be undertaken by setting one year as the base year, and then calculating each line item for the other years as a percentage of the base year.

Horizontal Analysis: Definition, Formula & Examples

The company reported a net income of $25 million and retained total earnings of $67 million in the current year. Mike Dion is a seasoned financial leader with over a decade of experience transforming numbers into actionable strategies that drive success. As a Senior FP&A professional, Mike has helped businesses—from Fortune 100 giants to scrappy startups—unlock tens of millions of dollars in value across industries like Entertainment and Telecom. His knack for identifying opportunities and solving complex financial problems has earned him a reputation as a trusted finance expert.

• In the end, horizontal analysis turns financial data into actionable insights.
• Another method of horizontal analysis is calculating the variance between multiple financial items in multiple financial statements and spanning multiple accounting periods.
• Strong cash flow from operations enables a company to reduce its dependence on external financing.
• Insert a column to the right of ‘2022’ and click on the cell corresponding to the first revenue line item.

Time Value of Money

However, you can do this quickly for multiple years, particularly if you’re interested in long-term trends. As in the prior step, we must calculate the dollar value of the year-over-year (YoY) variance and then divide the difference by the base year metric. Per usual, the importance of completing sufficient industry research cannot be overstated here. In each industry, market participants attempt to solve different problems and encounter various obstacles, resulting in financial performance that reflects a given industry’s state. By combining horizontal analysis with tools like FP&A software and scenario planning, companies can make decisions that are not just reactive but also forward-thinking.

Horizontal and vertical analysis

Trends or changes are measured by comparing the current year’s values against those of the base year. A percentage or an absolute comparison may be used in horizontal analysis. Horizontal analysis of the balance sheet tracks changes in assets, liabilities, and equity, giving you a picture of financial health over time.

For example, a company’s management may establish that the robust growth of revenues or the decline of the cost of goods sold as the cause for rising earnings per share. By exploring coverage ratios, interest coverage ratio, and cash flow-to-debt ratio, horizontal analysis can establish whether sufficient liquidity can service a company. Horizontal analysis can also be used to compare growth rates and profitability over a specific period across firms in the same industry. Therefore, analysts and investors can identify factors that drive a company’s financial growth over a period of time. They are also in a position to determine growth patterns and trends, such as seasonality.

By analyzing financial statements, your company accurately spots trends over time and identifies the mix of assets and liabilities it has to deal with within a certain period. Financial analysis helps you examine relationships between different financial items and determine efficient operations to manage them. The cash flow statement is also beneficial for horizontal analysis, in addition to the income statement and balance sheet.

• These percentages are considered common-size because they make businesses within industry comparable by taking out fluctuations for size.
• The latter two tend to go hand-in-hand because the most useful benchmark against which to compare recent performance is most often the preceding period.
• For example, in early November 2024, 48% of my students predicted that Chicago Bears quarterback Caleb Williams wouldn’t throw between 15 and 21 touchdowns during the 2024 NFL regular season.
• To calculate the percentage change, first select the base year and comparison year.
• For this technique to be used, at least two financial statements (of the same type) need to be in existence.
• Financial analysis helps you examine relationships between different financial items and determine efficient operations to manage them.

• In order to express the decimal amount in percentage form, the final step is to multiply the result by 100.
• Horizontal analysis is used to assess a sequence of financial statement data over a specified time frame.
• For example, a business may want to know how much inventory contributes to total assets.
• Consistency constraint here means that the same accounting methods and principles must be used each year since they remain constant over the years.
• Trend analysis examines the direction and magnitude of changes in financial metrics over an extended period.
• In this method, the earliest period is set as the base period and each subsequent period is compared to the base period.

The first step in horizontal analysis is horizontal analysis formula grabbing the company’s financial statements. We’re talking about the Income Statement and Balance Sheet—the bread and butter of financial reporting. Subscription-based bookkeeping services are transforming the way businesses manage their finances, offering predictable pricing, scalability, and automation-driven efficiency.

Analyzing Year-to-Year Changes

Percentage changes can be misleading when the base numbers are very small or if the changes don’t reflect meaningful growth. Explore the best Yahoo Finance API and its alternatives for Insurance Accounting automating financial data retrieval seamlessly. Pair horizontal analysis with these free DCF templates for stocks in Google Sheets to discover powerful valuation insights. The most common way to represent it is as a percentage increase over the identical line item in the base year. Zignalor