City of Huntington Beach
Quarterly Investment Report
June 2024
Prepared by:
Alisa Backstrom, MBA, CCMT, CPFIM
City Treasurer
Colin Stevens, MPP
Treasury Manager
1 INVESTMENT PORTFOLIO SUMMARY
As of June 30, 2024
Currently, funds within this portfolio with overnight availability are invested in the California Asset Management Program “CAMP”. The CAMP account is considered a “Local Government Investment Pool” or “LGIP” for reporting purposes above. Other funds are invested in U.S. Treasuries, Supranationals (International Bank of Reconstruction and Development “IBRD”, Inter -American Development Bank “IADB”), U.S. Agencies, money market funds, and corporate bonds. Only the investment types allowed under California Government code Section 53601 and the City’s Investment Policy Statement are utilized.
After raising the federal funds rate by 5.25 percentage points since March 2022 in one of the Fed’s fastest and largest rate hike campaigns , The Federal Open Market Committee (“FOMC” or “the Fed”) has held the rate steady since July of last year. At the most recent June 2024 meeting, the FOMC maintained the federal funds rate at 5.25 to 5.50 percent.
As interest rates have been rising and have remained at elevated levels, the market value of securities previously purchased at lower than the current market rates, is down. This has resulted in the current market value of the portfolio being lower than the book value, at $380.2 million versus $389.1 million , respectively. As investments are primarily held to maturity, the market value is only a point -in-time measurement and no loss is realized . The increasing interest rates will allow excess funds to be invested at higher rates resulting in increased interest income in the future. 2 PORTFOLIO BREAKOUT BY SECTOR
As of June 30, 2024
The largest holding by security type at month-end was U.S. Agency securities at approximately 42% of the total overall portfolio. This was followed by U.S. Treasur y securities at approximately 21% of the total portfolio as of June 30, 2024. Cash held in the Local Government Investment Pools (“LGIP”) has been reduced as higher interest rates have become available in marketable securities.
INVESTMENT PORTFOLIO EARNINGS
As of June 30, 2024
3 Earnings for the month of June 2024 were $984,580, an increase of approximately 35% from the same month in the prior year. Fiscal year to date earnings of $10,027,613 were up approximately 70% from the previous fiscal year. These higher earnings were due to both the increase in interest rates and the higher average balance of the portfolio . The effective rate of return for June was 3.04%, with a fi scal year-to-date return of 2.67%. The benchmark has increased rapidly with the sharp rise in interest rates through 2022 into 2023. At the end of June, the 12-month moving average of the interpolated 1.5-year U.S. Treasury was 4.98%. The portfolio will lag behind the benchmark, as it will take time for previously purchased securities to mature and for funds to be reinvested.
QUARTERLY PORTFOLIO ACTIVITY
April 1 to June 30, 2024
For the quarter ending June 30, 2024, one Supranational (IADB) was purchased for $10 million. Two U.S. Treasuries matured totaling $12 million, two U.S. Agencies matured totaling $10 million, and one Corporate Bond (NVDA) matured for $5 million.
4 COMPLIANCE SUMMARY
As of June 30, 2024
There were no compliance issues during this period.
ECONOMIC AND MARKET OVERVIEW
The Federal Open Market Committee (FOMC) met in June to discuss the current state of the economy and to examine potential future interest rate adjustments. They concluded that economic activity has been expanding at a solid pace, job gains have remained strong, and the unemployment rate has remained low. The Committee also stated that inflation has eased over the past year but remains elevated, and that in recent months there has been modest further progress toward the Committee’s two percent inflation objective.
5 Fixed Income / Equity Markets: The yield on the 10 -year U.S. Treasury finished the quarter at 4.36%, up from 4.20% at the end of the previous quarter . The S&P 500 increased by 3.92% and the DJIA decreased by 1.73% respectively, over the same period.
Employment: Total nonfarm payroll employment rose by 206,000 in June, and the unemployment rate was little changed at 4.1 percent. Notable job gains occu rred in government, health care, social assistance, and construction.
6 Portfolio Summary
City of Huntington Beach
Portfolio: CITY
Reporting Date: (FY2024)
06/01/2024 - 06/30/2024
Full Accrual Basis
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
$9,653,600.90 $9,653,600.90 $9,653,600.90 2.48% 5.17% 0.13% 1 $33,616,453.79 $33,616,453.79 $33,616,453.79 8.64% 5.43% 0.47% 1 $81,000,000.00 $80,656,417.98 $78,539,600.00 20.73% 2.35% 0.49% 645 $50,000,000.00 $49,569,236.75 $48,681,700.00 12.74% 2.97% 0.38% 960 $164,980,000.00 $164,786,239.28 $159,593,278.60 42.35% 2.24% 0.95% 604 $51,571,000.00 $50,783,139.39 $50,092,574.68 13.05% 3.61% 0.47% 631 $390,821,054.69 $389,065,088.09 $380,177,207.97 100.00% 2.88% 594 Portfolio Investments
06/30/2024
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 5
Purchases 0
Total Activity 5
Period Transactions
Redemptions 17
Purchases 14
Total Activity 31
Net Period Earnings $10,027,613.33
Last FY Period Net Earnings $5,896,788.47
Avg Daily Book Balance $375,076,563.56
$1.00 $1.00
Net Effective Annual Return 2.673%
Net Period Earnings $984,579.98
Last FY Period Net Earnings $730,988.46
Avg Daily Book Balance $401,099,321.66
$1.00 $1.00
Net Effective Annual Return 3.036%
Fiscal YTD Summary (366 Days)Period Earnings Summary (30 Days) ______________________________________________ __________________ Portfolio Market Value
Par Value Receivable
sum2
Total Market Value
$380,177,207.97
$12,000,000.00
$1.00
$392,177,207.97
Portfolio Book Value
Par Value Receivable
sum2
Total Book Value
$389,065,088.09
$12,000,000.00
$2.00
$401,065,088.09
Market Value
Book Value
Par Value
Portfolio Par Value
Par Value Receivable
sum2
Total Par Value
$390,821,054.69
$12,000,000.00
$1.00
$402,821,054.69
The City Portfolio uses a 12 month moving average of the 1.5Yr Treasury for comparison purposes. This period, that rate is equal to: 4.980% ____________________________________________
7 Accounting ID Ticker Pool Description Type Par Value Book Value Market Value Rate % of Portfolio 104 FUZXX First American Treasury Obligations Cash/Money Market 9,653,600.90 9,653,600.90 9,653,600.90 5.170 2.48% Cash/Money Market Total 9,653,600.90 9,653,600.90 9,653,600.90 2.48% 003 CAMP California Asset Management Program LGIP 33,616,453.79 33,616,453.79 33,616,453.79 5.430 8.64% LGIP Total 33,616,453.79 33,616,453.79 33,616,453.79 8.64% Portfolio: CITYCash By Structure Report
City of Huntington Beach
Reporting Period:
06/30/2024
Report Run Date: Jul 19, 2024
8 Accounting ID Transaction Type Cusip Description Price Settlement Date Posted Date Par Value Principal Accrued Interest Total 4378
Maturity
3130ATVC8
FHLB 4.875 06/14/2024
100.00000
06/14/2024
06/14/2024
5,000,000.00
5,000,000.00
0.00 5,000,000.00
4355
Maturity
67066GAL8
NVDA 0.584 06/14/2024
100.00000
06/14/2024
06/14/2024
5,000,000.00
5,000,000.00
0.00 5,000,000.00
4348
Maturity
3130AQD42
FHLB 0.920 06/28/2024
100.00000
06/28/2024
06/28/2024
5,000,000.00
5,000,000.00
0.00 5,000,000.00
4364
Maturity
9128286Z8
T 1.750 06/30/2024
100.00000
06/30/2024
07/01/2024
7,000,000.00
7,000,000.00
0.00 7,000,000.00
4370
Maturity
912828XX3
T 2.000 06/30/2024
100.00000
06/30/2024
07/01/2024
5,000,000.00
5,000,000.00
0.00 5,000,000.00
Activity Total 27,000,000.00 27,000,000.00 0.00 27,000,000.00 Portfolio: CITY Bond Redemption Activity Report
City of Huntington Beach
Reporting Period:
06/30/2024
Report Run Date: Jul 19, 2024
9 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 Portfolio: CITY Bond Purchase Activity Report
City of Huntington Beach
Reporting Period:
06/30/2024
Report Run Date: Jul 19, 2024
10 Accounting ID Transaction Type Cusip Description Date Posted Interest Received Purchased Interest Adjustment Net Interest
4382
Interest Income
717081DV2
PFE 2.750 06/03/2026
06/03/2024
68,750.00
68,750.00
4392
Interest Income
3130AW4N7
FHLB 3.630 06/04/2027
06/04/2024
90,750.00
90,750.00
4397
Interest Income
3130AWER7
FHLB 4.625 06/06/2025
06/06/2024
69,375.00
69,375.00
4395
Interest Income
3130AWC24
FHLB 4.000 06/09/2028
06/10/2024
100,000.00
100,000.00
4399
Interest Income
3130AWC24
FHLB 4.000 06/09/2028
06/10/2024
100,000.00
100,000.00
4401
Interest Income
45818WEQ5
IADB 3.800 06/09/2028
06/10/2024
95,000.00
95,000.00
4335
Interest Income
3130AMFS6
FHLB 0.750 06/12/2026
06/12/2024
18,750.00
18,750.00
4388
Interest Income
3130AVWS7
FHLB 3.750 06/12/2026
06/12/2024
56,250.00
56,250.00
4355
Interest Income
67066GAL8
NVDA 0.584 06/14/2024
06/14/2024
14,600.00
14,600.00
4378
Interest Income
3130ATVC8
FHLB 4.875 06/14/2024
06/14/2024
121,875.00
121,875.00
4375
Interest Income
110122CN6
BMY 3.200 06/15/2026
06/17/2024
80,000.00
80,000.00
4376
Interest Income
91282CEU1
T 2.875 06/15/2025
06/17/2024
43,125.00
43,125.00
4381
Interest Income
3135G04Z3
FNMA 0.500 06/17/2025
06/17/2024
12,500.00
12,500.00
4396
Interest Income
3133EPMV4
FFCB 4.125 06/15/2027
06/17/2024
103,125.00
103,125.00
4329
Interest Income
3135G04Z3
FNMA 0.500 06/17/2025
06/17/2024
12,500.00
12,500.00
4398
Interest Income
3133EPNG6
FFCB 4.375 06/23/2026
06/24/2024
65,625.00
65,625.00
4348
Interest Income
3130AQD42
FHLB 0.920 06/28/2024
06/28/2024
23,000.00
23,000.00
Activity Total 1,075,225.00 0.00 1,075,225.00 Portfolio: CITY Bond Interest Received Report
City of Huntington Beach
Reporting Period:
06/30/2024
Report Run Date: Jul 19, 2024
11 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
4353 912828Y87 T 1.750 07/31/2024 U.S. Treasury Note 01/13/2022 01/14/2022 5,000,000.00 5,002,922.50 4,985,150.00 (17,772.50) 1.028 0.08 30 1.29% Aaa AA+ AA+ 4358
912828Y87
T
1.750
07/31/2024
U.S. Treasury Note
02/10/2022
02/11/2022
4,000,000.00
4,000,496.78
3,988,120.00
(12,376.78)
1.595
0.08 30
1.03%
Aaa
AA+
AA+
4361 912828D56 T 2.375 08/15/2024 U.S. Treasury Note 03/21/2022 03/22/2022 5,000,000.00 5,000,801.74 4,981,050.00 (19,751.74) 2.240 0.12 45 1.29% Aaa AA+ AA+ 4298 912828YH7 T 1.500 09/30/2024 U.S. Treasury Note 12/04/2019 12/05/2019 5,000,000.00 4,998,863.15 4,951,150.00 (47,713.15) 1.595 0.25 91 1.28% 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,005,718.09 2,961,480.00 (44,238.09) 0.920 0.33 122 0.77% Aaa AA+ AA+ 4376 91282CEU1 T 2.875 06/15/2025 U.S. Treasury Note 11/17/2022 11/18/2022 3,000,000.00 2,962,319.14 2,936,460.00 (25,859.14) 4.276 0.93 349 0.76% Aaa AA+ AA+ 4330 91282CAB7 T 0.250 07/31/2025 U.S. Treasury Note 05/18/2021 05/19/2021 5,000,000.00 4,980,533.25 4,748,250.00 (232,283.25) 0.615 1.05 395 1.28% Aaa AA+ AA+ 4340 91282CAJ0 T 0.250 08/31/2025 U.S. Treasury Note 09/23/2021 09/27/2021 5,000,000.00 4,972,149.58 4,730,650.00 (241,499.58) 0.735 1.14 426 1.28% Aaa AA+ AA+ 4351 9128284Z0 T 2.750 08/31/2025 U.S. Treasury Note 12/30/2021 12/31/2021 5,000,000.00 5,093,789.99 4,870,500.00 (223,289.99) 1.103 1.12 426 1.31% Aaa AA+ AA+ 4411 91282CHM6 T 4.500 07/15/2026 U.S. Treasury Note 03/11/2024 03/12/2024 5,000,000.00 5,011,268.77 4,978,500.00 (32,768.77) 4.380 1.88 744 1.29% Aaa AA+ AA+ 4341 91282CCP4 T 0.625 07/31/2026 U.S. Treasury Note 09/30/2021 09/30/2021 5,000,000.00 4,967,011.95 4,599,600.00 (367,411.95) 0.950 2.01 760 1.28% Aaa AA+ AA+ 4339 91282CCW9 T 0.750 08/31/2026 U.S. Treasury Note 09/23/2021 09/23/2021 1,000,000.00 997,038.69 919,690.00 (77,348.69) 0.890 2.09 791 0.26% Aaa AA+ AA+ 4342 91282CCW9 T 0.750 08/31/2026 U.S. Treasury Note 11/22/2021 11/23/2021 5,000,000.00 4,943,950.02 4,598,450.00 (345,500.02) 1.285 2.09 791 1.27% Aaa AA+ AA+ 4379 91282CEW7 T 3.250 06/30/2027 U.S. Treasury Note 12/28/2022 12/29/2022 5,000,000.00 4,898,019.77 4,824,400.00 (73,619.77) 4.000 2.80 1,094 1.26% Aaa AA+ AA+ 4406 91282CEW7 T 3.250 06/30/2027 U.S. Treasury Note 12/21/2023 12/22/2023 5,000,000.00 4,901,488.96 4,824,400.00 (77,088.96) 3.960 2.80 1,094 1.26% Aaa AA+ AA+ 4409 91282CFB2 T 2.750 07/31/2027 U.S. Treasury Note 01/18/2024 01/19/2024 5,000,000.00 4,810,783.55 4,747,650.00 (63,133.55) 4.080 2.86 1,125 1.24% Aaa AA+ AA+ 4408 91282CHQ7 T 4.125 07/31/2028 U.S. Treasury Note 01/12/2024 01/16/2024 10,000,000.00 10,109,262.06 9,894,100.00 (215,162.06) 3.831 3.64 1,491 2.60% Aaa AA+ AA+ U.S. Treasuries 81,000,000.00 80,656,417.98 78,539,600.00 (2,116,817.98) 20.73% 4323
459056HV2
IBRD
1.500
08/28/2024
Int'l Bank for Recon and Dev
04/21/2021
04/23/2021
5,000,000.00
5,008,438.84
4,968,450.00
(39,988.84)
0.425
0.16 58
1.29%
Aaa
AAA
AAA
4338
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,988,965.92
4,754,750.00
(234,215.92)
0.583
1.05 392
1.28%
Aaa
AAA
AAA
4319
459058JL8
IBRD
0.500
10/28/2025
Int'l Bank for Recon and Dev
01/08/2021
01/12/2021
5,000,000.00
4,999,240.01
4,712,850.00
(286,390.01)
0.512
1.29 484
1.28%
Aaa
AAA
AAA
4324
45906M2L4
IBRD
0.650
02/24/2026
Int'l Bank for Recon and Dev
04/28/2021
04/30/2021
5,000,000.00
4,982,285.24
4,658,600.00
(323,685.24)
0.870
1.60 603
1.28%
Aaa
AAA
AAA
4413
45818WFN1
IADB
4.850
07/19/2027
Inter-American Development Bank
05/28/2024
05/29/2024
10,000,000.00
10,022,640.18
10,070,800.00
48,159.82
4.770
2.77 1,113
2.58%
Aaa
AAA
AAA
4401
45818WEQ5
IADB
3.800
06/09/2028
Inter-American Development Bank
09/19/2023
09/21/2023
5,000,000.00
4,855,819.96
4,858,400.00
2,580.04
4.622
3.59 1,439
1.25%
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,774,442.53
4,817,700.00
43,257.47
4.760
3.63 1,472
1.23%
Aaa
AAA
AAA
4403
459058KT9
IBRD
3.500
07/12/2028
Int'l Bank for Recon and Dev
12/04/2023
12/06/2023
5,000,000.00
4,846,094.11
4,817,700.00
(28,394.11)
4.350
3.63 1,472
1.25%
Aaa
AAA
AAA
4410
459058KW2
IBRD
4.625
08/01/2028
Int'l Bank for Recon and Dev
01/23/2024
01/25/2024
5,000,000.00
5,091,309.96
5,022,450.00
(68,859.96)
4.130
3.61 1,492
1.31%
Aaa
AAA
AAA
Supranational 50,000,000.00 49,569,236.75 48,681,700.00 (887,536.75) 12.74% 4380
3134GYCP5
FHLMC
5.000
07/23/2024
Freddie Mac
01/05/2023
01/23/2023
5,000,000.00
5,000,000.00
4,998,150.00
(1,850.00)
5.000
0.06 22
1.29%
Aaa
AA+
AA+
4344
3130AQ3C5
FHLB
1.000
08/28/2024
Federal Home Loan Bank
12/01/2021
12/02/2021
4,000,000.00
4,000,000.00
3,970,320.00
(29,680.00)
1.000
0.16 58
1.03%
Aaa
AA+
4373
3133XVDG3
FHLB
4.375
09/13/2024
Federal Home Loan Bank
09/22/2022
09/23/2022
5,000,000.00
5,001,272.68
4,988,450.00
(12,822.68)
4.240
0.20 74
1.29%
Aaa
AA+
4336
3130AMXJ6
FHLB
0.500
09/30/2024
Federal Home Loan Bank
06/17/2021
06/30/2021
5,000,000.00
5,000,000.00
4,938,650.00
(61,350.00)
0.500
0.25 91
1.29%
Aaa
AA+
4346
3130AQD59
FHLB
1.000
09/30/2024
Federal Home Loan Bank
12/14/2021
12/30/2021
5,000,000.00
5,000,000.00
4,946,500.00
(53,500.00)
1.000
0.25 91
1.29%
Aaa
AA+
4349
3130AQD59
FHLB
1.000
09/30/2024
Federal Home Loan Bank
12/22/2021
12/30/2021
5,000,000.00
5,000,000.00
4,946,500.00
(53,500.00)
1.000
0.25 91
1.29%
Aaa
AA+
4334
3130AMW65
FHLB
0.500
12/30/2024
Federal Home Loan Bank
06/15/2021
06/30/2021
5,000,000.00
5,000,000.00
4,879,450.00
(120,550.00)
0.500
0.49 182
1.29%
Aaa
AA+
4332
3130AMQ62
FHLB
0.625
03/14/2025
Federal Home Loan Bank
05/26/2021
06/14/2021
5,000,000.00
5,000,000.00
4,838,200.00
(161,800.00)
0.625
0.68 256
1.29%
Aaa
AA+
4397
3130AWER7
FHLB
4.625
06/06/2025
Federal Home Loan Bank
06/14/2023
06/15/2023
3,000,000.00
2,999,109.49
2,984,730.00
(14,379.49)
4.659
0.90 340
0.77%
Aaa
AA+
4329
3135G04Z3
FNMA
0.500
06/17/2025
Fannie Mae
05/13/2021
05/14/2021
5,000,000.00
4,993,927.97
4,783,200.00
(210,727.97)
0.628
0.94 351
1.28%
Aaa
AA+
AA+
4381
3135G04Z3
FNMA
0.500
06/17/2025
Fannie Mae
01/12/2023
01/13/2023
5,000,000.00
4,840,657.89
4,783,200.00
(57,457.89)
4.013
0.94 351
1.24%
Aaa
AA+
AA+
4345
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,465,255.50
(184,744.50)
1.250
0.97 364
1.20%
Aaa
AA+
4327
3130AMDL3
FHLB
0.800
07/25/2025
Federal Home Loan Bank
05/11/2021
05/25/2021
5,000,000.00
5,000,000.00
4,780,650.00
(219,350.00)
0.800
1.04 389
1.29%
Aaa
AA+
4360
3130AQT94
FHLB
1.600
08/28/2025
Federal Home Loan Bank
03/03/2022
03/04/2022
4,575,000.00
4,563,970.20
4,409,339.25
(154,630.95)
1.816
1.12 423
1.17%
Aaa
AA+
4331
3130AMQ54
FHLB
0.700
09/16/2025
Federal Home Loan Bank
05/26/2021
06/16/2021
5,000,000.00
5,000,000.00
4,747,000.00
(253,000.00)
0.700
1.18 442
1.29%
Aaa
AA+
4318 3135GA2Z3 FNMA 0.560 11/17/2025 Fannie Mae 01/08/2021 01/11/2021 3,000,000.00 3,000,937.46 2,821,440.00 (179,497.46) 0.500 1.34 504 0.77% Aaa AA+ AA+ 4320 3130AKN36 FHLB 0.525 01/15/2026 Federal Home Loan Bank 01/14/2021 01/15/2021 5,000,000.00 4,998,461.11 4,667,850.00 (330,611.11) 0.545 1.50 563 1.28% Aaa AA+ 4321 3130AKN85 FHLB 0.550 01/20/2026 Federal Home Loan Bank 01/14/2021 01/20/2021 5,000,000.00 4,999,223.61 4,667,100.00 (332,123.61) 0.560 1.51 568 1.28% Aaa AA+ 4322 3130AKUS3 FHLB 0.500 01/28/2026 Federal Home Loan Bank 01/26/2021 01/28/2021 5,000,000.00 5,000,000.00 4,657,950.00 (342,050.00) 0.500 1.53 576 1.29% Aaa AA+ 4333 3130ALEY6 FHLB 0.800 03/04/2026 Federal Home Loan Bank 06/09/2021 06/10/2021 5,000,000.00 5,000,000.00 4,669,200.00 (330,800.00) 0.800 1.62 611 1.29% Aaa AA+ 4328 3130AMJN3 FHLB 1.030 05/26/2026 Federal Home Loan Bank 05/12/2021 05/26/2021 5,000,000.00 5,000,000.00 4,646,800.00 (353,200.00) 1.030 1.84 694 1.29% Aaa AA+ 4335 3130AMFS6 FHLB 0.750 06/12/2026 Federal Home Loan Bank 06/16/2021 06/17/2021 5,000,000.00 4,988,284.12 4,623,750.00 (364,534.12) 0.873 1.89 711 1.28% Aaa AA+ 4388 3130AVWS7 FHLB 3.750 06/12/2026 Federal Home Loan Bank 05/08/2023 05/09/2023 3,000,000.00 2,997,373.61 2,943,540.00 (53,833.61) 3.796 1.85 711 0.77% Aaa AA+ 4398 3133EPNG6 FFCB 4.375 06/23/2026 Federal Farm Credit Bank 06/22/2023 06/23/2023 3,000,000.00 2,999,110.00 2,978,820.00 (20,290.00) 4.391 1.87 722 0.77% Aaa AA+ AA+ 4347 3130AQ7E7 FHLB 1.500 06/30/2026 Federal Home Loan Bank 12/14/2021 12/30/2021 5,000,000.00 5,000,887.65 4,682,650.00 (318,237.65) 1.339 1.92 729 1.29% Aaa AA+ Portfolio: CITYBond Holdings By Sector Report
City of Huntington Beach
Reporting Period:
06/30/2024
Report Run Date: Jul 19, 2024
12 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,898,650.00 (101,350.00) 3.750 1.91 749 1.29% Aaa AA+ 4356 3130AQS79 FHLB 1.375 08/07/2026 Federal Home Loan Bank 01/27/2022 02/07/2022 5,000,000.00 5,000,000.00 4,737,050.00 (262,950.00) 1.375 2.00 767 1.29% Aaa AA+ 4386 3133EPGT6 FFCB 3.875 04/26/2027 Federal Farm Credit Bank 04/21/2023 04/26/2023 5,000,000.00 4,995,947.05 4,904,600.00 (91,347.05) 3.906 2.61 1,029 1.28% Aaa AA+ AA+ 4389 3133EPJP1 FFCB 3.625 05/12/2027 Federal Farm Credit Bank 05/08/2023 05/12/2023 5,000,000.00 4,990,083.78 4,869,600.00 (120,483.78) 3.700 2.66 1,045 1.28% Aaa AA+ AA+ 4392 3130AW4N7 FHLB 3.630 06/04/2027 Federal Home Loan Bank 05/16/2023 05/18/2023 5,000,000.00 5,000,000.00 4,864,300.00 (135,700.00) 3.630 2.72 1,068 1.29% Aaa AA+ 4396 3133EPMV4 FFCB 4.125 06/15/2027 Federal Farm Credit Bank 06/09/2023 06/15/2023 5,000,000.00 4,999,298.06 4,936,800.00 (62,498.06) 4.130 2.74 1,079 1.28% Aaa AA+ AA+ 4385 3134GYPF3 FHLMC 4.750 07/12/2027 Freddie Mac 04/21/2023 04/24/2023 3,300,000.00 3,296,442.39 3,274,821.00 (21,621.39) 4.791 1.52 1,106 0.85% 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,469,808.62 4,438,382.85 (31,425.77) 4.383 2.89 1,166 1.15% Aaa AA+ 4395 3130AWC24 FHLB 4.000 06/09/2028 Federal Home Loan Bank 06/09/2023 06/13/2023 5,000,000.00 5,003,631.85 4,933,500.00 (70,131.85) 3.979 3.58 1,439 1.29% Aaa AA+ 4399 3130AWC24 FHLB 4.000 06/09/2028 Federal Home Loan Bank 06/26/2023 06/27/2023 5,000,000.00 4,997,811.73 4,933,500.00 (64,311.73) 4.012 3.58 1,439 1.28% Aaa AA+ 4400 31422X5U2 FAMCA 5.100 08/07/2028 Farmer Mac 08/02/2023 08/07/2023 2,000,000.00 2,000,000.00 1,983,380.00 (16,620.00) 5.100 1.90 1,498 0.51% U.S. Agencies 164,980,000.00 164,786,239.28 159,593,278.60 (5,192,960.68) 42.35% 4325 91159HHX1 USB 2.400 07/30/2024 US Bank 04/28/2021 04/30/2021 3,809,000.00 3,814,532.49 3,798,410.98 (16,121.51) 0.528 0.08 29 0.98% A3 A A 4343 14913R2P1 CAT 0.600 09/13/2024 Caterpillar 11/30/2021 12/02/2021 5,000,000.00 4,996,256.14 4,950,200.00 (46,056.14) 0.980 0.20 74 1.28% A2 A A+ 4371 459200KS9 IBM 4.000 07/27/2025 IBM 08/09/2022 08/11/2022 6,000,000.00 6,011,406.19 5,914,200.00 (97,206.19) 3.810 1.02 391 1.55% A3 A- 4372 931142EW9 WMT 3.900 09/09/2025 Walmart 09/20/2022 09/22/2022 5,000,000.00 4,986,121.09 4,928,250.00 (57,871.09) 4.150 1.13 435 1.28% Aa2 AA AA 4382 717081DV2 PFE 2.750 06/03/2026 Pfizer Inc 01/13/2023 01/18/2023 5,000,000.00 4,876,294.32 4,781,350.00 (94,944.32) 4.142 1.83 702 1.25% A2 A WD 4375 110122CN6 BMY 3.200 06/15/2026 Bristol-Myers Squibb 11/14/2022 11/16/2022 5,000,000.00 4,885,470.29 4,820,350.00 (65,120.29) 4.480 1.84 714 1.26% A2 A 4390 931142EM1 WMT 3.050 07/08/2026 Walmart 05/11/2023 05/15/2023 4,257,000.00 4,200,511.68 4,113,964.80 (86,546.88) 3.752 1.87 737 1.08% Aa2 AA AA 4391 904764AU1 UNANA 2.000 07/28/2026 Unilever 05/11/2023 05/15/2023 2,505,000.00 2,419,926.16 2,354,148.90 (65,777.26) 3.752 1.97 757 0.62% A1 A+ WD 4404 037833DN7 AAPL 2.050 09/11/2026 Apple 12/04/2023 12/06/2023 5,000,000.00 4,741,562.81 4,700,450.00 (41,112.81) 4.583 2.09 802 1.22% Aaa AA+ 4407 713448DN5 PEP 2.375 10/06/2026 Pepsi 12/21/2023 12/26/2023 5,000,000.00 4,799,306.25 4,726,000.00 (73,306.25) 4.273 2.14 827 1.23% A1 A+ WD 4412 24422EXB0 DE 4.950 07/14/2028 John Deere 03/25/2024 03/27/2024 5,000,000.00 5,051,751.97 5,005,250.00 (46,501.97) 4.662 3.53 1,474 1.30% A1 A A+ Corporates 51,571,000.00 50,783,139.39 50,092,574.68 (690,564.71) 13.05% Bond Holdings 347,551,000.00 345,795,033.40 336,907,153.28 (8,887,880.12) 88.88% Portfolio: CITYBond Holdings By Sector Report
City of Huntington Beach
Reporting Period:
06/30/2024
Report Run Date: Jul 19, 2024
13 Statement of Cash Receipts and Disbursements and
Cash Receipts and Disbursements May 2024 June 2024
Receipts
General Fund
Property Tax 18,152,473$ 543,241$
Local Sales Tax 4,760,809 3,681,592
Public Safety Sales Tax 205,869 284,457
Transient Occupancy Tax (TOT) 1,224,297 1,387,683
Utility Users Tax (UUT) 1,919,726 1,674,744
Other Revenue 5,892,158 5,026,618
Total General Fund Revenue 32,155,333 12,598,334
Total All Other Funds Revenue 22,894,140 18,374,339
Total Receipts 55,049,473$ 30,972,674$
Disbursements
General Fund
Personnel Services (18,341,172) (12,959,514)
Operating Expenses (4,160,884) (3,465,058)
Capital Expenditures ‐ ‐
Non‐Operating Expenses (1,261,983) (962,675)
Total General Fund Disbursements (23,764,039) (17,387,247) Total All Other Funds Disbursements (19,094,488) (38,065,071) Total Disbursements (42,858,527) (55,452,319)
Net Change in Cash Flow 12,190,946$ (24,479,645)$ Summary of Cash by Fund May 2024 June 2024
General Fund 160,402,282$ 155,613,368$
General Fund Other 5,104,628 5,094,155
Capital Projects Funds 41,513,503 39,818,953
Debt Service Funds 30,070,997 12,009,066
Enterprise Funds 85,549,942 86,695,176
Trust and Agency Funds 16,873,163 20,187,203
Internal Service Funds 48,800,219 43,993,337
Special Revenue Funds 46,130,350 46,554,181
General Ledger Cash Balances * 434,445,084$ 409,965,439$ Total cash will differ from investment portfolio total due to outstanding checks and/or other timing differences.
Note: Above information was obtained from the City's accounting system records. The above information includes receipts from maturing investments and payments for purchased investments in the city investment portfolio. This statement is prepared in compliance with the City's Charter.
Summary of Cash by Fund
City Treasurer's Office
June 2024
14 Portfolio Summary
City of Huntington Beach
Portfolio: CITY
Reporting Date: (FY2024)
05/01/2024 - 05/31/2024
Full Accrual Basis
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
$16,006,903.09 $16,006,903.09 $16,006,903.09 3.75% 5.18% 0.19% 1 $38,439,574.75 $38,439,574.75 $38,439,574.75 9.00% 5.43% 0.49% 1 $93,000,000.00 $92,642,861.03 $90,195,980.00 21.69% 2.39% 0.52% 591 $50,000,000.00 $49,563,465.04 $48,430,800.00 11.60% 2.97% 0.34% 990 $174,980,000.00 $174,770,978.97 $169,090,667.70 40.91% 2.27% 0.93% 599 $56,571,000.00 $55,753,910.87 $54,988,862.88 13.05% 3.40% 0.44% 603 $428,997,477.84 $427,177,693.76 $417,152,788.42 100.00% 2.92% 567 Portfolio Investments
05/31/2024
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 1
Total Activity 1
Period Transactions
Redemptions 12
Purchases 14
Total Activity 26
Net Period Earnings $9,043,033.35
Last FY Period Net Earnings $5,165,800.01
Avg Daily Book Balance $372,710,858.28
$1.00 $1.00
Net Effective Annual Return 2.646%
Net Period Earnings $1,012,056.22
Last FY Period Net Earnings $705,575.05
Avg Daily Book Balance $418,365,294.00
$1.00 $1.00
Net Effective Annual Return 2.894%
Fiscal YTD Summary (336 Days)Period Earnings Summary (31 Days) ______________________________________________ __________________ sum2
Total Market Value
$1.00
$417,152,788.42
sum2
Total Book Value
$2.00
$427,177,693.76
Market Value
Book Value
Par Value
sum2
Total Par Value
$1.00
$428,997,477.84
The City Portfolio uses a 12 month moving average of the 1.5Yr Treasury for comparison purposes. This period, that rate is equal to: 4.970% ____________________________________________
15 Accounting ID Ticker Pool Description Type Par Value Book Value Market Value Rate % of Portfolio 104 FUZXX First American Treasury Obligations Cash/Money Market 16,006,903.09 16,006,903.09 16,006,903.09 5.180 3.75% Cash/Money Market Total 16,006,903.09 16,006,903.09 16,006,903.09 3.75% 003 CAMP California Asset Management Program LGIP 38,439,574.75 38,439,574.75 38,439,574.75 5.430 9.00% LGIP Total 38,439,574.75 38,439,574.75 38,439,574.75 9.00% Portfolio: CITYCash By Structure Report
City of Huntington Beach
Reporting Period:
05/31/2024
Report Run Date: Jul 19, 2024
16 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 Portfolio: CITY Bond Redemption Activity Report
City of Huntington Beach
Reporting Period:
05/31/2024
Report Run Date: Jul 19, 2024
17 Accounting ID Transaction Type Cusip Description Price Settlement Date Posted Date Par Value Principal Accrued Interest Total 4413
Buy
45818WFN1
IADB 4.850 07/19/2027
100.23300
05/29/2024
05/29/2024
10,000,000.00
10,023,300.00
45,805.56
10,069,105.56
Activity Total 10,000,000.00 10,023,300.00 45,805.56 10,069,105.56 Portfolio: CITY Bond Purchase Activity Report
City of Huntington Beach
Reporting Period:
05/31/2024
Report Run Date: Jul 19, 2024
18 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
05/13/2024
90,625.00
90,625.00
4318
Interest Income
3135GA2Z3
FNMA 0.560 11/17/2025
05/17/2024
8,400.00
8,400.00
4327
Interest Income
3130AMDL3
FHLB 0.800 07/25/2025
05/28/2024
20,000.00
20,000.00
4328
Interest Income
3130AMJN3
FHLB 1.030 05/26/2026
05/28/2024
25,750.00
25,750.00
Activity Total 144,775.00 0.00 144,775.00 Portfolio: CITY Bond Interest Received Report
City of Huntington Beach
Reporting Period:
05/31/2024
Report Run Date: Jul 19, 2024
19 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,994,739.99 6,981,170.00 (13,569.99) 2.730 0.08 29 1.64% 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,998,223.04
4,987,450.00
(10,773.04)
2.462
0.08 29
1.17%
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,005,844.99 4,970,700.00 (35,144.99) 1.028 0.16 60 1.17% Aaa AA+ AA+ 4358 912828Y87 T 1.750 07/31/2024 U.S. Treasury Note 02/10/2022 02/11/2022 4,000,000.00 4,000,993.56 3,976,560.00 (24,433.56) 1.595 0.16 60 0.94% Aaa AA+ AA+ 4361 912828D56 T 2.375 08/15/2024 U.S. Treasury Note 03/21/2022 03/22/2022 5,000,000.00 5,001,336.23 4,969,750.00 (31,586.23) 2.240 0.20 75 1.17% Aaa AA+ AA+ 4298 912828YH7 T 1.500 09/30/2024 U.S. Treasury Note 12/04/2019 12/05/2019 5,000,000.00 4,998,488.36 4,938,000.00 (60,488.36) 1.595 0.33 121 1.17% Aaa AA+ AA+ 4350 912828YM6 T 1.500 10/31/2024 U.S. Treasury Note 12/30/2021 12/31/2021 3,000,000.00 3,007,124.17 2,953,980.00 (53,144.17) 0.920 0.41 152 0.70% Aaa AA+ AA+ 4376 91282CEU1 T 2.875 06/15/2025 U.S. Treasury Note 11/17/2022 11/18/2022 3,000,000.00 2,959,080.10 2,930,760.00 (28,320.10) 4.276 0.99 379 0.69% Aaa AA+ AA+ 4330 91282CAB7 T 0.250 07/31/2025 U.S. Treasury Note 05/18/2021 05/19/2021 5,000,000.00 4,979,054.76 4,729,300.00 (249,754.76) 0.615 1.13 425 1.17% Aaa 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,970,188.28 4,710,550.00 (259,638.28) 0.735 1.22 456 1.16% Aaa AA+ AA+ 4351 9128284Z0 T 2.750 08/31/2025 U.S. Treasury Note 12/30/2021 12/31/2021 5,000,000.00 5,100,394.92 4,858,800.00 (241,594.92) 1.103 1.20 456 1.19% Aaa AA+ AA+ 4411 91282CHM6 T 4.500 07/15/2026 U.S. Treasury Note 03/11/2024 03/12/2024 5,000,000.00 5,011,723.16 4,965,650.00 (46,073.16) 4.380 1.96 774 1.17% Aaa AA+ AA+ 4341 91282CCP4 T 0.625 07/31/2026 U.S. Treasury Note 09/30/2021 09/30/2021 5,000,000.00 4,965,709.79 4,574,400.00 (391,309.79) 0.950 2.09 790 1.16% Aaa AA+ AA+ 4339 91282CCW9 T 0.750 08/31/2026 U.S. Treasury Note 09/23/2021 09/23/2021 1,000,000.00 996,926.37 914,610.00 (82,316.37) 0.890 2.17 821 0.23% Aaa AA+ AA+ 4342 91282CCW9 T 0.750 08/31/2026 U.S. Treasury Note 11/22/2021 11/23/2021 5,000,000.00 4,941,824.23 4,573,050.00 (368,774.23) 1.285 2.17 821 1.16% Aaa AA+ AA+ 4379 91282CEW7 T 3.250 06/30/2027 U.S. Treasury Note 12/28/2022 12/29/2022 5,000,000.00 4,895,223.24 4,801,150.00 (94,073.24) 4.000 2.83 1,124 1.15% Aaa AA+ AA+ 4406 91282CEW7 T 3.250 06/30/2027 U.S. Treasury Note 12/21/2023 12/22/2023 5,000,000.00 4,898,787.56 4,801,150.00 (97,637.56) 3.960 2.83 1,124 1.15% Aaa AA+ AA+ 4409
91282CFB2
T
2.750
07/31/2027
U.S. Treasury Note
01/18/2024
01/19/2024
5,000,000.00
4,805,737.78
4,722,650.00
(83,087.78)
4.080
2.94 1,155
1.12%
Aaa
AA+
AA+
4408
91282CHQ7
T
4.125
07/31/2028
U.S. Treasury Note
01/12/2024
01/16/2024
10,000,000.00
10,111,460.49
9,836,300.00
(275,160.49)
3.831
3.71 1,521
2.37%
Aaa
AA+
AA+
U.S. Treasuries 93,000,000.00 92,642,861.03 90,195,980.00 (2,446,881.03) 21.69% 4323
459056HV2
IBRD
1.500
08/28/2024
Int'l Bank for Recon and Dev
04/21/2021
04/23/2021
5,000,000.00
5,012,880.33
4,953,350.00
(59,530.33)
0.425
0.24 88
1.17%
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,988,110.57
4,732,650.00
(255,460.57)
0.583
1.13 422
1.17%
Aaa
AAA
AAA
4319
459058JL8
IBRD
0.500
10/28/2025
Int'l Bank for Recon and Dev
01/08/2021
01/12/2021
5,000,000.00
4,999,192.21
4,689,000.00
(310,192.21)
0.512
1.37 514
1.17%
Aaa
AAA
AAA
4324
45906M2L4
IBRD
0.650
02/24/2026
Int'l Bank for Recon and Dev
04/28/2021
04/30/2021
5,000,000.00
4,981,389.04
4,626,100.00
(355,289.04)
0.870
1.68 633
1.17%
Aaa
AAA
AAA
4413
45818WFN1
IADB
4.850
07/19/2027
Inter-American Development Bank
05/28/2024
05/29/2024
10,000,000.00
10,023,258.76
10,034,700.00
11,441.24
4.770
2.85 1,143
2.35%
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,852,769.61
4,828,450.00
(24,319.61)
4.622
3.59 1,469
1.14%
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,769,779.04
4,785,600.00
15,820.96
4.760
3.70 1,502
1.12%
Aaa
AAA
AAA
4403
459058KT9
IBRD
3.500
07/12/2028
Int'l Bank for Recon and Dev
12/04/2023
12/06/2023
5,000,000.00
4,842,912.05
4,785,600.00
(57,312.05)
4.350
3.70 1,502
1.13%
Aaa
AAA
AAA
4410
459058KW2
IBRD
4.625
08/01/2028
Int'l Bank for Recon and Dev
01/23/2024
01/25/2024
5,000,000.00
5,093,173.43
4,995,350.00
(97,823.43)
4.130
3.68 1,522
1.19%
Aaa
AAA
AAA
Supranational 50,000,000.00 49,563,465.04 48,430,800.00 (1,132,665.04) 11.60% 4378
3130ATVC8
FHLB
4.875
06/14/2024
Federal Home Loan Bank
12/27/2022
12/28/2022
5,000,000.00
5,000,216.25
4,999,250.00
(966.25)
4.740
0.04 13
1.17%
Aaa
AA+
4348
3130AQD42
FHLB
0.920
06/28/2024
Federal Home Loan Bank
12/14/2021
12/28/2021
5,000,000.00
5,000,000.00
4,984,550.00
(15,450.00)
0.920
0.07 27
1.17%
Aaa
AA+
4380
3134GYCP5
FHLMC
5.000
07/23/2024
Freddie Mac
01/05/2023
01/23/2023
5,000,000.00
5,000,000.00
4,996,500.00
(3,500.00)
5.000
0.14 52
1.17%
Aaa
AA+
AA+
4344
3130AQ3C5
FHLB
1.000
08/28/2024
Federal Home Loan Bank
12/01/2021
12/02/2021
4,000,000.00
4,000,000.00
3,957,320.00
(42,680.00)
1.000
0.24 88
0.94%
Aaa
AA+
4373
3133XVDG3
FHLB
4.375
09/13/2024
Federal Home Loan Bank
09/22/2022
09/23/2022
5,000,000.00
5,001,802.96
4,983,600.00
(18,202.96)
4.240
0.28 104
1.17%
Aaa
AA+
4336
3130AMXJ6
FHLB
0.500
09/30/2024
Federal Home Loan Bank
06/17/2021
06/30/2021
5,000,000.00
5,000,000.00
4,917,350.00
(82,650.00)
0.500
0.32 121
1.17%
Aaa
AA+
4346
3130AQD59
FHLB
1.000
09/30/2024
Federal Home Loan Bank
12/14/2021
12/30/2021
5,000,000.00
5,000,000.00
4,927,400.00
(72,600.00)
1.000
0.32 121
1.17%
Aaa
AA+
4349
3130AQD59
FHLB
1.000
09/30/2024
Federal Home Loan Bank
12/22/2021
12/30/2021
5,000,000.00
5,000,000.00
4,927,400.00
(72,600.00)
1.000
0.32 121
1.17%
Aaa
AA+
4334
3130AMW65
FHLB
0.500
12/30/2024
Federal Home Loan Bank
06/15/2021
06/30/2021
5,000,000.00
5,000,000.00
4,864,500.00
(135,500.00)
0.500
0.57 212
1.17%
Aaa
AA+
4332
3130AMQ62
FHLB
0.625
03/14/2025
Federal Home Loan Bank
05/26/2021
06/14/2021
5,000,000.00
5,000,000.00
4,823,950.00
(176,050.00)
0.625
0.76 286
1.17%
Aaa
AA+
4397
3130AWER7
FHLB
4.625
06/06/2025
Federal Home Loan Bank
06/14/2023
06/15/2023
3,000,000.00
2,999,029.75
2,983,410.00
(15,619.75)
4.659
0.96 370
0.70%
Aaa
AA+
4329
3135G04Z3
FNMA
0.500
06/17/2025
Fannie Mae
05/13/2021
05/14/2021
5,000,000.00
4,993,401.49
4,767,950.00
(225,451.49)
0.628
1.02 381
1.17%
Aaa
AA+
AA+
4381
3135G04Z3
FNMA
0.500
06/17/2025
Fannie Mae
01/12/2023
01/13/2023
5,000,000.00
4,826,842.11
4,767,950.00
(58,892.11)
4.013
1.02 381
1.13%
Aaa
AA+
AA+
4345 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,470,649.50 (179,350.50) 1.250 1.05 394 1.09% Aaa AA+ 4327 3130AMDL3 FHLB 0.800 07/25/2025 Federal Home Loan Bank 05/11/2021 05/25/2021 5,000,000.00 5,000,000.00 4,765,550.00 (234,450.00) 0.800 1.12 419 1.17% Aaa AA+ 4360 3130AQT94 FHLB 1.600 08/28/2025 Federal Home Loan Bank 03/03/2022 03/04/2022 4,575,000.00 4,563,176.69 4,396,026.00 (167,150.69) 1.816 1.20 453 1.07% Aaa AA+ 4331 3130AMQ54 FHLB 0.700 09/16/2025 Federal Home Loan Bank 05/26/2021 06/16/2021 5,000,000.00 5,000,000.00 4,731,350.00 (268,650.00) 0.700 1.26 472 1.17% Aaa AA+ 4318 3135GA2Z3 FNMA 0.560 11/17/2025 Fannie Mae 01/08/2021 01/11/2021 3,000,000.00 3,000,994.16 2,812,080.00 (188,914.16) 0.500 1.42 534 0.70% Aaa AA+ AA+ 4320 3130AKN36 FHLB 0.525 01/15/2026 Federal Home Loan Bank 01/14/2021 01/15/2021 5,000,000.00 4,998,377.78 4,649,650.00 (348,727.78) 0.545 1.58 593 1.17% Aaa AA+ 4321 3130AKN85 FHLB 0.550 01/20/2026 Federal Home Loan Bank 01/14/2021 01/20/2021 5,000,000.00 4,999,181.94 4,648,900.00 (350,281.94) 0.560 1.59 598 1.17% Aaa AA+ 4322 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,635,800.00 (364,200.00) 0.500 1.61 606 1.17% Aaa AA+ 4333 3130ALEY6 FHLB 0.800 03/04/2026 Federal Home Loan Bank 06/09/2021 06/10/2021 5,000,000.00 5,000,000.00 4,650,350.00 (349,650.00) 0.800 1.70 641 1.17% Aaa AA+ 4328 3130AMJN3 FHLB 1.030 05/26/2026 Federal Home Loan Bank 05/12/2021 05/26/2021 5,000,000.00 5,000,000.00 4,635,100.00 (364,900.00) 1.030 1.92 724 1.17% Aaa AA+ Portfolio: CITYBond Holdings By Sector Report
City of Huntington Beach
Reporting Period:
05/31/2024
Report Run Date: Jul 19, 2024
20 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
4335 3130AMFS6 FHLB 0.750 06/12/2026 Federal Home Loan Bank 06/16/2021 06/17/2021 5,000,000.00 4,987,782.73 4,604,100.00 (383,682.73) 0.873 1.96 741 1.17% Aaa AA+ 4388 3130AVWS7 FHLB 3.750 06/12/2026 Federal Home Loan Bank 05/08/2023 05/09/2023 3,000,000.00 2,997,261.21 2,937,210.00 (60,051.21) 3.796 1.89 741 0.70% Aaa AA+ 4398 3133EPNG6 FFCB 4.375 06/23/2026 Federal Farm Credit Bank 06/22/2023 06/23/2023 3,000,000.00 2,999,072.50 2,969,280.00 (29,792.50) 4.391 1.90 752 0.70% Aaa AA+ AA+ 4347 3130AQ7E7 FHLB 1.500 06/30/2026 Federal Home Loan Bank 12/14/2021 12/30/2021 5,000,000.00 5,000,924.69 4,664,800.00 (336,124.69) 1.339 1.99 759 1.17% Aaa AA+ 4384 3130AUMC5 FHLB 3.750 07/20/2026 Federal Home Loan Bank 01/17/2023 01/19/2023 5,000,000.00 5,000,000.00 4,886,800.00 (113,200.00) 3.750 1.99 779 1.17% Aaa AA+ 4356 3130AQS79 FHLB 1.375 08/07/2026 Federal Home Loan Bank 01/27/2022 02/07/2022 5,000,000.00 5,000,000.00 4,717,400.00 (282,600.00) 1.375 2.08 797 1.17% Aaa AA+ 4386 3133EPGT6 FFCB 3.875 04/26/2027 Federal Farm Credit Bank 04/21/2023 04/26/2023 5,000,000.00 4,995,827.26 4,889,300.00 (106,527.26) 3.906 2.69 1,059 1.17% Aaa AA+ AA+ 4389 3133EPJP1 FFCB 3.625 05/12/2027 Federal Farm Credit Bank 05/08/2023 05/12/2023 5,000,000.00 4,989,795.24 4,854,400.00 (135,395.24) 3.700 2.74 1,075 1.17% Aaa AA+ AA+ 4392 3130AW4N7 FHLB 3.630 06/04/2027 Federal Home Loan Bank 05/16/2023 05/18/2023 5,000,000.00 5,000,000.00 4,849,350.00 (150,650.00) 3.630 2.75 1,098 1.17% Aaa AA+ 4396 3133EPMV4 FFCB 4.125 06/15/2027 Federal Farm Credit Bank 06/09/2023 06/15/2023 5,000,000.00 4,999,278.26 4,920,900.00 (78,378.26) 4.130 2.76 1,109 1.17% Aaa AA+ AA+ 4385 3134GYPF3 FHLMC 4.750 07/12/2027 Freddie Mac 04/21/2023 04/24/2023 3,300,000.00 3,296,344.57 3,267,957.00 (28,387.57) 4.791 1.62 1,136 0.77% Aaa AA+ AA+ 4405 3130AWWN6 FHLB 4.500 09/10/2027 Federal Home Loan Bank 12/04/2023 12/05/2023 4,455,000.00 4,470,195.27 4,434,685.20 (35,510.07) 4.383 2.97 1,196 1.05% Aaa AA+ 4395 3130AWC24 FHLB 4.000 06/09/2028 Federal Home Loan Bank 06/09/2023 06/13/2023 5,000,000.00 5,003,708.69 4,907,800.00 (95,908.69) 3.979 3.59 1,469 1.17% Aaa AA+ 4399 3130AWC24 FHLB 4.000 06/09/2028 Federal Home Loan Bank 06/26/2023 06/27/2023 5,000,000.00 4,997,765.43 4,907,800.00 (89,965.43) 4.012 3.59 1,469 1.17% Aaa AA+ 4400 31422X5U2 FAMCA 5.100 08/07/2028 Farmer Mac 08/02/2023 08/07/2023 2,000,000.00 2,000,000.00 1,982,300.00 (17,700.00) 5.100 1.99 1,528 0.47% U.S. Agencies 174,980,000.00 174,770,978.97 169,090,667.70 (5,680,311.27) 40.91% 4355 67066GAL8 NVDA 0.584 06/14/2024 Nvidia 01/20/2022 01/24/2022 5,000,000.00 4,998,818.66 4,987,450.00 (11,368.66) 1.250 0.04 13 1.17% Aa3 AA- 4325 91159HHX1 USB 2.400 07/30/2024 US Bank 04/28/2021 04/30/2021 3,809,000.00 3,820,255.76 3,789,002.75 (31,253.01) 0.528 0.16 59 0.89% A3 A A 4343 14913R2P1 CAT 0.600 09/13/2024 Caterpillar 11/30/2021 12/02/2021 5,000,000.00 4,994,696.20 4,932,150.00 (62,546.20) 0.980 0.28 104 1.17% A2 A A+ 4371 459200KS9 IBM 4.000 07/27/2025 IBM 08/09/2022 08/11/2022 6,000,000.00 6,012,292.68 5,910,000.00 (102,292.68) 3.810 1.10 421 1.41% A3 A- 4372 931142EW9 WMT 3.900 09/09/2025 Walmart 09/20/2022 09/22/2022 5,000,000.00 4,985,148.27 4,927,650.00 (57,498.27) 4.150 1.21 465 1.17% Aa2 AA AA 4382 717081DV2 PFE 2.750 06/03/2026 Pfizer Inc 01/13/2023 01/18/2023 5,000,000.00 4,870,931.36 4,784,000.00 (86,931.36) 4.142 1.89 732 1.14% A2 A WD 4375 110122CN6 BMY 3.200 06/15/2026 Bristol-Myers Squibb 11/14/2022 11/16/2022 5,000,000.00 4,880,589.76 4,811,900.00 (68,689.76) 4.480 1.89 744 1.14% A2 A 4390 931142EM1 WMT 3.050 07/08/2026 Walmart 05/11/2023 05/15/2023 4,257,000.00 4,198,180.66 4,103,492.58 (94,688.08) 3.752 1.95 767 0.98% Aa2 AA AA 4391 904764AU1 UNANA 2.000 07/28/2026 Unilever 05/11/2023 05/15/2023 2,505,000.00 2,416,509.54 2,350,967.55 (65,541.99) 3.752 2.05 787 0.57% A1 A+ WD 4404 037833DN7 AAPL 2.050 09/11/2026 Apple 12/04/2023 12/06/2023 5,000,000.00 4,731,748.74 4,687,200.00 (44,548.74) 4.583 2.17 832 1.11% Aaa AA+ 4407 713448DN5 PEP 2.375 10/06/2026 Pepsi 12/21/2023 12/26/2023 5,000,000.00 4,791,918.75 4,713,100.00 (78,818.75) 4.273 2.22 857 1.12% A1 A+ WD 4412 24422EXB0 DE 4.950 07/14/2028 John Deere 03/25/2024 03/27/2024 5,000,000.00 5,052,820.49 4,991,950.00 (60,870.49) 4.662 3.60 1,504 1.18% A1 A A+ Corporates 56,571,000.00 55,753,910.87 54,988,862.88 (765,047.99) 13.05% Bond Holdings 374,551,000.00 372,731,215.92 362,706,310.58 (10,024,905.34) 87.25% Portfolio: CITYBond Holdings By Sector Report
City of Huntington Beach
Reporting Period:
05/31/2024
Report Run Date: Jul 19, 2024
21 Statement of Cash Receipts and Disbursements and
Cash Receipts and Disbursements April 2024 May 2024
Receipts
General Fund
Property Tax 22,852,792$ 18,152,473$
Local Sales Tax 3,372,318 4,760,809
Public Safety Sales Tax 216,280 205,869
Transient Occupancy Tax (TOT) 1,524,811 1,224,297
Utility Users Tax (UUT) 1,846,676 1,919,726
Other Revenue 8,768,017 5,892,158
Total General Fund Revenue 38,580,895 32,155,333
Total All Other Funds Revenue 17,981,968 22,894,140
Total Receipts 56,562,863$ 55,049,473$
Disbursements
General Fund
Personnel Services (12,314,628) (18,341,172)
Operating Expenses (4,021,838) (4,160,884)
Capital Expenditures ‐ ‐
Non‐Operating Expenses (65,934) (1,261,983)
Total General Fund Disbursements (16,402,400) (23,764,039) Total All Other Funds Disbursements (14,906,182) (19,094,488) Total Disbursements (31,308,582) (42,858,527)
Net Change in Cash Flow 25,254,281$ 12,190,946$ Summary of Cash by Fund April 2024 May 2024
General Fund 149,601,480$ 157,992,774$
General Fund Other 5,083,679 5,173,039
Capital Projects Funds 45,849,522 41,007,435
Debt Service Funds 28,790,903 29,793,692
Enterprise Funds 83,529,012 84,692,615
Trust and Agency Funds 12,537,646 16,314,220
Internal Service Funds 45,739,512 48,298,793
Special Revenue Funds 45,679,524 45,729,654
General Ledger Cash Balances * 416,811,277$ 429,002,223$ Total cash will differ from investment portfolio total due to outstanding checks and/or other timing differences.
Note: Above information was obtained from the City's accounting system records. The above information includes receipts from maturing investments and payments for purchased investments in the city investment portfolio. This statement is prepared in compliance with the City's Charter.
Summary of Cash by Fund
City Treasurer's Office
May 2024
22 Portfolio Summary
City of Huntington Beach
Portfolio: CITY
Reporting Date: (FY2024)
04/01/2024 - 04/30/2024
Full Accrual Basis
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
$14,890,200.52 $14,890,200.52 $14,890,200.52 3.58% 5.17% 0.19% 1 $38,324,381.03 $38,324,381.03 $38,324,381.03 9.22% 5.44% 0.50% 1 $93,000,000.00 $92,628,601.44 $89,734,940.00 22.27% 2.39% 0.53% 622 $40,000,000.00 $39,533,815.98 $38,135,300.00 9.51% 2.51% 0.24% 981 $174,980,000.00 $174,756,001.47 $168,174,369.80 42.02% 2.27% 0.95% 630 $56,571,000.00 $55,723,137.53 $54,744,907.17 13.40% 3.40% 0.45% 634 $417,765,581.55 $415,856,137.97 $404,004,098.52 100.00% 2.87% 582 Portfolio Investments
04/30/2024
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 0
Total Activity 0
Period Transactions
Redemptions 12
Purchases 13
Total Activity 25
Net Period Earnings $8,030,977.13
Last FY Period Net Earnings $4,460,224.96
Avg Daily Book Balance $368,145,414.71
$1.00 $1.00
Net Effective Annual Return 2.623%
Net Period Earnings $911,251.90
Last FY Period Net Earnings $584,762.41
Avg Daily Book Balance $398,096,266.61
$1.00 $1.00
Net Effective Annual Return 2.829%
Fiscal YTD Summary (305 Days)Period Earnings Summary (30 Days) ______________________________________________ __________________ sum2
Total Market Value
$1.00
$404,004,098.52
sum2
Total Book Value
$2.00
$415,856,137.97
Market Value
Book Value
Par Value
sum2
Total Par Value
$1.00
$417,765,581.55
The City Portfolio uses a 12 month moving average of the 1.5Yr Treasury for comparison purposes. This period, that rate is equal to: 4.930% ____________________________________________
23 Accounting ID Ticker Pool Description Type Par Value Book Value Market Value Rate % of Portfolio 104 FUZXX First American Treasury Obligations Cash/Money Market 14,890,200.52 14,890,200.52 14,890,200.52 5.170 3.58% Cash/Money Market Total 14,890,200.52 14,890,200.52 14,890,200.52 3.58% 003 CAMP California Asset Management Program LGIP 38,324,381.03 38,324,381.03 38,324,381.03 5.440 9.22% LGIP Total 38,324,381.03 38,324,381.03 38,324,381.03 9.22% Portfolio: CITYCash By Structure Report
City of Huntington Beach
Reporting Period:
04/30/2024
Report Run Date: Jul 19, 2024
24 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 Portfolio: CITY Bond Redemption Activity Report
City of Huntington Beach
Reporting Period:
04/30/2024
Report Run Date: Jul 19, 2024
25 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 Portfolio: CITY Bond Purchase Activity Report
City of Huntington Beach
Reporting Period:
04/30/2024
Report Run Date: Jul 19, 2024
26 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
04/01/2024
37,500.00
37,500.00
4336
Interest Income
3130AMXJ6
FHLB 0.500 09/30/2024
04/01/2024
12,500.00
12,500.00
4407
Interest Income
713448DN5
PEP 2.375 10/06/2026
04/08/2024
59,375.00
26,388.89
32,986.11
4386
Interest Income
3133EPGT6
FFCB 3.875 04/26/2027
04/26/2024
96,875.00
96,875.00
4319
Interest Income
459058JL8
IBRD 0.500 10/28/2025
04/29/2024
12,500.00
12,500.00
4350
Interest Income
912828YM6
T 1.500 10/31/2024
04/30/2024
22,500.00
22,500.00
Activity Total 241,250.00 26,388.89 214,861.11 Portfolio: CITY Bond Interest Received Report
City of Huntington Beach
Reporting Period:
04/30/2024
Report Run Date: Jul 19, 2024
27 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,989,117.22 6,957,020.00 (32,097.22) 2.730 0.16 60 1.68% 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,996,323.53
4,971,400.00
(24,923.53)
2.462
0.16 60
1.20%
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,008,864.91 4,955,150.00 (53,714.91) 1.028 0.25 91 1.20% 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,001,506.90 3,964,120.00 (37,386.90) 1.595 0.25 91 0.96% Aaa AA+ AA+ 4361 912828D56 T 2.375 08/15/2024 U.S. Treasury Note 03/21/2022 03/22/2022 5,000,000.00 5,001,888.54 4,956,300.00 (45,588.54) 2.240 0.29 106 1.20% Aaa AA+ AA+ 4298 912828YH7 T 1.500 09/30/2024 U.S. Treasury Note 12/04/2019 12/05/2019 5,000,000.00 4,998,101.08 4,921,350.00 (76,751.08) 1.595 0.41 152 1.20% 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,008,577.13 2,943,240.00 (65,337.13) 0.920 0.49 183 0.72% 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,955,733.09 2,923,590.00 (32,143.09) 4.276 1.07 410 0.71% 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,977,526.99 4,703,150.00 (274,376.99) 0.615 1.22 456 1.20% 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,968,161.61 4,685,350.00 (282,811.61) 0.735 1.30 487 1.19% Aaa AA+ AA+ 4351 9128284Z0 T 2.750 08/31/2025 U.S. Treasury Note 12/30/2021 12/31/2021 5,000,000.00 5,107,220.01 4,844,150.00 (263,070.01) 1.103 1.28 487 1.23% Aaa AA+ AA+ 4411 91282CHM6 T 4.500 07/15/2026 U.S. Treasury Note 03/11/2024 03/12/2024 5,000,000.00 5,012,192.69 4,947,450.00 (64,742.69) 4.380 2.04 805 1.21% Aaa AA+ AA+ 4341 91282CCP4 T 0.625 07/31/2026 U.S. Treasury Note 09/30/2021 09/30/2021 5,000,000.00 4,964,364.23 4,540,650.00 (423,714.23) 0.950 2.17 821 1.19% Aaa AA+ AA+ 4339 91282CCW9 T 0.750 08/31/2026 U.S. Treasury Note 09/23/2021 09/23/2021 1,000,000.00 996,810.32 907,970.00 (88,840.32) 0.890 2.25 852 0.24% 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,939,627.58 4,539,850.00 (399,777.58) 1.285 2.25 852 1.19% Aaa AA+ AA+ 4379 91282CEW7 T 3.250 06/30/2027 U.S. Treasury Note 12/28/2022 12/29/2022 5,000,000.00 4,892,333.49 4,767,400.00 (124,933.49) 4.000 2.92 1,155 1.18% 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,895,996.11 4,767,400.00 (128,596.11) 3.960 2.92 1,155 1.18% Aaa AA+ AA+ 4409
91282CFB2
T
2.750
07/31/2027
U.S. Treasury Note
01/18/2024
01/19/2024
5,000,000.00
4,800,523.82
4,686,700.00
(113,823.82)
4.080
3.02 1,186
1.15%
Aaa
AA+
AA+
4408
91282CHQ7
T
4.125
07/31/2028
U.S. Treasury Note
01/12/2024
01/16/2024
10,000,000.00
10,113,732.21
9,752,700.00
(361,032.21)
3.831
3.79 1,552
2.43%
Aaa
AA+
AA+
U.S. Treasuries 93,000,000.00 92,628,601.44 89,734,940.00 (2,893,661.44) 22.27% 4323
459056HV2
IBRD
1.500
08/28/2024
Int'l Bank for Recon and Dev
04/21/2021
04/23/2021
5,000,000.00
5,017,321.83
4,936,100.00
(81,221.83)
0.425
0.32 119
1.21%
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,987,255.22
4,705,600.00
(281,655.22)
0.583
1.21 453
1.20%
Aaa
AAA
AAA
4319
459058JL8
IBRD
0.500
10/28/2025
Int'l Bank for Recon and Dev
01/08/2021
01/12/2021
5,000,000.00
4,999,144.41
4,661,750.00
(337,394.41)
0.512
1.45 545
1.20%
Aaa
AAA
AAA
4324
45906M2L4
IBRD
0.650
02/24/2026
Int'l Bank for Recon and Dev
04/28/2021
04/30/2021
5,000,000.00
4,980,492.85
4,596,000.00
(384,492.85)
0.870
1.76 664
1.20%
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,849,719.26
4,788,500.00
(61,219.26)
4.622
3.67 1,500
1.17%
Aaa
AAA
AAA
4402
459058KT9
IBRD
3.500
07/12/2028
Int'l Bank for Recon and Dev
11/09/2023
11/13/2023
5,000,000.00
4,765,115.54
4,745,800.00
(19,315.54)
4.760
3.79 1,533
1.15%
Aaa
AAA
AAA
4403
459058KT9
IBRD
3.500
07/12/2028
Int'l Bank for Recon and Dev
12/04/2023
12/06/2023
5,000,000.00
4,839,729.98
4,745,800.00
(93,929.98)
4.350
3.79 1,533
1.16%
Aaa
AAA
AAA
4410
459058KW2
IBRD
4.625
08/01/2028
Int'l Bank for Recon and Dev
01/23/2024
01/25/2024
5,000,000.00
5,095,036.90
4,955,750.00
(139,286.90)
4.130
3.76 1,553
1.23%
Aaa
AAA
AAA
Supranational 40,000,000.00 39,533,815.98 38,135,300.00 (1,398,515.98) 9.51% 4378
3130ATVC8
FHLB
4.875
06/14/2024
Federal Home Loan Bank
12/27/2022
12/28/2022
5,000,000.00
5,000,715.30
4,996,400.00
(4,315.30)
4.740
0.12 44
1.20%
Aaa
AA+
4348
3130AQD42
FHLB
0.920
06/28/2024
Federal Home Loan Bank
12/14/2021
12/28/2021
5,000,000.00
5,000,000.00
4,964,950.00
(35,050.00)
0.920
0.16 58
1.20%
Aaa
AA+
4380
3134GYCP5
FHLMC
5.000
07/23/2024
Freddie Mac
01/05/2023
01/23/2023
5,000,000.00
5,000,000.00
4,996,850.00
(3,150.00)
5.000
0.22 83
1.20%
Aaa
AA+
AA+
4344
3130AQ3C5
FHLB
1.000
08/28/2024
Federal Home Loan Bank
12/01/2021
12/02/2021
4,000,000.00
4,000,000.00
3,943,200.00
(56,800.00)
1.000
0.32 119
0.96%
Aaa
AA+
4373
3133XVDG3
FHLB
4.375
09/13/2024
Federal Home Loan Bank
09/22/2022
09/23/2022
5,000,000.00
5,002,333.24
4,982,050.00
(20,283.24)
4.240
0.36 135
1.20%
Aaa
AA+
4336
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,898,700.00
(101,300.00)
0.500
0.41 152
1.20%
Aaa
AA+
4346
3130AQD59
FHLB
1.000
09/30/2024
Federal Home Loan Bank
12/14/2021
12/30/2021
5,000,000.00
5,000,000.00
4,911,150.00
(88,850.00)
1.000
0.41 152
1.20%
Aaa
AA+
4349
3130AQD59
FHLB
1.000
09/30/2024
Federal Home Loan Bank
12/22/2021
12/30/2021
5,000,000.00
5,000,000.00
4,911,150.00
(88,850.00)
1.000
0.41 152
1.20%
Aaa
AA+
4334
3130AMW65
FHLB
0.500
12/30/2024
Federal Home Loan Bank
06/15/2021
06/30/2021
5,000,000.00
5,000,000.00
4,846,600.00
(153,400.00)
0.500
0.65 243
1.20%
Aaa
AA+
4332
3130AMQ62
FHLB
0.625
03/14/2025
Federal Home Loan Bank
05/26/2021
06/14/2021
5,000,000.00
5,000,000.00
4,802,750.00
(197,250.00)
0.625
0.85 317
1.20%
Aaa
AA+
4397
3130AWER7
FHLB
4.625
06/06/2025
Federal Home Loan Bank
06/14/2023
06/15/2023
3,000,000.00
2,998,950.00
2,979,930.00
(19,020.00)
4.659
1.04 401
0.72%
Aaa
AA+
4329
3135G04Z3
FNMA
0.500
06/17/2025
Fannie Mae
05/13/2021
05/14/2021
5,000,000.00
4,992,875.02
4,743,400.00
(249,475.02)
0.628
1.10 412
1.20%
Aaa
AA+
AA+
4381
3135G04Z3
FNMA
0.500
06/17/2025
Fannie Mae
01/12/2023
01/13/2023
5,000,000.00
4,813,026.32
4,743,400.00
(69,626.32)
4.013
1.10 412
1.16%
Aaa
AA+
AA+
4345
3130AQ5S8
FHLB
1.250
06/30/2025
Federal Home Loan Bank
12/08/2021
12/30/2021
4,650,000.00
4,650,000.00
4,451,026.50
(198,973.50)
1.250
1.13 425
1.12%
Aaa
AA+
4327 3130AMDL3 FHLB 0.800 07/25/2025 Federal Home Loan Bank 05/11/2021 05/25/2021 5,000,000.00 5,000,000.00 4,738,400.00 (261,600.00) 0.800 1.19 450 1.20% Aaa AA+ 4360 3130AQT94 FHLB 1.600 08/28/2025 Federal Home Loan Bank 03/03/2022 03/04/2022 4,575,000.00 4,562,383.18 4,366,425.75 (195,957.43) 1.816 1.28 484 1.10% Aaa AA+ 4331 3130AMQ54 FHLB 0.700 09/16/2025 Federal Home Loan Bank 05/26/2021 06/16/2021 5,000,000.00 5,000,000.00 4,698,300.00 (301,700.00) 0.700 1.34 503 1.20% Aaa AA+ 4318 3135GA2Z3 FNMA 0.560 11/17/2025 Fannie Mae 01/08/2021 01/11/2021 3,000,000.00 3,001,050.86 2,796,810.00 (204,240.86) 0.500 1.50 565 0.72% Aaa AA+ AA+ 4320 3130AKN36 FHLB 0.525 01/15/2026 Federal Home Loan Bank 01/14/2021 01/15/2021 5,000,000.00 4,998,294.44 4,618,000.00 (380,294.44) 0.545 1.66 624 1.20% Aaa AA+ 4321 3130AKN85 FHLB 0.550 01/20/2026 Federal Home Loan Bank 01/14/2021 01/20/2021 5,000,000.00 4,999,140.28 4,617,150.00 (381,990.28) 0.560 1.67 629 1.20% Aaa AA+ 4322 3130AKUS3 FHLB 0.500 01/28/2026 Federal Home Loan Bank 01/26/2021 01/28/2021 5,000,000.00 5,000,000.00 4,608,450.00 (391,550.00) 0.500 1.69 637 1.20% Aaa AA+ 4333 3130ALEY6 FHLB 0.800 03/04/2026 Federal Home Loan Bank 06/09/2021 06/10/2021 5,000,000.00 5,000,000.00 4,612,250.00 (387,750.00) 0.800 1.78 672 1.20% Aaa AA+ 4328 3130AMJN3 FHLB 1.030 05/26/2026 Federal Home Loan Bank 05/12/2021 05/26/2021 5,000,000.00 5,000,000.00 4,598,100.00 (401,900.00) 1.030 1.99 755 1.20% Aaa AA+ 4335 3130AMFS6 FHLB 0.750 06/12/2026 Federal Home Loan Bank 06/16/2021 06/17/2021 5,000,000.00 4,987,281.34 4,568,200.00 (419,081.34) 0.873 2.04 772 1.20% Aaa AA+ Portfolio: CITYBond Holdings By Sector Report
City of Huntington Beach
Reporting Period:
04/30/2024
Report Run Date: Jul 19, 2024
28 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
4388 3130AVWS7 FHLB 3.750 06/12/2026 Federal Home Loan Bank 05/08/2023 05/09/2023 3,000,000.00 2,997,148.81 2,922,240.00 (74,908.81) 3.796 1.97 772 0.72% Aaa AA+ 4398 3133EPNG6 FFCB 4.375 06/23/2026 Federal Farm Credit Bank 06/22/2023 06/23/2023 3,000,000.00 2,999,035.00 2,959,800.00 (39,235.00) 4.391 1.99 783 0.72% Aaa AA+ AA+ 4347 3130AQ7E7 FHLB 1.500 06/30/2026 Federal Home Loan Bank 12/14/2021 12/30/2021 5,000,000.00 5,000,961.73 4,627,800.00 (373,161.73) 1.339 2.07 790 1.20% Aaa AA+ 4384 3130AUMC5 FHLB 3.750 07/20/2026 Federal Home Loan Bank 01/17/2023 01/19/2023 5,000,000.00 5,000,000.00 4,860,900.00 (139,100.00) 3.750 2.07 810 1.20% Aaa AA+ 4356 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,683,350.00 (316,650.00) 1.375 2.16 828 1.20% Aaa AA+ 4386 3133EPGT6 FFCB 3.875 04/26/2027 Federal Farm Credit Bank 04/21/2023 04/26/2023 5,000,000.00 4,995,707.47 4,857,300.00 (138,407.47) 3.906 2.77 1,090 1.20% Aaa AA+ AA+ 4389 3133EPJP1 FFCB 3.625 05/12/2027 Federal Farm Credit Bank 05/08/2023 05/12/2023 5,000,000.00 4,989,506.70 4,820,700.00 (168,806.70) 3.700 2.77 1,106 1.20% Aaa AA+ AA+ 4392 3130AW4N7 FHLB 3.630 06/04/2027 Federal Home Loan Bank 05/16/2023 05/18/2023 5,000,000.00 5,000,000.00 4,816,300.00 (183,700.00) 3.630 2.83 1,129 1.20% Aaa AA+ 4396 3133EPMV4 FFCB 4.125 06/15/2027 Federal Farm Credit Bank 06/09/2023 06/15/2023 5,000,000.00 4,999,258.47 4,887,350.00 (111,908.47) 4.130 2.84 1,140 1.20% Aaa AA+ AA+ 4385 3134GYPF3 FHLMC 4.750 07/12/2027 Freddie Mac 04/21/2023 04/24/2023 3,300,000.00 3,296,246.74 3,258,090.00 (38,156.74) 4.791 1.81 1,167 0.79% Aaa AA+ AA+ 4405 3130AWWN6 FHLB 4.500 09/10/2027 Federal Home Loan Bank 12/04/2023 12/05/2023 4,455,000.00 4,470,581.91 4,404,257.55 (66,324.36) 4.383 3.05 1,227 1.08% Aaa AA+ 4395 3130AWC24 FHLB 4.000 06/09/2028 Federal Home Loan Bank 06/09/2023 06/13/2023 5,000,000.00 5,003,785.52 4,855,450.00 (148,335.52) 3.979 3.66 1,500 1.20% Aaa AA+ 4399 3130AWC24 FHLB 4.000 06/09/2028 Federal Home Loan Bank 06/26/2023 06/27/2023 5,000,000.00 4,997,719.14 4,855,450.00 (142,269.14) 4.012 3.66 1,500 1.20% Aaa AA+ 4400 31422X5U2 FAMCA 5.100 08/07/2028 Farmer Mac 08/02/2023 08/07/2023 2,000,000.00 2,000,000.00 1,971,740.00 (28,260.00) 5.100 2.32 1,559 0.48% U.S. Agencies 174,980,000.00 174,756,001.47 168,174,369.80 (6,581,631.67) 42.02% 4355 67066GAL8 NVDA 0.584 06/14/2024 Nvidia 01/20/2022 01/24/2022 5,000,000.00 4,996,092.50 4,970,550.00 (25,542.50) 1.250 0.12 44 1.20% Aa3 AA- 4325 91159HHX1 USB 2.400 07/30/2024 US Bank 04/28/2021 04/30/2021 3,809,000.00 3,825,979.02 3,779,175.53 (46,803.49) 0.528 0.24 90 0.92% A3 A A 4343 14913R2P1 CAT 0.600 09/13/2024 Caterpillar 11/30/2021 12/02/2021 5,000,000.00 4,993,136.26 4,912,000.00 (81,136.26) 0.980 0.36 135 1.20% A2 A A+ 4371 459200KS9 IBM 4.000 07/27/2025 IBM 08/09/2022 08/11/2022 6,000,000.00 6,013,179.17 5,891,580.00 (121,599.17) 3.810 1.18 452 1.45% A3 A- 4372 931142EW9 WMT 3.900 09/09/2025 Walmart 09/20/2022 09/22/2022 5,000,000.00 4,984,175.45 4,915,100.00 (69,075.45) 4.150 1.30 496 1.20% Aa2 AA AA 4382 717081DV2 PFE 2.750 06/03/2026 Pfizer Inc 01/13/2023 01/18/2023 5,000,000.00 4,865,568.40 4,764,550.00 (101,018.40) 4.142 1.97 763 1.17% A2 A A 4375 110122CN6 BMY 3.200 06/15/2026 Bristol-Myers Squibb 11/14/2022 11/16/2022 5,000,000.00 4,875,709.23 4,789,700.00 (86,009.23) 4.480 1.98 775 1.17% A2 A 4390 931142EM1 WMT 3.050 07/08/2026 Walmart 05/11/2023 05/15/2023 4,257,000.00 4,195,849.64 4,083,612.39 (112,237.25) 3.752 2.04 798 1.01% Aa2 AA AA 4391 904764AU1 UNANA 2.000 07/28/2026 Unilever 05/11/2023 05/15/2023 2,505,000.00 2,413,092.92 2,336,789.25 (76,303.67) 3.752 2.13 818 0.58% A1 A+ A 4404 037833DN7 AAPL 2.050 09/11/2026 Apple 12/04/2023 12/06/2023 5,000,000.00 4,721,934.67 4,656,450.00 (65,484.67) 4.583 2.25 863 1.14% Aaa AA+ 4407 713448DN5 PEP 2.375 10/06/2026 Pepsi 12/21/2023 12/26/2023 5,000,000.00 4,784,531.25 4,686,900.00 (97,631.25) 4.273 2.30 888 1.15% A1 A+ WD 4412 24422EXB0 DE 4.950 07/14/2028 John Deere 03/25/2024 03/27/2024 5,000,000.00 5,053,889.01 4,958,500.00 (95,389.01) 4.662 3.68 1,535 1.22% A1 A A+ Corporates 56,571,000.00 55,723,137.53 54,744,907.17 (978,230.36) 13.40% Bond Holdings 364,551,000.00 362,641,556.42 350,789,516.97 (11,852,039.45) 87.20% Portfolio: CITYBond Holdings By Sector Report
City of Huntington Beach
Reporting Period:
04/30/2024
Report Run Date: Jul 19, 2024
29 Statement of Cash Receipts and Disbursements and
Cash Receipts and Disbursements March 2024 April 2024
Receipts
General Fund
Property Tax 4,914,439$ 22,852,792$
Local Sales Tax 3,861,827 3,372,318
Public Safety Sales Tax 325,633 216,280
Transient Occupancy Tax (TOT) 938,525 1,524,811
Utility Users Tax (UUT) 1,840,310 1,846,676
Other Revenue 8,370,025 8,768,017
Total General Fund Revenue 20,250,760 38,580,895
Total All Other Funds Revenue 16,780,087 17,981,968
Total Receipts 37,030,847$ 56,562,863$
Disbursements
General Fund
Personnel Services (10,693,407) (12,314,628)
Operating Expenses (3,697,896) (4,021,838)
Capital Expenditures ‐ ‐
Non‐Operating Expenses (1,236,763) (65,934)
Total General Fund Disbursements (15,628,067) (16,402,400) Total All Other Funds Disbursements (13,748,398) (14,906,182) Total Disbursements (29,376,465) (31,308,582)
Net Change in Cash Flow 7,654,382$ 25,254,281$ Summary of Cash by Fund March 2024 April 2024
General Fund 126,414,089$ 148,592,584$
General Fund Other 5,007,108 4,962,385
Capital Projects Funds 46,117,578 45,742,371
Debt Service Funds 28,262,356 28,737,932
Enterprise Funds 81,088,525 83,371,803
Trust and Agency Funds 11,438,287 12,474,314
Internal Service Funds 46,729,357 45,636,783
Special Revenue Funds 44,656,741 45,450,151
General Ledger Cash Balances * 389,714,041$ 414,968,323$ Total cash will differ from investment portfolio total due to outstanding checks and/or other timing differences.
Note: Above information was obtained from the City's accounting system records. The above information includes receipts from maturing investments and payments for purchased investments in the city investment portfolio. This statement is prepared in compliance with the City's Charter.
Summary of Cash by Fund
City Treasurer's Office
April 2024
30