Entergy logo
Entergy Financial Model

Utilities Company Financials Example (Free Excel Download)

Entergy Corporation (ETR) is a pure-play regulated electric utility that produces, transmits, and distributes electricity to approximately 3.1 million customers.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

This model evaluates the equity valuation and credit profile of Entergy Corporation by forecasting its rate base growth, capital expenditures, and regulated returns across its five operating jurisdictions to determine if the company can achieve its targeted 8% annual EPS growth.

Entergy Corporation (ETR) is a pure-play regulated electric utility that produces, transmits, and distributes electricity to approximately 3.1 million customers. The company operates primarily in the Gulf South, providing power to industrial, commercial, residential, and governmental customers.

The business is divided into two primary segments: Utility (which accounts for nearly all revenue and earnings) and Parent & Other (which captures corporate debt and holding company costs). Geographically, the company operates through five regulated operating companies: Entergy Arkansas, Entergy Louisiana, Entergy Mississippi, Entergy New Orleans, and Entergy Texas. Entergy operates an asset-heavy business model, earning a regulated return on equity (ROE) on its capital investments (rate base) approved by state and local public utility commissions. The company holds a monopoly position in its regulated service territories but faces benchmarking against other regional utilities. Recently, Entergy completed its exit from the merchant nuclear business (Entergy Wholesale Commodities) to focus entirely on its regulated utility operations and announced a massive $43 billion capital plan for 2026 to 2029 to support unprecedented industrial and data centre load growth.

The downloadable Entergy 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 & AssumptionsEntergy financial model

Source: SEC EDGAR · values in USD

Line itemFY2021FY2022FY2023FY2024FY2025
Revenue$11.74B$13.76B$12.15B$11.88B$12.95B
INCOME BEFORE INCOME TAXES$1.31B$1.06B$1.67B$1.44B$2.27B
Operating income$1.85B$2.05B$2.62B$2.65B$3.20B
Net income$1.12B$1.10B$2.36B$1.06B$1.77B

Forecast assumptions

Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.

Revenue growth
2.8%
COGS % of revenue
55.0%
R&D % of revenue
0.0%
SG&A % of revenue
15.0%
D&A % of revenue
18.1%
Effective tax rate
16.9%
See 8 more
Capex % of revenue
19.3%
Net working capital % of revenue
-14.1%
Other assets % of revenue
495.0%
Other liabilities % of revenue
140.6%
Annual debt paydown
5.0%
Interest rate on debt
3.5%
Dividend payout ratio
59.2%
Buybacks % of net income
0.0%

How to build a detailed financial model for Entergy

A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.

Revenue Deep Dive

Entergy's Utility segment revenue is driven by billed retail sales and wholesale power sales.

  • Residential: Driven by "Number of Customers x Usage per Customer x Residential Rate". This segment is highly weather-sensitive. Historical growth has been flat to 1%, but it provides stable baseline revenue.
  • Commercial: Driven by "Commercial Volume (GWh) x Commercial Rate". Tied to regional economic health and employment.
  • Industrial: Driven by "Industrial Volume (GWh) x Industrial Rate". This is Entergy's primary growth engine, with management projecting up to 15% annual growth driven by Gulf Coast petrochemical expansion, liquefied natural gas (LNG) facilities, and new data centres.
  • Governmental: Driven by "Governmental Volume (GWh) x Governmental Rate". A small, stable contributor.
  • Fuel and Purchased Power Recovery: Driven by actual fuel costs. This is a direct pass-through to customers; it increases revenue but has an equal and offsetting expense in the cost of goods sold, resulting in zero margin impact.

Pricing dynamics are strictly regulated by state utility commissions through base rate cases and formula rate plans (FRPs). Revenue is recognised over time as electricity is delivered. Seasonality is highly pronounced, with the third quarter (July to September) generating the highest revenue and margins due to significant summer cooling demand in the hot and humid Gulf South region.

Cost Structure

Variable Costs / COGS

  • Fuel, fuel-related expenses, and gas purchased for resale: Includes natural gas, nuclear fuel, and coal. This is a direct pass-through to customers.
  • Purchased power: Electricity bought from the Midcontinent Independent System Operator (MISO) market or third parties. Also a pass-through.
  • Gross Margin: Because fuel is a pass-through, gross margin percentage is not a useful metric for utilities. Analysts focus on "Gross Margin Dollars" (Revenue less Fuel and Purchased Power), which represents the revenue available to cover operating expenses and provide a return on capital.

