Laserfiche WebLink
Table K <br />Water Fund <br />Projected Year End Cash Balance <br />Current Year <br />2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 <br />Use of Cash <br />Operations & Maintenance 994,392 1,187,169 1,628,404 2,037,756 2,098,889 2,161,856 2,226,711 2,293,513 2,362,318 2,433,188 <br />Capital Acquisition 3,582,559 28,688,275 25,992,610 3,117,661 1,840,000 1,720,000 2,182,964 2,248,336 258,274 1,723,416 <br />Interfund Transfers Out - - - - - - - - - - <br />Debt Service (includes transfers for debt) 1,524,262 1,573,630 1,587,973 1,663,521 1,929,971 2,066,307 2,192,398 1,850,954 1,937,960 1,684,919 <br />Total Use of Cash 6,101,213 31,449,074 29,208,987 6,818,938 5,868,860 5,948,163 6,602,073 6,392,803 4,558,552 5,841,522 <br />Source of Cash <br />Revenues 6,477,438 32,492,715 27,709,564 4,989,538 4,565,564 6,033,578 6,895,714 6,551,314 7,205,819 7,658,355 <br />Bond Proceeds 470,000 325,000 785,000 2,810,000 1,840,000 1,720,000 2,125,000 1,825,000 - 710,000 <br />Interfund Transfers In - - - - - - - - - - <br />Total Source of Cash 6,947,438 32,817,715 28,494,564 7,799,538 6,405,564 7,753,578 9,020,714 8,376,314 7,205,819 8,368,355 <br />Net Change in Other Assets and Liabilities (1,160,149) (18,152) (18,094) (22,405) (22,405) (22,802) (19,828) (16,743) (10,180) (6,768) <br />Change in Cash Balance (313,925) 1,350,489 (732,517) 958,195 514,299 1,782,613 2,398,813 1,966,769 2,637,087 2,520,064 <br />Beginning Cash Balance 5,792,477 5,478,552 6,829,041 6,096,525 7,054,720 7,569,019 9,351,632 11,750,445 13,717,214 16,354,301 <br />Ending Cash 5,478,552 6,829,041 6,096,525 7,054,720 7,569,019 9,351,632 11,750,445 13,717,214 16,354,301 18,874,365 <br />Ending Cash by Purpose <br />Cash for next year planned capital 28,363,275 25,207,610 307,661 - - 57,964 423,336 258,274 1,013,416 500,000 <br />Cash for next year debt service 1,573,630 1,587,973 1,663,521 1,929,971 2,066,307 2,192,398 1,850,954 1,937,960 1,684,919 1,624,483 <br />Restricted availability charges - - 3,106,465 4,075,304 4,421,784 5,987,915 8,329,399 10,339,821 10,215,081 9,735,517 <br />Unrestricted cash (24,458,353) (19,966,542) 1,018,878 1,049,444 1,080,928 1,113,356 1,146,756 1,181,159 3,440,885 7,014,365 <br />Ending Cash 5,478,552 6,829,041 6,096,525 7,054,720 7,569,019 9,351,632 11,750,445 13,717,214 16,354,301 18,874,365 <br />Net Position <br />Ending Unrestricted Net Position 5,024,744 6,393,385 5,678,962 6,659,562 7,196,266 9,001,681 11,420,323 13,403,835 16,051,102 18,577,934 <br />Subsequent Year's Expenses 4,505,976 5,583,557 6,104,267 6,277,265 6,393,511 6,529,644 6,675,976 6,739,323 6,808,181 7,120,076 <br />Ending Unrestricted Net Position as % of Expenses 111.5% 114.5% 93.0% 106.1% 112.6% 137.9% 171.1% 198.9% 235.8% 260.9% <br />Projected