Source: EFC the UNC Chapel Hill
This spreadsheet model allows users to enter data that affect water and wastewater revenues and expenses, including rates of delinquencies and water use changes, to estimate net loss (or change) of revenue under COVID-19 pandemic working conditions over a two year period. Start with financial and water use data from the most recent year prior to the pandemic (e.g. 2019) as the baseline, and then enter the changes experienced or expected as a result of the COVID-19 working conditions. You will have the option to enter two scenarios, which can represent different possibilities and scenarios for changes in the coming months.
The tool is free to download and use. It is designed to be used by utility professionals, governing body members, government staff, and technical assistance providers working with water and wastewater utilities.