Item 06 - Monthly Treasurer's Report January 2023 — Yucaipa City Council, February 27, 2023

Agenda Item No.- 6
Lam Xgl 17A tj I wen-4
TO: Honorable Mayor and City Council
FROM: Fermin Preciado, Acting City Manager/Treasureri-?. @Phillip White, Director of Finance
FOR: City Council Meeting of February 27, 2023
SUBJECT: Monthly Treasurer's Report: January 2023
oil
That the City Council receive and file the Monthly Treasurer's Report for January 2023.

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 to be 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 safety and 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 cash and investment portfolio.

The balances included in the Treasurer's Report represent the month -end market value of the City's investment portfolio. The portfolio is one component of assets. The City's net position or fund balance (equity) is comprised of all assets less liabilities. As such, the amounts are related but will differ for a number of reasons including accruals and methods of accounting. The City utilizes the Monthly Treasurer's Report as one tool to monitor fiscal performance.

While the City does not have outstanding 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 38 City Council Agenda
Meeting of February 27, 2023
Monthly Treasurer's Report: January 2023
Agency and Community Facilities District which are required to be held in separate accounts held with fiscal agents in accordance with the bond indentures.

As required by the Investment Policy, the attached 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.

There is no fiscal impact.

Attachments:

I . Treasurer's Report — January 2023

2. Asset Summary U.S. Bank PFM Managed — January 2023

3. Asset Summary U.S. Bank Treasurer Managed — January 2023

4. LAIF January Regular Monthly Statement

5. Wells Fargo Checking Bank Statement (I s'page) — January 202' )

6. Investments with Fiscal Agents Summary

7. Investments with Fiscal Agents — Asset Detail — January 2023 39 City of Yucaipa
Treasurer's Report - January 31, 2023
Attachment I
December 2022
January 2023
Institution/investment Type
Balance
1 Balance
Funds Under Control of the City:

U.S, Bank Investment Account - Managed by PFM
Cash and Equivalents
$
38,857,25
$
70,633.97
U.S. Government Issues
$
12,781,938.02
$
12,907,623.59
Corporate Issues
$
3,501,411.06
$
3,528,897.96
Foreign Issues
$
228,234.65
$
229,707.10
Municipal Issues
$
179,251.00
$
181,853.00
$
16,729,691.98
$
16, 918, 715.62
U.S. Bank Investment Account - Managed by Treasurer
Cash and Equivalents
$
255,471.30
$
256,017.26
U.S. Government Issues
$
19,774,628.00
$
19,851,827.00
$
20,030,099.30
$
20,107,844.26
$
5,007,491.73
$
14,833,928.50
Local Agency Investment Fund (LAIF)
City Checking Account (Wells Fargo)
$
15,724,288.54
$
9,003,245.34
Petty Cash / Change Drawers
$
2,450.00
$
2,450.00
Total Funds Under Control of the City
57,494,021.55
$
60,866,183.72
Funds with Fiscal Agents:

Bank of New York Mellon
CFD 98-1 - Invesco Govt Agency Private 1903
$
2,391,291.85
$
2,398,822.96
U.S. Bank
RDA 1998 TAB - Blackrock Instl Funds
$
1,818.12
$
1,824,02
RDA 1998 TAB - LAIF
$
45,357.47
$
45,357.47
RDA 2004 TAB - Blackrock Instl Funds
$
195,572.17
$
196,206:84
RDA 2010 TAB - Blackrock Instl Funds
$
373,543.70
$
374,755,91
Total Funds with Fiscal Agents
3,007,583.31
$
3,016,967,20
Other:

First American Title - Escrow
$
550,035.19
$
550,035.19
,Grand Total j
$
61,051,6
:3,:1:8::6::l :1j

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
40 00229701
22- -01-B -82 -035-01
0102 -11-04304-01

CITY OF YUCAIPA
ACCOUNT 291144529
Cash And Equivalents
U.S. Government Issues
Corporate Issues
Municipal Issues
Accrued Income
01/3
% OF
70,633.97 0.42
12, 907, 623.59 76.07
3,528,897.96 20:80
229,707.10 1.35
BONDS
181,853.00 1,07
49,023.13 0.29
VA
usl

Page 5 of 35 ends

