|
Table KWater FundProjected Year End Cash BalanceCurrent Year2024 2025 2026 2027 2028 2029 2030 2031 2032 2033Use of CashOperations & Maintenance 1,257,669 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 Capital Acquisition 1,381,344 1,686,475 1,500,800 3,117,661 1,840,000 1,720,000 2,182,964 2,214,414 258,274 1,710,140 Interfund Transfers Out - - - - - - - - - - Debt Service (includes transfers for debt) 1,524,262 1,573,630 1,657,973 1,762,721 2,029,571 2,158,607 2,292,298 1,948,254 1,873,994 1,618,819 Total Use of Cash 4,163,275 4,447,274 4,787,177 6,918,138 5,968,460 6,040,463 6,701,973 6,456,181 4,494,585 5,762,146 Source of CashRevenues 4,452,239 5,454,809 2,975,260 4,463,097 3,592,055 4,479,661 5,474,753 5,341,960 6,289,540 7,123,239 Bond Proceeds 470,000 1,090,000 1,130,000 2,810,000 1,840,000 1,720,000 2,125,000 - - - Interfund Transfers In - - - - - - - - - - Total Source of Cash 4,922,239 6,544,809 4,105,260 7,273,097 5,432,055 6,199,661 7,599,753 5,341,960 6,289,540 7,123,239 Net Change in Other Assets and Liabilities (1,486,878) (18,152) (18,094) (22,405) (22,405) (22,802) (19,828) (16,743) (10,180) (6,768) Change in Cash Balance (727,914) 2,079,383 (700,011) 332,554 (558,810) 136,396 877,953 (1,130,964) 1,784,775 1,354,325 Beginning Cash Balance 5,787,696 5,059,782 7,139,165 6,439,154 6,771,708 6,212,898 6,349,294 7,227,247 6,096,283 7,881,058 Ending Cash5,059,782 7,139,165 6,439,154 6,771,708 6,212,898 6,349,294 7,227,247 6,096,283 7,881,058 9,235,383 Ending Cash by PurposeCash for next year planned capital 596,475 370,800 307,661 - - 57,964 2,214,414 258,274 1,710,140 500,000 Cash for next year debt service 1,573,630 1,657,973 1,762,721 2,029,571 2,158,607 2,292,298 1,948,254 1,873,994 1,618,819 1,501,750 Restricted availability charges 2,296,092 4,296,190 3,349,894 3,692,693 2,973,363 2,885,677 1,917,822 2,782,856 3,335,506 5,980,541 Unrestricted cash 593,585 814,202 1,018,878 1,049,444 1,080,928 1,113,356 1,146,756 1,181,159 1,216,594 1,253,092 Ending Cash 5,059,782 7,139,165 6,439,154 6,771,708 6,212,898 6,349,294 7,227,247 6,096,283 7,881,058 9,235,383 Net PositionEnding Unrestricted Net Position 5,180,973 7,278,508 6,596,591 6,951,551 6,415,146 6,574,344 7,472,124 6,357,903 8,152,859 9,513,951 Subsequent Year's Expenses 3,790,525 4,283,796 4,805,516 4,973,914 5,087,861 5,221,593 5,331,404 5,342,406 5,410,854 5,443,927 Ending Unrestricted Net Position as % of Expenses 136.7% 169.9% 137.3% 139.8% 126.1% 125.9% 140.2% 119.0% 150.7% 174.8%Projected
|