analytics_dcf_valuation
Build a discounted cash flow valuation model with sensitivity analysis to calculate company worth based on financial projections.
Instructions
Build comprehensive DCF (Discounted Cash Flow) valuation model with sensitivity analysis
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| projectionYears | No | Number of explicit forecast years | |
| discountRate | Yes | WACC - Weighted Average Cost of Capital (decimal, e.g., 0.12 for 12%) | |
| terminalGrowthRate | No | Long-term growth rate (decimal, e.g., 0.025 for 2.5%) | |
| initialRevenue | Yes | Base year revenue in currency units | |
| revenueCAGR | Yes | Revenue Compound Annual Growth Rate (decimal, e.g., 0.15 for 15%) | |
| terminalMargin | No | Terminal operating margin (decimal, e.g., 0.20 for 20%) | |
| terminalCapexRate | No | Terminal capex as % of revenue (decimal) | |
| terminalTaxRate | No | Terminal tax rate (decimal, e.g., 0.25 for 25%) | |
| worksheetName | No | DCF Valuation |