Period from January 1, 2023 to January 31, 2023
41 00229701
22- -01-B -82 -035-01
0101 -11-04304-01

CITY OF YUCAIPA - TREASURER MANAGED
ACCOUNT 001051013310
Cash And Equivalents
U.S. Government Issues
Total Assets
Accrued Income
Grand Total
0113112023 % OF
256,017.26 1.27
19, 851, 827.00 98.29
89,870.54 0.44 1 BONDS

Page 5 of 12 ends

Period from January 1, 2023 to January 31, 2023
EQUIV&ACCR 1.71%
42 2/16/23,11:59AM
LAIF Regular Monthly Statement
California elate Treasurer
Rona Ma r,.P,-A
Local Agency Investment Fund February 16, 2023
P.O. Box 942809
Sacramento, CA 94209-0001 LAIF Home
(916) 653-3001 PMIA Average Month
Yields

CITY OF YUCAIPA
o WE
January 2023 Statement
Iran Type Definitions
Tran
Web
Effective Transaction
Confirm
Confirm
Date Date
T
Type
Number
Number Authorized Caller
Amount
1/11/2023 1/10/2023
RD
1720163
N/A

RYAN BLACKERBY
6,000,000.00
1/13/2023 1/12/2023
QRD
1722409
N/A
SYSTEM
26,436.77
1/30/2023 1/30/2023
RD
1723334
N/A

RYAN BLACKERBY
3,800,000.00
Account Summary
Total Deposit:
9,826,436.77
Beginning Balance:
5,007,491.73
Total Withdrawal:
0,00
Ending Balance:
14,833,928.50
https:Hlaifms.treasurer.ca.gov/RegularStatement.aspx 43 1/1

Analyzed Business Checking - PF
Account number: 111M= 0 January 1, 2023 -January 31, 2023 0 Page 1 of 5

CITY OF YUCAIPA

GENERAL OPERATING ACCOUNT
34272 YUCAIPA BLVD
YUCAIPA CA 92399-2434
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 7100844500 $15,724,288.54 $6,096,518.39 -$12,817,561.59 $9,003,245.34 Effective Posted
date
date
Amount
Transaction detail
01/06
100.00
Deposit
01/17
01/18
1,349.44
Reversal of Check Posted 1-17-23 Reposted 1-18-23 for $1,340.44 Our Ref:
1-17-23 00000000
01/20
325.00
Deposit
01/23
01/24
1,442.99
Reversal of Check Posted 1-23-23 Reposted 1-24-23 as Serial 0000012417 Our Ref: 1-23-23 00000000
01/24
01/25
12,384.00
Reversal of Check Posted 1-24-23 Reposted 1-25-23 as Serial 0000012404 Our Ref: 1-24-23 00000000
$15,601.43
Total deposits
Electronic deposits/bank credits
Effective Posted
01/03
585.00
01/03
830.00
01/03
2,468.75
01/03
3,611.25
01/03
9,905.00
01/04
2,785.00
01/04
4,447.60
01/04
16,266.09
01/05
100.00
01/05
11,233.83
01/05
13,923.00
01/05
58,085.41
02010 Wells Fargo Bank, N.A.

City M Yucaipa
AgentInvestment with Fiscal
FY 2023
880553 COI Acct
$
21,646.91
880554 Reserve AM
$
2,245,481.82
880555 Admin Exp Acct
$
131,694.2
Total
$
2,398,822.96
U.S. Bank
RDA 1998 TAB
671/616700 Project Acct - Blackrock Instl Funds
$

0.24 6711616701 Interest Acct - Blackrock Instl Funds
$
1,740.82
6711616703 Sinking Acct - Blackrock Instl Funds
$

11.81 6711616704 Reserve Acct - Blackrock Instl Funds
$

71.15 6711616704 Reserve Acct - IAIF
$
45,357,47
Total
$
47,181.49
6711740700 Project Acct - Blackrock Instl Funds $ 0.12
6711740701 Interest Acct - Blackrock Instl Funds $ 52,027.62 6711740702 Principal Acct - Blackrock Instl Funds $ 72.84 6711740703 Reserve Acct - Blackrock Instl Funds $ 144,106.26 Total $ 196,206.84
RDA 2010 TAB
6711740705 Reserve Acct - Blackrock Intl Funds $ 374,755.91 45 BNY MELLON
The Bank of Now York Mellon Trust Company, N.A.

