Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2024-06 June Combined Financials
NA TROPHY CLUB MUNICIPAL UTILITY DISTRICT Trophy Club Municipal Utility District No. 1 Vendor Number Vendor Name Bank Code: Prosperity Bank -Prosperity Bank Check Report By Check Number Date Range: 06/01/2024 - 06/30/2024 Payment Date Payment Type Discount Amount Payment Amount Number 3127 Allied Welding Supply Inc. 06/10/2024 Regular 0.00 5.13 10436 UC006 American Real PM 06/10/2024 Regular 0.00 12.33 10437 UC009 April Lucier 06/10/2024 Regular 0.00 113.47 10438 1005 Atlas Utility Supply Co. 06/10/2024 Regular 0.00 905.00 10439 1250 Bio -Aquatic Testing Inc. 06/10/2024 Regular 0.00 1,170.00 10440 4003 CW Janitorial Services 06/10/2024 Regular 0.00 1,600.00 10441 UC016 Deborah Cox 06/10/2024 Regular 0.00 18.53 10442 UC015 Deborah Gibby 06/10/2024 Regular 0.00 8.68 10443 1018 Denton Central Appraisal District 06/10/2024 Regular 0.00 1,967.85 10444 UC010 Emily Pressnall 06/10/2024 Regular 0.00 21.94 10445 3118 Exclusive Pest Control 06/10/2024 Regular 0.00 245.00 10446 2606 Fisery Solutions LLC 06/10/2024 Regular 0.00 50.00 10447 3093 Four Man Furnace Inc. 06/10/2024 Regular 0.00 187.50 10448 2795 Griswold Company 06/10/2024 Regular 0.00 575.00 10449 2783 JJ HVAC LLC 06/10/2024 Regular 0.00 985.00 10450 UC004 John W Walser 06/10/2024 Regular 0.00 4.75 10451 UC013 Kerry Rozes 06/10/2024 Regular 0.00 99.53 10452 UC012 Kevin Morgan 06/10/2024 Regular 0.00 8.50 10453 3278 Kyocera Document Solutions 06/10/2024 Regular 0.00 82.49 10454 UC003 Lennar Homes 06/10/2024 Regular 0.00 28.46 10455 3216 M3 Networks 06/10/2024 Regular 0.00 1,403.00 10456 UC014 Martha McCoy 06/10/2024 Regular 0.00 12.64 10457 UC007 Nancy Wardlow 06/10/2024 Regular 0.00 80.03 10458 UC005 Open House Texas Realty & Investments 06/10/2024 Regular 0.00 20.47 10459 UC008 Paul Labbe 06/10/2024 Regular 0.00 22.96 10460 4087 Prime Source Construction, Inc. 06/10/2024 Regular 0.00 485.00 10461 1737 PVS DX INC 06/10/2024 Regular 0.00 1,362.45 10462 UC002 Ralph & Kay Jones 06/10/2024 Regular 0.00 17.90 10463 2821 Ricochet Fuel Distributors,Inc 06/10/2024 Regular 0.00 861.72 10464 UC011 Tanisha M Chavez 06/10/2024 Regular 0.00 4.03 10465 4086 Texas Comptroller of Public Accounts 06/10/2024 Regular 0.00 1,364.81 10466 2696 Texas Excavation Safety System 06/10/2024 Regular 0.00 395.60 10467 4085 The Liston Law Firm, P.C. 06/10/2024 Regular 0.00 1,678.75 10468 1001 Town of Trophy Club 06/10/2024 Regular 0.00 233,276.66 10469 3225 US Bank Voyager Fleet Systems 06/10/2024 Regular 0.00 2,187.39 10470 4005 Aurora Patricia Albrecht 06/10/2024 Regular 0.00 504.16 10471 4018 BP Energy Holding Company LLC 06/10/2024 Regular 0.00 30,619.98 10472 1179 Denton County Tax Office 06/10/2024 Regular 0.00 660.57 10473 2796 Garver 06/10/2024 Regular 0.00 1,405.00 10474 2635 Halff Associates Inc. 06/10/2024 Regular 0.00 2,000.00 10475 4033 Health Care Service Corporation 06/10/2024 Regular 0.00 21,759.20 10476 2760 NDS Leasing 06/10/2024 Regular 0.00 175.00 10477 2440 Tarrant County Public Health Laboratory 06/10/2024 Regular 0.00 570.00 10478 UC001 Timothy Moreland 06/10/2024 Regular 0.00 15.73 10479 2634 Valley Solvents & Chemicals 06/10/2024 Regular 0.00 2,635.63 10480 2683 Charter Communications 06/10/2024 Regular 0.00 903.74 10481 2222 Aflac 06/10/2024 Regular 0.00 221.93 10482 3132 Legal Shield 06/10/2024 Regular 0.00 7.98 10483 1030 City of Fort Worth 06/10/2024 Regular 0.00 177,284.87 10484 2796 Garver 06/10/2024 Regular 0.00 5,711.64 10485 4004 Insituform Technologies LLC 06/10/2024 Regular 0.00 88,242.50 10486 3176 Rey -Mar Construction 06/10/2024 Regular 0.00 157,620.33 10487 3156 Southern Petroleum Lab Inc 06/10/2024 Regular 0.00 338.40 10488 2222 Aflac 06/20/2024 Regular 0.00 221.93 10489 7/10/2024 2:02:37 PM Page 1 of 3 Check Report Date Range: 06/01/2024 - 06/30/2024 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number 2772 Allied Waste Industries 06/20/2024 Regular 0.00 6,256.46 10490 3197 BenefitMall 06/20/2024 Regular 0.00 52.00 10491 1030 City of Fort Worth 06/20/2024 Regular 0.00 176,021.71 10492 3184 Dataprose LLC 06/20/2024 Regular 0.00 2,642.15 10493 4088 Entech Sales & Service, LLC 06/20/2024 Regular 0.00 615.00 10494 2606 Fisery Solutions LLC 06/20/2024 Regular 0.00 50.00 10495 2796 Garver 06/20/2024 Regular 0.00 2,225.05 10496 2635 Halff Associates Inc. 06/20/2024 Regular 0.00 5,449.64 10497 2943 JP Morgan Chase Bank NA 06/20/2024 Regular 0.00 2,224.14 10498 3132 Legal Shield 06/20/2024 Regular 0.00 7.97 10499 3216 M3 Networks 06/20/2024 Regular 0.00 1,080.00 10500 1050 Michael's Keys Inc. 06/20/2024 Regular 0.00 867.35 10501 3134 Prime Controls LP 06/20/2024 Regular 0.00 -3,334.75 10502 3134 Prime Controls LP 06/20/2024 Regular 0.00 3,334.75 10502 2806 Robert Half International, Inc 06/20/2024 Regular 0.00 1,518.00 10503 3156 Southern Petroleum Lab Inc 06/20/2024 Regular 0.00 3,265.20 10504 1081 Tri County Electric 06/20/2024 Regular 0.00 729.31 10505 1058 Verizon Wireless 06/20/2024 Regular 0.00 583.70 10506 3280 Watts Ellison LLC 06/20/2024 Regular 0.00 1,779.67 10507 3134 Prime Controls LP 06/20/2024 Regular 0.00 1,520.00 10508 4087 Prime Source Construction, Inc. 06/20/2024 Regular 0.00 1,814.75 10509 3197 BenefitMall 06/07/2024 Bank Draft 0.00 248.33 DFT0000162 3113 TCDRS 06/30/2024 Bank Draft 0.00 8,538.19 DFT0000163 3124 IRS Tax Payment 06/07/2024 Bank Draft 0.00 11,637.76 DFT0000164 3124 IRS Tax Payment 06/21/2024 Bank Draft 0.00 12,595.32 DFT0000165 3197 BenefitMall 06/21/2024 Bank Draft 0.00 248.33 DFT0000166 3113 TCDRS 06/30/2024 Bank Draft 0.00 8,454.28 DFT0000167 3124 IRS Tax Payment 06/21/2024 Bank Draft 0.00 -1,121.76 DFT0000168 Bank Code Prosperity Bank Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 105 74 0.00 954,198.01 Manual Checks 0 0 0.00 0.00 Voided Checks 0 1 0.00 -3,334.75 Bank Drafts 7 7 0.00 40,600.45 EFT's 0 0 0.00 0.00 112 82 0.00 991,463.71 7/10/2024 2:02:37 PM Page 2 of 3 Check Report Date Range: 06/01/2024 - 06/30/2024 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 105 74 0.00 954,198.01 Manual Checks 0 0 0.00 0.00 Voided Checks 0 1 0.00 -3,334.75 Bank Drafts 7 7 0.00 40,600.45 EFT's 0 0 0.00 0.00 112 82 0.00 991,463.71 Fund Summary Fund Name Period Amount 996 MUD Consolidated Cash 6/2024 991,463.71 991,463.71 7/10/2024 2:02:37 PM Page 3 of 3 ■ 135 YTD Revenues ■ 135 YTD Expenses Adopted Revenues Adopted Expenses 140,000,000 120,000,000 100,000,000 80,000,000 60,000,000 40,000,000 20,000,000 FY 2024 Combined Financials Adopted Budget vs YTD Actuals Revenues & Expenses YTD as of 6/30/2024 $8,868,207 9,554,597 $14,423,933 $14,423,933 $1,684 $63,317 Water Budget vs Actual Water Consumption Budget vs Actual 2,006,200 92,198,177 61,555,000 48,355,000 42,063,017 37,451,315 59,737,002 44,722,000 82,105,000 --- AOK 6,387 "41114.],226,660 65,644,59] 51,503,997 46,670,584 35,861,000 —0—Budget Consumption 36,716,000 41,156,060 —A—Actual Consumption $1,000,000 $900,000 $800,000 $700,000 $600,000 $500,000 $554,257 $400,000 $300,000 $200,000 5100,000 0 50 Oct Nov Dec Jan Feb Mar Apr May Jun 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 $676,430 7 $493,96 YTD Expenses By Departments YTD Expense- Water YTD Expense- WW YTD Expense- Admin YTD Expense- BOD ■ YTD Expense- Non Dept Water Revenue Budget vs Actual $614,170 $478,646 $449,612 $413,727 $401,119 $345,689 $369,594 $382,397 8297,607 8272,019 $237,590 8212,224 8236,081 —0—Budget Revenue —A—Actual Revenue 8390,412 $565,055 Oct Nov Dec Jan Feb Mar Apr May Jun Adopted Budget Water Consumption Vs Actual Water Consumption Adopted Budget Water Revenue Vs Projected Water Revenue $7,000,000 $6,000,000 Presented by: Finance Department 868,678,857 867,324,264 ■ Budgeted Water Consumption ■ Projected Water Consumption $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 $0 Total Water Consumption Total Water Revenue $5,166,291 $6,261,595 $2,510,794 $3,738,574 ■ Budgeted Water Revenue ■ Projected Water Revenue Net Budgeted Water Revenue Minus Budgeted Expenses ■ Net Projected Water Revenue Minus Projected Expenses TROPHY CLUB 1 1 MUNICIPAL UTILITY DISTRICT Trophy Club Municipal Utility District No. 1 Budget Report Account Summary For Fiscal: 2023-2024 Period Ending: 06/30/2024 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining Fund: 135 - MUD 1 General Fund Revenue 135-000-40000-000 Property Taxes 85,733.51 85,733.51 240.46 84,487.92 -1,245.59 1.45 % 135-000-40002-000 Property Taxes/Delinquent 300.00 300.00 0.00 -951.20 -1,251.20 417.07 % 135-000-40015-000 Property Taxes/P &I 300.00 300.00 20.37 314.49 14.49 104.83 % 135-000-40025-000 PID Surcharges 143,223.25 143,223.25 24,174.82 108,776.26 -34,446.99 24.05 % 135-000-47000-000 Water 6,939,998.00 6,939,998.00 606,102.59 4,235,728.87 -2,704,269.13 38.97 % 135-000-47005-000 Sewer 3,679,786.00 3,679,786.00 296,412.36 2,644,967.76 -1,034,818.24 28.12 % 135-000-47025-000 Penalties 105,800.00 105,800.00 6,458.28 64,486.54 -41,313.46 39.05 % 135-000-47030-000 Service Charges 3,350.00 3,350.00 250.00 3,200.00 -150.00 4.48 % 135-000-47035-000 Plumbing Inspections 300.00 300.00 0.00 1,650.00 1,350.00 550.00 % 135-000-47045-000 Sewer Inspections 100.00 100.00 0.00 500.00 400.00 500.00 % 135-000-47070-000 TCCC Effluent Charges 70,000.00 70,000.00 8,779.20 23,756.80 -46,243.20 66.06 % 135-000-49011-000 Interest Income 150,000.00 150,000.00 43,339.09 395,111.31 245,111.31 263.41 % 135-000-49016-000 Cell Tower Revenue 49,320.00 49,320.00 8,240.00 45,200.00 -4,120.00 8.35 % 135-000-49026-000 Proceeds from Sale of Assets 25,000.00 25,000.00 0.00 51,450.00 26,450.00 205.80 % 135-000-49035-000 Prior Year Reserves 1,933,264.00 1,933,264.00 0.00 0.00 -1,933,264.00 100.00 % 135-000-49036-000 GASB Reserves 50,000.00 50,000.00 0.00 0.00 -50,000.00 100.00 % 135-000-49075-000 Oversize Meter Reimbursement 2,058.00 2,058.00 0.00 4,708.00 2,650.00 228.77 % 135-000-49141-000 Interfund Transfer In 1,178,400.00 1,178,400.00 0.00 1,200,330.86 21,930.86 101.86 % 135-000-49900-000 Miscellaneous Income 7,000.00 7,000.00 168.73 4,489.73 -2,510.27 35.86 % Revenue Total: 14,423,932.76 14,423,932.76 994,185.90 8,868,207.34 -5,555,725.42 38.52% Expense 135-010-50005-000 Salaries & Wages 431,575.02 431,575.02 33,876.76 312,366.71 119,208.31 27.62 % 135-010-50010-000 Overtime 17,000.00 17,000.00 862.69 8,429.81 8,570.19 50.41 % 135-010-50016-000 Longevity 6,252.50 6,252.50 0.00 6,252.50 0.00 0.00 % 135-010-50017-000 Certification 3,600.00 3,600.00 0.00 1,800.00 1,800.00 50.00 % 135-010-50020-000 Retirement 56,730.41 56,730.41 4,168.74 40,439.04 16,291.37 28.72 % 135-010-50026-000 Medical Insurance 116,527.50 116,527.50 7,619.49 71,049.04 45,478.46 39.03 % 135-010-50027-000 Dental Insurance 4,834.55 4,834.55 367.85 3,258.09 1,576.46 32.61 % 135-010-50028-000 Vision Insurance 1,051.01 1,051.01 71.30 641.67 409.34 38.95 % 135-010-50029-000 Life Insurance & Other 4,000.00 4,000.00 13.00 2,597.21 1,402.79 35.07 % 135-010-50030-000 Social Security Taxes 28,422.51 28,422.51 2,082.69 19,828.03 8,594.48 30.24 % 135-010-50035-000 Medicare Taxes 6,647.20 6,647.20 487.07 4,637.16 2,010.04 30.24 % 135-010-50040-000 Unemployment Taxes 1,260.00 1,260.00 0.00 585.00 675.00 53.57 % 135-010-50045-000 Workman's Compensation 11,898.56 11,898.56 1,060.94 6,890.46 5,008.10 42.09 % 135-010-50060-000 Pre-emp Physicals/Testing 400.00 400.00 0.00 0.00 400.00 100.00 % 135-010-50070-000 Employee Relations 300.00 300.00 0.00 0.00 300.00 100.00 % 135-010-55080-000 Maintenance & Repairs 201,500.00 201,500.00 1,485.13 106,606.04 94,893.96 47.09 % 135-010-55085-000 Generator Maint. and Repair 2,000.00 2,000.00 0.00 13,469.93 -11,469.93 -573.50 % 135-010-55090-000 Vehicle Maintenance 5,000.00 5,000.00 0.00 3,038.13 1,961.87 39.24 % 135-010-55105-000 Maintenance-Backhoe/SkidLoader 1,000.00 1,000.00 0.00 1,911.94 -911.94 -91.19 % 135-010-55120-000 Cleaning Services 2,500.00 2,500.00 0.00 40.31 2,459.69 98.39 % 135-010-55135-000 Lab Analysis 7,500.00 7,500.00 0.00 3,837.00 3,663.00 48.84 % 135-010-55135-001 Lab Analysis for PID 2,000.00 2,000.00 0.00 2,222.00 -222.00 -11.10 % 135-010-60010-000 Communications/Mobiles 7,500.00 7,500.00 334.76 2,678.17 4,821.83 64.29 % 135-010-60020-000 Electricity 183,143.49 183,143.49 7,181.09 88,778.64 94,364.85 51.53 % 135-010-60066-000 Publications/Books/Subscripts 1,000.00 1,000.00 0.00 0.00 1,000.00 100.00 % 135-010-60080-000 Schools & Training 2,630.00 2,630.00 0.00 3,546.74 -916.74 -34.86 % 135-010-60100-000 Travel & per diem 577.50 577.50 0.00 604.10 -26.60 -4.61 % 135-010-60135-000 TCEQ Fees & Permits 29,500.00 29,500.00 0.00 15,134.15 14,365.85 48.70 % 135-010-60135-001 TCEQ Fees & Permits for PID 500.00 500.00 0.00 0.00 500.00 100.00 % 7/18/2024 3:11:37 PM Page 1 of 5 Budget Report For Fiscal: 2023-2024 Period Ending: 06/30/2024 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining 135-010-60150-000 Wholesale Water 2,655,497.13 2,655,497.13 0.00 1,323,789.01 1,331,708.12 50.15 % 135-010-60285-000 Lawn Equipment & Maintenance 12,500.00 12,500.00 600.00 6,000.00 6,500.00 52.00 % 135-010-60332-000 Interfund Transfer Out -Rev I&S 565,796.88 565,796.88 51,500.52 463,504.68 102,292.20 18.08 % 135-010-60334-000 Interfund Transfer Out 0.00 0.00 0.00 920,912.00 -920,912.00 0.00 % 135-010-65005-000 Fuel & Lube 23,575.00 23,575.00 2,428.59 12,131.16 11,443.84 48.54 % 135-010-65010-000 Uniforms 4,355.00 4,355.00 0.00 1,852.91 2,502.09 57.45 % 135-010-65030-000 Chemicals 58,200.00 58,200.00 0.00 25,817.04 32,382.96 55.64 % 135-010-65050-000 Meter Expense 20,000.00 20,000.00 0.00 0.00 20,000.00 100.00 % 135-010-65053-000 Meter Change Out Program 124,500.00 124,500.00 0.00 82,650.00 41,850.00 33.61 % 135-010-69005-000 Capital Outlays 4,200,000.00 4,200,000.00 4,939.67 1,544,161.62 2,655,838.38 63.23 % 135-010-69195-000 GASB Reserve for Replacement 378,659.00 378,659.00 0.00 378,659.00 0.00 0.00 % 135-020-50005-000 Salaries & Wages 290,304.62 290,304.62 11,230.64 159,776.93 130,527.69 44.96 % 135-020-50010-000 Overtime 20,000.00 20,000.00 361.43 6,825.76 13,174.24 65.87 % 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 0.00 2,100.00 3,000.00 58.82 % 135-020-50020-000 Retirement 40,934.05 40,934.05 1,391.05 21,070.15 19,863.90 48.53 % 135-020-50026-000 Medical Insurance 93,222.04 93,222.04 3,265.50 38,545.94 54,676.10 58.65 % 135-020-50027-000 Dental Insurance 3,385.28 3,385.28 119.63 1,631.01 1,754.27 51.82 % 135-020-50028-000 Vision Insurance 818.82 818.82 25.69 365.85 452.97 55.32 % 135-020-50029-000 Life Insurance & Other 3,000.00 3,000.00 17.00 1,545.34 1,454.66 48.49 % 135-020-50030-000 Social Security Taxes 20,507.87 20,507.87 687.43 10,226.70 10,281.17 50.13 % 135-020-50035-000 Medicare Taxes 4,796.20 4,796.20 160.77 2,391.72 2,404.48 50.13 % 135-020-50040-000 Unemployment Taxes 1,008.00 1,008.00 0.00 350.98 657.02 65.18 % 135-020-50045-000 Workman's Compensation 8,403.61 8,403.61 748.93 4,617.37 3,786.24 45.05 % 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 1,765.00 113,427.81 23,572.19 17.21 % 135-020-55081-000 Mainten & Repairs Collections 270,000.00 270,000.00 0.00 245,936.33 24,063.67 8.91 % 135-020-55085-000 Generator Maint. and Repair 11,000.00 11,000.00 0.00 6,478.06 4,521.94 41.11 % 135-020-55090-000 Vehicle Maintenance 4,600.00 4,600.00 0.00 227.94 4,372.06 95.04 % 135-020-55091-000 Veh Maintenance Collections 13,000.00 13,000.00 0.00 4,301.52 8,698.48 66.91 % 135-020-55105-000 Maintenance-Backhoe/SkidLoader 3,000.00 3,000.00 0.00 1,541.03 1,458.97 48.63 % 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 6,256.46 68,163.17 31,836.83 31.84 % 135-020-55135-000 Lab Analysis 55,000.00 55,000.00 2,258.40 42,282.82 12,717.18 23.12 % 135-020-60010-000 Communications/Mobiles 7,500.00 7,500.00 200.69 2,088.15 5,411.85 72.16 % 135-020-60020-000 Electricity 242,978.33 242,978.33 729.31 151,906.79 91,071.54 37.48 % 135-020-60080-000 Schools & Training 2,119.00 2,119.00 0.00 727.50 1,391.50 65.67 % 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 710.00 9,960.00 6,040.00 37.75 % 135-020-60331-000 Interfund Transfer Out -Tax I&S 115,885.76 115,885.76 10,535.09 94,815.81 21,069.95 18.18 % 135-020-60332-000 Interfund Transfer Out -Rev l&S 698,542.63 698,542.63 63,548.65 571,937.85 126,604.78 18.12 % 135-020-60334-000 Interfund Transfer Out 0.00 0.00 0.00 96,630.00 -96,630.00 0.00 % 135-020-65005-000 Fuel & Lube 13,000.00 13,000.00 620.52 8,795.29 4,204.71 32.34 % 135-020-65010-000 Uniforms 3,520.00 3,520.00 0.00 1,581.63 1,938.37 55.07 % 135-020-65030-000 Chemicals 32,500.00 32,500.00 2,635.63 21,300.31 11,199.69 34.46 % 135-020-65031-000 Chemicals Collections 10,000.00 10,000.00 0.00 5,709.00 4,291.00 42.91 % 135-020-65045-000 Lab Supplies 33,000.00 33,000.00 0.00 26,063.82 6,936.18 21.02 % 135-020-69005-000 Capital Outlays 1,050,000.00 1,050,000.00 89,027.88 878,903.74 171,096.26 16.29 % 135-020-69008-000 Short Term Debt -Principal 22,398.34 22,398.34 0.00 22,132.30 266.04 1.19 % 135-020-69009-000 Short Term Debt -Interest 442.39 442.39 0.00 425.07 17.32 3.92 % 135-020-69195-000 GASB Reserve for Replacement 155,762.00 155,762.00 0.00 155,762.00 0.00 0.00 % 135-026-50045-000 Workman's Compensation 15.00 15.00 0.66 5.94 9.06 60.40 % 135-026-60070-000 Dues & Memberships 750.00 750.00 0.00 750.00 0.00 0.00 % 135-026-60075-000 Meetings 1,500.00 1,500.00 0.00 927.92 572.08 38.14 % 135-026-60080-000 Schools & Training 4,000.00 4,000.00 0.00 0.00 4,000.00 100.00 % 135-026-60100-000 Travel & per diem 5,000.00 5,000.00 0.00 0.00 5,000.00 100.00 % 7/18/2024 3:11:37 PM Page 2 of 5 Budget Report For Fiscal: 2023-2024 Period Ending: 06/30/2024 Variance Original Current Period Fiscal Favorable Percent Total Budget Total Budget Activity Activity (Unfavorable) Remaining 135-026-60245-000 Miscellaneous Expenses 500.00 500.00 0.00 0.00 500.00 100.00 % 135-030-50005-000 Salaries & Wages 663,185.25 663,185.25 43,102.42 488,289.74 174,895.51 26.37 % 135-030-50010-000 Overtime 2,000.00 2,000.00 0.00 1,620.34 379.66 18.98 % 135-030-50016-000 Longevity 2,532.50 2,532.50 0.00 2,597.50 -65.00 -2.57 % 135-030-50020-000 Retirement 82,631.07 82,631.07 5,172.29 60,288.39 22,342.68 27.04 % 135-030-50026-000 Medical Insurance 108,759.00 108,759.00 5,442.50 58,363.16 50,395.84 46.34 % 135-030-50027-000 Dental Insurance 3,816.74 3,816.74 216.66 2,208.85 1,607.89 42.13 % 135-030-50028-000 Vision Insurance 886.17 886.17 46.50 489.35 396.82 44.78 % 135-030-50029-000 Life Insurance & Other 4,800.00 4,800.00 66.20 3,525.19 1,274.81 26.56 % 135-030-50030-000 Social Security Taxes 41,398.50 41,398.50 2,573.32 28,969.31 12,429.19 30.02 % 135-030-50035-000 Medicare Taxes 9,681.91 9,681.91 601.82 6,891.46 2,790.45 28.82 % 135-030-50040-000 Unemployment Taxes 1,512.00 1,512.00 14.25 819.00 693.00 45.83 % 135-030-50045-000 Workman's Compensation 1,597.19 1,597.19 139.51 900.59 696.60 43.61 % 135-030-50060-000 Pre-emp Physicals/Testing 500.00 500.00 0.00 248.45 251.55 50.31 % 135-030-50070-000 Employee Relations 4,000.00 4,000.00 0.00 3,111.83 888.17 22.20 % 135-030-55030-000 Software & Support 130,311.00 130,311.00 5,178.38 132,350.08 -2,039.08 -1.56 % 135-030-55080-000 Maintenance & Repairs 23,000.00 23,000.00 4,152.10 16,422.71 6,577.29 28.60 % 135-030-55085-000 Generator Maint. and Repair 1,000.00 1,000.00 0.00 1,348.04 -348.04 -34.80 % 135-030-55120-000 Cleaning Services 13,825.00 13,825.00 0.00 11,654.70 2,170.30 15.70 % 135-030-55160-000 Professional Outside Services 100,000.00 100,000.00 1,705.50 88,059.94 11,940.06 11.94 % 135-030-55205-000 Utility Billing Contract 9,000.00 9,000.00 0.00 5,121.75 3,878.25 43.09 % 135-030-60005-000 Telephone 6,000.00 6,000.00 0.00 3,812.33 2,187.67 36.46 % 135-030-60010-000 Communications/Mobiles 3,000.00 3,000.00 48.25 386.05 2,613.95 87.13 % 135-030-60020-000 Electricity/Gas 17,684.51 17,684.51 -7,181.09 11,061.00 6,623.51 37.45 % 135-030-60025-000 Water 5,000.00 5,000.00 0.00 1,735.92 3,264.08 65.28 % 135-030-60035-000 Postage 30,000.00 30,000.00 0.00 17,819.00 12,181.00 40.60 % 135-030-60040-000 Service Charges & Fees 140,000.00 140,000.00 8,751.00 124,708.03 15,291.97 10.92 % 135-030-60050-000 Bad Debt Expense 13,000.00 13,000.00 0.00 0.00 13,000.00 100.00 % 135-030-60055-000 Insurance 116,158.22 116,158.22 9,618.44 86,565.96 29,592.26 25.48 % 135-030-60070-000 Dues & Memberships 6,800.00 6,800.00 0.00 2,016.00 4,784.00 70.35 % 135-030-60080-000 Schools & Training 3,900.00 3,900.00 0.00 1,313.10 2,586.90 66.33 % 135-030-60100-000 Travel & per diem 1,227.50 1,227.50 0.00 0.00 1,227.50 100.00 % 135-030-60115-000 Elections 10,000.00 10,000.00 0.00 0.00 10,000.00 100.00 % 135-030-60245-000 Miscellaneous Expenses 0.00 0.00 1,854.76 2,515.33 -2,515.33 0.00 % 135-030-60285-000 Lawn Equipment & Maintenance 5,000.00 5,000.00 469.67 4,227.03 772.97 15.46 % 135-030-60360-000 Furniture/Equipment < $5000 3,000.00 3,000.00 0.00 0.00 3,000.00 100.00 % 135-030-65010-000 Uniforms 530.00 530.00 0.00 0.00 530.00 100.00 % 135-030-65055-000 Hardware 8,200.00 8,200.00 0.00 4,562.24 3,637.76 44.36 % 135-030-65085-000 Office Supplies 5,000.00 5,000.00 0.00 2,573.95 2,426.05 48.52 % 135-030-65095-000 Maintenance Supplies 5,000.00 5,000.00 0.00 5,146.67 -146.67 -2.93 % 135-030-69170-000 Copier Lease Installments 4,000.00 4,000.00 82.49 2,196.73 1,803.27 45.08 % 135-030-69195-000 GASB Reserve for Replacement 24,903.00 24,903.00 0.00 24,903.00 0.00 0.00 % 135-039-55045-000 Legal 65,000.00 65,000.00 1,678.75 29,545.70 35,454.30 54.55 % 135-039-55055-000 Auditing 30,000.00 30,000.00 0.00 21,784.29 8,215.71 27.39 % 135-039-55060-000 Appraisal 13,071.00 13,071.00 1,967.85 8,046.27 5,024.73 38.44% 135-039-55065-000 Tax Admin Fees 5,000.00 5,000.00 0.00 3,941.00 1,059.00 21.18 % Expense Total: 14,423,932.76 14,423,932.76 401,078.22 9,546,957.15 4,876,975.61 33.81% Fund: 135 - MUD 1 General Fund Surplus (Deficit): 0.00 0.00 593,107.68 -678,749.81 -678,749.81 0.00% Report Surplus (Deficit): 0.00 0.00 593,107.68 -678,749.81 -678,749.81 0.00% 7/18/2024 3:11:37 PM Page 3 of 5 Budget Report For Fiscal: 2023-2024 Period Ending: 06/30/2024 Group Summary Variance Original Current Period Fiscal Favorable Percent Account Type Total Budget Total Budget Activity Activity (Unfavorable) Remaining Fund: 135 - MUD 1 General Fund Revenue 14,423,932.76 14,423,932.76 994,185.90 8,868,207.34 -5,555,725.42 38.52% Expense 14,423,932.76 14,423,932.76 401,078.22 9,546,957.15 4,876,975.61 33.81% Fund: 135 - MUD 1 General Fund Surplus (Deficit): 0.00 0.00 593,107.68 -678,749.81 -678,749.81 0.00% Report Surplus (Deficit): 0.00 0.00 593,107.68 -678,749.81 -678,749.81 0.00% 7/18/2024 3:11:37 PM Page 4 of 5 Budget Report For Fiscal: 2023-2024 Period Ending: 06/30/2024 Fund Summary Fund 135 - MUD 1 General Fund Report Surplus (Deficit): Variance Original Current Period Fiscal Favorable Total Budget Total Budget Activity Activity (Unfavorable) 0.00 0.00 593,107.68 -678,749.81 -678,749.81 0.00 0.00 593,107.68 -678,749.81 -678,749.81 7/18/2024 3:11:37 PM Page 5 of 5 TROPHY CLUB MUNICIPAL UTILITY DISTRICT Trophy Club Municipal Utility District No. 1 Account Name Balance Fund: 135 - MUD 1 General Fund Assets ±35-000-10152-000 CD - Bank of the West 0.00 135-000-10153-000 CD - Prosperity Bank 0.00 135-000-10154-000 CD -Bank of the West/THB 0.00 135-000-10175-000 Money Market -Bank of the West 0.00 135-000-10250-000 Cash-Texpool-General 2,518,096.25 135-000-10255-000 Cash-Texpool/Customer Deposits 0.00 135-000-10260-000 Cash-Texpool GASB 34 Reserve 0.00 135-000-10300-000 Cash -Prosperity Bank -General 9,689.65 135-000-10305-000 Savings-Prosperity/Cash Resery 1,983,071.89 135-000-10550-000 Cash -Advance to Payroll 0.00 135-000-10750-000 Cash -Disbursement Account 0.00 135-000-10996-000 Claim On Cash 4,833,790.91 135-000-11100-000 Petty Cash -Administration 150.00 135-000-11130-000 Petty Cash -Public Works 0.00 135-000-11150-000 Petty Cash/UB 450.00 135-000-11160-000 Cash- Escrow 0.00 135-000-11200-000 Prepaid Expenses 0.00 135-000-11201-000 Prepaid -FSA Account 0.00 135-000-11202-000 Prepaid Insurance -TML 34,705.38 135-000-11203-000 Prepaid Postage -Meter 0.00 135-000-11205-000 Ppd Postage Deposit -UB Bills 3,880.00 135-000-11210-000 Prepaid Fuel/Unleaded 0.00 135-000-11220-000 Prepaid Diesel 0.00 135-000-11310-000 Due from Customer Deposits 0.00 135-000-11370-000 Due from Capital Projects 0.00 135-000-11380-000 Due From Tax Bond Construction 0.00 135-000-11390-000 Due from Rev Bond Const 0.00 135-000-11400-000 Due from Town of Trophy Club 0.00 135-000-11410-000 Due from Fire Dept 0.00 135-000-11420-000 Due From Fire Construction 0.00 135-000-11430-000 Due From SWIFT Bond Construct. 81,691.15 135-000-11460-000 Due from TC Country Club 0.00 135-000-11470-000 Due from Trophy Club Park 0.00 135-000-11480-000 Due From TC Utility Fund 0.00 135-000-11490-000 Due from Grant Fund 0.00 135-000-11500-000 Due from Employees 0.00 135-000-11540-000 Due from I&S Fund 0.00 135-000-11560-000 Due from Storm Drainage Fund 0.00 135-000-11600-000 Due from Street Maintenance 0.00 135-000-11710-000 A/R MUD Water Billings 613,692.02 135-000-11715-000 A/R MUD 1 Sewer Billing 302,126.93 135-000-11720-000 A/R-TCEQ Reg Assessment 3,281.29 135-000-11725-000 A/R -PID Surcharge 11,972.38 135-000-11730-000 A/R Master District Water Bill 0.00 135-000-11740-000 A/R Refuse 91,849.01 135-000-11750-000 A/R Refuse Tax 7,701.62 135-000-11760-000 A/R UB Storm Drainage 37,161.59 135-000-11800-000 Allow for Bad Debts/MUD Water -12,051.13 135-000-11810-000 A/R Unbilled MUD 0.00 135-000-12100-000 A/R Miscellaneous 0.00 135-000-12190-000 A/R Town of Trophy Club 0.00 Balance Sheet Account Summary As Of 06/30/2024 7/10/2024 1:21:16 PM Page 1 of 3 Balance Sheet Account Name Balance 135-000-13000-000 A/R Advalorem Taxes- M&O 4,091.37 Total Assets: 10,525,350.31 10,525,350.31 Liability 135-000-20050-000 A/P Vendors 0.00 135-000-20055-000 Claims Payable 0.00 135-000-20060-000 Procurement Clearing 0.00 135-000-20070-000 Retainage Payable 0.00 135-000-20071-000 Solana/Sabre WW line reloc 0.00 135-000-20072-000 Solana Waterline Relocation 0.00 135-000-20073-000 Campus Cir Waterline Relocatio 0.00 135-000-20075-000 THB Construction (BOTW CD) 0.00 135-000-20080-000 Miscellaneous 0.00 135-000-20200-000 Accrued Payroll 0.00 135-000-20275-000 Due to Consolidated Cash 0.00 135-000-20305-000 Due to Rev Bond Const. 0.00 135-000-20315-000 Due To Rev Bond 16" Waterline 0.00 135-000-20355-000 Due to I&S 0.00 135-000-20358-000 Due to Capital Projects 0.00 135-000-20460-000 Due To Others 772.25 135-000-20500-000 Fort Worth Water -Impact Fees 30,275.00 135-000-20550-000 Due to Town of Trophy Club 0.00 135-000-20560-000 Due to Town Storm Drainage 0.00 135-000-20570-000 Due to Town Utility Fund 0.00 135-000-20600-000 Due to Payroll 0.00 135-000-20996-000 Accounts Payable Pending 1.79 135-000-21000-000 TMRS-Retirement 0.00 135-000-21201-000 Payroll Correction 0.00 135-000-21300-000 Cafe 125 (Pretax) 0.00 135-000-21301-000 Employee Fund (P/R Deducted) 0.00 135-000-21302-000 FWH Taxes 0.00 135-000-21303-000 Social Security Taxes 0.00 135-000-21304-000 Medicare Taxes 0.00 135-000-21305-000 Deferred Compensation 0.00 135-000-21306-000 Employee Flex Spending Acct 0.00 135-000-21307-000 Medical -2,177.03 135-000-21308-000 Dental -165.48 135-000-21309-000 Vision -33.65 135-000-21310-000 Legal Plan 0.00 135-000-21311-000 Voluntary Life -0.06 135-000-21312-000 Aflac 0.00 135-000-21313-000 Cafe 125 -Medical Reimb 0.00 135-000-21314-000 Cafe 125 -Childcare 0.00 135-000-21315-000 Short Term Disability -69.26 135-000-21316-000 Life -MUD Paid 44.20 135-000-21317-000 TCDRS -178.56 135-000-21400-000 TWC Payable 116.98 135-000-21410-000 Child Support 0.00 135-000-21430-000 Wage Garnishment 0.00 135-000-25000-000 Refuse 179,849.42 135-000-25010-000 Refuse Tax 14,950.02 135-000-25030-000 Customer Deposit Account 147,055.00 135-000-25031-000 Customer Deposit Clearing 0.00 135-000-25032-000 Customer Deposits Uanpplied Pymts 0.00 135-000-25033-000 Unapplied Credits UB 25,924.35 135-000-25040-000 Town -Storm Drainage 73,314.50 135-000-25041-000 PID Surcharge Liability -0.01 135-000-25045-000 TCEQ Reg Assessment Charge 24,846.69 135-000-26000-000 Investmt in Uncollected Taxes- GF 4,091.18 135-000-27000-000 Development Depos/JSB Properti 0.00 135-000-27005-000 Development Depos/Old Town Dev 0.00 As Of 06/30/2024 7/10/2024 1:21:16 PM Page 2 of 3 Balance Sheet As Of 06/30/2024 Account Name Balance 135-010-20073-000 Campus Cir Waterline Relocatio 0.00 135-010-20315-000 Due To Rev Bond 16 0.00 Total Liability: 498,617.33 Equity 135-000-31070-000 135-000-31080-000 135-000-31090-000 135-000-31100-000 135-000-31110-000 135-000-31200-000 135-000-35000-000 Total Revenue Total Expense Revenues Over/Under Expenses Non -spendable Fund Balance Restricted Fund Balance Committed Fund Balance Assigned Fund Balance Unassigned Fund Balance Reserve for Encumbrances Transfer of Funds Total Beginning Equity: 3,880.00 0.00 0.00 6,516,007.06 4,185, 595.73 0.00 0.00 10,705,482.79 8, 868, 207.34 9,546,957.15 -678,749.81 Total Equity and Current Surplus (Deficit): 10,026,732.98 Total Liabilities, Equity and Current Surplus (Deficit): 10,525,350.31 7/10/2024 1:21:16 PM Page 3 of 3 CASH STATUS AS OF JUNE 2024 TexPool O & 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 (XXXXX2660) Fire Operating $0 $2,518,096 $2,518,096 135-10300 Prosperity Bank (XXXXX2660) General Fund Operating * $148,055 $4,695,426 $4,843,481 135-10305 Prosperity Bank Reserve -Savings Acct (XXXXX7724) $1,983,072 $0 $1,983,072 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 $4,953,642 $0 $4,953,642 519-10300 Prosperity Bank (XXXXX2660) SWIFT $85,052 $0 $85,052 519-11155 Cash -Bond Escrow Bank of Texas (SWIFT) $839,482 $0 $839,482 520-10250 Texpool Revenue Bond Water & Waste Water Systems 2019 (XXXXX018) $0 $0 $0 520-10300 Prosperity Bank (XXXXX2660)- Construction Water & Waste Water Systems $0 $0 $0 528-10250 TexPool Revenue Bond Reserve (XXXXX014) WWTP Improvements $980,774 $0 $980,774 533-10250 TexPool Tax I & S (XXXXX0003) $547,682 $0 $547,682 533-10300 Prosperity Bank (XXXXX2660) Tax I&S $0 $0 $0 534-10250 TexPool Revenue I & S (XXXXX013) WWTP Improvements $460,606 $0 $460,606 535-10250 Texpool Revenue I & S (XXXXX017) SWIFT $213,167 $0 $213,167 536-10250 TexPool Revenue I & S (XXXXX020) Water & Waste Water Systems $216,618 $0 $216,618 $7,214,122 $17,642,272 Amount available in cash for spending (MUD Accounts) *6/30/2024 Customer Water Deposits $147,055 Fire Department Cash $7,214,122 122-10250 TexPool O & M (XXXXX0002)-Fire Operating Cash $0 $865,861 $865,861 122-10300 Prosperity Bank (XXXXX2660) Fire Operating $0 $0 $0 $0 $865,861 $865,861 Amount available in cash for spending (Fire Department Accounts) $865,861 General Fund 135 Available $ 4,695,426 Prosperity General Fund $ 2,518,096 Texpool General Fund $ 600 Petty Cash Total General Fund 135 Available for Spending $ 7,214,122 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,185,596 Current Year Revenue/Expenses $ (678,750) Total Nonspendable, Assigned & Committed Fund Balances - General Fund 135 $10,026,733 ebills Bills Mailed Bank Draft Online Payments Late Notices Disconnects Connections MUD Connections Town June Utility Billing Report Fiscal Year 2023 - 2024 June 2023 July 2023 August 2023 September 2023 October 2023 November 2023 December 2023 January 2024 February 2024 March 2024 April 2024 May 2024 June 2024 1,766 1,750 1,744 1,742 1,745 1,740 1,737 1,736 1,734 1,744 1,741 1,738 1,724 3,755 3,749 3,747 3,747 3,737 3,739 3,742 3,726 3,729 3,737 3,747 3,753 3,758 589 585 578 572 569 562 567 568 565 565 562 562 557 3,134 3,101 2,957 3,086 3,072 3,006 3,133 3,023 3,036 3,246 2,992 3,152 3,197 327 327 268 344 255 298 342 249 298 299 245 295 277 9 13 7 7 13 4 5 4 8 7 3 3 3 3,395 3,395 3,395 3,395 3,395 3,395 3,395 3,395 3,395 3,394 3,394 3,394 3,394 1,443 1,443 1,443 1,443 1,444 1,444 1,446 1,446 1,447 1,447 1,450 1,453 1,453 June 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 $ - $ - $ - $ - $ - $ - $ - $ - IWHEN EXPERIENCE, REPUTATION AND PERFORMANCE MATTER 1?3 PERDUE BRANDON FIELDERCOLLINS&MOTT LLP ATTORNEYS AT LAW 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 July 2024 2022 TAX YEAR ANALYSIS Delinquent Turnover Original Tax Levy Adj. Delinquent July 1, 2023 Turnover • $1,959,930 • $21,418 • 1.09% 0 ■ Collected ■ Delinquent 98.91 % 1.09% Source: Denton County Tax Office, Year -To -Date Summary Reports. 2 Perdue Brandon Fielder Collins & Mott, LLP Fi!' 2022 TAX YEAR DELINQUENT COLLECTIONS N July 1,2023- June 30,2024 Adj. July 1 Turnover Base Tax Collected Base Tax Remaining • $21,418 • $19,834 • 92.61% • $1,584 Base Tax Only - No Penalties or Interest Added $1,584 Collected $19,834 Source: Denton County Tax Office, Year -To -Date Summary Reports. Turnover Accounts for Adjustments. Base Taxes Only - No Penalties or Interest Added. Perdue Brandon Fielder Collins & Mott, LLP P13 ACCOUNT BREAKDOWN CHART In Bankruptcy, $307.94, 1.3% In Deferral, $8,427.77, 34.4% Nit_ In Litigation, $1,449.45, 5.9% Action Pending, $12,671.95, 51.8% In Uncollectable, $1,609.93, 6.6% As of 7/2/2024 - Total Base Tax: $24,467 (2023 Tax Year & Prior) Action Pending Accounts: Notification Letters, Telephone Collections, Lienholder Notification, Title Research, Property Inspection and Payment Agreements. Source: Perdue Brandon tape download on 6/29/2024 from the Denton County Tax Office. 2023 TAX YEAR ANALYSIS Delinquent Turnover Original Tax Levy Adj. Delinquent July 1,2024 Turnover • $1,623,338 • $17,052 • 1.05% 0 ■ Collected ■ Delinquent 98.95% 1.05% Source: Denton County Tax Office, Year -To -Date Summary Reports. 5 Perdue Brandon Fielder Collins & Mott, LLP Top Tax Due Report Top 100 Percent Properties - TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1 GEO Code Legal Description 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-2022 $4,864.02 $6,899.37 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-2022 $2,332.99 $2,773.75 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-2022 $1,796.51 $3,326.43 11514221TAR DIEGO'S TEX MEX KITCHEN PERSONAL PROPERTY TANGIBLE BKR,SUIT,UP Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 59 SUMMERS, JAMES M N/A 2013-2014 $455.51 $1,266.58 40758281TAR TROPHY CLUB # 9 LOT 723 ACRES: 0.236200 DEFE Taxpayer # Taxpayer Name Primary Phone 93245 PARKER CHARLES J AND PARKER SYLVIA A N/A D Years Tax Due Total Due 2022 $337.04 $360.90 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 $862.15 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 $756.75 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 $640.42 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 $569.77 42641576TAR KNOLLS AT SOLANA BLOCK B LOT 23 ACRES: 0.247900 Taxpayer # Taxpayer Name 93256 MAYA WALDEMAR <none> Primary Phone Years Tax Due Total Due N/A 2021-2022 $171.12 $280.18 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 S267.59 72034DEN TROPHY CLUB # 4 LOT 333 ACRES: 0.361600 <none>,BKR,EMP Taxpayer # Taxpayer Name Primary Phone 1219 BINGHAM GENE C N/A B Years Tax Due Total Due 2021 $122.63 S208.96 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 S120.97 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-2022 $37.36 $62.16 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 $62.47 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 $92.66 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 $87.99 676479DEN PERSONAL PROPERTY - DANCE & MUSIC LESSONS LOCATION: 905 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 90858 FULLER CHRISTINA N/A 2020-2022 $20.53 $35.14 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 $31.84 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 $50.38 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-2022 $18.50 $33.07 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 $47.15 682747DEN PERSONAL PROPERTY - RESTAURANT LOCATION: 301 TROPHY LAKE DR UP Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 91619 7 MILES TASTE GROUP INC N/A 2019 $14.43 $28.74 7/2/2024 10:37:05 AM Page 1 of 2 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 $25.45 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.93 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 $16.25 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-2022 $6.51 $10.66 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 $11.06 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.57 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.59 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.27 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 $7.16 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.45 727270DEN PERSONAL PROPERTY - INSURANCE OFFICE LOCATION: 100 INDIAN <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 92609 FOLEYBEVERLY N/A 2020-2021 $1.98 $3.52 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.32 676477DEN PERSONAL PROPERTY - MEDICAL OFFICE LOCATION: 300 TROPHY CLUB <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 91387 TRUE MEDICINE PA N/A 2022 $0.95 $1.48 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.26 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.38 1030803DEN PERSONAL PROPERTY - LEASED EQUIPMENT - Sl l <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 94223 REDBOX AUTOMATED RETAIL LLC N/A 2022 $0.21 $0.33 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.41 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.35 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.16 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 70726DEN TROPHY CLUB #11 LOT 1467 ACRES: 0.293800 <none>,DEFE,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 7/2/2024 10:37:05 AM Page 2 of 2 Top Tax Due Report Top 100 Percent Properties - TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1 GEO Code Legal Description Status LPBD 42201843TAR GRANADA BLOCK A LOT 44 ACRES: 0.633800 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 94421 DHANUKA VISHAL AND DHANUKA KIRAN N/A 2023 $1,814.44 $2,569.25 42641592TAR KNOLLS AT SOLANA BLOCK B LOT 25 ACRES: 0.275100 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 94428 LEE RHYDON AND LEE CAROLINE N/A 2023 $1,738.38 $2,461.55 657586DEN TROPHY CLUB COMMONS A CONDOMINIUM UNIT 5 PLUS 17.4672% INT <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 94492 915 TROPHY CLUB LLC N/A 2023 $1,429.54 $2,024.23 42641690TAR KNOLLS AT SOLANA BLOCK C LOT 5 ACRES: 0.216900 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 93995 KAUSERRICKY N/A 2023 $1,016.37 $1,439.18 42509139TAR WESTLAKE ENTRADA BLOCK E LOT 2 ACRES: 0.100400 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 94425 GARY S DONOVITZ 2012 IRREVOCABLE TRUST N/A 2023 $967.93 $1,370.59 14924418TAR MP MATERIALS PERSONAL PROPERTY TANGIBLE COMMERCIAL <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 94327 MP MATERIALS CORP N/A 2023 $678.46 $960.70 526096DEN CHURCHILL DOWNS BLK A LOT 1 ACRES: 0.258300 <none>,EMP,PPAY,TPAY Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 895 SEAY MARK SR & TERRI N/A 2023 $437.00 $618.79 70106DEN LAKE FOREST VILLAGE PH 1 LOT 9 ACRES: 0.315700 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 94506 SEFCIK ARNOLD & TIFFANY N/A 2023 $407.72 $577.33 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 2023 $322.05 $328.75 71779DEN TROPHY CLUB 4 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 2023 $310.45 $316.91 72402DEN TROPHY CLUB # 6 LOT 568 ACRES: 0.441700 <none>,TPAY Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 91180 WICK PETER K & HEATHER J N/A 2023 $298.33 $422.44 40758281TAR TROPHY CLUB 4 9 LOT 723 ACRES: 0.236200 DEFE D Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 93245 PARKER CHARLES J AND PARKER SYLVIA A N/A 2023 $260.59 $266.01 42402369TAR WESTLAKE ENTRADA BLOCK C LOT lA SCHOOL BOUNDARY SPLIT <none>,EMP Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 931 UNKNOWN N/A 2023 $241.49 $341.95 40758001TAR TROPHY CLUB 4 3 LOT 254 BALANCE IN DENTON CO ACRES: 0.477400 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 94416 JOHNSON CLAIR G N/A 2023 $228.41 $323.43 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 2023 $223.89 $317.03 42894164TAR WESTLAKE ENTRADA BLOCK G LOT 1R2 ACRES: 0.168000 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 94431 1 TIM 617 LLC N/A 2023 $223.34 $316.25 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 0 & LARISSA N/A 2023 $223.12 $315.94 40758052TAR TROPHY CLUB 4 3 LOT 258 BALANCE IN DENTON CO ACRES: 0.355600 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 93243 WEEKS CHRISTOPHER ROCK AND DENSMORE BRIT N/A 2023 $198.54 $281.13 991059DEN PERSONAL PROPERTY - RESTAURANT/BAR LOCATION: 2230 SH 114 STE <none>,BKR B Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 94161 BLUE 22 SPORTS GRILL N/A 2023 $185.31 $262.40 71202DEN TROPHY CLUB VILLAGE WEST SEC A LOT 893 ACRES: 0.206600 TPAY Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 94516 BARRONALEJANDRA N/A 2023 $183.71 $260.13 40758478TAR TROPHY CLUB # 9 LOT 744 BALANCE IN DENTON CO ACRES: 0.255200 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 94418 MILLER HIGHLIFE LLC N/A 2023 $176.84 $250.41 42641258TAR KNOLLS AT SOLANA BLOCK A LOT 10 ACRES: 0.242400 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 93989 FRAGISKATOS GERASIMOS AND MACIAS JULIETA N/A 2023 $116.01 $164.27 42616733TAR WESTLAKE ENTRADA BLOCK C LOT 1B SCHOOL BOUNDARY SPLIT <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 92381 AMR WESTLAKE STORAGE OWNER LLC N/A 2023 $114.07 $161.52 7/2/2024 10:39:18 AM Page 1 42400404TAR WESTLAKE ENTRADA BLOCK C LOT 1A SCHOOL BOUNDARY SPLIT <none>,EMP Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 931 UNKNOWN N/A 2023 $96.95 $137.28 70211DEN TROPHY CLUB OAK HILL LOT 30 ACRES: 0.282000 <none>,QPAY Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 93485 NICHOLSON RUFUS A N/A 2023 $89.80 $122.85 41640012TAR TROPHY WOOD BUSINESS CENTER BLOCK B LOT 2R1 TROPHY CLUB <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 94628 CRUMPTON DAVID DDS PA 2023 $87.60 $118.79 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 2023 $83.05 $117.60 70609DEN TROPHY CLUB #11 LOT 1439 ACRES: 0.337500 Taxpayer # Taxpayer Name 94616 CONNI RICHARD & LINDA <none> Primary Phone Years Tax Due Total Due 2023 $69.92 $97.33 14924108TAR INSPIRA ENTERPRISES PERSONAL PROPERTY TANGIBLE COMMERCIAL <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 94323 INSPIRA ENTERPRISE INC N/A 2023 $65.89 $93.30 14690069TAR THE CELL SPA/MCKENNA ORTHOPEDI PERSONAL PROPERTY TANGIBLE <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 92192 MCKENNA OTHOPAEDIC AND SPORT MEDICINE PA N/A 2023 $53.00 $75.05 536105DEN PERSONAL PROPERTY --LEASED VEHICLES - Sl l <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 91334 DONLEN TRUST N/A 2023 $49.43 $68.81 42616725TAR WESTLAKE ENTRADA BLOCK C LOT 1B SCHOOL BOUNDARY SPLIT <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 92381 AMR WESTLAKE STORAGE OWNER LLC N/A 2023 $43.80 $62.02 14836420TAR OLDCASTLE APG PERSONAL PROPERTY TANGIBLE COMMERCIAL <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 94320 OLDCASTLE APG N/A 2023 $41.35 $58.55 1010181DEN PERSONAL PROPERTY - MARTIAL ARTS SCHOOL LOCATION: 2550 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 94240 PREMIER MARTIAL ARTS TROPHY CLUB N/A 2023 $32.64 $46.22 40777545TAR LAKE FOREST VILLAGE ADDN LOT 83 BALANCE IN DENTON CO ACRES: <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 90729 CLARKSON NIKOLE AND CLARKSON BART THOMAS N/A 2023 $26.72 $37.84 14924281TAR TXRE PROPERTIES PERSONAL PROPERTY TANGIBLE COMMERCIAL <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 94325 TXRE PROPERTIES N/A 2023 $24.39 $34.54 116392DEN TROPHY CLUB 412 LOT 1510 ACRES: 0.256800 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 94301 LOGAN FAMILY HOLDINGS LLC N/A 2023 $23.30 $32.99 14949895TAR LINDE LEASED EQUIPMENT VARX COMMERCIAL <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 94329 LINDE LEASED EQUIPMENT N/A 2023 $21.49 $30.43 976220DEN PERSONAL PROPERTY - LEASED VEHICLES - S11 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 92441 VCFS AUTO LEASING COMPANY N/A 2023 $21.36 $29.73 72112DEN TROPHY CLUB # 4 LOT 354 353(W221) ACRES: 0.407600 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 90954 ADDINGTON TERI N/A 2023 $18.18 $25.74 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 2023 $14.26 $20.19 42201762TAR GRANADA BLOCK A LOT 36 SCHOOL BOUNDARY SPLIT ACRES: 0.028700 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 94420 BARRIOS JOSUE ELIEZER MORALES ETAL N/A 2023 $11.01 $15.59 1028287DEN PERSONAL PROPERTY - LEASED EQUIPMENT - S11 Taxpayer # Taxpayer Name 94609 HUNTINGTON NATIONAL BANK (EQUIPMENT FINA <none> Primary Phone Years Tax Due Total Due 2023 $8.55 $11.90 776374DEN PERSONAL PROPERTY - BUSINESS SERVICES LOCATION : 99 TROPHY <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 92696 STEVE SCHERMERHORN N/A 2023 $8.43 $11.94 722702DEN PERSONAL PROPERTY - INSURANCE AGENT LOCATION: 2550 BOBCAT <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 91432 JOHN HOUSE GROUP N/A 2023 $8.23 $11.65 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 2023 $7.58 $10.73 943797DEN PERSONAL PROPERTY - LEASED EQUIPMENT - S11 Taxpayer # Taxpayer Name 94625 THE COCA-COLA COMPANY <none> Primary Phone Years Tax Due Total Due 2023 $7.07 $9.76 676479DEN PERSONAL PROPERTY - DANCE & MUSIC LESSONS LOCATION: 905 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 90858 FULLER CHRISTINA N/A 2023 $4.30 $6.09 7/2/2024 10:39:18 AM Page 2 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 2023 $3.64 $5.15 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 2023 $3.61 $5.11 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 2023 $2.83 $4.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 2023 $2.10 $2.97 14635955TAR NTT DATA SERVICES LLC VARX COMMERCIAL <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 92936 NTT DATA SERVICES LLC N/A 2023 $1.75 $2.39 1030803DEN PERSONAL PROPERTY - LEASED EQUIPMENT - S11 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 94223 REDBOX AUTOMATED RETAIL LLC N/A 2023 $1.20 $1.70 72060DEN TROPHY CLUB # 6 LOT 499 ACRES: 0.384000 DEFE Taxpayer # Taxpayer Name Primary Phone 76 MCDONALD JAMES E & HUESTIS LAURA LEA TR N/A D Years Tax Due Total Due 2023 $0.63 $0.64 1027682DEN PERSONAL PROPERTY - LEASED EQUIPMENT - S11 Taxpayer # Taxpayer Name 94608 PORTIER LLC <none> Primary Phone Years Tax Due Total Due 2023 $0.54 $0.75 14924302TAR GKN AEROSPACE PERSONAL PROPERTY TANGIBLE COMMERCIAL <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 94326 GKN AEROSPACE N/A 2023 $0.16 $0.23 203762DEN LAKES OF TROPHY CLUB PH 3 BLK 2 LOT 14 ACRES: 0.286000 QPAY Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 93817 BRAUN WALTER E & LINDA M N/A 2023 $0.06 $0.08 72301DEN TROPHY CLUB # 3 LOT 176 ACRES: 0.350400 <none>,DEFE,QPAY Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 91663 STAFFEL CARL ALLEN & DESIREE 3 N/A 2023 $0.04 $0.05 71098DEN TROPHY CLUB 6 8 LOT 644 ACRES: 0.202400 <none>,QPAY Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 90923 KIRKPATRICK GINGER G N/A 2023 $0.04 $0.05 536970DEN PERSONAL PROPERTY - CHIROPRACTIC OFFICE LOCATION: 501 TROPHY <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 90794 LHK HOLDINGS LLC N/A 2023 $0.03 $0.04 976238DEN PERSONAL PROPERTY - LEASED EQUIPMENT <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 93739 NUCO2 SUPPLY LLC N/A 2023 $0.03 $0.04 72248DEN TROPHY CLUB # 3 LOT 168 ACRES: 0.399400 <none> Taxpayer # Taxpayer Name Primary Phone Years Tax Due Total Due 94525 GANNON DANIEL J JR N/A 2023 $0.01 $0.01 7/2/2024 10:39:18 AM Page 3 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 40758281TAR Trophy Club MUD 1 2023 DEFE TAX 12/06/2021 12/01/2099 Defer $260.59 Property Base Due $597.63 Taxpayer Base Due $597.63 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 71012DEN Trophy Club MUD 1 71012DEN Trophy Club MUD 1 71012DEN Trophy Club MUD 1 71012DEN Trophy Club MUD 1 71012DEN Trophy Club MUD 1 71012DEN Trophy Club MUD 1 71012DEN Trophy Club MUD 1 71012DEN Trophy Club MUD 1 71012DEN Trophy Club MUD 1 71012DEN Trophy Club MUD 1 71012DEN Trophy Club MUD 1 71012DEN Trophy Club MUD 1 2011 DEFE TAX 06/30/2010 12/01/2099 Defer $378.65 2012 DEFE TAX 06/30/2010 12/01/2099 Defer $295.79 2013 DEFE TAX 06/30/2010 12/01/2099 Defer $300.56 2014 DEFE TAX 06/30/2010 12/01/2099 Defer $325.30 2015 DEFE TAX 06/30/2010 12/01/2099 Defer $355.07 2016 DEFE TAX 06/30/2010 12/01/2099 Defer $367.89 2017 DEFE TAX 06/30/2010 12/01/2099 Defer $385.38 2018 DEFE TAX 06/30/2010 12/01/2099 Defer $380.30 2019 DEFE TAX 06/30/2010 12/01/2099 Defer $404.59 2020 DEFE TAX 06/30/2010 12/01/2099 Defer $401.84 2021 DEFE TAX 06/30/2010 12/01/2099 Defer $437.04 2022 DEFE TAX 06/30/2010 12/01/2099 Defer $417.01 2023 DEFE TAX 06/30/2010 12/01/2099 Defer $322.05 Property Base Due $5,186.07 Taxpayer Base Due $5,186.07 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 $276.37 71779DEN Trophy Club MUD 1 71779DEN Trophy Club MUD 1 71779DEN Trophy Club MUD 1 71779DEN Trophy Club MUD 1 71779DEN Trophy Club MUD 1 71779DEN Trophy Club MUD 1 2018 DEFE TAX 11/03/2017 12/01/2099 Defer $412.53 2019 DEFE TAX 11/03/2017 12/01/2099 Defer $416.50 2020 DEFE TAX 11/03/2017 12/01/2099 Defer $404.55 2021 DEFE TAX 11/03/2017 12/01/2099 Defer $421.13 2022 DEFE TAX 11/03/2017 12/01/2099 Defer $401.91 2023 DEFE TAX 11/03/2017 12/01/2099 Defer $310.45 Property Base Due $2,643.44 Taxpayer Base Due $2,643.44 76 MCDONALD JAMES E & HUESTIS LAURA LEA TR GEO Code Client Name Tax Year Status Tran Type Start Date End Date Condition Base Tax 72060DEN Trophy Club MUD 1 2023 DEFE TAX 01/25/2007 12/01/2099 Defer $0.63 Property Base Due $0.63 Taxpayer Base Due $0.63 Total Base Due $8,427.77 TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1 Defer $8,427.77 7/2/2024 10:31:26 AM Page 1 it3 PERDUE BRANDON FIELDERCDLLINS&MDTT LLP ATTORNEYS AT LAW AUTHORITY ACTIVITY ANALYSIS TROPHY CLUB MUNICIPAL UTILITY DISTRICT #1 As Of 7/2/2024, Tax Years Between 1997 And 2023 Description # Properties Pct Of Total Base Tax Amount Pct Of Total In Bankruptcy In Deferral In Litigation In Uncollectable Action Pending 2 4 4 19 69 2.04% 4.08% 4.08% 19.39% 70.41% $307.94 $8,427.77 $1,449.45 $1,609.93 $12,671.95 1.26% 34.45% 5.92% 6.58% 51.79% Totals 98 100.00% $24,467.04 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 $5000.01 - $10,000.00 Totals 63 13 8 3 5 1 1 94 67.02% 13.83% 8.51% 3.19% 5.32% 1.06% 1.06% 100.00% $1,215.82 $2,400.53 $2,758.03 $2,244.02 $8,019.13 $2,643.44 $5,186.07 $24,467.04 4.97% 9.81% 11.27% 9.17% 32.78% 10.80% 21.20% 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 2023 1 1 1 8 8 10 6 8 8 10 10 13 16 63 0.61% 0.61% 0.61% 4.91% 4.91% 6.13% 3.68% 4.91% 4.91% 6.13% 6.13% 7.98% 9.82% 38.65% $414.60 $378.65 $295.79 $786.42 $857.40 $502.72 $485.70 $865.42 $1,283.95 $1,400.46 $1,265.72 $1,583.77 $1,615.48 $12,730.96 1.69% 1.55% 1.21% 3.21% 3.50% 2.05% 1.99% 3.54% 5.25% 5.72% 5.17% 6.47% 6.60% 52.03% Totals 163 100.00% $24,467.04 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. Trophy Club Municipal Utility District No. 1 Quarterly Investment Report For Ending Period 06/30/2024 (April, May, June) I certify that this Investment Report complies with requirements of TCMUD's Investment Policy and the Public Funds Act. Prepared By Investment Officer Regina Van Dyke DATE Alan Fourmentin DATE 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 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 Rate / Type Par Coupon 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 $ 4,998,887 0.000% $ 0.000% $ 0.000% $ 0.000% $ 8,560,625 0.000% $ 0.000% $ 0.000% $ 537,091 0.000% $ 405,003 0.000% $ 980,774 0.000% $ 0.000% $ 188,266 0.000% $ 0.000% $ 182,073 0.000% $ 1,983,072 0.000% $ 836,522 $ 18,672,314 Call Maturity Date N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A Purchase Price Restricted/ Settle Date Sec Type Account Number Par Coupon Maturity Yield % 100.000 0.35% $ 100.000 0.35% $ 100.000 0.35% $ 100.000 0.35% $ 100.000 5.31% $ 100.000 5.31% $ 100.000 5.31% $ 100.000 5.31% $ 100.000 5.31% $ 100.000 5.31% $ 100.000 5.31% $ 100.000 5.31% $ 100.000 5.31% $ 100.000 5.31% $ 100.000 3.19% $ 3.19% $ Qtr. Accrued Qtr. Amort. Total Qtr. Earnings Ending Book 3/31/2024 Ending Market 3/31/2024 Ending Book 6/30/2024 Ending Market 6/30/2024 Gain/Loss End MV -End BV 4,765,951 $ 4,765,951 $ 4,998,887 $ 4,998,887 0.00 $ $ - $ 0.00 85,052 $ 85,052 $ - $ - 0.00 $ $ - $ 0.00 2,815,828 $ 2,815,828 $ 8,560,625 $ 8,560,625 0.00 1,145,236 $ 1,145,236 $ - $ - 0.00 4,916,433 $ 4,916,433 $ - $ - 0.00 507,048 $ 507,048 $ 537,091 $ 537,091 0.00 289,185 $ 289,185 $ 405,003 $ 405,003 0.00 967,894 $ 967,894 $ 980,774 $ 980,774 0.00 - $ - $ - $ - 0.00 136,308 $ 136,308 $ 188,266 $ 188,266 0.00 $ - $ - $ - 0.00 111,034 $ 111,034 $ 182,073 $ 182,073 0.00 1,967,621 $ 1,967,621 $ 1,983,072 $ 1,983,072 0.00 836,522 $ 836,522 $ 836,522 $ 836,522 0.00 18,544,112 $ 18,544,112 $ 18,672,314 $ 18,672,314 $ 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 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 4,998,887 N/A N/A N/A N/A N/A N/A N/A N/A 8,560,625 537,091 405,003 980,774 188,266 $ 182,073 XXXXX7724 $ 82-1747-01-1 $ N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A 1,983,072 N/A N/A 836,522 N/A N/A $ 4,685 $ 117,027 $ 3,954 $ 3,129 $ 12,746 $ 1,3- 88 $ 5,250 $ 1,448 $ 15,330 $ 9,789 N/A $ 4,685 N/A $ N/A $ N/A $ N/A $ 117,027 N/A $ 3,954 N/A $ 3,129 N/A $ 12,746 NA $ - NA $ 1,388 NA $ 5,250 NA $ 1,448 N/A $ 15,330 N/A $ 9,789 $ 174,746 N/A $ 174,746