HomeMy WebLinkAbout2022-09 September Combined FinancialsFY 2022 Combined Financials
YTD as of 9/30/2022
YTD
Revenues
• YTD
Expenses
Amended
Revenues
• Amended
Expenses
Adopted
Revenues
Adopted
Expenses
Adopted Budget vs YTD Actuals Revenues & Expenses
$9,591,888
$10,909,758
$10,829,758
$10,370,758
$2,751 $96,251
0% -. 1%
$1,413,914
15%
YTD Expenses By
Departments
YTD Expense- Water
52,853,970 55,225,002
54%
30% 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
Water Consumption Budget vs Actual
80,639,404
78,390,000
60,000,000
72,448,000
54,635,000
49,322,000
44,588,000
48,488,000
40,021,000
40,000,000 51 338 613 / 56,888,452
44,024,449 B 04,839
36,662,055 36,449,799
20,000,000
119,711,0001
85,474,000
Budget Consumption
143,845,000
08,377,000
41,177,000
I 124313,693
114,781,327
90,391,285
96,534,832
63,970,589
-*-Actual Consumption
0
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
Adopted Budget Water Consumption Vs Actual Water Consumption
1,000,000,000 986,476,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
834,099,338
Total Water Consumption
• Budgeted Water Consumption
■ Proiected Water Consumption
Presented by:
Finance Department
$1,000,000
$900,000
$800,000
$700,000
$600,000
5500,000
$400,000
$455,836 /
$300,000 ;359,936
Water Revenue Budget vs Actual
$569,186
9402,228
$373,428
$370,639
$398,851 J $320,532$322,394
$326,817
$200,000
$328,46
5510,419
$360,890
$918,465
$786,615 /
$580,431
$100,000
$0
$423,949
$466,196
Budget Revenue --Actual Revenue
$817,889
$759,395
$651,814
5939,810
$719,195
$616,814
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
$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,033,776
$3,525,165
Total Water Revenue
$4,008,962
• 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
SEPTEMBER 2022
ASSETS
CASH IN BANK
INVESTMENTS
PREPAID EXPENSES
ADVALOREM PROPERTY TAXES RECEIVABLE
EMERGENCY SERVICES ASSESSMENTS RECEIVABLE
UTILITY AND OTHER ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
122
FIRE DEPT.
675,927
12,891
TOTAL ASSETS 688,819
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 7,015
ACCOUNTS AND OTHER PAYABLES -
TOTAL LIABILITIES 7,015
FUND BALANCE
DESIGNATED FOR FUTURE ASSET REPLACEMENT -
NON -SPENDABLE FUND BALANCE -
UNASSIGNED FUND BALANCE 720,907
RESERVE FOR ENCUMBRANCES -
NET REVENUES / EXPENDITURES (39,103)
TOTAL FUND BALANCE 681,804
TOTAL LIABILITIES AND FUND BALANCE 688,819
TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND)
BALANCE SHEET
SEPTEMBER 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,516,399 4,516,399
CASH IN BANK -SAVINGS -CASH RESERVE 1,882,637 1,882,637
INVESTMENTS-TEXPOOL 3,782,898 2,985,575 6,768,472
PREPAID EXPENSES 3,880 3,880
ADVALOREM PROPERTY TAXES RECEIVABLE 1,288 1,288
UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,291,615 1,291,615
TOTAL ASSETS 11,479,318 2,985,575 14,464,893
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES (164) (164)
ACCOUNTS AND OTHER PAYABLES 308,061 308,061
CUSTOMER DEPOSITS 328,600 328,600
TOTAL LIABILITIES 636,497 636,497
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 1,687,828 1,687,828
TOTAL FUND BALANCE 10,842,821 2,985,575 13,828,396
TOTAL LIABILITIES AND FUND BALANCE 11,479,318 2,985,575 14,464,893
TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION
NSII FORT WORTH- SWIFT FUNDING
BALANCE SHEET
SEPTEMBER 2022
ASSETS
CASH IN BANK
CASH IN ESCROW
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
519
REVENUE BOND
CONSTRUCTION
787,221
TOTAL ASSETS 787,221
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
2,185
705,530
787,221
TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND
BALANCE SHEET
SEPTEMBER 2022
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
FUND 520
16" 2019
REVENUE BOND
1,497,693
TOTAL ASSETS 1,497,693
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
158,596
TOTAL LIABILITIES 158,596
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
4,032,009
(2,692,912)
TOTAL FUND BALANCE 1,339,097
TOTAL LIABILITIES AND FUND BALANCE 1,497,693
TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE
BALANCE SHEET
SEPTEMBER 2022
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
528
REVENUE BOND
RESERVE
900,604
TOTAL ASSETS 900,604
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
894,311
6,293
900,604
900,604
TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE)
BALANCE SHEET
SEPTEMBER 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
51,961
7,294
TOTAL ASSETS 59,255
LIABILITIES AND FUND BALANCE
LIABILITIES 57,355
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES (2,244)
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES 55,111
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
(16,307)
20,453
TOTAL FUND BALANCE 4,144
TOTAL LIABILITIES AND FUND BALANCE 59,255
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP)
BALANCE SHEET
SEPTEMBER 2022
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
1 /
MUNICIPAL
UTILITY
DISTRICT
534
REVENUE BOND
ASSETS I&S WWTP
27,958
TOTAL ASSETS 27,958
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
TOTAL FUND BALANCE
26,061
1,898
27,958
TOTAL LIABILITIES AND FUND BALANCE 27,958
TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S
BALANCE SHEET
SEPTEMBER 2022
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
535
NSII FTW SWIFT
REVENUE BOND
I&S
6,555
TOTAL ASSETS 6,555
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE 5,656
NET REVENUES / EXPENDITURES 899
TOTAL FUND BALANCE 6,555
TOTAL LIABILITIES AND FUND BALANCE 6,555
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S
WATER & WASTEWATER SYSTEM 2019
BALANCE SHEET
SEPTEMBER 2022
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
536
REVENUE BOND
SERIES 2019 I&S
1,429
TOTAL ASSETS 1,429
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE 565
NET REVENUES / EXPENDITURES 864
TOTAL FUND BALANCE 1,429
TOTAL LIABILITIES AND FUND BALANCE 1,429