American Water Works Financial Model
Utilities Company Financials Example (Free Excel Download)
American Water Works Company, Inc. is the largest publicly traded water and wastewater utility in the United States, providing essential services to approximately 14 million people.
professionals from Deloitte
Used by professionals from






About this model
This model forecasts American Water Works' rate base growth, regulated revenue requirements, and capital funding needs to determine equity valuation and assess the financial impact of the pending Essential Utilities merger.
American Water Works Company, Inc. is the largest publicly traded water and wastewater utility in the United States, providing essential services to approximately 14 million people. The company operates primarily as a regulated monopoly, earning a return on its infrastructure investments as determined by state Public Utility Commissions.
Business segments include the Regulated Businesses (approximately 92% of revenue) and Other, which includes the Military Services Group (approximately 8% of revenue). The company operates across 14 states, with a significant presence in New Jersey, Pennsylvania, Missouri, and Illinois. The business model is highly asset-heavy, relying on continuous capital expenditure to maintain and upgrade water infrastructure. The competitive position is exceptionally strong due to the monopolistic nature of regulated utility service territories. Recent major events include the 2021 divestiture of the Homeowner Services Group to focus purely on regulated operations and the late 2025 announcement of a transformational merger with Essential Utilities.
The downloadable American Water Works 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 & AssumptionsAmerican Water Works financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $3.91B | $3.76B | $4.22B | $4.65B | $5.12B |
| Income before income taxes | $1.64B | $1.01B | $1.20B | $1.36B | $1.42B |
| Operating income | $1.20B | $1.27B | $1.50B | $1.72B | $1.88B |
| Net income | $1.26B | $820.0M | $944.0M | $1.05B | $1.11B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for American Water Works
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Regulated Businesses
- Segment name: Regulated Businesses
- Revenue driver formula: (Authorized Rate Base x Allowed Return on Capital) + Recoverable Operating Expenses + Depreciation + Taxes
- Historical growth rate: 8-9% CAGR
- Key growth levers and headwinds: Capital investment in infrastructure (such as PFAS compliance and lead pipe replacement) drives rate base growth, while regulatory lag and customer affordability concerns act as headwinds.
- Pricing dynamics: Strictly regulated by state Public Utility Commissions through periodic rate cases.
- Revenue recognition notes: Recognised over time as services are delivered, including estimates for unbilled water usage at the end of each period.
- Seasonality: Q3 is typically the strongest quarter due to higher summer water usage for irrigation and cooling, often swinging revenue by 10-15% compared to winter quarters.
Other (Military Services Group)
- Segment name: Other
- Revenue driver formula: Contracted Fixed Fees + Variable Volume Charges
- Historical growth rate: 2-4% CAGR
- Key growth levers and headwinds: Winning new 50-year contracts with the US Department of Defense versus the slow pace of military base privatisations.
- Pricing dynamics: Long-term contractual pricing with inflation escalators.
- Revenue recognition notes: Recognised as operations and maintenance services are performed.
- Seasonality: Minimal seasonality compared to the regulated residential business.
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: Operations and Maintenance (O&M) includes purchased water, purchased power, chemicals, and direct labour.
- Gross margin range: Utilities typically do not focus on gross margin; instead, O&M as a percentage of revenue is tracked, usually running at 35-40%.
- Key input costs and commodity exposures: Electricity prices for pumping water and chemical costs for water treatment.
- How COGS scales with revenue: Step-function scaling, as infrastructure requires fixed maintenance regardless of minor volume fluctuations.
Operating Expenses
- R&D: Negligible for regulated water utilities.
- SG&A: General and administrative expenses include corporate overhead, billing, and customer service labour.
- Depreciation & Amortisation: Extremely high at 15-18% of revenue, driven by the massive tangible asset base of water treatment plants and pipe networks.
- Stock-Based Compensation: Low, typically under 1% of revenue.
- Restructuring / one-time charges: Infrequent, though merger-related transaction costs will appear in 2026 and 2027.
Margin Profile
- Operating margin: 35-38% historically.
- Net margin: 20-22% historically.
- Margin trend: Stable to slightly expanding as the company drives O&M efficiency to offset customer bill impacts from rate base growth.
- Segment-level margins: Regulated margins are highly stable, while the Other segment operates at lower margins due to the lack of capital return.
Balance Sheet Structure
- Total assets: Approximately $30 billion, dominated by utility infrastructure.
- Key asset categories: Property, Plant, and Equipment (Utility Plant) represents over 80% of total assets.
- Goodwill & intangibles as % of total assets: Approximately 5-7%, stemming from historical acquisitions of municipal systems.
- Working capital profile:
- Days Sales Outstanding (DSO): 35-45 days.
- Days Inventory Outstanding (DIO): Minimal (chemicals and maintenance supplies).
- Days Payable Outstanding (DPO): 40-50 days.
- Net working capital as % of revenue: Typically negative or near zero.
- Is working capital positive or negative? The company operates with slightly negative working capital, but growth is funded by external capital, not working capital advantages.
- PP&E: Consists of water treatment facilities, pipe networks, and pumping stations with useful lives ranging from 40 to 75 years.
- Right-of-use assets / operating leases: Immaterial compared to owned infrastructure.
Capital Expenditure & Investment
- Capex as % of revenue: 60-65% (approximately $3.2 billion annually on $5.1 billion of revenue).
- Maintenance capex vs. growth capex: Roughly 40% maintenance (pipe replacement) and 60% growth (system expansion, PFAS compliance, acquisitions).
- Major capex programmes underway or planned: A $19 to $20 billion capital plan for 2026-2030, including $2 billion for PFAS compliance and $1.5 billion for lead pipe replacement.
- Capitalised software / development costs: Immaterial.
- M&A pattern: Serial acquirer of small municipal systems (bolt-on strategy), supplemented by the transformational pending merger with Essential Utilities.
- Typical acquisition multiple paid: 1.2x to 1.5x rate base for municipal acquisitions.
Debt & Capital Structure
- Total debt: Approximately $13.0 billion.
- Debt/EBITDA ratio: 4.5x to 5.0x.
- Credit rating: S&P A, Moody's Baa1.
- Key debt instruments: Long-term senior notes, tax-exempt bonds, and a commercial paper programme for short-term liquidity.
- Maturity profile: Well-laddered, with average maturities exceeding 12 years.
- Interest rate profile: Predominantly fixed-rate long-term debt; weighted average cost of debt is approximately 4.0-4.5%.
- Covenants: Standard debt-to-capitalisation limits (typically maximum 70%).
- Share repurchase programme: Inactive; the company issues equity to fund growth rather than repurchasing shares.
- Dividend policy: Target payout ratio of 55-60% of net income, with a dividend growth rate of 7-9% annually.
Cash Flow Characteristics
- Operating cash flow conversion: OCF / Net Income is typically 1.5x to 1.8x due to massive depreciation add-backs.
- Free cash flow margin: Structurally negative. The company spends significantly more on capex than it generates in operating cash flow.
- Major non-cash items: Depreciation and deferred income taxes.
- Working capital cash flow impact: Minor fluctuations; not a primary source of cash.
- Capex intensity: Extremely high, requiring constant access to debt and equity markets.
- Cash tax rate vs. GAAP effective tax rate: Cash taxes are near zero due to accelerated depreciation rules for utility infrastructure, creating large deferred tax liabilities.
Sheet Structure
- Assumptions: Macro drivers, rate base growth targets, allowed ROE, capex schedule, and financing mix.
- Rate Base: Roll-forward of Gross Utility Plant, Accumulated Depreciation, and Deferred Taxes to calculate the authorized rate base.
- Revenue: Calculation of Regulated Businesses revenue requirement and Other segment revenue.
- Income Statement: O&M, Depreciation, General Taxes, Interest Expense, and Income Taxes.
- Balance Sheet: Utility Plant, Working Capital, Deferred Taxes, Debt, and Equity.
- Cash Flow Statement: OCF, Investing Cash Flows (capex, acquisitions), and Financing Cash Flows (debt issuance, equity issuance, dividends).
- Debt Schedule: Tranches of long-term debt, short-term borrowings, and interest expense calculation.
- Merger Pro-Forma: Adjustments and consolidation mechanics for the pending Essential Utilities transaction.
Key Financial Relationships
- Rate Base = Prior Year Rate Base + Capex - Depreciation - Change in Deferred Taxes
- Allowed Return = Rate Base x (Equity Ratio x Allowed ROE + Debt Ratio x Cost of Debt)
- Regulated Revenue = Allowed Return + O&M Expenses + Depreciation + General Taxes
- O&M Expense = Prior Year O&M x (1 + Inflation Rate) - Efficiency Savings
- Depreciation Expense = Gross Utility Plant x Composite Depreciation Rate
- Interest Expense = Average Debt Balance x Weighted Average Interest Rate
- Dividends Paid = Prior Year EPS x Target Payout Ratio x Share Count
- Funding Gap = Cash from Operations - Capex - Dividends
- New Debt Issued = Funding Gap x Target Debt Ratio
- New Equity Issued = Funding Gap x Target Equity Ratio
Cross-Sheet Dependencies
The Assumptions sheet feeds all calculations. The Rate Base sheet is the critical engine; it feeds the Revenue sheet to determine the allowed return and the Balance Sheet for the Utility Plant balance. The Revenue sheet feeds the Income Statement. The Income Statement feeds the Cash Flow Statement (Net Income) and Balance Sheet (Retained Earnings). The Cash Flow Statement determines the Funding Gap, which feeds the Debt Schedule and Equity roll-forward. The Debt Schedule feeds interest expense back to the Income Statement, creating a circular reference that must be managed with a circuit breaker toggle.
Sign Convention
Revenues, assets, and equity are positive. Expenses, capital expenditures, and liabilities are positive in their respective schedules but subtracted in totals. On the Cash Flow Statement, cash inflows are positive, while cash outflows (such as capex and dividends) are negative.
Things Most Likely to Go Wrong
- Regulatory lag: Assuming capex immediately generates revenue will overstate near-term earnings; the model must account for the delay between spending capital and new rates taking effect.
- Weather normalization: Historical revenue includes weather impacts; the model must use weather-normalized baselines for forecasting.
- Deferred taxes: Miscalculating the deferred tax liability will distort the rate base calculation, as deferred taxes are deducted from the rate base.
- HOS divestiture: Failing to exclude historical Homeowner Services Group financials will skew historical growth rates and margin analysis.
- Essential Utilities merger: Ignoring the pending merger will make 2027 forecasts irrelevant; the model must include a toggle for the pro-forma combination.
- Equity dilution: Forgetting to model the required equity issuances (management expects $1 billion in 2026) will understate the share count and artificially inflate EPS.
- PFAS costs: Omitting the $2 billion environmental compliance capex will understate the rate base and future revenue requirements.
- Circularity: Interest expense depends on debt, which depends on the funding gap, which depends on net income.
Validation Checks
- Debt-to-Capital ratio must remain between 58% and 60% to align with regulatory targets.
- Dividend payout ratio must stay within the 55-60% target range.
- EPS growth should align with management guidance of 7-9% CAGR.
- Rate base growth should track at 8-9% annually.
- Operating margin should remain stable around 36-38%.
- Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period.
- Effective tax rate should reflect utility-specific deductions, typically running lower than the statutory rate.
- Cash flows from financing must exactly offset the free cash flow deficit.
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Rate Base Growth | 8.5 | % | Midpoint of management's 8-9% target range |
| Allowed ROE | 9.7 | % | Average authorized return across state jurisdictions |
| Regulatory Equity Ratio | 50.0 | % | Standard PUC target for capital structure |
| Cost of Debt | 4.5 | % | Weighted average interest rate on long-term debt |
| Annual Capex | 3,200 | $ Millions | Based on 2025 actuals and 2026-2030 capital plan |
| O&M Inflation | 2.5 | % | Long-term utility cost inflation estimate |
| Dividend Payout Ratio | 58.0 | % | Midpoint of management's target policy |
| Effective Tax Rate | 15.0 | % | Historical average reflecting utility tax benefits |
| Target Debt to Capital | 59.0 | % | Management's stated balance sheet target |
| Share Count | 195.2 | Millions | Actual outstanding shares as of late 2025 |
| 2026 Equity Issuance | 1,000 | $ Millions | Management guidance for external equity needs |
Data Sources & Benchmarks
- Where to find filings: SEC EDGAR database and the American Water Investor Relations website.
- Key peers for benchmarking: Essential Utilities (WTRG), California Water Service Group (CWT), American States Water Company (AWR).
- Industry data sources: State Public Utility Commission dockets (e.g., Pennsylvania PUC, New Jersey BPU) for detailed rate case filings and allowed ROE data.
- Consensus estimates: Bloomberg or FactSet for EPS and rate base growth consensus.
Sources
- American Water Works Company, Inc. 2024 and 2025 Form 10-K filings.
- American Water Q4 2025 Earnings Presentation and Conference Call Transcripts.
- SEC Form S-4 filings regarding the pending merger with Essential Utilities.
- Press releases regarding the 2021 divestiture of the Homeowner Services Group to Apax Partners.
Do more with the American Water Works model
Frequently asked
What does American Water Works do?+
American Water Works Company, Inc. is the largest publicly traded water and wastewater utility in the United States, providing essential services to approximately 14 million people. The company operates primarily as a regulated monopoly, earning a return on its infrastructure investments as determined by state Public Utility Commissions.
How does American Water Works generate its revenue?+
American Water Works primarily generates revenue from its Regulated Businesses, which accounts for approximately 92% of its total revenue. This is driven by authorized rate base, allowed return on capital, recoverable operating expenses, depreciation, and taxes. The remaining revenue comes from its Other segment, including the Military Services Group, through contracted fixed fees and variable volume charges.
What is American Water Works' capital expenditure strategy?+
American Water Works has a highly asset-heavy business model with significant capital expenditure, typically 60-65% of revenue, or about $3.2 billion annually. This includes a $19 to $20 billion capital plan for 2026-2030, with major investments in PFAS compliance and lead pipe replacement. Roughly 60% of this capex is for growth, while 40% is for maintenance.
What are the main financial assumptions used in the American Water Works model?+
Key assumptions in the financial model for American Water Works include a Revenue Growth rate of approximately 4.13% and COGS as 55% of revenue. Additionally, Capex is assumed to be 40% of revenue, and the Tax Rate is around 22.29%. These assumptions are used for the FY2026–FY2030 forecast horizon.
Can I download a financial model for American Water Works?+
Yes, a downloadable Excel model for American Water Works is available. This model forecasts the company's rate base growth, regulated revenue requirements, and capital funding needs. Its purpose is to determine equity valuation and assess the financial impact of the pending Essential Utilities merger.
What factors drive American Water Works' regulated business growth?+
Growth in American Water Works' regulated businesses is primarily driven by capital investment in infrastructure, such as projects for PFAS compliance and lead pipe replacement, which expands the authorized rate base. However, regulatory lag and customer affordability concerns can act as headwinds to this growth.
Have more financial modelling questions? Contact us
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.

Ameren
Ameren Corporation is a public utility holding company headquartered in St.

American Electric Power
American Electric Power Company, Inc.

AES
The AES Corporation is a global Fortune 500 independent power producer and utility company that generates and distributes electrical power.

Atmos Energy
Atmos Energy Corporation is the largest fully regulated, pure-play natural gas distributor in the United States, serving approximately 3.4 million customers.

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

CMS Energy
CMS Energy Corporation is a multi-utility holding company based in Jackson, Michigan.

CenterPoint Energy
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.

Dominion Energy
Dominion Energy is a regulated electric utility holding company headquartered in Richmond, Virginia, providing electricity to approximately 3.6 million homes and businesses.
Explore more Energy financial model templates.



