Loading...
HomeMy WebLinkAbout05(D) - Approve 4th Quarter 2021 Investment Report ReportYTM @  Cost Cost Value Days to  Maturity % of  Portfolio 0‐1 Month 0.078      13,873,317        1                    31.43% 3‐6 Months 1.955      1,401,698          120                3.14% 6‐9 Months 2.221      1,518,785          213                3.36% 9‐12 Months 2.141      2,632,736          305                5.89% 1‐2 Years 2.126      7,022,322          597                15.79% 2‐3 Years 1.609      5,893,677          972                13.20% 3‐4 Years 0.924      5,770,110          1,315             12.70% 4‐5 Years 1.054      6,162,260          1,722             13.92% 5‐10 Years 1.004      249,000             2,158             0.57% Total / Average 1.104 44,523,905        671                100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio ‐ Diversification, by Maturity Range December 31, 2021 Description City of Prior Lake ‐ Quarterly Investment Report YTM @  Cost Cost Value Days to  Maturity % of  Portfolio Cash ‐           1,220,151           1                    2.76% Certificate of Deposit 1.930       12,445,896        727               28.21% FFCB Bond 0.890       2,070,383           1,548            4.64% FHLB Bond 0.960       3,139,360           1,476            7.06% FHLMC Bond 0.500       200,000              1,074            0.45% LGIP 0.028       12,408,166        1                    28.11% Municipal Bond 1.551       12,744,941        978               28.07% Treasury Note 0.780       295,008              1,430            0.70% Total / Average 1.104 44,523,905 671               100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio ‐ Diversification, by Security Type December 31, 2021 Description City of Prior Lake ‐ Quarterly Investment Report Description CUSIP/Ticker Settlement Date YTM @ Cost Face Amount/Shares Cost Value Book Value Market Value Maturity Date Days To MaturityAccrued Interest % of PortfolioCash - Northland Securities Cash CASH5845 2/3/2002 0.000 257,986.54 257,986.54 257,986.54 257,986.54 N/A 1 0.58Morgan Stanley Cash CASH5089 12/31/2010 0.000 796,095.42 796,095.42 796,095.42 796,095.42 N/A 1 1.80Oppenheimer Cash MM9905 12/27/2011 0.000 166,069.07 166,069.07 166,069.07 166,069.07 N/A 1 0.38Sub Total / Average Cash0.000 1,220,151.03 1,220,151.03 1,220,151.03 1,220,151.03 1 0.00 2.76Allegiance Bank TX 2.2 11/3/2022 01748DAY2 11/3/2017 2.200 245,000.00 245,000.00 245,000.00 248,868.55 11/3/2022 307 413.48 0.56Alma Bank 1.8 9/11/2023 020080BM8 9/11/2019 1.800 245,000.00 245,000.00 245,000.00 250,127.85 9/11/2023 619 241.64 0.56Bank Baroda New York 3.55 11/30/2023 06062R-7R-7 11/30/2018 3.550 245,000.00 245,000.00 245,000.00 258,631.80 11/30/2023 699 724.79 0.56Bank Hapoalim 0.95 7/23/2026 06251A2Y5 7/23/2021 0.950 245,000.00 245,000.00 245,000.00 241,910.55 7/23/2026 1,665 1,026.65 0.56Bank of New England 3.25 7/31/2023 06426KAN8 7/31/2018 3.250 245,000.00 245,000.00 245,000.00 255,535.00 7/31/2023 577 0.00 0.56Bankers Bank West Denver CO 1.8 9/30/2024 06610T-EE-1 9/30/2019 1.800 245,000.00 245,000.00 245,000.00 251,411.65 9/30/2024 1,004 12.08 0.56BankUnited Savings Miami 0.95 3/31/2026 066519QT9 3/31/2021 0.950 245,000.00 245,000.00 245,000.00 242,677.40 3/31/2026 1,551 0.00 0.56Barclays Bk Delaware 2.3 10/18/2022 06740KLD7 10/18/2017 2.300 245,000.00 245,000.00 245,000.00 248,888.15 10/18/2022 291 1,142.44 0.56BMW Bank of NA 1.8 4/11/2022 05580ASR6 10/11/2019 1.800 247,000.00 247,000.00 247,000.00 248,071.98 4/11/2022 101 986.65 0.56Capital BK3.15 10/28/2022 139797HC1 10/29/2018 3.150 245,000.00 245,000.00 245,000.00 250,735.45 10/28/2022 301 42.29 0.56Capital One Nat'l Assn McLean 2.1 8/14/2024 14042RMW8 8/14/2019 2.100 247,000.00 247,000.00 247,000.00 255,291.79 8/14/2024 957 1,975.32 0.56Celtic Bank 1.8 8/30/2023 15118RRF6 8/30/2019 1.800 245,000.00 245,000.00 245,000.00 250,083.75 8/30/2023 607 0.00 0.56CF Bank 3.15 9/18/2023 15721UCQ0 9/18/2018 3.150 245,000.00 245,000.00 245,000.00 255,811.85 9/18/2023 626 274.87 0.56Citibank Sioux Falls 3.15 7/25/2022 17312QP86 7/24/2018 3.150 245,000.00 245,000.00 245,000.00 249,020.45 7/25/2022 206 3,383.01 0.56City National Bank 3.05 8/8/2022 17801GBU2 8/6/2018 3.050 245,000.00 245,000.00 245,000.00 249,118.45 8/8/2022 220 511.82 0.56Discover Bank 1.9 5/11/2023 254672YR3 9/17/2019 2.001 245,000.00 244,135.15 244,677.95 249,784.85 5/11/2023 496 637.67 0.56Enerbank USA 0.55 9/25/2025 29278TRL6 9/25/2020 0.550 245,000.00 245,000.00 245,000.00 240,313.15 9/25/2025 1,364 22.15 0.56Enterprise Bank & Trust 1.8 11/8/2024 29367SJQ8 11/8/2019 1.800 245,000.00 245,000.00 245,000.00 251,468.00 11/8/2024 1,043 277.89 0.56Enterprise Bank Allison Park PA 1.8 9/27/2024 29367R-LA-2 9/27/2019 1.800 245,000.00 245,000.00 245,000.00 251,387.15 9/27/2024 1,001 1,147.81 0.56First Natl Bank of Albany 1.6 2/28/2025 32117WAN2 2/28/2020 1.600 245,000.00 245,000.00 245,000.00 250,051.90 2/28/2025 1,155 32.22 0.56Firstbank Puerto Rico 1.8 9/6/2022 33767GAE8 9/6/2019 1.800 245,000.00 245,000.00 245,000.00 247,528.40 9/6/2022 249 302.05 0.56Flagstar Bank FSB 0.2 6/30/2023 33847E4Q7 6/30/2021 0.200 245,000.00 245,000.00 245,000.00 243,895.05 6/30/2023 546 1.34 0.56Goldman Sachs Bk 1 7/28/2026 38149MXK4 7/28/2021 1.000 245,000.00 245,000.00 245,000.00 241,631.25 7/28/2026 1,670 1,047.12 0.56Harden County 3.1 9/28/2023 412022CJ2 9/28/2018 3.100 245,000.00 245,000.00 245,000.00 255,738.35 9/28/2023 636 62.42 0.56Industrial & Coml NY 2.65 2/14/2023 45581EAR2 2/14/2018 2.650 245,000.00 245,000.00 245,000.00 251,193.60 2/14/2023 410 302.39 0.56Iowa State Clarksville 3.15 9/28/2023 46256YAY5 9/28/2018 3.150 245,000.00 245,000.00 245,000.00 255,919.65 9/28/2023 636 1,987.52 0.56KS State Bank Manhattan 2.1 5/17/2022 50116CBE8 11/17/2017 2.100 245,000.00 245,000.00 245,000.00 246,724.80 5/17/2022 137 197.34 0.56Luana Savings Bank 0.2 5/7/2024 549104XH5 11/22/2021 0.699 240,000.00 237,081.60 237,208.49 236,997.60 5/7/2024 858 71.01 0.54Marine Bank 3 1/18/2022 56817TAH4 7/18/2018 3.000 245,000.00 245,000.00 245,000.00 245,338.10 1/18/2022 18 261.78 0.56Merrick Bank2.2 11/8/2022 59013JD71 11/8/2017 2.200 245,000.00 245,000.00 245,000.00 248,924.90 11/8/2022 312 339.64 0.56Morgan Stanley Bank Step 11/28/2027 61765QP52 9/2/2021 1.004 249,000.00 249,000.00 249,000.00 243,173.40 11/28/2027 2,158 225.12 0.56MS Private Bank 3.55 11/8/2023 61760ARS0 11/8/2018 3.550 245,000.00 245,000.00 245,000.00 257,955.60 11/8/2023 677 1,262.92 0.56National Cooperative Bank3.4 12/21/2023 635573AL2 12/24/2018 3.400 245,000.00 245,000.00 245,000.00 258,259.40 12/21/2023 720 228.22 0.56New York Community Bank 0.2 7/3/2023 649447VA4 6/30/2021 0.200 245,000.00 245,000.00 245,000.00 243,880.35 7/3/2023 549 1.34 0.56Northwest Bank 2 4/29/2022 66736ABJ7 11/10/2017 2.000 245,000.00 245,000.00 245,000.00 246,428.35 4/29/2022 119 0.00 0.56Preferred Bank LA Calif 1.95 8/30/2024 740367HR1 8/30/2019 1.950 249,000.00 249,000.00 249,000.00 256,455.06 8/30/2024 973 0.00 0.56Sallie Mae Bank Utah 1.9 9/18/2024 7954504D4 9/18/2019 1.900 245,000.00 245,000.00 245,000.00 252,026.60 9/18/2024 992 1,326.36 0.56Spring Bank3.25 10/24/2023 849430AY9 10/24/2018 3.250 245,000.00 245,000.00 245,000.00 256,750.20 10/24/2023 662 152.71 0.56State Bk India New York 0.65 12/29/2023 856285A92 12/29/2021 0.650 245,000.00 245,000.00 245,000.00 245,007.35 12/29/2023 728 8.73 0.56Sterling Bank Poplar Bluff MO 3.1 1/11/2023 85916V-CY-9 1/11/2019 3.100 245,000.00 245,000.00 245,000.00 251,886.95 1/11/2023 376 3,599.82 0.56Synchrony Bank 0.9 8/6/2026 87165GD58 8/6/2021 0.900 248,000.00 248,000.00 248,000.00 245,812.64 8/6/2026 1,679 898.92 0.56Texas Exchange Bk 0.45 8/21/2024 88241TJE1 8/21/2020 0.450 245,000.00 245,000.00 245,000.00 242,697.00 8/21/2024 964 30.21 0.56TIAA FSB Jacksonville FLA 1.95 8/26/2022 87270LCR2 8/28/2019 1.950 247,000.00 247,000.00 247,000.00 249,704.65 8/26/2022 238 1,649.49 0.56Toyota Finl Svgs Bk 0.95 7/15/2026 89235MLC3 7/15/2021 0.950 245,000.00 245,000.00 245,000.00 241,966.90 7/15/2026 1,657 1,077.66 0.56UBS Bank USA 3.25 10/17/2022 90348JEG1 10/17/2018 3.250 245,000.00 245,000.00 245,000.00 250,730.55 10/17/2022 290 305.41 0.56Veritex Cmnty Bk 0.2 9/15/2023 923450CP3 9/15/2021 0.200 245,000.00 245,000.00 245,000.00 243,485.90 9/15/2023 623 21.48 0.56Washington Federal 1.95 8/28/2024 938828BN9 8/28/2019 1.950 245,000.00 245,000.00 245,000.00 252,320.60 8/28/2024 971 39.27 0.56Webbank 0.4 10/30/2023-22 947547NL5 11/8/2021 0.449 245,000.00 244,755.00 244,773.01 244,105.75 10/30/2023 668 5.37 0.56Wells Fargo BK NA Sioux Falls 2.75 5/17/2024 949763-B6-2 6/11/2019 2.650 200,000.00 200,924.00 200,445.08 209,462.00 5/17/2024 868 210.960.45Wells Fargo Natl Bk West 1.8 12/13/2022 949495AA3 12/13/2019 1.800 245,000.00 245,000.00 245,000.00 248,388.35 12/13/2022 347 217.48 0.56Wex Bk Midvale 0.25 6/30/2023 92937CKM9 6/30/2021 0.250 232,000.00 232,000.00 232,000.00 231,127.68 6/30/2023 546 1.59 0.53Sub Total / Average Certificate Of Deposit1.930 12,449,000.00 12,445,895.75 12,446,104.53 12,644,706.70 727 28,688.45 28.21FFCB 0.69 7/22/2025-21 3133ELX33 4/15/2021 0.750 600,000.00 598,488.00 598,740.16 590,376.00 7/22/2025 1,299 1,828.50 1.36FFCB 0.72 10/27/2026-21 3133EMES7 6/18/2021 1.000 500,000.00 492,715.00 493,444.62 485,325.00 10/27/2026 1,761 640.00 1.13FFCB 0.74 11/24/2026-21 3133EMHC9 4/14/2021 1.053 450,000.00 442,350.00 443,323.98 439,308.00 11/24/2026 1,789 342.25 1.02FFCB 2.62 11/17/2025 3133EHJR5 9/24/2021 0.810 500,000.00 536,830.00 534,447.60 527,560.00 11/17/2025 1,417 1,601.11 1.13Sub Total / Average FFCB Bond0.892 2,050,000.00 2,070,383.00 2,069,956.36 2,042,569.00 1,548 4,411.86 4.64FHLB 1 12/30/2026-21 3130ANY87 10/20/2021 1.205 500,000.00 494,850.00 495,045.47 492,715.00 12/30/2026 1,825 0.00 1.13FHLB 1.25 11/10/2026-22 3130APLR4 11/10/2021 1.250 450,000.00 450,000.00 450,000.00 448,717.50 11/10/2026 1,775 796.87 1.02FHLB 5.375 9/30/2022 3133XMFY2 6/18/2021 0.115 450,000.00 480,343.50 467,662.63 466,996.50 9/30/2022 273 6,046.88 1.02FHLB Step 12/15/2025-21 3130AKJ72 4/13/2021 0.894 500,000.00 497,500.00 497,883.71 492,995.00 12/15/2025 1,445 66.67 1.13FHLN 5159508 1.25 10/16/2026-21 3130ALW83 4/16/2021 1.250 216,666.67 216,666.67 216,666.67 215,206.34 10/16/2026 1,750 564.24 0.49FHLN 5214149 Step 7/22/2026-21 3130AN4W7 7/22/2021 1.057 1,000,000.00 1,000,000.00 1,000,000.00 994,700.00 7/22/2026 1,664 2,208.33 2.27Sub Total / Average FHLB Bond0.960 3,116,666.67 3,139,360.17 3,127,258.48 3,111,330.34 1,476 9,682.99 7.06FHLMC 0.5 12/9/2024 3134GWA71 9/9/2020 0.500 200,000.00 200,000.00 200,000.00 197,116.00 12/9/2024 1,074 61.11 0.45Sub Total / Average FHLMC Bond0.500 200,000.00 200,000.00 200,000.00 197,116.00 1,074 61.11 0.454M ARPA Funds LGIP LGIP5401MARPA 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,424.76 1,441,424.76 1,441,424.76 1,441,424.76 N/A 1 3.27League of Minnesota Cities - 4M Fund LGIP LGIP5101M 11/30/2010 0.010 1,426,103.76 1,426,103.76 1,426,103.76 1,426,103.76 N/A 1 3.23League 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,623,999.52 8,623,999.52 8,623,999.52 8,623,999.52 N/A 1 19.54League of Minnesota Cities LGIP LGIP5207MP 10/12/2021 0.030 916,625.39 916,625.39 916,625.39 916,625.39 N/A 1 2.08LMC 2021A LGIP LGIP5207M 6/23/2021 0.010 1.32 1.32 1.32 1.32 N/A 1 0.00Sub Total / Average Local Government Investment Pool0.028 12,408,166.45 12,408,166.45 12,408,166.45 12,408,166.45 1 0.00 28.11Local Government Investment PoolCity of Prior LakePortfolio HoldingsInvestment Portfolio - by Security TypeAs of 12/31/2021CashCertificate Of DepositFFCB BondFHLB BondFHLMC Bond Description CUSIP/Ticker Settlement Date YTM @ Cost Face Amount/Shares Cost Value Book Value Market Value Maturity Date Days To MaturityAccrued Interest % of PortfolioCity of Prior LakePortfolio HoldingsInvestment Portfolio - by Security TypeAs of 12/31/2021Allen Park MI Public Sch Dist 2 11/2/2024 018033HR4 7/30/2020 0.751 290,000.00 305,140.90 300,090.69 297,174.60 11/2/2024 1,037 966.67 0.66Armada Mich Area Schools Ref Bond 2.712 5/1/2022 042105MG8 8/29/2019 1.750 400,000.00 409,996.00 401,239.26 403,132.00 5/1/2022 121 1,808.00 0.91Canadian 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 291,651.90 11/1/2024 1,036 950.00 0.65Cecil Cnty MD 1.05 11/1/2026 1498433N2 9/23/2021 0.970 500,000.00 501,985.00 501,879.63 491,200.00 11/1/2026 1,766 875.00 1.13Central Cmnty Sch 2 3/1/2026 153135FJ2 3/4/2021 0.700 300,000.00 319,098.00 315,934.21 306,351.00 3/1/2026 1,521 2,000.00 0.68Columbus Ohio2.333 12/1/2022 199492-CT-4 8/26/2019 1.750 100,000.00 101,840.00 100,516.68 101,678.00 12/1/2022 335 194.42 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,162.11 136,853.55 12/1/2022 335 229.050.31Edgewood Ohio City 5 12/1/2023 280455ET9 12/19/2019 2.101 215,000.00 238,512.40 226,405.88 230,851.95 12/1/2023 700 895.83 0.49El Paso TX ISD 0 8/15/2024 283770NS0 10/30/2020 0.700 500,000.00 486,925.00 490,956.06 484,340.00 8/15/2024 958 0.00 1.13Falmouth ME Taxable 3 10/15/2025 306783NF4 10/15/2021 0.800 340,000.00 369,386.20 367,837.44 363,089.40 10/15/2025 1,384 2,153.33 0.77Federal Way Wash2.2 12/1/2024 314031-HH-1 12/11/2019 2.150 475,000.00 476,111.50 475,652.10 489,159.75 12/1/2024 1,066 870.83 1.08Hawaii St Taxable 1.033 8/1/2025 419792F92 10/12/2021 0.950 300,000.00 300,924.00 300,870.78 297,360.00 8/1/2025 1,309 680.06 0.68Hennepin Cnty 5 12/1/2025 425507BS8 12/4/2020 2.976 115,000.00 125,723.75 123,417.82 120,012.85 12/1/2025 1,431 479.17 0.26Indiana Bond Bank 3.326 7/15/2025 45462TER9 3/26/2021 0.900 240,000.00 264,516.00 260,149.28 256,310.40 7/15/2025 1,292 3,680.77 0.54Iowa Westn Comm2.8 6/1/2023 462612SE3 2/12/2018 2.800 195,000.00 195,000.00 195,000.00 198,773.25 6/1/2023 517 455.00 0.44Liberty Center Ohio 0 11/1/2025 530336DV5 8/18/2020 1.051 215,000.00 203,589.95 206,591.02 202,166.65 11/1/2025 1,401 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 295,503.00 2/1/2025 1,128 875.00 0.68Maricopa Cnty Ariz 5 7/1/2022 567389UY5 3/19/2020 1.700 500,000.00 536,785.00 508,027.42 512,005.00 7/1/2022 182 12,500.00 1.13Massachusetts St 0.986 11/1/2026 57582RK96 6/30/2021 1.000 500,000.00 499,635.00 499,669.44 488,795.00 11/1/2026 1,766 821.67 1.13Massachusetts St Dev 2.785 5/1/2024 57584FEM8 12/20/2019 1.920 240,000.00 248,647.20 244,621.97 248,683.20 5/1/2024 852 1,114.00 0.54Medallion Bk Salt Lake City 3.4 12/7/2022 58404D-CX-7 12/7/2018 3.400 245,000.00 245,000.00 245,000.00 252,002.10 12/7/2022 341 555.33 0.56Milwaukee Cnty Wis 2 12/1/2026 6022453V2 11/23/2021 1.300 500,000.00 516,960.00 516,608.59 517,350.00 12/1/2026 1,796 1,055.56 1.13Monmouth OR Bds 2.9 4/1/2023 609694FZ2 1/30/2018 2.900 255,000.00 255,000.00 255,000.00 261,640.20 4/1/2023 456 1,848.75 0.58Monona Wis Ref 3 10/1/2022 610100XT1 9/18/2018 3.000 200,000.00 200,000.00 200,000.00 203,684.00 10/1/2022 274 1,500.00 0.45Northwest Local Sch District Hamilton & Butler 667712CF8 11/15/2019 2.069 360,000.00 376,408.80 367,776.68 374,745.60 12/1/2023 700 975.00 0.82Northwest Local Sch District Hamilton & Butler 667712CG6 11/15/2019 2.169 370,000.00 389,010.60 380,995.82 389,931.90 12/1/2024 1,066 1,002.08 0.84Oak Creek WIS 4 10/1/2023 671137-YP-6 11/27/2018 3.402 280,000.00 287,434.00 282,685.32 295,352.40 10/1/2023 639 2,800.00 0.63Oklahoma Cnty Okla Metro 2.65 6/1/2024 67869T-AD-7 7/15/2019 2.286 500,000.00 508,255.00 504,088.15 518,570.00 6/1/2024 883 1,104.17 1.13Oregon Edu Dists 0.312 6/30/2023 68587FAT1 12/17/2021 0.550 385,000.00 383,598.60 383,633.64 382,870.95 6/30/2023 546 0.00 0.87Orono ME Taxable 5 11/1/2025 687085DR8 10/29/2020 1.000 330,000.00 394,287.30 379,243.58 375,870.00 11/1/2025 1,401 2,750.00 0.75Pelican Rapids Minn 0.8 2/1/2025 705863HR2 12/17/2020 0.700 525,000.00 527,126.25 526,591.51 517,146.00 2/1/2025 1,128 1,750.00 1.19Pennsylvania St Univ 1.645 9/1/2025 709235S48 12/6/2021 1.120 250,000.00 254,787.50 254,699.82 251,022.50 9/1/2025 1,340 1,370.83 0.57Rhode IS Infrastructure Bk 2.18 10/1/2023 7622FDD7 6/27/2019 2.151 435,000.00 435,522.00 435,214.23 444,504.75 10/1/2023 639 2,370.75 0.99Richfield Minn ISD 3 2/1/2024 763342SZ6 9/4/2020 0.570 200,000.00 216,380.00 210,025.35 208,674.00 2/1/2024 762 2,500.00 0.45Roanoke VA Taxable 2 2/1/2025 770078BD4 5/14/2020 1.250 300,000.00 310,266.00 306,716.97 307,791.00 2/1/2025 1,128 2,500.00 0.68South Lyon MI 2.69 5/1/2022 838736VU7 10/23/2017 2.250 250,000.00 254,702.50 250,344.64 251,865.00 5/1/2022 121 1,120.83 0.57St. Charles County MO Francis Howell School Distri 787642-4F-1 8/7/2019 2.531 200,000.00 209,956.00 203,249.85 201,110.00 3/1/2023 425 2,666.67 0.45Trussville AL 0.822 10/1/2025 898242ND0 8/25/2020 0.710 300,000.00 301,677.00 301,233.22 293,889.00 10/1/2025 1,370 616.50 0.68Wauwatosa WI 3 12/1/2024-22 9435042U3 10/28/2021 2.014 200,000.00 205,880.00 205,546.97 203,488.00 12/1/2024 1,066 500.00 0.45Wisconsin St Gen Fund 2.877 5/1/2024 977100EA0 12/2/2021 0.700 160,000.00 168,321.60 168,047.68 166,612.80 5/1/2024 852 767.20 0.36Sub Total / Average Municipal Bond1.551 12,390,000.00 12,744,941.20 12,615,723.81 12,633,211.70 978 61,302.47 28.07T-Note 0.375 11/30/2025 91282CAZ4 9/24/2021 0.780 300,000.00 295,008.00 295,328.17 291,069.00 11/30/2025 1,430 95.81 0.68Sub Total / Average Treasury Note0.780 300,000.00 295,008.00 295,328.17 291,069.00 1,430 95.81 0.68Total / Average1.104 44,133,984.15 44,523,905.60 44,382,688.83 44,548,320.22 671 104,242.69 100Municipal BondTreasury Note Change from one 12/31/2020 3/31/2021 6/30/2021 9/30/2021 12/31/2021 year prior Market Value 13,942,057 12,919,565 14,932,703 14,412,610 13,628,317 (313,740) 111110 0.03% 0.03% 0.01% 0.02% 0.03%‐0.01% Fixed Income Assets 24,346,211 23,632,077 26,700,008 29,577,498 30,895,588 6,549,377 25,059,382 24,184,431 27,166,384 29,891,353 30,920,003 5,860,621 847 843 951 951 970 123 844 840 765 800 895 51 2.06% 2.00% 1.75% 1.66% 1.58%‐0.47% Total Portfolio Value 38,288,268 36,551,642 41,632,711 43,990,108 44,523,905 6,235,637 39,001,439 37,103,996 42,099,087 44,303,963 44,548,320 5,546,881 99,282 132,453 98,504 132,849 104,243 4,961 713,171 552,353 466,376 313,855 24,415 (688,756) 537 543 607 638 671 134 535 541 489 536 619 84 1.32% 1.31% 1.13% 1.12% 1.11%‐0.21% BENCHMARK 90 Day T‐Bill 0.09% 0.03% 0.05% 0.04% 0.06%‐0.03% 0.09% 0.05% 0.06%0.05% 0.19% 0.10% 0.10% 0.07% 0.07%0.09% 0.39% 0.29% 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 December 31, 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