Overview of General Fund Revenues and Expenditures in a City

GENERAL FUND REVENUES Projected Beginning Balance $ 8,000,000 Projected Revenues $ 33,388,872 Projected Expenditures $( 33,388,872) Projected Fund Balance $ 8,000,000 Sales Tax 36% Reserved Carryover 19% Charges for Services 4% Licenses/Permits/Fees 1% Interest Income 1% Franchise Taxes 3% Fines 1% Other Taxes 7% Transfers In 28%

GENERAL FUND EXPENDITURES City Council & City Attorney 1% Fire 9% Managerial 3% Streets 1% Info Tec & Library 2% Parks & Recreation 7% Animal Welfare 1% General Government 5% Support Services 2% Police 11% Transfers Out 37% Finance 1% Community Development 1% Reserved Carryover 19%

GENERAL FUND GENERAL FUND - - 01 01 FY25 sales tax projection is based on most current data available (a flat budget). Transfer of $200,000 from the Defined Contribution Fund for a tax-deferred retirement savings and investment plan that offers full-time eligible employees savings and a tax benefit. All regular full-time employees will now collect 50% of their sick leave balance upon retirement. A $250k transfer from the Hotel Tax Fund to cover City Attorney s wages and benefits. Transfer of $400,000 from the Personal Service Fund (10% of 4thpenny sales tax). A 6.68% CPI rate increase for equipment and operation for 3rd party contractor Silver Star Construction. Primary operating fund of the city. Used to account for all activities except those legally or administratively required to be accounted for in other funds. The general fund includes most of the basic operating activities of a government entity such as general administration like the council, city manager, finance or community development departments, police and fire departments, parks and recreation and library.

GENERAL FUND GENERAL FUND 01 (CONT D) (CONT D) 01 A decision to not add additional positions in FY25 and address the compensation of current employees. Non-Union Regular Employees - will receive a flat increase of $1 per hour, merit increase of 5% for all eligible full-time employees, excluding directors. Fraternal Order of Police (FOP) contract includes approximately an 8% cost of living adjustment for sergeants and officers, and one additional steps being added for lieutenant and captain positions. International Association of Firefighters (IAFF) contract includes a $1 per hour increase plus standard pay scale of 4% for all union positions.

GENERAL RESERVE GENERAL RESERVE - - 02 02 Established by Resolution 06-017. Original funding deposited from other funds for maintenance of City facilities, infrastructure, and other capital purchases. Ordinance No. 1105, approved on July 15, 2015 to levy a tax of five percent (5%) on the rental of hotel and motel rooms within the city limits. All taxes collected shall be deposited into the City s General Fund. Use of funds for the purpose of encouraging, promoting, and fostering economic development, convention, tourism, and parks & recreation for the City. The funds may be used for the employment of personnel, purchase or lease of assets, pledge for indebtedness or to fund contracts for services as the City Council deem appropriate. The City Council shall determine on a yearly basis the use of the room tax funds. A transfer of $250,000 from the Hotel Tax Fund to cover City Attorney s wages and benefits are scheduled for fiscal year 2025.

IMPOUND FEE IMPOUND FEE - - 04 04 Established by Ordinance No.1102 on May 8, 2014 amending Chapter 114, Article IX to Impoundment of Vehicles . Restricted fund to account for the $100 fee to remove a vehicle from any street, highway, private or public property to a storage facility.

PARK IMPROVEMENT PARK IMPROVEMENT - - 05 05 Used to account for the revenue received from business licenses ($15 per license) required by ordinance; court costs assessed for parks; and park fees from subdivisions. (Resolution 05-013). Restricted for improvements to and development of the park system.

ALCOHOL ALCOHOL ENFORCEMENT ENFORCEMENT - - 06 06 Used to account for restricted fines and fees generated as a result of intoxicating substances and traffic related offences (Ordinance No. 1087, Title 11 Oklahoma Statutes 14-111C).

LIBRARY FUND - 07 Used to account for restricted state grant agreements and fines generated as a result of overdue library materials. Funds are used for library operations, local programs, and capital purchases.

TRAFFIC ENFORCEMENT TRAFFIC ENFORCEMENT - - 08 08 Used to account for restricted fines and fees restricted for capital and training expenses related to traffic enforcement (Ordinance No. 920).

