The URL can be used to link to this page

Home My WebLink About2022-01 January Combined FinancialsFY 2022 Combined Financials YTD as of 1/31/2022 • YTD Revenues Expenses Adopted Budget vs YTD Actuals Revenues & Expenses 53,028,959 $2,882,819 $1,163 $43,285 o% 2% $454,912 $1,396,700 $986,759 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 54,635,000 51,338,613 48,488,000 49,322,000 r 1i 44,024,449 Budget Consumption --Actual Consumption 36,662,055 Oct Nov Dec Jan 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 852,269,816 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 $455,836 $300,000 $200,000 $100,000 50 Water Revenue Budget vs Actual $569,186 $402,228 $370,639 $398,851 $359,936 Budget Revenue --Actual Revenue 3373,428 $320,532 Oct Nov Dec Jan $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 so Adopted Budget Water Revenue Vs Projected Water Revenue $6,033,776 $5,987,400 $3,525,165 $3,499,971 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 JANUARY 2022 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 1,232,593 PREPAID EXPENSES 13,305 ADVALOREM PROPERTY TAXES RECEIVABLE 229,210 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 1,475,107 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 220,980 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 220,980 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 723,260 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 530,867 TOTAL FUND BALANCE 1,254,127 TOTAL LIABILITIES AND FUND BALANCE 1,475,107 TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET JANUARY 2022 135 137 4 Tfl PHV CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 3,823,724 3,823,724 CASH IN BANK -SAVINGS -CASH RESERVE 2,002,914 2,002,914 INVESTMENTS-TEXPOOL 3,253,866 2,985,575 6,239,440 PREPAID EXPENSES 79,564 79,564 ADVALOREM PROPERTY TAXES RECEIVABLE 24,471 24,471 UTILITY AND OTHER ACCOUNTS RECEIVABLE 940,239 940,239 TOTAL ASSETS 10,125,377 2,985,575 13,110,952 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 22,719 22,719 ACCOUNTS AND OTHER PAYABLES 488,756 488,756 CUSTOMER DEPOSITS 312,470 312,470 TOTAL LIABILITIES 823,945 823,945 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 146,140 146,140 TOTAL FUND BALANCE 9,301,432 2,985,575 12,287,007 TOTAL LIABILITIES AND FUND BALANCE 10,125,377 2,985,575 13,110,952 TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET JANUARY 2022 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 785,052 TOTAL ASSETS 785,052 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 16 703,361 785,052 TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET JANUARY 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 REVENUE BOND 2,635,857 TOTAL ASSETS 2,635,857 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 412,372 TOTAL LIABILITIES 412,372 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 4,032,009 (1,808,524) TOTAL FUND BALANCE 2,223,485 TOTAL LIABILITIES AND FUND BALANCE 2,635,857 TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET JANUARY 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 894,423 TOTAL ASSETS 894,423 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 112 894,423 894,423 TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET JANUARY 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 648,590 125,025 TOTAL ASSETS 773,615 LIABILITIES AND FUND BALANCE LIABILITIES 57,355 DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 114,019 ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES 171,375 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES (14,841) 617,081 TOTAL FUND BALANCE 602,240 TOTAL LIABILITIES AND FUND BALANCE 773,615 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET JANUARY 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB 1 / MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 245,288 TOTAL ASSETS 245,288 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 219,228 245,288 245,288 TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET JANUARY 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 106,522 TOTAL ASSETS 106,522 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 100,866 106,522 106,522 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET JANUARY 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 138,513 TOTAL ASSETS 138,513 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 565 NET REVENUES / EXPENDITURES 137,948 TOTAL FUND BALANCE 138,513 TOTAL LIABILITIES AND FUND BALANCE 138,513