The URL can be used to link to this page

Home My WebLink About2021-04 April 2021 Combined FinancialsFY 2021 Combined Financials YTD as of 04/30/2021 Adopted Budget vs YTD Actuals Revenues & Expenses YTD Revenues YTD Expenses • Adopted Revenues Adopted Expenses J $1,607 011 $46,487 1% YTD Expense By Departments 52,399,940 48% 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 115,781,000 61,136,000 46,305,000 47,602,205 43,092,000 38,117,386 69,156,299 61,402,206 42,932,939 - 36,365,918 40,786,000 —0—Budget Consumption —0—Actual Consumption Oct Nov Dec Jan Fab Mar 58,087,848 41,078,000 Apr 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,8 3,055 907,888,253 Total Water Consumption • Budgeted Water Consumption • Projected Water Consumption Presented by: Finance Department $600,000 5521,136 $500,000 $400,000 $300,000 5200,000 $100,000 $0 Water Revenue Budget vs Actual 5447,160 5465,093 5490,389 5348,784 $337,820 5412,932 5326,759 5313,020 5323,259 5326,348 5371,601 —0—Budget Revenue —0—Actual Revenue 5327,587 Oct Nov Dec Jan Feb Mar 5423,447 Apr $7,000,000 $6,000,000 85,000,000 $4,000,000 53,000,000 52,000,000 $1,000,000 50 Adopted Budget Water Revenue Vs Projected Water Revenue 55,932,489 55,932,508 53,336,194 53,500,711 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 2021 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 FIRE DEPT. 57,369 945,810 8,245 51,687 TOTAL ASSETS 1,063,111 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 34,975 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 34,975 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON -SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 668,784 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES 359,352 TOTAL FUND BALANCE 1,028,136 TOTAL LIABILITIES AND FUND BALANCE 1,063,111 TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET APRIL 2021 SI TROPHY CL 4 MUNICIPAL UTILITY DISTRICT 135 137 GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 3,254,251 3,254,251 CASH IN BANK -SAVINGS -CASH RESERVE 1,998,376 1,998,376 INVESTMENTS-TEXPOOL 3,870,242 2,007,484 5,877,726 PREPAID EXPENSES 48,354 48,354 ADVALOREM PROPERTY TAXES RECEIVABLE 5,540 5,540 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,036,097 1,036,097 TOTAL ASSETS 10,213,459 2,007,484 12,220,943 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 3,788 3,788 ACCOUNTS AND OTHER PAYABLES 734,849 734,849 CUSTOMER DEPOSITS 313,495 313,495 TOTAL LIABILITIES 1,052,131 1,052,131 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 (11,797) (11,797) TOTAL FUND BALANCE 9,161,328 2,007,484 11,168,812 TOTAL LIABILITIES AND FUND BALANCE 10,213,459 2,007,484 12,220,943 TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST BALANCE SHEET APRIL 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 4 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 APRIL 2021 CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND ASSETS CONSTRUCTION 785,013 TOTAL ASSETS 785,013 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 46 703,322 785,013 TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET APRIL 2021 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 175,836 INVESTMENTS 3,892,754 ACCOUNTS RECEIVABLE TOTAL ASSETS 4,068,590 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 (82,792) 4,068,590 4,068,590 TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET APRIL 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 528 REVENUE BOND RESERVE 894,242 TOTAL ASSETS 894,242 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 893,867 NET REVENUES / EXPENDITURES 375 TOTAL FUND BALANCE 894,242 TOTAL LIABILITIES AND FUND BALANCE 894,242 TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET APRIL 2021 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE ACCOUNTS RECEIVABLE -OTHER a TROPHY CLUB 533 INTEREST & SINKING DEBT 872,098 28,829 TOTAL ASSETS 900,927 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES ACCOUNTS AND OTHER PAYABLES 64,064 19,226 TOTAL LIABILITIES 83,290 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES (19,950) 837,587 TOTAL FUND BALANCE 817,637 TOTAL LIABILITIES AND FUND BALANCE 900,927 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET APRIL 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 534 REVENUE BOND I&S WWTP 307,972 TOTAL ASSETS 307,972 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 281,984 307,972 307,972 TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET APRIL 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 150,510 TOTAL ASSETS 150,510 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 144,885 150,510 150,510 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET APRIL 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 129,735 TOTAL ASSETS 129,735 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 531 NET REVENUES / EXPENDITURES 129,204 TOTAL FUND BALANCE 129,735 TOTAL LIABILITIES AND FUND BALANCE 129,735