Loading...
HomeMy WebLinkAbout2022-05 May Combined FinancialsFY 2022 Combined Financials YTD as of 5/31/2022 YTD Revenues • YTD Expenses Amended Revenues • Amended Expenses Adopted Revenues Adopted Expenses 111. Adopted Budget vs YTD Actuals Revenues & Expenses $6,189,571 $5,747,694 $10,909,758 $10,829,758 $10,370,758 $1,662 $58,033 0% 1 1% $884,924 15% $1,931,359 34% YTD Expenses By Departments YTD Expense- Water 52,871,715 50% 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 80,639,404 78,390,000 Water Consumption Budget vs Actual 54,635,000 48,488,000 49,322,000 85,474,000 72,448,000 44,588,000 51,338,613 44,024,449 36,662,055 36,449,799 38,104,839 40,021,000 Budget Consumption —A—Actual Consumption 63,970,589 56,888,452 Oct Nov Dec Jan Feb Mar Apr May 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 899,387,137 Total Water Consumption • Budgeted Water Consumption • Projected Water Consumption Presented by: Finance Department 5900,000 5800,000 5700,000 5600,000 5000,000 $400,000 Water Revenue Budget vs Actual $569,186 $510,419 $580431 • 5402,228 $370,639 $455,836 --� $328,461 5300,000 $398,851 $359,936 373,428 5200,000 $100,000 50 5360,890 $320,532 $322,394 5326,817 Budget Revenue —e—Actual Revenue $466,196 $423,949 Oct Nov Dec Jan Feb Mar Apr May $7,000,000 56,000,000 $5,000,000 54,000,000 53,000,000 $2,000,000 $1,000,000 $0 Adopted Budget Water Revenue Vs Projected Water Revenue $6,033,776 $6,228,245 $3,525,165 Total Water Revenue $3,716,907 • 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 MAY 2022 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 961,271 PREPAID EXPENSES 6,653 ADVALOREM PROPERTY TAXES RECEIVABLE 28,825 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 996,749 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 22,949 TOTAL LIABILITIES 22,949 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 720,907 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 252,894 TOTAL FUND BALANCE 973,800 TOTAL LIABILITIES AND FUND BALANCE 996,749 TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET MAY 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,854,587 4,854,587 CASH IN BANK -SAVINGS -CASH RESERVE 1,480,743 1,480,743 INVESTMENTS-TEXPOOL 3,116,572 2,985,575 6,102,147 PREPAID EXPENSES 41,722 41,722 ADVALOREM PROPERTY TAXES RECEIVABLE 2,999 2,999 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,154,186 1,154,186 TOTAL ASSETS 10,651,410 2,985,575 13,636,985 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 1,547 1,547 ACCOUNTS AND OTHER PAYABLES 731,127 731,127 CUSTOMER DEPOSITS 321,865 321,865 TOTAL LIABILITIES 1,054,538 1,054,538 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 441,879 441,879 TOTAL FUND BALANCE 9,596,872 2,985,575 12,582,446 TOTAL LIABILITIES AND FUND BALANCE 10,651,410 2,985,575 13,636,985 TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET MAY 2022 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 785,066 TOTAL ASSETS 785,066 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 30 703,375 785,066 TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET MAY 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 REVENUE BOND 2,008,783 TOTAL ASSETS 2,008,783 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 160,504 TOTAL LIABILITIES 160,504 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 4,032,009 (2,183,730) TOTAL FUND BALANCE 1,848,279 TOTAL LIABILITIES AND FUND BALANCE 2,008,783 TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET MAY 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 895,280 TOTAL ASSETS 895,280 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 894,311 NET REVENUES / EXPENDITURES 969 TOTAL FUND BALANCE 895,280 TOTAL LIABILITIES AND FUND BALANCE 895,280 TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET MAY 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 928,916 15,979 TOTAL ASSETS 944,895 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES ACCOUNTS AND OTHER PAYABLES 57,355 6,441 TOTAL LIABILITIES 63,796 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES (16,307) 897,408 TOTAL FUND BALANCE 881,099 TOTAL LIABILITIES AND FUND BALANCE 944,895 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET MAY 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB 1 / MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 368,354 TOTAL ASSETS 368,354 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 342,294 368,354 368,354 TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET MAY 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 178,832 TOTAL ASSETS 178,832 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 173,176 178,832 178,832 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET MAY 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 166,895 TOTAL ASSETS 166,895 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 565 NET REVENUES / EXPENDITURES 166,330 TOTAL FUND BALANCE 166,895 TOTAL LIABILITIES AND FUND BALANCE 166,895