DTE · NYQ · Utilities
DTE Energy Company
Also onShortfallConsensus DriftCrosscheck
Implied value per share
USD 6.77
Market price
USD 135.85
Implied upside
-95.0%
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 16.0bn | USD 16.6bn | USD 17.3bn | USD 17.9bn | USD 18.5bn | USD 19.0bn | USD 19.6bn | USD 20.2bn | USD 20.7bn | USD 21.2bn | +3.2% |
| EBIT | USD 2.4bn | USD 2.5bn | USD 2.6bn | USD 2.7bn | USD 2.8bn | USD 2.9bn | USD 3.0bn | USD 3.1bn | USD 3.2bn | USD 3.2bn | +3.2% |
| NOPAT | USD 2.3bn | USD 2.4bn | USD 2.5bn | USD 2.6bn | USD 2.7bn | USD 2.7bn | USD 2.8bn | USD 2.9bn | USD 3.0bn | USD 3.0bn | +3.2% |
| Add depreciation & amortisation | USD 1.4bn | USD 1.4bn | USD 1.5bn | USD 1.5bn | USD 1.6bn | USD 1.7bn | USD 1.7bn | USD 1.7bn | USD 1.8bn | USD 1.8bn | +3.2% |
| Less capital expenditure | USD -4.5bn | USD -4.4bn | USD -4.3bn | USD -4.2bn | USD -4.0bn | USD -3.9bn | USD -3.7bn | USD -3.5bn | USD -3.2bn | USD -3.0bn | -4.5% |
| Capex, % of revenue | 28.1% | 26.5% | 25.0% | 23.4% | 21.8% | 20.3% | 18.7% | 17.1% | 15.6% | 14.0% | - |
| Less increase in working capital | USD -24.8m | USD -69.9m | USD -69.4m | USD -68.7m | USD -67.8m | USD -66.5m | USD -65.0m | USD -63.3m | USD -61.3m | USD -59.0m | +10.1% |
| Free cashflow to firm | USD -830.7m | USD -646.7m | USD -397.9m | USD -129.8m | USD 157.2m | USD 462.8m | USD 786.2m | USD 1.1bn | USD 1.5bn | USD 1.9bn | - |
| Discount factor | 0.9684 | 0.9082 | 0.8517 | 0.7987 | 0.7490 | 0.7025 | 0.6588 | 0.6178 | 0.5794 | 0.5433 | - |
| Present value | USD -804.5m | USD -587.3m | USD -338.9m | USD -103.7m | USD 117.8m | USD 325.1m | USD 517.9m | USD 696.2m | USD 859.6m | USD 1.0bn | - |
| Present Value Of The Forecast | USD 1.7bn | ||||||||||
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.568 | Reported 0.355, pulled toward 1.0 (Blume) |
| Cost of equity | 7.30% | 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.3%. |
| Market capitalisation | USD 28.3bn | 51.8% of capital |
| Total debt | USD 26.3bn | 48.2% of capital, book value as a proxy |
| Tax rate | 5.7% | Effective, capped at statutory |
| WACC | 6.63% | 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%
94% of EV
- Forecast FCFF, final year
- USD 1.9bn
- Capex at depreciation, working capital in reinvestment
- USD 3.1bn
- Less reinvestment at g/ROIC (37.7% of NOPAT)
- USD -1.2bn
- Capitalised
- USD 1.9bn
- ROIC (WACC floor)
- 6.6%
- Terminal value, undiscounted
- USD 47.5bn
- Terminal value, discounted
- USD 25.8bn
- Enterprise value
- USD 27.5bn
- Less net debt
- USD 26.1bn
- Equity value
- USD 1.4bn
Exit at 14.3x EBITDA
96% of EV
- Terminal value, undiscounted
- USD 72.3bn
- Terminal value, discounted
- USD 39.3bn
- Enterprise value
- USD 41.0bn
- Less net debt
- USD 26.1bn
- Equity value
- USD 14.9bn
Spread between methods: 166%.
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.63% | 127.26 | 138.69 | 157.05 | 188.73 | 251.36 |
| 5.63% | 52.98 | 52.22 | 52.23 | 53.45 | 56.73 |
| 6.63% | 12.28 | 9.52 | 6.77 | 4.01 | 1.26 |
| 7.63% | -13.25 | -15.51 | -17.77 | -20.03 | -22.30 |
| 8.63% | -32.46 | -34.35 | -36.24 | -38.14 | -40.03 |
Outlined: this model. Green text: above today's price of 135.85. 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 | -6.3% | 3.0% | 10.3% | |
| EBIT margin | 18.1% | 15.2% | 25.0% | |
| Discount rate | - | 6.6% | 4.8% |
Live formulas, not pasted numbers - edit a driver and the workbook reprices.
Yahoo Finance and RBA data. General information, not advice. Methodology.