Loading...
HomeMy WebLinkAbout2022-03 March Combined FinancialsFY 2022 Combined Financials YTD as of 3/31/2022 YTD Revenues • YTD Expenses Adopted Budget vs YTD Actuals Revenues & Expenses $4,410,259 $4,226,976 51,510 0v $54,651 1% 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 78,390,000 60,000,000 40,000,000 20,000,000 0 Water Consumption Budget vs Actual 80,639,404 51,338,613 54,635,000 48,488,000 49,322,000 44,588,000 44,024,449 36,662,055 40,021,000 36,449,799 Budget Consumption—1—Actual Consumption 38,104,839 Oct Nov Dec Jan Feb Mar 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 66G,3G4,1 Total Water Consumption • Budgeted Water Consumption ■ Proiected Water Consumption Presented by: Finance Department 5900,000 5800,000 5700,000 $600,000 5500,000 $400,000 $455,836 $300,000 $200,000 $100,000 50 Water Revenue Budget vs Actual $569,186 $402,228 $370,639 $373,428 $328,461 5398,851 5359,936 $320,532 Budget Revenue —A—Actual Revenue $322,394 3360890 5326,817 Oct Nov Dec Jan Feb Mar $7,000,000 56,000,000 $5,000,000 $4,000,000 53,000,000 $2,000,000 51,000,000 $0 Adopted Budget Water Revenue Vs Projected Water Revenue $6,033,776 $6,027,540 53,525,165 53,550,277 1 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 MARCH 2022 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 1,065,700 PREPAID EXPENSES 9,979 ADVALOREM PROPERTY TAXES RECEIVABLE 75,276 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 1,150,955 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 69,400 TOTAL LIABILITIES 69,400 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 720,907 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 360,648 TOTAL FUND BALANCE 1,081,555 TOTAL LIABILITIES AND FUND BALANCE 1,150,955 TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET MARCH 2022 135 137 4 Tfl PHV CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 3,889,568 3,889,568 CASH IN BANK -SAVINGS -CASH RESERVE 2,003,885 2,003,885 INVESTMENTS-TEXPOOL 3,356,139 2,985,575 6,341,714 PREPAID EXPENSES 60,643 60,643 ADVALOREM PROPERTY TAXES RECEIVABLE 7,978 7,978 UTILITY AND OTHER ACCOUNTS RECEIVABLE 916,725 916,725 TOTAL ASSETS 10,235,539 2,985,575 13,221,114 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 6,526 6,526 ACCOUNTS AND OTHER PAYABLES 573,547 573,547 CUSTOMER DEPOSITS 317,190 317,190 TOTAL LIABILITIES 897,263 897,263 FUND BALANCE NON -SPENDABLE FUND BALANCE 3,880 3,880 ASSIGNED FUND BALANCE 3,097,390 3,097,390 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 6,053,723 6,053,723 COMMITTED FUND BALANCE - - NET REVENUES / EXPENDITURES 183,283 183,283 TOTAL FUND BALANCE 9,338,276 2,985,575 12,323,851 TOTAL LIABILITIES AND FUND BALANCE 10,235,539 2,985,575 13,221,114 TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET MARCH 2022 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 785,059 TOTAL ASSETS 785,059 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 23 703,368 785,059 TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET MARCH 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 REVENUE BOND 2,130,057 TOTAL ASSETS 2,130,057 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 160,128 TOTAL LIABILITIES 160,128 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 4,032,009 (2,062,080) TOTAL FUND BALANCE 1,969,929 TOTAL LIABILITIES AND FUND BALANCE 2,130,057 TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET MARCH 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 894,583 TOTAL ASSETS 894,583 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 894,311 NET REVENUES / EXPENDITURES 272 TOTAL FUND BALANCE 894,583 TOTAL LIABILITIES AND FUND BALANCE 894,583 TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET MARCH 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 882,512 41,263 TOTAL ASSETS 923,775 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES ACCOUNTS AND OTHER PAYABLES 57,355 31,725 TOTAL LIABILITIES 89,080 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES (16,307) 851,003 TOTAL FUND BALANCE 834,695 TOTAL LIABILITIES AND FUND BALANCE 923,775 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET MARCH 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB 1 / MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 258,508 TOTAL ASSETS 258,508 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 26,061 232,447 258,508 258,508 TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET MARCH 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 128,285 TOTAL ASSETS 128,285 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,656 122,629 128,285 128,285 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET MARCH 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 97,825 TOTAL ASSETS 97,825 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 565 NET REVENUES / EXPENDITURES 97,260 TOTAL FUND BALANCE 97,825 TOTAL LIABILITIES AND FUND BALANCE 97,825