Water And Wastewater Rates Analysis Model

Use this tool to help set water and/or wastewater rates next year by projecting the utility’s expenses, revenues from rates, and fund balance for the next few years.

Category: Long Term Funding

Resource
Description

Resource

Title	Document Type	View in new tab
Water And Wastewater Rates Analysis Model	Spreadsheet	Open

Description

Use this tool to help set water and/or wastewater rates next year by projecting the utility’s expenses, revenues from rates, and fund balance for the next few years. Uniform (“flat”) and block rate structures for up to 12 rate structures can be assessed. Data inputs are minimal, and the tool has been updated to offer several new features and improvements to make it easier to test scenarios and help determine whether the utility needs to adjust rates in order to achieve financial sufficiency. This tool is designed specifically for small water/wastewater systems and should be used annually. The tool is free to download and use.