DUK · NYQ · Utilities
Duke Energy Corporation
Also onShortfallConsensus DriftCrosscheck
Implied value per share
USD 27.28
Market price
USD 128.38
Implied upside
-78.8%
10-year forecast · Perpetuity growth terminal value · Mid-year discounting · Base case · Price 2026-11-02 · Accounts to 2025-12-31
Value Per Share
Same forecast, different terminal treatment. Percentages vs price.
Forecast Cashflows
Reporting currency (USD). Outflows negative.
| Line | FY26 | FY27 | FY28 | FY29 | FY30 | FY31 | FY32 | FY33 | FY34 | FY35 | CAGR |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | USD 33.8bn | USD 35.3bn | USD 36.8bn | USD 38.3bn | USD 39.7bn | USD 41.1bn | USD 42.4bn | USD 43.7bn | USD 44.9bn | USD 46.0bn | +3.5% |
| EBIT | USD 8.4bn | USD 8.8bn | USD 9.2bn | USD 9.5bn | USD 9.9bn | USD 10.2bn | USD 10.6bn | USD 10.9bn | USD 11.2bn | USD 11.5bn | +3.5% |
| NOPAT | USD 7.5bn | USD 7.9bn | USD 8.2bn | USD 8.5bn | USD 8.9bn | USD 9.2bn | USD 9.5bn | USD 9.8bn | USD 10.0bn | USD 10.3bn | +3.5% |
| Add depreciation & amortisation | USD 7.3bn | USD 7.6bn | USD 7.9bn | USD 8.3bn | USD 8.6bn | USD 8.9bn | USD 9.2bn | USD 9.4bn | USD 9.7bn | USD 9.9bn | +3.5% |
| Less capital expenditure | USD -14.1bn | USD -14.3bn | USD -14.4bn | USD -14.5bn | USD -14.5bn | USD -14.5bn | USD -14.5bn | USD -14.3bn | USD -14.2bn | USD -13.9bn | -0.1% |
| Capex, % of revenue | 41.7% | 40.4% | 39.2% | 37.9% | 36.6% | 35.3% | 34.1% | 32.8% | 31.5% | 30.3% | - |
| Less increase in working capital | USD -177.5m | USD -178.2m | USD -175.9m | USD -172.5m | USD -168.2m | USD -162.8m | USD -156.4m | USD -149.0m | USD -140.6m | USD -131.2m | -3.3% |
| Free cashflow to firm | USD 566.2m | USD 1.0bn | USD 1.6bn | USD 2.1bn | USD 2.7bn | USD 3.4bn | USD 4.0bn | USD 4.7bn | USD 5.4bn | USD 6.2bn | +30.4% |
| Discount factor | 0.9693 | 0.9107 | 0.8556 | 0.8039 | 0.7553 | 0.7096 | 0.6667 | 0.6264 | 0.5886 | 0.5530 | - |
| Present value | USD 548.8m | USD 954.6m | USD 1.3bn | USD 1.7bn | USD 2.1bn | USD 2.4bn | USD 2.7bn | USD 2.9bn | USD 3.2bn | USD 3.4bn | - |
| Present Value Of The Forecast | USD 21.2bn | ||||||||||
Discount Rate
Source shown per component. All overridable above.
| Risk-free rate | 4.89% | US 10-year Treasury (^TNX), 2026-11-02 |
| Equity risk premium | 4.23% | Damodaran, January 2026 |
| Beta | 0.536 | Reported 0.308, pulled toward 1.0 (Blume) |
| Cost of equity | 7.16% | Risk-free + beta x equity risk premium |
| Cost of debt | 6.27% | Risk-free + 138bp, the spread for a BB+ rating at 2.4x interest cover. Book interest / average debt was lower, at 4.1%. |
| Market capitalisation | USD 100.1bn | 52.4% of capital |
| Total debt | USD 90.9bn | 47.6% of capital, book value as a proxy |
| Tax rate | 10.2% | Effective, capped at statutory |
| WACC | 6.43% | E/V x Re + D/V x Rd x (1 - t) |
Terminal Value
Perpetuity growth is intrinsic. The exit multiple defaults to the company's current EV/EBITDA, so it answers a different question - what the shares are worth if today's rating holds and EBITDA grows as forecast.
Perpetuity growth at 2.50%
81% of EV
- Forecast FCFF, final year
- USD 6.2bn
- Capex at depreciation, working capital in reinvestment
- USD 10.3bn
- Less reinvestment at g/ROIC (38.9% of NOPAT)
- USD -4.0bn
- Capitalised
- USD 6.3bn
- ROIC (WACC floor)
- 6.4%
- Terminal value, undiscounted
- USD 163.8bn
- Terminal value, discounted
- USD 90.6bn
- Enterprise value
- USD 111.8bn
- Less net debt
- USD 90.6bn
- Equity value
- USD 21.2bn
Exit at 11.7x EBITDA
87% of EV
- Terminal value, undiscounted
- USD 250.5bn
- Terminal value, discounted
- USD 138.5bn
- Enterprise value
- USD 159.8bn
- Less net debt
- USD 90.6bn
- Equity value
- USD 69.1bn
Spread between methods: 106%.
Sensitivity
Value per share (USD) by discount rate and long-run growth.
| Long-run growth | |||||
|---|---|---|---|---|---|
| Discount rate | 1.50% | 2.00% | 2.50% | 3.00% | 3.50% |
| 4.44% | 134.15 | 139.89 | 150.44 | 170.81 | 216.76 |
| 5.44% | 66.67 | 63.48 | 60.29 | 57.09 | 53.90 |
| 6.44% | 32.37 | 29.82 | 27.27 | 24.73 | 22.18 |
| 7.43% | 7.61 | 5.53 | 3.44 | 1.36 | -0.72 |
| 8.43% | -11.02 | -12.75 | -14.49 | -16.23 | -17.96 |
Outlined: this model. Green text: above today's price of 128.38. Shading: distance from this model's own value.
Priced In
What each input would have to be to justify the current price, one at a time.
| Input | Actual | Model | Implied | Gap |
|---|---|---|---|---|
| Revenue growth, a year | 3.9% | 3.6% | 9.6% | |
| EBIT margin | 26.6% | 24.9% | 38.4% | |
| Discount rate | - | 6.4% | 4.6% |
Live formulas, not pasted numbers - edit a driver and the workbook reprices.
Yahoo Finance and RBA data. General information, not advice. Methodology.