10-Year Free Cash Flow Projections(showing years 1, 3, 5, 7, 10)
| Year | Year 1 | Year 3 | Year 5 | Year 7 | Year 10 |
|---|
| Revenue | $1.3B | $1.5B | $1.8B | $1.9B | $2.1B |
| EBIT | $580M | $642M | $753M | $822M | $900M |
| Tax | $122M | $135M | $158M | $173M | $189M |
| NOPAT | $458M | $507M | $595M | $649M | $711M |
| + Depreciation | $341M | $377M | $443M | $483M | $529M |
| - Capex | $298M | $331M | $388M | $423M | $463M |
| - Δ NWC | $14M | $18M | $17M | $15M | $10M |
| Free Cash Flow | $486M | $536M | $633M | $694M | $766M |
| Discount Factor | 0.914 | 0.765 | 0.639 | 0.535 | 0.409 |
| Present Value | $445M | $410M | $404M | $371M | $313M |
FCF Formula: Free Cash Flow = NOPAT + Depreciation - Capex - Change in Net Working Capital
Sensitivity AnalysisPrice per Share
| WACC ↓ / Growth → | 3.12% | 3.62% | 4.12% | 4.62% | 5.12% |
|---|
| 7.36% | $139.55 | $154.41 | $173.85 | $200.40 | $238.80 |
| 8.36% | $111.53 | $120.26 | $131.04 | $144.71 | $162.60 |
| 9.36% | $93.11 | $98.68 | $105.32 | $113.35 | $123.28 |
| 10.36% | $80.26 | $84.03 | $88.40 | $93.53 | $99.65 |
| 11.36% | $70.91 | $73.56 | $76.59 | $80.06 | $84.09 |
How to read: This table shows how the valuation changes with different WACC (discount rate) and terminal growth rate assumptions. Green = undervalued, Red = overvalued.
Key Assumptions & Drivers✓ Using Analyst Consensus Estimates• Real Estate Sector
Growth Assumptions (Select Years)
Year 1 Revenue Growth5.45%
Year 3 Revenue Growth6.50%
Year 5 Revenue Growth5.30%
Year 7 Revenue Growth4.18%
Year 10 Revenue Growth2.50%
Terminal Growth Rate4.12%
Margin & Efficiency
EBIT Margin42.99%
Tax Rate21.00%
Capex / Revenue22.13%
NWC / Revenue19.53%
Key Drivers: Revenue growth, operating margin expansion, capex efficiency, and working capital management are the primary drivers of cash flow generation. Terminal value assumptions significantly impact final valuation.
Institutional-Grade Methodology
Actual Company Data: Revenue, EBIT, Capex, NWC, Tax Rate, Interest Expense, Beta
Market Assumptions: Risk-free: 4.5% (10Y), MRP: 4.5% (Damodaran 2026), Exit: 18x EV/EBITDA (S&P 500: 22x P/E)
This DCF model is for informational purposes only. Projections are based on assumptions that may not materialize. Past performance does not guarantee future results. Consult a financial advisor before making investment decisions.