Constellation Energy logo
Constellation Energy Financial Model

Utilities Company Financials Example (Free Excel Download)

Constellation Energy Corporation (CEG) is the largest producer of carbon-free energy in the United States and a leading competitive retail energy supplier.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

This model evaluates the long-term equity valuation and free cash flow generation of Constellation Energy Corporation, focusing specifically on the impact of the pending Calpine acquisition, the Crane Clean Energy Center restart, and the downside protection offered by the Inflation Reduction Act's nuclear production tax credits.

Constellation Energy Corporation (CEG) is the largest producer of carbon-free energy in the United States and a leading competitive retail energy supplier. The company operates a massive fleet of nuclear, natural gas, hydro, wind, and solar facilities with approximately 55 gigawatts of capacity, serving commercial, industrial, public sector, and residential customers.

The business reports revenue across five regional segments: Mid-Atlantic, Midwest, New York, ERCOT, and Other Power Regions. The business model is highly asset-heavy, relying on the efficient baseload operation of its nuclear fleet, paired with a customer-facing commercial business that hedges generation output. Constellation holds a dominant competitive position in the US nuclear industry and is a primary beneficiary of growing data centre power demand. Recent major events include the 2022 spin-off from Exelon, the early 2025 announcement to acquire Calpine Corporation, and the planned 2027 restart of the Crane Clean Energy Center (formerly Three Mile Island Unit 1) backed by a 20-year power purchase agreement with Microsoft and a $1 billion Department of Energy loan.

The downloadable Constellation 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 & AssumptionsConstellation Energy financial model

Source: SEC EDGAR · values in USD

Line itemFY2021FY2022FY2023FY2024FY2025
Revenue$17.25B$21.57B$20.84B$18.96B$22.66B
Total operating expenses$20.20B$23.95B$23.34B$19.29B$22.45B
Operating income-$346.0M$495.0M$1.61B$4.35B$3.09B
Net income-$205.0M-$160.0M$1.62B$3.75B$2.32B

How to build a detailed financial model for Constellation Energy

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

Revenue Deep Dive

Constellation disaggregates revenue primarily by regional power markets.

  • Mid-Atlantic
  • *Revenue driver formula:* Mid-Atlantic Volumes (TWh) x Average Realised Price ($/MWh) + Capacity Revenues.
  • *Historical growth rate:* 4-6% CAGR, driven by rate base and capacity market pricing.
  • *Key growth levers and headwinds:* PJM capacity auction clearing prices, data centre load growth in Virginia/Maryland, and transmission congestion.
  • *Pricing dynamics:* Highly dependent on PJM wholesale power prices and capacity market auctions, though heavily hedged forward.
  • *Seasonality:* Peaks in Q3 (summer cooling) and Q1 (winter heating).
  • Midwest
  • *Revenue driver formula:* Midwest Volumes (TWh) x Average Realised Price ($/MWh) + Zero Emission Credits (ZECs) / Carbon Mitigation Credits (CMCs).
  • *Historical growth rate:* 2-4% CAGR.
  • *Key growth levers and headwinds:* State-level nuclear subsidies (ZECs/CMCs) and transition to federal Production Tax Credits (PTCs).
  • *Pricing dynamics:* Regulated subsidy floors combined with wholesale market pricing.
  • *Seasonality:* Strong winter and summer peaks.
  • New York
  • *Revenue driver formula:* NY Volumes (TWh) x Average Realised Price ($/MWh) + ZECs.
  • *Historical growth rate:* 1-3% CAGR.
  • *Key growth levers and headwinds:* NYISO market dynamics and state clean energy mandates.
  • *Pricing dynamics:* Spot market pricing supported by state-level ZECs.
  • *Seasonality:* Winter heating demand is a significant driver.
  • ERCOT (Texas)
  • *Revenue driver formula:* ERCOT Volumes (TWh) x Average Realised Price ($/MWh).
  • *Historical growth rate:* 5-8% CAGR (highly volatile).
  • *Key growth levers and headwinds:* Extreme weather events, population growth, and grid reliability scarcity pricing.
  • *Pricing dynamics:* Energy-only market with no capacity payments; highly volatile spot pricing.
  • *Seasonality:* Extreme summer peak (Q3).
  • Other Power Regions
  • *Revenue driver formula:* Volumes (TWh) x Average Realised Price ($/MWh).
  • *Historical growth rate:* 2-5% CAGR.
  • *Key growth levers and headwinds:* Expansion into New England, South, and West markets.

