Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5.b2 2022 Uptown Sewer DRAFT Cash-Flow Analysis Presented 12-15-2021
DRAFT UTILITIES BUDGET DRAFT Fund 612 YTD Actual 2019 2020 7/31/2021 2021 2022 2023 2024 2025 2026 2027 2027 2027 2027 REVENUE Charges for services 20,535 12,546 3,393 23,000 19,500 (1) 14,413 19,451 21,049 23,153 27,506 28,056 28,618 29,190 Special assessments - - - - - - - - - - - - - Intergovernmental 11 11 - - - - - - - - - - - Interest earnings - 241 - - 63 (2) 64 34 91 (14) (842) (858) (713) (943) Miscellaneous - - - - - - - - - - - - - Bond Proceeds - - - - - - - - - - 145,000 - - Transfer In - - - - - - - - - - - - - TOTAL REVENUES 20,546 12,799 3,393 23,000 19,563 14,477 19,485 21,140 23,140 26,665 172,199 27,905 28,247 EXPENDITURES Wages 4,636 4,805 2,471 10,235 10,920 (3) 11,138 11,361 11,588 11,820 12,297 12,543 12,794 13,050 Materials 257 139 - 545 500 (3) 510 520 530 541 563 574 585 597 Professional Services 579 1,119 728 700 700 (3) 714 728 743 758 788 804 820 836 Repair and Maintenance 1,206 80 (260) 3,300 3,300 (3) 3,366 3,433 3,502 3,572 3,716 3,790 3,866 3,943 Other 2,625 1,277 935 3,950 3,950 (3) 4,029 4,110 4,192 4,276 4,449 4,538 4,629 4,722 Depreciation 4,877 4,877 - 4,877 5,100 (3) 5,202 5,306 5,412 5,520 5,743 5,858 5,975 6,095 Debt Service Expense - - - - - - - - - - 16,998 16,998 Capital Outlay - - - 4,000 2,600 (3) 4,867 4,499 7,604 21,291 5,922 140,278 3,558 9,622 Transfer Out 2,640 - - - - - - - - - - - - TOTAL EXPENDITURES (16,819) (12,296) (3,873) (27,607) (27,070) (29,826) (29,957) (33,571) (47,778) (33,478) (168,385) (49,226) (55,863) Audit Adj NET REVENUE OVER (UNDER) EXPENSE 3,727 503 (480) (4,607) (7,507) (15,349) (10,473) (12,431) (24,639) (6,813) 3,813 (21,321) (27,616) Target Cash 7,291 3,710 7,472 14,885 12,479 14,943 14,777 18,088 31,984 17,046 23,624 32,131 9,622 Over (Under)Target 2,055 15,623 11,031 6,065 8,927 (3,685)(8,685)(19,015)(52,030)(74,238)(71,144)(94,997)(94,009) ENDING BALANCE 9,346 19,332 18,503 20,950 21,406 11,259 6,092 (927) (20,046) (57,191) (47,520) (62,866) (84,387) Actual Budget Projected Projected ACTUALs FOR YEAR ENDED DECEMBER 31, 2019 AND 2020, PERIOD TO DATE JULY 31, 2021 AND BUDGET FOR THE YEARS ENDED DECEMBER 31, 2021 & 2022, AND PROJECTIONS THRU YRS 2023-2026 UPTOWN SEWER FUND (Fund 612) CASHFLOW ANALYSIS DRAFT 1 of 1 Presented 12/15/2021