Loading...
HomeMy WebLinkAboutFY 2025 TCMUD Budget Fiscal Years % of Increase/Decrease M&O (General Fund) Tax -6.38% M&O Fire Tax -0.96% M&O Tax Rate -1.29% Increase/Decrease: I & S (Debt Service) Tax -7.01% Increase/Decrease: Total Tax Rate:-2.06% Increase/Decrease: Fiscal Years % of Increase/Decrease District Tarrant Co.6.02% District Denton Co.6.73% Town 7.15% Out of District & Out of PID -27.14% Total Value:6.60% Revenue 12,726,575 Revenue 15,000 Tax Collections 85,620 Tax Collections 1,398,028 PID Surcharges 143,160 Town Assessment 572,690 Reserve Funds 285,000 Reserve Funds 184,800 Total Revenue 13,240,355 Total Revenue 2,170,518 Water Expense 7,440,945 Fire Expense 2,170,518 Wastewater Expense 3,852,935 Board of Directors Expense 11,770 Administration Expense 1,805,499 Non-Departmental Expense 113,070 Total Expense 13,224,220 Total Expense 2,170,518 Net Budget Surplus/Deficit $16,135 Net Budget Surplus/Deficit $0 Revenue 199,211 Revenue 1,273,318 Tax Collections 217,408 PID Surcharge 115,708 Total Revenue 532,328 Total Revenue 1,273,318 Debt Service Expense 532,328 Debt Service Expense 1,273,318 Total Expense 532,328 Total Expense 1,273,318 Net Budget Surplus/Deficit $0 Net Budget Surplus/Deficit $0 0.00859 FY 2025 ADOPTED BUDGET 12,316,662 3,599,368,018 2024 677,155,614 PROPERTY VALUE SUMMARY COMPARISON 717,908,930 2,003,954,100 1,106,013,301 1,877,675,027 1,032,220,715 2025 TAX RATE SUMMARY COMPARISON 2025 0.00315 0.05451 -0.00071 2024 0.00336 0.05186 0.05136 Revenue Debt Service FundTax Debt Service Fund FY 2025 BUDGET FUND SUMMARY 0.06381 0.05522 -0.00497 General Fund Fire Fund -0.02753 -0.00131 0.06250 -0.02256 -0.00060 8,973,424 3,836,849,755 0.00799 4/1/2024 - 4/29/2024 Create new fiscal year baseline budget. 5/2/2024 - 5/27/2024 Departmental budget meeting for base budget needs and wants, review calendar and set expectations. 5/31/2024 - 6/4/2024 Correspondence with Town/Fire staff to review and update the Fire Budget. Present a projected General Fund and Fire Fund budget summary at the June Board meeting. 6/8/2024 - 6/19/2024 6/20/2024 Budget workshop with District Board members and Town of Trophy Club staff. Annual IT budget meeting. 7/1/2024 Update the budget with preliminary tax evaluations, and calculate preliminary District tax rate. 7/2/2024 Provide consumption numbers and draft budget numbers to consultants for rate calculations. 7/2/2024 - Various meetings with General Manager to prepare presentation of proposed budget. 7/13/2024 Review 5 year capital plan and preliminary tax valuations for discussion at the July Board Meeting. Certified Tax values released, update Tax Assessment worksheet, and update budget projections. 7/25/2024 Calculate Comptroller Developed Water District Voter-Approval Tax Rate Worksheet. 7/30/2024 Budget meeting with Town of Trophy Club to discuss fire budget. 7/31/2024 Special budget workshop to review General Fund and Fire Fund details. Meetings with consultants to discuss rates. Discussions with financial advisor to discuss debt tax rate. 8/17/2024 - 8/18/2024 Update and finalize the fiscal year draft General Fund and Fire Fund budget for Board Meeting in August 8/21/2024 8/21/2024 -Update District's website, Denton/Tarrant County TNT websites with proposed tax rate and public hearing notice. 9/3/2024 Notice of Public Hearing for Proposed Tax Rate published in Denton Chronicle (minimum 7 days prior). 9/18/2024 9/25/2024 -Update Denton County and Tarrant County TNT websites with Adopted Tax Rates. 9/30/2024 Update District's website with Adopted Tax Rates, Adopted Rate Order, and Notice to Purchaser. Regular Board meeting to review any final budget questions and set proposed budget and tax rates for legal publications. Public Hearing/Board meeting for adoption of District Property Tax Rate, Levy Tax Resolutions, and adopt District FY Budget. FY 2025 Budget Calendar 6/5/2024 - 6/17/2024 8/7/2024 - 8/13/2024 8/15/2024 - 8/29/2024 First round of departmental proposals submitted for review, with detail explanation on account increases and capital request with supporting documentation. Update excel budget worksheets with YTD numbers thru May, revenue and tax bond debt, TexPool transfers (I&S), employee cost projections, preliminary tax valuations, and consumption forecasting and demands. FIRE TAX/ASSESSMENT RATE NET TAX VALUE: Certified TARRANT COUNTY:$717,908,930 7/25/2024 DENTON COUNTY:$2,003,954,100 7/25/2024 DENTON CO. PID:$1,106,013,301 7/25/2024 OUT OF DISTRICT & PID $8,973,424 7/25/2024 REQUIRED REVENUE TAX/ASSESS RATE = REQUIRED REVENUE/TOTAL VALS/100 FIRE Vals/100 =38,368,498 FY 2025 Tax/Assess Rate =0.05136 $1,970,718 Revenue from District Tax =1,398,028$ Revenue from Town Assess =572,690$ Total:1,970,718$ M&O TAX/SURCHARGE RATE NET TAX VALUE: Certified TARRANT COUNTY:$717,908,930 7/25/2024 DENTON COUNTY:$2,003,954,100 7/25/2024 DENTON CO. PID:$1,106,013,301 7/25/2024 REQUIRED REVENUE TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 M&O Vals/100 =38,278,763 113,070 *FY 2025 District M&O Tax Rate =0.00315 95,000 **FY 2025 Town Tax/Surcharge Rate =0.00248 *District (All of Dept. 39 Budget) **Town (Legal and Auditor only Dept 39 Budget)Revenue from MUD Tax =85,621$ Revenue from PID Surcharge =27,449$ Total:113,070$ I&S TAX/SURCHARGE RATE NET TAX VALUE: NEW DEBT: CALCULATE AMOUNT DUE FROM Town Certified TARRANT COUNTY:$717,908,930 7/25/2024 DENTON COUNTY:$2,003,954,100 7/25/2024 DENTON CO. PID:$1,106,013,301 7/25/2024 REQUIRED REVENUE TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 TAX DEBT 2014 AND AFTER (I&S)Vals/100 =38,278,763 FY 2025 PID Surcharge Rate =0.01046 *** $400,463 ***NOT FINAL TAX RATE: ONLY USED TO CALCULATE PID SHARE Revenue from District Tax =284,754$ Revenue from Town Surcharge =115,708$ Total:400,463$ MUD DEBT: CALCULATE MUD TAX NET TAX VALUE: Certified TARRANT COUNTY:$717,908,930 7/25/2024 DENTON COUNTY:$2,003,954,100 7/25/2024 REQUIRED REVENUE I&S DISTRICT DEBT TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 Vals/100 =27,218,630 $217,408 FY 2025 Tax Rate =0.00799 Revenue from District Tax =217,408$ Revenue from Town = N/A -$ Total:217,408$ Tax Rate Requirements 3.5% Overall Tax Rate FY 2025 2024 2025 M&O (General Fund) Tax 0.00336 0.00315 M&O Fire Tax 0.05186 0.05136 Voter Approval Rate M&O Tax Rate 0.05522 0.05451 Increase/Decrease Rate:-0.00497 -0.00071 I & S (Debt Service) Tax 0.00859 0.00799 Contributions Required Increase/Decrease Rate:-0.02256 -0.00060 Total Tax Rate:0.06381 0.06250 Increase/Decrease Rate:-0.02753 -0.00131$0 FY 2025 TAX RATE ASSESSMENT TOWN ASSESSMENT & SURCHARGE CALCULATIONS TAX COMPARISON 0.06250 0.06250 FY 2023 FY 2024 FY 2024 FY 2025 Actual Adopted Projected Proposed Revenues - Town Assessment - Emergency Services 519,246 541,701 541,701 572,690 Emergency Services Assessment/Delinquent - - - - Property Taxes/Assessments P&I - - - - Fire Permits/Sprinkler & Plan Review 6,418 5,000 5,000 5,000 Fire Inspections - - - - Denton/Tarrant County Pledge - Fire 10,000 10,000 10,000 10,000 Town Cash Contribution - Grant Revenue - - - - Revenues - MUD Property Taxes/MUD Fire 1,246,229 1,324,945 1,324,945 1,398,028 Property Taxes/Fire - Delinquent 6,991 - - - Property Taxes/Fire P&I 12,916 - - - Capital Leases - Other Financial Sources - - - - Proceeds from Sale of Assets 60,000 - - - Prior Year Reserves - 179,500 179,500 184,800 GASB Reserves - - - - Miscellaneous Income 14,340 - 54,417 - Total Revenue 1,876,139 2,061,146 2,115,563 2,170,518 Expenses - Town 50%/MUD 50% Salaries - Regular 853,876 950,494 950,494 1,001,354 Salaries - Part Time 23,176 50,000 50,000 50,000 Salaries - Overtime 126,709 40,303 40,303 125,008 Salaries - Longevity 6,916 7,441 7,441 8,515 Certification Pay 10,183 11,250 11,250 11,250 Salaries - Cell Phone Stipend 1,374 1,350 1,350 1,350 Salaries - Payout/Separations - - - 4,258 Retirement 130,884 130,884 148,657 Medical Insurance 75,815 79,022 79,022 87,481 Dental Insurance 4,762 4,472 4,472 8,400 Vision Insurance 676 594 594 1,760 Life Insurance & Other 3,869 3,921 3,921 4,116 Social Security Taxes 37,956 61,194 61,194 69,312 Medicare Taxes 8,874 14,311 14,311 16,210 Unemployment Taxes 116 2,520 2,520 2,520 Workman's Compensation 25,980 58,584 58,584 67,300 Pre-Employment Physicals/Testing 5,875 - - 1,000 Tuition Reimbursement 2,828 7,000 7,000 5,000 Professional Outside Services 196 1,750 1,750 1,750 Physicals/Testing - 7,000 7,000 7,000 Recruitment - - - 5,000 Software & Support 15,323 11,085 11,085 10,197 Tax Administration 1,579 1,600 1,600 1,600 Advertising - 200 200 200 Printing 249 1,100 1,100 1,100 Schools & Training 7,889 19,900 19,900 19,900 Description FY 2025 ADOPTED FIRE BUDGET FY 2023 FY 2024 FY 2024 FY 2025 Actual Adopted Projected ProposedDescription FY 2025 ADOPTED FIRE BUDGET Electricity 5,928 8,400 8,400 8,820 Water 4,312 4,000 4,000 4,000 Communications/Mobiles 18,447 16,691 16,691 16,691 Building Maintenance 43,592 37,200 37,200 30,000 Vehicle Maintenance 19,588 49,029 49,029 51,500 Equipment Maintenance 14,537 18,715 18,715 19,500 Kitchen/Janitorial Supplies - - - 7,200 Emergency Management - 1,000 1,000 1,000 Dispatch - Denton County 5,061 5,622 5,622 5,224 Copier Rental/Lease - - - 3,693 Dues & Memberships 18,791 27,242 27,242 30,000 Travel & per diem 17,461 14,510 14,510 14,510 Office Supplies 449 500 500 500 Printer Supplies 1,429 2,600 2,600 1,000 Postage 31 100 100 100 Publications/Books/Subscripts - 350 350 350 Fuel 11,978 12,225 12,225 12,225 Uniforms 9,491 9,645 9,645 9,133 Safety Equipment/Protective Clothing 36,947 40,000 40,000 40,000 Disposable Supplies 35 - - - Small Equipment 6,981 4,950 4,950 4,000 Hardware 1,283 4,458 4,458 4,000 Maintenance & Supplies 1,274 1,500 1,500 1,500 Miscellaneous Expense 2,580 4,000 4,000 3,303 Programs & Special Projects 7,354 16,931 16,931 16,000 Capital Outlays - 6,500 6,500 - Expenses - MUD 100% Maintenance & Repairs (GASB34)24 - - - Rent And/or Usage 197,266 200,771 200,771 199,211 Insurance 22,623 26,812 26,812 26,820 Transfer to Town/Fire Budget - - - - Capital Outlays - - - - Short Term Debt -Principal - - - Short Term Debt - Interest - - - - GASB34/Reserve for Replacement 81,420 81,420 81,420 - Capital Leases - Principal - - - - Total Expense 1,743,103 2,061,146 2,061,146 2,170,518 Total Fire Revenues 1,876,139$ 2,061,146$ 2,115,563$ 2,170,518$ Total Fire Expenses 1,743,103$ 2,061,146$ 2,061,146$ 2,170,518$ Net Budget Surplus (Deficit)133,036$ -$ 54,417$ -$ FY 2025 ADOPTED FIRE BUDGET FY 2024 FY 2025 Fire Budget 2,061,146 2,170,518 Less: Rent/Debt Service 200,771 199,211 Less: TML Fire Insurance 26,812 26,820 Less: Capital Outlays - - Less: Capital Leases Interest - - Less: Capital Leases Principal - - Less: GASB34/Reserve for Replacement 81,420 - Less: ESD Assessment 541,701 572,690 Less: Fire Permits/Sprinkler 5,000 5,000 Less: Fire Inspections - - Less: Denton County Fire Pledge 10,000 10,000 Less: Grant Proceeds - - Annual transfer to Town from MUD/Fire Budget 1,195,442$ 1,356,797$ 99,620$ 113,066$ Town/MUD Fire Contract Calculation Monthly payment to Town FY 2023 FY 2024 FY 2024 FY 2025 Actual Adopted Projected Proposed Revenues Property Taxes 86,595 85,734 85,734 85,620 Property Taxes/Delinquent 1,299 300 550 550 Property Taxes/P&I 1,119 300 400 500 PID Surcharges 151,357 143,223 143,200 143,160 Water 8,001,954 6,939,998 7,112,680 6,925,430 Sewer 3,736,790 3,679,786 3,548,555 3,773,500 Penalties 77,201 105,800 86,964 105,800 Service Charges (Disconnect Fees)4,100 3,350 3,700 3,350 Plumbing Inspections - 300 1,650 300 Sewer Inspections - 100 500 100 TCCC Effluent Charges 108,286 70,000 70,000 119,890 Interest Income 397,122 150,000 548,000 533,725 Cell Tower Revenue 45,179 49,320 49,440 50,930 Proceeds from Sale of Assets 50,979 25,000 51,450 25,000 Prior Year Reserves - 1,933,264 1,204,217 - GASB Reserves 164,000 50,000 50,000 285,000 Loan Proceeds - - - - Oversize Meter Reimbursement - 2,058 4,708 2,100 Interfund Transfer In - 1,178,400 1,178,400 1,178,400 Intergov Transfer In - - - - Miscellaneous Income 3,016 7,000 6,481 7,000 Records Management Revenue - - - - Recovery of Prior Year Expense 76 - - - Reimbursement/Revenue Bond - - - - Subtotal Revenues 12,829,073 14,423,933 14,146,629 13,240,355 Water Expenses Salaries & Wages 403,507 431,575 430,020 448,840 Overtime 17,676 17,000 11,386 17,000 Longevity 5,983 6,253 6,253 6,540 Certification 2,700 3,600 2,700 3,300 Retirement 50,705 56,730 55,414 57,100 Medical Insurance 87,625 116,528 97,717 105,150 Dental Insurance 3,960 4,835 4,546 5,080 Vision Insurance 744 1,051 891 980 Life Insurance & Other 3,567 4,000 3,783 4,000 Social Security Taxes 26,110 28,423 27,402 29,490 Medicare Taxes 5,906 6,647 6,409 6,897 Unemployment Taxes 54 1,260 878 1,260 Workers' Compensation 13,313 11,899 10,073 13,200 Pre-employment Physicals/Testing 420 400 400 400 Employee Relations 640 300 300 300 Maintenance & Repairs 230,476 201,500 180,000 222,000 Generator Maintenance & Repairs 876 2,000 13,470 2,000 Vehicle Maintenance & Repairs 12,919 5,000 5,000 5,000 Equipment Maintenance & Repairs 2,891 1,000 1,912 1,000 Cleaning Services 2,096 2,500 40 - Lab Analysis - District 5,492 7,500 7,500 7,500 FY 2025 ADOPTED GENERAL FUND Description FY 2023 FY 2024 FY 2024 FY 2025 Actual Adopted Projected Proposed FY 2025 ADOPTED GENERAL FUND Description Lab Analysis - Town 2,341 2,000 3,000 3,000 Communications/Mobiles 5,466 7,500 4,017 7,500 Electricity 222,085 183,143 209,900 216,400 Postage - - - - Publications/Books/Subscripts - 1,000 - - Dues & Memberships - - - - Schools & Training 3,124 2,630 3,547 3,000 Travel & per diem 45 578 604 920 TCEQ Fees & Permits - District 34,114 29,500 25,135 29,500 TCEQ Fees & Permits - Town 214 500 500 500 Wholesale Water 2,738,044 2,655,497 2,717,862 2,757,560 Lawn Services 5,400 12,500 10,200 12,500 Interfund Transfer Out - Revenue I&S 567,783 565,797 565,797 568,498 Interfund Transfer Out - Bank Reserve - - - - Furniture/Equipment < $5000 1,355 - - - Fuel & Lube 18,660 23,575 18,399 23,580 Uniforms 3,098 4,355 2,779 4,360 Chemicals 47,747 58,200 33,000 35,000 Meter Expense - 20,000 19,740 20,000 Meter Change Out Program 87,000 124,500 83,555 130,000 Office Supplies - - - - Capital Outlays 2,107,269 4,200,000 3,840,711 2,265,000 Short Term Debt - Principal 31,882 - - - Short Term Debt - Interest 470 - - - Gasb34 Reserves 162,639 378,659 378,659 426,590 Water Tank Inspection Contract 110,864 - - - Bond Related Expenses - - - - Subtotal Water Expenses 7,027,259 9,179,933 8,783,498 7,440,945 Wastewater Expenses Salaries & Wages 292,361 290,305 220,031 275,760 Overtime 16,059 20,000 11,062 20,000 Longevity 4,035 2,368 2,540 2,770 Certification 4,350 5,100 5,700 5,700 Retirement 37,504 40,934 24,691 36,500 Medical Insurance 63,848 93,222 56,506 60,090 Dental Insurance 2,643 3,385 2,482 2,790 Vision Insurance 564 819 544 590 Life Insurance & Other 2,547 3,000 2,209 3,000 Social Security Taxes 19,162 20,508 14,112 18,860 Medicare Taxes 4,481 4,796 3,300 4,411 Unemployment Taxes 44 1,008 400 1,010 Workers' Compensation 10,635 8,404 6,864 8,356 Pre-employment Physicals/Testing 150 400 400 400 Employee Relations 1,228 300 300 300 Maintenance & Repairs - WWTP 220,313 137,000 135,551 149,000 Maintenance & Repairs - Collections 259,373 270,000 330,000 330,000 Generator Maintenance & Repairs 2,836 11,000 6,478 11,000 Vehicle Maintenance - WWTP 640 4,600 1,000 4,600 Vehicle Maintenance - Collections 11,144 13,000 5,000 11,480 FY 2023 FY 2024 FY 2024 FY 2025 Actual Adopted Projected Proposed FY 2025 ADOPTED GENERAL FUND Description Equipment Maintenance & Repairs 2,435 3,000 3,000 3,000 Cleaning Services 2,096 2,000 40 - Dumpster Services 85,077 100,000 100,000 103,000 Lab Analysis 50,001 55,000 60,600 60,000 Communications/Mobiles 4,016 7,500 3,260 5,000 Electricity 272,792 242,978 226,800 314,100 Schools & Training 2,561 2,119 1,580 2,420 Travel & per diem 3 528 100 870 TCEQ Fees & Permits 9,888 12,000 9,900 12,000 Lawn Services 6,390 16,000 15,750 16,000 Interfund Transfer Out - Tax I&S 116,245 115,886 115,886 115,708 Interfund Transfer Out - Revenue I&S 691,932 698,543 698,543 704,820 Interfund Transfer Out - Bank Reserve - - - - Furniture/Equipment < $5000 347 - - - Fuel & Lube 12,206 13,000 11,427 13,000 Uniforms 2,932 3,520 2,000 3,520 Chemicals - WWTP 22,109 32,500 31,843 32,500 Chemicals - Collections 6,003 10,000 5,709 10,000 Lab Supplies 27,835 33,000 33,000 33,000 Capital Outlays 1,390,083 1,050,000 1,023,468 1,140,000 Short Term Debt - Principal 85,763 22,398 22,398 - Short Term Debt - Interest 2,835 442 442 - Gasb34 Reserves 165,777 155,762 155,762 337,380 Subtotal Wastewater Expenses 3,913,241 3,506,324 3,350,679 3,852,935 Board of Directors Expenses Workman's Compensation 7 15 8 20 Dues & Memberships 750 750 750 750 Meetings 1,451 1,500 1,500 1,500 Schools & Training 535 4,000 485 4,000 Travel & per diem - 5,000 - 5,000 Miscellaneous Expenses - 500 - 500 Subtotal Board of Directors Expenses 2,743 11,765 2,743 11,770 Administration Expenses Salaries & Wages 616,594 663,185 657,800 662,170 Overtime 1,094 2,000 1,620 2,000 Longevity 2,423 2,533 2,600 2,290 Retirement 72,808 82,631 80,700 79,976 Medical Insurance 77,664 108,759 81,800 105,150 Dental Insurance 3,064 3,817 3,120 3,810 Vision Insurance 629 886 690 830 Life Insurance & Other 4,382 4,800 5,030 4,800 Social Security Taxes 36,720 41,399 39,200 41,320 Medicare Taxes 8,653 9,682 9,300 9,660 Unemployment Taxes 59 1,512 1,025 1,510 Workers' Compensation 1,291 1,597 1,319 1,703 Pre-employment Physicals/Testing 198 500 400 400 Employee Relations 2,842 4,000 4,000 4,000 Software & Support 108,247 130,311 132,661 153,810 FY 2023 FY 2024 FY 2024 FY 2025 Actual Adopted Projected Proposed FY 2025 ADOPTED GENERAL FUND Description Independent Labor 6,473 - - - Maintenance & Repairs 22,778 23,000 20,000 23,000 Generator Maintenance & Repairs - 1,000 1,348 1,000 Cleaning Services 13,354 13,825 18,055 20,000 Professional Outside Services 74,770 100,000 98,000 100,000 Utility Billing Contract 7,701 9,000 7,860 9,000 Telephone 5,763 6,000 6,110 6,000 Communications/Mobiles 190 3,000 580 3,000 Electricity 18,313 17,685 29,740 20,300 Water 4,971 5,000 1,736 - Postage 24,227 30,000 25,500 30,000 Bank Service Charges & Fees 165,491 140,000 150,650 155,000 Bad Debt Expense 11,623 13,000 13,000 13,000 Insurance 97,414 116,158 116,200 129,860 Dues & Memberships 6,965 6,800 3,000 2,560 Public Education 27,795 - - - Schools & Training 626 3,900 1,350 3,550 Travel & per diem - 1,228 500 4,270 Elections - 10,000 - - Advertising 1,265 - - - Miscellaneous Expenses 4,145 - 2,550 - Lawn Services 3,468 5,000 6,200 6,000 Furniture/Equipment < $5000 13,053 3,000 - - Uniforms 307 530 - 530 Hardware IT 14,265 8,200 7,000 50,000 Office Supplies 4,303 5,000 5,000 5,000 Maintenance Supplies 5,833 5,000 6,000 6,000 Capital Outlays 56,090 - - 115,000 Copier Lease 3,210 4,000 3,340 4,000 Gasb34 Reserves 26,736 24,903 24,903 25,000 Subtotal Administration Expenses 1,557,796 1,612,840 1,569,887 1,805,499 Non Departmental Expenses Legal 30,163 65,000 45,000 65,000 Auditing 23,164 30,000 21,800 30,000 Appraisal 11,264 13,071 10,050 13,070 Tax Admin Fees 4,046 5,000 3,941 5,000 Subtotal Non Departmental Expenses 68,637 113,071 80,791 113,070 Total General Fund Revenues 12,829,073$ 14,423,933$ 14,146,629$ 13,240,355$ Total General Fund Expenses 12,569,676$ 14,423,933$ 13,787,598$ 13,224,220$ Net Budget Surplus (Deficit)259,397$ 0$ 359,031$ 16,135$ LONG TERM TAX DEBT MUD/PID Reimburse Par Amount Principal FY 2025 Interest 3/01 Interest 9/01 Subtotal Interest Paying Agent Fee Total Maturity Date First Callable Date Project/Reason Series 2020 (Tax) MUD $1,220,000 $120,000 $5,558 $5,558 $11,115 $750 $131,865 9/1/2031 N/A Refund MUD #1 Unlimited Tax Bonds Series 2010 and costs of issuance of the Bonds, Trophy Club Fire Station $1,220,000 $120,000 $5,558 $5,558 $11,115 $750 $131,865 Series 2014 (Tax) MUD/PID $5,765,000 $295,000 $52,531 $52,531 $105,063 $400 $400,463 9/1/2034 9/1/2024 Tax Bonds for WWTP Expansion $5,765,000 $295,000 $52,531 $52,531 $105,063 $400 $400,463 $6,985,000 $415,000 $58,089 $58,089 $116,178 $1,150 $532,328 LONG TERM REVENUE DEBT Revenue Rates Par Amount Principal FY 2025 Interest 3/01 Interest 9/01 Subtotal Interest Paying Agent Fee Total Maturity Date First Callable Date Project/Reason Series 2015 (Revenue) WWTP $9,230,000 $450,000 $83,569 $83,569 $167,138 $400 $617,538 9/1/2035 9/1/2025 Revenue Bonds for WWTP Expansion Series 2016 (Revenue) SWIFT $4,635,000 $225,000 $25,446 $25,446 $50,893 $400 $276,293 9/1/2036 9/1/2027 Revenue Bonds for Fort Worth Line NSII Series 2019 (Revenue) WT & WW $7,080,000 $175,000 $102,044 $102,044 $204,088 $400 $379,488 9/1/2049 9/1/2028 Revenue Bonds for 16in Water Line (77%) Overrun for WWTP Expansion (23%) $20,945,000 $850,000 $211,059 $211,059 $422,118 $1,200 $1,273,318 TAX DEBT PAYMENTS REVENUE DEBT PAYMENTS TOTAL ALL REVENUE BONDS: TOTAL ALL TAX BONDS: SUBTOTAL MUD ONLY TAX BONDS: SUBTOTAL MUD/PID TAX BONDS: 0 200000 400000 600000 800000 1000000 1200000 1400000 1600000 1800000 2000000 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2049 Annual Long-Term Debt Payments WT & WW REV SERIES 2019 ($7,080,000) WT REV SERIES 2016 ($4,635,000) WW REV SERIES 2015 ($9,230,000) UTR GO SERIES 2020 ($1,220,000) UTR GO SERIES 2014 ($5,765,000) Department FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 Water Water Line Replacement 2,200,000$ 2,200,000$ 2,200,000$ 2,200,000$ 2,300,000$ Fleet Replacement 65,000$ -$ 50,000$ -$ -$ Water Grand Totals 2,265,000$ 2,200,000$ 2,250,000$ 2,200,000$ 2,300,000$ Wastewater Wastewater Line Improvements 850,000$ 200,000$ 200,000$ 200,000$ 200,000$ Lift Station Improvements 100,000$ 50,000$ 50,000$ 50,000$ 50,000$ Return Pump 45,000$ 45,000$ 45,000$ -$ -$ Fleet Replacement 80,000$ -$ -$ -$ -$ CCTV Camera Replacement 65,000$ -$ -$ -$ -$ Wastewater Grand Totals 1,140,000$ 295,000$ 295,000$ 250,000$ 250,000$ Administration Security Upgrades 75,000$ -$ -$ -$ -$ Software Upgrades 40,000$ -$ -$ -$ -$ Admin Grand Totals 115,000$ -$ -$ -$ -$ CAPITAL OUTLAYS (5 Year) Trendline Actuals ANNUAL WASTEWATER FLOW AND REVENUE BY YEAR ANNUAL WATER CONSUMPTION AND REVENUE BY YEAR AVERAGE MONTHLY METERS AND AVERAGE GALLONS BY YEAR 500 200,500 400,500 600,500 800,500 1,000,500 1,200,500 1,400,500 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 Annual Consumption in (Thousand) Gallons 4,450 4,500 4,550 4,600 4,650 4,700 4,750 4,800 4,850 4,900 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 Average Monthly Meters $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000 $8,000,000 $9,000,000 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 Annual Water Revenue 12,000 13,000 14,000 15,000 16,000 17,000 18,000 19,000 20,000 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 Average Monthly Gallons per Meter 0 100,000 200,000 300,000 400,000 500,000 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 Annual WWTP Flow in (Thousand) Gallons $2,000,000 $2,250,000 $2,500,000 $2,750,000 $3,000,000 $3,250,000 $3,500,000 $3,750,000 $4,000,000 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 Annual Wastewater Revenue