Page 10 - NEXT YEAR BUDGET DETAIL REPORT

Multi-Year Forecast

In order to operate as efficiently as possible, staff continually evaluates all tax-funded services
together over a multi-year financial projection. As expenses will consistently outpace revenue
growth, adjustments to Colleyville’s tax rate become increasingly necessary in order to maintain
financial solvency into the future. A summary of our most recent forecast is as follows:

Revenues and Expenses for all Non-Utility Services (General
Fund, CEDC Fund, CCCPD Fund, Hotel Tax Fund, Debt Service)

General City Summary FY24 FY25 FY26 FY27 FY28
Revenues
Ad Valorem Tax $ 17,776,505 $ 18,904,137 $ 19,876,778 $ 20,466,039 $ 21,028,112
Sales Tax $ 10,619,960 $ 10,829,109 $ 11,094,913 $ 11,367,313 $ 11,646,473
Franchise Tax $ 2,097,000 $ 2,117,970 $ 2,139,150 $ 2,160,541 $ 2,182,147
Licenses / Permits $ 907,850 $ 879,429 $ 852,598 $ 827,280 $ 803,401
Fines $ 550,000 $ 555,500 $ 561,055 $ 566,666 $ 572,332
Service Charges $ 936,875 $ 946,244 $ 955,706 $ 965,263 $ 974,916
Intergov $ 503,045 $ 549,184 $ 568,115 $ 588,256 $ 608,320
Misc $ 992,200 $ 1,018,480 $ 1,028,415 $ 1,038,449 $ 1,048,583
Transfers $ 669,662 $ 695,321 $ 723,234 $ 752,705 $ 782,743
Total General City Revenues $ 35,053,097 $ 36,495,373 $ 37,799,963 $ 38,732,512 $ 39,647,028

Expenses
Total Salary/Benefits $ 22,192,493 $ 23,295,951 $ 24,396,092 $ 25,565,798 $ 26,738,490
Total Contractual Services $ 7,174,491 $ 7,342,035 $ 7,566,454 $ 7,802,020 $ 8,045,410
Total Supplies $ 1,263,410 $ 1,235,989 $ 1,255,008 $ 1,274,327 $ 1,293,950
Total Debt Service $ 1,235,460 $ 1,880,895 $ 1,758,244 $ 1,713,110 $ 1,640,110
Total Capital $ 1,588,806 $ 972,444 $ 1,430,531 $ 1,018,814 $ 1,112,296
Total Transfers $ 524,706 $ 203,706 $ 203,706 $ 203,706 $ 203,706
Total General City Expenses $ 33,979,366 $ 34,931,021 $ 36,610,036 $ 37,577,774 $ 39,033,961

Over/(Under) $ 1,073,731 $ 1,564,352 $ 1,189,927 $ 1,154,738 $ 613,067

Beginning Balances $ 18,053,443 $ 19,127,174 $ 20,691,526 $ 21,881,453 $ 23,036,191

Ending Balances $ 19,127,174 $ 20,691,526 $ 21,881,453 $ 23,036,191 $ 23,649,258

This forecast snapshot incorporates conservative assumptions on expenditure and revenue growth,
all known debt service plans into the future, and assumes little additional growth in the City’s
employee count. It also incorporates our tax rate proposal for this year and assumes 3.5% growth
in the operating portion of that revenue stream into the future. While these tax adjustments enable
Colleyville to operate with cash surpluses through our five-year forecast, expenses are nonetheless
expected to outpace revenues, lessening the City’s operating margins year-over-year.

10