Public Financial Management

pakhohuang
5YearCIPSpreadsheet1.xlsx

Sheet1

The City of Newhope
Five Year Capital Improvement Program
2019-20 through 2023-24
Estimated
Fund Name Funding Source 2019-20 2020-21 2021-22 2022-23 2023-24 Five Year Annual Fund
Project Name Fund Number Fund Number Appropriation Appropriation Appropriation Appropriation Appropriation Total Operating Cost No.
1
XXXXXXXXXXXX XXXXXXXXXXXX XXXXXXXXXXXX XXXXXXXXXXXX XXXXXXXXXXXX 0 XXXXXXXXXXXX
2
XXXXXXXXXXXX XXXXXXXXXXXX XXXXXXXXXXXX XXXXXXXXXXXX XXXXXXXXXXXX 0 XXXXXXXXXXXX
3
XXXXXXXXXXXX XXXXXXXXXXXX XXXXXXXXXXXX XXXXXXXXXXXX XXXXXXXXXXXX 0 XXXXXXXXXXXX
4
XXXXXXXXXXXX XXXXXXXXXXXX XXXXXXXXXXXX XXXXXXXXXXXX XXXXXXXXXXXX 0 XXXXXXXXXXXX
5
XXXXXXXXXXXX XXXXXXXXXXXX XXXXXXXXXXXX XXXXXXXXXXXX XXXXXXXXXXXX 0 XXXXXXXXXXXX
Totals ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! ERROR:#VALUE! 0 ERROR:#VALUE!
Notes: Wherever XXXXXXXXXXXXX is displayed, students are to fill in the budgeted dollar amounts - totals will self-compute
It is OK to abbreviate fund names as needed General Fund Total Annual Operating Costs XXXXXXXXXXXX
In a "perfect" world the CIP budgeted/projected expenditures would be matched with dollar amounts to the Electric Utility Enterprise Fund Tot. Annual Op. Costs XXXXXXXXXXXX
funding sources. However, that gets logistically complicated and will not be part of this exercise. Wastewater Treatment Ent. Fund Total Op. Costs XXXXXXXXXXXX
Total All Funds (should equal row 22; column J 0