The URL can be used to link to this page

Home My WebLink About2021-06 June Combined FinancialsFY 2021 Combined Financials YTD as of 06/30/2021 Adopted Budget vs YTD Actuals Revenues & Expenses ■ YTD Revenues NMI • YTD Expenses 1 Adopted Revenues Adopted Expenses $6,434,623 $6,282,982 • ma= $2,359 $56,770 0% 1 1% $1,041,470 16% $2,067,184 • 33% YTD Expense 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 O Water Consumption Budget vs Actual 15,781,000 96,013,079 61,136,000 46,305,000 47,602,205 73,522,000 69,013,251 43,092,000 / 69,501,000 38,117,386 / 58,087,848 61,402,206 69,156,299 42,932,939 l 36,365,918 40,786,000 41,078,000 —0—Budget Consumption —0—Actual Consumption 50,738,000 Oct Nov Dec Jan Feb Mar Apr May Jun 1,200,000,000 1,100,000,000 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 839,853,055 863,100,923 Total Water Consumption • Budgeted Water Consumption • Projected Water Consumption Presented by: Finance Department Water Revenue Budget vs Actual 5337,820 5323,259 $0 —0—Budget Revenue —0—Actual Revenue Oct Nov Dec Jan Feb Mar Apr May Jun $7,000,000 $6,000,000 $5,000,000 34,000,000 $3,000,000 $2,000,000 31,000,000 30 Adopted Budget Water Revenue Vs Projected Water Revenue 55,932,489 55,639,480 $3,336,194 $3,322,639 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 JUNE 2021 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 892,894 PREPAID EXPENSES 4,947 ADVALOREM PROPERTY TAXES RECEIVABLE 37,801 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 935,642 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 21,088 TOTAL LIABILITIES 21,088 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 668,784 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 245,769 TOTAL FUND BALANCE 914,554 TOTAL LIABILITIES AND FUND BALANCE 935,642 TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET JUNE 2021 135 137 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 3,696,234 3,696,234 CASH IN BANK -SAVINGS -CASH RESERVE 1,999,378 1,999,378 INVESTMENTS-TEXPOOL 3,624,443 2,007,484 5,631,926 PREPAID EXPENSES 30,407 30,407 ADVALOREM PROPERTY TAXES RECEIVABLE 4,019 4,019 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,010,273 1,010,273 TOTAL ASSETS 10,365,354 2,007,484 12,372,838 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,267 2,267 ACCOUNTS AND OTHER PAYABLES 726,186 726,186 CUSTOMER DEPOSITS 312,135 312,135 TOTAL LIABILITIES 1,040,587 1,040,587 FUND BALANCE NON -SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 2,404,829 2,404,829 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 315,000 315,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 460,899 460,899 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 558,704 558,704 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 472,881 472,881 ASSIGNED FUND BALANCE/WWTP MBR REPLACEMENT 200,000 200,000 UNASSIGNED FUND BALANCE 6,764,810 6,764,810 COMMITTED FUND BALANCE NET REVENUES / EXPENDITURES 151,642 151,642 TOTAL FUND BALANCE 9,324,767 2,007,484 11,332,251 TOTAL LIABILITIES AND FUND BALANCE 10,365,354 2,007,484 12,372,838 TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST BALANCE SHEET JUNE 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 (199,119) 199,119 TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET JUNE 2021 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 785,025 TOTAL ASSETS 785,025 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,276 58 703,334 785,025 TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET JUNE 2021 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND 161,919 3,892,813 TOTAL ASSETS 4,054,732 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 4,151,382 (96,650) 4,054,732 4,054,732 TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET JUNE 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 894,260 TOTAL ASSETS 894,260 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 893,868 NET REVENUES / EXPENDITURES 392 TOTAL FUND BALANCE 894,260 TOTAL LIABILITIES AND FUND BALANCE 894,260 TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET JUNE 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 907,582 21,133 TOTAL ASSETS 928,715 LIABILITIES AND FUND BALANCE LIABILITIES 64,064 DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 11,530 ACCOUNTS AND OTHER PAYABLES 139 TOTAL LIABILITIES 75,733 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES (19,950) 872,932 TOTAL FUND BALANCE 852,982 TOTAL LIABILITIES AND FUND BALANCE 928,715 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET JUNE 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB 1 / MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 417,222 TOTAL ASSETS 417,222 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 25,988 391,234 417,222 417,222 TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET JUNE 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 200,331 TOTAL ASSETS 200,331 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,625 194,706 200,331 200,331 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET JUNE 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 198,645 TOTAL ASSETS 198,645 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 531 NET REVENUES / EXPENDITURES 198,114 TOTAL FUND BALANCE 198,645 TOTAL LIABILITIES AND FUND BALANCE 198,645