Water Utility Financial ModelFree Financial Model Download
Build a water utility model with usage projections, tariff revenue, capex needs, and rate adequacy analysis without stitching together separate regulatory and financial sheets. Supports rate case filings, municipal bond issuances, and 20-year strategic planning.
Free download. No sign-up required.
About this model
Model a water and wastewater utility with regulated tariffs, volume-driven consumption, and massive capital requirements. Revenue is split between fixed charges (per-connection annual fee) and volumetric charges (per-cubic-meter tariff), with separate tariffs for water supply and wastewater collection/treatment. Non-Revenue Water (NRW) of 15–20% reflects leakage losses; wastewater volumes are modeled as a percentage of water deliveries (typically 90–95% return to sewer).
Costs include power (largest variable cost, 6 kWh per cubic meter at $0.12/kWh = $0.72/m³), chemicals (chlorine, coagulants at $0.05/m³), and labor (30–40% of opex). Capex is 15–30% of revenue (much higher than electric utilities) due to aging pipe networks and new environmental regulations (PFAS remediation, nutrient discharge limits). Capex is bifurcated: RAB-eligible infrastructure (70–90% of total) recovers through tariffs; other capex (vehicles, IT) is expensed.
Key metrics: Debt/RAB ratio (target 60–65%), interest coverage ratio (ICR, minimum 1.5x), and customer connection growth (1–3% p.a.). Tariff adequacy is critical: if tariffs are held flat against inflation, coverage ratios deteriorate and borrowing capacity shrinks, limiting capex. This model is essential for municipal water systems, regional utilities (Severn Trent, United Utilities), and water infrastructure investors.
Recolor to your brand.
Formatted to IB standards.
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with blue inputs, black formulas, and green cross-sheet links.
- Brand-ready
- Institutional grade
- Fully auditable
What's included
- Customer growth and consumption projections by customer class
- Revenue model with fixed charges and volumetric usage rates
- Infrastructure capex for treatment, transmission, and replacement
- Debt service and rate covenants (coverage ratios)
- Rate case financial analysis and revenue requirement modeling
Rate adequacy and revenue requirement
Operating costs, capex needs, and debt service are summed to determine the revenue required to remain financially sound, which is the foundation of any rate case filing.
Debt service coverage and covenants
Municipal bond covenants requiring 1.25-1.50x debt service coverage are modeled explicitly so the utility knows its rate floor and borrowing capacity before going to market.
Long-term infrastructure investment planning
Capex requirements over 10 or more years are projected to address aging pipes, new regulations, and population growth, with affordability impacts tracked for low-income households.
Frequently asked
What revenue model should a water utility use?+
Most utilities use a two-part model: a fixed customer charge per month and a volumetric usage charge per thousand gallons. Some use tiered rates that increase at higher volumes to encourage conservation.
What debt service coverage ratio do bond covenants require?+
Municipal bond covenants typically require 1.25-1.50x debt service coverage (net revenue divided by debt service). Higher coverage is required for weaker credit profiles or first-time issuers.
How much capex does a water utility typically need?+
Utilities typically spend 2-4% of revenue annually on maintenance capex, plus additional spending for growth and regulatory compliance. Infrastructure age and climate resilience needs drive significant variability.
How do you model affordability impacts?+
Track the percentage of median household income consumed by the average customer bill. Bills above 2% of household income are considered unaffordable by most regulatory standards and may trigger subsidy requirements.
Who uses water utility financial models?+
Utility finance teams preparing rate case filings, water infrastructure investors, regulators reviewing revenue requirements, and rate consultants supporting municipal bond issuances and strategic financial planning.
Alex Tapio
Founder of Finamodel • Professional Financial Modeller • Ex-Deloitte
Related templates
Electric Utility Tariff Model
Model utility revenue based on customer class, usage levels, and tariff rate schedules.
Municipal Budget Model
Financial model for municipal governments including revenue forecasts, expenditure planning, and debt capacity.
Public Housing Authority Operating Model
Unit mix, rent roll, operating expenses, and asset replacement reserve for public housing portfolios.
Pension Fund Asset Allocation Model
Liability-driven investment strategy, asset allocation, and funding ratio analysis for pension plan portfolios.