1 City of Huntington Beach
Quarterly Investment Report
December 2023
Prepared by:
Alisa Backstrom, MBA, CCMT, CPFIM
Elected City Treasurer
Colin Stevens, MPP
Treasury Manager
2 INVESTMENT PORTFOLIO SUMMARY
As of December 31, 2023
Currently, funds within this portfolio with overnight availability are invested in the California Asset Management Program “CAMP”. The CAMP account is considered a “Local Government Investment Pool” or “LGIP” for reporting purposes above. Other funds are invested in U.S. Treasuries, Supranationals (International Bank of Reconstruction and Development “IBRD”, Inter -American Development Bank “IADB”), U.S. Agencies, money market funds, and corporate bonds. Only the investment types allowed under California Government code Section 53601 and the City’s Investment Policy Statement are utilized.
Portfolio Statistics:
The current market value of the portfolio as of December 31, 2023, was $364.0 million versus a book value of $373.4 million. As investments are primarily held to maturity, the market value is only a point- in-time measurement, and no loss is realized. As of December 31, the portfolio book yield was 2.65%, with an effective duration of 1.64 and a weighted average maturity of 1.77 years.
Sector Breakdown:
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 19% of the total portfolio as of December 31, 2023. Cash held in the Local Government Investment Pools (“LGIP”) has been reduced as higher interest rates have become available in marketable securities.
Maturity Distribution:
As of December 31, 2023, approximately 37% of the portfolio matured in 0-1 year, with approximately 46% maturing from 1-3 years, and 17% maturing from 3-5 years.
3 INVESTMENT PORTFOLIO EARNINGS
As of December 31, 2023
Earnings for the month of December 2023 were $767,581, an increase of approximately 66% from the same month in the prior year. Fiscal year to date earnings of $4,581,569 were up approximately 105% 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 December was 2.56%, with
4 a fi scal year -to-date return of 2.58%. The benchmark has increased rapidly with the sharp ris e in interest rates through 2022 into 2023. At the end of December, the 12-month moving average of the interpolated 1.5-year U.S. Treasury was 4.85%. 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
October 1 to December 31, 2023
For the quarter ending December 31, 2023, one U.S. Treasury was purchased totaling $5.0 million, two Supranationals was purchased totaling $10.0 million, one U.S. Agency was purchased totaling $4.5 million, and two Corporate Bonds totaling $10 million were purchased. One U.S. Agency matured for $3.0 million, and $2.87 million in Corporate Bonds matured.
COMPLIANCE SUMMARY
As of December 31, 2023
There were no compliance issues during this period.
5 ECONOMIC AND MARKET OVERVIEW
The Federal Open Market C ommittee (FOMC) met in December to discuss the current state of the economy and to examine potential future interest rate adjustments. They concluded that the growth of economic activity has slowed from its strong pace in the third quarter and maintained the federal funds rate at 5.25 to 5.50 percent. In determining the extent of additional policy firming that may be appropriate to return inflation to 2 percent over time, the Committee will take into account the cumulative tightening of monetary policy, the lags with which monetary policy affects econom ic activity and inflation, and economic and financial developments.
Fixed Income / Equity Markets: The yield on the 10 -year U.S. Treasury finished the quarter at 3.88%, down from 4.59% at the end of September, with the 2 -year decreasing from 5.03% to 4.23% for the same period . While t he Treasury yield curve fe ll, it remained inverted. The S&P 500 increased by
11.24% and the DJIA increased by 12.48% respectively, for the quarter ending December 31.
Employment: Total nonfarm payroll employment rose by 216,000 in December, and the unemployment rate was little changed at 3.7 percent. Notable job gains occu rred in government, health care, social assistance, and construction.
Par Value Book Value Market Value Book Value
% of Port Book Yield Book Yield
Contribution
Days to
Maturity
Cash / Money Market
Local Govt Inv Pools (LGIP)
U.S. Treasuries
Supranational
U.S. Agencies
Corporates
Hold
Total
$1,209,450.90 $1,209,450.90 $1,209,450.90 0.32% 5.25% 0.02% 1 $31,891,026.62 $31,891,026.62 $31,891,026.62 8.54% 5.55% 0.47% 1 $73,000,000.00 $72,656,145.91 $70,349,700.00 19.46% 1.93% 0.38% 564 $35,000,000.00 $34,405,764.04 $33,574,200.00 9.21% 2.26% 0.21% 1,017 $182,980,000.00 $182,696,557.42 $177,068,676.60 48.93% 2.31% 1.13% 721 $51,571,000.00 $50,541,881.06 $49,956,448.85 13.54% 3.27% 0.44% 664 $375,651,477.52 $373,400,825.95 $364,049,502.97 100.00% 2.65% 646 Portfolio Investments
12/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 December 19, 2023. The investment program herein shown provides sufficient cash flow liquidity to meet the next six month's obligations. Market values are provided by US Bank via Interactive Data Corp (IDC) City Portfolio Certification
Fiscal YTD Transactions
Redemptions 0
Purchases 5
Total Activity 5
Period Transactions
Redemptions 10
Purchases 8
Total Activity 18
Net Period Earnings $4,581,569.04
Last FY Period Net Earnings $2,232,909.85
Avg Daily Book Balance $356,174,314.81
$1.00 $1.00
Net Effective Annual Return 2.575%
Net Period Earnings $767,580.82
Last FY Period Net Earnings $462,463.79
Avg Daily Book Balance $357,706,297.51
$1.00 $1.00
Net Effective Annual Return 2.563%
Fiscal YTD Summary (184 Days)Period Earnings Summary (31 Days) ______________________________________________ ____________________________ sum2
Total Market Value
$1.00
$364,049,502.97
sum2
Total Book Value
$2.00
$373,400,825.95
Market Value
Book Value
Par Value
Portfolio Summary
City of Huntington Beach
Portfolio: CITY
Reporting Date: (FY2024)
12/01/2023 - 12/31/2023
Full Accrual Basis
sum2
Total Par Value
$1.00
$375,651,477.52
The City Portfolio uses a 12 month moving average of the 1.5Yr Treasury for comparison purposes. This period, that rate is equal to: 4.850% ____________________________________________
6 Accounting ID Ticker Pool Description Type Par Value Book Value Market Value Rate % of Portfolio Rating 003
CAMP
California Asset Management Program
LGIP
31,891,026.62
31,891,026.62
31,891,026.62
5.55 8.54%
NR
104
FUZXX
First American Treasury Obligations
Cash/Money Market
1,209,450.90
1,209,450.90
1,209,450.90
5.25 0.32%
NR
CITY Fund Total 33,100,477.52 33,100,477.52 33,100,477.52 8.86% Portfolio: CITYCash By Fund Report
City of Huntington Beach
Reporting Period:
12/31/2023
Report Run Date: Jan 19, 2024 7
Accounting
ID CUSIP Ticker Coupon Maturity Date Short Description Trade Date Settlement Date Par Value Book Value Market Value Gain/Loss Book
Yield
Effective
Duration
Days to
Maturity
(%) of
Portfolio Mdy/S&P/Fitch
4364
9128286Z8
T
1.750
06/30/2024
U.S. Treasury Note
04/29/2022
05/02/2022
7,000,000.00
6,967,170.27
6,883,240.00
(83,930.27)
2.730
0.49 181
1.87%
Aaa/AA+/AA+
4370
912828XX3
T
2.000
06/30/2024
U.S. Treasury Note
05/26/2022
05/27/2022
5,000,000.00
4,988,909.31
4,922,050.00
(66,859.31)
2.462
0.49 181
1.34%
Aaa/AA+/AA+
4353
912828Y87
T
1.750
07/31/2024
U.S. Treasury Note
01/13/2022
01/14/2022
5,000,000.00
5,020,652.31
4,905,650.00
(115,002.31)
1.028
0.56 212
1.34%
Aaa/AA+/AA+
4358
912828Y87
T
1.750
07/31/2024
U.S. Treasury Note
02/10/2022
02/11/2022
4,000,000.00
4,003,510.59
3,924,520.00
(78,990.59)
1.595
0.56 212
1.07%
Aaa/AA+/AA+
4361
912828D56
T
2.375
08/15/2024
U.S. Treasury Note
03/21/2022
03/22/2022
5,000,000.00
5,004,044.33
4,918,350.00
(85,694.33)
2.240
0.60 227
1.34%
Aaa/AA+/AA+
4298
912828YH7
T
1.500
09/30/2024
U.S. Treasury Note
12/04/2019
12/05/2019
5,000,000.00
4,996,589.44
4,874,400.00
(122,189.44)
1.595
0.73 273
1.34%
Aaa/AA+/AA+
4350
912828YM6
T
1.500
10/31/2024
U.S. Treasury Note
12/30/2021
12/31/2021
3,000,000.00
3,014,248.35
2,918,670.00
(95,578.35)
0.920
0.81 304
0.81%
Aaa/AA+/AA+
4376
91282CEU1
T
2.875
06/15/2025
U.S. Treasury Note
11/17/2022
11/18/2022
3,000,000.00
2,942,668.95
2,932,020.00
(10,648.95)
4.276
1.40 531
0.79%
Aaa/AA+/AA+
4330
91282CAB7
T
0.250
07/31/2025
U.S. Treasury Note
05/18/2021
05/19/2021
5,000,000.00
4,971,563.75
4,682,600.00
(288,963.75)
0.615
1.54 577
1.33%
Aaa/AA+/AA+
4340
91282CAJ0
T
0.250
08/31/2025
U.S. Treasury Note
09/23/2021
09/27/2021
5,000,000.00
4,960,251.05
4,667,800.00
(292,451.05)
0.735
1.62 608
1.33%
Aaa/AA+/AA+
4351
9128284Z0
T
2.750
08/31/2025
U.S. Treasury Note
12/30/2021
12/31/2021
5,000,000.00
5,133,859.90
4,867,400.00
(266,459.90)
1.103
1.59 608
1.37%
Aaa/AA+/AA+
4341
91282CCP4
T
0.625
07/31/2026
U.S. Treasury Note
09/30/2021
09/30/2021
5,000,000.00
4,959,112.18
4,579,900.00
(379,212.18)
0.950
2.50 942
1.33%
Aaa/AA+/AA+
4339
91282CCW9
T
0.750
08/31/2026
U.S. Treasury Note
09/23/2021
09/23/2021
1,000,000.00
996,357.32
916,800.00
(79,557.32)
0.890
2.57 973
0.27%
Aaa/AA+/AA+
4342
91282CCW9
T
0.750
08/31/2026
U.S. Treasury Note
11/22/2021
11/23/2021
5,000,000.00
4,931,053.57
4,584,000.00
(347,053.57)
1.285
2.57 973
1.32%
Aaa/AA+/AA+
4379
91282CEW7
T
3.250
06/30/2027
U.S. Treasury Note
12/28/2022
12/29/2022
5,000,000.00
4,881,054.14
4,886,150.00
5,095.86
4.000
3.25 1,276
1.31%
Aaa/AA+/AA+
4406
91282CEW7
T
3.250
06/30/2027
U.S. Treasury Note
12/21/2023
12/22/2023
5,000,000.00
4,885,100.47
4,886,150.00
1,049.53
3.960
3.25 1,276
1.31%
Aaa/AA+/AA+
U.S. Treasuries 73,000,000.00 72,656,145.91 70,349,700.00 (2,306,445.91) 19.46% 4323
459056HV2
IBRD
1.500
08/28/2024
Int'l Bank for Recon and Dev
04/21/2021
04/23/2021
5,000,000.00
5,035,087.80
4,885,000.00
(150,087.80)
0.425
0.64 240
1.35%
Aaa/AAA/AAA
4338
459058JE4
IBRD
0.376
07/28/2025
Int'l Bank for Recon and Dev
07/28/2021
07/30/2021
5,000,000.00
4,983,833.80
4,688,150.00
(295,683.80)
0.583
1.53 574
1.33%
Aaa/AAA/AAA
4319
459058JL8
IBRD
0.500
10/28/2025
Int'l Bank for Recon and Dev
01/08/2021
01/12/2021
5,000,000.00
4,998,953.22
4,659,700.00
(339,253.22)
0.512
1.77 666
1.34%
Aaa/AAA/AAA
4324
45906M2L4
IBRD
0.650
02/24/2026
Int'l Bank for Recon and Dev
04/28/2021
04/30/2021
5,000,000.00
4,976,908.07
4,603,800.00
(373,108.07)
0.870
2.08 785
1.33%
Aaa/AAA/AAA
4401
45818WEQ5
IADB
3.800
06/09/2028
Inter-American Development Bank
09/19/2023
09/21/2023
5,000,000.00
4,837,517.84
4,946,250.00
108,732.16
4.622
4.02 1,621
1.30%
Aaa/AAA/AAA
4402
459058KT9
IBRD
3.500
07/12/2028
Int'l Bank for Recon and Dev
11/09/2023
11/13/2023
5,000,000.00
4,746,461.58
4,895,650.00
149,188.42
4.760
4.06 1,654
1.27%
Aaa/AAA/AAA
4403
459058KT9
IBRD
3.500
07/12/2028
Int'l Bank for Recon and Dev
12/04/2023
12/06/2023
5,000,000.00
4,827,001.72
4,895,650.00
68,648.28
4.350
4.06 1,654
1.29%
Aaa/AAA/AAA
Supranational 35,000,000.00 34,405,764.04 33,574,200.00 (831,564.04) 9.21% 4387
3130AUXN9
FHLB
5.000
02/15/2024
Federal Home Loan Bank
04/24/2023
04/25/2023
3,000,000.00
3,000,241.24
2,998,260.00
(1,981.24)
4.923
0.12 45
0.80%
Aaa/AA+/NR
4292
3133ECHX5
FFCB
2.260
03/13/2024
Federal Farm Credit Bank
05/22/2019
05/23/2019
5,000,000.00
5,000,224.74
4,969,550.00
(30,674.74)
2.236
0.19 72
1.34%
Aaa/AA+/AA+
4378
3130ATVC8
FHLB
4.875
06/14/2024
Federal Home Loan Bank
12/27/2022
12/28/2022
5,000,000.00
5,002,711.50
4,992,300.00
(10,411.50)
4.740
0.44 165
1.34%
Aaa/AA+/NR
4348
3130AQD42
FHLB
0.920
06/28/2024
Federal Home Loan Bank
12/14/2021
12/28/2021
5,000,000.00
5,000,000.00
4,898,300.00
(101,700.00)
0.920
0.48 179
1.34%
Aaa/AA+/NR
4380
3134GYCP5
FHLMC
5.000
07/23/2024
Freddie Mac
01/05/2023
01/23/2023
5,000,000.00
5,000,000.00
4,997,650.00
(2,350.00)
5.000
0.54 204
1.34%
Aaa/AA+/AA+
4344
3130AQ3C5
FHLB
1.000
08/28/2024
Federal Home Loan Bank
12/01/2021
12/02/2021
4,000,000.00
4,000,000.00
3,894,920.00
(105,080.00)
1.000
0.64 240
1.07%
Aaa/AA+/NR
4373
3133XVDG3
FHLB
4.375
09/13/2024
Federal Home Loan Bank
09/22/2022
09/23/2022
5,000,000.00
5,004,454.37
4,976,050.00
(28,404.37)
4.240
0.68 256
1.34%
Aaa/AA+/NR
4336
3130AMXJ6
FHLB
0.500
09/30/2024
Federal Home Loan Bank
06/17/2021
06/30/2021
5,000,000.00
5,000,000.00
4,834,400.00
(165,600.00)
0.500
0.73 273
1.34%
Aaa/AA+/NR
4346
3130AQD59
FHLB
1.000
09/30/2024
Federal Home Loan Bank
12/14/2021
12/30/2021
5,000,000.00
5,000,000.00
4,853,300.00
(146,700.00)
1.000
0.73 273
1.34%
Aaa/AA+/NR
4349
3130AQD59
FHLB
1.000
09/30/2024
Federal Home Loan Bank
12/22/2021
12/30/2021
5,000,000.00
5,000,000.00
4,853,300.00
(146,700.00)
1.000
0.73 273
1.34%
Aaa/AA+/NR
4334
3130AMW65
FHLB
0.500
12/30/2024
Federal Home Loan Bank
06/15/2021
06/30/2021
5,000,000.00
5,000,000.00
4,787,000.00
(213,000.00)
0.500
0.97 364
1.34%
Aaa/AA+/NR
4332
3130AMQ62
FHLB
0.625
03/14/2025
Federal Home Loan Bank
05/26/2021
06/14/2021
5,000,000.00
5,000,000.00
4,784,450.00
(215,550.00)
0.625
1.17 438
1.34%
Aaa/AA+/NR
4397
3130AWER7
FHLB
4.625
06/06/2025
Federal Home Loan Bank
06/14/2023
06/15/2023
3,000,000.00
2,998,631.01
3,016,740.00
18,108.99
4.659
1.37 522
0.80%
Aaa/AA+/NR
4329
3135G04Z3
FNMA
0.500
06/17/2025
Fannie Mae
05/13/2021
05/14/2021
5,000,000.00
4,990,769.11
4,718,200.00
(272,569.11)
0.628
1.42 533
1.34%
Aaa/AA+/AA+
4381
3135G04Z3
FNMA
0.500
06/17/2025
Fannie Mae
01/12/2023
01/13/2023
5,000,000.00
4,757,763.16
4,718,200.00
(39,563.16)
4.013
1.42 533
1.27%
Aaa/AA+/AA+
4345
3130AQ5S8
FHLB
1.250
06/30/2025
Federal Home Loan Bank
12/08/2021
12/30/2021
4,650,000.00
4,650,000.00
4,439,727.00
(210,273.00)
1.250
1.45 546
1.25%
Aaa/AA+/NR
4327
3130AMDL3
FHLB
0.800
07/25/2025
Federal Home Loan Bank
05/11/2021
05/25/2021
5,000,000.00
5,000,000.00
4,729,650.00
(270,350.00)
0.800
1.52 571
1.34%
Aaa/AA+/NR
4360
3130AQT94
FHLB
1.600
08/28/2025
Federal Home Loan Bank
03/03/2022
03/04/2022
4,575,000.00
4,559,209.14
4,371,961.50
(187,247.64)
1.816
1.60 605
1.22%
Aaa/AA+/NR
4331
3130AMQ54
FHLB
0.700
09/16/2025
Federal Home Loan Bank
05/26/2021
06/16/2021
5,000,000.00
5,000,000.00
4,692,800.00
(307,200.00)
0.700
1.66 624
1.34%
Aaa/AA+/NR
4318
3135GA2Z3
FNMA
0.560
11/17/2025
Fannie Mae
01/08/2021
01/11/2021
3,000,000.00
3,001,277.66
2,786,820.00
(214,457.66)
0.500
1.83 686
0.80%
Aaa/AA+/AA+
4320
3130AKN36
FHLB
0.525
01/15/2026
Federal Home Loan Bank
01/14/2021
01/15/2021
5,000,000.00
4,997,961.11
4,631,150.00
(366,811.11)
0.545
1.98 745
1.34%
Aaa/AA+/NR
4321
3130AKN85
FHLB
0.550
01/20/2026
Federal Home Loan Bank
01/14/2021
01/20/2021
5,000,000.00
4,998,973.61
4,631,150.00
(367,823.61)
0.560
1.99 750
1.34%
Aaa/AA+/NR
4322
3130AKUS3
FHLB
0.500
01/28/2026
Federal Home Loan Bank
01/26/2021
01/28/2021
5,000,000.00
5,000,000.00
4,622,400.00
(377,600.00)
0.500
2.01 758
1.34%
Aaa/AA+/NR
4333
3130ALEY6
FHLB
0.800
03/04/2026
Federal Home Loan Bank
06/09/2021
06/10/2021
5,000,000.00
5,000,000.00
4,632,150.00
(367,850.00)
0.800
2.10 793
1.34%
Aaa/AA+/NR
4328
3130AMJN3
FHLB
1.030
05/26/2026
Federal Home Loan Bank
05/12/2021
05/26/2021
5,000,000.00
5,000,000.00
4,624,400.00
(375,600.00)
1.030
2.32 876
1.34%
Aaa/AA+/NR
4335
3130AMFS6
FHLB
0.750
06/12/2026
Federal Home Loan Bank
06/16/2021
06/17/2021
5,000,000.00
4,985,275.77
4,605,350.00
(379,925.77)
0.873
2.37 893
1.34%
Aaa/AA+/NR
4388
3130AVWS7
FHLB
3.750
06/12/2026
Federal Home Loan Bank
05/08/2023
05/09/2023
3,000,000.00
2,996,699.22
2,973,540.00
(23,159.22)
3.796
2.30 893
0.80%
Aaa/AA+/NR
Portfolio: CITYBond Holdings By Sector Report
City of Huntington Beach
Reporting Period:
12/31/2023
Report Run Date: Jan 19, 2024
8 Accounting
ID CUSIP Ticker Coupon Maturity Date Short Description Trade Date Settlement Date Par Value Book Value Market Value Gain/Loss Book
Yield
Effective
Duration
Days to
Maturity
(%) of
Portfolio Mdy/S&P/Fitch
4398
3133EPNG6
FFCB
4.375
06/23/2026
Federal Farm Credit Bank
06/22/2023
06/23/2023
3,000,000.00
2,998,885.00
3,013,320.00
14,435.00
4.391
2.32 904
0.80%
Aaa/AA+/AA+
4347
3130AQ7E7
FHLB
1.500
06/30/2026
Federal Home Loan Bank
12/14/2021
12/30/2021
5,000,000.00
5,001,109.88
4,666,250.00
(334,859.88)
1.339
2.39 911
1.34%
Aaa/AA+/NR
4384
3130AUMC5
FHLB
3.750
07/20/2026
Federal Home Loan Bank
01/17/2023
01/19/2023
5,000,000.00
5,000,000.00
4,950,400.00
(49,600.00)
3.750
2.36 931
1.34%
Aaa/AA+/NR
4356
3130AQS79
FHLB
1.375
08/07/2026
Federal Home Loan Bank
01/27/2022
02/07/2022
5,000,000.00
5,000,000.00
4,719,400.00
(280,600.00)
1.375
2.46 949
1.34%
Aaa/AA+/NR
4386
3133EPGT6
FFCB
3.875
04/26/2027
Federal Farm Credit Bank
04/21/2023
04/26/2023
5,000,000.00
4,995,228.30
4,971,100.00
(24,128.30)
3.906
3.05 1,211
1.34%
Aaa/AA+/AA+
4389
3133EPJP1
FFCB
3.625
05/12/2027
Federal Farm Credit Bank
05/08/2023
05/12/2023
5,000,000.00
4,988,352.53
4,932,250.00
(56,102.53)
3.700
3.10 1,227
1.34%
Aaa/AA+/AA+
4392
3130AW4N7
FHLB
3.630
06/04/2027
Federal Home Loan Bank
05/16/2023
05/18/2023
5,000,000.00
5,000,000.00
4,936,750.00
(63,250.00)
3.630
3.16 1,250
1.34%
Aaa/AA+/NR
4396
3133EPMV4
FFCB
4.125
06/15/2027
Federal Farm Credit Bank
06/09/2023
06/15/2023
5,000,000.00
4,999,179.31
5,011,300.00
12,120.69
4.130
3.17 1,261
1.34%
Aaa/AA+/AA+
4385
3134GYPF3
FHLMC
4.750
07/12/2027
Freddie Mac
04/21/2023
04/24/2023
3,300,000.00
3,295,855.43
3,268,617.00
(27,238.43)
4.791
1.49 1,288
0.88%
Aaa/AA+/AA+
4405
3130AWWN6
FHLB
4.500
09/10/2027
Federal Home Loan Bank
12/04/2023
12/05/2023
4,455,000.00
4,472,128.51
4,528,151.10
56,022.59
4.383
3.31 1,348
1.20%
Aaa/AA+/NR
4395
3130AWC24
FHLB
4.000
06/09/2028
Federal Home Loan Bank
06/09/2023
06/13/2023
5,000,000.00
5,004,092.87
5,017,500.00
13,407.13
3.979
4.01 1,621
1.34%
Aaa/AA+/NR
4399
3130AWC24
FHLB
4.000
06/09/2028
Federal Home Loan Bank
06/26/2023
06/27/2023
5,000,000.00
4,997,533.95
5,017,500.00
19,966.05
4.012
4.01 1,621
1.34%
Aaa/AA+/NR
4400
31422X5U2
FAMCA
5.100
08/07/2028
Farmer Mac
08/02/2023
08/07/2023
2,000,000.00
2,000,000.00
2,002,420.00
2,420.00
5.100
2.22 1,680
0.54%
NR/NR/NR
U.S. Agencies 182,980,000.00 182,696,557.42 177,068,676.60 (5,627,880.82) 48.93% 4355
67066GAL8
NVDA
0.584
06/14/2024
Nvidia
01/20/2022
01/24/2022
5,000,000.00
4,985,187.85
4,892,450.00
(92,737.85)
1.250
0.44 165
1.34%
A1/A+/
4325
91159HHX1
USB
2.400
07/30/2024
US Bank
04/28/2021
04/30/2021
3,809,000.00
3,848,872.09
3,743,142.39
(105,729.70)
0.528
0.56 211
1.03%
A3/A/A
4343
14913R2P1
CAT
0.600
09/13/2024
Caterpillar
11/30/2021
12/02/2021
5,000,000.00
4,986,896.50
4,840,450.00
(146,446.50)
0.980
0.68 256
1.34%
A2/A/A+
4371
459200KS9
IBM
4.000
07/27/2025
IBM
08/09/2022
08/11/2022
6,000,000.00
6,016,725.14
5,933,700.00
(83,025.14)
3.810
1.48 573
1.61%
A3/A-/NR
4372
931142EW9
WMT
3.900
09/09/2025
Walmart
09/20/2022
09/22/2022
5,000,000.00
4,980,284.16
4,950,300.00
(29,984.16)
4.150
1.60 617
1.33%
Aa2/AA/AA
4382
717081DV2
PFE
2.750
06/03/2026
Pfizer Inc
01/13/2023
01/18/2023
5,000,000.00
4,844,116.54
4,792,850.00
(51,266.54)
4.142
2.29 884
1.30%
A2/A/A
4375
110122CN6
BMY
3.200
06/15/2026
Bristol-Myers Squibb
11/14/2022
11/16/2022
5,000,000.00
4,856,187.12
4,851,400.00
(4,787.12)
4.480
2.28 896
1.30%
A2/A/
4390
931142EM1
WMT
3.050
07/08/2026
Walmart
05/11/2023
05/15/2023
4,257,000.00
4,186,525.57
4,130,269.11
(56,256.46)
3.752
2.31 919
1.12%
Aa2/AA/AA
4391
904764AU1
UNANA
2.000
07/28/2026
Unilever
05/11/2023
05/15/2023
2,505,000.00
2,399,426.44
2,360,887.35
(38,539.09)
3.752
2.43 939
0.64%
A1/A+/A
4404
037833DN7
AAPL
2.050
09/11/2026
Apple
12/04/2023
12/06/2023
5,000,000.00
4,682,678.39
4,709,900.00
27,221.61
4.583
2.54 984
1.25%
Aaa/AA+/
4407
713448DN5
PEP
2.375
10/06/2026
Pepsi
12/21/2023
12/26/2023
5,000,000.00
4,754,981.25
4,751,100.00
(3,881.25)
4.273
2.58 1,009
1.27%
A1/A+/WD
Corporates 51,571,000.00 50,541,881.06 49,956,448.85 (585,432.21) 13.54% Bond Holdings 342,551,000.00 340,300,348.43 330,949,025.45 (9,351,322.98) 91.14% Portfolio: CITYBond Holdings By Sector Report
City of Huntington Beach
Reporting Period:
12/31/2023
Report Run Date: Jan 19, 2024 9
Cash/Money Market/LGIP Activity Report
City of Huntington Beach
Portfolio: CITY
Reporting Date: 12/31/2023
Cash/Money Market Account Activity
Accounting ID Description Activity Date Transaction Type Transaction Amount 003 California Asset Management Program 12/05/2023 Withdrawal ($6,600,000.00) 003 California Asset Management Program 12/01/2023 Interest Received $142,425.88 003 California Asset Management Program 12/11/2023 Withdrawal ($6,000,000.00) 003 California Asset Management Program 12/27/2023 Deposit $12,000,000.00 Activity Total ($457,574.12)
104 First American Treasury Obligations 12/04/2023 Deposit $4,159,500.00 104 First American Treasury Obligations 12/06/2023 Withdrawal ($7,543,415.21) 104 First American Treasury Obligations 12/07/2023 Deposit $84,263.34 104 First American Treasury Obligations 12/01/2023 Interest Received $1,379.63 104 First American Treasury Obligations 12/11/2023 Deposit $303,888.89 104 First American Treasury Obligations 12/12/2023 Deposit $18,750.00 104 First American Treasury Obligations 12/13/2023 Deposit $67,812.50 104 First American Treasury Obligations 12/14/2023 Deposit $136,475.00 104 First American Treasury Obligations 12/15/2023 Deposit $226,250.00 104 First American Treasury Obligations 12/18/2023 Deposit $25,000.00 104 First American Treasury Obligations 12/21/2023 Deposit $0.88 104 First American Treasury Obligations 12/22/2023 Deposit $5,038,524.18 104 First American Treasury Obligations 12/26/2023 Withdrawal ($4,714,513.89) 104 First American Treasury Obligations 12/28/2023 Deposit $23,000.00 Activity Total ($2,173,084.68)
10 Bond Redemption Activity Report
City of Huntington Beach
Portfolio: CITY
Reporting Date: 12/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
11 Bond Purchase Activity Report
City of Huntington Beach
Portfolio: CITY
Reporting Date: 12/31/2023
Purchase Transactions
Accounting ID Transaction
Type Cusip Description Price Settlement
Date Posted Date Par Value Principal Accrued Interest Total 4405 Buy 3130AWWN6 FHLB 4.500 09/10/2027 100.39200 12/05/2023 12/05/2023 4,455,000.00 $4,472,463.60 $60,699.38 $4,533,162.98 4403 Buy 459058KT9 IBRD 3.500 07/12/2028 96.48700 12/06/2023 12/06/2023 5,000,000.00 $4,824,350.00 $70,000.00 $4,894,350.00 4404 Buy 037833DN7 AAPL 2.050 09/11/2026 93.49000 12/06/2023 12/06/2023 5,000,000.00 $4,674,500.00 $24,201.39 $4,698,701.39 4406 Buy 91282CEW7 T 3.250 06/30/2027 97.68400 12/22/2023 12/22/2023 5,000,000.00 $4,884,200.00 $77,275.82 $4,961,475.82 4407 Buy 713448DN5 PEP 2.375 10/06/2026 95.07500 12/26/2023 12/26/2023 5,000,000.00 $4,753,750.00 $26,388.89 $4,780,138.89 Activity Total 24,455,000.00 $23,609,263.60 $258,565.48 $23,867,829.08 12 Bond Interest Received Activity Report
City of Huntington Beach
Portfolio: CITY
Reporting Date: 12/31/2023
Bond Interest Received
Accounting ID Transaction Type Cusip Description Date Posted Interest Received Purchased Interest Adjustment Net Interest 4382 Interest Income 717081DV2 PFE 2.750 06/03/2026 12/04/2023 $68,750.00 $68,750.00 4392 Interest Income 3130AW4N7 FHLB 3.630 06/04/2027 12/04/2023 $90,750.00 $90,750.00 4397 Interest Income 3130AWER7 FHLB 4.625 06/06/2025 12/06/2023 $67,062.50 $1,156.25 $65,906.25 4395 Interest Income 3130AWC24 FHLB 4.000 06/09/2028 12/11/2023 $104,444.44 $6,666.67 $97,777.77 4399 Interest Income 3130AWC24 FHLB 4.000 06/09/2028 12/11/2023 $104,444.45 $14,444.44 $90,000.01 4401 Interest Income 45818WEQ5 IADB 3.800 06/09/2028 12/11/2023 $95,000.00 $53,833.33 $41,166.67 4335 Interest Income 3130AMFS6 FHLB 0.750 06/12/2026 12/12/2023 $18,750.00 $18,750.00 4388 Interest Income 3130AVWS7 FHLB 3.750 06/12/2026 12/12/2023 $67,812.50 $1,250.00 $66,562.50 4355 Interest Income 67066GAL8 NVDA 0.584 06/14/2024 12/14/2023 $14,600.00 $14,600.00 4378 Interest Income 3130ATVC8 FHLB 4.875 06/14/2024 12/14/2023 $121,875.00 $121,875.00 4375 Interest Income 110122CN6 BMY 3.200 06/15/2026 12/15/2023 $80,000.00 $80,000.00 4376 Interest Income 91282CEU1 T 2.875 06/15/2025 12/15/2023 $43,125.00 $43,125.00 4396 Interest Income 3133EPMV4 FFCB 4.125 06/15/2027 12/15/2023 $103,125.00 $103,125.00 4381 Interest Income 3135G04Z3 FNMA 0.500 06/17/2025 12/18/2023 $12,500.00 $12,500.00 4329 Interest Income 3135G04Z3 FNMA 0.500 06/17/2025 12/18/2023 $12,500.00 $12,500.00 4398 Interest Income 3133EPNG6 FFCB 4.375 06/23/2026 12/26/2023 $65,625.00 $65,625.00 4348 Interest Income 3130AQD42 FHLB 0.920 06/28/2024 12/28/2023 $23,000.00 $23,000.00 Activity Total $1,093,363.89 $77,350.69 $1,016,013.20
13 Statement of Cash Receipts and Disbursements and
Cash Receipts and Disbursements November 2023 December 2023 Receipts
General Fund
Property Tax 13,791,928$ 23,817,212$
Local Sales Tax 3,944,653 3,996,591
Public Safety Sales Tax 244,768 285,478
Transient Occupancy Tax (TOT) 1,419,750 1,072,762
Utility Users Tax (UUT) 2,091,183 1,642,396
Other Revenue 5,396,567 4,462,678
Total General Fund Revenue 26,888,849 35,277,117
Total All Other Funds Revenue 24,250,676 22,491,481
Total Receipts 51,139,525$ 57,768,599$
Disbursements
General Fund
Personnel Services (12,831,863) (16,299,110)
Operating Expenses (4,421,467) (3,789,596)
Capital Expenditures - -
Non-Operating Expenses (5,688) (466,907)
Total General Fund Disbursements (17,259,018) (20,555,613) Total All Other Funds Disbursements (20,257,979) (26,181,844) Total Disbursements (37,516,996) (46,737,457)
Net Change in Cash Flow 13,622,529$ 11,031,142$
Summary of Cash by Fund November 2023 December 2023
General Fund 69,130,451$ 83,851,956$
General Fund Other 5,453,511 5,361,116
Capital Projects Funds 67,221,273 67,553,371
Debt Service Funds 31,743,448 29,577,241
Enterprise Funds 80,368,509 81,583,428
Trust and Agency Funds 2,965,717 3,362,860
Internal Service Funds 54,838,545 52,107,813
Special Revenue Funds 50,698,369 50,053,181
General Ledger Cash Balances * 362,419,825$ 373,450,966$ Total cash will differ from investment portfolio total due to outstanding checks and/or other timing differences.
Note: Above information was obtained from the City's accounting system records. The above information includes receipts from maturing investments and payments for purchased investments in the city investment portfolio. This statement is prepared in compliance with the City's Charter.
Summary of Cash by Fund
City Treasurer's Office
December 2023
14 Par Value Book Value Market Value Book Value
% of Port Book Yield Book Yield
Contribution
Days to
Maturity
Cash / Money Market
Local Govt Inv Pools (LGIP)
U.S. Treasuries
Supranational
U.S. Agencies
Corporates
Hold
Total
$3,382,535.58 $3,382,535.58 $3,382,535.58 0.96% 5.24% 0.05% 1 $32,348,600.74 $32,348,600.74 $32,348,600.74 9.18% 5.58% 0.51% 1 $68,000,000.00 $67,762,050.02 $64,952,040.00 19.23% 1.79% 0.34% 543 $30,000,000.00 $29,573,690.62 $28,321,850.00 8.39% 1.92% 0.16% 943 $178,525,000.00 $178,209,322.88 $170,869,247.00 50.58% 2.26% 1.14% 736 $41,571,000.00 $41,089,581.13 $40,200,737.02 11.66% 3.00% 0.35% 619 $353,827,136.32 $352,365,780.96 $340,075,010.34 100.00% 2.56% 628 Portfolio Investments
11/30/2023
Date
City Treasurer
TitleAlisa Backstrom
I certify that this report and the corresponding pages attached accurately reflect all portfolio combined investments and conforms with all California state statutes and the Huntington Beach investment policy filed on January 17, 2023. The investment program herein shown provides sufficient cash flow liquidity to meet the next six month's obligations. Market values are provided by US Bank via Interactive Data Corp (IDC) City Portfolio Certification
Fiscal YTD Transactions
Redemptions 0
Purchases 1
Total Activity 1
Period Transactions
Redemptions 10
Purchases 3
Total Activity 13
Net Period Earnings $3,813,988.22
Last FY Period Net Earnings $1,770,450.23
Avg Daily Book Balance $355,867,918.27
$1.00 $1.00
Net Effective Annual Return 2.583%
Net Period Earnings $723,286.07
Last FY Period Net Earnings $415,620.82
Avg Daily Book Balance $346,087,376.15
$1.00 $1.00
Net Effective Annual Return 2.580%
Fiscal YTD Summary (153 Days)Period Earnings Summary (30 Days) ______________________________________________ ____________________________ sum2
Total Market Value
$1.00
$340,075,010.34
sum2
Total Book Value
$2.00
$352,365,780.96
Market Value
Book Value
Par Value
Portfolio Summary
City of Huntington Beach
Portfolio: CITY
Reporting Date: (FY2024)
11/01/2023 - 11/30/2023
Full Accrual Basis
sum2
Total Par Value
$1.00
$353,827,136.32
The City Portfolio uses a 12 month moving average of the 1.5Yr Treasury for comparison purposes. This period, that rate is equal to: 4.860% ____________________________________________
15 Accounting ID Ticker Pool Description Type Par Value Book Value Market Value Rate % of Portfolio Rating 003
CAMP
California Asset Management Program
LGIP
32,348,600.74
32,348,600.74
32,348,600.74
5.58 9.18%
NR
104
FUZXX
First American Treasury Obligations
Cash/Money Market
3,382,535.58
3,382,535.58
3,382,535.58
5.24 0.96%
NR
CITY Fund Total 35,731,136.32 35,731,136.32 35,731,136.32 10.14% Portfolio: CITYCash By Fund Report
City of Huntington Beach
Reporting Period:
11/30/2023
Report Run Date: Dec 22, 2023 16
Accounting
ID CUSIP Ticker Coupon Maturity Date Short Description Trade Date Settlement Date Par Value Book Value Market Value Gain/Loss Book
Yield
Effective
Duration
Days to
Maturity
(%) of
Portfolio
Moodys
Rating
S&P
Rating
Fitch
Rating
4364
9128286Z8
T
1.750
06/30/2024
U.S. Treasury Note
04/29/2022
05/02/2022
7,000,000.00
6,961,547.49
6,858,110.00
(103,437.49)
2.730
0.56 212
1.98%
Aaa
AA+
AA+
4370
912828XX3
T
2.000
06/30/2024
U.S. Treasury Note
05/26/2022
05/27/2022
5,000,000.00
4,987,009.80
4,904,900.00
(82,109.80)
2.462
0.56 212
1.42%
Aaa
AA+
AA+
4353
912828Y87
T
1.750
07/31/2024
U.S. Treasury Note
01/13/2022
01/14/2022
5,000,000.00
5,023,672.23
4,884,550.00
(139,122.23)
1.028
0.65 243
1.43%
Aaa
AA+
AA+
4358
912828Y87
T
1.750
07/31/2024
U.S. Treasury Note
02/10/2022
02/11/2022
4,000,000.00
4,004,023.93
3,907,640.00
(96,383.93)
1.595
0.65 243
1.14%
Aaa
AA+
AA+
4361
912828D56
T
2.375
08/15/2024
U.S. Treasury Note
03/21/2022
03/22/2022
5,000,000.00
5,004,596.64
4,898,450.00
(106,146.64)
2.240
0.68 258
1.42%
Aaa
AA+
AA+
4298
912828YH7
T
1.500
09/30/2024
U.S. Treasury Note
12/04/2019
12/05/2019
5,000,000.00
4,996,202.16
4,848,650.00
(147,552.16)
1.595
0.81 304
1.42%
Aaa
AA+
AA+
4350
912828YM6
T
1.500
10/31/2024
U.S. Treasury Note
12/30/2021
12/31/2021
3,000,000.00
3,015,701.30
2,900,400.00
(115,301.30)
0.920
0.89 335
0.86%
Aaa
AA+
AA+
4376
91282CEU1
T
2.875
06/15/2025
U.S. Treasury Note
11/17/2022
11/18/2022
3,000,000.00
2,939,321.94
2,910,600.00
(28,721.94)
4.276
1.46 562
0.83%
Aaa
AA+
AA+
4330
91282CAB7
T
0.250
07/31/2025
U.S. Treasury Note
05/18/2021
05/19/2021
5,000,000.00
4,970,035.98
4,636,150.00
(333,885.98)
0.615
1.62 608
1.41%
Aaa
AA+
AA+
4340
91282CAJ0
T
0.250
08/31/2025
U.S. Treasury Note
09/23/2021
09/27/2021
5,000,000.00
4,958,224.37
4,621,100.00
(337,124.37)
0.735
1.70 639
1.41%
Aaa
AA+
AA+
4351
9128284Z0
T
2.750
08/31/2025
U.S. Treasury Note
12/30/2021
12/31/2021
5,000,000.00
5,140,684.99
4,828,900.00
(311,784.99)
1.103
1.67 639
1.46%
Aaa
AA+
AA+
4341
91282CCP4
T
0.625
07/31/2026
U.S. Treasury Note
09/30/2021
09/30/2021
5,000,000.00
4,957,766.62
4,517,000.00
(440,766.62)
0.950
2.57 973
1.41%
Aaa
AA+
AA+
4339
91282CCW9
T
0.750
08/31/2026
U.S. Treasury Note
09/23/2021
09/23/2021
1,000,000.00
996,241.26
904,140.00
(92,101.26)
0.890
2.65 1,004
0.28%
Aaa
AA+
AA+
4342
91282CCW9
T
0.750
08/31/2026
U.S. Treasury Note
11/22/2021
11/23/2021
5,000,000.00
4,928,856.92
4,520,700.00
(408,156.92)
1.285
2.65 1,004
1.40%
Aaa
AA+
AA+
4379
91282CEW7
T
3.250
06/30/2027
U.S. Treasury Note
12/28/2022
12/29/2022
5,000,000.00
4,878,164.39
4,810,750.00
(67,414.39)
4.000
3.27 1,307
1.38%
Aaa
AA+
AA+
U.S. Treasuries 68,000,000.00 67,762,050.02 64,952,040.00 (2,810,010.02) 19.23% 4323
459056HV2
IBRD
1.500
08/28/2024
Int'l Bank for Recon and Dev
04/21/2021
04/23/2021
5,000,000.00
5,039,529.29
4,862,550.00
(176,979.29)
0.425
0.72 271
1.43%
Aaa
AAA
AAA
4338
459058JE4
IBRD
0.376
07/28/2025
Int'l Bank for Recon and Dev
07/28/2021
07/30/2021
5,000,000.00
4,982,978.44
4,642,200.00
(340,778.44)
0.583
1.61 605
1.41%
Aaa
AAA
AAA
4319
459058JL8
IBRD
0.500
10/28/2025
Int'l Bank for Recon and Dev
01/08/2021
01/12/2021
5,000,000.00
4,998,905.42
4,610,450.00
(388,455.42)
0.512
1.85 697
1.42%
Aaa
AAA
AAA
4324
45906M2L4
IBRD
0.650
02/24/2026
Int'l Bank for Recon and Dev
04/28/2021
04/30/2021
5,000,000.00
4,976,011.88
4,547,550.00
(428,461.88)
0.870
2.16 816
1.41%
Aaa
AAA
AAA
4401
45818WEQ5
IADB
3.800
06/09/2028
Inter-American Development Bank
09/19/2023
09/21/2023
5,000,000.00
4,834,467.49
4,856,650.00
22,182.51
4.622
4.01 1,652
1.37%
Aaa
AAA
AAA
4402
459058KT9
IBRD
3.500
07/12/2028
Int'l Bank for Recon and Dev
11/09/2023
11/13/2023
5,000,000.00
4,741,798.09
4,802,450.00
60,651.91
4.760
4.12 1,685
1.35%
Aaa
AAA
AAA
Supranational 30,000,000.00 29,573,690.62 28,321,850.00 (1,251,840.62) 8.39% 4387
3130AUXN9
FHLB
5.000
02/15/2024
Federal Home Loan Bank
04/24/2023
04/25/2023
3,000,000.00
3,000,405.72
2,996,100.00
(4,305.72)
4.923
0.21 76
0.85%
Aaa
AA+
NR
4292
3133ECHX5
FFCB
2.260
03/13/2024
Federal Farm Credit Bank
05/22/2019
05/23/2019
5,000,000.00
5,000,318.38
4,955,900.00
(44,418.38)
2.236
0.28 103
1.42%
Aaa
AA+
AA+
4378
3130ATVC8
FHLB
4.875
06/14/2024
Federal Home Loan Bank
12/27/2022
12/28/2022
5,000,000.00
5,003,210.55
4,985,350.00
(17,860.55)
4.740
0.51 196
1.42%
Aaa
AA+
NR
4348
3130AQD42
FHLB
0.920
06/28/2024
Federal Home Loan Bank
12/14/2021
12/28/2021
5,000,000.00
5,000,000.00
4,876,600.00
(123,400.00)
0.920
0.56 210
1.42%
Aaa
AA+
NR
4380
3134GYCP5
FHLMC
5.000
07/23/2024
Freddie Mac
01/05/2023
01/23/2023
5,000,000.00
5,000,000.00
4,988,850.00
(11,150.00)
5.000
0.62 235
1.42%
Aaa
AA+
AA+
4344
3130AQ3C5
FHLB
1.000
08/28/2024
Federal Home Loan Bank
12/01/2021
12/02/2021
4,000,000.00
4,000,000.00
3,874,400.00
(125,600.00)
1.000
0.72 271
1.14%
Aaa
AA+
NR
4373
3133XVDG3
FHLB
4.375
09/13/2024
Federal Home Loan Bank
09/22/2022
09/23/2022
5,000,000.00
5,004,984.65
4,965,350.00
(39,634.65)
4.240
0.76 287
1.42%
Aaa
AA+
NR
4336
3130AMXJ6
FHLB
0.500
09/30/2024
Federal Home Loan Bank
06/17/2021
06/30/2021
5,000,000.00
5,000,000.00
4,804,450.00
(195,550.00)
0.500
0.81 304
1.42%
Aaa
AA+
NR
4346
3130AQD59
FHLB
1.000
09/30/2024
Federal Home Loan Bank
12/14/2021
12/30/2021
5,000,000.00
5,000,000.00
4,824,650.00
(175,350.00)
1.000
0.81 304
1.42%
Aaa
AA+
NR
4349
3130AQD59
FHLB
1.000
09/30/2024
Federal Home Loan Bank
12/22/2021
12/30/2021
5,000,000.00
5,000,000.00
4,824,650.00
(175,350.00)
1.000
0.81 304
1.42%
Aaa
AA+
NR
4334
3130AMW65
FHLB
0.500
12/30/2024
Federal Home Loan Bank
06/15/2021
06/30/2021
5,000,000.00
5,000,000.00
4,750,550.00
(249,450.00)
0.500
1.05 395
1.42%
Aaa
AA+
NR
4332
3130AMQ62
FHLB
0.625
03/14/2025
Federal Home Loan Bank
05/26/2021
06/14/2021
5,000,000.00
5,000,000.00
4,718,750.00
(281,250.00)
0.625
1.25 469
1.42%
Aaa
AA+
NR
4397
3130AWER7
FHLB
4.625
06/06/2025
Federal Home Loan Bank
06/14/2023
06/15/2023
3,000,000.00
2,998,551.27
2,988,360.00
(10,191.27)
4.659
1.41 553
0.85%
Aaa
AA+
NR
4329
3135G04Z3
FNMA
0.500
06/17/2025
Fannie Mae
05/13/2021
05/14/2021
5,000,000.00
4,990,242.63
4,675,350.00
(314,892.63)
0.628
1.50 564
1.42%
Aaa
AA+
AA+
4381
3135G04Z3
FNMA
0.500
06/17/2025
Fannie Mae
01/12/2023
01/13/2023
5,000,000.00
4,743,947.37
4,675,350.00
(68,597.37)
4.013
1.50 564
1.35%
Aaa
AA+
AA+
4345
3130AQ5S8
FHLB
1.250
06/30/2025
Federal Home Loan Bank
12/08/2021
12/30/2021
4,650,000.00
4,650,000.00
4,384,857.00
(265,143.00)
1.250
1.52 577
1.32%
Aaa
AA+
NR
4327
3130AMDL3
FHLB
0.800
07/25/2025
Federal Home Loan Bank
05/11/2021
05/25/2021
5,000,000.00
5,000,000.00
4,673,350.00
(326,650.00)
0.800
1.60 602
1.42%
Aaa
AA+
NR
4360
3130AQT94
FHLB
1.600
08/28/2025
Federal Home Loan Bank
03/03/2022
03/04/2022
4,575,000.00
4,558,415.63
4,332,342.00
(226,073.63)
1.816
1.68 636
1.29%
Aaa
AA+
NR
4331
3130AMQ54
FHLB
0.700
09/16/2025
Federal Home Loan Bank
05/26/2021
06/16/2021
5,000,000.00
5,000,000.00
4,645,050.00
(354,950.00)
0.700
1.74 655
1.42%
Aaa
AA+
NR
4318
3135GA2Z3
FNMA
0.560
11/17/2025
Fannie Mae
01/08/2021
01/11/2021
3,000,000.00
3,001,334.36
2,765,310.00
(236,024.36)
0.500
1.91 717
0.85%
Aaa
AA+
AA+
4320
3130AKN36
FHLB
0.525
01/15/2026
Federal Home Loan Bank
01/14/2021
01/15/2021
5,000,000.00
4,997,877.78
4,568,200.00
(429,677.78)
0.545
2.06 776
1.42%
Aaa
AA+
NR
4321
3130AKN85
FHLB
0.550
01/20/2026
Federal Home Loan Bank
01/14/2021
01/20/2021
5,000,000.00
4,998,931.94
4,562,200.00
(436,731.94)
0.560
2.07 781
1.42%
Aaa
AA+
NR
4322
3130AKUS3
FHLB
0.500
01/28/2026
Federal Home Loan Bank
01/26/2021
01/28/2021
5,000,000.00
5,000,000.00
4,567,750.00
(432,250.00)
0.500
2.09 789
1.42%
Aaa
AA+
NR
4333
3130ALEY6
FHLB
0.800
03/04/2026
Federal Home Loan Bank
06/09/2021
06/10/2021
5,000,000.00
5,000,000.00
4,569,400.00
(430,600.00)
0.800
2.18 824
1.42%
Aaa
AA+
NR
4328
3130AMJN3
FHLB
1.030
05/26/2026
Federal Home Loan Bank
05/12/2021
05/26/2021
5,000,000.00
5,000,000.00
4,581,100.00
(418,900.00)
1.030
2.39 907
1.42%
Aaa
AA+
NR
4335
3130AMFS6
FHLB
0.750
06/12/2026
Federal Home Loan Bank
06/16/2021
06/17/2021
5,000,000.00
4,984,774.37
4,549,400.00
(435,374.37)
0.873
2.44 924
1.41%
Aaa
AA+
NR
4388
3130AVWS7
FHLB
3.750
06/12/2026
Federal Home Loan Bank
05/08/2023
05/09/2023
3,000,000.00
2,996,586.82
2,942,670.00
(53,916.82)
3.796
2.33 924
0.85%
Aaa
AA+
NR
4398
3133EPNG6
FFCB
4.375
06/23/2026
Federal Farm Credit Bank
06/22/2023
06/23/2023
3,000,000.00
2,998,847.50
2,988,360.00
(10,487.50)
4.391
2.34 935
0.85%
Aaa
AA+
AA+
4347
3130AQ7E7
FHLB
1.500
06/30/2026
Federal Home Loan Bank
12/14/2021
12/30/2021
5,000,000.00
5,001,146.91
4,622,050.00
(379,096.91)
1.339
2.46 942
1.42%
Aaa
AA+
NR
Portfolio: CITYBond Holdings By Sector Report
City of Huntington Beach
Reporting Period:
11/30/2023
Report Run Date: Dec 22, 2023 17
Accounting
ID CUSIP Ticker Coupon Maturity Date Short Description Trade Date Settlement Date Par Value Book Value Market Value Gain/Loss Book
Yield
Effective
Duration
Days to
Maturity
(%) of
Portfolio
Moodys
Rating
S&P
Rating
Fitch
Rating
4384
3130AUMC5
FHLB
3.750
07/20/2026
Federal Home Loan Bank
01/17/2023
01/19/2023
5,000,000.00
5,000,000.00
4,896,900.00
(103,100.00)
3.750
2.43 962
1.42%
Aaa
AA+
NR
4356
3130AQS79
FHLB
1.375
08/07/2026
Federal Home Loan Bank
01/27/2022
02/07/2022
5,000,000.00
5,000,000.00
4,670,600.00
(329,400.00)
1.375
2.55 980
1.42%
Aaa
AA+
NR
4386
3133EPGT6
FFCB
3.875
04/26/2027
Federal Farm Credit Bank
04/21/2023
04/26/2023
5,000,000.00
4,995,108.51
4,901,900.00
(93,208.51)
3.906
3.12 1,242
1.42%
Aaa
AA+
AA+
4389
3133EPJP1
FFCB
3.625
05/12/2027
Federal Farm Credit Bank
05/08/2023
05/12/2023
5,000,000.00
4,988,063.99
4,861,450.00
(126,613.99)
3.700
3.18 1,258
1.42%
Aaa
AA+
AA+
4392
3130AW4N7
FHLB
3.630
06/04/2027
Federal Home Loan Bank
05/16/2023
05/18/2023
5,000,000.00
5,000,000.00
4,864,650.00
(135,350.00)
3.630
3.18 1,281
1.42%
Aaa
AA+
NR
4396
3133EPMV4
FFCB
4.125
06/15/2027
Federal Farm Credit Bank
06/09/2023
06/15/2023
5,000,000.00
4,999,159.51
4,939,500.00
(59,659.51)
4.130
3.18 1,292
1.42%
Aaa
AA+
AA+
4385
3134GYPF3
FHLMC
4.750
07/12/2027
Freddie Mac
04/21/2023
04/24/2023
3,300,000.00
3,295,757.61
3,249,048.00
(46,709.61)
4.791
2.14 1,319
0.94%
Aaa
AA+
AA+
4395
3130AWC24
FHLB
4.000
06/09/2028
Federal Home Loan Bank
06/09/2023
06/13/2023
5,000,000.00
5,004,169.71
4,921,650.00
(82,519.71)
3.979
3.99 1,652
1.42%
Aaa
AA+
NR
4399
3130AWC24
FHLB
4.000
06/09/2028
Federal Home Loan Bank
06/26/2023
06/27/2023
5,000,000.00
4,997,487.65
4,921,650.00
(75,837.65)
4.012
3.99 1,652
1.42%
Aaa
AA+
NR
4400
31422X5U2
FAMCA
5.100
08/07/2028
Farmer Mac
08/02/2023
08/07/2023
2,000,000.00
2,000,000.00
1,985,200.00
(14,800.00)
5.100
2.09 1,711
0.57%
NR
NR
NR
U.S. Agencies 178,525,000.00 178,209,322.88 170,869,247.00 (7,340,075.88) 50.58% 4355
67066GAL8
NVDA
0.584
06/14/2024
Nvidia
01/20/2022
01/24/2022
5,000,000.00
4,982,461.69
4,872,850.00
(109,611.69)
1.250
0.52 196
1.41%
A1
A+
4325
91159HHX1
USB
2.400
07/30/2024
US Bank
04/28/2021
04/30/2021
3,809,000.00
3,854,595.36
3,724,630.65
(129,964.71)
0.528
0.64 242
1.09%
A3
A
A
4343
14913R2P1
CAT
0.600
09/13/2024
Caterpillar
11/30/2021
12/02/2021
5,000,000.00
4,985,336.56
4,817,150.00
(168,186.56)
0.980
0.77 287
1.41%
A2
A
A+
4371
459200KS9
IBM
4.000
07/27/2025
IBM
08/09/2022
08/11/2022
6,000,000.00
6,017,611.63
5,883,660.00
(133,951.63)
3.810
1.55 604
1.71%
A3
A-
NR
4372
931142EW9
WMT
3.900
09/09/2025
Walmart
09/20/2022
09/22/2022
5,000,000.00
4,979,311.34
4,921,000.00
(58,311.34)
4.150
1.67 648
1.41%
Aa2
AA
AA
4382
717081DV2
PFE
2.750
06/03/2026
Pfizer Inc
01/13/2023
01/18/2023
5,000,000.00
4,838,753.58
4,758,850.00
(79,903.58)
4.142
2.34 915
1.37%
A1
A+
A
4375
110122CN6
BMY
3.200
06/15/2026
Bristol-Myers Squibb
11/14/2022
11/16/2022
5,000,000.00
4,851,306.59
4,808,000.00
(43,306.59)
4.480
2.35 927
1.38%
A2
A+
4390
931142EM1
WMT
3.050
07/08/2026
Walmart
05/11/2023
05/15/2023
4,257,000.00
4,184,194.55
4,086,975.42
(97,219.13)
3.752
2.42 950
1.19%
Aa2
AA
AA
4391
904764AU1
UNANA
2.000
07/28/2026
Unilever
05/11/2023
05/15/2023
2,505,000.00
2,396,009.82
2,327,620.95
(68,388.87)
3.752
2.51 970
0.68%
A1
A+
A
Corporates 41,571,000.00 41,089,581.13 40,200,737.02 (888,844.11) 11.66% Bond Holdings 318,096,000.00 316,634,644.64 304,343,874.02 (12,290,770.62) 89.86% Portfolio: CITYBond Holdings By Sector Report
City of Huntington Beach
Reporting Period:
11/30/2023
Report Run Date: Dec 22, 2023 18
Cash/Money Market/LGIP Activity Report
City of Huntington Beach
Portfolio: CITY
Reporting Date: 11/30/2023
Cash/Money Market Account Activity
Accounting ID Description Activity Date Transaction Type Transaction Amount 003 California Asset Management Program 11/01/2023 Interest Received $156,647.74 003 California Asset Management Program 11/17/2023 Withdrawal ($6,000,000.00) 003 California Asset Management Program 11/28/2023 Deposit $5,000,000.00 Activity Total ($843,352.26)
104 First American Treasury Obligations 11/01/2023 Interest Received $580.02 104 First American Treasury Obligations 11/13/2023 Deposit $292,805.56 104 First American Treasury Obligations 11/17/2023 Deposit $8,400.00 104 First American Treasury Obligations 11/27/2023 Deposit $20,000.00 104 First American Treasury Obligations 11/28/2023 Deposit $25,750.00 104 First American Treasury Obligations 11/30/2023 Deposit $3,000,000.00 Activity Total $3,347,535.58
19 Bond Redemption Activity Report
City of Huntington Beach
Portfolio: CITY
Reporting Date: 11/30/2023
Redemption Transactions
Accounting ID Transaction
Type Cusip Description Price Settlement
Date Posted Date Par Value Principal Accrued Interest Total Activity Total $0.00 $0.00 $0.00 $0.00
20 Bond Purchase Activity Report
City of Huntington Beach
Portfolio: CITY
Reporting Date: 11/30/2023
Purchase Transactions
Accounting ID Transaction
Type Cusip Description Price Settlement
Date Posted Date Par Value Principal Accrued Interest Total 4402 Buy 459058KT9 IBRD 3.500 07/12/2028 94.78000 11/13/2023 11/13/2023 5,000,000.00 $4,739,000.00 $58,819.44 $4,797,819.44 Activity Total 5,000,000.00 $4,739,000.00 $58,819.44 $4,797,819.44 21 Bond Interest Received Activity Report
City of Huntington Beach
Portfolio: CITY
Reporting Date: 11/30/2023
Bond Interest Received
Accounting ID Transaction Type Cusip Description Date Posted Interest Received Purchased Interest Adjustment Net Interest 4389 Interest Income 3133EPJP1 FFCB 3.625 05/12/2027 11/13/2023 $90,625.00 $90,625.00 4318 Interest Income 3135GA2Z3 FNMA 0.560 11/17/2025 11/17/2023 $8,400.00 $8,400.00 4327 Interest Income 3130AMDL3 FHLB 0.800 07/25/2025 11/27/2023 $20,000.00 $20,000.00 4328 Interest Income 3130AMJN3 FHLB 1.030 05/26/2026 11/27/2023 $25,750.00 $25,750.00 Activity Total $144,775.00 $0.00 $144,775.00
22 Statement of Cash Receipts and Disbursements and
Cash Receipts and Disbursements October 2023 November 2023 Receipts
General Fund
Property Tax 246,426 $ 13,791,928$
Local Sales Tax 4,201,331 3,944,653
Public Safety Sales Tax 236,550 244,768
Transient Occupancy Tax (TOT) 1,689,599 1,419,750 Utility Users Tax (UUT) 2,417,455 2,091,183 Other Revenue 5,669,127 5,396,567
Total General Fund Revenue 14,460,488 26,888,849 Total All Other Funds Revenue 15,858,729 24,250,676 Total Receipts 30,319,217$ 51,139,525 $
Disbursements
General Fund
Personnel Services (11,932,469) (12,831,863)
Operating Expenses (5,094,618) (4,421,467)
Capital Expenditures ‐ ‐
Non‐Operating Expenses (65,934) (5,688)
Total General Fund Disbursements (17,093,021) (17,259,018) Total All Other Funds Disbursements (15,791,321) (20,257,979) Total Disbursements (32,884,342) (37,516,996)
Net Change in Cash Flow (2,565,125)$ 13,622,529$ Summary of Cash by Fund October 2023 November 2023
General Fund 58,296,947$ 67,926,778$
General Fund Other 5,351,166 5,453,511 Capital Projects Funds 71,511,509 69,241,611 Debt Service Funds 30,297,321 31,743,448
Enterprise Funds 73,832,411 80,368,509
Trust and Agency Funds 4,536,235 2,965,717 Internal Service Funds 56,363,664 55,112,174 Special Revenue Funds 50,596,466 51,596,498 General Ledger Cash Balances * 350,785,718$ 364,408,247$ Total cash will differ from investment portfolio total due to outstanding checks and/or other timing differences.
Note: Above information was obtained from the City's accounting system records. The above information includes receipts from maturing investments and payments for purchased investments in the city investment portfolio. This statement is prepared in compliance with the City's Charter.
Summary of Cash by Fund
City Treasurer's Office
November 2023
23 Par Value Book Value Market Value Book Value
% of Port Book Yield Book Yield
Contribution
Days to
Maturity
Cash / Money Market
Local Govt Inv Pools (LGIP)
U.S. Treasuries
Supranational
U.S. Agencies
Corporates
Hold
Total
$35,000.00 $35,000.00 $35,000.00 0.01% 5.24% 0.00% 1
$33,191,953.00 $33,191,953.00 $33,191,953.00 9.62% 5.56% 0.53% 1 $68,000,000.00 $67,753,344.77 $64,447,770.00 19.63% 1.79% 0.35% 573 $25,000,000.00 $24,831,484.32 $23,238,600.00 7.20% 1.38% 0.10% 832 $178,525,000.00 $178,194,216.85 $169,069,305.25 51.64% 2.26% 1.17% 766 $41,571,000.00 $41,074,940.83 $39,811,554.71 11.90% 3.00% 0.36% 649 $346,322,953.00 $345,080,939.77 $329,794,182.96 100.00% 2.51% 645 Portfolio Investments
10/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) City Portfolio Certification
Fiscal YTD Transactions
Redemptions 2
Purchases 0
Total Activity 2
Period Transactions
Redemptions 10
Purchases 2
Total Activity 12
Net Period Earnings $3,090,702.15
Last FY Period Net Earnings $1,354,829.41
Avg Daily Book Balance $358,313,053.80
$1.00 $1.00
Net Effective Annual Return 2.589%
Net Period Earnings $735,333.30
Last FY Period Net Earnings $403,240.70
Avg Daily Book Balance $347,214,453.47
$1.00 $1.00
Net Effective Annual Return 2.529%
Fiscal YTD Summary (123 Days)Period Earnings Summary (31 Days) ______________________________________________ ____________________________ sum2
Total Market Value
$1.00
$329,794,182.96
sum2
Total Book Value
$2.00
$345,080,939.77
Market Value
Book Value
Par Value
Portfolio Summary
City of Huntington Beach
Portfolio: CITY
Reporting Date: (FY2024)
10/01/2023 - 10/31/2023
Full Accrual Basis
sum2
Total Par Value
$1.00
$346,322,953.00
The City Portfolio uses a 12 month moving average of the 1.5Yr Treasury for comparison purposes. This period, that rate is equal to: 4.830% ____________________________________________
24 Accounting ID Ticker Pool Description Type Par Value Book Value Market Value Rate % of Portfolio Rating 003
CAMP
California Asset Management Program
LGIP
33,191,953.00
33,191,953.00
33,191,953.00
5.56 9.62%
NR
104
FUZXX
First American Treasury Obligations
Cash/Money Market
35,000.00
35,000.00
35,000.00
5.24 0.01%
NR
CITY Fund Total 33,226,953.00 33,226,953.00 33,226,953.00 9.63% Portfolio: CITYCash By Fund Report
City of Huntington Beach
Reporting Period:
10/31/2023
Report Run Date: Nov 22, 2023
25 Accounting
ID CUSIP Ticker Coupon Maturity Date Short Description Trade Date Settlement Date Par Value Book Value Market Value Gain/Loss Book
Yield
Effective
Duration
Days to
Maturity
(%) of
Portfolio Mdy/S&P/Fitch
4364
9128286Z8
T
1.750
06/30/2024
U.S. Treasury Note
04/29/2022
05/02/2022
7,000,000.00
6,956,106.10
6,829,130.00
(126,976.10)
2.730
0.64 242
2.02%
Aaa/AA+/AA+
4370
912828XX3
T
2.000
06/30/2024
U.S. Treasury Note
05/26/2022
05/27/2022
5,000,000.00
4,985,171.57
4,885,950.00
(99,221.57)
2.462
0.64 242
1.44%
Aaa/AA+/AA+
4353
912828Y87
T
1.750
07/31/2024
U.S. Treasury Note
01/13/2022
01/14/2022
5,000,000.00
5,026,594.73
4,863,100.00
(163,494.73)
1.028
0.73 273
1.46%
Aaa/AA+/AA+
4358
912828Y87
T
1.750
07/31/2024
U.S. Treasury Note
02/10/2022
02/11/2022
4,000,000.00
4,004,520.71
3,890,480.00
(114,040.71)
1.595
0.73 273
1.16%
Aaa/AA+/AA+
4361
912828D56
T
2.375
08/15/2024
U.S. Treasury Note
03/21/2022
03/22/2022
5,000,000.00
5,005,131.13
4,879,700.00
(125,431.13)
2.240
0.76 288
1.45%
Aaa/AA+/AA+
4298
912828YH7
T
1.500
09/30/2024
U.S. Treasury Note
12/04/2019
12/05/2019
5,000,000.00
4,995,827.37
4,824,800.00
(171,027.37)
1.595
0.89 334
1.45%
Aaa/AA+/AA+
4350
912828YM6
T
1.500
10/31/2024
U.S. Treasury Note
12/30/2021
12/31/2021
3,000,000.00
3,017,107.39
2,885,640.00
(131,467.39)
0.920
0.97 365
0.87%
Aaa/AA+/AA+
4376
91282CEU1
T
2.875
06/15/2025
U.S. Treasury Note
11/17/2022
11/18/2022
3,000,000.00
2,936,082.89
2,892,780.00
(43,302.89)
4.276
1.54 592
0.85%
Aaa/AA+/AA+
4330
91282CAB7
T
0.250
07/31/2025
U.S. Treasury Note
05/18/2021
05/19/2021
5,000,000.00
4,968,557.50
4,594,350.00
(374,207.50)
0.615
1.70 638
1.44%
Aaa/AA+/AA+
4340
91282CAJ0
T
0.250
08/31/2025
U.S. Treasury Note
09/23/2021
09/27/2021
5,000,000.00
4,956,263.08
4,578,300.00
(377,963.08)
0.735
1.78 669
1.44%
Aaa/AA+/AA+
4351
9128284Z0
T
2.750
08/31/2025
U.S. Treasury Note
12/30/2021
12/31/2021
5,000,000.00
5,147,289.92
4,792,200.00
(355,089.92)
1.103
1.74 669
1.49%
Aaa/AA+/AA+
4341
91282CCP4
T
0.625
07/31/2026
U.S. Treasury Note
09/30/2021
09/30/2021
5,000,000.00
4,956,464.46
4,455,300.00
(501,164.46)
0.950
2.65 1,003
1.44%
Aaa/AA+/AA+
4339
91282CCW9
T
0.750
08/31/2026
U.S. Treasury Note
09/23/2021
09/23/2021
1,000,000.00
996,128.95
891,090.00
(105,038.95)
0.890
2.73 1,034
0.29%
Aaa/AA+/AA+
4342
91282CCW9
T
0.750
08/31/2026
U.S. Treasury Note
11/22/2021
11/23/2021
5,000,000.00
4,926,731.13
4,455,450.00
(471,281.13)
1.285
2.73 1,034
1.43%
Aaa/AA+/AA+
4379
91282CEW7
T
3.250
06/30/2027
U.S. Treasury Note
12/28/2022
12/29/2022
5,000,000.00
4,875,367.85
4,729,500.00
(145,867.85)
4.000
3.34 1,337
1.41%
Aaa/AA+/AA+
U.S. Treasuries 68,000,000.00 67,753,344.77 64,447,770.00 (3,305,574.77) 19.63% 4323
459056HV2
IBRD
1.500
08/28/2024
Int'l Bank for Recon and Dev
04/21/2021
04/23/2021
5,000,000.00
5,043,970.79
4,837,350.00
(206,620.79)
0.425
0.80 301
1.46%
Aaa/AAA/AAA
4338
459058JE4
IBRD
0.376
07/28/2025
Int'l Bank for Recon and Dev
07/28/2021
07/30/2021
5,000,000.00
4,982,123.09
4,598,200.00
(383,923.09)
0.583
1.69 635
1.44%
Aaa/AAA/AAA
4319
459058JL8
IBRD
0.500
10/28/2025
Int'l Bank for Recon and Dev
01/08/2021
01/12/2021
5,000,000.00
4,998,857.62
4,564,200.00
(434,657.62)
0.512
1.93 727
1.45%
Aaa/AAA/AAA
4324
45906M2L4
IBRD
0.650
02/24/2026
Int'l Bank for Recon and Dev
04/28/2021
04/30/2021
5,000,000.00
4,975,115.69
4,487,200.00
(487,915.69)
0.870
2.23 846
1.44%
Aaa/AAA/AAA
4401
45818WEQ5
IADB
3.800
06/09/2028
Inter-American Development Bank
09/19/2023
09/21/2023
5,000,000.00
4,831,417.14
4,751,650.00
(79,767.14)
4.622
4.08 1,682
1.40%
Aaa/AAA/AAA
Supranational 25,000,000.00 24,831,484.32 23,238,600.00 (1,592,884.32) 7.20% 4387
3130AUXN9
FHLB
5.000
02/15/2024
Federal Home Loan Bank
04/24/2023
04/25/2023
3,000,000.00
3,000,570.21
2,994,120.00
(6,450.21)
4.923
0.28 106
0.87%
Aaa/AA+/NR
4292
3133ECHX5
FFCB
2.260
03/13/2024
Federal Farm Credit Bank
05/22/2019
05/23/2019
5,000,000.00
5,000,412.02
4,942,200.00
(58,212.02)
2.236
0.36 133
1.45%
Aaa/AA+/AA+
4378
3130ATVC8
FHLB
4.875
06/14/2024
Federal Home Loan Bank
12/27/2022
12/28/2022
5,000,000.00
5,003,709.60
4,982,000.00
(21,709.60)
4.740
0.59 226
1.45%
Aaa/AA+/NR
4348
3130AQD42
FHLB
0.920
06/28/2024
Federal Home Loan Bank
12/14/2021
12/28/2021
5,000,000.00
5,000,000.00
4,851,000.00
(149,000.00)
0.920
0.64 240
1.45%
Aaa/AA+/NR
4380
3134GYCP5
FHLMC
5.000
07/23/2024
Freddie Mac
01/05/2023
01/23/2023
5,000,000.00
5,000,000.00
4,978,050.00
(21,950.00)
5.000
0.70 265
1.45%
Aaa/AA+/AA+
4344
3130AQ3C5
FHLB
1.000
08/28/2024
Federal Home Loan Bank
12/01/2021
12/02/2021
4,000,000.00
4,000,000.00
3,852,760.00
(147,240.00)
1.000
0.80 301
1.16%
Aaa/AA+/NR
4373
3133XVDG3
FHLB
4.375
09/13/2024
Federal Home Loan Bank
09/22/2022
09/23/2022
5,000,000.00
5,005,514.93
4,954,550.00
(50,964.93)
4.240
0.84 317
1.45%
Aaa/AA+/NR
4336
3130AMXJ6
FHLB
0.500
09/30/2024
Federal Home Loan Bank
06/17/2021
06/30/2021
5,000,000.00
5,000,000.00
4,775,100.00
(224,900.00)
0.500
0.89 334
1.45%
Aaa/AA+/NR
4346
3130AQD59
FHLB
1.000
09/30/2024
Federal Home Loan Bank
12/14/2021
12/30/2021
5,000,000.00
5,000,000.00
4,797,150.00
(202,850.00)
1.000
0.89 334
1.45%
Aaa/AA+/NR
4349
3130AQD59
FHLB
1.000
09/30/2024
Federal Home Loan Bank
12/22/2021
12/30/2021
5,000,000.00
5,000,000.00
4,797,150.00
(202,850.00)
1.000
0.89 334
1.45%
Aaa/AA+/NR
4334
3130AMW65
FHLB
0.500
12/30/2024
Federal Home Loan Bank
06/15/2021
06/30/2021
5,000,000.00
5,000,000.00
4,718,750.00
(281,250.00)
0.500
1.13 425
1.45%
Aaa/AA+/NR
4332
3130AMQ62
FHLB
0.625
03/14/2025
Federal Home Loan Bank
05/26/2021
06/14/2021
5,000,000.00
5,000,000.00
4,683,350.00
(316,650.00)
0.625
1.33 499
1.45%
Aaa/AA+/NR
4397
3130AWER7
FHLB
4.625
06/06/2025
Federal Home Loan Bank
06/14/2023
06/15/2023
3,000,000.00
2,998,471.52
2,967,750.00
(30,721.52)
4.659
1.49 583
0.87%
Aaa/AA+/NR
4329
3135G04Z3
FNMA
0.500
06/17/2025
Fannie Mae
05/13/2021
05/14/2021
5,000,000.00
4,989,716.16
4,637,450.00
(352,266.16)
0.628
1.58 594
1.45%
Aaa/AA+/AA+
4381
3135G04Z3
FNMA
0.500
06/17/2025
Fannie Mae
01/12/2023
01/13/2023
5,000,000.00
4,730,131.58
4,637,450.00
(92,681.58)
4.013
1.58 594
1.37%
Aaa/AA+/AA+
4345
3130AQ5S8
FHLB
1.250
06/30/2025
Federal Home Loan Bank
12/08/2021
12/30/2021
4,650,000.00
4,650,000.00
4,349,935.50
(300,064.50)
1.250
1.60 607
1.35%
Aaa/AA+/NR
4327
3130AMDL3
FHLB
0.800
07/25/2025
Federal Home Loan Bank
05/11/2021
05/25/2021
5,000,000.00
5,000,000.00
4,630,400.00
(369,600.00)
0.800
1.67 632
1.45%
Aaa/AA+/NR
4360
3130AQT94
FHLB
1.600
08/28/2025
Federal Home Loan Bank
03/03/2022
03/04/2022
4,575,000.00
4,557,622.11
4,293,591.75
(264,030.36)
1.816
1.75 666
1.32%
Aaa/AA+/NR
4331
3130AMQ54
FHLB
0.700
09/16/2025
Federal Home Loan Bank
05/26/2021
06/16/2021
5,000,000.00
5,000,000.00
4,598,150.00
(401,850.00)
0.700
1.82 685
1.45%
Aaa/AA+/NR
4318
3135GA2Z3
FNMA
0.560
11/17/2025
Fannie Mae
01/08/2021
01/11/2021
3,000,000.00
3,001,391.07
2,732,970.00
(268,421.07)
0.500
1.98 747
0.87%
Aaa/AA+/AA+
4320
3130AKN36
FHLB
0.525
01/15/2026
Federal Home Loan Bank
01/14/2021
01/15/2021
5,000,000.00
4,997,794.44
4,517,050.00
(480,744.44)
0.545
2.13 806
1.45%
Aaa/AA+/NR
4321
3130AKN85
FHLB
0.550
01/20/2026
Federal Home Loan Bank
01/14/2021
01/20/2021
5,000,000.00
4,998,890.28
4,516,900.00
(481,990.28)
0.560
2.15 811
1.45%
Aaa/AA+/NR
4322
3130AKUS3
FHLB
0.500
01/28/2026
Federal Home Loan Bank
01/26/2021
01/28/2021
5,000,000.00
5,000,000.00
4,507,650.00
(492,350.00)
0.500
2.17 819
1.45%
Aaa/AA+/NR
4333
3130ALEY6
FHLB
0.800
03/04/2026
Federal Home Loan Bank
06/09/2021
06/10/2021
5,000,000.00
5,000,000.00
4,522,850.00
(477,150.00)
0.800
2.25 854
1.45%
Aaa/AA+/NR
4328
3130AMJN3
FHLB
1.030
05/26/2026
Federal Home Loan Bank
05/12/2021
05/26/2021
5,000,000.00
5,000,000.00
4,514,400.00
(485,600.00)
1.030
2.46 937
1.45%
Aaa/AA+/NR
4335
3130AMFS6
FHLB
0.750
06/12/2026
Federal Home Loan Bank
06/16/2021
06/17/2021
5,000,000.00
4,984,272.98
4,480,400.00
(503,872.98)
0.873
2.51 954
1.44%
Aaa/AA+/NR
4388
3130AVWS7
FHLB
3.750
06/12/2026
Federal Home Loan Bank
05/08/2023
05/09/2023
3,000,000.00
2,996,474.42
2,906,430.00
(90,044.42)
3.796
2.40 954
0.87%
Aaa/AA+/NR
4398
3133EPNG6
FFCB
4.375
06/23/2026
Federal Farm Credit Bank
06/22/2023
06/23/2023
3,000,000.00
2,998,810.00
2,950,500.00
(48,310.00)
4.391
2.42 965
0.87%
Aaa/AA+/AA+
4347
3130AQ7E7
FHLB
1.500
06/30/2026
Federal Home Loan Bank
12/14/2021
12/30/2021
5,000,000.00
5,001,183.95
4,553,900.00
(447,283.95)
1.339
2.53 972
1.45%
Aaa/AA+/NR
4384
3130AUMC5
FHLB
3.750
07/20/2026
Federal Home Loan Bank
01/17/2023
01/19/2023
5,000,000.00
5,000,000.00
4,833,400.00
(166,600.00)
3.750
2.51 992
1.45%
Aaa/AA+/NR
Portfolio: CITYBond Holdings By Sector Report
City of Huntington Beach
Reporting Period:
10/31/2023
Report Run Date: Jan 19, 2024 26
Accounting
ID CUSIP Ticker Coupon Maturity Date Short Description Trade Date Settlement Date Par Value Book Value Market Value Gain/Loss Book
Yield
Effective
Duration
Days to
Maturity
(%) of
Portfolio Mdy/S&P/Fitch
4356
3130AQS79
FHLB
1.375
08/07/2026
Federal Home Loan Bank
01/27/2022
02/07/2022
5,000,000.00
5,000,000.00
4,597,550.00
(402,450.00)
1.375
2.62 1,010
1.45%
Aaa/AA+/NR
4386
3133EPGT6
FFCB
3.875
04/26/2027
Federal Farm Credit Bank
04/21/2023
04/26/2023
5,000,000.00
4,994,988.72
4,815,550.00
(179,438.72)
3.906
3.20 1,272
1.45%
Aaa/AA+/AA+
4389
3133EPJP1
FFCB
3.625
05/12/2027
Federal Farm Credit Bank
05/08/2023
05/12/2023
5,000,000.00
4,987,775.45
4,773,250.00
(214,525.45)
3.700
3.19 1,288
1.45%
Aaa/AA+/AA+
4392
3130AW4N7
FHLB
3.630
06/04/2027
Federal Home Loan Bank
05/16/2023
05/18/2023
5,000,000.00
5,000,000.00
4,774,500.00
(225,500.00)
3.630
3.25 1,311
1.45%
Aaa/AA+/NR
4396
3133EPMV4
FFCB
4.125
06/15/2027
Federal Farm Credit Bank
06/09/2023
06/15/2023
5,000,000.00
4,999,139.72
4,849,550.00
(149,589.72)
4.130
3.25 1,322
1.45%
Aaa/AA+/AA+
4385
3134GYPF3
FHLMC
4.750
07/12/2027
Freddie Mac
04/21/2023
04/24/2023
3,300,000.00
3,295,659.78
3,213,408.00
(82,251.78)
4.791
2.34 1,349
0.96%
Aaa/AA+/AA+
4395
3130AWC24
FHLB
4.000
06/09/2028
Federal Home Loan Bank
06/09/2023
06/13/2023
5,000,000.00
5,004,246.55
4,805,550.00
(198,696.55)
3.979
4.06 1,682
1.45%
Aaa/AA+/NR
4399
3130AWC24
FHLB
4.000
06/09/2028
Federal Home Loan Bank
06/26/2023
06/27/2023
5,000,000.00
4,997,441.36
4,805,550.00
(191,891.36)
4.012
4.06 1,682
1.45%
Aaa/AA+/NR
4400
31422X5U2
FAMCA
5.100
08/07/2028
Farmer Mac
08/02/2023
08/07/2023
2,000,000.00
2,000,000.00
1,957,040.00
(42,960.00)
5.100
2.92 1,741
0.58%
NR/NR/NR
U.S. Agencies 178,525,000.00 178,194,216.85 169,069,305.25 (9,124,911.60) 51.64% 4355
67066GAL8
NVDA
0.584
06/14/2024
Nvidia
01/20/2022
01/24/2022
5,000,000.00
4,979,735.52
4,847,600.00
(132,135.52)
1.250
0.60 226
1.44%
A1/A+/
4325
91159HHX1
USB
2.400
07/30/2024
US Bank
04/28/2021
04/30/2021
3,809,000.00
3,860,318.62
3,702,576.54
(157,742.08)
0.528
0.72 272
1.12%
A3/A/A
4343
14913R2P1
CAT
0.600
09/13/2024
Caterpillar
11/30/2021
12/02/2021
5,000,000.00
4,983,776.62
4,788,150.00
(195,626.62)
0.980
0.84 317
1.44%
A2/A/A+
4371
459200KS9
IBM
4.000
07/27/2025
IBM
08/09/2022
08/11/2022
6,000,000.00
6,018,498.12
5,840,340.00
(178,158.12)
3.810
1.63 634
1.74%
A3/A-/
4372
931142EW9
WMT
3.900
09/09/2025
Walmart
09/20/2022
09/22/2022
5,000,000.00
4,978,338.52
4,884,400.00
(93,938.52)
4.150
1.75 678
1.44%
Aa2/AA/AA
4382
717081DV2
PFE
2.750
06/03/2026
Pfizer Inc
01/13/2023
01/18/2023
5,000,000.00
4,833,390.62
4,684,450.00
(148,940.62)
4.142
2.41 945
1.40%
A1/A+/A
4375
110122CN6
BMY
3.200
06/15/2026
Bristol-Myers Squibb
11/14/2022
11/16/2022
5,000,000.00
4,846,426.07
4,738,000.00
(108,426.07)
4.480
2.41 957
1.40%
A2/A+/
4390
931142EM1
WMT
3.050
07/08/2026
Walmart
05/11/2023
05/15/2023
4,257,000.00
4,181,863.54
4,034,188.62
(147,674.92)
3.752
2.48 980
1.21%
Aa2/AA/AA
4391
904764AU1
UNANA
2.000
07/28/2026
Unilever
05/11/2023
05/15/2023
2,505,000.00
2,392,593.20
2,291,849.55
(100,743.65)
3.752
2.58 1,000
0.69%
A1/A+/A
Corporates 41,571,000.00 41,074,940.83 39,811,554.71 (1,263,386.12) 11.90% Bond Holdings 313,096,000.00 311,853,986.77 296,567,229.96 (15,286,756.81) 90.37% Portfolio: CITYBond Holdings By Sector Report
City of Huntington Beach
Reporting Period:
10/31/2023
Report Run Date: Jan 19, 2024 27
Cash/Money Market/LGIP Activity Report
City of Huntington Beach
Portfolio: CITY
Reporting Date: 10/31/2023
Cash/Money Market Account Activity
Accounting ID Description Activity Date Transaction Type Transaction Amount 003 California Asset Management Program 10/02/2023 Interest Received $164,269.68 Activity Total $164,269.68
104 First American Treasury Obligations 10/26/2023 Deposit $96,875.00 104 First American Treasury Obligations 10/25/2023 Deposit $4,000,000.00 104 First American Treasury Obligations 10/27/2023 Withdrawal ($4,096,875.00) 104 First American Treasury Obligations 10/19/2023 Deposit $3,000,000.00 104 First American Treasury Obligations 10/20/2023 Withdrawal ($3,000,000.00) 104 First American Treasury Obligations 10/30/2023 Deposit $12,500.00 104 First American Treasury Obligations 10/31/2023 Deposit $22,500.00 Activity Total $35,000.00
28 Bond Redemption Activity Report
City of Huntington Beach
Portfolio: CITY
Reporting Date: 10/31/2023
Redemption Transactions
Accounting ID Transaction
Type Cusip Description Price Settlement
Date Posted Date Par Value Principal Accrued Interest Total 4300 Maturity 254687CR5 DIS 4.000 10/01/2023 100.00000 10/01/2023 10/02/2023 $2,875,000.00 $2,875,000.00 $0.00 $2,875,000.00 4377 Maturity 313384ND7 FHDN 0.000 10/19/2023 100.00000 10/19/2023 10/19/2023 $3,000,000.00 $3,000,000.00 $0.00 $3,000,000.00 Activity Total $5,875,000.00 $5,875,000.00 $0.00 $5,875,000.00 29 Bond Purchase Activity Report
City of Huntington Beach
Portfolio: CITY
Reporting Date: 10/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
30 Bond Interest Received Activity Report
City of Huntington Beach
Portfolio: CITY
Reporting Date: 10/31/2023
Bond Interest Received
Accounting ID Transaction Type Cusip Description Date Posted Interest Received Purchased Interest Adjustment Net Interest 4298 Interest Income 912828YH7 T 1.500 09/30/2024 10/02/2023 $37,500.00 $37,500.00 4300 Interest Income 254687CR5 DIS 4.000 10/01/2023 10/02/2023 $57,500.00 $57,500.00 4336 Interest Income 3130AMXJ6 FHLB 0.500 09/30/2024 10/02/2023 $12,500.00 $12,500.00 4386 Interest Income 3133EPGT6 FFCB 3.875 04/26/2027 10/26/2023 $96,875.00 $96,875.00 4319 Interest Income 459058JL8 IBRD 0.500 10/28/2025 10/30/2023 $12,500.00 $12,500.00 4350 Interest Income 912828YM6 T 1.500 10/31/2024 10/31/2023 $22,500.00 $22,500.00 Activity Total $239,375.00 $0.00 $239,375.00
31 Statement of Cash Receipts and Disbursements and
Cash Receipts and Disbursements September 2023 October 2023 Receipts
General Fund
Property Tax 999,234 $ 246,426$
Local Sales Tax 3,935,747 4,201,331
Public Safety Sales Tax 231,199 236,550
Transient Occupancy Tax (TOT) 1,671,484 1,689,599 Utility Users Tax (UUT) 1,693,569 2,417,455 Other Revenue 4,620,877 5,669,127
Total General Fund Revenue 13,152,111 14,460,488 Total All Other Funds Revenue 20,570,921 15,858,729 Total Receipts 33,723,032$ 30,319,217 $
Disbursements
General Fund
Personnel Services (11,240,451) (11,932,469)
Operating Expenses (3,259,040) (5,094,618)
Capital Expenditures ‐ ‐
Non‐Operating Expenses (3,831,000) (65,934)
Total General Fund Disbursements (18,330,491) (17,093,021) Total All Other Funds Disbursements (26,126,206) (15,791,321) Total Disbursements (44,456,698) (32,884,342)
Net Change in Cash Flow (10,733,666)$ (2,565,125)$ Summary of Cash by Fund September 2023 October 2023
General Fund 101,259,457$ 98,626,924$
General Fund Other 5,505,002 5,359,882 Capital Projects Funds 53,962,133 51,813,430 Debt Service Funds 27,479,838 27,329,640 Enterprise Funds 71,643,848 73,838,860
Trust and Agency Funds 10,245,364 11,074,223 Internal Service Funds 38,950,294 37,645,916 Special Revenue Funds 44,304,899 45,096,836 General Ledger Cash Balances * 353,350,836$ 350,785,712$ Total cash will differ from investment portfolio total due to outstanding checks and/or other timing differences.
Note: Above information was obtained from the City's accounting system records. The above information includes receipts from maturing investments and payments for purchased investments in the city investment portfolio. This statement is prepared in compliance with the City's Charter.
Summary of Cash by Fund
City Treasurer's Office
October 2023
32