HomeMy WebLinkAbout2021-01 January Combined FinancialsCombined Financials
Fiscal Year 2021
YTD as of 01/31/2021
Adopted Budget vs YTD Actuals Revenues & Expenses
■ YTD Revenues
11/11
■ YTD Expenses
• ■ Adopted Revenues
Adopted Expenses
$2,864,508
$2,978,596
$10,227,277
$459
0%
$37,485
1%
YTD Expense By Departments
$1,428,030
48% 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
O
Water Consumption Budget vs Actual
115,781,000
f
69,156,299
61,136,000
61,402,206
42,932,939
46,305,000
Budget Consumption —0—Actual Consumption
Oct Nov Dec
43,092,000
36,365,918
Jen
1,200,000,000
1,100,000,000
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
839,853,055
896,309,692
Total Water Consumption
■ Budgeted Water Consumption
■ Projected Water Consumption
Presented by:
Finance Department
3600,000
3500,000
3400,000
3300,000
3200,000
$100,000
30
Water Revenue Budget vs Actual
—0—Budget Revenue —0—Actual Revenue
Oct Nov Dec Jen
37,000,000
36,000,000
35,000,000
34,000,000
33,000,000
32,030,000
$1,000,000
30
Adopted Budget Water Revenue Vs Projected Water Revenue
$5,932,489 $5,931,785
1
$3,336,194
Total Water Revenue
$3,371,136
■ 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 2021
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.
10,000
1,159,788
13,193
200,027
TOTAL ASSETS 1,383,008
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 668,784
RESERVE FOR ENCUMBRANCES
NET REVENUES / EXPENDITURES 520,908
TOTAL FUND BALANCE 1,189,693
183,315
10,000
193,315
TOTAL LIABILITIES AND FUND BALANCE 1,383,008
TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND)
BALANCE SHEET
JANUARY 2021
135 137
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
GENERAL FUND GASB TOTAL
ASSETS
CASH ON HAND 600 600
CASH IN BANK -CHECKING 3,706,084 3,706,084
CASH IN BANK -SAVINGS -CASH RESERVE 1,846,943 1,846,943
INVESTMENTS-TEXPOOL 3,213,897 2,007,484 5,221,381
PREPAID EXPENSES 75,275 75,275
ADVALOREM PROPERTY TAXES RECEIVABLE 21,785 21,785
UTILITY AND OTHER ACCOUNTS RECEIVABLE 902,533 902,533
TOTAL ASSETS 9,767,117 2,007,484 11,774,601
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 20,033 20,033
ACCOUNTS AND OTHER PAYABLES 377,107 377,107
CUSTOMER DEPOSITS 310,940 310,940
TOTAL LIABILITIES 708,080 708,080
FUND BALANCE
NON -SPENDABLE FUND BALANCE 3,486 3,486
ASSIGNED FUND BALANCE 2,404,829 2,404,829
ASSIGNED FUND BALANCE/TOWN ELEVATED STORAGE TANK 315,000 315,000
ASSIGNED FUND BALANCE/WATER REPLACEMENT 460,899 460,899
ASSIGNED FUND BALANCE/SEWER REPLACEMENT 558,704 558,704
ASSIGNED FUND BALANCE/FIRE DEPARTMENT 472,881 472,881
ASSIGNED FUND BALANCE/WWTP MBR REPLACEMENT 200,000 200,000
UNASSIGNED FUND BALANCE 6,764,810 6,764,810
COMMITTED FUND BALANCE
NET REVENUES / EXPENDITURES (114,088) (114,088)
TOTAL FUND BALANCE 9,059,037 2,007,484 11,066,521
TOTAL LIABILITIES AND FUND BALANCE 9,767,117 2,007,484 11,774,601
TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST
BALANCE SHEET
JANUARY 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TOTAL ASSETS
Pi
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
517
TAX BOND
CONSTRUCTION
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES 724,278
TOTAL LIABILITIES 724,278
FUND BALANCE
ASSIGNED FUND BALANCE (199,119)
NET REVENUES / EXPENDITURES (525,159)
TOTAL FUND BALANCE (724,278)
TOTAL LIABILITIES AND FUND BALANCE
TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION
NSII FORT WORTH- SWIFT FUNDING
BALANCE SHEET
JANUARY 2021
ASSETS
CASH IN BANK
CASH IN ESCROW
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
519
REVENUE BOND
CONSTRUCTION
784,994
TOTAL ASSETS 784,994
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,276
27
703,303
784,994
TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND
BALANCE SHEET
JANUARY 2021
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
FUND 520
16" 2019
ASSETS REVENUE BOND
CASH IN BANK 252,635
INVESTMENTS 3,892,658
ACCOUNTS RECEIVABLE
TOTAL ASSETS 4,145,293
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
4,151,382
(6,089)
4,145,293
4,145,293
TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE
BALANCE SHEET
JANUARY 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
528
REVENUE BOND
RESERVE
894,188
TOTAL ASSETS 894,188
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE 893,867
NET REVENUES / EXPENDITURES 321
TOTAL FUND BALANCE 894,188
TOTAL LIABILITIES AND FUND BALANCE 894,188
TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE)
BALANCE SHEET
JANUARY 2021
ASSETS
CASH IN BANK
INVESTMENTS 641,147
PREPAID EXPENSES -
ADVALOREM PROPERTY TAXES RECEIVABLE 111,098
ACCOUNTS RECEIVABLE -OTHER -
TOTAL ASSETS 752,245
5
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
INTEREST &
SINKING- 533
LIABILITIES AND FUND BALANCE
LIABILITIES 64,064
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 101,495
ACCOUNTS AND OTHER PAYABLES -
TOTAL LIABILITIES 165,559
FUND BALANCE
ASSIGNED FUND BALANCE (19,950)
NET REVENUES / EXPENDITURES 606,637
TOTAL FUND BALANCE 586,686
TOTAL LIABILITIES AND FUND BALANCE 752,245
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP)
BALANCE SHEET
JANUARY 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
1 /
MUNICIPAL
UTILITY
DISTRICT
534
REVENUE BOND
I&S WWTP
244,511
TOTAL ASSETS 244,511
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
25,988
218,523
244,511
244,511
TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S
BALANCE SHEET
JANUARY 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
535
NSII FTW SWIFT
REVENUE BOND
I&S
105,275
TOTAL ASSETS 105,275
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,625
99,650
105,275
105,275
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S
WATER & WASTEWATER SYSTEM 2019
BALANCE SHEET
JANUARY 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
536
REVENUE BOND
SERIES 2019 I&S
138,362
TOTAL ASSETS 138,362
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE 531
NET REVENUES / EXPENDITURES 137,831
TOTAL FUND BALANCE 138,362
TOTAL LIABILITIES AND FUND BALANCE 138,362