*Revenue Recognition Notes:* Revenue from power sales is recognised upon delivery to the grid or customer. The company also records significant unrealised mark-to-market gains and losses on economic hedges, which must be stripped out to assess core operating performance.

Cost Structure

Variable Costs / COGS

  • *Line items:* Purchased power, fuel (including nuclear fuel amortisation and natural gas purchases), and transmission/distribution costs.
  • *Gross margin range:* Constellation focuses on "Gross Margin" (Revenues less Purchased Power and Fuel), which typically runs between 25% and 35% depending on commodity price volatility.
  • *Key input costs:* Uranium/nuclear fuel assemblies, natural gas, and wholesale power purchases to meet retail load obligations.
  • *Scaling:* Fuel costs scale linearly with generation, while purchased power scales with retail load obligations that exceed generation.

Operating Expenses

  • *Operating and Maintenance (O&M):* The largest fixed cost, covering plant labour, routine maintenance, and refuelling outage costs. Runs at roughly 15-20% of revenue.
  • *Depreciation & Amortisation:* High due to the asset-heavy nuclear fleet; typically 5-7% of beginning net PP&E.
  • *Taxes other than income:* Property taxes and gross receipts taxes.
  • *Restructuring / one-time charges:* Decommissioning-related activities and ERP system implementation costs occur frequently and are adjusted out of non-GAAP earnings.

Margin Profile

  • *EBITDA margin:* 15-22% historically.
  • *Operating margin:* 8-12%.
  • *Margin trend:* Expanding due to the implementation of the Inflation Reduction Act PTC floor, which protects downside while allowing upside participation, alongside strong operational execution (nuclear capacity factors >94%).

Balance Sheet Structure

  • *Total assets:* Approximately $50 billion to $55 billion.
  • *Key asset categories:* Property, Plant, and Equipment (PP&E) makes up the bulk of assets. Nuclear Decommissioning Trust (NDT) funds are also highly material (often exceeding $10 billion).
  • *Goodwill & intangibles:* Historically moderate, but will increase significantly following the Calpine acquisition.
  • *Working capital profile:*
  • *DSO:* 35-45 days.
  • *DPO:* 30-40 days.
  • *Net working capital:* Can swing wildly based on collateral postings for hedging activities and derivative mark-to-market positions.
  • *PP&E:* Primarily generation assets. Nuclear fuel is capitalised and amortised to fuel expense as it is consumed in the reactor.
  • *Asset Retirement Obligations (AROs):* Massive liability representing the future cost of decommissioning nuclear plants, offset by the NDT assets.

Capital Expenditure & Investment

  • *Capex as % of revenue:* Typically 12-16%.
  • *Maintenance vs. growth:* Approximately 35% of capex is dedicated to nuclear fuel acquisition. The remainder is split between base plant maintenance, nuclear uprates, and specific growth projects.
  • *Major programmes:* The Crane Clean Energy Center restart (estimated at over $1 billion, supported by DOE loans) and integration of Calpine assets.
  • *M&A pattern:* Historically organic and spin-off driven, but the 2025 Calpine acquisition marks a transformational shift to acquire dispatchable natural gas and expand the retail footprint.

Debt & Capital Structure

  • *Total debt:* Approximately $7 billion to $9 billion pre-Calpine.
  • *Credit rating:* Investment grade (Baa2/BBB).
  • *Key debt instruments:* Senior unsecured notes, term loans, and a revolving credit facility. The DOE loan for the Crane restart will add specific project-level debt.
  • *Maturity profile:* Near-term maturities include roughly $1.03 billion in 2025 and $691 million in 2027.
  • *Interest rate profile:* Predominantly fixed-rate bonds.
  • *Share repurchase programme:* Highly active, returning excess free cash flow to shareholders.
  • *Dividend policy:* Base dividend policy targeting approximately 10% annual growth.

Cash Flow Characteristics

  • *Operating cash flow conversion:* Very strong; OCF often exceeds Net Income due to heavy depreciation, nuclear fuel amortisation, and non-cash mark-to-market derivative losses.
  • *Free cash flow margin:* 10-15% of revenue. In 2024, the company generated over $3.7 billion in free cash flow.
  • *Major non-cash items:* Depreciation, amortisation of nuclear fuel, unrealised fair value adjustments on derivatives, and NDT fund investment returns.
  • *Working capital impact:* Collateral requirements for hedging can cause significant year-to-year cash flow volatility.
  • *Cash tax rate:* Often differs from the GAAP effective tax rate due to the utilisation of PTCs and accelerated depreciation.

