Based on historical data, a horizontal analysis interprets the change in financial statements over two or more accounting periods. It denotes the percentage change in the same line item of the next accounting period compared to the value of the baseline accounting period. It is a method that looks at a company’s performance over time, helping you measure how key metrics (like revenue, expenses, or net income) have changed from one period to the next.
- To further illustrate the practical application of horizontal analysis, let’s explore a few more examples that showcase its effectiveness in assessing financial performance and identifying trends.
- For example, you can use vertical analysis to compare a company’s net income from last year to its net income from this year as a percentage of revenue.
- I started my career in the industry at one of Canada’s largest REITs, where I honed my skills analyzing and facilitating over a billion dollars in commercial real estate deals.
- 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.
Example: Horizontal Analysis of a Cash Flow Statement
- The base year can be any period you choose; typically, this is year to year, quarter to quarter, or past trailing twelve months.
- The percentages are particularly noticeable when an account experiences an abrupt up or down Swing.
- If you’re looking for a comprehensive guide to horizontal analysis, you’ve come to the right place.
- For example, clearly the revenue is growing each year, however, the expenses, particularly the sales and marketing expenses are growing more rapidly, resulting in a reduction in the net income and net income % of the business.
- Horizontal analysis involves comparing line items in financial statements across consecutive periods, usually a recent year to a base year.
- Having identified a trend, the next step is to try and understand the reasons behind it by carrying out a more detailed investigation.
From 2021 to 2020, we’ll take the comparison year (2021) and subtract the corresponding amount recorded in the base year (2020). In order to express the decimal amount in percentage form, the final step is to multiply the result by 100.
Horizontal Analysis Formula
This blog post will discuss what horizontal analysis is, why it’s important, and how to perform it correctly. That’s when my team and I created Wisesheets, a tool designed to automate the stock data gathering process, with the ultimate goal of helping anyone quickly find good investment opportunities. I started my career in the industry at one of Canada’s largest REITs, where I honed my skills analyzing and facilitating over a billion dollars in commercial real estate deals. 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 https://www.pinterest.com/enstinemuki/everything-blogging-and-online-business/ for automating financial data retrieval seamlessly. Pair horizontal analysis with these free DCF templates for stocks in Google Sheets to discover powerful valuation insights.
Horizontal Analysis vs. Vertical Analysis: What is the Difference?
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. Analyzing a company’s financial statements investors and comparing company performance with other companies in the same industry helps analysts to make informed decisions about whether or not to invest in the company.
Remember to choose companies with similar characteristics for useful comparisons. The horizontal analysis evaluates trends Year over Year (YoY) or Quarter over Quarter (QoQ). If you are an investor considering investing in a company, only a year-end balance sheet or income statement would not be enough to judge how a company is doing. Better yet, you can see many years of balance sheets and income statements and compare them.