HomeMy WebLinkAbout2018 Q1 Cash and Investment Report
Memorandum
To: Wally Bobkiewicz, City Manager
From: Hitesh Desai, CFO/Treasurer
Subject: 1st Quarter 2018 - Cash and Investment Report
Date: May 8, 2018
Attached please find the Cash and Investment report as of March 31, 2018.
A comparison between the 2018 and 2017 first quarter investment reports indicate a
increase in combined cash & investments of $8,763,293 from $51,456,392
to $60,219,685. The increase was principally due to early property tax received. Cash and
investment changes from the previous period are summarized below:
As of March 31, 2018, ledger balances showing the highest percentage of total deposits
was held by First Bank and Trust at $32.7M or 54.34% of the total. PMA Financial is in
custody of money market funds at approximately $15.0M, or 24.99%, and Certificates of
Deposits at $5.0M or 8.25%. Illinois Funds was at $4.6M or 7.58% and IMET was at
$1.0M or 1.98%. The allocation of Cash and Investments 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 hdesai@cityofevanston.org.
3/31/2018 12/31/2017 Change
Cash 32,724,757 20,516,836 12,207,921
Investments 27,494,928 30,939,556 (3,444,628)
TOTAL 60,219,685 51,456,392 8,763,293
Attachment 2: 1st Quarter Investment Report
City of Evanston
Cash & Investments Bank
Investment Investment Investment
Description Type Bank Rate Amount Fund #Fund
IL Funds MMA US Bank 1.611 1,721,767 100 General
IL Funds MMA US Bank 1.611 15,006 175 General Assistance
IL Funds MMA US Bank 1.611 984,553 200 MFT
IL Funds MMA US Bank 1.611 657,107 205 E911
IL Funds MMA US Bank 1.611 370,319 250 Affordable Housing
IL Funds MMA US Bank 1.611 - 300 Washington National
IL Funds MMA US Bank 1.611 331,647 320 DS
IL Funds MMA US Bank 1.611 - 330 Howard Ridge TIF
IL Funds MMA US Bank 1.611 10,135 335 West Evanston TIF
IL Funds MMA US Bank 1.611 21,484 415 Capital Improvements
IL Funds MMA US Bank 1.611 224,244 420 Special Assessment
IL Funds MMA US Bank 1.611 64,251 505 Parking
IL Funds MMA US Bank 1.611 166,407 510 Water
IL Funds MMA US Bank 1.611 1 515 Sewer
US BANK Total 4,566,922
Money Market Fund MMA IMET 124,583 300 Washington National
Money Market Fund MMA IMET 13,369 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
IMET Total 914,197
Money Market Fund MMA PMA-SDA 1.150 1,508,724 200 MFT
Money Market Fund MMA PMA-SDA 1.150 220,286 300 Washington National
Money Market Fund MMA PMA-SDA 1.150 1,898,466 320 Debt Service
Money Market Fund MMA PMA-SDA 1.150 499,791 335 West Evanston TIF
Money Market Fund MMA PMA-SDA 1.150 4,263,454 415 Capital Improvements
Money Market Fund MMA PMA-SDA 1.150 2,087,209 505 Parking
Money Market Fund MMA PMA-SDA 1.150 3,307,922 510 Water
Money Market Fund MMA PMA-SDA 1.150 1,263,208 515 Sewer
PMA-SDA Total 15,049,059
Money Market Fund MMA PMA-CD 1.397-1.4 992,800 300 Washington National
Money Market Fund MMA PMA-CD 1.176-1.4 2,981,092 415 Capital Improvements
Money Market Fund MMA PMA-CD 1.2-1.501 494,600 505 Parking
Money Market Fund MMA PMA-CD 1.060-1.250 248,400 510 Water
Money Market Fund MMA PMA-CD 1.060-1.250 248,400 515 Sewer
PMA-CD Total 4,965,292
Money Market Fund MMA PMA US. T. BILL 1.120 1,999,458 415 Debt Service
PMA US.T. BILL Total 1,999,458
Grand Total 27,494,928
1st Bank
Cash Cash 12,177,474 General
Cash Cash 971,857 General Assistance
Cash Cash 45,994 Health and Human Services
Cash Cash 918,628 Good Neighbor
Cash Cash 3,967,418 Library
Cash Cash 145,649 Library Debt Service
Cash Cash 308,399 Library Capital Improvement FD
Cash Cash 91,158 Neighbrhd Stablztn
Cash Cash 0 E911
Cash Cash 0 SSD 4
Cash Cash 30,590 CDBG
Cash Cash 213,680 CD Loan
Cash Cash 170,183 Neighbrhd Improvemt
Cash Cash 8,082 Home
Cash Cash 1,130,619 Affordable Housing
Cash Cash 5,360,426 Washington National TIF
Cash Cash 4,023,636 Debt
Cash Cash 434,109 Howard Ridge
Cash Cash 0 West Evanston
Cash Cash 20,395 Dempster-Dodge-TIF
Cash Cash 89,508 Chicago-Main TIF
Cash Cash 115,445 Special Service Area (SSA) #6
Cash Cash 0 Capital Improvements
Cash Cash 540,861 Crown Construction
Cash Cash 2,765,397 Special Assess
Cash Cash 3,133,117 Parking
Cash Cash 653,953 Water
Cash Cash 3,550,194 Sewer
Cash Cash 0 Solid Waste
Cash Cash 0 Fleet
Cash Cash 586,673 Equipment Replacemt
Cash Cash 0 Insurance
41,453,444
Total Cash 41,453,444
Interfunds & negative cash (8,728,687)
Net Cash 32,724,757
Total Investments & Cash 60,219,685
CASH / INVESTMENT Investments Cash Total
GENERAL LEDGER Amount %Amount Amount %
1ST Bank 32,724,757 32,724,757 54.34%
PMA-SDA 15,049,059 54.73%15,049,059 24.99%
CD 4,965,292 18.06%4,965,292 8.25%
US. T. BILL 1,999,458 7.27%1,999,458 3.32%
IMET 914,197 3.32%914,197 1.52%
IL Funds 4,566,922 16.61%4,566,922 7.58%
Total 27,494,928 100.00% 32,724,757 60,219,685 100.00%
March 31, 2018
Attachment 2: 1st Quarter Investment Report
City of Evanston
Cash & Investment Summary by Type
March 31, 2018
Investment Investment Fiscal YTD Investment
Description Type Bank Rate Est. Income Amount Fund #Fund
IL Funds MMA US Bank 1.611 6,934 1,721,767 100 General
IL Funds MMA US Bank 1.611 60 15,006 175 General Assistance
IL Funds MMA US Bank 1.611 3,965 984,553 200 MFT
IL Funds MMA US Bank 1.611 2,646 657,107 205 E911
IL Funds MMA US Bank 1.611 1,491 370,319 250 Affordable Housing
IL Funds MMA US Bank 1.611 0 - 300 Washington National
IL Funds MMA US Bank 1.611 1,336 331,647 320 DS
IL Funds MMA US Bank 1.611 0 - 330 Howard Ridge TIF
IL Funds MMA US Bank 1.611 41 10,135 335 West Evanston TIF
IL Funds MMA US Bank 1.611 87 21,484 415 Capital Improvements
IL Funds MMA US Bank 1.611 903 224,244 420 Special Assessment
IL Funds MMA US Bank 1.611 259 64,251 505 Parking
IL Funds MMA US Bank 1.611 670 166,407 510 Water
IL Funds MMA US Bank 1.611 0 1 515 Sewer
Money Market Fund MMA IMET 0 124,583 300 Washington National
Money Market Fund MMA IMET 0 13,369 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 PMA-SDA 1.150 4,338 1,508,724 200 MFT
Money Market Fund MMA PMA-SDA 1.150 633 220,286 300 Washington National
Money Market Fund MMA PMA-SDA 1.150 5,458 1,898,466 320 Debt Service
Money Market Fund MMA PMA-SDA 1.150 1,437 499,791 335 West Evanston TIF
Money Market Fund MMA PMA-SDA 1.150 12,257 4,263,454 415 Capital Improvements
Money Market Fund MMA PMA-SDA 1.150 6,001 2,087,209 505 Parking
Money Market Fund MMA PMA-SDA 1.150 9,510 3,307,922 510 Water
Money Market Fund MMA PMA-SDA 1.150 3,632 1,263,208 515 Sewer
Money Market Fund MMA CD 1.397-1.4 992,800 300 Washington National
Money Market Fund MMA CD 1.176-1.4 2,981,092 415 Capital Improvements
Money Market Fund MMA CD 1.2-1.501 494,600 505 Parking
Money Market Fund MMA CD 1.060-1.250 248,400 510 Water
Money Market Fund MMA CD 1.060-1.250 248,400 515 Sewer
Money Market Fund MMA US. T. BILL 1.120 5,598 1,999,458 415 Capital Improvements
67,258 27,494,928
Attachment 2: 1st Quarter Investment Report