HomeMy WebLinkAbout2021-12 December Combined FinancialsFY 2022 Combined Financials
YTD as of 12/31/2021
• YTD
Revenues
Expenses
Adopted Budget vs YTD Actuals Revenues & Expenses
$2,276,412
$1,997,640
$1,048
$27,276
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
80,639,404
78,390,000
Oct
54,635,000
48,488,000
51,338,613
44,024,449
Budget Consumption —,~Actual Consumption
Nov Dec
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
839,609,871
Total Water Consumption
• Budgeted Water Consumption
• Projected Water Consumption
Presented by:
Finance Department
5900,000
5800,000
5700,000
5600,000
5500,000
$400,000
$300,000
$200,000
$100,000
So
Oct
Water Revenue Budget vs Actual
$569,186
$398,851
3402,228
Budget Revenue —A—Actual Revenue
$370,639
•
$359,936
Nov Dec
$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 $5,934,505
$3,525,165 $3,444,975
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
DECEMBER 2021
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
122
ASSETS FIRE DEPT.
CASH IN BANK -
INVESTMENTS 853,441
PREPAID EXPENSES 14,968
ADVALOREM PROPERTY TAXES RECEIVABLE 679,950
EMERGENCY SERVICES ASSESSMENTS RECEIVABLE
UTILITY AND OTHER ACCOUNTS RECEIVABLE
TOTAL ASSETS 1,548,359
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
DESIGNATED FOR FUTURE ASSET REPLACEMENT
NON -SPENDABLE FUND BALANCE
UNASSIGNED FUND BALANCE 723,260
RESERVE FOR ENCUMBRANCES
NET REVENUES / EXPENDITURES 161,861
TOTAL FUND BALANCE 885,121
663,238
663,238
TOTAL LIABILITIES AND FUND BALANCE 1,548,359
TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND)
BALANCE SHEET
DECEMBER 2021
135 137
4
Tfl PHV CLUB
MUNICIPAL
UTILITY
DISTRICT
GENERAL FUND GASB TOTAL
ASSETS
CASH ON HAND 600 600
CASH IN BANK -CHECKING 3,911,590 3,911,590
CASH IN BANK -SAVINGS -CASH RESERVE 2,002,403 2,002,403
INVESTMENTS-TEXPOOL 3,330,026 2,985,575 6,315,601
PREPAID EXPENSES 89,025 89,025
ADVALOREM PROPERTY TAXES RECEIVABLE 72,764 72,764
UTILITY AND OTHER ACCOUNTS RECEIVABLE 933,280 933,280
TOTAL ASSETS 10,339,689 2,985,575 13,325,264
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 71,012 71,012
ACCOUNTS AND OTHER PAYABLES 522,402 522,402
CUSTOMER DEPOSITS 312,210 312,210
TOTAL LIABILITIES 905,624 905,624
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,054,023 6,054,023
COMMITTED FUND BALANCE - -
NET REVENUES / EXPENDITURES 278,772 278,772
TOTAL FUND BALANCE 9,434,065 2,985,575 12,419,640
TOTAL LIABILITIES AND FUND BALANCE 10,339,689 2,985,575 13,325,264
TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION
NSII FORT WORTH- SWIFT FUNDING
BALANCE SHEET
DECEMBER 2021
ASSETS
CASH IN BANK
CASH IN ESCROW
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
519
REVENUE BOND
CONSTRUCTION
785,047
TOTAL ASSETS 785,047
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
11
703,356
785,047
TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND
BALANCE SHEET
DECEMBER 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
FUND 520
16" 2019
REVENUE BOND
2,872,408
TOTAL ASSETS 2,872,408
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
233,620
TOTAL LIABILITIES 233,620
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
4,032,008
(1,393,220)
TOTAL FUND BALANCE 2,638,788
TOTAL LIABILITIES AND FUND BALANCE 2,872,408
TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE
BALANCE SHEET
DECEMBER 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
528
REVENUE BOND
RESERVE
894,395
TOTAL ASSETS 894,395
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE 894,312
NET REVENUES / EXPENDITURES 83
TOTAL FUND BALANCE 894,395
TOTAL LIABILITIES AND FUND BALANCE 894,395
TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE)
BALANCE SHEET
DECEMBER 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
391,018
370,289
TOTAL ASSETS 761,307
LIABILITIES AND FUND BALANCE
LIABILITIES 57,355
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 359,283
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES 416,639
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
(14,841)
359,509
TOTAL FUND BALANCE 344,668
TOTAL LIABILITIES AND FUND BALANCE 761,307
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP)
BALANCE SHEET
DECEMBER 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
1 /
MUNICIPAL
UTILITY
DISTRICT
534
REVENUE BOND
I&S WWTP
190,478
TOTAL ASSETS 190,478
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
164,418
190,478
190,478
TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S
BALANCE SHEET
DECEMBER 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
535
NSII FTW SWIFT
REVENUE BOND
I&S
81,304
TOTAL ASSETS 81,304
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
TOTAL FUND BALANCE
5,656
75,648
81,304
TOTAL LIABILITIES AND FUND BALANCE 81,304
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S
WATER & WASTEWATER SYSTEM 2019
BALANCE SHEET
DECEMBER 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
536
REVENUE BOND
SERIES 2019 I&S
104,024
TOTAL ASSETS 104,024
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE 565
NET REVENUES / EXPENDITURES 103,459
TOTAL FUND BALANCE 104,024
TOTAL LIABILITIES AND FUND BALANCE 104,024