CELUW

CELUW — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($0.01)
DCF$157970463.63+1880600757365.6%
Graham Number
Reverse DCFimplied g: -15.7%
DDM
EV/EBITDA

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $12.79M
Rev: -43.2% / EPS: —
Default: 9% (no SEC data)

Results

Intrinsic Value / share$157970463.63
Current Price$0.01
Upside / Downside+1880600757365.6%
Net Debt (used)$66.64M
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term-3.0%1.0%5.0%9.0%13.0%
7.0%$159900066.39$205711916.72$259008641.10$320693633.80$391740851.19
8.0%$119589732.09$156462764.42$199295159.33$248802503.55$305756112.73
9.0%$91656264.10$122359037.36$157970463.63$199076942.31$246310406.98
10.0%$71149974.72$97342895.93$127678411.84$162648869.81$202784736.19
11.0%$55450388.39$78207232.06$104524607.24$134823513.25$169557448.94

2 — Graham Number

Assumptions

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

Results

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

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

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

5 — EV/EBITDA Multiple

Assumptions

Yahoo: -$41.35M
Current: —×
Default: $66.64M

Results

Implied Equity Value / share$-562902000.00
Current Price$0.01
Upside / Downside-6701214285814.3%
Implied EV-$496.26M