Operating Expenses

  • Other operation and maintenance (O&M): The largest controllable cost. Includes labour, vegetation management, nuclear plant operating costs, and routine maintenance. Entergy targets flat to declining O&M per MWh to offset capital-driven rate increases.
  • Depreciation and amortisation: Extremely high due to the asset-heavy nature of power generation and transmission. Typically runs at 12-15% of total revenue.
  • Taxes other than income taxes: Primarily property taxes on generation and transmission assets, and franchise taxes paid to municipalities.
  • Restructuring / one-time charges: Occasional charges related to storm cost securitisation or regulatory disallowances.

Margin Profile

  • Operating margin typically ranges from 15% to 20%.
  • Net margin typically ranges from 10% to 14%.
  • Margins are structurally protected by formula rate plans that adjust customer rates annually to ensure the company earns its allowed return on equity, though regulatory lag can cause temporary margin compression during periods of high inflation.

Balance Sheet Structure

  • Total Assets: Approximately $65 billion to $70 billion, dominated by physical infrastructure.
  • Property, Plant and Equipment (PP&E): The core of the balance sheet (over $45 billion net). Represents generation plants, transmission lines, and distribution networks. This forms the foundation of the company's "Rate Base", upon which it earns its profit.
  • Regulatory Assets: Significant balances (often $5 billion to $8 billion) representing deferred costs (like storm restoration expenses or deferred fuel costs) that regulators have approved for future recovery from customers.
  • Working Capital: Typically negative or neutral. The company has large receivables from customers and large payables for fuel. Utilities often operate with negative working capital because they can delay payments to suppliers while collecting monthly from customers.
  • Goodwill: Minimal, as growth is primarily organic rather than through corporate acquisitions.

Capital Expenditure & Investment

  • Capex Scale: Extremely high. Entergy plans to spend $43 billion from 2026 through 2029.
  • 2026 Capex: Projected at $11.6 billion, a significant step-up from 2025 levels.
  • Capex Split: Approximately 45% Generation (new combined-cycle gas turbines, solar, and nuclear uprates), 25% Transmission, 25% Distribution, and 5% Utility Support.
  • Growth vs. Maintenance: The vast majority is classified as growth or system hardening (resilience), which is added to the rate base and drives future earnings.
  • M&A Pattern: Entergy is an organic grower. It occasionally acquires individual power plants (e.g., purchasing a newly built solar facility from a developer) but does not typically acquire other corporate entities.

Debt & Capital Structure

  • Total Debt: Highly levered in absolute terms, typical for a regulated utility. Total debt is usually around $25 billion to $30 billion.
  • Credit Metrics: The company targets a Funds From Operations (FFO) to Debt ratio of approximately 15% to 16%, which is required to maintain its investment-grade credit ratings with Moody's and S&P.
  • Debt Instruments: Primarily long-term first mortgage bonds issued at the operating company level (e.g., Entergy Louisiana bonds), supplemented by holding company debt and commercial paper for short-term liquidity.
  • Securitisation Debt: The company often uses storm recovery bonds (securitisation) which are paid off via a dedicated rider on customer bills. Rating agencies often exclude this non-recourse debt from core credit metrics.
  • Equity Issuance: To fund the massive $43 billion capital plan while maintaining its target 50/50 debt-to-equity capital structure, Entergy regularly issues equity through forward equity sales and At-The-Market (ATM) programmes.
  • Dividend Policy: Entergy pays a strong, growing dividend. The payout ratio is typically targeted at 60% to 65% of adjusted earnings per share.

Cash Flow Characteristics

  • Operating Cash Flow (OCF): Very strong and stable, typically $4 billion to $5 billion annually, driven by net income and massive non-cash depreciation add-backs.
  • Free Cash Flow (FCF): Structurally negative. Because annual capex ($8 billion to $11.6 billion) far exceeds operating cash flow, free cash flow is consistently negative.
  • Funding the Gap: The negative free cash flow is funded through continuous issuance of new debt and equity. This is a healthy dynamic for a utility as long as the new capital is deployed into the rate base earning a regulated return.
  • Tax Profile: The cash tax rate is often significantly lower than the GAAP effective tax rate due to accelerated depreciation on massive capital investments and the utilisation of production tax credits (PTCs) from nuclear and renewable generation.

