Share this on Social Media...
There are many ways to assess affordability of residential rates. A common metric is to compute the proportion of the Median Household Income of the community that would be spent on a year's worth of "average bills" (termed Percent MHI). This is one metric, but is not the only metric by which the affordability of residential rates can be (or perhaps should be) assessed. This easy-to-use Excel tool guides a utility to obtain a range of Census data on its community in order to assess the relative affordability of its water & wastewater rates on its residential customers using multiple metrics. This provides the utility with more information and a more comprehensive understanding of the affordability of its rates than based on %MHI. Affordability is assessed for the average customer, low-income customers, and a full range of households based on their various income levels, both all households and only homeowners. The tool also allows a utility to compare two rate structures side-by-side, enabling the utility to assess the affordability of its current rates alongside alternative rates. The tool is designed to be used by individual utilities (or by people who are advising utilities). Data input should take just a few minutes.
Note: always consider the financial needs and condition of the utility while addressing affordability of rates. Setting artificially low rates at the expense of financial sustainability eventually leads to financial constraints that prevent the utility from investing in its assets, leading to deteriorating conditions and provision of poor quality water, ultimately harming public health and service. Read the blog posts linked throughout this tool for more information on how you can provide assistance to customers that are unable to pay their bills, or contact the EFC for assistance on how to set rates
How to use the tool:
Download the tool from the link above, and follow the built-in instructions to input the utility's current average monthly charge and a few socioeconomic data for your service area obtained from the U.S. Census Bureau's website following the step-by-step instructions included in the Inputs worksheet. Data input should only take a few minutes. The tool then computes several affordability assessment metrics and presents the results with text that describes how affordability can be assessed for different groups of customers.
View a recording of a webinar demonstrating how to use version 1.2 of this tool:
What's new in version 1.8 (January 15, 2020)?
- Updated American Community Suvey (ACS) data from 2018
- Updated instructions on how to obtain data to use in the tool.
What's new in version 1.7.1 (August 28,2019)?
- Updated instructions on how users can access data on data.census.gov
What's new in version 1.7 (July 12, 2019)?
- Updated US Census data and instructions on data access for new government site.
What's new in version 1.6 (December 6, 2018)?
- Updated 2017 American Community Survey (ACS) data.
What's new in version 1.5 (December 20, 2017)?
- Socioeconomic data for each state and the United States are updated with the latest (2016) American Community Survey data.
What's new in version 1.4 (August 23, 2017)?
- Updated color scheme
- Update text describing the results of the analysis
What's new in version 1.3 (February 2, 2017)?
- Socioeconomic data for each state and the United States are updated with the latest (2015) American Community Survey data
What's new in version 1.2 (September 7, 2016)?
- Socioeconomic data for each state and the United States are updated with the latest (2014) American Community Survey data
- New, simpler, dynamic graph replaces two bubble charts
- Addition of income distributions of homeowners only, which allows the user to exclude households that are renters (who may or may not have water/wastewater service included in their rent)
- Formatting changes to facilitate navigation
This tool was developed while assisting small water systems in the Smart Management for Small Water Systems project under a cooperative agreement with the U.S. Environmental Protection Agency.
CalculatorBill Payment Assistance Program Cost Estimation for Water UtilitiesMon, 01/25/2021
DashboardConnecticut Water and Wastewater Rates DashboardTue, 02/11/2020
DashboardDelaware Water and Wastewater Rates DashboardTue, 08/21/2018
DashboardMissouri 2018 Water Rates DashboardFri, 07/20/2018
ReportNavigating Legal Pathways to Rate-Funded Customer Assistance Programs: A Guide for Water and Wastewater UtilitiesMon, 07/10/2017
DashboardVirginia Water and Wastewater Rates DashboardWed, 12/20/2017