Loading...
HomeMy WebLinkAbout2022-07 July Combined FinancialsFY 2022 Combined Financials YTD as of 7/31/2022 YTD Revenues • YTD Expenses Amended Revenues • Amended Expenses Adopted Revenues Adopted Expenses Adopted Budget vs YTD Actuals Revenues & Expenses $7,581,063 $8,710,208 $10,909,758 $10,829,758 $10,370,758 $1,944 $89,745 0% $1,140,677 15% $2,424,664 32% 1 1% $3,924,033 52% 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 80,639,404 Water Consumption Budget vs Actual 54,635,000 49,322,000 48,488,000 44,588,000 40,021,000 51 338.613 72,448,000 44,024,449 36,662,055 36,449,799 Budget Consumption 141,177,000 119,711,000 85,474,000 56,888,452 8,104,839 —*-Actual Consumption 114,781,327 - 96,534,832 63,970,589 Oct Nov Dec Jan Feb 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 834,099,338 948,958,978 Total Water Consumption ■ Budgeted Water Consumption ■ Proiected Water Consumption Presented by: Finance Department $1,000,000 $900,000 $800,000 $700,000 $600,000 $500,000 $400,000 0455,836 $300,000 $398,851 $200,000 $100,000 $o $569,186 Water Revenue Budget vs Actual $918,465 y $786,615 $326,817 0466,196 $423,949 Budget Revenue --Actual Revenue 759,395 $651,814 Oct Nov Dec Jan Feb Mar Apr May Jun Jul $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 so Adopted Budget Water Revenue Vs Projected Water Revenue $6,033,776 $6,522,115 $3,525,165 1 Total Water Revenue $3,915,535 ■ 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 2022 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 820,771 PREPAID EXPENSES 3,326 ADVALOREM PROPERTY TAXES RECEIVABLE 19,407 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 843,504 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 13,531 TOTAL LIABILITIES 13,531 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 720,907 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 109,067 TOTAL FUND BALANCE 829,973 TOTAL LIABILITIES AND FUND BALANCE 843,504 TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET JULY 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,140,217 5,140,217 CASH IN BANK -SAVINGS -CASH RESERVE 1,482,052 1,482,052 INVESTMENTS-TEXPOOL 2,882,156 2,985,575 5,867,731 PREPAID EXPENSES 22,801 22,801 ADVALOREM PROPERTY TAXES RECEIVABLE 1,990 1,990 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,555,015 1,555,015 TOTAL ASSETS 11,084,831 2,985,575 14,070,406 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 538 538 ACCOUNTS AND OTHER PAYABLES 476,566 476,566 CUSTOMER DEPOSITS 323,590 323,590 TOTAL LIABILITIES 800,694 800,694 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,129,145 1,129,145 TOTAL FUND BALANCE 10,284,138 2,985,575 13,269,713 TOTAL LIABILITIES AND FUND BALANCE 11,084,831 2,985,575 14,070,406 TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET JULY 2022 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 785,479 TOTAL ASSETS 785,479 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 443 703,788 785,479 TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET JULY 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 REVENUE BOND 1,833,614 TOTAL ASSETS 1,833,614 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 361,210 TOTAL LIABILITIES 361,210 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 4,032,009 (2,559,605) TOTAL FUND BALANCE 1,472,404 TOTAL LIABILITIES AND FUND BALANCE 1,833,614 TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET JULY 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 897,174 TOTAL ASSETS 897,174 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 2,863 897,174 897,174 TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET JULY 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 957,079 10,850 TOTAL ASSETS 967,929 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES ACCOUNTS AND OTHER PAYABLES 57,355 1,311 TOTAL LIABILITIES 58,666 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES (16,307) 925,570 TOTAL FUND BALANCE 909,263 TOTAL LIABILITIES AND FUND BALANCE 967,929 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET JULY 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB 1 / MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 478,830 TOTAL ASSETS 478,830 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 452,769 478,830 478,830 TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET JULY 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 229,682 TOTAL ASSETS 229,682 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 224,026 229,682 229,682 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET JULY 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 236,275 TOTAL ASSETS 236,275 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 565 NET REVENUES / EXPENDITURES 235,710 TOTAL FUND BALANCE 236,275 TOTAL LIABILITIES AND FUND BALANCE 236,275