CSV — Valuation Models

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

Valuation Summary

Model	Intrinsic Value	vs Price ($45.05)
DCF	$64.43	+43.0%
Graham Number	$33.53	-25.6%
Reverse DCF	—	implied g: 13.0%
DDM	$9.27	-79.4%
EV/EBITDA	$45.06	+0.0%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Base FCF($B)Yahoo: $44.98M

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

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

Terminal growth rate(%)

WACC(%)Computed: 5.30%

Computed WACC: 5.30%

Cost of equity (Re)9.42%(Rf 4.30% + β 0.93 × 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)56.21%

Debt weight (D/V)43.79%

Results

Intrinsic Value / share$213.89

Current Price$45.05

Upside / Downside+374.8%

Net Debt (used)$550.82M

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

WACC \ Near-term	8.8%	12.8%	16.8%	20.8%	24.8%
7.0%	$71.65	$91.54	$114.37	$140.46	$170.15
8.0%	$50.87	$66.67	$84.78	$105.47	$129.00
9.0%	$36.56	$49.54	$64.43	$81.41	$100.71
10.0%	$26.12	$37.07	$49.60	$63.88	$80.11
11.0%	$18.20	$27.59	$38.34	$50.58	$64.48

2 — Graham Number

Assumptions

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

EPS (trailing)($)Yahoo: $3.09

Book Value / share($)Yahoo: $16.18

Results

Graham Number$33.53

Current Price$45.05

Margin of Safety-25.6%

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

3 — Reverse DCF (Implied Growth)

Assumptions

WACC(%)Computed: 5.30%

Terminal growth rate(%)

Computed WACC: 5.30%

Cost of equity (Re)9.42%(Rf 4.30% + β 0.93 × 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)56.21%

Debt weight (D/V)43.79%

Results

Current Price$45.05

Implied Near-term FCF Growth-0.7%

Historical Revenue Growth8.0%

Historical Earnings Growth16.8%

Base FCF (TTM)$44.98M

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.45

Dividend growth rate (g)(%)

Required return (r)(%)

Results

DDM Intrinsic Value / share$9.27

Current Price$45.05

Upside / Downside-79.4%

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

5 — EV/EBITDA Multiple

Assumptions

EBITDA($B)Yahoo: $121.74M

Target EV/EBITDA multipleCurrent: 10.4×

Net Debt($B)Default: $550.82M

Results

Implied Equity Value / share$45.06

Current Price$45.05

Upside / Downside+0.0%

Implied EV$1.26B

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

Mult \ Net Debt	-$1.45B	-$449.18M	$550.82M	$1.55B	$2.55B
6.4x	$141.16	$77.65	$14.14	$-49.37	$-112.89
8.4x	$156.62	$93.11	$29.60	$-33.91	$-97.42
10.4x	$172.09	$108.58	$45.06	$-18.45	$-81.96
12.4x	$187.55	$124.04	$60.53	$-2.98	$-66.49
14.4x	$203.02	$139.50	$75.99	$12.48	$-51.03

← Overview Financial Statements ← Companies