HomeMy WebLinkAbout2021-11 November Combined FinancialsFY 2022 Combined Financials
YTD as of 11/30/2021
• YTD
Revenues
Expenses
Adopted Budget vs YTD Actuals Revenues & Expenses
51,526,577
$1,312,786
5932
$7,563
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
78,390,000
80,639,404
51,338,613
54,635,000
Budget Consumption —,~Actual Consumption
Oct Nov
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
834,099,338 835,146,320
Total Water Consumption
• Budgeted Water Consumption
• Projected Water Consumption
Presented by:
Finance Department
$900,000
5800,000
$700,000
5600,000
$500,000
$400,000
$300,000
$200,000
$100,000
50
Water Revenue Budget vs Actual
$455,836
$569,186
$398,851 J
Budget Revenue --Actual Revenue
Oct Nov
$7,000,000
$6,000,000
$5,000,000
$4,000,000
53,000,000
$2,000,000
$1,000,000
$0
Adopted Budget Water Revenue Vs Projected Water Revenue
$6,033,776 $5,923,802
$3,525,165 $3,420,126
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
NOVEMBER 2021
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
122
ASSETS FIRE DEPT.
CASH IN BANK -
INVESTMENTS 1,076,474
PREPAID EXPENSES 16,631
ADVALOREM PROPERTY TAXES RECEIVABLE 1,157,226
EMERGENCY SERVICES ASSESSMENTS RECEIVABLE
UTILITY AND OTHER ACCOUNTS RECEIVABLE
TOTAL ASSETS 2,250,331
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
RESERVE FOR ENCUMBRANCES
NET REVENUES / EXPENDITURES
TOTAL FUND BALANCE
TOTAL LIABILITIES AND FUND BALANCE
1,140,514
629,193
1,769,707
723,260
(242,636)
480,624
2,250,331
TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND)
BALANCE SHEET
NOVEMBER 2021
135 137
4
Tfl PHV CLUB
MUNICIPAL
UTILITY
DISTRICT
GENERAL FUND GASB TOTAL
ASSETS
CASH ON HAND 600 600
CASH IN BANK -CHECKING 3,821,755 3,821,755
CASH IN BANK -SAVINGS -CASH RESERVE 2,001,893 2,001,893
INVESTMENTS-TEXPOOL 2,815,233 2,985,575 5,800,808
PREPAID EXPENSES 98,485 98,485
ADVALOREM PROPERTY TAXES RECEIVABLE 123,901 123,901
UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,684,263 1,684,263
TOTAL ASSETS 10,546,130 2,985,575 13,531,705
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 122,149 122,149
ACCOUNTS AND OTHER PAYABLES 743,108 743,108
CUSTOMER DEPOSITS 311,790 311,790
TOTAL LIABILITIES 1,177,047 1,177,047
FUND BALANCE
NON -SPENDABLE FUND BALANCE 3,880 3,880
ASSIGNED FUND BALANCE 3,097,390 3,097,390
ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 360,000 360,000
ASSIGNED FUND BALANCE/WATER REPLACEMENT 1,113,885 1,113,885
ASSIGNED FUND BALANCE/SEWER REPLACEMENT 1,211,690 1,211,690
ASSIGNED FUND BALANCE/FIRE DEPARTMENT - -
ASSIGNED FUND BALANCE/WWTP MBR REPLACEMENT 300,000 300,000
UNASSIGNED FUND BALANCE 6,054,023 6,054,023
COMMITTED FUND BALANCE - -
NET REVENUES / EXPENDITURES 213,791 213,791
TOTAL FUND BALANCE 9,369,083 2,985,575 12,354,658
TOTAL LIABILITIES AND FUND BALANCE 10,546,130 2,985,575 13,531,705
TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST
BALANCE SHEET
NOVEMBER 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
TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION
NSII FORT WORTH- SWIFT FUNDING
BALANCE SHEET
NOVEMBER 2021
ASSETS
CASH IN BANK
CASH IN ESCROW
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
519
REVENUE BOND
CONSTRUCTION
785,043
TOTAL ASSETS 785,043
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,345
7
703,352
785,043
TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND
BALANCE SHEET
NOVEMBER 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
FUND 520
16" 2019
REVENUE BOND
4,032,256
TOTAL ASSETS 4,032,256
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
1,159,964
TOTAL LIABILITIES 1,159,964
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
4,032,009
(1,159,717)
TOTAL FUND BALANCE 2,872,292
TOTAL LIABILITIES AND FUND BALANCE 4,032,256
TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE
BALANCE SHEET
NOVEMBER 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
528
REVENUE BOND
RESERVE
894,366
TOTAL ASSETS 894,366
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE 894,311
NET REVENUES / EXPENDITURES 55
TOTAL FUND BALANCE 894,366
TOTAL LIABILITIES AND FUND BALANCE 894,366
TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE)
BALANCE SHEET
NOVEMBER 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
108,185
629,993
TOTAL ASSETS 738,178
LIABILITIES AND FUND BALANCE
LIABILITIES 57,356
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 618,987
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES 676,343
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
(14,841)
76,676
TOTAL FUND BALANCE 61,835
TOTAL LIABILITIES AND FUND BALANCE 738,178
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP)
BALANCE SHEET
NOVEMBER 2021
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
1 /
MUNICIPAL
UTILITY
DISTRICT
534
REVENUE BOND
ASSETS I&S WWTP
80,868
TOTAL ASSETS 80,868
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
TOTAL FUND BALANCE
26,061
54,807
80,868
TOTAL LIABILITIES AND FUND BALANCE 80,868
TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S
BALANCE SHEET
NOVEMBER 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
535
NSII FTW SWIFT
REVENUE BOND
I&S
30,872
TOTAL ASSETS 30,872
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
TOTAL FUND BALANCE
5,656
25,216
30,872
TOTAL LIABILITIES AND FUND BALANCE 30,872
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S
WATER & WASTEWATER SYSTEM 2019
BALANCE SHEET
NOVEMBER 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
536
REVENUE BOND
SERIES 2019 I&S
35,052
TOTAL ASSETS 35,052
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE 565
NET REVENUES / EXPENDITURES 34,487
TOTAL FUND BALANCE 35,052
TOTAL LIABILITIES AND FUND BALANCE 35,052