The URL can be used to link to this page

Home My WebLink About2022-09 September Combined FinancialsFY 2022 Combined Financials YTD as of 9/30/2022 YTD Revenues • YTD Expenses Amended Revenues • Amended Expenses Adopted Revenues Adopted Expenses Adopted Budget vs YTD Actuals Revenues & Expenses $9,591,888 $10,909,758 $10,829,758 $10,370,758 $2,751 $96,251 0% -. 1% $1,413,914 15% YTD Expenses By Departments YTD Expense- Water 52,853,970 55,225,002 54% 30% 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 Water Consumption Budget vs Actual 80,639,404 78,390,000 60,000,000 72,448,000 54,635,000 49,322,000 44,588,000 48,488,000 40,021,000 40,000,000 51 338 613 / 56,888,452 44,024,449 B 04,839 36,662,055 36,449,799 20,000,000 119,711,0001 85,474,000 Budget Consumption 143,845,000 08,377,000 41,177,000 I 124313,693 114,781,327 90,391,285 96,534,832 63,970,589 -*-Actual Consumption 0 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Adopted Budget Water Consumption Vs Actual Water Consumption 1,000,000,000 986,476,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 834,099,338 Total Water Consumption • Budgeted Water Consumption ■ Proiected Water Consumption Presented by: Finance Department $1,000,000 $900,000 $800,000 $700,000 $600,000 5500,000 $400,000 $455,836 / $300,000 ;359,936 Water Revenue Budget vs Actual $569,186 9402,228 $373,428 $370,639 $398,851 J $320,532$322,394 $326,817 $200,000 $328,46 5510,419 $360,890 $918,465 $786,615 / $580,431 $100,000 $0 $423,949 $466,196 Budget Revenue --Actual Revenue $817,889 $759,395 $651,814 5939,810 $719,195 $616,814 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep $8,000,000 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 $o Adopted Budget Water Revenue Vs Projected Water Revenue $6,033,776 $3,525,165 Total Water Revenue $4,008,962 • 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 SEPTEMBER 2022 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. 675,927 12,891 TOTAL ASSETS 688,819 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 7,015 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 7,015 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON -SPENDABLE FUND BALANCE - UNASSIGNED FUND BALANCE 720,907 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES (39,103) TOTAL FUND BALANCE 681,804 TOTAL LIABILITIES AND FUND BALANCE 688,819 TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET SEPTEMBER 2022 135 137 4 Tfl PHV CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 4,516,399 4,516,399 CASH IN BANK -SAVINGS -CASH RESERVE 1,882,637 1,882,637 INVESTMENTS-TEXPOOL 3,782,898 2,985,575 6,768,472 PREPAID EXPENSES 3,880 3,880 ADVALOREM PROPERTY TAXES RECEIVABLE 1,288 1,288 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,291,615 1,291,615 TOTAL ASSETS 11,479,318 2,985,575 14,464,893 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES (164) (164) ACCOUNTS AND OTHER PAYABLES 308,061 308,061 CUSTOMER DEPOSITS 328,600 328,600 TOTAL LIABILITIES 636,497 636,497 FUND BALANCE NON -SPENDABLE FUND BALANCE 3,880 3,880 ASSIGNED FUND BALANCE 3,370,500 3,370,500 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 5,780,613 5,780,613 COMMITTED FUND BALANCE - - NET REVENUES / EXPENDITURES 1,687,828 1,687,828 TOTAL FUND BALANCE 10,842,821 2,985,575 13,828,396 TOTAL LIABILITIES AND FUND BALANCE 11,479,318 2,985,575 14,464,893 TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET SEPTEMBER 2022 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 787,221 TOTAL ASSETS 787,221 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 2,185 705,530 787,221 TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET SEPTEMBER 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 REVENUE BOND 1,497,693 TOTAL ASSETS 1,497,693 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 158,596 TOTAL LIABILITIES 158,596 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 4,032,009 (2,692,912) TOTAL FUND BALANCE 1,339,097 TOTAL LIABILITIES AND FUND BALANCE 1,497,693 TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET SEPTEMBER 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 900,604 TOTAL ASSETS 900,604 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 6,293 900,604 900,604 TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET SEPTEMBER 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 51,961 7,294 TOTAL ASSETS 59,255 LIABILITIES AND FUND BALANCE LIABILITIES 57,355 DEFERRED REVENUE - AD VALOREM PROPERTY TAXES (2,244) ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES 55,111 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES (16,307) 20,453 TOTAL FUND BALANCE 4,144 TOTAL LIABILITIES AND FUND BALANCE 59,255 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET SEPTEMBER 2022 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB 1 / MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND ASSETS I&S WWTP 27,958 TOTAL ASSETS 27,958 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 26,061 1,898 27,958 TOTAL LIABILITIES AND FUND BALANCE 27,958 TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET SEPTEMBER 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 6,555 TOTAL ASSETS 6,555 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 5,656 NET REVENUES / EXPENDITURES 899 TOTAL FUND BALANCE 6,555 TOTAL LIABILITIES AND FUND BALANCE 6,555 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET SEPTEMBER 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 1,429 TOTAL ASSETS 1,429 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 565 NET REVENUES / EXPENDITURES 864 TOTAL FUND BALANCE 1,429 TOTAL LIABILITIES AND FUND BALANCE 1,429