Loading...
HomeMy WebLinkAbout2022-10 October Combined FinancialsAdopted Budget vs YTD Actuals Revenues & Expenses $980,888 $853,655 $11,733,354 $11,733,354 FY 2023 Combined Financials YTD as of 10/31/2022 YTD Revenues • YTD Expenses $116 $4,500 0% — 1% $213,570 25% $353,080 41% 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 - 101,683,000 88,979,203 Budget Consumption—1—Actual Consumption Oct 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 808,128,121 820,831,917 Total Water Consumption ■ Budgeted Water Consumption ■ Projected Water Consumption Presented by: Finance Department $1,000,000 $900,000 $800,000 $700,000 $600,000 $500,000 $400,000 $300,000 5200,000 $100,000 $0 Water Revenue Budget vs Actual $703,717 $664,453 Budget Revenue --Actual Revenue Oct $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,710,979 $6,671,714 $4,070,848 $4,031,583 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 OCTOBER 2022 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 495,455 PREPAID EXPENSES 20,738 ADVALOREM PROPERTY TAXES RECEIVABLE 1,219,334 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 1,735,527 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 1,213,458 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 1,213,458 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT - NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 681,804 RESERVE FOR ENCUMBRANCES - NET REVENUES / EXPENDITURES (159,734) TOTAL FUND BALANCE 522,069 TOTAL LIABILITIES AND FUND BALANCE 1,735,527 TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET OCTOBER 2022 135 137 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 4,613,604 4,613,604 CASH IN BANK -SAVINGS -CASH RESERVE 1,885,069 1,885,069 INVESTMENTS-TEXPOOL 3,321,346 3,422,147 6,743,492 PREPAID EXPENSES 116,112 116,112 ADVALOREM PROPERTY TAXES RECEIVABLE 130,737 130,737 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,333,655 1,333,655 TOTAL ASSETS 11,401,123 3,422,147 14,823,270 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 129,284 129,284 ACCOUNTS AND OTHER PAYABLES 369,567 369,567 CUSTOMER DEPOSITS 327,500 327,500 TOTAL LIABILITIES 826,351 826,351 FUND BALANCE NON -SPENDABLE FUND BALANCE 3,880 3,880 ASSIGNED FUND BALANCE 4,770,878 4,770,878 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 405,000 405,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 26,736 26,736 ASSIGNED FUND BALANCE/WATER REPLACEMENT 1,231,524 1,231,524 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 1,287,467 1,287,467 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 81,420 81,420 ASSIGNED FUND BALANCE/WWTP MBR REPLACEMENT 390,000 390,000 UNASSIGNED FUND BALANCE 5,672,780 5,672,780 COMMITTED FUND BALANCE NET REVENUES / EXPENDITURES 127,234 127,234 TOTAL FUND BALANCE 10,574,772 3,422,147 13,996,919 TOTAL LIABILITIES AND FUND BALANCE 11,401,123 3,422,147 14,823,270 TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET OCTOBER 2022 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 788,434 TOTAL ASSETS 788,434 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 705,530 1,213 706,743 788,434 TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET OCTOBER 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 REVENUE BOND 1,367,677 TOTAL ASSETS 1,367,677 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 158,280 TOTAL LIABILITIES 158,280 FUND BALANCE ASSIGNED FUND BALANCE 1,339,097 NET REVENUES / EXPENDITURES (129,700) TOTAL FUND BALANCE 1,209,397 TOTAL LIABILITIES AND FUND BALANCE 1,367,677 TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET OCTOBER 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 902,848 TOTAL ASSETS 902,848 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 900,604 2,244 902,848 902,848 TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET OCTOBER 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 64,441 663,715 TOTAL ASSETS 728,156 LIABILITIES AND FUND BALANCE LIABILITIES 62,967 DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 654,176 ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES 717,143 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES (1,467) 12,480 TOTAL FUND BALANCE 11,013 TOTAL LIABILITIES AND FUND BALANCE 728,156 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET OCTOBER 2022 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB 1 / MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND ASSETS I&S WWTP 83,000 TOTAL ASSETS 83,000 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 27,959 55,041 83,000 TOTAL LIABILITIES AND FUND BALANCE 83,000 TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET OCTOBER 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 31,622 TOTAL ASSETS 31,622 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 6,555 25,067 31,622 TOTAL LIABILITIES AND FUND BALANCE 31,622 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET OCTOBER 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 35,939 TOTAL ASSETS 35,939 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 1,429 34,510 35,939 TOTAL LIABILITIES AND FUND BALANCE 35,939