This tool uses one line item on the statement as a base against which to evaluate all other items in the same statement. This kind of analysis can be performed on many types of financial statements including the balance sheet and the income statement. Vertical analysis is an invaluable tool for simplifying financial statements and gaining valuable insights into a company’s financial performance. Acterys takes the effectiveness of vertical analysis to the next level with its advanced features and capabilities. By seamlessly integrating data from multiple sources, converting it into a suitable format, and offering dynamic reporting and visualization options, Acterys streamlines the vertical analysis process. Vertical analysis, also known as common-size analysis, is a financial analysis technique used to evaluate the relative proportions of different line items within a financial statement.

For finance and FP&A leaders, it’s a great way to quickly spot any problem areas or parts that need a bit more attention, making their job a bit simpler and more focused. Sync data, gain insights, and analyze business performance right in Excel, Google Sheets, or the Cube platform. For this example, I will carry out the analysis of the data vertical analysis formula reported for 2021. However, you can do this very quickly for multiple years, particularly if you’re using an income statement template. Look for items with a significant percentage of Total Assets, as these could represent areas of vulnerability or strength. Get instant access to video lessons taught by experienced investment bankers.

What Is Vertical Analysis?

Drag down the cell with the formula to copy it to the other revenue line items. Now, it’s time for the most important step – analyzing and interpreting the results for the period. The interpretation of these results is likely to be more accurate if you can compare them to previous results, as well as those of your competitors.

• Overall, the Vertical Analysis Calculator can be an essential financial tool that can help businesses and individuals gain valuable insights into their financial statements and make informed financial decisions.
• When completing a vertical analysis, you will use revenue or assets as a base.
• Previously, Stefan served as the Corporate Controller for Kodiak Cakes, a private equity owned, leading consumer packaged food company, and as a Controller for Skullcandy, a multinational headphone CPG.
• Further, when working with large data sets, we recommend cleaning up the data to improve the overall visual representation of the analysis.
• Apply vertical analysis of the given Statement of Profit & Loss of ABC Ltd. and interpret the same.

For example, if a specific expense item is consistently increasing as a percentage of revenue, it may indicate a need to optimize costs or explore opportunities for expense reduction. In this example, we calculated each line item’s percentage relative to net sales. This allows analyzing the composition of the income statement and understand the relative significance of each item in relation to the company’s revenue. Vertical analysis is a method of financial analysis where each line item is listed as a percentage of a base figure within the statement. By examining these vertical percentages, analysts can evaluate the cost structure, profitability ratios, and the relative significance of different line items within the income statement.

What is vertical analysis?

You can use vertical page analysis on income statement (income statement analysis) or balance sheet (balance sheet analysis). Utilizing tools in conjunction with vertical common size analysis significantly helps with financial reporting. It enables businesses to gain quick insights into historical performance by comparing current values to previous periods. You can then get a summary of how the business is operating and performing over time.

Horizontal analysis studies changes to variables over time, using historical data to predict future trends. Vertical analysis, however, studies the proportions of the total amount represented by the different variables during a single period. First, gather the balance sheet figures for each line item, such as cash, accounts receivable, fixed assets, etc. You can likely export the company’s financial statements from your accounting software to an Excel spreadsheet for easy analysis.

Conducting Vertical Analysis on Assets

Using actual dollar amounts would be ineffective when analyzing an entire industry, but the common-sized percentages of the vertical analysis solve that problem and make industry comparison possible. Doing a vertical analysis for multiple periods allows you to use the results for a detailed horizontal analysis, so you can look for potential patterns or trends in the way different line items contribute to the total. For example, by showing the various expense line items in the income statement as a percentage of sales, one can see how these are contributing to profit margins and whether profitability is improving over time. It thus becomes easier to compare the profitability of a company with its peers. Suppose we’ve been tasked with performing vertical analysis on a company’s financial performance in its latest fiscal year, 2021. The business will need to determine which line item they are comparing all items to within that statement and then calculate the percentage makeup.

Regardless of the placement, the more important factor is to ensure the analysis clearly shows which period it is reflecting.