Model Validation: PASSED
14/14 tests passed
Revenue CAGR
4.0%
Avg Gross Margin
40.0%
Avg EBITDA Margin
20.0%
Equity Value (DCF)
$1,902,324
AI-Powered Model Modification
Describe changes in natural language (e.g., "Increase revenue growth to 6% for all years")
Base Revenue
The starting revenue used for all projections and scenario analysis
This model is using the default base revenue ($1,000,000). Update it with the actual revenue from your financial statements for accurate projections.
CA$1,000,000
Base year revenue for projections
Income Statement
| Line Item | 2026 | 2027 | 2028 | 2029 | 2030 |
|---|---|---|---|---|---|
| Revenue | $1,050,000 | $1,102,500 | $1,146,600 | $1,192,464 | $1,228,238 |
| Gross Profit | $420,000 | $441,000 | $458,640 | $476,986 | $491,295 |
| Gross Margin | 40.0% | 40.0% | 40.0% | 40.0% | 40.0% |
| EBITDA | $210,000 | $220,500 | $229,320 | $238,493 | $245,648 |
| EBITDA Margin | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% |
| EBIT | $174,750 | $179,738 | $182,825 | $186,035 | $187,049 |
| Net Income | $118,886 | $123,508 | $126,636 | $129,770 | $131,212 |