DTE Energy Financial Model

• Total assets: Approximately $54.1 billion as of year-end 2025.
• Key asset categories: Property, Plant, and Equipment (PP&E) is the dominant asset, representing the utility rate base. Regulatory assets are also material, representing deferred costs approved for future recovery from customers.
• Goodwill & intangibles: Minimal, as growth is primarily organic infrastructure investment rather than corporate M&A.
• Working capital profile:
• Days Sales Outstanding (DSO): 35-45 days.
• Days Payable Outstanding (DPO): 30-40 days.
• Net working capital is typically negative or near zero. The company does not fund growth from working capital; it funds growth through external capital markets.
• PP&E: Consists of generation plants, distribution grids, and gas pipelines. Useful lives range from 10 to 60 years.
• Right-of-use assets: Immaterial relative to the massive owned infrastructure base.

• Capex as % of revenue: Extremely high, typically 25-35% of revenue.
• Maintenance vs. growth split: Approximately 40% maintenance (base infrastructure) and 60% growth (cleaner generation, grid modernisation, data centre load support).
• Major capex programmes: The 2026-2030 capital plan is $36.5 billion. This includes converting the Belle River plant to natural gas peaking, building battery storage at Trenton Channel, and constructing infrastructure for the 1.4 GW Oracle data centre.
• M&A pattern: Primarily organic growth. DTE Vantage occasionally makes bolt-on acquisitions of RNG facilities.

• Total debt: Highly levered, typical for a regulated utility.
• Debt/Capital ratio: Management targets approximately 50% debt and 50% equity in the utility capital structure to align with regulatory requirements.
• Credit rating: Typically BBB+ to A- (investment grade is critical for utility access to capital).
• Key debt instruments: First mortgage bonds (secured by utility assets), unsecured holding company notes, and commercial paper for short-term liquidity.
• Interest rate profile: Predominantly fixed-rate long-term bonds.
• Share repurchase programme: Inactive. Utilities issue equity to fund growth rather than repurchasing shares.
• Dividend policy: Target payout ratio of 60-65% of operating earnings. The dividend grows in line with EPS growth (6-8% annually).

• Operating cash flow conversion: Very strong. OCF is typically 2.0x to 2.5x Net Income due to massive depreciation add-backs and deferred taxes.
• Free cash flow margin: Free cash flow (OCF less Capex) is consistently negative. This is a structural feature of a growing utility, not a sign of distress.
• Major non-cash items: Depreciation, amortisation of regulatory assets, and deferred income taxes.
• Working capital cash flow impact: Minor fluctuations driven by winter heating demand and fuel inventory levels.
• Cash tax rate: Significantly lower than the statutory rate due to accelerated depreciation on infrastructure and production tax credits from renewable energy and RNG projects.

1. Assumptions: Macroeconomic drivers, weather normalisation factors, allowed ROE, equity ratio targets, and the $36.5 billion 5-year capex plan.
2. Revenue & Fuel: Volume drivers (MWh and Bcf), rate assumptions, fuel cost pass-through calculations, and DTE Vantage project revenue.
3. O&M & D&A: Detailed build of operating and maintenance expenses, property taxes, and depreciation schedules linked to PP&E additions.
4. Rate Base Roll-Forward: Beginning PP&E, plus Capex, minus Depreciation, minus Deferred Taxes, yielding the ending Rate Base (the foundation for future earnings).
5. Income Statement: Consolidated view mirroring the 10-K, plus a segment-level operating earnings build (Electric, Gas, Vantage, Trading, Corporate).
6. Balance Sheet: Standard utility format highlighting Utility Plant, Regulatory Assets, and Long-Term Debt.
7. Cash Flow Statement: Indirect method, clearly showing the massive capex outflow and the resulting financing need.
8. Financing & Debt Schedule: Calculates the cash shortfall (FCF minus Dividends) and models the issuance of new debt and equity to maintain the 50/50 capital structure.
9. Valuation: Sum-of-the-parts DCF and P/E multiple valuation, bridging enterprise value to equity value.

1. "Electric Gross Margin = Electric Operating Revenues - Fuel and Purchased Power"
2. "Gas Gross Margin = Gas Operating Revenues - Cost of Gas Sold"
3. "Ending Utility Plant = Beginning Utility Plant + Capital Expenditures - Retirements"
4. "Accumulated Depreciation = Beginning Accumulated Depreciation + Depreciation Expense - Retirements"
5. "Estimated Rate Base = Net Utility Plant + Working Capital Allowance - Accumulated Deferred Income Taxes"
6. "Electric Regulated Earnings = Estimated Rate Base x Equity Ratio (approx 50%) x Allowed ROE"
7. "Total Capex = Base Infrastructure Capex + Cleaner Generation Capex + Distribution Infrastructure Capex + Non-Utility Capex"
8. "Free Cash Flow = Operating Cash Flow - Capital Expenditures"
9. "Financing Need = Dividends Paid - Free Cash Flow"
10. "New Equity Issued = Financing Need x Target Equity Funding Percentage"
11. "New Debt Issued = Financing Need x Target Debt Funding Percentage"
12. "Interest Expense = Average Debt Balance x Weighted Average Interest Rate"
13. "Operating EPS = Consolidated Operating Earnings / Diluted Shares Outstanding"
14. "Dividends Paid = Prior Year Operating EPS x Target Payout Ratio x Diluted Shares Outstanding"

