AU

AU — Valuation Models

Interactive models with editable assumptions. All calculations run client-side.

Valuation Summary

ModelIntrinsic Valuevs Price ($128.26)
DCF$2906.39+2166.0%
Graham Number$43.25-66.3%
Reverse DCFimplied g: 14.2%
DDM$87.76-31.6%
EV/EBITDA$131.87+2.8%

Values reflect default assumptions. Adjust inputs in each model below to update.

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $2.14B
Rev: 75.3% / EPS: 63.1%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$2901.59
Current Price$128.26
Upside / Downside+2162.3%
Net Debt (used)-$624.00M
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term67.3%71.3%75.3%79.3%83.3%
7.0%$3722.50$4186.17$4695.06$5252.39$5861.56
8.0%$2877.14$3234.87$3627.44$4057.36$4527.22
9.0%$2302.35$2588.07$2901.59$3244.89$3620.07
10.0%$1889.14$2123.10$2379.81$2660.88$2968.01
11.0%$1579.86$1775.10$1989.30$2223.80$2480.03

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $5.19
Yahoo: $16.02

Results

Graham Number$43.25
Current Price$128.26
Margin of Safety-66.3%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$128.26
Implied Near-term FCF Growth14.2%
Historical Revenue Growth75.3%
Historical Earnings Growth63.1%
Base FCF (TTM)$2.14B
Implied growth is the FCF growth rate (yrs 1–5) that makes the DCF intrinsic value equal the current price. Long-term growth is set to half the implied near-term rate.

4 — Dividend Discount Model (DDM)

Assumptions

Yahoo: $4.26

Results

DDM Intrinsic Value / share$87.76
Current Price$128.26
Upside / Downside-31.6%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $5.14B
Current: 12.8×
Default: -$624.00M

Results

Implied Equity Value / share$131.87
Current Price$128.26
Upside / Downside+2.8%
Implied EV$65.97B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$2.62B-$1.62B-$624.00M$376.00M$1.38B
8.8x$95.15$93.17$91.19$89.21$87.23
10.8x$115.49$113.51$111.53$109.55$107.57
12.8x$135.83$133.85$131.87$129.89$127.91
14.8x$156.18$154.20$152.22$150.24$148.26
16.8x$176.52$174.54$172.56$170.58$168.60