NEE-PT

NEE-PT — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($52.47)
DCF$-982247501820.68-1872017346813.7%
Graham Number
Reverse DCF
DDM
EV/EBITDA$121380298068.99+231332757797.8%

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

1 — Discounted Cash Flow (DCF)

Assumptions

Yahoo: -$15.21B
Rev: 20.7% / EPS: 26.0%
Default: 9% (no SEC data)

Results

Intrinsic Value / share$-982247501820.68
Current Price$52.47
Upside / Downside-1872017346813.7%
Net Debt (used)$94.41B
Sensitivity: WACC (rows) × Near-term g (cols)
WACC \ Near-term18.0%22.0%26.0%30.0%34.0%
7.0%$-1086215962742.14$-1259129784411.54$-1455781435197.44$-1678556383795.99$-1929995393753.61
8.0%$-883661412671.19$-1019972005531.17$-1174903805862.84$-1350323294409.02$-1548218267931.95
9.0%$-744666302835.79$-855897526338.20$-982247501820.68$-1125227663961.73$-1286447527796.30
10.0%$-643721619241.85$-736770739404.80$-842402114262.50$-961870228411.31$-1096510838869.94
11.0%$-567329440194.40$-646645674581.23$-736630649671.19$-838345156712.76$-952918595893.59

2 — Graham Number

Assumptions

Graham used 22.5 (15× P/E × 1.5× P/B)
Yahoo: —
Yahoo: $26.22

Results

Graham Number requires positive EPS and positive Book Value per share. EPS is zero or negative.
Graham Number
Current Price$52.47
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$52.47
Implied Near-term FCF Growth
Historical Revenue Growth20.7%
Historical Earnings Growth26.0%
Base FCF (TTM)-$15.21B
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$52.47
Upside / Downside
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

Yahoo: $14.14B
Current: 15.3×
Default: $94.41B

Results

Implied Equity Value / share$121380298068.99
Current Price$52.47
Upside / Downside+231332757797.8%
Implied EV$215.79B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt$46.41B$70.41B$94.41B$118.41B$142.41B
11.3x$112828296532.99$88828296532.99$64828296532.99$40828296532.99$16828296532.99
13.3x$141104297300.99$117104297300.99$93104297300.99$69104297300.99$45104297300.99
15.3x$169380298068.99$145380298068.99$121380298068.99$97380298068.99$73380298068.99
17.3x$197656298836.99$173656298836.99$149656298836.99$125656298836.99$101656298836.99
19.3x$225932299604.99$201932299604.99$177932299604.99$153932299604.99$129932299604.99