Vertical analysis is also called – analysis
What’s the other name for that spreadsheet trick that makes every number speak the same language?
If you’ve ever stared at a profit‑and‑loss statement and felt like you were decoding a secret cipher, you’re not alone. The numbers look right, but you can’t tell at a glance whether today’s $5,000 in sales is a big win or a tiny drop‑off. Worth adding: that’s where vertical analysis steps in, and—surprise! —it’s also called common‑size analysis It's one of those things that adds up. Surprisingly effective..
In practice, the two terms are interchangeable, but the nuance each brings can shape how you talk about financial statements, teach a class, or convince a boardroom. Let’s peel back the layers, see why it matters, and give you a toolbox you can actually use tomorrow.
What Is Vertical Analysis
Vertical analysis is a method of financial statement evaluation that expresses each line item as a percentage of a base figure within the same statement Worth keeping that in mind..
- On an income statement, the base is usually total revenue.
- On a balance sheet, the base is total assets (or total liabilities & equity).
The result? Every number is common‑size—you can compare apples to oranges, years to years, or even companies of different sizes without doing any extra math Worth keeping that in mind..
The “Common‑Size” Alias
Why the second name? Because the output is a common‑size statement. “Common‑size” just means “the same size” across the board. When you see a line that reads “Cost of Goods Sold – 45%,” you instantly know it’s 45 % of total sales, regardless of whether the company made $1 million or $1 billion.
A Quick Example
| Income Statement (USD) | Amount | % of Revenue |
|---|---|---|
| Revenue | 1,200,000 | 100% |
| Cost of Goods Sold | 720,000 | 60% |
| Gross Profit | 480,000 | 40% |
| Operating Expenses | 240,000 | 20% |
| Net Income | 120,000 | 10% |
Now you can see at a glance that the firm keeps 10 % of every dollar as profit. Even so, no need to remember that $120,000 was “only” 10 % of $1. 2 million—you’ve already done the division for you.
Why It Matters / Why People Care
The short version is: vertical analysis (or common‑size analysis) lets you normalize financial data.
Spot Trends Without the Noise
Imagine you’re tracking a startup that grew from $200 k to $2 M in revenue over three years. Raw numbers look impressive, but the expense percentages tell the real story. Day to day, if COGS dropped from 70 % to 55 %, that’s a sign of scaling efficiency. If operating expenses jumped from 15 % to 30 %, you might be over‑investing in sales or R&D It's one of those things that adds up. And it works..
Benchmark Competitors
Because percentages strip away size, you can line up your common‑size income statement next to a rival’s. Do they keep a tighter gross margin? Do they spend less on SG&A? Those answers drive strategic decisions—pricing, cost control, even merger talks It's one of those things that adds up..
Communicate With Non‑Finance Folks
Your CEO might not care about “$450,000 in depreciation.” She cares that depreciation is 8 % of revenue, leaving 92 % of sales to cover actual cash costs. Translating raw dollars into percentages makes the conversation less about numbers and more about business health Took long enough..
Easier for Investors
Analysts love common‑size statements. They feed them into valuation models, compare across industries, and spot red flags faster. If you ever need to pitch to VCs, having a clean vertical analysis ready shows you understand the fundamentals.
How It Works
Below is the step‑by‑step recipe for turning a regular financial statement into a vertical (common‑size) one It's one of those things that adds up..
1. Gather the Right Statement
- Income statement → use total revenue (or net sales) as the denominator.
- Balance sheet → use total assets (or total liabilities + equity) as the denominator.
2. Convert Each Line to a Percentage
Formula:
[ \text{Common‑size %} = \frac{\text{Line Item Value}}{\text{Base Figure}} \times 100 ]
Do this for every line. Spreadsheets make it painless—just drag the formula down.
3. Double‑Check the Totals
- Income statement percentages should add up to 100 % (or very close, rounding errors aside).
- Balance sheet percentages should also total 100 % for assets and for the combined liabilities + equity side.
If they don’t, you’ve likely missed a line or used the wrong base Small thing, real impact..
4. Create a Comparative Layout
Put multiple periods side‑by‑side, or line up your firm against a competitor. Highlight the biggest shifts—those are the story beats you’ll want to explain.
5. Interpret the Numbers
Ask yourself:
- Which costs are eating up the biggest slice?
- Are margins improving or eroding?
- Do asset allocations (cash vs. inventory vs. PP&E) make sense for the business model?
6. Use the Insights
Turn the findings into actions: cut a high‑percentage expense, renegotiate supplier terms, or reallocate cash into higher‑return assets.
Common Mistakes / What Most People Get Wrong
Mistake #1 – Using the Wrong Base
People sometimes divide every line by “total assets” on the income statement, or by “total revenue” on the balance sheet. Worth adding: that skews everything. Remember: income = revenue base, balance sheet = assets base.
Mistake #2 – Forgetting to Adjust for Non‑Operating Items
Interest expense, taxes, and one‑off gains can distort the picture if you’re trying to gauge operating efficiency. Some analysts create a pure operating common‑size statement that excludes those items Still holds up..
Mistake #3 – Ignoring Rounding Errors
If you see 99 % or 101 % total, don’t panic. Rounding each line to two decimals will cause a tiny drift. Just keep an eye on the magnitude; if it’s off by 5 % or more, you’ve got a real problem.
Mistake #4 – Treating Percentages as Static
Vertical analysis is a snapshot. Which means don’t assume a 30 % SG&A expense will stay that way forever. Always pair it with trend analysis (horizontal analysis) to see where it’s moving Worth knowing..
Mistake #5 – Over‑Comparing Across Industries
A software firm with 80 % gross margin looks great next to a manufacturing company with 30 % margin—until you remember their cost structures are fundamentally different. Use vertical analysis within comparable peer groups Simple, but easy to overlook. Turns out it matters..
Practical Tips / What Actually Works
-
Build a Template – Create a reusable Excel (or Google Sheets) template with rows for every typical line item and columns for “Amount” and “% of Base.” One click, and you’re ready for the next quarter Turns out it matters..
-
Color‑Code the Changes – Use conditional formatting: green for percentages that improve, red for those that worsen. Your brain picks up visual cues faster than numbers.
-
Add a “Trend” Row – Include a column that shows the % change from the prior period. That way you get both vertical (size) and horizontal (direction) insight in one view.
-
Combine With Ratio Analysis – Vertical analysis tells you how big each slice is; ratios tell you how efficiently those slices are used. Pair them for a full‑picture financial health check.
-
Tell a Story, Not Just a Table – When you present the common‑size statement, start with the headline (e.g., “Gross margin jumped from 38 % to 45 % after we switched suppliers”). Numbers are proof, but narrative drives action Small thing, real impact..
-
Keep an Archive – Save every vertical analysis you produce. Over five years you’ll have a gold mine of normalized data that can be used for forecasting, budgeting, and strategic planning.
-
Use It for Non‑Financial Statements – The concept works beyond finance. Take a marketing spend report and express each channel as a % of total spend. Suddenly you see that SEO is 55 % of the budget, while events are only 5 % Less friction, more output..
FAQ
Q: Is vertical analysis the same as ratio analysis?
A: Not exactly. Vertical analysis converts line items to percentages of a base figure, while ratio analysis compares two different numbers (e.g., current ratio = current assets ÷ current liabilities). Both are useful, but they answer different questions.
Q: Can I use vertical analysis on cash flow statements?
A: Yes. Use total cash inflows (or outflows) as the base, then express each cash flow component as a % of that total. It helps you see where cash is really coming from and going to.
Q: Do I need to adjust for seasonality?
A: Seasonal businesses should compare vertical analyses from the same quarter or month across years. Comparing Q1 to Q4 can mislead you because the base (revenue) fluctuates dramatically And that's really what it comes down to..
Q: How often should I run a vertical analysis?
A: At a minimum, each quarter when you receive fresh financial statements. Many CFOs do it monthly for tighter control.
Q: Is there a downside to using common‑size statements?
A: They hide absolute dollar magnitude. A 5 % profit margin on $10 million is $500 k—significant—while the same margin on $100 k is only $5 k. Always pair percentages with the underlying dollar amount Practical, not theoretical..
Vertical analysis—aka common‑size analysis—doesn’t magically fix a weak balance sheet, but it gives you a clear, level playing field to see where the real issues lie. Once you start looking at every line as a slice of the same pie, you’ll spot inefficiencies, benchmark smarter, and talk numbers in a language that anyone can understand Still holds up..
So the next time you open a financial statement, skip the raw totals and jump straight to the percentages. Your future self (and maybe your investors) will thank you Simple as that..
