Xcel Energy Financial Model

• Total assets: Approximately $65 billion to $70 billion.
• Key asset categories: Property, Plant and Equipment (PP&E) makes up over 70% of total assets. Regulatory Assets (costs deferred for future recovery from customers) are also highly material.
• Goodwill & intangibles: Minimal (less than 5% of assets), as growth is primarily organic rather than through M&A.
• Working capital profile:
• Days Sales Outstanding (DSO): 35-45 days.
• Days Inventory Outstanding (DIO): 20-30 days (primarily fuel inventory).
• Days Payable Outstanding (DPO): 35-45 days.
• Net working capital as % of revenue: Typically negative or near zero. Utilities do not rely on working capital to fund growth.
• PP&E: Consists of generation plants (wind, solar, natural gas, nuclear, coal), transmission lines, and distribution networks. Useful lives range from 10 to 60 years.
• Right-of-use assets: Material but small relative to owned PP&E, primarily related to office leases and certain equipment.

• Capex as % of revenue: 45-55% (extremely high, characteristic of the utility sector).
• Maintenance capex vs. growth capex: Approximately 30% maintenance, 70% growth (driven by the clean energy transition).
• Major capex programmes underway: The 2025-2029 base capital forecast is approximately $39 billion. This includes major investments in transmission (e.g., Colorado Power Pathway), renewable generation (Sherco Solar facility), and distribution grid modernisation.
• Capitalised software: Minor relative to hard infrastructure.
• M&A pattern: Purely organic grower. The company focuses on investing in its existing regulated footprint rather than acquiring other utilities.

