SPOT

SPOT — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($498.72)
DCF$286371.31+57321.3%
Graham Number$115.12-76.9%
Reverse DCFimplied g: 42.8%
DDM
EV/EBITDA$507.28+1.7%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $675.37M
Rev: 6.8% / EPS: 213.9%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$286033.84
Current Price$498.72
Upside / Downside+57253.6%
Net Debt (used)-$5.76B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term205.9%209.9%213.9%217.9%221.9%
7.0%$420608.62$448828.41$478543.14$509811.41$542693.38
8.0%$319628.77$341071.68$363650.45$387409.64$412394.93
9.0%$251410.98$268275.76$286033.84$304720.27$324370.96
10.0%$202717.30$216314.27$230631.41$245696.96$261539.90
11.0%$166551.10$177721.01$189482.51$201858.79$214873.64

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $12.38
Yahoo: $47.58

Results

Graham Number$115.12
Current Price$498.72
Margin of Safety-76.9%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$498.72
Implied Near-term FCF Growth42.8%
Historical Revenue Growth6.8%
Historical Earnings Growth213.9%
Base FCF (TTM)$675.37M
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: —

Results

This company does not pay a dividend. DDM is not applicable — the intrinsic value shown uses D0 = $0 unless you enter a hypothetical dividend above.
DDM Intrinsic Value / share
Current Price$498.72
Upside / Downside
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $2.25B
Current: 43.8×
Default: -$5.76B

Results

Implied Equity Value / share$507.28
Current Price$498.72
Upside / Downside+1.7%
Implied EV$98.66B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$7.76B-$6.76B-$5.76B-$4.76B-$3.76B
39.8x$473.20$468.34$463.48$458.62$453.76
41.8x$495.10$490.24$485.38$480.52$475.67
43.8x$517.00$512.14$507.28$502.42$497.57
45.8x$538.90$534.04$529.18$524.33$519.47
47.8x$560.80$555.94$551.09$546.23$541.37