HomeMy WebLinkAbout2022-02 February Combined FinancialsFY 2022 Combined Financials
YTD as of 2/28/2022
YTD
Revenues
• YTD
Expenses
Adopted Budget vs YTD Actuals Revenues & Expenses
53,715,943
$3,354,957
$1,394 $44,293
0% 1%
$548,357
17%
$1,110,148
33%
$1,650,765
49%
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 49,322,000
51,338,613
44,024,449
36,662,055
Budget Consumption --Actual Consumption
Nov Dec Jan Feb
40,021,000
36,449,799
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
855,841,017
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
$455,836
5300,000
$200,000
$100,000
50
Oct
$569,186
Water Revenue Budget vs Actual
$402,228
$370,639 $373,428
5398,851 $359,936
$320,532
Budget Revenue --Actual Revenue
Nov Dec Jan
3328,461
$322,394
Feb
$7,000,000
56,000,000
$5,000,000
$4,000,000
$3,000,000
$2,000,000
51,000,000
50
Adopted Budget Water Revenue Vs Projected Water Revenue
$6,033,776 $5,993,467
$3,525,165 $3,505,945
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
FEBRUARY 2022
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
122
ASSETS FIRE DEPT.
CASH IN BANK -
INVESTMENTS 1,323,762
PREPAID EXPENSES 11,642
ADVALOREM PROPERTY TAXES RECEIVABLE 64,079
EMERGENCY SERVICES ASSESSMENTS RECEIVABLE
UTILITY AND OTHER ACCOUNTS RECEIVABLE
TOTAL ASSETS 1,399,483
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS
ACCOUNTS AND OTHER PAYABLES
55,849
TOTAL LIABILITIES 55,849
FUND BALANCE
DESIGNATED FOR FUTURE ASSET REPLACEMENT
NON -SPENDABLE FUND BALANCE
UNASSIGNED FUND BALANCE 723,260
RESERVE FOR ENCUMBRANCES
NET REVENUES / EXPENDITURES 620,374
TOTAL FUND BALANCE 1,343,634
TOTAL LIABILITIES AND FUND BALANCE 1,399,483
TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND)
BALANCE SHEET
FEBRUARY 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,814,220 3,814,220
CASH IN BANK -SAVINGS -CASH RESERVE 2,003,375 2,003,375
INVESTMENTS-TEXPOOL 3,346,918 2,985,575 6,332,492
PREPAID EXPENSES 70,104 70,104
ADVALOREM PROPERTY TAXES RECEIVABLE 6,778 6,778
UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,191,074 1,191,074
TOTAL ASSETS 10,433,069 2,985,575 13,418,644
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 5,026 5,026
ACCOUNTS AND OTHER PAYABLES 597,498 597,498
CUSTOMER DEPOSITS 314,265 314,265
TOTAL LIABILITIES 916,789 916,789
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 360,987 360,987
TOTAL FUND BALANCE 9,516,280 2,985,575 12,501,855
TOTAL LIABILITIES AND FUND BALANCE 10,433,069 2,985,575 13,418,644
TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION
NSII FORT WORTH- SWIFT FUNDING
BALANCE SHEET
FEBRUARY 2022
ASSETS
CASH IN BANK
CASH IN ESCROW
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
519
REVENUE BOND
CONSTRUCTION
785,056
TOTAL ASSETS 785,056
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
19
703,365
785,056
TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND
BALANCE SHEET
FEBRUARY 2022
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
FUND 520
16" 2019
REVENUE BOND
2,635,985
TOTAL ASSETS 2,635,985
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
550,506
TOTAL LIABILITIES 550,506
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
4,032,009
(1,946,530)
TOTAL FUND BALANCE 2,085,479
TOTAL LIABILITIES AND FUND BALANCE 2,635,985
TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE
BALANCE SHEET
FEBRUARY 2022
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
528
REVENUE BOND
RESERVE
894,466
TOTAL ASSETS 894,466
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
155
894,466
894,466
TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE)
BALANCE SHEET
FEBRUARY 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
654,147
35,171
TOTAL ASSETS 689,317
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES
ACCOUNTS AND OTHER PAYABLES
57,355
24,165
TOTAL LIABILITIES 81,520
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
(14,841)
622,638
TOTAL FUND BALANCE 607,797
TOTAL LIABILITIES AND FUND BALANCE 689,317
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP)
BALANCE SHEET
FEBRUARY 2022
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
1 /
MUNICIPAL
UTILITY
DISTRICT
534
REVENUE BOND
I&S WWTP
148,880
TOTAL ASSETS 148,880
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,060
122,820
148,880
148,880
TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S
BALANCE SHEET
FEBRUARY 2022
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
535
NSII FTW SWIFT
REVENUE BOND
I&S
77,844
TOTAL ASSETS 77,844
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
TOTAL FUND BALANCE
5,656
72,188
77,844
TOTAL LIABILITIES AND FUND BALANCE 77,844
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S
WATER & WASTEWATER SYSTEM 2019
BALANCE SHEET
FEBRUARY 2022
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
536
REVENUE BOND
SERIES 2019 I&S
28,849
TOTAL ASSETS 28,849
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE 565
NET REVENUES / EXPENDITURES 28,284
TOTAL FUND BALANCE 28,849
TOTAL LIABILITIES AND FUND BALANCE 28,849