Loading...
HomeMy WebLinkAbout05(B) - Approval of 2nd Quarter Investment Report ReportYTM @  Cost Cost Value Days to  Maturity % of  Portfolio 0‐1 Month 0.966      14,504,042        1                    31.55% 1‐3 Months 2.266      737,000             55                  1.61% 3‐6 Months 2.141      2,632,736          124                5.67% 6‐9 Months 2.875      490,000             212                1.07% 9‐12 Months 1.561      1,796,734          342                3.92% 1‐2 Years 2.157      7,086,242          529                15.26% 2‐3 Years 1.471      6,157,048          872                13.36% 3‐4 Years 0.895      4,951,816          1,212             10.42% 4‐5 Years 1.298      6,200,137          1,571             13.57% 5‐10 Years 2.877      1,488,185          1,913             3.57% Total / Average 1.452 46,043,940        629                100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio ‐ Diversification, by Maturity Range June 30, 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 363,856.88 363,856.88 363,856.88 363,856.88 N/A 1 0.79Morgan Stanley Cash CASH5089 12/31/2010 0.000 176,214.85 176,214.85 176,214.85 176,214.85 N/A 1 0.38Oppenheimer Cash MM9905 12/27/2011 0.000 5,751.34 5,751.34 5,751.34 5,751.34 N/A 1 0.01Sub Total / Average Cash0.000 545,823.07 545,823.07 545,823.07 545,823.07 1 0.00 1.19Allegiance Bank TX 2.2 11/3/2022 01748DAY2 11/3/2017 2.200 245,000.00 245,000.00 245,000.00 245,237.65 11/3/2022 126 398.71 0.53Alma Bank 1.8 9/11/2023 020080BM8 9/11/2019 1.800 245,000.00 245,000.00 245,000.00 241,685.15 9/11/2023 438 229.56 0.53American Express Natl 3 5/4/2027 02589ACK6 4/30/2022 3.000 245,000.00 245,000.00 245,000.00 240,278.85 5/4/2027 1,769 1,228.36 0.53Banc Calif Irvine 3.2 7/1/2024 05961SNS9 6/29/2022 3.200 245,000.00 245,000.00 245,000.00 244,524.70 7/1/2024 732 21.48 0.53Bank 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 246,700.30 11/30/2023 518 724.79 0.53Bank Hapoalim 0.95 7/23/2026 06251A2Y5 7/23/2021 0.950 245,000.00 245,000.00 245,000.00 222,807.90 7/23/2026 1,484 1,007.52 0.53Bank of New England 3.25 7/31/2023 06426KAN8 7/31/2018 3.250 245,000.00 245,000.00 245,000.00 245,911.40 7/31/2023 396 0.00 0.53Bankers 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 236,910.10 9/30/2024 823 0.00 0.53BankUnited Savings Miami 0.95 3/31/2026 066519QT9 3/31/2021 0.950 245,000.00 245,000.00 245,000.00 224,167.65 3/31/2026 1,370 0.00 0.53Barclays Bk Delaware 2.3 10/18/2022 06740KLD7 10/18/2017 2.300 245,000.00 245,000.00 245,000.00 245,318.50 10/18/2022 110 1,127.00 0.53Capital BK3.15 10/28/2022 139797HC1 10/29/2018 3.150 245,000.00 245,000.00 245,000.00 246,002.05 10/28/2022 120 21.14 0.53Capital One Bk USA Natl 1.8 3/17/2025 14042TEM5 3/16/2022 1.800 245,000.00 245,000.00 245,000.00 235,072.60 3/17/2025 991 1,280.71 0.53Capital 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 240,901.57 8/14/2024 776 1,932.69 0.54Celtic Bank 1.8 8/30/2023 15118RRF6 8/30/2019 1.800 245,000.00 245,000.00 245,000.00 241,800.30 8/30/2023 426 0.00 0.53CF Bank 3.15 9/18/2023 15721UCQ0 9/18/2018 3.150 245,000.00 245,000.00 245,000.00 245,553.70 9/18/2023 445 253.73 0.53Citibank Sioux Falls 3.15 7/25/2022 17312QP86 7/24/2018 3.150 245,000.00 245,000.00 245,000.00 245,245.00 7/25/2022 25 3,319.58 0.53City National Bank 3.05 8/8/2022 17801GBU2 8/6/2018 3.050 245,000.00 245,000.00 245,000.00 245,340.55 8/8/2022 39 491.34 0.53Discover Bank 1.9 5/11/2023 254672YR3 9/17/2019 2.001 245,000.00 244,135.15 244,795.47 243,471.20 5/11/2023 315 637.67 0.53Enerbank USA 0.55 9/25/2025 29278TRL6 9/25/2020 0.550 245,000.00 245,000.00 245,000.00 223,724.20 9/25/2025 1,183 18.46 0.53Enterprise Bank & Trust 1.8 11/8/2024 29367SJQ8 11/8/2019 1.800 245,000.00 245,000.00 245,000.00 236,486.25 11/8/2024 862 265.81 0.53Enterprise 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 236,973.80 9/27/2024 820 1,147.81 0.53Fifth 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 365 0.00 0.53First Commercial Bank MS 0.3 3/31/2025 31984GFK0 3/7/2022 1.700 225,000.00 215,588.25 216,554.64 206,835.75 3/31/2025 1,005 0.00 0.49First Natl Bank of Albany 1.6 2/28/2025 32117WAN2 2/28/2020 1.600 245,000.00 245,000.00 245,000.00 233,999.50 2/28/2025 974 21.48 0.53Firstbank Puerto Rico 1.8 9/6/2022 33767GAE8 9/6/2019 1.800 245,000.00 245,000.00 245,000.00 245,000.00 9/6/2022 68 289.97 0.53Flagstar Bank FSB 0.2 6/30/2023 33847E4Q7 6/30/2021 0.200 245,000.00 245,000.00 245,000.00 238,556.50 6/30/2023 365 0.00 0.53Goldman Sachs Bk 1 7/28/2026 38149MXK4 7/28/2021 1.000 245,000.00 245,000.00 245,000.00 222,548.20 7/28/2026 1,489 1,026.99 0.53Harden County 3.1 9/28/2023 412022CJ2 9/28/2018 3.100 245,000.00 245,000.00 245,000.00 245,382.20 9/28/2023 455 41.62 0.53Industrial & Coml NY 2.65 2/14/2023 45581EAR2 2/14/2018 2.650 245,000.00 245,000.00 245,000.00 245,580.65 2/14/2023 229 284.60 0.53Iowa State Clarksville 3.15 9/28/2023 46256YAY5 9/28/2018 3.150 245,000.00 245,000.00 245,000.00 245,521.85 9/28/2023 455 1,987.52 0.53Israel Discount Bk 0.75 7/14/2023 465076TA5 1/28/2022 0.750 249,000.00 249,000.00 249,000.00 243,591.72 7/14/2023 379 782.82 0.54Luana Savings Bank 0.2 5/7/2024 549104XH5 11/22/2021 0.699 240,000.00 237,081.60 237,797.37 226,941.60 5/7/2024 677 71.01 0.52Merrick Bank2.2 11/8/2022 59013JD71 11/8/2017 2.200 245,000.00 245,000.00 245,000.00 245,232.75 11/8/2022 131 324.88 0.53Morgan Stanley Bank Step 11/28/2027 61765QP52 9/2/2021 1.004 249,000.00 249,000.00 249,000.00 219,070.20 11/28/2027 1,977 225.12 0.54MS Private Bank 3.55 11/8/2023 61760ARS0 11/8/2018 3.550 245,000.00 245,000.00 245,000.00 246,482.25 11/8/2023 496 1,262.92 0.53National Cooperative Bank3.4 12/21/2023 635573AL2 12/24/2018 3.400 245,000.00 245,000.00 245,000.00 246,153.95 12/21/2023 539 205.40 0.53New York Community Bank 0.2 7/3/2023 649447VA4 6/30/2021 0.200 245,000.00 245,000.00 245,000.00 238,495.25 7/3/2023 368 0.00 0.53Oceanfirst Bk Natl 3.25 7/1/2024 67523TBE2 6/29/2022 3.250 245,000.00 245,000.00 245,000.00 244,762.35 7/1/2024 732 21.82 0.53Preferred Bank LA Calif 1.95 8/30/2024 740367HR1 8/30/2019 1.950 249,000.00 249,000.00 249,000.00 241,886.07 8/30/2024 792 0.00 0.54Sallie Mae Bank Utah 1.9 9/18/2024 7954504D4 9/18/2019 1.900 245,000.00 245,000.00 245,000.00 237,591.20 9/18/2024 811 1,326.36 0.53Spring Bank3.25 10/24/2023 849430AY9 10/24/2018 3.250 245,000.00 245,000.00 245,000.00 245,779.10 10/24/2023 481 130.89 0.53State Bk India New York 0.65 12/29/2023 856285A92 12/29/2021 0.650 245,000.00 245,000.00 245,000.00 236,300.05 12/29/2023 547 4.36 0.53Sterling 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 246,229.90 1/11/2023 195 3,537.40 0.53Synchrony Bank 0.9 8/6/2026 87165GD58 8/6/2021 0.900 248,000.00 248,000.00 248,000.00 226,126.40 8/6/2026 1,498 880.57 0.54Texas Exchange Bk 0.45 8/21/2024 88241TJE1 8/21/2020 0.450 245,000.00 245,000.00 245,000.00 230,513.15 8/21/2024 783 27.18 0.53TIAA FSB Jacksonville FLA 1.95 8/26/2022 87270LCR2 8/28/2019 1.950 247,000.00 247,000.00 247,000.00 247,056.81 8/26/2022 57 1,609.90 0.54Toyota Finl Svgs Bk 0.95 7/15/2026 89235MLC3 7/15/2021 0.950 245,000.00 245,000.00 245,000.00 222,942.65 7/15/2026 1,476 1,058.53 0.53UBS Bank USA 3.25 10/17/2022 90348JEG1 10/17/2018 3.250 245,000.00 245,000.00 245,000.00 246,006.95 10/17/2022 109 283.60 0.53Veritex Cmnty Bk 0.2 9/15/2023 923450CP3 9/15/2021 0.200 245,000.00 245,000.00 245,000.00 236,993.40 9/15/2023 442 20.14 0.53Washington Federal 1.95 8/28/2024 938828BN9 8/28/2019 1.950 245,000.00 245,000.00 245,000.00 238,029.75 8/28/2024 790 26.18 0.53Webbank 0.4 10/30/2023-22 947547NL5 11/8/2021 0.449 245,000.00 244,755.00 244,834.51 236,643.05 10/30/2023 487 2.68 0.53Wells 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,352.27 198,186.00 5/17/2024 687 195.890.44Wells Fargo Natl Bk West 1.8 12/13/2022 949495AA3 12/13/2019 1.800 245,000.00 245,000.00 245,000.00 244,730.50 12/13/2022 166 205.40 0.53Wex Bk Midvale 0.25 6/30/2023 92937CKM9 6/30/2021 0.250 232,000.00 232,000.00 232,000.00 226,012.08 6/30/2023 365 0.00 0.51Sub Total / Average Certificate Of Deposit1.966 13,163,000.00 13,150,484.00 13,152,334.26 12,831,295.20 633 29,961.59 28.70FFCB 0.69 7/22/2025-21 3133ELX33 4/15/2021 0.750 600,000.00 598,488.00 598,915.70 557,874.00 7/22/2025 1,118 1,817.00 1.31FFCB 0.72 10/27/2026-21 3133EMES7 6/18/2021 1.000 500,000.00 492,715.00 494,118.40 450,515.00 10/27/2026 1,580 630.00 1.09FFCB 0.74 11/24/2026-21 3133EMHC9 4/14/2021 1.053 450,000.00 442,350.00 443,999.41 409,635.00 11/24/2026 1,608 333.00 0.98FFCB 2.62 11/17/2025 3133EHJR5 9/24/2021 0.810 500,000.00 536,830.00 530,047.45 491,065.00 11/17/2025 1,236 1,564.72 1.09Sub Total / Average FFCB Bond0.892 2,050,000.00 2,070,383.00 2,067,080.96 1,909,089.00 1,367 4,344.72 4.47FHLB 1 12/30/2026-21 3130ANY87 10/20/2021 1.205 500,000.00 494,850.00 495,536.85 459,735.00 12/30/2026 1,644 0.00 1.09FHLB 1.25 11/10/2026-22 3130APLR4 11/10/2021 1.250 450,000.00 450,000.00 450,000.00 420,507.00 11/10/2026 1,594 781.25 0.98FHLB 5.375 9/30/2022 3133XMFY2 6/18/2021 0.115 450,000.00 480,343.50 455,952.24 453,825.00 9/30/2022 92 6,046.88 0.98FHLB Step 12/15/2025-21 3130AKJ72 4/13/2021 0.894 500,000.00 497,500.00 498,148.80 461,865.00 12/15/2025 1,264 72.92 1.09FHLN 5159508 1.25 10/16/2026-21 3130ALW83 4/16/2021 1.250 216,666.67 216,666.67 216,666.67 201,794.67 10/16/2026 1,569 556.71 0.47FHLN 5214149 Step 7/22/2026-21 3130AN4W7 7/22/2021 1.057 1,000,000.00 1,000,000.00 1,000,000.00 937,120.00 7/22/2026 1,483 2,194.44 2.18Sub Total / Average FHLB Bond0.960 3,116,666.67 3,139,360.17 3,116,304.56 2,934,846.67 1,295 9,652.20 6.80FHLMC 0.5 12/9/2024 3134GWA71 9/9/2020 0.500 200,000.00 200,000.00 200,000.00 188,372.00 12/9/2024 893 58.33 0.44Sub Total / Average FHLMC Bond0.500 200,000.00 200,000.00 200,000.00 188,372.00 893 58.33 0.444M ARPA Funds LGIP LGIP5401MARPA 8/2/2021 0.916 11.70 11.70 11.70 11.70 N/A 1 0.004MP ARPA Funds LMC LGIP LGIP5401MPARPA 9/1/2021 0.944 1,443,676.19 1,443,676.19 1,443,676.19 1,443,676.19 N/A 1 3.15League of Minnesota Cities - 4M Fund LGIP LGIP5101M 11/30/2010 0.916 3,241,752.63 3,241,752.63 3,241,752.63 3,241,752.63 N/A 1 7.07League 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.944 8,490,949.01 8,490,949.01 8,490,949.01 8,490,949.01 N/A 1 18.52League of Minnesota Cities LGIP LGIP5207MP 10/12/2021 0.944 44.10 44.10 44.10 44.10 N/A 1 0.00Local Government Investment PoolCity of Prior LakeInvestment Portfolio - by Security TypeAs of 6/30/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 LakeInvestment Portfolio - by Security TypeAs of 6/30/2022Sub Total / Average Local Government Investment Pool0.937 13,176,433.63 13,176,433.63 13,176,433.63 13,176,433.63 1 0.00 28.73Allen Park MI Public Sch Dist 2 11/2/2024 018033HR4 7/30/2020 0.751 290,000.00 305,140.90 298,329.44 281,529.10 11/2/2024 856 950.56 0.63Cabot-Las Positas 1.287 8/1/2027 15722TJS1 4/28/2022 3.500 550,000.00 491,991.50 493,893.91 485,639.00 8/1/2027 1,858 2,929.71 1.20Canadian 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 275,694.75 11/1/2024 855 934.17 0.62Cecil Cnty MD 1.05 11/1/2026 1498433N2 9/23/2021 0.970 500,000.00 501,985.00 501,686.98 451,920.00 11/1/2026 1,585 860.42 1.09Central Cmnty Sch 2 3/1/2026 153135FJ2 3/4/2021 0.700 300,000.00 319,098.00 314,038.03 286,374.00 3/1/2026 1,340 1,983.33 0.65Columbus Ohio2.333 12/1/2022 199492-CT-4 8/26/2019 1.750 100,000.00 101,840.00 100,237.52 99,852.00 12/1/2022 154 187.94 0.22Columbus Ohio City Sch Dist 2.036 12/1/2022 199507-6K-5 10/17/2019 1.901 135,000.00 135,552.15 135,074.52 134,774.55 12/1/2022 154 221.410.29Edgewood Ohio City 5 12/1/2023 280455ET9 12/19/2019 2.101 215,000.00 238,512.40 223,456.64 220,628.70 12/1/2023 519 865.97 0.47El Paso TX ISD 0 8/15/2024 283770NS0 10/30/2020 0.700 500,000.00 486,925.00 492,664.78 467,655.00 8/15/2024 777 0.00 1.09Enfield Conn Taxable 1.39 8/1/2027 292749UK2 4/6/2022 3.000 335,000.00 308,658.95 309,811.29 301,118.10 8/1/2027 1,858 1,927.27 0.73Falmouth ME Taxable 3 10/15/2025 306783NF4 10/15/2021 0.800 340,000.00 369,386.20 364,196.85 335,984.60 10/15/2025 1,203 2,125.00 0.74Federal Way Wash2.2 12/1/2024 314031-HH-1 12/11/2019 2.150 475,000.00 476,111.50 475,541.37 463,562.00 12/1/2024 885 841.81 1.04Hawaii St Taxable 1.033 8/1/2025 419792F92 10/12/2021 0.950 300,000.00 300,924.00 300,750.38 279,576.00 8/1/2025 1,128 1,282.64 0.65Hennepin Cnty 5 12/1/2025 425507BS8 12/4/2020 2.976 115,000.00 125,723.75 122,353.09 116,664.05 12/1/2025 1,250 463.19 0.25Indiana Bond Bank 3.326 7/15/2025 45462TER9 3/26/2021 0.900 240,000.00 264,516.00 257,326.51 239,040.00 7/15/2025 1,111 3,658.60 0.52Iowa Westn Comm2.8 6/1/2023 462612SE3 2/12/2018 2.800 195,000.00 195,000.00 195,000.00 194,485.20 6/1/2023 336 439.83 0.43Liberty Center Ohio 0 11/1/2025 530336DV5 8/18/2020 1.051 215,000.00 203,589.95 207,677.40 189,234.40 11/1/2025 1,220 0.00 0.47Mankato Minn ISD 0.7 2/1/2025 563690RP3 10/22/2020 0.700 300,000.00 300,000.00 300,000.00 279,756.00 2/1/2025 947 869.17 0.65Maricopa Cnty Ariz 5 7/1/2022 567389UY5 3/19/2020 1.700 500,000.00 536,785.00 500,044.11 500,000.00 7/1/2022 1 12,430.56 1.09Massachusetts St 0.986 11/1/2026 57582RK96 6/30/2021 1.000 500,000.00 499,635.00 499,703.32 451,210.00 11/1/2026 1,585 807.97 1.09Massachusetts St Dev 2.785 5/1/2024 57584FEM8 12/20/2019 1.920 240,000.00 248,647.20 243,640.07 237,626.40 5/1/2024 671 1,095.43 0.52Medallion 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 246,462.65 12/7/2022 160 532.19 0.53Milwaukee Cnty Wis 2 12/1/2026 6022453V2 11/23/2021 1.300 500,000.00 516,960.00 514,934.79 475,580.00 12/1/2026 1,615 805.56 1.09Monmouth OR Bds 2.9 4/1/2023 609694FZ2 1/30/2018 2.900 255,000.00 255,000.00 255,000.00 254,635.35 4/1/2023 275 1,828.21 0.56Monona Wis Ref 3 10/1/2022 610100XT1 9/18/2018 3.000 200,000.00 200,000.00 200,000.00 200,454.00 10/1/2022 93 1,483.33 0.44Northwest Local Sch District Hamilton & Butler 667712CF8 11/15/2019 2.069 360,000.00 376,408.80 365,765.85 359,942.40 12/1/2023 519 942.50 0.79Northwest Local Sch District Hamilton & Butler 667712CG6 11/15/2019 2.169 370,000.00 389,010.60 379,128.80 367,724.50 12/1/2024 885 968.68 0.81Oak Creek WIS 4 10/1/2023 671137-YP-6 11/27/2018 3.402 280,000.00 287,434.00 281,924.69 283,306.80 10/1/2023 458 2,768.89 0.61Oklahoma Cnty Okla Metro 2.65 6/1/2024 67869T-AD-7 7/15/2019 2.286 500,000.00 508,255.00 503,250.15 494,875.00 6/1/2024 702 1,067.36 1.09Oregon Edu Dists 0.312 6/30/2023 68587FAT1 12/17/2021 0.550 385,000.00 383,598.60 384,086.59 374,320.10 6/30/2023 365 0.00 0.84Orono ME Taxable 5 11/1/2025 687085DR8 10/29/2020 1.000 330,000.00 394,287.30 372,881.63 348,252.30 11/1/2025 1,220 2,704.17 0.72Pelican Rapids Minn 0.8 2/1/2025 705863HR2 12/17/2020 0.700 525,000.00 527,126.25 526,336.14 490,119.00 2/1/2025 947 1,738.33 1.14Pennsylvania St Univ 1.645 9/1/2025 709235S48 12/6/2021 1.120 250,000.00 254,787.50 254,064.99 237,100.00 9/1/2025 1,159 1,359.41 0.55Rhode IS Infrastructure Bk 2.18 10/1/2023 7622FDD7 6/27/2019 2.151 435,000.00 435,522.00 435,153.55 430,432.50 10/1/2023 458 2,344.41 0.95Richfield Minn ISD 3 2/1/2024 763342SZ6 9/4/2020 0.570 200,000.00 216,380.00 207,644.00 199,076.00 2/1/2024 581 2,483.33 0.44Roanoke VA Taxable 2 2/1/2025 770078BD4 5/14/2020 1.250 300,000.00 310,266.00 305,639.15 290,487.00 2/1/2025 947 2,483.33 0.65Trussville AL 0.822 10/1/2025 898242ND0 8/25/2020 0.710 300,000.00 301,677.00 301,070.29 275,778.00 10/1/2025 1,189 609.65 0.65Wauwatosa WI 3 12/1/2024-22 9435042U3 10/28/2021 2.014 200,000.00 205,880.00 204,605.13 198,550.00 12/1/2024 885 483.33 0.44Wicomico Cnty MD 2 12/1/2026 967546BA9 5/13/2022 3.450 380,000.00 356,975.80 357,640.36 354,357.60 12/1/2026 1,615 612.22 0.83Wisconsin St Gen Fund 2.877 5/1/2024 977100EA0 12/2/2021 0.700 160,000.00 168,321.60 166,338.02 158,843.20 5/1/2024 671 754.41 0.35Sub Total / Average Municipal Bond1.694 12,805,000.00 13,027,912.95 12,880,890.34 12,332,620.25 947 60,844.29 27.92T-Note 0.375 11/30/2025 91282CAZ4 9/24/2021 0.780 300,000.00 295,008.00 295,919.50 274,323.00 11/30/2025 1,249 92.21 0.65T-Note 0.625 11/30/2027 91282CAY7 5/5/2022 3.040 500,000.00 438,535.00 440,226.42 439,845.00 11/30/2027 1,979 256.15 1.09Sub Total / Average Treasury Note2.193 800,000.00 733,543.00 736,145.92 714,168.00 1,705 348.36 1.74Total / Average1.452 45,856,923.37 46,043,939.82 45,875,012.74 44,632,647.82 629 105,209.49 100Municipal BondTreasury Note YTM @  Cost Cost Value Days to  Maturity % of  Portfolio Cash ‐           545,823              1                    1.19% Certificate of Deposit 1.966       13,150,484        633               28.70% FFCB Bond 0.892       2,070,383           1,367            4.47% FHLB Bond 0.960       3,139,360           1,295            6.80% FHLMC Bond 0.500       200,000              893               0.44% LGIP 0.937       13,176,434        1                    28.74% Municipal Bond 1.694       13,027,913        947               27.92% Treasury Note 2.193       733,543              1,705            1.74% Total / Average 1.452 46,043,940 629               100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio ‐ Diversification, by Security Type June 30, 2022 Description City of Prior Lake ‐ Quarterly Investment Report Change from one 6/30/2021 9/30/2021 12/31/2021 3/31/2022 6/30/2022 year prior Market Value 14,932,703 14,412,610 13,628,317 11,451,561 13,722,257 (1,210,446) 111110 0.01% 0.02% 0.03% 0.07% 0.90%0.89% Fixed Income Assets 26,700,008 29,577,498 30,895,588 31,360,176 32,321,683 5,621,675 27,166,384 29,891,353 30,920,003 30,387,293 30,910,391 3,744,007 951 951 970 887 897 (54) 765 800 895 822 838 73 1.75% 1.66% 1.58% 1.57% 1.68%‐0.07% Total Portfolio Value 41,632,711 43,990,108 44,523,905 42,811,737 46,043,940 4,411,229 42,099,087 44,303,963 44,548,320 41,838,854 44,632,648 2,533,561 98,504 132,849 104,243 137,024 105,209 6,705 466,376 313,855 24,415 ‐972,783 ‐1,411,292 (1,877,668) 607 638 671 648 629 22 489 536 619 601 587 98 1.13% 1.12% 1.11% 1.17% 1.45% 0.32% BENCHMARK 90 Day T‐Bill 0.05% 0.04% 0.06% 0.52% 1.72% 1.67% 0.06% 0.05% 0.19%1.06% 2.51% 2.45% 0.07% 0.09% 0.39%1.63% 2.80% 2.73% 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 June 30, 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