Ameren logo
Ameren Financial Model

Utilities Company Financials Example (Free Excel Download)

Ameren Corporation is a public utility holding company headquartered in St. Louis, Missouri, providing electric and natural gas services to customers in Missouri and Illinois.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

This model projects Ameren's future earnings, cash flows, and rate base growth to determine equity valuation and assess the sustainability of its dividend programme for utility sector equity investors.

Ameren Corporation is a public utility holding company headquartered in St. Louis, Missouri, providing electric and natural gas services to customers in Missouri and Illinois. The company operates a heavily regulated, asset-intensive business model where earnings are primarily driven by capital investments in infrastructure that earn a regulated return on equity.

Business segments include:

  • Ameren Missouri (approx. 45-50% of net income): A vertically integrated electric and natural gas utility serving central and eastern Missouri.
  • Ameren Illinois Electric Distribution (approx. 15-20% of net income): An electric distribution utility serving central and southern Illinois.
  • Ameren Transmission (approx. 20-25% of net income): Operates high-voltage transmission lines across the Midcontinent Independent System Operator (MISO) footprint.
  • Ameren Illinois Natural Gas (approx. 10% of net income): A natural gas distribution utility in Illinois.

The company operates in a constructive regulatory environment, benefiting from forward-looking rate-making mechanisms and a massive $31.8 billion infrastructure investment programme planned for 2025 through 2030. Recent major events include the signing of 2.2 gigawatts of large load electric service agreements in Missouri in early 2026 and the ongoing transition of its generation fleet away from coal towards renewable energy and natural gas.

The downloadable Ameren 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 & AssumptionsAmeren financial model

Source: SEC EDGAR · values in USD

Line itemFY2021FY2022FY2023FY2024FY2025
Revenue$6.39B$7.96B$7.50B$7.62B$8.80B
Income Before Income Taxes$1.15B$1.25B$1.34B$1.27B$1.60B
Operating income$1.33B$1.51B$1.56B$1.52B$2.03B
Net income$995.0M$1.08B$1.16B$1.19B$1.46B

Forecast assumptions

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

Revenue growth
6.1%
COGS % of revenue
55.0%
R&D % of revenue
0.0%
SG&A % of revenue
15.0%
D&A % of revenue
18.5%
Effective tax rate
14.8%
See 8 more
Capex % of revenue
40.0%
Net working capital % of revenue
-15.3%
Other assets % of revenue
125.8%
Other liabilities % of revenue
187.7%
Annual debt paydown
5.0%
Interest rate on debt
3.1%
Dividend payout ratio
56.7%
Buybacks % of net income
0.0%

How to build a detailed financial model for Ameren

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

Revenue Deep Dive

For a regulated utility like Ameren, revenue is a function of recovering operating costs plus earning a return on invested capital (rate base).

Ameren Missouri

  • Revenue driver formula: (Average Rate Base x Equity Ratio x Allowed ROE) + Interest Expense + Operating & Maintenance (O&M) + Depreciation + Fuel Costs.
  • Historical growth rate: 4-6% CAGR, driven by infrastructure upgrades and new generation investments.
  • Key growth levers and headwinds: The primary lever is capital expenditure on grid modernisation and renewable generation. Headwinds include regulatory lag and warmer winter weather reducing heating demand.
  • Pricing dynamics: Rates are set by the Missouri Public Service Commission (MoPSC). Fuel costs are largely passed through to customers via riders.
  • Seasonality: Highly seasonal. The third quarter (summer) is the strongest for electric revenue due to cooling demand, while the first quarter is strongest for gas heating.

Ameren Illinois Electric Distribution

  • Revenue driver formula: Formula rate updates based on (Year-End Rate Base x Equity Ratio x Allowed ROE) + Recoverable Operating Costs.
  • Historical growth rate: 5-7% CAGR.
  • Key growth levers and headwinds: Driven by the Illinois Commerce Commission (ICC) multi-year rate plans. Headwinds include strict regulatory scrutiny on grid plan approvals.
  • Pricing dynamics: Regulated by the ICC with performance-based formula rates that reduce regulatory lag.

Ameren Transmission

  • Revenue driver formula: (Average Rate Base x Equity Ratio x FERC Allowed ROE) + Recoverable Costs.
  • Historical growth rate: 8-10% CAGR.
  • Key growth levers and headwinds: Driven by MISO long-range transmission planning projects.
  • Pricing dynamics: Regulated by the Federal Energy Regulatory Commission (FERC) using forward-looking formula rates, which provide highly predictable cash flows.

