1 INVESTMENT REPORT
For the Quarter Ending June 30, 2024
City of Hercules, California
CITY OF HERCULES
FINANCE DEPARTMENT
111 CIVIC DRIVE
HERCULES, CALIFORNIA 94547-1771
PHONE: 510-799-8200
September 10, 2024
Honorable Mayor and City Council:
I verified that this investment portfolio, as of June 30, 2024, conforms with all state laws and City’s investment policy. The City’s expenditures requirements for the next months are covered by anticipated revenues from City operations and liquidity from cash on deposit.
As of June 30, 2024, the City has sufficient funds to meet its expenditure requirements for the next six months.
Sincerely,
Edwin Gato
Finance Director/City Treasurer
City of Hercules, California
Investment Portfolio Summary Report
For the Quarter Ended June 30, 2024
Book % of Average Market
Value Total Yield Value
Cash on Hand $2,005 $2,005
Cash on Deposit 7,231,995 7,231,995
Total Cash on Hand 7,234,000 9.61% 0.47% 7,234,000 Local Agency Investment Fund (LAIF) 60,430,628 80.25% 4.48% 60,208,004 Irrevocable Trust (Pension) 2,391,824 3.18% 0.91% 2,391,824 Irrevocable Trust (OPEB) 2,888,601 3.84% 0.91% 2,888,601 Investments with Bond Trustees 2,353,663 3.13% 4.16% 2,353,663 Total Portfolio $75,298,716 100.00% 2.51% $75,076,092
Amount over (under) Market Value vs. Book Value ($222,624) % of Portfolio -0.30%
Investments by Type
Cash on Hand
LAIF
Irrevocable Trust
(Pension)
Irrevocable Trust
(OPEB)
Investments with
Trustees
City of Hercules
Detail for Investment Portfolio Summary Report
For the Quarter Ended June 30, 2024
(DAYS)
BOOK PURCHASE MATURITY LIFE TO REMAINING PAR MARKET
DESCRIPTION VALUE RATE YIELD DATE DATE MATURITY LIFE VALUE VALUE
CASH ON HAND
PETTY CASH 2,005.00 0.00% 0.00% 2,005.00 $2,005.00
CASH IN BANK
MECHANICS BANK - GENERAL CHECKING 2,854,759.75 0.00% 0.00% 2,854,759.75 2,854,759.75 MECHANICS BANK - HERCULES RDA 4,316,704.86 0.00% 0.00% 4,316,704.86 4,316,704.86 MECHANICS BANK - PD ASSET SEIZURE 38,797.98 0.00% 0.00% 38,797.98 38,797.98 CalTRUST 21,732.72 0.47% 0.47% 4/1/2024 6/30/2024 90 - 21,732.72 21,732.72 TOTAL AND AVERAGES 7,231,995.31 0.47% 0.47% 90 - 7,231,995.31 7,231,995.31
LOCAL AGENCY INVESTMENT FUND (LAIF)
LAIF 60,430,628.02 4.48% 4.48% 4/1/2024 6/30/2024 90 - 60,430,628.02 60,208,004.12
IRREVOCABLE TRUST (PENSION/OPEB)
US BANK MUTUAL (PARS-OPEB) 2,888,601.03 0.91% 0.91% 4/1/2024 6/30/2024 90 - 2,888,601.03 2,888,601.03 US BANK MUTUAL (PARS-PENSION) 2,391,823.73 0.91% 0.91% 4/1/2024 6/30/2024 90 - 2,391,823.73 2,391,823.73 TOTAL AND AVERAGES 5,280,424.76 0.91% 0.91% 90 - 5,280,424.76 5,280,424.76
INVESTMENTS WITH BOND TRUSTEES
WEBSTER BANK (STERLING NATIONAL BANK
ESCROW) 118,737.26 0.25% 0.25% 4/1/2024 6/30/2024 90 - 118,737.26 118,737.26 THE BANK OF NEW YORK (BNY) JM 05 1 RESERVE
FUND 2019 55,797.47 0.00% 0.00% 4/1/2024 6/30/2024 90 - 55,797.47 55,797.47
THE BANK OF NEW YORK (BNY) MELLON TRUST
HERCULES PFA WW INTEREST ACCT 21 A 2,887.50 0.00% 0.00% 4/1/2024 6/30/2024 90 - 2,887.50 2,887.50
THE BANK OF NEW YORK (BNY) MELLON TRUST
(HERCULES PFA 09 REVENUE FUND) 652,853.60 5.14% 5.14% 4/1/2024 6/30/2024 90 - 652,853.60 652,853.60
THE BANK OF NEW YORK (BNY) MELLON TRUST
(HERCULES PFA 09 DEBT SERV PRIN ACCT) 278,955.31 5.14% 5.14% 4/1/2024 6/30/2024 90 - 278,955.31 278,955.31
THE BANK OF NEW YORK (BNY) MELLON TRUST
(HERCULES PFA 09 DEBT SERV INT ACCT) 319,648.84 5.14% 5.14% 4/1/2024 6/30/2024 90 - 319,648.84 319,648.84
THE BANK OF NEW YORK (BNY) MELLON TRUST
(HERCULES PFA 09 RESERVE FD) 920,215.00 5.14% 5.14% 4/1/2024 6/30/2024 90 - 920,215.00 920,215.00
THE BANK OF NEW YORK (BNY) MELLON TRUST
(HERCULES 2020 INT FD) 4,567.80 0.00% 0.00% 4/1/2024 6/30/2024 90 - 4,567.80 4,567.80 TOTAL AND AVERAGES 2,353,662.78 4.16% 4.16% 90 - 2,353,662.78 2,353,662.78 TOTAL INVESTMENT REPORT $75,298,715.87 2.51% 2.51% 90 - $75,298,715.87 $75,076,091.97 City of Hercules, California
Investment Portfolio Summary Report
For the Quarter Ended June 30, 2024
% of
Cash Description Book Value Total
Bond Trustee $2,353,663 3%
Irrevocable Trust 5,280,425 7%
Restricted 37,990,211 50%
General Fund 27,796,757 37%
Internal Service Funds 1,877,660 2%
Total, Book Value $75,298,716 100%
Restricted:
Wastewater 17,297,344
Successor Housing 5,660,800
Development Impact Fees 3,360,134
Successor Agency 6,085,004
Landscape & Lighting 1,517,677
Gas Tax & Measure J "Street" 1,222,305
Solid Waste 837,372
SB1 RMRA 1,017,172
Agency Fund 748,308
Asset Seizure 221,459
Other 22,636
37,990,211
Bond Trustee 3% Irrevocable Trust 7%Restricted 50%General Fund 37%Internal Service Funds 3%Cash by Fund June 4.480
May 4.332
April 4.272
March 4.232
February 4.122
January 4.012
PMIA Average Life(1): 217
LAIF Fair Value Factor(1): 0.996316042
PMIA Daily(1): 4.52
PMIA Quarter to Date(1): 4.36
LAIF Apportionment Rate(2): 4.55
LAIF Earnings Ratio(2): 0.00012419067099490
LAIF Administrative Cost(1)*: TBD
Treasuries
56.98%
Agencies
23.22%
Certificates of
Deposit/Bank Notes
9.18%
Time
Deposits
3.14%
Commercial
Paper
6.84%
Corporate
Bonds
0.42%
Loans
0.22%
Notes: The apportionment rate includes interest earned on the CalPERS Supplemental Pension Payment pursuant to Government Code 20825 (c)(1) and interest earned on the Wildfire Fund loan pursuant to Public Utility Code 3288 (a). *The percentage of administrative cost equals the total administrative cost divided by the quarterly interest earnings. The law provides that administrative costs are not to exceed 5% of quarterly EARNINGS of the fund. However, if the 13-week Daily Treasury Bill Rate on the last day of the fiscal year is below 1%, then administrative costs shall not exceed 8% of quarterly EARNINGS of the fund for the subsequent fiscal year.
Source:
(1) State of California, Office of the Treasurer
(2) State of Calfiornia, Office of the Controller
PMIA Average Monthly
Effective Yields(1)
PMIA/LAIF Performance Report
as of 6/30/2024
Daily rates are now available here. View PMIA Daily Rates Quarterly Performance
Quarter Ended 06/30/24
Chart does not include $1,943,000.00 in mortgages, which equates to 0.001%. Percentages may not total 100% due to rounding.
Pooled Money Investment Account
Monthly Portfolio Composition (1)
6/30/24
$162.3 billion