CRE

CRE — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($2.73)
DCF$1344.43+49146.7%
Graham Number$4.11+50.6%
Reverse DCFimplied g: -12.0%
DDM
EV/EBITDA$3.12+14.3%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: $5.56M
Rev: 1.4% / EPS: 63.7%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$1346.75
Current Price$2.73
Upside / Downside+49231.4%
Net Debt (used)$31.41M
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term55.7%59.7%63.7%67.7%71.7%
7.0%$1692.09$1921.33$2174.60$2453.74$2760.67
8.0%$1308.62$1486.05$1682.06$1898.06$2135.54
9.0%$1047.53$1189.71$1346.75$1519.78$1709.99
10.0%$859.56$976.37$1105.36$1247.47$1403.67
11.0%$718.64$816.43$924.41$1043.35$1174.08

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $0.61
Yahoo: $1.23

Results

Graham Number$4.11
Current Price$2.73
Margin of Safety+50.6%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Current Price$2.73
Implied Near-term FCF Growth-12.0%
Historical Revenue Growth1.4%
Historical Earnings Growth63.7%
Base FCF (TTM)$5.56M
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$2.73
Upside / Downside
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $12.06M
Current: 3.0×
Default: $31.41M

Results

Implied Equity Value / share$3.12
Current Price$2.73
Upside / Downside+14.3%
Implied EV$36.53M
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt-$1.97B-$968.59M$31.41M$1.03B$2.03B
-1.0x$1193.99$583.84$-26.30$-636.44$-1246.59
1.0x$1208.70$598.55$-11.59$-621.73$-1231.88
3.0x$1223.41$613.27$3.12$-607.02$-1217.17
5.0x$1238.12$627.98$17.83$-592.31$-1202.45
7.0x$1252.83$642.69$32.54$-577.60$-1187.74