Agenda Item No. 08
CITY OF YUCAIPA
AGENDA REPORT
TO: Honorable Mayor and City Council
FROM: Chris Mann, City Manager/Treasu rh%�
Phil White, Director of Financelkl�
FOR: City Council Meeting of September 23, 2024
SUBJECT: Monthly Treasurer Reports July 2024 & August 2024 RECOMMENDATION:
That the City Council receive and file the Monthly Treasurer Reports for July 2024 & August 2024.
BACKGROUND/DISCUSSION:
To comply with the requirements of California Government Code Section 53607 and the recommendation of California Government Code Section 53646, a treasurer's report is submitted to Council monthly.
It is the responsibility of the Finance staff to develop the Monthly Treasurer's Report in a timely manner for review by the City Manager/Treasurer, and ultimately the City Council. It is the function of the Treasurer to deposit and invest funds in accordance with the Investment Policy of the City of Yucaipa to achieve the stated objectives of preservation of capital, liquidity, and return on investment. The purpose of the Monthly Treasurer's Report is to provide the City Council with a snapshot of the City's investment portfolio. The balances included in the Monthly Treasurer's Report represent the market value of the City's investments.
The City utilizes the Monthly Treasurer's Report as one tool to monitor fiscal performance. The City's net position or fund balance (equity) is comprised of assets less liabilities. The portfolio is just one component of assets. The portfolio balance will fluctuate based on investment performance (yield) as well as timing of cash inflows (revenue collection) and cash outflows (expenditure payments).
The yield for the investment held with the Local Agency Investment Fund (LAIF) was 4.516% in July and 4.579% in August.
While the City does not have outstanding debt related to bond issuances, the City acts in a fiduciary capacity for the Successor Agency to the former Redevelopment Agency and the Chapman Heights
Community Facilities District, both of which maintain outstanding bonds. The City pools cash and investments of all funds, except for assets related to the bond issuances of the Successor Agency and Community Facilities District which are required to be held in separate accounts with fiscal agents in accordance with the bond indentures.
As required by the Investment Policy, the attached Monthly Treasurer's Report includes a certification that (1) All investment actions executed since the last report have been made in full compliance with the Investment Policy; and (2) the City will meet its expenditure obligations for the next six months.
FISCAL IMPACT:
There is no fiscal impact.
Attachments:
1. Treasurer Report — July
2. Treasurer Report — August
3. Treasurer Managed Portfolio Summary — July
4. Treasurer Managed Portfolio Summary — August
5. LAIF Quarterly Interest Statement — July
6. LAIF Quarterly Interest Statement — August
7. Wells Fargo Operating Account — July
8. Wells Fargo Operating Account — August
9. Investments with Fiscal Agent Summary — July
10. Investments with Fiscal Agent Summary — August
ATTACHMENT 1
City of Yucaipa
Monthly Treasurer's Report - July 31, 2024
June 2024
July 2024
Institution/Investment Type
Balance
Balance
Held in U.S. Bank Custody Account
$
39,064,769.08
$
39,407,898.60
Local Agency Investment Fund (LAIF)
$
17,412,513.25
$
12,584,694.41
City Checking Account
$
5,749,286.17
$
4,666,791.72
Petty Cash / Change Drawers
$
2,750.00
$
2,750.00
Total Funds Under Control of the City
$
62,229,318.50
$
56,662,134.73
Funds with Fiscal Agents:
Bank of New York Mellon (Chapman Heights)
CFD 98-1 - Invesco Govt Agency Private 1903
$
281,021.38
$
1,805,304.69
CFD 98-1 - Cash
$
12,068.98
$
12,068.98
$
293,090.36
$
1,817,373.67
U.S. Bank (Successor Agency)
RDA 1998 TAB - Blackrock Instl Funds
$
60.17 $
35,669.37
RDA 1998 TAB - LAIF
$
46,907.65
$
47,932.81
RDA 2004 TAB - Blackrock Instl Funds
$
161,349.13
$
507,572.29
RDA 2010 TAB - Blackrock Instl Funds
$
374,331.82
$
375,924.89
$
582,648.77
$
967,099.36
Total Funds with Fiscal Agents
$
1,168,829.49
$
2,784,473.03
Grand Total
$
63,398,147.99
$
59,446,607.76
1. All investment actions executed since the last report have been made in full compliance with the Investment Policy; and
2. The City will meet its expenditure obligations for the next six months.
Treasurer:
�—
Sign / Date
ATTACHMENT 2
00206301
65- -01-B -82-219-01
0101-11-04304-01
embank.
CITY OF YUCAIPA - TREASURER MANAGED Page 5 of 39
ACCOUNT Period from July 1, 2024 to July 31, 2024
:�1►SSET'.SCI�VI.1111�1�2Y' ..:... ... _:::.......; ..... 07/31/2024
% OF
ASSETS
MARKET VALUE
MARKET
Cash And Equivalents
501,552.43
1.27 U.S. Government Issues
35,474,943.21
89.45 Corporate Issues
2,998,650.66
7.56 Foreign Issues
243,245.80
0.61 Municipal Issues
189,506.50
0.48 Total Assets
39,407,898.60
99.37 Accrued Income
249,699.79
0.63 Grand Total
39.657.598.39
100.00
BONDS 98.1
EQUIV & ACCR 1.90%
ATTACHMENT 3
8/6/24, 4:02 PM
LAIF Regular Monthly Statement
California State treasurer
Fiona Ma, cPa
Local Agency Investment Fund
P.O. Box 942809
Sacramento, CA 94209-0001
(916) 653-3001
CITY OF YUCAIPA
TREASURER
34272 YUCAIPA BLVD.
YUCAIPA, CA 92399
Account Number:
July 2024 Statement
August 06, 2024
LAIF Home
PMIA Average Monthly_
Yields
Tran Type Definitions
Web
Tran
Effective Transaction
Confirm
Confirm
Date Date
Type
Number
Number Authorized Caller
Amount
7/15/2024 7/12/2024
QRD
1757135
N/A SYSTEM
172,181.16
7/15/2024 7/11/2024
RW
1755014
1715474 PHILLIP WHITE
-2,000,000.00
7/22/2024 7/18/2024
RW
1757591
1718044 PHILLIP WHITE
-1,000,000.00
7/29/2024 7/25/2024
RW
1757867
1718319 PHILLIP WHITE
-2,000,000.00
Account Summary_
Total Deposit:
172,181.16 Beginning Balance:
17,412,513.25
Total Withdrawal:
-5,000,000.00
Ending Balance:
12,584,694.41
https://Iaifms.treasurer.ca.gov/RegularStatement.aspx 1/1
ATTACHMENT 4
Analyzed Business Checking - PF
Account number: ■ July 1, 2024-July 31, 2024 ■ Page 1 of 8
CITY OF YUCAIPA
GENERAL OPERATING ACCOUNT
34643 YALE DR
YUCAIPA CA 92399-6860
Account summary
Analyzed Business Checking - PF
Questions?
Call your Customer Service Officer or Client Services
1-800-AT WELLS (1-800-289-3557)
5:00 AM TO 6:00 PM Pacific Time Monday - Friday
Online: wellsfargo.com
Write: Wells Fargo Bank, N.A. (114)
P.O. Box 6995
Portland, OR 97228-6995
Accountnumber Beginning balance Total credits Total debits Ending balance $5,749,286.17 $7,319,533.19-$8,402,027.64 $4,666,791.72 Credits
Deposits
Effective Posted
date date
Amount
Transaction detail
07/09
3,375.00
Deposit
07/09
4,568.23
Deposit
07/12
140.00
Deposit
07/17
10.00 Deposit
07/19
100.00
Deposit
07/24
150.00
Deposit
07/25
1,300.00
Deposit
07/30
10,060.00
Deposit
07/31
100.00
Deposit
$19,803.23 Total deposits
Electronic deposits/bank credits
Effective Posted
date date
Amount
Transaction detail
07/01
1.00 American Express Settlement 240628 5647699297 General Bi115647699297 07/01
109.00
07/01 Bankcard Deposit-0328149721
07/01
353.00
07/01 Bankcard Deposit-0328149721
07/01
492.00
07/01 Bankcard Deposit-0328149721
07/01
2,083.32
Stripe Transfer St-Y6A1 F1 K71-31-18 City of Yucaipa
07/01
4,007.00
Paymentech Transfer 240701 Tyler0005037697 Eg Css CA Yucaipa Comm 07/01
4,502.00
Paymentech Transfer 240701 Tyler0005037661 Mun Csh CA Yucaipa Gen 07/01
9,495.00
Desktop Check Deposit
07/01
67,387.91
Desktop Check Deposit
07/01
1,447.45
ZBA Funding Account Transfer From 4241875095
07/02
329.00
Desktop Check Deposit
02010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
(114)
SheetSeq = 0049722
Sheet 00001 of 00008
ATTACHMENT 5
City of Yucaipa
Investment with Fiscal Agent Summary
7/31/2024
Bank of New York Mellon CFD 98-1
324812 Special Acct - Invesco Govt Agency Private 1903
$
15.66 324813 Interest Acct - Invesco Govt Agency Private 1903 $
314.85
880552 Escrow Acct
$
281,021.38
703129 COI Acct - Cash
$
12,068.98
703130 Special Tax Acct - Invesco Govt Agency Private 1903 $
1,523,375.00
880553 COI Acct - Invesco Govt Agency Private 1903
$
74.80 880554 Reserve Acct - Invesco Govt Agency Private 1903 $
47.83 880555 Admin Exp Acct - Invesco Govt Agency Private 1903 $
455.17
$
1,817,373.67
U.S. Bank
RDA 1998 TAB
6711616700 Project Acct - Blackrock Instl Funds
$
0.24 6711616701 Interest Acct - Blackrock Instl Funds
$
35,624.80
6711616702 Principal Acct - Blackrock Instl Funds
$
31.42 6711616703 Sinking Acct - Blackrock Instl Funds
$
12.70 6711616704 Reserve Acct - Blackrock Instl Funds
$
0.21 $
35,669.37
6711616704 Reserve Acct - LAIF
$
47,932.81
RDA 2004 TAB
6711740700 Project Acct - Blackrock Instl Funds
$
0.12 6711740701 Interest Acct - Blackrock Instl Funds
$
360,284.61
6711740702 Principal Acct - Blackrock Instl Funds
$
204.79
6711740703 Reserve Acct - Blackrock Instl Funds
$
147,082.77
$
507,572.29
RDA 2010 TAB
6711740705 Reserve Acct - Blackrock Instl Funds
$
375,924.89
ATTACHMENT 6
City of Yucaipa
Treasurer's Report - August 31, 2024
July 2024
August 2024
Institution/Investment Type
Balance
Balance
Funds Under Control of the City:
Held in U.S. Bank Custody Account
$
39,407,898.60
$
39,717,785.30
Local Agency Investment Fund (LAIF)
$
12,584,694.41
$
10,584,694.41
City Checking Account
$
4,666,791.72
$
4,558,154.81
Petty Cash / Change Drawers
$
2,750.00
$
2,750.00
Total Funds Under Control of the City
$
56,662,134.73
$
54,863,384.52
Funds with Fiscal Agents:
Bank of New York Mellon (Chapman Heights)
CFD 98-1 - Invesco Govt Agency Private 1903
$
1,805,304.69
$
1,535,443.98
CFD 98-1 - Cash
$
12,068.98
$
-
$
1,817,373.67
$
1,535,443.98
U.S. Bank (Successor Agency)
RDA 1998 TAB - Blackrock Instl Funds
$
35,669.37
$
35,705.22
RDA 1998 TAB - LAIF
$
47,932.81
$
47,932.81
RDA 2004 TAB - Blackrock Instl Funds
$
507,572.29
$
508,631.85
RDA 2010 TAB - Blackrock Instl Funds
$
375,924.89
$
377,581.98
$
967,099.36
$
969,851.86
Total Funds with Fiscal Agents
$
2,784,473.03
$
2,505,295.84
Grand Total
$
59,446,607.76
$
57,368,680.36
1. All investment actions executed since the last report have been made in full compliance with the Investment Policy; and
2. The City will meet its expenditure obligations for the next six months.
Treasurer:
Sign / Date
ATTACHMENT 7
00202801
65- -01-B -82-250-01
0101-11-04304-01
embank.
CITY OF YUCAIPA - TREASURER MANAGED Period from August 1, 2024 to August 31, 2024
ACCOUNT
:ASSET SUM M.ARY
08/31/2024
% OF
ASSETS
MARKET VALUE
MARKET
Cash And Equivalents
2,177,518.03
5.45 U.S. Government Issues
34,112,301.16
85.36 Corporate Issues
2,992,489.21
7.49 Foreign Issues
244,343.40
0.61 Municipal Issues
191,133.50
0.48 Total Assets
39,717,785.30
99.39 Accrued Income
244,317.28
0.61 Grand Total
39.962.102.58
100.00
BONDS 93
EQUIV & ACCR 6.06%
ATTACHMENT 8
9/12/24, 10:47 AM
LAW Regular Monthly Statement
California State Treasurer
Fiona Ma, +cPA
Local Agency Investment Fund
P.O. Box 942809
Sacramento, CA 94209-0001
(916) 653-3001
CITY OF YUCAIPA
TREASURER
34272 YUCAIPA BLVD.
YUCAIPA, CA 92399
Account Number:
August 2024 Statement
14 September 12, 2024
LAIF Horne
PM1A Average Monthly_
Yields
!ran Type Definitions
Tran web
Effective Transaction Confirm Confirm
Date Date Type Number Number Authorized Caller
8/16/2024 8/15/2024 RW 1758633 1719152 PHILLIP WHITE
Account Summary
Total Deposit: 0.00 Beginning Balance:
Total Withdrawal:-2,000,000.00 Ending Balance:
Amount
-2,000,000.00
12,584,694.41
10,584,694.41
https://Iaifms.treasurer.ca.gov/RegularStatement.aspx 1 /1
ATTACHMENT 9
Analyzed Business Checking - PF
Account number: ■ August 1, 2024 - August 31, 2024 ■ Page 1 of 7
CITY OF YUCAIPA
GENERAL OPERATING ACCOUNT
34643 YALE DR
YUCAIPA CA 92399-6860
Account summary
Analyzed Business Checking - PF
Questions?
Call your Customer Service Officer or Client Services
1-800-AT WELLS (1-800-289-3557)
5:00 AM TO 6:00 PM Pacific Time Monday - Friday
Online: wellsforgo.com
Write: Wells Fargo Bank, N.A. (114)
P.O. Box 6995
Portland, OR 97228-6995
Accountnumber Beginning balance Total credits Total debits Ending balance $4,666,791.72 $6,236,462.74-$6,345,099.65 $4,558,154.81 Credits
Deposits
Effective Posted
date date
Amount
Transaction detail
08/07
2,340.00
Deposit
08/07
2,790.00
Deposit
08/19
1,160.00
Deposit
08/20
140.00
Deposit
08/21
140.00
Deposit
08/23
10.00 Deposit
08/23
580.00
Deposit
08/27
100.00
Deposit
08/27
150.00
Deposit
08/28
25.00 Deposit
08/29
390.00
Deposit
08/30
30.00 Deposit
$7,855.00 Total deposits
Electronic deposits/bank credits
Effective Posted
date date
Amount
Transaction detail
08/01
312.00
Desktop Check Deposit
08/01
1,204.02
Stripe Transfer St-U4A1 F3AOG2R4 City of Yucaipa
08/01
1,289.39
Desktop Check Deposit
08/01
11,509.33
Paymentech Transfer 240801 Tyler0005037661 Mun Csh CA Yucaipa Gen 08/01
17,018.61
Paymentech Transfer 240801 Tyler0005037697 Eg Css CA Yucaipa Comm 08/01
145,907.47
Apport St of CA Apsapports 072924 1927 Yucaipa City Treasurer 08/02
99.00 American Express Settlement 240801 5647699297 General Bi115647699297 08/02
115.13
Stripe Transfer St-A417F309A9138 City of Yucaipa
02010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
(114)
Sheet Seq = 0047217
Sheet 00001 of 00007
ATTACHMENT 10
City of Yucaipa
Investment with Fiscal Agent Summary
8/31/2024
Bank of New York Mellon CFD 98-1
703130 Special Tax Acct - Invesco Govt Agency Private 1903 $ 1,535,443.98 U.S. Bank
RDA 1998 TAB
6711616700 Project Acct -
Blackrock Instl Funds
$
0.24 6711616701 Interest Acct -
Blackrock Instl Funds
$
5,673.15
6711616702 Principal Acct
- Blackrock Instl Funds
$
31.56 6711616703 Sinking Acct -
Blackrock Instl Funds
$
30,000.06
6711616704 Reserve Acct -
Blackrock Instl Funds
$
0.21 $
35,705.22
6711616704 Reserve Acct -
LAW
$
47,932.81
RDA 2004 TAB
6711740700 Project Acct -
Blackrock Instl Funds
$
0.12 6711740701 Interest Acct -
Blackrock Instl Funds
$
155,899.71
6711740702 Principal Acct
- Blackrock Instl Funds
$
205,000.90
6711740703 Reserve Acct -
Blackrock Instl Funds
$
147,731.12
$
508,631.85
RDA 2010 TAB
6711740705 Reserve Acct -
Blackrock Instl Funds
$
377,581.98