HomeMy WebLinkAbout2022-10 October Combined FinancialsAdopted Budget vs YTD Actuals Revenues & Expenses
$980,888
$853,655
$11,733,354
$11,733,354
FY 2023 Combined Financials
YTD as of 10/31/2022
YTD
Revenues
• YTD
Expenses
$116 $4,500
0% — 1%
$213,570
25%
$353,080
41%
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
- 101,683,000
88,979,203
Budget Consumption—1—Actual Consumption
Oct
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
808,128,121 820,831,917
Total Water Consumption
■ Budgeted Water Consumption
■ Projected Water Consumption
Presented by:
Finance Department
$1,000,000
$900,000
$800,000
$700,000
$600,000
$500,000
$400,000
$300,000
5200,000
$100,000
$0
Water Revenue Budget vs Actual
$703,717
$664,453
Budget Revenue --Actual Revenue
Oct
$8,000,000
$7,000,000
$6,000,000
$5,000,000
$4,000,000
$3,000,000
$2,000,000
$1,000,000
$o
Adopted Budget Water Revenue Vs Projected Water Revenue
$6,710,979 $6,671,714
$4,070,848 $4,031,583
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
OCTOBER 2022
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
122
ASSETS FIRE DEPT.
CASH IN BANK -
INVESTMENTS 495,455
PREPAID EXPENSES 20,738
ADVALOREM PROPERTY TAXES RECEIVABLE 1,219,334
EMERGENCY SERVICES ASSESSMENTS RECEIVABLE
UTILITY AND OTHER ACCOUNTS RECEIVABLE
TOTAL ASSETS 1,735,527
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 1,213,458
ACCOUNTS AND OTHER PAYABLES -
TOTAL LIABILITIES 1,213,458
FUND BALANCE
DESIGNATED FOR FUTURE ASSET REPLACEMENT -
NON -SPENDABLE FUND BALANCE
UNASSIGNED FUND BALANCE 681,804
RESERVE FOR ENCUMBRANCES -
NET REVENUES / EXPENDITURES (159,734)
TOTAL FUND BALANCE 522,069
TOTAL LIABILITIES AND FUND BALANCE 1,735,527
TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND)
BALANCE SHEET
OCTOBER 2022
135 137
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
GENERAL FUND GASB TOTAL
ASSETS
CASH ON HAND 600 600
CASH IN BANK -CHECKING 4,613,604 4,613,604
CASH IN BANK -SAVINGS -CASH RESERVE 1,885,069 1,885,069
INVESTMENTS-TEXPOOL 3,321,346 3,422,147 6,743,492
PREPAID EXPENSES 116,112 116,112
ADVALOREM PROPERTY TAXES RECEIVABLE 130,737 130,737
UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,333,655 1,333,655
TOTAL ASSETS 11,401,123 3,422,147 14,823,270
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 129,284 129,284
ACCOUNTS AND OTHER PAYABLES 369,567 369,567
CUSTOMER DEPOSITS 327,500 327,500
TOTAL LIABILITIES 826,351 826,351
FUND BALANCE
NON -SPENDABLE FUND BALANCE 3,880 3,880
ASSIGNED FUND BALANCE 4,770,878 4,770,878
ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 405,000 405,000
ASSIGNED FUND BALANCE/WATER REPLACEMENT 26,736 26,736
ASSIGNED FUND BALANCE/WATER REPLACEMENT 1,231,524 1,231,524
ASSIGNED FUND BALANCE/SEWER REPLACEMENT 1,287,467 1,287,467
ASSIGNED FUND BALANCE/FIRE DEPARTMENT 81,420 81,420
ASSIGNED FUND BALANCE/WWTP MBR REPLACEMENT 390,000 390,000
UNASSIGNED FUND BALANCE 5,672,780 5,672,780
COMMITTED FUND BALANCE
NET REVENUES / EXPENDITURES 127,234 127,234
TOTAL FUND BALANCE 10,574,772 3,422,147 13,996,919
TOTAL LIABILITIES AND FUND BALANCE 11,401,123 3,422,147 14,823,270
TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION
NSII FORT WORTH- SWIFT FUNDING
BALANCE SHEET
OCTOBER 2022
ASSETS
CASH IN BANK
CASH IN ESCROW
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
519
REVENUE BOND
CONSTRUCTION
788,434
TOTAL ASSETS 788,434
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
705,530
1,213
706,743
788,434
TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND
BALANCE SHEET
OCTOBER 2022
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
FUND 520
16" 2019
REVENUE BOND
1,367,677
TOTAL ASSETS 1,367,677
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES 158,280
TOTAL LIABILITIES 158,280
FUND BALANCE
ASSIGNED FUND BALANCE 1,339,097
NET REVENUES / EXPENDITURES (129,700)
TOTAL FUND BALANCE 1,209,397
TOTAL LIABILITIES AND FUND BALANCE 1,367,677
TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE
BALANCE SHEET
OCTOBER 2022
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
528
REVENUE BOND
RESERVE
902,848
TOTAL ASSETS 902,848
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
900,604
2,244
902,848
902,848
TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE)
BALANCE SHEET
OCTOBER 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
64,441
663,715
TOTAL ASSETS 728,156
LIABILITIES AND FUND BALANCE
LIABILITIES 62,967
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 654,176
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES 717,143
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
(1,467)
12,480
TOTAL FUND BALANCE 11,013
TOTAL LIABILITIES AND FUND BALANCE 728,156
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP)
BALANCE SHEET
OCTOBER 2022
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
1 /
MUNICIPAL
UTILITY
DISTRICT
534
REVENUE BOND
ASSETS I&S WWTP
83,000
TOTAL ASSETS 83,000
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
TOTAL FUND BALANCE
27,959
55,041
83,000
TOTAL LIABILITIES AND FUND BALANCE 83,000
TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S
BALANCE SHEET
OCTOBER 2022
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
535
NSII FTW SWIFT
REVENUE BOND
I&S
31,622
TOTAL ASSETS 31,622
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
TOTAL FUND BALANCE
6,555
25,067
31,622
TOTAL LIABILITIES AND FUND BALANCE 31,622
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S
WATER & WASTEWATER SYSTEM 2019
BALANCE SHEET
OCTOBER 2022
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
536
REVENUE BOND
SERIES 2019 I&S
35,939
TOTAL ASSETS 35,939
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
TOTAL FUND BALANCE
1,429
34,510
35,939
TOTAL LIABILITIES AND FUND BALANCE 35,939