Plan to Pay: Scenarios to Fund your C.I.P.

Access the Tool

Source: EFC @ UNC Chapel Hill (.xlsx)
Enter in all capital projects and this tool will project your fund balance (revenues, expenses and reserves), and necessary rate increases for the next 20 years, and more! Data entry requirements are minimal. Intended for small systems. How to use the CIP tool:
Start by entering basic information on a utility’s rate structure, customer base and current fiscal year financials. Then enter the capital projects for the next 20 years, choose project start and end dates and costs, and select a financing method for each project (cash financed or debt financed). The tool will calculate annual rate increases necessary to cover capital reserve allocations and debt service over a 20-year planning period, while restricting your reserves from increasing perpetually. Results are displayed in tables and easy-to-read graphics.

Back to Resource Library