Page 52 - Colleyville FY21 Budget

ALL FUNDS SUMMARY - ESTIMATE OF FINANCIAL POSITION AT SEPTEMBER 30, 2021

DEBT DRAINAGE HOTEL
GENERAL UTILITY SERVICE UTILITY OCCUPANCY TOTAL
FUND FUND FUND FUND FUND ALL FUNDS

ESTIMATED BALANCE
AT OCTOBER 1, 2020* $9,577,213 $6,961,904 $960,350 $901,191 $295,594 $18,400,658

AD VALOREM TAXES $15,320,000 $0 $770,000 $0 $0 $16,090,000
FRANCHISE TAXES 2,053,000 0 0 0 0 2,053,000
SALES/HOTEL/BEVERAGE TAXES 4,305,000 0 0 0 235,000 4,305,000
LICENSES AND PERMITS 820,000 0 0 0 0 820,000
FINES 620,000 0 0 0 0 620,000
CHARGES FOR SERVICE 799,875 17,375,258 0 962,640 0 19,137,773
INTERGOVERNMENTAL 482,327 0 0 0 0 482,327
MISCELLANEOUS/INTEREST INCOME 248,000 525,000 12,500 15,868 2,500 801,368
INTERFUND TRANSFERS (IN) 476,179 0 0 0 0 476,179

ESTIMATED REVENUES $25,124,381 $17,900,258 $782,500 $978,508 $237,500 $44,785,647

GENERAL MANAGEMENT $ 1,743,669 $0 $0 $0 $57,592 $1,743,669
FINANCE/COURT/UTILITY BILLING 1,233,299 469,229 0 0 0 1,702,528
ECONOMIC DEVELOPMENT 224,599 0 0 0 20,000 224,599
ADVERTISING/PROMOTION 0 0 0 0 60,000
ENGINEERING 380,559 0 0 0 0 380,559
INFORMATION SERVICES 954,738 73,453 0 23,731 0 1,051,922
COMMUNITY DEVELOPMENT 921,315 0 0 0 0 921,315
POLICE 5,296,774 0 0 0 0 5,296,774
FIRE 6,239,520 0 0 0 0 6,239,520
LIBRARY 605,426 0 0 0 0 605,426
PARKS & RECREATION 1,824,964 0 0 0 0 1,824,964
COLLEYVILLE CENTER 210,045 0 0 0 189,584 210,045
PUBLIC WORKS:STREETS/DRAINAGE** 3,356,893 0 0 652,690 0 4,009,583
UTILITY OPERATIONS 0 16,336,509 0 0 0 16,336,509
NON-DEPARTMENTAL 1,113,345 233,605 0 6,612 0 1,353,562
DEBT SERVICE 0 0 810,677 127,169 0 937,846
INTERFUND TRANSFERS (OUT)*** 2,121,000 812,961 0 0 0 2,933,961

ESTIMATED EXPENDITURES $26,226,146 $17,925,757 $810,677 $810,202 $327,176 $45,772,782
ESTIMATED BALANCE
AT SEPTEMBER 30, 2019 $8,475,448 $6,936,405 $932,173 $1,069,497 $205,918 $17,413,523

NET INCREASE/DECREASE ($1,101,765) ($25,500) ($28,177) $168,306 ($89,676) ($987,135)
PLANNED USE OF FUND BALANCE $1,750,000 $25,500 $28,177 $0 $89,676 $1,893,353

RECURRING REVS/RECURRING EXPS $648,235 $0 $0 $168,306 $0 $906,218
REQUIRED RESERVE (90 DAYS) $6,466,721 $4,420,050 $199,893 $199,776 $80,674 $11,367,113

NOTES:
* BALANCES ARE UNAUDITED
**PUBLIC WORKS GENERAL FUND BUDGET INCLUDES AN ONGOING TRANSFER OF $1,500,000 TO THE CAPITAL PROJECTS FUND
FOR STREET PROJECTS
***THIS INCLUDES AN ANNUAL TRANSFER TO THE VEHICLE REPLACEMENT FUND AND A ONE-TIME TRANSFER OF
$1,750,000 FROM THE GENERAL FUND TO THE TIF FOR CAPITAL PROJECTS

50