The URL can be used to link to this page

Home My WebLink About2022-04 April Combined FinancialsFY 2022 Combined Financials YTD as of 4/30/2022 YTD Revenues • YTD Expenses Amended Revenues • Amended Expenses Adopted Revenues Adopted Expenses Adopted Budget vs YTD Actuals Revenues & Expenses $5,261,881 $5,032,257 $10,909,758 $10,829,758 $10,370,758 $1,511 $56,633 0% -I 1% $789,926 16% $2,433,694 48% 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 80,639,404 78,390,000 Oct Water Consumption Budget vs Actual 54,635,000 48,488,000 49,322,000 .0021,000 51,338,613 44,024,449 Budget Consumption 36,662,055 36,449,799 —*-Actual Consumption 38,104,839 72,448,000 56,888,452 Nov Dec Jan Feb Mar Apr 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 877,883,726 Total Water Consumption • Budgeted Water Consumption • Projected Water Consumption Presented by: Finance Department 5900,000 5800,000 5700,000 5600,000 $500,000 $400,000 $300,000 $200,000 $100,000 So $569,186 A 0373,428 $370,639 $360,890 $455,836 $328,461 $423,949 $398,851 $359,936 Water Revenue Budget vs Actual 8402,228 $510,419 $320,532 0322,394 0326,817 Budget Revenue --Actual Revenue Oct Nov Dec Jan Feb Mar Apr $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,114,010 $3,525,165 $3,622,001 1 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 APRIL 2022 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 1,029,237 PREPAID EXPENSES 8,316 ADVALOREM PROPERTY TAXES RECEIVABLE 35,343 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 1,072,896 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 29,467 TOTAL LIABILITIES 29,467 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 720,907 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 322,522 TOTAL FUND BALANCE 1,043,429 TOTAL LIABILITIES AND FUND BALANCE 1,072,896 TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET APRIL 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,363,236 4,363,236 CASH IN BANK -SAVINGS -CASH RESERVE 1,480,366 1,480,366 INVESTMENTS-TEXPOOL 3,237,062 2,985,575 6,222,636 PREPAID EXPENSES 51,183 51,183 ADVALOREM PROPERTY TAXES RECEIVABLE 3,697 3,697 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,088,114 1,088,114 TOTAL ASSETS 10,224,258 2,985,575 13,209,833 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,245 2,245 ACCOUNTS AND OTHER PAYABLES 519,246 519,246 CUSTOMER DEPOSITS 318,150 318,150 TOTAL LIABILITIES 839,641 839,641 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 229,624 229,624 TOTAL FUND BALANCE 9,384,617 2,985,575 12,370,192 TOTAL LIABILITIES AND FUND BALANCE 10,224,258 2,985,575 13,209,833 TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET APRIL 2022 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 785,063 TOTAL ASSETS 785,063 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 27 703,372 785,063 TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET APRIL 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 REVENUE BOND 2,128,742 TOTAL ASSETS 2,128,742 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 279,348 TOTAL LIABILITIES 279,348 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 4,032,009 (2,182,615) TOTAL FUND BALANCE 1,849,394 TOTAL LIABILITIES AND FUND BALANCE 2,128,742 TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET APRIL 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 894,807 TOTAL ASSETS 894,807 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 894,311 NET REVENUES / EXPENDITURES 496 TOTAL FUND BALANCE 894,807 TOTAL LIABILITIES AND FUND BALANCE 894,807 TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET APRIL 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 914,132 19,526 TOTAL ASSETS 933,659 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES ACCOUNTS AND OTHER PAYABLES 57,355 9,987 TOTAL LIABILITIES 67,342 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES (16,307) 882,624 TOTAL FUND BALANCE 866,317 TOTAL LIABILITIES AND FUND BALANCE 933,659 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET APRIL 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB 1 / MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 313,378 TOTAL ASSETS 313,378 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 287,317 313,378 313,378 TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET APRIL 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 153,533 TOTAL ASSETS 153,533 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 147,877 153,533 153,533 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET APRIL 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 132,335 TOTAL ASSETS 132,335 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 565 NET REVENUES / EXPENDITURES 131,770 TOTAL FUND BALANCE 132,335 TOTAL LIABILITIES AND FUND BALANCE 132,335