11-13-2017 Council Work Session Packet

Home Browse Search

Water Fund Current Balance: $977,700 Table 6-6 Project 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Annual Operation and Maintenance (1) $505,000 $517,625 $530,566 $543,830 $557,426 $571,361 $585,645 $600,286 $615,293 $630,676 $646,443 $662,604 $679,169 $696,148 Debt Service $156,000 $160,000 $157,000 $156,000 $155,000 $158,000 $101,500 $100,000 $100,000 $100,500 $104,000 $100,600 $103,000 $0 CIP Expenditures $428,700 $391,000 $720,000 $145,200 $471,750 $388,885 $375,113 $425,935 $710,854 $275,871 $330,988 $286,208 $291,532 $341,963 Total Expenses $1,089,700 $1,068,625 $1,407,566 $845,030 $1,184,176 $1,118,246 $1,062,258 $1,126,221 $1,426,147 $1,007,047 $1,081,431 $1,049,412 $1,073,701 $1,038,111 Total Expenses $2,399,220 $1,910,121 $2,211,808 $2,003,565 $2,135,569 $2,361,227 $1,848,099 $1,931,217 $1,919,615 $1,970,327 $2,022,389 $2,075,837 $2,130,707 $2,267,038 Revenues (1) $750,000 $772,500 $795,675 $819,545 $844,132 $869,456 $895,539 $922,405 $950,078 $978,580 $1,007,937 $1,038,175 $1,079,702 $1,112,093 Assessments $10,387 $10,387 $10,387 $10,387 $10,387 $10,387 $10,387 $10,387 $10,387 $0 $0 $0 $0 $0 Annual Balance ($329,313) ($285,738) ($601,504) ($15,098) ($329,657) ($238,404) ($156,332) ($193,429) ($465,683) ($28,467) ($73,494) ($11,236) $6,002 $73,983 Year End Cash Balance $648,387 $362,649 ($238,855) ($253,952) ($583,609) ($822,013) ($978,344) ($1,171,773) ($1,637,456) ($1,665,922) ($1,739,416) ($1,750,652) ($1,744,651) ($1,670,668) Sewer Fund Current Balance: $2,800,000 Table 6-7 Project 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Operation and Maintenance (1) $1,128,700 $1,156,918 $1,185,840 $1,215,486 $1,245,874 $1,277,020 $1,308,946 $1,341,670 $1,375,211 $1,409,592 $1,444,831 $1,480,952 $1,517,976 $1,555,925 Debt Service $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $0 $0 $0 $0 $0 $0 $0 $0 CIP Expenditures $1,140,520 $643,204 1 $815,967 $646,578 $779,696 $524,206 $539,153 $554,547 $544,404 $560,736 $577,558 $594,885 $612,731 $631,113 Transfer to Equipment Fund for Sewer Equip $20,000 $0 $100,000 $31,500 $0 $450,000 $0 $35,000 $0 $0 $0 $0 $0 $80,000 Total Expenses $2,399,220 $1,910,121 $2,211,808 $2,003,565 $2,135,569 $2,361,227 $1,848,099 $1,931,217 $1,919,615 $1,970,327 $2,022,389 $2,075,837 $2,130,707 $2,267,038 Revenues (1) $255,600 $268,380 $281,799 $295,889 $310,683 $326,218 $342,528 $359,655 $377,638 $396,519 $416,345 $437,163 $459,021 $481,972 Revenues (1) $1,308,898 $1,361,254 $1,415,704 $1,472,333 $1,531,226 $1,592,475 $1,656,174 $1,722,421 $1,791,318 $1,862,970 $1,862,970.33 $1,909,545 $1,957,283 $2,006,215 Assessments $35,349 $35,349 $35,349 $30,368 $26,934 $24,902 $17,569 $17,569 $10,939 $2,000 $0 $0 $0 $0 Annual Balance ($1,054,973) ($513,518) ($760,754) ($500,864) ($577,409) ($743,850) ($174,356) ($191,227) ($117,358) ($105,357) ($159,419) ($166,292) ($173,424) ($260,823) Year End Cash Balance $1,745,027 $1,231,509 $470,755 ($30,109) ($607,519) ($1,351,369) ($1,525,724) ($1,716,951) ($1,834,310) ($1,939,667) ($2,099,086) ($2,265,378) ($2,438,802) ($2,699,625) Storm Water Fund Current Balance: $1,700,000 Table 6-8 Project 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Operation and Maintenance (1) $161,564 $165,603 $169,743 $173,987 $178,336 $182,795 $187,365 $192,049 $196,850 $201,771 $206,816 $211,986 $217,286 $222,718 CIP Expenditures $308,080 $222,160 1 $306,260 $381,122 $390,044 $399,190$408,565 �$0 $418,175 $428,027 $438,127 $448,480 $459,095 $469,977 $469,977 Transfer to Equipment Fund for Storm Equip $0 $0 $100,000 $0 $75,000 $0 $12,000 $600,000 $0 $0 $0 $0 $0 Total Expenses $469,644 $387,763 1 $576,004 $555,108 $643,380 $581,985 $595,930 $622,224 $1,224,877 $639,898 $655,296 $671,081 $687,262 $692,695 Revenues (1) $255,600 $268,380 $281,799 $295,889 $310,683 $326,218 $342,528 $359,655 $377,638 $396,519 $416,345 $437,163 $459,021 $481,972 Annual Balance ($214,044) ($119,383) ($294,205) ($259,219) ($332,697) ($255,767) ($253,401) ($262,569) ($847,240) ($243,378) ($238,950) ($233,918) ($228,242) ($210,723) Year End Cash Balance $1,485,956 $1,366,573 $1,072,368 $813,149 $480,452 $224,685 ($28,717) ($291,286) ($1,138,526) ($1,381,904) ($1,620,855) ($1,854,773) ($2,083,014) ($2,293,737)