Ameren Illinois Natural Gas

  • Revenue driver formula: Traditional rate base return model plus purchased gas adjustment clauses.
  • Historical growth rate: 2-4% CAGR.
  • Pricing dynamics: Gas commodity costs are passed directly to consumers without markup. Revenue is driven by delivery charges.

Cost Structure

Variable Costs / COGS

  • Fuel and Purchased Power: The largest variable cost, representing the cost of coal, natural gas, and nuclear fuel, as well as electricity purchased from the wholesale market. This is generally a pass-through cost to customers.
  • Purchased Natural Gas: The cost of gas procured for distribution customers, also a direct pass-through.
  • Gross margin range: Utilities typically focus on "Gross Margin" as Revenue less Fuel and Purchased Power. This margin has historically grown steadily in line with rate base, rather than fluctuating with commodity prices.

Operating Expenses

  • Operations and Maintenance (O&M): Includes labour, tree trimming, power plant maintenance, and storm restoration. Ameren actively manages O&M to keep customer bills affordable while rate base grows.
  • Depreciation and Amortisation (D&A): A massive expense for utilities, typically running at 12-15% of total revenue, reflecting the capital-intensive nature of the grid and generation assets.
  • Taxes Other Than Income Taxes: Primarily property taxes and gross receipts taxes, which are significant for asset-heavy utilities.

Margin Profile

  • Operating Margin: Typically ranges between 18% and 22%.
  • Net Margin: Typically ranges between 14% and 17%.
  • Margin trend: Margins are relatively stable but expand slightly as the company invests capital (increasing earnings) while holding O&M flat through efficiency programmes.

Balance Sheet Structure

  • Total assets: Approximately $40 billion to $45 billion.
  • Key asset categories: Property, Plant, and Equipment (PP&E) makes up the vast majority of assets (over 75%). Regulatory Assets are also material, representing costs that regulators have approved for future recovery from customers.
  • Working capital profile: Utilities often operate with negative or neutral working capital.
  • Days Sales Outstanding (DSO): 30-40 days.
  • Days Payable Outstanding (DPO): 35-45 days.
  • PP&E: Consists of generation plants, transmission lines, distribution poles, and gas mains. Useful lives range from 10 years for software to 60+ years for transmission structures.
  • Regulatory Liabilities: Represents amounts over-collected from customers or deferred income taxes that must be returned to ratepayers over time.

Capital Expenditure & Investment

  • Capex as % of revenue: Extremely high, typically 40-50% of revenue, as the company reinvests heavily into the grid.
  • Major capex programmes: Ameren announced a $31.8 billion infrastructure investment plan for 2025 through 2030. This is expected to drive a 10.6% compound annual growth rate in rate base.
  • Maintenance vs. Growth: The majority is considered growth or modernisation capex (smart meters, renewable generation, transmission build-outs).
  • M&A pattern: Ameren is an organic grower. The company rarely engages in corporate M&A, focusing instead on building its own regulated assets.

Debt & Capital Structure

  • Total debt: Approximately $15 billion to $18 billion.
  • Capital Structure Target: Regulators typically authorise a capital structure of roughly 50% debt and 50% equity. Ameren manages its consolidated balance sheet to mirror this regulatory target.
  • Credit rating: Solid investment grade (typically Baa1/BBB+ at the parent level, higher at the operating company level).
  • Key debt instruments: Long-term first mortgage bonds at the utility subsidiaries and senior unsecured notes at the parent company.
  • Interest rate profile: Mostly fixed-rate long-term debt. The weighted average cost of debt is a critical input for regulatory rate cases.
  • Dividend policy: Ameren targets a dividend payout ratio of 50% to 60% of earnings. The 2026 annualised dividend is $3.00 per share.

Cash Flow Characteristics

  • Operating cash flow conversion: OCF is strong and predictable, typically 1.5x to 2.0x Net Income, aided by massive non-cash depreciation and deferred tax add-backs.
  • Free cash flow margin: Free cash flow (OCF less Capex) is structurally negative. This is standard for a growing utility.
  • Funding the gap: The negative free cash flow is funded through continuous issuance of long-term debt and periodic equity issuances (often via at-the-market programmes) to maintain the 50/50 capital structure.
  • Cash tax rate: Often near zero or negative due to accelerated depreciation on massive capital investments, creating large deferred tax liabilities.

