HomeMy WebLinkAbout2021-04 April 2021 Combined FinancialsFY 2021 Combined Financials
YTD as of 04/30/2021
Adopted Budget vs YTD Actuals Revenues & Expenses
YTD Revenues
YTD Expenses
• Adopted Revenues
Adopted Expenses
J
$1,607
011
$46,487
1%
YTD Expense By Departments
52,399,940
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
Water Consumption Budget vs Actual
115,781,000
61,136,000
46,305,000
47,602,205
43,092,000
38,117,386
69,156,299
61,402,206
42,932,939 -
36,365,918 40,786,000
—0—Budget Consumption —0—Actual Consumption
Oct Nov Dec
Jan
Fab Mar
58,087,848
41,078,000
Apr
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,8 3,055
907,888,253
Total Water Consumption
• Budgeted Water Consumption
• Projected Water Consumption
Presented by:
Finance Department
$600,000
5521,136
$500,000
$400,000
$300,000
5200,000
$100,000
$0
Water Revenue Budget vs Actual
5447,160 5465,093
5490,389
5348,784
$337,820
5412,932
5326,759
5313,020
5323,259
5326,348
5371,601
—0—Budget Revenue —0—Actual Revenue
5327,587
Oct Nov Dec Jan Feb Mar
5423,447
Apr
$7,000,000
$6,000,000
85,000,000
$4,000,000
53,000,000
52,000,000
$1,000,000
50
Adopted Budget Water Revenue Vs Projected Water Revenue
55,932,489 55,932,508
53,336,194 53,500,711
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
APRIL 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.
57,369
945,810
8,245
51,687
TOTAL ASSETS 1,063,111
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - PROPERTY TAXES/ASSESSMENTS 34,975
ACCOUNTS AND OTHER PAYABLES -
TOTAL LIABILITIES 34,975
FUND BALANCE
DESIGNATED FOR FUTURE ASSET REPLACEMENT -
NON -SPENDABLE FUND BALANCE -
UNASSIGNED FUND BALANCE 668,784
RESERVE FOR ENCUMBRANCES -
NET REVENUES / EXPENDITURES 359,352
TOTAL FUND BALANCE 1,028,136
TOTAL LIABILITIES AND FUND BALANCE 1,063,111
TROPHY CLUB MUD NO. 1 - O&M (GENERAL FUND)
BALANCE SHEET
APRIL 2021
SI
TROPHY CL
4
MUNICIPAL
UTILITY
DISTRICT
135 137
GENERAL FUND GASB TOTAL
ASSETS
CASH ON HAND 600 600
CASH IN BANK -CHECKING 3,254,251 3,254,251
CASH IN BANK -SAVINGS -CASH RESERVE 1,998,376 1,998,376
INVESTMENTS-TEXPOOL 3,870,242 2,007,484 5,877,726
PREPAID EXPENSES 48,354 48,354
ADVALOREM PROPERTY TAXES RECEIVABLE 5,540 5,540
UTILITY AND OTHER ACCOUNTS RECEIVABLE 1,036,097 1,036,097
TOTAL ASSETS 10,213,459 2,007,484 12,220,943
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES 3,788 3,788
ACCOUNTS AND OTHER PAYABLES 734,849 734,849
CUSTOMER DEPOSITS 313,495 313,495
TOTAL LIABILITIES 1,052,131 1,052,131
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 (11,797) (11,797)
TOTAL FUND BALANCE 9,161,328 2,007,484 11,168,812
TOTAL LIABILITIES AND FUND BALANCE 10,213,459 2,007,484 12,220,943
TROPHY CLUB MUD NO. 1 - WWTP TAX BOND CONST
BALANCE SHEET
APRIL 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
4
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
APRIL 2021
CASH IN BANK
CASH IN ESCROW
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
519
REVENUE BOND
ASSETS CONSTRUCTION
785,013
TOTAL ASSETS 785,013
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
46
703,322
785,013
TROPHY CLUB MUD NO. 1 - 16" WATERLINE REV BOND
BALANCE SHEET
APRIL 2021
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
FUND 520
16" 2019
ASSETS REVENUE BOND
CASH IN BANK 175,836
INVESTMENTS 3,892,754
ACCOUNTS RECEIVABLE
TOTAL ASSETS 4,068,590
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
(82,792)
4,068,590
4,068,590
TROPHY CLUB MUD NO. 1 - REVENUE BOND RESERVE
BALANCE SHEET
APRIL 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
528
REVENUE BOND
RESERVE
894,242
TOTAL ASSETS 894,242
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE 893,867
NET REVENUES / EXPENDITURES 375
TOTAL FUND BALANCE 894,242
TOTAL LIABILITIES AND FUND BALANCE 894,242
TROPHY CLUB MUD NO. 1 - I&S (DEBT SERVICE)
BALANCE SHEET
APRIL 2021
ASSETS
CASH IN BANK
INVESTMENTS
PREPAID EXPENSES
ADVALOREM PROPERTY TAXES RECEIVABLE
ACCOUNTS RECEIVABLE -OTHER
a
TROPHY CLUB
533
INTEREST &
SINKING DEBT
872,098
28,829
TOTAL ASSETS 900,927
LIABILITIES AND FUND BALANCE
LIABILITIES
DEFERRED REVENUE - AD VALOREM PROPERTY TAXES
ACCOUNTS AND OTHER PAYABLES
64,064
19,226
TOTAL LIABILITIES 83,290
FUND BALANCE
ASSIGNED FUND BALANCE
NET REVENUES / EXPENDITURES
(19,950)
837,587
TOTAL FUND BALANCE 817,637
TOTAL LIABILITIES AND FUND BALANCE 900,927
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S (WWTP)
BALANCE SHEET
APRIL 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
534
REVENUE BOND
I&S WWTP
307,972
TOTAL ASSETS 307,972
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
281,984
307,972
307,972
TROPHY CLUB MUD NO. 1 - SWIFT REVENUE BOND I&S
BALANCE SHEET
APRIL 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
535
NSII FTW SWIFT
REVENUE BOND
I&S
150,510
TOTAL ASSETS 150,510
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
144,885
150,510
150,510
TROPHY CLUB MUD NO. 1 - REVENUE BOND I&S
WATER & WASTEWATER SYSTEM 2019
BALANCE SHEET
APRIL 2021
ASSETS
CASH IN BANK
INVESTMENTS
ACCOUNTS RECEIVABLE
4
TROPHY CLUB
MUNICIPAL
UTILITY
DISTRICT
536
REVENUE BOND
SERIES 2019 I&S
129,735
TOTAL ASSETS 129,735
LIABILITIES AND FUND BALANCE
LIABILITIES
ACCOUNTS AND OTHER PAYABLES
TOTAL LIABILITIES
FUND BALANCE
ASSIGNED FUND BALANCE 531
NET REVENUES / EXPENDITURES 129,204
TOTAL FUND BALANCE 129,735
TOTAL LIABILITIES AND FUND BALANCE 129,735