HomeMy WebLinkAbout2016 Q3 Cash and Investment Report
Memorandum
To: Wally Bobkiewicz, City Manager
From: Martin Lyons, Asst. City Manager/CFO
Subject: FY2016 – 3rd Quarter - Cash and Investment Report
Date: November 16, 2016
Attached please find the Cash and Investment report as of September 30, 2016.
A comparison between the 2016 third quarter investment report and 2015 third quarter
indicates an increase in combined cash & investments of $13,940,331, from $71,642,533
to $85,582,864. Cash and investment changes from the previous period are summarized
below:
9/30/2015 9/30/2016 Change
Cash 33,307,231 44,784,035 11,476,804
Investments 38,335,302 40,798,829 2,463,527
TOTAL 71,642,533 85,582,864 13,940,331
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 September 30, 2016, ledger balances showing the highest percentage of total
deposits was held by First Bank and Trust at $43.7M or 51.1% of the total, PMA
Financial at approximately 26.1M, or 30.5%, followed by U.S. Bank at $13.2M or
15.4%. The increase in the total Cash and Investments was due to receipt of $14
million proceeds from bond issuance at the end of September. A portion of this
money has been allocated from First Bank and Trust to other institutions during
October to be 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.
City of Evanston
Cash & Investment Summary by Fund
September 30, 2016
Fund #Fund Cash Investments Interfund Total
100 General 1,142,777 8,113,724 185,793 9,442,294
175 General Assistance 768,962 14,805 - 783,768
176 Health and Human Services 56,650 - - 56,650
180 Good Neighbor 625,000 - - 625,000
185 Library 2,277,293 - - 2,277,293
186 Library Debt Service 843,912 - - 843,912
195 Neighborhood Stabilization 150,226 - - 150,226
200 MFT - 1,488,120 (182,417) 1,305,703
205 E911 - 647,680 (619,355) 28,325
210 SSD4 - - (111,600) (111,600)
215 CDBG - - (26,145) (26,145)
220 CD Loan 153,282 - - 153,282
225 Economic Dev.1,976,666 393,236 - 2,369,902
235 Neighborhood Improvement 169,915 - - 169,915
240 Home 99,049 - (3,377) 95,673
250 Affordable Housing 671,396 364,596 - 1,035,992
300 Washington National TIF 3,350,824 4,796,198 - 8,147,023
305 SSD5 796,039 - - 796,039
310 Howard Hartrey - 786,586 (594,586) 192,000
320 Debt Service 3,497,218 6,538,651 - 10,035,869
330 Howard Ridge 70,478 143,448 - 213,926
335 West Evanston - 518,685 (86,847) 431,838
345 Chicago Main-TIF 279,098 - - 279,098
350 Special Service Area (SSA) #6 221,813 - - 221,813
415 Capital Improvements 13,460,285 2,601,509 - 16,061,794
420 Special Assessment 2,835,889 224,901 - 3,060,789
505 Parking 4,301,970 8,811,923 - 13,113,893
510 Water 2,973,481 5,349,767 - 8,323,248
515 Sewer 3,229,835 4,998 - 3,234,833
520 Solid Waste - - (1,663,660) (1,663,660)
600 Fleet 223,673 - - 223,673
601 Equipment Replacement 1,946,791 - - 1,946,791
605 Insurance 1,763,705 - - 1,763,705
47,886,228 40,798,829 (3,102,193) 85,582,864
Includes negative cash balance reclassed to interfund liability.*
*
*
**
**
*
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.404 24,585 8,113,724 100 General
IL Funds MMA US Bank 0.404 45 14,805 175 General Assistance
IL Funds MMA US Bank 0.404 4,509 1,488,120 200 MFT
IL Funds MMA US Bank 0.404 1,962 647,680 205 E911
IL Funds MMA US Bank 0.404 1,192 393,236 225 Economic Development
IL Funds MMA US Bank 0.404 1,105 364,596 250 Affordable Housing
IL Funds MMA US Bank 0.404 0 121 300 Washington National
IL Funds MMA US Bank 0.404 991 327,056 310 HH TIF
IL Funds MMA US Bank 0.404 423 139,494 330 Howard Ridge TIF
IL Funds MMA US Bank 0.404 30 10,000 335 West Evanston TIF
IL Funds MMA US Bank 0.404 3,671 1,211,480 415 Capital Improvements
IL Funds MMA US Bank 0.404 662 218,598 420 Special Assessment
IL Funds MMA US Bank 0.404 192 63,394 505 Parking
IL Funds MMA US Bank 0.404 482 159,180 510 Water
IL Funds MMA US Bank 0.404 15 4,998 515 Sewer
US BANK Total 39,864 13,156,481
Money Market Fund MMA IMET 0.420 433 137,491 300 Washington National
Money Market Fund MMA IMET 0.420 335 106,397 310 Howard Hartrey TIF
Money Market Fund MMA IMET 0.420 81 25,778 320 Debt Service
Money Market Fund MMA IMET 0.420 12 3,954 330 Howard Ridge TIF
Money Market Fund MMA IMET 0.420 46 14,498 335 West Evanston TIF
Money Market Fund MMA IMET 0.420 1,225 389,020 415 Capital Improvements
Money Market Fund MMA IMET 0.420 2,269 720,365 420 Special Assessment
Money Market Fund MMA IMET 0.420 20 6,303 505 Parking
Money Market Fund MMA IMET 0.420 564 178,925 510 Water
IMET Total 4,985.60 1,582,731
Money Market Fund MMA PMA 0.400 13,976 4,658,587 300 Washington National
Money Market Fund MMA PMA 0.400 1,059 353,133 310 HH TIF
Money Market Fund MMA PMA 0.400 19,539 6,512,873 320 Debt Service
Money Market Fund MMA PMA 0.400 1,483 494,187 335 West Evanston TIF
Money Market Fund MMA PMA 0.400 3,003 1,001,009 415 Capital Improvements
Money Market Fund MMA PMA 0.400 24,084 8,028,164 505 Parking
Money Market Fund MMA PMA 0.400 15,035 5,011,663 510 Water
PMA Total 78,179 26,059,616
Grand Total 123,029 40,798,829
September 30, 2016
Cash Total Chase 1st Bank
Cash 1,142,777 121,462 1,021,315 100 General
Cash 768,962 768,962 175 General Assistance
Cash 56,650 56,650 176 Health and Human Services
Cash 625,000 625,000 180 Good Neighbor
Cash 2,277,293 2,277,293 185 Library
Cash 843,912 843,912 186 Library Debt Service
Cash 150,226 150,226 195 Neighbrhd Stablztn
Cash 0 0 205 E911
Cash 0 0 210 SSD 4
Cash 0 0 215 CDBG
Cash 153,282 153,282 220 CD Loan
Cash 1,976,666 1,976,666 225 Economic Dev.
Cash 169,915 169,915 235 Neighbrhd Improvemt
Cash 99,049 99,049 240 Home
Cash 671,396 671,396 250 Affordable Housing
Cash 3,350,824 3,350,824 300 Washington National TIF
Cash 796,039 796,039 305 SSD5
Cash 0 0 310 Howard Hartrey
Cash 3,497,218 3,497,218 320 Debt
Cash 70,478 70,478 330 Howard Ridge
Cash 0 0 335 West Evanston
Cash 279,098 279,098 345 Chicago-Main TIF
Cash 221,813 221,813 350 Special Service Area (SSA) #6
Cash 13,460,285 13,460,285 415 Capital Improvements
Cash 2,835,889 2,835,889 420 Special Assess
Cash 4,301,970 4,301,970 505 Parking
Cash 2,973,481 2,973,481 510 Water
Cash 3,229,835 969,264 2,260,571 515 Sewer
Cash 0 0 520 Solid Waste
Cash 223,673 223,673 600 Fleet
Cash 1,946,791 1,946,791 601 Equipment Replacemt
Cash 1,763,705 1,763,705 605 Insurance
47,886,228 1,090,726 46,795,503
47,886,228
(3,102,193)
44,784,036
85,582,864
CASH / INVESTMENT Investments Cash Total
GENERAL LEDGER Amount %Amount %Amount %
1ST Bank 43,693,310 97.56%43,693,310 51.05%
Chase 1,090,726 2.44%1,090,726 1.27%
PMA 26,059,616 63.87%26,059,616 30.45%
IMET 1,582,731 3.88%1,582,731 1.85%
US Bank 13,156,481 32.25%13,156,481 15.37%
Total 40,798,829 100.00%44,784,036 100.00%85,582,864 100.00%