Sheet Structure

  1. Assumptions: Hardcoded inputs for rate base growth, allowed ROEs, equity ratios, O&M inflation, and financing costs.
  2. Scenarios: Toggles for base case, adverse regulatory outcomes, and high load growth (e.g. data centre demand).
  3. Rate Base Roll-Forward: Tracks beginning rate base, plus capex, less depreciation, to calculate ending and average rate base for all four segments.
  4. Revenue Build: Calculates revenue for Ameren Missouri, Ameren Illinois Electric, Ameren Illinois Gas, and Ameren Transmission based on the rate base and allowed returns.
  5. Income Statement: Consolidated view mirroring the 10-K, separating fuel costs, O&M, D&A, and interest expense.
  6. Balance Sheet: Heavy focus on PP&E, Regulatory Assets, Regulatory Liabilities, and Debt.
  7. Cash Flow Statement: Bridges net income to OCF, deducts the $31.8 billion capex programme, and calculates the funding deficit.
  8. Debt & Equity Schedule: Models the issuance of new debt and equity required to fund the cash flow deficit while maintaining a 50% equity ratio.
  9. Valuation (DCF & DDM): A Dividend Discount Model is often preferred for utilities, alongside a standard DCF and P/E multiple valuation.

Key Financial Relationships

  1. "Ameren Missouri Earnings = Average Missouri Rate Base x Missouri Equity Ratio x Missouri Allowed ROE"
  2. "Ameren Transmission Earnings = Average Transmission Rate Base x FERC Equity Ratio x FERC Allowed ROE"
  3. "Consolidated Net Income = Sum of Segment Earnings - Parent Company Interest Expense"
  4. "Total Capital Expenditure = Base Maintenance Capex + Planned Grid Modernisation + Planned Generation Transition Capex"
  5. "Ending Rate Base = Beginning Rate Base + Capital Expenditures - Depreciation - Deferred Taxes"
  6. "Required External Financing = Operating Cash Flow - Capital Expenditures - Dividends Paid"
  7. "New Equity Required = Required External Financing x Target Equity Ratio (approx. 50%)"
  8. "New Debt Required = Required External Financing x Target Debt Ratio (approx. 50%)"
  9. "Dividends Paid = Prior Year EPS x Target Payout Ratio (55%) x Share Count"
  10. "Fuel and Purchased Power Expense = Base Fuel Cost + (Volume Growth x Variable Fuel Rate)" (Note: This perfectly offsets the fuel recovery revenue line).

Cross-Sheet Dependencies

The model relies on a highly circular but predictable chain. The Rate Base Roll-Forward sheet dictates the earnings calculated on the Revenue Build sheet. These earnings flow to the Income Statement and Cash Flow Statement. The massive capex from the Rate Base Roll-Forward causes a cash deficit on the Cash Flow Statement. This deficit flows to the Debt & Equity Schedule, which triggers new debt and equity issuances. The new debt generates interest expense, and the new equity dilutes EPS, both of which flow back to the Income Statement and impact the dividend payout on the Cash Flow Statement.

Sign Convention

  • Revenue and earnings are positive.
  • Expenses (O&M, Fuel, D&A, Interest) are positive in their specific schedules but subtracted in the Income Statement totals.
  • Capital expenditures are positive in the PP&E schedule but negative in the Cash Flow Statement.
  • Debt issuances are positive cash flows; debt repayments are negative cash flows.
  • Dividends paid are negative in the Cash Flow Statement.

Things Most Likely to Go Wrong

  • Ignoring the Parent Company Drag: Segment earnings will sum to a number higher than consolidated net income because Ameren Parent incurs unallocated interest expense. The model must include a "Parent and Other" column.
  • Misunderstanding Fuel Pass-Throughs: Spikes in natural gas prices inflate both revenue and fuel expense equally. Do not model margin expansion from higher commodity prices.
  • Applying Flat Margins to Revenue: Utility earnings grow based on rate base (capital invested), not revenue margins. Modelling EBITDA as a flat percentage of revenue will break when fuel prices fluctuate.
  • Failing to Model Equity Dilution: To fund the $31.8 billion capex plan while maintaining a 50/50 capital structure, Ameren must issue equity. Failing to increase the share count will artificially inflate EPS.
  • Regulatory Lag: The model assumes the company earns its exact allowed ROE. In reality, regulatory lag (the time between spending capital and getting it into rates) means actual earned ROE is usually 50 to 100 basis points lower than allowed ROE.
  • Weather Impacts: Historical revenue includes weather anomalies (e.g. a very hot summer). The base year must be weather-normalised before applying growth rates.
  • Using Year-End vs Average Rate Base: Illinois and FERC use year-end or forward-looking rate base, while Missouri traditionally uses historical average rate base. The model must apply the correct base to each segment.
  • Tax Benefit Exclusions: Ameren reported $5.35 GAAP EPS in 2025 but $5.03 Adjusted EPS due to FERC and ICC tax benefits. The model must base future growth on the $5.03 adjusted figure.

