American Water Works logo
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.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

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 model

Source: SEC EDGAR · values in USD

Line itemFY2021FY2022FY2023FY2024FY2025
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.

Revenue growth
4.1%
COGS % of revenue
55.0%
R&D % of revenue
0.0%
SG&A % of revenue
15.0%
D&A % of revenue
16.5%
Effective tax rate
22.3%
See 8 more
Capex % of revenue
40.0%
Net working capital % of revenue
-45.9%
Other assets % of revenue
97.2%
Other liabilities % of revenue
218.4%
Annual debt paydown
5.0%
Interest rate on debt
4.5%
Dividend payout ratio
51.8%
Buybacks % of net income
1.2%

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

  1. Assumptions: Macro drivers, rate base growth targets, allowed ROE, capex schedule, and financing mix.
  2. Rate Base: Roll-forward of Gross Utility Plant, Accumulated Depreciation, and Deferred Taxes to calculate the authorized rate base.
  3. Revenue: Calculation of Regulated Businesses revenue requirement and Other segment revenue.
  4. Income Statement: O&M, Depreciation, General Taxes, Interest Expense, and Income Taxes.
  5. Balance Sheet: Utility Plant, Working Capital, Deferred Taxes, Debt, and Equity.
  6. Cash Flow Statement: OCF, Investing Cash Flows (capex, acquisitions), and Financing Cash Flows (debt issuance, equity issuance, dividends).
  7. Debt Schedule: Tranches of long-term debt, short-term borrowings, and interest expense calculation.
  8. Merger Pro-Forma: Adjustments and consolidation mechanics for the pending Essential Utilities transaction.

Key Financial Relationships

  1. Rate Base = Prior Year Rate Base + Capex - Depreciation - Change in Deferred Taxes
  2. Allowed Return = Rate Base x (Equity Ratio x Allowed ROE + Debt Ratio x Cost of Debt)
  3. Regulated Revenue = Allowed Return + O&M Expenses + Depreciation + General Taxes
  4. O&M Expense = Prior Year O&M x (1 + Inflation Rate) - Efficiency Savings
  5. Depreciation Expense = Gross Utility Plant x Composite Depreciation Rate
  6. Interest Expense = Average Debt Balance x Weighted Average Interest Rate
  7. Dividends Paid = Prior Year EPS x Target Payout Ratio x Share Count
  8. Funding Gap = Cash from Operations - Capex - Dividends
  9. New Debt Issued = Funding Gap x Target Debt Ratio
  10. 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)

AssumptionDefault ValueUnitRationale
Rate Base Growth8.5%Midpoint of management's 8-9% target range
Allowed ROE9.7%Average authorized return across state jurisdictions
Regulatory Equity Ratio50.0%Standard PUC target for capital structure
Cost of Debt4.5%Weighted average interest rate on long-term debt
Annual Capex3,200$ MillionsBased on 2025 actuals and 2026-2030 capital plan
O&M Inflation2.5%Long-term utility cost inflation estimate
Dividend Payout Ratio58.0%Midpoint of management's target policy
Effective Tax Rate15.0%Historical average reflecting utility tax benefits
Target Debt to Capital59.0%Management's stated balance sheet target
Share Count195.2MillionsActual outstanding shares as of late 2025
2026 Equity Issuance1,000$ MillionsManagement 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

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

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