Investment Research & Financial Modeling

Forecast Model

Historical actuals (white) roll into a driver-based forecast (tinted). Select any line item to see its formula.

ActualForecast
Validation (5)
  • Unable to calculate: current share price must be positive.
  • Unable to calculate: shares outstanding must be positive.
  • Shares outstanding must be positive.
  • Unable to calculate: at least one comparable company is required.
  • Unable to calculate: shares outstanding must be positive.
Forecast horizon
5 years
Analyst assumption
Year 1 growth
7.0%
From 2026 actual revenue
Year 1 EBITDA margin
—
COGS and opex drivers
Tax rate
24.0%
Applied to positive pre-tax income

Forecast Assumptions

All values are analyst inputs

Assumption
Driver2027E2028E2029E2030E2031E
Revenue Growth %
COGS % of Revenue
Implied Gross Margin42.5%43.0%43.3%43.5%43.7%
Operating Expenses % of Revenue
Implied EBITDA Margin—————
D&A % of Revenue
Capex % of Revenue

Operating Forecast

Historical actuals vs. forecast years — all forecast values are calculated, never hard-coded

$ in millions2024A2025A2026A2027E2028E2029E2030E2031E
$0.0$0.0$0.0$0.0$0.0$0.0$0.0$0.0
———7.0%6.5%6.0%5.5%5.0%
$0.0$0.0$0.0$0.0$0.0$0.0$0.0$0.0
$0.0$0.0$0.0$0.0$0.0$0.0$0.0$0.0
$0.0$0.0$0.0$0.0$0.0$0.0$0.0$0.0
$0.0$0.0$0.0$0.0$0.0$0.0$0.0$0.0
————————
$0.0$0.0$0.0$0.0$0.0$0.0$0.0$0.0
$0.0$0.0$0.0$0.0$0.0$0.0$0.0$0.0
$0.0$0.0$0.0$0.0$0.0$0.0$0.0$0.0
$0.0$0.0$0.0$0.0$0.0$0.0$0.0$0.0
$0.0$0.0$0.0$0.0$0.0$0.0$0.0$0.0
$0.0$0.0$0.0$0.0$0.0$0.0$0.0$0.0
———$0.0$0.0$0.0$0.0$0.0
$0.0$0.0$0.0$0.0$0.0$0.0$0.0$0.0
$0.0$0.0$0.0$0.0$0.0$0.0$0.0$0.0
———$0.0$0.0$0.0$0.0$0.0
Formula — Revenue
Forecast Revenue = Prior Year Revenue × (1 + Revenue Growth Rate)