Loading...
HomeMy WebLinkAbout2022-11 November Combined FinancialsFY 2023 Combined Financials YTD as of 11/30/2022 YTD Revenues 1119 YTD Expenses Adopted Budget vs YTD Actuals Revenues & Expenses 51,740,189 $1,755,175 • $11,733,354 $11,733,354 $346 $9,308 0% 1% YTD Expenses By Departments YTD Expense- Water YTD Expense- WW YTD Expense- Admin YTD Expense- BOD ■ YTD Expense- Non Dept Water Budget vs Actual 140,000,000 120,000,000 100,000,000 80,000,000 60,000,000 40,000,000 20,000,000 0 Water Consumption Budget vs Actual 88,979,203 101,683,000 41,702,881 49,016,000 —8—Budget Consumption —*-Actual Consumption Oct Nov 1,000,000,000 900,000,000 800,000,000 700,000,000 600,000,000 500,000,000 400,000,000 300,000,000 200,000,000 100,000,000 0 Adopted Budget Water Consumption Vs Actual Water Consumption 808,128,121 828,145,036 Total Water Consumption ■ Budgeted Water Consumption ■ Projected Water Consumption Presented by: Finance Department 51,000,000 $900,000 5800,000 5700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 50 Water Revenue Budget vs Actual —0—Budget Revenue —Actual Revenue Oct Nov $8,000,000 57,000,000 $6,000,000 55,000,000 $4,000,000 53,000,000 $2,000,000 $1,000,000 50 Adopted Budget Water Revenue Vs Projected Water Revenue $6,710,979 56,714,693 $4,070,848 $4,099,167 1 Total Water Revenue ■ Budgeted Water Revenue ■ Projected Water Revenue Net Budgeted Water Revenue Minus Budgeted Expenses ■ Net Projected Water Revenue Minus Projected Expenses TGfPHV CLUB MUNEMPAL urILLTY I][57HI I:, Trophy Club Municipal Utility District No. 1 Fund: 135 - MUD 1 General Fund REVENUE SUMMARY Non Deparmental TOTAL REVENUE EXPENSE SUMMARY Budget Variance Report As Of: 11/30/2022 CURRENT MONTH YEAR TO DATE ANNUAL BUDGET ACTUAL BUDGETED VARIANCE ACTUAL BUDGETED VARIANCE % TOTAL REMAINING % 759,300.94 977,388.37 (218,087.43) 1,740,188.80 1,954,776.74 (214,587.94) 15 11,733,354.00 (9,993,165.20) 85 759,300.94 977,388.37 (218,087.43) 1,740,188.80 1,954,776.74 (214,587.94) 15 11,733,354.00 (9,993,165.20) 85 Non Deparmental 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Water 567,954.86 547,941.66 (20,013.20) 849,759.72 1,095,883.32 246,123.60 13 6,577,932.00 (5,728,172.28) 87 Wastewater 195,426.62 290,877.74 95,451.12 541,465.75 581,755.48 40,289.73 16 3,491,931.00 (2,950,465.25) 84 Board of Directors 230.60 980.01 749.41 346.21 1,960.02 1,613.81 3 11,765.00 (11,418.79) 97 Administration 135,755.14 127,864.23 (7,890.91) 354,296.00 255,728.46 (98,567.54) 23 1,534,986.00 (1,180,690.00) 77 Non Deparmental 4,807.50 9,724.44 4,916.94 9,307.50 19,448.88 10,141.38 8 116,740.00 (107,432.50) 92 TOTAL EXPENSE 904,174.72 977,388.08 73,213.36 1,755,175.18 1,954,776.16 199,600.98 15 11,733,354.00 9,978,178.82 85 REVENUE OVER/(UNDER) EXPENDITURE (144,873.78) 0.29 (144,874.07) (14,986.38) 0.58 (14,986.96) 0.00 (19,971,344.02) 12/9/2022 3:06:23 AM Page 1 of 14 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT Department Trophy Club Municipal Utility District No. 1 Asset 000 - Non Deparmental Liability 000 - Non Deparmental Equity 000 - Non Deparmental Total Revenue Total Expense Revenues Over/Under Expenses 122 - Trophy 135 - MUD 1 137 - MUD 1 519 - 2016 Rev 520 - Revenue 528 - 2015 Club MUD Fire D General Fund Consolidated Bond Const- Bond 16" Revenue Bond GASB SWIFT Waterline Reserve Fund 1,665,644.37 11,283,603.30 3,422,146.58 788,433.85 1,367,045.31 902,848.29 Total Asset: 1,665,644.37 11,283,603.30 3,422,146.58 788,433.85 1,367,045.31 902,848.29 1,156,108.18 851,051.61 0.00 81,691.15 246,595.87 0.00 Total Liability: 1,156,108.18 851,051.61 0.00 81,691.15 246,595.87 0.00 681,803.57 10,447,538.07 2,985,574.58 705,530.20 1,339,096.93 900,604.41 Total Total Beginning Equity: 681,803.57 10,447,538.07 2,985,574.58 705,530.20 1,339,096.93 900,604.41 72,221.18 1,740,188.80 436,572.00 1,212.50 3,720.36 2,243.88 244,488.56 1,755,175.18 0.00 0.00 222,367.85 0.00 -172,267.38 -14,986.38 436,572.00 1,212.50 -218,647.49 2,243.88 Total Equity and Current Surplus (Deficit): Total Liabilities, Equity and Current Surplus (Deficit): 12/9/2022 2:26:10 AM 509,536.19 10,432,551.69 3,422,146.58 706,742.70 1,120,449.44 902,848.29 1,665,644.37 11,283,603.30 3,422,146.58 788,433.85 1,367,045.31 902,848.29 Balance Sheet Account Summary As Of 11/30/2022 Total 19,429,721.70 19,429,721.70 2,335,446.81 2,335,446.81 17,060,147.76 17,060,147.76 2,256,158.72 2,222,031.59 34,127.13 17,094,274.89 19,429,721.70 Page 1 of 1 TROPHY CLUB MUNICIPAL UTILITY DISTRICT Department Trophy Club Municipal Utility District No. 1 Asset 000 - Non Deparmental Liability 000 - Non Deparmental Equity 000 - Non Deparmental 533 - MUD 1 I&S 534 - 2015 535 - 2016 Rev 536 - 2019 Rev Consolidated Revenue Bond Bond I&S-SWIFT Bond I&S- I&S W&WW System 745,017.93 137,966.77 56,671.20 70,442.49 Total Asset: 745,017.93 137,966.77 56,671.20 70,442.49 679,794.59 0.00 0.00 0.00 Total Liability: 679,794.59 0.00 0.00 0.00 4,145.11 27,958.35 6,554.77 1,429.17 Total Total Beginning Equity: 4,145.11 27,958.35 6,554.77 1,429.17 Total Revenue Total Expense Revenues Over/Under Expenses Total Equity and Current Surplus (Deficit): Total Liabilities, Equity and Current Surplus (Deficit): 12/9/2022 2:33:56 AM 61,078.23 110,008.42 50,116.43 69,013.32 0.00 0.00 0.00 0.00 61,078.23 110,008.42 50,116.43 69,013.32 65,223.34 137,966.77 56,671.20 70,442.49 745,017.93 137,966.77 56,671.20 70,442.49 Balance Sheet Account Summary As Of 11/30/2022 Total 1,010,098.39 1,010,098.39 679,794.59 679,794.59 40,087.40 40,087.40 290,216.40 0.00 290,216.40 330,303.80 1,010,098.39 Page 1 of 1