Skills

Valuation Model

Valuation methodology, absolute valuation with DCF / DDM / SOTP, relative valuation...

Install

npx skills add HKUDS/Vibe-Trading --skill valuation-model -g -a claude-code -y
Repository
HKUDS/Vibe-Trading37.4k
Category
Engineering
Updated
3d ago
License
MIT
Context cost
Mediumabout 2,190 tokens
Runs scripts
No, instructions only

What it does

Valuation methodology, absolute valuation with DCF / DDM / SOTP, relative valuation with PE-Band / PB-ROE / EV-EBITDA, sensitivity analysis, and valuation-trap detection.

Valuation Methodology

Overview

Systematic corporate valuation framework covering absolute valuation (DCF / DDM / SOTP) and relative valuation (PE / PB / EV-EBITDA), including sensitivity-analysis methods and a checklist for identifying valuation traps.

Absolute Valuation Methods

1. DCF (Discounted Cash Flow)

Core formulas:

Enterprise value = Σ FCF_t / (1+WACC)^t + TV / (1+WACC)^n
Equity value = enterprise value - net debt
Per-share value = equity value / total shares outstanding

Detailed steps:

Step 1: Forecast free cash flow (usually 5 years)

FCFF = EBIT × (1-tax rate) + depreciation & amortization - capex - increase in working capital

Simplified version:
FCFF ≈ operating cash flow - capex
YearRevenue (100m RMB)EBIT (100m RMB)FCFF (100m RMB)Growth
2026E1202418+15%
2027E1382821+15%
2028E1553124+12%
2029E1703426+10%
2030E1823628+7%

Step 2: Calculate WACC

WACC = E/(D+E) × Ke + D/(D+E) × Kd × (1-T)

Ke (cost of equity) = Rf + β × (Rm - Rf)
  - Rf: 10-year government bond yield (about 2.5% for China A-shares)
  - β: industry average or company beta (1.0-1.5)
  - Rm-Rf: equity risk premium (about 5-7% for China A-shares)

Kd: cost of debt (loan rate, about 4-5%)
T: income tax rate (25%)

Reference WACC ranges for China A-shares:

IndustryWACC RangeReference β
Consumer8-10%0.8-1.0
Technology10-13%1.2-1.5
Financials7-9%1.0-1.2
Cyclicals9-12%1.0-1.4
Utilities6-8%0.5-0.8

Step 3: Terminal Value

Perpetual-growth method: TV = FCF_n × (1+g) / (WACC - g)
  - g: perpetual growth rate (usually 2-3%, should not exceed GDP growth)

Exit-multiple method: TV = EBITDA_n × EV/EBITDA multiple
  - Reference the industry average or historical median
Read the whole SKILL.md on GitHub

More in Engineering