Loading...
HomeMy WebLinkAbout2022-06 June Combined FinancialsFY 2022 Combined Financials YTD as of 6/30/2022 YTD Revenues • YTD Expenses Amended Revenues • Amended Expenses Adopted Revenues Adopted Expenses Adopted Budget vs YTD Actuals Revenues & Expenses $7,337,557 $6,464,833 $10,909,758 $10,829,758 $10,370,758 $1,778 R720 0% o% $1,054,960 16% $2,174,872 34% $3,233,942 50% 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 80,639,404 78,390,000 Water Consumption Budget vs Actual 54,635,000 49,322,000 48,488,000 40,021,000 51,338,613 44,024,449 72,448,000 44,588,000 36,662,055 36,449,799 -4—Budget Consumption 38,104,839 85,474,000 119,711,000 96,534,832 63,970,589 56,888,452 —*-Actual Consumption Oct Nov Dec Jan Feb Mar Apr May Jun 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 922,563,305 Total Water Consumption • Budgeted Water Consumption • Projected Water Consumption Presented by: Finance Department 3900,000 $800,000 3700,000 Water Revenue Budget vs Actual 3600,000 $569,186 $500,000 $402,228 $373,428 $370,639 0360,890 $400,000 $455,836 / $328,461 $300,000 / $359,936 $200,000 $100,000 $0 $398,851 $320,532 $322,394 $510,419 8326,817 Budget Revenue --Actual Revenue $786,615 $580,431 $423,949 $466,196 $651,814 Oct Nov Dec Jan Feb Mar Apr May Jun $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 $6,363,045 $3,525,165 1 Total Water Revenue 33,811,427 • 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 JUNE 2022 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 891,450 PREPAID EXPENSES 4,989 ADVALOREM PROPERTY TAXES RECEIVABLE 23,653 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 920,092 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 17,777 TOTAL LIABILITIES 17,777 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 720,907 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 181,409 TOTAL FUND BALANCE 902,315 TOTAL LIABILITIES AND FUND BALANCE 920,092 TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET JUNE 2022 135 137 4 Tfl PHV CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 4,974,957 4,974,957 CASH IN BANK -SAVINGS -CASH RESERVE 1,481,234 1,481,234 INVESTMENTS-TEXPOOL 2,997,926 2,985,575 5,983,500 PREPAID EXPENSES 32,262 32,262 ADVALOREM PROPERTY TAXES RECEIVABLE 2,444 2,444 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,381,619 1,381,619 TOTAL ASSETS 10,871,042 2,985,575 13,856,617 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 992 992 ACCOUNTS AND OTHER PAYABLES 518,403 518,403 CUSTOMER DEPOSITS 323,930 323,930 TOTAL LIABILITIES 843,325 843,325 FUND BALANCE NON -SPENDABLE FUND BALANCE 3,880 3,880 ASSIGNED FUND BALANCE 3,370,500 3,370,500 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 5,780,613 5,780,613 COMMITTED FUND BALANCE - - NET REVENUES / EXPENDITURES 872,725 872,725 TOTAL FUND BALANCE 10,027,717 2,985,575 13,013,292 TOTAL LIABILITIES AND FUND BALANCE 10,871,042 2,985,575 13,856,617 TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET JUNE 2022 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 785,141 TOTAL ASSETS 785,141 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 105 703,450 785,141 TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET JUNE 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 REVENUE BOND 1,832,325 TOTAL ASSETS 1,832,325 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 158,280 TOTAL LIABILITIES 158,280 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 4,032,009 (2,357,964) TOTAL FUND BALANCE 1,674,045 TOTAL LIABILITIES AND FUND BALANCE 1,832,325 TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET JUNE 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 896,017 TOTAL ASSETS 896,017 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 894,311 1,706 896,017 896,017 TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET JUNE 2022 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE ACCOUNTS RECEIVABLE -OTHER 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 533 INTEREST & SINKING DEBT 942,998 13,163 TOTAL ASSETS 956,161 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES ACCOUNTS AND OTHER PAYABLES 57,355 3,624 TOTAL LIABILITIES 60,979 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES (16,307) 911,489 TOTAL FUND BALANCE 895,182 TOTAL LIABILITIES AND FUND BALANCE 956,161 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET JUNE 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB 1 / MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 423,463 TOTAL ASSETS 423,463 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 397,402 423,463 423,463 TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET JUNE 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 204,195 TOTAL ASSETS 204,195 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 5,656 198,539 204,195 204,195 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET JUNE 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 201,519 TOTAL ASSETS 201,519 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 565 NET REVENUES / EXPENDITURES 200,954 TOTAL FUND BALANCE 201,519 TOTAL LIABILITIES AND FUND BALANCE 201,519