A founder pulled three years of income statements off her shelf and noticed something odd. Revenue had grown 41% over the period — she was proud of that — but net income had grown only 7%. The dollar figures alone never made the problem visible. When she converted each line to a percentage of revenue, the story snapped into focus: cost of goods sold had crept from 52% to 58%, payroll from 19% to 23%, and her operating margin had quietly collapsed from 14% to 8%. She had been working harder for less, and her bookkeeping never raised a flag, because the dollars were going up.
This is the value of common-size analysis — and its sibling, trend analysis. Both techniques replace the raw dollars on a financial statement with percentages, and once you do that, problems hiding inside growth become impossible to miss. They are the cheapest, fastest analytical tools an owner has, they require no new software, and they reveal more about a business in fifteen minutes than most monthly reports do in a year.
This guide walks through what each technique is, how to compute it on an income statement and a balance sheet, how to layer them together, where to find industry benchmarks, and the traps that fool people who only look at the dollar columns.
What Common-Size Analysis Actually Does
A common-size financial statement expresses every line as a percentage of a single base figure. The dollars are still there, but the percentages are what you read.
- Common-size income statement — every line is expressed as a percentage of total revenue. Revenue itself is 100%. Cost of goods sold, gross profit, every operating expense, interest, taxes, and net income all become percentages of the top line.
- Common-size balance sheet — every line is expressed as a percentage of total assets. Cash, accounts receivable, inventory, every fixed asset, every liability, and every equity account becomes a percentage of the asset base.
- Common-size cash flow statement — typically each line is expressed as a percentage of total revenue, though some analysts use cash from operations as the base.
The technique is sometimes called vertical analysis because you read down the column of a single period, comparing each line to a base on the same page. It strips out the effect of size — a $2M business and a $20M business can be put side by side and meaningfully compared.
What Trend Analysis Adds
If common-size analysis is the snapshot, trend analysis (often called horizontal analysis) is the movie. Trend analysis takes the same line item across multiple periods and asks how it has changed.
Two formats are common:
- Dollar and percentage change — for each line, show the dollar change and the percentage change from a base year. If revenue went from $1.0M to $1.18M, that's +$180,000 and +18%.
- Index numbers — pick a base year (usually the earliest), set every line in that year to 100, and express every subsequent year as an index. A line that grew from $1.0M to $1.45M over four years would index at 100 → 115 → 128 → 145.
Index numbers are the trick most owners have never been shown, and they're worth their weight in gold for spotting cost creep: a line that indexes faster than revenue is eating margin. If revenue indexes 100 → 141 over three years but cost of goods sold indexes 100 → 158, costs are outrunning sales, and the gap is your missing profit.
When you extend trend analysis across three to five years (or more), you also get a compound annual growth rate (CAGR), which smooths out the volatility of any single year. The formula is straightforward:
CAGR = (Ending value ÷ Beginning value)^(1 ÷ number of years) − 1
A business that grew from $1.0M to $1.45M over four years has a CAGR of about 9.7%. A simple average of the four annual growth rates would mislead you, because it ignores compounding.
A Worked Example: The Income Statement
Take a fictional café, "Maple & Oak Coffee," over three years. The raw numbers look encouraging:
| Line item | Year 1 | Year 2 | Year 3 |
|---|---|---|---|
| Revenue | $620,000 | $735,000 | $878,000 |
| Cost of goods sold | $192,000 | $242,500 | $307,300 |
| Gross profit | $428,000 | $492,500 | $570,700 |
| Wages and benefits | $186,000 | $235,200 | $298,500 |
| Rent and occupancy | $54,000 | $58,800 | $63,200 |
| Marketing | $14,000 | $18,400 | $22,000 |
| Other operating expenses | $48,000 | $58,800 | $74,600 |
| Operating income | $126,000 | $121,300 | $112,400 |
| Net income (after tax) | $94,500 | $90,975 | $84,300 |
Revenue grew 42% over three years — that looks great. But the dollars hide what's actually happening. Now convert the same statement to common-size form (each line as a percentage of revenue):
| Line item | Year 1 | Year 2 | Year 3 |
|---|---|---|---|
| Revenue | 100.0% | 100.0% | 100.0% |
| Cost of goods sold | 31.0% | 33.0% | 35.0% |
| Gross profit | 69.0% | 67.0% | 65.0% |
| Wages and benefits | 30.0% | 32.0% | 34.0% |
| Rent and occupancy | 8.7% | 8.0% | 7.2% |
| Marketing | 2.3% | 2.5% | 2.5% |
| Other operating expenses | 7.7% | 8.0% | 8.5% |
| Operating income | 20.3% | 16.5% | 12.8% |
| Net income (after tax) | 15.2% | 12.4% | 9.6% |
The story changes. The café is busier, but every dollar of revenue is producing less profit than it did three years ago. COGS climbed four percentage points, wages climbed four, "other operating" climbed a bit, and the only line shrinking as a percentage of revenue is rent — because rent is essentially fixed and revenue grew around it.
Layering on a trend (index) analysis for the same period sharpens the picture again. Set Year 1 = 100:
| Line item | Year 1 | Year 2 | Year 3 |
|---|---|---|---|
| Revenue | 100 | 119 | 142 |
| Cost of goods sold | 100 | 126 | 160 |
| Wages and benefits | 100 | 126 | 161 |
| Operating income | 100 | 96 | 89 |
| Net income | 100 | 96 | 89 |
Revenue indexed at 142, but COGS and wages indexed at 160 and 161 — each growing roughly 4½ percentage points faster than the top line per year. Net income actually went down. That is what cost creep looks like in numbers. The owner is busier but objectively poorer.
A Worked Example: The Balance Sheet
The same logic applies to the balance sheet, using total assets as the base. Imagine the café's balance sheet over the same three years:
| Line item | Year 1 | Year 2 | Year 3 |
|---|---|---|---|
| Cash | 23.0% | 17.0% | 11.0% |
| Accounts receivable | 4.0% | 6.0% | 8.0% |
| Inventory | 14.0% | 18.0% | 22.0% |
| Property and equipment | 51.0% | 49.0% | 49.0% |
| Other assets | 8.0% | 10.0% | 10.0% |
| Total assets | 100.0% | 100.0% | 100.0% |
| Accounts payable | 9.0% | 12.0% | 16.0% |
| Short-term debt | 6.0% | 9.0% | 14.0% |
| Long-term debt | 24.0% | 27.0% | 31.0% |
| Total equity | 61.0% | 52.0% | 39.0% |
Three things jump out:
- Cash is collapsing as a share of assets — from 23% to 11%. The business is liquid on paper because dollars are still in the bank, but proportionally it's drying out.
- Inventory is bloating — from 14% to 22% of assets. The café is buying or holding more product than the sales pace justifies. This often shows up first on the balance sheet, weeks before COGS shows it on the income statement.
- Debt is replacing equity — the equity share has fallen from 61% to 39%, while short-term and long-term debt have both grown. The business is being financed by borrowing rather than retained earnings, because earnings have stalled (we already saw that on the income statement).
The two statements tell the same story from different angles, which is exactly what good analysis should do.
How to Build It in Practice
You don't need anything more than a spreadsheet to do this. The mechanics:
- Export three to five years of clean, comparable income statements and balance sheets. Comparability matters — if you changed your chart of accounts mid-period, you'll need to re-map historical periods to today's structure or your percentages will be apples to oranges.
- Build the common-size columns by dividing each line by the period's base (revenue for the income statement, total assets for the balance sheet). Format as percentages with one decimal place.
- Build the trend (index) columns by dividing each year's figure by the base-year figure and multiplying by 100.
- Stack the two views side by side, period over period. Highlight any line where the common-size percentage moves by more than ~1 percentage point year over year, or where the index diverges from the revenue index by more than ~10 points.
- Calculate CAGR for the lines that matter most — revenue, gross profit, operating income, headcount, units sold — and compare them against each other. Revenue CAGR > expense CAGR is healthy; the reverse is the warning siren.
This whole exercise takes an hour or two the first time you build the template, and twenty minutes per quarter to refresh after that. The cost-to-insight ratio is unbeatable.
Benchmarking Against Industry Peers
Common-size statements are the only practical way to compare a $1M business against a $50M competitor. Once both are in percentage form, the size difference disappears and the structural differences become visible.
A few realistic benchmarks by sector — these are rough industry ranges, not a substitute for true peer data:
- Pure-service businesses (consulting, agencies, professional services) — gross margins routinely above 60%, often above 70%. The big expense line is wages, not COGS.
- SaaS and software — gross margins of 70–85% are normal at scale; lower than that suggests heavy hosting/support cost or unusual cost-of-revenue capitalization.
- Specialty retail — gross margins of 35–50%, with rent and labor each running 10–20% of revenue.
- Restaurants and food service — gross margins typically 60–70% on food (so food cost runs 30–40% of revenue), but labor of 25–35% and rent of 6–10% push net margins into single digits.
- General contractors and construction — gross margins of 15–25%, net margins of 3–7%, with WIP and AR dominating the balance sheet.
- Wholesale distribution — gross margins of 15–30%, very inventory-heavy balance sheets.
When you benchmark, always compare within your own NAICS code and revenue band. A $2M restaurant has a very different structure from a $20M chain. Useful public sources include the IRS Statistics of Income tables (free, organized by industry), RMA Annual Statement Studies (subscription, used by banks for credit decisions), BizMiner and IBISWorld industry reports, and Dun & Bradstreet's key business ratios. For publicly traded peers, you can often pull five years of common-size statements directly from a competitor's 10-K filings.
If your percentages line up with the industry, you're operating "to type." If a single line is several points off, that is either a genuine strategic difference (a deliberate choice to spend more on, say, marketing) or an unintentional problem you didn't know you had.
What Common-Size Analysis Won't Tell You
A few important limits worth being honest about:
- It is a screen, not a diagnosis. A jump in COGS percentage tells you costs grew faster than revenue. It does not tell you whether the culprit is a vendor price increase, a product mix shift, theft, mis-recorded inventory, or your own price cuts. You still have to dig.
- Mix matters. If you sell a high-margin product alongside a low-margin product, a shift in which one sells more will change your common-size income statement without anything being wrong. Segment your analysis by product line or business unit when mix could be the driver.
- One-time items distort. A lawsuit settlement, a PPP forgiveness, a one-time bonus, or an inventory write-down will skew the percentages for the affected year. Always note non-recurring items so you don't read them as trends.
- The base figure can move. If revenue drops sharply, every expense percentage automatically rises even if dollars are flat. Always read the percentages alongside the dollar columns so you understand which side moved.
- Accounting policies matter. Capitalization vs. expensing decisions, depreciation methods, lease accounting (operating vs. finance), and revenue recognition all shape what the percentages look like. When you compare against a peer, verify they're on similar accounting policies.
A Practical Cadence for Owners
Most small and mid-sized businesses benefit from running this analysis quarterly, with a deeper review annually. A workable rhythm:
- Each month — review the latest income statement against the prior month and the same month a year ago, focused on the three or four lines that tend to drift (COGS percentage, payroll percentage, marketing percentage).
- Each quarter — refresh the full common-size and trend tables, looking at the trailing four quarters and the three prior fiscal years.
- Each year — run the deep review: build five-year common-size and trend tables, compute CAGRs for the top eight to ten lines, pull updated industry benchmarks, and write a one-page memo on what the percentages say about strategy.
This rhythm catches margin erosion early, makes pricing conversations objective rather than emotional, and gives you a defensible basis for the annual budget and any conversation with a banker, board member, or potential acquirer.
A Short Note on Bookkeeping
None of this analysis works if the underlying numbers are wrong, inconsistent, or arrive too late. Common-size and trend analysis assume that your chart of accounts is stable, that classifications are consistent across years, that the cutoff between periods is clean, and that you can pull comparable financials with a few clicks rather than a week of forensic work. Investing in disciplined monthly bookkeeping — closing the books on a fixed schedule, reconciling every balance sheet account, and resisting the urge to reclassify history — is what makes this kind of analysis possible at all.
Keep Your Financial Records Analysis-Ready from Day One
Common-size and trend analysis pay off only when your books are clean, consistent, and comparable across years. Beancount.io provides plain-text accounting that is transparent, version-controlled, and AI-ready — every change is auditable, every account roll-up is consistent, and your data is never trapped in a proprietary format. Get started for free and build a financial foundation that lets you actually read your business, year over year.