The EFC at UNC has created several free tools to assist water utilities in addressing the challenges and questions we commonly see in our teaching and advising. These tools cover a broad range of finance and management topics, including rates and revenue, financial benchmarking, affordability, capital finance, communicating with the board, and evaluating loans and grants.
Rates and Revenue
Use this tool to review your rates to ensure projected revenues cover projected expenses. This tool will help you determine whether proposed rates will keep the utility financially self-sufficient for the next few years.
Use this tool to assess how much revenues might be affected by changing demand patterns. The tool will help you compare effects on existing rates and on alternative rate structures.
COVID-19 Revenue Loss Tool
The EFC can use this tool to work one-on-one with a utility to project its revenue losses during the pandemic and into the next two years under differing scenarios of recovery. Contact the EFC to work with you in using this tool, at no cost (not available for download).
Our flagship tools for water utilities, these interactive dashboards allow you to benchmark your utility's rates against other utilities with similar characteristics. The dashboards also help you evaluate rates, cost recovery, affordability, pricing signal, and other financial benchmarks. Use the dashboards to communicate important information about your rates with your board, the media, and the public.
Use this tool to get a snapshot of your utilitys financial health and demonstrate the financial strengths and weaknesses of your utility over the past 5 years. The tool uses your utility's financial data to calculate and visualize 6 financial performance indicators.
This dashboard is designed to allow utilities to visualize the impact of revenue losses given COVID-19's conditions and the ability to pay for operations and maintenance expenses by offsetting revenue losses from unrestricted cash and reserves. There are unique versions of this dashboard for North Carolina and Georgia.
Use this tool to assess how affordable rates are to your customer base using multiple metrics.
Use this tool to estimate the funds needed from your utility (or other organization) to create a Customer Assistance Program that helps residential customers when they cannot afford to pay their water bill.
Use this tool to help plan how to pay for future capital projects. The tool will estimate the effects that paying for capital projects will have on your rates under various scenarios.
Use this tool to nd the right balance of debt nancing and cash reserves to pay for a capital project while maintaining a positive fund balance.
Communicating with the Board
Rate Case Visualization Tool
This infographic tool is designed to help utility staff present key financial and operational information to the water utility board during a rate review. Contact us to use this tool.
Evaluating Loans and Grants
Use this tool to determine whether it makes economic sense to accept a subsidized loan or grant that your utility has been offered.
This tool allows you to see how much electricity your water system is currently using and track how much you save, or have already saved, with new energy efficiency projects.