Loading...
HomeMy WebLinkAbout05(F) - Approval of 4th Quarter 2023 Investment Report ReportYTM @ Cost Cost Value Days to Maturity % of Portfolio 0-1 Month 3.996 14,734,627 1 27.83% 1-3 Months 0.570 216,380 32 0.38% 3-6 Months 1.801 1,363,230 137 2.53% 6-9 Months 2.089 2,447,925 228 4.65% 9-12 Months 2.226 3,081,142 320 5.74% 1-2 Years 1.687 7,845,415 596 14.53% 2-3 Years 2.210 9,711,447 937 18.46% 3-4 Years 3.628 5,933,631 1,320 11.54% 4-5 Years 4.640 6,305,642 1,693 11.99% 5-10 Years 5.112 1,107,762 2,010 2.35% Total / Average 3.120 52,747,201 695 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio - Diversification, by Maturity Range December 31, 2023 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 24,298.26 24,298.26 24,298.26 24,298.26 N/A 1 0.05 Morgan Stanley Cash CASH5089 12/31/2010 0.000 1,018,587.41 1,018,587.41 1,018,587.41 1,018,587.41 N/A 1 1.92 Oppenheimer Cash MM9905 12/27/2011 0.000 2,651,811.86 2,651,811.86 2,651,811.86 2,651,811.86 N/A 1 5.01 Sub Total / Average Cash 0.000 3,694,697.53 3,694,697.53 3,694,697.53 3,694,697.53 1 0.00 6.98 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 244,460.73 6/16/2026 898 414.43 0.47 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,220.45 8/4/2025 582 3,400.47 0.46 Amerant Bank 4.65 9/8/2028 02357QCF2 9/8/2023 4.650 249,000.00 249,000.00 249,000.00 251,016.90 9/8/2028 1,713 729.60 0.47 American Express Natl 3 5/4/2027 02589ACK6 4/30/2022 3.000 245,000.00 245,000.00 245,000.00 231,221.20 5/4/2027 1,220 1,147.81 0.46 Banc Calif Irvine 3.2 7/1/2024 05961SNS9 6/29/2022 3.200 245,000.00 245,000.00 245,000.00 242,723.95 7/1/2024 183 42.96 0.46 Bank Hapoalim 0.95 7/23/2026 06251A2Y5 7/23/2021 0.950 245,000.00 245,000.00 245,000.00 222,183.15 7/23/2026 935 1,026.65 0.46 Bank of Belleville 4 6/15/2027 06063PDD4 12/15/2022 4.000 249,000.00 249,000.00 249,000.00 242,568.33 6/15/2027 1,262 436.60 0.47 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 239,036.70 9/30/2024 274 12.08 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 224,851.20 3/31/2026 821 0.00 0.46 BMW Bk 4.75 3/17/2028 055180AW83 3/17/2023 4.750 245,000.00 245,000.00 245,000.00 246,097.60 3/17/2028 1,538 3,347.77 0.46 BNY Mellon4.5 9/7/2028 05584CJJ6 9/7/2023 4.500 244,000.00 244,000.00 244,000.00 244,370.88 9/7/2028 1,712 3,459.45 0.46 Bridgewater Bk 4.8 3/29/2028 108622NK3 3/29/2023 4.800 245,000.00 245,000.00 245,000.00 246,776.25 3/29/2028 1,550 64.44 0.46 CalPrivate Bk La Jolla 4 9/23/2027-23 13135NAS9 9/28/2022 4.400 249,000.00 244,545.39 245,668.22 242,568.33 9/23/2027 1,362 221.33 0.47 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 235,628.75 3/17/2025 442 1,280.71 0.46 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 242,428.03 8/14/2024 227 1,975.32 0.47 Celtic Bank 4.6 9/19/2028 15118RJ32 9/19/2023 4.600 249,000.00 249,000.00 249,000.00 250,611.03 9/19/2028 1,724 376.57 0.47 Central Fed Savings 4.5 9/14/2028 15347VAC5 9/14/2023 4.500 249,000.00 249,000.00 249,000.00 249,500.49 9/14/2028 1,719 521.88 0.47 CIBC Bank USA 4.5 5/25/2028 12547CBN7 5/25/2023 4.500 244,000.00 244,000.00 244,000.00 243,377.80 5/25/2028 1,607 1,082.96 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 245,463.05 11/24/2025 694 1,249.84 0.46 Customers Bk 4.95 10/27/2028 23204HPE2 10/27/2023 4.950 240,000.00 240,000.00 240,000.00 245,488.80 10/27/2028 1,762 2,115.62 0.45 Discover Bk 4.5 7/24/2028 2546736R2 7/26/2023 4.500 244,000.00 244,000.00 244,000.00 243,924.36 7/24/2028 1,667 4,752.99 0.46 Enerbank USA 0.55 9/25/2025 29278TRL6 9/25/2020 0.550 245,000.00 245,000.00 245,000.00 227,364.90 9/25/2025 634 22.15 0.46 Enterprise Bank & Trust 1.8 11/8/2024 29367SJQ8 11/8/2019 1.800 245,000.00 245,000.00 245,000.00 238,142.45 11/8/2024 313 277.89 0.46 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 239,110.20 9/27/2024 271 1,147.81 0.46 Farmers BK 4.85 10/17/2028 30916PAA2 10/17/2023 4.850 248,000.00 248,000.00 248,000.00 253,592.40 10/17/2028 1,752 461.35 0.47 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,218.24 4/25/2028 1,577 199.76 0.47 First Commercial Bank MS 0.3 3/31/2025 31984GFK0 3/7/2022 1.700 225,000.00 215,588.25 221,168.07 212,017.50 3/31/2025 456 1.85 0.42 First Finl Bk3.3 8/2/2027 32022RSG3 8/1/2022 3.300 245,000.00 245,000.00 245,000.00 233,034.20 8/2/2027 1,310 664.52 0.46 First National Bank/Dama 5 10/31/2028 32117BGJ1 10/31/2023 5.000 248,000.00 248,000.00 248,000.00 254,415.76 10/31/2028 1,766 1,019.18 0.47 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 235,337.20 2/28/2025 425 32.22 0.46 First Natl Bk 4.75 10/30/2028 32110YH73 10/30/2023 4.750 245,000.00 245,000.00 245,000.00 248,670.10 10/30/2028 1,765 0.00 0.46 First Utd Bk4.4 8/8/2025 33742CCR6 2/8/2023 4.400 245,000.00 245,000.00 245,000.00 243,008.15 8/8/2025 586 679.29 0.46 Genoa Banking Company 4.95 10/31/2028 372348DH2 10/31/2023 4.950 243,000.00 243,000.00 243,000.00 248,640.03 10/31/2028 1,766 2,010.24 0.46 Goldman Sachs Bk 1 7/28/2026 38149MXK4 7/28/2021 1.000 245,000.00 245,000.00 245,000.00 221,945.50 7/28/2026 940 1,047.12 0.46 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 234,665.90 7/29/2027 1,306 46.99 0.46 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 238,890.60 8/2/2027 1,310 702.32 0.47 Luana Savings Bank 0.2 5/7/2024 549104XH5 11/22/2021 0.699 240,000.00 237,081.60 239,583.55 235,792.80 5/7/2024 128 71.01 0.45 Manufacturers 4.9 12/9/2024 564759RJ9 12/7/2022 4.900 245,000.00 245,000.00 245,000.00 244,448.75 12/9/2024 344 789.37 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 244,027.35 7/31/2028 1,674 0.00 0.46 Merrick Bk 4.85 11/6/2029 59013KXW1 11/6/2023 4.850 245,000.00 245,000.00 245,000.00 248,547.60 11/6/2029 2,137 813.87 0.46 Morgan Stanley Bank Step 11/28/2027 61765QP52 9/2/2021 1.004 249,000.00 249,000.00 249,000.00 216,366.06 11/28/2027 1,428 225.12 0.47 MORGAN STANLEY PRIVATE BK 5.05 11/8/2028 61768EE82 11/8/2023 5.050 243,000.00 243,000.00 243,000.00 249,799.14 11/8/2028 1,774 1,781.89 0.46 Oceanfirst Bk Natl 3.25 7/1/2024 67523TBE2 6/29/2022 3.250 245,000.00 245,000.00 245,000.00 242,785.20 7/1/2024 183 43.63 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 234,511.55 9/15/2027 1,354 375.89 0.46 Preferred Bank LA Calif 1.95 8/30/2024 740367HR1 8/30/2019 1.950 249,000.00 249,000.00 249,000.00 243,870.60 8/30/2024 243 0.00 0.47 Sallie Mae Bank Utah 1.9 9/18/2024 7954504D4 9/18/2019 1.900 245,000.00 245,000.00 245,000.00 239,482.60 9/18/2024 262 1,326.36 0.46 Savibank 4.05 1/19/2027 80517LAC5 1/18/2023 4.050 249,000.00 249,000.00 249,000.00 243,081.27 1/19/2027 1,115 359.17 0.47 Schuyler Svgs Bk 4.35 7/27/2028 80832MAA5 7/27/2023 4.350 244,000.00 244,000.00 244,000.00 242,406.68 7/27/2028 1,670 4,565.47 0.46 Signature Bk New York 4.7 12/9/2024 82669GFM1 12/9/2022 4.700 240,000.00 240,000.00 240,000.00 238,929.60 12/9/2024 344 679.89 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 249,246.00 10/17/2028 1,752 2,431.64 0.46 Synchrony Bank 0.9 8/6/2026 87165GD58 8/6/2021 0.900 248,000.00 248,000.00 248,000.00 225,069.92 8/6/2026 949 898.92 0.47 Texas Exchange Bk 0.45 8/21/2024 88241TJE1 8/21/2020 0.450 245,000.00 245,000.00 245,000.00 237,787.20 8/21/2024 234 30.21 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 232,968.05 8/19/2027 1,327 2,968.19 0.46 Toyota Finl Svgs Bk 0.95 7/15/2026 89235MLC3 7/15/2021 0.950 245,000.00 245,000.00 245,000.00 222,384.05 7/15/2026 927 1,077.66 0.46 Transportation Alliance Bk 4.8 9/9/2024 89388CGG7 12/9/2022 4.800 240,000.00 240,000.00 240,000.00 239,488.80 9/9/2024 253 694.36 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 243,980.80 7/26/2028 1,669 147.67 0.46 Uinta Bk Mtn 4.4 3/22/2028 903572FT7 3/22/2023 4.400 245,000.00 245,000.00 245,000.00 242,915.05 3/22/2028 1,543 265.81 0.46 Univest Bank & Trust 4.5 6/21/2028 91527PCD7 6/21/2023 4.500 249,000.00 249,000.00 249,000.00 255,008.37 6/21/2028 1,634 306.99 0.47 Valley Central 4 4/28/2028 91944RAZ1 4/28/2023 4.000 249,000.00 249,000.00 249,000.00 243,277.98 4/28/2028 1,580 81.86 0.47 Washington Federal 1.95 8/28/2024 938828BN9 8/28/2019 1.950 245,000.00 245,000.00 245,000.00 239,962.80 8/28/2024 241 39.27 0.46 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,070.76 198,164.00 5/17/2024 138 210.96 0.38 Winter Hill Bank 3.5 8/26/2027-23 975875BH7 8/26/2022 3.500 245,000.00 245,000.00 245,000.00 234,560.55 8/26/2027 1,334 117.47 0.46 Sub Total / Average Certificate Of Deposit 3.379 15,158,000.00 15,142,139.24 15,150,490.60 14,839,433.88 1,074 56,274.85 28.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,255.00 12/22/2027 1,452 599.18 0.94 FFCB 0.69 7/22/2025-21 3133ELX33 4/15/2021 0.750 600,000.00 598,488.00 599,448.15 564,552.00 7/22/2025 569 1,828.50 1.13 FFCB 0.72 10/27/2026-21 3133EMES7 6/18/2021 1.000 500,000.00 492,715.00 496,162.07 452,470.00 10/27/2026 1,031 640.00 0.94 FFCB 0.74 11/24/2026-21 3133EMHC9 4/14/2021 1.053 450,000.00 442,350.00 446,048.12 406,192.50 11/24/2026 1,059 342.25 0.85 FFCB 2.62 11/17/2025 3133EHJR5 9/24/2021 0.810 500,000.00 536,830.00 516,701.13 484,745.00 11/17/2025 687 1,601.11 0.94 FFCB 4.5 12/22/2025 3133EPQ81 12/29/2023 4.210 1,000,000.00 1,005,440.00 1,005,424.97 1,003,250.00 12/22/2025 722 1,125.00 1.89 Sub Total / Average FFCB Bond 2.386 3,550,000.00 3,575,823.00 3,563,784.44 3,411,464.50 880 6,136.04 6.70 FHLB 1 12/30/2026-21 3130ANY87 10/20/2021 1.205 500,000.00 494,850.00 497,027.28 453,500.00 12/30/2026 1,095 0.00 0.94 FHLB 1.25 11/10/2026-22 3130APLR4 11/10/2021 1.250 450,000.00 450,000.00 450,000.00 412,843.50 11/10/2026 1,045 796.87 0.85 FHLB 3 4/20/2026 3130ARGN5 12/29/2023 4.350 1,000,000.00 970,620.00 970,689.70 970,920.00 4/20/2026 841 5,916.67 1.89 FHLB Step 12/15/2025-21 3130AKJ72 4/13/2021 0.894 500,000.00 497,500.00 498,952.84 470,370.00 12/15/2025 715 177.78 0.94 City of Prior Lake Portfolio Holdings Investment Portfolio - by Security Type As of 12/31/2023 Cash Certificate Of Deposit FFCB Bond FHLB Bond 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 City of Prior Lake Portfolio Holdings Investment Portfolio - by Security Type As of 12/31/2023 FHLN 5159508 1.25 10/16/2026-21 3130ALW83 4/16/2021 1.250 216,666.67 216,666.67 216,666.67 199,266.17 10/16/2026 1,020 564.24 0.41 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 929,050.00 7/22/2026 934 5,300.00 1.89 Sub Total / Average FHLB Bond 1.988 3,666,666.67 3,629,636.67 3,633,336.49 3,435,949.67 919 12,755.56 6.92 FHLMC 0.5 12/9/2024 3134GWA71 9/9/2020 0.500 200,000.00 200,000.00 200,000.00 192,022.00 12/9/2024 344 61.11 0.38 Sub Total / Average FHLMC Bond 0.500 200,000.00 200,000.00 200,000.00 192,022.00 344 61.11 0.38 League of Minnesota Cities - 4M Fund LGIP LGIP5101M 11/30/2010 5.242 1,891,201.79 1,891,201.79 1,891,201.79 1,891,201.79 N/A 1 3.57 League of Minnesota Cities - 4M Plus Fund LGIP LGIP5101MP 11/30/2010 5.352 9,148,727.97 9,148,727.97 9,148,727.97 9,148,727.97 N/A 1 17.28 Sub Total / Average Local Government Investment Pool 5.333 11,039,929.76 11,039,929.76 11,039,929.76 11,039,929.76 1 0.00 20.85 Allen Park MI Public Sch Dist 2 11/2/2024 018033HR4 7/30/2020 0.751 290,000.00 305,140.90 292,987.31 283,135.70 11/2/2024 307 966.67 0.55 Cabot-Las Positas 1.287 8/1/2027 15722TJS1 4/28/2022 3.500 550,000.00 491,991.50 510,472.08 491,502.00 8/1/2027 1,309 2,949.38 1.04 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 278,097.30 11/1/2024 306 950.00 0.54 Cecil Cnty MD 1.05 11/1/2026 1498433N2 9/23/2021 0.970 500,000.00 501,985.00 501,102.66 455,900.00 11/1/2026 1,036 875.00 0.94 Central Cmnty Sch 2 3/1/2026 153135FJ2 3/4/2021 0.700 300,000.00 319,098.00 308,286.63 284,337.00 3/1/2026 791 2,000.00 0.57 El Paso TX ISD 0 8/15/2024 283770NS0 10/30/2020 0.700 500,000.00 486,925.00 497,847.58 485,160.00 8/15/2024 228 0.00 0.94 Enfield Conn Taxable 1.39 8/1/2027 292749UK2 4/6/2022 3.000 335,000.00 308,658.95 317,254.02 302,350.90 8/1/2027 1,309 1,940.21 0.63 Falmouth ME Taxable 3 10/15/2025 306783NF4 10/15/2021 0.800 340,000.00 369,386.20 353,154.40 331,234.80 10/15/2025 654 2,153.33 0.64 Federal Way Wash2.2 12/1/2024 314031-HH-1 12/11/2019 2.150 475,000.00 476,111.50 475,205.54 463,410.00 12/1/2024 336 870.83 0.90 Franklin Twp 1.623 2/1/2029 355064KL9 10/4/2023 5.350 250,000.00 207,310.00 209,239.49 216,485.00 2/1/2029 1,859 1,690.62 0.47 Goose Creek Tex 4.5 2/15/2027 382604Z25 11/3/2022 4.700 500,000.00 496,125.00 497,172.36 503,160.00 2/15/2027 1,142 8,500.00 0.94 Hawaii St GO Ref 2.802 10/1/2027-26 419792KL9 7/28/2022 3.350 100,000.00 97,413.00 98,125.76 94,987.00 10/1/2027 1,370 700.50 0.19 Hawaii St Taxable 1.033 8/1/2025 419792F92 10/12/2021 0.950 300,000.00 300,924.00 300,385.17 283,596.00 8/1/2025 579 1,291.25 0.57 Indiana Bond Bank 3.326 7/15/2025 45462TER9 3/26/2021 0.900 240,000.00 264,516.00 248,764.63 234,952.80 7/15/2025 562 3,680.77 0.45 Liberty Center Ohio 0 11/1/2025 530336DV5 8/18/2020 1.051 215,000.00 203,589.95 210,972.57 197,557.05 11/1/2025 671 0.00 0.41 Mankato Minn ISD 0.7 2/1/2025 563690RP3 10/22/2020 0.700 300,000.00 300,000.00 300,000.00 286,485.00 2/1/2025 398 875.00 0.57 Mason & Kitsap Cntys 1.583 12/1/2028 575181HB1 5/19/2023 4.150 445,000.00 389,032.35 395,284.79 389,330.50 12/1/2028 1,797 587.03 0.84 Massachusetts St 0.986 11/1/2026 57582RK96 6/30/2021 1.000 500,000.00 499,635.00 499,806.08 456,175.00 11/1/2026 1,036 821.67 0.94 Massachusetts St Dev 2.785 5/1/2024 57584FEM8 12/20/2019 1.920 240,000.00 248,647.20 240,661.83 237,890.40 5/1/2024 122 1,114.00 0.45 Milwaukee Cnty Wis 2 12/1/2026 6022453V2 11/23/2021 1.300 500,000.00 516,960.00 509,857.88 467,705.00 12/1/2026 1,066 833.33 0.94 Minnesota St 7 11/1/2028 604146GK0 11/8/2023 5.251 250,000.00 268,952.50 268,400.59 279,435.00 11/1/2028 1,767 2,576.39 0.47 New York NY 1.92 11/1/2029 64971XUUO 9/25/2023 5.150 275,000.00 228,998.00 230,999.88 238,606.50 11/1/2029 2,132 880.00 0.52 New York NY 3.7 8/1/2029-25 64966LYZ8 11/24/2023 5.100 250,000.00 232,897.50 233,202.17 240,335.00 8/1/2029 2,040 3,854.17 0.47 New York State TFA 4.2 11/1/2028-23 64971Q7N7 9/7/2023 4.850 250,000.00 242,657.50 243,106.16 246,305.00 11/1/2028 1,767 1,750.00 0.47 Northwest Local Sch District Hamilton & Butler 667712CG6 11/15/2019 2.169 370,000.00 389,010.60 373,465.85 364,387.10 12/1/2024 336 1,002.08 0.70 Oklahoma Cnty Okla Metro 2.65 6/1/2024 67869T-AD-7 7/15/2019 2.286 500,000.00 508,255.00 500,708.37 495,145.00 6/1/2024 153 1,104.17 0.94 Orono ME Taxable 5 11/1/2025 687085DR8 10/29/2020 1.000 330,000.00 394,287.30 353,584.90 331,676.40 11/1/2025 671 2,750.00 0.62 Pelican Rapids Minn 0.8 2/1/2025 705863HR2 12/17/2020 0.700 525,000.00 527,126.25 525,561.54 502,887.00 2/1/2025 398 1,750.00 0.99 Pennsylvania St Univ 1.645 9/1/2025 709235S48 12/6/2021 1.120 250,000.00 254,787.50 252,139.47 237,675.00 9/1/2025 610 1,370.83 0.47 Richfield Minn ISD 3 2/1/2024 763342SZ6 9/4/2020 0.570 200,000.00 216,380.00 200,421.01 199,680.00 2/1/2024 32 2,500.00 0.38 Roanoke VA Taxable 2 2/1/2025 770078BD4 5/14/2020 1.250 300,000.00 310,266.00 302,369.99 291,042.00 2/1/2025 398 2,500.00 0.57 Springboro Ohio 5 12/1/2027 85023MAF2 7/12/2022 4.002 245,000.00 256,755.10 253,547.53 250,963.30 12/1/2027 1,431 1,020.83 0.46 St Louis Park Minn 4.5 2/1/2027 791740V34 9/7/2022 3.345 190,000.00 198,863.50 196,217.68 189,954.40 2/1/2027 1,128 3,562.50 0.36 Toledo Ohio City Sch 5 12/1/2027 889294RT3 9/28/2022 4.520 100,000.00 102,186.00 101,655.11 101,827.00 12/1/2027 1,431 416.67 0.19 Trussville AL 0.822 10/1/2025 898242ND0 8/25/2020 0.710 300,000.00 301,677.00 300,576.10 280,422.00 10/1/2025 640 616.50 0.57 Waukesha Wis 1.2 10/1/2027 943080UZ2 9/1/2022 3.660 375,000.00 332,557.50 343,671.21 334,657.50 10/1/2027 1,370 1,125.00 0.71 Wauwatosa WI 3 12/1/2024-22 9435042U3 10/28/2021 2.014 200,000.00 205,880.00 201,748.39 196,742.00 12/1/2024 336 500.00 0.38 Wicomico Cnty MD 2 12/1/2026 967546BA9 5/13/2022 3.450 380,000.00 356,975.80 365,241.25 355,060.60 12/1/2026 1,066 633.33 0.72 Winthrop Minn 2 2/1/2029-28 976367PN6 11/24/2023 5.100 225,000.00 193,556.25 194,169.87 197,327.25 2/1/2029 1,859 1,875.00 0.42 Wisconsin St Gen Fund 2.877 5/1/2024 977100EA0 12/2/2021 0.700 160,000.00 168,321.60 161,152.37 158,686.40 5/1/2024 122 767.20 0.30 Sub Total / Average Municipal Bond 2.315 12,840,000.00 12,758,840.45 12,653,520.22 12,236,265.90 890 65,354.26 24.25 T-Note 0.375 11/30/2025 91282CAZ4 9/24/2021 0.780 300,000.00 295,008.00 297,713.09 278,673.00 11/30/2025 700 95.29 0.57 T-Note 0.625 11/30/2027 91282CAY7 5/5/2022 3.040 500,000.00 438,535.00 456,808.38 441,055.00 11/30/2027 1,430 264.69 0.94 T-Note 2.5 2/28/2026 9128286F2 12/21/2023 4.220 1,000,000.00 964,310.91 964,757.02 965,390.00 2/28/2026 790 8,379.12 1.89 T-Note 4.625 3/15/2026 91282CGR6 12/21/2023 4.230 1,000,000.00 1,008,280.00 1,008,178.40 1,008,950.00 3/15/2026 805 13,595.47 1.89 Sub Total / Average Treasury Note 3.644 2,800,000.00 2,706,133.91 2,727,456.89 2,694,068.00 900 22,334.57 5.29 Total / Average 3.133 52,949,293.96 52,747,200.56 52,663,215.93 51,543,831.24 695 162,916.39 100 Local Government Investment Pool Municipal Bond Treasury Note FHLMC Bond YTM @ Cost Cost Value Days to Maturity % of Portfolio Cash - 3,694,698 1 6.98% Certificate of Deposit 3.379 15,142,139 1,074 28.63% FFCB Bond 2.386 3,575,823 880 6.70% FHLB Bond 1.988 3,629,637 919 6.92% FHLMC Bond 0.500 200,000 344 0.38% LGIP 5.333 11,039,930 1 20.85% Municipal Bond 2.315 12,758,840 890 24.25% Treasury Note 3.644 2,706,134 900 5.29% Total / Average 3.12 52,747,201 695 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio - Diversification, by Security Type December 31, 2023 Description City of Prior Lake - Quarterly Investment Report Change from one 12/31/2022 3/31/2023 6/30/2023 9/30/2023 12/31/2023 year prior Market Value 14,313,568 12,699,977 20,061,417 18,176,651 14,734,627 421,059 111110 3.47% 4.31% 4.71% 4.89% 4.00%0.52% Fixed Income Assets 33,197,884 33,936,884 33,902,781 33,750,838 38,012,573 4,814,689 31,188,237 32,121,659 31,899,550 31,752,611 36,809,204 5,620,967 917 865 853 903 963 46 849 826 806 844 903 54 1.98% 2.06% 2.16% 2.37% 2.78%0.80% Total Portfolio Value 47,511,452 46,636,861 53,964,198 51,927,490 52,747,201 5,235,749 45,501,805 44,821,636 51,960,967 49,929,262 51,543,831 6,042,026 112,064 164,251 116,519 170,756 162,916 50,852 -2,009,647 -1,815,225 -2,003,232 -1,998,228 -1,203,369 806,278 640 630 536 587 695 55 593 601 506 549 652 59 2.43% 2.67% 3.11% 3.25% 3.12% 0.69% BENCHMARK 90 Day T-Bill 4.42% 4.85% 5.43% 5.55% 5.40% 0.98% 4.69% 4.97% 5.47%5.53% 5.26% 0.57% 4.76% 4.94% 5.40%5.46% 4.79% 0.03% Weighted Average Yield to Maturity @ Cost CITY OF PRIOR LAKE, MINNESOTA Quarterly Investment Report December 31, 2023 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