Horizontal Analysis
Year-over-year trend analysis — turning financial statement snapshots into a film.
Why This Matters
A company reports $500,000 in revenue this year. Is that good or bad?
You can't know without a reference point. But if they reported $400,000 last year, the picture sharpens: revenue grew 25%. That's meaningful.
Horizontal analysis compares financial statement data across periods — line by line — to identify trends, growth rates, and patterns of change.
It answers questions a single-period statement can't:
- Is the business growing or contracting?
- Are expenses rising faster than revenue?
- Is debt increasing while assets stay flat?
- Which areas improved? Which deteriorated?
Horizontal analysis turns financial statements from a snapshot into a film. You see not just where the company is, but where it's going.
What Is Horizontal Analysis?
Horizontal analysis (also called trend analysis) compares financial statement line items across two or more accounting periods to measure the dollar change and percentage change from period to period.
The comparison is "horizontal" because you read across the statement from one year to the next.
| Line Item | 2025 | 2026 | $ Change | % Change |
|---|---|---|---|---|
| Revenue | $400,000 | $500,000 | +$100,000 | +25.0% |
| COGS | $240,000 | $285,000 | +$45,000 | +18.8% |
| Gross Profit | $160,000 | $215,000 | +$55,000 | +34.4% |
| Operating Expenses | $90,000 | $110,000 | +$20,000 | +22.2% |
| Net Income | $70,000 | $105,000 | +$35,000 | +50.0% |
Each line gets two additional columns: the dollar change and the percentage change. Together, they tell the story of how that item evolved.
The Formulas
DOLLAR CHANGE
Current Year Amount − Base Year Amount = $ Change
PERCENTAGE CHANGE
$ Change ÷ Base Year Amount × 100 = % Change
Example
Revenue: $400,000 (2025) → $500,000 (2026)
$ Change: $500,000 − $400,000 = $100,000
% Change: $100,000 ÷ $400,000 × 100 = 25.0%
The base year is always the earlier (comparison) period — you measure change FROM the base year TO the current year.
Special Case: Sign Flip
Base year negative, current year positive (or vice versa): percentage change is misleading. Mark as NM (not meaningful) or describe in words.
Special Case: Zero Base
Base year is zero → division by zero. Percentage change is undefined. Mark as NM.
Horizontal Analysis: Income Statement
ABC Coffee Shop — Comparative Income Statement for years ended Dec 31, 2025 and 2026
| Line Item | 2025 | 2026 | $ Change | % Change |
|---|---|---|---|---|
| REVENUE | ||||
| Coffee Sales | $95,000 | $120,000 | +$25,000 | +26.3% |
| Food Sales | $38,000 | $50,000 | +$12,000 | +31.6% |
| Total Revenue | $133,000 | $170,000 | +$37,000 | +27.8% |
| Cost of Goods Sold | $65,000 | $80,000 | +$15,000 | +23.1% |
| Gross Profit | $68,000 | $90,000 | +$22,000 | +32.4% |
| OPERATING EXPENSES | ||||
| Salary Expense | $32,000 | $40,000 | +$8,000 | +25.0% |
| Rent Expense | $12,000 | $12,000 | $0 | 0.0% |
| Utilities | $3,800 | $4,000 | +$200 | +5.3% |
| Supplies | $2,500 | $3,000 | +$500 | +20.0% |
| Depreciation | $1,800 | $2,000 | +$200 | +11.1% |
| Marketing | $4,200 | $5,000 | +$800 | +19.0% |
| Total Op. Expenses | $56,300 | $66,000 | +$9,700 | +17.2% |
| Operating Income | $11,700 | $24,000 | +$12,300 | +105.1% |
| Interest Expense | ($2,400) | ($2,000) | +$400 | −16.7% |
| Net Income | $9,300 | $22,000 | +$12,700 | +136.6% |
Reading the Income Statement Analysis
This is where horizontal analysis earns its value — not in the calculation, but in the interpretation.
✓ Positive Signals
- Revenue +27.8% — strong top-line growth
- Gross profit +32.4% grew faster than revenue → margin improved (COGS only +23.1%)
- OpEx +17.2% grew slower than revenue → operating leverage
- Operating income nearly doubled (+105.1%)
- Interest expense −16.7% — debt being paid down
⚠ Questions to Investigate
- Salary +25.0% — roughly in line with revenue; monitor further increases
- Marketing +19.0% — below revenue growth. Is less marketing driving more revenue, or is growth coming from elsewhere?
The headline story: ABC Coffee Shop's profitability dramatically improved in 2026. Revenue grew 28%, but smart cost control and operating leverage produced net income growth of 137% — nearly 5× the revenue growth rate.
Horizontal Analysis: Balance Sheet
ABC Coffee Shop — Comparative Balance Sheet as of Dec 31, 2025 and 2026
| Line Item | 2025 | 2026 | $ Change | % Change |
|---|---|---|---|---|
| ASSETS — Current | ||||
| Cash | $31,000 | $45,000 | +$14,000 | +45.2% |
| Accounts Receivable | $5,500 | $8,000 | +$2,500 | +45.5% |
| Inventory | $9,500 | $12,000 | +$2,500 | +26.3% |
| Prepaid Expenses | $900 | $1,100 | +$200 | +22.2% |
| Total Current Assets | $46,900 | $66,100 | +$19,200 | +40.9% |
| Equipment (net) | $38,000 | $44,583 | +$6,583 | +17.3% |
| Total Assets | $84,900 | $110,683 | +$25,783 | +30.4% |
| LIABILITIES — Current | ||||
| Accounts Payable | $8,500 | $10,000 | +$1,500 | +17.6% |
| Wages Payable | $1,800 | $2,000 | +$200 | +11.1% |
| Other Current Liab. | $4,200 | $5,720 | +$1,520 | +36.2% |
| Total Current Liab. | $14,500 | $17,720 | +$3,220 | +22.2% |
| Bank Loan (LT) | $9,000 | $6,000 | −$3,000 | −33.3% |
| Total Liabilities | $23,500 | $23,720 | +$220 | +0.9% |
| EQUITY | ||||
| Owner's Capital | $50,000 | $50,000 | $0 | 0.0% |
| Retained Earnings | $11,400 | $36,963 | +$25,563 | +224.2% |
| Total Equity | $61,400 | $86,963 | +$25,563 | +41.6% |
| Total Liab. & Equity | $84,900 | $110,683 | +$25,783 | +30.4% |
Reading the Balance Sheet Analysis
✓ Positive Signals
- Cash +45.2% — strong cash accumulation
- Total assets +30.4% — growth funded by equity, not debt
- Total liabilities essentially flat (+0.9%)
- Bank loan −33.3% — actively paying down LT debt
- Retained earnings +224.2% — dramatic equity buildup
⚠ Questions to Investigate
- A/R +45.5% faster than revenue (+27.8%) — are collections slowing?
- Other current liabilities +36.2% — unearned revenue? Accrued expenses?
Balance sheet story: ABC is growing healthily — assets expanded 30%, debt stayed flat, equity soared. One yellow flag: receivables growing faster than revenue suggests a potential collection issue worth monitoring.
Multi-Year Trend Analysis
Horizontal analysis gets more powerful with more periods. Three or more years reveal sustained trends vs. one-time fluctuations.
| Metric | 2024 | 2025 | 2026 |
|---|---|---|---|
| Revenue | $110,000 | $133,000 | $170,000 |
| YoY Change | — | +20.9% | +27.8% ← Accelerating |
| Net Income | $6,500 | $9,300 | $22,000 |
| YoY Change | — | +43.1% | +136.6% ← Dramatically accelerating |
| Net Margin | 5.9% | 7.0% | 12.9% |
Multi-year insight: This isn't a one-year anomaly. Revenue growth has been accelerating, and the margin expansion from 5.9% → 7.0% → 12.9% is a powerful positive signal.
Index Analysis: Long-Run Trends
For periods longer than 2–3 years, index analysis converts all figures to a base-year index (base year = 100), making long-run trends easier to see.
INDEX ANALYSIS (Base Year 2023 = 100)
By 2026, revenue is 185% of 2023 levels (+85%). Net income is 338% (+238%) — dramatic improvement. Assets grew only 71% — profit grew much faster than the asset base.
Common Analytical Insights
| What You See | What It Might Mean |
|---|---|
| Revenue growing, COGS growing faster | Margin compression — pricing or cost problem |
| Revenue growing, expenses growing slower | Operating leverage — scalability improving |
| Revenue flat, net income growing | Cost-cutting or efficiency improvement |
| Assets growing, revenue flat | Capital not being deployed efficiently |
| Debt growing faster than assets | Increasing leverage risk |
| A/R growing faster than revenue | Collection slowdown — watch for bad debt |
| Cash declining despite profits | Cash tied up in assets, paying debt, or dividends |
| One-year spike in a line item | Look for non-recurring items (asset sales, lawsuits) |
Common Mistakes
Mistake 1: Treating % Change as the Full Story
❌ Wrong
"Marketing expense grew 100% — that's bad!"
✅ Right
Marketing grew from $500 → $1,000 while revenue grew $50,000 → $100,000. Always look at both dollar and percentage change.
Mistake 2: Comparing Across Very Different Companies
❌ Wrong
"ABC grew 28%; Mega Corp grew 5% — ABC is better managed."
✅ Right
Growth rates slow as companies get larger. 5% on $10B is $500M in new revenue. Compare within the same company, or peers of similar size/stage.
Mistake 3: Ignoring the Base Year When Chaining Percentages
❌ Wrong
"−50% then +50% means we're back where we started."
✅ Right
Start $100,000 → −50% = $50,000 → +50% = $75,000, not $100,000. Work from dollars when the base changes materially.
Key Takeaway
Horizontal analysis compares financial statement line items across multiple periods, calculating the dollar change and percentage change for each item. It transforms static statements into trend data — revealing whether the company is growing or contracting, whether costs are under control, and whether the balance sheet is getting stronger or weaker. The strongest insights come from comparing growth rates across related items. Always examine both dollar and percentage changes — and look for the story behind the numbers.
Test Your Understanding
See if you've got the basics down. Click each option and check your answer.
Question 1: Revenue was $200,000 last year and is $250,000 this year. What is the percentage change?
Question 2: Revenue grew 20%, but COGS grew 30%. What does this indicate?
Question 3: Which item would be calculated as "NM" (Not Meaningful) in horizontal analysis?
Question 4: Accounts Receivable grew 45% while revenue grew 28%. What is the most likely concern?
Question 5: True or False: A 50% decrease followed by a 50% increase returns a number to its original level.
Ready to Practice?
Prepare a two-year comparative income statement and balance sheet with full horizontal analysis — calculate dollar and percentage changes, then interpret what the trends reveal.
Try the Practice LabWhat's Next?
Next module: Vertical Analysis (Common-Size) — express every line as a percentage of a base figure to reveal the internal structure of financial statements.
Vertical Analysis
Common-size statements — every line as a % of a base
Financial Ratio Analysis Overview
Return to the four ratio categories