City of Huntington Beach
Quar
terly Investment Report
December 2022
Prepared
by:
Alisa Backstrom, MBA, CCMT, CPFIM
City Treasurer
Colin Stevens, MPP
Treasury Associate
1 INVESTMENT PORTFOLIO SUMMARY
Currently, funds within this portfolio are invested in the California Asset Management Program “CAMP”, commercial paper, U.S. Treasury securities, Supranationals (International Bank of Reconstruction and Development “IBRD”, Inter-American Development Bank “IADB”), Federal Agency securities and corporate bonds. Only the investment types allowed under California Government Code Section 53601 and the City’s Investment Policy Statement are utilized.
Short-term interest rates continued to rise during the fourth quarter of 2022 as the Federal Reserve continued to raise the Federal Funds rate. As interest rates rise, the market price of the securities previously purchased (at lower than the current market rates) goes down. This has resulted in the current market value of the portfolio being lower than the book value, at $308.7 million versus $325.4 million, respectively. These increasing interest rates will allow excess funds to be invested at higher rates resulting in increased interest income in the future.
Investment Type
$ in 000's Market Value Book Value
Federal Agency Issues 137,664$ 147,116$
CA Asset Management Program (CAMP) 19,127$ 19,127$ Treasury Securities 81,463$ 85,671$
Medium Term Notes - Supranationals 27,099$ 29,059$ Corporate Bonds 38,469$ 39,568$
Commercial Paper 4,877$ 4,889$
TOTAL 308,699$ 325,430$
AS OF: December 31, 2022
2 PORTFOLIO BREAKOUT BY TYPE – BOOK VALUE as % of Total Portfolio
The largest holding by security type at month-end was Federal Agency securities at approximately 45% of the total overall portfolio. This was followed by U.S. Treasury securities at approximately 26% of the total portfolio as of December 30. Overnight liquidity has been reduced as higher interest rates have become available in marketable securities.
INVESTMENT PORTFOLIO EARNINGS
Earnings for the month of December 2022 were $462,460, an increase of approximately 77% from the same month in the prior year, due to the increase in interest rates. Fiscal y ear to date earnings of $2,232,897 were up approximately 43% from the previous fiscal year. The effect ive rate of return for December was 1.74%, with a fiscal year-to-date return of 1.44%. The increase in the December rate of 3 return over that of the fiscal year-to-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, especially on the short end, during 2022. At the end of December, the 12-month moving average of the interpolated 1.5-year U.S. Treasury was 2.84%. The portfolio rate of return will lag behind the benchmark, as it will take time for previously purchased securities to mature and funds reinvested.
QUARTERLY PORTFOLIO ACTIVITY
As the Federal Reserve continued to raise rates in the latter half of the 2022, funds were moved when possible into higher yielding options. Liquidity funds were moved from LAIF to the California Asset Management Program ("CAMP") account in order to take advantage of the higher yield. The CAMP Pool is a permitted investment for all local agencies under California Government Code Section 53601(p). It also has the highest rating by Standard & Poor’s of AAAm. As of 01/17/23, this fund had a current seven-day yield of 4.48%.
In addition to moving funds to CAMP, $5 million in Commercial Paper matured. $8 million in Federal Agencies was purchased, one $5 million Corporate Bond ( Bristol-Myers Squibb) was purchased, $5 million in Commercial Pape r was purchased, and two U.S. Treasury Securities were purchased for a total of $8 million.
Investment Type
$ in 000's
Purchases/
Deposits
Calls/Maturities/
Withdrawals
Federal Agency Issues 8,000$
Local Agency Investment Fund (LAIF) * 68$ 3,788$ CA Asset Management Program (CAMP)* 9,128$ 9,001$ Corporate Bonds 5,000$
Commercial Paper 5,000$ 5,000$
Treasury Securities 8,000$ -$
OC Investment Pool * 10$ 17$ TOTAL 35,206$ 17,806$
*Includes Interest Income
October 1 to December 30, 2022
4 CO
MPLIANCE SUMMARY
INVESTMENT
TYPE
MAXIMUM
MATURITY
MAXIMUM
SPECIFIED % OF
PORTFOLIO/
MAXIMUM PER
ISSUER
MINIMUM QUALITY
REQUIREMENTS
IN
COMPLIANCE?
Commercial
Paper 270 days 25%/10% A1, "A" Rating YES
State Obligations-
- CA And Others 5 years None/10% "A" Rating YES
U.S. Treasury
Obligations 5 years None None YES
U.S. Government
Agency
Obligations
5 years None None YES
IBRD, IFC, IADB 5 years 10% "AA" Rating YES
Corporate Notes 5 years 30%/10% "A" Rating YES
Local Agency
Investment Fund
(LAIF)
N/A Up to $75,000,000 None YES
Orange County
Investment Pool
(OCIP)
N/A Up to $75,000,000 None
YES
CA Asset Mgt
Program (CAMP) N/A Up to $75,000,000 Non e YES
Maximum
Maturities No more than 50% of portfolio maturing over 4 years. YES There were no compliance issues during this period.
5 ECONOMIC AND MARKET OVERVIEW
The Federal Open Market Committee (FOMC) met in December to discuss the current state of the economy and to examine potential future interest rate adjustments. They concluded that recent indicators point to modest growth in spending and production. In addition to Russia’s war against Ukraine causing tremendous human and economic hardship, inflation remains elevated, reflecting supply and demand imbalances related to the pandemic.
Fixed Income / Equity Markets: The yield on the 10-year U.S. Treasury finished the quarter at 3.88%, up from 3.83% at the end of last quarter. The S&P 500 increased by 7.08% while the DJIA increased by 15.39% respectively, over the same period.
Employment: Total nonfarm payroll employment rose by 223,000 in December and the unemployment rate remained the same at 3.5 percent . Notable job gains occurred in leisure and hospitality, health care, construction, and social assistance.
6 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
$19,127,333.39 $19,127,333.39 5.88% $19,127,333.39 0.253% 1 $5,000,000.00 $4,888,750.00 1.50% $4,877,150.00 0.069% 180 $86,000,000.00 $85,670,914.27 26.33% $81,462,990.00 0.426% 733 $29,000,000.00 $29,059,426.72 8.93% $27,098,880.00 0.100% 707 $147,225,000.00 $147,116,243.85 45.21% $137,663,506.50 0.698% 747 $39,684,000.00 $39,567,697.55 12.16% $38,469,145.31 0.280% 652 $326,036,333.39 $325,430,365.78 100.00% $308,699,005.20 1.825% 676 Portfolio Investments
12/31/2022
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 February 1, 2022. 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 6
Purchases 9
Total Activity 15
Net Period Earnings $2,232,897.34
Last FY Period Net Earnings $1,559,308.07
Avg Daily Book Balance $309,497,256.99
$1.00 $1.00
Net Effective Annual Return 1.436%
Net Period Earnings $462,459.62
Last FY Period Net Earnings $260,935.33
Avg Daily Book Balance $314,957,219.95
$1.00 $1.00
Net Effective Annual Return 1.743%
Fiscal YTD Summary (184 Days)Period Earnings Summary (31 Days) ______________________________________________ ____________________________ Portfolio Market Value
Accrued Interest Paid at
Purchase
Interest Receivable
Accrued Interest Earned
sum2
Total Market Value
$308,699,005.20
$56,982.64
$192,500.00
$1,164,929.38
$1.00
$310,113,417.22
Portfolio Book Value
Accrued Interest Paid at
Purchase
sum2
Total Book Value
$325,430,365.78
$56,982.64
$2.00
$325,487,348.42
Market Value
Book Value
Par Value
Portfolio Summary
Huntington Beach
Portfolio: CITY
Reporting Date: (FY2023)
12/01/2022 - 12/31/2022
Full Accrual Basis
sum2
Total Par Value
$1.00
$326,036,333.39
____________________________________________
The City Portfolio uses a 12 month moving average of the 1.5Yr Treasury for comparison purposes. This period, that rate is equal to: 2.840% 7 Accounting ID Pool Description Type Par Value Book Value Market Value Rate % of Portfolio Composite Rating 003
California Asset Management Program
LGIP
19,127,333.39
19,127,333.39
19,127,333.39
4.30 5.88%
NR
CITY Fund Total 19,127,333.39 19,127,333.39 19,127,333.39 5.88% Portfolio: CITYCash By Fund Report
City of Huntington Beach
Reporting Period:
12/31/2022
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
4374 62479MTW3 MUFGBK 0.000 06/30/2023 (0.49Yr-Disco) 10/05/2022 5,000,000.00 4,888,750.00 4,877,150.00 4.602 0.50 180 1.50% P-1/A-1/F1 Commercial Paper Total 5,000,000.00 4,888,750.00 4,877,150.00 1.50% 4299 912828P79 T 1.500 02/28/2023 (0.16Yr-Fixed) 12/05/2019 3,000,000.00 2,999,654.69 2,986,230.00 1.574 0.16 58 0.92% Aaa/AA+/AAA 4352 912828S92 T 1.250 07/31/2023 (0.58Yr-Fixed) 01/14/2022 5,000,000.00 5,015,515.81 4,901,550.00 0.711 0.56 211 1.54% Aaa/AA+/AAA 4357 91282CCN9 T 0.125 07/31/2023 (0.58Yr-Fixed) 02/02/2022 5,000,000.00 4,975,152.23 4,868,350.00 0.991 0.57 211 1.53% Aaa/AA+/AAA 4354 9128282D1 T 1.375 08/31/2023 (0.66Yr-Fixed) 01/21/2022 5,000,000.00 5,015,459.97 4,888,100.00 0.903 0.65 242 1.54% Aaa/AA+/AAA 4364 9128286Z8 T 1.750 06/30/2024 (1.49Yr-Fixed) 05/02/2022 7,000,000.00 6,900,966.66 6,707,960.00 2.730 1.45 546 2.12% Aaa/AA+/AAA 4370 912828XX3 T 2.000 06/30/2024 (1.49Yr-Fixed) 05/27/2022 5,000,000.00 4,966,544.12 4,808,800.00 2.462 1.45 546 1.53% Aaa/AA+/AAA 4353 912828Y87 T 1.750 07/31/2024 (1.58Yr-Fixed) 01/14/2022 5,000,000.00 5,056,209.36 4,782,600.00 1.028 1.52 577 1.55% Aaa/AA+/AAA 4358 912828Y87 T 1.750 07/31/2024 (1.58Yr-Fixed) 02/11/2022 4,000,000.00 4,009,554.76 3,826,080.00 1.595 1.52 577 1.23% Aaa/AA+/AAA 4361 912828D56 T 2.375 08/15/2024 (1.62Yr-Fixed) 03/22/2022 5,000,000.00 5,010,547.32 4,824,200.00 2.240 1.55 592 1.54% Aaa/AA+/AAA 4298 912828YH7 T 1.500 09/30/2024 (1.75Yr-Fixed) 12/05/2019 5,000,000.00 4,992,029.53 4,747,850.00 1.595 1.69 638 1.53% Aaa/AA+/AAA 4350 912828YM6 T 1.500 10/31/2024 (1.83Yr-Fixed) 12/31/2021 3,000,000.00 3,031,355.74 2,842,380.00 0.920 1.77 669 0.93% Aaa/AA+/AAA 4376 91282CEU1 T 2.875 06/15/2025 (2.45Yr-Fixed) 11/18/2022 3,000,000.00 2,903,260.60 2,899,560.00 4.276 2.33 896 0.89% Aaa/AA+/AAA 4330 91282CAB7 T 0.250 07/31/2025 (2.58Yr-Fixed) 05/19/2021 5,000,000.00 4,953,575.49 4,511,900.00 0.615 2.51 942 1.52% Aaa/AA+/AAA 4340 91282CAJ0 T 0.250 08/31/2025 (2.66Yr-Fixed) 09/27/2021 5,000,000.00 4,936,388.60 4,496,100.00 0.735 2.59 973 1.52% Aaa/AA+/AAA 4351 9128284Z0 T 2.750 08/31/2025 (2.66Yr-Fixed) 12/31/2021 5,000,000.00 5,214,219.87 4,806,050.00 1.103 2.50 973 1.60% Aaa/AA+/AAA 4341 91282CCP4 T 0.625 07/31/2026 (3.58Yr-Fixed) 09/30/2021 5,000,000.00 4,943,269.24 4,418,150.00 0.950 3.44 1,307 1.52% Aaa/AA+/AAA 4339 91282CCW9 T 0.750 08/31/2026 (3.66Yr-Fixed) 09/23/2021 1,000,000.00 994,990.85 885,430.00 0.890 3.52 1,338 0.31% Aaa/AA+/AAA 4342 91282CCW9 T 0.750 08/31/2026 (3.66Yr-Fixed) 11/23/2021 5,000,000.00 4,905,189.80 4,427,150.00 1.285 3.52 1,338 1.51% Aaa/AA+/AAA 4379 91282CEW7 T 3.250 06/30/2027 (4.49Yr-Fixed) 12/29/2022 5,000,000.00 4,847,029.65 4,834,550.00 4.000 4.10 1,641 1.49% Aaa/AA+/AAA U.S. Treasuries Total 86,000,000.00 85,670,914.27 81,462,990.00 26.33% 4290 45818WBX3 IADB 2.870 07/20/2023 (0.55Yr-Fixed) 03/28/2019 4,000,000.00 4,012,555.46 3,955,280.00 2.270 0.53 200 1.23% Aaa/AAA/AAA 4291 45818WBY1 IADB 2.960 08/16/2023 (0.62Yr-Fixed) 03/28/2019 5,000,000.00 5,020,382.60 4,938,500.00 2.271 0.60 227 1.54% Aaa/AAA/AAA 4323 459056HV2 IBRD 1.500 08/28/2024 (1.66Yr-Fixed) 04/23/2021 5,000,000.00 5,088,385.73 4,748,650.00 0.425 1.60 605 1.56% Aaa/AAA/AAA 4338 459058JE4 IBRD 0.375 07/28/2025 (2.57Yr-Fixed) 07/30/2021 5,000,000.00 4,973,569.54 4,518,400.00 0.583 2.50 939 1.53% Aaa/AAA/AAA 4319 459058JL8 IBRD 0.500 10/28/2025 (2.82Yr-Fixed) 01/12/2021 5,000,000.00 4,998,379.63 4,491,900.00 0.512 2.73 1,031 1.54% Aaa/AAA/AAA 4324 45906M2L4 IBRD 0.650 02/24/2026 (3.15YrNC1.81Mo-Dq-Fixed) 04/30/2021 5,000,000.00 4,966,153.75 4,446,150.00 0.870 3.03 1,150 1.53% Aaa/AAA/AAA Supranational Total 29,000,000.00 29,059,426.72 27,098,880.00 8.93% 4285 3130AFWX1 FHLB 2.550 05/30/2023 (0.41Yr-Fixed) 02/26/2019 5,000,000.00 5,000,000.00 4,962,600.00 2.550 0.40 149 1.54% Aaa/AA+/NR 4281 313383QR5 FHLB 3.250 06/09/2023 (0.44Yr-Fixed) 12/20/2018 5,000,000.00 5,010,408.95 4,973,200.00 2.743 0.43 159 1.54% Aaa/AA+/NR 4368
313383MD0
FHLB 2.625 06/09/2023 (0.44Yr-Fixed)
05/09/2022
7,000,000.00
7,012,761.54
6,946,380.00
2.201
0.43 159
2.15%
Aaa/AA+/NR
4287 3137EAEN5 FHLMC 2.750 06/19/2023 (0.46Yr-Fixed) 03/08/2019 3,000,000.00 3,003,957.43 2,974,680.00 2.450 0.45 169 0.92% Aaa/AA+/AAA 4288 3137EAEN5 FHLMC 2.750 06/19/2023 (0.46Yr-Fixed) 03/14/2019 3,000,000.00 3,004,133.79 2,974,680.00 2.437 0.45 169 0.92% Aaa/AA+/AAA 4289 3135G0U43 FNMA 2.875 09/12/2023 (0.70Yr-Fixed) 03/15/2019 5,000,000.00 5,013,442.55 4,935,750.00 2.465 0.67 254 1.54% Aaa/AA+/AAA 4377 313384ND7 FHDN 0.000 10/19/2023 (0.80Yr-Disco) 12/05/2022 3,000,000.00 2,888,328.75 2,894,610.00 4.817 0.78 291 0.89% P-1/A-1+/NR 4292 3133ECHX5 FFCB 2.260 03/13/2024 (1.20Yr-Fixed) 05/23/2019 5,000,000.00 5,001,348.44 4,852,850.00 2.236 1.15 437 1.54% Aaa/AA+/AAA 4378 3130ATVC8 FHLB 4.875 06/14/2024 (1.45Yr-Fixed) 12/28/2022 5,000,000.00 5,008,700.10 5,006,050.00 4.740 1.38 530 1.54% Aaa/AA+/NR 4348 3130AQD42 FHLB 0.920 06/28/2024 (1.49YrNC2.86Mo-Dq-Fixed) 12/28/2021 5,000,000.00 5,000,000.00 4,711,850.00 0.920 1.45 544 1.54% Aaa/AA+/NR 4344 3130AQ3C5 FHLB 1.000 08/28/2024 (1.66YrNC1.94Mo-Dq-Fixed) 12/02/2021 4,000,000.00 4,000,000.00 3,753,200.00 1.000 1.60 605 1.23% Aaa/AA+/NR 4373 3133XVDG3 FHLB 4.375 09/13/2024 (1.70Yr-Fixed) 09/23/2022 5,000,000.00 5,010,817.75 4,977,300.00 4.240 1.60 621 1.54% Aaa/AA+/NR Portfolio: CITYSecurities By Structure Report
City of Huntington Beach
Reporting Period:
12/31/2022
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
4336 3130AMXJ6 FHLB 0.500 09/30/2024 (1.75YrNC2.92Mo-Dq-Fixed) 06/30/2021 5,000,000.00 5,000,000.00 4,636,850.00 0.500 1.70 638 1.54% Aaa/AA+/NR 4346 3130AQD59 FHLB 1.000 09/30/2024 (1.75YrNC2.92Mo-Dq-Fixed) 12/30/2021 5,000,000.00 5,000,000.00 4,673,650.00 1.000 1.69 638 1.54% Aaa/AA+/NR 4349 3130AQD59 FHLB 1.000 09/30/2024 (1.75YrNC2.92Mo-Dq-Fixed) 12/30/2021 5,000,000.00 5,000,000.00 4,673,650.00 1.000 1.69 638 1.54% Aaa/AA+/NR 4334 3130AMW65 FHLB 0.500 12/30/2024 (2.00YrNC2.92Mo-Dq-Fixed) 06/30/2021 5,000,000.00 5,000,000.00 4,595,200.00 0.500 1.94 729 1.54% Aaa/AA+/NR 4332 3130AMQ62 FHLB 0.625 03/14/2025 (2.20YrNC2.40Mo-Dq-Fixed) 06/14/2021 5,000,000.00 5,000,000.00 4,574,350.00 0.625 2.13 803 1.54% Aaa/AA+/NR 4329 3135G04Z3 FNMA 0.500 06/17/2025 (2.46Yr-Fixed) 05/14/2021 5,000,000.00 4,984,451.39 4,549,550.00 0.628 2.39 898 1.53% Aaa/AA+/AAA 4345 3130AQ5S8 FHLB 1.250 06/30/2025 (2.49YrNC2.92Mo-Dq-Fixed) 12/30/2021 4,650,000.00 4,650,000.00 4,279,488.00 1.250 2.40 911 1.43% Aaa/AA+/NR 4327 3130AMDL3 FHLB 0.800 07/25/2025 (2.56YrNC1.84Mo-Dq-Fixed) 05/25/2021 5,000,000.00 5,000,000.00 4,540,300.00 0.800 2.47 936 1.54% Aaa/AA+/NR 4360 3130AQT94 FHLB 1.600 08/28/2025 (2.66YrNC1.94Mo-1x-Fixed) 03/04/2022 4,575,000.00 4,549,687.01 4,232,698.50 1.816 2.53 970 1.40% Aaa/AA+/NR 4331 3130AMQ54 FHLB 0.700 09/16/2025 (2.71YrNC8.51Mo-Da-Fixed) 06/16/2021 5,000,000.00 5,000,000.00 4,507,550.00 0.700 2.61 989 1.54% Aaa/AA+/NR 4318 3135GA2Z3 FNMA 0.560 11/17/2025 (2.88YrNC10.55Mo-Da-Fixed) 01/11/2021 3,000,000.00 3,001,958.08 2,683,320.00 0.500 2.78 1,051 0.92% Aaa/AA+/AAA 4320 3130AKN36 FHLB 0.525 01/15/2026 (3.04YrNC0.49Mo-Dq-Fixed) 01/15/2021 5,000,000.00 4,996,961.11 4,429,950.00 0.545 2.93 1,110 1.54% Aaa/AA+/NR 4321 3130AKN85 FHLB 0.550 01/20/2026 (3.05YrNC0.66Mo-Dq-Fixed) 01/20/2021 5,000,000.00 4,998,473.61 4,438,950.00 0.560 2.94 1,115 1.54% Aaa/AA+/NR 4322 3130AKUS3 FHLB 0.500 01/28/2026 (3.07YrNC0.92Mo-Dq-Fixed) 01/28/2021 5,000,000.00 5,000,000.00 4,428,450.00 0.500 2.97 1,123 1.54% Aaa/AA+/NR 4333 3130ALEY6 FHLB 0.800 03/04/2026 (3.17YrNC2.07Mo-Dq-Fixed) 06/10/2021 5,000,000.00 5,000,000.00 4,456,650.00 0.800 3.05 1,158 1.54% Aaa/AA+/NR 4328 3130AMJN3 FHLB 1.030 05/26/2026 (3.40YrNC1.87Mo-Dq-Fixed) 05/26/2021 5,000,000.00 5,000,000.00 4,465,100.00 1.030 3.25 1,241 1.54% Aaa/AA+/NR 4335 3130AMFS6 FHLB 0.750 06/12/2026 (3.44Yr-Fixed) 06/17/2021 5,000,000.00 4,979,259.05 4,453,450.00 0.873 3.32 1,258 1.53% Aaa/AA+/NR 4347 3130AQ7E7 FHLB 1.500 06/30/2026 (3.49YrNC2.92Mo-Dq-Fixed) 12/30/2021 5,000,000.00 5,001,554.32 4,519,900.00 1.339 3.32 1,276 1.54% Aaa/AA+/NR 4356 3130AQS79 FHLB 1.375 08/07/2026 (3.60YrNC19.22Mo-1x-Step) 02/07/2022 5,000,000.00 5,000,000.00 4,561,300.00 1.375 3.31 1,314 1.54% Aaa/AA+/NR U.S. Agencies Total 147,225,000.00 147,116,243.85 137,663,506.50 45.21% 4313 037833DE7 AAPL 2.400 01/13/2023 (0.03Yr-Fixed) 04/29/2020 5,000,000.00 5,002,683.37 4,997,600.00 0.720 0.03 12 1.54% Aaa/AA+/NR 4306 90331HNV1 USB 3.400 07/24/2023 (0.56YrNC5.72Mo-Cc-Fixed) 02/21/2020 2,000,000.00 2,018,409.94 1,981,740.00 1.671 0.54 204 0.62% A1/AA-/A1 4300 254687CR5 DIS 4.000 10/01/2023 (0.75Yr-Fixed) 12/16/2019 2,875,000.00 2,914,807.69 2,852,891.25 2.070 0.72 273 0.90% A2/BBB+/A- 4355 67066GAL8 NVDA 0.584 06/14/2024 (1.45YrNC5.42Mo-Cc-Fixed) 01/24/2022 5,000,000.00 4,952,473.90 4,717,700.00 1.250 1.41 530 1.52% A2/A/ 4325 91159HHX1 USB 2.400 07/30/2024 (1.58YrNC17.91Mo-Cc-Fixed) 04/30/2021 3,809,000.00 3,917,551.29 3,661,744.06 0.528 1.50 576 1.20% A2/A+/A+ 4343 14913R2P1 CAT 0.600 09/13/2024 (1.70Yr-Fixed) 12/02/2021 5,000,000.00 4,968,177.22 4,664,150.00 0.980 1.65 621 1.53% A2/A/A 4371 459200KS9 IBM 4.000 07/27/2025 (2.57Yr-Fixed) 08/11/2022 6,000,000.00 6,027,363.04 5,902,620.00 3.810 2.36 938 1.85% A3/A-/ 4372 931142EW9 WMT 3.900 09/09/2025 (2.69Yr-Fixed) 09/22/2022 5,000,000.00 4,968,610.31 4,923,950.00 4.150 2.49 982 1.53% Aa2/AA/AA 4375 110122CN6 BMY 3.200 06/15/2026 (3.45YrNC39.46Mo-Cc-Fixed) 11/16/2022 5,000,000.00 4,797,620.79 4,766,750.00 4.480 3.17 1,261 1.47% A2/A+/WD Corporates Total 39,684,000.00 39,567,697.55 38,469,145.31 12.16% Holdings Total 306,909,000.00 306,303,032.39 289,571,671.81 94.12% Portfolio: CITYSecurities By Structure Report
City of Huntington Beach
Reporting Period:
12/31/2022
10 Cash/Money Market/LGIP Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 12/31/2022
Cash/Money Market Account Activity
Accounting ID Description Activity Date Transaction Type Transaction Amount 003 California Asset Management Program 12/01/2022 Interest Received $50,930.64 003 California Asset Management Program 12/14/2022 Withdrawal ($3,000,000.00) 003 California Asset Management Program 12/06/2022 Deposit $3,000,000.00 003 California Asset Management Program 12/23/2022 Deposit $3,000,000.00 Activity Total $3,050,930.64
11 Redemption Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 12/31/2022
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
12 Purchase Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 12/31/2022
Purchase Transactions
Accounting ID Transaction
Type Cusip Description Price Settlement
Date Posted Date Par Value Principal Accrued Interest Total 4377 Buy 313384ND7 FHDN 0.000 10/19/2023 95.93225 12/05/2022 12/05/2022 3,000,000.00 $2,877,967.50 $0.00 $2,877,967.50 4378 Buy 3130ATVC8 FHLB 4.875 06/14/2024 100.17500 12/28/2022 12/28/2022 5,000,000.00 $5,008,750.00 $34,531.25 $5,043,281.25 4379 Buy 91282CEW7 T 3.250 06/30/2027 96.93500 12/29/2022 12/29/2022 5,000,000.00 $4,846,750.00 $80,366.85 $4,927,116.85 Activity Total 13,000,000.00 $12,733,467.50 $114,898.10 $12,848,365.60 13 Bond Interest Received Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 12/31/2022
Bond Interest Received
Accounting ID Transaction Type Cusip Description Date Posted Cash Interest Received Purchased Interest Adjustment Net Interest 4281 Interest Income 313383QR5 FHLB 3.250 06/09/2023 12/09/2022 $81,250.00 $81,250.00 4368 Interest Income 313383MD0 FHLB 2.625 06/09/2023 12/09/2022 $91,875.00 $91,875.00 4335 Interest Income 3130AMFS6 FHLB 0.750 06/12/2026 12/12/2022 $18,750.00 $18,750.00 4355 Interest Income 67066GAL8 NVDA 0.584 06/14/2024 12/14/2022 $14,600.00 $14,600.00 4375 Interest Income 110122CN6 BMY 3.200 06/15/2026 12/15/2022 $80,000.00 $67,111.11 $12,888.89 4376 Interest Income 91282CEU1 T 2.875 06/15/2025 12/15/2022 $43,125.00 $36,762.30 $6,362.70 4329 Interest Income 3135G04Z3 FNMA 0.500 06/17/2025 12/19/2022 $12,500.00 $12,500.00 4287 Interest Income 3137EAEN5 FHLMC 2.750 06/19/2023 12/19/2022 $41,250.00 $41,250.00 4288 Interest Income 3137EAEN5 FHLMC 2.750 06/19/2023 12/19/2022 $41,250.00 $41,250.00 4348 Interest Income 3130AQD42 FHLB 0.920 06/28/2024 12/28/2022 $23,000.00 $23,000.00 4334 Interest Income 3130AMW65 FHLB 0.500 12/30/2024 12/30/2022 $12,500.00 $12,500.00 4345 Interest Income 3130AQ5S8 FHLB 1.250 06/30/2025 12/30/2022 $29,062.50 $29,062.50 4346 Interest Income 3130AQD59 FHLB 1.000 09/30/2024 12/30/2022 $25,000.00 $25,000.00 4347 Interest Income 3130AQ7E7 FHLB 1.500 06/30/2026 12/30/2022 $37,500.00 $37,500.00 4349 Interest Income 3130AQD59 FHLB 1.000 09/30/2024 12/30/2022 $25,000.00 $25,000.00 Activity Total $576,662.50 $103,873.41 $472,789.09
14 Statement of Cash Receipts and Disbursements and
Cash Receipts and Disbursements November 2022 December 2022 Receipts
General Fund
Property Tax 13,932,088$ 23,693,577$
Local Sales Tax 4,134,068 4,237,274
Public Safety Sales Tax 241,265 290,139 Transient Occupancy Tax (TOT) 1,554,091 1,000,355 Utility Users Tax (UUT) 1,773,734 1,359,100 Other Revenue 7,108,845 4,242,624
Total General Fund Revenue 28,744,092 34,823,068 Total All Other Funds Revenue 23,245,292 19,732,658 Total Receipts 51,989,384$ 54,555,727$
Disbursements
General Fund
Personnel Services (10,628,635) (16,439,936)
Operating Expenses (4,631,674) (4,141,076)
Capital Expenditures ‐ ‐ Non‐Operating Expenses (1,115) (465,427) Total General Fund Disbursements (15,261,424) (21,046,440) Total All Other Funds Disbursements (19,944,033) (21,907,222) Total Disbursements (35,205,456) (42,953,662)
Net Change in Cash Flow 16,783,928 $ 11,602,065 $ Summary of Cash by Fund November 2022 December 2022
General Fund 82,962,969$ 96,739,597$
General Fund Other 3,266,741 3,190,174 Capital Projects Funds 29,030,279 28,340,156 Debt Service Funds 24,626,564 22,675,329 Enterprise Funds 85,720,624 85,914,556
Trust and Agency Funds 6,117,338 7,402,428 Internal Service Funds 30,920,596 30,146,736 Special Revenue Funds 63,814,965 63,653,164 General Ledger Cash Balances * 326,460,075$ 338,062,140$ 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
Finance Department
December 2022
15 Par Value Book Value Book Value % of
Port Market Value Book Yield
Contribution Days to Maturity
Pooled Cash Accounts
Commercial Paper
U.S. Treasuries
Supranational
U.S. Agencies
Corporates
Hold
Total
$16,076,402.75 $16,076,402.75 5.19% $16,076,402.75 0.202% 1 $5,000,000.00 $4,869,590.28 1.57% $4,846,750.00 0.072% 211 $81,000,000.00 $80,818,203.74 26.10% $76,616,260.00 0.385% 710 $29,000,000.00 $29,066,679.33 9.39% $27,125,000.00 0.105% 738 $139,225,000.00 $139,225,437.29 44.96% $129,679,172.00 0.612% 796 $39,684,000.00 $39,578,020.04 12.78% $38,493,184.06 0.295% 683 $309,985,402.75 $309,634,333.42 100.00% $292,836,768.81 1.671% 703 Portfolio Investments
11/30/2022
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 February 1, 2022. 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 2
Total Activity 2
Period Transactions
Redemptions 6
Purchases 6
Total Activity 12
Net Period Earnings $1,770,437.72
Last FY Period Net Earnings $783,380.74
Avg Daily Book Balance $308,405,264.39
$1.00 $1.00
Net Effective Annual Return 1.375%
Net Period Earnings $415,620.82
Avg Daily Book Balance $305,402,012.27
$1.00 $1.00
Net Effective Annual Return 1.668%
Fiscal YTD Summary (153 Days)Period Earnings Summary (30 Days) ______________________________________________ ____________________________ Portfolio Market Value
Accrued Interest Paid at
Purchase
Accrued Interest Earned
sum2
Total Market Value
$292,836,768.81
$126,324.80
$1,349,956.87
$1.00
$294,313,050.48
Portfolio Book Value
Accrued Interest Paid at
Purchase
sum2
Total Book Value
$309,634,333.42
$126,324.80
$2.00
$309,760,658.22
Market Value
Book Value
Par Value
Portfolio Summary
Huntington Beach
Portfolio: CITY
Reporting Date: (FY2023)
11/01/2022 - 11/30/2022
Full Accrual Basis
sum2
Total Par Value
$1.00
$309,985,402.75
____________________________________________
The City Portfolio uses a 12 month moving average of the 1.5Yr Treasury for comparison purposes. This period, that rate is equal to: 2.520% 16 Accounting ID Pool Description Type Par Value Book Value Market Value Rate % of Portfolio Composite Rating 003
California Asset Management Program
LGIP
16,076,402.75
16,076,402.75
16,076,402.75
3.90 5.19%
NR
CITY Fund Total 16,076,402.75 16,076,402.75 16,076,402.75 5.19% Portfolio: CITYCash By Fund Report
City of Huntington Beach
Reporting Period:
11/30/2022
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
4374 62479MTW3 MUFGBK 0.000 06/30/2023 (0.58Yr-Disco) 10/05/2022 5,000,000.00 4,869,590.28 4,846,750.00 4.602 0.58 211 1.57% P-1/A-1/F1 Commercial Paper Total 5,000,000.00 4,869,590.28 4,846,750.00 1.57% 4299 912828P79 T 1.500 02/28/2023 (0.24Yr-Fixed) 12/05/2019 3,000,000.00 2,999,470.13 2,978,490.00 1.574 0.24 89 0.97% Aaa/AA+/AAA 4352 912828S92 T 1.250 07/31/2023 (0.66Yr-Fixed) 01/14/2022 5,000,000.00 5,017,795.38 4,886,700.00 0.711 0.65 242 1.62% Aaa/AA+/AAA 4357 91282CCN9 T 0.125 07/31/2023 (0.66Yr-Fixed) 02/02/2022 5,000,000.00 4,971,501.61 4,849,400.00 0.991 0.65 242 1.61% Aaa/AA+/AAA 4354 9128282D1 T 1.375 08/31/2023 (0.75Yr-Fixed) 01/21/2022 5,000,000.00 5,017,440.37 4,876,000.00 0.903 0.73 273 1.62% Aaa/AA+/AAA 4364 9128286Z8 T 1.750 06/30/2024 (1.58Yr-Fixed) 05/02/2022 7,000,000.00 6,895,343.89 6,705,790.00 2.730 1.52 577 2.23% Aaa/AA+/AAA 4370 912828XX3 T 2.000 06/30/2024 (1.58Yr-Fixed) 05/27/2022 5,000,000.00 4,964,644.61 4,807,400.00 2.462 1.52 577 1.60% Aaa/AA+/AAA 4353 912828Y87 T 1.750 07/31/2024 (1.66Yr-Fixed) 01/14/2022 5,000,000.00 5,059,229.28 4,778,700.00 1.028 1.60 608 1.63% Aaa/AA+/AAA 4358 912828Y87 T 1.750 07/31/2024 (1.66Yr-Fixed) 02/11/2022 4,000,000.00 4,010,068.10 3,822,960.00 1.595 1.60 608 1.30% Aaa/AA+/AAA 4361 912828D56 T 2.375 08/15/2024 (1.71Yr-Fixed) 03/22/2022 5,000,000.00 5,011,099.63 4,824,200.00 2.240 1.63 623 1.62% Aaa/AA+/AAA 4298 912828YH7 T 1.500 09/30/2024 (1.83Yr-Fixed) 12/05/2019 5,000,000.00 4,991,642.25 4,743,150.00 1.595 1.77 669 1.61% Aaa/AA+/AAA 4350 912828YM6 T 1.500 10/31/2024 (1.92Yr-Fixed) 12/31/2021 3,000,000.00 3,032,808.70 2,842,260.00 0.920 1.85 700 0.98% Aaa/AA+/AAA 4376 91282CEU1 T 2.875 06/15/2025 (2.54Yr-Fixed) 11/18/2022 3,000,000.00 2,899,913.59 2,907,180.00 4.276 2.38 927 0.94% Aaa/AA+/AAA 4330 91282CAB7 T 0.250 07/31/2025 (2.66Yr-Fixed) 05/19/2021 5,000,000.00 4,952,047.72 4,515,250.00 0.615 2.59 973 1.60% Aaa/AA+/AAA 4340 91282CAJ0 T 0.250 08/31/2025 (2.75Yr-Fixed) 09/27/2021 5,000,000.00 4,934,361.92 4,499,200.00 0.735 2.68 1,004 1.59% Aaa/AA+/AAA 4351 9128284Z0 T 2.750 08/31/2025 (2.75Yr-Fixed) 12/31/2021 5,000,000.00 5,221,044.96 4,821,300.00 1.103 2.59 1,004 1.69% Aaa/AA+/AAA 4341 91282CCP4 T 0.625 07/31/2026 (3.66Yr-Fixed) 09/30/2021 5,000,000.00 4,941,923.67 4,429,500.00 0.950 3.53 1,338 1.60% Aaa/AA+/AAA 4339 91282CCW9 T 0.750 08/31/2026 (3.75Yr-Fixed) 09/23/2021 1,000,000.00 994,874.79 888,130.00 0.890 3.60 1,369 0.32% Aaa/AA+/AAA 4342 91282CCW9 T 0.750 08/31/2026 (3.75Yr-Fixed) 11/23/2021 5,000,000.00 4,902,993.15 4,440,650.00 1.285 3.60 1,369 1.58% Aaa/AA+/AAA U.S. Treasuries Total 81,000,000.00 80,818,203.74 76,616,260.00 26.10% 4290 45818WBX3 IADB 2.870 07/20/2023 (0.63Yr-Fixed) 03/28/2019 4,000,000.00 4,014,448.25 3,956,400.00 2.270 0.61 231 1.30% Aaa/AAA/AAA 4291 45818WBY1 IADB 2.960 08/16/2023 (0.71Yr-Fixed) 03/28/2019 5,000,000.00 5,023,100.29 4,941,500.00 2.271 0.69 258 1.62% Aaa/AAA/AAA 4323 459056HV2 IBRD 1.500 08/28/2024 (1.74Yr-Fixed) 04/23/2021 5,000,000.00 5,092,827.22 4,748,650.00 0.425 1.68 636 1.64% Aaa/AAA/AAA 4338 459058JE4 IBRD 0.375 07/28/2025 (2.66Yr-Fixed) 07/30/2021 5,000,000.00 4,972,714.19 4,521,900.00 0.583 2.58 970 1.61% Aaa/AAA/AAA 4319 459058JL8 IBRD 0.500 10/28/2025 (2.91Yr-Fixed) 01/12/2021 5,000,000.00 4,998,331.84 4,499,100.00 0.512 2.82 1,062 1.61% Aaa/AAA/AAA 4324 45906M2L4 IBRD 0.650 02/24/2026 (3.23YrNC2.83Mo-Dq-Fixed) 04/30/2021 5,000,000.00 4,965,257.55 4,457,450.00 0.870 3.12 1,181 1.60% Aaa/AAA/AAA Supranational Total 29,000,000.00 29,066,679.33 27,125,000.00 9.39% 4285 3130AFWX1 FHLB 2.550 05/30/2023 (0.49Yr-Fixed) 02/26/2019 5,000,000.00 5,000,000.00 4,949,850.00 2.550 0.48 180 1.61% Aaa/AA+/NR 4281 313383QR5 FHLB 3.250 06/09/2023 (0.52Yr-Fixed) 12/20/2018 5,000,000.00 5,012,385.33 4,964,950.00 2.743 0.50 190 1.62% Aaa/AA+/NR 4368 313383MD0 FHLB 2.625 06/09/2023 (0.52Yr-Fixed) 05/09/2022 7,000,000.00 7,015,184.62 6,928,670.00 2.201 0.50 190 2.27% Aaa/AA+/NR 4287
3137EAEN5
FHLMC 2.750 06/19/2023 (0.55Yr-Fixed)
03/08/2019
3,000,000.00
3,004,664.11
2,966,670.00
2.450
0.53 200
0.97%
Aaa/AA+/AAA
4288 3137EAEN5 FHLMC 2.750 06/19/2023 (0.55Yr-Fixed) 03/14/2019 3,000,000.00 3,004,871.96 2,966,670.00 2.437 0.53 200 0.97% Aaa/AA+/AAA 4289 3135G0U43 FNMA 2.875 09/12/2023 (0.78Yr-Fixed) 03/15/2019 5,000,000.00 5,015,049.23 4,925,500.00 2.465 0.76 285 1.62% Aaa/AA+/AAA 4292 3133ECHX5 FFCB 2.260 03/13/2024 (1.28Yr-Fixed) 05/23/2019 5,000,000.00 5,001,442.08 4,845,500.00 2.236 1.24 468 1.62% Aaa/AA+/AAA 4348 3130AQD42 FHLB 0.920 06/28/2024 (1.57YrNC0.92Mo-Dq-Fixed) 12/28/2021 5,000,000.00 5,000,000.00 4,702,800.00 0.920 1.52 575 1.61% Aaa/AA+/NR 4344 3130AQ3C5 FHLB 1.000 08/28/2024 (1.74YrNC2.96Mo-Dq-Fixed) 12/02/2021 4,000,000.00 4,000,000.00 3,747,640.00 1.000 1.69 636 1.29% Aaa/AA+/NR 4373 3133XVDG3 FHLB 4.375 09/13/2024 (1.79Yr-Fixed) 09/23/2022 5,000,000.00 5,011,348.03 4,984,950.00 4.240 1.68 652 1.62% Aaa/AA+/NR 4336 3130AMXJ6 FHLB 0.500 09/30/2024 (1.83YrNC0.99Mo-Dq-Fixed) 06/30/2021 5,000,000.00 5,000,000.00 4,628,400.00 0.500 1.78 669 1.61% Aaa/AA+/NR 4346 3130AQD59 FHLB 1.000 09/30/2024 (1.83YrNC0.99Mo-Dq-Fixed) 12/30/2021 5,000,000.00 5,000,000.00 4,669,650.00 1.000 1.77 669 1.61% Aaa/AA+/NR 4349 3130AQD59 FHLB 1.000 09/30/2024 (1.83YrNC0.99Mo-Dq-Fixed) 12/30/2021 5,000,000.00 5,000,000.00 4,669,650.00 1.000 1.77 669 1.61% Aaa/AA+/NR Portfolio: CITYSecurities By Structure Report
City of Huntington Beach
Reporting Period:
11/30/2022
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
4334 3130AMW65 FHLB 0.500 12/30/2024 (2.08YrNC0.99Mo-Dq-Fixed) 06/30/2021 5,000,000.00 5,000,000.00 4,588,950.00 0.500 2.02 760 1.61% Aaa/AA+/NR 4332 3130AMQ62 FHLB 0.625 03/14/2025 (2.28YrNC0.46Mo-Dq-Fixed) 06/14/2021 5,000,000.00 5,000,000.00 4,570,050.00 0.625 2.21 834 1.61% Aaa/AA+/NR 4329 3135G04Z3 FNMA 0.500 06/17/2025 (2.54Yr-Fixed) 05/14/2021 5,000,000.00 4,983,924.92 4,553,450.00 0.628 2.47 929 1.61% Aaa/AA+/AAA 4345 3130AQ5S8 FHLB 1.250 06/30/2025 (2.58YrNC0.99Mo-Dq-Fixed) 12/30/2021 4,650,000.00 4,650,000.00 4,279,209.00 1.250 2.47 942 1.50% Aaa/AA+/NR 4327 3130AMDL3 FHLB 0.800 07/25/2025 (2.65YrNC2.86Mo-Dq-Fixed) 05/25/2021 5,000,000.00 5,000,000.00 4,538,600.00 0.800 2.56 967 1.61% Aaa/AA+/NR 4360 3130AQT94 FHLB 1.600 08/28/2025 (2.74YrNC2.96Mo-1x-Fixed) 03/04/2022 4,575,000.00 4,548,893.50 4,234,803.00 1.816 2.61 1,001 1.47% Aaa/AA+/NR 4331 3130AMQ54 FHLB 0.700 09/16/2025 (2.79YrNC9.53Mo-Da-Fixed) 06/16/2021 5,000,000.00 5,000,000.00 4,506,800.00 0.700 2.70 1,020 1.61% Aaa/AA+/NR 4318 3135GA2Z3 FNMA 0.560 11/17/2025 (2.96YrNC11.56Mo-Da-Fixed) 01/11/2021 3,000,000.00 3,002,014.78 2,683,260.00 0.500 2.87 1,082 0.97% Aaa/AA+/AAA 4320 3130AKN36 FHLB 0.525 01/15/2026 (3.12YrNC1.51Mo-Dq-Fixed) 01/15/2021 5,000,000.00 4,996,877.78 4,429,350.00 0.545 3.02 1,141 1.61% Aaa/AA+/NR 4321 3130AKN85 FHLB 0.550 01/20/2026 (3.14YrNC1.68Mo-Dq-Fixed) 01/20/2021 5,000,000.00 4,998,431.94 4,438,350.00 0.560 3.03 1,146 1.61% Aaa/AA+/NR 4322 3130AKUS3 FHLB 0.500 01/28/2026 (3.16YrNC1.94Mo-Dq-Fixed) 01/28/2021 5,000,000.00 5,000,000.00 4,427,850.00 0.500 3.05 1,154 1.61% Aaa/AA+/NR 4333 3130ALEY6 FHLB 0.800 03/04/2026 (3.26YrNC0.13Mo-Dq-Fixed) 06/10/2021 5,000,000.00 5,000,000.00 4,458,400.00 0.800 3.13 1,189 1.61% Aaa/AA+/NR 4328 3130AMJN3 FHLB 1.030 05/26/2026 (3.48YrNC2.89Mo-Dq-Fixed) 05/26/2021 5,000,000.00 5,000,000.00 4,469,550.00 1.030 3.34 1,272 1.61% Aaa/AA+/NR 4335 3130AMFS6 FHLB 0.750 06/12/2026 (3.53Yr-Fixed) 06/17/2021 5,000,000.00 4,978,757.66 4,457,150.00 0.873 3.39 1,289 1.61% Aaa/AA+/NR 4347 3130AQ7E7 FHLB 1.500 06/30/2026 (3.58YrNC0.99Mo-Dq-Fixed) 12/30/2021 5,000,000.00 5,001,591.36 4,525,950.00 1.339 3.36 1,307 1.62% Aaa/AA+/NR 4356 3130AQS79 FHLB 1.375 08/07/2026 (3.68YrNC20.24Mo-1x-Step) 02/07/2022 5,000,000.00 5,000,000.00 4,566,550.00 1.375 3.35 1,345 1.61% Aaa/AA+/NR U.S. Agencies Total 139,225,000.00 139,225,437.29 129,679,172.00 44.96% 4313 037833DE7 AAPL 2.400 01/13/2023 (0.12YrNC0.43Mo-Cc-Fixed) 04/29/2020 5,000,000.00 5,009,391.79 4,986,350.00 0.720 0.12 43 1.62% Aaa/AA+/NR 4306 90331HNV1 USB 3.400 07/24/2023 (0.64YrNC6.74Mo-Cc-Fixed) 02/21/2020 2,000,000.00 2,021,130.62 1,980,740.00 1.671 0.62 235 0.65% A1/AA-/A1 4300 254687CR5 DIS 4.000 10/01/2023 (0.83Yr-Fixed) 12/16/2019 2,875,000.00 2,919,230.77 2,845,876.25 2.070 0.80 304 0.94% A2/BBB+/A- 4355 67066GAL8 NVDA 0.584 06/14/2024 (1.54YrNC6.44Mo-Cc-Fixed) 01/24/2022 5,000,000.00 4,949,747.73 4,700,700.00 1.250 1.49 561 1.60% A2/A/ 4325 91159HHX1 USB 2.400 07/30/2024 (1.66YrNC18.92Mo-Cc-Fixed) 04/30/2021 3,809,000.00 3,923,274.56 3,676,027.81 0.528 1.58 607 1.27% A2/A+/A+ 4343 14913R2P1 CAT 0.600 09/13/2024 (1.79Yr-Fixed) 12/02/2021 5,000,000.00 4,966,617.28 4,654,250.00 0.980 1.73 652 1.60% A2/A/A 4371 459200KS9 IBM 4.000 07/27/2025 (2.65Yr-Fixed) 08/11/2022 6,000,000.00 6,028,249.53 5,908,740.00 3.810 2.45 969 1.95% A3/A-/ 4372 931142EW9 WMT 3.900 09/09/2025 (2.77Yr-Fixed) 09/22/2022 5,000,000.00 4,967,637.49 4,937,750.00 4.150 2.57 1,013 1.60% Aa2/AA/AA 4375 110122CN6 BMY 3.200 06/15/2026 (3.54YrNC40.48Mo-Cc-Fixed) 11/16/2022 5,000,000.00 4,792,740.26 4,802,750.00 4.480 3.20 1,292 1.55% A2/A+/WD Corporates Total 39,684,000.00 39,578,020.04 38,493,184.06 12.78% Holdings Total 293,909,000.00 293,557,930.67 276,760,366.06 94.81% Portfolio: CITYSecurities By Structure Report
City of Huntington Beach
Reporting Period:
11/30/2022
19 Cash/Money Market/LGIP Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 11/30/2022
Cash/Money Market Account Activity
Accounting ID Description Activity Date Transaction Type Transaction Amount 001 Orange County Pool 11/01/2022 Admin Fee ($0.59)
001 Orange County Pool 11/28/2022 Interest Received $3,385.76 001 Orange County Pool 11/28/2022 Interest Received $174.54 001 Orange County Pool 11/28/2022 Interest Received $19.90 001 Orange County Pool 11/28/2022 Interest Received $16.78 001 Orange County Pool 11/28/2022 Admin Fee ($0.60)
001 Orange County Pool 11/23/2022 Withdrawal ($10,380.91) Activity Total ($6,785.12)
003 California Asset Management Program 11/01/2022 Interest Received $47,828.38 003 California Asset Management Program 11/23/2022 Withdrawal ($3,000,000.00) 003 California Asset Management Program 11/25/2022 Deposit $3,000,000.00 Activity Total $47,828.38
20 Redemption Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 11/30/2022
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
21 Purchase Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 11/30/2022
Purchase Transactions
Accounting ID Transaction
Type Cusip Description Price Settlement
Date Posted Date Par Value Principal Accrued Interest Total 4375 Buy 110122CN6 BMY 3.200 06/15/2026 95.80600 11/16/2022 11/16/2022 5,000,000.00 $4,790,300.00 $67,111.11 $4,857,411.11 4376 Buy 91282CEU1 T 2.875 06/15/2025 96.61700 11/18/2022 11/18/2022 3,000,000.00 $2,898,510.00 $36,762.30 $2,935,272.30 Activity Total 8,000,000.00 $7,688,810.00 $103,873.41 $7,792,683.41 22 Bond Interest Received Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 11/30/2022
Bond Interest Received
Accounting ID Transaction Type Cusip Description Date Posted Cash Interest Received Purchased Interest Adjustment Net Interest 4318 Interest Income 3135GA2Z3 FNMA 0.560 11/17/2025 11/17/2022 $8,400.00 $8,400.00 4327 Interest Income 3130AMDL3 FHLB 0.800 07/25/2025 11/25/2022 $20,000.00 $20,000.00 4328 Interest Income 3130AMJN3 FHLB 1.030 05/26/2026 11/28/2022 $25,750.00 $25,750.00 4285 Interest Income 3130AFWX1 FHLB 2.550 05/30/2023 11/30/2022 $63,750.00 $63,750.00 Activity Total $117,900.00 $0.00 $117,900.00
23 Statement of Cash Receipts and Disbursements and
Cash Receipts and Disbursements October 2022 November 2022 Receipts
General Fund
Property Tax 440,651 $ 13,932,088$
Local Sales Tax 4,402,273 4,134,068
Public Safety Sales Tax 231,794 241,265
Transient Occupancy Tax (TOT) 1,737,764 1,554,091 Utility Users Tax (UUT) 1,991,253 1,773,734 Other Revenue 3,747,691 7,108,845
Total General Fund Revenue 12,551,426 28,744,092 Total All Other Funds Revenue 11,323,268 23,245,292 Total Receipts 23,874,694$ 51,989,384 $
Disbursements
General Fund
Personnel Services (11,068,897) (10,628,635)
Operating Expenses (2,746,380) (4,631,674)
Capital Expenditures (222) ‐
Non‐Operating Expenses (70,142) (1,115)
Total General Fund Disbursements (13,885,641) (15,261,424) Total All Other Funds Disbursements (17,864,856) (19,944,033) Total Disbursements (31,750,497) (35,205,456)
Net Change in Cash Flow (7,875,803)$ 16,783,928$ Summary of Cash by Fund October 2022 November 2022
General Fund 69,410,947$ 82,893,615$
General Fund Other 3,230,629 3,263,028 Capital Projects Funds 30,764,567 28,964,429 Debt Service Funds 23,131,836 24,584,593
Enterprise Funds 82,397,405 85,567,084
Trust and Agency Funds 5,181,101 5,989,025 Internal Service Funds 30,475,469 30,855,028 Special Revenue Funds 64,503,530 63,762,611 General Ledger Cash Balances * 309,095,485$ 325,879,412$ 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
Finance Department
November 2022
24 Par Value Book Value Book Value % of
Port Market Value Book Yield
Contribution Days to Maturity
Local Govt Inv Pools (LGIP)
Commerical Paper
U.S. Treasuries
Supranational
U.S. Agencies
Corporate MTN
Hold
Total
$16,035,359.49 $16,035,359.49 5.31% $16,035,359.49 0.167% 1 $5,000,000.00 $4,851,048.61 1.61% $4,824,250.00 0.074% 241 $78,000,000.00 $77,916,031.58 25.81% $73,234,670.00 0.353% 732 $29,000,000.00 $29,073,931.94 9.63% $26,902,230.00 0.108% 768 $139,225,000.00 $139,231,659.57 46.12% $128,723,634.25 0.628% 826 $34,684,000.00 $34,800,482.78 11.53% $33,476,548.94 0.231% 629 $301,944,359.49 $301,908,513.97 100.00% $283,196,692.68 1.560% 720 Portfolio Investments
10/31/2022
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 February 1, 2022. 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 1
Total Activity 2
Period Transactions
Redemptions 6
Purchases 4
Total Activity 10
Net Period Earnings $1,354,816.90
Last FY Period Net Earnings $783,380.74
Avg Daily Book Balance $309,456,077.43
$1.00 $1.00
Net Effective Annual Return 1.305%
Net Period Earnings $403,240.70
Avg Daily Book Balance $305,467,931.19
$1.00 $1.00
Net Effective Annual Return 1.565%
Fiscal YTD Summary (123 Days)Period Earnings Summary (31 Days) ______________________________________________ ____________________________ Portfolio Market Value
Accrued Interest Paid at
Purchase
Accrued Interest Earned
sum2
Total Market Value
$283,196,692.68
$22,451.39
$1,074,982.33
$1.00
$284,294,126.40
Portfolio Book Value
Accrued Interest Paid at
Purchase
sum2
Total Book Value
$301,908,513.97
$22,451.39
$2.00
$301,930,965.36
Market Value
Book Value
Par Value
Portfolio Summary
Huntington Beach
Portfolio: CITY
Reporting Date: (FY2023)
10/01/2022 - 10/31/2022
Full Accrual Basis
sum2
Total Par Value
$1.00
$301,944,359.49
____________________________________________
The City Portfolio uses a 12 month moving average of the 1.5Yr Treasury for comparison purposes. This period, that rate is equal to: 2.190% AB
25 Accounting ID Pool Description Type Par Value Book Value Market Value Rate % of Portfolio Composite Rating 001
Orange County Pool
LGIP
6,785.12
6,785.12
6,785.12
1.85 0.00%
NR
003
California Asset Management Program
LGIP
16,028,574.37
16,028,574.37
16,028,574.37
3.14 5.31%
NR
CITY Fund Total 16,035,359.49 16,035,359.49 16,035,359.49 5.31% Portfolio: CITYCash By Fund Report
City of Huntington Beach
Reporting Period:
10/31/2022
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.66Yr-Disco) 10/05/2022 5,000,000.00 4,851,048.61 4,824,250.00 4.602 0.66 241 1.61% P-1/A-1/F1 Commercial Paper Total 5,000,000.00 4,851,048.61 4,824,250.00 1.61% 4299 912828P79 T 1.500 02/28/2023 (0.33Yr-Fixed) 12/05/2019 3,000,000.00 2,999,291.52 2,973,300.00 1.574 0.32 119 0.99% Aaa/AA+/AAA 4352 912828S92 T 1.250 07/31/2023 (0.74Yr-Fixed) 01/14/2022 5,000,000.00 5,020,001.42 4,875,000.00 0.711 0.73 272 1.66% Aaa/AA+/AAA 4357 91282CCN9 T 0.125 07/31/2023 (0.74Yr-Fixed) 02/02/2022 5,000,000.00 4,967,968.75 4,834,400.00 0.991 0.73 272 1.65% Aaa/AA+/AAA 4354 9128282D1 T 1.375 08/31/2023 (0.83Yr-Fixed) 01/21/2022 5,000,000.00 5,019,356.90 4,866,600.00 0.903 0.81 303 1.66% Aaa/AA+/AAA 4364 9128286Z8 T 1.750 06/30/2024 (1.66Yr-Fixed) 05/02/2022 7,000,000.00 6,889,902.49 6,680,380.00 2.730 1.60 607 2.28% Aaa/AA+/AAA 4370 912828XX3 T 2.000 06/30/2024 (1.66Yr-Fixed) 05/27/2022 5,000,000.00 4,962,806.37 4,791,200.00 2.462 1.60 607 1.64% Aaa/AA+/AAA 4353 912828Y87 T 1.750 07/31/2024 (1.75Yr-Fixed) 01/14/2022 5,000,000.00 5,062,151.78 4,761,550.00 1.028 1.68 638 1.68% Aaa/AA+/AAA 4358 912828Y87 T 1.750 07/31/2024 (1.75Yr-Fixed) 02/11/2022 4,000,000.00 4,010,564.88 3,809,240.00 1.595 1.68 638 1.33% Aaa/AA+/AAA 4361 912828D56 T 2.375 08/15/2024 (1.79Yr-Fixed) 03/22/2022 5,000,000.00 5,011,634.12 4,808,200.00 2.240 1.72 653 1.66% Aaa/AA+/AAA 4298 912828YH7 T 1.500 09/30/2024 (1.91Yr-Fixed) 12/05/2019 5,000,000.00 4,991,267.46 4,724,800.00 1.595 1.85 699 1.65% Aaa/AA+/AAA 4350 912828YM6 T 1.500 10/31/2024 (2.00Yr-Fixed) 12/31/2021 3,000,000.00 3,034,214.78 2,828,670.00 0.920 1.93 730 1.01% Aaa/AA+/AAA 4330 91282CAB7 T 0.250 07/31/2025 (2.75Yr-Fixed) 05/19/2021 5,000,000.00 4,950,569.23 4,464,850.00 0.615 2.68 1,003 1.64% Aaa/AA+/AAA 4340 91282CAJ0 T 0.250 08/31/2025 (2.83Yr-Fixed) 09/27/2021 5,000,000.00 4,932,400.63 4,447,450.00 0.735 2.76 1,034 1.63% Aaa/AA+/AAA 4351 9128284Z0 T 2.750 08/31/2025 (2.83Yr-Fixed) 12/31/2021 5,000,000.00 5,227,649.89 4,774,200.00 1.103 2.67 1,034 1.73% Aaa/AA+/AAA 4341 91282CCP4 T 0.625 07/31/2026 (3.75Yr-Fixed) 09/30/2021 5,000,000.00 4,940,621.51 4,356,050.00 0.950 3.61 1,368 1.64% Aaa/AA+/AAA 4339 91282CCW9 T 0.750 08/31/2026 (3.83Yr-Fixed) 09/23/2021 1,000,000.00 994,762.48 873,130.00 0.890 3.69 1,399 0.33% Aaa/AA+/AAA 4342 91282CCW9 T 0.750 08/31/2026 (3.83Yr-Fixed) 11/23/2021 5,000,000.00 4,900,867.36 4,365,650.00 1.285 3.69 1,399 1.62% Aaa/AA+/AAA U.S. Treasuries Total 78,000,000.00 77,916,031.58 73,234,670.00 25.81% 4290 45818WBX3 IADB 2.870 07/20/2023 (0.71Yr-Fixed) 03/28/2019 4,000,000.00 4,016,341.03 3,950,680.00 2.270 0.69 261 1.33% Aaa/AAA/AAA 4291 45818WBY1 IADB 2.960 08/16/2023 (0.79Yr-Fixed) 03/28/2019 5,000,000.00 5,025,817.97 4,934,700.00 2.271 0.77 288 1.66% Aaa/AAA/AAA 4323 459056HV2 IBRD 1.500 08/28/2024 (1.82Yr-Fixed) 04/23/2021 5,000,000.00 5,097,268.71 4,730,600.00 0.425 1.76 666 1.69% Aaa/AAA/AAA 4338 459058JE4 IBRD 0.375 07/28/2025 (2.74Yr-Fixed) 07/30/2021 5,000,000.00 4,971,858.83 4,464,800.00 0.583 2.66 1,000 1.65% Aaa/AAA/AAA 4319 459058JL8 IBRD 0.500 10/28/2025 (2.99Yr-Fixed) 01/12/2021 5,000,000.00 4,998,284.04 4,435,150.00 0.512 2.90 1,092 1.66% Aaa/AAA/AAA 4324 45906M2L4 IBRD 0.650 02/24/2026 (3.32YrNC0.79Mo-Dq-Fixed) 04/30/2021 5,000,000.00 4,964,361.36 4,386,300.00 0.870 3.20 1,211 1.64% Aaa/AAA/AAA Supranational Total 29,000,000.00 29,073,931.94 26,902,230.00 9.63% 4285 3130AFWX1 FHLB 2.550 05/30/2023 (0.57Yr-Fixed) 02/26/2019 5,000,000.00 5,000,000.00 4,944,450.00 2.550 0.56 210 1.66% Aaa/AA+/NR 4281 313383QR5 FHLB 3.250 06/09/2023 (0.60Yr-Fixed) 12/20/2018 5,000,000.00 5,014,361.72 4,956,500.00 2.743 0.58 220 1.66% Aaa/AA+/NR 4368 313383MD0 FHLB 2.625 06/09/2023 (0.60Yr-Fixed) 05/09/2022 7,000,000.00 7,017,607.69 6,913,620.00 2.201 0.58 220 2.32% Aaa/AA+/NR 4287 3137EAEN5 FHLMC 2.750 06/19/2023 (0.63Yr-Fixed) 03/08/2019 3,000,000.00 3,005,370.80 2,964,450.00 2.450 0.61 230 1.00% Aaa/AA+/AAA 4288
3137EAEN5
FHLMC 2.750 06/19/2023 (0.63Yr-Fixed)
03/14/2019
3,000,000.00
3,005,610.14
2,964,450.00
2.437
0.61 230
1.00%
Aaa/AA+/AAA
4289 3135G0U43 FNMA 2.875 09/12/2023 (0.86Yr-Fixed) 03/15/2019 5,000,000.00 5,016,655.91 4,921,450.00 2.465 0.84 315 1.66% Aaa/AA+/AAA 4292 3133ECHX5 FFCB 2.260 03/13/2024 (1.36Yr-Fixed) 05/23/2019 5,000,000.00 5,001,535.72 4,837,650.00 2.236 1.32 498 1.66% Aaa/AA+/AAA 4348 3130AQD42 FHLB 0.920 06/28/2024 (1.66YrNC1.91Mo-Dq-Fixed) 12/28/2021 5,000,000.00 5,000,000.00 4,683,700.00 0.920 1.61 605 1.66% Aaa/AA+/NR 4344 3130AQ3C5 FHLB 1.000 08/28/2024 (1.82YrNC0.92Mo-Dq-Fixed) 12/02/2021 4,000,000.00 4,000,000.00 3,729,880.00 1.000 1.77 666 1.32% Aaa/AA+/NR 4373 3133XVDG3 FHLB 4.375 09/13/2024 (1.87Yr-Fixed) 09/23/2022 5,000,000.00 5,011,878.31 4,977,850.00 4.240 1.77 682 1.66% Aaa/AA+/NR 4336 3130AMXJ6 FHLB 0.500 09/30/2024 (1.91YrNC1.97Mo-Dq-Fixed) 06/30/2021 5,000,000.00 5,000,000.00 4,602,550.00 0.500 1.86 699 1.66% Aaa/AA+/NR 4346 3130AQD59 FHLB 1.000 09/30/2024 (1.91YrNC1.97Mo-Dq-Fixed) 12/30/2021 5,000,000.00 5,000,000.00 4,667,100.00 1.000 1.85 699 1.66% Aaa/AA+/NR 4349 3130AQD59 FHLB 1.000 09/30/2024 (1.91YrNC1.97Mo-Dq-Fixed) 12/30/2021 5,000,000.00 5,000,000.00 4,667,100.00 1.000 1.85 699 1.66% Aaa/AA+/NR 4334 3130AMW65 FHLB 0.500 12/30/2024 (2.16YrNC1.97Mo-Dq-Fixed) 06/30/2021 5,000,000.00 5,000,000.00 4,556,300.00 0.500 2.10 790 1.66% Aaa/AA+/NR Portfolio: CITYSecurities By Structure Report
City of Huntington Beach
Reporting Period:
10/31/2022
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
4332 3130AMQ62 FHLB 0.625 03/14/2025 (2.37YrNC1.45Mo-Dq-Fixed) 06/14/2021 5,000,000.00 5,000,000.00 4,533,000.00 0.625 2.30 864 1.66% Aaa/AA+/NR 4329 3135G04Z3 FNMA 0.500 06/17/2025 (2.63Yr-Fixed) 05/14/2021 5,000,000.00 4,983,398.44 4,508,950.00 0.628 2.55 959 1.65% Aaa/AA+/AAA 4345 3130AQ5S8 FHLB 1.250 06/30/2025 (2.66YrNC1.97Mo-Dq-Fixed) 12/30/2021 4,650,000.00 4,650,000.00 4,239,312.00 1.250 2.55 972 1.54% Aaa/AA+/NR 4327 3130AMDL3 FHLB 0.800 07/25/2025 (2.73YrNC0.82Mo-Dq-Fixed) 05/25/2021 5,000,000.00 5,000,000.00 4,491,650.00 0.800 2.63 997 1.66% Aaa/AA+/NR 4360 3130AQT94 FHLB 1.600 08/28/2025 (2.82YrNC3.94Mo-1x-Fixed) 03/04/2022 4,575,000.00 4,548,099.99 4,191,752.25 1.816 2.70 1,031 1.51% Aaa/AA+/NR 4331 3130AMQ54 FHLB 0.700 09/16/2025 (2.87YrNC10.51Mo-Da-Fixed) 06/16/2021 5,000,000.00 5,000,000.00 4,454,800.00 0.700 2.78 1,050 1.66% Aaa/AA+/NR 4318 3135GA2Z3 FNMA 0.560 11/17/2025 (3.04YrNC0.56Mo-Da-Fixed) 01/11/2021 3,000,000.00 3,002,071.48 2,648,370.00 0.500 2.94 1,112 0.99% Aaa/AA+/AAA 4320 3130AKN36 FHLB 0.525 01/15/2026 (3.21YrNC2.50Mo-Dq-Fixed) 01/15/2021 5,000,000.00 4,996,794.44 4,375,200.00 0.545 3.10 1,171 1.66% Aaa/AA+/NR 4321 3130AKN85 FHLB 0.550 01/20/2026 (3.22YrNC2.66Mo-Dq-Fixed) 01/20/2021 5,000,000.00 4,998,390.28 4,376,700.00 0.560 3.11 1,176 1.66% Aaa/AA+/NR 4322 3130AKUS3 FHLB 0.500 01/28/2026 (3.24YrNC2.92Mo-Dq-Fixed) 01/28/2021 5,000,000.00 5,000,000.00 4,365,950.00 0.500 3.14 1,184 1.66% Aaa/AA+/NR 4333 3130ALEY6 FHLB 0.800 03/04/2026 (3.34YrNC1.12Mo-Dq-Fixed) 06/10/2021 5,000,000.00 5,000,000.00 4,395,300.00 0.800 3.21 1,219 1.66% Aaa/AA+/NR 4328 3130AMJN3 FHLB 1.030 05/26/2026 (3.56YrNC0.85Mo-Dq-Fixed) 05/26/2021 5,000,000.00 5,000,000.00 4,403,850.00 1.030 3.40 1,302 1.66% Aaa/AA+/NR 4335 3130AMFS6 FHLB 0.750 06/12/2026 (3.61Yr-Fixed) 06/17/2021 5,000,000.00 4,978,256.27 4,389,600.00 0.873 3.47 1,319 1.65% Aaa/AA+/NR 4347 3130AQ7E7 FHLB 1.500 06/30/2026 (3.66YrNC1.97Mo-Dq-Fixed) 12/30/2021 5,000,000.00 5,001,628.40 4,461,050.00 1.339 3.46 1,337 1.66% Aaa/AA+/NR 4356 3130AQS79 FHLB 1.375 08/07/2026 (3.76YrNC21.22Mo-1x-Step) 02/07/2022 5,000,000.00 5,000,000.00 4,501,100.00 1.375 3.51 1,375 1.66% Aaa/AA+/NR U.S. Agencies Total 139,225,000.00 139,231,659.57 128,723,634.25 46.12% 4313 037833DE7 AAPL 2.400 01/13/2023 (0.20YrNC1.41Mo-Cc-Fixed) 04/29/2020 5,000,000.00 5,016,100.21 4,980,650.00 0.720 0.20 73 1.66% Aaa/AA+/NR 4306 90331HNV1 USB 3.400 07/24/2023 (0.73YrNC7.72Mo-Cc-Fixed) 02/21/2020 2,000,000.00 2,023,851.31 1,975,760.00 1.671 0.70 265 0.67% A1/AA-/A1 4300 254687CR5 DIS 4.000 10/01/2023 (0.91Yr-Fixed) 12/16/2019 2,875,000.00 2,923,653.85 2,848,550.00 2.070 0.89 334 0.97% A2/BBB+/A- 4355 67066GAL8 NVDA 0.584 06/14/2024 (1.62YrNC7.43Mo-Cc-Fixed) 01/24/2022 5,000,000.00 4,947,021.57 4,664,650.00 1.250 1.57 591 1.64% A2/A/ 4325 91159HHX1 USB 2.400 07/30/2024 (1.74YrNC19.91Mo-Cc-Fixed) 04/30/2021 3,809,000.00 3,928,997.82 3,640,108.94 0.528 1.67 637 1.30% A2/A+/A+ 4343 14913R2P1 CAT 0.600 09/13/2024 (1.87Yr-Fixed) 12/02/2021 5,000,000.00 4,965,057.34 4,617,150.00 0.980 1.82 682 1.64% A2/A/A 4371 459200KS9 IBM 4.000 07/27/2025 (2.74Yr-Fixed) 08/11/2022 6,000,000.00 6,029,136.02 5,854,380.00 3.810 2.53 999 2.00% A3/A-/ 4372 931142EW9 WMT 3.900 09/09/2025 (2.86Yr-Fixed) 09/22/2022 5,000,000.00 4,966,664.67 4,895,300.00 4.150 2.65 1,043 1.65% Aa2/AA/AA Corporate MTN Total 34,684,000.00 34,800,482.78 33,476,548.94 11.53% Holdings Total 285,909,000.00 285,873,154.48 267,161,333.19 94.69% Portfolio: CITYSecurities By Structure Report
City of Huntington Beach
Reporting Period:
10/31/2022
28 Cash/Money Market/LGIP Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 10/31/2022
Cash/Money Market Account Activity
Accounting ID Description Activity Date Transaction Type Transaction Amount 001 Orange County Pool 10/03/2022 Admin Fee ($7.30)
001 Orange County Pool 10/12/2022 Withdrawal ($6,641.87) 001 Orange County Pool 10/26/2022 Interest Received $6,785.12 Activity Total $135.95
003 California Asset Management Program 10/03/2022 Interest Received $29,119.85 003 California Asset Management Program 10/12/2022 Withdrawal ($1,000.00) 003 California Asset Management Program 10/21/2022 Withdrawal ($3,000,000.00) Activity Total ($2,971,880.15)
982 LAIF 10/14/2022 Interest Received $68,435.64
982 LAIF 10/17/2022 Withdrawal ($3,788,493.41)
Activity Total ($3,720,057.77)
29 Redemption Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 10/31/2022
Redemption Transactions
Accounting ID Transaction
Type Cusip Description Price Settlement
Date Posted Date Par Value Principal Accrued Interest Total 4363 Maturity 62479MK36 MUFGBK 0.000 10/03/2022 100.00000 10/03/2022 10/03/2022 $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 30 Purchase Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 10/31/2022
Purchase Transactions
Accounting ID Transaction
Type Cusip Description Price Settlement
Date Posted Date Par Value Principal Accrued Interest Total 4374 Buy 62479MTW3 MUFGBK 0.000 06/30/2023 96.68722 10/05/2022 10/05/2022 5,000,000.00 $4,834,361.11 $0.00 $4,834,361.11 Activity Total 5,000,000.00 $4,834,361.11 $0.00 $4,834,361.11 31 Bond Interest Received Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 10/31/2022
Bond Interest Received
Accounting ID Transaction Type Cusip Description Date Posted Cash Interest Received Purchased Interest Adjustment Net Interest 4300 Interest Income 254687CR5 DIS 4.000 10/01/2023 10/03/2022 $57,500.00 $57,500.00 4319 Interest Income 459058JL8 IBRD 0.500 10/28/2025 10/28/2022 $12,500.00 $12,500.00 4350 Interest Income 912828YM6 T 1.500 10/31/2024 10/31/2022 $22,500.00 $22,500.00 Activity Total $92,500.00 $0.00 $92,500.00
32 Statement of Cash Receipts and Disbursements and
Cash Receipts and Disbursements September 2022 October 2022 Receipts
General Fund
Property Tax 1,068,070 $ 440,651 $
Local Sales Tax 4,187,866 4,402,273
Public Safety Sales Tax 245,526 231,794
Transient Occupancy Tax (TOT) 1,817,586 1,737,764 Utility Users Tax (UUT) 1,935,246 1,991,253 Other Revenue 4,834,163 3,747,691
Total General Fund Revenue 14,088,457 12,551,426
Total All Other Funds Revenue 20,272,775 11,323,268
Total Receipts 34,361,232$ 23,874,694$
Disbursements
General Fund
Personnel Services (10,165,158) (11,068,897)
Operating Expenses (4,949,218) (2,746,380)
Capital Expenditures (176) (222)
Non‐Operating Expenses (4,208) (70,142)
Total General Fund Disbursements (15,118,761) (13,885,641) Total All Other Funds Disbursements (18,454,372) (17,864,856) Total Disbursements (33,573,133) (31,750,497)
Net Change in Cash Flow 788,099$ (7,875,803)$
Summary of Cash by Fund September 2022 October 2022
General Fund 70,137,007$ 68,802,792$
General Fund Other 6,430,278 3,229,834 Capital Projects Funds 33,730,578 30,751,189
Debt Service Funds 23,257,914 23,123,707
Enterprise Funds 80,157,399 82,354,355
Trust and Agency Funds 5,745,625 5,178,840 Internal Service Funds 31,219,568 30,462,392
Special Revenue Funds 65,594,486 64,493,944
General Ledger Cash Balances * 316,272,855$ 308,397,052$ 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
Finance Department
October 2022
33