Loading...
HomeMy WebLinkAbout05(C) - Approval of 4th Quarter 2022 Investment Report ReportYTM @  Cost Cost Value Days to  Maturity % of  Portfolio 0‐1 Month 3.468      14,558,568        1                    30.69% 1‐3 Months 2.650      245,000             45                  0.52% 3‐6 Months 2.555      694,135             122                1.47% 6‐9 Months 1.335      2,821,599          210                5.95% 9‐12 Months 2.687      3,535,632          310                7.35% 1‐2 Years 2.050      7,108,677          610                14.84% 2‐3 Years 1.193      6,594,974          942                13.60% 3‐4 Years 1.299      6,768,236          1,357             14.28% 4‐5 Years 3.493      5,184,631          1,682             11.30% Total / Average 2.439 47,511,452        640                100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio ‐ Diversification, by Maturity Range December 31, 2022 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 426,364.46 426,364.46 426,364.46 426,364.46 N/A 1 0.90Morgan Stanley Cash CASH5089 12/31/2010 0.000 7,403.57 7,403.57 7,403.57 7,403.57 N/A 1 0.02Oppenheimer Cash MM9905 12/27/2011 0.000 1,224,972.84 1,224,972.84 1,224,972.84 1,224,972.84 N/A 1 2.58Sub Total / Average Cash0.000 1,658,740.87 1,658,740.87 1,658,740.87 1,658,740.87 1 0.00 3.501st Security Bk of Wash 4.05 6/16/2026 33625CFL8 12/16/2022 4.050 249,000.00 249,000.00 249,000.00 244,776.96 6/16/2026 1,263 414.43 0.52Ally Bk Sandy UT 3.4 8/4/2025 02007GXF5 8/4/2022 3.400 245,000.00 245,000.00 245,000.00 237,951.35 8/4/2025 947 3,400.47 0.52Alma Bank 1.8 9/11/2023 020080BM8 9/11/2019 1.800 245,000.00 245,000.00 245,000.00 240,445.45 9/11/2023 254 241.64 0.52American Express Natl 3 5/4/2027 02589ACK6 4/30/2022 3.000 245,000.00 245,000.00 245,000.00 229,783.05 5/4/2027 1,585 1,147.81 0.52Banc Calif Irvine 3.2 7/1/2024 05961SNS9 6/29/2022 3.200 245,000.00 245,000.00 245,000.00 239,994.65 7/1/2024 548 42.96 0.52Bank 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 242,684.75 11/30/2023 334 724.79 0.52Bank Hapoalim 0.95 7/23/2026 06251A2Y5 7/23/2021 0.950 245,000.00 245,000.00 245,000.00 216,023.85 7/23/2026 1,300 1,026.65 0.52Bank of Belleville 4 6/15/2027 06063PDD4 12/15/2022 4.000 249,000.00 249,000.00 249,000.00 243,053.88 6/15/2027 1,627 436.60 0.52Bank of New England 3.25 7/31/2023 06426KAN8 7/31/2018 3.250 245,000.00 245,000.00 245,000.00 243,412.40 7/31/2023 212 0.00 0.52Bankers 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 233,433.55 9/30/2024 639 12.08 0.52BankUnited Savings Miami 0.95 3/31/2026 066519QT9 3/31/2021 0.950 245,000.00 245,000.00 245,000.00 218,179.85 3/31/2026 1,186 0.00 0.52CalPrivate Bk La Jolla 4 9/23/2027-23 13135NAS9 9/28/2022 4.400 249,000.00 244,545.39 244,775.34 242,757.57 9/23/2027 1,727 221.33 0.52Capital One Bk USA Natl 1.8 3/17/2025 14042TEM5 3/16/2022 1.800 245,000.00 245,000.00 245,000.00 230,736.10 3/17/2025 807 1,280.71 0.52Capital 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 237,364.53 8/14/2024 592 1,975.32 0.52Celtic Bank 1.8 8/30/2023 15118RRF6 8/30/2019 1.800 245,000.00 245,000.00 245,000.00 240,700.25 8/30/2023 242 0.00 0.52CF Bank 3.15 9/18/2023 15721UCQ0 9/18/2018 3.150 245,000.00 245,000.00 245,000.00 242,618.60 9/18/2023 261 274.87 0.52Charles Schwab Bank 4.7 11/21/2023 159877UAC2 11/21/2022 4.700 238,000.00 238,000.00 238,000.00 238,157.08 11/21/2023 325 1,225.86 0.50City Natl Bk Los Ang 4.9 11/24/2025 178180GS8 11/23/2022 4.900 245,000.00 245,000.00 245,000.00 247,114.35 11/24/2025 1,059 1,249.84 0.52Discover Bank 1.9 5/11/2023 254672YR3 9/17/2019 2.001 245,000.00 244,135.15 244,914.94 242,973.85 5/11/2023 131 637.67 0.52Enerbank USA 0.55 9/25/2025 29278TRL6 9/25/2020 0.550 245,000.00 245,000.00 245,000.00 219,620.45 9/25/2025 999 22.15 0.52Enterprise Bank & Trust 1.8 11/8/2024 29367SJQ8 11/8/2019 1.800 245,000.00 245,000.00 245,000.00 232,781.85 11/8/2024 678 277.89 0.52Enterprise 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 233,600.15 9/27/2024 636 1,147.81 0.52Fifth Third Bk2.95 6/30/2023 316777XV8 6/30/2022 2.950 242,000.00 242,000.00 242,000.00 242,000.00 6/30/2023 181 3,598.84 0.51First Commercial Bank MS 0.3 3/31/2025 31984GFK0 3/7/2022 1.700 225,000.00 215,588.25 218,100.85 204,338.25 3/31/2025 821 1.85 0.47First Finl Bk3.3 8/2/2027 32022RSG3 8/1/2022 3.300 245,000.00 245,000.00 245,000.00 231,892.50 8/2/2027 1,675 664.52 0.52First Natl Bank of Albany 1.6 2/28/2025 32117WAN2 2/28/2020 1.600 245,000.00 245,000.00 245,000.00 229,908.00 2/28/2025 790 32.22 0.52Flagstar Bank FSB 0.2 6/30/2023 33847E4Q7 6/30/2021 0.200 245,000.00 245,000.00 245,000.00 240,080.40 6/30/2023 181 1.34 0.52Goldman Sachs Bk 1 7/28/2026 38149MXK4 7/28/2021 1.000 245,000.00 245,000.00 245,000.00 215,776.40 7/28/2026 1,305 1,047.12 0.52Harden County 3.1 9/28/2023 412022CJ2 9/28/2018 3.100 245,000.00 245,000.00 245,000.00 242,390.75 9/28/2023 271 62.42 0.52Industrial & Coml NY 2.65 2/14/2023 45581EAR2 2/14/2018 2.650 245,000.00 245,000.00 245,000.00 244,578.60 2/14/2023 45 302.39 0.52Iowa State Clarksville 3.15 9/28/2023 46256YAY5 9/28/2018 3.150 245,000.00 245,000.00 245,000.00 242,503.45 9/28/2023 271 1,987.52 0.52Israel Discount Bk 0.75 7/14/2023 465076TA5 1/28/2022 0.750 249,000.00 249,000.00 249,000.00 244,266.51 7/14/2023 195 798.16 0.52Legacy Bk & Tr Co 3.5 7/29/2027-22 52470QBK9 8/1/2022 3.500 245,000.00 245,000.00 245,000.00 233,935.80 7/29/2027 1,671 46.99 0.52Live Oak Bkg Co 3.55 8/2/2027-23 538036WY6 8/2/2022 3.550 249,000.00 249,000.00 249,000.00 238,250.67 8/2/2027 1,675 702.32 0.52Luana Savings Bank 0.2 5/7/2024 549104XH5 11/22/2021 0.699 240,000.00 237,081.60 238,396.02 226,204.80 5/7/2024 493 71.01 0.51Manufacturers 4.9 12/9/2024 564759RJ9 12/7/2022 4.900 245,000.00 245,000.00 245,000.00 246,337.70 12/9/2024 709 789.37 0.52Morgan Stanley Bank Step 11/28/2027 61765QP52 9/2/2021 1.004 249,000.00 249,000.00 249,000.00 210,046.44 11/28/2027 1,793 225.12 0.52MS Private Bank 3.55 11/8/2023 61760ARS0 11/8/2018 3.550 245,000.00 245,000.00 245,000.00 242,728.85 11/8/2023 312 1,262.92 0.52National Cooperative Bank3.4 12/21/2023 635573AL2 12/24/2018 3.400 245,000.00 245,000.00 245,000.00 242,145.75 12/21/2023 355 228.22 0.52New York Community Bank 0.2 7/3/2023 649447VA4 6/30/2021 0.200 245,000.00 245,000.00 245,000.00 239,987.30 7/3/2023 184 1.34 0.52Oceanfirst Bk Natl 3.25 7/1/2024 67523TBE2 6/29/2022 3.250 245,000.00 245,000.00 245,000.00 240,171.05 7/1/2024 548 43.63 0.52Ponce De Leon Fed Bk 3.5 9/15/2027 732329BD8 9/15/2022 3.500 245,000.00 245,000.00 245,000.00 233,641.80 9/15/2027 1,719 375.89 0.52Preferred Bank LA Calif 1.95 8/30/2024 740367HR1 8/30/2019 1.950 249,000.00 249,000.00 249,000.00 238,370.19 8/30/2024 608 0.00 0.52Sallie Mae Bank Utah 1.9 9/18/2024 7954504D4 9/18/2019 1.900 245,000.00 245,000.00 245,000.00 234,153.85 9/18/2024 627 1,326.36 0.52Signature Bk New York 4.7 12/9/2024 82669GFM1 12/9/2022 4.700 240,000.00 240,000.00 240,000.00 240,424.80 12/9/2024 709 679.89 0.51Spring Bank3.25 10/24/2023 849430AY9 10/24/2018 3.250 245,000.00 245,000.00 245,000.00 242,393.20 10/24/2023 297 152.71 0.52State Bk India New York 0.65 12/29/2023 856285A92 12/29/2021 0.650 245,000.00 245,000.00 245,000.00 235,540.55 12/29/2023 363 8.73 0.52Sterling 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 244,921.60 1/11/2023 11 3,599.820.52Synchrony Bank 0.9 8/6/2026 87165GD58 8/6/2021 0.900 248,000.00 248,000.00 248,000.00 219,063.36 8/6/2026 1,314 898.92 0.52Texas Exchange Bk 0.45 8/21/2024 88241TJE1 8/21/2020 0.450 245,000.00 245,000.00 245,000.00 228,879.00 8/21/2024 599 30.21 0.52Third Fed Sav & Ln 3.3 8/19/2027 88413QDN5 8/19/2022 3.300 245,000.00 245,000.00 245,000.00 231,860.65 8/19/2027 1,692 2,968.19 0.52Toyota Finl Svgs Bk 0.95 7/15/2026 89235MLC3 7/15/2021 0.950 245,000.00 245,000.00 245,000.00 216,192.90 7/15/2026 1,292 1,077.66 0.52Transportation Alliance Bk 4.8 9/9/2024 89388CGG7 12/9/2022 4.800 240,000.00 240,000.00 240,000.00 240,736.80 9/9/2024 618 694.36 0.51Veritex Cmnty Bk 0.2 9/15/2023 923450CP3 9/15/2021 0.200 245,000.00 245,000.00 245,000.00 237,613.25 9/15/2023 258 21.48 0.52Washington Federal 1.95 8/28/2024 938828BN9 8/28/2019 1.950 245,000.00 245,000.00 245,000.00 234,572.80 8/28/2024 606 39.27 0.52Webbank 0.4 10/30/2023-22 947547NL5 11/8/2021 0.449 245,000.00 244,755.00 244,897.04 236,613.65 10/30/2023 303 5.37 0.52Wells 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,257.92 194,992.00 5/17/2024 503 210.960.42Wex Bk Midvale 0.25 6/30/2023 92937CKM9 6/30/2021 0.250 232,000.00 232,000.00 232,000.00 227,397.12 6/30/2023 181 1.59 0.49Winter Hill Bank 3.5 8/26/2027-23 975875BH7 8/26/2022 3.500 245,000.00 245,000.00 245,000.00 233,818.20 8/26/2027 1,699 117.47 0.52Sub Total / Average Certificate Of Deposit2.405 14,385,000.00 14,368,029.39 14,372,342.11 13,826,893.46 752 39,837.06 30.33FFCB 0.69 7/22/2025-21 3133ELX33 4/15/2021 0.750 600,000.00 598,488.00 599,094.16 542,682.00 7/22/2025 934 1,828.50 1.26FFCB 0.72 10/27/2026-21 3133EMES7 6/18/2021 1.000 500,000.00 492,715.00 494,803.34 436,530.00 10/27/2026 1,396 640.00 1.05FFCB 0.74 11/24/2026-21 3133EMHC9 4/14/2021 1.053 450,000.00 442,350.00 444,686.05 392,238.00 11/24/2026 1,424 342.25 0.95FFCB 2.62 11/17/2025 3133EHJR5 9/24/2021 0.810 500,000.00 536,830.00 525,574.36 477,280.00 11/17/2025 1,052 1,601.11 1.05Sub Total / Average FFCB Bond0.892 2,050,000.00 2,070,383.00 2,064,157.91 1,848,730.00 1,183 4,411.86 4.32FHLB 1 12/30/2026-21 3130ANY87 10/20/2021 1.205 500,000.00 494,850.00 496,036.37 438,290.00 12/30/2026 1,460 0.00 1.05FHLB 1.25 11/10/2026-22 3130APLR4 11/10/2021 1.250 450,000.00 450,000.00 450,000.00 399,834.00 11/10/2026 1,410 796.87 0.95FHLB Step 12/15/2025-21 3130AKJ72 4/13/2021 0.894 500,000.00 497,500.00 498,418.28 452,435.00 12/15/2025 1,080 100.00 1.05FHLN 5159508 1.25 10/16/2026-21 3130ALW83 4/16/2021 1.250 216,666.67 216,666.67 216,666.67 192,161.67 10/16/2026 1,385 564.24 0.46FHLN 5214149 Step 7/22/2026-21 3130AN4W7 7/22/2021 1.057 1,000,000.00 1,000,000.00 1,000,000.00 903,440.00 7/22/2026 1,299 5,300.00 2.11Sub Total / Average FHLB Bond1.103 2,666,666.67 2,659,016.67 2,661,121.32 2,386,160.67 1,314 6,761.11 5.62FHLMC 0.5 12/9/2024 3134GWA71 9/9/2020 0.500 200,000.00 200,000.00 200,000.00 184,556.00 12/9/2024 709 61.11 0.42Sub Total / Average FHLMC Bond0.500 200,000.00 200,000.00 200,000.00 184,556.00 709 61.11 0.42City of Prior LakePortfolio HoldingsInvestment Portfolio - by Security TypeAs of 12/31/2022CashCertificate 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/2022League of Minnesota Cities - 4M Fund LGIP LGIP5101M 11/30/2010 3.934 8,911,155.13 8,911,155.13 8,911,155.13 8,911,155.13 N/A 1 18.79League of Minnesota Cities - 4M Plus Fund LGIP LGIP5101MP 11/30/2010 3.918 3,743,671.66 3,743,671.66 3,743,671.66 3,743,671.66 N/A 1 7.89Sub Total / Average Local Government Investment Pool3.929 12,654,826.79 12,654,826.79 12,654,826.79 12,654,826.79 1 0.00 26.68Allen Park MI Public Sch Dist 2 11/2/2024 018033HR4 7/30/2020 0.751 290,000.00 305,140.90 296,539.00 276,575.90 11/2/2024 672 966.67 0.61Cabot-Las Positas 1.287 8/1/2027 15722TJS1 4/28/2022 3.500 550,000.00 491,991.50 499,450.17 468,891.50 8/1/2027 1,674 2,949.38 1.16Canadian 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 271,491.00 11/1/2024 671 950.00 0.60Cecil Cnty MD 1.05 11/1/2026 1498433N2 9/23/2021 0.970 500,000.00 501,985.00 501,491.14 436,230.00 11/1/2026 1,401 875.00 1.05Central Cmnty Sch 2 3/1/2026 153135FJ2 3/4/2021 0.700 300,000.00 319,098.00 312,110.42 276,087.00 3/1/2026 1,156 2,000.00 0.63Edgewood Ohio City 5 12/1/2023 280455ET9 12/19/2019 2.101 215,000.00 238,512.40 220,458.53 215,797.65 12/1/2023 335 895.83 0.45El Paso TX ISD 0 8/15/2024 283770NS0 10/30/2020 0.700 500,000.00 486,925.00 494,401.82 464,395.00 8/15/2024 593 0.00 1.05Enfield Conn Taxable 1.39 8/1/2027 292749UK2 4/6/2022 3.000 335,000.00 308,658.95 312,305.76 288,371.35 8/1/2027 1,674 1,940.21 0.71Falmouth ME Taxable 3 10/15/2025 306783NF4 10/15/2021 0.800 340,000.00 369,386.20 360,495.92 326,097.40 10/15/2025 1,019 2,153.33 0.72Federal Way Wash2.2 12/1/2024 314031-HH-1 12/11/2019 2.150 475,000.00 476,111.50 475,428.82 453,895.75 12/1/2024 701 870.83 1.00Goose Creek Tex 4.5 2/15/2027 382604Z25 11/3/2022 4.700 500,000.00 496,125.00 496,268.61 498,700.00 2/15/2027 1,507 8,500.00 1.05Hawaii St GO Ref 2.802 10/1/2027-26 419792KL9 7/28/2022 3.350 100,000.00 97,413.00 97,626.42 92,024.00 10/1/2027 1,735 700.50 0.21Hawaii St Taxable 1.033 8/1/2025 419792F92 10/12/2021 0.950 300,000.00 300,924.00 300,627.97 274,428.00 8/1/2025 944 1,291.25 0.63Indiana Bond Bank 3.326 7/15/2025 45462TER9 3/26/2021 0.900 240,000.00 264,516.00 254,456.95 231,489.60 7/15/2025 927 3,680.77 0.51Iowa Westn Comm2.8 6/1/2023 462612SE3 2/12/2018 2.800 195,000.00 195,000.00 195,000.00 193,635.00 6/1/2023 152 455.00 0.41Liberty Center Ohio 0 11/1/2025 530336DV5 8/18/2020 1.051 215,000.00 203,589.95 208,781.79 188,133.60 11/1/2025 1,036 0.00 0.45Mankato Minn ISD 0.7 2/1/2025 563690RP3 10/22/2020 0.700 300,000.00 300,000.00 300,000.00 276,219.00 2/1/2025 763 875.00 0.63Massachusetts St 0.986 11/1/2026 57582RK96 6/30/2021 1.000 500,000.00 499,635.00 499,737.76 433,200.00 11/1/2026 1,401 821.67 1.05Massachusetts St Dev 2.785 5/1/2024 57584FEM8 12/20/2019 1.920 240,000.00 248,647.20 242,641.90 234,410.40 5/1/2024 487 1,114.00 0.51Milwaukee Cnty Wis 2 12/1/2026 6022453V2 11/23/2021 1.300 500,000.00 516,960.00 513,233.24 456,575.00 12/1/2026 1,431 833.33 1.05Monmouth OR Bds 2.9 4/1/2023 609694FZ2 1/30/2018 2.900 255,000.00 255,000.00 255,000.00 253,951.95 4/1/2023 91 1,848.75 0.54Northwest Local Sch District Hamilton & Butler 667712CF8 11/15/2019 2.069 360,000.00 376,408.80 363,721.70 355,953.60 12/1/2023 335 975.00 0.76Northwest Local Sch District Hamilton & Butler 667712CG6 11/15/2019 2.169 370,000.00 389,010.60 377,230.84 360,376.30 12/1/2024 701 1,002.08 0.78Oak Creek WIS 4 10/1/2023 671137-YP-6 11/27/2018 3.402 280,000.00 287,434.00 281,151.45 278,927.60 10/1/2023 274 2,800.00 0.59Oklahoma Cnty Okla Metro 2.65 6/1/2024 67869T-AD-7 7/15/2019 2.286 500,000.00 508,255.00 502,398.26 486,830.00 6/1/2024 518 1,104.17 1.05Oregon Edu Dists 0.312 6/30/2023 68587FAT1 12/17/2021 0.550 385,000.00 383,598.60 384,547.05 377,573.35 6/30/2023 181 0.00 0.81Orono ME Taxable 5 11/1/2025 687085DR8 10/29/2020 1.000 330,000.00 394,287.30 366,414.24 331,861.20 11/1/2025 1,036 2,750.00 0.70Pelican Rapids Minn 0.8 2/1/2025 705863HR2 12/17/2020 0.700 525,000.00 527,126.25 526,076.53 485,751.00 2/1/2025 763 1,750.00 1.11Pennsylvania St Univ 1.645 9/1/2025 709235S48 12/6/2021 1.120 250,000.00 254,787.50 253,419.64 231,890.00 9/1/2025 975 1,370.83 0.53Rhode IS Infrastructure Bk 2.18 10/1/2023 7622FDD7 6/27/2019 2.151 435,000.00 435,522.00 435,091.86 426,365.25 10/1/2023 274 2,370.75 0.92Richfield Minn ISD 3 2/1/2024 763342SZ6 9/4/2020 0.570 200,000.00 216,380.00 205,223.18 196,686.00 2/1/2024 397 2,500.00 0.42Roanoke VA Taxable 2 2/1/2025 770078BD4 5/14/2020 1.250 300,000.00 310,266.00 304,543.48 284,403.00 2/1/2025 763 2,500.00 0.63Springboro Ohio 5 12/1/2027 85023MAF2 7/12/2022 4.002 245,000.00 256,755.10 255,727.72 246,800.75 12/1/2027 1,796 1,020.83 0.52St Louis Park Minn 4.5 2/1/2027 791740V34 9/7/2022 3.345 190,000.00 198,863.50 198,229.61 189,473.70 2/1/2027 1,493 2,707.50 0.40Toledo Ohio City Sch 5 12/1/2027 889294RT3 9/28/2022 4.520 100,000.00 102,186.00 102,077.28 100,118.00 12/1/2027 1,796 416.67 0.21Trussville AL 0.822 10/1/2025 898242ND0 8/25/2020 0.710 300,000.00 301,677.00 300,904.66 270,546.00 10/1/2025 1,005 616.50 0.63Waukesha Wis 1.2 10/1/2027 943080UZ2 9/1/2022 3.660 375,000.00 332,557.50 335,324.49 318,022.50 10/1/2027 1,735 1,125.00 0.79Wauwatosa WI 3 12/1/2024-22 9435042U3 10/28/2021 2.014 200,000.00 205,880.00 203,647.68 194,364.00 12/1/2024 701 500.00 0.42Wicomico Cnty MD 2 12/1/2026 967546BA9 5/13/2022 3.450 380,000.00 356,975.80 360,187.84 345,157.80 12/1/2026 1,431 633.33 0.80Wisconsin St Gen Fund 2.877 5/1/2024 977100EA0 12/2/2021 0.700 160,000.00 168,321.60 164,600.02 156,243.20 5/1/2024 487 767.20 0.34Sub Total / Average Municipal Bond1.902 13,020,000.00 13,166,912.15 13,041,573.75 12,247,942.35 941 60,631.38 27.45T-Note 0.375 11/30/2025 91282CAZ4 9/24/2021 0.780 300,000.00 295,008.00 296,520.63 268,605.00 11/30/2025 1,065 95.81 0.63T-Note 0.625 11/30/2027 91282CAY7 5/5/2022 3.040 500,000.00 438,535.00 445,783.94 425,350.00 11/30/2027 1,795 266.14 1.05Sub Total / Average Treasury Note2.193 800,000.00 733,543.00 742,304.57 693,955.00 1,521 361.95 1.69Total / Average2.439 47,435,234.33 47,511,451.87 47,395,067.32 45,501,805.14 640 112,064.47 100Local Government Investment PoolMunicipal BondTreasury Note YTM @  Cost Cost Value Days to  Maturity % of  Portfolio Cash ‐           1,658,741           1                    3.50% Certificate of Deposit 2.405       14,368,029        752               30.33% FFCB Bond 0.892       2,070,383           1,183            4.32% FHLB Bond 1.103       2,659,017           1,314            5.62% FHLMC Bond 0.500       200,000              709               0.41% LGIP 3.929       12,654,827        1                    26.68% Municipal Bond 1.902       13,166,912        941               27.45% Treasury Note 2.193       733,543              1,521            1.69% Total / Average 2.439 47,511,452 640               100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio ‐ Diversification, by Security Type December 31, 2022 Description City of Prior Lake ‐ Quarterly Investment Report Change from one 12/31/2021 3/31/2022 6/30/2022 9/30/2022 12/31/2022 year prior Market Value 13,628,317 11,451,561 13,722,257 13,941,365 14,313,568 685,251 111110 0.03% 0.07% 0.90% 2.05% 3.47%3.45% Fixed Income Assets 30,895,588 31,360,176 32,321,683 33,273,875 33,197,884 2,302,296 30,920,003 30,387,293 30,910,391 31,173,111 31,188,237 268,234 970 887 897 938 917 (53) 895 822 838 831 849 (46) 1.58% 1.57% 1.68% 1.85% 1.98%0.39% Total Portfolio Value 44,523,905 42,811,737 46,043,940 47,215,240 47,511,452 2,987,547 44,548,320 41,838,854 44,632,648 45,114,476 45,501,805 953,485 104,243 137,024 105,209 145,337 112,064 7,821 24,415 ‐972,783 ‐1,411,292 ‐2,100,764 ‐2,009,647 (2,034,062) 671 648 629 661 640 (31) 619 601 587 586 593 (26) 1.11% 1.17% 1.45% 1.91% 2.43% 1.32% BENCHMARK 90 Day T‐Bill 0.06% 0.52% 1.72% 3.33% 4.42% 4.36% 0.19% 1.06% 2.51%3.92% 4.69% 4.50% 0.39% 1.63% 2.80%4.05% 4.76% 4.37% 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, 2022 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