HomeMy WebLinkAbout2017 Q2 Cash and Investment Report
Memorandum
To: Wally Bobkiewicz, City Manager
From: Martin Lyons, Asst. City Manager/CFO
Subject: 2nd Quarter 2017 - Cash and Investment Report
Date: July 6, 2017
Attached please find the Cash and Investment report as of June 30, 2017.
A comparison between the 2017 first quarter and second quarter investment report
indicates a decrease combined cash & investments of $13,691,306, from $69,864,273 to
$56,172,967. Cash and investment changes from the previous period are summarized
below:
As can be seen above, staff invested additional cash since the close of the first quarter.
As of March 31, 2017, ledger balances showing the highest percentage of total deposits
was held by First Bank and Trust at $19.8M or 35.2% of the total, PMA
Financial at approximately $26.1M, or 46.5%, followed by U.S. Bank at $8.7M or 15.5%,
and IMET at $1.5M or 2.7%. 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.
Cash balances are lower than in June 2016 due to the additional payroll that is included
in this report (three payrolls in June 2017 vs. three payrolls in July 2016). As noted in the
July 10, 2017 report to Council, 2017 revenues are also lower than expected which
reduces cash balances.
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.
6/30/2017 3/31/2017 Change
Cash
Investments
TOTAL
1
2
3
4
46
48
83
84
86
88
89
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.942 18,076 3,837,710 100 General
IL Funds MMA US Bank 0.942 70 14,875 175 General Assistance
IL Funds MMA US Bank 0.942 8,740 1,855,672 200 MFT
IL Funds MMA US Bank 0.942 3,066 650,869 205 E911
IL Funds MMA US Bank 0.942 1,727 366,577 250 Affordable Housing
IL Funds MMA US Bank 0.942 1 122 300 Washington National
IL Funds MMA US Bank 0.942 0 - 310 HH TIF
IL Funds MMA US Bank 0.942 1,548 328,581 320 DS
IL Funds MMA US Bank 0.942 0 42 330 Howard Ridge TIF
IL Funds MMA US Bank 0.942 47 10,046 335 West Evanston TIF
IL Funds MMA US Bank 0.942 5,733 1,217,190 415 Capital Improvements
IL Funds MMA US Bank 0.942 1,035 219,785 420 Special Assessment
IL Funds MMA US Bank 0.942 300 63,692 505 Parking
IL Funds MMA US Bank 0.942 753 159,930 510 Water
IL Funds MMA US Bank 0.942 24 5,022 515 Sewer
US BANK Total 41,119 8,730,114
Money Market Fund MMA IMET 0.700 481 137,491 300 Washington National
Money Market Fund MMA IMET 0.700 159 45,325 310 Howard Hartrey TIF
Money Market Fund MMA IMET 0.700 90 25,778 320 Debt Service
Money Market Fund MMA IMET 0.700 14 3,954 330 Howard Ridge TIF
Money Market Fund MMA IMET 0.700 51 14,498 335 West Evanston TIF
Money Market Fund MMA IMET 0.700 1,362 389,020 415 Capital Improvements
Money Market Fund MMA IMET 0.700 2,530 722,983 420 Special Assessment
Money Market Fund MMA IMET 0.700 22 6,303 505 Parking
Money Market Fund MMA IMET 0.700 626 178,925 510 Water
IMET Total 5,334.97 1,524,277
Money Market Fund MMA PMA 0.800 22,695 5,673,662 300 Washington National
Money Market Fund MMA PMA 0.800 0 - 310 HH TIF
Money Market Fund MMA PMA 0.800 7,504 1,876,007 320 Debt Service
Money Market Fund MMA PMA 0.800 1,984 496,039 335 West Evanston TIF
Money Market Fund MMA PMA 0.800 16,062 4,015,403 415 Capital Improvements
Money Market Fund MMA PMA 0.800 28,195 7,048,782 505 Parking
Money Market Fund MMA PMA 0.800 22,110 5,527,385 510 Water
Money Market Fund MMA PMA 0.800 5,992 1,497,883 515 Sewer
PMA Total 104,541 26,135,160
Grand Total 150,994 36,389,551
Cash
Total 1st Bank
Cash Cash 4,394,067 4,394,067 100 General
Cash Cash 646,099 646,099 175 General Assistance
Cash Cash 0 0 176 Health and Human Services
Cash Cash 583,333 583,333 180 Good Neighbor
Cash Cash 1,701,671 1,701,671 185 Library
Cash Cash 0 0 186 Library Debt Service
Cash Cash 116,139 116,139 195 Neighbrhd Stablztn
Cash Cash 0 0 205 E911
Cash Cash 0 0 210 SSD 4
Cash Cash 0 0 215 CDBG
Cash Cash 212,373 212,373 220 CD Loan
Cash Cash 169,915 169,915 235 Neighbrhd Improvemt
Cash Cash 0 0 240 Home
Cash Cash 1,059,563 1,059,563 250 Affordable Housing
Cash Cash 91,424 91,424 300 Washington National TIF
Cash Cash 0 0 305 SSD5
Cash Cash 0 0 310 Howard Hartrey
Cash Cash 3,743,256 3,743,256 320 Debt
Cash Cash 0 0 330 Howard Ridge
Cash Cash 0 0 335 West Evanston
Cash Cash 0 0 340 Dempster-Dodge-TIF
Cash Cash 0 0 345 Chicago-Main TIF
Cash Cash 79,138 79,138 350 Special Service Area (SSA) #6
Cash Cash 3,808,224 3,808,224 415 Capital Improvements
Cash Cash 2,839,105 2,839,105 420 Special Assess
Cash Cash 1,101,622 1,101,622 505 Parking
Cash Cash 190,034 190,034 510 Water
Cash Cash 3,251,515 3,251,515 515 Sewer
Cash Cash 0 0 520 Solid Waste
Cash Cash 154,787 154,787 600 Fleet
Cash Cash 1,259,970 1,259,970 601 Equipment Replacemt
Cash Cash 0 0 605 Insurance
25,402,236 25,402,236
Total Cash 25,402,236
Interfunds & negative cash (5,618,820)
Net Cash 19,783,416
Total Investments & Cash 56,172,967
CASH / INVESTMENT Investments Cash Total
GENERAL LEDGER Amount %Amount %Amount %
1ST Bank 19,783,416 100.00%19,783,416 35.22%
Chase - 0.00%- 0.00%
PMA 26,135,160 71.82%26,135,160 46.53%
IMET 1,524,277 4.19%1,524,277 2.71%
US Bank 8,730,114 23.99%8,730,114 15.54%
Total 36,389,551 100.00%19,783,416 100.00%56,172,967 100.00%
June 30, 2017
City of Evanston
Cash & Investment Summary by Type
June 30, 2017
Investment Investment Fiscal YTD Investment
Description Type Bank Rate Est. Income Amount Fund #Fund
IL Funds MMA US Bank 0.942 18,076 3,837,710 100 General
IL Funds MMA US Bank 0.942 70 14,875 175 General Assistance
IL Funds MMA US Bank 0.942 8,740 1,855,672 200 MFT
IL Funds MMA US Bank 0.942 3,066 650,869 205 E911
IL Funds MMA US Bank 0.942 1,727 366,577 250 Affordable Housing
IL Funds MMA US Bank 0.942 1 122 300 Washington National
IL Funds MMA US Bank 0.942 0 - 310 HH TIF
IL Funds MMA US Bank 0.942 1,548 328,581 320 DS
IL Funds MMA US Bank 0.942 0 42 330 Howard Ridge TIF
IL Funds MMA US Bank 0.942 47 10,046 335 West Evanston TIF
IL Funds MMA US Bank 0.942 5,733 1,217,190 415 Capital Improvements
IL Funds MMA US Bank 0.942 1,035 219,785 420 Special Assessment
IL Funds MMA US Bank 0.942 300 63,692 505 Parking
IL Funds MMA US Bank 0.942 753 159,930 510 Water
IL Funds MMA US Bank 0.942 24 5,022 515 Sewer
Money Market Fund MMA IMET 0.700 481 137,491 300 Washington National
Money Market Fund MMA IMET 0.700 159 45,325 310 Howard Hartrey TIF
Money Market Fund MMA IMET 0.700 90 25,778 320 Debt Service
Money Market Fund MMA IMET 0.700 14 3,954 330 Howard Ridge TIF
Money Market Fund MMA IMET 0.700 51 14,498 335 West Evanston TIF
Money Market Fund MMA IMET 0.700 1,362 389,020 415 Capital Improvements
Money Market Fund MMA IMET 0.700 2,530 722,983 505 Parking
Money Market Fund MMA IMET 0.700 22 6,303 420 Special Assessment
Money Market Fund MMA IMET 0.700 626 178,925 510 Water
Money Market Fund MMA PMA 0.800 22,695 5,673,662 300 Washington National
Money Market Fund MMA PMA 0.800 0 - 310 HH TIF
Money Market Fund MMA PMA 0.800 7,504 1,876,007 320 Debt Service
Money Market Fund MMA PMA 0.800 1,984 496,039 335 West Evanston TIF
Money Market Fund MMA PMA 0.800 16,062 4,015,403 415 Capital Improvements
Money Market Fund MMA PMA 0.800 28,195 7,048,782 505 Parking
Money Market Fund MMA PMA 0.800 22,110 5,527,385 510 Water
Money Market Fund MMA PMA 0.800 5,992 1,497,883 515 Sewer
150,994 36,389,551