HomeMy WebLinkAbout2020-12 Financials December 202055,906,984
1
Combined Financials
Fiscal Year 2021
YTD as of 12/31/2020
Adopted Budget vs YTD Actuals Revenues & Expenses
• Adopted Revenues
Adopted Expenses
Om,
■ YTD Revenues
■ YTD Expenses -
$2,190,988
$2,276,703
$458
0% 7
$467,685
21%
9701,906
31%
$31,237
1%
YTD Expense By Departments
$1,075,417
47%
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
61,136,000
42,932,939
69,156,299 61404206
46,305,000
Oct
Budget Consumption —0—Actual Consumption
Nov Dee
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
889,583,610
Total Water Consumption
■ Budgeted Water Consumption
■ Projected Water Consumption
Presented by:
Finance Department
9600,000
9600,000
9400,000
9300,000
9200,000
$100,000
90
$521,136
5490,389
Oce
Water Revenue Budget vs Actual
5447,160
$348,784
$412,932
5326,759
—0—Budget Revenue —0—Actual Revenue
Nov Dec
97,000,000
$6,000,000
95,000,000
$4,000,000
93,000,000
92,000,000
$1,000,000
90
Adopted Budget Water Revenue Vs Projected Water Revenue
55,932,489
1
$3,336,194 93,305,199
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 2020
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
122
ASSETS FIRE DEPT.
CASH IN BANK -
INVESTMENTS 813,211
PREPAID EXPENSES 14,842
ADVALOREM PROPERTY TAXES RECEIVABLE 621,716
EMERGENCY SERVICES ASSESSMENTS RECEIVABLE
UTILITY AND OTHER ACCOUNTS RECEIVABLE
TOTAL ASSETS 1,449,768
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 652,065
RESERVE FOR ENCUMBRANCES
NET REVENUES / EXPENDITURES 175,980
TOTAL FUND BALANCE 828,045
621,723
621,723
TOTAL LIABILITIES AND FUND BALANCE 1,449,768
TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND)
BALANCE SHEET
DECEMBER 2020
135 137
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
GENERAL FUND GASB TOTAL
ASSETS
CASH ON HAND 600 600
CASH IN BANK -CHECKING 3,682,352 3,682,352
CASH IN BANK -SAVINGS -CASH RESERVE 1,846,457 1,846,457
INVESTMENTS-TEXPOOL 3,291,369 2,007,484 5,298,853
PREPAID EXPENSES 84,248 84,248
ADVALOREM PROPERTY TAXES RECEIVABLE 67,953 67,953
UTILITY AND OTHER ACCOUNTS RECEIVABLE 854,931 854,931
TOTAL ASSETS 9,827,910 2,007,484 11,835,394
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 67,953 67,953
ACCOUNTS AND OTHER PAYABLES 361,320 361,320
CUSTOMER DEPOSITS 312,980 312,980
TOTAL LIABILITIES 742,252 742,252
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,763,058 6,763,058
COMMITTED FUND BALANCE
NET REVENUES / EXPENDITURES (85,715) (85,715)
TOTAL FUND BALANCE 9,085,658 2,007,484 11,093,142
TOTAL LIABILITIES AND FUND BALANCE 9,827,910 2,007,484 11,835,394
TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST
BALANCE SHEET
DECEMBER 2020
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
Pi
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
517
TAX BOND
CONSTRUCTION
474,199
TOTAL ASSETS 474,199
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES 685,476
TOTAL LIABILITIES 685,476
FUND BALANCE
ASSIGNED FUND BALANCE (199,119)
NET REVENUES / EXPENDITURES (12,158)
TOTAL FUND BALANCE (211,277)
TOTAL LIABILITIES AND FUND BALANCE 474,199
TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION
NSII FORT WORTH- SWIFT FUNDING
BALANCE SHEET
DECEMBER 2020
ASSETS
CASH IN BANK
CASH IN ESCROW
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
519
REVENUE BOND
CONSTRUCTION
784,987
TOTAL ASSETS 784,987
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
20
703,296
784,987
TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND
BALANCE SHEET
DECEMBER 2020
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
FUND 520
16" 2019
ASSETS REVENUE BOND
CASH IN BANK 252,618
INVESTMENTS 3,892,625
ACCOUNTS RECEIVABLE
TOTAL ASSETS 4,145,243
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,139)
4,145,243
4,145,243
TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE
BALANCE SHEET
DECEMBER 2020
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
528
REVENUE BOND
RESERVE
894,128
TOTAL ASSETS 894,128
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE 893,867
NET REVENUES / EXPENDITURES 261
TOTAL FUND BALANCE 894,128
TOTAL LIABILITIES AND FUND BALANCE 894,128
TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE)
BALANCE SHEET
DECEMBER 2020
ASSETS
CASH IN BANK
INVESTMENTS 395,244
PREPAID EXPENSES -
ADVALOREM PROPERTY TAXES RECEIVABLE 344,803
ACCOUNTS RECEIVABLE -OTHER -
TOTAL ASSETS 740,048
5
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
INTEREST &
SINKING- 533
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 344,803
ACCOUNTS AND OTHER PAYABLES -
TOTAL LIABILITIES 344,803
FUND BALANCE
ASSIGNED FUND BALANCE 34,511
NET REVENUES / EXPENDITURES 360,734
TOTAL FUND BALANCE 395,245
TOTAL LIABILITIES AND FUND BALANCE 740,049
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP)
BALANCE SHEET
DECEMBER 2020
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
1 /
MUNICIPAL
UTILITY
DISTRICT
534
REVENUE BOND
I&S WWTP
189,876
TOTAL ASSETS 189,876
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
163,888
189,876
189,876
TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S
BALANCE SHEET
DECEMBER 2020
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
535
NSII FTW SWIFT
REVENUE BOND
I&S
80,360
TOTAL ASSETS 80,360
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
TOTAL FUND BALANCE
5,624
74,736
80,360
TOTAL LIABILITIES AND FUND BALANCE 80,360
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S
WATER & WASTEWATER SYSTEM 2019
BALANCE SHEET
DECEMBER 2020
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
536
REVENUE BOND
SERIES 2019 I&S
103,901
TOTAL ASSETS 103,901
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE 531
NET REVENUES / EXPENDITURES 103,370
TOTAL FUND BALANCE 103,901
TOTAL LIABILITIES AND FUND BALANCE 103,901