Sheet Structure

  1. Assumptions: Hardcoded drivers for macro variables, power prices, capacity factors, and segment growth.
  2. Scenarios: Toggles for the Calpine acquisition close date, Crane Clean Energy Center restart timing, and PTC floor pricing.
  3. Generation & Fleet Operations: Calculates TWh generated by region, factoring in planned refuelling outage days and capacity factors.
  4. Revenue Build: Calculates revenue for Mid-Atlantic, Midwest, New York, ERCOT, and Other based on volumes and realised pricing.
  5. Fuel & Purchased Power: Calculates nuclear fuel amortisation, natural gas costs, and wholesale power purchases.
  6. Income Statement: Consolidated view from Revenue down to GAAP Net Income and Adjusted (non-GAAP) Operating Earnings.
  7. Balance Sheet: Standard assets, liabilities, and equity, with specific breakouts for NDT funds and AROs.
  8. Cash Flow Statement: Bridges Net Income to OCF, CFI, and CFF.
  9. Debt Schedule: Tranches of senior notes, DOE loan drawdowns, and interest expense calculation.
  10. NDT & ARO Schedule: Rolls forward the Nuclear Decommissioning Trust assets and Asset Retirement Obligation liabilities.
  11. DCF Valuation: Unlevered free cash flow calculation, WACC, and terminal value.

Key Financial Relationships

  1. `Mid-Atlantic Revenue = Mid-Atlantic Volume (TWh) x Mid-Atlantic Realised Price ($/MWh) + Mid-Atlantic Capacity Revenue`
  2. `Total Generation (TWh) = Total Fleet Capacity (MW) x 8760 hours x Average Fleet Capacity Factor (%) / 1,000,000`
  3. `Nuclear Fuel Expense = Beginning Capitalised Nuclear Fuel + Fuel Purchases - Ending Capitalised Nuclear Fuel`
  4. `Gross Margin = Total Operating Revenues - Purchased Power - Fuel`
  5. `Adjusted Operating Earnings = GAAP Net Income - Unrealised Fair Value Adjustments - Decommissioning-Related Activities - Plant Retirements/Divestitures`
  6. `NDT Ending Balance = NDT Beginning Balance + Contributions + Realised/Unrealised Investment Returns - Decommissioning Spend`
  7. `ARO Ending Balance = ARO Beginning Balance + Accretion Expense + Revisions in Estimates - Liabilities Settled`
  8. `Free Cash Flow = Operating Cash Flow - Capital Expenditures (including nuclear fuel)`
  9. `Effective Tax Rate = Income Tax Expense / Income Before Income Taxes` (Adjusted for PTCs)
  10. `Interest Expense = Average Long-Term Debt x Weighted Average Interest Rate`

Cross-Sheet Dependencies

  • Generation & Fleet Operations is the foundational sheet. It feeds volumes into the Revenue Build and fuel consumption into the Fuel & Purchased Power sheet.
  • The Revenue Build and Fuel & Purchased Power sheets feed directly into the Income Statement to calculate Gross Margin.
  • The NDT & ARO Schedule calculates non-cash accretion and investment returns, which feed into the Income Statement (Other Income/Expense) and the Cash Flow Statement (non-cash adjustments).
  • The Debt Schedule creates a circularity: Interest expense reduces Net Income, which reduces Cash, which dictates the need for revolver borrowing, which in turn increases Interest Expense. A circuit breaker toggle is required.

Sign Convention

  • Revenues and income items are positive.
  • Expenses and cash outflows (including capex and dividends) are negative.
  • Assets are positive.
  • Liabilities and Equity are positive.
  • In the Cash Flow Statement, an increase in an asset is negative, and an increase in a liability is positive.

Things Most Likely to Go Wrong

  • Failing to adjust GAAP Net Income for unrealised mark-to-market gains/losses on economic hedges; this is the most critical adjustment for utility earnings quality.
  • Mismodelling the Inflation Reduction Act PTC floor. The model must calculate whether market prices fall below the inflation-adjusted floor to trigger the tax credit.
  • Treating nuclear fuel purchases as a standard operating expense rather than capitalising them into PP&E and amortising them based on reactor consumption.
  • Ignoring the impact of planned refuelling outage days on both generation volume and O&M costs (outage years have higher O&M).
  • Mishandling the tax treatment of NDT funds; qualified and non-qualified funds are taxed at different rates (often resulting in a blended ~54% effective tax rate on NDT returns).
  • Failing to include the pro-forma financial impact of the Calpine acquisition, which fundamentally alters the generation mix and debt profile.
  • Double-counting capacity revenues and energy revenues in regions like ERCOT, which is an energy-only market with no capacity payments.
  • Misaligning the timing of the Crane Clean Energy Center restart (2027) and the associated Microsoft PPA cash flows.

