City of Huntington Beach
Quarterly Investment Report
March 2022
Prepared by:
Alisa Backstrom, MBA, CCT, CPFIM
City Treasurer
Colin Stevens, MPP
Treasury Associate
INVESTMENT PORTFOLIO SUMMARY
AS OF: March 31, 2022
Investment Type
$ in 000's Market Value Book Value % of Portfolio
Federal Agency Issues $ 127,387 $ 132,224 44.1%
Local Agency Investment Fund (LAIF) $ 5,684 $ 5,684 1.9% Treasury Securities 63,898 $ 66,100 22.1%
Medium Term Notes - Supranationals 33,914 $ 35,177 11.7% Corporate Bonds 46,412 $ 46,924 15.7%
Commercial Paper $ 2,994 $ 2,993 1.0%
OC Investment Pool $ 10,575 $ 10,575 3.5%
TOTAL $ 290,864 $ 299,677 100%
Currently, funds within this portfolio are invested in federal agency securities, corporate bonds, commercial paper, the International Bank of Reconstruction and Development ("BRD"), 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 continued to rise during the first quarter of 2022. As interest rates rise, the market price of the securities previously purchased at lower than the current market rates goes down. This has resulted in the current market value of the portfolio being slightly lower than the book value, at $290.9 million versus $299.7 million, respectively. Increasing interest rates will allow excess funds to be invested at higher rates thus allowing the portfolio an opportunity to earn increased interest income in the future.
PORTFOLIO BREAKOUT BY TYPE - BOOK VALUE as % of Total Portfolio Commercial Paper OC Investment Pool
1% 3%
Corporate Bonds
16%
Federal Agency Issues
44%
Medium Term Notes
12%
Local Agency
Investment Fund (LAIF)
2%
Treasury Securities
22%
The largest holding by security type at month-end was federal agency securities at approximately 44% of the total overall portfolio. This was followed by treasury securities at approximately 22% of the total portfolio as of March 31. Cash held in the LAIF fund and the Orange County Pool has been reduced as higher interest rates have become available.
INVESTMENT PORTFOLIO EARNINGS
AS OF: March 31, 2022
Total Earnings Month: March Fiscal YTD
Current Year $ 324,815 $ 2,483,158
Current Budget $ 100,000 $ 900,000
Last Year Actual $ 261,545 2,609,546
Average Daily Balance $ 303,455,743 $ 283,914,207
Effective Rate of Return 1.26% 1.17%
Benchmark* 0.50% n/a
* 12-month moving average of interpolated 1.5-year treasury Earnings for the month of March 2022 were $324,815, an increase of approximately 24% from the same month in the prior year. Fiscal year-to-date earnings of $2,483, 158 were down slightly from the same period during the previous year. The effective rate of return for March was 1.26%, with a fiscal year-to-date return of 1.17%. The increase in the March rate of return over that of the fiscal year-to-date return is a result of the portfolio investing in the higher available rates. The benchmark of the 12-month moving average of the interpolated 1.5-year U.S. Treasury was
0.50% at the end of March. This rate will quickly increase as short-term rates have risen rapidly.
INVESTMENT PORTFOLIO ACTIVITY
MONTHLY ACTIVITY: March 2022
Investment Type Purchases (Face Calls/Maturities/
$ in 000's Value)/Deposits Withdrawals
Federal Agency Issues $ 4,575
Local Agency Investment Fund (LAIF) * $ 3,000
Medium Term Notes - Supranationals
Corporate Bonds $ 5,000
Commercial Paper $ 3,000
Treasury Securities $ 5,000
OC Investment Pool * $ 18 $ 10,001
TOTAL 12,593 $ 18,001
*Includes Interest Income
QUARTERLY ACTIVITY: January 1 to March 31, 2022
Investment Type Purchases (Face Calls/Maturities/
$ in 000's Value)/Deposits Withdrawals
Federal Agency Issues $ 9,575
Local Agency Investment Fund (LAIF) * $ 5 $ 3,000
Medium Term Notes - Supranationals
Corporate Bonds $ 5,000 $ 5,000
Commercial Paper 3,000
Treasury Securities 29,000
OC Investment Pool* 74 $ 40,006
TOTAL $ 46,654 $ 48,006
*Includes Interest Income
For the quarter ended March 31, 2022, approximately $40 million was moved from the Orange County pool into other investments in order to take advantage of the increasing interest rates available. As well, additional funds will become available as the property taxes are received by the City in April. The $5 million Home Depot corporate bond was called in March, providing additional funds for reinvestment.
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, 2022. The investment program herein shown provides sufficient cash flow liquidity to meet the next six months' obligations.
MAXIMUM
SPECIFIED % OF IN
INVESTMENT MAXIMUM MINIMUM QUALITY COMPLIANCE
PORTFOLIO/ REQUIREMENTS
TYPE MATURITY MAXIMUM PER ?
ISSUER
Commercial Paper 270 days 25%/10% A1, "A" Rating YES
State Obligations- "A" Rating YES
CA And Others 5 years None/10%
U.S. Treasury YES
Obligations 5 years None None
U.S. Government None None YES
Agency Obligations 5 years
IBRD, IFC, LADB 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 $76,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 OVERVIEW
MARKET SUMMARY: December 31, 2021 - MARCH 31, 2022
Fed Funds 2-Yr. 10-Yr.
As of: Rate Treasury Treasury S&P 500 DJIA
12/31/2021 0.00 - 0.25% 0.73% 1.52% $ 4,766.18 $ 36,338.30 3/31/2022 0.25 - 0.50% 2.28% 2.32% $ 4,530.41 $ 34,678.35 % Change 100.00% 212.33% 52.63% -4.95% -4.57%
The Federal Open Market Committee (FOMC) met in March to discuss the current state of the economy and to examine potential future interest rate adjustments. They concluded that the invasion of Ukraine by Russia is causing tremendous human and economic hardship, and that this will likely create additional upward pressure on inflation and weigh on economic activity. The Fed Funds approved a rate hike for the first time in three years in March to 0.25-0.50%.
Fixed Income / Equity Markets: The yield on the 10-year U.S. Treasury finished the quarter at
2.32%, up from 1.52% at the end of last quarter. The S&P 500 decreased by 4.95% over the quarter and the DJIA decreased by 4.57% over the same period.
Employment: Total nonfarm payroll employment rose by 431,000 in March, and the unemployment rate declined to 3.6 percent. Notable job gains occurred in leisure and hospitality, professional and business services, retail trade, and manufacturing.
TREASURY RATES
The following chart shows the 2- and 5-year Treasury Yield Curve rates for the period March 2021 to March 2022. Both the 2- and 5-year Treasury rates have been increasing over the past six months. These Treasury rates are proxies for the type of rates the portfolio will obtain upon investment.
- 2Yr Tsy
- 5Yr Tsy
Treasury Rates
2,110
100- 1.910
1.80- 1.076
1.60 1.590
1.50 1.40-
1.200 2,236
0.860 0.840 0,850
0.80 0,820 0.820
0.770
0.70 0.6p6
0.60 0.50 0.530
0.40 0.390
0.30 0.210-
0.200 0,220
0.20 0.350 0.160
0.10 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 City of Huntington Beach
City of Huntington Beach 2000 Main St.
Portfolio Management Huntington Beach,
Portfolio Summary
January 31, 2022
Par Market Book % of Days to YTM YTM
Investments Value Portfolio Term Maturity 360 Equiv. 365 Equiv.
Value Value
Federal Agency Issues - Coupon 122,650,000.00 121,303,852.50 122,689,211.86 40.07 1,485 1,070 1.187 1.204 Local Agency Investment Funds 8,684,249.01 8,684,249.01 8,684,249.01 2.84 1 1 0.231 0.234 Treasury Securities - Coupon 52,000,000.00 51,518,700.00 52,141,610.91 17.03 1,279 1,091 1.006 1.020 Medium Term Notes - Supras 35,000,000.00 34,710,580.00 35,201,477.99 11.50 1,464 923 1.006 1.020 Corporate Bonds 51,684,000.00 51,991,878.30 51,940,272.52 16.96 1,183 438 2.064 2.093 ORANGE COUNTY POOL 35,533,601.78 35,533,601.78 35,533,601.78 11.61 1 0.396 0.402 305,551,850.79 303,742,861.59 306, 190,424.07 100.00% 1,182 795 1.165 1.182 Investments
Total Earnings January 31 Month Ending Fiscal Year To Date Fiscal Year Ending Current Year 294,599.75 1,854,643.79
Current Budget 100,000.00 700,000.00 1,200,000.00
Last Year Actual 264,248.91 2,080,252.53 3,403,369.60
Average Daily Balance 303,250,810.44 278,613,537.62
Effective Rate of Return 1.14% 1.13%
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 1s policy watable actuate oftene aly cleric. The investment program her 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 01/01/2022-01/31/2022 Portfolio CITY
AP
Run Date: 04/20/2022 - 13:57 PM (PRF_PM1) 7.3.11
Report Ver. 7.3.11
City of Huntington Beach
Portfolio Management Page 1
Portfolio Details - Investments
January 31, 2022
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,109,600.00 5,002,378.50 2.260 AA 2.236 771 03/13/2024 3133EKTG1 4296 Federal Farm Credit Bank 07/01/2019 5,000,000.00 5,029,200.00 4,998,576.39 1,750 1.821 150 07/01/2022 313383QR5 4281 Federal Home Loan Bank 12/20/2018 5,000,000.00 5,153,550.00 5,032,149.16 3.250 2,743 493 06/09/2023 3130AFWX1 4285 Federal Home Loan Bank 02/26/2019 5,000,000.00 5,107,150.00 5,000,000.00 2.550 2.550 483 05/30/2023 3130AKN36 4320 Federal Home Loan Bank 01/15/2021 5,000,000.00 4,832,850.00 4,996,044.44 0.525 0.545 1,444 01/15/2026 3130AKN85 4321 Federal Home Loan Bank 01/20/2021 5,000,000.00 4,816,450.00 4,998,015.28 0.550 0.560 1,449 01/20/2026 3130AKUS3 4322 Federal Home Loan Bank 01/28/2021 5,000,000.00 4,789,700.00 5,000,000.00 0.500 0.500 1,457 01/28/2026 3130AMDL3 4327 Federal Home Loan Bank 05/25/2021 5,000,000.00 4,881,900.00 5,000,000.00 0.800 0.800 1,270 07/25/2025 3130AMJN3 4328 Federal Home Loan Bank 05/26/2021 5,000,000.00 4,898,050.00 5,000,000.00 1.030 1.030 1,575 05/26/2026 3130AMQ54 4331 Federal Home Loan Bank 06/16/2021 5,000,000.00 4,855,500.00 5,000,000.00 0.700 0.700 1,323 09/16/2025 3130AMQ62 4332 Federal Home Loan Bank 06/14/2021 5,000,000.00 4,873,450.00 5,000,000.00 0.625 0.625 1,137 03/14/2025 3130ALEY6 4333 Federal Home Loan Bank 06/10/2021 5,000,000.00 4,869,350.00 5,000,000.00 0.800 0.800 1,492 03/04/2026 3130AMW65 4334 Federal Home Loan Bank 06/30/2021 5,000,000.00 4,894,450.00 5,000,000.00 0.500 0.500 1,063 12/30/2024 3130AMFS6 4335 Federal Home Loan Bank 06/17/2021 5,000,000.00 4,826,450.00 4,973,743.73 0.750 0.873 1,592 06/12/2026 3130AMXJ6 4336 Federal Home Loan Bank 06/30/2021 5,000,000.00 4,890,100.00 5,000,000.00 0.500 0.500 972 09/30/2024 3130AQ3C5 4344 Federal Home Loan Bank 12/02/2021 4,000,000.00 3,972,640.00 4,000,000.00 1.000 1.000 939 08/28/2024 3130AQ5S8 4345 Federal Home Loan Bank 12/30/2021 4,650,000.00 4,621,402.50 4,650,000.00 1.250 1.250 1,245 06/30/2025 3130AQD59 4346 Federal Home Loan Bank 12/30/2021 5,000,000.00 4,966,450.00 5,000,000.00 1.000 1.000 972 09/30/2024 3130AQ7E7 4347 Federal Home Loan Bank 12/30/2021 5,000,000.00 4,978,150.00 5,001,961.73 1.500 1.491 1,610 06/30/2026 3130AQD42 4348 Federal Home Loan Bank 12/28/2021 5,000,000.00 4,951,050.00 5,000,000.00 0.920 0.920 878 06/28/2024 3130AQD59 4349 Federal Home Loan Bank 12/30/2021 5,000,000.00 4,966,450.00 5,000,000.00 1.000 1.000 972 09/30/2024 3137EAEN5 4287 Federal Home Loan Mort Corp 03/08/2019 3,000,000.00 3,072,390.00 3,011,730.95 2.750 2.450 503 06/19/2023 3137EAEN5 4288 Federal Home Loan Mort Corp 03/14/2019 3,000,000.00 3,072,390.00 3,012,253.72 2,750 2.437 503 06/19/2023 3135GOU43 4289 Fed. Natl Mort. Assoc. 03/15/2019 5,000,000.00 5,142,550.00 5,031,116.02 2.875 2.465 588 09/12/2023 3135GAZZ3 4318 Fed. Natl Mort. Assoc. 01/11/2021 3,000,000.00 2,886,480.00 3,002,581.79 0.560 0.537 1,385 11/17/2025 3135G04Z3 4329 Fed. Natl Mort. Assoc. 05/14/2021 5,000,000.00 4,846, 150.00 4,978,660.15 0.500 0.628 1,232 06/17/2025 Subtotal and Average 122,690,978.89 122,650,000.00 121,303,852.50 122,689,211.86 1.204 1,070 Local Agency Investment Funds
SYS982 982 Laif City 8,684,249.01 8,684,249.01 8,684,249.01 0.234 0.234 -| r
Subtotal and Average 8,682,080.49 8,684,249.01 8,684,249.01 8,684,249.01 0.234 Treasury Securities - Coupon
912828YH7 4298 US Treasury Notes 12/05/2019 5,000,000.00 5,023,050.00 4,987,856.90 1.500 AAA 1.595 972 09/30/2024 912828P79 4299 US Treasury Notes 12/05/2019 3,000,000.00 3,020,970.00 2,997,666.17 1.500 AAA 1.574 392 02/28/2023 91282CAB7 4330 US Treasury Notes 05/19/2021 5,000,000.00 4,792,800.00 4,937,114.99 0.250 0.615 1,276 07/31/2025 Portfolio CITY
AP
Run Date: 04/20/2022 - 13:57 PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
City of Huntington Beach
Portfolio Management Page 2
Portfolio Details - Investments
January 31, 2022
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 962,770.00 993,740.43 0.750 0.890 1,672 08/31/2026 91282CAJ0 4340 US Treasury Notes 09/27/2021 5,000,000.00 4,784,000.00 4,914,552.82 0.250 0.735 1,307 08/31/2025 91282CCP4 4341 US Treasury Notes 09/30/2021 5,000,000.00 4,790,800.00 4,928,771.86 0.625 0.950 1,641 07/31/2026 91282CCW9 4342 US Treasury Notes 11/23/2021 5,000,000.00 4,813,850.00 4,881,522.68 0.750 1.285 1,672 08/31/2026 912828YM6 4350 US Treasury Notes 12/31/2021 3,000,000.00 3,012,660.00 3,047,010.17 1.500 0.920 1,003 10/31/2024 912828420 4351 US Treasury Notes 12/31/2021 5,000,000.00 5,219,350.00 5,287,754.74 2.750 1.103 1,307 08/31/2025 912828592 4352 US Treasury Notes 01/14/2022 5,000,000.00 5,016,600.00 5,040,076.38 1.250 0.711 545 07/31/2023 91282887 4353 US Treasury Notes 01/14/2022 5,000,000.00 5,057,250.00 5,088,746.50 1.750 1.028 911 07/31/2024 9128282D1 4354 US Treasury Notes 01/21/2022 5,000000.00 5,024,600.00 5,036,797.27 1.375 0.903 576 08/31/2023 Subtotal and Average 44,645,689.27 52,000,000.00 51,518,700.00 52,141,610.91 1.020 1,091 Medium Term Notes - Supras
45818WBX3 4290 Inter-American Dev. Bank 03/28/2019 4,000,000.00 4,106,000.00 4,033,376.08 2.870 2.270 534 07/20/2023 45818WBY1 4291 Inter-American Dev. Bank 03/28/2019 5,000,000.00 5,143,700.00 5,050,277.09 2,960 2.271 561 08/16/2023 45818WCT1 4312 Inter-American Dev. Bank 04/29/2020 6,000,000.00 6,038,580.00 6,062,272.55 1.600 0.550 363 01/30/2023 459058JL8 4319 Inti Bk Recon & Development 01/12/2021 5,000,000.00 4,804,100.00 4,997,853.85 0.500 AAA 0.512 1,365 10/28/2025 459056HV2 4323 Int Bk Recon & Development 04/23/2021 5,000,000.00 5,021,350.00 5,137,242.16 1.500 AAA 0.425 939 08/28/2024 45906M2L4 4324 Int Bk Recon & Development 04/30/2021 5,000,000.00 4,794,100.00 4,956,295.62 0.650 AAA 0,870 1,484 02/24/2026 459058JE4 4338 Intl Bk Recon & Development 07/30/2021 5,000,000.00 4,802,750.00 4,964,160.64 0.376 AAA 0.584 1.273 07/28/2025 Subtotal and Average 35,207,309.99 35,000,000.00 34,710,580.00 35,201,477.99 1.020 923 Corporate Bonds
037833DE7 4313 Apple Inc. 04/29/2020 5,000,000.00 5,068,950.00 5,076,475.98 2.400 0.720 346 01/13/2023 14913R2P1 4343 Caterpillar Financial Corp. 12/02/2021 5,000,000.00 4,871,000.00 4,951,017.88 0.600 0.980 955 09/13/2024 166764AH3 4294 Chevron Corp 05/24/2019 5,000,000.00 5,120,300.00 5,041,232.31 3.191 AA 2.528 508 06/24/2023 254687CR5 4300 Disney 12/16/2019 2,875,000.00 3,000,810.00 2,963,461.54 4.000 2.070 607 10/01/2023 437076BG6 4293 Home Depot Inc 05/24/2019 5,000,000.00 5,027,950.00 5,002,345.91 2.625 >> 2.474 120 06/01/2022 459200HG9 4274 IBM Corp 09/28/2018 3,000,000.00 3,017,580.00 2,979,891.54 1.875 3.257 181 08/01/2022 67066GAL8 4355 Nvidia 01/24/2022 5,000,000.00 4,884,650.00 4,922,486.10 0.584 1.250 864 06/14/2024 713448CX4 4280 PEPSICO INC 12/21/2018 5,000,000.00 5,039,500.00 4,998,689.81 3.100 3.160 166 07/17/2022 882508BA1 4279 Texas Instruments Inc 12/21/2018 5,000,000.00 5,008,400.00 4,983,308.17 1.850 3.564 103 05/15/2022 904764AW7 4286 Unilever 03/01/2019 5,000,000.00 5,013,250.00 4,992,518.62 2.200 2.802 93 05/05/2022 90331HNV1 4306 US Bank NA Cincinnati 02/21/2020 2,000,000.00 2,059,260.00 2,048,337.44 3.400 AA 1.671 538 07/24/2023 91159HHX1 4325 US Bank NA Cincinnati 04/30/2021 3,809,000.00 3,880,228.30 3,980,507.22 2.400 0.528 910 07/30/2024 Subtotal and Average 48,292,853.88 51,684,000.00 51,991,878.30 51,940,272.52 2.093 438 Portfolio CITY
AP
Run Date: 04/20/2022 - 13:57 PM (PRF_PM2) 7.3.11
City of Huntington Beach
Portfolio Management Page 3
Portfolio Details - Investments
January 31, 2022
Average Purchase Stated YTM Days to Maturity
CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate S&P 365 Maturity Date
ORANGE COUNTY POOL
OCP1 01 Orange County Invest Pool 35,533,601.78 35,533,601.78 35,533,601.78 0.402 0.402 1 Subtotal and Average 43,731,897.91 35,533,601.78 35,533,601.78 35,533,601.78 0.402 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 0.00 0.00 0.00 0.00 0.000
Total and Average 303,250,810.44 305,551,850.79 303,742,861.59 306,190,424.07 1.182 795 Portfolio CITY
AP
Run Date: 04/20/2022 - 13:57 PM (PRF_PM2) 7.3.11
City of Huntington Beach
Portfolio Management Page 4
Portfolio Details - Cash
January 31, 2022
Average Purchase Stated YTM Days to
CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate S&P 365 Maturity Average Balance 0.00
Total Cash and Investments 303,250,810.44 305,551,850.79 303,742,861.59 306,190,424.07 1.182 795 Portfolio CITY
AP
Run Date: 04/20/2022 - 13:57 PM (PRF_PM2) 7.3.11
City of Huntington Beach
Portfolio Management
Activity By Type
January 1, 2022 through January 31, 2022
Stated Transaction Purchases Redemptions
CUSIP Investment # Issuer Rate Date or Deposits or Withdrawals Balance Federal Agency Issues - Coupon
Subtotal 122,689,211.86
Local Agency Investment Funds (Monthly Summary)
SYS982 982 Laif City 0.234 5,171.08 0.00
Subtotal 5,171.08 0.00 8,684,249.01
Treasury Securities - Coupon
912828S92 4352 US Treasury Notes 1.250 01/14/2022 5,041,400.00 912828Y87 4353 US Treasury Notes 1.750 01/14/2022 5,090,500.00 9128282D1 4354 US Treasury Notes 1.375 01/21/2022 5,037,500.00 Subtotal 15,169,400.00 52,141,60.91
Medium Term Notes - Supras
Subtotal 35,201,477.99
Corporate Bonds
67066GAL8 4355 Nvidia 0.584 01/24/2022 4,921,850.00 0.00 Subtotal 4,921,850.00 0.00 51,940,272.52
ORANGE COUNTY POOL (Monthly Summary)
OCP1 01 Orange County Invest Pool 0.402 28,601.86 15,002,617.89 Subtotal 28,601.86 15,002,617.89 35,533,601.78
US Bank Sweep First AM Gov (Monthly Summary)
Subtotal 0.00
Total 20,125,022.94 15,002,617.89 306,190,424.07
Portfolio CITY
AP
Run Date: 04/20/2022 - 13:57 PM (PRF_PM3) 7.3.11
Report Ver. 7.3.11
City of Huntington Beach
Portfolio Management Page 1
Activity Summary
January 2021 through January 2022
Yield to Maturity Number Number
Average 360 365 Pool of Investments of Investments
Year Balance Redeemed
Rate Purchased
2021 36 245,184,705.47 5 2 474
2021 34 244,848,561.08 471
2021 34 241,726,743.55 0 1 451
2021 37 245,258,735.71 4 488
2021 41 272,220,547.80 4 529
2021 47 299,541,338.17 7 667
2021 47 294,084,830.06 1 705
2021 46 278,833,182.25 1 1 711
2021 48 271,196,912.63 3 713
2021 46 270,161,809.86 0 715
2021 47 269,384,512.30 1 725
2021 54 262,845,749.33 7 774
2022 60 303,250,810.44 4 795
Average 44 269,279,708.12 3 1 632
Portfolio CITY
AP
Run Date: 04/20/2022 - 13:57 PM (PRF_PM4) 7.3.11
Report Ver. 7.3.11
City of Huntington Beach
Portfolio Management Page 1
Interest Earnings Summary
January 31, 2022
January 31Month Ending Fiscal Year To Date
CD/Coupon/Discount Investments:
Interest Collected 438,652.88 1,969,678.93
Plus Accrued Interest at End of Period 655,349.31 655,349.31 Less Accrued Interest at Beginning of Period 785,917.28) ( 764,664.92) Less Accrued Interest at Purchase During Period 0.00) ( 0.00) Interest Earned during Period 308,084.91 1,860,363.32
Adjusted by Premiums and Discounts -30,141.78 -187,668.86 Adjusted by Capital Gains or Losses 0.00 -21,439.99
Earnings during Periods 277,943.13 1,651,254.47
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 33,772.94 273,102.63
Plus Accrued Interest at End of Period 4,409.90 4,409.90 Less Accrued Interest at Beginning of Period ( 21,526.22) 74,123.21) Interest Earned during Period 16,656.62 203,389.32
Total Interest Earned during Period 324,741.53 2,063,752.64 Total Adjustments from Premiums and Discounts -30,141.78 -187,668.86 Total Capital Gains or Losses 0.00 -21,439.99
Total Earnings during Period 294,599.75 1,854,643.79
Portfolio CITY
AP
Run Date: 04/20/2022 - 13:57 PM (PRF_PM6) 7.3.11
Report Ver. 7.3.11
State of California
Pooled Money Investment Account
Market Valuation
1/31/2022
Carrying Cost Plus
Description Accrued Interest Purch. Fair Value Accrued Interest United States Treasury:
Bills 48,500,254,535.59 48,460,414,000.00 NA
Notes 85,696,415,143.41 $ 84,813,187,000.00 $ 147,054,459.50 Federal Agency:
SBA $ 345,829,327.41 346,364,913.87 146,293.30
MBS-REMICS $ 6,159,422.37 6,391,641.14 28,137.60
Debentures 10,404,956,466.49 $ 10,349,010,050.00 $ 8,594,390.00 Debentures FR $ $
Debentures CL $ 900,000,000.00 $ 882,711,000.00 $ 773,360.00 Discount Notes 22,357,095,147.12 22,333,152,750.00 NA
Supranational Debentures $ 2,069,293,683.95 2,040,256,500.00 $ 6,507,100.50 Supranational Debentures FR $ 50,000,000.00 50,005,500.00 $ 15,516.67 CDs and YCDs FR $ $
Bank Notes $ $
CDs and YCDs $ 14,925,000,416.66 $ 14,919,734,588.32 $ 7,131,118.02 Commercial Paper $ 12,613,539,263.83 12,614,873,270.77 NA Corporate:
Bonds FR $
Bonds 329,900,428.70 322,995,970.00 $ 1,541,557.55
Repurchase Agreements $
Reverse Repurchase $ :
Time Deposits 3,903,500,000.00 3,903,500,000.00 NA
PMIA & GF Loans 743,769,000.00 743,769,000.00 NA
TOTAL $ 202,845,712,835.53| $ 201,786,366,184.10 $ 171,791,933.14 Fair Value Including Accrued Interest $ 201,958,158,117.24 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
January 2022
Cash Receipts and Disbursements December 2021 January 2022 Receipts
General Fund
Property Tax $ 24,015,007 $ 15,514,563
Local Sales Tax 3,843,392 3,660,024
Public Safety Sales Tax 267,988 223,876
Transient Occupancy Tax (TOT) 850,926 940,430
Utility Users Tax (UUT) 1,458,262 1,597,233
Other Revenue 3,470,402 5,179,294
Total General Fund Revenue 33,905,976 27,115,419
Total All Other Funds Revenue 14,919,339 10,699,810
Total Receipts 48,825,316 $ 37,815,229
Disbursements
General Fund
Personnel Services (14,746,534) (10,926,377)
Operating Expenses (4,118,527) (2,599,520)
Capital Expenditures
Non-Operating Expenses (465,427) (22,605)
Total General Fund Disbursements (19,330,489) (13,548,502) Total All Other Funds Disbursements (18,223,083) (14,184,315) Total Disbursements (37,553,572) (27,732,817)
Net Change in Cash Flow 11,271,744 $ 10,082,412
Summary of Cash by Fund December 2021 January 2022
General Fund 76,987,473 $ 90,554,390
General Fund Other 2,828,068 2,662,390
Capital Projects Funds 25,068,128 24,758,753
Debt Service Funds 33,087,268 33,691,999
Enterprise Funds 77,902,768 75,230,152
Trust and Agency Funds 8,920,708 8,394,751
Internal Service Funds 26,505,102 26,407,301
Special Revenue Funds 56,018,131 55,700,322
General Ledger Cash Balances * $ 307,317,646 $ 317,400,058 * 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.
City of Huntington Beach
City of Huntington Beach 2000 Main St.
Huntington Beach,
Portfolio Management
Portfolio Summary
COUNTY
February 28, 2022
Par Market Book % of Days to YT YTM
Investments Value Value Value Portfolio Term Maturity 360 Equiv. 365 Equiv.
Federal Agency Issues - Coupon 127,650,000.00 125,417,898.50 127,685,434.16 41.85 1,491 1,065 1.209 1.225 Local Agency Investment Funds 8,684,249.01 8,684,249.01 8,684,249.01 2.85 1 1 0.274 0.278 Treasury Securities - Coupon 61,000,000.00 60,142,520.00 61,088,328.82 20.02 1,195 1,007 1.041 1.055 Medium Term Notes - Supras 35,000,000.00 34,521,500.00 35,189,021.54 11.53 1,464 896 1.006 1.020 Corporate Bonds 51,684,000.00 51,775,909.86 51,932,728.34 17.02 1,183 410 2.065 2.093 ORANGE COUNTY POOL 20,558,673.37 20,558,673.37 20,558,673.37 6.74 1 1 0.433 0.439 304,576,922.38 301,100,750.74 305,138,435.24 100.00% 1,234 821 1.218 1.235 Investments
Total Earnings February 28 Month Ending Fiscal Year To Date Fiscal Year Ending Current Year 303,699.41 2,158,343.20
Current Budget 100,000.00 800,000.00 1,200,000.00
Last Year Actual 267,748.47 2,348,001.00 3,403,369.60
Average Daily Balance 302,980,501.77 281,421,253.65
Effective Rate of Return 1.31% 1.15%
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 Bank Clus oyalable at the office of the City Clerk. The investment program herein shown provides suficient cash fow liquidity to meet the next six monthis obligations. Market Values provided by us Alisa Backstrom, CITY TREASURER
Reporting period 02/01/2022-02/28/2022 Portfolio CITY
AP
Run Date: 04/20/2022 - 13:58 PM (PRF_PM1) 7.3.11
Report Ver. 7.3.11
City of Huntington Beach
Portfolio Management Page 1
Portfolio Details - Investments
February 28, 2022
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
3133ECHХ5 4292 Federal Farm Credit Bank 05/23/2019 5,000,000.00 5,075,950.00 5,002,284.86 2.260 AA . 2.236 743 03/13/2024 3133EKTG1 4296 Federal Farm Credit Bank 07/01/2019 5,000,000.00 5,022,450.00 4,998,861.11 1.750 1.821 122 07/01/2022 313383QR5 4281 Federal Home Loan Bank 12/20/2018 5,000,000.00 5,125,600.00 5,030,172.78 3.250 2.743 465 06/09/2023 3130AFWX1 4285 Federal Home Loan Bank 02/26/2019 5,000,000.00 5,083,450.00 5,000,000.00 2.550 2.550 455 05/30/2023 3130AKN36 4320 Federal Home Loan Bank 01/15/2021 5,000,000.00 4,793,250.00 4,996,127.78 0.525 0.545 1,416 01/15/2026 3130AKN85 4321 Federal Home Loan Bank 01/20/2021 5,000,000.00 4,757,500.00 4,998,056.94 0.550 0.560 1,421 01/20/2026 3130AKUS3 4322 Federal Home Loan Bank 01/28/2021 5,000,000.00 4,751,350.00 5,000,000.00 0.500 0.500 1,429 01/28/2026 3130AMDL3 4327 Federal Home Loan Bank 05/25/2021 5,000,000.00 4,843,250.00 5,000,000.00 0.800 0.800 1,242 07/25/2025 3130AMJN3 4328 Federal Home Loan Bank 05/26/2021 5,000,000.00 4,856,600.00 5,000,000.00 1.030 1.030 1,547 05/26/2026 3130AMQ54 4331 Federal Home Loan Bank 06/16/2021 5,000,000.00 4,816,700.00 5,000,000.00 0.700 0.700 1,295 09/16/2025 3130AMQ62 4332 Federal Home Loan Bank 06/14/2021 5,000,000.00 4,836,700.00 5,000,000.00 0.625 0.625 1,109 03/14/2025 3130ALEY6 4333 Federal Home Loan Bank 06/10/2021 5,000,000.00 4,828,700.00 5,000,000.00 0.800 0.800 1,464 03/04/2026 3130AMW65 4334 Federal Home Loan Bank 06/30/2021 5,000,000.00 4,860,300.00 5,000,000.00 0.500 0.500 1,035 12/30/2024 3130AMFS6 4335 Federal Home Loan Bank 06/17/2021 5,000,000.00 4,779,150.00 4,974,245.13 0.750 0.873 1,564 06/12/2026 3130AMXJ6 4336 Federal Home Loan Bank 06/30/2021 5,000,000.00 4,858,800.00 5,000,000.00 0.500 0.500 944 09/30/2024 3130AQ3C5 4344 Federal Home Loan Bank 12/02/2021 4,000,000.00 3,948,960.00 4,000,000.00 1.000 1.000 911 08/28/2024 3130AQ5S8 4345 Federal Home Loan Bank 12/30/2021 4,650,000.00 4,589,038.50 4,650,000.00 1.250 1.250 1,217 06/30/2025 3130AQD59 4346 Federal Home Loan Bank 12/30/2021 5,000,000.00 4,936,200.00 5,000,000.00 1,000 1.000 944 09/30/2024 3130AQ7E7 4347 Federal Home Loan Bank 12/30/2021 5,000,000.00 4,943,350.00 5,001,924.69 1.500 1.491 1,582 06/30/2026 3130AQD42 4348 Federal Home Loan Bank 12/28/2021 5,000,000.00 4,922,450.00 5,000,000.00 0.920 0.920 850 06/28/2024 3130AQD59 4349 Federal Home Loan Bank 12/30/2021 5,000,000.00 4,936,200.00 5,000,000.00 1.000 1.000 944 09/30/2024 3130AQS79 4356 Federal Home Loan Bank 02/07/2022 5,000,000.00 4,961,450.00 5,000,000.00 1.375 1.755 1,620 08/07/2026 3137EAEN5 4287 Federal Home Loan Mort Corp 03/08/2019 3,000,000.00 3,057,510.00 3,011.024.27 2,750 2.450 475 06/19/2023 3137EAEN5 4288 Federal Home Loan Mort Corp 03/14/2019 3,000,000.00 3,057,510.00 3,011,515.54 2,750 2.437 475 06/19/2023 3135GOU43 4289 Fed. Natl Mort. Assoc. 03/15/2019 5,000,000.00 5,112,500.00 5,029,509.34 2.875 2,465 560 09/12/2023 3135GA2Z3 4318 Fed. Natl Mort. Assoc. 01/11/2021 3,000,000.00 2,863,530.00 3,002,525.09 0.560 0.537 1,357 11/17/2025 3135G04Z3 4329 Fed. Natl Mort. Assoc. 05/14/2021 5,000,000.00 4,799,450.00 4,979,186.63 0.500 0.628 1,204 06/17/2025 Subtotal and Average 126,615,948.40 127,650,000.00 125,417,898.50 127,685,434.16 1.225 1,065 Local Agency Investment Funds
SYS982 982 Laif City 8,684,249.01 8,684.249.01 8.684,249.01 0.278 0.278 1 Subtotal and Average 8,684,249.01 8,684,249.01 8,684,249.01 8,684,249.01 0.278 1 Treasury Securities - Coupon
912828YH7 4298 US Treasury Notes 12/05/2019 5,000,000.00 4,987,500.00 4,988,206.70 1.500 AAA 1.595 944 09/30/2024 912828P79 4299 US Treasury Notes 12/05/2019 3,000,000.00 3,011,490.00 2,997,832.87 1.500 AAA . 1.574 364 02/28/2023 Portfolio CITY
AP
Run Date: 04/20/2022 - 13:58 PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
City of Huntington Beach
Portfolio Management Page 2
Portfolio Details - Investments
February 28, 2022
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
91282CAB7 4330 US Treasury Notes 05/19/2021 5,000,000.00 4,761,350.00 4,938,494.92 0.250 0.615 1,248 07/31/2025 91282CCW9 4339 US Treasury Notes 09/23/2021 1,000,000.00 956,950.00 993,845.26 0.750 0.890 1,644 08/31/2026 91282CAJO 4340 US Treasury Notes 09/27/2021 5,000,000.00 4,752,150.00 4,916,383.37 0.250 0.735 1,279 08/31/2025 91282CCP4 4341 US Treasury Notes 09/30/2021 5,000,000.00 4,761,350.00 4,929,987.21 0.625 0.950 1,613 07/31/2026 91282CCW9 4342 US Treasury Notes 11/23/2021 5,000,000.00 4,784,750.00 4,883,506.75 0,750 1,285 1,644 08/31/2026 912828YM6 4350 US Treasury Notes 12/31/2021 3,000,000.00 2,991,690.00 3,045,697.83 1.500 0.920 975 10/31/2024 9128284Z0 4351 US Treasury Notes 12/31/2021 5,000,000.00 5,175,800.00 5,281,590.14 2,750 1.103 1,279 08/31/2025 912828592 4352 US Treasury Notes 01/14/2022 5,000,000.00 4,997,650.00 5,038,017.41 1.250 0.711 517 07/31/2023 912828Y87 4353 US Treasury Notes 01/14/2022 5,000,000.00 5,023,050.00 5,086,018.84 1.750 1.028 883 07/31/2024 9128282D1 4354 US Treasury Notes 01/21/2022 5,000,000.00 5,002,550.00 5,035,008.52 1.375 0.903 548 08/31/2023 91282CCN9 4357 US Treasury Notes 02/02/2022 5,000,000.00 4,917,800.00 4,939,117.07 0.125 0.991 517 07/31/2023 912828Y87 4358 US Treasury Notes 02/11/2022 4,000,000.00 4,018,440.00 4,014,621.93 1,750 1.595 883 07/31/2024 Subtotal and Average 59,480,137.66 61,000,000.00 60,142,520.00 61,088,328.82 1.055 1,007 Medium Term Notes - Supras
45818WBX3 4290 Inter-American Dev. Bank 03/28/2019 4,000,000.00 4,084,360.00 4,031,483.30 2.870 2,270 506 07/20/2023 45818WBY1 4291 Inter-American Dev. Bank 03/28/2019 5,000,000.00 5,115,250.00 5,047,559.41 2.960 2.271 533 08/16/2023 45818WCT1 4312 Inter-American Dev. Bank 04/29/2020 6,000,000.00 6,023,040.00 6,057,068.72 1.600 0.550 335 01/30/2023 459058JL8 4319 Inti Bk Recon & Development 01/12/2021 5,000,000.00 4,768,450.00 4,997,901.65 0.500 AAA 0.512 1,337 10/28/2025 459056HV2 4323 Int Bk Recon & Development 04/23/2021 5,000,000.00 4,986,950.00 5,132,800.66 1.500 AAA 0.425 911 08/28/2024 45906M2L4 4324 Inti Bk Recon & Development 04/30/2021 5,000,000.00 4,774,600.00 4,957,191.81 0.650 AAA 0.870 1,456 02/24/2026 459058JE4 4338 Intl Bk Recon & Development 07/30/2021 5,000,000.00 4,768,850.00 4,965,015.99 0.376 AAA 0.584 1.245 07/28/2025 Subtotal and Average 35,195,427.72 35,000,000.00 34,521,500.00 35,189,021.54 1.020 896 Corporate Bonds
037833DE7 4313 Apple Inc. 04/29/2020 5,000,000.00 5,046,400.00 5,069,767.56 2.400 0.720 318 01/13/2023 14913R2P1 4343 Caterpillar Financial Corp. 12/02/2021 5,000,000.00 4,832,950.00 4,952,577.82 0.600 0.980 927 09/13/2024 166764AH3 4294 Chevron Corp 05/24/2019 5,000,000.00 5,095,450.00 5,038,773.13 3.191 AA 2.528 480 06/24/2023 254687CR5 4300 Disney 12/16/2019 2,875,000.00 2,975,826.25 2,959,038.46 4.000 2.070 579 10/01/2023 437076BG6 4293 Home Depot Inc 05/24/2019 5,000,000.00 5,015,800.00 5,001,759.43 2.625 A 2.474 92 06/01/2022 459200HG9 4274 IBM Corp 09/28/2018 3,000,000.00 3,010,770.00 2,983,242.95 1.875 A 3.257 15308/01/2022 67066GAL8 4355 Nvidia 01/24/2022 5,000,000.00 4,865,500.00 4,925,212.27 0.584 1.250 836 06/14/2024 713448CX4 4280 PEPSICO INC 12/21/2018 5,000,000.00 5,022,150.00 4,998,926.59 3.100 3.160 138 07/17/2022 882508BA1 4279 Texas Instruments Inc 12/21/2018 5,000,000.00 5,006,050.00 4,988,123.12 1.850 3.564 75 05/15/2022 904764AW7 4286 Unilever 03/01/2019 5,000,000.00 5,007,150.00 4,994,906.29 2.200 2.802 65 05/05/2022 90331HNV1 4306 US Bank NA Cincinnati 02/21/2020 2,000,000.00 2,045,860.00 2,045,616.76 3.400 AA 1.671 510 07/24/2023 Portfolio CITY
AP
Run Date: 04/20/2022 - 13:58 PM (PRF _PM2) 7.3.11
City of Huntington Beach
Portfolio Management Page 3
Portfolio Details - Investments
February 28, 2022
Average Purchase Stated YTM Days to Maturity
CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate S&P 365 Maturity Date Corporate Bonds
91159HHX1 4325 US Bank NA Cincinnati 04/30/2021 3,809,000.00 3,852,003.61 3,974,783.96 2.400 0.528 882 07/30/2024 Subtotal and Average 51,936,608.21 51,684,000.00 51,775,909.86 51,932,728.34 2.093 410
ORANGE COUNTY POOL
OCP1 01 Orange County Invest Pool 20,558,673.37 20,558,673.37 20,558,673.37 0.439 0.439 1 Subtotal and Average 21,068,130.77 20,558,673.37 20,558,673.37 20,558,673.37 0.439 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 0.00 0.00 0.00 0.000 0
0.00 Total and Average 302,980,501.77 304,576,922.38 301,100,750.74 305,138,435.24 1.235 821 Portfolio CITY
AP
Run Date: 04/20/2022 - 13:58 PM (PRF_PM2) 7.3.11
City of Huntington Beach
Portfolio Management Page 4
Portfolio Details - Cash
February 28, 2022
Average Purchase Stated YTM Days to
CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate S&P 365 Maturity Average Balance 0.00 0
Total Cash and Investments 302,980,501.77 304,576,922.38 301,100,750.74 305,138,435.24 1.235 821 Portfolio CITY
AP
Run Date: 04/20/2022 - 13:58 PM (PRF_PM2) 7.3.11
City of Huntington Beach
Portfolio Management Page 1
Activity By Type
February 1, 2022 through February 28, 2022
Stated Transaction Purchases Redemption
CUSIP Investment # Issuer Rate Date or Deposits r Withdrawal Balance Federal Agency Issues - Coupon
3130AQS79 4356 Federal Home Loan Bank 1.375 02/07/2022 5,000.000.00 0.00 Subtotal 5,000,000.00 0.00 127,685,434.16
Local Agency Investment Funds (Monthly Summary)
Subtotal 8,684,249.01
Treasury Securities - Coupon
91282CCN9 4357 US Treasury Notes 0.125 02/02/2022 4,935,937.50 0.00 912828Y87 4358 US Treasury Notes 1,750 02/11/2022 4,014,920.00 0.00 Subtotal 8,950,857.50 0.00 61,088,328.82
Medium Term Notes - Supras
Subtotal 35,189,021.54
Corporate Bonds
Subtotal 51,932,728.34
ORANGE COUNTY POOL (Monthly Summary)
OCP1 01 Orange County Invest Pool 0.439 27,229.36 15,002,157.77 Subtotal 27,229.36 15,002,157.77 20,558,673.37
US Bank Sweep First AM Gov (Monthly Summary)
Subtotal 0.00
Total 13,978,086.86 15,002,157.77 305,138,435.24
Portfolio CITY
AP
Run Date: 04/20/2022 - 13:58 PM (PRF_PM3) 7.3.11
Report Ver. 7.3.11
City of Huntington Beach
Portfolio Management Page 1
Activity Summary
February 2021 through February 2022
Yield to Maturity
Number
Average 360 365 of Investments Average
Balance Equivalent Equivalent Redeemed Term
34 244,848,561.08 1.338 1.356 0 821 471
34 241,726,743.55 1.272 1.290 0 1 812 451
37 245,258,735.71 1.187 1.203 4 833 488
41 272,220,547.80 1.102 1.117 832 529
299,541,338.17 1.096 1.111 965 667
294,084,830.06 1.128 1.144 1,019 705
278,833,182.25 1.133 1,149 1 1,032 711
271,196,912.63 1.112 1.128 3 2 1,045 713
270,161,809.86 1.135 1.150 0 1,080 715
269,384,512.30 1.149 1.165 0 1,112 725
262,845,749.33 1.143 1.159 1,151 774
303,250,810.44 1.165 1.182 1,182 795
63 302,980,501.77 1.218 1.235 1,234 821
46 273,581,406.10 1.168% 1.184% 3 1 1,009 659
Portfolio CITY
AP
Run Date: 04/20/2022 - 13:58 PM (PRF PM4) 7.3.11
Report Ver. 7.3.11
City of Huntington Beach
Portfolio Management Page 1
Interest Earnings Summary
February 28, 2022
February 28Month Ending Fiscal Year To Date
CD/Coupon/Discount Investments:
Interest Collected 236,197.13 2,205,876.06
Plus Accrued Interest at End of Period 741,822.45 741,822.45 Less Accrued Interest at Beginning of Period ( 655,349.31) ( 764,664.92) Less Accrued Interest at Purchase During Period ( 0.00) ( 0.00) Interest Earned during Period 322,670.27 2,183,033.59
Adjusted by Premiums and Discounts -27,917.92 -215,586.78 Adjusted by Capital Gains or Losses 0.00 -21,439.99
Earnings during Periods 294,752.35 1,946,006.82
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 27,229.36 300,331.99
Plus Accrued Interest at End of Period -13,872.40 -13,872.40 Less Accrued Interest at Beginning of Period ( 4,409.90) 74,123.21) Interest Earned during Period 8,947.06 212,336.38
Total Interest Earned during Period 331,617.33 2,395,369.97 Total Adjustments from Premiums and Discounts -27,917.92 -215,586.78 Total Capital Gains or Losses 0.00 -21,439.99
Total Earnings during Period 303,699.41 2,158,343.20
Portfolio CITY
AP
Run Date: 04/20/2022 - 13:58 PM (PRF_PM6) 7.3.11
Report Ver. 7.3.11
State of California
PMIA Pooled Money Investment Account
Market Valuation
2/28/2022
Carrying Cost Plus
Description Accrued Interest Purch. Fair Value Accrued Interest United States Treasury:
Bills $ 46,472,272,106.97 $ 46,429,166,500.00 NA
Notes $ 84,628,471,463.24 83,478,898,500.00 $ 104,971,057.50 Federal Agency:
SBA $ 340,292,826.93 $ 340,771,620.75 143,809.26
MBS-REMICS $ 5,920,047.32 $ 6,126,573.69 26,972.04
Debentures 9,304,930,731.93 $ 9,234,710,500.00 8,465,057.10 Debentures FR EA EA EA EA CA A
Debentures CL 800,000,000.00 782,249,000.00 $ 800,862.00 Discount Notes 23,921,165,555.40 23,894,611,500.00 NA
Supranational Debentures $ 2,069,131,963.01 2,029,098,000.00 $ 6,080,057.50 Supranational Debentures FR $ 50,000,000.00 50,002,000.00 $ 24,568.06 CDs and YCDs FR $
Bank Notes $ : $ :
-
CDs and YCDs 13,985,000,000.00 $ 13,977.462,334.62 $ 8,006,081.95 Commercial Paper 12.359,935,277.68 12,359,096,486.15 NA Corporate
Bonds FF $ $
Bonds $ 425,881,030.93 $ 416,133,480.00 2,466,855.73
Repurchase Agreements $ $
Reverse Repurchase : : $
Time Deposits $ 3,960,500,000.00 3,960,500,000.00 NA
PMIA & GF Loans $ 743,769,000.00 $ 743,769,000.00 NA
TOTAL $ 199,067,270,003.41 | $ 197,702,595,495.21| $ 130,985,321.14 Fair Value Including Accrued Interest $ 197,833,580,816.35 Repurchase Agreements, Time Deposits, PMIA & General Fund loans, and Reverse Repurchase agreements are carried at portfolio book value (carrying cost). atement of Cash Receipts and Disbursements ar
ummary of Cash by Fur
Finance Department
February 2022
Cash Recepts and Disbursements January 2022 February 2022 Receipts
General Fund
Property Tax $ 15,514,563 $ 103,003
Local Sales Tax 3,660,024 5,291,192
Public Safety Sales Tax 223,876 224,304
Transient Occupancy Tax (TOT) 940,430 667,825
Utility Users Tax (UUT) 1,597,233 1,693,719
Other Revenue 5,179,294 5,406,628
Total General Fund Revenue 27,115,419 13,386,671
Total All Other Funds Revenue 10,699,810 12,469,103
Total Receipts 37,815,229 $ 25,855,774
Disbursements
(General Fund
Personnel Services (10,926,377) (10,462,104)
Operating Expenses (2,599,520) (3,399,382)
Capital Expenditures
Non-Operating Expenses (22,505) (949,203)
Total General Fund Disbursements (13,548,502) (14,810,689) Total All Other Funds Disbursements (14,184,315) (15,464,431) Total Disbursements (27,732,817) (30,275,119)
Net Change in Cash Flow 10,082,412 $ (4,119,346)
Summary of Cash by Fund January 2022 February 2022
General Fund - 5 90,557,962 $ 89,133,944
General Fund Other 2,662,390 3,965,689
Capital Projects Funds 24,758,753 23,884,663
Debt Service Funds 33,691,999 34,561,810
Enterprise Funds 75,230,152 75,891,199
Trust and Agency Funds 8,395,096 5,930,345
Internal Service Funds 26,407,301 24,562,351
Special Revenue Funds 55,700,287 55,054,591
General Ledger Cash Balances *$ 317,403,939 $ 312,984,593 * 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 GTON
City of Huntington Beach
City of Huntington Beach 2000 Main St.
Portfolio Management Huntington Beach,
COUNTY CALT Portfolio Summary
March 31, 2022
Par Market Book % of Days to YTM YTM
Investments Value Value Portfolio Term Maturity 360 Equiv. 365 Equiv.
Value
Federal Agency Issues - Coupon 132,225,000.00 127,386,617.25 132,224,201.84 44.12 1,484 1,041 1.229 1.246 Local Agency Investment Funds 5,684,249.01 5,684,249.01 5,684,249.01 1,90 1 1 0.360 0.365 Treasury Securities - Coupon 66,000,000.00 63,898,110.00 66,099, 139.52 22.06 1,171 968 1.129 1.145 Medium Term Notes - Supras 35,000,000.00 33,913,840.00 35,176,565.10 11.74 1,464 865 1.006 1.020 Corporate Bonds 46,684,000.00 46,411,590.53 46,924,011.19 15.66 1,192 413 2.025 2.053 Commercial Paper Disc. -Amortizing 3,000,000.00 2,993,610.00 2,993,399.17 1.00 90 89 0.892 0.904 ORANGE COUNTY POOL 10,575,624.36 10,575,624.36 10,575,624.36 3.53 1 0.456 0.462 299,168,873.37 290,863,641.15 299,677, 190.19 100.00% 1,272 840 1.258 1.276 Investments
Total Earnings March 31 Month Ending Fiscal Year To Date Fiscal Year Ending Current Year 324,815.16 2,483,158.36
Current Budget 100,000.00
Last Year Actual 261,545.23 2,609,546.23 3,403,369.60
Average Daily Balance 303,455,743.14 283,914,206.84
Effective Rate of Return
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 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 03/01/2022-03/31/2022 Portfolio CITY
AP
Run Date: 04/20/2022 - 14:00 PM (PRF_PM1) 7.3.11
Report Ver. 7.3.11
City of Huntington Beach
Portfolio Management Page 1
Portfolio Details - Investments
March 31, 2022
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,008,050.00 5,002,191.21 2,260 AA 2.236 712 03/13/2024 3133EKTG1 4296 Federal Farm Credit Bank 07/01/2019 5,000,000.00 5,013,800.00 4,999,145.83 1,750 1.821 91 07/01/2022 313383QR5 4281 Federal Home Loan Bank 12/20/2018 5,000,000.00 5,070,950.00 5,028,196.40 3.250 2.743 434 06/09/2023 3130AFWX1 4285 Federal Home Loan Bank 02/26/2019 5,000,000.00 5,036,750.00 5,000,000.00 2.550 2.550 424 05/30/2023 3130AKN36 4320 Federal Home Loan Bank 01/15/2021 5,000,000.00 4,666,150.00 4,996,211.11 0.525 0.545 1,385 01/15/2026 3130AKN85 4321 Federal Home Loan Bank 01/20/2021 5,000,000.00 4,626,750.00 4,998,098.61 0.550 0.560 1,390 01/20/2026 3130AKUS3 4322 Federal Home Loan Bank 01/28/2021 5,000,000.00 4,623,850.00 5,000,000.00 0.500 0.500 1,398 01/28/2026 3130AMDL3 4327 Federal Home Loan Bank 05/25/2021 5,000,000.00 4,728,400.00 5,000,000.00 0.800 0.800 1,211 07/25/2025 3130AMJN3 4328 Federal Home Loan Bank 05/26/2021 5,000,000.00 4,723,600.00 5,000,000.00 1.030 1,030 1,516 05/26/2026 3130AMQ54 4331 Federal Home Loan Bank 06/16/2021 5,000,000.00 4,697,500.00 5,000,000.00 0.700 0.700 1,264 09/16/2025 3130AMQ62 4332 Federal Home Loan Bank 06/14/2021 5,000,000.00 4,732,650.00 5,000,000.00 0.625 0.625 1,078 03/14/2025 3130ALEY6 4333 Federal Home Loan Bank 06/10/2021 5,000,000.00 4,699,150.00 5,000,000.00 0.800 0.800 1,433 03/04/2026 3130AMW65 4334 Federal Home Loan Bank 06/30/2021 5,000,000.00 4,762,400.00 5,000,000.00 0.500 0.500 1,004 12/30/2024 3130AMFS6 4335 Federal Home Loan Bank 06/17/2021 5,000,000.00 4,646,350.00 4,974,746.52 0.750 0.873 1,533 06/12/2026 3130AMXJ6 4336 Federal Home Loan Bank 06/30/2021 5,000,000.00 4,768,800.00 5,000,000.00 0.500 0.500 913 09/30/2024 3130AQ3C5 4344 Federal Home Loan Bank 12/02/2021 4,000,000.00 3,879,680.00 4,000,000.00 1.000 1.000 880 08/28/2024 3130AQ5S8 4345 Federal Home Loan Bank 12/30/2021 4,650,000.00 4,488,970.50 4,650,000.00 1.250 1.250 1,186 06/30/2025 3130AQD59 4346 Federal Home Loan Bank 12/30/2021 5,000,000.00 4,847,350.00 5,000,000.00 1.000 1.000 913 09/30/2024 3130AQ7E7 4347 Federal Home Loan Bank 12/30/2021 5,000,000.00 4,820,600.00 5,001,887.65 1,500 1.491 1,551 06/30/2026 3130AQD42 4348 Federal Home Loan Bank 12/28/2021 5,000,000.00 4,840,350.00 5,000,000.00 0.920 0.920 819 06/28/2024 3130AQD59 4349 Federal Home Loan Bank 12/30/2021 5,000,000.00 4,847,350.00 5,000,000.00 1.000 1.000 913 09/30/2024 3130AQS79 4356 Federal Home Loan Bank 02/07/2022 5,000,000.00 4,833,050.00 5,000,000.00 1.375 1.755 1,589 08/07/2026 3130AQT94 4360 Federal Home Loan Bank 03/04/2022 4,575,000.00 4,442,736.75 4,542,545.41 1.600 1.816 1,245 08/28/2025 3137EAEN5 4287 Federal Home Loan Mort Corp 03/08/2019 3,000,000.00 3,027,390.00 3,010,317.59 2.750 2.450 444 06/19/2023 3137EAEN5 4288 Federal Home Loan Mort Corp 03/14/2019 3,000,000.00 3,027,390.00 3,010,777.37 2,750 2.437 444 06/19/2023 3135GOU43 4289 Fed. Natl Mort. Assoc. 03/15/2019 5,000,000.00 5,050,700.00 5,027,902.66 2.875 2.465 529 09/12/2023 3135GA2Z3 4318 Fed. Natl Mort. Assoc. 01/11/2021 3,000,000.00 2,789,850.00 3,002,468.38 0.560 0.537 1,326 11/17/2025 3135G04Z3 4329 Fed. Natl Mort. Assoc. 05/14/2021 5,000,000.00 4,686,050.00 4,979,713.10 0.500 0.628 1.173 06/17/2025 Subtotal and Average 131,786,067.37 132,225,000.00 127,386,617.25 132,224,201.84 1.246 1,041 Local Agency Investment Funds
SYS982 982 Laif City 5,684,249.01 5,684,249.01 5,684.249.01 0.365 0.365 1 Subtotal and Average 5,877,797.40 5,684,249.01 5,684,249.01 5,684,249.01 0.365 1 Portfolio CITY
AP
Run Date: 04/20/2022 - 14:00 PM (PRF_PM2) 73.11
Report Ver. 7.3.11
City of Huntington Beach
Portfolio Management Page 2
Portfolio Details - Investments
March 31, 2022
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
912828YH7 4298 US Treasury Notes 12/05/2019 5,000,000.00 4,882,250.00 4,988,593.98 1.500 AAA 1.595 913 09/30/2024 912828P79 4299 US Treasury Notes 12/05/2019 3,000,000.00 2,996,010.00 2,998,017.44 1.500 AAA 1.574 333 02/28/2023 91282CAB7 4330 US Treasury Notes 05/19/2021 5,000,000.00 4,635,550.00 4,940,022.69 0.250 0.615 1,217 07/31/2025 91282CCW9 4339 US Treasury Notes 09/23/2021 1,000,000.00 926,840.00 993,961.31 0.750 0.890 1,613 08/31/2026 91282CAJO 4340 US Treasury Notes 09/27/2021 5,000,000.00 4,626,150.00 4,918,410.04 0.250 0.735 1,248 08/31/2025 91282CCP4 4341 US Treasury Notes 09/30/2021 5,000,000.00 4,613,650.00 4,931,332.77 0.625 0.950 1,582 07/31/2026 91282CCW9 4342 US Treasury Notes 11/23/2021 5,000,000.00 4,634,200.00 4,885,703.39 0.750 1.285 1,613 08/31/2026 912828YM6 4350 US Treasury Notes 12/31/2021 3,000,000.00 2,926,890.00 3,044,244.87 1.500 0.920 944 10/31/2024 9128284Z0 4351 US Treasury Notes 12/31/2021 5,000,000.00 5,035,950.00 5,274,765.05 2,750 1.103 1,248 08/31/2025 912828S92 4352 US Treasury Notes 01/14/2022 5,000,000.00 4,948,250.00 5,035,737.83 1.250 0.711 486 07/31/2023 912828Y87 4353 US Treasury Notes 01/14/2022 5,000,000.00 4,921,900.00 5,082,998.92 1,750 1.028 852 07/31/2024 9128282D1 4354 US Treasury Notes 01/21/2022 5,000,000.00 4,950,400.00 5,033,028.11 1.375 0.903 517 08/31/2023 91282CCN9 4357 US Treasury Notes 02/02/2022 5,000,000.00 4,874,050.00 4,942,767.69 0.125 0.991 486 07/31/2023 912828Y87 4358 US Treasury Notes 02/11/2022 4,000,000.00 3,937,520.00 4,014,108.59 1.750 1.595 852 07/31/2024 912828D56 4361 US Treasury Notes 03/22/2022 5,000,000.00 4,988,500.00 5,015,446.84 2.375 2.240 867 08/15/2024 Subtotal and Average 62,703,847.91 66,000,000.00 63,898,110.00 66,099,139.52 1.145 968 Medium Term Notes - Supras
45818WBX3 4290 Inter-American Dev. Bank 03/28/2019 4,000,000.00 4,039,560.00 4,029,590.52 2.870 2.270 475 07/20/2023 45818WBY1 4291 Inter-American Dev. Bank 03/28/2019 5,000,000.00 5,055,800.00 5,044,841.73 2.960 2.271 50208/16/2023 45818WCT1 4312 Inter-American Dev. Bank 04/29/2020 6,000,000.00 5,990,880.00 6,051,864.88 1.600 0.550 304 01/30/2023 459058JL8 4319 Int Bk Recon & Development 01/12/2021 5,000,000.00 4,639,150.00 4,997,949.45 0.500 AAA 0.512 1,306 10/28/2025 459056HV2 4323 Intl Bk Recon & Development 04/23/2021 5,000,000.00 4,890,100.00 5,128,359.17 1.500 AAA 0.425 880 08/28/2024 45906M2L4 4324 Int Bk Recon & Development 04/30/2021 5,000,000.00 4,650,200.00 4,958,088.00 0.650 AMA 0.870 1,425 02/24/2026 459058JE4 4338 Int Bk Recon & Development 07/30/2021 5,000,000.00 4,648,150.00 4,965,871.35 0.376 AAA 0.584 1,214 07/28/2025 Subtotal and Average 35,182,401.88 35,000,000.00 33,913,840.00 35,176,565.10 1.020 865 Corporate Bonds
037833DE7 4313 Apple Inc. 04/29/2020 5,000,000.00 5,030,450.00 5,063,059.14 2.400 0.720 287 01/13/2023 14913R2P1 4343 Caterpillar Financial Corp. 12/02/2021 5,000,000.00 4,764,900.00 4,954,137.76 0.600 0.980 896 09/13/2024 166764AH3 4294 Chevron Corp 05/24/2019 5,000,000.00 5,054,200.00 5,036,313.95 3.191 AA 2.528 449 06/24/2023 254687CR5 4300 Disney 12/16/2019 2,875,000.00 2,934,253.75 2,954,615.38 4.000 2.070 548 10/01/2023 459200HG9 4274 IBM Corp 09/28/2018 3,000,000.00 3,004,410.00 2,986,594.36 1.875 A 3.257 122 08/01/2022 67066GAL8 4355 Nvidia 01/24/2022 5,000,000.00 4,794,500.00 4,927,938.43 0.584 1,250 805 06/14/2024 713448CX4 4280 PEPSICO INC 12/21/2018 5,000,000.00 5,011,800.00 4,999,163.37 3.100 3.160 107 07/17/2022 882508BA1 4279 Texas Instruments Inc 12/21/2018 5,000,000.00 5,000,900.00 4,992,938.07 1.850 3.564 44 05/15/2022 Portfolio CITY
AP
Run Date: 04/20/2022 - 14:00 PM (PRF_PM2) 7.3.11
City of Huntington Beach
Portfolio Management Page 3
Portfolio Details - Investments
March 31, 2022
Average Purchase Stated YTM Days to Maturity
CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate S&P 365 Maturity Date Corporate Bonds
904764AW7 4286 Unilever 03/01/2019 5,000,000.00 5,005,500.00 4,997,293.97 2,200 2.802 34 05/05/2022 90331HNV1 4306 US Bank NA Cincinnati 02/21/2020 2,000,000.00 2,026,740.00 2,042,896.07 3.400 AA 1.671 479 07/24/2023 91159HHX1 4325 US Bank NA Cincinnati 04/30/2021 3,809,000.00 3,783,936.78 3,969,060.69 2.400 0.528 851 07/30/2024 Subtotal and Average 47,895,340.99 46,684,000.00 46,411,590.53 46,924,011.19 2.053 413 Commercial Paper Disc. -Amortizing
62479MFV0 4362 MUFG Bank Ltd/NY 03/31/2022 3,000,000.00 2,993,610.00 2,993,399.17 0.890 0.904 89 06/29/2022 Subtotal and Average 96,561.26 3,000,000.00 2,993,610.00 2,993,399.17 0.904 89
ORANGE COUNTY POOL
OCP1 01 Orange County Invest Pool 10,575,624.36 110575,624.36 10,575,624.36 0.462 0.462 Subtotal and Average 10,575,624.36 10,575,624.36 10,575,624.36 0.462 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 303,455,743.14 299,168,873.37 290,863,641.15 299,677,190.19 1.276 840 Portfolio CITY
AP
Run Date: 04/20/2022 - 14:00 PM (PRF_PM2) 7.3.11
City of Huntington Beach
Portfolio Management Page 4
Portfolio Details - Cash
March 31, 2022
Average Purchase Stated YTM Days to
CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate S&P 365 Maturity Average Balance 0.00
Total Cash and Investments 303,455,743.14 299,168,873.37 290,863,641.15 299,677,190.19 1.276 840 Portfolio CITY
AP
Run Date: 04/20/2022 - 14:00 PM (PRF_PM2) 7.3.11
City of Huntington Beach
Portfolio Management Page 1
Activity By Type
March 1, 2022 through March 31, 2022
Stated Transaction Purchases Redemptions
Investment# Issuer Rate Date or Deposits or Withdrawals Balance Preseal Agony Buts Coun
3130AQT94 4360 Federal Home Loan Bank 1.600 03/04/2022 4,541.831.25 0.00 Subtotal 4,541,831.25 0.00 132,224,201.84
Local Agency Investment Funds (Monthly Summary)
SYS982 982 Laif City 0.365 0.00 3,000,000.00
Subtotal 0.00 3,000,000.00 5,684,249.01
Treasury Securities - Coupon
912828D56 4361 US Treasury Notes 2.375 03/22/2022 5,015,625.00 0.00 Subtotal 5,015,625.00 0.00 66,099,139.52
Medium Term Notes - Supras
Subtotal 35,176,565.10
Corporate Bonds
437076BG6 4293 Home Depot Inc 2.625 03/07/2022 0.00 5,001,642.13 Subtotal 0.00 5,001,642.13 46,924,011.19
Commercial Paper Disc. -Amortizing
62479MFV0 4362 MUFG Bank Lta/NY 0.890 03/31/2022 2,993.325.00 0.00 Subtotal 2,993,325.00 0.00 2,993,399.17
ORANGE COUNTY POOL (Monthly Summary)
OCP1 01 Orange County Invest Pool 0.462 17,891.01 10,000.940.02 Subtotal 17,891.01 10,000,940.02 10,575,624.36
US Bank Sweep First AM Gov (Monthly Summary)
Subtotal 0.00
Total 12,568,672.26 18,002,582.15 299,677,190.19
Portfolio CITY
AP
Run Date: 04/20/2022 - 14:00 PM (PRF_PM3) 7.3.11
Report Ver. 7.3.11
City of Huntington Beach
Portfolio Management Page 1
Activity Summary
March 2021 through March 2022
Yield to Maturity Number Number
Average 360 of Investments of Investments
End Balance Equivalent Purchased Redeemed
34 241,726,743.55 1.272 0 1 451
37 245,258,735.71 4 0 488
41 272,220,547.80 4 1 529
47 299,541,338.17 7 1 667
47 294,084,830.06 705
46 278,833,182.25 1 1 711
48 271,196,912.63 3 2 713
46 270,161,809.86 715
47 269,384,512.30 1 0 725
54 262,845,749.33 7 0 774
60 303,250,810.44 4 795
63 302,980,501.77 3 0 821
66 303,455,743.14 3 840
49 277,951,669.00 3 1 687
Portfolio CITY
AP
Run Date: 04/20/2022 - 14:00 PM (PRF_PM4) 7.3.11
Report Ver. 7.3.11
City of Huntington Beach
Portfolio Management Page 1
Interest Earnings Summary
March 31, 2022
March 31Month Ending Fiscal Year To Date
CD/Coupon/Discount Investments:
Interest Collected 274,916.67 2,480,792.73
Plus Accrued Interest at End of Period 798,062.29 798,062.29 Less Accrued Interest at Beginning of Period 741,822.45) ( 764,664.92) Less Accrued Interest at Purchase During Period 0.00) 0.00) Interest Earned during Period 331,156.51 2,514,190.10
Adjusted by Premiums and Discounts -27,335.16 -242,921.94 Adjusted by Capital Gains or Losses 11,357.87 -10,082.12 Earnings during Periods 315,179.22 2,261,186.04
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 17,891.01 318,223.00
Plus Accrued Interest at End of Period -22,127.47 -22,127.47 Less Accrued Interest at Beginning of Period ( -13,872.40) ( 74,123.21) Interest Earned during Period 9,635.94 221,972.32
Total Interest Earned during Period 340,792.45 2,736,162.42 Total Adjustments from Premiums and Discounts -27,335.16 -242,921.94 Total Capital Gains or Losses 11,357.87 -10,082.12
Total Earnings during Period 324,815.16 2,483,158.36
Portfolio CITY
AP
Run Date: 04/20/2022 - 14:00 PM (PRF_PM6) 7.3.11
Report Ver. 7.3.11
State of California
Pooled Money Investment Account
Market Valuation
3/31/2022
Carrying Cost Plus
Description Accrued Interest Purch. Amortized Cost Fair Value Accrued Interest United States Treasury:
Bills $ 46,438,364,881.91 $ 46,462,802,161.83 $ 46,366,792,000.00 NA Notes $ 91,137,412,378.62 $ 91,123,228,383.84 89,180,593,000.00 $ 117,562,034.00 Federal Agency:
SBA $ 329,037,520.12 $ 329,037,520.12 $ 329,497,596.82 $ 138,923.93 MBS-REMICS $ 5,703,902.13 $ 5,703,902.13 $ 5,844,529.41 $ 25.924.77 Debentures $ 8,923,276,985.63 $ 8,922,590,857.86 $ 8,805,155,700.00 $ 8,519,115.80 Debentures FR $ $ $
Debentures CL $ 700,000,000.00 $ 700,000,000.00 $ 672,254,000.00 $ 905,027.00 Discount Notes $ 24,949,939,687.37 $ 24,960,712,979.03 1$ 24,906,670,000.00 NA Supranational Debentures $ 2,065,258,478.33 $ 2,065,258,478.33 $ 2,004,805,500.00 I$ 5,592,972.00 Supranational Debentures FR I$ - $ $ $
CDs and YCDs FR $ $ $ $ -
:
Bank Notes $ $ $
CDs and YCDs $ 15,335,000,000.00 $ 15,335,000,000.00 $ 15,320,961,230.66 $ 9,972,225.03 Commercial Paper $ 12,697,608,013.77 12,705,537,708.34 $ 12,693,180,684.70 NA Corporate:
Bonds FR $ - $ $
Bonds $ 424,349,911.03 $ 424,107,855.47 $ 409,797,860.00 $ 1,877,396.95 Repurchase Agreements $ $ - $ $ -
Reverse Repurchase $ - $ - $ $
Time Deposits $ 4,135,000,000.00 $ 4,135,000,000.00 $ 4,135,000,000.00 NA PMIA & GF Loans $ 756,663,000.00 $ 756,663,000.00 $ 756,663,000.00 NA TOTAL $ 207,897,614,758.91 $ 207,925,642,846.95 $ 205,587,215,101.59 $ 144,593,619.48 Fair Value Including Accrued Interest $ 205,731,808,721.07 Repurchase Agreements, Time Deposits, PMIA & 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.988753538).
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,775,070.77 or $20,000,000.00 x 0.988753538.
Statement of Cash Receipts and Disbursements and
Summary of Cash by Fund
Finance Department
March 2022
Cash Receipts and Disbursements February 2022 March 2022 Receipts
General Fund
Property Tax $ 103,003 $ 4,542,358
Local Sales Tax 5,291,192 3,601,263
Public Safety Sales Tax 224,304 312,313
Transient Occupancy Tax (TOT) 667,825 852,125
Utility Users Tax (UUT) 1,693,719 1,775,334
Other Revenue 5,406,628 6,235,951
Total General Fund Revenue 13,386,671 17,319,345
Total All Other Funds Revenue 12,469,103 15,001,011
Total Receipts 25,855,774 $ 32,320,356
Disbursements
General Fund
Personnel Services (10,462,104) (12,230,806)
Operating Expenses (3,399,382) (3,213,471)
Capital Expenditures
Non-Operating Expenses (949,203) (4,208)
Total General Fund Disbursements (14,810,689) (15,448,485) Total All Other Funds Disbursements (15,464,431) (16,109,562) Total Disbursements (30,275,119) (31,558,048)
Net Change in Cash Flow $ (4,419,346) $ 762,308
Summary of Cash by Fund February 2022 March 2022
General Fund $ 89,192,910 $ 91,063,770
General Fund Other 3,971,801 3,927,496
Capital Projects Funds 23,934,208 23,481,033
Debt Service Funds 34,608,733 35,051,475
Enterprise Funds 76,069,697 77,382,316
Trust and Agency Funds 6,074,678 5,408,120
Internal Service Funds 24,622,896 23,856,246
Special Revenue Funds 55,121,931 54,188,708
General Ledger Cash Balances * $ 313,596,854 $ 314,359,162 * Total cash will differ from investment portfolio total due to outstanding checks and/or other timing differences.