Vertical Analysis: Definition, Formula and Step-by-Step Examples

Vertical analysis is one of the most practical tools in financial statement analysis. It converts raw financial figures into proportions, making it possible to compare performance across different time periods and between companies of different sizes. A company with revenue of $10 million and a company with revenue of $1 billion can be compared on equal terms once their income statements are expressed as percentages of revenue.

This guide covers the definition, the formulas, a worked example with a full numerical table, a step-by-step Excel process, how to interpret results, and how to apply vertical analysis in practice.

Related: Financial Statement Analysis: The Complete Guide (With Step-by-Step Process)

Vertical financial analysis is a method where each line item in a financial statement is expressed as a percentage of a base figure. On the income statement, the base is total revenue. On the balance sheet, the base is total assets. The name ‘vertical’ comes from the direction of the comparison: you move vertically down the financial statement, expressing each item relative to the same base.

The result is a common size financial statement. Instead of showing that COGS was $5 million and operating expenses were $2 million, the common size income statement shows that COGS was 50% of revenue and operating expenses were 20% of revenue. Those proportions are directly comparable across periods and across companies, regardless of scale.

Vertical analysis is particularly valuable in industries where cost control is critical, such as manufacturing, distribution, and FMCG. When costs are expressed as a percentage of revenue, the relationship between cost structure and profitability becomes immediately visible.

For the income statement, the formula is:

For the balance sheet, the formula is:

Total revenue is fixed at 100% on the income statement. All other line items are expressed relative to it. Total assets is fixed at 100% on the balance sheet. An alternative for the liabilities and equity section is to use Total Liabilities and Equity as the denominator, which gives the same result since Total Assets = Total Liabilities + Equity.

Read: Balance Sheet Ratios: Key Metrics for Financial Health

To show how this works in practice, consider ACME Inc., a manufacturing business with quarterly revenue of $10 million.

Applying the income statement formula to each line item:

The vertical analysis immediately shows that COGS consumes 50% of every revenue dollar, leaving a gross margin of 50%. Operating expenses at 20% leave an operating margin of 30%. Interest at 3% and tax leave a net margin of 27%.

Applying the balance sheet formula with total assets of $20 million:

The balance sheet analysis shows that 30% of total assets are tied up in inventory and 35% in fixed assets, meaning 65% of the company’s resources are in assets that convert to cash slowly. Cash at 10% and receivables at 15% represent the liquid portion. This asset allocation picture is immediately useful for evaluating working capital management and capital efficiency.

Step 1: Set up your data. Enter financial statement line items in rows, with absolute values in column B and a blank column C for the vertical analysis percentages.

Step 2: Identify and fix the base figure. For the income statement, the base is total revenue. For the balance sheet, it is total assets. Lock the base figure cell reference in Excel using a dollar sign: if total revenue is in cell B2, write it as $B$2 so it does not move when you copy the formula down.

Step 3: Enter the formula. For the first line item, enter: =B3/$B$2*100. B3 is the line-item value; $B$2 is the fixed base figure; multiplying by 100 gives a percentage.

Step 4: Copy the formula down. Select the formula cell and copy it to all remaining rows. The absolute reference ($B$2) keeps the denominator fixed while the numerator adjusts to each row’s value automatically.

Step 5: Format the results. Display the percentages with one decimal place for readability. Remove the revenue row itself from the percentage column if it simply shows 100.0%, since it adds no information.

Step 6: Add a prior period column for comparison. Repeat the formula for the prior period in column D (or a parallel column) with the prior period base figure locked in the same way. Compare the percentage movements between current and prior period to identify structural changes. A COGS percentage moving from 48% to 52% in two years is a meaningful signal even when absolute revenue is growing.

Vertical analysis answers the question: what does the cost structure look like right now? Horizontal analysis answers: how has it changed? Together they provide a complete picture of both structure and trajectory. Use them together, alongside ratio analysis, for a comprehensive view of financial health.

Calculating the percentages is the straightforward part. Knowing what to do with them is where most analyses stop short.

Compare across your own periods first. The most informative comparison is always against the company’s own prior periods. A SG&A ratio rising from 18% to 23% over three years shows that overhead costs are growing faster than revenue. Whether this is a concern depends on what is driving the SG&A growth, but the signal is clear.

Then compare against industry benchmarks. A COGS ratio of 60% is healthy in grocery retail but indicates significant inefficiency in enterprise software. Use sector averages as the reference point for ‘normal’, then investigate any material deviation.

Indicative benchmark ranges by sector:

Flag unusual items before concluding. A one-time restructuring charge or asset write-down may inflate a single period’s expense ratios, making the vertical analysis look worse than the underlying business warrants. Always check for non-recurring items before treating a ratio movement as a structural signal.

