5-Year EPS & Revenue Valuation Model
Intuitive 5-year valuation engine projecting Revenue, Net Margins, and EPS into Year 5 target prices with interlocked floor & ceiling scenario controls.
AAPL
Apple Inc.NASDAQConsumer Electronics & Software // Base: USD
Year-by-Year Progression (Years 1 to 5)
Annual compounding schedule of Projected Revenue, Net Income, and EPS.
| Valuation Metric | Bear Case | Base Case | Bull Case |
|---|---|---|---|
| Revenue Growth Rate YoY | 8.2% | 16.4% | 23.0% |
| Target Net Profit Margin | 23.5% | 27.6% | 31.7% |
| Exit P/E Multiple | 26x | 37x | 47x |
| Projected Year 5 Revenue | $692.29B | $997.50B | $1.31T |
| Projected Year 5 Net Income | $162.69B | $275.31B | $416.61B |
| Projected Year 5 EPS | $11.15 | $18.86 | $28.55 |
| Projected Year 5 Stock Price | $289.83 | $697.98 | $1,341.69 |
| Total 5-Year Return % | -10.9% | +114.7% | +312.7% |
| 5-Year Projected CAGR | -2.3%/yr | +16.5%/yr | +32.8%/yr |
Revenue & EPS Projections
Revenue compounds annually at the growth rate over 5 years. Target net profit margin is applied to determine Year 5 Net Income, which is divided by shares outstanding to yield projected Year 5 EPS.
Exit P/E Multiple & Price
Projected Year 5 Stock Price equals Year 5 EPS multiplied by the Terminal Exit P/E multiple. This represents the market valuation multiple expected at the end of the 5-year holding period.
Total Return & CAGR
CAGR represents the annualized compound return required from the current market price to reach the Year 5 target price. The model automatically ensures Bear ≤ Base ≤ Bull consistency.