Loading...
HomeMy WebLinkAbout5B 2016 3rd Quarter Investment Report 4646 Dakota Street SE Prior Lake, MN 55372 CITY COUNCIL AGENDA REPORT MEETING DATE: NOVEMBER 28, 2016 AGENDA #: 5B PREPARED BY: DON URAM, FINANCE DIRECTOR PRESENTED BY: DON URAM AGENDA ITEM: CONSIDER APPROVAL OF 3rd 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 third quarter of 2016. Current Circumstances Staff has prepared a list of investments as of September 30, 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. A motion as part of the consent agenda to approve the 2016 3rd Quarter In- vestment Report as submitted. 2. Remove this item from the consent agenda for 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 September 30, 2016, the balance of the investment portfolio is $25,697,655. This is an increase of $1.9M from June 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.52% which is a decrease from 1.61% as of June 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 September, the balance in the 4M money market was $1.7M. 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 September 30, 2016, the market value of the portfolio is greater than the cost of the investments by $273k. 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 3rd quarter 2016; no actual gain is realized because the City holds the securities until maturity. During the third quarter of 2016, the chart below shows how rates, especially for mid to long-term se- curities, 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 9/30/14 9/30/15 9/30/16 3 As the attached chart titled Investment Portfolio – Diversification, by Maturity Range indicates, approx- imately 26% or $6.6 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 September Treasurer’s Report, the balance of cash and investments, is $28.6M. Of this balance, $25.6M is investments and $2.9M 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 1 MO 3 MO 6 MO 1 YR 2 YR 3 YR 5 YR 7 YR 10 YR US TREASURY YIELD CURVE 7/31/16 8/31/16 9/30/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 09/30/2015 12/31/2015 03/31/2016 06/30/2016 09/30/2016 year prior Market Value 6,701,415 2,179,080 3,156,481 5,798,579 5,874,655 (826,760) 1 1 1 1 1 0 0.05%0.05%0.06%0.06%6.20%6.15% Fixed Income Assets 21,525,125 21,400,125 21,326,125 17,987,700 19,823,000 (1,702,125) 21,743,809 21,482,504 21,598,640 18,294,310 20,096,281 (1,647,528) 1,483 1,348 1,146 1,074 988 (495) 747 708 664 634 518 (229) 2.13%2.10%1.97%2.12%1.95%-0.18% Total Portfolio Value 28,226,540 23,579,205 24,482,606 23,786,279 25,697,655 (2,528,885) 28,445,224 23,661,585 24,755,121 24,092,889 25,970,936 (2,474,288) 83,438 99,404 80,548 79,372 67,230 (16,208) 218,684 82,379 272,515 306,610 273,282 54,598 1,131 1,224 998 812 763 (368) 570 642 578 479 400 (170) 1.64%1.91%1.72%1.61%1.52%-0.12% BENCHMARK 90 Day T-Bill 0.00%0.16%0.21%0.27%0.29%0.29% 0.08%0.49%0.39%0.36%0.47%0.39% 0.33%0.65%0.59%0.46%0.59%0.26% Don Uram, Finance Director Weighted Average Yield to Maturity @ Cost CITY OF PRIOR LAKE, MINNESOTA Quarterly Investment Report September 30, 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 ‐           4,207,191           1                   16.37% Certificate of Deposit 1.483       10,288,000        740               40.03% FHLB Bond 0.750       900,000              327               3.50% FHLMC Bond 1.961       3,490,000           1,535            13.58% FNMA Bond 1.958       2,900,000           1,671            11.29% LGIP 0.220       1,667,463           1                   6.49% Municipal Bond 4.528       2,245,000           660               8.74% Total / Average 1.517 25,697,654 763               100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio ‐ Diversification, by Security Type September 30, 2016 Description City of Prior Lake ‐ Quarterly Investment Report YTM @  Cost Cost Value Days to  Maturity % of  Portfolio 0‐1 Month 0.143      6,612,654          3                    25.73% 1‐3 Months 0.775      490,000             82                  1.91% 3‐6 Months 0.889      1,324,000          135                5.15% 6‐9 Months 2.512      1,190,000          196                4.63% 9‐12 Months 0.857      1,982,000          333                7.71% 1‐2 Years 1.979      2,466,000          553                9.60% 2‐3 Years 2.945      2,576,000          922                10.02% 3‐4 Years 2.510      1,971,000          1,294             7.67% 4‐5 Years 2.006      6,351,000          1,681             24.71% 5‐10 Years 2.233      735,000             2,049             2.86% Total / Average 1.517 25,697,654       763                100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio ‐ Diversification, by Maturity Range September 30, 2016 Description City of Prior Lake ‐ Quarterly Investment Report De s c r i p t i o n C U S I P / T i c k e r S e c u r i t y T y p e S e t t l e m e n t D a t e Y T M @ C o s t F a 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 % o f P o r t f o l i o 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 L o 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 5 / 2 6 / 2 0 1 6 0 . 2 0 0 1 , 1 1 7 , 9 1 6 . 4 3 1 , 1 1 7 , 9 1 6 . 4 3 1 , 1 1 7 , 9 16.43 1 , 1 1 7 , 9 1 6 . 4 3 4 . 3 5 Su b T o t a l / A v e r a g e 0. 2 0 0 1 , 1 1 7 , 9 1 6 . 4 3 1 , 1 1 7 , 9 1 6 . 4 3 1 , 1 1 7 , 9 1 6 . 4 3 1 , 1 1 7 , 9 1 6 . 4 3 4 . 3 5 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 1 0 1 B L o 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 1 1 / 3 0 / 2 0 1 0 0 . 2 6 0 5 4 9 , 5 4 6 . 6 6 5 4 9 , 5 4 6 . 6 6 5 4 9 , 5 46.66 5 4 9 , 5 4 6 . 6 6 2 . 1 4 Su b T o t a l / A v e r a g e 0. 2 6 0 5 4 9 , 5 4 6 . 6 6 5 4 9 , 5 4 6 . 6 6 5 4 9 , 5 4 6 . 6 6 5 4 9 , 5 4 6 . 6 6 2 . 1 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 A G 4 C e r t i f i c a t e O f D e p o s i t 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 5 , 5 5 8 .60 0 . 9 5 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 C e r t i f i c a t e O f D e p o s i t 9 / 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 5 , 9 9 3 . 2 8 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 C e r t i f i c a t e O f D e p o s i t 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 5 1 , 1 0 7 . 8 5 0 . 9 5 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 8 7 D W X 2 C e r t i f i c a t e O f D e p o s i t 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 0 0 . 0 0 2 5 2 ,247.10 0 . 9 5 Ba n k B a r o d a N Y , N Y 1 1 2 / 1 3 / 2 0 1 6 0 6 0 6 2 A C A 5 C e r t i f i c a t e O f D e p o s i t 1 2 / 1 3 / 2 0 1 3 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 5 , 2 4 0 . 1 0 0 . 9 5 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 C e r t i f i c a t e O f D e p o s i t 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 8 , 1 0 9 . 1 2 0 .97 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 C e r t i f i c a t e O f D e p o s i t 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 6 , 0 2 4 . 1 0 0 . 9 5 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 C e r t i f i c a t e O f D e p o s i t 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 , 9 9 2 . 2 5 0 . 9 5 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 C e r t i f i c a t e O f D e p o s i t 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 , 4 2 8 . 7 5 0.95 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 C e r t i f i c a t e O f D e p o s i t 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 5 0 , 2 7 4 . 8 5 0 . 9 5 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 C e r t i f i c a t e O f D e p o s i t 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 5 4 , 0 0 3 .75 0 . 9 5 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 C e r t i f i c a t e O f D e p o s i t 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 8 , 5 4 0 . 2 5 0 . 9 5 CI T B a n k S L C 1 . 8 3 / 1 3 / 2 0 2 0 - 1 3 1 7 2 8 4 A 6 Q 6 C e r t i f i c a t e O f D e p o s i t 3 / 1 3 / 2 0 1 3 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 , 0 2 8 . 8 0 0 . 3 7 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 N 7 C e r t i f i c a t e O f D e p o s i t 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 9 , 1 9 0 .40 0 . 9 5 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 C e r t i f i c a t e O f D e p o s i t 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 5 0 , 3 3 6 . 1 0 0 . 95 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 C e r t i f i c a t e O f D e p o s i t 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 5 4 , 0 0 3 . 7 5 0 . 9 5 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 C e r t i f i c a t e O f D e p o s i t 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 6 , 0 6 0 . 8 5 0 .95 FI R S T B A N K C D S A N T U R C E P R 1 . 1 5 1 0 / 2 6 / 2 0 1 6 3 3 7 6 4 J N H 4 C e r t i f i c a t e O f D e p o s i t 1 0 / 2 6 / 2 0 1 2 1 . 1 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 9 8 . 0 0 0 .95 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 F N M A B o n d 5 / 2 5 / 2 0 1 6 2 . 0 1 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 , 3 1 0 . 0 0 1 . 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 C e r t i f i c a t e O f D e p o s i t 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 , 8 7 3 . 6 0 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 C e r t i f i c a t e O f D e p o s i t 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 8 , 2 5 0 . 0 0 0 . 5 8 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 C e r t i f i c a t e O f D e p o s i t 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 1 0 1 , 1 9 8 . 4 0 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 C e r t i f i c a t e O f D e p o s i t 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 6 , 3 4 5 . 0 0 0 . 5 8 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 C e r t i f i c a t e O f D e p o s i t 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 , 4 3 3 . 9 2 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 C e r t i f i c a t e O f D e p o s i t 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 6 , 6 8 0 . 7 0 0 . 9 5 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 C e r t i f i c a t e O f D e p o s i t 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 , 4 2 6 . 3 0 0 . 9 5 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 C e r t i f i c a t e O f D e p o s i t 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 5 0 , 7 3 7 . 9 2 0 . 9 7 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 C e r t i f i c a t e O f D e p o s i t 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 9 , 6 5 2 . 5 5 0 .95 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 C e r t i f i c a t e O f D e p o s i t 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 , 3 9 2 . 0 0 0 . 9 5 Mo r g a n S t a n l e y C a s h C A S H 5 0 8 9 C a s h 1 2 / 3 1 / 2 0 1 0 0 . 0 0 0 1 , 0 3 9 , 8 8 9 . 4 8 1 , 0 3 9 , 8 8 9 . 4 8 1 , 0 3 9 , 8 8 9 . 4 8 1 , 0 3 9 , 8 8 9 . 4 8 4 . 0 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 C e r t i f i c a t e O f D e p o s i t 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 5 1 , 2 5 4 . 8 5 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 C e r t i f i c a t e O f D e p o s i t 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 7 , 4 0 3 . 4 5 0.95 sa n t a n d e r W i l m i n g t o n D E 0 . 6 1 0 / 1 4 / 2 0 1 6 8 0 2 8 0 J J H 5 C e r t i f i c a t e O f D e p o s i t 1 0 / 1 4 / 2 0 1 5 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 5 , 0 0 9 . 8 0 0 . 9 5 Ci t y o f P r i o r L a k e In v e s t m e n t P o r t f o l i o - D e t a i l b y B r o k e r Mo r g a n S t a n l e y - S m i t h B a r n e y As o f 9 / 3 0 / 2 0 1 6 20 1 6 A B o n d F u n d Le a g u e o f M i n n e s o t a C i t i e s 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 C e r t i f i c a t e O f D e p o s i t 1 2 / 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 7 , 5 2 4 . 4 0 0 . 95 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 C e r t i f i c a t e O f D e p o s i t 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 , 4 5 3 . 2 5 0 . 9 5 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 C e r t i f i c a t e O f D e p o s i t 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 4 5 , 4 7 2 . 8 5 0 . 9 5 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 C e r t i f i c a t e O f D e p o s i t 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 , 7 9 6 . 5 0 0 . 8 8 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 C e r t i f i c a t e O f D e p o s i t 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 1 , 3 4 4 . 0 0 0 . 7 8 Su b T o t a l / A v e r a g e 1. 5 4 9 9 , 3 6 5 , 8 8 9 . 4 8 9 , 3 6 5 , 8 8 9 . 4 8 9 , 3 6 5 , 8 8 9 . 4 8 9 , 4 8 5 , 6 8 6 . 8 7 3 6 . 4 5 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 M u n i c i p a l B o n d 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 6 , 2 3 0 . 0 0 1 . 9 5 Ca r d i n a l B k 0 . 5 5 1 2 / 2 9 / 2 0 1 6 1 4 1 4 7 V F V 3 C e r t i f i c a t e O f D e p o s i t 3 / 2 9 / 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 4 5 , 0 3 4 . 3 0 0 . 9 5 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 C a s h 6 / 3 0 / 2 0 1 2 0 . 0 0 0 2 , 3 3 8 , 1 1 1 . 5 6 2 , 3 3 8 , 1 1 1 . 5 6 2 , 3 3 8 , 1 1 1 . 5 6 2 , 3 3 8 , 1 1 1 . 5 6 9 . 1 0 FH L M C 2 1 1 / 3 0 / 2 0 2 0 3 1 3 4 G 3 V F 4 F H L M C B o n d 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 9 0 , 0 0 0 . 0 0 1 , 8 4 8 , 1 2 1 . 3 0 6 . 9 7 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 M u n i c i p a l B o n d 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 7 6 , 8 6 0 . 0 0 3 . 8 9 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 M u n i c i p a l B o n d 4 / 1 6 / 2 0 0 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 7 , 5 2 5 . 0 0 1 . 9 5 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 M u n i c i p a l B o n d 7 / 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 6 , 3 5 0 . 8 5 0 . 9 5 Su b T o t a l / A v e r a g e 2. 0 9 7 6 , 6 1 8 , 1 1 1 . 5 6 6 , 6 1 8 , 1 1 1 . 5 6 6 , 6 1 8 , 1 1 1 . 5 6 6 , 7 7 8 , 2 3 3 . 0 1 2 5 . 7 5 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 C e r t i f i c a t e O f D e p o s i t 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 , 7 8 1 . 9 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 C e r t i f i c a t e O f D e p o s i t 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 4 4 , 6 3 7 . 4 0 0.95 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 C e r t i f i c a t e O f D e p o s i t 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 4 4 , 8 1 6 . 2 5 0 .95 FH L B 0 . 7 5 8 / 2 3 / 2 0 1 7 - 1 6 3 1 3 0 A 9 2 C 4 F H L B B o n d 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 , 6 4 0 . 0 0 3 . 5 0 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 F H L M C B o n d 6 / 3 0 / 2 0 1 6 2 . 2 4 6 5 0 0 , 0 0 0 . 0 0 5 0 0 , 0 0 0 . 0 0 5 0 0 , 0 0 0 . 0 0 4 9 8 , 2 5 0 . 0 0 1 . 9 5 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 F H L M C B o n d 7 / 2 6 / 2 0 1 6 1 . 7 3 7 5 0 0 , 0 0 0 . 0 0 5 0 0 , 0 0 0 . 0 0 5 0 0 , 0 0 0 . 0 0 4 9 9 , 6 0 0 . 0 0 1 . 9 5 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 F H L M C B o n d 8 / 2 4 / 2 0 1 6 1 . 8 1 5 7 0 0 , 0 0 0 . 0 0 7 0 0 , 0 0 0 . 0 0 7 0 0 , 0 0 0 . 0 0 7 0 0 , 2 1 0 . 0 0 2 . 7 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 C e r t i f i c a t e O f D e p o s i t 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 4 0 . 4 0 0 . 9 7 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 C e r t i f i c a t e O f D e p o s i t 1 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 6 1 . 2 8 0 . 9 7 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 F N M A B o n d 3 / 3 0 / 2 0 1 6 2 . 4 1 2 5 0 0 , 0 0 0 . 0 0 5 0 0 , 0 0 0 . 0 0 5 0 0 , 0 0 0 . 0 0 4 9 8 , 4 5 0 . 0 0 1 . 9 5 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 F N M A B o n d 7 / 1 9 / 2 0 1 6 1 . 7 3 3 4 0 0 , 0 0 0 . 0 0 4 0 0 , 0 0 0 . 0 0 4 0 0 , 0 0 0 . 0 0 3 9 8 , 7 2 0 . 0 0 1 . 5 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 F N M A B o n d 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 1 , 0 0 0 , 0 0 0 . 0 0 3 . 8 9 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 F N M A B o n d 8 / 2 4 / 2 0 1 6 1 . 9 8 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 , 1 0 0 . 0 0 1 . 9 5 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 C e r t i f i c a t e O f D e p o s i t 7 / 2 0 / 2 0 1 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 0 5 . 7 6 0 . 9 7 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 9 5 0 6 Y D D 8 C e r t i f i c a t e O f D e p o s i t 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,811.35 0 . 9 5 Sa f r a N a t i o n a l B K o f N Y 0 . 6 1 0 / 1 4 / 2 0 1 6 7 8 6 5 8 Q R B 1 C e r t i f i c a t e O f D e p o s i t 1 0 / 1 5 / 2 0 1 5 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 9 5 . 0 4 0 . 9 7 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 C a s h 1 2 / 2 7 / 2 0 1 1 0 . 0 0 0 8 2 9 , 1 9 0 . 5 6 8 2 9 , 1 9 0 . 5 6 8 2 9 , 1 9 0 . 5 6 8 2 9 , 1 9 0 . 5 6 3 . 2 3 WE X B A N K , U T 1 7 / 9 / 2 0 1 8 9 2 9 3 7 C D R 6 C e r t i f i c a t e O f D e p o s i t 7 / 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 , 3 4 3 . 4 0 0 . 9 5 Su b T o t a l / A v e r a g e 1. 2 7 1 8 , 0 4 6 , 1 9 0 . 5 6 8 , 0 4 6 , 1 9 0 . 5 6 8 , 0 4 6 , 1 9 0 . 5 6 8 , 0 3 9 , 5 5 3 . 3 9 3 1 . 3 1 To t a l / A v e r a g e 1. 5 1 7 2 5 , 6 9 7 , 6 5 4 . 6 9 2 5 , 6 9 7 , 6 5 4 . 6 9 2 5 , 6 9 7 , 6 5 4 . 6 9 2 5 , 9 7 0 , 9 3 6 . 3 6 1 0 0 No r t h l a n d S e c u r i t i e s We l l s F a r g o A d v i s o r s