BZ

BZ — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($16.18)
DCF$2864.29+17602.6%
Graham Number$10.48-35.2%
Reverse DCFimplied g: -20.0%
DDM$3.50-78.4%
EV/EBITDA$37.10+129.3%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $2.84B
Rev: 13.2% / EPS: 63.5%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$2869.07
Current Price$16.18
Upside / Downside+17632.2%
Net Debt (used)-$19.05B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term55.5%59.5%63.5%67.5%71.5%
7.0%$3580.88$4054.84$4578.54$5155.79$5790.60
8.0%$2789.29$3156.16$3561.48$4008.19$4499.39
9.0%$2250.32$2544.31$2869.07$3226.93$3620.39
10.0%$1862.27$2103.82$2370.59$2664.52$2987.65
11.0%$1571.35$1773.59$1996.92$2242.95$2513.39

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $0.80
Yahoo: $6.10

Results

Graham Number$10.48
Current Price$16.18
Margin of Safety-35.2%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$16.18
Implied Near-term FCF Growth-20.0%
Historical Revenue Growth13.2%
Historical Earnings Growth63.5%
Base FCF (TTM)$2.84B
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.17

Results

DDM Intrinsic Value / share$3.50
Current Price$16.18
Upside / Downside-78.4%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $2.67B
Current: -1.6×
Default: -$19.05B

Results

Implied Equity Value / share$37.10
Current Price$16.18
Upside / Downside+129.3%
Implied EV-$4.14B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$29.05B-$24.05B-$19.05B-$14.05B-$9.05B
-5.6x$35.41$22.97$10.52$-1.92$-14.36
-3.6x$48.70$36.26$23.81$11.37$-1.08
-1.6x$61.99$49.54$37.10$24.65$12.21
0.4x$75.27$62.83$50.39$37.94$25.50
2.4x$88.56$76.12$63.67$51.23$38.78