Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
05(B) - Approval of the 2nd Quarter 2023 Investment Report Report
Change from one 6/30/2022 9/30/2022 12/31/2022 3/31/2023 6/30/2023 year prior Market Value 13,722,257 13,941,365 14,313,568 12,699,977 20,061,417 6,339,160 111110 0.90% 2.05% 3.47% 4.31% 4.71%3.81% Fixed Income Assets 32,321,683 33,273,875 33,197,884 33,936,884 33,902,781 1,581,098 30,910,391 31,173,111 31,188,237 32,121,659 31,899,550 989,159 897 938 917 865 853 (44) 838 831 849 826 806 (32) 1.68% 1.85% 1.98% 2.06% 2.16%0.48% Total Portfolio Value 46,043,940 47,215,240 47,511,452 46,636,861 53,964,198 7,920,258 44,632,648 45,114,476 45,501,805 44,821,636 51,960,967 7,328,319 105,209 145,337 112,064 164,251 116,519 11,310 1,411,292 -2,100,764 -2,009,647 -1,815,225 -2,003,232 (591,940) 629 661 640 630 536 (93) 587 586 593 601 506 (81) 1.45% 1.91% 2.43% 2.67% 3.11% 1.66% BENCHMARK 90 Day T-Bill 1.72% 3.33% 4.42% 4.85% 5.43% 3.71% 2.51% 3.92% 4.69%4.97% 5.47% 2.96% 2.80% 4.05% 4.76%4.94% 5.40% 2.60% Weighted Average Yield to Maturity @ Cost CITY OF PRIOR LAKE, MINNESOTA Quarterly Investment Report June 30, 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 YTM @ Cost Cost Value Days to Maturity of Portfolio Cash - 1,331,500 1 2.47% Certificate of Deposit 2.759 15,133,894 782 28.09% FFCB Bond 0.892 2,070,383 1,002 3.80% FHLB Bond 1.103 2,659,017 1,133 4.94% FHLMC Bond 0.500 200,000 528 0.37% LGIP 5.043 18,729,917 1 34.72% Municipal Bond 1.946 13,105,944 830 24.13% Treasury Note 2.193 733,543 1,340 1.48% Total / Average 3.11 53,964,198 536 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio - Diversification, by Security Type June 30, 2023 Description City of Prior Lake - Quarterly Investment Report YTM @ Cost Cost Value Days to Maturity of Portfolio 0-1 Month 4.532 20,939,016 1 38.84% 1-3 Months 2.350 1,715,000 72 3.18% 3-6 Months 2.790 2,800,632 131 5.10% 6-9 Months 0.614 461,380 197 0.82% 9-12 Months 2.183 1,853,229 333 3.39% 1-2 Years 1.824 6,882,049 506 12.70% 2-3 Years 1.426 5,810,092 851 10.47% 3-4 Years 1.763 7,393,126 1,228 13.74% 4-5 Years 3.703 5,720,642 1,604 10.94% 5-10 Years 4.150 389,032 1,981 0.82% Total / Average 3.110 53,964,198 536 100.00% CITY OF PRIOR LAKE, MINNESOTA Investment Portfolio - Diversification, by Maturity Range June 30, 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 271,275.78 271,275.78 271,275.78 271,275.78 N/A 1 0.50 Morgan Stanley Cash CASH5089 12/31/2010 0.000 563,622.23 563,622.23 563,622.23 563,622.23 N/A 1 1.04 Oppenheimer Cash MM9905 12/27/2011 0.000 496,601.81 496,601.81 496,601.81 496,601.81 N/A 1 0.92 Sub Total / Average Cash 0.000 1,331,499.82 1,331,499.82 1,331,499.82 1,331,499.82 1 0.00 2.47 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 239,814.39 6/16/2026 1,082 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 235,312.70 8/4/2025 766 3,332.00 0.45 Alma Bank 1.8 9/11/2023 020080BM8 9/11/2019 1.800 245,000.00 245,000.00 245,000.00 243,329.10 9/11/2023 73 229.56 0.45 American Express Natl 3 5/4/2027 02589ACK6 4/30/2022 3.000 245,000.00 245,000.00 245,000.00 225,321.60 5/4/2027 1,404 1,147.81 0.45 Banc Calif Irvine 3.2 7/1/2024 05961SNS9 6/29/2022 3.200 245,000.00 245,000.00 245,000.00 239,570.80 7/1/2024 367 21.48 0.45 Bank Baroda New York 3.55 11/30/2023 06062R-7R-7 11/30/2018 3.550 245,000.00 245,000.00 245,000.00 243,201.70 11/30/2023 153 724.79 0.45 Bank Hapoalim 0.95 7/23/2026 06251A2Y5 7/23/2021 0.950 245,000.00 245,000.00 245,000.00 214,620.00 7/23/2026 1,119 1,007.52 0.45 Bank of Belleville 4 6/15/2027 06063PDD4 12/15/2022 4.000 249,000.00 249,000.00 249,000.00 237,262.14 6/15/2027 1,446 409.32 0.46 Bank of New England 3.25 7/31/2023 06426KAN8 7/31/2018 3.250 245,000.00 245,000.00 245,000.00 244,588.40 7/31/2023 31 0.00 0.45 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 234,168.55 9/30/2024 458 0.00 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 217,143.50 3/31/2026 1,005 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 239,573.25 3/17/2028 1,722 3,347.77 0.45 Bridgewater Bk 4.8 3/29/2028 108622NK3 3/29/2023 4.800 245,000.00 245,000.00 245,000.00 240,043.65 3/29/2028 1,734 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 245,218.11 236,741.73 9/23/2027 1,546 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 230,547.45 3/17/2025 626 1,280.71 0.45 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 238,016.61 8/14/2024 411 1,932.69 0.46 Celtic Bank 1.8 8/30/2023 15118RRF6 8/30/2019 1.800 245,000.00 245,000.00 245,000.00 243,569.20 8/30/2023 61 0.00 0.45 CF Bank 3.15 9/18/2023 15721UCQ0 9/18/2018 3.150 245,000.00 245,000.00 245,000.00 243,873.00 9/18/2023 80 253.73 0.45 Charles Schwab Bank 4.7 11/21/2023 159877UAC2 11/21/2022 4.700 238,000.00 238,000.00 238,000.00 237,297.90 11/21/2023 144 6,772.89 0.44 CIBC Bank USA 4.5 5/25/2028 12547CBN7 5/25/2023 4.500 244,000.00 244,000.00 244,000.00 235,899.20 5/25/2028 1,791 1,082.96 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 242,187.40 11/24/2025 878 1,249.84 0.45 Enerbank USA 0.55 9/25/2025 29278TRL6 9/25/2020 0.550 245,000.00 245,000.00 245,000.00 219,948.75 9/25/2025 818 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 233,308.60 11/8/2024 497 265.81 0.45 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 234,298.40 9/27/2024 455 1,147.81 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 244,098.96 4/25/2028 1,761 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 219,621.86 205,722.00 3/31/2025 640 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 226,889.60 8/2/2027 1,494 642.37 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 230,084.40 2/28/2025 609 21.48 0.45 First Utd Bk4.4 8/8/2025 33742CCR6 2/8/2023 4.400 245,000.00 245,000.00 245,000.00 240,048.55 8/8/2025 770 649.75 0.45 Goldman Sachs Bk 1 7/28/2026 38149MXK4 7/28/2021 1.000 245,000.00 245,000.00 245,000.00 214,379.90 7/28/2026 1,124 1,026.99 0.45 Harden County 3.1 9/28/2023 412022CJ2 9/28/2018 3.100 245,000.00 245,000.00 245,000.00 243,694.15 9/28/2023 90 41.62 0.45 Iowa State Clarksville 3.15 9/28/2023 46256YAY5 9/28/2018 3.150 245,000.00 245,000.00 245,000.00 243,674.55 9/28/2023 90 1,987.52 0.45 Israel Discount Bk 0.75 7/14/2023 465076TA5 1/28/2022 0.750 249,000.00 249,000.00 249,000.00 248,566.74 7/14/2023 14 782.82 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 228,707.50 7/29/2027 1,490 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 232,877.25 8/2/2027 1,494 678.10 0.46 Luana Savings Bank 0.2 5/7/2024 549104XH5 11/22/2021 0.699 240,000.00 237,081.60 238,984.90 229,620.00 5/7/2024 312 71.01 0.44 Manufacturers 4.9 12/9/2024 564759RJ9 12/7/2022 4.900 245,000.00 245,000.00 245,000.00 243,118.40 12/9/2024 528 756.48 0.45 Morgan Stanley Bank Step 11/28/2027 61765QP52 9/2/2021 1.004 249,000.00 249,000.00 249,000.00 207,419.49 11/28/2027 1,612 225.12 0.46 MS Private Bank 3.55 11/8/2023 61760ARS0 11/8/2018 3.550 245,000.00 245,000.00 245,000.00 243,383.00 11/8/2023 131 1,262.92 0.45 National Cooperative Bank3.4 12/21/2023 635573AL2 12/24/2018 3.400 245,000.00 245,000.00 245,000.00 242,802.35 12/21/2023 174 205.40 0.45 New York Community Bank 0.2 7/3/2023 649447VA4 6/30/2021 0.200 245,000.00 245,000.00 245,000.00 244,897.10 7/3/2023 3 0.00 0.45 Oceanfirst Bk Natl 3.25 7/1/2024 67523TBE2 6/29/2022 3.250 245,000.00 245,000.00 245,000.00 239,688.40 7/1/2024 367 21.82 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 228,313.05 9/15/2027 1,538 352.40 0.45 Preferred Bank LA Calif 1.95 8/30/2024 740367HR1 8/30/2019 1.950 249,000.00 249,000.00 249,000.00 239,087.31 8/30/2024 427 0.00 0.46 Sallie Mae Bank Utah 1.9 9/18/2024 7954504D4 9/18/2019 1.900 245,000.00 245,000.00 245,000.00 234,788.40 9/18/2024 446 1,326.36 0.45 Savibank 4.05 1/19/2027 80517LAC5 1/18/2023 4.050 249,000.00 249,000.00 249,000.00 238,504.65 1/19/2027 1,299 331.55 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 237,496.80 12/9/2024 528 648.99 0.44 Spring Bank3.25 10/24/2023 849430AY9 10/24/2018 3.250 245,000.00 245,000.00 245,000.00 243,427.10 10/24/2023 116 130.89 0.45 State Bk India New York 0.65 12/29/2023 856285A92 12/29/2021 0.650 245,000.00 245,000.00 245,000.00 239,389.50 12/29/2023 182 4.36 0.45 Synchrony Bank 0.9 8/6/2026 87165GD58 8/6/2021 0.900 248,000.00 248,000.00 248,000.00 217,496.00 8/6/2026 1,133 880.57 0.46 Texas Exchange Bk 0.45 8/21/2024 88241TJE1 8/21/2020 0.450 245,000.00 245,000.00 245,000.00 231,407.40 8/21/2024 418 27.18 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 226,877.35 8/19/2027 1,511 2,901.74 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 214,811.10 7/15/2026 1,111 1,058.53 0.45 Transportation Alliance Bk 4.8 9/9/2024 89388CGG7 12/9/2022 4.800 240,000.00 240,000.00 240,000.00 238,147.20 9/9/2024 437 662.79 0.44 Uinta Bk Mtn 4.4 3/22/2028 903572FT7 3/22/2023 4.400 245,000.00 245,000.00 245,000.00 235,959.50 3/22/2028 1,727 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 246,890.97 6/21/2028 1,818 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 235,456.89 4/28/2028 1,764 54.58 0.46 Veritex Cmnty Bk 0.2 9/15/2023 923450CP3 9/15/2021 0.200 245,000.00 245,000.00 245,000.00 242,422.60 9/15/2023 77 20.14 0.45 Washington Federal 1.95 8/28/2024 938828BN9 8/28/2019 1.950 245,000.00 245,000.00 245,000.00 235,312.70 8/28/2024 425 26.18 0.45 Webbank 0.4 10/30/2023-22 947547NL5 11/8/2021 0.449 245,000.00 244,755.00 244,958.54 241,043.25 10/30/2023 122 2.68 0.45 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,165.11 195,416.00 5/17/2024 322 195.89 0.37 Winter Hill Bank 3.5 8/26/2027-23 975875BH7 8/26/2022 3.500 245,000.00 245,000.00 245,000.00 228,528.65 8/26/2027 1,518 93.97 0.45 Sub Total / Average Certificate Of Deposit 2.759 15,150,000.00 15,133,894.24 15,139,948.52 14,510,086.78 782 42,632.56 28.09 FFCB 0.69 7/22/2025-21 3133ELX33 4/15/2021 0.750 600,000.00 598,488.00 599,269.70 547,116.00 7/22/2025 753 1,817.00 1.11 FFCB 0.72 10/27/2026-21 3133EMES7 6/18/2021 1.000 500,000.00 492,715.00 495,477.12 441,725.00 10/27/2026 1,215 630.00 0.93 FFCB 0.74 11/24/2026-21 3133EMHC9 4/14/2021 1.053 450,000.00 442,350.00 445,361.49 397,008.00 11/24/2026 1,243 333.00 0.83 FFCB 2.62 11/17/2025 3133EHJR5 9/24/2021 0.810 500,000.00 536,830.00 521,174.21 474,990.00 11/17/2025 871 1,564.72 0.93 Sub Total / Average FFCB Bond 0.892 2,050,000.00 2,070,383.00 2,061,282.52 1,860,839.00 1,002 4,344.72 3.80 City of Prior Lake Portfolio Holdings Investment Portfolio - by Security Type As of 6/30/2023 Cash Certificate Of Deposit FFCB 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 6/30/2023 FHLB 1 12/30/2026-21 3130ANY87 10/20/2021 1.205 500,000.00 494,850.00 496,527.75 444,035.00 12/30/2026 1,279 0.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 404,401.50 11/10/2026 1,229 781.25 0.83 FHLB Step 12/15/2025-21 3130AKJ72 4/13/2021 0.894 500,000.00 497,500.00 498,683.36 458,065.00 12/15/2025 899 114.58 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 194,995.67 10/16/2026 1,204 556.71 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 901,250.00 7/22/2026 1,118 5,266.67 1.85 Sub Total / Average FHLB Bond 1.103 2,666,666.67 2,659,016.67 2,661,877.78 2,402,747.17 1,133 6,719.21 4.94 FHLMC 0.5 12/9/2024 3134GWA71 9/9/2020 0.500 200,000.00 200,000.00 200,000.00 186,512.00 12/9/2024 528 58.33 0.37 Sub Total / Average FHLMC Bond 0.500 200,000.00 200,000.00 200,000.00 186,512.00 528 58.33 0.37 League of Minnesota Cities - 4M Fund LGIP LGIP5101M 11/30/2010 5.027 14,860,673.84 14,860,673.84 14,860,673.84 14,860,673.84 N/A 1 27.55 League of Minnesota Cities - 4M Plus Fund LGIP LGIP5101MP 11/30/2010 5.105 3,832,618.19 3,832,618.19 3,832,618.19 3,832,618.19 N/A 1 7.10 LMC 2023A LGIP LGIP5210M 6/26/2023 5.027 36,625.17 36,625.17 36,625.17 36,625.17 N/A 1 0.07 Sub Total / Average Local Government Investment Pool 5.043 18,729,917.20 18,729,917.20 18,729,917.20 18,729,917.20 1 0.00 34.72 Allen Park MI Public Sch Dist 2 11/2/2024 018033HR4 7/30/2020 0.751 290,000.00 305,140.90 294,777.75 277,216.80 11/2/2024 491 950.56 0.54 Cabot-Las Positas 1.287 8/1/2027 15722TJS1 4/28/2022 3.500 550,000.00 491,991.50 504,915.83 479,231.50 8/1/2027 1,493 2,929.71 1.02 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 271,576.50 11/1/2024 490 934.17 0.53 Cecil Cnty MD 1.05 11/1/2026 1498433N2 9/23/2021 0.970 500,000.00 501,985.00 501,298.50 442,250.00 11/1/2026 1,220 860.42 0.93 Central Cmnty Sch 2 3/1/2026 153135FJ2 3/4/2021 0.700 300,000.00 319,098.00 310,214.23 277,290.00 3/1/2026 975 1,983.33 0.56 Edgewood Ohio City 5 12/1/2023 280455ET9 12/19/2019 2.101 215,000.00 238,512.40 217,509.29 214,425.95 12/1/2023 154 865.97 0.40 El Paso TX ISD 0 8/15/2024 283770NS0 10/30/2020 0.700 500,000.00 486,925.00 496,110.54 470,965.00 8/15/2024 412 0.00 0.93 Enfield Conn Taxable 1.39 8/1/2027 292749UK2 4/6/2022 3.000 335,000.00 308,658.95 314,759.55 293,500.20 8/1/2027 1,493 1,927.27 0.62 Falmouth ME Taxable 3 10/15/2025 306783NF4 10/15/2021 0.800 340,000.00 369,386.20 356,855.33 325,210.00 10/15/2025 838 2,125.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,318.10 454,408.75 12/1/2024 520 841.81 0.88 Goose Creek Tex 4.5 2/15/2027 382604Z25 11/3/2022 4.700 500,000.00 496,125.00 496,716.77 497,075.00 2/15/2027 1,326 8,437.50 0.93 Hawaii St GO Ref 2.802 10/1/2027-26 419792KL9 7/28/2022 3.350 100,000.00 97,413.00 97,874.04 93,028.00 10/1/2027 1,554 692.72 0.19 Hawaii St Taxable 1.033 8/1/2025 419792F92 10/12/2021 0.950 300,000.00 300,924.00 300,507.57 276,012.00 8/1/2025 763 1,282.64 0.56 Indiana Bond Bank 3.326 7/15/2025 45462TER9 3/26/2021 0.900 240,000.00 264,516.00 251,634.18 230,757.60 7/15/2025 746 3,658.60 0.44 Liberty Center Ohio 0 11/1/2025 530336DV5 8/18/2020 1.051 215,000.00 203,589.95 209,868.18 190,728.65 11/1/2025 855 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 278,673.00 2/1/2025 582 869.17 0.56 Mason & Kitsap Cntys 1.583 12/1/2028 575181HB1 5/19/2023 4.150 445,000.00 389,032.35 390,194.31 378,250.00 12/1/2028 1,981 567.46 0.82 Massachusetts St 0.986 11/1/2026 57582RK96 6/30/2021 1.000 500,000.00 499,635.00 499,771.64 440,575.00 11/1/2026 1,220 807.97 0.93 Massachusetts St Dev 2.785 5/1/2024 57584FEM8 12/20/2019 1.920 240,000.00 248,647.20 241,660.00 234,676.80 5/1/2024 306 1,095.43 0.44 Milwaukee Cnty Wis 2 12/1/2026 6022453V2 11/23/2021 1.300 500,000.00 516,960.00 511,559.43 454,425.00 12/1/2026 1,250 805.56 0.93 Northwest Local Sch District Hamilton & Butler 667712CF8 11/15/2019 2.069 360,000.00 376,408.80 361,710.87 356,626.80 12/1/2023 154 942.50 0.67 Northwest Local Sch District Hamilton & Butler 667712CG6 11/15/2019 2.169 370,000.00 389,010.60 375,363.82 358,999.90 12/1/2024 520 968.68 0.69 Oak Creek WIS 4 10/1/2023 671137-YP-6 11/27/2018 3.402 280,000.00 287,434.00 280,390.82 278,854.80 10/1/2023 93 2,768.89 0.52 Oklahoma Cnty Okla Metro 2.65 6/1/2024 67869T-AD-7 7/15/2019 2.286 500,000.00 508,255.00 501,560.26 486,850.00 6/1/2024 337 1,067.36 0.93 Oregon Edu Dists 0.312 7/1/2023 68587FAT1 12/17/2021 0.550 385,000.00 383,598.60 385,000.00 385,000.00 7/1/2023 1 0.00 0.71 Orono ME Taxable 5 11/1/2025 687085DR8 10/29/2020 1.000 330,000.00 394,287.30 360,052.29 328,227.90 11/1/2025 855 2,704.17 0.61 Pelican Rapids Minn 0.8 2/1/2025 705863HR2 12/17/2020 0.700 525,000.00 527,126.25 525,821.15 489,604.50 2/1/2025 582 1,738.33 0.97 Pennsylvania St Univ 1.645 9/1/2025 709235S48 12/6/2021 1.120 250,000.00 254,787.50 252,784.82 232,612.50 9/1/2025 794 1,359.41 0.46 Rhode IS Infrastructure Bk 2.18 10/1/2023 7622FDD7 6/27/2019 2.151 435,000.00 435,522.00 435,031.18 431,550.45 10/1/2023 93 2,344.41 0.81 Richfield Minn ISD 3 2/1/2024 763342SZ6 9/4/2020 0.570 200,000.00 216,380.00 202,841.83 197,070.00 2/1/2024 216 2,483.33 0.37 Roanoke VA Taxable 2 2/1/2025 770078BD4 5/14/2020 1.250 300,000.00 310,266.00 303,465.67 284,898.00 2/1/2025 582 2,483.33 0.56 Springboro Ohio 5 12/1/2027 85023MAF2 7/12/2022 4.002 245,000.00 256,755.10 254,646.59 247,501.45 12/1/2027 1,615 986.81 0.45 St Louis Park Minn 4.5 2/1/2027 791740V34 9/7/2022 3.345 190,000.00 198,863.50 197,231.91 187,366.60 2/1/2027 1,312 6,958.75 0.35 Toledo Ohio City Sch 5 12/1/2027 889294RT3 9/28/2022 4.520 100,000.00 102,186.00 101,867.93 100,390.00 12/1/2027 1,615 402.78 0.19 Trussville AL 0.822 10/1/2025 898242ND0 8/25/2020 0.710 300,000.00 301,677.00 300,741.73 271,962.00 10/1/2025 824 609.65 0.56 Waukesha Wis 1.2 10/1/2027 943080UZ2 9/1/2022 3.660 375,000.00 332,557.50 339,463.55 324,273.75 10/1/2027 1,554 1,112.50 0.70 Wauwatosa WI 3 12/1/2024-22 9435042U3 10/28/2021 2.014 200,000.00 205,880.00 202,705.84 193,750.00 12/1/2024 520 483.33 0.37 Wicomico Cnty MD 2 12/1/2026 967546BA9 5/13/2022 3.450 380,000.00 356,975.80 362,693.78 348,159.80 12/1/2026 1,250 612.22 0.70 Wisconsin St Gen Fund 2.877 5/1/2024 977100EA0 12/2/2021 0.700 160,000.00 168,321.60 162,890.36 156,630.40 5/1/2024 306 754.41 0.30 Sub Total / Average Municipal Bond 1.946 13,015,000.00 13,105,944.50 12,962,809.64 12,240,604.60 830 62,416.15 24.13 T-Note 0.375 11/30/2025 91282CAZ4 9/24/2021 0.780 300,000.00 295,008.00 297,111.96 270,750.00 11/30/2025 884 92.21 0.56 T-Note 0.625 11/30/2027 91282CAY7 5/5/2022 3.040 500,000.00 438,535.00 451,250.86 428,010.00 11/30/2027 1,614 256.15 0.93 Sub Total / Average Treasury Note 2.193 800,000.00 733,543.00 748,362.82 698,760.00 1,340 348.36 1.48 Total / Average 3.118 53,943,083.69 53,964,198.43 53,835,698.30 51,960,966.57 536 116,519.33 100 Local Government Investment Pool Municipal Bond Treasury Note FHLB Bond FHLMC Bond