1. Makes comparison easier. Expressing financial items as percentages removes the effect of scale. A $10 million company and a $1 billion company can be compared on the same basis once both are expressed as common size statements.
2. Reveals cost structure clearly. When every expense is shown as a percentage of revenue, the relationship between each cost line and overall profitability is immediately visible. Misaligned costs become apparent at a glance.
3. Enables benchmarking across companies and time. Common size percentages allow direct comparison regardless of revenue differences, making vertical analysis the primary tool for peer comparison and competitive benchmarking.
4. Supports decision-making. Managers can set clear cost targets expressed as percentages, such as capping operating expenses at 20% of revenue or targeting gross margin above 40%, and track performance against those targets using vertical analysis.
5. Simplifies communication to non-financial stakeholders. Telling a board that ‘marketing represents 14% of revenue, up from 11% two years ago’ is more accessible than presenting absolute figures that require size context to interpret.

1. No information about absolute size. Percentages do not convey scale. A COGS percentage of 50% at a $5 million company and a $500 million company looks identical, but the absolute implications are very different.
2. Single-period snapshot. Vertical analysis provides a snapshot of one period. It cannot reveal whether a ratio has been improving or deteriorating without a comparison to prior periods, which requires horizontal analysis as a complement.
3. One-time items distort the base. If the base figure (total revenue or total assets) includes a large non-recurring item, all percentages for that period become misleading. Adjusted figures should be used when material one-off items are present.
4. Does not account for external factors. Inflation, currency fluctuations, and economic cycles all affect both numerator and denominator without appearing explicitly in the analysis. A revenue increase that matches inflation exactly shows flat vertical analysis percentages despite real-terms stagnation.
5. Industry norms vary significantly. A gross margin that looks healthy in one sector may be a concern in another. Vertical analysis benchmarks always need to be sector-specific to produce meaningful conclusions.

Read: How to Choose the Right Revenue Forecasting Model for Your Company

The data collection and organisation step is typically the most time-consuming part of vertical analysis: extracting financial statements from ERP, ensuring period-end adjustments are applied correctly, and organising line items consistently before any formula is applied.

Vertical analysis makes budgets more realistic by grounding them in the actual cost structure of the business. Setting a marketing budget at 12% of revenue is more defensible than setting an absolute number, because the target scales automatically as revenue moves.

Heineken tracks costs as a percentage of revenue as part of its budgeting process. When the team noticed marketing costs had grown from approximately 15% to 19% of revenue over two years, they adjusted the forward budget to address the drift and set a target percentage for the planning period rather than an absolute spend ceiling.

Including vertical analysis in monthly or quarterly financial reviews makes it easier to track cost trends in real time rather than discovering structural shifts at year-end. A COGS percentage rising gradually over several quarters is visible in regular vertical analysis long before it becomes a crisis.

In 2022, Unilever used vertical analysis to identify that COGS was increasing as a percentage of revenue. This early detection allowed the company to adjust pricing and take targeted cost reduction actions in time to protect margins before the full impact of input cost inflation was absorbed.

Not all line items warrant the same attention in vertical analysis. Prioritise the metrics that most directly drive profitability: gross margin, operating margin, SG&A as a percentage of revenue, and COGS as a percentage of revenue. These four metrics together describe the cost structure and efficiency of the business more accurately than any individual line item.

Companies like Coca-Cola track these metrics as percentages of revenue in their regular reporting, allowing the finance team to spot quickly when any component drifts out of the target range.

Vertical analysis removes the scale difference between companies of different sizes, enabling direct peer comparison. Expressing Walmart’s and Target’s SG&A, gross margin, and net margin as percentages of revenue reveals competitive positioning in the cost structure far more clearly than comparing absolute figures.

This use case is particularly powerful in industries where peers publish annual reports with full income statement and balance sheet data. Building a common size benchmark table from three to five direct competitors gives a clear view of where the business sits in the competitive landscape.

Read: Common Size Financial Statement: What Is It and How to Prepare It

Vertical analysis becomes significantly more powerful when combined with scenario planning. When costs are expressed as percentages of revenue, it is straightforward to model what happens to those percentages under different revenue assumptions.

Ford uses vertical analysis combined with scenario planning to assess the margin impact when raw material costs, particularly steel and aluminium, increase as a percentage of revenue. The analysis shows at what input cost level margin targets are breached, enabling the procurement team to negotiate supplier contracts with specific cost thresholds in mind.

Vertical analysis is a simple but powerful technique. By converting financial statement line items into percentages of a base figure, it enables comparisons that absolute numbers cannot support: across time periods, across companies of different sizes, and against industry benchmarks.

The formula is straightforward. The interpretation is where the value is created. A COGS percentage that is rising over time, above sector benchmarks, or inconsistent with a competitor’s cost structure is a signal that requires investigation. Vertical analysis surfaces that signal. The investigation, the diagnosis, and the planning response are what the finance team brings to it.

Used together with horizontal analysis and ratio analysis, vertical analysis is one of the foundational techniques that converts financial statement data into the forward-looking insight that drives better decisions.