• Total debt: Approximately $26 billion to $28 billion.
• Debt/EBITDA ratio: 4.5x to 5.0x (standard for regulated utilities).
• Credit rating: BBB+ (S&P) / Baa1 (Moody's).
• Key debt instruments: First mortgage bonds (secured by utility property) at the operating company level, and unsecured senior notes at the holding company level.
• Maturity profile: Laddered long-term maturities, often issuing 10-year and 30-year bonds to match the long lives of utility assets.
• Interest rate profile: Predominantly fixed-rate long-term debt.
• Covenants: Standard debt-to-capitalisation limits (typically maximum 65% debt).
• Share repurchase programme: Not active. Utilities typically issue equity to fund capital programmes rather than buy back shares.
• Dividend policy: Target payout ratio of 60-70% of earnings, with a historical growth rate of 5-7% annually.

• Operating cash flow conversion: 1.5x to 2.0x of Net Income. High conversion due to massive non-cash depreciation add-backs.
• Free cash flow margin: Consistently negative. Operating cash flow is entirely consumed by capital expenditures.
• Major non-cash items: Depreciation, amortisation of regulatory assets, and deferred income taxes.
• Working capital cash flow impact: Fluctuates primarily with seasonal fuel costs and under/over-recovered fuel balances.
• Capex intensity: Extremely high. The company relies on continuous debt and equity capital market access to fund the gap between operating cash flow and capex.
• Cash tax rate: Very low (often near zero or negative) due to accelerated depreciation for tax purposes and significant Production Tax Credits (PTCs) from wind generation.

1. Assumptions: Hardcoded inputs for rate base growth, allowed ROE, equity ratio, capex plan, and macroeconomic drivers.
2. Rate Base & Capex: Roll-forward of the regulatory asset base by operating company (NSPM, NSPW, PSCo, SPS). Calculates average rate base and allowed operating income.
3. Revenue Build: Projects Electric and Natural Gas revenues based on rate base returns, volumetric sales, and fuel pass-throughs.
4. Income Statement: Consolidated P&L mirroring the 10-K, separating Electric and Gas margins, O&M, depreciation, and interest expense.
5. Balance Sheet: Assets (highlighting PP&E and Regulatory Assets), Liabilities (highlighting Long-Term Debt and Regulatory Liabilities), and Equity.
6. Cash Flow Statement: Operating, Investing (Capex), and Financing (Debt and Equity issuance, Dividends).
7. Debt & Interest Schedule: Tranches of debt, interest expense calculation, and AFUDC (Allowance for Funds Used During Construction) debt component.
8. Tax & PTC Schedule: Calculation of effective tax rate, deferred taxes, and Production Tax Credits which heavily influence utility earnings.
9. Valuation: Dividend Discount Model (DDM) and Price/Earnings multiple valuation (standard for utilities, DCF is less relevant due to perpetual negative FCF).

1. `Ending Rate Base = Beginning Rate Base + Capital Expenditures - Depreciation - Deferred Taxes`
2. `Average Rate Base = (Beginning Rate Base + Ending Rate Base) / 2`
3. `Allowed Operating Income = Average Rate Base x Allowed Return on Rate Base (approx 7.0-7.5%)`
4. `Electric Margin = Electric Revenues - Electric Fuel and Purchased Power`
5. `Natural Gas Margin = Natural Gas Revenues - Cost of Natural Gas Sold and Transported`
6. `Total O&M Expense = Prior Year O&M x (1 + Inflation Rate + System Growth Rate)`
7. `Depreciation Expense = Average Gross PP&E x Composite Depreciation Rate (approx 2.5-3.0%)`
8. `Interest Expense = Average Debt Balance x Weighted Average Cost of Debt`
9. `AFUDC Equity = Capital Work in Progress x Equity Portion of AFUDC Rate`
10. `Net Income = Operating Income + AFUDC Equity - Interest Expense - Income Taxes`
11. `EPS = Net Income / Weighted Average Diluted Shares Outstanding`
12. `Dividends Paid = Prior Year Dividend Per Share x (1 + Target Dividend Growth Rate) x Shares Outstanding`
13. `External Financing Need = Capital Expenditures + Dividends Paid - Operating Cash Flow`

The critical chain in a utility model begins with the Rate Base & Capex sheet. Capital expenditures feed into PP&E on the Balance Sheet and drive the Ending Rate Base. The Average Rate Base feeds the Revenue Build to determine base rate revenues. Revenues flow to the Income Statement to generate Net Income. Net Income flows to the Cash Flow Statement, where the massive Capex outflow creates a funding deficit. This deficit feeds the Debt & Interest Schedule (and equity issuance assumptions) to balance the cash flow. The new debt balance generates Interest Expense, which flows back to the Income Statement, creating a circular reference that must be managed with an iteration toggle or algebraic breaker.

• Income Statement: Revenues are positive. All expenses (COGS, O&M, Depreciation, Interest, Taxes) are negative. Net Income is positive if profitable.
• Balance Sheet: Assets are positive. Liabilities and Equity are positive.
• Cash Flow Statement: Cash inflows are positive. Cash outflows (including Capex and Dividends) are negative.
• Formulas: Gross Margin = Revenue + COGS (since COGS is negative).

• Misinterpreting Fuel Pass-Throughs: Fuel costs are passed directly to customers. An increase in natural gas prices will spike both Revenue and COGS, but Gross Margin will remain unchanged. Do not model revenue growth based purely on historical top-line trends.
• Ignoring AFUDC: Utilities capitalise the cost of financing construction projects. AFUDC-Debt reduces interest expense, and AFUDC-Equity is a non-cash addition to Net Income. Omitting this will understate earnings.
• Tax Credit Complexity: Xcel Energy generates massive Production Tax Credits (PTCs) from its wind farms. These credits are often passed back to customers through lower base rates, meaning they reduce revenue but also reduce tax expense.
• Regulatory Lag: The model assumes the company earns its exact allowed ROE. In reality, regulatory lag (the time it takes to file and win a rate case) means actual earned ROE is usually 50-100 basis points lower than allowed ROE.
• Weather Normalisation: Historical revenues fluctuate with weather (cooling degree days and heating degree days). The model must assume "normal" weather going forward; do not extrapolate a particularly hot or cold historical year.
• Negative Free Cash Flow Panic: Standard DCF models break on utilities because FCF is perpetually negative due to rate base growth. The builder must rely on a Dividend Discount Model (DDM) or P/E multiples for valuation.
• Share Count Creep: Utilities issue equity regularly to maintain their regulatory capital structure (typically 50-55% equity) while funding massive capex. The model must forecast rising share counts, which dilutes EPS.
• Pension Accounting: Non-service pension costs are recorded below the operating line but are often recoverable in rates. Ensure these are mapped correctly to match reported ongoing earnings.

• "Consolidated Rate Base CAGR should be approximately 9.4% from 2024 to 2029; flag if growth deviates significantly."
• "Ongoing EPS growth should fall within management's target range of 5-7% annually."
• "Dividend payout ratio must remain between 60% and 70% of Net Income."
• "Debt to Total Capitalisation ratio should remain near 50-55% to maintain the BBB+ credit rating."
• "Effective tax rate should be unusually low (0-10%) due to the continuous generation of wind Production Tax Credits."
• "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
• "Operating Cash Flow to Net Income conversion should consistently exceed 1.5x."
• "Total Base Capital Expenditures for the 5-year period (2025-2029) should sum to approximately $39 billion."

• Filings: SEC EDGAR (Form 10-K, 10-Q, 8-K) and Xcel Energy Investor Relations website (quarterly earnings presentations, ESG reports).
• Key Peers for Benchmarking: WEC Energy Group (WEC), Alliant Energy (LNT), CMS Energy (CMS), Eversource Energy (ES), and Ameren (AEE).
• Industry Data: Edison Electric Institute (EEI) for utility financial metrics, rate case outcomes, and regulatory ROE averages.
• Regulatory Data: S&P Global Market Intelligence (formerly SNL Financial) for detailed state-level rate case filings and allowed returns.
• Consensus Estimates: FactSet or Bloomberg for consensus EPS, Capex, and Rate Base estimates.

• Xcel Energy Inc. Form 10-K for the fiscal year ended December 31, 2024 (SEC EDGAR)
• Xcel Energy Q4 2025 Earnings Release and Presentation (February 2026)
• Xcel Energy Investor Relations Presentation (September 2025 and December 2025 updates)
• Xcel Energy 2023/2024 Investor Relations Fact Book
• Edison Electric Institute (EEI) Industry Financial Data