Depending on the metrics you want to focus on, you will need different financial statements, like balance sheets, income statements, or cash-flow statements. To conduct horizontal analysis, collect financial statements prepared according to GAAP, determine comparison methods, calculate absolute and percentage changes between periods, and analyse trends. 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. For example, in the income statement, we can, based on historical data and trends, make assumptions about sales growth and then forecast the sales growth rates through the forecast periods. In horizontal analysis, the changes in specific items in financial statements i.e. net debt on the balance sheet or revenue on the income statement– are expressed as a percentage and in a specific currency – for example, the U.S. dollar. Vertical analysis expresses each line item on a company’s financial statements as a percentage of a base figure, whereas horizontal analysis is more about measuring the percentage change over a specified period.
Analyze & Compare Results
In this example the business is looking for trends over the three years from 2019 to 2021. By producing the horizontal analysis it is possible to monitor changes in each line item over time. 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. It empowers you to understand financial trends, make informed decisions, and assess the health of a bookkeeping business. Whether you’re an investor, a financial professional, or a business owner, mastering horizontal analysis can be a game-changer.
Collect Financial Statements
Horizontal Analysis measures a company’s operating performance by comparing its reported financial statements, i.e. the income statement and balance sheet, to the financial results filed in a base period. From the above examples, the horizontal analysis only pushes to present the changes in these different periods and offer companies or businesses easy pointers to the health of their financial growth and situations. However, more than two financial statements need to be compared to obtain more reliable results for proper financial analysis. The simplest way to carry out horizontal analysis is to list each accounting periods financial statements side by side. The example below shows the horizontal analysis of an income statement, but it can equally well apply to the horizontal analysis of a balance sheet. The analysis can be carried out on any of the financial statements but is usually performed on the balance sheet and income statement together with appropriate accounting ratios.
Example: Horizontal Analysis of an Income Statement
Anyone can use the horizontal analysis formula to uncover insights that go beyond surface-level stats. Drag down the cell with the formula to copy it to the other current assets line items. For this example, the analysis will be carried out on the data reported for 2021 and 2022. However, you can do this very quickly for multiple years, particularly if you’re interested in long-term trends. For this example, I will carry out the analysis of the data reported for 2021 and 2022. However, law firm chart of accounts you can do this quickly for multiple years, particularly if you’re interested in long-term trends.
Trends
While analyzing financial statements, horizontal analysis is used to analyze historical data from various accounting periods, such as ratios or line items. In a horizontal analysis, comparisons can be done using either absolute comparisons or percentage comparisons. In the latter case, the statistics from each succeeding period are expressed as a percentage of the baseline year’s total, with 100% serving as the baseline value. In the world of financial analysis, mastering advanced techniques and tools can take your horizontal analysis skills to the next level. These methods go beyond basic percentage changes and provide deeper insights into a company’s financial performance and trends.
- The investor now needs to make a decision based on their analysis of the figures, as well as a comparison to other similar figures.
- Some of the earliest documented uses of horizontal analysis date back to the 1920s and 1930s when accounting textbooks and publications began covering it as an important analytical approach.
- Explore the best Yahoo Finance API and its alternatives for automating financial data retrieval seamlessly.
- The percentages are particularly noticeable when an account experiences an abrupt up or down Swing.
- With your findings, you understand how much change you have in your revenue (increase or decrease) between the two periods in consideration and also spot changes in your COGS and net income.
- Unlike traditional bookkeeping, which relies on periodic updates, real-time bookkeeping ensures continuous transaction recording, automated reconciliation, and real-time financial reporting.
- Aggregated information compiled in financial statements may have changed over time, presenting businesses with a problem.
- Another limitation is that even minor absolute changes sometimes manifest as significant percentage adjustments in accounts with initially low balances.
- Insert a column to the right of ‘2022’ and click on the cell corresponding to the first line item.
We may earn a commission when you click on a link or make a purchase through the links on our site. All of our content is based on objective analysis, and the opinions are our own. The investor now needs to make a decision based on their analysis of the figures, as well as a comparison to other similar figures. Operating and administrative expenses also increased slightly and interest expense increased by over 12%. In this discussion and analysis of operations, Safeway’s management noted that the increase was due to a growing trend toward mortgage financing. In percentage comparison, the increase or decrease in amounts is expressed as a percentage of the amount in the base year.
- My journey from a finance-loving teenager to a tech entrepreneur has been a thrilling ride, full of surprises and lessons.
- By comparing financial results from prior periods with those from more recent periods, a company enhances its capacity to determine the direction and magnitude of account balance movements.
- In this second example, I will do a horizontal analysis of Company B’s current assets based on the annual balance sheets.
- Financial institutions and creditors rely on horizontal analysis to assess the creditworthiness of individuals and businesses.
- Horizontal analysis makes it easy to detect these changes and compare growth rates and profitability with other companies in the industry.