贴现现金流估值
- 作者仓库星标 26,823
- 作者仓库 dexter
- 领域
- 工程开发
- 作者声明的智能体
- 未找到明确声明;不据此推断已兼容或已测试
- 静态检查
- 88 / 100 · 启发式扫描,不代表运行安全
- 运行环境证据
- 未执行;当前没有隔离运行测试证据
- 作者 / 版本 / 许可证
- @virattt · 未声明许可证
- 上下文用量评级
- 低消耗
- 接入复杂程度
- 即装即用
- 是否需要外部接口密钥
- 不需要
- 兼容的系统
- 未声明(默认跨平台)
- 运行环境要求
- 未检出明确要求
- 检测到的文件与系统行为
-
- 只读
- 允许写入 / 修改
- 网络行为
- 仅限本地
- 安装命令数
- 无(仅作为资料)
需要注意: 未声明工具权限范围;实际权限由运行环境决定。
使用以下查询调用`get_financials`工具:
根据现金流历史计算 5 年 FCF CAGR。交叉验证:`free_cash_flow_growth`(同比)、`revenue_growth` 增长率选择:稳定的 FCF 历史→使用复合年增长率 10-20% 的折减率上限为 15%(持续较高的增长很少见)
使用公司事实中的`sector`从sector-wacc.md中选择适当的基本WACC范围。默认假设: 无风险利率:4% 股权风险溢价:5-6% 债务成本:税前 5-6%(按 30% 税率计算,税后约为 4%)
第 1-5 年:应用每年衰减 5% 的增长率(第 2-5 年将增长率乘以 0.95、0.90、0.85、0.80)。这反映了竞争动态。终端价值:使用戈登增长模型,终端增长率为 2.5%(GDP 代理)。
贴现所有自由现金流→企业价值总和→减去净债务→除以`outstanding_shares`即每股公允价值。
创建 3×3 矩阵:WACC(基础 ±1%)与终端增长(2.0%、2.5%、3.0%)。
在演示之前,请验证这些健全性检查: EV 比较:计算出的 EV 应在报告的 30% 范围内`enterprise_value` 如果偏差 >30%,则重新审视 WACC 或增长假设 最终价值比率:成熟公司的最终价值应为总 EV 的 50-80% 如果 >90%,增长率可能太高
提供结构化摘要,包括: 估值摘要:当前价格与公允价值、上行/下行百分比 关键输入表:所有假设及其来源 预测自由现金流表:使用现值的 5 年预测 敏感性矩阵:3×3 网格,变化 WACC (±1%) 和终端增长 (2.0%、2.5%、3.0%)
# DCF Valuation Skill
## Workflow Checklist
Copy and track progress:
```
DCF Analysis Progress:
- [ ] Step 1: Gather financial data
- [ ] Step 2: Calculate FCF growth rate
- [ ] Step 3: Estimate discount rate (WACC)
- [ ] Step 4: Project future cash flows (Years 1-5 + Terminal)
- [ ] Step 5: Calculate present value and fair value per share
- [ ] Step 6: Run sensitivity analysis
- [ ] Step 7: Validate results
- [ ] Step 8: Present results with caveats
```
## Step 1: Gather Financial Data
Call the `get_financials` tool with these queries:
### 1.1 Cash Flow History
**Query:** `"[TICKER] annual cash flow statements for the last 5 years"`
**Extract:** `free_cash_flow`, `net_cash_flow_from_operations`, `capital_expenditure`
**Fallback:** If `free_cash_flow` missing, calculate: `net_cash_flow_from_operations - capital_expenditure`
### 1.2 Financial Metrics
**Query:** `"[TICKER] financial metrics snapshot"`
**Extract:** `market_cap`, `enterprise_value`, `free_cash_flow_growth`, `revenue_growth`, `return_on_invested_capital`, `debt_to_equity`, `free_cash_flow_per_share`
### 1.3 Balance Sheet
**Query:** `"[TICKER] latest balance sheet"`
**Extract:** `total_debt`, `cash_and_equivalents`, `current_investments`, `outstanding_shares`
**Fallback:** If `current_investments` missing, use 0
### 1.4 Current Price
Call the `get_market_data` tool:
**Query:** `"[TICKER] price snapshot"`
**Extract:** `price`
### 1.5 Company Facts
Call the `get_financials` tool:
**Query:** `"[TICKER] company facts"`
**Extract:** `sector`, `industry`, `market_cap`
**Use:** Determine appropriate WACC range from [sector-wacc.md](sector-wacc.md)
## Step 2: Calculate FCF Growth Rate
Calculate 5-year FCF CAGR from cash flow history.
**Cross-validate with:** `free_cash_flow_growth` (YoY), `revenue_growth`
**Growth rate selection:**
- Stable FCF history → Use CAGR with 10-20% haircut
- **Cap at 15%** (sustained higher growth is rare)
## Step 3: Estimate Discount Rate (WACC)
**Use the `sector` from company facts** to select the appropriate base WACC range from [sector-wacc.md](sector-wacc.md).
**Default assumptions:**
- Risk-free rate: 4%
- Equity risk premium: 5-6%
- Cost of debt: 5-6% pre-tax (~4% after-tax at 30% tax rate)
Calculate WACC using `debt_to_equity` for capital structure weights.
**Reasonableness check:** WACC should be 2-4% below `return_on_invested_capital` for value-creating companies.
**Sector adjustments:** Apply adjustment factors from [sector-wacc.md](sector-wacc.md) based on company-specific characteristics.
## Step 4: Project Future Cash Flows
**Years 1-5:** Apply growth rate with 5% annual decay (multiply growth rate by 0.95, 0.90, 0.85, 0.80 for years 2-5). This reflects competitive dynamics.
**Terminal value:** Use Gordon Growth Model with 2.5% terminal growth (GDP proxy).
## Step 5: Calculate Present Value
Discount all FCFs → sum for Enterprise Value → subtract Net Debt → divide by `outstanding_shares` for fair value per share.
## Step 6: Sensitivity Analysis
Create 3×3 matrix: WACC (base ±1%) vs terminal growth (2.0%, 2.5%, 3.0%).
## Step 7: Validate Results
Before presenting, verify these sanity checks:
1. **EV comparison**: Calculated EV should be within 30% of reported `enterprise_value`
- If off by >30%, revisit WACC or growth assumptions
2. **Terminal value ratio**: Terminal value should be 50-80% of total EV for mature companies
- If >90%, growth rate may be too high
- If <40%, near-term projections may be aggressive
3. **Per-share cross-check**: Compare to `free_cash_flow_per_share × 15-25` as rough sanity check
If validation fails, reconsider assumptions before presenting results.
## Step 8: Output Format
Present a structured summary including:
1. **Valuation Summary**: Current price vs. fair value, upside/downside percentage
2. **Key Inputs Table**: All assumptions with their sources
3. **Projected FCF Table**: 5-year projections with present values
4. **Sensitivity Matrix**: 3×3 grid varying WACC (±1%) and terminal growth (2.0%, 2.5%, 3.0%)
5. **Caveats**: Standard DCF limitations plus company-specific risks
按说明文件中的顺序排列。
工作流程清单
第 1 步:收集财务数据
1.1 现金流历史
1.2 财务指标
1.3 资产负债表
文件/命令 -> get_financials · "[TICKER] annual cash flow statements for the last 5 years" · free_cash_flow · net_cash_flow_from_operations · capital_expenditure · net_cash_flow_from_operations - capital_expenditure · "[TICKER] financial metrics snapshot" · market_cap
内容校验值 -> f51a6cfa0f25
当前原文的自动摘译,尚未人工审校。
工作流程清单
复制并跟踪进度:
第 1 步:收集财务数据
使用以下查询调用
get_financials工具:1.1 现金流历史
查询:
"[TICKER] annual cash flow statements for the last 5 years"提取:free_cash_flow、net_cash_flow_from_operations、capital_expenditure回退:如果free_cash_flow缺失,则计算:net_cash_flow_from_operations - capital_expenditure1.2 财务指标
查询:
"[TICKER] financial metrics snapshot"提取:market_cap、enterprise_value、free_cash_flow_growth、revenue_growth、return_on_invested_capital、debt_to_equity、free_cash_flow_per_share1.3 资产负债表
查询:
"[TICKER] latest balance sheet"提取:total_debt、cash_and_equivalents、current_investments、outstanding_shares后备:如果current_investments缺失,则使用 0