Loading...
HomeMy WebLinkAbout2021-10 October Combined FinancialsFY 2022 Combined Financials YTD as of 10/31/2021 • YTD Revenues Expenses Adopted Budget vs YTD Actuals Revenues & Expenses 5797,181 $643,396 1 5816 50 o% 0% 5161,078 $180,819 25% 28% 5300,683 47% 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 Water Consumption Budget vs Actual 80,639,404 78,390,000 Budget Consumption —,~Actual Consumption Oct 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 834,099,338 831,849,933 Total Water Consumption • Budgeted Water Consumption • Projected Water Consumption Presented by: Finance Department 5900,000 5800,000 5700,000 5600,000 5500,000 5400,000 5300,000 5200,000 5100,000 50 Water Revenue Budget vs Actual $569,186 Budget Revenue —*-Actual Revenue Oct $7,000,000 56,000,000 $5,000,000 $4,000,000 53,000,000 $2,000,000 $1,000,000 50 Adopted Budget Water Revenue Vs Projected Water Revenue 56,033,776 $5,920,425 53,525,165 $3,411,813 Total Water Revenue • Budgeted Water Revenue • Projected Water Revenue Net Budgeted Water Revenue Minus Budgeted Expenses • Net Projected Water Revenue Minus Projected Expenses TROPHY CLUB MUD NO. 1 - FIRE DEPARTMENT BALANCE SHEET OCTOBER 2021 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 FIRE DEPT. 175,699 440,003 18,295 1,238,367 TOTAL ASSETS 1,872,363 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 723,260 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES (802,552) TOTAL FUND BALANCE (79,292) 1,221,655 730,000 1,951,655 TOTAL LIABILITIES AND FUND BALANCE 1,872,363 TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET OCTOBER 2021 135 137 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 4,050,640 4,050,640 CASH IN BANK -SAVINGS -CASH RESERVE 2,001,400 2,001,400 INVESTMENTS-TEXPOOL 2,806,216 3,539,876 6,346,092 PREPAID EXPENSES 107,946 107,946 ADVALOREM PROPERTY TAXES RECEIVABLE 132,594 132,594 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,114,774 1,114,774 TOTAL ASSETS 10,214,170 3,539,876 13,754,046 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 130,842 130,842 ACCOUNTS AND OTHER PAYABLES 454,011 454,011 CUSTOMER DEPOSITS 311,690 311,690 TOTAL LIABILITIES 896,543 896,543 FUND BALANCE NON -SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 3,097,390 3,097,390 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 360,000 360,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 1,113,885 1,113,885 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 1,211,690 1,211,690 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 554,301 554,301 ASSIGNED FUND BALANCE/WWTP MBR REPLACEMENT 300,000 200,000 UNASSIGNED FUND BALANCE 6,062,966 6,062,966 COMMITTED FUND BALANCE NET REVENUES / EXPENDITURES 153,785 153,785 TOTAL FUND BALANCE 9,317,627 3,439,876 12,757,503 TOTAL LIABILITIES AND FUND BALANCE 10,214,170 3,439,876 13,654,046 TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST BALANCE SHEET OCTOBER 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TOTAL ASSETS 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 Pi TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET OCTOBER 2021 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 785,040 TOTAL ASSETS 785,040 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,345 4 703,349 785,040 TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET OCTOBER 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 REVENUE BOND 4,032,130 TOTAL ASSETS 4,032,130 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 157,605 TOTAL LIABILITIES 157,605 FUND BALANCE ASSIGNED FUND BALANCE 4,032,009 NET REVENUES / EXPENDITURES (157,484) TOTAL FUND BALANCE 3,874,525 TOTAL LIABILITIES AND FUND BALANCE 4,032,130 TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET OCTOBER 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 894,338 TOTAL ASSETS 894,338 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 894,311 NET REVENUES / EXPENDITURES 27 TOTAL FUND BALANCE 894,338 TOTAL LIABILITIES AND FUND BALANCE 894,338 TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET OCTOBER 2021 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE ACCOUNTS RECEIVABLE -OTHER 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 533 INTEREST & SINKING DEBT 63,486 674,155 TOTAL ASSETS 737,641 LIABILITIES AND FUND BALANCE LIABILITIES 64,064 DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 664,552 ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES 728,616 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES (21,550) 30,575 TOTAL FUND BALANCE 9,025 TOTAL LIABILITIES AND FUND BALANCE 737,641 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET OCTOBER 2021 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB 1 / MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND ASSETS I&S WWTP 80,865 TOTAL ASSETS 80,865 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 26,061 54,804 80,865 TOTAL LIABILITIES AND FUND BALANCE 80,865 TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET OCTOBER 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 30,871 TOTAL ASSETS 30,871 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 5,656 25,215 30,871 TOTAL LIABILITIES AND FUND BALANCE 30,871 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET OCTOBER 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 35,050 TOTAL ASSETS 35,050 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 565 NET REVENUES / EXPENDITURES 34,485 TOTAL FUND BALANCE 35,050 TOTAL LIABILITIES AND FUND BALANCE 35,050