Horizontal vs Vertical Analysis of Financial Statements: Worked Examples
A practitioner-level walkthrough of horizontal (trend) analysis and vertical (common-size) analysis with full computations on a real-sized income statement and balance sheet, and how analysts combine the two for a complete picture.
A practitioner-level walkthrough of horizontal (trend) analysis and vertical (common-size) analysis with full computations on a real-sized income statement and balance sheet, and how analysts combine the two for a complete picture.
Learning Objectives
- ✓Compute horizontal (trend) percentages from multi-period financial statements.
- ✓Compute vertical (common-size) percentages by relating each line to a base.
- ✓Combine horizontal and vertical analysis for a fuller picture of financial trends.
1. Direct Answer: Two Lenses on the Same Statements
Horizontal analysis (also called trend analysis) compares financial statement line items across multiple periods, expressing each later period as a percentage change from a base period. Vertical analysis (also called common-size analysis) expresses each line item as a percentage of a base figure within the same period — total assets for balance sheet items, net sales for income statement items. Horizontal shows direction and rate of change over time; vertical shows composition within a period. Used together, they reveal both how the business is trending and how its structural mix is shifting. A growing top line that masks a deteriorating gross margin is invisible in horizontal alone but obvious when you overlay vertical analysis.
Key Points
- •Horizontal analysis: line items over time, percentage change from base period.
- •Vertical analysis: line items within a period, percentage of a base figure.
- •Use both for direction-of-change and composition-shift visibility.
2. Worked Example: Horizontal Analysis of an Income Statement
Three-year income statement excerpts (thousands): Year 1 base — Net Sales $1,000, COGS $620, Gross Profit $380, OpEx $250, Net Income $130. Year 2 — Net Sales $1,150, COGS $730, Gross Profit $420, OpEx $275, Net Income $145. Year 3 — Net Sales $1,322, COGS $870, Gross Profit $452, OpEx $310, Net Income $142. Horizontal percentages with Year 1 as base: Year 2 Net Sales = +15%, Year 3 Net Sales = +32.2%. Year 2 COGS = +17.7%, Year 3 COGS = +40.3%. Year 2 Gross Profit = +10.5%, Year 3 Gross Profit = +18.9%. Year 2 Net Income = +11.5%, Year 3 Net Income = +9.2%. The trend: revenue is growing 15-32% over the three-year window but COGS is growing FASTER than revenue, and net income growth is decelerating despite revenue acceleration. Cost discipline is slipping — exactly the signal horizontal analysis is designed to reveal.
Key Points
- •Percentage change = (current - base) / base × 100.
- •Watch for line items growing faster than revenue.
- •Net income growth deceleration despite revenue growth is a red flag.
3. Worked Example: Vertical Analysis of the Same Income Statement
Same three years, now expressing each line as a percentage of Net Sales: Year 1 — COGS 62.0%, Gross Profit 38.0%, OpEx 25.0%, Net Income 13.0%. Year 2 — COGS 63.5%, Gross Profit 36.5%, OpEx 23.9%, Net Income 12.6%. Year 3 — COGS 65.8%, Gross Profit 34.2%, OpEx 23.5%, Net Income 10.7%. The composition is shifting: COGS as a percentage of revenue rose from 62.0% to 65.8% (gross margin compression of 3.8 percentage points). Operating expenses as a percentage of sales actually IMPROVED (25.0% → 23.5%, suggesting operating leverage). Net income margin collapsed from 13.0% to 10.7% — a 230 basis point decline driven entirely by gross margin compression. Now we know the problem is in cost of goods sold, not in overhead.
Key Points
- •Income statement vertical: percentage of net sales.
- •Gross margin compression of 380 bps drives the entire profitability decline.
- •OpEx is actually being managed well — visible only through vertical analysis.
4. Worked Example: Vertical Analysis of a Balance Sheet
Balance sheet at year-end (Year 3, thousands): Cash $80, Receivables $320, Inventory $400, Total Current Assets $800; PP&E (net) $1,200; Total Assets $2,000. Current Liabilities $400, Long-term Debt $600, Total Liabilities $1,000; Common Stock $300, Retained Earnings $700, Total Equity $1,000. Vertical analysis with total assets as base: Cash 4.0%, Receivables 16.0%, Inventory 20.0%, Total Current Assets 40.0%, PP&E 60.0%, Total Assets 100%. Current Liabilities 20.0%, Long-term Debt 30.0%, Total Liabilities 50.0%, Common Stock 15.0%, Retained Earnings 35.0%, Total Equity 50.0%. Insight: 60% of assets are tied up in PP&E (capital-intensive business), 20% in inventory (potential working capital drag), and the balance sheet is 50/50 debt-to-equity. Peer comparison via common-size statements is the standard equity research workflow.
Key Points
- •Balance sheet vertical: percentage of total assets.
- •Liabilities and equity sum to 100% of total assets (balance sheet equation).
- •Common-size statements enable peer comparison across companies of different sizes.
5. How Analysts Combine Both Lenses
The combined workflow: (1) Horizontal analysis identifies what is growing fastest and slowest and where deceleration is occurring. (2) Vertical analysis identifies what items are taking up the most "room" in each period and how that mix is shifting. (3) The intersection is where actionable insights live: line items that are growing AND becoming a larger share of revenue/assets. In the worked examples, COGS was both growing fastest (horizontal) and taking a larger share (vertical) — a clear margin-compression problem. OpEx was growing modestly (horizontal) but shrinking as a share (vertical), indicating operating leverage. The full diagnostic uses both views in a single workbook with side-by-side columns: amount, year-over-year change, percent of base.
Key Points
- •Horizontal answers "what is changing." Vertical answers "what matters within this period."
- •Intersection items (growing fast AND taking a larger share) are the diagnostic priorities.
- •Standard equity research template: amount, YoY change, percent of base, side by side.
6. Connection to Ratio Analysis and Financial Statement Pillars
Horizontal and vertical analysis are the foundation under ratio analysis. Many "ratios" are simply vertical analysis percentages with different names: gross margin = gross profit / net sales (vertical analysis of the income statement); current ratio = current assets / current liabilities (a structural relationship within the balance sheet). Horizontal analysis tracks the same ratios across time. The ratio analysis cluster covers liquidity, leverage, and profitability ratios; horizontal and vertical analysis are how analysts read those ratios in context.
Key Points
- •Many ratios are vertical analysis percentages by another name.
- •Horizontal analysis tracks the same ratios across time.
- •Together they form the foundation of ratio analysis.
7. Using AccountingIQ for Analytical Procedures
Snap a photo of multi-period financial statements and AccountingIQ produces side-by-side horizontal trend percentages and vertical common-size percentages, flags line items where the two analyses point to the same problem (e.g., growing AND taking a larger share), and benchmarks the resulting margins against industry standards where available. For exam prep, the app generates analytical procedure questions at three difficulty levels.
Key Points
- •Side-by-side horizontal + vertical analysis output.
- •Cross-flagging when both lenses point to the same line item.
- •Industry benchmarking where data is available.
High-Yield Facts
- ★Horizontal analysis: percentage change from a base period for each line.
- ★Vertical analysis: percentage of a base figure within the period.
- ★Income statement vertical base = net sales. Balance sheet vertical base = total assets.
- ★Horizontal % change = (current - base) / base × 100.
- ★Common-size statements enable peer comparison.
Practice Questions
1. Year 1 sales $500, Year 2 sales $600, Year 3 sales $720. Compute horizontal percentages with Year 1 as base.
2. On a balance sheet with total assets $2,500, cash is $150. Vertical analysis percentage?
3. A company's SG&A as a percentage of revenue rose from 18% to 22% while revenue grew 15%. Diagnose.
FAQs
Common questions about this topic
The earliest period in the data range is the standard choice — usually the first year of a multi-year analysis. Some analysts use a recent normalized year (e.g., the last pre-pandemic year) when the earliest data is unrepresentative due to an unusual event. Whatever base you choose, document it and use it consistently across all line items.
Vertical analysis is a subset. Vertical analysis produces percentages that ARE ratios — e.g., gross margin is gross profit / net sales, which is the vertical analysis percentage of gross profit. Ratio analysis is broader and includes ratios that combine items across statements (e.g., return on assets = net income / total assets, which crosses the income statement and balance sheet).
When the base period is unrepresentative (e.g., a loss year as the base for net income creates a large percentage change that overstates trend significance), when the company is growing inorganically through acquisitions (apples-to-oranges comparison), or when accounting changes between periods make the line items not directly comparable. Always restate prior periods on the current period's accounting basis before computing trend percentages.
When the base period is negative and the current period is positive (or vice versa), the percentage change formula breaks down. Standard practice is to mark the cell "n/m" (not meaningful) and discuss the change in absolute terms instead — "operating income improved from a loss of $5 to a gain of $20."
Snap a photo of multi-period financial statements and AccountingIQ generates the horizontal and vertical analyses side by side, flags items where both analyses point to the same diagnostic conclusion (margin compression, operating deleverage), and provides industry benchmarks where available.
Not explicitly, but MD&A (Management Discussion & Analysis) sections of 10-Ks and 10-Qs are required to discuss year-over-year changes in revenues, costs, and key line items — which is fundamentally horizontal analysis in narrative form. Analysts construct their own common-size statements from the reported financial statements.