Loading...
HomeMy WebLinkAbout05(D) - Approval of 2nd Quarter 2024 Investment Report ReportYTM @ Cost Cost Value Days to Maturity % of Portfolio 0-1 Month 3.968 16,072,477 1 29.67% 1-3 Months 1.805 2,202,925 61 4.09% 3-6 Months 2.263 2,836,143 142 5.16% 6-9 Months 1.106 1,627,392 227 2.98% 9-12 Months 1.700 215,588 274 0.42% 1-2 Years 2.598 9,758,743 536 17.81% 2-3 Years 1.763 7,393,126 862 13.68% 3-4 Years 3.794 6,220,642 1,241 11.82% 4-5 Years 4.586 6,604,078 1,606 12.45% 5-10 Years 4.849 951,516 1,909 1.92% Total / Average 3.224 53,882,630 615 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio - Diversification, by Maturity Range June 30, 2024 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 Maturity Accrued Interest % of Portfolio Cash - Northland Securities Cash CASH5845 2/3/2002 0.000 1,161,642.01 1,161,642.01 1,161,642.01 1,161,642.01 N/A 1 2.14 Morgan Stanley Cash CASH5089 12/31/2010 0.000 131,730.39 131,730.39 131,730.39 131,730.39 N/A 1 0.24 Oppenheimer Cash MM9905 12/27/2011 0.000 2,460,921.60 2,460,921.60 2,460,921.60 2,460,921.60 N/A 1 4.54 Sub Total / Average Cash 0.000 3,754,294.00 3,754,294.00 3,754,294.00 3,754,294.00 1 0.00 6.93 1st Security Bk of Wash 4.05 6/16/2026 33625CFL8 12/16/2022 4.050 249,000.00 249,000.00 249,000.00 245,105.64 6/16/2026 716 386.80 0.46 Ally Bk Sandy UT 3.4 8/4/2025 02007GXF5 8/4/2022 3.400 245,000.00 245,000.00 245,000.00 240,362.15 8/4/2025 400 3,354.82 0.45 Amerant Bank 4.65 9/8/2028 02357QCF2 9/8/2023 4.650 249,000.00 249,000.00 249,000.00 249,251.49 9/8/2028 1,531 697.88 0.46 AMERASIA BK FLUSHING NY 4 2/15/2029 02357PAG4 2/15/2024 4.000 248,000.00 248,000.00 248,000.00 242,159.60 2/15/2029 1,691 407.67 0.46 American Express Natl 3 5/4/2027 02589ACK6 4/30/2022 3.000 245,000.00 245,000.00 245,000.00 232,762.25 5/4/2027 1,038 1,147.81 0.45 Banc Calif Irvine 3.2 7/1/2024 05961SNS9 6/29/2022 3.200 245,000.00 245,000.00 245,000.00 244,955.90 7/1/2024 1 21.48 0.45 Bank Hapoalim 0.95 7/23/2026 06251A2Y5 7/23/2021 0.950 245,000.00 245,000.00 245,000.00 226,269.75 7/23/2026 753 1,013.90 0.45 Bank of Belleville 4 6/15/2027 06063PDD4 12/15/2022 4.000 249,000.00 249,000.00 249,000.00 242,966.73 6/15/2027 1,080 409.32 0.46 Bankers 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 242,755.80 9/30/2024 92 0.00 0.45 BankUnited Savings Miami 0.95 3/31/2026 066519QT9 3/31/2021 0.950 245,000.00 245,000.00 245,000.00 228,538.45 3/31/2026 639 0.00 0.45 BMW Bk 4.75 3/17/2028 055180AW83 3/17/2023 4.750 245,000.00 245,000.00 245,000.00 245,149.45 3/17/2028 1,356 3,347.77 0.45 BNY Mellon4.5 9/7/2028 05584CJJ6 9/7/2023 4.500 244,000.00 244,000.00 244,000.00 242,723.88 9/7/2028 1,530 3,459.45 0.45 Bridgewater Bk 4.8 3/29/2028 108622NK3 3/29/2023 4.800 245,000.00 245,000.00 245,000.00 245,752.15 3/29/2028 1,368 32.22 0.45 CalPrivate Bk La Jolla 4 9/23/2027-23 13135NAS9 9/28/2022 4.400 249,000.00 244,545.39 246,113.43 242,854.68 9/23/2027 1,180 193.67 0.46 Capital One Bk USA Natl 1.8 3/17/2025 14042TEM5 3/16/2022 1.800 245,000.00 245,000.00 245,000.00 239,004.85 3/17/2025 260 1,280.71 0.45 Capital 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 245,930.49 8/14/2024 45 1,946.90 0.46 Celtic Bank 4.6 9/19/2028 15118RJ32 9/19/2023 4.600 249,000.00 249,000.00 249,000.00 248,815.74 9/19/2028 1,542 345.19 0.46 Central Fed Savings 4.5 9/14/2028 15347VAC5 9/14/2023 4.500 249,000.00 249,000.00 249,000.00 247,847.13 9/14/2028 1,537 491.18 0.46 CIBC Bank USA 4.5 5/25/2028 12547CBN7 5/25/2023 4.500 244,000.00 244,000.00 244,000.00 242,394.48 5/25/2028 1,425 1,082.96 0.45 Citizens Bk Batesville Ark 3.85 2/16/2029 173477BZ2 2/16/2024 3.850 248,000.00 248,000.00 248,000.00 240,609.60 2/16/2029 1,692 366.22 0.46 City Natl Bk Los Ang 4.9 11/24/2025 178180GS8 11/23/2022 4.900 245,000.00 245,000.00 245,000.00 244,426.70 11/24/2025 512 1,249.84 0.45 Customers Bk 4.95 10/27/2028 23204HPE2 10/27/2023 4.950 240,000.00 240,000.00 240,000.00 243,103.20 10/27/2028 1,580 2,083.07 0.44 Discover Bk 4.5 7/24/2028 2546736R2 7/26/2023 4.500 244,000.00 244,000.00 244,000.00 242,726.32 7/24/2028 1,485 4,692.82 0.45 Enerbank USA 0.55 9/25/2025 29278TRL6 9/25/2020 0.550 245,000.00 245,000.00 245,000.00 231,556.85 9/25/2025 452 18.46 0.45 Enterprise Bank & Trust 1.8 11/8/2024 29367SJQ8 11/8/2019 1.800 245,000.00 245,000.00 245,000.00 241,873.80 11/8/2024 131 265.81 0.45 Enterprise 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 242,758.25 9/27/2024 89 1,147.81 0.45 Farmers BK 4.85 10/17/2028 30916PAA2 10/17/2023 4.850 248,000.00 248,000.00 248,000.00 251,221.52 10/17/2028 1,570 428.39 0.46 First Bank of the Lake 4.9 4/25/2028-24 31925YAE2 4/25/2023 4.900 248,000.00 248,000.00 248,000.00 248,039.68 4/25/2028 1,395 166.47 0.46 First Commercial Bank MS 0.3 3/31/2025 31984GFK0 3/7/2022 1.700 225,000.00 215,588.25 222,697.48 216,742.50 3/31/2025 274 0.00 0.42 First Finl Bk3.3 8/2/2027 32022RSG3 8/1/2022 3.300 245,000.00 245,000.00 245,000.00 234,075.45 8/2/2027 1,128 642.37 0.45 First National Bank/Dama 5 10/31/2028 32117BGJ1 10/31/2023 5.000 248,000.00 248,000.00 248,000.00 251,881.20 10/31/2028 1,584 985.21 0.46 First Natl Bank of Albany 1.6 2/28/2025 32117WAN2 2/28/2020 1.600 245,000.00 245,000.00 245,000.00 239,110.20 2/28/2025 243 21.48 0.45 First Natl Bk 4.75 10/30/2028 32110YH73 10/30/2023 4.750 245,000.00 245,000.00 245,000.00 246,367.10 10/30/2028 1,583 0.00 0.45 First Utd Bk4.4 8/8/2025 33742CCR6 2/8/2023 4.400 245,000.00 245,000.00 245,000.00 242,983.65 8/8/2025 404 649.75 0.45 Genoa Banking Company 4.95 10/31/2028 372348DH2 10/31/2023 4.950 243,000.00 243,000.00 243,000.00 246,129.84 10/31/2028 1,584 2,010.24 0.45 Goldman Sachs Bk 1 7/28/2026 38149MXK4 7/28/2021 1.000 245,000.00 245,000.00 245,000.00 226,056.60 7/28/2026 758 1,033.70 0.45 Legacy Bk & Tr Co 3.5 7/29/2027-22 52470QBK9 8/1/2022 3.500 245,000.00 245,000.00 245,000.00 235,442.55 7/29/2027 1,124 23.49 0.45 Live Oak Bkg Co 3.55 8/2/2027-23 538036WY6 8/2/2022 3.550 249,000.00 249,000.00 249,000.00 239,682.42 8/2/2027 1,128 678.10 0.46 Manufacturers 4.9 12/9/2024 564759RJ9 12/7/2022 4.900 245,000.00 245,000.00 245,000.00 244,490.40 12/9/2024 162 756.48 0.45 Mauch Chunk Trust 4.35 2/28/2029 577234DA2 3/28/2024 4.350 249,000.00 249,000.00 249,000.00 246,801.33 2/28/2029 1,704 59.35 0.46 Medallion Bk Salt 4.4 7/31/2028 58404DSW2 7/31/2023 4.400 245,000.00 245,000.00 245,000.00 242,836.65 7/31/2028 1,492 0.00 0.45 Merrick Bk 4.85 11/6/2029 59013KXW1 11/6/2023 4.850 245,000.00 245,000.00 245,000.00 248,819.55 11/6/2029 1,955 781.32 0.45 Morgan Stanley Bank Step 11/28/2027 61765QP52 9/2/2021 1.004 249,000.00 249,000.00 249,000.00 219,757.44 11/28/2027 1,246 225.12 0.46 MORGAN STANLEY PRIVATE BK 5.05 11/8/2028 61768EE82 11/8/2023 5.050 243,000.00 243,000.00 243,000.00 247,123.71 11/8/2028 1,592 1,781.89 0.45 Oceanfirst Bk Natl 3.25 7/1/2024 67523TBE2 6/29/2022 3.250 245,000.00 245,000.00 245,000.00 244,958.35 7/1/2024 1 21.82 0.45 Old Dominion Natl Bk 4 1/29/2029 679585CL1 1/29/2024 4.000 249,000.00 249,000.00 249,000.00 243,096.21 1/29/2029 1,674 0.00 0.46 Ponce De Leon Fed Bk 3.5 9/15/2027 732329BD8 9/15/2022 3.500 245,000.00 245,000.00 245,000.00 235,315.15 9/15/2027 1,172 352.40 0.45 Preferred Bank LA Calif 1.95 8/30/2024 740367HR1 8/30/2019 1.950 249,000.00 249,000.00 249,000.00 247,525.92 8/30/2024 61 0.00 0.46 Sallie Mae Bank Utah 1.9 9/18/2024 7954504D4 9/18/2019 1.900 245,000.00 245,000.00 245,000.00 243,027.75 9/18/2024 80 1,326.36 0.45 Savibank 4.05 1/19/2027 80517LAC5 1/18/2023 4.050 249,000.00 249,000.00 249,000.00 244,077.27 1/19/2027 933 331.55 0.46 Schuyler Svgs Bk 4.35 7/27/2028 80832MAA5 7/27/2023 4.350 244,000.00 244,000.00 244,000.00 241,337.96 7/27/2028 1,488 4,507.32 0.45 Signature Bk New York 4.7 12/9/2024 82669GFM1 12/9/2022 4.700 240,000.00 240,000.00 240,000.00 239,198.40 12/9/2024 162 648.99 0.44 Southern First Bank NA 4.85 10/17/2028 84287PJB9 11/7/2023 4.850 244,000.00 244,000.00 244,000.00 246,913.36 10/17/2028 1,570 2,399.22 0.45 Synchrony Bank 0.9 8/6/2026 87165GD58 8/6/2021 0.900 248,000.00 248,000.00 248,000.00 229,134.64 8/6/2026 767 886.68 0.46 Texas Exchange Bk 0.45 8/21/2024 88241TJE1 8/21/2020 0.450 245,000.00 245,000.00 245,000.00 243,236.00 8/21/2024 52 27.18 0.45 Third Fed Sav & Ln 3.3 8/19/2027 88413QDN5 8/19/2022 3.300 245,000.00 245,000.00 245,000.00 234,011.75 8/19/2027 1,145 2,923.89 0.45 Toyota Finl Svgs Bk 0.95 7/15/2026 89235MLC3 7/15/2021 0.950 245,000.00 245,000.00 245,000.00 226,463.30 7/15/2026 745 1,064.91 0.45 Transportation Alliance Bk 4.8 9/9/2024 89388CGG7 12/9/2022 4.800 240,000.00 240,000.00 240,000.00 239,724.00 9/9/2024 71 662.79 0.44 UBS Bk USA 4.4 7/26/2028 90355GEX0 7/26/2023 4.400 245,000.00 245,000.00 245,000.00 242,824.40 7/26/2028 1,487 118.14 0.45 Uinta Bk Mtn 4.4 3/22/2028 903572FT7 3/22/2023 4.400 245,000.00 245,000.00 245,000.00 242,395.65 3/22/2028 1,361 236.27 0.45 Univest Bank & Trust 4.5 6/21/2028 91527PCD7 6/21/2023 4.500 249,000.00 249,000.00 249,000.00 247,610.58 6/21/2028 1,452 276.29 0.46 Valley Central 4 4/28/2028 91944RAZ1 4/28/2023 4.000 249,000.00 249,000.00 249,000.00 243,001.59 4/28/2028 1,398 54.58 0.46 Washington Federal 1.95 8/28/2024 938828BN9 8/28/2019 1.950 245,000.00 245,000.00 245,000.00 243,610.85 8/28/2024 59 26.18 0.45 Winter Hill Bank 3.5 8/26/2027-23 975875BH7 8/26/2022 3.500 245,000.00 245,000.00 245,000.00 235,373.95 8/26/2027 1,152 93.97 0.45 Sub Total / Average Certificate Of Deposit 3.471 15,712,000.00 15,698,133.64 15,706,810.91 15,423,054.20 969 55,645.66 29.00 FAMC 4.17 5/24/2029 31422XYY2 1/19/2024 4.580 325,000.00 318,724.25 319,248.30 317,648.50 5/24/2029 1,789 1,355.25 0.60 Sub Total / Average FAMC Bond 4.580 325,000.00 318,724.25 319,248.30 317,648.50 1,789 1,355.25 0.60 Federal Farm Cr Bks 4.86 12/22/2027-25 3133EPN92 12/22/2023 4.860 500,000.00 500,000.00 500,000.00 496,520.00 12/22/2027 1,270 532.60 0.92 City of Prior Lake Portfolio Holdings Investment Portfolio - by Security Type As of 6/30/2024 Cash Certificate Of Deposit FAMC Bond FFCB Bond FFCB 0.69 7/22/2025-21 3133ELX33 4/15/2021 0.750 600,000.00 598,488.00 599,624.67 570,888.00 7/22/2025 387 1,817.00 1.11 FFCB 0.72 10/27/2026-21 3133EMES7 6/18/2021 1.000 500,000.00 492,715.00 496,839.57 455,855.00 10/27/2026 849 630.00 0.92 FFCB 0.74 11/24/2026-21 3133EMHC9 4/14/2021 1.053 450,000.00 442,350.00 446,727.29 408,375.00 11/24/2026 877 333.00 0.83 FFCB 2.62 11/17/2025 3133EHJR5 9/24/2021 0.810 500,000.00 536,830.00 512,276.67 484,060.00 11/17/2025 505 1,564.72 0.92 FFCB 3.05 5/18/2029 3133ENXB1 1/19/2024 4.030 325,000.00 309,845.25 311,114.64 306,176.00 5/18/2029 1,783 1,156.46 0.60 FFCB 4.5 12/22/2025 3133EPQ81 12/29/2023 4.210 1,000,000.00 1,005,440.00 1,004,057.46 992,800.00 12/22/2025 540 1,000.00 1.85 Sub Total / Average FFCB Bond 2.524 3,875,000.00 3,885,668.25 3,870,640.30 3,714,674.00 789 7,033.78 7.15 FHLB 1 12/30/2026-21 3130ANY87 10/20/2021 1.205 500,000.00 494,850.00 497,521.38 455,115.00 12/30/2026 913 0.00 0.92 FHLB 1.25 11/10/2026-22 3130APLR4 11/10/2021 1.250 450,000.00 450,000.00 450,000.00 414,360.00 11/10/2026 863 781.25 0.83 FHLB 2.375 8/15/2029 3130AGVG7 2/12/2024 4.310 270,000.00 244,620.00 246,374.26 243,637.20 8/15/2029 1,872 2,404.69 0.50 FHLB 3 4/20/2026 3130ARGN5 12/29/2023 4.350 1,000,000.00 970,620.00 977,032.72 968,080.00 4/20/2026 659 5,833.33 1.85 FHLB Step 12/15/2025-21 3130AKJ72 4/13/2021 0.894 500,000.00 497,500.00 499,219.39 476,045.00 12/15/2025 533 234.38 0.92 FHLN 5159508 1.25 10/16/2026-21 3130ALW83 4/16/2021 1.250 216,666.67 216,666.67 216,666.67 199,775.34 10/16/2026 838 556.71 0.40 FHLN 5214149 Step 7/22/2026-21 3130AN4W7 7/22/2021 1.057 1,000,000.00 1,000,000.00 1,000,000.00 929,310.00 7/22/2026 752 5,266.67 1.85 Sub Total / Average FHLB Bond 2.147 3,936,666.67 3,874,256.67 3,886,814.42 3,686,322.54 815 15,077.03 7.27 FHLMC 0.5 12/9/2024 3134GWA71 9/9/2020 0.500 200,000.00 200,000.00 200,000.00 195,424.00 12/9/2024 162 58.33 0.37 Sub Total / Average FHLMC Bond 0.500 200,000.00 200,000.00 200,000.00 195,424.00 162 58.33 0.37 League of Minnesota Cities - 4M Fund LGIP LGIP5101M 11/30/2010 5.234 158,325.21 158,325.21 158,325.21 158,325.21 N/A 1 0.29 League of Minnesota Cities - 4M Plus Fund LGIP LGIP5101MP 11/30/2010 5.259 11,669,857.53 11,669,857.53 11,669,857.53 11,669,857.53 N/A 1 21.54 Sub Total / Average Local Government Investment Pool 5.259 11,828,182.74 11,828,182.74 11,828,182.74 11,828,182.74 1 0.00 21.83 Allen Park MI Public Sch Dist 2 11/2/2024 018033HR4 7/30/2020 0.751 290,000.00 305,140.90 291,216.33 286,818.70 11/2/2024 125 950.56 0.54 Cabot-Las Positas 1.287 8/1/2027 15722TJS1 4/28/2022 3.500 550,000.00 491,991.50 515,967.94 494,560.00 8/1/2027 1,127 2,929.71 1.02 Canadian 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 281,805.15 11/1/2024 124 934.17 0.53 Cecil Cnty MD 1.05 11/1/2026 1498433N2 9/23/2021 0.970 500,000.00 501,985.00 500,908.95 458,410.00 11/1/2026 854 860.42 0.92 Central Cmnty Sch 2 3/1/2026 153135FJ2 3/4/2021 0.700 300,000.00 319,098.00 306,379.97 285,420.00 3/1/2026 609 1,983.33 0.55 El Paso TX ISD 0 8/15/2024 283770NS0 10/30/2020 0.700 500,000.00 486,925.00 499,565.74 496,705.00 8/15/2024 46 0.00 0.92 Enfield Conn Taxable 1.39 8/1/2027 292749UK2 4/6/2022 3.000 335,000.00 308,658.95 319,721.38 302,742.85 8/1/2027 1,127 1,927.27 0.62 Falmouth ME Taxable 3 10/15/2025 306783NF4 10/15/2021 0.800 340,000.00 369,386.20 349,493.69 330,820.00 10/15/2025 472 2,125.00 0.63 Federal Way Wash2.2 12/1/2024 314031-HH-1 12/11/2019 2.150 475,000.00 476,111.50 475,094.21 468,630.25 12/1/2024 154 841.81 0.88 Franklin Twp 1.623 2/1/2029 355064KL9 10/4/2023 5.350 250,000.00 207,310.00 213,230.03 218,527.50 2/1/2029 1,677 1,679.35 0.46 Goose Creek Tex 4.5 2/15/2027 382604Z25 11/3/2022 4.700 500,000.00 496,125.00 497,623.00 496,705.00 2/15/2027 960 8,437.50 0.92 Hawaii St GO Ref 2.802 10/1/2027-26 419792KL9 7/28/2022 3.350 100,000.00 97,413.00 98,374.75 94,233.00 10/1/2027 1,188 692.72 0.18 Hawaii St Taxable 1.033 8/1/2025 419792F92 10/12/2021 0.950 300,000.00 300,924.00 300,264.10 286,836.00 8/1/2025 397 1,282.64 0.55 Indiana Bond Bank 3.326 7/15/2025 45462TER9 3/26/2021 0.900 240,000.00 264,516.00 245,926.26 235,351.20 7/15/2025 380 3,658.60 0.44 Liberty Center Ohio 0 11/1/2025 530336DV5 8/18/2020 1.051 215,000.00 203,589.95 212,064.96 200,762.70 11/1/2025 489 0.00 0.40 Mankato Minn ISD 0.7 2/1/2025 563690RP3 10/22/2020 0.700 300,000.00 300,000.00 300,000.00 292,203.00 2/1/2025 216 869.17 0.55 Mason & Kitsap Cntys 1.583 12/1/2028 575181HB1 5/19/2023 4.150 445,000.00 389,032.35 400,319.94 389,152.50 12/1/2028 1,615 567.46 0.82 Massachusetts St 0.986 11/1/2026 57582RK96 6/30/2021 1.000 500,000.00 499,635.00 499,840.15 457,505.00 11/1/2026 854 807.97 0.92 Milwaukee Cnty Wis 2 12/1/2026 6022453V2 11/23/2021 1.300 500,000.00 516,960.00 508,174.83 467,335.00 12/1/2026 884 805.56 0.92 Minnesota St 7 11/1/2028 604146GK0 11/8/2023 5.251 250,000.00 268,952.50 266,505.34 273,517.50 11/1/2028 1,585 2,868.06 0.46 New York NY 1.92 11/1/2029 64971XUUO 9/25/2023 5.150 275,000.00 228,998.00 234,755.99 237,561.50 11/1/2029 1,950 865.33 0.51 New York NY 3.7 8/1/2029-25 64966LYZ8 11/24/2023 5.100 250,000.00 232,897.50 234,700.80 237,435.00 8/1/2029 1,858 3,828.47 0.46 New York State TFA 4.2 11/1/2028-23 64971Q7N7 9/7/2023 4.850 250,000.00 242,657.50 243,816.23 243,815.00 11/1/2028 1,585 1,720.83 0.46 Northwest Local Sch District Hamilton & Butler 667712CG6 11/15/2019 2.169 370,000.00 389,010.60 371,588.51 366,914.20 12/1/2024 154 968.68 0.68 Orono ME Taxable 5 11/1/2025 687085DR8 10/29/2020 1.000 330,000.00 394,287.30 347,187.80 329,019.90 11/1/2025 489 2,704.17 0.61 Pelican Rapids Minn 0.8 2/1/2025 705863HR2 12/17/2020 0.700 525,000.00 527,126.25 525,304.76 511,822.50 2/1/2025 216 1,738.33 0.97 Pennsylvania St Univ 1.645 9/1/2025 709235S48 12/6/2021 1.120 250,000.00 254,787.50 251,501.14 239,850.00 9/1/2025 428 1,359.41 0.46 Roanoke VA Taxable 2 2/1/2025 770078BD4 5/14/2020 1.250 300,000.00 310,266.00 301,286.23 294,546.00 2/1/2025 216 2,483.33 0.55 Springboro Ohio 5 12/1/2027 85023MAF2 7/12/2022 4.002 245,000.00 256,755.10 252,460.43 246,982.05 12/1/2027 1,249 986.81 0.45 St Louis Park Minn 4.5 2/1/2027 791740V34 9/7/2022 3.345 190,000.00 198,863.50 195,214.47 187,826.40 2/1/2027 946 3,538.75 0.35 Toledo Ohio City Sch 5 12/1/2027 889294RT3 9/28/2022 4.520 100,000.00 102,186.00 101,444.61 100,476.00 12/1/2027 1,249 402.78 0.18 Trussville AL 0.822 10/1/2025 898242ND0 8/25/2020 0.710 300,000.00 301,677.00 300,412.27 284,355.00 10/1/2025 458 609.65 0.55 Waukesha Wis 1.2 10/1/2027 943080UZ2 9/1/2022 3.660 375,000.00 332,557.50 347,833.14 335,152.50 10/1/2027 1,188 1,112.50 0.69 Wauwatosa WI 3 12/1/2024-22 9435042U3 10/28/2021 2.014 200,000.00 205,880.00 200,801.35 198,038.00 12/1/2024 154 483.33 0.37 Wicomico Cnty MD 2 12/1/2026 967546BA9 5/13/2022 3.450 380,000.00 356,975.80 367,761.04 355,904.20 12/1/2026 884 612.22 0.70 Winthrop Minn 2 2/1/2029-28 976367PN6 11/24/2023 5.100 225,000.00 193,556.25 197,188.20 197,950.50 2/1/2029 1,677 1,862.50 0.42 Sub Total / Average Municipal Bond 2.376 11,740,000.00 11,617,236.65 11,558,928.54 11,185,689.10 780 59,498.39 21.67 T-Note 0.375 11/30/2025 91282CAZ4 9/24/2021 0.780 300,000.00 295,008.00 298,307.69 281,439.00 11/30/2025 518 92.21 0.55 T-Note 0.625 11/30/2027 91282CAY7 5/5/2022 3.040 500,000.00 438,535.00 462,305.49 439,690.00 11/30/2027 1,248 256.15 0.92 T-Note 2.5 2/28/2026 9128286F2 12/21/2023 4.220 1,000,000.00 964,310.91 972,876.29 962,770.00 2/28/2026 608 8,288.04 1.85 T-Note 4.625 3/15/2026 91282CGR6 12/21/2023 4.230 1,000,000.00 1,008,280.00 1,006,329.37 996,520.00 3/15/2026 623 13,447.69 1.85 Sub Total / Average Treasury Note 3.644 2,800,000.00 2,706,133.91 2,739,818.84 2,680,419.00 718 22,084.09 5.17 Total / Average 3.224 54,171,143.41 53,882,630.11 53,864,738.05 52,785,708.08 615 160,752.53 100 FHLMC Bond Local Government Investment Pool Municipal Bond Treasury Note FHLB Bond YTM @ Cost Cost Value Days to Maturity % of Portfolio Cash - 3,754,294 1 6.94% Certificate of Deposit 3.471 15,698,134 969 29.00% FAMC Bond 4.580 318,724 1,789 0.60% FFCB Bond 2.524 3,885,668 789 7.15% FHLB Bond 2.147 3,874,257 815 7.27% FHLMC Bond 0.500 200,000 162 0.37% LGIP 5.259 11,828,183 1 21.83% Municipal Bond 2.376 11,617,237 780 21.67% Treasury Note 3.644 2,706,134 718 5.17% Total / Average 3.224 53,882,630 615 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio - Diversification, by Security Type June 30, 2024 Description City of Prior Lake - Quarterly Investment Report Change from one 6/30/2023 9/30/2023 12/31/2023 3/31/2024 6/30/2024 year prior Market Value 20,061,417 18,176,651 14,734,627 9,627,932 15,582,477 (4,478,940) 1 1 1 1 1 0 4.71% 4.89% 4.00% 4.08% 3.99%-0.72% Fixed Income Assets 33,902,781 33,750,838 38,012,573 39,663,383 38,300,153 4,397,372 31,899,550 31,752,611 36,809,204 38,539,677 37,203,231 5,303,682 853 903 963 923 862 9 806 844 903 868 817 11 2.16% 2.37% 2.78% 2.85% 2.89%0.73% Total Portfolio Value 53,964,198 51,927,490 52,747,201 49,291,314 53,882,630 (81,568) 51,960,967 49,929,262 51,543,831 48,167,609 52,785,708 824,742 116,519 170,756 162,916 214,228 160,753 44,233 -2,003,232 -1,998,228 -1,203,369 -1,123,706 -1,096,922 906,310 536 587 695 744 615 79 506 549 652 699 582 76 3.11% 3.25% 3.12% 3.09% 3.21% 0.10% BENCHMARK 90 Day T-Bill 5.43% 5.55% 5.40% 5.46% 5.48% 0.05% 5.47%5.53%5.26%5.38%5.33%-0.14% 5.40%5.46%4.79%5.03%5.09%-0.31% 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, 2024 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