HomeMy WebLinkAbout2015 Q1 Cash and Investment Report�---- Memorandum
cny or
Evanston
To: Wally Bobkiewicz, City Manager
Martin Lyons, Assistant City Manager/CFO
From: David Meimers, Accounting Manager/Controller
Subject: FY2015 — 1 st Quarter End Investment Report
Date: April 16, 2015
Attached please find the investment report as of March 31, 2015.
A comparison between the 2014 fourth quarter investment report and 2015 first quarter
indicates an increase in combined cash and investments of $12,564,765 from
$63,257,795 to $75,822,560. Cash and investment changes from the previous period
are summarized below:
03/31 /2015 12/31 /2014 Change
-Cash $ 34,609,097 $ 21,868,707 i $ 12,740,390
;Investments $ 41,213.463 $ 41,389,088 $ (175,625)
Total $ 75,822,560 ' $ 63,257,795 $ 12,564,765 '!
The net increase of $12.6M in cash and investments was primarily due to Property Tax
revenues received from Cook County. The City received the first installment of the 2014
Property Tax levy in the amount of $14.8M. This includes $6.2M for the General Fund,
$2.5M for the Library and $6.1 M for Debt Service principally offset by Capital Outlay and
IEPA loan payments.
As of March 31, 2015, ledger balances showing the highest percentage of total deposits
was held by First Bank and Trust at approximately $33.6M, or 44% of the City's $75.8M
in cash and investments followed by US Bank with $29AM or 39% of the total. The
remaining funds were invested with PMA or Chase Bank and IMET. This is in
compliance with the City's investment policy to ensure no financial institution should
have greater than 50% of the City's total deposits.
If you have any questions on this report or would like to discuss in greater detail, please
contact me at (847) 866-2905 or at dmeimers(a.citvofevanston.orq.
Note: The City is in the process of closing its account with IMET and moving all remaining funds due to concerns over IMET's
investment practices. As of March 31, 2015 the City has reduced its holdings to $3.8M or 4.96% of the Cities Cash holdings.
A f B
C
D
E
F
1
City of Evanston
2
Cash & Investment Summary by Fund
3
March 31, 2015
4�
�5�
6 I
Fund # I Fund
Cash
Investments
Interfund
Total
8 +
100 General
5,853,313
3,173,654 1
1,759,816 1
10,786,783
9
175 General Assistance
89,935
14,766 1
(346,036)
(241,335)
101
185 1 Library
3,478,957
1
(1,466,235)1
2,012,722
111
186 1 Library Debt Service 1
290,517
1
1
290,517
1 121
195 1 Neighborhood Stabilization 1
217,644
1
(27,444)1
190,200
13
200 MFT
2,803215
(277,667)1
2,525,548
1 141
205 1 E911
45,283
645:772
(31,972)1
659,083
151
210 1 SSD4
(15,623)1
(15,623)
161
215 1 CDBG
357,438
(460,688) 1
(103,250)
171
220 1 CD Loan
137,780
23,838 1
161,617
181
225 1 Economic Dev. 1
2,824,228
392,065
(342,565)1
2,873,728
191
235 1 Neighborhood Improvement
149,915
149,915
201
240 1 Home
26,061
1
(12,283)
13,778
211
250 1 Affordable Housing
505,314
363,518 1
18,173
887,004
221
300 1 Washington National TIF
3,558,762
5,114,893 1
(1,103,156)1
7,570,498
231
305 1 SSD5
629,079
1
1
629,079
241
310 1 Howard Hartrey
4,039,741 1
(1,038,912)1
3,000,829
1 25 i
315 1 Southwest TIF
896,123
1
(2,458) 1
893,665
1 26 1
320 1 Debt Service 1
6,230,796 1
90,098 1
771,348 1
7,092,242
1 27 1
330 1 Howard Ridge 1
181,617 1
152,591 1
(5,053)1
329,155
281
335 1 West Evanston 1
1
552,205 1
(59,395)'
492,811
291
415 1 Capital Improvements 1
893,586 1
6,515,739 1
(82,648)1
7,326,677
30
420 1 Special Assessment 1
2,354,279 1
239,315 1
3,721 1
2,597,315
31
505 1 Parking 1
4,608,430 1
10,089,353 1
(738,853)1
13,958,930
321
510 1 Water
1,548,063 1
7,021,554 1
(834,279)1
7,735,339
331
515 1 Sewer
7,179,936 1
4,985 1
(3,563,585)
3,621,336
341
520 1 Solid Waste
I
(1,395,014)T
(1,395,014)
351
600 1 Fleet
1
(469,989)1
(469,989)
361
601 1 Equipment Replacement 1
901,919 1
1
524,176 1
1,426,095
371
605 1 Insurance I
1
1
822, 9041
822,904
381 1 I 42,958,975 I 41,213,463 1 (8,349,878)1 75,822,560
39
1 40 1
1 41 i * Includes negative cash balance reclassed to interfund liability.
A I B C D
1 City of Evanston
2 Cash & Investments Bank
1 3 IMarch 31, 2015
41 1
51 Investment Investment I
1 6 1 Description 1 Type I Bank 1 Rat
171 1
1 8 IIL Funds I
19 IIL Funds I
110 IIL Funds
111 IIL Funds I
112 IIL Funds
113 IIL Funds
14 IIL Funds I
15 IIL Funds I
1 16 IIL Funds I
1 17 IIL Funds I
118 IIL Funds I
119 IIL Funds
1 20 IIL Funds
121 IIL Funds I
122 IIL Funds I
123 IIL Funds
124 IIL Funds I
1251 I
1261
127 IMoney Market Fund I
128 IMoney Market Fund I
129 IMoney Market Fund I
130 IMoney Market Fund I
131 IMoney Market Fund I
132 IMoney Market Fund
133 IMoney Market Fund I
134 IMoney Market Fund I
135 IMoney Market Fund I
37 Money Market Fund
1381
139 IMoney Market Fund
1401
1421
1431 I
1 44 1
145 (Cash
1461_
1 47 Wash ICas
1481Cash ICas
149ICash ICas
1501Cash ICas
1511Cash (Cash
152 Wash (Cash
153ICash (Cash
154ICash (Cash
1551Cash (Cash
15616ash Cash
157 ]Cash (Cash
1581Cash (Cash
1591Cash (Cash
1601Cash (Cash
1611,Cash (Cash
1621Cash (Cash
163 Wash (Cash
1641Cash (Cash
1651Cash (Cash
1661Cash ]Cash
1671Cash (Cash
1681Cash (Cash
1691Cash ICash
1701 1
1711 I
1721
1731
1741
1751
1761
I77ICASH/INVESTMEN
BALANCES BY
MMA
I I
IUS Bank I
MMA
IUS Bank I
MMA
IUS Bank I
MMA
IUS Bank I
MMA
IUS Bank I
MMA
IUS Bank I
MMA
IUS Bank
MMA
IUS Bank
MMA
IUS Bank
MMA
IUS Bank I
MMA
IUS Bank I
MMA
IUS Bank I
MMA
IUS Bank I
MMA
IUS Bank I
MMA
IUS Bank I
MMA
Bank I
MMA
_IUS
IUS Bank
IUS BANK Total
I
Fiscal YTD
e I Est. Income
I I
0.0171 1351
0.0171 1 1
0.0171 1191
0.0171 27 1
0.0171 17 1
0.0171 151
0.0171 197 1
0.0171 156 1
0.0171 1
0.0171 61
0.0171 21 1
0.0171 240 1
0.017 9
0.0171 41
0.0171 180 1
0.0171 861
0.0171 1
1,2511
MMA
h
h
h
h
I
IIMET
0.2201
257
MMA
IIMET
0.2201
1991
MMA
IIMET
0.2201
491
MMA
IIMET 1
0.2201
71
MMA
IIMET 1
0.2201
271
MMA
IIMET 1
0.2201
481
MMA
IIMET
0.2201
12I
MMA
11MET I
0.2201
6191
MMA
IIMET I
0.2201
2951
MMA
IIMET
0.2201
1251
IIMET Total I
1 I
1
2,070 1
MMA
IPMA
I
0.1501
2,959I
IPMA Total 1
I I
1
I
2,959 1
I
(Grand Total I
I I
I
I
I
I
6,282
I
I
I
I
Total 1
I
Chase I
5,853,313 I
932,479 1
I
89.935
I
3,478,9571
I I
290,5171
I I
217,644 1
I
45.283 I
I
357,438 I
I
I
137,780 1
I
I
2,824,2281
I
I I
149,9151
I
26,061 1
I
505,314 1
I
3,558,762 1
I
I
629,079 I
896,123 ]
I
6,230,7961
I 1
181,617 I
893,586
2,354,2791
I
4,608,4301
I I
1.548,063 I
1
7,179,936 I
33,064 I
I
901,919 I
I I
42,958,975 I
965,543
]Total Cash I
I
I
Ilnterfunds & negative
cash 1
INet Cash
ITotalInvestments&
I
Cash
I
I
Investments
Cash
78 BANK
Amount
1 79 11ST Bank
I
1801Chase
I
181IPMA
1 8,003,0251
18211MET
I 3,764,4501
183 IUS Bank
I 29.445,988
1841 Total
1 41,213,4631
% I
Amount
%
I
33,643,554
97.21 %
965,543
2.79 %
19.42 %
1
9.13%
1
71.45%
100.00% I
34,609,0971
100.00%
G
I
Investment
Amount I
Fund # Fund
I
3,173,654 1
I I
100 1 General
14,766 1
175 1 General Assistance
2,803,215 1
200 MFT
645.772 1
205 E911 I
392,065
225 Economic Development 1
I
363,518 I
250 1 Affordable Housing 1
4,646,808
300 1 Washington National I
3,677,515 1
310 HH TIF
1,348 1
320 Debt Service j
I
139,130 1
3301 Howard Ridge TIF 1
502,846 1
335 1 West Evanston TIF 1
5,642,051 1
415 1 Capital Improvements I
217,858 1
420 1 Special Assessment
961,450 1
505 1 Parking
4,240.5261
I1jj
510 1 Water
2.018.485 1
511 1 Water BD & INT 1
4,9841
515 1 Sewer 1
29,445,9881
I
468,085
300 1 Washington National 1
362,227 1
310 Howard Hartrey TIF 1
88,750 1
320 Debt Service I
13,462 1
330 1 Howard Ridge TIF
49,359 I
335 West Evanston TIF
873,688 I
415 Capital Improvements
21,458
420 1 Special Assessments
1,124,878 I
505 1 Parking 1
536,053 I
510 1 Water 1
226,490 1
511 1 Water BD & INT 1
3,764,450 I
I I
8,003,025 1
I I
505 Parking
13,003,025
I
I
41,213,463
I
I
I
�
I
1st Bank I
I
1
I
4,920,835 1
100 1 General 1
89,935 1
175 General Assistance
3,478,957 1
185 I Library
290,517
186 1 Library Debt Service
217,644
195 1 Neighbrhd Stablzln
45,283
205 1 E911
357,438 1
215 1 CDBG I
137:780 1
220 CD Loan 1
2,824228
225 Economic Dev. 1
I
149,9151
235 1 Neighbrhd Improveml 1
26,061 1
240 1 Home 1
505,314 1
250 I Affordable Housing 1
3,558,762 1
300 I Washington National TIF
629,079 1
305 1 SSD5
896,123 1
315 1 Southwest TIF
6,230,796
320 I Debt
181,617 I
330 I Howard Ridge I
893,586 1
415 1 Capital Improvements I
2.354,279 I
420 I Special Assess 1
4608,430
505 I Parking 1
1:548,063
510 1 Water
7,146,872
515 Sewer
901,919 1
605 1 Insurance
41,993,432 I
1 I
I
42.958,975 I
I I
I
(8,349,878)I
1
34,609,097 1
I I
75,822,560
Total
Amount
%
33,643,554 44.37 %
965,543 I
1.27 %
8,003,0251 10.55%
1
3.764.450 I 4.96 % 1
29.445,988 138.84 % 1
75,822,560 1 100.00% 1 1