WLK — Valuation Models

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

Valuation Summary

Model	Intrinsic Value	vs Price ($106.79)
DCF	$-18.63	-117.4%
Graham Number	—	—
Reverse DCF	—	implied g: 55.9%
DDM	$43.67	-59.1%
EV/EBITDA	$110.41	+3.4%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Base FCF($B)Yahoo: $62.25M

Near-term growth (yrs 1–5)(%)Rev: -10.9% / EPS: —

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

Terminal growth rate(%)

WACC(%)Computed: 6.03%

Computed WACC: 6.03%

Cost of equity (Re)8.85%(Rf 4.30% + β 0.83 × 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)68.12%

Debt weight (D/V)31.88%

Results

Intrinsic Value / share$-11.37

Current Price$106.79

Upside / Downside-110.6%

Net Debt (used)$3.48B

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

WACC \ Near-term	-3.0%	1.0%	5.0%	9.0%	13.0%
7.0%	$-18.55	$-16.81	$-14.79	$-12.45	$-9.76
8.0%	$-20.08	$-18.68	$-17.06	$-15.18	$-13.02
9.0%	$-21.14	$-19.98	$-18.63	$-17.07	$-15.27
10.0%	$-21.92	$-20.92	$-19.77	$-18.45	$-16.93
11.0%	$-22.51	$-21.65	$-20.65	$-19.50	$-18.19

2 — Graham Number

Assumptions

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

EPS (trailing)($)Yahoo: $-7.43

Book Value / share($)Yahoo: $68.73

Results

Graham Number requires positive EPS and positive Book Value per share. EPS is zero or negative.

Graham Number—

Current Price$106.79

Margin of Safety—

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

3 — Reverse DCF (Implied Growth)

Assumptions

WACC(%)Computed: 6.03%

Terminal growth rate(%)

Computed WACC: 6.03%

Cost of equity (Re)8.85%(Rf 4.30% + β 0.83 × 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)68.12%

Debt weight (D/V)31.88%

Results

Current Price$106.79

Implied Near-term FCF Growth41.2%

Historical Revenue Growth-10.9%

Historical Earnings Growth—

Base FCF (TTM)$62.25M

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

Dividend growth rate (g)(%)

Required return (r)(%)

Results

DDM Intrinsic Value / share$43.67

Current Price$106.79

Upside / Downside-59.1%

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

5 — EV/EBITDA Multiple

Assumptions

EBITDA($B)Yahoo: $834.00M

Target EV/EBITDA multipleCurrent: 21.2×

Net Debt($B)Default: $3.48B

Results

Implied Equity Value / share$110.41

Current Price$106.79

Upside / Downside+3.4%

Implied EV$17.64B

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

Mult \ Net Debt	$1.48B	$2.48B	$3.48B	$4.48B	$5.48B
17.2x	$100.00	$92.20	$84.41	$76.61	$68.81
19.2x	$113.00	$105.20	$97.41	$89.61	$81.82
21.2x	$126.00	$118.21	$110.41	$102.62	$94.82
23.2x	$139.01	$131.21	$123.42	$115.62	$107.82
25.2x	$152.01	$144.22	$136.42	$128.62	$120.83

← Overview Financial Statements ← Companies