CMS Energy Financial Model
Utilities Company Financials Example (Free Excel Download)
CMS Energy Corporation is a multi-utility holding company based in Jackson, Michigan.
professionals from Deloitte
Used by professionals from
About this model
This model evaluates the equity valuation and dividend sustainability of CMS Energy by forecasting its regulated rate base growth, allowed returns, and capital expenditure requirements under the Michigan Public Service Commission (MPSC) regulatory framework.
CMS Energy Corporation is a multi-utility holding company based in Jackson, Michigan. Through its primary subsidiary, Consumers Energy, the company provides electricity and natural gas to approximately 6.7 million of Michigan's 10 million residents. The business operates a predominantly regulated, asset-heavy model where earnings are driven by capital investments in utility infrastructure and renewable energy generation, upon which the company earns a regulated return on equity. The company holds a monopoly position in its designated Michigan service territories, competing primarily with alternative energy sources and energy efficiency trends rather than direct utility peers. Recently, CMS Energy has focused heavily on its Clean Energy Transformation, committing to a 20-Year Renewable Energy Plan that includes adding 9 GW of solar and 4 GW of wind capacity by 2040, alongside an $8.5 billion electric Reliability Roadmap.
Business segments include:
- Electric Utility (approx. 65% of revenue): Generation, transmission, and distribution of electricity to 1.9 million customers in Michigan.
- Gas Utility (approx. 30% of revenue): Purchase, transmission, storage, and distribution of natural gas to 1.8 million customers in Michigan.
- NorthStar Clean Energy (approx. 5% of revenue): Formerly CMS Enterprises, this segment focuses on domestic independent power production and renewable energy projects for corporate clients.
The downloadable CMS Energy financial model includes SEC-sourced historical financials, forecast assumptions, core operating schedules, and valuation outputs in an Excel workbook built for review and scenario analysis.
A turnkey financial model
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
Historicals & AssumptionsCMS Energy financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $7.08B | $8.32B | $7.26B | $7.32B | $8.30B |
| Income Before Income Taxes | $823.0M | $902.0M | $954.0M | $1.12B | $1.25B |
| Operating income | $1.15B | $1.22B | $1.24B | $1.49B | $1.73B |
| Net income | $1.35B | $837.0M | $887.0M | $1.00B | $1.07B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for CMS Energy
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Electric Utility
- Segment name: Electric Utility
- Revenue driver formula: (Average Rate Base x Allowed Equity Thickness x Allowed ROE) + Recoverable Operating Expenses + Fuel Pass-Through Costs. Alternatively modelled as Volume (GWh) x Average Rate per kWh.
- Historical growth rate: 4-6% CAGR, driven primarily by rate base expansion rather than volumetric growth.
- Key growth levers and headwinds: Growth is driven by the $8.5 billion Reliability Roadmap and renewable energy investments. Headwinds include energy efficiency programmes (which reduce volumetric demand) and the delayed retirement of the J.H. Campbell coal plant due to federal emergency orders.
- Pricing dynamics: Fully regulated by the MPSC. Rates are set via general rate cases based on a test year. Fuel and purchased power costs are generally passed through to customers via power supply cost recovery (PSCR) mechanisms.
- Revenue recognition notes: Recognised as energy is delivered. Includes unbilled revenue estimates for energy delivered but not yet billed at month-end.
- Seasonality: Highly seasonal. The third quarter (summer) is the strongest due to cooling demand (air conditioning).
Gas Utility
- Segment name: Gas Utility
- Revenue driver formula: (Average Rate Base x Allowed Equity Thickness x Allowed ROE) + Recoverable Operating Expenses + Gas Cost Pass-Through. Alternatively modelled as Volume (Bcf) x Average Rate per Mcf.
- Historical growth rate: 2-4% CAGR.
- Key growth levers and headwinds: Growth is driven by infrastructure replacement (cast iron pipe replacement) and net-zero methane emission investments. Headwinds include electrification trends and warmer winter weather.
- Pricing dynamics: Regulated by the MPSC. Gas commodity costs are passed through via gas cost recovery (GCR) mechanisms. The company leverages extensive underground storage to buy gas in the summer and sell in the winter, keeping customer rates below the national average.
- Revenue recognition notes: Recognised upon delivery. Includes unbilled revenues.
- Seasonality: Extremely seasonal. The first and fourth quarters (winter) generate the vast majority of revenue and earnings due to heating demand.
NorthStar Clean Energy
- Segment name: NorthStar Clean Energy
- Revenue driver formula: Contracted Capacity (MW) x Capacity Price + Generation (MWh) x Energy Price.
- Historical growth rate: 5-10% CAGR, highly dependent on new project commissioning.
- Key growth levers and headwinds: Driven by corporate decarbonisation goals and long-term power purchase agreements (PPAs).
- Pricing dynamics: Contractual. Revenues are secured via long-term PPAs with creditworthy counterparties, insulating the segment from spot market volatility.
- Revenue recognition notes: Recognised over time as capacity is provided and energy is delivered.
- Seasonality: Varies by asset type (wind vs. solar generation profiles).
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: Fuel for electric generation, purchased power, and cost of natural gas sold.
- Gross margin range: Not typically evaluated on a gross margin basis in the utility sector, but "Revenue less fuel and purchased power" (Net Revenue) margins typically range from 45% to 55%.
- Key input costs and commodity exposures: Natural gas prices, coal prices, and wholesale electricity prices. Because of PSCR and GCR mechanisms, commodity price volatility primarily impacts customer bills rather than corporate earnings, though high bills can increase regulatory friction.
- How COGS scales with revenue: Linear with volumetric sales, but completely decoupled from the earnings generated by rate base investments.
Operating Expenses
- Operating and Maintenance (O&M): The largest controllable cost, covering payroll, vegetation management, grid maintenance, and corporate overhead. CMS Energy employs a lean operating system called the "CE Way" to drive continuous waste elimination (e.g., $100 million in savings in 2025).
- Depreciation & Amortisation: Very high (typically 12-15% of revenue) due to the capital-intensive nature of utility infrastructure. Split almost entirely into tangible asset depreciation.
- Taxes Other Than Income: Property taxes and payroll taxes are material line items for utilities.
- Restructuring / one-time charges: Infrequent, though early plant retirements (e.g., coal plants) can trigger regulatory asset creation and amortisation rather than immediate P&L hits.
Margin Profile
- Operating margin: 18-22% (highly dependent on weather and the timing of rate case outcomes).
- Net margin: 10-13%.
- Margin trend: Stable to slightly expanding as the company replaces pass-through fuel costs with capital-intensive renewable generation (which earns a return).
Balance Sheet Structure
- Total assets: Approximately $35.9 billion (as of 2024/2025).
- Key asset categories: Property, Plant, and Equipment (PP&E) makes up the vast majority of assets. Regulatory Assets are also highly material.
- Goodwill & intangibles: Minimal (less than 5% of assets), as growth is primarily organic rather than through M&A.
- Working capital profile:
- DSO: 35-45 days.
- DIO: Gas inventory is highly seasonal, peaking in October and drawing down through March.
- DPO: 30-40 days.
- Net working capital: Generally negative or neutral, excluding seasonal gas inventory swings.
- PP&E: Consists of electric generation plants, transmission lines, distribution grids, gas pipelines, and storage facilities. Useful lives range from 10 to 60+ years.
- Regulatory Assets/Liabilities: Represent costs or revenues that the MPSC has authorised to be deferred and recovered from or refunded to customers in future periods (e.g., storm costs, under-recovered fuel).
Capital Expenditure & Investment
- Capex as % of revenue: 35-45% (utilities invest heavily relative to revenue).
- Maintenance vs. growth capex: Approximately 40% maintenance (safety, basic replacement) and 60% growth/transformation (renewables, grid hardening, smart meters).
- Major capex programmes: The $8.5 billion electric Reliability Roadmap and the 20-Year Renewable Energy Plan (targeting 9 GW solar and 4 GW wind).
- Capitalised software: Material for grid management systems, but dwarfed by hard infrastructure.
- M&A pattern: Organic grower. M&A is rare and typically limited to bolt-on renewable asset acquisitions in the NorthStar segment.
Debt & Capital Structure
- Total debt: Approximately $14-16 billion.
- Debt/EBITDA ratio: 4.5x to 5.5x, standard for a regulated utility.
- Credit rating: Investment grade (typically BBB+ / Baa1 range).
- Key debt instruments: First mortgage bonds (secured by utility property), unsecured notes, securitisation bonds (issued by special purpose entities to recover specific costs like retired plants), and commercial paper for working capital.
- Maturity profile: Laddered over 10 to 30 years to match the long-duration nature of utility assets.
- Interest rate profile: Predominantly fixed-rate long-term debt.
- Covenants: Standard debt-to-capitalisation limits (usually capped at 65%).
- Share repurchase programme: Not active. Utilities generally issue equity to fund capex rather than buy back shares.
- Dividend policy: Highly consistent. The company increased its dividend to $2.28 per share for 2026 (the 20th consecutive annual increase), targeting a payout ratio of approximately 60%.
Cash Flow Characteristics
- Operating cash flow conversion: OCF / Net Income is typically 1.5x to 2.0x due to massive non-cash depreciation and deferred taxes.
- Free cash flow margin: Often negative. The company outspends its operating cash flow on capital expenditures to grow the rate base, funding the gap with debt and equity issuance.
- Major non-cash items: Depreciation, amortisation of regulatory assets, and deferred income taxes.
- Working capital cash flow impact: Highly seasonal. Cash is used to build gas inventory in the summer and generated as inventory is drawn down in the winter.
- Capex intensity: Extremely high. Annual capex routinely exceeds $2.5 billion.
- Cash tax rate: Significantly lower than the statutory rate due to accelerated depreciation on utility infrastructure, creating large deferred tax liabilities.
Sheet Structure
- Assumptions: Hardcoded inputs for macroeconomic drivers, rate base growth, allowed ROE, equity thickness, O&M inflation, and financing costs.
- Scenarios: Toggles for base, bull, and bear cases (e.g., varying MPSC rate case outcomes or weather normalisation).
- Rate Base Build: Roll-forward of the electric and gas rate bases (Beginning Balance + Capex - Depreciation = Ending Balance). This is the engine of the model.
- Revenue Build: Calculation of electric and gas revenues based on Rate Base x Allowed Return, plus recovery of O&M and fuel costs. Includes NorthStar Clean Energy revenue build.
- Income Statement: Consolidated P&L mirroring the 10-K, with clear breakouts for Operating Revenue, Fuel and Purchased Power, O&M, Depreciation, and Interest Expense.
- Balance Sheet: Assets (highlighting Utility Plant and Regulatory Assets), Liabilities (highlighting Long-Term Debt and Regulatory Liabilities), and Equity.
- Cash Flow Statement: Operating, Investing, and Financing cash flows. Must accurately capture the heavy capex and regular debt/equity issuance.
- Debt Schedule: Tranche-by-tranche roll-forward of first mortgage bonds, securitisation bonds, and revolving credit facilities.
- Regulatory Tracker: Schedule tracking pending rate cases, requested rate increases, and historical MPSC authorised ROEs.
- Valuation (DCF & DDM): Dividend Discount Model (primary for utilities) and a standard Unlevered DCF.
- Outputs & Summary: Dashboard showing adjusted EPS, dividend payout ratio, FFO/Debt, and rate base CAGR.
Key Financial Relationships
- "Electric Rate Base = Prior Year Electric Rate Base + Electric Capex - Electric Depreciation"
- "Gas Rate Base = Prior Year Gas Rate Base + Gas Capex - Gas Depreciation"
- "Electric Operating Income = (Average Electric Rate Base x Allowed Equity Thickness x Allowed ROE) + (Average Electric Rate Base x Debt Thickness x Cost of Debt)"
- "Electric Revenue = Electric Operating Income + Electric O&M + Electric Depreciation + Taxes Other Than Income + Fuel and Purchased Power"
- "Gas Revenue = Gas Operating Income + Gas O&M + Gas Depreciation + Taxes Other Than Income + Cost of Gas Sold"
- "Consolidated Operating Revenue = Electric Revenue + Gas Revenue + NorthStar Clean Energy Revenue"
- "Net Income Available to Common Stockholders = Consolidated Operating Income - Interest Expense - Income Taxes - Preferred Dividends"
- "Adjusted EPS = (Net Income Available to Common Stockholders + Weather Normalisation Adjustments + One-Time Restructuring Costs) / Diluted Shares Outstanding"
- "Dividend Payout Ratio = Dividends per Share / Adjusted EPS (Targeting ~60%)"
- "Funds From Operations (FFO) = Net Income + Depreciation + Deferred Taxes"
- "FFO to Debt Ratio = FFO / Total Debt (Key credit metric, targeting >15%)"
- "External Financing Need = Capital Expenditures + Dividends Paid - Operating Cash Flow"
Cross-Sheet Dependencies
- The Rate Base Build is the foundational sheet. It feeds depreciation to the Income Statement and Cash Flow Statement, and ending PP&E balances to the Balance Sheet.
- The Rate Base Build also drives the Revenue Build, as utility revenue is fundamentally a function of the allowed return on the rate base.
- The Revenue Build feeds the top line of the Income Statement.
- The Income Statement generates Net Income, which feeds the top of the Cash Flow Statement and Retained Earnings on the Balance Sheet.
- The Cash Flow Statement determines the External Financing Need, which feeds the Debt Schedule (and potential equity issuance).
- *Circularity Risk:* Interest expense on the Income Statement depends on the debt balance from the Debt Schedule, which depends on the financing shortfall from the Cash Flow Statement, which in turn depends on Net Income. This requires a standard interest circuit breaker.
Sign Convention
- Income Statement: Revenues are positive. All expenses (Fuel, O&M, Depreciation, Interest, Taxes) are negative. Net Income is positive if profitable.
- Balance Sheet: Assets are positive. Liabilities and Equity are positive. (Total Assets = Total Liabilities + Total Equity).
- Cash Flow Statement: Cash inflows (Net Income, depreciation add-back, debt issuance) are positive. Cash outflows (Capex, dividends, debt repayment, working capital increases) are negative.
- Formulas: Combine items using addition (e.g., Gross Margin = Revenue + COGS, where COGS is negative).
Things Most Likely to Go Wrong
- "Failing to decouple volumetric sales from earnings; in a regulated utility, earnings are driven by rate base investments, while volumetric changes mostly impact pass-through fuel revenues."
- "Ignoring the impact of weather; the model must include a weather-normalised view, as mild winters or cool summers can swing reported EPS by $0.10 to $0.20."
- "Mismodelling securitisation bonds; these are non-recourse bonds serviced by a dedicated customer surcharge and should be ring-fenced from the parent company's core corporate debt metrics."
- "Applying a standard gross margin concept; utilities pass through fuel costs dollar-for-dollar, so 'Gross Margin' is meaningless. Focus on 'Net Revenue' or 'Gross Margin excluding fuel'."
- "Underestimating the external financing need; CMS Energy routinely outspends its cash flow to fund the Reliability Roadmap, requiring regular debt and equity issuances to maintain its capital structure."
- "Missing the regulatory lag; capital spent today does not earn a return until it is approved in the next rate case, meaning rapid capex expansion can temporarily depress earned ROE versus allowed ROE."
- "Treating NorthStar Clean Energy as a regulated business; it operates on long-term PPAs and does not have a regulated rate base."
- "Failing to account for the seasonality of working capital; gas inventory builds consume massive amounts of cash in Q2 and Q3, which is released in Q1 and Q4."
Validation Checks
- "Adjusted EPS growth should fall within the management guidance range of 6.0% to 8.0% annually; flag if outside this band."
- "Dividend payout ratio must remain between 55% and 65% based on stated corporate policy."
- "Consolidated Operating Revenue should be approximately $8.5 billion in the base year (2025)."
- "Electric and Gas Rate Base growth should closely track the $2.5+ billion annual capex spend minus depreciation."
- "FFO to Debt should remain above 15% to maintain current investment-grade credit ratings."
- "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
- "Effective tax rate should be significantly lower than the 21% statutory rate due to production tax credits (PTCs) and amortisation of excess deferred taxes."
- "Equity thickness in the capital structure should remain near the MPSC authorised level of approximately 50-52%."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| 2025 Base Year Revenue | 8,500 | $ Millions | Actual 2025 consolidated operating revenue. |
| 2026 Adjusted EPS Guidance | 3.86 | $ / Share | Midpoint of management's 2026 guidance range of $3.83 to $3.90. |
| Long-Term EPS Growth Rate | 7.0 | % | Midpoint of management's 6% to 8% long-term target. |
| Annual Dividend (2026) | 2.28 | $ / Share | Actual declared dividend for 2026. |
| Target Dividend Payout Ratio | 60.0 | % | Management stated target payout ratio. |
| Electric Utility Allowed ROE | 9.90 | % | Typical recent MPSC authorised return on equity for Consumers Energy. |
| Gas Utility Allowed ROE | 9.90 | % | Typical recent MPSC authorised return on equity for Consumers Energy. |
| Authorised Equity Thickness | 51.0 | % | Standard MPSC regulatory capital structure target. |
| Annual Capital Expenditures | 2,800 | $ Millions | Estimated annual run-rate to support the $8.5B Reliability Roadmap and renewables. |
| O&M Annual Inflation/Growth | 1.0 | % | Kept low due to the "CE Way" waste elimination programme offsetting inflation. |
| Effective Tax Rate | 12.0 | % | Blended rate reflecting statutory rate offset by renewable tax credits and regulatory amortisations. |
| Cost of Debt (New Issuance) | 5.50 | % | Estimated yield on new long-term utility first mortgage bonds. |
| Terminal Growth Rate (DCF) | 2.0 | % | Standard long-term GDP/inflation proxy for a mature domestic utility. |
| Cost of Equity (WACC) | 8.5 | % | Based on current risk-free rates and utility beta. |
Data Sources & Benchmarks
- SEC Filings: CMS Energy and Consumers Energy combined Form 10-K and 10-Q filings via the SEC EDGAR database.
- Investor Relations: CMS Energy website (cmsenergy.com/investor-relations) for earnings presentations, rate case updates, and the Reliability Roadmap details.
- Regulatory Data: Michigan Public Service Commission (MPSC) electronic docket system for real-time updates on pending electric and gas rate cases.
- Key Peers for Benchmarking: DTE Energy (DTE) - direct Michigan peer; WEC Energy Group (WEC); Alliant Energy (LNT); Xcel Energy (XEL).
- Industry Data: Edison Electric Institute (EEI) for utility capex and rate base trends; American Gas Association (AGA).
Sources
Do more with the CMS Energy model
Frequently asked
What does CMS Energy do?+
CMS Energy is a multi-utility holding company primarily operating through its subsidiary, Consumers Energy, to provide electricity and natural gas to approximately 6.7 million residents in Michigan. The company focuses on a regulated, asset-heavy model, driving earnings through capital investments in utility infrastructure and renewable energy.
How does CMS Energy generate revenue?+
CMS Energy generates revenue primarily through its Electric Utility and Gas Utility segments, which provide electricity and natural gas services to its designated Michigan service territories. Earnings are driven by capital investments in utility infrastructure and renewable energy generation, upon which the company earns a regulated return on equity.
What is a key assumption for capital expenditures in CMS Energy's financial model?+
In CMS Energy's financial model, capital expenditure (Capex) is assumed to be approximately 15.8% of revenue. This reflects the company's asset-heavy utility model and significant ongoing investments in infrastructure and renewable energy projects.
What is the purpose of the financial model for CMS Energy?+
The financial model for CMS Energy is designed to evaluate the company's equity valuation and dividend sustainability. It achieves this by forecasting regulated rate base growth, allowed returns, and capital expenditure requirements under the Michigan Public Service Commission (MPSC) regulatory framework.
Can I download an Excel financial model for CMS Energy?+
Yes, an Excel financial model for CMS Energy is available for download. This model forecasts the company's financials from FY2026 through FY2030, providing a comprehensive view of its future performance.
What is CMS Energy's strategic focus regarding clean energy?+
CMS Energy is heavily focused on its Clean Energy Transformation, committing to a 20-Year Renewable Energy Plan. This plan aims to add 9 GW of solar and 4 GW of wind capacity by 2040, alongside an $8.5 billion electric Reliability Roadmap.
Have more financial modelling questions? Contact us
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Other Utilities Company Financial Models
Browse another company in the same sector.
Ameren
Ameren Corporation is a public utility holding company headquartered in St.
American Electric Power
American Electric Power Company, Inc.
AES
The AES Corporation is a global Fortune 500 independent power producer and utility company that generates and distributes electrical power.
Atmos Energy
Atmos Energy Corporation is the largest fully regulated, pure-play natural gas distributor in the United States, serving approximately 3.4 million customers.
American Water Works
American Water Works Company, Inc.
Constellation Energy
Constellation Energy Corporation (CEG) is the largest producer of carbon-free energy in the United States and a leading competitive retail energy supplier.
CenterPoint Energy
CenterPoint Energy is a public utility holding company that operates regulated electric transmission and distribution systems, as well as natural gas distribution systems across multiple US states.
Dominion Energy
Dominion Energy is a regulated electric utility holding company headquartered in Richmond, Virginia, providing electricity to approximately 3.6 million homes and businesses.
Explore more Energy financial model templates.
