HomeMy WebLinkAbout2017 Q1 Cash and Investment Report Attachment 1: First Quarter Investment Report
Memorandum
To: Wally Bobkiewicz, City Manager
From: Martin Lyons, Asst. City Manager/CFO
Subject: 1st Quarter 2017 - Cash and Investment Report
Date: May 5, 2017
``
Attached please find the Cash and Investment report as of March 31, 2017.
A comparison between the 2017 first quarter and 2016 fourth quarter investment report
indicates an increase in combined cash & investments of $9,460,891, from $60,403,382
to $69,864,273. 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, 2017, ledger balances showing the highest percentage of total deposits
was held by First Bank and Trust at $34.9M or 50.0% of the total, PMA
Financial at approximately $25.1M, or 35.9%, followed by U.S. Bank at $8.3M or 11.8%.
The net increase of $9.5M in cash and investments was primarily due to property tax
collection. 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 mlyons@cityofevanston.org.
3/31/2017 12/31/2016 Change
Cash 34,930,970 26,985,840 7,945,130
Investments 34,933,303 33,417,542 1,515,761
TOTAL 69,864,273 60,403,382 9,460,891
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
97
98
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.769 6,690 3,480,091 100 General
IL Funds MMA US Bank 0.769 29 14,846 175 General Assistance
IL Funds MMA US Bank 0.769 3,353 1,744,261 200 MFT
IL Funds MMA US Bank 0.769 1,249 649,571 205 E911
IL Funds MMA US Bank 0.769 0 - 225 Economic Development
IL Funds MMA US Bank 0.769 703 365,914 250 Affordable Housing
IL Funds MMA US Bank 0.769 0 121 300 Washington National
IL Funds MMA US Bank 0.769 630 327,929 310 HH TIF
IL Funds MMA US Bank 0.769 0 41 330 Howard Ridge TIF
IL Funds MMA US Bank 0.769 19 10,027 335 West Evanston TIF
IL Funds MMA US Bank 0.769 2,335 1,214,776 415 Capital Improvements
IL Funds MMA US Bank 0.769 422 219,388 420 Special Assessment
IL Funds MMA US Bank 0.769 122 63,566 505 Parking
IL Funds MMA US Bank 0.769 307 159,613 510 Water
IL Funds MMA US Bank 0.769 10 5,012 515 Sewer
US BANK Total 15,871 8,255,156
Money Market Fund MMA IMET 0.580 199 137,491 300 Washington National
Money Market Fund MMA IMET 0.580 154 106,397 310 Howard Hartrey TIF
Money Market Fund MMA IMET 0.580 37 25,778 320 Debt Service
Money Market Fund MMA IMET 0.580 6 3,954 330 Howard Ridge TIF
Money Market Fund MMA IMET 0.580 21 14,498 335 West Evanston TIF
Money Market Fund MMA IMET 0.580 564 389,020 415 Capital Improvements
Money Market Fund MMA IMET 0.580 1,047 721,878 420 Special Assessment
Money Market Fund MMA IMET 0.580 9 6,303 505 Parking
Money Market Fund MMA IMET 0.580 259 178,925 510 Water
IMET Total 2,297.15 1,584,244
Money Market Fund MMA PMA 0.800 11,329 5,664,433 300 Washington National
Money Market Fund MMA PMA 0.800 708 353,880 310 HH TIF
Money Market Fund MMA PMA 0.800 3,038 1,519,076 320 Debt Service
Money Market Fund MMA PMA 0.800 990 495,232 335 West Evanston TIF
Money Market Fund MMA PMA 0.800 8,017 4,008,619 415 Capital Improvements
Money Market Fund MMA PMA 0.800 14,074 7,036,872 505 Parking
Money Market Fund MMA PMA 0.800 11,037 5,518,692 510 Water
Money Market Fund MMA PMA 0.800 994 497,100 515 Sewer
PMA Total 50,188 25,093,902
Grand Total 68,355 34,933,303
Cash
Total 1st Bank
Cash Cash 5,881,819 5,881,819 100 General
Cash Cash 908,127 908,127 175 General Assistance
Cash Cash 213,998 213,998 176 Health and Human Services
Cash Cash 1,000,000 1,000,000 180 Good Neighbor
Cash Cash 3,903,413 3,903,413 185 Library
Cash Cash 369,692 369,692 186 Library Debt Service
Cash Cash 137,353 137,353 195 Neighbrhd Stablztn
Cash Cash 0 0 205 E911
Cash Cash 0 0 210 SSD 4
Cash Cash 218,199 218,199 215 CDBG
Cash Cash 211,029 211,029 220 CD Loan
Cash Cash 0 0 225 Economic Dev.
Cash Cash 169,915 169,915 235 Neighbrhd Improvemt
Cash Cash 0 0 240 Home
Cash Cash 1,046,227 1,046,227 250 Affordable Housing
Cash Cash 2,712,948 2,712,948 300 Washington National TIF
Cash Cash 0 0 305 SSD5
Cash Cash 0 0 310 Howard Hartrey
Cash Cash 5,224,632 5,224,632 320 Debt
Cash Cash 242,584 242,584 330 Howard Ridge
Cash Cash 0 0 335 West Evanston
Cash Cash 0 0 340 Dempster-Dodge-TIF
Cash Cash 94,986 94,986 345 Chicago-Main TIF
Cash Cash 194,650 194,650 350 Special Service Area (SSA) #6
Cash Cash 5,916,214 5,916,214 415 Capital Improvements
Cash Cash 2,908,379 2,908,379 420 Special Assess
Cash Cash 485,304 485,304 505 Parking
Cash Cash 3,617,120 3,617,120 510 Water
Cash Cash 4,235,113 4,235,113 515 Sewer
Cash Cash 0 0 520 Solid Waste
Cash Cash 125,705 125,705 600 Fleet
Cash Cash 1,467,406 1,467,406 601 Equipment Replacemt
Cash Cash 0 0 605 Insurance
41,284,814 41,284,814
Total Cash 41,284,814
Interfunds & negative cash (6,353,844)
Net Cash 34,930,970
Total Investments & Cash 69,864,273
CASH / INVESTMENT Investments Cash Total
GENERAL LEDGER Amount %Amount %Amount %
1ST Bank 34,930,970 100.00%34,930,970 50.00%
Chase - 0.00%- 0.00%
PMA 25,093,902 71.83%25,093,902 35.92%
IMET 1,584,244 4.54%1,584,244 2.27%
US Bank 8,255,156 23.63%8,255,156 11.82%
Total 34,933,303 100.00%34,930,970 100.00%69,864,273 100.00%
March 31, 2017
City of Evanston
Cash & Investment Summary by Type
March 31, 2017
Investment Investment Fiscal YTD Investment
Description Type Bank Rate Est. Income Amount Fund #Fund
IL Funds MMA US Bank 0.769 6,690 3,480,091 100 General
IL Funds MMA US Bank 0.769 29 14,846 175 General Assistance
IL Funds MMA US Bank 0.769 3,353 1,744,261 200 MFT
IL Funds MMA US Bank 0.769 1,249 649,571 205 E911
IL Funds MMA US Bank 0.769 0 - 225 Economic Development
IL Funds MMA US Bank 0.769 703 365,914 250 Affordable Housing
IL Funds MMA US Bank 0.769 0 121 300 Washington National
IL Funds MMA US Bank 0.769 630 327,929 310 HH TIF
IL Funds MMA US Bank 0.769 0 41 330 Howard Ridge TIF
IL Funds MMA US Bank 0.769 19 10,027 335 West Evanston TIF
IL Funds MMA US Bank 0.769 2,335 1,214,776 415 Capital Improvements
IL Funds MMA US Bank 0.769 422 219,388 420 Special Assessment
IL Funds MMA US Bank 0.769 122 63,566 505 Parking
IL Funds MMA US Bank 0.769 307 159,613 510 Water
IL Funds MMA US Bank 0.769 10 5,012 515 Sewer
Money Market Fund MMA IMET 0.580 199 137,491 300 Washington National
Money Market Fund MMA IMET 0.580 154 106,397 310 Howard Hartrey TIF
Money Market Fund MMA IMET 0.580 37 25,778 320 Debt Service
Money Market Fund MMA IMET 0.580 6 3,954 330 Howard Ridge TIF
Money Market Fund MMA IMET 0.580 21 14,498 335 West Evanston TIF
Money Market Fund MMA IMET 0.580 564 389,020 415 Capital Improvements
Money Market Fund MMA IMET 0.580 1,047 721,878 505 Parking
Money Market Fund MMA IMET 0.580 9 6,303 420 Special Assessment
Money Market Fund MMA IMET 0.580 259 178,925 510 Water
Money Market Fund MMA PMA 0.800 11,329 5,664,433 300 Washington National
Money Market Fund MMA PMA 0.800 708 353,880 310 HH TIF
Money Market Fund MMA PMA 0.800 3,038 1,519,076 320 Debt Service
Money Market Fund MMA PMA 0.800 990 495,232 335 West Evanston TIF
Money Market Fund MMA PMA 0.800 8,017 4,008,619 415 Capital Improvements
Money Market Fund MMA PMA 0.800 14,074 7,036,872 505 Parking
Money Market Fund MMA PMA 0.800 11,037 5,518,692 510 Water
Money Market Fund MMA PMA 0.800 994 497,100 515 Sewer
68,355 34,933,303