GEF-B — Valuation Models

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

Valuation Summary

Model	Intrinsic Value	vs Price ($88.42)
DCF	$-42.19	-147.7%
Graham Number	$65.38	-26.1%
Reverse DCF	—	—
DDM	$68.39	-22.7%
EV/EBITDA	$240.32	+171.8%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Base FCF($B)Yahoo: —

Near-term growth (yrs 1–5)(%)Rev: -2.2% / EPS: 691.7%

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

Terminal growth rate(%)

WACC(%)Computed: 7.21%

Computed WACC: 7.21%

Cost of equity (Re)9.35%(Rf 4.30% + β 0.92 × 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)77.11%

Debt weight (D/V)22.89%

Results

Intrinsic Value / share$-42.19

Current Price$88.42

Upside / Downside-147.7%

Net Debt (used)$908.60M

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

WACC \ Near-term	683.7%	687.7%	691.7%	695.7%	699.7%
7.0%	$-42.19	$-42.19	$-42.19	$-42.19	$-42.19
8.0%	$-42.19	$-42.19	$-42.19	$-42.19	$-42.19
9.0%	$-42.19	$-42.19	$-42.19	$-42.19	$-42.19
10.0%	$-42.19	$-42.19	$-42.19	$-42.19	$-42.19
11.0%	$-42.19	$-42.19	$-42.19	$-42.19	$-42.19

2 — Graham Number

Assumptions

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

EPS (trailing)($)Yahoo: $3.63

Book Value / share($)Yahoo: $52.34

Results

Graham Number$65.38

Current Price$88.42

Margin of Safety-26.1%

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

3 — Reverse DCF (Implied Growth)

Assumptions

WACC(%)Computed: 7.21%

Terminal growth rate(%)

Computed WACC: 7.21%

Cost of equity (Re)9.35%(Rf 4.30% + β 0.92 × 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)77.11%

Debt weight (D/V)22.89%

Results

Reverse DCF requires positive TTM free cash flow.

Current Price$88.42

Implied Near-term FCF Growth—

Historical Revenue Growth-2.2%

Historical Earnings Growth691.7%

Base FCF (TTM)—

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: $3.32

Dividend growth rate (g)(%)

Required return (r)(%)

Results

DDM Intrinsic Value / share$68.39

Current Price$88.42

Upside / Downside-22.7%

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

5 — EV/EBITDA Multiple

Assumptions

EBITDA($B)Yahoo: $578.52M

Target EV/EBITDA multipleCurrent: 10.5×

Net Debt($B)Default: $908.60M

Results

Implied Equity Value / share$240.32

Current Price$88.42

Upside / Downside+171.8%

Implied EV$6.08B

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

Mult \ Net Debt	-$1.09B	-$91.40M	$908.60M	$1.91B	$2.91B
6.5x	$225.74	$179.30	$132.86	$86.42	$39.98
8.5x	$279.47	$233.03	$186.59	$140.15	$93.71
10.5x	$333.20	$286.76	$240.32	$193.88	$147.45
12.5x	$386.93	$340.49	$294.05	$247.61	$201.18
14.5x	$440.66	$394.22	$347.78	$301.34	$254.91

← Overview Financial Statements ← Companies