Validation Checks

  • Adjusted Operating Earnings per share should align with management's 2025 guidance range of $9.05 to $9.45.
  • Nuclear fleet capacity factor should consistently model above 94% based on historical operational excellence.
  • Free Cash Flow should remain robust, typically exceeding $3 billion annually pre-Calpine integration.
  • The NDT fund balance should roughly equal or exceed the ARO liability balance, indicating fully funded decommissioning obligations.
  • Total Assets must equal Total Liabilities plus Equity in every period.
  • The effective tax rate on core operations should be approximately 25.5%, excluding NDT-specific tax impacts.
  • Capex should spike in 2025/2026 to roughly $3.0 billion to $3.5 billion to account for the Crane restart and nuclear fuel purchases.

Key Assumptions (Default Values)

AssumptionDefault ValueUnitRationale
Nuclear Fleet Capacity Factor94.5%Historical average demonstrating top-tier operational performance
2025 Total Capex3,250$ MillionsMidpoint of management guidance for 2025/2026 capital program
Nuclear Fuel Capex (% of Total)35.0%Historical average for fuel cycle replenishment
Effective Tax Rate (Core)25.6%Actual reported marginal statutory rate for recent quarters
NDT Investment Return Tax Rate54.9%Blended rate for qualified and non-qualified trust funds
Base Dividend Growth Rate10.0%Management stated target for annual dividend per share growth
Mid-Atlantic Volume Growth2.5%Assumed load growth driven by data centre expansion in PJM
Crane Clean Energy Center Restart2027YearTarget date for Three Mile Island Unit 1 return to service
WACC7.5%Standard utility/IPP discount rate reflecting investment grade debt
Terminal Growth Rate2.0%Long-term inflation alignment for power demand

Data Sources & Benchmarks

  • Filings: SEC EDGAR (Constellation Energy Corporation - CEG), specifically the 2024 10-K and 2025 10-Q filings.
  • Investor Relations: Constellation IR website for the 2025 Business and Earnings Outlook Presentation and Calpine Acquisition Announcement Presentation.
  • Peers for Benchmarking: Vistra Corp (VST), Public Service Enterprise Group (PEG), NRG Energy (NRG), and Talen Energy (TLN).
  • Industry Data: PJM Interconnection capacity auction results, ERCOT load forecasts, and NRC (Nuclear Regulatory Commission) outage reports.

Sources

Frequently asked

What does Constellation Energy do?+

Constellation Energy (CEG) is the largest producer of carbon-free energy in the United States, operating a vast fleet of nuclear, natural gas, hydro, wind, and solar facilities. It also serves as a leading competitive retail energy supplier, primarily relying on efficient baseload nuclear operations and a commercial business that hedges generation output.

How does Constellation Energy generate revenue?+

Constellation Energy disaggregates revenue primarily by regional power markets, such as Mid-Atlantic and Midwest. Revenue drivers include regional volumes multiplied by average realized prices, capacity revenues, and state-level subsidies like Zero Emission Credits (ZECs) or Carbon Mitigation Credits (CMCs).

What are Constellation Energy's typical capital expenditure patterns?+

Constellation Energy's capital expenditure typically ranges from 12-16% of revenue. Approximately 35% of this is dedicated to nuclear fuel acquisition, with the remainder split between base plant maintenance, nuclear uprates, and specific growth projects.

What are the key factors influencing Constellation Energy's long-term equity valuation?+

The long-term equity valuation of Constellation Energy is significantly impacted by the pending Calpine acquisition and the restart of the Crane Clean Energy Center. Additionally, the downside protection offered by the Inflation Reduction Act's nuclear production tax credits is a crucial factor.

Can I download an Excel financial model for Constellation Energy?+

No, an Excel financial model for Constellation Energy is not available for download from this source. The provided context indicates that a downloadable model is not offered.

What major strategic developments has Constellation Energy recently undertaken?+

Recent major developments for Constellation Energy include its 2022 spin-off from Exelon and the early 2025 announcement to acquire Calpine Corporation, marking a transformational shift. The company also plans the 2027 restart of the Crane Clean Energy Center, backed by a 20-year power purchase agreement with Microsoft.

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