HomeMy WebLinkAbout2015 Q2 Cash and Investment Reportcity or
Memorandum
Evanston,
To: Wally Bobkiewicz, City Manager
Martin Lyons, Asst. City Manager/CFO
From: David Meimers, Accounting Manager/Controller
Subject: FY2015 — 2nd Quarter End Investment Report
Date: August 10, 2015
Attached please find the investment report as of June 30, 2015.
A comparison between the 2015 first quarter investment report and 2015 second
quarter indicates a decrease in combined cash & investments of $10,239,609 from
$75,822,560 to $65,582,951. Cash and investment changes from the previous period
are summarized below:
6/30/2015 3/31/2015 Change
- --- - - -
Cas h $ 28, 862,177 $ 34,609,097 $ (5,746,920)
Investments 36,720,774 41,213,463 (4,492,689)
Total $ 65,582,951 $ 75,822,560 $ (10,239,609)
The net decrease of $10.2M in cash and investments was primarily due to second
quarter debt service IEPA Loan repayments of $3.2M, General Obligation debt service
payments of $2.9M, Insurance payments and capital outlay resulting in a net decrease
of $10.2M.
As of June 30, 2015, ledger balances showing the highest percentage of total deposits
was held by First Bank and Trust at approximately $27.9M, or 43% of the City's $75.8M
in cash and investments followed by US Bank with $25.OM or 38% of the total. The
remaining funds were invested with PMA or Chase Bank and a remaining liquidating
trust balance with 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 @ (847) 866-2905 or at dmeimers@cityofevanston.org.
A B I
C 1
D
E
F
1
City of Evanston
2
Cash & Investment Summary by Fund
June 30, 2015
4
5
6
Fund # I Fund
Cash I
Investments
Interfund
Total
1
�7
8
100 General 1
5,182,987
967,900 1
1,350,997 1
7,501,885
9
175 General Assistance 1
58,971
14,767 1
(502,196)I
(428,458)
10
176 Health and Human Services 1
508,343
- 1
(294,931)1
213,411
11
185 Library 1
1,302,537 1
-
(492,285)1
810,252
12
186 Library Debt Service
250,396
-
(40,402)I
209,994
13
195 Neighborhood Stabilization
177,392
-
(5,704)I
171,689
14
200 MFT
- 1
2,548,411
(69,417)1
2,478,994
15
205 E911
79,457 1
645,809
(98385)
626,880
16
210 1 SSD4
-
-
(175:646)
(175,646)
17
215 1 CDBG
-
-
(305,781)
(305,781)
18
220 1 CD Loan
217,966
-
35
218,001
19
225 1 Economic Dev. 1
2,782,711 1
392,087 I
(486,665)1
2,688,133
201
235 1 Neighborhood Improvement
169,915
-
- 1
169,915
21
240 1 Home
-
-
(10,704)"'
(10,704)
122
250 Affordable Housing
517,106 I
363,538
(2,070)
878,574
1 231
300 Washington National TIF
1,787,675 1
5,110,733
(259,986)
6,638,423
1 241
305 1 SSD5
634,173
-
(21,075)
613,098
251
310 1 Howard Hartrey
-
4,036,528
(1,884,280)'
2,152,248
261
315 1 Southwest TIF
893,665
-
- 1
893,665
271
320 1 Debt Service 1
4,808,187
89,260
853,683
5,751,129
1 281
330 1 Howard Ridge
-
152:472
(131,661 (
20,811
1 291
335 1 West Evanston
-
551768
(72,621)
479,147
301
415 1 Capital Improvements
1,869,023
4,503,179
35,717
6,407,919
311
420 1 Special Assessment
2,280,340
239,123
2,322
2,521,785
321
505 I Parking
4,058,573
10,083,962
(29,295)1
14,113,241
331
510 1 Water
1,597,888
7,016,251 I
(1,077,316)1
7,536,824
341
515 1 Sewer
3,510,999
4,985
(1,085,069)
2,430,915
351
520 1 Solid Waste
-
-
(1,526,526)'
(1,526,526)
361
600 1 Fleet
-
-
(387,435)
(387,435)
371
601 1 Equipment Replacement
1,437,327
-
120,952
1,558,279
381
605I Insurance
-
- 1
1,332,2901
1,332,290
391 I 34,125,629 1 36,720,774 1 (5,263,452)1 65,582,951
1401
141 I _I
1 42 1 * Includes negative cash balance reclassed to interfund liability.
A
I B
C
1)E
F
G H
1 City of Evanston
I
Cash & Investments Bank
_2
3 June 30, 2015
4
5 Investment
Investment
I
Fiscal YTD I
Investment
I
6 Description
Type
I Bank I
Rate
Est. Income I
Amount I
Fund # Fund
7
1
1
1
8 IL Funds
MMA
IUS Bank 1
0.0341
94 1
551,400 1
100 1 General
9 IL Funds
MMA
IUS Bank 1
0.0341
3 1
14.767
175 1 General Assistance
10 IL Funds
I MMA
_ _
IUS Bank 1
0.0341
504 I
2,964,911 I
200 1 MFT
11 IL Funds
I MMA
IUS Bank I
0.0341
110 1
645,809 1
205 1 E911
12 IL Funds
I MMA
I US Bank 1
0.0341
67 1
392.087 1
225 1 Economic Development
13 IL Funds
MMA
IUS Bank I
0.0341
62 1
363.638 1
250 1 Affordable Housing
14 IL Funds
MMA
IUS Bank 1
0.0341
790
4.647.122 I
300 I Washington National
15 IL Funds
I MMA
IUS Bank 1
0.0341
625
3.677,764 I
310 I HH TIF
16 IL Funds
I MMA
IUS Bank 1
0.0341
0 I
1,348 1
320 1 Debt Service
17 IL Funds
I MMA
I US Bank 1
0.0341
24
139.139 1
330 1 Howard Ridge TIF
18 IL Funds
MMA
_
IUS Bank 1
0.0341
85 1
502,880 1
335 1 West Evanston TIF
19 IIL Funds
I MMA
IUS Bank 1
0.0341
619 1
3.642.430 1
415 1 Capital Improvements
2011L Funds
I MMA
IUS Bank 1
0,0341
37 1
217,870 I
420 1 Special Assessment
21 IIL Funds
I MMA
IUS Bank 1
0.0341
163 1
961.515
505 1 Parking
22 IIL Funds
I MMA
I US Bank 1
0.0341
721 1
4.240.813 1
510 1 Water
2311L Funds
I MMA
IUS Bank 1
0.0341
343 1
2.018,622 1
511 1 Water BD & INT
24 IIL Funds
I MMA
IUS Bank 1
0.034
1 1
4.985 1
515 1 Sewer
251
I
US BANK Total
1
4,248 1
24,987,000 1
1
261
I
I
-- -1
1
27IMonev Market Fund
I MMA
IIMET
0.2501I
580 1
463.611 1
300 1 Washington National
281money Market Fund
I MMA
IIMET
0.2501
448 I
358,764 I
310 1 Howard Hartrey TIF
29IMoney Market Fund
I MMA
IIMET
0.2501
110 I
87.912 1
320 1 Debt Service
30 IMonev, Market Fund
I MMA
IIMET
0.2501
17 1
13,333 1
330 1 Howard Ridge TIF
31 imonev Market Fund
I MMA
IIMET
0.2501
61 1
48,888 1
335 1 West Evanston TIF
321Money Market Fund
I MMA
IIMET
0.2501
1.076 1
860,749 1
415 1 Capital Improvements
331Money Markel Fund
I MMA
IIMET I
0.2501
27 1
21,253 1
420 1 Special Assessments
341Money Market Fund
I MMA
IIMET
I
0.2501
1,396 1
1,116.429 1
505 1 Parking
35IMonev Market Fund
I MMA
IIMET
0.2501
665 1
532.028 1
510 1 Water
361Monev Market Fund
I MMA
IIMET 1
0.2501
281 1
224.788 1
511 1 Water BD & INT
371
I
I IMET Total 1
1
4,660 I
3,727,755 I
381
I
1 1
1
I
I
39 1 Money Market Fund
I MMA
IPMA 1
0.1501
2,9591
8,006,0181
5051 Parking
401
1
IPMA Total 1
1
2,959 1
8,006,018 1
I
411
1
I 1
1
1
1I
421
I
(Grand Total I
11,867
36,720,774
431
1
1
I
441
I
451Cash
1
1 1
1
461
1
1
Total
Chase
1st Bank
47ICash
ICash
I
5.182.987 I
41,989 I
5,140.996
100 I General
481Cash
ICash
I
58.971 1
58.971
175 I General Assistance
491Cash
ICash
I
508.343 1
I
508.343 1
176 1 Health and Human Servia
501Cash
(Cash
I
1.302.537
I
1.302,537 1
185 1 Library
51 ICash
ICash
I
250,396 I
250.396 1
186 1 Library Debt Service
52ICash
ICash
I
177,392
177.392 I
195 Nelphbrhd Stablzln
63Wash
ICash
I I
79,4571
79.4571
205 E911
I
54ICash
ICash
I
I
- 1
210 1 SSD4
551Cash
ICash
I
I
I
- 1
215 1 CDBG
56 Wash
(Cash
1 1
217,966 1
1
217.966 1
220 1 CD Loan
571Cash
ICash
1 I
2,782,711
2,782.711 1
225 1 Economic Day.
581Cash
ICash
1 I
169,915
I
169,915 1
235 1 Netghbrhd ImprOvemt
591Cash
ICash
I
I
I
-
240 1 Home
60ICash
ICash
I
517,106 1
517.106 I
250 1 Affordable Housing
61 ICash
ICash
I
1,787,675 1
1
1,787,675 1
300 1 Washington National TIF
62ICash
(Cash
I I
634.173
634,173 1
305 1 SSD5
63ICash
(Cash
I I
I
I
- 1
310 1 Howard Hartrey
641Cash
ICash
1
893,665 1
1
893,665 1
315 1 Southwest TIF
651Cash
ICash
1 1
4,808,187 1
1
4.808.187 1
320 1 Debt
66ICash
ICash
I
- I
I
- 1
330 1 Howard Ridge
671Cash
(Cash
I I
I
335 I WesiEvanston
68ICash
ICash
1
1,869,023 1
1
1,869,023 I
415 I Capital Improvements
691Cash
ICash
1
2,280,340 1
1
2,280,340 1
420 1 Special Assess
701Cash
ICash
1 I
4,058,573 1
I
4,058,573 1
505 1 Parking
71 (Cash
ICash
1 I
1,597.888 1
I
1,597,888 1
510 1 Water
72ICash
ICash
I I
3.510,999 1
938.243 1
2,572.755 1
515 I Sewer
73ICash
ICash
I
I
1
520 1 Solid Waste
74ICash
ICash
1
600 1 Fleet
751Cash
ICash
I
1,437,327
I
1.437,327 1
601 1 EquipmentReplaceml
761Cash
(Cash
I
I
I
605 I Insurance
771
34,125,629 I
980,233
33,145,396
781
I
1
1
/91
(Total Cash
I
34,125,629
-
I
I Interfunds & negative
cash I
I
80
(5,263.4521
811
I
Net Cash 1
J
28,862,177
821
I
(Total Investments
& Cash
65.582,951
831
841CASH / INVESTMENT1 Investments
Cash
Total
1
851 GENERAL LEDGER
I Amount
1 % 1
Amount 1
%
Amount I
% 1
8611ST Bank
1
27,881,944
96.60%
27,881,944 1 42.51% 1
871Chase
i
980,233
3.40% 1
980,2331
1.49% 1
881PMA
8006.018
21.80% 1
I
I
8.006,0181 12.21% 1
8911MET
3:727,755
1 10.15% I
1
3,727,7551
5.68% 1
901US Bank
24,987,000
1 68.05% I
24,987.000 1 38.10% 1
911 Total
I 36.720,774
1 100.00%
28,862.177
100.00% 1
65,582,951 1 100.00%
1