Apple Inc.
Model against market
The past year of closing prices, with the implied value from this model drawn across it. The model line is flat because it is rebuilt from filings, not quoted.
Solid line: closing price. Dashed: implied value from this model, held at its published figure.
What the model is built on
Revenue and operating margin as reported. The growth rate and margin used in the projection come from these figures, not from an estimate.
Method
Intrinsic value derived from a 6-year Discounted Cash Flow model with mid-year convention. Projections driven by your assumption inputs; terminal value via Gordon Growth. Comps cross-check shown separately. For high-multiple growth stocks, a DCF typically prices in only fundamentals — market prices may reflect optionality (new products, markets, regulatory) that a DCF framework can't capture.
Assumptions come from the Consensus preset — peer-median operating margin, analyst-implied growth, and a 5.0% equity risk premium. The workbook contains every step, with formulas left live so the numbers can be traced or changed.
Figures
If the assumptions are wrong
The figure above is one answer from one set of inputs. Here the four drivers — growth, margin, discount rate and terminal growth — are varied together across ten thousand scenarios, correlated rather than independent, since a company growing faster tends to carry a higher discount rate and settle at a higher steady state. The result is a range, not a point.
10,000 draws · seed 763379888 · growth, margin, discount rate and terminal growth drawn together rather than independently · 0 discarded where terminal growth approached the discount rate
Sensitivity
Implied share price across discount rate and terminal growth. The base case sits in the centre.
| WACC ╲ Terminal growth | 1.5% | 2.0% | 2.5% | 3.0% | 3.5% |
|---|---|---|---|---|---|
| 7.2% | 314.40 | 264.30 | 227.40 | 199.14 | 176.82 |
| 8.2% | 339.38 | 281.31 | 239.57 | 208.17 | 183.72 |
| 9.2% | 369.69 | 301.31 | 253.55 | 218.37 | 191.42 |
| 10.2% | 407.23 | 325.16 | 269.80 | 230.00 | 200.05 |
| 11.2% | 454.94 | 354.09 | 288.90 | 243.36 | 209.80 |
Peer set
Used as a cross-check on the model output, not as an input to it.
| Company | Revenue ($bn) | EBIT margin | EV / EBITDA | P/E | Rev growth 3Y |
|---|---|---|---|---|---|
| MSFT Microsoft Corporation | 331.8 | 58.5% | 19.9 | 21.5 | 16.1% |
| GOOGL Alphabet Inc. | 445.9 | 38.8% | 23.9 | 22.9 | 12.5% |
| META Meta Platforms, Inc. | 228.2 | 48.0% | 13.6 | 16.4 | 19.9% |
| AMZN Amazon.com, Inc. | 775.7 | 21.8% | 17.8 | 25.0 | 11.7% |
| NVDA NVIDIA Corporation | 303.0 | 66.4% | 26.3 | 14.3 | 100.0% |
This is one model with one set of assumptions, not a price target or a recommendation. Change the growth rate or the discount rate and the answer moves — which is the point. Run AAPL with your own inputs or read the disclaimer.