CenterPoint Energy Financial Model
Utilities Company Financials Example (Free Excel Download)
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.
professionals from Deloitte
Used by professionals from






About this model
This model evaluates CenterPoint Energy's rate base growth, capital expenditure recovery, and dividend sustainability to determine its equity valuation and credit profile as a regulated multi-utility.
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. The company generates earnings primarily through a regulated return on its infrastructure investments, known as its rate base.
- Electric Segment (approx. 65% of earnings): Provides electric transmission and distribution to the Houston area and southwestern Indiana.
- Natural Gas Segment (approx. 35% of earnings): Distributes natural gas in Indiana, Ohio, Minnesota, and Texas.
- Key Geographies: Texas (Houston Gulf Coast), Indiana, Ohio, and Minnesota.
- Business Model: Regulated utility. Revenue is decoupled from volume in many jurisdictions; earnings are driven by capital investment (rate base) multiplied by an allowed return on equity (ROE).
- Competitive Position: Monopoly provider in its regulated service territories; 19th largest US investor-owned electric utility by customer base.
- Recent Major Events: Sold its Louisiana and Mississippi natural gas local distribution company (LDC) businesses for $1.2 billion (closed Q1 2025); announced the sale of its Ohio natural gas utility for $2.62 billion (expected close Q4 2026); increased its 10-year capital plan to $65.5 billion to support a projected 50% increase in Houston electric peak load by 2029.
The downloadable CenterPoint 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 & AssumptionsCenterPoint Energy financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $8.26B | $9.33B | $8.61B | $8.55B | $9.34B |
| Gross profit | $8.05B | $9.12B | $8.51B | $8.55B | $9.33B |
| Operating income | $1.36B | $1.57B | $1.76B | $1.99B | $2.11B |
| Net income | $1.49B | $1.06B | $917.0M | $1.02B | $1.05B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for CenterPoint Energy
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Electric
- Segment Name: Electric
- Revenue Driver Formula: (Average Rate Base x Equity Thickness x Allowed ROE) + Cost of Debt + Recoverable O&M + Depreciation + Taxes + Pass-Through Fuel Costs
- Historical Growth Rate: 8-10% CAGR (excluding pass-through fuel volatility).
- Key Growth Levers and Headwinds: Driven by massive load growth in the Houston area (data centres, advanced manufacturing) and grid resiliency investments. Headwinds include regulatory pushback on rate increases and storm-related damage.
- Pricing Dynamics: Regulated by the Public Utility Commission of Texas (PUCT) and Indiana Utility Regulatory Commission (IURC).
- Revenue Recognition Notes: Billed monthly based on meter readings; unbilled revenue is accrued at month-end. Fuel costs are a direct pass-through with zero margin impact.
- Seasonality: Highly seasonal. Q3 is the strongest quarter due to summer cooling demand in Texas.
Natural Gas
- Segment Name: Natural Gas
- Revenue Driver Formula: (Average Rate Base x Equity Thickness x Allowed ROE) + Cost of Debt + Recoverable O&M + Depreciation + Taxes + Pass-Through Gas Costs
- Historical Growth Rate: 2-4% CAGR (adjusting for recent divestitures).
- Key Growth Levers and Headwinds: Driven by pipeline replacement programmes and system modernisation. Headwinds include electrification trends and mild winter weather.
- Pricing Dynamics: Regulated by state commissions (e.g., Minnesota PUC, PUCT).
- Revenue Recognition Notes: Purchased gas costs are passed directly to customers.
- Seasonality: Highly seasonal. Q1 and Q4 are the strongest quarters due to winter heating demand in the Midwest.
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: Natural gas purchased, Fuel and purchased power.
- Gross margin range: Not a relevant metric for utilities due to pass-through fuel costs. Analysts focus on "Gross Margin excluding fuel" or Operating Margin, which typically ranges from 20% to 25%.
- Key input costs: Natural gas prices and wholesale electricity prices, which are passed through to customers via riders.
- How COGS scales: Scales directly with commodity prices and weather-driven volume, but has zero impact on net income.
Operating Expenses
- Operation and Maintenance (O&M): Labour, vegetation management, grid repairs, and corporate overhead. Typically grows at or below the rate of inflation (2-3% annually).
- Depreciation & Amortisation: Extremely high (approx. 15-20% of revenue) due to the capital-intensive nature of utility infrastructure.
- Taxes other than income taxes: Property taxes and franchise fees, which scale with asset growth and revenue.
- Restructuring / one-time charges: Frequent adjustments for storm cost securitisation and transaction costs related to LDC divestitures.
Margin Profile
- Operating Margin: 20-25% historically.
- Net Margin: 10-12% historically.
- Margin trend: Stable to slightly expanding as the company aggressively deploys capital into its rate base while keeping O&M growth flat.
Balance Sheet Structure
- Total assets: Approximately $40 billion.
- Key asset categories: Property, Plant and Equipment (PP&E) makes up over 70% of total assets. Regulatory Assets (deferred fuel costs, storm recovery costs) are also highly material.
- Goodwill & intangibles: Minimal, typically less than 5% of assets.
- Working capital profile:
- DSO: 30-45 days.
- DIO: 15-25 days (natural gas in storage).
- DPO: 30-45 days.
- Net working capital: Typically negative or near zero. Utilities do not fund growth from working capital; they fund it through external capital markets.
- PP&E: Consists of electric transmission lines, distribution poles, substations, and natural gas pipelines. Depreciated over 30 to 50 years.
- Right-of-use assets: Immaterial compared to PP&E.
Capital Expenditure & Investment
- Capex as % of revenue: 50-60% (utilities are extremely capital intensive).
- Maintenance vs. growth: Approximately 30% maintenance, 70% growth and modernisation.
- Major capex programmes: $65.5 billion 10-year plan (2026-2035), including a new 765 kV import line in Texas and systemwide resiliency upgrades.
- Capitalised software: Immaterial relative to hard infrastructure.
- M&A pattern: Currently a net seller of assets (divesting Louisiana, Mississippi, and Ohio gas LDCs) to fund organic electric rate base growth in Texas.
Debt & Capital Structure
- Total debt: Approximately $18 to $20 billion.
- Debt/EBITDA ratio: 5.0x to 5.5x (standard for regulated utilities).
- Credit rating: Baa2 (Moody's) / BBB (S&P).
- Key debt instruments: First mortgage bonds (secured by utility assets), holding company senior notes, and non-recourse securitisation bonds (for storm costs).
- Maturity profile: Laddered long-term maturities, average life of 10+ years.
- Interest rate profile: Predominantly fixed rate.
- Covenants: FFO to Debt target of 14% to 15% to maintain current credit ratings.
- Share repurchase programme: Inactive. The company issues equity (via ATM and forward contracts) to fund its massive capex plan.
- Dividend policy: 60-70% payout ratio of non-GAAP EPS, growing at 8-9% annually.
Cash Flow Characteristics
- Operating cash flow conversion: OCF is typically 2.0x to 2.5x Net Income due to massive non-cash depreciation and deferred taxes.
- Free cash flow margin: Deeply negative. The company spends significantly more on capex than it generates in OCF.
- Major non-cash items: Depreciation, deferred income taxes, and equity earnings from unconsolidated affiliates.
- Working capital cash flow impact: Highly seasonal due to winter gas purchases, but neutral over a full year.
- Capex intensity: $5.4 billion spent in 2025; planned $6.8 billion in 2026.
- Cash tax rate: Near zero. The company utilises accelerated depreciation and alternative minimum tax credits, pushing cash taxes far below the statutory rate.
Sheet Structure
- Assumptions: Hardcoded drivers for rate base growth, ROE, cost of debt, and capex.
- Scenarios: Base, Bull (higher load growth), and Bear (regulatory lag) toggles.
- Income Statement: Segmented revenue (Electric, Natural Gas), pass-through fuel costs, O&M, D&A, and interest expense.
- Balance Sheet: PP&E, Regulatory Assets, Securitisation Debt, and Equity.
- Cash Flow Statement: OCF, Investing (Capex, Asset Sales), and Financing (Debt issuance, Equity issuance, Dividends).
- Rate Base & Capex Schedule: Roll-forward of Electric and Natural Gas rate base (Beginning Balance + Capex - D&A = Ending Balance).
- Debt & Interest Schedule: Tranches of first mortgage bonds, revolver draw, and securitisation debt.
- Regulatory & Securitisation: Tracking of storm cost recovery bonds and deferred fuel balances.
- DCF Valuation: Unlevered free cash flow, terminal value, and WACC calculation.
- EPS & Dividend Output: Non-GAAP EPS calculation, dividend payout ratio, and FFO/Debt credit metric tracking.
Key Financial Relationships
- "Electric Rate Base (End of Period) = Electric Rate Base (Beginning) + Electric Capex - Electric D&A"
- "Natural Gas Rate Base (End of Period) = Natural Gas Rate Base (Beginning) + Natural Gas Capex - Natural Gas D&A"
- "Electric Operating Income = Average Electric Rate Base * Allowed Electric ROE * Equity Thickness"
- "Natural Gas Operating Income = Average Natural Gas Rate Base * Allowed Natural Gas ROE * Equity Thickness"
- "Total Revenue = Electric Revenue + Natural Gas Revenue"
- "Electric Revenue = Electric Operating Income + Electric Interest Expense + Electric O&M + Electric D&A + Electric Taxes + Pass-Through Fuel"
- "Funds From Operations (FFO) = Net Income + D&A + Deferred Income Taxes"
- "FFO to Debt Ratio = FFO / Average Total Debt"
- "Dividends Paid = Prior Year Non-GAAP EPS * Target Payout Ratio * Shares Outstanding"
- "External Financing Need = Cash Flow from Operations + Cash Flow from Investing - Dividends Paid"
- "New Equity Issued = External Financing Need * Target Equity Thickness"
- "New Debt Issued = External Financing Need * Target Debt Thickness"
Cross-Sheet Dependencies
The Rate Base & Capex Schedule is the engine of the model. It feeds PP&E on the Balance Sheet, D&A on the Income Statement, and Operating Income on the Income Statement. Net Income feeds the Cash Flow Statement, which calculates the External Financing Need. This shortfall feeds the Debt & Interest Schedule and Equity Issuance lines. The new debt balance feeds Interest Expense on the Income Statement, creating a circular reference that must be managed with a toggle.
Sign Convention
- Revenue, operating income, and net income are positive.
- Expenses (O&M, D&A, Interest, Taxes) are negative.
- Capital expenditures and dividends paid are negative.
- Debt issuance and equity issuance are positive.
- Balance sheet assets, liabilities, and equity are positive.
Things Most Likely to Go Wrong
- Modelling fuel costs as a margin driver. Fuel is a strict pass-through; an increase in natural gas prices inflates revenue and COGS equally but does not increase operating income.
- Failing to remove the Ohio, Louisiana, and Mississippi gas LDCs from future projections. The model must account for the lost earnings and the cash proceeds from these divestitures.
- Miscalculating the FFO to Debt ratio. Rating agencies exclude non-recourse securitisation debt from this calculation; the model must separate corporate debt from storm recovery bonds.
- Ignoring regulatory lag. Utilities rarely earn their exact allowed ROE due to the delay between spending capital and getting it approved in a rate case. The model should apply an "earned ROE" discount (e.g., 50-100 bps below allowed ROE).
- Overestimating cash taxes. Accelerated depreciation generates massive deferred tax liabilities; cash taxes are negligible.
- Circularity in the financing schedule. The model must use an interest switch to break the loop between debt issuance, interest expense, and net income.
- Misaligning equity issuance. CenterPoint issues equity to maintain its 50/50 capital structure as rate base grows; failing to model this will artificially inflate leverage and EPS.
- Forgetting the Allowance for Funds Used During Construction (AFUDC), which flatters net income but does not provide immediate cash flow.
Validation Checks
- "FFO to Debt must remain between 13.5% and 15.0%; flag if it drops below 13.0% (downgrade risk)."
- "Electric Rate Base CAGR should be approximately 10-11% based on management guidance."
- "Dividend payout ratio must remain between 60% and 70% of non-GAAP EPS."
- "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
- "Effective tax rate should be 15-20%, but cash tax rate should be less than 5%."
- "Earned ROE should not exceed the allowed ROE of 9.8% (Electric) and 9.5% (Gas)."
- "Total Capex for 2026-2035 must sum to approximately $65.5 billion."
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Electric Rate Base CAGR | 11.0 | % | Management guidance driven by Houston load growth |
| Natural Gas Rate Base CAGR | 4.0 | % | Historical average for remaining gas jurisdictions |
| Allowed ROE (Electric) | 9.8 | % | Recent Indiana rate case settlement and Texas average |
| Allowed ROE (Natural Gas) | 9.5 | % | Blended average of state jurisdictions |
| Target Equity Thickness | 50.0 | % | Standard regulatory capital structure |
| Target Debt Thickness | 50.0 | % | Standard regulatory capital structure |
| Cost of New Debt | 5.5 | % | Current yield on utility first mortgage bonds |
| O&M Annual Growth | 2.0 | % | Management target to keep O&M growth below inflation |
| Effective Tax Rate | 18.0 | % | Historical average reflecting tax credits |
| Dividend Payout Ratio | 65.0 | % | Midpoint of management's target policy |
| 2026 Total Capex | 6.8 | $ Billions | Management guidance for 2026 |
| FFO to Debt Target | 14.0 | % | Moody's downgrade threshold cushion |
| WACC | 6.5 | % | Blended cost of capital for regulated utilities |
| Terminal Growth Rate | 2.5 | % | Long-term inflation and population growth |
Data Sources & Benchmarks
- Filings: SEC EDGAR (CenterPoint Energy Inc. 10-K, 8-K for LDC sales).
- Presentations: CenterPoint Investor Relations (Q4 2025 Earnings Presentation, Systemwide Resiliency Plan filings).
- Peers for Benchmarking: Sempra Energy (SRE), WEC Energy Group (WEC), Xcel Energy (XEL), CMS Energy (CMS).
- Industry Data: Public Utility Commission of Texas (PUCT) dockets, ERCOT load forecast reports.
Sources
Do more with the CenterPoint Energy model
Frequently asked
What does CenterPoint Energy do?+
CenterPoint Energy is a public utility holding company that operates regulated electric transmission and distribution systems, and natural gas distribution systems across several US states. The company provides electric services primarily to the Houston area and southwestern Indiana, and natural gas distribution in Indiana, Ohio, Minnesota, and Texas.
How does CenterPoint Energy generate revenue?+
CenterPoint Energy's earnings are primarily driven by a regulated return on its infrastructure investments, known as its rate base. As a regulated utility, its revenue is often decoupled from volume, with earnings tied to capital investment multiplied by an allowed return on equity.
What are CenterPoint Energy's capital expenditure plans?+
CenterPoint Energy has a substantial $65.5 billion 10-year capital expenditure plan from 2026-2035, with approximately 70% allocated to growth and modernization. This includes major projects like a new 765 kV import line in Texas and systemwide resiliency upgrades.
What are the key financial assumptions in a CenterPoint Energy financial model?+
Key financial assumptions in a CenterPoint Energy model include a revenue growth rate of approximately 3.5% and a high capital expenditure as a percentage of revenue, around 40%. Other important assumptions cover COGS, SGA, D&A, and tax rates, reflecting its regulated utility nature.
How is CenterPoint Energy's equity valuation determined?+
CenterPoint Energy's equity valuation is determined by evaluating its rate base growth, capital expenditure recovery, and dividend sustainability. The model also assesses its credit profile as a regulated multi-utility.
Can I download a financial model for CenterPoint Energy?+
Yes, a downloadable Excel financial model is available for CenterPoint Energy. This model evaluates the company's financial performance and forecasts key metrics through FY2030.
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.

CMS Energy
CMS Energy Corporation is a multi-utility holding company based in Jackson, Michigan.

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.



