LPL

LPL — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($4.97)
DCF$-71651.55-1441781.1%
Graham Number$5.74+15.6%
Reverse DCF
DDM
EV/EBITDA$1238.40+24817.6%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: -$3.45T
Rev: -8.1% / EPS: —
Default: 9% (no SEC data)

Results

Intrinsic Value / share$-71651.55
Current Price$4.97
Upside / Downside-1441781.1%
Net Debt (used)$11.07T
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term-3.0%1.0%5.0%9.0%13.0%
7.0%$-72171.99$-84527.93$-98902.62$-115539.72$-134701.91
8.0%$-61299.86$-71244.91$-82797.26$-96149.92$-111510.91
9.0%$-53765.91$-62046.77$-71651.55$-82738.41$-95477.77
10.0%$-48235.14$-55299.65$-63481.46$-72913.37$-83738.44
11.0%$-44000.80$-50138.56$-57236.64$-65408.57$-74776.69

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $0.16
Yahoo: $9.17

Results

Graham Number$5.74
Current Price$4.97
Margin of Safety+15.6%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Reverse DCF requires positive TTM free cash flow.
Current Price$4.97
Implied Near-term FCF Growth
Historical Revenue Growth-8.1%
Historical Earnings Growth
Base FCF (TTM)-$3.45T
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

Yahoo: —

Results

This company does not pay a dividend. DDM is not applicable — the intrinsic value shown uses D0 = $0 unless you enter a hypothetical dividend above.
DDM Intrinsic Value / share
Current Price$4.97
Upside / Downside
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $5.00T
Current: 2.5×
Default: $11.07T

Results

Implied Equity Value / share$1238.40
Current Price$4.97
Upside / Downside+24817.6%
Implied EV$12.31T
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt$5.54T$8.30T$11.07T$13.84T$16.61T
-1.5x$-13216.81$-15984.81$-18752.81$-21520.81$-24288.81
0.5x$-3221.20$-5989.20$-8757.20$-11525.20$-14293.20
2.5x$6774.40$4006.40$1238.40$-1529.60$-4297.60
4.5x$16770.01$14002.01$11234.01$8466.01$5698.01
6.5x$26765.62$23997.62$21229.62$18461.62$15693.62