Loading...
HomeMy WebLinkAbout05(C) - Approval of 3rd Quarter 2021 Investment Report ReportYTM @  Cost Cost Value Days to  Maturity % of  Portfolio 0‐1 Month 0.051      14,657,610        1                    33.59% 1‐3 Months 1.500      1,818,454          66                  4.12% 3‐6 Months 3.000      245,000             110                0.56% 6‐9 Months 1.955      1,401,699          212                3.18% 9‐12 Months 1.906      2,444,129          325                5.45% 1‐2 Years 2.263      6,506,439          576                14.87% 2‐3 Years 2.055      4,977,052          950                11.27% 3‐4 Years 1.193      4,692,336          1,251             10.59% 4‐5 Years 0.984      4,600,037          1,636             10.28% 5‐10 Years 1.033      2,647,352          1,902             6.09% Total / Average 1.120 43,990,108        638                100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio ‐ Diversification, by Maturity Range September 30, 2021 Description City of Prior Lake ‐ Quarterly Investment Report YTM @  Cost Cost Value Days to  Maturity % of  Portfolio Cash ‐           1,238,319           1                    2.84% Certificate of Deposit 2.019       12,944,059        786               29.66% FFCB Bond 0.892       2,070,383           1,640            4.70% FHLB Bond 0.843       2,194,510           1,425            4.97% FHLMC Bond 0.500       200,000              1,166            0.46% LGIP 0.025       13,174,291        1                    30.19% Municipal Bond 1.594       11,873,538        907               26.50% Treasury Note 0.780       295,008              1,522            0.68% Total / Average 1.12 43,990,108 638               100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio ‐ Diversification, by Security Type September 30, 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 PortfolioCash - Northland Securities Cash CASH5845 2/3/2002 0.000 701,131.36 701,131.36 701,131.36 701,131.36 N/A 1 1.61Morgan Stanley Cash CASH5089 12/31/2010 0.000 518,044.90 518,044.90 518,044.90 518,044.90 N/A 1 1.19Oppenheimer Cash MM9905 12/27/2011 0.000 19,142.93 19,142.93 19,142.93 19,142.93 N/A 1 0.04Sub Total / Average Cash0.000 1,238,319.19 1,238,319.19 1,238,319.19 1,238,319.19 1 0.00 2.84Allegiance Bank TX 2.2 11/3/2022 01748DAY2 58,629 11/3/2017 2.200 245,000.00 245,000.00 245,000.00 250,529.65 11/3/2022 399 398.71 0.56Alma Bank 1.8 9/11/2023 020080BM8 58,424 9/11/2019 1.800 245,000.00 245,000.00 245,000.00 251,889.40 9/11/2023 711 229.56 0.56Bank Baroda New York 3.55 11/30/2023 06062R-7R-7 33,681 11/30/2018 3.550 245,000.00 245,000.00 245,000.00 261,588.95 11/30/2023 791 2,899.17 0.56Bank Hapoalim 0.95 7/23/2026 06251A2Y5 33,686 7/23/2021 0.950 245,000.00 245,000.00 245,000.00 245,004.90 7/23/2026 1,757 439.99 0.56Bank of New England 3.25 7/31/2023 06426KAN8 24,540 7/31/2018 3.250 245,000.00 245,000.00 245,000.00 258,134.45 7/31/2023 669 0.00 0.56Bankers Bank West Denver CO 1.8 9/30/2024 06610T-EE-1 23,210 9/30/2019 1.800 245,000.00 245,000.00 245,000.00 253,369.20 9/30/2024 1,096 0.00 0.56BankUnited Savings Miami 0.95 3/31/2026 066519QT9 33,134 3/31/2021 0.950 245,000.00 245,000.00 245,000.00 245,169.05 3/31/2026 1,643 0.00 0.56Barclays Bk Delaware 2.3 10/18/2022 06740KLD7 57,203 10/18/2017 2.300 245,000.00 245,000.00 245,000.00 250,603.15 10/18/2022 383 2,547.33 0.56BMW Bank of NA 1.8 4/11/2022 05580ASR6 35,141 10/11/2019 1.800 247,000.00 247,000.00 247,000.00 249,232.88 4/11/2022 193 2,095.10 0.57Capital BK3.15 10/28/2022 139797HC1 34,562 10/29/2018 3.150 245,000.00 245,000.00 245,000.00 252,977.20 10/28/2022 393 21.14 0.56Capital One Nat'l Assn McLean 2.1 8/14/2024 14042RMW8 4,297 8/14/2019 2.100 247,000.00 247,000.00 247,000.00 257,467.86 8/14/2024 1,049 667.92 0.57Celtic Bank 1.8 8/30/2023 15118RRF6 57,056 8/30/2019 1.800 245,000.00 245,000.00 245,000.00 251,833.05 8/30/2023 699 0.00 0.56CF Bank 3.15 9/18/2023 15721UCQ0 28,263 9/18/2018 3.150 245,000.00 245,000.00 245,000.00 258,416.20 9/18/2023 718 253.73 0.56Citibank Sioux Falls 3.15 7/25/2022 17312QP86 7,213 7/24/2018 3.150 245,000.00 245,000.00 245,000.00 251,200.95 7/25/2022 298 1,437.78 0.56City National Bank 3.05 8/8/2022 17801GBU2 3,814 8/6/2018 3.050 245,000.00 245,000.00 245,000.00 251,210.75 8/8/2022 312 491.34 0.56COMENITY BK SALT LAKE CITY UT 2.6 11/24/2021 20033AJN7 57,570 11/26/2014 2.600 245,000.00 245,000.00 245,000.00 245,972.65 11/24/2021 55 69.81 0.56Discover Bank 1.9 5/11/2023 254672YR3 5,649 9/17/2019 2.001 245,000.00 244,135.15 244,618.22 251,460.65 5/11/2023 588 1,810.99 0.56Enerbank USA 0.55 9/25/2025 29278TRL6 57,293 9/25/2020 0.550 245,000.00 245,000.00 245,000.00 243,089.00 9/25/2025 1,456 18.46 0.56Enterprise Bank & Trust 1.8 11/8/2024 29367SJQ8 27,237 11/8/2019 1.800 245,000.00 245,000.00 245,000.00 253,577.45 11/8/2024 1,135 265.81 0.56Enterprise Bank Allison Park PA 1.8 9/27/2024 29367R-LA-2 34,786 9/27/2019 1.800 245,000.00 245,000.00 245,000.00 253,359.40 9/27/2024 1,093 36.25 0.56First Natl Bank of Albany 1.6 2/28/2025 76T155845 3,067 2/28/2020 1.600 245,000.00 245,000.00 245,000.00 252,504.35 2/28/2025 1,247 21.48 0.56First Source Bank 1.7 10/29/2021 33646CLT9 9,087 12/31/2019 1.700 245,000.00 245,000.00 245,000.00 245,316.05 10/29/2021 29 1,049.81 0.56Firstbank Puerto Rico 1.8 9/6/2022 33767GAE8 30,387 9/6/2019 1.800 245,000.00 245,000.00 245,000.00 248,890.60 9/6/2022 341 289.97 0.56Flagstar Bank FSB 0.2 6/30/2023 33847E4Q7 32,541 6/30/2021 0.200 245,000.00 245,000.00 245,000.00 244,576.15 6/30/2023 638 123.51 0.56Goldman Sachs 2.4 9/6/2022 38148PPC5 33,124 9/6/2017 2.400 245,000.00 245,000.00 245,000.00 250,277.30 9/6/2022 341 386.63 0.56Goldman Sachs Bk 1 7/28/2026 38149MXK4 33,124 7/28/2021 1.000 245,000.00 245,000.00 245,000.00 244,701.10 7/28/2026 1,762 429.59 0.56Harden County 3.1 9/28/2023 412022CJ2 5,817 9/28/2018 3.100 245,000.00 245,000.00 245,000.00 258,325.55 9/28/2023 728 41.62 0.56Industrial & Coml NY 2.65 2/14/2023 45581EAR2 24,387 2/14/2018 2.650 245,000.00 245,000.00 245,000.00 253,212.40 2/14/2023 502 284.60 0.56Iowa State Clarksville 3.15 9/28/2023 46256YAY5 15,947 9/28/2018 3.150 245,000.00 245,000.00 245,000.00 258,577.90 9/28/2023 728 42.29 0.56JP Morgan Chase 1.1 12/31/2026-21 48128US67 628 4/20/2021 1.100 245,000.00 245,000.00 245,000.00 245,137.20 12/31/2026 1,918 1,203.52 0.56KS State Bank Manhattan 2.1 5/17/2022 50116CBE8 19,899 11/17/2017 2.100 245,000.00 245,000.00 245,000.00 248,113.95 5/17/2022 229 183.25 0.56Marine Bank 3 1/18/2022 56817TAH4 20,250 7/18/2018 3.000 245,000.00 245,000.00 245,000.00 247,131.50 1/18/2022 110 241.64 0.56Merrick Bank2.2 11/8/2022 59013JD71 34,519 11/8/2017 2.200 245,000.00 245,000.00 245,000.00 250,590.90 11/8/2022 404 324.88 0.56Morgan Stanley Bank Step 11/28/2027 61765QP52 32,992 9/2/2021 1.004 249,000.00 249,000.00 249,000.00 248,636.46 11/28/2027 2,250 225.12 0.57MS Private Bank 3.55 11/8/2023 61760ARS0 34,221 11/8/2018 3.550 245,000.00 245,000.00 245,000.00 260,841.70 11/8/2023 769 3,455.17 0.56National Cooperative Bank3.4 12/21/2023 635573AL2 323,612 12/24/2018 3.400 245,000.00 245,000.00 245,000.00 261,123.45 12/21/2023 812 2,305.01 0.56New York Community Bank 0.2 7/3/2023 649447VA4 16,022 6/30/2021 0.200 245,000.00 245,000.00 245,000.00 244,563.90 7/3/2023 641 123.51 0.56Northwest Bank 2 4/29/2022 66736ABJ7 58,752 11/10/2017 2.000 245,000.00 245,000.00 245,000.00 247,729.30 4/29/2022 211 0.00 0.56Preferred Bank LA Calif 1.95 8/30/2024 740367HR1 33,539 8/30/2019 1.950 249,000.00 249,000.00 249,000.00 258,536.70 8/30/2024 1,065 0.00 0.57Sallie Mae Bank Utah 1.9 9/18/2024 7954504D4 58,177 9/18/2019 1.900 245,000.00 245,000.00 245,000.00 254,060.10 9/18/2024 1,084 153.04 0.56Spring Bank3.25 10/24/2023 849430AY9 58,668 10/24/2018 3.250 245,000.00 245,000.00 245,000.00 259,457.45 10/24/2023 754 130.89 0.56STATE BK INDIA NEW YORK NY 2.6 12/6/2021 8562843H5 33,682 12/5/2014 2.600 245,000.00 245,000.00 245,000.00 246,124.55 12/6/2021 67 2,041.89 0.56Sterling Bank Poplar Bluff MO 3.1 1/11/2023 85916V-CY-9 57,813 1/11/2019 3.100 245,000.00 245,000.00 245,000.00 254,187.50 1/11/2023 468 1,685.47 0.56Synchrony Bank 0.9 8/6/2026 87165GD58 27,314 8/6/2021 0.900 248,000.00 248,000.00 248,000.00 249,014.32 8/6/2026 1,771 336.33 0.57Texas Exchange Bk 0.45 8/21/2024 88241TJE1 20,099 8/21/2020 0.450 245,000.00 245,000.00 245,000.00 243,816.65 8/21/2024 1,056 27.18 0.56TIAA FSB Jacksonville FLA 1.95 8/26/2022 87270LCR2 34,775 8/28/2019 1.950 247,000.00 247,000.00 247,000.00 251,196.53 8/26/2022 330 435.460.57Toyota Finl Svgs Bk 0.95 7/15/2026 89235MLC3 57,542 7/15/2021 0.950 245,000.00 245,000.00 245,000.00 245,066.15 7/15/2026 1,749 491.01 0.56UBS Bank USA 3.25 10/17/2022 90348JEG1 57,565 10/17/2018 3.250 245,000.00 245,000.00 245,000.00 253,028.65 10/17/2022 382 283.60 0.56Veritex Cmnty Bk 0.2 9/15/2023 923450CP3 57,665 9/15/2021 0.200 245,000.00 245,000.00 245,000.00 244,267.45 9/15/2023 715 20.14 0.56Washington Federal 1.95 8/28/2024 938828BN9 28,088 8/28/2019 1.950 245,000.00 245,000.00 245,000.00 254,368.80 8/28/2024 1,063 26.18 0.56Wells Fargo BK NA Sioux Falls 2.75 5/17/2024 949763-B6-2 3,511 6/11/2019 2.650 200,000.00 200,924.00 200,492.25 211,522.00 5/17/2024 960 195.89 0.46Wells Fargo Natl Bk West 1.8 12/13/2022 949495AA3 27,389 12/13/2019 1.800 245,000.00 245,000.00 245,000.00 249,831.40 12/13/2022 439 205.40 0.56Wex Bk Midvale 0.25 6/30/2023 92937CKM9 34,697 6/30/2021 0.250 232,000.00 232,000.00 232,000.00 231,800.48 6/30/2023 638 146.19 0.53Sub Total / Average Certificate Of Deposit2.019 12,944,000.00 12,944,059.15 12,944,110.47 13,252,615.28 786 30,593.36 29.66FFCB 0.69 7/22/2025-21 3133ELX33 4/15/2021 0.750 600,000.00 598,488.00 598,650.94 597,264.00 7/22/2025 1,391 782.00 1.37FFCB 0.72 10/27/2026-21 3133EMES7 6/18/2021 1.000 500,000.00 492,715.00 493,102.14 493,310.00 10/27/2026 1,853 1,530.00 1.15FFCB 0.74 11/24/2026-21 3133EMHC9 4/14/2021 1.053 450,000.00 442,350.00 442,980.66 443,785.50 11/24/2026 1,881 1,165.50 1.03FFCB 2.62 11/17/2025 3133EHJR5 9/24/2021 0.810 500,000.00 536,830.00 536,684.14 535,895.00 11/17/2025 1,509 4,839.72 1.15Sub Total / Average FFCB Bond0.892 2,050,000.00 2,070,383.00 2,071,417.88 2,070,254.50 1,640 8,317.22 4.70FHLB 5.375 9/30/2022 3133XMFY2 6/18/2021 0.115 450,000.00 480,343.50 473,614.88 473,710.50 9/30/2022 365 0.00 1.03FHLB Step 12/15/2025-21 3130AKJ72 4/13/2021 0.894 500,000.00 497,500.00 497,748.97 496,970.00 12/15/2025 1,537 364.58 1.15FHLN 5159508 1.25 10/16/2026-21 3130ALW83 4/16/2021 1.250 216,666.67 216,666.67 216,666.67 216,499.84 10/16/2026 1,842 1,233.80 0.50FHLN 5214149 Step 7/22/2026-21 3130AN4W7 7/22/2021 1.057 1,000,000.00 1,000,000.00 1,000,000.00 998,510.00 7/22/2026 1,756 944.44 2.29Sub Total / Average FHLB Bond0.843 2,166,666.67 2,194,510.17 2,188,030.52 2,185,690.34 1,425 2,542.82 4.97FHLMC 0.5 12/9/2024 3134GWA71 9/9/2020 0.500 200,000.00 200,000.00 200,000.00 199,096.00 12/9/2024 1,166 308.33 0.46Sub Total / Average FHLMC Bond0.500 200,000.00 200,000.00 200,000.00 199,096.00 1,166 308.33 0.464M ARPA Funds LGIP LGIP5401ARPA 8/2/2021 0.010 11.70 11.70 11.70 11.70 N/A 1 0.004MP ARPA Funds LMC LGIP LGIP5401MPARPA 9/1/2021 0.030 1,441,316.18 1,441,316.18 1,441,316.18 1,441,316.18 N/A 1 3.30League of Minnesota Cities - 4M Fund LGIP LGIP5101M 11/30/2010 0.010 933,797.46 933,797.46 933,797.46 933,797.46 N/A 1 2.14League of Minnesota Cities - 4M LGIP LGIP5204M2017A 6/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.030 8,484,418.93 8,484,418.93 8,484,418.93 8,484,418.93 N/A 1 19.44LMC 2021A LGIP LGIP52074M 6/23/2021 0.010 2,311,223.44 2,311,223.44 2,311,223.44 2,311,223.44 N/A 1 5.30LMC 2021B LGIP LGIP52084M 7/26/2021 0.010 3,523.03 3,523.03 3,523.03 3,523.03 N/A 1 0.01Sub Total / Average Local Government Investment Pool0.025 13,174,290.74 13,174,290.74 13,174,290.74 13,174,290.74 1 0.00 30.19Allen Park MI Public Sch Dist 2 11/2/2024 018033HR4 7/30/2020 0.751 290,000.00 305,140.90 300,985.91 301,147.60 11/2/2024 1,129 2,400.56 0.66Armada Mich Area Schools Ref Bond 2.712 5/1/2022 042105MG8 8/29/2019 1.750 400,000.00 409,996.00 402,181.50 405,632.00 5/1/2022 213 4,489.87 0.92Canadian Cnty Okla Indpt Sch Dist 2 11/1/2024 135537-GT-9 11/7/2019 2.000 285,000.00 285,000.00 285,000.00 295,513.65 11/1/2024 1,128 2,359.17 0.65Local Government Investment PoolMunicipal BondCity of Prior LakePortfolio HoldingsInvestment Portfolio - by Security TypeAs of 9/30/2021CashCertificate Of DepositFFCB BondFHLB BondFHLMC Bond Cecil Cnty MD 1.05 11/1/2026 1498433N2 9/23/2021 0.970 500,000.00 501,985.00 501,977.55 496,610.00 11/1/2026 1,858 102.08 1.15Central Cmnty Sch 2 3/1/2026 153135FJ2 3/4/2021 0.700 300,000.00 319,098.00 316,898.01 310,452.00 3/1/2026 1,613 483.33 0.69Columbus Ohio2.333 12/1/2022 199492-CT-4 8/26/2019 1.750 100,000.00 101,840.00 100,658.58 102,515.00 12/1/2022 427 771.19 0.23Columbus Ohio City Sch Dist 2.036 12/1/2022 199507-6K-5 10/17/2019 1.901 135,000.00 135,552.15 135,206.63 137,613.60 12/1/2022 427 908.560.31Edgewood Ohio City 5 12/1/2023 280455ET9 12/19/2019 2.101 215,000.00 238,512.40 227,904.93 234,741.30 12/1/2023 792 3,553.47 0.49El Paso TX ISD 0 8/15/2024 283770NS0 10/30/2020 0.700 500,000.00 486,925.00 490,087.55 487,845.00 8/15/2024 1,050 0.00 1.15Federal Way Wash2.2 12/1/2024 314031-HH-1 12/11/2019 2.150 475,000.00 476,111.50 475,708.37 495,942.75 12/1/2024 1,158 3,454.31 1.09Hempstead NY1.125 12/1/2021 424092HH0 12/1/2020 0.350 600,000.00 604,632.00 600,786.81 600,858.00 12/1/2021 62 5,606.25 1.37Hennepin Cnty 5 12/1/2025 425507BS8 12/4/2020 2.976 115,000.00 125,723.75 123,959.01 121,362.95 12/1/2025 1,523 1,900.69 0.26Indiana Bond Bank 3.326 7/15/2025 45462TER9 3/26/2021 0.900 240,000.00 264,516.00 261,584.06 260,532.00 7/15/2025 1,384 1,663.00 0.55Iowa Westn Comm2.8 6/1/2023 462612SE3 2/12/2018 2.800 195,000.00 195,000.00 195,000.00 200,510.70 6/1/2023 609 1,804.83 0.45Liberty Center Ohio 0 11/1/2025 530336DV5 8/18/2020 1.051 215,000.00 203,589.95 206,038.82 203,921.05 11/1/2025 1,493 0.00 0.49Mankato Minn ISD 0.7 2/1/2025 563690RP3 10/22/2020 0.700 300,000.00 300,000.00 300,000.00 298,671.00 2/1/2025 1,220 344.17 0.69Maricopa Cnty Ariz 5 7/1/2022 567389UY5 3/19/2020 1.700 500,000.00 536,785.00 512,085.24 518,060.00 7/1/2022 274 6,180.56 1.15Massachusetts St 0.986 11/1/2026 57582RK96 6/30/2021 1.000 500,000.00 499,635.00 499,652.22 496,020.00 11/1/2026 1,858 2,040.47 1.15Massachusetts St Dev 2.785 5/1/2024 57584FEM8 12/20/2019 1.920 240,000.00 248,647.20 245,121.05 252,000.00 5/1/2024 944 2,766.43 0.55Medallion Bk Salt Lake City 3.4 12/7/2022 58404D-CX-7 57,449 12/7/2018 3.400 245,000.00 245,000.00 245,000.00 254,420.25 12/7/2022 433 532.19 0.56Monmouth OR Bds 2.9 4/1/2023 609694FZ2 1/30/2018 2.900 255,000.00 255,000.00 255,000.00 264,164.70 4/1/2023 548 3,676.96 0.58Monona Wis Ref 3 10/1/2022 610100XT1 9/18/2018 3.000 200,000.00 200,000.00 200,000.00 205,308.00 10/1/2022 366 2,983.33 0.46Nebraska State 3 12/15/2021 63968HE55 3/18/2020 1.651 370,000.00 378,532.20 371,017.97 372,016.50 12/15/2021 76 3,237.50 0.85Northwest Local Sch District Hamilton & Butler 667712CF8 11/15/2019 2.069 360,000.00 376,408.80 368,798.76 379,663.20 12/1/2023 792 3,867.50 0.82Northwest Local Sch District Hamilton & Butler 667712CG6 11/15/2019 2.169 370,000.00 389,010.60 381,944.80 396,011.00 12/1/2024 1,158 3,974.93 0.85Oak Creek WIS 4 10/1/2023 671137-YP-6 11/27/2018 3.402 280,000.00 287,434.00 283,071.94 299,544.00 10/1/2023 731 5,568.89 0.64Oklahoma Cnty Okla Metro 2.65 6/1/2024 67869T-AD-7 7/15/2019 2.286 500,000.00 508,255.00 504,514.09 525,640.00 6/1/2024 975 4,379.86 1.15Orono ME Taxable 5 11/1/2025 687085DR8 10/29/2020 1.000 330,000.00 394,287.30 382,477.28 383,262.00 11/1/2025 1,493 6,829.17 0.76Papio-Missouri Riv 4 12/15/2021 698874DQ4 3/18/2020 1.750 140,000.00 145,376.00 140,641.41 141,066.80 12/15/2021 76 1,633.33 0.32Pelican Rapids Minn 0.8 2/1/2025 705863HR2 12/17/2020 0.700 525,000.00 527,126.25 526,721.32 522,338.25 2/1/2025 1,220 688.33 1.20Rhode IS Infrastructure Bk 2.18 10/1/2023 7622FDD7 6/27/2019 2.151 435,000.00 435,522.00 435,245.08 450,834.00 10/1/2023 731 4,715.16 1.00Richfield Minn ISD 3 2/1/2024 763342SZ6 9/4/2020 0.570 200,000.00 216,380.00 211,235.76 209,182.00 2/1/2024 854 983.33 0.46Roanoke VA Taxable 2 2/1/2025 770078BD4 5/14/2020 1.250 300,000.00 310,266.00 307,264.80 312,036.00 2/1/2025 1,220 983.33 0.69South Lyon MI 2.69 5/1/2022 838736VU7 10/23/2017 2.250 250,000.00 254,702.50 250,606.68 253,357.50 5/1/2022 213 2,783.40 0.57St. Charles County MO Francis Howell School Distri 787642-4F-1 8/7/2019 2.531 200,000.00 209,956.00 203,953.34 202,990.00 3/1/2023 517 644.44 0.46Trussville AL 0.822 10/1/2025 898242ND0 8/25/2020 0.710 300,000.00 301,677.00 301,316.04 297,183.00 10/1/2025 1,462 1,226.15 0.69Univ of North Carolina NC 1.778 12/1/2021 914713N24 12/20/2019 1.800 200,000.00 199,914.00 199,992.51 200,554.00 12/1/2021 62 1,175.46 0.46Sub Total / Average Municipal Bond1.594 11,565,000.00 11,873,537.50 11,749,638.02 11,889,519.80 907 90,712.20 26.50T-Note 0.375 11/30/2025 91282CAZ4 9/24/2021 0.780 300,000.00 295,008.00 295,027.60 294,177.00 11/30/2025 1,522 375.00 0.69Sub Total / Average Treasury Note0.780 300,000.00 295,008.00 295,027.60 294,177.00 1,522 375.00 0.69Total / Average1.120 43,638,276.60 43,990,107.75 43,860,834.42 44,303,962.85 638 132,848.93 100Treasury Note Change from one 9/30/2020 12/31/2020 3/31/2021 6/30/2021 9/30/2021 year prior Market Value 12,793,321 13,942,057 12,919,565 14,932,703 14,412,610 1,619,289 111110 0.04% 0.03% 0.03% 0.01% 0.02%‐0.01% Fixed Income Assets 23,846,516 24,346,211 23,632,077 26,700,008 29,577,498 5,730,982 24,644,014 25,059,382 24,184,431 27,166,384 29,891,353 5,247,339 830 847 843 951 951 121 827 844 840 765 800 (27) 2.18% 2.06% 2.00% 1.75% 1.66%‐0.52% Total Portfolio Value 36,639,837 38,288,268 36,551,642 41,632,711 43,990,108 7,350,271 37,437,335 39,001,439 37,103,996 42,099,087 44,303,963 6,866,628 129,719 99,282 132,453 98,504 132,849 3,130 797,498 713,171 552,353 466,376 313,855 (483,643) 538 537 543 607 638 100 536 535 541 489 536 0 1.43% 1.32% 1.31% 1.13% 1.12%‐0.31% BENCHMARK 90 Day T‐Bill 0.10% 0.09% 0.03% 0.05% 0.04%‐0.06% 0.11% 0.09% 0.05% 0.06% 0.05%‐0.06% 0.13% 0.10% 0.07% 0.07% 0.09%‐0.04% 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 September 30, 2021 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 City of Prior Lake ‐ Quarterly Investment Report