1 City of Huntington Beach
Quarterly Investment Report
March 2023
Prepared by:
Alisa Backstrom, MBA, CCMT, CPFIM
City Treasurer
Colin Stevens, MPP
Treasury Associate
2 INVESTMENT PORTFOLIO SUMMARY
As of March 31, 2022
Currently, funds within this portfolio with overnight availability are invested in the California Asset Management Program “CAMP”. The CAMP account is considered a “Local Government Investment Pool” or “LGIP” for reporting purposes above. Other funds are invested in commercial paper, 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 allowed 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 q uarter of 2023. At the most recent March 2023 meeting, the FOMC raised the target range for the federal funds rate to 4-3/4 to 5 percent. Over the last year, the Fed has significantly moved the target rate off the 0% level that it had maintained for two years. 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 lower than the book value, at $326.9 million versus $340.1 million, respectively. As investments are primarily held to maturity, the market value is only a point-in-time measurement and no loss is realized. The increasing interest rates will allow excess funds to be invested at higher rates resulting in increased interest income in the future.
3 PORTFOLIO BREAKOUT BY SECTOR
As of March 31, 2023
The largest holding by security type at month-end was U.S. Agency securities at approximately 49% of the total overall portfolio. This was followed by U.S. Treasur y securities at approximately 24% of the total portfolio as of March 31, 2023. Cash held in the Local Government Investment Pools (“LGIP”) has been reduced as higher interest rates have become available in marketable securities.
INVESTMENT PORTFOLIO EARNINGS
As of March 31, 2023
4 Earnings for the month of March 2023 were $574,351 , an increase of approximately 77% from the same month in the prior year. Fiscal year to date earnings of $3,875,960 were up approximately 56% from the previous fiscal year. These higher earnings were due to both the increase in interest rates and the higher average balance of the portfolio . The effective rate of return for March was 1.99%, with a fiscal year-to-date return of 1.62%. The increase in the March rate of 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 ris e in interest rates through 2022 and the first part 2023. At the end of March, the 12-month moving average of the interpolated 1.5-year U.S. Treasury was 3.63%. The portfolio will lag behind the benchmark, as it will take time for previously purchased securities to mature and for funds to be reinvested.
QUARTERLY PORTFOLIO ACTIVITY
January 1 to March 31, 2023
As the Federal Reserve continued to raise rates in the first quarter of the year , available funds were invested into higher yielding options. For the quarter ending March 31, 2023, four U.S. Agencies were purchased totaling $20 million and one $5 million corporate bond (Pfizer Inc.) was purchased. One $5 million corporate bond matured, and one $3 million U.S. Treasury matured. Looking forward, additional funds will become available to invest as the property taxes are received by the City in April.
Investment Type
$ in $000's
Purchases/
Deposits
Maturities/
Withdrawals
Local Gov't Investment Pools 13,194$ 15,003$
Commercial Paper -$ -$
U.S. Treasuries -$ 3,000$
Supranationals -$ -$
U.S. Agencies 20,000$ -$
Corporates 5,000$ 5,000$
Total 38,194$ 23,003$
(Includes Interest Income)
5 COMPLIANCE SUMMARY
As of March 31, 2023
There were no compliance issues during this period.
ECONOMIC AND MARKET OVERVIEW
6 The Federal Open Market Committee (FOMC) met in March to discuss the current state of the economy and to examine potential future interest rate adjustments. They concluded that recent indicators point to modest gr owth in spending and production. In addition, the Committee anticipates that some additional pol icy firming may be appropriate in order to attain a stance of monetary policy that is sufficiently restrictive to return inflation to their goal of 2 percent.
Short-term interest rates rose in the first half of the quarter and began to drop in March after the banking issues emerged. The 2- year U.S. Treasury peaked at 5.05% on March 8, subsequently dropped to
3.76% in the following two weeks, and ultimately finis hed the quarter at 4.06%. This rapid fall in rates during this time was likely attributable to investors choosing to allocate money into bonds as a flight to safety after the news of the bank failures emerged.
Fixed Income / Equity Markets
: The yield on the 10-year U.S. Treasury finished the quarter at 3.48%, down from 3.88% at the end of 2022. The S&P 500 increased by 7.03% while the DJIA increased by
0.38% respectively, over the same period.
Employment
: Total nonfarm payroll employment rose by 236,000 in March, and the unemployment rate was little changed at 3.5 percent. Notable job gains occurred in leisure and hospitality, government, professional and business services, and health care.
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
$17,318,030.49 $17,318,030.49 5.09% $17,318,030.49 0.244% 1 $5,000,000.00 $4,944,375.00 1.45% $4,936,950.00 0.067% 90 $83,000,000.00 $82,695,606.21 24.31% $79,462,570.00 0.394% 668 $29,000,000.00 $29,037,668.89 8.54% $27,461,340.00 0.095% 618 $167,225,000.00 $166,765,787.88 49.03% $159,180,017.00 0.921% 656 $39,684,000.00 $39,350,021.87 11.57% $38,546,242.43 0.316% 717 $341,227,030.49 $340,111,490.34 100.00% $326,905,149.92 2.038% 621 Portfolio Investments
03/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 0
Purchases 0
Total Activity 0
Period Transactions
Redemptions 8
Purchases 14
Total Activity 22
Net Period Earnings $3,875,960.38
Last FY Period Net Earnings $2,201,914.13
Avg Daily Book Balance $319,315,098.55
$1.00 $1.00
Net Effective Annual Return 1.620%
Net Period Earnings $574,350.72
Last FY Period Net Earnings $324,815.16
Avg Daily Book Balance $342,511,229.73
$1.00 $1.00
Net Effective Annual Return 1.992%
Fiscal YTD Summary (274 Days)Period Earnings Summary (31 Days) ______________________________________________ ____________________________ Portfolio Market Value
Accrued Interest Paid at
Purchase
sum2
Total Market Value
$326,905,149.92
$53,524.31
$1.00
$326,958,674.23
Portfolio Book Value
Accrued Interest Paid at
Purchase
sum2
Total Book Value
$340,111,490.34
$53,524.31
$2.00
$340,165,014.65
Market Value
Book Value
Par Value
Portfolio Summary
Huntington Beach
Portfolio: CITY
Reporting Date: (FY2023)
03/01/2023 - 03/31/2023
Full Accrual Basis
sum2
Total Par Value
$1.00
$341,227,030.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: 3.630% ____________________________________________
7 Accounting ID Pool Description Type Par Value Book Value Market Value Rate % of Portfolio Composite Rating 003
California Asset Management Program
LGIP
17,318,030.49
17,318,030.49
17,318,030.49
4.80 5.09%
NR
CITY Fund Total 17,318,030.49 17,318,030.49 17,318,030.49 5.09% Portfolio: CITYCash By Fund Report
City of Huntington Beach
Reporting Period:
03/31/2023
Page: 1 Report Run Date: Apr 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
4374 62479MTW3 MUFGBK 0.000 06/30/2023 (0.25Yr-Disco) 10/05/2022 5,000,000.00 4,944,375.00 4,936,950.00 4.602 0.25 90 1.45% P-1/A-1/F1 Commercial Paper Total 5,000,000.00 4,944,375.00 4,936,950.00 1.45% 4352 912828S92 T 1.250 07/31/2023 (0.33Yr-Fixed) 01/14/2022 5,000,000.00 5,008,897.69 4,942,200.00 0.711 0.33 121 1.47% Aaa/AA+/AAA 4357 91282CCN9 T 0.125 07/31/2023 (0.33Yr-Fixed) 02/02/2022 5,000,000.00 4,985,750.80 4,924,400.00 0.991 0.33 121 1.47% Aaa/AA+/AAA 4354 9128282D1 T 1.375 08/31/2023 (0.42Yr-Fixed) 01/21/2022 5,000,000.00 5,009,710.39 4,931,450.00 0.903 0.41 152 1.47% Aaa/AA+/AAA 4364 9128286Z8 T 1.750 06/30/2024 (1.25Yr-Fixed) 05/02/2022 7,000,000.00 6,917,290.84 6,773,060.00 2.730 1.21 456 2.03% Aaa/AA+/AAA 4370 912828XX3 T 2.000 06/30/2024 (1.25Yr-Fixed) 05/27/2022 5,000,000.00 4,972,058.82 4,851,550.00 2.462 1.21 456 1.46% Aaa/AA+/AAA 4353 912828Y87 T 1.750 07/31/2024 (1.33Yr-Fixed) 01/14/2022 5,000,000.00 5,047,441.87 4,828,900.00 1.028 1.29 487 1.48% Aaa/AA+/AAA 4358 912828Y87 T 1.750 07/31/2024 (1.33Yr-Fixed) 02/11/2022 4,000,000.00 4,008,064.42 3,863,120.00 1.595 1.29 487 1.18% Aaa/AA+/AAA 4361 912828D56 T 2.375 08/15/2024 (1.37Yr-Fixed) 03/22/2022 5,000,000.00 5,008,943.84 4,866,800.00 2.240 1.33 502 1.47% Aaa/AA+/AAA 4298 912828YH7 T 1.500 09/30/2024 (1.50Yr-Fixed) 12/05/2019 5,000,000.00 4,993,153.89 4,797,450.00 1.595 1.46 548 1.47% Aaa/AA+/AAA 4350 912828YM6 T 1.500 10/31/2024 (1.59Yr-Fixed) 12/31/2021 3,000,000.00 3,027,137.48 2,873,910.00 0.920 1.53 579 0.89% Aaa/AA+/AAA 4376 91282CEU1 T 2.875 06/15/2025 (2.21Yr-Fixed) 11/18/2022 3,000,000.00 2,912,977.72 2,929,230.00 4.276 2.09 806 0.86% Aaa/AA+/AAA 4330 91282CAB7 T 0.250 07/31/2025 (2.33Yr-Fixed) 05/19/2021 5,000,000.00 4,958,010.95 4,591,600.00 0.615 2.27 852 1.46% Aaa/AA+/AAA 4340 91282CAJ0 T 0.250 08/31/2025 (2.42Yr-Fixed) 09/27/2021 5,000,000.00 4,942,272.49 4,580,300.00 0.735 2.36 883 1.45% Aaa/AA+/AAA 4351 9128284Z0 T 2.750 08/31/2025 (2.42Yr-Fixed) 12/31/2021 5,000,000.00 5,194,405.08 4,862,300.00 1.103 2.30 883 1.53% Aaa/AA+/AAA 4341 91282CCP4 T 0.625 07/31/2026 (3.33Yr-Fixed) 09/30/2021 5,000,000.00 4,947,175.72 4,510,150.00 0.950 3.22 1,217 1.45% Aaa/AA+/AAA 4339 91282CCW9 T 0.750 08/31/2026 (3.42Yr-Fixed) 09/23/2021 1,000,000.00 995,327.79 903,750.00 0.890 3.30 1,248 0.29% Aaa/AA+/AAA 4342 91282CCW9 T 0.750 08/31/2026 (3.42Yr-Fixed) 11/23/2021 5,000,000.00 4,911,567.16 4,518,750.00 1.285 3.30 1,248 1.44% Aaa/AA+/AAA 4379 91282CEW7 T 3.250 06/30/2027 (4.25Yr-Fixed) 12/29/2022 5,000,000.00 4,855,419.25 4,913,650.00 4.000 3.87 1,551 1.43% Aaa/AA+/AAA U.S. Treasuries Total 83,000,000.00 82,695,606.21 79,462,570.00 24.31% 4290 45818WBX3 IADB 2.870 07/20/2023 (0.30Yr-Fixed) 03/28/2019 4,000,000.00 4,006,877.11 3,973,240.00 2.270 0.30 110 1.18% Aaa/AAA/AAA 4291 45818WBY1 IADB 2.960 08/16/2023 (0.38Yr-Fixed) 03/28/2019 5,000,000.00 5,012,229.56 4,959,850.00 2.271 0.37 137 1.47% Aaa/AAA/AAA 4323 459056HV2 IBRD 1.500 08/28/2024 (1.41Yr-Fixed) 04/23/2021 5,000,000.00 5,075,061.24 4,805,200.00 0.425 1.37 515 1.49% Aaa/AAA/AAA 4338 459058JE4 IBRD 0.376 07/28/2025 (2.32Yr-Fixed) 07/30/2021 5,000,000.00 4,976,135.61 4,602,300.00 0.583 2.26 849 1.46% Aaa/AAA/AAA 4319 459058JL8 IBRD 0.500 10/28/2025 (2.58Yr-Fixed) 01/12/2021 5,000,000.00 4,998,523.03 4,581,800.00 0.512 2.50 941 1.47% Aaa/AAA/AAA 4324 45906M2L4 IBRD 0.650 02/24/2026 (2.90YrNC1.77Mo-Dq-Fixed) 04/30/2021 5,000,000.00 4,968,842.33 4,538,950.00 0.870 2.81 1,060 1.46% Aaa/AAA/AAA Supranational Total 29,000,000.00 29,037,668.89 27,461,340.00 8.54% 4285 3130AFWX1 FHLB 2.550 05/30/2023 (0.16Yr-Fixed) 02/26/2019 5,000,000.00 5,000,000.00 4,982,200.00 2.550 0.16 59 1.47% Aaa/AA+/NR 4281 313383QR5 FHLB 3.250 06/09/2023 (0.19Yr-Fixed) 12/20/2018 5,000,000.00 5,004,479.80 4,986,550.00 2.743 0.19 69 1.47% Aaa/AA+/NR 4368 313383MD0 FHLB 2.625 06/09/2023 (0.19Yr-Fixed) 05/09/2022 7,000,000.00 7,005,492.31 6,968,010.00 2.201 0.19 69 2.06% Aaa/AA+/NR 4287
3137EAEN5
FHLMC 2.750 06/19/2023 (0.22Yr-Fixed)
03/08/2019
3,000,000.00
3,001,837.38
2,986,680.00
2.450
0.21 79
0.88%
Aaa/AA+/AAA
4288 3137EAEN5 FHLMC 2.750 06/19/2023 (0.22Yr-Fixed) 03/14/2019 3,000,000.00 3,001,919.26 2,986,680.00 2.437 0.21 79 0.88% Aaa/AA+/AAA 4383 3130AUHE7 FHLB 0.000 07/26/2023 (0.32Yr-Disco) 01/18/2023 5,000,000.00 5,001,749.47 5,001,400.00 4.755 0.31 116 1.47% Aaa/AA+/NR 4289 3135G0U43 FNMA 2.875 09/12/2023 (0.45Yr-Fixed) 03/15/2019 5,000,000.00 5,008,622.51 4,954,850.00 2.465 0.44 164 1.47% Aaa/AA+/AAA 4377 313384ND7 FHDN 0.000 10/19/2023 (0.55Yr-Disco) 12/05/2022 3,000,000.00 2,922,866.25 2,923,890.00 4.817 0.54 201 0.86% P-1/A-1+/NR 4292 3133ECHX5 FFCB 2.260 03/13/2024 (0.95Yr-Fixed) 05/23/2019 5,000,000.00 5,001,067.51 4,886,200.00 2.236 0.92 347 1.47% Aaa/AA+/AAA 4378 3130ATVC8 FHLB 4.875 06/14/2024 (1.20Yr-Fixed) 12/28/2022 5,000,000.00 5,007,202.95 5,018,450.00 4.740 1.14 440 1.47% Aaa/AA+/NR 4348 3130AQD42 FHLB 0.920 06/28/2024 (1.24YrNC2.92Mo-Dq-Fixed) 12/28/2021 5,000,000.00 5,000,000.00 4,773,850.00 0.920 1.21 454 1.47% Aaa/AA+/NR 4380 3134GYCP5 FHLMC 5.000 07/23/2024 (1.31YrNC6.77Mo-1x-Fixed) 01/23/2023 5,000,000.00 5,000,000.00 4,992,450.00 5.000 0.77 479 1.47% Aaa/AA+/AAA 4344 3130AQ3C5 FHLB 1.000 08/28/2024 (1.41YrNC1.91Mo-Dq-Fixed) 12/02/2021 4,000,000.00 4,000,000.00 3,807,200.00 1.000 1.37 515 1.18% Aaa/AA+/NR Portfolio: CITYSecurities By Structure Report
City of Huntington Beach
Reporting Period:
03/31/2023
Page: 1 Report Run Date: Apr 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
4373 3133XVDG3 FHLB 4.375 09/13/2024 (1.45Yr-Fixed) 09/23/2022 5,000,000.00 5,009,226.90 4,989,250.00 4.240 1.39 531 1.47% Aaa/AA+/NR 4336 3130AMXJ6 FHLB 0.500 09/30/2024 (1.50YrNC2.99Mo-Dq-Fixed) 06/30/2021 5,000,000.00 5,000,000.00 4,712,150.00 0.500 1.46 548 1.47% Aaa/AA+/NR 4346 3130AQD59 FHLB 1.000 09/30/2024 (1.50YrNC2.99Mo-Dq-Fixed) 12/30/2021 5,000,000.00 5,000,000.00 4,747,900.00 1.000 1.46 548 1.47% Aaa/AA+/NR 4349 3130AQD59 FHLB 1.000 09/30/2024 (1.50YrNC2.99Mo-Dq-Fixed) 12/30/2021 5,000,000.00 5,000,000.00 4,747,900.00 1.000 1.46 548 1.47% Aaa/AA+/NR 4334 3130AMW65 FHLB 0.500 12/30/2024 (1.75YrNC2.99Mo-Dq-Fixed) 06/30/2021 5,000,000.00 5,000,000.00 4,682,950.00 0.500 1.70 639 1.47% Aaa/AA+/NR 4332 3130AMQ62 FHLB 0.625 03/14/2025 (1.95YrNC2.46Mo-Dq-Fixed) 06/14/2021 5,000,000.00 5,000,000.00 4,661,300.00 0.625 1.90 713 1.47% Aaa/AA+/NR 4329 3135G04Z3 FNMA 0.500 06/17/2025 (2.21Yr-Fixed) 05/14/2021 5,000,000.00 4,986,030.82 4,620,550.00 0.628 2.15 808 1.47% Aaa/AA+/AAA 4381 3135G04Z3 FNMA 0.500 06/17/2025 (2.21Yr-Fixed) 01/13/2023 5,000,000.00 4,633,421.05 4,620,550.00 4.013 2.15 808 1.36% Aaa/AA+/AAA 4345 3130AQ5S8 FHLB 1.250 06/30/2025 (2.25YrNC2.99Mo-Dq-Fixed) 12/30/2021 4,650,000.00 4,650,000.00 4,364,908.50 1.250 2.16 821 1.37% Aaa/AA+/NR 4327 3130AMDL3 FHLB 0.800 07/25/2025 (2.32YrNC1.81Mo-Dq-Fixed) 05/25/2021 5,000,000.00 5,000,000.00 4,638,150.00 0.800 2.24 846 1.47% Aaa/AA+/NR 4360 3130AQT94 FHLB 1.600 08/28/2025 (2.41Yr-Fixed) 03/04/2022 4,575,000.00 4,552,067.54 4,305,898.50 1.816 2.31 880 1.34% Aaa/AA+/NR 4331 3130AMQ54 FHLB 0.700 09/16/2025 (2.46YrNC5.55Mo-Da-Fixed) 06/16/2021 5,000,000.00 5,000,000.00 4,608,400.00 0.700 2.39 899 1.47% Aaa/AA+/NR 4318 3135GA2Z3 FNMA 0.560 11/17/2025 (2.63YrNC7.59Mo-Da-Fixed) 01/11/2021 3,000,000.00 3,001,787.97 2,744,400.00 0.500 2.55 961 0.88% Aaa/AA+/AAA 4320 3130AKN36 FHLB 0.525 01/15/2026 (2.79YrNC0.49Mo-Dq-Fixed) 01/15/2021 5,000,000.00 4,997,211.11 4,532,800.00 0.545 2.71 1,020 1.47% Aaa/AA+/NR 4321 3130AKN85 FHLB 0.550 01/20/2026 (2.81YrNC0.66Mo-Dq-Fixed) 01/20/2021 5,000,000.00 4,998,598.61 4,534,400.00 0.560 2.72 1,025 1.47% Aaa/AA+/NR 4322 3130AKUS3 FHLB 0.500 01/28/2026 (2.83YrNC0.92Mo-Dq-Fixed) 01/28/2021 5,000,000.00 5,000,000.00 4,525,250.00 0.500 2.74 1,033 1.47% Aaa/AA+/NR 4333 3130ALEY6 FHLB 0.800 03/04/2026 (2.92YrNC2.14Mo-Dq-Fixed) 06/10/2021 5,000,000.00 5,000,000.00 4,548,000.00 0.800 2.82 1,068 1.47% Aaa/AA+/NR 4328 3130AMJN3 FHLB 1.030 05/26/2026 (3.15YrNC1.84Mo-Dq-Fixed) 05/26/2021 5,000,000.00 5,000,000.00 4,555,900.00 1.030 3.02 1,151 1.47% Aaa/AA+/NR 4335 3130AMFS6 FHLB 0.750 06/12/2026 (3.20Yr-Fixed) 06/17/2021 5,000,000.00 4,980,763.23 4,531,950.00 0.873 3.08 1,168 1.46% Aaa/AA+/NR 4347 3130AQ7E7 FHLB 1.500 06/30/2026 (3.25YrNC2.99Mo-Dq-Fixed) 12/30/2021 5,000,000.00 5,001,443.21 4,603,650.00 1.339 3.06 1,186 1.47% Aaa/AA+/NR 4384 3130AUMC5 FHLB 3.750 07/20/2026 (3.30Yr-Fixed) 01/19/2023 5,000,000.00 5,000,000.00 4,979,900.00 3.750 3.04 1,206 1.47% Aaa/AA+/NR 4356 3130AQS79 FHLB 1.375 08/07/2026 (3.35YrNC16.26Mo-1x-Step) 02/07/2022 5,000,000.00 5,000,000.00 4,655,450.00 1.375 2.97 1,224 1.47% Aaa/AA+/NR U.S. Agencies Total 167,225,000.00 166,765,787.88 159,180,017.00 49.03% 4306 90331HNV1 USB 3.400 07/24/2023 (0.31YrNC2.76Mo-Cc-Fixed) 02/21/2020 2,000,000.00 2,010,247.90 1,987,160.00 1.671 0.31 114 0.59% A1/AA-/A1 4300 254687CR5 DIS 4.000 10/01/2023 (0.50Yr-Fixed) 12/16/2019 2,875,000.00 2,901,538.46 2,856,945.00 2.070 0.48 183 0.85% A2/BBB+/A- 4355 67066GAL8 NVDA 0.584 06/14/2024 (1.20YrNC2.46Mo-Cc-Fixed) 01/24/2022 5,000,000.00 4,960,652.38 4,774,200.00 1.250 1.18 440 1.46% A2/A/ 4325 91159HHX1 USB 2.400 07/30/2024 (1.33YrNC14.95Mo-Cc-Fixed) 04/30/2021 3,809,000.00 3,900,381.49 3,661,477.43 0.528 1.28 486 1.15% A2/A+/A+ 4343 14913R2P1 CAT 0.600 09/13/2024 (1.45Yr-Fixed) 12/02/2021 5,000,000.00 4,972,857.04 4,726,400.00 0.980 1.42 531 1.46% A2/A/A 4371 459200KS9 IBM 4.000 07/27/2025 (2.32Yr-Fixed) 08/11/2022 6,000,000.00 6,024,703.56 5,932,260.00 3.810 2.17 848 1.77% A3/A-/ 4372
931142EW9
WMT 3.900 09/09/2025 (2.44Yr-Fixed)
09/22/2022
5,000,000.00
4,971,528.77
4,984,850.00
4.150
2.30 892
1.46%
Aa2/AA/AA
4382
717081DV2
PFE 2.750 06/03/2026 (3.17Yr-Fixed)
01/18/2023
5,000,000.00
4,795,849.88
4,791,000.00
4.142
2.96 1,159
1.41%
A1/A+/Au
4375
110122CN6
BMY 3.200 06/15/2026 (3.21YrNC36.50Mo-Cc-Fixed)
11/16/2022
5,000,000.00
4,812,262.37
4,831,950.00
4.480
2.93 1,171
1.41%
A2/A+/WD
Corporates Total 39,684,000.00 39,350,021.87 38,546,242.43 11.57% Holdings Total 323,909,000.00 322,793,459.85 309,587,119.43 94.91% Portfolio: CITYSecurities By Structure Report
City of Huntington Beach
Reporting Period:
03/31/2023
Page: 2 Report Run Date: Apr 11, 2023
10 Cash/Money Market/LGIP Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 03/31/2023
Cash/Money Market Account Activity
Accounting ID Description Activity Date Transaction Type Transaction Amount 003 California Asset Management Program 03/01/2023 Interest Received $51,900.60 003 California Asset Management Program 03/08/2023 Deposit $3,000,000.00 003 California Asset Management Program 03/16/2023 Withdrawal ($3,000,000.00) 003 California Asset Management Program 03/20/2023 Deposit $3,000,000.00 003 California Asset Management Program 03/28/2023 Withdrawal ($4,000,000.00) Activity Total ($948,099.40)
11 Bond Redemption Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 03/31/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
12 Bond Purchase Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 03/31/2023
Purchase 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
13 Bond Interest Received Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 03/31/2023
Bond Interest Received
Accounting ID Transaction Type Cusip Description Date Posted Interest Received Purchased Interest Adjustment Net Interest 4333 Interest Income 3130ALEY6 FHLB 0.800 03/04/2026 03/06/2023 $20,000.00 $20,000.00 4372 Interest Income 931142EW9 WMT 3.900 09/09/2025 03/09/2023 $97,500.00 $7,041.67 $90,458.33 4343 Interest Income 14913R2P1 CAT 0.600 09/13/2024 03/13/2023 $15,000.00 $15,000.00 4373 Interest Income 3133XVDG3 FHLB 4.375 09/13/2024 03/13/2023 $109,375.00 $6,076.39 $103,298.61 4289 Interest Income 3135G0U43 FNMA 2.875 09/12/2023 03/13/2023 $71,875.00 $71,875.00 4292 Interest Income 3133ECHX5 FFCB 2.260 03/13/2024 03/13/2023 $56,500.00 $56,500.00 4332 Interest Income 3130AMQ62 FHLB 0.625 03/14/2025 03/14/2023 $15,625.00 $15,625.00 4331 Interest Income 3130AMQ54 FHLB 0.700 09/16/2025 03/16/2023 $17,500.00 $17,500.00 4336 Interest Income 3130AMXJ6 FHLB 0.500 09/30/2024 03/30/2023 $12,500.00 $12,500.00 4298 Interest Income 912828YH7 T 1.500 09/30/2024 03/31/2023 $37,500.00 $37,500.00 Activity Total $453,375.00 $13,118.06 $440,256.94
14 Statement of Cash Receipts and Disbursements and
Cash Receipts and Disbursements February 2023 March 2023 Receipts
General Fund
Property Tax 162,618 $ 4,784,171$
Local Sales Tax 4,782,858 3,650,664
Public Safety Sales Tax 237,163 313,247
Transient Occupancy Tax (TOT) 966,560 859,306
Utility Users Tax (UUT) 2,145,110 1,976,080 Other Revenue 5,228,407 7,475,327
Total General Fund Revenue 13,522,715 19,058,795 Total All Other Funds Revenue 14,840,057 21,133,448 Total Receipts 28,362,772$ 40,192,243 $
Disbursements
General Fund
Personnel Services (10,819,623) (11,009,605)
Operating Expenses (4,084,763) (4,395,889)
Capital Expenditures (323) ‐
Non‐Operating Expenses (1,418,583) ‐
Total General Fund Disbursements (16,323,291) (15,405,494) Total All Other Funds Disbursements (17,142,796) (24,001,654) Total Disbursements (33,466,087) (39,407,148)
Net Change in Cash Flow (5,103,315)$ 785,095$ Summary of Cash by Fund February 2023 March 2023
General Fund 94,263,953$ 97,917,254$
General Fund Other 3,420,166 3,445,070 Capital Projects Funds 26,264,184 24,673,034 Debt Service Funds 40,571,401 41,025,168
Enterprise Funds 83,832,587 84,120,410
Trust and Agency Funds 5,943,692 4,855,623 Internal Service Funds 27,660,582 24,971,032 Special Revenue Funds 64,918,138 66,652,206 General Ledger Cash Balances * 346,874,701$ 347,659,796$ 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
March 2023
15 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
$18,266,129.89 $18,266,129.89 5.36% $18,266,129.89 0.253% 1 $5,000,000.00 $4,925,215.28 1.44% $4,914,450.00 0.066% 121 $83,000,000.00 $82,687,220.15 24.25% $78,364,180.00 0.393% 699 $29,000,000.00 $29,044,921.50 8.52% $27,077,580.00 0.095% 649 $167,225,000.00 $166,747,253.56 48.90% $156,848,138.00 0.919% 687 $39,684,000.00 $39,348,272.97 11.54% $38,049,776.93 0.315% 748 $342,175,129.89 $341,019,013.34 100.00% $323,520,254.82 2.041% 649 Portfolio Investments
02/28/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 0
Total Activity 1
Period Transactions
Redemptions 8
Purchases 14
Total Activity 22
Net Period Earnings $3,875,960.38
Last FY Period Net Earnings $2,201,914.13
Avg Daily Book Balance $319,315,098.55
$1.00 $1.00
Net Effective Annual Return 1.620%
Net Period Earnings $535,524.25
Last FY Period Net Earnings $303,699.41
Avg Daily Book Balance $339,930,474.75
$1.00 $1.00
Net Effective Annual Return 2.073%
Fiscal YTD Summary (274 Days)Period Earnings Summary (28 Days) ______________________________________________ ____________________________ Portfolio Market Value
Accrued Interest Paid at
Purchase
sum2
Total Market Value
$323,520,254.82
$66,642.37
$1.00
$323,586,897.19
Portfolio Book Value
Accrued Interest Paid at
Purchase
sum2
Total Book Value
$341,019,013.34
$66,642.37
$2.00
$341,085,655.71
Market Value
Book Value
Par Value
Portfolio Summary
Huntington Beach
Portfolio: CITY
Reporting Date: (FY2023)
02/01/2023 - 02/28/2023
Full Accrual Basis
sum2
Total Par Value
$1.00
$342,175,129.89
The City Portfolio uses a 12 month moving average of the 1.5Yr Treasury for comparison purposes. This period, that rate is equal to: 3.450% ____________________________________________
16 Accounting ID Pool Description Type Par Value Book Value Market Value Rate % of Portfolio Composite Rating 003
California Asset Management Program
LGIP
18,266,129.89
18,266,129.89
18,266,129.89
4.73 5.36%
NR
CITY Fund Total 18,266,129.89 18,266,129.89 18,266,129.89 5.36% Portfolio: CITYCash By Fund Report
City of Huntington Beach
Reporting Period:
02/28/2023
Page: 1 Report Run Date: Apr 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
4374 62479MTW3 MUFGBK 0.000 06/30/2023 (0.33Yr-Disco) 10/05/2022 5,000,000.00 4,925,215.28 4,914,450.00 4.602 0.33 121 1.44% P-1/A-1/F1 Commercial Paper Total 5,000,000.00 4,925,215.28 4,914,450.00 1.44% 4352 912828S92 T 1.250 07/31/2023 (0.42Yr-Fixed) 01/14/2022 5,000,000.00 5,011,177.26 4,922,850.00 0.711 0.41 152 1.47% Aaa/AA+/AAA 4357 91282CCN9 T 0.125 07/31/2023 (0.42Yr-Fixed) 02/02/2022 5,000,000.00 4,982,100.18 4,899,400.00 0.991 0.41 152 1.46% Aaa/AA+/AAA 4354 9128282D1 T 1.375 08/31/2023 (0.50Yr-Fixed) 01/21/2022 5,000,000.00 5,011,690.80 4,909,750.00 0.903 0.49 183 1.47% Aaa/AA+/AAA 4364 9128286Z8 T 1.750 06/30/2024 (1.33Yr-Fixed) 05/02/2022 7,000,000.00 6,911,668.06 6,701,170.00 2.730 1.29 487 2.03% Aaa/AA+/AAA 4370 912828XX3 T 2.000 06/30/2024 (1.33Yr-Fixed) 05/27/2022 5,000,000.00 4,970,159.31 4,799,400.00 2.462 1.29 487 1.46% Aaa/AA+/AAA 4353 912828Y87 T 1.750 07/31/2024 (1.42Yr-Fixed) 01/14/2022 5,000,000.00 5,050,461.79 4,772,850.00 1.028 1.37 518 1.48% Aaa/AA+/AAA 4358 912828Y87 T 1.750 07/31/2024 (1.42Yr-Fixed) 02/11/2022 4,000,000.00 4,008,577.76 3,818,280.00 1.595 1.37 518 1.18% Aaa/AA+/AAA 4361 912828D56 T 2.375 08/15/2024 (1.46Yr-Fixed) 03/22/2022 5,000,000.00 5,009,496.15 4,811,550.00 2.240 1.41 533 1.47% Aaa/AA+/AAA 4298 912828YH7 T 1.500 09/30/2024 (1.59Yr-Fixed) 12/05/2019 5,000,000.00 4,992,766.61 4,736,350.00 1.595 1.52 579 1.46% Aaa/AA+/AAA 4350 912828YM6 T 1.500 10/31/2024 (1.67Yr-Fixed) 12/31/2021 3,000,000.00 3,028,590.43 2,835,480.00 0.920 1.61 610 0.89% Aaa/AA+/AAA 4376 91282CEU1 T 2.875 06/15/2025 (2.29Yr-Fixed) 11/18/2022 3,000,000.00 2,909,630.71 2,883,270.00 4.276 2.17 837 0.85% Aaa/AA+/AAA 4330 91282CAB7 T 0.250 07/31/2025 (2.42Yr-Fixed) 05/19/2021 5,000,000.00 4,956,483.18 4,504,700.00 0.615 2.35 883 1.45% Aaa/AA+/AAA 4340 91282CAJ0 T 0.250 08/31/2025 (2.50Yr-Fixed) 09/27/2021 5,000,000.00 4,940,245.82 4,490,650.00 0.735 2.44 914 1.45% Aaa/AA+/AAA 4351 9128284Z0 T 2.750 08/31/2025 (2.50Yr-Fixed) 12/31/2021 5,000,000.00 5,201,230.17 4,780,650.00 1.103 2.38 914 1.53% Aaa/AA+/AAA 4341 91282CCP4 T 0.625 07/31/2026 (3.42Yr-Fixed) 09/30/2021 5,000,000.00 4,945,830.15 4,404,900.00 0.950 3.30 1,248 1.45% Aaa/AA+/AAA 4339 91282CCW9 T 0.750 08/31/2026 (3.50Yr-Fixed) 09/23/2021 1,000,000.00 995,211.73 882,580.00 0.890 3.38 1,279 0.29% Aaa/AA+/AAA 4342 91282CCW9 T 0.750 08/31/2026 (3.50Yr-Fixed) 11/23/2021 5,000,000.00 4,909,370.52 4,412,900.00 1.285 3.38 1,279 1.44% Aaa/AA+/AAA 4379 91282CEW7 T 3.250 06/30/2027 (4.33Yr-Fixed) 12/29/2022 5,000,000.00 4,852,529.50 4,797,450.00 4.000 3.95 1,582 1.42% Aaa/AA+/AAA U.S. Treasuries Total 83,000,000.00 82,687,220.15 78,364,180.00 24.25% 4290 45818WBX3 IADB 2.870 07/20/2023 (0.39Yr-Fixed) 03/28/2019 4,000,000.00 4,008,769.90 3,960,680.00 2.270 0.38 141 1.18% Aaa/AAA/AAA 4291 45818WBY1 IADB 2.960 08/16/2023 (0.46Yr-Fixed) 03/28/2019 5,000,000.00 5,014,947.24 4,943,650.00 2.271 0.45 168 1.47% Aaa/AAA/AAA 4323 459056HV2 IBRD 1.500 08/28/2024 (1.49Yr-Fixed) 04/23/2021 5,000,000.00 5,079,502.74 4,743,100.00 0.425 1.45 546 1.49% Aaa/AAA/AAA 4338 459058JE4 IBRD 0.376 07/28/2025 (2.41Yr-Fixed) 07/30/2021 5,000,000.00 4,975,280.25 4,514,750.00 0.583 2.34 880 1.46% Aaa/AAA/AAA 4319 459058JL8 IBRD 0.500 10/28/2025 (2.66Yr-Fixed) 01/12/2021 5,000,000.00 4,998,475.23 4,488,600.00 0.512 2.58 972 1.47% Aaa/AAA/AAA 4324 45906M2L4 IBRD 0.650 02/24/2026 (2.99YrNC2.79Mo-Dq-Fixed) 04/30/2021 5,000,000.00 4,967,946.14 4,426,800.00 0.870 2.89 1,091 1.46% Aaa/AAA/AAA Supranational Total 29,000,000.00 29,044,921.50 27,077,580.00 8.52% 4285 3130AFWX1 FHLB 2.550 05/30/2023 (0.25Yr-Fixed) 02/26/2019 5,000,000.00 5,000,000.00 4,970,700.00 2.550 0.24 90 1.47% Aaa/AA+/NR 4281 313383QR5 FHLB 3.250 06/09/2023 (0.27Yr-Fixed) 12/20/2018 5,000,000.00 5,006,456.18 4,976,550.00 2.743 0.27 100 1.47% Aaa/AA+/NR 4368 313383MD0 FHLB 2.625 06/09/2023 (0.27Yr-Fixed) 05/09/2022 7,000,000.00 7,007,915.38 6,949,250.00 2.201 0.27 100 2.05% Aaa/AA+/NR 4287
3137EAEN5
FHLMC 2.750 06/19/2023 (0.30Yr-Fixed)
03/08/2019
3,000,000.00
3,002,544.06
2,979,030.00
2.450
0.30 110
0.88%
Aaa/AA+/AAA
4288 3137EAEN5 FHLMC 2.750 06/19/2023 (0.30Yr-Fixed) 03/14/2019 3,000,000.00 3,002,657.43 2,979,030.00 2.437 0.30 110 0.88% Aaa/AA+/AAA 4383 3130AUHE7 FHLB 0.000 07/26/2023 (0.40Yr-Disco) 01/18/2023 5,000,000.00 5,002,205.85 4,994,700.00 4.755 0.39 147 1.47% Aaa/AA+/NR 4289 3135G0U43 FNMA 2.875 09/12/2023 (0.53Yr-Fixed) 03/15/2019 5,000,000.00 5,010,229.19 4,938,750.00 2.465 0.52 195 1.47% Aaa/AA+/AAA 4377 313384ND7 FHDN 0.000 10/19/2023 (0.64Yr-Disco) 12/05/2022 3,000,000.00 2,910,970.00 2,906,430.00 4.817 0.62 232 0.85% P-1/A-1+/NR 4292 3133ECHX5 FFCB 2.260 03/13/2024 (1.03Yr-Fixed) 05/23/2019 5,000,000.00 5,001,161.16 4,847,950.00 2.236 0.99 378 1.47% Aaa/AA+/AAA 4378 3130ATVC8 FHLB 4.875 06/14/2024 (1.29Yr-Fixed) 12/28/2022 5,000,000.00 5,007,702.00 4,972,950.00 4.740 1.22 471 1.47% Aaa/AA+/NR 4348 3130AQD42 FHLB 0.920 06/28/2024 (1.33YrNC0.92Mo-Dq-Fixed) 12/28/2021 5,000,000.00 5,000,000.00 4,722,400.00 0.920 1.29 485 1.47% Aaa/AA+/NR 4380 3134GYCP5 FHLMC 5.000 07/23/2024 (1.40YrNC7.79Mo-1x-Fixed) 01/23/2023 5,000,000.00 5,000,000.00 4,967,350.00 5.000 0.99 510 1.47% Aaa/AA+/AAA 4344 3130AQ3C5 FHLB 1.000 08/28/2024 (1.49YrNC2.92Mo-Dq-Fixed) 12/02/2021 4,000,000.00 4,000,000.00 3,757,520.00 1.000 1.45 546 1.17% Aaa/AA+/NR Portfolio: CITYSecurities By Structure Report
City of Huntington Beach
Reporting Period:
02/28/2023
Page: 1 Report Run Date: Apr 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
4373 3133XVDG3 FHLB 4.375 09/13/2024 (1.54Yr-Fixed) 09/23/2022 5,000,000.00 5,009,757.18 4,945,750.00 4.240 1.44 562 1.47% Aaa/AA+/NR 4336 3130AMXJ6 FHLB 0.500 09/30/2024 (1.59YrNC0.99Mo-Dq-Fixed) 06/30/2021 5,000,000.00 5,000,000.00 4,643,550.00 0.500 1.54 579 1.47% Aaa/AA+/NR 4346 3130AQD59 FHLB 1.000 09/30/2024 (1.59YrNC0.99Mo-Dq-Fixed) 12/30/2021 5,000,000.00 5,000,000.00 4,681,200.00 1.000 1.53 579 1.47% Aaa/AA+/NR 4349 3130AQD59 FHLB 1.000 09/30/2024 (1.59YrNC0.99Mo-Dq-Fixed) 12/30/2021 5,000,000.00 5,000,000.00 4,681,200.00 1.000 1.53 579 1.47% Aaa/AA+/NR 4334 3130AMW65 FHLB 0.500 12/30/2024 (1.83YrNC0.99Mo-Dq-Fixed) 06/30/2021 5,000,000.00 5,000,000.00 4,598,650.00 0.500 1.78 670 1.47% Aaa/AA+/NR 4332 3130AMQ62 FHLB 0.625 03/14/2025 (2.04YrNC0.46Mo-Dq-Fixed) 06/14/2021 5,000,000.00 5,000,000.00 4,573,450.00 0.625 1.97 744 1.47% Aaa/AA+/NR 4329 3135G04Z3 FNMA 0.500 06/17/2025 (2.30Yr-Fixed) 05/14/2021 5,000,000.00 4,985,504.34 4,544,050.00 0.628 2.23 839 1.46% Aaa/AA+/AAA 4381 3135G04Z3 FNMA 0.500 06/17/2025 (2.30Yr-Fixed) 01/13/2023 5,000,000.00 4,619,605.26 4,544,050.00 4.013 2.23 839 1.35% Aaa/AA+/AAA 4345 3130AQ5S8 FHLB 1.250 06/30/2025 (2.33YrNC0.99Mo-Dq-Fixed) 12/30/2021 4,650,000.00 4,650,000.00 4,269,769.50 1.250 2.24 852 1.36% Aaa/AA+/NR 4327 3130AMDL3 FHLB 0.800 07/25/2025 (2.40YrNC2.83Mo-Dq-Fixed) 05/25/2021 5,000,000.00 5,000,000.00 4,531,850.00 0.800 2.32 877 1.47% Aaa/AA+/NR 4360 3130AQT94 FHLB 1.600 08/28/2025 (2.49Yr-Fixed) 03/04/2022 4,575,000.00 4,551,274.03 4,230,868.50 1.816 2.39 911 1.33% Aaa/AA+/NR 4331 3130AMQ54 FHLB 0.700 09/16/2025 (2.55YrNC6.57Mo-Da-Fixed) 06/16/2021 5,000,000.00 5,000,000.00 4,498,900.00 0.700 2.45 930 1.47% Aaa/AA+/NR 4318 3135GA2Z3 FNMA 0.560 11/17/2025 (2.72YrNC8.61Mo-Da-Fixed) 01/11/2021 3,000,000.00 3,001,844.67 2,674,590.00 0.500 2.63 992 0.88% Aaa/AA+/AAA 4320 3130AKN36 FHLB 0.525 01/15/2026 (2.88YrNC1.51Mo-Dq-Fixed) 01/15/2021 5,000,000.00 4,997,127.78 4,417,800.00 0.545 2.78 1,051 1.47% Aaa/AA+/NR 4321 3130AKN85 FHLB 0.550 01/20/2026 (2.89YrNC1.68Mo-Dq-Fixed) 01/20/2021 5,000,000.00 4,998,556.94 4,419,050.00 0.560 2.79 1,056 1.47% Aaa/AA+/NR 4322 3130AKUS3 FHLB 0.500 01/28/2026 (2.91YrNC1.94Mo-Dq-Fixed) 01/28/2021 5,000,000.00 5,000,000.00 4,409,100.00 0.500 2.82 1,064 1.47% Aaa/AA+/NR 4333 3130ALEY6 FHLB 0.800 03/04/2026 (3.01YrNC0.13Mo-Dq-Fixed) 06/10/2021 5,000,000.00 5,000,000.00 4,440,500.00 0.800 2.89 1,099 1.47% Aaa/AA+/NR 4328 3130AMJN3 FHLB 1.030 05/26/2026 (3.24YrNC2.86Mo-Dq-Fixed) 05/26/2021 5,000,000.00 5,000,000.00 4,430,000.00 1.030 3.10 1,182 1.47% Aaa/AA+/NR 4335 3130AMFS6 FHLB 0.750 06/12/2026 (3.28Yr-Fixed) 06/17/2021 5,000,000.00 4,980,261.84 4,435,100.00 0.873 3.16 1,199 1.46% Aaa/AA+/NR 4347 3130AQ7E7 FHLB 1.500 06/30/2026 (3.33YrNC0.99Mo-Dq-Fixed) 12/30/2021 5,000,000.00 5,001,480.25 4,497,450.00 1.339 3.16 1,217 1.47% Aaa/AA+/NR 4384 3130AUMC5 FHLB 3.750 07/20/2026 (3.39Yr-Fixed) 01/19/2023 5,000,000.00 5,000,000.00 4,888,200.00 3.750 3.12 1,237 1.47% Aaa/AA+/NR 4356 3130AQS79 FHLB 1.375 08/07/2026 (3.44YrNC17.28Mo-1x-Step) 02/07/2022 5,000,000.00 5,000,000.00 4,530,450.00 1.375 3.23 1,255 1.47% Aaa/AA+/NR U.S. Agencies Total 167,225,000.00 166,747,253.56 156,848,138.00 48.90% 4306 90331HNV1 USB 3.400 07/24/2023 (0.40YrNC3.78Mo-Cc-Fixed) 02/21/2020 2,000,000.00 2,012,968.58 1,985,660.00 1.671 0.39 145 0.59% A1/AA-/A1 4300 254687CR5 DIS 4.000 10/01/2023 (0.59Yr-Fixed) 12/16/2019 2,875,000.00 2,905,961.54 2,852,316.25 2.070 0.56 214 0.85% A2/BBB+/A- 4355 67066GAL8 NVDA 0.584 06/14/2024 (1.29YrNC3.48Mo-Cc-Fixed) 01/24/2022 5,000,000.00 4,957,926.22 4,714,100.00 1.250 1.25 471 1.45% A2/A/ 4325 91159HHX1 USB 2.400 07/30/2024 (1.42YrNC15.97Mo-Cc-Fixed) 04/30/2021 3,809,000.00 3,906,104.76 3,658,620.68 0.528 1.36 517 1.15% A2/A+/A+ 4343 14913R2P1 CAT 0.600 09/13/2024 (1.54Yr-Fixed) 12/02/2021 5,000,000.00 4,971,297.10 4,665,050.00 0.980 1.49 562 1.46% A2/A/A 4371 459200KS9 IBM 4.000 07/27/2025 (2.41Yr-Fixed) 08/11/2022 6,000,000.00 6,025,590.06 5,844,180.00 3.810 2.25 879 1.77% A3/A-/ 4372
931142EW9
WMT 3.900 09/09/2025 (2.53Yr-Fixed)
09/22/2022
5,000,000.00
4,970,555.95
4,900,050.00
4.150
2.33 923
1.46%
Aa2/AA/AA
4382
717081DV2
PFE 2.750 06/03/2026 (3.26Yr-Fixed)
01/18/2023
5,000,000.00
4,790,486.91
4,696,250.00
4.142
3.03 1,190
1.40%
A1/A+/Au
4375
110122CN6
BMY 3.200 06/15/2026 (3.29YrNC37.52Mo-Cc-Fixed)
11/16/2022
5,000,000.00
4,807,381.85
4,733,550.00
4.480
3.02 1,202
1.41%
A2/A+/WD
Corporates Total 39,684,000.00 39,348,272.97 38,049,776.93 11.54% Holdings Total 323,909,000.00 322,752,883.45 305,254,124.93 94.64% Portfolio: CITYSecurities By Structure Report
City of Huntington Beach
Reporting Period:
02/28/2023
Page: 2 Report Run Date: Apr 11, 2023
19 Cash/Money Market/LGIP Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 02/28/2023
Cash/Money Market Account Activity
Accounting ID Description Activity Date Transaction Type Transaction Amount 003 California Asset Management Program 02/01/2023 Interest Received $73,826.38 003 California Asset Management Program 02/02/2023 Withdrawal ($5,000,000.00) 003 California Asset Management Program 02/16/2023 Withdrawal ($3,000,000.00) 003 California Asset Management Program 02/24/2023 Deposit $7,000,000.00 Activity Total ($926,173.62)
982 LAIF 02/07/2023 Withdrawal ($3,393.02)
Activity Total ($3,393.02)
20 Bond Redemption Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 02/28/2023
Redemption Transactions
Accounting ID Transaction
Type Cusip Description Price Settlement
Date Posted Date Par Value Principal Accrued Interest Total 4299 Maturity 912828P79 T 1.500 02/28/2023 100.00000 02/28/2023 02/28/2023 $3,000,000.00 $3,000,000.00 $0.00 $3,000,000.00 Activity Total $3,000,000.00 $3,000,000.00 $0.00 $3,000,000.00 21 Bond Purchase Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 02/28/2023
Purchase 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
22 Bond Interest Received Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 02/28/2023
Bond Interest Received
Accounting ID Transaction Type Cusip Description Date Posted Interest Received Purchased Interest Adjustment Net Interest 4356 Interest Income 3130AQS79 FHLB 1.375 08/07/2026 02/07/2023 $34,375.00 $34,375.00 4361 Interest Income 912828D56 T 2.375 08/15/2024 02/15/2023 $59,375.00 $59,375.00 4291 Interest Income 45818WBY1 IADB 2.960 08/16/2023 02/16/2023 $74,000.00 $74,000.00 4324 Interest Income 45906M2L4 IBRD 0.650 02/24/2026 02/24/2023 $16,250.00 $16,250.00 4339 Interest Income 91282CCW9 T 0.750 08/31/2026 02/28/2023 $3,750.00 $3,750.00 4340 Interest Income 91282CAJ0 T 0.250 08/31/2025 02/28/2023 $6,250.00 $6,250.00 4342 Interest Income 91282CCW9 T 0.750 08/31/2026 02/28/2023 $18,750.00 $18,750.00 4344 Interest Income 3130AQ3C5 FHLB 1.000 08/28/2024 02/28/2023 $20,000.00 $20,000.00 4351 Interest Income 9128284Z0 T 2.750 08/31/2025 02/28/2023 $68,750.00 $68,750.00 4354 Interest Income 9128282D1 T 1.375 08/31/2023 02/28/2023 $34,375.00 $34,375.00 4360 Interest Income 3130AQT94 FHLB 1.600 08/28/2025 02/28/2023 $36,600.00 $36,600.00 4299 Interest Income 912828P79 T 1.500 02/28/2023 02/28/2023 $22,500.00 $22,500.00 4323 Interest Income 459056HV2 IBRD 1.500 08/28/2024 02/28/2023 $37,500.00 $37,500.00 Activity Total $432,475.00 $0.00 $432,475.00
23 Statement of Cash Receipts and Disbursements and
Cash Receipts and Disbursements January 2023 February 2023 Receipts
General Fund
Property Tax 16,811,848$ 162,618$
Local Sales Tax 3,480,191 4,782,858
Public Safety Sales Tax 245,574 237,163
Transient Occupancy Tax (TOT) 1,024,428 966,560 Utility Users Tax (UUT) 1,017,399 2,145,110 Other Revenue 3,955,832 5,228,407
Total General Fund Revenue 26,535,272 13,522,715
Total All Other Funds Revenue 30,812,081 14,840,057
Total Receipts 57,347,352$ 28,362,772$
Disbursements
General Fund
Personnel Services (24,567,467) (10,819,623)
Operating Expenses (2,958,213) (4,084,763)
Capital Expenditures (105) (323)
Non‐Operating Expenses
‐
(1,418,583)
Total General Fund Disbursements (27,525,784) (16,323,291) Total All Other Funds Disbursements (18,654,619) (17,142,796) Total Disbursements (46,180,403) (33,466,087)
Net Change in Cash Flow 11,166,949$ (5,103,315)$ Summary of Cash by Fund January 2023 February 2023
General Fund 96,715,476$ 93,914,900$
General Fund Other 3,403,577 3,413,762 Capital Projects Funds 28,111,679 26,162,173
Debt Service Funds 39,350,787 40,435,804
Enterprise Funds 82,139,444 83,529,795
Trust and Agency Funds 7,182,783 5,917,227 Internal Service Funds 28,804,382 27,557,317
Special Revenue Funds 65,087,407 64,761,244
General Ledger Cash Balances * 350,795,535$ 345,692,220$ 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
February 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
$19,195,696.53 $19,195,696.53 5.57% $19,195,696.53 0.252% 1 $5,000,000.00 $4,907,909.72 1.42% $4,898,000.00 0.065% 149 $86,000,000.00 $85,679,484.89 24.84% $82,054,150.00 0.402% 703 $29,000,000.00 $29,052,174.11 8.42% $27,304,110.00 0.094% 676 $167,225,000.00 $166,729,870.48 48.34% $158,399,309.00 0.908% 715 $39,684,000.00 $39,346,524.07 11.41% $38,489,535.54 0.312% 776 $346,104,696.53 $344,911,659.80 100.00% $330,340,801.07 2.033% 668 Portfolio Investments
01/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 5
Total Activity 6
Period Transactions
Redemptions 8
Purchases 14
Total Activity 22
Net Period Earnings $3,875,960.38
Last FY Period Net Earnings $2,201,914.13
Avg Daily Book Balance $319,315,098.55
$1.00 $1.00
Net Effective Annual Return 1.620%
Net Period Earnings $532,677.73
Last FY Period Net Earnings $294,599.75
Avg Daily Book Balance $333,226,487.96
$1.00 $1.00
Net Effective Annual Return 1.898%
Fiscal YTD Summary (274 Days)Period Earnings Summary (31 Days) ______________________________________________ ____________________________ Portfolio Market Value
Accrued Interest Paid at
Purchase
sum2
Total Market Value
$330,340,801.07
$66,642.37
$1.00
$330,407,443.44
Portfolio Book Value
Accrued Interest Paid at
Purchase
sum2
Total Book Value
$344,911,659.80
$66,642.37
$2.00
$344,978,302.17
Market Value
Book Value
Par Value
Portfolio Summary
Huntington Beach
Portfolio: CITY
Reporting Date: (FY2023)
01/01/2023 - 01/31/2023
Full Accrual Basis
sum2
Total Par Value
$1.00
$346,104,696.53
The City Portfolio uses a 12 month moving average of the 1.5Yr Treasury for comparison purposes. This period, that rate is equal to: 3.140% ____________________________________________
25 Accounting ID Pool Description Type Par Value Book Value Market Value Rate % of Portfolio Composite Rating 003
California Asset Management Program
LGIP
19,192,303.51
19,192,303.51
19,192,303.51
4.53 5.56%
NR
982
LAIF
LGIP
3,393.02
3,393.02
3,393.02
2.43 0.00%
NR
CITY Fund Total 19,195,696.53 19,195,696.53 19,195,696.53 5.57% Portfolio: CITYCash By Fund Report
City of Huntington Beach
Reporting Period:
01/31/2023
Page: 1 Report Run Date: Apr 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.41Yr-Disco) 10/05/2022 5,000,000.00 4,907,909.72 4,898,000.00 4.602 0.41 149 1.42% P-1/A-1/F1 Commercial Paper Total 5,000,000.00 4,907,909.72 4,898,000.00 1.42% 4299 912828P79 T 1.500 02/28/2023 (0.07Yr-Fixed) 12/05/2019 3,000,000.00 2,999,839.25 2,993,040.00 1.574 0.07 27 0.87% Aaa/AA+/AAA 4352 912828S92 T 1.250 07/31/2023 (0.49Yr-Fixed) 01/14/2022 5,000,000.00 5,013,236.23 4,913,300.00 0.711 0.48 180 1.45% Aaa/AA+/AAA 4357 91282CCN9 T 0.125 07/31/2023 (0.49Yr-Fixed) 02/02/2022 5,000,000.00 4,978,802.85 4,886,700.00 0.991 0.48 180 1.44% Aaa/AA+/AAA 4354 9128282D1 T 1.375 08/31/2023 (0.58Yr-Fixed) 01/21/2022 5,000,000.00 5,013,479.56 4,904,700.00 0.903 0.56 211 1.45% Aaa/AA+/AAA 4364 9128286Z8 T 1.750 06/30/2024 (1.41Yr-Fixed) 05/02/2022 7,000,000.00 6,906,589.43 6,732,880.00 2.730 1.37 515 2.00% Aaa/AA+/AAA 4370 912828XX3 T 2.000 06/30/2024 (1.41Yr-Fixed) 05/27/2022 5,000,000.00 4,968,443.63 4,825,400.00 2.462 1.37 515 1.44% Aaa/AA+/AAA 4353 912828Y87 T 1.750 07/31/2024 (1.49Yr-Fixed) 01/14/2022 5,000,000.00 5,053,189.45 4,802,150.00 1.028 1.45 546 1.47% Aaa/AA+/AAA 4358 912828Y87 T 1.750 07/31/2024 (1.49Yr-Fixed) 02/11/2022 4,000,000.00 4,009,041.42 3,841,720.00 1.595 1.45 546 1.16% Aaa/AA+/AAA 4361 912828D56 T 2.375 08/15/2024 (1.54Yr-Fixed) 03/22/2022 5,000,000.00 5,009,995.01 4,844,900.00 2.240 1.47 561 1.45% Aaa/AA+/AAA 4298 912828YH7 T 1.500 09/30/2024 (1.66Yr-Fixed) 12/05/2019 5,000,000.00 4,992,416.81 4,771,700.00 1.595 1.60 607 1.45% Aaa/AA+/AAA 4350 912828YM6 T 1.500 10/31/2024 (1.75Yr-Fixed) 12/31/2021 3,000,000.00 3,029,902.78 2,857,740.00 0.920 1.69 638 0.88% Aaa/AA+/AAA 4376 91282CEU1 T 2.875 06/15/2025 (2.37Yr-Fixed) 11/18/2022 3,000,000.00 2,906,607.61 2,922,180.00 4.276 2.25 865 0.84% Aaa/AA+/AAA 4330 91282CAB7 T 0.250 07/31/2025 (2.49Yr-Fixed) 05/19/2021 5,000,000.00 4,955,103.26 4,560,950.00 0.615 2.43 911 1.44% Aaa/AA+/AAA 4340 91282CAJ0 T 0.250 08/31/2025 (2.58Yr-Fixed) 09/27/2021 5,000,000.00 4,938,415.27 4,548,050.00 0.735 2.51 942 1.43% Aaa/AA+/AAA 4351 9128284Z0 T 2.750 08/31/2025 (2.58Yr-Fixed) 12/31/2021 5,000,000.00 5,207,394.77 4,848,250.00 1.103 2.42 942 1.51% Aaa/AA+/AAA 4341 91282CCP4 T 0.625 07/31/2026 (3.49Yr-Fixed) 09/30/2021 5,000,000.00 4,944,614.80 4,487,700.00 0.950 3.38 1,276 1.43% Aaa/AA+/AAA 4339 91282CCW9 T 0.750 08/31/2026 (3.58Yr-Fixed) 09/23/2021 1,000,000.00 995,106.91 899,690.00 0.890 3.44 1,307 0.29% Aaa/AA+/AAA 4342 91282CCW9 T 0.750 08/31/2026 (3.58Yr-Fixed) 11/23/2021 5,000,000.00 4,907,386.45 4,498,450.00 1.285 3.44 1,307 1.42% Aaa/AA+/AAA 4379 91282CEW7 T 3.250 06/30/2027 (4.41Yr-Fixed) 12/29/2022 5,000,000.00 4,849,919.40 4,914,650.00 4.000 4.03 1,610 1.41% Aaa/AA+/AAA U.S. Treasuries Total 86,000,000.00 85,679,484.89 82,054,150.00 24.84% 4290 45818WBX3 IADB 2.870 07/20/2023 (0.46Yr-Fixed) 03/28/2019 4,000,000.00 4,010,662.68 3,962,560.00 2.270 0.45 169 1.16% Aaa/AAA/AAA 4291 45818WBY1 IADB 2.960 08/16/2023 (0.54Yr-Fixed) 03/28/2019 5,000,000.00 5,017,664.92 4,948,550.00 2.271 0.52 196 1.45% Aaa/AAA/AAA 4323 459056HV2 IBRD 1.500 08/28/2024 (1.57Yr-Fixed) 04/23/2021 5,000,000.00 5,083,944.23 4,774,250.00 0.425 1.52 574 1.47% Aaa/AAA/AAA 4338 459058JE4 IBRD 0.376 07/28/2025 (2.49Yr-Fixed) 07/30/2021 5,000,000.00 4,974,424.90 4,565,700.00 0.583 2.42 908 1.44% Aaa/AAA/AAA 4319 459058JL8 IBRD 0.500 10/28/2025 (2.74Yr-Fixed) 01/12/2021 5,000,000.00 4,998,427.43 4,544,800.00 0.512 2.66 1,000 1.45% Aaa/AAA/AAA 4324 45906M2L4 IBRD 0.650 02/24/2026 (3.06YrNC0.79Mo-Dq-Fixed) 04/30/2021 5,000,000.00 4,967,049.94 4,508,250.00 0.870 2.95 1,119 1.44% Aaa/AAA/AAA Supranational Total 29,000,000.00 29,052,174.11 27,304,110.00 8.42% 4285 3130AFWX1 FHLB 2.550 05/30/2023 (0.32Yr-Fixed) 02/26/2019 5,000,000.00 5,000,000.00 4,966,450.00 2.550 0.32 118 1.45% Aaa/AA+/NR 4281 313383QR5 FHLB 3.250 06/09/2023 (0.35Yr-Fixed) 12/20/2018 5,000,000.00 5,008,432.57 4,972,200.00 2.743 0.34 128 1.45% Aaa/AA+/NR 4368
313383MD0
FHLB 2.625 06/09/2023 (0.35Yr-Fixed)
05/09/2022
7,000,000.00
7,010,338.46
6,950,930.00
2.201
0.35 128
2.03%
Aaa/AA+/NR
4287 3137EAEN5 FHLMC 2.750 06/19/2023 (0.38Yr-Fixed) 03/08/2019 3,000,000.00 3,003,250.75 2,976,420.00 2.450 0.37 138 0.87% Aaa/AA+/AAA 4288 3137EAEN5 FHLMC 2.750 06/19/2023 (0.38Yr-Fixed) 03/14/2019 3,000,000.00 3,003,395.61 2,976,420.00 2.437 0.37 138 0.87% Aaa/AA+/AAA 4383 3130AUHE7 FHLB 0.000 07/26/2023 (0.48Yr-Disco) 01/18/2023 5,000,000.00 5,002,662.23 4,999,800.00 4.755 0.47 175 1.45% Aaa/AA+/NR 4289 3135G0U43 FNMA 2.875 09/12/2023 (0.61Yr-Fixed) 03/15/2019 5,000,000.00 5,011,835.87 4,939,550.00 2.465 0.59 223 1.45% Aaa/AA+/AAA 4377 313384ND7 FHDN 0.000 10/19/2023 (0.71Yr-Disco) 12/05/2022 3,000,000.00 2,900,225.00 2,899,650.00 4.817 0.70 260 0.84% P-1/A-1+/NR 4292 3133ECHX5 FFCB 2.260 03/13/2024 (1.11Yr-Fixed) 05/23/2019 5,000,000.00 5,001,254.80 4,867,350.00 2.236 1.07 406 1.45% Aaa/AA+/AAA 4378 3130ATVC8 FHLB 4.875 06/14/2024 (1.37Yr-Fixed) 12/28/2022 5,000,000.00 5,008,201.05 5,010,700.00 4.740 1.30 499 1.45% Aaa/AA+/NR 4348 3130AQD42 FHLB 0.920 06/28/2024 (1.40YrNC1.84Mo-Dq-Fixed) 12/28/2021 5,000,000.00 5,000,000.00 4,745,300.00 0.920 1.37 513 1.45% Aaa/AA+/NR 4380 3134GYCP5 FHLMC 5.000 07/23/2024 (1.47YrNC8.71Mo-1x-Fixed) 01/23/2023 5,000,000.00 5,000,000.00 5,008,000.00 5.000 0.92 538 1.45% Aaa/AA+/AAA Portfolio: CITYSecurities By Structure Report
City of Huntington Beach
Reporting Period:
01/31/2023
Page: 1 Report Run Date: Apr 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.57YrNC0.92Mo-Dq-Fixed) 12/02/2021 4,000,000.00 4,000,000.00 3,782,240.00 1.000 1.52 574 1.16% Aaa/AA+/NR 4373 3133XVDG3 FHLB 4.375 09/13/2024 (1.62Yr-Fixed) 09/23/2022 5,000,000.00 5,010,287.46 4,991,950.00 4.240 1.52 590 1.45% Aaa/AA+/NR 4336 3130AMXJ6 FHLB 0.500 09/30/2024 (1.66YrNC1.91Mo-Dq-Fixed) 06/30/2021 5,000,000.00 5,000,000.00 4,676,750.00 0.500 1.62 607 1.45% Aaa/AA+/NR 4346 3130AQD59 FHLB 1.000 09/30/2024 (1.66YrNC1.91Mo-Dq-Fixed) 12/30/2021 5,000,000.00 5,000,000.00 4,716,400.00 1.000 1.61 607 1.45% Aaa/AA+/NR 4349 3130AQD59 FHLB 1.000 09/30/2024 (1.66YrNC1.91Mo-Dq-Fixed) 12/30/2021 5,000,000.00 5,000,000.00 4,716,400.00 1.000 1.61 607 1.45% Aaa/AA+/NR 4334 3130AMW65 FHLB 0.500 12/30/2024 (1.91YrNC1.91Mo-Dq-Fixed) 06/30/2021 5,000,000.00 5,000,000.00 4,643,500.00 0.500 1.86 698 1.45% Aaa/AA+/NR 4332 3130AMQ62 FHLB 0.625 03/14/2025 (2.11YrNC1.38Mo-Dq-Fixed) 06/14/2021 5,000,000.00 5,000,000.00 4,627,650.00 0.625 2.05 772 1.45% Aaa/AA+/NR 4329 3135G04Z3 FNMA 0.500 06/17/2025 (2.37Yr-Fixed) 05/14/2021 5,000,000.00 4,984,977.87 4,593,900.00 0.628 2.31 867 1.45% Aaa/AA+/AAA 4381 3135G04Z3 FNMA 0.500 06/17/2025 (2.37Yr-Fixed) 01/13/2023 5,000,000.00 4,605,789.47 4,593,900.00 4.013 2.31 867 1.34% Aaa/AA+/AAA 4345 3130AQ5S8 FHLB 1.250 06/30/2025 (2.41YrNC1.91Mo-Dq-Fixed) 12/30/2021 4,650,000.00 4,650,000.00 4,332,219.00 1.250 2.32 880 1.35% Aaa/AA+/NR 4327 3130AMDL3 FHLB 0.800 07/25/2025 (2.48YrNC0.82Mo-Dq-Fixed) 05/25/2021 5,000,000.00 5,000,000.00 4,599,400.00 0.800 2.40 905 1.45% Aaa/AA+/NR 4360 3130AQT94 FHLB 1.600 08/28/2025 (2.57YrNC0.92Mo-1x-Fixed) 03/04/2022 4,575,000.00 4,550,480.52 4,287,690.00 1.816 2.45 939 1.32% Aaa/AA+/NR 4331 3130AMQ54 FHLB 0.700 09/16/2025 (2.62YrNC7.49Mo-Da-Fixed) 06/16/2021 5,000,000.00 5,000,000.00 4,570,700.00 0.700 2.54 958 1.45% Aaa/AA+/NR 4318 3135GA2Z3 FNMA 0.560 11/17/2025 (2.79YrNC9.53Mo-Da-Fixed) 01/11/2021 3,000,000.00 3,001,901.37 2,711,940.00 0.500 2.70 1,020 0.87% Aaa/AA+/AAA 4320 3130AKN36 FHLB 0.525 01/15/2026 (2.95YrNC2.43Mo-Dq-Fixed) 01/15/2021 5,000,000.00 4,997,044.44 4,498,000.00 0.545 2.86 1,079 1.45% Aaa/AA+/NR 4321 3130AKN85 FHLB 0.550 01/20/2026 (2.97YrNC2.60Mo-Dq-Fixed) 01/20/2021 5,000,000.00 4,998,515.28 4,499,500.00 0.560 2.88 1,084 1.45% Aaa/AA+/NR 4322 3130AKUS3 FHLB 0.500 01/28/2026 (2.99YrNC2.86Mo-Dq-Fixed) 01/28/2021 5,000,000.00 5,000,000.00 4,489,900.00 0.500 2.90 1,092 1.45% Aaa/AA+/NR 4333 3130ALEY6 FHLB 0.800 03/04/2026 (3.09YrNC1.05Mo-Dq-Fixed) 06/10/2021 5,000,000.00 5,000,000.00 4,517,450.00 0.800 2.97 1,127 1.45% Aaa/AA+/NR 4328 3130AMJN3 FHLB 1.030 05/26/2026 (3.31YrNC0.85Mo-Dq-Fixed) 05/26/2021 5,000,000.00 5,000,000.00 4,520,950.00 1.030 3.17 1,210 1.45% Aaa/AA+/NR 4335 3130AMFS6 FHLB 0.750 06/12/2026 (3.36Yr-Fixed) 06/17/2021 5,000,000.00 4,979,760.45 4,512,600.00 0.873 3.24 1,227 1.44% Aaa/AA+/NR 4347 3130AQ7E7 FHLB 1.500 06/30/2026 (3.41YrNC1.91Mo-Dq-Fixed) 12/30/2021 5,000,000.00 5,001,517.28 4,592,300.00 1.339 3.19 1,245 1.45% Aaa/AA+/NR 4384 3130AUMC5 FHLB 3.750 07/20/2026 (3.46Yr-Fixed) 01/19/2023 5,000,000.00 5,000,000.00 4,984,900.00 3.750 3.20 1,265 1.45% Aaa/AA+/NR 4356 3130AQS79 FHLB 1.375 08/07/2026 (3.51YrNC18.20Mo-1x-Step) 02/07/2022 5,000,000.00 5,000,000.00 4,626,300.00 1.375 3.12 1,283 1.45% Aaa/AA+/NR U.S. Agencies Total 167,225,000.00 166,729,870.48 158,399,309.00 48.34% 4306 90331HNV1 USB 3.400 07/24/2023 (0.47YrNC4.70Mo-Cc-Fixed) 02/21/2020 2,000,000.00 2,015,689.26 1,985,660.00 1.671 0.46 173 0.58% A1/AA-/A1 4300 254687CR5 DIS 4.000 10/01/2023 (0.66Yr-Fixed) 12/16/2019 2,875,000.00 2,910,384.62 2,855,335.00 2.070 0.64 242 0.84% A2/BBB+/A- 4355 67066GAL8 NVDA 0.584 06/14/2024 (1.37YrNC4.40Mo-Cc-Fixed) 01/24/2022 5,000,000.00 4,955,200.06 4,737,350.00 1.250 1.33 499 1.44% A2/A/ 4325 91159HHX1 USB 2.400 07/30/2024 (1.49YrNC16.89Mo-Cc-Fixed) 04/30/2021 3,809,000.00 3,911,828.02 3,687,340.54 0.528 1.44 545 1.13% A2/A+/A+ 4343 14913R2P1 CAT 0.600 09/13/2024 (1.62Yr-Fixed) 12/02/2021 5,000,000.00 4,969,737.16 4,697,300.00 0.980 1.57 590 1.44% A2/A/A 4371
459200KS9
IBM 4.000 07/27/2025 (2.48Yr-Fixed)
08/11/2022
6,000,000.00
6,026,476.55
5,924,700.00
3.810
2.33 907
1.75%
A3/A-/
4372
931142EW9
WMT 3.900 09/09/2025 (2.60Yr-Fixed)
09/22/2022
5,000,000.00
4,969,583.13
4,973,450.00
4.150
2.41 951
1.44%
Aa2/AA/AA
4382
717081DV2
PFE 2.750 06/03/2026 (3.33Yr-Fixed)
01/18/2023
5,000,000.00
4,785,123.95
4,786,450.00
4.142
3.11 1,218
1.39%
A1/A+/Au
4375
110122CN6
BMY 3.200 06/15/2026 (3.37YrNC38.44Mo-Cc-Fixed)
11/16/2022
5,000,000.00
4,802,501.32
4,841,950.00
4.480
3.08 1,230
1.39%
A2/A+/WD
Corporates Total 39,684,000.00 39,346,524.07 38,489,535.54 11.41% Holdings Total 326,909,000.00 325,715,963.27 311,145,104.54 94.43% Portfolio: CITYSecurities By Structure Report
City of Huntington Beach
Reporting Period:
01/31/2023
Page: 2 Report Run Date: Apr 11, 2023
28 Cash/Money Market/LGIP Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 01/31/2023
Cash/Money Market Account Activity
Accounting ID Description Activity Date Transaction Type Transaction Amount 003 California Asset Management Program 01/03/2023 Interest Received $64,970.12 Activity Total $64,970.12
982 LAIF 01/13/2023 Interest Received $3,393.02
Activity Total $3,393.02
29 Bond Redemption Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 01/31/2023
Redemption Transactions
Accounting ID Transaction
Type Cusip Description Price Settlement
Date Posted Date Par Value Principal Accrued Interest Total 4313 Maturity 037833DE7 AAPL 2.400 01/13/2023 100.00000 01/13/2023 01/13/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 30 Bond Purchase Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 01/31/2023
Purchase Transactions
Accounting ID Transaction
Type Cusip Description Price Settlement
Date Posted Date Par Value Principal Accrued Interest Total 4381 Buy 3135G04Z3 FNMA 0.500 06/17/2025 91.95000 01/13/2023 01/13/2023 5,000,000.00 $4,597,500.00 $1,805.56 $4,599,305.56 4382 Buy 717081DV2 PFE 2.750 06/03/2026 95.65600 01/18/2023 01/18/2023 5,000,000.00 $4,782,800.00 $17,187.50 $4,799,987.50 4383 Buy 3130AUHE7 FHLB 4.875 07/26/2023 100.05720 01/18/2023 01/18/2023 5,000,000.00 $5,002,860.00 $8,125.00 $5,010,985.00 4384 Buy 3130AUMC5 FHLB 3.750 07/20/2026 100.00000 01/19/2023 01/19/2023 5,000,000.00 $5,000,000.00 $0.00 $5,000,000.00 4380 Buy 3134GYCP5 FHLMC 5.000 07/23/2024 100.00000 01/23/2023 01/23/2023 5,000,000.00 $5,000,000.00 $0.00 $5,000,000.00 Activity Total 25,000,000.00 $24,383,160.00 $27,118.06 $24,410,278.06 31 Bond Interest Received Activity Report
Huntington Beach
Portfolio: CITY
Reporting Date: 01/31/2023
Bond Interest Received
Accounting ID Transaction Type Cusip Description Date Posted Interest Received Purchased Interest Adjustment Net Interest 4364 Interest Income 9128286Z8 T 1.750 06/30/2024 01/03/2023 $61,250.00 $61,250.00 4370 Interest Income 912828XX3 T 2.000 06/30/2024 01/03/2023 $50,000.00 $50,000.00 4379 Interest Income 91282CEW7 T 3.250 06/30/2027 01/03/2023 $81,250.00 $80,366.85 $883.15 4313 Interest Income 037833DE7 AAPL 2.400 01/13/2023 01/13/2023 $60,000.00 $60,000.00 4320 Interest Income 3130AKN36 FHLB 0.525 01/15/2026 01/17/2023 $13,125.00 $13,125.00 4290 Interest Income 45818WBX3 IADB 2.870 07/20/2023 01/20/2023 $57,400.00 $57,400.00 4321 Interest Income 3130AKN85 FHLB 0.550 01/20/2026 01/20/2023 $13,750.00 $13,750.00 4306 Interest Income 90331HNV1 USB 3.400 07/24/2023 01/24/2023 $34,000.00 $34,000.00 4371 Interest Income 459200KS9 IBM 4.000 07/27/2025 01/27/2023 $120,000.00 $9,333.33 $110,666.67 4325 Interest Income 91159HHX1 USB 2.400 07/30/2024 01/30/2023 $45,708.00 $45,708.00 4338 Interest Income 459058JE4 IBRD 0.376 07/28/2025 01/30/2023 $9,400.00 $9,400.00 4322 Interest Income 3130AKUS3 FHLB 0.500 01/28/2026 01/30/2023 $12,500.00 $12,500.00 4330 Interest Income 91282CAB7 T 0.250 07/31/2025 01/31/2023 $6,250.00 $6,250.00 4341 Interest Income 91282CCP4 T 0.625 07/31/2026 01/31/2023 $15,625.00 $15,625.00 4352 Interest Income 912828S92 T 1.250 07/31/2023 01/31/2023 $31,250.00 $31,250.00 4353 Interest Income 912828Y87 T 1.750 07/31/2024 01/31/2023 $43,750.00 $43,750.00 4357 Interest Income 91282CCN9 T 0.125 07/31/2023 01/31/2023 $3,125.00 $3,125.00 4358 Interest Income 912828Y87 T 1.750 07/31/2024 01/31/2023 $35,000.00 $35,000.00 Activity Total $693,383.00 $89,700.18 $603,682.82
32 Statement of Cash Receipts and Disbursements and
Cash Receipts and Disbursements December 2022 January 2023 Receipts
General Fund
Property Tax 23,693,577$ 16,811,848$
Local Sales Tax 4,237,274 3,480,191
Public Safety Sales Tax 290,139 245,574
Transient Occupancy Tax (TOT) 1,000,355 1,024,428
Utility Users Tax (UUT) 1,359,100 1,017,399
Other Revenue 4,242,624 3,955,832
Total General Fund Revenue 34,823,068 26,535,272
Total All Other Funds Revenue 19,732,658 30,812,081
Total Receipts 54,555,727$ 57,347,352$
Disbursements
General Fund
Personnel Services (16,439,936) (24,567,467)
Operating Expenses (4,141,076) (2,958,213)
Capital Expenditures - (105)
Non-Operating Expenses (465,427) -
Total General Fund Disbursements (21,046,440) (27,525,784) Total All Other Funds Disbursements (21,907,222) (18,654,619) Total Disbursements (42,953,662) (46,180,403)
Net Change in Cash Flow 11,602,065$ 11,166,949$
Summary of Cash by Fund December 2022 January 2023
General Fund 96,801,323$ 95,810,811$
General Fund Other 3,191,724 3,400,670
Capital Projects Funds 28,369,200 28,059,166
Debt Service Funds 22,693,504 39,311,943
Enterprise Funds 85,990,627 81,977,490
Trust and Agency Funds 7,406,322 7,169,566
Internal Service Funds 30,174,023 28,747,379
Special Revenue Funds 63,690,981 65,007,629
General Ledger Cash Balances * 338,317,705$ 349,484,654$ 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
January 2023
33