Loading...
HomeMy WebLinkAbout2020-12 Financials December 202055,906,984 1 Combined Financials Fiscal Year 2021 YTD as of 12/31/2020 Adopted Budget vs YTD Actuals Revenues & Expenses • Adopted Revenues Adopted Expenses Om, ■ YTD Revenues ■ YTD Expenses - $2,190,988 $2,276,703 $458 0% 7 $467,685 21% 9701,906 31% $31,237 1% YTD Expense By Departments $1,075,417 47% 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 61,136,000 42,932,939 69,156,299 61404206 46,305,000 Oct Budget Consumption —0—Actual Consumption Nov Dee 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,583,610 Total Water Consumption ■ Budgeted Water Consumption ■ Projected Water Consumption Presented by: Finance Department 9600,000 9600,000 9400,000 9300,000 9200,000 $100,000 90 $521,136 5490,389 Oce Water Revenue Budget vs Actual 5447,160 $348,784 $412,932 5326,759 —0—Budget Revenue —0—Actual Revenue Nov Dec 97,000,000 $6,000,000 95,000,000 $4,000,000 93,000,000 92,000,000 $1,000,000 90 Adopted Budget Water Revenue Vs Projected Water Revenue 55,932,489 1 $3,336,194 93,305,199 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 DECEMBER 2020 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 813,211 PREPAID EXPENSES 14,842 ADVALOREM PROPERTY TAXES RECEIVABLE 621,716 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 1,449,768 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 652,065 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 175,980 TOTAL FUND BALANCE 828,045 621,723 621,723 TOTAL LIABILITIES AND FUND BALANCE 1,449,768 TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET DECEMBER 2020 135 137 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 3,682,352 3,682,352 CASH IN BANK -SAVINGS -CASH RESERVE 1,846,457 1,846,457 INVESTMENTS-TEXPOOL 3,291,369 2,007,484 5,298,853 PREPAID EXPENSES 84,248 84,248 ADVALOREM PROPERTY TAXES RECEIVABLE 67,953 67,953 UTILITY AND OTHER ACCOUNTS RECEIVABLE 854,931 854,931 TOTAL ASSETS 9,827,910 2,007,484 11,835,394 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 67,953 67,953 ACCOUNTS AND OTHER PAYABLES 361,320 361,320 CUSTOMER DEPOSITS 312,980 312,980 TOTAL LIABILITIES 742,252 742,252 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,763,058 6,763,058 COMMITTED FUND BALANCE NET REVENUES / EXPENDITURES (85,715) (85,715) TOTAL FUND BALANCE 9,085,658 2,007,484 11,093,142 TOTAL LIABILITIES AND FUND BALANCE 9,827,910 2,007,484 11,835,394 TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST BALANCE SHEET DECEMBER 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE Pi TROPHY CLUB MUNICIPAL UTILITY DISTRICT 517 TAX BOND CONSTRUCTION 474,199 TOTAL ASSETS 474,199 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES 685,476 TOTAL LIABILITIES 685,476 FUND BALANCE ASSIGNED FUND BALANCE (199,119) NET REVENUES / EXPENDITURES (12,158) TOTAL FUND BALANCE (211,277) TOTAL LIABILITIES AND FUND BALANCE 474,199 TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET DECEMBER 2020 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 784,987 TOTAL ASSETS 784,987 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 20 703,296 784,987 TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET DECEMBER 2020 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 252,618 INVESTMENTS 3,892,625 ACCOUNTS RECEIVABLE TOTAL ASSETS 4,145,243 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,139) 4,145,243 4,145,243 TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET DECEMBER 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 894,128 TOTAL ASSETS 894,128 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 893,867 NET REVENUES / EXPENDITURES 261 TOTAL FUND BALANCE 894,128 TOTAL LIABILITIES AND FUND BALANCE 894,128 TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET DECEMBER 2020 ASSETS CASH IN BANK INVESTMENTS 395,244 PREPAID EXPENSES - ADVALOREM PROPERTY TAXES RECEIVABLE 344,803 ACCOUNTS RECEIVABLE -OTHER - TOTAL ASSETS 740,048 5 TROPHY CLUB MUNICIPAL UTILITY DISTRICT INTEREST & SINKING- 533 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 344,803 ACCOUNTS AND OTHER PAYABLES - TOTAL LIABILITIES 344,803 FUND BALANCE ASSIGNED FUND BALANCE 34,511 NET REVENUES / EXPENDITURES 360,734 TOTAL FUND BALANCE 395,245 TOTAL LIABILITIES AND FUND BALANCE 740,049 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET DECEMBER 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB 1 / MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 189,876 TOTAL ASSETS 189,876 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 163,888 189,876 189,876 TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET DECEMBER 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 80,360 TOTAL ASSETS 80,360 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES TOTAL FUND BALANCE 5,624 74,736 80,360 TOTAL LIABILITIES AND FUND BALANCE 80,360 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET DECEMBER 2020 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 103,901 TOTAL ASSETS 103,901 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 531 NET REVENUES / EXPENDITURES 103,370 TOTAL FUND BALANCE 103,901 TOTAL LIABILITIES AND FUND BALANCE 103,901