Loading...
HomeMy WebLinkAbout2020-11 Combined Financials November 2020TROPHY CLUB MUD NO. 1 - FIRE DEPARTMENT BALANCE SHEET NOVEMBER 2020 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE 5,11 TROPHY CLUB l MUNICIPAL UTILITY DISTRICT 122 FIRE DEPT. 355,535 16,491 1,147,647 TOTAL ASSETS 1,519,672 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 1,147,654 1,147,654 652,065 (280,047) 372,018 1,519,672 glbase_tbam skrolczyk Trophy Club MUD No.1 17:28 12/07/20 Budget Summary with Amendment Fund: 122 Trophy Club MUD Fire Dept. Department: Fire Revenues Program: Period Ending: 11/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 122-40010-000-000 122-40011-000-000 122-40020-000-000 Property Taxes/MUD Fire 1,246,877.00- 1,246,877.00 - Property Taxes/Fire-Delinquent Property Taxes/Fire P&I 56,426.60- 77.61- 54.83- 65,435.44- 2,980.49- 75.11- 5.248 1,181,441.56- 2,980.49 75.11 Page 1 Subtotal: 1,246,877.00- 1,246,877.00- 56,559.04- 68,491.04- 5.493 1,178,385.96 - Program number: 1,246,877.00- 1,246,877.00- 56,559.04- 68,491.04- 5.493 1,178,385.96 - Department number: Fire Revenues 1,246,877.00- 1,246,877.00- 56,559.04- 68,491.04- 5.493 1,178,385.96 - Revenues Subtotal 1,246,877.00- 1,246,877.00- 56,559.04- 68,491.04- 5.493 1,178,385.96- glbase_tbam skrolczyk 17:28 12/07/20 Fund: 122 Trophy Club MUD Fire Dept. Account Description 122-60030-045-000 122-60055-045-000 122-60337-045-000 Rent And/Or Usage Insurance Transfer to Town/Fire Budget Trophy Club MUD No.1 Budget Summary with Amendment Department: 45 Fire Program: Period Ending: 11/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 197,281.00 21,000.00 820,027.00 197,281.00 21,000.00 820,027.00 683,355.80 1,649.06 68,335.58 3,298.12 820,026.96 15.705 100.000 197,281.00 17,701.88 .04 Page 2 Subtotal: 79.295 214,982.92 122-69009-045-000 122-69195-045-000 122-69305-045-000 Short Term Debt -Interest GASB34/Reserve for Replacement Capital Leases 6,127.00 81,420.00 121,022.00 6,127.00 81,420.00 121,022.00 6,126.73 81,420.00 121,021.87 99.996 100.000 100.000 .27 .13 Subtotal: * 208,569.00 208,569.00 208,568.60 100.000 .40 Program number: 1,246,877.00 1,246,877.00 683,355.80 69,984.64 1,031,893.68 82.758 214,983.32 Department number: Fire 1,246,877.00 1,246,877.00 683,355.80 69,984.64 1,031,893.68 82.758 214,983.32 Expenditures Subtotal 1,246,877.00 1,246,877.00 683,355.80 69,984.64 1,031,893.68 82.758 214,983.32 Fund number: 122 Trophy Club MUD Fire Dept. 683,355.80 13,425.60 963,402.64 963,402.64 - TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET NOVEMBER 2020 135 137 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 3,749,073 3,749,073 CASH IN BANK -SAVINGS -CASH RESERVE 1,845,832 1,845,832 INVESTMENTS-TEXPOOL 3,361,562 2,007,484 5,369,046 PREPAID EXPENSES 93,222 93,222 ADVALOREM PROPERTY TAXES RECEIVABLE 125,533 125,533 UTILITY AND OTHER ACCOUNTS RECEIVABLE 989,484 989,484 TOTAL ASSETS 10,165,305 2,007,484 12,172,789 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 125,533 125,533 ACCOUNTS AND OTHER PAYABLES 610,108 610,108 CUSTOMER DEPOSITS 311,780 311,780 TOTAL LIABILITIES 1,047,421 1,047,421 FUND BALANCE NON -SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 2,404,829 2,404,829 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 315,000 315,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 460,899 460,899 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 558,704 558,704 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 472,881 472,881 ASSIGNED FUND BALANCE/WWTP MBR REPLACEMENT 200,000 200,000 UNASSIGNED FUND BALANCE 6,763,058 6,763,058 COMMITTED FUND BALANCE NET REVENUES / EXPENDITURES (53,488) (53,488) TOTAL FUND BALANCE 9,117,885 2,007,484 11,125,369 TOTAL LIABILITIES AND FUND BALANCE 10,165,305 2,007,484 12,172,789 glbase_tbam skrolczyk Trophy Club MUD No.1 Page 3 17:28 12/07/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: Revenues Program: Period Ending: 11/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-40000-000-000 135-40002-000-000 135-40015-000-000 135-40025-000-000 Property Taxes Property Taxes/Delinquent Property Taxes/P & I PID Surcharges 136,531.00- 136,531.00- 300.00- 300.00- 300.00- 300.00- 163,725.00- 163,725.00- 135-47000-000-000 Water 5,932,489.00- 5,932,489.00- 135-47005-000-000 Sewer 3,677,146.00- 3,677,146.00- 135-47025-000-000 Penalties 112,608.00- 112,608.00- 135-47030-000-000 Service Charges 16,550.00- 16,550.00- 135-47035-000-000 Plumbing Inspections 750.00- 750.00- 135-47045-000-000 Sewer Inspections 2,500.00- 2,500.00- 135-47070-000-000 TCCC Effluent Charges 50,000.00- 50,000.00- 135-49011-000-000 135-49016-000-000 135-49026-000-000 135-49075-000-000 135-49900-000-000 Interest Income Cell Tower Revenue Proceeds from Sale of Assets Oversize Meter Reimbursement Miscellaneous Income 9,792,043.00- 9,792,043.00- 100,000.00- 100,000.00- 14,146.00- 14,146.00- 5,000.00- 5,000.00- 8,232.00- 8,232.00- 7,000.00- 7,000.00- 6,177.64- 8.70- 6.07- 7,163.96- 330.13- 8.34- 92.41- . 7, 412,931.98- 934,067.84- 281,022.83- 511,411.62- 8,909.13- 16,566.73- 1,200.00- 3,200.00- 3,004.80- 17,044.00- 707,068.74- 1,482,290.19- 1,924.58- 3,939.77- 1,178.81- 2,357.62- 19,575.00- 19,575.00- 207.28- 394.39- 5.247 110.043 2.780 15.745 13.908 14.712 19.335 34.088 15.138 3.940 16.666 391.500 5.634 .82- 1,516,059.40- 129,367.04- 30.13 291.66- 163,725.00- 4,998,421.16- 3,165,734.38- 96,041.27- 13,350.00- 750.00- 2,500.00- 32,956.00- 8,309,752.81- 96,060.23- 11,788.38- 14,575.00 8,232.00- 6,605.61- 8,711,21 8,711,217-W 8,711,217.60- glbase_tbam skrolczyk Trophy Club MUD No.1 17:28 12/07/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Program: Period Ending: 11/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-010-000 Salaries & Wages 365,309.00 365,309.00 135-50010-010-000 Overtime 17,000.00 17,000.00 135-50016-010-000 Longevity 5,435.00 5,435.00 135-50017-010-000 Certification 6,000.00 6,000.00 135-50020-010-000 Retirement 36,520.00 36,520.00 135-50026-010-000 Medical Insurance 86,182.00 86,182.00 135-50027-010-000 Dental Insurance 4,933.00 4,933.00 135-50028-010-000 Vision Insurance 789.00 789.00 135-50029-010-000 Life Insurance & Other 3,289.00 3,289.00 135-50030-010-000 Social Security Taxes 24,412.00 24,412.00 135-50035-010-000 Medicare Taxes 5,709.00 5,709.00 135-50040-010-000 Unemployment Taxes 1,080.00 1,080.00 135-50045-010-000 Workman's Compensation 10,877.00 10,877.00 135-50060-010-000 Pre-emp Physicals/Testing 400.00 400.00 135-50070-010-000 Employee Relations 300.00 300.00 27,405.16 1,559.89 5,435.00 250.00 3,208.60 5,225.04 316.63 48.18 325.83 2,117.74 495.28 16.58 901.29 50,412.82 13.800 314,896.18 3,258.18 19.166 13,741.82 5,435.00 100.000 450.00 7.500 5,550.00 7,192.56 19.695 29,327.44 10,450.08 12.126 75,731.92 633.26 12.837 4,299.74 96.36 12.213 692.64 629.66 19.144 2,659.34 3,658.36 14.986 20,753.64 855.59 14.987 4,853.41 50.99 4.721 1,029.01 1,802.58 16.572 9,074.42 400.00 103.13 103.13 34.377 196.87 FSubtotal: ' 568,235.00 568,235.00 = 47,408.35 135-55005-010-000 Engineering 20,000.00 20,000.00 20,000.00 135-55080-010-000 Maintenance & Repairs 124,000.00 124,000.00 5,126.50 5,801.92 24,212.78 19.526 99,787.22 135-55085-010-000 Generator Maint. and Repair 3,000.00 3,000.00 3,000.00 135-55090-010-000 Vehicle Maintenance 5,000.00 5,000.00 119.50 1,161.59 23.232 3,838.41 135-55105-010-000 Maintenance-Backhoe/SkidLoader 3,500.00 3,500.00 3,500.00 135-55120-010-000 Cleaning Services 1,000.00 1,000.00 912.50 87.50 1,000.00 100.000 135-55135-010-000 Lab Analysis 7,500.00 7,500.00 4,280.00 4,713.94 62.853 2,786.06 Page 4 164,000.00 164,000.00 6,008.92 132,911.69 135-60010-010-000 Communications/Mobiles 7,500.00 7,500.00 5,748.52 135-60020-010-000 Electricity 123,487.00 123,487.00 110,992.82 135-60066-010-000 Publications/Books/Subscripts 1,000.00 1,000.00 135-60070-010-000 Dues & Memberships 500.00 500.00 135-60080-010-000 Schools & Training 7,426.00 7,426.00 135-60090-010-000 Safety Program 400.00 400.00 135-60100-010-000 Travel & per diem 2,875.00 2,875.00 135-60105-010-000 Rent/Lease Equipment 1,500.00 1,500.00 135-60135-010-000 TCHQ Fees & Permits 30,000.00 30,000.00 8,454.95- 135-60150-010-000 Wholesale Water 2,596,295.00 2,596,295.00 193,524.75- 135-60245-010-000 Miscellaneous Expenses 200.00 200.00 135-60280-010-000 Property Maintenance 3,000.00 3,000.00 135-60285-010-000 Lawn Equipment & Maintenance 14,750.00 14,750.00 135-60332-010-000 Interfund Transfer Out -Rev I&S 565,820.00 565,820.00 135-60334-010-000 Interfund Transfer Out 75,000.00 75,000.00 135-60360-010-000 Furniture/Equipment < $5000 2,500.00 2,500.00 751.48 11,774.79 111.00 14,951.94 193,524.75 51,438.13 6,500.00 86.667 1,000.00 134,104.32 108.598 10,617.32- 516.00 51.600 484.00 500.00 111.00 1.495 7,315.00 400.00 2,875.00 1,500.00 6,496.99 21.657 23,503.01 54,579.12 2.102 2,541,715.88 200.00 3,000.00 750.00 5.085 14,000.00 102,876.26 18.182 462,943.74 75,000.00 2,500.00 glbase_tbam skrolczyk Trophy Club MUD No.1 17:28 12/07/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 10 Water Period Ending: 11/2020 Account Description Adopted Amended Total 135-65005-010-000 Fuel & Lube 135-65010-010-000 Uniforms 135-65030-010-000 Chemicals 135-65035-010-000 Small Tools 135-65040-010-000 Safety Equipment 135-65050-010-000 Meter Expense 135-65053-010-000 Meter Change Out Program 135-69005-010-000 135-69008-010-000 135-69009-010-000 135-69195-010-000 135-69281-010-000 Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Water Tank Inspection Contract Budget Budget Encumb. 15,000.00 15,000.00 5,190.00 5,190.00 103.30 25,000.00 25,000.00 9,387.69 1,200.00 1,200.00 1,000.00 1,000.00 70,000.00 70,000.00 87,000.00 87,000.00 86,625.00 740,000.00 740,000.00 106,781.50 30,962.00 30,962.00 2,324.00 2,324.00 75,000.00 75,000.00 108,000.00 108,000.00 Current Month 2,55 635.26 542.71 2,133.00 3,517.50 60,148.68 Program: YTD % of Remaining Total Budget Budget 1,159.45 2,166.24 13,199.02 86,625.00 103,149.7 160,769.55 75,000.00 60,148.68 7.730 13,840.55 41.739 3,023.76 52.796 11,800.98 1,200.00 1,000.00 70,000.00 99.569 375.00 21.726 579,230.45 30,962.00 2,324.00 100.000 55.693 47,851.32 Page Program glbase_tbam skrolczyk 17:28 12/07/20 Fund: 135 MUD 1 General Fund Account 135-55135-010-001 Subtotal: Description Lab Analysis for PID Program number: 1 Lab Analysis for PU1111111111 Department number: Water Trophy Club MUD No.1 Budget Summary with Amendment Department: 10 Water Period Ending: 11/2020 Program: 1 Lab Analysis for PID Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 2,000.00 2,000.00 1,120.00 213.94 1,413.94 2,000.00 2,000.00 5,327,164.00 2,000.00 2,000.00 5,327,164.00 1,120.00 213.94 1,120.00 213.94 129,098.13 393,160.45 1,413.94 1,413.94 822,532.45 70.697 70.697 70.697 15.440 586.06 586.06 586.06 4,504,631.55 Page 6 glbase_tbam skrolczyk Trophy Club MUD No.1 17:28 12/07/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Period Ending: 11/2020 Account Description Adopted Amended Total Current Budget Budget Encumb. Month 135-50005-020-000 Salaries & Wages 483,633.00 483,633.00 135-50010-020-000 Overtime 33,000.00 33,000.00 135-50016-020-000 Longevity 7,420.00 7,420.00 135-50017-020-000 Certification 8,100.00 8,100.00 135-50020-020-000 Retirement 49,358.00 49,358.00 135-50026-020-000 Medical Insurance 122,035.00 122,035.00 135-50027-020-000 Dental Insurance 6,443.00 6,443.00 135-50028-020-000 Vision Insurance 1,098.00 1,098.00 135-50029-020-000 Life Insurance & Other 4,725.00 4,725.00 135-50030-020-000 Social Security Taxes 32,993.00 32,993.00 135-50035-020-000 Medicare Taxes 7,716.00 7,716.00 135-50040-020-000 Unemployment Taxes 1,440.00 1,440.00 135-50045-020-000 Workman's Compensation 14,607.00 14,607.00 135-50060-020-000 Pre-emp Physicals/Testing 400.00 400.00 135-50070-020-000 Employee Relations 300.00 300.00 FSubtotal: 773,268.00 773,268.00 135-55005-020-000 Engineering 30,000.00 30,000.00 135-55070-020-000 Independent Labor 15,000.00 15,000.00 135-55080-020-000 Maintenance & Repairs 108,000.00 108,000.00 135-55081-020-000 Mainten & Revairs Collections 157,500.00 157,500.00 135-55085-020-000 Generator Meant. and Repair 10,000.00 10,000.00 135-55090-020-000 Vehicle Maintenance 4,000.00 4,000.00 135-55091-020-000 Veh Maintenance Collections 13,000.00 13,000.00 135-55105-020-000 Maintenance-Backhoe/SkidLoader 3,000.00 3,000.00 135-55120-020-000 Cleaning Services 1,500.00 1,500.00 135-55125-020-000 Dumpster Services 100,000.00 100,000.00 135-55135-020-000 Lab Analysis 40,000.00 40,000.00 135-60010-020-000 Communications/Mobiles 7,500.00 7,500.00 135-60020-020-000 Electricity 157,735.00 157,735.00 135-60066-020-000 Publications/Books/Subscripts 200.00 200.00 135-60070-020-000 Dues & Memberships 300.00 300.00 135-60080-020-000 Schools & Training 4,991.00 4,991.00 135-60090-020-000 Safety Program 1,000.00 1,000.00 135-60100-020-000 Travel & per diem 1,575.00 1,575.00 135-60105-020-000 Rent/Lease Equipment 5,000.00 5,000.00 135-60125-020-000 Advertising 2,500.00 2,500.00 135-60135-020-000 TCEQ Fees & Permits 45,000.00 45,000.00 135-60245-020-000 Miscellaneous Expenses 450.00 450.00 135-60280-020-000 Property Maintenance 5,000.00 5,000.00 35,806.94 2,164.49 7,420.00 550.00 4,254.18 7,739.58 430.81 69.78 421.04 2,746.62 642.34 14.67 1,218.11 Program: YTD % of Remaining Total Budget Budget 66,265.58 13.702 417,367.42 3,716.99 11.264 29,283.01 7,420.00 100.000 1,175.00 14.506 6,925.00 9,513.38 19.274 39,844.62 15,479.16 12.684 106,555.84 861.62 13.373 5,581.38 139.56 12.710 958.44 810.08 17.145 3,914.92 4,730.31 14.337 28,262.69 1,106.29 14.338 6,609.71 51.53 3.578 1,388.47 2,436.22 16.678 12,170.78 400.00 103.12 103.12 34.373 196.88 113, 659,459.16 63,581.68 708.00 1,412.50 89,940.50 27,506.51 5,607.80 133,802.68 30,000.00 15,000.00 10,266.26 16,230.99 15.029 91,769.01 44.65 44.65 .028 157,455.35 10,000.00 224.36 1,672.86 41.822 2,327.14 4,985.65 5,352.15 41.170 7,647.85 272.55 272.55 9.085 2,727.45 87.50 1,500.00 100.000 4,676.04 100,000.00 100.000 5,169.34 35,505.00 88.763 4,495.00 964.07 6,571.87 87.625 928.13 12,347.41 157,705.27 99.981 29.73 200.00 300.00 113.75 2.279 4,877.25 1,000.00 1,575.00 5,000.00 2,500.00 9,888.02 21.973 35,111.98 450.00 5,000.00 Page 7 glbase_tbam skrolczyk Trophy Club MUD No.1 17:28 12/07/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 20 Wastewater Program: Period Ending: 11/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60285-020-000 135-60331-020-000 135-60332-020-000 135-60334-020-000 135-60360-020-000 Lawn Equipment & Maintenance Interfund Transfer Out -Tax I&S Interfund Transfer Out -Rev I&S Interfund Transfer Out Furniture/Equipment < $5000 14,000.00 14,000.00 114,681.00 114,681.00 688,005.00 688,005.00 75,000.00 75,000.00 2,000.00 2,000.00 10,425.55 62,545.87 890.00 20,851.10 125,091.74 35.90 6.357 13,110.00 18.182 93,829.90 18.182 562,913.26 75,000.00 1.795 1,964.10 Page 8 1,124,937.00 1,124,937.00 139,410.48 86,282.90 803,789.35 135-65005-020-000 Fuel & Lube 12,500.00 12,500.00 756.43 135-65010-020-000 Uniforms 6,280.00 6,280.00 1,727.36- 3,661.73 135-65030-020-000 Chemicals 25,000.00 25,000.00 5,282.50 135-65031-020-000 Chemicals Collections 17,500.00 17,500.00 135-65035-020-000 Small Tools 1,200.00 1,200.00 135-65040-020-000 Safety EQuipment 1,200.00 1,200.00 135-65045-020-000 Lab Supplies 28,000.00 28,000.00 7,435.95 FSubtotal: !91,680.00 ' 3,555.14 135-69005-020-000 Capital Outlays 335,000.00 335,000.00 120,653.75 34,492.50 135-69008-020-000 Short Term Debt -Principal 81,273.00 81,273.00 135-69009-020-000 Short Term Debt -Interest 8,532.00 8,532.00 135-69195-020-000 Gasb34/Reserve for Replacement 130,000.00 130,000.00 120,653.75 34,492.50 FProgram number: Department number: Wastewater 3,026,690.00 3,026,690.00 383,186.88 221,937.54 3,026,690.00 3,026,690.00 383,186.88 221,937.54 1,406.50 1,934.37 8,856.60 252.00 11,999.83 24,449.30 162,770.25 130,000.00 2MJ0.25 914.24 914.24 11.252 11,093.50 30.802 4,345.63 35.426 16,143.40 17,500.00 1,200.00 21.000 948.00 42.857 16,000.17 48.588 172,229.75 81,273.00 8,532.00 100.000 52.770 30.157 2,113,93 30.157 2,113,93 glbase_tbam skrolczyk 17:28 12/07/20 Fund: 135 MUD 1 General Fund Account 135-50045-026-000 Description Workman's Compensation Trophy Club MUD No.1 Budget Summary with Amendment Department: 26 Board of Directors Period Ending: 11/2020 Adopted Amended Total Current Budget Budget Encumb. Month 30.00 30.00 .79 Program: YTD Total 1.58 % of Remaining Budget Budget 5.267 28.42 Page 9 135-60066-026-000 135-60070-026-000 135-60075-026-000 135-60080-026-000 135-60100-026-000 135-60245-026-000 Publications/Books/Subscripts Dues & Memberships Meetings Schools & Training Travel & per diem Miscellaneous Expenses 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 150.00 750.00 1,300.00 4,000.00 5,000.00 2,000.00 78.99 57.50 168.49 12.961 57.50 2.875 150.00 750.00 1,131.51 4,000.00 5,000.00 1,942.50 Subtotal: 13,200.00 13,200.00 136.49 225.99 1.712 12,974.01 Program number: 13,230.00 13,230.00 137.28 227.57 1.720 13,002.43 L Department number: Board of Directors 13,230.00 13,230.00 137.28 227.57 1.720 13,002.43 glbase_tbam skrolczyk Trophy Club MUD No.1 17:28 12/07/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-50005-030-000 Salaries & Wages 626,592.00 626,592.00 135-50010-030-000 Overtime 2,000.00 2,000.00 135-50016-030-000 Longevity 2,668.00 2,668.00 135-50020-030-000 Retirement 58,550.00 58,550.00 135-50026-030-000 Medical Insurance 136,834.00 136,834.00 135-50027-030-000 Dental Insurance 7,109.00 7,109.00 135-50028-030-000 Vision Insurance 1,138.00 1,138.00 135-50029-030-000 Life Insurance & Other 4,730.00 4,730.00 135-50030-030-000 Social Security Taxes 39,138.00 39,138.00 135-50035-030-000 Medicare Taxes 9,153.00 9,153.00 135-50040-030-000 Unemployment Taxes 1,440.00 1,440.00 135-50045-030-000 Workman's Compensation 1,573.00 1,573.00 135-50060-030-000 Pre-emp Physicals/Testing 500.00 500.00 135-50070-030-000 Employee Relations 8,000.00 8,000.00 39,933.98 74,568.22 11.901 552,023.78 67.67 67.67 3.384 1,932.33 2,667.50 2,667.50 99.981 .50 3,951.17 9,704.27 16.574 48,845.73 6,809.48 14,779.65 10.801 122,054.35 369.77 811.73 11.418 6,297.27 55.47 121.07 10.639 1,016.93 423.01 830.02 17.548 3,899.98 7,222.91 9,316.61 23.805 29,821.39 578.17 1,067.81 11.666 8,085.19 1,440.00 128.50 257.00 16.338 1,316.00 500.00 78.83 .985 7,921.17 Page 10 899,425.00 899,425.00 785,154.62 135-55030-030-000 135-55070-030-000 135-55080-030-000 135-55085-030-000 135-55120-030-000 135-55160-030-000 135-55205-030-000 Software & Support Independent Labor Maintenance & Repairs Generator Maint. and Repair Cleanini7 Services Professional Outside Services Utility Billing Contract 126,854.00 126,854.00 15,000.00 15,000.00 40,000.00 40,000.00 10,000.00 10,000.00 15,000.00 15,000.00 104,925.00 104,925.00 9,000.00 9,000.00 8,997.26 3,719.46 45,883.66 36.170 80,970.34 595.00 595.00 3.967 14,405.00 2,209.25 5,770.93 14.427 34,229.07 10,000.00 13,028.08 1,896.92 15,000.00 100.000 5,292.50 63,168.50 60.203 41,756.50 6,839.17 578.56 8,000.00 88.889 1,000.00 135-60005-030-000 Telephone 135-60010-030-000 Communications/Mobiles 135-60020-030-000 Electricity/Gas 135-60025-030-000 Water 135-60035-030-000 Postage 135-60040-030-000 Service Charges & Fees 135-60050-030-000 Bad Debt Expense 135-60055-030-000 Insurance 135-60066-030-000 Publications/Books/Subscripts 135-60070-030-000 Dues & Memberships 135-60075-030-000 Meetings 135-60079-030-000 Public Education 135-60080-030-000 Schools & Training 135-60100-030-000 Travel & per diem 135-60110-030-000 Physicals/Testing 135-60115-030-000 Elections 135-60125-030-000 Advertising 9,680.00 9,680.00 3,000.00 3,000.00 14,512.00 14,512.00 5,000.00 5,000.00 30,000.00 30,000.00 67,000.00 67,000.00 1,500.00 1,500.00 84,000.00 84,000.00 1,000.00 1,000.00 6,000.00 6,000.00 400.00 400.00 6,000.00 6,000.00 6,850.00 6,850.00 3,575.00 3,575.00 200.00 200.00 5,000.00 5,000.00 2,500.00 2,500.00 2,760.00 547.53 3,748.44 38.724 5,931.56 225.00 450.00 15.000 2,550.00 2,204.14 1,157.47 3,894.68 26.838 10,617.32 272.93 593.03 11.861 4,406.97 17,696.13 1,946.42 21,418.17 71.394 8,581.83 500.00 7,728.59 16,249.52 24.253 50,750.48 1,500.00 6,724.87 13,449.74 16.012 70,550.26 1,000.00 100.00 200.00 3.333 5,800.00 400.00 111.00 1.850 5,889.00 129.00 204.00 2.978 6,646.00 95.34 2.667 3,479.66 200.00 59.43 1.189 4,940.57 2,500.00 glbase_tbam skrolczyk Trophy Club MUD No.1 17:28 12/07/20 Budget Summary with Amendment Fund: 135 MUD 1 General Fund Department: 30 Administration Program: Period Ending: 11/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135-60235-030-000 135-60245-030-000 135-60246-030-000 135-60285-030-000 135-60360-030-000 Security Miscellaneous Expenses General Manager Contingency Lawn EquiQFnent & Maintenance Furniture/Equipment < $5000 1,288.00 1,288.00 500.00 500.00 17,000.00 17,000.00 5,000.00 5,000.00 2,500.00 2,500.00 72.00 72.00 272.00 272.00 90.00 5.590 1,216.00 54.400 228.00 17,000.00 1.800 4,910.00 2,500.00 Page 11 7 272,505.00 272,505.00 23,160.27 19,175 22.351 135-65010-030-000 Uniforms 135-65055-030-000 Hardware 135-65085-030-000 Office Supplies 135-65095-030-000 Maintenance Supplies 135-65105-030-000 Printing 135-69005-030-000 135-69170-030-000 Capital Outlays Copier Lease Installments Department number: Administration 2,050.00 2,050.00 20,253.00 20,253.00 6,000.00 6,000.00 4,000.00 4,000.00 2,500.00 2,500.00 138,000.00 138,000.00 4,000.00 4,000.00 1,1111111111 1.1111111111 1,669,5 1,483.60 3,400.00 16,148.74 177.80 363.06 96.16 244.84 112,705.73 17,632.34 871.32 546.84 19,050. 50,321.16 419.84 2,050.00 87.060 2,620.66 14.522 5,128.68 13.671 3,453.16 2,500.00 36.465 87,678.84 10.496 3,580.16 50,741. 383,387. 383'387.11111111111111,64 12 1,286,12 glbase_tbam skrolczyk 17:28 12/07/20 Fund: 135 MUD 1 General Fund Account Description 135-55045-039-000 135-55055-039-000 135-55060-039-000 1 135-55065-039-000 Le al Auditing_ Appraisal Tax Admin Fees Trophy Club MUD No.1 Budget Summary with Amendment Department: 39 Non Departmental Program: Period Ending: 11/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 135,000.00 33,800.00 11,925.00 4,850.00 135,000.00 33,800.00 11,925.00 4,850.00 3,325.00- 15,225.00- 3,325.00 15,225.00 1,397.50 107.67- 1.035 -.903 133,602.50 33,800.00 12,032.67 4,850.00 Page 12 ir Subtotal: ' 185,575.00 185,575.00 18,550.00- 18,550.00 1,289.83 .695 184,285.17 Program number: 185,575.00 185,575.00 18,550.00- 18,550.00 1,289.83 .695 184,285.17 Department number: Non Departmental 185,575.00 185,575.00 18,550.00- 18,550.00 1,289.83 .695 184,285.17 Expenditures Subtotal 10,222,171.00 10,222,171.00 550,643.39 746,491.00 2,120,191.41 20.741 8,101,979.59 Fund number: 135 MUD 1 General Fund 5,106.00- 5,106.00- 550,643.39 10,344.18 604,132.01 ############### 609,238.01- glbase_tbam skrolczyk Trophy Club MUD No.1 17:28 12/07/20 Budget Summary with Amendment Fund: 137 MUD 1 Consolidated GASB Department: Program: Period Ending: 11/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 137-49145-000-000 Intergov Transfer -General Fund 205,000.00- 205,000.00 137-49146-000-000 Intergov Transfer -Fire Dept 81,420.00- 81,420.00 Subtot 286, H Program number: 286,420.00- 286,420.00 Department number: 286,420.00- 286,420.00 Revenues Subtotal 286,420.00- 286,420.00 Fund number: 137 MUD 1 Consolidated GASB 286,420.00- 286,420.00 Page 13 TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST BALANCE SHEET NOVEMBER 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 486,462 TOTAL ASSETS 486,462 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 685,476 TOTAL LIABILITIES 685,476 FUND BALANCE ASSIGNED FUND BALANCE (199,119) NET REVENUES / EXPENDITURES 105 TOTAL FUND BALANCE (199,014) TOTAL LIABILITIES AND FUND BALANCE 486,462 glbase tbam skrolczyk Trophy Club MUD No.1 17:28 12/07/20 Budget Summary with Amendment Fund: 517 2014 MUD 1 Tax Bond Const WWTP Department: Revenues Program: Period Ending: 11/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 1 517-49011-000-000 Interest Income 49.23- 104.99- 104.99 Page 14 Subtotal: 49.23- 104.99- 104.99 Program number: 49.23- 104.99- 104.99 Department number: Revenues 49.23- 104.99- 104.99 Revenues Subtotal 49.23- 104.99- 104.99 I Fund number: 517 2014 MUD 1 Tax Bond Const WWTP ! 49.23- 104.99- 104.99 TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET NOVEMBER 2020 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 1 OPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 784,980 TOTAL ASSETS 784,980 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 81,691 81,691 703,276 13 703,289 784,980 glbase tbam skrolczyk Trophy Club MUD No.1 17:28 12/07/20 Budget Summary with Amendment Fund: 519 2016 Rev Bond Const -SWIFT Department: Revenues Program: Period Ending: 11/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1 1 519-49011-000-000 Interest Income 6.67- 13.12- 13.12 Page 15 Subtotal: 6.67- 13.12- 13.12 Program number: 6.67- 13.12- 13.12 Department number: Revenues 6.67- 13.12- 13.12 Revenues Subtotal 6.67- 13.12- 13.12 I Fund number: 519 2016 Rev Bond Const -SWIFT TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET NOVEMBER 2020 MI TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 256,375 INVESTMENTS 3,892,590 ACCOUNTS RECEIVABLE TOTAL ASSETS 4,148,965 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 4,151,382 (2,417) 4,148,965 4,148,965 59.26- 121.77- 121.77 59.26- 121.77- 121.77 glbase_tbam skrolczyk Trophy Club MUD No.1 17:28 12/07/20 Budget Summary with Amendment Fund: 520 Revenue Bond 16" Waterline Department: Program: Period Ending: 11/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 520-49011-000-000 Interest Income 59.26- 121.77- 121.77 Subtotal: Program number: 59.26- 121.77- 121.77 Department number: Revenues Subtotal 59.26- 121.77- 121.77 Page 16 glbase_tbam skrolczyk 17:28 12/07/20 Fund: 520 Revenue Bond 16" Waterline Account Description 520-69005-010-000 Capital Outlays Trophy Club MUD No.1 Budget Summary with Amendment Department: 10 Water Department Program: Period Ending: 11/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 2,538.78 2,538.78- Page 17 Subtotal: 2,538.78 2,538.78- Department number: Water Department Expenditures Subtotal Fund number: 520 Revenue Bond 16" Waterline 59.26- 2,538.78 2,538.78 2,417.01 2,538.78- 2,538.78- 2,417.01 - TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET NOVEMBER 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE NI TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 894,059 TOTAL ASSETS 894,059 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 893,867 192 894,059 894,059 glbase_tbam skrolczyk Trophy Club MUD No.1 17:28 12/07/20 Budget Summary with Amendment Fund: 528 2015 Revenue Bond Reserve Fund Department: Program: Period Ending: 11/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 528-49011-000-000 Interest Income 10,000.00- 10,000.00 - Subtotal: 10,000.00- 10,000.00 - Program number: 10,000.00- 10,000.00 - Department number: = 10,000.00- 10,000.00 - Revenues Subtotal 10,000.00- 10,000.00 - Fund number: 528 2015 Revenue Bond Reserve Fund 10,000.00- 10,000.00- 90.45- 90.45- 90.45- 90.45- 90.45- 90.45- 191.78- 191.78- 191.78- 191.78- 191.78- 191.78- 1.918 1.918 1.918 1.918 1.918 1.918 9,808.22- 9,808.22- 9,808.22- 9,808.22- 9,808.22- 9,808.22- Page ,808.22-9,808.22-9,808.22-9,808.22-9,808.22- 9,808.22- Page 18 TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET NOVEMBER 2020 ASSETS CASH IN BANK INVESTMENTS 93,319 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 636,278 ACCOUNTS RECEIVABLE -OTHER - TOTAL ASSETS 729,598 LE TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 636,278 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 636,278 FUND BALANCE ASSIGNED FUND BALANCE 34,511 NET REVENUES / EXPENDITURES 58,809 TOTAL FUND BALANCE 93,319 TOTAL LIABILITIES AND FUND BALANCE 729,598 glbase tbam skrolczyk Trophy Club MUD No.1 17:28 12/07/20 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: Revenues Program: Period Ending: 11/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 533-40000-000-000 533-40002-000-000 533-40015-000-000 Subtotal: Property Taxes Property Taxes/Delinquent Property Taxes/P & I 691,010.00- 1,000.00- 2,000.00- 691,010.00- 1,000.00- 2,000.00- 31,271.61- 45.02- 10.31- 36,264.37- 1,661.01- 21.85- 5.248 166.101 1.093 654,745.63- 661.01 1,978.15 - Page 19 Mr - 694,010.00 - AL 31,326.94- 37,947.23- 656,062.77- 533-49011-000-000 533-49015-000-000 533-49141-000-000 Interest Income Lease/Rental Income Interfund Trans In -PID Surchg 5,000.00- 197,281.00- 114,681.00- 5,000.00- 197,281.00- 114,681.00- 6.22- 10.34- 10,425.55- 20,851.10- .207 18.182 4,989.66- 197,281.00- 93,829.90 - Subtotal: 316,962.00- 316,962.00- 10,431.77- 20,861.44- 6.582 296,100.56 - Program number: 1,010,972.00- 1,010,972.00- 41,758.71- 58,808.67- 5.817 952,163.33 - Department number: Revenues 1,010,972.00- 1,010,972.00- 41,758.71- 58,808.67- 5.817 952,163.33 - Revenues Subtotal 1,010,972.00- 1,010,972.00- 41,758.71- 58,808.67- 5.817 952,163.33- glbase tbam skrolczyk Trophy Club MUD No.1 17:28 12/07/20 Budget Summary with Amendment Fund: 533 MUD 1 I&S Consolidated Department: 51 Administration Program: Period Ending: 11/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget Page 20 533-70005-051-000 Paying Agent Fee 2,900.00 2,900.00 2,900.00 I 533-70025-051-000 Bond Interest Expense -Tax 190,073.00 190,073.00 190,073.00 I 533-70035-051-000 Bond Principal Payment -Tax 810,000.00 810,000.00 810,000.00 I Subtotal: 1,002,973.00 1,002,973.00 1,002,973.00 Program number: 1,002,973.00 1,002,973.00 1,002,973.00 Department number: Administration 1,002,973.00 1,002,973.00 1,002,973.00 Expenditures Subtotal 1,002,973.00 1,002,973.00 1,002,973.00 Fund number: 533 MUD 1 I&S Consolidated 7,999.00- 7,999.00- 41,758.71- 58,808.67- 735.200 50,809.67 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET NOVEMBER 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 135,243 TOTAL ASSETS 135,243 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE TOTAL LIABILITIES AND FUND BALANCE 25,988 109,255 135,243 135,243 glbase_tbam skrolczyk 17:28 12/07/20 Fund: 534 2015 Revenue Bond I&S Account Description 534-49011-000-000 Interest Income 534-49143-000-000 Interfund Transfer In-ww Sales Subtot Program number: Department number: Revenues Revenues Subtotal Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Period Ending: 11/2020 Adopted Amended Total Current Budget Budget Encumb. Month 2,500.00- 600,838.00- 2,500.00- 600,838.00- 6090- 60 6030- 60 60338.00- 60 603,338.00- 603,33 8.30- 54,621.59 - 54,629.89- Program: YTD % of Remaining Total Budget Budget 11.68- 109,243.18- 109,254.86 - 109,254.86- 109,254.86- 109,254.86- Page 21 .467 2,488.32- I 18.182 491,594.82- I 18.108 18.108 18.108 18.108 494,083.14- 494,083. 494,083.14- 494,083.14- glbase tbam skrolczyk Trophy Club MUD No.1 17:28 12/07/20 Budget Summary with Amendment Fund: 534 2015 Revenue Bond I&S Department: 51 Administration Program: Period Ending: 11/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 534-70005-051-000 534-70040-051-000 534-70045-051-000 Rev Bond Paying Agent Fee Revenue Bona Interest Expense Revenue Bond Principal Expense 400.00 200,438.00 400,000.00 400.00 200,438.00 400,000.00 Subtotal: ,111111100,838.00 600,838.00 Program number: iiirmo00,838.00 600,838.00 Department number: Administration - 600,838.00 600,838.00 Expenditures Subtotal - 600,838.00 600,838.00 Fund number: 534 2015 Revenue Bond I&S . 2,500.00- 2,500.00- 54,629.89- 109,254.86- 4,370.194 400.00 200,438.00 400,000.00 600,838.00 600,838.00 600,838.00 600,838.00 106,754.86 Page 22 TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET NOVEMBER 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 55,447 TOTAL ASSETS 55,447 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 5,625 49,822 55,447 TOTAL LIABILITIES AND FUND BALANCE 55,447 glbase_tbam skrolczyk 17:28 12/07/20 Fund: 535 2016 Rev Bond I&S-SWIFT Account Description 535-49011-000-000 Interest Income Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Program: Period Ending: 11/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1,000.00- 535-49142-000-000 Interfund Tran In -Water Sales 273,999.00- Subtot Program number: 0 Department number: 111=99.00 - Revenues Subtotal 274,999.00 - Revenues 1,000.00- 273,999.00- 274,999' 274,999.00- 274,999.00- 274,999.00- 1 1 3.17- 24,909.00- 24,912.17- 24,912.17- 24,912.17- 24,912.17- 3.97- 49,818.00- 4J.97- 49,821.97- .397 18.182 18.117 18.117 18.117 18.117 996.03- 224,181.00- 225, 225,177. 225,177.03- 225,177.03 - Page 23 glbase_tbam skrolczyk Trophy Club MUD No.1 17:28 12/07/20 Budget Summary with Amendment Fund: 535 2016 Rev Bond I&S-SWIFT Department: 51 Administration Program: Period Ending: 11/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 535-70005-051-000 535-70040-051-000 535-70045-051-000 Rev Bond Paying Agent Fee Revenue Bona Interest Expense Revenue Bond Principal Expense 400.00 58,599.00 215,000.00 400.00 58,599.00 215,000.00 Subtotal: ,IIW273,999.00 273,999.00 Program number: III 273,999.00 273,999.00 Department number: Administration mEr 273,999.00 273,999.00 Expenditures Subtotal 273,999.00 273,999.00 Fund number: 535 2016 Rev Bond I&S-SWIFT 1,000.00- 1,000.00- 24,912.17 - 49,821. - 4,982.1 400.00 58,599.00 215,000.00 Page 24 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET NOVEMBER 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE EN TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 69,442 TOTAL ASSETS 69,442 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 531 NET REVENUES / EXPENDITURES 68,911 TOTAL FUND BALANCE 69,442 TOTAL LIABILITIES AND FUND BALANCE 69,442 glbase_tbam skrolczyk 17:28 12/07/20 Fund: 536 2019 Rev Bond I&S- W&WW System Account Description 536-49011-000-000 536-49142-000-000 536-49143-000-000 Subtotal: Interest Income Interfund Tran In -Water Sales Interfund Transfer In -WW Sales Program number: Department number: Revenues Revenues Subtotal Trophy Club MUD No.1 Budget Summary with Amendment Department: Revenues Program: Period Ending: 11/2020 Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 1,000.00- 291,820.00- 87,168.00- 1,000.00- 291,820.00- 87,168.00- 379,988.00- 379,988.00- 379,988.00- 379,988.00- 379,988.00- 379,988.00- 379,988.00- 379,988.00- 3.62- 26,529.13- 7,924.28- 3.88- 53,058.26- 15,848.56- 34,457.03- 68,910.70- ■ 34,457.03- ■ 34,457.03- M 34,457.03- 68,910.70- 68,910.70- 68,910.70- .388 18.182 18.182 18.1, 18.135 18.135 18.135 996.12- 238,761.74- 71,319.44 - Page 25 glbase_tbam skrolczyk Trophy Club MUD No.1 17:28 12/07/20 Budget Summary with Amendment Fund: 536 2019 Rev Bond I&S- W&WW System Department: 51 Administration Program: Period Ending: 11/2020 Account Description Adopted Amended Total Current YTD % of Remaining Budget Budget Encumb. Month Total Budget Budget 536-70005-051-000 536-70040-051-000 536-70045-051-000 Rev Bond Paying Agent Fee Revenue Bona Interest Expense Revenue Bond Principal Expense 400.00 223,588.00 155,000.00 400.00 223,588.00 155,000.00 Subtotal: , gliiiii78,988.00 378,988.00 Program number: 111111178,988.00 378,988.00 Department number: Administration X78,988.00 378,988.00 Expenditures Subtotal 378,988.00 378,988.00 Fund number: 536 2019 Rev Bond I&S- W&WW System 1,000.00- 1,000.00- ******* End of Report ********* 34,457.03- 68,910.70- 6,891.070 400.00 223,588.00 155,000.00 378,988.00 378,988.00 378,988.00 378,988.00 67,910.70 Page 26