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
TableJSON 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 |