Loading...
HomeMy WebLinkAboutPreliminary Operating Budget FY23-24City of Euless, Texas Fiscal Year 2023-2024 Budget Cover Page July 21, 2023 This preliminary budget was prepared prior to the delivery of Certified Appraisal Values. This budget will raise more revenue from property taxes than last year's budget by an amount of $837,143, which is a 3.4 percent increase from last year's budget. This document and this page will be updated once Certified Appraisal Values are received. The property tax revenue to be raised from new property added to the tax roll will be reported once data is received. City of Euless N9`,34' � 2023 THEVCITY EULESS awl Preliminary Annual Operating Budget Fiscal Year Ending September 30, 2024 201 North Ector Drive, Euless, Texas 76039 www.eulesstx.gov City of Euless FISCAL YEAR 2023-2024 Council Members LINDA MARTIN, MAYOR Tim Stinneford, Place One Jeremy Tompkins, Place Two Eddie Price, Mayor Pro Tem, Place Three Perry Bynum, Place Four Harry Zimmer, Place Five Tika Paudel, Place Six Loretta Getchell, City Manager Chris Barker, Deputy City Manager Wes Rhodes, Assistant City Manager TABLE OF CONTENTS PROPOSED BUDGET TITLE PAGE BUDGET MESSAGE Letter 1-8 Executive Summary, General Fund 9 Executive Summary, Water & Wastewater Fund 10 Executive Summary, Car Rental Fund 11 Fund Balance Summary, General & Internal Service Funds 12 Fund Balance Summary, Special Revenue Funds 13-14 Fund Balance Summary, Enterprise Funds 15 Fund Balance Summary, Debt Service Funds 16 Fund Balance Summary, Reserve Funds 17 ESTIMATED REVENUES & PROPOSED EXPENSE Where Does the Money Come From? 18 Where Does the Money Go? 19 General Fund Revenues 20 Tax Rate Scenarios 21 General Fund Expenditures 22 Water & Wastewater Revenues 23 Proposed Water Service Rates 24 Proposed Wastewater Service Rates 25 Water & Wastewater Expenditures 26 All Other Enterprise Operating Funds 27 Special Revenue Operating Funds 28-29 Internal Service Operating Funds 30 Debt Service Operating Funds 31 Personnel Counts 32 BOND INDEBTEDNESS Schedule of Outstanding and Proposed Indebtedness 33 CAPITAL EXPENSES & FUNDING Capital & Supplemental Requests by Fund 34-35 REQUIRED DISCLOSURE 36 2023 TAX RATE CALCULATION WORKSHEETS 37 SUPPLEMENTARY INFORMATION INTRODUCTION TAB 1 Organizational Chart 1-1 Budget Process 1-2 Budget Calendar Resolution 1-5 Excerpt from Charter 1-7 Fiscal Policies 1-9 CAPITAL, INFRASTRUCTURE PLANS & FLEET/EQUIPMENT REPLACEMENT TAB 2 Capital & Supplemental Requests by Fund 2-1 Capital & Supplemental Requests by Department 2-3 FY2023-24 Infrastructure Plan 2-5 Memo, Projected Equipment Replacement Fund 2-6 Proposed Fleet Depreciation Transfer 2-7 Proposed Misc. Asset Depreciation Transfer 2-8 Proposed Building Asset Depreciation Transfer 2-10 Proposed Fleet Replacements 2-11 Proposed Misc. Asset Replacements 2-12 Proposed Building Asset Replacements 2-13 Proposed Fleet Carryover 2-14 Proposed Misc. Asset Carryover 2-15 DEBT TAB 3 Schedule of Outstanding and Proposed Indebtedness 3-1 Annual Debt Service 3-2 Total General Obligation Debt 3-3 Tax -Supported General Obligation Debt 3-4 TIRZ/PID Supported General Obligation Debt 3-13 Taxable (Self -Supporting) G.O. Debt 3-19 Golf G.O. Refunding Debt 3-21 Water & Wastewater Revenue Debt 3-23 Sales Tax Revenue Debt 3-30 PERSONNEL & INSURANCE TAB 4 Personnel Counts 4-1 Personnel Counts by Fund 4-2 Proposed Public Safety Pay Plan 4-3 Proposed Exempt Pay Plan 4-5 Proposed Non -Exempt Pay Plan 4-7 Proposed Insurance Premiums 4-9 Insurance & Benefits 4-10 Risk & Workers Compensation 4-11 HISTORICAL & COMPARISON DATA TAB 5 Monthly Service Charges & Key Fiscal Points 5-1 Population Growth in Euless 5-2 General Fund Multi -Year Analysis 5-3 General Fund Revenue Assumptions 5-4 Property Tax Revenues 5-5 Tax Rate & Exemptions Comparisons 5-6 Tax Rate Impact 5-7 Water/ Wastewater Fund Revenue Assumptions 5-8 Utility Rate History 5-9 Sanitation and Recycling Comparison of Service & Rates 5-10 Drainage Utility Charge Comparison 5-11 Comparative Rates, Water & Wastewater - Other Cities 5-12 Impact of Water & Wastewater Rate Increase 5-13 Utility Bill Comparison 5-14 THE CITY 0 F EUL*ESS July 21, 2023 Honorable Mayor Linda Martin Honorable City Councilmembers: Tim Stinneford, Place One Jeremy Tompkins, Place Two Eddie Price, Mayor Pro Tem, Place Three Perry Bynum, Place Four Harry Zimmer, Place Five Tika Paudel, Place Six INTRODUCTION As required by the City of Euless' Home Rule Charter, the operating budget for the fiscal year beginning October 1, 2023 and ending September 30, 2024 is submitted for your review. This budget document includes all required data per the City's Charter and includes additional supplementary information. We hope our citizens find this document easy to navigate. In accordance with state law, the proposed budget must be filed with the municipal clerk at least 30 days prior to adoption of the tax rate which is scheduled for August 21, 2023. Therefore, property valuations and the proposed tax rate are based on estimates. The certified taxable property values are due from Tarrant Appraisal District on July 25, 2023. Upon receipt, we will update the taxable property values reflected in this document and will recalculate the property tax rate necessary to fund the proposed expenses. The proposed budget document will be updated with the municipal clerk and on the City's website to reflect these changes as soon as the calculations are completed. We would like to extend our thanks to all of the department directors and managers along with the finance staff for their outstanding performance in preparing this budget document. 201 N. Ector Drive, Euless, Texas 76039-3595 817/685-1400 • Metro 817/267-4403 • Fax 817/685-1416 www.eulesstx.gov 1 BUDGET HIGHLIGHTS In preparing this budget, we strived to provide funding to provide for continued excellent service to our citizens and retention of a talented and skilled workforce while addressing inflationary pressures, possible recession, and facility needs. The City's current property rate is 46¢ per $100 of assessed valuation with no change currently proposed. Upon receipt of the certified taxable property values, the proposed tax rate will be adjusted, if necessary, to achieve the revenue needed to fund the proposed budget. This may result in an increase or a decrease in the proposed tax rate. In accordance with state law, if the proposed tax rate exceeds the voter approval tax rate, an automatic election will be held on the next uniform election date which is November 7, 2023. Highlights of the proposed budget are detailed below: ♦ Property tax revenues are calculated assuming an increase of 5.5% in property values and a proposed tax rate of 46¢ per $100 of assessed valuation. (This information, along with the no -new revenue rate and the voter approval rate will be updated upon receipt of the certified taxable values from Tarrant Appraisal District). ♦ There are no cuts in programs or services for citizens. ♦ Personal additions include an additional School Resource Officer which will be funded by Hurst -Euless -Bedford Independent School District (HEB ISD), a Public Service Officer for increased safety and security in the jail, and a Conference Center Assistant Manager. ♦ In an effort to maintain a skilled workforce during a time of inflationary pressure and potential recession, a modest baseline salary increase is proposed for public safety personnel and a modest merit -based increase is proposed for all other City personnel. ♦ The water rate includes a $1 increase in the standard base rate, adjusted proportionately for larger meters, to cover operational cost increases in water delivery and an increase to the volume rate of 58¢ per thousand gallons to cover the pass -through increase from Trinity River Authority (TRA) in the cost to purchase water. ♦ The wastewater rate includes a $1 increase in the base rate to cover operational cost increases in wastewater collections and an increase to the volume rate of 46¢ per thousand gallons to cover the pass -through increase from TRA for the collection and treatment of the wastewater. ♦ A 50¢ per thousand gallons rate stabilization rebate is proposed to help offset some of the increases. This rebate is for residential water customers up to 15,000 gallons per month. ♦ Other user fees, permit fees and inspection fees are proposed to be adjusted, as deemed necessary, based on increased costs of service and change to state law regarding fee structure. 201 N. Ector Drive, Euless, Texas 76039-3595 817/685-1400 • Metro 817/267-4403 • Fax 817/685-1416 www.eulesstx.gov 2 ♦ The Water and Wastewater Operating Fund includes transfers to Capital Improvement Programs (CIP) to cash flow infrastructure improvements including water and wastewater line replacements. The annual commitment for line replacement is $1,100,000. An additional $2,000,000 has been allocated to the W/WW Fund Balance for future water and wastewater line replacements and to cover increased costs due to inflationary pressures. ♦ The General Fund includes a transfer to CIP to cash flow annual street improvements. This has been increased $25,000 in an effort to keep pace with inflation and is based on a third -party study of street conditions. The proposed amount for FY2023-24 is $1,075,000. An additional $4,000,000 has been allocated to General CIP Fund Balance for future capital projects and to cover increased costs due to inflationary pressures. ♦ Debt service payments have been included in the General Obligation Debt Service Fund for the issuance of Certificates of Obligation to fund renovation of the Police Facility. ♦ Funding has been provided from the Car Rental Fund for the design and remodel of the Animal Shelter. The animal shelter will be expanded to include the current Fire Station #2 which is being relocated. ♦ Depreciation funding for the majority of the City's vehicles, equipment, furnishing and fixtures, and certain expected building needs including HVAC, roof, and elevator replacements is included in the baseline budgets. ♦ Several of the recommended reserve levels for funds operated by the City are based on the number of days of operations. This helps keep up with inflationary trends. However, a few funds have reserve recommendations at fixed dollar amounts. This budget recommends an increase to the Risk Fund reserve due to inflationary pressures and to the Car Rental Fund reserve due to reliance on a portion of these funds for annual government operations. ♦ A detail of the recommended capital and supplemental programs is included in this Proposed Budget, as well as in Tab 2 along with a schedule of vehicle, equipment, furnishings and fixture replacements. GENERAL FUND General Fund revenues are proposed at $52,315,421 which represents an increase of 5% from the previous year's budget. The increase is primarily due to increased sales tax collections and an estimated increase in property tax revenue from new development and increased values. As mentioned, certified property valuations are expected on July 25th from the Tarrant Appraisal District. This proposed budget assumes an increase of 5.5% in taxable values. The tax rate proposed for FY2023-24 based on this estimate is unchanged at 46¢ per $100 of assessed valuation, which includes 37.11 ¢ for maintenance and operations and 8.89¢ for debt service. FY2022-23 sales tax collections are projected to end the fiscal year up almost 7.5% from budget due to better than expected collections. This is attributed to both continued 201 N. Ector Drive, Euless, Texas 76039-3595 817/685-1400 • Metro 817/267-4403 • Fax 817/685-1416 www.culesstx.gov 3 commercial development and inflationary increases. Projections for FY2023-24 sales taxes assumes a 3% increase over FY2022-23 original budget. Other revenue sources vary in their projections. While building permits have been strong, this revenue source will be vastly reduced when the City reaches buildout. Therefore, we continue to reduce our dependence on this revenue. Municipal court fines and fees collections have increased recently and therefore our projection for next year has increased slightly. Franchise fees are projected to increase slightly due to the inflationary impact on rates charged. Jail revenue is expected to increase based on the contractual agreement with other government entities. Interest income is expected to increase from current year budget estimates based on continued increases from the Federal Reserve. Tower lease rentals are expected to decrease based on existing agreements. General Fund operating expenses, excluding capital programs, are proposed at $52,245,458 which represents an increase of approximately 5%. This increase is primarily due to the proposed pay plan adjustment, the addition of a Public Safety Officer for jail safety and security, and a new School Resource Officer, as mentioned above, and increased supply, services, and material costs. Funding for two full-time equivalent positions has been moved from the General Fund to the EDC Fund. This includes one-half of the Controller position and for one and one- half Field Technician positions. Funding for one Police Officer has been transferred to the Crime Control and Prevention District (CCPD) and funding for part time jailers has been transferred from the CCPD to the General Fund for ease of reporting on shared jailed operations. The Juvenile Case Management revenues have increased; therefore, one -quarter of a Court Clerk funding has been transferred back to the Juvenile Case Management Fund from General Fund. Contractual rebates have been increased based on expected increases in sales tax collections. Recommended capital items are detailed in the proposed budget in Tab 2 and are funded from excess reserves. In accordance with the City's fiscal policy, all current expenses will be paid from current revenues. Per this policy, the budgeted General Fund reserve is equal to 60 days working capital. The fund balance summary verifies that the City has complied with this policy. Excess reserves have only been used to fund proposed capital and one-time needs. WATER AND WASTEWATER FUND The FY2023-24 budget includes proposed operating revenues of $33,135,803, which is an increase of 10% over FY2022-23 budgeted revenues. The water and wastewater revenue projections are based on proposed rates, detailed above, and estimated consumption for FY2023-24. A proposed rebate of 50¢ per thousand gallons of water 201 N. Ector Drive, Euless, Texas 76039-3595 817/685-1400 • Metro 817/267-4403 • Fax 817/685-1416 www.eulesstx.gov 4 used up to a maximum of 15,000 gallons per month is included for single-family residential customers. The City's Rate Stabilization Fund will provide the resources to cover the cost of the proposed rebate. Proposed water and wastewater baseline expenses are $33,119,762, which is an increase of 10% over current year. The increase is attributed to the increased costs from TRA for the purchase of water and treatment of wastewater and the proposed pay plan. Recommended capital items are detailed in the proposed budget and funded from excess reserves. The proposed budget meets the criteria set forth in the City's fiscal policies with reserves calculated at 75 days of working capital. Water and Wastewater Debt Reserve Requirements Water and wastewater revenue bond covenants require the City to maintain sufficient reserves equal to the average annual debt service requirements. This debt reserve is in addition to the working capital reserve required by the City's fiscal policies and is maintained in a separate fund. Reserve levels in excess of the requirements of the bond covenants are transferred to Water and Wastewater CIP. EQUIPMENT REPLACEMENT FUND The City maintains an equipment replacement program to accumulate funds for the replacement of existing vehicles, equipment, furnishings and fixtures, and expected facility needs including HVAC, roof, and elevator replacements. Funding is provided annually by user departments in order to accumulate funds to cover the expected replacement costs. Shortages in accumulated funds are supplemented with funding from the Car Rental Fund. RISK MANAGEMENT & WORKERS COMPENSATION FUND This fund is used to account for the revenue and expenses applicable to providing workers' compensation coverage for all City employees, as well as, general liability and property coverage. The reserve in this fund has been $600,000 for over 20 years. This proposed budget includes an increase to $1,000,000 as insurance claims and costs have steadily increased. SPECIAL REVENUE FUNDS Hotel/Motel Fund The Hotel/Motel Fund was established to account for a 7% hotel/motel occupancy tax allowed by the State of Texas. The tax is levied on the rental of a hotel/motel room within the City of Euless. Funds generated by this occupancy tax must be expended for 201 N. Ector Drive, Euless, Texas 76039-3595 817/685-1400 • Metro 817/267-4403 • Fax 817/685-1416 www.culcsstx.gov 5 items that qualify in accordance with state law including the promotion of tourism, programs which enhance the arts, historical restoration programs, and convention facilities. The hotel/motel tax receipts are projected to increase slightly in FY2023-24 from the current year budget. Historical preservation, conference center operations, and contractual rebates are included in the budget for FY2023-24. A one-time capital expense for Conference Center Improvements is included in the budget. Expenditures have increased to cover additional costs associated with contractual obligations for revenue sharing at DFW Airport, the operation of the Conference Centre, as well as to increase funding for the Arbor Daze festival. Half -Cent Sales Tax Fund — Euless Development Corporation (EDC) Euless citizens approved an additional 1/2¢ sales tax in 1993 that is restricted for parks, library, and economic development activities. Sales tax revenue projections assumes a 3% increase over FY2022-23 original budget estimates. As mentioned earlier, funding for two full-time equivalent positions has been moved from the General Fund to the EDC Fund. This includes one-half of the Controller position and one and one-half Field Technician positions. Recommended capital programs, as detailed in Tab 2, include RFID equipment for the Library, greenhouse roof replacement, a new parks master plan, and a multi -purpose hard court. Other capital projects include additional funding for miscellaneous parks improvements and Parks at Texas Star Lighting upgrades. These two items are detailed in the Capital Improvement Plan document. This budget maintains the required reserves equal to 60 days of working capital. Car Rental Tax Fund In November 1999, Euless citizens approved a 5% tax to be collected on all short-term motor vehicle rentals within the City limits. In the spring of 2000, the Dallas -Fort Worth International (DFW) Airport opened a consolidated car rental facility within Euless city limits. These funds are divided equally among Euless, Dallas, and Fort Worth per the requirements of a revenue sharing agreement established by the parties in FY1997-98. Revenue from car rentals continue to be strong. We expect revenues of $17,717,551 in FY2023-24. Expenditures from this fund include a transfer to the General Fund equal to one-third of the City's share of the revenue. This transfer helps offset the amount needed from property taxes to support general government operations. Additionally, funding is included for the airport revenue sharing obligations and equipment replacement funding as mentioned previously. Funding has also been provided for redevelopment and a renovation and expansion of the animal shelter. These two items are detailed in the Capital Improvement Plan document. 201 N. Ector Drive, Euless, Texas 76039-3595 817/685-1400 • Metro 817/267-4403 • Fax 817/685-1416 www.eulesstx.gov 6 The reserve level for this fund has been $2,000,000 for over 20 years. This proposed budget includes an increase to $4,000,000 due to increased reliance on this funding for general government operations. Juvenile Case Management Fund Revenues from the juvenile case fee have slightly increased. Therefore, we have transferred one -quarter of a Court Clerk back to this Fund from the General Fund as mentioned above. Funds from this source are restricted for the sole purpose of providing for juvenile case management. CAPITAL IMPROVEMENT FUNDS A separate Capital Improvements Program (CIP) has been updated and will be distributed under separate cover. This comprehensive document provides a summary of all funded projects detailing project scope, justification, funding sources, future maintenance and operating costs, and expenses to -date. Unfunded projects are categorized as Priority A, B, or C. Priority A items are recommended in the upcoming budget year and funding sources have been identified. Priority B items are expected to be presented for funding consideration within a two to five year window. Priority C items have been identified, but will be introduced for funding consideration at some time beyond the five year window. Projects identified as Priority B are considered in multi -year financial planning. This Capital Improvements Plan is fluid and will be reviewed and updated annually based on infrastructure needs within the City. The FY2023-24 recommended Priority A projects include annual street improvements; water line replacements at Huntington Drive Phase II and Sotogrande Boulevard Phase I; Animal Shelter Expansion and Renovation, Parks at Texas Star Lighting Upgrade, and Police and Courts Building Remodel. Additional capital funding is also included for West Pipeline Road reconstruction, Heritage Avenue reconstruction, Trailwood Addition wastewater line replacement, redevelopment, and miscellaneous capital improvements. LONG-TERM DEBT The City has existing long-term debt issued for the acquisition and construction of major capital facilities, infrastructure, and equipment. Additional debt in the amount not to exceed $22 million is planned for the remodel and expansion of the Police and Court facility. A brief explanation of the various debt instruments is provided below: General Obligation Bonds — issued pursuant to voter authorization for infrastructure and facility projects. 201 N. Ector Drive, Euless, Texas 76039-3595 817/685-1400 • Metro 817/267-4403 • Fax 817/685-1416 www.culcsstx.gov 7 General Obligation Refunding Bonds — issued to refund existing General Obligation Bonds and Certificates of Obligations in order to lower the overall debt service requirements of the City. These bonds do not require voter authorization. Certificates of Obligation — similar to General Obligation bonded debt in usage, but do not require voter authorization and cannot be used for refunding existing debt. Water and Wastewater Revenue Bonds — issued to provide funds for certain improvements to the water and wastewater system as well as to refund prior water and wastewater debt issues. These bonds are reported in the Water and Wastewater Fund and will be repaid from revenues of this enterprise operation. Sales Tax Revenue Bonds — are used to finance library, park, and economic development projects as well as to refund prior sales tax revenue debt issues. Sales tax revenue bonds will be repaid from the half -cent sales tax revenues collected by the Euless Development Corporation. The City strives to utilize the long-term plan to maintain a stable Interest and Sinking (I&S) tax rate so as not to have undue volatility in the overall tax rate due to capital projects and debt issuance. Additional information relating to the City's currently outstanding debt is included in Tab 3 of this book. CLOSING COMMENTS This proposed budget is focused on providing the resources to allow us to continue all current service levels while addressing inflationary impacts and possible recession. We believe that this is a fiscally sound budget that meets our City's primary objectives including: maintaining financial integrity; providing public safety and health services to the community; employing high -quality professional personnel; maintaining the City's infrastructure; promoting quality development; providing quality leisure opportunities; and instilling a "sense of community" in residents. We will continue to be diligent in the use of City funds and will remain flexible to adapt to the changing conditions. We look forward to seeing you at the budget work session. Respectfully submitted, 11(1I4a117 Loretta Getchell City Manager 201 N. Ector Drive, Euless, Texas 76039-3595 817/685-1400 • Metro 817/267-4403 • Fax 817/685-1416 www.eulesstx.gov 8 EXECUTIVE SUMMARY GENERAL FUND FY 2023 Budgeted Resources $ 58,655,282 Less Use of Prior Year Reserves $ (8,891,334) FY 2023 Net Operating Revenues $ 49,763,948 Proposed Changes in Revenue Property Taxes $ 999,713 Sales Tax $ 545,459 Franchise Fees $ 283,793 Licenses and Permits $ 21,129 Fines and Fees $ 321,825 Interest Income $ 74,002 Transfers $ 166,990 Other Changes $ 138,562 Subtotal: $ 2,551,473 FY 2024 Proposed Operating Revenues $ 52,315,421 FY 2023 Budgeted Expenses $ 58,584,348 Less Capital / One -Time Expenses $ (8,891,334) FY 2023 Net Operating Expenses $ 49,693,014 Proposed Changes in Expenses Salaries and Benefits $ 1,030,981 Rebates/Incentives $ 74,836 Professional/Technical $ 138,717 Utilities and Fees $ 99,091 Maintenance/Supplies $ 306,393 Equipment Replacement $ 541,848 Street Improvements $ 25,000 Other Changes $ 81,350 Subtotal: $ 2,298,216 FY 2024 Proposed Supplemental $ 254,228 FY 2024 Proposed Operating Expenses $ 52,245,458 Proposed Capital / One -Time Expenses Capital / One -Time Carryover $ 915,268 Recommended Capital / One -Time Expenses $ 7,370,156 FY 2024 Proposed Capital / One -Time Expenses $ 8,285,424 FY 2024 Proposed Budget $ 60,530,882 9 EXECUTIVE SUMMARY WATER & WASTEWATER FY 2023 Budgeted Resources Less Use of Prior Year Reserves $ 30,367,790 $ (365,022) FY 2023 Net Operating Revenues $ 30,002,768 Proposed Changes in Revenue Water Service $ 1,683,739 Wastewater Service $ 1,274,661 Reclaimed Water Service $ 12,561 Interest Income $ Sanitation/Recycling/Penalties $ 162,074 Subtotal: $ 3,133,035 FY 2024 Proposed Operating Revenues $ 33,135,803 FY 2023 Budgeted Expenses Less Capital / One -Time Expenses $ 30,363,165 $ (365,022) FY 2023 Net Operating Expenses $ 29,998,143 Proposed Changes in Expenses Salaries and Benefits $ 140,686 TRA Payments $ 2,164,494 Reclaimed Water Purchases $ 22,105 Transfers $ 156,974 G&A/Franchise $ 313,304 Utilities and Fees $ 118,420 Maintenance $ 21,000 Regulatory Fees $ 16,900 Other Changes $ 167,736 Subtotal: $ 3,121,619 FY 2024 Proposed Supplemental $ FY 2024 Proposed Operating Expenses $ 33,119,762 Proposed Capital / One -Time Expenses Capital / One -Time Carryover Recommended Capital / One -Time Expenses $ 168,944 $ 2,235,000 FY 2024 Proposed Capital / One -Time Expenses $ 2,403,944 FY 2024 Proposed Budget $ 35,523,706 10 EXECUTIVE SUMMARY CAR RENTAL FUND FY 2023 Budgeted Resources Less Use of Prior Year Reserves $ 19,144,155 $ (1,482,972) FY 2023 Net Operating Revenues $ 17,661,183 Proposed Changes in Revenue Car Rental Taxes $ 83,474 Transfers In $ Interest Income $ 325,644 Subtotal: $ 409,118 FY 2024 Proposed Operating Revenues $ 18,070,301 FY 2023 Budgeted Expenses Less Capital / One -Time Expenses $ 16,070,847 $ (1,482,972) FY 2023 Net Operating Expenses $ 14,587,875 Proposed Changes in Expenses DFW Rebate $ 55,648 Contingencies $ - Transfer to General Fund $ 9,275 Transfer to Equipment Replacement $ (54,928) Subtotal: $ 9,995 FY 2024 Proposed Operating Expenses $ 14,597,870 Proposed Capital / One -Time Expenses Capital / One -Time Carryover $ 372,972 Recommended Capital / One -Time Expenses $ 7,625,000 FY 2024 Proposed Capital / One -Time Expenses $ 7,997,972 FY 2024 Proposed Budget $ 22,595,842 11 Fund Balance Summary Estimated FY2022-23 and Budgeted FY2023-24 General and Internal Service Funds 'Beginning Balance, FY23 (per audit, FYE 2022) FY23 Estimated Revenues Total Available: FY23 Estimated Expenses Proposed Budget Adjustment Capital / One -Time Expenses Total Projected Expenses: 'Estimated Ending Balance FY23 FY24 Budgeted Revenues Total Available: FY24 Budgeted Expenses Capital Carryover Capital / One -Time Expenses Total Projected Expenses: Projected Ending Balance, FY24 Less: Designated Reserve Adjusted Ending Balance General Risk Mgmt. & Workers Comp $23,805,905 $5,917,105 $2,245,184 Insurance & Benefits 52,177,011 8,437,983 1,518,223 75,982,916 14,355,088 3,763,407 (49,693,014) (8,363,240) (1,366,731) 0 0 0 (7,976,066) (40,000) 0 (57,669,080) (8,403,240) (1,366,731) 18,313,836 5,951,848 2,396,676 52,315,421 8,745,766 1,508,486 70,629,257 14,697,614 3,905,162 (52,245,458) (8,482,087) (1,448,342) (915,268) 0 0 (7.370,156) (44,000) 0 (60,530,882) (8,526,087) (1,448,342) 10,098,375 6,171,527 2,456,820 (121.182) 0 0 9,977,193 6,171,527 2,456,820 Recommended Reserve Levels per Fiscal Policy: Available for Supplemental: Available for Capital / One -Time: Total Available 8.588.294 69,963 1,318,936 1,388,899 3.243.385 263,679 2,664,463 2,928,142 1.000.000 60,144 1,396,676 1,456,820 Equipment Replacement $17,071,070 9,806,035 26,877,105 (1,045,397) 0 (1,838,500) (2,883,897) 23,993,208 5,890,625 29,883,833 (3,355,442) (2,414,855) (1,834,236) (7,604,533) 22,279,300 0 22,279,300 22.279.300 2,535,183 (2,535,183) 0 12 Fund Balance Summary Estimated FY2022-23 and Budgeted FY2023-24 Special Revenue Funds 'Beginning Balance, FY23 (per audit, FYE 2022) FY23 Estimated Revenues Total Available: FY23 Estimated Expenses Proposed Budget Adjustment Capital / One -Time Expenses Total Projected Expenses: 'Estimated Ending Balance FY23 FY24 Budgeted Revenues Total Available: FY24 Budgeted Expenses Capital Carryover Capital / One -Time Expenses Total Projected Expenses: Projected Ending Balance, FY24 Less: Designated Reserve Adjusted Ending Balance Hotel/ Juvenile Motel Case $2,156,362 $189,156 1.592.903 52,667 3,749,265 241,823 (1,270,988) (28,684) 0 0 (464.424) (950) (1.735.412) (29,634) 2,013,853 212,189 1,632,890 52,528 3,646,743 264,717 (1,616,570) (48,421) 0 (12,421) (275.000) 0 (1,891,570) (60,842) 1,755,173 203,875 (66,903) 0 1,688,270 203,875 Recommended Reserve Levels per Fiscal Policy: Available for Supplemental: Available for Capital / One -Time: Total Available 265,738 16,320 1.406.212 1,422,532 7,960 4,107 191,808 195,915 EDC 1/2 Cent Sales Tax $7,305,323 7.552.716 14,858,039 (5,342,175) 0 (4.943.639) (10.285.814) 4,572,225 7.231.673 11,803,898 (5,663,854) (750,346) (1.163.4321 (7.577.632) 4,226,266 0 4,226,266 931,044 1,567,819 1.727.403 3,295,222 CCPD 1/4 Cent Sales Tax $2,536,425 3.789.433 6,325,858 (3,263,018) 0 (976.000) (4.239.018) 2,086,840 3.532.168 5,619,008 (3,396,829) 0 (1,414,450) (4,811,279) 807,729 0 807,729 558,383 135,339 114,007 249,346 Car Rental $8,698,251 20.035.398 28,733,649 (14,587,875) (1,272,909) (1.110.000) (16.970.784) 11,762,865 18.070.301 29,833,166 (14,597,870) (372,972) (7,625,000) (22,595,842) 7,237,324 0 7,237,324 4.000.000 3,472,431 (235.107) 3,237,324 13 Beginning Balance, FY23 (per audit, FYE 2022) Fund Balance Summary Estimated FY2022-23 and Budgeted FY2023-24 Special Revenue Funds (continued) Police Drug Police Glade Glade Grant Seized Parks P/D Parks Assets #1 TIRZ Cable Midtown Midtown PEG Fee HD TIRZ $526,334 $276 $223,060 $750,000 $3,458,961 $644,986 $61,234 $788,755 FY23 Estimated Revenues 132,313 352,747 8 544 0 2,291,809 99,446 343,515 933,048 Total Available: 658,647 353,023 231,604 750,000 5,750,770 744,432 404,749 1,721,803 FY23 Estimated Expenses (220,000) (52,918) (49,471) 0 (1,138,418) (85,400) (337,464) (764,199) Proposed Budget Adjustment 0 (299,829) 0 0 0 0 0 0 Capital / One -Time Expenses 0 0 0 0 0 (114,600) 0 0 Total Projected Expenses: (220,000) (352,747) (49,471) 0 (1,138,418) (200,000) (337,464) (764,199) Estimated Ending Balance FY23 438,647 276 182,133 750,000 4,612,352 544,432 67,285 957,604 I FY24 Budgeted Revenues 35,729 950.445 9 826 0 2,255,795 95.634 366.464 918.929 Total Available: 474,376 950,721 191,959 750,000 6,868,147 640,066 433,749 1,876,533 FY24 Budgeted Expenses (220,000) (950,445) (51,048) 0 (1,130,113) (85,400) (361,321) (742,400) Capital Carryover 0 0 0 0 0 0 0 0 Capital / One -Time Expenses 0 0 0 0 0 (34,600) 0 0 Total Projected Expenses: (220,000) (950,445) (51,048) 0 (1,130,113) (120,000) (361,321) (742,400) Projected Ending Balance, FY24 254,376 276 140,911 750,000 5,738,034 520,066 72,428 1,134,133 Less: Designated Reserve 0 0 0 (750,000) 0 0 0 0 Adjusted Ending Balance 254,376 276 140,911 0 5,738,034 520,066 72,428 1,134,133 Recommended Reserve Levels per Fiscal Policy: 0 0 0 0 Available for Supplemental: (184,271) 0 (41,222) 0 1,125,682 10,234 5,143 176,529 Available for Capital / One -Time: 438,647 276 182,133 0 4,612,352 509,832 67,285 957,604 Total Available 254,376 276 140,911 0 5,738,034 520,066 72,428 1,134,133 14 !Beginning Balance, FY23 (per audit, FYE 2022) Fund Balance Summary Estimated FY2022-23 and Budgeted FY2023-24 Enterprise Funds Drainage Parks at Water & Service Utility Recreation Arbor Texas Star Texas Wastewater Center System Classes Daze Golf Star $10,131,803 $485,766 $287,409 $349,171 $93 $1,750,500 $479,559 FY23 Estimated Revenues 30.002.768 1,311,214 951,979 479,366 120,000 4,926,715 1,100,574 Total Available: 40,134,571 1,796,980 1,239,388 828,537 120,093 6,677,215 1,580,133 FY23 Estimated Expenses (29,998,143) (1,311,214) (924,646) (425,197) (120,000) (4,879,599) (987,652) Capital / One -Time Expenses (196,078) (58,800) (50,000) 0 0 (120,000) (46,000) Total Projected Expenses: (30.194.221) (1.370.014) (974,646) (425,197) (120,000) (4.999.599) (1.033.652) !Estimated Ending Balance FY23 9,940,350 426,966 264,742 403,340 93 1,677,616 546,481 I FY24 Budgeted Revenues 33.135.803 1,413,635 950,207 590,600 150,000 5,663,037 1,166,144 Total Available: 43,076,153 1,840,601 1,214,949 993,940 150,093 7,340,653 1,712,625 FY24 Budgeted Expenses (33,119,762) (1,413,635) (940,632) (528,155) (150,000) (5,654,171) (1,073,115) Capital Carryover (168,944) 0 0 0 0 0 0 Capital / One -Time Expenses (2.235.000) (38,500) (70,000) 0 0 0 0 Total Projected Expenses: (35.523.706) (1.452.135) (1.010.632) (528,155) (150,000) (5.654.171) (1.073.115) Projected Ending Balance, FY24 7,552,447 388,466 204,317 465,785 93 1,686,482 639,510 Less: Designated Reserve 0 0 0 0 0 0 0 Adjusted Ending Balance 7,552,447 388,466 204,317 465,785 93 1,686,482 639,510 Recommended Reserve Levels per Fiscal Policy: 6.805.431 0 193.281 108.525 0 1.161.816 220.503 Available for Supplemental: 16,041 0 9,575 62,445 0 8,866 93,029 Available for Capital / One -Time: 730.975 388.466 1.461 294.815 93 515.800 325.978 Total Available 747,016 388,466 11,036 357,260 93 524,666 419,007 15 Fund Balance Summary Estimated FY2022-23 and Budgeted FY2023-24 Debt Service Funds 'Beginning Balance, FY23 (per audit, FYE 2022) EDC 1/2 Water & Texas G.O.Debt Stars Star Golf Service Center Debt Cent Sales Wastewater Course Tax Debt Debt Debt $2,107,809 $135,005 $11,731 $598,379 $56,964 FY23 Estimated Revenues 7,321,236 706,470 403,239 1,218.796 590,912 Total Available: 9,429,045 841,475 414,970 1,817,175 647,876 FY23 Estimated Expenses (7,087,875) (706,470) (398,976) (1,218,796) (590,894) Capital / One -Time Expenses (165.000) 0 0 0 0 Total Projected Expenses: (7.252.875) (706.470) (398.976) (1.218.796) (590.8941 'Estimated Ending Balance FY23 2,176,170 135,005 15,994 598,379 56,982 I FY24 Budgeted Revenues 7,139.631 775,976 399,351 1,213.836 589,459 Total Available: 9,315,801 910,981 415,345 1,812,215 646,441 FY24 Budgeted Expenses (7,742,890) (709,190) (395,626) (1,213,836) (589,187) Capital / One -Time Expenses 0 0 0 0 0 Total Projected Expenses: (7742.890) (709.190) (395.626) (1.213.836) (589.187) Projected Ending Balance, FY24 1,572,911 201,791 19,719 598,379 57,254 Less: Designated Reserve (654.6551 (41,250) 0 0 0 Adjusted Ending Balance 918,256 160,541 19,719 598,379 57,254 Recommended Reserve Levels per Fiscal Policy: 645,241 0 0 0 0 Available for Supplemental: (603,259) 66,786 3,725 0 272 Available for Capital / One -Time: 876,274 93,755 15,994 598,379 56,982 Total Available 273,015 160,541 19,719 598,379 57,254 16 'Beginning Balance, FY23 (per audit, FYE 2022) FY23 Estimated Revenues Total Available: FY23 Estimated Expenses Total Projected Expenses: 'Estimated Ending Balance FY23 FY24 Budgeted Revenues Fund Balance Summary Estimated FY2022-23 and Budgeted FY2023-24 Reserve Funds General EDC 1/2 Cent Emergency / Sales Tax Contingency Debt Reserves Reserve Water & Water & Midtown Wastewater Wastewater Bond Debt & Rate Reserve Emergency Stabilization Reserve Reserve Texas Star Sports Complex Reserve Texas Star Golf Course Reserve 1,500,000 $401,125 $999,725 $1,250,550 $3,968,349 $374,004 $828,934 0 0 0 0 1,500,000 401,125 999,725 1,250,550 21,000 3,989,349 30,704 97,546 404,708 926,480 0 0 0 (16,957) (979,205) 0 (100 000) 0 0 0 (16,957) (979,205) 0 (100 000) 1,500,000 401,125 999,725 1,233,593 3,010,144 404,708 826,480 0 0 0 0 21.000 17.000 60.000 Total Available: 1,500,000 401,125 999,725 1,233,593 3,031,144 421,708 886,480 FY24 Budgeted Expenses 0 0 0 0 (479,205) 0 (100,000) Capital / One -Time Expenses 0 0 0 (18,506) 0 0 (50,000) Total Projected Expenses: 0 0 0 (18,506) (479,205) 0 (150,000) Projected Ending Balance, FY24 1,500,000 401,125 999,725 1,215,087 2,551,939 421,708 736,480 Less: Designated Reserve (1.500,000) (401,075) (999,725) (1,215,0871 0 0 (523,074) Adjusted Ending Balance 0 50 0 0 2,551,939 421,708 213,406 Recommended Reserve Levels per Fiscal Policy: 0 Available for Supplemental: 0 0 0 0 (458,205) 17,000 (40,000) Available for Capital / One -Time: 0 50 0 0 3,010,144 404,708 253,406 Total Available 0 50 0 0 2,551,939 421,708 213,406 17 Where Does The Money Come From? FY2023-2024 Risk/WC 1% Insurance 6% Golf 4% W&WW 21% Debt 6% Car Rental 12% Other 10% CCPD 90/ 0 EDC 5% General 33% Budgeted FY2022-2023 Proposed FY2023-2024 Use of Use of Revenue Reserves Revenue Reserves General $ 49,763,948 $ 8,891,334 $ 52,315,421 $ 8,285,424 Hotel/Motel $ 1,514,579 $ 464,424 $ 1,632,890 $ 275,000 Juvenile Case $ 46,031 $ 13,371 $ 52,528 $ 12,421 EDC'h¢ Sales Tax $ 7,008,599 $ 5,693,985 $ 7,231,673 $ 1,913,778 CCPD 1/4¢ Sales Tax $ 3,471,916 $ 976,000 $ 3,532,168 $ 1,414,450 Police Seized Assets Fund $ 435 $ 49,036 $ 9,826 $ 41,222 Police Drug Fund $ 36,336 $ 183,664 $ 35,729 $ 184,271 Grant Fund $ 52,918 $ 635,925 $ 950,445 $ Car Rental $ 17,661,183 $ 1,482,972 $ 18,070,301 $ 7,997,972 Glade Parks TIRZ $ 2,134,976 $ $ 2,255,795 $ Cable PEG Fund $ 86,029 $ 114,600 $ 95,634 $ 34,600 Midtown PID $ 338,105 $ $ 366,464 $ Midtown TIRZ $ 933,048 $ $ 918,929 $ Water&Wastewater $ 30,002,768 $ 365,022 $ 33,135,803 $ 2,403,944 Service Center $ 1,311,214 $ 58,800 $ 1,413,635 $ 38,500 Drainage Utility $ 928,949 $ 50,000 $ 950,207 $ 70,000 Recreation Classes $ 479,366 $ $ 590,600 $ Arbor Daze $ 120,000 $ $ 150,000 $ Texas Star Golf Course (TSGC) $ 4,926,715 $ 120,000 $ 5,663,037 $ Parks at Texas Star (PATS) $ 1,100,574 $ 46,000 $ 1,166,144 $ Equip. Replacement $ 9,271,331 $ - $ 5,890,625 $ 4,249,091 Insurance $ 8,377,974 $ 40,000 $ 8,745,766 $ 44,000 Risk/WC $ 1,438,359 $ - $ 1,508,486 $ - General Obligation Debt $ 7,153,579 $ 165,000 $ 7,139,631 $ 771,019 Star Center Debt $ 707,621 $ $ 775,976 $ EDC Debt $ 399,131 $ $ 399,351 $ Water & Wastewater Debt $ 1,218,796 $ $ 1,213,836 $ TSGC Debt $ 590,912 $ $ 589,459 $ TOTAL $ 151,075,392 $ 19,350,133 $ 156,800,359 $ 27,735,692 Schedule includes operating and debt funds and excludes CIP and reserve funds. 18 Where Does The Money Go? FY2023-2024 Insurance 6% Golf 4% Fund Risk/WC 1% Debt 7% Other 9% DC Car Rental CCPD 4% 10% 2% Budgeted FY2022-2023 General !Icy. Proposed FY2023-2024 Operating Capital / Operating Capital / Expenses One -Time Expenses One -Time General $ 49,693,014 $ 8,891,334 $ 52,245,458 $ 8,285,424 Hotel/Motel $ 1,270,988 $ 464,424 $ 1,616,570 $ 275,000 Juvenile Case $ 28,684 $ 13,371 $ 48,421 $ 12,421 EDC 1/2¢ Sales Tax $ 5,342,175 $ 5,693,985 $ 5,663,854 $ 1,913,778 CCPD'/4¢ Sales Tax $ 3,263,018 $ 976,000 $ 3,396,829 $ 1,414,450 Police Seized Assets Fund $ 49,471 $ - $ 51,048 $ - Police Drug Fund $ 220,000 $ - $ 220,000 $ - Grant Fund $ 52,918 $ 635,925 $ 950,445 $ - Car Rental $ 14,587,875 $ 1,482,972 $ 14,597,870 $ 7,997,972 Glade Parks TIRZ $ 1,138,418 $ $ 1,130,113 $ Cable PEG Fund $ 85,400 $ 114,600 $ 85,400 $ 34,600 Midtown PID $ 337,464 $ - $ 361,321 $ - Midtown TIRZ $ 764,199 $ - $ 742,400 $ - Water & Wastewater $ 29,998,143 $ 365,022 $ 33,119,762 $ 2,403,944 Service Center $ 1,311,214 $ 58,800 $ 1,413,635 $ 38,500 Drainage Utility $ 924,646 $ 50,000 $ 940,632 $ 70,000 Recreation Classes $ 425,197 $ - $ 528,155 $ - Arbor Daze $ 120,000 $ - $ 150,000 $ Texas Star Golf Course (TSGC) $ 4,879,599 $ 120,000 $ 5,654,171 $ - Parks at Texas Star (PATS) $ 987,652 $ 46,000 $ 1,073,115 $ - Equip. Replacement $ 3,460,252 $ 1,838,500 $ 3,355,442 $ 4,249,091 Insurance $ 8,363,240 $ 40,000 $ 8,482,087 $ 44,000 Risk/WC $ 1,366,731 $ - $ 1,448,342 $ - General Obligation Debt $ 7,087,875 $ 165,000 $ 7,742,890 $ Star Center Debt $ 706,470 $ - $ 709,190 $ - EDC Debt $ 398,976 $ $ 395,626 $ Water & Wastewater Debt $ 1,218,796 $ - $ 1,213,836 $ - TSGC Debt $ 590,894 $ - $ 589,187 $ - TOTAL $ 138,673,309 $ 20,955,933 $ 147,925,799 $ 26,739,180 Schedule includes operating and debt funds and excludes CIP and reserve funds. 19 General Fund Revenues FY2023-2024 Property Taxes 40% Miscellaneous 2% General Fund Revenues Property Taxes Prior Year Property Taxes Penalties & Interest Sales Tax Additional Sales Tax Mixed Drink Tax Electric Franchise Gas Franchise Telephone Franchise Sanitation Service Recycling Franchise Fee Cable Franchise Fee W&WW Franchise Tax Other Permits Health Permits Fire Permits Contractor Regulatory License Minimum Housing Misc. Permits and Fees Building Permits Aquatics Auto Theft Task Force Grant School Resource Officers Municipal Court Library Fees Ambulance Fees Alarm Revenue Jail Revenue Interest Income Miscellaneous Tower Lease Betterment/Contributions Transfers TOTAL REVENUES Use of Reserves TOTAL RESOURCES Actual FY 22 $ 19,291,224 $ 312 $ 86,681 $ 13,908,346 $ 3,589,742 $ 201,349 $ 1,654,195 $ 563,968 $ 98,763 $ 324,755 $ 25,615 $ 245,178 $ 1,485,888 $ 30,774 $ 87,700 $ 66,828 $ 42,800 $ 96,303 $ 50,512 $ 774,403 $ 299,986 $ 95,013 $ 341,294 $ 1,876,948 $ 19,558 $ 1,066,967 $ 113,239 $ 675,025 $ 126,233 $ 724,875 $ 559,431 $ 17,813 $ 2,744,924 $ 51,286,642 $ $ 51,286,642 Transfers 7% Interest 0% Fines & Fees 7% Budget Estimated FY 23 FY 23 19,774,934 $ 19,886,616 $ 15,000 80,000 13,308,071 3,440,050 164,558 1,620,378 431,092 98,809 318,777 25,920 240,000 1,500,138 26,330 86,800 78,766 40,230 65,000 45,774 300,000 245,000 95,000 341,294 1,626,288 14,500 900,000 106,540 650,000 38,402 89,400 475,970 15,000 3,505,927 49,763,948 8,891,334 58,655,282 $ (15,000) $ 70,000 $ 14,304,753 $ 3,688,259 $ 200,500 $ 1,662,500 $ 595,680 $ 84,180 $ 328,992 $ 29,757 $ 190,925 $ 1,500,138 $ 14,000 $ 86,800 $ 66,000 $ 40,230 $ 67,560 $ 48,519 $ 735,920 $ 245,000 $ 95,000 $ 341,294 $ 1,565,593 $ 16,214 $ 935,300 $ 106,540 $ 682,500 $ 246,631 $ 358,313 $ 475,970 $ 16,400 $ 3,505,927 $ 52,177,011 $ 5,492,069 $ 57,669,080 Sales & Uses Taxes 34% Licenses/Permits 1% Franchise Fees 9% Proposed Budget FY 24 20,774,647 15,000 75,000 13,749,654 3,543,926 223,500 1,662,860 568,645 71,550 345,177 33,885 180,000 1,656,790 19,000 86,800 71,000 42,955 96,600 47,674 300,000 275,644 95,000 470,834 1,751,419 16,214 995,000 109,251 716,625 112,404 98,029 422,421 15,000 3,672,917 52,315,421 8,285,424 60, 600, 845 FY23 Budget to FY24 Proposed $ Diff 999,713 (5,000) 441,583 103,876 58,942 42,482 137,553 (27,259) 26,400 7,965 (60,000) 156,652 (7,330) (7,766) 2,725 31,600 1,900 30,644 129,540 125,131 1,714 95,000 2,711 66,625 74,002 8,629 (53,549) 166,990 2,551,473 (605,910) 1,945,563 % Diff. 5% 0% (6%) 3% 3% 36% 3% 32% (28%) 8% 31% (25%) 10% (28%) 0% (10%) 7% 49% 4% 0% 13% 0% 38% 8% 12% 11% 5% 5% (7%) 3% 20 TAX RATE SCENARIOS As Computed from July 2023 Certified Tax Roll Fiscal Year Total Tax Rate Debt Tax Rate M & 0 Tax Rate Est. Assessed Valuation (a) $6, Adj. Net Taxable Value Assessed (b) $5, Est. TIF Increment Value (c) Total Debt Debt Paid by other Sources Taxable Debt Service Debt Revenue Ceiling Revenues Prior Year Debt Revenue Increase (Decrease) in Debt Revenue M&O Revenue - General Fund Ceiling Revenues Total General Fund Tax Revenue Prior Year M&O Revenue Increase (Decrease) in M&O Revenue Total Increase in Tax Revenue 2022-23 0.460000 0.089153 0.370847 001,564,674 193,568,181 299,126, 638 $7,083,954 ($2,140,287) $4,943,667 $4,630,222 $289,259 $3,353,394 $1, 566, 086 $18, 527, 042 $1,203,220 $19,730,262 $19,162,531 Revenue at No -New -Revenue Rate Fiscal Year 2023-24 Revenue at Proposed Rate $6,331,650,731 $5,350,124,766 399,472,055 $7,742,890 ($3,146,959) $4,595,931 $4,630,222 $19,730,262 0.460000 0.088912 0.371088 $6,331,650,731 $5,350,124,766 399,472,055 $ 7,742,890 $ (3,146,959) $4,595,931 $4,756,911 $311,568 $4,630,222 $438,257 $19,474,272 $1,300,375 $20,774,647 $19,730,262 $567,731 * $1,044,385 $2,133,817 * $1,482,642 Revenue at Voter -Approval Rate— $6,331,650,731 $5,350,124,766 399,472,055 $7,742,890 ($3,146,959) $4,595,931 * $4,630,222 $19,730,262 (a) Assessed Valuation is the estimated Net Taxable Value from T.A.D. plus minimum value of ARB and estimate of incomplete property. This is an early estimated increase of 5.5% from July 25, 2022 Certified Values. Will be revised after Tarrant Appraisal District Certification on July 25, 2023. (b) Adj. Net Taxable Value Assessed = Assessed Value less estimated TIF increment $399,472,055 and authorized ceiling estimate $582,053,910. These values are based on June 2023 estimates. Will be revised after Tarrant Appraisal District Certification on July 25, 2023. (c) TIF = Tax Increment Finance zone increment taxable value increase contracted at 75% ($532,629,407 @ 75% = $399,472,055). These values are based on June 2023 estimates. Will be revised after Tarrant Appraisal District Certification on July 25, 2023. Note: Under these circumstances each penny of tax equals approximately $524,312 ($5,350,124,766*.01*.98/100 = $524,312). M&O Revenues are at a collection rate of approximately 98%. Debt Revenues are at 100% collections. M&O = Maintenance and Operations * Unknown value for FY24. Will be revised after Tarrant Appraisal District Certification on July 25, 2023. 21 General Fund Expenditures FY2023-2024 Public Works 6% Finance 0 Admin Srvcs ° 7% Non -Depart. 10% Development 1% PACS 5% Fire Capital / One -Time 14% City Admin 2% Police 30% 22% Proposed General Fund Actual Budget Estimated Budget Expenditures FY 22 FY 23 FY 23 FY 24 City Council $ 12,616 $ 26,805 $ 26,805 $ 27,000 $ City Administration $ 605,602 $ 701,861 $ 701,861 $ 720,400 $ City Secretary $ 405,941 $ 495,231 $ 495,231 $ 508,136 $ Communications/Marketing $ 4,719 $ 20,600 $ 20,600 $ 21,350 $ Total - City Administration $ 1,028,878 $ 1,244,497 $ 1,244,497 $ 1,276,886 $ Finance/Budget $ 180,455 $ 310,286 $ 310,286 $ 319,508 $ Municipal Court $ 764,528 $ 901,598 $ 901,598 $ 882,123 $ Accounting $ 336,524 $ 435,743 $ 435,743 $ 457,142 $ Purchasing $ 92,373 $ 116,260 $ 116,260 $ 118,017 $ Total - Finance $ 1,373,880 $ 1,763,887 $ 1,763,887 $ 1,776,790 $ Emergency Management $ 58,191 $ 69,832 $ 69,832 $ 121,207 $ Police Code Compliance $ 1,978,187 $ 2,129,547 $ 2,129,547 $ 2,380,937 $ Police Administration $ 1,216,130 $ 1,308,200 $ 1,308,200 $ 1,451,734 $ Police Patrol $ 6,603,888 $ 7,293,714 $ 7,293,714 $ 7,115,833 $ Police CID $ 1,866,493 $ 2,309,489 $ 2,309,489 $ 2,818,938 $ Police Service $ 2,471,710 $ 2,856,314 $ 2,856,314 $ 2,820,162 $ Police Detention $ 1,604,712 $ 1,399,693 $ 1,399,693 $ 1,581,311 $ Total -Police $ 15,799,311 $ 17,366,789 $ 17,366,789 $ 18,290,122 $ Fire Marshal/Education $ 612,174 $ 685,269 $ 685,269 $ 660,802 $ Fire Administration $ 519,480 $ 659,160 $ 659,160 $ 662,780 $ EMS/Suppression $ 10,193,338 $ 11,420,875 $ 11,420,875 $ 11,855,443 $ Total -Fire $ 11,324,992 $ 12,765,304 $ 12,765,304 $ 13,179,025 $ Information Services $ 873,338 $ 1,141,520 $ 1,141,520 $ 1,262,756 $ Human Resources $ 407,692 $ 550,071 $ 550,071 $ 592,386 $ Facility Maintenance $ 1,207,657 $ 1,229,690 $ 1,229,690 $ 1,412,901 $ Library $ 914,621 $ 1,002,541 $ 1,002,541 $ 985,899 $ Total - Administrative Services $ 3,403,308 $ 3,923,822 $ 3,923,822 $ 4,253,942 $ Planning & Development $ 323,388 $ 473,185 $ 473,185 $ 403,336 $ Inspection Services $ 389,488 $ 463,924 $ 463,924 $ 508,685 $ Total -Development $ 712,876 $ 937,109 $ 937,109 $ 912,021 $ Recreation $ 678,635 $ 757,255 $ 757,255 $ 781,544 $ Parks $ 1,542,070 $ 1,726,888 $ 1,726,888 $ 1,617,644 $ Aquatics $ 109,820 $ 156,025 $ 156,025 $ 180,762 $ Senior Center $ 241,965 $ 273,610 $ 273,610 $ 290,533 $ Recreation Admin. $ 81,209 $ 90,777 $ 90,777 $ 101,599 $ Total -Parks & Comm Srvcs $ 2,653,699 $ 3,004,555 $ 3,004,555 $ 2,972,082 $ Street Maintenance $ 2,641,150 $ 3,007,802 $ 3,007,802 $ 3,069,202 $ Animal Control $ 343,663 $ 418,390 $ 418,390 $ 461,356 $ City Engineer $ 73,107 $ 94,395 $ 94,395 $ 90,781 $ Total - Public Works $ 3,057,920 $ 3,520,587 $ 3,520,587 $ 3,621,339 $ Legal Services $ 166,379 $ 200,000 $ 200,000 $ 200,000 $ Non -Departmental $ 3,871,840 $ 4,951,864 $ 4,951,864 $ 5,748,651 $ Betterment $ - $ 14,600 $ 14,600 $ 14,600 $ Total - Non -Depart. $ 4,038,219 $ 5,166,464 $ 5,166,464 $ 5,963,251 $ Total Operating Expenses $ 43,393,083 $ 49,693,014 $ 49,693,014 $ 52,245,458 $ Capital / One -Time $ 3,573,884 $ 8,891,334 $ 7,976,066 $ 8,285,424 $ Total Expenses $ 46,966,967 $ 58,584,348 $ 57,669,080 $ 60,530,882 $ % Diff. 1% 3% 3% 4% 3% 3% (2%) 5% 2% 1% 74% 12% 11% (2%) 22% (1%) 13% 5% (4%) 1% 4% 3% 11% 8% 15% (2%) 8% (15%) 10% (3%) 3% (6%) 16% 6% 12% (1 %) 2% 10% (4%) 3% 0% 796,787 16% 0% 796,787 15% 2,552,444 (605,910) 1,946,534 3% FY23 Budget to FY24 Proposed $ Diff 195 18,539 12,905 750 32,389 9,222 (19,475) 21,399 1,757 12,903 51,375 251,390 143,534 (177,881) 509,449 (36,152) 181,618 923,333 (24,467) 3,620 434,568 413,721 121,236 42,315 183,211 (16,642) 330,120 (69,849) 44,761 (25,088) 24,289 (109,244) 24,737 16,923 10,822 (32,473) 61,400 42,966 (3,614) 100,752 5% (7%) 22 Water & Wastewater Revenues FY2023-2024 Wastewater 37% Other (1) Rarv-Ii - - Sanitation 2% 1% 1% Penalties Reclaimed Water 1% 3% Water 55% The above graph shows the sources of revenues in the Water & Wastewater Fund which are generated by services provided to the citizens of Euless for recycling, sanitation, water and wastewater. The "Other" amount represents 1 of total revenues and is an aggregate of several revenue sources as indicated in the table below. Proposed FY23 Budget to Water & Wastewater Actual Budget Estimated Budget FY24 Proposed Revenues FY 22 FY 23 FY 23 FY 24 $ Diff % Diff. Interest Income(1) $ 76,046 $ 14,226 $ 14,226 $ 14,226 $ - 0% Sanitation $ 270,357 $ 250,000 $ 250,000 $ 250,000 $ - 0% Water Service $ 16,446,768 $ 16,729,757 $ 16,729,757 $ 18,413,496 $ 1,683,739 10% Wastewater Service $ 10,709,042 $ 10,880,226 $ 10,880,226 $ 12,154,887 $ 1,274,661 12% Reclaimed Water Service $ 946,434 $ 883,125 $ 883,125 $ 895,686 $ 12,561 1% New Meters(1) $ 16,578 $ 15,000 $ 15,000 $ 15,000 $ - 0% Reconnect Fees(1) $ 228,195 $ 135,000 $ 135,000 $ 135,000 $ - 0% Inspection Fees(1) $ 81,200 $ 150,000 $ 150,000 $ 150,000 $ - 0% Miscellaneous(1) $ 164,602 $ 171,484 $ 171,484 $ 171,484 $ - 0% Penalties $ 316,602 $ 230,000 $ 230,000 $ 230,000 $ 0% Initiations/Transfer Fees(1) $ 29,190 $ 30,000 $ 30,000 $ 30,000 $ - 0% Recycling Fees $ 484,627 $ 513,950 $ 513,950 $ 676,024 $ 162,074 32% Use of Rate Stabilization $ 288,962 $ 479,205 $ 479,205 $ 479,205 $ - 0% Rate Stabilization Rebate $ (288,962) $ (479,205) $ (479,205) $ (479,205) $ - 0% TOTAL REVENUES $ 29,769,641 $ 30,002,768 $ 30,002,768 $ 33,135,803 $ 3,133,035 10% Use of Reserves $ - $ 365,022 $ 196,078 $ 2,403,944 $ 2,038,922 559% TOTAL RESOURCES $ 29,769,641 $ 30,367,790 $ 30,198,846 $ 35,539,747 $ 5,171,957 17% The above chart details revenues for the past, current, and upcoming fiscal years, as well as expected increases and decreases in service fee collections within the past year. The Water and Wastewater revenues are generated primarily from user charges for the variety of services provided to the citizens of Euless. Water Service revenues fluctuate seasonally and can be drastically affected by an extended period of drought or rainfall. (1) Water & Wastewater Revenue line items are aggregated in graph under "Other" 23 WATER SERVICE RATES Current Rates: Meter Charge: Meter Size (inches) 5/8-3/4 1 1 1/2 2 3 4 5 6 Monthly Charae $ 13.75 $ 16.07 $ 22.52 $ 37.30 $ 75.88 $ 133.77 $ 210.94 $ 300.98 Residential Volume Charge per 1,000 gallons (tgals) Tiered Rates 0-2 tgals 3-8 tgals 9-15 tgals 16-35 tgals Over 35 tgals 4.77 5.70 6.27 6.80 7.40 single Family Kesidential Kate Stabilization Ketund: 50¢ per 1,000 (tgals) up to 15 tgals/monthly Estimated total refund @ 50¢/tgal Estimated refund volume in tgals: Refund not applicable to irrigation meters Irrigation Volume Charge per 1,000 gallons (tgals) Tiered Rates 0-2 tgals 3-8 tgals 9-15 tgals 16-35 tgals Over 35 tgals 6.03 6.03 6.27 6.80 7.40 $ 479,205 958,410 Other Volume Charges per 1,000 gallons (tgals) Commercial & Multi -family Fire Hydrant & Gas Wells Supplemental Irrigation Reclaimed Volume Charge per 1,000 gallons (tgals) Non -Boosted $ 2.17 Boosted Tiered Rates 0-8 tgals $ 9-15 tgals $ 16-35 tgals $ Over 35 tgals $ Construction & Gas Wells $ Proposed Rates: Meter Charge: Meter Size (inches) 5/8-3/4 1 1 1/2 2 3 4 5 6 Monthly Charge $ 14.75 $ 17.24 $ 24.15 $ 40.01 $ 81.40 $ 143.50 $ 226.28 $ 322.87 Residential Volume Charge per 1,000 gallons (tgals) Tiered Rates 0-2 tgals 3-8 tgals 9-15 tgals 16-35 tgals Over 35 tgals 5.35 6.28 6.85 7.38 7.98 Single Family Kesidential Kate Stabilization Ketund: 50¢ per 1,000 (tgals) up to 15 tgals/monthly Estimated total refund @ 50¢/tgal Estimated refund volume in tgals: Refund not applicable to irrigation meters Irrigation Volume Charge per 1,000 gallons (tgals) Tiered Rates 0-2 tgals 3-8 tgals 9-15 tgals 16-35 tgals Over 35 tgals 6.61 6.61 6.85 7.38 7.98 $ 479,205 958,410 Other Volume Charges per 1,000 gallons (tgals) Commercial & Multi -family Fire Hydrant & Gas Wells Supplemental Irrigation Reclaimed Volume Charge per 1,000 gallons (tgals) Non -Boosted Boosted Tiered Rates 5.13 0-8 tgals 5.33 9-15 tgals 5.78 16-35 tgals 6.29 Over 35 tgals 9.60 Construction & Gas Wells $ 2.27 $ 5.62 $ 5.82 $ 6.27 $ 6.78 $ 10.09 24 WASTEWATER SERVICE RATES Current Rates: Residential Base Charge: Base Charge: Within Corporate Limits $ Outside Corporate Limits $ Proposed Rates: Residential Base Charge: Base Charge: 12.00 Within Corporate Limits $ 16.50 Outside Corporate Limits $ Volume Charge per 1,000 gallons (tgals) (based on 90% of metered water up to 12,000 gallons) Within Corporate Limits $ 4.53 Outside Corporate Limits $ 4.53 Commercial and Industrial Charges: Base Charge: Within Corporate Limits $ 12.00 Outside Corporate Limits $ 16.50 Volume Charge per 1,000 gallons (tgals) (based on 100% of metered water) Within Corporate Limits $ Outside Corporate Limits $ 13.00 17.50 Volume Charge per 1,000 gallons (tgals) (based on 90% of metered water up to 12,000 gallons) Within Corporate Limits $ 4.99 Outside Corporate Limits $ 4.99 Commercial and Industrial Charges: Base Charge: Within Corporate Limits $ 13.00 Outside Corporate Limits $ 17.50 Volume Charge per 1,000 gallons (tgals) (based on 100% of metered water) 4.53 Within Corporate Limits 4.53 Outside Corporate Limits 4.99 $ 4.99 25 City Engineer Water Production Water Distribution Wastewater Treatment Meter Services Total -Public Works Recycling GIS/Information Services Legal Services Non -Departmental Total -Non Departmental Total Operating Expenses (Capital / One -Time Total Expenses Water & Wastewater Expenditures FY2023-2024 Capital / One -Time 7% GIS 2% Wastewater Treatment 18% Water Distribution 5% Non -Depart. 31% Finance 2% Public Works 1% Water Production 34% The graph above indicates the expenditure amounts disbursed to the individual departments within the Water and Wastewater Fund. These expenditures reflect the cost incurred by the City for the services provided to Euless citizens. Proposed FY23 Budget to Water & Wastewater Actual Budget Estimated Budget FY24 Proposed Expenditures FY 22 FY 23 FY 23 FY 24 $ Diff % Diff. Water Office $ 495,273 $ 537,134 $ 537,134 $ 559,299 $ 22,165 4% Total -Finance $ 495,273 $ 537,134 $ 537,134 $ 559,299 $ 22,165 4% $ 329,930 $ 381,210 $ 381,210 $ 370,470 $ (10,740) (3%) $ 10,033,011 $ 10,663,831 $ 10,663,831 $ 12,087,055 $ 1,423,224 13% $ 1,644,155 $ 1,644,214 $ 1,644,214 $ 1,734,804 $ 90,590 6% $ 5,495,451 $ 5,537,415 $ 5,537,415 $ 6,453,911 $ 916,496 17% $ 64,225 $ 69,331 $ 69,331 $ 73,149 $ 3,818 6% $ 17,566,772 $ 18,296,001 $ 18,296,001 $ 20,719,389 $ 2,423,388 13% $ 25,719 $ 40,100 $ 40,100 $ 57,357 $ 17,257 43% $ 706,071 $ 803,070 $ 803,070 $ 789,835 $ (13,235) (2%) $ 85,990 $ 85,000 $ 85,000 $ 85,000 $ - 0% $ 9,570,221 $ 10,236,838 $ 10,236,838 $ 10,908,882 $ 672,044 7% $ 10,388,001 $ 11,165,008 $ 11,165,008 $ 11,841,074 $ 676,066 6% $ 28,450,046 $ 29,998,143 $ 29,998,143 $ 33,119,762 $ 3,121,619 10% $ 1,709,356 $ 365,022 $ 196,078 $ 2,403,944 $ 2,038,922 559% $ 30,159,402 $ 30,363,165 $ 30,194,221 $ 35,523,706 $ 5,160,541 17% The chart details the expenditures over the past, current, and upcoming fiscal years, as well as the expected increases and decreases in costs within the past year. These expenditures account for the cost associated with the acquisition, operation and maintenance of a municipal water and wastewater utility system. 26 All Other Enterprise Operating Funds This chart presents revenues, operating and capital expenses, and use of reserves for all other enterprise operating funds presented within the City of Euless' Annual Operating Budget. Proposed FY23 Budget to Enterprise Actual Budget Estimated Budget FY24 Proposed Funds FY 22 FY 23 FY 23 FY 24 $ Diff % Diff. Service Center Fund: Revenues $ 1,223,386 $ 1,311,214 $ 1,311,214 $ 1,413,635 $ 102,421 8% Operating Expenses $ 1,268,229 $ 1,311,214 $ 1,311,214 $ 1,413,635 $ 102,421 8% Use of Reserves $ 52,563 $ 58,800 $ 58,800 $ 38,500 $ (20,300) (35%) Capital / One -Time $ 7,720 $ 58,800 $ 58,800 $ 38,500 $ (20,300) (35%) Drainage Utility System: Revenues $ 923,008 $ 928,949 $ 951,979 $ 950,207 $ 21,258 Operating Expenses $ 840,206 $ 924,646 $ 924,646 $ 940,632 $ 15,986 Use of Reserves $ - $ 50,000 $ 22,667 $ 70,000 $ 20,000 Capital / One -Time $ 50,000 $ 50,000 $ 50,000 $ 70,000 $ 20,000 Recreation Classes: Revenues $ 598,909 $ 479,366 $ 479,366 $ 590,600 $ 111,234 Operating Expenses $ 435,762 $ 425,197 $ 425,197 $ 528,155 $ 102,958 Use of Reserves $ - $ - $ - $ - $ - Capital / One -Time $ - $ - $ - $ - $ Arbor Daze: Revenues $ 19,149 $ 120,000 $ 120,000 $ 150,000 $ 30,000 Operating Expenses $ 73,370 $ 120,000 $ 120,000 $ 150,000 $ 30,000 Use of Reserves $ 54,221 $ - $ - $ - $ - Capital / One -Time $ - $ - $ - $ - $ 2% 2% 40% 40% 23% 24% 0% 0% 25% 25% 0% 0% Texas Star Golf Course: Revenues $ 5,295,031 $ 4,926,715 $ 4,926,715 $ 5,663,037 $ 736,322 15% Operating Expenses $ 4,845,373 $ 4,879,599 $ 4,879,599 $ 5,654,171 $ 774,572 16% Use of Reserves $ - $ 120,000 $ 72,884 $ - $ (120,000) (100%) Capital / One -Time $ - $ 120,000 $ 120,000 $ - $ (120,000) (100%) Parks at Texas Star: Revenues $ 1,251,932 $ Operating Expenses $ 1,090,912 $ Use of Reserves $ 100,863 $ Capital / One -Time $ 261,883 $ 1,100,574 $ 1,100,574 $ 1,166,144 $ 65,570 6% 987,652 $ 987,652 $ 1,073,115 $ 85,463 9% 46,000 $ 46,000 $ - $ (46,000) (100%) 46,000 $ 46,000 $ - $ (46,000) (100%) Enterprise Funds are used to account for operations that are financed and operated in a manner similar to private business enterprises where the intent of the government's council is that the costs of providing goods and services to the general public on a continuing basis can be financed or recovered primarily through user charges. The Service Center Fund is used to account for the maintenance of the City's motor vehicles. The Drainage Fund is used to account for the acquisition, operation, and maintenance of the City's municipal drainage utility system. The Recreation Class Fund is used to account for the operation of recreational programs, activities and special events offered to Euless citizens and other groups on a fee basis. The Arbor Daze Fund is used to account for expenses related to the annual festival. The Texas Star Golf Course and Parks at Texas Star Funds are used to account for the operations and maintenance of these facilities which are supported primarily by user charges. 27 Special Revenue Operating Funds This chart presents revenues, operating and capital expenses, and use of reserves for all Special Revenue Funds presented within the City of Euless' Annual Operating Budget. Proposed FY23 Budget to Special Revenue Actual Budget Estimated Budget FY24 Proposed Funds FY 22 FY 23 FY 23 FY 24 $ Diff % Diff. Hotel/Motel: Revenues $ 1,748,585 $ 1,514,579 $ 1,592,903 $ 1,632,890 $ 118,311 8% Operating Expenses $ 798,642 $ 1,270,988 $ 1,270,988 $ 1,616,570 $ 345,582 27% Use of Reserves $ - $ 464,424 $ 142,509 $ 275,000 $ (189,424) (41%) Capital / One -Time $ - $ 464,424 $ 464,424 $ 275,000 $ (189,424) (41%) Juvenile Case: Revenues $ 51,351 $ 46,031 $ 52,667 $ 52,528 $ 6,497 14% Operating Expenses $ 58,022 $ 28,684 $ 28,684 $ 48,421 $ 19,737 69% Use of Reserves $ 7,200 $ 13,371 $ - $ 12,421 $ (950) (7%) Capital / One -Time $ 529 $ 13,371 $ 950 $ 12,421 $ (950) (7%) EDC'/z¢ Sales Tax: Revenues $ 7,328,173 $ 7,008,599 $ 7,552,716 $ 7,231,673 $ 223,074 3% Operating Expenses $ 4,335,921 $ 5,342,175 $ 5,342,175 $ 5,663,854 $ 321,679 6% Use of Reserves $ - $ 5,693,985 $ 2,733,098 $ 1,913,778 $ (3,780,207) (66%) Capital / One -Time $ 1,237,237 $ 5,693,985 $ 4,943,639 $ 1,913,778 $ (3,780,207) (66%) CCPD 1A¢ Sales Tax: Revenues $ 3,588,677 $ 3,471,916 $ 3,789,433 $ 3,532,168 $ 60,252 2% Operating Expenses $ 2,643,081 $ 3,263,018 $ 3,263,018 $ 3,396,829 $ 133,811 4% Use of Reserves $ - $ 976,000 $ 449,585 $ 1,414,450 $ 438,450 45% Capital / One -Time $ 398,319 $ 976,000 $ 976,000 $ 1,414,450 $ 438,450 45% Police Seized Assets Fund: Revenues $ 1,423 $ 435 $ 8,544 $ 9,826 $ 9,391 2159% Operating Expenses $ 11,600 $ 49,471 $ 49,471 $ 51,048 $ 1,577 3% Use of Reserves $ 10,177 $ 49,036 $ 40,927 $ 41,222 $ (7,814) (16%) Capital / One -Time $ - $ - $ - $ - $ - 0% Police Drug Fund: Revenues $ 50,649 $ 36,336 $ 132,313 $ 35,729 $ (607) (2%) Operating Expenses $ 147,247 $ 220,000 $ 220,000 $ 220,000 $ 0% Use of Reserves $ 96,598 $ 183,664 $ 87,687 $ 184,271 $ 607 0% Capital / One -Time $ - $ - $ - $ - $ - 0% Grant Fund: Revenues $ 143,250 $ 52,918 $ 352,747 $ 950,445 $ 897,527 1696% Operating Expenses $ 143,962 $ 52,918 $ 352,747 $ 950,445 $ 897,527 1696% Use of Reserves $ 712 $ 635,925 $ - $ - $ (635,925) (100%) Capital / One -Time $ - $ 635,925 $ - $ - $ (635,925) (100%) Car Rental Tax: Revenues $ 18,510,336 $ 17,661,183 $ 20,035,398 $ 18,070,301 $ 409,118 2% Operating Expenses $ 13,700,695 $ 14,587,875 $ 14,982,310 $ 14,597,870 $ 9,995 0% Use of Reserves $ - $ 1,482,972 $ - $ 7,997,972 $ 6,515,000 439% Capital / One -Time $ 1,000,000 $ 1,482,972 $ 1,988,474 $ 7,997,972 $ 6,515,000 439% Glade Parks TIRZ: Revenues $ 1,950,102 $ 2,134,976 $ 2,291,809 $ 2,255,795 $ 120,819 6% Operating Expenses $ 1,136,374 $ 1,138,418 $ 1,138,418 $ 1,130,113 $ (8,305) (1%) Use of Reserves $ - $ - $ - $ - $ - 0% Capital / One -Time $ - $ - $ - $ - $ 0% Cable PEG Fund: Revenues $ 83,804 $ 86,029 $ 99,446 $ 95,634 $ 9,605 11% Operating Expenses $ 28,269 $ 85,400 $ 85,400 $ 85,400 $ 0% Use of Reserves $ - $ 114,600 $ 100,554 $ 34,600 $ (80,000) (70%) Capital / One -Time $ - $ 114,600 $ 114,600 $ 34,600 $ (80,000) (70%) 28 Proposed FY23 Budget to Special Revenue Actual Budget Estimated Budget FY24 Proposed Funds FY 22 FY 23 FY 23 FY 24 $ Diff % Diff. Midtown PID: Revenues $ 718,148 $ 338,105 $ 343,515 $ 366,464 $ 28,359 8% Operating Expenses $ 779,079 $ 337,464 $ 337,464 $ 361,321 $ 23,857 7% Use of Reserves $ 60,931 $ - $ - $ - $ - 0% Capital / One -Time $ - $ - $ - $ - $ - 0% Midtown TIRZ: Revenues $ 694,952 $ 933,048 $ 933,048 $ 918,929 $ (14,119) (2%) Operating Expenses $ 303,691 $ 764,199 $ 764,199 $ 742,400 $ (21,799) (3%) Use of Reserves $ - $ - $ - $ - $ - 0% Capital / One -Time $ - $ - $ - $ - $ 0% Special Revenue funds are used for specific revenues that are legally restricted to expenditures for particular purposes. The Hotel/Motel Fund is used to account for occupancy tax revenues from area hotels. Expenses are dedicated to the promotion of tourism and the convention and hotel industry. The Juvenile Case Fund is used to account for court fees collected. Expenses are dedicated primarily to personnel and operating costs required to process juvenile cases. The Euless Development Corporation (EDC) 1/2¢ Sales Tax Fund is used to account for the '/z¢ sales tax revenues. Expenses are dedicated to parks, library, recreational, and economic development activities within the City of Euless. The Crime Control and Prevention District (CCPD) 1/4¢ Sales Tax Fund is used to account for '/4¢ sales tax revenues. Expenses are dedicated to additional personnel, crime prevention programs, and equipment for the Euless Police Department. The Police Seized Asset Fund is used to account for proceeds from sale of seized assets which are dedicated to police expenditures. The Police Drug Fund is used to account for proceeds from sale of assets seized in connection with drug arrests. Expenses are dedicated solely for police department expenditures. Only interest earnings and overtime cost are budgeted due to the volatility and unpredictable nature in asset confiscation. Grant Fund is used to account for grant funds and other restricted revenues received by the City. Expenses must be spent in accordance with the grant provisions. The Car Rental Tax Fund is used to account for the 5% tax charged on any short-term motor vehicle rental. Expenses may be dedicated to operations, debt avoidance/reduction and capital expenditures. These revenues are shared equally between the cities of Dallas, Fort Worth, and Euless. The Glade Parks Tax Increment Reinvestment Zone (TIRZ) Fund is used to account for new revenues generated from increased values of properties located within the Zone, based on the percentage pledged by each participating taxing entity. Expenses are incurred for the repayment of the related infrastructure cost. The Cable Public Educational and Governmental (PEG) Fund is used to account for a 1% fee collected from cable channel providers for expansion of the City's public, educational, and governmental channel. The Midtown Public Improvement District (PID) Fund is used to account for assessments levied upon properties within the district boundaries. Expenses are incurred for the repayment of debt issued to fund public improvements within the district. The Midtown Tax Increment Reinvestment Zone (TIRZ) Fund is used to account for new revenues generated from increased values of properties located within the Zone, based on the percentage pledged by each participating taxing entity. Expenses are incurred for the repayment of the related infrastructure cost. 29 Internal Service Operating Funds This chart presents revenues, operating and capital expenses, and use of reserves for all Internal Service Funds presented within the City of Euless' Annual Operating Budget. Internal Service Funds Equipment Replacement: Revenues Operating Expenses Use of Reserves Capital / One -Time Insurance: Revenues Operating Expenses Use of Reserves Capital / One -Time Risk/WC Management: Revenues Operating Expenses Use of Reserves Capital / One -Time Actual FY 22 $ 5,632,356 $ $ 1,939,055 $ $ - $ $ - $ $ 7,499,992 $ $ 7,344,662 $ $ - $ $ 10,400 $ $ 1,127,185 $ $ 1,004,601 $ $ - $ $ - $ Budget Estimated FY 23 FY 23 9,271,331 $ 9,806,035 3,460,252 $ 1,045,397 - $ 1,838,500 $ 1,838,500 Proposed Budget FY 24 $ 5,890,625 $ 3,355,442 $ 4,249,091 $ 4,249,091 FY23 Budget to FY24 Proposed $ Diff % Diff. $ (3,380,706) $ (104,810) $ 4,249,091 $ 2,410,591 131% 8,377,974 $ 8,437,983 $ 8,745,766 $ 8,363,240 $ 8,363,240 $ 8,482,087 $ 40,000 $ 40,000 $ 44,000 $ 40,000 $ 40,000 $ 44,000 $ 1,438,359 $ 1,518,223 $ 1,508,486 $ 1,366,731 $ 1,366,731 $ 1,448,342 $ - $ - $ - $ - $ - $ - $ 367,792 118,847 4,000 4,000 70,127 81,611 (36%) (3%) 5% 6% 0% 0% Internal Service funds are used to account for the financing of goods or services provided by one department to other departments of the government and to other government units, on a cost reimbursement basis. The Equipment Replacement Fund is used to account for the accumulation of funds from user departments. Expenses are dedicated to replacement of existing equipment and motor vehicles. The Insurance Fund is used to account for both city and employee premiums. Expenses are dedicated to employees' health, dental, and prescription claims. The Risk Management/Workers' Compensation Fund is used to account for the program(s) used for worker's compensation, general liability, and property claims. 30 Debt Service Operating Funds This chart presents revenues and operating expenses, and use of reserves for all Debt Service Funds presented within the City of Euless' Annual Operating Budget. Debt Service Funds General Obligation Debt Revenues Operating Expenses Use of Reserves Capital / One -Time Star Center Debt Revenues Operating Expenses Use of Reserves EDC Debt Service Revenues Operating Expenses Use of Reserves Water & Wastewater Debt Revenues Operating Expenses Use of Reserves Texas Star Golf Course Debt Revenues Operating Expenses Use of Reserves Actual FY 22 $ 5,976,091 $ 6,887,685 $ 998,334 $ - Budget FY 23 $ 7,153,579 $ 7,087,875 $ 165,000 $ 165,000 Estimated FY 23 $ 7,321,236 $ 7,087,875 $ 91,932 $ 165,000 Proposed Budget FY 24 $ 7,139,631 $ 7,742,890 $ 771,019 $ - FY23 Budget to FY24 Proposed $ Diff % Diff. $ (13,948) $ 655,015 $ 606,019 $ (165,000) $ 711,177 $ 707,621 $ 706,470 $ 775,976 $ 68,355 $ 710,970 $ 706,470 $ 706,470 $ 709,190 $ $ - $ - $ - $ - $ $ 403,139 $ 399,131 $ 403,239 $ 399,351 $ $ 402,125 $ 398,976 $ 398,976 $ 395,626 $ (3,350) $ - $ - $ - $ - $ $ 1,212,183 $ 1,218,796 $ 1,218,796 $ 1,213,836 $ $ 1,212,443 $ 1,218,796 $ 1,218,796 $ 1,213,836 $ $ 260 $ - $ - $ - $ $ 591,815 $ 590,912 $ 590,912 $ 589,459 $ $ 591,715 $ 590,894 $ 590,894 $ 589,187 $ $ - $ - $ - $ - $ (0%) 9% 367% (100%) 10% 2,720 0% 0% 220 0% (1%) 0% (4,960) (0%) (4,960) (0%) 0% (1,453) (0%) (1,707) (0%) 0% Debt Service funds are used to account for the repayment of General Obligation Bonds, Certificates of Obligation, Taxable Bonds, Tax Notes, and Revenue Supported Bonds. These Bonds represent direct and special obligations of the City. The General Obligation Debt Service Fund is used to account for the collection of a continuing ad valorem tax levied by the City. Expenses are dedicated to the payment of principal and interest on General Obligation Bonds, General Obligation Refunding Bonds, Tax Notes, and Certificates of Obligation. The Star Center Debt Fund is used to account for monthly lease payments on the Stars Center. Expenses are dedicated to annual debt service requirements. The EDC Debt Service Fund is used to account for pledged revenues, which includes the proceeds of a 1/z¢ sales and use tax levied within the City. Expenses are dedicated to the sole benefit of the Euless Development Corporation obligations. The Water & Wastewater Debt Service Fund is used to account for a pledge of the surplus net revenues of the City's Waterworks and Sewer System. Expenses are dedicated to payment of annual debt service requirements. The Golf Course Debt Service Fund is used to account for a pledge of the surplus net revenues derived from the operation and ownership of the Texas Star Golf Course. Expenses are dedicated to payment of annual debt service requirements. 31 CITY ADMINISTRATION CITY SECRETARY Total City Administration FINANCE/BUDGET MUNICIPAL COURTS ACCOUNTING PURCHASING Total Finance POLICE CODE COMP/COMM SVRS POLICE ADMINISTRATION POLICE PATROL POLICE CID POLICE SERVICE POLICE DETENTION Total Police Department FIRE MARSHAL/EDUCATION FIRE ADMINISTRATION EMS/SUPPRESSION Total Fire Department INFORMATION SERVICES HUMAN RESOURCES FACILITY MAINTENANCE Total Administrative Services LIBRARY Total Library PLANNING & DEVELOPMENT INSPECTIONS SERVICES Total Planning & Development RECREATION PARKS SENIOR CENTER RECREATION ADMINISTRATION Total Community Services STREET MAINTENANCE ANIMAL CONTROL CITY ENGINEER Total Public Works TOTAL GENERAL FUND EDC - PARKS EDC - LIBRARY EDC - ECO. DEV. TOTAL EDC FUND WATER OFFICE Total Finance W&S ENGINEERING WATER PRODUCTION WATER DISTRIBUTION SEWAGE & TREATMENT METER SERVICES Total Public Works INFORMATION SERVICES W&S NON-DEPT. Total Non -departmental TOTAL W&S FUND GOLF NON DEPARTMENTAL GOLF COURSE MAINT. GOLF PRO SHOP GOLF FOOD AND BEVERAGE GOLF CONFERENCE CENTRE TOTAL GOLF COURSE FUND JUVENILE CASE FUND CRIME CONTROL FUND SERVICE CENTER FUND DRAINAGE UTILITY FUND PARKS @ TEXAS STAR HEALTH INSURANCE FUND WC/RISK MANAGEMENT FUND TOTAL OTHER FUNDS TOTAL ALL FUNDS Full -Time Personnel Counts FY 21/22 FY 22/23 FY 22/23 ACTUAL BUDGETED ESTIMATED 3.50 3.50 3.50 3.50 3.50 3.50 7.00 7.00 7.00 1.50 G 2.50 2.50 8.25 B,F 7.75 7.75 3.50 3.50 3.50 1.00 1.00 1.00 14.25 14.75 14.75 16.00 16.00 16.00 7.00 7.00 7.00 49.00 C 48.00 48.00 14.00 D 16.00 16.00 21.00 D 22.50 22.50 17.00 D 13.50 13.50 124.00 123.00 123.00 4.00 4.00 4.00 4.00 4.00 4.00 70.00 70.00 70.00 78.00 78.00 78.00 1.00 1.00 1.00 3.50 3.50 3.50 4.00 4.00 4.00 8.50 8.50 8.50 9.00 9.00 9.00 9.00 9.00 9.00 2.50 B 3.50 3.50 4.00 4.00 4.00 6.50 7.50 7.50 5.50 5.50 5.50 11.00 11.00 11.00 2.00 2.00 2.00 1.00 1.00 1.00 19.50 19.50 19.50 11.50 A 13.50 13.50 3.00 E 4.00 4.00 1.00 1.00 1.00 15.50 18.50 18.50 282.25 285.75 285.75 13.25 A 14.25 14.25 10.00 10.00 10.00 1.00 1.00 1.00 24.25 25.25 25.25 5.00 5.00 5.00 5.00 5.00 5.00 3.00 3.00 3.00 5.75 5.75 5.75 8.25 8.25 8.25 8.00 8.00 8.00 1.00 1.00 1.00 26.00 26.00 26.00 4.00 4.00 4.00 10.00 10.00 10.00 14.00 14.00 14.00 45.00 45.00 45.00 0.75 0.75 0.75 4.00 4.00 4.00 2.50 2.50 2.50 3.00 3.00 3.00 1.50 1.50 1.50 11.75 11.75 11.75 0.75 F 0.25 0.25 18.00 C 19.00 19.00 5.00 5.00 5.00 8.00 8.00 8.00 1.50 1.50 1.50 1.00 1.00 1.00 0.50 0.50 0.50 34.75 35.25 35.25 398.00 403.00 403.00 A) Added FT Field Tech(s) B) Transferred Court Clerk to Planning & Development C) Transferred 1 Police Officer from General Fund to CCPD D Transferred 3.5 positions from Detention to CID and Services E) Converted Part Time to Full Time F) Transferred 0.25 Juvenile Case Manager and 0.25 Court Clerk to General Fund G) Funded Internal Audit Position as Accountant II H) Transferred .25 Court Clerk from General Fund to Juvenile Case Fund FY 23/24 BUDGETED 3.50 3.50 7.00 2.50 H 7.50 3.50 1.00 14.50 I,N 18.00 7.00 I,J 44.00 19.00 21.50 0 14.50 124.00 4.00 4.00 70.00 78.00 1.00 3.50 4.00 8.50 9.00 9.00 K 2.50 K 5.00 7.50 L,M 4.75 L 9.50 2.00 1.00 17.25 13.50 4.00 1.00 18.50 284.25 L 16.25 10.00 1.00 27.25 5.00 5.00 3.00 5.75 8.25 8.00 1.00 26.00 4.00 10.00 14.00 45.00 0.75 4.00 2.50 3.00 M,P 2.75 13.00 H 0.50 J 20.00 5.00 8.00 1.50 1.00 0.50 36.50 406.00 I) Moved Officers within Police division in General Fund J) Transferred 1 Police Officer from General Fund to CCPD K) Moved Secretary within Planning division in General Fund L) Moved .5 Controller and 1.5 Field Tech from General Fund Parks to EDC Parks M) Moved .25 TX Star Gen Mgr from General Fund to Golf Fund N) Added Additional SRO to General Fund 0) Added FT Public Service Officer P) Added FT Conference Center Assistant Manager 32 Outstanding Indebtedness Principal Amount of Description Dated Amount Original Paying Agent Remaining Maturity Outstanding Issuance Interest Rate General Obligation Refunding Bonds, Series 2012 Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of Obligation, Series 20111 Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of 10/15/2014 $ 3,930,000 $ 5,715,000 U.S. Bank Trust 3% to 5% 8/15/2034 Obligation, Series 20141 Company, NA Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of 10/27/2015 $ 2,245,000 $ 3,030,000 U.S. Bank Trust 3% to 5% 2/15/2035 Obligation, Series 20151 Company, NA Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of Obligation, Series 20161 Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of Obligation, Series 20185 Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of Obligation, Series 2019 Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of Obligation, Series 2020 Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of Obligation, Series 2021 Tax Notes Series 2021 Tax Notes Series 2022 Taxable General Obligation Refunding Bonds, Series 20102 General Obligation Refunding Bonds, Series 2012A3 Waterworks & Sewer System Revenue Refunding Bonds, Series 20124 Waterworks & Sewer System Revenue Bonds, Series 20134 Waterworks & Sewer System Revenue Bonds, Series 2015A4 Waterworks & Sewer System Revenue Bonds, Series 2015B4 Waterworks & Sewer System Revenue Bonds, Series 20184 Waterworks & Sewer System Revenue Bonds, Series 2019 Euless Development Corporation, Sales Tax Revenue Bonds, Series 2018 Euless Development Corporation, Sales Tax Revenue Bonds, Series 2019 AXON Enterprise, Inc. Lease 12/1/2011 $ 535,000 $ 5,955,000 U.S. Bank Trust 3% to 4% 2/15/2024 Company, NA 1/15/2011 $ 1,425,000 $ 3,035,000 U.S. Bank Trust 4%to4.25% 8/15/2030 Company, NA 1/12/2016 $ 13,365,000 $ 16,450,000 U.S. Bank Trust 2.25% to 4% 2/15/2041 Company, NA 3/1/2018 $ 7,540,000 $ 9,180,000 U.S. Bank Trust 3% to 4% 2/15/2038 Company, NA 1/15/2019 $ 10,280,000 $ 11,785,000 U.S. Bank Trust 3% to 5% 2/15/2039 Company, NA 1/14/2020 $ 6,290,000 $ 7,115,000 U.S. Bank Trust 2% to 3.5% 2/15/2040 Company, NA 4/8/2021 $ 4,980,000 $ 5,360,000 U.S. Bank Trust 1.625%to4% 2/15/2041 Company, NA 4/8/2021 $ 570,000 $ 1,625,000 U.S. Bank Trust 4.00% 2/15/2024 Company, NA 9/20/2022 $ 6,595,000 $ 7,660,000 Amegy Bank 2.89% 2/15/2029 8/15/2010 $ 1,335,000 $ 8,110,000 U.S. Bank Trust 4%to4.4% 8/1/2025 Company, NA 11/1/2012 $ 2,245,000 $ 7,185,000 U.S. Bank Trust 2%to2.625% 2/15/2027 Company, NA 3/29/2012 $ 135,000 $ 3,340,000 Bank of Texas 2.03% 7/15/2024 6/25/2013 $ 935,000 $ 1,585,000 U.S. Bank Trust 3 625% to 5% 7/15/2033 Company, NA 8/5/2015 $ 2,925,000 $ 4,685,000 U.S. Bank Trust 0.8%to 1.98% 7/15/2035 Company, NA 8/5/2015 $ 1,540,000 $ 2,380,000 U.S. Bank Trust 0.5%to 1.68% 7/15/2035 Company, NA 4/12/2018 $ 2,140,000 $ 2,785,000 U.S. Bank Trust 0.24%to 1.49% 7/15/2038 Company, NA 4/25/2019 $ 8,200,000 $ 9,275,000 U.S. Bank Trust 0.29%to 1.66% 7/15/2049 Company, NA 10/15/2018 $ 1,315,000 $ 1,635,000 U.S. Bank Trust 3% to 4% 9/15/2038 Company, NA 12/12/2019 $ 3,485,000 $ 4,120,000 U.S. Bank Trust 2.5% to 4% 9/15/2039 Company, NA 6/13/2023 $ 1,139,386 $ 1,139,386 AXON 3/15/2028 Enterprise, Inc. Proposed Indebtedness 111 Proposed Issuance Amount Proposed Sale Type Anticipated Payment Source Proposed Issuance Date Proposed Term Description Certificates of Obligation - Police & Courts Building Design & Remodel Not to exceed $22 million Competitive Sale Property Tax August 2023 20 Year 1 Bonds paid by Tax Increment Financing District and Public Improvement District. 2 Bonds paid by rental income from Stars Center. 3 Remaining Bonds paid by Texas Star Golf Course. ° Bonds paid by Water & Wastewater user charges. 5 Bonds partially paid by Tax Increment Financing District and Public Improvement District. 33 Capital & Supplemental Requests for FY2023-24 by Fund Department *Fund Fleet & Facilities General Fleet & Facilities General Fleet & Facilities General Public Works General Fleet & Facilities General Fleet & Facilities General Information Services General Public Works General Fire General Non -Departmental General Fleet & Facilities General Non -Departmental General Public Works General Non -Departmental General Information Services General Non -Departmental General Non -Departmental General Public Works General CMO General Fleet & Facilities General Public Works General Information Services General Police General Police General Fire General Police General Fleet & Facilities General Police General Police General Public Works General Public Works General Golf Hotel PACS Hotel Golf Hotel Library EDC PACS EDC Program Description Vinyl Floor - Tile Replacement - Senior Center Exercise Carpet Replacement - Senior Center Reseal Exterior Windows in Pre -Council Chambers Paperless Plan Review and Inspection Wall / Door Construction - Human Resources Vinyl Floor - Tile Replacement - Senior Center Arts Wireless Network Upgrade Pickup Truck Part -Time Fire Inspectors HOME / ER Program Replenishment CM0802 Renovation of Kitchen & Operations Area FS#3 Consulting Services Public Works Yard Improvements Transfer to CIP for Heritage Ave - Cheek-Sparger Rd PS2302 Fiber Optics Project, Phase II Transfer to CIP for W. Pipeline PS1902 Transfer to CIP Dingo / Compact Utility Loader Parking Lot Ross Ave. Carpet Replacement - Children's Area Library Paperless Plan Review and Inspection Part -Time Network Systems Analyst Public Service Officer School Resource Officer Bunker Gear Testing & Cleaning Agency Management System Janitorial Day Porter / Custodian Crime Scene Technician Automated License Plate Reader Camera Service Inspector Animal Control Officer Conference Center Improvements Engineering Study for Old Iron Bridge Hallway Expansion in Conference Center RFID Equipment Greenhouse Roof Replacement Program Type Capital Capital Capital Capital Capital Capital Capital Capital Capital Capital Capital Capital Capital Capital Capital Capital Capital Capital Capital Capital Supplemental Supplemental Supplemental Supplemental Supplemental Supplemental Supplemental Supplemental Supplemental Supplemental Supplemental Capital Capital Capital ^Program Cost $ 6,300 $ 8,450 $ 10,100 $ 9,400 $ 22,500 $ 24,500 $ 33,000 $ 48,330 $ 55,311 $ 60,000 $ 66,000 $ 100,000 $ 100,000 $ 239,725 $ 650,000 $ 1,936,540 $ 4,000,000 $ 22,000 $ 173,000 $ 195,000 Capital $ Capital $ Total Funded $ 6,300 $ 14,750 $ 24,850 $ 34,250 $ 56,750 $ 81,250 $ 114,250 $ 162,580 $ 217,891 $ 277,891 $ 343,891 $ 443,891 $ 543,891 $ 783,616 $ 1,433,616 $ 3,370,156 $ 7,370,156 $ 7,392,156 $ 7,565,156 $ 7,760,156 2,700 $ 2,700 35,000 $ 37,700 86,988 $ 124,688 129,540 $ 254,228 19,110 $ 273,338 20,000 $ 293,338 32,000 $ 325,338 94,860 $ 420,198 100,000 $ 520,198 128,638 $ 648,836 149,809 $ 798,645 275,000 $ 275,000 20,500 $ 295,500 220,000 $ 515,500 15,732 $ 15,732 30,000 $ 45,732 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No No No Yes Yes Yes Yes No No No No No No No Yes No No Yes Yes 34 Department Capital & Supplemental Requests for FY2023-24 by Fund *Fund Program Description Program Type Program Total Funded Cost PACS EDC New Parks Master Plan Capital $ 135,000 $ 180,732 Yes PACS EDC Misc. Parks Improvements PR0720 Capital $ 200,000 $ 380,732 Yes PACS EDC Multi -Purpose Hard Court Capital $ 150,000 $ 530,732 Yes PACS EDC PATS Lighting Capital $ 632,700 $ 1,163,432 Yes PACS EDC Recreation Assistant Supplemental $ 75,860 $ 75,860 No Police CCPD Alternate Emergency Operations Center Capital $ 22,450 $ 22,450 Yes Police CCPD Cybersecurity Data Protection Capital $ 142,000 $ 164,450 Yes Police CCPD Transfer to CIP for Police Facility Remodel Capital $ 1,250,000 $ 1,414,450 Yes Police CCPD Alternate Emergency Operations Center Capital $ 500 $ 500 Yes Non -Departmental Non -Departmental Non -Departmental Car Rental Car Rental Transfer to CIP for Redevelopment CM0804 Transfer to CIP for Animal Shelter Expansion / Renovation PEG Equipment Capital $ 1,500,000 $ 1,500,000 Yes Capital $ 6,125,000 $ 7,625,000 Yes Capital $ 34,600 $ 34,600 Yes Public Works Water/Wastewater Mini Excavator Capital $ 55,000 $ 55,000 Yes Public Works Water/Wastewater Lead Copper Rule Plan Capital $ 180,000 $ 235,000 Yes Non -Departmental Water/Wastewater Transfer to CIP Capital $ 2,000,000 $ 2,235,000 Yes Fleet & Facilities Fleet & Facilities Service Center Service Center Automatic Gates - Service Center South Entrance Repaint Service Center Capital $ 9,500 $ 9,500 Yes Capital $ 29,000 $ 38,500 Yes Fleet & Facilities Service Center Apprentice Mechanic Program Supplemental $ 47,050 $ 47,050 Yes Non -Departmental Drainage Transfer to CIP for Misc. Drainage Improvements DR9903 Capital $ 70,000 $ 70,000 Yes Golf Golf Conference Centre Assistant Manager Supplemental $ 34,554 $ 34,554 Yes Golf Golf Reserve Transfer to CIP for TSGC Misc. Improvements GC1801 Capital $ 50,000 $ 50,000 Yes Fleet & Facilities Equipment Replacement Transfer to CIP for Police & Court Facility Remodel Capital $ 1,834,236 $ 1,834,236 Yes Human Resources Insurance Enhanced Fitness/Health Screening Capital $ 44,000 $ 44,000 Yes 35 Required Disclosure Local Government Code 140.0045: Itemization of certain expenditures required in certain political subdivision budgets. Expenditures City Wide: Adjusted Proposed Actual Budget Budget FY22 FY23 FY24 1. Notices required by law to be published in a newspaper by the political subdivision or a representative of the political subdivision: $ 2,860 $ 3,550 $ 3,700 2. Directly or indirectly influencing or attempting to influence the outcome of legislation or administrative action, as those terms are defined in Section 305.002, Government Code: $ - $ - $ 36 2023 Tax Rate Calculation Worksheet This worksheet will be provided after Tarrant Appraisal District Certification on July 25, 2023. INTRODUCTION Organizational Chart Budget Process Budget Calendar Resolution Excerpt from Charter Fiscal Policies THE CITY OF EULESS CITY ATTORNEY CITY SECRETARY Wayne K. Olson Kim Sutter DEPUTY CITY MANAGER Chris Barker DIRECTOR OF PUBLIC WORKS MajorJones FLEET AND FACILITIES DIRECTOR Kyle McAdams DIRECTOR OF PLANNING AND ECONOMIC DEVELOPMENT Michael Warrix GENERAL MANAGER TEXAS STAR Glenda Hartsell -Shelton ORGANIZATIONAL CHART CITIZENS OF EULESS I I MAYOR &COUNCIL CITY MANAGER Loretta Getchell POLICE CHIEF Mike Brown DIRECTOR OF FINANACE Janina Jewell DIRECTOR OF PARKS AND COMMUNITY SERVICES Duane Strawn DIRECTOR OF HUMAN RESOURCES AND RISK MANAGEMENT Heather Moorhead Loretta Getchell, City Manager MUNICIPAL COURT JUDGE Lacy Britten May 08, 2023 MUNICIPAL COURT OF RECORD ASSISTANT CITY MANAGER Wes Rhodes FIRE CHIEF Chanc Bennett INFORMATION SERVICES DIRECTOR ScottJoyce LIBRARY DIRECTOR Sherry Knight MUNICIPAL COURT MANAGER Claudia Quintero COMMUNICATIONS AND MARKETING MANAGER Matt Sanders 1-1 The City Manager, prior to August first of each year, shall prepare and submit the budget, covering the next fiscal year, to the City Council, which shall contain the following information. In preparing the budget, each employee, officer, board, and department shall assist the city manager by furnishing all necessary information. (1) The city manager's budget message shall outline the proposed financial policies for the next fiscal year with explanations of any changes from previous years in expenditures and any major changes of policy and a complete statement regarding the financial condition of the City. (2) An estimate of all revenue from taxes and other sources, including the present tax structure rates and property evaluation for the ensuing year. A carefully itemized list of proposed expenses by office, department, agency, employee, and project for the budget year, as compared to actual expenses of the last ended fiscal year, and the present year to date. (4) A description of all outstanding bond indebtedness, showing amount, purchaser, date of issue, rate of interest, and maturity date, as well as any other indebtedness which the City had incurred and which has not been paid. A statement proposing any capital expenditures deemed necessary for undertaking during the next budget year and recommended provisions for financing. (6) A list of capital projects which should be undertaken within the five (5) next succeeding years. BUDGET PROCESS DEFINITION AND AUTHORITY The budget is a financial plan for a specific fiscal year that contains both the estimated revenues to be received during the year and the proposed expenditures to be incurred to achieve stated objectives. The City Charter established the City of Euless' fiscal year as October 1 through September 30. The City Charter further states: (3) (5) PUBLIC ACCESS Article VII, Section 3 of the City Charter provides: The budget and all supporting schedules shall be filed with the City Secretary when submitted to the City Council and shall be open for public inspection by anyone interested. PUBLIC HEARINGS Article VII, Section 4 of the City Charter provides: At the Council meeting at which time the budget is submitted, the Council shall, in conformance with the requirements of law, name the date and place of a public hearing and shall cause to be published the time and place thereof. At this hearing, interested citizens may express their opinion concerning items of expenditure, giving their reasons for wishing to increase or decrease any items of expense. 1-2 BUDGET AMENDMENT Department heads can amend the budget within their divisions as long as it does not affect total appropriations. The City Manager can amend the budget within a particular fund as long as it does not affect total appropriations. The City Council may amend the budget by a majority vote of the full membership for emergency conditions which may arise which could not reasonably have been foreseen in the normal process of planning the budget when the general welfare of the citizenry is involved. These amendments must be by ordinance and attached to the original budget in accordance with Article VII, Section 8 of the City Charter. BUDGET PREPARATION The budget preparation is coordinated through the City Manager's Office and the Finance Department. The budget process begins in late February or early March with a budget kickoff meeting with all City department directors and managers. Each department and division receives a budget preparation manual, forms and year to date budget information. Departments prepare a summary including the following information about their activities: Location and Hours of Operation Mission/Programs/Services Highlights/Accomplishments for the current fiscal year Goals & Objectives for the upcoming fiscal year Major Budgetary Issues and Operational Trends. Current year estimates are carefully reviewed and known exceptions or cost increases are reported along with justification. These variances are reviewed by the City Manager's Office for amendment as deemed necessary. The budget requests are submitted along with justification for any increases. The City Manager's office holds meetings with each director to review each of their line items and discuss any changes. All capital and supplemental requests are submitted separately and must include the following information: Purpose/objective of this request Changes/improvements from current operations Alternative financing options Estimated life of requested item Impact or consequence of not funding this request Equipment being replaced by this request Cost of the item Other associated cost A work session is held to allow each department the opportunity to present their capital and supplemental requests to the City Council. The City Manager's Office consolidates all capital requests and all supplemental requests, assigns a ranking based on funding available, and submits its recommendation to the City Council for consideration. In accordance with the fiscal policies, supplemental programs will only be funded from current revenues. One-time revenue sources and excess reserves are used to fund capital requests. The finance department prepares revenue estimates based on historical data available from the revenue manual (which is updated monthly) and other available data. Estimates are reviewed and adjusted by the City Manager's office as deemed necessary. The objective of 1-3 the City is to estimate revenues as accurately as possible to allow use of all available funding. The City Manager's Office completes a final review of the budget and submits a preliminary budget to the City Council. In accordance with Article VII, Section 2 of the City Charter, this document must be submitted to City Council prior to August 1st STRATEGIC PLANNING The City Council meets for a winter work -session and a budget work -session each year. During these work -sessions, a strategic planning session is held for discussion of short, intermediate, and long-term goals. These goals and the fiscal impact are considered during the budget process and serves as a guide throughout the year for staff. COMPREHENSIVE PLAN The City's long-term planning has been consolidated into a comprehensive five-year plan produced by the City Manager's office. This plan is updated every year and serves as the City's "road map" to which infrastructure, facility, and park projects will be done in the coming years. Each project contains a fiscal impact analysis. The comprehensive plan includes a five-year plan for drainage infrastructure, streets including overlay and construction, water and wastewater line replacement, City facilities, and the parks master plan. The information included in this document is an integral part of the budget process. The Capital Improvements Program details all funded and unfunded projects that have been identified to date and meets the requirements of the City Charter. Article VII, Section 2 (4) requires "A statement proposing any capital expenditures deemed necessary for undertaking during the next budget year and recommended provisions for financing". Section 2 (5) further requires "A list of capital projects which should be undertaken within the five (5) next succeeding years". BUDGET ADOPTION The City Charter provides: After public hearing, the City Council makes any changes deemed necessary and adopts the budget at least ten (10) days prior to the beginning of the next fiscal year by a favorable majority vote of all members of the Council. On July 29th, the City Council plans to review the preliminary operating and capital budgets. At their City Council meeting on July 31 st, the Euless City Council plans to set a date, time, and place for the budget public hearing on August 8th. City Council will consider adoption of the Budget on August 21 st. After the budget adoption, the Finance Department prepares a monthly financial report which is presented to the City Council for their review. 1-4 RESOLUTION NO. 23-1636 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF EULESS, TEXAS, ADOPTING THE CITY OF EULESS PROPOSED BUDGET CALENDAR FOR FISCAL YEAR 2023-2024, INCLUDING THE CRIME CONTROL AND PREVENTION DISTRICT AND THE EULESS DEVELOPMENT CORPORATION BUDGETS. WHEREAS, the City Council finds that it is in the best interest of the City to establish a meeting schedule relative to the adoption of the Fiscal Year 2023-2024 budget; and WHEREAS, the budget calendar establishes meetings at a convenient date and place; and WHEREAS, the City Council desires to adopt a proposed budget calendar for the Fiscal Year 2023-2024 budget cycle. NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF EULESS, TEXAS, THAT: SECTION 1. The City Council hereby adopts the Fiscal Year 2023-2024 proposed budget calendar as shown in the attached Exhibit A. Dates are subject to adjustment due to scheduling requirements. Meetings will be posted in accordance with the Texas Open Meetings Act. SECTION 2. All resolutions, or parts of resolutions in force with provisions relating to this resolution, which are inconsistent or in conflict with the terms or provisions contained herein, are hereby repealed to the extent of any such conflict only. The non -conflicting sections, sentences, paragraphs, and phrases shall remain in full force and effect. SECTION 3. This resolution shall become effective immediately upon its passage and approval. APPROVED AND ADOPTED at a regular meeting of the Euless City Council on February 14, 2023 by a vote of 5 ayes, 0 nays, and 0 abstentions. APPROVED: ATTEST: 1-131-' Linda Martin, Mayor Kim utter, RMC, CMC, City Secretary 1-5 Exhibit A Euless City Council Proposed Budget Calendar Fiscal Year 2023-2024 DATE Thursday, June 15,2023 Thursday, June 15, 2023 Thursday, June 15, 2023 Monday, June 26, 2023 Saturday, July 29, 2023 Monday, July 31, 2022 Monday, August 7, 2023 Tuesday, August 8, 2023 Monday, August 21, 2023 Monday, August 28, 2023 ACTION Hold Public Hearing on CCPD Budget. Adopt FY2024 CCPD Budget. Submit CCPD Budget to City Council. Special called meeting to receive CCPD Budget. Pre -Budget Work Session Pre -Budget Work Session Budget Work Session Special Called City Council Meeting to set date for Budget Public Hearing on August 8, Tax Rate Public Hearing on August 21st, and Vote to place a Proposal to Adopt a Specific Tax Rate on August 21st Hold Public Hearing on EDC Budget and Adopt FY2024 EDC Budget. Rg. Schedule Meeting to hold Public Hearing on FY2024 CCPD, EDC, and City Budget. Approve CCPD FY2024 Budget. Accept Notice & Certification. Rg. Schedule Meeting to hold Public Hearing on Tax Rate & Order Election, if necessary. Adopt EDC and City Budget and Tax Rate. Adopt Tax Roll. Ratify Revenue Increase if necessary. Adopt Fee/Rate Changes if necessary. Rg. Schedule Meeting for second reading of Budget, Tax Rate, Tax Roll, Ratification of Revenue Increase, and/or Fee/Rate Changes if necessary. CC — Euless City Council CCPD Board — Euless Crime Control and Prevention District Board EDC Board — Euless Development Corporation Board All meetings held at City facilities. Dates subject to change due to rescheduling requirements. Resolution No. 23-1636, Page 2 of 2 1-6 EXCERPTS FROM CHARTER CITY OF EULESS, TEXAS ARTICLE VII. FINANCE Sec. 1. Fiscal year. The fiscal year of the City of Euless shall begin on October first of each calendar year and will end on September thirtieth of the following calendar year. The fiscal year will also be established as the accounting and budget year. All funds collected by the City during any fiscal year, including both current and delinquent revenue shall belong to such fiscal year and, except funds derived to pay interest and create a sinking fund on the bonded indebtedness of the City, may be applied to the payment of the expenses incurred during such fiscal year. Any revenues uncollected at the end of any fiscal year, and any unencumbered funds actually on hand shall become resources of the next succeeding fiscal year. State law references — Budgets. V.T.C.A. Local Government Code ¶ 102.001 et seq: fiscal powers. V.T.C.A., Local Government Code ¶ 101.002. State law reference — Fiscal Year. V.T.C.A. Tax Code ¶1.05 Sec. 2. Preparation and submission of budget. The City Manager, prior to August first of each year, shall prepare and submit the budget, covering the next fiscal year, to the Council, which shall contain the following information. In preparing the budget, each employee, officer, board, and department shall assist the City Manager by furnishing all necessary information. (1) The City Manager's budget message shall outline the proposed financial policies for the next fiscal year with explanations of any change from previous years in expenditures and any major changes of policy, and a complete statement regarding the financial conditions of the City. (2) An estimate all revenue from taxes and other sources, including the present tax structure rates and property evaluation for the ensuing year. (3) A carefully itemized list of proposed expenses by office, department, agency, employee and project for the budget year, as compared to actual expenses of the last ended fiscal year, and the present year-to-date. (4) A description of all outstanding bond indebtedness, showing amount, purchaser, date of issue, rate of interest and maturity date, as well as any other indebtedness which the City had incurred and which has not been paid. (5) A statement proposing any capital expenditures deemed necessary for undertaking during the next budget year and recommended provisions for financing. (6) A list of capital projects which should be undertaken within the five (5) next succeeding years. State law reference —Budget, V.T.C.A., Local Government Code ¶ 102.001 et seq. Sec. 3 Budget a public record. The budget and all supporting schedules shall be filed with the City Secretary when submitted to the Council and shall be open to public inspection by anyone interested. State law reference — Budget, V.T.C.A., Local Government Code ¶ 102.001 et seq. 1-7 Sec. 4. Public hearing on budget. At the Council meeting at which time the budget is submitted, the Council shall, in conformance with the requirements of law, name the date and place of a public hearing and shall cause to be published the time and place thereof. At this hearing, interested citizens may express their opinions concerning items of expenditure, giving their reasons for wishing to increase or decrease any items of expense. (Amended 11-5-91) State law reference —Budget, V.T.C.A., Local Government Code ¶ 102.001 et seq. Sec. 5. Proceeding on adoption of budget. After public hearing, the Council shall analyze the budget, making any additions or deletions which they feel appropriate, and shall, at least ten (10) days prior to the beginning of the next fiscal year, adopt the budget by a favorable majority vote all members of the Council. State law reference —Budget, V.T.C.A. Local Government Code ¶ 102.001 et seq. Sec. 6. Budget, appropriation, and amount to be raised by taxation. On final adoption, the budget shall be in effect for the budget year. Final adoption of the budget by the Council shall constitute the official appropriations as proposed expenditures for the current year and shall constitute the basis of the official levy of the property tax as the amount of tax to be assessed and collected for the corresponding tax year. Estimated expenditures will in no case exceed proposed revenue plus cash on hand. Unused appropriations may be transferred to any item required for the same general purpose. Sec. 7. Unallocated reserve fund. The City Manager may recommend for action by the Council, an unallocated reserve fund to be used for unexpected items of expense which were not contained as original items of expenditures. Sec. 8. Amending the budget. Under the extreme emergency conditions which may arise and which could not reasonably have been foreseen in the normal process of planning the budget, the Council may, by a majority vote of the full membership, amend or change the budget to provide for any additional expenses in which the general welfare of the citizenry is involved. These amendments shall be by ordinance, and shall become an attachment to the original budget. State law reference —Budget, V.T.C.A. Local Government Code ¶ 102.001 et seq. Sec. 9. Certification: copies made available. A copy of the budget, as finally adopted, shall be filed with the City Secretary. The final budget shall be printed, mimeographed, or otherwise reproduced and sufficient copies shall be made available for the use of all offices, agencies and for the use of interested persons and civic organizations. Sec. 10. Defect shall not invalidate the tax levy. Errors or defects in the form or preparation of the budget or the failure to perform any procedural requirements shall not nullify the tax levy or the tax rate. 1-8 CITY OF EULESS FISCAL POLICIES I. INTRODUCTION A. Purpose Statement — The City of Euless has an important responsibility to its citizens to carefully account for public funds, to manage municipal finances wisely, and to plan for the adequate funding of services desired by the public. The overriding goal of the Fiscal Policies is to enable the City to achieve a long-term stable and positive financial condition. The watchwords of the City's fiscal management include integrity, prudent stewardship, planning, accountability, and full disclosure. The purpose of the Fiscal Policies is to provide guidelines for the Director of Finance in planning and directing the City's day to day financial affairs and in developing recommendations to the City Manager and City Council. The scope of the policies spans accounting, auditing, financial reporting, internal controls, operating and capital budgeting, revenue management, cash management, expenditure control, and debt management. B. Annual Review of Policies — These policies will be reviewed administratively by the Finance Director and City Manager and will be presented to the City Council for approval of any significant changes. II. ACCOUNTING, AUDITING, AND FINANCIAL REPORTING A. Accounting.— The Director of Finance is the City's Chief Accountant and is responsible for establishing the chart of accounts and for properly recording financial transactions. B. Accounts Receivable — This asset account reflects amounts owed to the City from citizens, companies, or other governmental entities. Delinquent accounts will be pursued. C. External Auditing 1. The City will be audited annually by outside independent accountants (auditors). The auditors must be a CPA firm of national reputation and must demonstrate that they have the breadth and depth of staff to conduct the City's audit in accordance with generally accepted auditing standards and contractual requirements. The auditor's report on the City's financial statements will be completed and submitted to City staff within 120 days of the City's fiscal year end, and the auditor's management letter will be presented to the City staff accordingly. An interim management letter will be issued prior to this date if any materially significant internal control weaknesses are discovered. 2. The Auditors are accountable to the City Council and will have access to direct communication with the City Council if the City staff is unresponsive to auditor recommendations or if the auditors consider such communication necessary to fulfill their legal and professional responsibilities. 3. Auditor Rotation — The City will not require auditor rotation, but will circulate requests for proposal for audit services at least every five years. D. Internal Auditing — The City recognizes the need for an internal audit function to provide independent, unbiased and objective reviews and assessments of the business activities, operations, financial systems and internal accounting controls of the City and some of its business partners. The reviews and assessments are conducted in order to instill confidence to citizens and stakeholders that resources are responsibly and effectively managed in order to achieve intended results. The City shall devote resources, as available, to conduct operational, financial and performance audits, selected as a result of risk analysis and assessment process. The internal audit function will report directly to the City Manager's Office. E. External Financial Reporting — The City will prepare and publish an annual comprehensive financial report (ACFR). The ACFR will be prepared in accordance with generally accepted accounting principles and will be presented annually to the Government Finance Officers Association (GFOA) for evaluation and awarding of the Certificate of Achievement for Excellence in Financial Reporting. The 1-9 ACFR will be published and presented to the City Council within 150 days after the end of the fiscal year. City staffing limitations may preclude such timely reporting. In such case, the Finance Director will inform the City Manager and the City Manager will inform the City Council of the delay and the reasons therefore. F. Internal Financial Reporting — The Finance Department will prepare internal financial reports sufficient for management to plan, monitor, and control the City's financial affairs. Internal financial reporting objectives are addressed throughout the policies. III. INTERNAL CONTROLS A. Obiective — To provide management with reasonable assurance that assets are safeguarded against loss from unauthorized use or disposition. At all times the City of Euless shall maintain an environment conducive to good internal controls. B. Written Procedures — The Finance Director is responsible for developing Citywide written guidelines on accounting, cash handling, and other financial matters which will be approved by the City Manager. The Finance Department will assist Department Managers as needed in tailoring these guidelines into detailed written procedures to fit each department's specific requirements. C. Department Managers Responsible — Each Department Manager is responsible to ensure that good internal controls are followed throughout his or her department, that all Finance Department guidelines on accounting and internal controls are implemented, and that all independent auditor internal control recommendations are addressed. IV. OPERATING BUDGET A. Preparation — The City's "operating budget" is the City's annual financial operating plan. It comprises governmental and proprietary funds, including the General Obligation Debt Service Fund. The budget is prepared by the Finance Director or appointee with the cooperation of all City Departments, and is submitted to the City Manager who makes any necessary changes and transmits the document to the City Council. The operating budget will be submitted to the GFOA annually for evaluation and awarding of the Award for Distinguished Budget Presentation. B. Balanced Budget — The operating budget will be balanced, with current revenues, exclusive of beginning resources, greater than or equal to current expenditures/expenses. C. Adoption Process — Pursuant to City Charter Article VII Section 5, a budget will be presented by the City Manager to the City Council, and to the public through the Euless Public Library, by August 1, and after public hearings the City Council shall adopt, with any changes, at least ten days prior to beginning of the new fiscal year by a majority vote. D. Amendment Process — According to Section 8 of the same article, amendments may be made by ordinance as necessary. E. Planning — The budget process will be coordinated so as to identify major policy issues for the City Council consideration several months prior to the budget approval date so that proper decision analysis can be made. Periodic financial reports will be prepared to enable the Department Managers to manage their budgets and to enable the Budget Office to monitor and control the budget as authorized by the City Manager. Summary financial reports will be presented to the City Council monthly by the third Friday after the end of each month. Such reports will enable the City Council to understand the big picture budget status. Operating Expenditure Control is addressed in another section of the Policies. F. Performance Measures and Productivity Indicators — Where appropriate, performance measures and productivity indicators will be developed and used as guidelines and reviewed for efficiency and effectiveness. This information will be included in the annual budgeting process and reported to the City Council at least annually. V. CAPITAL BUDGET AND PROGRAM A. Preparation — The City's capital budget will include all capital project funds and all capital resources. The budget will be prepared annually in conjunction with the operating budget. The capital budget will be compiled by the Finance Director with the involvement of all required City departmental project managers. Integration of the fiscal impact of capital improvements on the operating budget will be monitored. 1-10 B. Definition — 1. Facilities - include any structures or properties owned by the City, the land upon which the facility is situated for the provision of City services, and the initial furniture, fixtures, equipment and apparatus necessary to put the facility in service. Facilities include, but are not limited to the following: administrative offices, parks, service centers and storage yards, recreation centers, libraries, fire stations, jails and courts, and water and sewer related structures. 2. Infrastructure - Includes permanently installed facilities, generally placed underground or at grade, which form the basis for the provision of City services. Typically included are thoroughfares, bridges, water and sanitary sewer lines, drainage channels, and storm sewers. C. Control — All capital project expenditures must be appropriated in the capital budget. The Finance Department must certify the availability of such appropriations or the availability of resources so an appropriation can be made before a capital project contract is presented by the City Manager to the City Council for approval. D. Program Planning — The capital budget will include capital improvements program plans for future years. The planning time frame should normally be at least five years. The replacement and maintenance for capital items should be projected for the next five years. Future maintenance and operations will be fully costed, so that these costs can be considered in the operating budget. E. Alternate Resources — Where applicable, assessments, impact fees, pro-rata charges, or other user - based fees should be used to fund capital projects which have a primary benefit to specified property owners. Drainage Utility revenues are established to fund small citywide drainage projects. Single large drainage projects may be funded by debt. F. Debt Financing — Recognizing that debt is usually a more expensive financing method, alternative financing sources will be explored before debt is issued. When debt is issued, it will be used to acquire major assets with expected lives which equal or exceed the average life of the debt issue. The exceptions to this requirement are the traditional costs of marketing and issuing the debt, capitalized labor for design and construction of capital projects, and small component parts which are attached to major equipment purchases. G. Infrastructure Maintenance — The City recognizes that deferred street maintenance increases future capital costs by an estimated five- to ten -fold. Therefore, a portion of the General Fund budget will be set aside each year to maintain the quality of streets. The amount will be established annually so that repairs will be made amounting to a designated percentage of the value of the streets. H. Reporting — Periodic financial reports will be prepared to enable the Department Managers to manage their capital budgets and to enable the Finance Department to monitor and control the capital budget as authorized by the City Manager. VI. REVENUE MANAGEMENT A. Simplicity — The City will strive to keep the revenue system simple, which will result in a decrease of compliance costs for the taxpayer or service recipient and a corresponding decrease in avoidance to pay. The City will avoid nuisance taxes, fee, or charges as revenue sources. B. Certainty — An understanding of the revenue source increases the reliability of the revenue system. The City will try to understand its revenue sources, and enact consistent collection policies so that assurances can be provided that the revenue base will materialize according to budgets and plans. C. Equity — The revenue system of the City will strive to maintain equity in its structure. That is, the City will seek to minimize or eliminate all forms of subsidization between entities, funds, services, utilities, and customers. However, it is recognized that public policy decisions may lead to subsidies in certain circumstances, e.g., homestead tax exemption. D. Administration — The benefits of a revenue will exceed the cost of producing the revenue. The cost of collection will be reviewed annually for cost effectiveness as a part of the indirect cost, cost of services analysis. Where appropriate, the City will use the administrative processes of State or Federal collection agencies in order to reduce administrative costs. E. Revenue Adequacy — The City will require that there be a balance in the revenue system. That is, the revenue base will have the characteristic of fairness and neutrality as it applies to cost of service, willingness to pay, and ability to pay. F. Cost/Benefit of Abatement — The City will use due caution in the analysis of any tax, fee, or water and wastewater incentives that are used to encourage development. Ideally, a cost/benefit (fiscal impact) analysis will be performed as a part of such review. G. Diversification and Stability — In order to protect the government from fluctuations in a revenue source due to fluctuations in the economy, and variations in weather (in the case of water and wastewater), a diversified revenue system will be maintained which has a stable source of income. H. Nonrecurring Revenues — One-time revenues will not be used for ongoing operations. Nonrecurring revenues will be used only for nonrecurring expenditures. Care will be taken not to use these revenues for budget balancing purposes. Property Tax Revenues — 1. Process. Property shall be assessed at 100% of the fair market value as appraised by Tarrant Appraisal District. Reappraisal and reassessment shall be done regularly as required by State law. A 97% collection rate will serve as a goal for tax collections, with a delinquency rate of 3% or less. All delinquent taxes will be aggressively pursued, with delinquents greater than 150 days being turned over to an attorney and a penalty assessed to compensate the attorney as allowed by State law, and in accordance with the attorney's contract. Annual performance criteria will be developed for the attorney. 2. Reduce Reliance on Property Tax. The City will try to reduce reliance on property tax by seeking additional revenue sources and attempting to expand and diversify the City tax base. J. Exemptions — In order to maintain stability of funds for the City, it is the Council's intentions for the exemptions presently allowed by the City to be continued with no allowance for additional exemptions. Tax abatements should be used selectively and only when a good chance exists of economic return exceeding the loss. K. User -Based Fees — For services associated with a user fee or charge, the direct and indirect costs of that service will be offset by a fee where possible. There will be an annual review of fees and charges to ensure that fees provide adequate coverage of costs of services. L. Property Tax Distribution — The percentage of the tax rate allocated to the General Fund is the percent equal to the Maintenance and Operations portion of the total tax rate. The allocation of the tax rate for debt purposes is the percent equal to the Interest and Sinking portion of the total tax rate. Debt service should not exceed 40% except for extraordinary and temporary reasons. M. Proprietary — Proprietary funds will pay the General Fund for direct services rendered. Additionally, the Water and Wastewater Fund will pay a franchise fee of 5% of gross receipts. This is to compensate the General Fund for the lost revenue that would be payable from a privately owned utility. N. Franchise Agreements — The City will monitor the status of existing financial agreements and take necessary actions to negotiate new agreements as they near expiration or as they need revisions to best serve the citizens of Euless. O. General and Administrative Charges — A method will be maintained whereby the General Fund may impose a charge to the proprietary funds for general and administrative services (indirect costs) performed on the enterprise funds' behalf. P. Utility Rates — The City will review and adopt utility rates that will generate revenues required to fully cover operating expenditures, meet the legal restrictions of all applicable bond covenants, and provide for an adequate level of working capital needs. This policy does not preclude drawing down cash balance to finance current operations. However, it is best that any extra cash balance be used instead to finance capital projects. Q. Interest Income — Interest earned from investment of available moneys, whether pooled or not, will be distributed to the funds in accordance with the operating and capital budgets which, wherever possible, will be in accordance with the equity balance of the fund from which moneys were provided to be invested. 1-12 R. Revenue Monitoring — Revenues actually received will be regularly compared to budgeted revenues and variances will be investigated. This process will be summarized in the appropriate budget report. VII. EXPENDITURE CONTROL A. Appropriations — The level of budgetary control is the department level in the General Fund and Water and Sewer Fund, and the fund level in all other funds. When budget adjustments between funds are necessary, these must be approved by the City Council. Budget appropriation amendments at lower levels of control shall be made in accordance with the applicable administrative procedures through the finance office. B. Central Control — Significant salary and capital budgetary savings in any department will be centrally controlled and may not be spent by the department without specific City Manager authorization. C. Purchasing - All purchases shall be in accordance with the City's purchasing policies. Purchases and any contracts exceeding the limit established by state law will conform to a formal bidding process as outlined. Recommendations on purchases and contracts that are subject to the bidding process will be made to the City Council for their approval. D. Prompt Payment — All invoices will be paid within 30 days of receipt in accordance with the prompt payment requirements of State law. Procedures will be used to take advantage of all purchase discounts where considered cost effective. However, payments will also be reasonably delayed in order to maximize the City's investable cash, where such delay does not violate the agreed upon payment terms. E. Equipment Financing. — Equipment may be financed when the unit purchase price is $20,000 or more and the useful life is at least four years with City Council approval. VIII. ASSET MANAGEMENT A. Investments — The City's investment practices will be conducted in accordance with the City Council approved Investment Policies. Utilized objectives: safety, liquidity, and yield. B. Cash Manaaement — The City's cash flow will be managed to maximize the cash available to invest. C. Investment Performance — At the end of each fiscal year a report on investment performance will be provided by the Finance Director to the City Manager for presentation to the City Council. D. Fixed Assets and Inventory — These assets will be reasonably safeguarded, property accounted for, and prudently insured. DC FINANCIAL CONDITION AND RESERVES A. No Operating Deficits — Current expenditures will be paid with current revenues. Deferrals, short-term loans, or one-time sources will be avoided as budget balancing techniques. Reserves will be used only for emergencies or nonrecurring expenditures, except when balances can be reduced because their levels exceed guideline minimums. B. Operating Reserves — The General Fund resources balance combined with the Emergency Reserve Funds should be at least 30 to 60 days in working capital and never fall below 8.3% of the General Fund expenditures budget. This percentage is the equivalent of 30 days' expenditures. The Enterprise Fund working capital should be at least 45 to 75 days in working capital and never fall below 12% of the Water and Wastewater operating expense budget. An additional cash test will be required for the Water and Wastewater Fund to ensure the City's ability to operate, exclusive of accounts receivable. If reserves fall below the minimum level, the Director of Finance and City Manager will propose a plan for the replacement of the reserves. The City Council will review and approve the plan. The City will try to replace the reserves within the minimum amount of time that is practical. C. Risk Management Program — The City will aggressively pursue every opportunity to provide for the public's and City employees' safety and to manage its risks. All reasonable options will be investigated to finance losses. Such options may include risk transfer, insurance, and risk retention. Where risk is retained, reserves will be established based on actuarial determinations. Such reserves will not be used for any purpose other than for financing losses. 1-13 D. Compensated Absences — The City will establish a separate expenditure account within its operating funds to pay for accrued vacation leave. Accrued vacation leave can normally be paid by allowing a vacated position to remain open for several weeks. This account will be established based upon a schedule of estimated retirements which will be developed in conjunction with the operating budget. E. Equipment Replacement — The City shall maintain an Equipment Replacement Fund for vehicles and equipment. Funds will be transferred based on a depreciated calculation of each piece of equipment. F. Health Claims — The City shall maintain a fund for health claims for all employees. Adequate reserves shall be maintained as determined actuarially. All reasonable cost containments will be reviewed to keep the cost to the City and the employees minimal. X. DEBT MANAGEMENT A. Short -Term Debt — Short-term debt may be issued for interim financing, short economic life assets, or funding operational cash flow deficits or anticipated revenues. If utilized, tax anticipation notes (TAN's) will be retired in accordance with State law, and bond anticipation notes (BAN's) will be retired within six months of completion of the project. Any short-term debt outstanding at year end will not exceed 5% (including TAN's, but excluding BAN's) of net operating revenues. B. Long -Term Debt — The City may issue long-term debt when it is deemed that capital improvements should not be financed from current revenues, reserves, or short-term borrowings. Long -Term debt will not be used for operating purposes, and the life of the bonds will not exceed the useful life of the projects financed. C. Self -Supporting Debt — When appropriate, self-supporting revenues will pay debt service in lieu of tax revenues. D. Rating — Full disclosure of operations will be made to the bond rating agencies. The City staff, with the assistance of fiscal advisors or bond counsel, will prepare the necessary materials for and presentation to the rating agencies. E. Water and Wastewater Bond Coverage Ratios — The City has both revenue bonds and other indebtedness of the Water and Wastewater Fund. The City will maintain two coverage ratios: 1.50 for revenue bonds "technical average" and 1.25 for all indebtedness "practical coverage". The City will issue new debt for an Enterprise only after an "additional bonds" test has been applied to the issuance. This test determines that revenues are sufficient to defray the additional debt service burden that will be created by the new issuance. F. Federal Requirements — The City will maintain procedures to comply with arbitrage rebate and other Federal requirements as necessary. In attempt to exempt the City from arbitrage rebate requirements, the City will attempt to issue bonds in increments not to exceed $5,000,000 per calendar year. G. Debt Service Reserves — The Debt Service Fund will maintain a minimum level of reserves equal to one month of principal and interest. This does not include the amounts accrued for the next debt service payment. The policy above does not preclude the debt service reserves normally established to market revenue bonds. The City's policy and bond ordinance requirement are to maintain these debt service reserves at the level of the average annual debt service. H. Debt Burden — The Debt Burden should be within the norm of comparable cities. Specifically, maintenance of capacity not to exceed the median per capita and per assessed valuation will be monitored. Debt Structuring — The City will issue bonds with an average life of twenty (20) years or less in order to reduce net interest cost and maintain future flexibility by paying off debt earlier. The issuance should contribute to an overall curve that is relatively flat. J. Competitive vs. Negotiated Bidding — The City will analyze on a per issue and market basis the desire to utilize competitive versus negotiated sale of bonds. In either instance, the fiscal staff will present to management and council advantages and disadvantages of the process. K. Bidding Parameters — The notice of sale will be carefully constructed so as to ensure the best possible bid for the City, in light of the existing market conditions and other prevailing factors. Parameters to be examined include: 1-14 • Limits between lowest and highest coupons • Coupon requirements relative to the yield curve • Method of underwriter compensation, discount or premium coupons • Use of True Interest Cost (TIC) vs. Net interest Cost (NIC) • Use of bond insurance • Deep discount bonds • Variable rate bonds • Call provisions L. Bond Issuance Advisory Fees and Costs — The City will be actively involved in the selection of all financial advisors, underwriters, paying agents, and bond counsel. The City shall evaluate the merits of rotating professional advisors and consultants as well as the kinds of services and fee structures available from independent financial advisors, investment banking firms, and commercial banks. The City will carefully itemize and scrutinize all costs associated with the issuance of bonds. M. Refunding Debt —The City shall continually review outstanding obligations and may initiate refinancing when the potential for present value savings calculate to approximately five percent (5%) or gross savings exceed $100,000. N. Maximum Debt Levels — The water and wastewater bond maximum shall be within Bond Coverage Ratios as stated in this policy. The City will strive to keep the portion of the City's ad valorem tax rate for interest and sinking (debt service) that is tax supported debt (excluding self-supporting debt) below forty percent (40%) of the total adopted City ad valorem tax rate. The State of Texas limits the total City ad valorem tax rate to $2.50 per $100 valuation. O. Fixed Rate Debt — To maintain a predictable debt service schedule, the City may give preference to debt that carries a fixed interest rate. P. Variable Rate Debt - Variable rate debt is debt that bears interest at a floating rate established at specific intervals. The City strives not to exceed thirty percent (30%) of the City's total outstanding debt in variable rate debt and may consider using variable rate debt in circumstances where assets and liabilities match, for interim financing, where interest rates are above historic averages, if diversification of debt is desired, or there is a variable revenue stream. XI. STAFFING AND TRAINING A. Adequate Staffing. — Staffing levels will be adequate for the fiscal functions of the City to function effectively. Overtime shall be used only to address temporary or seasonal demands that require excessive hours. Workload shedding alternatives as well as technology will be explored before adding staff. B. Training — The City will support the continuing education efforts of all financial staff including the investment in time and materials for maintaining a current perspective concerning financial issues. Staff will be held accountable for communicating, teaching, and sharing with other staff members all information and training materials acquired from seminars, conferences, and related education efforts. C. Awards. Credentials — The City will support efforts and involvements which result in meeting standards and receiving exemplary recitations on behalf of any of the City's fiscal policies, practices, processes, products, or personnel. Further, the Finance Director will try to obtain and/or maintain designation of Certified Government Finance Officer as awarded by the GFOA of Texas. 1-15 CAPITAL, INFRASTRUCTURE PLANS & FLEET/EQUIPMENT REPLACEMENT Capital & Supplemental Requests by Fund Capital & Supplemental Requests by Department FY2023-24 Infrastructure Plan Memo, Projected Equipment Replacement Fund Proposed Fleet, Misc. Asset, and Building Asset Depreciation Transfers Proposed Fleet, Misc. Asset, and Building Asset Replacements Proposed Fleet and Misc. Asset Carryover Capital & Supplemental Requests for FY2023-24 by Fund Department *Fund Fleet & Facilities General Fleet & Facilities General Fleet & Facilities General Public Works General Fleet & Facilities General Fleet & Facilities General Information Services General Public Works General Fire General Non -Departmental General Fleet & Facilities General Non -Departmental General Public Works General Non -Departmental General Information Services General Non -Departmental General Non -Departmental General Public Works General CMO General Fleet & Facilities General Public Works General Information Services General Police General Police General Fire General Police General Fleet & Facilities General Police General Police General Public Works General Public Works General Golf Hotel PACS Hotel Golf Hotel Library EDC PACS EDC Program Description Vinyl Floor - Tile Replacement - Senior Center Exercise Carpet Replacement - Senior Center Reseal Exterior Windows in Pre -Council Chambers Paperless Plan Review and Inspection Wall / Door Construction - Human Resources Vinyl Floor - Tile Replacement - Senior Center Arts Wireless Network Upgrade Pickup Truck Part -Time Fire Inspectors HOME / ER Program Replenishment CM0802 Renovation of Kitchen & Operations Area FS#3 Consulting Services Public Works Yard Improvements Transfer to CIP for Heritage Ave - Cheek-Sparger Rd PS2302 Fiber Optics Project, Phase II Transfer to CIP for W. Pipeline PS1902 Transfer to CIP Dingo / Compact Utility Loader Parking Lot Ross Ave. Carpet Replacement - Children's Area Library Paperless Plan Review and Inspection Part -Time Network Systems Analyst Public Service Officer School Resource Officer Bunker Gear Testing & Cleaning Agency Management System Janitorial Day Porter / Custodian Crime Scene Technician Automated License Plate Reader Camera Service Inspector Animal Control Officer Conference Center Improvements Engineering Study for Old Iron Bridge Hallway Expansion in Conference Center RFID Equipment Greenhouse Roof Replacement Program Type Capital Capital Capital Capital Capital Capital Capital Capital Capital Capital Capital Capital Capital Capital Capital Capital Capital Capital Capital Capital Supplemental Supplemental Supplemental Supplemental Supplemental Supplemental Supplemental Supplemental Supplemental Supplemental Supplemental Capital Capital Capital ^Program Cost $ 6,300 $ 8,450 $ 10,100 $ 9,400 $ 22,500 $ 24,500 $ 33,000 $ 48,330 $ 55,311 $ 60,000 $ 66,000 $ 100,000 $ 100,000 $ 239,725 $ 650,000 $ 1,936,540 $ 4,000,000 $ 22,000 $ 173,000 $ 195,000 Capital $ Capital $ Total Funded $ 6,300 $ 14,750 $ 24,850 $ 34,250 $ 56,750 $ 81,250 $ 114,250 $ 162,580 $ 217,891 $ 277,891 $ 343,891 $ 443,891 $ 543,891 $ 783,616 $ 1,433,616 $ 3,370,156 $ 7,370,156 $ 7,392,156 $ 7,565,156 $ 7,760,156 2,700 $ 2,700 35,000 $ 37,700 86,988 $ 124,688 129,540 $ 254,228 19,110 $ 273,338 20,000 $ 293,338 32,000 $ 325,338 94,860 $ 420,198 100,000 $ 520,198 128,638 $ 648,836 149,809 $ 798,645 275,000 $ 275,000 20,500 $ 295,500 220,000 $ 515,500 15,732 $ 15,732 30,000 $ 45,732 Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes No No No Yes Yes Yes Yes No No No No No No No Yes No No Yes Yes 2-1 Department Capital & Supplemental Requests for FY2023-24 by Fund *Fund Program Description Program Type ^Program Cost Total Funded PACS EDC New Parks Master Plan Capital $ 135,000 $ 180,732 Yes PACS EDC Misc. Parks Improvements PR0720 Capital $ 200,000 $ 380,732 Yes PACS EDC Multi -Purpose Hard Court Capital $ 150,000 $ 530,732 Yes PACS EDC PATS Lighting Capital $ 632,700 $ 1,163,432 Yes PACS EDC Recreation Assistant Supplemental $ 75,860 $ 75,860 No Police CCPD Alternate Emergency Operations Center Capital $ 22,450 $ 22,450 Yes Police CCPD Cybersecurity Data Protection Capital $ 142,000 $ 164,450 Yes Police CCPD Transfer to CIP for Police Facility Remodel Capital $ 1,250,000 $ 1,414,450 Yes Police CCPD Alternate Emergency Operations Center Capital $ 500 $ 500 Yes Non -Departmental Car Rental Transfer to CIP for Redevelopment CM0804 Capital $ 1,500,000 $ 1,500,000 Yes Non -Departmental Car Rental Transfer to CIP for Animal Shelter Expansion / Renovation Capital $ 6,125,000 $ 7,625,000 Yes Non -Departmental PEG Equipment Capital $ 34,600 $ 34,600 Yes Public Works Water/Wastewater Mini Excavator Capital $ 55,000 $ 55,000 Yes Public Works Water/Wastewater Lead Copper Rule Plan Capital $ 180,000 $ 235,000 Yes Non -Departmental Water/Wastewater Transfer to CIP Capital $ 2,000,000 $ 2,235,000 Yes Fleet & Facilities Service Center Automatic Gates - Service Center South Entrance Capital $ 9,500 $ 9,500 Yes Fleet & Facilities Service Center Repaint Service Center Capital $ 29,000 $ 38,500 Yes Fleet & Facilities Service Center Apprentice Mechanic Program Supplemental $ 47,050 $ 47,050 Yes Non -Departmental Drainage Transfer to CIP for Misc. Drainage Improvements DR9903 Capital $ 70,000 $ 70,000 Yes Golf Golf Conference Centre Assistant Manager Supplemental $ 34,554 $ 34,554 Yes Golf Golf Reserve Transfer to CIP for TSGC Misc. Improvements GC1801 Capital $ 50,000 $ 50,000 Yes Fleet & Facilities Equipment Replacement Transfer to CIP for Police & Court Facility Remodel Capital $ 1,834,236 $ 1,834,236 Yes Human Resources Insurance Enhanced Fitness/Health Screening Capital $ 44,000 $ 44,000 Yes 2-2 Capital & Supplemental Requests for FY2023-24 by Department Department *Fund Program Description Program Type ^Program Cost Total Funded CMO General Parking Lot Ross Ave. Capital $ 173,000 $ 173,000 No Fire General Part -Time Fire Inspectors Capital $ 55,311 $ 55,311 Yes Fire General Bunker Gear Testing & Cleaning Supplemental $ 19,110 $ 19,110 No Fleet & Facilities General Vinyl Floor - Tile Replacement - Senior Center Exercise Capital $ 6,300 $ 6,300 Yes Fleet & Facilities General Carpet Replacement - Senior Center Capital $ 8,450 $ 14,750 Yes Fleet & Facilities General Reseal Exterior Windows in Pre -Council Chambers Capital $ 10,100 $ 24,850 Yes Fleet & Facilities General Wall / Door Construction - Human Resources Capital $ 22,500 $ 47,350 Yes Fleet & Facilities General Vinyl Floor - Tile Replacement - Senior Center Arts Capital $ 24,500 $ 71,850 Yes Fleet & Facilities General Renovation of Kitchen & Operations Area FS#3 Capital $ 66,000 $ 137,850 Yes Fleet & Facilities Service Center Automatic Gates - Service Center South Entrance Capital $ 9,500 $ 147,350 Yes Fleet & Facilities Service Center Repaint Service Center Capital $ 29,000 $ 176,350 Yes Fleet & Facilities Equipment Replacement Transfer to CIP for Police & Court Facility Remodel Capital $ 1,834,236 $ 2,010,586 Yes Fleet & Facilities General Carpet Replacement - Children's Area Library Capital $ 195,000 $ 2,205,586 No Fleet & Facilities Service Center Apprentice Mechanic Program Fleet & Facilities General Janitorial Day Porter / Custodian Supplemental $ 47,050 $ 47,050 Yes Supplemental $ 32,000 $ 79,050 No Golf Hotel Conference Center Improvements Capital $ 275,000 $ 275,000 Yes Golf Golf Reserve Transfer to CIP for TSGC Misc. Improvements GC1801 Capital $ 50,000 $ 325,000 Yes Golf Hotel Hallway Expansion in Conference Center Capital $ 220,000 $ 545,000 No Golf Golf Conference Centre Assistant Manager Supplemental $ 34,554 $ 34,554 Yes Human Resources Insurance Enhanced Fitness/Health Screening Capital $ 44,000 $ 44,000 Yes Information Services General Wireless Network Upgrade Capital $ 33,000 $ 33,000 Yes Information Services General Fiber Optics Project, Phase II Capital $ 650,000 $ 683,000 Yes Information Services General Part -Time Network Systems Analyst Supplemental $ 35,000 $ 35,000 Yes Library EDC RFID Equipment Capital $ 15,732 $ 15,732 Yes Non -Departmental General HOME / ER Program Replenishment CM0802 Capital $ 60,000 $ 60,000 Yes Non -Departmental General Consulting Services Capital $ 100,000 $ 160,000 Yes Non -Departmental General Transfer to CIP for Heritage Ave - Cheek-Sparger Rd PS2302 Capital $ 239,725 $ 399,725 Yes 2-3 Capital & Supplemental Requests for FY2023-24 by Department Department *Fund Program Description Program Type ^Program Cost Total Funded Non -Departmental Non -Departmental Non -Departmental Non -Departmental Non -Departmental Non -Departmental Non -Departmental PACS PACS PACS PACS PACS PACS PACS Police Police Police Police Police Police Police Police Police Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works Public Works General General Car Rental Car Rental PEG Water/Wastewater Drainage EDC EDC EDC EDC EDC Hotel EDC CCPD CCPD CCPD General General CCPD General General General General General General Water/Wastewater Water/Wastewater General General General General Transfer to CIP for W. Pipeline PS1902 Transfer to CIP Transfer to CIP for Redevelopment CM0804 Transfer to CIP for Animal Shelter Expansion / Renovation Equipment Transfer to CIP Transfer to CIP for Misc. Drainage Improvements DR9903 Greenhouse Roof Replacement New Parks Master Plan Multi -Purpose Hard Court Misc. Parks Improvements PR0720 PATS Lighting Engineering Study for Old Iron Bridge Recreation Assistant Alternate Emergency Operations Center Cybersecurity Data Protection Transfer to CIP for Police Facility Remodel Public Service Officer School Resource Officer Alternate Emergency Operations Center Agency Management System Crime Scene Technician Automated License Plate Reader Camera Service Paperless Plan Review and Inspection Pickup Truck Public Works Yard Improvements Mini Excavator Lead Copper Rule Plan Dingo / Compact Utility Loader Paperless Plan Review and Inspection Inspector Animal Control Officer Capital $ Capital $ Capital $ Capital $ Capital $ Capital $ Capital $ Capital $ Capital $ Capital $ Capital $ Capital $ Capital $ 1,936,540 4,000,000 1,500,000 6,125,000 34,600 2,000,000 70,000 $ 2,336,265 Yes $ 6,336,265 Yes $ 7,836,265 Yes $ 13,961,265 Yes $ 13,995,865 Yes $ 15,995,865 Yes $ 16,065,865 Yes 30,000 $ 30,000 Yes 135,000 $ 165,000 Yes 150,000 $ 315,000 Yes 200,000 $ 515,000 Yes 632,700 $ 1,147,700 Yes 20,500 $ 1,168,200 No Supplemental $ 75,860 $ 75,860 No Capital Capital Capital Supplemental Supplemental Supplemental Supplemental Supplemental Supplemental Capital Capital Capital Capital Capital Capital Supplemental Supplemental Supplemental 22,450 142,000 1,250,000 86,988 129,540 500 20,000 94,860 100,000 9,400 48,330 100,000 55,000 180,000 22,000 2,700 128,638 149,809 $ 22,450 Yes $ 164,450 Yes $ 1,414,450 Yes $ 86,988 Yes $ 216,528 Yes $ 217,028 Yes $ 237,028 No $ 331,888 No $ 431,888 No $ 9,400 Yes $ 57,730 Yes $ 157,730 Yes $ 212,730 Yes $ 392,730 Yes $ 414,730 No $ 2,700 Yes $ 131,338 No $ 281,147 No 2-4 FY2023-24 INFRASTRUCTURE PLAN STREET MAINTENANCE PLAN Street maintenance includes material and labor for pavement surface and sub grade repair, curb and gutter replacement (as needed), manhole and water valve adjustments, driveway approach repair (as needed) and other miscellaneous items associated with specific locations. The maintenance list and methods employed will be based on the IMS (Infrastructure Management Services) street condition study as well as staff's knowledge of street conditions. SIDEWALK PLAN Sidewalk construction includes material and labor for sidewalks, barrier free ramps where necessary, short concrete paver retaining walls where necessary and other miscellaneous items that may exist at specific locations. STREET LIGHT PLAN The street light plan includes roadway illumination on arterial and collector streets to enhance pedestrian and vehicular safety during night and low light conditions. Street light installation may include underground installation of power sources to lights, concrete foundations, and poles. Where possible the use of existing power poles will be utilized. New and/or additional street lights on residential streets are not addressed or included in this plan but are reviewed on a case by case basis. SIGNAL PLAN The Traffic Signal Plan includes traffic signals and flashing school zone signs located throughout the City of Euless. The items included in the plan are upgrades to signal controllers, upgrades to signal heads, upgrades to video detection, replacement of antiquated flashers and other miscellaneous related items. The addition of GPS (Global Positioning System) protocol for preemption is also now included City-wide. 2-5 MEMO TO: Loretta Getchell, City Manager FROM: Kyle McAdams, Fleet and Facility Director DATE: July 21, 2023 SUBJECT: Projected Equipment Replacement Fund Beginning working capital available as of October 1, 2022 $17,071,070 REVENUE: Depreciation $9,186,974 Issuance Proceeds $0 Salvage Sales (estimated) $31,930 Interest/Misc. $587,131 Total Revenues: $9,806,035 TOTAL FUNDS AVAILABLE $26,877,105 EXPENSES: Replacement Vehicles, Equipment, and Assets $2,883,897 Total Expenses: $2,883,897 ESTIMATED ENDING BALANCE SEPTEMBER 30, 2023 $23,993,208 ESTIMATED REVENUE Depreciation $4,593,672 Car Rental Fund Contribution $717,553 Salvage Sales (estimated) $78,700 Interest/Misc. $500,700 Total Revenues: $5,890,625 ESTIMATED TOTAL FUNDS AVAILABLE: $29,883,833 ESTIMATED EXPENSES: Replacement Vehicles $4,298,797 Replacement Equipment $1,337,000 Remodel / Improvements $1,958,236 Alternative Fuel Conversion $10,500 Total Expenses: $7,604,533 ESTIMATED ENDING BALANCE SEPTEMBER 30, 2024 $22,279,300 2-6 City of Euless : Fleet Depreciation Transfer Budget Year 2023 - 2024 Department Name Account Code Transfer Police / Code Compliance 101-3025-521 9601 $17,000 Police / Administration 101-3045-521 9601 $15,750 Police / Patrol 101-3046-521 9601 $439,733 Police / C.I.D. 101-3047-521 9601 $28,423 Police / Service 101-3048-521 9601 $10,926 Police / Detention 101-3049-521 9601 $0 Fire / Edu Prev. / Marshall 101-4023-522 9601 $37,521 Fire / EMS / Suppression 101-4041-522 9601 $850,865 Facility Maintenance 101-5037-519 9601 $24,467 Planning 101-6034-540 9601 $15,527 Recreation 101-7051-550 9601 $28,925 Parks 101-7052-550 9601 $175,541 Animal Control 101-8033-531 9601 $16,000 Streets 101-8033-531 9601 $165,118 Total General Fund: $1,825,796 City Engineer 501-8066-531 9601 $6,233 Water Production 501-8071-531 9601 $4,000 Water Distribution 501-8072-531 9601 $121,322 Sewer & Treatment 501-8073-531 9601 $74,088 Total Water & Wastewater: $205,643 EDC Parks (Tx Star) 210-1052-550 9601 $5,500 Fleet Services 504-5090-519 9601 $9,667 Drainage Utility 510-8029-531 9601 $4,600 Parks at Texas Star 530-7050-550 9601 $5,650 Texas Star Golf Course 540-7060-550 9601 $328,293 City Total: $2,385,149 Transfers are shown at 100% City of Euless : Misc. Asset Depreciation Transfer Budget Year 2023 - 2024 Department Name Finance - Purchasing Police / Administration Police / Patrol Police / C.I.D. Police / Service Police / Detention Police / EOC Police / CCPD - Patrol Fire / Administration Fire / Safety & Training Fire / EMS Fire / Suppression Facility Maintenance Library Recreation - Administration Recreation - EFLAP Recreation - ELFC NAT Recreation - EFLC MID Rec Recreation - Parks Maint. Recreation - Splash Recreation - Sen Center Public Works - Yard Equip. Public Works - Traffic Signals City Secretary's Office Information Services Total General Fund: Courts Engineering Well - Far North Well - Fuller Reclaimed Water Total Water & Sewer Fund: Euless Development Corp Westpark Wilshire Account Code 101-5036-519 101-3045-521 101-3046-521 101-3047-521 101-3048-521 101-3049-521 101-3024-521 220-3045-521 101-4023-522 101-4023-522 101-4041-522 101-4041-522 101-5037-519 101-5054-519 101-7084-550 101-7051-550 101-7052-550 101-7051-550 101-5052-550 101-7052-550 101-7052-550 101-8033-531 101-8033-531 101-1014-510 101-5016-519 Transfer 9601 $2,250 9601 $2,600 9601 $190,376 9601 $5,267 9601 $157,816 9601 $4,258 9601 $15,567 9601 $158,917 9601 $15,944 9601 $3,625 9601 $3,875 9601 $94,486 9601 $32,318 9601 $84,783 9601 $5,927 9601 $113,577 9601 $31,945 9601 $24,796 9601 $556 9601 $7,413 9601 $52,888 9601 $10,144 8601 $81,500 9601 $2,533 9601 $41,200 $1,144, 561 202-2013-515 9601 $700 501-8066-531 501-8071-531 501-8071-531 501-8072-531 9601 $1,800 9601 $71,233 9601 $69,333 9601 $86,850 $229, 216 210-1052-550 9601 210-1052-550 9601 $5,736 $2,600 City of Euless : Misc. Asset Depreciation Transfer Budget Year 2023 - 2024 Department Name Bob Eden VOBC Midway Heritage Trailwood Preserve McCormick Blessing Branch South Euless Carr Park Total EDC Fleet Services Special Rec Fund Parks @ Texas Star Parks @ TX Star - North Parks @ TX Star: Texas Star / Golf Operations Texas Star / Conf. Center Texas Star / Grille Operations Texas Star Golf & Conference: Transfers are shown at 100% Account Code 210-1052-550 210-1052-550 210-1052-550 210-1052-550 210-1052-550 210-1052-550 210-1052-550 210-1052-550 210-1052-550 210-1052-550 504-5090-519 520-7055-550 9601 $87,967 530-7050-550 530-7050-550 540-7062-550 540-7068-550 540-7067-550 Transfer 9601 $6,284 9601 $19,472 9601 $10,707 9601 $6,817 9601 $4,330 9601 $12,242 9601 $6,850 9601 $193 9601 $3,007 9601 $35,433 $113,671 9601 $17,843 9601 $32,552 9601 $28,813 $61,365 9601 9601 9601 $57,151 $34,894 $26,012 $118,057 City Total: $1,773,380 City of Euless : Building Asset Depreciation Transfer Budget Year 2023 - 2024 Facility Name PD & Courts Service Center City Hall Fire Administration Finance Development & Engineering Library Parks & Community Service Public Works Fire Station #1 Fire Station #2 Fire Station #3 Animal Shelter Parks Maintenance Euless Family Life Center Simmons Center City Buildings: Ruth Millican Center Fuller House Texas Star Conference Ctr. Hotel / Motel Tax: Vulcan / RediMix HQ RediMix IT Building RediMix Laboratory Shields Awards EDC Funded: Transfers are shown at 100% Account Code 101-9060-590 504-5090-519 101-9060-590 101-9060-590 101-9060-590 101-9060-590 101-9060-590 101-9060-590 101-9060-590 101-9060-590 101-9060-590 101-9060-590 101-9060-590 101-9060-590 101-9060-590 101-9060-590 201-7080-550 201-7080-550 201-7080-550 210-1031-513 210-1031-513 210-1031-513 210-1031-513 Transfers 96-01 $ 91,424 96-01 $ 4,400 96-01 $ 34,133 96-01 $ 17,800 96-01 $ 15,429 96-01 $ 22,443 96-01 $ 14,908 96-01 $ 8,800 96-01 $ 4,950 96-01 $ 16,308 96-01 $ 8,100 96-01 $ 6,280 96-01 $ 5,000 96-01 $ 5,636 96-01 $ 54,649 96-01 $ 5,231 $ 315,491 96-01 $ 7,517 96-01 $ 1,350 96-01 $ 27,828 $ 36,695 96-01 $ 63,032 96-01 $ 4,600 96-01 $ 2,242 96-01 $ 13,083 $ 82,957 City Total: $ 435,143 PROPOSED FLEET REPLACEMENTS - FY2024 PLANNED -- CURRENT -- REPLACEMENTS UNIT # VEHICLE TYPE DEPT. COST 315 FORD 1/2T CREW CAB FD - FIRE MARSHAL $ 48,000 898 FORD 4DR SEDAN FD - FIRE MARSHAL $ 45,000 960 PIERCE QUINT FD - SUPPRESSION $ 1,558,142 FD1804 KNOX KEYSECURE UNITS FD - SUPPRESSION $ 19,000 694 FORD F750 2.5T UTILITY BED PW - WATER DIST $ 146,000 804 FORD F750 2.5T UTILITY BED PW - WATER DIST $ 97,000 165 KUBOTA ZERO -TURN MOWER PARKS $ 19,000 837 FORD 3/4T PICKUP PARKS $ 44,000 934 FORD 3/4T PICKUP PARKS $ 42,000 938 FORD 1/2T PICKUP DEVELOPMENT $ 27,000 896 FORD 1/2T PICKUP PD - CODE $ 32,000 954 SAM SPEED TRAILER PD - PATROL $ 11,000 0 POLICE PURSUIT UTILITY PD - PATROL $ 66,500 0 POLICE PURSUIT UTILITY PD - PATROL $ 66,500 0 POLICE PURSUIT UTILITY PD - PATROL $ 66,500 0 POLICE PURSUIT UTILITY PD - PATROL $ 66,500 845 PACE ENCLOSED TRAILER PD - SERVICE $ 4,000 788 CARGO TRAILER RECREATION $ 7,000 840 WARREN SPREADER STREETS $ 17,000 3409 YAMAHA EMERALD TX - GOLF COURSE $ 8,300 3413 YAMAHA EMERALD TX - GOLF COURSE $ 8,300 93 KUBOTA RTV UTILITY CART TX - GOLF COURSE $ 14,500 394 TORO WORKMAN GTX TX - GOLF COURSE $ 14,100 449 TORO FAIRWAY BEVERAGE INSERT TX - GOLF COURSE $ 14,100 450 TORO FAIRWAY BEVERAGE INSERT TX - GOLF COURSE $ 18,200 911 TORO WORKMAN MDX BEV CART TX - GOLF COURSE $ 20,800 TOTAL PURCHASES FY2024: $ 2,480,442 2-11 PROPOSED MISC. ASSET REPLACEMENTS - FY2024 YEAR 2016 2010 2014 2010 2010 2012 2013 2019 2013 2013 2013 2020 2020 2013 2013 2010 2018 2006 1992 1996 2004 2019 2019 2014 2014 2008 2008 2021 1999 2008 2017 2008 2018 2008 2008 2008 2008 UNIT AGE 8 14 10 14 14 12 11 5 11 11 11 4 4 11 11 14 6 18 32 28 20 5 5 10 10 16 16 3 25 16 7 16 6 16 16 16 16 DEPT. FIRE DEPT. FIRE DEPT. FIRE DEPT. FLEET FLEET PACS PACS PACS PACS PACS PACS PACS PACS PACS PACS PACS PACS PACS PACS PACS PACS POLICE POLICE P. WORKS P. WORKS TX STAR TX STAR TX STAR TX STAR TX STAR TX STAR TX STAR TX STAR TX STAR TX STAR TX STAR TX STAR LOCATION ASSIGNED EMS SUPPRESSION TRAINING ADMIN EFLAP EFLAP EFLAP EFLAP EFLAP EFLAP ELFC - NAT EFLC - NAT EFLC - NAT EFLC - SC EFLC - FC VOBC VOBC TRAILWOOD TRAILWOOD CCPD CCPD PWYRD PWYRD GOLF GOLF GOLF CONF CENTER CONF CENTER CONF CENTER CONF CENTER CONF CENTER GRILLE GRILLE GRILLE GRILLE -- CURRENT -- ASSET TYPE ALS TRAINING MANNEQUIN THERMAL IMAGING SYSTEM BULLEX EXT. TRAINING AID MILLER TIG WELDER MILLER MIG WELDER VINYL CUTTER SAND FILTERS FUNBRELLA FABRIC SAND FILTERS SURGE PROTECTORS POOL PUMP POOL VACUUM POOL VACUUM PATIO FURNITURE EXHAUST FAN TV MONITORS PA SYSTEM TRASHCANS EXERCISE STATION PLAYGROUND PICNIC BENCHES CRIME SCENE CAMERAS DRONE PROGRAM EQUIP TRENCH BOX - 10' X 8' LEAK DETECTOR 2 DOOR COOLER 2 DOOR REACH -IN REFER RANGE MATS PORTABLE BAR TABLE & CHAIRS CHARGRILLER - 11 BURNER AV EQUIP - MASTER COMP DISHWASHER RENTAL CLUB SETS DEEP FRYER BAR COOLER - 4 DOOR SANDWICH PREP COOLER - 1 DR FREEZER WORKTOP - 1 DOOR UNIT COUNT 2 $ 14 $ 41 $ 11 $ 7 $ 1 $ TOTAL PURCHASES FY2024: PLANNED REPLACEMENTS COST 19,000 25,000 26,000 8,000 7,000 8,000 15,000 22,000 75,000 7,500 73,000 5,000 5,000 10,500 10,000 9,000 8,000 32,000 65,000 90,000 9,000 3,500 50,000 11,000 13,000 4,000 5,000 10,000 10,000 8,000 38,000 10,000 7,000 33,000 3,000 3,000 3,000 $ 740,500 2-12 PROPOSED BUILDING ASSET REPLACEMENTS - FY2024 PLANNED UNIT LOCATION -- CURRENT -- UNIT REPLACEMENTS YEAR AGE DEPT. ASSIGNED ASSET TYPE COUNT COST 2002 22 PARKS MAINT. BLDG HVAC UNITS 5 $ 124,000 TOTAL PURCHASES FY2024: $ 124,000 2-13 FLEET CARRYOVER - FY2023 UNIT **CURRENT** NUMBER VEHICLE TYPE 285 286 LP4656 LP3943 LP3761 LP2716 LP3323 LP2902 953 946 811 857 709 803 849 937 872 956 TBD TBD TBD TBD 885 FORD / FRASER AMB. CHASSIS FORD / FRASER AMB. CHASSIS LIFEPACK - 15 LIFEPACK - 15 LIFEPACK - 15 LIFEPACK - 15 LIFEPACK - 15 LIFEPACK - 15 FORD F550 / PIERCE SQUAD FORD SM. VAN FORD 1/2T STD SM PICKUP TOYOTA HYBRID SEDAN FORD 3/4T STD PICKUP FORD 4DR SEDAN FORD 3/4T STD PICKUP FORD 3/4T STD PICKUP FORD 1/2T STD PICKUP ASPHALT ZIPPER PATROL UNIT PATROL UNIT PATROL UNIT PATROL UNIT JOHN DEERE UTILITY CART DODGE / DODGE / **PROPOSED** VEHICLE TYPE FRASER AMB. CHASSIS FRASER AMB. CHASSIS FORD F550 / PIERCE SQUAD MID -SIZE VAN/CARGO BOX FORD 1/2T STD SM PICKUP FORD 1/2T STD SM PICKUP FORD 3/4T STD PICKUP CHEVROLET SM. SUV FORD 1/2T STD PICKUP FORD 3/4T STD PICKUP FORD 3/4T STD PICKUP HAMM DUAL DRUM ROLLER PATROL UNIT PATROL UNIT PATROL UNIT PATROL UNIT KUBOTA UTILITY CART DEPT. FD FD FD FD FD FD FD FD FD FACILITY MAINT. DEVELOPMENT DEVELOPMENT FLEET PD PW PW PW PW PD PD PD PD PACS TOTAL FY2024: ASSIGNED LOCATION EMS EMS EMS EMS EMS EMS EMS EMS SUPPRESS ADMIN SEWER SEWER WATER STREETS PATROL PATROL PATROL PATROL PATS-N CARRY OVER EXPENSE $ 335,171 $ 250,000 $ 47,000 $ 47,000 $ 47,000 $ 47,000 $ 47,000 $ 47,000 $ 279,184 $ 44,000 $ 35,000 $ 32,000 $ 39,000 $ 25,000 $ 39,000 $ 35,000 $ 29,000 $ 90,000 $ 72,000 $ 72,000 $ 72,000 $ 72,000 $ 16,000 $ 1,818,355 2-14 MISC. ASSET NUMBER 8PD 6P 8P 5P / 13P 15P 11T 4PD 5PD 6PD 7PD 1PW 2PW 4TX 5TX 6TX 1TX / 7TX 13T 14TX ASSET CARRYOVER - FY2023 **CURRENT** ASSET TYPE LIGHTNING PROTECTION VARIABLE FREQ. DRIVE POOL PUMPS AV EQUIPMENT FURNITURE NETWORK CORE SWITCH CELLBRITE MACHINE DISPATCH/RADIOS UPS BATS HVAC COMPUTER ROOM SWAT VESTS ALLEN-DATAGRAPH MIC DEVICES & CORRELAT LOBBY DECOR NARROW TABLES 72" ROUND TABLES AV SYSTEM PATIO TABLES PATIO CHAIRS **PROPOSED** ASSET TYPE EARTH NETWORKS LIGHTN. PRO DIGITAL RESPOURCES AV GL SEAMAN FURNITURE FORTINET SWITCH LANTEK AV SYSTEMS DEPT. PD PACS PACS PACS PACS IT PD PD PD PD PW PW TX STAR TX STAR TX STAR TX STAR TX STAR TX STAR ASSIGNED LOCATION EMERG. MGMT EFLAP EFLAP EFLAP / SC SENIOR CENTER INFO SERVICES SERVICE SERVICE CCPD CCPD PWYRD PWYRD CONF. CENTER CONF. CENTER CONF. CENTER CONF. CENTER GRILLE GRILLE CARRY OVER EXPENSE $ 125,000 $ 9,000 $ 72,000 $ 58,500 $ 85,000 $ 26,000 $ 7,000 $ 33,000 $ 20,000 $ 39,000 $ 26,000 $ 7,000 $ 7,000 $ 6,000 $ 23,000 $ 39,000 $ 5,000 $ 9,000 TOTAL FY2024: $ 596,500 2-15 DEBT Schedule of Outstanding and Proposed Indebtedness Annual Debt Service Total General Obligation Debt Tax -Supported General Obligation Debt TIRZ/PID Supported General Obligation Debt Taxable (Self -Supporting) G.O. Debt Golf G.O. Refunding Debt Water & Wastewater Revenue Debt Sales Tax Revenue Debt Outstanding Indebtedness Principal Amount of Description Dated Amount Original Paying Agent Remaining Maturity Outstanding Issuance Interest Rate General Obligation Refunding Bonds, Series 2012 Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of Obligation, Series 20111 Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of 10/15/2014 $ 3,930,000 $ 5,715,000 U.S. Bank Trust 3% to 5% 8/15/2034 Obligation, Series 20141 Company, NA Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of 10/27/2015 $ 2,245,000 $ 3,030,000 U.S. Bank Trust 3% to 5% 2/15/2035 Obligation, Series 20151 Company, NA Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of Obligation, Series 20161 Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of Obligation, Series 20185 Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of Obligation, Series 2019 Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of Obligation, Series 2020 Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of Obligation, Series 2021 Tax Notes Series 2021 Tax Notes Series 2022 Taxable General Obligation Refunding Bonds, Series 20102 General Obligation Refunding Bonds, Series 2012A3 Waterworks & Sewer System Revenue Refunding Bonds, Series 20124 Waterworks & Sewer System Revenue Bonds, Series 20134 Waterworks & Sewer System Revenue Bonds, Series 2015A4 Waterworks & Sewer System Revenue Bonds, Series 2015B4 Waterworks & Sewer System Revenue Bonds, Series 20184 Waterworks & Sewer System Revenue Bonds, Series 2019 Euless Development Corporation, Sales Tax Revenue Bonds, Series 2018 Euless Development Corporation, Sales Tax Revenue Bonds, Series 2019 AXON Enterprise, Inc. Lease 12/1/2011 $ 535,000 $ 5,955,000 U.S. Bank Trust 3% to 4% 2/15/2024 Company, NA 1/15/2011 $ 1,425,000 $ 3,035,000 U.S. Bank Trust 4%to4.25% 8/15/2030 Company, NA 1/12/2016 $ 13,365,000 $ 16,450,000 U.S. Bank Trust 2.25% to 4% 2/15/2041 Company, NA 3/1/2018 $ 7,540,000 $ 9,180,000 U.S. Bank Trust 3% to 4% 2/15/2038 Company, NA 1/15/2019 $ 10,280,000 $ 11,785,000 U.S. Bank Trust 3% to 5% 2/15/2039 Company, NA 1/14/2020 $ 6,290,000 $ 7,115,000 U.S. Bank Trust 2% to 3.5% 2/15/2040 Company, NA 4/8/2021 $ 4,980,000 $ 5,360,000 U.S. Bank Trust 1.625%to4% 2/15/2041 Company, NA 4/8/2021 $ 570,000 $ 1,625,000 U.S. Bank Trust 4.00% 2/15/2024 Company, NA 9/20/2022 $ 6,595,000 $ 7,660,000 Amegy Bank 2.89% 2/15/2029 8/15/2010 $ 1,335,000 $ 8,110,000 U.S. Bank Trust 4%to4.4% 8/1/2025 Company, NA 11/1/2012 $ 2,245,000 $ 7,185,000 U.S. Bank Trust 2%to2.625% 2/15/2027 Company, NA 3/29/2012 $ 135,000 $ 3,340,000 Bank of Texas 2.03% 7/15/2024 6/25/2013 $ 935,000 $ 1,585,000 U.S. Bank Trust 3 625% to 5% 7/15/2033 Company, NA 8/5/2015 $ 2,925,000 $ 4,685,000 U.S. Bank Trust 0.8%to 1.98% 7/15/2035 Company, NA 8/5/2015 $ 1,540,000 $ 2,380,000 U.S. Bank Trust 0.5%to 1.68% 7/15/2035 Company, NA 4/12/2018 $ 2,140,000 $ 2,785,000 U.S. Bank Trust 0.24%to 1.49% 7/15/2038 Company, NA 4/25/2019 $ 8,200,000 $ 9,275,000 U.S. Bank Trust 0.29%to 1.66% 7/15/2049 Company, NA 10/15/2018 $ 1,315,000 $ 1,635,000 U.S. Bank Trust 3% to 4% 9/15/2038 Company, NA 12/12/2019 $ 3,485,000 $ 4,120,000 U.S. Bank Trust 2.5% to 4% 9/15/2039 Company, NA 6/13/2023 $ 1,139,386 $ 1,139,386 AXON 3/15/2028 Enterprise, Inc. Proposed Indebtedness 111 Proposed Issuance Amount Proposed Sale Type Anticipated Payment Source Proposed Issuance Date Proposed Term Description Certificates of Obligation - Police & Courts Building Design & Remodel Not to exceed $22 million Competitive Sale Property Tax August 2023 20 Year 1 Bonds paid by Tax Increment Financing District and Public Improvement District. 2 Bonds paid by rental income from Stars Center. 3 Remaining Bonds paid by Texas Star Golf Course. ° Bonds paid by Water & Wastewater user charges. 5 Bonds partially paid by Tax Increment Financing District and Public Improvement District. 3-1 ANNUAL DEBT SERVICE TOTAL GENERAL OBLIGATION AND REVENUE DEBT $12,000,000 $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 $0 v SALES TAX 1/2 CENT �tGcNF STAR CENTER WATER & WASTEWATER G.O.'S AND C.O.'S 2024 2026 2028 2030 2032 2034 2036 2038 2040 2042 2044 FISCAL YEAR TOTAL ANNUAL DEBT SERVICE REQUIREMENTS SUMMARY OF TOTAL GENERAL OBLIGATION AND REVENUE DEBT GENERAL & CERTIFICATES WATER & YEAR OF OBLIGATION GOLF WASTEWATER STAR CENTER '/2 CENT 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2049 $6,716,537 $5,594,842 $5,594,891 $5,595,991 $5,589,930 $5,366,976 $4,177,501 $3,934,454 $3,935,509 $3,939,725 $3,944,975 $3,510,728 $3,286,447 $3,288,553 $3,281,728 $2,642,350 $1,790,200 $922,725 $0 $0 $0 $0 $0 $0 $0 $0 $588,738 $591,072 $587,419 $592,678 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,209,786 $1,073,658 $1,069,201 $1,073,835 $1,071,924 $1,074,096 $1,075,181 $1,074,672 $1,083,190 $1,075,675 $947,371 $954,407 $540,758 $539,444 $537,826 $380,949 $381,181 $381,208 $381,060 $380,767 $380,327 $379,773 $379,103 $383,316 $382,330 $381,225 $708,740 $715,140 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 SALES TAX $394,625 $401,075 $396,975 $396,975 $396,575 $395,775 $399,575 $394,875 $396,100 $397,000 $396,450 $395,600 $399,400 $397,700 $400,650 $278,100 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 TOTAL $73,114,063 $2,359,906 $18,592,257 $1,423,880 $6,237,450 2046 2048 REQUIREMENTS $9,618,426 $8,375,786 $7,648,486 $7,659,478 $7,058,429 $6,836,847 $5,652,257 $5,404,001 $5,414,799 $5,412,400 $5,288,796 $4,860,735 $4,226,605 $4,225,697 $4,220,204 $3, 301, 399 $2,171, 381 $1,303,933 $381,060 $380,767 $380,327 $379,773 $379,103 $383,316 $382,330 $381,225 $101,727,556 3-2 $7,500,000 $ 7, 000, 000 $6,500,000 $ 6, 000, 000 $5,500,000 $ 5, 000, 000 $4,500,000 $4,000,000 $3,500,000 $ 3, 000, 000 $2,500,000 $ 2, 000, 000 $1, 500, 000 $1, 000, 000 $500,000 $0 Total General Obligation Debt Composition of Debt Service u Interest LJ Principal 11 2024 2026 2028 2030 2032 2034 2036 Fiscal Year DEBT SERVICE REQUIREMENTS SUMMARY OF GENERAL OBLIGATION DEBT 2038 2040 YEAR INTEREST PRINCIPAL REQUIREMENTS 2024 $1,769,733 $4,946,805 $6,716,537 2025 $1,637,946 $3,956,895 $5,594,842 2026 $1,517,996 $4,076,895 $5,594,891 2027 $1,394,096 $4,201,895 $5,595,991 2028 $1,263,035 $4,326,895 $5,589,930 2029 $1,121,976 $4,245,000 $5,366,976 2030 $992,501 $3,185,000 $4,177,501 2031 $879,454 $3,055,000 $3,934,454 2032 $780,509 $3,155,000 $3,935,509 2033 $684,725 $3,255,000 $3,939,725 2034 $584,975 $3,360,000 $3,944,975 2035 $480,728 $3,030,000 $3,510,728 2036 $391,447 $2,895,000 $3,286,447 2037 $303,553 $2,985,000 $3,288,553 2038 $211,728 $3,070,000 $3,281,728 2039 $127,350 $2,515,000 $2,642,350 2040 $65,200 $1,725,000 $1,790,200 2041 $12,725 $910,000 $922,725 TOTAL $14,219,677 $58,894,386 $73,114,063 3-3 Tax -Supported General Obligation Debt Composition of Debt Service $5,500,000 $ 5, 000, 000 $4,500,000 $4,000,000 $3,500,000 $3,000,000 $2,500,000 $ 2, 000, 000 $1,500,000 $1, 000, 000 $500,000 $0 L 7 Interest Principal 2024 2026 2028 2030 2032 2034 2036 2038 2040 Fiscal Year DEBT SERVICE REQUIREMENTS SUMMARY OF TAX -SUPPORTED GENERAL OBLIGATION DEBT YEAR INTEREST PRINCIPAL REQUIREMENTS 2024 $1,118,302 $3,721,805 $4,840,106 2025 $1,022,290 $2,691,895 $3,714,185 2026 $942,214 $2,771,895 $3,714,110 2027 $859,489 $2,851,895 $3,711,385 2028 $771,385 $2,931,895 $3,703,280 2029 $674,614 $2,805,000 $3,479,614 2030 $591,164 $1,700,000 $2,291,164 2031 $525,739 $1,760,000 $2,285,739 2032 $465,966 $1,820,000 $2,285,966 2033 $410,769 $1,880,000 $2,290,769 2034 $352,875 $1,940,000 $2,292,875 2035 $292,069 $1,995,000 $2,287,069 2036 $230,884 $2,060,000 $2,290,884 2037 $169,084 $2,120,000 $2,289,084 2038 $104,291 $2,180,000 $2,284,291 2039 $47,725 $1,595,000 $1,642,725 2040 $15,475 $775,000 $790,475 2041 $3,300 $330,000 $333,300 TOTAL $8,597,633 $37,929,386 $46,527,019 3-4 CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: GENERAL OBLIGATION REFUNDING BONDS,SERIES 2012 (DATED: December 1, 2011 (ORIGINAL AMOUNT: $5,955,000 INTEREST RATES: SPAYING AGENT: IOPTION DATE: YEAR 2024 TOTAL BOND YEARS 2012-2016 @ 2.000%, 2017-2019 @ 3.000%, 2020-2022 @ 4.000%, 2023 @ 3.000% and 2024 @ 3.125% U.S. BANK TRUST COMPANY, NATIONAL ASSOCIATION* February 15, 2021 INTEREST PRINCIPAL TOTAL COUPON FEBRUARY 15 AUGUST 15 FEBRUARY 15 REQUIREMENTS 3.125% $8,359 $0 $535,000 $543,359 $8,359 $0 $535,000 $543,359 Proceeds from the sale of the Bonds were used to (i) refund a portion of the City's outstanding debt in order to lower the overall debt service requirements of the City and (ii) to pay the costs associated with the issuance of the bonds. These Bonds are direct obligations of the City payable from an annual ad valorem tax levied on all taxable property within the City, within the limits prescribed by law. * 2022 Successor Paying Agent 3-5 DESCRIPTION: CITY OF EULESS DEBT SERVICE REQUIREMENTS TAX & WATERWORKS & SEWER SYSTEM (LIMITED PLEDGE) REVENUE CERTIFICATES OF OBLIGATION, SERIES 2018 DATED: March 1, 2018 (ORIGINAL AMOUNT: $9,180,000 BOND YEARS 2019 @ 4.00%, 2020-2023 @ 3.00%, 2024-2029 @ 4.00%, 2030- INTEREST RATES: 2031 @ 3.00%, 2032-2033 @ 3.125%, 2034-2035 @ 3.250%, 2036-2037 @ 3.3375% and 2038 @ 3.50% (PAYING AGENT: U.S. BANK TRUST COMPANY, NATIONAL ASSOCIATION* (OPTION DATE: February 15, 2028 INTEREST PRINCIPAL TOTAL YEAR COUPON FEBRUARY 15 AUGUST 15 FEBRUARY 15 REQUIREMENTS 2024 4.000% $131,756 $124,056 $385,000 $640,813 2025 4.000% $124,056 $116,056 $400,000 $640,113 2026 4.000% $116,056 $107,756 $415,000 $638,813 2027 4.000% $107,756 $99,056 $435,000 $641,813 2028 4.000% $99,056 $90,056 $450,000 $639,113 2029 4.000% $90,056 $80,656 $470,000 $640,713 2030 3.000% $80,656 $73,382 $485,000 $639,039 2031 3.000% $73,382 $65,881 $500,000 $639,264 2032 3.125% $65,881 $57,834 $515,000 $638,716 2033 3.125% $57,834 $49,475 $535,000 $642,309 2034 3.250% $49,475 $40,538 $550,000 $640,013 2035 3.250% $40,538 $31,275 $570,000 $641,813 2036 3.375% $31,275 $21,319 $590,000 $642,594 2037 3.375% $21,319 $11,025 $610,000 $642,344 2038 3.500% $11,025 $0 $630,000 $641,025 TOTAL $1,100,123 $968,367 $7,540,000 $9,608,490 Proceeds from the sale of the Certificates will be used for (i) the construction of public works, to wit: (a) constructing, renovating, enlarging, equipping and improving various streets, roads, bridges, overpasses, alleyways, thoroughfares, sidewalks, pathways and related municipal facilities within the City, including lane markings, signage, street, drainage, curbs, gutters, ADA accessibility, traffic signals, lighting and landscaping related thereto and the acquisition of necessary rights -of -way and land in connection therewith; (b) constructing, renovating, enlarging, equipping, and improving water and wastewater facilities for the City and the acquisition of necessary rights -of -way and land in connection therewith; and (c) renovating, improving and equipping existing City buildings and facilities for police, fire and other City departments, including HVAC system and lighting improvements, and (ii) professional services rendered in relation to such projects and the financing thereof. A portion of the debt service is being repaid from other sources. * 2022 Successor Paying Agent 3-6 CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: AXON ENTERPRISE, INC. LEASE DATED: June 13, 2023 (ORIGINAL AMOUNT: $1,139,386 INTEREST RATES: PAYING AGENT: AXON ENTERPRISE, INC. OPTION DATE: N/A INTEREST PRINCIPAL TOTAL YEAR INTEREST December/March December/March REQUIREMENTS 2024 $231,805 $231,805 2025 $226,895 $226,895 2026 $226,895 $226,895 2027 $226,895 $226,895 2028 $226,895 $226,895 TOTAL $0 $1,139,386 $1,139,386 The lease was used to finance an integrated camera and taser system along with related hardware and software for the police department. 3-7 DESCRIPTION: CITY OF EULESS DEBT SERVICE REQUIREMENTS TAX & WATERWORKS & SEWER SYSTEM (LIMITED PLEDGE) REVENUE CERTIFICATES OF OBLIGATION, SERIES 2019 (DATED: January 15, 2019 IORIGINALAMOUNT: $11,785,000 INTEREST RATES: (PAYING AGENT: (OPTION DATE: BOND YEARS 2020-2024 @ 3.00%, 2025-2028 @ 4.00%, 2029-2031 @ 5.00%, 2032-2035 @ 4.00%, 2036 @ 3.250%, 2037-2038 @ 3.3375% and 2039 @ 3.50% U.S. BANK TRUST COMPANY, NATIONAL ASSOCIATION* February 15, 2028 INTEREST PRINCIPAL TOTAL YEAR COUPON FEBRUARY 15 AUGUST 15 FEBRUARY 15 REQUIREMENTS 2024 3.000% $202,228 $195,328 $460,000 $857,556 2025 4.000% $195,328 $185,728 $480,000 $861,056 2026 4.000% $185,728 $175,728 $500,000 $861,456 2027 4.000% $175,728 $165,328 $520,000 $861,056 2028 4.000% $165,328 $154,528 $540,000 $859,856 2029 5.000% $154,528 $140,403 $565,000 $859,931 2030 5.000% $140,403 $125,528 $595,000 $860,931 2031 5.000% $125,528 $109,903 $625,000 $860,431 2032 4.000% $109,903 $96,803 $655,000 $861,706 2033 4.000% $96,803 $83,203 $680,000 $860,006 2034 4.000% $83,203 $69,003 $710,000 $862,206 2035 4.000% $69,003 $54,303 $735,000 $858,306 2036 3.250% $54,303 $41,872 $765,000 $861,175 2037 3.375% $41,872 $28,541 $790,000 $860,413 2038 3.375% $28,541 $14,788 $815,000 $858,328 2039 3.500% $14,788 $0 $845,000 $859,788 TOTAL $1,843,216 $1,640,988 $10,280,000 $13,764,203 Proceeds from the sale of the Certificates will be used for (i) the construction of public works, to wit: (a) constructing, renovating, enlarging, equipping and improving various streets, roads, bridges, overpasses, alleyways, thoroughfares, sidewalks, pathways and related municipal facilities within the City, including lane markings, signage, street, drainage, curbs, gutters, ADA accessibility, traffic signals, lighting and landscaping related thereto and the acquisition of necessary rights -of -way and land in connection therewith; (b) constructing, renovating, enlarging, equipping, and improving water and wastewater facilities for the City and the acquisition of necessary rights -of -way and land in connection therewith; and (c) renovating, improving and equipping existing City buildings and facilities for police, fire and other City departments, including HVAC system and lighting improvements, and (ii) professional services rendered in relation to such projects and the financing thereof. * 2022 Successor Paying Agent 3-8 DESCRIPTION: CITY OF EULESS DEBT SERVICE REQUIREMENTS TAX & WATERWORKS & SEWER SYSTEM (LIMITED PLEDGE) REVENUE CERTIFICATES OF OBLIGATION, SERIES 2020 (DATED: January 14, 2020 (ORIGINAL AMOUNT: $7,115,000 INTEREST RATES: (PAYING AGENT: (OPTION DATE: BOND YEARS 2020-2024 @ 3.50%, 2025-2031 @ 3.00%, 2032-2033 @ 2.00%, 2034 @ 2.125%, 2035 @ 2.250%, 2036-2037 @ 2.375% and 2038-2040 @ 2.50% U.S. BANK TRUST COMPANY, NATIONAL ASSOCIATION* February 15, 2029 INTEREST PRINCIPAL TOTAL YEAR COUPON FEBRUARY 15 AUGUST 15 FEBRUARY 15 REQUIREMENTS 2024 3.500% $82,313 $77,150 $295,000 $454,463 2025 3.000% $77,150 $72,575 $305,000 $454,725 2026 3.000% $72,575 $67,850 $315,000 $455,425 2027 3.000% $67,850 $63,050 $320,000 $450,900 2028 3.000% $63,050 $58,100 $330,000 $451,150 2029 3.000% $58,100 $53,000 $340,000 $451,100 2030 3.000% $53,000 $47,675 $355,000 $455,675 2031 3.000% $47,675 $42,200 $365,000 $454,875 2032 2.000% $42,200 $38,500 $370,000 $450,700 2033 2.000% $38,500 $34,700 $380,000 $453,200 2034 2.125% $34,700 $30,556 $390,000 $455,256 2035 2.250% $30,556 $26,113 $395,000 $451,669 2036 2.375% $26,113 $21,303 $405,000 $452,416 2037 2.375% $21,303 $16,375 $415,000 $452,678 2038 2.500% $16,375 $11,063 $425,000 $452,438 2039 2.500% $11,063 $5,625 $435,000 $451,688 2040 2.500% $5,625 $0 $450,000 $455,625 TOTAL $748,147 $665,834 $6,290,000 $7,703,981 Proceeds from the sale of the Certificates will be used for (i) the construction of public works, to wit: acquiring, designing, constructing, improving, expanding and equipping one or more fire stations (including the demolition of existing Fire Station #1), and (ii) professional services rendered in relation to such projects and the financing thereof. * 2022 Successor Paying Agent 3-9 DESCRIPTION: CITY OF EULESS DEBT SERVICE REQUIREMENTS TAX AND WATERWORKS AND SEWER SYSTEM (LIMITED PLEDGE) REVENUE CERTIFICATE OF OBLIGATION, SERIES 2021 DATED: April 8, 2021 IORIGINAL AMOUNT: $5,360,000 INTEREST RATES: BOND YEARS 2022-2041 @ 4.000% - 1.625% (PAYING AGENT: (OPTION DATE: YEAR COUPON 2024 2.125% 2025 1.750% 2026 1.750% 2027 1.700% 2028 4.000% 2029 4.000% 2030 4.000% 2031 3.000% 2032 1.625% 2033 1.625% 2034 1.750% 2035 1.750% 2036 2.000% 2037 2.000% 2038 2.000% 2039 2.000% 2040 2.000% 2041 2.000% TOTAL U.S. BANK TRUST COMPANY, NATIONAL ASSOCIATION* February 15, 2030 INTEREST PRINCIPAL FEBRUARY 15 AUGUST 15 FEBRUARY 15 $56,123 $53,732 $225,000 $53,732 $51,719 $230,000 $51,719 $49,707 $230,000 $49,707 $47,709 $235,000 $47,709 $42,909 $240,000 $42,909 $37,909 $250,000 $37,909 $32,609 $265,000 $32,609 $28,559 $270,000 $28,559 $26,284 $280,000 $26,284 $23,969 $285,000 $23,969 $21,431 $290,000 $21,431 $18,850 $295,000 $18,850 $15,850 $300,000 $15,850 $12,800 $305,000 $12,800 $9,700 $310,000 $9,700 $6,550 $315,000 $6,550 $3,300 $325,000 $3,300 $0 $330,000 $539,712 $483,589 $4,980,000 TOTAL REQUIREMENTS $334,854 $335,451 $331,426 $332,416 $330,619 $330,819 $335,519 $331,169 $334,844 $335,253 $335,400 $335,281 $334,700 $333,650 $332,500 $331,250 $334,850 $333,300 $6,003,301 Proceeds from the sale of the Certificates will be used to (i) construct public works and, (ii) to pay professional services rendered in relation to such projects and the financing thereof. * 2022 Successor Paying Agent 3-10 CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: TAX NOTES, SERIES 2021 DATED: April 8, 2021 ORIGINAL AMOUNT: $1,625,000 INTEREST RATES: 4.00% (PAYING AGENT: OPTION DATE: YEAR 2024 TOTAL U.S. BANK TRUST COMPANY, NATIONAL ASSOCIATION* N/A INTEREST PRINCIPAL TOTAL INTEREST FEBRUARY 15 AUGUST 15 FEBRUARY 15 REQUIREMENTS 4.000% $11,400 $0 $570,000 $581,400 $11,400 $0 $570,000 $581,400 Proceeds from the sale of the Notes will be used for: (i) the costs of purchasing equipment, machinery, buildings and vehicles for the City fire and police departments and (ii) professional services rendered in connection with such projects and the Notes. * 2022 Successor Paying Agent 3-11 CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: TAX NOTES, SERIES 2022 DATED: September 20, 2022 ORIGINAL AMOUNT: $7,660,000 INTEREST RATES: 2.89% (PAYING AGENT: AMEGY BANK OPTION DATE: N/A INTE ZEST PRINCIPAL TOTAL YEAR INTEREST FEBRUARY 15 AUGUST 15 FEBRUARY 15 REQUIREMENTS 2024 2.890% $95,298 $80,559 $1,020,000 $1,195,857 2025 2.890% $80,559 $65,386 $1,050,000 $1,195,945 2026 2.890% $65,386 $49,708 $1,085,000 $1,200,094 2027 2.890% $49,708 $33,596 $1,115,000 $1,198,304 2028 2.890% $33,596 $17,051 $1,145,000 $1,195,647 2029 2.890% $17,051 $0 $1,180,000 $1,197,051 TOTAL $341,598 $246,300 $6,595,000 $7,182,898 Proceeds from the sale of the Notes will be used for: (i) acquiring, designing, constructing, improving, expanding and equipping one or more fire stations, and (ii) the costs of professional services rendered in connection with the financing thereof. 3-12 TIRZ/PID-Supported General Obligation Debt Composition of Debt Service $2,000,000 $1, 500, 000 $1, 000, 000 $500,000 $0 2024 2026 2028 2030 2032 2034 2036 2038 2040 Fiscal Year DEBT SERVICE REQUIREMENTS SUMMARY OF TIRZ/PID-SUPPORTED GENERAL OBLIGATION DEBT 1Interest Principal : . iww �� n�.„„, YEAR INTEREST PRINCIPAL REQUIREMENTS 2024 $651,431 $1,225,000 $1,876,431 2025 $615,656 $1,265,000 $1,880,656 2026 $575,781 $1,305,000 $1,880,781 2027 $534,606 $1,350,000 $1,884,606 2028 $491,650 $1,395,000 $1,886,650 2029 $447,363 $1,440,000 $1,887,363 2030 $401,338 $1,485,000 $1,886,338 2031 $353,716 $1,295,000 $1,648,716 2032 $314,544 $1,335,000 $1,649,544 2033 $273,956 $1,375,000 $1,648,956 2034 $232,100 $1,420,000 $1,652,100 2035 $188,659 $1,035,000 $1,223,659 2036 $160,563 $835,000 $995,563 2037 $134,469 $865,000 $999,469 2038 $107,438 $890,000 $997,438 2039 $79,625 $920,000 $999,625 2040 $49,725 $950,000 $999,725 2041 $9,425 $580,000 $589,425 TOTAL $5,622,044 $20,965,000 $26,587,044 TIRZ - Tax Increment Reinvestment Zone PID - Public Improvement District 3-13 DESCRIPTION: CITY OF EULESS DEBT SERVICE REQUIREMENTS TAX & WATERWORKS & SEWER SYSTEM (LIMITED PLEDGE) REVENUE CERTIFICATES OF OBLIGATION, SERIES 2011 DATED: January 15, 2011 (ORIGINAL AMOUNT: $180,130 INTEREST RATES: (PAYING AGENT: OPTION DATE: YEAR 2024 2025 2026 2027 2028 2029 2030 TOTAL COUPON 4.000% 4.000% 4.000% 4.125% 4.125% 4.250% 4.250% BOND YEARS 2011-2018 @ 3.000%, 2019-2026 @ 4.000%, 2027-2028 @ 4.125%, 2029-2030 @ 4.250% U.S. BANK TRUST COMPANY, NATIONAL ASSOCIATION* August 15, 2021 INTEREST PRINCIPAL FEBRUARY 15 AUGUST 15 AUGUST 15 $1,650 $1,650 $10,000 $1,450 $1,450 $10,000 $1,250 $1,250 $10,000 $1,050 $1,050 $10,000 $844 $844 $10,000 $638 $638 $15,000 $319 $319 $15,000 $7,200 $7,200 $80,000 TOTAL REQUIREMENTS $13,300 $12,900 $12,500 $12,100 $11,688 $16,275 $15,638 $94,400 Proceeds from the sale of the Bonds were used for (i) street improvements, including drainage, landscaping, curbs, gutters, sidewalks, entryways, signage, lighting, and traffic signalization incidental thereto, and the acquisition of land and rights -of -way therefor, and (ii) to pay the costs associated with the issuance of the bonds. These Bonds are direct obligations of the City payable from an annual ad valorem tax levied on all taxable property within the City, within the limits prescribed by law. * 2022 Successor Paying Agent 3-14 DESCRIPTION: CITY OF EULESS DEBT SERVICE REQUIREMENTS TAX & WATERWORKS & SEWER SYSTEM (LIMITED PLEDGE) REVENUE CERTIFICATES OF OBLIGATION, SERIES 2011 (GLADE PARKS) (DATED: January 15, 2011 (ORIGINAL AMOUNT: $2,854,870 INTEREST RATES: (PAYING AGENT: (OPTION DATE: BOND YEARS 2011-2018 @3.000%, 2019-2026 @ 4.000%, 2027-2028@ 4.125%, 2029-2030 @4.250% U.S. BANK TRUST COMPANY, NATIONAL ASSOCIATION* August 15, 2021 INTEREST PRINCIPAL TOTAL YEAR COUPON FEBRUARY 15 AUGUST 15 AUGUST 15 REQUIREMENTS 2024 4.000% $27,672 $27,672 $170,000 $225,344 2025 4.000% $24,272 $24,272 $175,000 $223,544 2026 4.000% $20,772 $20,772 $185,000 $226,544 2027 4.125% $17,072 $17,072 $195,000 $229,144 2028 4.125% $13,050 $13,050 $200,000 $226,100 2029 4.250% $8,925 $8,925 $205,000 $222,850 2030 4.250% $4,569 $4,569 $215,000 $224,138 TOTAL $116,331 $116,331 $1,345,000 $1,577,663 Proceeds from the sale of the Bonds were used for (i) street improvements, including drainage, landscaping, curbs, gutters, sidewalks, entryways, signage, lighting, and traffic signalization incidental thereto, and the acquisition of land and rights -of -way therefor, and (ii) to pay the costs associated with the issuance of the bonds. These Bonds are direct obligations of the City payable from an annual ad valorem tax levied on all taxable property within the City, within the limits prescribed by law. 2022 Successor Paying Agent 3-15 CITY OF EULESS DEBT SERVICE REQUIREMENTS TAX & WATERWORKS & SEWER SYSTEM (LIMITED PLEDGE) DESCRIPTION: REVENUE CERTIFICATES OF OBLIGATION, SERIES 2014 (GLADE PARKS) DATED: October 15, 2014 (ORIGINAL AMOUNT: $5,715,000 (INTEREST RATES: BOND YEARS 2017-2023 @5.000%, 2024-2034 @ 3.000% (PAYING AGENT: U.S. BANK TRUST COMPANY, NATIONAL ASSOCIATION* (OPTION DATE: August 15, 2024 INTEREST PRINCIPAL TOTAL YEAR COUPON FEBRUARY 15 AUGUST 15 AUGUST 15 REQUIREMENTS 2024 3.000% $58,950 $58,950 $305,000 $422,900 2025 3.000% $54,375 $54,375 $315,000 $423,750 2026 3.000% $49,650 $49,650 $325,000 $424,300 2027 3.000% $44,775 $44,775 $335,000 $424,550 2028 3.000% $39,750 $39,750 $345,000 $424,500 2029 3.000% $34,575 $34,575 $355,000 $424,150 2030 3.000% $29,250 $29,250 $365,000 $423,500 2031 3.000% $23,775 $23,775 $380,000 $427,550 2032 3.000% $18,075 $18,075 $390,000 $426,150 2033 3.000% $12,225 $12,225 $400,000 $424,450 2034 3.000% $6,225 $6,225 $415,000 $427,450 TOTAL $371,625 $371,625 $3,930,000 $4,673,250 Proceeds from the sale of the Bonds will be used for (i) street improvements, including drainage, landscaping, curbs, gutters, sidewalks, entryways, signage, lighting, and traffic signalization incidental thereto, and the acquisition of land and rights -of -way therefor, and (ii) professional services rendered in relation to such projects and the financing thereof. These Bonds are direct obligations of the City payable from an annual ad valorem tax levied on all taxable property within the City, within the limits prescribed by law. * 2022 Successor Paying Agent 3-16 DESCRIPTION: DATED: ORIGINAL AMOUNT: INTEREST RATES: PAYING AGENT: OPTION DATE: YEAR COUPON 2024 5.000% 2025 3.000% 2026 3.000% 2027 3.000% 2028 3.000% 2029 3.000% 2030 3.000% 2031 3.125% 2032 3.125% 2033 3.250% 2034 3.500% 2035 3.375% TOTAL CITY OF EULESS DEBT SERVICE REQUIREMENTS TAX & WATERWORKS & SEWER SYSTEM (LIMITED PLEDGE) REVENUE CERTIFICATES OF OBLIGATION, SERIES 2015 (GLADE PARKS PHASE 3) October 27, 2015 $3,030,000 BOND YEARS 2016-2035 @3.000% - 5.000% U.S. BANK TRUST COMPANY, NATIONAL ASSOCIATION* February 15, 2026 INTEREST FEBRUARY 15 $36,375 $32,625 $30,225 $27,750 $25,200 $22,500 $19,725 $16,875 $13,828 $10,703 $7,291 $3,797 $246,894 AUGUST 15 $32,625 $30,225 $27,750 $25,200 $22,500 $19,725 $16,875 $13,828 $10,703 $7,291 $3,797 $0 $210,519 PRINCIPAL FEBRUARY 15 $150,000 $160,000 $165,000 $170,000 $180,000 $185,000 $190,000 $195,000 $200,000 $210,000 $215,000 $225,000 $2,245,000 TOTAL REQUIREMENTS $219,000 $222,850 $222,975 $222,950 $227,700 $227,225 $226,600 $225,703 $224,531 $227,994 $226,088 $228,797 $2,702,413 Proceeds from the sale of the Certificates will be used for (i) street improvements, including drainage, landscaping, curbs, gutters, sidewalks, entryways, signage, lighting and traffic signalization incident thereto and the acquisition of land and rights -of -way therefor and (ii) professional services rendered in relation to such projects and the financing thereof. * 2022 Successor Paying Agent 3-17 CITY OF EULESS DEBT SERVICE REQUIREMENTS TAX & WATERWORKS & SEWER SYSTEM (LIMITED PLEDGE) DESCRIPTION: REVENUE CERTIFICATES OF OBLIGATION, SERIES 2016 (MIDTOWN DEVELOPMENT) DATED: January 12, 2016 ORIGINAL AMOUNT: INTEREST RATES: PAYING AGENT: OPTION DATE: YEAR COUPON 2024 2.250% 2025 3.000% 2026 3.000% 2027 3.000% 2028 3.000% 2029 3.000% 2030 3.000% 2031 3.000% 2032 3.000% 2033 3.000% 2034 3.000% 2035 3.000% 2036 3.125% 2037 3.125% 2038 3.125% 2039 3.250% 2040 3.250% 2041* 3.250% TOTAL $16,450,000 BOND YEARS 2016-2041 ©2.000% - 4.000% U.S. BANK TRUST COMPANY, NATIONAL ASSOCIATION** August 15, 2026 INTEREST PRINCIPAL TOTAL FEBRUARY 15 $202,944 $196,306 $187,231 $177,931 $168,331 $158,431 $148,231 $137,731 $126,931 $115,756 $104,281 $92,431 $80,281 $67,234 $53,719 $39,813 $24,863 $9,425 $2,091,872 AUGUST 15 $202,944 $196,306 $187,231 $177,931 $168,331 $158,431 $148,231 $137,731 $126,931 $115,756 $104,281 $92,431 $80,281 $67,234 $53,719 $39,813 $24,863 $0 $2,082,447 AUGUST 15 $590,000 $605,000 $620,000 $640,000 $660,000 $680,000 $700,000 $720,000 $745,000 $765,000 $790,000 $810,000 $835,000 $865,000 $890,000 $920,000 $950,000 $580,000 $13,365,000 REQUIREMENTS $995,888 $997,613 $994,463 $995,863 $996,663 $996,863 $996,463 $995,463 $998,863 $996,513 $998,563 $994,863 $995,563 $999,469 $997,438 $999,625 $999,725 $589,425 $17,539,319 Proceeds from the sale of the Certificates will be used for (i) public infrastructure including demolishing dangerous structures, streets, street improvements, water and wastewater, drainage, curbs, gutters, sidewalks, entryways, signage, lighting, traffic signalization and other public improvements thereto and the acquisition of land and rights - of -way therefor and (ii) professional services rendered in relation to such projects and the financing thereof. * In 2041, Principal payment and final maturity is February 15, 2041. ** 2022 Successor Paying Agent 3-18 Taxable (Self Supporting) G.O. Debt Composition of Debt Service $800,000 $700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 so — 2024 Fiscal Year Interest Principal DEBT SERVICE REQUIREMENTS SUMMARY OF TAXABLE (SELF SUPPORTING) G.O. DEBT YEAR INTEREST PRINCIPAL REQUIREMENTS 2024 $58,740 $650,000 $708,740 2025 $30,140 $685,000 $715,140 TOTAL $88,880 $1,335,000 $1,423,880 G.O. - General Obligation 3-19 DESCRIPTION: CITY OF EULESS DEBT SERVICE REQUIREMENTS TAXABLE GENERAL OBLIGATION REFUNDING BONDS SERIES 2010 DATED: AUGUST 15, 2010 ORIGINAL AMOUNT: $8,110,000 INTEREST RATES: 2011 - 2025, RATES VARY FROM .680% TO 4.400% 'PAYING AGENT: U.S. BANK TRUST COMPANY, NATIONAL ASSOCIATION* 'OPTION DATE: August 1, 2021 INTEREST PRINCIPAL TOTAL YEAR COUPON FEBRUARY 1 AUGUST 1 AUGUST 1 REQUIREMENTS 2024 4.400% $29,370 $29,370 $650,000 $708,740 2025 4.400% $15,070 $15,070 $685,000 $715,140 (TOTAL $44,440 $44,440 $1,335,000 $1,423,880 Proceeds from the sale of the Certificates were used to purchase a community ice skating recreation facility and to pay the costs associated with the issuance of the Certificates. The Certificates constitute direct obligations of the City, payable from a combination of (i) the levy and collection of a direct and continuing ad valorem tax levied on all taxable property within the City, within the limits prescribed by law, and (ii) a limited pledge (not to exceed $1,000) of the Net revenues of the City's combined Waterworks and Sewer System as provided in the Ordinance. The facility is operated by the Dallas Stars; rental payments received from the operator are used to fund this self- supporting debt. * 2022 Successor Paying Agent 3-20 $800,000 $600,000 $400,000 $200,000 $0 Golf G.O. Refunding Debt Composition of Debt Service PRINCIPAL INTEREST 2024 2026 Fiscal Year DEBT SERVICE REQUIREMENTS SUMMARY OF GOLF G.O. REFUNDING DEBT YEAR INTEREST PRINCIPAL REQUIREMENTS 2024 $48,738 $540,000 $588,738 2025 $36,072 $555,000 $591,072 2026 $22,419 $565,000 $587,419 2027 $7,678 $585,000 $592,678 TOTAL $114,906 $2,245,000 $2,359,906 These bonds were originally issued as C. O. bonds paid from the surplus revenues of each function. Therefore, they are presented separately from other G.O. and C.O. Bonds. G.O. - General Obligation C.O. - Certificates of Obligation 3-21 DESCRIPTION: CITY OF EULESS DEBT SERVICE REQUIREMENTS GENERAL OBLIGATION REFUNDING BONDS, SERIES 2012A-GOLF DATED: November 1, 2012 ORIGINAL AMOUNT: $7,185,000 INTEREST RATES: PAYING AGENT: OPTION DATE: BOND YEAR 2013-2014 @ 2.00%, 2015-2016 @ 4.000%, 2017-2018 @ 2.000%, 2019-2021 @ 3.000%, 2022 @ 2.000%, 2023 @ 2.125%, 2024 @ 2.250%, 2025 @ 2.375%, 2026 @ 2.500%, 2027 @ 2.625% U.S. BANK TRUST COMPANY, NATIONAL ASSOCIATION* FEBRUARY 15, 2022 INTEREST PRINCIPAL TOTAL YEAR COUPON FEBRUARY 15 AUGUST 15 FEBRUARY 15 REQUIREMENTS 2024 2.250% $27,406 $21,331 $540,000 $588,738 2025 2.375% $21,331 $14,741 $555,000 $591,072 2026 2.500% $14,741 $7,678 $565,000 $587,419 2027 2.625% $7,678 $0 $585,000 $592,678 TOTAL $71,156 $43,750 $2,245,000 $2,359,906 Proceeds from the sale of the Bonds were used to (i) advance refund a portion of the City's outstanding debt in order to lower the overall debt service requirements of the City and (ii) to pay the costs associated with the issuance of the bonds. AVERAGE ANNUAL DEBT OUTSTANDING $589,977 * 2022 Successor Paying Agent 3-22 $1,300,000 $1,200,000 $1,100,000 $1,000,000 $900,000 $800,000 $700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 $0 Water & Wastewater Revenue Debt Composition of Debt Service 1.1 2024 PRINCIPAL INTEREST 2027 2030 2033 2036 2039 2042 2045 2048 Fiscal Year DEBT SERVICE REQUIREMENTS SUMMARY OF WATER AND WASTEWATER SYSTEM REVENUE DEBT YEAR INTEREST PRINCIPAL REQUIREMENTS 2024 $244,786 $965,000 $1,209,786 2025 $233,658 $840,000 $1,073,658 2026 $224,201 $845,000 $1,069,201 2027 $213,835 $860,000 $1,073,835 2028 $201,924 $870,000 $1,071,924 2029 $189,096 $885,000 $1,074,096 2030 $175,181 $900,000 $1,075,181 2031 $159,672 $915,000 $1,074,672 2032 $143,190 $940,000 $1,083,190 2033 $125,675 $950,000 $1,075,675 2034 $107,371 $840,000 $947,371 2035 $94,407 $860,000 $954,407 2036 $80,758 $460,000 $540,758 2037 $74,444 $465,000 $539,444 2038 $67,826 $470,000 $537,826 2039 $60,949 $320,000 $380,949 2040 $56,181 $325,000 $381,181 2041 $51,208 $330,000 $381,208 2042 $46,060 $335,000 $381,060 2043 $40,767 $340,000 $380,767 2044 $35,327 $345,000 $380,327 2045 $29,773 $350,000 $379,773 2046 $24,103 $355,000 $379,103 2047 $18,316 $365,000 $383,316 2048 $12,330 $370,000 $382,330 2049 $6,225 $375,000 $381,225 TOTAL $2,717,257 $15,875,000 $18,592,257 AVERAGE ANNUAL PRINCIPAL AND INTEREST OUTSTANDING $715,087 3-23 CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: WATERWORKS AND SEWER SYSTEM REVENUE REFUNDING BONDS, SERIES 2012 DATED: March 29, 2012 ORIGINAL AMOUNT: $3,340,000 INTEREST RATES: BOND YEAR 2012-2024 @ 2.030% PAYING AGENT: BANK OF TEXAS OPTION DATE: N/A INTEREST PRINCIPAL TOTAL YEAR COUPON JANUARY 15 JULY 15 JULY 15 REQUIREMENTS 2024 2.030% $1,370 $1,370 $135,000 $137,740 (TOTAL $1,370 $1,370 $135,000 $137,740 Proceeds from the sale of the Bonds were used to (i) advance refund a portion of the City's outstanding Water and Wastewater System debt in order to lower the overall debt service requirements of the Water and Sewer fund and (ii) to pay the costs associated with the issuance of the Bonds. 3-24 DESCRIPTION: DATED: (ORIGINAL AMOUNT: INTEREST RATES: PAYING AGENT: OPTION DATE: YEAR 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 TOTAL COUPON 4.000% 4.000% 4.000% 4.500% 4.500% 4.500% 5.000% 5.000% 5.000% 5.000% CITY OF EULESS DEBT SERVICE REQUIREMENTS WATERWORKS AND SEWER SYSTEM REVENUE BONDS, SERIES 2013 June 25, 2013 $1,585,000 BOND YEAR 2012-2033 @ 2.00% - 5.00% U.S. BANK TRUST COMPANY, NATIONAL ASSOCIATION* July 25, 2023 INTEREST PRINCIPAL JANUARY 15 JULY 15 JULY 15 $21,525 $21,525 $75,000 $20,025 $20,025 $80,000 $18,425 $18,425 $80,000 $16,825 $16,825 $85,000 $14,913 $14,913 $90,000 $12,888 $12,888 $95,000 $10,750 $10,750 $100,000 $8,250 $8,250 $105,000 $5,625 $5,625 $110,000 $2,875 $2,875 $115,000 $132,100 $132,100 $935,000 TOTAL REQUIREMENTS $118,050 $120,050 $116,850 $118,650 $119,825 $120,775 $121,500 $121,500 $121,250 $120,750 $1,199,200 Proceeds from the sale of the Bonds will be used for (i) the construction, acquisition, purchase, renovation, enlargement, equipment and improvement of waterworks and sewer system properties and facilities, including the acquisition of land and rights -of -way therefor, and (ii) paying the costs associated with the issuance of the Bonds. * 2022 Successor Paying Agent 3-25 DESCRIPTION: DATED: ORIGINAL AMOUNT: INTEREST RATES: CITY OF EULESS DEBT SERVICE REQUIREMENTS WATERWORKS AND SEWER SYSTEM REVENUE BONDS, SERIES 2015A (Meters) June 15, 2015 $4,685,000 BOND YEARS 2019-2035 @ 0% - 1.98% PAYING AGENT: U.S. BANK TRUST COMPANY, NATIONAL ASSOCIATION* OPTION DATE: N/A YEAR 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 TOTAL COUPON 1.120% 1.250% 1.390% 1.500% 1.590% 1.670% 1.740% 1.800% 1.850% 1.900% 1.940% 1.980% INTEREST JANUARY 15 JULY 15 $24,255 $24,255 $22,995 $22,995 $21,589 $21,589 $19,991 $19,991 $18,228 $18,228 $16,360 $16,360 $14,356 $14,356 $12,224 $12,224 $9,974 $9,974 $7,616 $7,616 $5,146 $5,146 $2,624 $2,624 $175,357 $175,357 PRINCIPAL JULY 15 $225,000 $225,000 $230,000 $235,000 $235,000 $240,000 $245,000 $250,000 $255,000 $260,000 $260,000 $265,000 $2,925,000 TOTAL REQUIREMENTS $273,511 $270,991 $273,178 $274,981 $271,456 $272,720 $273,712 $274,449 $274,949 $275,231 $270,291 $270,247 $3,275,713 Proceeds from the sale of the Bonds will be used for (i) the construction, acquisition, purchase, renovation, enlargement, equipment and improvement of waterworks and sewer system properties and facilities, including the acquisition of land and rights -of -way therefor, and (ii) paying the costs associated with the issuance of the Bonds. * 2022 Successor Paying Agent 3-26 DESCRIPTION: DATED: ORIGINAL AMOUNT: INTEREST RATES: CITY OF EULESS DEBT SERVICE REQUIREMENTS WATERWORKS AND SEWER SYSTEM REVENUE BONDS, SERIES 2015B (Reclaimed Water System) June 15, 2015 $2,380,000 BOND YEARS 2020-2035 @ 0% -1.68% PAYING AGENT: U.S. BANK TRUST COMPANY, NATIONAL ASSOCIATION* OPTION DATE: N/A YEAR 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 TOTAL COUPON 0.820% 0.950% 1.090% 1.200% 1.290% 1.370% 1.440% 1.500% 1.550% 1.600% 1.640% 1.680% INTEREST JANUARY 15 $10,449 $9,957 $9,387 $8,733 $7,983 $7,177 $6,320 $5,384 $4,409 $3,363 $2,283 $1,176 $76,620 JULY 15 $10,449 $9,957 $9,387 $8,733 $7,983 $7,177 $6,320 $5,384 $4,409 $3,363 $2,283 $1,176 $76,620 PRINCIPAL JULY 15 $120,000 $120,000 $120,000 $125,000 $125,000 $125,000 $130,000 $130,000 $135,000 $135,000 $135,000 $140,000 $1,540,000 TOTAL REQUIREMENTS $140,898 $139,914 $138,774 $142,466 $140,966 $139,353 $142,641 $140,769 $143,819 $141,726 $139,566 $142,352 $1,693,240 Proceeds from the sale of the Bonds will be used for (i) the construction, acquisition, purchase, renovation, enlargement, equipment and improvement of waterworks and sewer system properties and facilities, including the acquisition of land and rights -of -way therefor, and (ii) paying the costs associated with the issuance of the Bonds. * 2022 Successor Paying Agent 3-27 DESCRIPTION: DATED: ORIGINAL AMOUNT: INTEREST RATES: CITY OF EULESS DEBT SERVICE REQUIREMENTS WATERWORKS AND SEWER SYSTEM REVENUE BONDS, SERIES 2018 4/12/2018* $2,785,000 BOND YEARS 2018-2038 @ 0% -1.49% PAYING AGENT: U.S. BANK TRUST COMPANY, NATIONAL ASSOCIATION** OPTION DATE: N/A YEAR 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 TOTAL INTEREST PRINCIPAL TOTAL COUPON JANUARY 15 JULY 15 JULY 15 REQUIREMENTS $12,439 $12,439 $135,000 $159,878 0.540% 0.670% 0.810% 0.940% 1.020% 1.110% 1.170% 1.220% 1.270% 1.320% 1.370% 1.410% 1.440% 1.470% 1.490% $12,075 $12,075 $11,622 $11,076 $10,441 $9,753 $8,976 $8,157 $7,303 $6,382 $5,425 $4,432 $3,374 $2,294 $1,155 $114,900 $11,622 $11,076 $10,441 $9,753 $8,976 $8,157 $7,303 $6,382 $5,425 $4,432 $3,374 $2,294 $1,155 $114,900 $135,000 $135,000 $135,000 $135,000 $140,000 $140,000 $140,000 $145,000 $145,000 $145,000 $150,000 $150,000 $155,000 $155,000 $2,140,000 $159,149 $158,245 $157,151 $155,882 $159,505 $157,951 $156,313 $159,605 $157,764 $155,850 $158,863 $156,748 $159,588 $157,310 $2,369,800 Proceeds from the sale of the Bonds will be used for (i) the construction, acquisition, purchase, renovation, enlargement, equipment and improvement of waterworks and sewer system properties and facilities, including the acquisition of land and rights -of -way therefor, and (ii) paying the costs associated with the issuance of the Bonds. * Changed date to reflect date on Official Statement. ** 2022 Successor Paying Agent 3-28 DESCRIPTION: DATED: IORIGINAL AMOUNT: INTEREST RATES: CITY OF EULESS DEBT SERVICE REQUIREMENTS WATERWORKS AND SEWER SYSTEM REVENUE BONDS, SERIES 2019 April 25, 2019 $9,275,000 BOND YEARS 2020-2049 @ 0.23% -1.66% PAYING AGENT: U.S. BANK TRUST COMPANY, NATIONAL ASSOCIATION* (OPTION DATE: N/A YEAR 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2049 TOTAL COUPON 0.420% 0.500% 0.560% 0.640% 0.720% 0.830% 0.960% 1.060% 1.140% 1.200% 1.240% 1.290% 1.340% 1.400% 1.450% 1.490% 1.530% 1.560% 1.580% 1.600% 1.610% 1.620% 1.630% 1.640% 1.650% 1.660% INTEREST JANUARY 15 JULY 15 $52,355 $52,355 $51,778 $51,778 $51,078 $50,294 $49,398 $48,372 $47,189 $45,821 $44,284 $42,602 $40,832 $38,972 $37,005 $34,928 $32,758 $30,474 $28,090 $25,604 $23,030 $20,384 $17,664 $14,886 $12,051 $9,158 $6,165 $3,113 $858,282 $51,078 $50,294 $49,398 $48,372 $47,189 $45,821 $44,284 $42,602 $40,832 $38,972 $37,005 $34,928 $32,758 $30,474 $28,090 $25,604 $23,030 $20,384 $17,664 $14,886 $12,051 $9,158 $6,165 $3,113 $858,282 PRINCIPAL TOTAL JULY 15 REQUIREMENTS $275,000 $379,710 $280,000 $280,000 $280,000 $285,000 $285,000 $285,000 $290,000 $295,000 $295,000 $300,000 $305,000 $310,000 $310,000 $315,000 $320,000 $325,000 $330,000 $335,000 $340,000 $345,000 $350,000 $355,000 $365,000 $370,000 $375,000 $8,200,000 $383,555 $382,155 $380,587 $383,795 $381,743 $379,378 $381,642 $383,568 $380,205 $381,665 $382,945 $384,010 $379,856 $380,516 $380,949 $381,181 $381,208 $381,060 $380,767 $380,327 $379,773 $379,103 $383,316 $382,330 $381,225 $9,916,564 Proceeds from the sale of the Bonds will provide funds for Capital Improvement Project WT1802 Well Replacement - Fuller / Far North. * 2022 Successor Paying Agent 3-29 $500,000 $450,000 $400,000 $350,000 $300,000 $250,000 $200,000 $150,000 $100,000 $50,000 Sales Tax Revenue Debt Composition of Debt Service PRINCIPAL INTEREST /MFMIR ool� 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 Fiscal Year DEBT SERVICE REQUIREMENTS SUMMARY OF SALES TAX REVENUE DEBT TOTAL YEAR INTEREST PRINCIPAL REQUIREMENTS 2024 $164,625 $230,000 $394,625 2025 $156,075 $245,000 $401,075 2026 $146,975 $250,000 $396,975 2027 $136,975 $260,000 $396,975 2028 $126,575 $270,000 $396,575 2029 $115,775 $280,000 $395,775 2030 $104,575 $295,000 $399,575 2031 $94,875 $300,000 $394,875 2032 $86,100 $310,000 $396,100 2033 $77,000 $320,000 $397,000 2034 $66,450 $330,000 $396,450 2035 $55,600 $340,000 $395,600 2036 $44,400 $355,000 $399,400 2037 $32,700 $365,000 $397,700 2038 $20,650 $380,000 $400,650 2039 $8,100 $270,000 $278,100 TOTAL $1,437,450 $4,800,000 $6,237,450 MAXIMUM ANNUAL DEBT SERVICE (RESERVE) AVERAGE ANNUAL DEBT OUTSTANDING $401,075 $389,841 3-30 DESCRIPTION: CITY OF EULESS DEBT SERVICE REQUIREMENTS EULESS DEVELOPMENT CORPORATION, SALES TAX REVENUE BONDS, SERIES 2018 DATED: 10/15/18 ORIGINAL AMOUNT: $1,635,000 INTEREST RATE: YEARS 2020-2025 @ 3.00%, YEARS 2026-2038 @ 4.00% PAYING AGENT: U.S. BANK TRUST COMPANY, NATIONAL ASSOCIATION* OPTION DATE: 9/15/2028 INTEREST PRINCIPAL TOTAL YEAR COUPON MARCH 15 SEPTEMBER 15 SEPTEMBER 15 REQUIREMENTS 2024 3.00% $25,625 $25,625 $65,000 $116,250 2025 3.00% $24,650 $24,650 $70,000 $119,300 2026 4.00% $23,600 $23,600 $70,000 $117,200 2027 4.00% $22,200 $22,200 $75,000 $119,400 2028 4.00% $20,700 $20,700 $75,000 $116,400 2029 4.00% $19,200 $19,200 $80,000 $118,400 2030 4.00% $17,600 $17,600 $85,000 $120,200 2031 4.00% $15,900 $15,900 $85,000 $116,800 2032 4.00% $14,200 $14,200 $90,000 $118,400 2033 4.00% $12,400 $12,400 $95,000 $119,800 2034 4.00% $10,500 $10,500 $95,000 $116,000 2035 4.00% $8,600 $8,600 $100,000 $117,200 2036 4.00% $6,600 $6,600 $105,000 $118,200 2037 4.00% $4,500 $4,500 $110,000 $119,000 2038 4.00% $2,300 $2,300 $115,000 $119,600 TOTAL $228,575 $228,575 $1,315,000 $1,772,150 Proceeds from the sale of the Bonds will be used to (i) pay contractual obligations of the City to be incurred for the construction of parks and park facilities, and (ii) pay the costs associated with the issuance of the Bonds. * 2022 Successor Paying Agent 3-31 DESCRIPTION: DATED: (ORIGINAL AMOUNT: INTEREST RATE: (PAYING AGENT: (OPTION DATE: CITY OF EULESS DEBT SERVICE REQUIREMENTS EULESS DEVELOPMENT CORPORATION, SALES TAX REVENUE BONDS, SERIES 2019 12/12/19* $4,120,000 YEARS 2020-2029 @ 4.00%, 2030 @ 3.00%, YEARS 2031-2032 @2.5%, YEARS 2033-2039 @ 3.00% U.S. BANK TRUST COMPANY, NATIONAL ASSOCIATION** 9/15/2030 INTEREST PRINCIPAL TOTAL YEAR COUPON MARCH 15 SEPTEMBER 15 SEPTEMBER 15 REQUIREMENTS 2024 4.00% $56,688 $56,688 $165,000 $278,375 2025 4.00% $53,388 $53,388 $175,000 $281,775 2026 4.00% $49,888 $49,888 $180,000 $279,775 2027 4.00% $46,288 $46,288 $185,000 $277,575 2028 4.00% $42,588 $42,588 $195,000 $280,175 2029 4.00% $38,688 $38,688 $200,000 $277,375 2030 3.00% $34,688 $34,688 $210,000 $279,375 2031 2.50% $31,538 $31,538 $215,000 $278,075 2032 2.50% $28,850 $28,850 $220,000 $277,700 2033 3.00% $26,100 $26,100 $225,000 $277,200 2034 3.00% $22,725 $22,725 $235,000 $280,450 2035 3.00% $19,200 $19,200 $240,000 $278,400 2036 3.00% $15,600 $15,600 $250,000 $281,200 2037 3.00% $11,850 $11,850 $255,000 $278,700 2038 3.00% $8,025 $8,025 $265,000 $281,050 2039 3.00% $4,050 $4,050 $270,000 $278,100 TOTAL $490,150 $490,150 $3,485,000 $4,465,300 Proceeds from the sale of the Bonds will be used to (i) pay contractual obligations of the City to be incurred for improvements to parks and park facilities located at the Parks at Texas Star, including softball facilities, and (ii) pay the costs associated with the issuance of the Bonds. * Changed date to reflect date on O/S. ** 2022 Successor Paying Agent 3-32 PERSONNEL & INSURANCE Personnel Counts Personnel Counts by Fund Proposed Pay Plan Proposed Insurance Premiums Insurance & Benefits Risk & Workers Compensation CITY ADMINISTRATION CITY SECRETARY Total City Administration FINANCE/BUDGET MUNICIPAL COURTS ACCOUNTING PURCHASING Total Finance POLICE CODE COMP/COMM SVRS POLICE ADMINISTRATION POLICE PATROL POLICE CID POLICE SERVICE POLICE DETENTION Total Police Department FIRE MARSHAL/EDUCATION FIRE ADMINISTRATION EMS/SUPPRESSION Total Fire Department INFORMATION SERVICES HUMAN RESOURCES FACILITY MAINTENANCE Total Administrative Services LIBRARY Total Library PLANNING & DEVELOPMENT INSPECTIONS SERVICES Total Planning & Development RECREATION PARKS SENIOR CENTER RECREATION ADMINISTRATION Total Community Services STREET MAINTENANCE ANIMAL CONTROL CITY ENGINEER Total Public Works TOTAL GENERAL FUND EDC - PARKS EDC - LIBRARY EDC - ECO. DEV. TOTAL EDC FUND WATER OFFICE Total Finance W&S ENGINEERING WATER PRODUCTION WATER DISTRIBUTION SEWAGE & TREATMENT METER SERVICES Total Public Works INFORMATION SERVICES W&S NON-DEPT. Total Non -departmental TOTAL W&S FUND GOLF NON DEPARTMENTAL GOLF COURSE MAINT. GOLF PRO SHOP GOLF FOOD AND BEVERAGE GOLF CONFERENCE CENTRE TOTAL GOLF COURSE FUND JUVENILE CASE FUND CRIME CONTROL FUND SERVICE CENTER FUND DRAINAGE UTILITY FUND PARKS @ TEXAS STAR HEALTH INSURANCE FUND WC/RISK MANAGEMENT FUND TOTAL OTHER FUNDS TOTAL ALL FUNDS Full -Time Personnel Counts FY 21/22 FY 22/23 FY 22/23 ACTUAL BUDGETED ESTIMATED 3.50 3.50 3.50 3.50 3.50 3.50 7.00 7.00 7.00 1.50 G 2.50 2.50 8.25 B,F 7.75 7.75 3.50 3.50 3.50 1.00 1.00 1.00 14.25 14.75 14.75 16.00 16.00 16.00 7.00 7.00 7.00 49.00 C 48.00 48.00 14.00 D 16.00 16.00 21.00 D 22.50 22.50 17.00 D 13.50 13.50 124.00 123.00 123.00 4.00 4.00 4.00 4.00 4.00 4.00 70.00 70.00 70.00 78.00 78.00 78.00 1.00 1.00 1.00 3.50 3.50 3.50 4.00 4.00 4.00 8.50 8.50 8.50 9.00 9.00 9.00 9.00 9.00 9.00 2.50 B 3.50 3.50 4.00 4.00 4.00 6.50 7.50 7.50 5.50 5.50 5.50 11.00 11.00 11.00 2.00 2.00 2.00 1.00 1.00 1.00 19.50 19.50 19.50 11.50 A 13.50 13.50 3.00 E 4.00 4.00 1.00 1.00 1.00 15.50 18.50 18.50 282.25 285.75 285.75 13.25 A 14.25 14.25 10.00 10.00 10.00 1.00 1.00 1.00 24.25 25.25 25.25 5.00 5.00 5.00 5.00 5.00 5.00 3.00 3.00 3.00 5.75 5.75 5.75 8.25 8.25 8.25 8.00 8.00 8.00 1.00 1.00 1.00 26.00 26.00 26.00 4.00 4.00 4.00 10.00 10.00 10.00 14.00 14.00 14.00 45.00 45.00 45.00 0.75 0.75 0.75 4.00 4.00 4.00 2.50 2.50 2.50 3.00 3.00 3.00 1.50 1.50 1.50 11.75 11.75 11.75 0.75 F 0.25 0.25 18.00 C 19.00 19.00 5.00 5.00 5.00 8.00 8.00 8.00 1.50 1.50 1.50 1.00 1.00 1.00 0.50 0.50 0.50 34.75 35.25 35.25 398.00 403.00 403.00 A) Added FT Field Tech(s) B) Transferred Court Clerk to Planning & Development C) Transferred 1 Police Officer from General Fund to CCPD D Transferred 3.5 positions from Detention to CID and Services E) Converted Part Time to Full Time F) Transferred 0.25 Juvenile Case Manager and 0.25 Court Clerk to General Fund G) Funded Internal Audit Position as Accountant II H) Transferred .25 Court Clerk from General Fund to Juvenile Case Fund FY 23/24 BUDGETED 3.50 3.50 7.00 2.50 H 7.50 3.50 1.00 14.50 I,N 18.00 7.00 I,J 44.00 19.00 21.50 0 14.50 124.00 4.00 4.00 70.00 78.00 1.00 3.50 4.00 8.50 9.00 9.00 K 2.50 K 5.00 7.50 L,M 4.75 L 9.50 2.00 1.00 17.25 13.50 4.00 1.00 18.50 284.25 L 16.25 10.00 1.00 27.25 5.00 5.00 3.00 5.75 8.25 8.00 1.00 26.00 4.00 10.00 14.00 45.00 0.75 4.00 2.50 3.00 M,P 2.75 13.00 H 0.50 J 20.00 5.00 8.00 1.50 1.00 0.50 36.50 406.00 I) Moved Officers within Police division in General Fund J) Transferred 1 Police Officer from General Fund to CCPD K) Moved Secretary within Planning division in General Fund L) Moved .5 Controller and 1.5 Field Tech from General Fund Parks to EDC Parks M) Moved .25 TX Star Gen Mgr from General Fund to Golf Fund N) Added Additional SRO to General Fund 0) Added FT Public Service Officer P) Added FT Conference Center Assistant Manager 4-1 PERSONNEL COUNTS BY FUND GENERAL FUND EDC FUND WATER & WW FUND GOLF COURSE FUND JUVENILE CASE FUND CRIME CONTROL DISTRICT SERVICE CENTER FUND DRAINAGE UTILITY PARKS AT TEXAS STAR HEALTH INSURANCE FUND WC/RISK MANAGEMENT FUND TOTAL GENERAL FUND EDC FUND WATER & WW FUND GOLF COURSE FUND SPECIAL RECREATION FUND PARKS AT TEXAS STAR TOTAL FY22 ACTUAL 282.25 24.25 45.00 11.75 0.75 18.00 5.00 8.00 1.50 1.00 0.50 398.00 49.00 17.00 2.00 57.00 3.00 26.00 154.00 FULL-TIME EMPLOYEES FY23 BUDGETED 285.75 25.25 45.00 11.75 0.25 19.00 5.00 8.00 1.50 1.00 0.50 403.00 FY23 ESTIMATED 285.75 25.25 45.00 11.75 0.25 19.00 5.00 8.00 1.50 1.00 0.50 403.00 PART-TIME EMPLOYEES 47.00 47.00 17.00 2.00 57.00 3.00 26.00 152.00 17.00 2.00 57.00 3.00 26.00 152.00 FY24 FUNDED 284.25 27.25 45.00 13.00 0.50 20.00 5.00 8.00 1.50 1.00 0.50 406.00 48.00 17.00 2.00 57.00 3.00 26.00 153.00 4-2 PROPOSED PUBLIC SAFETY PAY PLAN FIRE EFFECTIVE 09-20-2023 POLICE EFFECTIVE 09-21-2023 H.T.E. STEP 1 2 3 4 5 6 Job Grade Code FLSA Job Title Start Pay EOY 1 EOY 2 EOY 3 EOY 4 Merit Top 510.00 120.00 1 N I PSO 520.00 I 21.00 N Dispatcher 21.01 N Crime Scene Technician 1 N Fire Inspector I 730.00 122.00 N Fire Fighter 740.00 1 22.01 1N (Fire Fighter/Paramedic 550.00 23.00 I N Communications Supervisor N Jail Supervisor 565.00 I 24.00 I N Police Officer 24.03 I N Fire Inspector II 770.00 24.02 $4,207 $4,418 $4,637 $4,870 $5,113 $5,3681 $50,486 $53,011 $55,650 $58,446 $61,355 $64,4211 24.2722 25.4862 26.7547 28.0989 29.4974 30.97151 $4,810 $5,051 $5,303 $5,568 $5,705 $6,1391 $57,724 $60,611 $63,632 $66,811 $68,460 $73,6661 27.7520 29.1397 30.5922 32.1209 32.9132 35.41631 $5,876 $6,169 $6,479 $6,802 $7,144 $7,4991 $70,509 $74,027 $77,747 $81,625 $85,729 $89,9921 24.1471 25.3518 26.6258 27.9539 29.3593 30.81901 $6,091 $6,384 $6,735 $7,058 $7,483 $7,8381 $73,089 $76,607 $80,823 $84,701 $89,797 $94,0591 25.0305 26.2352 27.6791 29.0072 30.7524 32.21211 $5,541 $5,819 $6,109 $6,415 $6,736 $7,0731 $66,496 $69,833 $73,305 $76,981 $80,836 $84,8731 31.9690 33.5734 35.2429 37.0100 38.8637 40.80431 $6,052 $6,340 $6,642 $6,958 $7,293 $7,6401 $72,629 $76,079 $79,709 $83,497 $87,511 $91,6821 34.9177 36.5764 38.3216 40.1430 42.0726 44.07801 N 'Firefighter II/Paramedic $6,267 $6,555 $6,899 $7,214 $7,632 $7,9791 $75,209 $78,659 $82,785 $86,573 $91,579 $95,7501 25.7564 26.9379 28.3510 29.6484 31.3626 32.79121 585.00 I 24.99 I N Police Corporal 25.00 I N Senior Police Officer 590.00 126.01 I N 'Fire Inspector III $6,462 $6,750 $7,052 $7,368 $7,702 $8,0501 $77,544 $80,994 $84,625 $88,413 $92,427 $96,5981 37.2810 38.9395 40.6851 42.5061 44.4358 46.4413' $6,538 $6,825 $7,128 $7,443 $7,778 $8,1251 $78,454 $81,903 $85,534 $89,321 $93,336 $97,5061 37.7183 39.3765 41.1219 42.9429 44.8729 46.87791 790.00 I 25.02 IN (Fire Fighter/Driver/Paramedic $6,753 $7,040 $7,384 $7,700 $8,117 $8,4651 $81,033 $84,483 $88,609 $92,397 $97,403 $101,5751 27.7510 28.9325 30.3454 31.6428 33.3572 34.78581 595.00 1 25.03 1 N 'Senior Police Corporal $7,007 $7,331 $7,669 $8,023 $8,358 $8,7441 $84,087 $87,970 $92,032 $96,281 $100,294 $104,9251 40.4264 42.2931 44.2460 46.2891 48.2184 50.44481 4-3 Job Grade Code FLSA 605.00 610.00 26.00 27.00 N N PROPOSED PUBLIC SAFETY PAY PLAN FIRE EFFECTIVE 09-16-2022 POLICE EFFECTIVE 09-22-2022 H.T.E. STEP 1 2 3 4 5 Job Title Start Pay EOY 1 EOY 2 EOY 3 EOY 4 Police Sergeant Public Education Officer $7,938 $95,261 45.7986 820.00 1 26.03 1 N (Fire Lieutenant/Paramedic $8,153 $97,840 33.5070 630.00 1 26.04 1 N (Assistant Fire Marshal $8,153 $97,840 I 47.0384 1 840.00 127.02 I N 'Fire Captain/Paramedic $8,454 $101,449 I 34.7428 650.00 128.00 E Police Lieutenant $9,033 128.01 E Technical Services Manager $108,394 128.02 E Civilian Service Manager 52.1127 26.05 E Emergency Mgmt. Coordinator 670.00 1 127.04 I E (Battalion Chief/EMS Coordinator 870.00 1 29.01 1 N 'Battalion Chief/Paramedic $9,379 $112,549 54.1101 $9,379 $112,549 38.5442 6 Merit Top I $9,4321 $113,1871 54.41681 $9,7711 $117,2551 40.15591 $9,7711 $117,2551 56.37241 $10,2861 $123,4371 42.27301 $10,5901 $127,0791 61.09571 $10,8991 $130,7921 62.88051 $10,8991 $130,7921 44.79161 4-4 PROPOSED NON-EXEMPT PAY PLAN EFFECTIVE 09-21-2023 Hourly, Monthly and Annual Pay Scales Job GRADE Code FLSA Job Title Min Mid Max 200 I 35.01 1 N 'Firefighter Trainee 210 I 36.03 1 N 'Library Aide 220 37.03 N Library Clerk N Animal Shelter Attendant 230 37.01 37.02 37.05 240 N N N Parks Field Tech I Facility Tech I Public Works Field Tech I $2,729 $2,729 $2,729 $32,742 $32,742 $32,742 15.7414 15.7414 15.7414 $2,677 $3,291 $3,905 $32,119 $39,487 $46,854 15.4418 18.9840 22.5261 $2,865 $3,517 $4,169 $34,383 $42,204 $50,025 16.5303 20.2904 24.0506 $3,023 $3,687 $4,350 $36,277 $44,241 $52,205 17.4410 21.2697 25.0985 38.01 N Police Records Clerk $3,182 $3,903 $4,623 38.03 N Utility Billing Clerk $38,189 $46,830 $55,472 39.00 N Parks Field Tech II 18.3600 22.5146 26.6692 39.01 N Animal Control Officer I 39.04 N Receptionist 39.05 N Facility Tech II 39.06 N Public Works Field Tech II 39.11 N Golf Course Field Tech II 39.12 N Asst. F& B Mgr. 250 39.08 N Court Clerk 40.01 N Animal Control Officer II 40.04 N Office Tech 40.05 N Mechanic I 40.07 N Secretary 42.02 N Recreation Assistant $3,342 $40,100 19.2790 $4,073 $48,877 23.4984 $4,804 $57,653 27.7178 I 260 1 1 N 'OPEN $3,389 $4,152 $4,915 $40,673 $49,825 $58,976 19.5542 23.9541 28.3540 I 270 39.10 42.06 I 42.07 I 280 N N N 41.01 N 43.01 N 43.02 N 43.04 N 43.03 N 43.07 N 43.08 N 43.10 N Juvenile Case Clerk Emr Mgt/Special Proj Assistant HR Specialist - Recruiter $3,661 $4,503 $5,345 $43,926 $54,032 $64,137 21.1185 25.9768 30.8350 Administrative Secretary $3,820 $4,719 $5,619 Administrative Assistant $45,838 $56,633 $67,428 Librarian Assistant 22.0377 27.2274 32.4172 Admin Asst./Analyst Equipment Operator Mechanic II Parks Field Tech III Facility Tech III PROPOSED NON-EXEMPT PAY PLAN EFFECTIVE 09-22-2022 Hourly, Monthly and Annual Pay Scales Job GRADE Code FLSA 280 I 43.11 43.13 43.14 N N N Job Title Min Mid Max Public Works Field Tech III Signal Technician I Payroll Specialist 281 I 41.02 N (Circulation Supervisor $4,019 $4,955 $5,891 $48,230 $59,463 $70,695 23.1877 28.5879 33.9882 290 43.09 N 45.00 N 45.01 N 45.04 N 48.04 N Executive Secretary $4,219 $5,182 $6,146 Inspector I $50,622 $62,187 $73,752 Mechanic III 24.3376 29.8976 35.4575 Crew Leader Signal Tech II 300 43.06 N Animal Control Supervisor 46.04 N Police Records Supervisor 46.08 N Computer Support Specialist 46.09 N Chief Mechanic 46.10 N Municipal Court Supervisor N Signal Tech III 310 1 47.01 I N 'Water Quality Specialist $4,376 $52,513 25.2468 $5,406 $64,872 31.1883 $6,436 $77,230 37.1298 $4,470 $5,482 $6,493 $53,639 $65,779 $77,919 25.7879 31.6244 37.4608 320 I 48.01 N Foreman $4,854 $5,962 $7,069 48.02 N Inspector II $58,251 $71,542 $84,832 48.05 N Eng./PW Technical Specialist 28.0053 34.3950 40.7847 49.00 N Bailiff/Warrant Officer 330 340 I 48.03 50.02 50.03 N (OPEN N N N Computer Support Spec II Inspector III Engineer Technician $5,092 $6,261 $7,430 $61,099 $75,131 $89,163 29.3747 36.1207 42.8666 $5,331 $6,563 $7,795 $63,968 $78,756 $93,544 30.7540 37.8636 44.9731 350 151.02 1 N (Senior Inspector $5,570 $6,863 $8,157 $66,837 $82,358 $97,878 32.1332 39.5951 47.0569 I 360 I N (OPEN $5,847 $7,185 $8,523 $70,163 $86,221 $102,279 33.7321 41.4524 49.1728 PROPOSED EXEMPT PAY PLAN EFFECTIVE 09-21-2023 Hourly, Monthly and Annual Pay Scales Job GRADE Code FLSA Job Title Min Mid Max 295 143.04 E Asst. Golf Superintendent 143.11 E First Asst. Golf Pro 305 $4,185 $5,137 $6,089 $50,219 $61,642 $73,064 24.1440 29.6354 35.1268 146.11 E Seniors Coordinator $4,334 $5,354 $6,375 146.12 E Recreation Specialist -Aquatics $52,012 $64,254 $76,496 146.13 E Program Rec. Specialists 25.0058 30.8913 36.7768 146.14 E Athletic Coordinator 146.15 E Recreation Specialist -Analyst 146.16 E Special Events Coordinator 146.18 E Human Resources Generalist I 315 E OPEN 325 335 345 145.03 E 146.10 E 148.00 E 148.02 E 149.09 E 149.10 E $4,572 $5,606 $6,641 $54,860 $67,276 $79,693 26.3751 32.3444 38.3137 Accountant I $4,807 $5,905 $7,002 Recreation Center Supervisor $57,688 $70,857 $84,027 Librarian 27.7347 34.0661 40.3975 Library Services Supervisor Senior Center Supervisor Aquatics Supervisor 152.01 E Recreation Superintendent 143.16 E Conference Centre Manager 149.01 E Human Resources Generalist II 149.02 E Food and Beverage Manager 149.03 E Kitchen Manager/Chef 149.08 E Facilities Supervisor 150.06 E Assistant to the City Secretary 154.02 E Park Superintendent 150.03 1 E (Senior Librarian 355 149.04 150.00 151.00 E E E Deputy City Secretary Accountant II Web Designer $5,045 $60,537 29.1041 $6,203 $74,435 35.7862 $7,361 $88,334 42.4683 $5,280 $6,500 $7,720 $63,364 $78,005 $92,645 30.4636 37.5023 44.5409 $5,518 $6,799 $8,079 $66,213 $81,582 $96,952 31.8331 39.2223 46.6115 365 I 1 E (OPEN $5,791 $7,117 $8,442 $69,497 $85,404 $101,310 33.4121 41.0594 48.7067 375 I 145.07 E Internal Auditor $6,081 $7,473 $8,865 153.00 E GIS Manager $72,970 $89,673 $106,375 153.08 E Network Manager 35.0817 43.1119 51.1421 150.05 E Controller 4-7 Job GRADE Code 385 PROPOSED EXEMPT PAY PLAN EFFECTIVE 09-21-2023 Hourly, Monthly and Annual Pay Scales FLSA Job Title Min Mid Max 149.09 E Communications/Mktg Manager 150.07 E Budget/Treasury Manager 154.08 E Accounting Manager 151.01 E Purchasing Manager 154.03 E SBW/PATS General Manager 154.11 E Billing Manager 154.12 E Building Official 154.14 E Parks Manager 154.16 E Senior City Planner 154.17 E Benefits Manager 154.18 E Risk Manager 154.19 E Public Works Manager 405 1 155.01 1 E (Civil Engineer $6,386 $76,628 36.8405 $7,847 $94,165 45.2718 $9,309 1 $111,702 1 53.7031 1 $7,041 $8,652 $10,263 $84,487 $103,824 $123,162 40.6187 49.9155 59.2123 410 I 156.01 I E (Senior Computer Developer $7,216 $8,868 $10,520 $86,597 $106,418 $126,240 41.6330 51.1625 60.6921 415 1 157.04 E Senior Civil Engineer E Financial Services Manager $7,392 $9,084 $10,776 $88,705 $109,011 $129,318 42.6465 52.4093 62.1720 4-8 MEDICAL/RX Employee Only Employee + Children Employee + Spouse Employee + Family DENTAL Employee Only Employee + Children Employee + Spouse Employee + Family Total Premium Employee Only Employee + Children Employee + Spouse Employee + Family City of Euless 2023-24 Proposed Employee Insurance Premiums Per Month 2022-23 Actual $172.66 $366.90 $453.23 $582.72 2022-23 Actual $9.64 $18.30 $22.14 $27.94 2022-23 Actual $182.30 $385.20 $475.37 $610.66 2023-24 Proposed $175.24 $372.36 $459.98 $591.40 2023-24 Proposed $9.77 $18.53 $22.43 $28.30 2023-24 Proposed $185.01 $390.89 $482.41 $619.70 Increase / Decrease $2.58 $5.46 $6.75 $8.68 Increase / Decrease $0.13 $0.23 $0.29 $0.36 Increase / Decrease $2.71 $5.69 $7.04 $9.04 4-9 Insurance & Benefits FY2023-24 FY2024 Proposed Revenues: City Contribution For Employees and Dependents $ 6,814,270 Employee Contribution Employee/Retiree Contribution $ 1,863,488 Interest Income $ 68,008 Total Operating Revenues $ 8,745,766 FY2024 Proposed Expenses: Operating Expenses Operations $ 227,173 Claims $ 5,394,672 Prescription Claims $ 771,180 Re -Insurance Fee $ 1,161,879 Insurance Services $ 191,383 Wellness Programs $ 5,000 OPEB Trust Contribution $ 730,800 Total Operating Expenses $ 8,482,087 Capital / One -Time Expenses Capital / One -Time $ 44,000 Total Capital / One -Time Expenses $ 44,000 FY2024 Proposed Budget $ 8,526,087 Reserves - Health FY2015 $ 3,322,129 FY2016 $ 2,767,051 FY2017 $ 2,492,157 FY2018 $ 3,947,017 FY2019 $ 4,657,309 FY2020 $ 5,680,312 FY2021 $ 5,772,173 FY2022 $ 5,917,105 FY2023 (estimated) $ 5,951,848 FY2024 (projected) $ 6,171,527 4-10 Risk Management & Workers' Comp FY2023-24 FY2024 Proposed Revenues: Transfers General $ 450,000 Water & Wastewater $ 450,000 Interest Income $ 70,419 Charges Workers' Comp Employee Assistance $ 528,000 $ 10,067 Total Operating Revenues $ 1,508,486 FY2024 Proposed Expenses: Operating Expenses Risk Management Worker's Compensation $ 997,044 $ 451,298 Total Operating Expenses $ 1,448,342 Capital / One -Time Expenses Capital / One -Time Expenses $ Total Capital / One -Time Expenses $ FY2024 Proposed Budget $ 1,448,342 Reserves FY2015 $ 1,378,778 FY2016 $ 1,992,931 FY2017 $ 2,116,376 FY2018 $ 2,187,793 FY2019 $ 1,949,186 FY2020 $ 2,161,658 FY2021 $ 2,122,598 FY2022 $ 2,245,184 FY2023 (estimated) $ 2,396,676 FY2024 (projected) $ 2,456,820 4-11 HISTORICAL & COMPARISON DATA Monthly Service Charges & Key Fiscal Points Population Growth in Euless General Fund Multi -Year Analysis General Fund Revenue Assumptions Property Tax Revenues Tax Rate & Exemptions Comparisons Tax Rate Impact Water/ Wastewater Fund Revenue Assumptions Utility Rate History Sanitation and Recycling Comparison of Service Rates Drainage Utility Charge Comparison Comparative Rates, Water & Wastewater -Other Cities Impact of Water & Wastewater Rate Increase Utility Bill Comparison Residential Monthly Service Charges Water Wastewater Trash Drainage Recycling FY24 $14.75 Base $13.00+90% of metered water *$2.07 per home Prop Tiered Rates/tgals usage @ $4.99 per tgals. $11.06* $3.00 $4.38 per home -cart 0-2 tgals - $5.35 $1.26 per apt. unit 3-8 tgals - $6.28 $1.04 for Seniors 9-15 tgals - $6.85 $3.35 for Seniors home- 16-35 tgals - $7.38 cart Over 35 tgals - $7.98 FY23 $13.75 Base $12.00+90% of metered water Tiered Rates/tgals usage @ $4.53 per tgals. 0-2 tgals - $4.77 3-8 tgals - $5.70 9-15 tgals - $6.27 16-35 tgals - $6.80 Over 35 tgals - $7.40 FY22 $12.75 Base $11.00+90% of metered water Tiered Rates/tgals usage @ $4.34 per tgals. 0-2 tgals - $4.21 3-8 tgals - $5.14 9-15 tgals - $5.71 16-35 tgals - $6.24 Over 35 tgals - $6.84 *Effective through March 31, 2024. $11.06 $3.00 General Fund Key Fiscal Points $10.74 $3.00 $2.07 per home $4.38 per home -cart $1.26 per apt. unit $1.04 for Seniors $3.35 for Seniors home - cart $1.54 per home $3.27 per home -cart $1.10 per apt. unit $.77 for Seniors $2.50 for Seniors home - cart Proposed % Change Budget % Change Actual FY24 FY23 FY22 Operating Expenses $52,245,458 5.1% $49,693,014 14.51% $43,393,083 Capital/One-Time Exp. $ 8,285,424 -6.8% $ 8,891,334 148.5% $ 3,573,884 Tax Rate^ .4600 per $100 0% .4600 per $100 3.2% .47500 per $100 Debt = .088912 Debt = .089153 Debt = .072112 M&O = .371088 M&O = .370847 M&O = .402888 Taxable Valuation^ $6,331,650,731 5.5% $6,001,564,674 13.1% $5,306,690,383 Debt Rating: Moody's S&P G.O. =Aa2 G.O. = Aa2 W&S = Aa2 W&S = Aa2 Drainage = Al Drainage = Al Sales Tax = Al Sales Tax = Al G.O. = Aa2 W&S = Aa2 Drainage = Al Sales Tax = Al G.O.=AA G.O.=AA G.O.=AA W&S=AA+ W&S=AA+ W&S=AA+ Drainage = AA+ Drainage = AA+ Drainage = AA+ ^ Early estimate for FY24. Will be revised after Tarrant Appraisal District Certification on July 25, 2023. 5-1 63,000 62,000 61,000 60,000 59,000 58,000 57,000 56,000 55,000 54,000 53,000 52,000 51,000 53,780 s 54,050 ■ POPULATION 54,870 54,250 55,170 56,160 58,26 57,550 61,480 61,544 a O�� Ot\h Oi\O O�� OHO OHO O0O 00'� 00� O0O r� ti *2015 Population Estimates based on census data. Population for non -census years calculated by North Central Texas Council of Governments. 5-2 Revenues In Millions $60.0 $50.0 $40.0 $30.0 $20.0 $10.0 $0.0 General Fund Multi -Year Analysis FY2020 FY2021 FY2022 FY2023 BUD FY2023 EST ■ Property Taxes ■ Franchise Fees ❑ Sales & Use Taxes ❑ Fines & Fees ❑ Licenses & Permits ■ Interest Income FY2024 PROP • Int'gov't./Trans./Misc. REVENUE ACTUAL ACTUAL ACTUAL BUDGETED ESTIMATED PROPOSED SOURCE FY2020 FY2021 FY2022 FY2023 FY2023 FY2024 Property Taxes $17,149,229 $18,192,851 $19,378,217 $19,869,934 $19,941,616 $20,864,647 Franchise Fees $4,134,434 $4,131,593 $4,398,362 $4,235,114 $4,392,172 $4,518,907 Sales & Use Taxes $13,599,827 $15,001,072 $17,699,437 $16,912,679 $18,193,512 $17,517,080 Fines & Fees $2,924,661 $3,066,447 $4,051,723 $3,542,328 $3,551,147 $3,864,153 Licenses & Permits $1,697,638 $1,578,146 $1,149,320 $642,900 $1,059,029 $664,029 Interest Income $263,648 $62,639 $126,233 $38,402 $246,631 $112,404 Int'gov't./Trans./Misc. $4,576,495 $3,362,265 $4,483,350 $4,522,591 $4,792,904 $4,774,201 TOTAL REVENUES $44,345,932 $45,395,013 $51,286,642 $49,763,948 $52,177,011 $52,315,421 Property Taxes Franchise Fees Sales & Use Taxes Fines & Fees Licenses & Permits Interest Income I nt'gov't./Trans./Misc. TOTAL 38.67% 40.08% 37.78% 39.93% 38.22% 39.88% 9.32% 9.10% 8.58% 8.51 % 8.42% 8.64% 30.67% 33.05% 34.51% 33.99% 34.86% 33.48% 6.60% 6.75% 7.90% 7.12% 6.81% 7.39% 3.83% 3.47% 2.24% 1.29% 2.03% 1.27% 0.59% 0.14% 0.25% 0.08% 0.47% 0.21% 10.32% 7.41% 8.74% 9.08% 9.19% 9.13% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% FY23 Budget to FY24 Proposed % Diff 5.01% 6.70% 3.57% 9.09% 3.29% 192.70% 5.56% 5.13% 39.09% 8.76% 33.43% 7.10% 2.36% 0.29% 8.98% 100.00% The graph and chart above depicts the five year trend for revenues which support services and operations accounted for in the General Fund. While indicating which revenue sources have experienced an increase or decrease, the chart indicates what percentage of the total revenue stream a source constitutes. While growth in sales tax revenue helps to reduce the dependency on property taxes, sales taxes are more volatile in nature, and therefore are subject to sharp declines in slower economic periods. The trend now shows property tax to be the largest source of revenues averaging 39.09% of the total. Sales and use taxes is the second highest source on average at 33.43% and Intergovernmental/Transfers/Misc third at 8.98%. Franchise Fees make up approximately 8.76% and fines & fees about 7.10% of total revenues with other sources varying from less than 1% to a little under 3%. 5-3 General Fund FY2024 Revenue Assumptions Revenue Source Property Taxes Prior Year Property Taxes Penalties & Interest Sales Tax Additional Sales Tax Mixed Drink Tax Electric Franchise Gas Franchise Telephone Access Line Fees Sanitation Services Franchise Recycling Franchise Cable Franchise Water & Wastewater Franchise Other Permits Health Permits Fire Permits Contractors Regulatory License Minimum Housing Miscellaneous Permits and Fees Building Permits Police Program Reimbursements School Police Reimbursements Municipal Court Library Fees Ambulance Fees Alarm Revenue Jail Revenue Interest Income Miscellaneous Tower Lease Revenue Betterment Contributions Transfers Assumptions Projection based on revenues to cover needed expenses. Projected to remain flat with FY23 budget. Projected decrease from FY23 budget based on trend. Projected increase from FY23 budget due continued business development. Increase based on 25% of projected sales tax revenues without TIRZ allocation. Projected to increase with economic outlook and historic trend. Projection for a slight increase based on historic trend and increasing rates. Projected increase from FY23 budget based on historic trends. Projected to decrease from FY23 budget based on historic trends. Projected increase from FY23 budget based on approved rates. Projected increase from FY23 budget based on approved rates. Projected decrease from estimated FY23 budget based on historic trends. Based on 5°/0 of projected gross receipts. Projected slight decrease based on historical trend. Projected to remain flat with FY23 budget. Projected to decrease based on historic trend. Projected slight increase from FY23 budget based on historic trend. Projected to increase from FY23 budget based on historic trend. Projected to increase slightly from FY23 budget based on historic trend. Projected to remain flat with FY23 budget. Auto Theft Task Force projected to remain flat with FY23 budget. Increased current contract from four to five patrol officers for FY24. Projected to increase from FY23 budget based on recent trend. Projected slight increase from FY23 budget based on historic trend. Projected an increase from FY23 budget based on historic trends. Projected a slight increase from FY23 estimates. Based continuation of interlocal shared services agreement. Projected to increase from FY23 budget based on market outlook and Federal Funds Rate. Projected slight increase with FY23 budget. Based on current lease agreements. Projected to remain flat with FY23 budget. Based on administrative fees charged to utility operations and 1/3 of Euless' portion of the Car Rental Tax. 5-4 Adj. Net Taxable Value Assessed TIF Increment Value Proposed Tax Rate per $100 Valuation Estimated Tax Levy TIF Distribution Est. Percent of Collection (O&M and I&S) General Fund Collections Ceiling Revenues Estimated Fund Collections Operating & Maintenance - General Fund Interest and Sinking - Debt Service Fund TOTAL Cents Per $100 Valuation 0.500000 0.450000 0.400000 0.350000 0.300000 0.250000 0.200000 0.150000 0.100000 0.050000 0.000000 PROPERTY TAXES Estimated Revenues FY24* Operating & Maintenance $5,350,124,766 $399,472,055 0.371088 $21, 336,055 $1,464,349 98.00% $19,474,272 $1, 300,375 $20,774,647 Debt Service $5,350,124,766 0.088912 $4,756,911 100.00% $311,568 $5,068,479 Proposed Fund Distribution Rate 0.371088 0.088912 0.460000 Percent 80.67% 19.33% 100.00% Ten Year Breakdown of Tax Rate $ Amount $20,774,647 $5,068,479 $25,843,126 Additional Sales Tax $ 3,543,926 $ $ - $ $ 3,543,926 $ Total 24, 318, 573 5,068,479 29, 387, 052 2015 2016 2017 Fiscal Year 2015 2016 2017 2018 2019 2020 2021 2022 2023 Proposed 2024* 2018 2019 2020 2021 2022 2023 P oposed 2024* I u Interest & Sinking ■Operating & Maintenance' Operating & Interest & Total Maintenance Sinking Tax Rate 0.364505 0.102995 0.467500 0.366571 0.100929 0.467500 0.363053 0.099447 0.462500 0.361056 0.101444 0.462500 0.371710 0.090790 0.462500 0.377974 0.084526 0.462500 0.381954 0.080546 0.462500 0.402888 0.072112 0.475000 0.370847 0.089153 0.460000 0.371088 0.088912 0.460000 *Early estimate for FY24. Will be revised after Tarrant Appraisal District Certification on July 25, 2023. 5-5 •% 1 /I (-el-I- TAX RATE & EXEMPTIONS COMPARISONS OF TAX RATES SENIOR TAX WITH TAX WITH TAXES ON TAXES ON CITY CURRENT HOMESTEAD CITIZEN HOMESTEAD SEN. CITIZEN AVERAGE AVERAGE AVERAGE TAX RATE EXEMPTION EXEMPTION EXEMPTION ON EXEMPTION ON HOME VALUE HOME VALUE HOME VALUE $287,000 (A) $269,624(B) 7/21/2022 SEN. CITIZENS BEDFORD (c) 0.4957 0% $50,000 $1,423 $1,089 $303,277 $1,503 $1,256 HURST 0.6140 20% $35,000 $1,410 $1,110 $270,281 $1,328 $1,113 N.R. HILLS 0.5480 20% $36,000 $1,258 $985 $316,532 $1,388 $1,190 GRAPEVINE 0.2718 20% $75,000 $624 $382 $436,636 $949 $746 COLLEYVILLE (c) 0.2656 0% $65,000 $762 $544 $738,310 $1,961 $1,788 AVERAGE 0.4390 12% $52,200 $1,095 $822 $413,007 $1,596 $1,366 EULESS (proposed)* 0.4600 20% $35,000 $1,056 $831 $287,000 $1,056 $895 NOTES: (A) Euless' average home value as of July 2022. Will be revised after Tarrant Appraisal District Certification on July 25, 2023. (B) Average home value of senior citizen property in the City of Euless as of July 2022. Will be revised after Tarrant Appraisal District Certification on July 25, 2023. (C) Bedford & Colleyville have no homestead exemption. SOURCE: Tarrant Appraisal District Website * Early estimate for FY24. Will be revised after Tarrant Appraisal District Certification on July 25, 2023. 5-6 TAX RATE IMPACT Tax Rate Based on $100,000 Taxable Value Less: Homestead Exemption, 20% Adjusted Value Annual Tax Burden: (at above tax rates) or monthly Over 65 - Based on $100,000 Taxable Value Less: Homestead Exemption, 20% Adjusted Value Less: Over 65 Exemption Net Value Annual Tax Burden: (at above tax rates) or monthly Average Home Value - Annual Tax Over 65 Average Home Value* - Annual Tax FY2022-23 FY2023-24 Budgeted Proposed^ @ 46¢ @ 46¢ $100,000 $20,000 $80,000 $368.00 $30.67 $100,000 $20.000 $80,000 $35.000 $45,000 $207.00 $17.25 $100,000 $20.000 $80,000 $368.00 $30.67 $100,000 $20.000 $80,000 $35.000 $45,000 $207.00 $17.25 $287,000 $287,000 $1,056.16 $1,056.16 $269,624 $269,624 $831.22 $831.22 * Euless has adopted the senior tax freeze. Seniors citizens pay no more than they paid @ age 65 regardless of home value excluding improvements. - Home Values are based on average home values provided by Tarrant Appraisal District as of July each year. Both values shown here are from July 25, 2022. Values will be revised after Tarrant Appraisal District Certification on July 25, 2023. ^ Early estimate for FY24. Will be revised after Tarrant Appraisal District Certification on July 25, 2023. 5-7 Revenue Source Interest Income Sanitation Services Water Service Wastewater Service Reclaimed Water Service Sale of New Meters Reconnect Fees Inspection Fees Miscellaneous Penalties Initiation & Transfer Fees Recycling Fees Water & Wastewater Fund FY24 Revenue Assumptions Assumptions Projected to increase based on market outlook and investable balances. Projected to remain flat with FY23 budget. Consumption is estimated to increase slightly with FY23 year- end projections based on expected growth. Volume rates increased by 58¢ per 1,000 gallons and the residential base rates increased by $1 or 7.3% for FY24. Anticipated treatment volume is estimated remain almost flat with FY23 budgeted volume. Volume rates increased by 46¢ per 1,000 gallons and base rates increased by $1 for FY24. Consumption is relatively flat with that of the prior fiscal year's estimates. Rates per tier are based on 85% of the potable water rate per tier. Projected to remain flat with FY23 budget. Projected to remain flat with FY23 budget. Projected to remain flat with FY23 budget. Projected to remain flat with FY23 budget. Projected to remain flat with FY23 budget. Projected to remain flat with FY23budget. Increase anticipated from growth in customer base as compared with prior year estimates and scheduled rate increase. 5-8 Year CITY OF EULESS RESIDENTIAL UTILITY RATE HISTORY WATER Base Rate 0-2 Tgals 3-8 Tgals 9-15 Tgals 16-35 Tgals >35 Tgals FY15 $8.95 $2.97 $3.90 $4.47 $5.00 $5.60 FY16 $9.75 $3.24 $4.17 $4.74 $5.27 $5.87 FY17 $10.75 $3.44 $4.37 $4.94 $5.47 $6.07 FY18 $11.75 $3.58 $4.51 $5.08 $5.61 $6.21 FY19 $12.50 $3.88 $4.81 $5.38 $5.91 $6.51 FY20 $12.75 $4.07 $5.00 $5.57 $6.10 $6.70 FY21 $12.75 $4.21 $5.14 $5.71 $6.24 $6.84 FY22 $12.75 $4.21 $5.14 $5.71 $6.24 $6.84 FY23 $13.75 $4.77 $5.70 $6.27 $6.80 $7.40 FY24 Proposed $14.75 $5.35 $6.28 $6.85 $7.38 $7.98 WASTEWATER DRAINAGE FEE 90% of Metered Lot Less Year Base Rate Water Year Than 5 Acres FY15 $7.75 $3.33 FY15 $2.50 FY16 $8.50 $3.59 FY16 $2.50 FY17 $9.50 $3.72 FY17 $2.50 FY18 $10.50 $3.98 FY18 $2.75 FY19 $10.75 $4.27 FY19 $2.75 FY20 $11.00 $4.29 FY20 $2.75 FY21 $11.00 $4.34 FY21 $2.75 FY22 $11.00 $4.34 FY22 $3.00 FY23 $12.00 $4.53 FY23 $3.00 FY24 Proposed $13.00 $4.99 FY24 Proposed $3.00 5-9 CITY SANITATION AND RECYCLING COMPARISON OF SERVICE AND RATES SINGLE BAGS FAMILY COST OF OR BULK COST OF CUSTOMERS SANITATION* CANS PICKUP RECYCLING* BEDFORD 13,543 $10.02 Either 2 days/wk. $4.71 GRAPEVINE 12,404 $16.91 Either Bi-Weekly Included N . R. HILLS 20,868 $18.47 Either 2 days/wk. Included COLLEYVILLE 9,418 $20.22 Either 2 days/wk. Included HURST 11,003 $9.31 Either 2 days/wk. $4.60 AVERAGE 13,447 $14.99 $4.66 EULESS 13,027 $11.06 Either 2 days/wk. $2.07 * Rates as of June 2023 5-10 DRAINAGE UTILITY CHARGE RESIDENTIAL MONTHLY RATE COMPARISON - Bedford Grapevine * North Richland Hills Colleyville Hurst $4.50 $4.00 $6.31 (maximum) $7.00 $4.00 AVERAGE $5.16 Euless -Rates as of June 2023 North Richland Hills base charge on lot size. $3.00 COMMERCIAL MONTHLY RATE COMPARISON^ Bedford Grapevine North Richland Hills Colleyville Hurst $71.88 $24.50 $28.25 $24.40 $51.84 AVERAGE $40.17 Euless $22.72 Commercial Rates are based on 1 impervious acre. ^This comparison shows a generalized rate. Please see individual City Ordinances for actual amount and runoff coefficient reductions. 5-11 COMPARATIVE RATES WAT E R MINIMUM WATER 3,000 8,000 12,000 15,000 20,000 CITY BILL RATE GALLONS GALLONS GALLONS GALLONS GALLONS BEDFORD - NON -SENIOR $20.70 4.87/ gals $35.31 $59.66 $79.14 $93.75 $118.10 SENIOR $18.81 4.87/ gals $33.42 $57.77 $77.25 $91.86 $116.21 GRAPEVINE' $15.78 4.43/>2 gals $20.21 $42.36 $60.08 $73.37 $95.52 N. R. HILLS' $17.50 4.65tgal/ from 2-22.44 gals $31.72 $70.92 $102.28 $125.80 $165.00 4.74 tgal > 22.44 gals plus 3.19/tgal pass thru rate COLLEYVILLE $14.83 4.96/gals $29.71 $54.51 $74.35 $89.23 $114.03 HURST $18.78 7.54/>2 gals $26.32 $64.02 $94.18 $116.80 $154.50 AVERAGE $17.52 5.93/gals $28.65 $58.29 $82.01 $99.79 $129.43 EULESS proposed $14.75 5.35 / 0-2 gals $31.73 $63.13 $90.53 $111.08 $147.98 6.28 / 3-8 gals 6.85 / 9-15 gals 7.38 / 16-35 gals 7.98/ > 35 gals EULESS proposed w/rebate $14.75 $30.23 $59.13 $84.53 $103.58 $140.48 'Minimum bill includes first 2,000 gallons of usage. Rates as of October 2022. WASTEWATER WATER CONSUMPTION MINIMUM WASTEWATER 3,000 8,000 12,000 15,000 20,000 CITY BILL RATE GALLONS GALLONS GALLONS GALLONS GALLONS BEDFORD - NON -SENIOR $13.84 3.72/gals $25.00 $43.60 $58.48 $69.64 $88.24 SENIOR $12.56 3.72/gals $23.72 $42.32 $57.20 $68.36 $86.96 GRAPEVINE2 $10.55 4.41/> 2 gals $14.96 $37.01 $54.65 $67.88 $67.88 N. R. HILLS3 $11.00 4.65/gals $24.95 $48.20 $66.80 $80.75 $97.96 COLLEYVILLE $13.30 3.26/gals $23.08 $39.38 $52.42 $62.20 $78.50 HURST $13.59 4.36/gals $26.67 $48.47 $65.91 $78.99 $100.79 AVERAGE $12.46 4.08/gals $22.93 $43.33 $59.65 $71.89 $86.67 EULESS' proposed $13.00 4.99/gals $26.47 $48.93 $66.89 $72.88 $72.88 'Wastewater charge is based on 90% of metered water and shall not exceed 12,000 gallons of wastewater treated. 2Capped at 15,000 gallons. 3Capped at 2,500 cf or 18,700 gallons. Rates as of October 2022. 5-12 Impact of Water Rate Increase Impact of 5¢ increase on all tiers: Impact of 10¢ increase on all tiers: To City: Additional revenues generated To City: Additional revenues generated Increase Estimated Volume* Revenue Increase Estimated Volume* Revenue 05¢ 2,168,118 $ 108,406 10¢ 2,168,118 $ 216,812 To Citizens: Estimated Increase To Citizens: Estimated Increase Monthly $ 0.33 Monthly $ 0.66 Annually $ 3.94 Annually $ 7.87 Impact of 15¢ increase on all tiers: Impact of 20¢ increase on all tiers: To City: Additional revenues generated To City: Additional revenues generated Increase Estimated Volume* Revenue Increase Estimated Volume* Revenue 15¢ 2,168,118 $ 325,218 20¢ 2,168,118 $ 433,624 To Citizens: Estimated Increase Monthly $ 0.98 Annually $ 11.81 * amounts shown in thousands of gallons Calculations based on 27,548 water customers To Citizens: Estimated Increase Monthly $ 1.31 Annually $ 15.74 Impact of Wastewater Rate Increase Impact of 5¢ increase on rate: Impact of 10¢ increase on rate: To City: Additional revenues generated To City: Additional revenues generated Increase Estimated Volume* Revenue Increase Estimated Volume* Revenue 05¢ 1,582,726 $ 79,136 10¢ 1,582,726 $ 158,273 To Citizens: Estimated Increase To Citizens: Estimated Increase Monthly $ 0.24 Monthly $ 0.48 Annually $ 2.90 Annually $ 5.80 Impact of 15¢ increase on rate: Impact of 20¢ increase on rate: To City: Additional revenues generated To City: Additional revenues generated Increase Estimated Volume* Revenue Increase Estimated Volume* Revenue 15¢ 1,582,726 $ 237,409 20¢ 1,582,726 $ 316,545 To Citizens: Estimated Increase Monthly $ 0.73 Annually $ 8.70 * amounts shown in thousands of gallons Calculations based on 27,289 wastewater customers To Citizens: Estimated Increase Monthly $ 0.97 Annually $ 11.60 5-13 Utility Bill Comparison CITY WATER WASTEWATER DRAINAGE SANITATION RECYCLING TOTAL (8 tgals) (8 tgals) BILL BEDFORD $59.66 $43.60 $4.50 $10.02 $4.71 $122.49 GRAPEVINE $42.36 $37.01 $4.00 $16.91 INCLUDED $100.28 N . R. HILLS $70.92 $48.20 $6.31 $18.47 INCLUDED $143.90 COLLEYVILLE $54.51 $39.38 $7.00 $20.22 INCLUDED $121.11 HURST $64.02 $48.47 $4.00 $9.31 $4.60 $130.40 AVERAGE $58.29 $43.33 $5.16 $14.99 $4.66 $126.43 EULESS proposed w/ rebate $59.13 $48.93 $3.00 $11.06 $2.07 $124.19 All comparison cities are based on current year rates. 5-14