NEE-PS

NEE-PS — Valuation Models

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

Valuation Summary

ModelIntrinsic Valuevs Price ($56.31)
DCF$-982247501820.68-1744357133505.6%
Graham Number
Reverse DCF
DDM
EV/EBITDA$129198612281.34+229441683937.2%

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$56.31
Upside / Downside-1744357133505.6%
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$56.31
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$56.31
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$56.31
Upside / Downside
Formula: D0 × (1+g) / (r − g)

5 — EV/EBITDA Multiple

Assumptions

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

Results

Implied Equity Value / share$129198612281.34
Current Price$56.31
Upside / Downside+229441683937.2%
Implied EV$223.61B
Sensitivity: EV/EBITDA multiple (rows) × Net Debt (cols)
Mult \ Net Debt$46.41B$70.41B$94.41B$118.41B$142.41B
11.8x$120646610745.34$96646610745.34$72646610745.34$48646610745.34$24646610745.34
13.8x$148922611513.34$124922611513.34$100922611513.34$76922611513.34$52922611513.34
15.8x$177198612281.34$153198612281.34$129198612281.34$105198612281.34$81198612281.34
17.8x$205474613049.34$181474613049.34$157474613049.34$133474613049.34$109474613049.34
19.8x$233750613817.34$209750613817.34$185750613817.34$161750613817.34$137750613817.34