Monthly Report MAY 2008
black>Yahoo! is not affiliated with the authors of this page or responsible for its content.
Monthly Report MAY 2008
Monthly Report
MAY 2008
CITY OF McALLEN
McALLEN PUBLIC UTILITIES
McALLEN HIDALGO-REYNOSA
INTERNATIONAL TOLL BRIDGE
CITY OF McALLEN
CITY OF McALLEN, TEXAS - RECONCILED BANK BALANCES
As Of May 31, 2008
POOL
TIME
BLENDED
GROSS *
BLENDED
BLENDED
BLENDED
FUNDS
CASH
APR/ROI
DEPOSITS
APR/ROI
INVESTMENTS
APR/ROI
TEX POOL
APR/ROI
TOTAL
APR/ROI
GENERAL
1,058,092
1.65%
30,572,788
3.97%
30,362,436
3.68%
1,312,692
2.28%
63,306,008
3.76%
% of Total
1.67%
48.29%
47.96%
2.07%
HOTEL OCCUPANCY
66,600
1.65%
-
-
-
-
4,567
2.28%
71,167
1.69%
% of Total
93.58%
-
-
6.42%
DEVELOP. CORP. OF MCALL
249,494
1.65%
15,100,000
3.92%
5,495,501
3.85%
515,215
2.28%
21,360,210
3.84%
% of Total
1.17%
70.69%
25.73%
2.41%
DEV CORP DEBT SERVICE
3,290
1.65%
-
-
-
-
4
2.28%
3,294
1.65%
% of Total
99.87%
-
-
0.13%
PARK LAND ZONE 1
50,475
1.65%
1,300,000
3.77%
-
-
17,970
2.28%
1,368,445
3.68%
% of Total
3.69%
95.00%
-
1.31%
PARK LAND ZONE 2
34,873
1.65%
900,000
3.93%
-
-
46,773
2.28%
981,647
3.77%
% of Total
3.55%
91.68%
-
4.76%
PARK LAND ZONE 3
40,797
1.65%
350,000
2.50%
-
-
69,486
2.28%
460,283
2.39%
% of Total
8.86%
76.04%
-
15.10%
DOWNTOWN SERV PARKING 283,932
1.65%
-
-
-
-
-
-
283,932
1.65%
% of Total
100.00%
-
-
-
DEBT SERVICE
56,629
1.65%
-
-
-
-
514,910
2.28%
571,539
2.22%
% of Total
9.91%
-
-
90.09%
CAPITAL PROJECTS
(107,376)
1.65%
16,450,000
3.59%
6,502,054
3.82%
338,076
2.28%
23,182,753
3.65%
% of Total
-0.46%
70.96%
28.05%
1.46%
TAX NOTE CONSTRUCTION
(35,701)
1.65%
700,000
4.46%
-
-
7,640
2.28%
671,939
4.58%
% of Total
-5.31%
104.18%
-
1.14%
INFORMATION TECHNOLOG
37,269
1.65%
800,000
3.64%
-
-
484,917
2.28%
1,322,186
3.08%
% of Total
2.82%
60.51%
-
36.68%
SANITATION
161,652
1.65%
750,000
4.00%
-
-
79,524
2.28%
991,176
3.48%
% of Total
16.31%
75.67%
-
8.02%
SANITATION DEPRECIATION
19,503
1.65%
3,700,000
3.86%
250,113
3.38%
389,149
2.28%
4,358,765
3.68%
% of Total
0.45%
84.89%
5.74%
8.93%
GOLF COURSE
116,128
1.65%
350,000
3.78%
-
-
102,531
2.28%
568,659
3.08%
% of Total
20.42%
61.55%
-
18.03%
GOLF COURSE-DEPRCTN
7,729
1.65%
-
-
-
-
113,803
2.28%
121,532
2.24%
% of Total
6.36%
-
-
93.64%
CIVIC CENTER
47,193
1.65%
100,000
2.50%
-
-
300
2.28%
147,492
2.23%
% of Total
32.00%
67.80%
-
0.20%
CONVENTION CENTER
4,052
1.65%
1,350,000
3.79%
-
-
49,383
2.28%
1,403,435
3.73%
% of Total
0.29%
96.19%
-
3.52%
AIRPORT
62,309
1.65%
700,000
2.72%
-
-
26,127
2.28%
788,437
2.62%
% of Total
7.90%
88.78%
-
3.31%
PFC AIRPORT
52,462
1.65%
4,100,000
3.78%
-
-
255,516
2.28%
4,407,978
3.67%
% of Total
1.19%
93.01%
-
5.80%
AIRPORT CIP
(18,570)
-
-
-
-
-
-
-
(18,570)
-
% of Total
-
-
-
-
TRANSIT SYSTEM
117,079
1.65%
-
-
-
-
762,965
2.28%
880,045
2.20%
% of Total
13.30%
-
-
86.70%
MCALLEN EXPRESS
335,206
1.65%
300,000
2.50%
-
-
-
-
635,206
2.05%
% of Total
52.77%
47.23%
-
-
GENERAL DEPRECIATION
39,579
1.65%
4,600,000
4.42%
999,747
3.64%
212,326
2.28%
5,851,651
4.19%
% of Total
0.68%
78.61%
17.08%
3.63%
HEALTH INSURANCE
139,904
1.65%
5,500,000
4.13%
-
-
274,531
2.28%
5,914,435
3.98%
% of Total
2.37%
92.99%
-
4.64%
RETIREES HEALTH INS
50,681
1.65%
-
-
-
-
-
-
50,681
1.65%
% of Total
100.00%
-
-
-
GEN INS & WORKMEN'S
(33,615)
1.65%
7,600,000
3.70%
2,486,143
3.95%
391,182
2.28%
10,443,710
3.71%
% of Total
-0.32%
72.77%
23.81%
3.75%
DEVELOPER'S
195,170
1.65%
2,800,000
4.81%
500,000
4.02%
2,605
2.28%
3,497,775
4.52%
% of Total
5.58%
80.05%
14.29%
0.07%
MISC. GRANTS
95,101
1.65%
-
-
-
-
-
-
95,101
1.65%
% of Total
100.00%
-
-
-
CDBG
(208)
-
-
-
-
-
-
-
(208)
-
% of Total
-
-
-
-
FLEET/MAT MGM'T
553,976
1.65%
-
-
-
-
-
-
553,976
1.65%
% of Total
100.00%
-
-
-
NEIGHBORHOOD ASSOC.
15,867
1.65%
-
-
-
-
-
-
15,867
1.65%
% of Total
100.00%
-
-
-
PAYROLL
801,058
1.65%
-
-
-
-
-
-
801,058
1.65%
% of Total
100.00%
-
-
-
FIREMEN'S PENSION (1)
405,532
1.65%
-
-
-
-
-
-
405,532
1.65%
% of Total
100.00%
-
-
-
(2)
4,906,162
1.65%
98,022,788
3.89%
46,595,993
3.74%
5,972,191
2.28%
155,497,134
3.71%
% of Total
3.16%
63.04%
29.97%
3.84%
TOTAL - WATER
326,019
1.65%
23,845,525
3.87%
5,036,942
4.00%
1,526,792
2.28%
30,735,279
TOTAL - SEWER
455,249
1.65%
37,878,404
3.86%
3,451,870
3.90%
2,308,281
2.28%
44,093,803
TOTAL - BRIDGE
433,408
1.65%
28,487,249
3.07%
0
0.00%
7,645,223
2.28%
36,565,880
GRAND TOTAL
6,120,838
1.65%
188,233,966
3.76%
55,084,805
3.77%
17,452,486
2.28%
266,892,096
3.62%
% of Total
2.29%
70.53%
20.64%
6.54%
100.00%
(4)
Percentage Invested
100.00%
* Does not include market value adjustment
(1) Excludes $1,018,104 in Manager Trust Cash.
(2) Both Demand and Time Deposits are covered by Depository Agreement Collateralization.
(3) Texpool Investments includes earned/accrued interest.
(4) Does not include Accrued Interest in the C.D. Investments in the amount of $4,915,634.
CITY OF McALLEN
BUDGET VS. ACTUAL EXPENDITURES
FOR THE MONTH AND Y.T.D. ENDING MAY 31, 2008
FUND
ADJUSTED
MONTHLY
Y.T.D.
% TO DATE
#
FUND NAME
BUDGET
EXPENSE
EXPENSE
EXPENSE
011
GENERAL
108,144,581
$
8,717,559
$
65,899,390
$
60.94%
100
HOTEL OCCUPANCY
3,745,135
321,390
2,627,833
70.17%
110
DEV. CORP. OF McALLEN
28,397,521
2,440,918
7,816,194
27.52%
112
DEV. CORP. DEBT SVC.
38,463
-
32,025
83.26%
121
PARK LAND ZONE #1
315,000
-
56,642
17.98%
122
PARK LAND ZONE #2
1,504,000
4,158
16,118
1.07%
123
PARK LAND ZONE #3
595,200
-
-
0.00%
132
CDBG
2,563,329
240,730
2,150,644