Horizontal & Vertical Analysis
Overview
- What you’ll learn: Horizontal (trend) analysis for comparing financial data across periods, vertical (common-size) analysis for expressing line items as percentages, and how these techniques complement ratio analysis.
- Prerequisites: Lesson 5 — Financial Statement Analysis: Ratios
- Estimated reading time: 15 minutes
Introduction
The Grand Historian records: A single year’s financial statements are like a single chapter of a dynasty’s history — informative but incomplete. The true narrative emerges only when you compare chapters: Is the empire growing or declining? Are expenses rising faster than revenue? Is the debt burden increasing or shrinking? Horizontal and vertical analysis are the historian’s tools for reading across time and within structure, revealing the trends and proportions that raw numbers alone cannot show.
Horizontal Analysis (Trend Analysis)
Horizontal analysis compares the same line item across two or more periods to identify trends. It answers: How much did this item change, and in what direction?
Calculating the Change
Two measures are used:
- Dollar change: Current Year Amount – Base Year Amount
- Percentage change: (Dollar Change / Base Year Amount) x 100
Example: Income Statement Horizontal Analysis
| Line Item | 2024 | 2025 | $ Change | % Change |
|---|---|---|---|---|
| Net Sales | $180,000 | $200,000 | +$20,000 | +11.1% |
| COGS | $105,000 | $120,000 | +$15,000 | +14.3% |
| Gross Profit | $75,000 | $80,000 | +$5,000 | +6.7% |
| Operating Expenses | $60,000 | $76,000 | +$16,000 | +26.7% |
| Net Income | $15,000 | $37,100 | +$22,100 | +147.3% |
Insights: Sales grew 11.1%, but COGS grew faster (14.3%), compressing the gross margin. Operating expenses surged 26.7%. Despite this, net income grew dramatically due to the addition of service revenue. An analyst would investigate what drove the expense increase.
Multi-Year Trend Analysis
For trends spanning three or more years, use a base year (typically the earliest year) and express all subsequent years as a percentage of the base. This reveals long-term trajectories:
| Year | Net Sales | Trend % |
|---|---|---|
| 2022 (base) | $150,000 | 100% |
| 2023 | $162,000 | 108% |
| 2024 | $180,000 | 120% |
| 2025 | $200,000 | 133% |
Vertical Analysis (Common-Size Statements)
Vertical analysis expresses each line item as a percentage of a base amount within the same period. It answers: What is the relative proportion of each item?
- Income statement: Each item as a % of Net Sales
- Balance sheet: Each item as a % of Total Assets
Example: Common-Size Income Statement
| Line Item | Amount | % of Net Sales |
|---|---|---|
| Net Sales | $200,000 | 100.0% |
| COGS | $120,000 | 60.0% |
| Gross Profit | $80,000 | 40.0% |
| Operating Expenses | $76,000 | 38.0% |
| Operating Income | $4,000 | 2.0% |
| Net Income | $37,100 | 18.6% |
Example: Common-Size Balance Sheet
| Line Item | Amount | % of Total Assets |
|---|---|---|
| Cash | $45,000 | 19.3% |
| Accounts Receivable | $32,000 | 13.7% |
| Inventory | $28,000 | 12.0% |
| PP&E (net) | $125,000 | 53.6% |
| Total Assets | $233,000 | 100.0% |
| Current Liabilities | $31,000 | 13.3% |
| Long-term Liabilities | $60,000 | 25.8% |
| Total Equity | $142,000 | 60.9% |
Combining Horizontal and Vertical Analysis
The most powerful analysis uses both methods together. Compare common-size percentages across years to see how the structure of the company has changed:
- Did COGS as a % of sales increase? Margin compression.
- Did debt as a % of assets increase? Growing leverage.
- Did cash as a % of assets decrease while receivables increased? Potential collection problems.
Key Takeaways
- Horizontal analysis compares data across periods (dollar and percentage changes) to identify trends.
- Vertical analysis expresses each item as a percentage of a base (Net Sales for income statement, Total Assets for balance sheet).
- Common-size statements enable comparison across companies of different sizes.
- The most powerful analysis combines horizontal, vertical, and ratio analysis together.
- Look for divergences: revenue growing slower than expenses, assets growing faster than revenue, or debt growing faster than equity.
What’s Next
In Lesson 7, you will learn to interpret financial statements holistically — reading annual reports, spotting red flags, and applying everything you have learned to real-world case analysis.
繁體中文
概述
- 學習目標:水平(趨勢)分析跨期比較財務數據、垂直(共同比)分析將項目表達為百分比。
- 先決條件:第 5 課——財務報表分析:比率
- 預計閱讀時間:15 分鐘
簡介
太史公曰:單一年度之財務報表如王朝歷史之單一章節——有益然不完整。真正之敘事唯有比較各章方能浮現:帝國在成長還是衰退?費用是否增長快於收入?
水平分析(趨勢分析)
比較相同項目在兩個或以上期間之變化。
- 金額變動:本年金額 – 基年金額
- 百分比變動:(金額變動 / 基年金額)x 100
範例
| 項目 | 2024 | 2025 | 變動% |
|---|---|---|---|
| 淨銷貨 | $180,000 | $200,000 | +11.1% |
| 銷貨成本 | $105,000 | $120,000 | +14.3% |
| 淨利 | $15,000 | $37,100 | +147.3% |
垂直分析(共同比報表)
將每一項目表達為同一期間基數之百分比。損益表以淨銷貨為基數;資產負債表以總資產為基數。
範例:共同比損益表
| 項目 | 金額 | 佔淨銷貨% |
|---|---|---|
| 淨銷貨 | $200,000 | 100.0% |
| 銷貨成本 | $120,000 | 60.0% |
| 毛利 | $80,000 | 40.0% |
| 淨利 | $37,100 | 18.6% |
重點摘要
- 水平分析跨期比較(金額與百分比變動)以識別趨勢。
- 垂直分析將各項目表達為基數之百分比。
- 共同比報表可跨不同規模公司比較。
- 最強大之分析結合水平、垂直及比率分析。
下一步
在第 7 課中,您將學習全面解讀財務報表。
日本語
概要
- 学習内容:水平(トレンド)分析と垂直(構成比)分析の方法と活用。
- 前提条件:レッスン5——財務比率分析
- 推定読了時間:15分
はじめに
太史公曰く:単年度の財務諸表は王朝の歴史の一章に過ぎない——有益ではあるが不完全である。真の物語は章を比較して初めて浮かび上がる。
水平分析(トレンド分析)
同じ項目を2期間以上にわたり比較し、傾向を識別する。
- 金額変動:当年度金額 − 基準年度金額
- 変動率:(金額変動 / 基準年度金額)× 100
垂直分析(構成比財務諸表)
各項目を同期間の基準額のパーセンテージで表す。損益計算書は純売上高、貸借対照表は総資産を基準とする。
例:構成比損益計算書
| 項目 | 金額 | 純売上高比 |
|---|---|---|
| 純売上高 | $200,000 | 100.0% |
| 売上原価 | $120,000 | 60.0% |
| 売上総利益 | $80,000 | 40.0% |
| 純利益 | $37,100 | 18.6% |
重要ポイント
- 水平分析は期間横断で比較し、傾向を識別する。
- 垂直分析は各項目を基準額のパーセンテージで表す。
- 構成比財務諸表は規模の異なる企業間の比較を可能にする。
- 最も強力な分析は水平・垂直・比率分析を組み合わせる。
次のステップ
レッスン7では、財務諸表を総合的に解釈する方法を学ぶ。