|
Table MSanitary Sewer FundProjected Year End Cash BalanceModel Year2025 2026 2027 2028 2029 2030 2031 2032 2033 2034Use of CashOperations & Maintenance 1,214,838 1,509,421 1,597,852 1,697,556 1,811,985 1,931,093 2,052,421 2,178,075 2,313,163 2,446,522 Capital Acquisition 2,073,660 - 309,000 1,273,080 - 2,459,237 - - - - Interfund Transfers Out - - - - - - - - - - Debt Service (includes transfers for debt) 1,311,225 1,304,013 1,295,913 1,291,625 1,286,122 1,279,363 1,214,550 1,184,775 1,127,838 899,688 Total Use of Cash 4,599,723 2,813,434 3,202,764 4,262,261 3,098,107 5,669,692 3,266,971 3,362,850 3,441,001 3,346,210 Source of CashRevenues 4,063,826 2,325,251 3,156,767 3,294,484 2,934,638 6,002,576 3,382,198 3,832,184 4,067,059 4,204,753 Bond Proceeds - - - - - - - - - - Interfund Transfers In - - - - - - - - - - Total Source of Cash 4,063,826 2,325,251 3,156,767 3,294,484 2,934,638 6,002,576 3,382,198 3,832,184 4,067,059 4,204,753 Net Change in Other Assets and Liabilities 124,673 231,865 230,275 (571,464) 218,155 (1,582,671) 203,732 205,163 205,883 164,679 Change in Cash Balance (411,225) (256,318) 184,277 (1,539,242) 54,686 (1,249,788) 318,958 674,497 831,941 1,023,222 Beginning Cash Balance 12,519,471 12,108,246 11,851,928 12,036,205 10,496,964 10,551,650 9,301,862 9,620,820 10,295,317 11,127,257 Ending Cash12,108,246 11,851,928 12,036,205 10,496,964 10,551,650 9,301,862 9,620,820 10,295,317 11,127,257 12,150,480 Ending Cash by PurposeCash for next year planned capital - 309,000 1,273,080 - 2,459,237 - - - - - Cash for next year debt service 1,304,013 1,295,913 1,291,625 1,286,122 1,279,363 1,214,550 1,184,775 1,127,838 899,688 759,934 Restricted availability charges 10,049,523 9,084,088 8,088,375 7,063,878 5,847,504 4,985,450 3,955,225 2,952,163 2,150,313 1,465,066 Unrestricted cash 754,711 1,162,928 1,383,125 2,146,964 965,547 3,101,862 4,480,820 6,215,317 8,077,257 9,925,480 Ending Cash 12,108,246 11,851,928 12,036,205 10,496,964 10,551,650 9,301,862 9,620,820 10,295,317 11,127,257 12,150,480 Net PositionEnding Unrestricted Net Position 16,342,595 15,804,264 15,708,118 14,690,193 14,476,573 14,760,290 14,826,714 15,248,677 15,832,937 16,649,684 Projected
|