The URL can be used to link to this page

Home My WebLink About2018 Q2 Cash and Investment ReportAttachment 1C—Treasurer’s Report for Second Quarter Memorandum To: Wally Bobkiewicz, City Manager From: Hitesh Desai, CFO/ Treasurer Ashley King, Budget and Finance Manager Subject: 2nd Quarter 2018 - Cash and Investment Report Date: July 20, 2018 Attached please find the Cash and Investment report as of June 30, 2018. A comparison between the first quarter and second quarter of 2018 investment reports indicate a decrease in combined cash & investments of $12,937,999 from $60,219,685 to $47,281,686. The decrease was principally due to the use 2017 GO Bond proceeds to pay for various capital projects. Cash and investment changes from the previous period are summarized below: As of June 30, 2018, ledger balances showing the highest percentage of total deposits was held by First Bank and Trust at $17.4M or 36.8% of the total followed closely by PMA Financial at 17.1M or 36.2%. PMA investments include money market funds of $10.4M, US Treasury Bill of $3M and Certificates of Deposits of $3.7M. Illinois Funds was at $11.7M or 24.8% and IMET was at $1.0M or 2.2%. Staff will continue to review the allocation of Cash and Investments to ensure compliance with the City’s investment policy of no greater than 50% of the city’s total cash and investments with one financial institution. 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. 6/30/2018 3/31/2018 Change Cash 17,414,042 32,724,757 (15,310,715) Investments 29,867,644 27,494,928 2,372,716 TOTAL 47,281,686 60,219,685 (12,937,999) Attachment 1C—Treasurer’s Report for Second Quarter Fund #Fund Cash Investments Interfund Total 100 General 9,568,773 192,724 (755,481) 9,006,016 175 General Assistance 737,016 15,072 (42,404) 709,685 176 Health and Human Services 78,496 - 91,632 170,129 180 Good Neighbor 585,731 - (82,658) 503,072 185 Library 2,172,927 - (590,026) 1,582,901 186 Library Debt Service 106,988 - - 106,988 187 Library Capital Improvement FD 301,565 - - 301,565 195 Neighborhood Stabilization 100,649 - (3,428) 97,220 200 MFT - 2,156,407 (204,833) 1,951,575 205 E911 - 661,121 (578,504) *82,617 210 SSD4 - - (131,317) *(131,317) 215 CDBG - - (177,845) *(177,845) 220 CD Loan 206,834 - 2,640 209,473 235 Neighborhood Improvement 170,265 - 153 170,418 240 Home - - (5,332) *(5,332) 250 Affordable Housing 1,124,869 372,581 (7,716) 1,489,734 300 Washington National TIF 2,994,946 2,350,115 (592,253) 4,752,808 320 Debt Service - 6,367,953 (1,414,607) *4,953,345 330 Howard Ridge - 3,583 (422,565) *(418,982) 335 West Evanston - 525,107 (56,005) *469,102 340 Dempster-Dodge-TIF 19,363 - - 19,363 345 Chicago Main-TIF 91,472 - - 91,472 350 Special Service Area (SSA) #6 12,458 - - 12,458 415 Capital Improvements 1,837,598 4,666,450 945,149 *7,449,198 416 Crown Construction 13,135 - (493,444) (480,309) 420 Special Assessment 2,648,819 231,325 (45,154) 2,834,990 505 Parking 736,813 5,904,906 123,978 6,765,698 510 Water 24,258 4,902,776 308,712 5,235,746 515 Sewer 2,068,536 1,517,524 (938,826) 2,647,234 520 Solid Waste - - (1,269,704) *(1,269,704) 600 Fleet - - (437,848) *(437,848) 601 Equipment Replacement 785,063 - 111,718 896,781 605 Insurance - - (2,306,562) *(2,306,562) 26,386,575 29,867,644 (8,972,533) 47,281,686 Includes negative cash balance reclassed to interfund liability. City of Evanston Cash & Investment Summary by Fund June 30, 2018 * Attachment 1C—Treasurer’s Report for Second Quarter City of Evanston Cash & Investments Bank Investment Investment Investment Description Type Bank Rate Amount Fund #Fund IL Funds MMA US Bank 1.964 192,035 100 General IL Funds MMA US Bank 1.964 15,072 175 General Assistance IL Funds MMA US Bank 1.964 641,998 200 MFT IL Funds MMA US Bank 1.964 661,483 205 E911 IL Funds MMA US Bank 1.964 372,785 250 Affordable Housing IL Funds MMA US Bank 1.964 - 300 Washington National IL Funds MMA US Bank 1.964 5,348,369 320 DS IL Funds MMA US Bank 1.964 - 330 Howard Ridge TIF IL Funds MMA US Bank 1.964 10,187 335 West Evanston TIF IL Funds MMA US Bank 1.964 21,614 415 Capital Improvements IL Funds MMA US Bank 1.964 225,737 420 Special Assessment IL Funds MMA US Bank 1.964 3,073,663 505 Parking IL Funds MMA US Bank 1.964 1,170,191 510 Water IL Funds MMA US Bank 1.964 1 515 Sewer US BANK Total 11,733,134 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 IMET Total 1,020,594 Money Market Fund MMA PMA-SDA 1.150 1,267,209 200 MFT Money Market Fund MMA PMA-SDA 1.150 230,888 300 Washington National Money Market Fund MMA PMA-SDA 1.150 899,818 320 Debt Service Money Market Fund MMA PMA-SDA 1.150 501,783 335 West Evanston TIF Money Market Fund MMA PMA-SDA 1.150 3,298,938 415 Capital Improvements Money Market Fund MMA PMA-SDA 1.150 94,672 505 Parking Money Market Fund MMA PMA-SDA 1.150 3,075,057 510 Water Money Market Fund MMA PMA-SDA 1.150 1,022,124 515 Sewer PMA-SDA Total 10,390,488 Money Market Fund MMA PMA-CD 2.241 247,200 200 MFT Money Market Fund MMA PMA-CD 1.91-1.92 995,200 300 Washington National Money Market Fund MMA PMA-CD 1.948-2.174 993,400 415 Capital Improvements Money Market Fund MMA PMA-CD 1.94-2 497,500 505 Parking 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 3,724,100 Money Market Fund MMA PMA US. T. BILL 1.849 999,444 300 Washington National Money Market Fund MMA PMA US. T. BILL 1.849 1,999,884 505 Parking PMA US.T. BILL Total 2,999,329 Grand Total 29,867,645 June 30, 2018 Attachment 1C—Treasurer’s Report for Second Quarter Cash 1st Bank Cash Cash 9,568,773 100 General Cash Cash 737,016 175 General Assistance Cash Cash 78,496 176 Health and Human Services Cash Cash 585,731 180 Good Neighbor Cash Cash 2,172,927 185 Library Cash Cash 106,988 186 Library Debt Service Cash Cash 301,565 187 Library Capital Improvement FD Cash Cash 100,649 195 Neighbrhd Stablztn Cash Cash 0 205 E911 Cash Cash 0 210 SSD 4 Cash Cash 0 215 CDBG Cash Cash 206,834 220 CD Loan Cash Cash 170,265 235 Neighbrhd Improvemt Cash Cash 0 240 Home Cash Cash 1,124,869 250 Affordable Housing Cash Cash 2,994,946 300 Washington National TIF Cash Cash 0 320 Debt Cash Cash 0 330 Howard Ridge Cash Cash 0 335 West Evanston Cash Cash 19,363 340 Dempster-Dodge-TIF Cash Cash 91,472 345 Chicago-Main TIF Cash Cash 12,458 350 Special Service Area (SSA) #6 Cash Cash 1,837,598 415 Capital Improvements Cash Cash 13,135 416 Crown Construction Cash Cash 2,648,819 420 Special Assess Cash Cash 736,813 505 Parking Cash Cash 24,258 510 Water Cash Cash 2,068,536 515 Sewer Cash Cash 0 520 Solid Waste Cash Cash 0 600 Fleet Cash Cash 785,063 601 Equipment Replacemt Cash Cash 0 605 Insurance 26,386,575 Total Cash 26,386,575 Interfunds & negative cash (8,972,533) Net Cash 17,414,042 Total Investments & Cash 47,281,687 CASH / INVESTMENT Investments Cash Total GENERAL LEDGER Amount %Amount %Amount % 1ST Bank 17,414,042 100.00%17,414,042 36.83% PMA-SDA 10,390,488 34.79%10,390,488 21.98% CD 3,724,100 12.47%3,724,100 7.88% US. T. BILL 2,999,329 10.04%2,999,329 6.34% IMET 1,020,594 3.42%1,020,594 2.16% IL Funds 11,733,134 39.28%11,733,134 24.82% Total 29,867,645 100.00%17,414,042 100.00%47,281,687 100.00%