HomeMy WebLinkAbout2021-06 June Combined FinancialsFY 2021 Combined Financials
YTD as of 06/30/2021
Adopted Budget vs YTD Actuals Revenues & Expenses
■ YTD Revenues
NMI
• YTD Expenses
1 Adopted Revenues
Adopted Expenses
$6,434,623
$6,282,982
• ma=
$2,359
$56,770
0% 1 1%
$1,041,470
16%
$2,067,184
•
33%
YTD Expense 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
O
Water Consumption Budget vs Actual
15,781,000 96,013,079
61,136,000
46,305,000
47,602,205
73,522,000 69,013,251
43,092,000 / 69,501,000
38,117,386
/ 58,087,848
61,402,206
69,156,299 42,932,939 l
36,365,918 40,786,000
41,078,000
—0—Budget Consumption —0—Actual Consumption
50,738,000
Oct Nov Dec Jan Feb Mar Apr May
Jun
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
863,100,923
Total Water Consumption
• Budgeted Water Consumption
• Projected Water Consumption
Presented by:
Finance Department
Water Revenue Budget vs Actual
5337,820 5323,259
$0
—0—Budget Revenue —0—Actual Revenue
Oct Nov Dec Jan Feb Mar Apr May Jun
$7,000,000
$6,000,000
$5,000,000
34,000,000
$3,000,000
$2,000,000
31,000,000
30
Adopted Budget Water Revenue Vs Projected Water Revenue
55,932,489
55,639,480
$3,336,194 $3,322,639
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
JUNE 2021
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
122
ASSETS FIRE DEPT.
CASH IN BANK -
INVESTMENTS 892,894
PREPAID EXPENSES 4,947
ADVALOREM PROPERTY TAXES RECEIVABLE 37,801
EMERGENCY SERVICES ASSESSMENTS RECEIVABLE
UTILITY AND OTHER ACCOUNTS RECEIVABLE
TOTAL ASSETS 935,642
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS
ACCOUNTS AND OTHER PAYABLES
21,088
TOTAL LIABILITIES 21,088
FUND BALANCE
DESIGNATED FOR FUTURE ASSET REPLACEMENT
NON -SPENDABLE FUND BALANCE
UNASSIGNED FUND BALANCE 668,784
RESERVE FOR ENCUMBRANCES
NET REVENUES / EXPENDITURES 245,769
TOTAL FUND BALANCE 914,554
TOTAL LIABILITIES AND FUND BALANCE 935,642
TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND)
BALANCE SHEET
JUNE 2021
135 137
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
GENERAL FUND GASB TOTAL
ASSETS
CASH ON HAND 600 600
CASH IN BANK -CHECKING 3,696,234 3,696,234
CASH IN BANK -SAVINGS -CASH RESERVE 1,999,378 1,999,378
INVESTMENTS-TEXPOOL 3,624,443 2,007,484 5,631,926
PREPAID EXPENSES 30,407 30,407
ADVALOREM PROPERTY TAXES RECEIVABLE 4,019 4,019
UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,010,273 1,010,273
TOTAL ASSETS 10,365,354 2,007,484 12,372,838
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,267 2,267
ACCOUNTS AND OTHER PAYABLES 726,186 726,186
CUSTOMER DEPOSITS 312,135 312,135
TOTAL LIABILITIES 1,040,587 1,040,587
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 151,642 151,642
TOTAL FUND BALANCE 9,324,767 2,007,484 11,332,251
TOTAL LIABILITIES AND FUND BALANCE 10,365,354 2,007,484 12,372,838
TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST
BALANCE SHEET
JUNE 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
JUNE 2021
ASSETS
CASH IN BANK
CASH IN ESCROW
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
519
REVENUE BOND
CONSTRUCTION
785,025
TOTAL ASSETS 785,025
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
58
703,334
785,025
TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND
BALANCE SHEET
JUNE 2021
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
FUND 520
16" 2019
ASSETS REVENUE BOND
161,919
3,892,813
TOTAL ASSETS 4,054,732
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
(96,650)
4,054,732
4,054,732
TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE
BALANCE SHEET
JUNE 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
528
REVENUE BOND
RESERVE
894,260
TOTAL ASSETS 894,260
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE 893,868
NET REVENUES / EXPENDITURES 392
TOTAL FUND BALANCE 894,260
TOTAL LIABILITIES AND FUND BALANCE 894,260
TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE)
BALANCE SHEET
JUNE 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
907,582
21,133
TOTAL ASSETS 928,715
LIABILITIES AND FUND BALANCE
LIABILITIES 64,064
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 11,530
ACCOUNTS AND OTHER PAYABLES 139
TOTAL LIABILITIES 75,733
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
(19,950)
872,932
TOTAL FUND BALANCE 852,982
TOTAL LIABILITIES AND FUND BALANCE 928,715
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP)
BALANCE SHEET
JUNE 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
1 /
MUNICIPAL
UTILITY
DISTRICT
534
REVENUE BOND
I&S WWTP
417,222
TOTAL ASSETS 417,222
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
391,234
417,222
417,222
TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S
BALANCE SHEET
JUNE 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
535
NSII FTW SWIFT
REVENUE BOND
I&S
200,331
TOTAL ASSETS 200,331
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
194,706
200,331
200,331
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S
WATER & WASTEWATER SYSTEM 2019
BALANCE SHEET
JUNE 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
536
REVENUE BOND
SERIES 2019 I&S
198,645
TOTAL ASSETS 198,645
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE 531
NET REVENUES / EXPENDITURES 198,114
TOTAL FUND BALANCE 198,645
TOTAL LIABILITIES AND FUND BALANCE 198,645