DTE Energy Company
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 | 2.1 | 0.1 | 2.0 | -0.0 | +2.4 | 2.4 | 0.18 | $-0.12 | $83.84 | -0.1% |
| 2017 | 2.1 | 0.1 | 2.3 | -0.2 | +0.9 | 0.7 | 0.18 | $-1.07 | $93.16 | -1.1% |
| 2018 | 2.7 | 0.1 | 2.7 | -0.1 | -0.1 | -0.2 | 0.18 | $-0.54 | $93.87 | -0.6% |
| 2019 | 2.6 | 0.0 | 3.0 | -0.4 | +3.8 | 3.4 | 0.19 | $-2.15 | $110.53 | -1.9% |
| 2020 | 3.7 | 0.0 | 3.9 | -0.2 | +3.1 | 2.9 | 0.19 | $-0.88 | $103.33 | -0.9% |
| 2021 | 3.1 | 0.4 | 3.8 | -1.1 | -4.5 | -5.6 | 0.19 | $-5.57 | $119.54 | -4.7% |
| 2022 | 2.0 | 0.1 | 3.4 | -1.5 | +2.3 | 0.9 | 0.20 | $-7.46 | $117.53 | -6.4% |
| 2023 | 3.2 | 0.0 | 3.9 | -0.8 | +0.5 | -0.2 | 0.21 | $-3.70 | $110.26 | -3.4% |
| 2024 | 3.6 | 0.0 | 4.5 | -0.8 | +3.3 | 2.4 | 0.21 | $-3.98 | $120.75 | -3.3% |
| 2025 | 3.4 | 0.0 | 4.4 | -1.0 | +3.1 | 2.1 | 0.21 | $-4.84 | $128.98 | -3.8% |
| 9-yr CAGR | 5.7% | n/m | 9.0% | n/m | n/a | -1.6% | 1.6% | n/m | 4.9% | avg -2.6% |
| Fiscal year | Revenue | EBITDA | EBITDA margin | Debt incl. leases | Cash & securities | Market cap | Enterprise value | EV / EBITDA | Net debt / EBITDA |
|---|---|---|---|---|---|---|---|---|---|
| 2016 | 10.6 | 2.5 | 23.2% | 11.3 | 0.1 | 15 | 26 | 10.6x | 4.53x |
| 2017 | 12.6 | 2.7 | 21.7% | 12.2 | 0.1 | 17 | 29 | 10.5x | 4.41x |
| 2018 | 14.2 | 2.7 | 19.1% | 12.1 | 0.1 | 17 | 29 | 10.7x | 4.44x |
| 2019 | 12.2 | 2.7 | 22.1% | 16.1 | -0.2 | 20 | 37 | 13.6x | 6.04x |
| 2020 | 11.4 | 3.0 | 26.2% | 19.2 | 0.5 | 20 | 39 | 12.9x | 6.24x |
| 2021 | 15.0 | 3.0 | 19.7% | 14.6 | 0.2 | 23 | 38 | 12.7x | 4.88x |
| 2022 | 19.2 | 3.2 | 16.7% | 17.0 | 0.0 | 23 | 40 | 12.4x | 5.26x |
| 2023 | 12.7 | 3.9 | 30.7% | 17.5 | 0.0 | 23 | 40 | 10.3x | 4.48x |
| 2024 | 12.5 | 3.9 | 31.1% | 20.9 | 0.0 | 25 | 46 | 11.8x | 5.38x |
| 2025 | 15.8 | 4.3 | 27.1% | 24.1 | 0.3 | 27 | 51 | 11.8x | 5.56x |
| 9-yr CAGR | 4.5% | 6.3% | avg 23.8% | 8.8% | 9.2% | 6.6% | 7.6% | median 11.8x | avg 5.12x |
| Purchase price | 8x | 10x | 12x median | 16x |
|---|---|---|---|---|
| $75 | 1.7% | 6.5% | 10.0% | 15.1% |
| $95 | -0.1% | 4.5% | 7.9% | 12.9% |
| $114 | -1.6% | 3.0% | 6.3% | 11.1% |
| $127 last close | -2.4% | 2.1% | 5.3% | 10.1% |
| $146 | -3.5% | 0.9% | 4.1% | 8.7% |
Revenue grew 4.5% a year and EBITDA 6.3% 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.6% a year, so per-share figures grew more slowly than the totals. Net debt stood at 5.6x EBITDA at the last fiscal year-end. Capital spending rose from 19% of revenue to 28%, 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 $127 as a 5.3% 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.