HomeMy WebLinkAbout2012 Q2 Cash and Investment Report
To: Wally Bobkiewicz, City Manager
Martin Lyons, Asst. City Manager/CFO
From: Hitesh Desai, Accounting Manager
Subject: FY2012 – 2nd Quarter end Investment Report
Date: July 23, 2012
Attached please find the investment report as of June 30, 2012.
A comparison between the first and second quarter investment report indicates a
decrease for combined cash & investments of $10,518,316 from $81,424,725 to
$70,906,409. Cash and investment changes from the previous period are summarized
below:
6/30/2012 3/31/2012 Change
Cash 21,989,730$ 27,482,796$ (5,493,066)$
Investments 48,916,679$ 53,941,929$ (5,025,250)$
Total 70,906,409$ 81,424,725$ (10,518,316)$
The net decrease of $10.5M in cash and investments during the second quarter was
primarily due to debt service payments, IEPA loan payments and capital outlay. The
City paid $3,086,519 towards bond debt service payments which were due June 1,
2012. During the second quarter, $4,153,533 was disbursed towards IEPA loan
payments. The remainder of the decrease was the result of payments for capital outlay
in several funds.
As of June 30, 2012, ledger balances showed the highest percentage of total deposits
was held by Chase Bank at approximately $24.5M, or 35% of the City’s $70.9M in cash
and investments followed by Illinois Funds with $19.8M or 28% of the total. The
remaining funds were invested with First Bank, IMET and Charter One Bank. This 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. The Finance Staff will continue to
monitor the balances to have a suitable investment mix in compliance of the City
Investment policy to maximize returns on investments.
If you have any questions on this report or would like to discuss in greater detail, please
contact me @ (847) 866-2905 or at hdesai@cityofevanston.org.
Memorandum
1
City of Evanston
Cash & Investment Summary by Fund
June 30, 2012
Fund #Fund Cash Investments Interfund Total
100 General 8,033,947 4,597,466 (300,752)12,330,661
185 Library 1,470,939 (563,072)907,867
190 HPRP 0 0
195 Neighborhood Stabilization 222,371 (124,864)97,507
200 MFT 525,739 1,154,434 (280,842)1,399,331
205 E911 407,916 645,066 43,886 1,096,868
210 SSD4 (78,607) (78,607)
215 CDBG 195,695 (114,035)81,660
220 CD Loan 169,948 (64,199)105,749
225 Economic Dev.1,581,951 391,636 (200,267)1,773,320
235 Neighbrhd Improvemt 109,915 109,915
240 Home 53,661 (54,925) (1,264)
250 Affordable Housing 206,609 363,120 16,002 585,731
300 Washington National TIF 9,797,364 (1,993,023)7,804,341
305 SSD5 250,322 757 251,079
310 Howard Hartrey 5,049,605 (507,904)4,541,701
315 Southwest TIF 123,575 (4,820)118,755
320 Debt Service 1,431,205 2,763,829 178,918 4,373,952
330 Howard Ridge 973,348 152,320 (20,625)1,105,043
335 West Evanston 863,519 551,225 (9,442)1,405,302
415 Capital Improvements 6,203,095 (888,892)5,314,203
420 Special Assess 218,732 2,754,705 (9,732)2,963,705
505 Parking 7,266,607 6,758,934 (178,451)13,847,090
510 Water 1,993,715 5,392,432 (338,820)7,047,327
515 Sewer 3,792,802 1,014,638 (1,661,504)3,145,936
520 Solid Waste 49,543 (1,693,616) (1,644,073)
600 Fleet 594,271 (357,030)237,241
601 Equipment Replacemt 654,787 278,196 932,983
605 Insurance 682,239 370,847 1,053,086
30,547,303 48,916,679 (8,557,573)70,906,409
Includes negative cash balance reclassed to interfund liability.*
*
*
*
*
*
*
*
*
*
*
2
City of Evanston
Cash & Investments by Bank
June 30, 2012
Investment Investment Fiscal YTD Investment
Description Type Bank Rate Est. Income Amount Fund #Fund
Money Market Fund MMA 1st Bank 0.200 1,503 1,502,789 300 Washington National
Money Market Fund MMA 1st Bank 0.200 159 158,535 320 Debt Service
Money Market Fund MMA 1st Bank 0.150 40 53,118 415 Capital Improvements
Money Market Fund MMA 1st Bank 0.200 6,609 6,608,633 505 Parking
Money Market Fund MMA 1st Bank 0.050 2 7,109 510 Water
SUBTOTAL 8,312 8,330,184
Money Market Fund MMA Chase 0.210 1,889 1,799,186 300 Washington National
Money Market Fund MMA Chase 0.210 5,745 5,470,974 415 Capital Improvements
Money Market Fund MMA Chase 0.210 2,892 2,754,705 420 Special Assessment
Money Market Fund MMA Chase 0.210 92 87,159 505 Parking
Money Market Fund MMA Chase 0.210 860 818,768 510 Water
Money Market Fund MMA Chase 0.210 36 34,142 515 Sewer
Money Market Fund MMA Chase 0.210 52 49,543 520 Solid Waste
SUBTOTAL 11,565 11,014,477
Money Market Fund MMA IMET 0.270 4,055 3,003,432 300 Washington National
Money Market Fund MMA IMET 0.270 5,409 4,006,418 310 Howard Hartrey TIF
Money Market Fund MMA IMET 0.270 584 432,588 415 Capital Improvements
Money Market Fund MMA IMET 0.270 2,703 2,002,271 510 Water
Money Market Fund MMA IMET 0.270 424 313,751 515 Sewer
SUBTOTAL 13,174 9,758,461
IL Funds MMA US Bank 0.096 2,207 4,597,466 100 General
IL Funds MMA US Bank 0.096 554 1,154,434 200 MFT
IL Funds MMA US Bank 0.096 310 645,066 205 E911
IL Funds MMA US Bank 0.096 188 391,636 225 Economic Development
IL Funds MMA US Bank 0.096 174 363,120 250 Affordable Housing
IL Funds MMA US Bank 0.096 1,676 3,491,958 300 Washington National
IL Funds MMA US Bank 0.096 0 757 305 SSA#5
IL Funds MMA US Bank 0.096 501 1,043,187 310 Howard Hartrey TIF
IL Funds MMA US Bank 0.096 1,251 2,605,293 320 Debt Service
IL Funds MMA US Bank 0.096 73 152,320 330 Howard Ridge TIF
IL Funds MMA US Bank 0.096 265 551,225 335 West Evanston TIF
IL Funds MMA US Bank 0.096 118 246,414 415 Capital Improvements
IL Funds MMA US Bank 0.096 30 63,141 505 Parking
IL Funds MMA US Bank 0.096 1,231 2,564,285 510 Water
IL Funds MMA US Bank 0.096 320 666,745 515 Sewer
IL Funds MMA US Bank 0.096 285 594,271 600 Fleet
IL Funds MMA US Bank 0.096 327 682,239 605 Insurance
SUBTOTAL 9,511 19,813,558
Total Investments 42,561 48,916,679
Cash Cash 1st Bank 1,813,091 510 Water
Cash Cash 1st Bank 6,123,220 505 Parking
SUBTOTAL 7,936,311
Cash Cash Charter One 525,503 200 MFT
Cash Cash Chase 206,609 250 Affordable Housing
Cash Cash Chase 169,948 220 CD Loan
Cash Cash Chase 195,695 215 CDBG
Cash Cash Chase 1,431,205 320 Debt
Cash Cash Chase 407,916 205 E911
Cash Cash Chase 1,581,951 225 Economic Dev.
Cash Cash Chase 654,787 601 Equipment Replacemt
Cash Cash Chase 8,033,947 100 General
Cash Cash Chase 53,661 240 Home
Cash Cash Chase 973,348 330 Howard Ridge
Cash Cash Chase 1,470,939 185 Library
Cash Cash Chase 235 200 MFT
Cash Cash Chase 109,915 235 Neighbrhd Improvemt
Cash Cash Chase 222,371 195 Neighbrhd Stablztn
Cash Cash Chase 1,143,388 505 Parking
Cash Cash Chase 3,792,802 515 Sewer
Cash Cash Chase 123,575 315 Southwest TIF
Cash Cash Chase 218,732 420 Special Assess
Cash Cash Chase 250,322 305 SSD5
Cash Cash Chase 180,624 510 Water
Cash Cash Chase 863,519 335 West Evanston
SUBTOTAL 22,085,489
Total Cash 30,547,303
Interfunds & negative cash (8,557,573)
Net Cash 21,989,730
Total Investments & Cash 70,906,409
CASH / INVESTMENT Investments Cash Total
GENERAL LEDGER BALANCES
BY BANK Amount %Amount %Amount %
1ST Bank 8,330,184 17.03%7,936,311 36.09%16,266,495 22.94%
Charter One 525,503 2.39%525,503 0.74%
Chase 11,014,477 22.52%13,527,916.00 61.52%24,542,393 34.61%
IMET 9,758,461 19.95%9,758,461 13.76%
US Bank 19,813,558 40.50%19,813,558 27.94%
Total 48,916,679 100.00% 21,989,730 100.00% 70,906,409 100.00%
3
City of Evanston
Investments by Fund
June 30, 2012
Investment Investment Fiscal YTD Investment
Description Type Bank Rate Est. Income Amount Fund #Fund
IL Funds MMA US Bank 0.096 174 363,120 250 Affordable Housing
Money Market Fund MMA 1st Bank 0.150 40 53,118 415 Capital Improvements
Money Market Fund MMA Chase 0.210 5,745 5,470,974 415 Capital Improvements
Money Market Fund MMA IMET 0.270 584 432,588 415 Capital Improvements
IL Funds MMA US Bank 0.096 118 246,414 415 Capital Improvements
SUBTOTAL 6,203,095
Money Market Fund MMA 1st Bank 0.200 159 158,535 320 Debt Service
IL Funds MMA US Bank 0.096 1,251 2,605,293 320 Debt Service
SUBTOTAL 2,763,829
IL Funds MMA US Bank 0.096 310 645,066 205 E911
IL Funds MMA US Bank 0.096 188 391,636 225 Economic Development
IL Funds MMA US Bank 0.096 285 594,271 600 Fleet
IL Funds MMA US Bank 0.096 2,207 4,597,466 100 General
Money Market Fund MMA IMET 0.270 5,409 4,006,418 310 Howard Hartrey TIF
IL Funds MMA US Bank 0.096 501 1,043,187 310 Howard Hartrey TIF
SUBTOTAL 5,049,605
IL Funds MMA US Bank 0.096 73 152,320 330 Howard Ridge TIF
IL Funds MMA US Bank 0.096 327 682,239 605 Insurance
IL Funds MMA US Bank 0.096 554 1,154,434 200 MFT
Money Market Fund MMA 1st Bank 0.200 6,609 6,608,633 505 Parking
Money Market Fund MMA Chase 0.210 92 87,159 505 Parking
IL Funds MMA US Bank 0.096 30 63,141 505 Parking
SUBTOTAL 6,758,933
Money Market Fund MMA Chase 0.210 36 34,142 515 Sewer
Money Market Fund MMA IMET 0.270 424 313,751 515 Sewer
IL Funds MMA US Bank 0.096 320 666,745 515 Sewer
SUBTOTAL 1,014,638
Money Market Fund MMA Chase 0.210 52 49,543 520 Solid Waste
Money Market Fund MMA Chase 0.210 2,892 2,754,705 420 Special Assessment
IL Funds MMA US Bank 0.096 0 757 305 SSA#5
Money Market Fund MMA 1st Bank 0.200 1,503 1,502,789 300 Washington National
Money Market Fund MMA Chase 0.210 1,889 1,799,186 300 Washington National
Money Market Fund MMA IMET 0.270 4,055 3,003,432 300 Washington National
IL Funds MMA US Bank 0.096 1,676 3,491,958 300 Washington National
SUBTOTAL 9,797,364
Money Market Fund MMA 1st Bank 0.050 2 7,109 510 Water
Money Market Fund MMA Chase 0.210 860 818,768 510 Water
Money Market Fund MMA IMET 0.270 2,703 2,002,271 510 Water
IL Funds MMA US Bank 0.096 1,231 2,564,285 510 Water
SUBTOTAL 5,392,432
IL Funds MMA US Bank 0.096 265 551,225 335 West Evanston TIF
TOTAL 48,916,679 Grand Total4