Water Utility Funds
<br />Source 2018 2019 2020 2021 2022
<br />274,511 (1,858,206)(1,987,524)(2,381,409)(2,394,863)Beginning Balance
<br />Revenues and Other Fund Sources
<br />Revenue
<br />2,186,900 2,230,638 2,275,250 2,320,755 2,367,170Operating Revenue
<br />2,186,900 2,230,638 2,275,250 2,320,755 2,367,170Total
<br />2,461,411 372,432 287,726 (60,654)(27,693)Total Funds Available
<br />2,186,900 2,230,638 2,275,250 2,320,755 2,367,170Total Revenues and Other Fund Sources
<br />Expenditures and Uses
<br />Capital Projects & Equipment
<br />Street Department
<br />0 0 (400,000)0 (400,000)Future PMP 18-Str-005
<br />(100,000)0 0 0 0Indian Oaks/Floral Drive PMP - 2018 PMP 18-Str-065
<br />(100,000)0 (400,000)0 (400,000)Total
<br />Water Department
<br />(520,000)0 0 0 0Water Towers Repair and Repainting 12-W-001
<br />(855,000)0 0 0 0CR E2 Water Replacement/Old Hwy 10 Water
<br />Loop
<br />17-W-001
<br />(400,000)(154,000)0 0 0Booster Station Repair/Upgrade - Roseville 18-W-001
<br />(300,000)0 0 0 0County Road F Watermain Replacement 18-W-002
<br />(2,075,000)(154,000)0 0 0Total
<br />Other Uses
<br />(2,044,617)(2,105,956)(2,169,135)(2,234,209)(2,301,235)Operating Expenditures
<br />(100,000)(100,000)(100,000)(100,000)(100,000)Transfer to Equipment Fund
<br />(2,144,617)(2,205,956)(2,269,135)(2,334,209)(2,401,235)Total
<br />(4,319,617)(2,359,956)(2,669,135)(2,334,209)(2,801,235)Total Expenditures and Uses
<br />(1,858,206)(1,987,524)(2,381,409)(2,394,863)(2,828,928)Ending Balance
<br />(2,132,717)(129,318)(393,885)(13,454)(434,065)Change in Fund Balance
<br />Wednesday, September 13, 2017Page 67Produced Using the Plan-It Capital Planning Software
|