What is Horizontal Analysis? Process, Formula, Examples

When combined, these insights provide a comprehensive view of a company’s financial health and potential for future success. Horizontal analysis of the cash flow statement helps you see how cash is being managed year over year. These metrics reveal consistent growth and profitability, which are key insights for investors evaluating Apple’s performance over time. 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.

Step 2 of 3

Horizontal analysis enables investors, analysts, and other stakeholders in the company to see how well the company is performing financially. Either the data of the rest of the years is expressed as a percentage of the base year or an absolute comparison is performed. If the comparison year is year 3, then we will input the net income of year 3 and compute the percentage change between year 3 and year 1 (base year).

What is financial statement analysis?

For information pertaining to the registration status of 11 Financial, please What is partnership accounting contact the state securities regulators for those states in which 11 Financial maintains a registration filing. Operating and administrative expenses also increased slightly and interest expense increased by over 12%. In percentage comparison, the increase or decrease in amounts is expressed as a percentage of the amount in the base year. For example, to find the growth rate of net sales for 2015, the formula is (Net Sales 2015 – Net Sales 2014) / Net Sales 2014.

Ask a Financial Professional Any Question

It helps you understand how efficiently a company is managing its costs and whether there are any notable changes in expense categories over time. Based on the horizontal analysis, we observe that Company B’s operating expenses have gradually increased over the three-year period. The growth rates of 10% and 9.09% indicate a consistent upward trend in the company’s expenses. Through horizontal analysis, we observe that Company A has experienced consistent revenue growth over the five-year period. The growth rates of 20%, 25%, 20%, and 11.11% indicate a positive trend in the company’s revenue generation. Analyzing the year-to-year changes helps identify long-term trends and patterns.

Since we do not have any further information about the segments, we will project the future sales of Colgate based on this available data. We will use the sales growth approach across segments to derive the forecasts. The investor may desire to understand how the firm has altered over time to decide. For example, if that Company XYZ’s net income was $10 million and retained earnings were $50 million at the start of its existence, as depicted by example. 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.

• Have you ever wondered how businesses gain valuable insights into their financial performance over time?
• By comparing data sets in this way, you can identify trends and patterns in your business performance.
• It enables analysts to identify trends and growth patterns by comparing changes in income statements, balance sheets, and other reports.
• Horizontal analysis is often referred to as trend analysis, but the latter term has broader applications and is not specific to financial statements.
• By applying these advanced techniques, you can refine your horizontal analysis and provide more accurate insights and recommendations to stakeholders.
• For this example, the analysis will be carried out on the data reported for 2021 and 2022.

From the horizontal analysis, we observe that Company C has experienced consistent growth in total assets over the four-year period. The growth rates of 10%, 9.09%, and 8.33% indicate a positive trend in the company’s asset accumulation. Trend analysis examines the direction and magnitude of changes in financial metrics over an extended period.

There are two primary methods for analysing trends from horizontal analysis. In order to calculate the absolute change, subtract the figure from the earlier period from the figure from the later period. 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. Using the variance analysis method, the variance or discrepancy between quantities is determined. According to the variance, the financial impact was advantageous due to the rise in revenue. Analysts are interested in observing positive trends and enhanced profit margins.

• Analyzing the year-to-year changes helps identify long-term trends and patterns.
• Horizontal analysis, or “time series analysis”, is oriented around identifying trends and patterns in the revenue growth profile, profit margins, and/or cyclicality (or seasonality) over a predetermined period.
• For this reason, it is imperative to exercise caution when formulating conclusions in the absence of additional information.
• Also, horizontal analysis alone may not provide a comprehensive understanding of a company’s financial health and requires additional analysis and context.
• This makes it easy to see how your company performs over time and identify trends or patterns.

However, the percentage increase in sales was greater than the percentage increase in the cost of sales. This increase in capital expenditures is also reflected on the liability side of the balance sheet. 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. Determining the percentage change is important because it links the degree of change to the actual amounts involved. In this way, percentage changes are better for comparative purposes with other firms than are actual dollar changes.

Double Entry Bookkeeping is here to provide you with free online information to help you learn and understand bookkeeping and introductory accounting. Chartered accountant Michael Brown is the founder and CEO of Double Entry Bookkeeping. He has worked as an accountant and consultant for more than 25 years and has built financial models for all types of industries.

Given below is a horizontal analysis in excel of a comparative income statement (i.e. year 1 – base, year 2, and year 3). Conceptually, the premise of horizontal analysis is that tracking a company’s financial performance in real time and comparing those figures to its past performance (and that of its industry peers) can be very practical. Benchmark the company’s financial performance against industry averages or key competitors.

By dividing the net difference by the base figure, the percentage change comes out to 25%. 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. Take the guesswork out of investing and start making decisions backed by data – and confidence. It’s the flashlight that cuts through the fog of financial data, showing you where the real opportunities (and risks) lie.

Horizontal analysis focuses on comparing absolute amounts and percentages across different time periods, typically over the course of years. This highlights increases or decreases in accounts on the financial statements. With a solid understanding of horizontal analysis applied to income statements and balance sheets, you’ll be well-prepared to make informed financial assessments and decisions. With dollar amount changes and percentage changes calculated, it’s time to analyze the trends and patterns within the data. Look for consistent patterns of growth, stability, or decline in key financial metrics. Additionally, consider examining the factors that may have contributed to these trends, such as changes in market conditions, company strategy, or industry dynamics.