The URL can be used to link to this page

Home My WebLink About2021-08 August Combined FinancialsFY 2021 Combined Financials YTD as of 08/31/2021 Adopted Budget vs YTD Actuals Revenues & Expenses YTD Revenues • YTD Expenses - Amended Revenues •Amended Expenses ■ Adopted Revenues Adopted Expenses $7,714,410 $9,357,257 510,227,277 $2,564 $65,485 0% 51,275,872 17% $2,477,426 32% 1% $3,893,062 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 Water Consumption Budget vs Actual 98,232,000 77,776,000 61,402,206 69,156,299 57,380,000 47,602,205 42,932,939 42,725,000 40,786,000 40,841,000 gg 117 386 36,365,918 96,013,079 69,013,25 119,706,571 97,846,000 i100,853,000 58,087,848 -64,195,000 41,078,000 50,736,000 —0—Budget Consumption —0—Actual Consumption Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug 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 797,940,841 Total Water Consumption • Budgeted Water Consumption • Projected Water Consumption Presented by: Finance Department 5900,000 5800,000 5700,000 5600,000 $521,111136 5500,000 `\ 5400,000 $447,160 5412,932 5300,000 5200,000 $100,000 50 Water Revenue Budget vs Actual $348,784 $323,259 $337,820 71,60 5465,093 $691,059 5635,974 5483,450 / 5633,180 5650,853 I $326,348 5327,587 5326,759 $313,020 423,447 $379555 --Budget Revenue —0—Actual Revenue 5446,839 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 51,000,000 $0 Adopted Budget Water Revenue Vs Projected Water Revenue $5,932,489 $5,458,320 $3,336,194 $3,271,816 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 AUGUST 2021 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 771,824 PREPAID EXPENSES 1,649 ADVALOREM PROPERTY TAXES RECEIVABLE 16,949 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 790,422 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 237 TOTAL LIABILITIES 237 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 668,784 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 121,401 TOTAL FUND BALANCE 790,185 TOTAL LIABILITIES AND FUND BALANCE 790,422 TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET AUGUST 2021 135 137 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 3,011,226 3,011,226 CASH IN BANK -SAVINGS -CASH RESERVE 2,000,397 2,000,397 INVESTMENTS-TEXPOOL 4,377,574 2,007,484 6,385,058 PREPAID EXPENSES 12,460 12,460 ADVALOREM PROPERTY TAXES RECEIVABLE 1,736 1,736 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,252,746 1,252,746 TOTAL ASSETS 10,656,739 2,007,484 12,664,223 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES (16) (16) ACCOUNTS AND OTHER PAYABLES 452,791 452,791 CUSTOMER DEPOSITS 312,405 312,405 TOTAL LIABILITIES 765,180 765,180 FUND BALANCE NON -SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 1,518,116 1,518,116 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 7,651,523 7,651,523 COMMITTED FUND BALANCE NET REVENUES / EXPENDITURES 718,434 718,434 TOTAL FUND BALANCE 9,891,559 2,007,484 11,899,043 TOTAL LIABILITIES AND FUND BALANCE 10,656,739 2,007,484 12,664,223 TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST BALANCE SHEET AUGUST 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 AUGUST 2021 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 785,032 TOTAL ASSETS 785,032 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 65 703,341 785,032 TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET AUGUST 2021 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND 145,375 3,892,849 TOTAL ASSETS 4,038,224 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 (113,158) 4,038,224 4,038,224 TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET AUGUST 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 894,291 TOTAL ASSETS 894,291 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 893,868 NET REVENUES / EXPENDITURES 423 TOTAL FUND BALANCE 894,291 TOTAL LIABILITIES AND FUND BALANCE 894,291 TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET AUGUST 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 127,873 9,576 TOTAL ASSETS 137,449 LIABILITIES AND FUND BALANCE LIABILITIES 64,064 DEFERRED REVENUE - AD VALOREM PROPERTY TAXES (27) ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES 64,037 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES (19,950) 93,362 TOTAL FUND BALANCE 73,412 TOTAL LIABILITIES AND FUND BALANCE 137,449 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET AUGUST 2021 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB 1 / MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND ASSETS I&S WWTP 26,060 TOTAL ASSETS 26,060 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 25,988 NET REVENUES / EXPENDITURES 72 TOTAL FUND BALANCE 26,060 TOTAL LIABILITIES AND FUND BALANCE 26,060 TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET AUGUST 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 5,656 TOTAL ASSETS 5,656 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 5,625 NET REVENUES / EXPENDITURES 31 TOTAL FUND BALANCE 5,656 TOTAL LIABILITIES AND FUND BALANCE 5,656 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET AUGUST 2021 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TOTAL ASSETS TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND ASSETS SERIES 2019 I&S LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES 565 565 FUND BALANCE ASSIGNED FUND BALANCE 531 NET REVENUES / EXPENDITURES 34 TOTAL FUND BALANCE 565 TOTAL LIABILITIES AND FUND BALANCE 565