The URL can be used to link to this page

Home My WebLink About2021-11 November Combined FinancialsFY 2022 Combined Financials YTD as of 11/30/2021 • YTD Revenues Expenses Adopted Budget vs YTD Actuals Revenues & Expenses 51,526,577 $1,312,786 5932 $7,563 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 78,390,000 80,639,404 51,338,613 54,635,000 Budget Consumption —,~Actual Consumption Oct Nov 1,000,000,000 900,000,000 800,000,000 700,000,000 600,000,000 500,000,000 400,000,000 300,000,000 200,000,000 100,000,000 0 Adopted Budget Water Consumption Vs Actual Water Consumption 834,099,338 835,146,320 Total Water Consumption • Budgeted Water Consumption • Projected Water Consumption Presented by: Finance Department $900,000 5800,000 $700,000 5600,000 $500,000 $400,000 $300,000 $200,000 $100,000 50 Water Revenue Budget vs Actual $455,836 $569,186 $398,851 J Budget Revenue --Actual Revenue Oct Nov $7,000,000 $6,000,000 $5,000,000 $4,000,000 53,000,000 $2,000,000 $1,000,000 $0 Adopted Budget Water Revenue Vs Projected Water Revenue $6,033,776 $5,923,802 $3,525,165 $3,420,126 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 NOVEMBER 2021 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 1,076,474 PREPAID EXPENSES 16,631 ADVALOREM PROPERTY TAXES RECEIVABLE 1,157,226 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 2,250,331 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,140,514 629,193 1,769,707 723,260 (242,636) 480,624 2,250,331 TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET NOVEMBER 2021 135 137 4 Tfl PHV CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 3,821,755 3,821,755 CASH IN BANK -SAVINGS -CASH RESERVE 2,001,893 2,001,893 INVESTMENTS-TEXPOOL 2,815,233 2,985,575 5,800,808 PREPAID EXPENSES 98,485 98,485 ADVALOREM PROPERTY TAXES RECEIVABLE 123,901 123,901 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,684,263 1,684,263 TOTAL ASSETS 10,546,130 2,985,575 13,531,705 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 122,149 122,149 ACCOUNTS AND OTHER PAYABLES 743,108 743,108 CUSTOMER DEPOSITS 311,790 311,790 TOTAL LIABILITIES 1,177,047 1,177,047 FUND BALANCE NON -SPENDABLE FUND BALANCE 3,880 3,880 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 - - ASSIGNED FUND BALANCE/WWTP MBR REPLACEMENT 300,000 300,000 UNASSIGNED FUND BALANCE 6,054,023 6,054,023 COMMITTED FUND BALANCE - - NET REVENUES / EXPENDITURES 213,791 213,791 TOTAL FUND BALANCE 9,369,083 2,985,575 12,354,658 TOTAL LIABILITIES AND FUND BALANCE 10,546,130 2,985,575 13,531,705 TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST BALANCE SHEET NOVEMBER 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 NOVEMBER 2021 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 785,043 TOTAL ASSETS 785,043 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 7 703,352 785,043 TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET NOVEMBER 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 REVENUE BOND 4,032,256 TOTAL ASSETS 4,032,256 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 1,159,964 TOTAL LIABILITIES 1,159,964 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 4,032,009 (1,159,717) TOTAL FUND BALANCE 2,872,292 TOTAL LIABILITIES AND FUND BALANCE 4,032,256 TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET NOVEMBER 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 894,366 TOTAL ASSETS 894,366 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 894,311 NET REVENUES / EXPENDITURES 55 TOTAL FUND BALANCE 894,366 TOTAL LIABILITIES AND FUND BALANCE 894,366 TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET NOVEMBER 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 108,185 629,993 TOTAL ASSETS 738,178 LIABILITIES AND FUND BALANCE LIABILITIES 57,356 DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 618,987 ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES 676,343 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES (14,841) 76,676 TOTAL FUND BALANCE 61,835 TOTAL LIABILITIES AND FUND BALANCE 738,178 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET NOVEMBER 2021 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB 1 / MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND ASSETS I&S WWTP 80,868 TOTAL ASSETS 80,868 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,807 80,868 TOTAL LIABILITIES AND FUND BALANCE 80,868 TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET NOVEMBER 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 30,872 TOTAL ASSETS 30,872 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,216 30,872 TOTAL LIABILITIES AND FUND BALANCE 30,872 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET NOVEMBER 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 35,052 TOTAL ASSETS 35,052 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 565 NET REVENUES / EXPENDITURES 34,487 TOTAL FUND BALANCE 35,052 TOTAL LIABILITIES AND FUND BALANCE 35,052