Horizontal & Vertical Analysis

Level: Intermediate Module: Financial Statements 3 min read Lesson 6 of 67

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では、財務諸表を総合的に解釈する方法を学ぶ。

You Missed