Loading...
HomeMy WebLinkAbout2024 City Treasurer's Quarterly Investment Summary Reports. (2) IN 2000 Main Street, 0C,, ,. , Huntington Beach,CA g F City of Huntington Beach =) APPROVED 7-0 UNTY CP�\ File #: 24-418 MEETING DATE: 8/6/2024 REQUEST FOR CITY COUNCIL ACTION SUBMITTED TO: Honorable Mayor and City Council Members SUBMITTED BY: Alisa Backstrom, City Treasurer VIA: Alisa Backstrom, City Treasurer PREPARED BY: Jennifer McCann, Senior Administrative Assistant Subject: Receive and File the City Treasurer's Quarterly Investment Report for June 2024 • Statement of Issue: Receive and File the City Treasurer's Quarterly Investment Report for June 2024, pursuant to Section 18.0 of the Investment Policy of the City of Huntington Beach. Financial Impact: Not Applicable Recommended Action: Receive and File the City Treasurer's Quarterly Investment Report for June 2024, pursuant to Section 18.0 of the Investment Policy of the City of Huntington Beach. Alternative Action(s): Deny or Critique Quarterly Investment Report. Analysis: Not Applicable. Environmental Status: This action is not subject to the California Environmental Quality Act (CEQA) pursuant to Sections 15060(c)(2) (the activity will not result in a direct or reasonably foreseeable indirect physical change in the environment) and 15060(c)(3) (the activity is not a project as defined in Section 15378) of the CEQA Guidelines, California Code of Regulations, Title 14, Chapter 3, because it has no potential for resulting in physical change to the environment, directly or indirectly. Strategic Plan Goal: Non Applicable -Administrative Item City of Huntington Beach Page 1 of 2 Printed on 7/31/2024 powered351j.Legista rrM File #: 24-418 MEETING DATE: 8/6/2024 Attachment(s): 1. Treasurer's Quarterly Investment Report for June 2024 2. PowerPoint Presentation Treasurer's Quarterly Investment Report for June 2024 City of Huntington Beach Page 2 of 2 Printed on 7/31/2024 powered3s'LegistarTM .' 1..�w ` HUNTINGTON BEACH o- CityHuntingtonof Beach Reportort Quarterly Investment June 2024 0 /,�� I N G T� � p \I <(••.•\011poRgFoNI O n ; s1 p W_ • ok 00uNTN \J; Prepared by: Alisa Backstrom, MBA, CCMT, CPFIM City Treasurer Colin Stevens, MPP Treasury Manager 1 33 a 'HUtfTINGTONBEACH r '> ' INVESTMENT PORTFOLIO SUMMARY As of June 30, 2024 Portfolio Investments Par Value Book Value Market Value Book Value Book Yield Book Yield Days to %of Port Contribution Maturity Cash/Money Market $9,653,600.90 $9,653,600.90 $9,653,600.90 2.48% 5.17% 0.13% 1 Local Govt Iry Pools(LGIP) $33,616,453.79 533,616,453.79 533,616,453.79 8.64% 5.43; 0.47% 1 U.S:Treasuries $81,000,000.00 580,656,417.98 578,539,600.00 20.73% 2.35% 0.49% 645 Supranational $50,000,000.03 $49,569,236.75 548,681,700.00 12.74% 2.97% 0.38% 960 US.Agencies $164,980,000.00 $164,786,239.28 $159,593,278.60 42.35% 2.24% 0.95% 604 Corporates $51,571,000.00 4,50,783,139.39 550,092,.574.68 13.05% 3.61% 0.47% 631 Total $390,821,054.69 $389,065,0;;.09 $380,177,207_97 100.00% 2;;% 594 Currently, funds within this portfolio with overnight availability are invested in the California Asset Management Program "CAMP". The CAMP account is considered a "Local Government Investment Pool" or "LGIP" for reporting purposes above. Other funds are invested in U.S. Treasuries, Supranationals (International Bank of Reconstruction and Development "IBRD", Inter-American Development Bank "IADB"), U.S. Agencies, money market funds, and corporate bonds. Only the investment types allowed under California Government code Section 53601 and the City's Investment Policy Statement are utilized. After raising the federal funds rate by 5.25 percentage points since March 2022 in one of the Fed's fastest and largest rate hike campaigns, The Federal Open Market Committee ("FOMC" or "the Fed") has held the rate steady since July of last year. At the most recent June 2024 meeting, the FOMC maintained the federal funds rate at 5.25 to 5.50 percent. As interest rates have been rising and have remained at elevated levels, the market value of securities previously purchased at lower than the current market rates, is down. This has resulted in the current market value of the portfolio being lower than the book value, at $380.2 million versus $389.1 million, respectively. As investments are primarily held to maturity, the market value is only a point-in-time measurement and no loss is realized. The increasing interest rates will allow excess funds to be invested at higher rates resulting in increased interest income in the future. 2 34 �.. -,*rt•y^' FoRk HUNTINGTON BEACH • o ;` : PORTFOLIO BREAKOUT BY SECTOR As of June 30, 2024 Sector Breakdown Cash/Money Corporates Market 13.05% .1 2.48% Local Govt Inv - . Pools(LGIP) 8.64% ` U.S.Treasuries 20.73% U.S.Agencies 42.35% . "`' Supranational 12.74% The largest holding by security type at month-end was U.S. Agency securities at approximately 42% of the total overall portfolio. This was followed by U.S. Treasury securities at approximately 21% of the total portfolio as of June 30, 2024. Cash held in the Local Government Investment Pools ("LGIP") has been reduced as higher interest rates have become available in marketable securities. INVESTMENT PORTFOLIO EARNINGS As of June 30, 2024 Period Earnings Summary(30 Days) Fiscal YTD Summary(366 Days) Net Period Earnings $9 64,579.98 Net Period Earnings S10.027,613.33 Last FY Period Net Earnings $730,988.46 Last FY Period Net Earnings $5.896,786.47 Avg Daily Book Balance S401.099.321.66 Avg Daily Book Balance S375.076,563.56 Net Effective Annual Return 3.036% Net Effective Annual Return 2.673% 3 35 itt a u � w A, e HUIiTINGTON BEACH � �� ' - _ Earnings for the month of June 2024 were $984,580, an increase of approximately 35% from the same month in the prior year. Fiscal year to date earnings of$10,027,613 were up approximately 70% from the previous fiscal year. These higher earnings were due to both the increase in interest rates and the higher average balance of the portfolio. The effective rate of return for June was 3.04%, with a fiscal year-to-date return of 2.67%. The benchmark has increased rapidly with the sharp rise in interest rates through 2022 into 2023. At the end of June, the 12-month moving average of the interpolated 1.5-year U.S. Treasury was 4.98%. The portfolio will lag behind the benchmark, as it will take time for previously purchased securities to mature and for funds to be reinvested. QUARTERLY PORTFOLIO ACTIVITY April 1 to June 30, 2024 $ in 000s j Transaction Type: Security Type Purchase Maturity/Sale Commercial Paper $0 $0 U.S. Treasuries $0 $12,000 Supranationals $10,000 $0 U.S. Agencies $0 $10,000 Corporate Bonds $0 $5,000 ;TOTALS: $10,000 . $27,000 For the quarter ending June 30, 2024, one Supranational (IADB) was purchased for $10 million. Two U.S. Treasuries matured totaling $12 million, two U.S. Agencies matured totaling $10 million, and one Corporate Bond (NVDA) matured for $5 million. 4 36 Pxv � r HUNTINBTON BEACH COMPLIANCE SUMMARY As of June 30, 2024 MAXIMUM INVESTMENT MAXIMUM SPECIFIED%OF MINIMUM QUALITY IN TYPE MATURITY PORTFOLIO! REQUIREMENTS COMPLIANCE? MAXIMUM PER ISSUER U.S.Treasuries 5 years None None YES U.S.Agencies 5 years None Norte YES Supranationals 5 years 30% -AA- Rating Category YES Corporate Bonds 5 years 30%/1 0% "A" Rating Category YES Money Market 60 days 15%/10% "AAA"Rating Mutual Funds Category YES CA Asset Management N/A Up to$75,000,000 None Program(CAMP) YES Maximum Maturities No more than 50%of portfolio maturing over 4 years. YES There were no compliance issues during this period. ECONOMIC AND MARKET OVERVIEW MARKET SUMMARY: MARCH 31, 2024 - JUNE 30, 2024 Fed Funds 2-Yr. 10-Yr. As of: Rate Treasury Treasury S&P 500 DJIA 3/28/2024 5.25 - 5.50 % 4.59% 4.20% $ 5,254.35 $ 39,807.37 6/28/2024 5.25 - 5.50% 4.71% 4.36% $ 5,460.48 $ 39,118.86 % Change 0.00°/n 2.61% 3.81% 3.92% -1.73% The Federal Open Market Committee (FOMC) met in June to discuss the current state of the economy and to examine potential future interest rate adjustments. They concluded that economic activity has been expanding at a solid pace, job gains have remained strong, and the unemployment rate has remained low. The Committee also stated that inflation has eased over the past year but remains elevated, and that in recent months there has been modest further progress toward the Committee's two percent inflation objective. 5 37 HUNTINGTON BEACH • a y . :�.-•.,max ` _ •.'�+r,.$Fi Fixed Income / Equity Markets: The yield on the 10-year U.S. Treasury finished the quarter at 4.36%, up from 4.20% at the end of the previous quarter. The S&P 500 increased by 3.92% and the DJIA decreased by 1.73% respectively, over the same period. Employment: Total nonfarm payroll employment rose by 206,000 in June, and the unemployment rate was little changed at 4.1 percent. Notable job gains occurred in government, health care, social assistance, and construction. 6 38 oIIHCTp Portfolio Summary °;`"'""_7,1„ City of Huntington Beach f ^ Portfolio:CITY y x qY -Q Reporting Date:(FY2024) oe uirrvcA�� 06/01/2024-06/30/2024 Full Accrual Basis Par Value Period Earnings Summary(30 Days) Fiscal YTD Summary(366 Days) Period Transactions Portfolio Par Value $390,821,054.69 Net Period Earnings $984,579.98 r Net Period Earnings $10,027,613.33 Redemptions 5 Last FY Period Net Earnings $730,988.46 Last FY Period Net Earnings $5,896,788.47 Purchases 0 Par Value Receivable $12,000,000.00 Avg Daily Book Balance $401,099,321.66 Avg Daily Book Balance $375,076,563.56 Total Activity 5 Total Par Value $402,821,054.69 Net Effective Annual Return 3.036% Net Effective Annual Return 2.673% Fiscal YTD Transactions Redemptions 17 Purchases 14 Book Value Total Activity 31 Portfolio Book Value $389,065,088.09 City Portfolio Certification Par Value Receivable $12,000,000.00 I certify that this report and the corresponding pages attached accurately reflect all portfolio combined investments and conforms with all California state statutes and the Huntington Beach investment policy filed on December 19,2023.The investment program herein shown provides sufficient cash flow liquidity to meet the next six month's obligations.Market values are provided by US Bank via Interactive Data Corp(IDC) Total Book Value $401,065,088.09 The City Portfolio uses a 12 month moving average of the 1.5Yr Treasury for comparison purposes.This period,that rate is equal to:4.980% 4$ City Treasurer 06/30/2024 Alisa Backstrom Title • Date Portfolio Investments Market Value Book Value Book Yield Days to Par Value Book Value Market Value %of Port Book Yield Contribution Maturity Portfolio Market Value $380,177,207.97 Cash/Money Market $9,653,600.90 $9,653,600.90 $9,653,600.90 2.48% 5.17% 0.13% 1 Par Value Receivable $12,000,000.00 Local Govt Inv Pools(LGIP) $33,616,453.79 $33,616,453.79 $33,616,453.79 8.64% 5.43% 0.47% 1 U.S.Treasuries $81,000,000.00 $80,656,417.98 $78,539,600.00 20.73% 2.35% 0.49% 645 ' Supranational $50,000,000.00 $49,569,236.75 $48,681,700.00 12.74% 2.97% 0.38% 960 Total Market Value $392,177,207.97 U.S.Agencies $164,980,000.00 $164,786,239.28 $159,593,278.60 42.35% 2.24% 0.95% 604 I Corporates $51,571,000.00 $50,783,139.39 $50,092,574.68 13.05% 3.61% 0.47% 631 Total $390,821,054.69 $389,065,088.09 $380,177,207.97 100.00% 2.88% 594 7 39 Reporting Period: Cash By Structure Report Portfolio:CITY 06/30/2024 City of Huntington Beach Accounting ID Ticker Pool Description Type Par Value Book Value Market Value Rate %of Portfolio 104 FUZXX First American Treasury Obligations Cash/Money Market. 9,653,600.90 9,653,600.90 9,653,600.90 5.170 2.48% Cash/Money Market Total 9,653,600.90 9,653,600.90 9,653,600.90 2.48% 003 CAMP California Asset Management Program LGIP 33,616,453.79 33,616,453.79 33,616,453.79 5.430 8.64% LGIP Total 33,616,453.79 33,616,453.79 33,616,453.79 8.64% • Report Run Date: Jul 19,2024 8 ao Reporting Period: Bond Redemption Activity Report Portfolio:CITY 06/30/2024 City of Huntington Beach Accounting ID Transaction Type Cusip Description Price Settlement Posted Date Par Value Principal Accrued Interest Total Date 4378 Maturity 3130ATVC8 FHLB 4.875 06/14/2024 100.00000 06/14/2024 06/14/2024 5,000,000.00 5,000,000.00 0.00 5,000,000.00 4355 Maturity 67066GAL8 NVDA 0.584 06/14/2024 100.00000 06/14/2024 06/14/2024 5,000,000.00 5,000,000.00 0.00 5,000,000.00 4348 Maturity 3130AQD42 FHLB 0.920 06/28/2024 100 00000 06/28/2024 06/28/2024 5,000,000.00 5,000,000.00 0.00 5,000,000.00 4364 Maturity 9128286Z8 T 1.750 06/30/2024 100.00000 06/30/2024 07/01/2024 7,000,000.00 7,000,000.00 0.00 7,000,000.00 4370 Maturity 912828XX3 T 2.000 06/30/2024 i 100.00000 06/30/2024 07/01/2024 5,000,000 00 5,000,000.00 0.00 5,000,000.00 Activity Total 1 27,000,000.00 27,000,000.00 0.00 27,000,000.00 • Report Run Date: Jul 19,2024 s 41 Reporting Period: Bond Purchase Activity Report Portfolio:CITY 06/30/2024 City of Huntington Beach Accounting ID Transaction Type Cusip j Description Price Settlement Posted Date Par Value Principal Accrued Interest Total Date Activity Total 0.00 0.00 0.00 0.00 Report Run Date: Jul 19,2024 10 42 Reporting Period: Bond Interest Received Report Portfolio:CITY 06/30/2024 City of Huntington Beach Accounting ID Transaction Type Cusip Description Date Posted Interest Received Purchased Interest Net Interest Adjustment 4382 Interest Income 717081DV2 PFE 2.750 06/03/2026 06/03/2024 68,750.00 68,750.00 4392 Interest Income 3130AW4N7 FHLB 3.630 06/04/2027 06/04/2024 90,750.00 90,750.00 4397 Interest Income 3130AWER7 FHLB 4.625 06/06/2025 06/06/2024 69,375.00 69,375.00 4395 Interest Income 3130AWC24 FHLB 4.000 06/09/2028 06/10/2024 100,000.00 100,000.00 4399 _ Interest Income 3130A_WC24 FHL_B_4.0_0_0 06/09/2028 06/10/_2024 100,000.00 100,000.00_ 4401 — Interest Income —_ 45818WEQ5 IA_DB 3.800 06/09/2028 —06/10/202_4_ __Income 18,750.00 ---- 18,750.00 4388 Interest Income 3130AVWS7 ___ FHLB_ 3.750 06/12/2026_ 06/12/2024 56,250.00 56,250.00_ — 4355 Interest Income 67066GAL8 NVDA 0.584 06/14/2024 --—06/14/2024— 14,600.00 — 14,600.00 — 4378 Interest Income 3130ATVC8 FHLB 4.875 06/14/2024 06/14/2024 121,875.00 121,875.00 i 4375 Interest Income 110122CN6 BMY 3.200 06/15/2026 06/17/2024 80,000.00 80,000.00 4376 Interest Income 91282CEU1 T 2.875 06/15/2025 06/17/2024_ 43,125.00_ _ 43,125.00 --4381 _ Interest Income 3135G04Z3 — FNMA 0.500 06/17/2025-- 06/17/2024 —12,500.00 — —— _ 12,500.00 4396 Interest Income 3133EPMV4 FFCB 4.125 06/15/2027 06/17/2024 103,125.00 103,125.00 4329 Interest Income 3135G04Z3 FNMA 0.500 06/17/2025 06/17/2024 12,500 00 12,500.00 ` 6254398 Interest Income 3133EPNG6 FFCB 4 375 06/23/2026 06/24/2024 65,625.00 .00 - - -- 65 4348 Interest Income 3130AQD42 FHLB 0.920 06/28/2024 06/28/2024 23,000 00 23 000.00 Activity Total 1,075,225.00 0.00 1,075,225.00 Report Run Date: Jul 19,2024 11 43 Reporting Period: Bond Holdings By Sector Report Portfolio:CITY 06/30/2024 City of Huntington Beach Accounting CUSIP Ticker Coupon Maturity Date Short Description Trade Date Settlement Par Value Book Value Market Value Gain/Loss Book Effective Days to (%)of Moodys S&P Fitch ID Date Yield Duration Maturity Portfolio Rating Rating Rating 4353 912828Y87 T 1.750 07/31/2024 U.S.Treasury Note 01/13/2022 01/14/2022 5,000,000.00 5,002,922.50 4,985,150.00 (17,772.50) 1.028 0.08 30 1.29% Aaa AA+ AA+ 4358 912828Y87 T 1.750 07/31/2024 U.S.Treasury Note 02/10/2022 02/11/2022 4,000,000.00 4,000,496.78 3,988,120.00 (12,376.78) 1.595 0.08 30 1.03% Aaa AA+ AA+ 4361 912828D56 T 2.375 08/15/2024 U.S.Treasury Note _._ 03/21/2022 03/22/2022 5,000,000.00 5,000,801.74 4,981,050.00 (19,751.74) 2.240 0.12 45 1.29% Aaa AA+ AA+ ..... .... ... ...... 0.25 91 .._1 28% Aaa A 4298 912828YH7 T 1.500 09/30//2024 U.S.Treasury Note 12/04/2019 12/OS/2019 5,000,000.00 4,998,863.15 4,951,150.00 (47713.15) 1.595. A+ AA+ 4350 912828YM6 T 1.500 10/31/2024 U.S.Treasury Note 12/30/2021 12/31/2021 3,000,000.00 3,005,718.09 2,961,480.00 (44,238.09) 0.920 0.33 122 0.77% Aaa AA+ AA+ 4376 91282CEU1 T 2.875 06/15/2025 U.S.Treasury Note 11/17/2022 11/18/2022 3,000,000.00 2,962,319.14 2,936,460.00 (25,859.14) 4.276 0.93 349 0.76% Aaa AA+ AA+ 4330 91282CA87 T 0.250 07/31/2025 U.S.Treasury Note 05/18/2021 05/19/2021 5,000,00000 4,980,533.25 4,748,250.00 (232,283.25) 0.615 1.05 395 1.28% Aaa AA+ AA+ ............ 4340 91282CAJ0 T 0.250 08/31/2025 U.S.Treasury Note 09/23/2021 09/27/2021 5,000,000.00 4972,149.58 4,730,650.00 (241,499.58) 0.735 1.14 426 1.28% Aaa AA+ AA+ 4351 9128284Z0 T 2.750 08/31/2025 U.S.Treasury Note 12/30/2021 12/31/2021 5,000,000.00 5,093,789.99 4,870,500.00 (223,289.99) 1.103 1.12 426 1.31% Aaa AA+ AA+ 4411 91282CHM6 T 4.500 07/15/2026 U.S.Treasury Note 03/11/2024 03/12/2024 5,000,000.00 5,011,268.77 4,978,500.00 (32,768.77) 4.380 1.88 744 1.29% Aaa AA+ AA+ 4341 91282CCP4 T 0.625 07/31/2026 U.S.Treasury Note 09/30/2021 09/30/2021 5,000,000.00 4,967,011.95 4,599,600.00 (367 411.95) 0.950 2.01 760 1.28% Aaa AA+ AA+ 4339 91282CCW9 T 0.750 08/31/2026 U.S.Treasury Note 09/23/2021 09/23/2021 1,000,000.00 997,038.69 919,690.00 (77 348.69) 0.890 2.09 791 0.26% Aaa AA+ AA+ 4342 91282CCW9 T 0.750 08/31/2026 U.S.Treasury Note 11/22/2021 11/23/2021 5,000,000.00 4,943,950.02 4,598,450.00 (345,500.02) 1.285 2.09 791 1.27% Aaa AA+ AA+ 4379 91282CEW7 T 3.250 06/30/2027 U.S.Treasury Note 12/28/2022 12/29/2022 5,000,000.00 4,898,019.77 4,824,400.00 (73,619.77) 4.000 2.80 1,094 1.26% Aaa AA+ AA+ 4406 91282CEW7 T 3.250 06/30/2027 U.S.Treasury Note 12/21/2023 12/22/2023 5,000,000.00 4,901,488.96 4,824,400.00 (77,088.96) 3.960 2.80 1,094 1.26% Aaa AA+ AA+ 4409 91282CFB2 T 2.750 07/31/2027 U.S.Treasury Note 01/18/2024 01/19/2024 5,000,000.00 4,810,783.55 4,747,650.00 (63133.55) 4.080 2.86 1,125 1.24% Aaa AA+ AA+ 4408 91282CHQ7 T 4.125 07/31/2028 U.S.Treasury Note 01/12/2024 01/16/2024 10,000,000.00 10,109,262.06 9,894,100.00 (215 162.06) 3.831 3.64 1,491 2.60% Aaa AA+ AA+ IU.S.Treasuries 81,000,000.00 80,656,417.98 78,539,600.00 (2,116,817.98) • 20.73% 4323 459056HV2 IBRD 1.500 08/28/2024 Intl Bank for Recon and Dev 04/21/2021 04/23/2021 5,000,000.00 5,008,438.84 4,968,450.00 (39,988.84) 0.425 0.16 58 1.29% Aaa AAA AAA 4338 4590581E4 IBRD 0.376 07/28/2025 Intl Bank for Recon and Dev 07/28/2021 07/30/2021 5,000,000.00 4,988,965.92 4,754,750.00 (234,215.92) 0.583 1.05 392 1.28% Aaa AAA AAA 4319 459058JL8 IBRD 0.500 10/28/2025 lot'I Bank for Recon and Dev 01/08/2021 01/12/2021 5,000,000.00 4,999,240.01 4,712,850.00 (286,390.01) 0.512 1.29 484 1.28% Aaa AAA AAA 4324 45906M2L4 IBRD 0.650 02/24/2026 Int'l Bank for Recon and Dev 04/28/2021 04/30/2021 5,000,000.00 4,982,285.24 4,658,600.00 (323,685.24) 0.870 1.60 603 1.28% Aaa AAA AAA 4413 45818WFN1 IADB 4.850 07/19/2027 Inter-American Development Bank 05/28/2024 05/29/2024 10,000,000.00 10,022,640.18 10,070,800.00 48,159.82 4.770 2.77 1,113 2.58% Aaa AAA AAA 4401 45818WEQ5 IADB 3.800 06/09/2028 Inter-American Development Bank 09/19/2023 09/21/2023 5,000,000.00 4,855,819.96 4,858,400.00 2,580.04 4.622 3.59 1,439 1.25% Ma AAA AAA 4402 459058KT9 IBRD 3.500 07/12/2028 Intl Bank for Recon and Dev 11/09/2023 11/13/2023 5,000,000.00 4,774,442.53 4,817,700.00 43,257.47 4.760 3.63 1,472 1.23% Aaa AAA AAA 4403 459058KT9 IBRD 3.500 07/12/2028 Intl Bank for Recon and Dev 12/04/2023 12/06/2023 5,000,000.00 4,846,094.11 4,817,700.00 (28,394.11) 4.350 3.63 1,472 1.25% Ma AAA AAA 4410 459058KW2 IBRD 4.625 08/01/2028 Intl Bank for Recon and Dev 01/23/2024 01/25/2024 5,000,000.00 5,091,309.96 5,022,450.00 (68,859.96) 4.130 3.61 1,492 1.31% Ma AAA AAA Supranational 50,000,000.00 49,569,236.75 48,681,700.00 (887,536.75) 12.74% 4380 3134GYCP5 FHLMC 5.000 07/23/2024 Freddie Mac 01/05/2023 01/23/2023 5,000,000.00 5,000,000.00 4,998.150.00 (1,850.00) 5.000 0.06 22 1.29% Aaa AA+ AA+ 4344 3130AQ3C5 FHLB 1.000 08/28/2024 Federal Home Loan Bank 12/01/2021 12/02/2021 4,000,000.00 . 4,000,000.00 3,970,320.00 (29,680.00) 1.000 0.16 58 1.03% Ma AA+ 4373 3133XVDG3 FHLB 4.375 09/13/2024 Federal Home Loan Bank 09/22/2022 09/23/2022 5,000,000.00 5,001,272.68 4,988,450.00 (12,822.68) 4.240 0.20 74 1.29% Aaa AA+ _..._....... a 4336 3130AMX16 FHLB 0.500 09/30/2024 Federal Home Loan Bank 06/17/2021 06/30/2021 5,000,000.00 5,000,000.00 4,938,650.60 (61,350.00) 0.500 0.25 91 1.29% Aaa AA+ 4346 3130AQD59 FHLB 1.000 09/30/2024 Federal Home Loan Bank 12/14/2021 12/30/2021 5,000,000.00 5,000,000.00 4,946,500.00 (53,500.00) 1.000 0.25 91 1.29% Aaa AA+ 4349 3130AQD59 FHLB 1.000 09/30/2024 Federal Home Loan Bank 12/22/2021 12/30/2021 5,000,000.00 5,000,000.00 4,946,500.00 (53,500.00) 1.000 0.25 91 1.29% Aaa AA+ 4334 3130AMW65 FHLB 0.500 12/30/2024 Federal Home Loan Bank 06/15/2021 06/30/2021 5,000,000.00 5,000,000.00 4,879,450.00 (120,550.00) 0.500 0.49 182 1.29% Ma AA+ 4332 3130AMQ62 FHLB 0.625 03/14/2025 Federal Home Loan Bank 05/26/2021 06/14/2021 5,000,000.00 5,000,000.00 4,838,200.00 (161,800.00) 0.625 0.68 256 1.29% Ma AA+ 4397 3130AWER7 FHLB 4.625 06/06/2025 Federal Home Loan Bank 06/14/2023 06/15/2023 3,000,000.00 2,999,109.49 2,984,730.00 (14,379.49) 4.659 0.90 340 0.77% Ma AA+ 4329 3135G04Z3 FNMA 0.500 06/17/2025 Fannie Mae 05/13/2021 05/14/2021 5,000,000.00 4,993,927.97 4,783,200.00 (210.727.97) 0.628 0.94 351 1.28% Aaa AA+ AA+ 4381 3135G04Z3 FNMA 0.500 06/17/2025 Fannie Mae 01/12/2023 01/13/2023 5,000,000.00 4,840,657.89 4,783,200.00 (57,457.89) 4.013 0.94 351 1.24% Aaa AA+ AA+ 4345 3130AQ558 FHLB 1.250 06/30/2025 Federal Home Loan Bank 12/08/2021 12/30/2021 4,650,000.00 4,650,000.00 4,465,255.50 (184 744.50) 1.250 0.97 364 1.20% Ma AA+ 4327 3130AMDL3 FHLB 0.800 07/25/2025 Federal Home Loan Bank 05/11/2021 05/25/2021 5,000,000 00 5,000,000.00 4,780,650.00 (219 350.00) 0.800 1.04 389 1.29% Ma AA+ 4360 3130AQT94 FHLB 1.600 08/28/2025 Federal Home Loan Bank 03/03/2022 03/04/2022 4,575,000.00 4,563,970.20 4,409,339.25 (154,630.95) 1.816 1.12 423 1.17% Ma AA+ 4331 3130AMQ54 FHLB 0.700 09/16/2025 Federal Home Loan Bank 05/26/2021 06/16/2021 5,000,000.00 5,000,000.00 4,747,000.00 (253,000.00) 0.700 1.18 442 1.29% Aaa AA+ 4318 3135GA2Z3 FNMA 0.560 11/17/2025 Fannie Mae 01/08/2021 01/11/2021 3,000,000.00 3,000,937.46 2,821,440.00 (179,497.46) 0.500 1.34 504 0.77% Ma AA+ AA+ 4320 3130AKN36 FHLB 0.525 01/15/2026 Federal Home Loan Bank 01/14/2021 01/15/2021 5,000,000.00 4,998,461.11 4,667,850.00 (330,611.11) 0.545 1.50 563 1.28% Ma AA+ 4321 3130AKN85 FHLB 0.550 01/20/2026 Federal Home Loan Bank 01/14/2021 01/20/2021 5,000,000 00 4,999,223.61 4,667.100.00 (332,123.61) 0.560 1.51 568 1.28% Aaa AA+ 4322 3130AKUS3 FHLB 0.500 01/28/2026 Federal Home Loan Bank 01/26/2021 01/28/2021 5,000,00000 5,000,000.00. 4,657,950.00 (342,050.00) 0.500 1.53 576 1.29% Aaa AA+ 4333 3130ALEY6 FHLB 0.800 03/04/2026 Federal Home Loan Bank 06/09/2021 06/10/2021 5,000,000.00 5,000,000.00 4,669,200.00 (330,800.00) 0.800 1.62 611 1.29% Aaa AA+ 4328 3130AMJN3 FHLB 1.030 05/26/2026,., Federal Home Loan Bank 05/12/2021 05/26/2021 5,000,000.00 5,000,000.00 4,646,800.00 (353,200.00) 1.030 1.84 694 1.29% Aaa AA+ 4335 3130AMFS6 FHLB 0.750 06/12/2026 Federal Home Loan Bank 06/16/2021 06/17/2021 5,000,000.00 4,988,284.12 4,623,750.00 (364,534.12) 0.873 1.89 711 1.28% Aaa AA+ 4388 3130AVWS7 FHLB 3.750 06/12/2026 Federal Home Loan Bank 05/08/2023 05/09/2023 3,000,000.00 2,997,373.61 2,943,540.00 (53,833.61) 3.796 1.85 711 0.77% Aaa AA+ 4398 3133EPNG6 FFCB 4.375 06/23/2026 Federal Farm Credit Bank 06/22/2023 06/23/2023 3,000,000.00 2,999,110.00 2,978,820.00 (20,290.00) 4.391 1.87 722 0.77% Aaa AA+ AA+ 4347 3130AQ7E7. FHLB 1.500 06/30/2026 Federal Home Loan Bank 12/14/2021 12/30/2021 5,000,000.00 5,000,887.65 4,682,650.00 (318,237.65) 1.339 1.92 729 129% Ma AA+ Report Run Date: Jul 19,2024 12 44 Reporting Period: Bond Holdings By Sector Report Portfolio:CITY 06/30/2024 City of Huntington Beach Accounting CUSIP Ticker Coupon Maturity Date Short Description Trade Date Settlement Par Value Book Value Market Value Gain/Loss Book Effective Days to (%)of Moodys 5&P Fitch ID Date Yield Duration Maturity Portfolio Rating Rating Rating 4384 3130AUMC5 FHLB 3.750 07/20/2026 Federal Home Loan Bank 01/17/2023 01/19/2023 5,000,000.00 5,000,000.00 4,898,650.00 (101,350.00) 3.750 1.91 749 1.29% Aaa AA+ ............ 4356 3130AQS79 FHLB 1.375 08/07/2026 Federal Home Loan Bank 01/27/2022 02/07/2022 5,000,000 00 5,000,000.00 4,737,050.00 (262.950.00) 1.375 2.00 767 1.29% Aaa AA+ 4386 3133EPGT6 FFCB 3.875 04/26/2027 Federal Farm Credit Bank 04/21/2023 04/26/2023 5,000,000.00 4,995,947.05 4,904,600.00 (91,347.05) 3.906 2.61 1,029 1.28% Aaa AA+ AA+ 4389 3133EPJP1 FFCB 3.625 05/12/2027 Federal Farm Credit Bank 05/08/2023 05/12/2023 5,000,000.00 4,990,083.78 4,869,600.00 (120,483.78) 3.700 2.66 1,045 1.28% Aaa AA+ AA+ 4392 3130AW4N7 FHLB 3.630 06/04/2027 Federal Home Loan Bank 05/16/2023 05/18/2023 5,000,000.00 5000,00000 4,864,300.00 ._. (135,700.00) 3.630 2.72 1,068 1.29% Aaa AA+ 4396 3133EPMV4 FFCB 4.125 06/15/2027 Federal Farm Credit Bank 06/09/2023 06/15/2023 5,000,000 00 4,999,298.06 4,936,800.00 (62,498.06) 4.130 2.74 1,079 1.28% Aaa AA+ AA+ 4385 3134GYPF3 FHLMC 4.750 07/12/2027 Freddie Mac 04/21/2023 04/24/2023 3,300,000.00 3,296,442.39 3,274,821.00 (21,621.39) 4.791 1.52 1,106 0.85% Ma AA+ AA+ 4405 3130AWWN6 FHLB 4.500 09/10/2027. Federal Home Loan Bank 12/04/2023 12/05/2023 4,455,000.00 4,469,808.62 4,438,382.85 (31,425.77) 4.383 2.89 1,166 1.15% Ma AA+ 4395 3130AWC24 FHLB 4.000 06/09/2028 Federal Home Loan Bank 06/09/2023 06/13/2023 _ 5,000,000.00 5,003,631.85 4,933,500.00 (70,131.85) 3.979 3.58 1,439 1.29% Ma AA+ 4399 3130AWC24 FHLB 4.000 06/09/2028.,. Federal Home Loan Bank 06/26/2023 06/27/2023 5,000,000.00 4997,81173 4,933,500.00 (64,311.73) 4.012 3.58 1,439 1.28% Aaa AA+ 4400 31422X5U2 FAMCA 5.100 08/07/2028 Farmer Mac 08/02/2023 08/07/2023 2,000,00000 2,000,000.00 1,983,380.00 (16,620.00) 5.100 1.90 1,498 0.51% I U.S.Agencies 164,980,000.00 164,786,239.28 159,593,278.60 (5,192,960.68) 42.35% 4325 91159HHX1 USB 2.400 07/30/2024 US Bank 04/28/2021 04/30/2021 3,809,000.00 3,814,532.49 3,798,410.98 (16,121.51) 0.528 0.08 29 0.98% A3 A A 4343 14913R2P1 CAT 0.600 09/13/2024 Caterpillar 11/30/2021 12/02/2021_ 5,000,000.00 4,996,256 14 4,950,200.00 (46,056.14) 0.980 0.20 74 1.28% A2 A A+ 4371 459200K59 IBM 4.000 07/27/2025 IBM 08/09/2022 08/11/2022 6,000,000.00 6,011,406.19 5,914,200.00 (97,206.19) 3.810 1.02 391 1.55% A3 A- 4372 931142EW9 WMT 3.900 09/09/2025 Walmart 09/20/2022 09/22/2022 5,000,000.00 4,986,121.09 4,928,250.00 (57,871.09) 4.150 1.13 435 1.28% Aa2 AA AA 4382 717081DV2 PFE 2.750 06/03/2026 Pfizer Inc 01/13/2023 01/18/2023 5000,000.00 4,876,294.32 4,781,350.00 (94,944.32) 4.142 1.83 702 1.25% _A2 A WD 4375 110122CN6 BMY 3.200 06/15/2026 Bristol-Myers Squibb 11/14/2022 11/16/2022 5,000,000.00 4,885,47029 4,820,350.00 (65,120.29) 4.480 1.84 714 1.26% ) A2 A 4390 931142EM1 WMT 3.050 07/08/2026 Walmart 05/11/2023 05/15/2023 4,257,000.00 4,200,511.68 4,113,964.80 (86,546.88) 3.752 1.87 737 1.08% Aa2 PA AA 4391 904764AU1 UNANA 2.000 07/28/2026 Unilever 05/11/2023 05/15/2023 2,505,000.00 2,419,926.16 2,354,148.90 (65,777.26) 3.752 1.97 757 0.62% Al A+ WD 4404 037833DN7 AAPL 2.050 09/11/2026 Apple 12/04/2023 12/06/2023 5,000,000.00 4,741,562.81 4,700,450.00 (41,112.81) 4.583 2.09 802 1.22% Ma AA+ 4407 713448DN5 PEP 2.375 10/06/2026 Pepsi 12/21/2023 12/26/2023._ 5,000,000.00 4,799,306.25 4,726,000.00 (73,306.25) 4.273 2.14 827 1.23% Al A+ WD 4412 24422EX60 DE 4.950 07/14/2028 John Deere 03/25/2024 03/27/2024 5,000,00000 5,051,751.97 5,005,250.00 (46,501.97) 4.662 3.53 1,474 1.30% Al A A+ Corporates 51,571,000.00 50,783,139.39 50,092,574.68 (690,564.71) 13.05% Bond Holdings 347,551,000.00 345,795,033.40 336,907,153.28 (8,887,880.12) 88.88% Report Run Date: Jul 19,2024 13 45 11NGTp�B Statement of Cash Receipts and Disbursements and ��£ ._ � Summary of Cash by Fund 0`v' ,.e llo%' City Treasurer's Office couNTY GP,r June 2024 Cash Receipts and Disbursements May 2024 June 2024 Receipts General Fund Property Tax $ 18,152,473 $ 543,241 Local Sales Tax 4,760,809 3,681,592 Public Safety Sales Tax 205,869 284,457 Transient Occupancy Tax(TOT) 1,224,297 1,387,683 Utility Users Tax(UUT) 1,919,726 1,674,744 Other Revenue 5,892,158 5,026,618 Total General Fund Revenue 32,155,333 12,598,334 Total All Other Funds Revenue 22,894,140 18,374,339 Total Receipts $ 55,049,473 $ 30,972,674 Disbursements General Fund Personnel Services (18,341,172) (12,959,514) Operating Expenses (4,160,884) (3,465,058) Capital Expenditures - - Non-Operating Expenses (1,261,983) (962,675) Total General Fund Disbursements (23,764,039) (17,387,247) Total All Other Funds Disbursements (19,094,488) (38,065,071) Total Disbursements (42,858,527) (55,452,319) Net Change in Cash Flow $ 12,190,946 $ (24,479,645) Summary of Cash by Fund May 2024 June 2024 General Fund $ 160,402,282 $ 155,613,368 General Fund Other 5,104,628 5,094,155 Capital Projects Funds 41,513,503 39,818,953 Debt Service Funds 30,070,997 12,009,066 Enterprise Funds 85,549,942 86,695,176 Trust and Agency Funds 16,873,163 20,187,203 Internal Service Funds 48,800,219 43,993,337 Special Revenue Funds 46,130,350 46,554,181 General Ledger Cash Balances * $ 434,445,084 $ 409,965,439 Total cash will differ from investment portfolio total due to outstanding checks and/or other timing differences. Note: Above information was obtained from the City's accounting system records.The above information includes receipts from maturing investments and payments for purchased investments in the city investment portfolio.This statement is prepared in compliance with the City's Charter. 14 46 ...0 xaro Portfolio Summary >o� ., ,,,,,ys,� City of Huntington Beach i'i Portfolio:CITY s' `' Reporting Date(FY2024) y6e "TY t'N., 05/01/2024-05/31/2024 Full Accrual Basis Par Value Period Earnings Summary(31 Days) Fiscal YTD Summary(336 Days) Period Transactions Net Period Earnings $1,012,056.22 Net Period Earnings $9,043,033.35 Redemptions 0 Total Par Value $428,997,477.84 , Last FY Period Net Earnings $705,575.05 Last FY Period Net Earnings $5,165,800.01 Purchases 1 Avg Daily Book Balance $418,365,294.00 Avg Daily Book Balance $372,710,858.28 Total Activity 1 Net Effective Annual Return 2.894% Net Effective Annual Return 2.646% Fiscal YTD Transactions Redemptions 12 Purchases 14 Book Value Total Activity 26 Total Book Value $427,177,693.76 City Portfolio Certification I certify that this report and the corresponding pages attached accurately reflect all portfolio combined investments and conforms with all California state statutes and the Huntington Beach investment policy filed on December 19,2023.The investment program herein shown provides sufficient cash flow liquidity to meet the next six month's obligations.Market values are provided by US Bank via Interactive Data Corp(IDC) The City Portfolio uses a 12 month moving average of the 1.5Yr Treasury for comparison purposes.This period,that rate is equal to:4.970% Air _ City Treasurer __ 05/31/2024 Alisa Backstrom Title Date Portfolio Investments Market Value Par Value Book Value Market Value Book Value Book Yield Book Yield Days to %of Port Contribution Maturity Total Market Value $417,152,788.42 Cash/Money Market $16,006,903.09 $16,006,903.09 $16,006,903.09 3.75% 5.18% 0.19% 1 Local Govt Inv Pools(LGIP) $38,439,574.75 $38,439,574.75 $38,439,574.75 9.00% 5.43% 0.49% 1 U.S.Treasuries $93,000,000.00 $92,642,861.03 $90,195,980.00 21.69% 2.39% 0.52% 591 Supranational $50,000,000.00 $49,563,465.04 $48,430,800.00 11.60% 2.97% 0.34% 990 U.S.Agencies $174,980,000.00 $174,770,978.97 $169,090,667.70 40.91% 2.27% 0.93% 599 Corporates $56,571,000.00 $55,753,910.87 $54,988,862.88 13.05% 3.40% 0.44% 603 Total $428,997,477.84 $427,177,693.76 $417,152,788.42 100.00% 2.92% 567 15 47 Reporting Period: Cash By Structure Report Portfolio:CITY 05/31/2024 City of Huntington Beach Accounting ID Ticker Pool Description Type Par Value Book Value Market Value Rate %of Portfolio 104 FUZXX First American Treasury Obligations Cash/Money Market 16,006,903.09 16,006,903.09 16,006,903.09 5.180 3.75% Cash/Money Market Total 16,006,903.09 16,006,903.09 16,006,903.09 3.75% 003 CAMP California Asset Management Program LGIP 38,439,574.75 38,439,574.75 38,439,574.75 5.430 9.00% LGIP Total 38,439,574.75 38,439,574.75 38,439,574.75 9.00% Report Run Date: Jul 19,2024 16 48 Reporting Period: Bond Redemption Activity Report Portfolio:CITY 05/31/2024 City of Huntington Beach Accounting ID Transaction Type Cusip Description r Price Settlement Posted Date Par Value Principal Accrued Interest Total Date Activity Total 0.00 0.00 0.00 0.00 Report Run Date: Jul 19,2024 17 49 Reporting Period: Bond Purchase Activity Report Portfolio:CITY 05/31/2024 City of Huntington Beach ^Accounting ID Transaction Type Cusip Description Price Settlement Date Posted Date Par Value Principal Accrued Interest Total 4413 Buy 45818WFN1 IADB 4.850 07/19/2027 100.23300 05/29/2024 05/29/2024 10,000,000.00 10,023,300.00 45,805.56 10,069,105.56 Activity Total 10,000,000.00 10,023,300.00 45,805.56 10,069,105.56 Report Run Date: Jul 19,2024 18 50 Reporting Period: Bond Interest Received Report Portfolio:CITY 05/31/2024 City of Huntington Beach Accounting ID Transaction Type Cusip Description Date Posted Interest Received Purchased Interest Net Interest Adjustment 4389 Interest Income 3133EPJP1 FFCB 3.625 05/12/2027 05/13/2024 90,625.00 90 625.00 4318 Interest Income 3135GA2Z3 FNMA 0.560 11/17/2025 05/17/2024 8,400.00 8,400.00 4327 Interest Income 3130AMDL3 FHLB 0.800 07/25/2025 05/28/2024 20,000.00 20,000.00 4328 Interest Income 3130AMJN3 FHLB 1.030 05/26/2026 05/28/2024 25,750.00 25,750.00 Activity Total 144,775.00 0.00 144,775.00 • Report Run Date: Jul 19,2024 19 51 Reporting Period: Bond Holdings By Sector Report Portfolio:CITY 05/31/2024 City of Huntington Beach Accounting CUSIP Ticker Coupon Maturity Date Short Description Trade Date Settlement Par Value Book Value Market Value Gain/Loss Book Effective Days to (%)of Moodys 5&P Fitch ID Date Yield Duration Maturity Portfolio Rating Rating Rating 4364 9128286Z8 T 1.750 06/30/2024 U.S_Treasury Note 04/29/2022 05/02/2022 7,000,000.00 6,994,739.99 6,981,170.00 (13,569.99) 2.730 0.08 29 1.64% Aaa AA+ Ma 4370 912828XX3 T 2.000 06/30/2024 U.S.Treasury Note 05/26/2022 05/27/2022 5,000,000.00 4,998,223.04 4,987,450.00 (10,773.04) 2.462 0.08 29 1.17% Aaa 4.4+ AA+ 4353 912828Y87 T 1.750 07/31/2024 U.S.Treasury Note 01/13/2022 01/14/2022 5,000,000 00 5,005,844.99 4,970,700.00 (35,144.99) 1.028 0.16 60 1.17% Aaa AA+ AA+ 4358 912828Y87 T 1.750 07/31/2024 U.S.Treasury Note 02/10/2022 02/11/2022 4,000,000.00 4,000,993.56 3,976,560.00 (24,433.56) 1.595 0.16 60 0.94% Aaa AA+ AA+ 4361 912828D56 T 2.375 08/15/2024 U.S.Treasury Note 03/21/2022 03/22/2022 5,000,000.00 5,001,336.23 4,969,750.00 (31,586.23) 2.240 0.20 75 1.17% Aaa AA+ AA+ 4298 912828YH7 T 1.500 09/30/2024 U.S.Treasury Note 12/04/2019 12/05/2019 5,000,000 00 4,998,488.36 4,938,000.00 (60,488.36) 1.595 0.33 121 1.17% Aaa AA+ AA+ 4350 912828YM6 T 1.500 10/31/2024 U.S.Treasury Note 12/30/2021 12/31/2021 3,000,000.00 3,007,124.17 2,953,980.00 (53 144.17) 0.920 0.41 152 0.70% Aaa AA+ AA+ 4376 91282CEU1 T 2.875 06/15/2025 U.S.Treasury Note 11/17/2022 11/18/2022 3,000,000.00 2,959,080.10 2,930,760.00 (28,320.10) 4.276 0.99 379 0.69% Aaa AA+ AA+ 4330 91282CAB7 T _ _0.250 07/31/2025 U.S.Treasury Note 05/18/2021 05/19/2021 5,000,000.00 4,979,054.76 4,729,300.00 (249,754.76) 0.615 1.13 425 1.17% Aaa 4.4+ 4.4+ 4340 91282C410 T 0.250 08/31/2025 U.S.Treasury Note 09/23/2021 09/27/2021 5,000,000.00 4,970,188.28 4,710,550.00 (259,638.28) 0.735 1.22 456 1.16% Aaa AA+ AA+ 4351 9128284Z0 T 2.750 08/31/2025 U.S.Treasury Note 12/30/2021 12/31/2021 5,000,000.00 5,100,394.92 4,858,800.00 (241,594.92) 1.103 1.20 456 1.19% Aaa AA+ AA+ 4411 91282CHM6 T 4.500 07/15/2026 U.S.Treasury Note 03/11/2024 03/12/2024 5,000,000 00 5,011,723.16 4,965,650.00 (46,073.16) 4.380 1.96 774 1.17% Aaa AA+ AA+ 4341 91282CCP4 T 0.625 07/31/2026 U.S.Treasury Note 09/30/2021 09/30/2021 5,000,000.00 4,965,709.79 4,574,400.00 (391,309.79) 0.950 2.09 790 1.16% Aaa AA+ AA+ 4339 91282CCW9 T 0.750 08/31/2026 U.S.Treasury Note 09/23/2021 09/23/2021 1,000,000.00 996,926.37 914,610.00 (82,316.37) 0.890 2.17 821 0.23% Aaa AA+ AA+ 4342 91282CCW9 T 0.750 08/31/2026 U.S.Treasury Note 11/22/2021 11/23/2021 5,000,000.00 4,941,824.23 4,573,050.00 (368.774.23) 1.285 2.17 821 1.16% Aaa AA+ AA+ 4379 91282CEW7 T 3.250 06/30/2027 U.S.Treasury Note 12/28/2022 12/29/2022 5,000,000.00 4,895,223.24 4,801,150.00 (94,073.24) 4.000 2.83 1,124 1.15% Aaa AA+ AA+ 4406 91282CEW7 T 3.250 06/30/2027 U.S.Treasury Note 12/21/2023 12/22/2023 5,000,000.00 4,898,787.56 4,801,150.00 (97,637.56) 3.960 2.83 1,124 1.15% Aaa AA+ AA+_ 4409 91282CFB2 T 2.750 07/31/2027 U.S.Treasury Note 01/18/2024 01/19/2024 5,000,000.00 4,805,737.78 4,722,650.00 (83,087.78) 4.080 2.94 1,155 1.12% Aaa AA+ AA+ 4408 91282CHQ7 T 4.125 07/31/2028 U.S.Treasury Note 01/12/2024 01/16/2024 10,000,000 00 10,111,460.49 9,836,300.00 (275 160.49) 3.831 3.71 1,521 2.37% Aaa AA+ AA+ U.S.Treasuries 93,000,000.00 92,642,861.03 90,195,980.00 (2,446,881.03) 21.69% 4323 459056HV2 IBRD 1.500 08/28/2024 Intl Bank for Recon and Dev 04/21/2021 04/23/2021 5,000,000.00 5,012,880.33 4,953,350.00 (59,530.33) 0.425 0.24 88 1.17% Ma AAA AAA 4338 4590581E4 IBRD 0.376 07/28/2025 Intl Bank for Recon and Dev 07/28/2021 07/30/2021 5,000,000.00 4,988,110.57 4732,650.00 (255460.57) 0.583 1.13 422 1.17% Ma AAA AAA .. a 4319 459058118 IBRD 0.500 10/28/2025 Intl Bank for Recon and Dev 01/08/2021 01/12/2021 5,000,000.00 4,999,192.21 4,689,000.00 (310,192.21) 0.512 1.37 514 1.17% Aaa AAA AAA 4324 45906M2L4 IBRD 0.650 02/24/2026 Int')Bank for Recon and Dev 04/28/2021 04/30/2021 5,000,000.00 4,981,389.04 4,626,100.00 (355,289.04) 0.870 1.68 633. 1.17%. Aaa AAA AAA 4413 45818WFN1 IADB 4.850 07/19/2027 Inter American Development Bank 05/28/2024 05/29/2024 10,000,000 00 10,023,258 76 10 034,700.00 11441 24 4.770 2.85 1,143 2.35% Ma AAA AAA 4401 45818WEQ5 IADB 3.800 06/09/2028 Inter-American Development Bank 09/19/2023 09/21/2023 5,000,000.00 4,852,769.61 4,828,450.00 (24,319.61) 4.622 3.59 1,469 1.14% Aaa AAA AM 4402 459058KT9 IBRD 3.500 07/12/2028 Int'l Bank for Recon and Dev 11/09/2023 11/13/2023 5,000,000.00 4,769,779.04 4,785,600.00 15,820.96 4.760 3.70 1,502 1.12% Aaa AAA AAA 4403 459058KT9 IBRD 3.500 07/12/2028 Int')Bank for Recon and Dev 12/04/2023 12/06/2023 5,000,000.00 4,842,912.05 4,785,600.00 (57 312.05) 4.350 3.70 1,502 1.13% Aaa AAA AAA 4410 459058KW2 IBRD 4.625 08/01/2028 Int'l Bank for Recon and Dev 01/23/2024 01/25/2024 5,000,000.00 5,093,173.43 I 4,995,350.00 (97,823.43) 4.130 3.68 1,522 1.19% Aaa AAA AAA Supranational 50,000,000.00 49,563,465.04 48,430,800.00 (1,132,665.04) 11.60% 4378 3130ATVC8 FHLB 4.875 06/14/2024 _ Federal Home Loan Bank 12/27/2022 _12/28/2022 5,000,000.00 5,000,216.25 4,999,250.00 (966.25) 4.740 0.04 13 1.17% Aaa _AA+ 4348 3130AQD42 FHLB 0.920 06/28/2024 Federal Home Loan Bank 12/14/2021 12/28/2021 5,000,000.00 5,000,000.00 4,984,550.00 (15,450.00) 0.920 0.07 27 1.17% Aaa AA+ 4380 3134GYCP5 FHLMC 5.000 07/23/2024 Freddie Mac 01/05/2023 01/23/2023 5,000,000.00 5,000,000.00 4,996,500.00 (3,500.00) 5.000 0.14 52 1.17% Aaa AA+ AA+ 4344 3130AQ3C5 FHLB 1.000 08/28/2024 Federal Home Loan Bank 12/01/2021 12/02/2021 4,000,000.00 4,000,000.00 3,957,320.00 (42,680.00) 1.000 0.24 88 0.94% Aaa AA+ 4373 3133XVDG3 FHLB 4.375 09/13/2024 Federal Home Loan Bank 09/22/2022 09/23/2022 5,000,000.00 5,001,802.96 4,983,600.00 (18,202.96) 4.240 0.28 104 1.17% Ma AM- 4336 3130AMXJ6 FHLB 0.500 09/30/2024 Federal Home Loan Bank 06/17/2021 06/30/2021 5,000,000.00 5,000,000.00 4,917,350.00 (82,650.00) 0.500 0.32 121 1.17% Ma AA+ 4346 3130AQD59 FHLB 1.000 09/30/2024 Federal Home Loan Bank 12/14/2021 12/30/2021 5,000,000.00 5,000,000.00 4,927,400.00 (72,600.00) 1.000 0.32 121 1.17% Aaa AA+ 4349 3130AQD59 FHLB 1.000 09/30/2024 Federal Home Loan Bank 12/22/2021 12/30/2021 5,000,000.00 5,000,000.00 4,927,400.00 (72,600.00) 1.000 0.32 121 1.17% Aaa AA+ 4334 3130AMW65 FHLB 0.500 12/30/2024 Federal Home Loan Bank 06/15/2021 06/30/2021 5,000,000.00 5,000,000.00 4,864,500.00 (135,500.00) 0.500 0.57 212 1.17% Aaa AA+ 4332 3130AMQ62 FHLB 0.625 03/14/2025 Federal Home Loan Bank 05/26/2021 06/14/2021 5,000,000.00 5,000,000.00 4,823,950.00 (176,050.00) 0.625 0.76 286 1.17% Ma AA+ 4397 3130AWER7 FHLB 4.625 06/06/2025 Federal Home Loan Bank 06/14/2023 06/15/2023 3,000,000.00 2,999,029.75 2,983,410.00 (15,619.75) 4.659 0.96 370 0.70% Aaa AA+ 4329 3135G04Z3 FNMA 0.500 06/17/2025 Fannie Mae 05/13/2021 05/14/2021 5,000,000.00 4,993,401.49 4,767,950.00 (225,451.49) 0.628 1.02 381 1.17% Aaa AA+ AA+ 4381 3135G04Z3 FNMA 0.500 06/17/2025 Fannie Mae 01/12/2023 01/13/2023 5,000,000.00 4,826,842.11 4,767,950.00 (58,892.11) 4.013 1.02 381 1.13% Aaa AA+ AA+ 4345 3130AQ558 FHLB 1.250 06/30/2025 Federal Home Loan Bank 12/08/2021 12/30/2021 4,650,000.00 4650,000.00 4,470,649.50 (179,350.50) 1.250 1.05 394 1.09% Aaa AA+ 4327 3130AMDL3 FHLB 0.800 07/25/2025 Federal Home Loan Bank 05/11/2021 05/25/2021 5,000,000.00 5,000,000.00 4,765,550.00 (234,450.00) 0.800 1.12 419 1.17% Ma AA+ 4360 3130AQT94 FHLB 1.600 08/28/2025 Federal Home Loan Bank 03/03/2022 03/04/2022 4,575,000.00 4,563,176.69 4,396,026.00 (167,150.69) 1.816 1.20 453 1.07% Ma AA+ 4331 3130AMQ54 FHLB 0.700 09/16/2025 Federal Home Loan Bank 05/26/2021 06/16/2021 5,000,000.00 5,000,000.00 4,731,350.00 (268,650.00) 0.700 1.26 472 1.17% Aaa AA+ 4318 3135GA2Z3 FNMA 0.560 11/17/2025 Fannie Mae 01/08/2021 01/11/2021 3,000,000.00 3,000,994.16 2,812,080.00 (188,914.16) 0.500 1.42 534 0.70% Aaa AA+ AA+ 4320 3130AKN36 FHLB 0.525 01/15/2026 Federal Home Loan Bank 01/14/2021 01/15/2021 5,000,000.00 4,998,377.78 4,649,650.00 (348,727.78) 0.545 1.58 593 1.17% Aaa AA+ 4321 3130AKN85 FHLB 0.550 01/20/2026 Federal Home Loan Bank 01/14/2021 01/20/2021 5,000,000.00 4,999,181.94 , 4,648,900.00 (350,281.94) 0.560 1.59 598 1.17% Aaa AA+ 4322 3130AKU53 FHLB 0.500 01/28/2026 Federal Home Loan Bank 01/26/2021 01/28/2021 5,000,000.00 5,000,000.00 4,635,800.00 (364,200.00) 0.500 1.61 606 1.17% Aaa AA+ 4333 3130ALEY6 FHLB 0.800 03/04/2026 Federal Home Loan Bank 06/09/2021 06/10/2021 5,000,000.00 5,000,000.00 4,650,350.00 (349,650.00) 0.800 1.70 641 1.17% Aaa AA+ 4328 3130AMJN3 FHLB 1.030 05/26/2026 Federal Home Loan Bank 05/12/2021 05/26/2021 5,000,000.00 5,000,000.00 4,635,100.00 (364,900.00) 1.030 1.92 724 1.17% Aaa 4.4+ Report Run Date: Jul 19,2024 20 52 Reporting Period: Bond Holdings By Sector Report Portfolio:CITY 05/31/2024 City of Huntington Beach Accounting CUSIP Ticker Coupon Maturity Date Short Description Trade Date Settlement Par Value Book Value Market Value Gain/Loss Book Effective Days to (%)of Moodys S&P Fitch ID Date Yield Duration Maturity Portfolio Rating Rating Rating 4335 3130AMF56 FHLB 0.750 06/12/2026 Federal Home Loan Bank 06/16/2021 06/17/2021 5,000,000.00 4,987,782.73 4,604,100.00 (383 682.73) 0.873 1.96 741 1.17% Aaa AA+ 4388 3130AVWS7 FHLB 3.750 06/12/2026 Federal Home Loan Bank 05/08/2023 05/09/2023 3,000,000.00 2,997,261 21 2,937,210.00 (60,051.21) 3.796 1.89 741 0.70% Aaa AA+ 4398 3133EPNG6 FFCB 4.375 06/23/2026 Federal Farm Credit Bank 06/22/2023 06/23/2023 3,000,000.00 2,999,072.50 2,969,280.00 (29,792.50) 4.391 1.90 752 0.70% Aaa AA+ AA+ 4347 3130AQ7E7 FHLB 1.500 06/30/2026 Federal Home Loan Bank 12/14/2021 12/30/2021 5,000,000.00 5,000,924 69 4,664,800.00 (336,124.69) 1.339 1.99 759 1.17% Aaa AA+ 4384 3130AUMC5 FHLB 3.750 07/20/2026 Federal Home Loan Bank 01/17/2023 01/19/2023 5,000,000.00 5,000,000.00 4,886,800.00 (113,200.00) 3.750 1.99 779 1.17% Aaa AA+ 4356 3130AQS79 FHLB 1.375 08/07/2026 Federal Home Loan Bank 01/27/2022 02/07/2022 5.000,000.00 5,000,000.00 4,717.400.00 (282,600.00) 1.375 2.08 797 1.17% Aaa AA+ 4386 3133EPGT6 FFCB 3.875 04/26/2027 Federal Farm Credit Bank 04/21/2023 04/26/2023 5,000,000.00 4,995,827.26 4,889,300.00 (106,527.26) 3.906 2.69 1059 1.17% Aaa AM. AA+ 4389 3133EPJP1 FFCB 3.625 05/12/2027 Federal Farm Credit Bank 05/08/2023 05/12/2023 5,000,000.00 4,989,795.24 4,854,400.00 (135 395.24) 3.700 2.74 1,075 1.17% Aaa AA+ AA+ 4392 3130AW4N7 FHLB 3.630 06/04/2027 Federal Home Loan Bank 05/16/2023 05/18/2023 5,000,000.00 5,000,000.00 4,849,350.00 (150,650.00) 3.630 2.75 1,098 1.17% Aaa AA+ 4396 3133EPMV4 FFCB 4.125 06/15/2027 Federal Farm Credit Bank 06/09/2023 06/15/2023 5,000,000 00 4,999,278 26 4,920,900.00 (78 378.26) 4.130 2.76 1,109 1.17% Aaa AA+ AA+ 4385 3134GYPF3 FHLMC 4.750 07/12/2027 Freddie Mac 04/21/2023 04/24/2023 3,300,000.00 3,296,344.57 3,267,957.00 (28,387.57) 4.791 1.62 1,136 0.77% Aaa AA+ AA+ 4405 3130AWWN6 FHLB 4.500 09/10/2027 Federal Home Loan Bank 12/04/2023 12/05/2023 4,455,000.00 4,470,195.27 4,434,685.20 (35510.07) 4.383 2.97 1,196 1.05% Aaa AA+ 4395 3130AWC24 FHLB 4.000 06/09/2028 Federal Home Loan Bank 06/09/2023 06/13/2023 5,000,000.00 5,003,708.69 4,907,800.00 (9590869) 3.979 3.59 1,469 1.17% Aaa AA+ 4399. 3130AWC24 FHLB 4.000 06/09/2028 Federal Home Loan Bank 06/26/2023 06/27/2023 5,000,000.00 4,997,765.43 4,907,800.00 (89965.43) 4.012 3.59 1,469 1.17% Aaa AA+ 4400 31422X5U2 FAMCA 5.100 08/07/2028 Farmer Mac 08/02/2023 08/07/2023 2,000,000_00 2,000,000.00 . 1,982,300.00 (17,700.00) 5.100 1.99 1,528 0.47% U.S.Agencies 174,980,000.00 174,770,978.97 169,090,667.70 (5,680,311.27) 40.91% 4355 67066GAL8 NVDA 0.584 06/14/2024 Nvidia 01/20/2022 01/24/2022 5,000,000.00 4,998,818.66 4,987,450.00 (11,368.66) 1.250 0.04 13 1.17% Aa3 AA- 4325 91159HHX1 USB 2.400 07/30/2024 US Bank 04/28/2021 04/30/2021 3,809,000.00 3,820,255.76 3,789,002.75 (31,253.01) 0.528 0.16 59 0.89% A3 A A 4343 14913R2P1 CAT 0.600 09/13/2024 Caterpillar 11/30/2021 12/02/2021 5,000,000.00 4,994,696.20 4,932,150.00 (62,546.20) 0.980 0.28 104 1.17% A2 A A+ 4371 459200KS9 IBM 4.000 07/27/2025 IBM 08/09/2022 08/11/2022 6,000,000.00 6,012,292.68 5,910,000.00 (102,292.68) 3.810 1.10 421 1.41% A3 A- 4372 931142EW9 WMT 3.900 09/09/2025 Walmart 09/20/2022 09/22/2022 5,000,000.00 4,985,148.27 4,927,650.00 (57,498.27) 4.150 1.21 465 1.17% Aa2 AA AA 4382 717081DV2 PFE 2.750 06/03/2026 Pfizer Inc 01/13/2023 01/18/2023 5,000,000.00 4,870,931.36 4,784,000.00 (86,931.36) 4.142 1.89 732 1.14% A2 A WD 4375 110122CN6 BMY 3.200 06/15/2026 Bristol-Myers Squibb 11/14/2022 11/16/2022 5,000,000.00 4,880,589.76 4,811,900.00 (68,689.76) 4.480 1.89 744 1.14% A2 A 4390 931142EM1 WMT 3.050 07/08/2026 Walmart 05/11/2023 05/15/2023 4,257,000.00 4,198,180.66 4,103,492.58 (94,688.08) 3.752 1.95 767 0.98% Aa2 ' AA AA 4391 904764AU1 UNANA 2.000 07/28/2026 Unilever 05/11/2023 05/15/2023 2,505,000.00 2,416,509.54 2,350,967.55 (65,541.99) 3.752 2.05 787 0.57% Al A+ WD 4404 037833DN7 AAPL 2.050 09/11/2026 Apple 12/04/2023 12/06/2023 5,000,000.00 4,731,748.74 4,687,200.00 (44,548.74) 4.583 2.17 832 1.11% Aaa AA+ 4407 7134480N5 PEP 2.375 10/06/2026 Pepsi 12/21/2023 12/26/2023 5,000,000.00 4,791,918.75 4,713,100.00 (78818.75) 4.273 2.22 857 1.12% Al A+ WD 4412 24422EX80 __.DE 4.950 07/14/2028 John Deere 03/25/2024 03/27/2024 5,000,000.00 5,052,820.49 4,991,950.00 (60,870.49) 4.662 3.60 1,504 1.18% Al A A+ Corporates - J 56,571,000.00 55,753,910.87 54,988,862.88 (765,047.99) 13.05% • Bond Holdings I 374,551,000.00 372,731,215.92 362,706,310.58 (10,024,905.34) 87.25% I Report Run Date: Jul 19,2024 21 53 1°!'oNtrO?��\ Statement of Cash Receipts and Disbursements and • Summary of Cash by Fund *a;,. He �o/�, City Treasurer's Office May 2024 Cash Receipts and Disbursements April 2024 May 2024 Receipts General Fund Property Tax $ 22,852,792 $ 18,152,473 Local Sales Tax 3,372,318 4,760,809 Public Safety Sales Tax 216,280 205,869 Transient Occupancy Tax(TOT) 1,524,811 1,224,297 Utility Users Tax(UUT) 1,846,676 1,919,726 Other Revenue 8,768,017 5,892,158 Total General Fund Revenue 38,580,895 32,155,333 Total All Other Funds Revenue 17,981,968 22,894,140 Total Receipts $ 56,562,863 $ 55,049,473 Disbursements General Fund Personnel Services (12,314,628) (18,341,172) Operating Expenses (4,021,838) (4,160,884) Capital Expenditures - - Non-Operating Expenses (65,934) (1,261,983) Total General Fund Disbursements (16,402,400) (23,764,039) Total All Other Funds Disbursements (14,906,182) (19,094,488) Total Disbursements (31,308,582) (42,858,527) Net Change in Cash Flow $ 25,254,281 $ 12,190,946 Summary of Cash by Fund April 2024 May 2024 General Fund $ 149,601,480 $ 157,992,774 General Fund Other 5,083,679 5,173,039 Capital Projects Funds 45,849,522 41,007,435 Debt Service Funds 28,790,903 29,793,692 Enterprise Funds 83,529,012 84,692,615 Trust and Agency Funds 12,537,646 16,314,220 Internal Service Funds 45,739,512 48,298,793 Special Revenue Funds 45,679,524 45,729,654 General Ledger Cash Balances * $ 416,811,277 $ 429,002,223 Total cash will differ from investment portfolio total due to outstanding checks and/or other timing differences. Note: Above information was obtained from the City's accounting system records.The above information includes receipts from maturing investments and payments for purchased investments in the city investment portfolio.This statement is prepared in compliance with the City's Charter. 22 54 pl.��yar�,,\ Portfolio Summary (..\,_ 44,�,.. +A,, p City of Huntington Beach 'g Portfolio:CITY 9µ..'',4� Reporting Date:(FY2024) yCes`:"''.:.'nrY J�4'+' 04/01/2024-04/30/2024 Full Accrual Basis Par Value Period Earnings Summary(30 Days) Fiscal YTD Summary(305 Days) Period Transactions Net Period Earnings $911,251.90 Net Period Earnings $8,030,977.13 Redemptions 0 Total Par Value $417,765,581.55 Last FY Period Net Earnings $584,762.41 Last FY Period Net Earnings $4,460,224.96 Purchases 0 Avg Daily Book Balance $398,096,266.61 Avg Daily Book Balance $368,145,414.71 Total Activity 0 Net Effective Annual Return 2.829% Net Effective Annual Return 2.623% Fiscal YTD Transactions Redemptions 12 Purchases 13 Book Value Total Activity 25 Total Book Value $415,856,137.97 City Portfolio Certification I certify that this report and the corresponding pages attached accurately reflect all portfolio combined investments and conforms with all California state statutes and the Huntington Beach investment policy filed on December 19,2023.The investment program herein shown provides sufficient cash flow liquidity to meet the next six month's obligations.Market values are provided by US Bank via Interactive Data Corp(IDC) The City Portfolio uses a 12 month moving average of the 1.5Yr Treasury for comparison purposes.This period,that rate is equal to:4.930% _ 4' City Treasurer 04/30/2024 Alisa Backstrom Title Date Portfolio Investments Market Value Book Value Book Yield Days to Par Value Book Value Market Value %of Port Book Yield Contribution Maturity Total Market Value $404,004,098.52 Cash/Money Market $14,890,200.52 $14,890,200.52 $14,890,200.52 3.58% 5.17% 0.19% 1 Local Govt Inv Pools(LGIP) $38,324,381.03 $38,324,381.03 $38,324,381.03 9.22% 5.44% 0.50% 1 U.S.Treasuries $93,000,000.00 $92,628,601.44 $89,734,940.00 22.27% 2.39% 0.53% 622 Supranational $40,000,000.00 $39,533,815.98 $38,135,300.00 9.51% 2.51% _ 0.24% 981 U.S.Agencies $174,980,000.00 $174,756,001.47 $168,174,369.80 42.02% 2.27% 0.95% 630 Corporates $56,571,000.00 $55,723,137.53 $54,744,907.17 13.40% 3.40% 0.45% 634 Total $417,765,581.55 $415,856,137.97 $404,004,098.52 100.00% 2.87% 582 • 23 55 Reporting Period: Cash By Structure Report Portfolio:CITY 04/30/2024 City of Huntington Beach Accounting ID Ticker Pool Description Type Par Value Book Value Market Value Rate %of Portfolio 104 FUZXX First American Treasury Obligations Cash/Money Market 14,890,200.52 14,890,200.52 14,890,200.52 5.170 3.58% Cash/Money Market Total 14,890,200.52 14,890,200.52 14,890,200.52 3.58% 003 CAMP California Asset Management Program LGIP 38,324,381.03 38,324,381.03 38,324,381.03 5.440 9.22% LGIP Total 38,324,381.03 38,324,381.03 38,324,381.03 9.22% Report Run Date: Jul 19,2024 24 56 Reporting Period: Bond Redemption Activity Report Portfolio:CITY 04/30/2024 City of Huntington Beach Accounting ID Transaction Type Cusip Description Price Settlement Posted Date Par Value Principal Accrued Interest Total Date Activity Total 0.00 0.00 0.00 0.00 Report Run Date: Jul 19,2024 25 57 Reporting Period: Bond Purchase Activity Report Portfolio:CITY 04/30/2024 City of Huntington Beach Accounting ID Transaction Type Cusip Description Price Settlement Date Posted Date Par Value Principal Accrued Interest Total Activity Total 0.00 0.00 0.00 0.00 Report Run Date: Jul 19,2024 26 58 Reporting Period: Bond Interest Received Report Portfolio:CITY 04/30/2024 City of Huntington Beach Accounting ID Transaction Type Cusip Description Date Posted Interest Received Purchased Interest Net Interest Adjustment 4298 Interest Income 912828YH7 T 1.500 09/30/2024 04/01/2024 37,500.00 37,500.00 4336 Interest Income 3130AMXJ6 FHLB 0.500 09/30/2024 04/01/2024 12,500.00 12,500.00 4407 Interest Income 713448DN5 PEP 2.375 10/06/2026 04/08/2024 59,375.00 ,26,388.89 32,986.11 4386 Interest Income 3133EPGT6 FFCB 3.875 04/26/2027 04/26/2024 96,875.00 96,875.00 4319 Interest Income 459058JL8 IBRD 0.500 10/28/2025 04/29/2024 12,500.00 12,500.00 4350 Interest Income 912828YM6 T 1.500 10/31/2024 _04/30/2024 22,500.00 22,500.00 Activity Total 241,250.00 26,388.89 214,861.11 Report Run Date: Jul 19,2024 27 59 Reporting Period: Bond Holdings By Sector Report Portfolio:CITY 04/30/2024 City of Huntington Beach Accounting CUSIP Ticker Coupon Maturity Date Short Description Trade Date Settlement par Value Book Value Market Value Gain/Loss Book Effective Days to (%)of Moodys S&P Fitch ID Date Yield Duration Maturity Portfolio Rating Rating Rating 4364 9128286Z8 T 1.750 06/30/2024 U.S.Treasury Note 04/29/2022 05/02/2022 7,000,000.00 6,989,117.22 6,957,020.00 (32,097.22) 2.730 0.16 60 1.68% Ma AA+ AA+ 4370 912828XX3 T 2.000 06/30/2024 U.S.Treasury Note 05/26/2022 05/27/2022 5,000,000.00 4,996,323.53 4971,400.00 (24,923.53) 1 2.462 0.16 60 1.20% Aaa 1 AA+ AA+- 4353 912828Y87 T 1.750 07/31/2024 U.S.Treasury Note 01/13/2022 01/14/2022 5,000,000.00 5,008,864.91 4,955,150.00 (53,714.91) 1.028 0.25 91 1.20% Ma AA+ AA+ 4358 912828Y87 T 1.750 07/31/2024 U.S.Treasury Note 02/10/2022 02/11/2022 4,000,000.00 4,001,506.90 3,964,120.00 (37,386.90) 1.595 0.25 91 0.96% Aaa AA+ AA+ 4361 912828D56 T 2.375 08/15/2024 U.S.Treasury Note 03/21/2022 03/22/2022 5,000,000 00 5,001,888 54 4,956,300.00 (45,588.54) 2.240 0.29 106 1.20% Ma AA+ AA+ 4298 912828YH7 T 1.500 09/30/2024 U.S.Treasury Note 12/04/2019 12/05/2019 5,000,00000 4,998,101.08 4,921,350.00 (76,751.08) 1.595 0.41 152 1.20% Ma AA+ AA+ 4350 912828YM6 T 1.500 10/31/2024 U.S.Treasury Note 12/30/2021 12/31/2021 3,000,000.00 3,008,577.13 2,943,240.00 (6533713) 0.920 0.49 183 0.72% Ma AA+ AA+ 4376 91282CEU1 T 2.875 06/15/2025. U.S.Treasury Note 11/17/2022 11/18/2022 3,000,000.00 2,955,733.09 2,923,590.00 (32,143.09) 4.276 1.07 410 0.71% Ma AA+ AA+ 4330 91282CAB7 T 0.250 07/31/2025 U.S.Treasury Note 05/18/2021 05/19/2021 5,000,000 00 4,977,526.99 4,703,150.00 (274,376.99) 0.615 1.22 456 1.20% Ma AA+ AA+ 4340 91282CAJ0 T 0.250 08/31/2025 U.S.Treasury Note 09/23/2021 09/27/2021 5,000,000.00 4,968,161.61 4,685,350.00 (282,811.61) 0.735 1.30 487 1.19% Aaa AA+ AA+ 4351 9128284Z0 T 2.750 08/31/2025 U.S.Treasury Note 12/30/2021 12/31/2021 5,000,000.00 5,107,220.01 4,844,150.00 (263,070.01) 1.103 1.28 487 1.23% Aaa AA+ AA+ 4411 91282CHM6 T 4.500 07/15/2026 U.S.Treasury Note 03/11/2024 03/12/2024 5,000,000.00 5,012,192.69 4,947,450.00 (64742.69) 4380 2.04 805 1.21% Aaa AA+ AA+ 4341 91282CCP4 T 0.625 07/31/2026 U.S.Treasury Note 09/30/2021 09/30/2021 5,000,000.00 4,964,364.23 4,540,650.00 (423,714.23) 0.950 2.17 821 1.19% Aaa AA+ AA+ 4339 91282CCW9 T 0.750 08/31/2026 U.S.Treasury Note 09/23/2021 09/23/2021 1,000,000.00 996,810.32 907,970.00 (8884032) 0.890 2.25 852 0.24% Ma AA+ AA+ 4342 91282CCW9 __.T 0.750 08/31/2026 U.S.Treasury Note 11/22/2021 11/23/2021 5,000,000.00 4,939,627.58 4,539,850.00 (399,777.58) 1.285 2.25 852 1.19% Aaa AA+ AA+ 4379 91282CEW7 T 3.250 06/30/2027 U.S.Treasury Note 12/28/2022 12/29/2022 5,000,000.00 4,892,333.49 4,767,400.00 (124,933.49) 4.000 2.92 1,155 118% Ma AA+ AA+ 4406 91282CEW7 T 3.250 06/30/2027 U.S.Treasury Note 12/21/2023 12/22/2023 5,000,00000 4,895,996.11 4,767,400.00 (128,596.11) 3.960 2.92 1,155 1.18% Ma AA+ AA+ 4409 91282CFB2 T 2.750 07/31/2027 U.S.Treasury Note 01/18/2024 01/19/2024 5,000,000.00 4,800,523.82 4,686,700.00 (113,823.82) 4.080 3.02 1,186 1.15% Aaa AA+ AA+ 4408 91282CHQ7 T 4.125 07/31/2028 U.S.Treasury Note 01/12/2024 01/16/2024 10,000,000.00 10,113,732.21 9,752,700.00 (361,032.21) 3.831 3.79 1,552 2.43% Aaa AA+ AA+ U.S.Treasuries 93,000,000.00 92,628,601.44 89,734,940.00 (2,893,661.44) 22.27% 4323 459056HV2 IBRD 1.500 08/28/2024 Intl Bank for Recon and Dev 04/21/2021 04/23/2021 5,000,000.00 5,017,321.83 4,936,100.00 (81,221.83) 0.425 0.32 119 1.21% Ma AAA AAA 4338 4590581E4 IBRD 0.376 07/28/2025 Int'l Bank for Recon and Dev 07/28/2021 07/30/2021 5,000,000.00 4,987,255.22 4,705,600.00 (281,655.22) 0.583 1.21 453 1.20% Aaa AAA AAA 4319 459058JL8 IBRD 0.500 10/28/2025 Intl Bank for Recon and Dev 01/08/2021 01/12/2021 5,000,000.00 4,999,144.41 4,661,750.00 (337,394.41) 0.512 1.45 545 1.20% Aaa -AAA AAA 4324 45906M2L4 IBRD 0.650 02/24/2026 Intl Bank for Recon and Dev 04/28/2021 04/30/2021 5,000,000.00 4,980,492 85 4,596,000.00 (384,492.85) 0.870 1.76 664 1.20% Ma AAA AAA 4401 45818WEQ5 IADB 3.800 06/09/2028 Inter American Development Bank 09/19/2023 09/21/2023 5,000,000.00 4,849,719.26 4,788,500.00 (61,219.26) 4.622 3.67 1,500 1.17% Aaa AAA AAA 4402 459058KT9 IBRD 3.500 07/12/2028 Int'l Bank for Recon and Dev 11/09/2023 11/13/2023 5,000,000.00 4,765,115 54 4,745,800.00 (19,315.54) 4.760 3.79 1,533 1.15% Aaa AAA AAA 4403 459058KT9 IBRD 3.500 07/12/2028 Intl Bank for Recon and Dev 12/04/2023 12/06/2023 5,000,000.00 4,839,729.98 4,745,800.00 (93,929.98) 4.350 3.79 1,533 1.16% Aaa AAA AM 4410 459058KW2 IBRD 4.625 08/01/2028 Intl Bank for Recon and Dev 01/23/2024 01/25/2024 5000,000.00 5,095,036.90 4,955,750.00 (139286.90) 4.130 3.76 1,553 1.23% Aaa AAA AAA Supranational 40,000,000.00 39,533,815.98 38,135,300.00 (1,398,515.98) 9.51% 4378 3130ATVC8 FHLB 4.875 06/14/2024 Federal Home Loan Bank 12/27/2022 12/28/2022 5,000,000.00 5,000,715.30 4,996,400.00 (4,315.30) 4.740 0.12 44 1.20% Ma AA+ 4348 3130AQD42 FHLB 0.920 06/28/2024 Federal Home Loan Bank 12/14/2021 12/28/2021 5,000,000.00 5,000,000.00 4,964,950.00 (35,050.00) 0.920 0.16 58 1.20% Ma AA+ 4380 3134GYCP5 FHLMC 5.000 07/23/2024 Freddie Mac 01/05/2023 01/23/2023 5,000,000.00 5,000,000.00 4,996,850.00 (3,150.00) 5.000 0.22 83 1.20% Aaa AA+ AA+ 4344 3130AQ3C5 FHLB 1.000 08/28/2024 Federal Home Loan Bank 12/01/2021 12/02/2021 4,000,000.00 4,000,000.00 3,943,200.00 (56,800.00) 1.000 0.32 119 0.96% _ Aaa AA+ 4373 3133XVDG3 FHLB 4.375 09/13/2024 Federal Home Loan Bank 09/22/2022 09/23/2022 5,000,000.00 5,002,333.24 4,982,050.00 (20,283.24) 4.240 0.36 135 1.20% Aaa AA+ 4336 3130AMX16 FHLB 0.500 09/30/2024 Federal Home Loan Bank 06/17/2021 06/30/2021 5,000,000.00 5,000,000.00 4,898,700.00 (101,300.00) 0.500 0.41 152 1.20% Aaa AA+ 4346 3130AQD59 FHLB 1.000 09/30/2024 Federal Home Loan Bank 12/14/2021 12/30/2021 5,000,000.00 5,000,000.00 4,911,150.00 (88,850.00) 1.000 0.41 152 1.20% Aaa AA+ 4349 3130AQD59 FHLB 1.000 09/30/2024 Federal Home Loan Bank 12/22/2021 12/30/2021 5,000,000.00 5,000,000.00 4,911,150.00 (88,850.00) 1.000 0.41 152 1.20% Aaa AA+ 4334 3130AMW65 FHLB 0.500 12/30/2024 Federal Home Loan Bank 06/15/2021 06/30/2021 5,000,000.00 5,000,000.00 4,846.600.00 (153,400.00) 0.500 0.65 243 1.20% Ma AA+ 4332 3130AMQ62 FHLB 0.625 03/14/2025 Federal Home Loan Bank 05/26/2021 06/14/2021 5,000,000.00 5,000,000.00 4,802,750.00 (197,250.00) 0.625 0.85 317 1.20% Ma AA+ 4397 3130AWER7 FHLB 4.625 06/06/2025 Federal Home Loan Bank 06/14/2023 06/15/2023 3,000,000.00 2,998,950.00 _ 2,979,930.00 (19,020.00) 4.659 1.04 401 0.72% Aaa AA+ 4329 3135G04Z3 FNMA 0.500 06/17/2025 Fannie Mae 05/13/2021 05/14/2021 5,000,000.00 4,992,875.02 4,743,400.00 (249,475.02) 0.628 1.10 412 1.20% Aaa AA+ AA+ 4381 3135G04Z3 FNMA 0.500 06/17/2025 Fannie Mae 01/12/2023 01/13/2023 5,000,000.00 4,813,026.32 4,743,400.00 (69,626.32) 4.013 1.10 412 1.16% Aaa AA+ AA+ 4345 3130AQ5S8 FHLB 1.250 06/30/2025 Federal Home Loan Bank 12/08/2021 12/30/2021 4,650,000.00 4,650,000.00 4,451,026.50 (198,973.50) 1.250 1.13 425 1.12% Aaa AA+ 4327 3130AMDL3 FHLB 0.800 07/25/2025 Federal Home Loan Bank 05/11/2021 05/25/2021 5,000,000.00 5,000,000.00 4,738,400.00 (261,600.00) 0.800 1.19 450 1.20% Ma AA+ 4360 3130AQT94 FHLB 1.600 08/28/2025 Federal Home Loan Bank 03/03/2022 03/04/2022 4,575,000.00 4,562,383.18 4,366,425.75 (195 957.43) 1.816 1.28 484 1.10% Aaa AA+ 4331 3130AMQ54 FHLB 0.700 09/16/2025 Federal Home Loan Bank 05/26/2021 06/16/2021 5,000,000.00 5,000,000.00 4698,300.00 (301,700.00) 0.700 1.34 503 1.20% Ma AA+ 4318 3135GA2Z3 FNMA 0.560 11/17/2025 Fannie Mae 01/08/2021 01/11/2021 3,000,000.00 3,001,050 86 2,796,810.00 (204,240.86) 0.500 1.50 565 0.72% Aaa AA+ AA+ 4320 3130AKN36 FHLB 0.525 01/15/2026 Federal Home Loan Bank 01/14/2021 01/15/2021 5,000,000.00 4,998,294.44 4,618,000.00 (380,294.44) 0.545 1.66 624 120% Aaa AA+ 4321 3130AKN85 FHLB 0.550 01/20/2026 Federal Home Loan Bank 01/14/2021 .01/20/2021. 5,000,000.00 4,999,140.28 4,617,150.00 (381,990.28) 0.560 1.67 629 1.20% Aaa AA+ 4322 3130AKUS3 FHLB 0.500 01/28/2026 Federal Home Loan Bank 01/26/2021 01/28/2021 5,000,000 00 5,000,000.00 4,608,450.00 (391 550.00) 0.500 1.69 637 1.20% Aaa AA+ 4333 3130ALEY6 FHLB 0.800 03/04/2026 Federal Home Loan Bank 06/09/2021 06/10/2021 5,000,000.00 5,000,000.00 4,612,250.00 (387,750.00) 0.800 1.78 672 1.20% Ma AA+ 4328 3130AMJN3 FHLB 1.030 05/26/2026 Federal Home Loan Bank 05/12/2021 05/26/2021. 5,000,000 00 5,000,000.00 4,598,100.00 (401,900.00) 1.030 1.99 755 1.20% Ma AA+ 4335 3130AMFS6 FHLB 0.750 06/12/2026 Federal Home Loan Bank 06/16/2021 06/17/2021 5,000,000.00 4,987,281 34 4,568,200.00 (419 081.34) 0.873 2.04 772 1.20% Ma AA+ Report Run Date: Jul 19,2024 28 60 Reporting Period: Bond Holdings By Sector Report Portfolio:CITY 04/30/2024 City of Huntington Beach Accounting CUSIP Ticker Coupon Maturity Date Short Description Trade Date Settlement Par Value Book Value Market Value Gain/Loss Book Effective Days to (%)of Moodys S&P Fitch ID Date Yield Duration Maturity Portfolio Rating Rating Rating 4388 3130AVWS7 FHLB 3.750 06/12/2026 Federal Home Loan Bank 05/08/2023 05/09/2023 3,000,000.00 2,997,148.81 2,922,240.00 (74,908.81) 3.796 1.97 772 0.72% Aaa AA+ 4398 3133EPNG6 FFCB 4.375 06/23/2026 Federal Farm Credit Bank 06/22/2023 06/23/2023 3,000,000.00 2,999,035.00 2,959,800.00 (39235.00) 4.391 1.99 783 0.72% Aaa AA+ AA+ 4347 3130AQ7E7 FHLB 1.500 06/30/2026 Federal Home Loan Bank 12/14/2021 12/30/2021 5,000,000 00 5,000,961.73 4,627,800.00 (373,161.73) 1.339 2.07 790 1.20% Aaa AA+ 4384 3130AUMC5 FHLB 3.750 07/20/2026 Federal Home Loan Bank 01/17/2023 01/19/2023 5,000,000.00 5,000,000.00 4,860,900.00 (139,100.00) 3.750 2.07 810 1.20% Aaa AA+ 4356 3130AQ579 FHLB 1.375 08/07/2026 Federal Home Loan Bank 01/27/2022 02/07/2022 5,000,000.00 5,000,000.00 4,683,350.00 (316 650.00) 1.375 2.16 828 1.20% Aaa AA+ 4386 3133EPGT6 FFCB 3.875 04/26/2027 Federal Farm Credit Bank 04/21/2023 04/26/2023 5,000,000.00 4,995,707.47 4,857,300.00 (138,407.47) 3.906 2.77 1,090 1.20% Aaa AA+ AA+ 4389 3133EPJP1 FFCB 3.625 05/12/2027 Federal Farm Credit Bank 05/08/2023 05/12/2023 5,000,000.00 4,989,506.70 4,820,700.00 (168,806.70) 3.700 2.77 1,106 1.20% Aaa AA+ AA+ 4392 3130AW4N7 FHLB 3.630 06/04/2027 Federal Home Loan Bank 05/16/2023 05/18/2023 5,000,000.00 5,000,000.00 4816300.00 (183,700.00) 3.630 2.83 1,129 1.20% Aaa AA+ 4396 3133EPMV4 FFCB 4.125 06/15/2027 Federal Farm Credit Bank 06/09/2023 06/15/2023 5,000,000.00 4,999,258.47 4,887,350.00 (111 908.47) 4.130 2.84 1140 120% Aaa AA+ AA+ 4385 3134GYPF3 FHLMC 4.750 07/12/2027 Freddie Mac 04/21/2023 04/24/2023 3,300,000.00 3,296,246.74 3,258,090.00 (38 156.74) 4.791 1.81 1,167 0.79% Aaa AA+ AA+ 4405 3130AWWN6 FHLB 4.500 09/10/2027 Federal Home Loan Bank 12/04/2023 12/05/2023 4,455,000.00 4,470,581.91 4,404,257.55 (66,324.36) 4.383 3.05 1,227 1.08% Aaa AA+ 4395 3130AWC24 FHLB 4.000 06/09/2028 Federal Home Loan Bank 06/09/2023 06/13/2023 5,000,000.00 5,003,785.52 4,855,450.00 (148,335.52) 3.979 3.66 1,500 1.20% Aaa AA+_ 4399 3130AWC24 FHLB 4.000 06/09/2028 Federal Home Loan Bank 06/26/2023 06/27/2023 5,000,000 00 4,997,719.14 4,855,450.00 (142,269.14) 4.012 3.66 1,500 1.20% Aaa AA+ 4400 31422X5U2 FAMCA 5.100 08/07/2028 Farmer Mac 08/02/2023 08/07/2023 2,000,000.00 2000,000.00 1971,740.00 (28,260.00) 5.100 2.32 1,559 0.48% U.S.Agencies 174,980,000.00 174,756,001.47 168,174,369.80 (6,581,631.67) 42.02% 4355 67066GAL8 NVDA 0.584 06/14/2024 _ Nvidia 01/20/2022 01/24/2022 5,000,000.00 4,996,092.50 4,970,550.00 (25,542.50) 1.250 0.12 44 1.20% Aa3 AA- 4325 91159HHX1 USB 2.400 07/30/2024 US Bank 04/28/2021 04/30/2021 3,809,000.00 3,825,979.02 3,779,175.53 (46,803.49) 0.528 0.24 90 0.92% A3 A A 4343 14913R2P1 CAT 0.600 09/13/2024 Caterpillar 11/30/2021 12/02/2021 5,000,000.00 4,993,136.26 4,912,000.00 (81,136.26) 0.980 0.36 135 1.20% A2 A A+ 4371 459200KS9 IBM 4.000 07/27/2025 IBM 08/09/2022 08/11/2022 6,000,000.00 6,013,179.17 5,891,580.00 (121,599.17) 3.810 1.18 452 1.45% A3 A- 4372 931142EW9 WMT 3.900 09/09/2025 Walmart 09/20/2022 09/22/2022 5,000,000.00 4,984,175.45 4,915,100.00 (69,075.45) 4.150 1.30 496 1.20% Aa2 AA AA 4382 717081DV2 PFE 2.750 06/03/2026 Pfizer Inc 01/13/2023 01/18/2023 5,000,000.00 4865 568.40 4,764,550.00 (101 018.40) 4.142 1.97 763 1.17% A2 A A 4375 110122CN6 BMY 3.200 06/15/2026 Bristol-Myers Squibb 11/14/2022 11/16/2022 5,000,000.00 4,875,709.23 4,789,700.00 (86,009_23) 4.480 1.98 775 1.17% A2 A 4390 931142EM1 WMT 3.050 07/08/2026 Walmart 05/11/2023 05/15/2023 4,257,000.00 4,195,849.64 4,083,612.39 (112,237.25) 3.752 2.04 798 101% Aa2 AA AA 4391 904764AU1 UNANA 2.000 07/28/2026 Unilever 05/11/2023 05/15/2023 2,505,000.00 2,413,092.92 2,336,789.25 (76303.67) 3.752 2.13 818 0.58% Al A+ A 4404 0378330N7 AAPL 2.050 09/11/2026 Apple 12/04/2023 12/06/2023 5,000,000.00 4721,934.67 4,656,450.00 (6548467) 4.583 2.25 863 1.14% Aaa AA+ 4407 7134480N5 PEP 2.375 10/06/2026 'Pepsi 12/21/2023 12/26/2023 5,000,000.00 4,784,531.25 4,686,900.00 (97631.25) 4.273 2.30 888 1.15% Al A+ WD 4412 24422EXB0 DE 4.950 07/14/2028 John Deere 03/25/2024 03/27/2024 1 5,000,000.00 5,053,889.01 4,958,500.00 (95,389.01) 4.662 3.68 1,535 1.22% Al A A+ Corporates 56,571,000.00 55,723,137.53 54,744,907.17 (978,230.36) 13.40% Bond Holdings 364,551,000.00 362,641,556.42 350,789,516.97 (11,852,039.45) 87.20% Report Run Date: Jul 19,2024 29 61 Nor?�9 i Statement of Cash Receipts and Disbursements and � Summary of Cash by Fund �9�`•:4<=F .,�,;,, M°r�� ��� City Treasurer's Office zOUNrry�>l April 2024 Cash Receipts and Disbursements March 2024 April 2024 Receipts General Fund Property Tax $ 4,914,439 $ 22,852,792 Local Sales Tax 3,861,827 3,372,318 Public Safety Sales Tax 325,633 216,280 Transient Occupancy Tax(TOT) 938,525 1,524,811 Utility Users Tax(UUT) 1,840,310 1,846,676 Other Revenue 8,370,025 8,768,017 Total General Fund Revenue 20,250,760' 38,580,895 Total All Other Funds Revenue 16,780,087 17,981,968 Total Receipts $ 37,030,847 $ 56,562,863 Disbursements General Fund Personnel Services (10,693,407) (12,314,628) Operating Expenses (3,697,896) (4,021,838) Capital Expenditures - - Non-Operating Expenses (1,236,763) (65,934) Total General Fund Disbursements (15,628,067) (16,402,400) Total All Other Funds Disbursements (13,748,398) (14,906,182) Total Disbursements (29,376,465) (31,308,582) Net Change in Cash Flow $ 7,654,382 $ 25,254,281 Summary of Cash by Fund March 2024 April 2024 General Fund $ 126,414,089 $ 148,592,584 General Fund Other 5,007,108 4,962,385 Capital Projects Funds 46,117,578 45,742,371 Debt Service Funds 28,262,356 28,737,932 Enterprise Funds 81,088,525 83,371,803 Trust and Agency Funds 11,438,287 12,474,314 Internal Service Funds 46,729,357 45,636,783 Special Revenue Funds 44,656,741 45,450,151 General Ledger Cash Balances * $ 389,714,041 $ 414,968,323 Total cash will differ from investment portfolio total due to outstanding checks and/or other timing differences. Note: Above information was obtained from the City's accounting system records.The above information includes receipts from maturing investments and payments for purchased investments in the city investment portfolio.This statement is prepared in compliance with the City's Charter. 30 62 //.I.i►,.., i:.\fc%TlN G ri6klib'`A 4/ I., Q .•`.t p R P 0 RA�,••.. Quarterly • ,,,,,rr • Investment ____ ___ __� _ � . ,,,„ „ ,, , ,p(i (r _ , Report . , _ . ,,,,,,,7_ , ,, ,,x,: .....z. t . ._. 2___ _____ • ,, .- -, ". ____ , . •_.___ . , •.� e. 9 , P�°,.=' c.� Alisa Backstrom , MBA, CCMT, CPFIM •••..• /C \>'‘ Elected City Treasurer 0NT C)\'',/# �� / Quarter Ended . June 30, 2024 63 ECONOMIC UPDATE - June UFederal Reserve continued to hold interest rates unchanged : > lnflation eased to 2 . 7% but remained elevated > Modest further progress towards 2% objective LJNonfarm payroll rose by 206K in June NGTo 1/ O(• .•\ CORPORATFO.••. (T U Unemployment rate 4. 1% • _ =z O 64 INVESTMENT PORTFOLIO - SUMMARY QUARTER END 6/30/24 ($ in millions) Investment Type Book Value Market Value U.S. Agencies $ 164.8 $ 159.6 U.S. Treasuries $ 80.7 $ 78.5 Corporate Bonds $ 50.8 $ 50.1 CAMP Investment Pool $ 33.6 $ 33.6 Supranational Bonds $ 49.6 $ 48.7 ,00/1%11NGr N 04i ,'/r c..`'\ CORP0RATe>.. V5)\\ . Cash / Money Market $ 9.6 $ 9.6 � _ _ - TOTAL $389.1 $ 380.1 ..i B• I7-_9- %•' G'puNTY .,.c,\„. 65 INVESTMENT PORTFOLIO - INVESTMENTS BY TYPE QUARTER END 6/30/24 42°,.13% 13% 9% r2% U.S.Agencies Supranationals U.S. Treasuries Corpw^ CAMP ^^^^^^^^^^^^^^^^^^ »^ 66 INVESTMENT PORTFOLIO - BY MATURITY QUARTER END 6/30/24 Maturity Distribution 4-5Yr/ r \ WASH 8.1' 4 11.12% 3-4Yr 9.63% ° . 24.49% 2-3Yr �, ��,. 18.47%_,, 1 �• . r �/ �� ANT..N GTO AO ., ' P <<..•••••'•RPOR ' .• o' n ' 1 ••.•\ CO ATE'-0•'•• V \ 1-2Yr :CI ': . • _ • S _�a 28_109` = ::: Book Value % of Portfolio �cF \� �� =°OUNT`I t�ii# 67 INVESTMENT PORTFOLIO - SELECTED ACTIVITY QUARTER END 6/30/24 U.S. Agencies $1 OMM Maturities U.S. - 12MM Maturities Treasuries Corporate Bonds $5MM Maturities TING 0 '/I O�•.`\N�pRPORATE�• -57 ��� Supranationals $10MM Purchases - • • Total Purchases: $10 million Total Maturities: $27 million ouiu.\ #' 68 INVESTMENT PORTFOLIO - EARNINGS QUARTER END 6/30/24 Current Month':': • $984 580 j U 35% p Fiscal Year-to-date. • $10,027,613 fUp 70% Monthly EffectiveAnnual $ urin: • 3.04% �,1�,�N:��ivcT CC-- n '� O`er.•';COAPORgl''. o FYTD Effective Annual Return •_ • 2.67 % CvUNTY 69 INVESTMENT PORTFOLIO - SELECTED COMPLIANCE QUARTER END 6/30/24 MAXIMUM INVESTMENT MAXIMUM SPECIFIED %OF MINIMUM QUALITY IN PORTFTYPE MATURITY MAXIMUM PER COMPLIANCE? PER ISSUER U.S. Treasuries 5 years None None YES U.S.Agencies 5 years None None YES Supranationals 5 years 30% "AA" Rating Category YES Corporate Bonds 5 years 30%f10% "A"Rating Category YES Money Market o o "AAA" Rating 60 days 15/110/a i' TIN Mutual Funds Category YES jolt_*vN.a. 0� CA Asset 1 0 .••.N Fo •., Management NIA Upto$75,000,000 UI 000 None . �.1 Program (CAMP) YES i �: -- ==$ _ =Y--=- : �‘ :, - . -;:..: ,-::'= 1 Maximum Maturities No more than 50%of portfolio maturing over 4 years. YES `�T2'••.,4.-==== o::•` 1 cF•. i :•�\�o//I "CUNT' ;;i#J 70 ADDITIONAL INFORMATION City of Huntington Beach Website : • City Treasurer • Investments https ://www. hu ntington beachca .gov/govern ment/ ci ty treasurer investments . php „......,........ ,if\>0.1 NCTo O ::Y--ter"_ - -; Q , \'9 •• -"---- ` �Dt/NT 1 C A.,ifr 71 z� r3 't" - . ." 2 • Questions . a> . ,. , , , , . ,,, , 4,4.]'':-n--- lifipilirdiliLMititio-,-_,.,::-,,'!.. 1-., .:;,-,.. ...4. _ 4.1,1!4.,4111-ift \inntruz., 1 ,„ ;,,,,L, ,:-„ t,.i'L.:, ,.;„,-„.__ -1:4-.,..,,7,--..„,.. ._ 1.,,,i, 4..,1„,,,,, „r.,---...r• ,.:lie ti-rirl .1 - - irk,e' .,.. ,..1c.-. ......_,..- --, ,...e.,2?r i"s.-t',::7"2:"7.1.;';414"..,.,t,.-.1',...,..1:j'':''-,";,.''4'.'.4,'V 7".,:",4-7'-,°•••-';—...;:1 4-',.e-'.,7 2';4,-.,"',.•',n•i-r•e,-:..-;n!„t\,1';•v;'‘,,"c':,..it.•t,.,f4".in..‘,54::.:%'4.;•,,,,,:•=r4-.i,,.,1.L.,1--„,'N7-t 4 _ ,. f -tom ' 4,, , :_ . ,,;,...12,....:: ., ::::„,,.e.„.... .!..,,,.,,,,...„.„.. .;._... ...: • ...• fir �..... qa+t-. -2'" , +s '. '..`"ate g. '� FT„ � z;, �' "`-•,C fi,,r' z '4,f- • 1 Yr , { ru 72 �0NTiNGro 2000 Main Street, �� ;w�m Huntington Beach,CA tiN 92648 City of Huntington Beach APPROVED 7-0 _ b'�. , a so: �UUNTY�0 File #: 24-317 MEETING DATE: 5/7/2024 REQUEST FOR CITY COUNCIL ACTION SUBMITTED TO: Honorable Mayor and City Council Members SUBMITTED BY: Alisa Backstrom, City Treasurer VIA: Alisa Backstrom, City Treasurer PREPARED BY: Alisa Backstrom, City Treasurer Subject: Receive and File the City Treasurer's Quarterly Investment Report for March 2024 Statement of Issue: Receive and File the City Treasurer's Quarterly Investment Report for March 2024, pursuant to Section 18.0 of the Investment Policy of the City of Huntington Beach. Financial Impact: Not Applicable Recommended Action: Receive and File the City Treasurer's Quarterly Investment Report for March 2024, pursuant to Section 18.0 of the Investment Policy of the City of Huntington Beach. Alternative Action(s): Deny or Critique Quarterly Investment Report. Analysis: Not Applicable Environmental Status: This action is not subject to the California Environmental Quality Act (CEQA) pursuant to Sections 15060(c)(2) (the activity will not result in a direct or reasonably foreseeable indirect physical change in the environment) and 15060(c)(3) (the activity is not a project as defined in Section 15378) of the CEQA Guidelines, California Code of Regulations, Title 14, Chapter 3, because it has no potential for resulting in physical change to the environment, directly or indirectly. City of Huntington Beach Page 1 of 2 Printed on 5/1/2024 powered24 LegistarT"^ File #: 24-317 MEETING DATE: 5/7/2024 Strategic Plan Goal: Non Applicable -Administrative Item For details, visit www.huntingtonbeachca.gov/strategicplan <http://www.huntingtonbeachca.gov/strategicplan>. Attachment(s): 1. Treasurer's Quarterly Report of March 2024 2. PowerPoint Presentation Treasurer's Quarterly Investment Report for March 2024 City of Huntington Beach Page 2 of 2 Printed on 5/1/2024 powerecia4 Legistarn" 19.4 ." ^.- :.r . >--., ;..-.,+ �� .�• �.,,,�!„ yam,/^„ Pit �p w- HURTINGTON BEACH »'` City of Huntington Beach Quarterl Investment Report Y March 2024 �,/'\\N . i N c ro AeAO 0� •••\� OIIP0Rgttt•.•• . o � ._ \ �j �••6 I1, 1909�P�•• Prepared by: Alisa Backstrom, MBA, CCMT, CPFIM City Treasurer Colin Stevens, MPP Treasury Manager 1 26 `Fv HUflTI@16TON BEACH �� ,� w � INVESTMENT PORTFOLIO SUMMARY As of March 31, 2024 Portfolio Investments Book Value Book Yield Days to Par Value Book Value Market Value Book Yield %of Port. Contribution Maturity Cash/Money Market $630,181.12 $630,181.12 $630,181.12 0.17% 5.19% 0.01% 1 Local Govt Inv Pools(LGIP) $18,239,724.65 $18,239,724.65 $18,239,724.65 4.78% 5.48% 0.26% 1 U.S.Treasuries $93,000,000.00 $92,614,801.84 $90,143,810.00 24.28% 2.39% 0.58% 652 Supranational $40,000,000.00 $39,527,425.69 538,517,300.00 10.36% 2.51% 026% 1,011 U.S.Agencies $174,980,000.00 $174,741,023.96 $168,833,576.35 45.81% 2.27% 1.04% 660 Corporates $56,571,000.00 $55,692,364.19 $54,967,152.18 14.60% 3.39% 0.50% 664 Total $383,420,905.77 $381,445,521.45 $371,331,744,30 . 100.00% 2.65% 662 Currently, funds within this portfolio with overnight availability are invested in the California Asset Management Program "CAMP". The CAMP account is considered a "Local Government Investment Pool" or "LGIP" for reporting purposes above. Other funds are invested in U.S. Treasuries, Supranationals (International Bank of Reconstruction and Development "IBRD", Inter-American Development Bank "IADB"), U.S. Agencies, money market funds, and corporate bonds. Only the investment types allowed under California Government code Section 53601 and the City's Investment Policy Statement are utilized. After raising the federal funds rate by 5.25 percentage points since March 2022 in one of the Fed's fastest and largest rate hike campaigns, The Federal Open Market Committee ("FOMC" or "the Fed") has held the rate steady since July of last year. At the most recent March 2024 meeting, the FOMC maintained the federal funds rate at 5.25 to 5.50 percent. As interest rates have been rising and have remained at elevated levels, the market value of securities previously purchased at lower than the current market rates, is down. This has resulted in the current market value of the portfolio being lower than the book value, at $371.3 million versus $381.4 million, respectively. As investments are primarily held to maturity, the market value is only a point-in-time measurement and no loss is realized. The increasing interest rates will allow excess funds to be invested at higher rates resulting in increased interest income in the future. 2 27 dye HUNTINGTON BEACH VI2 t s . PORTFOLIO BREAKOUT BY SECTOR As of March 31, 2024 Sector Breakdown Cash! Money Corporates Market 14.60% 0.1796 Local Govt Inv Pools(LGIP) 4.78% U.S. Treasuries 24.28% Supranational 10.36% U.S. Agencies 45.81% • Book Value% of Port The largest holding by security type at month-end was U.S. Agency securities at approximately 46% of the total overall portfolio. This was followed by U.S. Treasury securities at approximately 24% of the total portfolio as of March 31, 2024. Cash held in the Local Government Investment Pools ("LGIP") has been reduced as higher interest rates have become available in marketable securities. INVESTMENT PORTFOLIO EARNINGS As of March 31, 2024 Period Earnings Summary(31 Days) Fiscal YTD Summary(275 Days) Net Period Earnings $844,665.99 Net Period Earnings $7,119,725.23 Last FY Period Net Earnings $574,350.72 Last FY Period Net Earnings $3,875,462.55 Avg Daily Book Balance $380,972,664.17 Avg Daily Book Balance $364,817,542.27 Net Effective Annual Return 2.649% Net Effective Annual Return 2.606% 3 28 . d HUNTINGTON BEACH Earnings for the month of March 2024 were $844,666, an increase of approximately 47% from the same month in the prior year. Fiscal year to date earnings of $7,119,725 were up approximately 84% from the previous fiscal year. These higher earnings were due to both the increase in interest rates and the higher average balance of the portfolio. The effective rate of return for March was 2.65%, with a fiscal year-to-date return of 2.61%. The benchmark has increased rapidly with the sharp rise in interest rates through 2022 into 2023. At the end of March, the 12-month moving average of the interpolated 1.5-year U.S. Treasury was 4.86%. The portfolio will lag behind the benchmark, as it will take time for previously purchased securities to mature and for funds to be reinvested. QUARTERLY PORTFOLIO ACTIVITY January 1 to March 31, 2024 $ in 000s Transaction Type: Security Type Purchase Maturity/Sale Commercial Paper $0 $0 U.S.Treasuries $20,000 $0 Supranationals $5,000 $0 U.S.Agencies $0 $8,000 Corporate Bonds $5,000 $0 'TOTALS: $30,000 $8,000, As interest rates have remained elevated throughout the first quarter, available funds were invested into higher yielding options. For the quarter ending March 31, 2024, three U.S. Treasuries were purchased totaling $20.0 million, one Supranational was purchased totaling $5.0 million, and one Corporate Bond was purchased totaling $5.0 million. Two U.S. Agencies matured for $8.0 million. 4 29 0410.0, HUNTINGTON BEACH - - COMPLIANCE SUMMARY As of March 31, 2024 MAXIMUM SPECIFIED%°OF INVESTMENT MAXIMUM MINIMUM QUALITY IN TYPE MATURITY PORTFOLIO/ REQUIREMENTS COMPLIANCE? MAXIMUM PER ISSUER U.S.Treasuries 5 years None None YES U.S.Agencies 5 years None None YES Supranationals 5 years 30% "AA" Rating Category YES Corporate Bonds 5 years 30%/10% "A" Rating Category YES Money Market 60 days 15%/10% "AAA"Rating Mutual Funds Category YES CA Asset Management N/A Up to$75,000,000 None Program(CAMP) YES Maximum Maturities No more than 50%of portfolio maturing over 4 years. YES There were no compliance issues during this period. ECONOMIC AND MARKET OVERVIEW MARKET SUMMARY: DECEMBER 29, 2023 - MARCH 31, 2024 Fed Funds 2-Yr. 10-Yr. As of: Rate Treasury Treasury S&P 500 DJIA 12/29/2023 5.25- 5.50 % 4.23% 3.88% $ 4,769.83 $ 37,689.54 3/28/2024 5.25- 5.50% 4.59% 4.20% $ 5,254.35 $ 39,807.37 %Change 0.00% 8.51% 8.25% 10.16% 5.62% The Federal Open Market Committee (FOMC) met in March to discuss the current state of the economy and to examine potential future interest rate adjustments. They concluded that economic activity has been expanding at a solid pace, job gains have remained strong, and the unemployment rate has remained low. In determining the extent of additional policy firming that may be appropriate to return inflation to 2 percent over time, the Committee will consider the cumulative tightening of monetary policy, the lags with which monetary policy affects economic activity and inflation, and economic and financial developments. 5 30 HIJHTINGTON BEACH 44* u � Fixed Income / Equity Markets: The yield on the 10-year U.S. Treasury finished the quarter at 4.20%, up from 3.88% at the end of December last year. The S&P 500 increased by 10.16% and the DJIA increased by 5.62% respectively, over the same period. Employment: Total nonfarm payroll employment rose by 303,000 in March, and the unemployment rate was little changed at 3.8 percent. Notable job gains occurred in health care, government, and construction. 6 31 �p"1,70 p Portfolio Summary �t � City of Huntington Beach Portfolio:CITY rez Reporting Date:(FY2024) r " 03/01/2024 03/31/2024 -. Full Accrual Basis Par Value Period Earnings Summary(31 Days) Fiscal YTD Summary(275 Days) Period Transactions Net Period Earnings $844,665.99 Net Period Earnings $7,119,725.23 Redemptions 1 Total Par Value $383,420,905.77 Last FY Period Net Earnings $574,351.34 Last FY Period Net Earnings $3,875,462.55 Purchases 2 Avg Daily Book Balance $380,972,664.17 Avg Daily Book Balance $364,817,542.27 Total Activity 3 Net Effective Annual Return 2.649% Net Effective Annual Return 2.606% Fiscal YTD Transactions Redemptions 12 Purchases 13 Book Value Total Activity 25 Total Book Value $381,445,521.45 City Portfolio Certification I certify that this report and the corresponding pages attached accurately reflect all portfolio combined investments and conforms with all California state statutes and the Huntington Beach investment policy filed on December 19,2023.The investment program herein shown provides sufficient cash flow liquidity to meet the next six month's obligations.Market values are provided by US Bank via Interactive Data Corp(IDC) The City Portfolio uses a 12 month moving average of the 1.5Yr Treasury for comparison purposes.This period,that rate is equal to:4.860% 14' City Treasurer 03/31/2024 Alisa Backstrom Title Date Portfolio Investments Market Value Book Value Book Yield Days to Par Value Book Value Market Value Book Yield %of Port Contribution Maturity Total Market Value $371,331,744.30 Cash/Money Market $630,181.12 $630,181.12 $630,181.12 0.17% 5.19% 0.01% 1 Local Govt Inv Pools(LGIP) $18,239,724.65 $18,239,724.65 $18,239,724.65 4.78% 5.48% 0.26% 1 U.S.Treasuries $93,000,000.00 $92,614,801.84 $90,143,810.00 24.28% 2.39% 0.58% 652 Supranational $40,000,000.00 $39,527,425.69 $38,517,300.00 10.36% 2.51% 0.26% 1,011 U.S.Agencies $174,980,000.00 $174,741,023.96 $168,833,576.35 45.81% 2.27% 1.04% 660 Corporates $56,571,000.00 $55,692,364.19 $54,967,152.18 14.60% 3.39% 0.50% 664 Total $383,420,905.77 $381,445,521.45 $371,331,744.30 100.00% 2.65% 662 7 32 Reporting Period: Cash By Structure Report Portfolio:CITY 03/31/2024 City of Huntington Beach Accounting ID Ticker Pool Description Type Par Value Book Value Market Value Rate %of.Portfolio 104 FUZXX First American Treasury Obligations Cash/Money Market 630,181.12 630,181.12 630,181.12 5.190 0.17% Cash/Money Market Total 630,181.12 '630,181.12 630,181.12 0.17% 003 CAMP California Asset Management Program LGIP 18,239,724.65 18,239,724.65 18,239,724.65 5.480 4.78% LGIP Total 18,239,724.65 18,239,724.65 18,239,724.65 4.78% Report Run Date: Apr 22,2024 8 33 Reporting Period: Bond Redemption Activity Report Portfolio:CITY 03/31/2024 City of Huntington Beach Accounting ID Transaction Type Cusip Description Price Settlement Date Posted Date Par Value Principal Accrued Interest Total 4292 Maturity 3133ECHX5 FFCB 2.260 03/13/2024 100.00000 03/13/2024 03/13/2024 5,000,000.00 5,000,000.00 0.00 5,000,000.00 Activity Total 5,000,000.00 5,000,000.00 0.00 5,000,000.00 Report Run Date: Apr 22,2024 9 34 Reporting Period: Bond Purchase Activity Report Portfolio:CITY 03/31/2024 City of Huntington Beach Accounting ID Transaction Type Cusip Description Price Settlement Posted Date Par Value Principal Accrued Interest Total Date 4411 Buy 91282CHM6 T4.50007/15/2026 100.25900 03/12/2024 03/12/2024 5,000,000.00 5,012,950.00 35,233.52 5,048,183.52 4412 Buy 24422EX80 DE 4.950 07/14/2028 101.10200 03/27/2024 03/27/2024 5,000,000.00 5,055,100.00 50,187.50 5,105,287.50 Activity Total 10,000,000.00 10,068,050.00 85,421.02 ` 10,153,471.02 Report Run Date: Apr 22,2024 10 35 Reporting Period: Bond Interest Received Report Portfolio:CITY 03/31/2024 City of Huntington Beach Purchased Interest Accounting ID Transaction Type Cusip Description Date Posted Interest Received Net Interest Adjustment 4333 Interest Income 3130ALEY6 FHLB 0.800 03/04/2026 03/04/2024 20,000.00 20,000.00 4372 Interest Income 931142EW9 WMT 3.900 09/09/2025 03/11/2024 97,500.00 97,500.00 4404 Interest Income 037833DN7 AAPL 2.050 09/11/2026 03/11/2024 51,250.00 24,201.39 27,048.61 4405 Interest Income— — 3130AWWN6 — FHLB 4.500 09/10/2027 03/11/2024 113,602.50 60,699.38 — 52,903.12 — 4343 Interest Income _ 14913R2P1 CAT 0.600 09/13/2024 03/13/2024 15,000.00 15,000.00 4373 Interest Income 3133XVDG3 FHLB 4.375 09/13/2024 03/13/2024_ — 109,375.00 T 109,375.00 4292 — Interest Income 3133ECHX5 — FFCB 2.260 03/13/2024 03/13/2024 56,500.00 56,500.00 4332 Interest Income — 3130AMQ62 FHLB 0.625 03/14/2025 03/14/2024 _ 15,625.00 _ 15,625.00 4331 Interest Income 3130AMQ54 FHLB 0.700 09/16/2025 03/18/2024 17,500.00 17,500.00 Activity Total 496,352.50 84,900.77 411,451.73 Report Run Date: Apr 22,2024 11 36 Reporting Period: Bond Holdings By Sector Report Portfolio:CITY 03/31/2024 City of Huntington Beach Accounting CUSIP Ticker Coupon Maturity Date Short Description Trade Date Settlement Par Value Book Value Market Value Gain/Loss Book Effective Days to (%)of Moodys 5&P Fitch ID , Date Yield Duration Maturity Portfolio Rating Rating Rating 4364 9128286Z8 T 1.750 06/30/2024 U.S.Treasury Note 04/29/2022 05/02/2022 7,000,000.00 6,983,675.82 6,937,490.00 (46,185.82) 2.730 0.24 90 1.83% Ma AA+ AA+ 4370 912828XX3 T 2.000 06/30/2024 U.S.Treasury Note 05/26/2022 05/27/2022 5,000,000.00 4,994,485.29 4,957,750.00 (36,735.29) 2.462 0.24 90 1.31% Ma AA+ AA+ 4353 912828Y87 T 1.750 07/31/2024 U.S.Treasury Note 01/13/2022 01/14/2022 5,000,000.00 5,011,787.41 4,941,200.00 (70,587.41) 1.028 0.33 121 1.31% Ma AA+ AA+ 4358 912828Y87 T 1.750 07/31/2024 U.S.Treasury Note 02/10/2022 02/11/2022 4,000,000.00 4,002,003.68 3,952,960.00 (49,043.68) 1.595 0.33 121 1.05% Aaa AA+ AA+ 4361 912828D56 T 2.375 08/15/2024 U.S.Treasury Note 03/21/2022 03/22/2022 5,000,000.00 5,002,423.03 4,945,050.00 (57,373.03) 2.240 0.37 136 1.31% Aaa AM AA+ 4298 912828YH7 T 1.500 09/30/2024 U.S.Treasury Note 12/04/2019 12/05/2019 5,000,000.00 4,997,726.29 4,907,900.00 (89,826.29) 1.595 0.49 182 131% Aaa AM AA+ 4350 912828YM6 T 1.500 10/31/2024 U.S.Treasury Note 12/30/2021 12/31/2021 3,000,000 00 3,009,983.22 2,935,770.00 (74 213.22) 0.920 0.57 213 0.79% Aaa AA+ AA+ 4376 91282CEU1 T 2.875 06/15/2025 U.S.Treasury Note 11/17/2022 11/18/2022 3,000,000.00 2,952,494.04 2,927,340.00 (25,154.04) 4.276 1.16 440 0.77% Aaa AA+ AA+ 4330 91282CAB7 T 0.250 07/31/2025 U.S.Treasury Note 05/18/2021 05/19/2021 5,000,000.00 4,976,04850 4,703,900.00 (272,148.50) 0.615 1.30 486 1.30% Ma AA+ AA+ 4340 91282CAJ0 T 0.250 08/31/2025 U.S.Treasury Note 09/23/2021 09/27/2021 5,000,000.00 4,966,200.31 4,687,900.00 (278,300.31) 0.735 1.38 517 1.30% Aaa AA+ AA+ 4351 9128284Z0 T 2.750 08/31/2025 U.S.Treasury Note 12/30/2021 12/31/2021 5,000,000.00 5,113,824.94 4,856,850.00 (256,974.94) 1.103 1.36 517 1.34% Ma AA+ AA+ 4411 91282CHM6 T 4.500 07/15/2026 U.S.Treasury Note 03/11/2024 03/12/2024 5,000,000.00 5,012,647.08 4,992,600.00 (20,047.08) 4.380 2.13 835 1.31% Aaa AA+ AA+ 4341 91282CCP4 T 0.625 07/31/2026 U.S.Treasury Note 09/30/2021 09/30/2021 5,000,000 00 4,963,062.07 4,569,550.00 (393,512.07) 0.950 2.26 851 1.30% Ma AA+ AA+ 4339 91282CCW9 T 0.750 08/31/2026 U.S.Treasury Note-- 09/23/2021 09/23/2021 1,000,000.00 996,698.00 914,100.00 _ (82,598.00) 0.890 2.34 882 0 26% Aaa AM AA+ 4342 91282CCW9 T 0.750 08/31/2026 - U.S.Treasury Note 11/22/2021 11/23/2021 _5,000,000.00 - 4,937,501.79 _ 4,570,500.00 _ (367,001.79) 1.285 2.34_ 882 1.29% Aaa AA+ AA+ 4379 91282CEW7 _ T 3.250 06/30/2027 __ U.S.Treasury Note 12/28/2022 12/29/2022 _5,000,000.00 4,889,536.95 4,828,500.00 (61,036.95) 4.000 3.00 1,185 _1.28% i Ma AA+ AA+_ __ 4406 91282CEW7 T_ 3.250 06/30/2027 _ U.S.Treasury Note 12/21/2023 _12/2_2/2023 5,000,000.00 - 4,893,294.71 4,828,500.00 (64,794.71) 3.960 3.00 1,185 1.28% Aaa AA+ AA+ 4409 91282CFB2 __ T__- _ 2.750 07/31/2027 _-� U.S.Treasury Note 01/18/2024 01/19/2024 5,000,000.00 4,795,478.04 i 4,748,450.00 (47,028.04) 4.080 3.11 _1,216 1.26% -Aaa- AM AA+ - 4408 - 91282CHQ7 -T 4.125 07/31/2028 U.S.Treasury Note �- 01/12/2024 01/16/2024 10,000,000.00 10,115,930.64 9,937,500.00 (178,430.64) 3.831 3.89 1,582 2.65% Aaa AA+ AA+ U.S.Treasuries 93,000,000.00 92,614,801.84 90,143,810.00 (2,470,991.84) ,24.28% -' 4323 459056HV2 IBRD 1.500 08/28/2024 Int'l Bank for Recon and 0ev 04/21/2021 04/23/2021 5,000,000.00 5,021,763.32 4,923,550.00 (98,213.32) 0.425 0.40 149 1.32% Aaa AAA AAA 4338 4590581E4 IBRD 0.376 07/28/2025 Int'l Bank for Recon and Dev 07/28/2021 07/30/2021 5,000,000.00 4,986,399.86 4,713,100.00 (273,299.86) 0.583 1.29 483 1.31% Ma AAA AAA 4319 459058JL8 IBRD 0.500 10/28/2025 Intl Bank for Recon and Dev 01/08/2021 01/12/2021 5,000,000.00 4,999,096.61 4,676,650.00 (322,446.61) 0.512 1.53 575 1.31% Ma AAA MA 4324 45906M2L4 IBRD 0.650 02/24/2026 Intl Bank for Recon and Dev 04/28/2021 04/30/2021 5,000,000.00 4,979,596.66 4,616,150.00 (363,446.66) 0.870 1.84 694 1.31% Aaa AAA AAA 4401 45818WEQ5 IADB 3.800 06/09/2028 Inter-American Development Bank 09/19/2023 09/21/2023 5,000,000.00 4,846,668.90 4,873,150.00 26,481.10 4.622 3.77 1,530 1.27% Aaa AAA AAA 4402 4590581(1'9 IBRD 3.500 07/12/2028 Intl Bank for Recon and Dev 11/09/2023 11/13/2023 5,000,000.00 4,760,452.05 4,831,800.00 71,347.95 4.760 3.88 1,563 1.25% Ma AAA AAA 4403 4590581(1'9 IBRD 3.500 07/12/2028 Intl Bank for Recon and Dev 12/04/2023 12/06/2023 5,000,000.00 4,836,547.92 4,831,800.00 (4,747.92) 4.350 3.88 1,563 1.27% Ma AM AAA 4410 459058KW2 IBRD 4.625 08/01/2028 Intl Bank for Recon and Dev 01/23/2024 01/25/2024 5,000,000.00 5,096,900.37 5,051,100.00 (45,800.37) 4.130 3.85 1,583 1.34% Aaa AAA AAA , Supranational 40,000,000.00 39,527,425.69 38,517,300.00 (1,010,125.69) - 10.36% 4378 3130ATVC8 FHLB 4.875 06/14/2024 Federal Home Loan Bank 12/27/2022 12/28/2022 5,000,000.00 5,001,214.35 4,993,650.00 (7,564.35) 4.740 0.20 74 1.31% Aaa AA+ 4348 3130AQD42 FHLB 0.920 06/28/2024 Federal Home Loan Bank 12/14/2021 12/28/2021 5,000,000.00 5,000,000.00 4,948,350.00 (51,650.00) 0.920 0.24 88 1.31% Aaa AA+ 4380 3134GYCP5 FHLMC 5.000 07/23/2024 Freddie Mac 01/05/2023 01/23/2023 5,000,000.00 5,000,000.00 4,992,300.00 (7,700.00) 5.000 0.30 113 1.31% Ma AA+ AA+ 4344 3130AQ3C5 FH LB 1.000 08/28/2024 Federal Home Loan Bank 12/01/2021 12/02/2021 4,000,000.00 4,000,000.00 3,925,600.00 (74,400.00) 1.000 0.40 149 1.05% Aaa AA+ 4373 3133XVDG3 FHLB 4.375 09/13/2024 Federal Home Loan Bank 09/22/2022 09/23/2022 5,000,000.00 5,002,863.52 4,978,500.00 (24,363.52) 4.240 0.44 165 1.31% Ma AA+ 4336 3130AMXJ6 FHLB 0.500 09/30/2024 Federal Home Loan Bank 06/17/2021 06/30/2021 5,000,000.00 5,000,000.00 4,885,900.00 (114,100.00) 0.500 0.49 182 1.31% Ma AA+ 4346 3130AQD59 FHLB 1.000 09/30/2024 Federal Home Loan Bank 12/14/2021 12/30/2021 5,000,000.00 5,000,000.00 4,892,900.00 (107,100.00) 1.000 0.49 182 1.31% Ma AA+ 4349 3130AQD59 FHLB 1.000 09/30/2024 Federal Home Loan Bank 12/22/2021 12/30/2021 5,000,000.00 5,000,000.00 4,892,900.00 (107,100.00) 1.000 0.49 182 1.31% Ma AA+ 4334 3130AMW65 FHLB 0.500 12/30/2024 Federal Home Loan Bank 06/15/2021 06/30/2021 5,000,000.00 5,000,000.00 4,826.950.00 (173,050.00) 0.500 0.73 273 1.31% Aaa AA+ 4332 3130AMQ62 FHLB 0.625 03/14/2025 Federal Home Loan Bank 05/26/2021 06/14/2021 5,000,000.00 5,000,000.00 4,790,600.00 (209,400.00) 0.625 0.93 347 1.31% Aaa AA+ 4397 3130AWER7 FHLB 4.625 06/06/2025 Federal Home Loan Bank 06/14/2023 06/15/2023 3,000,000.00 2,998,870.25 2,988,660.00 (10,210.25) 4.659 1.12 431 0.79% Aaa AA+ 4329 3135G04Z3 FNMA 0.500 06/17/2025 Fannie Mae 05/13/2021 05/14/2021 5,000,000.00 4,992,348.54 4,741,750.00 (250,598.54) 0.628 1.18 442 1.31% Aaa AA+ AA+ 4381 3135004Z3 . FNMA 0.500 06/17/2025 Fannie Mae 01/12/2023 01/13/2023 5,000,000.00 4,799,210.53 4,741.750.00 (57,460.53) 4.013 1.18 442 1.26% Ma AA+ AA+ 4345 3130AQ558 FHLB 1.250 06/30/2025 Federal Home Loan Bank 12/08/2021 12/30/2021 4,650,000.00 4,650,000.00 4,454,188.50 (195,811.50) 1.250 1.21 455 1.22% Aaa AA+ 4327 3130AMDL3 FHLB 0.800 07/25/2025 Federal Home Loan Bank 05/11/2021 05/25/2021 5,000,000.00 5,000,000.00 4,741,200.00 (258,800.00) 0.800 1.28 480 1.31% Ma AA+ 4360 3130AQT94 FHLB 1.600 08/28/2025 Federal Home Loan Bank 03/03/2022 03/04/2022 4,575,000.00 4,561,589.67 4,371,778.50 (189 811.17) 1.816 1.36 514 1.20% Aaa AA+ 4331 3130AMQ54 FHLB 0.700 09/16/2025 Federal Home Loan Bank 05/26/2021 06/16/2021 5,000,000.00 5,000,000.00 4,705,400.00 (294,600.00) 0.700 142 533 1.31% Aaa AA+ 4318 3135GA2Z3 FNMA 0.560 11/17/2025 Fannie Mae 01/08/2021 01/11/2021 3,000,000.00 3,001,107.56 2,795,340.00 (205,767.56) 0.500 1.58 595 0.79% Aaa AA+ AA+ 4320 3130AKN36 FHLB 0.525 01/15/2026 Federal Home Loan Bank 01/14/2021 01/15/2021 5,000,000.00 4,998,211.11 4,631,150.00 (367,061.11) 0.545 1.74 654 1.31% Ma AA+ 4321 3130AKN85 FHLB 0.550 01/20/2026 Federal Home Loan Bank 01/14/2021 01/20/2021 5,000,000.00 4,999,098.61 4,630,900.00 (368,198.61) 0.560 1.75 659 1.31% Aaa AA+ 4322 3130AKUS3 FHLB 0.500 01/28/2026 Federal Home Loan Bank 01/26/2021 01/28/2021 5,000,000.00 5,000,000.00 4,622,550.00 (377,450.00) 0.500 1.77 667 1.31% Aaa AA+ 4333 3130ALEY6 FHLB 0.800 03/04/2026 Federal Home Loan Bank 06/09/2021 06/10/2021 5,000,000.00 5,000,000.00 4,632,150.00 (367,850.00) 0.800 1.86 702 1.31% Aaa AA+ 4328 3130AMJN3 FHLB 1.030 05/26/2026 Federal Home Loan Bank 05/12/2021 05/26/2021 5,000,000.00 5,000,000.00 4,625,200.00 (374,800.00) 1.030 2.07 785 1.31% Ma AA+ 4335 3130AMFS6 FHLB 0.750 06/12/2026 Federal Home Loan Bank 06/16/2021 06/17/2021 5,000,000.00 4,986,779.94 4,597,100.00 (389,679.94) 0.873 2.12 802 1.31% Aaa AA+ Report Run Date: Apr 22,2024 12 37 Reporting Period: Bond Holdings By Sector Report Portfolio:CITY 03/31/2024 City of Huntington Beach Accounting CUSIP Ticker Coupon Maturity Date Short Description Trade Date Settlement Par Value Book Value Market Value Gain/Loss Book Effective Days to •(%)of Moodys S&P Fitch ID - Date _ Yield Duration Maturity Portfolio Rating Rating Rating 4388 3130AVWS7 FHLB 3.750 06/12/2026 Federal Home Loan Bank 05/08/2023 05/09/2023 3,000,000.00 2,997,036.42 2947,170.00 (49,866.42) 3.796 2.06 802 0.79% Aaa AA+ 4398 3133EPNG6 FFCB 4.375 06/23/2026 Federal Farm Credit Bank 06/22/2023 06/23/2023 3,000,000.00 2,998,997.50 2,983,440.00 (15 557.50) 4.391 2.07 813 0.79% Aaa AA+ AA+ ... 4347 3130AQ7E7 FHLB 1.500 06/30/2026 Federal Home Loan Bank 12/14/2021 .12/30/2021 5,000,000.00 5,000,998.77 4,659,250.00 (341,748.77) 1.339 2.15 820 1.31% Aaa AA+ 4384 3130AUMC5 FHLB 3.750 07/20/2026 Federal Home Loan Bank 01/17/2023 01/19/2023 5,000,000.00 5,000,000.00 4,904,650.00 (95,350.00) 3.750 2.16 840 1.31% Aaa AA+ 4356 3130AQS79 FHLB 1.375 08/07/2026 Federal Home Loan Bank 01/27/2022 02/07/2022 5,000,000 00 5,000,000.00 4,702,750.00 (297,250.00) 1.375 2.24 858 1.31% Aaa AA+ 4386 3133EPGT6 FFCB 3.875 04/26/2027 Federal Farm Credit Bank 04/21/2023 04/26/2023 5,000,000.00 4,995,587.67 4,915,300.00 (80 287.67) 3.906 2.80 1,120 1.31% Aaa AA+ AA+ 4389 3133EPJP1 FFCB 3.625 05/12/2027 Federal Farm Credit Bank 05/08/2023 05/12/2023 5,000,000.00 4,989,218.16 4,878,300.00 (110,918.16) 3.700 2.86 1,136 1.31% Aaa AA+ AA+ • ._.4392 3130AW4N7 FHLB 3_630 06/04/2027 Federal Home Loan Bank 05/16/2023 05/18/2023 5,000,000.00 5,000,000.00 4878400.00 (121,600.00) 3.630 2.92 1,159 1.31% Aaa AM- 4396 3133EPMV4 FFCB 4.125 06/15/2027 Federal Farm Credit Bank 06/09/2023 06/15/2023 5,000,000.00 4,999,238.68 4,949,050.00 (50,188.68) 4.130 2.92 1,170 1.31% Aaa AA+ AA+ 4385 3134GYPF3 iFHLMC 4.750 07/12/2027 Freddie Mac 04/21/2023 04/24/2023 3,300,000.00 3,296,148.91 3,274,788.00 (2136091) 4.791 1.46 1,197 0.86% Aaa AA+ AA+, 4405 3130AWWN6 FHLB 4.500 09/10/2027 Federal Home Loan Bank 12/04/2023 12/05/2023 4455,000.00 4,470,968.56 4,468,231.35 (2,737.21) 4.383 3.14 1,257 1.17% Aaa AA+ 4395 3130AWC24 FHLB 4.000 06/09/2028 Federal Home Loan Bank 06/09/2023 06/13/2023 5,000,000.00 5,003,862.36 4,938,700.00 (65,162.36) 3.979 3.76 1,530 1.31% Aaa AA+ 4399 3130AWC24 FHLB 4.000_ 06/09/2028 Federal Home Loan Bank 06/26/2023 �_06/27/2023 __5,000,000.00 4,997,672 84 4,938,706.00 (58,972.84) 4.012 3.76 1,530_ _1.31% Aaa AA+ 4400 31422X5U2 FAMCA 5.100 08/07/2028 Farmer Mac 08/02/2023 08/07/2023 2,000,000.00 2,000,000.00 1,988,080.00 (11,920.00) 5.100 2.16_ 1,589 0.52% U.S.Agencies 174,980,000.00 174,741,023.96 168,833,576.35 (5,907,447.61) 45.81% 4355 .__ 67066GAL8 NVDA 0.584 06/14/2024 Nvidia 01/20/2022 01/24/2022 5,000,000.00 4,993,366.34 4,950,350.00 (43,016.34) 1.250 0.20 74 1.31% Al 4+_ 4325 91159HHX1 USB 2.400 07/30/2024 US Bank 04/28/2021 04/30/2021 3,809,000.00 3,831,702.29 3768738.87 (62,963.42) 0.528 0.32 120 1.00% A3 A A 4343 14913R2P1 CAT 0.600 09/13/2024 Caterpillar 11/30/2021 12/02/2021 5,000,000.00 4,991,576.32 4,891,100.00 (100476.32) 0.980 0.44 165 1.31% A2 A A+ ........... 4371 459200KS9 IBM 4.000 07/27/2025 IBM 08/09/2022 08/11/2022 6,000,000.00 6,014,065.67 5,905,860.00 (108,205.67) 3.810 1.26 482 1.58% A3 A- 4372 931142EW9 WMT 3.900 09/09/2025 Walmart 09/20/2022 09/22/2022 5,000,000.00 498320262 4928200.00 (55,002.62) 4.150 1.38 526 1.31% Aa2 AA AA 4382 717081DV2 PFE 2.750 06/03/2026 Pfizer Inc 01/13/2023 01/18/2023 5,000,000.00 4,860,205.43 4794900.00 (65,305.43) 4.142 2.05 793 1.27% A2 A A 4375 110122CN6 BMY 3.200 06/15/2026 __. Bristol-Myers Squibb 11/14/2022 11/16/2022 5,000,000.00 4870,828.70 4,820,200.00 (50,628.70) 4.480 2.05 805 1.28% A2 A 4390 931142EM1 WMT 3.050 07/08/2026 .__ Walmart 05/11/2023 05/15/2023 4,257,000.00 4,193,518.62 4104939.96 (88,578.66) 3.752 2.12 828 1.10% Aa2 AA AA 4391 904764AU1 UNANA 2.000 07/28/2026 Unilever 05/11/2023 05/15/2023 2,505,000.00 2,409,676.30 2,348,863.35 ((60,812.95) 3.752 2.21 848 0.63% Al A+ A 4404 ' 037833DN7 AAPL 2.050 09/11/2026 Apple 12/04/2023 12/06/2023 5,000,00000 471212060 4,693,350.00 (18770.60) 4583 233 893 124% Aaa AA+ 4407 713448DN5 PEP 2.375 10/06/2026 Pepsi 12/21/2023 12/26/2023 5,000,000.00 4,777,143.75 4,722,950.00 (54,193.75) 4.273 2.35 918 1.25% Al A+ WD 4412 24422EX80 DE 4.950 07/14/2028 .John Deere _ 03/25/2024 03/27/2024 5,000,000.00 5,054,957.53 5,037,700.00 (17,257.53) 4.662 3.77 1,565 1.33% Al A A+ Corporates 56,571,000.00 55,692,364.19 54,967,152.18 (725,212.01) - 14.60% - . i r Bond Holdings 364,551,000.00 362,575,615.68 352,461,838.53 (10,113,777.15) - 95.05% Report Run Date: Apr 22,2024 13 38 f ING Statement of Cash Receipts and Disbursements and '�o m F��;y Summary of Cash by Fund City Treasurer's Office cou-K6 P;��� March 2024 Cash Receipts and Disbursements February 2024 March 2024 Receipts General Fund Property Tax $ 144,722 $ 4,914,439 Local Sales Tax 4,795,396 3,861,827 Public Safety Sales Tax 236,799 325,633 Transient Occupancy Tax(TOT) 1,001,534 938,525 Utility Users Tax(UUT) 1,815,586 1,840,310 Other Revenue 5,573,286 8,370,025 Total General Fund Revenue 13,567,325 20,250,760 Total All Other Funds Revenue 12,853,834 16,780,087 Total Receipts $ 26,421,158 $ 37,030,847 Disbursements General Fund Personnel Services (12,873,440) (10,187,565) Operating Expenses (5,828,662) (4,203,739) Capital Expenditures - - Non-Operating Expenses (5,688) (1,236,763) Total General Fund Disbursements (18,707,790) (15,628,067) Total All Other Funds Disbursements (12,548,735) (13,748,398) Total Disbursements (31,256,525) (29,376,465) Net Change in Cash Flow $ (4,835,366) $ 7,654,382 Summary of Cash by Fund February 2024 March 2024 General Fund $ 120,747,859 $ 125,370,553 General Fund Other 5,052,899 5,029,806 Capital Projects Funds 45,480,202 45,761,824 Debt Service Funds 27,610,578 28,103,975 Enterprise Funds 79,482,173 80,643,342 Trust and Agency Funds 11,834,054 11,367,785 Internal Service Funds 45,743,301 46,387,107 Special Revenue Funds 43,401,730 44,342,787 General Ledger Cash Balances * $ 379,352,797 $ 387,007,179 Total cash will differ from investment portfolio total due to outstanding checks and/or other timing differences. Note: Above information was obtained from the City's accounting system records.The above information includes receipts from maturing investments and payments for purchased investments in the city investment portfolio.This statement is prepared in compliance with the City's Charter. 14 39 o`i�'U� ro,, Portfolio Summary , J ` , . City of Huntington Beach - x Portfolio:CITY Q Reporting Date:(FY2024) ���‘4.coU;T;' 4.$1 02/01/2024-02/29/2024 Full Accrual Basis Par Value Period Eaarnings Summary(29 Days) Fiscal YTD Summary(244 Days) Period Transactions Net Period Earnings T $822,954.01 Net Period Earnings $6,275,059.24 Redemptions 1 Total Par Value $380,980,152.68 Last FY Period Net Earnings $535,524.25 Last FY Period Net Earnings $3,301,111.83 Purchases 0 Avg Daily Book Balance $380,901,773.70 Avg Daily Book Balance $362,798,152.04 Total Activity 1 Net Effective Annual Return 2.761% Net Effective Annual Return 2.606% Fiscal YTD Transactions Redemptions 11 Purchases 11 Book Value Total Activity 22 Total Book Value $378,869,262.42 City Portfolio Certification I certify that this report and the corresponding pages attached accurately reflect all portfolio combined investments and conforms with all California state statutes and the Huntington Beach investment policy filed on December 19,2023.The investment program herein shown provides sufficient cash flow liquidity to meet the next six month's obligations.Market values are provided by US Bank via Interactive Data Corp(IDC) The City Portfolio uses a 12 month moving average of the 1.5Yr Treasury for comparison purposes.This period,that rate is equal to:4.870% rig. City Treasurer 02/29/2024 Alisa Backstrom Title Date Portfolio Investments Market Value Book Value Book Yield Days to Par Value Book Value Market Value %of Port Book Yield Contribution Maturity .... Total Market Value $368,182,824.70 Cash/Money Market $3,280,148.30 $3,280,148.30 $3,280,148.30 0.87% 5.19% 0.04% 1 Local Govt Inv Pools(LGIP) $18,149,004.38 $18,149,004.38 $18,149,004.38 4.79% 5.50% 0.26% 1 U.S.Treasuries $88,000,000.00 $87,587,425.64 $84,980,940.00 23.12% 2.27% 0.53% 673 Supranational $40,000,000.00 $39,521,035.40 $38,393,650.00 10.43% 2.51% 0.26% 1,042 U.S.Agencies $179,980,000.00 $179,726,083.91 $173,556,875.10 47.44% 2.27% 1.08% _ 672 Corporates $51,571,000.00 $50,605,564.79 $49,822,206.92 13.36% 3.27% 0.44% 605 Total $380,980,152.68 $378,869,262.42 $368,182,824.70 100.00% 2.61% 664 15 40 Reporting Period: Cash By Structure Report Portfolio:CITY 02/29/2024 City of Huntington Beach Accounting ID Ticker Pool Description Type Par Value Book Value Market Value Rate %of Portfolio- 104 FUZXX First American Treasury Obligations Cash/Money Market 3,280,148.30 3,280,148.30 3,280,148.30 5.190 0.87% Cash/Money Market Total 3,280,148.30 3,280,148.30 3,280,148.30 0.87% 003 CAMP California Asset Management Program LGIP 18,149,004.38 18,149,004.38 18,149,004.38 _ 5.500 4.79% LGIP Total 18,149,004.38 18,149,004.38 18,149,004.38 4.79% Report Run Date: Apr 24,2024 16 41 Reporting Period: Bond Redemption Activity Report Portfolio:CITY 02/29/2024 City of Huntington Beach Accounting ID Transaction Type Cusip Description Price Settlement Date Posted Date Par Value Principal Accrued Interest Total 4387 Maturity 3130AUXN9 FHLB 5.000 02/15/2024 100.00000 02/15/2024 02/15/2024 3,000,000.00 3,000,000.00 0.00 3,000,000.00 Activity Total 3,000,000.00 3,000,000.00 0.00 3,000,000.00 Report Run Date: Apr 24,2024 17 42 Reporting Period: Bond Purchase Activity Report Portfolio:CITY 02/29/2024 City of Huntington Beach Accounting ID Transaction Type Cusip Description Price Settlement Date Posted Date Par Value Principal Accrued Interest Total Activity Total 0.00 0.00 0.00 0.00 Report Run Date: Apr 24,2024 18 43 Reporting Period: Bond Interest Received Report Portfolio:CITY 02/29/2024 City of Huntington Beach Accounting ID Transaction Type Cusip Description, Date Posted Interest Received Purchased Interest Net Interest Adjustment 4410 Interest Income 459058KW2 IBRD 4.625 08/01/2028 02/01/2024 80,300.00 76,440.97 3,859.03 4356 Interest Income 3130AQS79 FHLB 1.375 08/07/2026 02/07/2024 34,375.00 34,375 00 4400 Interest Income _31422X5U2 FAMCA 5.100 08/07/2028 02/07/2024 51,000.00 — 51,000.00 4361 Interest Income 912828D56_ T 2.375 08/15/2024 — 02/15/2024 59,375.00 — _ 59,375.00 4387_ Interest Income 3130AUXN9 — FHLB 5.000 02/15/2024 02/15/2024 _ 75,000.00 —_ 75,000.00 4324 —— Interest Income 45906M2L4 IBRD 0.650 02/24/2026 02/26/2024 — 16,250.00 _ 16,250.00 4344 Interest Income 3130AQ3C5 FHLB 1.000 08/28/2024 02/28/2024_ 20,000.00 20,000.00 4360 Interest Income 3130AQT94 FHLB 1.600 08/28/2025 02/28/2024 36,600.00 36,600.00 4323 Interest Income 459056HV2 IBRD 1.500 08/28/2024 02/28/2024_ 37,500.00 37,500.00 4339 Interest Income 91282CCW9 T 0.750 08/31/2026 02/29/2024 3,750.00 3,750.00 — 4340 Interest Income 91282CA10 T 0.250 08/31/2025 02/29/2024 6,250.00 _ 6,250.00 4342 Interest Income 91282CCW9 v T 0.750 08/31/2026 —-- 02/29/2024 18,750.00 — 18,750.00 _ 4351 Interest Income 9128284Z0 T 2.750 08/31/2025 02/29/2024 ri—�68,750.00 68,750.00 Activity Total 507,900.00 76,440.97 431,459.03 Report Run Date: Apr 24,2024 19 44 Reporting Period: Bond Holdings By Sector Report Portfolio:CITY 02/29/2024 City of Huntington Beach Accounting CUSIP Ticker Coupon Maturity Date Short Description Trade Date Settlement Par Value Book Value Market Value Gain/Loss Book Effective Days to (%)of Moodys S&P Fitch ID Date Yield Duration Maturity Portfolio Rating Rating Rating 4364 9128286Z8 T 1.750 06/30/2024 U.S.Treasury Note 04/29/2022 05/02/2022 7,000,000.00 6,978,053.05 6917120.00 (60,933.05) 2.730 0.33 121 1.84% Aaa AA+ AA+ 4370 912828XX3 T 2.000 06/30/2024 U.S.Treasury Note 05/26/2022 05/27/2022 5,000,000.00 4,992,585.78 4,944,750.00 (47,835.78) 2.462 0.33 121 1.32% Aaa AA+ AA+ 4353 912828Y87 T 1.750 07/31/2024 U.S.Treasury Note 01/13/2022 01/14/2022 5,000,000.00 5,014,807.32 4,927,150.00 (87,657.32) 1.028 0.41 152 1.32% Aaa AA+ AA+ 4358 912828Y87 T 1.750 07/31/2024 U.S.Treasury Note 02/10/2022 02/11/2022 4,000,000.00 4,002,517.03 3,941,720.00 (60,797.03) 1.595 0.41 152 1.06% Aaa AA+ AA+ 4361 912828D56 T 2.375 08/15/2024 U.S.Treasury Note 03/21/2022 03/22/2022 5,000,000.00 5,002,975.34 4,934,200.00 (68,775.34) 2.240 0.45 167 1.32% Aaa AA+ AA+ 4298 912828YH7 T 1.500 09/30/2024 U.S.Treasury Note 12/04/2019 12/05/2019 5,000,000.00 4,997,339.01 4,893,550.00 (103,789.01) 1.595 0.57 213 132% Aaa AA+ AA+ 4350 912828YM6 T .1.500 10/31/2024 U.S.Treasury Note 12/30/2021 12/31/2021 3,000,000.00 3,011,436.17 2,927,700.00 (8373617) 0.920 0.65 244 0.79% Aaa AA+ 'AA+ 4376 91282CEU1 T 2.875 06/15/2025 U.S.Treasury Note 11/17/2022 11/18/2022 3,000,000 00 2,949,147.03 2,924,310.00 (24,837.03) 4.276 1.24 471 0.78% Aaa AA+ AA+ 4330 91282CAB7 T 0.250 07/31/2025 U.S.Treasury NoteA 05/18/2021 05/19/2021 5,000,000.00 4,974,520.73 4,688,650.00 (285,870.73) 0.615 1.38 517 1.31% Aaa AA+ A+ 4340 91282CA10 T 0.250 08/31/2025 U.S.Treasury Note 09/23/2021 09/27/2021 5,000,00000 4964,173.64 4,673,650.00 (290,523.64) 0.735 1.46 548 1.31% Aaa AA+ AA+ 4351 912828420 T 2.750 08/31/2025 U.S.Treasury Note 12/30/2021 12/31/2021 5,000,000.00 5,120,650.04 4,851,350.00 (269,300.04) 1.103 1_45 548 1.35% Aaa AA+ AA+ 4341 91282CCP4 T 0.625 07/31/2026 U.S.Treasury Note 09/30/2021 09/30/2021 5,000,000.00 4,961,716_50 4,558,600.00 (403,116.50) 0.950 2.34 882 1.31% Aaa AA+ AA+ 4339 91282CCW9 T 0.750 08/31/2026 U.S.Treasury Note 09/23/2021 09/23/2021 1,000,00000 996,581.95 912,190.00 (84,391.95) 0.890 2.42 913 0.26% Aaa AA+ AA+ 4342 91282CCW9 T 0.750 08/31/2026 U.S.Treasury Note __ 11/22/2021 11/23/2021 5,000,000.00 4,935,305.14 4 56.0,950.00 (374,355.14) 1.285 2.42 913 1.30% Aaa AA+ AA+ 4379 91282CEW7 T__ 3.250 06/30/2027 U.S.Treasury Note 12/28/2022 12/29/2022 5,_000,000.00 4,886,647.20 4,826,000.00 (60,647.20) 4.000 3.09 1,216 1.29% _Aaa AA+ 44+_ _ 4406 91282C_EW7 ____ T_ 3.250 06/30/2027_ _ U.S.Treasury Note 12/21/2023 12/22/2023 _Y_5,000,000.00 4,890,503.27 _ 4,826,000.00 (64,503.27) 3.960 3.09 1,216 1.29% Aaa AA+ AA+_ _4409 91282CFB2 T 2.750 07/31/2027 �_�U.S.Treasury Note ___01/18/2024 01/19/2024 5,000,000.00 __ _ 4,790,264.08__^ 4,742,950.00 (47,314.08) 4.080 _3.19 _1,247 _1.26% Ma _AA+ AA+ 4408 91282CHQ7 vY T 4.125 07/31/2028 U.S.Treasury Note 01/12/2024 01/16/2024 10,060,000.00 - 10,118,202.35 Y 9,930,100.00 (188,102.35) 3.831 3.97 1,613 2.67% Ma A4+ 44+ U.S.Treasuries - 88,000,000.00 87,587,425.64 84,980,940.00 - (2,606,485.64) 23.12% 4323 459056HV2 IBRD 1.500 08/28/2024 Int'l Bank for Recon and Dev 04/21/2021 04/23/2021 5,000,000.00 5,026,204.81 4,907,150.00 (119,054.81) 0.425 0.48 180 1.33% Aaa AAA AAA 4338 459058JE4 IBRD 0.376 07/28/2025 Intl Bank for Recon and Dev 07/28/2021 07/30/2021 5,000,000.00 4,985,544.51 4,694,000.00 (291,544.51) 0.583 1.37 514 1.32% Ma AAA AAA 4319 459058JL8 IBRD 0.500 10/28/2025 Intl Bank for Recon and Dev 01/08/2021 01/12/2021 5,000,000.00 4,999,048.81 4,659,050.00 (339,998.81) 0.512 1.61 606 1.32% Aaa AAA A4A_ 4324 45906M2L4 IBRD 0.650 02/24/2026 Intl Bank for Recon and Dev 04/28/2021 04/30/2021 5,000,000.00 4,978,700.46 4,580,650.00 (398,050.46) 0.870 1.92 725 1.31% Aaa AAA AAA 4401 45818WEQ5 IADB 3.800 06/09/2028 Inter-American Development Bank 09/19/2023 09/21/2023 5,000,000.00 4,843,618.55 4,864,000.00 20,381.45 4.622 3.85 1,561 1.28% Aaa AAA AAA 4402 459058KT9 IBRD 3.500 07/12/2028 Intl Bank for Recon and Dev 11/09/2023 11/13/2023 5,000,000.00 4,755.788.56 4,821,450.00 65,661.44 4.760 3.96 1,594 1.26% Aaa AAA AAA 4403 459058KT9 IBRD 3.500 07/12/2028 Intl Bank for Recon and Dev 12/04/2023 12/06/2023 5,000,000.00 4,833,365.85 4,821,450.00 (11,915.85) 4.350 3.96 1,594 1.28% Ma AAA AAA 4410 459058KW2 IBRD 4.625 08/01/2028 Intl Bank for Recon and Dev 01/23/2024 01/25/2024 5,000,000.00 5,098,763.84 5,045,900.00 (52,863.84) 4.130 3.94 1,614 1.35% Aaa AAA AAA Supranational 40,000,000.00 39,521,035.40 38,393,650.00 (1,127,385.40) 10.43% 4292 3133ECHX5 FFCB 2.260 03/13/2024 Federal Farm Credit Bank 05/22/2019 05/23/2019 5,000,000.00 5,000,037.46 4,994,750.00 (5,287.46) 2.236 0.03 12 1.32% Aaa AA+ AA+ 4378 3130ATVC8 FHLB 4.875 06/14/2024 Federal Home Loan Bank 12/27/2022 12/28/2022 5,000,000.00 5,001,713.40 4,991,750.00 (9,963.40) 4.740 0.28 105 1.32% Aaa AA+ 4348 3130AQD42 FHLB 0.920 06/28/2024 Federal Home Loan Bank 12/14/2021 12/28/2021 5,000,000.00 5,000,000.00 4,927,500.00 (72,500.00) 0.920 0.32 119 1.32% Aaa AA+ 4380 3134GYCP5 FHLMC 5.000 07/23/2024 Freddie Mac 01/05/2023 01/23/2023 5,000,000.00 5,000,000.00 4,991,750.00 (8,250.00) 5.000 0.39 144 1.32% Ma AA+ AA+ 4344 3130AQ3C5 FHLB 1.000 08/28/2024 Federal Home Loan Bank 12/01/2021 12/02/2021 4,000,000.00 4,000,000.00 3 918 640.00 (81,360.00) 1.000 0.48 180 1.06% Aaa AA+ 4373 3133XVDG3 FHLB 4.375 09/13/2024 Federal Home Loan Bank 09/22/2022 09/23/2022 5,000,000.00 5,003,393.80 4,975,450.00 (27,943.80) 4.240 0.51 196 1.32% Aaa AA+ 4336 31304MXJ6 FHLB 0.500 09/30/2024 Federal Home Loan Bank 06/17/2021 06/30/2021 5,000,000.00 5,000,000.00 4,865,150.00 (134,850.00) 0.500 0.57 213 1.32% Ma AA+ 4346 3130AQD59 FHLB 1.000 09/30/2024 Federal Home Loan Bank 12/14/2021 12/30/2021 5,000,000.00 5,000,000.00 4,882,100.00 (117,900.00) 1.000 0.57 213 1.32% Ma AA+ 4349 3130AQD59 FHLB 1.000 09/30/2024 Federal Home Loan Bank 12/22/2021 12/30/2021 5,000,000.00 5,000,000.00 4,882,100.00 (117,900.00) 1.000 0.57 213 1.32% Ma AA+ 4334 3130AMW65 FHLB 0.500 12/30/2024 Federal Home Loan Bank 06/15/2021 06/30/2021 5,000,000.00 5,000,000.00 4,807,600.00 (192,400.00) 0.500 0.81 304 1.32% Ma AA+ 4332 3130AMQ62 FHLB 0.625 03/14/2025 _ Federal Home Loan Bank 05/26/2021 06/14/2021 5,000,000.00 5,000,000.00 4,768,350.00 (231,650.00) 0.625 1.01 378 1.32% Aaa AA+ 4397 3130AWER7 FHLB 4.625 06/06/2025 Federal Home Loan Bank 06/14/2023 06/15/2023 3,000,000.00 2,998,790.51 2,991,900.00 (6,890.51) 4.659 1.20 462 0.79% Ma AA+ 4329 3135G04Z3 FNMA 0.500 06/17/2025 Fannie Mae 05/13/2021 05/14/2021 5,000,000.00 4,991,822.06 4,731,700.00 (260,122.06) 0.628 1.26 473 1.32% Aaa AA+ AA+ 4381 3135G04Z3 FNMA 0.500 06/17/2025 Fannie Mae 01/12/2023 01/13/2023 5,000,000.00 4,785,394.74 4,731.700.00 (53,694.74) 4.013 1.26 473 1.26% Ma AA+ AA+ 4345 3130AQ558 FHLB 1.250 06/30/2025 Federal Home Loan Bank 12/08/2021 12/30/2021 4,650,000.00 4,650,000.00 4,438,750.50 (211,249.50) 1.250 1.29 486 1.23% Ma AA+ 4327 3130AMDL3 FHLB 0.800 07/25/2025 Federal Home Loan Bank 05/11/2021 05/25/2021 5,000,000.00 5,000,000.00 4,730,350.00 (269 650.00) 0.800 1.36 511 1.32% Ma AA+ 4360 3130AQT94 FHLB 1.600 08/28/2025 Federal Home Loan Bank 03/03/2022 03/04/2022 4,575,000.00 4,560,796.16 4,363,543.50 (197,252.66) 1.816 1.45 545 1.20% Aaa AA+ 4331 3130AMQ54 FHLB 0.700 09/16/2025 Federal Home Loan Bank 05/26/2021 06/16/2021 5,000,000.00 5,000,000.00 4,695,600.00 (304,400.00) 0.700 1.50 564 1.32% Ma AA+ 4318 3135GA2Z3 FNMA 0.560 11/17/2025 Fannie Mae 01/08/2021 01/11/2021 3,000,000.00 3,001,164.26 2,789,700.00 (211,464.26) 0.500 1.66 626 0.79% Ma AA+ AA+ 4320 3130AKN36 FHLB 0.525 01/15/2026 Federal Home Loan Bank 01/14/2021 01/15/2021 5,000,000.00 4,998,127.78 4,623,700.00 (374,427.78) 0.545 1.82 685 1.32% Aaa AA+ 4321 3130AKN85 FHLB 0.550 01/20/2026 Federal Home Loan Bank 01/14/2021 .01/20/2021 5,000,000.00 4,999,056.94 4,623,300.00 (375,756.94) 0.560 1.84 690 1.32% Ma AA+ 4322 3130AKUS3 FHLB 0.500 01/28/2026 Federal Home Loan Bank 01/26/2021 01/28/2021 5,000,000.00 5,000,000.00 4,615,000.00 (385,000.00) 0.500 1.86 698 1.32% Aaa AA+ 4333 3130ALEY6 FHLB 0.800 03/04/2026 Federal Home Loan Bank 06/09/2021 06/10/2021 5,000,000.00 5,000,000.00 4,626,250.00 (373,750.00) 0.800 1.94 733 1.32% Aaa 44+ 4328 3130AMJN3 FHLB 1.030 05/26/2026 Federal Home Loan Bank 05/12/2021 05/26/2021 5,000,000.00 5,000,000.00 4,609,600.00 (390,400.00) 1.030 2.15 816 1.32% Aaa AA+ 4335 3130AMFS6 FHLB 0.750 06/12/2026 Federal Home Loan Bank 06/16/2021 06/17/2021 5,000,000.00 4,986,278.55 4,588,600.00 (397,678.55) 0.873 2.21 833 1.32% Aaa AA+ Report Run Date: Apr 18,2024 20 45 Reporting Period: Bond Holdings By Sector Report Portfolio:CITY 02/29/2024 City of Huntington Beach Accounting _CUSIP Ticker Coupon Maturity Date Short Description Trade Date Settlement Par Value Book Value I Market Value Gain/Loss Book Effective Days to (%)of Moodys S&P Fitch ID Date - Yield Duration Maturity: Portfolio Rating Rating Rating 4388 3130AVWS7 FHLB 3.750 06/12/2026 Federal Home Loan Bank 05/08/2023 05/09/2023 3,000,000.00 2,996,924.02 2,948,910.00 (48,014.02) 3.796 2.14 833 0.79% Aaa AM 4398 3133EPNG6 FFCB 4.375 06/23/2026 Federal Farm Credit Bank 06/22/2023 06/23/2023 3,000,000.00 2,998,960.00 2,990,190.00 (8,770.00) 4.391 2.15 844 0.79% Aaa AA+ AA+ 4347 3130AQ7E7 FHLB 1.500 06/30/2026 Federal Home Loan Bank 12/14/2021 12/30/2021 5,000,000.00 5,001,035.80 4,646,050.00 (354,985.80) 1.339 2.23 851 1.32% Aaa AA+ 4384 3130AUMC5 FHLB 3.750 07/20/2026 Federal Home Loan Bank 01/17/2023 01/19/2023 5,000,000.00 5,000,000.00 4,907,700.00 (92,300.00) 3.750 2.24 871 1.32% Aaa AA+ 4356 3130AQS79 FHLB 1.375 08/07/2026 Federal Home Loan Bank 01/27/2022 02/07/2022 5,000,000.00 5,000,000.00 4,698,100.00 (301,900.00) 1.375 2.33 889 1.32% Aaa AA+ 4386 3133EPGT6 FFCB 3.875 04/26/2027 Federal Farm Credit Bank 04/21/2023 04/26/2023 5,000,000.00 4,995,467.88 4,915,450.00 (80,017.88) 3.906 2.88 1,151 1.32% Aaa AA+ AA+ 4389 3133EPJP1 FFCB 3.625 05/12/2027 Federal Farm Credit Bank 05/08/2023 05/12/2023 5,000,000.00 4,988,929.62 4,877,850.00 (111,079.62) 3.700 2.94 1,167 1.32% Aaa AA+ AA+ 4392 3130AW4N7 FHLB 3.630 06/04/2027 Federal Home Loan Bank 05/16/2023 05/18/2023 5,000,000.00 5,000,000.00 4,871,150.00 (128,850.00) 3.630 3.00 1,190 1.32% Aaa AA+ ___4396 _-.3133EPMV4 FFCB 4.125 06/15/2027 Federal Farm Credit Bank 06/09/2023 06/15/2023 5,000,000.00 4,999,218 89 4,951,300.00 (47,918.89) 4.130 3.01 1,201 1.32% Aaa AA+ AA+ 4385 3134GYPF3 FHLMC 4.750 07/12/2027 Freddie Mac 04/21/2023 04/24/2023 3,300,000.00 3,296,051.09- 3,257,397.00 (38,654.09) 4.791 1.80 1,228 0.87% Aaa AA+ AA+ 4405 3130AWWN6 FHLB 4.500 09/10/2027 Federal Home Loan Bank 12/04/2023 12/05/2023 4,455,000.00 4,471,355.21 4,459,544.10 (11,811.11) 4.383 3.14 1,288 1.18% Aaa AA+ 4395 3130AWC24 FHLB 4.000 06/09/2028 Federal Home Loan Bank 06/09/2023 06/13/2023 5,000,000.00 5,003,939.20 4,940,300.00 (63,639.20) 3.979 3.84 1,561 1.32% Ma AA+ 4399 3130AWC24 FHLB 4.000 06/09/2028 Federal Home Loan Bank 06/26/2023 06/27/2023 5,000,000.00 4,997,626.54 4,940,300.00 (57,326.54) 4.012 3.84 1,561 1.32% Ma AA+ 4400 31422X5U2 FAMCA 5.100 08/07/2028 Farmer Mac 08/02/2023 08/07/2023 2,000,000.00 2,000,000.00 1,987,800.00 (12,200.00) 5.100 2.26 1,620 0.53% - U.S.Agencies 179,980,000.00 179,726,083.91 173,556,875.10 - (6,169,208.81) '47.44% 4355 67066GAL8 NVDA 0.584 06/14/2024 Nvidia 01/20/2022 01/24/2022 5,000,000.00 4,990,640.17 4,933,000.00 (57,640.17) 1.250 0.28 105 1.32% Al A+ 4325 91159HHX1 USB 2.400 07/30/2024 US Bank 04/28/2021 04/30/2021 3,809,000.00 3,837,425.56 3,758,530.75 (78,894.81) 0.528 0.40 151 1.01% A3 A A 4343 14913R2P1 CAT 0.600 09/13/2024 Caterpillar 11/30/2021 12/02/2021 5,000,000.00 4,990,016.38 4,874,800.00 (115,216.38) 0.980 0.52 196 1.32% A2 A A+ 4371 459200KS9 IBM 4.000 07/27/2025 IBM 08/09/2022 08/11/2022 6,000,000.00 6,014,952.16 5,906,280.00 (108,672.16) 3.810 1.34 513 1.59% A3 A- 4372 931142EW9 WMT 3.900 09/09/2025 Walmart 09/20/2022 09/22/2022 5,000,000.00 4,982,229.80 4,923,450.00 (58,779.80) 4.150 1.43 557 1.32% Aa2 AA AA 4382 717081DV2 PFE 2.750 06/03/2026 Pfizer Inc 01/13/2023 01/18/2023 5,000,000.00 4,854,842.47 4,785,600.00 (69,242.47) 4.142 2.13 824 1.28% A2 A A 4375 110122CN6 BMY 3.200 06/15/2026 Bristol-Myers Squibb 11/14/2022 11/16/2022 5,000,000.00 4865,94818 4,811,550.00 (54,398.18) 4480 2.13 836. 128% A2 A 4390 931142EM1 WMT 3.050 07/08/2026 Walmart 05/11/2023 05/15/2023 4,257,000.00 4,191,187.61 4,095,489.42 (95,698.19) 3.752 2.20 -859 1.11% Aa2 AA AA 4391 904764AU1 UNANA 2.000 07/28/2026 Unilever 05/11/2023 05/15/2023 2,505,000.00 2,406,259.68 2,345,556.75 (60,702.93) 3.752 2.30 879 0.64% Al A+ A 4404 037833DN7 AAPL 2.050 09/11/2026 Apple 12/04/2023 12/06/2023 5,000,000.00 4,702,306 53 4,676,900.00 (25,406.53) 4.583 2.39 924 1.24% Aaa AA+ 4407 713448DN5 PEP 2.375 10/06/2026 Pepsi 12/21/2023 12/26/2023 5,000,000.00 4,769,756.25 4,711,050.00 (58,706.25) 4.273 2.43 949 1.26% Al A+ WD 7. -..- - -..- - - - - • ..--- -- --li_., Corporates 51,571,000.00 50,605,564.79 49,822,206 92 (783,357.87) 13.36% -. -. - I-._. -I _. [-- Bond Holdings 359,551,000.00 - - 357,440,109.74 ' 346,753,672.02 (10,686,437.72) 94.34% Report Run Date: Apr 18,2024 21 46 • OIINGro /11o` 'tip Statement of Cash Receipts and Disbursements and i�f ` Summary of Cash by Fund U ;2 z CityTreasurer's Office �c e �-4-- NV�4~� February 2024 Cash Receipts and Disbursements January 2024 February 2024 Receipts General Fund Property Tax $ 19,158,531 $ 144,722 Local Sales Tax 3,385,565 4,795,396 Public Safety Sales Tax 241,753 236,799 Transient Occupancy Tax(TOT) 1,031,836 1,001,534 Utility Users Tax(UUT) 1,854,414 1,815,586 Other Revenue 5,055,037 5,573,286 Total General Fund Revenue 30,727,136 13,567,325 Total All Other Funds Revenue 20,986,315 12,853,834 Total Receipts $ 51,713,451 $ 26,421,158 Disbursements General Fund Personnel Services (12,176,399) (12,873,440) Operating Expenses (4,845,543) (5,828,662) Capital Expenditures - - Non-Operating Expenses (201,186) (5,688) Total General Fund Disbursements (17,223,128) (18,707,790) Total All Other Funds Disbursements (23,888,352) (12,548,735) Total Disbursements (41,111,480) (31,256,525) Net Change in Cash Flow $ 10,601,970 $ (4,835,366) Summary of Cash by Fund January 2024 February 2024 General Fund $ 97,196,382 $ 92,055,917 General Fund Other 5,232,060 5,084,219 Capital Projects Funds 66,460,343 65,411,498 Debt Service Funds 30,809,276 30,652,777 Enterprise Funds 77,781,286 79,723,530 Trust and Agency Funds 5,800,313 5,008,251 Internal Service Funds 52,799,033 52,912,108 Special Revenue Funds 48,699,206 49,094,233 General Ledger Cash Balances * $ 384,777,899 $ 379,942,533 Total cash will differ from investment portfolio total due to outstanding checks and/or other timing differences. Note: Above information was obtained from the City's accounting system records.The above information includes receipts from maturing investments and payments for purchased investments in the city investment portfolio.This statement is prepared in compliance with the City's Charter. 22 47 aroy� Portfolio Summary ;.- 9 City of Huntington Beach $�N x Portfolio:CITY - ` Q Reporting Date:(FY2024) cFea M vY c% � 01/01/2024-01/31/2024 Full Accrual Basis Par Value Period Earnings Summary(31 Days) Fiscal YTD Summary(215 Days) Period Transactions Net Period Earnings $870,536.19 Net Period Earnings $5,452,105.23 Redemptions 0 Total Par Value $386,306,222.90 Last FY Period Net Earnings $532,677.73 i Last FY Period Net Earnings $2,765,587.58 Purchases .' 3 Avg Daily Book Balance $384,437,553.74 Avg Daily Book Balance $360,211,920.37 Total Activity 3 Net Effective Annual Return 2.706% Net Effective Annual Return 2.590% Fiscal YTD Transactions Redemptions 10 Purchases 11 Book Value Total Activity 21 Total Book Value $384,128,514.52 City Portfolio Certification. I certify that this report and the corresponding pages attached accurately reflect all portfolio combined investments and conforms with all California state statutes and the Huntington Beach investment policy filed on December 19,2023.The investment program herein shown provides sufficient cash flow liquidity to meet the next six month's obligations.Market values are provided by US Bank via Interactive Data Corp(IDC) The City Portfolio uses a 12 month moving average of the 1.5Yr Treasury for comparison purposes.This period,that rate is equal to:4.850% rf{' City Treasurer 01/31/2024 Alisa Backstrom Title Date Portfolio Investments Market Value Book Value Book Yield Days to Par Value Book Value Market Value Book Yield of Port Contribution Maturity Total Market Value $375,422,224.58 Cash/Money Market $748,112.80 $748,112.80 $748,112.80 0.19% 5.20% 0.01% 1 Local Govt Inv Pools(LGIP) $23,007,110.10 $23,007,110.10 $23,007,110.10 5.99% 5.54% 0.33% 1 U.S.Treasuries $88,000,000.00 $87,573,646.79 $85,417,930.00 22.80% 2.27% 0.52% 702 Supranational $40,000,000.00 $39,514,645.10 $38,769,850.00 10.29% 2.51% 0.26% 1,071 U.S.Agencies $182,980,000.00 $182,711,276.80 $177,434,696.50 47.57% 2.31% 1.10% 690 Corporates $51,571,000.00 $50,573,722.93 $50,044,525.18 13.17% 3.27% 0.43% 633 Total $386,306,222.90 $384,128,514.52 $375,422,224.58 100.00% 2.65% 682 23 48 Reporting Period: Cash By Structure Report Portfolio:CITY 01/31/2024 City of Huntington Beach Accounting ID Ticker Pool Description Type Par Value Book Value Market Value Rate %of Portfolio 104 FUZXX First American Treasury Obligations Cash/Money Market 748,112.80 748,112.80 748,112.80 5.200 0.19% Cash/Money Market Total 748,112.80 748,112.80 748,112.80 0.19% 003 _ CAMP California Asset Management Program LGIP 23,007,110.10 23,007,110.10 23,007,110.10 5.540 5.99% LGIP Total 23,007,110.10 23,007,110.10 23,007,110.10 5.99% Report Run Date: Apr 24,2024 24 49 Reporting Period: Bond Redemption Activity Report Portfolio:CITY 01/31/2024 City of Huntington Beach Accounting ID Transaction Type Cusip Description Price Settlement Posted Date Par Value Principal Accrued Interest Total Date Activity Total 0.00 0.00 0.00 0.00 Report Run Date: Apr 24,2024 25 50 Reporting Period: Bond Purchase Activity Report Portfolio:CITY 01/31/2024 City of Huntington Beach Accounting ID Transaction Type Cusip Description Price Settlement Posted Date Par Value Principal Accrued Interest Total Date 4408 Buy 91282CHQ7 T 4.125 07/31/2028 101.21500 01/16/2024 01/16/2024 10,000,000.00 10,121,500.00 189,436.14 10,310,936.14 4409 Buy 91282CFB2 T 2.750 07/31/2027 95.66400 01/19/2024 01/19/2024 5,000,000.00 4,783,200.00 64,266.30 4,847,466.30 4410 Buy 459058KW2 IBRD4.62508/01/2028 102.02000 01/25/2024 01/25/2024 5,000,000.00 5,101,000.00 76,440.97 5,177,440.97 Activity Total 20,000,000.00 20,005,700.00 330,143.41 20,335,843.41 Report Run Date: Apr 24,2024 26 51 Reporting Period: Bond Interest Received Report Portfolio:CITY 01/31/2024 City of Huntington Beach Accounting ID Transaction Type Cusip Description Date Posted Interest Received Purchased Interest Net Interest Adjustment 4334 Interest Income 3130AMW65 FHLB 0.50012/30/2024 01/02/2024 12,500.00 12,500.00 4345 Interest Income 3130AQ5S8 FHLB 1.250 06/30/2025 01/02/2024 29,062.50 29,062.50 4346 Interest Income _3130A7E7 —3130AQD59 FHLB 1.000 09/30/2024 01/02/2024 25,000.0025,000.00 4347 Interest Income _ — Q FHLB 1.500 06/30/2026 01/02/2024 —___37,500.00 -- 37,500.00 4349 — Interest Income -- 3130AQD59_ 4364 FHLB 1.000 09/30/2024 01/02/2024— 25,000.00 --— 25,000.00 Interest Income — _ 9128286Z8 T 1.750 06/30/2024 01/02/2024 61,250.00 61,250.00 --4370 Interest Income 912828XX3 T 2.000 06/30/2024 01/02/2024 50,000.00 50,000.00 _ _ 4379 Interest Income _ 91282CEW7 T 3.250 06/30/2027 01/02/2024 81,250.00 81,250.00 4406 Interest Income 91282CEW7 T 3.250 06/30/2027 01/02/2024 81,250.00 77,275.82 3,974.18 4390 Interest Income 931142EM1 WMT 3.050 07/08/2026 01/08/2024_ 64,919.25 64,919.25 4385 Interest Income 3134GYPF3 FHLMC 4.750 07/12/2027 —01/12/2024 — 78,375.00 _ _ 78,375.00 4402 Interest Income 459058K19 IBRD 3.500 07/12/2028 01/12/2024 87,500.00_ 58,819.44 — 28,680.56 4403 Interest Income 459058KT9— IBRD 3.500 07/12/2028 01/16/2024 — 87,500.00 — 70,000.00 17,500.00_ 4320 Interest Income 3130AKN36 FHLB 0.525 01/15/2026 _ 01/16/2024_ _13,125.00 — 13,125.00 - - 4384 Interest Income 3130AUMC5 _ FHLB 3.750 07/20/2026— 01/22/2024 — 93,750.00 — — 93,750.00 4321 Interest Income 3130AKN85 FHLB 0.550 01/20/2026 01/22/2024 13,750.00 13,750.00 4380 Interest Income 3134GYCP5 FHLMC 5.000 07/23/2024 01/23/2024 125,000.00 125,000.00 4338 Interest Income 459058JE4 IBRD 0.376 07/28/2025 01/29/2024 9,400.00 9,400.00 4371 Interest Income 459200KS9 IBM 4.000 07/27/2025 01/29/2024 120,000.00 120,000.00 4391 Interest Income 904764AU1 UNANA 2.000 07/28/2026 01/29/2024 25,050.00 25,050.00 4322 Interest Income 3130AKUS3 FHLB 0.500 01/28/2026 01/29/2024 12,500.00 12,500.00 4325 Interest Income 91159HHX1 USB 2.400 07/30/2024 01/30/2024 45,708.00 45,708.00 4330 Interest Income 91282CAB7 T 0.250 07/31/2025 01/31/2024 6,250.00 6,250.00 4341 Interest Income 91282CCP4 T 0.625 07/31/2026 01/31/2024 15,625.00 15,625.00 4353 Interest Income 912828Y87 T 1.750 07/31/2024 01/31/2024 43,750.00 43,750.00 4358 Interest Income 912828Y87 T 1.750 07/31/2024 01/31/2024 35,000.00 35,000.00 4408 Interest Income 91282CHQ7 T 4.125 07/31/2028 01/31/2024 206,250.00 189,436.14 16,813.86 4409 Interest Income 91282CFB2 T 2.750 07/31/2027 01/31/2024 68,750.00 64,266.30 4,483.70 Activity Total 1,555,014.75 459,797.70 1,095,217.05 Report Run Date: Apr 24,2024 27 52 Reporting Period: Bond Holdings By Sector Report Portfolio:CITY 01/31/2024 City of Huntington Beach Accounting CUSIP Ticker Coupon Maturity Date Short Description Trade Date Settlement Par Value Book Value Market Value Gain/Loss Book Effective Days to (%)of Moodys S&P Fitch ID Date Yield Duration Maturity Portfolio Rating Rating Rating 4364 9128286Z8 T 1.750 06/30/2024 U.S.Treasury Note 04/29/2022 05/02/2022 7.000,000.00 6,972,793.04 6,901,860.00 (70,933.04) 2.730 0.40 150 1.82% Aaa AA+ AA+ 4370 912828XX3 T 2.000 06/30/2024 U.S.Treasury Note 05/26/2022 05/27/2022 5,000,000.00 4,990,808.82 4,935,150.00 (55,658.82) 2.462 0.40 150 1.30% Aaa AA+ AA+ 4353 912828Y87 T 1.750 07/31/2024 U.S.Treasury Note 01/13/2022 01/14/2022 5,000,000.00 5,017,632.40 4,917,800.00 (99 832.40) 1.028 0.49 181 1.31% Aaa AA+ AA+ 4358 912828Y87 T 1.750 07/31/2024 U.S.Treasury Note 02/10/2022 02/11/2022 4,000,000.00 4,002,997.25 3,934,240.00 (68,757.25) 1.595 0.49 181 1.04% Aaa AA+ AA+ 4361 912828D56 T 2.375 08/15/2024 U.S.Treasury Note 03/21/2022 03/22/2022 5,000,000.00 5,003,492.02 4,928,150.00 (75,342.02) 2.240 0.52 196 1.30% Aaa AA+ AA+ 4298 912828YH7 T 1.500 09/30/2024 U.S.Treasury Note 12/04/2019 12/05/2019 5,000,000 00 4,996,976 72 4,887,700.00 (109,276.72) 1.595 0.65 242 _ 1.30% Aaa AA+ AA+ 4350 912828YM6 T 1.500 10/31/2024 U.S.Treasury Note 12/30/2021 12/31/2021 3,000,000.00 3,012,795.39 2,925,600.00 (87,195.39) 0.920 0.73 273 0.78% Aaa AA+ AA+ 4376 91282CEU1 T 2.875 06/15/2025 U.S.Treasury Note 11/17/2022 11/18/2022 3,000,000.00 2,946,015.96 2,936,850.00 (9,165.96) 4.276 1.32 500 0.77% Ma AA+ AA+ 4330 91282CA87 T 0250 07/31/2025 U.S.Treasury Note 05/18/2021 05/19/2021 500000000 497309153 4,700,400.00 (272,691.53) 0615 1.46 546 1.29% Ma AA+ AA+ 4340 91282CAJ0 T 0.250 08/31/2025 U.S.Treasury Note 09/23/2021 09/27/2021 5,000,000.00 4,962,277.72 4,686,900.00 (275,377.72) 0.735 1.54 577 1.29% Aaa AA+ AA+ 4351 9128284Z0 T 2.750 08/31/2025 U.S.Treasury Note 12/30/2021 12/31/2021 5000,000.00 5,127,034.80 4,876,950.00 (250,084.80) 1.103 1.51 577 1.33% Ma AA+ AA+ 4341 91282CCP4 T 0.625 07/31/2026 U.S.Treasury Note 09/30/2021 09/30/2021 5,000,000.00 4,960,457.75 4,593,350.00 (367,107.75) 0.950 2.42 911 1.29% Aaa AA+ AA+ 4339 91282CCW9 T 0.750 08/31/2026 U.S.Treasury Note 09/23/2021 09/23/2021 1,000,000.00 996.473.38 919,530.00 (76,943.38) 0.890 2.49 942 0.26% Aaa AA+ AA+ 4342 _91282CCW9 - T -_ 0.750 08/31/2026 U.S.Treasury Note 11/22/2021 11/23/2021 5,000,000.00 4,933,250.22 4,597,650.00 (335,600.22) _ 1285 2.49 942 1.28% Aaa AA+ AA+ 4379 91282CEW7 T 3.250 06/30/2027 U.S.Treasury Note 12/28/2022 12/29/2022 5,000,000.00 4,883,943.89 4,888,300.00 4,356.11 `_4.000 3.17 1,245 1.27% Ma _AA+ AA+_ 4406 91282CEW7 T 3.250 06/30/2027 U.S.Treasury Note 12/21/2023 12/22/2023 5,000,000.00 4,887,891.91 _ 4,888,300.00 408.09 3.960_ 3.17 1,245 1.27% Aaa AA+��AA+ 4409 _._. 91282CF82 T 2.750 07/31/2027 U.S.Treasury Note 01/18/2024 01/19/2024 5,000,000.00 4,785,386.50 4,804,300.00_ 18,913.50 4.080_ 3.28 1,276 1.25%_ Aaa AA+ AA+ 4408 91282CHQ7 T 4.125 07/31/2028 U.S.Treasury Note 01/12/2024 01/16/2024 10,000,000.00 10,120,327.50 i�10,094,900.00 _ (25,427.50) 3.831 4.06 1,642 2.63% Ma 4A+ AA+ U.S.Treasuries 88,000,000.00 87,573,646.79 85,417,930.00 (2,155,716.79) 22.80% 4323 459056HV2 IBRD 1.500 08/28/2024 Int'l Bank for Recon and Dev 04/21/2021 04/23/2021 5,000,000.00 5,030,646.31 4,895,900.00 (134,746.31) 0.425 0.56 209 1.31% Aaa AAA MA 4338 4590581E4 IBRD 0.376 07/28/2025 Int'l Bank for Recon and Dev 07/28/2021 07/30/2021 5,000,000.00 4,984,689.15 4,704,000.00 (280,689.15) 0.583 1.45 543 1.30% Aaa AAA AAA 4319 459058JL8 IBRD 0.500 10/28/2025 Int'l Bank for Recon and Dev 01/08/2021 01/12/2021 5,000,000.00 4,999,001.01 4,674,550.00 (324,451.01) 0.512 1.69 635 1.30%- Aaa AAA AAA 4324 45906M2L4 IBRD 0.650 02/24/2026 Int'l Bank for Recon and Dev 04/28/2021 04/30/2021 5,000,000.00 4,977,804.27 4,637,200.00 (340,604.27) 0.870 2.00 754 1.30% Ma AAA AAA .......... 4401 45818WEQ5 IADB 3.800 06/09/2028 Inter-American Development Bank 09/19/2023 09/21/2023 5,000,000.00 4,840,568.20 4,940,950.00 100,381.80 4.622 3.94 1,590 1.26% Aaa AAA AAA 4402 459058KT9 IBRD 3.500 07/12/2028 Int'l Bank for Recon and Dev 11/09/2023 11/13/2023 5,000,000.00 4,751,125.07 4,896,350.00 145,224.93 4.760 4.05 1,623 1.24% Ma AAA AAA 4403 459058KT9 IBRD 3.500 07/12/2028 Int'l Bank for Recon and Dev 12/04/2023 12/06/2023 5,000,000.00 4,830,183.79 4,896,350.00 66,166.21 4.350 4.05 1,623 1.26% Aaa AAA AAA 4410 459058KW2 IBRD 4.625 08/01/2028 Int'l Bank for Recon and Dev 01/23/2024 01/25/2024 5,000,000.00 5,100,627.31 5,124,550.00 23,922.69 4.130 3.96 1,643 1.33% Ma AAA AAA Supranational 40,000,000.00 39,514,645.10 38,769,850.00 (744,795.10) 10.29% 4387 3130AUXN9 FHLB 5.000 02/15/2024 Federal Home Loan Bank 04/24/2023 04/25/2023 3,000,000.00 3,000,076.76 2,999,550.00 (526.76) 4.923 0.04 14 0.78% Ma AA+ 4292 3133ECHX5 FFCB 2.260 03/13/2024 Federal Farm Credit Bank 05/22/2019 05/23/2019 5,000,000.00 5,000,131.10 4,982,750.00 (17,381.10) 2.236 0.11 41 1.30% Ma AA+ AA+ 4378 3130A1VC8 FHLB 4.875 06/14/2024 Federal Home Loan Bank 12/27/2022 12/28/2022 5,000,000.00 5,002,212.45 4,994,150.00 (8.062.45) 4.740 0.36 134 1.30% Aaa AA+� 4348 3130AQD42 FHLB 0.920 06/28/2024 Federal Home Loan Bank 12/14/2021 12/28/2021 5,000,000.00 5,000,000.00 4,914,300.00 (85,700.00) 0.920 0.40 148 1.30% Aaa AA+ 4380 3134GYCP5 FHLMC 5.000 07/23/2024 Freddie Mac 01/05/2023 01/23/2023 5,000,000.00 5,000,000.00 4,995,850.00 (4,150.00) 5.000 0.46 173 1.30% Aaa AA+ AA+ 4344 3130AQ3C5 FHLB 1.000 08/28/2024 Federal Home Loan Bank 12/01/2021 12/02/2021 4,000,000.00 4,000,000.00 3,907,360.00 (92,640.00) 1.000 0.56 209 1.04% Aaa AA+ 4373 3133XVDG3 FHLB 4.375 09/13/2024 Federal Home Loan Bank 09/22/2022 09/23/2022 5,000,000.00 5,003,924.08 4,985,300.00 (18,624.08) 4.240 0.59 225 1.30% Ma AA+ 4336 3130AMXJ6 FHLB 0.500 09/30/2024 Federal Home Loan Bank 06/17/2021 06/30/2021 5,000,000.00 5,000,000.00 4,854,050.00 (145,950.00) 0.500 0.65 242 1.30% Ma AA+ 4346 3130AQD59 FHLB 1.000 09/30/2024 Federal Home Loan Bank 12/14/2021 12/30/2021 5,000,000.00 5,000,000.00 4,869,000.00 (131,000.00) 1.000 0.65 242 1.30% Ma AA+ 4349 3130AQD59 FHLB 1.000 09/30/2024 Federal Home Loan Bank 12/22/2021 12/30/2021 5,000,000.00 5,000,000.00 4,869.000.00 (131,000.00) 1.000 0.65 242 1.30% Ma AA+ 4334 3130AMW65 FHLB 0.500 12/30/2024 Federal Home Loan Bank 06/15/2021 06/30/2021 5,000,000.00 5,000,000.00 4,804,850.00 (195,150.00) 0.500 0.89 333 1.30% Ma AA+ 4332 3130AMQ62 FHLB 0.625 03/14/2025 Federal Home Loan Bank 05/26/2021 06/14/2021 5,000,000.00 5,000,000.00 4,799,700.00 (200,300.00) 0.625 1.09 407 1.30% Ma AA+ 4397 3130AWER7 FHLB 4.625 06/06/2025 Federal Home Loan Bank 06/14/2023 06/15/2023 3,000,000.00 2,998,710.76 3,008,310.00 9,599.24 4.659 1.28 491 0.78% Ma AA+ 4329 3135G04Z3 FNMA 0.500 06/17/2025 Fannie Mae 05/13/2021 05/14/2021 5,000,000.00 4,991,295.59 4,737.600.00 (253,695.59) 0.628 1.34 502 1.30% Aaa AA+ 6.4+--- 4381 3135G04Z3 FNMA 0.500 06/17/2025 Fannie Mae 01/12/2023 01/13/2023 5,000,000.00 4,771,578.95 4,737,600.00 (33,978.95) 4.013 1.34 502 1.24% Aaa AA+ AA+ 4345 3130AQ5S8 FHLB 1.250 06/30/2025 Federal Home Loan Bank 12/08/2021 12/30/2021 4,650,000.00 4,650,000.00 4,451,166.00 (198,834.00) 1.250 1.37 515 1.21% Ma AA+ 4327 3130AMDL3 FHLB 0.800 07/25/2025 Federal Home Loan Bank 05/11/2021 05/25/2021 5,000,000.00 5000,00000 4743,350.00 (25665000) 0.800 1.44 540 1.30% Ma AA+ 4360 3130AQT94 FHLB 1.600 08/28/2025 Federal Home Loan Bank 03/03/2022 03/04/2022 4,575,000.00 4,560,002 65 4,380,333.75 (179,668.90) 1.816 1.51 574 1.19% Ma AA+ 4331 3130AMQ54 FHLB 0.700 09/16/2025 Federal Home Loan Bank 05/26/2021 06/16/2021 5,000,000.00 5,000,000.00 4,707,000.00 (293,000.00) 0.700 1.58 593 1.30% Ma AA+ 4318 3135GA2Z3 FNMA 0.560 11/17/2025 Fannie Mae 01/08/2021 01/11/2021 3,000,000.00 3,001,220.96 2,801,040.00 (200,180.96) 0.500 1.74 655 0.78% Ma AA+ AA+ 4320 3130AKN36 FHLB 0.525 01/15/2026 Federal Home Loan Bank 01/14/2021 01/15/2021 5,000,000.00 4,998,044.44 4,646,250.00 (351,794.44) 0.545 1.90 714 1.30% Aaa AA+ 4321 3130AKN85 FHLB 0.550 01/20/2026 Federal Home Loan Bank 01/14/2021 01/20/2021 5,000,000 00 4,999,015.28 4,646,500.00 (352 515.28) 0.560 1.92 719 1.30% Aaa AA+ 4322 3130AKUS3 FHLB 0.500 01/28/2026 Federal Home Loan Bank 01/26/2021 01/28/2021 5_000,000_00 5,000,000.00 4,638,550.00 (361,450.00) 0.500 1.94 727 1.30% Aaa AA+ 4333 3130ALEY6 FHLB 0.800 03/04/2026 Federal Home Loan Bank 06/09/2021 06/10/2021 5,000,000.00 5,000,000.00 4,646,500.00 (353,500.00) 0.800 2.02 762 1.30% Ma AA+ 4328 3130AMJN3 FHLB 1.030 05/26/2026 Federal Home Loan Bank 05/12/2021 05/26/2021 __.5,000,000.00 5,000,000.00 4.638,850_00 (361,150.00) 1.030 2.23 845 1.30% Ma AA+ Report Run Date: Apr 18,2024 28 53 Reporting Period: Bond Holdings By Sector Report Portfolio:CITY 01/31/2024 City of Huntington Beach Accounting CUSIP Ticker Coupon Maturity Date Short Description Trade Date Settlement Par Value Book Value Market Value Gain/Loss Book Effective Days to (%)of Maodys S&P Fitch ID - Date Yield Duration Maturity; Portfolio Rating Rating Rating 4335 3130AMF56 FHLB 0.750 06/12/2026 Federal Home Loan Bank 06/16/2021 06/17/2021 5,000,000.00 4,985,777.16 4,618,700.00 (367,077.16) 0.873 2.29 862 1.30% Aaa AA+ 4388 3130AVWS7 FHLB 3.750 06/12/2026 Federal Home Loan Bank 05/08/2023 05/09/2023 3,000,000.00 2,996,811.62 2,974,890.00 (21,921.62) 3.796 2.22 862 0.78% Aaa AA+ 4398 3133EPNG6 FFCB 4.375 06/23/2026 Federal Farm Credit Bank 06/22/2023 06/23/2023 3,000,000 00 2,998,922.50 3,015,060.00 16137 50 4.391 2.24 873 0.78% Aaa AA+ AA+ 4347 3130AQ7E7 FHLB 1.500 06/30/2026 Federal Home Loan Bank 12/14/2021 12/30/2021 5,000,000.00 5,001,072.84 4,679,250.00 (321,822.84) 1.339 2.31 880 1.30% Aaa AA+ 4384 3130AUMC5 FHLB 3.750 07/20/2026 Federal Home Loan Bank 01/17/2023 01/19/2023 5,000,000.00 5,000,000.00 4,953,000.00 (47,000.00) 3.750 2.32 900 1.30% Aaa AA+ 4356 3130AQ579 FHLB 1.375 08/07/2026 Federal Home Loan Bank 01/27/2022 02/07/2022 5,000,000.00 5,000,000.00 4,733,100.00 (266,900.00) 1.375 2.38 918 1.30% Aaa AA+ 4386 3133EPGT6 FFCB 3.875 04/26/2027 Federal Farm Credit Bank 04/21/2023 04/26/2023 5,000,000.00 4,995,348.09 4,975,300.00 (20,048.09) 3.906 2.97 1,180 1.30% Aaa AA+ AA+ 4389 3133EPJP1 FFCB 3.625 05/12/2027 Federal Farm Credit Bank 05/08/2023 05/12/2023 5,000,000.00 4,988,641.08 4,937,350.00 (51,291.08) 3.700 3.02 1,196 1.30% Aaa AA+ AA+ _4392_ 3130AW4N7 -_FHLB _- 3.630 06/04/2027_ _ _Federal Home Loan Bank_ __ 05/16/2023_.05/18/2023 __ 5,000,000.00 __y 5,000,000.00-_ 4,941,850.00 (58,150.00)__3.630 __3.08 1,219 1.30%_ _ Aaa__ AA+ _ _ 4396 3133EPMV4 FFCB 4.125 06/15/2027 Federal Farm Credit Bank 06/09/2023 06/15/2023 5,000,000.00 4,999,199.10 5,014,800.00 15,600.90 4.130 3.09 1,230 1.30% Aaa AA+ AA+ 4385 3134GYPF3 FHLMC 4.750 07/12/2027 Freddie Mac 04/21/2023 04/24/2023 3,300,000.00 3,295,953.26 3,273,369.00 (22,584.26) 4.791 1.43 1,257 0.86% Aaa AA+ AA+� 4405 3130AWWN6 FHLB 4.500 09/10/2027 Federal Home Loan Bank 12/04/2023 12/05/2023 4,455,000.00 4,471,741.86 4,530,957.75 59,215.89 4.383 3.23 1,317 1.16% Aaa AA+ 4395 3130AWC24 FHLB 4.000 06/09/2028 Federal Home Loan Bank 06/09/2023 06/13/2023 5,000,000.00,_- 5,004,016.04 5,012,000.00 7,983.96 3.979 3.93 _1,590 .1.30% __Aaa AA+ 4399 3130AWC24 FHLB 4.000 06/09/2028 Federal Home Loan Bank 06/26/2023 06/27/2023 5,000,000.00 4,997,580.25 5,012,000.00 14,419.75 4.012 3.93 1,590 1.30% Aaa AA+ 4400 31422X5U2 FAMCA 5.100 08/07/2028 Farmer Mac 08/02/2023 08/07/2023 _2,000,000.00 2,000,000.00 2,004,160.00 4,160.00 5.100 2.11 1,649 0.52% U.S.Agencies 182,980,000.00 182,711,276.80 177,434,696.50 (5,276,580.30) 47.57% 4355 67066GAL8 NVDA 0.584 06/14/2024 Nvidia 01/20/2022 01/24/2022 5,000,000.00 4,987,914.01 4,912,750.00 (75,164.01) 1.250 0.36 134 1.30% Al A+ 4325 91159HHX1 USB 2.400 07/30/2024 US Bank 04/28/2021 04/30/2021 3,809,000 00 3,843,148.82 3,752,474.44 (90,674.38) 0.528 0.48 180 1.00% A3 A A 4343 14913R2P1 CAT 0.600 09/13/2024 Caterpillar 11/30/2021 12/02/2021 5,000,000.00 4,988,456.44 4859,400.00 (129056.44) 0.980 0.60 225 1.30% A2 A A+ 4371 459200KS9 IBM 4.000 07/27/2025 IBM 08/09/2022 08/11/2022 6,000,000.00 6,015,838.65 5,944,020.00 (71,818.65) 3.810 1.42 542 1.57% A3 A- 4372 931142EW9 WMT 3.900 09/09/2025 Walmart 09/20/2022 09/22/2022 5,000,000.00 4,981,256.98 4,955,150.00 (26,106.98) 4.150 1.51 586 1.30% Aa2 AA AA 4382 717081DV2 PFE 2.750 06/03/2026 Pfizer Inc 01/13/2023 01/18/2023 5,000,000.00 4,849,479.51 4,800,050.00 (49,429.51) 4.142 2.21 853 1.26% A2 A A 4375 110122CN6 BMY 3.200 06/15/2026 Bristol-Myers Squibb 11/14/2022 11/16/2022 5000,00000 4861,067.65 4849,050.00 (1201765) 4.480 220 865 1.27% A2 A_ 4390 931142EM1 WMT 3.050 07/08/2026 Walmart 05/11/2023 05/15/2023 4,257,000.00 4188,85659 4,133.206.44 (55,650.15) 3.752 2.26 888 1.09% Aa2 AA AA 4391 904764AU1 UNANA 2.000 07/28/2026 Unilever 05/11/2023 05/15/2023 2,505,000.00 2,402,843.06 .__ 2366874.30 (35,968.76) 3.752 2.38 908 0.63% Al A+ A 4404 037833DN7 AAPL 2.050 09/11/2026 Apple__. 12/04/2023 12/06/2023 5,000,000.00 4,692,492.46 4,712,500.00 20,007.54 4.583 2.46 953 1.22% Aaa AA+ 4407 713448DN5 _.PEP ,___ 2.375 10/06/2026 Pepsi___ - 12/21/2023 12/26/2023 5,000,000.00 4,762,368.75 4759050.00 (3,318.75) 4.273 2.50 978 1.24% Al A+ WD r. Corporates 51,571,000.00 50,573,722.93 50,044,525.18 (529,197.75) 13.17% % Bond Holdings , 362,551,000.00 360,373,291.62 351,667,001.68 (8,706,289.94) 93.82% • • Report Run Date: Apr 18,2024 29 54 ,r tAIIN67`. Statement of Cash Receipts and Disbursements and 1C-3 = Summary of Cash by Fund °FC u'N c i// City Treasurer's Office 202 January Cash Receipts and Disbursements December 2023 January 2024 Receipts General Fund Property Tax $ 23,817,212 $ 19,158,531 Local Sales Tax 3,996,591 3,385,565 Public Safety Sales Tax 285,478 241,753 Transient Occupancy Tax(TOT) 1,072,762 1,031,836 Utility Users Tax(UUT) 1,642,396 1,854,414 Other Revenue 4,462,678 5,055,037 Total General Fund Revenue 35,277,117 30,727,136 Total All Other Funds Revenue 22,491,481 20,986,315 Total Receipts $ 57,768,599 $ 51,713,451 Disbursements General Fund Personnel Services (16,299,110) (12,176,399) Operating Expenses (3,789,596) (4,845,543) Capital Expenditures - - Non-Operating Expenses (466,907) (201,186) Total General Fund Disbursements (20,555,613) (17,223,128) Total All Other Funds Disbursements (26,181,844) (23,888,352) Total Disbursements (46,737,457) (41,111,480) Net Change in Cash Flow $ 11,031,142 $ 10,601,970 Summary of Cash by Fund December 2023 January 2024 General Fund $ 83,517,850 $ 97,021,857 General Fund Other 5,346,116 5,225,669 Capital Projects Funds 67,553,371 66,230,097 Debt Service Funds 29,577,241 30,734,758 Enterprise Funds 81,583,525 77,575,831 Trust and Agency Funds 3,362,860 5,777,599 Internal Service Funds 54,079,271 52,610,362 Special Revenue Funds 48,080,997 48,527,027 General Ledger Cash Balances * $ 373,101,230 $ 383,703,201 Total cash will differ from investment portfolio total due to outstanding checks and/or other timing differences. Note: Above information was obtained from the City's accounting system records.The above information includes receipts from maturing investments and payments for purchased investments in the city investment portfolio.This statement is prepared in compliance with the City's Charter. 30 55 1'.\Ala %//'!'�I',.► ING in'I'vq--. . .•••• pRP ORA re••••.. __ _ „;- - • .. /7 Investment ,, ,, c..., ,,,, Report __ _, , . ,-_- . , C-/%("Y__,___-!"--/ ' AI 6'• Fa. . • P°:' r Alisa Backstrom , MBA, CCMT, CPFIM \<c 0 A, Elected City Treasurer IV çS1##.. 1 / Quarter Ended : March 31 , 2024 56 INTEREST RATES - US TREASURY YIELD CURVE MARCH 28, 2024 INVERTED YIELD CURVE 1—MO = "t, 5.49% 1---w-+ ---,,,,, 1 -MO. = 5.49% 2-YR = 4.59% .5 D 5-YR = 4.21 % I tr ILIUM 2-YR: 4.59% •,,,,„,,,,,...........„ 1101INGto — II * A , .............. * Nib, OF cs. ...•\‘‘z,01IP 0 9 A re.... .."..., tA ...) .___ ! 0 v 4t.. ..: _____________ ___ 4 4 5-YR: 4.21% : -. --- --- ••.-'7 —• :4ibwiiiiiiihb, • c) -- • i C)It ry:—4.;.,,,,,:-..s77::?•,,,._ -11"--,— : Gr i 4 2 • \.V3 % " ' .' 'i'o-,1 2_•,--- e 1.fP It2 ;Li .ti 4"-p tik" 1Y A.Y re Ei It 'i't J CO. 3f.tY Nk"7 *. ,-,.-- -..::°-.:1 ":e.-:—• ' ' V ,...„,,,.,e •...;....Ins;..... <c 0 U UNTN Vil';,lif 57 INVESTMENT PORTFOLIO — SUMMARY QUARTER END 3/31 /24 ($.. ,. . ,„....11ions)¢ Investment Type Book Value Market Vawlue U.S. Agencies $ 174.7 $ 168.9 U.S. Treasuries $ �92.6� $ 90.1 Corporate Bonds $ 55.7 $ 55.0 CAMP Investment Pool $ 18.2 $ 18.2 �,,•--- I, TINcro Supranational Bonds $ 39.5 $ 38.5 vi'off `":�-oA° rFo•••�6‹, Cash/money Market $ 0.6 $ 0.6 = ' TOTAL $381 .5 $ 371 .3 * .;•••,;FQ . o4 °, Ns .' `°OUNTY C Ae//0 58 INVESTMENT PORTFOLIO - INVESTMENTS BY TYPE QUARTER END 3/31 /24 46% 24% 14.5% 10% 5% 0.5% ,, f a , bed . i�U Ncr0— '� Off(• +\��pRPORgrfQ••.. \ • l • genc es . eses GOpraeords . � • z� _ C P I 0 C i U • .upratioi :a15: : :•: : : : CAMS G.ash.� . I+one�.Market . --� ,,, 59 INVESTMENT PORTFOLIO - BY MATURITY QUARTER END 3131 /24 Maturity Distribution 4-5Yr / \CASH ,, 3-4Yr ' 11_17% 0-lYr z: :• r'`'�26..`.% v ` ,i''NTINcr .2-3I r '� O�(•.••�NGpRPONgTFO•••. V • 19.18 5- �.._ i i ce \ 1-2Yr " ., yam,��, •: .. iii , - _ '" �`26.12% k\,/) 4•. t e8.. .-._,; /c„ r••i i • • Book Valhue % of Portfolio .�.�.i 60 INVESTMENT PORTFOLIO - SELECTED ACTIVITY QUARTER END 3/31 /24 . , : ', err ... r- r °;3. .,� d .y "F '%8';" "" „arm+�A�y } q ; .s�{"� �g '� .b t° 4 � XG �?+ti_ � $ s1� r f + mm�'"�w" "` ' sY�� �p ' �*`,.., w"$'�c t `.� +� ' p�,st w.. '`--.•.. ` :, .� ! :, y •. ,a"f t:. %a " w s+ .. S. xH w Ra...; "ai 8�= ;; "S".+ r : ',aw 'c .i. ¢� ,'�� ^t e,w, x ^t 'i„, .� yu• ,�, ,X 5� a 4 . ; ,ra �$-e41 Aói Pii4�(e 'x ..`Y.,j5 i Ya 11 d s. , ws,5 r4,, r$ ..§., y .,6 + P+; .. 1'' 1 a .r � P7 . n^i4 i a` •31r it x'''S,I, r', 1 x .,t 'Zh a +s rt• -' a .4wy+" .;ii ^`4:3'S'rYy r . ii+� 'Y.. S .y,� e.a'� C't� ye • w.'k 'ar '6.� 'r•X 'e¢ 'ri"5 �:' �a a fit. $ k '1.e use i.. s$b a,wc"� �` $; � a � � °`*: �' �r y�y�s ,�qg� a, r ,?p..: «t:L 1.».n Rk�,.�#x:.��...a�:,,�s .gs;, , ��„�,.. .ray- d° , � .�.,�. �•m`"z"� ....�.ss.�+�,�`�.:...Al:...'�»lC".�i` �a'�fi.'�i t S�`� .�` i .. _ .,.fe.�..-.-. .4r.t.P L.. °ae. ..,,+".#°x,. .8:. ..�°e+ .s.�"sr ...ru..::,.,._ * tr • 4 k:'.. x'";^...*.i,.."r',""'..',4"i'.isr:c�t'+°.*".`."4:3."�e 4; y •Q. v� x lit,..•�'. ' �''-,;..ka.a':' _ �,.,. �*.tl' •'a d.7 ,,�a..t q� 9. ,s�y..�,.e„»3'. �ti w� ..f,, �..�.• �,� . feK "vrY ,5ra " i) c .i.� a.. e r ,4 t* : : i;U ° .,* 4 i ‘ %, rsk fj Pjt s , a"ASaa , ,. . i, a. ,!' . y�a +r ...a Wi�' v' . i ffia s: ' V as es t � - ' r „g +e�r � y - .k —, *s°.'• e a: t x " e . ?' tb ri'•y 'r S { �n awF t"$ .• 3 g.. re asu i\ sa x E ra tl ea4t ,,ftx,, ... 4 � r $ 4 A•. Aa a: ? r •w. °' •e: a : .«: r i ' 4+ .i� +; "'$ r' •#a• R _ t :"h! x '''.1..,.,T 'f�f - :, ae:#kv� %4'� f.. Sz4e.''Vz'',as .,41.„ -;+s �'.;g: ,. .a ex.: a :;ee t d ot .'�,' .s.1. "�'.4 . .4:.,4" y ° �" t s • ..+.� ar� s. s4 j., � s a.. 'iqa :tr • s wg S�;f .,�, �'`Z.•.�'. '�a,� �.a.:� ����,,�s$•(:,�^ 1+,± Pg mil+ �` • � •'S.-y a �,y"�:�F dY"� a��� �7t 4 �5 9 t "` +sk _ �, ►e +�,, 'YL: ' 0„r ,0y8--t�:/ '' . s'.443 .x.a '`qi' :, ".^: *.' r8 $`'R ,:i;i ay,;a %w r. ✓a� 'av*,: '` r, e'4`": 5,v=.. r�1`�. ii.. t� {� P •. 7 e u .` + .T*y'. S '++ z .t IP ii, o h G,ss V a ". r;'r + a.' „, t jr .4,::. t t'.4a "'r Oxl"`Ii� %Sr`t� .3z Z°` .s� �,d[#.. ec-.. .s..d, ' �, a.,�.. i e,w¢+.,y.$,e:y^yc� plat .7t�c' r ' :} 3e ;n'r""tn..�y,+' *'� s .e {-"A.!'t ` sE " s' "e y''y ! }� • '.t°:-, a m. ' 1:,- x .,x� . € A' a ..• - • `" t•- r•`•v ,e o b.,:'Y� az• /� .e ,,.�,y ; � s g px. '6 e: , nr x 7ae I I, NT I N G j ^`aM., ....�t.'.'C Ps 4'�.. � �." ✓ +«l8 't s .s r is .' 3a § A ) 'y`� y a a•7 .n,+y a: T r e , •iw in.: 4"Yr' .7, 7 if*: °x:' ri%'' sr h ?.: `,:'4.7s" a`:''ar^n. " \`�•+•....a••.• .. t+ e-. i i.. a.',�*^ + a. ' t '7,,° .", ,t '° `�1.'f.+.e ,'* + +,4 '3'`�y '•° 4£ 's O` `NCflAPORgpf'•••_ Jr...., • ,r r a„isw' ®' i i. 1e i9.g t?.• .ya .`4". t P4;. "s.:I 'It: .447 , '}' �! v. b�1:'`•1°x: ,s1•"LV"y, '° .; •w i t:e '' +,-.\___` 0 •tt NN 3 Ki �. •ra s ^ti, `� Yf , t�. >,I Q 1 � � , r M = P�r h Fib 1i e'x i te*w x'' �« r asP4' °1'xI ` ... C . ` ,'., +P:,7 `+.n.�aR`" ;rX .;1„ :a� �,:a•r 7•,.�• ','�'i,'',,t, y'a ?• Y..S.'� ;�4§s 4•� sa• ,,,,y z, ,.c :.ice?f'A°'ft,^§P®'.t "i' .a '4:e s a' ;�'L7a Y. 1 CJ.• i= 4 v $ �,. .?. .aft'. �, w � � yt ;� , r � ,� ��.��.�>,J{„ �• .a�" ... �9 r �� c A , �" y.tu,7 � � e ,q;_a -,'' a t $ m a5 a'tc,,r ?k '_�° 'S# i r s. t . ,*, a�,'` ;, ;;;',. e• : .a r:_fi �iP-z �'�d< 7xP e.'�fi4 f '..t �g �c ,r < > ,mow `"'ze.4.. . '+.!9a"a'�t."�'.... -'.'» `"'...; i a..;•. l+er is... s^.r?�.s,. .. a ..3,..1.'.t Mv..:�:t?�C�`.. fx:... '€i> a..,..n,A.. ± ' c ..Y. . ;Q .r .z. .e// fib ..'� i Total Purchases: $30 million Total Maturities: $8 million ''��UUNTN cP /'� 61 INVESTMENT PORTFOLIO - EARNINGS • QUARTER END 3/31 /24 • $844,666 Up 47% psPw • $7,119,725 Up 84% • 2.6 5 % I vNT I N G 0' O� •.•\\atpRP ORgrep'•• ST \ .; .7rotiv,, • • 2.60 % :9 , .• , • �/ '0UNTY °.% 1 62 INVESTMENT PORTFOLIO - SELECTED COMPLIANCE QUARTER END 3/31 /24 iAXI U INVESTMENT MAXIMUMEr, MINIMUM'QUALITY' IN TYPE ; MATURITY a ; REQUIREMENTS OMPL1 HCE? MAXIMUM ' '' an a z 0 s r. 4 ISSUER i.. li - .a 2 I d a[ s r U.S. Treasuries 5 years None None YES U.S,Agencies 5 years None None YES Supranationals 5 years 30% "AA"Rating Category YES Corporate Bonds 5 years 30%(10% "A"Rating Category YES Monoy Market 60 days 15°10�10°l0 "AAA"Rating ��,�,-�.._�a Mutual Funds Category YES ''io���NTPNGTp��\ GA Asset 1 :—_�.-ot : Management N/A Up to75,000,000 None �, _ Program (CAMP) YES � Maximum Maturities No mono than 50%of portfolio maturing over 4 years. YES ��6.0-% ,.F----_ < ��1� COUNTY t/IFS 63 ADDITIONAL INFORMATION Cityof Huntington Beach Webs ite : Ci• y t Treasurer • Investments . https ://www. huntin tonbeachca . ov/ overnment/ g g g cit�/_treasurer investments. h ,, „......,..... ��UN 1 Ncro J I ePOR ''•. •, i d`--.-'�1t0 'ire ... �� 1 U. '''':7-NT:1:: 4rif 64