Loading...
HomeMy WebLinkAbout05(E) - Approval of 4th Quarter 2024 Investment Report ReportYTM @ Cost Cost Value Days to Maturity % of Portfolio 0-1 Month 3.442 14,201,388 1 25.83% 1-3 Months 1.178 1,842,981 49 3.35% 3-6 Months - - - 0.00% 6-9 Months 1.542 2,153,716 219 3.86% 9-12 Months 2.021 3,848,718 327 6.78% 1-2 Years 2.210 9,711,446 571 17.77% 2-3 Years 3.630 6,178,631 956 11.55% 3-4 Years 4.604 6,545,642 1,329 11.98% 4-5 Years 4.247 6,169,639 1,668 11.61% 5-10 Years 3.804 3,641,850 2,080 7.27% Total / Average 3.258 54,294,011 748 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio - Diversification, by Maturity Range December 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 1,834,746.65 1,834,746.65 1,834,746.65 1,834,746.65 N/A 1 3.34 Morgan Stanley Cash CASH5089 12/31/2010 0.000 1,442,622.02 1,442,622.02 1,442,622.02 1,442,622.02 N/A 1 2.62 Oppenheimer Cash MM9905 12/27/2011 0.000 81,545.44 81,545.44 81,545.44 81,545.44 N/A 1 0.15 Sub Total / Average Cash 0.000 3,358,914.11 3,358,914.11 3,358,914.11 3,358,914.11 1 0.00 6.11 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,900.40 6/16/2026 532 414.43 0.45 Ally Bk Sandy UT 3.4 8/4/2025 02007GXF5 8/4/2022 3.400 245,000.00 245,000.00 245,000.00 243,821.55 8/4/2025 216 3,400.47 0.45 Amerant Bank 4.65 9/8/2028 02357QCF2 9/8/2023 4.650 249,000.00 249,000.00 249,000.00 254,510.37 9/8/2028 1,347 729.60 0.45 AMERASIA BK FLUSHING NY 4 2/15/2029 02357PAG4 2/15/2024 4.000 248,000.00 248,000.00 248,000.00 247,972.72 2/15/2029 1,507 434.85 0.45 American Express Natl 3 5/4/2027 02589ACK6 4/30/2022 3.000 245,000.00 245,000.00 245,000.00 239,494.85 5/4/2027 854 1,147.81 0.45 Bank Hapoalim 0.95 7/23/2026 06251A2Y5 7/23/2021 0.950 245,000.00 245,000.00 245,000.00 233,541.35 7/23/2026 569 1,026.65 0.45 Bank of Belleville 4 6/15/2027 06063PDD4 12/15/2022 4.000 249,000.00 249,000.00 249,000.00 248,930.28 6/15/2027 896 436.60 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 235,636.10 3/31/2026 455 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 250,439.00 3/17/2028 1,172 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 248,096.76 9/7/2028 1,346 3,459.45 0.44 Bridgewater Bk 4.8 3/29/2028 108622NK3 3/29/2023 4.800 245,000.00 245,000.00 245,000.00 250,926.55 3/29/2028 1,184 64.44 0.45 CalPrivate Bk La Jolla 4 9/23/2027-23 13135NAS9 9/28/2022 4.400 249,000.00 244,545.39 246,563.54 248,950.20 9/23/2027 996 221.33 0.45 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 243,721.10 3/17/2025 76 1,280.71 0.45 Carter Bank & Trust 3.8 9/13/2029 146102BB3 9/13/2024 3.800 249,000.00 249,000.00 249,000.00 246,841.17 9/13/2029 1,717 466.62 0.45 Celtic Bank 4.6 9/19/2028 15118RJ32 9/19/2023 4.600 249,000.00 249,000.00 249,000.00 254,124.42 9/19/2028 1,358 376.57 0.45 Central Fed Savings 4.5 9/14/2028 15347VAC5 9/14/2023 4.500 249,000.00 249,000.00 249,000.00 253,250.43 9/14/2028 1,353 521.88 0.45 CIBC Bank USA 4.5 5/25/2028 12547CBN7 5/25/2023 4.500 244,000.00 244,000.00 244,000.00 247,806.40 5/25/2028 1,241 1,082.96 0.44 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,559.12 2/16/2029 1,508 392.38 0.45 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,751.75 11/24/2025 328 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 247,934.40 10/27/2028 1,396 2,115.62 0.44 Discover Bk 4.5 7/24/2028 2546736R2 7/26/2023 4.500 244,000.00 244,000.00 244,000.00 247,943.04 7/24/2028 1,301 4,752.99 0.44 Enerbank USA 0.55 9/25/2025 29278TRL6 9/25/2020 0.550 245,000.00 245,000.00 245,000.00 238,647.15 9/25/2025 268 22.15 0.45 Farmers BK 4.85 10/17/2028 30916PAA2 10/17/2023 4.850 248,000.00 248,000.00 248,000.00 256,196.40 10/17/2028 1,386 461.35 0.45 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,211 199.76 0.45 First Commercial Bank MS 0.3 3/31/2025 31984GFK0 3/7/2022 1.700 225,000.00 215,588.25 224,243.70 222,741.00 3/31/2025 90 1.85 0.41 First Finl Bk3.3 8/2/2027 32022RSG3 8/1/2022 3.300 245,000.00 245,000.00 245,000.00 240,756.60 8/2/2027 944 664.52 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 256,794.08 10/31/2028 1,400 1,019.18 0.45 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 243,929.35 2/28/2025 59 32.22 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 251,487.60 10/30/2028 1,399 0.00 0.45 First Premier Bank 3.65 9/26/2029 33610RVT7 9/26/2024 3.650 245,000.00 245,000.00 245,000.00 241,298.05 9/26/2029 1,730 2,352.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 245,333.20 8/8/2025 220 679.29 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 251,082.18 10/31/2028 1,400 2,010.24 0.44 Goldman Sachs Bk 1 7/28/2026 38149MXK4 7/28/2021 1.000 245,000.00 245,000.00 245,000.00 233,369.85 7/28/2026 574 1,047.12 0.45 Hershey State Banl 3.65 9/26/2028 427883AV5 9/26/2024 3.650 240,000.00 240,000.00 240,000.00 237,062.40 9/26/2028 1,365 120.00 0.44 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,944.85 7/29/2027 940 46.99 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 246,213.69 8/2/2027 944 702.32 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 252,306.72 2/28/2029 1,520 89.03 0.45 Medallion Bk Salt 4.4 7/31/2028 58404DSW2 7/31/2023 4.400 245,000.00 245,000.00 245,000.00 248,265.85 7/31/2028 1,308 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 254,133.60 11/6/2029 1,771 813.87 0.45 Morgan Stanley Bank Step 11/28/2027 61765QP52 9/2/2021 1.004 249,000.00 249,000.00 249,000.00 228,868.35 11/28/2027 1,062 225.12 0.45 MORGAN STANLEY PRIVATE BK 5.05 11/8/2028 61768EE82 11/8/2023 5.050 243,000.00 243,000.00 243,000.00 251,986.14 11/8/2028 1,408 1,781.89 0.44 NORTHEAST BK LEWISTON 3.7 9/23/2027 66405SFA3 9/23/2024 3.700 245,000.00 245,000.00 245,000.00 243,059.60 9/23/2027 996 2,458.73 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 248,972.61 1/29/2029 1,490 0.00 0.45 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,812.55 9/15/2027 988 375.89 0.45 Savibank 4.05 1/19/2027 80517LAC5 1/18/2023 4.050 249,000.00 249,000.00 249,000.00 249,181.77 1/19/2027 749 359.17 0.45 Schuyler Svgs Bk 4.35 7/27/2028 80832MAA5 7/27/2023 4.350 244,000.00 244,000.00 244,000.00 246,693.76 7/27/2028 1,304 4,565.47 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 251,849.48 10/17/2028 1,386 2,431.64 0.44 Synchrony Bank 0.9 8/6/2026 87165GD58 8/6/2021 0.900 248,000.00 248,000.00 248,000.00 236,482.88 8/6/2026 583 898.92 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 240,619.40 8/19/2027 961 2,968.19 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 233,690.80 7/15/2026 561 1,077.66 0.45 UBS Bk USA 4.4 7/26/2028 90355GEX0 7/26/2023 4.400 245,000.00 245,000.00 245,000.00 248,226.65 7/26/2028 1,303 147.67 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 247,932.65 3/22/2028 1,177 265.81 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 253,001.43 6/21/2028 1,268 306.99 0.45 Valley Central 4 4/28/2028 91944RAZ1 4/28/2023 4.000 249,000.00 249,000.00 249,000.00 248,972.61 4/28/2028 1,214 81.86 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 241,866.45 8/26/2027 968 117.47 0.45 Sub Total / Average Certificate Of Deposit 3.681 13,510,000.00 13,496,133.64 13,506,807.24 13,508,971.34 1,044 55,247.34 24.56 FAMC 4.17 5/24/2029 31422XYY2 1/19/2024 4.580 325,000.00 318,724.25 319,839.87 319,202.00 5/24/2029 1,605 1,392.90 0.59 Sub Total / Average FAMC Bond 4.580 325,000.00 318,724.25 319,839.87 319,202.00 1,605 1,392.90 0.59 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 499,955.00 12/22/2027 1,086 599.18 0.91 FFCB 0.69 7/22/2025-21 3133ELX33 4/15/2021 0.750 600,000.00 598,488.00 599,803.12 588,264.00 7/22/2025 203 1,828.50 1.09 FFCB 0.72 10/27/2026-21 3133EMES7 6/18/2021 1.000 500,000.00 492,715.00 497,524.51 468,485.00 10/27/2026 665 640.00 0.91 FFCB 0.74 11/24/2026-21 3133EMHC9 4/14/2021 1.053 450,000.00 442,350.00 447,413.93 420,696.00 11/24/2026 693 342.25 0.82 FFCB 1.26 10/15/2030-24 3133EMDG4 9/13/2024 3.700 500,000.00 434,025.00 437,259.94 415,200.00 10/15/2030 2,114 1,330.00 0.91 FFCB 1.45 6/11/2030-24 3133ELH31 9/13/2024 3.620 500,000.00 444,170.00 447,071.99 423,840.00 6/11/2030 1,988 402.78 0.91 FFCB 2.62 11/17/2025 3133EHJR5 9/24/2021 0.810 500,000.00 536,830.00 507,803.58 492,705.00 11/17/2025 321 1,601.11 0.91 FFCB 2.87 2/25/2030 3133ENPL8 9/9/2024 3.685 1,000,000.00 960,000.00 962,265.66 921,820.00 2/25/2030 1,882 10,045.00 1.82 FFCB 3.05 5/18/2029 3133ENXB1 1/19/2024 4.030 325,000.00 309,845.25 312,547.56 307,378.50 5/18/2029 1,599 1,183.99 0.59 FFCB 4.5 12/22/2025 3133EPQ81 12/29/2023 4.210 1,000,000.00 1,005,440.00 1,002,674.92 1,002,340.00 12/22/2025 356 1,125.00 1.82 Sub Total / Average FFCB Bond 2.915 5,875,000.00 5,723,863.25 5,714,365.21 5,540,683.50 1,069 19,097.81 10.68 City of Prior Lake Portfolio Holdings Investment Portfolio - by Security Type As of 12/31/2024 Cash Certificate Of Deposit FAMC Bond FFCB Bond FHLB 1 12/30/2026-21 3130ANY87 10/20/2021 1.205 500,000.00 494,850.00 498,020.90 468,080.00 12/30/2026 729 0.00 0.91 FHLB 1.25 11/10/2026-22 3130APLR4 11/10/2021 1.250 450,000.00 450,000.00 450,000.00 425,236.50 11/10/2026 679 796.87 0.82 FHLB 1.35 2/18/2031-24 3130AKZS8 9/13/2024 3.770 500,000.00 430,995.00 434,197.02 408,920.00 2/18/2031 2,240 243.75 0.91 FHLB 1.875 12/10/2031-25 3130ALJN5 12/30/2024 4.550 500,000.00 421,115.00 421,146.11 414,075.00 12/10/2031 2,535 2,890.62 0.91 FHLB 2.375 8/15/2029 3130AGVG7 2/12/2024 4.310 270,000.00 244,620.00 248,696.45 245,146.50 8/15/2029 1,688 2,422.50 0.49 FHLB 3 4/20/2026 3130ARGN5 12/29/2023 4.350 1,000,000.00 970,620.00 983,445.43 982,490.00 4/20/2026 475 5,916.67 1.82 FHLB Step 12/15/2025-21 3130AKJ72 4/13/2021 0.894 500,000.00 497,500.00 499,488.87 487,885.00 12/15/2025 349 333.33 0.91 FHLN 5159508 1.25 10/16/2026-21 3130ALW83 4/16/2021 1.250 216,666.67 216,666.67 216,666.67 205,285.17 10/16/2026 654 564.24 0.39 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 953,480.00 7/22/2026 568 5,300.00 1.82 Sub Total / Average FHLB Bond 2.555 4,936,666.67 4,726,366.67 4,751,661.45 4,590,598.17 987 18,467.98 8.98 League of Minnesota Cities - 4M Fund LGIP LGIP5101M 11/30/2010 4.502 4,839,988.92 4,839,988.92 4,839,988.92 4,839,988.92 N/A 1 8.80 League of Minnesota Cities - 4M Plus Fund LGIP LGIP5101MP 11/30/2010 4.515 5,273,438.33 5,273,438.33 5,273,438.33 5,273,438.33 N/A 1 9.59 League of Minnesota Cities LGIP LGIP5211M 7/24/2024 4.502 729,046.45 729,046.45 729,046.45 729,046.45 N/A 1 1.33 Sub Total / Average Local Government Investment Pool 4.508 10,842,473.70 10,842,473.70 10,842,473.70 10,842,473.70 1 0.00 19.71 AUSTIN TEX CMNTY COLLEGE 1.78 2/1/2030 052404QL7 9/11/2024 3.700 500,000.00 453,475.00 456,097.79 432,755.00 2/1/2030 1,858 3,708.33 0.91 Cabot-Las Positas 1.287 8/1/2027 15722TJS1 4/28/2022 3.500 550,000.00 491,991.50 521,524.20 507,793.00 8/1/2027 943 2,949.38 1.00 California St 2.5 10/1/2029 13063DRE0 8/12/2024 4.100 500,000.00 463,270.00 466,030.62 455,655.00 10/1/2029 1,735 3,125.00 0.91 Cecil Cnty MD 1.05 11/1/2026 1498433N2 9/23/2021 0.970 500,000.00 501,985.00 500,713.11 470,635.00 11/1/2026 670 875.00 0.91 Central Cmnty Sch 2 3/1/2026 153135FJ2 3/4/2021 0.700 300,000.00 319,098.00 304,452.36 292,137.00 3/1/2026 425 2,000.00 0.55 Colorado HSG & FIN 6 11/1/2029 19648G-MF-6 9/11/2024 4.253 1,000,000.00 1,079,960.00 1,075,231.41 1,051,670.00 11/1/2029 1,766 10,000.00 1.82 Enfield Conn Taxable 1.39 8/1/2027 292749UK2 4/6/2022 3.000 335,000.00 308,658.95 322,215.85 309,958.75 8/1/2027 943 1,940.21 0.61 Falmouth ME Taxable 3 10/15/2025 306783NF4 10/15/2021 0.800 340,000.00 369,386.20 345,792.76 336,606.80 10/15/2025 288 2,153.33 0.62 Franklin Twp 1.623 2/1/2029 355064KL9 10/4/2023 5.350 250,000.00 207,310.00 217,264.42 222,097.50 2/1/2029 1,493 1,690.62 0.45 Goose Creek Tex 4.5 2/15/2027 382604Z25 11/3/2022 4.700 500,000.00 496,125.00 498,078.59 501,510.00 2/15/2027 776 8,500.00 0.91 Hawaii St 1.892 10/1/2029 419792B47 8/14/2024 3.901 435,000.00 394,710.30 397,698.70 385,257.75 10/1/2029 1,735 2,057.55 0.79 Hawaii St GO Ref 2.802 10/1/2027-26 419792KL9 7/28/2022 3.350 100,000.00 97,413.00 98,626.47 95,837.00 10/1/2027 1,004 700.50 0.18 Hawaii St Taxable 1.033 8/1/2025 419792F92 10/12/2021 0.950 300,000.00 300,924.00 300,141.69 294,504.00 8/1/2025 213 1,291.25 0.55 Indiana Bond Bank 3.326 7/15/2025 45462TER9 3/26/2021 0.900 240,000.00 264,516.00 243,056.70 238,682.40 7/15/2025 196 3,680.77 0.44 KENNEBUNKPORT ME 5 10/1/2029 489299BK2 10/1/2024 3.700 295,000.00 312,357.80 311,492.76 300,723.00 10/1/2029 1,735 3,687.50 0.54 Liberty Center Ohio 0 11/1/2025 530336DV5 8/18/2020 1.051 215,000.00 203,589.95 213,169.35 207,432.00 11/1/2025 305 0.00 0.39 Mankato Minn ISD 0.7 2/1/2025 563690RP3 10/22/2020 0.700 300,000.00 300,000.00 300,000.00 299,127.00 2/1/2025 32 875.00 0.55 Mason & Kitsap Cntys 1.583 12/1/2028 575181HB1 5/19/2023 4.150 445,000.00 389,032.35 405,410.43 396,753.10 12/1/2028 1,431 587.03 0.81 Massachusetts St 0.986 11/1/2026 57582RK96 6/30/2021 1.000 500,000.00 499,635.00 499,874.59 470,835.00 11/1/2026 670 821.67 0.91 Milwaukee Cnty Wis 2 12/1/2026 6022453V2 11/23/2021 1.300 500,000.00 516,960.00 506,473.28 478,075.00 12/1/2026 700 833.33 0.91 Minnesota St 7 11/1/2028 604146GK0 11/8/2023 5.251 250,000.00 268,952.50 264,589.26 271,147.50 11/1/2028 1,401 2,916.67 0.45 New York NY 1.92 11/1/2029 64971XUUO 9/25/2023 5.150 275,000.00 228,998.00 238,553.37 241,661.75 11/1/2029 1,766 880.00 0.50 New York NY 3.7 8/1/2029-25 64966LYZ8 11/24/2023 5.100 250,000.00 232,897.50 236,215.90 239,855.00 8/1/2029 1,674 3,854.17 0.45 New York State TFA 4.2 11/1/2028-23 64971Q7N7 9/7/2023 4.850 250,000.00 242,657.50 244,534.09 245,947.50 11/1/2028 1,401 1,750.00 0.45 Orono ME Taxable 5 11/1/2025 687085DR8 10/29/2020 1.000 330,000.00 394,287.30 340,720.41 331,626.90 11/1/2025 305 2,750.00 0.60 Pelican Rapids Minn 0.8 2/1/2025 705863HR2 12/17/2020 0.700 525,000.00 527,126.25 525,045.15 523,451.25 2/1/2025 32 1,750.00 0.95 Pennsylvania St Univ 1.645 9/1/2025 709235S48 12/6/2021 1.120 250,000.00 254,787.50 250,855.79 245,600.00 9/1/2025 244 1,370.83 0.45 Roanoke VA Taxable 2 2/1/2025 770078BD4 5/14/2020 1.250 300,000.00 310,266.00 300,190.55 299,415.00 2/1/2025 32 2,500.00 0.55 SIOUX FALLS S D 3.65 11/15/2030-28 829594ML1 9/18/2024 3.720 500,000.00 498,070.00 498,159.25 472,405.00 11/15/2030 2,145 2,331.94 0.91 Springboro Ohio 5 12/1/2027 85023MAF2 7/12/2022 4.002 245,000.00 256,755.10 251,361.37 248,123.75 12/1/2027 1,065 1,020.83 0.45 St Louis Park Minn 4.5 2/1/2027 791740V34 9/7/2022 3.345 190,000.00 198,863.50 194,200.24 190,136.80 2/1/2027 762 3,562.50 0.35 TARRANT REGL WTR DIST TEX 1.45 9/1/2029 876448EB3 9/11/2024 3.650 500,000.00 450,390.00 453,422.33 435,050.00 9/1/2029 1,705 2,416.67 0.91 Toledo Ohio City Sch 5 12/1/2027 889294RT3 9/28/2022 4.520 100,000.00 102,186.00 101,231.79 101,550.00 12/1/2027 1,065 416.67 0.18 Trussville AL 0.822 10/1/2025 898242ND0 8/25/2020 0.710 300,000.00 301,677.00 300,246.64 292,272.00 10/1/2025 274 616.50 0.55 Waukesha Wis 1.2 10/1/2027 943080UZ2 9/1/2022 3.660 375,000.00 332,557.50 352,040.80 343,275.00 10/1/2027 1,004 1,125.00 0.68 Wicomico Cnty MD 2 12/1/2026 967546BA9 5/13/2022 3.450 380,000.00 356,975.80 370,308.51 363,458.60 12/1/2026 700 633.33 0.69 Winthrop Minn 2 2/1/2029-28 976367PN6 11/24/2023 5.100 225,000.00 193,556.25 200,239.71 201,066.75 2/1/2029 1,493 1,875.00 0.41 Sub Total / Average Municipal Bond 2.933 13,350,000.00 13,121,401.75 13,105,260.24 12,794,087.10 1,040 83,246.58 24.27 T-Note 0.375 11/30/2025 91282CAZ4 9/24/2021 0.780 300,000.00 295,008.00 298,908.82 289,695.00 11/30/2025 334 95.81 0.55 T-Note 0.625 11/30/2027 91282CAY7 5/5/2022 3.040 500,000.00 438,535.00 467,863.02 450,275.00 11/30/2027 1,064 266.14 0.91 T-Note 2.5 2/28/2026 9128286F2 12/21/2023 4.220 1,000,000.00 964,310.91 981,084.78 980,350.00 2/28/2026 424 8,425.41 1.82 T-Note 4.625 3/15/2026 91282CGR6 12/21/2023 4.230 1,000,000.00 1,008,280.00 1,004,460.02 1,004,300.00 3/15/2026 439 13,670.58 1.82 Sub Total / Average Treasury Note 3.644 2,800,000.00 2,706,133.91 2,752,316.64 2,724,620.00 534 22,457.94 5.09 Total / Average 3.258 54,998,054.48 54,294,011.28 54,351,638.46 53,679,549.92 748 199,910.55 100 Local Government Investment Pool Municipal Bond Treasury Note FHLB Bond YTM @ Cost Cost Value Days to Maturity % of Portfolio Cash - 3,358,914 1 6.12% Certificate of Deposit 3.681 13,496,134 1,044 24.56% FAMC Bond 4.580 318,724 1,605 0.59% FFCB Bond 2.915 5,723,863 1,069 10.68% FHLB Bond 2.555 4,726,367 987 8.98% LGIP 4.508 10,842,474 1 19.71% Municipal Bond 2.933 13,121,402 1,040 24.27% Treasury Note 3.644 2,706,134 534 5.09% Total / Average 3.258 54,294,011 748 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio - Diversification, by Security Type December 31, 2024 Description City of Prior Lake - Quarterly Investment Report Change from one 12/31/2023 3/31/2024 6/30/2024 9/30/2024 12/31/2024 year prior Market Value 14,734,627 9,627,932 15,582,477 11,373,705 14,201,388 (533,239) 1 1 1 1 1 0 4.00% 4.08% 3.99% 4.48% 3.44%-0.55% Fixed Income Assets 38,012,573 39,663,383 38,300,153 41,950,294 40,092,623 2,080,050 36,809,204 38,539,677 37,203,231 41,710,847 39,478,162 2,668,958 963 923 862 1,015 1,009 46 903 868 817 940 931 28 2.78% 2.85% 2.89% 3.10% 3.17%0.39% Total Portfolio Value 52,747,201 49,291,314 53,882,630 53,323,998 54,294,011 1,546,811 51,543,831 48,167,609 52,785,708 53,084,551 53,679,550 2,135,719 162,916 214,228 160,753 229,318 199,911 36,994 -1,203,369 -1,123,706 -1,096,922 -239,447 -614,461 588,908 695 744 615 801 748 53 652 699 582 742 691 39 3.12% 3.09% 3.21% 3.39% 3.24% 0.12% BENCHMARK 90 Day T-Bill 5.40% 5.46% 5.48% 4.73% 4.37% -1.03% 5.26%5.38%5.33%4.38%4.24%-1.02% 4.79%5.03%5.09%3.98%4.16%-0.63% 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