HomeMy WebLinkAbout2022-03 March Combined FinancialsFY 2022 Combined Financials
YTD as of 3/31/2022
YTD
Revenues
• YTD
Expenses
Adopted Budget vs YTD Actuals Revenues & Expenses
$4,410,259
$4,226,976
51,510
0v
$54,651
1%
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
78,390,000
60,000,000
40,000,000
20,000,000
0
Water Consumption Budget vs Actual
80,639,404
51,338,613
54,635,000 48,488,000 49,322,000
44,588,000
44,024,449
36,662,055
40,021,000
36,449,799
Budget Consumption—1—Actual Consumption
38,104,839
Oct Nov Dec Jan Feb Mar
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
66G,3G4,1
Total Water Consumption
• Budgeted Water Consumption
■ Proiected Water Consumption
Presented by:
Finance Department
5900,000
5800,000
5700,000
$600,000
5500,000
$400,000
$455,836
$300,000
$200,000
$100,000
50
Water Revenue Budget vs Actual
$569,186
$402,228
$370,639
$373,428
$328,461
5398,851 5359,936
$320,532
Budget Revenue —A—Actual Revenue
$322,394
3360890
5326,817
Oct Nov Dec Jan Feb Mar
$7,000,000
56,000,000
$5,000,000
$4,000,000
53,000,000
$2,000,000
51,000,000
$0
Adopted Budget Water Revenue Vs Projected Water Revenue
$6,033,776 $6,027,540
53,525,165 53,550,277
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
MARCH 2022
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
122
ASSETS FIRE DEPT.
CASH IN BANK -
INVESTMENTS 1,065,700
PREPAID EXPENSES 9,979
ADVALOREM PROPERTY TAXES RECEIVABLE 75,276
EMERGENCY SERVICES ASSESSMENTS RECEIVABLE
UTILITY AND OTHER ACCOUNTS RECEIVABLE
TOTAL ASSETS 1,150,955
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS
ACCOUNTS AND OTHER PAYABLES
69,400
TOTAL LIABILITIES 69,400
FUND BALANCE
DESIGNATED FOR FUTURE ASSET REPLACEMENT
NON -SPENDABLE FUND BALANCE
UNASSIGNED FUND BALANCE 720,907
RESERVE FOR ENCUMBRANCES
NET REVENUES / EXPENDITURES 360,648
TOTAL FUND BALANCE 1,081,555
TOTAL LIABILITIES AND FUND BALANCE 1,150,955
TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND)
BALANCE SHEET
MARCH 2022
135 137
4
Tfl PHV CLUB
MUNICIPAL
UTILITY
DISTRICT
GENERAL FUND GASB TOTAL
ASSETS
CASH ON HAND 600 600
CASH IN BANK -CHECKING 3,889,568 3,889,568
CASH IN BANK -SAVINGS -CASH RESERVE 2,003,885 2,003,885
INVESTMENTS-TEXPOOL 3,356,139 2,985,575 6,341,714
PREPAID EXPENSES 60,643 60,643
ADVALOREM PROPERTY TAXES RECEIVABLE 7,978 7,978
UTILITY AND OTHER ACCOUNTS RECEIVABLE 916,725 916,725
TOTAL ASSETS 10,235,539 2,985,575 13,221,114
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 6,526 6,526
ACCOUNTS AND OTHER PAYABLES 573,547 573,547
CUSTOMER DEPOSITS 317,190 317,190
TOTAL LIABILITIES 897,263 897,263
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,053,723 6,053,723
COMMITTED FUND BALANCE - -
NET REVENUES / EXPENDITURES 183,283 183,283
TOTAL FUND BALANCE 9,338,276 2,985,575 12,323,851
TOTAL LIABILITIES AND FUND BALANCE 10,235,539 2,985,575 13,221,114
TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION
NSII FORT WORTH- SWIFT FUNDING
BALANCE SHEET
MARCH 2022
ASSETS
CASH IN BANK
CASH IN ESCROW
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
519
REVENUE BOND
CONSTRUCTION
785,059
TOTAL ASSETS 785,059
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
23
703,368
785,059
TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND
BALANCE SHEET
MARCH 2022
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
FUND 520
16" 2019
REVENUE BOND
2,130,057
TOTAL ASSETS 2,130,057
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
160,128
TOTAL LIABILITIES 160,128
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
4,032,009
(2,062,080)
TOTAL FUND BALANCE 1,969,929
TOTAL LIABILITIES AND FUND BALANCE 2,130,057
TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE
BALANCE SHEET
MARCH 2022
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
528
REVENUE BOND
RESERVE
894,583
TOTAL ASSETS 894,583
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE 894,311
NET REVENUES / EXPENDITURES 272
TOTAL FUND BALANCE 894,583
TOTAL LIABILITIES AND FUND BALANCE 894,583
TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE)
BALANCE SHEET
MARCH 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
882,512
41,263
TOTAL ASSETS 923,775
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES
ACCOUNTS AND OTHER PAYABLES
57,355
31,725
TOTAL LIABILITIES 89,080
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
(16,307)
851,003
TOTAL FUND BALANCE 834,695
TOTAL LIABILITIES AND FUND BALANCE 923,775
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP)
BALANCE SHEET
MARCH 2022
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
1 /
MUNICIPAL
UTILITY
DISTRICT
534
REVENUE BOND
I&S WWTP
258,508
TOTAL ASSETS 258,508
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
232,447
258,508
258,508
TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S
BALANCE SHEET
MARCH 2022
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
535
NSII FTW SWIFT
REVENUE BOND
I&S
128,285
TOTAL ASSETS 128,285
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
122,629
128,285
128,285
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S
WATER & WASTEWATER SYSTEM 2019
BALANCE SHEET
MARCH 2022
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
536
REVENUE BOND
SERIES 2019 I&S
97,825
TOTAL ASSETS 97,825
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE 565
NET REVENUES / EXPENDITURES 97,260
TOTAL FUND BALANCE 97,825
TOTAL LIABILITIES AND FUND BALANCE 97,825