Validation Checks

  • "Consolidated Rate Base CAGR should equal approximately 10.6% between 2025 and 2030."
  • "Dividend payout ratio must remain between 50% and 60% of Adjusted EPS."
  • "Total capital expenditures for the 2025-2030 period should sum to approximately $31.8 billion."
  • "Consolidated Equity to Total Capital ratio must remain between 48% and 52% to satisfy rating agency and regulatory requirements."
  • "EPS compound annual growth rate should land between 6% and 8% from the 2026 base."
  • "Free Cash Flow (OCF less Capex) must be negative in every projected year due to the heavy investment cycle."
  • "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."

Key Assumptions (Default Values)

AssumptionDefault ValueUnitRationale
2026 Base EPS5.35USDMidpoint of management's 2026 guidance range ($5.25 to $5.45).
EPS Long-Term CAGR7.0%Midpoint of management's 6% to 8% target for 2026-2030.
2025-2030 Total Capex31.8USD BillionsManagement's stated 5-year infrastructure investment plan.
Rate Base CAGR10.6%Management guidance for rate base growth through 2030.
Target Dividend Payout Ratio55.0%Midpoint of stated 50% to 60% target policy.
2026 Annualised Dividend3.00USDDeclared in February 2026 ($0.75 per quarter).
Missouri Allowed ROE9.6%Approximate recent allowed return for Ameren Missouri.
Illinois Electric Allowed ROE8.7%Approximate recent allowed return under ICC formula.
FERC Transmission Allowed ROE10.5%Typical FERC allowed return including incentives.
Target Equity Ratio50.0%Standard regulatory capital structure requirement.
Effective Tax Rate13.0%Blended rate reflecting utility tax credits and accelerated depreciation.
Cost of New Long-Term Debt5.5%Estimated yield on new utility first mortgage bonds.

Data Sources & Benchmarks

  • SEC EDGAR: Source for Ameren's 10-K, 10-Q, and 8-K filings.
  • Ameren Investor Relations: Crucial for the February earnings presentation which details the 5-year capital plan and rate base growth targets.
  • Edison Electric Institute (EEI): Industry group providing data on average utility rates and regulatory trends.
  • S&P Global Market Intelligence / SNL Energy: The gold standard for tracking utility rate cases, allowed ROEs, and regulatory lag.
  • Key Peers: WEC Energy Group (WEC), CMS Energy (CMS), Alliant Energy (LNT), and Evergy (EVRG) for benchmarking P/E multiples and dividend yields.

Sources

Frequently asked

What is Ameren's core business model and how does it generate revenue?+

Ameren Corporation operates as a public utility holding company, providing electric and natural gas services across Missouri and Illinois. Its business model is heavily regulated and asset-intensive, with earnings primarily driven by capital investments in infrastructure that earn a regulated return on equity.

How does Ameren's regulated utility business generate revenue, particularly for Ameren Missouri?+

For a regulated utility like Ameren, revenue is a function of recovering operating costs and earning a return on invested capital, also known as the rate base. Specifically for Ameren Missouri, revenue is driven by a formula that includes the average rate base, equity ratio, allowed return on equity, interest expense, operating & maintenance costs, depreciation, and fuel costs.

What is Ameren's capital expenditure strategy and how does it impact the company's growth?+

Ameren has an extremely high capital expenditure profile, typically reinvesting 40-50% of its revenue back into the grid. The company has a massive $31.8 billion infrastructure investment plan for 2025 through 2030, which is expected to drive a 10.6% compound annual growth rate in its rate base.

What are the key revenue growth and margin assumptions used in Ameren's financial model?+

The financial model for Ameren assumes a revenue growth rate of approximately 6.14%. Key margin assumptions include Cost of Goods Sold at 55% of revenue, Selling, General & Administrative expenses at 15% of revenue, and Depreciation & Amortization at about 18.45% of revenue.

What is the purpose of the Ameren financial model and what does it help assess?+

The Ameren financial model is designed to project the company's future earnings, cash flows, and rate base growth. Its primary purpose is to determine equity valuation and assess the sustainability of Ameren's dividend program for utility sector equity investors.

Can I download an Excel financial model for Ameren (AEE) and what is its forecast horizon?+

Yes, an Excel financial model for Ameren (AEE) is available for download. This model provides financial projections with a forecast horizon spanning from fiscal year 2026 through fiscal year 2030.

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!

Other Utilities Company Financial Models

Browse another company in the same sector.

Explore more Energy financial model templates.

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