VAL — Valuation Models

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

Valuation Summary

Model	Intrinsic Value	vs Price ($95.85)
DCF	$29997551.55	+31296250.1%
Graham Number	$119.51	+24.7%
Reverse DCF	—	implied g: 20.8%
DDM	—	—
EV/EBITDA	$95.88	+0.0%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Base FCF($B)Yahoo: $165.12M

Near-term growth (yrs 1–5)(%)Rev: -8.0% / EPS: 446.6%

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

Terminal growth rate(%)

WACC(%)Computed: 9.20%

Computed WACC: 9.20%

Cost of equity (Re)10.81%(Rf 4.30% + β 1.18 × 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)85.13%

Debt weight (D/V)14.87%

Results

Intrinsic Value / share$28652560.41

Current Price$95.85

Upside / Downside+29893025.1%

Net Debt (used)$559.50M

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

WACC \ Near-term	438.6%	442.6%	446.6%	450.6%	454.6%
7.0%	$47111978.06	$48887562.35	$50716283.08	$52599324.06	$54537886.56
8.0%	$35614663.96	$36956926.87	$38339358.48	$39762853.68	$41228320.57
9.0%	$27865697.13	$28915909.99	$29997551.55	$31111321.99	$32257931.81
10.0%	$22348671.70	$23190954.08	$24058442.54	$24951698.65	$25871292.23
11.0%	$18262315.94	$18950588.28	$19659457.75	$20389383.21	$21140830.32

2 — Graham Number

Assumptions

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

EPS (trailing)($)Yahoo: $13.86

Book Value / share($)Yahoo: $45.80

Results

Graham Number$119.51

Current Price$95.85

Margin of Safety+24.7%

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

3 — Reverse DCF (Implied Growth)

Assumptions

WACC(%)Computed: 9.20%

Terminal growth rate(%)

Computed WACC: 9.20%

Cost of equity (Re)10.81%(Rf 4.30% + β 1.18 × 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)85.13%

Debt weight (D/V)14.87%

Results

Current Price$95.85

Implied Near-term FCF Growth21.4%

Historical Revenue Growth-8.0%

Historical Earnings Growth446.6%

Base FCF (TTM)$165.12M

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: —

Dividend growth rate (g)(%)

Required return (r)(%)

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$95.85

Upside / Downside—

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

5 — EV/EBITDA Multiple

Assumptions

EBITDA($B)Yahoo: $641.30M

Target EV/EBITDA multipleCurrent: 11.2×

Net Debt($B)Default: $559.50M

Results

Implied Equity Value / share$95.88

Current Price$95.85

Upside / Downside+0.0%

Implied EV$7.20B

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

Mult \ Net Debt	-$1.44B	-$440.50M	$559.50M	$1.56B	$2.56B
7.2x	$87.72	$73.27	$58.83	$44.38	$29.94
9.2x	$106.24	$91.80	$77.35	$62.91	$48.46
11.2x	$124.77	$110.32	$95.88	$81.43	$66.99
13.2x	$143.29	$128.85	$114.41	$99.96	$85.52
15.2x	$161.82	$147.38	$132.93	$118.49	$104.04

← Overview Financial Statements ← Companies