EMPLOYEE FLEX EMPLOYEE FLEX SPENDING SPENDING - - 10 10 The City offers its employees a Flexible Spending Program, which is allowable under Internal Revenue Code, Section 125. The program allows employees to deposit a portion of their pre-tax income into the account maintained for health care expenditures.

PARK & RECREATION PARK & RECREATION DONATION DONATION - - 11 11 Title O.S., 33-109 requires money derived from recreation grants, gifts or bequests be deposited by the City Treasurer in a separate continuing fund, unless otherwise specified by the donor or grantor, and be used for the specified recreation purposes.

POLICE POLICE TECHNOLOGY TECHNOLOGY FEES FEES - - 13 13 Used to account for fines and fees restricted for the sole purpose of funding acquisition, operation, maintenance, repair and replace of police technological advances and upgrades, data processing equipment and software related to the administration of the municipal laws and the municipal criminal justice system. Ordinance No. 1146 established legislative restriction approved April 18, 2017, effective July 1, 2017.

STREET & DRAINAGE STREET & DRAINAGE IMPROVEMENT IMPROVEMENT - - 14 14 Used to account for the proceeds of specified revenue sources that are restricted or committed to expenditures for street/drainage projects and repair.

PERSONAL SERVICES PERSONAL SERVICES ( 10% PUBLIC SAFETY ( 10% PUBLIC SAFETY PERSONNEL PERSONNEL 4 4TH FUND 15 FUND 15 THPENNY) PENNY) Mustang citizens voted on August 23, 2016 to extend the 4thpenny sales tax for a 13- year period. Fund 15 collects the 10% allocation of revenues restricted for personnel costs related to public safety.

POLICE NARCOTICS POLICE NARCOTICS ENFORCEMENT ENFORCEMENT - - 16 16 Used to account for fines and fees restricted for the sole purpose of funding equipment and drug testing kits, education, training, and scientific development of police personnel and canine development. Ordinance No. 1161 established legislative restriction approved April 3, 2018.

JUVENILE FUND JUVENILE FUND - - 17 17 The City signed an Inter-local Cooperation Agreement for Municipal Court Jurisdiction concerning juveniles with the Canadian County District Court on March 5, 2019 (Ref. Resolution 19-029). Oklahoma Statutes Title 10A, Children and Juvenile Code, Sections 10A-2-2-103, restrict funds generated from juvenile fines must be earmarked for local programs which address problems of juvenile crimes; costs of prosecutions; detention, administrative costs related to local programs that address problems of juvenile crime, and costs of community intervention centers authorized pursuant to Section 9 of this act.

DEFINED CONTRIBUTION DEFINED CONTRIBUTION (DC) PLAN (DC) PLAN - - 18 18 A tax A tax- -deferred retirement plan in deferred retirement plan in which employees allocate part of their which employees allocate part of their paychecks to an account funding their paychecks to an account funding their retirements. retirements. Eligible Eligible full the opportunity to save part of their the opportunity to save part of their income for retirement, receiving a income for retirement, receiving a matching up to 2% from agency matching up to 2% from agency contribution, and reduce current contribution, and reduce current taxes. taxes. full- -time employees will have time employees will have

DISTRIBUTOR OKLAHOMA DISTRIBUTOR OKLAHOMA SETTLEMENT SETTLEMENT - - 19 19 The city approved settlements of its The city approved settlements of its opioid opioid- -related claims against certain related claims against certain defendants to receive payments from defendants to receive payments from Johnson & Johnson and the Opioid Johnson & Johnson and the Opioid Distributors. Distributors. The settlement payments are The settlement payments are restricted solely for the purpose of restricted solely for the purpose of remediating the harm caused by remediating the harm caused by defendant(s) or to provide defendant(s) or to provide restitution for such harm that was restitution for such harm that was previously incurred. previously incurred.

DEBT SERVICE DEBT SERVICE - - 27 27 Used to account for ad-valorem taxes levied by the county for use in retiring general obligation bonds, court-assessed judgments, and their related interest and fiscal agent fees. In State law, referred to as the Sinking Fund. Current obligations are the: 2012 General Obligation Bond Projects Ball Field 2012 General Obligation Bond Project Town Center Expansion.

