Loading...
Agenda 08/25/2020 Item #16J3 (09/08/2020 Item #16F1E for 08/25/2020 Absentia)08/25/2020 EXECUTIVE SUMMARY Report to the Board regarding the investment of County funds as of the quarter ended June 30, 2020. OBJECTIVE: To provide the Board a report regarding the investment of County funds as of the quarter ended June 30, 2020. CONSIDERATIONS: Florida Statute 28.33 provides for the investment of County surplus funds by the Clerk of Courts. The Clerk manages the investment of Board funds in accordance with Florida Statute and the Board of County Commissioners’ lawful adopted investment poli cy 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 inventory, portfolio composition pie chart, along with yield and return graphs as of the end of the third quarter of FY-2020. The total managed portfolio at June 30, 2020 was $1.27B, at par value. For June 2020, Collier’s short and long-term yields exceeded their respective benchmarks by .22% and 1.29%. Short-term yield exceeded the Standard and Poor’s benchmark primarily due to the performance of funds with the Florida Prime Local Government Investment Pool, FLCLASS and Florida PALM (LGIPs). The Board’s Concentration (Operating) Account has also been included on the chart and bore interest of .25% as of June 30, 2020. In order to maximize yield, only funds necessary to meet current obligations are kept in the Concentration Account. Over the same period, the Collier portfolio’s long-term sector total return was 1.78% lower than the benchmark due to the relative market volatility of the Bank of America 1 to 3 year Treasury index’s total return. Total return measures include the unrealized gains and losses related to changes in the fair value of the investments. The current yield curve is relatively flat out to five years, so current strategy is to utilize overnight LGIPs. This allows the flexibility to take advantage of yield increases, should they occur. There is no realized gain or loss of principal associated with the performance to benchmark of the long or short-term portfolio. GROWTH MANAGEMENT IMPACT: None. FISCAL IMPACT: None. LEGAL CONSIDERATIONS: This item has been reviewed by the County Attorney, raises no legal issues, and requires majority vote for approval. -JAK RECOMMENDATION: The investment report 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 16.J.3 Packet Pg. 287 08/25/2020 ATTACHMENT(S) 1. Investment Exhibits QTR3 FY 2020 (PDF) 16.J.3 Packet Pg. 288 08/25/2020 COLLIER COUNTY Board of County Commissioners Item Number: 16.J.3 Doc ID: 13341 Item Summary: Report to the Board regarding the investment of County funds as of the quarter ended June 30, 2020. Meeting Date: 08/25/2020 Prepared by: Title: – Clerk of the Circuit Court Name: Erin Roxberry 08/20/2020 4:01 PM Submitted by: Title: Senior Staff Assistant – Clerk of the Circuit Court Name: Jennifer Milum 08/20/2020 4:01 PM Approved By: Review: Clerk of the Circuit Court Derek Johnssen Additional Reviewer Completed 08/20/2020 4:07 PM Office of Management and Budget Debra Windsor Level 3 OMB Gatekeeper Review Completed 08/20/2020 4:59 PM Budget and Management Office Mark Isackson Additional Reviewer Completed 08/21/2020 9:00 AM County Attorney's Office Jeffrey A. Klatzkow Level 3 County Attorney's Office Review Completed 08/21/2020 10:09 AM County Manager's Office Leo E. Ochs Level 4 County Manager Review Completed 08/21/2020 11:02 AM Board of County Commissioners MaryJo Brock Meeting Pending 08/25/2020 9:00 AM 16.J.3 Packet Pg. 289 Collier County Investment Portfolio as of 06/30/2020 A B C D E F G Weighted Weighted Bond Cont. Rate/Bond Cont. Rate/ FNBB Final Years Years O/N Equiv. /Coupon Equiv. /Weighted Settlement First Call Market Amortized Maturity to to First Cont.Coupon Weighted Purchased Purchased Instrument CUSIP Date Call Date Frequency Par Value Value Cost Date Maturity Call/Maturity Rate Rate Yield Yield Yield US Treasury Note 9128285F3 10/15/2018 none N/A 25,000,000.00$ 25,875,000.00$ 24,963,806.08$ 10/15/2021 0.06 0.06 2.88 0.14 2.99 0.15 FFCB 3133EJY60 12/3/2018 none N/A 9,548,000.00 10,236,181.65 9,554,188.53 3/3/2023 0.05 0.05 3.02 0.06 2.99 0.06 US Treasury Bill 912796SZ3-1 7/25/2019 none N/A 25,000,000.00 24,998,425.00 24,978,944.44 7/16/2020 0.00 0.00 1.95 0.10 1.95 0.10 US Treasury Bill 912796SZ3-2 7/26/2019 none N/A 25,000,000.00 24,998,425.00 24,978,722.22 7/16/2020 0.00 0.00 1.98 0.10 1.98 0.10 US Treasury Bill 912796SZ3-3 7/26/2019 none N/A 25,000,000.00 24,998,425.00 24,978,655.56 7/16/2020 0.00 0.00 1.98 0.10 1.98 0.10 US Treasury Bill 912796TD1 9/9/2019 none N/A 25,000,000.00 24,995,750.00 24,948,895.83 8/13/2020 0.01 0.01 1.72 0.09 1.72 0.09 US Treasury Bill 912796TJ8 9/12/2019 none N/A 50,000,000.00 49,984,750.00 49,826,500.00 9/10/2020 0.02 0.02 1.79 0.18 1.79 0.18 FHLB 3130AH7J6-1 10/1/2019 none N/A 10,000,000.00 10,042,000.00 9,998,203.52 10/1/2020 0.01 0.01 1.75 0.03 1.82 0.04 FHLB 3130AH7J6-2 10/1/2019 none N/A 10,000,000.00 10,042,000.00 9,998,221.31 10/1/2020 0.01 0.01 1.75 0.03 1.82 0.04 FHLB 3130AH7J6-3 10/2/2019 none N/A 25,000,000.00 25,105,000.00 24,996,815.07 10/1/2020 0.01 0.01 1.75 0.09 1.80 0.09 US Treasury Note 912828YZ7-1 12/31/2019 none N/A 50,000,000.00 51,085,950.00 49,998,496.84 12/31/2021 0.15 0.15 1.63 0.16 1.63 0.16 US Treasury Note 912828YZ7-2 12/31/2019 none N/A 50,000,000.00 51,085,950.00 49,998,528.00 12/31/2021 0.15 0.15 1.63 0.16 1.63 0.16 FFCB 3133ELKR4 2/3/2020 2/3/2021 continuously 25,000,000.00 25,115,475.00 24,992,554.64 2/3/2022 0.08 0.03 1.54 0.08 1.57 0.08 Fed Hm Ln Disc Nt 313384F87 3/17/2020 none N/A 25,000,000.00 24,991,550.00 24,972,555.56 9/14/2020 0.01 0.01 0.52 0.03 0.52 0.03 FHLB 3130AJFH7 3/30/2020 9/30/2020 continuously 25,000,000.00 25,007,600.00 25,000,000.00 3/30/2022 0.09 0.01 1.00 0.05 1.00 0.05 US Treasury Bill 9127963A5 5/21/2020 none N/A 100,000,000.00 99,932,600.00 99,943,791.66 11/19/2020 0.08 0.08 0.15 0.03 0.15 0.03 Total long term investments 504,548,000.00$ 508,495,081.65$ 504,128,879.26$ 0.73 0.60 1.43 1.46 Balance BoCC FFIB Concentration Account 57,805,803.23$ 0.25 BoCC SBA Florida LGIP Account 601,819,416.29$ 0.51 BoCC FLCLASS LGIP Account 100,028,958.76$ 0.49 BoCC FL PALM LGIP Account 10,000,674.09$ 0.49 Total Funds on Deposit 769,654,852.37$ Total managed portfolio 1,274,202,852.37$ 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. 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. C-An Overnight Contractual Rate is provided for overnight investments (BoCC Concentration Account) pursuant to a contract with First Florida Integrity Bank. Concentration Account Rate is indexed at 95% of the daily Effective Federal Funds Rate with a floor (minimum) rate of .25%. The SBA Florida, FLCLASS, and FL PALM LGIP rates are the current 7-Day Participant Yield as published on the respective LGIP websites. D-Coupon Rate is taken from the respective investment trade tickets. Step coupons, if any, are shown at their current rate. E-Coupon Weighted Yield calculation is based on individual par value divided by total long term investment par value multiplied by the coupon rate. F-Bond Equivalent / Purchased Yield is taken from the respective investment trade tickets. 16.J.3.a Packet Pg. 290 Attachment: Investment Exhibits QTR3 FY 2020 (13341 : QTR 3 Investments) US Treasuries Notes & T-Bills $375,000,000.00 29.4% Bank Deposit Account $57,805,803.23 4.5% Federal Agencies / GSE (FHLB,FNMA,FHLMC,FFCB) $129,548,000.00 10.2% SBA Florida LGIP $601,819,416.29 47.2% FLCLASS LGIP $100,028,958.76 7.9% FL PALM LGIP $10,000,674.09 0.8% Collier County Portfolio Composition as of June 30, 2020 (At Par Value) $1,274,202,852.37 Sector Allowed (%)Current (%) Sector Maximum Total Cash Based Interest & Gains Fiscal Year to Date $17,420,753 Bank Deposit Account 100% 4.5% U.S. Treasury Notes & T-Bills 100% 29.4% Federal Agency / GSE 80% 10.2% SBA Florida LGIP 50% 47.2% FLCLASS LGIP 25%7.9% FL PALM LGIP 25% 0.8% 16.J.3.a Packet Pg. 291 Attachment: Investment Exhibits QTR3 FY 2020 (13341 : QTR 3 Investments) 0.25% 0.55% 0.33% 0.00% 0.25% 0.50% 0.75% 1.00% 1.25% 1.50% 1.75% 2.00% 2.25% 2.50% 2.75% July. 2019 Aug. 2019 Sept. 2019 Oct. 2019 Nov. 2019 Dec. 2019 Jan. 2020 Feb. 2020 Mar. 2020 Apr. 2020 May. 2020 June. 2020 Collier County Short Term Sector Yields Collier Short Term Portfolio Yield vs. S&P Rated GIP Government Index Concentration Account (FFIB)Collier Short Term Portfolio Yield S&P Rated GIP Government Index Combined Yield of SBA Florida Prime, FLCLASS, & FL PALM LGIP Accounts 16.J.3.a Packet Pg. 292 Attachment: Investment Exhibits QTR3 FY 2020 (13341 : QTR 3 Investments) 1.46% 0.17% 0.00% 0.25% 0.50% 0.75% 1.00% 1.25% 1.50% 1.75% 2.00% 2.25% 2.50% July. 2019 Aug. 2019 Sept. 2019 Oct. 2019 Nov. 2019 Dec. 2019 Jan. 2020 Feb. 2020 Mar. 2020 Apr. 2020 May. 2020 June. 2020 Collier County Long Term Sector Yields Collier Long Term Portfolio Yield vs. B of A 1-3 Yr. Treas. Note Yield Benchmark Collier Long Term Portfolio Yield Bank of America 1-3 Yr Treasury Note Benchmark 16.J.3.a Packet Pg. 293 Attachment: Investment Exhibits QTR3 FY 2020 (13341 : QTR 3 Investments) 4.07% 2.29% 2.00% 2.50% 3.00% 3.50% 4.00% 4.50% 5.00% 5.50% 6.00% July. 2019 Aug. 2019 Sept. 2019 Oct. 2019 Nov. 2019 Dec. 2019 Jan. 2020 Feb. 2020 Mar. 2020 Apr. 2020 May. 2020 June. 2020 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. 16.J.3.a Packet Pg. 294 Attachment: Investment Exhibits QTR3 FY 2020 (13341 : QTR 3 Investments)