SE

SE — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($105.21)
DCF$15059.11+14213.4%
Graham Number$29.25-72.2%
Reverse DCFimplied g: 28.7%
DDM
EV/EBITDA$114.79+9.1%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $763.99M
Rev: 38.3% / EPS: 145.8%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$15059.11
Current Price$105.21
Upside / Downside+14213.4%
Net Debt (used)-$5.66B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term137.8%141.8%145.8%149.8%153.8%
7.0%$21157.53$22995.21$24958.50$27053.75$29287.51
8.0%$16154.03$17556.53$19054.89$20653.95$22358.68
9.0%$12767.44$13875.42$15059.11$16322.33$17669.02
10.0%$10345.04$11242.36$12200.98$13224.00$14314.60
11.0%$8541.79$9282.30$10073.39$10917.60$11817.58

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $2.22
Yahoo: $17.13

Results

Graham Number$29.25
Current Price$105.21
Margin of Safety-72.2%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$105.21
Implied Near-term FCF Growth28.7%
Historical Revenue Growth38.3%
Historical Earnings Growth145.8%
Base FCF (TTM)$763.99M
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$105.21
Upside / Downside
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $1.79B
Current: 31.8×
Default: -$5.66B

Results

Implied Equity Value / share$114.79
Current Price$105.21
Upside / Downside+9.1%
Implied EV$57.07B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$7.66B-$6.66B-$5.66B-$4.66B-$3.66B
27.8x$105.33$103.50$101.67$99.84$98.01
29.8x$111.89$110.06$108.23$106.40$104.57
31.8x$118.45$116.62$114.79$112.96$111.13
33.8x$125.01$123.18$121.35$119.52$117.69
35.8x$131.57$129.74$127.91$126.08$124.25