The critical chain in this model revolves around capital expenditure and financing. The Assumptions sheet dictates the $36.5 billion capex plan. This feeds the Rate Base Roll-Forward, which increases PP&E on the Balance Sheet and drives Depreciation on the O&M & D&A sheet. The increased Rate Base feeds the Income Statement by driving higher allowed revenues in future years. Simultaneously, the Capex flows to the Cash Flow Statement, creating a massive negative Free Cash Flow. This shortfall feeds the Financing & Debt Schedule, triggering new debt and equity issuances. The new debt generates Interest Expense, which flows back to the Income Statement, creating a circular reference that must be managed with an iterative calculation or a circuit breaker toggle.

• Revenues and Sales Volumes: Positive
• Operating Expenses (O&M, Fuel, D&A): Positive (subtracted in margin formulas)
• Capital Expenditures: Positive on the Capex schedule, negative on the Cash Flow Statement
• Debt and Equity Issuances: Positive on the Cash Flow Statement
• Dividends Paid: Positive on the Assumptions sheet, negative on the Cash Flow Statement

• Failing to model fuel and purchased power as a direct pass-through. If commodity prices spike, revenue and fuel expense should increase by the exact same dollar amount, leaving gross margin unchanged.
• Extrapolating abnormal weather. 2024 and 2025 featured specific weather impacts (e.g., warmer winters hurting Gas, hotter summers helping Electric). The model must use weather-normalised baseline volumes for forecasting.
• Ignoring the equity funding requirement. Utilities cannot fund $36.5 billion of capex with debt alone without losing their investment-grade rating. The model must force equity issuances to maintain a 50% debt-to-capital ratio.
• Misunderstanding Energy Trading. This segment is highly volatile. Do not apply a historical CAGR; instead, hardcode a normalised run-rate of $30-$50 million in operating earnings.
• Double-counting RNG tax credits. DTE Vantage benefits heavily from production tax credits, which lower the effective tax rate. Ensure these are modelled as a tax benefit rather than top-line revenue.
• Circularity in the interest expense calculation. The cash shortfall requires debt, which creates interest expense, which lowers net income, which increases the cash shortfall. Provide a toggle to break this loop.
• Confusing Reported EPS with Operating EPS. Management guides to Operating EPS (which excludes mark-to-market trading swings and one-time plant retirement costs). Valuation should be based on Operating EPS.
• Applying standard corporate working capital metrics. DSO and DPO are largely irrelevant for utility valuation; focus entirely on rate base growth.

• "Electric and Gas Gross Margins must grow in line with Rate Base growth (approx 6-8%); flag if margin growth deviates significantly from capex additions."
• "Fuel and Purchased Power expense must exactly equal Fuel Recovery Revenue in the forecast period."
• "Free Cash Flow after dividends must be negative in every projected year due to the $36.5 billion capex plan."
• "The Debt to Total Capitalisation ratio must remain between 48% and 52% to reflect regulatory capital structure targets."
• "Operating EPS growth must fall within management's guided range of 6.0% to 8.0% annually."
• "Effective tax rate should remain below the 21% statutory rate (typically 10-15%) due to renewable energy and RNG tax credits."
• "Dividend payout ratio must remain between 60% and 65% of Operating EPS."
• "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."

• Filings: SEC EDGAR (DTE Energy Company Form 10-K, Form 8-K for earnings releases).
• Investor Relations: DTE Energy Investor Relations website (specifically the Q4 2025 Earnings Presentation detailing the $36.5B capex plan and Oracle data centre deal).
• Key Peers: CMS Energy (CMS - direct Michigan peer), WEC Energy Group (WEC), Alliant Energy (LNT), Xcel Energy (XEL).
• Industry Data: Michigan Public Service Commission (MPSC) rate case dockets, Edison Electric Institute (EEI) industry capex trends.
• Consensus Estimates: FactSet or Bloomberg for forward EPS and capex consensus.

• DTE Energy 2024 Form 10-K
• DTE Energy Q4 2025 Earnings Release and Presentation (February 2026)
• Industrial Info Resources: Data Center Demand Drives DTE's Five-Year Capex Increase
• Seeking Alpha: DTE Energy outlines 6-8% EPS growth through 2030
• Stock Titan: DTE Energy lifts 2025 EPS, lands 1.4 GW Oracle data center deal