Go Paperless.

Securely access your accounts online to view your statements. Ask your BNY Mellon contact how we can help you access your account balances and activity in real time, receive your reports, enter your own transactions or submit an audit confirmation online. Also be sure to ask how NEXEN(SM) Gateway, our new cloud -based ecosystem, can help you.

Visit us at www.bnymellon.com
Z3ZM3N=
rirpl i1q, � I � � I � I 11 � r � � I � � � �Tm4rff *.Tffl• rj
Account Statement
Statement Period 01/01/2023 Through 01/31/2023
Account 880553 Base Currency = USID
YUCAIPA 2011 COI ACCT
CLIENT SERVICE MANAGER: GRACIE CUICO

0.00 871.18

4.02 %
ACCOUNT TOTALS 21,646.91
21,646.91

0.00 871 A 8

4.02%
Summary of Cash Transactions by Transaction Category
Current Period
Year -to -Date
Realized
Transaction Category Income
Principal
Gains/Losses
Income
Principal
OPENING BALANCE 0.00

0.00 0.00

0.00 DIVIDENDS 67.97

0.00 0.00

67.97 0.00
PURCHASES 67.97-

0.00 0.00
67,97-

0.00 46 Page 1 of 4

'Poll-

BNY MELLON
The Bank of Now York Mellon Trust Company, N.A.

Go Paperless,
Securely access your accounts online to view your statements. Ask your BNY Mellon contact how we can help you access your account balances and activity in real time, receive your reports, enter your own transactions or submit an audit confirmation online. Also be sure to ask how NEXEN(SM) Gateway, our new cloud -based ecosystem, can help you.

Visit us at www.bnymellon.com
Summary of Assets Held by Asset Classificatior
Statement Period 01/0112023 Through 01/31/2023
Account 880554 Base Currency = USD
YUCAIPA 2011 BOND RESERVE ACCT
CLIENT SERVICE MANAGER: GRACIE CUICO

BNYM CORPORATE TRUST
400 SOUTH HOPE STREET, SU
LOS ANGELES, CA 90071
213-553-4337
[email protected]
Estimated Market
Asset Classification Market Value Cost Accrued Income Annual Income Yield CASH AND SHORT TERM 2,245,481 .82 2,245,481.82 0.00 90,369.20 4.02% ACCOUNT TOTALS 2,245,481.82 2,245,481.82 0.00 90,369.20 4.02% Summary of Cash Transactions by Transaction Category
1000M
9EN=
Realized
0 Transaction Category
Income
Principal
Gains/Losses
Income
Principal

OPENING BALANCE

0.00 0.00

DIVIDENDS
7,049.66

0.00 0.00
7,049.66

0.00 1�

PURCHASES
7,049.66-

0.00 0.00
7,049.66-

0.00 47 Page 1 of 4

BNY MELLON
The Bank of Now York Mellon Trust Company, N.A.

Go Paperless.

Visit us at www.bnymellon.com
Summary of Assets Held by Asset Classification
Statement Period 01/01/2023 Through 01/31/2023
Account 880555 Base Currency = USD
YUCAIPA 2011 ADMIN EXP ACCT
CLIENT SERVICE MANAGER: GRACIE CUICO

BNYM CORPORATE TRUST
400 SOUTH HOPE STREET, SU
LOS ANGELES, CA 90071
213-553-4337
[email protected]
Estimated Market
Asset Classification Market Value Cost Accrued Income Annual Income Yield CASH AND SHORT TERM 131,694.23 131,694.23 0.00 5,300.02 4.02% ACCOUNT TOTALS 131,694.23 131,694.23 0.00 5,300.02 4.02% Summary of Cash Transactions by Transaction Category
a==
Realized
0 Transaction Category
Income
Principal
Gains/Losses
Income
Principal

OPENING BALANCE

0.00 0.00

DIVIDENDS
413.48
0,00

0.00 413.48

0.00 PURCHASES
413.48-

0.00 0.00
413.48-

0.00 48 Page 1 of

