vertical analysis example

Let’s continue our analysis of ABC Manufacturing by applying vertical analysis to its balance sheet. For example, the amount of cash reported on the balance sheet on Dec. 31 of 2024, petty cash 2023, 2022, 2021, and 2020 will be expressed as a percentage of the Dec. 31, 2020, amount. It’s a horizontal merger because Disney and Pixar were both involved in the production of animated films. This vertical merger allowed Inditex to integrate fabric production with its fast-fashion retail operations. By doing so, Inditex could accelerate production cycles and better respond to changing fashion trends. At the time, PayPal was already the preferred payment option for many eBay users, so the merger streamlined transactions on the platform.

vertical analysis example

Select the Time Period

  • This allows for meaningful comparisons and identification of trends over time or across companies.
  • Specifically, when a company controls both the product creation and distribution process, it can adapt more quickly to customer feedback or market shifts.
  • Vertical analysis can account for businesses of different sizes or those with multiple departments and product lines, making cohort analysis and the process of comparing profitability much easier.
  • We can easily understand that the total expenses gradually increased from 43% to 52%, and the net income get reduced from 1st year to 2nd year.
  • In vertical analysis, each line item in the financial statement is expressed as a percentage of a base figure in the same period (for example, the total assets or gross sales).

One of its cons is that it doesn’t take into consideration absolute numbers; so if you are comparing two companies, looking at percentages will give a different result than absolute numbers. The balance sheet uses the total assets or liabilities as the starting point in the vertical analysis. In contrast, the income statement uses total revenue or sales as the starting point.

  • Most often, vertical analysis is used by management to find changes or variations in financial statement items of importance like individual asset accounts or asset groups.
  • The figure below shows the common-size calculations on the comparative income statements and comparative balance sheets for Mistborn Trading.
  • By using both vertical and horizontal analyses, businesses can gain a better understanding of their financial position and performance.
  • You can calculate the proportion of each line item from the total based on publicly available financial data.
  • We can see that the capital expenditures decreased as a percentage of operating cash flow slightly from the previous year, which may indicate a decrease in investments.
  • By converting figures into percentages, it normalizes financial data and makes it easier to identify trends, patterns, and areas of concern.
  • The cash flow statement is vital in assessing a company’s ability to generate cash and its cash management practices.

Understanding Financial Statements

vertical analysis example

What we don’t know, and what we can’t know from the vertical analysis, is why that is happening. First, we can see that the company’s marketing expenses increased not just in dollar terms, but also as a percentage of sales. This implies that the new money invested in marketing was not as effective in driving sales growth as in prior years. The following example shows ABC Company’s income statement over vertical analysis formula a three-year period.

Importance of Vertical Analysis in Financial Analysis

  • For instance, it might reveal that leasing costs for the company headquarters constitute 1.5% of total revenue.
  • What makes vertical analysis stand out from other financial and profitability analysis methods is its emphasis on relative relationships.
  • Vertical analysis proves to be an essential technique for evaluating the structural composition of financial statements and making informed financial decisions.
  • It helps in making smarter, strategic decisions by offering a clear view of a company’s financial situation.
  • While the US market performance improved, it underperformed the other regions for the year.

By converting each number by the sales number for the year, comparing the line items over the years is easy. We must also consider that there may be another factor responsible for the significant rise in total sales in year 3 – such as a robust economy driving significantly higher sales in this year. This may be due to higher demand or some other factor that needs to be investigated. As it gets more intricate, figuring out which data really matters—and what’s just noise or not relevant to your company’s goals—can be tricky. Tools like Google Sheets or Excel allow you to automate calculations, so you can focus on analysis.

Example of the Vertical Analysis Formula

  • Since these proportions are expressed as percentages, you can easily compare them to other time periods or other companies.
  • In the realm of finance, vertical analysis aids in comparing the composition of income and expenses over time or against industry peers.
  • To deepen your understanding of vertical analysis, let’s explore some practical examples that demonstrate its application in analyzing financial statements.
  • Cultural integration is a significant challenge in vertical mergers, as companies from different parts of the supply chain often have very different corporate cultures and operational approaches.
  • By doing this, we’ll build a new income statement that shows each account as a percentage of the sales for that year.
  • These elements are the ones that allow businesses to calculate different ratios and check if they are performing well or require improvement.

When used together, they offer a comprehensive view of the company’s financial health. By analyzing these ratios using vertical analysis, you can gain insights into a company’s cash flow management and capital allocation strategies. A vertical analysis is also the most effective way to compare a company’s financial statement to industry averages.

vertical analysis example

vertical analysis example

Moreover, duplicating functions in areas like administration or IT can https://www.bookstime.com/ lead to inefficiencies, further driving up expenses, particularly if eliminating redundant roles is difficult. A vertical merger is a merger between two or more companies that operate on different stages of the same supply chain. We hope that these examples of vertical analysis have helped provide you with a clear example of how to perform vertical analysis on your spreadsheet.

However, you can do this very quickly for multiple years, particularly if you’re using an income statement template. Once you know what time period to focus on, you need to choose the documents and values you want to analyze. For example, you could choose to study the contribution of each revenue stream to the total amount of revenue using the information from the balance sheet. Use the insights gained from the vertical analysis in your decision-making processes.