Page 208 - City of Colleyville FY22 Adopted Budget

DRAINAGE UTILITY FUND SUMMARY

BUDGETED YE PROJECTED PROJECTED PROJECTED PROJECTED PROJECTED PROJECTED
FY 2021 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 FY 2026
TOTAL BEG. WORKING CAPITAL 718,287 718,287 939,603 1,276,267 1,592,397 1,882,684 2,145,473
FUND REVENUES
Drainage Fees 962,640 1,007,839 1,015,000 1,020,075 1,025,175 1,030,301 1,035,453
Penalties/Misc 9,626 3,000 9,626 9,722 9,819 9,918 10,017
Interest Income 6,242 1,000 6,242 6,304 6,367 6,431 6,495
TOTAL OPERATING REVENUES 978,508 1,011,839 1,030,868 1,036,102 1,041,362 1,046,651 1,051,967
FUND EXPENSES
Drainage Operations 505,457 469,171 510,007 529,452 553,034 577,932 598,209
Stormwater Management 147,233 155,045 153,021 158,358 164,608 171,165 176,253
IS GIS 23,731 24,694 24,564 25,351 26,418 27,540 28,298
Non-Departmental 6,612 6,131 6,612 6,810 7,015 7,225 7,442
Debt Service 127,169 135,482 0 0 0 0 0
TOTAL OPERATING EXPENSES 810,202 790,523 694,204 719,972 751,075 783,863 810,203
NET REVENUE 168,306 221,316 336,664 316,130 290,288 262,789 241,764
ENDING WORKING CAPITAL 886,593 939,603 1,276,267 1,592,397 1,882,684 2,145,473 2,387,237
Required Coverage Ratio
(25% of debt service) 31,792 0 0 0 0 0 0
ENDING AVAILABLE WORKING CAPITAL 854,800 939,603 1,276,267 1,592,397 1,882,684 2,145,473 2,387,237
Days of Working Capital 399 434 671 807 915 999 1,075

206