HomeMy WebLinkAbout2021-08 August Combined FinancialsFY 2021 Combined Financials
YTD as of 08/31/2021
Adopted Budget vs YTD Actuals Revenues & Expenses
YTD Revenues
• YTD Expenses
- Amended Revenues
•Amended Expenses
■ Adopted Revenues
Adopted Expenses
$7,714,410
$9,357,257
510,227,277
$2,564 $65,485
0%
51,275,872
17%
$2,477,426
32%
1%
$3,893,062
50%
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
98,232,000
77,776,000
61,402,206
69,156,299
57,380,000
47,602,205
42,932,939
42,725,000
40,786,000
40,841,000 gg 117 386
36,365,918
96,013,079
69,013,25
119,706,571
97,846,000
i100,853,000
58,087,848 -64,195,000
41,078,000
50,736,000
—0—Budget Consumption —0—Actual Consumption
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug
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
797,940,841
Total Water Consumption
• Budgeted Water Consumption
• Projected Water Consumption
Presented by:
Finance Department
5900,000
5800,000
5700,000
5600,000 $521,111136
5500,000 `\
5400,000
$447,160
5412,932
5300,000
5200,000
$100,000
50
Water Revenue Budget vs Actual
$348,784
$323,259
$337,820
71,60
5465,093
$691,059
5635,974
5483,450 / 5633,180
5650,853
I $326,348
5327,587
5326,759 $313,020
423,447 $379555
--Budget Revenue —0—Actual Revenue
5446,839
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug
$7,000,000
$6,000,000
$5,000,000
$4,000,000
$3,000,000
$2,000,000
51,000,000
$0
Adopted Budget Water Revenue Vs Projected Water Revenue
$5,932,489
$5,458,320
$3,336,194 $3,271,816
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
AUGUST 2021
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
122
ASSETS FIRE DEPT.
CASH IN BANK -
INVESTMENTS 771,824
PREPAID EXPENSES 1,649
ADVALOREM PROPERTY TAXES RECEIVABLE 16,949
EMERGENCY SERVICES ASSESSMENTS RECEIVABLE
UTILITY AND OTHER ACCOUNTS RECEIVABLE
TOTAL ASSETS 790,422
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS
ACCOUNTS AND OTHER PAYABLES
237
TOTAL LIABILITIES 237
FUND BALANCE
DESIGNATED FOR FUTURE ASSET REPLACEMENT
NON -SPENDABLE FUND BALANCE
UNASSIGNED FUND BALANCE 668,784
RESERVE FOR ENCUMBRANCES
NET REVENUES / EXPENDITURES 121,401
TOTAL FUND BALANCE 790,185
TOTAL LIABILITIES AND FUND BALANCE 790,422
TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND)
BALANCE SHEET
AUGUST 2021
135 137
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
GENERAL FUND GASB TOTAL
ASSETS
CASH ON HAND 600 600
CASH IN BANK -CHECKING 3,011,226 3,011,226
CASH IN BANK -SAVINGS -CASH RESERVE 2,000,397 2,000,397
INVESTMENTS-TEXPOOL 4,377,574 2,007,484 6,385,058
PREPAID EXPENSES 12,460 12,460
ADVALOREM PROPERTY TAXES RECEIVABLE 1,736 1,736
UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,252,746 1,252,746
TOTAL ASSETS 10,656,739 2,007,484 12,664,223
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES (16) (16)
ACCOUNTS AND OTHER PAYABLES 452,791 452,791
CUSTOMER DEPOSITS 312,405 312,405
TOTAL LIABILITIES 765,180 765,180
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 718,434 718,434
TOTAL FUND BALANCE 9,891,559 2,007,484 11,899,043
TOTAL LIABILITIES AND FUND BALANCE 10,656,739 2,007,484 12,664,223
TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST
BALANCE SHEET
AUGUST 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
AUGUST 2021
ASSETS
CASH IN BANK
CASH IN ESCROW
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
519
REVENUE BOND
CONSTRUCTION
785,032
TOTAL ASSETS 785,032
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
65
703,341
785,032
TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND
BALANCE SHEET
AUGUST 2021
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
FUND 520
16" 2019
ASSETS REVENUE BOND
145,375
3,892,849
TOTAL ASSETS 4,038,224
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
(113,158)
4,038,224
4,038,224
TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE
BALANCE SHEET
AUGUST 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
528
REVENUE BOND
RESERVE
894,291
TOTAL ASSETS 894,291
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE 893,868
NET REVENUES / EXPENDITURES 423
TOTAL FUND BALANCE 894,291
TOTAL LIABILITIES AND FUND BALANCE 894,291
TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE)
BALANCE SHEET
AUGUST 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
127,873
9,576
TOTAL ASSETS 137,449
LIABILITIES AND FUND BALANCE
LIABILITIES 64,064
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES (27)
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES 64,037
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
(19,950)
93,362
TOTAL FUND BALANCE 73,412
TOTAL LIABILITIES AND FUND BALANCE 137,449
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP)
BALANCE SHEET
AUGUST 2021
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
1 /
MUNICIPAL
UTILITY
DISTRICT
534
REVENUE BOND
ASSETS I&S WWTP
26,060
TOTAL ASSETS 26,060
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE 25,988
NET REVENUES / EXPENDITURES 72
TOTAL FUND BALANCE 26,060
TOTAL LIABILITIES AND FUND BALANCE 26,060
TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S
BALANCE SHEET
AUGUST 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
535
NSII FTW SWIFT
REVENUE BOND
I&S
5,656
TOTAL ASSETS 5,656
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE 5,625
NET REVENUES / EXPENDITURES 31
TOTAL FUND BALANCE 5,656
TOTAL LIABILITIES AND FUND BALANCE 5,656
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S
WATER & WASTEWATER SYSTEM 2019
BALANCE SHEET
AUGUST 2021
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TOTAL ASSETS
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
536
REVENUE BOND
ASSETS SERIES 2019 I&S
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
565
565
FUND BALANCE
ASSIGNED FUND BALANCE 531
NET REVENUES / EXPENDITURES 34
TOTAL FUND BALANCE 565
TOTAL LIABILITIES AND FUND BALANCE 565