A horizontal analysis can be particularly illuminating when it includes calculations of key ratios or margins, such as the current ratio, interest coverage ratio, gross margin, and/or net profit margin. In particular, take note of any measurements included in a company’s loan covenants, since it makes sense to monitor trends in these measurements that could lead to a covenant breach. This type of presentation makes it easier to spot declining margins and/or liquidity problems early and make corrections before they can become serious concerns. How detailed your initial financial statements are depends largely on the accounting software application you’re using. If you’re using an entry-level application, it’s likely you’ll need to use spreadsheets in order to complete the horizontal analysis. Although a change in accounting policy or the occurrence of a one-time event can impact horizontal analysis, these situations should also be disclosed in the footnotes to the financial statements, in keeping with the principle of consistency.
The analysis can be performed on any of the four financial statements; however, we’ll focus on the balance sheet and income statement,’ said Patty. That’s exactly why it’s called horizontal analysis – you compare the data from each period side by side to calculate your results. The value of horizontal analysis enables analysts to assess the company’s past performance and current financial position or growth and project the useful insights gained into the future. However, when using the analysis technique, the comparison (current) period can be made to appear uncommonly bad or good. It depends on the choice of the base year and the chosen accounting periods on which the analysis starts.
A horizontal analysis is a financial statement analysis technique that shows changes in the amounts of corresponding financial statement items over a period of time. It is a useful tool to evaluate trend data, but it has several limitations. To conduct a horizontal analysis of Goldman Sachs’ 2021 performance compared to 2020, first subtract the line items for the base year of 2020 from those for the target year of 2021. Then, divide the change by the base year amount and multiply by 100 to get the percentage change. Below are the results for the balance sheet and income statement, followed by an interpretation of the results. In other words, one can take year-on-year or quarter-on-quarter growth rates of all the items of the income statement or the balance sheet – based on the historical data.
- First, a direction comparison simply looks at the results from one period and comparing it to another.
- These formulas are used to evaluate trends which can either be quarter-on-quarter or year-on-year depending on the accounting period from which the data is sourced.
- 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.
- The increase in cost of goods sold (78% vs. 77% of sales) may warrant further investigation.
- It means that elements of financial statements, such as liabilities, assets, or expenses, may change between different accounting periods, leading to variation when account balances for each accounting period are sequentially compared.
To complete a horizontal analysis, the first step is to determine the base year, which is the year that will be used as the starting point for comparisons. The base year is typically the most recent year for which complete financial statements are available. Horizontal analysis of the income statement is usually in a two-year format, such as the one shown below, with a variance also shown that states the difference between the two years for each line item. An alternative format is to simply add as many years as will fit on the page, without showing a variance, so that you can see general changes by account over multiple years. A third format is to include a vertical analysis of each year in the report, so that each year shows expenses as a percentage of the total revenue in that year.
Horizontal Analysis Formula
When conducting a horizontal analysis, you are essentially comparing data from one period to another. This type of analysis is mostly used by investors, financial analysts, and business managers. However, anyone who is interested in the future of a company will be interested in conducting https://simple-accounting.org/ a trend analysis to determine its likely trajectory. This may include creditors, regulatory authorities, and industry observers like business journalists, among others. Liquidity ratios are needed to check if the company is liquid enough to settle its debts and pay back any liabilities.
As a company grows, it often becomes more difficult to sustain the same rate of growth, even if the company grows in pure dollar size. This percentage method is most useful when identifying changes over a longer period of time where there may be significant deviations from the base period to the current period. Horizontal analysis involves the calculation of percentage changes from one or more years over the base year dollar amount. The following two examples of horizontal analysis use an abbreviated income statement and balance sheet information where 2019 represents the base year.
However, the same results may be below par when the base year is changed to the same quarter for the previous year. To illustrate, consider an investor who wishes to determine Company ABC’s performance over the past year before investing. Assume that ABC reported a net income of $15 million in the base year, and total earnings of $65 million were retained.
Finish Your Free Account Setup
For demonstration purposes, the percentages have been rounded to the nearest whole number. In this article, you will learn about the horizontal analysis of financial statements and how to incorporate it into your company’s accounting practices. You will also learn how to do horizontal analysis using an income statement and a balance sheet. These formulas are used to evaluate trends which can either be quarter-on-quarter or year-on-year depending on the accounting period from which the data is sourced. For horizontal analysis, it’s best to take several years of historical data to gain useful insights into how a company is performing.
Investors can use horizontal analysis to determine the trends in a company’s financial position and performance over time to determine whether they want to invest in that company. However, investors should combine horizontal analysis with vertical analysis and other techniques to get a true picture of a company’s financial health and trajectory. On the other hand, horizontal analysis looks at amounts from the financial statements over a horizon of many years. Second, a variance analysis determines not only the dollar amount but the direction of change for a given general ledger account. Generally accepted accounting principles (GAAP) are based on the consistency and comparability of financial statements.
Key Metrics in Horizontal Analysis
First, decide which periods you will be comparing, carefully choosing comparable periods. For example, if your industry is seasonal, comparing consecutive quarters would provide misleading results. It would make more sense to compare the values for a specific quarter to the same quarter from past years. If you happen to choose a particularly bad time period for your base values, the values for your comparison period may look much better than they are. 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. Suppose we’re tasked with performing a horizontal analysis on a company’s financial performance from fiscal years ending in 2020 to 2021.
Operating and administrative expenses also increased slightly and interest expense increased by over 12%. Horizontal analysis of income statements also produces worthwhile information. In this discussion and analysis of operations, Safeway’s management noted that the increase was due to a growing trend toward mortgage financing. This type of analysis has the advantage of allowing for the visual identification of anomalies from long-term trends.
When the same accounting standards are used over the years, the financial statements of the company are easier to compare and trends are easily analyzed. The main difference between horizontal analysis and vertical analysis is that a horizontal analysis is used to judge performance over a number of reporting periods, while vertical analysis is used to compare numbers within one reporting period. For example, how to create and use a balance sheet for your business a horizontal analysis of the cost of insurance might list the cost on a quarterly basis for the past few years, while a vertical analysis would present it as a percentage of sales only for the current period. Given below is a horizontal analysis in excel of a comparative income statement (i.e. year 1 – base, year 2, and year 3). There’s a reason horizontal analysis is often referred to as trend analysis.
For example, net income could fall sharply in year 2, despite a rise in sales, due to a marked rise in the cost of goods sold, marketing expenses, administrative expenses, and/or depreciation expenses. In the final section, we’ll perform a horizontal analysis on our company’s historical balance sheet. We’ll start by inputting our historical income statement and balance sheet into an Excel spreadsheet. In particular, the specific metrics and any notable patterns or trends that were identified can be compared across different companies — ideally to close competitors operating in the same industry — in order to evaluate each finding in more detail. Over 1.8 million professionals use CFI to learn accounting, financial analysis, modeling and more.