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

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

Monte Carlo

Live distribution · 10,000 paths

1.3%

$322.15–$339.08

P5P50P95$118.95$728.54

$322.15–$339.08

1.3% of paths

CDF 97.4%

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