Sheet Structure

  1. Assumptions: Macroeconomic drivers, weather normalisation factors, allowed ROEs by jurisdiction, equity ratio targets, and base rate case timelines.
  2. Volumes & Retail Revenue: GWh sales forecasts broken down by Residential, Commercial, Industrial, and Governmental. Pricing per kWh and total billed retail revenue.
  3. Fuel & Purchased Power: Forecast of commodity costs and the corresponding fuel recovery revenue (ensuring they net to zero impact on gross margin).
  4. O&M & Depreciation: Detailed build of operation and maintenance expenses, taxes other than income, and the depreciation schedule based on useful lives of PP&E.
  5. Rate Base & Capex: The most critical sheet. Roll-forward of PP&E: Beginning Balance + Capex - Depreciation - Deferred Taxes = Ending Rate Base.
  6. Income Statement: Consolidated view mirroring the 10-K, from Total Operating Revenues down to Net Income Attributable to Entergy Corporation.
  7. Balance Sheet: Standard assets, liabilities, and equity, with specific call-outs for Regulatory Assets and Regulatory Liabilities.
  8. Cash Flow Statement: Operating, Investing, and Financing cash flows. Must clearly show the massive capex outflows and the corresponding debt/equity inflows.
  9. Debt & Interest Schedule: Tranches of debt, commercial paper, securitisation bonds, and calculated interest expense.
  10. Valuation & Returns: DCF using a utility-specific WACC, and a Price/Earnings (P/E) multiple valuation based on the 8% EPS growth target.

Key Financial Relationships

  1. Billed Retail Revenue = (Residential GWh x Resi Rate) + (Commercial GWh x Comm Rate) + (Industrial GWh x Ind Rate) + (Governmental GWh x Gov Rate)
  2. Total Operating Revenue = Billed Retail Revenue + Wholesale Revenue + Fuel Recovery Revenue
  3. Gross Margin Dollars = Total Operating Revenue - Fuel and Purchased Power Expense
  4. Ending PP&E = Beginning PP&E + Capital Expenditures - Depreciation Expense
  5. Estimated Rate Base = Net PP&E + Working Capital Allowance - Accumulated Deferred Income Taxes (ADIT)
  6. Operating Income (EBIT) = Estimated Rate Base x Blended Allowed Return on Rate Base (approx. 7.5% to 8.0%)
  7. Interest Expense = Average Total Debt x Weighted Average Cost of Debt
  8. Net Income = Operating Income - Interest Expense - Income Taxes + Allowance for Funds Used During Construction (AFUDC)
  9. Earnings Per Share (EPS) = Net Income Attributable to Entergy / Weighted Average Diluted Shares Outstanding
  10. Dividends Paid = EPS x Target Payout Ratio (approx. 60% to 65%)
  11. Funding Gap (New Capital Required) = Operating Cash Flow - Capital Expenditures - Dividends Paid
  12. New Equity Issued = Funding Gap x Target Equity Capitalisation Ratio (approx. 50%)

Cross-Sheet Dependencies

The model relies on a critical circular chain typical of regulated utilities. The Rate Base & Capex sheet dictates the Depreciation on the O&M & Depreciation sheet and the PP&E on the Balance Sheet. The Rate Base also drives the allowable Operating Income on the Income Statement. Net Income feeds the Cash Flow Statement, which subtracts the massive Capex to reveal the Funding Gap. This Funding Gap feeds the Debt & Interest Schedule and Equity assumptions to balance the cash. The new debt generates Interest Expense, which flows back to the Income Statement, creating a circular reference that must be resolved using an iterative calculation or a circuit breaker toggle.

Sign Convention

  • Revenues and Sales Volumes: Positive.
  • Operating Expenses (O&M, Fuel, Depreciation): Positive inputs, subtracted in subtotal formulas.
  • Capital Expenditures: Positive inputs on the Capex sheet, represented as negative outflows on the Cash Flow Statement.
  • Debt Paydown / Dividends: Negative on the Cash Flow Statement.
  • Accumulated Depreciation: Positive balance on the Balance Sheet, subtracted from Gross PP&E to yield Net PP&E.

Things Most Likely to Go Wrong

  • Mismatched Fuel Pass-Throughs: Failing to perfectly match Fuel Recovery Revenue with Fuel Expense will artificially inflate or deflate operating margins.
  • Ignoring Regulatory Lag: Assuming all Capex immediately earns a return. In reality, Capex only enters the rate base and earns a return after a regulatory rate case or formula rate plan update is approved.
  • Parent & Other Drag: Forgetting to model the holding company debt interest. The Utility segment generates the operating income, but the Parent segment carries debt that drags down consolidated EPS.
  • Weather Normalisation: Forecasting future revenue based on a historically abnormally hot or cold year. Base year volumes must be weather-normalised before applying growth rates.
  • Share Dilution: Failing to increase the share count. Entergy must issue equity to fund its $43 billion capital plan; keeping the share count flat will artificially inflate forecasted EPS.
  • Securitisation Debt Confusion: Including non-recourse storm recovery bonds in the core FFO/Debt calculation, which rating agencies typically exclude.
  • AFUDC Accounting: Mishandling the Allowance for Funds Used During Construction. This is a non-cash income item that represents the return on capital for projects currently under construction, which should be deducted from Net Income to arrive at Operating Cash Flow.

