HomeMy WebLinkAbout2018 Q3 Cash and Investment Report
Memorandum
To: Wally Bobkiewicz, City Manager
From: Hitesh Desai, CFO/ Treasurer
Subject: 3rd Quarter 2018 - Cash and Investment Report
Date: October 19, 2018
Attached please find the Cash and Investment report as of September 30, 2018.
A comparison between the second quarter and third quarter of 2018 investment reports
indicate an increase in combined cash & investments of $51,566,470 from $47,281,686 to
$98,848,156. Cash and investment changes from the previous period are summarized below:
The above table reflects an increase of over $51M in cash and investments. This is
mainly because of the Series 2018 General Obligation Bonds issued during the month of
August. The City also added three financial institutions during the third quarter in an
effort to diversify the investments to explore increased investment revenues. The
financial institutions included were Fifth Third, Wintrust and MB Financial. As of
September 30, 2018, ledger balances showing the highest percentage of total deposit
was held by First Bank and Trust at $29.5M or 29.9% of the total. PMA Financial has
money market funds at approximately $14.1M, or 14.2% and Certificates of Deposits at
$1.5M or 1.5%. Wintrust held $13M or 13.2% while Fifth Third held $12.7M or 12.9%.
Illinois Funds was at $17.3M or 17.5% and IMET was at $9.0M or 9.2%. Staff will
continue to monitor the allocation of cash and investments to ensure compliance with the
City’s investment policy that no financial institution should have greater than 50% of the
City’s total cash and investments.
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 hdesai@cityofevanston.org.
9/30/2018 6/30/2018 Change
Cash 29,522,377 17,414,042 12,108,335
Investments 69,325,779 29,867,644 39,458,135
TOTAL 98,848,156 47,281,686 51,566,470
1
2
3
4
5
7
34
44
54
55
56
57
58
59
60
61
62
66
A B C D E F G H
City of Evanston
Cash & Investments Bank
Investment Investment Investment
Description Type Bank Rate Amount Fund #Fund
IL Funds MMA US Bank 2.17 1,871,252 100 General
IL Funds MMA US Bank 2.17 15,147 175 General Assistance
IL Funds MMA US Bank 2.17 505,937 200 MFT
IL Funds MMA US Bank 2.17 664,596 205 E911
IL Funds MMA US Bank 2.17 374,540 250 Affordable Housing
IL Funds MMA US Bank 2.17 5,375,003 320 DS
IL Funds MMA US Bank 2.17 10,237 335 West Evanston TIF
IL Funds MMA US Bank 2.17 5,030,066 415 Capital Improvements
IL Funds MMA US Bank 2.17 226,800 420 Special Assessment
IL Funds MMA US Bank 2.17 3,093,013 505 Parking
IL Funds MMA US Bank 2.17 171,569 510 Water
IL Funds MMA US Bank 2.17 1 515 Sewer
US BANK Total 17,338,162
Money Market Fund MMA IMET 124,583 300 Washington National
Money Market Fund MMA IMET 119,766 320 Debt Service
Money Market Fund MMA IMET 3,583 330 Howard Ridge TIF
Money Market Fund MMA IMET 13,137 335 West Evanston TIF
Money Market Fund MMA IMET 352,499 415 Capital Improvements
Money Market Fund MMA IMET 239,187 505 Special Assessment
Money Market Fund MMA IMET 5,711 420 Parking
Money Market Fund MMA IMET 162,127 510 Water
Money Market Fund MMA IMET 1.930 3,007,581 320 Debt Service
Money Market Fund MMA IMET 1.930 5,012,634 415 Capital Improvements
IMET Total 9,040,809
Money Market Fund MMA PMA-SDA 2.000 926,627 200 MFT
Money Market Fund MMA PMA-SDA 2.000 2,238,156 300 Washington National
Money Market Fund MMA PMA-SDA 2.000 904,851 320 Debt Service
Money Market Fund MMA PMA-SDA 2.000 504,590 335 West Evanston TIF
Money Market Fund MMA PMA-SDA 2.000 3,778,239 415 Capital Improvements
Money Market Fund MMA PMA-SDA 2.000 2,609,100 505 Parking
Money Market Fund MMA PMA-SDA 2.000 2,088,974 510 Water
Money Market Fund MMA PMA-SDA 2.000 1,026,750 515 Sewer
PMA-SDA Total 14,077,286
Money Market Fund MMA PMA-CD 2.241 247,200 200 MFT
Money Market Fund MMA PMA-CD 2.174 247,300 415 Capital Improvements
Money Market Fund MMA PMA-CD 1.801-1.811 495,400 510 Water
Money Market Fund MMA PMA-CD 1.821-1.843 495,400 515 Sewer
PMA-CD Total 1,485,300
Money Market Fund MMA PMA-Municipal 2.381 356,088 200 MFT
Money Market Fund MMA PMA-Municipal 2.701 286,044 415 Capital Improvements
PMA -MUNICIPAL Total 642,131
Money Market Fund MMA FIFTH THIRD 1.860 491,549 416 RobertCrown
Money Market Fund MMA FIFTH THIRD-US.T 12,216,706 416 RobertCrown
FITHTHIRD Total 12,708,255
Money Market Fund MMA WINTRUST 2.210 1,005,092 420 Special Assessment
Money Market Fund MMA WINTRUST 2.210 12,026,951 416 RobertCrown
WINTRUST Total 13,032,043
Money Market Fund MMA MB FINANCIAL 2.150 1,001,794 510 Water
MB FINANCIAL Total 1,001,794
Grand Total 69,325,779
September 30, 2018
68
100
101
105
106
107
109
111
112
114
115
116
117
118
119
120
121
122
123
124
126
A B C D E F G H
Cash
1st Bank
Cash Cash 8,646,772 100 General
Cash Cash 851,108 175 General Assistance
Cash Cash 0 176 Health and Human Services
Cash Cash 253,816 180 Good Neighbor
Cash Cash 92,774 195 Neighbrhd Stablztn
Cash Cash 0 205 E911
Cash Cash 0 210 SSD 4
Cash Cash 0 215 CDBG
Cash Cash 16,592 220 CD Loan
Cash Cash 236,378 235 Neighbrhd Improvemt
Cash Cash 170,703 240 Home
Cash Cash 13,140 250 Affordable Housing
Cash Cash 1,044,810 300 Washington National TIF
Cash Cash 3,321,832 320 Debt
Cash Cash 2,244,580 330 Howard Ridge
Cash Cash 2,799,618 335 West Evanston
Cash Cash 100,153 340 Dempster-Dodge-TIF
Cash Cash 55,298 345 Chicago-Main TIF
Cash Cash 171,475 350 Special Service Area (SSA) #6
Cash Cash 115,933 415 Capital Improvements
Cash Cash 704,193 416 Crown Construction
Cash Cash 0 420 Special Assess
Cash Cash 1,467,882 505 Parking
Cash Cash 1,200,175 510 Water
Cash Cash 5,417,631 515 Sewer
Cash Cash 1,744,895 520 Solid Waste
Cash Cash 0 600 Fleet
Cash Cash 0 601 Equipment Replacemt
Cash Cash 851,293 605 Insurance
CITY 31,521,048
Cash Cash 3,174,339 185 Library
Cash Cash 274,674 186 Library Debt Service
Cash Cash 1,177,112 187 Library Capital Improvement FD
Library 4,626,126
Total Cash 36,147,174
Interfunds & negative cash (6,624,797)
Net Cash 29,522,377
Total Investments & Cash 98,848,156
CASH / INVESTMENT Investments Cash Total
GENERAL LEDGER
BALANCES BY BANK Amount %Amount %Amount %
1ST Bank-City 24,902,628.31 84.35%24,902,628 25.19%
1ST Bank-Library 4,619,748.66 15.65%4,619,749 4.67%
IL Funds 17,338,162 25.01%17,338,162 17.54%
IMET 9,040,809 13.04%9,040,809 9.15%
PMA-SDA 14,077,286 20.31%14,077,286 14.24%
CD 1,485,300 2.14%1,485,300 1.50%
PMA-Municipal 642,131 0.93%642,131 0.65%
FIFTH THIRD 12,708,255 18.33%12,708,255 12.86%
WINTRUST 13,032,043 18.80%13,032,043 13.18%
MB FINANCIAL 1,001,794 1.45%1,001,794 1.01%
Total 69,325,779 100.00%29,522,377 100.00%98,848,156 100.00%
City of Evanston
Cash & Investment Summary by Type
September 30, 2018
Investment Investment Fiscal YTD Investment
Description Type Bank Rate Est. Income Amount Fund #Fund
IL Funds MMA US Bank 2.17 30,455 1,871,252 100 General
IL Funds MMA US Bank 2.17 247 15,147 175 General Assistance
IL Funds MMA US Bank 2.17 3,430 505,937 200 MFT
IL Funds MMA US Bank 2.17 10,816 664,596 205 E911
IL Funds MMA US Bank 2.17 6,096 374,540 250 Affordable Housing
IL Funds MMA US Bank 2.17 87,478 5,375,003 320 DS
IL Funds MMA US Bank 2.17 167 10,237 335 West Evanston TIF
IL Funds MMA US Bank 2.17 81,864 5,030,066 415 Capital Improvements
IL Funds MMA US Bank 2.17 3,691 226,800 420 Special Assessment
IL Funds MMA US Bank 2.17 50,339 3,093,013 505 Parking
IL Funds MMA US Bank 2.17 2,792 171,569 510 Water
IL Funds MMA US Bank 2.17 0 1 515 Sewer
Money Market Fund MMA IMET 0 124,583 300 Washington National
Money Market Fund MMA IMET 0 119,766 320 Debt Service
Money Market Fund MMA IMET 0 3,583 330 Howard Ridge TIF
Money Market Fund MMA IMET 0 13,137 335 West Evanston TIF
Money Market Fund MMA IMET 0 352,499 415 Capital Improvements
Money Market Fund MMA IMET 0 239,187 505 Special Assessment
Money Market Fund MMA IMET 0 5,711 420 Parking
Money Market Fund MMA IMET 0 162,127 510 Water
Money Market Fund MMA IMET 1.930 43,535 3,007,581 320 Debt Service
Money Market Fund MMA IMET 1.930 72,558 5,012,634 415 Capital Improvements
Money Market Fund MMA PMA 2.000 13,899 926,627 200 MFT
Money Market Fund MMA PMA 2.000 33,572 2,238,156 300 Washington National
Money Market Fund MMA PMA 2.000 13,573 904,851 320 Debt Service
Money Market Fund MMA PMA 2.000 7,569 504,590 335 West Evanston TIF
Money Market Fund MMA PMA 2.000 56,674 3,778,239 415 Capital Improvements
Money Market Fund MMA PMA 2.000 39,136 2,609,100 505 Parking
Money Market Fund MMA PMA 2.000 31,335 2,088,974 510 Water
Money Market Fund MMA PMA 2.000 15,401 1,026,750 515 Sewer
Money Market Fund CD PMA 2.241 4,155 247,200 200 MFT
Money Market Fund CD PMA 2.174 4,032 247,300 415 Capital Improvements
Money Market Fund CD PMA 1.801-1.811 495,400 510 Water
Money Market Fund CD PMA 1.821-1.843 495,400 515 Sewer
Money Market Fund Municipal PMA 2.381 6,359 356,088 200 MFT
Money Market Fund Municipal PMA 2.701 5,795 286,044 415 Capital Improvements
Money Market Fund MMA FIFTH THIRD 1.860 6,857 491,549 416 RobertCrown
Money Market Fund MMA FIRTH THIRD-US.T 12,216,706 416 RobertCrown
Money Market Fund MMA Wintrust 2.210 16,659 1,005,092 420 Special Assessment
Money Market Fund MMA Wintrust 2.210 199,347 12,026,951 416 RobertCrown
Money Market Fund MMA MB FINANCIAL 2.150 16,154 1,001,794 510 Water
863,984 69,325,779