Loading...
HomeMy WebLinkAbout05(D) - Approval of 2nd Quarter 2025 Investment Report Report ITEM: 5D CITY COUNCIL AGENDA REPORT MEETING DATE: July 22, 2025 PREPARED BY: Angela Gieseke, Financial Analyst / Accountant PRESENTED BY: Cathy Erickson, Finance Director AGENDA ITEM: Approval of 2nd Quarter 2025 Investment Report RECOMMENDED ACTION: Approve the 2025 2nd Quarter Investment Report as presented. BACKGROUND: The purpose of this agenda item is for the Council to consider approval of the investment report for the second quarter of 2025. Staff has prepared a list of investments as of June 30, 2025. The Investment Report Summary Narrative provides some supplementary information with respect to the investments currently held and the allowable forms of investments permitted by Minnesota Statute. The investment software provides the ability to generate reports and charts by broker, security type, maturities, etc. The software also enables staff to track interest earned on an accrual basis versus a cash basis as well as changes in market value. ALTERNATIVES: 1. Motion and second as part of the consent agenda to approve the 2025 2nd Quarter Investment Report as presented. 2. Motion and second to remove the Investment Report from the consent agenda for additional discussion. ATTACHMENTS: 1. 2025 Q2 Investment Summary Report (attach 1) 2. 2025 Q2 Year to Year Summary Analysis (attach 2) 3. 2025 Q2 Investment Portfolio by Security Type Graph (attach 3) 4. 2025 Q2 Investment Portfolio by Maturity Range Graph (attach 4) 5. 2025 Q2 Investment Portfolio by Security Type (attach 5) City of Prior Lake | 4646 Dakota Street SE | Prior Lake MN 55372 YTM @ Cost Cost Value Days to Maturity % of Portfolio 0-1 Month 3.212 18,767,959 2 31.91% 1-3 Months 2.032 1,290,712 50 2.19% 3-6 Months 2.021 3,848,718 146 6.35% 6-9 Months 3.765 2,291,689 250 3.91% 9-12 Months 3.742 1,464,620 300 2.54% 1-2 Years 1.763 7,393,126 497 12.62% 2-3 Years 3.747 6,217,642 867 10.89% 3-4 Years 4.554 6,844,078 1,239 11.89% 4-5 Years 4.014 6,003,849 1,607 10.66% 5-10 Years 4.128 3,739,717 2,063 7.04% Total / Average 3.331 57,862,110 649 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio - Diversification, by Maturity Range June 30, 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 2,090,448.35 2,090,448.35 2,090,448.35 2,090,448.35 N/A 1 3.56 Morgan Stanley Cash CASH5089 12/31/2010 0.000 1,805,829.13 1,805,829.13 1,805,829.13 1,805,829.13 N/A 1 3.07 Oppenheimer Cash MM9905 12/27/2011 0.000 16,565.81 16,565.81 16,565.81 16,565.81 N/A 1 0.03 Sub Total / Average Cash 0.000 3,912,843.29 3,912,843.29 3,912,843.29 3,912,843.29 1 0.00 6.66 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 249,022.41 6/16/2026 351 386.80 0.42 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,740.30 8/4/2025 35 3,332.00 0.42 Amerant Bank 4.65 9/8/2028 02357QCF2 9/8/2023 4.650 249,000.00 249,000.00 249,000.00 253,765.86 9/8/2028 1,166 697.88 0.42 AMERASIA BK FLUSHING NY 4 2/15/2029 02357PAG4 2/15/2024 4.000 248,000.00 248,000.00 248,000.00 247,734.64 2/15/2029 1,326 407.67 0.42 American Express Natl 3 5/4/2027 02589ACK6 4/30/2022 3.000 245,000.00 245,000.00 245,000.00 240,665.95 5/4/2027 673 1,147.81 0.42 Bank Hapoalim 0.95 7/23/2026 06251A2Y5 7/23/2021 0.950 245,000.00 245,000.00 245,000.00 237,218.80 7/23/2026 388 1,007.52 0.42 Bank of Belleville 4 6/15/2027 06063PDD4 12/15/2022 4.000 249,000.00 249,000.00 249,000.00 249,129.48 6/15/2027 715 409.32 0.42 BankUnited Savings Miami 0.95 3/31/2026 066519QT9 3/31/2021 0.950 245,000.00 245,000.00 245,000.00 239,316.00 3/31/2026 274 0.00 0.42 BMW Bk 4.75 3/17/2028 055180AW83 3/17/2023 4.750 245,000.00 245,000.00 245,000.00 249,601.10 3/17/2028 991 3,347.77 0.42 BNY Mellon4.5 9/7/2028 05584CJJ6 9/7/2023 4.500 244,000.00 244,000.00 244,000.00 247,416.00 9/7/2028 1,165 3,459.45 0.42 Bridgewater Bk 4.8 3/29/2028 108622NK3 3/29/2023 4.800 245,000.00 245,000.00 245,000.00 250,140.10 3/29/2028 1,003 32.22 0.42 CalPrivate Bk La Jolla 4 9/23/2027-23 13135NAS9 9/28/2022 4.400 249,000.00 244,545.39 247,006.31 249,002.49 9/23/2027 815 193.67 0.42 Carter Bank & Trust 3.8 9/13/2029 146102BB3 9/13/2024 3.800 249,000.00 249,000.00 249,000.00 246,597.15 9/13/2029 1,536 440.70 0.42 Celtic Bank 4.6 9/19/2028 15118RJ32 9/19/2023 4.600 249,000.00 249,000.00 249,000.00 253,419.75 9/19/2028 1,177 345.19 0.42 Central Fed Savings 4.5 9/14/2028 15347VAC5 9/14/2023 4.500 249,000.00 249,000.00 249,000.00 252,660.30 9/14/2028 1,172 491.18 0.42 CIBC Bank USA 4.5 5/25/2028 12547CBN7 5/25/2023 4.500 244,000.00 244,000.00 244,000.00 247,211.04 5/25/2028 1,060 1,082.96 0.42 Citizens Bk Batesville Ark 3.85 2/16/2029 173477BZ2 2/16/2024 3.850 248,000.00 248,000.00 248,000.00 246,479.76 2/16/2029 1,327 366.22 0.42 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 245,553.70 11/24/2025 147 1,249.84 0.42 Customers Bk 4.95 10/27/2028 23204HPE2 10/27/2023 4.950 240,000.00 240,000.00 240,000.00 246,808.80 10/27/2028 1,215 2,083.07 0.41 Discover Bk 4.5 7/24/2028 2546736R2 7/26/2023 4.500 244,000.00 244,000.00 244,000.00 247,481.88 7/24/2028 1,120 4,662.74 0.42 Enerbank USA 0.55 9/25/2025 29278TRL6 9/25/2020 0.550 245,000.00 245,000.00 245,000.00 242,790.10 9/25/2025 87 18.46 0.42 Farmers BK 4.85 10/17/2028 30916PAA2 10/17/2023 4.850 248,000.00 248,000.00 248,000.00 255,097.76 10/17/2028 1,205 428.39 0.42 First Finl Bk3.3 8/2/2027 32022RSG3 8/1/2022 3.300 245,000.00 245,000.00 245,000.00 241,721.90 8/2/2027 763 642.37 0.42 First National Bank/Dama 5 10/31/2028 32117BGJ1 10/31/2023 5.000 248,000.00 248,000.00 248,000.00 255,623.52 10/31/2028 1,219 985.21 0.42 First Natl Bk 4.75 10/30/2028 32110YH73 10/30/2023 4.750 245,000.00 245,000.00 245,000.00 250,595.80 10/30/2028 1,218 0.00 0.42 First Premier Bank 3.65 9/26/2029 33610RVT7 9/26/2024 3.650 245,000.00 245,000.00 245,000.00 241,102.05 9/26/2029 1,549 2,352.00 0.42 First Utd Bk4.4 8/8/2025 33742CCR6 2/8/2023 4.400 245,000.00 245,000.00 245,000.00 245,004.90 8/8/2025 39 649.75 0.42 Genoa Banking Company 4.95 10/31/2028 372348DH2 10/31/2023 4.950 243,000.00 243,000.00 243,000.00 249,876.90 10/31/2028 1,219 2,010.24 0.41 Goldman Sachs Bk 1 7/28/2026 38149MXK4 7/28/2021 1.000 245,000.00 245,000.00 245,000.00 237,066.90 7/28/2026 393 1,026.99 0.42 Hershey State Banl 3.65 9/26/2028 427883AV5 9/26/2024 3.650 240,000.00 240,000.00 240,000.00 237,364.80 9/26/2028 1,184 96.00 0.41 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 242,692.10 7/29/2027 759 23.49 0.42 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 246,915.87 8/2/2027 763 678.10 0.42 Mauch Chunk Trust 4.35 2/28/2029 577234DA2 3/28/2024 4.350 249,000.00 249,000.00 249,000.00 251,679.24 2/28/2029 1,339 59.35 0.42 Medallion Bk Salt 4.4 7/31/2028 58404DSW2 7/31/2023 4.400 245,000.00 245,000.00 245,000.00 247,807.70 7/31/2028 1,127 0.00 0.42 Merrick Bk 4.85 11/6/2029 59013KXW1 11/6/2023 4.850 245,000.00 245,000.00 245,000.00 252,805.70 11/6/2029 1,590 781.32 0.42 Morgan Stanley Bank Step 11/28/2027 61765QP52 9/2/2021 1.004 249,000.00 249,000.00 249,000.00 232,321.98 11/28/2027 881 225.12 0.42 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,669.08 11/8/2028 1,227 1,781.89 0.41 NORTHEAST BK LEWISTON 3.7 9/23/2027 66405SFA3 9/23/2024 3.700 245,000.00 245,000.00 245,000.00 243,449.15 9/23/2027 815 2,458.73 0.42 Old Dominion Natl Bk 4 1/29/2029 679585CL1 1/29/2024 4.000 249,000.00 249,000.00 249,000.00 248,755.98 1/29/2029 1,309 0.00 0.42 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 242,535.30 9/15/2027 807 352.40 0.42 Savibank 4.05 1/19/2027 80517LAC5 1/18/2023 4.050 249,000.00 249,000.00 249,000.00 249,226.59 1/19/2027 568 331.55 0.42 Schuyler Svgs Bk 4.35 7/27/2028 80832MAA5 7/27/2023 4.350 244,000.00 244,000.00 244,000.00 246,383.88 7/27/2028 1,123 4,478.24 0.42 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,734.40 10/17/2028 1,205 2,399.22 0.42 Synchrony Bank 0.9 8/6/2026 87165GD58 8/6/2021 0.900 248,000.00 248,000.00 248,000.00 240,091.28 8/6/2026 402 880.57 0.42 Third Fed Sav & Ln 3.3 8/19/2027 88413QDN5 8/19/2022 3.300 245,000.00 245,000.00 245,000.00 241,614.10 8/19/2027 780 2,901.74 0.42 Toyota Finl Svgs Bk 0.95 7/15/2026 89235MLC3 7/15/2021 0.950 245,000.00 245,000.00 245,000.00 237,375.60 7/15/2026 380 1,058.53 0.42 UBS Bk USA 4.4 7/26/2028 90355GEX0 7/26/2023 4.400 245,000.00 245,000.00 245,000.00 247,802.80 7/26/2028 1,122 118.14 0.42 Uinta Bk Mtn 4.4 3/22/2028 903572FT7 3/22/2023 4.400 245,000.00 245,000.00 245,000.00 247,579.85 3/22/2028 996 236.27 0.42 Univest Bank & Trust 4.5 6/21/2028 91527PCD7 6/21/2023 4.500 249,000.00 249,000.00 249,000.00 252,490.98 6/21/2028 1,087 276.29 0.42 Valley Central 4 4/28/2028 91944RAZ1 4/28/2023 4.000 249,000.00 249,000.00 249,000.00 249,034.86 4/28/2028 1,033 54.58 0.42 Winter Hill Bank 3.5 8/26/2027-23 975875BH7 8/26/2022 3.500 245,000.00 245,000.00 245,000.00 242,601.45 8/26/2027 787 93.97 0.42 Sub Total / Average Certificate Of Deposit 3.769 12,547,000.00 12,542,545.39 12,545,006.31 12,564,778.03 915 52,542.92 21.36 FAMC 4.17 5/24/2029 31422XYY2 1/19/2024 4.580 325,000.00 318,724.25 320,421.79 323,713.00 5/24/2029 1,424 1,355.25 0.55 Sub Total / Average FAMC Bond 4.580 325,000.00 318,724.25 320,421.79 323,713.00 1,424 1,355.25 0.55 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 501,190.00 12/22/2027 905 532.60 0.85 FFCB 0.69 7/22/2025-21 3133ELX33 4/15/2021 0.750 600,000.00 598,488.00 599,978.66 598,734.00 7/22/2025 22 1,817.00 1.02 FFCB 0.72 10/27/2026-21 3133EMES7 6/18/2021 1.000 500,000.00 492,715.00 498,198.29 478,665.00 10/27/2026 484 630.00 0.85 FFCB 0.74 11/24/2026-21 3133EMHC9 4/14/2021 1.053 450,000.00 442,350.00 448,089.37 430,821.00 11/24/2026 512 333.00 0.77 FFCB 1.26 10/15/2030-24 3133EMDG4 9/13/2024 3.700 500,000.00 434,025.00 442,631.73 433,545.00 10/15/2030 1,933 1,312.50 0.85 FFCB 1.45 6/11/2030-24 3133ELH31 9/13/2024 3.620 500,000.00 444,170.00 451,890.89 444,380.00 6/11/2030 1,807 382.64 0.85 FFCB 1.94 6/30/2031-25 3133EMN24 5/5/2025 4.070 425,000.00 376,154.75 377,372.08 376,035.75 6/30/2031 2,191 0.00 0.72 FFCB 2.62 11/17/2025 3133EHJR5 9/24/2021 0.810 500,000.00 536,830.00 503,403.43 496,885.00 11/17/2025 140 1,564.72 0.85 FFCB 2.87 2/25/2030 3133ENPL8 9/9/2024 3.685 1,000,000.00 960,000.00 965,894.74 949,130.00 2/25/2030 1,701 9,965.28 1.70 FFCB 3.05 5/18/2029 3133ENXB1 1/19/2024 4.030 325,000.00 309,845.25 313,957.12 316,537.00 5/18/2029 1,418 1,156.46 0.55 FFCB 4.5 12/22/2025 3133EPQ81 12/29/2023 4.210 1,000,000.00 1,005,440.00 1,001,314.92 1,000,880.00 12/22/2025 175 1,000.00 1.70 Sub Total / Average FFCB Bond 2.993 6,300,000.00 6,100,018.00 6,102,731.23 6,026,802.75 976 18,694.20 10.72 FHLB 1 12/30/2026-21 3130ANY87 10/20/2021 1.205 500,000.00 494,850.00 498,512.28 478,435.00 12/30/2026 548 0.00 0.85 FHLB 1.25 11/10/2026-22 3130APLR4 11/10/2021 1.250 450,000.00 450,000.00 450,000.00 433,593.00 11/10/2026 498 781.25 0.77 City of Prior Lake Portfolio Holdings Investment Portfolio - by Security Type As of 6/30/2025 Cash Certificate Of Deposit FAMC Bond FFCB Bond FHLB Bond FHLB 1.35 2/18/2031-24 3130AKZS8 9/13/2024 3.770 500,000.00 430,995.00 439,514.14 431,020.00 2/18/2031 2,059 225.00 0.85 FHLB 1.875 12/10/2031-25 3130ALJN5 12/30/2024 4.550 500,000.00 421,115.00 426,776.31 433,480.00 12/10/2031 2,354 2,864.58 0.85 FHLB 2.375 8/15/2029 3130AGVG7 2/12/2024 4.310 270,000.00 244,620.00 250,980.78 253,408.50 8/15/2029 1,507 2,404.69 0.46 FHLB 3 4/20/2026 3130ARGN5 12/29/2023 4.350 1,000,000.00 970,620.00 989,753.59 990,500.00 4/20/2026 294 5,833.33 1.70 FHLB Step 12/15/2025-21 3130AKJ72 4/13/2021 0.894 500,000.00 497,500.00 499,753.95 495,045.00 12/15/2025 168 416.67 0.85 FHLN 5159508 1.25 10/16/2026-21 3130ALW83 4/16/2021 1.250 216,666.67 216,666.67 216,666.67 209,122.34 10/16/2026 473 556.71 0.37 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 971,620.00 7/22/2026 387 5,266.67 1.70 Sub Total / Average FHLB Bond 2.555 4,936,666.67 4,726,366.67 4,771,957.72 4,696,223.84 806 18,348.90 8.40 FNMA 1.5 12/18/2031-25 3135GAA50 5/5/2025 4.180 200,000.00 169,280.00 169,991.46 170,038.00 12/18/2031 2,362 100.00 0.34 Sub Total / Average FNMA Bond 4.180 200,000.00 169,280.00 169,991.46 170,038.00 2,362 100.00 0.34 League of Minnesota Cities - 4M Fund LGIP LGIP5101M 11/30/2010 4.228 411.69 411.69 411.69 411.69 N/A 1 0.00 League of Minnesota Cities - 4M Plus Fund LGIP LGIP5101MP 11/30/2010 4.256 13,440,816.40 13,440,816.40 13,440,816.40 13,440,816.40 N/A 1 22.88 League of Minnesota Cities LGIP LGIP5211M 7/24/2024 4.228 550,884.06 550,884.06 550,884.06 550,884.06 N/A 1 0.94 Sub Total / Average Local Government Investment Pool 4.255 13,992,112.15 13,992,112.15 13,992,112.15 13,992,112.15 1 0.00 23.82 AUSTIN TEX CMNTY COLLEGE 1.78 2/1/2030 052404QL7 9/11/2024 3.700 500,000.00 453,475.00 460,374.59 449,695.00 2/1/2030 1,677 3,683.61 0.85 Cabot-Las Positas 1.287 8/1/2027 15722TJS1 4/28/2022 3.500 550,000.00 491,991.50 526,989.86 521,317.50 8/1/2027 762 2,929.71 0.94 California St 2.5 10/1/2029 13063DRE0 8/12/2024 4.100 500,000.00 463,270.00 469,574.40 470,170.00 10/1/2029 1,554 3,090.28 0.85 Cecil Cnty MD 1.05 11/1/2026 1498433N2 9/23/2021 0.970 500,000.00 501,985.00 500,520.46 481,675.00 11/1/2026 489 860.42 0.85 Central Cmnty Sch 2 3/1/2026 153135FJ2 3/4/2021 0.700 300,000.00 319,098.00 302,556.18 295,887.00 3/1/2026 244 1,983.33 0.51 Colorado HSG & FIN 6 11/1/2029 19648G-MF-6 9/11/2024 4.253 1,000,000.00 1,079,960.00 1,067,520.83 1,063,230.00 11/1/2029 1,585 9,833.33 1.70 CONNECTICUT ST 4.79 3/15/2031 20772KZM4 5/7/2025 4.382 500,000.00 510,460.00 510,195.81 514,640.00 3/15/2031 2,084 3,525.97 0.85 Enfield Conn Taxable 1.39 8/1/2027 292749UK2 4/6/2022 3.000 335,000.00 308,658.95 324,669.64 318,018.85 8/1/2027 762 1,927.27 0.57 Falmouth ME Taxable 3 10/15/2025 306783NF4 10/15/2021 0.800 340,000.00 369,386.20 342,152.17 338,878.00 10/15/2025 107 2,125.00 0.58 Franklin Twp 1.623 2/1/2029 355064KL9 10/4/2023 5.350 250,000.00 207,310.00 221,233.04 228,715.00 2/1/2029 1,312 1,679.35 0.43 Goose Creek Tex 4.5 2/15/2027 382604Z25 11/3/2022 4.700 500,000.00 496,125.00 498,526.76 503,875.00 2/15/2027 595 8,437.50 0.85 Hawaii St 1.892 10/1/2029 419792B47 8/14/2024 3.901 435,000.00 394,710.30 401,590.08 398,864.55 10/1/2029 1,554 2,034.69 0.74 Hawaii St GO Ref 2.802 10/1/2027-26 419792KL9 7/28/2022 3.350 100,000.00 97,413.00 98,874.09 97,606.00 10/1/2027 823 692.72 0.17 Hawaii St Taxable 1.033 8/1/2025 419792F92 10/12/2021 0.950 300,000.00 300,924.00 300,021.29 299,157.00 8/1/2025 32 1,282.64 0.51 Indiana Bond Bank 3.326 7/15/2025 45462TER9 3/26/2021 0.900 240,000.00 264,516.00 240,233.93 239,901.60 7/15/2025 15 3,658.60 0.41 KENNEBUNKPORT ME 5 10/1/2029 489299BK2 10/1/2024 3.700 295,000.00 312,357.80 309,772.19 307,095.00 10/1/2029 1,554 3,646.53 0.50 Liberty Center Ohio 0 11/1/2025 530336DV5 8/18/2020 1.051 215,000.00 203,589.95 214,255.74 212,037.30 11/1/2025 124 0.00 0.37 Mason & Kitsap Cntys 1.583 12/1/2028 575181HB1 5/19/2023 4.150 445,000.00 389,032.35 410,417.91 409,867.25 12/1/2028 1,250 567.46 0.76 Massachusetts St 0.986 11/1/2026 57582RK96 6/30/2021 1.000 500,000.00 499,635.00 499,908.47 480,265.00 11/1/2026 489 807.97 0.85 Milwaukee Cnty Wis 2 12/1/2026 6022453V2 11/23/2021 1.300 500,000.00 516,960.00 504,799.48 485,440.00 12/1/2026 519 805.56 0.85 Minnesota St 7 11/1/2028 604146GK0 11/8/2023 5.251 250,000.00 268,952.50 262,704.42 273,082.50 11/1/2028 1,220 2,868.06 0.43 New York NY 1.92 11/1/2029 64971XUUO 9/25/2023 5.150 275,000.00 228,998.00 242,288.84 249,298.50 11/1/2029 1,585 865.33 0.47 New York NY 3.7 8/1/2029-25 64966LYZ8 11/24/2023 5.100 250,000.00 232,897.50 237,706.29 245,067.50 8/1/2029 1,493 3,828.47 0.43 New York NY City 4.2 11/1/2030 64971QRB1 5/5/2025 4.350 500,000.00 496,370.00 496,471.34 497,880.00 11/1/2030 1,950 3,441.67 0.85 New York State TFA 4.2 11/1/2028-23 64971Q7N7 9/7/2023 4.850 250,000.00 242,657.50 245,240.25 249,987.50 11/1/2028 1,220 1,720.83 0.43 Orono ME Taxable 5 11/1/2025 687085DR8 10/29/2020 1.000 330,000.00 394,287.30 334,358.46 330,838.20 11/1/2025 124 2,704.17 0.56 Pennsylvania St Univ 1.645 9/1/2025 709235S48 12/6/2021 1.120 250,000.00 254,787.50 250,220.96 248,920.00 9/1/2025 63 1,359.41 0.43 SIOUX FALLS S D 3.65 11/15/2030-28 829594ML1 9/18/2024 3.720 500,000.00 498,070.00 498,314.58 483,570.00 11/15/2030 1,964 2,281.25 0.85 Springboro Ohio 5 12/1/2027 85023MAF2 7/12/2022 4.002 245,000.00 256,755.10 250,280.24 249,775.05 12/1/2027 884 986.81 0.42 St Louis Park Minn 4.5 2/1/2027 791740V34 9/7/2022 3.345 190,000.00 198,863.50 193,202.55 190,811.30 2/1/2027 581 3,538.75 0.32 TARRANT REGL WTR DIST TEX 1.45 9/1/2029 876448EB3 9/11/2024 3.650 500,000.00 450,390.00 458,366.94 451,995.00 9/1/2029 1,524 2,396.53 0.85 Toledo Ohio City Sch 5 12/1/2027 889294RT3 9/28/2022 4.520 100,000.00 102,186.00 101,022.45 102,366.00 12/1/2027 884 402.78 0.17 Trussville AL 0.822 10/1/2025 898242ND0 8/25/2020 0.710 300,000.00 301,677.00 300,083.71 297,390.00 10/1/2025 93 609.65 0.51 Waukesha Wis 1.2 10/1/2027 943080UZ2 9/1/2022 3.660 375,000.00 332,557.50 356,179.86 352,957.50 10/1/2027 823 1,112.50 0.64 Wicomico Cnty MD 2 12/1/2026 967546BA9 5/13/2022 3.450 380,000.00 356,975.80 372,814.46 369,546.20 12/1/2026 519 612.22 0.65 Winthrop Minn 2 2/1/2029-28 976367PN6 11/24/2023 5.100 225,000.00 193,556.25 203,241.46 207,688.50 2/1/2029 1,312 1,862.50 0.38 YSLETA TEX INDPT SCH 0 8/15/2030 98816PDU3 4/14/2025 4.447 510,000.00 403,246.80 407,464.35 409,198.50 8/15/2030 1,872 0.00 0.87 Sub Total / Average Municipal Bond 3.265 13,735,000.00 13,394,086.30 13,414,148.08 13,326,707.30 1,063 84,162.87 23.38 T-Note 0.375 11/30/2025 91282CAZ4 9/24/2021 0.780 300,000.00 295,008.00 299,500.15 295,185.00 11/30/2025 153 92.21 0.51 T-Note 0.625 11/30/2027 91282CAY7 5/5/2022 3.040 500,000.00 438,535.00 473,329.93 464,725.00 11/30/2027 883 256.15 0.85 T-Note 2.5 2/28/2026 9128286F2 12/21/2023 4.220 1,000,000.00 964,310.91 989,159.44 988,980.00 2/28/2026 243 8,288.04 1.70 T-Note 4.625 3/15/2026 91282CGR6 12/21/2023 4.230 1,000,000.00 1,008,280.00 1,002,621.15 1,003,530.00 3/15/2026 258 13,447.69 1.70 Sub Total / Average Treasury Note 3.644 2,800,000.00 2,706,133.91 2,764,610.67 2,752,420.00 353 22,084.09 4.77 Total / Average 3.331 58,748,622.11 57,862,109.96 57,993,822.70 57,765,638.36 649 197,288.23 100 FNMA Bond Local Government Investment Pool Municipal Bond Treasury Note YTM @ Cost Cost Value Days to Maturity % of Portfolio Cash - 3,912,843 1 6.66% Certificate of Deposit 3.769 12,542,545 915 21.36% FAMC Bond 4.580 318,724 1,424 0.55% FFCB Bond 2.993 6,100,018 976 10.72% FHLB Bond 2.555 4,726,367 806 8.40% FNMA Bond 4.180 169,280 2,362 0.34% LGIP 4.255 13,992,112 1 23.82% Municipal Bond 3.265 13,394,086 1,063 23.38% Treasury Note 3.644 2,706,134 353 4.77% Total / Average 3.331 57,862,110 649 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio - Diversification, by Security Type June 30, 2025 Description City of Prior Lake - Quarterly Investment Report -6/30/256/30/246/30/23 US Treasury Yield Curve 10 yr 6.00 5.00 4.00 3.00 2.00 1.00 4646 Dakota Street SE Prior Lake, MN 55372 INVESTMENT REPORT SUMMARY NARRATIVE The attached “Investment Portfolio – by Security Type” identifies the various types of investments and the brokers/banks the City of Prior Lake uses for investment purposes. As of June 30, 2025, the cost value of the investment portfolio is $57,862,110. This increased $7.3M from March 31, 2025. The ‘weighted average yield to maturity at cost’ of the investment portfolio is currently 3.31% which is an increase from 3.04% as of March 31. The yield will fluctuate due in part to the balances that are in the short-term money market accounts. At the end of June, the balance in the 4M money market was $14.0M. nd The following table shows the treasury rates for the 2 quarter of 2025 compared to the previous two years. Short-term yields in 2025 are lower as compared to both of the two years prior. Short-term se- curities are necessary to meet cash flow needs for payments to vendors (including construction con- tracts) and payroll. Long-term yields in 2025 are lower and in between as compared to both of the two years prior. Interest rates and bond prices exhibit an inverse relationship: when interest rates increase, bond prices decrease, and when rates decrease, bond prices increase. This occurs because newly issued bonds offer higher yields as interest rates rise, making existing lower-yield bonds less attractive and reducing their market price. Conversely, when interest rates fall, existing higher-yield bonds become more ap- pealing, increasing prices. As of June 30, 2025, the cost value of the portfolio is more than the market value of the investments by $96K. The change in the fair value of the securities is adjusted against interest earnings in each of the funds. This is a paper loss for the second quarter of 2025; no actual gain/loss is realized because the City holds the securities until maturity. -6/30/255/31/254/30/25 US Treasury Yield Curve 10 yr 5.00 4.50 4.00 3.50 3.00 2.50 2.00 1.50 1.00 0.50 During the second quarter of 2025, the chart below shows how rates offered by financial institutions have remained steady for both shorter-terms and for longer-terms. As the attached chart titled Investment Portfolio – Diversification, by Maturity Range indicates, approx- imately 32% or $18.8M matures within 1 month. Of that total, $14.0M is in the 4M investment pool. These short-term securities are necessary to meet cash flow needs for payments to vendors (includ- ing construction contracts) and payroll. These funds will be invested as cash flow needs allow and when the appropriate security (type, rate, and maturity) becomes available. Staff continues to look for opportunities to invest funds for our long-term cash needs, primarily for annual debt service and future capital projects. The City’s investment portfolio amount is a pool of funds identified on the monthly Treasurer’s Report. As shown on the June Treasurer’s Report, the book value of cash and investments, is $60.5M. Of this balance, $58.0M is investments and $2.5M is cash. Because City funds are pooled for investment purposes, interest is allocated to each fund monthly and is based upon each individual fund’s propor- tionate share of the total amount. Overall, the total investment pool does not represent excess re- serves but rather available financial resources. In most instances, these funds were established and restricted for specific and designated purposes by either Minnesota Statutes or City Code to accom- plish the goals and objectives of the City. The constraints for each of the funds are noted on the Treasurer’s Report. Investments for local governments are restricted to only those permitted by Minnesota Statutes. Per the City of Prior Lake Investment Policy, the City has chosen to limit its allowable investments as fol- lows: 1. Bonds, notes certificates of indebtedness, treasury bills or other securities is- sued by the United States of America, its agencies and allowable instrumen- talities; 2. Interest bearing checking and savings accounts, or any other investments constituting direct obligations of any bank; 2 3. Certificates of deposit at state and federally chartered institutions that are lim- ited to the amount of coverage provided by the Federal Deposit Insurance Corporation; 4. Money market accounts that are invested in above referenced government se- curities; 5. State and local securities which have at the time of investment one of the three highest credit ratings by a nationally recognized rating agency; 6. Investments may be made only in those savings banks or savings and loan associations the shares, or investment certificates of which are insured by the Federal Deposit Insurance Corporation or the National Credit Union Associa- tion; 7. Investment products that are considered as derivatives are specifically ex- cluded from approved investments. The breakdown of all security types held by the City is shown graphically in the attached document titled Investment Portfolio – Diversification, by Security Type. The investment policy also requires that all investment maturities shall not extend beyond ten (10) years with no more than 20% maturing beyond five (5) years. 3 Change from one 6/30/2024 9/30/2024 12/31/2024 3/31/2025 6/30/2025 year prior Market Value 15,582,477 11,373,705 14,201,388 12,587,578 17,904,955 2,322,479 1 1 1 1 1 0 3.99% 4.48% 3.44% 2.38% 3.33%-0.67% Fixed Income Assets 38,300,153 41,950,294 40,092,623 38,001,643 39,957,155 1,657,001 37,203,231 41,710,847 39,478,162 37,672,515 39,860,683 2,657,452 862 1,015 1,009 963 934 72 817 940 931 926 900 83 2.89% 3.10% 3.17% 3.25% 3.31%0.42% Total Portfolio Value 53,882,630 53,323,998 54,294,011 50,589,221 57,862,110 3,979,480 52,785,708 53,084,551 53,679,550 50,260,093 57,765,638 4,979,930 160,753 229,318 199,911 236,785 197,288 36,536 -1,096,922 -239,447 -614,461 -329,128 -96,472 1,000,450 615 801 748 727 649 34 582 742 691 699 626 44 3.21% 3.39% 3.24% 3.04% 3.31% 0.10% BENCHMARK 90 Day T-Bill 5.48% 4.73% 4.37% 4.32% 4.41% -1.07% 5.33%4.38%4.24%4.23%4.29%-1.04% 5.09%3.98%4.16%4.03%3.96%-1.13% 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, 2025 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