返回 AI Hub
Skill#valuation#DCF#model
DCF 快速估值模型
可在任意 AI 对话中完成的逐步现金流折现估值工作流。
by Capital Deck Team421 点赞1.2k 复制
DCF Quick Model
Step 1 — Estimate FCF Base Use the trailing 3-year average FCF as your starting point. If FCF is negative or erratic, use owner earnings (net income + D&A – capex – working capital change) or normalized EBITDA – capex. Step 2 — Project Growth Scenarios Model 3 scenarios over 5 years: • Bear: FCF grows at 0–3% (or declines) • Base: FCF grows at the company's LT revenue growth estimate – 2% • Bull: FCF grows at the high end of analyst consensus Step 3 — Discount Rate (WACC) WACC = Risk-free rate (10Y UST) + Beta × Equity Risk Premium + Size premium Rule of thumb: 8% for large-cap, 10–12% for mid/small-cap. Step 4 — Terminal Value TV = FCF_year5 × (1 + g) / (WACC − g) Use g = 2–3% (roughly in line with long-run nominal GDP growth). Step 5 — Intrinsic Value per Share PV = Σ[FCF_t / (1+WACC)^t] + TV / (1+WACC)^5 Intrinsic value = PV / diluted share count. Step 6 — Margin of Safety Buy only at ≥25% discount to base-case IV. Report: Bear IV / Base IV / Bull IV per share with the key assumption driving the spread.