CMBT

CMBT — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($14.72)
DCF$8679.38+58863.2%
Graham Number$13.00-11.7%
Reverse DCFimplied g: 28.7%
DDM$4.33-70.6%
EV/EBITDA$14.72+0.0%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $143.11M
Rev: 160.6% / EPS: -35.3%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$8679.38
Current Price$14.72
Upside / Downside+58863.2%
Net Debt (used)$5.42B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term152.6%156.6%160.6%164.6%168.6%
7.0%$12353.20$13363.59$14438.96$15582.38$16797.04
8.0%$9413.58$10183.75$11003.44$11875.00$12800.86
9.0%$7424.97$8032.65$8679.38$9367.04$10097.53
10.0%$6003.37$6494.88$7017.98$7574.18$8165.01
11.0%$4945.79$5350.88$5782.01$6240.41$6727.36

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $0.83
Yahoo: $9.04

Results

Graham Number$13.00
Current Price$14.72
Margin of Safety-11.7%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$14.72
Implied Near-term FCF Growth28.7%
Historical Revenue Growth160.6%
Historical Earnings Growth-35.3%
Base FCF (TTM)$143.11M
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.21

Results

DDM Intrinsic Value / share$4.33
Current Price$14.72
Upside / Downside-70.6%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $756.60M
Current: 12.8×
Default: $5.42B

Results

Implied Equity Value / share$14.72
Current Price$14.72
Upside / Downside+0.0%
Implied EV$9.69B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt$3.42B$4.42B$5.42B$6.42B$7.42B
8.8x$11.18$7.74$4.29$0.85$-2.60
10.8x$16.40$12.95$9.51$6.06$2.61
12.8x$21.61$18.17$14.72$11.27$7.83
14.8x$26.83$23.38$19.94$16.49$13.04
16.8x$32.04$28.60$25.15$21.70$18.26