The URL can be used to link to this page

Home My WebLink About2024-0117 January 17 2024 Regular Meeting Agenda Packet.January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT BOARD OF DIRECTORS REGULAR MEETING TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 100 MUNICIPAL DRIVE TROPHY CLUB, TEXAS 76262 Wednesday, January 17, 2024 6:30 P.M. Svore Municipal Boardroom REGULAR MEETING AGENDA VIA VIDEOCONFERENCE - THE PRESIDING OFFICER AND A QUORUM OF THE BOARD OF DIRECTORS WILL BE PHYSICALLY PRESENT AT, AND MEMBERS OF THE PUBLIC MAY ATTEND THE MEETING AT THE LOCATION SPECIFIED ABOVE. PURSUANT TO TEXAS GOVERNMENT CODE SECTION 551.127, ON A REGULAR, NON- EMERGENCY BASIS, UP TO TWO DIRECTORS MAY ATTEND AND PARTICIPATE IN THE MEETING REMOTELY BY VIDEO CONFERENCE. SHOULD THAT OCCUR, A QUORUM OF THE MEMBERS WILL BE PHYSICALLY PRESENT AT THE LOCATION NOTED ABOVE ON THIS AGENDA. CALL TO ORDER AND ANNOUNCE A QUORUM CITIZEN COMMENTS This is an opportunity for citizens to address the Board on any matter whether or not it is posted on the agenda. The Board is not permitted to take action on or discuss any comments made to the Board at this time concerning an item not listed on the agenda. The Board will hear comments on specific agenda items prior to the Board addressing those items. You may speak up to four (4) minutes or the time limit determined by the President or presiding officer. To speak during this item, you must complete the Speaker's form that includes the topic(s) of your statement. Citizen Comments should be limited to matters over which the Board has authority. REPORTS & UPDATES 1. Staff Reports a. Capital Improvement Projects b. Operations Reports (Nov/Dec) c. Finance Reports (Nov/Dec) • Quarterly Tax Collections 1st Quarter • Quarterly Investment Report 1" Quarter Attachment: Staff Reports CONSENT AGENDA All matters listed as Consent Agenda are considered to be routine by the Board of Directors and will be enacted by one motion. There will not be a separate discussion of these items. If discussion is desired, that item will be removed from the consent agenda and will be considered separately. 1 of 131 January 17, 2024 Regular Meeting Agenda Packet 2. Consider and act to approve the Consent Agenda. a. December 13, 2023, Regular Meeting Minutes Attachment: Meeting Minutes REGULAR SESSION 3. Consider and take appropriate action to approve the Fiscal Year 2023 Annual Financial Audit Report prepared by Rod Abbott PLLC. Attachments: Audit Letter Audited Financials 4. Consider and act regarding approval of Contract No. 2024011701 with Insituform Technologies, LLC for wastewater collection system repairs. Attachment: Staff Report 5. Consider and take appropriate action regarding District bank signatories including: a. Approve Resolution No. 2024-0117A designating authorized signers on Prosperity Bank accounts. b. Approve Resolution No. 2024-0117B designating depository institutions, designating authorized signatories for the disbursement of District funds, providing for electronic transfers of District funds, and containing other matters relating thereto. Attachments: Resolution No. 2024-0117A Resolution No. 2024-0117B 6. Consider and take appropriate action to approve matters related to May 4, 2024, General Election: a. Adopt Order No. 2024-0117A Calling the May 4, 2024, General Election. b. Approve Notice of Appointment of Agent. c. Authorize General Manager to sign and execute all necessary documents relating to the election. d. Authorize Other necessary actions as may be necessary or convenient for conducting the May 4, 2024, General Election Attachments: Order No. 2024-0117A Notice of Appointment of Agent 6. Items for future agendas: 7. Next Regular Meeting date — February 21, 2024 Attachment: Meeting Calendar 2 of 131 January 17, 2024 Regular Meeting Agenda Packet THE BOARD OF DIRECTORS RESERVES THE RIGHT TO ADJOURN INTO EXECUTIVE SESSION AT ANY TIME DURING THE COURSE OF THIS MEETING TO DISCUSS ANY MATTERS LISTED ON THE AGENDA, AS AUTHORIZED BY TEXAS GOVERNMENT CODE SECTIONS 551.071 (CONSULTATION WITH ATTORNEY), 551.072 (DELIBERATIONS ABOUT REAL PROPERTY), 551.073 (DELIBERATIONS ABOUT GIFTS AND DONATIONS), 551.074 (PERSONNEL MATTERS), 551.076 (DELIBERATIONS ABOUT SECURITY DEVICES), AND/OR 418.183 (HOMELAND SECURITY). NO FINAL ACTION, DECISION OR VOTE WILL BE TAKEN ON ANY SUBJECT OR MATTER IN EXECUTIVE SESSION. THIS NOTICE MODIFIES THE DISTRICT'S PRIOR PRACTICE OF SPECIFICALLY IDENTIFYING ALL AGENDA ITEMS TO BE DISCUSSED IN EXECUTIVE SESSION. ADJOURN 3 of 131 4 TROPHY CLUB l MUNICIPAL UTILITY DISTRICT January 17, 2024 Regular Meeting Agenda Packet Capital Improvement Projects • Pump Station Improvement Project — Remaining submittals have been finalized, and the header piping and valves have been delivered to the site along with some of the electrical control panels. Preassembly of piping will begin in late January and go into early February in preparation for the major system shutdown to install the new cross, valves, and discharge piping. This project is tentatively scheduled to be completed in May 2024 but will likely be delayed further due to the long lead time for VFDs. • Lift Station Generators — Installation of all generators is complete, and they are operable. The contractor will be working to complete punch list items, finalize start-up protocols, and work towards finalizing documentation and as -built drawings. The anticipated final completion date is April 2024. • FY 2024 Water Line Project — Preliminary 90% design plans have been received and under review for the replacement of approximately 7,150 linear feet of water lines along and adjacent to Inverness Drive, Forest Hill Drive, Sonora Drive, Pagosa Court, Palo Duro Court, and Mesa Verde Court. • WWTP CIP Improvements — Preliminary 50% design plans have been received and under review for the installation of permanent Clean in Place (CIP) Systems to perform cleaning of the Membrane Bioreactor (MBR) permeate membranes at the Wastewater Treatment Plant (WWTP) including associated tanks, pumps, electrical, and piping; installation of an exhaust fan on the south side of MBRs 1 and 2; and replacement of the backflow preventer vault. • FY 2024 Wastewater Improvements — Proposed repairs are submitted for approval to complete recommended rehabilitation and repairs resulting from the annual wastewater system analysis performed in FY 2023. • FY 2024 Lift Station Improvements — Design is under way of standard details, specifications, and updating of plan sheets for the removal and installation of chain link fence and driveway improvements at Lift Station No. 2; removal and installation of aluminum hatches on check valve vaults at Lift Stations No. 2, 3, and 6; removal and installation of new aluminum hatch on the wet well at Lift Station No. 4; installation of manual valve vault bypass line with quick connect at Lift Stations No. 2, 5, and 6; and installation of davit cranes at Lift Stations No. 2, 3, 4, 5, 6, 7, 8, 9. • Southlake emergency connection — We are awaiting Southlake to complete a Water Master Plan Update, which is expected to be completed in May 2024. 4 of 131 January 17, 2024 Regular Meeting Agenda Packet Water Billed - -2024 180,000 160,000 140,000 120,000 100,000 80,000 60,000 --- _ 40,000 i-� 20,000 - 0 FY October November December January February March April May June July August September Total Year 2015 90,994 58,986 49,607 36,162 38,776 30,566 46,543 39,576 60,731 100,622 139,441 123,886 815,890 2016 108,951 41,936 39,028 39,622 44,551 49,498 55,181 50,827 65,390 115,687 119,611 98,945 829,227 2017 74,785 68,638 38,580 33,028 38,380 60,841 56,683 86,794 98,864 95,355 104,303 99,541 855,792 2018 83,228 69,099 48,144 34,592 40,658 43,411 60,079 89,802 118,899 126,588 125,531 73,735 913,766 2019 47,193 41,933 36,244 34,604 33,740 40,421 55,970 42,773 70,747 96,174 131,472 114,784 746,055 2020 102,150 40,988 43,946 36,418 31,000 34,047 53,755 67,030 96,195 123,309 118,522 83,570 830,930 2021 98,232 57,380 40,841 42,725 40,786 41,078 67,776 50,736 64,195 100,853 97,864 112,674 815,140 2022 78,390 54,635 48,488 49,322 40,021 44,588 72,448 85,474 119,711 141,177 143,845 108,377 986,476 2023 101,683 49,007 52,466 49,082 34,501 46,119 70,083 79,654 108,707 134,083 169,549 154,971 1,049,905 2024 112,006 61,555 173,561 Water Pumped 180,000 -2020 -2021 -2022 -2023 -2024 160,000 140,000 120,000 100,000 80,000 60,000 40,000 20,000 0 - FY October November December January February March April May June July August September Total Year 2015 106,251 67,825 58,659 45,691 39,675 35,752 56,704 48,637 72,934 117,302 143,413 142,394 935,237 2016 106,731 52,616 43,708 46,945 50,721 55,178 60,434 55,562 68,138 112,533 128,963 104,664 886,193 2017 82,677 77,937 43,792 43,207 43,024 69,549 65,723 94,452 103,867 101,184 114,872 109,769 950,053 2018 91,439 78,282 55,745 40,796 40,750 51,711 67,217 97,980 124,109 155,354 144,015 85,946 1,033,344 2019 60,576 53,119 45,651 45,552 39,014 43,048 61,238 48,787 79,167 102,887 144,299 130,752 854,090 2020 112,971 48,627 49,384 40,726 35,749 38,576 57,714 74,153 106,219 136,306 130,721 89,514 920,660 2021 106,660 66,304 46,962 50,538 47,733 44,191 75,866 56,985 73,907 113,015 109,492 123,206 914,859 2022 91,078 61,928 54,930 52,679 49,094 51,606 81,977 92,915 133,828 152,199 161,534 117,252 1,101,020 2023 114,089 54,777 57,827 57,758 39,309 50,124 77,261 84,019 120,932 145,657 184,972 169,227 1,155,952 2024 122,699 69,114 191,813 5 of 131 January 17, 2024 Regular Meeting Agenda Packet 7 6 C' 5 0 7 4 0 3 3 2 1 0 • Min • Max Avg mil .11 .h Nov -22 Dec -22 Jan -23 Feb -23 Water Production ■ Mar -23 Apr -23 May -23 Jun -23 Jul -23 Nov -22 Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 f May -23 Jun -23 1.401 1.115 1.225 0.878 0.999 0.920 1.730 2.628 2.572 2.716 2.508 2.354 2.516 4.597 5.729 5.950 1.834 1.657 1.759 1.479 1.731 2.780 3.125 4.079 Jul -23 3.277 7.079 5.266 Aug -23 Aug -23 4.622 7.305 6.291 Sep -23 Sep -23 3.391 Oct -23 Oct -23 1.119 7.430 5.458 5.234 3.566 Nov -23 Nov -23 1.026 2.803 2.145 2.150 1.950 1.750 1.550 1.350 3 1.150 0.950 0.750 Wastewater Treated ■III ■1 ■1 ■1 ■t ■I ■t •II Nov -22 Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 May -23 Jun -23 Daily Avg Flow Daily Max Flow -Daily Avg Max Jul -23 Aug -23 Sep -23 Oct -23 Nov -23 20.0 18.0 16.0 14.0 12.0 10.0 8.0 6.0 4.0 2.0 0.0 Carbonaceous Biochemical Oxygen Demand (CBOD) J Nov -22 Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 May -23 Jun -23 CBOD Avg CBOD Max -Daily Avg Max -Daily Max Jul -23 Aug -23 Sep -23 Oct -23 Nov -23 6 of 131 January 17, 2024 Regular Meeting Agenda Packet 40.0 35.0 30.0 25.0 20.0 15.0 10.0 5.0 0.0 Total Suspended Solids (TSS) Nov -22 Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 May -23 Jun -23 TSS Avg i TSS Max Daily Avg Max -Daily Max Jul -23 Aug -23 Sep -23 Oct -23 Nov -23 10.00 9.00 8.00 7.00 6.00 5.00 4.00 3.00 2.00 1.00 0.00 Ammonia Nitrogen (NH3) Nov -22 Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 May -23 Jun -23 Jul -23 Aug -23 Sep -23 Oct -23 Nov -23 NH3 Avg NH3 Max -Daily Avg Max -Daily Max 50.0 40.0 30.0 20.0 10.0 0.0 Nitrate -Nitrogen (NO3) rr r r r rrNI Nov -22 Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 May -23 Jun -23 Jul -23 Aug -23 Sep -23 Oct -23 Nov -23 NO3 Avg NO3 Max -Daily Avg Max -Daily Max 7 of 131 January 17, 2024 Regular Meeting Agenda Packet 8 of 131 Potential of Hydrogen (pH) 9 8.5 8 7.5 7 6.5 6 Nov -22 Dec -22 Jan -23 Feb -23 Mar -23 pH Min Apr -23 May -23 Jun -23 Jul -23 pH Max , pH Avg -Daily Avg Min -Daily Avg Max Aug -23 Sep -23 Oct -23 Nov -23 Dissolved Oxygen (DO) 9.0 8.5 . ■ 8.0 1 7.5 7.0 6.5 6.0 ill J J Nov -22 Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 May -23 Jun -23 Jul -23 Aug -23 Sep -23 Oct -23 Nov -23 DO Min DO Max DO Avg Min -Daily Avg -Daily Avg Max Escherichia coli (E. coli) 400 350 300 250 200 150 100 50 1.0 2.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 6.3 2.0 1.0 1.0 0 Nov -22 Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 May -23 Jun -23 Jul -23 Aug -23 Sep -23 Oct -23 Nov -23 E. Avg E. Max Avg Max Max coli coli -Daily -Daily 8 of 131 January 17, 2024 Regular Meeting Agenda Packet Water Billed - -2024 180,000 160,000 140,000 120,000 100,000 80,000 60,000 --- _ 40,000 -. 20,000 - 0 FY October November December January February March April May June July August September Total Year 2015 90,994 58,986 49,607 36,162 38,776 30,566 46,543 39,576 60,731 100,622 139,441 123,886 815,890 2016 108,951 41,936 39,028 39,622 44,551 49,498 55,181 50,827 65,390 115,687 119,611 98,945 829,227 2017 74,785 68,638 38,580 33,028 38,380 60,841 56,683 86,794 98,864 95,355 104,303 99,541 855,792 2018 83,228 69,099 48,144 34,592 40,658 43,411 60,079 89,802 118,899 126,588 125,531 73,735 913,766 2019 47,193 41,933 36,244 34,604 33,740 40,421 55,970 42,773 70,747 96,174 131,472 114,784 746,055 2020 102,150 40,988 43,946 36,418 31,000 34,047 53,755 67,030 96,195 123,309 118,522 83,570 830,930 2021 98,232 57,380 40,841 42,725 40,786 41,078 67,776 50,736 64,195 100,853 97,864 112,674 815,140 2022 78,390 54,635 48,488 49,322 40,021 44,588 72,448 85,474 119,711 141,177 143,845 108,377 986,476 2023 101,683 49,007 52,466 49,082 34,501 46,119 70,083 79,654 108,707 134,083 169,549 154,971 1,049,905 2024 112,006 61,555 48,355 221,916 Water Pumped 180,000 -2020 -2021 -2022 -2023 -2024 160,000 140,000 120,000 100,000 80,000 60,000 �� _ 40,000 20,000 0 - FY October November December January February March April May June July August September Total Year 2015 106,251 67,825 58,659 45,691 39,675 35,752 56,704 48,637 72,934 117,302 143,413 142,394 935,237 2016 106,731 52,616 43,708 46,945 50,721 55,178 60,434 55,562 68,138 112,533 128,963 104,664 886,193 2017 82,677 77,937 43,792 43,207 43,024 69,549 65,723 94,452 103,867 101,184 114,872 109,769 950,053 2018 91,439 78,282 55,745 40,796 40,750 51,711 67,217 97,980 124,109 155,354 144,015 85,946 1,033,344 2019 60,576 53,119 45,651 45,552 39,014 43,048 61,238 48,787 79,167 102,887 144,299 130,752 854,090 2020 112,971 48,627 49,384 40,726 35,749 38,576 57,714 74,153 106,219 136,306 130,721 89,514 920,660 2021 106,660 66,304 46,962 50,538 47,733 44,191 75,866 56,985 73,907 113,015 109,492 123,206 914,859 2022 91,078 61,928 54,930 52,679 49,094 51,606 81,977 92,915 133,828 152,199 161,534 117,252 1,101,020 2023 114,089 54,777 57,827 57,758 39,309 50,124 77,261 84,019 120,932 145,657 184,972 169,227 1,155,952 2024 122,699 69,114 53,685 245,498 9 of 131 January 17, 2024 Regular Meeting Agenda Packet 7 6 0 5 4 0 3 g 2 A1 ■11 ■ rib° 1 1 Water Production 1 Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 Dec -22 - Jan -23 Feb -23 Mar -23 • Min 1.115 1.225 0.878 0.999 • Max 2.716 2.508 2.354 2.516 Avg 1.657 1.759 1.479 1.731 May -23 Jun -23 Jul -23 Apr -23 May -23 Jun -23 Jul -23 0.920 1.730 2.628 3.277 4.597 5.729 5.950 7.079 2.780 3.125 4.079 5.266 Aug -23 Aug -23 4.622 7.305 6.291 Sep -23 Oct -23 Nov -23 Dec -23 Sep -23 Oct -23 Nov -23 Dec -23 3.391 1.119 1.026 1.044 7.430 5.458 2.803 2.476 5.234 3.566 2.145 1.772 2.150 1.950 1.750 1.550 0 • 1.350 3 1.150 0.950 0.750 Wastewater Treated IIuIIIuI.I.I.I.I.I.III.III Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 May -23 Jun -23 Jul -23 Daily Avg Flow Daily Max Flow -Daily Avg Max Aug -23 Sep -23 Oct -23 Nov -23 Dec -23 20.0 18.0 16.0 14.0 12.0 10.0 8.0 6.0 4.0 2.0 0.0 Carbonaceous Biochemical Oxygen Demand (CBOD) .1 Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 May -23 Jun -23 Jul -23 Aug -23 Sep -23 Oct -23 Nov -23 Dec -23 CBOD Avg CBOD Max -Daily Avg Max -Daily Max 10 of 131 January 17, 2024 Regular Meeting Agenda Packet 40.0 35.0 30.0 25.0 20.0 15.0 10.0 5.0 0.0 Total Suspended Solids (TSS) Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 May -23 Jun -23 Jul -23 TSS Avg TSS Max Daily Avg Max Daily Max Aug -23 Sep -23 Oct -23 Nov -23 Dec -23 10.00 9.00 8.00 7.00 6.00 5.00 4.00 3.00 2.00 1.00 0.00 Ammonia Nitrogen (NH3) Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 May -23 Jun -23 Jul -23 Aug -23 Sep -23 Oct -23 Nov -23 Dec -23 NH3 Avg NH3 Max -Daily Avg Max -Daily Max 50.0 40.0 30.0 20.0 10.0 0.0 Nitrate -Nitrogen (NO3) Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 May -23 Jun -23 Jul -23 Aug -23 Sep -23 Oct -23 Nov -23 Dec -23 NO3 Avg NO3 Max -Daily Avg Max -Daily Max 11 of 131 January 17, 2024 Regular Meeting Agenda Packet 12 of 131 Potential of Hydrogen (pH) 9 8.5 8 7.5 7 6.5 6 Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 pH Min May -23 Jun -23 Jul -23 Aug -23 pH Max a pH Avg —Daily Avg Min —Daily Avg Max Sep -23 Oct -23 Nov -23 Dec -23 Dissolved Oxygen (DO) 9.0 8.5 8.0 II 7.5 7.0 6.5 II 6.0 Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 May -23 Jun -23 Jul -23 Aug -23 Sep -23 Oct -23 Nov -23 Dec -23 DO Min DO Max DO Avg Min —Daily Avg —Daily Avg Max Escherichia coli (E. coli) 400 350 — 300 250 200 150 100 50 1.0 1.0 1.0 1.0 1.0 1.0 1.0 1.0 6.3 2.0 1.0 1.0 2.0 0 Dec -22 Jan -23 Feb -23 Mar -23 Apr -23 May -23 Jun -23 Jul -23 Aug -23 Sep -23 Oct -23 Nov -23 Dec -23 E. Avg E. Max Avg Max Max coli coli —Daily —Daily 12 of 131 January 17, 2024 Regular Meeting Agenda Packet Check Report Trophy Club Municipal Utility District No. 1 By Check Number Date Range: 11/01/2023 - 11/30/2023 Vendor Number Vendor Name Bank Code: Prosperity Bank -Prosperity Bank Payment Type: Regular Payment Date Payment Type Discount Amount Payment Amount Number 3197 BenefitMall 11/01/2023 Regular 0.00 52.00 9982 4033 Health Care Service Corporation 11/01/2023 Regular 0.00 22,147.36 9983 3216 M3 Networks 11/01/2023 Regular 0.00 2,875.94 9984 3115 Metlife Group Benefits 11/01/2023 Regular 0.00 2,301.06 9985 3176 Rey -Mar Construction 11/01/2023 Regular 0.00 116,375.00 9986 4019 Peterson Pump & Motor Service LLC 11/01/2023 Regular 0.00 7,950.00 9987 3134 Prime Controls LP 11/01/2023 Regular 0.00 11,418.20 9988 3187 CLS Sewer Equipment Co.Inc 11/15/2023 Regular 0.00 4,321.05 9989 2785 Kleen Pipe, Inc 11/15/2023 Regular 0.00 19,866.00 9990 3111 North Texas Groundwater 11/15/2023 Regular 0.00 6,168.30 9991 3156 Southern Petroleum Lab Inc 11/15/2023 Regular 0.00 706.80 9992 2440 Tarrant County Public Health Laboratory 11/15/2023 Regular 0.00 380.00 9993 2970 Air Mac 11/15/2023 Regular 0.00 12,034.09 9994 3127 Allied Welding Supply Inc. 11/15/2023 Regular 0.00 20.76 9995 2683 Charter Communications 11/15/2023 Regular 0.00 903.72 9996 3184 Dataprose LLC 11/15/2023 Regular 0.00 2,604.89 9997 2711 Endress+Hauser Inc. 11/15/2023 Regular 0.00 1,006.46 9998 2606 Fisery Solutions LLC 11/15/2023 Regular 0.00 50.00 9999 3093 Four Man Furnace Inc. 11/15/2023 Regular 0.00 2,238.75 10000 3258 Francotyp-Postalia, Inc. 11/15/2023 Regular 0.00 142.41 10001 3216 M3 Networks 11/15/2023 Regular 0.00 1,047.00 10002 2628 MCCI 11/15/2023 Regular 0.00 6,234.00 10003 3186 Member's Building Maintenance 11/15/2023 Regular 0.00 1,047.97 10004 1056 Office Depot Inc 11/15/2023 Regular 0.00 87.96 10005 2801 Pipeline Analysis LLC 11/15/2023 Regular 0.00 17,998.00 10006 3134 Prime Controls LP 11/15/2023 Regular 0.00 2,099.75 10007 3231 SC Tracking Solutions LLC 11/15/2023 Regular 0.00 595.00 10008 3156 Southern Petroleum Lab Inc 11/15/2023 Regular 0.00 6,147.60 10009 2440 Tarrant County Public Health Laboratory 11/15/2023 Regular 0.00 460.00 10010 1973 Texas Commission on Environmental Quality 11/15/2023 Regular 0.00 8,964.55 10011 2696 Texas Excavation Safety System 11/15/2023 Regular 0.00 240.35 10012 1001 Town of Trophy Club 11/15/2023 Regular 0.00 232,358.92 10013 1081 Tri County Electric 11/15/2023 Regular 0.00 518.52 10014 2634 Valley Solvents & Chemicals 11/15/2023 Regular 0.00 862.91 10015 1058 Verizon Wireless 11/15/2023 Regular 0.00 583.83 10016 3280 Watts Ellison LLC 11/15/2023 Regular 0.00 2,969.67 10017 Total Regular: 0.00 495,778.82 1/10/2024 11:31:35 AM Page 1 of 3 13 of 131 Check Report Vendor Number Payment Type: 3197 3113 3124 3113 3124 3197 3113 3124 Vendor Name Bank Draft BenefitMall TCDRS IRS Tax Payment TCDRS IRS Tax Payment BenefitMall TCDRS IRS Tax Payment Payment Type Regular Checks Manual Checks Voided Checks Bank Drafts E FT's January 17, 2024 Regular Meeting Agenda Packet Date Range: 11/01/2023 - 11/30/2023 Discount Amount Payment Amount Number Payment Date Payment Type 11/10/2023 11/30/2023 11/10/2023 11/30/2023 11/17/2023 11/22/2023 11/30/2023 11/22/2023 Bank Draft Bank Draft Bank Draft Bank Draft Bank Draft Bank Draft Bank Draft Bank Draft Total Bank Draft: Bank Code Prosperity Bank Summary Payable Count 54 0 0 8 0 Payment Count 36 0 0 8 0 Discount Payment 0.00 495,778.82 0.00 0.00 0.00 0.00 0.00 52,741.29 0.00 0.00 62 44 0.00 548,520.11 0.00 266.67 DFT0000115 0.00 10,090.25 DFT0000116 0.00 13,911.35 DFT0000117 0.00 2,164.13 DFT0000118 0.00 2,400.75 DFT0000119 0.00 266.67 DFT0000120 0.00 10,015.35 DFT0000121 0.00 13,626.12 DFT0000122 0.00 52,741.29 1/10/2024 11:31:35 AM Page 2 of 3 14 of 131 Check Report Fund 996 January 17, 2024 Regular Meeting Agenda Packet Date Range: 11/01/2023 - 11/30/2023 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 54 36 0.00 495,778.82 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 8 8 0.00 52,741.29 EFT's 0 0 0.00 0.00 62 44 0.00 548,520.11 Fund Summary Name MUD Consolidated Cash Period Amount 11/2023 548,520.11 548,520.11 1/10/2024 11:31:35 AM Page 3 of 3 15 of 131 $14,423,933 Adopted Budget vs YTD Actuals Revenues & Expenses $1,857,090 52,506,346 $14,423,933 January 17, 2024 Regular Meeting Agenda Packet FY 2024 Combined Financials YTD as of 11/30/2023 YTD Revenues • YTD Expenses $983 $12,218 0% YTD Expenses By Departments YTD Expense- Water $1,396,402 56% YTD Expense- WW YTD Expense- Admin YTD Expense- BOD • YTD Expense- Non Dept Water Budget vs Actual 140,000,000 120,000,000 100,000,000 80,000,000 60,000,000 40,000,000 20,000,000 0 Water Consumption Budget vs Actual 112,006,200 -- 92,198,177 51,503,997 61,555,000 Budget Consumption --Actual Consumption Oct Nov 1,000,000,000 900,000,000 800,000,000 700,000,000 600,000,000 500,000,000 400,000,000 300,000,000 200,000,000 100,000,000 0 Adopted Budget Water Consumption Vs Actual Water Consumption 868,678,857 898,537,882 Total Water Consumption • Budgeted Water Consumption • Projected Water Consumption Presented by: Finance Department $1,000,000 5900,000 5800,000 5700,000 $600,000 5500,000 5400,000 5300,000 5200,000 $100,000 $0 Water Revenue Budget vs Actual 8676,430 $554,257 $493,961 0297,607 Budget Revenue --Actual Revenue Oct Nov $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 50 Adopted Budget Water Revenue Vs Projected Water Revenue $5,166,291 $5,484,817 $2,510,794 Total Water Revenue $2,842,663 • Budgeted Water Revenue • Projected Water Revenue Net Budgeted Water Revenue Minus Budgeted Expenses • Net Projected Water Revenue Minus Projected Expenses 16 of 131 Fund: 135 - MUD 1 Ge Revenue Department: 000 - 135-000-40000-000 135-000-40002-000 135-000-40015-000 135-000-40025-000 135-000-47000-000 135-000-47005-000 135-000-47025-000 135-000-47030-000 135-000-47035-000 135-000-47045-000 135-000-47070-000 135-000-49011-000 135-000-49016-000 135-000-49026-000 135-000-49035-000 135-000-49036-000 135-000-49075-000 135-000-49141-000 135-000-49900-000 Trophy Club Municipal Utility District No. 1 neral Fund Revenue, Asset, Liability, & Equity Property Taxes Property Taxes/Delinquent Property Taxes/P & I PID Surcharges Water Sewer Penalties Service Charges Plumbing Inspections Sewer Inspections TCCC Effluent Charges Interest Income Cell Tower Revenue Proceeds from Sale of Assets Prior Year Reserves GASB Reserves Oversize Meter Reimbursement Interfund Transfer In Miscellaneous Income Department: 000 - Revenue, Asset, Liability, & Equity Total: Expense Department: 010 - Water 135-010-50005-000 135-010-50010-000 135-010-50016-000 135-010-50017-000 135-010-50020-000 135-010-50026-000 135-010-50027-000 135-010-50028-000 135-010-50029-000 135-010-50030-000 135-010-50035-000 135-010-50040-000 135-010-50045-000 135-010-50060-000 135-010-50070-000 135-010-55080-000 135-010-55085-000 135-010-55090-000 135-010-55105-000 135-010-55120-000 135-010-55135-000 135-010-55135-001 135-010-60010-000 135-010-60020-000 135-010-60066-000 135-010-60080-000 January 17, 2024 Regular Meeting Agenda Packet Original Current Total Budget Total Budget 85,733.51 300.00 300.00 143,223.25 6,939,998.00 3,679,786.00 105,800.00 3,350.00 300.00 100.00 70,000.00 150,000.00 49,320.00 25,000.00 1,933,264.00 50,000.00 2,058.00 1,178,400.00 7,000.00 14,423,932.76 85,733.51 300.00 300.00 143,223.25 6,939,998.00 3,679,786.00 105,800.00 3,350.00 300.00 100.00 70,000.00 150,000.00 49,320.00 25,000.00 1,933,264.00 50,000.00 2,058.00 1,178,400.00 7,000.00 14,423,932.76 Budget Report Account Summary For Fiscal: 2023-2024 Period Ending: 11/30/2023 Period Activity 3,517.72 -22.36 8.59 0.00 493,960.82 302,703.73 8,875.88 375.00 0.00 0.00 0.80 39,408.35 8,120.00 0.00 0.00 0.00 0.00 0.00 0.00 856,948.53 Variance Fiscal Favorable Percent Activity (Unfavorable) Remaining 3,517.72 104.73 34.77 0.00 1,170,391.17 560,884.35 17,051.84 1,250.00 150.00 0.00 14,311.20 80,845.79 8,120.00 0.00 0.00 0.00 428.00 0.00 0.00 1,857,089.57 -82,215.79 -195.27 -265.23 -143,223.25 -5,769,606.83 -3,118,901.65 -88,748.16 -2,100.00 -150.00 -100.00 -55,688.80 -69,154.21 -41,200.00 -25,000.00 -1,933,264.00 -50,000.00 -1,630.00 -1,178,400.00 -7,000.00 -12,566,843.19 95.90 % 65.09 % 88.41 % 100.00 % 83.14 % 84.76 % 83.88 % 62.69 % 50.00 % 100.00 % 79.56 % 46.10 % 83.54 % 100.00 % 100.00 % 100.00 % 79.20 % 100.00 % 100.00 % 87.12% Revenue Total: 14,423,932.76 14,423,932.76 856,948.53 1,857,089.57 -12,566,843.19 87.12% Salaries & Wages Overtime Longevity Certification Retirement Medical Insurance Dental lnsurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations Maintenance & Repairs Generator Maint. and Repair Vehicle Maintenance Maintenance-Backhoe/SkidLoader Cleaning Services Lab Analysis Lab Analysis for PID Communications/Mobiles Electricity Publications/Books/Subscripts Schools & Training 431,575.02 431,575.02 17,000.00 17,000.00 6,252.50 6,252.50 3,600.00 3,600.00 56,730.41 56,730.41 116,527.50 116,527.50 4,834.55 4,834.55 1,051.01 1,051.01 4,000.00 4,000.00 28,422.51 28,422.51 6,647.20 6,647.20 1,260.00 1,260.00 11,898.56 11,898.56 400.00 400.00 300.00 300.00 201,500.00 201,500.00 2,000.00 2,000.00 5,000.00 5,000.00 1,000.00 1,000.00 2,500.00 2,500.00 7,500.00 7,500.00 2,000.00 2,000.00 7,500.00 7,500.00 183,143.49 183,143.49 1,000.00 1,000.00 2,630.00 2,630.00 33,473.26 954.05 6,252.50 225.00 4,908.58 8,444.02 350.33 71.31 286.69 2,470.91 577.86 0.00 1,060.94 0.00 0.00 411.04 951.60 0.00 0.00 40.31 1,214.00 574.00 669.64 19,214.23 0.00 113.75 58,622.17 2,417.53 6,252.50 450.00 9,106.17 16,888.04 700.66 142.60 577.38 4,094.82 957.65 0.00 2,121.88 0.00 0.00 7,677.98 951.60 953.90 1,911.94 40.31 1,214.00 574.00 669.64 19,214.23 0.00 113.75 372,952.85 14,582.47 0.00 3,150.00 47,624.24 99,639.46 4,133.89 908.41 3,422.62 24,327.69 5,689.55 1,260.00 9,776.68 400.00 300.00 193,822.02 1,048.40 4,046.10 -911.94 2,459.69 6,286.00 1,426.00 6,830.36 163,929.26 1,000.00 2,516.25 86.42 % 85.78 % 0.00 % 87.50 % 83.95 % 85.51 % 85.51 % 86.43 % 85.57 % 85.59 % 85.59 % 100.00 % 82.17 % 100.00 % 100.00 % 96.19 % 52.42 % 80.92 % -91.19 % 98.39 % 83.81 % 71.30 % 91.07 % 89.51 % 100.00 % 95.67 % 1/10/2024 11:27:52 AM 17 of 131 Budget Report 135-010-60100-000 135-010-60135-000 135-010-60135-001 135-010-60150-000 135-010-60285-000 135-010-60332-000 135-010-65005-000 135-010-65010-000 135-010-65030-000 135-010-65050-000 135-010-65053-000 135-010-69005-000 135-010-69195-000 January 17, 2024 Regular Meeting Agenda Packet For Fiscal: 2023-2024 Period Ending: 11/30/2023 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining Travel & per diem 577.50 577.50 0.00 0.00 577.50 100.00 % TCEQ Fees & Permits 29,500.00 29,500.00 8,964.55 8,964.55 20,535.45 69.61 % TCEQ Fees & Permits for PID 500.00 500.00 0.00 0.00 500.00 100.00 % Wholesale Water 2,655,497.13 2,655,497.13 253,960.96 253,960.96 2,401,536.17 90.44 % Lawn Equipment & Maintenance 12,500.00 12,500.00 1,200.00 1,200.00 11,300.00 90.40 % Interfund Transfer Out -Rev I&S 565,796.88 565,796.88 51,500.52 103,001.04 462,795.84 81.80 Fuel & Lube 23,575.00 23,575.00 2,077.18 3,280.36 20,294.64 86.09 % Uniforms 4,355.00 4,355.00 309.90 309.90 4,045.10 92.88 Chemicals 58,200.00 58,200.00 2,419.99 8,119.29 50,080.71 86.05 % Meter Expense 20,000.00 20,000.00 0.00 0.00 20,000.00 100.00 % Meter Change Out Program 124,500.00 124,500.00 0.00 0.00 124,500.00 100.00 % Capital Outlays 4,200,000.00 4,200,000.00 303,255.16 503,254.57 3,696,745.43 88.02 % GASB Reserve for Replacement 378,659.00 378,659.00 0.00 378,659.00 0.00 0.00 % Department: 010 - Water Total: 9,179,933.26 9,179,933.26 705,952.28 1,396,402.42 7,783,530.84 84.79% Department: 020 - Wastewater 135-020-50005-000 Salaries & Wages 290,304.62 290,304.62 18,536.17 32,482.71 257,821.91 88.81 % 135-020-50010-000 Overtime 20,000.00 20,000.00 1,391.02 2,191.01 17,808.99 89.04 % 135-020-50016-000 Longevity 2,367.50 2,367.50 2,540.00 2,540.00 -172.50 -7.29 % 135-020-50017-000 Certification 5,100.00 5,100.00 225.00 450.00 4,650.00 91.18 % 135-020-50020-000 Retirement 40,934.05 40,934.05 2,723.06 5,040.68 35,893.37 87.69 % 135-020-50026-000 Medical Insurance 93,222.04 93,222.04 4,503.48 9,006.96 84,215.08 90.34 % 135-020-50027-000 Dental Insurance 3,385.28 3,385.28 166.51 333.02 3,052.26 90.16 % 135-020-50028-000 Vision Insurance 818.82 818.82 42.52 85.04 733.78 89.61 % 135-020-50029-000 Life Insurance & Other 3,000.00 3,000.00 192.36 358.62 2,641.38 88.05 % 135-020-50030-000 Social Security Taxes 20,507.87 20,507.87 1,359.07 2,255.67 18,252.20 89.00 % 135-020-50035-000 Medicare Taxes 4,796.20 4,796.20 317.83 527.51 4,268.69 89.00 % 135-020-50040-000 Unemployment Taxes 1,008.00 1,008.00 0.00 0.00 1,008.00 100.00 % 135-020-50045-000 Workman's Compensation 8,403.61 8,403.61 748.93 1,497.86 6,905.75 82.18 % 135-020-50060-000 Pre-emp Physicals/Testing 400.00 400.00 0.00 0.00 400.00 100.00 % 135-020-50070-000 Employee Relations 300.00 300.00 0.00 0.00 300.00 100.00 % 135-020-55080-000 Maintenance & Repairs 137,000.00 137,000.00 18,250.58 22,602.75 114,397.25 83.50 % 135-020-55081-000 Mainten & Repairs Collections 270,000.00 270,000.00 37,272.44 37,523.99 232,476.01 86.10 % 135-020-55085-000 Generator Maint. and Repair 11,000.00 11,000.00 1,800.00 1,800.00 9,200.00 83.64 % 135-020-55090-000 Vehicle Maintenance 4,600.00 4,600.00 142.94 142.94 4,457.06 96.89 % 135-020-55091-000 Veh Maintenance Collections 13,000.00 13,000.00 3,276.26 3,307.01 9,692.99 74.56 % 135-020-55105-000 Maintenance-Backhoe/SkidLoader 3,000.00 3,000.00 1,374.77 1,374.77 1,625.23 54.17 % 135-020-55120-000 Cleaning Services 2,000.00 2,000.00 40.31 40.31 1,959.69 97.98 % 135-020-55125-000 Dumpster Services 100,000.00 100,000.00 8,401.08 13,238.50 86,761.50 86.76 % 135-020-55135-000 Lab Analysis 55,000.00 55,000.00 13,476.82 13,476.82 41,523.18 75.50 % 135-020-60010-000 Communications/Mobiles 7,500.00 7,500.00 401.78 401.78 7,098.22 94.64 % 135-020-60020-000 Electricity 242,978.33 242,978.33 22,240.83 22,240.83 220,737.50 90.85 % 135-020-60080-000 Schools & Training 2,119.00 2,119.00 0.00 0.00 2,119.00 100.00 % 135-020-60100-000 Travel & per diem 527.50 527.50 0.00 0.00 527.50 100.00 % 135-020-60135-000 TCEQ Fees & Permits 12,000.00 12,000.00 0.00 9,888.02 2,111.98 17.60 % 135-020-60285-000 Lawn Equipment & Maintenance 16,000.00 16,000.00 1,300.00 1,300.00 14,700.00 91.88 % 135-020-60331-000 Interfund Transfer Out -Tax I&S 115,885.76 115,885.76 10,535.09 21,070.18 94,815.58 81.82 % 135-020-60332-000 Interfund Transfer Out -Rev I&S 698,542.63 698,542.63 63,548.65 127,097.30 571,445.33 81.81 % 135-020-65005-000 Fuel & Lube 13,000.00 13,000.00 4,383.48 5,254.48 7,745.52 59.58 % 135-020-65010-000 Uniforms 3,520.00 3,520.00 140.88 140.88 3,379.12 96.00 % 135-020-65030-000 Chemicals 32,500.00 32,500.00 0.00 2,664.09 29,835.91 91.80 % 135-020-65031-000 Chemicals Collections 10,000.00 10,000.00 0.00 0.00 10,000.00 100.00 % 135-020-65045-000 Lab Supplies 33,000.00 33,000.00 0.00 16,970.67 16,029.33 48.57 % 135-020-69005-000 Capital Outlays 1,050,000.00 1,050,000.00 196,539.00 215,539.00 834,461.00 79.47 % 135-020-69008-000 Short Term Debt -Principal 22,398.34 22,398.34 0.00 0.00 22,398.34 100.00 % 135-020-69009-000 Short Term Debt -Interest 442.39 442.39 0.00 0.00 442.39 100.00 % 135-020-69195-000 GASB Reserve for Replacement 155,762.00 155,762.00 0.00 155,762.00 0.00 0.00 % Department: 020 - Wastewater Total: 3,506,323.94 3,506,323.94 415,870.86 728,605.40 2,777,718.54 79.22% 1/10/2024 11:27:52 AM 18 of 131 Budget Report Department: 026 - Board of Directors 135-026-50045-000 Workman's Compensation 135-026-60070-000 Dues & Memberships 135-026-60075-000 Meetings 135-026-60080-000 Schools & Training 135-026-60100-000 Travel & per diem 135-026-60245-000 Miscellaneous Expenses Department: 026 - Board of Directors Total: Department: 030 - Administration 135-030-50005-000 Salaries & Wages 135-030-50010-000 Overtime 135-030-50016-000 Longevity 135-030-50020-000 Retirement 135-030-50026-000 Medical Insurance 135-030-50027-000 Dental lnsurance 135-030-50028-000 Vision Insurance 135-030-50029-000 Life Insurance & Other 135-030-50030-000 Social Security Taxes 135-030-50035-000 Medicare Taxes 135-030-50040-000 Unemployment Taxes 135-030-50045-000 Workman's Compensation 135-030-50060-000 Pre-emp Physicals/Testing 135-030-50070-000 Employee Relations 135-030-55030-000 Software & Support 135-030-55080-000 Maintenance & Repairs 135-030-55085-000 Generator Maint. and Repair 135-030-55120-000 Cleaning Services 135-030-55160-000 Professional Outside Services 135-030-55205-000 Utility Billing Contract 135-030-60005-000 Telephone January 17, 2024 Regular Meeting Agenda Packet For Fiscal: 2023-2024 Period Ending: 11/30/2023 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining 15.00 750.00 1,500.00 4,000.00 5,000.00 500.00 15.00 750.00 1,500.00 4,000.00 5,000.00 500.00 11,765.00 11,765.00 663,185.25 2,000.00 2,532.50 82,631.07 108,759.00 3,816.74 886.17 4,800.00 41,398.50 9,681.91 1,512.00 1,597.19 500.00 4,000.00 130,311.00 23,000.00 1,000.00 13,825.00 100,000.00 9,000.00 6,000.00 663,185.25 2,000.00 2,532.50 82,631.07 108,759.00 3,816.74 886.17 4,800.00 41,398.50 9,681.91 1,512.00 1,597.19 500.00 4,000.00 130,311.00 23,000.00 1,000.00 13,825.00 100,000.00 9,000.00 6,000.00 0.66 0.00 115.99 0.00 0.00 0.00 116.65 51,239.34 0.00 2,597.50 6,433.44 6,755.22 241.48 55.37 512.54 3,214.99 751.91 0.00 139.51 0.00 0.00 21,836.06 0.00 631.25 2,174.70 3,141.30 1,292.16 427.92 1.32 750.00 231.98 0.00 0.00 0.00 983.30 89,725.10 70.94 2,597.50 12,454.40 13,510.44 482.96 110.72 895.10 5,516.68 1,290.21 0.00 279.02 0.00 0.00 66,763.17 0.00 1,348.04 2,174.70 72,690.30 1,292.16 918.66 13.68 0.00 1,268.02 4,000.00 5,000.00 500.00 10,781.70 573,460.15 1,929.06 -65.00 70,176.67 95,248.56 3,333.78 775.45 3,904.90 35,881.82 8,391.70 1,512.00 1,318.17 500.00 4,000.00 63,547.83 23,000.00 -348.04 11,650.30 27,309.70 7,707.84 5,081.34 91.20 % 0.00 84.53 % 100.00 100.00 % 100.00 % 91.64% 86.47 % 96.45 % -2.57 % 84.93 % 87.58 % 87.35 % 87.51 % 81.35 % 86.67 % 86.67 % 100.00 % 82.53 % 100.00 % 100.00 % 48.77 % 100.00 % -34.80 % 84.27 % 27.31 % 85.64 % 84.69 % 135-030-60010-000 Communications/Mobiles 3,000.00 3,000.00 96.52 96.52 2,903.48 96.78 % 135-030-60020-000 135-030-60025-000 135-030-60035-000 Electricity/Gas Water Postage 17,684.51 5,000.00 30,000.00 17,684.51 5,000.00 30,000.00 1,244.52 393.83 5,462.65 1,244.52 817.33 5,472.62 16,439.99 4,182.67 24,527.38 92.96 % 83.65 % 81.76 % 135-030-60040-000 Service Charges & Fees 140,000.00 140,000.00 17,835.26 36,504.33 103,495.67 73.93 % 135-030-60050-000 135-030-60055-000 135-030-60070-000 Bad Debt Expense 13,000.00 13,000.00 0.00 0.00 13,000.00 100.00 % Insurance 116,158.22 116,158.22 9,618.44 19,236.88 96,921.34 83.44 % Dues & Memberships 6,800.00 6,800.00 391.00 491.00 6,309.00 92.78 % 135-030-60080-000 Schools & Training 3,900.00 3,900.00 513.10 513.10 3,386.90 86.84 % 135-030-60100-000 135-030-60115-000 135-030-60285-000 135-030-60360-000 135-030-65010-000 135-030-65055-000 135-030-65085-000 135-030-65095-000 135-030-69170-000 135-030-69195-000 Travel & per diem 1,227.50 1,227.50 0.00 0.00 1,227.50 100.00 % Elections 10,000.00 10,000.00 0.00 0.00 10,000.00 100.00 % Lawn Equipment & Maintenance 5,000.00 5,000.00 469.67 469.67 4,530.33 90.61 % Furniture/Equipment < $5000 3,000.00 3,000.00 0.00 0.00 3,000.00 100.00 % Uniforms 530.00 530.00 0.00 0.00 530.00 100.00 % Hardware 8,200.00 8,200.00 0.00 2,476.46 5,723.54 69.80 % Office Supplies 5,000.00 5,000.00 535.33 1,267.02 3,732.98 74.66 % Maintenance Supplies 5,000.00 5,000.00 1,057.73 1,972.39 3,027.61 60.55 % Copier Lease Installments 4,000.00 4,000.00 444.50 551.89 3,448.11 86.20 % GASB Reserve for Replacement 24,903.00 24,903.00 0.00 24,903.00 0.00 0.00 % Department: 030 - Administration Total: 1,612,839.56 1,612,839.56 139,507.24 368,136.83 1,244,702.73 77.17% Department: 039 - Non Departmental 135-039-55045-000 Legal 65,000.00 65,000.00 5,575.05 5,575.05 59,424.95 91.42 % 135-039-55055-000 Auditing 30,000.00 30,000.00 0.00 4,500.00 25,500.00 85.00 % 135-039-55060-000 Appraisal 13,071.00 13,071.00 2,142.72 2,142.72 10,928.28 83.61 % 1/10/2024 11:27:52 AM 19 of 131 Tax Admin Fees 5,000.00 5,000.00 0.00 0.00 5,000.00 100.00 Department: 039 - Non Departmental Total: 113,071.00 113,071.00 7,717.77 12,217.77 100,853.23 89.19% Budget Report January 17, 2024 Regular Meeting Agenda Packet For Fiscal: 2023-2024 Period Ending: 11/30/2023 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining 135-039-55065-000 Expense Total: 14,423,932.76 14,423,932.76 1,269,164.80 2,506,345.72 11,917,587.04 82.62% Fund: 135 - MUD 1 General Fund Surplus (Deficit): 0.00 0.00 -412,216.27 -649,256.15 -649,256.15 0.00% Report Surplus (Deficit): 0.00 0.00 -412,216.27 -649,256.15 -649,256.15 0.00% 1/10/2024 11:27:52 AM 20 of 131 Department Trophy Club Municipal Utility District No. 1 Asset 000 - Revenue, Asset, Liability, & Equity Liability 000 - Revenue, Asset, Liability, & Equity Total Asset: Total Liability: Equity 000 - Revenue, Asset, Liability, & Equity Total Total Beginning Equity: Total Revenue Total Expense Revenues Over/Under Expenses Total Equity and Current Surplus (Deficit): Total Liabilities, Equity and Current Surplus (Deficit): January 17, 2024 Regular Meeting Agenda Packet Balance Sheet Funds 122 - 528 Account Summary As Of 11/30/2023 122 - Trophy Club 135 - MUD 1 137 - MUD 1 519 - 2016 Rev 520 - Revenue 528 - 2015 MUD Fire Dept. General Fund Consolidated Bond Const- Bond 16" Revenue Bond GASB SWIFT Waterline Reserve Fund 1,808,976.11 1,808,976.11 11,638,600.62 11,638,600.62 Total 3,898,890.58 823,508.19 1,189,655.11 950,811.51 20,310,442.12 3,898,890.58 823,508.19 1,189,655.11 950,811.51 20,310,442.12 1,271,977.97 1,271,977.97 766,150.10 766,150.10 55,601.40 284,753.36 -229,151.96 536,998.14 1,808,976.11 1,580,285.67 1,580,285.67 10,707,571.10 10,707,571.10 1,857,089.57 2,506,345.72 -649,256.15 10,058,314.95 11,638,600.62 0.00 81,691.15 0.00 0.00 2,933,954.79 0.00 81,691.15 0.00 0.00 2,933,954.79 3,258,146.58 735,325.73 1,179,058.79 942,342.55 17,588,594.85 3,258,146.58 735,325.73 1,179,058.79 942,342.55 17,588,594.85 640,744.00 6,491.31 10,596.32 8,468.96 2,578,991.56 0.00 0.00 0.00 0.00 2,791,099.08 640,744.00 6,491.31 10,596.32 8,468.96 -212,107.52 3,898,890.58 741,817.04 1,189,655.11 950,811.51 17,376,487.33 3,898,890.58 823,508.19 1,189,655.11 950,811.51 20,310,442.12 Monthly Financial Activity Footnotes: Fund 122 Activity • Daily property tax deposits • Monthly transfer OUT to MUD General Fund to cover Town transfers and any other A/P expenses Fund 135 Activity • Daily property tax deposits • All A/P checks are cut through the General Fund • Monthly transfer IN to cover other fund A/P expenses • • Monthly transfer OUT for l&S Revenue Bond payments for Fund 534, 535, & 536 Monthly bank interest Fund 137 Activity • Transfer IN at beginning of fiscal year based on yearly budget and transfer OUT at fiscal year-end based on reserves balances Fund 519 Activity • Monthly bank interest Fund 520 Activity • Transfer OUT to MUD General Fund to cover Interconnect Waterline construction project expenses • Monthly bank interest Fund 528 Activity • Monthly bank interest 1/10/2024 11:43:13 AM 21 of 131 Page 1 of 1 Department Trophy Club Municipal Utility District No. 1 Asset 000 - Revenue, Asset, Liability, & Equity Total Asset: 533 - MUD 1 I&S 534 - 2015 535 - 2016 Rev 536 - 2019 Rev Consolidated Revenue Bond Bond I&S-SWIFT Bond I&S- I&S W&WW System 330,701.01 150, 95 7.74 330,701.01 150,957.74 Liability 000 - Revenue, Asset, Liability, & Equity 209,862.21 61,738.89 75,785.71 January 17, 2024 Regular Meeting Agenda Packet Balance Sheet I&S Funds 533 - 536 Account Summary As Of 11/30/2023 61,738.89 75,785.71 0.00 0.00 0.00 Total Liability: 209,862.21 Equity 000 - Revenue, Asset, Liability, & Equity Total Total Beginning Equity: Total Revenue Total Expense Revenues Over/Under Expenses Total Equity and Current Surplus (Deficit): Total Liabilities, Equity and Current Surplus (Deficit): 0.00 0.00 0.00 89,219.04 39,137.14 11,713.62 6,476.05 89,219.04 39,137.14 11,713.62 6,476.05 31,619.76 111,820.60 50,025.27 69,309.66 0.00 0.00 0.00 0.00 31,619.76 111,820.60 50,025.27 69,309.66 120,838.80 150,957.74 61,738.89 75,785.71 330,701.01 150,957.74 61,738.89 75,785.71 Total 619,183.35 619,183.35 209,862.21 209,862.21 146,545.85 146,545.85 262,775.29 0.00 262,775.29 409,321.14 619,183.35 Monthly Financial Activity Footnotes: Fund 533 Activity Daily property tax deposits Monthly transfer IN from Fund 135 for PID portion of semi-annual GO Bond payments 3/1 & 9/1 GO Bond payments (Interest and Principal) Monthly bank interest Fund 534 Activity Monthly transfer IN for semi-annual I&S Revenue Bond payment from Fund 533 3/1 & 9/1 Revenue Bond payments (Interest and Principal) Monthly bank interest Fund 535 Activity Monthly transfer IN for semi-annual I&S Revenue Bond payment from Fund 533 3/1 & 9/1 Revenue Bond payments (Interest and Principal) Monthly bank interest Fund 536 Activity Monthly transfer IN for semi-annual I&S Revenue Bond payment from Fund 533 3/1 & 9/1 Revenue Bond payments (Interest and Principal) Monthly bank interest 1/10/2024 11:46:13 AM 22 of 131 Page 1 of 1 January 17, 2024 Regular Meeting Agenda Packet CASH STATUS AS OF NOVEMBER 2023 TexPool 0 & M (XXXXX0002)-Fire Operating Cash Restricted - Unable to be spent Unrestricted- Available for spending Total in Accounts (Restricted & Unrestricted) 135-10250 TexPool 0 & M (XXXXX0002)-General Fund Operating **" Prosperity Bank (XXX8701) Fire Operating $0 $2,908,520 $2,908,520 135-10300 Prosperity Bank (XXX8701) General Fund Operating * $146,705 $5,394,831 $5,541,536 135-10305 Prosperity Bank Reserve -Savings Acct (XXXXX7724) $1,947,082 $0 $1,947,082 135-11100 Petty Cash Administration $0 $150 $150 135-11150 Petty Cash Utility Billing $0 $450 $450 137-10250 TexPool 0 & M (XXXXX0002) GASB Replacement $3,898,891 $0 $3,898,891 519-10250 Texpool Revenue Bond Construction (XXXXX015) SWIFT $0 $0 $0 51 9-1 11 55 Cash -Bond Escrow Bank of Texas (SWIFT) $823,508 $0 $823,508 520-10250 Texpool Revenue Bond Water & Waste Water Systems 2019 (XXXXX018) $1,189,655 $0 $1,189,655 520-10300 Prosperity Bank Construction Water & Waste Water Systems 2019 $0 $0 $0 528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements $950,812 $0 $950,812 533-10250 TexPool Tax I & S (XXXXX0003) $117,455 $0 $117,455 533-10300 Prosperity Bank (XXX8701) Tax I&S $0 $0 $0 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements $150,958 $0 $150,958 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT $61,739 $0 $61,739 536-10250 TexPool Revenue I & S (XXXXX020) Water & Waste Water Systems $75,786 $0 $75,786 $8,303,951 $17,666,541 Amount available in cash for spending (MUD Accounts) *11/30/2023 Customer Water Deposits $146,705 Fire Department Cash $8,303,951 122-10250 TexPool 0 & M (XXXXX0002)-Fire Operating Cash $0 $509,663 $509,663 122-10300 Prosperity Bank (XXX8701) Fire Operating $0 $0 $0 $0 $509,663 $509,663 Amount available in cash for spending (Fire Department Accounts) $509,663 General Fund 135 Available $ 5,394,831 Prosperity General Fund $ 2,908,520 Texpool General Fund $ 600 Petty Cash Total General Fund 135 Available for Spending $ 8,303,951 General Fund 135 Fund Balances Nonspendable Fund Balance (Prepaids) $ 3,880 Assigned Fund Balance (FY2024 Capital Projects plus prior year carry forward) $ 6,516,007 Unassigned Fund Balance $ 4,187,684 Current Year Revenue/Expenses $ (649,256) Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 $10,058,315 23 of 131 ebills Bills Mailed Bank Draft Credit Card Draft Online Payments Late Notices Disconnects Connections MUD Connections Town January 17, 2024 Regular Meeting Agenda Packet November Utility Billing Report Fiscal Year 2023 - 2024 November 2022 December 2022 January 2023 February 2023 March 2023 April 2023 May 2023 June 2023 July 2023 August 2023 September 2023 October 2023 November 2023 1,710 1,746 1,765 1,777 1,773 1,767 1,794 1,766 1,750 1,744 1,742 1,745 1,740 3,801 3,768 3,741 3,751 3,744 3,743 3,734 3,755 3,749 3,747 3,747 3,737 3,739 711 630 606 599 599 590 588 589 585 578 572 569 562 1,494 2,251 2,540 2,719 3,016 2,998 2,754 3,134 3,101 2,957 3,086 3,072 3,006 1,049 0 0 0 547 413 289 290 327 327 268 344 255 298 4 0 0 0 0 8 9 9 13 7 7 13 4 3,399 3,399 3,394 3,394 3,394 3,394 3,394 3,395 3,395 3,395 3,395 3,395 3,395 1,444 1,444 1,444 1,443 1,443 1,443 1,443 1,443 1,443 1,443 1,443 1,444 1,444 November Permits Fiscal Year 2023 - 2024 Date of Permit Permit No. Customer Deposit Due to FW Water Oversize Meter Plumbing Inspections Sewer Inspections Fire Line Misc. Income Total $ - $ - $ - $ - $ - $ - $ - $ Total $ - $ - $ - $ - $ - $ - $ - $ 24 of 131 January 17, 2024 Regular Meeting Agenda Packet Check Report Trophy Club Municipal Utility District No. 1 By Check Number Date Range: 12/01/2023 - 12/31/2023 Vendor Number Vendor Name Bank Code: Prosperity Bank -Prosperity Bank Payment Type: Regular Payment Date Payment Type Discount Amount Payment Amount Number 2558 First Check Applicant Screenin 12/06/2023 Regular 3298 308 Construction LLC 12/06/2023 Regular 2222 Aflac 12/06/2023 Regular 2691 All Test Fire Protection LLC 12/06/2023 Regular 2772 Allied Waste Industries 12/06/2023 Regular 3127 Allied Welding Supply Inc. 12/06/2023 Regular 3197 BenefitMall 12/06/2023 Regular 3299 Bickerstaff Heath Delgado Acosta LLP 12/06/2023 Regular 1250 Bio -Aquatic Testing Inc. 12/06/2023 Regular 4018 BP Energy Holding Company LLC 12/06/2023 Regular 1030 City of Fort Worth 12/06/2023 Regular 2786 Cleargov Inc 12/06/2023 Regular 3184 Dataprose LLC 12/06/2023 Regular 1737 DPC Industries Inc. 12/06/2023 Regular 1026 Federal Express Corp 12/06/2023 Regular 2558 First Check Applicant Screenin 12/06/2023 Regular 3093 Four Man Furnace Inc. 12/06/2023 Regular 2796 Garver 12/06/2023 Regular 3292 Grapevine Dodge Chrysler Jeep 12/06/2023 Regular 4033 Health Care Service Corporation 12/06/2023 Regular 2802 Industrial Disposal Supply LLC 12/06/2023 Regular 3297 J&L Construction LLC 12/06/2023 Regular 2783 JJ HVAC LLC 12/06/2023 Regular 2943 JP Morgan Chase Bank NA 12/06/2023 Regular 3278 Kyocera Document Solutions 12/06/2023 Regular 3132 Legal Shield 12/06/2023 Regular 3186 Member's Building Maintenance 12/06/2023 Regular 3115 Metlife Group Benefits 12/06/2023 Regular 3200 Mettler -Toledo LLC 12/06/2023 Regular 2760 NDS Leasing 12/06/2023 Regular 1056 Office Depot Inc 12/06/2023 Regular 4019 Peterson Pump & Motor Service LLC 12/06/2023 Regular 3134 Prime Controls LP 12/06/2023 Regular 2703 RDO Equipment Co. 12/06/2023 Regular 3176 Rey -Mar Construction 12/06/2023 Regular 2821 Ricochet Fuel Distributors,Inc 12/06/2023 Regular 2809 Rod L Abbott CPA LLC 12/06/2023 Regular 2633 Sluder Emergency Power Service 12/06/2023 Regular 1578 Smith Pump Company, Inc. 12/06/2023 Regular 3156 Southern Petroleum Lab Inc 12/06/2023 Regular 2659 Tarrant Appraisal District 12/06/2023 Regular 2696 Texas Excavation Safety System 12/06/2023 Regular 1000 Trophy Club Mud (Water Bills) 12/06/2023 Regular 2798 Tyler Technologies Inc 12/06/2023 Regular 3225 US Bank Voyager Fleet Systems 12/06/2023 Regular 2196 Victor Insurance Managers 12/06/2023 Regular 2970 Air Mac 12/18/2023 Regular 2772 Allied Waste Industries 12/18/2023 Regular 2683 Charter Communications 12/18/2023 Regular 3184 Dataprose LLC 12/18/2023 Regular 1018 Denton Central Appraisal District 12/18/2023 Regular 3118 Exclusive Pest Control 12/18/2023 Regular 2606 Fisery Solutions LLC 12/18/2023 Regular 0.00 -160.45 9347 0.00 158,650.00 10018 0.00 446.16 10019 0.00 719.88 10020 0.00 1,833.80 10021 0.00 21.15 10022 0.00 52.00 10023 0.00 5,575.05 10024 0.00 1,170.00 10025 0.00 42,181.06 10026 0.00 253,960.96 10027 0.00 13,498.73 10028 0.00 456.48 10029 0.00 1,557.08 10030 0.00 6.05 10031 0.00 160.45 10032 0.00 31.25 10033 0.00 8,700.30 10034 0.00 37,791.00 10035 0.00 22,147.36 10036 0.00 2,002.44 10037 0.00 294,652.86 10038 0.00 825.00 10039 0.00 7,163.74 10040 0.00 94.50 10041 0.00 15.95 10042 0.00 1,207.35 10043 0.00 2,301.06 10044 0.00 402.82 10045 0.00 350.00 10046 0.00 439.99 10047 0.00 4,345.00 10048 0.00 1,028.75 10049 0.00 1,374.77 10050 0.00 7,394.47 10051 0.00 4,491.53 10052 0.00 5,500.00 10053 0.00 2,431.25 10054 0.00 8,635.00 10055 0.00 1,728.00 10056 0.00 2,142.72 10057 0.00 252.70 10058 0.00 393.83 10059 0.00 150.00 10060 0.00 1,969.13 10061 0.00 142.00 10062 0.00 3,924.50 10072 0.00 6,567.28 10073 0.00 903.72 10074 0.00 2,594.79 10075 0.00 1,967.85 10076 0.00 245.00 10077 0.00 50.00 10078 1/11/2024 1:07:41 PM Page 1 of 4 25 of 131 Check Report Vendor Number 2796 2754 3216 2784 4019 3156 3182 2440 1001 1058 3280 Vendor Name Garver Lower Colorado River Authority M3 Networks Manning Concrete Sawing Peterson Pump & Motor Service LLC Southern Petroleum Lab Inc Strategic Government Resources Tarrant County Public Health Laboratory Town of Trophy Club Verizon Wireless Watts Ellison LLC Payment Date 12/18/2023 12/18/2023 12/18/2023 12/18/2023 12/18/2023 12/18/2023 12/18/2023 12/18/2023 12/18/2023 12/18/2023 12/18/2023 January 17, 2024 Regular Meeting Agenda Packet Date Range: 12/01/2023 - 12/31/2023 Payment Type Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Regular Total Regular: Discount Amount 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Payment Amount 8,418.60 828.00 1,047.00 2,496.39 690.00 4,028.40 180.00 500.00 228,233.40 584.11 3,559.34 1,167,051.55 Number 10079 10080 10081 10082 10083 10084 10085 10086 10087 10088 10089 1/11/2024 1:07:41 PM Page 2 of 4 26 of 131 Check Report Vendor Number Payment Type: 3197 3113 3124 3197 3113 3124 Vendor Name Bank Draft BenefitMall TCDRS IRS Tax Payment BenefitMall TCDRS IRS Tax Payment Payment Type Regular Checks Manual Checks Voided Checks Bank Drafts EFT's January 17, 2024 Regular Meeting Agenda Packet Date Range: 12/01/2023 - 12/31/2023 Discount Amount Payment Amount Number Payment Date Payment Type 12/08/2023 12/31/2023 12/08/2023 12/22/2023 12/31/2023 12/22/2023 Bank Draft Bank Draft Bank Draft Bank Draft Bank Draft Bank Draft Total Bank Draft: Bank Code Prosperity Bank Summary Payable Count 94 0 0 6 0 100 Payment Count 63 0 1 6 0 70 Discount Payment 0.00 1,167,212.00 0.00 0.00 0.00 -160.45 0.00 46,770.04 0.00 0.00 0.00 1,213,821.59 0.00 266.67 DFT0000123 0.00 9,914.43 DFT0000124 0.00 13,391.92 DFT0000125 0.00 266.67 DFT0000126 0.00 10,038.11 DFT0000127 0.00 12,892.24 DFT0000128 0.00 46,770.04 1/11/2024 1:07:41 PM Page 3 of 4 27 of 131 Check Report January 17, 2024 Regular Meeting Agenda Packet Date Range: 12/01/2023 - 12/31/2023 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 94 63 0.00 1,167,212.00 Manual Checks 0 0 0.00 0.00 Voided Checks 0 1 0.00 -160.45 Bank Drafts 6 6 0.00 46,770.04 EFT's 0 0 0.00 0.00 100 70 0.00 1,213,821.59 Fund Summary Fund Name Period Amount 996 MUD Consolidated Cash 12/2023 1,213,821.59 1,213,821.59 1/11/2024 1:07:41 PM Page 4 of 4 28 of 131 January 17, 2024 Regular Meeting Agenda Packet FY 2024 Combined Financials YTD as of 12/31/2023 YTD Revenues • YTD Expenses Adopted Budget vs YTD Actuals Revenues & Expenses $2,671,103 $3,224,430 $14,423,933 $14,423,933 51,100 529,818 0% $514,579 16% 1 1% YTD Expenses By Departments YTD Expense- Water $1,790,529 $888,403 55% YTD Expense- WW 28% YTD Expense- Admin YTD Expense- BOD • YTD Expense- Non Dept Water Budget vs Actual 140,000,000 120,000,000 100,000,000 80,000,000 60,000,000 40,000,000 20,000,000 0 92,198,177 Oct Water Consumption Budget vs Actual 112,006,200 61,555,000 48,355,000 51,503,997 46,670,584 Budget Consumption—1—Actual Consumption Nov Dec 1,000,000,000 900,000,000 800,000,000 700,000,000 600,000,000 500,000,000 400,000,000 300,000,000 200,000,000 100,000,000 0 Adopted Budget Water Consumption Vs Actual Water Consumption 900,222,298 868.678,857 Total Water Consumption • Budgeted Water Consumption • Projected Water Consumption Presented by: Finance Department $1,000,000 5900,000 $800,000 $700,000 $600,000 5500,000 5400,000 5300,000 5200,000 $100,000 $0 Water Revenue Budget vs Actual $493,961 $554,257 s $413,727 Oct 3297,607 Budget Revenue --Actual Revenue Nov $272,019 Dec $6,000,000 55,000,000 $4,000,000 $3,000,000 52,000,000 51,000,000 $0 Adopted Budget Water Revenue Vs Projected Water Revenue $5,166,291 $5,626,525 $2,510,794 Total Water Revenue $2,990,721 • Budgeted Water Revenue • Projected Water Revenue Net Budgeted Water Revenue Minus Budgeted Expenses • Net Projected Water Revenue Minus Projected Expenses 29 of 131 Fund: 135 - MUD 1 Ge Revenue Department: 000 - 135-000-40000-000 135-000-40002-000 135-000-40015-000 135-000-40025-000 135-000-47000-000 135-000-47005-000 135-000-47025-000 135-000-47030-000 135-000-47035-000 135-000-47045-000 135-000-47070-000 135-000-49011-000 135-000-49016-000 135-000-49026-000 135-000-49035-000 135-000-49036-000 135-000-49075-000 135-000-49141-000 135-000-49900-000 Trophy Club Municipal Utility District No. 1 neral Fund Revenue, Asset, Liability, & Equity Property Taxes Property Taxes/Delinquent Property Taxes/P & I PID Surcharges Water Sewer Penalties Service Charges Plumbing Inspections Sewer Inspections TCCC Effluent Charges Interest Income Cell Tower Revenue Proceeds from Sale of Assets Prior Year Reserves GASB Reserves Oversize Meter Reimbursement Interfund Transfer In Miscellaneous Income Department: 000 - Revenue, Asset, Liability, & Equity Total: Expense Department: 010 - Water 135-010-50005-000 135-010-50010-000 135-010-50016-000 135-010-50017-000 135-010-50020-000 135-010-50026-000 135-010-50027-000 135-010-50028-000 135-010-50029-000 135-010-50030-000 135-010-50035-000 135-010-50040-000 135-010-50045-000 135-010-50060-000 135-010-50070-000 135-010-55080-000 135-010-55085-000 135-010-55090-000 135-010-55105-000 135-010-55120-000 135-010-55135-000 135-010-55135-001 135-010-60010-000 135-010-60020-000 135-010-60066-000 135-010-60080-000 January 17, 2024 Regular Meeting Agenda Packet Original Current Total Budget Total Budget 85,733.51 300.00 300.00 143,223.25 6,939,998.00 3,679,786.00 105,800.00 3,350.00 300.00 100.00 70,000.00 150,000.00 49,320.00 25,000.00 1,933,264.00 50,000.00 2,058.00 1,178,400.00 7,000.00 14,423,932.76 85,733.51 300.00 300.00 143,223.25 6,939,998.00 3,679,786.00 105,800.00 3,350.00 300.00 100.00 70,000.00 150,000.00 49,320.00 25,000.00 1,933,264.00 50,000.00 2,058.00 1,178,400.00 7,000.00 14,423,932.76 Budget Report Account Summary For Fiscal: 2023-2024 Period Ending: 12/31/2023 Period Activity 39,740.28 -39.07 3.37 0.00 413,726.80 298,222.57 15,399.02 400.00 300.00 100.00 470.40 40,713.97 4,120.00 0.00 0.00 0.00 856.00 0.00 0.00 814,013.34 Variance Fiscal Favorable Percent Activity (Unfavorable) Remaining 43,258.00 65.66 38.14 0.00 1,584,117.97 859,106.92 32,450.86 1,650.00 450.00 100.00 14,781.60 121,559.76 12,240.00 0.00 0.00 0.00 1,284.00 0.00 0.00 2,671,102.91 -42,475.51 -234.34 -261.86 -143,223.25 -5,355,880.03 -2,820,679.08 -73,349.14 -1,700.00 150.00 0.00 -55,218.40 -28,440.24 -37,080.00 -25,000.00 -1,933,264.00 -50,000.00 -774.00 -1,178,400.00 -7,000.00 -11,752,829.85 49.54 78.11 % 87.29 100.00 % 77.17 76.65 % 69.33 50.75 % 150.00 % 0.00 % 78.88 % 18.96 % 75.18 % 100.00 % 100.00 % 100.00 % 37.61 % 100.00 % 100.00 % 81.48% Revenue Total: 14,423,932.76 14,423,932.76 814,013.34 2,671,102.91 -11,752,829.85 81.48% Salaries & Wages Overtime Longevity Certification Retirement Medical Insurance Dental lnsurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations Maintenance & Repairs Generator Maint. and Repair Vehicle Maintenance Maintenance-Backhoe/SkidLoader Cleaning Services Lab Analysis Lab Analysis for PID Communications/Mobiles Electricity Publications/Books/Subscripts Schools & Training 431,575.02 431,575.02 17,000.00 17,000.00 6,252.50 6,252.50 3,600.00 3,600.00 56,730.41 56,730.41 116,527.50 116,527.50 4,834.55 4,834.55 1,051.01 1,051.01 4,000.00 4,000.00 28,422.51 28,422.51 6,647.20 6,647.20 1,260.00 1,260.00 11,898.56 11,898.56 400.00 400.00 300.00 300.00 201,500.00 201,500.00 2,000.00 2,000.00 5,000.00 5,000.00 1,000.00 1,000.00 2,500.00 2,500.00 7,500.00 7,500.00 2,000.00 2,000.00 7,500.00 7,500.00 183,143.49 183,143.49 1,000.00 1,000.00 2,630.00 2,630.00 33,845.44 658.44 0.00 225.00 4,167.48 8,444.02 350.33 71.27 286.69 2,087.99 488.31 0.00 1,060.94 0.00 0.00 5,569.85 0.00 0.00 0.00 0.00 220.00 0.00 334.77 14,805.45 0.00 1,550.00 92,467.61 3,075.97 6,252.50 675.00 13,273.65 25,332.06 1,050.99 213.87 864.07 6,182.81 1,445.96 0.00 3,182.82 0.00 0.00 13,247.83 951.60 953.90 1,911.94 40.31 1,434.00 574.00 1,004.41 34,019.68 0.00 1,663.75 339,107.41 13,924.03 0.00 2,925.00 43,456.76 91,195.44 3,783.56 837.14 3,135.93 22,239.70 5,201.24 1,260.00 8,715.74 400.00 300.00 188,252.17 1,048.40 4,046.10 -911.94 2,459.69 6,066.00 1,426.00 6,495.59 149,123.81 1,000.00 966.25 78.57 % 81.91 % 0.00 % 81.25 % 76.60 % 78.26 % 78.26 % 79.65 % 78.40 % 78.25 % 78.25 % 100.00 % 73.25 % 100.00 % 100.00 % 93.43 % 52.42 % 80.92 % -91.19 % 98.39 % 80.88 % 71.30 % 86.61 % 81.42 % 100.00 % 36.74 % 1/11/2024 3:56:33 PM 30 of 131 Budget Report 135-010-60100-000 135-010-60135-000 135-010-60135-001 135-010-60150-000 135-010-60285-000 135-010-60332-000 135-010-65005-000 135-010-65010-000 135-010-65030-000 135-010-65050-000 135-010-65053-000 135-010-69005-000 135-010-69195-000 January 17, 2024 Regular Meeting Agenda Packet For Fiscal: 2023-2024 Period Ending: 12/31/2023 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining Travel & per diem 577.50 577.50 590.44 590.44 -12.94 -2.24 % TCEQ Fees & Permits 29,500.00 29,500.00 0.00 8,964.55 20,535.45 69.61 TCEQ Fees & Permits for PID 500.00 500.00 0.00 0.00 500.00 100.00 % Wholesale Water 2,655,497.13 2,655,497.13 166,425.88 420,386.84 2,235,110.29 84.17 % Lawn Equipment & Maintenance 12,500.00 12,500.00 1,200.00 2,400.00 10,100.00 80.80 % Interfund Transfer Out -Rev I&S 565,796.88 565,796.88 51,500.52 154,501.56 411,295.32 72.69 Fuel & Lube 23,575.00 23,575.00 995.20 4,275.56 19,299.44 81.86 % Uniforms 4,355.00 4,355.00 415.96 725.86 3,629.14 83.33 % Chemicals 58,200.00 58,200.00 2,465.15 10,584.44 47,615.56 81.81 % Meter Expense 20,000.00 20,000.00 0.00 0.00 20,000.00 100.00 % Meter Change Out Program 124,500.00 124,500.00 0.00 0.00 124,500.00 100.00 % Capital Outlays 4,200,000.00 4,200,000.00 96,367.82 599,622.39 3,600,377.61 85.72 % GASB Reserve for Replacement 378,659.00 378,659.00 0.00 378,659.00 0.00 0.00 % Department: 010 - Water Total: 9,179,933.26 9,179,933.26 394,126.95 1,790,529.37 7,389,403.89 80.50% Department: 020 - Wastewater 135-020-50005-000 Salaries & Wages 290,304.62 290,304.62 18,286.05 50,768.76 239,535.86 82.51 % 135-020-50010-000 Overtime 20,000.00 20,000.00 618.50 2,809.51 17,190.49 85.95 % 135-020-50016-000 Longevity 2,367.50 2,367.50 0.00 2,540.00 -172.50 -7.29 % 135-020-50017-000 Certification 5,100.00 5,100.00 225.00 675.00 4,425.00 86.76 % 135-020-50020-000 Retirement 40,934.05 40,934.05 2,295.54 7,336.22 33,597.83 82.08 % 135-020-50026-000 Medical Insurance 93,222.04 93,222.04 4,503.48 13,510.44 79,711.60 85.51 % 135-020-50027-000 Dental Insurance 3,385.28 3,385.28 166.51 499.53 2,885.75 85.24 % 135-020-50028-000 Vision Insurance 818.82 818.82 42.52 127.56 691.26 84.42 % 135-020-50029-000 Life Insurance & Other 3,000.00 3,000.00 148.16 506.78 2,493.22 83.11 % 135-020-50030-000 Social Security Taxes 20,507.87 20,507.87 1,138.15 3,393.82 17,114.05 83.45 % 135-020-50035-000 Medicare Taxes 4,796.20 4,796.20 266.18 793.69 4,002.51 83.45 % 135-020-50040-000 Unemployment Taxes 1,008.00 1,008.00 0.00 0.00 1,008.00 100.00 % 135-020-50045-000 Workman's Compensation 8,403.61 8,403.61 748.93 2,246.79 6,156.82 73.26 % 135-020-50060-000 Pre-emp Physicals/Testing 400.00 400.00 0.00 0.00 400.00 100.00 % 135-020-50070-000 Employee Relations 300.00 300.00 0.00 0.00 300.00 100.00 % 135-020-55080-000 Maintenance & Repairs 137,000.00 137,000.00 17,274.50 39,877.25 97,122.75 70.89 % 135-020-55081-000 Mainten & Repairs Collections 270,000.00 270,000.00 320.00 37,843.99 232,156.01 85.98 % 135-020-55085-000 Generator Maint. and Repair 11,000.00 11,000.00 4,678.06 6,478.06 4,521.94 41.11 % 135-020-55090-000 Vehicle Maintenance 4,600.00 4,600.00 0.00 142.94 4,457.06 96.89 % 135-020-55091-000 Veh Maintenance Collections 13,000.00 13,000.00 40.75 3,347.76 9,652.24 74.25 % 135-020-55105-000 Maintenance-Backhoe/SkidLoader 3,000.00 3,000.00 0.00 1,374.77 1,625.23 54.17 % 135-020-55120-000 Cleaning Services 2,000.00 2,000.00 0.00 40.31 1,959.69 97.98 % 135-020-55125-000 Dumpster Services 100,000.00 100,000.00 0.00 13,238.50 86,761.50 86.76 % 135-020-55135-000 Lab Analysis 55,000.00 55,000.00 6,271.20 19,748.02 35,251.98 64.09 % 135-020-60010-000 Communications/Mobiles 7,500.00 7,500.00 200.92 602.70 6,897.30 91.96 % 135-020-60020-000 Electricity 242,978.33 242,978.33 21,767.03 44,007.86 198,970.47 81.89 % 135-020-60080-000 Schools & Training 2,119.00 2,119.00 425.00 425.00 1,694.00 79.94 % 135-020-60100-000 Travel & per diem 527.50 527.50 0.00 0.00 527.50 100.00 % 135-020-60135-000 TCEQ Fees & Permits 12,000.00 12,000.00 0.00 9,888.02 2,111.98 17.60 % 135-020-60285-000 Lawn Equipment & Maintenance 16,000.00 16,000.00 1,420.00 2,720.00 13,280.00 83.00 % 135-020-60331-000 Interfund Transfer Out -Tax I&S 115,885.76 115,885.76 10,535.09 31,605.27 84,280.49 72.73 % 135-020-60332-000 Interfund Transfer Out -Rev I&S 698,542.63 698,542.63 63,548.65 190,645.95 507,896.68 72.71 % 135-020-65005-000 Fuel & Lube 13,000.00 13,000.00 527.55 5,782.03 7,217.97 55.52 % 135-020-65010-000 Uniforms 3,520.00 3,520.00 441.02 581.90 2,938.10 83.47 % 135-020-65030-000 Chemicals 32,500.00 32,500.00 0.00 2,664.09 29,835.91 91.80 % 135-020-65031-000 Chemicals Collections 10,000.00 10,000.00 0.00 0.00 10,000.00 100.00 % 135-020-65045-000 Lab Supplies 33,000.00 33,000.00 0.00 16,970.67 16,029.33 48.57 % 135-020-69005-000 Capital Outlays 1,050,000.00 1,050,000.00 3,909.10 219,448.10 830,551.90 79.10 % 135-020-69008-000 Short Term Debt -Principal 22,398.34 22,398.34 0.00 0.00 22,398.34 100.00 % 135-020-69009-000 Short Term Debt -Interest 442.39 442.39 0.00 0.00 442.39 100.00 % 135-020-69195-000 GASB Reserve for Replacement 155,762.00 155,762.00 0.00 155,762.00 0.00 0.00 % Department: 020 - Wastewater Total: 3,506,323.94 3,506,323.94 159,797.89 888,403.29 2,617,920.65 74.66% 1/11/2024 3:56:33 PM 31 of 131 Budget Report Department: 026 - Board of Directors 135-026-50045-000 Workman's Compensation 135-026-60070-000 Dues & Memberships 135-026-60075-000 Meetings 135-026-60080-000 Schools & Training 135-026-60100-000 Travel & per diem 135-026-60245-000 Miscellaneous Expenses Department: 026 - Board of Directors Total: Department: 030 - Administration 135-030-50005-000 Salaries & Wages 135-030-50010-000 Overtime 135-030-50016-000 Longevity 135-030-50020-000 Retirement 135-030-50026-000 Medical Insurance 135-030-50027-000 Dental lnsurance 135-030-50028-000 Vision Insurance 135-030-50029-000 Life Insurance & Other 135-030-50030-000 Social Security Taxes 135-030-50035-000 Medicare Taxes 135-030-50040-000 Unemployment Taxes 135-030-50045-000 Workman's Compensation 135-030-50060-000 Pre-emp Physicals/Testing 135-030-50070-000 Employee Relations 135-030-55030-000 Software & Support 135-030-55080-000 Maintenance & Repairs 135-030-55085-000 Generator Maint. and Repair 135-030-55120-000 Cleaning Services 135-030-55160-000 Professional Outside Services 135-030-55205-000 Utility Billing Contract 135-030-60005-000 Telephone 135-030-60010-000 Communications/Mobiles 135-030-60020-000 Electricity/Gas 135-030-60025-000 Water 135-030-60035-000 Postage 135-030-60040-000 Service Charges & Fees 135-030-60050-000 Bad Debt Expense 135-030-60055-000 Insurance 135-030-60070-000 Dues & Memberships January 17, 2024 Regular Meeting Agenda Packet For Fiscal: 2023-2024 Period Ending: 12/31/2023 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining 15.00 750.00 1,500.00 4,000.00 5,000.00 500.00 15.00 750.00 1,500.00 4,000.00 5,000.00 500.00 11,765.00 11,765.00 663,185.25 2,000.00 2,532.50 82,631.07 108,759.00 3,816.74 886.17 4,800.00 41,398.50 9,681.91 1,512.00 1,597.19 500.00 4,000.00 130,311.00 23,000.00 1,000.00 13,825.00 100,000.00 9,000.00 6,000.00 3,000.00 17,684.51 5,000.00 30,000.00 140,000.00 13,000.00 116,158.22 6,800.00 663,185.25 2,000.00 2,532.50 82,631.07 108,759.00 3,816.74 886.17 4,800.00 41,398.50 9,681.91 1,512.00 1,597.19 500.00 4,000.00 130,311.00 23,000.00 1,000.00 13,825.00 100,000.00 9,000.00 6,000.00 3,000.00 17,684.51 5,000.00 30,000.00 140,000.00 13,000.00 116,158.22 6,800.00 0.66 0.00 115.99 0.00 0.00 0.00 116.65 51,393.43 134.41 0.00 6,138.57 6,755.22 241.48 55.33 252.58 2,565.10 716.27 0.00 139.51 0.00 2,859.44 25,490.40 2,732.73 0.00 1,200.00 430.00 672.73 546.98 48.26 1,293.36 336.18 1,988.30 26,979.32 0.00 9,618.44 794.00 1.98 750.00 347.97 0.00 0.00 0.00 13.02 0.00 1,152.03 4,000.00 5,000.00 500.00 86.80 % 0.00 76.80 % 100.00 100.00 % 100.00 % 1,099.95 10,665.05 90.65% 141,118.53 205.35 2,597.50 18,592.97 20,265.66 724.44 166.05 1,147.68 8,081.78 2,006.48 0.00 418.53 0.00 2,859.44 92,253.57 2,732.73 1,348.04 3,374.70 73,120.30 1,964.89 1,465.64 144.78 2,537.88 1,153.51 7,460.92 63,483.65 0.00 28,855.32 1,285.00 522,066.72 1,794.65 -65.00 64,038.10 88,493.34 3,092.30 720.12 3,652.32 33,316.72 7,675.43 1,512.00 1,178.66 500.00 1,140.56 38,057.43 20,267.27 -348.04 10,450.30 26,879.70 7,035.11 4,534.36 2,855.22 15,146.63 3,846.49 22,539.08 76,516.35 13,000.00 87,302.90 5,515.00 78.72 % 89.73 % -2.57 % 77.50 % 81.37 % 81.02 % 81.26 % 76.09 % 80.48 % 79.28 % 100.00 % 73.80 % 100.00 % 28.51 % 29.21 % 88.12 % -34.80 % 75.59 % 26.88 % 78.17 % 75.57 % 95.17 % 85.65 % 76.93 % 75.13 % 54.65 % 100.00 % 75.16 % 81.10 % 135-030-60080-000 Schools & Training 3,900.00 3,900.00 800.00 1,313.10 2,586.90 66.33 % 135-030-60100-000 135-030-60115-000 135-030-60285-000 135-030-60360-000 135-030-65010-000 135-030-65055-000 135-030-65085-000 135-030-65095-000 135-030-69170-000 135-030-69195-000 Travel & per diem 1,227.50 1,227.50 0.00 0.00 1,227.50 100.00 % Elections 10,000.00 10,000.00 0.00 0.00 10,000.00 100.00 % Lawn Equipment & Maintenance 5,000.00 5,000.00 939.34 1,409.01 3,590.99 71.82 % Furniture/Equipment < $5000 3,000.00 3,000.00 0.00 0.00 3,000.00 100.00 % Uniforms 530.00 530.00 0.00 0.00 530.00 100.00 % Hardware 8,200.00 8,200.00 0.00 2,476.46 5,723.54 69.80 % Office Supplies 5,000.00 5,000.00 383.75 1,650.77 3,349.23 66.98 % Maintenance Supplies 5,000.00 5,000.00 812.41 2,784.80 2,215.20 44.30 % Copier Lease Installments 4,000.00 4,000.00 124.78 676.67 3,323.33 83.08 % GASB Reserve for Replacement 24,903.00 24,903.00 0.00 24,903.00 0.00 0.00 % Department: 030 - Administration Total: 1,612,839.56 1,612,839.56 146,442.32 514,579.15 1,098,260.41 68.09% Department: 039 - Non Departmental 135-039-55045-000 Legal 65,000.00 65,000.00 6,191.15 11,766.20 53,233.80 81.90 % 135-039-55055-000 Auditing 30,000.00 30,000.00 5,500.00 10,000.00 20,000.00 66.67 % 135-039-55060-000 Appraisal 13,071.00 13,071.00 1,967.85 4,110.57 8,960.43 68.55 % 1/11/2024 3:56:33 PM 32 of 131 Tax Admin Fees 5,000.00 5,000.00 3,941.00 3,941.00 1,059.00 21.18 Department: 039 - Non Departmental Total: 113,071.00 113,071.00 17,600.00 29,817.77 83,253.23 73.63% Budget Report January 17, 2024 Regular Meeting Agenda Packet For Fiscal: 2023-2024 Period Ending: 12/31/2023 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining 135-039-55065-000 Expense Total: 14,423,932.76 14,423,932.76 718,083.81 3,224,429.53 11,199,503.23 77.65% Fund: 135 - MUD 1 General Fund Surplus (Deficit): 0.00 0.00 95,929.53 -553,326.62 -553,326.62 0.00% Report Surplus (Deficit): 0.00 0.00 95,929.53 -553,326.62 -553,326.62 0.00% 1/11/2024 3:56:33 PM 33 of 131 Department Trophy Club Municipal Utility District No. 1 Asset 000 - Revenue, Asset, Liability, & Equity Liability 000 - Revenue, Asset, Liability, & Equity Total Asset: Total Liability: Equity 000 - Revenue, Asset, Liability, & Equity Total Total Beginning Equity: Total Revenue Total Expense Revenues Over/Under Expenses Total Equity and Current Surplus (Deficit): Total Liabilities, Equity and Current Surplus (Deficit): January 17, 2024 Regular Meeting Agenda Packet Balance Sheet Funds 122 - 528 Account Summary As Of 12/31/2023 122 - Trophy Club 135 - MUD 1 137 - MUD 1 519 - 2016 Rev 520 - Revenue 528 - 2015 MUD Fire Dept. General Fund Consolidated Bond Const- Bond 16" Revenue Bond GASB SWIFT Waterline Reserve Fund 1,704,677.66 1,704,677.66 11,220,355.35 3,898,890.58 911,784.38 1,195,080.37 11,220,355.35 3 898,890.58 911,784.38 1,195,080.37 955,147.53 955,147.53 656,464.88 656,464.88 766,150.10 1,066,110.87 0.00 81,691.15 0.00 1,066,110.87 0.00 81,691.15 0.00 10,707,571.10 3,258,146.58 735,325.73 1,179,058.79 766,150.10 668,482.72 386,420.04 282,062.68 1,048,212.78 1,704,677.66 0.00 0.00 942,342.55 10,707,571.10 3,258,146.58 735,325.73 1,179,058.79 2,671,102.91 640,744.00 9,715.58 16,021.58 3,224,429.53 0.00 -85,051.92 0.00 -553,326.62 640,744.00 94,767.50 16,021.58 10,154,244.48 3,898,890.58 830,093.23 1,195,080.37 11,220,355.35 3 898 890.58 911,784.38 1,195,080.37 Monthly Financial Activity Footnotes: 942,342.55 12,804.98 0.00 12,804.98 955,147.53 955,147.53 Total 19,885,935.87 19 885,935.87 1,804,266.90 1,804,266.90 17,588,594.85 17,588,594.85 4,018,871.77 3,525,797.65 493,074.12 18,081,668.97 19,885,935.87 Fund 122 Activity • Daily property tax deposits Monthly transfer OUT to MUD General Fund to cover Town transfers and any other A/P expenses Fund 135 Activity • Daily property tax deposits All A/P checks are cut through the General Fund Monthly transfer IN to cover other fund A/P expenses Monthly transfer OUT for I&S Revenue Bond payments for Fund 534, 535, & 536 Monthly bank interest Fund 137 Activity • Transfer IN at beginning of fiscal year based on yearly budget and transfer OUT at fiscal year-end based on reserves balances Fund 519 Activity • Monthly bank interest Fund 520 Activity • Transfer OUT to MUD General Fund to cover Interconnect Waterline construction project expenses Monthly bank interest Fund 528 Activity • Monthly bank interest 1/11/2024 4:07:36 PM 34 of 131 Page 1 of 1 Department Trophy Club Municipal Utility District No. 1 533 - MUD 1 I&S 534 - 2015 535 - 2016 Rev 536 - 2019 Rev Consolidated Revenue Bond Bond I&S-SWIFT Bond I&S- I&S W&WW System January 17, 2024 Regular Meeting Agenda Packet Balance Sheet I&S Funds 533 - 536 Account Summary As Of 12/31/2023 Total Asset 000 - Revenue, Asset, Liability, & Equity 341,308.52 207,364.13 86,973.06 110,746.79 746,392.50 Total Asset: 341,308.52 207,364.13 86,973.06 110,746.79 746,392.50 Liability 000 - Revenue, Asset, Liability, & Equity 107,922.76 0.00 0.00 0.00 107,922.76 Total Liability: 107,922.76 0.00 0.00 0.00 107,922.76 Equity 000 - Revenue, Asset, Liability, & Equity 89,219.04 39,137.14 11,713.62 6,476.05 146,545.85 Total Total Beginning Equity: 89,219.04 39,137.14 11,713.62 6,476.05 146,545.85 Total Revenue 144,166.72 168,226.99 75,259.44 104,270.74 491,923.89 Total Expense 0.00 0.00 0.00 0.00 0.00 Revenues Over/Under Expenses 144,166.72 168,226.99 75,259.44 104,270.74 491,923.89 Total Equity and Current Surplus (Deficit): 233,385.76 207,364.13 86,973.06 110,746.79 638,469.74 Total Liabilities, Equity and Current Surplus (Deficit): 341,308.52 207,364.13 86,973.06 110,746.79 746,392.50 Monthly Financial Activity Footnotes: Fund 533 Activity • Daily property tax deposits Monthly transfer IN from Fund 135 for PID portion of semi-annual GO Bond payments 3/1 & 9/1 GO Bond payments (Interest and Principal) Monthly bank interest Fund 534 Activity • Monthly transfer IN for semi-annual l&S Revenue Bond payment from Fund 533 3/1 & 9/1 Revenue Bond payments (Interest and Principal) Monthly bank interest Fund 535 Activity • Monthly transfer IN for semi-annual l&S Revenue Bond payment from Fund 533 3/1 & 9/1 Revenue Bond payments (Interest and Principal) Monthly bank interest Fund 536 Activity • Monthly transfer IN for semi-annual l&S Revenue Bond payment from Fund 533 3/1 & 9/1 Revenue Bond payments (Interest and Principal) Monthly bank interest 1/11/2024 4:11:06 PM 35 of 131 Page 1 of 1 January 17, 2024 Regular Meeting Agenda Packet CASH STATUS AS OF DECEMBER 2023 TexPool 0 & M (XXXXX0002)-Fire Operating Cash Restricted - Unable to be spent Unrestricted- Available for spending Total in Accounts (Restricted & Unrestricted) 1 35-1 02 50 TexPool 0 & M (XXXXX0002)-General Fund Operating *** Prosperity Bank (XXX8701) Fire Operating $0 $2,852,451 $2,852,451 1 35-1 03 00 Prosperity Bank (XXX8701) General Fund Operating * $146,080 $5,166,102 $5,312,182 1 35-1 03 05 Prosperity Bank Reserve -Savings Acct (XXXXX7724) $1,952,291 $0 $1,952,291 135-11100 Petty Cash Administration $0 $150 $150 1 35-1 11 50 Petty Cash Utility Billing $0 $450 $450 1 37-1 02 50 TexPool 0 & M (XXXXX0002) GASB Replacement $3,898,891 $0 $3,898,891 51 9-1 03 00 Prosperity Bank (XXX8701) SWIFT $85,052 $0 $85,052 51 9-111 55 Cash -Bond Escrow Bank of Texas (SWIFT) $826,732 $0 $826,732 520-1 02 50 Texpool Revenue Bond Water & Waste Water Systems 2019 (XXXXX018) $1,195,080 $0 $1,195,080 520-1 03 00 Prosperity Bank Construction Water & Waste Water Systems 2019 $0 $0 $0 528-1 02 50 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements $955,148 $0 $955,148 533-1 02 50 TexPool Tax I & S (XXXXX0003) $230,002 $0 $230,002 533-1 03 00 Prosperity Bank (XXX8701) Tax I&S $0 $0 $0 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements $207,364 $0 $207,364 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT $86,973 $0 $86,973 536-10250 TexPool Revenue I & S (XXXXX020) Water & Waste Water Systems $110,747 $0 $110,747 $8,019,153 $17,713,513 Amount available in cash for spending (MUD Accounts) *12/31/2023 Customer Water Deposits $146,080 Fire Department Cash $8,019,153 1 22-1 02 50 TexPool 0 & M (XXXXX0002)-Fire Operating Cash $0 $1,022,924 $1,022,924 1 22-1 03 00 Prosperity Bank (XXX8701) Fire Operating $0 $0 $0 $0 $1,022,924 $1,022,924 Amount available in cash for spending (Fire Department Accounts) $1,022,924 General Fund 135 Available $ 5,166,102 Prosperity General Fund $ 2,852,451 Texpool General Fund $ 600 Petty Cash Total General Fund 135 Available for Spending $ 8,019,153 General Fund 135 Fund Balances Nonspendable Fund Balance (Prepaids) $ 3,880 Assigned Fund Balance (FY2024 Capital Projects plus prior year carry forward) $ 6,516,007 Unassigned Fund Balance $ 4,187,684 Current Year Revenue/Expenses $ (553,327) Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 $10,154,244 36 of 131 ebills Bills Mailed Bank Draft Online Payments Late Notices Disconnects Connections MUD Connections Town January 17, 2024 Regular Meeting Agenda Packet December Utility Billing Report Fiscal Year 2023 - 2024 December 2022 January 2023 February 2023 March 2023 April 2023 May 2023 June 2023 July 2023 August 2023 September 2023 October 2023 November 2023 December 2023 1,746 1,765 1,777 1,773 1,767 1,794 1,766 1,750 1,744 1,742 1,745 1,740 1,737 3,768 3,741 3,751 3,744 3,743 3,734 3,755 3,749 3,747 3,747 3,737 3,739 3,742 630 606 599 599 590 588 589 585 578 572 569 562 567 2,251 2,540 2,719 3,016 2,998 2,754 3,134 3,101 2,957 3,086 3,072 3,006 3,133 0 0 547 413 289 290 327 327 268 344 255 298 342 0 0 0 0 8 9 9 13 7 7 13 4 5 3,399 3,394 3,394 3,394 3,394 3,394 3,395 3,395 3,395 3,395 3,395 3,395 3,395 1,444 1,444 1,443 1,443 1,443 1,443 1,443 1,443 1,443 1,443 1,444 1,444 1,446 December Permits Fiscal Year 2023 - 2024 Date of Permit Permit No. Customer Deposit Due to FW Water Oversize Meter Plumbing Inspections Sewer Inspections Fire Line Misc. Income Total 12/8/2023 2024-02 $ 100.00 $ 4,396.00 $ 428.00 $ 150.00 $ 50.00 $ - $ - $ 5,124.00 12/21/2023 2024-03 $ 100.00 $ 4,396.00 $ 428.00 $ 150.00 $ 50.00 $ - $ - $ 5,124.00 Total $ 200.00 $ 8,792.00 $ 856.00 $ 300.00 $ 100.00 $ - $ - $ 10,248.00 37 of 131 IWHEN EXPERIENCE, REPUTATION AND PERFORMANCE MATTER 1?3 PERDUE BRANDON FIELDERCOLLINS&MOTT LLP ATTORNEYS AT LAW January 17, 2024 Regular Meeting Agenda Packet COLLECTION REPORT TO THE TROPHY CLUB MUNICIPAL UTILITY DISTRICT No. 1 Submitted by: Alison Callison /Andrew Brink 500 East Border Street, Suite 640 Arlington, Texas 76010 www.pbfcm.com January 2024 2022 TAX YEAR ANALYSIS Delinquent Turnover Original Tax Levy Adj. Delinquent July 1, 2023 Turnover • $1,959,930 • $21,240 • 1.08% January 17, 2024 Regular Meeting Agenda Packet 0 • Collected • Delinquent 98.92% 1.08% Source: Denton County Tax ONcR,1'par-To-Date Summary Reports. 2 Perdue Brandon Fielder Collins & Mott, LLP January 17, 2024 Regular Meeting Agenda Packet It 2022 TAX YEAR - DELINQUENT COLLECTIONS N July 1, 2023 - December 31, 2023 Adj. July 1 Turnover Base Tax Collected Base Tax Remaining • $21,240 • $18,204 • 85.70% • $3,037 Base Tax Only - No Penalties or Interest Added $3,037 Collected $18,204 Source: Denton County Tax Office, Year -To -Date Summary Rep -.1Tcyrnover Accounts for Adjustments. Base Taxes Only - No Penalties or Interest Added. Perdue Brandon Fielder Collins & Mott, LLP January 17, 2024 Regular Meeting Agenda Packet P13 ACCOUNT BREAKDOWN CHART In Trust, $0.90, 0.0% In Bankruptcy, $122.63, 0.9% Action Pending, $2,862.58, 21.0% In Deferral, $7,593.25, 55.7% In Uncollectable, $1,595.50, 11.7% In Litigation, $1,449.45, 10.6% As of 1/3/2024 - Total Base Tax: $13,624 (2022 Tax Year & Prior) Action Pending Accounts: Notification Letters, Telephone CLRIgt qns, Lienholder Notification, Title Research, Property Inspection and Payment Agreements. Source: Perdue Brandon tape download on 4/5/23 from the Denton County Tax Office. January 17, 2024 Regular Meeting Agenda Packet it3 PERDUE BRANDON FIELDERCDLLINS&MDTT LLP ATTORNEYS AT LAW AUTHORITY ACTIVITY ANALYSIS TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1 As Of 1/2/2024, Tax Years Between 1997 And 2022 Description # Properties Pct Of Total Base Tax Amount Pct Of Total In Bankruptcy In Trust In Deferral In Litigation In Uncollectable Action Pending 1 2 3 4 18 38 1.52% 3.03% 4.55% 6.06% 27.27% 57.58% $122.63 $0.90 $7,593.25 $1,449.45 $1,595.50 $2,862.58 0.90% 0.01% 55.73% 10.64% 11.71% 21.01% Totals 66 100.00% $13,624.31 100.00% Dollar Range # Properties Pct Of Total Base Tax Amount Pct Of Total $0.01 - $100.00 $100.01 - $250.00 $250.01 - $500.00 $500.01 - $1000.00 $1000.01 - $2500.00 $2500.01 - $5000.00 Totals 46 6 6 1 2 1 62 74.19% 9.68% 9.68% 1.61% 3.23% 1.61% 100.00% $713.06 $1,085.92 $2,016.69 $755.92 $4,188.70 $4,864.02 $13,624.31 5.23% 7.97% 14.80% 5.55% 30.74% 35.70% 100.00% Year # Transaction Pct Of Total Base Tax Amount Pct Of Total 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 1 1 1 8 10 10 6 8 8 11 12 15 27 0.85% 0.85% 0.85% 6.78% 8.47% 8.47% 5.08% 6.78% 6.78% 9.32% 10.17% 12.71% 22.88% $414.60 $378.65 $295.79 $786.42 $858.30 $502.72 $485.70 $924.62 $1,283.95 $1,400.47 $1,584.57 $1,778.66 $2,929.86 3.04% 2.78% 2.17% 5.77% 6.30% 3.69% 3.56% 6.79% 9.42% 10.28% 11.63% 13.06% 21.50% Totals 118 100.00% $13,624.31 100.00% **Number of properties may differ in the first two sections because a property may reside in more than one category in the first section. 42 of 131 Top Tax Due Report Top 100 Percent Properties - TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1 GEO Code Legal Description January 17, 2024 Regular Meeting Agenda Packet Status LPBD 71012DEN TROPHY CLUB #10 LOT 1219 ACRES: 0.235000 DEFE D Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 968 BOREN BENJAMIN C & BEVERLY C N/A 2010-2021 $4,447.01 $6,341.92 71779DEN TROPHY CLUB # 2 LOT 77 ACRES: 0.253600 DEFE D Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 91176 PARROW JAMES J & ELENA N/A 2017-2021 $1,990.28 $2,371.81 650109DEN PERSONAL PROPERTY - DENTIST LOCATION: 925 TROPHY CLUB DR <none>,UP L Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 90829 MEMBERS ONLY DENTAL PA N/A 2018-2021 $1,476.01 $2,720.17 11514221TAR Taxpayer # 59 DIEGO'S TEX MEX KITCHEN PERSONAL PROPERTY TANGIBLE Taxpayer Name SUMMERS, JAMES M BKR,SUIT,UP Primary Phone Years Tax Due Total Due N/A 2013-2014 $455.51 $1,233.78 526096DEN CHURCHILL DOWNS BLK A LOT 1 ACRES: 0.258300 <none>,EMP,PPAY Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 895 SEAY MARK SR & TERRI N/A 2020 $318.84 $566.26 620602DEN PERSONAL PROPERTY - DENTIST OFFICE LOCAITON : 301 TROPHY LAKE <none>,SUIT Taxpayer # Taxpayer Name Primary Phone 1560 BURGAR BRANDON N/A L Years Tax Due Total Due 2013-2014 $310.41 $839.80 926478DEN PERSONAL PROPERTY - CHIROPRACTOR LOCATION : 100 TROPHY CLUB <none>,SUIT,UP Taxpayer # Taxpayer Name Primary Phone 1242 FORD LESLIE N/A L Years Tax Due Total Due 2013-2017 $297.77 $735.32 11514205TAR WEINBERGERS DELICATESSEN PERSONAL PROPERTY TANGIBLE <none>,SUIT,UP Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 58 WEINBERGER DELI TWO LLC N/A 2016-2019 $297.12 $619.02 339971DEN PERSONAL PROPERTY - AIRCRAFT CESSNA 150L 1972-N5428Q LOCATION : SUIT Taxpayer # Taxpayer Name Primary Phone 759 MORRISON AVIATION LLC N/A L Years Tax Due Total Due 2013-2021 $247.57 $551.96 71082DEN TROPHY CLUB #10 LOT 1249 ACRES: 0.286000 TPAY Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 93518 CULPEPPER LEE & ADRIANNE BEHR N/A 2021 $193.03 $315.03 676474DEN PERSONAL PROPERTY - DRY CLEANERS LOCATION: 2003 SH 114 STE 390 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 90856 J.A.E.H.K. INC N/A 2018-2021 $139.49 $257.56 72034DEN TROPHY CLUB # 4 LOT 333 ACRES: 0.361600 BKR,EMP Taxpayer # Taxpayer Name Primary Phone 1219 BINGHAM GENE C N/A B Years Tax Due Total Due 2021 $122.63 $200.13 42641576TAR KNOLLS AT SOLANA BLOCK B LOT 23 ACRES: 0.247900 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 93256 MAYA WALDEMAR N/A 2021 $91.87 $149.93 336817DEN PERSONAL PROPERTY - DRY CLEANERS DROP OFF LOCATION : 2003 SH UP Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 1164 WALJI SHANIF M N/A 2014-2015 $45.93 $117.67 14318755TAR DYNAMIC ACTION PERSONAL PROPERTY TANGIBLE COMMERCIAL <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 92920 DYNAMIC ACTION INC N/A 2021 $36.66 $59.83 633172DEN PERSONAL PROPERTY - AUDIOLOGISTS LOCATION: 501 TROPHY LAKE UP Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 1730 EARCARE HEARING AIDS N/A 2014-2015 $35.18 S90.13 469054DEN PERSONAL PROPERTY - RETAIL STORE LOCATION: 301 TROPHY LAKE DR UP Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 1184 VERIZON N/A 2013 $30.81 $85.78 14265180TAR FUSE ENERGY LLC PERSONAL PROPERTY TANGIBLE COMMERCIAL <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 91517 FUSE ENERGY LLC N/A 2021 $26.93 $43.95 563646DEN PERSONAL PROPERTY - MISC PERSONAL SERVICE LOCATION: 2003 SH UP Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 1711 STYLES OF INDIA N/A 2015-2016 $20.23 $48.93 499622DEN PERSONAL PROPERTY - HAIR SALON LOCATION: 2001 W SH 114, STE 150, UP Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 1530 DESIRE SALON & SPA N/A 2013 $16.51 $45.96 723199DEN PERSONAL PROPERTY - INSURANCE AGENT LOCATION: 2101 SH 114 STE <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 91433 MILLER CRAIG N/A 2019-2021 $14.45 $25.70 682747DEN PERSONAL PROPERTY - RESTAURANT LOCATION: 301 TROPHY LAKE DR <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 91619 7 MILES TASTE GROUP INC N/A 2019 $14.43 $27.71 43 of 131 Page 1 676479DEN PERSONAL PROPERTY - DANCE & MUSIC LESSONS LOCATION: 905 <none> Taxpayer # Taxpayer Name Pri 202Vnular McIlli eq endTdP��di'IF�et 90858 FULLER CHRISTINA N/A 2020-2021 $74.38 $24.52 13442112TAR HEART TEST LABORATORIES PERSONAL PROPERTY TANGIBLE UP Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 91068 HEART TEST LABORATORIES INC N/A 2017-2019 $12.32 $24.57 72303DEN TROPHY CLUB # 6 LOT 528 ACRES: 0.266100 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 91664 TABER JOHN K N/A 2020 $9.15 $15.59 659388DEN PERSONAL PROPERTY - BUSINESS SERVICES LOCATION: 99 TROPHY UP Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 91141 CHIP MUNDY INC N/A 2017 $4.85 $10.71 566115DEN PERSONAL PROPERTY - BUSINESS SERVICES LOCATION: 99 TROPHY UP Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 1555 DONNA & ASSOCIATES N/A 2013 $4.40 $12.25 679913DEN PERSONAL PROPERTY - OFFICE LOCATION: 99 TROPHY CLUB DR <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 91389 SMITH CLINICAL SERVICES PLLC N/A 2019 $4.31 $8.28 659398DEN PERSONAL PROPERTY - BUSINESS SERVICES LOCATION: 99 TROPHY UP Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 90372 RAY DERSTEIN N/A 2015 $3.61 $9.01 701746DEN PERSONAL PROPERTY - SPECIAL TRADE CONTRACTORS: 99 TROPHY <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 93483 GRAY CAROL N/A 2021 $3.50 $5.71 13730967TAR RANDSTAD RANDSTAD US LP PERSONAL PROPERTY TANGIBLE UP Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 90303 RANDSTAD US LP N/A 2014-2015 $2.76 $6.95 727270DEN PERSONAL PROPERTY - INSURANCE OFFICE LOCATION: 100 INDIAN <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 92609 FOLEY BEVERLY N/A 2020-2021 $1.98 $3.38 943642DEN PERSONAL PROPERTY - BUSINESS SVCS LOCATION: 100 INDIAN CREEK <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 91198 ERIC RANSLEBEN N/A 2021 $1.86 $3.04 314763DEN PERSONAL PROPERTY - LEASED EQUIPMENT <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 298 NORTHERN LEASING SYSTEMS INC N/A 2020 $0.68 $1.21 14461451TAR DELL MARKETING LP VARX COMMERCIAL UP Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 91207 DELL MARKETING LP N/A 2016 $0.61 $1.34 624324DEN A0821A J.R. MICHAEL TR 1A(2) .09 ACRES ACRES: 0.090000 E Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 1628 TROPHY CLUB TOWN OF N/A 2014 $0.48 $1.27 624325DEN A0821A J.R. MICHAEL TR 1A(3) .081 ACRES ACRES: 0.081000 E Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 1628 TROPHY CLUB TOWN OF N/A 2014 $0.42 $1.11 42345560TAR WESTLAKE ENTRADA BLOCK I LOT 13 REF PLAT D218192054 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 91351 JJP TREVI LLC N/A 2018 $0.19 $0.39 14381350TAR SONIFI SOLUTIONS INC VARX COMMERCIAL UP Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 1290 SONIFI SOLUTIONS INC N/A 2015 $0.15 $0.34 13661787TAR NATIONAL DEFAULT TITLE PERSONAL PROPERTY TANGIBLE UP Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 1638 NATIONAL DEFAULT TITLE SERVICE N/A 2017 $0.07 $0.15 14448870TAR NEOPOST USA INC VARX COMMERCIAL UP Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 91049 NEOPOST USA INC N/A 2015 $0.04 $0.09 198454DEN LAKES OF TROPHY CLUB PH 1 BLK 5 LOT 11 ACRES: 0.160300 <none>,QPAY Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 91092 VILORIA PHILIP A & JOANNE N/A 2019 $0.01 $0.02 308380DEN EAGLES RIDGE PH II BLK B LOT 5 ACRES: 0.305700 QPAY Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 91720 HAFIZ ARIF & FATIMA LIVING TRUST N/A 2020 $0.01 $0.02 44 of 131 Page 2 Top Tax Due Report Top 100 Percent Properties - TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1 January 17, 2024 Regular Meeting Agenda Packet GEO Code Legal Description Status LPBD 661454DEN CANTERBURY HILLS PHASE 3 BLK F LOT 20 ACRES: 0.278900 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 94052 HARRISON CARL O & KATRINA A N/A 2022 $755.92 $1,124.81 71012DEN TROPHY CLUB #10 LOT 1219 ACRES: 0.235000 DEFE D Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 968 BOREN BENJAMIN C & BEVERLY C N/A 2022 $417.01 $436.11 71779DEN TROPHY CLUB # 2 LOT 77 ACRES: 0.253600 DEFE D Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 91176 PARROW JAMES J & ELENA N/A 2022 $401.91 $420.32 40758281TAR TROPHY CLUB # 9 LOT 723 ACRES: 0.236200 DEFE D Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 93245 PARKER CHARLES 3 AND PARKER SYLVIA A N/A 2022 $337.04 $352.48 650109DEN PERSONAL PROPERTY - DENTIST LOCATION: 925 TROPHY CLUB DR <none>,UP L Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 90829 MEMBERS ONLY DENTAL PA N/A 2022 $320.50 $476.90 189787DEN LAKESIDE AT TROPHY CLUB BLK B LOT 1 ACRES: 0.229400 <none>,PPAY,TPAY Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 90619 WILLIAMS JEFFREY O & LARISSA N/A 2022 $212.08 $315.58 71140DEN TROPHY CLUB # 8 LOT 655 ACRES: 0.196700 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 94075 PAGE DAVID HOGAN & PAGE AARON COOPER N/A 2022 $90.43 $134.56 991023DEN PERSONAL PROPERTY - RESTAURANT LOCATION: 2550 BOBCAT BLVD <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 94160 MARCO'S PIZZA N/A 2022 $85.58 $127.34 42641576TAR KNOLLS AT SOLANA BLOCK B LOT 23 ACRES: 0.247900 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 93256 MAYA WALDEMAR N/A 2022 $79.25 $117.92 12705160TAR CAVOK SOLUTIONS PERSONAL PROPERTY TANGIBLE COMMERCIAL <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 91514 MERCER MANAGEMENT CONSULTING N/A 2022 $73.26 S109.01 14836446TAR COASTAL BROKERS INSURANCE INC PERSONAL PROPERTY TANGIBLE <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 93910 COASTAL BROKERS INSURANCE INC N/A 2022 $45.19 $67.24 722632DEN PERSONAL PROPERTY - MORTGAGE COMPANY LOCATION: 2550 BOBCAT <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 91431 IMAX MORTGAGE LLC N/A 2022 $23.34 $34.73 929538DEN PERSONAL PROPERTY - DONUT SHOP LOCATION: 301 TROPHY LAKE DR <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 112 HOT & CREAMY DONUTS N/A 2022 $23.11 534.39 14689532TAR CROSSFIT SPT PERSONAL PROPERTY TANGIBLE COMMERCIAL <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 92190 RUTLEDGE SHANNON AND GARNER KASIE N/A 2022 $20.41 $30.37 14345060TAR BROKER ONLINE EXCHANGE LLC PERSONAL PROPERTY TANGIBLE <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 93904 BROKER ONLINE EXCHANGE LLC N/A 2022 $10.85 $16.14 14265180TAR FUSE ENERGY LLC PERSONAL PROPERTY TANGIBLE COMMERCIAL <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 91517 FUSE ENERGY LLC N/A 2022 $10.43 $15.52 676479DEN PERSONAL PROPERTY - DANCE & MUSIC LESSONS LOCATION: 905 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 90858 FULLER CHRISTINA N/A 2022 $6.15 $9.15 776375DEN PERSONAL PROPERTY - ACCOUNTING AUDITING & BOOKKEEPING <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 92697 KENNETH ARMSTRONG N/A 2022 $5.61 $8.35 723199DEN PERSONAL PROPERTY - INSURANCE AGENT LOCATION: 2101 SH 114 STE <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 91433 MILLER CRAIG N/A 2022 $4.05 $6.03 701746DEN PERSONAL PROPERTY - SPECIAL TRADE CONTRACTORS: 99 TROPHY <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 93483 GRAY CAROL N/A 2022 $3.01 $4.48 676473DEN PERSONAL PROPERTY - PERSONAL TRAINER SERVICES LOCATION: 2003 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 90855 THE FORCE BY LUKE N/A 2022 $2.21 $3.29 14881042TAR CARDTRONICS USA INC VARX COMMERCIAL <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 93915 CARDTRONICS USA INC N/A 2022 $1.49 $2.22 45 of 131 Page 1 676477DEN PERSONAL PROPERTY - MEDICAL OFFICE LOCATION: 300 TROPHY CLUB <none> Taxpayer # Taxpayer Name P.LYifir7 20241Vgular MegAgendiPS&Lt 91387 TRUE MEDICINE PA N/A 022 $0.95 $1.41 70627DEN LAKE FOREST VILLAGE PH 3 LOT 91 ACRES: 0.280100 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 94068 FRANKLIN G HOYT JR & WANDA N/A 2022 $0.03 $0.04 71301DEN TROPHY CLUB # 9 LOT 764R (PT) (DENTON CO PART) ACRES: 0.006800 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 91417 WHITE VICTORIA N/A 2022 $0.02 $0.03 72533DEN TROPHY CLUB # 3 LOT 270 ACRES: 0.439000 <none>,QPAY,UP Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 1256 YOMINE DANIEL F & JULIA A N/A 2022 $0.02 $0.03 70726DEN TROPHY CLUB #11 LOT 1467 ACRES: 0.293800 <none>,QPAY Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 90912 RUANGSKUL VERONICA IND EXECUTOR FOR BOWO N/A 2022 $0.01 $0.01 46 of 131 Page 2 January 17, 2024 Regular Meeting Agenda Packet Deferral Detail Report Locator: Denton Tax Clients: Trophy Club MUD 1 TP # Taxpayer Name Base Due 93245 PARKER CHARLES J AND PARKER SYLVIA A GEO Code Client Name 40758281TAR Trophy Club MUD 1 Tax Year Status Tran Type Start Date End Date Condition Base Tax 2022 DEFE TAX 12/06/2021 12/01/2099 Defer $337.04 Property Base Due $337.04 Taxpayer Base Due $337.04 968 BOREN BENJAMIN C & BEVERLY C GEO Code Client Name Tax Year Status Tran Type Start Date End Date Condition Base Tax 71012DEN Trophy Club MUD 1 2010 DEFE TAX 06/30/2010 12/01/2099 Defer $414.60 71012DEN Trophy Club MUD 1 2011 DEFE TAX 06/30/2010 12/01/2099 Defer $378.65 71012DEN Trophy Club MUD 1 2012 DEFE TAX 06/30/2010 12/01/2099 Defer $295.79 71012DEN Trophy Club MUD 1 2013 DEFE TAX 06/30/2010 12/01/2099 Defer $300.56 71012DEN Trophy Club MUD 1 2014 DEFE TAX 06/30/2010 12/01/2099 Defer $325.30 71012DEN Trophy Club MUD 1 2015 DEFE TAX 06/30/2010 12/01/2099 Defer $355.07 71012DEN Trophy Club MUD 1 2016 DEFE TAX 06/30/2010 12/01/2099 Defer $367.89 71012DEN Trophy Club MUD 1 2017 DEFE TAX 06/30/2010 12/01/2099 Defer $385.38 71012DEN Trophy Club MUD 1 2018 DEFE TAX 06/30/2010 12/01/2099 Defer $380.30 71012DEN Trophy Club MUD 1 2019 DEFE TAX 06/30/2010 12/01/2099 Defer $404.59 71012DEN Trophy Club MUD 1 2020 DEFE TAX 06/30/2010 12/01/2099 Defer $401.84 71012DEN Trophy Club MUD 1 2021 DEFE TAX 06/30/2010 12/01/2099 Defer $437.04 71012DEN Trophy Club MUD 1 2022 DEFE TAX 06/30/2010 12/01/2099 Defer $417.01 Property Base Due $4,864.02 Taxpayer Base Due $4,864.02 91176 PARROW JAMES J & ELENA GEO Code Client Name Tax Year Status Tran Type Start Date End Date Condition Base Tax 71779DEN Trophy Club MUD 1 2017 DEFE TAX 11/03/2017 12/01/2099 Defer $335.57 71779DEN Trophy Club MUD 1 2018 DEFE TAX 11/03/2017 12/01/2099 Defer $412.53 71779DEN Trophy Club MUD 1 2019 DEFE TAX 11/03/2017 12/01/2099 Defer $416.50 71779DEN Trophy Club MUD 1 2020 DEFE TAX 11/03/2017 12/01/2099 Defer $404.55 71779DEN Trophy Club MUD 1 71779DEN Trophy Club MUD 1 2021 DEFE TAX 11/03/2017 12/01/2099 Defer $421.13 2022 DEFE TAX 11/03/2017 12/01/2099 Defer $401.91 Property Base Due $2,392.19 Taxpayer Base Due $2,392.19 Total Base Due $7,593.25 Page 1 of 1 47 of 131 Restricted/ Unrestricted Unrestricted- 135 Unrestricted- 122 Restricted- 519 Restricted- 533 Unrestricted- 135 Restricted- 122 Restricted- 137 Restricted- 533 Restricted- 534 Restricted- 528 Restricted- 519 Restricted- 535 Restricted- 520 Restricted- 536 Restricted Restricted- 519 EARNINGS SUMMARY Trophy Club Municipal Utility District No. 1 Quarterly Investment Report For Ending Period 12/31/2023 (October, November, and December) Account or CUSIP Checking & Money Market Accounts XXXX2660 XXXX2660 XXXX2660 XXXX2660 Pools & Funds XXXXX0002 XXXXX0003 XXXXX00013 XXXXX00014 XXXXX00015 XXXXX00017 XXXXX00018 XXXXX00020 Savings Accounts XXXXX7724 Escrow/ Treasuries 82-1747-01-1 CD'S US Agencies NONE NONE Sec Type Prosperity Bank Consolidated Cash -General Fund Prosperity Bank Consolidated Cash -Fire Dept Prosperity Bank Consolidated Cash -Tax SWIFT Prosperity Bank Consolidated Cash -Tax I&S TexPool Municipal Fund -Operating TexPool Municipal Fund -Fire Dept TexPool Municipal Fund -GASB Replacement TexPool Tax Debt Service Texpool Revenue Bond I&S Texpool Revenue Bond Reserve Texpool Revenue Bond Construction -SWIFT Texpool Revenue Bond I&S-SWIFT Texpool Revenue Bond Construction Series 2019 Texpool Revenue Bond I&S Series 2019 Prosperity Bank Cash Reserve- Money Mkt Revenue Bond Series 2016 Escrow- BOK Par $ 5,312,182 $ 85,052 $ 2,852,451 $ 1,022,924 $ 3,898,891 $ 230,002 $ 207,364 $ 955,148 $ 86,973 $ 1,195,080 $ 110,747 $ 1,952,291 $ 826,732 $ 18,735,837 Rate / Call Cou.on Maturi Date 0.000% N/A N/A 0.000% N/A N/A 0.000% N/A N/A 0.000% N/A N/A 0.000% N/A N/A 0.000% N/A N/A 0.000% N/A N/A 0.000% N/A N/A 0.000% N/A N/A 0.000% N/A N/A 0.000% N/A N/A 0.000% N/A N/A 0.000% N/A N/A 0.000% N/A N/A 0.000% N/A N/A Purchase Price 100.000 100.000 100.000 100.000 Yield % January 17, 2024 Regular Meeting Agenda Packet I certify that this Investment Report complies with requirements of TCMUD's Investment Policy and the Public Funds Act. Prepared By Investment Officer Steven Krolczyk DATE Alan Fourmentin DATE Beginning Book 9/30/2023 0.35% $ 0.35% $ 0.35% $ 0.35% $ Beginning Market 9/30/2023 Ending Book 12/31/2023 Ending Market 12/31/2023 Gain/Loss End MV -End BV 4,279,206 $ 4,279,206 $ 5,312,182 $ 5,312,182 0.00 12,305 $ 12,305 $ - $ - 0.00 - $ - $ 85,052 $ 85,052 0.00 - $ $ - $ - 0.00 100.000 5.38% $ 3,647,646 $ 3,647,646 $ 2,852,451 $ 2,852,451 0.00 100.000 5.38% $ 746,977 $ 746,977 $ 1,022,924 $ 1,022,924 0.00 100.000 5.38% $ 3,258,147 $ 3,258,147 $ 3,898,891 $ 3,898,891 0.00 100.000 5.38% $ 85,835 $ 85,835 $ 230,002 $ 230,002 0.00 100.000 5.38% $ 39,137 $ 39,137 $ 207,364 $ 207,364 0.00 100.000 5.38% $ 942,343 $ 942,343 $ 955,148 $ 955,148 0.00 100.000 5.38% $ - $ - $ - $ 0.00 100.000 5.38% $ 11,714 $ 11,714 $ 86,973 $ 86,973 0.00 100.000 5.38% $ 1,179,059 $ 1,179,059 $ 1,195,080 $ 1,195,080 0.00 100.000 5.38% $ 6,476 $ 6,476 $ 110,747 $ 110,747 0.00 100.000 3.20% $ 1,936,872 $ 1,936,872 $ 1,952,291 $ 1,952,291 0.00 4.77% $ 817,017 $ 817,017 $ 826,732 $ 826,732 0.00 $ 16,962,734 $ 16,962,734 $ 18,735,837 $ 18,735,837 $ Restricted/ Unrestricted Unrestricted- 135 Unrestricted- 122 Restricted- 519 Restricted- 533 Unrestricted- 135 Restricted- 533 Restricted- 534 Restricted- 528 Restricted- 519 Restricted- 535 Restricted- 520 Restricted- 536 Restricted Restricted- 519 Settle Date Sec Type Account Number Par Coupon Maturity Qtr. Accrued Qtr. Amort. Total Qtr. Earnings Checking & Money Market Accounts Pools & Funds Savings Accounts Escrows/ Treasuries CD'S NONE US Agencies NONE Prosperity Bank Consolidated Cash -General Fund Prosperity Bank Consolidated Cash -Fire Dept Prosperity Bank Consolidated Cash -SWIFT Prosperity Bank Consolidated Cash -Tax I&S TexPool Municipal Fund TexPool Tax Debt Service Texpool Revenue Bond I&S Texpool Revenue Bond Reserve Texpool Revenue Bond Construction -SWIFT Texpool Revenue Bond I&S-SWIFT Texpool Revenue Bond Construction Series 2019 Texpool Revenue Bond I&S Series 2019 Prosperity Bank Cash Reserve- Money Mkt Revenue Bond Series 2016 Escrow- BOK PAR for this report is the statement balance on the last day of the quarter XXXX2660 XXXX2660 XXXX2660 XXXX2660 XXXXX0002 XXXXX0003 XXXXX00013 XXXXX00014 XXXXX00015 XXXXX00017 XXXXX00018 XXXXX00020 XXXXX7724 $ 82-1747-01-1 $ 5,312,182 N/A N/A N/A N/A 85,052 N/A N/A N/A N/A 7,774,266 N/A N/A 230,002 N/A N/A 207,364 N/A N/A 955,148 N/A N/A - N/A N/A 86,973 N/A N/A 1,195,080 N/A N/A 110,747 N/A N/A 1,952,291 N/A N/A 826,732 N/A N/A 48 of 131 $ 4,680 $ 101,461 $ 1,523 $ 1,417 $ 12,805 $ 555 $ 16,022 $ 638 $ 15,419 $ 9,716 N/A $ 4,680 N/A $ N/A $ N/A $ N/A $ 101,461 N/A $ 1,523 N/A $ 1,417 N/A $ 12,805 NA $ - NA $ 555 NA $ 16,022 NA $ 638 N/A $ 15,419 N/A $ 9,716 $ 164,234 N/A $ 164,234 January 17, 2024 Regular Meeting Agenda Packet REGULAR MEETING MINUTES TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BOARD OF DIRECTORS December 13, 2023, at 6:30 p.m. Trophy Club Municipal Utility District No. 1 Board of Directors, of Denton and Tarrant Counties, met in a regular session meeting on December 13, 2023, at 6:30 p.m., in the Boardroom of the Administration Building, 100 Municipal Drive, Trophy Club, Texas 76262. The meeting was held within the boundaries of the District and was open to the public. STATE OF TEXAS COUNTIES OF DENTON AND TARRANT § BOARD MEMBERS PRESENT: Kevin R. Carr Ben Brewster Doug Harper William C. Rose STAFF PRESENT: Alan Fourmentin Laurie Slaght Mike McMahon Steven Krolczyk Emily Rodgers President Vice President Secretary/Treasurer via Zoom Director General Manager District Secretary Operations Manager Finance Manager General Legal Counsel CALL TO ORDER AND ANNOUNCE A QUORUM President Carr announced the date of December 13, 2023, called the meeting to order and announced a quorum present at 6:31 p.m. CITIZEN COMMENTS Jim Thomas 7 Meadowbrook Lane REPORTS & UPDATES 1. Staff Reports a. Capital Improvement Projects General Manager Alan Fourmentin presented the staff reports and answered questions related thereto. CONSENT AGENDA 2. Consider and act to approve the Consent Agenda. a. November 15, 2023, Regular Meeting minutes b. November 28, 2023, Special Meeting minutes Director Rose removed item a. November 15, 2023, Regular Meeting minutes for discussion. Motion made by Director Rose and seconded by Director Brewster to approve item b. November 28, 2023, meeting minutes. 49 of 131 January 17, 2024 Regular Meeting Agenda Packet Motion carried unanimously Motion made by Director Rose and seconded by Director Brewster to approve item a. November 15, 2023, meeting minutes as amended at the dais. Motion carried unanimously The Board convened into Executive Session at 6:46 p.m. EXECUTIVE SESSION 3. Pursuant to Section 551.071 of the Texas Open Meetings Act, the Board may consult with its attorney in Executive Session on a matter in which the duty of the attorney to the Governmental Body under the Disciplinary Rules of Professional Conduct of the State Bar of Texas clearly conflicts with the Open Meetings Act or to seek advice of counsel on legal matters involving pending or contemplated litigation or settlement offers: a. Deliberations pursuant to Section 551.074(a)(1) of the Texas Open Meetings Act regarding appointment, employment, evaluation, reassignment, duties, discipline, or dismissal of a public officer or employee: Appointment of Director. The Board reconvened into Regular Session at 7:32 p.m. REGULAR SESSION 4. Consider and act to appoint a Director to Place 3 for a term ending in May of 2026. Motion made by Director Brewster and seconded by Director Rose to appoint Jim Thomas to Place 3 for the remainder of the term ending in May of 2026. Motion carried unanimously 5. Consider and take appropriate action to appoint two (2) directors to serve on the Audit Committee. Discussion only, no action taken. 6. Items for future agendas: Audit report 7. Next Regular Meeting date—January 17, at 6:30 p.m. ADJOURN President Carr called the meeting adjourned at 7:46 p.m. 50 of 131 Kevin R. Carr, President Doug Harper, Secretary/Treasurer Laurie Slaght, District Secretary 51 of 131 January 17, 2024 Regular Meeting Agenda Packet (SEAL) January 17, 2024 Regular Meeting Agenda Packet Rod L. Abbott, CPA PLLC Certified Public Accountant January 17, 2024 To the Board of Directors of Trophy Club Municipal Utility District No. 1 Trophy Club, Texas I have audited the financial statements of the governmental activities, each major fund, and the aggregate remaining fund information of the Trophy Club Municipal Utility District No. 1 (the "District") for the year ended September 30, 2023. Professional standards require that I provide you with information about my responsibilities under generally accepted auditing standards, as well as certain information related to the planned scope and timing of my audit. I have communicated such information in my letter to you dated July 15, 2022. Professional standards also require that I communicate to you the following information related to my audit. Significant Audit Matters Qualitative Aspects of Accounting Practices Management is responsible for the selection and use of appropriate accounting policies. The significant accounting policies used by the District are described in Note 1 to the financial statements. No new accounting policies were adopted and the application of existing policies was not changed during the year ended September 30, 2023. I noted no transactions entered into by the District during the year for which there is a lack of authoritative guidance or consensus. All significant transactions have been recognized in the financial statements in the proper period. Accounting estimates are an integral part of the financial statements prepared by management and are based on management's knowledge and experience about past and current events and assumptions about future events. Certain accounting estimates are particularly sensitive because of their significance to the financial statements and because of the possibility that future events affecting them may differ significantly from those expected. The most sensitive estimate affecting the government -wide financial statements was: Management's estimate of the useful lives of long-term assets for which to base depreciation expense. The District's estimates are based on prior experience with actual useful lives performance for District infrastructure, equipment, and other assets. I evaluated the key factors and assumptions used to develop the useful lives estimates in determining that they are reasonable in relation to the financial statements taken as a whole. The financial statement disclosures are neutral, consistent, and clear. Difficulties Encountered in Performing the Audit I encountered no significant difficulties in dealing with management in performing and completing my audit. Corrected and Uncorrected Misstatements Professional standards require me to accumulate all misstatements identified during the audit, other than those that are clearly trivial, and communicate them to the appropriate level of management. Management has corrected all material and immaterial misstatements as shown at Attachment 1. P.O. Box 75 Tom Bean, TX. 75489 (214) 856-9603 rodabbottcpa@hotmail.com 52 of 131 January 17, 2024 Regular Meeting Agenda Packet Disagreements with Management For purposes of this letter, a disagreement with management is a financial accounting, reporting, or auditing matter, whether or not resolved to my satisfaction, that could be significant to the financial statements or the auditor's report. I am pleased to report that no such disagreements arose during the course of my audit. Management Representations I have requested certain representations from management that are included in the management representation letter dated January 17, 2024. Management Consultations with Other Independent Accountants In some cases, management may decide to consult with other accountants about auditing and accounting matters, similar to obtaining a "second opinion" on certain situations. If a consultation involves application of an accounting principle to the District's financial statements or a determination of the type of auditor's opinion that may be expressed on those statements, my professional standards require the consulting accountant to check with me to determine that the consultant has all the relevant facts. To my knowledge, there were no such consultations with other accountants. Other Audit Findings or Issues I generally discuss a variety of matters, including the application of accounting principles and auditing standards, with management each year prior to retention as the District's auditor. However, these discussions occurred in the normal course of my professional relationship and my responses were not a condition to my retention. Other Matters I applied certain limited procedures to management's discussion and analysis, the General Fund's budget versus actual schedule, and the TCDRS pension and OPEB schedules, which are required supplementary information (RSI) that supplements the basic financial statements. My procedures consisted of inquiries of management regarding the methods of preparing the information and comparing the information for consistency with management's responses to my inquiries, the basic financial statements, and other knowledge I obtained during my audit of the basic financial statements. I did not audit the RSI and do not express an opinion or provide any assurance on the RSI. I was engaged to report on the individual schedules and other supplementary information required by the Texas Commission on Environmental Quality, which accompany the financial statements, but are not RSI. With respect to this supplementary information, I made certain inquiries of management and evaluated the form, content, and methods of preparing the information to determine that the information complies with accounting principles generally accepted in the United States of America, the method of preparing it has not changed from the prior period, and the information is appropriate and complete in relation to my audit of the financial statements. I compared and reconciled the supplementary information to the underlying accounting records used to prepare the financial statements or to the financial statements themselves. Restriction on Use This information is intended solely for the information and use of the Board of Directors and management of the Trophy Club Municipal Utility District No. 1 and is not intended to be, and should not be, used by anyone other than these specified parties. Very truly yours, aouivt— Rod L. Abbott, CPA PLLC P.O. Box 75 Tom Bean, TX. 75489 (214) 856-9603 rodabbottcpa@hotmail.com 53 of 131 January 17, 2024 Regular Meeting Agenda Packet ATTACHMENT 1 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ADJUSTING AUDIT ENTRIES FOR THE YEAR ENDED SEPTEMBER 30, 2023 AJE# DESCRIPTION AJE #1 122-000-26000-000 122-000-31110-000 135-000-26000-000 135-000-31110-000 533-000-26000-000 533-000-31110-000 Inv in Uncollected Taxes/FD Unassigned Fund Balance Investmt in Uncollected Taxes Unassigned Fund Balance Investmt in Uncollected Taxes Unassigned Fund Balance DEBIT 6,868 2,088 3,383 CREDIT 6,868 2,088 3,383 12,339 To properly state beginning fund balances for fiscal year 2023. 54 of 131 12,339 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1 AUDITED FINANCIAL STATEMENTS FOR THE YEAR ENDED SEPTEMBER 30, 2023 55 of 131 January 17, 2024 Regular Meeting Agenda Packet ANNUAL FILING AFFIDAVIT THE STATE OF TEXAS } COUNTY OF DENTON } I, Kevin R. Carr (Name of Duly Authorized Representative) Of Trophy Club Municipal Utility District No. 1 (Name of District) Hereby swear, or affirm, that the district named above has reviewed and approved at a meeting of the Board of Directors of the District on the 17th day of January 2024, its annual audit report for the fiscal year or period ended September 30, 2023 and that copies of the annual audit report have been filed in the district office, located at 100 Municipal Drive, Trophy Club, Texas, 76262. The annual filing affidavit and the attached copy of the annual audit report are being submitted to the Texas Commission on the Environmental Quality in satisfaction of the annual fling requirements of Texas Water Code Section 49.194. Date: January 17 , 20 24 . By: (Signature of District Representative) Kevin R. Carr, President, Board of Directors (Typed Name & Title) Sworn to and subscribed to before me this day of , 20 (SEAL) (signature of notary) My Commission Expires On: , 20 Notary Public in and for the State of Texas 56 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1 AUDITED FINANCIAL STATEMENTS TABLE OF CONTENTS Independent Auditor's Report Required Supplementary Information Management Discussion and Analysis .4 Basic Financial Statements Government Wide Statements: Statement of Net Position .1 1 Statement of Activities 12 Fund Financial Statements: Balance Sheet - Governmental Funds 13 Reconciliation of the Balance Sheet of Governmental Funds to the Statement of Net Position 14 Statement of Revenues and Expenditures, and Changes in Fund Balances — Governmental Funds 15 Reconciliation of the Statement of Revenues, Expenditures, and Changes in Fund Balances to the Statement of Activities 16 Notes to the Financial Statements 17 Required Supplementary Information Schedule of Revenues, Expenditures, and Changes in Fund Balance: Budgetary Comparison - General Fund ...36 Schedule of Changes in Net Pension Liability and Related Ratios 37 Schedule of Pension Contributions 38 Schedule of Changes in the Other Post -Employment Benefits (OPEB) Liability and Related Ratios 39 Schedule of Other Post -Employment Benefits (OPEB) Contributions 40 57 of 131 January 17, 2024 Regular Meeting Agenda Packet Other Supplementary Information Individual Schedules and Other Supplementary Information Required by the Texas Commission on Environmental Quality (TCEQ1 TSI -1 Service and Rates .41 TSI -2 General Fund Expenditures and Other Financing Uses 43 TSI -3 Temporary Investments 44 TSI -4 Taxes Levied and Receivables .45 TSI -5 Long -Term Debt Service Requirements - By Year 47 TSI -6 Changes in Long -Term Bonded Debt .50 TSI -7 Comparative Schedules of Revenues and Expenditures - Five Years 51 TSI -8 Board Members, Key Personnel, and Consultants 53 58 of 131 January 17, 2024 Regular Meeting Agenda Packet Rod L. Abbott, CPA PLLC Certified Public Accountant INDEPENDENT AUDITOR'S REPORT To the Board of Directors Trophy Club Municipal Utility District No. 1 Trophy Club, Texas Opinions I have audited the accompanying financial statements of the governmental activities, each major fund, and the remaining aggregate fund information of the Trophy Club Municipal Utility District No. 1 (the "District"), as of and for the year ended September 30, 2023, and the related notes to the financial statements, which collectively comprise the District's basic financial statements as listed in the table of contents. In my opinion, the financial statements referred to above present fairly, in all material respects, the respective financial position of the governmental activities, each major fund, and the remaining aggregate fund information of the Trophy Club Municipal Utility District No. 1 as of September 30, 2023, and the respective changes in financial position for the year then ended in accordance with accounting principles generally accepted in the United States of America. Basis for Opinions I conducted my audit in accordance with auditing standards generally accepted in the United States of America. My responsibilities under those standards are further described in the Auditor's Responsibilities for the Audit of the Financial Statements section of my report. I am required to be independent of the District, and to meet my other ethical responsibilities, in accordance with the relevant ethical requirements relating to my audit. I believe that the audit evidence I have obtained is sufficient and appropriate to provide a basis for my audit opinions. Responsibilities of Management for the Financial Statements Management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. In preparing the financial statements, management is required to evaluate whether there are conditions or events, considered in the aggregate, that raise substantial doubt about the District's ability to continue as a going concern for twelve months beyond the financial statement date, including any currently known information that may raise substantial doubt shortly thereafter. 1 P.O. Box 75 Tom Bean, TX. 75489 (214) 856-9603 rodabbottcpa@hotmail.com 59 of 131 January 17, 2024 Regular Meeting Agenda Packet Auditor's Responsibilities for the Audit of the Financial Statements My objectives are to obtain reasonable assurance about whether the financial statements as a whole are free from material misstatement, whether due to fraud or error, and to issue an auditor's report that includes my opinions. Reasonable assurance is a high level of assurance but is not absolute assurance and therefore is not a guarantee that an audit conducted in accordance with generally accepted auditing standards will always detect a material misstatement when it exists. The risk of not detecting a material misstatement resulting from fraud is higher than for one resulting from error, as fraud may involve collusion, forgery, intentional omissions, misrepresentations, or the override of internal control. Misstatements are considered material if there is a substantial likelihood that, individually or in the aggregate, they would influence the judgment made by a reasonable user based on the financial statements. In performing an audit in accordance with generally accepted auditing standards, I: • Exercise professional judgment and maintain professional skepticism throughout the audit. • Identify and assess the risks of material misstatement of the financial statements, whether due to fraud or error, and design and perform audit procedures responsive to those risks. Such procedures include examining, on a test basis, evidence regarding the amounts and disclosures in the financial statements. • Obtain an understanding of internal control relevant to the audit in order to design audit procedures that are appropriate in the circumstances, but not for the purpose of expressing an opinion on the effectiveness of the District's internal control. Accordingly, no such opinion is expressed. • Evaluate the appropriateness of accounting policies used and the reasonableness of significant accounting estimates made by management, as well as evaluate the overall presentation of the financial statements. • Conclude whether, in my judgment, there are conditions or events, considered in the aggregate, that raise substantial doubt about the District's ability to continue as a going concern for a reasonable period of time. I am required to communicate with those charged with governance regarding, among other matters, the planned scope and timing of the audit, significant audit findings, and certain internal control -related matters that I identified during the audit. Required Supplementary Information Accounting principles generally accepted in the United States of America require that the management's discussion and analysis, General Fund budgetary comparison schedule, pension schedules, and other post - employment benefit schedules be presented to supplement the basic financial statements. Such information is the responsibility of management and, although not a part of the basic financial statements, is required by the Governmental Accounting Standards Board, who considers it to be an essential part of financial reporting for placing the basic financial statements in an appropriate operational, economic, or historical context. I have applied certain limited procedures to the required supplementary information in accordance with auditing standards generally accepted in the United States of America, which consisted of inquiries of management about the methods of preparing the information and comparing the information for consistency with management's responses to my inquiries, the basic financial statements, and other knowledge I obtained during my audit of the basic financial statements. I do not express an opinion or provide any assurance on the information because the limited procedures do not provide me with sufficient evidence to express an opinion or provide any assurance. 2 P.O. Box 75 Tom Bean, TX. 75489 (214) 856-9603 rodabbottcpa@a hotmail.com 60 of 131 January 17, 2024 Regular Meeting Agenda Packet Other Information My audit was conducted for the purpose of forming an opinion on the basic financial statements of Trophy Club Municipal Utility District No. 1. The Texas TCEQ Supplemental Information on pages 41-54 is required by the Texas Commission on Environmental Quality as published in the Water District Financial Management Guide. The Texas TCEQ Supplemental Information has not been subjected to the auditing procedures applied in the audit of the basic financial statements, and accordingly, I do not express an opinion or provide any assurance on it. Sincerely, Rod L. Abbott, CPA PLLC Tom Bean, Texas January 17, 2024 3 P.O. Box 75 Tom Bean, TX. 75489 (214) 856-9603 rodabbottcpa@hotmail.com 61 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 MANAGEMENT'S DISCUSSION AND ANALYSIS FOR THE YEAR ENDED SEPTEMBER 30, 2023 Trophy Club Municipal Utility District No. 1, Texas (the "District") Management's Discussion and Analysis (MD&A) is a narrative overview and analysis designed to provide the reader a means to identify and understand the financial activity of the District and changes in the District's financial position during the fiscal year ended September 30, 2023. The Management's Discussion and Analysis is supplemental to, and should be considered along with, the District's financial statements. Financial Highlights • At the close of the fiscal year, the assets and deferred outflows of the District exceeded its liabilities and deferred inflows by $43,237,459. Of this amount, $14,909,747 is unrestricted net position and may be used to meet the District's ongoing commitments. • The District's net position increased by $4,163,010 during 2023. Significant contributors to this result were water and wastewater charges exceeding their related departmental expenses by $4,596,651. • At the end of the fiscal year, the District's governmental type funds reported a combined fund balance of $17,722,802. As of September 30, 2023, the unassigned fund balance of the General Fund was $10,030,878. The unassigned fund balance is equal to 10.2 months of 2023 General Fund expenditures and is considered a very healthy unassigned fund balance. Overview of the Financial Statements The MD&A is intended to introduce the reader to the District's basic financial statements, which are comprised of three components: 1. Government -Wide Financial Statements, 2. Fund Financial Statements, and 3. Notes to Basic Financial Statements. The report also contains other required supplementary information in addition to the basic financial statements. Government -Wide Financial Statements - the government -wide financial statements are designed to provide the reader with a general overview of the District's finances in a way that is comparable with financial statements from the private sector. The government -wide financial statements consist of two statements: 1. The Statement of Net Position - This statement presents information on all of the District's assets, deferred inflows, deferred outflows, liabilities, and net position. The net position is the difference between assets plus deferred outflows less deferred inflows plus liabilities. Over an extended period, the increase or decrease in net position will serve as a good indicator of whether the financial position of the District is improving or deteriorating. 2. The Statement of Activities — This statement gives information showing how the District's net position has changed during the fiscal year. All revenues and expenses are reported on the full accrual basis. 4 62 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 MANAGEMENT'S DISCUSSION AND ANALYSIS FOR THE YEAR ENDED SEPTEMBER 30, 2023 Overview of the Financial Statements - Continued Fund Financial Statements - Fund financial statements provide detailed information about the most important funds and not about the District as a whole as in the government -wide financial statements. The District uses fund accounting to demonstrate compliance with finance related legal requirements which can be categorized as governmental fund activities. Governmental Funds - All of the District's activities are reported in governmental funds. They are used to account for those functions known as governmental activities. But unlike government -wide financial statements, governmental fund financial statements focus on how monies flow into and out of those funds and their resulting balances at the end of the fiscal year. Statements of governmental funds provide a detailed short-term view of the District's general government operations and the basic services it provides. Such information can be useful in evaluating a government's short-term financing requirements. The District maintains three governmental funds. Information is presented separately in the Governmental Funds Balance Sheet and in the Governmental Funds Statement of Revenues, Expenditures, and Changes in Fund Balances for the General Fund, Debt Service Fund and Capital Projects Fund. The District adopts an annual appropriated budget for the General Fund. A budgetary comparison statement is provided for the General Fund to demonstrate compliance with its budget. Notes to the Basic Financial Statements - The notes provide additional information that is essential to a full understanding of the data presented in the government -wide and fund financial statements. Government -wide Financial Analysis The Management's Discussion and Analysis highlights the information provided in both the Statement of Net Position and Statement of Activities in the government -wide financial statements. It may serve over an extended period of time, as a useful indicator of the District's financial position. At the end of the fiscal year, the District's assets and deferred outflows exceeded liabilities and deferred inflows by $43,237,459. Of this amount, $27,323,898 (63%) reflects the District's investment in capital assets (e.g., land, buildings, machinery and equipment, net of accumulated depreciation), less any related outstanding debt used to acquire those assets and unspent bond proceeds, $1,003,815 (3%) restricted for debt service and capital projects, and the remaining $14,909,747 (34%) is unrestricted. 2023 governmental activities have increased the District's net position by $4,163,010, which amounts to a 10.6% increase in net position for the year ended September 30, 2023. 5 63 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 MANAGEMENT'S DISCUSSION AND ANALYSIS FOR THE YEAR ENDED SEPTEMBER 30, 2023 Government -wide Financial Analysis — Continued District operational analysis - The following table provides a summary analysis of the District's Statements of Net Position for the fiscal years ending on September 30, 2023 and 2022. Table 1 Condensed Statements of Net Position Current and other assets Capital assets Total assets Deferred outflows of resources Long-term liabilities Other liabilities Total liabilities Deferred inflows of resources Governmental Activities FY23 FY22 $ 18,827,852 $ 18,749,584 46,164,516 44,399,904 64,992,368 63,149,488 321,158 258,908 20,861,156 22,637,495 1,053,284 1,399,980 21,914,440 24,037,475 161,626 296,471 Net position: Net investment in capital assets 27,323,898 23,922,288 Restricted 1,003,815 748,222 Unrestricted 14,909,747 14,403,939 Total net position $ 43,237,459 $ 39,074,449 6 64 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 MANAGEMENT'S DISCUSSION AND ANALYSIS FOR THE YEAR ENDED SEPTEMBER 30, 2023 Government -wide Financial Analysis - Continued District operational analysis - The following table provides a summary analysis of the District's consolidated operations for the fiscal years ending on September 30, 2023 and 2022. Table 2 Condensed Statements of Activities Governmental Activities FY23 FY22 Revenues: Program Revenues: Charges for services $ 11,973,510 $ 10,937,443 Operating grants and contributions Capital grants and contributions General Revenues: Property taxes 2,047,252 2,136,367 Other unrestricted contributions 151,357 164,890 Investment income 573,996 95,640 Gain on sold assets 103,373 21,001 Other 17,432 92,899 14,866,920 13,448,240 Expenses: Water 4,621,529 4,160,522 Wastewater 2,706,051 2,495,767 Administration 1,544,270 1,593,047 Fire protection 1,157,569 1,251,603 Non -departmental and Board 71,379 102,472 Interest on long-term debt 603,112 617,680 10,703,910 10,221,091 Excess (deficiency) of revenues over expenditures before transfers 4,163,010 3,227,149 Transfers In (Out) Increase in net position 4,163,010 3,227,149 Net position - October 1 39,074,449 35,847,300 Net position - September 30 $ 43,237,459 $ 39,074,449 7 65 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 MANAGEMENT'S DISCUSSION AND ANALYSIS FOR THE YEAR ENDED SEPTEMBER 30, 2023 Financial analysis of the District's funds Governmental Funds - the main focus of the District's governmental funds is to provide information on the flow of monies to and from the funds, and to note the unassigned fund balance, which is a good indicator of resources available for spending in the near term. The information derived from these funds is highly useful in assessing the District's financial requirements. The unassigned fund balance may serve as a useful measure of the District's net resources available for use at the fiscal year-end. At the end of the fiscal year, the District's governmental funds reported combined ending fund balances of $17,722,802, of which 57%, or $10,030,878, is unassigned and available to the District for future spending. General Fund budgetary highlights The District's Board of Directors approved a budget amendment during fiscal year 2023 to largely account for the increase of water consumption and increased capital outlay expense due to prior year projects being completed by fiscal year end. (page 36) Revenue: Revenues were 5980,914 (7.1%) more than budgeted • Water charges totaled $8,001,954 and were $859,699 (10.7%) more than budgeted. Expenditures: Expenditures were $351,984 (3.0%) less than budgeted • Capital Outlay expenditures were $380,904 (10.7%) less than budgeted. • Water Operations were $133,376 (3.2%) more than budgeted. • Wastewater operations expenditures were $77,187 (5.3%) less than budgeted. Capital Assets The District's investment in capital assets for its governmental activities as of September 30, 2023 amounted to $46,164,516, net of accumulated depreciation. This represents a broad range of capital assets including, but not limited to land, buildings, improvements, machinery and equipment, vehicles, water, wastewater treatment, and wastewater collection systems. Net capital assets increased $1,764,612 or 4.0% during 2023 primarily due to over $3.3 million of new improvements to the District's water and wastewater system. Additional information about capital assets may be found in Note 5 in the notes to financial statements. 8 66 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 MANAGEMENT'S DISCUSSION AND ANALYSIS FOR THE YEAR ENDED SEPTEMBER 30, 2023 Debt administration Long -Term Debt - at the end of the current fiscal year, the District had $20,747,398 of general obligation bonds, revenue bonds, and type A financing leases, which is a decrease of 7.9% from the previous fiscal year due to $1,782,648 of 2023 principal payments. All 2023 debt service requirements were met and the District did not issue any new debt during fiscal year 2023. Economic factors and next year's budgets and rates: General Fund 2023 - 2024 budgetary highlights: Revenue: The District's 2024 General Fund budgeted revenues reflect a projected increase of $2,690,579, or 22.93%, when compared to the District's 2023 adopted budget. • Water revenue is budgeted to increase from $6,710,979 for fiscal year 2023 to $6,939,998 for fiscal year 2024 for a total projected increase of $229,019, or 3.41%. • Sewer revenue is budgeted to decrease from $3,839,686 for fiscal year 2023 to $3,679,786 for fiscal year 2024 for a total projected decrease of ($159,900), or (4.16%). • The District's M&O tax rate increased from fiscal year 2023 to fiscal year 2024. The fiscal year 2024 segregated M&O property tax revenue is budgeted to increase by $67,366 for Fire and decrease by ($2,222) for the MUD when compared to 2023. Expenses: The District's 2024 General Fund budgeted expenses reflect a projected increase of $2,690,579, or 22.93%, when compared to the District's 2023 adopted budget. • Wholesale water purchase from City of Fort Worth increased by $15,366, or 0.58%, due to the consumption demands. • The capital outlay collectively increased by $2,603,000, or 98.34% due to the District's proactive asset replacement schedule and the completion of prior year projects. • The maintenance and repairs collectively decreased by ($53,900), or (7.86%) due to reduction in required repairs with the proactive replacement schedule. • The electricity collectively decreased by ($85,132), or (16.09%) due the District's current provider new contract rates effective December 2022. • The District's personnel cost collectively increased by $72,796, or 3.58% due to the COLA increase and new employee benefit rates. Overall: The District's 2024 General Fund budget is anticipated to have revenues of $14,372,315 and expenses of $16,485,079 for a total projected net spend down of fund balance of ($2,112,764). Debt Service Fund 2023 - 2024 budgetary highlights: • The District's Debt Service expenses are budgeted to decrease from $2,269,673 in fiscal year 2023 to $1,800,479 budgeted for fiscal year 2024 for a total decrease of $469,194, or 20.67%. • Property tax revenues collected for Debt Service are budgeted to decrease from $696,446 in fiscal year 2023 to $219,481 budgeted in fiscal year 2024 for a total decrease of ($476,965), or (68.49%). 9 67 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 MANAGEMENT'S DISCUSSION AND ANALYSIS FOR THE YEAR ENDED SEPTEMBER 30, 2023 Sewer and Water Rates highlights: Effective October 1 S`, 2022, the District's Board of Directors adopted an increase in both the base and volumetric water rates, and effective April 1, 2023, adopted an increase in sewer volumetric rates for commercial customers. The District did not adopt a water or sewer rate increase for FY 2024. Requests for information This financial report is designed to provide a general overview of the District's consolidated finances for all interested parties. Questions concerning any of the information in this report or requests for additional information should be directed to the Trophy Club Municipal Utility District No. 1, Finance Manager, 100 Municipal Drive, Trophy Club, Texas 76262. 10 68 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 Statement of Net Position September 30, 2023 Governmental Activities Assets Cash and cash equivalents $ 6,086,438 Investments 7,652,770 Restricted assets: Restricted cash 146,955 Restricted investments 3,081,580 Prepaid assets 3,880 Receivables: Accounts receivables - net 1,757,383 Property taxes 12,341 Net pension asset 86,505 Capital assets: Non -depreciable capital assets 6,084,233 Depreciable capital assets (net) 40,080,283 Total assets 64,992,368 Deferred outflows of resources Deferred outflows of resources - OPEB Deferred outflows of resources - Pension Total deferred outflows of resources 7,531 313,627 321,158 Liabilities Accounts payable 833,096 Accrued liabilities 26,155 Interest payable 47,078 Customer meter deposits 146,955 Non-current liabilities: Due within one year 1,257,398 Due in more than one year 19,579,298 OPEB liability 24,460 Total liabilities 21,914,440 Deferred inflows of resources Deferred inflows of resources - OPEB Deferred inflows of resources - Pension Total deferred inflows of resources 16,114 145,512 161,626 Net Position Net investment in capital assets 27,323,898 Restricted for: Capital projects 860,652 Debt service 143,163 Unrestricted 14,909,747 Total net position $ 43,237,459 The accompanying notes are an integral part of these financial statements. 11 69 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 Statement of Activities For the Year Ended September 30, 2023 Functions/Programs Primary government: Governmental activities: Water operations Wastewater operations Administration Fire protection Non -departmental Board of directors Interest on long-term debt Total governmental activities Governmental Activities Expenses Program Revenues Net (Expense) Revenue and Changes in Net Position Charges for Services Operating Grants and Contributions Capital Grants and Contributions Total Governmental Activities $ 4,621,529 $ 2,706,051 1,544,270 1,157,569 68,637 2,742 603,112 8,079,155 $ 3,845,076 49,279 $ 3,457,626 1,139,025 (1,494,991) (1,157,569) (68,637) (2,742) (603,112) $ 10,703,911 $ 11,973,510 $ General revenues: Property taxes Contributions not restricted to specific programs Investment earnings Miscellaneous Gain on sale of assets Total general revenues Change in net position Net position - beginning Net position - ending The accompanying notes are an integral part of these financial statements. 12 70 of 131 1,269,599 2,047,252 151,357 573,996 17,432 103,373 2,893,411 4,163,010 39,074,449 $ 43,237,459 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 BALANCE SHEET - GOVERNMENTAL FUNDS SEPTEMBER 30, 2023 Assets Cash Investments Restricted assets: Restricted cash Restricted investments Prepaid assets Receivables: Accounts receivable - net Property taxes Due from other funds Total assets Liabilities Current liabilities: Accounts payable Accrued payroll liabilities Customer deposits Due to other funds Total current liabilities Deferred Inflows of Resources Unavailable revenue - Property taxes Total deferred inflows of resources Fund Balances Non -spendable: Prepaid assets Restricted for: Debt service Capital projects Assigned for: Capital projects Unassigned Total fund balances Total liabilities, deferred inflows of resources, and fund balances General Fund $ 6,086,438 7,652,770 Debt Service Fund Capital Projects Fund Total Governmental Funds $ 6,086,438 7,652,770 146,955 146,955 - 143,162 2,938,418 3,081,580 3,880 - 3,880 1,757,383 - 8,957 3,384 81,691 - 1,757,383 12,341 81,691 $ 15,738,074 $ 146,546 $ 2,938,418 $ 18,823,038 $ 833,096 26,155 146,955 1,006,206 8,956 8,956 3,880 4,688,154 10,030,878 14,722,912 $ 15,738,074 3,383 3,383 143,163 81,691 81,691 2,856,727 143,163 2,856,727 $ 833,096 26,155 146,955 81,691 1,087,897 12,339 12,339 3,880 143,163 2,856,727 4,688,154 10,030,878 17,722,802 $ 146,546 $ 2,938,418 $ 18,823,038 The accompanying notes are an integral part of these financial statements. 13 71 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 Reconciliation of the Governmental Funds Balance Sheet to the Statement of Net Position at September 30, 2023 Fund balances of governmental funds $ 17,722,802 Amounts reported for governmental activities in the statement of net position are different because: Capital assets used in governmental activities are not financial resources and, therefore, are not reported in the funds. 46,164,516 Deferred outflows of resources related to pension and OPEB balances do not provide current financial resources and, therefore, are not reported in the governmental funds. Deferred inflows of resources related to pension and OPEB balances do not require the use of current financial resources and, therefore, are not reported in the governmental funds. Long-term liabilities are not due and payable in the current period and, therefore, are not reported in the funds. Accrued interest payable for governmental -type long-term debt is recognized in the governmental activities in the statement of net position. The District's net pension asset balance does not provide current financial resources and, therefore, is not reported in the governmental funds. Property tax receivables not received within sixty days after fiscal year-end are deferred income on the fund financial statements, but these amounts are realized as income on the government -wide financials. 321,158 (161,626) (20,861,156) (47,078) 86,505 12,338 Net position of governmental activities $ 43,237,459 The accompanying notes are an integral part of these financial statements. 14 72 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB_ MUNICIPAL UTILITY DISTRICT NO. 1 Statement of Revenues, Expenditures, and Changes in Fund Balances - Governmental Funds For the Year Ended September 30, 2023 Revenues Water charges Wastewater charges Property taxes Intergovernmental Late charges Rental income Inspections and other charges for services Other revenue Investment earnings Total revenues Expenditures Current: Water Wastewater Administration Fire Non -departmental Board of directors Capital outlays Debt service: Principal retirement Interest and fees Total expenditures Excess of revenues over (under) expenditures Other financing sources (uses) Proceeds from sold assets Transfers in Transfers (out) Total other financing sources(uses) Net changes in fund balances Fund balances - beginning Fund balances - ending General Fund Debt Service Fund Capital Projects Fund $ 8,001,954 $ $ 3,845,076 1,355,148 701,238 151,357 77,201 45,179 4,100 17,432 397,122 49,191 127,683 13,894,570 4,157,215 1,460,607 1,474,970 978,435 68,637 2,742 3,553,442 750,428 127,683 117,645 1,665,000 3,305 603,395 11,816,999 2,077,571 110,979 (1,573,226) 216,188 2,268,395 216,188 (1,517,967) 1,573,226 (88,505) Total Governmental Funds $ 8,001,954 3,845,076 2,056,386 151,357 77,201 45,179 4,100 17,432 573,996 14,772,681 4,157,215 1,460,607 1,474,970 978,435 68,637 2,742 3,769,630 1,782,645 606,700 14,301,582 471,099 110,979 1,573,226 (1,573,226) (1,462,247) 1,573,226 110,979 615,324 55,259 (88,505) 14,107,588 87,904 2,945,232 582,078 17,140,724 $ 14,722,912 $ 143,163 $ 2,856,727 $ 17,722,802 The accompanying notes are an integral part of these financial statements. 15 73 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 Reconciliation of the Statement of Revenues, Expenditures, and Changes in Fund Balances of Governmental Funds To the Statement of Activities For the Year Ended September 30, 2023 Amounts reported for governmental activities in the statement of activities are different because: Net change in fund balances - total governmental funds $ 582,078 Governmental funds report capital outlays as expenditures. However, in the statement of activities, the cost of those assets is allocated over their estimated useful lives and reported as depreciation expense. This is the amount by which capital outlay expense exceeded depreciation expense in the fiscal year. Accrued interest does not require the use of current financial resources and, therefore, is not reported as an expenditure in the governmental funds. This is the (increase) decrease in accrued interest. 1,772,218 3,588 Principal payments on long-term debt are an expenditure for the governmental funds, but this expenditure is a reduction of long-term debt for the government -wide financial statements. 1,782,645 Various other reclassifications and eliminations are necessary to convert from the modified accrual basis of accounting to accrual basis of accounting. These include recognizing a $9,134 decrease in deferred revenue, a $15,092 increase in accrued compensated absences, and various other smaller items. The net effect of these reclassifications is to decrease net position. Modifications are necessary to convert from the modified accrual basis of accounting to accrual basis of accounting for OPEB and pension expense. The net effect of these adjustments is to increase net position. Change in net position of governmental activities: The accompanying notes are an integral part of these financial statements. 16 74 of 131 (31,832) 54,313 $ 4,163,010 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 NOTES TO BASIC FINANCIAL STATEMENTS FOR THE YEAR ENDED SEPTEMBER 30, 2023 NOTE 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES A. General Statement Denton County Municipal Utility District No. I (the District) was created by the Texas Water Rights Commission (later known as Texas Commission on Environmental Quality (TCEQ)) on March 4, 1975 and confirmed by the electorate of the District at a confirmation election on October 7, 1975. The Board of Director's held its first meeting on April 24, 1975. The Bonds were first sold on June 8, 1976. The District operates pursuant to Article XVI, Chapter 59 of the Texas Constitution and Chapter 54 of the Texas Water Code, as amended. Effective April 1, 1983, the District's name was officially changed by order from Denton County Municipal Utility District No..1 to Trophy Club Municipal Utility District No. 1 . On May 9, 2009, citizens voted to consolidate the District and Trophy Club Municipal Utility District No. 2 (MUD 2). As a result, the District reports consolidated activity and balances for the District and the entities formerly known as MUD 2 and the Trophy Club Master District Joint Venture (a joint venture of MUD 1 and MUD 2). The Governmental Accounting Standards Board (GASB) is the accepted standard setting body for the District. The financial statements of the District have been prepared in conformity with generally accepted accounting principles (GAAP) as applied to government units. B. Financial Reporting Entity As required by accounting principles generally accepted in the United States of America, these financial statements include the activities of the District and any organizations for which. the District is financially accountable or for which the nature and significance of their relationship with the District are such that exclusion would cause the reporting entity's financial statements to be misleading or incomplete. The definition of the reporting entity is based primarily on the notion of financial accountability. A primary government is financially accountable for the organizations that make up its legalentity. It is also financially accountable for legally separate organizations if its officials appoint a voting majority of an organization's governing body and either it is able to impose its will on that organization or there is a potential for the organization to provide specific financial benefits to, or to impose specific financial burdens on, the primary government. A primary government may also be financially accountable for governmental organizations that are fiscally dependent on it. A primary government has the ability to impose its will on an organization if it can significantly influence the programs, projects, or activities of, or the level of services performed or provided by, the organization. A financial benefit or burden relationship exists if the primary government (a) is entitled to the organization's resources; (b) is legally obligated or has otherwise assumed the obligation to finance the deficits of, or provide financial support to, the organization; or (c) is obligated in some manner for the debt of the organization. Some organizations are included as component units because of their fiscal dependency on the primary government. 17 75 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 NOTES TO BASIC FINANCIAL STATEMENTS FOR THE YEAR ENDED SEPTEMBER 30, 2023 NOTE 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - CONTINUED An organization is fiscally dependent on the primary government if it is unable to adopt its budget, levy taxes, set rates or charges, or issue bonded debt without approval by the primary government. The District has determined it has no component units. C. Government -Wide and Fund Financial Statements The government -wide financial statements (the Statement of Net Position and the Statement of Activities) report information on all of the activities of the District, except for fiduciary funds. The effect of interfund activity has been removed from these statements. Governmental activities, which normally are supported by taxes and intergovernmental revenues, are reported separately from business -type activities, which rely to a significant extent on fees and charges for support. The activities of the District are comprised only of governmental activities. The Statement of Activities demonstrates the degree to which the direct expenses of a given program are offset by program revenues. Direct expenses are those that are clearly identifiable with a specific program. Program revenues include 1) charges to customers or applicants who purchase, use, or directly benefit from goods, services, or privileges provided by a given program and 2) operating or capital grants and contributions that are restricted to meeting the operational or capital requirements of a particular program. Taxes and other items not properly included among program revenues are reported instead as general revenues. Fund Financial Statements The District segregates transactions related to certain functions or activities in separate funds in order to aid financial management and to demonstrate legal compliance. These statements are required to present each major fund in a separate column on the fund financial statements. For fiscal year 2023, the major funds are the General Fund, Debt Service Fund, and the Capital Projects Fund. Governmental funds are those funds through which most governmental functions typically are financed. The measurement focus of governmental funds is on the sources, uses and balance of current financial resources. The District has presented the following governmental funds: General Fund The General Fund is the main operating fund of the District. This fund is used to account for all financial resources not accounted for in other funds. All general tax revenues and other receipts that are not restricted by law or contractual agreement to some other fund are accounted for in this fund. Generaloperating expenditures, fixed charges and capital improvement costs that are not paid through other funds are paid from the General Fund. Debt Service Fund The Debt Service Fund is used to account for resources accumulated and payments made for principal and interest on the long-term debt of the District. 18 76 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 NOTES TO BASIC FINANCIAL STATEMENTS FOR THE YEAR ENDED SEPTEMBER 30, 2023 NOTE 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - CONTINUED Capital Projects Fund The Capital Projects Fund is used to account for funds received and expended for the acquisition and construction of infrastructure and other capital assets. D, Measurement Focus and Basis of Accounting Measurement focus refers to what is being measured; basis of accounting refers to when revenues and expenditures are recognized in the accounts and reported in the financial statements. Basis of accounting relates to the timing of the measurement made, regardless of the measurement focus applied. The government -wide statements are reported using the economic resources measurement focus and the accrual basis of accounting. The economic resources measurement focus means all assets and liabilities (whether current or non-current) are included on the Statement of Net Positionand the operating statements present increases (revenues) and decreases (expenses) in net total position. Under the accrual basis of accounting, revenues are recognized when earned. Expenses are recognized at the time the liability is incurred. Governmental fund financial statements are reported using the current financial resources measurement focus and are accounted for using the modified accrual basis of accounting. Under the modified accrual basis of accounting, revenues are recognized when susceptible to accrual; i.e.; when they become both measurable and available. "Measurable" means the amount of the transaction can be determined and "available" means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. The District considers receivables collected within sixty days after year-end to be available and recognizes them as revenues of the current year. Expenditures are recorded when the related fund liability is incurred. However, debt service expenditures are recorded only when payment is due. E. Cash and Investments The District's cash and cash equivalents are considered to be cash on hand, demand deposits, and short-term investments of three months or less from the date of acquisition, 19 77 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 NOTES TO BASIC FINANCIAL STATEMENTS FOR THE YEAR ENDED SEPTEMBER 30, 2023 NOTE 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES — CONTINUED The District's investment policy requires that all monies be deposited with the authorized District depository or in (1) obligations of the United States or its agencies and instrumentalities; (2) direct obligations of the State of Texas or its agencies; (3) other obligations. the principal of and interest on which are unconditionally guaranteed or insured by the State of Texas or the United States; (4) obligations of states, agencies, counties, cities, and other political subdivisions of any state having beenrated as to investment quality by a nationally recognized investment rating firm and having received a rating of not Tess than A or its equivalent; (5) certificates of deposit by state and national banks domiciled in this state that are (A) guaranteed or insured by the Federal Deposit Insurance Corporation, or its successor; or, (B) secured by obligations that are fully collateralized. All investments are recorded at fair value based on quoted market prices. Fair value is the amount at which a financial instrument could be exchanged in a current transaction between willing parties. F. Capital Assets Capital assets, which include property, plant, and equipment, are reported in the government -wide financial statements. All capital assets are valued at historical cost or estimated historical cost if actual historical cost is not available. Donated assets are valued at their fair value on the date donated. Repairs and maintenance are recorded as expenses. Renewals and betterments are capitalized. Assets capitalized have an original cost of $5,000 or more and over one year of useful life. Depreciation has been calculated on each class of depreciable property using the straight-line method. Estimated useful lives are as follows: Depreciable Asset Category Life in Years Buildings 50 Improvements other than Buildings 15-30 Machinery and Equipment 5-15 Vehicles 6-12 Water & Wastewater Infrastructure 30-65 G. Compensated Absences Employees earn vacation pay based upon seniority that accrues at various rates up to a maximum four weeks per year. Upon termination, employees will be paid for their unused earned vacation. The District accrues a liability for the value of these compensated absences on the full -accrual basis statement of net position. 20 78 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 NOTES TO BASIC FINANCIAL STATEMENTS FOR THE YEAR ENDED SEPTEMBER 30, 2023 NOTE 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - CONTINUED H. Net Position Net position represents the difference between assets and deferred outflows of resources, less deferred inflows of resources and liabilities. Net positioninvested in capital assets, net of related debt consists of capital assets, net of accumulated depreciation, reduced by the outstanding balances of any borrowing used for the acquisition, construction or improvements of those assets, and adding back unspent proceeds. Net position is reported as restricted when there are limitations imposed on their use either through the enabling legislations adopted by the District or through external restrictions imposed by creditors, grantors or laws or regulations of other governments. I. Estimates In preparing financial statements in conformity withaccounting principles generally accepted in the United States of America, management is required to make estimates and assumptions that affect the reported amounts of assets and Liabilities, the disclosures of contingent assets and liabilities, and the reported amounts of revenue and expenses/expenditures. Actual results could differ from those estimates. J. Fund Balances Governmental Accounting Standards Board (GASB) Statement No. 54, Fund Balance Reporting and Governmental Fund Type Definitions (GASB 54) defines the different types of fund balances that a governmental entity must use for financial reporting purposes in the fund financial statements for governmental type funds. It does not apply for the government -wide financial statements. GASB 54 requires the fund balance amounts to be properly reported within one of the following fund balance categories: Nonspendable - such as fund balance associated with inventories, prepaids, long-term loans and notes receivable, and property held for resale (unless the proceeds are restricted, committed, or assigned), Restricted - fund balance category includes amounts that can be spent only for the specific purposes stipulated by constitution, external resource providers, or through enabling legislation, Committed - fund balance classification includes amounts that can be used only for the specific purposes determined by a formal action of the Board of Directors (the District's highest level of decision-making authority), Assigned - fund balance classifications are assigned by the District Manager with the intentions to be used by the government for specific purposes but do not meet the criteria to be classified as restricted or committed, and Unassigned - fund balance is the residual classification for the District's General Fund and includes all spendable amounts not contained in the other classifications, and other funds that have total negative fund balances. 21 79 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 NOTES TO BASIC FINANCIAL STATEMENTS FOR THE YEAR ENDED SEPTEMBER 30, 2023 NOTE 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - CONTINUED K. Accounts Receivable and Allowances for Bad Debt Accounts receivable consists primarily of receivables related to water and sewer services. Accounts receivable includes an accrual for unbilled revenue earned during the month of September 2023. Trade accounts receivable are evaluated periodically for collectability based on customer history and current economic conditions. When considered necessary, an allowance is made for doubtful accounts. NOTE 2. CASH AND INVESTMENTS The funds of the District must be deposited and invested under the terms of a contract, contents of which are set out in the Depository Contract Law. The depository bank places approved pledged securities for safekeeping and trust with the District's agent bank in an amount sufficient to protect District funds on a day-to-day basis during the period of the contract. The pledge of approved securities is waived only to the extent of the depository bank's dollar amount of Federal Deposit Insurance Corporation (FDIC) insurance. At September 30, 2023, the carrying amount of the District's cash deposits was $6,232,793 and the bank balance was $7.309,657. Of the District's cash deposits at September 30, 2023, $250,000 was insured by FDIC and $7,059,657 was covered by pledged securities, The Public Funds Investment Act (Government Code Chapter 2256) contains specific provisions in the areas of investment practices, management reports and establishment of appropriate policies. Among other things, it requires the District to adopt, implement, and publicize an investment policy. That policy must address the following areas; (1) safety of principal and liquidity, (2) portfolio diversification, (3) allowable investments, (4) acceptable risk levels, (5) expected rates of return, (6) maximum allowable stated maturity of portfolio investments, (7) maximum average dollar -weighted maturity, allowed based on the stated maturity date for the portfolio, (8) investment staff quality and capabilities, and (9) bid solicitation preferences for certificates of deposit. Cash and investments as of September 30, 2023 consist of the following: Deposits with financial institutions $ 6,232,793 Unrestricted TexPool investments 7,652,770 Restricted TexPool investments 2,264,563 Restricted escrow investments 817,017 Petty cash 600 Total Cash and Investments $ 16,967,744 77 80 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 NOTES TO BASIC FINANCIAL STATEMENTS FOR THE YEAR ENDED SEPTEMBER 30, 2023 NOTE 2. CASH AND INVESTMENTS — CONTINUED Disclosures Relating to Interest Rate Risk Interest rate risk is the risk that changes in market interest rates will adversely affect the fair value of an investment. Generally, the longer the maturity of an investment the greater the sensitivity of its fair value to changes in market interest rates. One of the ways that the District manages its exposure to interest rate risk is by investing mainly in investment pools which purchase a combination of shorter -term investments with an average maturity of less than 60 days thus reducing the interest rate risk. The District monitors the interest rate risk inherent in its portfolio by measuring the weighted average maturity of its portfolio. The District monitors its interest rate risk, which is governed by adopted Investment Policies. As of September 30, 2023, the District had the following investments: Weighted Avg. Investment Type Carrying Amount Maturity TexPool Pooled Investments $ 9,917,333 26 days BOK Financial - U.S. Securities $ 817,017 12 days As of September 30, 2023, the District did not invest in any securities which are highly sensitive to interest rate fluctuations. Disclosures Relating to Credit Risk Generally. credit risk is the risk that an issuer of an investment will not fulfill its obligation to the holder of the investment. This is measured by the assignment of a rating by a nationally recognized statistical rating organization. Presented below is the minimum rating required by (where applicable) the Public Funds Investment Act, the District's investment policy, or debt agreements, and the actual rating as of year- end for each investment type. Minimum Rating at Investment Type Carrying Amount Legal Rating Year -End TexPool Pooled Investments $ 9,917,333 AAAm AAAm BOK Financial - U.S. Securities $ 817,017 AAAm AAAm 23 81 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 NOTES TO BASIC FINANCIAL STATEMENTS FOR THE YEAR ENDED SEPTEMBER 30, 2023 NOTE 2. CASH AND INVESTMENTS — CONTINUED Custodial Credit Risk Custodial credit risk for deposits is the risk that, in the event of the failure of a depository financial institution, a government will not be able to recover its deposits or will not be able to recover collateral securities that are in the possession of an outside party. The custodial credit risk for investments is the risk that, in the event of the failure of the counterparty to a transaction, a government will not be able to recover the value of its investment or collateral securities that are in the possession of another party. The Public Funds Investment Act and the .District's investment policy have the following provision for deposits: They require that a financial institution secure deposits made by state or local governmental units by either 1) pledging securities in an undivided collateral pool held by a depository regulated under state law (unless so waived by the governmental unit), or 2) an irrevocable standby letter of credit with the District named as the beneficiary. The market value of pledged securities in the collateral pool or the value of the letter of credit must equal at least the bank balance less .FDIC insurance at all times. Investment in State Investment Pools The District is a voluntary participant in TexPool. The State Comptroller of Public Accounts exercises responsibility over TexPool. This oversight includes the ability to significantly influence operations, designation of management, and accountability for fiscal matters. Additionally, the State Comptroller has established an advisory board composed of both participants in TexPool and other persons who do not have a business relationship with TexPool. TexPool operates in a manner consistent with the SEC's Rule 2a7 of the Investment Company Act of 1940. TexPool uses amortized costs rather than market value to report net assets to compute share prices. Accordingly, the fair value of the position in TexPool is the same as the value of TexPool shares. The TexPool and the mutual fund investments are measured at amortized cost and are exempt for fair value reporting under GASB Statement No. 72, Fair Value Measurement and Application. 24 82 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 NOTES TO BASIC FINANCIAL STATEMENTS FOR THE YEAR ENDED SEPTEMBER 30, 2023 NOTE 3. ACCOUNTS RECEIVABLE Receivables as of September 30, 2023 are as follows: Accounts Receivable: Water sales Wastewater sales Unbilled receivables Refuse (as an agent for the Town of Trophy Club) Storm drainage (as an agent for the Town of Trophy Club) Refuse tax (as an agent for the Town of Trophy Club) PID surcharge (as an agent for the Town of Trophy Club) Property taxes Other Gross receivables Less: Allowance for uncollectables Net receivables NOTE 4. INTERFUND TRANSFERS AND BALANCES $ 1,087,947 323,334 204,627 91,480 37,172 7,692 11,963 12,341 5,217 1,781,774 (12,051) $ 1,769,723 Transfers between funds during the year -ended September 30, 2023 are as follows: Transfers From General Fund Transfers To Debt Service Fund Total: Amount Purpose $ 1,573,226 Debt service assistance $ 1,573,226 Interfund due to/due from balances as of September 30, 2023 are as follows: Due From Fund Other Funds General Fund $ 81,691 Capital Projects Fund $ 81,691 83 of 131 Due To Other Funds 81,691 $ 81,691 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 NOTES TO BASIC FINANCIAL STATEMENTS FOR THE YEAR ENDED SEPTEMBER 30, 2023 NOTE 5. CAPITAL ASSETS Capital asset activity for the year ended September 30, 2023, was as follows: Governmental Activities: Beginning Balances Additions Retirements/ Ending Transfers Balance Capital assets - Non -Depreciable Land Construction in progress Water rights Total non -depreciable assets: Capital assets - Depreciable Buildings Improvements other than buildings Machinery and equipment Organization costs Vehicles Water system Wastewater treatment system Wastewater collection system Total capital assets being depreciated: Less accumulated depreciation for: Buildings Improvements other than buildings Machinery and equipment Organization costs Vehicles Water system Wastewater treatment system Wastewater collection system Total accumulated depreciation: Total depreciable capital assets, net: Capital assets, net: $ 648,178 8,649,949 864,678 $ - $ - $ 648,178 3,668,405 (7,746,977) 4,571,377 864,678 10,162,805 3,535,137 600,776 3,044,563 2,643,563 2,787,645 14,056,578 22,497,150 4,541,890 53,707,302 3,668,405 101,225 101,225 (7,746,977) 93,653 478,753 32,593 391,394 5,488,506 268,605 825,059 7,578,563 6,084,233 3,535,137 694,429 3,523,316 2,676,156 3,280,264 19,545,084 22,765,755 5,366,949 61,387,090 917,369 336,310 1,589,866 2,342,353 1,926,797 4,991,590 5,444,050 1,921,868 19,470,203 34,237,099 81,102 24,331 202,713 70,555 236,046 351,973 943,294 87,398 1,997,412 (160,808) (1,896,187) (160,808) 998,471 360,641 1,792,579 2,412,908 2,002,035 5,343,563 6,387,344 2,009,266 21,306,807 7,739,371 40,080,283 $ 44,399,904 $ 1,772,218 $ (7,606) $ 46,164,516 26 84 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 NOTES TO BASIC FINANCIAL STATEMENTS FOR THE YEAR ENDED SEPTEMBER 30, 2023 NOTE 5. CAPITAL ASSETS - CONTINUED Depreciation expense was charged as direct expense to programs of the primary govern Governmental activities: General government Water operations Wastewater operations Fire department Wastewater collection systems Total depreciation expense NOTE 6 LONG-TERM DEBT en t as follows: $ 72,312 482,418 1,176,150 179,134 87,398 $ 1,997,412 At September 30, 2023, the District's long-term debt issuances consisted of the following: General Obligation Bonds Series 2014 Tax Bonds Series 2020 Refunding Bonds Revenue Bonds Series 2015 Bonds Series 2016 Bonds Series 2019 Bonds Type A Financing Leases Camera Van Lease Total long-term debt: Interest Maturity Rate (%) Date Outstanding 1.5-3.5% 8/31/2034 1.30% 8/31/2031 2.0-3.25% 8/31/2035 0.5-2.2% 8/31/2036 3.0-3.5% 8/31/2049 3.95% 2/1/2024 27 85 of 131 $ 3,725,000 975,000 6,280,000 3,145,000 6,600,000 22,398 Due Within One Year $ 290,000 120,000 435,000 220,000 170,000 22,398 $ 20,747,398 $ 1,257,398 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 NOTES TO BASIC FINANCIAL STATEMENTS FOR THE YEAR ENDED SEPTEMBER 30, 2023 NOTE 6. LONG-TERM DEBT - CONTINUED The following is a summary of long-term liabilities activity for the District for the year ended September 30. 2023: Governmental activities: General Obligation Bonds Revenue Bonds Type A Financing Leases Compensated Absences Total Governmental activities long-term liabilities: Beginning Due Within Balance Additions Reductions Ending Balance One Year $ 5,560,000 $ 16,830,000 140,046 74,205 $ (860,000) $ (805,000) (117,648) 15,092 4,700,000 16,025,000 22,398 89,297 $ 410,000 825,000 22,398 $ 22,604,251 $ 15,092 $ (1,782,648) $ 20,836,695 $ 1,257,398 The annual debt service requirements for the District's bonds are as follows: Fiscal Year Ending 2024 2025 2026 2027 2028 2029-2033 2034-2038 2039-2043 2044-2048 2049 Totals: General Obligation and Revenue Bonds Principal Interest Totals $ 1,235,000 $ 563,127 $ 1,798,127 1,265,000 538,295 1,803,295 1,285,000 511,555 1,796,555 1,325,000 482,948 1,807,948 1,360,000 452,287 1,812,287 7,165,000 1,715,615 8,880,615 3,650,000 790,985 4,440,985 1,415,000 482,456 1,897,456 1,660,000 235,111 1,895,444 365,000 12,775 377,775 $ 20,725,000 $ 5,785,487 $ 26,510,487 28 86 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 NOTES TO BASIC FINANCIAL STATEMENTS FOR THE YEAR ENDED SEPTEMBER 30, 2023 NOTE 6. LONG-TERM DEBT- CONTINUED As of September 30, 2023. the District has one outstanding Type A financing lease. The leased asset is classified as a vehicle. The capitalized cost is $205,629 and amortized net book value is $45,928 at September 30, 2023. $34,446 of amortization expense has been included in depreciation expense for the year ended September 30, 2023. The following is a schedule of future debt service requirements for this lease: Fiscal Year Ending September 30 Principal Interest Totals 2024 $ 22,398 $ 442 $ 22,840 Total Financing Lease Debt Service: $ 22,398 $ 442 $ 22,840 NOTE 7. RISK MANAGEMENT The District is exposed to various risks of loss related to torts; theft of, damage to, and destruction of assets; business interruption; errors and omissions; injuries to employees; employee health benefits; and other claims of various nature. Commercial insurance is purchased for the risks of loss to which the District is exposed. Any losses reported but unsettled or incurred and not reported, are believed to be insignificant to the District's basic financial statements. Additionally, the District must operate in compliance with rules and regulations mandated for public water supply systems by federal and state governments. The District is subject to compliance oversight by the Texas Commission on Environmental Quality (TCEQ). NOTE 8. RETIREMENT PLAN The District provides retirement, disability, and death benefits for all of its full-time employees through a nontraditional defined benefit pension plan in the statewide Texas County and District Retirement System (TCDRS). The Board of Trustees of TCDRS is responsible for the administration of the statewide agent multiple - employer public employee retirement system consisting of nontraditional defined benefit pension plans. TCDRS in the aggregate issues a comprehensive annual financial report (CAFR) on a calendar -year basis. The CAFR is available upon written request from the TCDRS Board. of Trustees at P.O. Box 2034, Austin, Texas 78768-2034. The plan provisions are adopted by the governing body of the employer, within the options available in the Texas state statutes governing TCDRS (TCDRS Act). Members can retire at ages 60 and above with 10 or more years of service, with 30 years of service regardless of age, or when the sum of their age and years of service equals 80 or more. Members are vested after 10 years of service but must leave their accumulated contributions in the plan to receive any employer -financed benefit. Members who withdraw their personal contributions in a lump sum are not entitled to any amounts contributed by their employer. 29 87 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 NOTES TO BASIC FINANCIAL STATEMENTS FOR THE YEAR ENDED SEPTEMBER 30, 2023 NOTE 8. RETIREMENT PLAN - CONTINUED Benefit amounts are determined by the sum of the employee's contributions to the plan, with interest, and employer -financed monetary credits. The level of these monetary credits is adopted by the governing body of the employer within the actuarial constraints imposed by the TCDRS Act so that the resulting benefits can be expected to be adequately financed by the employer's commitment to contribute. At retirement, death, or disability, the benefit is calculated by converting the sum of the employee's accumulated contributions and the employer -financed monetary credits to a monthly annuity using annuity purchase rates prescribed by the TCDRS Act. Contributions The employer has elected the annually determined contribution rate (ADCR) plan provision of the TCDRS Act. The plan is funded by monthly contributions from both employee members and the employer based on the covered payroll of employee members. Under the TCDRS Act, the contribution rate of the employer is actuarially determined annually. The employer contributed using the actuarially determined rates of 10.92% and 11.80% for calendar years 2022 and 2023, respectively. Total employer contributions for the year ended September 30, 2023 was $158,013. The contribution rate payable by the employee members for calendar years 2022 and 2023 is the rate of 7.00% as adopted by the governing body of the employer. The employee contribution rate and the employer contribution rate may be changed by the governing body of the employer within the options available in the TCDRS Act. Actuarial Assumptions The total pension liability in the December 31, 2022 actuarial valuation was determined using the following actuarial assumptions: Valuation Date: December 31, 2022 Actuarial Cost Method: Entry Age (level percentage of pay) Asset Valuation Method: Smoothing Period 5 Years Recognition Method Level percentage of payroll, closed Corridor None Inflation: 2.50% Salary Increase: 4.70% Investment Rate of Return: 7.50% (net) 30 88 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 NOTES TO BASIC FINANCIAL STATEMENTS FOR THE YEAR ENDED SEPTEMBER 30, 2023 NOTE & RETIREMENT PLAN - CONTINUED Discount Rate The discount rate used to measure the total pension liability was 7.60%. There was no change in the discount rate since the previous year, The projection of cash flows used to determine the discount rate assumed that contributions from plan members and those of the contributing employers and the non -employer contributing entity are made at the statutorily required rates, Based on those assumptions, the pension plan's fiduciary net position was projected to be available to make all future benefit payments of current plan members, Therefore, the long-term expected rate of return on pension plan investments was applied to all periods of projected benefit payments to determine the total pension liability. The long-term rate of return on pension plan investments is 7.60%, The long-term expected rate of return on pension plan investments was determined using a building-block method in which best -estimates ranges of expected future real rates of return (expected returns, net of pension plan investment expense and inflation) are developed for each major asset class. These ranges are combined to produce the long-term expected rate of return by weighting the expected future real rates of return by the target asset allocation percentage and by adding expected inflation. Best estimates of geometric real rates of return for each major asset class included in the Systems target asset allocation as of December 31, 2022 are summarized below: Asset Class U.S. Equities Global Equities Intl Equities - Developed Markets Intl Equities - Emerging Markets Investment Grade Bonds Strategic Credit Direct Lending Distressed Debt REIT Equities Master Limited Partnerships Private Real Estate Partnerships Private Equity Hedge Funds Cash Equivalents Benchmark Dow Jones U.S. Total Stock Market Index MSCI World (net) Index MSCI World Ex USA (net) Index MSCI Emerging Markets (net) Index Bloomberg Barclays U.S. Aggregate Bond Index FTSE High -Yield Cash -Pay Capped Index S&P/LSTA Leveraged Loan Index Cambridge Associates Distressed Securities Index 67% FTSE NAREIT Equity REITs Index + 33% S&P Global REIT Index Alerian MLP Index Cambridge Associates Real Estate Index Cambridge Associates Global Private Equity & Venture Capital Index Hedge Fund Research, Inc. Fund of Funds Composite Index 90 -Day U.S. Treasury Target Allocation 11.50% 2.50% 5.00% 6.00% 3.00% 9.00% 16.00% 4.00% 2.00% 2.00% 6.00% 25.00% 6.00% 2.00% Geometric Real Rate of Return 4.95% 4.95% 4.95% 4.95% 2.40% 3.39% 6.95% 7.60% 4.15% 5.30% 5.70% 7.95% 2.90% 0.20% Discount Rate Sensitivity Analysis The following schedule shows the impact of the Net Pension Liability (Asset) if the discount rate used was 1% less than and 1% greater than the discount rate that was used (7.60%) in measuring the Net Pension Liability: Net pension liability (asset) $ 297,870 $ 31 89 of 131 (86,505) $ (409,514) Current 1% Decrease Discount Rate 1% Increase 6.60% 7.60% 8.60% Net pension liability (asset) $ 297,870 $ 31 89 of 131 (86,505) $ (409,514) January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 NOTES TO BASIC FINANCIAL STATEMENTS FOR THE YEAR ENDED SEPTEMBER 30, 2023 NOTE 8. RETIREMENT PLAN - CONTINUED Pension Assets/Liabilities, Pension Expense, and Deferred Outflows of Resources and Deferred Inflows of Resources Related to Pensions At September 30, 2023, the District reported ($86,505) for the net pension (asset) and pension expense of $100,074 related to the December 31, 2022 valuation. The breakdown of the components of the total pension liability, plan fiduciary net position, and the net pension liability follows: Changes in the Net Pension Liability (Asset) Increase (Decrease) Total Pension Liability (a) Plan Fiduciary Net Position (b) Net Pension Liab./(Asset) (a) - (b) Balances at 12/31/2021: Changes for the year: Service cost Interest Effect of plan changes Effect of economic/demographic gains or losses Effect of assumptions changes or inputs Refund of contributions Benefit payments Administrative expenses Member contributions Net investment income Employer contributions Other changes Balances at 12/31/2022: $ 2,507,319 $ 233,536 205,110 (194,016) (53,830) (31,818) 2,745,392 $ $ 2,666,301 $ (238,073) 233,536 205,110 (194,016) (53,830) (31,818) (1,613) 1,613 95,508 (95,508) (174,486) 174,486 148,993 (148,993) 24,660 (24,660) 2,752,806 $ (86,505) The District reported deferred outflows of resources and deferred inflows of resources related to the pension from the following sources: Deferred Inflows / Outflows of Resources Difference between expected and actual experience Changes of assumptions Net difference between projected and actual earnings Contributions subsequent to the measurement date Totals: $120,444 reported as deferred outflow of resources Deferred Inflows Deferred Outflows of Resources of Resources $ 145,512 $ N/A 32,269 67,842 93,072 120,444 $ 145,512 $ 313,627 for contributions made subsequent to the measurement date will be recognized as an addition to the net pension asset in the 2023 measurement year. 32 90 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 NOTES TO BASIC FINANCIAL STATEMENTS FOR THE YEAR ENDED SEPTEMBER 30, 2023 NOTE 8. RETIREMENT PLAN - CONTINUED The net amounts of the employer's balances of deferred outflows and inflows of resources related to pensions will be recognized in pension expense as follows: Fiscal Year Ending: 2024 $ (23,477) 2025 (5,646) 2026 (1,191) 2027 77,985 Thereafter $ 47,671 NOTE 9. OTHER POST -EMPLOYMENT BENEFITS Plan. Description The District participates in the retiree Group Term Life program for the Texas County & District Retirement System (TCDRS), which is a statewide, multiple -employer, public employee retirement system. All full and part-time non -temporary employees participate in the plan, regardless of the number of hours they work in a year and are eligible for the TCDRS pension plan. Only employers that have elected participation in the retiree Group Term Life program are includedin the OPER plan. The planprovides a $5,000 post-retirementdeath benefit to beneficiaries of service retirees and disability retirees of employers that have elected participation in the retiree GTL program. The OPEB benefit is a fixed $5,000 lump -sum benefit. No future increases are assumed in. the $5,000 benefit amount. Benefit terms are established under the TCDRS Act. Participation in the retiree GTL program is optional and the employer may elect to opt out of (or opt into) coverage as of January 1 each year. The District's contribution rate for the retiree GTL program is calculated annually on an actuarial basis, and is equal to the cost of providing a one-year deal benefit equal to $5,000. Membership information is shown in the chart below: Inactive employees or beneficiaries currently receiving benefits: 3 Inactive employees entitled, but not yet receiving benefits: 5 Active employees: 15 Total: 23 Total OPEB Liability The District's total OPEB liability was determined by an actuarial valuation dated December 31, 2022. Estimates include assumptions about future employment, mortality, and the healthcare cost trend. Amounts determined regarding the funded status of the plan and the annual required contributions (ARC) of the employer are subject to continual revisions as actual results are compared with past expectations and new estimates are made about the future. 33 91 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 NOTES TO BASIC FINANCIAL STATEMENTS FOR THE YEAR ENDED SEPTEMBER 30, 2023 NOTE 9. OTHER POST -EMPLOYMENT BENEFITS - CONTINUED Below is a schedule of significant assumptions used to estimate the District's ARC: Valuation Date: December 31, 2022 Amortization Method: Straight -Line Over Expected Working Life Discount Rate: 3.72% Disability: Custom rates based on TCDRS experience Mortality: Depositing Members 135% of PUB -2010 General Employees Amount -Weighted Mortality Table for males and 120% of the General Employees Amount -Weighted Mortality Table for females, both projected with 100% of the MP -2021 Ultimate scale after 2010. Retirees/Beneficiaries 135% of PUB -2010 General Healthy Retirees Amount -Weighted Mortality Table for males and 120% of the General Healthy Retirees Amount -Weighted Mortality Table for females, both projected with 100% of the MP -2021 Ultimate scale after 2010. Disabled Retirees 160% of PUB -2010 General Disabled Retirees Amount -Weighted Mortality Table for males and 120% of the General Disabled Retirees Amount -Weighted Mortality Table for females, both projected with 100% of the MP -2021 Ultimate scale after 2010. Discount Rate The discount rate is based on a yield or index for 20 -year, tax-exempt general obligation municipal bonds with an average rating of AA/Aa or better for benefits not covered by plan assets. The 20 Year Bond GO Index published by bondbuyer.com was used in determining the discount rate used to measure the Total OPEB Liability as of December 31, 2022 (measurement date under GASB 75). At this date, the discount rate was 3.72%. Sensitivity of the Total OPEB Liability to Changes in the Discount Rate The following presents the District's Total OPEB Liability if it were calculated using a discount rate that is 1% point lower (2.72%) or 1% point higher (4.72%) than the current rate, for measurement period ended December 31, 2022: Total OPEB liability $ 29,831 $ 34 92 of 131 24,460 $ 20,269 Current 1% Decrease Discount Rate 1% Increase 2.72% 3.72% 4.72% Total OPEB liability $ 29,831 $ 34 92 of 131 24,460 $ 20,269 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 NOTES TO BASIC FINANCIAL STATEMENTS FOR THE YEAR ENDED SEPTEMBER 30, 2023 NOTE 9. OTHER POST -EMPLOYMENT BENEFITS - CONTINUED OPEB Expense and Deferred Outflows/Inflows of Resources Related to OPEB For the fiscal year ended September 30, 2023, the District recognized expense related to OPEB of $2,964. As of September 30, 2023, the District reported deferred inflows of resources related to OPEB from the following sources: Deferred Inflows / Outflows of Resources Deferred Inflows Deferred Outflows of Resources of Resources Difference between expected and actual experience $ 7,219 $ - Changes of assumptions 8,895 5,489 Net difference between projected and actual earnings - - Contributions subsequent to the measurement date N/A 2,042 Totals: $ 16,114 $ 7,531 The $2,042 contributions made after the measurement date of the total OPEB liability but before the end of the District's reporting period will be recognized as a reduction of the total OPEB liability in the subsequent fiscal period. The other amounts reported as deferred inflows/outflows of resources related to OPEB will be recognized in OPEB expense as follows: Fiscal Year Ending: 2024 2025 2026 2027 Thereafter NOTE 10. SUBSEQUENT EVENTS (2,078) (2,170) (1,686) (2,407) (2,284) $ (10,625) The District has evaluated all events and transactions after September 30, 2023 up through the audit report date, which is the date the financial statements were issued. The District has no subsequent events to disclose. 35 93 of 131 January 17, 2024 Regular Meeting Agenda Packet REQUIRED SUPPLEMENTARY INFORMATION 94 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 Schedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual - General Fund For the Year Ended September 30, 2023 Revenues Water charges Wastewater charges Property taxes Intergovernmental Late charges Rental income Inspections and other charges for services Other revenue Investment earnings Total revenues Expenditures Current: Water Wastewater Administration Fire Non -departmental Board of directors Capital outlays Debt service: Principal retirement Interest and fees Total expenditures Excess of revenues over (under) expenditures Other financing sources (uses) Proceeds from sold assets Transfers (out) Total other financing sources (uses) Net changes in fund balances Fund balances - beginning Fund balances - ending Actual Original Budget Final Budget Amounts $ 6,710,979 3,899,686 1,346,135 145,029 78,000 14,146 8,058 7,000 20,000 $ 7,142,255 $ 8,001,954 3,770,000 3,845,076 1,346,135 1,355,148 145,029 151,357 78,000 77,201 37,179 45,179 8,058 4,100 7,000 17,432 380,000 397,122 12,229,033 12,913,656 13,894,570 Variance with Final Budget - Positive (Negative) $ 859,699 75,076 9,013 6,328 (799) 8,000 (3,958) 10,432 17,122 980,914 4,063,174 4,023,839 4,157,215 (133,376) 1,534,411 1,537,794 1,460,607 77,187 1,508,250 1,495,467 1,474,970 20,497 978,893 978,893 978,435 458 116,740 74,940 68,637 6,303 11,750 2,785 2,742 43 2,647,000 3,934,346 3,553,442 380,904 117,648 117,648 117,645 3 3,271 3,271 3,305 (34) 10,981,137 12,168,983 11,816,999 351,984 1,247,896 744,673 2,077,571 1,332,898 25,000 (1,845,796) (1,820,796) (572,900) 14,107,588 $ 13,534,688 50,000 (1,845,796) (1,795,796) (1,051,123) 14,107,588 $ 13,056,465 110,979 60,979 (1,573,226) 272,570 (1,462,247) 333,549 615,324 $ 1,666,447 14,107,588 $ 14,722,912 The accompanying notes are an integral part of these financial statements. 36 95 of 131 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 SCHEDULE OF CHANGES IN NET PENSION LIABILITY AND RELATED RATIOS (LAST TEN MEASUREMENT YEARS) TEXAS COUNTY AND DISTRICT RETIREMENT SYSTEM FOR THE YEAR ENDED SEPTEMBER 30, 2023 December 31, 2022 December December 31, 2021 31, 2020 Total Pension Liability Service cost $ 233,536 $ Interest on total pension liability 205,110 Effect of plan changes - Difference between expected and actual experience Effect of assumptions changes or inputs Benefit payments/Refund of contributions Net Change in Total Pension Liability Total pension liability, beginning Total pension liability, ending Fiduciary Net Position Employer contributions Member contributions Investment income (net of expenses) Benefit payments/Refund of contributions Administrative expenses Other Net Change in Fiduciary Net Position Fiduciary Net Position, beginning Fiduciary Net Position, ending Net pension liability / (asset), ending Fiduciary net position as a percentage of total pension liability Covered -employee payroll Net pension liability as a percentage of covered payroll 227,965 $ 175,365 (194,016) 27,195 7,163 (85,649) (19,329) 158,981 418,359 December December 31, 2019 31, 2018 183,103 $ 145,931 January 17, 2024 Regular Meeting Agenda Packet December December 31, 2017 31, 2016 164,365 $ 153,752 $ 121,767 100,515 21,485 8,770 13,723 127,091 (14,049) (16,533) (15,970) 463,561 278,369 252,020 December December 31, 2015 31, 2014 176,975 $ 200,990 $ 150,689 $ 170,600 83,553 57,230 41,351 27,449 (22,086) (25,170) 5,971 (1,695) (9,790) (11,320) (7,057) 7,686 (2,091) (1,902) (3,156) 239,634 246,339 164,418 187,836 2,507,320 2,088,961 1,625,400 1,347,031 1,095,011 855,377 609,038 444,620 256,784 $ 2,666,301 $ 2,507,320 $ 2,088,961 $ 1,625,400 $ 1,347,031 $ 1,095,011 $ 855,377 $ 609,038 148,993 95,508 (174,486) (85,649) (1,613) 24,660 127,080 98,621 475,821 (19,329) (1,485) 6,414 122,021 94,695 173,686 (14,049) (1,506) 6,162 103,641 80,287 212,168 (16,533) (1,278) 5,966 7,413 687,122 381,009 384,251 2,745,393 2,058,271 1,677,262 1,293,011 2,752,806 2,745,393 2,058,271 1,677,262 (86,505) $ (238,073) $ 30,690 $ (51,862) 94,803 73,880 (19,840) (15,970) (1,039) 4,667 136,501 1,156,510 102,802 79,868 126,587 (1,695) (769) 2,418 309,211 847,300 1,293,011 1,156,511 95,185 78,388 46,440 (2,091) (505) 19,889 237,306 609,994 847,300 $ 54,020 $ (61,500) $ 8,077 97,043 78,171 (15,011) (1,902) (394) (47) 157,860 452,134 609,994 444,620 93,694 74,784 18,561 (3,156) (285) (21) 183,577 268,557 452,134 (956) $ (7,514) 103.24% 109.50% 98.53% 103.19% 95.99% 105.62% 99.06% 100.16% 101.69% $ 1,364,405 $ 1,408,871 $ 1,352,780 $ 1,150,893 $ 1,055,433 $ 1,140,976 $ 1,119,822 $ 1,116,721 $ 1,068,342 -6.34% -16.90% 2.27% -4.51% 5.12% -5.39% 0.72% Note 1 - GASB 68 requires that information on this schedule be presented on the measurement date basis, which is on a calendar year basis. This schedule will also ultimately present the last ten years of information. The measurement year 2014 is the first year for which this information is available. 37 96 of 131 -0.09% -0.70% TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 SCHEDULE OF EMPLOYER PENSION CONTRIBUTIONS (LAST TEN FISCAL YEARS) TEXAS COUNTY AND DISTRICT RETIREMENT SYSTEM FOR THE YEAR ENDED SEPTEMBER 30, 2023 Contractually required contributions Contributions in relation to the contractually required contributions Contribution deficiency (excess) January 17, 2024 Regular Meeting Agenda Packet 2023 2022 2021 2020 2019 2018 2017 2016 2015 2014 $ 158,013 $ 148,867 $ 117,151 $ 97,337 $ 92,561 $ 102,802 $ 97,875 $ 97,043 $ 93,694 $ 84,476 158,013 148,867 122,021 103,641 94,803 102,802 97,875 97,043 93,694 198,219 $ $ $ (4,870) $ (6,304) $ (2,242) $ $ $ $ - $ (113,743) District's covered -employee payroll $ 1,364,747 $ 1,436,437 $ 1,352,780 $ 1,146,956 $ 1,055,433 $ 1,140,976 $ 1,119,822 $ 1,116,721 $ 1,068,342 $ 963,243 Contributions as a percentage of covered employee payroll 11.6% 10.4% 9.0% 9.0% 9.0% 9.0% 8.7% 8.7% 8.8% 20.6% GASB 68 requires that information on this schedule be presented on the District's fiscal year basis. 38 97 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 SCHEDULE OF CHANGES IN TOTAL OPEB LIABILITY AND RELATED RATIOS (LAST TEN MEASUREMENT YEARS) TEXAS COUNTY AND DISTRICT RETIREMENT SYSTEM FOR THE YEAR ENDED SEPTEMBER 30, 2023 December December December December December December 31, 2022 31, 2021 31, 2020 31, 2019 31, 2018 31, 2017 Total OPEB Liability Service cost $ 4,273 $ 4,121 $ 3,314 $ 2,241 $ 2,503 $ 2,889 Interest on total pension liability 771 736 771 778 669 595 Effect of plan changes - - Difference between expected and actual experience (3,949) (2,610) (2,345) (1,422) (678) (321) Effect of assumptions changes or inputs (9,745) 408 4,033 6,476 (2,704) 946 Benefit payments/Refund of contributions (136) - - - Net Change in Total OPEB Liability (8,786) 2,655 5,773 8,073 (210) 4,109 Total OPEB liability, beginning 33,246 Total OPEB liability, ending 30,591 24,818 16,745 16,955 12,846 $ 24,460 $ 33,246 $ 30,591 $ 24,818 $ 16,745 $ 16,955 Covered payroll $ 1,364,405 $ 1,408,871 $ 1,352,780 $ 1,150,893 $ 1,055,433 $ 1,140,976 Total OPEB liability as a percentage of covered payroll 1.79% 2.36% 2.26% 2.16% 1.59% 1.49% Note 1 - GASB 75 requires that information on this schedule be presented on the measurement date basis, which is on a calendar year basis. This schedule will also ultimately present the last ten years of information. The measurement year 2017 is the first year for which this information is available. 39 98 of 131 TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 SCHEDULE OF EMPLOYER OPEB CONTRIBUTIONS (LAST TEN FISCAL YEARS) TEXAS COUNTY AND DISTRICT RETIREMENT SYSTEM FOR THE YEAR ENDED SEPTEMBER 30, 2023 Contractually required contributions Contributions in relation to the contractually required contributions Contribution deficiency (excess) January 17, 2024 Regular Meeting Agenda Packet 2023 2022 2021 2020 2019 2018 $ 3,005 $ 3,964 $ 3,886 $ 4,552 $ 2,635 $ 2,673 3,005 3,964 3,886 4,552 2,635 2,673 $ - $ $ $ - $ $ District's covered -employee payroll $ 1,364,747 $ 1,436,437 $ 1,352,780 $ 1,146,956 $ 1,055,433 $ 1,140,976 Contributions as a percentage of covered employee payroll 0.22% 0.28% 0.29% 0.40% 0.25% 0.23% Note 1 - GASB 75 requires that information on this schedule be presented on the District's fiscal year basis. This schedule will also ultimately present the last ten years of information. 2018 is the first year for which this information is available. 40 99 of 131 January 17, 2024 Regular Meeting Agenda Packet OTHER SUPPLEMENTARY INFORMATION 100 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 TSI -1 SERVICES AND RATES SEPTEMBER 30, 2023 1. Services provided by the District: a) Retail Water b) Retail Wastewater c) Wholesale Water d) Wholesale Wastewater Treatment e) Fire Protection f) Irrigation g) Participates in regional system and/or wastewater service (other than emergency interconnect) 2. Retail service providers: Current Rates Water Base Rates Residential and Commercial Meter Size 5/8" 1" 1.5" 2" 3" 4" 6" Base Rate $20.26 $38.08 $67.54 $108.06 $204.80 $337.68 $675.38 Water Volumetric Rates Rates per 1,000 $4.60 $5.35 $6.19 $7.19 $8.36 Gallons 0 to 6,000 6,001 to 17,000 17,001 to 25,000 25,001 to 50,000 50,001 + Sewer Base Fee Residential* Base Rate $22.15 Sewer Volimetric Rates Rates per 1,000 $3.57 $5.09 $7.18 $10.22 Gallons 0 to 4,000 4,001 to 8,000 8,001 to 12,000 12,000 + Commercial** $22.15 $8.57 1,000 + *Effective October 1, 2016 Winter Averaging for Sewer Rates were adopted for Residential Customers. Residential sewer rates each year are based on average water usuage for the months of December, January, and February. **Commercial sewer usage is billed based on actual water usage per month NOTE: Water rates noted above were effective October 1, 2022 and the Wastewater rates effective April 1, 2023. District employs winter averaging for wastewater usage? Yes ***Total water and wastewater charges per 10,000 gallons usage (including surcharges) effective April 1, 2020 (based on 5/8" & 3/4") First 10,000 gallons used 10,000 $ Next 10,000 gallons used 20,000 $ Next 10,000 gallons used 30,000 $ Next 10,000 gallons used 40,000 $ Next 10,000 gallons used 50,000 $ Next 10,000 gallons used and subsequent 60,000 $ 140.41 196.43 263.33 335.23 407.13 490.73 *** The above sewer calculations are based on a Winter Average of 10,000 gallons per month. 41 101 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 TSI -1 SERVICES AND RATES SEPTEMBER 30, 2023 b) Retail service providers: number of retail water and/or wastewater* connections within the District as of the fiscal year end. Provide actual numbers and single family equivalents (ESFC). Meter Size Connections ESFC Active Total Active Factor ESFC's Unmetered - 1 Less than 3/4" 2,497 2,503 1 2,503 1" 707 702 3 1,755 1 1/2" 28 28 5 140 2" 105 105 8 840 3" 42 42 15 630 4" 17 17 25 425 6" 5 5 50 250 8" 1 1 80 80 10" - 115 Total Water 3,412 3,403 6,623 Total Wastewater 3,417 3,407 1 3,407 * Number of connections relates to water service if provided. Otherwise, the number of wastewater connections should be provided. Note: Total water connections does not include Fire Lines or Portable meters Note: "inactive" means that water and wastewater connections were made, but service is not being provided. Note: District provides wholesale services to the Town of Trophy Club through 1,443 connections 3. Total water consumption (in thousands) during the fiscal year: Gallons pumped into the system Gallons billed to customers Water accountability ratio 1,155, 952 1,049,905 90.83% 4. Standby Fees: Does the District assess standby fees? No For the most recent fiscal year, FY2023: Total Total Percentage Levy Collected Collected Debt Service $ 696,446 $ 690,063 99.00% Operations and Maintenance $ 1,345,535 $ 1,332,824 99.00% Have standby fees been levied in accordance with Water Code Section 49.231, thereby constituting a lien on property? No 5. Location of District: Counties in which District is located: Denton Tarrant Is the District located entirely in one county? No Is the District located within a city? Partially Cities in which District is located: Town of Trophy Club Town of Westlake Is District located within a city's extra territorial jurisdiction (ETJ)? Unknown ETJ's in which District is located: Unknown Is the general membership of the Board appointed by an office outside No the District? 42 102 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 TSI -2 General Fund Expenditures and Other Financing Uses Year End September 30, 2023 Current Year Prior Year 2023 2022 Administrative $ 1,546,349 $ 1,424,573 Water Operations 4,157,215 4,025,300 Wastewater Operations 1,460,607 1,530,667 Contribution to Trophy Club Fire Dept 978,435 918,658 Capital Outlay 3,553,442 2,000,049 Transfers Out and Debt Service 1,694,176 1,823,389 Total Expenditures $ 13,390,224 $ 11,722,636 Number of employees employed by the District: Full time Equivalents (FTEs) 14 15 Part time 0 0 '• The Town of Trophy Club handles the operations of the Fire Department based on an Interlocal Agreement with Trophy Club Municipal Utility District No.1. The District reimburses the annual Town's Fire Budget in equal monthly payments. 43 103 of 131 Funds January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 TSI -3 TEMPORARY INVESTMENTS September 30, 2023 Identification Interest Maturity Balance Accrued Interest Number Rate Date End of Year Paid Term Reserve Fund Prosperity Bank XXXXX7724 3.20% Demand $ 1,936,872 Paid monthly (Money Market) General Fund Prosperity Bank XXX8701 0.35% Demand $ 4,295,920 Paid monthly General Fund, Fire Fund, & GASB Reserves TexPool XXXXX0002 5.32% Demand $ 7,652,770 Paid daily Debt Service Fund TexPool XXXXX0003 5.32% Demand $ 85,835 Paid daily Debt Service -Revenue Bond Texpool XXXXX0013 5.32% Demand $ 39,137 Paid daily Revenue Bond Reserve Texpool XXXXX0014 5.32% Demand $ 942,343 Paid daily SWIFT Revenue Bond Debt Service Texpool XXXXX0017 5.32% Demand $ 11,714 Paid daily W&WW 19 Revenue Bond Construction Texpool XXXXX0018 5.32% Demand $ 1,179,059 Paid daily W&WW 19 Revenue Bond Debt Service Texpool XXXXX0020 5.32% Demand $ 6,476 Paid daily SWIFT Revenue Bond Escrow Account Bank of Texas BOKF 82-1747-01-1 5.32% Demand $ 817,017 Paid daily TCEQ Revenue Bond Escrow Account Bank of Texas BOKF 82-3288-01-4 4.76% Demand $ Paid daily Total - All Funds $ 16,967,143 44 104 of 131 Taxes receivable beginning of year 2022 tax levy Total to be accounted for Less collections and adjustments: Current year Prior years Total to be accounted for Taxes receivable, end of year Taxes receivable by year 1999 and prior 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Property valuations (in 000's) Land Improvements Personal property Exemptions Tax rate per $100 valuation Operations Fire department Debt service Tax rate per $100 valuation Tax levy: January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 TSI -4 TAXES LEVIED AND RECEIVABLE SEPTEMBER 30, 2023 General Fund Operations $ 1,288 84,337 85,626 (84,163) 626 Fire Debt Total Service $ 12,891 $ 1,207,118 1,220,009 (1,204,621) (8,521) (83,537) (1,213,141) 14,180 $ 1,291,455 Total 7,294 $ 21,474 668,475 1,305,635 (1,288,784) (7,895) $ 2,089 $ 6,868 $ (1,296,678) 675,769 1,959,930 1,981,403 (667,092) (1,955,876) ( 5,292) (13,187) 8,956 $ (672,384) (1,969,063) 3,384 $ 12,341 $ - $ $ - $ $ $ $ - $ - $ - $ $ $ - $ - $ - $ $ $ - $ - $ $ $ - $ - $ $ $ $ - $ - $ - $ $ $ - $ $ - $ $ $ $ - $ - $ - $ $ $ $ - $ $ $ $ - $ - $ $ $ $ - $ - $ $ - $ 33 $ 410 $ 443 $ 289 $ 732 $ 37 $ 414 $ 451 $ 212 $ 663 $ 42 $ 445 $ 487 $ 83 $ 570 $ 54 $ 501 $ 555 $ 210 $ 765 $ 91 $ 471 $ 562 $ 251 $ 813 $ 18 $ 274 $ 292 $ 206 $ 498 $ 17 $ 281 $ 298 $ 183 $ 481 $ 63 $ 546 $ 609 $ 347 $ 956 $ 104 $ 914 $ 1,018 $ 562 $ 1,580 $ (237) $ (2,132) $ (2,369) $ (1,198) $ (3,567) $ 134 $ 1,228 $ 1,362 $ 680 $ 2,042 $ 150 $ 1,399 $ 1,549 $ 761 $ 2,310 $ 174 $ 2,497 $ 2,671 $ 1,383 $ 4,054 $ 680 $ 7,248 $ 7,928 $ 3,969 $ 11,897 FY FY FY FY FY 21/22 20/21 19/20 18/19 17/18 $ 963,053 $ 824,647 $ 823,775 $ 800,425 $ 667,906 1,268,107 1,239,177 1,159,708 1,042,035 981,366 116,148 108,942 101,998 109,764 103,985 (260,389) (162,059) (152,776) (140,704) (81,906) $ 2,086,919 $ 2,010,707 $ 1,932,705 $ 1,811,520 $ 1,671,351 0.00687 0.00709 0.00748 0.00765 0.00788 0.06412 0.06476 0.06738 0.06719 0.06870 0.03489 0.03589 0.03787 0.04134 0.04363 0.10588 0.10774 0.11273 0.11618 0.12021 $ 2,039,976 $ 2,056,855 $ 2,052,305 $ 1,919,984 $ 1,870,008 Percent of taxes collected to taxes levied 99.85% 99.71% 99.76% 99.48% 99.75% 45 105 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 TSI -4 TAXES LEVIED AND RECEIVABLE SEPTEMBER 30, 2023 Tax rate for any other special district which (a) encompass less than a county, (b) provides water, wastewater collection, drainage or roads to property in the district and (c) taxes property in the district. Name of Special Districts Service Provided Tax Rate None $ Total rate(s) of special districts $ Tax rates (per $100 net taxable value) for all overlapping jurisdictions. Include any taxing entities which overlap 10% or more of the District. Denton County Tarrant County County Denton/Tarrant 0.217543 0.224 City Town of Trophy Club 0.434799 0.434799 School District Northwest ISD/Carroll ISD 1.2746 1.2188 1.926942 1.877599 Special Districts not included above Hospital District 0 0.224429 Tarrant County Comm. College 0 0.13017 Total Special Districts 0 0.354599 MUD 1 District Tax Rate 0.09134 0.09134 Total Overlapping Tax District 2.018282 2.323538 46 106 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1 TSI -5 LONG-TERM DEBT SERVICE REQUIREMENTS - BY YEARS SEPTEMBER 30, 2023 Due During Fiscal All Bonded Debt Series Principal Due Interest Due Years Ending 1 -Sep Mar 1/ Sep 1 Total 2024 $ 1,235,000 $ 563,128 $ 1,798,128 2025 1,265,000 538,296 1,803,296 2026 1,285, 000 511,556 1,796,556 2027 1,325,000 482,948 1,807,948 2028 1,360,000 452,287 1,812,287 2029 1,400,000 419,307 1,819,307 2030 1,440,000 383,809 1,823,809 2031 1,485,000 344,703 1,829,703 2032 1,400,000 304,049 1,704,049 2033 1,440, 000 263,749 1,703,749 2034 1,500,000 221,124 1,721,124 2035 1,130,000 175,675 1,305,675 2036 515,000 142,612 657,612 2037 250,000 129,538 379,538 2038 255,000 122,038 377,038 2039 265,000 114,069 379,069 2040 275,000 105,788 380,788 2041 285,000 96,850 381,850 2042 290,000 87,588 377,588 2043 300,000 78,163 378,163 2044 310,000 68,413 378,413 2045 320,000 58,338 378,338 2046 330,000 47,538 377,538 2047 345,000 36,400 381,400 2048 355,000 24,756 379,756 2049 365,000 12,775 377,775 $ 20,725,000 $ 5,785,489 $ 26,510,489 Due During Fiscal Years Ending General Obligation Bonds - Series 2014 (5,765,000) Principal Due Interest Due 1 -Sep Mar 1/ Sep 1 Total 2024 290,000 112,313 402,313 2025 295,000 105,063 400,063 2026 305,000 97,688 402,688 2027 315,000 90,063 405,063 2028 325,000 81,400 406,400 2029 335,000 72,463 407,463 2030 345,000 62,413 407,413 2031 360,000 51,200 411,200 2032 370,000 39,500 409,500 2033 385,000 27,475 412,475 2034 400,000 14,000 414,000 $ 3,725,000 $ 753,575 $ 4,478,575 47 107 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1 TSI -5 LONG-TERM DEBT SERVICE REQUIREMENTS - BY YEARS (CONTINUED) SEPTEMBER 30, 2023 Unlimited Tax Refunding Bonds, Series 2020 Refunded Bond: M1 Series 2010 (1,220,000) Due During Fiscal Principal Due Interest Due Years Ending 1 -Sep Mar 1/ Sep 1 Total 2024 120,000 12,675 132,675 2025 120,000 11,115 131,115 2026 115,000 9,555 124,555 2027 120,000 8,060 128,060 2028 125,000 6,500 131,500 2029 125,000 4,875 129,875 2030 125,000 3,250 128,250 2031 125,000 1,625 126,625 Due During Fiscal Years Ending $ 975,000 $ 57,655 $ 1,032,655 Revenue Bonds - Series 2015 (9,230,000) Principal Due Interest Due 1 -Sep Mar 1/ Sep 1 Total 2024 435,000 175,838 610,838 2025 450,000 167,138 617,138 2026 460,000 157,013 617,013 2027 475,000 145,513 620,513 2028 490,000 133,638 623,638 2029 510,000 120,163 630,163 2030 525,000 106,138 631,138 2031 545,000 90,388 635,388 2032 565,000 74,038 639,038 2033 585,000 57,088 642,088 2034 610,000 39,538 649,538 2035 630,000 20,475 650,475 Due During Fiscal Years Ending $ 6,280,000 $ 1,286,963 $ 7,566,963 Revenue Bonds - Series 2016 (4,635,000) Principal Due Interest Due 1 -Sep Mar 1/ Sep 1 Total 2024 220,000 53,115 273,115 2025 225,000 50,893 275,893 2026 225,000 48,463 273,463 2027 230,000 45,875 275,875 2028 230,000 42,862 272,862 2029 235,000 39,619 274,619 2030 240,000 35,671 275,671 2031 245,000 31,303 276,303 2032 250,000 26,624 276,624 2033 250,000 21,749 271,749 2034 260,000 16,749 276,749 2035 265,000 11,262 276,262 2036 270,000 5,724 275,724 $ 3,145,000 $ 429,909 $ 3,574,909 48 108 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO.1 TSI -5 LONG-TERM DEBT SERVICE REQUIREMENTS - BY YEARS (CONTINUED) SEPTEMBER 30, 2023 Revenue Bonds - Series 2019 (7,080,000) Due During Fiscal Principal Due Interest Due Years Ending 1 -Sep Mar 1/ Sep 1 Total 2024 170,000 209,188 379,188 2025 175,000 204,088 379,088 2026 180,000 198,838 378,838 2027 185,000 193,438 378,438 2028 190,000 187,888 377,888 2029 195,000 182,188 377,188 2030 205,000 176,338 381,338 2031 210,000 170,188 380,188 2032 215,000 163,888 378,888 2033 220,000 157,438 377,438 2034 230,000 150,838 380,838 2035 235,000 143,938 378,938 2036 245,000 136,888 381,888 2037 250,000 129,538 379,538 2038 255,000 122,038 377,038 2039 265,000 114,069 379,069 2040 275,000 105,788 380,788 2041 285,000 96,850 381,850 2042 290,000 87,588 377,588 2043 300,000 78,163 378,163 2044 310,000 68,413 378,413 2045 320,000 58,338 378,338 2046 330,000 47,538 377,538 2047 345,000 36,400 381,400 2048 355,000 24,756 379,756 2049 365,000 12,775 377,775 $ 6,600,000 $ 3,257,388 $ 9,857,388 49 109 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 TSI -6 CHANGES IN LONG-TERM BONDED DEBT SEPTEMBER 30, 2023 Series 2012 Series 2013 Series 2014 M1 GO Series 2020 Series 2015 Series 2016 Series 2019 GO Bonds GO Bonds GO Bonds GO Bonds Revenue Bonds Revenue Bonds Revenue Bonds Total Interest rate 2.00-3.00% 2.00-3.50% 1.50-3.50% 1.3% 2.0-3.25% 0.53-2.12% 3.00-3.50% Date interest payable 3/1 & 9/1 3/1 & 9/1 3/1 & 9/1 3/1 &9/1 3/1 & 9/1 3/1 & 9/1 3/1 & 9/1 Maturity date 9/1/2023 9/1/2023 9/1/2034 9/1/2031 9/1/2035 9/1/2036 9/1/2049 Bonds outstanding at beginning of year $ 250,000 $ 215,000 $ 4,005,000 $ 1,090,000 $ 6,700,000 $ 3,365,000 $ 6,765,000 $ 22,390,000 Retirements of principal $ 250,000 $ 215,000 $ 280,000 $ 115,000 $ 420,000 $ 220,000 $ 165,000 $ 1,665,000 Bonds outstanding at end of fiscal year $ - $ $ 3,725,000 $ 975,000 $ 6,280,000 $ 3,145,000 $ 6,600,000 $ 20,725,000 Retirements of interest $ 7,500 $ 7,525 $ 118,613 $ 14,170 $ 184,238 $ 55,139 $ 214,138 $ 601,323 Paying agent's name & city: The Bank of New The Bank of New The Bank of TX JP Morgan The Bank of TX The Bank of TX The Bank of TX York Mellon York Mellon Corporate Trust Chase Corporate Trust Corporate Trust Corporate Trust Newark, NJ Newark, NJ Austin, TX New York, NY Austin, TX Austin, TX Austin, TX Bond Authority General Obligation Bonds Amount authorized by voters $ 34,859,217 Amount issued $ 34,855,000 Remaining to be issued $ 4,217 The general obligation bonds were authorized on October 7, 1975 Debt Service Fund cash and cash equivalents balance as of September 30, 2023: $ 1,085,505 Average annual debt service payment (principal & interest) for remaining term of debt: $ 1,811,527 50 110 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 TS1-7 COMPARATIVE SCHEDULES OF REVENUES AND EXPENDITURES -FIVE YEARS GENERAL FUND SEPTEMBER 30, 2023 Amounts Percentage REVENUE 2023 2022 2021 2020 2019 2023 2022 2021 2020 2019 Ad valorem property taxes $ 1,355,148 $ 1,434,197 $ 1,378,844 $ 1,371,466 $ 1,231,580 9.7% 11.3% 12.5% 12.6% 11.6% Water and wastewater charges 11,847,030 10,809,305 9,222,445 9,109,566 8,539,760 84.6% 85.0% 83.7% 83.6% 80.7% Inspection and tap fees 4,100 8,099 12,500 20,300 6,900 0.0% 0.1% 0.1% 0.2% 0.1% Interest earned 397,122 66,251 18,386 81,518 139,388 2.8% 0.5% 0.2% 0.7% 1.3% Debt proceeds - - (7,080) 0.0% 0.0% 0.0% 0.0% -0.1% Transfers In - - 32,080 0.0% 0.0% 0.0% 0.0% 0.3% Proceeds from Sale of Assets 110,979 21,001 23,975 12,520 52,600 0.8% 0.2% 0.2% 0.1% 0.5% Capital Lease Financing 204,004 0.0% 0.0% 0.0% 0.0% 1.9% Miscellaneous and other 291,169 377,827 359,189 300,746 376,822 2.1% 3.0% 3.3% 2.8% 3.6% Total revenue $ 14,005,548 $ 12,716,680 $ 11,015,339 $ 10,896,116 $10,576,054 100.0% 100.0% 100.0% 100.0% 100.0% EXPENDITURES Administrative $ 1,546,349 $ 1,424,573 $ 1,405,997 $ 1,388,918 $ 1,304,577 11.5% 12.2% 13.2% 14.4% 13.4% Water operations 4,157,215 4,025,300 2,982,828 2,919,210 3,001,947 31.0% 34.3% 28.1% 30.3% 30.9% Wastewater operations 1,460,607 1,530,667 1,508,659 1,252,392 1,048,445 10.9% 13.1% 14.2% 13.0% 10.8% Contribution to Trophy Club Fire Dept 978,435 918,658 839,816 738,348 692,347 7.3% 7.8% 7.9% 7.7% 7.1% Capital outlay 3,553,442 2,000,049 1,034,637 931,856 2,036,172 26.5% 17.1% 9.7% 9.7% 21.0% Transfers Out and Debt Service 1,694,176 1,823,389 2,858,279 2,405,409 1,619,062 12.7% 15.6% 26.9% 25.0% 16.7% Total expenditures $ 13,390,224 $ 11,722,635 $ 10,630,215 $ 9,636,133 $ 9,702,550 100% 100.0% 100.0% 100.0% 100.0% Excess (deficiency) of revenues over (under) expenditures $ 615,324 $ 994,045 $ 385,123 $ 1,259,983 $ 873,504 4.4% 7.8% Total active retail water and/or wastewater connections 3,407 3,379 3,374 3,371 3,330 51 111 of 131 3.5% 11.6% 8.3% January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 TSI -7 COMPARATIVE SCHEDULES OF REVENUES AND EXPENDITURES -FIVE YEARS (Continued) DEBT SERVICE FUND SEPTEMBER 30, 2023 Amounts Percentage REVENUE 2023 2022 2021 2020 2019 2023 2022 2021 2020 2019 Ad valorem property taxes $ 701,238 $ 704,644 $ 688,651 $ 693,604 $ 677,477 30.2% 30.8% 30.5% 31.0% 31.8% Penalties and interest 2,010 0.0% 0.0% 0.0% 0.0% 0.1% Transfers in from other funds 1,573,226 1,574,226 1,565,786 1,535,035 1,413,156 67.7% 68.8% 69.4% 68.6% 66.3% Interest earned 49,191 7,980 286 6,776 37,255 2.1% 0.3% 0.0% 0.3% 1.7% Miscellaneous and other - - - 1,220 - 0.0% 0.0% 0.0% 0.1% 0.0% Total revenue 2,323,655 2,286,850 2,254,723 2,236,635 2,129,898 100.0% 100.0% 100.0% 100.0% 100.0% EXPENDITURES Principal retirement Interest and fiscal charges Bond admin fees Total expenditures Excess (deficiency) of revenues over (under) expenditures 1,665,000 1,625,000 1,580,000 1,370,000 1,350,000 73.4% 71.8% 70.2% 62.0% 71.2% 601,296 636,539 665,987 837,477 543,396 26.5% 28.1% 29.6% 37.9% 28.7% 2,100 2,600 3,350 3,292 2,950 0.1% 0.1% 0.1% 0.1% 0.2% 2,268,396 2,264,139 2,249,337 2,210,769 1,896,346 100.0% 100.0% 100.0% 100.0% 100.0% $ 55,259 $ 22,711 $ 5,386 $ 25,865 $ 233,552 2.4% 1.0% 0.2% 1.2% 11.0% 52 112 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 TSI -8 BOARD MEMBERS, KEY PERSONNEL, AND CONSULTANTS September 30, 2023 Complete District Mailing Address: 100 Municipal Drive, Trophy Club, Texas 76262 District Business Telephone Number: Metro (682) 831-4600 Limit of Fees of Office that a Director may receive during a fiscal year: $0 (Set by Board Resolution - TWC Section 49.060) Name and Address Board Members: Term of Office Fees of Expense Title Elected/Expires Office Paid Reimbursements at or Date Hired FY2023 FY2023 Year End Kevin Carr 15 Edgemere Drive Trophy Club, TX 76262 11/20-5/24 $ $ President William Rose 219 Inverness Drive Trophy Club, TX 76262 Doug Harper 16 Fair Green Drive Trophy Club, TX 76262 Ben Brewster 222 Fresh Meadow Drive Trophy Club, TX 76262 Tracey Hunter 19 Monterrey Drive Trophy Club, TX 76262 11/20-5/24 $ 5/22-5/26 $ 5/22-5/26 $ 5/22-5/26 $ 53 113 of 131 Director - Secretary/Treasurer - Vice -President Director January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 TSI -8 BOARD MEMBERS, KEY PERSONNEL, AND CONSULTANTS (Continued) SEPTEMBER 30, 2023 Name and Address Consultants/Legal: Date of Contract Total Paid Out Type of or Vendor Created FY 2023 Vendor Denton Central Appraisal District P.O. Box 2816 Denton, TX 76202 4/1/1981 $ 8,655 Appraiser Tarrant Appraisal District 2500 Handley-Ederville Rd. Fort Worth, TX 76262 10/1/2007 $ 2,609 Appraiser Rod L Abbott CPA LLC P.O. Box 75 Tom Bean, Tx 75489 8/27/2020 $ 22,064 Halff Associates, Inc. P.O. Box 678316 Dallas, TX 75267-8316 1/1/2017 $ 94,679 Auditors Engineers Garver P.O. Box 736556 Dallas, TX 75373-6556 12/3/2021 $ 217,154 Engineers Bickerstaff Heath Delgado Acosta LLP 901 S. Mopac Expressway Building #1, Suite 300 Austin, TX 78746 4/1/2023 $ 19,993 Legal Counsel McLean & Howard, L.L.P. 901 S. Mopac Expressway Building 2, Suite 225 Austin, TX 78746 3/1/2017 $ 10,170 Legal/Bond Counsel Whitaker Chalk Swindle & Schwartz PLLC 301 Commerce St, Suite 3500 Fort Worth, TX 76102-4186 4/30/2018 $ 1,100 Legal Counsel New Gen Strategies & Solutions 1300 E. Lookout Dr. Suite 100 Richardson, TX 75082 7/1/2013 $ 5,058 Rate Consultant 54 114 of 131 TROPHY CLUB MUNICIPAL UTILITY DISTRICT January 17, 2024 Regular Meeting Agenda Packet STAFF REPORT AGENDA ITEM: Consider and act regarding approval of Contract No. 2024011701 with Insituform Technologies, LLC for wastewater collection system repairs. DESCRIPTION: This project consists of all labor, materials, equipment, and services necessary to complete wastewater collection system point repairs identified during the FY 2023 annual wastewater system analysis. Pricing for this project was requested utilizing Buyboard Cooperative Purchasing Contract No. 635-21. ATTACHMENTS: Insituform Technologies, LLC Proposal RECOMMENDATION: Staff recommend awarding Contract No. 2024011701 for wastewater collection system repairs to Insituform Technologies, LLC for an amount not to exceed $370,770.00 and authorize the General Manager to execute any necessary documents. 115 of 131 Insituform Technologies; LLC An Aegion Company January 11, 2024 Mr. Alan Fourmentin Trophy Club MUD 100 Municipal Dr. Trophy Club, TX 76262 Project Name: 1103 Postwood Dr. Corinth, TX 76210 www.insituform.com January 17, 2024 Regular Meeting Agenda Packet Insituform Technologies, LLC is a subsidiary of Aegion Corporation Name: Tim Peterie Fax: 940-498-0265 Phone: 214-317-0950 Email: tpeterie@insituform.com SF#: SO -00120391 BuyBoard Proposal Trophy Club, TX — Basin 14 Sewer Repairs 6"-12" Sewer Point Repairs by Open Cut Excavation INSITUFORM TECHNOLOGIES, LLC herein proposes to furnish all labor, materials, equipment, and services necessary to reconstruct the referenced project (as detailed by the information provided by Trophy Club) utilizing the Texas Statewide Cooperative Purchasing Contract #635-21 administered through the BuyBoard. ASSUMPTIONS AND QUALIFICATIONS Insituform Technologies, LLC will work with the Trophy Club MUD to make all practical attempts to notify the affected residents of this sanitary sewer line repair project and the expected inconveniences. The pricing in this proposal assumes that all Technical Specifications set forth by the BuyBoard will be strictly adhered to. INSITUFORM TECHNOLOGIES, LLC will supply Trophy Club MUD a 2 -year Maintenance Bond, Performance and Payment Bonds, and Certificate of Insurance following acceptance of this proposal. Water shall be provided at no cost to Insituform Technologies, LLC for all construction phases of this project. Insituform Technologies, Inc. will follow all required deposit, backflow prevention, and metering procedures. Special Notes: 1. The pricing in this proposal takes into account current material prices and are only good for 30 days. If material prices change after 30 days and prior to approval, price adjustments may be necessary. 2. All quantities are estimates from above ground assessment of the project and review of the videos provided. The final invoice will reflect actual quantities for all items. 3. Trophy Club MUD will be responsible for all permits and application fees, material testing, and impact fees as necessary. 4. A contingency allowance has been included to account for unforeseen conditions or changes in scope. This amount will not be used without prior approval from Trophy Club MUD. 5. Some point repairs may only require internal means for repairs, but none have been confirmed by the videos provided. A full assessment of the repairs will be made after release of the project and if internal means can be utilized effectively or with a cost savings, then a change to the contract will be agreed upon prior to completing said repairs. 6. Two locations from the scope list provided could not be priced due to extraordinary access issues and should be treated separately by Trophy Club MUD. Those locations are 14 Skyline Dr and 1600 Solana Blvd. 116 of 131 January 17, 2024 Regular Meeting Agenda Packet PROPOSAL PRICING PAY Travel & Mobilization — Excavation Crew QTY U/M UNIT ESTIMATED ITEM DESCRIPTION 19 EA PRICE AMOUNT NO. 6"-10" Point Repair (8'-12' deep) 7 EA $5,500.00 $38,500.00 1 Travel & Mobilization — Excavation Crew 1 EA $7,500.00 $7,500.00 2 6"-10" Point Repair (0'-8' deep)_ 19 EA $5,000.00 $95,000.00 3 6"-10" Point Repair (8'-12' deep) 7 EA $5,500.00 $38,500.00 4 6"-10" Point Repair (12'-15' deep) 1 EA $15,500.00 $15,500.00 5 Trench Safety 250 LF $20.00 $5,000.00 6 Granular Backfill 52 Ton $75.00 $3,900.00 7 Protect Buried Utilities, Water Lines, or Sprinklers — Multiple Locations 15 EA $1,150.00 $17,250.00 8 21 Troon Dr— Protect Mailbox & Sprinklers 1 LS $1,700.00 $1,700.00 9 33 Troon Dr— Protect Mailbox, Retaining Wall, & R/R Brick Sidewalk 1 LS $5,200.00 $5,200.00 10 1 Turnbury Ct — Protect Retaining Wall 1 LS $2,400.00 $2,400.00 11 22 Cypress — Protect Light Pole 1 LS $5,100.00 $5,100.00 12 30 Cypress — Protect Light Pole and Access to Site 1 LS $8,200.00 $8,200.00 13 101 Panorama — Extra Utility Protection 1 LS $1,900.00 _ $1,900.00 14 Field Management, Access Issues, Hand Excavation (Per Point Repair) 27 EA $3,285.00 $88,695.00 15 Repair/Rehab 8" Concrete Pavement 75 SY $275.00 $20,625.00 16 Repair/Rehab 6" Concrete Driveway 120 SF $50.00 $6,000.00 17 Repair/Rehab 4" Concrete Sidewalk SF $30.00 $900.00 18 Repair/Rehab Concrete Curb & Gutter _30 20 LF $50.00 $1,000.00 19 Sod 250 SY $20.00_ $5,000.00 20 Traffic Control 60 Day $250.00 $15,000.00 21 Owner Contingency 1 AL $20,000.00 $20,000.00 22 Bonds 1 LS $6,400.00 $6,400.00 Total $370,770.00 PROPOSAL INCLUSIONS The prices stated in this proposal include: 1. Mobilizations and demobilization. 2. Pipe and other materials. 3. Sod, concrete, and other restoration items. 4. Additional services as listed in pricing for specific repair locations. 5. Traffic control. 6. Confined space safe entry practices. 7. Two-year standard construction warranty, Maintenance, Performance, and Payment Bonds. 8. Certificate of insurance with a standard coverage. PROPOSAL EXCLUSIONS Not included in the prices stated in this estimate are costs associated with the items listed below. These items, if needed or found to be applicable, would be provided by INSITUFORM TECHNOLOGIES, LLC at your additional cost; or would be furnished by others, at your direction, at no cost to INSITUFORM TECHNOLOGIES, LLC: a) Water from fire hydrants within a convenient distance from site location. b) If any hazardous or toxic materials are encountered during the project, the Owner will be responsible for the removal and disposal of the materials. c) Construction entrance. 117 of 131 January 17, 2024 Regular Meeting Agenda Packet d) Rock excavation. e) Project permits and/or local licenses with be provided by the Owner or Engineer. f) State and local sales and/or use taxes on the value of the project. If you are exempt, please submit the appropriate documentation. g) Additional premiums for special insurance coverage(s) demanded by you or other parties particular to this project. PROPOSAL TERMS AND CONDITIONS a) LIMITED WARRANTY. IN LIEU OF ALL OTHER EXPRESSED, IMPLIED AND/OR STATUTORY. WARRANTIES, INCLUDING WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, CONTRACTOR AGREES TO CORRECT ANY DEFECTS IN THE MATERIALS OR SERVICES PROVIDED BY CONTRACTOR WHICH ARE BROUGHT TO THE ATTENTION OF CONTRACTOR WITHIN TWO YEAR FOLLOWING COMPLETION OF CONTRACTOR'S WORK, PROVIDED OWNER AFFORDS CONTRACTOR SUITABLE ACCESS AND WORKING CONDITIONS TO ACCOMPLISH SUCH CORRECTION. b) PROPOSAL SUBJECT TO NEGOTIATION OF OTHER STANDARD TERMS OF AGREEMENT. This proposal is subject to agreement of the parties on other terms and conditions as are customary in contracts of this nature. c) Quantities are estimated. Unit prices apply for actual invoice and payment. d) Payments are due at net within thirty days of invoice. Final payment is due within thirty days of completion of project. e) Monthly progress partial payments may be requested for the value of work in progress or completed, including materials secured and on site. f) Prices stated are in effect for thirty days from the date of this proposal. The acceptance period may be extended at the sole option of INSITUFORM TECHNOLOGIES, LLC. g) Insituform Technologies, LLC estimates approximately 120 calendar days for substantial completion. OFFERED BY: ACCEPTED BY: INSITUFORM TECHNOLOGIES, LLC 764444 R, p SIGNATURE DATE TIMOTHY R. PETERIE NAME BUSINESS DEVELOPMENT MANAGER REVIEWED BY: ANDY OZMENT AREA MANAGER cc: Ben Hawkins Mike McMahon (TCMUD) TITLE ORGANIZATION 118 of 131 January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 RESOLUTION NO. 2024-0117A A RESOLUTION REGARDING SIGNATORY AUTHORITY FOR TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 ACCOUNTS AT PROSPERTY BANK USA WHEREAS, Trophy Club Municipal Utility District No. 1 (the "District") is a conservation and reclamation district, a body corporate and politic and governmental agency of the State of Texas, created under Article XVI, Sec. 59 of the Texas Constitution by order of the Texas Water Commission, now the Texas Commission on Environmental Quality ("TCEQ"), and the District operates under Chapters 49 and 54 of the Texas Water Code, as amended; WHEREAS, banking rules and effective management of the District's finances require that the Board of Directors (the "Board") of Trophy Club Municipal Utility District No. 1 (the "District") establish designated persons who shall have signature authority over the District's bank accounts at Prosperity Bank USA (the "Bank"); and WHEREAS, it is necessary for the Board to provide that a sufficient number of District officials be designated with signature authority; and NOW, THEREFORE, BE IT RESOLVED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 THAT: 1. The following members of the Board of Directors and the General Manager of Trophy Club Municipal Utility District No. 1 shall have signatory authority over the District's accounts at Prosperity Bank USA, each of them mutually having authority to act in the place of any other as may be convenient for effectively transacting the business of the District: a. William C. Rose Director b. Kevin R. Carr Director c. Jim Thomas Director d. Ben Brewster Director e. Doug Harper Director f. Alan Fourmentin General Manager 2. At least two (2) authorized signors must sign all disbursements of the District. 3. The Board of Directors directs the staff of the District to take all actions necessary and apply such information and documentation as may be requested by the Bank to affect the provisions of this Resolution. 4. These changes supersede all previously existing signatory authorities on record with Prosperity Bank USA. 119 of 131 January 17, 2024 Regular Meeting Agenda Packet RESOLVED, PASSED, AND APPROVED on this the 17th day of January 2024. ATTEST: Doug Harper Secretary, Board of Directors Kevin R. Carr President, Board of Directors 120 of 131 (SEAL) January 17, 2024 Regular Meeting Agenda Packet TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 RESOLUTION NO. 2024-0117B RESOLUTION DESIGNATING DEPOSITORY INSTITUTIONS, DESIGNATING AUTHORIZED SIGNATORIES FOR THE DISBURSEMENT OF DISTRICT FUNDS, PROVIDING FOR ELECTRONIC TRANSFERS OF DISTRICT FUNDS, AND CONTAINING OTHER MATTERS RELATING THERETO STATE OF TEXAS § COUNTIES OF DENTON AND TARRANT § WHEREAS, Trophy Club Municipal Utility District No. 1 (the "District") is a duly created and existing municipal utility District created and operating under Chapters 49 and 54 of the Texas Water Code, as amended; WHEREAS, Section 49.156 of the Water Code requires the Board of Directors of the District, by order or resolution, to designate one or more banks or savings associations within the state to serve as the depository for the funds of the District; WHEREAS, the Board of Directors of the District desires to designate depository institutions for funds of the District in accordance with Section 49.156 of the Water Code; WHEREAS, Section 49.151 of the Water Code provides that except as otherwise set forth therein, a District's money shall be disbursed only by check, draft, order, or other instrument that shall be signed by at least a majority of the directors. The statute allows a Board, by resolution, to allow the General Manager, Treasurer, Bookkeeper, or other employee of the District to sign disbursements. The statute also provides that the board may allow disbursements of District money to be transferred by Federal Reserve wire system to accounts in the name of the District or accounts not in the name of the District; WHEREAS, in accordance with the foregoing statutes, the Board of Directors desires to designate banks or savings associations to serve as the depository for the funds of the District; to provide for the disbursement of funds of the District; and to provide for the electronic transfer of funds, all subject to certain limitations specified herein by the Board of Directors herein for the safekeeping and protection of public funds. NOW THEREFORE, BE IT RESOLVED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 THAT: 1. 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. 2. Designation of Depository Institutions: (a) In accordance with Section 49.156 of the Texas Water Code, the Board of Directors hereby designates those banks and savings associations set forth on 121 of 131 January 17, 2024 Regular Meeting Agenda Packet Exhibit "A" attached hereto (hereinafter, the "Authorized Depository Institutions") to serve as depositories for the funds of the District. (b) The District's General Manager and Board of Directors are hereby authorized to open and close accounts at the Authorized Depository Institutions. (c) No funds of the District shall be deposited at any of the Authorized Depository Institutions in excess of the amounts insured by the Federal Deposit Insurance Corporation unless they are secured in the manner provided by law under the Public Funds Collateral Act (Chapter 2257, Government Code). (d) In accordance with Section 49.156 of the Water Code, the Board of Directors hereby authorizes the following designated representatives to supervise the substitution of securities pledged to secure the District's funds at the Authorized Depository Institutions: Alan Fourmentin General Manager Steven Krolczyk Finance Manager 3. Authorized Signatories for District Accounts: (a) Checks, drafts, and other withdrawal or transfer orders issued against funds of the District on deposit at the Authorized Depository Institutions may be signed only by the members of the Board of Directors of the District and its General Manager, each of whom are identified below: a. William C. Rose Director b. Kevin R. Carr Director c. Ben Brewster Director d. Douglas Harper Director e. Jim Thomas Director f. Alan Fourmentin General Manager (b) The authority of all other persons to sign disbursements, transfer or withdraw funds, or otherwise conduct any transactions related to the District's funds is hereby terminated for all purposes. (c) The General Manager is hereby directed to ensure that signature cards for all District depository accounts contain current information and only the names of those individuals authorized to sign disbursements on behalf of the District. 4. Disbursement Authority: (a) General Manager Disbursement Authority. The General Manager is authorized to disburse District funds and approve expenditures in accordance with the terms and conditions of Order 2018-0618B, such Order shall remain in full force and effect for all purposes. (b) Other Disbursements. In accordance with Section 49.151 of the Water Code, and except as otherwise provided hereunder and in Order 2018-0618B, disbursements of the District's funds by check, draft, order, or other instrument shall be signed by at least a majority of the directors. 122 of 131 January 17, 2024 Regular Meeting Agenda Packet (c) Additional Limitations on Disbursement Authority. i. Non -payroll checks made payable to the General Manager of the District may not be signed by the General Manager. ii. Checks made payable to any Director of the District for director's fees or reimbursement of expenses may not be signed by the Director receiving the check. 5. Electronic Transfers: Except as authorized below, the electronic transfer of District funds is prohibited: (a) Except as otherwise specified herein, District funds may be transferred between District accounts or to third party accounts only upon approval of the Board of Directors. (b) The General Manager is authorized to approve the electronic transfer of District funds in accordance with the terms and conditions of Order 2018-0618B. 6. This Resolution supersedes and replaces all previous orders, resolutions and policies relating to the subject matter hereof. This Resolution does not supersede or replace Order 2018-0618B. 7. This Resolution shall be effective immediately upon adoption. 8. District staff are hereby directed to take any and all actions that may be required by the Authorized Depository Institutions to implement this Resolution. RESOLVED, PASSED AND APPROVED this the 17th day of January 2024. Kevin R. Carr President, Board of Directors ATTEST: Doug Harper Secretary, Board of Directors (SEAL) 123 of 131 January 17, 2024 Regular Meeting Agenda Packet Exhibit "A" Authorized Depository Institutions Name of Bank Address Town State Zip Prosperity Bank 217 North Main Keller TX 76248 TexPool 1001 Texas Avenue Suite 1400 Houston TX 77002 124 of 131 January 17, 2024 Regular Meeting Agenda Packet ORDER NO. 2024-0117A AN ORDER OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 CALLING AN ELECTION FOR DIRECTORS; AUTHORIZING EXECUTION OF A JOINT ELECTION AGREEMENT AND ELECTION SERVICES AGREEMENT; AND APPROVING OTHER MATTERS RELATED TO SAID ELECTION WHEREAS, Trophy Club Municipal Utility District No. 1 (the "District") is a conservation and reclamation district created under Article XVI, Sec. 59 of the Texas Constitution by order of the Texas Natural Resource Conservation Commission, now the Texas Commission on Environmental Quality ("TCEQ"), and the District operates under Chapters 49 and 54 of the Texas Water Code, as amended; WHEREAS, the Board of Directors of the District desires to conduct an election for the purpose of electing two (2) directors of Trophy Club Municipal Utility District No. 1 on May 4, 2024; WHEREAS, Section 271.002 et seq. of the Election Code authorizes joint elections to be held by certain entities, including two or more political subdivisions in all or part of the same territory, provided the governing bodies enter into an agreement to hold the election jointly; WHEREAS, pursuant to Section 271.003 of the Election Code, a regular county polling place may be used for a common polling place in a joint election, and the voters of a political subdivision may be served in a joint election by a common polling place outside the boundary of the political subdivision if the location can adequately and conveniently serve the affected voters and will facilitate the orderly conduct of the election; WHEREAS, the District intends to enter into a joint election contract with one or more other political subdivisions conducting an election on May 4, 2024 and further intends to enter into contracts with Denton and Tarrant Counties to conduct said joint election; and WHEREAS, the Board of Directors of the District, in an open, public meeting, proper notice of which has been given as required by law, has given consideration to calling a director election for May 4, 2024, and authorizing execution of agreements with Denton County and Tarrant County for purpose of conducting the election. NOW, THEREFORE, BE IT ORDERED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 THAT: 125 of 131 January 17, 2024 Regular Meeting Agenda Packet Section 1: The matters and facts set out in the preamble of this Order 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: An election for two (2) directors shall be held between the hours of 7:00 a.m. and 7:00 p.m., on the 4 th day of May 2024. The election precincts for the election shall be the election precincts established by Denton County and Tarrant County, provided that each shall contain and include geographic area that is within the District. The polling place for each such election precinct shall be the polling places established by Denton County and Tarrant County for such election precincts in Denton County and Tarrant County and voting by residents of the District. The returns for precincts in Denton County and Tarrant County will be provided by precinct and the Denton County and Tarrant County Elections Administrators shall tabulate and provide the election returns for the election. Section 3: The Elections Administrators of Denton County and Tarrant County are conducting the election pursuant to a contract for election services between the District and such Election Administrators as authorized under Section 31.092 of the Texas Election Code (the "Election Services Agreements"). The election shall be held as a joint election pursuant to Chapter 271 of the Texas Election Code and a joint election agreement to be entered into between the District and the other eligible participating entities that are holding an election on May 4, 2024 (the "Joint Election Agreement"). The Board of Directors hereby authorizes and directs its General Manager to enter into the Election Services Agreements and Joint Election Agreement on behalf of the District. Section 4: The District's boundaries overlap areas within both Denton and Tarrant County and the District will therefore contract for election services with both counties to serve qualified voters of the District that reside in each county. The Denton County Elections Administrator is appointed to serve as the District's Election Officer to conduct the election for qualified voters of the District residing in Denton County, and the Tarrant County Elections Administrator is appointed to serve as the District's Election Officer to conduct the election for qualified District voters residing in Tarrant County. Section 5: Early voting shall be conducted at the early voting polling locations established by Denton County and Tarrant County. These places shall remain open on the dates and at the times established by Denton County and Tarrant County. The Denton and Tarrant County Election Administrators are hereby appointed as the Early Voting Clerks for their respective county. Early voting shall commence on the 12th day before the election (April 22, 2024) and continue through the 4th day preceding the date of the election (April 30, 2024) as provided by the provisions of the Texas Election Code. The Early Voting Clerks' mailing addresses to which ballot applications and ballots to be voted by mail may be sent in are as follows: 126 of 131 January 17, 2024 Regular Meeting Agenda Packet For Qualified Voters of the District residing in Denton County: Early Voting Clerk Denton County Elections Administration 701 Kimberly Drive, Suite A101 Denton, Texas 76208 For Qualified Voters of the District residing in Tarrant County: Early Voting Clerk Tarrant County Elections Administration 2700 Premier Street Fort Worth, Texas 76111 Section 6: All residents and qualified electors of the District shall be entitled to vote at the election. Qualified electors of the District residing in Denton County shall vote at locations established by Denton County. Qualified electors of the District residing in Tarrant County shall vote at locations established by Tarrant County. Section 7: At said election, there shall be submitted to the duly qualified resident electors of the District the matter of electing two (2) directors by submitting the names of those persons who have duly and legally filed as candidates for such office. The purpose of the election is to elect a Director to Place One (1) for a four (4) year term and to elect a Director to Place Two (2) for a four (4) year term. Directors shall be elected by plurality vote by place number. Section 8: Written application to have a person's name printed on the ballot as a candidate for the office of Director of the District must be signed by the candidate and must be received by the District Secretary no later than 5:00 p.m. on February 16, 2024. No person's name shall be placed on the ballot unless he or she is at least eighteen (18) years of age, a resident citizen of the State of Texas, owns land subject to taxation in the District, or is a qualified voter within the District. No person who is disqualified by the laws of the State of Texas from serving as a director of this District shall have his or her name placed on the ballot. The District Secretary is authorized to determine the qualifications of candidates for office. Any person not satisfied with the District Secretary's ruling may appeal the decision to the Board of Directors of the District. Blank applications and copies of this Order may be obtained from the District Secretary, who is hereby designated as the District's agent for purposes of the May 4, 2024, election. Section 9: The election shall be held and conducted, and returns made to this Board of Directors in accordance with the Texas Election Code, as modified by Chapters 49 and 54, Texas Water Code. 127 of 131 January 17, 2024 Regular Meeting Agenda Packet Section 10• Immediately after the election, the officers holding same shall make and deliver the returns of the results thereof to the District Secretary, who shall safely keep them and deliver same to the Board of Directors at its next meeting, at which time the Board shall timely canvass said returns and declare the results of said election. Section 11: The District Secretary is hereby directed to cause notice of the election to be provided in English, Spanish and Vietnamese in accordance with the requirements of Section 4.003 of the Texas Election Code and all other requirements of law. Section 12: The rate of pay for judges and clerks of the election shall be determined by the Denton County Election Officer and the Tarrant County Election Officer in compliance with the Texas Election Code. Section 13: The District's President, Secretary, General Manager, and legal counsel are authorized and directed to take any action necessary to carry out the provisions of this Order, including entering into one or more joint election agreements with other political subdivisions in Denton and Tarrant Counties, Texas that will be conducting an election on May 4, 2024, at the locations identified on the exhibits attached hereto. 128 of 131 January 17, 2024 Regular Meeting Agenda Packet ADOPTED, PASSED AND APPROVED this 17th day of January 2024. ATTEST: Doug Harper, Secretary/Treasurer Board of Directors Laurie Slaght, District Secretary 129 of 131 Kevin R. Carr, President Board of Directors (SEAL) January 17, 2024 Regular Meeting Agenda Packet NOTICE OF APPOINTMENT OF AGENT FOR MAY 4, 2024, DIRECTOR ELECTION TO: ALL PERSONS INTERESTED IN THE DIRECTOR ELECTION OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1: Notice is hereby given that the undersigned, Secretary of the Board of Directors of Trophy Club Municipal Utility District No. 1 (the "District"), acting pursuant to Section 31.123, Texas Election Code, appoints Laurie Slaght, District Secretary as the duly authorized agent (the "Agent") for all purposes for the May 4, 2024, Director Election. The office for the Agent is located at 100 Municipal Drive, Trophy Club, Texas 76262, and the telephone number for the Agent is (682) 831-4600. The Agent shall be available for election duties at least three hours each day, during regular office hours on regular business days, beginning on March 14, 2024, the 50th day before Election Day and not ending earlier than June 12, 2024, the 40th day after Election Day. The Agent shall maintain in the Agent's office the documents, records, and other papers relating to the election that: 1. by law are placed in the custody of the authority appointing the agent; and 2. are public information. The Agent shall receive any personally delivered document relating to the election that the appointing authority is authorized or required to receive; and make available for inspection and copying, in accordance with applicable regulations, the documents, records, and other papers that are required to be maintained in the Agent's office. The Agent may perform any other ministerial duties in connection with the election that may lawfully be performed by an employee of the District. This Notice shall be posted on the bulletin board used for posting meetings of the District's Board of Directors and shall remain continuously posted during the minimum period for maintaining the Agent's office. Doug Harper, Secretary/Treasurer Board of Directors Trophy Club Municipal Utility District No. 1 130 of 131 • Trophy Club Municipal Utility District No. 1 February 2024 January 17, 2024 Regular Meeting Agenda �r Slaght Sun Mon Tue Wed Thu Fri Sat 5 Jan 28, 2024 6 4 7 11 8 18 9 25 29 5 12 19 Presidents Day - Office 26 7am Early Voting - March Republican Primary Printed on: 01/12/2024 8:29am 30 6 13 20 31 7 14 21 Feb 1 8 15 22 2 3 9 10 16 17 23 24 7am Early Voting - March Republican Primary 27 Board of Directors Re 28 131 of 131 29 Mar 1 2 Q Central Time US & Ca Powered by ;T; teamup