Vertical Analysis Formula
Starting from the revenue line item, each line item on the income statement – if deemed appropriate – is divided by revenue (or the applicable core metric).
The formula to perform vertical analysis on the income statement, assuming the base figure is revenue, is as follows.
Vertical Analysis, Income Statement = Income Statement Line Item ÷ Revenue
In contrast, the process is practically the same for the balance sheet, but there is the added option of using “Total Liabilities” instead of “Total Assets”. But we’ll utilize the latter here, as that tends to be the more prevalent approach taken.
Vertical Analysis, Balance Sheet = Balance Sheet Line Item ÷ Total Assets
Vertical Analysis Calculator – Excel Template
We’ll now move to a modeling exercise, which you can access by filling out the form below.
Step 1. Historical Income Statement and Balance Sheet Data
Suppose we’ve been tasked with performing vertical analysis on a company’s financial performance in its latest fiscal year, 2021.
To start, the table below shows the company’s historical financial statements – the income statement and balance sheet – of our hypothetical company, which we’ll be using throughout our two-part exercise.
|Historical Income Statement
|Less: Interest Expense
|Less: Taxes (30%)
|Historical Balance Sheet
|Cash and Equivalents
|Total Current Assets
|Total Current Liabilities
Once the historical data from 2021 has been inputted into Excel, we must determine the base figure to use.
Here, we’ve chosen “Revenue” as the base figure for the common size income statement, followed by “Total Assets” for the common size balance sheet.
Step 2. Vertical Analysis of Income Statement
Percentage of Revenue Calculation
With our financial data presented in Excel, we can start to calculate the contribution percentages on either the side or below the income statement.
Regardless of the placement, the more important factor is to ensure the analysis clearly shows which period it is reflecting.
The placement is not much of a concern in our simple exercise, however, the analysis can become rather “crowded” given numerous periods.
So if we had multiple years of historical data, it is recommended to organize the percentage calculations into a single section on the far right or below the financials with the timing of the periods aligned.
In order to keep a complex model more dynamic and intuitive to the reader(s), it is generally a “best practice” to avoid creating separate columns in between each period.
Further, when working with large data sets, we recommend cleaning up the data to improve the overall visual representation of the analysis.
For example, some minor adjustments could be to remove the “Revenue (% Revenue)” line item since it is not necessary and offers no practical insights.
For each line item, we’ll divide the amount by the corresponding period’s revenue to arrive at our contribution percentages.
Because we entered our costs and expenses as negatives, i.e. to reflect that those items are cash outflows, we must place a negative sign in front when applicable, so that the percentage shown is a positive figure.
Of the takeaways from our common size income statement, the most important metrics are the following:
|Vertical Analysis of Income Statement
|Revenue (% Revenue)
|COGS (% Revenue)
|Gross Margin (%)
|SG&A (% Revenue)
|R&D (% Revenue)
|Operating Margin (%)
|Interest Expense (% Revenue)
|EBT Margin (%)
|Taxes (% Revenue)
|Net Profit Margin (%)
Step 3. Vertical Analysis of Balance Sheet
Percentage of Total Assets Calculation
We’ve now completed our vertical analysis for our company’s income statement and will move on to the balance sheet.
The process is virtually identical to our common size income statement, however, the base figure is “Total Assets” as opposed to “Revenue”.
Once we divide each balance sheet item by the “Total Assets” of $500 million, we are left with the following table.
The assets section is informative with regard to understanding which assets belonging to the company constitute the greatest percentage.
In our case, half of the company’s asset base comprises PP&E, with the rest coming from its current assets.
The sum of the current assets equals 50%, confirming our calculations thus far are correct.
On the liabilities and shareholders equity side, we’ve chosen the base figure to be total assets.
To reiterate from earlier, dividing by total assets is akin to dividing by the sum of liabilities and equity.
Since liabilities and equity represent a company’s funding sources – i.e. how the company obtained the funds to purchase its assets – this part of the analysis can be insightful for understanding where the company’s financing stems from.
For instance, we can see that our company’s long-term debt as a percentage of total assets is 17.0%. The metric we calculated is formally known as the “debt to asset ratio”, which is a ratio used to gauge a company’s solvency risk and the proportion of its resources (i.e. assets) funded by debt rather than equity.
| Vertical Analysis of Balance Sheet
|Cash and Equivalents (% Total Assets)
|Accounts Receivable (% Total Assets)
|Inventory (% Total Assets)
|Prepaid Expenses (% Total Assets)
|Total Current Assets (% Total Assets)
|PP&E, net (% Total Assets)
|Total Assets (% Total Assets)
|Accounts Payable (% Total Assets)
|Accrued Expenses (% Total Assets)
|Total Current Liabilities (% Total Assets)
|Long-Term Debt (% Total Assets)
|Total Liabilities (% Total Assets)
|Total Equity (% Total Assets)