Module 02 · AAPL Monte Carlo

Four knobs, ten thousand rolls on Apple.

Each path redraws WACC, terminal growth, revenue growth and EBIT margin around the Apple case, then reruns the DCF.

Mean

$217.18

Median

$206.84

P5

$155.03

Very bear

P25

$182.64

P75

$241.06

P95

$309.39

Very bull

95.5% of 10,000 paths price below the AAPL $313.45 tape. Shocks: WACC ±1.0%, TGR ±0.5%, growth ±2.5%, margin ±1.5%.

Monte Carlo

Live distribution · 10,000 paths

1.6%

$305.21$322.15

P5P50P95$118.95$728.54

$305.21$322.15

1.6% of paths

CDF 96.1%

Green dashed is the median. Red dashed is the live tape. Drag across bins to read P(range).

Cumulative distribution

At $447.25 the model sits at the 99.6% percentile.

Market$118.95$447.25

Excel workbook reference

The original model’s 10,000-path print — a cross-check, not a live rerun.

StatisticExcelThis desk
Mean$172.00$217.18
Median$164.60$206.84
P5$122.50$155.03
P25$144.00$182.64
P75$190.20$241.06
P95$246.10$309.39