Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
FY 2024 TCMUD Budget
Trophy Club Municipal Utility District No. 1 100 Municipal Drive Trophy Club, Texas 76262 (682) 831-4600 15,000 1,324,945 541,701 179,500 2,061,146 2,061,146 2,061,146 1,264,340 Total Revenue 1,264,340 Debt Service Expense 1,264,340 Total Expense 1,264,340 Trophy Club MUD No. 1 FY 2024 ADOPTED BUDGET TAX RATE SUMMARY COMPARISON Fiscal Years 2023 2024 % of Increase/Decrease MUD Tarrant Co. Fiscal Years 2023 2024 % of Increase/Decrease MUD Denton Co. M&O (General Fund) Tax 0.00393 0.00336 -14.70% 919,078,121 M&O Fire Tax 0.05625 0.05186 -7,81% 12,316,662 M&O Tax Rate 0.06019 0.05522 -8.26% Increase/Decrease: -0.01081 -0.00497 I & 5 (Debt Service) Tax 0.03115 0.00859 -72.42% Increase/Decrease: -0.00374 -0.02256 Total Tax Rate: 0.09134 0.06381 -30.14% J Increase/Decrease: -0.01454 -0.02753 PROPERTY VALUE SUMMARY COMPARISON Fiscal Years 2023 2024 % of Increase/Decrease MUD Tarrant Co. 590,349,578 677,155,614 14.70% MUD Denton Co. 1,645,315,777 1,877,675,027 14.12% PID 919,078,121 1,032,220,715 12.31% Out of District & PID 704,864 12,316,662 1647.38% Total Value: • 3,155,448,340 3,599,368,018 14.07% FY 2024 BUDGET FUND SUMMARY General Fund Revenue Tax Collections PID Surcharges Reserve Funds Total Revenue 12,211,712 85,734 143,223 1,983,264 14,423,933 Water Expense Wastewater Expense Board of Directors Expense Administration Expense Non -Departmental Expense Total Expense 9,179,933 3,506,324 11,765 1,612,840 113,071 14,423,933 Net Budget Surplus/Deficit $0 Tax Debt Service Fund Revenue Tax Collections PID Surcharge 200,771 219,481 115,886 Total Revenue 536,138 Debt Service Expense 536,138 Total Expense 536,138 Net Budget Surplus/Deficit so Fire Fund Revenue Tax Collections PID Assessment Reserve Funds Total Revenue Fire Expense Total Expense Net Budget Surplus/Deficit so Revenue Debt Service Fund Revenue Net Budget Surplus/Deficit so FY 2024 Budget Calendar 4/1/2023 - 4/29/2023 Create Budget Calendar Create new fiscal year baseline budget in Excel and Clear Gov Operational Budget 5/2/2023- 5/27/2023 Departmental budget meeting for base budget needs and wants, review calendar and set expectations 5/31/2023 - 6/4/2023 First round of Departmental Proposals should be submitted for review Detail explanation on account increases and capital request with quotes and supporting documents 6/5/2023 Budget meeting with Town/Fire staff to review and update the Fire Budget, Budget Committee meeting to review draft Present a projected General Fund and Fire Fund budget summary at the June Board meeting 6/8/2023 - 6/11/2023 Update excel budget worksheets YTD thru May, Revenue and Tax Bond Debt, TexPool Transfers (I&S) employee cost projections, preliminary tax valuations, and consumption forecasting and demands 6/14/2023 Meeting with General Manager, Operations Manager, and Finance Manager to discuss 5 year CIP projection Impact to rates and Cash Reserves, and overall projected budget review 6/17/2023 - 6/24/2023 Meet with department supervisors to address budget demands and required reductions All departmental budget proposal submissions and documents are due to Finance Department 6/25/2023 - 6/28/2023 Review and approve resubmittal department proposals, reach out to Fire Department/Town for proposed Fire Budget, update the excel budget with preliminary tax evaluations, and calculate preliminary District tax rate 6/30/2023 Provide consumption numbers and draft budget numbers for rate calculations to NewGen for rate assessment calculations 7/6/2023 Budget Committee Meeting to review initial draft budget and discuss potential rate impacts 7/13/2023 Meet with General Manager to present proposed budget Review 5 year capital plan and preliminary tax valuations to put together for July Board Meeting 7/25/2023 Certified Tax Roll numbers released, update Tax Assessment worksheet, and update budget projections Calculate HS tax averages and Comptroller Developed Water District Voter -Approval Tax Rate Worksheet 7/27/2023 Final projected budget numbers to NewGen for rate assessment and updated Rate Model 8/2/2023 Special Board Budget Workshop to review General Fund and Fire Fund Details 8/7/2023 Notify Town of Trophy Club of proposed Fire Assessment Rate and get final updated projected and proposed numbers 8/16/2023 Special Board Budget Workshop to review Fire Budget details with Fire Chief 8/17/2023 - 8/18/2023 Update and finalize the fiscal year draft General Fund and Fire Fund budget for Boar Meeting in August 8/23/2023 Regular Board meeting to review any final budget questions and set proposed Budget and Tax Rates for legal publications 8/21/2023 - 9/3/2023 Update District's website and Denton/Tarrant County TNT websites with Proposed Tax Rate and Public Hearing Notice Notice of Public Hearing for Proposed Tax Rate published in Denton Chronicle (minimum 7 days prior) 9/20/2023 Public Hearing/Board meeting for adoption of District Property Tax Rate, Levy Tax Resolutions, and adopt District FY Budget 9/25/2023 - 9/30/2023 Update Denton County and Tarrant County TNT websites with Adopted Tax Rates Update District's website with Adopted Tax Rates, Adopted Rate Order, and Notice to Purchaser *Some of the following dates are estimated and maybe subject to change as needed TAX RATE ASSESSMENT PID ASSESSMENT & SURCHARGE CALCULATIONS FIRE TAX/ASSESSMENT RATE NET TAX VALUE: TARRANT COUNTY: $677,155,614 DENTON COUNTY: $1,877,675,027 DENTON CO. PID: $1,032,220,715 OUT OF DISTRICT & PID $12,316,662 REQUIRED REVENUE FIRE $1,866,646 TAX/ASSESS RATE = REQUIRED REVENUE/TOTAL VALS/100 Vals/100 = 35,993,680 FY 2023 Tax/Assess Rate = 0.05186 Revenue from MUD Tax = Revenue from PID Assess = $ $ Total: $ 1,324,945 541,701 1,866,646 Certified 7/24/2023 7/24/2023 7/24/2023 M&O TAX/SURCHARGE RATE NET TAX VALUE: TARRANT COUNTY: $677,155,614 DENTON COUNTY: $1,877,675,027 DENTON CO. PID: $1,032,220,715 REQUIRED REVENUE M&O 113,071 95,000 *MUD (All of Dept. 39 Budget) **PID (Legal and Auditor only Dept 39 Budget) * ** TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 Vals/100 = 35,870,514 FY 2023 MUD M&O Tax Rate = 0.00336 FY 2023 PID Tax/Surcharge Rate = 0.00265 Revenue from MUD Tax = Revenue from PID Surcharge = $ 85,734 $ 27,337 Total: $ 113,071 Certified 7/24/2023 7/24/2023 7/24/2023 I&S TAX/SURCHARGE RATE NET TAX VALUE: NEW DEBT: CALCULATE AMOUNT DUE FROM PID TARRANT COUNTY: $677,155,614 DENTON COUNTY: DENTON CO. PID: REQUIRED REVENUE TAX DEBT 2014 AND AFTER (I&S) $402,713 $1,877,675,027 $1,032,220,715 TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 Vals/100 = 35,870,514 FY 2023 PID Surcharge Rate = 0.01123 ...NOT FINAL TAX RATE: ONLY USED TO CALCULATE PID SHARE Revenue from MUD Tax = Revenue from PID Surcharge = $ $ Total: $ 286,827 115,886 402,713 * * * Certified 7/24/2023 7/24/2023 7/24/2023 MUD DEBT: CALCULATE MUD TAX NET TAX VALUE: TARRANT COUNTY: $677,155,614 DENTON COUNTY: $1,877,675,027 REQUIRED REVENUE I&S MUD DEBT $219,481 TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 Vals/100 = 25,548,306 FY 2023 Tax Rate = Revenue from MUD Tax = Revenue from PID = N/A $ $ Total: $ 0.00859 219,481 219,481 Certified 7/24/2023 7/24/2023 Tax Rate Requirements 3.5% Overall Tax Rate FY 2024 0.06381 Voter Approval Rate 0.06381 Contributions Required $0 TAX COMPARISON 2023 2024 M&O (General Fund) Tax 0.00393 0.00336 M&O Fire Tax 0.05625 0.05186 M&O Tax Rate 0.06019 0.05522 Increase/Decrease Rate: -0.01081 -0.00497 1 & S (Debt Service) Tax 0.03115 0.00859 Increase/Decrease Rate: -0.00374 -0.02256 Total Tax Rate: 0.09134 0.06381 Increase/Decrease Rate: -0.01454 -0.02753 FIRE DEPARTMENT FUND Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted FY 2023 Amended FY 2023 Projected FY 2024 Adopted Budget vs Amended Budget % Change FY 2025 Proposed Revenues - Town 671,577 697,488 693,010 716,522 745,734 867,427 950,494 204,760 27.46% 969,503 Assessment - Emergency Services 513,618 507,446 528,546 517,385 517,385 517,385 541,701 24,316 4.70% 626,787 Emergency Services Assessment/Delinquent - - - - -- - - - 0.00% - PropertyTaxes/AssessmentsP&I - - - - - - - - 0.00% - Fire Permits/Sprinkler & Plan Review 47,977 4,226 5,000 5,000 5,000 5,000 5,000 - 0.00% 5,000 Fire Inspections -- - - - - - - - 0.00% - Denton/Tarrant County Pledge - Fire 17,072 17,072 17,000 17,000 17,000 10,000 10,000 (7,000) -41.18% 10,000 Grant Revenue 17,009 - - - - - - - 0.00% - Revenues - MUD Er 100,538 113,794 109,271 111,785 115,753 136,667 130,884 15,131 13.07% 133,502 Property Taxes/MUD Fire 1,223,805 1,205,268 1,279,821 1,257,579 1,257,579 1,257,579 1,324,945 67,366 5.36% 1,447,386 Property Taxes/Fire - Delinquent 3,736 32,221 2,425 - - 6,970 - - 0.00% - PropertyTaxes/FireP&I 6,897 5,283 4,639 - - 12,633 - - 0.00% - Capital Leases - Other Financial Sources - - - - - - - - 0.00% 3,999 Proceeds from Sale of Assets - - - - - 60,000 - - 0.00% - Prior Year Reserves - 57,369 - - - - 179,500 179,500 0.00% - GASB Reserves - - 554,301 - - - - - 0.00% - Miscellaneous Income 24,423 - - - - 191,028 - - 0.00% - Total Revenue 1,854,538 1,828,885 2,391,733 1,796,964 1,796,964 2,060,595 2,061,146 264,182 14.70% 2,089,173 Expenses - Town 50%/MUD 50% Salaries -Regular 671,577 697,488 693,010 716,522 745,734 867,427 950,494 204,760 27.46% 969,503 Salaries - Part Time - 49,275 37,954 50,000 50,000 29,779 50,000 - 0.00% 51,000 Salaries - Merits - - - 35,337 35,337 - - (35,337) -100.00% - Salaries - Overtime 75,008 115,592 128,564 83,580 83,580 142,736 40,303 (43,277) -51.78% 41,109 Salaries - Longevity 6,838 7,343 7,574 7,607 7,607 6,916 7,441 (166) -2.18% 7,590 Salaries - Stipend - - - - - - - - 0.00% - Certification Pay 9,063 10,176 8,277 10,838 10,838 10,546 11,250 413 3.81% 11,475 Salaries - Cell Phone Stipend - 1,875 1,082 900 900 1,430 1,350 450 50.00% 1,350 Retirement 100,538 113,794 109,271 111,785 115,753 136,667 130,884 15,131 13.07% 133,502 Medical lnsurance 76,605 76,715 64,881 91,140 91,140 80,337 79,022 (12,118) -13.30% 80,602 Dental Insurance 5,514 5,559 3,959 6,544 6,544 3,728 4,472 (2,072) -31.66% 4,561 Vision Insurance 525 513 498 631 631 592 594 (37) -5.86% 606 Life Insurance & Other 4,087 4,633 3,195 5,565 5,638 4,096 3,921 (1,717) -30.46% 3,999 Social Security Taxes 44,880 52,773 51,451 51,444 53,339 38,956 61,194 7,856 14.73% 62,418 Medicare Taxes 10,496 12,338 12,057 12,031 12,474 9,874 14,311 1,837 14.72% 14,598 Unemployment Taxes 426 4,993 207 2,520 2,520 123 2,520 - 0.00% 2,570 Workman's Compensation 15,004 17,868 20,249 19,047 19,810 19,810 58,584 38,774 195.73% 59,756 Pre -Employment Physicals/Testing 3,867 4,078 4,342 - - 5,785 - - 0.00% - Tuition Reimbursement 1,497 5,074 4,043 - - 2,315 7,000 7,000 0.00% 7,140 Professional Outside Services - 1,567 40,504 1,750 1,750 1,750 1,750 - 0.00% 1,785 Physicals/Testing -- - - - - 7,000 7,000 0.00% 7,000 Software & Support 12,495 12,354 14,564 17,164 17,164 17,164 11,085 (6,079) -35.42% 11,307 Tax Administration - 1,521 1,542 1,600 1,600 1,579 1,600 - 0.00% 1,632 Advertising - - - 1,000 1,000 - 200 (800) -80.00% 204 Printing 141 280 266 300 300 249 1,100 800 266.67% 1,122 Schools & Training 14,427 9,478 11,449 19,900 19,900 19,900 19,900 - 0.00% 20,298 Electricity 4,970 5,530 5,853 8,400 8,400 8,400 8,400 - 0.00% 8,568 Water 3,935 3,734 3,318 4,000 4,000 4,000 4,000 - 0.00% 4,080 Communications/Mobiles 12,345 14,692 18,816 16,691 16,691 16,691 16,691 - 0.00% 17,025 Building Maintenance 22,727 25,176 55,628 22,200 22,200 42,512 37,200 15,000 67.57% 37,944 Vehicle Maintenance 31,865 17,136 24,128 40,800 40,800 40,800 49,029 8,229 20.17% 50,010 Equipment Maintenance 5,719 10,241 11,155 18,715 18,715 18,715 18,715 - 0.00% 19,089 Emergency Management 1,000 1,000 - 1,000 1,000 1,000 1,000 - 0.00% 1,020 Dispatch - Denton County 3,986 3,946 4,021 5,061 5,061 5,061 5,622 561 11.08% 5,734 Dues & Memberships 19,782 20,417 19,154 20,337 20,337 20,337 27,242 6,905 33.95% 27,787 Flags & Repair - 215 -- - - - - 0.00% - Travel & per diem 5,326 8,236 17,410 14,510 14,510 14,921 14,510 - 0.00% 14,800 Office Supplies 390 327 267 500 500 500 500 - 0.00% 510 Printer Supplies - 1,007 1,371 1,600 1,600 1,600 2,600 1,000 62.50% 2,652 Postage 31 73 65 100 100 100 100 - 0.00% 102 Publications/Books/Subscripts 334 297 - 350 350 350 350 - 0.00% 357 Fuel 6,959 8,997 12,141 12,225 12,225 12,225 12,225 - 0.00% 12,470 Uniforms 7,001 7,850 9,129 9,645 9,645 9,645 9,645 - 0.00% 9,838 Safety Equipment/Protective Clothing 24,353 8,970 16,026 40,000 40,000 40,000 40,000 - 0.00% 40,800 Disposable Supplies - - 46 - - 35 - - 0.00% - Small Equipment 3,591 161 4,705 4,950 9,542 9,542 4,950 (4,592) -48.13% 5,049 FIRE DEPARTMENT FUND Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted FY 2023 Amended FY 2023 Projected FY 2024 Adopted Budget vs Amended Budget % Change FY 2025 Proposed Hardware 2,592 1,106 2,504 4,458 4,458 4,458 4,458 - 0.00% 4,547 Maintenance & Supplies 1,113 375 1,648 1,500 1,500 1,500 1,500 - 0.00% 1,530 Miscellaneous Expense 27,936 3,562 3,954 4,000 4,000 4,000 4,000 - 0.00% 4,080 Programs & Special Projects 18,023 9,649 16,402 16,931 16,931 16,931 16,931 - 0.00% 17,270 Capital Outlays - - - - - - 6,500 6,500 0.00% - Expenses - MUD 100% 5,900 - - - - - - - 0.00% - Maintenance & Repairs (GASB34) Rent And/or Usage 218,004 197,281 198,761 197,266 197,266 197,266 200,771 3,505 1.78% 199,211 Insurance 19,691 19,789 19,958 23,100 23,100 22,623 26,812 3,712 16.07% 28,153 Capital Outlays 39,743 - 554,301 - - 191,028 - - 0.00% - Short Term Debt - Interest 9,078 6,127 3,102 - - - - - 0.00% - GASB34/Reserve for Replacement 81,420 81,420 81,420 81,420 81,420 81,420 81,420 - 0.00% 81,420 Capital Leases - Principal 118,070 121,022 124,047 - - - - - 0.00% - Total Expense 1,748,871 1,783,622 2,428,271 1,796,964 1,837,910 2,167,420 2,061,146 223,236 12.15% 2,089,173 Total Fire Revenues $ 1,854,538 $ 1,828,885 $ 2,391,733 $ 1,796,964 $ 1,796,964 $ 2,060,595 $ 2,061,146 264,182 14.70% $ 2,089,173 Total Fire Expenses $ 1,748,871 $ 1,783,622 $ 2,428,271 $ 1,796,964 $ 1,837,910 $ 2,167,420 $ 2,061,146 223,236 12.15% $ 2,089,173 Net Budget Surplus (Deficit) $ 105,667 $ 45,262 $ (36,538) $ - $ (40,946) $ (106,825) $ - 40,946 - $ 0 Town/MUD Fire Contract Calculation FY 2023 FY 2024 Fire Budget 1,796,964 2,061,146 Less: Rent/Debt Service 197,266 200,771 Less: TML Fire Insurance 23,100 26,812 Less: Capital Outlays - - Less: Capital Leases Interest - - Less: Capital Leases Principal - - Less: GASB34/Reserve for Replacement 81,420 81,420 Less: ESD Assessment 517,385 541,701 Less: Fire Permits/Sprinkler 5,000 5,000 Less: Fire Inspections - - Less: Denton County Fire Pledge 17,000 10,000 Less: Grant Proceeds - - Annual transfer to Town from MUD/Fire Budget $ 955,793 $ 1,195,442 Monthly payment to Town October - September $ 79,649 $ 99,620 GENERAL FUND •n FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted FY 2023 Amended FY 2023 Projected FY 2024 Adopted Budget vs Budget Net Budget % Change FY 2025 Proposed Salaries & Wages 358,683 353,851 362,451 407,139 407,139 407,139 431,575 24,436 6.00% 453,154 Property Taxes 135,857 134,965 138,467 87,956 87,956 87,956 85,734 (2,223) -2.53% 88,306 Property Taxes/Delinquent 402 527 (179) 300 300 1,297 300 - 0.00% 300 Property Taxes/P&I 769 581 541 300 300 1,099 300- - 0.00% 300 PID Surcharges 164,700 162,305 164,890 145,029 145,029 145,029 143,223 (1,806) -1.24% 147,520 Water 5,765,931 5,617,478 6,843,941 6,710,979 7,142,255 7,142,255 6,939,998 229,019 3.41% 6,831,639 Sewer 3,254,599 3,604,966 3,856,157 3,839,686 3,670,000 3,670,000 3,679,786 (159,900) -4.16% 3,679,786 Penalties 61,753 86,208 105,893 78,000 78,000 73,227 105,800 27,800 35.64% 108,974 Service Charges (Disconnect Fees) 9,950 12,100 4,695 5,600 5,600 4,500 3,350 (2,250) -40.18% 3,350 Plumbing Inspections 5,300 300 600 300 300 300 300 - 0.00% 300 Sewer lnspections 5,050 100 150 100 100 100 100 - 0.00% 100 TCCC Effluent Charges 89,037 72,210 109,207 60,000 100,000 100,000 70,000 10,000 16.67% 70,000 Utility Fees - - - - - - - - 0.00% - CapitalLease- Other Sources- 235 - - - - - - - 0.00% - Interest Income 81,518 18,386 66,251 20,000 380,000 380,000 150,000 130,000 650.00% 150,000 Cell Tower Revenue 12,967 14,146 14,146 14,146 37,179 41,179 49,320 35,174 248.66% 50,800 Building Rent Income 5,833 - - - - - - - 0.00% 206,000 Proceeds from Sale of Assets 12,520 23,975 21,001 25,000 50,000 50,000 25,000- - 0.00% 25,000 Prior Year Reserves - - - 572,900 572,900 572,900 1,933,264 1,360,364 237.45% 262,859 GASB Reserves- 1,828 - - 164,000 164,000 164,000 50,000 (114,000) -69.51% 315,000 Loan Proceeds - - - - - - - - 0.00% - Oversize Meter Reimbursement 19,732 4,407 2,654 2,058 2,058 - 2,058 - 0.00% 2,058 Interfund Transfer In - - - - - - 1,178,400 1,178,400 0.00% 2,000 IntergovTransfer In- 5,334 5,551 6,865 7,500 - - - - 0.00% - Miscellaneous Income 35,761 19,912 7,899 7,000 7,000 5,000 7,000 - 0.00% 7,000 Records Management Revenue - - - - - - - - 0.00% - Recovery of Prior Year Expense - - 85,000 - - 76 - - 0.00% - Reimbursement/Revenue Bond - - - - - - - - 0.00% - IbItotalRevenues 9,661,678 9,772,566 11,421,312 11,733,354 12,442,977 12,438,•• - - 0.00% - Water Expenses Salaries & Wages 358,683 353,851 362,451 407,139 407,139 407,139 431,575 24,436 6.00% 453,154 Overtime 20,986 22,293 32,273 17,000 17,000 13,100 17,000 - 0.00% 17,000 Longevity 5,083 5,435 5,713 5,983 5,983 5,983 6,253 270 4.51% 6,565 Certification 4,900 3,025 2,650 3,600 3,600 2,600 3,600 - 0.00% 3,600 Retirement 35,476 35,652 44,359 51,201 51,201 51,201 56,730 5,530 10.80% 59,567 Medical lnsurance 59,351 62,867 65,577 82,722 87,627 87,627 116,528 33,806 40.87% 128,180 Dental Insurance 3,641 3,835 3,923 4,876 4,876 3,962 4,835 (41) -0.85% 5,318 Vision Insurance 563 561 553 745 745 745 1,051 306 41.15% 1,156 Life Insurance & Other 3,752 3,787 3,573 2,400 2,400 3,600 4,000 1,600 66.67% 4,400 Social Security Taxes 23,871 23,532 24,535 26,891 26,891 26,400 28,423 1,532 5.70% 29,844 Medicare Taxes 5,583 5,503 5,938 6,289 6,289 5,571 6,647 358 5.70% 6,980 Unemployment Taxes 974 1,671 143 1,260 1,260 65 1,260 - 0.00% 1,323 Workman's Compensation 8,846 12,500 10,909 11,249 11,249 13,313 11,899 649 5.77% 12,493 Pre-employment Physicals/Testing 235 - 55 400 400 420 400 - 0.00% 400 Employee Relations 87 103 182 300 300 468 300 - 0.00% 300 Engineering- - - - - - - - 0.00% - Maintenance & Repairs 60,089 80,718 357,812 229,800 204,800 204,800 201,500 (28,300) -12.32% 206,000 Generator Maintenance & Repairs 847 889 952 2,000 2,000 876 2,000 - 0.00% 2,000 Vehicle Maintenance 6,003 7,879 9,738 5,000 12,066 12,066 5,000 - 0.00% 5,150 Maintenance - Heavy Equipment 1,828 1,114 237 1,000 1,000 2,516 1,000 - 0.00% 1,030 Cleaning Services 1,050 1,198 1,935 2,500 2,500 2,500 2,500 - 0.00% 2,500 Lab Analysis - MUD 4,561 3,641 5,285 7,500 7,500 4,500 7,500 - 0.00% 7,500 Lab Analysis - PID 2,216 2,047 1,583 2,000 2,000 1,500 2,000 - 0.00% 2,000 Communications/Mobiles 5,334 5,551 6,865 7,500 7,500 6,600 7,500 - 0.00% 7,500 Electricity 131,998 123,528 138,327 228,250 194,810 194,810 183,143 (45,107) -19.76% 192,301 Publications/Books/Subscripts 850 1,366 875 1,000 1,000 1,000 1,000 - 0.00% 1,000 Dues & Memberships 105 - 125 - - - - - 0.00% - Schools&Training 2,920 1,986 2,649 3,630 3,630 2,400 2,630 (1,000) -27.55% 2,630 Safety Program - 105 - - - - - - 0.00% - Travel & per diem- - 59 938 938 100 578 (360) -38.40% 578 Rent/Lease Equipment - - - - - - - - 0.00% - TCEQ Fees & Permits - MUD 25,706 34,779 21,486 30,000 30,000 30,000 29,500 (500) -1.67% 29,500 TCEQ Fees & Permits - PID - - 437 - 214 214 500 500 0.00% 500 Wholesale Water 1,865,024 1,893,513 2,672,206 2,640,131 2,640,131 2,640,131 2,655,497 15,366 0.58% 2,788,272 Miscellaneous Expenses - - - - - - - - 0.00% - Property Maintenance 1,392 245 - -- - - - 0.00% - Lawn Services 6,000 8,700 6,315 12,500 12,500 12,500 12,500 - 0.00% 12,500 Interfund Transfer Out - Revenue l&S 527,381 565,819 569,455 567,782 567,782 567,783 565,797 (1,986) -0.35% 565,797 Interfund Transfer Out - Bond Reserve 36,800 - - - - - - - 0.00% - Interfund Transfer Out - Bank Reserve - - - - - - - - 0.00% - Furniture/Equipment < $5000 562 382 1,923 2,500 2,500 1,355 - (2,500) -100.00% - Fuel & Lube 10,066 14,940 21,815 15,000 15,000 17,200 23,575 8,575 57.17% 24,282 Uniforms 3,425 2,966 2,474 4,355 4,355 2,900 4,355 - 0.00% 4,355 Chemicals 21,491 25,231 30,633 25,000 45,500 45,500 58,200 33,200 132.80% 59,946 Small Tools - 640 - - - - - - 0.00% - Safety Equipment - - - - - - - - 0.00% - Meter Expense 61,774 9,287 - 20,000 6,420 6,420 20,000 - 0.00% 20,000 GENERAL FUND Description FY 2020 Actual FY 2021 ._Actual FY 2022 Actual FY 2023 Adopted FY 2023 Amended FY 2023 Projected Budget vs Budget Net Budget % Change FY 2025 Proposed Meter Change Out Program 36,900 86,625 66,372 87,000 87,000 87,000 124,500 37,500 43.10% 128,235 Capital Outlays 451,480 689,134 950,880 1,752,000 2,300,000 2,300,000 4,200,000 2,448,000 139.73% 1,765,000 Short Term Debt - Principal 30,512 30,962 31,418 31,882 31,882 31,882 - (31,882) -100.00% - ShortTermDebt- Interest 3,230 2,314 1,404 470 470 470 - (470) -100.00% - Gasb34 Reserves 475,899 697,986 75,000 162,639 162,639 162,639 378,659 216,020 132.82% 378,659 Water Tank Inspection Contract 102,077 107,607 112,364 113,500 113,500 110,864 - (113,500) -100.00% - Bond Related Expenses 1,220 - - - - - - - 0.00% - Subtotal Water Expenses 4,410,770 4,935,767 5,653,457 6,577,931 7,086,596 7,072,720 9,179,933 2,602,002 39.56% 6,937,514 Wastewater Expenses Salaries & Wages 425,068 458,805 382,301 309,655 290,179 290,179 290,305 (19,350) -6.25% 304,820 Overtime 22,679 32,324 31,627 33,000 15,586 15,586 20,000 (13,000) -39.39% 20,000 Longevity 6,873 7,420 7,955 4,035 4,035 4,035 2,368 (1,668) -41.33% 2,486 Certification 7,575 7,800 5,900 6,300 6,300 4,200 5,100 (1,200) -19.05% 5,100 Retirement 42,091 46,910 47,229 41,671 41,671 41,671 40,934 (737) -1.77% 42,981 Medical lnsurance 84,736 91,201 71,491 96,579 63,861 63,861 93,222 (3,357) -3.48% 102,544 Dental Insurance 4,900 5,036 3,957 5,427 5,427 3,961 3,385 (2,041) -37.62% 3,724 Vision Insurance 784 781 566 793 793 740 819 26 3.30% 901 Life Insurance & Other 4,563 4,810 3,400 2,400 2,400 2,700 3,000 600 25.00% 3,300 Social Security Taxes 27,142 30,252 26,257 21,885 21,885 19,343 20,508 (1,377) -6.29% 21,533 Medicare Taxes 6,348 7,075 6,141 5,118 5,118 4,623 4,796 (322) -6.29% 5,036 Unemployment Taxes 1,100 1,960 70 1,260 1,260 44 1,008 (252) -20.00% 1,008 Workman's Compensation 12,653 16,302 13,414 8,987 8,987 10,635 8,404 (584) -6.50% 8,824 Pre-employment Physicals/Testing 357 - 292 400 400 400 400 - 0.00% 400 Employee Relations 105 135 445 300 300 1,168 300 - 0.00% 300 Engineering 23,200 - - -- - - - 0.00% - Independent Labor 3,000 - - - - - - - 0.00% - Maintenance & Repairs - WWTP 87,020 99,418 193,823 134,600 211,000 211,000 137,000 2,400 1.78% 110,000 Maintenance & Repairs - Collections 27,259 187,743 286,403 281,000 333,600 333,600 270,000 (11,000) -3.91% 270,000 Generator Maintenance & Repairs 3,198 4,055 4,604 9,000 2,836 2,836 11,000 2,000 22.22% 11,000 Vehicle Maintenance - WWTP 1,203 2,831 524 4,600 4,600 1,000 4,600 - 0.00% 4,600 Vehicle Maintenance - Collections 2,173 7,905 18,947 13,000 13,000 10,000 13,000 - 0.00% 13,000 Maintenance -Heavy Equipment 1,471 1,390 1,325 3,000 3,000 3,000 3,000 - 0.00% 3,000 Cleaning Services 1,050 1,197 1,935 2,000 2,000 2,000 2,000 - 0.00% 2,000 Dumpster Services 91,387 92,408 91,740 100,000 95,000 95,000 100,000 - 0.00% 103,000 Lab Analysis 37,205 40,690 44,380 40,000 45,000 45,000 55,000 15,000 37.50% 56,650 Communications/Mobiles 5,716 5,997 6,383 7,500 7,500 5,500 7,500 - 0.00% 7,500 Electricity 132,686 146,660 172,359 276,318 243,973 243,973 242,978 (33,340) -12.07% 255,127 Publications/Books/Subscripts- - - - - - - - 0.00% - Dues & Memberships 216 - - -- - - - 0.00% - Schools &Training 4,349 2,827 1,700 3,630 3,630 2,500 2,119 (1,511) -41.63% 2,119 Safety Program 109 - - -- - - - 0.00% - Travel & per diem 411 - - 1,038 1,038 - 528 (510) -49.16% 528 Rent/Lease Equipment - 575 - - - - - - 0.00% - Advertising- - - - - - - - 0.00% - TCEQ Fees & Permits 10,088 28,791 20,314 12,000 12,000 9,888 12,000 - 0.00% 12,000 Miscellaneous Expenses - - - - - - - - 0.00% - Property Maintenance 2,618 - - -- - - - 0.00% - Lawn Services 6,525 10,430 6,067 16,000 8,500 8,500 16,000 - 0.00% 16,000 Interfund Transfer Out - Tax l&S 114,563 114,681 115,924 116,245 116,245 116,245 115,886 (359) -0.31% 115,886 Interfund Transfer Out - Revenue I&S 673,867 688,005 690,085 691,931 691,931 691,932 698,543 6,612 0.96% 698,543 Interfund Transfer Out - Bond Reserve 46,000 - - - - - - - 0.00% - Interfund Transfer Out - Bank Reserve - 38,802 - - - - -- 0.00% - Furniture/Equipment < $5000 1,055 228 - 500 500 500 - (500) -100.00% - Fuel & Lube 8,220 13,408 13,686 12,500 12,500 10,000 13,000 500 4.00% 13,000 Uniforms 3,732 4,168 3,299 4,415 4,415 3,000 3,520 (895) -20.27% 3,520 Chemicals - WWTP 23,055 23,442 25,284 32,500 22,500 22,500 32,500 - 0.00% 33,475 Chemicals - Collections 10,449 4,895 5,776 10,000 10,000 6,003 10,000 - 0.00% 10,300 Small Tools - 343 - - - - -- 0.00% - Safety Equipment 1,167 307 - - - - - - 0.00% - Lab Supplies 26,446 28,349 31,073 33,000 33,000 29,000 33,000 - 0.00% 33,000 Capital Outlays 324,270 222,147 381,214 895,000 1,578,000 1,578,000 1,050,000 155,000 17.32% 570,000 Short Term Debt -Principal 79,142 81,295 83,484 85,766 85,766 85,766 22,398 (63,368) -73.88% Short Term Debt -Interest 11,269 8,496 5,707 2,801 2,801 2,835 442 (2,359) -84.21% - Gasb34 Reserves 530,899 752,986 130,000 165,777 165,777 165,777 155,762 (10,015) -6.04% 155,762 Capital Lease Issuance Cost - - - - - - - - 0.00% - Subtotal Wastewater Expenses 2,941,991 3,325,280 2,937,081 3,491,931 4,178,315 4,148,502 3,506,324 14,393 0.41% 3,022,965 Board of Directors Expenses Salaries & Wages - - - - - - - - 0.00% - SocialSecurityTaxes - - - - - - - - 0.00% - Medicare Taxes - - - - - - - - 0.00% - UnemploymentTaxes- - - - - - - - 0.00% - Workman's Compensation 24 9 10 15 15 15 15 - 0.00% 15 Publications/Books/Subscriptions - - - - - - - - 0.00% - Dues & Memberships 675 1,195 700 750 750 750 750 - 0.00% 750 Meetings 1,034 1,418 1,416 1,500 1,500 1,500 1,500 - 0.00% 1,500 Schools &Training - - 625 4,000 535 535 4,000 - 0.00% 4,000 GENERAL FUND Desai • FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted FY 2023 Amended - FY 2023 Projected FY 2024 Adopted Budget vs Budget Net Budget % Change FY 2025 Proposed Travel & per diem - - - 5,000 - - 5,000 - 0.00% 5,000 Miscellaneous Expenses - 58 - 500 - - 500 - 0.00% 500 Subtotal Board of Directors Expenses 1,733 2,680 2,751 11,765 2,800 2,800 11,765 - 0.00% 11,765 Administration Expenses Salaries & Wages 453,839 516,401 534,749 620,938 620,938 620,938 663,185 42,247 6.80% 696,345 Overtime 50 97 549 2,000 2,000 1,500 2,000 - 0.00% 2,000 Longevity 2,208 2,668 2,973 2,423 2,423 2,423 2,533 110 4.54% 2,659 Retirement 41,774 48,136 59,277 73,825 73,825 73,825 82,631 8,806 11.93% 86,763 Medical Insurance 80,099 75,830 69,806 116,290 79,352 79,352 108,759 (7,531) -6.48% 119,635 Dental lnsurance 4,436 4,204 3,762 6,051 6,051 3,081 3,817 (2,234) -36.92% 4,198 Vision Insurance 667 616 527 899 899 638 886 (13) -1.45% 975 Life lnsurance & Other 4,307 4,829 4,507 2,400 2,400 5,100 4,800 2,400 100.00% 5,280 Social Security Taxes 26,325 30,429 31,981 38,772 38,772 37,404 41,399 2,626 6.77% 43,468 Medicare Taxes 6,157 7,116 7,479 9,068 9,068 8,813 9,682 614 6.77% 10,166 Unemployment Taxes 1,008 1,512 54 1,512 1,512 59 1,512- 0.00% 1,512 Workman's Compensation 1,178 1,542 1,511 1,496 1,496 1,291 1,597 101 6.78% 1,677 Pre-employment Physicals/Testing - - 516 500 500 500 500 - 0.00% 500 Employee Relations 3,140 3,422 3,471 4,000 4,000 4,000 4,000 - 0.00% 4,000 Engineering - - - - - - - - 0.00% - Software & Support 124,037 96,552 107,761 131,700 131,700 131,700 130,311 (1,389) -1.05% 134,220 Independent Labor 90,481 16,573 29,113 15,000 8,000 8,000 - (15,000) -100.00% - Maintenance & Repairs 18,794 94,832 66,308 40,000 20,000 20,000 23,000 (17,000) -42.50% 13,000 Generator Maintenance & Repairs 1,169 670 717 3,000 3,000 1,000 1,000 (2,000) -66.67% 1,000 Building Maintenance & Supplies - - - - - - - - 0.00% Cleaning Services 17,143 17,315 12,266 12,000 12,000 12,356 13,825 1,825 15.21% 13,825 Professional Outside Services 57,100 103,120 75,415 75,040 75,040 75,040 100,000 24,960 33.26% 103,000 Utility Billing Contract 7,132 7,188 7,346 9,000 9,000 9,000 9,000 - 0.00% 9,000 Telephone 24,055 7,365 5,909 6,000 6,000 6,000 6,000 - 0.00% 6,000 Communications/Mobiles 2,784 2,700 2,700 3,000 3,000 300 3,000 - 0.00% 3,000 Electricity 6,315 13,873 15,200 24,369 16,957 16,957 17,685 (6,685) -27.43% 17,685 Water 1,945 3,828 4,107 5,000 5,000 5,000 5,000 - 0.00% 5,000 Postage 20,402 21,713 22,408 30,000 24,000 24,000 30,000 - 0.00% 30,000 Bank Service Charges & Fees 73,964 90,222 92,832 95,000 141,000 141,000 140,000 45,000 47.37% 140,000 Bad Debt Expense 16,874 10,998 9,562 1,500 13,000 13,000 13,000 11,500 766.67% 13,000 Insurance 79,988 80,698 86,013 88,200 97,400 97,400 116,158 27,958 31.70% 121,966 Publications/Books/Subscripts 125 183 -- - - - - 0.00% - Dues & Memberships 4,607 6,017 6,522 6,500 6,500 6,900 6,800 300 4.62% 6,800 Meetings 149 289 -- - - - - 0.00% - Public Education 1,875 3,063 3,867 40,000 30,000 30,000 - (40,000) -100.00% - Schools &Training 3,018 3,639 913 3,250 3,250 1,000 3,900 650 20.00% 3,900 Travel & per diem 1,205 304 509 1,588 1,588 - 1,228 (360) -22.68% 1,228 Physicals/Testing - - - - - - - - 0.00% - Elections 138 9,330 7,143 - - - 10,000 10,000 0.00% - Advertising 6,112 625 10,412 - - - - - 0.00% - Security 264 312 - - - - - - 0.00% - Miscellaneous Expenses 6,096 392 112 - - 88 - - 0.00% - General Manager Contingency- - - - - - - - 0.00% - Lawn Services- - 4,227 5,000 5,000 5,000 5,000 - 0.00% 5,000 Furniture/Equipment < $5000 2,027 4,012 3,284 10,000 13,053 13,053 3,000 (7,000) -70.00% 3,000 Uniforms- - 443 530 530 530 530 - 0.00% 530 Hardware IT 24,611 20,339 12,206 8,400 13,214 13,587 8,200 (200) -2.38% 8,200 Office Supplies 5,383 4,682 4,217 6,000 6,000 5,000 5,000 (1,000) -16.67% 5,000 Printer Supplies & Maintenance - - - - - - - 0.00% - Maintenance Supplies 4,596 4,553 6,190 4,000 4,000 5,000 5,000 1,000 25.00% 5,000 Printing - - - - - - - - 0.00% Capital Outlays 156,107 123,356 113,654 - 56,346 74,953 -- 0.00% Copier Lease 3,027 3,168 3,242 4,000 4,000 4,000 4,000 - 0.00% 4,000 Gasb34 Reserves- - - 26,736 26,736 26,736 24,903 (1,833) -6.86% 24,903 Subtotal Administration Expenses 1,386,708 1,448,713 1,435,755 1,534,986 1,578,548 1,585,523 1,612,840 77,854 5.07% 1,657,434 Non Departmental Expenses Legal 109,011 42,018 55,890 65,000 30,000 30,000 65,000- 0.00% 65,000 Auditing 31,908 21,000 25,375 33,800 27,000 27,000 30,000 (3,800) -11.24% 30,000 Appraisal 11,909 11,122 14,582 12,940 12,940 12,940 13,071 131 1.01% 13,463 Tax Admin Fees 3,756 3,821_ 3,874 5,000 5,000 4,046 5,000 - 0.00% 5,150 Subtotal Non Departmental Expenses 156,584 77,961 99,721 116,740 74,940 73,986 113,071 (3,669) -3.14% 113,613 Total General Fund Revenues $ 9,661,678 $ 9,772,566 $ 11,421,312 $ 11,733,354 $ 12,442,977 $ 12,438,917 $ 14,423,933 $ 2,690,579 22.93% $ 11,743,292 Total General Fund Expenses $ 8,897,786 $ 9,790,401 $ 10,128,766 $ 11,733,354 $ 12,921,199 $ 12,883,531 $ 14,423,933 $ 2,690,579 22.93% $ 11,743,292 Net Budget Surplus (Deficit) $ 763,892 $ (17,835) $ 1,292,546 $ 0 $ (478,222) $ (444,613) $ 0 $ 0 $ 0 TAX DEBT PAYMENTS LONG TERM TAX DEBT REVENUE DEBT PAYMENTS LONG TERM REVENUE DEBT MUD/PID Reimburse Par Amount Principal FY 2024 Interest 3/01 Interest 9/01 Subtotal Interest Paying Agent Fee Total Maturity Date First Callable Date Project/Reason Series 2012 (Tax) MUD $2,355,000 50 50 50 50 50 $0 9/1/2023 9/1/2020 Refund MUD #2 Unlimited Tax Bonds Series 2002 and costs of issuance Series 2013 (Tax) MUD 51,905,000 $0 $0 $0 $0 $0 $0 9/1/2023 9/1/2023 Refund MUD #2 Unlimited Tax Bonds Series 2003 & Unlimited Tax Refunding Bonds Series 2005 and costs of issuance Series 2020 (Tax) MUD 51,220,000 $120,000 $6,338 $6,338 $12,675 $750 5133,425 9/1/2031 9/1/2031 Refund MUD #1 Unlimited Tax Bonds Series 2010 and costs of issuance of the Bonds, Trophy Club Fire Station SUBTOTAL MUD ONLY TAX BONDS: 55,480,000 5120,000 $6,338 56,338 $12,675 $750 $133,425 Series 2014 (Tax) MUD/PID $5,765,000 $290,000 556,156 556,156 $112,313 5400 5402,713 9/1/2034 9/1/2024 Tax Bonds for WWTP Expansion SUBTOTAL MUD/PID TAX BONDS: $5,765,000 5290,000 556,156 556,156 5112,313 5400 5402,713 TOTAL ALL TAX BONDS: $11,245,000 $410,000 $62,494 $62,494 $124,988 $1,150 $536,138 REVENUE DEBT PAYMENTS LONG TERM REVENUE DEBT CAPITAL LEASE PAYMENTS SHORT TERM REVENUE DEBT Revenue Rates Par Amount Principal FY 2024 Interest 3/01 Interest 9/01 Subtotal Interest Paying Agent Fee Total Maturity Date First Callable Date Project/Reason Series 2015 (Revenue) WWTP 59,230,000 $435,000 587,919 587,919 $175,838 $400 5611,238 9/1/2035 9/1/2025 Revenue Bonds for WWTP Expansion Series 2016 (Revenue) SWIFT $4,635,000 $220,000 $26,557 $26,557 553,115 $400 5273,515 9/1/2036 9/1/2027 Revenue Bonds for Fort Worth Line NSII Series 2019 (Revenue) WT & WW $7,080,000 5170,000 5104,594 5104,594 $209,188 5400 $379,588 9/1/2049 9/1/2028 Revenue Bonds for 16in Water Line (77%) Overrun for WWTP Expansion (23%) TOTAL ALL REVENUE BONDS: $20,945,000 $825,000 $219,070 $219,070 $438,140 $1,200 $1,264,340 CAPITAL LEASE PAYMENTS SHORT TERM REVENUE DEBT Revenue Rates Par Amount Principal FY 2023 Interest 2/01 Interest 8/01 Subtotal Interest Paying Agent Fee Total Payoff Date Reason Department Vaccon Truck (Water usage 43%) 5154,843 $0 $0 $0 $0 $ - $0 2/1/2023 Replacement Water Vaccon Truck (WW usage 57%) $205,257 $0 $0 $0 $0 $ - $0 2/1/2023 Replacement Wastewater Camera Van 5205,504 $22,398 $442 $0 $442 $ - $22,841 2/1/2024 Replacement Wastewater Total: $565,604 $22,398 $442 $0 $442 $ - $22,841 $2,000,000.00 - $1,800,000.00 - $1,600,000.00 - $1,400,000.00 - $1,200,000.00 - $1,000,000.00 - $800,000.00 - $600,000.00 - $400,000.00 - $200,000.00 - M Annual Long -Term Debt Payments 1 URI 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) 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2049 $25,000.00 $20,000.00 $15,000.00 $10,000.00 $5,000.00 $- Annual Capital Lease Payments 2024 CAMERA VAN LEASE 2019 ($210,000) CAPITAL OUTLAYS (5 Year ) Department FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 Water Water Line Replacement $ 2,000,000 $ 1,700,000 $ 1,751,000 $ 1,803,530 $ 1,857,636 Pump Station Improvements $ 2,200,000 $ - $ - $ - $ - Fleet Replacement $ - $ 65,000 $ - $ 50,000 $ - MBR CIP Tanks $ - $ - $ - $ - $ Water Grand Totals $ 4,200,000 $ 1,765,000 $ 1,751,000 $ 1,853,530 $ 1,857,636 Wastewater Wastewater Line Improvements $ 400,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 Lift Station Improvements $ 225,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 Return Pump $ - $ - $ 40,000 $ 40,000 $ 40,000 MBR CIP Tanks $ 375,000 $ - $ - $ - $ - Crane Pulley $ - $ 35,000 $ - $ - $ - Concrete Repairs $ - $ 35,000 $ - $ - $ - Fleet Replacement $ 50,000 $ 250,000 $ - $ - $ - $ - $ - $ - $ - $ Wastewater Grand Totals $ 1,050,000 $ 570,000 $ 290,000 $ 290,000 $ 290,000 Administration $ - $ - $ - $ - $ $ - $ - $ - $ - $ - $ - $ - $ - $ - $ Admin Grand Totals $ - $ - $ - $ - $ - ANNUAL WATER CONSUMPTION AND REVENUE BY YEAR 1,200,000 1,000,000 800,000 600,000 400,000 200,000 Annual Consumption in (Thousand) Gallons 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 $- Annual Water Revenue 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 AVERAGE MONTHLY METERS AND AVERAGE GALLONS BY YEAR 5,000 4,900 4,800 4,700 4,600 4,500 4,400 4,300 4,200 4,100 4,000 3,900 Average Monthly Meters 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 24,000 22,000 20,000 18,000 16,000 14,000 12,000 10,000 8,000 6,000 4,000 2,000 Average Monthly Gallons per Meter 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 ANNUAL WASTEWATER FLOW AND REVENUE BY YEAR 500,000 400,000 300,000 200,000 100,000 0 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 Annual WWTP Flow in (Thousand) Gallons $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 $- Annual Wastewater Revenue 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 RESOLUTION NO. 2023-0920A A RESOLUTION APPROVING THE 2024 FISCAL YEAR BUDGET OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 WHEREAS, Trophy Club Municipal Utility District No. 1 (the "District") is a conservation and reclamation district of the State of Texas created under Article XVI, Sec. 59 of the Texas Constitution, and the District operates under Chapters 49 and 54 of the Texas Water Code, as amended; WHEREAS, Section 49.057(b) of the Texas Water Code requires the board of directors of a water district to adopt an annual budget; WHEREAS, Title 30, Section 293.97(b), Texas Administrative Code, provides that an operating budget shall be passed and approved by a resolution of the governing board of a water district and shall be made a part of the governing board minutes; and WHEREAS, the Board of Directors of the District desires to adopt a budget for the 2022 fiscal year in an open, public meeting, proper notice of which has been given as required by law. NOW THEREFORE BE IT RESOLVED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1: Section 1. That the facts and recitations found in the preamble of this Resolution are hereby found and declared to be true and correct and are incorporated by reference herein and expressly made a part hereof, as if copied verbatim. Section 2. That the annual budget of revenues and expenditures necessary for conducting the operations and affairs of the District for Fiscal Year 2024, attached hereto, and incorporated herein as Exhibit A, is hereby approved, and adopted. Said budget document shall be on file for public inspection in the office of the District. Section 3. The District's audited financial statements, bond transcripts; and engineer's reports required by Texas Water Code § 49.106, are hereby incorporated to the District's budget as an appendix as required by Texas Water Code § 49.057(b). Section 4. That the District's expenditures during the fiscal year shall be made in accordance with the approved budget and any amendments thereto approved by the Board of Directors. Section 5. A copy of this Resolution and the budget approved hereby shall be attached to the minutes of the Board's September 20, 2023, meeting. Section 6. passage. That this Resolution shall become effective immediately upon its RESOLVED, PASSED AND APPROVED by the Board of Directors of Trophy Club Municipal Utility District No. 1, this the 20th day of September 2023. Kevin R. Carr, President Board of Directors Doug Harper, Secretary/ asurer Board of Directors L urie Slaght, District Sec: e ry CERTIFICATE OF RESOLUTION 2023-0920A THE STATE OF TEXAS COUNTIES OF DENTON AND TARRANT I, the undersigned member of the Board of Directors of Trophy Club Municipal Utility District No. 1 of Denton and Tarrant Counties, Texas (the "District"), hereby certify as follows: 1. That I am the duly qualified Secretary of the Board of Directors of the District, and that, as such, I have custody of the minutes and records of the District. 2. That the Board of Directors of the District convened in Open Session at a Regular Meeting on September 20, 2023, at the regular meeting place thereof, and the roll was called of the duly constituted officers and members of the Board of Directors, to wit: Kevin R. Carr President Ben Brewster Vice President Doug Harper Secretary/Treasurer William C. Rose Director Tracey Hunter Director All members of the Board were present exceptTrrp,L1 , thus constituting a quorum. Whereupon, among other business, the following was transacted at such meeting: A RESOLUTION APPROVING THE 2024 FISCAL YEAR BUDGET OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 and duly introduced for the consideration of the Board of Directors of the District. It was then duly moved and seconded that such Resolution be adopted and, after due discussion, such motion, carrying with it the adoption of such Resolution, prevailed, and carried by the following vote: AYES: 1-1.. NAYS: _ ABSTENSIONS: I 3. That a true, full and correct copy of such Resolution adopted at such meeting is attached to and follows this certificate; that such resolution has been duly recorded in the minutes of the Board of Directors for such meeting; that the persons named in the above and foregoing Paragraph 2 were the duly chosen, qualified and acting officers and members of the Board of Directors as indicated therein, that each was duly and sufficiently notified officially and personally, in advance, of the time, place and purpose of such meeting, and that such Resolution would be introduced and considered for adoption at such meeting, and that each consented, in advance, to the holding of such meeting for such purpose; that the canvassing of the officers and members of the Board of Directors present at and absent from such meeting and of the votes of each on such motion, as set forth in the above and foregoing Paragraph 2, is true and correct; and that sufficient and timely notice of the hour, date, place and subject of such meeting was given and posted as required by Chapter 551, Texas Government Code, as amended. SIGNED AND SEALED the 20"' day of September 2023. Doug Treasurer Board of Directors Harper, Secretar L.:urie laght, District Seary EXHIBIT "A" (Approved FY 2024 Budget)