LIMITED PURPOSE LIMITED PURPOSE (CAPITAL) (CAPITAL) - - 39 39 The Limited Purpose Fund is a capital project fund used to purchase capital outlay, including the acquisition or construction of capital facilities, or other capital assets. The restricted 3rd penny sales tax collected (MIA) in excess of debt payments are set aside to the Limited Purpose Fund. Amend Resolution No. 05-027 to read 10% of sales tax revenue received in excess of $800,000 in a month .

LIMITED PURPOSE LIMITED PURPOSE (CAPITAL) (CAPITAL) - - 39 39 Mayor and Council - $ 4,000 Granicus Workstations City Attorney - $ 1,000 HP Printer $ 4,500 Westlaw National Edge $ 200 Adobe Acrobat $ 43,000 New City Attorney s Office Information Technology - $ 4,500 KnowBe4 $ 1,650 PDQ Deploy & Inventory $ 2,750 Screen Connect $ 25,000 Sophos Anti-Virus $ 4,500 User Lock $ 2,800 Veeam Backup $ 2,800 Extreme Switch $ 400 Barcode Scanner $ 2,500 Standby Computer $ 350 Office Chair $ 4,736 Windows Server CALs $ 5,200 Sophos Firewall

LIMITED PURPOSE LIMITED PURPOSE (CAPITAL) (CAPITAL) - - 39 39 City Manager - $ 200 Office Chair (HR Director) $ 30,000 Remodel Office Space $ 35,000 Truck (Program Manager) $ 8,000 Handheld Data Collector $ 2,000 Work Station (CM) $ 1,800 Laptop (Asst. CM) $ 14,000 Granicus Encoding (Program Manager) Library - $ 700 Carpet Squares $ 9,000 Public Work Stations $ 250 GoDaddy Registration $ 2,900 Firewall Parks & Recreation $ 800 Aruba AP $ 1,800 Laptop (Program Coordinator) $ 6,000 (3) Work Stations $ 2,000 Network Access Storage $ 12,000 Cardio & Weight Equipment $ 10,000 Recreation Center Funding $ 15,000 Dog Park Water Fountains $ 35,000 ADA Fishing Dock for WHP

LIMITED PURPOSE LIMITED PURPOSE (CAPITAL) (CAPITAL) - - 39 39 Parks & Recreation Cont d $ 65,001 Bleachers for Rodeo $ 12,000 Artwork for Conference Area $ 1,600 When to Work Software $ 20,000 Fencing Park Street $ 40,000 Dorchester Park Playground General Government $ 16,000 Cope Notes $ 22,500 Placer Software $ 8,500 Thrill Share Website $ 364,300 Vehicle Charging Station $ 3,000 CCTV Server $ 66,814 Emergency Capital $ 3,800,000 Restricted for FY26 Town Center $ 12,500 Painting Active Adult Center $ 3,000 Chairs for Active Adult Center $ 8,000 Painting Metal Awning $ 12,000 Carpet Replacement $ 20,000 Concrete Floors $ 6,000 CCTV Servers (2) $ 7,000 Additional Cameras $ 15,000 Town Center Funding

LIMITED PURPOSE LIMITED PURPOSE (CAPITAL) (CAPITAL) - - 39 39 Ball Complex $ 10,000 Concession Equipment $ 10,000 Turf Tank $ 10,300 Mini-Split $ 27,000 Utility Carts (2) $ 45,000 4520N Tractor $ 33,000 Shade Structures $ 100,000 Baseball Parking Lot $ 6,000 Tools for Maintenance Barn Aquatic Center $ $ 20,000 Replace Caulking for Deck $ 16,000 Paint Slide 15,000 Aquatic Center Funding Finance $ 6,000 Work Stations (3) Community Development $ 2,000 Work Station $ 45,000 Truck (Chief Building Inspector) $ 1,200 Digital Camera $ 2,000 Scanning Work Station $ 300 Additional Lighting $ 500 Network Connection $ 400 Office Chairs (3)

LIMITED PURPOSE LIMITED PURPOSE (CAPITAL) (CAPITAL) - - 39 39 Police $ 227,931 2023 Lease-Purchase $ 258,849 2024 Lease-Purchase $ 330,725 2025 Lease-Purchase $ 5,800 Net Motion $ 30,400 Tough Tablets (8) $ 4,000 Work Stations (2) $ 150,000 HVAC Software Upgrades $ 36,000 Battery Back-up System Animal Welfare $ 900 Sophos Firewall $ 350 Network Stitch $ 61,400 ACO Vehicle $ 27,500 Dog Kennel Gates Support Services $ 5,600 Dispatch Chairs (2) Fire $ 123,330 2019 Lease Purchase Aerial Truck 12,000 Tough Tablets (4) 2,000 Work Station 9,000 Overhead Garage Doors

