HomeMy WebLinkAbout2022-04 April Combined FinancialsFY 2022 Combined Financials
YTD as of 4/30/2022
YTD
Revenues
• YTD
Expenses
Amended
Revenues
• Amended
Expenses
Adopted
Revenues
Adopted
Expenses
Adopted Budget vs YTD Actuals Revenues & Expenses
$5,261,881
$5,032,257
$10,909,758
$10,829,758
$10,370,758
$1,511 $56,633
0% -I 1%
$789,926
16%
$2,433,694
48%
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
80,639,404
78,390,000
Oct
Water Consumption Budget vs Actual
54,635,000
48,488,000 49,322,000
.0021,000
51,338,613
44,024,449
Budget Consumption
36,662,055
36,449,799
—*-Actual Consumption
38,104,839
72,448,000
56,888,452
Nov Dec Jan Feb Mar Apr
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
877,883,726
Total Water Consumption
• Budgeted Water Consumption
• Projected Water Consumption
Presented by:
Finance Department
5900,000
5800,000
5700,000
5600,000
$500,000
$400,000
$300,000
$200,000
$100,000
So
$569,186
A 0373,428
$370,639 $360,890
$455,836 $328,461 $423,949
$398,851 $359,936
Water Revenue Budget vs Actual
8402,228
$510,419
$320,532 0322,394 0326,817
Budget Revenue --Actual Revenue
Oct Nov Dec Jan Feb Mar Apr
$7,000,000
$6,000,000
$5,000,000
$4,000,000
$3,000,000
$2,000,000
$1,000,000
$0
Adopted Budget Water Revenue Vs Projected Water Revenue
$6,033,776 $6,114,010
$3,525,165 $3,622,001
1
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
APRIL 2022
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
122
ASSETS FIRE DEPT.
CASH IN BANK -
INVESTMENTS 1,029,237
PREPAID EXPENSES 8,316
ADVALOREM PROPERTY TAXES RECEIVABLE 35,343
EMERGENCY SERVICES ASSESSMENTS RECEIVABLE
UTILITY AND OTHER ACCOUNTS RECEIVABLE
TOTAL ASSETS 1,072,896
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS
ACCOUNTS AND OTHER PAYABLES
29,467
TOTAL LIABILITIES 29,467
FUND BALANCE
DESIGNATED FOR FUTURE ASSET REPLACEMENT
NON -SPENDABLE FUND BALANCE
UNASSIGNED FUND BALANCE 720,907
RESERVE FOR ENCUMBRANCES
NET REVENUES / EXPENDITURES 322,522
TOTAL FUND BALANCE 1,043,429
TOTAL LIABILITIES AND FUND BALANCE 1,072,896
TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND)
BALANCE SHEET
APRIL 2022
135 137
4
Tfl PHV CLUB
MUNICIPAL
UTILITY
DISTRICT
GENERAL FUND GASB TOTAL
ASSETS
CASH ON HAND 600 600
CASH IN BANK -CHECKING 4,363,236 4,363,236
CASH IN BANK -SAVINGS -CASH RESERVE 1,480,366 1,480,366
INVESTMENTS-TEXPOOL 3,237,062 2,985,575 6,222,636
PREPAID EXPENSES 51,183 51,183
ADVALOREM PROPERTY TAXES RECEIVABLE 3,697 3,697
UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,088,114 1,088,114
TOTAL ASSETS 10,224,258 2,985,575 13,209,833
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 2,245 2,245
ACCOUNTS AND OTHER PAYABLES 519,246 519,246
CUSTOMER DEPOSITS 318,150 318,150
TOTAL LIABILITIES 839,641 839,641
FUND BALANCE
NON -SPENDABLE FUND BALANCE 3,880 3,880
ASSIGNED FUND BALANCE 3,370,500 3,370,500
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 5,780,613 5,780,613
COMMITTED FUND BALANCE - -
NET REVENUES / EXPENDITURES 229,624 229,624
TOTAL FUND BALANCE 9,384,617 2,985,575 12,370,192
TOTAL LIABILITIES AND FUND BALANCE 10,224,258 2,985,575 13,209,833
TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION
NSII FORT WORTH- SWIFT FUNDING
BALANCE SHEET
APRIL 2022
ASSETS
CASH IN BANK
CASH IN ESCROW
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
519
REVENUE BOND
CONSTRUCTION
785,063
TOTAL ASSETS 785,063
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
27
703,372
785,063
TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND
BALANCE SHEET
APRIL 2022
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
FUND 520
16" 2019
REVENUE BOND
2,128,742
TOTAL ASSETS 2,128,742
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
279,348
TOTAL LIABILITIES 279,348
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
4,032,009
(2,182,615)
TOTAL FUND BALANCE 1,849,394
TOTAL LIABILITIES AND FUND BALANCE 2,128,742
TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE
BALANCE SHEET
APRIL 2022
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
528
REVENUE BOND
RESERVE
894,807
TOTAL ASSETS 894,807
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE 894,311
NET REVENUES / EXPENDITURES 496
TOTAL FUND BALANCE 894,807
TOTAL LIABILITIES AND FUND BALANCE 894,807
TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE)
BALANCE SHEET
APRIL 2022
ASSETS
CASH IN BANK
INVESTMENTS
PREPAID EXPENSES
ADVALOREM PROPERTY TAXES RECEIVABLE
ACCOUNTS RECEIVABLE -OTHER
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
533
INTEREST &
SINKING DEBT
914,132
19,526
TOTAL ASSETS 933,659
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES
ACCOUNTS AND OTHER PAYABLES
57,355
9,987
TOTAL LIABILITIES 67,342
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
(16,307)
882,624
TOTAL FUND BALANCE 866,317
TOTAL LIABILITIES AND FUND BALANCE 933,659
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP)
BALANCE SHEET
APRIL 2022
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
1 /
MUNICIPAL
UTILITY
DISTRICT
534
REVENUE BOND
I&S WWTP
313,378
TOTAL ASSETS 313,378
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
26,061
287,317
313,378
313,378
TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S
BALANCE SHEET
APRIL 2022
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
535
NSII FTW SWIFT
REVENUE BOND
I&S
153,533
TOTAL ASSETS 153,533
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,656
147,877
153,533
153,533
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S
WATER & WASTEWATER SYSTEM 2019
BALANCE SHEET
APRIL 2022
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
536
REVENUE BOND
SERIES 2019 I&S
132,335
TOTAL ASSETS 132,335
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE 565
NET REVENUES / EXPENDITURES 131,770
TOTAL FUND BALANCE 132,335
TOTAL LIABILITIES AND FUND BALANCE 132,335