LOS=
This statement is for the period from
January 1, 2023 to January 31, 2023
Shares or Market Value/ Tax Cost] % of Total
Face Amount Securitv Description Price Unit Cost Yield at Market Est Ann Inc .240 Blackrock T-Fund Inst 0.24 0.24 100.0 0.01
#30 1.0000 1.00 4.17
0924BU718
Total Cash Equivalents $0.24 $0.24 100.0 $.01
Total Assets $0.24 $0.24 100.0 $.01
Time of trade execution and trading party (if not disclosed) will be provided upon request.

Publicly traded assets are valued in accordance with market quotations or valuation methodologies from financial industry services believed by us to be reliable. Assets that are not publicly traded may be reflected at values from other external sources. Assets for which a current value is not available may be reflected at a previous value or as not valued, at par value, or at a nominal value. Values shown do not necessarily reflect prices at which assets could be bought or sold. Values are updated based on internal policy and may be updated less frequently than statement generation.

For further information, please contact your Analyst.

Yield at Market and Estimated Annual Income are estimates provided for informational purposes only and should not be relied on for making investment, trading, or tax decisions. The estimates may not represent the actual value earned by your investments and they provide no guarantee of what your investments may earn in the future. 49 F---------
Lug
This statement is for the period from
January 1, 2023 to January 31, 2023
000�� IF-111
Shares or Market Value/ Tax Cost/ % of Total
Face Amount Security Description Price Unit Cost Yield at Market Est Ann Inc, Cash Equivalents
1,740.820 Blackrock T-Fund Inst
#30
09248U718
1,740.82 1,740.82 100.0 70.94

1.0000 1.00 4.07
Total Cash Equivalents $1,740.82 $1,740.82 10010 $70.94 Total Assets $1,740.82 $1,740.82 100.0 $70.94
Time of trade execution and trading party (if not disclosed) will be provided upon request.

For further information, please contact your Analyst.

CITY OF YUCAIPA AS SUCCESSOR TO

THE RDA FOR THE CITY OF YUCAIPA

YUCAIPA REDEVELOPMENT PROJECT
1998 TAX ALLOCATION BONDS

SINKING ACCOUNT
This statement is for the period from
January 1, 2023 to January 31, 2023
Shares or Market Value/ Tax Cost/ % of Total
Face Amount Security Description Price Unit Cost Yield at Market EstAnnInc 111.810 Blackrock T-Fund Inst 11.81 11.81 100.0 0,48
#30 1.0000 1.00 4,06
09248U718
Total Cash Equivalents $11.81 $11.81 100.0 $.48
Total Assets $11.81 $11.81 100.0 $.48
Time of trade execution and trading party (if not disclosed) will be provided upon request.

For further information, please contact your Analyst.

Yield at Market and Estimated Annual Income are estimates provided for informational purposes only and should not be relied on for making investment, trading, or tax decisions. The estimates may not represent the actual value earned by your investments and they provide no guarantee of what your investments may earn in the future. 51 This statement is for the period from
January 1, 2023 to January 31, 2023
Shares or Market Value/ Tax Cost/ % of Total
Face Amount Security Description Price Unit Cost Yield at Market Est Ann Inc

71.150 Blackrock T-Fund Inst 71.15 71A5 0.2 2.90
#30 1.0000 1,00 4.08
09248U718
Total Cash Equivalents $71.15 $71.15 0.2 $2.90
45,357.470 Local Agency Investment Fd
45,357.47
45,357.47 99.8 0.00
Var Rate Open Maturity

1.0000

1.00 '00
Pays Qtrly On The 15TH Jajo
****** Open Maturity
5396409A2
Total Miscellaneous
$45,357.47
$45,357.47 99.8
Total Assets
$45,428.62
$45,428.62 100.0 $2.90
Time of trade execution and trading party (if not disclosed) will be provided upon request.

For further information, please contact your Analyst.

CITY OF YUCAIPA AS SUCCESSOR TO THE

RDA OF THE CITY OF YUCAIPA

