Loading...
HomeMy WebLinkAbout05(C) - Approve 1st Quarter 2020 Investment Report ReportDescription 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 Portfolio Cash - Northland Securities Cash CASH5845 02/03/2002 0.000 4,326.36 4,326.36 4,326.36 4,326.36 N/A 1 0.01 Morgan Stanley Cash CASH5089 12/31/2010 0.000 593,386.09 593,386.09 593,386.09 593,386.09 N/A 1 1.75 Oppenheimer Cash MM9905 12/27/2011 0.000 4,759,139.11 4,759,139.11 4,759,139.11 4,759,139.11 N/A 1 14.01 Sub Total / Average Cash 0.000 5,356,851.56 5,356,851.56 5,356,851.56 5,356,851.56 1 0.00 15.77 Allegiance Bank TX 2.2 11/3/2022 01748DAY2 58629 11/03/2017 2.200 245,000.00 245,000.00 245,000.00 249,926.95 11/03/2022 947 413.48 0.72 Ally Bank 1.95 10/19/2020 02006L6D0 57803 10/19/2017 1.950 149,000.00 149,000.00 149,000.00 149,727.12 10/19/2020 202 1,305.48 0.44 Alma Bank 1.8 9/11/2023 020080BM8 58424 09/11/2019 1.800 245,000.00 245,000.00 245,000.00 247,695.00 09/11/2023 1,259 241.64 0.72 Apex Bank 1.85 4/26/2021 03753XAU4 9176 10/25/2017 1.850 245,000.00 245,000.00 245,000.00 246,545.95 04/26/2021 391 74.51 0.72 Bank 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 263,000.15 11/30/2023 1,339 2,899.17 0.72 Bank of New England 3.25 7/31/2023 06426KAN8 24540 07/31/2018 3.250 245,000.00 245,000.00 245,000.00 259,205.10 07/31/2023 1,217 0.00 0.72 Bankers 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 247,927.75 09/30/2024 1,644 12.08 0.72 Barclays Bk Delaware 2.3 10/18/2022 06740KLD7 57203 10/18/2017 2.300 245,000.00 245,000.00 245,000.00 250,473.30 10/18/2022 931 2,547.33 0.72 BMW Bank of NA 1.8 4/11/2022 05580ASR6 35141 10/11/2019 1.800 247,000.00 247,000.00 247,000.00 249,203.24 04/11/2022 741 2,095.10 0.73 Capital BK3.15 10/28/2022 139797HC1 34562 10/29/2018 3.150 245,000.00 245,000.00 245,000.00 255,799.60 10/28/2022 941 42.29 0.72 Capital 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,484.70 09/30/2020 183 15.10 0.72 Capital 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 253,058.91 08/14/2024 1,597 653.70 0.73 Celtic Bank 1.8 8/30/2023 15118RRF6 57056 08/30/2019 1.800 245,000.00 245,000.00 245,000.00 247,685.20 08/30/2023 1,247 0.00 0.72 CF Bank 3.15 9/18/2023 15721UCQ0 28263 09/18/2018 3.150 245,000.00 245,000.00 245,000.00 258,874.35 09/18/2023 1,266 274.87 0.72 Citibank Sioux Falls 3.15 7/25/2022 17312QP86 7213 07/24/2018 3.150 245,000.00 245,000.00 245,000.00 254,863.70 07/25/2022 846 1,416.64 0.72 City National Bank 3.05 8/8/2022 17801GBU2 3814 08/06/2018 3.050 245,000.00 245,000.00 245,000.00 254,444.75 08/08/2022 860 511.82 0.72 COMENITY 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 250,549.25 11/24/2021 603 87.26 0.72 Discover Bank 1.9 5/11/2023 254672YR3 5649 09/17/2019 2.001 245,000.00 244,135.15 244,262.41 248,302.60 05/11/2023 1,136 1,798.23 0.72 Enerbank USA, UT 2.25 8/28/2020 29266NB48 57293 08/28/2014 2.250 245,000.00 245,000.00 245,000.00 246,234.80 08/28/2020 150 483.29 0.72 Enterprise Bank & Trust 1.8 11/8/2024 29367SJQ8 27237 11/08/2019 1.800 245,000.00 245,000.00 245,000.00 247,937.55 11/08/2024 1,683 277.89 0.72 Enterprise 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 247,922.85 09/27/2024 1,641 48.33 0.72 First Farmers 1.85 4/8/2021-18 320165JB0 12839 09/08/2017 1.850 245,000.00 245,000.00 245,000.00 245,049.00 04/08/2021 373 285.61 0.72 First 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 245,629.65 02/28/2025 1,795 32.22 0.72 First Source Bank 1.7 10/29/2021 33646CLT9 9087 12/31/2019 1.700 245,000.00 245,000.00 245,000.00 246,504.30 10/29/2021 577 1,038.40 0.72 Firstbank Puerto Rico 1.8 9/6/2022 33767GAE8 30387 09/06/2019 1.800 245,000.00 245,000.00 245,000.00 247,381.40 09/06/2022 889 302.05 0.72 GE 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 152,653.50 07/19/2021 475 765.00 0.44 GE 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,342.08 03/29/2021 363 20.91 0.28 GE CAPITAL, UT 2.6 9/21/2020 36157QQQ3 27314 09/20/2013 2.600 150,000.00 150,000.00 150,000.00 150,975.00 09/21/2020 174 117.53 0.44 Goldman Sachs 2.4 9/6/2022 38148PPC5 33124 09/06/2017 2.400 245,000.00 245,000.00 245,000.00 250,897.15 09/06/2022 889 402.74 0.72 Harden County 3.1 9/28/2023 412022CJ2 5817 09/28/2018 3.100 245,000.00 245,000.00 245,000.00 258,553.40 09/28/2023 1,276 62.42 0.72 Industrial & Coml NY 2.65 2/14/2023 45581EAR2 24387 02/14/2018 2.650 245,000.00 245,000.00 245,000.00 253,352.05 02/14/2023 1,050 302.39 0.72 Iowa State Clarksville 3.15 9/28/2023 46256YAY5 15947 09/28/2018 3.150 245,000.00 245,000.00 245,000.00 258,960.10 09/28/2023 1,276 63.43 0.72 KS State Bank Manhattan 2.1 5/17/2022 50116CBE8 19899 11/17/2017 2.100 245,000.00 245,000.00 245,000.00 248,790.15 05/17/2022 777 197.34 0.72 Lee Bank 2 11/15/2024 523391BC3 33645 11/15/2019 2.000 245,000.00 245,000.00 245,000.00 245,098.00 11/15/2024 1,690 214.79 0.72 Marine Bank 3 1/18/2022 56817TAH4 20250 07/18/2018 3.000 245,000.00 245,000.00 245,000.00 252,271.60 01/18/2022 658 261.78 0.72 Marlin Business Bk 1.95 5/17/2021 57116AQG6 58267 11/17/2017 1.950 245,000.00 245,000.00 245,000.00 246,888.95 05/17/2021 412 183.25 0.72 Merrick Bank2.2 11/8/2022 59013JD71 34519 11/08/2017 2.200 245,000.00 245,000.00 245,000.00 249,944.10 11/08/2022 952 339.64 0.72 Morgan Stanley Bk 2.45 1/25/2021 61747MG96 32992 01/25/2018 2.450 245,000.00 245,000.00 245,000.00 247,604.35 01/25/2021 300 1,085.38 0.72 MS Private Bank 3.55 11/8/2023 61760ARS0 34221 11/08/2018 3.550 245,000.00 245,000.00 245,000.00 262,110.80 11/08/2023 1,317 3,431.34 0.72 National Cooperative Bank3.4 12/21/2023 635573AL2 323612 12/24/2018 3.400 245,000.00 245,000.00 245,000.00 261,936.85 12/21/2023 1,360 2,305.01 0.72 Northwest Bank 2 4/29/2022 66736ABJ7 58752 11/10/2017 2.000 245,000.00 245,000.00 245,000.00 248,224.20 04/29/2022 759 0.00 0.72 Pinnacle Bank 1.85 2/26/2021 72345SFT3 35583 08/30/2017 1.850 245,000.00 245,000.00 245,000.00 246,440.60 02/26/2021 332 0.00 0.72 Preferred Bank LA Calif 1.95 8/30/2024 740367HR1 33539 08/30/2019 1.950 249,000.00 249,000.00 249,000.00 253,561.68 08/30/2024 1,613 0.00 0.73 Sallie Mae Bank Utah 1.9 9/18/2024 7954504D4 58177 09/18/2019 1.900 245,000.00 245,000.00 245,000.00 248,976.35 09/18/2024 1,632 165.79 0.72 Southern Sts Bk 2 4/20/2021 843879BB2 58558 12/20/2017 2.000 245,000.00 245,000.00 245,000.00 246,911.00 04/20/2021 385 147.67 0.72 Spring Bank3.25 10/24/2023 849430AY9 58668 10/24/2018 3.250 245,000.00 245,000.00 245,000.00 260,069.95 10/24/2023 1,302 152.71 0.72 CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio - By Security Type March 31, 2020 Cash Certificate Of Deposit 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 Portfolio CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio - By Security Type March 31, 2020 STATE 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 250,091.10 12/06/2021 615 2,041.89 0.72 Sterling 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 256,132.80 01/11/2023 1,016 1,664.66 0.72 Third Federal Savings 1.9 9/15/2020 88413QBQ0 30012 09/15/2017 1.900 245,000.00 245,000.00 245,000.00 245,975.10 09/15/2020 168 204.05 0.72 TIAA FSB Jacksonville FLA 1.95 8/26/2022 87270LCR2 34775 08/28/2019 1.950 247,000.00 247,000.00 247,000.00 250,260.40 08/26/2022 878 422.27 0.73 UBS Bank USA 3.25 10/17/2022 90348JEG1 57565 10/17/2018 3.250 245,000.00 245,000.00 245,000.00 256,304.30 10/17/2022 930 305.41 0.72 Washington Federal 1.95 8/28/2024 938828BN9 28088 08/28/2019 1.950 245,000.00 245,000.00 245,000.00 249,485.95 08/28/2024 1,611 39.27 0.72 Webster 5 Cnts 1.55 9/17/2021-17 94789PBV5 90297 03/18/2016 1.550 245,000.00 245,000.00 245,000.00 245,075.95 09/17/2021 535 135.25 0.72 Wells 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,773.25 208,172.00 05/17/2024 1,508 210.96 0.59 Wells 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 247,464.70 12/13/2022 987 217.48 0.72 Wex Bank 2.7 4/23/2020 92937CHR2 34697 07/23/2018 2.700 245,000.00 245,000.00 245,000.00 245,271.95 04/23/2020 23 1,232.38 0.72 Sub Total / Average Certificate Of Deposit 2.365 13,250,000.00 13,250,059.15 13,250,035.66 13,556,223.28 942 33,549.23 39.00 FHLMC 2 11/30/2020 3134G3VF4 05/30/2012 2.000 1,790,000.00 1,790,000.00 1,790,000.00 1,807,273.50 11/30/2020 244 11,933.33 5.27 Sub Total / Average FHLMC Bond 2.000 1,790,000.00 1,790,000.00 1,790,000.00 1,807,273.50 244 11,933.33 5.27 League of Minnesota Cities - 4M Fund LGIP LGIP5101M 11/30/2010 1.150 99,024.19 99,024.19 99,024.19 99,024.19 N/A 1 0.29 League 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.00 League of Minnesota Cities - 4M Plus Fund LGIP LGIP5101MP 11/30/2010 1.270 3,622,592.91 3,622,592.91 3,622,592.91 3,622,592.91 N/A 1 10.66 League of MN Cities LGIP LGIP52064M Phone Wire Purchase 06/04/2019 1.150 1,220,115.52 1,220,115.52 1,220,115.52 1,220,115.52 N/A 1 3.59 League of Mn Cities LGIP LGIP52054M Good Faith Deposit 07/17/2018 1.150 38,217.95 38,217.95 38,217.95 38,217.95 N/A 1 0.11 Sub Total / Average Local Government Investment Pool 1.237 4,979,950.57 4,979,950.57 4,979,950.57 4,979,950.57 1 0.00 14.66 Ansonia CT Bds 4 2/1/2021 036519PR1 02/01/2018 2.550 210,000.00 218,740.20 212,448.21 213,246.60 02/01/2021 307 1,400.00 0.62 Armada Mich Area Schools Ref Bond 2.712 5/1/2022 042105MG8 08/29/2019 1.750 400,000.00 409,996.00 407,794.01 412,416.00 05/01/2022 761 4,520.00 1.18 Canadian 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 288,770.55 11/01/2024 1,676 2,375.00 0.84 Columbus Ohio2.333 12/1/2022 199492-CT-4 08/26/2019 1.750 100,000.00 101,840.00 101,503.77 103,238.00 12/01/2022 975 777.67 0.29 Columbus Ohio City Sch Dist 2.036 12/1/2022 199507-6K-5 10/17/2019 1.901 135,000.00 135,552.15 135,471.82 137,641.95 12/01/2022 975 916.20 0.40 Desert Sands CA ISD 2.852 6/1/2021 250433QJ1 02/01/2018 2.578 1,165,000.00 1,175,100.55 1,168,546.82 1,186,261.25 06/01/2021 427 11,075.27 3.43 Edgewood Ohio City 5 12/1/2023 280455ET9 12/19/2019 2.101 215,000.00 238,512.40 236,834.11 240,081.90 12/01/2023 1,340 3,045.83 0.63 Federal Way Wash2.2 12/1/2024 314031-HH-1 12/11/2019 2.150 475,000.00 476,111.50 476,043.60 488,988.75 12/01/2024 1,706 3,193.06 1.40 Iowa Westn Comm2.8 6/1/2023 462612SE3 02/12/2018 2.800 195,000.00 195,000.00 195,000.00 202,772.70 06/01/2023 1,157 1,820.00 0.57 Kentucky Assn of Cntys 2.5 2/1/2021 491196YV7 11/30/2017 2.051 465,000.00 471,379.80 466,689.90 469,440.75 02/01/2021 307 1,937.50 1.37 Maricopa Cnty Ariz 5 7/1/2022 567389UY5 03/19/2020 1.700 500,000.00 536,785.00 536,255.72 542,800.00 07/01/2022 822 6,250.00 1.47 Massachusetts St Dev 2.785 5/1/2024 57584FEM8 12/20/2019 1.920 240,000.00 248,647.20 248,093.87 253,860.00 05/01/2024 1,492 2,785.00 0.71 Medallion 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 257,786.55 12/07/2022 981 555.33 0.72 Minnetonka ISD 276 3 2/1/2021 604195YF8 12/18/2017 2.150 260,000.00 266,627.40 261,783.18 263,920.80 02/01/2021 307 1,300.00 0.77 Monmouth OR Bds 2.9 4/1/2023 609694FZ2 01/30/2018 2.900 255,000.00 255,000.00 255,000.00 266,426.55 04/01/2023 1,096 3,697.50 0.75 Monona Wis Ref 3 10/1/2022 610100XT1 09/18/2018 3.000 200,000.00 200,000.00 200,000.00 206,984.00 10/01/2022 914 3,000.00 0.59 Nebraska State 3 12/15/2021 63968HE55 03/18/2020 1.651 370,000.00 378,532.20 378,358.07 381,125.90 12/15/2021 624 2,898.33 1.09 Northwest Local Sch District Hamilton & Butler 667712CF8 11/15/2019 2.069 360,000.00 376,408.80 374,886.79 383,148.00 12/01/2023 1,340 4,420.00 1.06 Northwest Local Sch District Hamilton & Butler 667712CG6 11/15/2019 2.169 370,000.00 389,010.60 387,597.44 398,142.20 12/01/2024 1,706 4,542.78 1.09 Oak Creek WIS 4 10/1/2023 671137-YP-6 11/27/2018 3.402 280,000.00 287,434.00 285,374.84 306,006.40 10/01/2023 1,279 5,600.00 0.82 Oklahoma Cnty Okla Metro 2.65 6/1/2024 67869T-AD-7 07/15/2019 2.286 500,000.00 508,255.00 507,051.24 519,020.00 06/01/2024 1,523 11,041.67 1.47 Papio-Missouri Riv 4 12/15/2021 698874DQ4 03/18/2020 1.750 140,000.00 145,376.00 145,266.29 146,925.80 12/15/2021 624 1,648.89 0.41 Rhode IS Infrastructure Bk 2.18 10/1/2023 7622F-DD-7 06/27/2019 2.151 435,000.00 435,522.00 435,428.80 446,601.45 10/01/2023 1,279 4,741.50 1.28 San Antonio TX ISD 5.033 8/15/2020 796269TX6 12/06/2019 1.751 150,000.00 153,366.00 151,822.70 152,289.00 08/15/2020 137 964.66 0.44 South Lyon MI 2.69 5/1/2022 838736VU7 10/23/2017 2.250 250,000.00 254,702.50 252,167.54 257,490.00 05/01/2022 761 2,802.08 0.74 St. Charles County MO Francis Howell School Distri 787642-4F-1 08/07/2019 2.531 200,000.00 209,956.00 208,143.73 208,486.00 03/01/2023 1,065 666.67 0.59 Univ of North Carolina NC 1.778 12/1/2021 914713N24 12/20/2019 1.800 200,000.00 199,914.00 199,926.32 201,370.00 12/01/2021 610 1,185.33 0.59 Sub Total / Average Municipal Bond 2.254 8,600,000.00 8,797,769.30 8,757,488.77 8,935,241.10 959 89,160.27 25.31 Total / Average 1.780 33,976,802.13 34,174,630.58 34,134,326.56 34,635,540.01 623 134,642.83 100 FHLMC Bond Local Government Investment Pool Municipal Bond YTM @ Cost Cost Value Days to Maturity % of Portfolio 0-1 Month 0.645 10,581,802 2 30.96% 3-6 Months 2.112 793,366 158 2.32% 6-9 Months 2.025 2,184,000 234 6.39% 9-12 Months 2.208 1,542,747 313 4.51% 1-2 Years 2.194 4,253,923 502 12.45% 2-3 Years 2.372 6,272,832 898 18.36% 3-4 Years 2.739 4,227,012 1,278 12.37% 4-5 Years 2.029 4,318,948 1,635 12.64% Total / Average 1.781 34,174,630 625 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio - Diversification, by Maturity Range March 31, 2020 Description City of Prior Lake - Quarterly Investment Report YTM @ Cost Cost Value Days to Maturity % of Portfolio Cash - 5,356,852 1 15.67% Certificate of Deposit 2.365 13,250,059 942 38.78% FHLMC Bond 2.000 1,790,000 244 5.24% LGIP 1.237 4,979,950 1 14.57% Municipal Bond 2.250 8,797,769 960 25.74% Total / Average 1.781 34,174,630 625 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio - Diversification, by Security Type March 31, 2020 Description City of Prior Lake - Quarterly Investment Report Change from one 3/31/2019 6/30/2019 9/30/2019 12/31/2019 3/31/2020 year prior Market Value 5,559,979 13,668,660 10,371,851 12,567,010 10,336,802 4,776,823 1 1 1 1 1 0 2.07% 1.95% 1.71% 0.91% 0.60%-1.47% Fixed Income Assets 26,207,580 25,631,026 26,844,156 25,705,148 23,837,828 (2,369,752) 26,145,555 25,752,883 27,109,395 25,941,106 24,298,738 (1,846,817) 870 841 903 931 895 25 678 642 720 861 887 209 2.36% 2.37% 2.33% 2.32% 2.30%-0.07% Total Portfolio Value 31,767,559 39,299,686 37,216,007 38,272,158 34,174,630 2,407,071 31,705,534 39,421,544 37,481,246 38,508,116 34,635,540 2,930,006 120,321 111,297 119,459 112,473 134,643 14,322 (62,025)121,857 265,239 235,958 460,909 522,934 718 549 651 630 623 (95) 559 419 519 582 617 58 2.31% 2.22% 2.16% 1.87% 1.78% -0.53% BENCHMARK 90 Day T-Bill 2.40% 2.12% 1.88% 1.55% 0.11% -2.29% 2.44%2.09%1.83%1.60%0.15%-2.29% 2.40%1.92%1.75%1.59%0.17%-2.23% 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 Weighted Average Yield to Maturity @ Cost CITY OF PRIOR LAKE, MINNESOTA Quarterly Investment Report March 31, 2020 Local Government Investment Pools / Money Market Quarterly WAM (1) in DaysWeighted Average Yield to Maturity Cost Value Market Value WAM (1) in Days WAM / Callable (1) in Days City of Prior Lake - Quarterly Investment Report