HomeMy WebLinkAbout2021-07 Combined Financials July 2021FY 2021 Combined Financials
YTD as of 07/31/2021
Adopted Budget vs YTD Actuals Revenues & Expenses
• YTD Revenues
• YTD Expenses
. Amended Revenues
11.1
• Amended Expenses
r Adopted Revenues
Adopted Expenses
$6,978,681
59,357,258
52,360
0%
51,151,174
17%
$60,885
1%
YTD Expense By Departments
53,506,871
50% YTD Expense- Water
52,257,391 YTD Expense- WW
32%
YTD Expense- Admin
• YTD Expense- BOD
• YTD Expense- Non Dept
Water Budget vs Actual
140,000,000
120,000,000
115,781,000
100,000,000
80,000,000
60,000,000
61402,206
40,000,000
69,156,299
20,000,000
Water Consumption Budget vs Actual
61,136,000
46,305,000
43,092,000
38,117,386
0
42,932,939
47,602,205
105,962,511
96,013,079 -
73,522,000 69,013,25
36,365,918 40,786,000
--Budget Consumption
Oct Nov Dec Jan Feb
58,087,848
50,738,000
41,078,000
—0—Actual Consumption
100,853.000
69,501,000
Mar Apr May Jun Jul
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
857,991,412
Total Water Consumption
• Budgeted Water Consumption
• Projected Water Consumption
Presented by:
Finance Department
Water Revenue Budget vs Actual
5800,000
5700,000
5600,000
5521,136
5447,160
5500,000 II1}i��\
5400,000 5490,359
$412,,9932
5300,000
5200,000
5100,000
50
5348,784 5371,601
5323,259
Sa_aj1■ J
\ 5326,348
5313,020
$326,759
$635,974
5483,450
$465,093 \
$327,58]
5423,447
—0—Budget Revenue —0—Actual Revenue
379,555
5691,059 -
5650,853
$446,839
Oct Nov Dec Jan Feb Mar Apr May Jun Jul
$7,000,000
$6,000,000
55,000,000
$4,000,000
$3,000,000
$2,000,000
51,000,000
50
Adopted Budget Water Revenue Vs Projected Water Revenue
55,932,489
55,599,274
$3,336,194 53,370,365
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
JULY 2021
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
122
ASSETS FIRE DEPT.
CASH IN BANK -
INVESTMENTS 835,426
PREPAID EXPENSES 3,298
ADVALOREM PROPERTY TAXES RECEIVABLE 21,188
EMERGENCY SERVICES ASSESSMENTS RECEIVABLE
UTILITY AND OTHER ACCOUNTS RECEIVABLE
TOTAL ASSETS 859,912
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS
ACCOUNTS AND OTHER PAYABLES
4,476
TOTAL LIABILITIES 4,476
FUND BALANCE
DESIGNATED FOR FUTURE ASSET REPLACEMENT
NON -SPENDABLE FUND BALANCE
UNASSIGNED FUND BALANCE 668,784
RESERVE FOR ENCUMBRANCES
NET REVENUES / EXPENDITURES 186,652
TOTAL FUND BALANCE 855,436
TOTAL LIABILITIES AND FUND BALANCE 859,912
TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND)
BALANCE SHEET
JULY 2021
135 137
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
GENERAL FUND GASB TOTAL
ASSETS
CASH ON HAND 600 600
CASH IN BANK -CHECKING 2,590,505 2,590,505
CASH IN BANK -SAVINGS -CASH RESERVE 1,999,887 1,999,887
INVESTMENTS-TEXPOOL 4,501,328 2,007,484 6,508,812
PREPAID EXPENSES 21,433 21,433
ADVALOREM PROPERTY TAXES RECEIVABLE 2,200 2,200
UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,248,179 1,248,179
TOTAL ASSETS 10,364,133 2,007,484 12,371,617
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 448 448
ACCOUNTS AND OTHER PAYABLES 416,607 416,607
CUSTOMER DEPOSITS 312,280 312,280
TOTAL LIABILITIES 729,334 729,334
FUND BALANCE
NON -SPENDABLE FUND BALANCE 3,486 3,486
ASSIGNED FUND BALANCE 1,518,116 1,518,116
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 7,651,523 7,651,523
COMMITTED FUND BALANCE
NET REVENUES / EXPENDITURES 461,674 461,674
TOTAL FUND BALANCE 9,634,799 2,007,484 11,642,283
TOTAL LIABILITIES AND FUND BALANCE 10,364,133 2,007,484 12,371,617
TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST
BALANCE SHEET
JULY 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TOTAL ASSETS
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
Pi
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
517
TAX BOND
CONSTRUCTION
(199,119)
199,119
TROPHY CLUB MUD NO. 1 - REVENUE BOND CONSTRUCTION
NSII FORT WORTH- SWIFT FUNDING
BALANCE SHEET
JULY 2021
ASSETS
CASH IN BANK
CASH IN ESCROW
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
519
REVENUE BOND
CONSTRUCTION
785,029
TOTAL ASSETS 785,029
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
62
703,338
785,029
TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND
BALANCE SHEET
JULY 2021
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
FUND 520
16" 2019
ASSETS REVENUE BOND
157,470
3,892,831
TOTAL ASSETS 4,050,301
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,383
(101,082)
4,050,301
4,050,301
TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE
BALANCE SHEET
JULY 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
528
REVENUE BOND
RESERVE
894,274
TOTAL ASSETS 894,274
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE 893,867
NET REVENUES / EXPENDITURES 406
TOTAL FUND BALANCE 894,274
TOTAL LIABILITIES AND FUND BALANCE 894,274
TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE)
BALANCE SHEET
JULY 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
923,901
11,925
TOTAL ASSETS 935,827
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES
ACCOUNTS AND OTHER PAYABLES
64,064
2,322
TOTAL LIABILITIES 66,386
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
(19,950)
889,391
TOTAL FUND BALANCE 869,441
TOTAL LIABILITIES AND FUND BALANCE 935,827
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP)
BALANCE SHEET
JULY 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
1 /
MUNICIPAL
UTILITY
DISTRICT
534
REVENUE BOND
I&S WWTP
471,850
TOTAL ASSETS 471,850
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
445,862
471,850
471,850
TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S
BALANCE SHEET
JULY 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
535
NSII FTW SWIFT
REVENUE BOND
I&S
225,243
TOTAL ASSETS 225,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
5,625
219,618
225,243
225,243
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S
WATER & WASTEWATER SYSTEM 2019
BALANCE SHEET
JULY 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
536
REVENUE BOND
SERIES 2019 I&S
233,102
TOTAL ASSETS 233,102
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE 531
NET REVENUES / EXPENDITURES 232,571
TOTAL FUND BALANCE 233,102
TOTAL LIABILITIES AND FUND BALANCE 233,102