LPX — Valuation Models

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

Valuation Summary

Model	Intrinsic Value	vs Price ($80.59)
DCF	$5.48	-93.2%
Graham Number	$34.02	-57.8%
Reverse DCF	—	implied g: 50.7%
DDM	$24.72	-69.3%
EV/EBITDA	$80.59	-0.0%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Base FCF($B)Yahoo: $26.75M

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

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

Terminal growth rate(%)

WACC(%)Computed: 13.28%

Computed WACC: 13.28%

Cost of equity (Re)13.91%(Rf 4.30% + β 1.75 × ERP 5.50%)

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

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

Equity weight (E/V)93.69%

Debt weight (D/V)6.31%

Results

Intrinsic Value / share$2.78

Current Price$80.59

Upside / Downside-96.6%

Net Debt (used)$87.00M

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

WACC \ Near-term	-3.0%	1.0%	5.0%	9.0%	13.0%
7.0%	$5.54	$6.91	$8.50	$10.35	$12.48
8.0%	$4.33	$5.43	$6.72	$8.20	$9.90
9.0%	$3.49	$4.41	$5.48	$6.71	$8.12
10.0%	$2.88	$3.66	$4.57	$5.62	$6.82
11.0%	$2.41	$3.09	$3.88	$4.79	$5.83

2 — Graham Number

Assumptions

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

EPS (trailing)($)Yahoo: $2.08

Book Value / share($)Yahoo: $24.73

Results

Graham Number$34.02

Current Price$80.59

Margin of Safety-57.8%

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

3 — Reverse DCF (Implied Growth)

Assumptions

WACC(%)Computed: 13.28%

Terminal growth rate(%)

Computed WACC: 13.28%

Cost of equity (Re)13.91%(Rf 4.30% + β 1.75 × ERP 5.50%)

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

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

Equity weight (E/V)93.69%

Debt weight (D/V)6.31%

Results

Current Price$80.59

Implied Near-term FCF Growth65.6%

Historical Revenue Growth-16.6%

Historical Earnings Growth—

Base FCF (TTM)$26.75M

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

Dividend growth rate (g)(%)

Required return (r)(%)

Results

DDM Intrinsic Value / share$24.72

Current Price$80.59

Upside / Downside-69.3%

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

5 — EV/EBITDA Multiple

Assumptions

EBITDA($B)Yahoo: $402.00M

Target EV/EBITDA multipleCurrent: 14.2×

Net Debt($B)Default: $87.00M

Results

Implied Equity Value / share$80.59

Current Price$80.59

Upside / Downside-0.0%

Implied EV$5.71B

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

Mult \ Net Debt	-$1.91B	-$913.00M	$87.00M	$1.09B	$2.09B
10.2x	$86.20	$71.88	$57.56	$43.24	$28.92
12.2x	$97.71	$83.39	$69.07	$54.75	$40.43
14.2x	$109.23	$94.91	$80.59	$66.27	$51.95
16.2x	$120.74	$106.42	$92.10	$77.78	$63.46
18.2x	$132.26	$117.93	$103.61	$89.29	$74.97

← Overview Financial Statements ← Companies