Validation Checks

  • EPS Growth: Implied Adjusted EPS growth should closely track management's guidance of 8% CAGR from 2025 to 2029.
  • FFO to Debt: Must remain between 15% and 17% to align with Moody's and S&P investment-grade thresholds.
  • Capex Totals: The sum of 2026-2029 Capex must equal approximately $43 billion, with 2026 specifically at $11.6 billion.
  • Dividend Payout: The calculated dividend per share divided by EPS should remain in the 60% to 65% historical band.
  • Fuel Margin: (Fuel Recovery Revenue - Fuel Expense) must equal exactly zero in every forecasted period.
  • Balance Sheet: Total Assets must equal Total Liabilities plus Equity in all periods.
  • Industrial Volume Growth: Should reflect the aggressive 10% to 15% growth guidance driven by data centres, significantly outpacing residential growth.

Key Assumptions (Default Values)

AssumptionDefault ValueUnitRationale
Residential Volume Growth1.0%Mature service territory, offset by energy efficiency.
Commercial Volume Growth1.5%Modest regional economic growth.
Industrial Volume Growth10.0%Management guidance for 2026, driven by data centres and Gulf Coast industrial expansion.
Blended Allowed ROE9.8%Typical average across Entergy's five state jurisdictions.
Equity Layer in Rate Base50.0%Standard regulatory capital structure target.
2026 Capital Expenditures11,600$ MillionsManagement guidance for 2026 step-up in investment.
2027-2029 Average Annual Capex10,466$ MillionsRemainder of the $43 billion 4-year plan divided by 3 years.
O&M Expense Growth1.0%Management focus on cost control to offset rate base growth impacts on customer bills.
Effective Tax Rate19.0%Benefits from production tax credits and accelerated depreciation.
Dividend Payout Ratio62.0%Historical average and standard utility sector benchmark.
Cost of Debt (New Issuance)5.5%Current yield on long-term utility first mortgage bonds.
Target FFO / Debt15.5%Midpoint of rating agency downgrade thresholds.

Data Sources & Benchmarks

  • Filings: SEC EDGAR (Form 10-K, 10-Q) and Entergy Investor Relations website for quarterly earnings presentations and the annual Performance Report.
  • Peers: Southern Company (SO), Duke Energy (DUK), NextEra Energy (NEE), and CenterPoint Energy (CNP) for benchmarking valuation multiples and allowed ROEs.
  • Industry Data: U.S. Energy Information Administration (EIA) for retail electricity prices, weather data (cooling degree days), and regional demand forecasts.
  • Regulatory Data: S&P Global Market Intelligence (formerly SNL Energy) for tracking state-level rate cases, allowed ROEs, and regulatory lag across Arkansas, Louisiana, Mississippi, and Texas.

Sources

Frequently asked

What kind of company is Entergy and what services does it provide?+

Entergy Corporation (ETR) is a pure-play regulated electric utility operating primarily in the Gulf South region. It produces, transmits, and distributes electricity to approximately 3.1 million industrial, commercial, residential, and governmental customers across five regulated operating companies.

What are the main drivers of Entergy's revenue growth?+

Entergy's revenue is primarily driven by billed retail sales and wholesale power sales across its customer segments. The industrial segment is a key growth engine, projected to grow up to 15% annually due to Gulf Coast petrochemical expansion, LNG facilities, and new data centers. Residential and commercial sales also contribute, influenced by customer usage, regional economic health, and weather.

What is Entergy's capital expenditure strategy and how does it impact the financial model?+

Entergy has an extremely high capital expenditure plan, projecting to spend $43 billion from 2026 through 2029, with $11.6 billion allocated for 2026 alone. The majority of this spending is for growth and system hardening, which is added to the rate base and drives future earnings, making it a critical input for the financial model's valuation.

How does Entergy's regulated business model influence its valuation?+

Entergy operates an asset-heavy, regulated utility business model where it earns a regulated return on equity (ROE) on its capital investments, known as its rate base. This stable, predictable earnings stream, approved by state and local public utility commissions, provides a foundational input for valuation models like a Discounted Cash Flow (DCF) analysis.

Can I download an Excel financial model for Entergy to analyze its forecasts?+

Yes, an Excel financial model for Entergy is available for download, allowing users to analyze its forecasts. This model evaluates the company's equity valuation and credit profile by forecasting rate base growth, capital expenditures, and regulated returns through FY2030.

What are Entergy's key financial targets and how are they reflected in its business strategy?+

Entergy aims to achieve an 8% annual EPS growth, which is a central focus of its business strategy. This target is supported by its massive $43 billion capital plan for 2026-2029, primarily directed towards expanding its regulated utility operations and growing its rate base.

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