The URL can be used to link to this page

Home My WebLink About05(L) - Approval of 2nd Quarter 2020 Investment Report Report 4646 Dakota Street SE Prior Lake, MN 55372 INVESTMENT REPORT SUMMARY NARRATIVE The attached “Investment Portfolio – by Security Type” identifies the various types of investments and the brokers/banks the City of Prior Lake uses for investment purposes. As of June 30, 2020, the balance of the investment portfolio is $36,484,987. This is an increase of $2.3M from March 31, 2020. The ‘weighted average yield to maturity at cost’ of the investment portfolio is currently 1.49% which is a decrease from 1.78% as of March 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 June, the balance in the 4M money market was $9.5M. The City received the 1st half prop- erty tax settlement of $7.6M on June 19, and the funds are being held in the 4M investment pool until they can be invested, where needed, on the City’s five-year investment maturity ladder. 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 2nd quarter of 2020 compared to the previous two years: As rates decrease, the market value of the existing securities will increase. As of June 30, 2020, the market value of the portfolio is more than the cost of the investments by $775K. 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 second quarter of 2020; no actual gain is realized because the City holds the securities until maturity. 2 During the second quarter of 2020, the chart below shows how rates are showing a decrease, espe- cially short to mid-term securities. Current long-term rates being offered by financial institutions contin- ues to be very low. As the attached chart titled Investment Portfolio – Diversification, by Maturity Range indicates, approx- imately 36% or $13.1M matures within 1 month. Of that total, $9.5M is in the 4M investment pool. The City received the 1st half property tax settlement of $7.6M on June 19 and the funds are being held in the 4M investment pool. These funds will be invested as the appropriate security (type, rate, and ma- turity) becomes available. Staff continues to look for opportunities to invest our short-term funds. The City’s investment portfolio amount is a pool of funds identified on the monthly Treasurer’s Report. As shown on the June Treasurer’s Report, the balance of cash and investments, is $37.1M. Of this balance, $36.4M is investments and $700K 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; 3 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; 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. Description CUSIP/Ticker Transaction ID Settlement Date YTM @ Cost Face Amount/Shares Cost Value Book Value Market Value Maturity Date Days To Maturity Accrued Interest % of PortfolioCash - Northland Securities Cash CASH5845 Redeemed 620637W46 02/03/2002 0.000 78,666.33 78,666.33 78,666.33 78,666.33 N/A 1 0.22Morgan Stanley Cash CASH5089 12/31/2010 0.000 1,123,094.63 1,123,094.63 1,123,094.63 1,123,094.63 N/A 1 3.10Oppenheimer Cash MM9905 12/27/2011 0.000 2,393,022.77 2,393,022.77 2,393,022.77 2,393,022.77 N/A 1 6.60Sub Total / Average Cash0.000 3,594,783.73 3,594,783.73 3,594,783.73 3,594,783.73 1 0.00 9.91Allegiance Bank TX 2.2 11/3/2022 01748DAY2 58629 11/03/2017 2.200 245,000.00 245,000.00 245,000.00 256,137.70 11/03/2022 856 398.71 0.68Ally Bank 1.95 10/19/2020 02006L6D0 57803 10/19/2017 1.950 149,000.00 149,000.00 149,000.00 149,838.87 10/19/2020 111 573.14 0.41Alma Bank 1.8 9/11/2023 020080BM8 58424 09/11/2019 1.800 245,000.00 245,000.00 245,000.00 256,274.90 09/11/2023 1,168 229.56 0.68Apex Bank 1.85 4/26/2021 03753XAU4 9176 10/25/2017 1.850 245,000.00 245,000.00 245,000.00 248,437.35 04/26/2021 300 62.09 0.68Bank Baroda New York 3.55 11/30/2023 06062R-7R-7 33681 11/30/2018 3.550 245,000.00 245,000.00 245,000.00 271,391.40 11/30/2023 1,248 724.79 0.68Bank of New England 3.25 7/31/2023 06426KAN8 24540 07/31/2018 3.250 245,000.00 245,000.00 245,000.00 266,905.45 07/31/2023 1,126 0.00 0.68Bankers Bank West Denver CO 1.8 9/30/2024 06610T-EE-1 23210 09/30/2019 1.800 245,000.00 245,000.00 245,000.00 258,242.25 09/30/2024 1,5530.00 0.68Barclays Bk Delaware 2.3 10/18/2022 06740KLD7 57203 10/18/2017 2.300 245,000.00 245,000.00 245,000.00 256,551.75 10/18/2022 840 1,127.00 0.68BMW Bank of NA 1.8 4/11/2022 05580ASR6 35141 10/11/2019 1.800 247,000.00 247,000.00 247,000.00 254,032.09 04/11/2022 650 974.47 0.68Capital BK3.15 10/28/2022 139797HC1 34562 10/29/2018 3.150 245,000.00 245,000.00 245,000.00 261,483.60 10/28/2022 850 21.14 0.68Capital One Bank Glen Allen VA 2.25 9/30/2020 140420WD8 33954 09/30/2015 2.250 245,000.00 245,000.00 245,000.00 246,330.35 09/30/2020 92 1,389.45 0.68Capital One Nat'l Assn McLean 2.1 8/14/2024 14042RMW8 4297 08/14/2019 2.100 247,000.00 247,000.00 247,000.00 263,267.42 08/14/2024 1,506 1,946.90 0.68Celtic Bank 1.8 8/30/2023 15118RRF6 57056 08/30/2019 1.800 245,000.00 245,000.00 245,000.00 256,211.20 08/30/2023 1,156 0.00 0.68CF Bank 3.15 9/18/2023 15721UCQ0 28263 09/18/2018 3.150 245,000.00 245,000.00 245,000.00 266,898.10 09/18/2023 1,175 253.73 0.68Citibank Sioux Falls 3.15 7/25/2022 17312QP86 7213 07/24/2018 3.150 245,000.00 245,000.00 245,000.00 259,805.35 07/25/2022 755 3,340.73 0.68City National Bank 3.05 8/8/2022 17801GBU2 3814 08/06/2018 3.050 245,000.00 245,000.00 245,000.00 259,533.40 08/08/2022 769 491.34 0.68COMENITY BK SALT LAKE CITY UT 2.6 11/24/2021 20033AJN7 57570 11/26/2014 2.600 245,000.00 245,000.00 245,000.00 253,648.50 11/24/2021 512 69.81 0.68Discover Bank 1.9 5/11/2023 254672YR3 5649 09/17/2019 2.001 245,000.00 244,135.15 244,321.50 256,125.45 05/11/2023 1,045 637.67 0.68Enerbank USA, UT 2.25 8/28/2020 29266NB48 57293 08/28/2014 2.250 245,000.00 245,000.00 245,000.00 245,862.40 08/28/2020 59 1,857.64 0.68Enterprise Bank & Trust 1.8 11/8/2024 29367SJQ8 27237 11/08/2019 1.800 245,000.00 245,000.00 245,000.00 258,308.40 11/08/2024 1,592 265.810.68Enterprise Bank Allison Park PA 1.8 9/27/2024 29367R-LA-2 34786 09/27/2019 1.800 245,000.00 245,000.00 245,000.00 258,237.35 09/27/2024 1,550 1,147.81 0.68First Natl Bank of Albany 1.6 2/28/2025 76T155845 3067 02/28/2020 1.600 245,000.00 245,000.00 245,000.00 256,189.15 02/28/2025 1,704 21.480.68First Source Bank 1.7 10/29/2021 33646CLT9 9087 12/31/2019 1.700 245,000.00 245,000.00 245,000.00 250,012.70 10/29/2021 486 0.00 0.68Firstbank Puerto Rico 1.8 9/6/2022 33767GAE8 30387 09/06/2019 1.800 245,000.00 245,000.00 245,000.00 253,349.60 09/06/2022 798 289.97 0.68GE Cap Bk Inc Retail 2.55 7/19/2021 36161TS48 33778 07/18/2014 2.550 150,000.00 150,000.00 150,000.00 153,924.00 07/19/2021 384 1,718.63 0.41GE Cap Ret BK, Draper UT 2.65 3/29/2021 36157QXM4 27314 03/28/2014 2.650 96,000.00 96,000.00 96,000.00 97,816.32 03/29/2021 272 655.17 0.26GE CAPITAL, UT 2.6 9/21/2020 36157QQQ3 27314 09/20/2013 2.600 150,000.00 150,000.00 150,000.00 150,787.50 09/21/2020 83 1,089.86 0.41Goldman Sachs 2.4 9/6/2022 38148PPC5 33124 09/06/2017 2.400 245,000.00 245,000.00 245,000.00 256,573.80 09/06/2022 798 1,868.71 0.68Harden County 3.1 9/28/2023 412022CJ2 5817 09/28/2018 3.100 245,000.00 245,000.00 245,000.00 266,662.90 09/28/2023 1,185 41.62 0.68Industrial & Coml NY 2.65 2/14/2023 45581EAR2 24387 02/14/2018 2.650 245,000.00 245,000.00 245,000.00 260,141.00 02/14/2023 959 284.60 0.68Iowa State Clarksville 3.15 9/28/2023 46256YAY5 15947 09/28/2018 3.150 245,000.00 245,000.00 245,000.00 267,076.95 09/28/2023 1,185 1,987.52 0.68KS State Bank Manhattan 2.1 5/17/2022 50116CBE8 19899 11/17/2017 2.100 245,000.00 245,000.00 245,000.00 253,702.40 05/17/2022 686 183.25 0.68Marine Bank 3 1/18/2022 56817TAH4 20250 07/18/2018 3.000 245,000.00 245,000.00 245,000.00 255,652.60 01/18/2022 567 241.64 0.68Marlin Business Bk 1.95 5/17/2021 57116AQG6 58267 11/17/2017 1.950 245,000.00 245,000.00 245,000.00 248,883.25 05/17/2021 321 170.16 0.68Merrick Bank2.2 11/8/2022 59013JD71 34519 11/08/2017 2.200 245,000.00 245,000.00 245,000.00 256,194.05 11/08/2022 861 324.88 0.68Morgan Stanley Bk 2.45 1/25/2021 61747MG96 32992 01/25/2018 2.450 245,000.00 245,000.00 245,000.00 248,236.45 01/25/2021 209 2,581.90 0.68MS Private Bank 3.55 11/8/2023 61760ARS0 34221 11/08/2018 3.550 245,000.00 245,000.00 245,000.00 270,384.45 11/08/2023 1,226 1,262.92 0.68National Cooperative Bank3.4 12/21/2023 635573AL2 323612 12/24/2018 3.400 245,000.00 245,000.00 245,000.00 270,499.60 12/21/2023 1,269 205.40 0.68Northwest Bank 2 4/29/2022 66736ABJ7 58752 11/10/2017 2.000 245,000.00 245,000.00 245,000.00 253,045.80 04/29/2022 668 0.00 0.68Average By: Face Amount / SharesPortfolio / Report Group: All PortfoliosAs of 6/30/2020CashCertificate Of DepositCity of Prior LakePortfolio HoldingsInvestment Portfolio - by Security TypeReport Format: By TransactionGroup By: Security Type Description CUSIP/Ticker Transaction ID Settlement Date YTM @ Cost Face Amount/Shares Cost Value Book Value Market Value Maturity Date Days To Maturity Accrued Interest % of PortfolioAverage By: Face Amount / SharesPortfolio / Report Group: All PortfoliosAs of 6/30/2020City of Prior LakePortfolio HoldingsInvestment Portfolio - by Security TypeReport Format: By TransactionGroup By: Security TypePinnacle Bank 1.85 2/26/2021 72345SFT3 35583 08/30/2017 1.850 245,000.00 245,000.00 245,000.00 247,770.95 02/26/2021 241 0.00 0.68Preferred Bank LA Calif 1.95 8/30/2024 740367HR1 33539 08/30/2019 1.950 249,000.00 249,000.00 249,000.00 263,944.98 08/30/2024 1,522 0.00 0.69Sallie Mae Bank Utah 1.9 9/18/2024 7954504D4 58177 09/18/2019 1.900 245,000.00 245,000.00 245,000.00 259,241.85 09/18/2024 1,541 1,326.36 0.68Southern Sts Bk 2 4/20/2021 843879BB2 58558 12/20/2017 2.000 245,000.00 245,000.00 245,000.00 248,667.65 04/20/2021 294 134.25 0.68Spring Bank3.25 10/24/2023 849430AY9 58668 10/24/2018 3.250 245,000.00 245,000.00 245,000.00 268,272.55 10/24/2023 1,211 130.89 0.68STATE BK INDIA NEW YORK NY 2.6 12/6/2021 8562843H5 33682 12/05/2014 2.600 245,000.00 245,000.00 245,000.00 253,410.85 12/06/2021 524 436.30 0.68Sterling Bank Poplar Bluff MO 3.1 1/11/2023 85916V-CY-9 57813 01/11/2019 3.100 245,000.00 245,000.00 245,000.00 262,448.90 01/11/2023 9253,558.21 0.68Third Federal Savings 1.9 9/15/2020 88413QBQ0 30012 09/15/2017 1.900 245,000.00 245,000.00 245,000.00 245,935.90 09/15/2020 77 1,364.62 0.68TIAA FSB Jacksonville FLA 1.95 8/26/2022 87270LCR2 34775 08/28/2019 1.950 247,000.00 247,000.00 247,000.00 256,121.71 08/26/2022 787 1,623.09 0.68UBS Bank USA 3.25 10/17/2022 90348JEG1 57565 10/17/2018 3.250 245,000.00 245,000.00 245,000.00 261,848.65 10/17/2022 839 283.60 0.68Washington Federal 1.95 8/28/2024 938828BN9 28088 08/28/2019 1.950 245,000.00 245,000.00 245,000.00 259,690.20 08/28/2024 1,520 26.18 0.68Wells Fargo BK NA Sioux Falls 2.75 5/17/2024 949763-B6-2 3511 06/11/2019 2.650 200,000.00 200,924.00 200,726.59 215,994.00 05/17/2024 1,417 195.89 0.55Wells Fargo Natl Bk West 1.8 12/13/2022 949495AA3 27389 12/13/2019 1.800 245,000.00 245,000.00 245,000.00 254,194.85 12/13/2022 896 205.400.68Sub Total / Average Certificate Of Deposit2.393 12,270,000.00 12,270,059.15 12,270,048.09 12,870,198.84 874 37,724.29 33.82FHLMC 2 11/30/2020 3134G3VF4 05/30/2012 2.000 1,790,000.00 1,790,000.00 1,790,000.00 1,802,494.20 11/30/2020 153 2,983.33 4.93Sub Total / Average FHLMC Bond2.000 1,790,000.00 1,790,000.00 1,790,000.00 1,802,494.20 153 2,983.33 4.93League of Minnesota Cities - 4M Fund LGIP LGIP5101M 11/30/2010 0.030 1,537,421.15 1,537,421.15 1,537,421.15 1,537,421.15 N/A 1 4.24League of Minnesota Cities - 4M LGIP LGIP5204M2017A Good Faith Deposit 06/13/2017 0.000 0.00 0.00 0.00 0.00 N/A 1 0.00League of Minnesota Cities - 4M Plus Fund LGIP LGIP5101MP 11/30/2010 0.100 7,974,517.50 7,974,517.50 7,974,517.50 7,974,517.50 N/A 1 21.98Sub Total / Average Local Government Investment Pool0.089 9,511,938.65 9,511,938.65 9,511,938.65 9,511,938.65 1 0.00 26.22Ansonia CT Bds 4 2/1/2021 036519PR1 02/01/2018 2.550 210,000.00 218,740.20 211,722.52 213,038.70 02/01/2021 216 3,476.67 0.58Armada Mich Area Schools Ref Bond 2.712 5/1/2022 042105MG8 08/29/2019 1.750 400,000.00 409,996.00 406,862.01 411,856.00 05/01/2022 670 1,777.87 1.10Canadian Cnty Okla Indpt Sch Dist 2 11/1/2024 135537-GT-9 Dated Date 11/1/20 1st Coupon 11/07/2019 2.000 285,000.00 285,000.00 285,000.00 290,221.20 11/01/2024 1,585 3,784.17 0.79Columbus Ohio2.333 12/1/2022 199492-CT-4 08/26/2019 1.750 100,000.00 101,840.00 101,363.42 103,285.00 12/01/2022 884 187.94 0.28Columbus Ohio City Sch Dist 2.036 12/1/2022 199507-6K-5 10/17/2019 1.901 135,000.00 135,552.15 135,427.78 137,860.65 12/01/2022 884 221.41 0.37Desert Sands CA ISD 2.852 6/1/2021 250433QJ1 02/01/2018 2.578 1,165,000.00 1,175,100.55 1,167,790.94 1,188,602.90 06/01/2021 336 2,676.523.21Edgewood Ohio City 5 12/1/2023 280455ET9 12/19/2019 2.101 215,000.00 238,512.40 235,351.34 239,608.90 12/01/2023 1,249 865.97 0.59Elizabethtown KY 1.5 8/1/2020 286875FS3 04/21/2020 1.203 210,000.00 210,170.10 210,053.36 210,180.60 08/01/2020 32 1,303.75 0.58Federal Way Wash2.2 12/1/2024 314031-HH-1 12/11/2019 2.150 475,000.00 476,111.50 475,987.93 491,083.50 12/01/2024 1,615 841.81 1.31Iowa Westn Comm2.8 6/1/2023 462612SE3 02/12/2018 2.800 195,000.00 195,000.00 195,000.00 203,010.60 06/01/2023 1,066 439.83 0.54Kentucky Assn of Cntys 2.5 2/1/2021 491196YV7 11/30/2017 2.051 465,000.00 471,379.80 466,188.99 468,148.05 02/01/2021 216 4,811.46 1.28Maricopa Cnty Ariz 5 7/1/2022 567389UY5 03/19/2020 1.700 500,000.00 536,785.00 532,242.01 546,760.00 07/01/2022 731 12,430.56 1.38Massachusetts St Dev 2.785 5/1/2024 57584FEM8 12/20/2019 1.920 240,000.00 248,647.20 247,600.21 254,354.40 05/01/2024 1,401 1,095.43 0.66Medallion Bk Salt Lake City 3.4 12/7/2022 58404D-CX-7 57449 12/07/2018 3.400 245,000.00 245,000.00 245,000.00 263,661.65 12/07/2022 890 532.19 0.68Minnetonka ISD 276 3 2/1/2021 604195YF8 12/18/2017 2.150 260,000.00 266,627.40 261,254.62 262,766.40 02/01/2021 216 3,228.33 0.72Monmouth OR Bds 2.9 4/1/2023 609694FZ2 01/30/2018 2.900 255,000.00 255,000.00 255,000.00 266,520.90 04/01/2023 1,005 1,828.21 0.70Monona Wis Ref 3 10/1/2022 610100XT1 09/18/2018 3.000 200,000.00 200,000.00 200,000.00 206,920.00 10/01/2022 823 1,483.33 0.55Nebraska State 3 12/15/2021 63968HE55 03/18/2020 1.651 370,000.00 378,532.20 377,139.19 382,716.90 12/15/2021 533 462.50 1.02Northwest Local Sch District Hamilton & Butler 667712CF8 11/15/2019 2.069 360,000.00 376,408.80 373,875.82 383,306.40 12/01/2023 1,249 942.50 0.99Northwest Local Sch District Hamilton & Butler 667712CG6 11/15/2019 2.169 370,000.00 389,010.60 386,658.77 398,767.50 12/01/2024 1,615 968.68 1.02Oak Creek WIS 4 10/1/2023 671137-YP-6 11/27/2018 3.402 280,000.00 287,434.00 284,992.42 305,466.00 10/01/2023 1,188 2,768.89 0.77Oklahoma Cnty Okla Metro 2.65 6/1/2024 67869T-AD-7 07/15/2019 2.286 500,000.00 508,255.00 506,629.93 524,555.00 06/01/2024 1,432 1,067.361.38FHLMC BondLocal Government Investment PoolMunicipal Bond Description CUSIP/Ticker Transaction ID Settlement Date YTM @ Cost Face Amount/Shares Cost Value Book Value Market Value Maturity Date Days To Maturity Accrued Interest % of PortfolioAverage By: Face Amount / SharesPortfolio / Report Group: All PortfoliosAs of 6/30/2020City of Prior LakePortfolio HoldingsInvestment Portfolio - by Security TypeReport Format: By TransactionGroup By: Security TypePapio-Missouri Riv 4 12/15/2021 698874DQ4 03/18/2020 1.750 140,000.00 145,376.00 144,498.29 147,565.60 12/15/2021 533 233.33 0.39Rhode IS Infrastructure Bk 2.18 10/1/2023 7622F-DD-7 06/27/2019 2.151 435,000.00 435,522.00 435,398.29 447,710.70 10/01/2023 1,188 2,344.41 1.20Roanoke VA Taxable 2 2/1/2025 770078BD4 05/14/2020 1.250 300,000.00 310,266.00 309,986.13 313,431.00 02/01/2025 1,677 766.67 0.83San Antonio TX ISD 5.033 8/15/2020 796269TX6 12/06/2019 1.751 150,000.00 153,366.00 150,612.00 150,718.50 08/15/2020 46 2,831.06 0.41South Lyon MI 2.69 5/1/2022 838736VU7 10/23/2017 2.250 250,000.00 254,702.50 251,908.34 257,172.50 05/01/2022 670 1,102.15 0.69St. Charles County MO Francis Howell School Distri 787642-4F-1 08/07/2019 2.531 200,000.00 209,956.00 207,447.88 207,848.00 03/01/2023 974 2,644.44 0.55Univ of North Carolina NC 1.778 12/1/2021 914713N24 12/20/2019 1.800 200,000.00 199,914.00 199,937.31 203,938.00 12/01/2021 519 286.46 0.55Sub Total / Average Municipal Bond2.196 9,110,000.00 9,318,205.40 9,260,929.50 9,481,075.55 875 57,403.90 25.11Total / Average1.483 36,276,722.38 36,484,986.93 36,427,699.97 37,260,490.97 523 98,111.52 100 YTM @ Cost Cost Value Days to Maturity % of Portfolio Cash ‐ 3,594,784 1 9.85% Certificate of Deposit 2.393 12,270,059 874 33.63% FHLMC Bond 2.000 1,790,000 153 4.91% LGIP 0.009 9,511,939 1 26.07% Municipal Bond 2.193 9,318,205 877 25.54% Total / Average 1.486 36,484,987 526 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio ‐ Diversification, by Security Type June 30, 2020 Description City of Prior Lake ‐ Quarterly Investment Report YTM @ Cost Cost Value Days to Maturity % of Portfolio 0‐1 Month 0.064 13,106,722 1 35.92% 1‐3 Months 1.921 1,003,536 59 2.75% 3‐6 Months 2.025 2,184,000 143 5.99% 6‐9 Months 2.178 1,446,747 219 3.97% 9‐12 Months 2.345 2,006,101 322 5.50% 1‐2 Years 2.030 3,792,306 602 10.39% 2‐3 Years 2.569 4,773,483 879 13.08% 3‐4 Years 2.680 4,745,703 1,246 13.01% 4‐5 Years 1.894 3,426,388 1,587 9.39% Total / Average 1.486 36,484,986 526 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio ‐ Diversification, by Maturity Range June 30, 2020 Description City of Prior Lake ‐ Quarterly Investment Report Change from one 6/30/2019 9/30/2019 12/31/2019 3/31/2020 6/30/2020 year prior Market Value 13,668,660 10,371,851 12,567,010 10,336,802 13,106,722 (561,938) 111110 1.95% 1.71% 0.91% 0.60% 0.06%‐1.89% Fixed Income Assets 25,631,026 26,844,156 25,705,148 23,837,828 23,378,265 (2,252,761) 25,752,883 27,109,395 25,941,106 24,298,738 24,153,769 (1,599,114) 841 903 931 895 819 (22) 642 720 861 887 816 174 2.37% 2.33% 2.32% 2.30% 2.28%‐0.08% Total Portfolio Value 39,299,686 37,216,007 38,272,158 34,174,630 36,484,987 (2,814,699) 39,421,544 37,481,246 38,508,116 34,635,540 37,260,491 (2,161,053) 111,297 119,459 112,473 134,643 98,112 (13,185) 121,857 265,239 235,958 460,909 775,504 653,647 549 651 630 623 523 (26) 419 519 582 617 521 102 2.22% 2.16% 1.87% 1.78% 1.49%‐0.74% BENCHMARK 90 Day T‐Bill 2.12% 1.88% 1.55% 0.11% 0.16%‐1.96% 2.09% 1.83% 1.60% 0.15% 0.18%‐1.91% 1.92% 1.75% 1.59% 0.17% 0.16%‐1.76% Weighted Average Yield to Maturity @ Cost CITY OF PRIOR LAKE, MINNESOTA Quarterly Investment Report June 30, 2020 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