Loading...
Loading...
Compare original and translation side by side
Unlevered Free Cash Flow (UFCF) =
EBIT × (1 - Tax Rate)
+ Depreciation & Amortization
- Capital Expenditures
- Change in Net Working Capital无杠杆自由现金流(UFCF) =
息税前利润(EBIT) × (1 - 税率)
+ 折旧与摊销
- 资本支出
- 净营运资本变动WACC = (E/V × Re) + (D/V × Rd × (1 - Tc))
Where:
E = Market value of equity
D = Market value of debt
V = E + D (total value)
Re = Cost of equity (CAPM: Rf + β × Market Risk Premium)
Rd = Cost of debt
Tc = Corporate tax rateWACC = (E/V × Re) + (D/V × Rd × (1 - Tc))
其中:
E = 股权市值
D = 债务市值
V = E + D(总价值)
Re = 股权成本(资本资产定价模型CAPM:Rf + β × 市场风险溢价)
Rd = 债务成本
Tc = 企业税率Re = Rf + β × (Rm - Rf)
Where:
Rf = Risk-free rate (10-year Treasury)
β = Stock beta (systematic risk)
Rm - Rf = Equity risk premium (typically 5-6%)Re = Rf + β × (Rm - Rf)
其中:
Rf = 无风险利率(10年期国债收益率)
β = 股票贝塔系数(系统性风险)
Rm - Rf = 股权风险溢价(通常为5-6%)Terminal Value = FCF(n+1) / (WACC - g)
Where:
FCF(n+1) = Final year FCF × (1 + g)
g = Terminal growth rate (typically 2-3%, ≤ GDP growth)终端价值 = FCF(n+1) / (WACC - g)
其中:
FCF(n+1) = 最后一年FCF × (1 + g)
g = 终端增长率(通常为2-3%,≤GDP增长率)Terminal Value = EBITDA(n) × Exit Multiple
Common multiples by sector:
- Technology: 10-15x
- Healthcare: 8-12x
- Consumer: 6-10x
- Industrial: 5-8x终端价值 = EBITDA(n) × 退出倍数
各行业常见倍数:
- 科技行业:10-15倍
- 医疗健康行业:8-12倍
- 消费行业:6-10倍
- 工业行业:5-8倍Enterprise Value = Σ [FCF(t) / (1 + WACC)^t] + [TV / (1 + WACC)^n]
Equity Value = Enterprise Value - Net Debt + Cash
Intrinsic Value per Share = Equity Value / Shares Outstanding企业价值 = Σ [FCF(t) / (1 + WACC)^t] + [TV / (1 + WACC)^n]
股权价值 = 企业价值 - 净债务 + 现金
每股内在价值 = 股权价值 / 已发行股份数量undefinedundefined| Metric | Value |
|---|---|
| Intrinsic Value per Share | $XX.XX |
| Current Market Price | $XX.XX |
| Upside/Downside | +/-XX% |
| Implied Recommendation | [Undervalued/Fair/Overvalued] |
| 指标 | 数值 |
|---|---|
| 每股内在价值 | $XX.XX |
| 当前市场价格 | $XX.XX |
| 上涨/下跌空间 | +/-XX% |
| 隐含结论 | [被低估/合理估值/被高估] |
| Year | Revenue ($M) | Growth % |
|---|---|---|
| Base (Current) | X,XXX | - |
| Year 1 | X,XXX | XX% |
| Year 2 | X,XXX | XX% |
| Year 3 | X,XXX | XX% |
| Year 4 | X,XXX | XX% |
| Year 5 | X,XXX | XX% |
| 年份 | 营收(百万美元) | 增长率% |
|---|---|---|
| 基准年(当前) | X,XXX | - |
| 第1年 | X,XXX | XX% |
| 第2年 | X,XXX | XX% |
| 第3年 | X,XXX | XX% |
| 第4年 | X,XXX | XX% |
| 第5年 | X,XXX | XX% |
| Metric | Year 1 | Year 5 | Rationale |
|---|---|---|---|
| EBITDA Margin | XX% | XX% | [Reason] |
| Capex/Revenue | XX% | XX% | [Reason] |
| D&A/Revenue | XX% | XX% | [Reason] |
| 指标 | 第1年 | 第5年 | 依据 |
|---|---|---|---|
| EBITDA利润率 | XX% | XX% | [理由] |
| 资本支出/营收 | XX% | XX% | [理由] |
| 折旧与摊销/营收 | XX% | XX% | [理由] |
| Component | Value | Source/Assumption |
|---|---|---|
| Risk-free Rate | X.X% | 10-Year Treasury |
| Beta | X.XX | Bloomberg/Calculated |
| Equity Risk Premium | X.X% | Historical average |
| Cost of Equity | XX.X% | CAPM |
| Cost of Debt | X.X% | Credit spread |
| Tax Rate | XX% | Effective rate |
| Debt/Total Capital | XX% | Current structure |
| WACC | X.X% |
| 组成部分 | 数值 | 来源/假设 |
|---|---|---|
| 无风险利率 | X.X% | 10年期国债收益率 |
| 贝塔系数 | X.XX | Bloomberg/计算得出 |
| 股权风险溢价 | X.X% | 历史平均值 |
| 股权成本 | XX.X% | CAPM |
| 债务成本 | X.X% | 信用利差 |
| 税率 | XX% | 实际税率 |
| 债务/总资本 | XX% | 当前资本结构 |
| WACC | X.X% |
| Method | Value ($M) | As % of EV |
|---|---|---|
| Gordon Growth (g=X%) | X,XXX | XX% |
| Exit Multiple (Xx EBITDA) | X,XXX | XX% |
| Selected | X,XXX | XX% |
| 方法 | 数值(百万美元) | 占企业价值比例% |
|---|---|---|
| 戈登增长法(g=X%) | X,XXX | XX% |
| 退出倍数法(X倍EBITDA) | X,XXX | XX% |
| 选定值 | X,XXX | XX% |
| ($M) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Terminal |
|---|---|---|---|---|---|---|
| Revenue | ||||||
| EBITDA | ||||||
| (-) D&A | ||||||
| EBIT | ||||||
| (-) Taxes | ||||||
| NOPAT | ||||||
| (+) D&A | ||||||
| (-) Capex | ||||||
| (-) ΔNWC | ||||||
| UFCF |
| (百万美元) | 第1年 | 第2年 | 第3年 | 第4年 | 第5年 | 终端阶段 |
|---|---|---|---|---|---|---|
| 营收 | ||||||
| EBITDA | ||||||
| (-)折旧与摊销 | ||||||
| EBIT | ||||||
| (-)税费 | ||||||
| 税后净营业利润(NOPAT) | ||||||
| (+)折旧与摊销 | ||||||
| (-)资本支出 | ||||||
| (-)净营运资本变动ΔNWC | ||||||
| 无杠杆自由现金流(UFCF) |
| Component | Value ($M) |
|---|---|
| PV of Projected FCFs | X,XXX |
| PV of Terminal Value | X,XXX |
| Enterprise Value | X,XXX |
| (-) Net Debt | (X,XXX) |
| (+) Cash | X,XXX |
| Equity Value | X,XXX |
| Shares Outstanding | XXX M |
| Value per Share | $XX.XX |
| 组成部分 | 数值(百万美元) |
|---|---|
| 预测FCF现值 | X,XXX |
| 终端价值现值 | X,XXX |
| 企业价值 | X,XXX |
| (-)净债务 | (X,XXX) |
| (+)现金 | X,XXX |
| 股权价值 | X,XXX |
| 已发行股份数量 | XXX 百万 |
| 每股价值 | $XX.XX |
| WACC ↓ / g → | 1.5% | 2.0% | 2.5% | 3.0% |
|---|---|---|---|---|
| 8.0% | $XX | $XX | $XX | $XX |
| 8.5% | $XX | $XX | $XX | $XX |
| 9.0% | $XX | $XX | $XX | $XX |
| 9.5% | $XX | $XX | $XX | $XX |
| 10.0% | $XX | $XX | $XX | $XX |
| WACC ↓ / g → | 1.5% | 2.0% | 2.5% | 3.0% |
|---|---|---|---|---|
| 8.0% | $XX | $XX | $XX | $XX |
| 8.5% | $XX | $XX | $XX | $XX |
| 9.0% | $XX | $XX | $XX | $XX |
| 9.5% | $XX | $XX | $XX | $XX |
| 10.0% | $XX | $XX | $XX | $XX |
| Assumption Change | Impact on Value |
|---|---|
| WACC +1% | -XX% |
| Terminal Growth +0.5% | +XX% |
| Revenue CAGR +2% | +XX% |
| EBITDA Margin +2% | +XX% |
| 假设变动 | 对估值的影响 |
|---|---|
| WACC +1% | -XX% |
| 终端增长率 +0.5% | +XX% |
| 营收复合增长率 +2% | +XX% |
| EBITDA利润率 +2% | +XX% |
---
---Build a DCF model for a SaaS company with:
- Current revenue: $500M
- Revenue growth: 25% declining to 15% over 5 years
- EBITDA margin: 20% improving to 30%
- Current stock price: $45
- Shares outstanding: 100M为一家SaaS公司构建DCF模型,参数如下:
- 当前营收:5亿美元
- 营收增长率:25%逐年下降至第5年的15%
- EBITDA利润率:20%逐年提升至30%
- 当前股价:45美元
- 已发行股份数量:1亿股