Loading...
Agenda 08/26/2025 Item #16J 6 (Report to the Board regarding the investment of County finds as of the quarter ended June 30, 2025)8/26/2025 Item # 16.J.6 ID# 2025-2720 Executive Summary Report to the Board regarding the investment of County funds as of the quarter ended June 30, 2025. OBJECTIVE: To provide the Board a report regarding the investment of County funds as of the quarter ended June 30, 2025. CONSIDERATIONS: Florida Statute 28.33 provides for the investment of County surplus funds by the Clerk of Courts and Comptroller (Clerk). The Clerk manages the investment of Board funds in accordance with Florida Statute and the Board of County Commissioners’ lawfully adopted investment policy using best practices and financial advice. The Clerk will continue to provide a monthly summary of investments on the Clerk’s website for public access. Additionally, the Clerk is providing this update as to the status of the Board’s investment portfolio on a quarterly basis at a publicly noticed Board of County Commissioners’ meeting. Attached as exhibits are the investment portfolio holdings, portfolio composition pie chart, and yield and return graphs as of the end of the third quarter of FY-2025. The total managed portfolio, as of June 30, 2025, was $2.27B, at par value. As of June 30, 2025, Collier’s 12-month short-term yield exceeded the benchmark by .11%. The short-term yield exceeded the Standard and Poor’s benchmark yield due to the performance of funds with the First Foundation Bank SBA PRIME indexed account and SBA Florida PRIME local government investment pool. The Board’s Concentration (Operating) Account has also been included on the chart and bore interest of 4.11% as of June 30, 2025. Over the same period, the Collier portfolio’s long-term sector 12-month total return was lower by 0.25% than the benchmark Bank of America 1 to 3-year Treasury index’s total return. The total return was lower due to the portfolio’s buy and hold strategy underperforming compared to the actively managed index, which generally outperforms during periods of rising rates. The portfolio generally outperforms during periods of falling rates. The current investment strategy focuses on ensuring sufficient short-term liquidity, particularly given the attractive short-term yields, while monitoring longer term yields for select purchases. There is no realized gain or loss of principal associated with the performance to benchmark of the long or short-term portfolio as investments will be held to maturity, or call, or sold at a gain if market conditions change. FISCAL IMPACT: None. GROWTH MANAGEMENT IMPACT: None. LEGAL CONSIDERATIONS: This item has been reviewed by the County Attorney, is approved as to form and legality and requires a majority vote for any action. -JAK RECOMMENDATIONS: The investment report and exhibits are provided to the Board as information only, no action is required. PREPARED BY: Derek M. Johnssen, Finance Director, Office of the Clerk of the Circuit Court and Comptroller ATTACHMENTS: 1. Investment Exhibits QTR3 FY 2025 Page 4405 of 4682 A B C D E as of 06/30/2025 Weighted Weighted Bond Cont. Rate/ FNBB Final Years Years Yield Equiv. /Weighted Market Amortized Settlement First Call Maturity to to First to Purchased Purchased CUSIP Par Value Value Cost Date Call Date Frequency Date Maturity Call/Maturity Worst Yield Yield FEDERAL FARM CREDIT BANK 3133EM3T7 25,000,000.00 24,111,657.75 24,994,140.20 9/1/2021 9/1/2022 continuously 9/1/2026 0.02 0.02 4.01%0.87%0.02 FEDERAL FARM CREDIT BANK 3133ENUH1 15,000,000.00 14,810,917.65 14,757,081.55 12/15/2023 4/12/2023 continuously 4/12/2027 0.02 0.02 4.07%3.33%0.05 FEDERAL FARM CREDIT BANK 3133ERLV1 15,000,000.00 15,005,120.10 15,000,000.00 7/22/2024 none N/A 7/22/2025 0.00 0.00 4.06%4.88%0.05 FEDERAL FARM CREDIT BANK 3133ERMH1-1 10,000,000.00 9,999,464.50 10,000,000.00 7/29/2024 7/29/2025 continuously 7/29/2027 0.01 0.00 4.96%5.00%0.04 FEDERAL FARM CREDIT BANK 3133ERMH1-2 5,000,000.00 4,999,732.25 5,000,000.00 7/29/2024 7/29/2025 continuously 7/29/2027 0.01 0.00 4.96%5.00%0.02 FEDERAL FARM CREDIT BANK 3133ERLT6 10,000,000.00 9,995,759.60 9,999,676.97 8/1/2024 7/23/2025 continuously 7/23/2029 0.03 0.00 5.15%5.14%0.04 FEDERAL FARM CREDIT BANK 3133ER4F5 10,000,000.00 10,056,706.50 10,000,000.00 2/19/2025 2/19/2027 continuously 2/19/2030 0.03 0.01 4.45%4.82%0.03 TOTAL =90,000,000.00$ 88,979,358.35$ 89,750,898.72$ FEDERAL HOME LOAN BANK (Step)3130ALKB9 25,000,000.00 24,692,574.25 25,000,000.00 3/17/2021 6/17/2021 quarterly 3/17/2026 0.01 0.01 2.50%1.50%0.01 FEDERAL HOME LOAN BANK (Step)3130AM6U1 25,000,000.00 24,389,786.25 25,000,000.00 4/28/2021 7/28/2021 quarterly 4/28/2026 0.01 0.01 4.28%1.25%0.01 FEDERAL HOME LOAN BANK (Step)3130AMR46 25,000,000.00 24,457,254.75 25,000,000.00 6/16/2021 9/16/2021 quarterly 6/16/2026 0.02 0.02 3.06%1.25%0.01 FEDERAL HOME LOAN BANK (Step)3130AMS45 25,000,000.00 24,445,367.50 25,000,000.00 6/24/2021 9/24/2021 quarterly 6/24/2026 0.02 0.02 3.06%1.25%0.01 FEDERAL HOME LOAN BANK (Step)3130AMXW7 25,000,000.00 24,572,882.50 25,000,000.00 6/30/2021 9/30/2021 quarterly 6/30/2026 0.02 0.02 2.54%1.00%0.01 FEDERAL HOME LOAN BANK 3130ANQC7 25,000,000.00 24,843,481.50 25,000,000.00 8/27/2021 9/27/2021 monthly 8/27/2025 0.00 0.00 4.82%0.85%0.01 FEDERAL HOME LOAN BANK 3130ANV31 15,000,000.00 14,443,908.00 14,998,180.45 9/16/2021 9/16/2022 quarterly 9/16/2026 0.01 0.01 4.12%0.95%0.01 FEDERAL HOME LOAN BANK (Step)3130AP5V3 24,000,000.00 23,807,608.08 24,000,000.00 9/30/2021 12/30/2021 quarterly 9/30/2025 0.00 0.00 4.23%1.50%0.01 FEDERAL HOME LOAN BANK 3130AP6V2 25,000,000.00 24,078,012.00 25,000,000.00 9/30/2021 12/30/2021 quarterly 9/30/2026 0.02 0.02 4.11%1.05%0.02 FEDERAL HOME LOAN BANK 3130APBX2 25,000,000.00 24,077,879.75 25,000,000.00 10/14/2021 1/14/2022 quarterly 10/14/2026 0.02 0.02 4.09%1.13%0.02 FEDERAL HOME LOAN BANK 3130APAY1 25,000,000.00 24,058,701.75 25,000,000.00 10/21/2021 1/21/2022 quarterly 10/21/2026 0.02 0.02 4.08%1.10%0.02 FEDERAL HOME LOAN BANK 3130APBF1 25,000,000.00 24,073,054.25 25,000,000.00 10/22/2021 11/22/2021 monthly 10/22/2026 0.02 0.02 4.08%1.15%0.02 FEDERAL HOME LOAN BANK 3130A8ZQ9 4,900,000.00 4,871,129.84 4,873,180.20 12/19/2023 none N/A 9/12/2025 0.00 0.00 4.65%1.75%0.02 FEDERAL HOME LOAN BANK 3130B2SS5 15,000,000.00 14,538,136.20 14,872,128.00 9/20/2024 2/12/2027 quarterly 9/12/2029 0.04 0.02 4.18%3.38%0.04 FEDERAL HOME LOAN BANK 3130B3LV3 15,000,000.00 14,972,055.00 15,000,000.00 11/13/2024 11/13/2027 one time 11/13/2029 0.05 0.02 4.45%4.41%0.05 FEDERAL HOME LOAN BANK 3130B3MK6 15,000,000.00 15,040,783.50 15,000,000.00 11/13/2024 11/8/2027 one time 11/8/2029 0.05 0.02 4.28%4.40%0.05 FEDERAL HOME LOAN BANK 3130B3NG4 10,000,000.00 10,003,896.00 10,000,000.00 11/15/2024 7/13/2027 one time 11/13/2029 0.03 0.01 4.43%4.45%0.03 FEDERAL HOME LOAN BANK 3130B3RF2 15,000,000.00 15,005,769.00 15,000,000.00 11/18/2024 1/15/2027 one time 11/15/2029 0.05 0.02 4.54%4.57%0.05 FEDERAL HOME LOAN BANK 3130B3RE5 10,000,000.00 9,974,005.30 10,000,000.00 11/19/2024 8/19/2025 quarterly 11/19/2029 0.03 0.00 5.07%5.00%0.04 FEDERAL HOME LOAN BANK 3130B4BR1 10,000,000.00 10,008,218.90 10,000,000.00 12/19/2024 4/19/2027 one time 12/19/2029 0.03 0.01 4.48%4.53%0.03 FEDERAL HOME LOAN BANK 3130B4D57 10,000,000.00 10,054,947.30 10,000,000.00 12/23/2024 6/17/2027 one time 12/17/2029 0.03 0.01 4.30%4.60%0.03 FEDERAL HOME LOAN BANK 3130B5NZ7 10,000,000.00 9,964,896.80 10,000,000.00 3/25/2025 6/25/2027 annual 3/25/2030 0.03 0.01 4.50%4.42%0.03 FEDERAL HOME LOAN BANK 3130B5SU3 10,000,000.00 10,001,707.80 10,000,000.00 4/10/2025 7/10/2025 continuously 4/10/2029 0.03 0.00 3.99%4.69%0.03 FEDERAL HOME LOAN BANK 3130B6AG1 10,000,000.00 9,991,000.10 10,000,000.00 5/6/2025 11/6/2025 monthly 5/6/2030 0.03 0.00 4.78%4.76%0.03 FEDERAL HOME LOAN BANK 3130B65W2 10,000,000.00 10,052,855.80 10,000,000.00 5/15/2025 5/15/2028 continuously 5/15/2030 0.03 0.02 3.80%4.00%0.03 TOTAL =433,900,000.00$ 426,419,912.12$ 433,743,488.65$ FREDDIE MAC 3134GXDM3 25,000,000.00 24,609,850.00 25,000,000.00 12/1/2020 12/1/2021 quarterly 12/1/2025 0.01 0.01 4.41%0.62%0.01 FREDDIE MAC 3134GXFV1 25,000,000.00 24,567,187.50 25,000,000.00 12/17/2020 12/17/2021 quarterly 12/17/2025 0.01 0.01 4.43%0.63%0.01 FREDDIE MAC 3134H1MN0 10,000,000.00 9,982,363.30 9,971,268.99 12/28/2023 3/28/2024 quarterly 8/28/2026 0.01 0.01 4.40%4.25%0.03 FREDDIE MAC 3134H1RF2 10,000,000.00 10,000,870.30 10,000,000.00 2/6/2024 2/6/2026 one time 2/6/2029 0.03 0.00 4.51%4.53%0.03 FREDDIE MAC 3134H1YS6 10,000,000.00 9,773,159.90 9,700,766.70 3/27/2024 3/27/2025 monthly 3/27/2029 0.03 0.03 4.16%3.50%0.03 FREDDIE MAC (Step)3134GXVW1 2,000,000.00 1,993,771.24 1,974,642.43 4/10/2024 6/23/2024 quarterly 6/23/2027 0.00 0.00 3.41%3.50%0.01 FREDDIE MAC 3134GW5R3 15,000,000.00 14,811,657.75 14,791,078.23 4/17/2024 7/27/2024 quarterly 10/27/2025 0.00 0.00 4.57%0.65%0.05 FREDDIE MAC 3134H1L92 25,000,000.00 24,962,937.50 24,863,690.07 5/1/2024 5/1/2025 quarterly 5/1/2026 0.01 0.01 4.55%4.38%0.09 FREDDIE MAC 3134H16Z1 10,000,000.00 9,961,193.20 9,992,792.00 7/17/2024 7/17/2025 quarterly 7/17/2029 0.03 0.00 4.36%4.25%0.03 FREDDIE MAC 3134HACY7 10,000,000.00 9,923,788.00 9,946,773.97 8/13/2024 8/13/2026 quarterly 8/13/2029 0.03 0.01 4.20%4.00%0.03 FREDDIE MAC 3134HADG5 10,000,000.00 9,979,021.40 9,962,886.09 8/14/2024 2/14/2025 semi-annual 8/14/2029 0.03 0.03 4.18%4.30%0.03 FREDDIE MAC 3134HACZ4 10,000,000.00 9,988,524.80 10,000,000.00 8/20/2024 8/20/2026 quarterly 8/20/2029 0.03 0.01 4.36%4.33%0.03 FREDDIE MAC 3134HADA8 10,000,000.00 9,975,907.10 9,989,939.73 8/20/2024 8/20/2025 quarterly 8/20/2029 0.03 0.00 4.44%4.38%0.03 FREDDIE MAC 3134HADB6 15,000,000.00 14,929,947.75 14,975,582.88 8/20/2024 8/20/2025 quarterly 8/20/2029 0.04 0.00 4.25%4.13%0.05 FREDDIE MAC 3134HAHC0 10,000,000.00 9,942,965.20 9,988,210.41 9/4/2024 9/4/2025 annual 9/4/2029 0.03 0.00 4.27%4.13%0.03 FREDDIE MAC 3134HALD3 10,000,000.00 9,975,260.00 10,000,000.00 9/18/2024 9/12/2025 one time 9/12/2029 0.03 0.00 4.29%4.23%0.03 FREDDIE MAC 3134HAL50 15,000,000.00 14,990,464.95 15,000,000.00 12/10/2024 9/10/2025 quarterly 12/10/2029 0.05 0.00 4.88%4.86%0.05 FREDDIE MAC 3134HAL76 15,000,000.00 14,983,142.70 15,000,000.00 12/17/2024 9/17/2025 quarterly 12/17/2029 0.05 0.00 4.93%4.90%0.05 FREDDIE MAC 3134HA2U6 15,000,000.00 15,000,096.75 15,000,000.00 1/14/2025 7/14/2025 quarterly 1/14/2030 0.05 0.00 5.06%5.20%0.05 FREDDIE MAC 3134HBRL7 10,000,000.00 9,916,294.40 10,000,000.00 5/22/2025 5/22/2028 quarterly 5/22/2030 0.03 0.02 4.29%4.10%0.03 TOTAL =262,000,000.00$ 260,268,403.74$ 261,157,631.50$ Collier County Investment Portfolio Instrument Page 4406 of 4682 A B C D E as of 06/30/2025 Weighted Weighted Bond Cont. Rate/ FNBB Final Years Years Yield Equiv. /Weighted Market Amortized Settlement First Call Maturity to to First to Purchased Purchased CUSIP Par Value Value Cost Date Call Date Frequency Date Maturity Call/Maturity Worst Yield Yield Collier County Investment Portfolio Instrument FANNIE MAE 3135G06J7 25,000,000.00 24,594,796.00 25,000,000.00 12/10/2020 6/10/2021 quarterly 12/10/2025 0.01 0.01 4.37%0.65%0.01 FANNIE MAE 3135GAMY4 15,000,000.00 14,954,523.90 14,883,030.54 2/5/2024 2/5/2025 quarterly 8/5/2027 0.02 0.02 4.15%4.00%0.05 FANNIE MAE 3135GAR60 10,000,000.00 9,770,194.90 9,676,304.49 4/11/2024 4/11/2025 monthly 4/11/2029 0.03 0.03 4.16%3.50%0.03 FANNIE MAE 3135GAYM7 10,000,000.00 10,005,352.80 9,989,953.68 11/14/2024 5/14/2027 one time 11/14/2029 0.03 0.01 4.39%4.42%0.03 FANNIE MAE 3135GAZ46 10,000,000.00 9,999,434.70 9,992,977.00 11/19/2024 5/19/2025 quarterly 11/19/2029 0.03 0.03 5.00%5.05%0.04 FANNIE MAE 3135GAZN4 10,000,000.00 9,987,257.60 10,000,000.00 12/3/2024 9/3/2025 quarterly 12/3/2029 0.03 0.00 5.04%5.01%0.04 FANNIE MAE 3136GA3K3 10,000,000.00 9,988,120.50 10,000,000.00 12/19/2024 6/19/2025 monthly 12/19/2029 0.03 0.03 4.89%4.86%0.03 FANNIE MAE 3136GA2L2 15,000,000.00 15,006,625.50 15,000,000.00 12/27/2024 6/12/2025 quarterly 12/12/2029 0.05 0.05 4.71%5.00%0.05 FANNIE MAE 3136GAHB8 10,000,000.00 9,982,709.20 10,000,000.00 5/16/2025 8/16/2027 one time 5/16/2030 0.03 0.01 4.31%4.27%0.03 FANNIE MAE 3136GAHC6 10,000,000.00 9,981,982.10 10,000,000.00 5/23/2025 8/23/2027 one time 5/23/2030 0.03 0.02 4.29%4.25%0.03 TOTAL =125,000,000.00$ 124,270,997.20$ 124,542,265.71$ FARMER MAC 31424WBY7 10,000,000.00 10,026,807.60 10,000,000.00 11/14/2023 none N/A 11/14/2025 0.00 0.00 4.24%5.00%0.04 FARMER MAC 31424WMA7 10,000,000.00 10,019,885.70 10,000,000.00 8/6/2024 8/6/2026 one time 8/6/2029 0.03 0.01 4.48%4.67%0.03 FARMER MAC 31424WMC3 10,000,000.00 9,997,338.30 10,000,000.00 8/6/2024 8/6/2026 one time 8/6/2029 0.03 0.01 4.56%4.55%0.03 FARMER MAC 31424WMV1 10,000,000.00 9,993,514.80 10,000,000.00 8/20/2024 11/20/2026 quarterly 8/20/2029 0.03 0.01 4.27%4.25%0.03 FARMER MAC 31424WNZ1 15,000,000.00 14,767,736.70 15,000,000.00 9/24/2024 3/24/2027 one time 9/24/2029 0.04 0.02 4.15%3.75%0.04 FARMER MAC 31424WRX2 10,000,000.00 10,017,957.60 10,000,000.00 12/17/2024 6/17/2027 one time 12/17/2029 0.03 0.01 4.30%4.40%0.03 FARMER MAC 31424WTR3 15,000,000.00 15,147,291.00 15,000,000.00 1/24/2025 1/24/2028 one time 1/24/2030 0.05 0.03 4.29%4.70%0.05 FARMER MAC 31324WVG4 15,000,000.00 15,048,413.85 15,000,000.00 2/19/2025 8/19/2027 one time 2/19/2030 0.05 0.02 4.44%4.60%0.05 FARMER MAC 31424WXT4 10,000,000.00 10,014,972.50 10,000,000.00 4/8/2025 10/8/2027 one time 4/8/2030 0.03 0.02 4.13%4.20%0.03 FARMER MAC 31424WZD7 10,000,000.00 9,929,493.90 10,000,000.00 5/2/2025 none N/A 5/2/2029 0.03 0.03 3.96%3.76%0.03 FARMER MAC 31424WD90 15,000,000.00 14,997,194.55 15,000,000.00 6/17/2025 6/17/2026 one time 6/17/2030 0.05 0.01 4.75%4.75%0.05 FARMER MAC 31424WE65 20,000,000.00 19,996,273.20 20,000,000.00 6/17/2025 6/17/2026 quarterly 6/17/2030 0.07 0.01 4.78%4.78%0.07 TOTAL =150,000,000.00$ 149,956,879.70$ 150,000,000.00$ 1,060,900,000.00$ 1,049,895,551.11$ 1,059,194,284.58$ AMAZON.COM INC 023135CG9 10,000,000.00 9,777,694.30 9,846,386.74 8/29/2024 2/13/2029 continuously 4/13/2029 0.03 0.03 4.09%3.45%0.03 APPLE INC CORP NOTE 037833EB2 10,000,000.00 9,774,754.40 9,788,691.82 12/19/2023 none N/A 2/8/2026 0.00 0.00 4.51%7.00%0.03 MERCK & CO INC 58933YAX3 10,000,000.00 9,710,697.70 9,746,309.58 10/16/2024 12/7/2028 continuously 3/7/2029 0.03 0.02 4.26%3.40%0.03 PROCTER & GAMBLE CO 742718GK9 10,000,000.00 10,040,363.90 9,955,636.04 10/30/2024 none N/A 10/24/2029 0.03 0.03 3.89%4.15%0.03 JP MORGAN CHASE 46632FUN3 15,000,000.00 15,013,767.90 15,000,000.00 11/15/2024 7/15/2026 one time 11/15/2029 0.05 0.01 4.62%4.71%0.05 BANK OF AMERICA CORP 06055JHP7 10,000,000.00 10,015,014.50 10,000,000.00 12/4/2024 12/4/2026 one time 12/4/2029 0.03 0.01 4.74%4.85%0.03 BANK OF AMERICA CORP 06055JKU2 15,000,000.00 15,154,554.60 15,000,000.00 4/22/2025 10/22/2025 semi-annual 4/22/2030 0.05 0.00 1.66%5.00%0.05 APPLE INC CORP NOTE 037833EZ9 10,000,000.00 10,013,353.90 10,000,000.00 5/12/2025 4/20/2030 one time 5/12/2030 0.03 0.03 4.17%4.20%0.03 90,000,000.00$ 89,500,201.20$ 89,337,024.18$ US TREASURY NOTE 91282CJV4-1 20,000,000.00 19,997,656.20 19,980,511.91 2/7/2024 none N/A 1/31/2026 0.01 0.01 4.27%4.25%0.06 US TREASURY NOTE 91282CJV4-2 20,000,000.00 19,997,656.20 19,960,877.57 2/14/2024 none N/A 1/31/2026 0.01 0.01 4.27%4.25%0.06 US TREASURY NOTE 91282CKB6 10,000,000.00 10,028,515.60 9,991,532.80 4/10/2024 none N/A 2/28/2026 0.00 0.00 4.18%4.63%0.03 US TREASURY NOTE 91282CHN4-1 15,000,000.00 15,004,545.90 14,995,606.10 4/24/2024 none N/A 7/31/2025 0.00 0.00 4.30%4.75%0.05 US TREASURY NOTE 91282CHM6-1 25,000,000.00 25,121,093.75 24,945,427.39 6/27/2024 none N/A 7/15/2026 0.02 0.02 4.02%4.50%0.08 US TREASURY NOTE 91282CHM6-2 10,000,000.00 10,048,437.50 9,988,068.38 7/11/2024 none N/A 7/15/2026 0.01 0.01 4.02%4.50%0.03 US TREASURY NOTE 91282CHN4-2 15,000,000.00 15,004,545.90 14,998,737.26 7/22/2024 none N/A 7/31/2025 0.00 0.00 4.30%4.75%0.05 US TREASURY NOTE 91282CGC9 15,000,000.00 15,039,843.75 15,000,000.00 10/18/2024 none N/A 12/31/2027 0.03 0.03 3.76%3.88%0.04 US TREASURY NOTE 91282CJW2 15,000,000.00 15,100,195.35 14,990,158.05 10/23/2024 none N/A 1/31/2029 0.04 0.04 3.80%4.00%0.04 US TREASURY NOTE 91282CFM8-1 10,000,000.00 10,076,171.90 9,977,961.15 11/15/2024 none N/A 9/30/2027 0.02 0.02 3.77%4.13%0.03 US TREASURY NOTE 91282CFU0 15,000,000.00 15,113,671.80 14,959,978.40 11/21/2024 none N/A 10/31/2027 0.02 0.02 3.78%4.13%0.04 US TREASURY NOTE 91282CFM8-2 20,000,000.00 20,152,343.80 19,996,876.52 12/6/2024 none N/A 9/30/2027 0.03 0.03 3.77%4.13%0.06 US TREASURY NOTE 91282CGP0 15,000,000.00 15,087,304.65 14,963,054.99 12/12/2024 none N/A 2/29/2028 0.03 0.03 3.77%4.00%0.04 US TREASURY NOTE 91282CKG5 15,000,000.00 15,166,406.25 15,000,000.00 12/12/2024 none N/A 3/31/2029 0.04 0.04 3.80%4.13%0.04 US TREASURY NOTE 91282CHQ7 15,000,000.00 15,152,929.65 14,994,023.97 12/13/2024 none N/A 7/31/2028 0.03 0.03 3.77%4.13%0.04 US TREASURY NOTE 91282CHV6 30,000,000.00 30,028,125.00 30,033,076.97 12/17/2024 none N/A 8/31/2025 0.00 0.00 4.36%5.00%0.09 US TREASURY NOTE 91282CKP5 10,000,000.00 10,288,671.90 10,082,048.42 12/19/2024 none N/A 4/30/2029 0.03 0.03 3.81%4.63%0.03 275,000,000.00$ 276,408,115.10$ 274,857,939.88$ 7/22/2024 none N/A 1,425,900,000.00$ 1,415,803,867.41$ 1,423,389,248.64$ 2.55 1.34 3.48 TOTAL LONG TERM INVESTMENTS TOTAL U.S. Treasuries TOTAL Corporate Notes TOTAL Agency Holdings Page 4407 of 4682 A B C D E as of 06/30/2025 Weighted Weighted Bond Cont. Rate/ FNBB Final Years Years Yield Equiv. /Weighted Market Amortized Settlement First Call Maturity to to First to Purchased Purchased CUSIP Par Value Value Cost Date Call Date Frequency Date Maturity Call/Maturity Worst Yield Yield Collier County Investment Portfolio Instrument Balance Overnight Rate (F) 42,991,062.09$ 4.11% 388,953,724.57$ 4.47% 98,615,192.61$ 4.47% 65,885,361.92$ 4.36% 131,954,365.64$ 4.37% 35,000,000.00$ 4.44% BoCC US Treasury SLGSafe Demand Account 83,492,829.07$ 3.29% 846,892,535.90$ 2,272,792,535.90$ A - Weighted Years to Maturity calculation is based on individual par value divided by total long term investment par value multiplied by the remaining number of year(s) to full maturity. C - Yield to Worst is a forward looking measure of the lowest possible yield that can be received on a security effective from this report date. This value takes into account the yield to call, yield to maturity, face value, market value, coupon rate, and payment frequency. D - Coupon Rate is taken from the respective investment trade tickets. Step coupons, if any, are shown at their current rate. E - Weighted Purchased Yield calculation is based on individual par value divided by total long term investment par value multiplied by the Purchased Yield. BoCC FFB Concentration Account BoCC FL PALM LGIP Account-Term Investment B - Weighted Years To First Call/Maturity calculation is based on individual par value divided by total long term investment par value multiplied by the remaining number of year(s) to full maturity, or to the first call date if applicable. When an investment passes the first call date the calculation is adjusted based on date of final maturity. F - An Overnight Contractual Rate is provided for overnight investments (BoCC Concentration Account) pursuant to a contract with First Foundation Bank. Concentration Account Rate is indexed at 95% of the daily Effective Federal Funds Rate with a minimum floor rate of .25%. First Foundation Bank also provides an account with overnight availability that is fully collateralized and pays interest indexed to the Florida PRIME rate. The Florida PRIME, FLCLASS, and FL PALM LGIP rates are the current 7-Day Participant Yield as published on the respective LGIP websites. The SLGSafe Demand Account pays interest based on an adjustment of the average yield for the 13-week Treasury Bills at the most recent Treasury Bill auction. Deposit / LGIP Accounts TOTAL FUNDS ON DEPOSIT TOTAL MANAGED PORTFOLIO BoCC FL PALM LGIP Account-Liquidity Account BoCC FLCLASS-Daily LGIP Account BoCC Florida PRIME LGIP Account BoCC FFB SBA Daily Indexed Account Page 4408 of 4682 US Treasuries Notes & T-Bills $275,000,000.00 12.1% Bank Deposits $431,944,786.66 19.0% Federal Agencies / GSE (FHLB,FNMA,FHLMC,FFCB) $1,060,900,000.00 46.7% Corporates $90,000,000.00 4.0% SBA Prime $98,615,192.61 4.3% FLCLASS $65,885,361.92 2.9% FL PALM, $166,954,365.64 7.3% SLGSafe Demand Account $83,492,829.07 3.7% Collier County Portfolio Composition as of June 30, 2025 (At Par Value) $2,272,792,535.90 Sector Allowed (%)Current (%) Sector Maximum Total Cash Based Interest & Gains Fiscal Year to Date $ 62,103,681 Bank Deposits 100% 19.0% U.S. Treasury Notes & T-Bills 100% 12.1% Federal Agency / GSE 80% 46.7% SBA Prime 50% 4.3% Corporates 25% 4.0% FLCLASS 25% 2.9% FL PALM 25% 7.3% SLGSafe Demand Account 100% 3.7% Page 4409 of 4682 4.11% 4.33% 4.22% 4.00% 4.25% 4.50% 4.75% 5.00% 5.25% 5.50% July 2024 Aug 2024 Sept 2024 Oct 2024 Nov 2024 Dec 2024 Jan 2025 Feb 2025 Mar 2025 April 2025 May 2025 June 2025 Collier County Short Term Sector Yields Collier Short Term Portfolio Yield vs. S&P Rated GIP Government Index Concentration Account (FFB)Collier Short Term Portfolio Yield S&P Rated GIP Government Index Combined Yield of LGIP Accounts (Florida Prime, FLCLASS, & FL PALM) & FFB Indexed Account 30-Day Net Yield % Note: Yield calculations on a 30-360 basis Page 4410 of 4682 5.67% 5.42% 3.00% 3.50% 4.00% 4.50% 5.00% 5.50% 6.00% 6.50% 7.00% 7.50% 8.00% July 2024 Aug 2024 Sept 2024 Oct 2024 Nov 2024 Dec 2024 Jan 2025 Feb 2025 Mar 2025 Apr 2025 May 2025 June 2025 Collier County Long Term Sector 12 Month Total Return vs. B of A 1-3 US T Index 12 Month Total Return Bank of America 12 Month Return Index Collier County 12 Month Return Note: Total return includes both interest earnings and changes in the market value of the underlying securities. Page 4411 of 4682