Loading...
HomeMy WebLinkAbout2021-12 December Combined FinancialsFY 2022 Combined Financials YTD as of 12/31/2021 • YTD Revenues Expenses Adopted Budget vs YTD Actuals Revenues & Expenses $2,276,412 $1,997,640 $1,048 $27,276 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 Oct 54,635,000 48,488,000 51,338,613 44,024,449 Budget Consumption —,~Actual Consumption Nov Dec 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 839,609,871 Total Water Consumption • Budgeted Water Consumption • Projected Water Consumption Presented by: Finance Department 5900,000 5800,000 5700,000 5600,000 5500,000 $400,000 $300,000 $200,000 $100,000 So Oct Water Revenue Budget vs Actual $569,186 $398,851 3402,228 Budget Revenue —A—Actual Revenue $370,639 • $359,936 Nov Dec $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 $0 Adopted Budget Water Revenue Vs Projected Water Revenue $6,033,776 $5,934,505 $3,525,165 $3,444,975 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 DECEMBER 2021 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 853,441 PREPAID EXPENSES 14,968 ADVALOREM PROPERTY TAXES RECEIVABLE 679,950 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 1,548,359 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 161,861 TOTAL FUND BALANCE 885,121 663,238 663,238 TOTAL LIABILITIES AND FUND BALANCE 1,548,359 TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET DECEMBER 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,911,590 3,911,590 CASH IN BANK -SAVINGS -CASH RESERVE 2,002,403 2,002,403 INVESTMENTS-TEXPOOL 3,330,026 2,985,575 6,315,601 PREPAID EXPENSES 89,025 89,025 ADVALOREM PROPERTY TAXES RECEIVABLE 72,764 72,764 UTILITY AND OTHER ACCOUNTS RECEIVABLE 933,280 933,280 TOTAL ASSETS 10,339,689 2,985,575 13,325,264 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 71,012 71,012 ACCOUNTS AND OTHER PAYABLES 522,402 522,402 CUSTOMER DEPOSITS 312,210 312,210 TOTAL LIABILITIES 905,624 905,624 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 278,772 278,772 TOTAL FUND BALANCE 9,434,065 2,985,575 12,419,640 TOTAL LIABILITIES AND FUND BALANCE 10,339,689 2,985,575 13,325,264 TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET DECEMBER 2021 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 785,047 TOTAL ASSETS 785,047 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 11 703,356 785,047 TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET DECEMBER 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 REVENUE BOND 2,872,408 TOTAL ASSETS 2,872,408 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 233,620 TOTAL LIABILITIES 233,620 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 4,032,008 (1,393,220) TOTAL FUND BALANCE 2,638,788 TOTAL LIABILITIES AND FUND BALANCE 2,872,408 TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET DECEMBER 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 894,395 TOTAL ASSETS 894,395 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 894,312 NET REVENUES / EXPENDITURES 83 TOTAL FUND BALANCE 894,395 TOTAL LIABILITIES AND FUND BALANCE 894,395 TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET DECEMBER 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 391,018 370,289 TOTAL ASSETS 761,307 LIABILITIES AND FUND BALANCE LIABILITIES 57,355 DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 359,283 ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES 416,639 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES (14,841) 359,509 TOTAL FUND BALANCE 344,668 TOTAL LIABILITIES AND FUND BALANCE 761,307 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET DECEMBER 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB 1 / MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 190,478 TOTAL ASSETS 190,478 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 26,061 164,418 190,478 190,478 TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET DECEMBER 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 81,304 TOTAL ASSETS 81,304 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 5,656 75,648 81,304 TOTAL LIABILITIES AND FUND BALANCE 81,304 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET DECEMBER 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 104,024 TOTAL ASSETS 104,024 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 565 NET REVENUES / EXPENDITURES 103,459 TOTAL FUND BALANCE 104,024 TOTAL LIABILITIES AND FUND BALANCE 104,024