Financial Modeling & Forecasting

Question / Objective

Build a three-year forward revenue forecast for Apple Inc. under conservative, base, and optimistic growth scenarios, grounded in the company's actual five-year revenue and margin history.

Course-Concept Connection

• Financial Modeling
• FIN 3063 — Computer Modeling of Financial Applications
• FIN 3603 — Introduction to Data Science for Finance Majors

Data Sources

• SEC EDGAR — Apple Inc. 10-K filings, XBRL company facts (FY2021–FY2025 revenue & net income) — as of FY2021–FY2025 10-Ks, filed through Oct 31, 2025

Methodology

1. 1.Compiled AAPL's revenue, net income, and operating margin for fiscal years 2021 through 2025 directly from SEC EDGAR's XBRL company-facts data (the same figures underlying AAPL's 10-K filings).
2. 2.Calculated year-over-year revenue growth for each period, along with the 4-year compound annual growth rate (CAGR) across the full window.
3. 3.Defined three forward growth scenarios bracketing the historical range: Conservative (2.0%/yr), Base (3.3%/yr, approximating the trailing CAGR), and Optimistic (6.0%/yr).
4. 4.Projected revenue forward three fiscal years (FY2026–FY2028) under each scenario from the FY2025 actual base.

Assumptions

• Growth scenarios are constant-rate projections for simplicity — a full model would vary growth by product/segment and by year rather than applying one flat rate.
• The Base scenario approximates AAPL's trailing 4-year revenue CAGR (~3.3%); it is not an analyst consensus estimate or company guidance.
• Operating margin is assumed to hold roughly flat at recent levels in this simplified model; it is not separately forecasted by scenario.

Analysis

Key Findings

• AAPL's revenue growth has been uneven year to year over the last five years — from a 2.8% decline in FY2023 to 7.8% growth in FY2022 — despite a positive 3.3% trailing CAGR overall, which is the basis for the Base scenario.
• The three scenarios produce a meaningful spread by FY2028: roughly $441.6B (Conservative) to $495.7B (Optimistic) in projected revenue, versus $458.7B under the Base case — a reminder of how much forecast uncertainty compounds over a multi-year horizon.
• Operating margin expanded from 29.8% (FY2021) to 32.0% (FY2025) even through a revenue dip in FY2023, suggesting cost discipline and mix shift (e.g., services growth) have supported profitability independent of top-line growth.

Limitations

• • A flat constant-growth-rate forecast is a simplification; real forecasting would build up from segment- and product-level assumptions (iPhone, Services, Wearables, etc.) rather than one company-wide growth rate.
• • The scenarios are illustrative bands based on historical volatility, not probability-weighted or analyst-sourced forecasts.
• • This is not investment advice or a prediction of AAPL's actual future results.