DCF
DCF Valuation
Build an FCFF valuation from FY2025 and test how assumptions affect implied value.
Illustrative data for a fictional company — see Methodology.
Natural-Language Assumption Input
Deterministic parsing only — no LLM. Try: “Assume revenue grows 12% for five years, EBITDA margin reaches 24%, WACC is 10%, and terminal growth is 4%.”
Interactive Assumptions — recalculates immediately
15.0%
28.0%
25.0%
5.0%
8.0%
10.0%
3.0%
5 years
Enterprise Value
$2,949.5M
Equity Value
$3,019.5M
Implied Value / Share
$71.89
Terminal Value (PV)
$2,248.9M
FCFF Forecast Build
| Metric | FY2025 (Actual) | FY2026 (Forecast) | FY2027 (Forecast) | FY2028 (Forecast) | FY2029 (Forecast) | FY2030 (Forecast) |
|---|---|---|---|---|---|---|
| Revenue | $761.0M | $875.2M | $1,006.4M | $1,157.4M | $1,331.0M | $1,530.6M |
| EBITDA | $194.1M | $245.0M | $281.8M | $324.1M | $372.7M | $428.6M |
| D&A | $34.0M | $39.4M | $45.3M | $52.1M | $59.9M | $68.9M |
| EBIT | $160.1M | $205.7M | $236.5M | $272.0M | $312.8M | $359.7M |
| Taxes | $40.0M | $51.4M | $59.1M | $68.0M | $78.2M | $89.9M |
| NOPAT | $120.1M | $154.2M | $177.4M | $204.0M | $234.6M | $269.8M |
| D&A Add-back | $34.0M | $39.4M | $45.3M | $52.1M | $59.9M | $68.9M |
| Less: Capex | -$40.0M | -$43.8M | -$50.3M | -$57.9M | -$66.5M | -$76.5M |
| Less: Change in NWC | -$51.0M | -$9.1M | -$10.5M | -$12.1M | -$13.9M | -$16.0M |
| FCFF | $63.1M | $140.7M | $161.8M | $186.1M | $214.0M | $246.2M |
| Discount Factor | — | 0.909 | 0.826 | 0.751 | 0.683 | 0.621 |
| PV of FCFF | — | $127.9M | $133.8M | $139.8M | $146.2M | $152.8M |
DCF Sensitivity — Implied Value per Share
WACC (rows) x Terminal Growth (columns), centered on current assumptions
| WACC \ TGR | 2.0% | 2.5% | 3.0% | 3.5% | 4.0% |
|---|---|---|---|---|---|
| 8.0% | $87.13 | $93.66 | $101.49 | $111.07 | $123.03 |
| 9.0% | $74.33 | $78.89 | $84.21 | $90.51 | $98.05 |
| 10.0% | $64.74 | $68.08 | $71.89 | $76.29 | $81.42 |
| 11.0% | $57.31 | $59.83 | $62.67 | $65.89 | $69.56 |
| 12.0% | $51.37 | $53.33 | $55.51 | $57.94 | $60.68 |