Loading...
HomeMy WebLinkAbout2022-08 August Combined FinancialsFY 2022 Combined Financials YTD as of 8/31/2022 YTD Revenues • YTD Expenses Amended Revenues • Amended Expenses Adopted Revenues Adopted Expenses Adopted Budget vs YTD Actuals Revenues & Expenses $8,657,304 $10,909,758 $10,829,758 $10,370,758 $2,635 $92,265 0% - 1% $1,270,227 15% YTD Expenses By Departments YTD Expense- Water $4,650,620 $2,641,556 54% YTD Expense- WW 30% 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 80,639,404 78,390,000 60,000,000 Water Consumption Budget vs Actual 72,448,000 54,635,000 49,322,000 44,588,000 48,488,000 143,845,000 141,1]],000 119,711,000 ✓/ 24,313,693 85,474,000 40,021,000 40,000,000 51 338613 56,888,452 f 44,024,449 r 38,104,839 O 4,839 36,662,055 36,449,799 20,000,000 Budget Consumption 63,970,589 -*-Actual Consumption 114,781,327 96,534,832 0 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug 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 834,099,338 968,490,285 Total Water Consumption • Budgeted Water Consumption • Proierted Water Consumption Presented by: Finance Department $1,000,000 $900,000 $800,000 $700,000 $600,000 $500,000 $400,000 / $455,836 $359,936 $398,851 J Water Revenue Budget vs Actual $569,186 5402,228 8373,428 r. 9370,639 $300,000 $200,000 $100,000 $o $918,465 7 $939,810 $786,6151 Y �� $817,889 8580,431 $510,419 360,890 8328,46 4320,532 $322,394 9326,817 8466,196 $423,949 Budget Revenue --Actual Revenue $651,814 $759,395 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 $1,000,000 $0 Adopted Budget Water Revenue Vs Projected Water Revenue $6,033,776 $6,644,036 $3,525,165 1 Total Water Revenue $3,990,390 • 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 2022 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 748,840 PREPAID EXPENSES 1,663 ADVALOREM PROPERTY TAXES RECEIVABLE 16,698 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 767,202 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 10,822 TOTAL LIABILITIES 10,822 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 720,907 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 35,473 TOTAL FUND BALANCE 756,380 TOTAL LIABILITIES AND FUND BALANCE 767,202 TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET AUGUST 2022 135 137 4 Tfl PHV CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 5,785,149 5,785,149 CASH IN BANK -SAVINGS -CASH RESERVE 1,482,870 1,482,870 INVESTMENTS-TEXPOOL 2,769,641 2,985,575 5,755,216 PREPAID EXPENSES 13,341 13,341 ADVALOREM PROPERTY TAXES RECEIVABLE 1,699 1,699 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,551,277 1,551,277 TOTAL ASSETS 11,604,578 2,985,575 14,590,153 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 247 247 ACCOUNTS AND OTHER PAYABLES 748,848 748,848 CUSTOMER DEPOSITS 326,470 326,470 TOTAL LIABILITIES 1,075,565 1,075,565 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,374,020 1,374,020 TOTAL FUND BALANCE 10,529,013 2,985,575 13,514,588 TOTAL LIABILITIES AND FUND BALANCE 11,604,578 2,985,575 14,590,153 TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET AUGUST 2022 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 786,153 TOTAL ASSETS 786,153 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 1,117 704,462 786,153 TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET AUGUST 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 REVENUE BOND 1,550,139 TOTAL ASSETS 1,550,139 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 158,280 TOTAL LIABILITIES 158,280 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 4,032,009 (2,640,150) TOTAL FUND BALANCE 1,391,859 TOTAL LIABILITIES AND FUND BALANCE 1,550,139 TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET AUGUST 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 898,822 TOTAL ASSETS 898,822 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 4,511 898,822 898,822 TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET AUGUST 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 50,786 9,378 TOTAL ASSETS 60,164 LIABILITIES AND FUND BALANCE LIABILITIES 57,355 DEFERRED REVENUE - AD VALOREM PROPERTY TAXES (161) ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES 57,194 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES (16,307) 19,277 TOTAL FUND BALANCE 2,970 TOTAL LIABILITIES AND FUND BALANCE 60,164 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET AUGUST 2022 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB 1 / MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND ASSETS I&S WWTP 27,903 TOTAL ASSETS 27,903 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,842 27,903 TOTAL LIABILITIES AND FUND BALANCE 27,903 TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET AUGUST 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 6,542 TOTAL ASSETS 6,542 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 5,656 NET REVENUES / EXPENDITURES 886 TOTAL FUND BALANCE 6,542 TOTAL LIABILITIES AND FUND BALANCE 6,542 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET AUGUST 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 1,426 TOTAL ASSETS 1,426 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 565 NET REVENUES / EXPENDITURES 861 TOTAL FUND BALANCE 1,426 TOTAL LIABILITIES AND FUND BALANCE 1,426