HomeMy WebLinkAbout2016 Q1 Cash and Investment Report
To: Wally Bobkiewicz, City Manager
From: Martin Lyons, Asst. City Manager/CFO
Subject: FY2016 – 1st Quarter - Cash and Investment Report
Date: June 13, 2016
Attached please find the Cash and Investment report as of March 31, 2016
A comparison between the 2016 first quarter investment report and 2015 first quarter
indicates a decrease in combined cash & investments of just $328,826, from
$75,822,560 down to $75,493,734. Cash and investment changes from the previous
period are summarized below:
While individual cash balances vary as noted on the attached table, this stability in
overall non-pension cash reserves will help the City respond to potential changes in the
State Budget Crisis..
As of March 31, 2016, ledger balances showing the highest percentage of total deposits
was held by First Bank and Trust at approximately32.33M, or 46.5% of the City’s
$75.5M in cash and investments followed by PMA Financial at $18.0M or 26% of the
total and U.S. Bank at $16.1M or 23.2%. 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 by phone at (847) 448.8082 or by e-mail at mlyons@cityofevanston.org.
3/31/2015 3/31/2016 Change
Cash 34,609,097 39,355,520 4,746,423
Investments 41,213,463 36,138,214 (5,075,249)
TOTAL 75,822,560 75,493,734 (328,826)
Memorandum
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
A B C D E F
City of Evanston
Cash & Investment Summary by Fund
March 31, 2016
Fund #Fund Cash Investments Interfund Total
100 General 5,704,599 3,123,590 (646,099) 8,182,090
175 General Assistance 383,521 14,780 (32,362) 365,939
176 Health and Human Services - 28,961 28,961
180 Good Neighbor 1,000,000 (125,000.01) 875,000
185 Library 4,188,916 (1,239,951) 2,948,965
186 Library Debt Service 60,554 - 60,554
195 Neighborhood Stabilization 204,774 (8,345) 196,429
200 MFT - 2,033,119 (477,833) 1,555,286
205 E911 - 646,414 (378,766) 267,648
210 SSD4 - (56,699) (56,699)
215 CDBG 75,011 (196,835) (121,824)
220 CD Loan 190,796 (5,716.98) 185,079
225 Economic Dev.2,174,279 392,466.97 (392,742) 2,174,004
235 Neighborhood Improvement 169,915 - 169,915
240 Home 8,825 (3,180) 5,645
250 Affordable Housing 716,530 363,883 17,640 1,098,053
300 Washington National TIF 4,337,710 4,788,749 (1,543,287.32) 7,583,172
305 SSD5 812,455 - 812,455
310 Howard Hartrey 1,051,334 785,457.40 (197,582) 1,639,210
320 Debt Service 280,703 6,527,127 (557,824) 6,250,006
330 Howard Ridge 124,783 143,208 11,865 279,856
335 West Evanston - 517,794 (73,347.38) 444,446
345 Chicago Main-TIF 303,876 303,876
415 Capital Improvements 4,534,450 2,033,159 1,778,270 8,345,879
420 Special Assessment 2,496,772 224,473 (60,057) 2,661,188
505 Parking 2,533,040 9,197,468 (469,309) 11,261,199
510 Water 1,487,165 5,341,535 (306,962) 6,521,738
515 Sewer 5,756,628 4,990 (3,304,244) 2,457,374
520 Solid Waste - - (1,195,379) (1,195,379)
600 Fleet - - 94,836 94,836
601 Equipment Replacement 758,884 - 496,359 1,255,243
605 Insurance - - 2,826,471 2,826,471
39,355,520 36,138,214 (6,017,118) 69,476,615
Includes negative cash balance reclassed to interfund liability.*
*
*
*
*
*
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
A B C D E F G H
City of Evanston
Cash & Investments Bank
Investment Investment Fiscal YTD Investment
Description Type Bank Rate Est. Income Amount Fund #Fund
IL Funds MMA US Bank 0.107 836 3,123,590 100 General
IL Funds MMA US Bank 0.107 4 14,780 175 General Assistance
IL Funds MMA US Bank 0.107 544 2,033,119 200 MFT
IL Funds MMA US Bank 0.107 173 646,414 205 E911
IL Funds MMA US Bank 0.107 105 392,467 225 Economic Development
IL Funds MMA US Bank 0.107 97 363,883 250 Affordable Housing
IL Funds MMA US Bank 0.107 0 121 300 Washington National
IL Funds MMA US Bank 0.107 87 326,492 310 HH TIF
IL Funds MMA US Bank 0.107 1,739 6,501,349 320 Debt Service
IL Funds MMA US Bank 0.107 37 139,254 330 Howard Ridge TIF
IL Funds MMA US Bank 0.107 135 503,295 335 West Evanston TIF
IL Funds MMA US Bank 0.107 440 1,644,138 415 Capital Improvements
IL Funds MMA US Bank 0.107 58 218,170 420 Special Assessment
IL Funds MMA US Bank 0.107 17 63,276 505 Parking
IL Funds MMA US Bank 0.107 43 158,904 510 Water
IL Funds MMA US Bank 0.107 0 - 511 Water BD & INT
IL Funds MMA US Bank 0.107 1 4,989 515 Sewer
US BANK Total 4,316 16,134,241
Money Market Fund MMA IMET 0.250 86 137,491 300 Washington National
Money Market Fund MMA IMET 0.250 66 106,397 310 Howard Hartrey TIF
Money Market Fund MMA IMET 0.250 16 25,778 320 Debt Service
Money Market Fund MMA IMET 0.250 2 3,954 330 Howard Ridge TIF
Money Market Fund MMA IMET 0.250 9 14,498 335 West Evanston TIF
Money Market Fund MMA IMET 0.250 243 389,020 415 Capital Improvements
Money Market Fund MMA IMET 0.250 4 6,303 420 Special Assessments
Money Market Fund MMA IMET 0.250 699 1,118,782 505 Parking
Money Market Fund MMA IMET 0.250 79 125,776 510 Water
Money Market Fund MMA IMET 0.250 33 53,150 511 Water BD & INT
IMET Total 33 1,981,149
Money Market Fund MMA PMA 0.150 3,006 8,015,411 505 Parking
Money Market Fund MMA PMA 0.150 1,876 5,003,706 510 Water
Money Market Fund MMA PMA 0.150 0 511 Water BD & INT
Money Market Fund MMA PMA 0.150 1,744 4,651,138 300 Washington National
Money Market Fund MMA PMA 0.150 132 352,569 310 Howard Hartrey TIF
PMA Total 6,759 18,022,824
Grand Total 11,108 36,138,214
Cash
Total Chase 1st Bank
Cash Cash 5,704,599 76,182 5,628,416 100 General
Cash Cash 383,521 383,521 175 General Assistance
Cash Cash 0 0 176 Health and Human Services
Cash Cash 1,000,000 1,000,000 180 Good Neighbor
Cash Cash 4,188,916 4,188,916 185 Library
Cash Cash 60,554 60,554 186 Library Debt Service
Cash Cash 204,774 204,774 195 Neighbrhd Stablztn
Cash Cash 0 0 205 E911
Cash Cash 0 0 210 SSD 4
Cash Cash 75,011 75,011 215 CDBG
Cash Cash 190,796 190,796 220 CD Loan
Cash Cash 2,174,279 2,174,279 225 Economic Dev.
Cash Cash 169,915 169,915 235 Neighbrhd Improvemt
Cash Cash 8,825 8,825 240 Home
Cash Cash 716,530 716,530 250 Affordable Housing
Cash Cash 4,337,710 4,337,710 300 Washington National TIF
Cash Cash 812,455 812,455 305 SSD5
Cash Cash 1,051,334 1,051,334 310 Howard Hartrey
Cash Cash 280,703 280,703 320 Debt
Cash Cash 124,783 124,783 330 Howard Ridge
Cash Cash 0 0 335 West Evanston
Cash Cash 303,876 303,876 345 Chicago-Main TIF
Cash Cash 4,534,450 4,534,450 415 Capital Improvements
Cash Cash 2,496,772 2,496,772 420 Special Assess
Cash Cash 2,533,040 2,533,040 505 Parking
Cash Cash 1,487,165 1,487,165 510 Water
Cash Cash 5,756,628 948,910 4,807,717 515 Sewer
Cash Cash 0 0 520 Solid Waste
Cash Cash 0 0 600 Fleet
Cash Cash 758,884 758,884 601 Equipment Replacemt
Cash Cash 0 0 605 Insurance
39,355,520 1,025,093 38,330,427
Total Cash 39,355,520
Interfunds & negative cash (6,017,118)
Net Cash 33,338,402
Total Investments & Cash 69,476,615
CASH / INVESTMENT Investments Cash Total
GENERAL LEDGER Amount %Amount %Amount %
1ST Bank 32,313,309 96.93%32,313,309 46.51%
Chase 1,025,093 3.07%1,025,093 1.48%
PMA 18,022,824 49.87%18,022,824 25.94%
IMET 1,981,149 5.48%1,981,149 2.85%
US Bank 16,134,241 44.65%16,134,241 23.22%
Total 36,138,214 100.00% 33,338,402 100.00% 69,476,615 100.00%
March 31, 2016