# CenterPoint Energy (CNP) Financial Model Free Excel 3-statement financial model and company analysis for CenterPoint Energy. - Canonical: https://finamodel.com/companies/centerpoint-energy - Industry: Utilities - Downloadable model: Yes - Excel download: https://finamodel.com/company-models/CNP.xlsx ## Model Purpose 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. ## Company Overview 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. ## 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) | 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 - CenterPoint Energy Q4 2025 Earnings Release and Investor Presentation (centerpointenergy.com) - CenterPoint Energy 2024 Annual Report on Form 10-K (sec.gov) - Indiana Utility Regulatory Commission (IURC) Rate Case Settlements - Seeking Alpha: CenterPoint Energy Analysis and Financial Summaries --- ## Frequently asked questions ### 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. [Interactive forecast calculator](https://finamodel.com/companies/centerpoint-energy/forecast)