EE — Valuation Models

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

Valuation Summary

Model	Intrinsic Value	vs Price ($41.99)
DCF	$144971.25	+345151.8%
Graham Number	$26.19	-37.6%
Reverse DCF	—	implied g: -3.2%
DDM	$6.18	-85.3%
EV/EBITDA	$90.36	+115.2%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Base FCF($B)Yahoo: $208.11M

Near-term growth (yrs 1–5)(%)Rev: 15.7% / EPS: 167.9%

Long-term growth (yrs 6–10)(%)

Terminal growth rate(%)

WACC(%)Computed: 9.07%

Computed WACC: 9.07%

Cost of equity (Re)11.80%(Rf 4.30% + β 1.36 × ERP 5.50%)

Cost of debt (Rd)0.00%(no debt / unavailable → 0%)

Tax rate (T)21.00%(US statutory fallback)

Equity weight (E/V)76.86%

Debt weight (D/V)23.14%

Results

Intrinsic Value / share$142914.24

Current Price$41.99

Upside / Downside+340253.0%

Net Debt (used)$903.14M

Sensitivity: WACC (rows) × Near-term g (cols)

WACC \ Near-term	159.9%	163.9%	167.9%	171.9%	175.9%
7.0%	$207613.32	$224081.77	$241579.09	$260152.77	$279851.72
8.0%	$158185.76	$170731.99	$184061.97	$198211.84	$213218.89
9.0%	$124756.68	$134650.29	$145161.86	$156319.91	$168153.80
10.0%	$100865.29	$108863.17	$117360.54	$126380.43	$135946.60
11.0%	$83096.55	$89684.57	$96683.97	$104113.72	$111993.38

2 — Graham Number

Assumptions

MultiplierGraham used 22.5 (15× P/E × 1.5× P/B)

EPS (trailing)($)Yahoo: $1.43

Book Value / share($)Yahoo: $21.31

Results

Graham Number$26.19

Current Price$41.99

Margin of Safety-37.6%

Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

WACC(%)Computed: 9.07%

Terminal growth rate(%)

Computed WACC: 9.07%

Cost of equity (Re)11.80%(Rf 4.30% + β 1.36 × ERP 5.50%)

Cost of debt (Rd)0.00%(no debt / unavailable → 0%)

Tax rate (T)21.00%(US statutory fallback)

Equity weight (E/V)76.86%

Debt weight (D/V)23.14%

Results

Current Price$41.99

Implied Near-term FCF Growth-3.1%

Historical Revenue Growth15.7%

Historical Earnings Growth167.9%

Base FCF (TTM)$208.11M

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

Annual dividend D0($/share)Yahoo: $0.30

Dividend growth rate (g)(%)

Required return (r)(%)

Results

DDM Intrinsic Value / share$6.18

Current Price$41.99

Upside / Downside-85.3%

Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

EBITDA($B)Yahoo: $414.99M

Target EV/EBITDA multipleCurrent: 9.1×

Net Debt($B)Default: $903.14M

Results

Implied Equity Value / share$90.36

Current Price$41.99

Upside / Downside+115.2%

Implied EV$3.80B

Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)

Mult \ Net Debt	-$1.10B	-$96.86M	$903.14M	$1.90B	$2.90B
5.1x	$100.98	$69.74	$38.50	$7.26	$-23.98
7.1x	$126.91	$95.67	$64.43	$33.19	$1.95
9.1x	$152.84	$121.60	$90.36	$59.12	$27.88
11.1x	$178.77	$147.53	$116.29	$85.05	$53.81
13.1x	$204.70	$173.46	$142.22	$110.98	$79.74

← Overview Financial Statements ← Companies