Loading...
HomeMy WebLinkAbout2021-05 May Combined FinancialsFY 2021 Combined Financials YTD as of 05/31/2021 Adopted Budget vs YTD Actuals Revenues & Expenses ■ YTD Revenues NMI • YTD Expenses I Adopted Revenues Adopted Expenses $5,653,659 $5,633,046 • 41•1= $1,608 0% $956,142 17% 111 51,844,651 33% L 551,860 1% YTD Expense By Departments $2,778,785 49% 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 Water Consumption Budget vs Actual 115,781,000 61,136,000 46,305,000 47,602,205 73,522,000 69,013,251 43,092,000 38,117,386 69,156,299 20,000,000 O 61,402,206 42,932,939 I 36,365,918 40,786,000 58,087,848 50,738,000 41,078,000 --Budget Consumption —0—Actual Consumption Oct Nov Dec Jan Feb Mar Apr May 1,200,000,000 1,100,000,000 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 839,853,055 889,613,002 Total Water Consumption • Budgeted Water Consumption • Projected Water Consumption Presented by: Finance Department $600,000 5521,136 , 3500,000 $400,000 3300,000 3200,000 5100,000 50 490,389 Water Revenue Budget vs Actual 5447,160 5465,093 5412,932 5348,784 5337,820 $326,759 $313,020 5371,601 323,259 5326,348 5327,587 —0—Budget Revenue —0—Actual Revenue $423,447 $483,450 5379,555 Oct Nov Dec Jan Feb Mar Apr May Adopted Budget Water Revenue Vs Projected Water Revenue $7,000,000 $6000000 55,932,489 55,828,615 $5,000,000 34,000,000 33,000,000 $2,000,000 31,000,000 30 $3,336,194 $3,418,576 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 MAY 2021 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 949,133 PREPAID EXPENSES 6,596 ADVALOREM PROPERTY TAXES RECEIVABLE 50,153 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 1,005,881 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 33,440 TOTAL LIABILITIES 33,440 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 668,784 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 303,657 TOTAL FUND BALANCE 972,441 TOTAL LIABILITIES AND FUND BALANCE 1,005,881 TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET MAY 2021 135 137 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 3,255,866 3,255,866 CASH IN BANK -SAVINGS -CASH RESERVE 1,998,885 1,998,885 INVESTMENTS-TEXPOOL 3,747,456 2,007,484 5,754,940 PREPAID EXPENSES 39,380 39,380 ADVALOREM PROPERTY TAXES RECEIVABLE 5,371 5,371 UTILITY AND OTHER ACCOUNTS RECEIVABLE 954,076 954,076 TOTAL ASSETS 10,001,634 2,007,484 12,009,118 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 3,619 3,619 ACCOUNTS AND OTHER PAYABLES 490,892 490,892 CUSTOMER DEPOSITS 313,385 313,385 TOTAL LIABILITIES 807,896 807,896 FUND BALANCE NON -SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 2,404,829 2,404,829 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 315,000 315,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 460,899 460,899 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 558,704 558,704 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 472,881 472,881 ASSIGNED FUND BALANCE/WWTP MBR REPLACEMENT 200,000 200,000 UNASSIGNED FUND BALANCE 6,764,810 6,764,810 COMMITTED FUND BALANCE NET REVENUES / EXPENDITURES 20,613 20,613 TOTAL FUND BALANCE 9,193,738 2,007,484 11,201,222 TOTAL LIABILITIES AND FUND BALANCE 10,001,634 2,007,484 12,009,118 TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST BALANCE SHEET MAY 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TOTAL ASSETS 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 Pi TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION (199,119) 199,119 TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET MAY 2021 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 785,020 TOTAL ASSETS 785,020 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,276 53 703,329 785,020 TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET MAY 2021 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 169,203 INVESTMENTS 3,892,786 ACCOUNTS RECEIVABLE TOTAL ASSETS 4,061,989 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 4,151,382 (89,393) 4,061,989 4,061,989 TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET MAY 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 894,250 TOTAL ASSETS 894,250 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 893,867 NET REVENUES / EXPENDITURES 383 TOTAL FUND BALANCE 894,250 TOTAL LIABILITIES AND FUND BALANCE 894,250 TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET MAY 2021 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE ACCOUNTS RECEIVABLE -OTHER 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 533 INTEREST & SINKING DEBT 890,448 27,980 TOTAL ASSETS 918,428 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES ACCOUNTS AND OTHER PAYABLES 64,064 18,377 TOTAL LIABILITIES 82,441 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES (19,950) 855,937 TOTAL FUND BALANCE 835,987 TOTAL LIABILITIES AND FUND BALANCE 918,428 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET MAY 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB 1 / MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 362,596 TOTAL ASSETS 362,596 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 25,988 336,608 362,596 362,596 TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET MAY 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 175,420 TOTAL ASSETS 175,420 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,625 169,795 175,420 175,420 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET MAY 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 164,190 TOTAL ASSETS 164,190 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 531 NET REVENUES / EXPENDITURES 163,659 TOTAL FUND BALANCE 164,190 TOTAL LIABILITIES AND FUND BALANCE 164,190