HomeMy WebLinkAbout2022-01 January Combined FinancialsFY 2022 Combined Financials
YTD as of 1/31/2022
• YTD
Revenues
Expenses
Adopted Budget vs YTD Actuals Revenues & Expenses
53,028,959
$2,882,819
$1,163
$43,285
o% 2%
$454,912
$1,396,700
$986,759
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
54,635,000
51,338,613
48,488,000 49,322,000
r
1i
44,024,449
Budget Consumption --Actual Consumption
36,662,055
Oct Nov Dec Jan
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
852,269,816
Total Water Consumption
• Budgeted Water Consumption
• Projected Water Consumption
Presented by:
Finance Department
$900,000
5800,000
$700,000
5600,000
$500,000
$400,000
$455,836
$300,000
$200,000
$100,000
50
Water Revenue Budget vs Actual
$569,186
$402,228
$370,639
$398,851 $359,936
Budget Revenue --Actual Revenue
3373,428
$320,532
Oct Nov Dec Jan
$7,000,000
$6,000,000
$5,000,000
$4,000,000
$3,000,000
$2,000,000
$1,000,000
so
Adopted Budget Water Revenue Vs Projected Water Revenue
$6,033,776 $5,987,400
$3,525,165 $3,499,971
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
JANUARY 2022
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
122
ASSETS FIRE DEPT.
CASH IN BANK -
INVESTMENTS 1,232,593
PREPAID EXPENSES 13,305
ADVALOREM PROPERTY TAXES RECEIVABLE 229,210
EMERGENCY SERVICES ASSESSMENTS RECEIVABLE
UTILITY AND OTHER ACCOUNTS RECEIVABLE
TOTAL ASSETS 1,475,107
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 220,980
ACCOUNTS AND OTHER PAYABLES -
TOTAL LIABILITIES 220,980
FUND BALANCE
DESIGNATED FOR FUTURE ASSET REPLACEMENT
NON -SPENDABLE FUND BALANCE
UNASSIGNED FUND BALANCE 723,260
RESERVE FOR ENCUMBRANCES
NET REVENUES / EXPENDITURES 530,867
TOTAL FUND BALANCE 1,254,127
TOTAL LIABILITIES AND FUND BALANCE 1,475,107
TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND)
BALANCE SHEET
JANUARY 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,823,724 3,823,724
CASH IN BANK -SAVINGS -CASH RESERVE 2,002,914 2,002,914
INVESTMENTS-TEXPOOL 3,253,866 2,985,575 6,239,440
PREPAID EXPENSES 79,564 79,564
ADVALOREM PROPERTY TAXES RECEIVABLE 24,471 24,471
UTILITY AND OTHER ACCOUNTS RECEIVABLE 940,239 940,239
TOTAL ASSETS 10,125,377 2,985,575 13,110,952
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 22,719 22,719
ACCOUNTS AND OTHER PAYABLES 488,756 488,756
CUSTOMER DEPOSITS 312,470 312,470
TOTAL LIABILITIES 823,945 823,945
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 146,140 146,140
TOTAL FUND BALANCE 9,301,432 2,985,575 12,287,007
TOTAL LIABILITIES AND FUND BALANCE 10,125,377 2,985,575 13,110,952
TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION
NSII FORT WORTH- SWIFT FUNDING
BALANCE SHEET
JANUARY 2022
ASSETS
CASH IN BANK
CASH IN ESCROW
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
519
REVENUE BOND
CONSTRUCTION
785,052
TOTAL ASSETS 785,052
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
16
703,361
785,052
TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND
BALANCE SHEET
JANUARY 2022
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
FUND 520
16" 2019
REVENUE BOND
2,635,857
TOTAL ASSETS 2,635,857
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
412,372
TOTAL LIABILITIES 412,372
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
4,032,009
(1,808,524)
TOTAL FUND BALANCE 2,223,485
TOTAL LIABILITIES AND FUND BALANCE 2,635,857
TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE
BALANCE SHEET
JANUARY 2022
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
528
REVENUE BOND
RESERVE
894,423
TOTAL ASSETS 894,423
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
112
894,423
894,423
TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE)
BALANCE SHEET
JANUARY 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
648,590
125,025
TOTAL ASSETS 773,615
LIABILITIES AND FUND BALANCE
LIABILITIES 57,355
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 114,019
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES 171,375
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
(14,841)
617,081
TOTAL FUND BALANCE 602,240
TOTAL LIABILITIES AND FUND BALANCE 773,615
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP)
BALANCE SHEET
JANUARY 2022
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
1 /
MUNICIPAL
UTILITY
DISTRICT
534
REVENUE BOND
I&S WWTP
245,288
TOTAL ASSETS 245,288
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
219,228
245,288
245,288
TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S
BALANCE SHEET
JANUARY 2022
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
535
NSII FTW SWIFT
REVENUE BOND
I&S
106,522
TOTAL ASSETS 106,522
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
100,866
106,522
106,522
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S
WATER & WASTEWATER SYSTEM 2019
BALANCE SHEET
JANUARY 2022
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
536
REVENUE BOND
SERIES 2019 I&S
138,513
TOTAL ASSETS 138,513
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE 565
NET REVENUES / EXPENDITURES 137,948
TOTAL FUND BALANCE 138,513
TOTAL LIABILITIES AND FUND BALANCE 138,513