The URL can be used to link to this page

Home My WebLink About2021-01 January Combined FinancialsCombined Financials Fiscal Year 2021 YTD as of 01/31/2021 Adopted Budget vs YTD Actuals Revenues & Expenses ■ YTD Revenues 11/11 ■ YTD Expenses • ■ Adopted Revenues Adopted Expenses $2,864,508 $2,978,596 $10,227,277 $459 0% $37,485 1% YTD Expense By Departments $1,428,030 48% 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 O Water Consumption Budget vs Actual 115,781,000 f 69,156,299 61,136,000 61,402,206 42,932,939 46,305,000 Budget Consumption —0—Actual Consumption Oct Nov Dec 43,092,000 36,365,918 Jen 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 896,309,692 Total Water Consumption ■ Budgeted Water Consumption ■ Projected Water Consumption Presented by: Finance Department 3600,000 3500,000 3400,000 3300,000 3200,000 $100,000 30 Water Revenue Budget vs Actual —0—Budget Revenue —0—Actual Revenue Oct Nov Dec Jen 37,000,000 36,000,000 35,000,000 34,000,000 33,000,000 32,030,000 $1,000,000 30 Adopted Budget Water Revenue Vs Projected Water Revenue $5,932,489 $5,931,785 1 $3,336,194 Total Water Revenue $3,371,136 ■ 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 JANUARY 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. 10,000 1,159,788 13,193 200,027 TOTAL ASSETS 1,383,008 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 668,784 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 520,908 TOTAL FUND BALANCE 1,189,693 183,315 10,000 193,315 TOTAL LIABILITIES AND FUND BALANCE 1,383,008 TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET JANUARY 2021 135 137 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 3,706,084 3,706,084 CASH IN BANK -SAVINGS -CASH RESERVE 1,846,943 1,846,943 INVESTMENTS-TEXPOOL 3,213,897 2,007,484 5,221,381 PREPAID EXPENSES 75,275 75,275 ADVALOREM PROPERTY TAXES RECEIVABLE 21,785 21,785 UTILITY AND OTHER ACCOUNTS RECEIVABLE 902,533 902,533 TOTAL ASSETS 9,767,117 2,007,484 11,774,601 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 20,033 20,033 ACCOUNTS AND OTHER PAYABLES 377,107 377,107 CUSTOMER DEPOSITS 310,940 310,940 TOTAL LIABILITIES 708,080 708,080 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 (114,088) (114,088) TOTAL FUND BALANCE 9,059,037 2,007,484 11,066,521 TOTAL LIABILITIES AND FUND BALANCE 9,767,117 2,007,484 11,774,601 TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST BALANCE SHEET JANUARY 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TOTAL ASSETS Pi TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 724,278 TOTAL LIABILITIES 724,278 FUND BALANCE ASSIGNED FUND BALANCE (199,119) NET REVENUES / EXPENDITURES (525,159) TOTAL FUND BALANCE (724,278) TOTAL LIABILITIES AND FUND BALANCE TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET JANUARY 2021 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 784,994 TOTAL ASSETS 784,994 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 27 703,303 784,994 TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET JANUARY 2021 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 252,635 INVESTMENTS 3,892,658 ACCOUNTS RECEIVABLE TOTAL ASSETS 4,145,293 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 (6,089) 4,145,293 4,145,293 TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET JANUARY 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 894,188 TOTAL ASSETS 894,188 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 893,867 NET REVENUES / EXPENDITURES 321 TOTAL FUND BALANCE 894,188 TOTAL LIABILITIES AND FUND BALANCE 894,188 TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET JANUARY 2021 ASSETS CASH IN BANK INVESTMENTS 641,147 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 111,098 ACCOUNTS RECEIVABLE -OTHER - TOTAL ASSETS 752,245 5 TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 LIABILITIES AND FUND BALANCE LIABILITIES 64,064 DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 101,495 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 165,559 FUND BALANCE ASSIGNED FUND BALANCE (19,950) NET REVENUES / EXPENDITURES 606,637 TOTAL FUND BALANCE 586,686 TOTAL LIABILITIES AND FUND BALANCE 752,245 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET JANUARY 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB 1 / MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 244,511 TOTAL ASSETS 244,511 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 218,523 244,511 244,511 TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET JANUARY 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 105,275 TOTAL ASSETS 105,275 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 99,650 105,275 105,275 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET JANUARY 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 138,362 TOTAL ASSETS 138,362 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 531 NET REVENUES / EXPENDITURES 137,831 TOTAL FUND BALANCE 138,362 TOTAL LIABILITIES AND FUND BALANCE 138,362