BEP-PA

BEP-PA — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($17.94)
DCF$-8.045873814227823e+25-4.485779651562088e+26%
Graham Number
Reverse DCF
DDM$26.99+50.5%
EV/EBITDA$36950691344.90+206009518782.8%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: -$4.47B
Rev: 7.5% / EPS: 4758.0%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$-8.045873814227823e+25
Current Price$17.94
Upside / Downside-4.485779651562088e+26%
Net Debt (used)$33.95B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term4750.0%4754.0%4758.0%4762.0%4766.0%
7.0%$-1.3605463585999048e+26$-1.3661661211169754e+26$-1.3718044383407168e+26$-1.377461356179651e+26$-1.3831369206179622e+26
8.0%$-1.0242040741549659e+26$-1.0284345684922871e+26$-1.0326790306051618e+26$-1.0369374950530113e+26$-1.041209996452215e+26
9.0%$-7.979843200496088e+25$-8.012804094056255e+25$-8.045873814227823e+25$-8.079052630272333e+25$-8.112340811895092e+25
10.0%$-6.3728552076544595e+25$-6.39917840685702e+25$-6.425588517070204e+25$-6.4520857533314225e+25$-6.478670331032486e+25
11.0%$-5.1854578568089296e+25$-5.206876488752097e+25$-5.228365838351353e+25$-5.249926080578102e+25$-5.271557390692118e+25

2 — Graham Number

Assumptions

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

Results

Graham Number requires positive EPS and positive Book Value per share. EPS is zero or negative.
Graham Number
Current Price$17.94
Margin of Safety
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$17.94
Implied Near-term FCF Growth
Historical Revenue Growth7.5%
Historical Earnings Growth4758.0%
Base FCF (TTM)-$4.47B
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: $1.31

Results

DDM Intrinsic Value / share$26.99
Current Price$17.94
Upside / Downside+50.5%
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $3.28B
Current: 21.6×
Default: $33.95B

Results

Implied Equity Value / share$36950691344.90
Current Price$17.94
Upside / Downside+206009518782.8%
Implied EV$70.91B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt$17.95B$25.95B$33.95B$41.95B$49.95B
17.6x$39826691600.90$31826691600.90$23826691600.90$15826691600.90$7826691600.90
19.6x$46388691472.90$38388691472.90$30388691472.90$22388691472.90$14388691472.90
21.6x$52950691344.90$44950691344.90$36950691344.90$28950691344.90$20950691344.90
23.6x$59512691216.90$51512691216.90$43512691216.90$35512691216.90$27512691216.90
25.6x$66074691088.90$58074691088.90$50074691088.90$42074691088.90$34074691088.90