Loading...
HomeMy WebLinkAbout05(B) - Approval of 1st Quarter 2021 Investment Report ReportYTM @ Cost Cost Value Days to Maturity % of Portfolio 0-1 Month 0.101 13,409,565 2 36.69% 1-3 Months 2.470 1,420,101 59 3.89% 3-6 Months 2.550 150,000 110 0.40% 6-9 Months 1.522 2,063,454 244 5.65% 9-12 Months 3.000 245,000 293 0.67% 1-2 Years 2.372 6,272,832 533 17.16% 2-3 Years 2.634 4,443,392 919 12.16% 3-4 Years 1.554 6,448,407 1,292 17.64% 4-5 Years 0.965 2,098,892 1,691 5.74% Total / Average 1.306 36,551,643 547 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio - Diversification, by Maturity Range March 31, 2021 Description City of Prior Lake - Quarterly Investment Report 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 Cash - Northland Securities Cash CASH5845 Redeemed 620637W46 02/03/2002 0.000 1,895,855.19 1,895,855.19 1,895,855.19 1,895,855.19 N/A 1 5.23 Morgan Stanley Cash CASH5089 12/31/2010 0.000 1,473,257.09 1,473,257.09 1,473,257.09 1,473,257.09 N/A 1 4.07 Oppenheimer Cash MM9905 12/27/2011 0.000 1,318,626.83 1,318,626.83 1,318,626.83 1,318,626.83 N/A 1 3.64 Sub Total / Average Cash 0.000 4,687,739.11 4,687,739.11 4,687,739.11 4,687,739.11 1 0.00 12.94 Allegiance Bank TX 2.2 11/3/2022 01748DAY2 58629 11/03/2017 2.200 245,000.00 245,000.00 245,000.00 253,060.50 11/03/2022 582 413.48 0.68 Alma Bank 1.8 9/11/2023 020080BM8 58424 09/11/2019 1.800 245,000.00 245,000.00 245,000.00 254,393.30 09/11/2023 894 241.64 0.68 Apex Bank 1.85 4/26/2021 03753XAU4 9176 10/25/2017 1.850 245,000.00 245,000.00 245,000.00 245,318.50 04/26/2021 26 74.51 0.68 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 266,381.15 11/30/2023 974 2,899.17 0.68 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 262,328.85 07/31/2023 852 0.00 0.68 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 256,813.90 09/30/2024 1,279 12.08 0.68 BankUnited Savings Miami 0.95 3/31/2026 066519QT9 33134 03/31/2021 0.950 245,000.00 245,000.00 245,000.00 245,570.85 03/31/2026 1,826 0.00 0.68 Barclays Bk Delaware 2.3 10/18/2022 06740KLD7 57203 10/18/2017 2.300 245,000.00 245,000.00 245,000.00 253,236.90 10/18/2022 566 2,531.89 0.68 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 251,342.26 04/11/2022 376 2,082.92 0.68 Capital BK3.15 10/28/2022 139797HC1 34562 10/29/2018 3.150 245,000.00 245,000.00 245,000.00 256,662.00 10/28/2022 576 42.29 0.68 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 261,182.74 08/14/2024 1,232 639.49 0.68 Celtic Bank 1.8 8/30/2023 15118RRF6 57056 08/30/2019 1.800 245,000.00 245,000.00 245,000.00 254,307.55 08/30/2023 882 0.00 0.68 CF Bank 3.15 9/18/2023 15721UCQ0 28263 09/18/2018 3.150 245,000.00 245,000.00 245,000.00 262,581.20 09/18/2023 901 274.87 0.68 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,829.40 07/25/2022 481 1,395.49 0.68 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,741.20 08/08/2022 495 511.82 0.68 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 249,226.25 11/24/2021 238 87.26 0.68 Discover Bank 1.9 5/11/2023 254672YR3 5649 09/17/2019 2.001 245,000.00 244,135.15 244,499.40 253,908.20 05/11/2023 771 1,785.48 0.68 Enerbank USA 0.55 9/25/2025 29278TRL6 57293 09/25/2020 0.550 245,000.00 245,000.00 245,000.00 243,650.05 09/25/2025 1,639 22.15 0.68 Enterprise Bank & Trust 1.8 11/8/2024 29367SJQ8 27237 11/08/2019 1.800 245,000.00 245,000.00 245,000.00 256,985.40 11/08/2024 1,318 277.89 0.68 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 256,818.80 09/27/2024 1,276 48.33 0.68 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 255,520.30 02/28/2025 1,430 32.22 0.68 First Source Bank 1.7 10/29/2021 33646CLT9 9087 12/31/2019 1.700 245,000.00 245,000.00 245,000.00 247,371.60 10/29/2021 212 1,026.99 0.68 Firstbank Puerto Rico 1.8 9/6/2022 33767GAE8 30387 09/06/2019 1.800 245,000.00 245,000.00 245,000.00 250,894.70 09/06/2022 524 302.05 0.68 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 151,191.00 07/19/2021 110 754.52 0.41 Goldman Sachs 2.4 9/6/2022 38148PPC5 33124 09/06/2017 2.400 245,000.00 245,000.00 245,000.00 253,043.35 09/06/2022 524 402.74 0.68 Harden County 3.1 9/28/2023 412022CJ2 5817 09/28/2018 3.100 245,000.00 245,000.00 245,000.00 262,448.90 09/28/2023 911 62.42 0.68 Industrial & Coml NY 2.65 2/14/2023 45581EAR2 24387 02/14/2018 2.650 245,000.00 245,000.00 245,000.00 256,451.30 02/14/2023 685 302.39 0.68 Iowa State Clarksville 3.15 9/28/2023 46256YAY5 15947 09/28/2018 3.150 245,000.00 245,000.00 245,000.00 262,801.70 09/28/2023 911 63.43 0.68 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 250,537.00 05/17/2022 412 197.34 0.68 Marine Bank 3 1/18/2022 56817TAH4 20250 07/18/2018 3.000 245,000.00 245,000.00 245,000.00 250,747.70 01/18/2022 293 261.78 0.68 Marlin Business Bk 1.95 5/17/2021 57116AQG6 58267 11/17/2017 1.950 245,000.00 245,000.00 245,000.00 245,607.60 05/17/2021 47 183.25 0.68 Merrick Bank2.2 11/8/2022 59013JD71 34519 11/08/2017 2.200 245,000.00 245,000.00 245,000.00 253,126.65 11/08/2022 587 339.64 0.68 MS Private Bank 3.55 11/8/2023 61760ARS0 34221 11/08/2018 3.550 245,000.00 245,000.00 245,000.00 265,489.35 11/08/2023 952 3,407.51 0.68 National Cooperative Bank3.4 12/21/2023 635573AL2 323612 12/24/2018 3.400 245,000.00 245,000.00 245,000.00 265,807.85 12/21/2023 995 2,282.19 0.68 Northwest Bank 2 4/29/2022 66736ABJ7 58752 11/10/2017 2.000 245,000.00 245,000.00 245,000.00 250,037.20 04/29/2022 394 0.00 0.68 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 262,132.26 08/30/2024 1,248 0.00 0.69 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 257,619.95 09/18/2024 1,267 165.79 0.68 Southern Sts Bk 2 4/20/2021 843879BB2 58558 12/20/2017 2.000 245,000.00 245,000.00 245,000.00 245,264.60 04/20/2021 20 147.67 0.68 Spring Bank3.25 10/24/2023 849430AY9 58668 10/24/2018 3.250 245,000.00 245,000.00 245,000.00 263,818.45 10/24/2023 937 152.71 0.68 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 249,221.35 12/06/2021 250 2,024.44 0.68 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 257,896.80 01/11/2023 651 1,643.85 0.68 Texas Exchange Bk 0.45 8/21/2024 88241TJE1 20099 08/21/2020 0.450 245,000.00 245,000.00 245,000.00 245,056.35 08/21/2024 1,239 30.21 0.68 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 253,365.19 08/26/2022 513 409.07 0.68 As of 3/31/2021 Cash Certificate Of Deposit City of Prior Lake Portfolio Holdings Investment Portfolio - 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 Portfolio As of 3/31/2021 City of Prior Lake Portfolio Holdings Investment Portfolio - by Security Type 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,823.70 10/17/2022 565 305.41 0.68 Washington Federal 1.95 8/28/2024 938828BN9 28088 08/28/2019 1.950 245,000.00 245,000.00 245,000.00 257,909.05 08/28/2024 1,246 39.27 0.68 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,586.09 214,796.00 05/17/2024 1,143 210.96 0.55 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 251,923.70 12/13/2022 622 217.48 0.68 Sub Total / Average Certificate Of Deposit 2.308 11,385,000.00 11,385,059.15 11,385,085.49 11,830,242.60 767 28,306.09 31.42 FHLMC 0.5 12/9/2024 3134GWA71 09/09/2020 0.500 200,000.00 200,000.00 200,000.00 200,020.00 12/09/2024 1,349 311.11 0.55 Sub Total / Average FHLMC Bond 0.500 200,000.00 200,000.00 200,000.00 200,020.00 1,349 311.11 0.55 League of Minnesota Cities - 4M Fund LGIP LGIP5101M 11/30/2010 0.020 77,833.09 77,833.09 77,833.09 77,833.09 N/A 1 0.21 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 0.050 8,153,993.23 8,153,993.23 8,153,993.23 8,153,993.23 N/A 1 22.50 Sub Total / Average Local Government Investment Pool 0.050 8,231,826.32 8,231,826.32 8,231,826.32 8,231,826.32 1 0.00 22.72 Allen Park MI Public Sch Dist 2 11/2/2024 018033HR4 07/30/2020 0.751 290,000.00 305,140.90 302,766.62 302,052.40 11/02/2024 1,312 2,416.67 0.80 Armada Mich Area Schools Ref Bond 2.712 5/1/2022 042105MG8 08/29/2019 1.750 400,000.00 409,996.00 404,055.75 410,096.00 05/01/2022 396 4,520.00 1.10 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 297,665.40 11/01/2024 1,311 8,075.00 0.79 Central Cmnty Sch 2 3/1/2026 153135FJ2 03/04/2021 0.700 300,000.00 319,098.00 318,815.14 311,049.00 03/01/2026 1,796 450.00 0.83 Columbus Ohio2.333 12/1/2022 199492-CT-4 08/26/2019 1.750 100,000.00 101,840.00 100,940.82 103,594.00 12/01/2022 610 777.67 0.28 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,295.19 138,712.50 12/01/2022 610 916.20 0.37 Desert Sands CA ISD 2.852 6/1/2021 250433QJ1 02/01/2018 2.578 1,165,000.00 1,175,100.55 1,165,515.00 1,169,496.90 06/01/2021 62 11,075.27 3.22 Edgewood Ohio City 5 12/1/2023 280455ET9 12/19/2019 2.101 215,000.00 238,512.40 230,886.76 239,544.40 12/01/2023 975 3,583.33 0.59 El Paso TX ISD 0 8/15/2024 283770NS0 10/30/2020 0.700 500,000.00 486,925.00 488,359.95 488,090.00 08/15/2024 1,233 0.00 1.38 Federal Way Wash2.2 12/1/2024 314031-HH-1 12/11/2019 2.150 475,000.00 476,111.50 475,820.32 495,743.25 12/01/2024 1,341 3,483.33 1.31 Hempstead NY1.125 12/1/2021 424092HH0 12/01/2020 0.350 600,000.00 604,632.00 603,109.15 603,414.00 12/01/2021 245 2,250.00 1.66 Hennepin Cnty 5 12/1/2025 425507BS8 12/04/2020 2.976 115,000.00 125,723.75 125,035.50 124,203.45 12/01/2025 1,706 1,916.67 0.32 Indiana Bond Bank 3.326 7/15/2025 45462TER9 03/26/2021 0.900 240,000.00 264,516.00 264,438.02 259,996.80 07/15/2025 1,567 1,685.17 0.66 Iowa Westn Comm2.8 6/1/2023 462612SE3 02/12/2018 2.800 195,000.00 195,000.00 195,000.00 202,238.40 06/01/2023 792 1,820.00 0.54 Liberty Center Ohio 0 11/1/2025 530336DV5 08/18/2020 1.051 215,000.00 203,589.95 204,940.43 201,018.55 11/01/2025 1,676 0.00 0.59 Mankato Minn ISD 0.7 2/1/2025 563690RP3 10/22/2020 0.700 300,000.00 300,000.00 300,000.00 298,644.00 02/01/2025 1,403 927.50 0.83 Maricopa Cnty Ariz 5 7/1/2022 567389UY5 03/19/2020 1.700 500,000.00 536,785.00 520,156.77 530,195.00 07/01/2022 457 6,250.00 1.38 Massachusetts St Dev 2.785 5/1/2024 57584FEM8 12/20/2019 1.920 240,000.00 248,647.20 246,113.80 254,716.80 05/01/2024 1,127 2,785.00 0.66 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 258,462.75 12/07/2022 616 555.33 0.68 Monmouth OR Bds 2.9 4/1/2023 609694FZ2 01/30/2018 2.900 255,000.00 255,000.00 255,000.00 265,758.45 04/01/2023 731 3,697.50 0.70 Monona Wis Ref 3 10/1/2022 610100XT1 09/18/2018 3.000 200,000.00 200,000.00 200,000.00 207,920.00 10/01/2022 549 3,000.00 0.55 Nebraska State 3 12/15/2021 63968HE55 03/18/2020 1.651 370,000.00 378,532.20 373,469.14 377,107.70 12/15/2021 259 3,268.33 1.02 Northwest Local Sch District Hamilton & Butler 667712CF8 11/15/2019 2.069 360,000.00 376,408.80 370,831.81 384,642.00 12/01/2023 975 3,900.00 0.99 Northwest Local Sch District Hamilton & Butler 667712CG6 11/15/2019 2.169 370,000.00 389,010.60 383,832.46 400,632.30 12/01/2024 1,341 4,008.33 1.02 Oak Creek WIS 4 10/1/2023 671137-YP-6 11/27/2018 3.402 280,000.00 287,434.00 283,840.97 303,175.60 10/01/2023 914 5,600.00 0.77 Oklahoma Cnty Okla Metro 2.65 6/1/2024 67869T-AD-7 07/15/2019 2.286 500,000.00 508,255.00 505,361.35 531,290.00 06/01/2024 1,158 4,416.67 1.38 Orono ME Taxable 5 11/1/2025 687085DR8 10/29/2020 1.000 330,000.00 394,287.30 388,909.52 389,400.00 11/01/2025 1,676 6,966.67 0.91 Papio-Missouri Riv 4 12/15/2021 698874DQ4 03/18/2020 1.750 140,000.00 145,376.00 142,185.85 143,778.60 12/15/2021 259 1,648.89 0.39 Pelican Rapids Minn 0.8 2/1/2025 705863HR2 12/17/2020 0.700 525,000.00 527,126.25 526,979.51 522,632.25 02/01/2025 1,403 1,213.33 1.45 Rhode IS Infrastructure Bk 2.18 10/1/2023 7622F-DD-7 06/27/2019 2.151 435,000.00 435,522.00 435,306.43 453,026.40 10/01/2023 914 4,741.50 1.20 Richfield Minn ISD 3 2/1/2024 763342SZ6 09/04/2020 0.570 200,000.00 216,380.00 213,643.42 211,428.00 02/01/2024 1,037 1,000.00 0.55 Roanoke VA Taxable 2 2/1/2025 770078BD4 05/14/2020 1.250 300,000.00 310,266.00 308,354.52 313,521.00 02/01/2025 1,403 1,000.00 0.83 South Lyon MI 2.69 5/1/2022 838736VU7 10/23/2017 2.250 250,000.00 254,702.50 251,127.92 256,225.00 05/01/2022 396 2,802.08 0.69 St. Charles County MO Francis Howell School Distri 787642-4F-1 08/07/2019 2.531 200,000.00 209,956.00 205,352.69 205,564.00 03/01/2023 700 666.67 0.55 Trussville AL 0.822 10/1/2025 898242ND0 08/25/2020 0.710 300,000.00 301,677.00 301,480.76 297,267.00 10/01/2025 1,645 1,233.00 0.83 FHLMC Bond Local Government Investment Pool Municipal 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 Portfolio As of 3/31/2021 City of Prior Lake Portfolio Holdings Investment Portfolio - by Security Type Univ of North Carolina NC 1.778 12/1/2021 914713N24 12/20/2019 1.800 200,000.00 199,914.00 199,970.41 201,866.00 12/01/2021 245 1,185.33 0.55 Sub Total / Average Municipal Bond 1.744 11,730,000.00 12,047,018.05 11,956,895.98 12,154,167.90 907 103,835.44 32.37 Total / Average 1.304 36,234,565.43 36,551,642.63 36,461,546.90 37,103,995.93 543 132,452.64 100 YTM @ Cost Cost Value Days to Maturity % of Portfolio Cash - 4,687,739 1 12.82% Certificate of Deposit 2.308 11,385,059 767 31.15% FHLMC Bond 0.500 200,000 1,349 0.55% LGIP 0.050 8,231,827 1 22.52% Municipal Bond 1.740 12,047,018 912 32.96% Total / Average 1.306 36,551,643 547 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio - Diversification, by Security Type March 31, 2021 Description City of Prior Lake - Quarterly Investment Report Change from one 3/31/2020 6/30/2020 9/30/2020 12/31/2020 3/31/2021 year prior Market Value 10,336,802 13,106,722 12,793,321 13,942,057 12,919,565 2,582,763 1 1 1 1 1 0 0.60% 0.06% 0.04% 0.03% 0.03%-0.56% Fixed Income Assets 23,837,828 23,378,265 23,846,516 24,346,211 23,632,077 (205,751) 24,298,738 24,153,769 24,644,014 25,059,382 24,184,431 (114,307) 895 819 830 847 843 (52) 887 816 827 844 840 (47) 2.30% 2.28% 2.18% 2.06% 2.00%-0.29% Total Portfolio Value 34,174,630 36,484,987 36,639,837 38,288,268 36,551,642 2,377,012 34,635,540 37,260,491 37,437,335 39,001,439 37,103,996 2,468,456 134,643 98,112 129,719 99,282 132,453 (2,190) 460,909 775,504 797,498 713,171 552,353 91,444 623 523 538 537 543 (80) 617 521 536 535 541 (76) 1.78% 1.49% 1.43% 1.32% 1.31% -0.48% BENCHMARK 90 Day T-Bill 0.11% 0.16% 0.10% 0.09% 0.03% -0.08% 0.15%0.18%0.11%0.09%0.05%-0.10% 0.17%0.16%0.13%0.10%0.07%-0.10% Weighted Average Yield to Maturity @ Cost CITY OF PRIOR LAKE, MINNESOTA Quarterly Investment Report March 31, 2021 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 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