Source: EFC at UNC Chapel Hill

Start the planning process by using this tool for a strategic approach to building your capital improvement plan. Enter in all capital projects and this spreadsheet model 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.

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 for your capital improvement plan are displayed in tables and easy-to-read graphics.