CEPU

CEPU — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($15.69)
DCF$-13774151.60-87789466.5%
Graham Number$5.78-63.2%
Reverse DCF
DDM
EV/EBITDA$537.61+3326.4%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: -$67.24B
Rev: 34.9% / EPS: 178.2%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$-13774151.60
Current Price$15.69
Upside / Downside-87789466.5%
Net Debt (used)$218.56B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term170.2%174.2%178.2%182.2%186.2%
7.0%$-19838839.83$-21350598.75$-22953160.68$-24650556.38$-26446934.15
8.0%$-15105861.50$-16256781.44$-17476824.19$-18769057.90$-20136640.20
9.0%$-11905779.64$-12812733.16$-13774151.60$-14792452.30$-15870123.09
10.0%$-9619464.78$-10352119.91$-11128768.06$-11951361.63$-12821909.94
11.0%$-7919663.24$-8522737.10$-9162018.88$-9839115.34$-10555680.10

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: $1.30
Yahoo: $1.14

Results

Graham Number$5.78
Current Price$15.69
Margin of Safety-63.2%
Formula: √(22.5 × max(0,EPS) × max(0,BVPS))

3 — Reverse DCF (Implied Growth)

Assumptions

Default: 9% (no SEC data)

Results

Reverse DCF requires positive TTM free cash flow.
Current Price$15.69
Implied Near-term FCF Growth
Historical Revenue Growth34.9%
Historical Earnings Growth178.2%
Base FCF (TTM)-$67.24B
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$15.69
Upside / Downside
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $323.62B
Current: 0.9×
Default: $218.56B

Results

Implied Equity Value / share$537.61
Current Price$15.69
Upside / Downside+3326.4%
Implied EV$299.35B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt$108.56B$163.56B$218.56B$273.56B$328.56B
-3.1x$-7344.63$-7710.63$-8076.62$-8442.62$-8808.62
-1.1x$-3037.51$-3403.51$-3769.51$-4135.50$-4501.50
0.9x$1269.60$903.61$537.61$171.61$-194.39
2.9x$5576.72$5210.72$4844.73$4478.73$4112.73
4.9x$9883.84$9517.84$9151.84$8785.84$8419.85