City of Huntington Beach
Quarterly Investment Report
June 2023
Pre
pared by:
Alisa Backstrom, MBA, CCMT, CPFIM
Ci
ty Treasurer
Colin Stevens, MPP
Treasury Manager
1 IN
VESTMENT PORTFOLIO SUMMARY
As of June 30, 2023
Cur
rently, 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, and corporate bonds. Only the investment types allow ed under California Government code Section 53601 and the City’s Investment Policy Statement are utilized.
The Federal Reserve Open Market Committee (“FOMC” or “the Fed”) continued to raise the federal funds rate throughout the first half of 2023. Over the last year, the Fed has s ignificantly moved the target rate off the 0% level that it had maintained for two years, with the central bank raising rates ten
times since March 2022 in an effort to combat inflation. At the most recent June 2023 meeting, the FOMC maintained the federal funds rate at 5 to 5.25 percent.
As interest rates rise, the market value of securities previously purchased at lower than the current market rates, goes down. This has resulted in the current market value of the portfolio being lo wer than the book value, at $360.6 million versus $376.3 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 PORTFOLIO BREAKOUT BY SECTOR
As of June 30, 2023
The largest holding by security type at month-end was U.S. Agency securities at approximately 50% of the total overall portfolio. This was followed by U.S. Treasur y securities at approximately 22% of the total portfolio as of June 30, 2023. Cash held in the Local Government Investment Pools (“LGIP”) has been reduced as longer-term securities have seen interest rates rise.
INV
ESTMENT PORTFOLIO EARNINGS
As of June 30, 2023
3 Earnings for the month of June 2023 were $730,988, an increase of approximately 117% from the same month in the prior year. Fiscal year- to-date earnings of $5,897,287 were up approximately 69% 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
2.37%, with a
fiscal year-to-date return of 1.78%. The increase in the June rate of return over that of the fiscal year-t o
-date return is a result of the portfolio investing in the higher available rates. The benchmark has increased rapidly with the sharp rise in interest rates through 2022 and the first half of 2023. At the end of June, the 12-month moving average of the interpolated 1.5-year U.S. Treasury was 4.28%. The portfolio will lag behind the benchmark, as it will take time for previously purchased securities to mature and for f unds to be reinvested.
QUARTERLY PORTFOLIO ACTIVITY - SECURITIES
April 1 to June 30, 2023
As the Federal Reserve continued to raise rates in the first half o f the year , available funds were invested into higher yielding options. For the quarter ending June 30, 2023, thirteen U.S.
Agencies were purchased totaling $60.3 million and two corporate bonds (Walmart Inc. and Unilever) were purchased totaling $6.8 million. Seven U.S. Agencies matured for $38 million, and
$5 million in Commercial Paper ma tured.
4 CO
MPLIANCE SUMMARY
As of June 30, 2023
There were no compliance issues during this period.
ECONOMIC AND MARKET OVERVIEW
Th
e 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 recent indicators suggest that economic activity has continued to expand at a modest pace. In addition, the Committee anticipates that some additional policy firming may be appropriate in order to return inflation to 2 percent over time. The Committee stated that it would take into account the cumulative tightening of monetary policy, the lags with which monetary policy affects economic activity and inflation, and economic and financial developments.
5 Fixed Income / Equity Markets: The yield on the 10-y ear U.S. Treasury finished the quarter at
3.81%, up from 3.48% at the end of March. The S&P 500 increased by 8.30% for the quarter while the DJIA increased by 3.41% respectively, over the same period. For the 12-months ending June 30, 2023, the S&P 500 was up 17.57% and the DJIA was up 11.8%.
Empl
oyment: Total nonfarm payroll employment rose by 209,000 in June, and the unemployment rate was little changed at 3.6 percent. Notable job gains occu rred in government, health care, social assistance, and construction.
6 Par Value Book Value Book Value % of
Port Market Value Book Yield
Contribution Days to Maturity
Local Govt Inv Pools (LGIP)
U.S. Treasuries
Supranational
U.S. Agencies
Corporates
Hold
Total
$29,609,946.55 $29,609,946.55 7.87% $29,609,946.55 0.412% 1 $83,000,000.00 $82,720,223.36 21.98% $79,016,180.00 0.356% 577 $29,000,000.00 $29,015,911.05 7.71% $27,325,370.00 0.086% 527 $189,525,000.00 $189,095,763.01 50.24% $179,931,506.25 1.177% 822 $46,446,000.00 $45,906,734.74 12.20% $44,687,293.02 0.351% 696 $377,580,946.55 $376,348,578.72 100.00% $360,570,295.82 2.382% 665 Portfolio Investments
06/30/2023
Date
City Treasurer
TitleAlisa Backstrom
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 January 17, 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) Certification
Fiscal YTD Transactions
Redemptions 7
Purchases 5
Total Activity 12
Period Transactions
Redemptions 16
Purchases 29
Total Activity 45
Net Period Earnings $5,897,286.92
Last FY Period Net Earnings $3,492,178.31
Avg Daily Book Balance $331,371,561.00
$1.00 $1.00
Net Effective Annual Return 1.780%
Net Period Earnings $730,988.46
Last FY Period Net Earnings $336,650.63
Avg Daily Book Balance $379,918,918.66
$1.00 $1.00
Net Effective Annual Return 2.366%
Fiscal YTD Summary (365 Days)Period Earnings Summary (30 Days) ______________________________________________ ____________________________ Portfolio Market Value
Accrued Interest Paid at
Purchase
sum2
Total Market Value
$360,570,295.82
$118,604.00
$1.00
$360,688,899.82
Portfolio Book Value
Accrued Interest Paid at
Purchase
sum2
Total Book Value
$376,348,578.72
$118,604.00
$2.00
$376,467,182.72
Market Value
Book Value
Par Value
Portfolio Summary
Huntington Beach
Portfolio: CITY
Reporting Date: (FY2023)
06/01/2023 - 06/30/2023
Full Accrual Basis
sum2
Total Par Value
$1.00
$377,580,946.55
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.280% ____________________________________________
7 Accounting ID Pool Description Type Par Value Book Value Market Value Rate % of Portfolio Composite Rating 003
California Asset Management Program
LGIP
29,609,946.55
29,609,946.55
29,609,946.55
5.24 7.87%
NR
CITY Fund Total 29,609,946.55 29,609,946.55 29,609,946.55 7.87% Portfolio: CITYCash By Fund Report
City of Huntington Beach
Reporting Period:
06/30/2023
Page: 1 Report Run Date: Jul 11, 2023
8 Accounting ID Cusip Security Description Purchase Date Par Value Book Value Market Value Book Yield Effective Duration
Days to
Maturity
(%) of
Portfolio Mdy/S&P/Fitch
4352 912828S92 T 1.250 07/31/2023 (0.08Yr-Fixed) 01/14/2022 5,000,000.00 5,002,206.04 4,984,650.00 0.711 0.08 30 1.33% Aaa/AA+/AAA 4357 91282CCN9 T 0.125 07/31/2023 (0.08Yr-Fixed) 02/02/2022 5,000,000.00 4,996,467.14 4,980,600.00 0.991 0.08 30 1.33% Aaa/AA+/AAA 4354 9128282D1 T 1.375 08/31/2023 (0.17Yr-Fixed) 01/21/2022 5,000,000.00 5,003,896.93 4,968,800.00 0.903 0.17 61 1.33% Aaa/AA+/AAA 4364 9128286Z8 T 1.750 06/30/2024 (1.00Yr-Fixed) 05/02/2022 7,000,000.00 6,933,796.39 6,751,430.00 2.730 0.97 365 1.84% Aaa/AA+/AAA 4370 912828XX3 T 2.000 06/30/2024 (1.00Yr-Fixed) 05/27/2022 5,000,000.00 4,977,634.80 4,835,150.00 2.462 0.97 365 1.32% Aaa/AA+/AAA 4353 912828Y87 T 1.750 07/31/2024 (1.08Yr-Fixed) 01/14/2022 5,000,000.00 5,038,576.96 4,809,000.00 1.028 1.04 396 1.34% Aaa/AA+/AAA 4358 912828Y87 T 1.750 07/31/2024 (1.08Yr-Fixed) 02/11/2022 4,000,000.00 4,006,557.51 3,847,200.00 1.595 1.04 396 1.06% Aaa/AA+/AAA 4361 912828D56 T 2.375 08/15/2024 (1.13Yr-Fixed) 03/22/2022 5,000,000.00 5,007,322.55 4,838,500.00 2.240 1.08 411 1.33% Aaa/AA+/AAA 4298 912828YH7 T 1.500 09/30/2024 (1.25Yr-Fixed) 12/05/2019 5,000,000.00 4,994,290.74 4,770,700.00 1.595 1.21 457 1.33% Aaa/AA+/AAA 4350 912828YM6 T 1.500 10/31/2024 (1.34Yr-Fixed) 12/31/2021 3,000,000.00 3,022,872.35 2,854,440.00 0.920 1.29 488 0.80% Aaa/AA+/AAA 4376 91282CEU1 T 2.875 06/15/2025 (1.96Yr-Fixed) 11/18/2022 3,000,000.00 2,922,802.82 2,885,730.00 4.276 1.87 715 0.78% Aaa/AA+/AAA 4330 91282CAB7 T 0.250 07/31/2025 (2.08Yr-Fixed) 05/19/2021 5,000,000.00 4,962,495.70 4,549,800.00 0.615 2.02 761 1.32% Aaa/AA+/AAA 4340 91282CAJ0 T 0.250 08/31/2025 (2.17Yr-Fixed) 09/27/2021 5,000,000.00 4,948,221.76 4,536,350.00 0.735 2.11 792 1.31% Aaa/AA+/AAA 4351 9128284Z0 T 2.750 08/31/2025 (2.17Yr-Fixed) 12/31/2021 5,000,000.00 5,174,370.13 4,789,450.00 1.103 2.05 792 1.37% Aaa/AA+/AAA 4341 91282CCP4 T 0.625 07/31/2026 (3.08Yr-Fixed) 09/30/2021 5,000,000.00 4,951,125.60 4,454,500.00 0.950 2.97 1,126 1.32% Aaa/AA+/AAA 4339 91282CCW9 T 0.750 08/31/2026 (3.17Yr-Fixed) 09/23/2021 1,000,000.00 995,668.47 891,880.00 0.890 3.04 1,157 0.26% Aaa/AA+/AAA 4342 91282CCW9 T 0.750 08/31/2026 (3.17Yr-Fixed) 11/23/2021 5,000,000.00 4,918,015.39 4,459,400.00 1.285 3.04 1,157 1.31% Aaa/AA+/AAA 4379 91282CEW7 T 3.250 06/30/2027 (4.00Yr-Fixed) 12/29/2022 5,000,000.00 4,863,902.07 4,808,600.00 4.000 3.68 1,460 1.29% Aaa/AA+/AAA U.S. Treasuries Total 83,000,000.00 82,720,223.36 79,016,180.00 21.98% 4290 45818WBX3 IADB 2.870 07/20/2023 (0.05Yr-Fixed) 03/28/2019 4,000,000.00 4,001,198.76 3,995,520.00 2.270 0.05 19 1.06% Aaa/AAA/AAA 4291 45818WBY1 IADB 2.960 08/16/2023 (0.13Yr-Fixed) 03/28/2019 5,000,000.00 5,004,076.52 4,984,550.00 2.271 0.13 46 1.33% Aaa/AAA/AAA 4323 459056HV2 IBRD 1.500 08/28/2024 (1.16Yr-Fixed) 04/23/2021 5,000,000.00 5,061,736.76 4,783,750.00 0.425 1.12 424 1.34% Aaa/AAA/AAA 4338 459058JE4 IBRD 0.376 07/28/2025 (2.08Yr-Fixed) 07/30/2021 5,000,000.00 4,978,701.67 4,564,100.00 0.583 2.01 758 1.32% Aaa/AAA/AAA 4319 459058JL8 IBRD 0.500 10/28/2025 (2.33Yr-Fixed) 01/12/2021 5,000,000.00 4,998,666.43 4,538,200.00 0.512 2.25 850 1.33% Aaa/AAA/AAA 4324 45906M2L4 IBRD 0.650 02/24/2026 (2.65YrNC1.81Mo-Dq-Fixed) 04/30/2021 5,000,000.00 4,971,530.91 4,459,250.00 0.870 2.55 969 1.32% Aaa/AAA/AAA Supranational Total 29,000,000.00 29,015,911.05 27,325,370.00 7.71% 4383 3130AUHE7 FHLB 0.000 07/26/2023 (0.07Yr-Disco) 01/18/2023 5,000,000.00 5,000,380.32 4,998,200.00 4.755 0.07 25 1.33% Aaa/AA+/NR 4289 3135G0U43 FNMA 2.875 09/12/2023 (0.20Yr-Fixed) 03/15/2019 5,000,000.00 5,003,802.47 4,974,350.00 2.465 0.20 73 1.33% Aaa/AA+/AAA 4377 313384ND7 FHDN 0.000 10/19/2023 (0.30Yr-Disco) 12/05/2022 3,000,000.00 2,957,787.50 2,955,600.00 4.817 0.30 110 0.79% P-1/A-1+/NR 4387 3130AUXN9 FHLB 5.000 02/15/2024 (0.63Yr-Fixed) 04/25/2023 3,000,000.00 3,001,228.14 2,988,540.00 4.923 0.60 229 0.80% Aaa/AA+/NR 4292 3133ECHX5 FFCB 2.260 03/13/2024 (0.70Yr-Fixed) 05/23/2019 5,000,000.00 5,000,786.59 4,878,400.00 2.236 0.68 256 1.33% Aaa/AA+/AAA 4378 3130ATVC8 FHLB 4.875 06/14/2024 (0.96Yr-Fixed) 12/28/2022 5,000,000.00 5,005,705.80 4,971,100.00 4.740 0.92 349 1.33% Aaa/AA+/NR 4348 3130AQD42 FHLB 0.920 06/28/2024 (0.99YrNC2.96Mo-Dq-Fixed) 12/28/2021 5,000,000.00 5,000,000.00 4,781,150.00 0.920 0.97 363 1.33% Aaa/AA+/NR 4380 3134GYCP5 FHLMC 5.000 07/23/2024 (1.06YrNC3.78Mo-1x-Fixed) 01/23/2023 5,000,000.00 5,000,000.00 4,966,600.00 5.000 0.84 388 1.33% Aaa/AA+/AAA 4344 3130AQ3C5 FHLB 1.000 08/28/2024 (1.16YrNC1.94Mo-Dq-Fixed) 12/02/2021 4,000,000.00 4,000,000.00 3,798,800.00 1.000 1.12 424 1.06% Aaa/AA+/NR 4373 3133XVDG3 FHLB 4.375 09/13/2024 (1.20Yr-Fixed) 09/23/2022 5,000,000.00 5,007,636.06 4,938,400.00 4.240 1.14 440 1.33% Aaa/AA+/NR 4336 3130AMXJ6 FHLB 0.500 09/30/2024 (1.25YrNC3.02Mo-Dq-Fixed) 06/30/2021 5,000,000.00 5,000,000.00 4,701,050.00 0.500 1.22 457 1.33% Aaa/AA+/NR 4346 3130AQD59 FHLB 1.000 09/30/2024 (1.25YrNC3.02Mo-Dq-Fixed) 12/30/2021 5,000,000.00 5,000,000.00 4,730,950.00 1.000 1.21 457 1.33% Aaa/AA+/NR 4349 3130AQD59 FHLB 1.000 09/30/2024 (1.25YrNC3.02Mo-Dq-Fixed) 12/30/2021 5,000,000.00 5,000,000.00 4,730,950.00 1.000 1.21 457 1.33% Aaa/AA+/NR 4334 3130AMW65 FHLB 0.500 12/30/2024 (1.50YrNC3.02Mo-Dq-Fixed) 06/30/2021 5,000,000.00 5,000,000.00 4,652,200.00 0.500 1.46 548 1.33% Aaa/AA+/NR 4332 3130AMQ62 FHLB 0.625 03/14/2025 (1.70YrNC2.50Mo-Dq-Fixed) 06/14/2021 5,000,000.00 5,000,000.00 4,631,150.00 0.625 1.65 622 1.33% Aaa/AA+/NR 4397 3130AWER7 FHLB 4.625 06/06/2025 (1.93Yr-Fixed) 06/15/2023 3,000,000.00 2,998,152.53 2,978,490.00 4.659 1.82 706 0.80% Aaa/AA+/NR Portfolio: CITYSecurities By Structure Report
City of Huntington Beach
Reporting Period:
06/30/2023
Report Run Date: Jul 11, 2023
9 Accounting ID Cusip Security Description Purchase Date Par Value Book Value Market Value Book Yield Effective Duration
Days to
Maturity
(%) of
Portfolio Mdy/S&P/Fitch
4329 3135G04Z3 FNMA 0.500 06/17/2025 (1.96Yr-Fixed) 05/14/2021 5,000,000.00 4,987,610.25 4,590,400.00 0.628 1.91 717 1.33% Aaa/AA+/AAA 4381 3135G04Z3 FNMA 0.500 06/17/2025 (1.96Yr-Fixed) 01/13/2023 5,000,000.00 4,674,868.42 4,590,400.00 4.013 1.91 717 1.24% Aaa/AA+/AAA 4345 3130AQ5S8 FHLB 1.250 06/30/2025 (2.00YrNC3.02Mo-Dq-Fixed) 12/30/2021 4,650,000.00 4,650,000.00 4,318,966.50 1.250 1.93 730 1.24% Aaa/AA+/NR 4327 3130AMDL3 FHLB 0.800 07/25/2025 (2.07YrNC1.84Mo-Dq-Fixed) 05/25/2021 5,000,000.00 5,000,000.00 4,593,900.00 0.800 2.00 755 1.33% Aaa/AA+/NR 4360 3130AQT94 FHLB 1.600 08/28/2025 (2.16Yr-Fixed) 03/04/2022 4,575,000.00 4,554,448.07 4,262,115.75 1.816 2.06 789 1.21% Aaa/AA+/NR 4331 3130AMQ54 FHLB 0.700 09/16/2025 (2.21YrNC2.56Mo-Da-Fixed) 06/16/2021 5,000,000.00 5,000,000.00 4,562,100.00 0.700 2.14 808 1.33% Aaa/AA+/NR 4318 3135GA2Z3 FNMA 0.560 11/17/2025 (2.38YrNC4.60Mo-Da-Fixed) 01/11/2021 3,000,000.00 3,001,617.87 2,718,750.00 0.500 2.31 870 0.80% Aaa/AA+/AAA 4320 3130AKN36 FHLB 0.525 01/15/2026 (2.54YrNC0.49Mo-Dq-Fixed) 01/15/2021 5,000,000.00 4,997,461.11 4,491,850.00 0.545 2.46 929 1.33% Aaa/AA+/NR 4321 3130AKN85 FHLB 0.550 01/20/2026 (2.56YrNC0.66Mo-Dq-Fixed) 01/20/2021 5,000,000.00 4,998,723.61 4,492,950.00 0.560 2.47 934 1.33% Aaa/AA+/NR 4322 3130AKUS3 FHLB 0.500 01/28/2026 (2.58YrNC0.92Mo-Dq-Fixed) 01/28/2021 5,000,000.00 5,000,000.00 4,483,600.00 0.500 2.49 942 1.33% Aaa/AA+/NR 4333 3130ALEY6 FHLB 0.800 03/04/2026 (2.67YrNC2.17Mo-Dq-Fixed) 06/10/2021 5,000,000.00 5,000,000.00 4,502,950.00 0.800 2.57 977 1.33% Aaa/AA+/NR 4328 3130AMJN3 FHLB 1.030 05/26/2026 (2.90YrNC1.87Mo-Dq-Fixed) 05/26/2021 5,000,000.00 5,000,000.00 4,505,700.00 1.030 2.78 1,060 1.33% Aaa/AA+/NR 4335 3130AMFS6 FHLB 0.750 06/12/2026 (2.95Yr-Fixed) 06/17/2021 5,000,000.00 4,982,267.41 4,458,750.00 0.873 2.84 1,077 1.32% Aaa/AA+/NR 4388 3130AVWS7 FHLB 3.750 06/12/2026 (2.95Yr-Fixed) 05/09/2023 3,000,000.00 2,996,024.82 2,919,360.00 3.796 2.73 1,077 0.80% Aaa/AA+/NR 4398 3133EPNG6 FFCB 4.375 06/23/2026 (2.98Yr-Fixed) 06/23/2023 3,000,000.00 2,998,660.00 2,990,040.00 4.391 2.75 1,088 0.80% Aaa/AA+/AAA 4347 3130AQ7E7 FHLB 1.500 06/30/2026 (3.00YrNC3.02Mo-Dq-Fixed) 12/30/2021 5,000,000.00 5,001,332.10 4,552,250.00 1.339 2.85 1,095 1.33% Aaa/AA+/NR 4384 3130AUMC5 FHLB 3.750 07/20/2026 (3.05Yr-Fixed) 01/19/2023 5,000,000.00 5,000,000.00 4,865,700.00 3.750 2.78 1,115 1.33% Aaa/AA+/NR 4356 3130AQS79 FHLB 1.375 08/07/2026 (3.10YrNC13.27Mo-1x-Step) 02/07/2022 5,000,000.00 5,000,000.00 4,606,150.00 1.375 2.88 1,133 1.33% Aaa/AA+/NR 4386 3133EPGT6 FFCB 3.875 04/26/2027 (3.82Yr-Fixed) 04/26/2023 5,000,000.00 4,994,509.55 4,902,050.00 3.906 3.47 1,395 1.33% Aaa/AA+/AAA 4389 3133EPJP1 FFCB 3.625 05/12/2027 (3.86Yr-Fixed) 05/12/2023 5,000,000.00 4,986,621.28 4,852,500.00 3.700 3.52 1,411 1.33% Aaa/AA+/AAA 4392 3130AW4N7 FHLB 3.630 06/04/2027 (3.93Yr-Fixed) 05/18/2023 5,000,000.00 5,000,000.00 4,849,950.00 3.630 3.58 1,434 1.33% Aaa/AA+/NR 4396 3133EPMV4 FFCB 4.125 06/15/2027 (3.96Yr-Fixed) 06/15/2023 5,000,000.00 4,999,060.56 4,964,500.00 4.130 3.59 1,445 1.33% Aaa/AA+/AAA 4385 3134GYPF3 FHLMC 4.750 07/12/2027 (4.03YrNC12.42Mo-Da-Fixed) 04/24/2023 3,300,000.00 3,295,268.48 3,242,844.00 4.791 2.14 1,472 0.88% Aaa/AA+/AAA 4395 3130AWC24 FHLB 4.000 06/09/2028 (4.94Yr-Fixed) 06/13/2023 5,000,000.00 5,004,553.90 4,968,900.00 3.979 4.40 1,805 1.33% Aaa/AA+/NR 4399 3130AWC24 FHLB 4.000 06/09/2028 (4.94Yr-Fixed) 06/27/2023 5,000,000.00 4,997,256.17 4,968,900.00 4.012 4.40 1,805 1.33% Aaa/AA+/NR U.S. Agencies Total 189,525,000.00 189,095,763.01 179,931,506.25 50.24% 4306 90331HNV1 USB 3.400 07/24/2023 (0.06Yr-Fixed) 02/21/2020 2,000,000.00 2,002,085.86 1,997,300.00 1.671 0.06 23 0.53% A2/A+/A+ 4300 254687CR5 DIS 4.000 10/01/2023 (0.25Yr-Fixed) 12/16/2019 2,875,000.00 2,888,269.23 2,861,775.00 2.070 0.25 92 0.77% A2/A-/A- 4355 67066GAL8 NVDA 0.584 06/14/2024 (0.96Yr-Fixed) 01/24/2022 5,000,000.00 4,968,830.87 4,776,500.00 1.250 0.93 349 1.32% A1/A+/ 4325
91159HHX1
USB 2.400 07/30/2024 (1.08YrNC11.96Mo-Cc-Fixed)
04/30/2021
3,809,000.00
3,883,211.69
3,673,970.95
0.528
1.04 395
1.03%
A3/A/A
4343
14913R2P1
CAT 0.600 09/13/2024 (1.20Yr-Fixed)
12/02/2021
5,000,000.00
4,977,536.86
4,719,550.00
0.980
1.17 440
1.32%
A2/A/A+
4371
459200KS9
IBM 4.000 07/27/2025 (2.07Yr-Fixed)
08/11/2022
6,000,000.00
6,022,044.09
5,864,520.00
3.810
1.92 757
1.60%
A3/A-/
4372
931142EW9
WMT 3.900 09/09/2025 (2.19Yr-Fixed)
09/22/2022
5,000,000.00
4,974,447.24
4,900,200.00
4.150
2.04 801
1.32%
Aa2/AA/AA
4382
717081DV2
PFE 2.750 06/03/2026 (2.92Yr-Fixed)
01/18/2023
5,000,000.00
4,811,938.77
4,724,900.00
4.142
2.74 1,068
1.28%
A1/A+/A
4375
110122CN6
BMY 3.200 06/15/2026 (2.96YrNC33.51Mo-Cc-Fixed)
11/16/2022
5,000,000.00
4,826,903.96
4,785,100.00
4.480
2.72 1,080
1.28%
A2/A+/
4390
931142EM1
WMT 3.050 07/08/2026 (3.02YrNC34.27Mo-Cc-Fixed)
05/15/2023
4,257,000.00
4,172,539.47
4,071,863.07
3.752
2.75 1,103
1.11%
Aa2/AA/AA
4391
904764AU1
UNANA 2.000 07/28/2026 (3.07Yr-Fixed)
05/15/2023
2,505,000.00
2,378,926.72
2,311,614.00
3.752
2.89 1,123
0.63%
A1/A+/A
Corporates Total 46,446,000.00 45,906,734.74 44,687,293.02 12.20% Holdings Total 347,971,000.00 346,738,632.17 330,960,349.27 92.13% Portfolio: CITYSecurities By Structure Report
City of Huntington Beach
Reporting Period:
06/30/2023
Report Run Date: Jul 11, 2023
10 Cash/Money Market/LGIP Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 06/30/2023
Cash/Money Market Account Activity
Accounting ID Description Activity Date Transaction Type Transaction Amount 003 California Asset Management Program 06/01/2023 Interest Received $124,202.00 003 California Asset Management Program 06/06/2023 Deposit $1,000,000.00 003 California Asset Management Program 06/29/2023 Deposit $3,000,000.00 Activity Total $4,124,202.00
11 Bond Redemption Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 06/30/2023
Redemption Transactions
Accounting ID Transaction
Type Cusip Description Price Settlement
Date Posted Date Par Value Principal Accrued Interest Total 4368 Maturity 313383MD0 FHLB 2.625 06/09/2023 100.00000 06/09/2023 06/09/2023 $7,000,000.00 $7,000,000.00 $0.00 $7,000,000.00 4281 Maturity 313383QR5 FHLB 3.250 06/09/2023 100.00000 06/09/2023 06/09/2023 $5,000,000.00 $5,000,000.00 $0.00 $5,000,000.00 4393 Maturity 313384GR4 FHDN 0.000 06/09/2023 100.00000 06/09/2023 06/09/2023 $10,000,000.00 $10,000,000.00 $0.00 $10,000,000.00 4287 Maturity 3137EAEN5 FHLMC 2.750 06/19/2023 100.00000 06/19/2023 06/20/2023 $3,000,000.00 $3,000,000.00 $0.00 $3,000,000.00 4288 Maturity 3137EAEN5 FHLMC 2.750 06/19/2023 100.00000 06/19/2023 06/20/2023 $3,000,000.00 $3,000,000.00 $0.00 $3,000,000.00 4394 Maturity 313384HK8 FHDN 0.000 06/27/2023 100.00000 06/27/2023 06/27/2023 $5,000,000.00 $5,000,000.00 $0.00 $5,000,000.00 4374 Maturity 62479MTW3 MUFGBK 0.000 06/30/2023 100.00000 06/30/2023 06/30/2023 $5,000,000.00 $5,000,000.00 $0.00 $5,000,000.00 Activity Total $38,000,000.00 $38,000,000.00 $0.00 $38,000,000.00 12 Bond Purchase Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 06/30/2023
Purchase Transactions
Accounting ID Transaction
Type Cusip Description Price Settlement
Date Posted Date Par Value Principal Accrued Interest Total 4395 Buy 3130AWC24 FHLB 4.000 06/09/2028 100.09200 06/13/2023 06/13/2023 5,000,000.00 $5,004,600.00 $6,666.67 $5,011,266.67 4396 Buy 3133EPMV4 FFCB 4.125 06/15/2027 99.98100 06/15/2023 06/15/2023 5,000,000.00 $4,999,050.00 $0.00 $4,999,050.00 4397 Buy 3130AWER7 FHLB 4.625 06/06/2025 99.93700 06/15/2023 06/15/2023 3,000,000.00 $2,998,110.00 $1,156.25 $2,999,266.25 4398 Buy 3133EPNG6 FFCB 4.375 06/23/2026 99.95500 06/23/2023 06/23/2023 3,000,000.00 $2,998,650.00 $0.00 $2,998,650.00 4399 Buy 3130AWC24 FHLB 4.000 06/09/2028 99.94500 06/27/2023 06/27/2023 5,000,000.00 $4,997,250.00 $14,444.44 $5,011,694.44 Activity Total 21,000,000.00 $20,997,660.00 $22,267.36 $21,019,927.36 13 Bond Interest Received Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 06/30/2023
Bond Interest Received
Accounting ID Transaction Type Cusip Description Date Posted Interest Received Purchased Interest Adjustment Net Interest 4382 Interest Income 717081DV2 PFE 2.750 06/03/2026 06/05/2023 $68,750.00 $17,187.50 $51,562.50 4392 Interest Income 3130AW4N7 FHLB 3.630 06/04/2027 06/05/2023 $8,066.67 $8,066.67 4281 Interest Income 313383QR5 FHLB 3.250 06/09/2023 06/09/2023 $81,250.00 $81,250.00 4368 Interest Income 313383MD0 FHLB 2.625 06/09/2023 06/09/2023 $91,875.00 $91,875.00 4335 Interest Income 3130AMFS6 FHLB 0.750 06/12/2026 06/12/2023 $18,750.00 $18,750.00 4355 Interest Income 67066GAL8 NVDA 0.584 06/14/2024 06/14/2023 $14,600.00 $14,600.00 4378 Interest Income 3130ATVC8 FHLB 4.875 06/14/2024 06/14/2023 $146,927.08 $34,531.25 $112,395.83 4375 Interest Income 110122CN6 BMY 3.200 06/15/2026 06/15/2023 $80,000.00 $80,000.00 4376 Interest Income 91282CEU1 T 2.875 06/15/2025 06/15/2023 $43,125.00 $43,125.00 4287 Interest Income 3137EAEN5 FHLMC 2.750 06/19/2023 06/20/2023 $41,250.00 $41,250.00 4381 Interest Income 3135G04Z3 FNMA 0.500 06/17/2025 06/20/2023 $12,500.00 $1,805.56 $10,694.44 4288 Interest Income 3137EAEN5 FHLMC 2.750 06/19/2023 06/20/2023 $41,250.00 $41,250.00 4329 Interest Income 3135G04Z3 FNMA 0.500 06/17/2025 06/20/2023 $12,500.00 $12,500.00 4348 Interest Income 3130AQD42 FHLB 0.920 06/28/2024 06/28/2023 $23,000.00 $23,000.00 4334 Interest Income 3130AMW65 FHLB 0.500 12/30/2024 06/30/2023 $12,500.00 $12,500.00 4345 Interest Income 3130AQ5S8 FHLB 1.250 06/30/2025 06/30/2023 $29,062.50 $29,062.50 4346 Interest Income 3130AQD59 FHLB 1.000 09/30/2024 06/30/2023 $25,000.00 $25,000.00 4347 Interest Income 3130AQ7E7 FHLB 1.500 06/30/2026 06/30/2023 $37,500.00 $37,500.00 4349 Interest Income 3130AQD59 FHLB 1.000 09/30/2024 06/30/2023 $25,000.00 $25,000.00 4364 Interest Income 9128286Z8 T 1.750 06/30/2024 06/30/2023 $61,250.00 $61,250.00 4370 Interest Income 912828XX3 T 2.000 06/30/2024 06/30/2023 $50,000.00 $50,000.00 4379 Interest Income 91282CEW7 T 3.250 06/30/2027 06/30/2023 $81,250.00 $81,250.00 Activity Total $1,005,406.25 $53,524.31 $951,881.94
14 Statement of Cash Receipts and Disbursements and
Cash Receipts and Disbursements May 2023 June 2023
Receipts
General Fund
Property Tax 16,969,943$ 635,888$
Local Sales Tax 3,959,843 4,370,590
Public Safety Sales Tax 216,344 274,224
Transient Occupancy Tax (TOT) 1,713,059 1,119,474 Utility Users Tax (UUT) 1,837,432 1,607,817 Other Revenue 10,850,141 4,853,884
Total General Fund Revenue 35,546,761 12,861,878 Total All Other Funds Revenue 33,776,163 19,635,859 Total Receipts 69,322,924$ 32,497,737$
Disbursements
General Fund
Personnel Services (11,028,837) (16,358,797)
Operating Expenses (2,698,092) (5,509,899)
Capital Expenditures (726) (27,811)
Non‐Operating Expenses (585,805) (1,105,781)
Total General Fund Disbursements (14,313,460) (23,002,288) Total All Other Funds Disbursements (18,245,710) (37,365,514) Total Disbursements (32,559,170) (60,367,802)
Net Change in Cash Flow 36,763,754$ (27,870,066)$ Summary of Cash by Fund May 2023 June 2023
General Fund 137,060,420$ 126,920,010$
General Fund Other 3,371,414 3,431,049 Capital Projects Funds 26,101,610 29,613,575 Debt Service Funds 42,323,578 24,297,271
Enterprise Funds 87,443,117 89,301,455
Trust and Agency Funds 14,465,862 13,326,570 Internal Service Funds 22,949,133 21,649,606 Special Revenue Funds 76,116,877 73,422,410 General Ledger Cash Balances * 409,832,011$ 381,961,946$ *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.
Summary of Cash by Fund
City Treasurer's Office
June 2023
Par Value Book Value Book Value % of
Port Market Value Book Yield
Contribution Days to Maturity
Local Govt Inv Pools (LGIP)
Commercial Paper
U.S. Treasuries
Supranational
U.S. Agencies
Corporates
Hold
Total
$25,485,744.55 $25,485,744.55 6.55% $25,485,744.55 0.338% 1 $5,000,000.00 $4,982,076.39 1.28% $4,979,200.00 0.059% 29 $83,000,000.00 $82,712,107.82 21.25% $79,313,690.00 0.344% 607 $29,000,000.00 $29,023,163.66 7.46% $27,457,350.00 0.083% 557 $201,525,000.00 $201,047,537.66 51.66% $192,497,413.50 1.209% 648 $46,446,000.00 $45,899,238.21 11.79% $44,924,740.21 0.340% 725 $390,456,744.55 $389,149,868.29 100.00% $374,658,138.26 2.373% 591 Portfolio Investments
05/31/2023
Date
City Treasurer
TitleAlisa Backstrom
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 January 17, 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) Certification
Fiscal YTD Transactions
Redemptions 1
Purchases 7
Total Activity 8
Period Transactions
Redemptions 9
Purchases 24
Total Activity 33
Net Period Earnings $5,166,298.46
Last FY Period Net Earnings $3,155,527.68
Avg Daily Book Balance $326,958,164.85
$1.00 $1.00
Net Effective Annual Return 1.723%
Net Period Earnings $705,575.05
Last FY Period Net Earnings $352,940.60
Avg Daily Book Balance $376,362,205.84
$1.00 $1.00
Net Effective Annual Return 2.230%
Fiscal YTD Summary (335 Days)Period Earnings Summary (31 Days) ______________________________________________ ____________________________ Portfolio Market Value
Accrued Interest Paid at
Purchase
sum2
Total Market Value
$374,658,138.26
$149,860.95
$1.00
$374,807,999.21
Portfolio Book Value
Accrued Interest Paid at
Purchase
sum2
Total Book Value
$389,149,868.29
$149,860.95
$2.00
$389,299,729.24
Market Value
Book Value
Par Value
Portfolio Summary
Huntington Beach
Portfolio: CITY
Reporting Date: (FY2023)
05/01/2023 - 05/31/2023
Full Accrual Basis
sum2
Total Par Value
$1.00
$390,456,744.55
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.060% ____________________________________________
15 Accounting ID Pool Description Type Par Value Book Value Market Value Rate % of Portfolio Composite Rating 003
California Asset Management Program
LGIP
25,485,744.55
25,485,744.55
25,485,744.55
5.16 6.55%
NR
CITY Fund Total 25,485,744.55 25,485,744.55 25,485,744.55 6.55% Portfolio: CITYCash By Fund Report
City of Huntington Beach
Reporting Period:
05/31/2023
Report Run Date: Jul 11, 2023
16 Accounting ID Cusip Security Description Purchase Date Par Value Book Value Market Value Book Yield Effective Duration
Days to
Maturity
(%) of
Portfolio Mdy/S&P/Fitch
4374 62479MTW3 MUFGBK 0.000 06/30/2023 (0.08Yr-Disco) 10/05/2022 5,000,000.00 4,982,076.39 4,979,200.00 4.602 0.08 29 1.28% P-1/A-1/F1 Commercial Paper Total 5,000,000.00 4,982,076.39 4,979,200.00 1.28% 4352 912828S92 T 1.250 07/31/2023 (0.16Yr-Fixed) 01/14/2022 5,000,000.00 5,004,412.08 4,966,450.00 0.711 0.16 60 1.29% Aaa/AA+/AAA 4357 91282CCN9 T 0.125 07/31/2023 (0.16Yr-Fixed) 02/02/2022 5,000,000.00 4,992,934.28 4,956,600.00 0.991 0.16 60 1.28% Aaa/AA+/AAA 4354 9128282D1 T 1.375 08/31/2023 (0.25Yr-Fixed) 01/21/2022 5,000,000.00 5,005,813.46 4,950,200.00 0.903 0.25 91 1.29% Aaa/AA+/AAA 4364 9128286Z8 T 1.750 06/30/2024 (1.08Yr-Fixed) 05/02/2022 7,000,000.00 6,928,355.00 6,751,150.00 2.730 1.04 395 1.78% Aaa/AA+/AAA 4370 912828XX3 T 2.000 06/30/2024 (1.08Yr-Fixed) 05/27/2022 5,000,000.00 4,975,796.57 4,835,150.00 2.462 1.04 395 1.28% Aaa/AA+/AAA 4353 912828Y87 T 1.750 07/31/2024 (1.17Yr-Fixed) 01/14/2022 5,000,000.00 5,041,499.46 4,815,250.00 1.028 1.13 426 1.30% Aaa/AA+/AAA 4358 912828Y87 T 1.750 07/31/2024 (1.17Yr-Fixed) 02/11/2022 4,000,000.00 4,007,054.30 3,852,200.00 1.595 1.13 426 1.03% Aaa/AA+/AAA 4361 912828D56 T 2.375 08/15/2024 (1.21Yr-Fixed) 03/22/2022 5,000,000.00 5,007,857.04 4,847,650.00 2.240 1.16 441 1.29% Aaa/AA+/AAA 4298 912828YH7 T 1.500 09/30/2024 (1.33Yr-Fixed) 12/05/2019 5,000,000.00 4,993,915.96 4,783,800.00 1.595 1.29 487 1.28% Aaa/AA+/AAA 4350 912828YM6 T 1.500 10/31/2024 (1.42Yr-Fixed) 12/31/2021 3,000,000.00 3,024,278.43 2,865,000.00 0.920 1.37 518 0.78% Aaa/AA+/AAA 4376 91282CEU1 T 2.875 06/15/2025 (2.04Yr-Fixed) 11/18/2022 3,000,000.00 2,919,563.78 2,911,290.00 4.276 1.92 745 0.75% Aaa/AA+/AAA 4330 91282CAB7 T 0.250 07/31/2025 (2.17Yr-Fixed) 05/19/2021 5,000,000.00 4,961,017.21 4,583,200.00 0.615 2.11 791 1.27% Aaa/AA+/AAA 4340 91282CAJ0 T 0.250 08/31/2025 (2.25Yr-Fixed) 09/27/2021 5,000,000.00 4,946,260.46 4,570,900.00 0.735 2.19 822 1.27% Aaa/AA+/AAA 4351 9128284Z0 T 2.750 08/31/2025 (2.25Yr-Fixed) 12/31/2021 5,000,000.00 5,180,975.06 4,835,950.00 1.103 2.13 822 1.33% Aaa/AA+/AAA 4341 91282CCP4 T 0.625 07/31/2026 (3.16Yr-Fixed) 09/30/2021 5,000,000.00 4,949,823.44 4,500,600.00 0.950 3.05 1,156 1.27% Aaa/AA+/AAA 4339 91282CCW9 T 0.750 08/31/2026 (3.25Yr-Fixed) 09/23/2021 1,000,000.00 995,556.16 901,600.00 0.890 3.13 1,187 0.26% Aaa/AA+/AAA 4342 91282CCW9 T 0.750 08/31/2026 (3.25Yr-Fixed) 11/23/2021 5,000,000.00 4,915,889.60 4,508,000.00 1.285 3.13 1,187 1.26% Aaa/AA+/AAA 4379 91282CEW7 T 3.250 06/30/2027 (4.08Yr-Fixed) 12/29/2022 5,000,000.00 4,861,105.54 4,878,700.00 4.000 3.70 1,490 1.25% Aaa/AA+/AAA U.S. Treasuries Total 83,000,000.00 82,712,107.82 79,313,690.00 21.25% 4290 45818WBX3 IADB 2.870 07/20/2023 (0.13Yr-Fixed) 03/28/2019 4,000,000.00 4,003,091.55 3,985,800.00 2.270 0.13 49 1.03% Aaa/AAA/AAA 4291 45818WBY1 IADB 2.960 08/16/2023 (0.21Yr-Fixed) 03/28/2019 5,000,000.00 5,006,794.20 4,973,100.00 2.271 0.21 76 1.29% Aaa/AAA/AAA 4323 459056HV2 IBRD 1.500 08/28/2024 (1.24Yr-Fixed) 04/23/2021 5,000,000.00 5,066,178.26 4,796,500.00 0.425 1.20 454 1.30% Aaa/AAA/AAA 4338 459058JE4 IBRD 0.376 07/28/2025 (2.16Yr-Fixed) 07/30/2021 5,000,000.00 4,977,846.31 4,599,100.00 0.583 2.10 788 1.28% Aaa/AAA/AAA 4319 459058JL8 IBRD 0.500 10/28/2025 (2.41Yr-Fixed) 01/12/2021 5,000,000.00 4,998,618.63 4,574,750.00 0.512 2.34 880 1.28% Aaa/AAA/AAA 4324 45906M2L4 IBRD 0.650 02/24/2026 (2.74YrNC2.79Mo-Dq-Fixed) 04/30/2021 5,000,000.00 4,970,634.72 4,528,100.00 0.870 2.64 999 1.28% Aaa/AAA/AAA Supranational Total 29,000,000.00 29,023,163.66 27,457,350.00 7.46% 4281 313383QR5 FHLB 3.250 06/09/2023 (0.02Yr-Fixed) 12/20/2018 5,000,000.00 5,000,527.04 4,997,600.00 2.743 0.02 8 1.28% Aaa/AA+/NR 4368 313383MD0 FHLB 2.625 06/09/2023 (0.02Yr-Fixed) 05/09/2022 7,000,000.00 7,000,646.15 6,995,310.00 2.201 0.02 8 1.80% Aaa/AA+/NR 4393 313384GR4 FHDN 0.000 06/09/2023 (0.02Yr-Disco) 05/26/2023 10,000,000.00 9,989,777.78 9,990,200.00 4.672 0.02 8 2.57% P-1/A-1+/NR 4287
3137EAEN5
FHLMC 2.750 06/19/2023 (0.05Yr-Fixed)
03/08/2019
3,000,000.00
3,000,424.01
2,995,320.00
2.450
0.05 18
0.77%
Aaa/AA+/AAA
4288 3137EAEN5 FHLMC 2.750 06/19/2023 (0.05Yr-Fixed) 03/14/2019 3,000,000.00 3,000,442.91 2,995,320.00 2.437 0.05 18 0.77% Aaa/AA+/AAA 4394 313384HK8 FHDN 0.000 06/27/2023 (0.07Yr-Disco) 05/26/2023 5,000,000.00 4,982,088.89 4,984,150.00 5.051 0.07 26 1.28% P-1/A-1+/NR 4383 3130AUHE7 FHLB 0.000 07/26/2023 (0.15Yr-Disco) 01/18/2023 5,000,000.00 5,000,836.70 4,996,600.00 4.755 0.15 55 1.29% Aaa/AA+/NR 4289 3135G0U43 FNMA 2.875 09/12/2023 (0.28Yr-Fixed) 03/15/2019 5,000,000.00 5,005,409.15 4,966,000.00 2.465 0.28 103 1.29% Aaa/AA+/AAA 4377 313384ND7 FHDN 0.000 10/19/2023 (0.38Yr-Disco) 12/05/2022 3,000,000.00 2,946,275.00 2,941,500.00 4.817 0.38 140 0.76% P-1/A-1+/NR 4387 3130AUXN9 FHLB 5.000 02/15/2024 (0.71Yr-Fixed) 04/25/2023 3,000,000.00 3,001,392.62 2,990,640.00 4.923 0.68 259 0.77% Aaa/AA+/NR 4292 3133ECHX5 FFCB 2.260 03/13/2024 (0.78Yr-Fixed) 05/23/2019 5,000,000.00 5,000,880.23 4,885,050.00 2.236 0.76 286 1.29% Aaa/AA+/AAA 4378 3130ATVC8 FHLB 4.875 06/14/2024 (1.04Yr-Fixed) 12/28/2022 5,000,000.00 5,006,204.85 4,977,400.00 4.740 0.97 379 1.29% Aaa/AA+/NR 4348 3130AQD42 FHLB 0.920 06/28/2024 (1.08YrNC0.92Mo-Dq-Fixed) 12/28/2021 5,000,000.00 5,000,000.00 4,768,000.00 0.920 1.04 393 1.28% Aaa/AA+/NR Portfolio: CITYSecurities By Structure Report
City of Huntington Beach
Reporting Period:
05/31/2023
Report Run Date: Jul 11, 2023
17 Accounting ID Cusip Security Description Purchase Date Par Value Book Value Market Value Book Yield Effective Duration
Days to
Maturity
(%) of
Portfolio Mdy/S&P/Fitch
4380 3134GYCP5 FHLMC 5.000 07/23/2024 (1.14YrNC4.76Mo-1x-Fixed) 01/23/2023 5,000,000.00 5,000,000.00 4,966,400.00 5.000 0.86 418 1.28% Aaa/AA+/AAA 4344 3130AQ3C5 FHLB 1.000 08/28/2024 (1.24YrNC2.92Mo-Dq-Fixed) 12/02/2021 4,000,000.00 4,000,000.00 3,792,640.00 1.000 1.20 454 1.03% Aaa/AA+/NR 4373 3133XVDG3 FHLB 4.375 09/13/2024 (1.29Yr-Fixed) 09/23/2022 5,000,000.00 5,008,166.34 4,960,850.00 4.240 1.23 470 1.29% Aaa/AA+/NR 4336 3130AMXJ6 FHLB 0.500 09/30/2024 (1.33YrNC0.99Mo-Dq-Fixed) 06/30/2021 5,000,000.00 5,000,000.00 4,693,150.00 0.500 1.30 487 1.28% Aaa/AA+/NR 4346 3130AQD59 FHLB 1.000 09/30/2024 (1.33YrNC0.99Mo-Dq-Fixed) 12/30/2021 5,000,000.00 5,000,000.00 4,724,950.00 1.000 1.29 487 1.28% Aaa/AA+/NR 4349 3130AQD59 FHLB 1.000 09/30/2024 (1.33YrNC0.99Mo-Dq-Fixed) 12/30/2021 5,000,000.00 5,000,000.00 4,724,950.00 1.000 1.29 487 1.28% Aaa/AA+/NR 4334 3130AMW65 FHLB 0.500 12/30/2024 (1.58YrNC0.99Mo-Dq-Fixed) 06/30/2021 5,000,000.00 5,000,000.00 4,650,300.00 0.500 1.54 578 1.28% Aaa/AA+/NR 4332 3130AMQ62 FHLB 0.625 03/14/2025 (1.79YrNC0.46Mo-Dq-Fixed) 06/14/2021 5,000,000.00 5,000,000.00 4,624,400.00 0.625 1.73 652 1.28% Aaa/AA+/NR 4329 3135G04Z3 FNMA 0.500 06/17/2025 (2.05Yr-Fixed) 05/14/2021 5,000,000.00 4,987,083.77 4,617,000.00 0.628 1.98 747 1.28% Aaa/AA+/AAA 4381 3135G04Z3 FNMA 0.500 06/17/2025 (2.05Yr-Fixed) 01/13/2023 5,000,000.00 4,661,052.63 4,617,000.00 4.013 1.98 747 1.20% Aaa/AA+/AAA 4345 3130AQ5S8 FHLB 1.250 06/30/2025 (2.08YrNC0.99Mo-Dq-Fixed) 12/30/2021 4,650,000.00 4,650,000.00 4,323,849.00 1.250 2.00 760 1.19% Aaa/AA+/NR 4327 3130AMDL3 FHLB 0.800 07/25/2025 (2.15YrNC2.83Mo-Dq-Fixed) 05/25/2021 5,000,000.00 5,000,000.00 4,596,850.00 0.800 2.08 785 1.28% Aaa/AA+/NR 4360 3130AQT94 FHLB 1.600 08/28/2025 (2.24Yr-Fixed) 03/04/2022 4,575,000.00 4,553,654.56 4,291,624.50 1.816 2.15 819 1.17% Aaa/AA+/NR 4331 3130AMQ54 FHLB 0.700 09/16/2025 (2.29YrNC3.55Mo-Da-Fixed) 06/16/2021 5,000,000.00 5,000,000.00 4,567,900.00 0.700 2.22 838 1.28% Aaa/AA+/NR 4318 3135GA2Z3 FNMA 0.560 11/17/2025 (2.46YrNC5.59Mo-Da-Fixed) 01/11/2021 3,000,000.00 3,001,674.57 2,719,770.00 0.500 2.39 900 0.77% Aaa/AA+/AAA 4320 3130AKN36 FHLB 0.525 01/15/2026 (2.63YrNC1.48Mo-Dq-Fixed) 01/15/2021 5,000,000.00 4,997,377.78 4,492,350.00 0.545 2.53 959 1.28% Aaa/AA+/NR 4321 3130AKN85 FHLB 0.550 01/20/2026 (2.64YrNC1.64Mo-Dq-Fixed) 01/20/2021 5,000,000.00 4,998,681.94 4,493,400.00 0.560 2.55 964 1.28% Aaa/AA+/NR 4322 3130AKUS3 FHLB 0.500 01/28/2026 (2.66YrNC1.91Mo-Dq-Fixed) 01/28/2021 5,000,000.00 5,000,000.00 4,484,250.00 0.500 2.57 972 1.28% Aaa/AA+/NR 4333 3130ALEY6 FHLB 0.800 03/04/2026 (2.76YrNC0.13Mo-Dq-Fixed) 06/10/2021 5,000,000.00 5,000,000.00 4,494,100.00 0.800 2.65 1,007 1.28% Aaa/AA+/NR 4328 3130AMJN3 FHLB 1.030 05/26/2026 (2.98YrNC2.86Mo-Dq-Fixed) 05/26/2021 5,000,000.00 5,000,000.00 4,510,500.00 1.030 2.86 1,090 1.28% Aaa/AA+/NR 4335 3130AMFS6 FHLB 0.750 06/12/2026 (3.03Yr-Fixed) 06/17/2021 5,000,000.00 4,981,766.02 4,521,300.00 0.873 2.91 1,107 1.28% Aaa/AA+/NR 4388 3130AVWS7 FHLB 3.750 06/12/2026 (3.03Yr-Fixed) 05/09/2023 3,000,000.00 2,995,912.43 2,959,200.00 3.796 2.81 1,107 0.77% Aaa/AA+/NR 4347 3130AQ7E7 FHLB 1.500 06/30/2026 (3.08YrNC0.99Mo-Dq-Fixed) 12/30/2021 5,000,000.00 5,001,369.14 4,554,950.00 1.339 2.91 1,125 1.29% Aaa/AA+/NR 4384 3130AUMC5 FHLB 3.750 07/20/2026 (3.13Yr-Fixed) 01/19/2023 5,000,000.00 5,000,000.00 4,945,850.00 3.750 2.87 1,145 1.28% Aaa/AA+/NR 4356 3130AQS79 FHLB 1.375 08/07/2026 (3.18YrNC14.26Mo-1x-Step) 02/07/2022 5,000,000.00 5,000,000.00 4,610,200.00 1.375 2.93 1,163 1.28% Aaa/AA+/NR 4386 3133EPGT6 FFCB 3.875 04/26/2027 (3.90Yr-Fixed) 04/26/2023 5,000,000.00 4,994,389.76 4,963,200.00 3.906 3.55 1,425 1.28% Aaa/AA+/AAA 4389 3133EPJP1 FFCB 3.625 05/12/2027 (3.95Yr-Fixed) 05/12/2023 5,000,000.00 4,986,332.74 4,912,450.00 3.700 3.61 1,441 1.28% Aaa/AA+/AAA 4392 3130AW4N7 FHLB 3.630 06/04/2027 (4.01Yr-Fixed) 05/18/2023 5,000,000.00 5,000,000.00 4,956,050.00 3.630 3.67 1,464 1.28% Aaa/AA+/NR 4385 3134GYPF3 FHLMC 4.750 07/12/2027 (4.11YrNC13.40Mo-Da-Fixed) 04/24/2023 3,300,000.00 3,295,170.65 3,244,890.00 4.791 2.13 1,502 0.85% Aaa/AA+/AAA U.S. Agencies Total 201,525,000.00 201,047,537.66 192,497,413.50 51.66% 4306
90331HNV1
USB 3.400 07/24/2023 (0.15YrNC0.76Mo-Cc-Fixed)
02/21/2020
2,000,000.00
2,004,806.54
1,992,400.00
1.671
0.14 53
0.52%
A2/A+/AA-
4300
254687CR5
DIS 4.000 10/01/2023 (0.33Yr-Fixed)
12/16/2019
2,875,000.00
2,892,692.31
2,858,296.25
2.070
0.33 122
0.74%
A2/BBB+/A-
4355
67066GAL8
NVDA 0.584 06/14/2024 (1.04YrNC0.46Mo-Cc-Fixed)
01/24/2022
5,000,000.00
4,966,104.71
4,764,850.00
1.250
1.01 379
1.28%
A2/A/
4325
91159HHX1
USB 2.400 07/30/2024 (1.16YrNC12.94Mo-Cc-Fixed)
04/30/2021
3,809,000.00
3,888,934.96
3,662,048.78
0.528
1.11 425
1.00%
A3/A/A+
4343
14913R2P1
CAT 0.600 09/13/2024 (1.29Yr-Fixed)
12/02/2021
5,000,000.00
4,975,976.92
4,731,700.00
0.980
1.25 470
1.28%
A2/A/A+
4371
459200KS9
IBM 4.000 07/27/2025 (2.15Yr-Fixed)
08/11/2022
6,000,000.00
6,022,930.58
5,912,460.00
3.810
2.01 787
1.55%
A3/A-/
4372
931142EW9
WMT 3.900 09/09/2025 (2.28Yr-Fixed)
09/22/2022
5,000,000.00
4,973,474.41
4,949,450.00
4.150
2.13 831
1.28%
Aa2/AA/AA
4382
717081DV2
PFE 2.750 06/03/2026 (3.01Yr-Fixed)
01/18/2023
5,000,000.00
4,806,575.80
4,777,850.00
4.142
2.79 1,098
1.24%
A1/A+/A
4375
110122CN6
BMY 3.200 06/15/2026 (3.04YrNC34.50Mo-Cc-Fixed)
11/16/2022
5,000,000.00
4,822,023.43
4,825,400.00
4.480
2.74 1,110
1.24%
A2/A+/
4390
931142EM1
WMT 3.050 07/08/2026 (3.10YrNC35.25Mo-Cc-Fixed)
05/15/2023
4,257,000.00
4,170,208.45
4,115,199.33
3.752
2.82 1,133
1.07%
Aa2/AA/AA
4391
904764AU1
UNANA 2.000 07/28/2026 (3.16Yr-Fixed)
05/15/2023
2,505,000.00
2,375,510.10
2,335,085.85
3.752
2.97 1,153
0.61%
A1/A+/A
Corporates Total 46,446,000.00 45,899,238.21 44,924,740.21 11.79% Portfolio: CITYSecurities By Structure Report
City of Huntington Beach
Reporting Period:
05/31/2023
Report Run Date: Jul 11, 2023
18 Accounting ID Cusip Security Description Purchase Date Par Value Book Value Market Value Book Yield Effective Duration
Days to
Maturity
(%) of
Portfolio Mdy/S&P/Fitch
Holdings Total 364,971,000.00 363,664,123.74 349,172,393.71 93.45% Portfolio: CITYSecurities By Structure Report
City of Huntington Beach
Reporting Period:
05/31/2023
Report Run Date: Jul 11, 2023
19 Cash/Money Market/LGIP Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 05/31/2023
Cash/Money Market Account Activity
Accounting ID Description Activity Date Transaction Type Transaction Amount 003 California Asset Management Program 05/03/2023 Deposit $4,000,000.00 003 California Asset Management Program 05/01/2023 Interest Received $87,302.71 003 California Asset Management Program 05/08/2023 Withdrawal ($8,000,000.00) 003 California Asset Management Program 05/22/2023 Deposit $4,000,000.00 003 California Asset Management Program 05/24/2023 Deposit $5,000,000.00 003 California Asset Management Program 05/25/2023 Withdrawal ($10,000,000.00) Activity Total ($4,912,697.29)
20 Bond Redemption Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 05/31/2023
Redemption Transactions
Accounting ID Transaction
Type Cusip Description Price Settlement
Date Posted Date Par Value Principal Accrued Interest Total 4285 Maturity 3130AFWX1 FHLB 2.550 05/30/2023 100.00000 05/30/2023 05/30/2023 $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 21 Bond Purchase Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 05/31/2023
Purchase Transactions
Accounting ID Transaction
Type Cusip Description Price Settlement
Date Posted Date Par Value Principal Accrued Interest Total 4388 Buy 3130AVWS7 FHLB 3.750 06/12/2026 99.86100 05/09/2023 05/09/2023 3,000,000.00 $2,995,830.00 $1,250.00 $2,997,080.00 4389 Buy 3133EPJP1 FFCB 3.625 05/12/2027 99.72300 05/12/2023 05/12/2023 5,000,000.00 $4,986,150.00 $0.00 $4,986,150.00 4390 Buy 931142EM1 WMT 3.050 07/08/2026 97.93200 05/15/2023 05/15/2023 4,257,000.00 $4,168,965.24 $45,804.14 $4,214,769.38 4391 Buy 904764AU1 UNANA 2.000 07/28/2026 94.75800 05/15/2023 05/15/2023 2,505,000.00 $2,373,687.90 $14,890.83 $2,388,578.73 4392 Buy 3130AW4N7 FHLB 3.630 06/04/2027 100.00000 05/18/2023 05/18/2023 5,000,000.00 $5,000,000.00 $0.00 $5,000,000.00 4393 Buy 313384GR4 FHDN 0.000 06/09/2023 99.82111 05/26/2023 05/26/2023 10,000,000.00 $9,982,111.11 $0.00 $9,982,111.11 4394 Buy 313384HK8 FHDN 0.000 06/27/2023 99.55911 05/26/2023 05/26/2023 5,000,000.00 $4,977,955.56 $0.00 $4,977,955.56 Activity Total 34,762,000.00 $34,484,699.81 $61,944.97 $34,546,644.78 22 Bond Interest Received Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 05/31/2023
Bond Interest Received
Accounting ID Transaction Type Cusip Description Date Posted Interest Received Purchased Interest Adjustment Net Interest 4350 Interest Income 912828YM6 T 1.500 10/31/2024 05/01/2023 $22,500.00 $22,500.00 4318 Interest Income 3135GA2Z3 FNMA 0.560 11/17/2025 05/17/2023 $8,400.00 $8,400.00 4327 Interest Income 3130AMDL3 FHLB 0.800 07/25/2025 05/25/2023 $20,000.00 $20,000.00 4328 Interest Income 3130AMJN3 FHLB 1.030 05/26/2026 05/26/2023 $25,750.00 $25,750.00 4285 Interest Income 3130AFWX1 FHLB 2.550 05/30/2023 05/30/2023 $63,750.00 $63,750.00 Activity Total $140,400.00 $0.00 $140,400.00
23 Statement of Cash Receipts and Disbursements and
Cash Receipts and Disbursements April 2023 May 2023
Receipts
General Fund
Property Tax 21,208,398$ 16,969,943$
Local Sales Tax 3,318,537 3,959,843
Public Safety Sales Tax 214,419 216,344
Transient Occupancy Tax (TOT) 1,214,231 1,713,059 Utility Users Tax (UUT) 2,564,310 1,837,432 Other Revenue 5,685,370 10,850,141
Total General Fund Revenue 34,205,265 35,546,761
Total All Other Funds Revenue 22,286,424 33,776,163
Total Receipts 56,491,688$ 69,322,924$
Disbursements
General Fund
Personnel Services (11,077,248) (11,028,837)
Operating Expenses (3,606,032) (2,698,092)
Capital Expenditures
‐
(726)
Non‐Operating Expenses (2,065,934) (585,805)
Total General Fund Disbursements (16,749,214) (14,313,460) Total All Other Funds Disbursements (16,088,385) (18,245,710) Total Disbursements (32,837,599) (32,559,170)
Net Change in Cash Flow 23,654,089$ 36,763,754$ Summary of Cash by Fund April 2023 May 2023
General Fund 115,312,455$ 136,545,756$
General Fund Other 3,438,393 3,367,436 Capital Projects Funds 26,222,973 26,101,610
Debt Service Funds 41,427,668 42,323,578
Enterprise Funds 85,421,126 87,442,587
Trust and Agency Funds 5,829,479 14,465,862 Internal Service Funds 24,004,761 22,949,133
Special Revenue Funds 70,794,142 76,018,789
General Ledger Cash Balances * 372,450,996$ 409,214,750$ 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.
Summary of Cash by Fund
City Treasurer's Office
May 2023
24 Par Value Book Value Book Value % of
Port Market Value Book Yield
Contribution Days to Maturity
Local Govt Inv Pools (LGIP)
Commercial Paper
U.S. Treasuries
Supranational
U.S. Agencies
Corporates
Hold
Total
$30,398,441.84 $30,398,441.84 8.34% $30,398,441.84 0.414% 1 $5,000,000.00 $4,962,916.67 1.36% $4,957,350.00 0.063% 60 $83,000,000.00 $82,703,721.76 22.69% $79,611,720.00 0.367% 638 $29,000,000.00 $29,030,416.27 7.96% $27,531,290.00 0.089% 588 $178,525,000.00 $178,074,838.36 48.85% $170,517,250.25 0.997% 661 $39,684,000.00 $39,351,770.76 10.80% $38,651,780.61 0.295% 687 $365,607,441.84 $364,522,105.66 100.00% $351,667,832.70 2.226% 590 Portfolio Investments
04/30/2023
Date
City Treasurer
TitleAlisa Backstrom
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 January 17, 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) Certification
Fiscal YTD Transactions
Redemptions 0
Purchases 3
Total Activity 3
Period Transactions
Redemptions 8
Purchases 17
Total Activity 25
Net Period Earnings $4,460,723.41
Last FY Period Net Earnings $2,802,587.08
Avg Daily Book Balance $322,017,760.75
$1.00 $1.00
Net Effective Annual Return 1.666%
Net Period Earnings $584,762.41
Avg Daily Book Balance $346,341,720.57
$1.00 $1.00
Net Effective Annual Return 2.074%
Fiscal YTD Summary (304 Days)Period Earnings Summary (30 Days) ______________________________________________ ____________________________ Portfolio Market Value
Accrued Interest Paid at
Purchase
sum2
Total Market Value
$351,667,832.70
$87,915.98
$1.00
$351,755,748.68
Portfolio Book Value
Accrued Interest Paid at
Purchase
sum2
Total Book Value
$364,522,105.66
$87,915.98
$2.00
$364,610,021.64
Market Value
Book Value
Par Value
Portfolio Summary
Huntington Beach
Portfolio: CITY
Reporting Date: (FY2023)
04/01/2023 - 04/30/2023
Full Accrual Basis
sum2
Total Par Value
$1.00
$365,607,441.84
____________________________________________
25 Accounting ID Pool Description Type Par Value Book Value Market Value Rate % of Portfolio Composite Rating 003
California Asset Management Program
LGIP
30,398,441.84
30,398,441.84
30,398,441.84
4.97 8.34%
NR
CITY Fund Total 30,398,441.84 30,398,441.84 30,398,441.84 8.34% Portfolio: CITYCash By Fund Report
City of Huntington Beach
Reporting Period:
04/30/2023
Report Run Date: Jul 11, 2023
26 Accounting ID Cusip Security Description Purchase Date Par Value Book Value Market Value Book Yield Effective Duration
Days to
Maturity
(%) of
Portfolio Mdy/S&P/Fitch
4374 62479MTW3 MUFGBK 0.000 06/30/2023 (0.16Yr-Disco) 10/05/2022 5,000,000.00 4,962,916.67 4,957,350.00 4.602 0.17 60 1.36% P-1/A-1/F1 Commercial Paper Total 5,000,000.00 4,962,916.67 4,957,350.00 1.36% 4352 912828S92 T 1.250 07/31/2023 (0.25Yr-Fixed) 01/14/2022 5,000,000.00 5,006,691.65 4,951,150.00 0.711 0.25 91 1.37% Aaa/AA+/AAA 4357 91282CCN9 T 0.125 07/31/2023 (0.25Yr-Fixed) 02/02/2022 5,000,000.00 4,989,283.66 4,939,050.00 0.991 0.25 91 1.37% Aaa/AA+/AAA 4354 9128282D1 T 1.375 08/31/2023 (0.33Yr-Fixed) 01/21/2022 5,000,000.00 5,007,793.87 4,939,050.00 0.903 0.33 122 1.37% Aaa/AA+/AAA 4364 9128286Z8 T 1.750 06/30/2024 (1.17Yr-Fixed) 05/02/2022 7,000,000.00 6,922,732.23 6,771,940.00 2.730 1.13 426 1.90% Aaa/AA+/AAA 4370 912828XX3 T 2.000 06/30/2024 (1.17Yr-Fixed) 05/27/2022 5,000,000.00 4,973,897.06 4,849,600.00 2.462 1.13 426 1.36% Aaa/AA+/AAA 4353 912828Y87 T 1.750 07/31/2024 (1.25Yr-Fixed) 01/14/2022 5,000,000.00 5,044,519.38 4,830,450.00 1.028 1.21 457 1.38% Aaa/AA+/AAA 4358 912828Y87 T 1.750 07/31/2024 (1.25Yr-Fixed) 02/11/2022 4,000,000.00 4,007,567.64 3,864,360.00 1.595 1.21 457 1.10% Aaa/AA+/AAA 4361 912828D56 T 2.375 08/15/2024 (1.29Yr-Fixed) 03/22/2022 5,000,000.00 5,008,409.35 4,864,850.00 2.240 1.25 472 1.37% Aaa/AA+/AAA 4298 912828YH7 T 1.500 09/30/2024 (1.42Yr-Fixed) 12/05/2019 5,000,000.00 4,993,528.68 4,801,150.00 1.595 1.38 518 1.37% Aaa/AA+/AAA 4350 912828YM6 T 1.500 10/31/2024 (1.50Yr-Fixed) 12/31/2021 3,000,000.00 3,025,731.39 2,875,320.00 0.920 1.46 549 0.83% Aaa/AA+/AAA 4376 91282CEU1 T 2.875 06/15/2025 (2.12Yr-Fixed) 11/18/2022 3,000,000.00 2,916,216.77 2,931,210.00 4.276 2.01 776 0.80% Aaa/AA+/AAA 4330 91282CAB7 T 0.250 07/31/2025 (2.25Yr-Fixed) 05/19/2021 5,000,000.00 4,959,489.44 4,606,050.00 0.615 2.19 822 1.36% Aaa/AA+/AAA 4340 91282CAJ0 T 0.250 08/31/2025 (2.34Yr-Fixed) 09/27/2021 5,000,000.00 4,944,233.79 4,594,750.00 0.735 2.27 853 1.36% Aaa/AA+/AAA 4351 9128284Z0 T 2.750 08/31/2025 (2.34Yr-Fixed) 12/31/2021 5,000,000.00 5,187,800.15 4,871,100.00 1.103 2.21 853 1.42% Aaa/AA+/AAA 4341 91282CCP4 T 0.625 07/31/2026 (3.25Yr-Fixed) 09/30/2021 5,000,000.00 4,948,477.88 4,534,750.00 0.950 3.14 1,187 1.36% Aaa/AA+/AAA 4339 91282CCW9 T 0.750 08/31/2026 (3.33Yr-Fixed) 09/23/2021 1,000,000.00 995,440.10 908,790.00 0.890 3.21 1,218 0.27% Aaa/AA+/AAA 4342 91282CCW9 T 0.750 08/31/2026 (3.33Yr-Fixed) 11/23/2021 5,000,000.00 4,913,692.95 4,543,950.00 1.285 3.21 1,218 1.35% Aaa/AA+/AAA 4379 91282CEW7 T 3.250 06/30/2027 (4.16Yr-Fixed) 12/29/2022 5,000,000.00 4,858,215.78 4,934,200.00 4.000 3.79 1,521 1.33% Aaa/AA+/AAA U.S. Treasuries Total 83,000,000.00 82,703,721.76 79,611,720.00 22.69% 4290 45818WBX3 IADB 2.870 07/20/2023 (0.22Yr-Fixed) 03/28/2019 4,000,000.00 4,004,984.33 3,978,640.00 2.270 0.22 80 1.10% Aaa/AAA/AAA 4291 45818WBY1 IADB 2.960 08/16/2023 (0.29Yr-Fixed) 03/28/2019 5,000,000.00 5,009,511.88 4,966,200.00 2.271 0.29 107 1.37% Aaa/AAA/AAA 4323 459056HV2 IBRD 1.500 08/28/2024 (1.33Yr-Fixed) 04/23/2021 5,000,000.00 5,070,619.75 4,811,750.00 0.425 1.29 485 1.39% Aaa/AAA/AAA 4338 459058JE4 IBRD 0.376 07/28/2025 (2.24Yr-Fixed) 07/30/2021 5,000,000.00 4,976,990.96 4,619,800.00 0.583 2.18 819 1.37% Aaa/AAA/AAA 4319 459058JL8 IBRD 0.500 10/28/2025 (2.49Yr-Fixed) 01/12/2021 5,000,000.00 4,998,570.83 4,598,150.00 0.512 2.42 911 1.37% Aaa/AAA/AAA 4324 45906M2L4 IBRD 0.650 02/24/2026 (2.82YrNC0.79Mo-Dq-Fixed) 04/30/2021 5,000,000.00 4,969,738.52 4,556,750.00 0.870 2.72 1,030 1.36% Aaa/AAA/AAA Supranational Total 29,000,000.00 29,030,416.27 27,531,290.00 7.96% 4285 3130AFWX1 FHLB 2.550 05/30/2023 (0.08Yr-Fixed) 02/26/2019 5,000,000.00 5,000,000.00 4,989,300.00 2.550 0.08 29 1.37% Aaa/AA+/NR 4281 313383QR5 FHLB 3.250 06/09/2023 (0.11Yr-Fixed) 12/20/2018 5,000,000.00 5,002,503.42 4,989,750.00 2.743 0.11 39 1.37% Aaa/AA+/NR 4368 313383MD0 FHLB 2.625 06/09/2023 (0.11Yr-Fixed) 05/09/2022 7,000,000.00 7,003,069.23 6,978,090.00 2.201 0.11 39 1.92% Aaa/AA+/NR 4287
3137EAEN5
FHLMC 2.750 06/19/2023 (0.13Yr-Fixed)
03/08/2019
3,000,000.00
3,001,130.69
2,990,670.00
2.450
0.13 49
0.82%
Aaa/AA+/AAA
4288 3137EAEN5 FHLMC 2.750 06/19/2023 (0.13Yr-Fixed) 03/14/2019 3,000,000.00 3,001,181.08 2,990,670.00 2.437 0.13 49 0.82% Aaa/AA+/AAA 4383 3130AUHE7 FHLB 0.000 07/26/2023 (0.24Yr-Disco) 01/18/2023 5,000,000.00 5,001,293.09 4,996,050.00 4.755 0.23 86 1.37% Aaa/AA+/NR 4289 3135G0U43 FNMA 2.875 09/12/2023 (0.37Yr-Fixed) 03/15/2019 5,000,000.00 5,007,015.83 4,961,650.00 2.465 0.36 134 1.37% Aaa/AA+/AAA 4377 313384ND7 FHDN 0.000 10/19/2023 (0.47Yr-Disco) 12/05/2022 3,000,000.00 2,934,378.75 2,932,470.00 4.817 0.46 171 0.80% P-1/A-1+/NR 4387 3130AUXN9 FHLB 5.000 02/15/2024 (0.79Yr-Fixed) 04/25/2023 3,000,000.00 3,001,557.10 2,998,860.00 4.923 0.76 290 0.82% Aaa/AA+/NR 4292 3133ECHX5 FFCB 2.260 03/13/2024 (0.87Yr-Fixed) 05/23/2019 5,000,000.00 5,000,973.87 4,889,450.00 2.236 0.84 317 1.37% Aaa/AA+/AAA 4378 3130ATVC8 FHLB 4.875 06/14/2024 (1.12Yr-Fixed) 12/28/2022 5,000,000.00 5,006,703.90 5,002,700.00 4.740 1.06 410 1.37% Aaa/AA+/NR 4348 3130AQD42 FHLB 0.920 06/28/2024 (1.16YrNC1.94Mo-Dq-Fixed) 12/28/2021 5,000,000.00 5,000,000.00 4,769,600.00 0.920 1.13 424 1.37% Aaa/AA+/NR 4380 3134GYCP5 FHLMC 5.000 07/23/2024 (1.23YrNC5.78Mo-1x-Fixed) 01/23/2023 5,000,000.00 5,000,000.00 4,978,100.00 5.000 0.75 449 1.37% Aaa/AA+/AAA Portfolio: CITYSecurities By Structure Report
City of Huntington Beach
Reporting Period:
04/30/2023
Report Run Date: Jul 11, 2023
27 Accounting ID Cusip Security Description Purchase Date Par Value Book Value Market Value Book Yield Effective Duration
Days to
Maturity
(%) of
Portfolio Mdy/S&P/Fitch
4344 3130AQ3C5 FHLB 1.000 08/28/2024 (1.33YrNC0.92Mo-Dq-Fixed) 12/02/2021 4,000,000.00 4,000,000.00 3,810,520.00 1.000 1.29 485 1.10% Aaa/AA+/NR 4373 3133XVDG3 FHLB 4.375 09/13/2024 (1.37Yr-Fixed) 09/23/2022 5,000,000.00 5,008,696.62 4,978,750.00 4.240 1.31 501 1.37% Aaa/AA+/NR 4336 3130AMXJ6 FHLB 0.500 09/30/2024 (1.42YrNC2.00Mo-Dq-Fixed) 06/30/2021 5,000,000.00 5,000,000.00 4,707,350.00 0.500 1.38 518 1.37% Aaa/AA+/NR 4346 3130AQD59 FHLB 1.000 09/30/2024 (1.42YrNC2.00Mo-Dq-Fixed) 12/30/2021 5,000,000.00 5,000,000.00 4,741,250.00 1.000 1.37 518 1.37% Aaa/AA+/NR 4349 3130AQD59 FHLB 1.000 09/30/2024 (1.42YrNC2.00Mo-Dq-Fixed) 12/30/2021 5,000,000.00 5,000,000.00 4,741,250.00 1.000 1.37 518 1.37% Aaa/AA+/NR 4334 3130AMW65 FHLB 0.500 12/30/2024 (1.67YrNC2.00Mo-Dq-Fixed) 06/30/2021 5,000,000.00 5,000,000.00 4,673,450.00 0.500 1.62 609 1.37% Aaa/AA+/NR 4332 3130AMQ62 FHLB 0.625 03/14/2025 (1.87YrNC1.48Mo-Dq-Fixed) 06/14/2021 5,000,000.00 5,000,000.00 4,653,100.00 0.625 1.81 683 1.37% Aaa/AA+/NR 4329 3135G04Z3 FNMA 0.500 06/17/2025 (2.13Yr-Fixed) 05/14/2021 5,000,000.00 4,986,557.30 4,637,650.00 0.628 2.07 778 1.37% Aaa/AA+/AAA 4381 3135G04Z3 FNMA 0.500 06/17/2025 (2.13Yr-Fixed) 01/13/2023 5,000,000.00 4,647,236.84 4,637,650.00 4.013 2.07 778 1.27% Aaa/AA+/AAA 4345 3130AQ5S8 FHLB 1.250 06/30/2025 (2.17YrNC2.00Mo-Dq-Fixed) 12/30/2021 4,650,000.00 4,650,000.00 4,357,980.00 1.250 2.08 791 1.28% Aaa/AA+/NR 4327 3130AMDL3 FHLB 0.800 07/25/2025 (2.23YrNC0.82Mo-Dq-Fixed) 05/25/2021 5,000,000.00 5,000,000.00 4,633,300.00 0.800 2.15 816 1.37% Aaa/AA+/NR 4360 3130AQT94 FHLB 1.600 08/28/2025 (2.33Yr-Fixed) 03/04/2022 4,575,000.00 4,552,861.05 4,316,192.25 1.816 2.23 850 1.25% Aaa/AA+/NR 4331 3130AMQ54 FHLB 0.700 09/16/2025 (2.38YrNC4.57Mo-Da-Fixed) 06/16/2021 5,000,000.00 5,000,000.00 4,604,900.00 0.700 2.30 869 1.37% Aaa/AA+/NR 4318 3135GA2Z3 FNMA 0.560 11/17/2025 (2.55YrNC6.60Mo-Da-Fixed) 01/11/2021 3,000,000.00 3,001,731.27 2,742,240.00 0.500 2.46 931 0.82% Aaa/AA+/AAA 4320 3130AKN36 FHLB 0.525 01/15/2026 (2.71YrNC2.50Mo-Dq-Fixed) 01/15/2021 5,000,000.00 4,997,294.44 4,533,100.00 0.545 2.62 990 1.37% Aaa/AA+/NR 4321 3130AKN85 FHLB 0.550 01/20/2026 (2.72YrNC2.66Mo-Dq-Fixed) 01/20/2021 5,000,000.00 4,998,640.28 4,534,600.00 0.560 2.63 995 1.37% Aaa/AA+/NR 4322 3130AKUS3 FHLB 0.500 01/28/2026 (2.75YrNC2.92Mo-Dq-Fixed) 01/28/2021 5,000,000.00 5,000,000.00 4,525,700.00 0.500 2.66 1,003 1.37% Aaa/AA+/NR 4333 3130ALEY6 FHLB 0.800 03/04/2026 (2.84YrNC1.15Mo-Dq-Fixed) 06/10/2021 5,000,000.00 5,000,000.00 4,546,900.00 0.800 2.74 1,038 1.37% Aaa/AA+/NR 4328 3130AMJN3 FHLB 1.030 05/26/2026 (3.07YrNC0.85Mo-Dq-Fixed) 05/26/2021 5,000,000.00 5,000,000.00 4,554,600.00 1.030 2.93 1,121 1.37% Aaa/AA+/NR 4335 3130AMFS6 FHLB 0.750 06/12/2026 (3.12Yr-Fixed) 06/17/2021 5,000,000.00 4,981,264.62 4,557,050.00 0.873 3.00 1,138 1.37% Aaa/AA+/NR 4347 3130AQ7E7 FHLB 1.500 06/30/2026 (3.16YrNC2.00Mo-Dq-Fixed) 12/30/2021 5,000,000.00 5,001,406.17 4,600,500.00 1.339 2.99 1,156 1.37% Aaa/AA+/NR 4384 3130AUMC5 FHLB 3.750 07/20/2026 (3.22Yr-Fixed) 01/19/2023 5,000,000.00 5,000,000.00 4,995,850.00 3.750 2.96 1,176 1.37% Aaa/AA+/NR 4356 3130AQS79 FHLB 1.375 08/07/2026 (3.27YrNC15.28Mo-1x-Step) 02/07/2022 5,000,000.00 5,000,000.00 4,653,950.00 1.375 2.91 1,194 1.37% Aaa/AA+/NR 4386 3133EPGT6 FFCB 3.875 04/26/2027 (3.99Yr-Fixed) 04/26/2023 5,000,000.00 4,994,269.97 5,014,500.00 3.906 3.64 1,456 1.37% Aaa/AA+/AAA 4385 3134GYPF3 FHLMC 4.750 07/12/2027 (4.20YrNC14.42Mo-Da-Fixed) 04/24/2023 3,300,000.00 3,295,072.83 3,297,558.00 4.791 1.90 1,533 0.90% Aaa/AA+/AAA U.S. Agencies Total 178,525,000.00 178,074,838.36 170,517,250.25 48.85% 4306 90331HNV1 USB 3.400 07/24/2023 (0.23YrNC1.77Mo-Cc-Fixed) 02/21/2020 2,000,000.00 2,007,527.22 1,990,980.00 1.671 0.23 84 0.55% A2/AA-/AA- 4300 254687CR5 DIS 4.000 10/01/2023 (0.42Yr-Fixed) 12/16/2019 2,875,000.00 2,897,115.38 2,856,628.75 2.070 0.41 153 0.79% A2/BBB+/A- 4355 67066GAL8 NVDA 0.584 06/14/2024 (1.12YrNC1.48Mo-Cc-Fixed) 01/24/2022 5,000,000.00 4,963,378.55 4,782,500.00 1.250 1.09 410 1.36% A2/A/ 4325
91159HHX1
USB 2.400 07/30/2024 (1.25YrNC13.96Mo-Cc-Fixed)
04/30/2021
3,809,000.00
3,894,658.22
3,677,741.86
0.528
1.20 456
1.07%
A3/A+/A+
4343
14913R2P1
CAT 0.600 09/13/2024 (1.37Yr-Fixed)
12/02/2021
5,000,000.00
4,974,416.98
4,742,900.00
0.980
1.34 501
1.36%
A2/A/A
4371
459200KS9
IBM 4.000 07/27/2025 (2.24Yr-Fixed)
08/11/2022
6,000,000.00
6,023,817.07
5,935,380.00
3.810
2.09 818
1.65%
A3/A-/
4372
931142EW9
WMT 3.900 09/09/2025 (2.36Yr-Fixed)
09/22/2022
5,000,000.00
4,972,501.59
4,970,350.00
4.150
2.21 862
1.36%
Aa2/AA/AA
4382
717081DV2
PFE 2.750 06/03/2026 (3.09Yr-Fixed)
01/18/2023
5,000,000.00
4,801,212.84
4,825,100.00
4.142
2.87 1,129
1.32%
A1/A+/A
4375
110122CN6
BMY 3.200 06/15/2026 (3.12YrNC35.52Mo-Cc-Fixed)
11/16/2022
5,000,000.00
4,817,142.90
4,870,200.00
4.480
2.84 1,141
1.32%
A2/A+/
Corporates Total 39,684,000.00 39,351,770.76 38,651,780.61 10.80% Holdings Total 335,209,000.00 334,123,663.82 321,269,390.86 91.66% Portfolio: CITYSecurities By Structure Report
City of Huntington Beach
Reporting Period:
04/30/2023
Report Run Date: Jul 11, 2023
28 Cash/Money Market/LGIP Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 04/30/2023
Cash/Money Market Account Activity
Accounting ID Description Activity Date Transaction Type Transaction Amount 003 California Asset Management Program 04/03/2023 Interest Received $80,411.35 003 California Asset Management Program 04/21/2023 Deposit $10,000,000.00 003 California Asset Management Program 04/25/2023 Deposit $3,000,000.00 Activity Total $13,080,411.35
982 LAIF 04/14/2023 Interest Received $6.36
982 LAIF 04/14/2023 Withdrawal ($6.36)
Activity Total $0.00
29 Bond Redemption Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 04/30/2023
Redemption Transactions
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
30 Bond Purchase Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 04/30/2023
Purchase Transactions
Accounting ID Transaction
Type Cusip Description Price Settlement
Date Posted Date Par Value Principal Accrued Interest Total 4385 Buy 3134GYPF3 FHLMC 4.750 07/12/2027 99.85000 04/24/2023 04/24/2023 3,300,000.00 $3,295,050.00 $5,225.00 $3,300,275.00 4387 Buy 3130AUXN9 FHLB 5.000 02/15/2024 100.05300 04/25/2023 04/25/2023 3,000,000.00 $3,001,590.00 $29,166.67 $3,030,756.67 4386 Buy 3133EPGT6 FFCB 3.875 04/26/2027 99.88500 04/26/2023 04/26/2023 5,000,000.00 $4,994,250.00 $0.00 $4,994,250.00 Activity Total 11,300,000.00 $11,290,890.00 $34,391.67 $11,325,281.67 31 Bond Interest Received Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 04/30/2023
Bond Interest Received
Accounting ID Transaction Type Cusip Description Date Posted Interest Received Purchased Interest Adjustment Net Interest 4300 Interest Income 254687CR5 DIS 4.000 10/01/2023 04/03/2023 $57,500.00 $57,500.00 4319 Interest Income 459058JL8 IBRD 0.500 10/28/2025 04/28/2023 $12,500.00 $12,500.00 Activity Total $70,000.00 $0.00 $70,000.00
32 Statement of Cash Receipts and Disbursements and
Cash Receipts and Disbursements March 2023 April 2023
Receipts
General Fund
Property Tax 4,784,171$ 21,208,398$
Local Sales Tax 3,650,664 3,318,537
Public Safety Sales Tax 313,247 214,419
Transient Occupancy Tax (TOT) 859,306 1,214,231
Utility Users Tax (UUT) 1,976,080 2,564,310
Other Revenue 7,475,327 5,685,370
Total General Fund Revenue 19,058,795 34,205,265
Total All Other Funds Revenue 21,133,448 22,286,424
Total Receipts 40,192,243$ 56,491,688$
Disbursements
General Fund
Personnel Services (11,009,605) (11,077,248)
Operating Expenses (4,395,889) (3,606,032)
Capital Expenditures - -
Non-Operating Expenses - (2,065,934)
Total General Fund Disbursements (15,405,494) (16,749,214) Total All Other Funds Disbursements (24,001,654) (16,088,385) Total Disbursements (39,407,148) (32,837,599)
Net Change in Cash Flow 785,095$ 23,654,089$
Summary of Cash by Fund March 2023 April 2023
General Fund 97,674,807$ 115,130,857$
General Fund Other 3,445,070 3,444,416
Capital Projects Funds 24,977,797 26,173,394
Debt Service Funds 41,025,168 41,358,285
Enterprise Funds 84,206,807 85,265,483
Trust and Agency Funds 4,855,623 5,816,861
Internal Service Funds 24,971,032 23,959,125
Special Revenue Funds 66,707,020 70,368,992
General Ledger Cash Balances * 347,863,324$ 371,517,414$ 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.
Summary of Cash by Fund
City Treasurer's Office
April 2023
33