CCRN

CCRN — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($8.83)
DCF$33.69+281.5%
Graham Number
Reverse DCFimplied g: -20.0%
DDM
EV/EBITDA$8.83-0.0%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $57.34M
Rev: -20.6% / EPS: —
Computed: 6.52%
Computed WACC: 6.52%
Cost of equity (Re)6.57%(Rf 4.30% + β 0.41 × ERP 5.50%)
Cost of debt (Rd)0.00%(no debt / unavailable → 0%)
Tax rate (T)21.00%(US statutory fallback)
Equity weight (E/V)99.24%
Debt weight (D/V)0.76%

Results

Intrinsic Value / share$52.88
Current Price$8.83
Upside / Downside+498.8%
Net Debt (used)-$96.93M
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term-3.0%1.0%5.0%9.0%13.0%
7.0%$33.95$40.22$47.51$55.95$65.67
8.0%$28.44$33.48$39.34$46.11$53.90
9.0%$24.61$28.81$33.69$39.31$45.77
10.0%$21.81$25.39$29.54$34.33$39.82
11.0%$19.66$22.77$26.38$30.52$35.27

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $-0.49
Yahoo: $12.55

Results

Graham Number requires positive EPS and positive Book Value per share. EPS is zero or negative.
Graham Number
Current Price$8.83
Margin of Safety
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Computed: 6.52%
Computed WACC: 6.52%
Cost of equity (Re)6.57%(Rf 4.30% + β 0.41 × ERP 5.50%)
Cost of debt (Rd)0.00%(no debt / unavailable → 0%)
Tax rate (T)21.00%(US statutory fallback)
Equity weight (E/V)99.24%
Debt weight (D/V)0.76%

Results

Current Price$8.83
Implied Near-term FCF Growth-20.0%
Historical Revenue Growth-20.6%
Historical Earnings Growth
Base FCF (TTM)$57.34M
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$8.83
Upside / Downside
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $20.93M
Current: 9.2×
Default: -$96.93M

Results

Implied Equity Value / share$8.83
Current Price$8.83
Upside / Downside-0.0%
Implied EV$192.34M
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$2.10B-$1.10B-$96.93M$903.07M$1.90B
5.2x$67.32$36.80$6.27$-24.25$-54.78
7.2x$68.60$38.08$7.55$-22.97$-53.50
9.2x$69.88$39.35$8.83$-21.70$-52.22
11.2x$71.16$40.63$10.11$-20.42$-50.94
13.2x$72.44$41.91$11.39$-19.14$-49.66