Agenda Item A.3
CPMS CONSENT CALENDAR
Meeting Date: April 2, 2024
TO: Mayor and Councilmembers
SUBMITTED BY: Luke Rioux, Finance Director
PREPARED BY: Ryan Schwarz, Accountant
SUBJECT: Acceptance of the February 2024 Investment Transaction Report RECOMMENDATION:
Accept the investment transaction report for the month of February 2024.
BACKGROUND:
Transmitted herewith is the investment transaction report for the month of February 2024.
DISCUSSION:
Investment Transaction Report
As of February 29, 202 4, the City‘s investment portfolio totaled $ 79,759,994.40. The City’s weighted average yield in February was 3.491%.
Attachment 1 contains the Investment Transaction Report, which includes the Investment Activity and Interest Report, Summary of Cash and Investments, and Investment Portfolio detail as of February 29, 2024.
FISCAL IMPACTS:
As of February 29, 2024, the investment portfolio is in compliance with all State laws and the City’s Investment Policy. There are sufficient funds available to meet the City’s expenditure requirements for the next six months.
LEGAL REVIEW BY: Megan Garibaldi, City Attorney
APPROVED BY: Robert Nisbet, City Manager
ATTACHMENTS:
1. February 2024 Investment Transaction Report
1 ATTACHMENT 1
Investment Transaction Report February 2024
2 City of Goleta
Investment Portfolio
February 29, 2024
Attachment 1
INVESTMENT ACTIVITY INVESTMENT INCOME
PURCHASES OR DEPOSITS POOLED INVESTMENTS
2/15/2024 UNITED STS TREAS BILLS - Treasury Note 5,124,708.75$ Interest Earned on Investments 225,873.18 $ Total
Total 5,124,708.75 $
SALES, MATURITIES, CALLS OR WITHDRAWALS
2/15/2024 UNITED STS TREAS BILLS - Treasury Note 5,130,000.00$ Total 5,130,000.00$
ACTIVITY TOTAL 10,254,708.75$ INCOME TOTAL 225,873.18 $ 3 City of Goleta
Investment Portfolio
February 29, 2024
Attachment 1
ENDING BALANCE AS OF January 31, 2024
Account Description
Book
Value
Market
Value
Percent of
Portfolio
Weighted Yield to
Maturity
Average
Days to
Maturity
Checking Accounts 1,976,656.16 $ 1,976,656.16 $ 2.446% 0.000% 1 Money Market Accounts 25,265,779.52 25,265,779.52 $ 31.262% 3.915% 1 Local Agency Investment Funds 43,378,674.09 43,098,583.67 $ 53.673% 3.590% 1 Certificates of Deposit 5,200,000.00 5,065,264.68 $ 6.434% 2.219% 1797 United States Treasury Bill 4,999,538.83 5,119,534.80 $ 6.186% 5.366% 182 SUBTOTAL 80,820,648.60$ 80,525,818.83$ 100.000% 3.625% 116.493 503,500.00$ 505,569.49 $ 1
Held by Fiscal Agent (BNY Mellon) 899.57 899.57 $ 1 SUBTOTAL 504,399.57$ 506,469.06
Totals 81,325,048.1 7$ 81,032,287.89$
Total Cash and Investments 81,325,048.17$
NET CASH AND INVESTMENT ACTIVITY FOR February 2024
(1,565,053.77)$
ENDING BALANCE AS OF February 29, 2024
Account Description
Book
Value
Market
Value
Percent of
Portfolio
Weighted Yield to
Maturity
Average
Days to
Maturity
Checking Accounts 4,295,073.42 $ 4,295,073.42 $ 5.419% 0.000% 1 Money Market Accounts (1) 21,257,138.57 21,257,138.57 26.821% 3.915% 1 Local Agency Investment Funds (2) 43,378,674.09 43,098,583.67 54.733% 3.590% 1 Certificates of Deposit 5,200,000.00 5,065,523.34 6.561% 2.219% 1814 United States Treasury Bill $5,124,708.75 5,130,352.50 6.466% 5.113% 175 SUBTOTAL 79,255,594.83$ 78,846,671.50$ 100.000% 3.491% 131.216 Held by Fiscal Agent (US Bank - PARS) 503,500.00$ 513,508.76$ 1 Held by Fiscal Agent (BNY Mellon) 899.57 899.57 1 SUBTOTAL 504,399.57$ 514,408.33$
Totals 79,759,994.4 0$ 79,361,079.83$
Total Cash and Investments 79,759,994.40$
Notes:
(1)
(2)
Community West Bank serves as the City's primary banking institution. Interest earnings are guaranteed at a minimum rate 0.7098% per banking agreement for the money market account. The rate may be adjusted to match the higher of the Pooled Money Investment Account (PMIA) or quarterly Local Agency Investment Fund (LAIF) apportionment rate. All deposits held are required to be fully collateralized by State law. The City has a written collateralization agreement with Community West Bank to ensure the safety of public funds and utilizes an irrevocable letter of credit through the Federal Home Loan Bank of San Francisco.
For reporting purposes the LAIF yield displayed is the apportionment rate available at the time of preparing this report. The apportionment rate is the actual interest earned from LAIF and is based on the prior three-month average of the PMIA effective yield, net of administrative costs. As of FY 17/18 the quarterly apportionment rate includes interest earned on the CalPERS Supplemental Pension Payment loan pursuant to Government Code 20825 (c)(1) and in FY 18/19 interest earned on Wildfire Fund loan pursuant to Public Utility Code 3288 (a), which are not reflected in the PMIA monthly effective yield, due to the structure of the loan.
4 City of Goleta
Investment Portfolio
February 29, 2024
Attachment 1
PURCHASE MATURITY DAYS TO STATED YIELD AT FACE BOOK MARKET** DATE DATE MATURITY RATE 365 VALUE VALUE VALUE
CHECKING ACCOUNTS
COMMUNITY WEST BANK GENERAL CHKING ACCT - - 1 0 0.000% 3,109,276.06 3,109,276.06 3,109,276.06 COMMUNITY WEST BANK GENERAL REV ACCT 1 0 0.000% 638,490.97 638,490.97 638,490.97 COMMUNITY WEST BANK PAYROLL CHKING ACCT 1 0 0.000% 359,418.72 359,418.72 359,418.72 PERSHING - SAFE KEEPING ACCT 0 0.000% 187,887.67 187,887.67 187,887.67 Subtotal, Checking Accounts 0.000% 0.000% 4,295,073.42$ 4,295,073.42 $ 4,295,073.42 $
MONEY MARKET ACCOUNTS
COMMUNITY WEST BANK MMA - - 1 3.9148% 3.9148% 21,257,138.57 21,257,138.57 21,257,138.57 Subtotal, MMA Account 1 3.9148% 3.9148% 21,257,138.57 $ 21,257,138.57 $ 21,257,138.57 $
LOCAL AGENCY INVESTMENT FUND
LOCAL AGENCY INVESTMENT FUND - - 1 3.590% 3.590% 43,378,674.09 43,378,674.09 43,098,583.67 Subtotal, LAIF 1 3.590% 3.590% 43,378,674.09 $ 43,378,674.09 $ 43,098,583.67 $
CERTIFICATES OF DEPOSIT
CAPITAL ONE NA 8/7/2019 8/7/2024 1,827 2.250% 2.250% 247,000.00 247,000.00 243,798.88 14042RMU2 CAPITAL ONE BANK USA NA 8/7/2019 8/7/2024 1,827 2.250% 2.250% 247,000.00 247,000.00 243,798.88 14042TBQ9 ENERBANK USA 8/7/2019 8/7/2024 1,827 2.150% 2.150% 247,000.00 247,000.00 243,692.67 29278TKJ8 MORGAN STANLEY BANK NA 8/8/2019 8/8/2024 1,827 2.200% 2.200% 247,000.00 247,000.00 243,727.25 61690UJX9 MORGAN STANLEY PVT BANK 8/8/2019 8/8/2024 1,827 2.200% 2.200% 247,000.00 247,000.00 243,727.25 61760AS75 LIVE OAK BKG CO WILMINGTON NC 2/12/2020 8/12/2024 1,643 1.700% 1.700% 247,000.00 247,000.00 243,186.32 538036HY3 WASHINGTON FEDERAL BK 8/23/2019 8/23/2024 1,827 2.050% 2.050% 249,000.00 249,000.00 245,317.29 938828BJ8 WELLS FARGO BK N A SIOUX FALLS S D 1/29/2020 1/29/2025 1,827 1.950% 1.950% 247,000.00 247,000.00 240,165.51 949763T30 RAYMOND JAMES BK NATL ASSN ST PETERSBURG 2/14/2020 2/14/2025 1,827 1.750% 1.750% 247,000.00 247,000.00 239,434.39 75472RBB6 ENCORE BK LITTLE ROCK ARK CTF DEP 4/25/2020 3/25/2025 1,795 1.150% 1.150% 249,000.00 249,000.00 239,042.49 29260MAV7 POPPY BK SANTA ROSA CA CTF DEP 4/27/2020 3/27/2025 1,795 1.100% 1.100% 249,000.00 249,000.00 238,865.70 73319FAK5 AMERICAN EXPRESS NATL BK BROKERED INTL CTF3/31/2020 3/31/2025 1,826 1.550% 1.550% 248,000.00 248,000.00 239,059.60 02589AB68 PACIFIC ENTERPRISE BK IRVINE CA CTF DEP 3/31/2020 3/31/2025 1,826 1.150% 1.150% 249,000.00 249,000.00 238,922.97 694231AC5 STATE BK INDIA NEW YORK NY CTF DEP 4/29/2020 4/29/2025 1,826 1.600% 1.600% 248,000.00 248,000.00 238,603.28 856285TF8 ALLY BK SANDY UTAH CRF ACT/365 6/2/2022 6/2/2027 1,826 3.100% 3.100% 249,000.00 249,000.00 241,154.01 02007GSH7 TOYOTA FINANCIAL SAVINGS BANK HEND NV 10/14/2021 10/14/2026 1,826 1.050% 1.050% 247,000.00 247,000.00 226,718.83 89235MLU3 UBS BANK USA SALT LAKE CITY UT 10/27/2021 10/27/2026 1,826 1.050% 1.050% 249,000.00 249,000.00 228,265.77 90348JV56 DISCOVER BK GREENWOOD DEL 6/1/2022 6/1/2027 1,826 3.200% 3.200% 245,000.00 245,000.00 237,654.90 254673F76 FIRST TECHNOLOGY FED CREDIT UNION #19976 8/5/2022 8/5/2027 1,826 3.650% 3.650% 247,000.00 247,000.00 242,976.37 33715LEB2 DORT FINANCIAL CREDIT UNION 6/20/2023 6/20/2028 1,827 4.500% 4.500% 247,000.00 247,000.00 251,026.10 25844MBB3 BAXTER CREDIT UNION VERNON HILLS 8/22/2023 8/22/2028 1,827 5.000% 5.000% 248,000.00 248,000.00 256,384.88 07181JBB9 Subtotal, Certificates of Deposit 1,814 2.219% 2.219% 5,200,000.00$ 5,200,000.00$ 5,065,523.34$
US TREASURY SECURITIES - DISCOUNT
UNITED STS TREAS BILLS 2/15/2024 8/8/2024 175 5.113% 5.113% 5,250,000.00 5,124,708.75 5,130,352.50 TSRYS5626537 Subtotal, US Treasuries 1,989 5.113% 5.113% 5,250,000.00$ 5,124,708.75$ 5,130,352.50$ Total 79,380,886.08$ 79,255,594.83$ 78,846,671.50$ Held By Fiscal Agent (US Bank - PARS)
PUBLIC AGENCY RETIREMENT SERVICES (PARS)
- OPEB - Moderate Index Plus 2/4/2022 1 -0.940% 333,500.00 333,500.00 340,129.44
PUBLIC AGENCY RETIREMENT SERVICES (PARS)
- PENSION - Moderate Index Plus 2/4/2022 1 -0.940% 170,000.00 170,000.00 173,379.32 Subtotal 1 -0.940% 503,500.00 $ 503,500.00 $ 513,508.76 $ Total 503,500.00$ 503,500.00 $ 513,508.76 $ Held By Fiscal Agent (BNY Mellon
)
Holding Account 1 899.57 899.57 899.57 Total 899.57$ 899.57 $ 899.57 $ Grand Total 79,885,285.65$ 79,759,994.40 $ 79,361,079.83 $ Notes:
* Comments for Certificates of Deposit represent the CUSIP Number (Committee on Uniform Securities Identification Procedures). * *Market Value on Certificates of Deposit have been obtained from the City's safekeeping agent, Pershing LLC, a subsidiary of The Bank of New York Mellon Corporation. Market value disclosure is for informational purposes only.
City policy is to hold all investments to maturity; therefore, any unrealized gain or loss reflected between the book value and market value of an investment will not be realized. **Market Value on U.S. Bank, Trustee for PARS: Account balances are inclusive of Trust Administration, Trustee and Investment Management fees.
DESCRIPTION COMMENTS *
5