Loading...
HomeMy WebLinkAbout05(B) - Approval of 1st Quarter 2024 Investment Report ReportYTM @ Cost Cost Value Days to Maturity % of Portfolio 0-1 Month 4.083 9,627,932 1 19.43% 1-3 Months 1.801 1,363,229 46 2.70% 3-6 Months 2.062 2,692,925 141 5.46% 6-9 Months 2.263 2,836,143 233 5.64% 9-12 Months 1.178 1,842,981 324 3.71% 1-2 Years 2.346 8,539,123 607 16.95% 2-3 Years 2.045 8,118,746 912 16.48% 3-4 Years 3.655 5,724,642 1,287 11.92% 4-5 Years 4.596 6,965,509 1,654 14.29% 5-10 Years 4.640 1,580,085 1,953 3.42% Total / Average 3.111 49,291,314 744 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio - Diversification, by Maturity Range March 31, 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 339,363.90 339,363.90 339,363.90 339,363.90 N/A 1 0.68 Morgan Stanley Cash CASH5089 12/31/2010 0.000 71,963.37 71,963.37 71,963.37 71,963.37 N/A 1 0.15 Oppenheimer Cash MM9905 12/27/2011 0.000 1,794,224.98 1,794,224.98 1,794,224.98 1,794,224.98 N/A 1 3.62 Sub Total / Average Cash 0.000 2,205,552.25 2,205,552.25 2,205,552.25 2,205,552.25 1 0.00 4.45 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,078.25 6/16/2026 807 414.43 0.50 Ally Bk Sandy UT 3.4 8/4/2025 02007GXF5 8/4/2022 3.400 245,000.00 245,000.00 245,000.00 239,872.15 8/4/2025 491 1,278.03 0.49 Amerant Bank 4.65 9/8/2028 02357QCF2 9/8/2023 4.650 249,000.00 249,000.00 249,000.00 252,299.25 9/8/2028 1,622 729.60 0.50 AMERASIA BK FLUSHING NY 4 2/15/2029 02357PAG4 2/15/2024 4.000 248,000.00 248,000.00 248,000.00 244,728.88 2/15/2029 1,782 434.85 0.50 American Express Natl 3 5/4/2027 02589ACK6 4/30/2022 3.000 245,000.00 245,000.00 245,000.00 233,732.45 5/4/2027 1,129 2,980.27 0.49 Banc Calif Irvine 3.2 7/1/2024 05961SNS9 6/29/2022 3.200 245,000.00 245,000.00 245,000.00 243,625.55 7/1/2024 92 1,997.59 0.49 Bank Hapoalim 0.95 7/23/2026 06251A2Y5 7/23/2021 0.950 245,000.00 245,000.00 245,000.00 224,603.75 7/23/2026 844 433.62 0.49 Bank of Belleville 4 6/15/2027 06063PDD4 12/15/2022 4.000 249,000.00 249,000.00 249,000.00 244,752.06 6/15/2027 1,171 436.60 0.50 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 240,739.45 9/30/2024 183 12.08 0.49 BankUnited Savings Miami 0.95 3/31/2026 066519QT9 3/31/2021 0.950 245,000.00 245,000.00 245,000.00 226,796.50 3/31/2026 730 0.00 0.49 BMW Bk 4.75 3/17/2028 055180AW83 3/17/2023 4.750 245,000.00 245,000.00 245,000.00 248,425.10 3/17/2028 1,447 446.37 0.49 BNY Mellon4.5 9/7/2028 05584CJJ6 9/7/2023 4.500 244,000.00 244,000.00 244,000.00 245,644.56 9/7/2028 1,621 721.97 0.49 Bridgewater Bk 4.8 3/29/2028 108622NK3 3/29/2023 4.800 245,000.00 245,000.00 245,000.00 249,160.10 3/29/2028 1,459 64.44 0.49 CalPrivate Bk La Jolla 4 9/23/2027-23 13135NAS9 9/28/2022 4.400 249,000.00 244,545.39 245,890.82 245,053.35 9/23/2027 1,271 221.33 0.50 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 237,338.85 3/17/2025 351 181.23 0.49 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 243,961.90 8/14/2024 136 653.70 0.50 Celtic Bank 4.6 9/19/2028 15118RJ32 9/19/2023 4.600 249,000.00 249,000.00 249,000.00 251,828.64 9/19/2028 1,633 376.57 0.50 Central Fed Savings 4.5 9/14/2028 15347VAC5 9/14/2023 4.500 249,000.00 249,000.00 249,000.00 250,805.25 9/14/2028 1,628 521.88 0.50 CIBC Bank USA 4.5 5/25/2028 12547CBN7 5/25/2023 4.500 244,000.00 244,000.00 244,000.00 245,461.56 5/25/2028 1,516 3,820.44 0.49 Citizens Bk Batesville Ark 3.85 2/16/2029 173477BZ2 2/16/2024 3.850 248,000.00 248,000.00 248,000.00 243,092.08 2/16/2029 1,783 392.38 0.50 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,958.35 11/24/2025 603 4,242.86 0.49 Customers Bk 4.95 10/27/2028 23204HPE2 10/27/2023 4.950 240,000.00 240,000.00 240,000.00 246,196.80 10/27/2028 1,671 5,077.48 0.48 Discover Bk 4.5 7/24/2028 2546736R2 7/26/2023 4.500 244,000.00 244,000.00 244,000.00 245,644.56 7/24/2028 1,576 1,955.34 0.49 Enerbank USA 0.55 9/25/2025 29278TRL6 9/25/2020 0.550 245,000.00 245,000.00 245,000.00 229,462.10 9/25/2025 543 22.15 0.49 Enterprise Bank & Trust 1.8 11/8/2024 29367SJQ8 11/8/2019 1.800 245,000.00 245,000.00 245,000.00 239,894.20 11/8/2024 222 277.89 0.49 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 240,710.05 9/27/2024 180 48.33 0.49 Farmers BK 4.85 10/17/2028 30916PAA2 10/17/2023 4.850 248,000.00 248,000.00 248,000.00 254,413.28 10/17/2028 1,661 461.35 0.50 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,074.40 4/25/2028 1,486 199.76 0.50 First Commercial Bank MS 0.3 3/31/2025 31984GFK0 3/7/2022 1.700 225,000.00 215,588.25 221,932.78 214,456.50 3/31/2025 365 1.85 0.45 First Finl Bk3.3 8/2/2027 32022RSG3 8/1/2022 3.300 245,000.00 245,000.00 245,000.00 235,658.15 8/2/2027 1,219 664.52 0.49 First National Bank/Dama 5 10/31/2028 32117BGJ1 10/31/2023 5.000 248,000.00 248,000.00 248,000.00 255,092.80 10/31/2028 1,675 1,019.18 0.50 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 237,304.55 2/28/2025 334 32.22 0.49 First Natl Bk 4.75 10/30/2028 32110YH73 10/30/2023 4.750 245,000.00 245,000.00 245,000.00 249,461.45 10/30/2028 1,674 0.00 0.49 First Utd Bk4.4 8/8/2025 33742CCR6 2/8/2023 4.400 245,000.00 245,000.00 245,000.00 243,059.60 8/8/2025 495 679.29 0.49 Genoa Banking Company 4.95 10/31/2028 372348DH2 10/31/2023 4.950 243,000.00 243,000.00 243,000.00 249,322.86 10/31/2028 1,675 5,009.13 0.49 Goldman Sachs Bk 1 7/28/2026 38149MXK4 7/28/2021 1.000 245,000.00 245,000.00 245,000.00 224,397.95 7/28/2026 849 422.88 0.49 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 237,204.10 7/29/2027 1,215 46.99 0.49 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 241,435.38 8/2/2027 1,219 702.32 0.50 Luana Savings Bank 0.2 5/7/2024 549104XH5 11/22/2021 0.699 240,000.00 237,081.60 239,879.62 238,663.20 5/7/2024 37 190.68 0.48 Manufacturers 4.9 12/9/2024 564759RJ9 12/7/2022 4.900 245,000.00 245,000.00 245,000.00 244,456.10 12/9/2024 253 3,782.40 0.49 Mauch Chunk Trust 4.35 2/28/2029 577234DA2 3/28/2024 4.350 249,000.00 249,000.00 249,000.00 249,600.09 2/28/2029 1,795 89.03 0.50 Medallion Bk Salt 4.4 7/31/2028 58404DSW2 7/31/2023 4.400 245,000.00 245,000.00 245,000.00 245,705.60 7/31/2028 1,583 0.00 0.49 Merrick Bk 4.85 11/6/2029 59013KXW1 11/6/2023 4.850 245,000.00 245,000.00 245,000.00 252,852.25 11/6/2029 2,046 813.87 0.49 Morgan Stanley Bank Step 11/28/2027 61765QP52 9/2/2021 1.004 249,000.00 249,000.00 249,000.00 220,499.46 11/28/2027 1,337 218.30 0.50 MORGAN STANLEY PRIVATE BK 5.05 11/8/2028 61768EE82 11/8/2023 5.050 243,000.00 243,000.00 243,000.00 250,365.33 11/8/2028 1,683 4,841.36 0.49 Oceanfirst Bk Natl 3.25 7/1/2024 67523TBE2 6/29/2022 3.250 245,000.00 245,000.00 245,000.00 243,657.40 7/1/2024 92 2,028.80 0.49 Old Dominion Natl Bk 4 1/29/2029 679585CL1 1/29/2024 4.000 249,000.00 249,000.00 249,000.00 245,775.45 1/29/2029 1,765 0.00 0.50 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 237,167.35 9/15/2027 1,263 375.89 0.49 Preferred Bank LA Calif 1.95 8/30/2024 740367HR1 8/30/2019 1.950 249,000.00 249,000.00 249,000.00 245,511.51 8/30/2024 152 0.00 0.50 Sallie Mae Bank Utah 1.9 9/18/2024 7954504D4 9/18/2019 1.900 245,000.00 245,000.00 245,000.00 241,018.75 9/18/2024 171 165.79 0.49 Savibank 4.05 1/19/2027 80517LAC5 1/18/2023 4.050 249,000.00 249,000.00 249,000.00 244,943.79 1/19/2027 1,024 359.17 0.50 Schuyler Svgs Bk 4.35 7/27/2028 80832MAA5 7/27/2023 4.350 244,000.00 244,000.00 244,000.00 244,170.80 7/27/2028 1,579 1,861.08 0.49 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,049.60 12/9/2024 253 3,492.16 0.48 Southern First Bank NA 4.85 10/17/2028 84287PJB9 11/7/2023 4.850 244,000.00 244,000.00 244,000.00 250,060.96 10/17/2028 1,661 5,382.04 0.49 Synchrony Bank 0.9 8/6/2026 87165GD58 8/6/2021 0.900 248,000.00 248,000.00 248,000.00 227,549.92 8/6/2026 858 330.21 0.50 Texas Exchange Bk 0.45 8/21/2024 88241TJE1 8/21/2020 0.450 245,000.00 245,000.00 245,000.00 240,286.20 8/21/2024 143 30.21 0.49 Third Fed Sav & Ln 3.3 8/19/2027 88413QDN5 8/19/2022 3.300 245,000.00 245,000.00 245,000.00 235,655.70 8/19/2027 1,236 908.18 0.49 Toyota Finl Svgs Bk 0.95 7/15/2026 89235MLC3 7/15/2021 0.950 245,000.00 245,000.00 245,000.00 224,763.00 7/15/2026 836 484.63 0.49 Transportation Alliance Bk 4.8 9/9/2024 89388CGG7 12/9/2022 4.800 240,000.00 240,000.00 240,000.00 239,426.40 9/9/2024 162 694.36 0.48 UBS Bk USA 4.4 7/26/2028 90355GEX0 7/26/2023 4.400 245,000.00 245,000.00 245,000.00 245,695.80 7/26/2028 1,578 147.67 0.49 Uinta Bk Mtn 4.4 3/22/2028 903572FT7 3/22/2023 4.400 245,000.00 245,000.00 245,000.00 245,463.05 3/22/2028 1,452 265.81 0.49 Univest Bank & Trust 4.5 6/21/2028 91527PCD7 6/21/2023 4.500 249,000.00 249,000.00 249,000.00 256,691.61 6/21/2028 1,543 306.99 0.50 Valley Central 4 4/28/2028 91944RAZ1 4/28/2023 4.000 249,000.00 249,000.00 249,000.00 245,867.58 4/28/2028 1,489 81.86 0.50 Washington Federal 1.95 8/28/2024 938828BN9 8/28/2019 1.950 245,000.00 245,000.00 245,000.00 241,609.20 8/28/2024 150 39.27 0.49 Wells 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,024.10 199,284.00 5/17/2024 47 210.96 0.40 Winter Hill Bank 3.5 8/26/2027-23 975875BH7 8/26/2022 3.500 245,000.00 245,000.00 245,000.00 237,157.55 8/26/2027 1,243 117.47 0.49 Sub Total / Average Certificate Of Deposit 3.420 16,152,000.00 16,136,139.24 16,145,727.32 15,926,694.41 1,032 64,199.11 32.59 FAMC 4.17 5/24/2029 31422XYY2 1/19/2024 4.580 325,000.00 318,724.25 318,955.73 315,900.00 5/24/2029 1,880 4,781.02 0.66 Sub Total / Average FAMC Bond 4.580 325,000.00 318,724.25 318,955.73 315,900.00 1,880 4,781.02 0.66 City of Prior Lake Portfolio Holdings Investment Portfolio - by Security Type As of 3/31/2024 Cash Certificate Of Deposit FAMC Bond FFCB Bond 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,060.00 12/22/2027 1,361 6,657.53 1.01 FFCB 0.69 7/22/2025-21 3133ELX33 4/15/2021 0.750 600,000.00 598,488.00 599,536.41 568,116.00 7/22/2025 478 793.50 1.21 FFCB 0.72 10/27/2026-21 3133EMES7 6/18/2021 1.000 500,000.00 492,715.00 496,500.82 451,550.00 10/27/2026 940 1,540.00 1.01 FFCB 0.74 11/24/2026-21 3133EMHC9 4/14/2021 1.053 450,000.00 442,350.00 446,387.71 407,178.00 11/24/2026 968 1,174.75 0.91 FFCB 2.62 11/17/2025 3133EHJR5 9/24/2021 0.810 500,000.00 536,830.00 514,488.90 483,195.00 11/17/2025 596 4,876.11 1.01 FFCB 3.05 5/18/2029 3133ENXB1 1/19/2024 4.030 325,000.00 309,845.25 310,405.96 306,796.75 5/18/2029 1,874 3,662.12 0.66 FFCB 4.5 12/22/2025 3133EPQ81 12/29/2023 4.210 1,000,000.00 1,005,440.00 1,004,741.22 994,770.00 12/22/2025 631 12,375.00 2.02 Sub Total / Average FFCB Bond 2.524 3,875,000.00 3,885,668.25 3,872,061.02 3,707,665.75 880 31,079.01 7.82 FHLB 1 12/30/2026-21 3130ANY87 10/20/2021 1.205 500,000.00 494,850.00 497,274.33 451,380.00 12/30/2026 1,004 1,250.00 1.01 FHLB 1.25 11/10/2026-22 3130APLR4 11/10/2021 1.250 450,000.00 450,000.00 450,000.00 413,626.50 11/10/2026 954 2,203.12 0.91 FHLB 2.375 8/15/2029 3130AGVG7 2/12/2024 4.310 270,000.00 244,620.00 245,225.79 242,846.10 8/15/2029 1,963 819.37 0.54 FHLB 3 4/20/2026 3130ARGN5 12/29/2023 4.350 1,000,000.00 970,620.00 973,861.21 965,140.00 4/20/2026 750 13,416.67 2.02 FHLB Step 12/15/2025-21 3130AKJ72 4/13/2021 0.894 500,000.00 497,500.00 499,086.12 471,530.00 12/15/2025 624 1,177.78 1.01 FHLN 5159508 1.25 10/16/2026-21 3130ALW83 4/16/2021 1.250 216,666.67 216,666.67 216,666.67 199,095.00 10/16/2026 929 1,241.32 0.44 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 925,880.00 7/22/2026 843 2,300.00 2.02 Sub Total / Average FHLB Bond 2.147 3,936,666.67 3,874,256.67 3,882,114.12 3,669,497.60 906 22,408.26 7.94 FHLMC 0.5 12/9/2024 3134GWA71 9/9/2020 0.500 200,000.00 200,000.00 200,000.00 193,450.00 12/9/2024 253 311.11 0.40 Sub Total / Average FHLMC Bond 0.500 200,000.00 200,000.00 200,000.00 193,450.00 253 311.11 0.40 League of Minnesota Cities - 4M Fund LGIP LGIP5101M 11/30/2010 5.275 156,273.00 156,273.00 156,273.00 156,273.00 N/A 1 0.32 League of Minnesota Cities - 4M Plus Fund LGIP LGIP5101MP 11/30/2010 5.297 7,266,106.44 7,266,106.44 7,266,106.44 7,266,106.44 N/A 1 14.66 Sub Total / Average Local Government Investment Pool 5.297 7,422,379.44 7,422,379.44 7,422,379.44 7,422,379.44 1 0.00 14.98 Allen Park MI Public Sch Dist 2 11/2/2024 018033HR4 7/30/2020 0.751 290,000.00 305,140.90 292,101.82 284,777.10 11/2/2024 216 2,416.67 0.59 Cabot-Las Positas 1.287 8/1/2027 15722TJS1 4/28/2022 3.500 550,000.00 491,991.50 513,220.01 494,994.50 8/1/2027 1,218 1,179.75 1.11 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 279,388.35 11/1/2024 215 2,375.00 0.58 Cecil Cnty MD 1.05 11/1/2026 1498433N2 9/23/2021 0.970 500,000.00 501,985.00 501,005.80 456,060.00 11/1/2026 945 2,187.50 1.01 Central Cmnty Sch 2 3/1/2026 153135FJ2 3/4/2021 0.700 300,000.00 319,098.00 307,333.30 284,382.00 3/1/2026 700 500.00 0.61 El Paso TX ISD 0 8/15/2024 283770NS0 10/30/2020 0.700 500,000.00 486,925.00 498,706.66 490,585.00 8/15/2024 137 0.00 1.01 Enfield Conn Taxable 1.39 8/1/2027 292749UK2 4/6/2022 3.000 335,000.00 308,658.95 318,487.70 301,684.25 8/1/2027 1,218 776.08 0.68 Falmouth ME Taxable 3 10/15/2025 306783NF4 10/15/2021 0.800 340,000.00 369,386.20 351,324.05 330,514.00 10/15/2025 563 4,703.33 0.69 Federal Way Wash2.2 12/1/2024 314031-HH-1 12/11/2019 2.150 475,000.00 476,111.50 475,149.87 465,785.00 12/1/2024 245 3,483.33 0.96 Franklin Twp 1.623 2/1/2029 355064KL9 10/4/2023 5.350 250,000.00 207,310.00 211,234.76 219,120.00 2/1/2029 1,768 676.25 0.50 Goose Creek Tex 4.5 2/15/2027 382604Z25 11/3/2022 4.700 500,000.00 496,125.00 497,397.68 498,560.00 2/15/2027 1,051 2,875.00 1.01 Hawaii St GO Ref 2.802 10/1/2027-26 419792KL9 7/28/2022 3.350 100,000.00 97,413.00 98,250.25 94,632.00 10/1/2027 1,279 1,401.00 0.20 Hawaii St Taxable 1.033 8/1/2025 419792F92 10/12/2021 0.950 300,000.00 300,924.00 300,324.63 284,727.00 8/1/2025 488 516.50 0.61 Indiana Bond Bank 3.326 7/15/2025 45462TER9 3/26/2021 0.900 240,000.00 264,516.00 247,345.44 234,748.80 7/15/2025 471 1,685.17 0.48 Liberty Center Ohio 0 11/1/2025 530336DV5 8/18/2020 1.051 215,000.00 203,589.95 211,518.76 198,769.65 11/1/2025 580 0.00 0.43 Mankato Minn ISD 0.7 2/1/2025 563690RP3 10/22/2020 0.700 300,000.00 300,000.00 300,000.00 288,891.00 2/1/2025 307 350.00 0.61 Mason & Kitsap Cntys 1.583 12/1/2028 575181HB1 5/19/2023 4.150 445,000.00 389,032.35 397,802.37 388,164.60 12/1/2028 1,706 2,348.12 0.90 Massachusetts St 0.986 11/1/2026 57582RK96 6/30/2021 1.000 500,000.00 499,635.00 499,823.12 455,635.00 11/1/2026 945 2,054.17 1.01 Massachusetts St Dev 2.785 5/1/2024 57584FEM8 12/20/2019 1.920 240,000.00 248,647.20 240,168.17 239,421.60 5/1/2024 31 2,785.00 0.48 Milwaukee Cnty Wis 2 12/1/2026 6022453V2 11/23/2021 1.300 500,000.00 516,960.00 509,016.36 466,055.00 12/1/2026 975 3,333.33 1.01 Minnesota St 7 11/1/2028 604146GK0 11/8/2023 5.251 250,000.00 268,952.50 267,452.96 276,037.50 11/1/2028 1,676 6,951.39 0.50 New York NY 1.92 11/1/2029 64971XUUO 9/25/2023 5.150 275,000.00 228,998.00 232,877.94 238,548.75 11/1/2029 2,041 2,200.00 0.55 New York NY 3.7 8/1/2029-25 64966LYZ8 11/24/2023 5.100 250,000.00 232,897.50 233,951.48 239,565.00 8/1/2029 1,949 1,541.67 0.50 New York State TFA 4.2 11/1/2028-23 64971Q7N7 9/7/2023 4.850 250,000.00 242,657.50 243,461.20 246,312.50 11/1/2028 1,676 4,375.00 0.50 Northwest Local Sch District Hamilton & Butler 667712CG6 11/15/2019 2.169 370,000.00 389,010.60 372,527.18 365,319.50 12/1/2024 245 4,008.33 0.75 Oklahoma Cnty Okla Metro 2.65 6/1/2024 67869T-AD-7 7/15/2019 2.286 500,000.00 508,255.00 500,287.05 497,820.00 6/1/2024 62 4,416.67 1.01 Orono ME Taxable 5 11/1/2025 687085DR8 10/29/2020 1.000 330,000.00 394,287.30 350,386.35 329,749.20 11/1/2025 580 6,875.00 0.67 Pelican Rapids Minn 0.8 2/1/2025 705863HR2 12/17/2020 0.700 525,000.00 527,126.25 525,433.15 506,682.75 2/1/2025 307 700.00 1.06 Pennsylvania St Univ 1.645 9/1/2025 709235S48 12/6/2021 1.120 250,000.00 254,787.50 251,820.30 238,792.50 9/1/2025 519 342.71 0.50 Roanoke VA Taxable 2 2/1/2025 770078BD4 5/14/2020 1.250 300,000.00 310,266.00 301,828.11 292,413.00 2/1/2025 307 1,000.00 0.61 Springboro Ohio 5 12/1/2027 85023MAF2 7/12/2022 4.002 245,000.00 256,755.10 253,003.98 248,275.65 12/1/2027 1,340 4,083.33 0.49 St Louis Park Minn 4.5 2/1/2027 791740V34 9/7/2022 3.345 190,000.00 198,863.50 195,716.08 187,989.80 2/1/2027 1,037 1,425.00 0.38 Toledo Ohio City Sch 5 12/1/2027 889294RT3 9/28/2022 4.520 100,000.00 102,186.00 101,549.86 100,780.00 12/1/2027 1,340 1,666.67 0.20 Trussville AL 0.822 10/1/2025 898242ND0 8/25/2020 0.710 300,000.00 301,677.00 300,494.19 282,474.00 10/1/2025 549 1,233.00 0.61 Waukesha Wis 1.2 10/1/2027 943080UZ2 9/1/2022 3.660 375,000.00 332,557.50 345,752.18 333,937.50 10/1/2027 1,279 2,250.00 0.76 Wauwatosa WI 3 12/1/2024-22 9435042U3 10/28/2021 2.014 200,000.00 205,880.00 201,274.87 197,088.00 12/1/2024 245 2,000.00 0.40 Wicomico Cnty MD 2 12/1/2026 967546BA9 5/13/2022 3.450 380,000.00 356,975.80 366,501.15 354,293.00 12/1/2026 975 2,533.33 0.77 Winthrop Minn 2 2/1/2029-28 976367PN6 11/24/2023 5.100 225,000.00 193,556.25 195,679.03 196,719.75 2/1/2029 1,768 750.00 0.45 Wisconsin St Gen Fund 2.877 5/1/2024 977100EA0 12/2/2021 0.700 160,000.00 168,321.60 160,292.81 159,648.00 5/1/2024 31 1,918.00 0.32 Sub Total / Average Municipal Bond 2.343 12,640,000.00 12,542,460.45 12,455,500.62 12,049,341.25 812 85,916.30 25.51 T-Note 0.375 11/30/2025 91282CAZ4 9/24/2021 0.780 300,000.00 295,008.00 298,010.39 279,153.00 11/30/2025 609 375.00 0.61 T-Note 0.625 11/30/2027 91282CAY7 5/5/2022 3.040 500,000.00 438,535.00 459,556.94 437,815.00 11/30/2027 1,339 1,041.67 1.01 T-Note 2.5 2/28/2026 9128286F2 12/21/2023 4.220 1,000,000.00 964,310.91 968,816.66 960,780.00 2/28/2026 699 2,105.98 2.02 T-Note 4.625 3/15/2026 91282CGR6 12/21/2023 4.230 1,000,000.00 1,008,280.00 1,007,253.89 999,380.00 3/15/2026 714 2,010.87 2.02 Sub Total / Average Treasury Note 3.644 2,800,000.00 2,706,133.91 2,733,637.88 2,677,128.00 809 5,533.52 5.65 Total / Average 3.111 49,556,598.36 49,291,314.46 49,235,928.38 48,167,608.70 744 214,228.33 100 FHLMC Bond Local Government Investment Pool Municipal Bond Treasury Note FHLB Bond YTM @ Cost Cost Value Days to Maturity % of Portfolio Cash - 2,205,552 1 4.45% Certificate of Deposit 3.420 16,136,139 1,032 32.59% FAMC Bond 4.580 318,724 1,880 0.66% FFCB Bond 2.524 3,885,668 880 7.82% FHLB Bond 2.147 3,874,257 906 7.94% FHLMC Bond 0.500 200,000 253 0.40% LGIP 5.297 7,422,379 1 14.98% Municipal Bond 2.343 12,542,460 812 25.51% Treasury Note 3.644 2,706,134 809 5.65% Total / Average 3.111 49,291,314 744 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio - Diversification, by Security Type March 31, 2024 Description City of Prior Lake - Quarterly Investment Report Change from one 3/31/2023 6/30/2023 9/30/2023 12/31/2023 3/31/2024 year prior Market Value 12,699,977 20,061,417 18,176,651 14,734,627 9,627,932 (3,072,045) 1 1 1 1 1 0 4.31% 4.71% 4.89% 4.00% 4.08%-0.23% Fixed Income Assets 33,936,884 33,902,781 33,750,838 38,012,573 39,663,383 5,726,499 32,121,659 31,899,550 31,752,611 36,809,204 38,539,677 6,418,018 865 853 903 963 923 58 826 806 844 903 868 42 2.06% 2.16% 2.37% 2.78% 2.85%0.80% Total Portfolio Value 46,636,861 53,964,198 51,927,490 52,747,201 49,291,314 2,654,453 44,821,636 51,960,967 49,929,262 51,543,831 48,167,609 3,345,973 164,251 116,519 170,756 162,916 214,228 49,977 -1,815,225 -2,003,232 -1,998,228 -1,203,369 -1,123,706 691,519 630 536 587 695 744 114 601 506 549 652 699 98 2.67% 3.11% 3.25% 3.12% 3.09% 0.42% BENCHMARK 90 Day T-Bill 4.85% 5.43% 5.55% 5.40% 5.46% 0.61% 4.97%5.47%5.53%5.26%5.38%0.41% 4.94%5.40%5.46%4.79%5.03%0.09% 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 March 31, 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