
Horizontal Analysis of Financial Statements
Comparative financial statements reflect the profitability and financial status of the concern for various accounting years in a comparative manner. It should be kept in mind that the data of two or more financial years can be compared only when the accounting principles are the same for the respective years. Integrating these methodologies offers a holistic perspective, empowering stakeholders with insights into historical performance trends and the current composition of financial statements.
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 two analysis are helpful in getting a what is horizontal analysis clear picture of the financial health and performance of the company. Calculate the absolute change by deducting amount of base (previous) year from the amount of comparing year. Let us understand this analysis with the help of the following balance sheet. Drag down the cell with the formula to copy it to the other current assets line items. If you are a finance professional or you want to step into the field of finance then becoming a financial analyst is a great career option.
Create a Free Account and Ask Any Financial Question
Fortunately, tools like Google Sheets or Excel allow you to set up templates, so you can forget about the calculations and focus on analysis. Using Layer, you can also automate data flows and user management, so you can gather the data automatically, carry out the analysis, and automatically share results and reports with the right users. Looking to streamline your business financial modeling process with a prebuilt customizable template?
We need to perform a horizontal analysis of the income statement of this company. For example, the vertical analysis of an income statement results in every income statement amount being restated as a percent of net sales. If a company’s net sales were $2 million, they will be presented as 100% ($2 million divided by $2 million). If the cost of goods sold amount is $1 million, it will be presented as 50% ($1 million divided by sales of $2 million). Second, a variance analysis determines not only the dollar amount but the direction of change for a given general ledger account.
Company
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. Benchmark the company’s financial performance against industry averages or key competitors. This helps identify areas where the company excels or lags behind the industry norms. Looking at percentage or absolute changes across periods makes it easier to model different financial scenarios.
Comparative Income Statements With Horizontal Analysis
Indeed, sometimes companies change the way they break down their business segments to make the horizontal analysis of growth and profitability trends more difficult to detect. Horizontal analysis can be performed by comparing a recent year against the base year while identifying the growth trends between the time periods. The analysis can be performed in any four types of financial statement i.e. income statement, balance sheet, statement of cash flow, and statement of changes in equity. However, income statement and balance sheet are mostly used financial statement to do horizontal analysis (Lubatkin, 1983). Horizontal analysis of financial statements is a way to measure the changes in dollars or percentages for various accounting periods by drawing a comparison with the base year. When people having a career in finance state that the revenue has gone up by 10% for the quarter, it means that such individuals are talking about the outcome of horizontal analysis.
Compound Annual Growth Rate (CAGR)
- After the entire calculation process is done, and the financial information is verified, it is time to analyse the outcomes.
- 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.
- Horizontal analysis is the use of financial information over time to compare specific data between periods to spot trends.
- Our goal is to deliver the most understandable and comprehensive explanations of financial topics using simple writing complemented by helpful graphics and animation videos.
- The percentages reflects the changes that have occurred over successive periods.
Horizontal analysis is your go-to method for comparing financial data across multiple periods. It’s like having a time machine for your finances, where you can spot trends, identify anomalies, and essentially read between the lines of those monotonous columns of numbers. Horizontal analysis allows for the comparison of financial data over time, highlighting trends, patterns, and changes in performance. It helps identify growth or decline areas, assess strategies’ effectiveness, and make informed decisions. It enables businesses to track progress, evaluate financial stability, and identify potential risks or opportunities.
Example 2: Expense Analysis for Company B
One reason is that analysts can choose a base year where the company’s performance was poor and base their analysis on it. In this way, the current accounting period (or any other accounting period) can be made to appear better. For example, in Safeway Stores’ balance sheets, both sales and the cost of sales increased from 2018 to 2019. You can also use horizontal analysis in conjunction with both the balance sheet and the income statement. Vertical Analysis refers to the analysis of the financial statement in which each item of the statement of a particular financial year is analysed, by comparing it with a common item.
Commonly referred to as common-size financial statement analysis, this method expresses each line item as a percentage of a base figure, typically the total revenue or assets. Financial statement analysis is a crucial aspect of evaluating a company’s performance. Two common methods employed for this purpose are horizontal analysis, also known as trend analysis, and vertical analysis, termed common size financial statement analysis. In this guide related to horizontal and vertical analysis, we will help you learn about these analytical approaches, exploring their definitions, applications, and the key distinctions between them.
There are multiple financial analyst courses that you can take to improve your skill set. The Postgraduate Financial Analysis Program by Imarticus is an insightful course that will help you leverage your abilities in the field of finance. The percentage change is calculated by dividing the dollar change between the base year and the year in question by considering the line item. However, it involves three major steps that need to be followed with precision. Get started with premium spreadsheets and financial models customizable to your unique business needs to help you save time and streamline your processes. 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.