LIMITED PURPOSE LIMITED PURPOSE (CAPITAL) (CAPITAL) - - 39 39 Fire $ 75,000 Repaint Existing Fleet $ 14,000 Replace Decals $ 13,011 X-AM 5800 Gas Monitors (2) Streets $ 573,924 Multimodal Connectivity $ 531,447 Mustang Trails $ 15,000 Poles & Signage $ 175,000 Mustang Trails Water $ 150,000 Water Meters, as needed $ 9,000 SPMR Table Software TOTAL CAPITAL: RESTRICTED C/O to FY26 $ 4,191,418 $ 3,800,000

2020A NOTE 2020A NOTE FUND 61 FUND 61 Purchased 2020A Note to apply its proceeds for refunding the 2014B Bonds which reduced the amount required to be borrowed. Total annual savings of $177,415. Funded South Mustang and Forster Drive. All projects completed. Outstanding Principal of $2.175m. Maturity Date June 1, 2026

2020 NOTE 2020 NOTE FUND 62 FUND 62 August 12, 2020, the City issued the Utility System and Sales Tax Revenue Note, Series 2020 in the amount of $4,021,000. Issuance of Utility System and Sales Tax Revenue Note, 2020 to address necessary projects within the Water, Wastewater and Drainage Systems along with Street Improvements. The note will mature June 1, 2035 (15-year term) with a fixed interest rate of 2.05% with Truist Bank (previously BB&T). Remaining projects: Arterial Streets Lift Station No. 4 (Young Contracting) Outstanding Principal of $3.776m. Maturity Date June 1, 2035

2017 NOTE 2017 NOTE FUND 63 FUND 63 July 11, 2017, the City issued the Utility System and Sales Tax Revenue Note, Series 2017 in the amount of $11,615,000. Projects funded by the 2017 Construction Note: Public Safety Emergency Operation Center (construction), Upgrade Dispatch System, Public Safety Vehicles/Equipment, and Animal Shelter. Streets SW 89th Street Widening (partial funding), Sara Road Widening, and Overlay Residential Streets. Quality of Life Town Center Expansion (partial funding), Splash Pad, (2) Soccer Field Lighting, and Market Place.

2017 NOTE 2017 NOTE FUND 63 CONT D CONT D FUND 63 Remaining projects: SW 89th Street Signalization Mustang Market Place Outstanding Principal of $6.440m. Maturity Date September 1, 2030

90% CAPITAL EXCESS 90% CAPITAL EXCESS FUND 64 FUND 64 Mustang citizens voted on August 23, 2016 to extend the 4th penny sales tax for a 13-year period. Fund 64 collects the excess of the 90% after the 2016 & 2017 note payments. Restricted for capital expenditures voted by citizens for public safety, infrastructure, streets and quality of life projects.

2016 NOTE 2016 NOTE FUND 65 FUND 65 October 12, 2016, the City issued the Utility System and Sales Tax Revenue Note, Series 2016 in the amount of $13,385,000. Projects Funded by the 2016 Construction Note: 1. Public Safety Emergency Operation Center (design) & Animal Shelter (partial funding). 2. Streets SW 89th Street Widening (partial funding). 3. Infrastructure Waste Water Treatment Plant (phases C&D). 4. Quality of Life All inclusive playground & Town Center Expansion (partial funding). Remaining projects: SW 89th Street Widening Outstanding Principal of $7.190m. Maturity Date September 1, 2030

MUSTANG IMPROVEMENT AUTHORITY The Mustang Improvement Authority (MIA) was created June 4, 1963 to finance, develop and operate the water, sewer and solid waste activities. These activities are financed primarily by user charges and similar to the private sector. This fund accounts for activities of the public trust in providing water, wastewater, sanitation, and recycling to the public.

