LB

LB — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($74.00)
DCF$238539333.02+322350350.0%
Graham Number$15.56-79.0%
Reverse DCFimplied g: 12.9%
DDM$8.65-88.3%
EV/EBITDA$90.80+22.7%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $93.18M
Rev: 55.6% / EPS: 559.3%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$238383323.31
Current Price$74.00
Upside / Downside+322139526.1%
Net Debt (used)$529.54M
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term551.3%555.3%559.3%563.3%567.3%
7.0%$379889252.35$391698953.03$403800549.17$416199418.62$428901004.92
8.0%$286907127.13$295826263.47$304965850.19$314329948.86$323922670.63
9.0%$224267335.75$231239169.73$238383323.31$245702971.30$253201327.26
10.0%$179691789.24$185277889.89$191002059.48$196866841.76$202874811.56
11.0%$146693046.72$151253305.88$155926278.62$160714041.57$165618696.69

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $0.88
Yahoo: $12.22

Results

Graham Number$15.56
Current Price$74.00
Margin of Safety-79.0%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$74.00
Implied Near-term FCF Growth12.9%
Historical Revenue Growth55.6%
Historical Earnings Growth559.3%
Base FCF (TTM)$93.18M
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: $0.42

Results

DDM Intrinsic Value / share$8.65
Current Price$74.00
Upside / Downside-88.3%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $129.97M
Current: 23.5×
Default: $529.54M

Results

Implied Equity Value / share$90.80
Current Price$74.00
Upside / Downside+22.7%
Implied EV$3.06B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$1.47B-$470.46M$529.54M$1.53B$2.53B
19.5x$143.97$108.04$72.12$36.20$0.28
21.5x$153.30$117.38$81.46$45.54$9.62
23.5x$162.64$126.72$90.80$54.87$18.95
25.5x$171.98$136.06$100.13$64.21$28.29
27.5x$181.32$145.39$109.47$73.55$37.63