Loading...
HomeMy WebLinkAbout2021-02 February Combined FinancialsL � FY 2021 Combined Financials YTD as of 02/28/2021 Adopted Budget vs YTD Actuals Revenues & Expenses ■ YTD Revenues NMI • YTD Expenses • Adopted Revenues Adopted Expenses $3,491,200 $3,471,768 510,227,277 $1,376 0% $654,268 19% $1,146,360 33% $41,117 1% YTD Expense By Departments $1,628,648 1 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 115,781,000 • 69,156,299 Water Consumption Budget vs Actual 61,136,000 61,402,206 42,932,939 46,305,000 43,092,000 36,365,918 --Budget Consumption —0—Actual Consumption Oct Nov Dec Jan 38,117,386 40,786,000 Fab 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 5600,000 5521,136 $500,000 5490,389 $400,000 3300,000 3200,000 5100,000 Water Revenue Budget vs Actual 5447,160 $0 5348,784 $412,932 5326,759 533720 1 5313,020 —0—Budget Revenue —0—Actual Revenue Oct Nov Dec Jen $374,254 5326,348 Feb Adopted Budget Water Consumption Vs Actual Water Consumption Adopted Budget Water Revenue Vs Projected Water Revenue $7,000,000 $6,000,000 55,000,000 04,000,000 $3,000,000 $2,000,000 01,000,000 Presented by: Finance Department 839,853,055 898,978,306 Total Water Consumption • Budgeted Water Consumption • Projected Water Consumption $0 55,932,489 55,934,874 53,336,194 53,425,294 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 2021 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 122 ASSETS FIRE DEPT. CASH IN BANK - INVESTMENTS 1,039,047 PREPAID EXPENSES 11,543 ADVALOREM PROPERTY TAXES RECEIVABLE 78,874 EMERGENCY SERVICES ASSESSMENTS RECEIVABLE UTILITY AND OTHER ACCOUNTS RECEIVABLE TOTAL ASSETS 1,129,464 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS ACCOUNTS AND OTHER PAYABLES 62,161 TOTAL LIABILITIES 62,161 FUND BALANCE DESIGNATED FOR FUTURE ASSET REPLACEMENT NON -SPENDABLE FUND BALANCE UNASSIGNED FUND BALANCE 668,784 RESERVE FOR ENCUMBRANCES NET REVENUES / EXPENDITURES 398,518 TOTAL FUND BALANCE 1,067,302 TOTAL LIABILITIES AND FUND BALANCE 1,129,464 TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND) BALANCE SHEET FEBRUARY 2021 135 137 TROPHY CLUB MUNICIPAL UTILITY DISTRICT GENERAL FUND GASB TOTAL ASSETS CASH ON HAND 600 600 CASH IN BANK -CHECKING 3,917,086 3,917,086 CASH IN BANK -SAVINGS -CASH RESERVE 1,997,374 1,997,374 INVESTMENTS-TEXPOOL 3,114,123 2,007,484 5,121,607 PREPAID EXPENSES 66,301 66,301 ADVALOREM PROPERTY TAXES RECEIVABLE 8,521 8,521 UTILITY AND OTHER ACCOUNTS RECEIVABLE 884,816 884,816 TOTAL ASSETS 9,988,822 2,007,484 11,996,306 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 6,769 6,769 ACCOUNTS AND OTHER PAYABLES 477,657 477,657 CUSTOMER DEPOSITS 311,840 311,840 TOTAL LIABILITIES 796,266 796,266 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 19,432 19,432 TOTAL FUND BALANCE 9,192,556 2,007,484 11,200,040 TOTAL LIABILITIES AND FUND BALANCE 9,988,822 2,007,484 11,996,306 TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST BALANCE SHEET FEBRUARY 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 685,476 TOTAL LIABILITIES 685,476 FUND BALANCE ASSIGNED FUND BALANCE (199,119) NET REVENUES / EXPENDITURES (486,357) TOTAL FUND BALANCE (685,476) TOTAL LIABILITIES AND FUND BALANCE TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION NSII FORT WORTH- SWIFT FUNDING BALANCE SHEET FEBRUARY 2021 ASSETS CASH IN BANK CASH IN ESCROW INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT 519 REVENUE BOND CONSTRUCTION 785,000 TOTAL ASSETS 785,000 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 33 703,309 785,000 TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND BALANCE SHEET FEBRUARY 2021 4 TROPHY CLUB MUNICIPAL UTILITY DISTRICT FUND 520 16" 2019 ASSETS REVENUE BOND CASH IN BANK 242,982 INVESTMENTS 3,892,691 ACCOUNTS RECEIVABLE TOTAL ASSETS 4,135,673 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 (15,709) 4,135,673 4,135,673 TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE BALANCE SHEET FEBRUARY 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 528 REVENUE BOND RESERVE 894,218 TOTAL ASSETS 894,218 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 893,867 NET REVENUES / EXPENDITURES 351 TOTAL FUND BALANCE 894,218 TOTAL LIABILITIES AND FUND BALANCE 894,218 TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE) BALANCE SHEET FEBRUARY 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 827,121 43,949 TOTAL ASSETS 871,070 LIABILITIES AND FUND BALANCE LIABILITIES DEFERRED REVENUE - AD VALOREM PROPERTY TAXES ACCOUNTS AND OTHER PAYABLES 64,064 34,346 TOTAL LIABILITIES 98,410 FUND BALANCE ASSIGNED FUND BALANCE NET REVENUES / EXPENDITURES (19,950) 792,610 TOTAL FUND BALANCE 772,660 TOTAL LIABILITIES AND FUND BALANCE 871,070 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP) BALANCE SHEET FEBRUARY 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE 4 TROPHY CLUB 1 / MUNICIPAL UTILITY DISTRICT 534 REVENUE BOND I&S WWTP 198,723 TOTAL ASSETS 198,723 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 172,735 198,723 198,723 TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S BALANCE SHEET FEBRUARY 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 535 NSII FTW SWIFT REVENUE BOND I&S 100,689 TOTAL ASSETS 100,689 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 95,064 100,689 100,689 TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S WATER & WASTEWATER SYSTEM 2019 BALANCE SHEET FEBRUARY 2021 ASSETS CASH IN BANK INVESTMENTS ACCOUNTS RECEIVABLE TROPHY CLUB MUNICIPAL UTILITY DISTRICT 536 REVENUE BOND SERIES 2019 I&S 60,826 TOTAL ASSETS 60,826 LIABILITIES AND FUND BALANCE LIABILITIES ACCOUNTS AND OTHER PAYABLES TOTAL LIABILITIES FUND BALANCE ASSIGNED FUND BALANCE 531 NET REVENUES / EXPENDITURES 60,295 TOTAL FUND BALANCE 60,826 TOTAL LIABILITIES AND FUND BALANCE 60,826