MUSTANG IMPROVEMENT AUTHORITY Projected Beginning Balance $ 10,000,000 2016 Restricted Carryover $ 1,203,000 2017 Restricted Carryover $ 403,675 2020 Restricted Carryover $ 1,011,000 Projected Revenues $ 27,368,150 Projected Expenditures $(27,368,150) 2016 Restricted Carryover $ (1,203,000) 2017 Restricted Carryover $ ( 403,675) 2020 Restricted Carryover $ (1,011,000) Projected Ending Fund Balance $ 10,000,000

MUSTANG IMPROVEMENT AUTHORITY REVENUES Transfers In 1% Construction Projects 21% Sales Tax 27% Water 8% Carryover 18% Sewer 5% Misc 1% Sanitation 5% Fees & Other Services 14%

MUSTANG IMPROVEMENT AUTHORITY EXPENDITURES Sanitation 4% General Government 1% Sewer 3% Increase to Fund Balance 25% Water 9% Construction Projects 9% Transfers Out 49%

MUSTANG IMPROVEMENT MUSTANG IMPROVEMENT AUTHORITY AUTHORITY FUND 68 FUND 68 The Mustang Improvement Authority (MIA) was created June 4, 1963 to finance, develop and operate the water, sewer, and solid waste activities. It is used to account for business-like activities provided to the general public. Activities are financed primarily by user charges and similar to the private sector. This fund accounts for activities of the public trust in providing water, wastewater, sanitation, and recycle to the public.

RISK MANAGEMENT RISK MANAGEMENT FUND 69 FUND 69 Internal service fund used to account for self-insured worker s compensation claims and excess worker s compensation policy.

MUSTANG IMPROVEMENT MUSTANG IMPROVEMENT AUTHORITY RESERVE AUTHORITY RESERVE FUND 70 FUND 70 The Mustang Improvement Authority Reserve Fund is used for maintenance, infrastructure, and capital purchases for the enterprise funds. Municipal Code Book Section 118-1 states that the connection fees imposed by subsection (b) (1) of Section 118-1 shall be deposited into the trust fund upon receipt. On an annual basis, thirty-three and one-third (33 1/3%) of the connection fees will be budgeted and appropriated for expenses of operating and maintaining the water and sewer utilities system, and sixty-six and two-thirds (66 2/3%) of the connection fees will be budgeted and appropriated for the purposes of expanding and upgrading the water and sewer utilities as capital improvements to the utility system. Ordinance No. 1106 amended a new section 118-5 to read beginning October 1, 2014, the City of Mustang shall charge and collect for utility service furnished to all consumers and users a monthly capital improvement fee in the amount of $4.50 per month for each utility account. All amounts collected from such capital improvement charge is transferred to the MIA Reserve Fund to be applied to water and wastewater facility and line maintenance and construction.

AMERICAN RESCUE PLAN AMERICAN RESCUE PLAN (COUNTY) (COUNTY) - - FUND 80 FUND 80 Canadian County received $28.8m from the American Rescue Plan Act (ARPA) of 2021. The allocations to Non-Entitlement Units for twelve Local Government entities was based on population. Mustang s allocation totaled $2,802,612. Mustang has elected to support its water infrastructure. The costs must be obligated by December 31, 2024 and expended by December 31, 2026.

AMERICAN RESCUE PLAN AMERICAN RESCUE PLAN (STATE) (STATE) FUND 81 FUND 81 American Rescue Plan Act (March 11, 2021) authorized the Department of the Treasury to make payments to certain recipients from the Coronavirus Local Fiscal Recovery Funds. The allocations to Non-Entitlement Units for Local Government was based on population. Mustang s allocation totaled $4,028,919.05. Mustang has elected to support its vital wastewater infrastructure. The costs must be obligated by December 31, 2024 or funds expended by December 31, 2026.

SEWER SEWER INFRASTRUCTURE INFRASTRUCTURE IMPACT IMPACT FUND 82 FUND 82 To account for fees established per house top to developers. Funds used to pay the Series 2009 Clean Water SRF Note to OWRB dated June 8, 2009, future indebtedness and sewer projects.

SEWER CLAIMS SEWER CLAIMS FUND 83 FUND 83 The Municipality is not automatically liable for resulting damages whenever a sewer backs up. This fund accounts for damages caused by part of the Municipality.

REVOLVING REVOLVING DRINKING WATER DRINKING WATER FUND 84 FUND 84 Funding allocation of $1.75m from Representative Frank Lucas Office for SH152 Water Relocation Project passed on March 8, 2024.