Loading...
HomeMy WebLinkAbout5F 2016 4th Quarter Investment Report 4646 Dakota Street SE Prior Lake, MN 55372 CITY COUNCIL AGENDA REPORT MEETING DATE: MARCH 27, 2017 AGENDA #: 5F PREPARED BY: JASON ETTER, ACCOUNTANT PRESENTED BY: DON URAM, FINANCE DIRECTOR AGENDA ITEM: CONSIDER APPROVAL OF 4th QUARTER 2016 INVESTMENT REPORT DISCUSSION: Introduction The purpose of this agenda item is for the Council to consider approval of the in- vestment report for the fourth quarter of 2016. Current Circumstances Staff has prepared a list of investments as of December 31, 2016. The Investment Report 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 2016 4th 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. ATTACHMENTS: 1. Investment Report Summary Narrative 2. Investment Portfolio – Weighted Average Yield to Maturity 3. Investment Portfolio – Diversification, by Security Type 4. Investment Portfolio – Diversification, by Maturity Range 5. Investment Portfolio – Security Type 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 December 31, 2016, the balance of the investment portfolio is $26,156,983. This is an increase of $459K from September 30, 2016 due to the short-term investment of funds held at U.S. Bank. The ‘weighted average yield to maturity at cost’ of the investment portfolio is currently 1.54% which is an increase from 1.52% as of September 30. 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 December, the balance in the 4M money market was $3.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 2016 compared to the previous two years: As rates decrease, the market value of the existing securities will increase. As of December 31, 2016, the market value of the portfolio is greater than the cost of the investments by $87k. 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 4th quarter 2016; no actual gain is realized because the City holds the securities until maturity. During the fourth quarter of 2016, the chart below shows how rates, especially for mid to long-term securities, 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 12/31/14 12/31/15 12/31/16 3 As the attached chart titled Investment Portfolio – Diversification, by Maturity Range indicates, approx- imately 26% or $6.9 million matures within 1 month. Of that total, $1.1 million is bond proceeds re- served for construction projects and remainder in cash in our broker’s accounts. These funds will be invested 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 December Treasurer’s Report, the balance of cash and investments, is $27.8M. Of this balance, $26.1M is investments and $1.7M 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 10/31/16 11/30/16 12/31/16 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 12/31/2015 3/31/2016 6/30/2016 9/30/2016 12/31/2016 year prior Market Value 2,179,080 3,156,481 5,798,579 5,874,655 5,710,646 3,531,566 1 1 1 1 1 0 0.05% 0.06% 0.06% 0.06% 0.25%0.20% Fixed Income Assets 21,400,125 21,326,125 17,987,700 19,823,000 20,445,000 (955,125) 21,482,504 21,598,640 18,294,310 20,096,281 20,533,421 (949,083) 1,348 1,146 1,074 988 873 (475) 708 664 634 518 437 (271) 2.10% 1.97% 2.12% 1.95% 1.90%-0.20% Total Portfolio Value 23,579,205 24,482,606 23,786,279 25,697,655 26,155,646 2,576,441 23,661,585 24,755,121 24,092,889 25,970,936 26,244,067 2,582,482 99,404 80,548 79,372 67,230 88,612 (10,792) 82,379 272,515 306,610 273,282 87,084 4,705 1,224 998 812 763 683 (541) 642 578 479 400 342 (300) 1.91% 1.72% 1.61% 1.52% 1.54% -0.37% BENCHMARK 90 Day T-Bill 0.16% 0.21% 0.27% 0.29% 0.51% 0.35% 0.49% 0.39% 0.36% 0.47% 0.62% 0.13% 0.65% 0.59% 0.46% 0.59% 0.85% 0.20% Weighted Average Yield to Maturity @ Cost CITY OF PRIOR LAKE, MINNESOTA Quarterly Investment Report December 31, 2016 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.020 1,790,220 1 6.84% Certificate of Deposit 1.493 9,705,000 684 37.11% FHLB Bond 0.750 900,000 235 3.44% FHLMC Bond 1.961 3,490,000 1,443 13.34% FNMA Bond 1.958 2,900,000 1,579 11.09% LGIP 0.360 3,920,426 1 14.99% Municipal Bond 3.215 3,451,337 403 13.19% Total / Average 1.538 26,156,983 812 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio - Diversification, by Security Type December 31, 2016 Description City of Prior Lake - Quarterly Investment Report YTM @ Cost Cost Value Days to Maturity % of Portfolio 0-1 Month 0.350 6,944,646 5 26.55% 1-3 Months 0.723 1,392,062 57 5.32% 3-6 Months 1.892 1,835,276 114 7.02% 6-9 Months 0.822 1,737,000 237 6.64% 9-12 Months 1.113 983,000 288 3.76% 1-2 Years 2.282 2,218,000 571 8.48% 2-3 Years 3.068 2,821,000 917 10.78% 3-4 Years 2.143 2,930,000 1,372 11.20% 4-5 Years 2.066 5,051,000 1,666 19.31% 5-10 Years 1.500 245,000 2,280 0.94% Total / Average 1.538 26,156,983 683 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio - Diversification, by Maturity Range December 31, 2016 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 1 0 6 5 5 , 9 9 0 . 0 3 6 5 5 , 9 9 0 . 0 3 6 5 5 , 9 9 0 . 0 3 6 5 5 , 9 9 0 . 0 3 N / A 1 2 . 5 1 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 6 5 8 , 4 1 6 . 4 3 6 5 8 , 4 1 6 . 4 3 6 5 8 , 4 1 6 . 43 6 5 8 , 4 1 6 . 4 3 N / A 1 2 . 5 2 We l l s F a r g o A d v i s o r s C a s h C A S H 4 2 8 5 1 2 / 2 7 / 2 0 1 1 0 . 0 6 0 4 7 5 ,8 1 3 . 5 6 4 7 5 , 8 1 3 . 5 6 4 7 5 , 8 1 3 . 5 6 4 7 5 , 8 1 3 . 5 6 N / A 1 1 . 8 2 Su b T o t a l / A v e r a g e 0. 0 2 0 1 , 7 9 0 , 2 2 0 . 0 2 1 , 7 9 0 , 2 2 0 . 0 2 1 , 7 9 0 , 2 2 0 . 0 2 1 , 7 9 0 , 2 2 0 . 02 1 0 . 0 0 6 . 8 4 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 .0 0 2 4 4 , 2 5 5 . 2 0 0 8 / 2 0 / 2 0 1 8 5 9 7 8 4 . 5 8 0 . 9 4 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 /0 1 / 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 , 9 8 7 . 2 0 0 9 /0 3 / 2 0 1 9 9 7 6 3 9 7 . 8 1 0 . 3 7 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 28 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 8 , 17 0 . 3 0 0 7 / 1 7 / 2 0 1 9 9 2 8 2 , 1 8 5 . 8 7 0 . 9 4 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 , 00 0 . 0 0 2 4 8 , 7 6 5 . 6 5 1 2 / 1 1 / 2 0 1 9 1 , 0 7 5 2 9 5 . 3 4 0 . 9 4 Ba n c o f C a l i f o r n i a , I r v i n e C A 0 . 5 2 / 1 5 / 2 0 1 7 0 5 9 6 1 S H Q 0 3 5 , 4 9 8 0 9 / 1 6 / 2 0 1 6 0 . 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 4 , 9 3 1 . 4 0 0 2 / 1 5 / 2 0 1 7 4 6 3 5 5 . 7 5 0 . 9 4 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 3, 6 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 47 , 8 3 8 . 8 0 0 8 / 3 1 / 2 0 1 7 2 4 3 6 6 3 . 1 5 0 . 9 5 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 24 4 , 5 9 5 . 7 5 0 9 / 2 2 / 2 0 1 7 2 6 5 4 2 . 9 6 0 . 9 4 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 1 , 7 1 7 . 0 0 0 3 / 3 0 /2 0 2 3 2 , 2 8 0 1 0 . 0 7 0 . 9 4 Ba r c l a y s B a n k - D E 1 . 9 1 / 1 9 / 2 0 1 7 0 6 7 4 0 K F X 0 5 7 , 2 0 3 0 1 / 1 9/ 2 0 1 2 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 5 , 1 4 9 . 4 5 01 / 1 9 / 2 0 1 7 1 9 2 , 1 0 4 . 3 2 0 . 9 4 Bl u e H i l l s B a n k , B o s t o n M A 0 . 5 5 2 / 1 6 / 2 0 1 7 0 9 5 5 7 7 D E 9 9 0, 1 6 0 0 9 / 1 6 / 2 0 1 6 0 . 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 44 , 9 3 6 . 3 0 0 2 / 1 6 / 2 0 1 7 4 7 3 9 1 . 3 3 0 . 9 4 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 6, 5 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 45 , 1 6 6 . 6 0 0 4 / 1 7 / 2 0 1 7 1 0 7 4 4 5 . 0 3 0 . 9 4 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 8 , 0 3 8 . 0 0 12 / 1 1 / 2 0 1 8 7 1 0 2 8 1 . 9 2 0 . 9 4 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 WD 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 .0 0 2 4 9 , 2 8 9 . 9 5 0 9 / 3 0 / 2 0 2 0 1 , 3 6 9 1 , 3 8 9 . 4 5 0 . 9 4 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 97 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 , 74 6 . 8 5 0 9 / 2 4 / 2 0 1 8 6 3 2 1 , 0 9 6 . 4 6 0 . 9 4 Ci t i z e n s P h i l a d e l p h i a P A 0 . 5 1 / 2 6 / 2 0 1 7 1 7 4 1 7 Q C V 3 5 7 , 2 82 1 0 / 2 6 / 2 0 1 6 0 . 5 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 , 99 2 . 5 6 0 1 / 2 6 / 2 0 1 7 2 6 2 2 4 . 2 2 0 . 9 5 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 . 00 2 5 2 , 2 3 9 . 7 5 1 1 / 2 4 / 2 0 2 1 1 , 7 8 9 8 7 . 2 6 0 . 9 4 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 49 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 8 , 08 7 . 0 0 1 2 / 1 1 / 2 0 1 8 7 1 0 2 6 8 . 4 9 0 . 9 4 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 /2 0 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 9 , 4 1 0 . 0 0 0 8/ 2 8 / 2 0 2 0 1 , 3 3 6 1 , 8 8 7 . 8 4 0 . 9 4 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 4, 7 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 45 , 3 7 7 . 3 0 0 9 / 2 9 / 2 0 1 7 2 7 2 6 7 9 . 2 9 0 . 9 4 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 0 8 / 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 7 , 6 28 . 0 0 0 8 / 1 6 / 2 0 1 7 2 2 8 7 6 . 4 4 0 . 9 5 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 , 1 6 3 .6 8 1 0 / 1 0 / 2 0 1 7 2 8 3 6 4 8 . 5 4 0 . 9 5 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 /1 3 / 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 , 5 2 2 . 2 4 0 7 /1 3 / 2 0 1 7 1 9 4 8 0 9 . 5 6 0 . 3 7 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 4 , 3 9 5 .0 0 0 7 / 1 9 / 2 0 2 1 1 , 6 6 1 1 , 7 3 9 . 5 9 0 . 5 7 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 , 31 4 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 , 9 3 9 .5 2 0 3 / 2 9 / 2 0 2 1 1 , 5 4 9 6 5 5 . 1 7 0 . 3 7 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 13 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 3 , 4 3 6 . 5 0 0 9 / 2 1/ 2 0 2 0 1 , 3 6 0 1 , 0 8 9 . 8 6 0 . 5 7 Go l d m a n S a c h s B a n k U S A - N Y 1 . 6 5 2 / 2 8 / 2 0 1 7 3 8 1 4 3 A K Z 7 33 , 1 2 4 0 2 / 2 9 / 2 0 1 2 1 . 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 6 , 16 3 . 2 0 0 2 / 2 8 / 2 0 1 7 5 9 5 3 8 . 1 3 0 . 3 7 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 , 9 0 6 .5 0 1 2 / 1 8 / 2 0 1 9 1 , 0 8 2 1 1 3 . 4 4 0 . 9 4 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 5 , 1 1 0 . 2 5 02 / 1 9 / 2 0 2 1 1 , 5 1 1 8 9 9 . 4 5 0 . 9 4 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 9 , 2 7 4 . 7 2 06 / 2 9 / 2 0 1 8 5 4 5 9 . 8 5 0 . 9 5 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 2, 9 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 47 , 7 7 5 . 8 5 0 8 / 2 9 / 2 0 1 8 6 0 6 1 , 5 9 4 . 1 8 0 . 9 4 Me r r i c k B a n k S o J o r d a n U T 0 . 9 3 / 3 0 / 2 0 1 7 5 9 0 1 3 J J R 1 3 4 , 51 9 0 9 / 3 0 / 2 0 1 5 0 . 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 5 ,1 4 7 . 0 0 0 3 / 3 0 / 2 0 1 7 8 9 6 . 0 4 0 . 9 4 Mi z r a h i T e f a h o t L A , C A 0 . 5 1 / 2 4 / 2 0 1 7 6 0 6 8 5 7 3 K 4 3 3 , 6 6 1 10 / 2 4 / 2 0 1 6 0 . 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 4 , 9 9 5. 1 0 0 1 / 2 4 / 2 0 1 7 2 4 2 2 8 . 2 2 0 . 9 4 MI Z U H O B A N K U S A 0 . 6 1 / 2 0 / 2 0 1 7 6 0 6 8 8 M V F 8 2 1 , 8 4 3 0 7 / 2 0 / 2 01 6 0 . 6 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 8 2 . 6 4 0 1 / 20 / 2 0 1 7 2 0 6 6 8 . 5 8 0 . 9 5 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 .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 8 , 1 5 0 . 7 0 0 8 / 2 7 / 2 01 9 9 6 9 1 , 7 7 6 . 0 8 0 . 9 4 Pa c i f i c W e s t e r n B k , B e v e r l y H i l l s C A 0 . 6 3 / 1 6 / 2 0 1 7 6 95 0 6 Y D D 8 2 4 , 0 4 5 0 9 / 1 6 / 2 0 1 6 0 . 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 4 , 9 0 4 . 4 5 0 3 / 1 6 / 2 0 1 7 7 5 4 2 6 . 9 0 0 . 9 4 RB S C i t i z e n s P r o v i d e n c e R I 0 . 5 1 / 2 6 / 2 0 1 7 7 5 5 2 4 K F T 6 5 7 ,9 5 7 1 0 / 2 6 / 2 0 1 6 0 . 5 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 9 2 . 5 6 0 1 / 2 6 / 2 0 1 7 2 6 2 2 4 . 2 2 0 . 9 5 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 8, 1 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 46 , 5 1 6 . 5 5 1 0 / 2 4 / 2 0 1 7 2 9 7 6 8 4 . 6 6 0 . 9 4 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 ,6 8 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 5 0, 6 4 9 . 7 0 1 2 / 0 6 / 2 0 2 1 1 , 8 0 1 4 5 3 . 7 5 0 . 9 4 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 / 27 / 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 , 0 1 2 . 2 5 1 0 / 2 7 / 2 0 1 7 3 0 0 3 0 5 . 4 1 0 . 9 4 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 De c e m b e r 3 1 , 2 0 1 6 Ca s h Ce r t i f i c a t e O f D e p o s i t We 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 , 8 7 4 . 6 0 09 / 1 7 / 2 0 2 1 1 , 7 2 1 1 3 5 . 2 5 0 . 9 4 We l l s F a r g o B a n k , S D S t e p 3 / 2 9 / 2 0 2 1 - 1 7 9 4 9 8 6 T P U 5 3 , 5 1 1 0 3 / 2 8 / 2 0 1 4 3 . 0 1 9 2 2 5 , 0 0 0 . 0 0 2 2 5 , 0 0 0 . 0 0 2 2 5 , 0 0 0 . 0 0 2 2 5 , 3 26 . 2 5 0 3 / 2 9 / 2 0 2 1 1 , 5 4 9 2 4 . 0 4 0 . 8 6 WE 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 00 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 3 , 6 9 1 . 7 0 0 7 / 0 9 / 2 0 1 8 5 5 5 1 , 1 8 1 . 3 7 0 . 9 4 Wo 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 , 9 1 2 .0 0 0 5 / 3 1 / 2 0 1 7 1 5 1 0 . 0 0 0 . 7 6 Su b T o t a l / A v e r a g e 1. 4 9 3 9 , 7 0 5 , 0 0 0 . 0 0 9 , 7 0 5 , 0 0 0 . 0 0 9 , 7 0 5 , 0 0 0 . 0 0 9 , 7 5 2 , 1 6 6 . 02 684 2 7 , 1 7 9 . 8 7 3 7 . 1 0 FH L B 0 . 7 5 8 / 2 3 / 2 0 1 7 - 1 6 31 3 0 A 9 2 C 4 0 8 / 2 3 / 2 0 1 6 0 . 7 5 0 9 0 0 , 0 0 0 . 0 0 9 0 0 , 0 0 0 . 0 0 9 0 0 , 0 0 0 .0 0 8 9 9 , 3 7 0 . 0 0 0 8 / 2 3 / 2 0 1 7 2 3 5 2 , 4 0 0 . 0 0 3 . 4 4 Su b T o t a l / A v e r a g e 0. 7 5 0 9 0 0 , 0 0 0 . 0 0 9 0 0 , 0 0 0 . 0 0 9 0 0 , 0 0 0 . 0 0 8 9 9 , 3 7 0 . 0 0 235 2 , 4 0 0 . 0 0 3 . 4 4 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 , 7 9 2 , 8 9 9 . 8 0 1 1 / 3 0 / 2 0 2 0 1 , 4 3 0 2 , 9 8 3 . 3 3 6 . 8 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 6 , 0 0 0 . 0 0 0 6 / 3 0 / 2 0 2 1 1 , 6 4 2 0.00 1 . 9 1 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 , 9 0 0 . 0 0 0 7 / 2 6 / 2 0 1 9 9 3 7 1 , 614.58 1 . 9 1 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 5 , 6 6 0 . 0 0 0 8 / 2 4 / 2 0 2 1 1 , 6 9 7 2,592.92 2 . 6 8 Su b T o t a l / A v e r a g e 1. 9 6 1 3 , 4 9 0 , 0 0 0 . 0 0 3 , 4 9 0 , 0 0 0 . 0 0 3 , 4 9 0 , 0 0 0 . 0 0 3 , 4 8 4 , 4 5 9 . 80 1 , 4 4 3 7 , 1 9 0 . 8 3 1 3 . 3 4 FN M A S t e p 3 / 3 0 / 2 0 2 0 - 1 6 3 1 3 6 G 3 D F 9 0 3 / 3 0 / 2 0 1 6 2 . 4 1 2 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 0 0 . 0 0 0 3 / 3 0 / 2 0 2 0 1 , 1 8 5 1 ,250.00 1 . 9 1 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 , 3 3 5 . 0 0 0 5 / 2 5 / 2 0 2 1 1 , 6 0 6 5 62.50 1 . 9 1 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 5 , 0 8 0 . 0 0 0 7 / 1 9 / 2 0 2 1 1 , 6 6 1 1 ,800.00 1 . 5 3 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 9 , 7 0 0 . 0 0 0 7 / 2 8 / 2 0 2 1 1,670 4 , 2 5 0 . 0 0 3 . 8 2 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 6 , 7 0 0 . 0 0 0 8 / 2 4 / 2 0 2 1 1 , 6 9 7 1 ,763.89 1 . 9 1 Su b T o t a l / A v e r a g e 1. 9 5 8 2 , 9 0 0 , 0 0 0 . 0 0 2 , 9 0 0 , 0 0 0 . 0 0 2 , 9 0 0 , 0 0 0 . 0 0 2 , 8 8 0 , 5 1 5 . 00 1 , 5 7 9 9 , 6 2 6 . 3 9 1 1 . 0 9 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 . 2 6 0 2 . 8 3 2 . 8 3 2 . 8 3 2 . 8 3 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 F u n d L G I P L G I P 5 2 0 3 M 0 5/ 2 6 / 2 0 1 6 0 . 2 6 0 1 . 9 1 1 . 9 1 1 . 9 1 1 . 9 1 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 . 3 6 0 3 , 9 2 0 , 4 2 0 . 7 9 3 , 9 2 0 , 4 2 0 . 7 9 3 , 9 2 0 , 4 20 . 7 9 3 , 9 2 0 , 4 2 0 . 7 9 N / A 1 1 4 . 9 9 Su b T o t a l / A v e r a g e 0. 3 6 0 3 , 9 2 0 , 4 2 5 . 5 3 3 , 9 2 0 , 4 2 5 . 5 3 3 , 9 2 0 , 4 2 5 . 5 3 3 , 9 2 0 , 4 2 5 . 53 1 0 . 0 0 1 4 . 9 9 An o k a - H e n n I S D 1 1 2 2 / 1 / 2 0 1 7 0 3 6 3 0 3 2 C 8 1 0 / 2 7 / 2 0 1 6 0 . 7 0 7 3 1 5 , 0 0 0 . 0 0 3 1 6 , 0 6 1 . 5 5 3 1 5 , 3 5 0 . 2 0 3 1 5 , 2 0 7 . 9 0 0 2 / 0 1 / 2 0 1 7 32 1 , 1 2 0 . 0 0 1 . 2 0 Au r o r a I S D - M N 4 . 6 5 2 / 1 / 2 0 1 8 - 1 7 0 5 1 8 2 0 C S 5 0 2 / 1 2 / 2 0 0 9 4. 6 5 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 1 , 5 3 5 . 0 0 0 2 / 0 1 / 20 1 8 3 9 7 9 , 6 8 7 . 5 0 1 . 9 1 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 , 1 7 2 . 0 8 8 8 8 , 4 8 7 . 0 0 0 5 / 0 1 / 2 0 1 7 1 2 1 1 , 5 3 4 . 0 1 3 . 4 0 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 7 , 9 0 0 .0 0 0 2 / 0 1 / 2 0 1 9 7 6 2 1 9 , 1 6 6 . 6 7 3 . 8 2 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 3 , 3 0 5 . 0 0 0 4 / 01 / 2 0 1 7 9 1 5 , 5 0 0 . 0 0 1 . 9 1 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 7 5. 7 5 0 1 / 0 1 / 2 0 2 0 1 , 0 9 6 5 , 2 0 6 . 2 5 0 . 9 4 Su b T o t a l / A v e r a g e 3. 2 1 6 3 , 4 5 0 , 0 0 0 . 0 0 3 , 4 5 1 , 3 3 7 . 4 5 3 , 4 5 0 , 5 2 2 . 2 8 3 , 5 1 6 , 9 1 0 . 65 404 4 2 , 2 1 4 . 4 3 1 3 . 1 9 To t a l / A v e r a g e 1. 5 3 8 2 6 , 1 5 5 , 6 4 5 . 5 5 2 6 , 1 5 6 , 9 8 3 . 0 0 2 6 , 1 5 6 , 1 6 7 . 8 3 2 6 , 2 4 4 , 06 7 . 0 2 683 8 8 , 6 1 1 . 5 2 1 0 0 Mu n i c i p a l B o n d FH L B B o n d 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