The URL can be used to link to this page

Home My WebLink About2021-07 Combined Financials July 2021FY 2021 Combined Financials YTD as of 07/31/2021 Adopted Budget vs YTD Actuals Revenues & Expenses • YTD Revenues • YTD Expenses . Amended Revenues 11.1 • Amended Expenses r Adopted Revenues Adopted Expenses $6,978,681 59,357,258 52,360 0% 51,151,174 17% $60,885 1% YTD Expense By Departments 53,506,871 50% YTD Expense- Water 52,257,391 YTD Expense- WW 32% YTD Expense- Admin • YTD Expense- BOD • YTD Expense- Non Dept Water Budget vs Actual 140,000,000 120,000,000 115,781,000 100,000,000 80,000,000 60,000,000 61402,206 40,000,000 69,156,299 20,000,000 Water Consumption Budget vs Actual 61,136,000 46,305,000 43,092,000 38,117,386 0 42,932,939 47,602,205 105,962,511 96,013,079 - 73,522,000 69,013,25 36,365,918 40,786,000 --Budget Consumption Oct Nov Dec Jan Feb 58,087,848 50,738,000 41,078,000 —0—Actual Consumption 100,853.000 69,501,000 Mar Apr May Jun Jul 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 857,991,412 Total Water Consumption • Budgeted Water Consumption • Projected Water Consumption Presented by: Finance Department Water Revenue Budget vs Actual 5800,000 5700,000 5600,000 5521,136 5447,160 5500,000 II1}i��\ 5400,000 5490,359 $412,,9932 5300,000 5200,000 5100,000 50 5348,784 5371,601 5323,259 Sa_aj1■ J \ 5326,348 5313,020 $326,759 $635,974 5483,450 $465,093 \ $327,58] 5423,447 —0—Budget Revenue —0—Actual Revenue 379,555 5691,059 - 5650,853 $446,839 Oct Nov Dec Jan Feb Mar Apr May Jun Jul $7,000,000 $6,000,000 55,000,000 $4,000,000 $3,000,000 $2,000,000 51,000,000 50 Adopted Budget Water Revenue Vs Projected Water Revenue 55,932,489 55,599,274 $3,336,194 53,370,365 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 JULY 2021 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 835,426 PREPAID EXPENSES 3,298 ADVALOREM PROPERTY TAXES RECEIVABLE 21,188 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 859,912 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 4,476 TOTAL LIABILITIES 4,476 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 668,784 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 186,652 TOTAL FUND BALANCE 855,436 TOTAL LIABILITIES AND FUND BALANCE 859,912 TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET JULY 2021 135 137 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 2,590,505 2,590,505 CASH IN BANK -SAVINGS -CASH RESERVE 1,999,887 1,999,887 INVESTMENTS-TEXPOOL 4,501,328 2,007,484 6,508,812 PREPAID EXPENSES 21,433 21,433 ADVALOREM PROPERTY TAXES RECEIVABLE 2,200 2,200 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,248,179 1,248,179 TOTAL ASSETS 10,364,133 2,007,484 12,371,617 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 448 448 ACCOUNTS AND OTHER PAYABLES 416,607 416,607 CUSTOMER DEPOSITS 312,280 312,280 TOTAL LIABILITIES 729,334 729,334 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 461,674 461,674 TOTAL FUND BALANCE 9,634,799 2,007,484 11,642,283 TOTAL LIABILITIES AND FUND BALANCE 10,364,133 2,007,484 12,371,617 TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST BALANCE SHEET JULY 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 JULY 2021 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 785,029 TOTAL ASSETS 785,029 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 62 703,338 785,029 TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET JULY 2021 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND 157,470 3,892,831 TOTAL ASSETS 4,050,301 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,383 (101,082) 4,050,301 4,050,301 TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET JULY 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 894,274 TOTAL ASSETS 894,274 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 893,867 NET REVENUES / EXPENDITURES 406 TOTAL FUND BALANCE 894,274 TOTAL LIABILITIES AND FUND BALANCE 894,274 TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET JULY 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 923,901 11,925 TOTAL ASSETS 935,827 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES ACCOUNTS AND OTHER PAYABLES 64,064 2,322 TOTAL LIABILITIES 66,386 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES (19,950) 889,391 TOTAL FUND BALANCE 869,441 TOTAL LIABILITIES AND FUND BALANCE 935,827 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET JULY 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB 1 / MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 471,850 TOTAL ASSETS 471,850 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 445,862 471,850 471,850 TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET JULY 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 225,243 TOTAL ASSETS 225,243 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 219,618 225,243 225,243 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET JULY 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 233,102 TOTAL ASSETS 233,102 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 531 NET REVENUES / EXPENDITURES 232,571 TOTAL FUND BALANCE 233,102 TOTAL LIABILITIES AND FUND BALANCE 233,102