CenterPoint Energy logo
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.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

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 model

Source: SEC EDGAR · values in USD

Line itemFY2021FY2022FY2023FY2024FY2025
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.

Revenue growth
3.5%
COGS % of revenue
2.6%
R&D % of revenue
0.0%
SG&A % of revenue
15.0%
D&A % of revenue
15.7%
Effective tax rate
15.0%
See 8 more
Capex % of revenue
40.0%
Net working capital % of revenue
3.9%
Other assets % of revenue
131.4%
Other liabilities % of revenue
152.6%
Annual debt paydown
5.0%
Interest rate on debt
4.5%
Dividend payout ratio
48.8%
Buybacks % of net income
0.0%

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

  1. Assumptions: Hardcoded drivers for rate base growth, ROE, cost of debt, and capex.
  2. Scenarios: Base, Bull (higher load growth), and Bear (regulatory lag) toggles.
  3. Income Statement: Segmented revenue (Electric, Natural Gas), pass-through fuel costs, O&M, D&A, and interest expense.
  4. Balance Sheet: PP&E, Regulatory Assets, Securitisation Debt, and Equity.
  5. Cash Flow Statement: OCF, Investing (Capex, Asset Sales), and Financing (Debt issuance, Equity issuance, Dividends).
  6. Rate Base & Capex Schedule: Roll-forward of Electric and Natural Gas rate base (Beginning Balance + Capex - D&A = Ending Balance).
  7. Debt & Interest Schedule: Tranches of first mortgage bonds, revolver draw, and securitisation debt.
  8. Regulatory & Securitisation: Tracking of storm cost recovery bonds and deferred fuel balances.
  9. DCF Valuation: Unlevered free cash flow, terminal value, and WACC calculation.
  10. EPS & Dividend Output: Non-GAAP EPS calculation, dividend payout ratio, and FFO/Debt credit metric tracking.

Key Financial Relationships

  1. "Electric Rate Base (End of Period) = Electric Rate Base (Beginning) + Electric Capex - Electric D&A"
  2. "Natural Gas Rate Base (End of Period) = Natural Gas Rate Base (Beginning) + Natural Gas Capex - Natural Gas D&A"
  3. "Electric Operating Income = Average Electric Rate Base * Allowed Electric ROE * Equity Thickness"
  4. "Natural Gas Operating Income = Average Natural Gas Rate Base * Allowed Natural Gas ROE * Equity Thickness"
  5. "Total Revenue = Electric Revenue + Natural Gas Revenue"
  6. "Electric Revenue = Electric Operating Income + Electric Interest Expense + Electric O&M + Electric D&A + Electric Taxes + Pass-Through Fuel"
  7. "Funds From Operations (FFO) = Net Income + D&A + Deferred Income Taxes"
  8. "FFO to Debt Ratio = FFO / Average Total Debt"
  9. "Dividends Paid = Prior Year Non-GAAP EPS * Target Payout Ratio * Shares Outstanding"
  10. "External Financing Need = Cash Flow from Operations + Cash Flow from Investing - Dividends Paid"
  11. "New Equity Issued = External Financing Need * Target Equity Thickness"
  12. "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)

AssumptionDefault ValueUnitRationale
Electric Rate Base CAGR11.0%Management guidance driven by Houston load growth
Natural Gas Rate Base CAGR4.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 Thickness50.0%Standard regulatory capital structure
Target Debt Thickness50.0%Standard regulatory capital structure
Cost of New Debt5.5%Current yield on utility first mortgage bonds
O&M Annual Growth2.0%Management target to keep O&M growth below inflation
Effective Tax Rate18.0%Historical average reflecting tax credits
Dividend Payout Ratio65.0%Midpoint of management's target policy
2026 Total Capex6.8$ BillionsManagement guidance for 2026
FFO to Debt Target14.0%Moody's downgrade threshold cushion
WACC6.5%Blended cost of capital for regulated utilities
Terminal Growth Rate2.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

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

Alex Tapio, ex-Deloitte financial modelling expert

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!

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview