CITY OF HUNTINGTON BEACH
OFFICE OF THE CITY TREASURER
QUARTERLY INVESTMENT REPORT
POOLED PORTFOLIO
PERIOD ENDED: DECEMBER 31, 2021
PREPARED BY:
ALISA BACKSTROM, MBA, CCT, CPFIM
CITY TREASURER
COLIN STEVENS, MPP
TREASURY ASSOCIATE
INVESTMENT PORTFOLIO SUMMARY:
AS OF: December 31, 2021
Investment Type
$ in 000's Market Value Book Value % of Portfolio
Federal Agency Issues $ 122,464 $ 122,693 40.7%
Local Agency Investment Fund (LAIF) 8,679 $ 8,679 2.9%
Treasury Securities 36,872 $ 36,976 12.3%
Medium Term Notes - IADB/IBRD 35,028 35,214 11.7%
Corporate Bonds $ 47,377 47,028 15.6%
OC Investment Pool $ 50,508 $ 50,508 16.8%
TOTAL $ 300,928 $ 301,098 100%
Currently, funds within this portfolio are invested in federal agency securities, corporate bonds, medium term notes of the International Bank of Reconstruction and Development ("BRD") and the Inter-American Development Bank ("IADB"), U.S.
Treasury securities, the State of California's pooled account (Local Agency Investment Fund "LAIF"), and the Orange County Investment Pool ("OCIP"). Only the investment types allowed under California Government Code Section 53601 and the City's Investment Policy Statement are utilized.
Short-term interest rates rose over the fourth quarter of 2021. As interest rates rise, the market prices of those securities previously purchased at lower than the current market rates, will go down. This has resulted in the current market value of the portfolio being slightly lower than the book value, at $300.9 million versus $301.1 million, respectively. Increasing rates will allow excess funds being invested at these higher rates to result in additional income for the portfolio.
PORTFOLIO BREAKOUT BY TYPE - Book Value as % of Total Portfolio:
OC Investment Pool
17%
Federal Agency Issues
41%
Corporate Bonds
16%
Local Agency
Investment Fund (LAIF)
3%
Medium Term Notes
11% Treasury Securities
12%
The largest holding by security type at month-end was federal agency securities at approximately 41% of the total overall portfolio. This was followed by the Orange County Investment Pool at approximately 17% of the total portfolio as of December 31.
INVESTMENT PORTFOLIO ACTIVITY:
MONTHLY ACTIVITY: December 2021
Investment Type Purchases (Face Calls/Maturities/
$ in 000's Value)/Deposits Withdrawals
Federal Agency Issues $ 28,650
Local Agency Investment Fund (LAIF) *
Medium Term Notes - IADB/IBRD
Corporate Bonds $ 5,000
US Bank Sweep First AM Gov
Treasury Securities $ 8,000
OC Investment Pool * $ 30 $ 10,003
TOTAL $ 41,680 $ 10,003
*Includes Interest Income
QUARTERLY ACTIVITY: October 1 to December 31, 2021
Investment Type Purchases (Face Calls/Maturities/
$ in 000's Value)/Deposits Withdrawals
Federal Agency Issues $ 28,650
Local Agency Investment Fund (LAIF) * $ 13 $ 4,000
Medium Term Notes - IADB/IBRD
Corporate Bonds $ 5,000
US Bank Sweep First AM Gov $ 5,044
Treasury Securities $ 13,000
OC Investment Pool * $ 95 $ 15,009
TOTAL $ 46,758 $ 24,053
*Includes Interest Income
INVESTMENT PORTFOLIO EARNINGS:
AS OF: December 31, 2021
Total Earnings Month: December Fiscal YTD
Current Year $ 260,935 $ 1,559,409
Current Budget $ 100,000 $ 600,000
Last Year Actual $ 272,920 $ 1,816,004
Average Daily Balance $ 272,558,593 $ 276,099,096
Effective Rate of Return 1.13% 1.12%
Benchmark * 0.20% n/a
* 12-month moving average of interpolated 1.5-year treasury Earnings for the month of December 2021 were $260,935, down just slightly (-4.39%) from the same month in the prior year, as recent interest rates have been on an upward path serving to begin to increase earnings. Fiscal year-to-date earnings of $1,559,409 were down from the same period during the previous year by 14.13%. This was due primarily to investments with rates higher than the market being called over the year, and such funds reinvested at (the then available) lower rates.
The effective rate of return for December was 1.13%, with a fiscal year-to-date return of 1.12%. The increase in December's rate over that of the fiscal year-to-date depicts the trend of the recently increasing interest rates. The benchmark of the 12- month moving average of the interpolated 1.5-year U.S. Treasury was 0.20% at the end of December. As the portfolio maintains securities purchased when interest rates were higher than the present, the return of the portfolio overall fell more slowly than that of the benchmark and continues to remain higher.
TREASURY RATES:
The following chart shows the 2- and 5-year Treasury rates for the period December, 2020 to December, 2021. The 2- and 5-year Treasury rates have been increasing over the past year. These Treasury rates are proxies for the type of rates the portfolio will obtain upon investment.
Treasury Rates
1.30 -
1.25- 5Yr Tsy 1.230
1.200
1.20 1.15-
1.110
1.10-
1.05-
1.00 0.95
0.90-
0.860
0.840
0.85 0.820 0.820
0.80 0.760
· 0.75
· 0.70-
100s
0.55-
0.50-
0.45- 0,450
0.40- 0.390
0.35-
0.30-
0.25-
0.20-
0.15-
0.10-
0.05 12/31/2020 1/31/2021 212872021 4/30/2021 5431/20211 01302021 7/31/2021 913072024- 12/31/2021 2-year Treasury
COMPLIANCE:
The portfolio is in conformity with all relevant State regulations and the City's Investment Policy statement as approved by the City Council on February 1, 2021. The investment program herein shown provides sufficient cash flow liquidity to meet the next six months' obligations.
MAXIMUM
SPECIFIED % OF IN
INVESTMENT MAXIMUM PORTFOLIO/ MINIMUM QUALITY
REQUIREMENTS COMPLIANCE
TYPE MATURITY
MAXIMUM PER ?
ISSUER
Commercial Paper 270 days 25%/10% A1, "A" Rating YES
State Obligations- 5 years None/10% "A-Rating YES
CA And Others
U.S. Treasury 5 years None None YES
Obligations
U.S. Government None None YES
5 years
Agency Obligations
IBRD, IFC, IADB 5 years 10% "AA" Rating YES
Corporate Notes 5 years 30%/10% *A" Rating YES
Local Agency
Investment Fund N/A Up to $75,000,000 None
(LAIF) YES
Orange County
Investment Pool N/A Up to $75,000,000 None
(OCIP) YES
Maximum Maturities No more than 50% of portfolio maturing over 4 years. YES Note: Compliance is measured at purchase per government code.
ECONOMIC AND MARKET SUMMARY:
MARKET SUMMARY: SEPTEMBER 30, 2021 - DECEMBER 31, 2021
Fed Funds 2-Yr. 10-Yr.
As of: Rate Treasury Treasury S&P 500 DJIA
9/30/2021 0.00 - 0.25 % 0.28% 1.52% $ 4,307.54 $ 33,843.92 12/31/2021 0.00 - 0.25% 0.73% 1.52% $ 4,766.18 $ 36,338.30 % Change none 160.71% 0.00% 10.65% 7.37%
The Federal Open Market Committee (FOMC) met in December to discuss the current state of the economy and to examine potential future interest rate adjustments. They concluded that because of progress on vaccinations and strong policy support, indicators of economic activity and employment have continued to strengthen. Additionally, they highlighted that the sectors most adversely affected by the pandemic have improved in recent months but continue to be affected by COVID-
19. They stated, "Overall financial conditions remain accommodative, in part reflecting policy measures to support the economy and the flow of credit to U.S. households and businesses.
Fixed Income / Equity Markets: The yield on the 10-year U.S. Treasury finished the quarter at 1.52%, unchanged from the end of the previous quarter. The S&P 500 increased by 10.65% while the DJIA increased 7.37% respectively, over the same period.
Employment: Total nonfarm payroll employment rose by 199,000 in December, and the unemployment rate decreased to
3.9 percent. Notable job gains occurred in leisure and hospitality, professional and business services, manufacturing/construction, and in transportation and warehousing.
NOTE: The above Treasury Rates are from the U.S. Department of the Treasury, Resource Center. They are the "Treasury Yield Curve Rates," which is defined as follows: These rates are commonly referred to as "Constant Maturity Treasury" rates, or CMTs. Yields are interpolated by the Treasury from the daily yield curve.
This curve, which relates the yield on a security to its time to maturity is based on the closing market bid yields on actively traded Treasury securities in the over-the- counter market. These market yields are calculated from composites of indicative, bid-side market quotations (not actual transactions) obtained by the Federal Reserve Bank of New York at or near 3:30 PM each trading day. The CMT yield values are read from the yield curve at fixed maturities, currently 1, 2, 3 and 6 months and 1, 2, 3, 5, 7, 10, 20, and 30 years. This method provides a yield for a 10 year maturity, for example, even if no outstanding security has exactly 10 years remaining to maturity.
City of Huntington Beach
City of Huntington Beach 2000 Main St.
Huntington Beach,
Portfolio Management
NGE COUNTY Portfolio Summary
CH
October 31, 2021
Par Market Book % of Days to YT YTM
Investments Value Portfolio Term Maturity 360 Equiv. 365 Equiv.
Value Value
Federal Agency Issues - Coupon 94,000,000.00 94,315,780.00 94,048,472.14 34.93 1,589 1,151 1.215 1.232 Local Agency Investment Funds 8,679,077.93 8,679,077.93 8,679,077.93 3.22 1 1 0.200 0.203 Treasury Securities - Coupon 24,000,000.00 23,731,650.00 23,743,119.71 8.82 1,576 1,291 1.033 1.048 Medium Term Notes - Supras 35,000,000.00 35,185,850.00 35,238,847.34 13.09 1,464 1,015 1.006 1.020 Corporate Bonds 41,684,000.00 42,639,507.52 42,102,259.39 15.64 1,239 420 2,288 2.320 ORANGE COUNTY POOL 65,451,682.19 65,451,682.19 65,451,682.19 24.31 1 0.507 0.514 268,814,760.12 270,003,547.64 269,263,458.70 100.00% 1,080 715 1.135 1.150 Investments
Total Earnings October 31 Month Ending Fiscal Year To Date Fiscal Year Ending Current Year 257,917.31 1,041,398.88
Current Budget 100,000.00 400,000.00 1,200,000.00
Last Year Actual 304,009.85 1,269,818.33 3,403,369.60
Average Daily Balance 270,161,809.86 278,629,120.86
Effective Rate of Return 1.12% 1.11%
I certify that this report accurately reflects all City pooled investments and is in conformity with all State laws and the investment policy statement filed with the City Council on February 1, 2021. A copy of this policy is available at the office of the City Clerk. The investment program herein shown provides sufficient cash flow liquidity to meet the next six month's obligations. Market Values provided by US Bank Custody.
Alisa Backstrom, CITY TREASURER
Reporting period 10/01/2021-10/31/2021 Portfolio CITY
AP
Run Date: 01/14/2022 - 11:45 PM (PRF_PM1) 7.3.11
Report Ver. 7.3.11
City of Huntington Beach
Portfolio Management Page 1
Portfolio Details - Investments
October 31, 2021
Average Purchase Stated YTM Days to Maturity
CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate S&P 365 Maturity Date Federal Agency Issues - Coupon
3133ECHX5 4292 Federal Farm Credit Bank 05/23/2019 5,000,000.00 5,188, 100.00 5,002,659.42 2.260 AA 2.236 863 03/13/2024 3133EKTG1 4296 Federal Farm Credit Bank 07/01/2019 5,000,000.00 5,055,750.00 4,997,722.22 1.750 1.821 24207/01/2022 313383QR5 4281 Federal Home Loan Bank 12/20/2018 5,000,000.00 5,230,200.00 5,038,078.31 3.250 2.743 585 06/09/2023 3130AFWX1 4285 Federal Home Loan Bank 02/26/2019 5,000,000.00 5,172,850.00 5,000,000.00 2.550 2,550 575 05/30/2023 3130AKN36 4320 Federal Home Loan Bank 01/15/2021 5,000,000.00 4,907,550.00 4,995,794.44 0.525 0.545 1,536 01/15/2026 3130AKN85 4321 Federal Home Loan Bank 01/20/2021 5,000,000.00 4,891,550.00 4,997,890.28 0.550 0.560 1,541 01/20/2026 3130AKUS3 4322 Federal Home Loan Bank 01/28/2021 5,000,000.00 4,901,050.00 5,000,000.00 0.500 0.500 1,549 01/28/2026 3130AMDL3 4327 Federal Home Loan Bank 05/25/2021 5,000,000.00 4,971,500.00 5,000,000.00 0.800 0.800 1,362 07/25/2025 3130AMJN3 4328 Federal Home Loan Bank 05/26/2021 5,000,000.00 4,963,600.00 5,000,000.00 1.030 1.030 1,667 05/26/2026 3130AMQ54 4331 Federal Home Loan Bank 06/16/2021 5,000,000.00 4,956,800.00 5,000,000.00 0.700 0.700 1,415 09/16/2025 3130AMQ62 4332 Federal Home Loan Bank 06/14/2021 5,000,000.00 4,967,850.00 5,000,000.00 0.625 0.625 1,229 03/14/2025 3130ALEY6 4333 Federal Home Loan Bank 06/10/2021 5,000,000.00 4,940,950.00 5,000,000.00 0.800 0.800 1,584 03/04/2026 3130AMW65 4334 Federal Home Loan Bank 06/30/2021 5,000,000.00 4,962,900.00 5,000,000.00 0.500 0.500 1,155 12/30/2024 3130AMFS6 4335 Federal Home Loan Bank 06/17/2021 5,000,000.00 4,914,750.00 4,972,239.55 0.750 0.873 1,684 06/12/2026 3130AMXJ6 4336 Federal Home Loan Bank 06/30/2021 5,000,000.00 4,973,500.00 5,000,000.00 0.500 0.500 1,064 09/30/2024 3137EAEN5 4287 Federal Home Loan Mort Corp 03/08/2019 3,000,000.00 3,111,330.00 3,013,851.01 2.750 2.450 595 06/19/2023 3137EAENS 4288 Federal Home Loan Mort Corp 03/14/2019 3,000,000.00 3,111,330.00 3,014,468.25 2.750 2.437 595 06/19/2023 3135GOU43 4289 Fed. Natl Mort. Assoc. 03/15/2019 5,000,000.00 5,219,250.00 5,035,936.05 2.875 2.465 680 09/12/2023 3135GA2Z3 4318 Fed. Natl Mort. Assoc. 01/11/2021 3,000,000.00 2,955,570.00 3,002,751.89 0.560 0.537 1,477 11/17/2025 3135G04Z3 4329 Fed. Natl Mort. Assoc. 05/14/2021 5,000,000.00 4,919,400.00 4,977,080.72 0.500 0.628 1,324 06/17/2025 Subtotal and Average 94,050,221.82 94,000,000.00 94,315,780.00 94,048,472.14 1.232 1,151 Local Agency Investment Funds
SYS982 982 Laif City 8,679,077.93 8.679,077.93 8,679.077.93 0.203 0.203 1 Subtotal and Average 9,576,585.55 8,679,077.93 8,679,077.93 8,679,077.93 0.203 1 Treasury Securities - Coupon
912828YH7 4298 US Treasury Notes 12/05/2019 5,000,000.00 5,108,000.00 4,986,707.55 1.500 AAA 1.595 1,064 09/30/2024 912828P79 4299 US Treasury Notes 12/05/2019 3,000,000.00 3,048,180.00 2,997,118.44 1.500 AAA 1.574 484 02/28/2023 91282CAB7 4330 US Treasury Notes 05/19/2021 5,000,000.00 4,865,450.00 4,932,580.96 0.250 0.615 1,368 07/31/2025 91282CCW9 4339 US Treasury Notes 09/23/2021 1,000,000.00 979,920.00 993,396.01 0.750 0.890 1,764 08/31/2026 91282CAJO 4340 US Treasury Notes 09/27/2021 5,000,000.00 4,856,850.00 4,908,538.18 0.250 0.735 1,399 08/31/2025 91282CCP4 4341 US Treasury Notes 09/30/2021 5,000,000.00 4,873,250.00 4,924,778.57 0.625 0.950 1,733 07/31/2026 Subtotal and Average 23,740,415.89 24,000,000.00 23,731,650.00 23,743,119.71 1.048 1,291 Portfolio CITY
AP
Run Date: 01/14/2022 - 11:45 PM (PRF _PM2) 7.3.11
Report Ver. 7.3.11
City of Huntington Beach
Portfolio Management Page 2
Portfolio Details - Investments
October 31, 2021
Average Purchase Stated YTM Days to Maturity
CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate S&P 365 Maturity Date Medium Term Notes - Supras
45818WBX3 4290 Inter-American Dev. Bank 03/28/2019 4,000,000.00 4,160,160.00 4,039,054.43 2,870 2.270 626 07/20/2023 45818WBY1 4291 Inter-American Dev. Bank 03/28/2019 5,000,000.00 5,214,900.00 5,058,430.13 2.960 2.271 653 08/16/2023 45818WCT1 4312 Inter-American Dev. Bank 04/29/2020 6,000,000.00 6,069,540.00 6,077,884.06 1.600 0.550 455 01/30/2023 459058JL8 4319 Inti Bk Recon & Development 01/12/2021 5,000,000.00 4,886,000.00 4,997,710.46 0.500 AAA 0.512 1,457 10/28/2025 459056HV2 4323 Int Bk Recon & Development 04/23/2021 5,000,000.00 5,101,900.00 5,150,566.64 1.500 AAA 0.425 1,031 08/28/2024 45906M2L4 4324 Intl Bk Recon & Development 04/30/2021 5,000,000.00 4,866,850.00 4,953,607.04 0.650 AAA 0.870 1,576 02/24/2026 459058JE4 4338 Int Bk Recon & Development 07/30/2021 5,000,000.00 4,886,500.00 4,961,594.58 0.375 AAA 0.583 1,365 07/28/2025 Subtotal and Average 35,244,679.33 35,000,000.00 35,185,850.00 35,238,847.34 1.020 1,015 Corporate Bonds
037833DE7 4313 Apple Inc. 04/29/2020 5,000,000.00 5,107,900.00 5,096,601.23 2.400 0.720 438 01/13/2023 166764AH3 4294 Chevron Corp 05/24/2019 5,000,000.00 5,181,500.00 5,048,609.86 3.191 AA 2.528 600 06/24/2023 254687CR5 4300 Disney 12/16/2019 2,875,000.00 3,055,550.00 2,976,730.77 4.000 2.070 699 10/01/2023 437076BG6 4293 Home Depot Inc 05/24/2019 5,000,000.00 5,053,400.00 5,004,105.34 2.625 2.474 212 06/01/2022 459200HG9 4274 IBM Corp 09/28/2018 3,000,000.00 3,034,590.00 2,969,837.31 1.875 A 3.257 273 08/01/2022 713448CX4 4280 PEPSICO INC 12/21/2018 5,000,000.00 5,079,700.00 4,997,979.47 3.100 3.160 258 07/17/2022 882508BA1 4279 Texas Instruments Inc 12/21/2018 5,000,000.00 5,034,950.00 4,968,863.32 1.850 3.564 195 05/15/2022 904764AW7 4286 Unilever 03/01/2019 5,000,000.00 5,038,700.00 4,985,355.59 2.200 2.802 185 05/05/2022 90331HNV1 4306 US Bank NA Cincinnati 02/21/2020 2,000,000.00 2,094,600.00 2,056,499.48 3.400 AA 1.671 630 07/24/2023 91159HHX1 4325 US Bank NA Cincinnati 04/30/2021 3,809,000.00 3,958,617.52 3,997,677.02 2.400 0.528 1,002 07/30/2024 Subtotal and Average 42,107,799.08 41,684,000.00 42,639,507.52 42,102,259.39 2.320 420
ORANGE COUNTY POOL
OCP1 01 Orange County Invest Pool 65,451,682.19 65,451,682.19 65,451,682.19 0.514 0.514 1 Subtotal and Average 65,424,064.69 65,451,682.19 65,451,682.19 65,451,682.19 0.514 1 US Bank Sweep First AM Gov
FAM1 02 First American 08/01/2021 0.00 0.00 0.00 0.020 0.020 1 Subtotal and Average 18,043.51 0.00 0.00 0.00 0.000
Total and Average 270,161,809.86 268,814,760.12 270,003,547.64 269,263,458.70 1.150 715 Portfolio CITY
AP
Run Date: 01/14/2022 - 11:45 PM (PRF_PM2) 7.3.11
City of Huntington Beach
Portfolio Management Page 3
Portfolio Details - Cash
October 31, 2021
Average Purchase YTM Days to
CUSIP Investment# Issuer Balance. Date Par Value Market Value Book Value 365 Maturity Average Balance 0.00
Total Cash and Investments 270,161,809.86 268,814,760.12 270,003,547.64 269,263,458.70 1.150 715 Portfolio CITY
AP
Run Date: 01/14/2022 - 11:45 PM (PRF_ PM2) 7.3.11
City of Huntington Beach
Portfolio Management Page 1
Activity By Type
October 1, 2021 through October 31, 2021
Stated Transaction Purchases Redemptions
CUSIP Investment# Issuer Rate Date or Deposits or Withdrawals Balance Federal Agency Issues - Coupon
Subtotal 94,048,472.14
Local Agency Investment Funds (Monthly Summary)
SYS982 982 Laif City 0.203 12.661.70 4,000,000.00
Subtotal 12,661.70 4,000,000.00 8,679,077.93
Treasury Securities - Coupon
Subtotal 23,743,119.71
Medium Term Notes - Supras
Subtotal 35,238,847.34
Corporate Bonds
Subtotal 42,102,259.39
ORANGE COUNTY POOL (Monthly Summary)
OCP1 01 Orange County Invest Pool 0.514 32,928.56 3,121.84 Subtotal 32,928.56 3,121.84 65,451,682.19
US Bank Sweep First AM Gov (Monthly Summary)
FAM1 02 First American 0.020 0.00 5,043,750.00
Subtotal 0.00 5,043,750.00 0.00
Total 45,590.26 9,046,871.84 269,263,458.70
Portfolio CITY
AP
Run Date: 01/14/2022 - 11:45 PM (PRF_PM3) 7.3.11
Report Ver. 7.3.11
City of Huntington Beach
Portfolio Management Page 1
Interest Earnings Summary
October 31, 2021
October 31Month Ending Fiscal Year To Date
CD/Coupon/Discount Investments:
Interest Collected 70,000.00 959,496.89
Plus Accrued Interest at End of Period 846,426.72 846,426.72 Less Accrued Interest at Beginning of Period 666,282.09) ( 764,664.92) Less Accrued Interest at Purchase During Period ( 0.00) ( 0.00) Interest Earned during Period 250,144.63 1,041,258.69
Adjusted by Premiums and Discounts -22,439.48 -116,471.06 Adjusted by Capital Gains or Losses 0.00 -21,439.99
Earnings during Periods 227,705.15 903,347.64
Pass Through Securities:
Interest Collected 0.00 0.00
Plus Accrued Interest at End of Period 0.00 0.00
Less Accrued Interest at Beginning of Period 0.00) 0.00) Less Accrued Interest at Purchase During Period 0.00) 0.00) Interest Earned during Period 0.00 0.00
Adjusted by Premiums and Discounts 0.00 0.00
Adjusted by Capital Gains or Losses 0.00 0.00
Earnings during Periods 0.00 0.00
Cash/Checking Accounts:
Interest Collected 45,590.26 177,098.12
Plus Accrued Interest at End of Period 35,076.33 35,076.33 Less Accrued Interest at Beginning of Period 50,454.43) ( 74,123.21) Interest Earned during Period 30,212.16 138,051.24
Total Interest Earned during Period 280,356.79 1,179,309.93 Total Adjustments from Premiums and Discounts -22,439.48 -116,471.06 Total Capital Gains or Losses 0.00 -21,439.99
Total Earnings during Period 257,917.31 1,041,398.88
Portfolio CITY
AP
Run Date: 01/14/2022 - 11:45 PM (PRF_PM6) 7.3.11
Report Ver. 7.3.11
State of California
PMIA Pooled Money Investment Account
Market Valuation
10/31/2021
Carrying Cost Plus
Description Accrued Interest Purch. Fair Value Accrued Interest United States Treasury:
Bills $ 51,528,364,233.43 $ 51,536,462,500.00 NA
Notes $ 66,995,520,746.81 $ 66,755,995,500.00 $ 107,797,892.00 Federal Agency:
SBA $ 379,794,651.43 $ 380,560,115.32 160,686.50
MBS-REMICS 7,684,554.49 $ 8,032,825.82 $ 35,258.52
Debentures 10,141,252,331.66 10,126,777,100.00 $ 9,034,416.50 Debentures FR $
Debentures CL 800,000,000.00 793,767,000.00 $ 745,527.00 Discount Notes 13,921,695,748.53 13,922,104,750.00 NA
Supranational Debentures $ 1,922,465,207.67 $ 1,910,733,500.00 $ 4,097,629.50 Supranational Debentures FR $ 100,005,722.97 $ 100,016,723.66 17,030.56 CDs and YCDs FR $ - 20,833.33
Bank Notes $ 50,000,000.00 49,988,446.23 $
CDs and YCDs $ 12,100,000,000.00 12,098,277,792.84 $ 4,034,013.86 Commercial Paper 10,353,697,111.07 $ 10,355,675,099.93 NA Corporate:
Bonds FR $ $
6A A 250,117,950.28
Bonds $ 247,515,080.00 $ 884,925.30
Repurchase Agreements $ $ :
Reverse Repurchase $ $ - $
Time Deposits 3,941,500,000.00 3,941,500,000.00 NA
PMIA & GF Loans 775,298,000.00 775,298,000.00 NA
TOTAL $ 173,267,396,258.34 $ 173,002,704,433.80 126,828,213.07 Fair Value Including Accrued Interest $ 173,129,532,646.87 Repurchase Agreements, Time Deposits, PMIA & General Fund loans, and Reverse Repurchase agreements are carried at portfolio book value (carrying cost).
Statement of Cash Receipts and Disbursements and
Summary of Cash by Fund
Finance Department
CA October 2021
Cash Receipts and Disbursements September 2021 October 2021 Receipts
General Fund
Property Tax $ 1,148,137 $ 176,963
Local Sales Tax 4,268,907 4,578,077
Public Safety Sales Tax 235,927 219,811
Transient Occupancy Tax (TOT) 1,624,948 1,216,081
Utility Users Tax (UUT) 1,517,723 1,641,876
Other Revenue 4,363,482 4,580,781
Total General Fund Revenue 13,159,123 12,413,588
Total All Other Funds Revenue 29,773,266 9,469,181
Total Receipts $ 42,932,389 $ 21,882,769
Disbursements
General Fund
Personnel Services (23,284,375) (10,328,887)
Operating Expenses (3,511,735) (3,143,215)
Capital Expenditures :
Non-Operating Expenses
Total General Fund Disbursements (26,796,110) (13,472,101) Total All Other Funds Disbursements (16,753,730) (14,594,964) Total Disbursements (43,549,840) (28,067,065)
Net Change in Cash Flow (617,451) $ (6,184,296)
Summary of Cash by Fund September 2021 October 2021
General Fund 5 52,785,370 $ 51,726,856
General Fund Other 3,133,604 2,745,957
Capital Projects Funds 26,608,650 26,097,523
Debt Service Funds 35,778,888 35,686,449
Enterprise Funds 76,972,198 76,198,890
Trust and Agency Funds 4,811,489 4,670,850
Internal Service Funds 28,841,173 27,368,213
Special Revenue Funds 55,289,672 53,542,010
General Ledger Cash Balances * $ 284,221,043 $ 278,036,747 * 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 ormation includes receipts from maturing investments and payments for purchased investmer the city investment portfolio. This statement is prepared in compliance with the City's Chart City of Huntington Beach
City of Huntington Beach 2000 Main St.
Huntington Beach,
Portfolio Management
Portfolio Summary
November 30, 2021
Par Market Book % of Days to YTM YTM
Investments Value Value Value Portfolio Term Maturity 360 Equiv. 365 Equiv. 93,986,140.00 94.044,731.48 34.94 1,589 1,121 1.215 1.232 Federal Agency Issues - Coupon 94,000,000.00
Local Agency Investment Funds 8,679,077.93 8,679,077.93 8,679,077.93 3.22 1 1 0.200 0.203 Treasury Securities - Coupon 29,000,000.00 28,640,240.00 28,625,656.75 10.64 1,604 1,342 1.073 1.088 Medium Term Notes - Supras 35,000,000.00 35,148,290.00 35,226,390.89 13.09 1,464 985 1.006 1.020 Corporate Bonds 41,684,000.00 42,528,723.84 42,090,429.11 15.64 1,239 390 2.289 2.321 ORANGE COUNTY POOL 60,480,444.87 60,480,444.87 60,480,444.87 22.47 1 0.508 0.515 268,843,522.80 269,462,916.64 269,146,731.03 100.00% 1,112 725 1.149 1.165 Investments
Total Earnings November 30 Month Ending Fiscal Year To Date Fiscal Year Ending Current Year 257,074.72 1,298,473.60
Current Budget 100,000.00 500,000.00 1,200,000.00
Last Year Actual 273,264.84 1,543,083.17 3,403,369.60
Average Daily Balance 269,384,512.30 276,816,452.52
Effective Rate of Return 1.16% 1.12%
certify that this report accurately reflects all City pooled investments and is in conformity with all State laws and the investment policy statement filed with the City Council on February 1, 2021. A copy o his policy is available at the office of the City Clerk. The investment program herein shown provides sufficient cash flow liquidity to meet the next six month's obligations. Market Values provided by US Bank Custody.
Alisa Backstrom, CITY TREASURER
Reporting period 11/01/2021-11/30/2021 Portfolio CITY
AP
Run Date: 01/14/2022 - 11:49 PM (PRF_PM1) 7.3.1
Report Ver. 7.3.1-
City of Huntington Beach
Portfolio Management Page 1
Portfolio Details - Investments
November 30, 2021
Average Purchase Stated YTM Days to Maturity
CUSIP Investment# Issuer, Balance Date Par Value Market Value Book Value Rate S&P 365 Maturity Date Federal Agency Issues - Coupon
3133ECHX5 4292 Federal Farm Credit Bank 05/23/2019 5,000,000.00 5,180,200.00 5,002,565.78 2.260 AA 2.236 833 03/13/2024 3133ЕKTG1 4296 Federal Farm Credit Bank 07/01/2019 5,000,000.00 5,047,450.00 4,998,006.94 1,750 1.821 212 07/01/2022 313383QR5 4281 Federal Home Loan Bank 12/20/2018 5,000,000.00 5,213,650.00 5,036,101.93 3.250 2.743 555 06/09/2023 3130AFWX1 4285 Federal Home Loan Bank 02/26/2019 5,000,000.00 5,159,750.00 5,000,000.00 2.550 2,550 545 05/30/2023 3130AKN36 4320 Federal Home Loan Bank 01/15/2021 5,000,000.00 4,898,950.00 4,995,877.78 0.525 0.545 1,506 01/15/2026 3130AKN85 4321 Federal Home Loan Bank 01/20/2021 5,000,000.00 4,883,400.00 4,997,931.94 0.550 0.560 1.511 01/20/2026 3130AKUS3 4322 Federal Home Loan Bank 01/28/2021 5,000,000.00 4,835,800.00 5,000,000.00 0.500 0.500 1,519 01/28/2026 3130AMDL3 4327 Federal Home Loan Bank 05/25/2021 5,000,000.00 4,943,800.00 5,000,000.00 0.800 0,800 1,332 07/25/2025 3130AMJN3 4328 Federal Home Loan Bank 05/26/2021 5,000,000.00 4,955,800.00 50000,00000 1.030 1.030 1,637 05/26/2026 3130AMQ54 4331 Federal Home Loan Bank 06/16/2021 5,000,000.00 4,921,000.00 5,000,000.00 0.700 0.700 1,385 09/16/2025 3130AMQ62 4332 Federal Home Loan Bank 06/14/2021 5,000,000.00 4,936,200.00 5,000,000.00 0.625 0.625 1,199 03/14/2025 3130ALEY6 4333 Federal Home Loan Bank 06/10/2021 5,000.000.00 4,932,300.00 5,000,000.00 0.800 0.800 1,554 03/04/2026 3130AMW65 4334 Federal Home Loan Bank 06/30/2021 5,000,000.00 4,953,800.00 5,000,000.00 0.500 0.500 1,125 12/30/2024 3130AMFS6 4335 Federal Home Loan Bank 06/17/2021 5,000,000.00 4,910,250.00 4,972,740.95 0.750 0.873 1,654 06/12/2026 3130AMXJ6 4336 Federal Home Loan Bank 06/30/2021 5,000,000.00 4,947,450.00 5,000,000.00 0.500 0.500 1,034 09/30/2024 3137EAEN5 4287 Federal Home Loan Mort Corp 03/08/2019 3,000,000.00 3,107,430.00 3,013,144.32 2.750 2.450 565 06/19/2023 3137EAEN5 4288 Federal Home Loan Mort Corp 03/14/2019 3,000,000.00 3,107,430.00 3,013,730.07 2.750 2.437 565 06/19/2023 3135GOU43 4289 Fed. Natl Mort. Assoc. 03/15/2019 5,000,000.00 5,208,500.00 5.034.329.38 2.875 2.465 65009/12/2023 3135GAZZ3 4318 Fed. Natl Mort. Assoc. 01/11/2021 3,000,000.00 2,939,730.00 3,002,695.19 0.560 0.537 1,447 11/17/2025 3135G04Z3 4329 Fed. Natl Mort. Assoc. 05/14/2021 5,000,000.00 4,903,250.00 4,977,607.20 0.500 0.628 1,294 06/17/2025 Subtotal and Average 94,046,539.47 94,000,000.00 93,986,140.00 94,044,731.48 1.232 1,121 Local Agency Investment Funds
SYS982 982 Laif City 8,679,077.93 8,679,077.93 8,679,077.93 0.203 0.203 1 Subtotal and Average 8,679,077.93 8,679,077.93 8,679,077.93 8,679,077.93 0.203 1 Treasury Securities - Coupon
912828YH7 4298 US Treasury Notes 12/05/2019 5,000,000.00 5,097,650.00 4,987,082.34 1.500 AAA 1.595 1,034 09/30/2024 912828P79 4299 US Treasury Notes 12/05/2019 3,000,000.00 3,044,640.00 2,997,297.05 1.500 AAA 1.574 454 02/28/2023 91282CAB7 4330 US Treasury Notes 05/19/2021 5,000,000.00 4,865,050.00 4,934,059.45 0.250 0.615 1,338 07/31/2025 91282CCW9 4339 US Treasury Notes 09/23/2021 1,000,000.00 981,950.00 993,508.32 0.750 0.890 1,734 08/31/2026 91282CAJO 4340 US Treasury Notes 09/27/2021 5,000,000.00 4,857,800.00 4,910,499.48 0.250 0.735 1,369 08/31/2025 91282CCP4 4341 US Treasury Notes 09/30/2021 5,000,000.00 4,883,400.00 4,926,080.73 0.625 0.950 1,703 07/31/2026 91282CCW9 4342 US Treasury Notes 11/23/2021 5,000,000.00 4,909,750.00 4,877,129.38 0.750 1.285 1.734 08/31/2026 Subtotal and Average 25,046,415.37 29,000,000.00 28,640,240.00 28,625,656.75 1.088 1,342 Portfolio CITY
AP
Run Date: 01/14/2022 - 11:49 PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
City of Huntington Beach
Portfolio Management Page 2
Portfolio Details - Investments
November 30, 2021
Average Purchase Stated YM Days to Maturity
CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate S&P 365 Maturity Date Medium Term Notes - Supras
45818WBX3 4290 Inter-American Dev. Bank 03/28/2019 4,000,000.00 4,150,800.00 4,037,161.65 2,870 2.270 596 07/20/2023 45818WBY1 4291 Inter-American Dev. Bank 03/28/2019 5,000,000.00 5,202,350.00 5,055,712.45 2.960 2.271 623 08/16/2023 45818WCT1 4312 Inter-American Dev. Bank 04/29/2020 6,000,000.00 6,060,840.00 6,072,680.22 1.600 0.550 425 01/30/2023 459058JL8 4319 Intl Bk Recon & Development 01/12/2021 5,000,000.00 4,886,500.00 4,997,758.26 0.500 AAA 0.512 1,427 10/28/2025 459056HV2 4323 Intl Bk Recon & Development 04/23/2021 5,000,000.00 5,091,900.00 5,146,125.15 1.500 AAA 0.425 1,001 08/28/2024 45906M2L4 4324 Intl Bk Recon & Development 04/30/2021 5,000,000.00 4,876,400.00 4,954,503.23 0.650 AAA 0.870 1,546 02/24/2026 459058JE4 4338 Intl Bk Recon & Development 07/30/2021 5,000,000.00 4,879,500.00 4,962,449.93 0.375 AAA 0.583 1,335 07/28/2025 Subtotal and Average 35,232,411.50 35,000,000.00 35,148,290.00 35,226,390.89 1.020 985 Corporate Bonds
037833DE7 4313 Apple Inc. 04/29/2020 5,000,000.00 5,098,400.00 5,089,892.81 2,400 0,720 408 01/13/2023 166764AH3 4294 Chevron Corp 05/24/2019 5,000,000.00 5,165,050.00 5,046,150.68 3.191 AA 2.528 570 06/24/2023 254687CR5 4300 Disney 12/16/2019 2,875,000.00 3,036,575.00 2,972,307.69 4.000 2,070 669 10/01/2023 437076BG6 4293 Home Depot Inc 05/24/2019 5,000,000.00 5,045,150.00 5,003,518.86 2.625 2.474 182 06/01/2022 459200HG9 4274 IBM Corp 09/28/2018 3,000,000.00 3,027,450.00 2,973,188.72 1.875 3.257 243 08/01/2022 713448CX4 4280 PEPSICO INC 12/21/2018 5,000,000.00 5,066,150.00 4,998,216.25 3.100 3.160 228 07/17/2022 882508BA1 4279 Texas Instruments Inc 12/21/2018 5,000,000.00 5,029,950.00 4,973,678.27 1.850 3.564 165 05/15/2022 904764AW7 4286 Unilever 03/01/2019 5,000,000.00 5,031,300.00 4,987,743.27 2.200 2.802 155 05/05/2022 90331HNV1 4306 US Bank NA Cincinnati 02/21/2020 2,000,000.00 2,079,680.00 2,053,778.80 3.400 AA 1.671 600 07/24/2023 91159HHX1 4325 US Bank NA Cincinnati 04/30/2021 3,809,000.00 3,949,018.84 3,991,953.76 2.400 0.528 972 07/30/2024 Subtotal and Average 42,096,147.08 41,684,000.00 42,528,723.84 42,090,429.11 2.321 390
ORANGE COUNTY POOL
OCP1 01 Orange County Invest Pool 60,480,444.87 60,480,444.87 60,480,444.87 0.515 0.515 1 Subtotal and Average 64,283,920.95 60,480,444.87 60,480,444.87 60,480,444.87 0.515 1 US Bank Sweep First AM Gov
FAM1 02 First American 08/01/2021 0.00 0.00 0.00 0.020 0.020 Subtotal and Average 0.00 0.00 0.00 0.00 0.000
Total and Average 269,384,512.30 268,843,522.80 269,462,916.64 269,146,731.03 1.165 725 Portfolio CITY
AP
Run Date: 01/14/2022 - 11:49 PM (PRF_PM2) 7.3.11
City of Huntington Beach
Portfolio Management Page 3
Portfolio Details - Cash
November 30, 2021
Average Purchase Stated YTM Days to
CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate 365 Maturity Average Balance 0.00 0
Total Cash and Investments 269,384,512.30 268,843,522.80 269,462,916.64 269,146,731.03 1.165 725 Portfolio CITY
AP
Run Date: 01/14/2022 - 11:49 PM (PRF_PM2) 7.3.11
City of Huntington Beach
Portfolio Management Page 1
Activity By Type
November 1, 2021 through November 30, 2021
Stated Transaction Purchases Redemptions
CUSIP Investment# Issuer Rate Date or Deposits or Withdrawals Balance Federal Agency Issues - Coupon
Subtotal 94,044,731.48
Local Agency Investment Funds (Monthly Summary)
Subtotal 8,679,077.93
Treasury Securities - Coupon
91282CCW9 4342 US Treasury Notes 0.750 11/23/2021 4,876,562.50 0.00 Subtotal 4,876,562.50 0.00 28,625,656.75
Medium Term Notes - Supras
Subtotal 35,226,390.89
Corporate Bonds
Subtotal 42,090,429.11
ORANGE COUNTY POOL (Monthly Summary)
OCP1 01 Orange County Invest Pool 0.515 31,989.91 5,003,227.23 Subtotal 31,989.91 5,003,227.23 60,480,444.87
US Bank Sweep First AM Gov (Monthly Summary)
Subtotal 0.00
Total 4,908,552.41 5,003,227.23 269,146,731.03
Portfolio CITY
AP
Run Date: 01/14/2022 - 11:49 PM (PRF_PM3) 7.3.11
Report Ver. 7.3.11
City of Huntington Beach
Portfolio Management Page 1
Interest Earnings Summary
November 30, 2021
November 30Month Ending Fiscal Year To Date
CD/Coupon/Discount Investments:
Interest Collected 219,150.00 1,178,646.89
Plus Accrued Interest at End of Period 877,745.60 877,745.60 Less Accrued Interest at Beginning of Period 846,426.72) ( 764,664.92) Less Accrued Interest at Purchase During Period 0.00) ( 0.00) Interest Earned during Period 250,468.88 1,291,727.57
Adjusted by Premiums and Discounts -22,052.85 -138,523.91 Adjusted by Capital Gains or Losses 0.00 -21,439.99
Earnings during Periods 228,416.03 1,131,763.67
Pass Through Securities:
Interest Collected 0.00 0.00
Plus Accrued Interest at End of Period 0.00 0.00
Less Accrued Interest at Beginning of Period 0.00) 0.00) Less Accrued Interest at Purchase During Period 0.00) 0.00) Interest Earned during Period 0.00 0.00
Adjusted by Premiums and Discounts 0.00 0.00
Adjusted by Capital Gains or Losses 0.00 0.00
Earnings during Periods 0.00 0.00
Cash/Checking Accounts:
Interest Collected 31,989.91 209,088.03
Plus Accrued Interest at End of Period 31,745.11 31,745.11 Less Accrued Interest at Beginning of Period 35,076.33) ( 74,123.21) Interest Earned during Period 28,658.69 166,709.93
Total Interest Earned during Period 279,127.57 1,458,437.50 Total Adjustments from Premiums and Discounts -22,052.85 -138,523.91 Total Capital Gains or Losses 0.00 -21,439.99
Total Earnings during Period 257,074.72 1,298,473.60
Portfolio CITY
AP
Run Date: 01/14/2022 - 11:49 PM (PRF_PM6) 7.3.11
Report Ver. 7.3.11
State of California
Pooled Money Investment Account
Market Valuation
PIETY LAUDIT HOTD 11/30/2021
Carrying Cost Plus
Description Accrued Interest Purch. Fair Value Accrued Interest United States Treasury:
Bills 48,726,449,678.61 $ 48,730,719,000.00 NA
Notes 69,830,483,002.41 $ 69,566,332,000.00 $ 100,381,839.50 Federal Agency:
SBA $ 368,147,080.16 $ 368,757,247.51 $ 155,956.38
MBS-REMICS $ 7,037,163.75 $ 7,342,045.11 32,233.50
Debentures 10,290,758,847.05 10,273,071,200.00 9,225,900.85 Debentures FR
Debentures CL 1A A A CA 792,328,000.00 I$ 681,362.00
800,000,000.00
Discount Notes 15,920,475,698.53 15,918,872,000.00 NA
Supranational Debentures $ 2,123,861,085.45 2,110,398,500.00 $ 5,249,155.50 Supranational Debentures FR $ 100,005,722.97 100,010,723.20 $ 28,113.89 CDs and YCDs FR $
Bank Notes $ 50,000,000.00 $ 49,994,496.07 25,000.00
CDs and YCDs 14,050,000,416.66 $ 14,047,931,055.49 $ 5,075,180.49 Commercial Paper 11,343,047,430.48 11,344,338,881.89 NA Corporate:
Bonds FR $
$ 1.525,203.13
Bonds $ 286,148,538.89 $ 282,462,680.00
Repurchase Agreements $ $
Reverse Repurchase $ $ $
Time Deposits $ 3,946,500,000.00 3,946,500,000.00 NA
PMIA & GF Loans $ 732,356,000.00 | 732,356,000.00 NA
TOTAL $ 178,575,270,664.96 $ 178,271,413,829.27 $ 122,379,945.24 Fair Value Including Accrued Interest $ 178,393,793,774.51 Repurchase Agreements, Time Deposits, PMIA & General Fund loans, and Reverse Repurchase agreements are carried at portfolio book value (carrying cost).
Statement of Cash Romany adDi by Fements and
Finance Department
November 2021
Cash Receipts and Disbursements October 2021 November 2021 Receipts
General Fund
Property Tax $ 176,963 $ 10,974,947
4,578,077 4,134,829
Public Safety Sales Tax 219,811 221,425
Transient Occupancy Tax (TOT) 1,216,081 1,083,342
Utility Users Tax (UUT) 1,641,876 1,849,979
Other Revenue 4,580,781 5,806,446
Total General Fund Revenue 12,413,588 24,070,968
Total All Other Funds Revenue 9,469,181 13,910,166
Total Receipts $ 21,882,769 $ 37,981,134
Disbursements
General Fund
Personnel Services (10,328,887) (9,863,247)
Operating Expenses (3,143,215) (3,428,060)
Capital Expenditures
Non-Operating Expenses : (70,873)
Total General Fund Disbursements (13,472,101) (13,362,180) Total All Other Funds Disbursements (14,594,964) (11,295,942) Total Disbursements (28,067,065) (24,658,122)
Net Change in Cash Flow $ (6,184,296) $ 13,323,011
Summary of Cash by Fund October 2021 November 2021
General Fund $ 51,744,625 $ 62,453,413
General Fund Other 2,747,347 2,846,689
Capital Projects Funds 26,108,503 25,634,403
Debt Service Funds 35,700,235 36,752,429
Enterprise Funds 76,246,580 77,928,329
Trust and Agency Funds 4,672,866 3,386,905
Internal Service Funds 27,380,800 27,041,339
Special Revenue Funds 53,549,612 55,430,072
General Ledger Cash Balances * $ 278,150,568 $ 291,473,579 * 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 formation includes receipts from maturing investments and payments for purchased investmer the city investment portfolio. This statement is prepared in compliance with the City's Charte City of Huntington Beach
City of Huntington Beach 2000 Main St.
Huntington Beach,
Portfolio Management
Portfolio Summary
December 31, 2021
Par Market Book % of Days to YTM YTM
Investments Value Value Value Portfolio Term Maturity 360 Equiv. 365 Equiv.
Federal Agency Issues - Coupon 122,650,000.00 122,464,430.00 122,692,989.58 40.75 1,485 1,101 1.188 1.204 Local Agency Investment Funds 8,679,077.93 8,679,077.93 8,679,077.93 2.88 1 1 0.209 0.212 Treasury Securities - Coupon 37,000,000.00 36,872,220.00 36,976,484.28 12.28 1,519 1,292 1.062 1.076 Medium Term Notes - Supras 35,000,000.00 35,027,620.00 35,213,934.44 11.70 1,464 954 1.006 1.020 Corporate Bonds 46,684,000.00 47,376,740.78 47,028,056.76 15.62 1,216 425 2.150 2.180 ORANGE COUNTY POOL 50,507,617.81 50,507,617.81 50,507,617.81 16.77 1 0.391 0.396 300,520,695.74 300,927,706.52 301,098,160.80 100.00% 1,153 786 1.139 1.155 Investments
Total Earnings December 31 Month Ending Fiscal Year To Date Fiscal Year Ending Current Year 260,935.33 1,559,408.93
Current Budget 100,000.00 600,000.00 1,200,000.00
Last Year Actual 272,920.45 1,816,003.62 3,403,369.60
Average Daily Balance 272,558,593.23 276,099,095.79
Effective Rate of Return 1.13% 1.12%
I certify that this report accurately reflects all City pooled investments and is in conformity with all State laws and the investment policy statement filed with the City Council on February 1, 2021. A copy of this policy is available at the office of the City Clerk. The investment program herein shown provides sufficient cash flow liquidity to meet the next six month's obligations. Market Values provided by US Bank Custody.
Alisa Backstrom, CITY TREASURER
Reporting period 12/01/2021-12/31/2021 Portfolio CITY
AP
Run Date: 01/14/2022 - 11:52 PM (PRF_PM1) 7.3.11
Report Ver. 7.3.11
City of Huntington Beach
Portfolio Management Page 1
Portfolio Details - Investments
December 31, 2021
Average Purchase Stated YTM Daysto Maturity
CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate S&P 365 Maturity Date Federal Agency Issues - Coupon
3133ECHX5 4292 Federal Farm Credit Bank 05/23/2019 5,000,000.00 5,182,950.00 5,002,472.14 2.260 AA 2.236 802 03/13/2024 3133EKTG1 4296 Federal Farm Credit Bank 07/01/2019 5,000,000.00 5,040,350.00 4,998,291.67 1.750 1.821 181 07/01/2022 313383QR5 4281 Federal Home Loan Bank 12/20/2018 5,000,000.00 5,192,350.00 5,034, 125.54 3.250 2.743 524 06/09/2023 3130AFWX1 4285 Federal Home Loan Bank 02/26/2019 5,000,000.00 5,141,750.00 5,000,000.00 2.550 2.550 514 05/30/2023 3130AKN36 4320 Federal Home Loan Bank 01/15/2021 5,000,000.00 4,891,550.00 4,995,961.11 0.525 0.545 1,475 01/15/2026 3130AKN85 4321 Federal Home Loan Bank 01/20/2021 5,000,000.00 4,875,950.00 4,997,973.61 0.550 0.560 1,480 01/20/2026 3130AKUS3 4322 Federal Home Loan Bank 01/28/2021 5,000,000.00 4,849,950.00 5,000,000.00 0.500 0.500 1,488 01/28/2026 3130AMDL3 4327 Federal Home Loan Bank 05/25/2021 5,000,000.00 4,936,450.00 5,000,000.00 0.800 0.800 1,301 07/25/2025 3130AMJN3 4328 Federal Home Loan Bank 05/26/2021 5,000,000.00 4,951,350.00 5,000,000.00 1.030 1.030 1,606 05/26/2026 3130AMQ54 4331 Federal Home Loan Bank 06/16/2021 5,000,000.00 4,912,800.00 5,000,000.00 0.700 0.700 1,354 09/16/2025 3130AMQ62 4332 Federal Home Loan Bank 06/14/2021 5,000,000.00 4,927,150.00 5,000,000.00 0.625 0.625 1,168 03/14/2025 3130ALEY6 4333 Federal Home Loan Bank 06/10/2021 5,000,000.00 4,926,350.00 5,000,000.00 0.800 0.800 1,523 03/04/2026 3130AMW65 4334 Federal Home Loan Bank 06/30/2021 5,000,000.00 4,944,900.00 5,000,000.00 0.500 0.500 1,094 12/30/2024 3130AMFS6 4335 Federal Home Loan Bank 06/17/2021 5,000,000.00 4,898,950.00 4,973,242.34 0.750 0.873 1,623 06/12/2026 3130AMXJ6 4336 Federal Home Loan Bank 06/30/2021 5,000,000.00 4,937,700.00 5,000,000.00 0.500 0.500 1,003 09/30/2024 3130AQ3C5 4344 Federal Home Loan Bank 12/02/2021 4,000,000.00 3,997,640.00 4,000,000.00 1.000 1.000 970 08/28/2024 3130AQ5S8 4345 Federal Home Loan Bank 12/30/2021 4,650,000.00 4,651,860.00 4,650,000.00 1,250 1.250 1,276 06/30/2025 3130AQD59 4346 Federal Home Loan Bank 12/30/2021 5,000,000.00 4,999,000.00 5,000,000.00 1.000 1.000 1,003 09/30/2024 3130AQ7E7 4347 Federal Home Loan Bank 12/30/2021 5,000,000.00 4,995,450.00 5,001,998.77 1.500 1.491 1,641 06/30/2026 3130AQD42 4348 Federal Home Loan Bank 12/28/2021 5,000,000.00 5,003,150.00 5,000,000.00 0.920 0.920 909 06/28/2024 3130AQD59 4349 Federal Home Loan Bank 12/30/2021 5,000,000.00 4,999,000.00 5,000,000.00 1.000 1.000 1,003 09/30/2024 3137EAEN5 4287 Federal Home Loan Mort Corp 03/08/2019 3,000,000.00 3,094,110.00 3,012,437.64 2,750 2.450 534 06/19/2023 3137EAENS 4288 Federal Home Loan Mort Corp 03/14/2019 3,000,000.00 3,094,110.00 3,012,991.90 2.750 2.437 534 06/19/2023 3135GOU43 4289 Fed. Natl Mort. Assoc. 03/15/2019 5,000,000.00 5,184,400.00 5,032,722.70 2.875 2.465 619 09/12/2023 3135GA2Z3 4318 Fed. Natl Mort. Assoc. 01/11/2021 3,000,000.00 2,934,960.00 3,002,638.49 0.560 0.537 1,416 11/17/2025 3135G0423 4329 Fed. Natl Mort. Assoc. 05/14/2021 5,000,000.00 4,900,250.00 4,978,133.67 0.500 0.628 1,263 06/17/2025 Subtotal and Average 99,826,740.43 122,650,000.00 122,464,430.00 122,692,989.58 1.204 1,101 Local Agency Investment Funds
SYS982 982 Laif City 8,679,077.93 8,679,077.93 8,679,077.93 0.212 0.212 Subtotal and Average 8,679,077.93 8,679,077.93 8,679,077.93 8,679,077.93 0.212 Treasury Securities - Coupon
912828YH7 4298 US Treasury Notes 12/05/2019 5,000,000.00 5,078,900.00 4,987,469.62 1.500 AAA 1.595 1,003 09/30/2024 912828P79 4299 US Treasury Notes 12/05/2019 3,000,000.00 3,035,520.00 2,997,481.61 1.500 AAA 1.574 423 02/28/2023 91282CAB7 4330 US Treasury Notes 05/19/2021 5,000,000.00 4,850,000.00 4,935,587.22 0.250 0.615 1,307 07/31/2025 Portfolio CITY
AP
Run Date: 01/14/2022 - 11:52 PM (PRF_PM2) 73.11
Report Ver. 7.3.11
City of Huntington Beach
Portfolio Management Page 2
Portfolio Details - Investments
December 31, 2021
Average Purchase Stated YTM Days to Maturity
CUSIP Investment# Issuer Balance. Date Par Value Market Value Book Value Rate S&P 365 Maturity Date Treasury Securities - Coupon
91282CCW9 4339 US Treasury Notes 09/23/2021 1,000,000.00 977,620.00 993,624.38 0.750 0.890 1,703 08/31/2026 91282CAJO 4340 US Treasury Notes 09/27/2021 5,000,000.00 4,843,550.00 4,912,526.15 0.250 0.735 1,338 08/31/2025 91282CCP4 4341 US Treasury Notes 09/30/2021 5,000,000.00 4,861,900.00 4,927,426.30 0.625 0.950 1,672 07/31/2026 91282CCW9 4342 US Treasury Notes 11/23/2021 5,000,000.00 4,888,100.00 4,879,326.03 0.750 1.285 1,703 08/31/2026 912828YM6 4350 US Treasury Notes 12/31/2021 3,000,000.00 3,046,980.00 3,048,463.13 1.500 0.920 1,034 10/31/2024 9128284Z0 4351 US Treasury Notes 12/31/2021 5,000,000.00 5,289,650.00 5,294,579.84 2.750 1.103 1,338 08/31/2025 Subtotal and Average 28,898,805.00 37,000,000.00 36,872,220.00 36,976,484.28 1.076 1,292 Medium Term Notes - Supras
45818WBX3 4290 Inter-American Dev. Bank 03/28/2019 4,000,000.00 4,137,760.00 4,035,268.87 2.870 2.270 565 07/20/2023 45818WBY1 4291 Inter-American Dev. Bank 03/28/2019 5,000,000.00 5,186,050.00 5,052,994.77 2.960 2.271 592 08/16/2023 45818WCT1 4312 Inter-American Dev. Bank 04/29/2020 6,000,000.00 6,044,160.00 6,067,476.39 1.600 0.550 394 01/30/2023 459058JL8 4319 Intl Bk Recon & Development 01/12/2021 5,000,000.00 4,870,400.00 4,997,806.05 0.500 AAA 0.512 1,396 10/28/2025 459056HV2 4323 Int Bk Recon & Development 04/23/2021 5,000,000.00 5,071,800.00 5,141,683.65 1.500 AAA 0.425 970 08/28/2024 45906M2L4 4324 Intl Bk Recon & Development 04/30/2021 5,000,000.00 4,856,250.00 4,955,399.42 0.650 AAA 0,870 1,515 02/24/2026 459058JE4 4338 Intl Bk Recon & Development 07/30/2021 5,000,000.00 4,861,200.00 4,963,305.29 0.375 AAA 0.583 1,304 07/28/2025 Subtotal and Average 35,219,766.44 35,000,000.00 35,027,620.00 35,213,934.44 1.020 954 Corporate Bonds
037833DE7 4313 Apple Inc. 04/29/2020 5,000,000.00 5,095,550.00 5,083,184.39 2.400 0.720 377 01/13/2023 14913R2P1 4343 Caterpillar Financial Corp. 12/02/2021 5,000,000.00 4,931,750.00 4,949,457.94 0.600 0.980 986 09/13/2024 166764AH3 4294 Chevron Corp 05/24/2019 5,000,000.00 5,148,100.00 5,043,691.50 3.191 AA 2.528 539 06/24/2023 254687CR5 4300 Disney 12/16/2019 2,875,000.00 3,029,416.25 2,967,884.62 4.000 2.070 638 10/01/2023 437076BG6 4293 Home Depot Inc 05/24/2019 5,000,000.00 5,038,400.00 5,002,932.38 2.625 A 2.474 151 06/01/2022 459200HG9 4274 IBM Corp 09/28/2018 3,000,000.00 3,025,140.00 2,976,540.13 1.875 3.257 212 08/01/2022 713448CX4 4280 PEPSICO INC 12/21/2018 5,000,000.00 5,051,150.00 4,998,453.03 3.100 3.160 197 07/17/2022 882508BA1 4279 Texas Instruments Inc 12/21/2018 5,000,000.00 5,018,600.00 4,978,493.22 1.850 3.564 134 05/15/2022 904764AW7 4286 Unilever 03/01/2019 5,000,000.00 5,023,750.00 4,990,130.94 2.200 2.802 124 05/05/2022 90331HNV1 4306 US Bank NA Cincinnati 02/21/2020 2,000,000.00 2,079,540.00 2,051,058.12 3.400 AA 1.671 569 07/24/2023 91159HHX1 4325 US Bank NA Cincinnati 04/30/2021 3,809,000.00 3,935,344.53 3,986,230.49 2.400 0.528 94107/30/2024 Subtotal and Average 46,873,255.50 46,684,000.00 47,376,740.78 47,028,056.76 2.180 425
ORANGE COUNTY POOL
OCP1 Orange County Invest Pool 50,507,617.81 50,507,617.81 50,507,617.81 0.396 0.396 1 Subtotal and Average 53,060,947.92 50,507,617.81 50,507,617.81 50,507,617.81 0.396 1 Portfolio CITY
AP
Run Date: 01/14/2022 - 11:52 PM (PRF_PM2) 7.3.11
City of Huntington Beach
Portfolio Management Page 3
Portfolio Details - Investments
December 31, 2021
Average Purchase Stated YTM Days to Maturity
CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate S&P 365 Maturity Date US Bank Sweep First AM Gov
FAM1 02 First American 08/01/2021 0.00 0.00 0.00 0.020 0.020 Subtotal and Average 0.00 0.00 0.00 0.00 0.000 0
Total and Average 272,558,593.23 300,520,695.74 300,927,706.52 301,098,160.80 1.155 786 Portfolio CITY
AP
Run Date: 01/14/2022 - 11:52 PM (PRF_PM2) 7.3.11
City of Huntington Beach
Portfolio Management Page 4
Portfolio Details - Cash
December 31, 2021
Average Purchase Stated YTM Days to
CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value 365 Maturity Average Balance 0.00
Total Cash and Investments 272,558,593.23 300,520,695.74 300,927,706.52 301,098,160.80 1.155 786 Portfolio CITY
AP
Run Date: 01/14/2022 - 11:52 PM (PRF_ PM2) 7.3.11
City of Huntington Beach
Portfolio Management
Activity By Type
December 1, 2021 through December 31, 2021
Stated Transaction Purchases Redemptions
CUSIP Investment # Issuer Rate Date or Deposits or Withdrawals Balance Federal Agency Issues - Coupon
3130AQ3C5 4344 Federal Home Loan Bank 1.000 12/02/2021 4,000,000.00 0.00 3130AQ5S8 4345 Federal Home Loan Bank 1.250 12/30/2021 4,650,000.00 0.00 3130AQD59 4346 Federal Home Loan Bank 1.000 12/30/2021 5,000,000.00 0.00 3130AQ7E7 4347 Federal Home Loan Bank 1.500 12/30/2021 5,002,000.00 0.00 3130AQD42 4348 Federal Home Loan Bank 0.920 12/28/2021 5,000,000.00 0.00 3130AQD59 4349 Federal Home Loan Bank 1.000 12/30/2021 5,000,000.00 0.00 Subtotal 28,652,000.00 0.00 122,692,989.58
Local Agency Investment Funds (Monthly Summary)
Subtotal 8,679,077.93
Treasury Securities - Coupon
912828YM6 4350 US Treasury Notes 1.500 12/31/2021 3,048,510.00 0.00 9128284Z0 4351 US Treasury Notes 2,750 12/31/2021 5,294,800.00 0.00 Subtotal 8,343,310.00 0.00 36,976,484.28
Medium Term Notes - Supras
Subtotal 35,213,934.44
Corporate Bonds
14913R2P1 4343 Caterpillar Financial Corp. 0.600 12/02/2021 4,947,950.00 0.00 Subtotal 4,947,950.00 0.00 47,028,056.76
ORANGE COUNTY POOL (Monthly Summary)
OCP1 01 Orange County Invest Pool 0.396 30,241.66 10.003,068.72 Subtotal 30,241.66 10,003,068.72 50,507,617.81
US Bank Sweep First AM Gov (Monthly Summary)
Subtotal 0.00
Total 41,973,501.66 10,003,068.72 301,098,160.80
Portfolio CITY
AP
Run Date: 01/14/2022 - 11:52 PM (PRF_PM3) 7.3.11
Report Ver. 7.3.11
City of Huntington Beach
Portfolio Management Page 1
Interest Earnings Summary
December 31, 2021
December 31Month Ending Fiscal Year To Date
CD/Coupon/Discount Investments:
Interest Collected 352,379.16 1,531,026.05
Plus Accrued Interest at End of Period 785,896.30 785,896.30 Less Accrued Interest at Beginning of Period 877,745.60) 764,664.92) Less Accrued Interest at Purchase During Period 0.00) ( 0.00) Interest Earned during Period 260,529.86 1,552,257.43
Adjusted by Premiums and Discounts -19,003.17 -157,527.08 Adjusted by Capital Gains or Losses 0.00 -21,439.99
Earnings during Periods 241,526.69 1,373,290.36
Pass Through Securities:
Interest Collected 0.00 0.00
Plus Accrued Interest at End of Period 0.00 0.00
Less Accrued Interest at Beginning of Period ( 0.00) 0.00) Less Accrued Interest at Purchase During Period ( 0.00) 0.00) Interest Earned during Period 0.00 0.00
Adjusted by Premiums and Discounts 0.00 0.00
Adjusted by Capital Gains or Losses 0.00 0.00
Earnings during Periods 0.00 0.00
Cash/Checking Accounts:
Interest Collected 30,241.66 239,329.69
Plus Accrued Interest at End of Period 20,912.09 20,912.09 Less Accrued Interest at Beginning of Period ( 31,745.11) ( 74,123.21) Interest Earned during Period 19,408.64 186,118.57
Total Interest Earned during Period 279,938.50 1,738,376.00 Total Adjustments from Premiums and Discounts -19,003.17 - 157,527.08 Total Capital Gains or Losses 0.00 -21,439.99
Total Earnings during Period 260,935.33 1,559,408.93
Portfolio CITY
AP
Run Date: 01/14/2022 - 11:52 PM (PRF_PM6) 7.3.11
Report Ver. 7.3.11
State of California
Pooled Money Investment Account
Market Valuation
12/31/2021
Carrying Cost Plus
Description Accrued Interest Purch. Amortized Cost Fair Value Accrued Interest United States Treasury:
Bills $ 43,569,286,927.30 $ 43,578,148,587.65 $ 43,566,910,500.00 NA Notes $ 75,086,412,242.60 $ 75,080,652,906.63 $ 74,687,028,500.00 $ 109,370,054.00 Federal Agency:
SBA $ 350,740,581.41 $ 350,740,581.41 $ 351,306,665.72 $ 148,390.75 MBS-REMICS $ 6,715,516.12 $ 6,715,516.12 $ 6,985,051.69 30,724.20 Debentures $ 10,439,956,592.62 $ 10,439,204,370.45 $ 10,416,451,600.00 $ 9,420,765.50 Debentures FR $ $
Debentures CL $ 800,000,000.00 800,000,000.00 $ 790,694,000.00 $ 762,194.00 Discount Notes $ 19,162,958,897.16 $ 19,165,010,905.46 $ 19,157,738,000.00 NA Supranational Debentures $ 2,219,658,716.35 $ 2,218,983,369.12 $ 2,204,343,500.00 6,007,849.50 Supranational Debentures FR I$ 50,000,000.00 $ 50,000,000.00 $ 50,001,500.00 $ 5,495.49 CDs and YCDs FR $ $ - $ $
Bank Notes $ 50,000,000.00 $ 50,000,000.00 $ 49,999,510.67 $ 29,305.56 CDs and YCDs $ 13,350,000,416.66 $ 13,350,000,000.00 $ 13,346,930,419.28 $ 6,017,777.79 Commercial Paper $ 11,491,501,972.14 $ 11,495,349,152.68 $ 11,494,513,733.35 NA Corporate:
Bonds FR $ $ $
Bonds $ 310,090,245.37 $ 309,862,368.98 $ 307,103,440.00 $ 1,913,014.98 Repurchase Agreements $ $ $ $
:
Reverse Repurchase $ $ $ $
Time Deposits $ 3,807,500,000.00 $ 3,807,500,000.00 3,807,500,000.00 NA PMIA & GF Loans $ 743,769,000.00 $ 743,769,000.00 $ 743,769,000.00 NA TOTAL $ 181,438,591,107.73 $ 181,445,936,758.50 I$ 180,981,275,420.71 $ 133,705,571.77 Fair Value Including Accrued Interest $ 181,114,980,992.48 Repurchase Agreements, Time Deposits, MIA & General Fund loans, and Reverse Repurchase agreements are carried at portfolio book value (carrying cost).
The value of each participating dollar equals the fair value divided by the amortized cost (0.99743912).
As an example: if an agency has an account balance of $20,000,000.00, then the agency would report its participation in the LAIF valued at $19,948,782.39 or $20,000,000.00 x 0.99743912.
Statement of Cash Receipts and Disbursements and
Summary of Cash by Fund
Finance Department
December 2021
Cash Receipts and Disbursements November 2021 December 2021 Receipts
General Fund
Property Tax $ 10,974,947 $ 24,015,007
Local Sales Tax 4,134,829 3,843,392
Public Safety Sales Tax 221,425 267,988
Transient Occupancy Tax (TOT) 1,083,342 850,926
Utility Users Tax (UUT) 1,849,979 1,458,262
Other Revenue 5,806,446 3,470,402
Total General Fund Revenue 24,070,968 33,905,976
Total All Other Funds Revenue 13,910,166 14,919,339
Total Receipts 37,981,134 $ 48,825,316
Disbursements
General Fund
Personnel Services (9,863,247) (14,746,534)
Operating Expenses (3,428,060) (4,118,527)
Capital Expenditures
Non-Operating Expenses (70,873) (465,427)
Total General Fund Disbursements (13,362,180) (19,330,489) Total All Other Funds Disbursements (11,295,942) (18,223,083) Total Disbursements (24,658,122) (37,553,572)
Net Change in Cash Flow 13,323,011 $ 11,271,744
ummary of Cash by Func November 2021 December 2021
eneral Func 62,318,532 $ 76,894,020
General Fund Other 2,848,745 2,825,390
Capital Projects Funds 25,651,070 25,042,877
Debt Service Funds 36,779,248 33,055,380
Enterprise Funds 77,974,543 77,822,120
Trust and Agency Funds 3,664,121 4,874,511
Internal Service Funds 27,061,587 26,477,663
Special Revenue Funds 55,392,908 55,970,538
General Ledger Cash Balances * $ 291,690,755 $ 302,962,498 * 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 nformation includes receipts from maturing investments and payments for purchased investment n the city investment portfolio. This statement is prepared in compliance with the City's Charter