Loading...
HomeMy WebLinkAbout5B 2017 1st Quarter Investment Report 4646 Dakota Street SE Prior Lake, MN 55372 CITY COUNCIL AGENDA REPORT MEETING DATE: MAY 22, 2017 AGENDA #: 5B PREPARED BY: JASON ETTER, ACCOUNTANT PRESENTED BY: CATHY ERICKSON, ACCOUNTING MANAGER AGENDA ITEM: CONSIDER APPROVAL OF 1st QUARTER 2017 INVESTMENT REPORT DISCUSSION: Introduction The purpose of this agenda item is for the Council to consider approval of the in- vestment report for the first quarter of 2017. Current Circumstances Staff has prepared a list of investments as of March 31, 2017. The Investment Re- port Summary Narrative provides some supplementary information with respect to the investments currently held and the allowable forms of investments permitted by Minnesota Statute. The investment software provides the ability to generate reports and charts by bro- ker, security type, maturities, etc. The software also enables staff to track interest earned on an accrual basis versus a cash basis as well as changes in market value. Conclusion The City Council should approve the quarterly investment report. ALTERNATIVES: 1. Motion and second as part of the consent agenda to approve the 2017 1st Quarter Investment Report as submitted. 2. Motion and second to remove the Investment Report from the consent agenda for additional discussion. RECOMMENDED MOTION: Alternative 1. 2 INVESTMENT REPORT SUMMARY NARRATIVE The attached “Investment Portfolio – Detail, by Broker” identifies the various types of investments and the brokers/banks the City of Prior Lake uses for investment purposes. As of March 31, 2017, the balance of the investment portfolio is $24,137,535. This is a decrease of $2M from December 31, 2016 due to the requirement to fund ongoing city operations. The ‘weighted average yield to maturity at cost’ of the investment portfolio is currently 1.68% which is an increase from 1.54% as of December 31. The yield will fluctuate due in part to the balances that are in the short-term money market accounts and the very low rate that is paid on money market funds. At the end of March, the balance in the 4M money market was $2.9M. It continues to be challenging to find competitive rates for short-term investments---30 to 120-day ma- turities. These short-term securities are necessary to meet cash flow needs for payments to vendors (including construction contracts) and payroll. The following table shows the treasury rates for the 1st quarter of 2017 compared to the previous two years: As rates decrease, the market value of the existing securities will increase. As of March 31, 2017, the market value of the portfolio is greater than the cost of the investments by $69K. The change in the fair value of the securities is adjusted against interest earnings in each of the funds. This is a paper gain for the first quarter of 2017; no actual gain is realized because the City holds the securities until maturity. During the first quarter of 2017, the chart below shows how rates, especially mid to long-term securi- ties, have remained flat. Current long-term rates being offered by financial institutions continues to be very low. - 0.50 1.00 1.50 2.00 2.50 3.00 1 mo 3 mo 6 mo 1 yr 2 yr 3 yr 5 yr 7 yr 10 yr US Treasury Yield Curve 3/31/15 3/31/16 3/31/17 3 As the attached chart titled Investment Portfolio – Diversification, by Maturity Range indicates, approx- imately 21% or $5 million matures within 1 month. Of that total, $2.9 million is in the 4M investment pool which is currently generating the highest money market interest rates. These funds will be in- vested as the appropriate security (type, rate, and maturity) becomes available. Staff continues to look for opportunities to invest our short-term funds. Revision to the City’s investment policy is cur- rently being reviewed for possible updates. The City’s investment portfolio amount is a pool of funds identified on the monthly Treasurer’s Report. As shown on the March Treasurer’s Report, the balance of cash and investments, is $24.5M. Of this balance, $24.1M is investments and $400K is cash. Because City funds are pooled for investment purposes, interest is allocated to each fund monthly, and is based upon each individual fund’s propor- tionate share of the total amount. Overall, the total investment pool does not represent excess re- serves but rather available financial resources. In most instances, these funds were established and restricted for specific and designated purposes by either Minnesota Statutes or City Code to accom- plish the goals and objectives of the City. The constraints for each of the funds are noted on the Treasurer’s Report. Investments for local governments are restricted to only those permitted by Minnesota Statutes. Per the City of Prior Lake Investment Policy, the City has chosen to limit its allowable investments as fol- lows: 1. Bonds, notes certificates of indebtedness, treasury bills or other securities now or hereafter issued by the United States of America, its agencies and al- lowable instrumentalities; 2. Interest bearing checking and savings accounts, or any other investments constituting direct obligations of any bank; 3. Certificates of deposit at state and federally chartered institutions that are lim- ited to the amount of coverage provided by the Federal Deposit Insurance Corporation; 4. Money market accounts that are invested in above referenced government se- curities; - 0.25 0.50 0.75 1.00 1.25 1.50 1.75 2.00 2.25 2.50 2.75 1 mo 3 mo 6 mo 1 yr 2 yr 3 yr 5 yr 7 yr 10 yr US Treasury Yield Curve 1/31/17 2/28/17 3/31/17 4 5. State and local securities which have at the time of investment one of the three highest credit ratings by a nationally recognized rating agency; 6. Investments may be made only in those savings banks or savings and loan associations the shares, or investment certificates of which are insured by the Federal Deposit Insurance Corporation; 7. Investment products that are considered as derivatives are specifically ex- cluded from approved investments. The breakdown of all security types held by the City is shown graphically in the attached document titled Investment Portfolio – Diversification, by Security Type. The investment policy also requires that all investment maturities shall not extend beyond ten (10) years with no more than 20% maturing beyond five (5) years. Change from one 3/31/2016 6/30/2016 9/30/2016 12/31/2016 3/31/2017 year prior Market Value 3,156,481 5,798,579 5,874,655 5,710,646 4,301,259 1,144,778 1 1 1 1 1 0 0.06% 0.06% 0.06% 0.25% 0.34%0.28% Fixed Income Assets 21,326,125 17,987,700 19,823,000 20,445,000 19,836,276 (1,489,849) 21,598,640 18,294,310 20,096,281 20,533,421 19,905,497 (1,693,143) 1,146 1,074 988 873 909 (237) 664 634 518 437 405 (259) 1.97% 2.12% 1.95% 1.90% 1.97%0.00% Total Portfolio Value 24,482,606 23,786,279 25,697,655 26,155,646 24,137,535 (345,071) 24,755,121 24,092,889 25,970,936 26,244,067 24,206,756 (548,365) 80,548 79,372 67,230 88,612 66,954 (13,594) 272,515 306,610 273,282 87,084 69,221 (203,294) 998 812 763 683 747 (251) 578 479 400 342 333 (245) 1.72% 1.61% 1.52% 1.54% 1.68% -0.04% BENCHMARK 90 Day T-Bill 0.21% 0.27% 0.29% 0.51% 0.76% 0.55% 0.39% 0.36% 0.47% 0.62% 0.91% 0.52% 0.59% 0.46% 0.59% 0.85% 1.03% 0.44% Weighted Average Yield to Maturity @ Cost CITY OF PRIOR LAKE, MINNESOTA Quarterly Investment Report March 31, 2017 Local Government Investment Pools / Money Market Quarterly WAM (1) in Days Weighted Average Yield to Maturity Cost Value Market Value WAM (1) in Days WAM / Callable (1) in Days Weighted Average Yield to Maturity @ Cost 6 Month Treasury 1 Year Treasury Cost Value Market Value Accrued Interest Unrealized Gain / Loss WAM (1) in Days WAM / Callable (1) in Days City of Prior Lake - Quarterly Investment Report YTM @ Cost Cost Value Days to Maturity % of Portfolio Cash 0.004 1,376,687 1 5.70% Certificate of Deposit 1.512 8,656,000 655 35.86% FHLB Bond 2.552 1,525,000 1,286 6.32% FHLMC Bond 2.014 4,340,000 1,301 17.98% FNMA Bond 1.863 2,400,000 1,571 9.94% LGIP 0.500 2,924,572 1 12.12% Municipal Bond 3.028 2,915,276 340 12.08% Total / Average 1.677 24,137,535 747 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio - Diversification, by Security Type March 31, 2017 Description City of Prior Lake - Quarterly Investment Report YTM @ Cost Cost Value Days to Maturity % of Portfolio 0-1 Month 0.768 5,046,259 2 20.91% 1-3 Months 0.844 1,834,276 36 7.60% 3-6 Months 0.835 2,309,000 143 9.57% 6-9 Months 1.113 983,000 198 4.07% 9-12 Months - - - 0.00% 1-2 Years 2.699 2,718,000 584 11.26% 2-3 Years 2.229 2,671,000 967 11.07% 3-4 Years 2.139 2,771,000 1,334 11.48% 4-5 Years 2.240 5,560,000 1,625 23.03% 5-10 Years 1.500 245,000 2,190 1.02% Total / Average 1.677 24,137,535 747 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio - Diversification, by Maturity Range March 31, 2017 Description City of Prior Lake - Quarterly Investment Report De s c r i p t i o n CU S I P / T i c k e r T r a n s a c t i o n I D S e t t l e m e n t D a t e Y T M @ C o s t Fa c e A m o u n t / S h a r e s C o s t V a l u e B o o k V a l u e M a r k e t V a l u e M at u r i t y D a t e D a y s T o M a t u r i t y A c c r u e d I n t e r e s t % o f P o rtfolio Ca s h - N o r t h l a n d S e c u r i t i e s C a s h C A S H 5 8 4 5 0 6 / 3 0 / 2 0 1 2 0 .0 0 0 3 2 , 3 4 5 . 4 2 3 2 , 3 4 5 . 4 2 3 2 , 3 4 5 . 4 2 3 2 , 3 4 5 . 4 2 N / A 1 0 . 1 3 Mo r g a n S t a n l e y C a s h CA S H 5 0 8 9 1 2 / 3 1 / 2 0 1 0 0 . 0 0 0 7 5 4 , 3 7 7 . 6 8 7 5 4 , 3 7 7 . 6 8 7 5 4 , 3 7 7 . 68 7 5 4 , 3 7 7 . 6 8 N / A 1 3 . 1 3 We l l s F a r g o A d v i s o r s C a s h M M 4 2 8 5 1 2 / 2 7 / 2 0 1 1 0 . 0 1 0 5 8 9 , 9 63 . 9 6 5 8 9 , 9 6 3 . 9 6 5 8 9 , 9 6 3 . 9 6 5 8 9 , 9 6 3 . 9 6 N / A 1 2 . 4 4 Su b T o t a l / A v e r a g e 0. 0 0 4 1 , 3 7 6 , 6 8 7 . 0 6 1 , 3 7 6 , 6 8 7 . 0 6 1 , 3 7 6 , 6 8 7 . 0 6 1 , 3 7 6 , 6 8 7 . 06 1 0 . 0 0 5 . 7 0 1s t F e d e r a l B a n k - H a r r i s o n A R 1 . 0 5 8 / 2 0 / 2 0 1 8 3 2 0 2 3 L AG 4 2 8 9 8 2 0 2 / 1 9 / 2 0 1 3 1 . 0 5 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 00 2 4 4 , 1 4 7 . 4 0 0 8 / 2 0 / 2 0 1 8 5 0 7 8 4 . 5 8 1 . 0 2 Al l y B k , M i d v a l e , U T 1 . 2 5 9 / 3 / 2 0 1 9 0 2 0 0 6 L L 6 8 5 7 8 0 3 0 9 / 01 / 2 0 1 6 1 . 2 5 0 9 6 , 0 0 0 . 0 0 9 6 , 0 0 0 . 0 0 9 6 , 0 0 0 . 0 0 9 4 , 7 4 9 . 1 2 0 9 / 03 / 2 0 1 9 8 8 6 9 8 . 6 3 0 . 4 0 Am e r i c a n E x p B K F S B , U T 1 . 9 5 7 / 1 7 / 2 0 1 9 0 2 5 8 7 C A F 7 3 5 3 2 8 0 7 / 1 7 / 2 0 1 4 1 . 9 5 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 7 , 0 50 . 6 5 0 7 / 1 7 / 2 0 1 9 8 3 8 9 5 5 . 5 0 1 . 0 2 Am e x C e n t u r i o n , S a l t L a k e C i t y U T 2 . 2 1 2 / 1 1 / 2 0 1 9 0 2 5 87 D W X 2 2 7 4 7 1 1 2 / 1 1 / 2 0 1 4 2 . 2 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 00 . 0 0 2 4 7 , 5 3 5 . 7 5 1 2 / 1 1 / 2 0 1 9 9 8 5 1 , 6 2 4 . 3 8 1 . 0 2 Ba n k H a p o a l i m B M 0 . 8 8 / 1 / 2 0 1 7 0 6 2 5 1 A P 4 6 3 3 6 8 6 0 2 / 0 1 / 2 0 17 0 . 8 0 0 2 4 6 , 0 0 0 . 0 0 2 4 6 , 0 0 0 . 0 0 2 4 6 , 0 0 0 . 0 0 2 4 6 , 0 5 6 . 5 8 0 8 / 0 1/ 2 0 1 7 1 2 3 3 1 2 . 7 2 1 . 0 2 Ba n k o f B a r o d a 0 . 8 7 / 3 1 / 2 0 1 7 0 6 0 6 2 Q G 8 1 3 3 6 8 1 0 1 / 3 1 / 2 0 1 7 0 . 8 0 0 2 4 8 , 0 0 0 . 0 0 2 4 8 , 0 0 0 . 0 0 2 4 8 , 0 0 0 . 0 0 2 4 8 , 0 2 4 . 8 0 0 7 / 3 1 /2 0 1 7 1 2 2 3 2 0 . 7 0 1 . 0 3 Ba n k o f C h i n a , N e w Y o r k , N Y 0 . 8 8 / 3 1 / 2 0 1 7 0 6 4 2 6 T Y W 3 3 36 5 3 0 8 / 3 1 / 2 0 1 6 0 . 8 0 0 2 4 8 , 0 0 0 . 0 0 2 4 8 , 0 0 0 . 0 0 2 4 8 , 0 0 0 . 0 0 2 4 7, 9 4 7 . 9 2 0 8 / 3 1 / 2 0 1 7 1 5 3 1 , 1 5 2 . 3 5 1 . 0 3 Ba n k o f H o p e , L o s A n g e l e s C A 0 . 8 9 / 2 2 / 2 0 1 7 0 6 2 6 8 3 A D 9 26 6 1 0 0 9 / 2 3 / 2 0 1 6 0 . 8 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 45 , 0 0 7 . 3 5 0 9 / 2 2 / 2 0 1 7 1 7 5 4 2 . 9 6 1 . 0 2 Ba n k w e s t S D 1 . 5 3 / 3 0 / 2 0 2 3 - 1 7 0 6 6 5 2 C F N 6 4 0 0 9 0 3 / 3 0 / 2 0 1 6 1. 5 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 0 , 4 0 6 . 2 5 0 3 / 3 0 / 20 2 3 2 , 1 9 0 1 0 . 0 7 1 . 0 2 Be r k s h i r e B a n k 0 . 6 5 8 / 2 8 / 2 0 1 7 0 8 4 6 0 1 G T 4 2 3 6 2 1 0 2 / 2 8 / 2 0 17 0 . 6 5 0 2 4 8 , 0 0 0 . 0 0 2 4 8 , 0 0 0 . 0 0 2 4 8 , 0 0 0 . 0 0 2 4 7 , 8 8 3 . 4 4 0 8 / 2 8/ 2 0 1 7 1 5 0 1 3 6 . 9 1 1 . 0 3 BM O H a r r i s B k N a t l C h i c a g o 0 . 8 5 4 / 1 7 / 2 0 1 7 0 5 5 7 3 J 5 Q 3 1 65 7 1 1 0 / 1 4 / 2 0 1 5 0 . 8 5 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5, 0 2 2 . 0 5 0 4 / 1 7 / 2 0 1 7 1 7 9 5 8 . 5 2 1 . 0 2 BM W B a n k N A , U t a h 2 . 1 1 2 / 1 1 / 2 0 1 8 0 5 5 6 8 P 6 L 6 3 5 1 4 1 1 2 / 1 1 /2 0 1 3 2 . 1 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 7 , 2 6 6 . 2 5 1 2/ 1 1 / 2 0 1 8 6 2 0 1 , 5 5 0 . 5 5 1 . 0 2 Ca p i t a l O n e B a n k G l e n A l l e n V A 2 . 2 5 9 / 3 0 / 2 0 2 0 1 4 0 4 2 0 W D 8 3 3 9 5 4 0 9 / 3 0 / 2 0 1 5 2 . 2 5 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 00 2 4 8 , 3 3 4 . 4 5 0 9 / 3 0 / 2 0 2 0 1 , 2 7 9 1 5 . 1 0 1 . 0 2 Ca p i t a l O n e N A M c L e a n V A 1 . 6 5 9 / 2 4 / 2 0 1 8 1 4 0 4 2 R A A 9 4 2 9 7 0 9 / 2 8 / 2 0 1 5 1 . 6 5 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 6 , 2 39 . 7 0 0 9 / 2 4 / 2 0 1 8 5 4 2 8 8 . 6 0 1 . 0 2 Ci t i z e n s B a n k P A 0 . 6 5 5 / 1 / 2 0 1 7 1 7 4 1 7 Q D E 0 5 7 2 8 2 0 2 / 0 1 / 2 01 7 0 . 6 5 0 2 4 8 , 0 0 0 . 0 0 2 4 8 , 0 0 0 . 0 0 2 4 8 , 0 0 0 . 0 0 2 4 7 , 9 9 7 . 5 2 0 5 / 01 / 2 0 1 7 3 1 2 5 6 . 1 5 1 . 0 3 Ci t i z e n s B a n k R I 0 . 6 5 5 / 1 / 2 0 1 7 7 5 5 2 4 K G K 4 5 7 9 5 7 0 2 / 0 1 / 2 01 7 0 . 6 5 0 2 4 8 , 0 0 0 . 0 0 2 4 8 , 0 0 0 . 0 0 2 4 8 , 0 0 0 . 0 0 2 4 7 , 9 9 7 . 5 2 0 5 / 01 / 2 0 1 7 3 1 2 5 6 . 1 5 1 . 0 3 CO M E N I T Y B K S A L T L A K E C I T Y U T 2 . 6 1 1 / 2 4 / 2 0 2 1 2 0 0 3 3 A J N7 5 7 5 7 0 1 1 / 2 6 / 2 0 1 4 2 . 6 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 5 0 , 9 6 8 . 2 0 1 1 / 2 4 / 2 0 2 1 1 , 6 9 9 8 7 . 2 6 1 . 0 2 Di s c o v e r B a n k G r e e n w o o d D E 2 1 2 / 1 1 / 2 0 1 8 2 5 4 6 7 1 C 8 1 5 6 4 9 1 2 / 1 1 / 2 0 1 3 2 . 0 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 7 , 3 10 . 3 5 1 2 / 1 1 / 2 0 1 8 6 2 0 1 , 4 7 6 . 7 1 1 . 0 2 En e r b a n k U S A , U T 2 . 2 5 8 / 2 8 / 2 0 2 0 2 9 2 6 6 N B 4 8 5 7 2 9 3 0 8 / 2 8 / 20 1 4 2 . 2 5 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 8 , 3 9 5 . 7 0 0 8 /2 8 / 2 0 2 0 1 , 2 4 6 4 6 8 . 1 8 1 . 0 2 Ev e r b a n k C D J a c k s o n v i l l e F L 1 . 1 9 / 2 9 / 2 0 1 7 2 9 9 7 6 D B 9 0 3 47 7 5 0 9 / 3 0 / 2 0 1 5 1 . 1 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5, 3 3 3 . 2 0 0 9 / 2 9 / 2 0 1 7 1 8 2 7 . 3 8 1 . 0 2 Fi r s t N a t i o n a l B k O m a h a 0 . 7 5 8 / 1 6 / 2 0 1 7 3 3 2 1 3 5 G L 0 5 4 5 2 08 / 1 6 / 2 0 1 6 0 . 7 5 0 2 4 8 , 0 0 0 . 0 0 2 4 8 , 0 0 0 . 0 0 2 4 8 , 0 0 0 . 0 0 2 4 8 , 0 0 0. 0 0 0 8 / 1 6 / 2 0 1 7 1 3 8 7 6 . 4 4 1 . 0 3 Fi r s t N i a g a r a B K N A 1 . 1 5 1 0 / 1 0 / 2 0 1 7 3 3 5 8 3 C S M 2 1 6 0 0 4 1 0 /0 9 / 2 0 1 5 1 . 1 5 0 2 4 8 , 0 0 0 . 0 0 2 4 8 , 0 0 0 . 0 0 2 4 8 , 0 0 0 . 0 0 2 4 8 , 4 1 4 . 16 1 0 / 1 0 / 2 0 1 7 1 9 3 1 , 3 5 1 . 7 7 1 . 0 3 GE C A P B K I N C R E T A I L 1 . 8 7 / 1 3 / 2 0 1 7 3 6 1 6 1 T B W 4 3 3 7 7 8 0 7 / 13 / 2 0 1 2 1 . 8 0 0 9 6 , 0 0 0 . 0 0 9 6 , 0 0 0 . 0 0 9 6 , 0 0 0 . 0 0 9 6 , 2 8 1 . 2 8 0 7 / 13 / 2 0 1 7 1 0 4 3 6 4 . 5 4 0 . 4 0 GE C a p B k I n c R e t a i l 2 . 5 5 7 / 1 9 / 2 0 2 1 3 6 1 6 1 T S 4 8 3 3 7 7 8 0 7 /1 8 / 2 0 1 4 2 . 5 5 0 1 5 0 , 0 0 0 . 0 0 1 5 0 , 0 0 0 . 0 0 1 5 0 , 0 0 0 . 0 0 1 5 3 , 7 6 9 . 50 0 7 / 1 9 / 2 0 2 1 1 , 5 7 1 7 5 4 . 5 2 0 . 6 2 GE C a p R e t B K , D r a p e r U T 2 . 6 5 3 / 2 9 / 2 0 2 1 3 6 1 5 7 Q X M 4 2 7 3 14 0 3 / 2 8 / 2 0 1 4 2 . 6 5 0 9 6 , 0 0 0 . 0 0 9 6 , 0 0 0 . 0 0 9 6 , 0 0 0 . 0 0 9 8 , 6 0 9 . 28 0 3 / 2 9 / 2 0 2 1 1 , 4 5 9 2 0 . 9 1 0 . 4 0 GE C A P I T A L , U T 2 . 6 9 / 2 1 / 2 0 2 0 3 6 1 5 7 Q Q Q 3 2 7 3 1 4 0 9 / 2 0 / 2 0 1 3 2 . 6 0 0 1 5 0 , 0 0 0 . 0 0 1 5 0 , 0 0 0 . 0 0 1 5 0 , 0 0 0 . 0 0 1 5 2 , 7 9 4 . 5 0 0 9 / 2 1 /2 0 2 0 1 , 2 7 0 1 1 7 . 5 3 0 . 6 2 HS B C B a n k U S A N A S t e p 1 2 / 1 8 / 2 0 1 9 - 1 7 4 0 4 3 4 A K Q 1 5 7 8 9 0 0 6 /1 9 / 2 0 1 4 2 . 0 2 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 8 2 3 . 20 1 2 / 1 8 / 2 0 1 9 9 9 2 1 1 3 . 4 4 1 . 0 2 JP M o r g a n C h a s e B k S t e p 2 / 1 9 / 2 0 2 1 - 1 5 4 8 1 2 5 T V 5 1 6 2 8 0 2 / 1 9/ 2 0 1 5 2 . 4 4 6 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 6 , 1 2 9 . 4 5 02 / 1 9 / 2 0 2 1 1 , 4 2 1 5 3 6 . 9 9 1 . 0 2 Me d a l l i o n B k U t a h 1 . 4 5 6 / 2 9 / 2 0 1 8 5 8 4 0 3 B Q 2 5 5 7 4 4 9 0 6 / 3 0 /2 0 1 4 1 . 4 5 0 2 4 8 , 0 0 0 . 0 0 2 4 8 , 0 0 0 . 0 0 2 4 8 , 0 0 0 . 0 0 2 4 8 , 9 0 0 . 2 4 0 6/ 2 9 / 2 0 1 8 4 5 5 9 . 8 5 1 . 0 3 Me r c a n t i l C o m m e r c e B a n k , F L 1 . 9 8 / 2 9 / 2 0 1 8 5 8 7 3 3 A A P 4 2 29 5 3 0 8 / 2 9 / 2 0 1 3 1 . 9 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 7, 1 4 3 . 7 5 0 8 / 2 9 / 2 0 1 8 5 1 6 3 9 5 . 3 6 1 . 0 2 Mi z r a h T e f a h o t B a n k 0 . 6 5 5 / 1 5 / 2 0 1 7 6 0 6 8 5 7 5 E 6 3 3 6 6 1 0 2 / 14 / 2 0 1 7 0 . 6 5 0 2 4 8 , 0 0 0 . 0 0 2 4 8 , 0 0 0 . 0 0 2 4 8 , 0 0 0 . 0 0 2 4 7 , 9 8 7 . 6 0 0 5 / 1 5 / 2 0 1 7 4 5 1 9 8 . 7 4 1 . 0 3 NB T B a n k , N Y 2 . 1 8 / 2 7 / 2 0 1 9 6 2 8 7 7 9 F P 0 7 2 3 0 0 8 / 2 7 / 2 0 1 4 2 . 10 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 7 , 0 2 1 . 2 5 0 8 / 2 7 / 2 0 19 8 7 9 4 5 1 . 0 7 1 . 0 2 SA L L I E M A E B K C D M u r r a y U T 1 . 5 1 0 / 2 4 / 2 0 1 7 7 9 5 4 5 0 P Y 5 5 81 7 7 1 0 / 2 4 / 2 0 1 2 1 . 5 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 6, 1 5 1 . 5 0 1 0 / 2 4 / 2 0 1 7 2 0 7 1 , 5 9 0 . 8 2 1 . 0 2 ST A T E B K I N D I A N E W Y O R K N Y 2 . 6 1 2 / 6 / 2 0 2 1 8 5 6 2 8 4 3 H 5 3 3 68 2 1 2 / 0 5 / 2 0 1 4 2 . 6 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 9 ,4 3 6 . 9 5 1 2 / 0 6 / 2 0 2 1 1 , 7 1 1 2 , 0 2 4 . 4 4 1 . 0 2 TC F S I O U X F A L L S S D 0 . 7 1 0 / 2 7 / 2 0 1 7 8 7 2 2 7 8 T P 1 2 8 3 3 0 0 4 / 2 7/ 2 0 1 6 0 . 7 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 1 1 0 . 2 5 10 / 2 7 / 2 0 1 7 2 1 0 7 2 8 . 2 9 1 . 0 2 W e b s t e r 5 C n t s 1 . 5 5 9 / 1 7 / 2 0 2 1 - 1 7 9 4 7 8 9 P B V 5 9 0 2 9 7 0 3 / 1 8 /2 0 1 6 1 . 5 5 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 3 9 , 3 8 4 . 6 0 0 9/ 1 7 / 2 0 2 1 1 , 6 3 1 1 3 5 . 2 5 1 . 0 2 W E X B A N K , U T 1 7 / 9 / 2 0 1 8 9 2 9 3 7 C D R 6 3 4 6 9 7 0 7 / 0 8 / 2 0 1 6 1 . 0 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 4 , 1 6 2 . 1 0 0 7 / 0 9 / 2 0 1 8 465 5 5 0 . 4 1 1 . 0 2 W o r l d F i n a n c i a l J u m b o 1 . 8 5 / 3 1 / 2 0 1 7 9 8 2 9 9 9 B 0 1 2 7 4 9 9 0 5 /3 1 / 2 0 1 2 1 . 8 0 0 2 0 0 , 0 0 0 . 0 0 2 0 0 , 0 0 0 . 0 0 2 0 0 , 0 0 0 . 0 0 2 0 0 , 3 3 8 . 00 0 5 / 3 1 / 2 0 1 7 6 1 0 . 0 0 0 . 8 3 Su b T o t a l / A v e r a g e 1. 5 1 2 8 , 6 5 6 , 0 0 0 . 0 0 8 , 6 5 6 , 0 0 0 . 0 0 8 , 6 5 6 , 0 0 0 . 0 0 8 , 6 8 9 , 1 3 1 . 81 6 5 5 1 9 , 3 2 3 . 7 7 3 5 . 8 6 Ca s h Ce r t i f i c a t e O f D e p o s i t CI T Y O F P R I O R L A K E , M I N N E S O T A In v e s t m e n t P o r t f o l i o - B y S e c u r i t y T y p e Ma r c h 3 1 , 2 0 1 7 FH L B B o n d FH L B 0 . 7 5 8 / 2 3 / 2 0 1 7 - 1 6 3 1 3 0 A 9 2 C 4 0 8 / 2 3 / 2 0 1 6 0 . 7 5 0 4 5 0 , 0 00 . 0 0 4 5 0 , 0 0 0 . 0 0 4 5 0 , 0 0 0 . 0 0 4 4 9 , 6 8 5 . 0 0 0 8 / 2 3 / 2 0 1 7 1 4 5 3 5 6 .25 1 . 8 6 FH L B S t e p 1 / 2 7 / 2 0 2 2 - 1 7 3 1 3 0 A A K 4 9 - 2 0 1 / 2 7 / 2 0 1 7 3 . 3 0 7 6 0 0 ,0 0 0 . 0 0 6 0 0 , 0 0 0 . 0 0 6 0 0 , 0 0 0 . 0 0 5 9 9 , 9 0 4 . 0 0 0 1 / 2 7 / 2 0 2 2 1 , 7 6 3 1 , 0 6 6 . 6 7 2 . 4 9 FH L B S t e p 1 / 2 7 / 2 0 2 2 - 1 7 3 1 3 0 A A K 4 9 - 1 0 1 / 2 7 / 2 0 1 7 3 . 3 0 7 4 7 5 ,0 0 0 . 0 0 4 7 5 , 0 0 0 . 0 0 4 7 5 , 0 0 0 . 0 0 4 7 4 , 9 5 2 . 5 0 0 1 / 2 7 / 2 0 2 2 1 , 7 6 3 8 4 4 . 4 4 1 . 9 7 Su b T o t a l / A v e r a g e 2. 5 5 2 1 , 5 2 5 , 0 0 0 . 0 0 1 , 5 2 5 , 0 0 0 . 0 0 1 , 5 2 5 , 0 0 0 . 0 0 1 , 5 2 4 , 5 4 1 . 50 1 , 2 8 6 2 , 2 6 7 . 3 6 6 . 3 2 FH L M C 2 1 1 / 3 0 / 2 0 2 0 31 3 4 G 3 V F 4 0 5 / 3 0 / 2 0 1 2 2 . 0 0 0 1 , 7 9 0 , 0 0 0 . 0 0 1 , 7 9 0 , 0 0 0 . 0 0 1 , 7 90 , 0 0 0 . 0 0 1 , 8 0 5 , 6 6 2 . 5 0 1 1 / 3 0 / 2 0 2 0 1 , 3 4 0 1 1 , 9 3 3 . 3 3 7 . 4 2 FH L M C S t e p 3 / 2 0 / 2 0 2 0 - 1 7 3 1 3 4 G A 7 D 0 0 3 / 2 0 / 2 0 1 7 2 . 2 3 4 6 0 0 , 00 0 . 0 0 6 0 0 , 0 0 0 . 0 0 6 0 0 , 0 0 0 . 0 0 5 9 8 , 9 8 0 . 0 0 0 3 / 2 0 / 2 0 2 0 1 , 0 8 5 183.33 2 . 4 9 FH L M C S t e p 3 / 2 0 / 2 0 2 0 - 1 7 3 1 3 4 G A 7 D 0 0 3 / 2 0 / 2 0 1 7 2 . 2 3 4 2 5 0 , 00 0 . 0 0 2 5 0 , 0 0 0 . 0 0 2 5 0 , 0 0 0 . 0 0 2 4 9 , 5 7 5 . 0 0 0 3 / 2 0 / 2 0 2 0 1 , 0 8 5 76.39 1 . 0 4 FH L M C S t e p 6 / 3 0 / 2 0 2 1 - 1 6 3 1 3 4 G 9 S V 0 0 6 / 3 0 / 2 0 1 6 2 . 2 4 6 5 0 0 , 00 0 . 0 0 5 0 0 , 0 0 0 . 0 0 5 0 0 , 0 0 0 . 0 0 4 9 9 , 4 0 0 . 0 0 0 6 / 3 0 / 2 0 2 1 1 , 5 5 2 1,562.50 2 . 0 7 FH L M C S t e p 7 / 2 6 / 2 0 1 9 - 1 6 3 1 3 4 G 9 Q 3 4 0 7 / 2 6 / 2 0 1 6 1 . 7 3 7 5 0 0 , 00 0 . 0 0 5 0 0 , 0 0 0 . 0 0 5 0 0 , 0 0 0 . 0 0 4 9 9 , 4 0 0 . 0 0 0 7 / 2 6 / 2 0 1 9 8 4 7 6 7 7.08 2 . 0 7 FH L M C S t e p 8 / 2 4 / 2 0 2 1 - 1 7 3 1 3 4 G A D Q 4 0 8 / 2 4 / 2 0 1 6 1 . 8 1 5 7 0 0 , 00 0 . 0 0 7 0 0 , 0 0 0 . 0 0 7 0 0 , 0 0 0 . 0 0 6 9 0 , 8 3 0 . 0 0 0 8 / 2 4 / 2 0 2 1 1 , 6 0 7 899.31 2 . 9 0 Su b T o t a l / A v e r a g e 2. 0 1 4 4 , 3 4 0 , 0 0 0 . 0 0 4 , 3 4 0 , 0 0 0 . 0 0 4 , 3 4 0 , 0 0 0 . 0 0 4 , 3 4 3 , 8 4 7 . 50 1 , 3 0 1 1 5 , 3 3 1 . 9 4 1 7 . 9 8 FN M A S t e p 5 / 2 5 / 2 0 2 1 - 1 6 3 1 3 6 G 3 L S 2 0 5 / 2 5 / 2 0 1 6 2 . 0 1 0 5 0 0 , 0 00 . 0 0 5 0 0 , 0 0 0 . 0 0 5 0 0 , 0 0 0 . 0 0 4 9 9 , 7 4 5 . 0 0 0 5 / 2 5 / 2 0 2 1 1 , 5 1 6 1 ,968.75 2 . 0 7 FN M A S t e p 7 / 1 9 / 2 0 2 1 - 1 7 3 1 3 6 G 3 Z Z 1 0 7 / 1 9 / 2 0 1 6 1 . 7 3 3 4 0 0 , 0 00 . 0 0 4 0 0 , 0 0 0 . 0 0 4 0 0 , 0 0 0 . 0 0 3 9 6 , 9 6 0 . 0 0 0 7 / 1 9 / 2 0 2 1 1 , 5 7 1 8 00.00 1 . 6 6 FN M A S t e p 7 / 2 8 / 2 0 2 1 - 1 6 3 1 3 6 G 3 X Y 6 0 7 / 2 8 / 2 0 1 6 1 . 7 8 2 1 , 0 0 0 ,0 0 0 . 0 0 1 , 0 0 0 , 0 0 0 . 0 0 1 , 0 0 0 , 0 0 0 . 0 0 9 8 2 , 7 0 0 . 0 0 0 7 / 2 8 / 2 0 2 1 1, 5 8 0 1 , 7 5 0 . 0 0 4 . 1 4 FN M A S t e p 8 / 2 4 / 2 0 2 1 - 1 7 3 1 3 6 G 3 V 7 7 0 8 / 2 4 / 2 0 1 6 1 . 9 8 0 5 0 0 , 0 00 . 0 0 5 0 0 , 0 0 0 . 0 0 5 0 0 , 0 0 0 . 0 0 4 9 5 , 1 0 0 . 0 0 0 8 / 2 4 / 2 0 2 1 1 , 6 0 7 5 13.89 2 . 0 7 Su b T o t a l / A v e r a g e 1. 8 6 3 2 , 4 0 0 , 0 0 0 . 0 0 2 , 4 0 0 , 0 0 0 . 0 0 2 , 4 0 0 , 0 0 0 . 0 0 2 , 3 7 4 , 5 0 5 . 00 1 , 5 7 1 5 , 0 3 2 . 6 4 9 . 9 4 Le a g u e o f M i n n e s o t a C i t i e s - 4 M F u n d L G I P L G I P 5 1 0 1 M 1 1/ 3 0 / 2 0 1 0 0 . 4 3 0 2 7 . 2 2 2 7 . 2 2 2 7 . 2 2 2 7 . 2 2 N / A 1 0 . 0 0 Le a g u e o f M i n n e s o t a C i t i e s - 4 M P l u s F u n d L G I P L G I P 5 10 1 M P 1 1 / 3 0 / 2 0 1 0 0 . 5 0 0 2 , 9 2 4 , 5 4 4 . 3 6 2 , 9 2 4 , 5 4 4 . 3 6 2 , 9 2 4 , 5 44 . 3 6 2 , 9 2 4 , 5 4 4 . 3 6 N / A 1 1 2 . 1 2 Su b T o t a l / A v e r a g e 0. 5 0 0 2 , 9 2 4 , 5 7 1 . 5 8 2 , 9 2 4 , 5 7 1 . 5 8 2 , 9 2 4 , 5 7 1 . 5 8 2 , 9 2 4 , 5 7 1 . 58 1 0 . 0 0 1 2 . 1 2 Gr a t i o t C o u n t y M I 1 9 / 1 / 2 0 1 7 3 8 8 8 2 5 E G 2 0 2 / 2 2 / 2 0 1 7 1 . 0 0 0 2 8 0 , 0 0 0 . 0 0 2 8 0 , 0 0 0 . 0 0 2 8 0 , 0 0 0 . 0 0 2 8 0 , 1 0 9 . 2 0 0 9 / 0 1 / 2 0 1 7 154 3 0 3 . 3 3 1 . 1 6 NY H S G D E V C O R P 0 . 8 5 5 / 1 / 2 0 1 7 6 4 9 7 2 C X J 7 1 0 / 1 9 / 2 0 1 6 0 . 7 92 8 9 0 , 0 0 0 . 0 0 8 9 0 , 2 7 5 . 9 0 8 9 0 , 2 7 5 . 9 0 8 8 9 , 9 1 9 . 9 0 0 5 / 0 1 / 2 0 1 7 3 1 3 , 4 2 5 . 2 6 3 . 6 9 Ro b b i n s d a l e I S D - M N 4 . 6 2 / 1 / 2 0 1 9 7 7 0 2 6 4 7 J 2 0 5 / 1 4 / 2 0 0 9 4 . 6 0 0 1 , 0 0 0 , 0 0 0 . 0 0 1 , 0 0 0 , 0 0 0 . 0 0 1 , 0 0 0 , 0 0 0 . 0 0 1 , 0 5 3 , 0 3 0 .0 0 0 2 / 0 1 / 2 0 1 9 6 7 2 7 , 6 6 6 . 6 7 4 . 1 4 Sa i n t F r a n c i s I S D - M N 4 . 4 4 / 1 / 2 0 1 7 7 8 9 4 6 6 P U 7 0 4 / 1 6 / 2 00 9 4 . 4 0 0 5 0 0 , 0 0 0 . 0 0 5 0 0 , 0 0 0 . 0 0 5 0 0 , 0 0 0 . 0 0 5 0 0 , 0 0 0 . 0 0 0 4 / 01 / 2 0 1 7 1 1 1 , 0 0 0 . 0 0 2 . 0 7 Wa s h i n g t o n C o u n t y H o u s i n g 4 . 2 5 1 / 1 / 2 0 2 0 - 1 0 9 3 7 7 9 1 K N 0 07 / 0 1 / 2 0 1 0 4 . 2 5 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 4 5 , 0 0 0 . 0 0 2 5 0 , 4 1 2. 0 5 0 1 / 0 1 / 2 0 2 0 1 , 0 0 6 2 , 6 0 3 . 1 2 1 . 0 2 Su b T o t a l / A v e r a g e 3. 0 2 8 2 , 9 1 5 , 0 0 0 . 0 0 2 , 9 1 5 , 2 7 5 . 9 0 2 , 9 1 5 , 2 7 5 . 9 0 2 , 9 7 3 , 4 7 1 . 15 3 4 0 2 4 , 9 9 8 . 3 8 1 2 . 0 8 To t a l / A v e r a g e 1. 6 7 7 2 4 , 1 3 7 , 2 5 8 . 6 4 2 4 , 1 3 7 , 5 3 4 . 5 4 2 4 , 1 3 7 , 5 3 4 . 5 4 2 4 , 2 0 6 , 75 5 . 6 0 7 4 7 6 6 , 9 5 4 . 0 9 1 0 0 FH L M C B o n d FN M A B o n d Lo c a l G o v e r n m e n t I n v e s t m e n t P o o l Mu n i c i p a l B o n d