Water and Sewer Rate Analysis ModelLocation: Online – your computer
Cost: FREE!

Date: 2/26/14
Time: 2:30 – 3:30 PM EST / 11:30 AM – 12:30 PM PST

Does your system charge your customers the correct amount for water?  This webinar helped systems answer this question by demonstrating the Water & Sewer Rates Analysis Model, an Excel tool developed by the Environmental Finance Center at The University of North Carolina.  This basic cash-flow modeling tool allowed water systems to input their current rate structure, estimates on number of customers and water use, and the expected costs for the system. The tool then automatically projects the end-of-year fund balance for the next several years, indicating whether revenues will be high enough to cover expected expenses. Users can then enter in another rate structure and compare the end-of-year fund balance side-by-side to the one projected using current rates. This allowed users to try out scenarios of adjusting their rates to meet their financial goals in the next few years, and can help users determine whether they need to adjust rates, and by how much, in order to achieve financial sufficiency. The tool can be used by systems that set volumetric charges for water as well as systems that only charge flat monthly fees.

Tool: Water & Sewer Rates Analysis Model
Example of calculating monthly consumption by block: Download this Excel file