Page 54 - City of Colleyville FY22 Adopted Budget

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

ALL OPERATING FUND SUMMARIES AND RELATIONSHIP BETWEEN FUNCTIONAL UNITS AND FUNDS
DEBT HOTEL DRAINAGE ECONOMIC CRIME CONTROL
GENERAL UTILITY SERVICE OCCUPANCY UTILITY DEVELOPMENT AND PREVENTION TOTAL
FUND FUND FUND TAX FUND FUND FUND DISTRICT FUND ALL FUNDS
ESTIMATED BALANCE
AT OCTOBER 1, 2021* $8,984,376 $5,699,511 $692,695 $245,560 $939,603 $5,799,376 $1,979,200 $24,340,321
AD VALOREM TAXES $15,640,000 $0 $552,000 $0 $0 $0 $0 $16,192,000
FRANCHISE TAXES 1,973,000 0 0 0 0 0 0 1,973,000
SALES TAXES 4,505,000 0 0 250,000 0 2,150,000 2,000,000 8,905,000
LICENSES AND PERMITS 867,000 0 0 0 0 0 0 867,000
FINES 586,000 0 0 0 0 0 0 586,000
CHARGES FOR SERVICE 914,875 17,609,171 0 0 1,024,626 0 0 19,548,672
INTERGOVERNMENTAL 476,758 450,000 0 0 0 225,000 0 1,151,758
MISCELLANEOUS/INTEREST 198,000 29,000 6,000 2,500 6,242 10,000 1,200 252,942
INTERFUND TRANSFERS (IN) 499,056 0 0 0 0 0 0 499,056
ESTIMATED REVENUES $25,659,689 $18,088,171 $558,000 $252,500 $1,030,868 $2,385,000 $2,001,200 $49,975,429

CITY COUNCIL $ 220,751 $0 $0 $0 $0 $2,000 $0 $222,751
CITY MANAGER'S OFFICE 771,922 0 0 0 0 0 0 0
CITY SECRETARY 261,589 0 0 0 0 0 0 0
LEGAL 242,008 0 0 0 0 0 0 0
HUMAN RESOURCES 366,430 0 0 0 0 0 0 0
COMMUNICATIONS 127,145 0 0 143,499 0 260,000 0 $530,644
COURT 546,905 0 0 0 0 0 0 $546,905
FINANCE/UTILITY BILLING 730,457 482,912 0 0 0 0 0 $1,213,369
ECONOMIC DEVELOPMENT 247,411 0 0 0 0 0 0 $247,411
ENGINEERING 393,682 0 0 0 0 0 0 $393,682
INFORMATION SERVICES 1,060,674 76,032 0 0 24,564 0 0 $1,161,270
COMMUNITY DEVELOPMENT 947,284 0 0 0 0 0 0 $947,284
POLICE 5,192,390 0 0 0 0 0 2,217,069 $7,409,459
FIRE 6,744,999 0 0 0 0 0 0 $6,744,999
LIBRARY 592,279 0 0 0 0 470,618 0 $1,062,897
PARKS & RECREATION 1,615,454 0 0 0 0 1,331,202 0 $2,946,656
COLLEYVILLE CENTER 213,604 0 0 104,323 0 223,808 0 $541,735
PUBLIC WORKS** 3,358,298 0 0 0 663,028 300,000 0 $4,321,326
UTILITY OPERATIONS 0 16,459,784 0 0 0 0 0 $16,459,784
NON-DEPARTMENTAL 1,125,862 233,605 0 0 6,612 0 0 $1,366,079
DEBT SERVICE 0 0 821,898 0 0 0 0 $821,898
INTERFUND TRANSFERS (OUT) 371,000 835,838 0 0 0 5,000,000 0 $6,206,838
ESTIMATED EXPENDITURES $ 25,130,144 $18,088,171 $821,898 $247,822 $694,204 $7,587,628 $2,217,069 $54,786,937

ESTIMATED BALANCE $9,513,921 $5,699,511 $428,797 $250,238 $1,276,267 $596,748 $1,763,331 $19,528,813
AT SEPTEMBER 30, 2019
NET INCREASE/DECREASE $529,545 $0 ($263,898) $4,678 $336,664 ($5,202,628) ($215,869) $606,989

REQUIRED RESERVE (90
DAYS OPERATING COSTS) $6,196,474 $4,460,097 $202,660 $61,107 $171,174 $339,652 $546,674 $11,091,511

NOTES:
* BALANCES ARE UNAUDITED
**PUBLIC WORKS GENERAL FUND BUDGET INCLUDES A TRANSFER OF $1,500,000 TO THE CAPITAL PROJECTS FUND
FOR STREET PROJECTS

52