Loading...
HomeMy WebLinkAbout2021-09 September Combined FinancialsFY 2021 Combined Financials YTD as of 09/30/2021 YTD Revenues YTD Expenses Amended Revenues 1 Amended Expenses Adopted Revenues Adopted Expenses Adopted Budget vs YTD Actuals Revenues & Expenses $9,504,563 $9,703,255 $10,227,277 $2,680 $77,516 0% 1 1% $1,410,602 15% $3,285,126 34% $4,815,490 50% 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 119,706,571 105,962,511 96,013,079 97,846,000 69,013,251 95,492,841 67,776,000 100,853,000 112,674,000 47,602,205 64,195,000 -4—Budget Consumption 58,087,848 50,736,000 —0—Actual Consumption Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep 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 815,122,000 Total Water Consumption • Budgeted Water Consumption • Projected Water Consumption Presented by: Finance Department $900,000 $800,000 $700,000 $600,000 5521,136 Water Revenue Budget vs Actual $447,160 $500,000 \ $348,784 371,60 $400,000 9490,389 5337,820 $326348 $635,974 5483,450 5465,093 5691,053 5716,304 5412,932 $300,000 5323,259 5327,587 5326,759 $313,020 $200,000 $100,000 SO 423,447 $379555 --Budget Revenue y •Actual Revenue 5650,85 5446,839 5633,186 5630,212 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep $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 $5,932,489 $5,544,413 $3,336,194 $3,459,959 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 SEPTEMBER 2021 ASSETS CASH IN BANK INVESTMENTS PREPAID EXPENSES ADVALOREM PROPERTY TAXES RECEIVABLE EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 FIRE DEPT. 706,548 14,359 TOTAL ASSETS 720,907 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES (2,354) TOTAL LIABILITIES (2,354) FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 668,784 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 54,476 TOTAL FUND BALANCE 723,260 TOTAL LIABILITIES AND FUND BALANCE 720,907 TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET SEPTEMBER 2021 135 137 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 3,466,999 3,466,999 CASH IN BANK -SAVINGS -CASH RESERVE 2,000,890 2,000,890 INVESTMENTS-TEXPOOL 3,132,101 3,253,456 6,385,557 PREPAID EXPENSES 4,370 4,370 ADVALOREM PROPERTY TAXES RECEIVABLE 1,452 1,452 UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,304,064 1,304,064 TOTAL ASSETS 9,910,476 3,253,456 13,163,932 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES (300) (300) ACCOUNTS AND OTHER PAYABLES 512,217 512,217 CUSTOMER DEPOSITS 312,285 312,285 TOTAL LIABILITIES 824,202 824,202 FUND BALANCE NON -SPENDABLE FUND BALANCE 3,486 3,486 ASSIGNED FUND BALANCE 1,518,116 1,518,116 ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 315,000 315,000 ASSIGNED FUND BALANCE/WATER REPLACEMENT 1,083,885 1,083,885 ASSIGNED FUND BALANCE/SEWER REPLACEMENT 1,181,690 1,181,690 ASSIGNED FUND BALANCE/FIRE DEPARTMENT 472,881 472,881 ASSIGNED FUND BALANCE/WWTP MBR REPLACEMENT 200,000 200,000 UNASSIGNED FUND BALANCE 7,651,523 7,651,523 COMMITTED FUND BALANCE NET REVENUES / EXPENDITURES (86,851) (86,851) TOTAL FUND BALANCE 9,086,274 3,253,456 12,339,730 TOTAL LIABILITIES AND FUND BALANCE 9,910,476 3,253,456 13,163,932 TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST BALANCE SHEET SEPTEMBER 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 SEPTEMBER 2021 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 785,036 TOTAL ASSETS 785,036 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 69 703,345 785,036 TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET SEPTEMBER 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 REVENUE BOND 4,033,089 TOTAL ASSETS 4,033,089 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,383 (118,294) 4,033,089 4,033,089 TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET SEPTEMBER 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 894,311 TOTAL ASSETS 894,311 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 893,867 NET REVENUES / EXPENDITURES 444 TOTAL FUND BALANCE 894,311 TOTAL LIABILITIES AND FUND BALANCE 894,311 TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET SEPTEMBER 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 32,911 8,136 TOTAL ASSETS 41,047 LIABILITIES AND FUND BALANCE LIABILITIES 64,064 DEFERRED REVENUE - AD VALOREM PROPERTY TAXES (1,467) ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES 62,597 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES (19,950) (1,600) TOTAL FUND BALANCE (21,550) TOTAL LIABILITIES AND FUND BALANCE 41,047 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET SEPTEMBER 2021 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB 1 / MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND ASSETS I&S WWTP 26,061 TOTAL ASSETS 26,061 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 25,988 NET REVENUES / EXPENDITURES 72 TOTAL FUND BALANCE 26,061 TOTAL LIABILITIES AND FUND BALANCE 26,061 TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET SEPTEMBER 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 5,656 TOTAL ASSETS 5,656 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 5,625 NET REVENUES / EXPENDITURES 31 TOTAL FUND BALANCE 5,656 TOTAL LIABILITIES AND FUND BALANCE 5,656 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET SEPTEMBER 2021 CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TOTAL ASSETS TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND ASSETS SERIES 2019 I&S LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES 565 565 FUND BALANCE ASSIGNED FUND BALANCE 531 NET REVENUES / EXPENDITURES 34 TOTAL FUND BALANCE 565 TOTAL LIABILITIES AND FUND BALANCE 565