Page 178 - City of Colleyville FY22 Adopted Budget

UTILITY OPERATING FUND SUMMARY

BUDGET YE PROJECTED PROJECTION PROJECTION PROJECTION PROJECTION PROJECTION
FY 2021 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 FY 2026
BEG. WORKING CAPITAL 5,873,267 5,873,267 5,699,511 5,699,511 5,699,511 5,699,511 5,999,512
FUND REVENUES
Water - Base Rate 1,864,515 1,830,000 1,985,445 2,033,794 2,121,951 2,214,721 2,288,415
Water - Volumetric Rate 10,605,069 9,277,232 10,605,069 11,279,218 12,268,231 13,034,567 13,785,183
Sale of Material 0 3,214 0 0 0 0 0
Wastewater - Base Rate 1,339,711 1,380,000 1,452,695 1,505,730 1,570,648 1,722,022 1,773,340
Wastewater - Volumetric Rate 3,303,963 3,259,153 3,303,963 3,761,298 4,010,841 4,500,345 4,753,070
Water Installation 42,000 20,000 42,000 42,420 42,844 43,273 43,705
Wastewater Installation 15,000 7,000 15,000 15,150 15,302 15,455 15,609
T.R.A. TRUE-UP 450,000 1,452,481 450,000 450,000 450,000 450,000 450,000
Engineering Charges 5,000 5,000 5,000 5,050 5,101 5,152 5,203
Penalties 200,000 50,000 200,000 202,000 204,020 206,060 208,121
Miscellaneous 15,000 7,000 15,000 15,150 15,302 15,455 15,609
Interest Income 60,000 10,000 14,000 14,140 14,281 14,424 14,568
TOTAL REVENUES 17,900,259 17,301,081 18,088,171 19,323,951 20,718,519 22,221,472 23,352,824
FUND EXPENSES .
Utility Billing 469,229 418,052 482,912 499,586 519,485 540,392 557,779
IS GIS 73,453 77,235 76,032 78,815 82,128 85,613 87,968
Utility Support 1,213,381 1,186,007 1,273,326 1,317,089 1,372,769 1,431,390 1,473,424
Utility Operations - Water 795,589 838,022 908,623 917,438 957,241 999,177 1,035,026
TRA Water (volumetric) 6,923,612 6,056,723 6,923,613 7,363,737 8,009,422 8,509,732 8,999,778
TRA Water (debt) 3,681,456 3,220,509 3,681,456 3,915,481 4,258,808 4,524,835 4,785,405
Utility Operations - WW 418,507 366,651 368,803 383,128 400,674 419,230 434,800
TRA Wastewater 3,303,963 3,259,153 3,303,963 3,761,298 4,010,841 4,283,369 4,534,585
Non-Departmental 233,605 237,043 233,605 240,613 247,832 255,266 262,924
Transfer to General Fund 281,861 281,861 304,738 315,666 328,219 341,368 350,034
T.R.A. True-Up 450,000 1,452,481 450,000 450,000 450,000 450,000 450,000
VERF Transfer 81,100 81,100 81,100 81,100 81,100 81,100 81,100
TOTAL EXPENDITURES 17,925,757 17,474,837 18,088,171 19,323,951 20,718,519 21,921,472 23,052,824
ENDING WORKING CAPITAL 5,847,769 5,699,511 5,699,511 5,699,511 5,699,511 5,999,512 6,299,514

T.R.A. Revenues / Expenses (not controlled by customer consumption)
City-controlled Revenues (base rates) / Expenses (overhead to run the system)
Days of Working Capital 119 119 115 108 100 100 100
Notes:
1. In FY 2017 the Utility Fund was divided into a Utility Operating Fund (shown here) and a Utility Capital Projects Fund
(to separately track resources for utility capital projects). Depreciation expenses are not included.
2. Year-end operating surpluses are transferred to the Utility Capital Projects Fund for future utility capital projects. A
minimum of 100 days of reserves are maintained in the Utility Operating Fund.
3. In FY 2018, all Utility Fund debt was paid off by the City of Colleyville. The City is working to make a complete
transition to a cash funded strategy.
4. Costs and revenues highlighted in yellow represent volumetric charges from the Trinity River Authority. The City
then charges its customers a rate desigend to pass those costs through to them. Projections for fiscal years 2023
through 2026 include the most recent available information from the Trinity River Authority regarding operations and
debt service costs.

176