The URL can be used to link to this page

Home My WebLink AboutPreliminary Operating Budget FY20-21City of Euless 5 Preliminary Annual Operating Budget Fiscal Year Ending September 30, 2021 201 N. Ector Drive, Euless, TX 76039 www.eulesstx.gov CITY OF EULESS FISCAL YEAR 2020-2021 Council Members LINDA MARTIN, MAYOR Tim Stinneford, Place One Jeremy Tompkins, Mayor Pro Tem, Place Two Eddie Price, Place Three Perry Bynum, Place Four Harry Zimmer, Place Five Salman Bhojani, Place Six Loretta Getchell, City Manager �` Chris Barker, Deputy City Manager City of Euless, Texas Fiscal Year 2020-2021 Budget Cover Page July 28, 2020 This budget will raise more revenue from property taxes than last year's budget by an amount of $698,058, which is a 3.27 percent increase from last year's budget. The property tax revenue to be raised from new property added to the tax roll this year is $311,456. TABLE OF CONTENTS PROPOSED BUDGET TITLE PAGE BUDGET MESSAGE Letter...........................................................................................................................................................................1 ExecutiveSummary, 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 WhereDoes the Money Go? ............................................................................................................................19 GeneralFund Revenues .................................................................................................................................... 20 TaxRate Scenarios............................................................................................................................................. 21 GeneralFund Expenditures............................................................................................................................ 22 Water& Wastewater Revenues.................................................................................................................... ProposedWater 23 Service Rates...................................................................................................................... 24 Proposed Wastewater Service Rates.......................................................................................................... 25 Water& Wastewater Expenditures............................................................................................................ 26 All Other Enterprise Operating Funds....................................................................................................... 27 SpecialRevenue Operating Funds........................................................................................................ 28-29 Internal Service Operating Funds................................................................................................................ 30 DebtService Operating Funds....................................................................................................................... 31 PersonnelCounts................................................................................................................................................32 BOND INDEBTEDNESS Schedule of Outstanding and Proposed Indebtedness........................................................................ 33 CAPITAL EXPENSES & FUNDING Capital & Supplemental Requests by Fund.............................................................................................. 34 REQUIREDDISCLOSURE.............................................................................................................................................. 35 L� SUPPLEMENTARY INFORMATION INTRODUCTION...................................................................................................................................................TAB 1 OrganizationalChart.......................................................................................................................................1-1 BudgetProcess........................................................................................................................................I.....I.....1-2 BudgetSchedule.................................................................................................................................................1-5 Excerptfrom Charter.......................................................................................................................................1-6 FiscalPolicies......................................................................................................................................................1-8 CAPITAL, INFRASTRUCTURE PLANS & FLEET................................................................................................ TAB 2 Capital & Supplemental Requests by Fund.............................................................................................2-1 Capital & Supplemental Requests by Department..............................................................................2-2 FY2020-21 Infrastructure Plan...................................................................................................................2-3 Memo, Projected Equipment Replacement Fund.................................................................................2-4 Fleetand Equipment Transfers...................................................................................................................2-5 ProposedUnit Replacements........................................................................................................................2-7 DEBT....................................................................................................................................................................TAB 3 Schedule of Outstanding and Proposed Indebtedness.......................................................................3-1 AnnualDebt Service.........................................................................................................................................3-2 TotalGeneral Obligation Debt.....................................................................................................................3-3 Tax -Supported General Obligation Debt.................................................................................................3-4 TIRZ/PID Supported General Obligation Debt..................................................................................3-12 Taxable(Self -Supporting) G.0 Debt.......................................................................................................3-18 GolfG.O. Refunding Debt.............................................................................................................................3-20 Water& Wastewater Revenue Debt....................................................................................................... 3-22 SalesTax Revenue Debt............................................................................................................................... 3-29 PERSONNEL& INSURANCE...............................................................................................................................TAB 4 PersonnelCounts...............................................................................................................................................4-1 PersonnelCounts by Fund..............................................................................................................................4-2 ProposedPay Plan.............................................................................................................................................4-3 ProposedInsurance Premiums....................................................................................................................4-9 InsuranceFinancial Report ...................... .................................................................................................. 4-10 Workers' Compensation/Risk Management Financial Report ................................................... 4-11 COMPARISON& HISTORICAL............................................................................................................................TAB 5 Monthly Service Charges & Key Fiscal Points........................................................................................5-1 PopulationGrowth in Euless.........................................................................................................................5-2 GeneralFund Multi -Year Analysis..............................................................................................................5-3 General Fund Revenue Assumptions.........................................................................................................5-4 PropertyTax Revenues....................................................................................................................................5-5 Tax Rate & Exemptions Comparisons.......................................................................................................5-6 TaxRateImpact.................................................................................................................................................5-7 Water/Wastewater Fund Revenue Assumptions...............................................................................5-8 UtilityRate 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 UtilityBill Comparison.................................................................................................................................5-14 T H E C I T Y O F EULESS July 28, 2020 Honorable Mayor Linda Martin Honorable City Councilmembers: Tim Stinneford, Place One Jeremy Tompkins, Place Two, Mayor Pro Tem Eddie Price, Place Three Perry Bynum, Place Four Harry Zimmer, Place Five Salman Bhojani, Place Six INTRODUCTION As required by the City of Euless' Home Rule Charter, the operating budget for the fiscal year beginning October 1, 2020 and ending September 30, 2021 is submitted for your review. This budget document has been condensed in an effort to make it more user friendly and to eliminate duplicate information available in other formats. It continues to include all required data per the City's Charter and supplementary information. We hope our citizens will find this document easier to navigate. This document supersedes the version submitted on July 24, 2020 and has been updated based on certified tax values received from the Tarrant Appraisal District. 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. BUDGET HIGHLIGHTS This budget was developed with an unprecedented amount of uncertainty caused by the COVID-19 global pandemic. We have reviewed all programs and services offered by the City and have made adjustments as necessary to address safety concerns and to identify cost savings to offset the economic impact of the pandemic. Highlights of the proposed budget are detailed below: 201 N. Ector Drive, Euless, Texas 76039-3595 817/685-1400 Metro 817/267-4403 Fax 817/685-1416 www.eulesstx.gov 1 ♦ The property tax rate for the upcoming fiscal year is proposed to remain at 46.250 per $100 of assessed valuation. ♦ Significant reductions are projected in sales tax, car rental tax, hotel/motel occupancy tax, and interest income. ♦ Hours of operations at some City facilities have been reduced. ♦ Departmental cuts have been made within all areas with an emphasis on maintaining funding for public safety. ♦ Two positions have been eliminated and twelve vacant positions have been frozen until economic conditions improve. ♦ The pay plans for non-public safety employees have been reduced approximately 10% and steps for newly hired non-exempt employees have been eliminated. Public safety employees and existing non-exempt employees will continue to receive step increases as previously committed. Baseline salary increases have not been included in the budget; however one-time lump sum payments will be considered should economic conditions improve. ♦ The water rate includes an increase to the volume charge of 140 per thousand gallons. The recommended volume charge covers the pass -through increase from Trinity River Authority (TRA) in the City's cost to purchase water. ♦ A 300 per thousand gallons rate stabilization rebate has been included for residential water customers for the first 15,000 gallons per month. ♦ The wastewater rate includes a 5¢ increase per thousand gallons, which covers the pass -through increase from TRA for the collection and treatment of the wastewater. ♦ The Water and Wastewater Operating Fund includes transfers to Capital Improvement Programs (CIP) to cash flow system infrastructure improvements including water and wastewater line replacements. The annual commitment for line replacement continues at $1,075,000. ♦ Funding for annual street improvements was eliminated from the baseline budget in order to offset revenue shortfalls. However, we are recommending that excess reserves in the amount of $1,000,000 be transferred to the Capital Projects Fund to ensure the City's street infrastructure is adequately maintained. Restoration of this item to the City's baseline is a top priority. ♦ Transfers to the Equipment Replacement Fund to cover vehicle, mobile equipment, and most equipment and furnishing replacements have been included in the baseline funding of all funds except the General Fund and the Texas Star Golf Course Fund. Revenues are expected to cover 40% of the annual depreciation for these two funds. The remaining percentage will be covered by excess reserves. Restoration of this item in the City's baseline is a top priority. ♦ No supplemental programs are included for FY2021. ♦ Recommended capital items are included in the proposed budget. 201 N. Ector Drive, Euless, Texas 76039-3595 817/685-1400 Metro 817/267-4403 Fax 817/685-1416 www.eulesstx.gov 2 GENERALFUND General Fund revenues are proposed at $41,368,771 which represents a decrease of 5% from the previous year's budget. COVID-19 is the primary factor for this decrease. Shelter in place rules and social distancing restrictions have had immediate impacts on sales, business investment, travel, and ultimately the entire economy. The General Fund is immediately effected by reduced sales tax collections, reduced car rental tax transfers, reduced interest income, increased personal protective equipment expenses, and increased expenses not covered by other special revenue sources. Property valuations as of July 25th, including minimum value of property under protest and incomplete properties, provided to the City by the Tarrant Appraisal District totaled $5,164,250,293 for FY2020-21. This represents an increase of $228,514,507 or 4.6% from the FY2019-20 tax roll of $4,935,735,786. The tax rate proposed for FY2020-21 is 46.250 per $100 of assessed valuation, which includes 38.19540 for maintenance and operations and 8.05460 for debt service. This total proposed rate is unchanged from FY2019-20 and represents the 27th consecutive year that the Euless property tax rate has been held flat or reduced. FY2019-20 sales tax collections are projected to end the fiscal year down almost 20% from budget due to the pandemic. Projections for FY2020-21 are estimated to decrease 10% from original FY2019-20 expectations. Other revenue sources including building permits and fines and fees have either been held flat or reduced. 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 have been reduced based on declining case volume and legislative changes that impact collection of fines and fees. Franchise fees are projected to remain fairly flat. Aquatic's user charges will increase due to new rates. Ambulance fees are trending upward but with higher unemployment, collection rates may fall. Interest income is expected to decrease significantly due to the Federal Reserve lowering interest rates and uncertain market conditions. Miscellaneous income has been projected to increase due to the proposed implementation of credit card convenience fees. General Fund operating expenses, excluding capital programs, are proposed at $41,320,647 which also represents a decrease of approximately 5%. This decrease is in direct response to our projected decline in revenue due to COVID-19. Reductions were made across all departments. Two positions that were split between the General Fund and Water and Wastewater fund were eliminated and eight vacant General Fund positions are being held until economic conditions improve. Another position that was wholly funded by the General Fund is now shared with the Water and Wastewater Fund, and four police officer positions have been moved to the General Fund from the Crime Control and Prevention District (CCPD) due to the decline in sales tax revenue. No baseline salary increases were budgeted for FY2020-21 and starting pay ranges for new hires have been reduced. Step plan increases are included. Contractual rebates have been reduced based on expected declines in sales tax collections. 1.� 201 N. Ector Drive, Euless, Texas 76039-3595 817/685-1400 Metro 817/267-4403 Fax 817/685-1416 www.eulesstx.gov 3 As mentioned above, annual street improvements in the amount of $1,000,000 were removed from baseline funding but are being proposed as a one-time transfer from excess reserves. Only 40% of the annual transfers to the Equipment Replacement Fund to cover vehicle, mobile equipment, and most equipment and furnishing replacements have been included in the baseline funding. The remaining 60% will be covered by excess reserves. Other items funded from excess reserves are detailed on the Capital and Supplemental Request summary including code books, inspection services, FEMA matching funds, contingency funds, and funding for Arbor Daze. 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 needs. WATER AND WASTEWATER FUND The FY2020-21 budget includes proposed operating revenues of $27,079,515, which is an increase of 4% over FY2019-20 budgeted revenues. The water and wastewater revenue projections are based on proposed rates and estimated consumption for FY2020-21. A proposed rebate is included for single-family residential customers of 300 per thousand gallons of water used up to a maximum of 15,000 gallons per month. The City's Rate Stabilization Fund will provide the resources to cover the cost of the 11� proposed rebate Proposed water and wastewater baseline expenses are $26,987,658, which is an increase of 4% over current year. The anticipated volume of wastewater treatment is increasing and the projected cost of water and wastewater collection services from TRA is increasing. Two vacant positions in this Fund are being held, an administrative position has been split between this Fund and the General Fund and, as previously mentioned, two shared positions were eliminated. The only capital items proposed is the painting of fire hydrants. 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. The reserve level currently meets the requirements of the bond covenants. 201 N. Ector Drive, Euless, Texas 76039-3595 817/685-1400 Metro 817/267-4403 Fax 817/685-1416 www.eutesstK.gov 4 EQUIPMENT REPLACEMENT FUND The City maintains an equipment replacement program to accumulate funds for the replacement of existing vehicles, mobile equipment, and some equipment and furnishings. Funding is provided annually by user departments in order to accumulate funds to cover the expected replacement costs. Additionally, purchases in excess of $75,000 are supplemented with funding from the car rental fund and the use of tax notes as required. 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 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 decrease significantly in FY2020-21 from current year collections based on the COVID-19 pandemic and its impact on the travel industry. Funding for Arbor Daze has been provided by General Fund excess reserves for FY2020-21. Historic preservation, conference center operations, and contractual rebates are included in the budget for FY2020-21. Half -Cent Sales Tax Fund — Euless Development Corporation (EDC) Euless citizens approved an additional Y20 sales tax in 1993 that is restricted for parks, library, and economic development activities. Due to COVID-19, sales tax revenue projections for FY2020-21 are expected to drop 10% from the current year budget. Two position are being held vacant in the EDC Fund until sales tax collections improve. Recommended capital programs, as detailed in tab 2, include funds for an economic development building remodel, funds to remodel the building currently housing the temporary library for other uses, and a transfer for miscellaneous parks improvements. This budget maintains the required 60 days of working capital for reserves. 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. The COVID-19 pandemic has devastated the travel industry. Revenue from car rentals has dropped substantially. We expect the recovery to be very slow and therefore, 201 N. Ector Drive, Euless, Texas 76039-3595 817/685-1400 Metro 817/267-4403 Fax 817/685-1416 www.eulesstx.gov 5 L FY2020-2021 collections are projected to be down approximately 50% from the current year budget. 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, funds are included to replenish the redevelopment project and replenish the Texas Star Miscellaneous Improvements project. Details of both items can be found in the CIP plan. The recommended reserve level of $2,000,000 has been maintained. Juvenile Case Management Fund As mentioned above, fiscal policies direct the City to pay current expenses with current revenues. This budget recommends that Council approve the use of excess reserves to cover a portion of current expenses. The Juvenile Case Management Fund is expected to end FY2019-20 with approximately 1,026 days of fund balance in reserves. Fiscal policies recommend 60 days of reserves. These excess funds can only be used for juvenile case management and there are no one-time requests from this Fund. With the recommended drawdown, this fund is projected to end FY2020-21 with 734 days of operating reserves. ENTERPRISE FUNDS Texas Star Sports Complex The Texas Star Sports Complex has been expanded to include the former Softball World facility. Renovations are expected to be complete in the spring of 2021. This renovated facility will allow for the expansion of youth baseball leagues and tournaments while still accommodating some adult softball play. This budget includes the expected revenue from both facilities as these will operate under the sole title of Texas Star Sports Complex in the future. Recreation Class Fund The Recreation Class Fund is supported by user fees. The proposed revenue includes increases to membership fees and class fees in an effort to help offset the increased costs of operations. 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. 201 N. Ector Drive, Euless, Texas 76039-3595 817/685-1400 Metro 817/267-4403 Fax 817/685-1416 www.eulesstx.gov 6 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 have been considered in preparing the multi -year financial plan. This plan is fluid and will be reviewed and updated annually based on infrastructure needs within the City. The FY2020-21 recommended Priority A projects include funds for annual street improvements; wastewater line replacement at El Camino Real, Del Paso Street, and State Highway 10 at Main Street; and water line replacement on Dickey Drive. Capital funding is also included to complete street reconstruction projects, redevelopment, and miscellaneous capital improvements citywide. 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 issuance planned for FY2020-21 includes Certificates of Obligation in the amount of $5.5 million for street reconstruction projects detailed in the CIP Preliminary Budget document and $1.6 million in short-term tax notes for future public safety equipment purchases. A brief explanation of the various debt instruments is provided below: General Obligation Bonds — issued pursuant to voter authorization for infrastructure and facility projects. 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 201 N. Ector Drive, Euless, Texas 76039-3595 817/685-1400 Metro 817/267-4403 Fax 817/685-1416 www.eulesstx.gov 7 projects and debt issuance. Additional information relating to the City's currently outstanding debt is included in tab 3 of this book. CLOSING COMMENTS While the COVID-19 global pandemic has created challenges for the upcoming budget year, the City remains in a strong financial position. We are confident that this budget will continue to provide the appropriate resources to support our public safety services, many quality leisure and recreational opportunities, and continued investment in the City's infrastructure. 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, 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 2020 Budgeted Resources $ 47,549,599 Less Use of Prior Year Reserves $ (3,954,091) FY 2020 Net Operating Revenues $ 43,595,508 Proposed Changes in Revenue Property Taxes $ 604,146 Sales Tax $ (1,325,227) Franchise Fees $ 61,306, Licenses and Permits $ (15,340) Fines and Fees $ (742,395) Interest Income $ (142,500) Transfers $ (761,123) Other Changes $ 94,396 Subtotal: $ (2,226,737) FY 2021 Proposed Operating Revenues $ 41,368,771 FY 2020 Budgeted Expenses $ 47,531,579 Less Capital Expenses $ (3,954,091) FY 2020 Net Operating Expenses $ 43,577,488 Proposed Changes in Expenses Salaries and Benefits $ 13,545 Rebates/Incentives $ (98,848) Professional/Technical $ (62,699) Utilities and Fees $ (36,100) Maintenance/Supplies $ (110,276) Equipment Replacement $ (1,010,774) Street Improvements $ (885,000) Other Changes $ (66,689) Subtotal: $ (2,256,841) FY 2021 Proposed Supplemental $ - FY 2021 Proposed Operating Expenses $ 41,320,647 Proposed Capital Expenses Capital Carryover $ 65,946 Recommended Capital Expenses $ 3,333,451 FY 2021 Proposed Capital Expenses $ 3,399,397 FY 2021 Proposed Budget $ 44,720,044 9 EXECUTIVE SUMMARY WATER & WASTEWATER FY 2020 Budgeted Resources $ 26,262,116 Less Use of Prior Year Reserves $ (209,032) FY 2020 Net Operating Revenues $ 26,063,084 Proposed Changes in Revenue Water Service $ 460,914 Wastewater Service $ 717,100 Reclaimed Water Service $ (8,972) Interest Income $ (210,000) Sanitation/Recycling/Penalties $ 75,905 Other Changes $ (8,516) Subtotal: $ 1,026,431 FY 2021 Proposed Operating Revenues $ 27,079,615 FY 2020 Budgeted Expenses $ 26,240,886 Less Capital Expenses $ (209,032) FY 2020 Net Operating Expenses $ 26,031,854 Proposed Changes in Expenses Salaries and Benefits $ (72,532) TRA Payments $ 1,194,982 Reclaimed Water Purchases $ (42,158) Transfers $ (96,790) G&A/Franchise $ 102,644 Utilities and Fees $ (43,600) Maintenance $ (2,200) Regulatory Fees $ (35,000) Other Changes $ (49,542) Subtotal: $ 955,804 FY 2021 Proposed Supplemental $ - FY 2021 Proposed Operating Expenses $ 26,987,658 Proposed Capital Expenses Capital Carryover $ 168,944 Recommended Capital Expenses $ 30,000 FY 2021 Proposed Capital Expenses $ 198,944 FY 2021 Proposed Budget $ 27,186,602 10 ON EXECUTIVE SUMMARY CAR RENTAL FUND FY 2020 Budgeted Resources Less Use of Prior Year Reserves FY 2020 Net Operating Revenues Proposed Changes in Revenue Car Rental Taxes Interest Income Subtotal: FY 2021 Proposed Operating Revenues FY 2020 Budgeted Expenses Less Capital Expenses FY 2020 Net Operating Expenses Proposed Changes in Expenses DFW Rebate Contingencies Transfer to General Fund Transfer to Equipment Replacement Subtotal: FY 2021 Proposed Operating Expenses Proposed Capital Expenses Capital Carryover Recommended Capital Expenses FY 2021 Proposed Capital Expenses FY 2021 Proposed Budget $ 18,421,290 $ (3,581,159) $ (7,313,223) $ (131,500) $ 15,444,403 $ (3,581,159) $ (4,875,482) $ (812,580) $ (349,253) $ 453,466 $ 800,000 $ 14,840,131 $ (7,444,723) $ 7,396,408 $ 11,863,244 $ (6,037,315) $ 5,825,929 $ 1,253,466 $ 7,079,395 11 Fund Balance Summary �.. Estimated FY2019-20 and Budgeted FY2020-21 General and Internal Service Funds Insurance & Risk Mgmt. & Equipment General Benefits Comps Replacement Beginning Balance, FY20 $15,473,615 $4,657,308 $1,949,184 $4,795,849 (per audit, FYE 2019) FY20 Estimated Revenues 39,756,485 7,704,525 1,028,800 7,226,224 Total Available: 55,230,100 12,361,833 2,977,984 12,022,073 FY20 Estimated Expenses (39,305,802) (7,631,683) (1,027,125) (1,370,392) Proposed Budget Adjustment 0 0 0 0 Capital Expenses (3,345,829) 0 0 0 Total Projected Expenses: (42,651,631) (7,631,683) (1,027,125) (1,370,392) Estimated Ending Balance FY20 12,578,469 4,730,150 1,950,859 10,651,681 FY21 Budgeted Revenues 41,368,771 7,282,014 1,045,308 4,222,819 Total Available: 53,947,240 12,012,164 2,996,167 14,874,500 FY21 Budgeted Expenses Capital Carryover Capital Expenses Total Projected Expenses: (41,320,647) (7,253,937) (65, 946) 0 (3,333,451) 0 (44,720,044) (7,253,937) (1,028,467) (1,472,500) (170,000) 0 0 0 (1,198,467) (1,472,500) Projected Ending Balance, FY21 9,227,196 4,758,227 1,797,700 13,402,000 .ess: Designated Reserve (129,148) 0 0 0 ►djusted Ending Balance 9,098,048 4,758,227 1,797,700 13,402,000 Recommended Reserve Levels per Fiscal Policy: 6,792,435 2,298,729 Available for Supplemental: Available for Capital: Total Available 48,124 2,257,489 2,305,613 28,077 2,431,421 2,459,498 600,000 13,402,000 16,841 2,750,319 1,180,859 (2,750,319) 1,197,700 0 12 Fund Balance Summary `- Estimated FY2019-20 and Budgeted FY2020-21 Special Revenue Funds Hotel/ Juvenile EDC 112 Cent CCPD 1/4 Motel Case Sales Tax Cent Sales Car Rental Tax Beginning Balance, FY20 $509,357 $280,877 $3,352,724 $1,295,869 $4,362,191 (per audit, FYE 2019) FY20 Estimated Revenues 649.190 55,485 4,745,804 2,206,668 9,355,305 Total Available: 1,158,547 336,362 8,098,528 3,502,537 13,717,496 FY20 Estimated Expenses (616,650) (79,818) (4,143,889) (2,651,914) (7,558,818) Proposed Budget Adjustment 0 0 0 (400,000) Capital Expenses (325,000) (1,000) (2,020,618) (456,476) (3,124,702) Total Projected Expenses: (941,650) 8( 0.818) (6,164,507) (3,108,390) (11,083,520) Estimated Ending Balance FY20 216,897 255,544 1,934,021 394,147 2,633,976 FY21 Budgeted Revenues 532,338 54,000 4,985,335 2,161,768 7,395,408 Total Available: 749,235 309,544 6,919,356 2,555,915 10,029,384 FY21 Budgeted Expenses (524,174) (90,658) (4,671,893) (2,122,850) (5,825,929) Capital Carryover 0 (36,000) (424,757) 0 (453,466) Capital Expenses 0 0 37( 0.000) (82,835) (800,000) Total Projected Expenses: (524,174) 12( 6.658) (5,466,650) (2,205,685) (7,079,395) Irojected Ending Balance, FY21 225,061 182,886 1,452,706 350,230 2,949,989 .ess: Designated Reserve (66,999) 0 0 0 0 ►djusted Ending Balance 158,062 182,886 1,452,706 350,230 2,949,989 Recommended Reserve Levels per Fiscal Policy: 86,166 14,903 767,982 348,962 2,000,000 Available for Supplemental: 8,164 (36,658) 313,442 38,918 1,569,479 Available for Capital: 63,732 204,641 371,282 (37,650) (619,490) Total Available 71,896 167,983 684,724 1,268 949,989 13 Fund Balance Summary Estimated FY2019-20 and Budgeted FY2020-21 Special Revenue Funds (continued) Police Police Glade Glade Cable Midtown Midtown Drug Grant Seized Parks PID Parks PEG Fee PID TIRZ Assets #1 TIRZ FY20 Estimated Revenues 12,328 3,231,939 2 531 0 1,641,886 119,012 994,247 100,009 Total Available: 537,790 3,232,752 279,987 750,000 2,855,085 905,086 1,081,684 151,733 FY20 Estimated Expenses (500) (71,362) (61,506) 0 (1,143,966) (120,000) (1,062,197) (51,701) Proposed Budget Adjustment 0 (3,160,577) 0 0 0 0 0 0 Capital Expenses 0 0 0 0 0 20( 6,794) 0 0 Total Projected Expenses: 500 (3,231,939) (61,506) 0 (1,143,966) 326794 (1,062,197) (51,701) Estimated Ending Balance FY20 537,290 813 218,481 750,000 1,711,119 578,292 19,487 100,032 FY21 Budgeted Revenues 2050 64,061 1000 0 1,832,232 110,000 1,109,756 399,989 Total Available: 539,340 64,874 219,481 750,000 3,543,351 688,292 1,129,243 500,021 FY21 Budgeted Expenses (500) (64,061) (34,104) 0 (1,138,167) (110,000) (1,009,747) (100,009) Capital Carryover (178,662) 0 0 0 0 0 0 0 Capital Expenses 0 0 0 0 0 0 0 0 Total Projected Expenses: (179,162) (64,061) (34,104) 0 (1,138,167) (110,000) (1,009,747) (100,009) 'rojected Ending Balance, FY21 360,178 813 185,377 750,000 2,405,184 578,292 119,496 400,012 .ess: Designated Reserve 0 0 0 75( 0,000) 0 0 0 0 idjusted Ending Balance 360,178 813 185,377 0 2,405,184 578,292 119,496 400,012 Recommended Reserve Levels per Fiscal Policy: 0 0 0 0 0 0 0 0 Available for Supplemental: 1,550 0 (33,104) 0 694,065 0 100,009 299,980 Available for Capital: 358,628 813 218,481 0 1,711,119 578,292 19,487 100,032 Total Available 360,178 813 185,377 0 2,406,184 578,292 119,496 400,012 14 Fund Balance Summary Estimated FY2019-20 and Budgeted FY2020-21 Enterprise Funds Drainage Texas Water & Service Utility Recreation Arbor Texas Star Star Wastewater Center System Classes Daze Golf Sports Complex Beginning Balance, FY20 $9,068,116 $598,187 $311,068 $467,744 $64,240 $3,113 $384.205 FY20 Estimated Revenues 25,787,469 1,209,143 834,500 428,530 4407 4,095,602 698,657 Total Available: 34,855,585 1,807,330 1,145,568 886,274 58,647 4,098,715 1,082,862 FY20 Estimated Expenses (26,578,789) (1,203,143) (754,288) (557,772) (4,230) (4,080,444) (641,090) Proposed Budget Adjustment 0 0 0 0 0 0 0 Capital Expenses (40,088) 11( 5.250) (50,000) 24( 6.862) 0 0 (53,000) Total Projected Expenses: (26,618,877) (1,318,393) 80( 4,288) (804,634) 4( •230) (4,080,444) 69( 4.090) Estimated Ending Balance FY20 8,236,708 488,937 341,280 81,640 54,417 18,271 388,772 FY21 Budgeted Revenues 27,079,515 1,212,265 837,200 787,027 25,583 4,629,475 885,000 Total Available: 35,316,223 1,701,202 1,178,480 868,667 80,000 4,647,746 1,273,772 FY21 Budgeted Expenses (26,987,658) (1,212,265) (834,563) (697,935) (80,000) (4,606,455) (725,564) Capital Carryover (168,944) (27,500) 0 0 0 0 0 Capital Expenses (30,000) 0 10( 0.000) 0 0 0 0 Total Projected Expenses: (27,186,602) (1,239,765) (934,563) 69f 7.935) (80,005) (4,606,455) 72( 5.564) 'rojected Ending Balance, FY21 8,129,621 461,437 243,917 170,732 0 41,291 548,20E .ess: Designated Reserve 0 0 0 0 0 0 C kdjusted Ending Balance 8,129,621 461,437 243,917 170,732 0 41,291 548,20E Recommended Reserve Levels per Fiscal Policy., 5,545,409 Available for Supplemental: 91,857 Available for Capital: 2,492,355 Total Available 2,584,212 0 171,486 143,411 0 0 149,088 0 2,637 89,092 (54,417) 23,020 169,436 461,437 69,794 61771 54,417 18,271 239,684 461,437 72,431 27,321 0 41,291 3995120 M Fund Balance Summary Estimated FY2019-20 and Budgeted FY2020-21 Debt Service Funds EDC 112 Water & Texas G.O.Debt Stars Star Golf Service Center Debt Cent Sales Wastewater Course Tax Debt Debt Debt (per audit, FYE 2019) FY20 Estimated Revenues 6,053,137 713,803 442,664 1,489,617 589,811 Total Available: 8,333,722 848,597 444,974 2,088,983 646,308 FY20 Estimated Expenses (6,070,199) (709,303) (442,664) (1,489,617) (589,566) Proposed Budget Adjustment 0 0 0 0 0 Total Projected Expenses: (6,070,199) (709,303) (442,664) (1,489,617) (589,566) Estimated Ending Balance FY20 2,263,523 139,294 2,310 599,366 56,742 FY21 Budgeted Revenues 6,000,969 715,896 394,605 1,220,326 594,125 Total Available: 8,264,492 855,190 396,915 1,819,692 650,867 FY21 Budgeted Expenses (6,070,834) (712,896) (394,605) (1,219,826) (594,566) Capital Carryover 0 0 0 0 0 Capital Expenses 0 0 0 0 0 Total Projected Expenses: (6,070,834) 71( 2.896) (394,605) (1,219,826) (594,566) Projected Ending Balance, FY21 2,193,658 142,294 2,310 599,866 56,301 Less: Designated Reserve (445,730) 4( 1,250) 0 0 0 Adjusted Ending Balance 1,747,928 101,044 2,310 599,866 56,301 Recommended Reserve Levels per Fiscal Policy. 444,270 Available for Supplemental: (69,865) Available for Capital: 1,373,523 Total Available 1,303,658 11�.-' 0 0 0 0 3,000 0 500 ("1) 98,044 2.310 599,366 56,742 101,044 2,310 599,866 56,301 16 Fund Balance Summary Estimated FY2019-20 and Budgeted FY2020-21 Reserve Funds General EDC 112 Cent Water & Water & Texas Star Emergency/ Midtown Sales Tax Wastewater Wastewater Texas Star Sports Contingency Bond Debt Debt & Rate Golf Course Complex Reserves Reserve Reserve Emergency Stabilization Reserve Reserve Reserve Reserve (per audit, FYE 2019) FY20 Estimated Revenues 0 230,821 0 0 245.213 44,120 68,000 Total Available: 1,500,000 391,500 999,725 1,327,464 4,589,459 660,455 949,435 FY20 Estimated Expenses 0 0 0 0 (242,414) 0 (100,000) Proposed Budget Adjustment 0 0 0 0 0 0 0 Capital Expenses 0 0 0 0 (900,000) (379,419) (215,337) Total Projected Expenses: 0 0 0 0 (1,142,414) 37( 9,419) 31( 5,337) Estimated Ending Balance FY20 1,500,000 391,500 999,726 1,327,464 3,447,045 281,036 634,098 FY21 Budgeted Revenues 0 9 625 0 0 20,000 16,000 52,500 Total Available: 1,500,000 401,125 999,725 1,327,464 3,467,045 297,036 686,598 FY21 Budgeted Expenses 0 0 0 0 (262,742) 0 (50,000) Capital Carryover 0 0 0 0 0 0 0 Capital Expenses 0 0 0 0 0 0 0 Total Projected Expenses: 0 0 0 0 26( 2,742) 0 (50,000) Irojected Ending Balance, FY21 1,600,000 401,125 999,726 1,327,464 3,204,303 297,036 636,598 .ess: Designated Reserve (1,600,000) 40( 1,126) (999,725) (1,266,601) 0 0 (523.73 3 Ldjusted Ending Balance 0 0 0 60,863 3,204,303 297,036 112,865 Recommended Reserve Levels per Fiscal Policy: 0 0 0 0 0 0 946,632 Available for Supplemental: 0 9,625 0 0 (242,742) 16,000 2,600 Available for Capital: 0 (9,626) 0 60,863 3,447,046 281,036 (836,167) Total Available 0 0 0 60,863 3,204,303 297,036 (833,667) 17 Where Does The Money Come From? FY2020-2021 Debt Other 8% 10 /o Risk/WC Insur 6' Golf 4% W&% 23' -�Car Rental CCPD 6% 2% Budgeted FY2019-2020 Use of Revenue Reserves General $ 43,595,508 $ 3,954,091 Hotel/Motel $ 1,229,500 $ 400,000 Juvenile Case $ 86,675 $ 37,000 EDC'/zo Sales Tax $ 5,543,964 $ 2,448,109 CCPD'/40 Sales Tax $ 2,715,960 $ 520,711 Police Seized Assets Fund $ 4,000 $ 57,506 Police Drug Fund $ 8,500 $ 178,662 Grant Fund $ 71,362 $ - Car Rental $ 14,840,131 $ 3,581,159 Glade Parks PID $ - $ - Glade Parks TIRZ $ 1,851,647 $ - Cable PEG Fund $ 123,000 $ 206,794 Midtown PID $ 1,112,248 $ - Midtown TIRZ $ 100,009 $ - Water & Wastewater $ 26,053,084 $ 209,032 Service Center $ 1,333,623 $ 142,750 Drainage Utility $ 834,500 $ 50,000 Recreation Classes $ 748,530 $ 246,862 Arbor Daze $ 80,000 $ - Texas Star Golf Course (TSGC) $ 4,694,475 $ - Texas Star Sports Complex (TSSC) $ 767,100 $ 53,000 Equip. Replacement $ 6,924,657 $ - Insurance $ 7,704,525 $ - Risk/WC $ 1,028,800 $ 170,000 General Obligation Debt $ 6,023,137 $ 47,062 Star Center Debt $ 713,803 $ - EDC Debt $ 442,664 $ Water & Wastewater Debt $ 1,489,617 $ TSGC Debt $ 589,566 $ - TOTAL $ 130,710,585 $ 12,302,738 Schedule includes operating and debt funds and excludes CIP and reserve funds 4% Proposed FY2020-2021 Use of Revenue Reserves $ 41,368,771 $ 3,399,397 $ 532,338 $ - $ 54,000 $ 72,658 $ 4,985,335 $ 794,757 $ 2,161,768 $ 82,835 $ 1,000 $ 33,104 $ 2,050 $ 178,662 $ 64,061 $ - $ 7,395,408 $ 1,253,466 $ 1,832,232 $ $ 110,000 $ - $ 1,109,756 $ $ 399,989 $ - $ 27,079,515 $ 198,944 $ 1,212,265 $ 27,500 $ 837,200 $ 100,000 $ 787,027 $ - $ 25,583 $ 54,417 $ 4,629,475 $ - $ 885,000 $ $ 4,222,819 $ - $ 7,282,014 $ - $ 1,045,308 $ 170,000 $ 6,000,969 $ 69,865 $ 715,896 $ - $ 394,605 $ $ 1,220,326 $ - $ 594,125 $ 441 $ 116,948,835 $ 6,436,046 18 FY2020-2021 Insu 7 Golf 4% W&W 25% Where Does The Money Go? Debt Other Risk/WC 8% 7% o/ Car Rental CCPD EDC 5% 2% 4 /o Budgeted FY2019-2020 Operating Capital Fund Expenses Expenses General $ 43,577,488 $ 3,954,091 Hotel/Motel $ 897,107 $ 400,000 Juvenile Case $ 85,618 $ 37,000 EDC''/z¢ Sales Tax $ 4,714,162 $ 2,448,109 CCPD'/40 Sales Tax $ 2,705,126 $ 520,711 Police Seized Assets Fund $ 61,506 $ - Police Drug Fund $ 500 $ 178,662 Grant Fund $ 71,362 $ - Car Rental $ 11,863,244 $ 3,581,159 Glade Parks PID $ - $ - Glade Parks TIRZ $ 1,143,966 $ - Cable PEG Fund $ 120,000 $ 206,794 Midtown PID $ 1,062,197 $ - Midtown TIRZ $ 51,701 $ - Water & Wastewater $ 26,031,854 $ 209,032 Service Center $ 1,333,623 $ 142,750 Drainage Utility $ 832,950 $ 50,000 Recreation Classes $ 734,119 $ 246,862 Arbor Daze $ 80,000 $ - Texas Star Golf Course (TSGC) $ 4,688,712 $ - Texas Star Sports Complex (TSSC) $ 684,522 $ 53,000 Equip. Replacement $ 1,634,500 $ - Insurance $ 7,631,683 $ - Risk/WC $ 1,027,125 $ 170,000 General Obligation Debt $ 6,070,199 $ - Star Center Debt $ 709,303 $ EDC Debt $ 442,664 $ Water & Wastewater Debt $ 1,489,617 $ TSGC Debt $ 589,566 $ - TOTAL $ 120,334,414 $ 12,198,170 Schedule includes operating and debt funds and excludes CIP and reserve funds. 19 General 37% Proposed FY2020-2021 Operating Capital Expenses Expenses $ 41,320,647 $ 3,399,397 $ 524,174 $ - $ 90,658 $ 36,000 $ 4,671,893 $ 794,757 $ 2,122,850 $ 82,835 $ 34,104 $ - $ 500 $ 178,662 $ 64,061 $ - $ 5,825,929 $ 1,253,466 $ 1,138,167 $ $ 110,000 $ $ 1,009,747 $ $ 100,009 $ - $ 26,987,658 $ 198,944 $ 1,212,265 $ 27,500 $ 834,563 $ 100,000 $ 697,935 $ - $ 80,000 $ $ 4,606,455 $ $ 725,564 $ $ 1,472,500 $ $ 7,253,937 $ - $ 1,028,467 $ 170,000 $ 6,070,834 $ - $ 712,896 $ $ 394,605 $ $ 1,219,826 $ $ 594,566 $ $ 110,904,810 $ 6,241,561 General Fund Revenues FY2020-2021 Property Taxes 43% Miscellaneo 3% Sales & Uses Taxes Transfers Fines & Fees 5% Interest 8% 0% Licenses/Permits 2% chise Fees 10% Proposed FY20 Budget to General Fund Actual Budget Estimated Budget FY21 Proposed Revenues FY 19 FY 20 FY 20 FY 21 $ Diff % Diff. Property Taxes $ 15,128,135 $ 17,108,713 $ 17,051,995 $ 17,712,859 $ 604,146 4% Prior Year Property Taxes $ 8,497 $ 15,000 $ 14,255 $ $ 15,000 60,000 $ $ - 10,000 0% 20% Penalties & Interest $ $ 56,913 10,360,283 $ $ 50,000 10,529,080 $ $ 70,115 8,496,100 $ 9,476,172 $ (1,052,908) (10%) Sales Tax Additional Sales Tax $ 2,678,349 $ 2,723,192 $ 2,186,028 $ 2,450,873 $ (272,319) (10%) Mixed Drink Tax $ 138,218 $ 188,890 $ 117,503 $ 130,000 $ (58,890) (31%) 1% Electric Franchise $ 1,680,213 $ 1,700,266 $ 1,700,266 $ $ 1,720,000 400,000 $ $ 19,734 (15,000) (4%) Gas Franchise $ $ 381,306 249,456 $ $ 415,000 50,000 $ $ 345,264 124,001 $ 50,000 $ - 0% Telephone Franchise Sanitation Service $ 264,926 $ 275,000 $ 275,556 $ 280,000 $ 5,000 2% Recycling Franchise Fee $ 21,877 $ 22,500 $ 22,789 $ 22,750 $ 250 0% Cable Franchise Fee $ 551,611 $ 425,000 $ $ 412,965 1,308,184 $ $ 425,000 1,353,976 $ $ - 51,322 4% W&WW Franchise Tax $ 1,289,265 $ $ 1,302,654 30,000 $ 28,470 $ 30,000 $ - Other Permits $ $ 30,388 91,400 $ 85,000 $ 75,050 $ 80,000 $ (5,000) (6%) Health Permits Fire Permits $ 110,933 $ 907000 $ 85,909 $ 90,000 $ - 0% Contractor Regulatory License $ 60,700 $ 60,000 $ 59,300 $ $ 60,000 65,000 $ $ = 0% 0% Minimum Housing $ $ 63,665 55,836 $ $ 65,000 51,140 $ $ 64,257 41,248 $ 40,800 $ (10,340) ( ) Misc. Permits and Fees Building Permits $ 1,720,499 $ 300,000 $ 920,889 $ 300,000 $ 0% Aquatics $ 249,384 $ 230,000 $ 3,045 $ 308,145 $ 78,145 34% 0% Auto Theft Task Force Grant $ 89,515 $ 95,000 $ 94,349 $ 95,000 $ $ - 0% School Resource Officers $ 331,354 $ $ 331,350 2,407,050 $ $ 250,999 1,539,484 $ $ 331,350 1,536,600 $ (870,450) (36%) Municipal Court $ $ 2,198,742 16,707 $ 16,100 $ 9,676 $ 16,010 $ (90) (1%) Library Fees Ambulance Fees $ 905,783 $ 850,000 $ 908,745 $ 900,000 $ 50,000 6% Alarm Revenue $ 119,216 $ 120,000 $ 118,421 $ 120,000 $ $ - 0% Jail Revenue $ 175,239 $ 200,000 255,000 $ $ 129,693 299,520 $ $ 200,000 112,500 $ (142,500) (56%) Interest Income $ $ 442,141 243,883 $ $ 84,424 $ 78,980 $ 205,028 $ 120,604 143% Miscellaneous $ 513,888 $ 530,200 $ 538,563 $ 552,882 $ 22,682 4% Tower Lease Betterment/Contributions $ 15,588 $ 15,000 $ 15,448 $ $ 15,000 2,213,826 $ $ - 761,123 0% 26% Transfers TOTAL REVENUES $ $ 2,970,891 43,214,801 $ $ 2,974,949 43,595,508 $ $ 2,369,418 39,756,485 $ 41,368,771 $ (2,226,737) -5% $ $ 3,954,091 $ 2,895,146 $ 3,399.397 $ 554,694 14%' Use of Reserves TOTAL RESOURCES $ 43,214,801 $ 47,549,599 $ 42,651,631 $ 44,768,168 $ (2,781,431) -6% O TAX RATE SCENARIOS As Computed from July 2020 Certified Tax Roll Fiscal Year 2020-21 Revenue at Revenue at Revenue at Revenue at Fiscal Year 2019-20 No -New -Revenue Rate Proposed Rate Voter -Approval Rate Voter -Approval Rate @ 3.5% @ 8% 0.462500 0.454376 0.462500 0.464103 0.483394 Total Tax Rate Debt Tax Rate 0.084526 0.080546 0.080646 0.080546 0.080546 M & O Tax Rate 0.377974 0.373830 0.381954 0.383557 0.402848 Est. Assessed Valuation (a) $4,935,735,786 $5,164,250,293 $5,164,250,293 $5,164,250,293 $5,164,250,293 Adj. Net Taxable Value Assessed (b) $4,392,681,817 $4,565,141,454 $4,565,141,454 $4,565,141,454 $4,565,141,454 Est. TIF Increment Value (c) 176,087,880 198,797,189 198,797,189 198,797,189 198,797,189 Total Debt $4,392,814 $5,812,833 $5,812,833 $5,812,833 $5,812,833 Debt Paid by other Sources ($246,352) ($2,135,805) ($2,135,805) ($2,135,805) ($2,135,805) Taxable Debt Service $4,146,462 $3,677,028 $3,677,028 $3,677,028 $3,677,028 Debt Revenue $3,712,958 $3,677,039 $3,677,039 $3,677,039 $3,677,039 Ceiling Revenues $0 $216,654 $212,849 $212,114 $203,649 Prior Year Debt Revenue $3,589,556 $3,712,958 $3,712,958 $3,712,958 $3,712,958 Increase (Decrease) in Debt Revenue $123,402 $180,735 $176,929 $176,194 $167,729 M&ORevenue- General Fund $16,188,115 $16,326,171 $16,703,518 $16,777,975 $17,674,011 Ceiling Revenues $920,598 $1,005,536 $1,009,341 $1,010,076 $1,018,541 Total General Fund Tax Revenue $17,108,713 $17,331,707 $17,712,859 $17,788,051 $18,692,552 Prior Year M&O Revenue $15,155,605 $17,108,713 $17,108,713 $17,108,713 $17,108,713 Increase (Decrease) in MSA Revenue $1,953,108 $222,994 $604,146 $679,338 $1,583,839 Totalincrease in Tax Revenue $2,076,510 $403,729 $781,075 $855,532 $1,751,568 NOTES: (a) Assessed Valuation is the estimated Net Taxable Value from T.A.D. plus minimum value of ARB and estimate of incomplete property. (b) Adj. Net Taxable Value Assessed = Assessed Value less estimated TIF increment $198,797,189 and authorized ceiling estimate $400,311,650. (c) TIF = Tax Increment Finance zone increment value increase contracted at 75% ($265,062,919 @ 75% = $198,797,189). Note: Under these circumstances each penny of tax equals approximately $445,101 ($4,565,141,454*.01*.975/100 = $445,101). M&O Revenues are at a collection rate of approximately 97.5%. Debt Revenues are at 100% collections. M&O = Maintenance and Operations M, 21 General Fund Expenditures FY2020-2021 Admin Sn 7% Non -Depart 10% Development 2% Public Works PACS Capital Finance 4% 6% 8% City Admin V/ tee. Police 34% Proposed FY20 Budget to General Fund Actual Budget Estimated Budget FY21 Proposed Expenditures FY 19 FY 20 FY 20 FY 21 $ Diff % Diff. City Council $ 16,542 $ 40,680 $ 22,985 $ 26,805 $ (13,875) (34%) City Administration $ 602,743 $ 622,176 $ 576,027 $ 508,211 $ (113,965) (18%) City Secretary $ 318,942 S 440,641 $ 434,377 $ 434,977 $ (5,664) (1%) Comm unications/Marketin $ 13,831 $ 20,725 $ 13,597 $ 13,600 $ (7,125) 34% Total - City Administration $ 952,058 $ 1,124,222 $ 1,046,986 $ 983,593 $ (140,629) (13%) Finance/Budget $ 243,876 $ 253,813 $ 203,521 $ 185,128 $ (68,685) (27%) Municipal Court $ 716,919 $ 814,553 $ 734,378 $ 812,933 $ (1,620) (0%) Accounting $ 380,639 $ 446,878 $ 439,666 $ 381,667 $ (65,211) (15%) Purchasing $ 96,939 $ 100,903 $ 100,735 $ 98,306 $ (2,597) 3% Total - Finance $ 1,438,373 $ 1,616,147 $ 1,478,300 $ 1,478,034 $ (138,113) (9%) Emergency Management $ 43,778 $ 58,095 $ 29,829 $ 57,508 $ (587)- (1%) Police Code Compliance $ 1,770,269 $ 1,919,126 $ 1,627,134 $ 1,917,082 $ (2,044y- (0%) Police Administration $ 1,136,856 $ 1,128,054 $ 1,113,054 $ 1,183,840 $ 55,786 5% Police Patrol $ 5,695,529 $ 6,116,071 $ 5,245,740 $ 6,481,805 $ 365,734 6% Police CID $ 1,768,426 $ 1,794,441 $ 1,792,182 $ 1,919,844 $ 125,403 7% Police Service $ 2,139,391 $ 2,271,077 $ 2,261,421 $ 2.230,603 $ (40,474)- (2%) Police Detention $ 1.538 672 $ 1,643,113 $ 1,409,447 $ 1,546,179 $ (96,934) 6% Total -Police $ 14,092,921 $ 14,929,977 $ 13,478,807 $ 15,336,861 $ 406,884 3% Fire Marshal/Education $ 646,996 $ 676,001 $ 622,783 $ 672,220 $ (3,781) (1%) Fire Administration $ 584,978 $ 578,037 $ 576,230 $ 583,496 $ 5,459 1% EMS/Suppression $ 9,224,238 $ 9,690,644 $ 8,272.846 $ 9.544,521 $ 146,123 2% Total -Fire $ 10,456,212 $ 10,944,682 $ 9,471,859 $ 10,800,237 $ 144,445 1% Information Services S 682,250 $ 756,910 $ 718,296 $ 766,703 $ 9,793 1% Human Resources S 418,584 $ 458,914 $ 421,022 $ 486,356 $ 27,442 6% Facility Maintenance S 994,008 $ 1.134,199 $ 990,969 $ 1,059,391 $ (74,808) (7%) Libra $ 801,868 S 827,337 $ 809,137 $ 818,665 $ 8,672 1% Total - Administrative Services $ 2,896,710 $ 3,177,360 $ 2,939,424 $ 3,131,115 $ (46,245) (1%) Planning & Development $ 308,177 $ 316,798 $ 316,126 $ 339,507 $ 22,709 7% Inspection Services $ 385,793 $ 406,541 $ 380,381 $ 388.075 $ 18466 5% Total -Development $ 693,970 $ 723,339 $ 696,507 $ 727,582 $ 4,243 1% Recreation $ 686,082 $ 688,616 $ 673,502 $ 632,079 $ (56,537) (8%) Parks $ 1,368,676 $ 1,492,597 $ 1,428,067 $ 1,401,776 $ (90,821) (6%) Aquatics $ 127,634 $ 156,460 $ 115,900 $ 156,025 $ (435) (0%) Senior Center $ 252,736 $ 301,553 $ 243,093 $ 252,346 $ (49,207) (16%) Recreation Admin. $ 71,017 $ 101,609 $ 97,759 $ 76,609 $ 25,000 25% Total -Parks & Comm Srvcs $ 2,506,145 $ 2,740,835 $ 2,558,321 $ 2,518,835 $ (222,000) (8%) Street Maintenance $ 2,316,556 S 2,368,916 $ 2,241,145 $ 1,428,698 $ (940,218) (40%) Animal Control $ 307,087 $ 327,586 $ 311,862 $ 325,942 $ (1,644) (1%) City Engineer $ 70.570 $ 81,819 $ 81,819 $ 82,357 $ 538 1% Total - Public Works $ 2,694,213 $ 2,778,321 $ 2,634,826 $ 1,836,997 $ (941,324) (34%) Legal Services $ 139,583 $ 175,000 $ 175,000 $ 175,000 $ - 0% Non -Departmental $ 4,044,272 $ 5,352,605 $ 4,825,172 $ 4,327,793 $ (1,024,812) (19%) Betterment $ 3,588 $ 15,000 $ 600 $ 4,600 $ (10,400) 69% Total - Non -Depart. $ 4,187,443 $ 5,542,605 $ 5,000,772 $ 4,507,393 $ 1,035,212 19% Total Operating Expenses $ 39,918,045 $ 43,577,488 $ 39,305,802 $ 41,320,647 $ (2,256,841) 5%) Capital Expenses $ 1,377,834 $ 3,954,091 $ 3,345,829 $ 3,399,397 $ (554,694) (14%) Total Expenses $ 41,295,879 $ 47,531,579 $ 42,651,631 $ 44,720,044 $ (2,811,535) (6%) 22 ow- Water & Wastewater Revenues FY2020-2021 Recycling Sanitation 1% 1% 1111119 Wastewater 38% Other(1) 2% Penalties Reclaimed Water 1% 2% ater ;5% 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 2% of total revenues and is an aggregate of several revenue sources as indicated in the table below. Proposed FY20 Budget to Water & Wastewater Actual Budget Estimated Budget FY21 Proposed Revenues FY 19 FY 20 FY 20 FY 21 $ Diff % Diff. Interest Income(l) $ 249,328 $ 250,000 $ 177,947 $ 40,000 $ (210,000) (84%) Sanitation $ 241,414 $ 224,045 $ 249,240 $ 250,000 $ 25,955 12% Water Service $ 13,859,748 $ 14,330,999 $ 14,330,999 $ 14,791,913 $ 460,914 3% Wastewater Service $ 9,694,746 $ 9,500,425 $ 9,500,425 $ 10,217,525 $ 717,100 8% Reclaimed Water Service $ 498,987 $ 608,333 $ 608,333 $ 599,361 $ (8,972) (1%) New Meters') $ 45,310 $ 60,000 $ 29,105 $ 30,000 $ (30,000) (50%) Reconnect Fees)1) $ 227,610 $ 235,000 $ 119,168 $ 135,000 $ (100,000) (43%) Inspection Fees(') $ 222,295 $ 150,000 $ 130,291 $ 150,000 $ - 0% Miscellaneous(') $ 54,908 $ 50,000 $ 40,319 $ 171,484 $ 121,484 243% Penalties $ 242,671 $ 230,000 $ 134,753 $ 230,000 $ - 0% Initiations/Transfer Fees(1) $ 31,530 $ 30,000 $ 26,449 $ 30,000 $ - 0% Recycling Fees $ 416,755 $ 384,282 $ 440,440 $ 434,232 $ 49,950 13% Use of Rate Stabilization $ 244,704 $ 242,414 $ 245,891 $ 262,742 $ 20,328 8% Rate Stabilization Rebate $ (244,704) $ (242,414) $ (245,891) $ (262,742) $ (20,328) 8% TOTAL REVENUES $ 25,785,302 $ 26,053,084 $ 25,787,469 $ 27,0795515 $ 1,026,431 4% Use of Reserves $ - $ 209,032 $ 831,408 $ 198,944 $ (10,088) (5%) TOTAL RESOURCES $ 25,785,302 $ 26,2625116 $ 26,618,877 $ 27,278,459 $ 1,0165343 4% 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: Proposed Rates: e er 7 Farge: eter arge: Meter Size (inches) Monthly Charge Meter Size (inches) Monthly Charge 5/8-3/4 $ 12.75 5/8-3/4 $ 12.75 1 $ 14.90 1 $ 14.90 11/2 $ 20.88 11/2 $ 20.88 2 $ 34.59 2 $ 34.59 3 $ 70.36 3 $ 70.36 4 $ 124.04 4 $ 124.04 5 $ 195.60 5 $ 195.60 6 $ 279.09 6 $ 279.09 Residential o ume Charge per 1,000 gallons gas Residential o ume Charge per 1,000 gallons (tgals) Tiered Rates Tiered Rates 0-2 tgals $ 4.07 0-2 tgals $ 4.21 3-8 tgals $ 5.00 3-8 tgals $ 5.14 9-15 tgals $ 5.57 9-15 tgals $ 5.71 16-35 tgals $ 6.10 16-35 tgals $ 6.24 Over 35 tgals $ 6.70 Over 35 tgals $ 6.84 Single ami y Residential Kate Stabilization a un : Single Family Kesidential Rate Stabilization a un : 300 per 1,000 (tgals) up to 15 tgals/monthly 300 per 1,000 (tgals) up to 15 tgals/monthly Estimated total refund @ 30¢/tgal $ 242,414 Estimated total refund @ 30¢/tgal $ 262,742 Estimated refund volume in tgals: 808,048 Estimated refund volume in tgals: 875,806 Refund not applicable to irrigation meters Refund not applicable to irrigation meters rngation o ume Unarge per 1,000 gallons (tgals) Irrigation Volume Charge per 1,UUU gallons (tgals) Tiered Rates Tiered Rates 0-2 tgals $ 5.33 0-2 tgals $ 5.47 3-8 tgals $ 5.33 3-8 tgals $ 5.47 9-15 tgals $ 5.57 9-15 tgals $ 5.71 16-35 tgals $ 6.10 16-35 tgals $ 6.24 Over 35 tgals $ 6.70 Over 35 tgals $ 6.84 Other -Volume Charges per 1,000 gallons (tgals) ter Volume Charges per C,000 gallons (tgals) Commercial & Multi -family $ 5.33 Commercial & Multi -family $ 5.47 Fire Hydrant & Gas Wells $ 10.59 Fire Hydrant & Gas Wells $ 10.73 Supplemental Irrigation $ 10.59 Supplemental Irrigation $ 10.73 Reclaimed o ume Charge per 1,000 gallons (tgals) Reclaimed o ume arge per 1,000 gallons (tgals) Non -Boosted $ 1.88 Non -Boosted $ 1.97 Boosted Tiered Rates Boosted Tiered Rates 0-8 tgals $ 4.58 0-8 tgals $ 4.65 9-15 tgals $ 4.79 9-15 tgals $ 4.85 16-35 tgals $ 5.25 16-35 tgals $ 5.30 Over 35 tgals $ 5.76 Over 35 tgals $ 5.81 Construction & Gas Wells $ 9.00 Construction & Gas Wells $ 9.12 24 WASTEWATER SERVICE RATES Current Rates: Proposed Rates: Kesidential BaseCharge: Residential Base arge: Base Charge: Base Charge: Within Corporate Limits $ 11.00 Within Corporate Limits $ 11.00 Outside Corporate Limits $ 15.50 Outside Corporate Limits $ 15.50 Volume Charge per 1,000 gallons (tgals) Volume Charge per 1,000 gallons (tgals) (based on 90% of metered water up to 12,000 gallons) (based on 90% of metered water up to 12,000 gallons) Within Corporate Limits $ 4.29 Within Corporate Limits $ 4.34 Outside Corporate Limits $ 4.29 Outside Corporate Limits $ 4.34 Commercial and industrialCharges: Commercial and IndustrialCharges: Base Charge: Base Charge: Within Corporate Limits $ 11.00 Within Corporate Limits $ 11.00 Outside Corporate Limits $ 15.50 Outside Corporate Limits $ 15.50 Volume Charge per 1,000 gallons (tgals) Volume Charge per 1,000 gallons (tgals) (based on 100% of metered water) (based on 100% of metered water) Within Corporate Limits $ 4.29 Within Corporate Limits $ 4.34 Outside Corporate Limits $ 4.29 Outside Corporate Limits $ 4.34 W Water & Wastewater Expenditures 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 FY20 Budget to Water & Wastewater Actual Budget Estimated Budget FY21 Proposed Expenditures FY 19 FY 20 FY 20 FY 21 $ Diff % Diff. Water Office $ 472,825 $ 487,423 $ 484,023 $ 491,112 $ 3689 1% Total -Finance $ 472,825 $ 487,423 $ 484,023 $ 491,112 $ 3,689 1% City Engineer $ 328,762 $ 361,538 $ 339,528 $ 384,473 $ 22,935 6% Water Production $ 7,632,889 $ 8,384,552 $ 8,327,652 $ 9,127,526 $ 742,974 9% Water Distribution $ 1,101,944 $ 1,282,030 $ 1,273,030 $ 1,243,627 $ (38,403) (3%) Wastewater Treatment $ 4,970,323 $ 4,977,281 $ 5,856,027 $ 5,358,080 $ 380,799 8% Meter Services $ 66,902 $ 71,813 $ 70,313 $ 72,053 $ 240 0% Total -Public Works $ 14,100,820 $ 15,077,214 $ 15,866,550 $ 16,185,759 $ 1,108,545 7% Recycling $ 22,742 $ 41,300 $ 34,550 $ 40,100 $ (1,200) (3%) GIS/Information Services $ 627,879 $ 681,215 $ 673,285 $ 676,464 $ (4,751) (1%) Legal Services $ 57,908 $ 85,000 $ 85,000 $ 85,000 $ 0% Non -Departmental $ 8,843,677 $ 9,659,702 $ 9,435,381 $ 9,509,223 $ 150,479 2% Total -Non Departmental $ 9,552,206 $ 10,467,217 $ 10,228,216 $ 10,310,787 $ (156,430) (1%) Total Operating Expenses $ 24,125,851 $ 26,031,854 $ 26,578,789 $ 26,987,658 $ 955,804 4% Capital Expenses $ 290,293 $ 209,032 $ 40,088 $ 198,944 $ 10.088 5% Total Expenses $ 24,416,144 $ 26,240,886 $ 26,618,877 $ 27,186,602 $ 9455716 4% 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. Q-] 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. Enterprise Funds Actual FY 19 Budget FY 20 Estimated FY 20 Proposed Budget FY 21 FY20 Budget to FY21 Proposed $ Diff % Diff. Service Center Fund: Revenues $ 1,241,864 $ 1,333,623 $ 1,209,143 $ 1,212,265 $ (121,358) (9%) Operating Expenses $ 1,164,102 $ 1,333,623 $ 1,203,143 $ 1,212,265 $ (121,358) (9%) Use of Reserves $ - $ 142,750 $ 109,250 $ 27,500 $ (115,250) (81 %) Capital Expenses $ 70,573 $ 142,750 $ 115,250 $ 27,500 $ (115,250) (81%) Drainage Utility System: Revenues $ 830,811 $ 834,500 $ 834,500 $ 837,200 $ 2,700 0% Operating Expenses $ 761,789 $ 832,950 $ 754,288 $ 834,563 $ 1,613 0% Use of Reserves $ - $ 50,000 $ - $ 100,000 $ 50,000 100% Capital Expenses $ 80,000 $ 50,000 $ 50,000 $ 100,000 $ 50,000 100% Recreation Classes: Revenues $ 792,851 $ 748,530 $ 428,530 $ 787,027 $ 38,497 5% Operating Expenses $ 670,052 $ 734,119 $ 557,772 $ 697,935 $ (36,184) (5%) Use of Reserves $ - $ 246,862 $ 376,104 $ - $ (246,862) (100%) Capital Expenses $ 78,258 $ 246,862 $ 246,862 $ - $ (246,862) (100%) Arbor Daze: Revenues $ 60,717 $ 80,000 $ 4,407 $ 25,583 $ (54,417) (68%) Operating Expenses $ 60,247 $ 80,000 $ 4,230 $ 80,000 $ - 0% Use of Reserves $ - $ - $ - $ 54,417 $ 54,417 0% Capital Expenses $ - $ - $ - $ - $ - 0% Texas Star Golf Course: Revenues $ 4,475,221 $ 4,694,475 $ 4,095,602 $ 4,629,475 $ (65,000) (1%) Operating Expenses $ 4,505,249 $ 4,688,712 $ 4,080,444 $ 4,606,455 $ (82,257) (2%) Use of Reserves $ 30,028 $ - $ - $ - $ - 0% Capital Expenses $ - $ - $ - $ - $ - 0% Texas Star Sports Complex: Revenues $ 1,212,218 $ 767,100 $ 698,657 $ 885,000 $ 117,900 15% Operating Expenses $ 955,082 $ 684,522 $ 641,090 $ 725,564 $ 41,042 6% Use of Reserves $ - $ 53,000 $ - $ - $ (53,000) (100%) Capital Expenses $ 64,899 $ 53,000 $ 53,000 $ - $ (53,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 Texas Star Sports Complex 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. Special Revenue Funds Actual FY 19 Budget FY 20 Estimated FY 20 Proposed Budget FY 21 FY20 Budget to FY21 Proposed $ Diff % Diff. Hotel/Motel: Revenues $ 853,718 $ 1,229,500 $ 649,190 $ 532,338 $ (697,162) (57%) Operating Expenses $ 767,807 $ 897,107 $ 616,650 $ 524,174 $ (372,933) (42%) Use of Reserves $ - $ 400,000 $ 292,460 $ - $ (400,000) (100%) Capital Expenses $ - $ 400,000 $ 325,000 $ - $ (400,000) (100%) Juvenile Case: Revenues $ 83,738 $ 86,675 $ 55,485 $ 54,000 $ (32,675) (38%) Operating Expenses $ 72,367 $ 85,618 $ 79,818 $ 90,658 $ 5,040 6% Use of Excess Reserves $ - $ 37,000 $ 25,333 $ 72,658 $ 47,325 128% Capital Expenses $ - $ 37,000 $ 1,000 $ 36,000 $ 35,000 95% EDC %¢ Sales Tax: Revenues $ 5,475,348 $ 5,543,964 $ 4,745,804 $ 4,985,335 $ (558,629) (10%) Operating Expenses $ 3,631,251 $ 4,714,162 $ 4,143,889 $ 4,671,893 $ (42,269) (1%) Use of Reserves $ - $ 2,448,109 $ 1,418,703 $ 794,757 $ (1,653,352) (68%) Capital Expenses $ 946,750 $ 2,448,109 $ 2,020,618 $ 794,757 $ (1,653,352) (68%) CCPD %0 Sales Tax: Revenues $ 2,691,484 $ 2,715,960 $ 2,206,668 $ 2,161,768 $ (554,192) (20%) Operating Expenses $ 2,606,076 $ 2,705,126 $ 2,651,914 $ 2,122,850 $ (582,276) (22%) Use of Reserves $ - $ 520,711 $ 901,722 $ 82,835 $. (437,876) (84%) Capital Expenses $ 73,712 $ 520,711 $ 456,476 $ 82,835 $ (437,876) (84%) Police Seized Assets Fund: Revenues $ 19,997 $ 4,000 $ 2,531 $ 1,000 $ (3,000) (75%) Operating Expenses $ 33,181 $ 61,506 $ 61,506 $ 34,104 $ (27,402) (45%) Use of Reserves $ 13,184 $ 57,506 $ 58,975 $ 33,104 $ (24,402) (42%) Capital Expenses $ - $ - $ - $ - $ _ - 0% Police Drug Fund: Revenues $ 29,800 $ 8,500 $ 12,328 $ 2,050 $ (6,450) (76%) Operating Expenses $ 12,128 $ 500 $ 500 $ 500 $ - 0% Use of Reserves $ - $ 178,662 $ - $ 178,662 $ - 0% Capital Expenses $ 11,320 $ 178,662 $ - $ 178,662 $ - 0% Grant Fund: Revenues $ 228,858 $ 71,362 $ 3,231,939 $ 64,061 $ (7,301) (10%) Operating Expenses $ 228,451 $ 71,362 $ 3,231,939 $ 64,061 $ (7,301) (10%) Use of Reserves $ - $ - $ - $ - $ - 0% Capital Expenses $ - $ - $ - $ - $ - 0% Car Rental Tax: Revenues $ 15,028,707 $ 14,840,131 $ 9,355,305 $ 7,395,408 $ (7,444,723) (50%) Operating Expenses $ 11,860,242 $ 11,863,244 $ 7,558,818 $ 5,825,929 $ (6,037,315) (51%) Use of Reserves $ 346,435 $ 3,581,159 $ 1,728,215 $ 1,253,466 $ (2,327,693) (65%) Capital Expenses $ 3,514,900 $ 3,581,159 $ 3,524,702 $ 1,253,466 $ (2,327,693) (65%) Glade Parks TIRZ: Revenues $ 1,641,646 $ 1,851,647 $ 1,641,886 $ 1,832,232 $ (19,415) (1%) Operating Expenses $ 1,130,268 $ 1,143,966 $ 1,143,966 $ 1,138,167 $ (5,799) (1 %) Use of Reserves $ - $ - $ - $ - $ - 0% Capital Expenses $ - $ - $ - $ - $ - 0% Cable PEG Fund: Revenues $ 125,343 $ 123,000 $ 119,012 $ 110,000 $ (13,000) (11%) Operating Expenses $ 29,665 $ 120,000 $ 120,000 $ 110,000 $ (10,000) (8%) Use of Reserves $ - $ 206,794 $ 207,782 $ - $ (206,794) (100%) Capital Expenses $ - $ 206,794 $ 206,794 $ - $ (206,794) (100%) 28 M Special Revenue Funds Actual FY 19 Budget FY 20 Estimated FY 20 Proposed Budget FY 21 FY20 Budget to FY21 Proposed $ Diff % Diff. Midtown PID: Revenues $ 1,115,183 $ 1,112,248 $ 994,247 $ 1,109,756 $ (2,492) (0%) Operating Expenses $ 1,097,769 $ 1,062,197 $ 1,062,197 $ 1,009,747 $ (52,450) (5%) Use of Reserves $ - $ - $ 67,950 $ - $ - 0% Capital Expenses $ - $ - $ - $ - $ - 0% Midtown TIRZ: Revenues $ 51,724 $ 100,009 $ 100,009 $ 399,989 $ 299,980 300% Operating Expenses $ - $ 51,701 $ 51,701 $ 100,009 $ 48,308 93% Use of Reserves $ - $ - $ - $ - $ - 0% Capital Expenses $ - $ - $ - $ - $ - 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) %0 Sales Tax Fund is used to account for the Y¢ 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/40 Sales Tax Fund is used to account for Y40 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 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 district will only assess property owners for the portion of the debt payment not covered with resources from the Glade Parks TIRZ. 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. Proposed FY20 Budget to Internal Service Actual Budget Estimated Budget FY21 Proposed Funds FY 19 FY 20 FY 20 FY 21 $ Diff % Diff. Equipment Replacement: Revenue $ 2,115,312 $ 6,924,657 $ 7,226,224 $ 4,222,819 $ (2,701,838) (39%) Operating Expenses $ 1,133,359 $ 1,634,500 $ 1,370,392 $ 1,472,500 $ (162,000) (10%) Use of Excess Reserves $ - $ - $ - $ - $ - - Insurance Revenue $ 6,942,518 $ 7,704,525 $ 7,704,525 $ 7,282,014 $ (422,511) (5%) Operating Expenses $ 6,232,226 $ 7,631,683 $ 7,631,683 $ 7,253,937 $ (377,746) (5%) Use of Reserves $ - $ - $ - $ - $ - 0% Capital Expenses $ - $ - $ - $ - $ - 0% Risk/WC Management Revenue $ 1,087,152 $ 1,028,800 $ 1,028,800 $ 1,045,308 $ 16,508 2% Operating Expenses $ 1,223,658 $ 1,027,125 $ 1,027,125 $ 1,028,467 $ 1,342 0% Use of Reserves $ 238,608 $ 170,000 $ - $ 170,000 $ - 0% Capital Expenses $ 102,102 $ 170,000 $ - $ 170,000 $ - 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 �i 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 L. 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 Actual FY 19 Budget FY 20 Estimated FY 20 Proposed Budget FY 21 FY20 Budget to FY21 Proposed $ Diff % Diff. General Obligation Debt Revenues $ 6,404,356 $ 6,023,137 $ 6,053,137 $ 6,000,969 $ (22,168) (0%) Operating Expenses $ 5,903,119 $ 6,070,199 $ 6,070,199 $ 6,070,834 $ 635 0% Use of Reserves $ - $ 47,062 $ 17,062 $ 69,865 $ 22,803 48% Star Center Debt Revenues $ 708,790 $ 713,803 $ 713,803 $ 715,896 $ 2,093 0% Operating Expenses $ 708,790 $ 709,303 $ 709,303 $ 712,896 $ 3,593 1% Use of Reserves $ - $ - $ - $ - $ - 0% EDC Debt Service Revenues $ 160,465 $ 442,664 $ 442,664 $ 394,605 $ (48,059) (11 %) Operating Expenses $ 160,435 $ 442,664 $ 442,664 $ 394,605 $ (48,059) (11%) Use of Reserves $ - $ - $ - $ - $ - 0% Water & Wastewater Debt Revenues $ 1,437,987 $ 1,489,617 $ 1,489,617 $ 1,220,326 $ (269,291) (18%) Operating Expenses $ 1,174,291 $ 1,489,617 $ 1,489,617 $ 1,219,826 $ (269,791) (18%) Use of Reserves $ - $ - $ - $ - $ - 0% Texas Star Golf Course Debt Revenues $ 590,058 $ 589,566 $ 589,811 $ 594,125 $ 4,559 1% Operating Expenses $ 589,040 $ 589,566 $ 589,566 $ 594,566 $ 5,000 1% Use of Reserves $ - $ - $ - $ 441 $ 441 0% Debt Service funds are used to account for the repayment of General Obligation Bonds, Certificates of Obligation, Taxable Bonds, 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, and Certificates of Obligation. The Star Center Debt Fund is used to account for monthly lease payments on the Dr. Pepper 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 %¢ 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 Full -Time Personnel Counts FY 18/19 FY 19120 FY 19120 FY 20121 ACTUAL BUDGETED ESTIMATED BUDGETED CITY ADMINISTRATION 3.50 3.50 3.50 3.00 D CITY SECRETARY 3.50 3.50 3.50 3.50 Total City Administration 7.00 7.00 7.00 6.50 V FINANCE/BUDGET 2.00 2.00 2.00 1.50 E MUNICIPAL COURTS 7.75 7.75 7.75 7.75 ACCOUNTING 4.00 4.00 4.00 3.50 G PURCHASING 1.00 1.00 1.00 1.00 Total Finance 14.75 14.75 14.75 13.75 POLICE CODE COMPLIANCE 15.00 B 16.00 16.00 16.00 POLICE ADMINISTRATION 6.00 6.00 7.00 C 7.00 POLICE PATROL 45.00 45.00 45.00 49.00 F POLICE CID 13.00 13.00 13.00 14.00 H POLICE SERVICE 22.00 22.00 22.00 21.00 H POLICE DETENTION 17.00 17.00 17.00 17.00 Total Police Department 118.00 119.00 120.00 124.00 FIRE MARSHAUEDUCATION 4.00 4.00 4.00 4.00 FIRE ADMINISTRATION 4.00 4.00 4.00 4.00 EMS/SUPPRESSION 67.00 67.00 67.00 67.00 Total Fire Department 75.00 75.00 75.00 75.00 INFORMATION SERVICES 1.00 1.00 1.00 1.00 HUMAN RESOURCES 3.50 3.50 3.50 3.50 FACILITY MAINTENANCE 4.00 4.00 4.00 4.00 Total Administrative Services 8.50 8.50 8.60 8.50 LIBRARY 9.00 9.00 9.00 9.00 Total Library 9.00 9.00 9.00 9.00 PLANNING & DEVELOPMENT 2.50 2.50 2.50 2.50 INSPECTIONS SERVICES 4.00 4.00 4.00 4.00 Total Planning & Development 6.50 6.50 6.50 6.50 RECREATION 6.50 6.50 5.50 C 5.50 PARKS 11.00 11.00 11.00 11.00 SENIOR CENTER 2.00 2.00 2.00 2.00 RECREATION ADMINISTRATION 1.00 1.00 1.00 1.00 Total Community Services 20.50 20.50 19.50 19.50 STREET MAINTENANCE 11.50 11.50 11.50 11.50 ANIMAL CONTROL 3.00 3.00 3.00 3.00 CITY ENGINEER 1.00 1.00 1.00 1.00 Total Public Works 15.50 15.50 15.50 15.50 GF NON -DEPARTMENTAL 0.00 0.00 0.00 0.00 Total Non -departmental 0.00 0.00 0.00 0.00 TOTAL GENERAL FUND 274.75 275.75 275.75 278.25 EDC - PARKS 13.25 13.25 13.25 13.25 EDC - LIBRARY 10.00 10.00 10.00 10.00 EDC - ECO. DEV. 1.00 1.00 1.00 1.00 TOTAL EDC FUND 24.25 24.26 24.25 24.25 WATER OFFICE 5.00 5.00 5.00 5.00 Total Finance 5.00 5.00 5.00 6.00 W&S ENGINEERING 3.00 3.00 3.00 3.00 WATER PRODUCTION 5.75 5.75 5.75 5.75 WATER DISTRIBUTION 7.25 7.25 7.25 7.25 SEWAGE & TREATMENT 7.00 A 8.00 8.00 8.00 METER SERVICES 1.00 1.00 1.00 1.00 Total Public Works 24.00 26.00 25.00 25.00 INFORMATION SERVICES 4.00 4.00 4.00 4.00 W&S NON-DEPT. 10.00 10.00 10.00 9.50 D,E&G Total Non -departmental 14.00 14.00 14.00 13.50 TOTAL W&S FUND 43.00 44.00 44.00 43.50 GOLF NON DEPARTMENTAL 0.75 0.75 0.75 0.75 GOLF COURSE MAINT. 4.00 4.00 4.00 4.00 GOLF PRO SHOP 2.50 2.50 2.50 2.50 GOLF FOOD AND BEVERAGE 3.00 3.00 3.00 3.00 GOLF CONFERENCE CENTRE 1.50 1.50 1.50 1.50 TOTAL GOLF COURSE FUND 11.75 11.75 11.75 11.75 JUVENILE CASE FUND 1.25 1.25 1.25 1.25 CRIME CONTROL FUND 19.00 19.00 19.00 15.00 F PUBLIC SAFETY SPECIAL FUND 0.00 0.00 0.00 0.00 SERVICE CENTER FUND 5.00 5.00 5.00 5.00 DRAINAGE UTILITY FUND 8.00 8.00 8.00 8.00 TEXAS STAR SPORTS COMPLEX 1.50 1.50 1.50 1.50 HEALTH INSURANCE FUND 1.00 1.00 1.00 1.00 WC/RISK MANAGEMENT FUND 0.50 0.50 0.50 0.50 TOTAL OTHER FUNDS 36.25 36.25 36.25 32.25 TOTAL ALL FUNDS 390.00 392.00 392.00 390.00 A) Added 1 PW Feld Tech I B) Added 1 Code Enforcement Officer C) Transferred Rec Assistant to PO Emergency Management Special Projects Assistant D) Unfunded Assistant City Manager Positron E) Unfunded Internal Auditor Positron F) Transferred 4 Police Officers from CCPD to General Fund G) Split Budget/Treasury Manager between General Fund and Water & Wastewater Fund H) Transferred Records Clerk to Crime Scene Technician 32 Outstanding Indebtedness Principal Amount of Description Dated Amount Original Paying Agent Remaining Maturity Interest Rate Outstanding Issuance General Obligation Refunding Bonds, Series 2011 1/15/2011 $ 860,000 $ 6,575,000 U.S. Bank 3.5% to 4% 8/15/2021 General Obligation Refunding Bonds, Series 2012 12/1/2011 $ 2,045,000 $ 5,955,000 U.S. Bank 3%to4% 2/15/2024 Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of Obligation, 1/15/2011 $ 1,925,000 $ 3,035,000 U.S. Bank 3% to 4.25% 8/15/2030 Series 2011' Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of Obligation, 10/15/2014 $ 4,770,000 $ 5,715,000 U.S. Bank 3% to 5% 8/15/2034 Series 2014' Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of Obligation, 10/27/2015 $ 2,665,000 $ 3,030,000 U.S. Bank 3% to 5% 2/15/2035 Series 2015' Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of 1/12/2016 $ 15,025,000 $ 16,450,000 U.S. Bank 2%to 4% 2/15/2041 Obligation, Series 2016' Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of 3/1/2018 $ 8,620,000 $ 9,180,000 U.S. Bank 3% to 4% 2/15/2038 Obligation, Series 2018' Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of 1/15/2019 $ 11,590,000 $ 11,785,000 U.S. Bank 3% to 5% 2/15/2039 Obligation, Series 2019 Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of 1/14/2020 $ 7,115,000 $ 7,115,000 U.S. Bank 2%to 3.5% 2/15/2040 Obligation, Series 2020 Tax Notes Series 2020 6/25/2020 $ 1,110,000 $ 1,110,000 Citizens Bank 1.07% 2/15/2023 Taxable General Obligation Refunding Bonds, Series 20102 8/15/2010 $ 3,135,000 $ 8,110,000 U.S. Bank 3.65% to 4.4% 8/1/2025 General Obligation Refunding Bonds, Series 11/1/2012 $ 3,805,000 $ 7,185,000 U.S. Bank 2%to 3% 2/15/2027 2012A3 Waterworks & Sewer System Revenue Refunding Bonds, Series 20124 3/29/2012 $ 535,000 $ 3,340,000 Bank of Texas 2.03% 7/15/2024 Waterworks & Sewer System Revenue Bonds, Series 20134 6/25/2013 $ 1,150,000 $ 1,585,000 U.S. Bank 3% to 5% 7/15/2033 Waterworks & Sewer System Revenue Texas Water 8/5/2015 $ 3,585,000 $ 4,685,000 Development 0%to 1.98% 7/15/2035 Bonds, Series 2015A Board Waterworks & Sewer System Revenue Texas Water Bonds, Series 20158 8/5/2015 $ 1,900,000 $ 2,380,000 Development 0%to 1.68% 7/15/2035 Board Waterworks & Sewer System Revenue Texas Water Bonds, Series 2018 4/15/2018 $ 2,530,000 $ 2,785,000 Development 0% to 1.49% 7/15/2038 Board Waterworks &Sewer System Revenue Texas Water Bonds, Series 2019 4/25/2019 $ 9,025,000 $ 9,275,000 Development 0.23%to 1.66% 7/15/2049 Board Euless Development Corporation, Sales Tax 10/15/2018 $ 1,505,000 $ 1,635,000 U.S. Bank 3% to 4% 9/15/2038 Revenue Bonds, Series 2018 Euless Development Corporation, Sales Tax 11/12/2019 $ 3,945,000 $ 4,120,000 U.S. Bank 2.5% to 4% 9/15/2039 Revenue Bonds, Series 2019 AXON Enterprise, Inc. Lease 1 10/25/2018 $ 418,912 $ 674,906 AXON 3% Imputed 2/7/2023 Enterprise, Inc. Proposed Indebtedness Proposed Anticipated Proposed Description Issuance Proposed Payment Issuance Proposed Amount Sale Type Source Date Term Certificates of Obligation - Street Reconstruction g $ 5,500,000 Competitive Property Tax October 2020 20 Year Sale Anticipation Notes - Equipment Package $ 1,680,000 Competitive Property Tax June 2021 1 3 Year Fax Sale ' Bonds paid by Tax Increment Financing District & Public Improvement District. z Bonds paid by rental income from Dallas Stars Center. 3 Remaining Bonds paid by Texas Star Golf Course. Bonds paid by Water & Wastewater user charges. s Bonds partially paid by Tax Increment Financing District and Public Improvement District. 33 Capital & Supplemental Requests FY2021 by Fund Department 'Fund Program Description Program Type Program Cost Total Planning & Development General 2021 International Building Codes Capital $ 3,800 $ 3,800 Fire General Part -Time Fire Inspector(s) Capital $ 34,500 $ 38,300 Pttb is Works General Street Overlay Capital $ 1,000,000 $ 1,038,300 PACS General Arbor Daze Capital $ 25,583 $ 1,063,883 V01b au-5 Fleet-&-Fai'Itiiies General Transfer to Equipment Replacement Capital $ 1,326,311 $ 2,390,194 Nen-BepaftnwMl, General One-time adjustment Capital $ 543,257 $ 2,933,451 ,t vp-Crnus 1-gepertmeT4Ca1. General Contingency Capital $ 250,000 $ 3,183,451 A( 0-0 � ,r Non -Departmental General FEMA Match Capital $ 150,000 $ 3,333,451 Planning & Development EDC Building Remodel Capital $ 70,000 $ 70,000 Planning & Development EDC Temporary Library Bldg. Remodel Capital $ 100,000 $ 170,000 Planning & Development EDC Transfer to EDC CIP - EDC Incentive Capital $ 25,000 $ 195,000 PACS EDC Transfer to EDC CIP - Irrigation Capital $ 25,000 $ 220,000 PACS EDC Transfer to EDC CIP - Misc. Parks Improvements Capital $ 200,000 $ 420,000 Police CCPD Assorted Police Equipment Capital $ 82,835 $ 82,835 Non -Departmental Car Rental Transfer to Redevelopment CIP Capital $ 750,000 $ 750,000 Non -Departmental Car Rental Transfer to Golf Course CIP Fund Capital $ 50,000 $ 800,000 Public Works W/WW Paint Fire Hydrants Capital $ 30,000 $ 30,000 Public Works Drainage Utility Transfer to Drainage CIP Capital $ 100,000 $ 100,000 r < ^. ; r a - r e ?ll `f ►�(. /LQ� h fl lJ�4f� G� f r ccf' r �,� p�'til �. "..�{,!�} � - �{-[ � Ord' 'l c4,C'✓Y 34 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 FY 19 FY 20 FY 21 1. Notices required by law to be published in a newspaper by the political subdivision or a representative of the political subdivision: $ 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: $ 2,219 $ 2,285 $ 3,350 35 Table of Contents Preliminary Annual Operating Budget Fiscal Year 2020-2021 Supplementary Information Introduction Capital, Infrastructure Plans Et Fleet/ Equipment Purchases Debt Personnel Et Insurance Historical Et Comparison Data INTRODUCTION Organizational Chart Budget Process Budget Schedule Excerpt from Charter Fiscal Policies `., M ORGANIZATIONAL CHART T H E C I T Y O F EULESS CITIZENS OF EULESS MAYOR & COUNCIL CITY ATTORNEY I I CITY SECRETARY Wayne K. Olson Kim Sutter DEPUTY CITY MANAGER Chris Barker DIRECTOR OF PUBLIC WORKS Hal Cranor I DIRECTOR OF PLANNING AND ECONOMIC DEVELOPMENT Mike Collins FLEET AND FACILITIES DIRECTOR Kyle McAdams INFORMATION SERVICES DIRECTOR I Scott Joyce LIBRARY DIRECTOR Sherry Knight GENERAL MANAGER TEXAS STAR Glenda Hartsell -Shelton MUNICIPAL COURT MANAGER Claudia Quintero Lo etta Getchell, City Manager July 13, 2020 CITY MANAGER II�� Loretta Getchell I i MUNICIPAL COURT JUDGE I MUNICIPAL COURT Lacy Britten ASSISTANT TO THE CITY MANAGER Betsy Deck POLICE CHIEF Mike Brown FIRE CHIEF Wes Rhodes DIRECTOR OF PARKS AND COMMUNITY SERVICES Ray McDonald DIRECTOR OF FINANCE Janina Jewell DIRECTOR OF HUMAN RESOURCES AND RISK Donny Beasley 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: 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. (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. 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 VI I, 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 4.. 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 M 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 August 1 st, the City Council plans to review the preliminary operating and capital budgets. At their City Council meeting on August 3rd, the Euless City Council plans to set a date, time, and place for the budget public hearing on August 17t". City Council will consider adoption of the Budget on August 24t". After the budget adoption, the Finance Department prepares a monthly financial report which is presented to the City Council for their review. 1-4 FY2020-2021 Budget Schedule* DATE RESPONSIBILITY ACTION Hold Public Hearing on CCPD Budget. Adopt Thursday, May 28, 2020 CCPD Board FY2021 CCPD Budget. Submit CCPD Budget to City Council. Thursday, May 28, 2020 CC Receive CCPD Budget. Special called meeting at 6:OOP.M. Thursday, May 28, 2020 CC, CMO & Department Heads Pre -Budget Work Session at 6:15P.M. Monday, June 29, 2020 CC, CMO & Finance Pre -Budget Work Session Saturday, August 1, 2020 CC, CMO & Finance Budget Work Session Special Called City Council Meeting to set date Monday, August 3, 2020 CC for Tax Rate Public Hearing on August 17th and Vote to place a Proposal to Adopt a Specific Tax Rate on August 24th. Monday, August 10, 2020 EDC Board Hold Public Hearing on EDC Budget and Adopt FY2021 EDC Budget. Tuesday, August 11, 2020 CC Hold Public Hearing on FY2021 CCPD Budget. Approve CCPD FY2021 Budget. Special Called City Council Meeting to hold Monday, August 17, 2020 CC Public Hearing on City and EDC Budget and Public Hearing on Tax Rate & Order Election, if necessary. Regular City Council Meeting to Adopt Budget Monday, August 24, 2020 CC and Tax Rate. Adopt Tax Roll. Ratify Revenue Increase if Necessary. Adopt Fee/Rate Changes if Necessary. Tentative Subject to Change M 1-5 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 1102.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 ¶L05 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, VT 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. 111.1 State law reference — Budget, V.T.C.A., Local Government Code ¶ 102.001 et seq. 1-6 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 1102.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-7 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 a comprehensive annual financial report (CAFR). The CAFR 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-8 CAFR 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. Objective — 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-9 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. E uit — 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. 1-10 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 — 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. am 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. Vll. 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 Management — 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. IX. 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. 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. 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. 1-12 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: • 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) 1-13 • 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-14 CAPITAL, INFRASTRUCTURE PLANS Et �. FLEET/EQUIPMENT REPLACEMENT Capital Et Supplemental Requests by Fund Capital Et Supplemental Requests by Department FY2020-21 Infrastructure Plan Memo, Projected Equipment Replacement Fund Fleet and Equipment Transfers Proposed Unit Replacements I..", Capital & Supplemental Requests FY2021 by Fund Department 'Fund Program Description Program Type Program Cost Total Planning & Development General 2021 International Building Codes Capital $ 3,800 $ 3,800 Fire General Part -Time Fire Inspector(s) Capital $ 34,500 $ 38,300 Public Works General Street Overlay Capital $ 1,000,000 $ 1,038,300 PACS General Arbor Daze Capital $ 25,583 $ 1,063,883 Fleet & Facilities General Transfer to Equipment Replacement Capital $ 1,326,311 $ 2,390,194 Non -Departmental General One-time adjustment Capital $ 543,257 $ 2,933,451 Non -Departmental General Contingency Capital $ 250,000 $ 3,193,451 Non -Departmental General FEMA Match Capital $ 150,000 $ 3,333,451 Planning & Development EDC Building Remodel Capital $ 70,000 $ 70,000 Planning & Development EDC Temporary Library Bldg. Remodel Capital $ 100,000 $ 170,000 Planning & Development EDC Transfer to EDC CIP - EDC Incentive Capital $ 25,000 $ 195,000 PACS EDC Transfer to EDC CIP - Irrigation Capital $ 25,000 $ 220,000 PACS EDC Transfer to EDC CIP - Misc. Parks Improvements Capital $ 200,000 $ 420,000 Police CCPD Assorted Police Equipment Capital $ 82,835 $ 82,835 Non -Departmental Car Rental Transfer to Redevelopment CIP Capital $ 750,000 $ 750,000 Non -Departmental Car Rental Transfer to Golf Course CIP Fund Capital $ 50,000 , $ 800,000 Public Works W/WW Paint Fire Hydrants Capital $ 30,000 $ 30,000 Public Works Drainage Utility Transfer to Drainage CIP Capital $ 100,000 $ 100,000 2-1 Department *Fund Capital & Supplemental Requests FY2021 by Department Program Description Program Type Program Cost Total Fire General Part -Time Fire Inspector(s) Capital $ 34,500 $ 34,500 Fleet & Facilities General Transfer to Equipment Replacement Capital $ 1,326,311 $ 1,326,311 Non -Departmental General One-time adjustment Capital $ 543,257 $ 543,257 Non -Departmental General Contingency Capital $ 250,000 $ 793,257 Non -Departmental General FEMA Match Capital $ 1S0,000 $ 943,257 Non -Departmental Car Rental Transfer to Redevelopment CIP Capital $ 750,000 $ 1,693,257 Non -Departmental Car Rental Transfer to Golf Course CIP Fund Capital $ 50,000 $ 1,743,257 PACS General Arbor Daze Capital $ 25,583 $ 25,583 PACS EDC Transfer to EDC CIP - Irrigation Capital $ 25,000 $ 50,583 PACS EDC Transfer to EDC CIP - Misc. Parks Improvements Capital $ 200,000 $ 250,583 Planning & Development General 2021 International Building Codes Capital $ 3,800 $ 3,800 Planning & Development EDC Building Remodel Capital $ 70,000 $ 73,800 Planning & Development EDC Temporary Library Bldg. Remodel Capital $ 100,000 $ 173,800 Planning & Development EDC Transfer to EDC CIP - EDC Incentive Capital $ 25,000 $ 198,800 Police CCPD Assorted Police Equipment Capital $ 82,835 $ 82,835 Public Works General Street Overlay Capital $ 1,000,000 $ 1,000,000 Public Works W/WW Paint Fire Hydrants Capital $ 30,000 $ 1,030,000 Public Works Drainage Utility Transfer to Drainage CIP Capital $ 100,000 $ 1,130,000 ls� 2-2 �..- FY2020-21 INFRASTRUCTURE PLAN STREET MAINTENANCE PLAN Street maintenance includes material and labor for 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 staffs 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. M 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, conversion of hardwired vehicle detection to video detection, replacement of antiquated flashers and other miscellaneous related items. 2-3 �- MEMO TO: Loretta Getchell, City Manager FROM: Kyle McAdams, Fleet and Facility Director DATE: July 25, 2020 SUBJECT: Projected Equipment Replacement Fund Beginning working capital available as of October 1, 2019 $4,795,849 REVENUE: Depreciation $6,267,726 Issuance Proceeds $700,000 Transfer from Car Rental Tax Fund $145,520 Salvage Sales (estimated) $23,840 Interest/Misc. $89,138 Total Revenues: $7,226,224 TOTAL FUNDS AVAILABLE $12,022,073 EXPENSES: Replacement Vehicles $1,370,392 Total Expenses: $1,370,392 ESTIMATED ENDING BALANCE SEPTEMBER 30, 2020 $10,651,681 ESTIMATED REVENUE Depreciation $2,562,590 Tax Anticipation Notes $1,600,000 Salvage Sales (estimated) $40,229 Interest $20,000 Total Revenues: $4,222,819 ESTIMATED TOTAL FUNDS AVAILABLE: $14,874,500 ESTIMATED EXPENSES: Replacement Vehicles $1,051,000 Replacement Equipment $411,000 Alternative Fuel Conversion $10,500 Total Expenses: $1,472,500 ESTIMATED ENDING BALANCE SEPTEMBER 30, 2021 $13,402,000 2-4 M City of Euless : Fleet Transfer Budget Year 2020 - 2021 Department Name Administration Police / Code Compliance Police / Administration Police / Patrol Police / C.I.D. Police / Service Police / Detention Fire / Edu Prev. / Marshall Fire / EMS / Suppression Facility Maintenance Planning Recreation Parks Animal Control Streets Total General Fund: City Engineer Water Production Water Distribution Sewer & Treatment Total Water & Wastewater: EDC Parks (Tx Star) Fleet Services Drainage Utility Texas Star Sports Complex Texas Star Golf Course Account Code 101-1011-513 101-3025-521 101-3045-521 101-3046-521 101-3047-521 101-3048-521 101-3049-521 101-4023-522 101-4041-522 101-5037-519 101-6034-540 101-7051-550 101-7052-550 101-8033-531 101-8033-531 501-8066-531 501-8071-531 501-8072-531 501-8073-531 9601 9601 9601 9601 9601 9601 9601 9601 9601 9601 9601 9601 9601 9601 9601 9601 9601 9601 9601 210-1052-550 9601 504-5090-519 9601 510-8029-531 9601 530-7050-550 9601 540-7060-550 9601 City Total: Depreciation Depreciation Depreciation @ 100% @ 60% @ 40% $2,154 $ 1,292 $ 862 $15,397 $ 9,238 $ 6,159 $8,321 $ 4,993 $ 3,328 $240,222 $ 144,133 $ 96,089 $21,269 $ 12,761 $ 8,508 $16,141 $ 9,685 $ 6,456 $1,778 $ 1,067 $ 711 $35,800 $ 21,480 $ 14,320 $551, 893 $ 331,136 $ 220,757 $22,688 $ 13,613 $ 9,075 $9,872 $ 5,923 $ 3,949 $23,842 $ 14,305 $ 9,537 $146,074 $ 87,644 $ 58,430 $14,545 $ 8,727 $ 5,818 $140,574 $ 84,344 $ 56,230 $1,250,570 $ 750,341 $ 500,229 $7,410 $3,364 $98,451 $46,207 $155,432 $5, 500 $5,043 $4,600 $3,700 $330,141 $ 198,085 $ 132,056 $1,754,986 $ 948,426 $ 632,285 2-5 City of Euless : Misc. Equipment Transfer Budget Year 2020 - 2021 Department Name Account Code Depreciation Depreciation Depreciation @ 100% @ 60% @ 40% Finance -Purchasing 101-5036-519 9601 $2,000 $ 1,200 $ 800 Police/Administration 101-3045-521 9601 $3,000 $ 1,800 $ 1,200 Police / Patrol 101-3046-521 9601 $116,250 $ 69,750 $ 46,500 Police / C.I.D. 101-3047-521 9601 $867 $ 520 $ 347 Police / Service 101-3048-521 9601 $8,950 $ 5,370 $ 3,580 Police / Detention 101-3049-521 9601 $4,550 $ 2,730 $ 1,820 Police / EOC 101-3024-521 9601 $15,233 $ 9,140 $ 6,093 Police / CCPD - Patrol 101-3046-521 9601 $87,367 $ 52,420 $ 34,947 Fire/Administration 101-4023-522 9601 $15,167 $ 9,100 $ 6,067 Fire / Safety & Training 101-4023-522 9601 $3,000 $ 1,800 $ 1,200 Fire / EMS 101-4041-522 9601 $3,708 $ 2,225 $ 1,483 Fire / Suppression 101-4041-522 9601 $46,539 $ 27,923 $ 18,616 Facility Maintenance 101-5037-519 9601 $28,633 $ 17,180 $ 11,453 Recreation - Adm. 101-7084-550 9601 $6,000 $ 3,600 $ 2,400 Recreation EFLAP 101-7051-550 9601 $107,644 $ 64,586 $ 43,058 Recreation - ELFC NAT 101-7052-550 9601 $6,300 $ 3,780 $ 2,520 Recreation - Splash 101-7052-550 9601 $6,706 $ 4,024 $ 2,682 Recreation - Senior Center 101-7052-550 9601 $29,468 $ 17,681 $ 11,787 Public Works - Yard Equip. 101-8033-531 9601 $19,557 $ 11,734 $ 7,823 Information Services 101-5016-519 9601 $17,714 $ 10,628 $ 7,086 Total General Fund. $528,653 $ 317,191 $ 211,462 Euless Development Corp. Westpark 210-1052-550 9601 $5,433 Bob Eden 210-1052-550 9601 $3,642 VOBC 210-1052-550 9601 $6,500 Midway 210-1052-550 9601 $7,871 Heritage 210-1052-550 9601 $5,433 Trailwood 210-1052-550 9601 $4,500 Preserve 210-1052-550 9601 $13,714 McCormick 210-1052-550 9601 $4,952 Blessing Branch 210-1052-550 9601 $1,571 Total EDC $53,617 Fleet Services 504-5090-519 9601 $13,739 Special Rec Fund 520-7055-550 9601 $82,949 Texas Star Sports Complex 550-7078-550 9601 $19,462 Softball World 530-7050-550 9601 $8,027 $27,488 Texas Star / Golf Operations 540-7062-550 9601 $54,401 $ 32,640 $ 21,761 Texas Star / Conf. Center 540-7068-550 9601 $21,340 $ 12,804 $ 8,536 Texas Star / Grille Operations 540-7067-550 9601 $25,416 $ 15,250 $ 10,166 Texas Star Golf & Conference: $101,157 $ 60,694 $ 40,463 Depreciated @ 100% City Total: $807,604 $ 377,885 $ 251,925 2-6 CITY OF EULESS: ESTIMATED FLEET REPLACEMENTS - FY2021 UNIT CURRENT -- CURRENT -- PLANNED UNIT # YEAR AGE MILEAGE VEHICLE TYPE DEPT. REPLACEMENTS 848 2008 13 93,637 FORD 1/2T PICKUP PW - STREETS $ 35,000 855 2009 12 90,495 CHEVROLET 1T FLATBED PW - STREETS $ 42,000 887 2011 10 1,690 KUBOTA MOWER PARKS $ 20,000 886 2011 10 1,180 KUBOTA MOWER SBW $ 20,000 TBD 2016 5 POLICE PATROL UNIT PD - PATROL $ 60,000 TBD 2016 5 POLICE PATROL UNIT PD - PATROL $ 60,000 TBD 2016 5 POLICE PATROL UNIT PD - PATROL $ 60,000 TBD 2017 4 POLICE PATROL UNIT PD - PATROL $ 60,000 TBD 2017 4 POLICE PATROL UNIT PD - PATROL $ 60,000 824 2007 14 82,830 FORD 1/2T PICKUP PD-CODE $ 35,000 284 2014 7 71,715 FORD / FRASER MICU UNIT FD - EMS $ 290,000 001 2014 7 KUBOTA RTV500 UTILITY CART TX STAR GC $ 12,000 112 2015 6 TORO REELMAST€R 3100D TX STAR GC $ 41,000 117 2015 6 TORO REELMASTER 5510D TX STAR GC $ 84,000 192 2015 6 TORO REELMASTER 5510D TX STAR GC $ 84,000 351 2015 6 TORO REELMASTER 3100D TX STAR GC $ 41,000 836A 2015 6 TORO MULTI -PRO 1750 SPRAYER TX STAR GC $ 47,000 TOTAL FY2021: $ 1,061,000 \11 2-7 CITY OF EULESS: ESTIMATED MISC. ASSET REPLACEMENTS - FY2021 UNIT LOCATION -- CURRENT -- UNIT I PLANNED YEAR AGE DEPT. ASSIGNED ASSET TYPE COUNT REPLACEMENT 2012 9 FIRE ADMIN TREADMILLS 2 $ 16,000 NEW FIRE ADMIN FURNITURE REPLACEMENT MISC $ 4,500 2005 16 FIRE SUPPRESSION THERMAL IMAGING UNIT 2 $ 24,000 NEW FIRE SUPPRESSION THERMAL IMAGING UNIT 2 $ 50,000 NEW FIRE SUPPRESSION HYDRAULIC TOOL SET 1 $ 40,000 NEW FIRE SUPPRESSION HANDTOOL REPLACMENT PACKAGE 1 $ 10,000 NEW FIRE SUPPRESSION HYDROCARBON SNIFFER 1 $ 2,500 NEW FIRE EMS NARCOTIC SAFES 3 $ 6,000 NEW FIRE FIRE MARSHAL CODE BOOKS SET $ 4,000 NEW FIRE FIRE MARSHAL REPLACEMENT CAMERA 1 $ 3,000 2016 5 PACS EFLCFIT RECUMBENT BIKES SET $ 17,000 2016 5 PACS EFLCFIT ELIPTICALS SET $ 18,000 2016 5 POLICE CCPD SWAT VESTS SET $ 39,000 2011 10 POLICE JAIL REFRIGERATOR 1 $ 7,000 2011 10 POLICE JAIL WASHER & DRYER 1 $ 26,000 2011 10 POLICE JAIL FREEZER 1 $ 5,000. 2016 5 POLICE PATROL ACTIVE SHOOTER EQUIPMENT SET $ 130,000 ,- + 2011 10 TX STAR CONF. CNRT AV EQUIPMENT - TV UNITS 5 $ 9,000 TOTAL FY2021: $ 411,000 2-8 M 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 Et Wastewater Revenue Debt Sales Tax Revenue Debt Outstanding Indebtedness Principal Amount of Remaining Description Dated Amount Original Paying Agent Maturity Interest Rate Outstanding Issuance General Obligation Refunding Bonds, Series 1/15/2011 $ 860,000 $ 6,575,000 U.S. Bank 3.S% to 4% 8/15/2021 2011 General Obligation Refunding Bonds, Series 12/1/2011 $ 2,045,000 $ 5,955,000 U.S. Bank 3% to 4% 2/15/2024 2012 Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of Obligation, 1/15/2011 $ 1,925,000 $ 3,035,000 U.S. Bank 3%to4.25% 8/15/2030 Series 2011' Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of Obligation, 10/15/2014 $ 4,770,000 $ 5,715,000 U.S. Bank 3% to 5% 8/15/2034 Series 2014' Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of Obligation, 10/27/2015 $ 2,665,000 $ 3,030,000 U.S. Bank 3% to 5% 2/15/2035 Series 2015' Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of 1/12/2016 $ 15,025,000 $ 16,450,000 U.S. Bank 2%to 4% 2/15/2041 Obligation, Series 2016' Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of 3/1/2018 $ 8,620,000 $ 9,180,000 U.S. Bank 3% to 4% 2115/2038 Obligation, Series 20185 Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of 1/15/2019 $ 11,590,000 $ 11,785,000 U.S. Bank 3% to 5% 2/15/2039 Obligation, Series 2019 Tax & Waterworks & Sewer System (Limited Pledge) Revenue Certificates of 1/14/2020 $ 7,115,000 $ 7,115,000 U.S. Bank 2%to 3.5% 2/15/2040 Obligation, Series 2020 Tax Notes Series 2020 6/25/2020 $ 1,110,000 $ 1,110,000 Citizens Bank 1.07% 2/15/2023 Taxable General Obligation Refunding 8/15/2010 $ 3,135,000 $ 8,110,000 U.S. Bank 3.65% to 4.4% 8/1/2025 Bonds, Series 2010' General Obligation Refunding Bonds, Series 11/1/2012 $ 3,805,000 $ 7,155,000 U.S. Bank 2% to 3% 2/15/2027 2012A' Waterworks & Sewer System Revenue 3/29/2012 $ 535,000 $ 3,340,000 Bank of Texas 2.03% 7/15/2024 Refunding Bonds, Series 2012' Waterworks & Sewer System Revenue 6/25/2013 $ 1,150,000 $ 1,585,000 U.S. Bank 3% to 5% 7/15/2033 Bonds, Series 20134 Texas Water Waterworks & Sewer System Revenue 8/5/2015 $ 3,585,000 $ 4,685,000 Development 0% to 1.98% 7115/2035 Bonds, Series 2015A4 Board Texas Water Waterworks &Sewer System Revenue 8/5/2015 $ 1,900,000 $ 2,380,000 Development 0%to 1.68% 7/15/2035 Bonds, Series 20156' Board Texas Water Waterworks & Sewer System Revenue 4/15/2018 $ 2,530,000 $ 2,785,000 Development 0%to1.49% 7/15/2035 Bonds, Series 201S' Board Texas Water Waterworks & Sewer System Revenue 4/25/2019 $ 9,025,000 $ 9,275,000 Development 0.23% to 1.66% 7/15/2049 Bonds, Series 2014 Board Euless Development Corporation, Sales Tax 10/15/2018 $ 1,505,000 $ 1,635,000 U.S. Bank 3% to 4% 9/15/2038 Revenue Bonds, Series 2018 Euless Development Corporation, Sales Tax 11/12/2019 $ 3,945,000 $ 4,120,000 U.S. Bank 2.5%to 4% 9/15/2039 Revenue Bonds, Series 2019 AXON Enterprise, Inc. Lease 10/25/2018 $ 418,912 $ 674,906 AXON Enterprise, Inc. 3% Imputed 2/7/2023 Proposed Indebtedness Proposed Anticipated Proposed Description Issuance Proposed Payment Issuance Proposed Amount Sale Type Source Date Term Certificates of Obligation -Street Reconstruction $ 5,500,000 CompetitiveSale Property Tax October 2020 20 Year ax Anticipation Notes - Equipment Package $ 1,680,000 Competitive Sale Property Tax June 2021 1 3 Year ' Bonds paid by Tax Increment Financing District & Public Improvement District. Bonds paid by rental income from Dallas Stars Center. s Remaining Bonds paid by Texas Star Golf Course. Bonds paid by Water & Wastewater user charges. Bonds partially paid by Tax Increment Financing District and Public Improvement District. 3-1 ANNUAL DEBT SERVICE TOTAL GENERAL OBLIGATION AND REVENUE DEBT TOTAL ANNUAL DEBT SERVICE REQUIREMENTS SUMMARY OF TOTAL GENERAL OBLIGATION AND REVENUE DEBT GENERAL & CERTIFICATES WATER & SALES TAX YEAR 20211 OF OBLIGATION 5,807,903 GOLFREQUIREMENTS 1 $594,125 $1,216,034 $712,495 $393,725 $8,724,282 2022 $4,908,122 $591,275 $1,208,393 $710,020 $401,125 $7,818,935 2023 $4,912,966 $590,444 $1,214,746 $706,020 $397,975 $7,822,151 2024 $4,372,622 $588,738 $1,209,786 $708,740 $394,625 $7,274,510 2025 $3,836,550 $591,072 $1,073,658 $715,140 $401,075 $6,617,495 2026 $3,836,475 $587,419 $1,069,201 $0 $396,975 $5,890,070 2027 $3,838,375 $592,678 $1,073,835 $0 $396,975 $5,901,863 2028 $3,836,769 $0 $1,071,924 $0 $396,575 $5,305,267 2029 $3,839,106 $0 $1,074,096 $0 $395.775 $5,308,977 2030 $3,841,982 $0 $1,075,181 $0 $399,575 $5,316,738 2031 $3.603,284 $0 $1,074,672 $0 $394,875 $5,072,831 2032 $3,600,666 $0 $1,083,190 $0 $396,100 $5,079,955 2033 $3,604,472 $0 $1,075,675 $0 $397,000 $5,077,147 2034 $3,609,575 $0 $947,371 $0 $396,450 $4,953,396 2035 $3,175,447 $0 $954,407 $0 $395,600 $4,525,453 2036 $2,951,747 $0 $540,758 $0 $399.400 $3,891,905 2037 $2,954,903 $0 $539,444 $0 $397.700 $3,892,047 2038 $2,949,228 $0 $537,826 $0 $400,650 $3,887,704 2039 $2.311,100 $0 $380,949 $0 $278,100 $2,970,149 2040 $1,455,350 $0 $381,181 $0 $0 $1,836,531 2041 $589,425 $0 $381,208 $0 $0 $970,633 2042 $0 $0 $381,060 $0 $0 $381,060 2043 $0 $0 $380,767 $0 $0 $380,767 2044 $0 $0 $380.327 $0 $0 $380.327 2045 $0 $0 $379,773 $0 $0 $379,773 2046 $0 $0 $379,103 $0 $0 $379,103 2047 $0 $0 $383,316 $0 $0 $383,316 2048 $0 $0 $382,330 $0 $0 $382,330 2049 $0 $0 $381,225 $0 $0 $381,225 TOTAL $73,836,067 $4,135,750 $22,231,430 $3,552,415 $7,430,275 $111,185,938 KIVA $6,500,000 , $6,000,000 4,1 $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 W Interest W Principal 2021 2023 2025 2027 2029 2031 2033 2035 2037 2039 2041 Fiscal Year DEBT SERVICE REQUIREMENTS SUMMARY OF GENERAL OBLIGATION DEBT YEAR INTEREST PRINCIPAL REQUIREMENTS 2021 $1,822,395 $3,985,508 $5,807,903 2022 $1,688,514 $3,219,608 $4,908,122 2023 $1, 584,170 $3, 328, 796 $4, 912, 966 2024 $1,472,622 $2,900,000 $4,372,622 2025 $1,386,550 $2,450,000 $3,836,550 2026 $1, 301,475 $2, 535, 000 $3, 836,475 2027 $1,213,375 $2,625,000 $3,838,375 2028 $1,121,769 $2,715,000 $3,836,769 2029 $1,024,106 $2,815,000 $3,839,106 2030 $921,982 $2,920,000 $3,841,982 2031 $818,284 $2,785,000 $3,603,284 2032 $725,666 $2,875,000 $3,600,666 2033 $634,472 $2,970,000 $3,604,472 2034 $539,575 $3,070,000 $3,609,575 2035 $440,447 $2,735,000 $3,175,447 2036 $356,747 $2,595,000 $2,951,747 2037 $274, 903 $2,680, 000 $2, 954, 903 2038 $189,228 $2,760,000 $2,949,228 2039 $111,100 $2,200,000 $2,311,100 2040 $55,350 $1,400,000 $1,455,350 2041 $9,425 $580,000 $589,425 TOTAL $17,692,156 $56,143,912 $73,836,067 3-3 Tax -Supported General Obligation Debt Composition of Debt Service $4,500,000 $4,000,000 $3,500,000 $3,000,000 $2,500,000 $ 2, 000, 000 s , s , 2027 2029 2031 2033 2035 2037 2039 Fiscal Year DEBT SERVICE REQUIREMENTS SUMMARY OF TAX -SUPPORTED GENERAL OBLIGATION DEBT YEAR INTEREST PRINCIPAL REQUIREMENTS 2021 $1,037,489 $2,885,508 $3,922,997 2022 $940,933 $2,084,608 $3,025,540 2023 $880,814 $2,143,796 $3,024,610 2024 $821,191 $1,675,000 $2,496,191 2025 $770,894 $1,185,000 $1,955,894 2026 $725,694 $1,230,000 $1,955,694 2027 $678,769 $1,275,000 $1,953,769 2028 $630,119 $1,320,000 $1,950,119 2029 $576, 744 $1,375, 000 $1, 951, 744 2030 $520,645 $1,435,000 $1,955,645 2031 $464, 569 $1,490, 000 $1, 954, 569 2032 $411,122 $1,540,000 $1,951,122 2033 $360,516 $1,595,000 $1,955,516 2034 $307,475 $1,650,000 $1,957,475 2035 $251, 788 $1,700, 000 $1,951, 788 2036 $196,184 $1,760,000 $1,956,184 2037 $140,434 $1, 815, 000 $1, 955,434 2038 $81,791 $1,870,000 $1,951,791 2039 $31,475 $1,280,000 $1,311,475 2040 $5,625 $450,000 $455,625 TOTAL $9,834,268 $31,758,912 $41,593,180 3-4 CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: GENERAL OBLIGATION REFUNDING BONDS,SERIES 2011 DATED: January 15, 2011 ORIGINAL AMOUNT: $6,575,000 INTEREST RATES: BOND YEARS 2013-2014 @ 2.000%, 2015-2016 @ 3.000%, 2017-2019 @ 3.500%, 2020-2021 @ 4.000% PAYING AGENT: U.S. BANK OPTION DATE: N/A YEAR COUPON INTEREST PRINCIPAL TOTAL REQUIREMENTS FEBRUARY15 AUGUST15 AUGUST15 2021 4.000% $17,200 $17,200 $860,000 $894,400 TOTAL $17,200 $17,200 $860,000 $894,400 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. 3-5 CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: GENERAL OBLIGATION REFUNDING BONDS,SERIES 2012 DATED: December 1, 2011 ORIGINAL AMOUNT: $5,955,000 INTEREST RATES: BOND YEARS 2012-2016 @ 2.000%, 2017-2019 @ 3.000%, 2020-2022 @ 4.000%, 2023 @ 3.000% and 2024 @ 3.125% PAYING AGENT: U.S. BANK OPTION DATE: February 15, 2021 YEAR COUPON INTEREST PRINCIPAL TOTAL REQUIREMENTS FEBRUARY15 AUGUST15 FEBRUARY15 2021 4.000% $35,959 $26,259 $485 000 $547 219 2022 4.000% $26,259 $16,159 $505,000 $547,419 2023 3.000% $16,159 $8,359 $520,000 $544,519 2024 3.125% $8,359 1 $0 $535,000 $543,359 TOTAL $86,738 1 $50,778 $2,045,000 $2,182,516 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. MW CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: TAX & WATERWORKS & SEWER SYSTEM (LIMITED PLEDGE) REVENUE CERTIFICATES OF OBLIGATION, SERIES 2018 DATED: March 1, 2018 ORIGINAL AMOUNT: $9,180,000 INTEREST RATES: BOND YEARS 2019 @ 4.00%, 2020-2023 @ 3.00%, 2024-2029 @ 4.00%, 2030- 2031 @ 3.00%, 2032-2033 @ 3.125%, 2034-2035 @ 3.250%, 2036-2037 @ 3.3375% and 2038 @ 3.50% PAYING AGENT: U.S. BANK OPTION DATE: February 15, 2028 YEAR COUPON INTEREST PRINCIPAL FEBRUARY 15 TOTAL REQUIREMENTS FEBRUARY 15 AUGUST 15 2021 3.000% $147,956 $142,706 $350,000 $640,663 2022 3.000% $142,706 $137,306 $360,000 $640,013 2023 3.000% $137,306 $131,756 $370,000 $639,063 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,381 $65,881 $500,000 $639,263 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,528,091 1 $1,380,135 $8,620,000 $11,528,226 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. 3-7 CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: AXON ENTERPRISE, INC. LEASE DATED: October 25, 2018 ORIGINAL AMOUNT: $674,906 INTEREST RATES: 0% INTEREST RATE; 3% Imputed Interest Rate for Reporting Purposes PAYING AGENT: AXON ENTERPRISE, INC. OPTION DATE: N/A YEAR INTEREST INTEREST FEBRUARY7 PRINCIPAL FEBRUARY7 TOTAL REQUIREMENTS 2021 3.000% $12,602 $135,508 $148,110 2022 3.000% $8,502 $139,608 $148,110 2023 3.000% $4,314 $143,796 $148,110 TOTAL $25,418 $418,912 $444,329 The lease was used to finance an integrated camera and taser system along with related hardware and software for the police department. 3-8 CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: TAX & WATERWORKS & SEWER SYSTEM (LIMITED PLEDGE) REVENUE CERTIFICATES OF OBLIGATION, SERIES 2019 DATED: January 15, 2019 ORIGINAL AMOUNT: $11,785,000 INTEREST RATES: 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% PAYING AGENT: U.S. BANK OPTION DATE: February 15, 2028 YEAR COUPON INTEREST PRINCIPAL FEBRUARY 15 TOTAL REQUIREMENTS FEBRUARY 15 AUGUST 15 2021 3.000% $221,878 $215,503 $425,000 $862,381 2022 3.000% $215,503 $208,978 $435,000 $859,481 2023 3.000% $208,978 $202,228 $450,000 $861,206 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 $2,489,575 $2,267,697 $11,590,000 $16,347,272 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. 3-9 CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: TAX & WATERWORKS & SEWER SYSTEM (LIMITED PLEDGE) REVENUE CERTIFICATES OF OBLIGATION, SERIES 2020 DATED: January 14, 2020 ORIGINAL AMOUNT: $7,115,000 INTEREST RATES: 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% PAYING AGENT: U.S. BANK OPTION DATE: February 15, 2029 YEAR COUPON INTEREST PRINCIPAL FEBRUARY 15 TOTAL REQUIREMENTS FEBRUARY 15 AUGUSTIS 2021 3.500% $96,750 $92,113 $265,000 $453,863 2022 3.500% $92,113 $87,300 $275,000 $454,413 2023 3.500% $87,300 $82,313 $285,000 $454,613 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 $1,024,309 $927,559 $7,115,000 $9,066,869 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. 3-10 Li CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: TAX NOTES, SERIES 2020 DATED: June 25, 2020 ORIGINAL AMOUNT: $1,110,000 INTEREST RATES: 1.07% PAYING AGENT: CITIZENS BANK OPTION DATE: February 15, 2022 YEAR INTEREST INTEREST FEBRUARY 15 AUGUST 15 PRINCIPAL FEBRUARY 15 TOTAL REQUIREMENTS 2021 1.070% $7,357 $4,006 $365,000 $376,362 2022 1.070% $4,006 $2,100 $370,000 $376,106 2023 1.070% $2,100 $0 $375,000 $377,100 TOTAL $13,462 1 $6,106 1 $1,110,000 1 $1,129,568 The notes will be used to: (i) pay costs of purchasing equipment, machinery, building, and vehicles for the City's public works, parks and recreation, fire, and police departments; and (ii) to pay for professional services related to the construction, installation, demolition, and financing thereof. 3-11 TIRZ/PID-Supported General Obligation Debt Composition of Debt Service $2,000,000 $1, 500, 000 $1, 000, 000 $500,000 $0 2021 2023 2025 2027 2029 2031 2033 2035 2037 2039 2041 Fiscal Year DEBT SERVICE REQUIREMENTS SUMMARY OF TIRZ/PID-SUPPORTED GENERAL OBLIGATION DEBT YEAR INTEREST PRINCIPAL REQUIREMENTS 2021 $784,906 $1,100,000 $1,884,906 2022 $747,581 $1,135,000 $1,882,581 2023 $703,356 $1,185,000 $1,888,356 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 $7,857,888 $24,385,000 $32,242,888 TIRZ - Tax Increment Reinvestment Zone PID - Public Improvement District 3-12 M CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: TAX & WATERWORKS & SEWER SYSTEM (LIMITED PLEDGE) REVENUE CERTIFICATES OF OBLIGATION, SERIES 2011 DATED: January 15, 2011 ORIGINAL AMOUNT: $180,130 INTEREST RATES: BOND YEARS 2011-2018 @ 3.000%, 2019-2026 @ 4.000%, 2027-2028 @ 4.125%, 2029-2030 @ 4.250% PAYING AGENT: U.S. BANK OPTION DATE: August 15, 2021 YEAR COUPON INTEREST PRINCIPAL TOTAL REQUIREMENTS FEBRUARY 15 AUGUST 15 AUGUST 15 2021 4.000% $2,250 $2,250 $10,000 $14,500 2022 4.000% $2,050 $2,050 $10,000 $14,100 2023 4.000% $1,850 $1,850 $10,000 $13,700 2024 4.000% $1,650 $1,650 $10,000 $13,300 2025 4.000% $1,450 $1,450 $10,000 $12,900 2026 4.000% $1,250 $1,250 $10,000 $12,500 2027 4.125% $1,050 $1,050 $10,000 $12,100 2028 4.125% $844 $844 $10,000 $11,688 2029 4.250% $638 $638 $15,000 $16,275 2030 4.250% $319 $319 $15,000 $15,638 TOTAL 1 1 $13,350 $13,350 $110,000 $136,700 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. 3-13 M CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: 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: BOND YEARS 2011-2018 @3.000%, 2019-2026 @ 4.000%, 2027-2028@ 4.125%, 2029-2030 @4.250% PAYING AGENT: U.S. BANK OPTION DATE: August 15, 2021 YEAR COUPON INTEREST PRINCIPAL AUGUST 15 TOTAL REQUIREMENTS FEBRUARY 15 AUGUST 15 2021 4.000% $37,072 $37 072 $150 000 $224 144 2022 4.000% $34,072 $34,072 $155,000 $223,144 2023 4.000% $30,972 $30,972 $165,000 $226,944 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 1 $218,447 $218,447 $1,815,000 $2,251,894 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. 3-14 M M CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: TAX & WATERWORKS & SEWER SYSTEM (LIMITED PLEDGE) 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 OPTION DATE: August 15, 2024 YEAR COUPON INTEREST PRINCIPAL AUGUST 15 TOTAL REQUIREMENTS FEBRUARY 15 AUGUST 15 2021 5.000% $79,950 $79,950 $265,000 $424,900 2022 5.000% $73,325 $73,325 $280,000 $426,650 2023 5.000% $66,325 $66,325 $295,000 $427,650 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 $591,225 $591,225 $4,770,000 $5,952,450 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. 3-15 ONE IM CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: TAX & WATERWORKS & SEWER SYSTEM (LIMITED PLEDGE) REVENUE CERTIFICATES OF OBLIGATION, SERIES 2015 (GLADE PARKS PHASE 3) DATED: October 27, 2015 ORIGINAL AMOUNT: $3,030,000 INTEREST RATES: BOND YEARS 2016-2035 @3.000% - 5.000% PAYING AGENT: U.S. BANK OPTION DATE: February 15, 2026 YEAR COUPON INTEREST PRINCIPAL FEBRUARY 15 TOTAL REQUIREMENTS FEBRUARY 15 AUGUST 15 2021 5.000% $46,875 $43,500 $135,000 $225,375 2022 5.000% $43,500 $40,000 $140,000 $223,500 2023 5.000% $40,000 $36,375 $145,000 $221,375 2024 5.000% $36,375 $32,625 $150,000 $219,000 2025 3.000% $32,625 $30,225 $160,000 $222,850 2026 3.000% $30,225 $27,750 $165,000 $222,975 2027 3.000% $27,750 $25,200 $170,000 $222,950 2028 3.000% $25,200 $22,500 $180,000 $227,700 2029 3.000% $22,500 $19,725 $185,000 $227,225 2030 3.000% $19,725 $16,875 $190,000 $226,600 2031 3.125% $16,875 $13,828 $195,000 $225,703 2032 3.125% $13,828 $10,703 $200,000 $224,531 2033 3.250% $10,703 $7,291 $210,000 $227,994 2034 3.500% $7,291 $3,797 $215,000 $226,088 2035 1 3.375% $3,797 1 $0 1 $225,000 $228,797 TOTAL 1 $377,269 1 $330,394 1 $2,665,000 $3,372,663 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. 3-16 Nam' CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: TAX & WATERWORKS & SEWER SYSTEM (LIMITED PLEDGE) REVENUE CERTIFICATES OF OBLIGATION, SERIES 2016 (MIDTOWN DEVELOPMENT) DATED: January 12, 2016 ORIGINAL AMOUNT: $16,450,000 INTEREST RATES: BOND YEARS 2016-2041 @2.000% - 4.000% PAYING AGENT: U.S. BANK OPTION DATE: August 15, 2026 YEAR COUPON INTEREST PRINCIPAL AUGUST 15 TOTAL REQUIREMENTS FEBRUARY 15 AUGUST 15 2021 2.000% $227,994 $227,994 $540,000 $995,988 2022 3.000% $222,594 $222,594 $550,000 $995,188 2023 4.000% $214,344 $214,344 $570,000 $998,688 2024 2.250% $202,944 $202,944 $590,000 $995,888 2025 3.000% $196,306 $196,306 $605,000 $997,613 2026 3.000% $187,231 $187,231 $620,000 $994,463 2027 3.000% $177,931 $177,931 $640,000 $995,863 2028 3.000% $168,331 $168,331 $660,000 $996,663 2029 3.000% $158,431 $158,431 $680,000 $996,863 2030 3.000% $148,231 $148,231 $700,000 $996,463 2031 3.000% $137,731 $137,731 $720,000 $995,463 2032 3.000% $126,931 $126,931 $745,000 $998,863 2033 3.000% $115,756 $115,756 $765,000 $996,513 2034 3.000% $104,281 $104,281 $790,000 $998,563 2035 3.000% $92,431 $92,431 $810,000 $994,863 2036 3.125% $80,281 $80,281 $835,000 $995,563 2037 3.125% $67,234 $67,234 $865,000 $999,469 2038 3.125% $53,719 $53,719 $890,000 $997,438 2039 3.250% $39,813 $39,813 $920,000 $999,625 2040 1 3.250% $24,863 $24,863 $950,000 $999,725 2041* 3.250% $9,425 $0 $580,000 $589,425 TOTAL $2,756,803 $2,747,378 $15,025,000 $20,529,181 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. 3-17 $800,000 1 $700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 Taxable (Self Supporting) G.O. Debt Composition of Debt Service Interest Principal 2021 2023 2025 Fiscal Year DEBT SERVICE REQUIREMENTS SUMMARY OF TAXABLE (SELF SUPPORTING) G.O. DEBT YEAR INTEREST PRINCIPAL REQUIREMENTS 2021 $132,495 $580,000 $712,495 2022 $110,020 $600,000 $710,020 2023 $86,020 $620,000 $706,020 2024 $58, 740 $650, 000 $708, 740 2025 $30,140 $685,000 $715,140 TOTAL $417,415 $3,135,000 $3,552,415 G.O. - General Obligation 3-18 CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: 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 OPTION DATE: August 1, 2021 YEAR COUPON INTEREST PRINCIPAL AUGUST1 TOTAL REQUIREMENTS FEBRUARY1 AUGUST1 2021 3.875% $66,248 $66,248 $580,000 $712,495 2022 4.000% $55,010 $55,010 $600,000 $710,020 2023 4.400% $43,010 $43,010 $620,000 $706,020 2024 4.400% $29,370 $29,370 $650,000 $708,740 2025 4A00% $15,070 $15,070 $685,000 $715,140 TOTAL $208,708 $208,708 $3,135,000 $3,552,415 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. 3-19 Golf G.O. Refunding Debt Composition of Debt Service $800,000 F PRINCIPAL ■ INTEREST $600,000 r ..... ..._.w $400,000 $200,000 $0 2021 2023 2025 2027 Fiscal Year DEBT SERVICE REQUIREMENTS SUMMARY OF GOLF G.O. REFUNDING DEBT YEAR INTEREST PRINCIPAL REQUIREMENTS 2021 $84,125 $510, 000 $594,125 2022 $71,275 $520,000 $591,275 2023 $60,444 $530,000 $590,444 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 $330,750 $3,805,000 $4,135,750 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-20 CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: GENERAL OBLIGATION REFUNDING November 1, 2012 BONDS, SERIES 2012A-GOLF DATED: ORIGINAL AMOUNT: $7,185,000 BOND YEAR 2013-2014 @ 2.00%, 2015-2016 @ 4.000%, 2017-2018 @ INTEREST RATES: 2.000%, 2019-2021 @ 3.000%, 2022 @ 2.000%, 2023 @ 2.125%, 2024 @ 2.250%, 2025 @ 2.375%, 2026 @ 2.500%, 2027 @ 2.625% PAYING AGENT: U.S. BANK OPTION DATE: FEBRUARY 15, 2022 INTEREST PRENA TOTAL YEAR COUPON FEBRUARY 15 AUGUST 15 FEB5 REQUIREMENTS 021 3.000% $45,888 $38,238 $5 $594,125 022 P2024 2.000% $38,238 $33,038 $5 $591,27, 023 2.125% $33,038 $27,406 $530,000 $590,444 2.250% $27,406 $21,331 $5401000 $588,738 2025 2.375% $21, 331 $14, 741 $555, 000 $591, 072 2026 2.500% S14,741 $7,678 $565,000 $587,419 2027 2.625% $7,678 $0 $585,000 $592,678 TOTAL $188,319 $142,431 $3,805,000 $4,135,750 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 $590, 821 3-21 Water & Wastewater Revenue Debt Composition of Debt Service $1,300,000 $1,200,000 j j - i j $1,100,000 PRINCIPAL jINTEREST $1,000,000 $900,000 $800,000 $700,000 $600,000 $500,000 $400,000 $300,000 $200:000 $100000wo WAANA -W 2021 2024 2027 2030 2033 2036 2039 2042 2045 2048 Fiscal Year I DEBT SERVICE REQUIREMENTS SUMMARY OF WATER AND WASTEWATER SYSTEM REVENUE DEBT YEAR INTEREST PRINCIPAL REQUIREMENTS 2021 $271,034 $945,000 $1,216,034 2022 $263,393 $945,000 $1,208,393 2023 $254, 746 $960, 000 $1,214, 746 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 $3,506,430 $18,725,000 $22,231,430 AVERAGE ANNUAL PRINCIPAL AND INTEREST OUTSTANDING $766,601 3-22 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 YEAR COUPON INTEREST PRINCIPAL JULY 15 TOTAL REQUIREMENTS JANUARY 15 JULY 15 2021 2.030% $5,430 $5,430 $130,000 $140,860 2022 2.030% $4 111 $4 111 $130,000 $138 222 2023 2.030% $2 791 $2 791 $140 000 $145 582 2024 2.030% $1,370 $1,370 $135,000 $137,740 TOTAL $13,702 $13,702 $635,000 $562,404 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-23 M CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: WATERWORKS AND SEWER SYSTEM REVENUE BONDS, SERIES 2013 DATED: June 25, 2013 ORIGINAL AMOUNT: $1,585,000 INTEREST RATES: BOND YEAR 2012-2033 @ 2.00% - 5.00% PAYING AGENT: U. S. BANK OPTION DATE: July 25, 2023 YEAR COUPON INTEREST PRINCIPAL JULY 15 TOTAL REQUIREMENTS JANUARY 15 JULY 15 2021 3.625% $25,422 $25,422 $70,000 $120,844 2022 3.625% $24,153 $24,153 $70,000 $118,306 2023 3.625% $22,884 $22,884 $75,000 $120,769 2024 4.000% $21,525 $21,525 $75,000 $118,050 2025 4.000% $20,025 $20,025 $80,000 $120,050 2026 4.000% $18,425 $18,425 $80,000 $116,850 2027 4.500% $16,825 $16,825 $85,000 $118,650 2028 4.500% $14,913 $14,913 $90,000 $119,825 2029 4.500% $12,888 $12,888 $95,000 $120,775 2030 5.000% $10,750 $10,750 $100,000 $121,500 2031 5.000% $8,250 $8,250 $105,000 $121,500 2032 5.000% $5,625 $5,625 $110,000 $121,250 2033 5.000% $2,875 $2,875 $115,000 $120,750 TOTAL $204,569 $204,669 $1,150,000 $1,659,119 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. 3-24 CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: WATERWORKS AND SEWER SYSTEM REVENUE BONDS, SERIES 2015A Meters DATED: June 15, 2015 ORIGINAL AMOUNT: $4,685,000 INTEREST RATES: BOND YEARS 2019-2035 @ 0% - 1.98% PAYING AGENT: Texas Water Development Board OPTION DATE: N/A YEAR COUPON INTEREST PRINCIPAL JULY 15 TOTAL REQUIREMENTS JANUARY 15 JULY 15 2021 0.590% $26,840 $26,840 $220,000 $273,681 2022 0.800% $26,191 $26,191 $220,000 $272,383 2023 0.960% $25,311 $25,311 $220,000 $270,623 2024 1.120% $24,255 $24,255 $225,000 $273,511 2025 1.250% $22,995 $22,995 $225,000 $270,991 2026 1.390% $21,589 $21,589 $230,000 $273,178 2027 1.500% $19,991 $19,991 $235,000 $274,981 2028 1.590% $18,228 $18,228 $235,000 $271,456 2029 1.670% $16,360 $16,360 $240,000 $272,720 2030 1.740% $14,356 $14,356 $245,000 $273,712 2031 1.800% $12,224 $12,224 $250,000 $274,449 2032 1.850% $9,974 $9,974 $255,000 $274,949 2033 1.900% $7,616 $7,616 $260,000 $275,231 2034 1.940% $5,146 $5,146 $260,000 $270,291 2035 1.980% $2,624 1 $2,624 1 $265,000 1 $270,247 TOTAL $253,699 1$253,699 1 $3,585,000 1 $4,092,399 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. 3-25 L CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: WATERWORKS AND SEWER SYSTEM REVENUE BONDS, SERIES 2015B Reclaimed Water System) DATED: June 15, 2015 ORIGINAL AMOUNT: $2,380,000 INTEREST RATES: BOND YEARS 2020-2035 @ 0% -1.68% PAYING AGENT: Texas Water Development Board OPTION DATE: N/A YEAR COUPON INTEREST PRINCIPAL JULY 15 TOTAL REQUIREMENTS JANUARY 15 JULY 15 2021 0.290% $11,319 $11,319 $120,000 $142,638 2022 0.500% $11,145 $11,145 $120,000 $142,290 2023 0.660% $10,845 $10,845 $120,000 $141,690 2024 0.820% $10,449 $10,449 $120,000 $140,898 2025 0.950% $9,957 $9,957 $120,000 $139,914 2026 1.090% $9,387 $9,387 $120,000 $138,774 2027 1.200% $8,733 $8,733 $125,000 $142,466 2028 1.290% $7, 983 $7, 983 $125,000 $140, 966 2029 1.370% $7,177 $7,177 $125,000 $139,353 2030 1.440% $6,320 $6,320 $130,000 $142,641 2031 1.500% $5,384 $5,384 $130,000 $140,769 2032 1.550% $4,409 $4,409 $135,000 $143,819 2033 1.600% $3,363 $3,363 $135,000 $141,726 2034 1.640% $2,283 $2,283 $135,000 $139,566 2035 1.680% $1,176 $1,176 $140, 000 $142, 352 TOTAL $109,928 $109,928 $1,900,000 $2,119,857 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. 3-26 OR CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: WATERWORKS AND SEWER SYSTEM REVENUE BONDS, SERIES 2018 DATED: Aril 15, 2018 ORIGINAL AMOUNT: $2,785,000 INTEREST RATES: BOND YEARS 2018-2038 @ 0% -1.49% PAYING AGENT: Texas Water Development Board OPTION DATE: N/A YEAR COUPON INTEREST PRINCIPAL JULY 15 TOTAL REQUIREMENTS JANUARY 15 JULY 15 2021 0.080% $12,914 $12,914 $130,000 $155,827 2022 0.240% $12,862 $12,862 $130,000 $155,723 2023 0.410% $12,706 $12,706 $130,000 $155,411 2024 0.540% $12,439 $12,439 1 $135,000 $159,878 2025 0.670% $12,075 $12,075 $135,000 $159,149 2026 0.810% $11,622 $11,622 $135,000 $158,245 2027 0.940% $11,076 $11,076 $135,000 $157,151 2028 1.020% $10,441 $10,441 $135,000 $155,882 2029 1.110% $9,753 $9,753 $140,000 $159,505 2030 1.170% $8,976 $8,976 $140,000 $157,951 2031 1.220% $8,157 $8,157 $140,000 $156,313 2032 1.270% $7,303 $7,303 $145,000 $159,605 2033 1.320% $6,382 $6,382 $145,000 $157,764 2034 1.370% $5,425 $5,425 $145,000 $155,850 2035 1.410% $4,432 $4,432 $150,000 $158,863 2036 1.440% $3,374 $3,374 $150,000 $156,748 2037 1.470% $2,294 $2,294 $155,000 $159,588 2038 1.490% $1,155 $1,155 $155 000 $157,310 TOTAL $153,381 $153,381 $2,530,000 1 $2,836,761 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. 3-27 CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: WATERWORKS AND SEWER SYSTEM REVENUE BONDS, SERIES 2019 DATED: Aril 25, 2019 ORIGINAL AMOUNT: $9,275,000 INTEREST RATES: BOND YEARS 2020-2049 @ 0.23% -1.66% PAYING AGENT: Texas Water Development Board OPTION DATE: N/A YEAR COUPON INTEREST PRINCIPAL JULY 15 TOTAL REQUIREMENTS JANUARY 15 JULY 15 2021 0.260% $53,593 $53,593 $275,000 $382,185 2022 0.290% $53,235 $53,235 $275,000 $381,470 2023 0.350% $52,836 $52,836 $275,000 $380,673 2024 0.420% $52,355 $52,355 $275,000 $379,710 2025 0.500% $51,778 $51,778 $280,000 $383,555 2026 0.560% $51,078 $51,078 $280,000 $382,155 2027 0.640% $50,294 $50,294 $280,000 $380,587 2028 0.720% $49,398 $49,398 $285,000 $383,795 2029 0.830% $48,372 $48,372 $285,000 $381,743 2030 0.960% $47,189 $47,189 $285,000 $379,378 2031 1.060% $45,821 $45,821 $290,000 $381,642 2032 1.140% $44,284 $44,284 $295,000 $383,568 2033 1.200% $42,602 $42,602 $295,000 $380,205 2034 1.240% $40,832 $40,832 $300,000 $381,665 2035 1.290% $38,972 $38,972 $305,000 $382,945 2036 1.340% $37,005 $37,005 $310,000 $384,010 2037 1.400% $34,928 $34,928 $310,000 $379,856 2038 1.450% $32,758 $32,758 $315,000 $380,516 2039 1.490% $30,474 $30,474 $320,000 $380,949 2040 1.530% $28,090 $28,090 $325,000 $381,181 2041 1.560% $25,604 $25,604 $330,000 $381,208 2042 1.580% $23,030 $23,030 $335,000 $381,060 2043 1.600% $20,384 $20,384 $340,000 $380,767 2044 1.610% $17,664 $17,664 $345,000 $380,327 2045 1.620% $141886 $14,886 $350,000 $379,773 2046 1.630% $12,051 $12,051 $355,000 $379,103 2047 1.640% $9,158 $9,158 $365,000 $383,316 2048 1.650% $6,165 $6,165 $370, 000 $382, 330 2049 1.660% $3,113 $3,113 $375,000 $381,225 TOTAL 1 $1,017,946 $1,017,946 $9,025,000 $11,060,892 Proceeds from the sale of the Bonds will provide funds for Capital Improvement Project WT1802 Well Replacement - Fuller / Far North. 3-28 Sales Tax Revenue Debt Composition of Debt Service $500,000 PRINCIPAL INTEREST $450,000 I $4001000 _. $350,000 $300,000 $250,000 $200,000 $150,000 $100, 000 $50,000 2021 2022 2023 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 YEAR INTEREST PRINCIPAL TOTAL REQUIREMENTS 2021 $188,725 $205,000 $393,725 2022 $181,125 $220,000 $401,125 2023 $172,975 $225,000 $397,975 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,980,275 $5,450,000 $7,430,275 MAXIMUM ANNUAL DEBT SERVICE (RESERVE) AVERAGE ANNUAL DEBT OUTSTANDING $401,125 $391,067 3-29 CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: 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, NATIONAL ASSOCIATION, DALLAS, TEXAS OPTION DATE: 9/15/2028 YEAR COUPON INTEREST PRINCIPAL SEPTEMBER 15 TOTAL REQUIREMENTS MARCH 15 SEPTEMBER 15 2021 3.00% $28,475 $28,475 $60,000 $116,950 2022 3.00% $27,575 $27,575 $65,000 $120,150 2023 3.00% $26,600 $26,600 $65,000 $118,200 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 $311,225 $311,225 $1,505,000 $2,127,450 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. 3-30 CITY OF EULESS DEBT SERVICE REQUIREMENTS DESCRIPTION: EULESS DEVELOPMENT CORPORATION, SALES TAX REVENUE BONDS, SERIES 2019 DATED: 11 /12/19 ORIGINAL AMOUNT: $4,120,000 INTEREST RATE: YEARS 2020-2029 @ 4.00%, 2030 @ 3.00%, YEARS 2031-2032 @2.5%, YEARS 2033-2039 @ 3.00% PAYING AGENT: U.S. BANK, NATIONAL ASSOCIATION, DALLAS, TEXAS OPTION DATE: 9/15/2030 YEAR COUPON INTEREST PRINCIPAL SEPTEMBER 15 TOTAL REQUIREMENTS MARCH 15 SEPTEMBER 15 2021 4.00% $65,888 $65,888 $145,000 $276,775 2022 4.00% $62,988 $62,988 $155,000 $280,975 2023 4.00% $59,888 $59,888 $160,000 $279,775 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 $678,913 $678,913 $3,945,000 $5,302,825 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. 3-31 PERSONNEL &t INSURANCE Personnel Counts Personnel Counts by Fund Proposed Pay Plan Proposed Insurance Premiums Insurance £t Benefits, CYTD Risk £t Workers Compensation, CYTD Full -Time Personnel Counts FY 18/19 FY 19/20 FY 19/20 FY 20121 ACTUAL BUDGETED ESTIMATED BUDGETED CITY ADMINISTRATION 3.50 3.50 3.50 3.00 O CITY SECRETARY 3.50 3.50 3.50 3.50 Total City Administration 7.00 7.00 7.00 6.50 ` v FINANCE/BUDGET 2.00 2.00 2.00 1.50 E MUNICIPAL COURTS 7.75 7.75 7.75 7.75 ACCOUNTING 4.00 4.00 4,00 3.50 G PURCHASING 1.00 1.00 1.00 1.00 Total Finance 14.75 %75 14.75 13.75 POLICE CODE COMPLIANCE 15.00 B 16.00 16.00 16.00 POLICE ADMINISTRATION 6.00 6.00 7.00 C 7.00 POLICE PATROL 45.00 45.00 45.00 49.00 F POLICE CID 13.00 13.00 13.00 14.00 H POLICE SERVICE 22.00 22.00 22.00 21.00 H POLICE DETENTION 17.00 17.00 17.00 17,00 Total Police Department 118.00 119.00 120.00 124.00 FIRE MARSHAL/EDUCATION 4.00 4.00 4.00 4.00 FIRE ADMINISTRATION 4.00 4.00 4.00 4.00 EMS/SUPPRESSION 67.00 67.00 67.00 67.00 Total Fire Department 75.00 75.00 75.00 75.00 INFORMATION SERVICES 1.00 1.00 1.00 1.00 HUMAN RESOURCES 3.50 3.50 3.50 3.50 FACILITY MAINTENANCE 4.00 4.00 4.00 4.00 Total Administrative Services 8.50 8.50 8.50 8.50 LIBRARY 9.00 9.00 9.00 9.00 Total Library 9.00 9.00 9.00 9.00 PLANNING & DEVELOPMENT 2.50 2.50 2.50 2.50 INSPECTIONS SERVICES 4.00 4,00 4.00 4.00 Total Planning & Development 6.50 6.50 6.50 6.50 RECREATION 6.50 6.50 5.50 C 5.50 PARKS 11.00 11.00 11.00 11.00 SENIOR CENTER 2.00 2.00 2.00 2.00 RECREATION ADMINISTRATION 1.00 1,00 1.00 1.00 Total Community Services 20.50 20.50 19.50 19.50 STREET MAINTENANCE 11.50 11.50 11.50 11.50 ANIMAL CONTROL 3.00 3.00 3.00 3.00 CITY ENGINEER 1.00 1.00 1.00 1.00 Total Public Works 15.50 15.50 16.50 15.60 GF NON -DEPARTMENTAL 0.00 0.00 0.00 0.00 Total Non -departmental 0.00 0.00 0.00 0.00 TOTAL GENERAL FUND 274.75 275.75 275.75 278.25 EDC-PARKS 13.25 13.25 13.25 13.25 EDC - LIBRARY 10.00 10.00 10.00 10.00 EDC - ECO. DEV. 1.00 1.00 1.00 1.00 TOTAL EDC FUND 24.25 24.25 24.25 24.25 WATER OFFICE 5.00 5.00 5.00 5.00 Total Finance 5.00 5.00 5.00 5.00 W&S ENGINEERING 3.00 3.00 3.00 3.00 WATER PRODUCTION 5.75 5.75 5.75 5.75 WATER DISTRIBUTION 725 7.25 7.25 7.25 SEWAGE & TREATMENT 7.00 A 8.00 8.00 8.00 METER SERVICES 1.00 1.00 1.00 1.00 Total Public Works 24.00 25.00 25.00 25.00 INFORMATION SERVICES 4.00 4.00 4.00 4.00 W&S NON-DEPT. 10.00 10.00 10.00 9.50 D,E&G Total Non -departmental 14.00 14.00 14.00 13.50 TOTAL W&S FUND 43.00 44.00 44.00 43.50 GOLF NON DEPARTMENTAL 0.75 0.75 0.75 0.75 GOLF COURSE MAINT, 4.00 4.00 4.00 4.00 GOLF PRO SHOP 2.50 2.50 2.50 2.50 GOLF FOOD AND BEVERAGE 3.00 3.00 3.00 3.00 GOLF CONFERENCE CENTRE 1.50 1.50 1.50 1.50 TOTAL GOLF COURSE FUND 11.75 11.75 11.75 11.75 JUVENILE CASE FUND 1.25 1.25 1.25 1.25 CRIME CONTROL FUND 19.00 19,00 19.00 15.00 F PUBLIC SAFETY SPECIAL FUND 0.00 0.00 0.00 0.00 SERVICE CENTER FUND 5.00 5.00 5.00 5.00 DRAINAGE UTILITY FUND 8.00 8.00 8.00 8.00 TEXAS STAR SPORTS COMPLEX 1.50 1.50 1.50 1.50 HEALTH INSURANCE FUND 1.00 1.00 1.00 1.00 WC/RISK MANAGEMENT FUND 0.50 0.50 0.50 0.50 TOTAL OTHER FUNDS 36.25 36.25 36.25 32.25 TOTAL ALL FUNDS 390.00 392.00 392.00 390.00 A) Added 1 PW Field Tech I B) Added 1 Code Enforcement Officer C) Transferred Rec Assistant to PD Emergency Managementlspecal Projects Assistant D) Unfunded Assistant City Manager Position E) Unfunded Internal Auditor Position F) Transferred 4 Police Officers from CCPD to General Fund G) Split BudgetRreasury, Manager between General Fund and Water & Wastewater Fund H) Transferred Records Clerk to Crime Scene Technician 4-1 OR m PERSONNEL COUNTS BY FUND FULL-TIME EMPLOYEES FY19 ACTUAL FY20 BUDGETED FY20 ESTIMATED FY21 FUNDED GENERAL FUND 274.75 275.75 275.75 278.25 EDC FUND 24.25 24.25 24.25 24.25 WATER & WW FUND 43.00 44.00 44.00 43.50 GOLF COURSE FUND 11.75 11.75 11.75 11.75 JUVENILE CASE FUND 1.25 1.25 1.25 1.25 CRIME CONTROL DISTRICT 19.00 19.00 19.00 15.00 PUBLIC SAFETY SPECIAL FUND 0.00 0.00 0.00 0.00 SERVICE CENTER FUND 5.00 5.00 5.00 5.00 DRAINAGE UTILITY 8.00 8.00 8.00 8.00 TEXAS STAR SPORTS COMPLEX 1.50 1.50 1.50 1.50 HEALTH INSURANCE FUND 1.00 1.00 1.00 1.00 WC/RISK MANAGEMENT FUND 0.50 0.50 1 0.50 0.50 TOTAL 1 390.001 392.001 392.001 390.00 PART-TIME EMPLOYEES GENERAL FUND 49.00 49.00 49.00 49.00 EDC FUND 17.00 17.00 17.00 17.00 WATER & WW FUND 2.00 2.00 2.00 2.00 GOLF COURSE FUND 57.00 57.00 57.00 57.00 SPECIAL RECREATION FUND 3.00 3.00 3.00 3.00 TEXAS STAR SPORTS COMPLEX 26.00 26.00 26.00 26.00 TOTAL 154.00 154.00 154.00 154.00 4-2 PROPOSED PUBLIC SAFETY PAY PLAN FIRE EFFECTIVE 09-26-2020 POLICE EFFECTIVE 09-24-2020 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 rto tN N $3,761 $3,949 1 $4,145 1 $4,3! $45,130 1$47,3871$49,7461 $52,2 21.6971 1927823123.9162125.11 1 24.8077 1 26.04821 27.34661 28.7131 130.15691 31.6588 1 1 21.5852 1 22.6621 1 23.80091 24.98821 26.24451 27.5493 1 740.00 1 22.01 1 N Wire Fighter/Paramedic 1 $5,445 1 $5,707 1 $6,021 1 $6,310 1 $6,689 1 $7,007 1 565.00 1 24.00 1 N 113olice Officer 24.03 1 N lFire inspector I 770.00 1 24.02 1 N IFirefiqhter II/Pa 590.00 1 26.01 1 N IFire Inspector II 1 22.3749 1 23.45181 24.74251 25.92981 27.48981 28.7946 1 31.2132 1 32.69591 34.256C $5,602 1 $5,859 $6,167 $67,230 1 $70,313 1 $74,002 23.0238 124.0800125.3431 $81,955 39.4016 $7,133 $85,592 29.3123 844 1 $6,101 1 $6,372 1 $6,654 1 $6,953 ),131 1 $73,2141 $76,459179,345 83,433 7166 35.1989 136.7591138.3870 140.1122 P4 4-3 0" �s PROPOSED PUBLIC SAFETY PAY PLAN FIRE EFFECTIVE 09-26-2020 POLICE EFFECTIVE 09-24-2020 P 1 2 3 4 5 6 Grade Code FLSA Job Title Start Pay EOY 1 EOY 2 EOY 3 EOY 4 Merit 605.00 26.00 N Police Sergeant $7,096 $8,432 26.05 E 1 lEmergency Mgmt. Coordinator $85,155 $101,179 610.00 1 26.04 N lFire Inspector III 40.9397 48.6435 1 27.00 1 N [Public Education Officer I 820.00 1 26.03 1 N lFire Lieutenant/Paramedic $7,288 $8,735 $87,460 $104,815 29.9521 1 1 1 1 1 35.8956 840.00 1 27.02 1 N lFire Captain/Paramedic $7,557 $9,195 $90,686 $110,341 31.0568 37.7882 650.00 128.00 E Police Lieutenant $8,075 $9,466 128.01 E Technical Services Manager $96,895 $113,597 128.02 E Civilian Service Manager 46.5839 54.6138 670.00 127.04 E Battalion Chief/EMS Coordinator $8,384 $9,743 $100,608 $116,915 48.3694 56.2093 1 680.00 1130.02 1 E (Police Captain 1 $8,603 1 1 1 1 1 $1u,7s5 I $103,233 $121,620 49.6313 58.4710 4-4 L PROPOSED EXEMPT PAY PLAN EFFECTIVE 09-24-2020 Hourly, Monthly and Annual Pay Scales Job GRADE Code FLSA Job Title Min Mid Max 295 143.16 E lConference, Centre Manager $3,834 $4,639 $5,443 143.04 E jAsst. Golf Superintendent $46,014 $55,663 $65,312 143.11 E I First Asst. Golf Pro 22.1220 26.7611 31.40012 305 146.11 E Seniors Coordinator $3,971 $4,8351 $5,698 146.12 E Recreation Specialist -Aquatics $47,656 $58,0181 $68,380 146.13 E Program Rec. Specialists 22.9116 27.89331 32.875 146.14 E Athletic Coordinator 146.15 1 E lRecreation Specialist -Analyst 146.16 E ISpecial Events Coordinator 146.18 1 E lHuman Resources Generalist.) 315 149.09 1 E ISenior Center Supervisor $4,1891 $5,0631 $5,936 146.10 1.. E I Recreation Center SupervisoO $50,2661 $60,7521 $71,238 24.16631 29.20761 34.24889 325 145.03 1 E jAccountant 1 $4,4051 $5,332 $6,259 148.00 1 E IlLibrarian $52,8571 $63,9851 $75,112 25.41201 30.76181 36.11163 335 152.01 E Recreation Superintendent $4,622 $5,6011 $6,580 149.01 E Human Resources Generalist II $55,467 $67,2151 $78,962 149.02 E Food and Beverage Manager- 26.6668 32.3147 - 37.9627 149.03 E Kitchen Manager/Chef 149.08 E IFacilities Supervisor 154.02 1 E jPark Superintendent pn 345 1 150.03 1 E ISenior Librarian $4,838 $5,870 $6,901 $58,058 $70,437 $82,816 27.9124 33.8639 39.81545 355 149.04 E Deputy City Secretary $5,056 $6,139 $7,222 150.00 E Accountant II $60,668 $73,667 $86,666 151.00 E Web Designer 29.1672 35.4168 41.66636 365 E JOPEN $5,3061 $6,427 $7,547 $63,6771 $77,1191 $90,562, 30.61401 37.07661 43.53925 4-5 111-� PROPOSED EXEMPT PAY PLAN EFFECTIVE 09-24-2020 Hourly, Monthly and Annual Pay Scales Job GRADE Code FLSA Job Title Min Mid Max 375 145.07 E Internal Auditor $5,572 $6,748 $7,924 153.00 E IGIS Manager $66,859 $80,974 $95,090 153.08 E I Network Manager 32.1438 38.9300 45.71622 385 150.07 E Budget/Treasury Manager $5,851 $7,086 $8,321 154.08 E Accounting Manager $70,211 $85,031 $99,852 151.01 E Purchasing Manager 33.7552 40.8804 48.00557 154.03 E SBW/PATS General Mana ef— n5 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 I Risk Manager 405 1 155.01 1 E ICivil Engineer $6,4511 $7,8131 $9,175 $77,4111 $93,7531 $110,095 37.21711 45.07371 52.93031 410 1 156.01 1 E Senior Computer Developer $6,6121 $8,008 $9,404 $79,3451 $96,095 $112,846 38.1464 46.1997 54.25307 415 1 157.04 1 E ISenior Civil Engineer $6,773 $8,2031 $9,633 $81,2761 $98,4371 $115,5918 39.07511 47.32551 55.576 4-6 L PROPOSED NON-EXEMPT PAY PLAN EFFECTIVE 09-24-2020 Hour( ., Monthly and Annual Pay Scales Job GRADE Code FLSA Job Title Min Mid Max 200 35.01 1 N Firefighter Trainee $2,500 $2,500 $2,500 $30,0001 $30,000 $30,000 14.42311 14.4231 14.4231 210 36.03 N Library Aide $2,4521 $2,9711 $3,490 $29,4291 $35,6561 $41,883 14.14871 17.14241 20.1362 220 37.03 N Library Clerk $2,6251 $3,1761 $3,726 ji $38,1111 $44,718 .$31,5041 15.14591 18.32251 21.4990 230 37.01 N Parks Field Tech 1 $2,7701 $3,3291 $3,889 37.02 N Facility Tech 1 $33,2391 $39,9531 $46,666 37.05 N Public Works Field Tech 1 15.98041 19.20801 22.4357 240 38.01 N Police Records Clerk $2,916 $3,5241 $4,132 38.03 N Utility Billing Clerk $34,991 $42,289 $49,687 39.00 N Parks Field Tech II 16.8224 20.3311 23.8398 39.01 N Animal Control Officer I 39.04 1 N Receptionist 39.05 N Facility Tech 11 39.06 N Public Works Field Tech II 39.11 N Golf Course Field Tech II 39.12 N jAsst. F& B Mgr. 260 39.08 N Court Clerk $3,062 $3,678 $4,295 40.01 N Animal Control Officer II $36,742 $44,139 $61,536 40.04 N Office Tech 17.6645 21.2208 24.7771 40.05 N Mechanic I 40.07 1 N ISecretary 40.30 1 N ICrime Scene Technician 270 $37,2671 $44,9931 $52,719 17.91661 21.63121 25.3459 39.10 N IJuvenile Case Clerk $3,3541 $4,066 $4,778 42.02 N Recreation Assistant $40,2481 $48,7901 $57,332 42.06 N Emr Mgt/Special Pro' Assistant 19.34991 23.45681 27.5636 4-7 PROPOSED NON-EXEMPT PA Y PLAN EFFECTIVE 09-24-2020 Hourly, Monthly and Annual Pay Scales Job GRADE Code FLSA Job Title Min Mid Max 280 41.01 N Administrative Secretary $3,500 $4,2611 $5,023 43.01 N Administrative Assistant $42,000 $51,1371 $60,274 43.02 N Librarian Assistant 20.1921 24.58501 28.9779 43.04 N Admin Asst./Analyst 43.03 N Equipment Operator 43.07 N Mechanic II 43.08 N Parks Field Tech III 43.10 N Facility Tech III 43.11 N Public Works Field Tech III 43.13 1 N ISignal Technician I 281 41.02 N Circulation Supervisor $3,683 $4,474 $5,266 $44,191 $53,693 $63,195 21.2458 25.8140 30.3823 290 43.09 N Executive Secretary $3,865 $4,680 $5,494 45.00 N Inspector 1 $46,3831 $56,1551 $65,927 45.01 N Mechanic III 26.99761 31.6957 45.04 N Crew Leader .22.29941 300 43.06 N Animal Control Supervisor $4,010 $4,881 $5,753 46.04 N Police Records Supervisor $48,116 $58,576 $69,036 46.08 N Computer Support Specialist 23.1325 28.1615 33.1906 46.09 N Chief Mechanic 46.10 1 N IMunicipal Court Supervisor 310 1 47.01 1 N lWater Quality Specialist $4,0961 $4,9501 $5,804 $49,1471 $59,399 $69,652 23.62831 28.55741 33.4865 320 48.01 N Foreman $4,448 $5,384 $6,319 48.02 N Inspector II $53,373 $64,602 $75,832 48.04 N Signal Tech II 25.6600 31.0588 36.4577 48.05 N Eng./PW Technical Specialist 49.00 N I Bailiff/Warrant Officer 330 1 N JOPEN 1 $4,6651 $5,6541 $6,642 $56,9831 $67,843 $79,703 26.91471 32.61671 38.3187 340 48.03 1 N lComputer Support Spec II $4,884 $5,926 $6,968 50.02 N Inspector III $58,611 $71,115 $83,620 28.1785 34.1901 40.2018 350 1 51.02 1 N ISenior Inspector $5,103 $6,197 $7,291 $61,240 $74,367 $87,494 29.4422 35.7534 42.0645 360 1 1 N JOPEN $5,357 $6,488 $7,619 $64,287 $77,858 $91,428 30.9072 37.4315 43.9559 4-8 City of Euless 2020-21 Proposed Employee Insurance Premiums Per Month MEDICAURX 2019-20 Actual 2020-21 Pro osed Increase / Decrease A B A B A - B Employee Only $299.24 $188.78 $329.16 $188.78 $29.92 $0.00 Employee + Children $568.56 $358.66 $625.42 $358.66 $56.86 $0.00 Employee + Spouse $688.26 $434.18 $757.10 $434.18 $68.84 $0.00 Em to ee + Family $867.82 $547.441 $954.60 $547.441 $86.78 $0.00 DENTAL 2019-20 Actual 2020-21 roposed Increase / Decrease A B A B A B Employee Only $8.28 $8.28 $9.52 $9.52 $1.24 $1.24 Employee + Children $15.72 $15.72 $18.06 $18.06 $2.34 $2.34 ,Employee + Spouse $19.02 $19.02 $21.86 $21.86 $2.84 $2.84 Em to ee + Family $24.00 $24.00 $27.58 $27.58 $3.58 $3.58 Total Premium 2019-20 Actual 2020-21 Proposed Increase / Decrease A B A B A B Employee Only $307.52 $197.06 $338.68 $198.30 $31.16 $1.24 Employee + Children $584.28 $374.38 $643.48 $376.72 $59.20 $2.34 ,Employee + Spouse $707.28 $453.20 $778.96 $456.04 $71.68 $2.84 Em to ee + Family$891.82 $571.44 $982.18 $575.02 1 $90.36 $3.58 4-9 Insurance & Benefits FY2020-21 FY2021 Proposed Revenues: City Contribution For Employees and Dependents $ 5,488,408 Employee Contribution Employee/Retiree Contribution $ 1,763,606 Interest Income $ 30,000 Total Operating Revenues $ 7,282,014 FY2021 Proposed Expenses: Operating Expenses Operations $ 215,858 Claims $ 4,382,199 Prescription Claims $ 843,993 Re -Insurance Fee $ 925,206 Insurance Services $ 220,902 Wellness Programs $ 5,000 OPEB Trust Contribution $ 660,779 Total Operating Expenses $ 7,253,937 Capital Expenses Capital Carryover $ - Total Capital Expenses FY2021 Proposed Budget Reserves - Health $ 7,263,937 FY2011 $ 2,877,946 FY2012 $ 2,688,329 FY2013 $ 2,646,829 FY2014 $ 2,516,262 FY2015 $ 3,322,129 FY2016 $ 2,767,051 FY2017 $ 2,492,157 FY2018 $ 3,947,017 FY2019 $ 4,657,309 FY2020 (estimated) $ 4,730,150 FY2021 (projected) $ 4,758,227 Goal $ 2,298,729 4-10 Risk Management & Workers' Comp 'f FY2020-21 FY2021 Proposed Revenues: Transfers General $ 256,000 Water & Wastewater $ 256,000 Interest Income $ 10,000 Charges Workers' Comp $ 513,480 Employee Assistance $ 9,828 Total Operating Revenues $ 1,045,308 FY2021 Proposed Expenses: Operating Expenses Risk Management $ 561,930 Worker's Compensation $ 466,537 Total Operating Expenses $ 1,028,467 Capital Expenses Recommended Capital Expenses $ 170,000 Total Capital Expenses $ 170,000 FY2021 Proposed Budget Reserves $ 1,198,467 FY2011 $ 1,008,222 FY2012 $ 1,167,779 FY2013 $ 1, 349,150 FY2014 $ 1,408,323 FY2015 $ 1,378,778 FY2016 $ 1,992,931 FY2017 $ 2,116,376 FY2018 $ 2,187,793 FY2019 $ 1,949,186 FY2020 (estimated) $ 1,950,859 FY2021 (projected) $ 1,797,700 Goal $ 600,000 4-11 \-..el HISTORICAL £t COMPARISON DATA Monthly Service Charges Et Key Fiscal Points Population Growth in Euless General Fund Multi -Year Analysis General Fund Revenue Assumptions Property Tax Revenues Tax Rate Et 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 Er Wastewater -Other Cities Impact of Water Et Wastewater Rate Increase Utility Bill Comparison Residential Monthly Service Charges Water Wastewater Trash Drainage Recycling FY21 $12.75 Base $11.00+90% of metered water **$1.49 per home Prop Tiered Rates/tgals usage @ $4.34 per tgals. $10.43** $2.75 $3.16 per home -cart 0-2 tgals - $4.21 $1.09 per apt. unit 3-8 tgals - $5.14 $.74 for Seniors 9-15 tgals - $5.71 $2.41 for Seniors home- 16-35 tgals - $6.24 cart Over 35 tgals - $6.84 FY20 $12.75 Base $11.00+90% of metered water $1.44 per home Tiered Rates/tgals usage @ $4.29 per tgals. $10.12 $2.75 $3.05 per home -cart 0-2 tgals - $4.07 $1.07 per apt. unit 3-8 tgals - $5.00 $.72 for Seniors 9-15 tgals - $5.57 $2.33 for Seniors home- 16-35 tgals - $6.10 cart Over 35 tgals - $6.70 FY19 $12.50 Base $10.75+90% of metered water $1.39 per home Tiered Rates/tgals usage @ $4.27 per tgals. $9.83 $2.75 $2.95 per home -cart 0-2 tgals - $3.88 $1.06 per apt. unit 3-8 tgals - $4.81 $.69 for Seniors 9-15 tgals - $5.38 $2.25 for Seniors home- 16-35 tgals - $5.91 cart Over 35 tgals - $6.51 "Effective for customer billings beginning April 1, 2021 through March 31, 2022. General Fund Key Fiscal Points Proposed % Change Budget % Change Actual FY21 FY20 FY19 Operating Expenses $41,320,647 -5.2% $43,577,488 9.2% $39,918,045 Capital Expenses $ 3,399,397 -14% $ 3,954,091 187% $ 1,377,834 Tax Rate .462500 per $100 0% .462500 per $100 0% .462500 per $100 Debt = .080546 Debt = .084526 Debt = .09079 M&O = .381954 M&O = .377974 M&O = .37171 Taxable Valuation* $5,164,250,293 4.6% $4,935,735,786 11.78% $4,415,713,775 Debt Rating: Moody's G.O. = Aa2 G.O. = Aa2 G.O. = Aa2 W&S = Aa2 W&S = Aa2 W&S = Aa2 Drainage = Al Drainage = Al Drainage = Al Sales Tax = Al Sales Tax = Al Sales Tax = Al S&P G.O. = AA G.O. = AA G.O. = AA W&S=AA+ W&S=AA+ W&S=AA+ Drainage = AA+ Drainage = AA+ Drainage = AA+ *Includes minimum taxable value of properties under protest and estimate of incomplete properties. 5-1 f 57,000 56,000 55,000 tit N 54,000 53,000 52,000 i a I ) ;Iij OTA V 0 (1) 57,550 N N �`� ht` ►�� tip' N +��' �g �� U ry0 r�0 T *rO T �4 r4 T T *2015 Population Estimates based on census data. Population for non -census years calculated by North Central Texas Council of Governments. General Fund Multi -Year Analysis $60.0 $50.0 $40.0 0 $30.0 a� $20.0 - --- a� $10.0 $0.0 FY2017 FY2018 FY2019 FY2020 BUD FY2020 EST FY2021 PROP ■Property Taxes ■Franchise Fees ❑Sales & Use Taxes ❑Fines & Fees ❑Licenses & Permits ■Interest Income ■Int'gov't./Trans./Misc. FY20 Budget to REVENUE ACTUAL ACTUAL ACTUAL BUDGETED ESTIMATED PROPOSED FY21 Proposed SOURCE FY2017 FY2018 FY2019 FY2020 FY2020 FY2021 % Diff Property Taxes $12,390,631 $13,639,517 $15,193,545 $17,173,713 $17,136,365 $17,787,859 3.58% Franchise Fees $4,330,670 $4,692,782 $4,438,654 $4,190,420 $4,189,025 $4,251,726 1.46% Sales & Use Taxes $13,222,232 $12,852,638 $13,176,850 $13,441,162 $10,799,631 $12,057,045 (10.30%) Fines & Fees $4,311,216 $4,134,415 $3,864,095 $3,823,150 $2,709,064 $3,080,755 (19.42%) Licenses & Permits $2,019,494 $1,875,120 $2,133,421 $681,140 $1,275,123 $665,800 (2.25%) Interest Income $140,239 $256,724 $442,141 $255,000 $299,520 $112,500 (55.88%) Int'gov't./Trans./Misc. $4,069,780 $7,177,359 $3,966,095 $4,030,923 $3,347,757 $3,413,086 (15.33%) TOTAL REVENUES $40,484,262 $44,628,555 $43,214,801 $43,595,508 $39,756,485 $41,368,771 5.11% Source PercentageRevenue - of Generat Fund Revenues Average Property Taxes 30.61 % 30.56% 35.16% 39.39% 43.10% 43.00% 36.97% Franchise Fees 10.70% 10.52% 10.27% 9.61% 10.54% 10.28% 10.32% Sales & Use Taxes 32.66% 28.80% 30.49% 30.83% 27.16% 29.15% 29.85% Fines & Fees 10.65% 9.26% 8.94% 8.77% 6.81 % 7.45% 8.65% Licenses & Permits 4.99% 4.20% 4.94% 1.56% 3.21 % 1.61 % 3.42% Interest Income 0.35% 0.58% 1.02% 0.58% 0.75% 0.27% 0.59% Int'gov't./Trans./Misc. 10.04% 16.08% 9.18% 9.26% 8.43% 8.24% 10.21% TOTAL 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 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. Through the years the trend now shows property tax to be the largest source of revenues averaging 36.97% of the total. Previously this was sales and use taxes which is now the second highest source on average at 29.85% and franchise fees third at 10.32%. Intergovernmental/ Transfers/Misc. make up approximately 10.21 % and fines & fees about 8.65% of total revenues with other sources varying from less than 1% to a little under 4%. Recent trends are showing less reliance on other sources of revenues and more on the sales and use and property taxes. 5-3 GENERAL ]FUND FY2021 REVENUE ASSUMPTIONS REVENUE SOURCE ASSUMPTIONS Property Taxes Projection based on overall tax rate of 46.250 on certified appraisals from Tarrant Appraisal District. Prior Year Property Taxes Projected to remain with FY20 budget based on historic trends. Penalties & Interest Projected a slight increase from FY20 budget based on economic outlook and trends. Sales Tax Projected 10% decrease from FY20 budget based on economic outlook. Additional Sales Tax Decrease based on 25% of projected sales tax revenues without TIF allocation. Mixed Drink Tax Projected to decrease with economic outlook. Electric Franchise Projection to remain nearly flat with FY20 budget. Gas Franchise Projected decrease from FY20 budget based on historic trends. Telephone Access Line Fees Projected to remain flat. Results of legislative action impact not fully known yet. Sanitation Services Franchise Projected a slight increase from FY20 budget based on approved rates. Recycling Franchise Projected a slight increase from FY20 budget based on approved rates. Cable Franchise Projected to remain flat. Results of legislative action impact not fully known yet. Water & Wastewater Franchise Based on 5% of projected gross receipts. Other Permits Projected to remain flat based on historical trend. Health Permits Projected to decrease from FY20 budget due to food establishment economic outlook. Fire Permits Projected to remain flat with FY20 budget. Contractors Regulatory License Projected to remain flat with FY20 budget. Minimum Housing Projected to remain flat with FY20 budget. Miscellaneous Permits and Fees Projected to decrease from FY20 budget. Building Permits Projected to remain flat with FY20 budget. Police Program Reimbursements Based on 80% of projected officer salary. School Police Reimbursements Based on current contract of four patrol officers. Municipal Court Projected to decrease from FY20 estimates. Library Fees Projected to remain flat with FY20 budget. Ambulance Fees Projection of a slight increase from FY20 budget based on historic trend but being mindful of economic conditions. Alarm Revenue Projected to remain flat with FY20 budget. Jail Revenue Projected to remain flat with FY20 budget. Interest Income Projected significant decrease from FY20 budget based on much lower rates in the market due to economic conditions and outlook. Miscellaneous Projected increase from FY20 budget as the City expects to begin charging for credit card convenience fees. Tower Lease Revenue Based on current lease agreements. Betterment Contributions Projected to remain flat with FY20 budget. Transfers Based on administrative fees charged to utility operations and 1/3 of Euless' portion of the Car Rental Tax. 5-4 PROPERTY TAXES Estimated Revenues FY21 Operating & Maintenance Debt Service Adj. Net Taxable Value Assessed $4,565,141,454 $4,565.141,454 TIF Increment Value $198,797,189 Proposed Tax Rate per $100 Valuation 0.381954 0.080546 Estimated Tax Levy $18,196,054 $3,677,039 TIF Distribution $1,064,241 Est. Percent of Collection (O&M and I&S) 97.50% 100.00% General Fund Collections $16,703,518 Ceiling Revenues $1,009,341 $212 114 Estimated Fund Collections $17,712,859 $3,889,153 Proposed Fund Distribution Additional Operating & Maintenance - General Fund Rate Percent 0.381954 82.58% $ Amount Sales Tax Total Interest and Sinking - Debt Service Fund 0.080546 17.42% $17,712,859 $3,889,153 $ 2,450,873 $ 20,163,732 $ TOTAL 0.462500 100.00% $21,602,012 - $ 3,889,153 $ 2,450,873 $ 24,052,885 Ten Year Breakdown of Tax Rate 0.500000 0.45000C 0.400000 0.350000 i+ R 0.300000 - _7 R 0.250000 O O 0.200000 d d o,sooao a.+ C 0.100000 d U 0.050000 i 0 000000 2012 2013 2014 2015 2016 2017 2018 2019 2020 Proposed 2021 ®Interest & Sinkin ®O eratin & Maintenance Fiscal Operating & Interest & Total Year Maintenance Sinking Tax Rate 2012 0,345388 0.124612 0.470000 2013 0.355130 0.114870 0.470000 2014 0.360619 0.109381 0.470000 2015 0.364505 0.102995 0.467500 2016 0.366571 0.100929 0.467500 2017 0.363053 0.099447 0.462500 2018 0.361056 0.101444 0.462500 2019 0.371710 0.090790 0.462500 2020 0.377974 0.084526 0,462500 Proposed 2021 0.381954 0.080546 0.462500 5-5 a or�AAVFN!AFIA FAF �r`� TAX RATE & EXEMPTIONS COMPARISONS OF TAX RATES CITY CURRENT TAX RATE HOMESTEAD EXEMPTION SENIOR CITIZEN EXEMPTION TAX WITH HOMESTEAD EXEMPTION ON $239,187 I"I TAX WITH SEN. CITIZEN EXEMPTION ON $229,2321B1 AVERAGE HOME VALUE 9/1/2019 TAXES ON AVERAGE HOME VALUE TAXES ON AVERAGE HOME VALUE SEN. CITIZENS BEDFORD cc' 0.5690 0% $50,000 $1,361 $1,020 $252,902 $1,439 $1,155 HURST 0.5973 20% $35,000 $1,143 $886 $226,554 $1,083 $874 N.R. HILLS 0.5720 15% $36,000 $1,163 $909 $260,404 $1,266 $1,060 GRAPEVINE 0.2843 20% $60,000 $544 $351 $369,247 $840 $669 COLLEYVILLE «' 0.3068 0% $65,000 $734 $504 $597,535 $1,833 $1,634 AVERAGE 0.4659 11 % $49,200 $989 $734 $341,328 $1,415 $1,186 EULESS 0.4625 20% $35,000 $885 $686 $239,552 $886 $724 NOTES: (A) Euless' average home value as of July 2020. (B) Average home value of senior citizen property in the City of Euless as of July 2020. (C) Bedford & Colleyville have no homestead exemption. SOURCE: Tarrant Appraisal District Website TAX RATE IMPACT FYI 9-20 FY20-21 Budgeted Proposed Tax Rate @ 46.2500 @ 46.2500 Based on $100,000 Taxable Value $100,000 $100,000 Less: Homestead Exemption, 20% $20, 000 $20, 000 Adjusted Value $80,000 $80,000 Annual Tax Burden: (at above tax rates) $370.00 $370.00 or monthly $30.83 $30.83 Over 65 - Based on $100,000 Taxable Value $100,000 $100,000 Less: Homestead Exemption, 20% $20,000 $20,000 Adjusted Value $80,000 $80,000 Less: Over 65 Exemption $35, 000 $35, 000 Net Value $45,000 $45,000 Annual Tax Burden: (at above tax rates) $208.13 $208.13 or monthly $17.34 $17.34 Average Home Value $239,390 $239,187 Annual Tax $885.74 $884.99 Over 65 Average Home Value* $228,470 $229,232 Annual Tax $683.46 $686.28 * Euless has adopted the senior tax freeze. Seniors citizens pay no more than they paid @ age 65 regardless of home value excluding improvements. Note: Home Values are based on average home values provided by Tarrant Appraisal District as of July each year. 5-7 �. WATER & WASTEWATER ]FUND FY21 REVENUE ASSUMPTIONS L REVENUE SOURCE ASSUMPTIONS Interest Income Projected to decrease based on market outlook and investable balances. Sanitation Services Increase anticipated from growth in customer base as compared with prior year estimates. Water Service Consumption is estimated to remain flat with FY2020 year-end projections. Proposed increase of 140 per 1000 gallons. The base rate remains unchanged for FY2021. Wastewater Service Anticipated treatment volume is estimated to increase 8.5% from FY2020 budgeted volume. Proposed increase of 5¢ per 1000 gallons. The base rate remains unchanged for FY2021. Reclaimed Water Service Revenue projections are based on anticipated cost increase and expansion of service area but a conservative projection on consumption. Rates per tier are based on 85% of the potable water rate per tier. Sale of New Meters Reduction from FY2020 budget due to economic crisis. Reconnect Fees Reduction from FY2020 budget due to economic crisis. Inspection Fees Projected to remain flat with FY2020 budget. Miscellaneous Increase from FY2020 budget due to implementation of credit card convenience fees. Penalties Projected to remain flat with FY2020 budget. Initiation & Transfer Fees Projected to remain flat with FY2020 budget. Recycling Fees Increase anticipated from growth in customer base as compared with prior year estimates. 5-8 L CITY OF EULESS RESIDENTIAL UTILITY RATE HISTORY WATER Year Base Rate 0-2 Tgals 3-8 Tgals 9-15 Tgals 16-35 Tgals >35 Tgals FY12 $7.95 $2.48 $3.41 $3.98 $4.36 $4.96 FY13 $8.45 $2.48 $3.41 $3.98 $4.51 $5.11 FY14 $8.45 $2.67 $3.60 $4.17 $4.70 $5.30 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 Proposed $12.75 $4.21 $5.14 $5.71 $6.24 $6.84 WASTEWATER DRAINAGE FEE 90% of Metered Lot Less Year Base Rate Water Year Than 5 Acres FY12 $6.75 $2.70 FY12 $2.50 FY13 $7.25 $2.83 FY13 $2.50 FY14 $7.25 $3.19 FY14 $2.50 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 Proposed $11.00 $4.34 FY21 Proposed $2.75 m 5-9 0 SANITATION AND RECYCLING COMPARISON OF SERVICE AND RATES CITY SINGLE FAMILY CUSTOMERS COST OF SANITATION* BAGS OR CANS BULK PICKUP COST OF RECYCLING* BEDFORD 13,672 $8.28 Either 2 days/wk. $3.78 GRAPEVINE 12,573 $15.19 Either Bi-Weekly Included N . R. HILLS 20,331 $16.84 Either 2 days/wk. Included COLLEYVILLE 9,435 $15.01 Either 2 days/wk. Included HURST 11,025 $8.52 Either 2 days/wk. $4.21 AVERAGE 13,407 $12.77 $1.60 EULESS 12,794 $10.12 Either 2 days/wk. $1.44 * Rates as of June 2020 DRAINAGE UTILITY CHARGE RESIDENTIAL MONTHLY RATE COMPARISON - Bedford $4.50 Grapevine $4.00 North Richland Hills $6.31 Colleyville $7.00 Hurst $4.00 $2.75 Rates as of June 2020 * North Richland Hills base charge on lot size. COMMERCIAL MONTHLY RATE COMPARISON" Bedford $71.88 Grapevine $27.20 North Richland Hills $28.25 Colleyville $24.40 Hurst $51.84 ,AVERAGE$40 .71 Euless $20.83 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. L COMPARATIVE RATES WATER CITY MINIMUM BILL WATER RATE 3,000 GALLONS 8,000 GALLONS 12,000 GALLONS 15,000 GALLONS 20,000 GALLONS BEDFORD - NON -SENIOR $19.30 4.241 gals $32.02 $53.22 $70.18 $82.90 $104.10 SENIOR $17.54 4.24/ gals $30.26 $51.46 $68.42 $81.14 $102.34 GRAPEVINE' $14.43 4.05/>2 gals $18.48 $38.73 $54.93 $67.08 $87.33 N. R. HILLS' $17.50 4.65tgal/ from 2-22.44 gals $29.74 $65.64 $94.36 $115.90 $151.80 4.74 tgal > 22.44 gals plus 2.53/tgal pass thru rate COLLEYVILLE $13.46 4.32/gals $26A2 $48.02 $65.30 $78.26 $99.86 HURST $17.87 7.18/>2 gals $25.05 $60.95 $89.67 $111.21 $147.11 AVERAGE $16.51 5.391gals $26.34 $53.31 $74.89 $91.07 $118.04 EULESS - proposed $12.75 4.21 / 0-2 gals $26.31 $52.01 $74.85 $91.98 $123.18 5.14 / 3-8 gals 5.71 / 9-15 gals 6.24 / 16-35 gals 6.84/ > 35 gals EULESS - proposed w/Rebate $12.75 $25.41 $49.61 $71.25 $87.48 $118.68 'Minimum bill includes first 2,000 gallons of usage. Rates as of October 2019 WASTEWATER MINIMUM WASTEWATER WATER CONSUMPTION 3,000 8,000 1 12,000 15,000 20,000 CITY BILL RATE GALLONS GALLONS GALLONS GALLONS GALLONS BEDFORD - NON -SENIOR $12.73 3.42/gals $22.99 $40.09 $53.77 $64.03 $81.13 SENIOR $11.55 3.42/gals $21.81 $38.91 $52.59 $62.85 $79.95 GRAPEVINE $10.41 4.35/> 2 gals $14.76 $36.51 $53.91 $66.96 $66.96 N. R. HILLS3 $11.00 4.28/gals $23.84 $45.24 $62.36 $75.20 $91.04 COLLEYVILLE $10.37 3.12/gals $19Y3 $35.33 $47.81 $57.17 $72.77 HURST $12.93 4.15/gals $25.38 $46.13 $62.73 $75.18 $95.93 AVERAGE $11.49 3.861ga/s $21.34 $40.66 $56.12 $67.71 $81.57 EULESS' - proposed 1 $11.00 1 4.34i als 1 $22.72 1 $42.25 $57.87 1 $63.08 1 $63.08 '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 2019 5-12 Impact of Water Rate Increase Impact of 5¢ increase on all tiers: Impact of 100 increase on all tiers: To City: Additional revenues generated To City: Additional revenues generated Increase Estimated Volume* Revenue Increase Estimated Volume* Revenue 050 2,021,132 $ 101,057 100 2,021,132 $ 202,113 To Citizens: Estimated Increase To Citizens: Estimated Increase Monthly $ 0.31 Monthly $ 0.62 Annually $ 3.72 Annually $ 7.45 Impact of 150 increase on all tiers: Impact of NO increase on all tiers: To City: Additional revenues generated To City: Additional revenues generated Increase Estimated Volume* Revenue Increase Estimated Volume* Revenue 150 2,021,132 $ 303,170 200 2,021,132 $ 404,226 To Citizens: Estimated Increase To Citizens: Estimated Increase Monthly $ 0.93 Monthly $ 1.24 Annually $ 11.17 Annually $ 14.89 * amounts shown in thousands of gallons Calculations based on 27,145 water customers Impact of Wastewater Rate Increase Impact of 5¢ increase on rate: Impact of 100 increase on rate: To City: Additional revenues generated To City: Additional revenues generated Increase Estimated Volume* Revenue Increase Estimated Volume* Revenue 050 1,545,844 $ 77,292 100 1,545,844 $ 154,584 To Citizens: Estimated Increase To Citizens: Estimated Increase Monthly $ 0.24 Monthly $ 0.49 Annually $ 2.91 Annually $ 5.82 Impact of 150 increase on rate: Impact of NO increase on rate: To City: Additional revenues generated To City: Additional revenues generated Increase Estimated Volume* Revenue Increase Estimated Volume* Revenue 150 1,545,844 $ 231,877 200 1,545,844 $ 309,169 To Citizens: Estimated Increase To Citizens: Estimated Increase Monthly $ 0.73 Monthly $ 0.97 Annually $ 8.72 Annually $ 11.63 * amounts shown in thousands of gallons Calculations based on 26,580 wastewater customers 5-13 Utility Bill Comparison CITY WATER (8 t als) WASTEWATER (8 t als) DRAINAGE SANITATION RECYCLING TOTAL BILL BEDFORD $53.22 $40.09 $4.50 $8.28 $3.78 $109.87 GRAPEVINE $38.73 $36.51 $4.00 $15.19 INCLUDED $94.43 N . R. HILLS $65.64 $45.24 $6.31 $16.84 INCLUDED $134.03 COLLEYVILLE $48.02 $35.33 $7.00 $15.01 INCLUDED $105.36 HURST $60.95 $46.13 $4.00 $8.52 $4.21 $123.81 AVERAGE $53.31 $40.66 $5.16 $12.77 $4.00 $115.90 EULESS - proposed $52.01 $42.25 $2.75 $10.43 $1.49 $108.93 All comparison cities are based on current year rates. Euless is based on the proposed rates.