Page 160 - Colleyville FY19 Budget

DRAINAGE UTILITY FUND SUMMARY

ACTUALS PROJECTED BUDGETED PROJECTED PROJECTED PROJECTED PROJECTED
FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023
TOTAL BEG. WORKING CAPITAL 1,700,651 2,032,304 1,512,822 1,714,134 1,474,819 448,087 730,982
FUND REVENUES
Drainage Fees 972,082 950,880 956,760 962,640 968,520 974,400 980,280
Penalties/Misc 13,554 5,000 9,568 9,626 9,685 9,744 9,803
Interest Income 11,195 6,000 6,120 6,242 6,367 6,495 6,624
TOTAL OPERATING REVENUES 996,831 961,880 972,448 978,509 984,572 990,639 996,708
FUND EXPENSES
Drainage Operations 393,407 460,591 492,690 509,934 527,782 546,254 565,373
Stormwater Management 96,945 113,383 118,550 122,699 126,994 131,439 136,039
IS GIS 0 20,456 21,501 21,931 22,370 22,817 23,273
Non-Departmental 4,754 6,511 6,525 6,753 6,990 7,234 7,488
Compensation Adjustment 1,652 5,847 6,200 0 0 0 0
Debt Service 149,387 124,574 125,670 131,506 127,169 0 0
Interfund loan repayment 19,032 0 0 0 0 0 0
TOTAL OPERATING EXPENSES 665,178 731,362 771,136 792,824 811,304 707,744 732,173
NET REVENUE 331,653 230,518 201,312 185,685 173,268 282,894 264,535
CAPITAL EXPENDITURES
Vehicle/Equipment Replacement 0 250,000 0 0 0 0 0
Drainage CIP Projects 0 0 0 425,000 1,200,000 0 0
Update Drainage Master Plan 0 500,000 0 0 0 0 0
TOTAL EXPENDITURES 665,178 1,481,362 771,136 1,217,824 2,011,304 707,744 732,173
Addition to / (Use of) Working Capital 331,653 (519,482) 201,312 (239,315) (1,026,732) 282,894 264,535
ENDING WORKING CAPITAL 2,032,304 1,512,822 1,714,134 1,474,819 448,087 730,982 995,517
Required Coverage Ratio
(25% of debt service) 37,347 31,144 31,418 32,877 31,792 0 0
ENDING AVAILABLE WORKING CAPITA 2,032,304 1,481,679 1,682,716 1,441,942 416,295 730,982 995,517

158