Loading...
HomeMy WebLinkAbout05(D) - Approval of 1st Quarter 2025 Investment Report ReportYTM @ Cost Cost Value Days to Maturity % of Portfolio 0-1 Month 2.378 12,587,578 1 24.56% 1-3 Months - - - 3-6 Months 1.542 2,153,716 129 4.14% 6-9 Months 2.021 3,848,718 237 7.27% 9-12 Months 3.494 2,536,689 343 4.96% 1-2 Years 2.045 8,118,746 547 15.92% 2-3 Years 3.657 5,969,642 921 11.99% 3-4 Years 4.553 6,957,509 1,294 13.79% 4-5 Years 4.074 6,188,248 1,664 12.50% 5-10 Years 3.872 2,228,375 2,114 4.87% Total / Average 3.058 50,589,221 727 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio - Diversification, by Maturity Range March 31, 2025 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 3,341,913.65 3,341,913.65 3,341,913.65 3,341,913.65 N/A 1 6.51 Morgan Stanley Cash CASH5089 12/31/2010 0.000 1,741,142.46 1,741,142.46 1,741,142.46 1,741,142.46 N/A 1 3.39 Oppenheimer Cash MM9905 12/27/2011 0.000 560,136.69 560,136.69 560,136.69 560,136.69 N/A 1 1.09 Sub Total / Average Cash 0.000 5,643,192.80 5,643,192.80 5,643,192.80 5,643,192.80 1 0.00 11.00 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 248,882.97 6/16/2026 442 414.43 0.49 Ally Bk Sandy UT 3.4 8/4/2025 02007GXF5 8/4/2022 3.400 245,000.00 245,000.00 245,000.00 244,233.15 8/4/2025 126 1,255.21 0.48 Amerant Bank 4.65 9/8/2028 02357QCF2 9/8/2023 4.650 249,000.00 249,000.00 249,000.00 253,193.16 9/8/2028 1,257 729.60 0.49 AMERASIA BK FLUSHING NY 4 2/15/2029 02357PAG4 2/15/2024 4.000 248,000.00 248,000.00 248,000.00 246,908.80 2/15/2029 1,417 434.85 0.48 American Express Natl 3 5/4/2027 02589ACK6 4/30/2022 3.000 245,000.00 245,000.00 245,000.00 239,695.75 5/4/2027 764 2,960.14 0.48 Bank Hapoalim 0.95 7/23/2026 06251A2Y5 7/23/2021 0.950 245,000.00 245,000.00 245,000.00 235,256.35 7/23/2026 479 427.24 0.48 Bank of Belleville 4 6/15/2027 06063PDD4 12/15/2022 4.000 249,000.00 249,000.00 249,000.00 248,509.47 6/15/2027 806 436.60 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 237,498.10 3/31/2026 365 0.00 0.48 BMW Bk 4.75 3/17/2028 055180AW83 3/17/2023 4.750 245,000.00 245,000.00 245,000.00 249,155.20 3/17/2028 1,082 446.37 0.48 BNY Mellon4.5 9/7/2028 05584CJJ6 9/7/2023 4.500 244,000.00 244,000.00 244,000.00 246,823.08 9/7/2028 1,256 721.97 0.48 Bridgewater Bk 4.8 3/29/2028 108622NK3 3/29/2023 4.800 245,000.00 245,000.00 245,000.00 249,657.45 3/29/2028 1,094 64.44 0.48 CalPrivate Bk La Jolla 4 9/23/2027-23 13135NAS9 9/28/2022 4.400 249,000.00 244,545.39 246,783.70 248,389.95 9/23/2027 906 221.33 0.49 Carter Bank & Trust 3.8 9/13/2029 146102BB3 9/13/2024 3.800 249,000.00 249,000.00 249,000.00 245,738.10 9/13/2029 1,627 466.62 0.49 Celtic Bank 4.6 9/19/2028 15118RJ32 9/19/2023 4.600 249,000.00 249,000.00 249,000.00 252,824.64 9/19/2028 1,268 376.57 0.49 Central Fed Savings 4.5 9/14/2028 15347VAC5 9/14/2023 4.500 249,000.00 249,000.00 249,000.00 252,010.41 9/14/2028 1,263 521.88 0.49 CIBC Bank USA 4.5 5/25/2028 12547CBN7 5/25/2023 4.500 244,000.00 244,000.00 244,000.00 246,671.80 5/25/2028 1,151 3,790.36 0.48 Citizens Bk Batesville Ark 3.85 2/16/2029 173477BZ2 2/16/2024 3.850 248,000.00 248,000.00 248,000.00 245,577.04 2/16/2029 1,418 392.38 0.48 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 246,193.15 11/24/2025 238 4,209.97 0.48 Customers Bk 4.95 10/27/2028 23204HPE2 10/27/2023 4.950 240,000.00 240,000.00 240,000.00 246,484.80 10/27/2028 1,306 5,044.93 0.47 Discover Bk 4.5 7/24/2028 2546736R2 7/26/2023 4.500 244,000.00 244,000.00 244,000.00 246,859.68 7/24/2028 1,211 1,925.26 0.48 Enerbank USA 0.55 9/25/2025 29278TRL6 9/25/2020 0.550 245,000.00 245,000.00 245,000.00 240,697.80 9/25/2025 178 22.15 0.48 Farmers BK 4.85 10/17/2028 30916PAA2 10/17/2023 4.850 248,000.00 248,000.00 248,000.00 254,693.52 10/17/2028 1,296 461.35 0.48 First Finl Bk3.3 8/2/2027 32022RSG3 8/1/2022 3.300 245,000.00 245,000.00 245,000.00 240,668.40 8/2/2027 854 664.52 0.48 First National Bank/Dama 5 10/31/2028 32117BGJ1 10/31/2023 5.000 248,000.00 248,000.00 248,000.00 255,254.00 10/31/2028 1,310 1,019.18 0.48 First Natl Bk 4.75 10/30/2028 32110YH73 10/30/2023 4.750 245,000.00 245,000.00 245,000.00 250,100.90 10/30/2028 1,309 0.00 0.48 First Premier Bank 3.65 9/26/2029 33610RVT7 9/26/2024 3.650 245,000.00 245,000.00 245,000.00 240,217.60 9/26/2029 1,640 122.50 0.48 First Utd Bk4.4 8/8/2025 33742CCR6 2/8/2023 4.400 245,000.00 245,000.00 245,000.00 245,085.75 8/8/2025 130 679.29 0.48 Genoa Banking Company 4.95 10/31/2028 372348DH2 10/31/2023 4.950 243,000.00 243,000.00 243,000.00 249,614.46 10/31/2028 1,310 4,976.17 0.47 Goldman Sachs Bk 1 7/28/2026 38149MXK4 7/28/2021 1.000 245,000.00 245,000.00 245,000.00 235,089.75 7/28/2026 484 416.16 0.48 Hershey State Banl 3.65 9/26/2028 427883AV5 9/26/2024 3.650 240,000.00 240,000.00 240,000.00 236,316.00 9/26/2028 1,275 120.00 0.47 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 241,751.30 7/29/2027 850 46.99 0.48 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 245,984.61 8/2/2027 854 702.32 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 251,034.33 2/28/2029 1,430 89.03 0.49 Medallion Bk Salt 4.4 7/31/2028 58404DSW2 7/31/2023 4.400 245,000.00 245,000.00 245,000.00 247,133.95 7/31/2028 1,218 0.00 0.48 Merrick Bk 4.85 11/6/2029 59013KXW1 11/6/2023 4.850 245,000.00 245,000.00 245,000.00 252,450.45 11/6/2029 1,681 813.87 0.48 Morgan Stanley Bank Step 11/28/2027 61765QP52 9/2/2021 1.004 249,000.00 249,000.00 249,000.00 229,944.03 11/28/2027 972 211.48 0.49 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,455.24 11/8/2028 1,318 4,807.74 0.47 NORTHEAST BK LEWISTON 3.7 9/23/2027 66405SFA3 9/23/2024 3.700 245,000.00 245,000.00 245,000.00 242,606.35 9/23/2027 906 198.68 0.48 Old Dominion Natl Bk 4 1/29/2029 679585CL1 1/29/2024 4.000 249,000.00 249,000.00 249,000.00 247,914.36 1/29/2029 1,400 0.00 0.49 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 241,552.85 9/15/2027 898 375.89 0.48 Savibank 4.05 1/19/2027 80517LAC5 1/18/2023 4.050 249,000.00 249,000.00 249,000.00 248,868.03 1/19/2027 659 359.17 0.49 Schuyler Svgs Bk 4.35 7/27/2028 80832MAA5 7/27/2023 4.350 244,000.00 244,000.00 244,000.00 245,686.04 7/27/2028 1,214 1,832.01 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,395.24 10/17/2028 1,296 5,349.62 0.48 Synchrony Bank 0.9 8/6/2026 87165GD58 8/6/2021 0.900 248,000.00 248,000.00 248,000.00 238,149.44 8/6/2026 493 324.10 0.48 Third Fed Sav & Ln 3.3 8/19/2027 88413QDN5 8/19/2022 3.300 245,000.00 245,000.00 245,000.00 240,572.85 8/19/2027 871 886.03 0.48 Toyota Finl Svgs Bk 0.95 7/15/2026 89235MLC3 7/15/2021 0.950 245,000.00 245,000.00 245,000.00 235,415.60 7/15/2026 471 478.25 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 247,097.20 7/26/2028 1,213 147.67 0.48 Uinta Bk Mtn 4.4 3/22/2028 903572FT7 3/22/2023 4.400 245,000.00 245,000.00 245,000.00 246,896.30 3/22/2028 1,087 265.81 0.48 Univest Bank & Trust 4.5 6/21/2028 91527PCD7 6/21/2023 4.500 249,000.00 249,000.00 249,000.00 251,821.17 6/21/2028 1,178 306.99 0.49 Valley Central 4 4/28/2028 91944RAZ1 4/28/2023 4.000 249,000.00 249,000.00 249,000.00 248,111.07 4/28/2028 1,124 81.86 0.49 Winter Hill Bank 3.5 8/26/2027-23 975875BH7 8/26/2022 3.500 245,000.00 245,000.00 245,000.00 241,636.15 8/26/2027 878 117.47 0.48 Sub Total / Average Certificate Of Deposit 3.769 12,547,000.00 12,542,545.39 12,544,783.70 12,523,777.79 1,006 50,716.45 24.46 FAMC 4.17 5/24/2029 31422XYY2 1/19/2024 4.580 325,000.00 318,724.25 320,129.22 322,312.25 5/24/2029 1,515 4,781.02 0.63 Sub Total / Average FAMC Bond 4.580 325,000.00 318,724.25 320,129.22 322,312.25 1,515 4,781.02 0.63 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 500,720.00 12/22/2027 996 6,590.96 0.97 FFCB 0.69 7/22/2025-21 3133ELX33 4/15/2021 0.750 600,000.00 598,488.00 599,890.41 593,400.00 7/22/2025 113 793.50 1.17 FFCB 0.72 10/27/2026-21 3133EMES7 6/18/2021 1.000 500,000.00 492,715.00 497,859.54 475,160.00 10/27/2026 575 1,540.00 0.97 FFCB 0.74 11/24/2026-21 3133EMHC9 4/14/2021 1.053 450,000.00 442,350.00 447,749.78 426,667.50 11/24/2026 603 1,174.75 0.88 FFCB 1.26 10/15/2030-24 3133EMDG4 9/13/2024 3.700 500,000.00 434,025.00 439,930.99 428,075.00 10/15/2030 2,024 2,905.00 0.97 FFCB 1.45 6/11/2030-24 3133ELH31 9/13/2024 3.620 500,000.00 444,170.00 449,468.13 435,825.00 6/11/2030 1,898 2,215.28 0.97 FFCB 2.62 11/17/2025 3133EHJR5 9/24/2021 0.810 500,000.00 536,830.00 505,615.66 494,975.00 11/17/2025 231 4,876.11 0.97 FFCB 2.87 2/25/2030 3133ENPL8 9/9/2024 3.685 1,000,000.00 960,000.00 964,070.18 938,220.00 2/25/2030 1,792 2,870.00 1.95 FFCB 3.05 5/18/2029 3133ENXB1 1/19/2024 4.030 325,000.00 309,845.25 313,248.45 312,611.00 5/18/2029 1,509 3,662.12 0.63 FFCB 4.5 12/22/2025 3133EPQ81 12/29/2023 4.210 1,000,000.00 1,005,440.00 1,001,998.67 1,002,040.00 12/22/2025 266 12,375.00 1.95 Sub Total / Average FFCB Bond 2.915 5,875,000.00 5,723,863.25 5,719,831.81 5,607,693.50 979 39,002.72 11.45 FHLB 1 12/30/2026-21 3130ANY87 10/20/2021 1.205 500,000.00 494,850.00 498,265.23 474,365.00 12/30/2026 639 1,250.00 0.97 FHLB 1.25 11/10/2026-22 3130APLR4 11/10/2021 1.250 450,000.00 450,000.00 450,000.00 430,348.50 11/10/2026 589 2,203.12 0.88 FHLB 1.35 2/18/2031-24 3130AKZS8 9/13/2024 3.770 500,000.00 430,995.00 436,840.89 421,730.00 2/18/2031 2,150 243.75 0.97 City of Prior Lake Portfolio Holdings Investment Portfolio - by Security Type As of 3/31/2025 Cash Certificate Of Deposit FAMC Bond FFCB Bond FHLB Bond FHLB 1.875 12/10/2031-25 3130ALJN5 12/30/2024 4.550 500,000.00 421,115.00 423,945.65 429,315.00 12/10/2031 2,445 546.88 0.97 FHLB 2.375 8/15/2029 3130AGVG7 2/12/2024 4.310 270,000.00 244,620.00 249,832.30 250,087.50 8/15/2029 1,598 819.37 0.53 FHLB 3 4/20/2026 3130ARGN5 12/29/2023 4.350 1,000,000.00 970,620.00 986,582.09 987,680.00 4/20/2026 385 13,416.67 1.95 FHLB Step 12/15/2025-21 3130AKJ72 4/13/2021 0.894 500,000.00 497,500.00 499,620.68 491,680.00 12/15/2025 259 2,208.33 0.97 FHLN 5159508 1.25 10/16/2026-21 3130ALW83 4/16/2021 1.250 216,666.67 216,666.67 216,666.67 207,675.00 10/16/2026 564 1,241.32 0.42 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 964,010.00 7/22/2026 478 2,300.00 1.95 Sub Total / Average FHLB Bond 2.555 4,936,666.67 4,726,366.67 4,761,753.51 4,656,891.00 897 24,229.44 9.62 League of Minnesota Cities - 4M Fund LGIP LGIP5101M 11/30/2010 4.289 888,501.30 888,501.30 888,501.30 888,501.30 N/A 1 1.73 League of Minnesota Cities - 4M Plus Fund LGIP LGIP5101MP 11/30/2010 4.317 5,350,397.26 5,350,397.26 5,350,397.26 5,350,397.26 N/A 1 10.43 League of Minnesota Cities LGIP LGIP5211M 7/24/2024 4.289 705,486.71 705,486.71 705,486.71 705,486.71 N/A 1 1.38 Sub Total / Average Local Government Investment Pool 4.311 6,944,385.27 6,944,385.27 6,944,385.27 6,944,385.27 1 0.00 13.54 AUSTIN TEX CMNTY COLLEGE 1.78 2/1/2030 052404QL7 9/11/2024 3.700 500,000.00 453,475.00 458,224.38 442,510.00 2/1/2030 1,768 1,483.33 0.97 Cabot-Las Positas 1.287 8/1/2027 15722TJS1 4/28/2022 3.500 550,000.00 491,991.50 524,241.93 514,915.50 8/1/2027 853 1,179.75 1.07 California St 2.5 10/1/2029 13063DRE0 8/12/2024 4.100 500,000.00 463,270.00 467,792.72 464,140.00 10/1/2029 1,645 6,250.00 0.97 Cecil Cnty MD 1.05 11/1/2026 1498433N2 9/23/2021 0.970 500,000.00 501,985.00 500,617.32 477,535.00 11/1/2026 580 2,187.50 0.97 Central Cmnty Sch 2 3/1/2026 153135FJ2 3/4/2021 0.700 300,000.00 319,098.00 303,509.51 294,144.00 3/1/2026 335 500.00 0.58 Colorado HSG & FIN 6 11/1/2029 19648G-MF-6 9/11/2024 4.253 1,000,000.00 1,079,960.00 1,071,397.42 1,064,750.00 11/1/2029 1,676 25,000.00 1.95 Enfield Conn Taxable 1.39 8/1/2027 292749UK2 4/6/2022 3.000 335,000.00 308,658.95 323,435.97 314,601.85 8/1/2027 853 776.08 0.65 Falmouth ME Taxable 3 10/15/2025 306783NF4 10/15/2021 0.800 340,000.00 369,386.20 343,982.52 337,810.40 10/15/2025 198 4,703.33 0.66 Franklin Twp 1.623 2/1/2029 355064KL9 10/4/2023 5.350 250,000.00 207,310.00 219,237.77 226,637.50 2/1/2029 1,403 676.25 0.49 Goose Creek Tex 4.5 2/15/2027 382604Z25 11/3/2022 4.700 500,000.00 496,125.00 498,301.44 502,830.00 2/15/2027 686 2,875.00 0.97 Hawaii St 1.892 10/1/2029 419792B47 8/14/2024 3.901 435,000.00 394,710.30 399,633.64 392,409.15 10/1/2029 1,645 4,115.10 0.85 Hawaii St GO Ref 2.802 10/1/2027-26 419792KL9 7/28/2022 3.350 100,000.00 97,413.00 98,749.59 96,794.00 10/1/2027 914 1,401.00 0.19 Hawaii St Taxable 1.033 8/1/2025 419792F92 10/12/2021 0.950 300,000.00 300,924.00 300,081.82 296,781.00 8/1/2025 123 516.50 0.58 Indiana Bond Bank 3.326 7/15/2025 45462TER9 3/26/2021 0.900 240,000.00 264,516.00 241,653.11 239,234.40 7/15/2025 106 1,685.17 0.47 KENNEBUNKPORT ME 5 10/1/2029 489299BK2 10/1/2024 3.700 295,000.00 312,357.80 310,637.23 304,962.15 10/1/2029 1,645 7,375.00 0.58 Liberty Center Ohio 0 11/1/2025 530336DV5 8/18/2020 1.051 215,000.00 203,589.95 213,709.54 209,734.65 11/1/2025 215 0.00 0.42 Mason & Kitsap Cntys 1.583 12/1/2028 575181HB1 5/19/2023 4.150 445,000.00 389,032.35 407,900.34 404,545.05 12/1/2028 1,341 2,348.12 0.87 Massachusetts St 0.986 11/1/2026 57582RK96 6/30/2021 1.000 500,000.00 499,635.00 499,891.44 476,535.00 11/1/2026 580 2,054.17 0.97 Milwaukee Cnty Wis 2 12/1/2026 6022453V2 11/23/2021 1.300 500,000.00 516,960.00 505,641.00 482,060.00 12/1/2026 610 3,333.33 0.97 Minnesota St 7 11/1/2028 604146GK0 11/8/2023 5.251 250,000.00 268,952.50 263,652.05 272,980.00 11/1/2028 1,311 7,291.67 0.49 New York NY 1.92 11/1/2029 64971XUUO 9/25/2023 5.150 275,000.00 228,998.00 240,410.79 247,337.75 11/1/2029 1,676 2,200.00 0.54 New York NY 3.7 8/1/2029-25 64966LYZ8 11/24/2023 5.100 250,000.00 232,897.50 236,956.98 243,612.50 8/1/2029 1,584 1,541.67 0.49 New York State TFA 4.2 11/1/2028-23 64971Q7N7 9/7/2023 4.850 250,000.00 242,657.50 244,885.22 249,280.00 11/1/2028 1,311 4,375.00 0.49 Orono ME Taxable 5 11/1/2025 687085DR8 10/29/2020 1.000 330,000.00 394,287.30 337,557.01 331,339.80 11/1/2025 215 6,875.00 0.64 Pennsylvania St Univ 1.645 9/1/2025 709235S48 12/6/2021 1.120 250,000.00 254,787.50 250,540.13 247,285.00 9/1/2025 154 342.71 0.49 SIOUX FALLS S D 3.65 11/15/2030-28 829594ML1 9/18/2024 3.720 500,000.00 498,070.00 498,236.48 482,295.00 11/15/2030 2,055 6,894.44 0.97 Springboro Ohio 5 12/1/2027 85023MAF2 7/12/2022 4.002 245,000.00 256,755.10 250,823.79 248,910.20 12/1/2027 975 4,083.33 0.48 St Louis Park Minn 4.5 2/1/2027 791740V34 9/7/2022 3.345 190,000.00 198,863.50 193,704.15 191,007.00 2/1/2027 672 1,425.00 0.37 TARRANT REGL WTR DIST TEX 1.45 9/1/2029 876448EB3 9/11/2024 3.650 500,000.00 450,390.00 455,880.97 445,060.00 9/1/2029 1,615 604.17 0.97 Toledo Ohio City Sch 5 12/1/2027 889294RT3 9/28/2022 4.520 100,000.00 102,186.00 101,127.70 102,102.00 12/1/2027 975 1,666.67 0.19 Trussville AL 0.822 10/1/2025 898242ND0 8/25/2020 0.710 300,000.00 301,677.00 300,165.63 294,717.00 10/1/2025 184 1,233.00 0.58 Waukesha Wis 1.2 10/1/2027 943080UZ2 9/1/2022 3.660 375,000.00 332,557.50 354,098.90 348,851.25 10/1/2027 914 2,250.00 0.73 Wicomico Cnty MD 2 12/1/2026 967546BA9 5/13/2022 3.450 380,000.00 356,975.80 371,554.56 367,076.20 12/1/2026 610 2,533.33 0.74 Winthrop Minn 2 2/1/2029-28 976367PN6 11/24/2023 5.100 225,000.00 193,556.25 201,732.29 205,056.00 2/1/2029 1,403 750.00 0.44 Sub Total / Average Municipal Bond 3.125 12,225,000.00 11,984,009.50 11,989,965.34 11,819,839.35 1,043 112,525.62 23.83 T-Note 0.375 11/30/2025 91282CAZ4 9/24/2021 0.780 300,000.00 295,008.00 299,202.85 292,611.00 11/30/2025 244 373.97 0.58 T-Note 0.625 11/30/2027 91282CAY7 5/5/2022 3.040 500,000.00 438,535.00 470,581.37 458,730.00 11/30/2027 974 1,038.80 0.97 T-Note 2.5 2/28/2026 9128286F2 12/21/2023 4.220 1,000,000.00 964,310.91 985,099.80 985,660.00 2/28/2026 334 2,105.98 1.95 T-Note 4.625 3/15/2026 91282CGR6 12/21/2023 4.230 1,000,000.00 1,008,280.00 1,003,545.67 1,005,000.00 3/15/2026 349 2,010.87 1.95 Sub Total / Average Treasury Note 3.644 2,800,000.00 2,706,133.91 2,758,429.69 2,742,001.00 444 5,529.62 5.46 Total / Average 3.058 51,296,244.74 50,589,221.04 50,682,471.34 50,260,092.96 727 236,784.87 100 Local Government Investment Pool Municipal Bond Treasury Note YTM @ Cost Cost Value Days to Maturity % of Portfolio Cash - 5,643,193 1 11.01% Certificate of Deposit 3.769 12,542,545 1,006 24.46% FAMC Bond 4.580 318,724 1,515 0.63% FFCB Bond 2.915 5,723,863 979 11.45% FHLB Bond 2.555 4,726,367 897 9.62% LGIP 4.311 6,944,385 1 13.54% Municipal Bond 3.125 11,984,010 1,043 23.83% Treasury Note 3.644 2,706,134 444 5.46% Total / Average 3.058 50,589,221 727 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio - Diversification, by Security Type March 31, 2025 Description City of Prior Lake - Quarterly Investment Report Change from one 3/31/2024 6/30/2024 9/30/2024 12/31/2024 3/31/2025 year prior Market Value 9,627,932 15,582,477 11,373,705 14,201,388 12,587,578 2,959,646 1 1 1 1 1 0 4.08% 3.99% 4.48% 3.44% 2.38%-1.71% Fixed Income Assets 39,663,383 38,300,153 41,950,294 40,092,623 38,001,643 (1,661,740) 38,539,677 37,203,231 41,710,847 39,478,162 37,672,515 (867,162) 923 862 1,015 1,009 963 40 868 817 940 931 926 58 2.85% 2.89% 3.10% 3.17% 3.25%0.40% Total Portfolio Value 49,291,314 53,882,630 53,323,998 54,294,011 50,589,221 1,297,907 48,167,609 52,785,708 53,084,551 53,679,550 50,260,093 2,092,484 214,228 160,753 229,318 199,911 236,785 22,557 -1,123,706 -1,096,922 -239,447 -614,461 -329,128 794,578 744 615 801 748 727 (17) 699 582 742 691 699 0 3.09% 3.21% 3.39% 3.24% 3.04% -0.06% BENCHMARK 90 Day T-Bill 5.46% 5.48% 4.73% 4.37% 4.32% -1.14% 5.38%5.33%4.38%4.24%4.23%-1.15% 5.03%5.09%3.98%4.16%4.03%-1.00% Weighted Average Yield to Maturity @ Cost CITY OF PRIOR LAKE, MINNESOTA Quarterly Investment Report December 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 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 City of Prior Lake - Quarterly Investment Report