Duke Energy Corporation
over ten years, 12x exit
| Fiscal year | Operating cash flow | Stock comp | Capex | Free cash flow | Net borrowing | FCFE | Shares (B) | FCF per share | Year-end price | FCF yield |
|---|---|---|---|---|---|---|---|---|---|---|
| 2016 | 6.8 | 0.1 | 7.9 | -1.2 | +8.7 | 7.6 | 0.69 | $-1.67 | $77.62 | -2.2% |
| 2017 | 6.6 | 0.1 | 8.1 | -1.5 | +3.5 | 2.0 | 0.70 | $-2.13 | $84.11 | -2.5% |
| 2018 | 7.2 | 0.1 | 9.4 | -2.3 | +2.1 | -0.2 | 0.71 | $-3.21 | $86.30 | -3.7% |
| 2019 | 8.2 | -5.1 | 11.1 | 2.2 | +3.9 | 6.1 | 0.73 | $3.01 | $91.21 | 3.3% |
| 2020 | 8.9 | -5.0 | 9.9 | 4.0 | +0.6 | 4.6 | 0.74 | $5.36 | $91.56 | 5.9% |
| 2021 | 8.3 | -5.2 | 9.7 | 3.7 | +4.8 | 8.6 | 0.77 | $4.86 | $104.90 | 4.6% |
| 2022 | 5.9 | 0.1 | 11.4 | -5.5 | +6.6 | 1.1 | 0.77 | $-7.19 | $102.99 | -7.0% |
| 2023 | 9.9 | 0.1 | 12.6 | -2.8 | +5.4 | 2.6 | 0.77 | $-3.65 | $97.04 | -3.8% |
| 2024 | 12.3 | 0.0 | 12.3 | 0.0 | +3.9 | 3.9 | 0.77 | $0.06 | $107.74 | 0.1% |
| 2025 | 12.4 | 0.0 | 14.0 | -1.7 | +3.8 | 2.1 | 0.78 | $-2.15 | $117.21 | -1.8% |
| 9-yr CAGR | 6.9% | n/m | 6.6% | n/m | n/a | -13.3% | 1.3% | n/m | 4.7% | avg -0.7% |
| Fiscal year | Revenue | EBITDA | EBITDA margin | Debt incl. leases | Cash & securities | Market cap | Enterprise value | EV / EBITDA | Net debt / EBITDA |
|---|---|---|---|---|---|---|---|---|---|
| 2016 | 22.7 | 9.1 | 39.9% | 46.4 | -5.4 | 54 | 105 | 11.6x | 5.71x |
| 2017 | 23.6 | 9.7 | 41.0% | 49.5 | -6.4 | 59 | 115 | 11.9x | 5.78x |
| 2018 | 24.5 | 9.4 | 38.3% | 51.5 | -5.9 | 61 | 118 | 12.6x | 6.12x |
| 2019 | 25.1 | 10.9 | 43.4% | 57.4 | -7.4 | 66 | 131 | 12.1x | 5.95x |
| 2020 | 23.4 | 10.1 | 43.0% | 57.0 | -8.3 | 68 | 133 | 13.2x | 6.49x |
| 2021 | 25.1 | 11.0 | 44.0% | 61.5 | 10.7 | 81 | 131 | 11.9x | 4.60x |
| 2022 | 28.8 | 11.9 | 41.2% | 67.9 | 0.4 | 79 | 147 | 12.4x | 5.70x |
| 2023 | 29.1 | 13.2 | 45.3% | 73.4 | 0.3 | 75 | 148 | 11.2x | 5.56x |
| 2024 | 30.4 | 14.3 | 47.3% | 77.3 | 11.7 | 83 | 149 | 10.4x | 4.57x |
| 2025 | 32.2 | 14.9 | 46.2% | 81.1 | 0.2 | 91 | 172 | 11.5x | 5.43x |
| 9-yr CAGR | 4.0% | 5.7% | avg 43.0% | 6.4% | n/m | 6.1% | 5.6% | median 11.9x | avg 5.59x |
| Purchase price | 8x | 10x | 11.5x last FYE | 12x median | 16x |
|---|---|---|---|---|---|
| $86 | 2.6% | 6.9% | 9.3% | 10.0% | 14.6% |
| $88 | 2.4% | 6.6% | 9.1% | 9.8% | 14.4% |
| $105 | 0.8% | 4.9% | 7.3% | 8.0% | 12.5% |
| $117 last close | -0.2% | 3.9% | 6.2% | 6.9% | 11.4% |
| $134 | -1.4% | 2.6% | 4.9% | 5.6% | 10.0% |
Revenue grew 4.0% a year and EBITDA 5.7% a year from FY2016 to FY2025, and free cash flow after stock compensation did not grow from a positive base. The share count rose 1.3% a year, so per-share figures grew more slowly than the totals. Net debt stood at 5.4x EBITDA at the last fiscal year-end. Capital spending rose from 35% of revenue to 44%, which is why free cash flow lagged operating cash flow in the latest year. At 12x EBITDA at the last fiscal year-end against a ten-year median of 12x, the model prices the last close of $117 as a 6.9% ten-year return; the grid shows how that changes if the multiple holds.
From the data: Stock compensation is not reported in the data feed for the latest fiscal year, so that year's free cash flow is before stock comp.
- Free cash flow is operating cash flow less stock-based compensation less capital spending. Stock comp is treated as a real cost.
- Net borrowing is the year's change in long-term debt. FCFE adds it back to free cash flow, the classic one-page definition.
- EBITDA is operating income plus depreciation and amortization. Debt includes lease obligations; cash includes short-term investments.
- Market cap uses the fiscal year-end price as traded, restated for later splits but not for dividends; enterprise value adds debt and subtracts cash.
- Share count is the yearly change in shares outstanding over the period; flat or falling clears. Cash margin is the latest free cash flow margin against its three-year average; within two points clears.
- Hurdle price is the present value, at the hurdle rate, of ten years of modeled free cash flow per share plus a year-10 sale at the exit multiple. It is shown as an exhibit: the 2011 to 2021 back-test found that buying below it did not sort winners from losers, so it is not scored.
- Cleared on a check means the number clears the stated rule; Not cleared means it does not. Durable, Holding and First year say how many fiscal years running the company has cleared all four staying-power checks (four or more, two or three, one); Partial and Not cleared count the checks it clears today. All of it is fact about the filings, not a rating of the stock.