Loading...
HomeMy WebLinkAbout05(D) - Approval of 3rd Quarter 2024 Investment Report ReportYTM @ Cost Cost Value Days to Maturity % of Portfolio 0-1 Month 4.477 11,373,705 1 21.09% 1-3 Months 2.307 2,591,143 55 4.73% 3-6 Months 1.106 1,627,392 135 2.99% 6-9 Months 1.700 215,588 182 0.42% 9-12 Months 1.439 2,455,393 318 4.50% 1-2 Years 2.560 9,286,350 524 17.07% 2-3 Years 2.603 8,604,292 904 16.24% 3-4 Years 4.196 5,480,476 1,310 10.25% 4-5 Years 4.421 6,914,966 1,639 13.40% 5-10 Years 3.944 4,774,693 2,032 9.31% Total / Average 3.408 53,323,998 801 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio - Diversification, by Maturity Range September 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 808,344.64 808,344.64 808,344.64 808,344.64 N/A 1 1.50 Morgan Stanley Cash CASH5089 12/31/2010 0.000 519,754.92 519,754.92 519,754.92 519,754.92 N/A 1 0.96 Oppenheimer Cash MM9905 12/27/2011 0.000 8,200.45 8,200.45 8,200.45 8,200.45 N/A 1 0.02 Sub Total / Average Cash 0.000 1,336,300.01 1,336,300.01 1,336,300.01 1,336,300.01 1 0.00 2.48 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,849.09 6/16/2026 624 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 243,414.85 8/4/2025 308 1,300.85 0.45 Amerant Bank 4.65 9/8/2028 02357QCF2 9/8/2023 4.650 249,000.00 249,000.00 249,000.00 258,920.16 9/8/2028 1,439 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 252,129.20 2/15/2029 1,599 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 240,109.80 5/4/2027 946 3,000.41 0.45 Bank Hapoalim 0.95 7/23/2026 06251A2Y5 7/23/2021 0.950 245,000.00 245,000.00 245,000.00 232,691.20 7/23/2026 661 439.99 0.45 Bank of Belleville 4 6/15/2027 06063PDD4 12/15/2022 4.000 249,000.00 249,000.00 249,000.00 250,279.86 6/15/2027 988 409.32 0.46 BankUnited Savings Miami 0.95 3/31/2026 066519QT9 3/31/2021 0.950 245,000.00 245,000.00 245,000.00 234,572.80 3/31/2026 547 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 253,388.80 3/17/2028 1,264 414.49 0.45 BNY Mellon4.5 9/7/2028 05584CJJ6 9/7/2023 4.500 244,000.00 244,000.00 244,000.00 252,278.92 9/7/2028 1,438 691.89 0.45 Bridgewater Bk 4.8 3/29/2028 108622NK3 3/29/2023 4.800 245,000.00 245,000.00 245,000.00 254,023.35 3/29/2028 1,276 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,338.49 249,032.37 9/23/2027 1,088 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 241,959.55 3/17/2025 168 169.15 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 250,740.51 9/13/2029 1,809 440.70 0.46 Celtic Bank 4.6 9/19/2028 15118RJ32 9/19/2023 4.600 249,000.00 249,000.00 249,000.00 258,601.44 9/19/2028 1,450 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 257,620.38 9/14/2028 1,445 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 251,015.00 5/25/2028 1,333 3,850.52 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 250,623.84 2/16/2029 1,600 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 247,641.10 11/24/2025 420 4,275.75 0.45 Customers Bk 4.95 10/27/2028 23204HPE2 10/27/2023 4.950 240,000.00 240,000.00 240,000.00 252,465.60 10/27/2028 1,488 5,077.48 0.45 Discover Bk 4.5 7/24/2028 2546736R2 7/26/2023 4.500 244,000.00 244,000.00 244,000.00 251,732.36 7/24/2028 1,393 1,985.42 0.45 Enerbank USA 0.55 9/25/2025 29278TRL6 9/25/2020 0.550 245,000.00 245,000.00 245,000.00 236,919.90 9/25/2025 360 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 244,255.20 11/8/2024 39 265.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 260,972.88 10/17/2028 1,478 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,213.28 4/25/2028 1,303 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 223,470.59 220,340.25 3/31/2025 182 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 241,729.25 8/2/2027 1,036 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 261,595.36 10/31/2028 1,492 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 242,047.75 2/28/2025 151 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 256,078.90 10/30/2028 1,491 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 244,982.85 9/26/2029 1,822 98.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,580.65 8/8/2025 312 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 255,609.27 10/31/2028 1,492 5,042.08 0.45 Goldman Sachs Bk 1 7/28/2026 38149MXK4 7/28/2021 1.000 245,000.00 245,000.00 245,000.00 232,519.70 7/28/2026 666 429.59 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 240,873.60 9/26/2028 1,457 96.00 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 243,030.20 7/29/2027 1,032 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 247,349.13 8/2/2027 1,036 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 245,066.15 12/9/2024 70 3,782.40 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 256,691.61 2/28/2029 1,612 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 252,087.85 7/31/2028 1,400 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 258,661.20 11/6/2029 1,863 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 228,918.15 11/28/2027 1,154 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 256,571.55 11/8/2028 1,500 4,874.98 0.45 NORTHEAST BK LEWISTON 3.7 9/23/2027 66405SFA3 9/23/2024 3.700 245,000.00 245,000.00 245,000.00 244,289.50 9/23/2027 1,088 173.85 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 253,155.81 1/29/2029 1,582 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 242,946.90 9/15/2027 1,080 352.40 0.45 Savibank 4.05 1/19/2027 80517LAC5 1/18/2023 4.050 249,000.00 249,000.00 249,000.00 250,396.89 1/19/2027 841 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 250,419.64 7/27/2028 1,396 1,890.16 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,882.40 12/9/2024 70 3,492.16 0.45 Southern First Bank NA 4.85 10/17/2028 84287PJB9 11/7/2023 4.850 244,000.00 244,000.00 244,000.00 256,456.20 10/17/2028 1,478 5,382.04 0.45 Synchrony Bank 0.9 8/6/2026 87165GD58 8/6/2021 0.900 248,000.00 248,000.00 248,000.00 235,709.12 8/6/2026 675 336.33 0.46 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,574.90 8/19/2027 1,053 930.33 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 232,821.05 7/15/2026 653 491.01 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 252,038.85 7/26/2028 1,395 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 250,742.80 3/22/2028 1,269 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 256,639.32 6/21/2028 1,360 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 251,873.46 4/28/2028 1,306 54.58 0.46 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,981.20 8/26/2027 1,060 93.97 0.45 Sub Total / Average Certificate Of Deposit 3.686 14,240,000.00 14,226,133.64 14,235,809.08 14,355,112.90 1,080 58,404.25 26.41 FAMC 4.17 5/24/2029 31422XYY2 1/19/2024 4.580 325,000.00 318,724.25 319,544.08 324,109.50 5/24/2029 1,697 4,743.38 0.60 Sub Total / Average FAMC Bond 4.580 325,000.00 318,724.25 319,544.08 324,109.50 1,697 4,743.38 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 504,025.00 12/22/2027 1,178 6,657.53 0.93 FFCB 0.69 7/22/2025-21 3133ELX33 4/15/2021 0.750 600,000.00 598,488.00 599,713.89 582,840.00 7/22/2025 295 782.00 1.11 FFCB 0.72 10/27/2026-21 3133EMES7 6/18/2021 1.000 500,000.00 492,715.00 497,182.04 469,375.00 10/27/2026 757 1,530.00 0.93 FFCB 0.74 11/24/2026-21 3133EMHC9 4/14/2021 1.053 450,000.00 442,350.00 447,070.61 421,600.50 11/24/2026 785 1,165.50 0.83 FFCB 1.26 10/15/2030-24 3133EMDG4 9/13/2024 3.700 500,000.00 434,025.00 434,529.53 427,600.00 10/15/2030 2,206 2,887.50 0.93 FFCB 1.45 6/11/2030-24 3133ELH31 9/13/2024 3.620 500,000.00 444,170.00 444,622.60 437,455.00 6/11/2030 2,080 2,195.14 0.93 FFCB 2.62 11/17/2025 3133EHJR5 9/24/2021 0.810 500,000.00 536,830.00 510,040.13 494,115.00 11/17/2025 413 4,839.72 0.93 FFCB 2.87 2/25/2030 3133ENPL8 9/9/2024 3.685 1,000,000.00 960,000.00 960,421.05 949,320.00 2/25/2030 1,974 2,790.28 1.85 City of Prior Lake Portfolio Holdings Investment Portfolio - by Security Type As of 9/30/2024 Cash Certificate Of Deposit FAMC Bond FFCB Bond FFCB 3.05 5/18/2029 3133ENXB1 1/19/2024 4.030 325,000.00 309,845.25 311,831.10 316,888.00 5/18/2029 1,691 3,634.58 0.60 FFCB 4.5 12/22/2025 3133EPQ81 12/29/2023 4.210 1,000,000.00 1,005,440.00 1,003,366.19 1,006,790.00 12/22/2025 448 12,250.00 1.85 Sub Total / Average FFCB Bond 2.915 5,875,000.00 5,723,863.25 5,708,777.14 5,610,008.50 1,161 38,732.25 10.89 FHLB 1 12/30/2026-21 3130ANY87 10/20/2021 1.205 500,000.00 494,850.00 497,771.14 469,995.00 12/30/2026 821 1,250.00 0.93 FHLB 1.25 11/10/2026-22 3130APLR4 11/10/2021 1.250 450,000.00 450,000.00 450,000.00 426,955.50 11/10/2026 771 2,187.50 0.83 FHLB 1.35 2/18/2031-24 3130AKZS8 9/13/2024 3.770 500,000.00 430,995.00 431,494.40 424,975.00 2/18/2031 2,332 225.00 0.93 FHLB 2.375 8/15/2029 3130AGVG7 2/12/2024 4.310 270,000.00 244,620.00 247,535.36 252,358.20 8/15/2029 1,780 801.56 0.50 FHLB 3 4/20/2026 3130ARGN5 12/29/2023 4.350 1,000,000.00 970,620.00 980,239.07 986,270.00 4/20/2026 567 13,333.33 1.85 FHLB Step 12/15/2025-21 3130AKJ72 4/13/2021 0.894 500,000.00 497,500.00 499,354.13 486,580.00 12/15/2025 441 1,640.62 0.93 FHLN 5159508 1.25 10/16/2026-21 3130ALW83 4/16/2021 1.250 216,666.67 216,666.67 216,666.67 205,917.84 10/16/2026 746 1,233.80 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 956,490.00 7/22/2026 660 2,266.67 1.85 Sub Total / Average FHLB Bond 2.330 4,436,666.67 4,305,251.67 4,323,060.77 4,209,541.54 905 22,938.48 8.23 FHLMC 0.5 12/9/2024 3134GWA71 9/9/2020 0.500 200,000.00 200,000.00 200,000.00 198,372.00 12/9/2024 70 308.33 0.37 Sub Total / Average FHLMC Bond 0.500 200,000.00 200,000.00 200,000.00 198,372.00 70 308.33 0.37 League of Minnesota Cities - 4M Fund LGIP LGIP5101M 11/30/2010 5.063 1,807,915.66 1,807,915.66 1,807,915.66 1,807,915.66 N/A 1 3.35 League of Minnesota Cities - 4M Plus Fund LGIP LGIP5101MP 11/30/2010 5.077 7,013,844.20 7,013,844.20 7,013,844.20 7,013,844.20 N/A 1 13.01 League of Minnesota Cities LGIP LGIP5211M 7/24/2024 5.063 1,215,644.72 1,215,644.72 1,215,644.72 1,215,644.72 N/A 1 2.25 Sub Total / Average Local Government Investment Pool 5.073 10,037,404.58 10,037,404.58 10,037,404.58 10,037,404.58 1 0.00 18.61 Allen Park MI Public Sch Dist 2 11/2/2024 018033HR4 7/30/2020 0.751 290,000.00 305,140.90 290,321.11 289,454.80 11/2/2024 33 2,400.56 0.54 AUSTIN TEX CMNTY COLLEGE 1.78 2/1/2030 052404QL7 9/11/2024 3.700 500,000.00 453,475.00 453,923.95 448,560.00 2/1/2030 1,950 1,458.61 0.93 Cabot-Las Positas 1.287 8/1/2027 15722TJS1 4/28/2022 3.500 550,000.00 491,991.50 518,746.07 513,254.50 8/1/2027 1,035 1,160.09 1.02 California St 2.5 10/1/2029 13063DRE0 8/12/2024 4.100 500,000.00 463,270.00 464,229.37 470,270.00 10/1/2029 1,827 6,215.28 0.93 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 284,447.10 11/1/2024 32 2,359.17 0.53 Cecil Cnty MD 1.05 11/1/2026 1498433N2 9/23/2021 0.970 500,000.00 501,985.00 500,811.03 472,490.00 11/1/2026 762 2,172.92 0.93 Central Cmnty Sch 2 3/1/2026 153135FJ2 3/4/2021 0.700 300,000.00 319,098.00 305,416.16 291,606.00 3/1/2026 517 483.33 0.56 Colorado HSG & FIN 6 11/1/2029 19648G-MF-6 9/11/2024 4.253 1,000,000.00 1,079,960.00 1,079,150.60 1,078,900.00 11/1/2029 1,858 3,166.67 1.85 Enfield Conn Taxable 1.39 8/1/2027 292749UK2 4/6/2022 3.000 335,000.00 308,658.95 320,968.61 313,057.50 8/1/2027 1,035 763.15 0.62 Falmouth ME Taxable 3 10/15/2025 306783NF4 10/15/2021 0.800 340,000.00 369,386.20 347,643.23 336,045.80 10/15/2025 380 4,675.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,037.93 473,266.25 12/1/2024 62 3,454.31 0.88 Franklin Twp 1.623 2/1/2029 355064KL9 10/4/2023 5.350 250,000.00 207,310.00 215,247.23 227,367.50 2/1/2029 1,585 664.98 0.46 Goose Creek Tex 4.5 2/15/2027 382604Z25 11/3/2022 4.700 500,000.00 496,125.00 497,850.80 508,685.00 2/15/2027 868 2,812.50 0.93 Hawaii St 1.892 10/1/2029 419792B47 8/14/2024 3.901 435,000.00 394,710.30 395,720.77 395,293.20 10/1/2029 1,827 4,092.24 0.81 Hawaii St GO Ref 2.802 10/1/2027-26 419792KL9 7/28/2022 3.350 100,000.00 97,413.00 98,500.61 97,077.00 10/1/2027 1,096 1,393.22 0.19 Hawaii St Taxable 1.033 8/1/2025 419792F92 10/12/2021 0.950 300,000.00 300,924.00 300,202.89 292,482.00 8/1/2025 305 507.89 0.56 Indiana Bond Bank 3.326 7/15/2025 45462TER9 3/26/2021 0.900 240,000.00 264,516.00 244,491.48 238,437.60 7/15/2025 288 1,663.00 0.45 Liberty Center Ohio 0 11/1/2025 530336DV5 8/18/2020 1.051 215,000.00 203,589.95 212,617.15 205,587.30 11/1/2025 397 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 296,568.00 2/1/2025 124 344.17 0.56 Mason & Kitsap Cntys 1.583 12/1/2028 575181HB1 5/19/2023 4.150 445,000.00 389,032.35 402,865.18 404,705.25 12/1/2028 1,523 2,328.55 0.83 Massachusetts St 0.986 11/1/2026 57582RK96 6/30/2021 1.000 500,000.00 499,635.00 499,857.37 472,525.00 11/1/2026 762 2,040.47 0.93 Milwaukee Cnty Wis 2 12/1/2026 6022453V2 11/23/2021 1.300 500,000.00 516,960.00 507,324.06 480,740.00 12/1/2026 792 3,305.56 0.93 Minnesota St 7 11/1/2028 604146GK0 11/8/2023 5.251 250,000.00 268,952.50 265,547.30 280,627.50 11/1/2028 1,493 7,243.06 0.46 New York NY 1.92 11/1/2029 64971XUUO 9/25/2023 5.150 275,000.00 228,998.00 236,654.68 248,402.00 11/1/2029 1,858 2,185.33 0.51 New York NY 3.7 8/1/2029-25 64966LYZ8 11/24/2023 5.100 250,000.00 232,897.50 235,458.35 246,745.00 8/1/2029 1,766 1,515.97 0.46 New York State TFA 4.2 11/1/2028-23 64971Q7N7 9/7/2023 4.850 250,000.00 242,657.50 244,175.16 250,030.00 11/1/2028 1,493 4,345.83 0.46 Northwest Local Sch District Hamilton & Butler 667712CG6 11/15/2019 2.169 370,000.00 389,010.60 370,639.53 369,408.00 12/1/2024 62 3,974.93 0.69 Orono ME Taxable 5 11/1/2025 687085DR8 10/29/2020 1.000 330,000.00 394,287.30 343,954.11 332,758.80 11/1/2025 397 6,829.17 0.61 Pelican Rapids Minn 0.8 2/1/2025 705863HR2 12/17/2020 0.700 525,000.00 527,126.25 525,174.95 519,277.50 2/1/2025 124 688.33 0.97 Pennsylvania St Univ 1.645 9/1/2025 709235S48 12/6/2021 1.120 250,000.00 254,787.50 251,178.46 244,380.00 9/1/2025 336 331.28 0.46 Roanoke VA Taxable 2 2/1/2025 770078BD4 5/14/2020 1.250 300,000.00 310,266.00 300,738.39 297,507.00 2/1/2025 124 983.33 0.56 SIOUX FALLS S D 3.65 11/15/2030-28 829594ML1 9/18/2024 3.720 500,000.00 498,070.00 498,080.30 491,755.00 11/15/2030 2,237 6,843.75 0.93 Springboro Ohio 5 12/1/2027 85023MAF2 7/12/2022 4.002 245,000.00 256,755.10 251,910.90 253,312.85 12/1/2027 1,157 4,049.31 0.45 St Louis Park Minn 4.5 2/1/2027 791740V34 9/7/2022 3.345 190,000.00 198,863.50 194,707.36 191,911.40 2/1/2027 854 1,401.25 0.35 TARRANT REGL WTR DIST TEX 1.45 9/1/2029 876448EB3 9/11/2024 3.650 500,000.00 450,390.00 450,909.05 447,625.00 9/1/2029 1,797 584.03 0.93 Toledo Ohio City Sch 5 12/1/2027 889294RT3 9/28/2022 4.520 100,000.00 102,186.00 101,338.20 103,100.00 12/1/2027 1,157 1,652.78 0.19 Trussville AL 0.822 10/1/2025 898242ND0 8/25/2020 0.710 300,000.00 301,677.00 300,329.46 290,109.00 10/1/2025 366 1,226.15 0.56 Waukesha Wis 1.2 10/1/2027 943080UZ2 9/1/2022 3.660 375,000.00 332,557.50 349,936.97 347,137.50 10/1/2027 1,096 2,237.50 0.70 Wauwatosa WI 3 12/1/2024-22 9435042U3 10/28/2021 2.014 200,000.00 205,880.00 200,322.62 199,564.00 12/1/2024 62 1,983.33 0.37 Wicomico Cnty MD 2 12/1/2026 967546BA9 5/13/2022 3.450 380,000.00 356,975.80 369,034.78 365,088.80 12/1/2026 792 2,512.22 0.70 Winthrop Minn 2 2/1/2029-28 976367PN6 11/24/2023 5.100 225,000.00 193,556.25 198,713.95 205,823.25 2/1/2029 1,585 737.50 0.42 Sub Total / Average Municipal Bond 2.800 14,675,000.00 14,470,186.95 14,404,730.12 14,275,382.40 999 98,786.72 27.21 T-Note 0.375 11/30/2025 91282CAZ4 9/24/2021 0.780 300,000.00 295,008.00 298,608.25 288,105.00 11/30/2025 426 375.00 0.56 T-Note 0.625 11/30/2027 91282CAY7 5/5/2022 3.040 500,000.00 438,535.00 465,084.26 455,995.00 11/30/2027 1,156 1,041.67 0.93 T-Note 2.5 2/28/2026 9128286F2 12/21/2023 4.220 1,000,000.00 964,310.91 976,980.54 982,310.00 2/28/2026 516 2,071.82 1.85 T-Note 4.625 3/15/2026 91282CGR6 12/21/2023 4.230 1,000,000.00 1,008,280.00 1,005,394.70 1,011,910.00 3/15/2026 531 1,916.44 1.85 Sub Total / Average Treasury Note 3.644 2,800,000.00 2,706,133.91 2,746,067.75 2,738,320.00 626 5,404.93 5.19 Total / Average 3.408 53,925,371.26 53,323,998.26 53,311,693.53 53,084,551.43 801 229,318.34 100 FHLMC Bond Local Government Investment Pool Municipal Bond Treasury Note FHLB Bond YTM @ Cost Cost Value Days to Maturity % of Portfolio Cash - 1,336,300 1 2.49% Certificate of Deposit 3.686 14,226,134 1,080 26.41% FAMC Bond 4.580 318,724 1,697 0.60% FFCB Bond 2.915 5,723,863 1,161 10.89% FHLB Bond 2.330 4,305,252 905 8.23% FHLMC Bond 0.500 200,000 70 0.37% LGIP 5.073 10,037,405 1 18.61% Municipal Bond 2.800 14,470,187 999 27.21% Treasury Note 3.644 2,706,134 626 5.19% Total / Average 3.408 53,323,998 801 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio - Diversification, by Security Type September 30, 2024 Description City of Prior Lake - Quarterly Investment Report Change from one 9/30/2023 12/31/2023 3/31/2024 6/30/2024 9/30/2024 year prior Market Value 18,176,651 14,734,627 9,627,932 15,582,477 11,373,705 (6,802,947) 1 1 1 1 1 0 4.89% 4.00% 4.08% 3.99% 4.48%-0.41% Fixed Income Assets 33,750,838 38,012,573 39,663,383 38,300,153 41,950,294 8,199,455 31,752,611 36,809,204 38,539,677 37,203,231 41,710,847 9,958,236 903 963 923 862 1,015 112 844 903 868 817 940 96 2.37% 2.78% 2.85% 2.89% 3.10%0.73% Total Portfolio Value 51,927,490 52,747,201 49,291,314 53,882,630 53,323,998 1,396,509 49,929,262 51,543,831 48,167,609 52,785,708 53,084,551 3,155,289 170,756 162,916 214,228 160,753 229,318 58,562 -1,998,228 -1,203,369 -1,123,706 -1,096,922 -239,447 1,758,781 587 695 744 615 801 214 549 652 699 582 742 193 3.25% 3.12% 3.09% 3.21% 3.39% 0.14% BENCHMARK 90 Day T-Bill 5.55% 5.40% 5.46% 5.48% 4.73% -0.82% 5.53%5.26%5.38%5.33%4.38%-1.15% 5.46%4.79%5.03%5.09%3.98%-1.48% 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 September 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