WLFC — Valuation Models

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

Valuation Summary

Model	Intrinsic Value	vs Price ($195.01)
DCF	$-2613.68	-1440.3%
Graham Number	$178.54	-8.4%
Reverse DCF	—	—
DDM	$32.96	-83.1%
EV/EBITDA	$212.99	+9.2%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Base FCF($B)Yahoo: -$265.21M

Near-term growth (yrs 1–5)(%)Rev: 26.1% / EPS: -3.6%

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

Terminal growth rate(%)

WACC(%)Computed: 5.83%

Computed WACC: 5.83%

Cost of equity (Re)8.50%(Rf 4.30% + β 0.76 × ERP 5.50%)

Cost of debt (Rd)5.15%(interest expense ÷ avg debt (SEC))

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

Equity weight (E/V)39.78%

Debt weight (D/V)60.22%

Results

Intrinsic Value / share$-5252.56

Current Price$195.01

Upside / Downside-2793.5%

Net Debt (used)$2.24B

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

WACC \ Near-term	18.1%	22.1%	26.1%	30.1%	34.1%
7.0%	$-2887.01	$-3332.67	$-3839.46	$-4413.53	$-5061.41
8.0%	$-2364.24	$-2715.51	$-3114.74	$-3566.72	$-4076.57
9.0%	$-2005.53	$-2292.14	$-2617.67	$-2986.03	$-3401.34
10.0%	$-1745.03	$-1984.76	$-2256.88	$-2564.63	$-2911.43
11.0%	$-1547.91	$-1752.23	$-1984.02	$-2246.00	$-2541.08

2 — Graham Number

Assumptions

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

EPS (trailing)($)Yahoo: $16.66

Book Value / share($)Yahoo: $85.04

Results

Graham Number$178.54

Current Price$195.01

Margin of Safety-8.4%

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

3 — Reverse DCF (Implied Growth)

Assumptions

WACC(%)Computed: 5.83%

Terminal growth rate(%)

Computed WACC: 5.83%

Cost of equity (Re)8.50%(Rf 4.30% + β 0.76 × ERP 5.50%)

Cost of debt (Rd)5.15%(interest expense ÷ avg debt (SEC))

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

Equity weight (E/V)39.78%

Debt weight (D/V)60.22%

Results

Reverse DCF requires positive TTM free cash flow.

Current Price$195.01

Implied Near-term FCF Growth—

Historical Revenue Growth26.1%

Historical Earnings Growth-3.6%

Base FCF (TTM)-$265.21M

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

Dividend growth rate (g)(%)

Required return (r)(%)

Results

DDM Intrinsic Value / share$32.96

Current Price$195.01

Upside / Downside-83.1%

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

5 — EV/EBITDA Multiple

Assumptions

EBITDA($B)Yahoo: $382.01M

Target EV/EBITDA multipleCurrent: 9.7×

Net Debt($B)Default: $2.24B

Results

Implied Equity Value / share$212.99

Current Price$195.01

Upside / Downside+9.2%

Implied EV$3.69B

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

Mult \ Net Debt	$242.33M	$1.24B	$2.24B	$3.24B	$4.24B
5.7x	$282.25	$135.50	$-11.26	$-158.01	$-304.76
7.7x	$394.37	$247.62	$100.87	$-45.89	$-192.64
9.7x	$506.50	$359.74	$212.99	$66.24	$-80.52
11.7x	$618.62	$471.87	$325.11	$178.36	$31.61
13.7x	$730.74	$583.99	$437.24	$290.48	$143.73

← Overview Financial Statements ← Companies