Loading...
HomeMy WebLinkAbout2022-02 February Combined FinancialsFY 2022 Combined Financials YTD as of 2/28/2022 YTD Revenues • YTD Expenses Adopted Budget vs YTD Actuals Revenues & Expenses 53,715,943 $3,354,957 $1,394 $44,293 0% 1% $548,357 17% $1,110,148 33% $1,650,765 49% 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 80,639,404 78,390,000 Oct 54,635,000 48,488,000 49,322,000 51,338,613 44,024,449 36,662,055 Budget Consumption --Actual Consumption Nov Dec Jan Feb 40,021,000 36,449,799 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 855,841,017 Total Water Consumption ■ Budgeted Water Consumption ■ Projected Water Consumption Presented by: Finance Department 5900,000 5800,000 5700,000 5600,000 5500,000 $400,000 $455,836 5300,000 $200,000 $100,000 50 Oct $569,186 Water Revenue Budget vs Actual $402,228 $370,639 $373,428 5398,851 $359,936 $320,532 Budget Revenue --Actual Revenue Nov Dec Jan 3328,461 $322,394 Feb $7,000,000 56,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 51,000,000 50 Adopted Budget Water Revenue Vs Projected Water Revenue $6,033,776 $5,993,467 $3,525,165 $3,505,945 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 FEBRUARY 2022 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 1,323,762 PREPAID EXPENSES 11,642 ADVALOREM PROPERTY TAXES RECEIVABLE 64,079 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 1,399,483 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 55,849 TOTAL LIABILITIES 55,849 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 723,260 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 620,374 TOTAL FUND BALANCE 1,343,634 TOTAL LIABILITIES AND FUND BALANCE 1,399,483 TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET FEBRUARY 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,814,220 3,814,220 CASH IN BANK -SAVINGS -CASH RESERVE 2,003,375 2,003,375 INVESTMENTS-TEXPOOL 3,346,918 2,985,575 6,332,492 PREPAID EXPENSES 70,104 70,104 ADVALOREM PROPERTY TAXES RECEIVABLE 6,778 6,778 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,191,074 1,191,074 TOTAL ASSETS 10,433,069 2,985,575 13,418,644 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 5,026 5,026 ACCOUNTS AND OTHER PAYABLES 597,498 597,498 CUSTOMER DEPOSITS 314,265 314,265 TOTAL LIABILITIES 916,789 916,789 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,054,023 6,054,023 COMMITTED FUND BALANCE - - NET REVENUES / EXPENDITURES 360,987 360,987 TOTAL FUND BALANCE 9,516,280 2,985,575 12,501,855 TOTAL LIABILITIES AND FUND BALANCE 10,433,069 2,985,575 13,418,644 TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET FEBRUARY 2022 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 785,056 TOTAL ASSETS 785,056 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 19 703,365 785,056 TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET FEBRUARY 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 REVENUE BOND 2,635,985 TOTAL ASSETS 2,635,985 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 550,506 TOTAL LIABILITIES 550,506 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES 4,032,009 (1,946,530) TOTAL FUND BALANCE 2,085,479 TOTAL LIABILITIES AND FUND BALANCE 2,635,985 TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET FEBRUARY 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 894,466 TOTAL ASSETS 894,466 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 155 894,466 894,466 TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET FEBRUARY 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 654,147 35,171 TOTAL ASSETS 689,317 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES ACCOUNTS AND OTHER PAYABLES 57,355 24,165 TOTAL LIABILITIES 81,520 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES (14,841) 622,638 TOTAL FUND BALANCE 607,797 TOTAL LIABILITIES AND FUND BALANCE 689,317 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET FEBRUARY 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB 1 / MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 148,880 TOTAL ASSETS 148,880 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,060 122,820 148,880 148,880 TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET FEBRUARY 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 77,844 TOTAL ASSETS 77,844 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 5,656 72,188 77,844 TOTAL LIABILITIES AND FUND BALANCE 77,844 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET FEBRUARY 2022 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 28,849 TOTAL ASSETS 28,849 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 565 NET REVENUES / EXPENDITURES 28,284 TOTAL FUND BALANCE 28,849 TOTAL LIABILITIES AND FUND BALANCE 28,849