YUCAIPA REDEVELOPMENT PROJECT
2004 TAX ALLOCATION BONDS
This statement is for the period from
January 1, 2023 to January 31, 2023
Shares or Market Value/ Tax Cost/ % of Total
Face Amount Security Description Price Unit Cost Yield at Market Est Ann Inc Cash Equivalents
.120 Blackrock T-Fund Inst 0.12 0.12 IWO 0.00
#30 1.0000 1.00 .00
09248U718
Total Cash Equivalents $0.12 $0.12 100.0
Total Assets $012 $0.12 100.0
Time of trade execution and trading party (if not disclosed) will be provided upon request.

For further information, please contact your Analyst.

CITY OF YUCAIPA AS SUCCESSOR TO THE

RDA OF THE CITY OF YUCAIPA

YUCAIPA REDEVELOPMENT PROJECT
2004/2010 TAX ALLOCATION BONDS

INTEREST ACCOUNT
This statement is for the period from
January 1, 2023 to January 31, 2023
Shares or Market Value/ Tax Cost/ % of Total
Face Amount Security Description Price Unit Cost Yield at Market Est Ann Inc Cash Equivalents
52,027.620 Blackrock T-Fund Inst 52,027.62 52,027.62 100.0 2,120.22 #30 1,0000 100 4,07
09248U718
Total Cash Equivalents $52,027.62 $52,027.62 100.0 $2,120.22 Total Assets $52,027.62 $52,027.62 100.0 $2,120.22
Time of trade execution and trading party (if not disclosed) will be provided upon request.

For further information, please contact your Analyst.

CITY OF YUCAIPA AS SUCCESSOR TO THE

RDA OF THE CITY OF YUCAIPA

YUCAIPA REDEVELOPMENT PROJECT
2004/2010 TAX ALLOCATION BONDS

PRINCIPAL ACCOUNT
This statement is for the period from
January 1, 2023 to January 31, 2023
Shares or Market Value/ Tax Cost/ % of Total
Face Amount SecuritZ DesELJ:2ffon Price Unit Cost Yield at Market Est Ann Inc

72.840 Blackrock T-Fund Inst
#30
09248U718

72.84 72.84 100A 2.97

1.0000 1.00 4.08
Total Cash Equivalents $72.84 $72.84 100.0 $2.97
I otall ASsets $72.84 $72.84 100.0 $2.97
Time of trade execution and trading party (if not disclosed) will be provided upon request.

For further information, please contact your Analyst.

This statement is for the period from
January 1, 2023 to January 31, 2023
Shares or Market Value/ Tax Cost/ % of Total
Face Amount Security Description Price Unit Cost Yield at Market Est Ann Inc Cash Equivalents
144,106.260 Blackrock T-Fund Inst 144,106.26
#30 1.0000
09248U718
144,106:26 100.0 5,872.60

1.00 407
Total Cash Equivalents $144,106.26 $144,106.26 100.0 $5,872.60 i otal ASsets $144,106.26 $144,106.26 100.0 $5,872.60
Time of trade execution and trading party (if not disclosed) will be provided upon request.

Publicly traded assets are valued in accordance with market quotations or valuation methodologies from financial industry services believed by us to be reliable. Assets that are not publicly traded may be reflected at values from other external sources, Assets for which a current value is not available may be reflected at a previous value or as not valued, at par value, or at a nominal value. Values shown do not necessarily reflect prices at which assets could be bought or sold. Values are updated based on internal policy and may be updated less frequently than statement generation.

For further information, please contact your Analyst.

Yield at Market and Estimated Annual Income are estimates provided for informational purposes only and should not be relied on for making investment, trading, or tax decisions. The estimates may not represent the actual value earned by your investments and they provide no guarantee of what your investments may earn in the future. 56 This statement is for the period from
January 1, 2023 to January 31, 2023
Shares or Market Value/ Tax Cost/ % of Total
Face Amount Securitv Descr tion Price Unit Cost Yield at Market Est Ann Inc Cash Equivalents
374,755.910 Blackrock T-Fund Inst
#30
09248U718
374,755.91

1.0000
374,755.91

1.00 100.0 15,272.01

4.07 Total Cash Equivalents
$374,755.91
$374,755.91
100.0 $15,272.01
Total Assets
$374,755.91
$374,755.91
100.0 $15,272.01
Time of trade execution and trading party (if not disclosed) will be provided upon request.

For further information, please contact your Analyst.

Yucaipa City CouncilFebruary 27, 2023

Yucaipa City Council
February 27, 2023