HomeMy WebLinkAboutAgenda - Agenda Packets - Regular Meeting 9/7/2021
AGENDA
CITY COUNCIL – REGULAR MEETING
TUESDAY, SEPTEMBR 7, 2021
5:30 PM CLOSED SESSION
6:30 PM OPEN SESSION
PUBLIC TELECONFERENCE NUMBER
(951) 465-7684, Conference ID #:484 599 452#
LIVE STREAM LINK: www.sanjacintoca.gov
SAN JACINTO CITY HALL
595 S. San Jacinto Ave
San Jacinto, CA 92583
951-487-7330
City of San Jacinto Page 1 Updated 9/2/2021 3:00 PM
ALONSO LEDEZMA, MAYOR
CRYSTAL RUIZ, MAYOR PRO TEM
JOEL LOPEZ, COUNCILMEMBER
PHIL AYALA, COUNCILMEMBER
BRIAN HAWKINS, COUNCILMEMBER
IMPORTANT MESSAGE REGARDING SEPTEMBER 7, 2021 CITY COUNCIL
MEETING
***SPECIAL TELECONFERENCING MEETING PROCEDURES***
This City Council meeting is being conducted utilizing teleconferencing and electronic means
consistent with State of California Executive Order N-29-20 dated March 17, 2020, regarding the
COVID-19 pandemic. The City Council meeting may be joined telephonically by calling (951)
465-7684, Conference ID #:484 599 452#.
Submission of Public Comments: For those wishing to make public comments at the
September 7, 2021, City Council meeting, please submit your comments by email to be read
aloud at the meeting by the City Clerk. Email comments to Julia Espinoza at
jespinoza@sanjacintoca.gov. Please put “PUBLIC COMMENT” in the email subject line.
Email comments on matters not on the agenda must be received before the time the Mayor calls
the item for Public Comments. Email comments on the agenda items must be received before
the time the Mayor closes public comments on the agenda item. All email comments shall be
subject to the same rules as would otherwise govern speaker comments at the Council meeting.
Electronic comments on agenda items for September 7, 2021, may only be submitted via email.
Comments via text and social media (Facebook, Twitter, etc.) will not be accepted.
Submission of Public Hearing Comments: Please put “COMMENT FOR PUBLIC
HEARING” in the subject line.
Reading of Public Comments: The City Clerk shall read all email comments, provided that the
reading shall not exceed three (3) minutes, or such other time as the Council may provide,
consistent with the time limit for speakers at a Council meeting. The email comments submitted
shall become part of the record of the Council meeting.
In compliance with the Americans with Disabilities Act, if you need special assistance to participate in this meeting, please contact the office
of the City Clerk at 951-487-7339. Notification 48 hours prior to a meeting will enable the City to make reasonable arrangements to ensure
accessibility to that meeting [28 CFR 35.102.35.104 ADA Title II].
City of San Jacinto Page 2 Updated 9/2/2021 3:00 PM
1. ORGANIZATION
1.1. Public Comments on Closed Session Items
1.2. Closed Session
1.2.1. CONFERENCE WITH LEGAL COUNSEL—ANTICIPATED LITIGATION
Initiation of litigation pursuant to Government Code Section 54956.9(d)(4): (1
case)
1.2.2. CONFERENCE WITH LEGAL COUNSEL—EXISTING LITIGATION
Pursuant to Government Code Section 54956.9(d)(1)
Case: In re National Prescription Opiate Litigation (U.S.D.C. Case No. 1:17-CV-
2804)
1.3. Closed Session Report
1.4. Roll Call
1.5. Invocation
1.6. Pledge of Allegiance
1.7. Special Presentation(s)
1.7.1. Resolution No. 3881 - Election Integrity
RECOMMENDATION:
Staff recommends that the City Council approve and adopt Resolution No.
3881, an expression of the City of San Jacinto City Council and its support for
election integrity.
Department: City Clerk
1.7.2. Resolution No. 3882 - Never Forget 9/11 20th Anniversary
RECOMMENDATION:
Staff recommends that the City Council approve and adopt Resolution No.
3882, Remembering 9/11 on its 20th anniversary.
Department: City Clerk
1.8. Mayor / Council Member Reports / Discussions
1.9. Late Items
2. PUBLIC COMMENTS
City of San Jacinto Page 3 Updated 9/2/2021 3:00 PM
3. CONSENT CALENDAR
3.A. Consent Calendar - City Council
3.A.1. Waiver of Full Reading of Ordinance(s), and Reading by Title Only
3.A.2. Minutes of the August 17, 2021, Regular City Council Meeting
RECOMMENDATION:
Staff recommends that City Council approve the minutes of the August 17,
2021, regular City Council meeting.
Department: City Clerk
3.A.3. Treasurer’s Report at July 31, 2021
RECOMMENDATION:
Receive and File Treasurer’s Report for the month ending July 31, 2021.
Department: Finance
3.A.4. San Jacinto Power – 2020 Power Content Label and Attestation
RECOMMENDATION:
Staff recommends that the City Council provide the attestation specified under
California’s Power Source Disclosure (PSD) Program, which requires the
governing council of a public agency providing retail electric service to
endorse the accuracy of each annual report and power content label, as
submitted to the California Energy Commission, for the previous year. In the
case of San Jacinto Power (SJP), such attestations will be based on the
California Choice Energy Authority’s (CalChoice) technical review, and they
will address the 2020 Annual Reports and Power Content Labels (PCL)
prepared for the SJP community choice aggregation (CCA) program.
Department: Finance
4. PUBLIC HEARING
4.1. Appointment of up to three Planning Commissioners for terms starting November 1,
2021, through October 31, 2025.
RECOMMENDATION:
That the City Council reappoint Corrine Awad, Michael Health, and Taurus Jones
to the Planning Commission for terms starting November 1, 2021.
Department: Community Development
5. FUTURE REQUESTS FROM CITY COUNCIL TO STAFF
6. ADJOURNMENT
City of San Jacinto Page 4 Updated 9/2/2021 3:00 PM
DOCUMENTS RELATED TO OPEN SESSION AGENDAS (SB343) - Any public record relating to an
open session agenda item that is distributed within 72 hours prior to the meeting is available for public
inspection at the public counter located in the Administration Building of City Hall, 595 S. San Jacinto
Avenue, San Jacinto, CA 92583.
I, Julia Espinoza, Deputy City Clerk of the City of San Jacinto, do hereby certify that I caused to be posted
the foregoing agenda this 2nd day of September 2021 as requested by law.
Julia Espinoza, Deputy City Clerk
September 7, 2021
TO: City Council
REQUESTED BY: Julia Espinoza, Deputy City Clerk
APPROVED BY: Robert A. Johnson, City Manager
SUBJECT: Election Integrity
RECOMMENDATION:
Staff recommends that the City Council approve and adopt Resolution No. 3881, an expression
of the City of San Jacinto City Council and its support for election integrity.
ATTACHMENTS:
Resolution No. 3881 - Election Integrity
1.7.1
Packet Pg. 5
STATE OF CALIFORNIA ) RESOLUTION NO. 3881
COUNTY OF RIVERSIDE ) ss.
CITY OF SAN JACINTO )
RESOLUTION OF THE CITY COUNCIL OF THE CITY OF SAN
JACINTO, CALIFORNIA, ADOPTING AN EXPRESSION OF THE CITY
OF SAN JACINTO CITY COUNCIL AND ITS SUPPORT FOR
ELECTION INTEGRITY.
WHEREAS, the ability to choose governmental leaders, and to hold such leaders
accountable for their actions and decisions, is a hallmark of democracy and of a free
and fair nation; and
WHEREAS, these democratic ideals require that we pre serve election integrity to
ensure that governmental leaders are selected through processes that are free from
corruption, undue influence and fraud; and
WHEREAS, electoral integrity requires a legal and institutional system that encourages
and protects f air and equitable elections as well as application of specific measures to protect
integrity based on democratic election standards and best practices; and
WHEREAS, every time a fraudulent vote is cast, it effectively cancels out a
legitimately cast ballot and risks awarding important governmental offices to candidates
who have not been duly elected by the people; and
WHEREAS, the appropriate measures must be adapted to the social and political
context of each country, but the basic objectives are the sam e and stem from the need to
ensure genuine and credible elections every step must be taken by legislators to ensure
ballots are protected, and that access is guaranteed for all voters; and
WHEREAS, the City Council of the City of San Jacinto believes in re spect for the
principles of electoral democracy, ethical conduct, professionalism and accuracy,
institutional safeguards, oversight and enforcement, and transparency and
accountability in the election process.
NOW, THEREFORE, BE IT RESOLVED by the City Council of the City of San
Jacinto:
SECTION 1. The people shall have an untarnished right to participate as voters
and candidates in the electoral process.
SECTION 2. All individual voters must have equal voting power and the right to
cast ballots as they see fit, without pressure, compulsion, or modification from outside
sources.
1.7.1.a
Packet Pg. 6 Attachment: Resolution No. 3881 - Election Integrity (Election Integrity)
2
SECTION 3. Voters must have meaningful access to electoral and campaign
information, the election administration must be conducted in a fair and non -partisan
manner, and the results of the elections must be decided by the freely cast votes of the
citizenry.
APPROVED AND ADOPTED this 7th day of September 2021, by the following vote:
AYES:
NAYS:
ABSTAIN:
ABSENT:
CITY OF SAN JACINTO:
________________________________
Alonso Ledezma, Mayor
ATTEST:
______________________________
Julia Espinoza, Deputy City Clerk
APPROVED AS TO FORM:
BEST BEST & KRIEGER, LLP
______________________________
Michael J. Maurer, City Attorney
1.7.1.a
Packet Pg. 7 Attachment: Resolution No. 3881 - Election Integrity (Election Integrity)
3
STATE OF CALIFORNIA)
COUNTY OF RIVERSIDE) §
CITY OF SAN JACINTO)
CERTIFICATION
I, Julia Espinoza, Deputy City Clerk of the City of San Jacinto, do hereby certify
that the foregoing Resolution No. 3881 duly adopted by the City Council of the City of
San Jacinto at a regular meeting thereof, held on the 7th day of September 2021, by the
following vote of Council:
AYES:
NAYS:
ABSENT:
ABSTAIN:
WITNESS MY HAND AND OFFICIAL SEAL the 7th day of Septembr, 2021.
___________________________________
Julia Espinoza, Deputy City Clerk
1.7.1.a
Packet Pg. 8 Attachment: Resolution No. 3881 - Election Integrity (Election Integrity)
September 7, 2021
TO: City Council
REQUESTED BY: Julia Espinoza, Deputy City Clerk
APPROVED BY: Robert A. Johnson, City Manager
SUBJECT: 9/11 20TH ANNIVERSARY
RECOMMENDATION:
Staff recommends that the City Council approve and adopt Resolution No. 3882, Remembering
9/11 on its 20th anniversary.
ATTACHMENTS:
Resolution No. 3882 - NEVER FORGET 911 20TH ANNIVERSARY
1.7.2
Packet Pg. 9
24438.00000\31671131.1
STATE OF CALIFORNIA ) RESOLUTION NO. 3882
COUNTY OF RIVERSIDE ) ss.
CITY OF SAN JACINTO )
RESOLUTION OF THE CITY COUNCIL OF THE CITY OF SAN
JACINTO, CALIFORNIA,ADOPTING A NEVER FORGET STATEMENT
REGARDING THE 20TH ANNIVERSARY OF 9/11.
WHEREAS, September 11, 2001, will forever be marked as one of our country’s
darkest days, as it changed our lives forever; and
WHEREAS, Almost two decades later, we still grieve the loss of the nearly 3,000
American lives and continue to honor the memory of our frie nds, loved ones, and family
who were simply passengers on a flight, folks going to work, and police officers and first
responders serving their community; and
WHEREAS, The 20th anniversary of that fateful day reminds us that who we are
as people and a nation is much bigger than anything that can divide us; and
WHEREAS, On a day that was meant to break our country, these evil acts only
served as a means to unify our country more than ever.
NOW, THEREFORE, BE IT RESOLVED by the City Council of the City of San
Jacinto
SECTION 1. The City Council’s hope and prayer for our country is that we never
forget those who were lost and the sacrifices so many made in the days that followed.
APPROVED AND ADOPTED this 7th day of September 2021, by the following vote:
AYES:
NAYS:
ABSTAIN:
ABSENT:
1.7.2.a
Packet Pg. 10 Attachment: Resolution No. 3882 - NEVER FORGET 911 20TH ANNIVERSARY (9/11 20TH ANNIVERSARY)
2
24438.00000\31671131.1
CITY OF SAN JACINTO:
________________________________
Alonso Ledezma, Mayor
ATTEST:
______________________________
Julia Espinoza, Deputy City Clerk
APPROVED AS TO FORM:
BEST BEST & KRIEGER, LLP
______________________________
Michael J. Maurer, City Attorney
1.7.2.a
Packet Pg. 11 Attachment: Resolution No. 3882 - NEVER FORGET 911 20TH ANNIVERSARY (9/11 20TH ANNIVERSARY)
3
24438.00000\31671131.1
STATE OF CALIFORNIA)
COUNTY OF RIVERSIDE) §
CITY OF SAN JACINTO)
CERTIFICATION
I, Julia Espinoza, Deputy City Clerk of the City of San Jacinto, do hereby certify
that the foregoing Resolution No. 3882 duly adopted by the City Council of the City of
San Jacinto at a regular meeting thereof, held on the 7th day of September 2021, by the
following vote of Council:
AYES:
NAYS:
ABSENT:
ABSTAIN:
WITNESS MY HAND AND OFFICIAL SEAL the 7th day of Septembr, 2021.
___________________________________
Julia Espinoza, Deputy City Clerk
1.7.2.a
Packet Pg. 12 Attachment: Resolution No. 3882 - NEVER FORGET 911 20TH ANNIVERSARY (9/11 20TH ANNIVERSARY)
September 7, 2021
TO: City Council
REQUESTED BY: Julia Espinoza, Deputy City Clerk
APPROVED BY: Robert A. Johnson, City Manager
SUBJECT: Minutes
RECOMMENDATION:
Staff recommends that City Council approve the minutes of the August 17, 2021, regular City
Council meeting.
ATTACHMENTS:
8-17-21 Regular Meeting Minutes
3.A.2
Packet Pg. 13
ACTION MINUTES
CITY COUNCIL – REGULAR MEETING
TUESDAY, AUGUST 17, 2021
6:30 pm OPEN SESSION – TELEPHONICALLY
(951) 465-7684, Conference ID #:215 355 234#
SAN JACINTO CITY HALL
595 SAN JACINTO AVE.
SAN JACINTO, CA 92583
951-487-7330
1. ORGANIZATION
Mayor Alonso Ledezma called the meeting to order at 6:30 pm.
1.1 Roll Call
Deputy City Clerk Julia Espinoza conducted the roll call:
Teleconferenced in: Mayor Alonso Ledezma, Mayor Pro Tem Crystal Ruiz,
Councilmember Phil Ayala and Councilmember Brian Hawkins
Absent: Councilmember Joel Lopez
M/S/C (Ledezma/Ruiz) moved to not excuse the absences of Councilmember Lopez. Motion
carried 4/0.
Ayes: Hawkins, Ruiz, Ledezma, Ayala
Nays: None
Absent: Lopez
Abstain: None
1.2 Invocation
Councilmember Ayala gave the invocation.
1.3 Pledge of Allegiance
Councilmember Hawkins led the Pledge of Allegiance.
ALONSO LEDEZMA, MAYOR
CRYSTAL RUIZ, MAYOR PRO TEM
PHIL AYALA, COUNCILMEMBER
BRIAN HAWKINS, COUNCILMEMBER
JOEL LOPEZ, COUNCILMEMBER
3.A.2.a
Packet Pg. 14 Attachment: 8-17-21 Regular Meeting Minutes (Minutes)
1.4 Mayor/Council Member Reports/Discussions
Councilmembers provided their reports.
1.5 Late Items
There were no late items.
2. PUBLIC COMMENTS
There were three public comments:
Sharon Durban
Mara Levy
Russ Utz
3. CONSENT CALENDAR
3.A Consent Calendar – City Council
3.A.1. Waiver of Full Reading of Ordinance(s), and Reading b y Title Onl y
3.A.2. Minutes of the Regular City Council Meeting of August 3, 2021/City
Clerk/Approved
3.A.3. Warrants and Disbursements-July 2021/Finance/Approved
3.A.4. Resolution of Intention to Annex Territory into Community Facilities
District No. 2003-1 and to Authorize the Levy of Special Taxes
Therein/Finance/Approved
3.A.5. Resolution of Intention to Annex Territory known as Class Leasing into
Community Facilities District No. 2020-1 and to Authorize the Levy of
Special Taxes Therein/Finance/Approved
3.A.6. Professional Services Agreement 3rd Extension – Dave’s Hauling/Public
Utilities/Approved
M/S/C (Ruiz/Ledezma) moved to approve the Consent Calendar. Motion
carried 4/0.
Ayes: Ruiz, Ayala, Hawkins, Ledezma
Nays: None
Absent: Lopez
Abstain: None
4. DISCUSSION ITEM
4.1 Consideration of Censure of Council Member Joel Lopez
City Attorney Michael J. Maurer and Mayor Pro Tem Ruiz presented the staff report.
3.A.2.a
Packet Pg. 15 Attachment: 8-17-21 Regular Meeting Minutes (Minutes)
M/S/C (Ruiz/ Ledezma) made a motion to approve the Censure of Council
Member Joel Lopez. There is no staff recommendation for this item. Motion
carried 4/0.
Ayes: Hawkins, Ledezma, Ruiz, Ayala
Nays: None
Absent: Lopez
Abstain: None
4.2 American Rescue Plan Act (ARPA) Funding Allocation and Appropriation
Deputy City Manager Thomas Prill presented the staff report.
M/S/C (/) made a motion to approve the initial spending plan of the City's
American Rescue Plan Act (ARPA) Funding Allocation and Appropriation of
$11,773,274. Motion carried 4/0.
Ayes: Ledezma, Ayala, Ruiz, Hawkins,
Nays: None
Absent: Lopez
Abstain: None
4.3 California Environmental Quality Act (CEQA) “Categorical Exemption” for
the drilling and construction of the New Grand Well
Chief of Public Utilities Arthur Mullen presented the staff report.
M/S/C (Ruiz/Ledezma) made a motion to approve the California Environmental
Quality Act (CEQA) “Categorical Exemption” for the drilling and
construction of the New Grand Well to replace the failed existing Grand Well.
Motion carried 4/0.
Ayes: Ayala, Ruiz, Hawkins, Ledezma
Nays: None
Absent: Lopez
Abstain: None
4.4 Abatement and Demolition of 248 E. Main Street, known as the Virginia Lee
City Manager Robert Johnson presented the staff report.
M/S/C (Ruiz/Ayala) made a motion to 1) determine that the project represents an
Emergency Project and therefore statutorily exempt from the provisions of
CEQA pursuant to Section 15269 (c) - Emergency Project; 2) approve the
contract award with Graham Cracker Demo Inc. for $50,441; and 3) authorize
the City Manager to execute the Contract. Motion carried 3/0.
Ayes: Ruiz, Hawkins, Ayala
Nays: None
Absent: Lopez
Abstain: Ledezma
3.A.2.a
Packet Pg. 16 Attachment: 8-17-21 Regular Meeting Minutes (Minutes)
5. FUTURE REQUESTS FROM CITY COUNCIL TO STAFF
There was no request to staff.
6. ADJOURNMENT
With no further business before the City Council, Mayor Ledezma adjourned the City
Council's Regular Meeting at 9:04 pm.
CITY OF SAN JACINTO:
________________________
Alonso Ledezma, Mayor
ATTEST:
________________________
Julia Espinoza, Deputy City Clerk
Approved as read:
Approved as amended:
3.A.2.a
Packet Pg. 17 Attachment: 8-17-21 Regular Meeting Minutes (Minutes)
September 7, 2021
TO: City Council
REQUESTED BY: Tom Prill, Deputy City Manager
APPROVED BY: Robert A. Johnson, City Manager
SUBJECT: Treasurer’s Report at July 31, 2021
RECOMMENDATION:
Receive and File Treasurer’s Report for the month ending July 31, 2021.
BACKGROUND:
The Treasurer’s Report is required to be presented to the governing body at least quarterly in
accordance with California Government Code Section 53600 et. seq.
DISCUSSION:
Total Cash and City Investments increased 4.19% during the month. This includes cash, cash in
the bank, and cash with the trustee.
The attached Treasurer’s report is a “snapshot” report of our cash position on the last day of the
month in all of our accounts. A section demonstrating compliance with the adopted Investment
Policy and a chart depicting historical interest rates for certain positions is also included.
Detailed statements of investments from Chandler Asset Management and Public Trust Advisors
have also been included.
FISCAL IMPACT:
None.
ATTACHMENTS:
2021-22 July Treasurers Report with signature
3.A.3
Packet Pg. 18
3.A.3.aPacket Pg. 19Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
3.A.3.aPacket Pg. 20Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
- 0.500 1.000 1.500 2.000 2.500 3.0008/189/1810/1811/1812/181/192/193/194/195/196/197/198/199/1910/1911/1912/191/202/203/204/205/206/207/208/209/2010/2011/2012/201/212/213/214/215/216/217/21Interest Rates - 8/18 to 7/21LAIFLAMMA-BoHMMA-MechPIMMA-MechChandlerPTA3.A.3.aPacket Pg. 21Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
MONTHLY ACCOUNT STATEMENT
City of San Jacinto - Account #10167
JULY 1, 2021 THROUGH JULY 31, 2021
Information contained herein is confidential. We urge you to compare this statement to the one you receive from your qualified custodian. Please see Important Disclosures.
CHANDLER ASSET MANAGEMENT
chandlerasset.com
Chandler Team:
For questions about your account, please call (800) 317-4747,
or contact operations@chandlerasset.com
Custodian
US Bank
Christopher Isles
(503) 464-3685
3.A.3.a
Packet Pg. 22 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
ACCOUNT SUMMARY
Beg. Values
as of 6/30/21
End Values
as of 7/31/21
Market Value 11,259,463 11,303,870
Accrued Interest 46,864 42,986
Total Market Value 11,306,326 11,346,856
Income Earned 14,123 13,953
Cont/WD -1,047
Par 11,008,121 11,026,324
Book Value 11,065,341 11,082,210
Cost Value 11,077,036 11,096,890
TOP ISSUERS
Government of United States 33.6%
Federal National Mortgage Assoc 19.3%
Federal Home Loan Bank 17.2%
Federal Home Loan Mortgage Corp 9.0%
Toyota Motor Corp 2.2%
Inter-American Dev Bank 2.0%
Apple Inc 1.8%
Honda ABS 1.7%
Total 87.0%
PORTFOLIO CHARACTERISTICS
Average Modified Duration 2.58
Average Coupon 1.66%
Average Purchase YTM 1.50%
Average Market YTM 0.36%
Average S&P/Moody Rating AA+/Aa1
Average Final Maturity 2.77 yrs
Average Life 2.64 yrs
CREDIT QUALITY (S&P)MATURITY DISTRIBUTIONSECTOR ALLOCATION
Portfolio Summary
As of July 31, 2021
City of San Jacinto
Account #10167
PERFORMANCE REVIEW
Annualized
TOTAL RATE OF RETURN 1M 3M YTD 1YR 2YRS 3YRS 5YRS 10YRS 6/30/2012
City of San Jacinto 0.37%0.37%-0.02%0.20%2.66%3.12%2.00%N/A 1.51%
City of San Jacinto 1-5 Year Govt Blended Index*0.35%0.30%-0.06%-0.06%2.20%2.75%1.64%N/A 1.26%
City of San Jacinto 1-5 Yr Corp/Gov AAA-A Blend**0.34%0.32%-0.03%0.03%2.26%2.85%1.78%N/A 1.43%
*ICE BAML 1-3 Yr US Treasury Index to 3/31/2020; then ICE BAML 1-5 Yr US Treasury/Agency thereafter.
**ICE BAML 1-3 Yr US Corp/Govt Rated AAA-A Index to 3/31/2020; then ICE BAML 1-5 Yr US Corp/Govt Rated AAA-A Index thereafter.
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 1
3.A.3.a
Packet Pg. 23 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Category Standard Comment
Municipal Securities "A" rating category or better by a NRSRO; 30% maximum; 5% max per issuer Complies
Treasury Issues No Limitation Complies
Agency Issues No Limitation Complies
Supranationals
"AA" rated or better by a NRSRO; 30% maximum; 10% max per issuer; U.S. dollar denominated senior unsecured
unsubordinated obligations issued or unconditionally guaranteed by the International Bank for Reconstruction and
Development ("IBRD"), the International Finance Corporation ("IFC") or the Inter-American Development Bank ("IADB")
Complies
Banker’s Acceptances "A-1" short term debt rated or higher by at least two NRSROs; and "A" long-term debt rated or higher by at least two
NRSROs; 40% maximum; 5% max per issuer; 180 days max maturity Complies
Commercial Paper
"A-1" short term debt rated or higher by at least two NRSROs; and "A" long-term debt rated or higher by at least two
NRSROs; 25% maximum; 5% max per issuer; 270 days max maturity; Issuer is a corporation organized and operating in the
U.S. with assets > $500 million
Complies
Negotiable Certificates of Deposit "A" long-term issuer rated category or higher by at least two NRSROs; and/or "A-1" short term rated or higher by at least
two NRSROs; 30% maximum; 5% max per issuer Complies
Federally Insured Certificates of Deposit
(CDs)/ Time Deposit (TDs)
20% maximum (combined FDIC insured and collateralized TD/ CD); Amount per institution is limited to maximum covered
under federal insurance Complies
Collateralized Certificates of Deposit
(CDs)/Time Deposit (TDs)/
"A" long-term debt rated category or higher by at least two NRSROs; and/or "A-1" short term debt rated or higher by at
least two NRSROs; 20% maximum (combined FDIC and collateralized TD/ CD)Complies
Corporate Medium Term Notes "A" rated category or better by at least two NRSROs; 30% maximum; 5% max per issuer; Issued by corporations organized
and operating within the U.S. or by depository institutions licensed by the U.S. or any state and operating within the U.S. Complies
Mutual Fund & Money Market Mutual
Fund
Highest rating or "AAA" rated by two NRSROs; SEC registered adviser with AUM >$500 million and experience > 5 years;
20% maximum in Mutual Funds and Money Market Mutual Funds; 10% max per one Mutual Fund; 20% max in Money
Market Mutual Fund
Complies
Asset-Backed (ABS), Mortgage-Backed
Securities; Mortgage Pass-Throughs;
Collateralized Mortgage Obligations
(CMOs)
"AA" rated category or better by at least two NRSROs; "A" issuer debt rated category or higher by at least two NRSROs; 20%
maximum; 5% max per issuer Complies
Local Agency Investment Fund (LAIF)70% of the portfolio may be invested in LAIF, up to the maximum permitted balance; Not used by investment adviser Complies
Local Government Investment Pools and
Joint Powers Authority Pools
Riverside County Investment Fund- 70% max of the total portfolio
JPA Pools- 50% max of the total portfolio
Repurchase Agreements 102% collateralized; 1 year max maturity Complies
Prohibited Securities Inverse floaters; Ranges notes, Interest-only strips from mortgaged backed securities; Zero interest accrual securities;
Margin purchasing or selling; Reverse repurchase agreements; Foreign currency denominated securities Complies
Max Callables 20% maximum callable securities (does not include "make whole call" securities)Complies
Max Per Issuer 5% of portfolio per issuer (except U.S. Government, its Agencies and enterprises, Money Market Mutual Funds, Mutual
Funds, LAIF, LGIP, Supranationals, or unless otherwise specified in the investment policy)Complies
Maximum maturity 5 years Complies
City of San Jacinto
As of July 31, 2021
Assets managed by Chandler Asset Management are in full compliance with state law and with the City's investment policy.
Statement of Compliance
3.A.3.a
Packet Pg. 24 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
BOOK VALUE RECONCILIATION
BEGINNING BOOK VALUE $11,065,340.89
Acquisition
+ Security Purchases $44,995.99
+ Money Market Fund Purchases $82,300.35
+ Money Market Contributions $0.00
+ Security Contributions $0.00
+ Security Transfers $0.00
Total Acquisitions $127,296.34
Dispositions
- Security Sales $50,053.00
- Money Market Fund Sales $44,995.99
- MMF Withdrawals $1,047.41
- Security Withdrawals $0.00
- Security Transfers $0.00
- Other Dispositions $0.00
- Maturites $0.00
- Calls $0.00
- Principal Paydowns $13,053.95
Total Dispositions $109,150.35
Amortization/Accretion
+/- Net Accretion ($1,362.76)
($1,362.76)
Gain/Loss on Dispositions
+/- Realized Gain/Loss $85.90
$85.90
ENDING BOOK VALUE $11,082,210.02
CASH TRANSACTION SUMMARY
BEGINNING BALANCE $3,583.14
Acquisition
Contributions $0.00
Security Sale Proceeds $50,053.00
Accrued Interest Received $256.94
Interest Received $18,935.73
Dividend Received $0.73
Principal on Maturities $0.00
Interest on Maturities $0.00
Calls/Redemption (Principal)$0.00
Interest from Calls/Redemption $0.00
Principal Paydown $13,053.95
Total Acquisitions $82,300.35
Dispositions
Withdrawals $1,047.41
Security Purchase $44,995.99
Accrued Interest Paid $0.00
Total Dispositions $46,043.40
ENDING BOOK VALUE $39,840.09
Reconciliation Summary
As of July 31, 2021
City of San Jacinto California
Account #10167
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 3
3.A.3.a
Packet Pg. 25 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Holdings Report
As of July 31, 2021
City of San Jacinto
Account #10167
CUSIP Security Description Par Value/Units Purchase Date
Book Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody/S&P
Fitch
Maturity
Duration
ABS
43815HAC1 Honda Auto Receivables Trust 2018-3
A3
2.95% Due 8/22/2022
8,783.71 08/21/2018
2.98%
8,782.51
8,783.39
100.43
0.15%
8,821.60
7.20
0.08%
38.21
Aaa / NR
AAA
1.06
0.16
43815NAC8 Honda Auto Receivables Trust 2019-3
A3
1.78% Due 8/15/2023
68,501.34 08/20/2019
1.79%
68,500.77
68,501.13
100.87
0.19%
69,098.33
54.19
0.61%
597.20
Aaa / AAA
NR
2.04
0.55
477870AC3 John Deere Owner Trust 2019-B A3
2.21% Due 12/15/2023
26,599.54 07/16/2019
2.23%
26,593.90
26,596.50
101.23
0.07%
26,927.59
26.13
0.24%
331.09
Aaa / NR
AAA
2.38
0.58
65479JAD5 Nissan Auto Receivables Owner 2019-C
A3
1.93% Due 7/15/2024
82,599.72 10/16/2019
1.94%
82,595.36
82,597.00
101.06
0.34%
83,477.76
70.85
0.74%
880.76
Aaa / AAA
NR
2.96
0.67
47789KAC7 John Deere Owner Trust 2020-A A3
1.1% Due 8/15/2024
60,000.00 03/04/2020
1.11%
59,996.33
59,997.48
100.91
0.14%
60,543.66
29.33
0.53%
546.18
Aaa / NR
AAA
3.04
0.95
89237VAB5 Toyota Auto Receivables Trust 2020-C
A3
0.44% Due 10/15/2024
55,000.00 07/21/2020
0.44%
54,995.77
54,996.79
100.26
0.19%
55,141.02
10.76
0.49%
144.23
Aaa / AAA
NR
3.21
1.01
43813KAC6 Honda Auto Receivables Trust 2020-3
A3
0.37% Due 10/18/2024
90,000.00 09/22/2020
0.38%
89,986.78
89,990.31
100.20
0.22%
90,180.81
12.03
0.79%
190.50
NR / AAA
AAA
3.22
1.32
47787NAC3 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
25,000.00 07/14/2020
0.52%
24,996.19
24,997.31
100.30
0.22%
25,075.70
5.67
0.22%
78.39
Aaa / NR
AAA
3.30
1.05
58769KAD6 Mercedes-Benz Auto Lease Trust 2021-
B A3
0.4% Due 11/15/2024
55,000.00 06/22/2021
0.40%
54,995.85
54,996.00
100.12
0.34%
55,065.18
9.78
0.49%
69.18
NR / AAA
AAA
3.30
1.98
89236XAC0 Toyota Auto Receivables 2020-D A3
0.35% Due 1/15/2025
45,000.00 10/06/2020
0.36%
44,991.62
44,993.19
100.10
0.27%
45,043.61
7.00
0.40%
50.42
NR / AAA
AAA
3.46
1.23
43813GAC5 Honda Auto Receivables Trust 2021-1
A3
0.27% Due 4/21/2025
30,000.00 02/17/2021
0.27%
29,999.45
29,999.53
100.01
0.26%
30,004.17
2.25
0.26%
4.64
Aaa / NR
AAA
3.73
1.48
89240BAC2 Toyota Auto Receivables Owners 2021-
A A3
0.26% Due 5/15/2025
75,000.00 02/02/2021
0.27%
74,986.08
74,988.22
99.99
0.27%
74,993.10
8.67
0.66%
4.88
Aaa / NR
AAA
3.79
1.55
47788UAC6 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
40,000.00 03/02/2021
0.37%
39,992.31
39,993.15
100.09
0.32%
40,034.60
6.40
0.35%
41.45
Aaa / NR
AAA
4.13
2.05
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 4
3.A.3.a
Packet Pg. 26 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Holdings Report
As of July 31, 2021
City of San Jacinto
Account #10167
CUSIP Security Description Par Value/Units Purchase Date
Book Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody/S&P
Fitch
Maturity
Duration
ABS
47789QAC4 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
45,000.00 07/13/2021
0.52%
44,995.99
44,996.02
100.22
0.44%
45,096.75
6.50
0.40%
100.73
Aaa / NR
AAA
4.63
2.57
Total ABS 706,484.31 0.86%
706,408.91
706,426.02 0.25%
709,503.88
256.76
6.26%
3,077.86
Aaa / AAA
AAA
3.25
1.26
AGENCY
3135G0N82 FNMA Note
1.25% Due 8/17/2021
265,000.00 01/26/2017
2.02%
256,233.80
264,915.46
100.05
0.12%
265,132.50
1,509.03
2.35%
217.04
Aaa / AA+
AAA
0.05
0.04
313378WG2 FHLB Note
2.5% Due 3/11/2022
300,000.00 03/13/2018
2.65%
298,323.00
299,744.65
101.48
0.08%
304,429.20
2,916.67
2.71%
4,684.55
Aaa / AA+
NR
0.61
0.60
313379Q69 FHLB Note
2.125% Due 6/10/2022
200,000.00 06/20/2017
1.87%
202,370.00
200,408.71
101.74
0.10%
203,473.60
602.08
1.80%
3,064.89
Aaa / AA+
AAA
0.86
0.85
3135G0W33 FNMA Note
1.375% Due 9/6/2022
200,000.00 09/05/2019
1.49%
199,304.00
199,745.35
101.38
0.11%
202,765.20
1,107.64
1.80%
3,019.85
Aaa / AA+
AAA
1.10
1.09
3130A3KM5 FHLB Note
2.5% Due 12/9/2022
100,000.00 09/10/2019
1.60%
102,813.00
101,177.04
103.18
0.15%
103,175.90
361.11
0.91%
1,998.86
Aaa / AA+
NR
1.36
1.34
3135G0T94 FNMA Note
2.375% Due 1/19/2023
290,000.00 10/17/2018
3.07%
281,993.10
287,236.51
103.30
0.13%
299,555.50
229.58
2.64%
12,318.99
Aaa / AA+
AAA
1.47
1.45
3137EAEN5 FHLMC Note
2.75% Due 6/19/2023
200,000.00 11/13/2018
3.08%
197,176.00
198,843.81
104.81
0.19%
209,621.00
641.67
1.85%
10,777.19
Aaa / AA+
AAA
1.88
1.84
313383YJ4 FHLB Note
3.375% Due 9/8/2023
200,000.00 12/27/2018
2.73%
205,630.00
202,521.19
106.66
0.20%
213,322.60
2,681.25
1.90%
10,801.41
Aaa / AA+
NR
2.11
2.02
3137EAEY1 FHLMC Note
0.125% Due 10/16/2023
180,000.00 10/22/2020
0.26%
179,253.00
179,446.62
99.73
0.25%
179,521.92
65.63
1.58%
75.30
Aaa / AA+
AAA
2.21
2.20
3130A0F70 FHLB Note
3.375% Due 12/8/2023
220,000.00 01/30/2019
2.71%
226,593.40
223,196.24
107.29
0.27%
236,027.88
1,093.13
2.09%
12,831.64
Aaa / AA+
AAA
2.36
2.27
3135G0V34 FNMA Note
2.5% Due 2/5/2024
375,000.00 03/24/2020
0.82%
398,835.00
390,496.13
105.58
0.27%
395,919.00
4,583.33
3.53%
5,422.87
Aaa / AA+
AAA
2.52
2.42
3130A1XJ2 FHLB Note
2.875% Due 6/14/2024
210,000.00 Various
1.96%
219,055.20
215,205.63
107.15
0.37%
225,008.50
788.22
1.99%
9,802.87
Aaa / AA+
NR
2.87
2.76
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 5
3.A.3.a
Packet Pg. 27 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Holdings Report
As of July 31, 2021
City of San Jacinto
Account #10167
CUSIP Security Description Par Value/Units Purchase Date
Book Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody/S&P
Fitch
Maturity
Duration
AGENCY
3130A2UW4 FHLB Note
2.875% Due 9/13/2024
150,000.00 10/29/2019
1.76%
157,737.00
154,950.81
107.69
0.39%
161,537.25
1,653.13
1.44%
6,586.44
Aaa / AA+
AAA
3.12
2.97
3130A3GE8 FHLB Note
2.75% Due 12/13/2024
250,000.00 12/16/2019
1.77%
261,672.50
257,875.58
107.80
0.41%
269,503.75
916.67
2.38%
11,628.17
Aaa / AA+
NR
3.37
3.23
3135G0X24 FNMA Note
1.625% Due 1/7/2025
225,000.00 01/16/2020
1.69%
224,298.00
224,515.13
104.11
0.42%
234,245.25
243.75
2.07%
9,730.12
Aaa / AA+
AAA
3.44
3.34
3137EAEP0 FHLMC Note
1.5% Due 2/12/2025
245,000.00 02/13/2020
1.52%
244,811.35
244,866.55
103.59
0.47%
253,792.07
1,725.21
2.25%
8,925.52
Aaa / AA+
AAA
3.54
3.42
3135G03U5 FNMA Note
0.625% Due 4/22/2025
310,000.00 Various
0.63%
309,949.40
309,968.99
100.44
0.50%
311,379.19
532.82
2.75%
1,410.20
Aaa / AA+
AAA
3.73
3.67
3130AJKW8 FHLB Note
0.5% Due 6/13/2025
225,000.00 06/24/2020
0.52%
224,824.50
224,863.39
99.79
0.56%
224,525.03
150.00
1.98%
(338.36)
Aaa / AA+
AAA
3.87
3.82
3137EAEU9 FHLMC Note
0.375% Due 7/21/2025
145,000.00 07/21/2020
0.48%
144,277.90
144,425.96
99.27
0.56%
143,945.71
15.10
1.27%
(480.25)
Aaa / AA+
AAA
3.98
3.93
3135G05X7 FNMA Note
0.375% Due 8/25/2025
230,000.00 08/25/2020
0.47%
228,923.60
229,123.65
99.11
0.60%
227,959.44
373.75
2.01%
(1,164.21)
Aaa / AA+
AAA
4.07
4.02
3137EAEX3 FHLMC Note
0.375% Due 9/23/2025
230,000.00 09/23/2020
0.44%
229,307.70
229,425.36
99.12
0.59%
227,972.55
306.67
2.01%
(1,452.81)
Aaa / AA+
AAA
4.15
4.10
3135G06G3 FNMA Note
0.5% Due 11/7/2025
250,000.00 11/09/2020
0.57%
249,105.00
249,233.77
99.52
0.61%
248,806.00
291.67
2.20%
(427.77)
Aaa / AA+
AAA
4.27
4.21
Total Agency 5,000,000.00 1.55%
5,042,486.45
5,032,186.53 0.33%
5,141,619.04
22,788.11
45.51%
109,432.51
Aaa / AA+
AAA
2.58
2.52
CORPORATE
89236TDP7 Toyota Motor Credit Corp Note
2.6% Due 1/11/2022
130,000.00 01/28/2019
2.98%
128,629.80
129,792.63
101.05
0.23%
131,370.59
187.78
1.16%
1,577.96
A1 / A+
A+
0.45
0.44
06051GEU9 Bank of America Corp Note
3.3% Due 1/11/2023
130,000.00 01/28/2019
3.29%
130,059.80
130,021.90
104.37
0.27%
135,682.56
238.33
1.20%
5,660.66
A2 / A-
AA-
1.45
1.42
06406RAE7 Bank of NY Mellon Corp Callable Note
Cont 12/29/2022
2.95% Due 1/29/2023
145,000.00 09/09/2019
1.97%
149,541.40
146,940.93
103.85
0.22%
150,580.33
23.76
1.33%
3,639.40
A1 / A
AA-
1.50
1.39
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 6
3.A.3.a
Packet Pg. 28 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Holdings Report
As of July 31, 2021
City of San Jacinto
Account #10167
CUSIP Security Description Par Value/Units Purchase Date
Book Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody/S&P
Fitch
Maturity
Duration
CORPORATE
084670BR8 Berkshire Hathaway Callable Note Cont
1/15/2023
2.75% Due 3/15/2023
150,000.00 08/26/2019
1.83%
154,525.50
151,947.87
103.64
0.24%
155,461.80
1,558.33
1.38%
3,513.93
Aa2 / AA
A+
1.62
1.42
037833AK6 Apple Inc Note
2.4% Due 5/3/2023
200,000.00 05/20/2019
2.63%
198,284.00
199,238.39
103.70
0.29%
207,394.00
1,173.33
1.84%
8,155.61
Aa1 / AA+
NR
1.76
1.72
24422EUR8 John Deere Capital Corp Note
3.45% Due 1/10/2024
150,000.00 03/14/2019
2.95%
153,322.50
151,684.86
107.33
0.43%
160,988.40
301.88
1.42%
9,303.54
A2 / A
A
2.45
2.36
808513BN4 Charles Schwab Corp Callable Note
Cont 2/18/2024
0.75% Due 3/18/2024
40,000.00 03/16/2021
0.77%
39,980.00
39,982.48
100.73
0.46%
40,293.20
110.83
0.36%
310.72
A2 / A
A
2.63
2.52
023135BW5 Amazon.com Inc Callable Note Cont
11/12/2021
0.45% Due 5/12/2024
90,000.00 05/10/2021
0.50%
89,868.60
89,878.31
99.98
0.46%
89,980.83
88.88
0.79%
102.52
A1 / AA
AA-
2.78
2.76
46625HJX9 JP Morgan Chase Note
3.625% Due 5/13/2024
145,000.00 12/19/2019
2.20%
153,560.80
150,429.32
108.50
0.55%
157,318.77
1,138.85
1.40%
6,889.45
A2 / A-
AA-
2.79
2.65
91324PEC2 United Health Group Inc Callable Note
Cont 4/15/2026
1.15% Due 5/15/2026
30,000.00 Various
1.08%
30,097.10
30,094.58
100.86
0.96%
30,258.81
69.00
0.27%
164.23
A3 / A+
A
4.79
4.57
89236TJK2 Toyota Motor Credit Corp Note
1.125% Due 6/18/2026
120,000.00 06/15/2021
1.13%
119,947.20
119,948.47
100.41
1.04%
120,486.12
161.25
1.06%
537.65
A1 / A+
A+
4.88
4.73
Total Corporate 1,330,000.00 2.18%
1,347,816.70
1,339,959.74 0.41%
1,379,815.41
5,052.22
12.20%
39,855.67
A1 / A+
A+
2.19
2.10
MONEY MARKET FUND
31846V203 First American Govt Obligation Fund
Class Y
39,840.09 Various
0.01%
39,840.09
39,840.09
1.00
0.01%
39,840.09
0.00
0.35%
0.00
Aaa / AAA
AAA
0.00
0.00
Total Money Market Fund 39,840.09 0.01%
39,840.09
39,840.09 0.01%
39,840.09
0.00
0.35%
0.00
Aaa / AAA
AAA
0.00
0.00
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 7
3.A.3.a
Packet Pg. 29 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Holdings Report
As of July 31, 2021
City of San Jacinto
Account #10167
CUSIP Security Description Par Value/Units Purchase Date
Book Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody/S&P
Fitch
Maturity
Duration
SUPRANATIONAL
4581X0DV7 Inter-American Dev Bank Note
0.875% Due 4/20/2026
230,000.00 04/13/2021
0.97%
228,946.60
229,006.02
100.82
0.70%
231,895.89
564.62
2.05%
2,889.87
Aaa / AAA
AAA
4.72
4.61
Total Supranational 230,000.00 0.97%
228,946.60
229,006.02 0.70%
231,895.89
564.62
2.05%
2,889.87
Aaa / AAA
AAA
4.72
4.61
US TREASURY
912828G53 US Treasury Note
1.875% Due 11/30/2021
120,000.00 04/26/2017
1.81%
120,356.65
120,025.72
100.60
0.08%
120,717.00
381.15
1.07%
691.28
Aaa / AA+
AAA
0.33
0.33
912828W89 US Treasury Note
1.875% Due 3/31/2022
200,000.00 04/26/2018
2.75%
193,531.25
198,908.34
101.19
0.09%
202,375.00
1,260.25
1.79%
3,466.66
Aaa / AA+
AAA
0.67
0.66
912828L24 US Treasury Note
1.875% Due 8/31/2022
150,000.00 07/22/2019
1.77%
150,462.89
150,161.09
101.93
0.10%
152,888.70
1,176.97
1.36%
2,727.61
Aaa / AA+
AAA
1.08
1.07
912828M80 US Treasury Note
2% Due 11/30/2022
200,000.00 04/11/2019
2.31%
197,851.56
199,211.97
102.51
0.12%
205,015.60
677.60
1.81%
5,803.63
Aaa / AA+
AAA
1.33
1.32
9128284D9 US Treasury Note
2.5% Due 3/31/2023
210,000.00 Various
2.95%
206,053.12
208,542.74
103.89
0.16%
218,162.07
1,764.35
1.94%
9,619.33
Aaa / AA+
AAA
1.67
1.63
912828Y61 US Treasury Note
2.75% Due 7/31/2023
175,000.00 12/27/2018
2.59%
176,223.63
175,532.24
105.11
0.19%
183,934.63
13.08
1.62%
8,402.39
Aaa / AA+
AAA
2.00
1.96
912828W71 US Treasury Note
2.125% Due 3/31/2024
210,000.00 12/05/2019
1.63%
214,331.25
212,672.36
104.85
0.30%
220,188.36
1,499.69
1.95%
7,516.00
Aaa / AA+
AAA
2.67
2.59
912828Y87 US Treasury Note
1.75% Due 7/31/2024
220,000.00 01/17/2020
1.63%
221,160.16
220,768.53
104.18
0.35%
229,203.92
10.46
2.02%
8,435.39
Aaa / AA+
AAA
3.00
2.93
9128282U3 US Treasury Note
1.875% Due 8/31/2024
230,000.00 12/12/2019
1.76%
231,230.86
230,804.38
104.60
0.37%
240,574.71
1,804.69
2.14%
9,770.33
Aaa / AA+
AAA
3.09
2.99
912828YV6 US Treasury Note
1.5% Due 11/30/2024
230,000.00 12/12/2019
1.74%
227,421.48
228,270.09
103.57
0.42%
238,211.69
584.43
2.10%
9,941.60
Aaa / AA+
AAA
3.34
3.25
912828ZC7 US Treasury Note
1.125% Due 2/28/2025
400,000.00 03/24/2020
0.51%
412,046.88
408,742.52
102.31
0.47%
409,234.40
1,883.15
3.62%
491.88
Aaa / AA+
AAA
3.58
3.50
912828ZT0 US Treasury Note
0.25% Due 5/31/2025
230,000.00 06/04/2020
0.39%
228,373.83
228,750.68
98.96
0.52%
227,619.04
97.40
2.01%
(1,131.64)
Aaa / AA+
AAA
3.84
3.81
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 8
3.A.3.a
Packet Pg. 30 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Holdings Report
As of July 31, 2021
City of San Jacinto
Account #10167
CUSIP Security Description Par Value/Units Purchase Date
Book Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody/S&P
Fitch
Maturity
Duration
US TREASURY
9128284Z0 US Treasury Note
2.75% Due 8/31/2025
155,000.00 06/24/2021
0.72%
167,950.98
167,637.38
108.84
0.56%
168,695.65
1,783.76
1.50%
1,058.27
Aaa / AA+
AAA
4.09
3.85
91282CAZ4 US Treasury Note
0.375% Due 11/30/2025
240,000.00 12/15/2020
0.37%
240,018.75
240,016.39
99.02
0.60%
237,656.16
152.46
2.10%
(2,360.23)
Aaa / AA+
AAA
4.34
4.29
91282CBC4 US Treasury Note
0.375% Due 12/31/2025
250,000.00 01/28/2021
0.41%
249,541.02
249,588.02
98.91
0.62%
247,285.25
81.52
2.18%
(2,302.77)
Aaa / AA+
AAA
4.42
4.37
91282CBQ3 US Treasury Note
0.5% Due 2/28/2026
250,000.00 03/24/2021
0.82%
246,123.05
246,400.74
99.34
0.65%
248,359.50
523.10
2.19%
1,958.76
Aaa / AA+
AAA
4.58
4.51
91282CBT7 US Treasury Note
0.75% Due 3/31/2026
250,000.00 Various
0.86%
248,714.06
248,758.43
100.43
0.66%
251,074.26
630.12
2.22%
2,315.83
Aaa / AA+
AAA
4.67
4.57
Total US Treasury 3,720,000.00 1.36%
3,731,391.42
3,734,791.62 0.40%
3,801,195.94
14,324.18
33.63%
66,404.32
Aaa / AA+
AAA
3.06
2.99
TOTAL PORTFOLIO 11,026,324.40 1.50%
11,096,890.17
11,082,210.02 0.36%
11,303,870.25
42,985.89
100.00%
221,660.23
Aa1 / AA+
AAA
2.77
2.58
TOTAL MARKET VALUE PLUS ACCRUED 11,346,856.14
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 9
3.A.3.a
Packet Pg. 31 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Transaction Ledger
As of July 31, 2021
City of San Jacinto
Account #10167
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 07/01/2021 31846V203 0.73 First American Govt Obligation Fund
Class Y
1.000 0.01%0.73 0.00 0.73 0.00
Purchase 07/07/2021 31846V203 1,828.13 First American Govt Obligation Fund
Class Y
1.000 0.01%1,828.13 0.00 1,828.13 0.00
Purchase 07/10/2021 31846V203 2,587.50 First American Govt Obligation Fund
Class Y
1.000 0.01%2,587.50 0.00 2,587.50 0.00
Purchase 07/11/2021 31846V203 3,835.00 First American Govt Obligation Fund
Class Y
1.000 0.01%3,835.00 0.00 3,835.00 0.00
Purchase 07/15/2021 31846V203 50,309.94 First American Govt Obligation Fund
Class Y
1.000 0.01%50,309.94 0.00 50,309.94 0.00
Purchase 07/15/2021 31846V203 16.25 First American Govt Obligation Fund
Class Y
1.000 0.01%16.25 0.00 16.25 0.00
Purchase 07/15/2021 31846V203 20.17 First American Govt Obligation Fund
Class Y
1.000 0.01%20.17 0.00 20.17 0.00
Purchase 07/15/2021 31846V203 13.13 First American Govt Obligation Fund
Class Y
1.000 0.01%13.13 0.00 13.13 0.00
Purchase 07/15/2021 31846V203 9.78 First American Govt Obligation Fund
Class Y
1.000 0.01%9.78 0.00 9.78 0.00
Purchase 07/15/2021 31846V203 55.00 First American Govt Obligation Fund
Class Y
1.000 0.01%55.00 0.00 55.00 0.00
Purchase 07/15/2021 31846V203 12.00 First American Govt Obligation Fund
Class Y
1.000 0.01%12.00 0.00 12.00 0.00
Purchase 07/15/2021 31846V203 10.63 First American Govt Obligation Fund
Class Y
1.000 0.01%10.63 0.00 10.63 0.00
Purchase 07/15/2021 31846V203 6,428.64 First American Govt Obligation Fund
Class Y
1.000 0.01%6,428.64 0.00 6,428.64 0.00
Purchase 07/15/2021 31846V203 1,549.05 First American Govt Obligation Fund
Class Y
1.000 0.01%1,549.05 0.00 1,549.05 0.00
Purchase 07/15/2021 31846V203 2,536.99 First American Govt Obligation Fund
Class Y
1.000 0.01%2,536.99 0.00 2,536.99 0.00
Purchase 07/19/2021 31846V203 3,443.75 First American Govt Obligation Fund
Class Y
1.000 0.01%3,443.75 0.00 3,443.75 0.00
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 10
3.A.3.a
Packet Pg. 32 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Transaction Ledger
As of July 31, 2021
City of San Jacinto
Account #10167
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 07/19/2021 31846V203 27.75 First American Govt Obligation Fund
Class Y
1.000 0.01%27.75 0.00 27.75 0.00
Purchase 07/21/2021 31846V203 271.88 First American Govt Obligation Fund
Class Y
1.000 0.01%271.88 0.00 271.88 0.00
Purchase 07/21/2021 31846V203 6.75 First American Govt Obligation Fund
Class Y
1.000 0.01%6.75 0.00 6.75 0.00
Purchase 07/21/2021 31846V203 2,867.28 First American Govt Obligation Fund
Class Y
1.000 0.01%2,867.28 0.00 2,867.28 0.00
Purchase 07/21/2021 47789QAC4 45,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
99.991 0.52%44,995.99 0.00 44,995.99 0.00
Purchase 07/29/2021 31846V203 2,138.75 First American Govt Obligation Fund
Class Y
1.000 0.01%2,138.75 0.00 2,138.75 0.00
Purchase 07/31/2021 31846V203 4,331.25 First American Govt Obligation Fund
Class Y
1.000 0.01%4,331.25 0.00 4,331.25 0.00
Subtotal 127,300.35 127,296.34 0.00 127,296.34 0.00
Short Sale 07/21/2021 31846V203 -44,995.99 First American Govt Obligation Fund
Class Y
1.000 -44,995.99 0.00 -44,995.99 0.00
Subtotal -44,995.99 -44,995.99 0.00 -44,995.99 0.00
TOTAL ACQUISITIONS 82,304.36 82,300.35 0.00 82,300.35 0.00
DISPOSITIONS
Closing
Purchase
07/21/2021 31846V203 -44,995.99 First American Govt Obligation Fund
Class Y
1.000 -44,995.99 0.00 -44,995.99 0.00
Subtotal -44,995.99 -44,995.99 0.00 -44,995.99 0.00
Sale 07/15/2021 3135G0N82 50,000.00 FNMA Note
1.25% Due 8/17/2021
100.106 2.02%50,053.00 256.94 50,309.94 85.90
Sale 07/21/2021 31846V203 44,995.99 First American Govt Obligation Fund
Class Y
1.000 0.01%44,995.99 0.00 44,995.99 0.00
Subtotal 94,995.99 95,048.99 256.94 95,305.93 85.90
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 11
3.A.3.a
Packet Pg. 33 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Transaction Ledger
As of July 31, 2021
City of San Jacinto
Account #10167
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
DISPOSITIONS
Paydown 07/15/2021 43815NAC8 6,317.66 Honda Auto Receivables Trust 2019-3
A3
1.78% Due 8/15/2023
100.000 6,317.66 110.98 6,428.64 0.00
Paydown 07/15/2021 477870AC3 1,497.30 John Deere Owner Trust 2019-B A3
2.21% Due 12/15/2023
100.000 1,497.30 51.75 1,549.05 0.00
Paydown 07/15/2021 47787NAC3 0.00 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
100.000 0.00 10.63 10.63 0.00
Paydown 07/15/2021 47788UAC6 0.00 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
100.000 0.00 12.00 12.00 0.00
Paydown 07/15/2021 47789KAC7 0.00 John Deere Owner Trust 2020-A A3
1.1% Due 8/15/2024
100.000 0.00 55.00 55.00 0.00
Paydown 07/15/2021 58769KAD6 0.00 Mercedes-Benz Auto Lease Trust 2021-
B A3
0.4% Due 11/15/2024
100.000 0.00 9.78 9.78 0.00
Paydown 07/15/2021 65479JAD5 2,400.28 Nissan Auto Receivables Owner 2019-C
A3
1.93% Due 7/15/2024
100.000 2,400.28 136.71 2,536.99 0.00
Paydown 07/15/2021 89236XAC0 0.00 Toyota Auto Receivables 2020-D A3
0.35% Due 1/15/2025
100.000 0.00 13.13 13.13 0.00
Paydown 07/15/2021 89237VAB5 0.00 Toyota Auto Receivables Trust 2020-C
A3
0.44% Due 10/15/2024
100.000 0.00 20.17 20.17 0.00
Paydown 07/15/2021 89240BAC2 0.00 Toyota Auto Receivables Owners 2021-
A A3
0.26% Due 5/15/2025
100.000 0.00 16.25 16.25 0.00
Paydown 07/19/2021 43813KAC6 0.00 Honda Auto Receivables Trust 2020-3
A3
0.37% Due 10/18/2024
100.000 0.00 27.75 27.75 0.00
Paydown 07/21/2021 43813GAC5 0.00 Honda Auto Receivables Trust 2021-1
A3
0.27% Due 4/21/2025
100.000 0.00 6.75 6.75 0.00
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 12
3.A.3.a
Packet Pg. 34 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Transaction Ledger
As of July 31, 2021
City of San Jacinto
Account #10167
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
DISPOSITIONS
Paydown 07/21/2021 43815HAC1 2,838.71 Honda Auto Receivables Trust 2018-3
A3
2.95% Due 8/22/2022
100.000 2,838.71 28.57 2,867.28 0.00
Subtotal 13,053.95 13,053.95 499.47 13,553.42 0.00
Security
Withdrawal
07/06/2021 31846V203 943.24 First American Govt Obligation Fund
Class Y
1.000 943.24 0.00 943.24 0.00
Security
Withdrawal
07/26/2021 31846V203 104.17 First American Govt Obligation Fund
Class Y
1.000 104.17 0.00 104.17 0.00
Subtotal 1,047.41 1,047.41 0.00 1,047.41 0.00
TOTAL DISPOSITIONS 64,101.36 64,154.36 756.41 64,910.77 85.90
OTHER TRANSACTIONS
Interest 07/07/2021 3135G0X24 225,000.00 FNMA Note
1.625% Due 1/7/2025
0.000 1,828.13 0.00 1,828.13 0.00
Interest 07/10/2021 24422EUR8 150,000.00 John Deere Capital Corp Note
3.45% Due 1/10/2024
0.000 2,587.50 0.00 2,587.50 0.00
Interest 07/11/2021 06051GEU9 130,000.00 Bank of America Corp Note
3.3% Due 1/11/2023
0.000 2,145.00 0.00 2,145.00 0.00
Interest 07/11/2021 89236TDP7 130,000.00 Toyota Motor Credit Corp Note
2.6% Due 1/11/2022
0.000 1,690.00 0.00 1,690.00 0.00
Interest 07/19/2021 3135G0T94 290,000.00 FNMA Note
2.375% Due 1/19/2023
0.000 3,443.75 0.00 3,443.75 0.00
Interest 07/21/2021 3137EAEU9 145,000.00 FHLMC Note
0.375% Due 7/21/2025
0.000 271.88 0.00 271.88 0.00
Interest 07/29/2021 06406RAE7 145,000.00 Bank of NY Mellon Corp Callable Note
Cont 12/29/2022
2.95% Due 1/29/2023
0.000 2,138.75 0.00 2,138.75 0.00
Interest 07/31/2021 912828Y61 175,000.00 US Treasury Note
2.75% Due 7/31/2023
0.000 2,406.25 0.00 2,406.25 0.00
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 13
3.A.3.a
Packet Pg. 35 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Transaction Ledger
As of July 31, 2021
City of San Jacinto
Account #10167
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
OTHER TRANSACTIONS
Interest 07/31/2021 912828Y87 220,000.00 US Treasury Note
1.75% Due 7/31/2024
0.000 1,925.00 0.00 1,925.00 0.00
Subtotal 1,610,000.00 18,436.26 0.00 18,436.26 0.00
Dividend 07/01/2021 31846V203 3,583.14 First American Govt Obligation Fund
Class Y
0.000 0.73 0.00 0.73 0.00
Subtotal 3,583.14 0.73 0.00 0.73 0.00
TOTAL OTHER TRANSACTIONS 1,613,583.14 18,436.99 0.00 18,436.99 0.00
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 14
3.A.3.a
Packet Pg. 36 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Income Earned
As of July 31, 2021
City of San Jacinto
Account #10167
CUSIP Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
FIXED INCOME
023135BW5 Amazon.com Inc
Callable Note Cont 11/12/2021
0.45% Due 05/12/2024
05/10/2021
05/12/2021
90,000.00
89,874.59
0.00
0.00
89,878.31
55.13
0.00
88.88
33.75
3.72
0.00
3.72
37.47
37.47
037833AK6 Apple Inc
Note
2.4% Due 05/03/2023
05/20/2019
05/22/2019
200,000.00
199,201.50
0.00
0.00
199,238.39
773.33
0.00
1,173.33
400.00
36.89
0.00
36.89
436.89
436.89
06051GEU9 Bank of America Corp
Note
3.3% Due 01/11/2023
01/28/2019
01/30/2019
130,000.00
130,023.18
0.00
0.00
130,021.90
2,025.83
2,145.00
238.33
357.50
0.00
1.28
(1.28)
356.22
356.22
06406RAE7 Bank of NY Mellon Corp
Callable Note Cont 12/29/2022
2.95% Due 01/29/2023
09/09/2019
09/11/2019
145,000.00
147,057.76
0.00
0.00
146,940.93
1,806.06
2,138.75
23.76
356.45
0.00
116.83
(116.83)
239.62
239.62
084670BR8 Berkshire Hathaway
Callable Note Cont 1/15/2023
2.75% Due 03/15/2023
08/26/2019
08/28/2019
150,000.00
152,061.37
0.00
0.00
151,947.87
1,214.58
0.00
1,558.33
343.75
0.00
113.50
(113.50)
230.25
230.25
24422EUR8 John Deere Capital Corp
Note
3.45% Due 01/10/2024
03/14/2019
03/18/2019
150,000.00
151,743.42
0.00
0.00
151,684.86
2,458.13
2,587.50
301.88
431.25
0.00
58.56
(58.56)
372.69
372.69
3130A0F70 FHLB
Note
3.375% Due 12/08/2023
01/30/2019
01/31/2019
220,000.00
223,311.58
0.00
0.00
223,196.24
474.38
0.00
1,093.13
618.75
0.00
115.34
(115.34)
503.41
503.41
3130A1XJ2 FHLB
Note
2.875% Due 06/14/2024
Various
Various
210,000.00
215,359.61
0.00
0.00
215,205.63
285.10
0.00
788.22
503.12
0.00
153.98
(153.98)
349.14
349.14
3130A2UW4 FHLB
Note
2.875% Due 09/13/2024
10/29/2019
10/30/2019
150,000.00
155,085.56
0.00
0.00
154,950.81
1,293.75
0.00
1,653.13
359.38
0.00
134.75
(134.75)
224.63
224.63
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 15
3.A.3.a
Packet Pg. 37 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Income Earned
As of July 31, 2021
City of San Jacinto
Account #10167
CUSIP Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
3130A3GE8 FHLB
Note
2.75% Due 12/13/2024
12/16/2019
12/17/2019
250,000.00
258,074.07
0.00
0.00
257,875.58
343.75
0.00
916.67
572.92
0.00
198.49
(198.49)
374.43
374.43
3130A3KM5 FHLB
Note
2.5% Due 12/09/2022
09/10/2019
09/13/2019
100,000.00
101,250.75
0.00
0.00
101,177.04
152.78
0.00
361.11
208.33
0.00
73.71
(73.71)
134.62
134.62
3130AJKW8 FHLB
Note
0.5% Due 06/13/2025
06/24/2020
06/25/2020
225,000.00
224,860.39
0.00
0.00
224,863.39
56.25
0.00
150.00
93.75
3.00
0.00
3.00
96.75
96.75
313378WG2 FHLB
Note
2.5% Due 03/11/2022
03/13/2018
03/14/2018
300,000.00
299,709.00
0.00
0.00
299,744.65
2,291.67
0.00
2,916.67
625.00
35.65
0.00
35.65
660.65
660.65
313379Q69 FHLB
Note
2.125% Due 06/10/2022
06/20/2017
06/21/2017
200,000.00
200,449.19
0.00
0.00
200,408.71
247.92
0.00
602.08
354.16
0.00
40.48
(40.48)
313.68
313.68
313383YJ4 FHLB
Note
3.375% Due 09/08/2023
12/27/2018
12/28/2018
200,000.00
202,622.96
0.00
0.00
202,521.19
2,118.75
0.00
2,681.25
562.50
0.00
101.77
(101.77)
460.73
460.73
3135G03U5 FNMA
Note
0.625% Due 04/22/2025
Various
Various
310,000.00
309,968.28
0.00
0.00
309,968.99
371.35
0.00
532.82
161.47
7.35
6.64
0.71
162.18
162.18
3135G05X7 FNMA
Note
0.375% Due 08/25/2025
08/25/2020
08/27/2020
230,000.00
229,105.36
0.00
0.00
229,123.65
301.88
0.00
373.75
71.87
18.29
0.00
18.29
90.16
90.16
3135G06G3 FNMA
Note
0.5% Due 11/07/2025
11/09/2020
11/12/2020
250,000.00
249,218.53
0.00
0.00
249,233.77
187.50
0.00
291.67
104.17
15.24
0.00
15.24
119.41
119.41
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 16
3.A.3.a
Packet Pg. 38 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Income Earned
As of July 31, 2021
City of San Jacinto
Account #10167
CUSIP Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
3135G0N82 FNMA
Note
1.25% Due 08/17/2021
01/26/2017
01/31/2017
265,000.00
314,704.79
0.00
49,967.10
264,915.46
1,465.63
256.94
1,509.03
300.34
177.77
0.00
177.77
478.11
478.11
3135G0T94 FNMA
Note
2.375% Due 01/19/2023
10/17/2018
10/19/2018
290,000.00
287,076.68
0.00
0.00
287,236.51
3,099.38
3,443.75
229.58
573.95
159.83
0.00
159.83
733.78
733.78
3135G0V34 FNMA
Note
2.5% Due 02/05/2024
03/24/2020
03/25/2020
375,000.00
391,019.42
0.00
0.00
390,496.13
3,802.08
0.00
4,583.33
781.25
0.00
523.29
(523.29)
257.96
257.96
3135G0W33 FNMA
Note
1.375% Due 09/06/2022
09/05/2019
09/06/2019
200,000.00
199,725.66
0.00
0.00
199,745.35
878.47
0.00
1,107.64
229.17
19.69
0.00
19.69
248.86
248.86
3135G0X24 FNMA
Note
1.625% Due 01/07/2025
01/16/2020
01/17/2020
225,000.00
224,503.15
0.00
0.00
224,515.13
1,767.19
1,828.13
243.75
304.69
11.98
0.00
11.98
316.67
316.67
3137EAEN5 FHLMC
Note
2.75% Due 06/19/2023
11/13/2018
11/14/2018
200,000.00
198,791.64
0.00
0.00
198,843.81
183.33
0.00
641.67
458.34
52.17
0.00
52.17
510.51
510.51
3137EAEP0 FHLMC
Note
1.5% Due 02/12/2025
02/13/2020
02/14/2020
245,000.00
244,863.35
0.00
0.00
244,866.55
1,418.96
0.00
1,725.21
306.25
3.20
0.00
3.20
309.45
309.45
3137EAEU9 FHLMC
Note
0.375% Due 07/21/2025
07/21/2020
07/23/2020
145,000.00
144,413.69
0.00
0.00
144,425.96
241.67
271.88
15.10
45.31
12.27
0.00
12.27
57.58
57.58
3137EAEX3 FHLMC
Note
0.375% Due 09/23/2025
09/23/2020
09/25/2020
230,000.00
229,413.59
0.00
0.00
229,425.36
234.79
0.00
306.67
71.88
11.77
0.00
11.77
83.65
83.65
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 17
3.A.3.a
Packet Pg. 39 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Income Earned
As of July 31, 2021
City of San Jacinto
Account #10167
CUSIP Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
3137EAEY1 FHLMC
Note
0.125% Due 10/16/2023
10/22/2020
10/23/2020
180,000.00
179,425.33
0.00
0.00
179,446.62
46.88
0.00
65.63
18.75
21.29
0.00
21.29
40.04
40.04
43813GAC5 Honda Auto Receivables Trust
2021-1 A3
0.27% Due 04/21/2025
02/17/2021
02/24/2021
30,000.00
29,999.51
0.00
0.00
29,999.53
2.25
6.75
2.25
6.75
0.02
0.00
0.02
6.77
6.77
43813KAC6 Honda Auto Receivables Trust
2020-3 A3
0.37% Due 10/18/2024
09/22/2020
09/29/2020
90,000.00
89,989.96
0.00
0.00
89,990.31
12.03
27.75
12.03
27.75
0.35
0.00
0.35
28.10
28.10
43815HAC1 Honda Auto Receivables Trust
2018-3 A3
2.95% Due 08/22/2022
08/21/2018
08/28/2018
8,783.71
11,621.96
0.00
2,838.71
8,783.39
9.52
28.57
7.20
26.25
0.14
0.00
0.14
26.39
26.39
43815NAC8 Honda Auto Receivables Trust
2019-3 A3
1.78% Due 08/15/2023
08/20/2019
08/27/2019
68,501.34
74,818.75
0.00
6,317.66
68,501.13
59.19
110.98
54.19
105.98
0.04
0.00
0.04
106.02
106.02
4581X0DV7 Inter-American Dev Bank
Note
0.875% Due 04/20/2026
04/13/2021
04/20/2021
230,000.00
228,988.14
0.00
0.00
229,006.02
396.91
0.00
564.62
167.71
17.88
0.00
17.88
185.59
185.59
46625HJX9 JP Morgan Chase
Note
3.625% Due 05/13/2024
12/19/2019
12/24/2019
145,000.00
150,594.98
0.00
0.00
150,429.32
700.83
0.00
1,138.85
438.02
0.00
165.66
(165.66)
272.36
272.36
477870AC3 John Deere Owner Trust
2019-B A3
2.21% Due 12/15/2023
07/16/2019
07/24/2019
26,599.54
28,093.51
0.00
1,497.30
26,596.50
27.60
51.75
26.13
50.28
0.29
0.00
0.29
50.57
50.57
47787NAC3 John Deere Owner Trust
2020-B A3
0.51% Due 11/15/2024
07/14/2020
07/22/2020
25,000.00
24,997.22
0.00
0.00
24,997.31
5.67
10.63
5.67
10.63
0.09
0.00
0.09
10.72
10.72
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 18
3.A.3.a
Packet Pg. 40 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Income Earned
As of July 31, 2021
City of San Jacinto
Account #10167
CUSIP Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
47788UAC6 John Deere Owner Trust
2021-A A3
0.36% Due 09/15/2025
03/02/2021
03/10/2021
40,000.00
39,992.97
0.00
0.00
39,993.15
6.40
12.00
6.40
12.00
0.18
0.00
0.18
12.18
12.18
47789KAC7 John Deere Owner Trust
2020-A A3
1.1% Due 08/15/2024
03/04/2020
03/11/2020
60,000.00
59,997.41
0.00
0.00
59,997.48
29.33
55.00
29.33
55.00
0.07
0.00
0.07
55.07
55.07
47789QAC4 John Deere Owner Trust
2021-B A3
0.52% Due 03/16/2026
07/13/2021
07/21/2021
45,000.00
0.00
44,995.99
0.00
44,996.02
0.00
0.00
6.50
6.50
0.03
0.00
0.03
6.53
6.53
58769KAD6 Mercedes-Benz Auto Lease Trust
2021-B A3
0.4% Due 11/15/2024
06/22/2021
06/29/2021
55,000.00
54,995.86
0.00
0.00
54,996.00
1.22
9.78
9.78
18.34
0.14
0.00
0.14
18.48
18.48
65479JAD5 Nissan Auto Receivables Owner
2019-C A3
1.93% Due 07/15/2024
10/16/2019
10/23/2019
82,599.72
84,997.11
0.00
2,400.28
82,597.00
72.91
136.71
70.85
134.65
0.17
0.00
0.17
134.82
134.82
808513BN4 Charles Schwab Corp
Callable Note Cont 2/18/2024
0.75% Due 03/18/2024
03/16/2021
03/18/2021
40,000.00
39,981.92
0.00
0.00
39,982.48
85.83
0.00
110.83
25.00
0.56
0.00
0.56
25.56
25.56
89236TDP7 Toyota Motor Credit Corp
Note
2.6% Due 01/11/2022
01/28/2019
01/30/2019
130,000.00
129,753.19
0.00
0.00
129,792.63
1,596.11
1,690.00
187.78
281.67
39.44
0.00
39.44
321.11
321.11
89236TJK2 Toyota Motor Credit Corp
Note
1.125% Due 06/18/2026
06/15/2021
06/18/2021
120,000.00
119,947.58
0.00
0.00
119,948.47
48.75
0.00
161.25
112.50
0.89
0.00
0.89
113.39
113.39
89236XAC0 Toyota Auto Receivables
2020-D A3
0.35% Due 01/15/2025
10/06/2020
10/13/2020
45,000.00
44,993.03
0.00
0.00
44,993.19
7.00
13.13
7.00
13.13
0.16
0.00
0.16
13.29
13.29
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 19
3.A.3.a
Packet Pg. 41 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Income Earned
As of July 31, 2021
City of San Jacinto
Account #10167
CUSIP Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
89237VAB5 Toyota Auto Receivables Trust
2020-C A3
0.44% Due 10/15/2024
07/21/2020
07/27/2020
55,000.00
54,996.70
0.00
0.00
54,996.79
10.76
20.17
10.76
20.17
0.09
0.00
0.09
20.26
20.26
89240BAC2 Toyota Auto Receivables Owners
2021-A A3
0.26% Due 05/15/2025
02/02/2021
02/08/2021
75,000.00
74,987.84
0.00
0.00
74,988.22
8.67
16.25
8.67
16.25
0.38
0.00
0.38
16.63
16.63
9128282U3 US Treasury
Note
1.875% Due 08/31/2024
12/12/2019
12/13/2019
230,000.00
230,826.53
0.00
0.00
230,804.38
1,441.41
0.00
1,804.69
363.28
0.00
22.15
(22.15)
341.13
341.13
9128284D9 US Treasury
Note
2.5% Due 03/31/2023
Various
Various
210,000.00
208,468.32
0.00
0.00
208,542.74
1,319.67
0.00
1,764.35
444.68
74.42
0.00
74.42
519.10
519.10
9128284Z0 US Treasury
Note
2.75% Due 08/31/2025
06/24/2021
06/25/2021
155,000.00
167,900.13
0.00
0.00
167,637.38
1,424.69
0.00
1,783.76
359.07
0.00
262.75
(262.75)
96.32
96.32
912828G53 US Treasury
Note
1.875% Due 11/30/2021
04/26/2017
04/27/2017
120,000.00
120,032.31
0.00
0.00
120,025.72
190.57
0.00
381.15
190.58
0.00
6.59
(6.59)
183.99
183.99
912828L24 US Treasury
Note
1.875% Due 08/31/2022
07/22/2019
07/23/2019
150,000.00
150,173.74
0.00
0.00
150,161.09
940.05
0.00
1,176.97
236.92
0.00
12.65
(12.65)
224.27
224.27
912828M80 US Treasury
Note
2% Due 11/30/2022
04/11/2019
04/15/2019
200,000.00
199,161.70
0.00
0.00
199,211.97
338.80
0.00
677.60
338.80
50.27
0.00
50.27
389.07
389.07
912828W71 US Treasury
Note
2.125% Due 03/31/2024
12/05/2019
12/06/2019
210,000.00
212,757.50
0.00
0.00
212,672.36
1,121.72
0.00
1,499.69
377.97
0.00
85.14
(85.14)
292.83
292.83
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 20
3.A.3.a
Packet Pg. 42 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Income Earned
As of July 31, 2021
City of San Jacinto
Account #10167
CUSIP Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
912828W89 US Treasury
Note
1.875% Due 03/31/2022
04/26/2018
04/27/2018
200,000.00
198,768.50
0.00
0.00
198,908.34
942.62
0.00
1,260.25
317.63
139.84
0.00
139.84
457.47
457.47
912828Y61 US Treasury
Note
2.75% Due 07/31/2023
12/27/2018
12/28/2018
175,000.00
175,554.87
0.00
0.00
175,532.24
2,007.42
2,406.25
13.08
411.91
0.00
22.63
(22.63)
389.28
389.28
912828Y87 US Treasury
Note
1.75% Due 07/31/2024
01/17/2020
01/21/2020
220,000.00
220,790.28
0.00
0.00
220,768.53
1,605.94
1,925.00
10.46
329.52
0.00
21.75
(21.75)
307.77
307.77
912828YV6 US Treasury
Note
1.5% Due 11/30/2024
12/12/2019
12/13/2019
230,000.00
228,226.02
0.00
0.00
228,270.09
292.21
0.00
584.43
292.22
44.07
0.00
44.07
336.29
336.29
912828ZC7 US Treasury
Note
1.125% Due 02/28/2025
03/24/2020
03/25/2020
400,000.00
408,949.88
0.00
0.00
408,742.52
1,504.08
0.00
1,883.15
379.07
0.00
207.36
(207.36)
171.71
171.71
912828ZT0 US Treasury
Note
0.25% Due 05/31/2025
06/04/2020
06/05/2020
230,000.00
228,723.00
0.00
0.00
228,750.68
48.70
0.00
97.40
48.70
27.68
0.00
27.68
76.38
76.38
91282CAZ4 US Treasury
Note
0.375% Due 11/30/2025
12/15/2020
12/16/2020
240,000.00
240,016.71
0.00
0.00
240,016.39
76.23
0.00
152.46
76.23
0.00
0.32
(0.32)
75.91
75.91
91282CBC4 US Treasury
Note
0.375% Due 12/31/2025
01/28/2021
01/29/2021
250,000.00
249,580.10
0.00
0.00
249,588.02
2.55
0.00
81.52
78.97
7.92
0.00
7.92
86.89
86.89
91282CBQ3 US Treasury
Note
0.5% Due 02/28/2026
03/24/2021
03/25/2021
250,000.00
246,334.01
0.00
0.00
246,400.74
417.80
0.00
523.10
105.30
66.73
0.00
66.73
172.03
172.03
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 21
3.A.3.a
Packet Pg. 43 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Income Earned
As of July 31, 2021
City of San Jacinto
Account #10167
CUSIP Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
91282CBT7 US Treasury
Note
0.75% Due 03/31/2026
Various
Various
250,000.00
248,735.82
0.00
0.00
248,758.43
471.32
0.00
630.12
158.80
22.61
0.00
22.61
181.41
181.41
91324PEC2 United Health Group Inc
Callable Note Cont 4/15/2026
1.15% Due 05/15/2026
Various
Various
30,000.00
30,096.29
0.00
0.00
30,094.58
40.25
0.00
69.00
28.75
0.00
1.71
(1.71)
27.04
27.04
Total Fixed Income 10,986,484.31
11,061,757.75
44,995.99
63,021.05
11,042,369.93
46,863.53
19,192.67
42,985.89
15,315.03
1,084.57
2,447.33
(1,362.76)
13,952.27 13,952.27
CASH & EQUIVALENT
31846V203 First American
Govt Obligation Fund Class Y
Various
Various
39,840.09
3,583.14
37,304.36
1,047.41
39,840.09
0.00
0.73
0.00
0.73
0.00
0.00
0.00
0.73
0.73
Total Cash & Equivalent 39,840.09
3,583.14
37,304.36
1,047.41
39,840.09
0.00
0.73
0.00
0.73
0.00
0.00
0.00
0.73 0.73
TOTAL PORTFOLIO 11,026,324.40
11,065,340.89
82,300.35
64,068.46
11,082,210.02
46,863.53
19,193.40
42,985.89
15,315.76
1,084.57
2,447.33
(1,362.76)
13,953.00 13,953.00
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 22
3.A.3.a
Packet Pg. 44 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Cash Flow Report
As of July 31, 2021
City of San Jacinto
Account #10167
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
08/05/2021 Interest 3135G0V34 375,000.00 FNMA Note
2.5% Due 2/5/2024
0.00 4,687.50 4,687.50
08/12/2021 Interest 3137EAEP0 245,000.00 FHLMC Note
1.5% Due 2/12/2025
0.00 1,837.50 1,837.50
08/15/2021 Paydown 43815NAC8 68,501.34 Honda Auto Receivables Trust 2019-3 A3
1.78% Due 8/15/2023
6,334.43 101.61 6,436.04
08/15/2021 Paydown 477870AC3 26,599.54 John Deere Owner Trust 2019-B A3
2.21% Due 12/15/2023
890.75 48.99 939.74
08/15/2021 Paydown 58769KAD6 55,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
0.00 18.33 18.33
08/15/2021 Paydown 47787NAC3 25,000.00 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
0.00 10.63 10.63
08/15/2021 Paydown 47788UAC6 40,000.00 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
0.00 12.00 12.00
08/15/2021 Paydown 65479JAD5 82,599.72 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
2,205.34 132.85 2,338.19
08/15/2021 Paydown 89240BAC2 75,000.00 Toyota Auto Receivables Owners 2021-A A3
0.26% Due 5/15/2025
0.00 16.25 16.25
08/15/2021 Paydown 47789KAC7 60,000.00 John Deere Owner Trust 2020-A A3
1.1% Due 8/15/2024
1,542.75 55.00 1,597.75
08/15/2021 Paydown 89236XAC0 45,000.00 Toyota Auto Receivables 2020-D A3
0.35% Due 1/15/2025
1,141.12 13.13 1,154.25
08/15/2021 Paydown 89237VAB5 55,000.00 Toyota Auto Receivables Trust 2020-C A3
0.44% Due 10/15/2024
0.00 20.17 20.17
08/17/2021 Maturity 3135G0N82 265,000.00 FNMA Note
1.25% Due 8/17/2021
265,000.00 1,656.25 266,656.25
08/18/2021 Paydown 43813KAC6 90,000.00 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
0.00 27.75 27.75
08/21/2021 Paydown 43813GAC5 30,000.00 Honda Auto Receivables Trust 2021-1 A3
0.27% Due 4/21/2025
0.00 6.75 6.75
08/21/2021 Paydown 43815HAC1 8,783.71 Honda Auto Receivables Trust 2018-3 A3
2.95% Due 8/22/2022
617.45 21.59 639.04
08/25/2021 Interest 3135G05X7 230,000.00 FNMA Note
0.375% Due 8/25/2025
0.00 431.25 431.25
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 23
3.A.3.a
Packet Pg. 45 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Cash Flow Report
As of July 31, 2021
City of San Jacinto
Account #10167
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
08/31/2021 Interest 9128284Z0 155,000.00 US Treasury Note
2.75% Due 8/31/2025
0.00 2,131.25 2,131.25
08/31/2021 Interest 912828L24 150,000.00 US Treasury Note
1.875% Due 8/31/2022
0.00 1,406.25 1,406.25
08/31/2021 Interest 91282CBQ3 250,000.00 US Treasury Note
0.5% Due 2/28/2026
0.00 625.00 625.00
08/31/2021 Interest 912828ZC7 400,000.00 US Treasury Note
1.125% Due 2/28/2025
0.00 2,250.00 2,250.00
08/31/2021 Interest 9128282U3 230,000.00 US Treasury Note
1.875% Due 8/31/2024
0.00 2,156.25 2,156.25
AUG 2021 277,731.84 17,666.30 295,398.14
09/06/2021 Interest 3135G0W33 200,000.00 FNMA Note
1.375% Due 9/6/2022
0.00 1,375.00 1,375.00
09/08/2021 Interest 313383YJ4 200,000.00 FHLB Note
3.375% Due 9/8/2023
0.00 3,375.00 3,375.00
09/11/2021 Interest 313378WG2 300,000.00 FHLB Note
2.5% Due 3/11/2022
0.00 3,750.00 3,750.00
09/13/2021 Interest 3130A2UW4 150,000.00 FHLB Note
2.875% Due 9/13/2024
0.00 2,156.25 2,156.25
09/15/2021 Interest 084670BR8 150,000.00 Berkshire Hathaway Callable Note Cont 1/15/2023
2.75% Due 3/15/2023
0.00 2,062.50 2,062.50
09/15/2021 Paydown 43815NAC8 68,501.34 Honda Auto Receivables Trust 2019-3 A3
1.78% Due 8/15/2023
6,114.81 92.21 6,207.02
09/15/2021 Paydown 47788UAC6 40,000.00 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
0.00 12.00 12.00
09/15/2021 Paydown 47787NAC3 25,000.00 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
0.00 10.63 10.63
09/15/2021 Paydown 47789KAC7 60,000.00 John Deere Owner Trust 2020-A A3
1.1% Due 8/15/2024
1,546.99 53.59 1,600.58
09/15/2021 Paydown 65479JAD5 82,599.72 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
2,210.31 129.30 2,339.61
09/15/2021 Paydown 89237VAB5 55,000.00 Toyota Auto Receivables Trust 2020-C A3
0.44% Due 10/15/2024
0.00 20.17 20.17
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 24
3.A.3.a
Packet Pg. 46 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Cash Flow Report
As of July 31, 2021
City of San Jacinto
Account #10167
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
09/15/2021 Paydown 89240BAC2 75,000.00 Toyota Auto Receivables Owners 2021-A A3
0.26% Due 5/15/2025
0.00 16.25 16.25
09/15/2021 Paydown 477870AC3 26,599.54 John Deere Owner Trust 2019-B A3
2.21% Due 12/15/2023
892.60 47.35 939.95
09/15/2021 Paydown 58769KAD6 55,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
0.00 18.33 18.33
09/15/2021 Paydown 47789QAC4 45,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
0.00 35.10 35.10
09/15/2021 Paydown 89236XAC0 45,000.00 Toyota Auto Receivables 2020-D A3
0.35% Due 1/15/2025
1,138.19 12.79 1,150.98
09/18/2021 Interest 808513BN4 40,000.00 Charles Schwab Corp Callable Note Cont 2/18/2024
0.75% Due 3/18/2024
0.00 150.00 150.00
09/18/2021 Paydown 43813KAC6 90,000.00 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
0.00 27.75 27.75
09/21/2021 Paydown 43813GAC5 30,000.00 Honda Auto Receivables Trust 2021-1 A3
0.27% Due 4/21/2025
0.00 6.75 6.75
09/21/2021 Paydown 43815HAC1 8,783.71 Honda Auto Receivables Trust 2018-3 A3
2.95% Due 8/22/2022
618.96 20.08 639.04
09/23/2021 Interest 3137EAEX3 230,000.00 FHLMC Note
0.375% Due 9/23/2025
0.00 431.25 431.25
09/30/2021 Interest 912828W89 200,000.00 US Treasury Note
1.875% Due 3/31/2022
0.00 1,875.00 1,875.00
09/30/2021 Interest 9128284D9 210,000.00 US Treasury Note
2.5% Due 3/31/2023
0.00 2,625.00 2,625.00
09/30/2021 Interest 912828W71 210,000.00 US Treasury Note
2.125% Due 3/31/2024
0.00 2,231.25 2,231.25
09/30/2021 Interest 91282CBT7 250,000.00 US Treasury Note
0.75% Due 3/31/2026
0.00 937.50 937.50
SEP 2021 12,521.86 21,471.05 33,992.91
10/15/2021 Paydown 47789KAC7 60,000.00 John Deere Owner Trust 2020-A A3
1.1% Due 8/15/2024
1,551.24 52.17 1,603.41
10/15/2021 Paydown 47789QAC4 45,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
0.00 19.50 19.50
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 25
3.A.3.a
Packet Pg. 47 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Cash Flow Report
As of July 31, 2021
City of San Jacinto
Account #10167
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
10/15/2021 Paydown 89236XAC0 45,000.00 Toyota Auto Receivables 2020-D A3
0.35% Due 1/15/2025
1,135.23 12.46 1,147.69
10/15/2021 Paydown 89237VAB5 55,000.00 Toyota Auto Receivables Trust 2020-C A3
0.44% Due 10/15/2024
0.00 20.17 20.17
10/15/2021 Paydown 43815NAC8 68,501.34 Honda Auto Receivables Trust 2019-3 A3
1.78% Due 8/15/2023
5,894.65 83.14 5,977.79
10/15/2021 Paydown 477870AC3 26,599.54 John Deere Owner Trust 2019-B A3
2.21% Due 12/15/2023
894.47 45.70 940.17
10/15/2021 Paydown 47787NAC3 25,000.00 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
0.00 10.63 10.63
10/15/2021 Paydown 47788UAC6 40,000.00 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
0.00 12.00 12.00
10/15/2021 Paydown 58769KAD6 55,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
0.00 18.33 18.33
10/15/2021 Paydown 89240BAC2 75,000.00 Toyota Auto Receivables Owners 2021-A A3
0.26% Due 5/15/2025
0.00 16.25 16.25
10/15/2021 Paydown 65479JAD5 82,599.72 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
2,215.28 125.75 2,341.03
10/16/2021 Interest 3137EAEY1 180,000.00 FHLMC Note
0.125% Due 10/16/2023
0.00 112.50 112.50
10/18/2021 Paydown 43813KAC6 90,000.00 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
0.00 27.75 27.75
10/20/2021 Interest 4581X0DV7 230,000.00 Inter-American Dev Bank Note
0.875% Due 4/20/2026
0.00 1,006.25 1,006.25
10/21/2021 Paydown 43813GAC5 30,000.00 Honda Auto Receivables Trust 2021-1 A3
0.27% Due 4/21/2025
0.00 6.75 6.75
10/21/2021 Paydown 43815HAC1 8,783.71 Honda Auto Receivables Trust 2018-3 A3
2.95% Due 8/22/2022
620.49 18.55 639.04
10/22/2021 Interest 3135G03U5 310,000.00 FNMA Note
0.625% Due 4/22/2025
0.00 968.75 968.75
OCT 2021 12,311.36 2,556.65 14,868.01
11/03/2021 Interest 037833AK6 200,000.00 Apple Inc Note
2.4% Due 5/3/2023
0.00 2,400.00 2,400.00
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 26
3.A.3.a
Packet Pg. 48 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Cash Flow Report
As of July 31, 2021
City of San Jacinto
Account #10167
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
11/07/2021 Interest 3135G06G3 250,000.00 FNMA Note
0.5% Due 11/7/2025
0.00 625.00 625.00
11/12/2021 Interest 023135BW5 90,000.00 Amazon.com Inc Callable Note Cont 11/12/2021
0.45% Due 5/12/2024
0.00 202.50 202.50
11/13/2021 Interest 46625HJX9 145,000.00 JP Morgan Chase Note
3.625% Due 5/13/2024
0.00 2,628.13 2,628.13
11/15/2021 Interest 91324PEC2 30,000.00 United Health Group Inc Callable Note Cont
4/15/2026
1.15% Due 5/15/2026
0.00 168.66 168.66
11/15/2021 Paydown 47788UAC6 40,000.00 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
0.00 12.00 12.00
11/15/2021 Paydown 43815NAC8 68,501.34 Honda Auto Receivables Trust 2019-3 A3
1.78% Due 8/15/2023
5,673.96 74.40 5,748.36
11/15/2021 Paydown 47789KAC7 60,000.00 John Deere Owner Trust 2020-A A3
1.1% Due 8/15/2024
1,555.51 50.75 1,606.26
11/15/2021 Paydown 47789QAC4 45,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
0.00 19.50 19.50
11/15/2021 Paydown 89236XAC0 45,000.00 Toyota Auto Receivables 2020-D A3
0.35% Due 1/15/2025
1,132.23 12.13 1,144.36
11/15/2021 Paydown 477870AC3 26,599.54 John Deere Owner Trust 2019-B A3
2.21% Due 12/15/2023
896.33 44.06 940.39
11/15/2021 Paydown 47787NAC3 25,000.00 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
0.00 10.63 10.63
11/15/2021 Paydown 58769KAD6 55,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
0.00 18.33 18.33
11/15/2021 Paydown 89237VAB5 55,000.00 Toyota Auto Receivables Trust 2020-C A3
0.44% Due 10/15/2024
0.00 20.17 20.17
11/15/2021 Paydown 89240BAC2 75,000.00 Toyota Auto Receivables Owners 2021-A A3
0.26% Due 5/15/2025
0.00 16.25 16.25
11/15/2021 Paydown 65479JAD5 82,599.72 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
2,220.27 122.18 2,342.45
11/18/2021 Paydown 43813KAC6 90,000.00 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
0.00 27.75 27.75
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 27
3.A.3.a
Packet Pg. 49 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Cash Flow Report
As of July 31, 2021
City of San Jacinto
Account #10167
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
11/21/2021 Paydown 43813GAC5 30,000.00 Honda Auto Receivables Trust 2021-1 A3
0.27% Due 4/21/2025
0.00 6.75 6.75
11/21/2021 Paydown 43815HAC1 8,783.71 Honda Auto Receivables Trust 2018-3 A3
2.95% Due 8/22/2022
622.01 17.03 639.04
11/30/2021 Interest 912828M80 200,000.00 US Treasury Note
2% Due 11/30/2022
0.00 2,000.00 2,000.00
11/30/2021 Interest 912828ZT0 230,000.00 US Treasury Note
0.25% Due 5/31/2025
0.00 287.50 287.50
11/30/2021 Interest 912828YV6 230,000.00 US Treasury Note
1.5% Due 11/30/2024
0.00 1,725.00 1,725.00
11/30/2021 Interest 91282CAZ4 240,000.00 US Treasury Note
0.375% Due 11/30/2025
0.00 450.00 450.00
11/30/2021 Maturity 912828G53 120,000.00 US Treasury Note
1.875% Due 11/30/2021
120,000.00 1,125.00 121,125.00
NOV 2021 132,100.31 12,063.72 144,164.03
12/08/2021 Interest 3130A0F70 220,000.00 FHLB Note
3.375% Due 12/8/2023
0.00 3,712.50 3,712.50
12/09/2021 Interest 3130A3KM5 100,000.00 FHLB Note
2.5% Due 12/9/2022
0.00 1,250.00 1,250.00
12/10/2021 Interest 313379Q69 200,000.00 FHLB Note
2.125% Due 6/10/2022
0.00 2,125.00 2,125.00
12/13/2021 Interest 3130A3GE8 250,000.00 FHLB Note
2.75% Due 12/13/2024
0.00 3,437.50 3,437.50
12/13/2021 Interest 3130AJKW8 225,000.00 FHLB Note
0.5% Due 6/13/2025
0.00 562.50 562.50
12/14/2021 Interest 3130A1XJ2 210,000.00 FHLB Note
2.875% Due 6/14/2024
0.00 3,018.76 3,018.76
12/15/2021 Paydown 47787NAC3 25,000.00 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
0.00 10.63 10.63
12/15/2021 Paydown 47788UAC6 40,000.00 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
0.00 12.00 12.00
12/15/2021 Paydown 65479JAD5 82,599.72 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
2,225.26 118.61 2,343.87
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 28
3.A.3.a
Packet Pg. 50 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Cash Flow Report
As of July 31, 2021
City of San Jacinto
Account #10167
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
12/15/2021 Paydown 89240BAC2 75,000.00 Toyota Auto Receivables Owners 2021-A A3
0.26% Due 5/15/2025
0.00 16.25 16.25
12/15/2021 Paydown 47789KAC7 60,000.00 John Deere Owner Trust 2020-A A3
1.1% Due 8/15/2024
1,559.79 49.32 1,609.11
12/15/2021 Paydown 47789QAC4 45,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
0.00 19.50 19.50
12/15/2021 Paydown 89236XAC0 45,000.00 Toyota Auto Receivables 2020-D A3
0.35% Due 1/15/2025
1,129.20 11.80 1,141.00
12/15/2021 Paydown 89237VAB5 55,000.00 Toyota Auto Receivables Trust 2020-C A3
0.44% Due 10/15/2024
0.00 20.17 20.17
12/15/2021 Paydown 43815NAC8 68,501.34 Honda Auto Receivables Trust 2019-3 A3
1.78% Due 8/15/2023
5,452.73 65.98 5,518.71
12/15/2021 Paydown 477870AC3 26,599.54 John Deere Owner Trust 2019-B A3
2.21% Due 12/15/2023
898.19 42.41 940.60
12/15/2021 Paydown 58769KAD6 55,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
0.00 18.33 18.33
12/18/2021 Interest 89236TJK2 120,000.00 Toyota Motor Credit Corp Note
1.125% Due 6/18/2026
0.00 675.00 675.00
12/18/2021 Paydown 43813KAC6 90,000.00 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
0.00 27.75 27.75
12/19/2021 Interest 3137EAEN5 200,000.00 FHLMC Note
2.75% Due 6/19/2023
0.00 2,750.00 2,750.00
12/21/2021 Paydown 43813GAC5 30,000.00 Honda Auto Receivables Trust 2021-1 A3
0.27% Due 4/21/2025
0.00 6.75 6.75
12/21/2021 Paydown 43815HAC1 8,783.71 Honda Auto Receivables Trust 2018-3 A3
2.95% Due 8/22/2022
623.54 15.50 639.04
12/31/2021 Interest 91282CBC4 250,000.00 US Treasury Note
0.375% Due 12/31/2025
0.00 468.75 468.75
DEC 2021 11,888.71 18,435.01 30,323.72
01/07/2022 Interest 3135G0X24 225,000.00 FNMA Note
1.625% Due 1/7/2025
0.00 1,828.13 1,828.13
01/10/2022 Interest 24422EUR8 150,000.00 John Deere Capital Corp Note
3.45% Due 1/10/2024
0.00 2,587.50 2,587.50
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 29
3.A.3.a
Packet Pg. 51 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Cash Flow Report
As of July 31, 2021
City of San Jacinto
Account #10167
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
01/11/2022 Interest 06051GEU9 130,000.00 Bank of America Corp Note
3.3% Due 1/11/2023
0.00 2,145.00 2,145.00
01/11/2022 Maturity 89236TDP7 130,000.00 Toyota Motor Credit Corp Note
2.6% Due 1/11/2022
130,000.00 1,690.00 131,690.00
01/15/2022 Paydown 89236XAC0 45,000.00 Toyota Auto Receivables 2020-D A3
0.35% Due 1/15/2025
1,126.14 11.47 1,137.61
01/15/2022 Paydown 477870AC3 26,599.54 John Deere Owner Trust 2019-B A3
2.21% Due 12/15/2023
900.07 40.75 940.82
01/15/2022 Paydown 47787NAC3 25,000.00 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
0.00 10.63 10.63
01/15/2022 Paydown 47789KAC7 60,000.00 John Deere Owner Trust 2020-A A3
1.1% Due 8/15/2024
1,564.08 47.89 1,611.97
01/15/2022 Paydown 47789QAC4 45,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
0.00 19.50 19.50
01/15/2022 Paydown 58769KAD6 55,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
0.00 18.33 18.33
01/15/2022 Paydown 89237VAB5 55,000.00 Toyota Auto Receivables Trust 2020-C A3
0.44% Due 10/15/2024
1,607.88 20.17 1,628.05
01/15/2022 Paydown 89240BAC2 75,000.00 Toyota Auto Receivables Owners 2021-A A3
0.26% Due 5/15/2025
0.00 16.25 16.25
01/15/2022 Paydown 47788UAC6 40,000.00 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
0.00 12.00 12.00
01/15/2022 Paydown 43815NAC8 68,501.34 Honda Auto Receivables Trust 2019-3 A3
1.78% Due 8/15/2023
5,230.97 57.90 5,288.87
01/15/2022 Paydown 65479JAD5 82,599.72 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
2,230.27 115.03 2,345.30
01/18/2022 Paydown 43813KAC6 90,000.00 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
0.00 27.75 27.75
01/19/2022 Interest 3135G0T94 290,000.00 FNMA Note
2.375% Due 1/19/2023
0.00 3,443.75 3,443.75
01/21/2022 Interest 3137EAEU9 145,000.00 FHLMC Note
0.375% Due 7/21/2025
0.00 271.88 271.88
01/21/2022 Paydown 43813GAC5 30,000.00 Honda Auto Receivables Trust 2021-1 A3
0.27% Due 4/21/2025
0.00 6.75 6.75
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 30
3.A.3.a
Packet Pg. 52 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Cash Flow Report
As of July 31, 2021
City of San Jacinto
Account #10167
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
01/21/2022 Paydown 43815HAC1 8,783.71 Honda Auto Receivables Trust 2018-3 A3
2.95% Due 8/22/2022
625.07 13.97 639.04
01/29/2022 Interest 06406RAE7 145,000.00 Bank of NY Mellon Corp Callable Note Cont
12/29/2022
2.95% Due 1/29/2023
0.00 2,138.75 2,138.75
01/31/2022 Interest 912828Y87 220,000.00 US Treasury Note
1.75% Due 7/31/2024
0.00 1,925.00 1,925.00
01/31/2022 Interest 912828Y61 175,000.00 US Treasury Note
2.75% Due 7/31/2023
0.00 2,406.25 2,406.25
JAN 2022 143,284.48 18,854.65 162,139.13
02/05/2022 Interest 3135G0V34 375,000.00 FNMA Note
2.5% Due 2/5/2024
0.00 4,687.50 4,687.50
02/12/2022 Interest 3137EAEP0 245,000.00 FHLMC Note
1.5% Due 2/12/2025
0.00 1,837.50 1,837.50
02/15/2022 Paydown 477870AC3 26,599.54 John Deere Owner Trust 2019-B A3
2.21% Due 12/15/2023
901.95 39.09 941.04
02/15/2022 Paydown 58769KAD6 55,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
0.00 18.33 18.33
02/15/2022 Paydown 47789KAC7 60,000.00 John Deere Owner Trust 2020-A A3
1.1% Due 8/15/2024
1,568.37 46.46 1,614.83
02/15/2022 Paydown 89236XAC0 45,000.00 Toyota Auto Receivables 2020-D A3
0.35% Due 1/15/2025
1,123.04 11.14 1,134.18
02/15/2022 Paydown 89237VAB5 55,000.00 Toyota Auto Receivables Trust 2020-C A3
0.44% Due 10/15/2024
1,608.47 19.58 1,628.05
02/15/2022 Paydown 47787NAC3 25,000.00 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
0.00 10.63 10.63
02/15/2022 Paydown 47788UAC6 40,000.00 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
0.00 12.00 12.00
02/15/2022 Paydown 47789QAC4 45,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
0.00 19.50 19.50
02/15/2022 Paydown 65479JAD5 82,599.72 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
2,235.28 111.45 2,346.73
02/15/2022 Paydown 89240BAC2 75,000.00 Toyota Auto Receivables Owners 2021-A A3
0.26% Due 5/15/2025
0.00 16.25 16.25
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 31
3.A.3.a
Packet Pg. 53 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Cash Flow Report
As of July 31, 2021
City of San Jacinto
Account #10167
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
02/15/2022 Paydown 43815NAC8 68,501.34 Honda Auto Receivables Trust 2019-3 A3
1.78% Due 8/15/2023
5,008.67 50.14 5,058.81
02/18/2022 Paydown 43813KAC6 90,000.00 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
0.00 27.75 27.75
02/21/2022 Paydown 43813GAC5 30,000.00 Honda Auto Receivables Trust 2021-1 A3
0.27% Due 4/21/2025
0.00 6.75 6.75
02/21/2022 Paydown 43815HAC1 8,783.71 Honda Auto Receivables Trust 2018-3 A3
2.95% Due 8/22/2022
626.61 12.43 639.04
02/25/2022 Interest 3135G05X7 230,000.00 FNMA Note
0.375% Due 8/25/2025
0.00 431.25 431.25
02/28/2022 Interest 9128284Z0 155,000.00 US Treasury Note
2.75% Due 8/31/2025
0.00 2,131.25 2,131.25
02/28/2022 Interest 912828L24 150,000.00 US Treasury Note
1.875% Due 8/31/2022
0.00 1,406.25 1,406.25
02/28/2022 Interest 91282CBQ3 250,000.00 US Treasury Note
0.5% Due 2/28/2026
0.00 625.00 625.00
02/28/2022 Interest 9128282U3 230,000.00 US Treasury Note
1.875% Due 8/31/2024
0.00 2,156.25 2,156.25
02/28/2022 Interest 912828ZC7 400,000.00 US Treasury Note
1.125% Due 2/28/2025
0.00 2,250.00 2,250.00
FEB 2022 13,072.39 15,926.50 28,998.89
03/06/2022 Interest 3135G0W33 200,000.00 FNMA Note
1.375% Due 9/6/2022
0.00 1,375.00 1,375.00
03/08/2022 Interest 313383YJ4 200,000.00 FHLB Note
3.375% Due 9/8/2023
0.00 3,375.00 3,375.00
03/11/2022 Maturity 313378WG2 300,000.00 FHLB Note
2.5% Due 3/11/2022
300,000.00 3,750.00 303,750.00
03/13/2022 Interest 3130A2UW4 150,000.00 FHLB Note
2.875% Due 9/13/2024
0.00 2,156.25 2,156.25
03/15/2022 Interest 084670BR8 150,000.00 Berkshire Hathaway Callable Note Cont 1/15/2023
2.75% Due 3/15/2023
0.00 2,062.50 2,062.50
03/15/2022 Paydown 47788UAC6 40,000.00 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
0.00 12.00 12.00
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 32
3.A.3.a
Packet Pg. 54 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Cash Flow Report
As of July 31, 2021
City of San Jacinto
Account #10167
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
03/15/2022 Paydown 47789KAC7 60,000.00 John Deere Owner Trust 2020-A A3
1.1% Due 8/15/2024
1,572.69 45.02 1,617.71
03/15/2022 Paydown 89236XAC0 45,000.00 Toyota Auto Receivables 2020-D A3
0.35% Due 1/15/2025
1,119.91 10.81 1,130.72
03/15/2022 Paydown 477870AC3 26,599.54 John Deere Owner Trust 2019-B A3
2.21% Due 12/15/2023
903.83 37.43 941.26
03/15/2022 Paydown 58769KAD6 55,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
0.00 18.33 18.33
03/15/2022 Paydown 43815NAC8 68,501.34 Honda Auto Receivables Trust 2019-3 A3
1.78% Due 8/15/2023
4,785.84 42.71 4,828.55
03/15/2022 Paydown 47787NAC3 25,000.00 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
1,082.28 10.63 1,092.91
03/15/2022 Paydown 47789QAC4 45,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
0.00 19.50 19.50
03/15/2022 Paydown 65479JAD5 82,599.72 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
2,240.32 107.85 2,348.17
03/15/2022 Paydown 89237VAB5 55,000.00 Toyota Auto Receivables Trust 2020-C A3
0.44% Due 10/15/2024
1,609.06 18.99 1,628.05
03/15/2022 Paydown 89240BAC2 75,000.00 Toyota Auto Receivables Owners 2021-A A3
0.26% Due 5/15/2025
0.00 16.25 16.25
03/18/2022 Interest 808513BN4 40,000.00 Charles Schwab Corp Callable Note Cont 2/18/2024
0.75% Due 3/18/2024
0.00 150.00 150.00
03/18/2022 Paydown 43813KAC6 90,000.00 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
4,272.51 27.75 4,300.26
03/21/2022 Paydown 43813GAC5 30,000.00 Honda Auto Receivables Trust 2021-1 A3
0.27% Due 4/21/2025
0.00 6.75 6.75
03/21/2022 Paydown 43815HAC1 8,783.71 Honda Auto Receivables Trust 2018-3 A3
2.95% Due 8/22/2022
628.15 10.89 639.04
03/23/2022 Interest 3137EAEX3 230,000.00 FHLMC Note
0.375% Due 9/23/2025
0.00 431.25 431.25
03/31/2022 Interest 9128284D9 210,000.00 US Treasury Note
2.5% Due 3/31/2023
0.00 2,625.00 2,625.00
03/31/2022 Interest 912828W71 210,000.00 US Treasury Note
2.125% Due 3/31/2024
0.00 2,231.25 2,231.25
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 33
3.A.3.a
Packet Pg. 55 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Cash Flow Report
As of July 31, 2021
City of San Jacinto
Account #10167
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
03/31/2022 Interest 91282CBT7 250,000.00 US Treasury Note
0.75% Due 3/31/2026
0.00 937.50 937.50
03/31/2022 Maturity 912828W89 200,000.00 US Treasury Note
1.875% Due 3/31/2022
200,000.00 1,875.00 201,875.00
MAR 2022 518,214.59 21,353.66 539,568.25
04/15/2022 Paydown 43815NAC8 68,501.34 Honda Auto Receivables Trust 2019-3 A3
1.78% Due 8/15/2023
4,562.46 35.61 4,598.07
04/15/2022 Paydown 47789KAC7 60,000.00 John Deere Owner Trust 2020-A A3
1.1% Due 8/15/2024
1,577.01 43.58 1,620.59
04/15/2022 Paydown 89236XAC0 45,000.00 Toyota Auto Receivables 2020-D A3
0.35% Due 1/15/2025
1,116.74 10.49 1,127.23
04/15/2022 Paydown 89237VAB5 55,000.00 Toyota Auto Receivables Trust 2020-C A3
0.44% Due 10/15/2024
1,609.65 18.40 1,628.05
04/15/2022 Paydown 65479JAD5 82,599.72 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
2,245.35 104.25 2,349.60
04/15/2022 Paydown 477870AC3 26,599.54 John Deere Owner Trust 2019-B A3
2.21% Due 12/15/2023
905.70 35.77 941.47
04/15/2022 Paydown 47787NAC3 25,000.00 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
1,082.70 10.17 1,092.87
04/15/2022 Paydown 47788UAC6 40,000.00 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
0.00 12.00 12.00
04/15/2022 Paydown 47789QAC4 45,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
0.00 19.50 19.50
04/15/2022 Paydown 58769KAD6 55,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
0.00 18.33 18.33
04/15/2022 Paydown 89240BAC2 75,000.00 Toyota Auto Receivables Owners 2021-A A3
0.26% Due 5/15/2025
0.00 16.25 16.25
04/16/2022 Interest 3137EAEY1 180,000.00 FHLMC Note
0.125% Due 10/16/2023
0.00 112.50 112.50
04/18/2022 Paydown 43813KAC6 90,000.00 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
4,273.83 26.43 4,300.26
04/20/2022 Interest 4581X0DV7 230,000.00 Inter-American Dev Bank Note
0.875% Due 4/20/2026
0.00 1,006.25 1,006.25
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 34
3.A.3.a
Packet Pg. 56 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Cash Flow Report
As of July 31, 2021
City of San Jacinto
Account #10167
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
04/21/2022 Paydown 43813GAC5 30,000.00 Honda Auto Receivables Trust 2021-1 A3
0.27% Due 4/21/2025
0.00 6.75 6.75
04/21/2022 Paydown 43815HAC1 8,783.71 Honda Auto Receivables Trust 2018-3 A3
2.95% Due 8/22/2022
629.69 9.35 639.04
04/22/2022 Interest 3135G03U5 310,000.00 FNMA Note
0.625% Due 4/22/2025
0.00 968.75 968.75
APR 2022 18,003.13 2,454.38 20,457.51
05/03/2022 Interest 037833AK6 200,000.00 Apple Inc Note
2.4% Due 5/3/2023
0.00 2,400.00 2,400.00
05/07/2022 Interest 3135G06G3 250,000.00 FNMA Note
0.5% Due 11/7/2025
0.00 625.00 625.00
05/12/2022 Interest 023135BW5 90,000.00 Amazon.com Inc Callable Note Cont 11/12/2021
0.45% Due 5/12/2024
0.00 202.50 202.50
05/13/2022 Interest 46625HJX9 145,000.00 JP Morgan Chase Note
3.625% Due 5/13/2024
0.00 2,628.13 2,628.13
05/15/2022 Interest 91324PEC2 30,000.00 United Health Group Inc Callable Note Cont
4/15/2026
1.15% Due 5/15/2026
0.00 172.50 172.50
05/15/2022 Paydown 477870AC3 26,599.54 John Deere Owner Trust 2019-B A3
2.21% Due 12/15/2023
907.59 34.10 941.69
05/15/2022 Paydown 47787NAC3 25,000.00 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
1,083.13 9.70 1,092.83
05/15/2022 Paydown 47789QAC4 45,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
0.00 19.50 19.50
05/15/2022 Paydown 58769KAD6 55,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
0.00 18.33 18.33
05/15/2022 Paydown 89237VAB5 55,000.00 Toyota Auto Receivables Trust 2020-C A3
0.44% Due 10/15/2024
1,610.24 17.81 1,628.05
05/15/2022 Paydown 89240BAC2 75,000.00 Toyota Auto Receivables Owners 2021-A A3
0.26% Due 5/15/2025
0.00 16.25 16.25
05/15/2022 Paydown 47788UAC6 40,000.00 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
0.00 12.00 12.00
05/15/2022 Paydown 43815NAC8 68,501.34 Honda Auto Receivables Trust 2019-3 A3
1.78% Due 8/15/2023
4,338.55 28.84 4,367.39
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 35
3.A.3.a
Packet Pg. 57 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Cash Flow Report
As of July 31, 2021
City of San Jacinto
Account #10167
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
05/15/2022 Paydown 65479JAD5 82,599.72 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
2,250.40 100.64 2,351.04
05/15/2022 Paydown 47789KAC7 60,000.00 John Deere Owner Trust 2020-A A3
1.1% Due 8/15/2024
1,581.35 42.13 1,623.48
05/15/2022 Paydown 89236XAC0 45,000.00 Toyota Auto Receivables 2020-D A3
0.35% Due 1/15/2025
1,113.54 10.16 1,123.70
05/18/2022 Paydown 43813KAC6 90,000.00 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
4,275.15 25.11 4,300.26
05/21/2022 Paydown 43813GAC5 30,000.00 Honda Auto Receivables Trust 2021-1 A3
0.27% Due 4/21/2025
0.00 6.75 6.75
05/21/2022 Paydown 43815HAC1 8,783.71 Honda Auto Receivables Trust 2018-3 A3
2.95% Due 8/22/2022
631.24 7.80 639.04
05/31/2022 Interest 91282CAZ4 240,000.00 US Treasury Note
0.375% Due 11/30/2025
0.00 450.00 450.00
05/31/2022 Interest 912828M80 200,000.00 US Treasury Note
2% Due 11/30/2022
0.00 2,000.00 2,000.00
05/31/2022 Interest 912828YV6 230,000.00 US Treasury Note
1.5% Due 11/30/2024
0.00 1,725.00 1,725.00
05/31/2022 Interest 912828ZT0 230,000.00 US Treasury Note
0.25% Due 5/31/2025
0.00 287.50 287.50
MAY 2022 17,791.19 10,839.75 28,630.94
06/08/2022 Interest 3130A0F70 220,000.00 FHLB Note
3.375% Due 12/8/2023
0.00 3,712.50 3,712.50
06/09/2022 Interest 3130A3KM5 100,000.00 FHLB Note
2.5% Due 12/9/2022
0.00 1,250.00 1,250.00
06/10/2022 Maturity 313379Q69 200,000.00 FHLB Note
2.125% Due 6/10/2022
200,000.00 2,125.00 202,125.00
06/13/2022 Interest 3130AJKW8 225,000.00 FHLB Note
0.5% Due 6/13/2025
0.00 562.50 562.50
06/13/2022 Interest 3130A3GE8 250,000.00 FHLB Note
2.75% Due 12/13/2024
0.00 3,437.50 3,437.50
06/14/2022 Interest 3130A1XJ2 210,000.00 FHLB Note
2.875% Due 6/14/2024
0.00 3,018.76 3,018.76
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 36
3.A.3.a
Packet Pg. 58 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Cash Flow Report
As of July 31, 2021
City of San Jacinto
Account #10167
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
06/15/2022 Paydown 47787NAC3 25,000.00 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
1,083.56 9.24 1,092.80
06/15/2022 Paydown 47788UAC6 40,000.00 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
0.00 12.00 12.00
06/15/2022 Paydown 47789QAC4 45,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
0.00 19.50 19.50
06/15/2022 Paydown 65479JAD5 82,599.72 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
2,255.47 97.02 2,352.49
06/15/2022 Paydown 89240BAC2 75,000.00 Toyota Auto Receivables Owners 2021-A A3
0.26% Due 5/15/2025
3,397.47 16.25 3,413.72
06/15/2022 Paydown 43815NAC8 68,501.34 Honda Auto Receivables Trust 2019-3 A3
1.78% Due 8/15/2023
4,114.11 22.40 4,136.51
06/15/2022 Paydown 58769KAD6 55,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
0.00 18.33 18.33
06/15/2022 Paydown 477870AC3 26,599.54 John Deere Owner Trust 2019-B A3
2.21% Due 12/15/2023
909.48 32.43 941.91
06/15/2022 Paydown 47789KAC7 60,000.00 John Deere Owner Trust 2020-A A3
1.1% Due 8/15/2024
1,585.70 40.68 1,626.38
06/15/2022 Paydown 89236XAC0 45,000.00 Toyota Auto Receivables 2020-D A3
0.35% Due 1/15/2025
1,110.31 9.84 1,120.15
06/15/2022 Paydown 89237VAB5 55,000.00 Toyota Auto Receivables Trust 2020-C A3
0.44% Due 10/15/2024
1,610.83 17.22 1,628.05
06/18/2022 Interest 89236TJK2 120,000.00 Toyota Motor Credit Corp Note
1.125% Due 6/18/2026
0.00 675.00 675.00
06/18/2022 Paydown 43813KAC6 90,000.00 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
4,276.46 23.80 4,300.26
06/19/2022 Interest 3137EAEN5 200,000.00 FHLMC Note
2.75% Due 6/19/2023
0.00 2,750.00 2,750.00
06/21/2022 Paydown 43813GAC5 30,000.00 Honda Auto Receivables Trust 2021-1 A3
0.27% Due 4/21/2025
0.00 6.75 6.75
06/21/2022 Paydown 43815HAC1 8,783.71 Honda Auto Receivables Trust 2018-3 A3
2.95% Due 8/22/2022
632.79 6.25 639.04
06/30/2022 Interest 91282CBC4 250,000.00 US Treasury Note
0.375% Due 12/31/2025
0.00 468.75 468.75
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 37
3.A.3.a
Packet Pg. 59 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Cash Flow Report
As of July 31, 2021
City of San Jacinto
Account #10167
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
JUN 2022 220,976.18 18,331.72 239,307.90
07/07/2022 Interest 3135G0X24 225,000.00 FNMA Note
1.625% Due 1/7/2025
0.00 1,828.13 1,828.13
07/10/2022 Interest 24422EUR8 150,000.00 John Deere Capital Corp Note
3.45% Due 1/10/2024
0.00 2,587.50 2,587.50
07/11/2022 Interest 06051GEU9 130,000.00 Bank of America Corp Note
3.3% Due 1/11/2023
0.00 2,145.00 2,145.00
07/15/2022 Paydown 477870AC3 26,599.54 John Deere Owner Trust 2019-B A3
2.21% Due 12/15/2023
911.38 30.75 942.13
07/15/2022 Paydown 58769KAD6 55,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
0.00 18.33 18.33
07/15/2022 Paydown 47788UAC6 40,000.00 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
0.00 12.00 12.00
07/15/2022 Paydown 43815NAC8 68,501.34 Honda Auto Receivables Trust 2019-3 A3
1.78% Due 8/15/2023
3,889.11 16.30 3,905.41
07/15/2022 Paydown 47787NAC3 25,000.00 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
1,083.98 8.78 1,092.76
07/15/2022 Paydown 47789QAC4 45,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
0.00 19.50 19.50
07/15/2022 Paydown 65479JAD5 82,599.72 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
2,260.55 93.39 2,353.94
07/15/2022 Paydown 89237VAB5 55,000.00 Toyota Auto Receivables Trust 2020-C A3
0.44% Due 10/15/2024
1,611.42 16.63 1,628.05
07/15/2022 Paydown 89240BAC2 75,000.00 Toyota Auto Receivables Owners 2021-A A3
0.26% Due 5/15/2025
3,398.58 15.51 3,414.09
07/15/2022 Paydown 47789KAC7 60,000.00 John Deere Owner Trust 2020-A A3
1.1% Due 8/15/2024
1,590.06 39.23 1,629.29
07/15/2022 Paydown 89236XAC0 45,000.00 Toyota Auto Receivables 2020-D A3
0.35% Due 1/15/2025
1,107.04 9.51 1,116.55
07/18/2022 Paydown 43813KAC6 90,000.00 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
4,277.78 22.48 4,300.26
07/19/2022 Interest 3135G0T94 290,000.00 FNMA Note
2.375% Due 1/19/2023
0.00 3,443.75 3,443.75
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 38
3.A.3.a
Packet Pg. 60 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Cash Flow Report
As of July 31, 2021
City of San Jacinto
Account #10167
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
07/21/2022 Interest 3137EAEU9 145,000.00 FHLMC Note
0.375% Due 7/21/2025
0.00 271.88 271.88
07/21/2022 Paydown 43813GAC5 30,000.00 Honda Auto Receivables Trust 2021-1 A3
0.27% Due 4/21/2025
0.00 6.75 6.75
07/21/2022 Paydown 43815HAC1 8,783.71 Honda Auto Receivables Trust 2018-3 A3
2.95% Due 8/22/2022
634.35 4.69 639.04
07/29/2022 Interest 06406RAE7 145,000.00 Bank of NY Mellon Corp Callable Note Cont
12/29/2022
2.95% Due 1/29/2023
0.00 2,138.75 2,138.75
07/31/2022 Interest 912828Y87 220,000.00 US Treasury Note
1.75% Due 7/31/2024
0.00 1,925.00 1,925.00
07/31/2022 Interest 912828Y61 175,000.00 US Treasury Note
2.75% Due 7/31/2023
0.00 2,406.25 2,406.25
JUL 2022 20,764.25 17,060.11 37,824.36
TOTAL 1,398,660.29 177,013.50 1,575,673.79
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 39
3.A.3.a
Packet Pg. 61 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Important DisclosuresCity of San Jacinto
Account #10167
Chandler Asset Management, Inc. ;͞Chandler͟Ϳis an SEC registered investment adviser. For additional information about our firm, please see our current disclosures (Form ADV). To
obtain a copy of our current disclosures, you may contact your client service representative by calling the number on the front of this statement or you may visit our website at
www.chandlerasset.com.
Information contained in this monthly statement is confidential and is provided for informational purposes only and should not be construed as specific investment or legal advice. The
information contained herein was obtained from sources believed to be reliable as of the date of this statement, but may become outdated or superseded at any time without
notice.
Custody: Your qualified custodian bank maintains control of all assets reflected in this statement and we urge you to compare this statement to the one you receive from your qualified
custodian. Chandler does not have any authority to withdraw or deposit funds from/to the custodian account.
Valuation: Prices are provided by IDC, an independent pricing source. In the event IDC does not provide a price or if the price provided is not reflective of fair market value, Chandler will
obtain pricing from an alternative approved third party pricing source in accordance with our written valuation policy and procedures. Our valuation procedures are also disclosed in
Item 5 of our Form ADV Part 2A.
Performance: Performance results are presented gross-of-advisory fees and represent the client ͛s Total Return. The deduction of advisory fees lowers performance results. These results
include the reinvestment of dividends and other earnings. Past performance may not be indicative of future results. Therefore, clients should not assume that future performance of any
specific investment or investment strategy will be profitable or equal to past performance levels. All investment strategies have the potential for profit or loss. Economic factors, market
conditions or changes in investment strategies, contributions or withdrawals may materially alter the performance and results of your portfolio.
Source ice Data Indices, LLC ("ICE"), used with permission. ICE PERMITS USE OF THE ICE INDICES AND RELATED DATA ON AN "AS IS" BASIS; ICE, ITS AFFILIATES AND THEIR RESPECTIVE
THIRD PARTY SUPPLIERS DISCLAIM ANY AND ALL WARRANTIES AND REPRESENTATIONS, EXPRESS AND/OR IMPLIED, INCLUDING ANY WARRANTIES OF MERCHANTABILITY OR FITNESS
FOR A PARTICULAR PURPOSE OR USE, INCLUDING THE INDICES, INDEX DATA AND ANY DATA INCLUDED IN, RELATED TO, OR DERIVED THEREFROM. NEITHER ICE DATA, ITS AFFILIATES OR
THEIR RESPECTIVE THIRD PARTY PROVIDERS GUARANTEE THE QUALITY, ADEQUACY, ACCURACY, TIMELINESS OR COMPLETENESS OF THE INDICES OR THE INDEX DATA OR ANY
COMPONENT THEREOF, AND THE INDICES AND INDEX DATA AND ALL COMPONENTS THEREOF ARE PROVIDED ON AN "AS IS" BASIS AND LICENSEE'S USE IS AT LICENSEE'S OWN RISK. ICE
DATA, ITS AFFILIATES AND THEIR RESPECTIVE THIRD PARTY DO NOT SPONSOR, ENDORSE, OR RECOMMEND CHANDLER, OR ANY OF ITS PRODUCTS OR SERVICES.
Index returns assume reinvestment of all distributions. Historical performance results for investment indexes generally do not reflect the deduction of transaction and/or custodial
charges or the deduction of an investment management fee, the incurrence of which would have the effect of decreasing historical performance results. It is not possible to invest
directly in an index.
Ratings: Ratings information have been provided by Moody͛s, S&P and Fitch through data feeds we believe to be reliable as of the date of this statement, however we cannot guarantee
its accuracy.
Security level ratings for U.S. Agency issued mortgage-backed securities ;͞MBS͟Ϳreflect the issuer rating because the securities themselves are not rated. The issuing U.S. Agency
guarantees the full and timely payment of both principal and interest and carries a AA+/Aaa/AAA by S&P, Moody ͛s and Fitch respectively.
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 40
3.A.3.a
Packet Pg. 62 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Benchmark Index & DisclosuresCity of San Jacinto California
Account #10167
Benchmark Index Disclosure
City of San Jacinto 1-5 Year Govt
Blended Index*
The ICE BofA 1-5 Year US Treasury & Agency Index tracks the performance of US dollar denominated US Treasury and nonsubordinated US
agency debt issued in the US domestic market. Qualifying securities must have an investment grade rating (based on an average of Moody ͛s,
S&P and Fitch). Qualifying securities must have at least one year remaining term to final maturity and less than five years remaining term to
final maturity, at least 18 months to maturity at time of issuance, a fixed coupon schedule, and a minimum amount outstanding of $1 billion
for sovereigns and $250 million for agencies.
The ICE BofA 1-3 Year US Treasury Index tracks the performance of US dollar-denominated sovereign debt publicly issued by the US
government in its domestic market. Qualifying securities must have at least one year remaining term to final maturity and less than three
years remaining term to final maturity, a fixed coupon schedule, and a minimum amount outstanding of $1 billion. Qualifying securities must
have at least 18 months to final maturity at the time of issuance.
City of San Jacinto 1-5 Yr Corp/Gov
AAA-A Blend*
Execution Time: 8/2/2021 7:19:27 PMChandler Asset Management - CONFIDENTIAL Page 41
3.A.3.a
Packet Pg. 63 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
City of San Jacinto Public Trust Advisors LLC
595 S. San Jacinto Ave.550 South Hope Street
San Jacinto, CA 92583 Suite 560
Los Angeles, CA 90071
Monthly Investment Report for Period Ended July 31, 2021
3.A.3.a
Packet Pg. 64 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Investment Management Portfolio Review Page
Investment Portfolio Summary Comparison 3
Total Return Performance Summary 4
Investment Portfolio Maturity Distribution 6
Investment Portfolio Maturity Distribution By Security Type 7
Investment Portfolio Rating Distribution 8
Investment Portfolio Security Distribution - Market Value 9
Investment Portfolio Security Distribution - Historical Cost 10
Investment Portfolio Compliance 11
Additional Disclosure 12
Portfolio Holdings Detail 13
City of San Jacinto Summary
3.A.3.a
Packet Pg. 65 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
City of San Jacinto
July 1, 2021
Beginning Balance
July 31, 2021
Ending Balance Portfolio Characteristic
July 1, 2021
Beginning Balance
July 31, 2021
Ending Balance
Historical Cost 11,232,745.44$ 11,249,880.14$ Book Yield Gross 0.92%0.86%
Book Value 11,204,837.50$ 11,218,381.73$ Market Yield Gross 0.43%0.35%
Accrued Interest 28,098.25 22,286.17 Weighted Average Coupon 1.12%1.06%
Book Value Plus Accrued 11,232,935.75$ 11,240,667.90$ Duration 2.60 Years 2.58 Years
Net Unrealized Gain/Loss 84,926.89 108,220.53 Weighted Effective Maturity 2.64 Years 2.62 Years
Market Value Plus Accrued(2)11,317,862.64$ 11,348,888.43$ Weighted Final Maturity 2.66 Years 2.64 Years
Net Pending Transactions 0.14 6,237.67
Market Value Plus Accrued Net(2)11,317,862.78$ 11,355,126.11$
City of San Jacinto
July 2021
Net Income Portfolio Compliance Compliant
Interest Income 9,905.33$ Security Distribution YES
Net Amortization/Accretion (1,799.29)Maturity Distribution YES
Net Realized Gain/Loss(3)5,967.81 Rating Distribution YES
Miscellaneous Income -
Net Income 14,073.85$
City of San Jacinto Summary Comparison for the period July 1, 2021 to July 31, 2021
(1) Payables represent amounts due to settle security transactions that have been executed but have not settled as of period end. The funds used to settle these trades may come from a variety of sources including cash within the
portfolio, proceeds from future security transactions including maturities and sales, or other sources including money market funds. For reporting purposes, a payable is created for over-period settlements which are reflected in the
detailed holdings.
(2) Market Value Plus Accrued Net represents the market value of the portfolio net payables and recievables from transactions that settle in the following reporting period.
(3) MBS paydowns may result in negative realized losses rather than amortization in as a result of accounting method.
Page 3
3.A.3.a
Packet Pg. 66 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Trailing Month Trailing 3 Months Trailing 12 Months Year to Date
Total Return Performance Periodic Periodic Periodic Periodic
City of San Jacinto 0.33%0.28%0.13%-0.04%
Trailing 3 Years Trailing 5 Years Since Inception*
Total Return Performance Annualized Annualized Annualized
City of San Jacinto 3.17%1.96%1.50%
*Total return since inception date: December 1, 2012
Annualized total return performance presented for investment periods longer than one year. Return information obtained from Bloomberg.
City of San Jacinto Total Return July 1, 2021 to July 31, 2021
0.33% 0.28% 0.13%
(0.04%)
3.17%
1.96%
1.50%
(0.50%)
0.00%
0.50%
1.00%
1.50%
2.00%
2.50%
3.00%
3.50%
Trailing Month Trailing 3 Months Trailing 12 Months Year to Date Trailing 3 Years Trailing 5 Years Since Inception*YieldTotal Return Performance
City of San Jacinto
Page 4
3.A.3.a
Packet Pg. 67 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Trailing Month Trailing 3 Months Trailing 12 Months Year To Date
Total Return Performance Periodic Periodic Periodic Periodic
City of San Jacinto 0.33%0.28%0.13%-0.04%
BofA ML 1-5 Year U.S. Treasury/Agency 0.35%0.29%-0.07%-0.06%
Since Inception*
Trailing 3 Years Trailing 5 Years February 1, 2020
Total Return Performance Annualized Annualized Annualized
City of San Jacinto NA NA 2.35%
BofA ML 1-5 Year U.S. Treasury/Agency NA NA 2.17%
*Original Total return since inception date: December 1, 2012. The BofA ML 1-5 Year U.S. Treasury/Agency benchmark established on February 1, 2020.
Annualized total return performance presented for investment periods longer than one year. Return information obtained from Bloomberg.
City of San Jacinto Total Return July 1, 2021 to July 31, 2021
0.33% 0.28% 0.35% 0.29%
(0.25%)
0.00%
0.25%
0.50%
0.75%
1.00%
1.25%
1.50%
1.75%
2.00%
2.25%
2.50%
Trailing Month Trailing 3 Months Trailing 12 Months Year To Date Trailing 3 Years Trailing 5 Years February 1, 2020YieldTotal Return Performance vs. Benchmark
City of San Jacinto BofA ML 1-5 Year U.S. Treasury/Agency
Page 5
3.A.3.a
Packet Pg. 68 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Maturity Distribution
July 1, 2021
Beginning Balance
July 31, 2021
Ending Balance Portfolio Allocation Distribution Change
0-3 Months 38,566.58$ 34,614.56$ 0.31%-0.04%
3-6 Months - - 0.00%0.00%
6-9 Months - - 0.00%0.00%
9-12 Months 336,059.83 376,166.95 3.31%0.35%
1-2 Years 4,230,375.45 3,848,933.99 33.91%-3.46%
2-3 Years 2,091,001.45 2,542,416.64 22.40%3.93%
3-4 Years 2,781,159.64 2,944,316.60 25.94%1.37%
4-5 Years 1,840,699.69 1,602,439.70 14.12%-2.14%
5-6 Years - - 0.00%0.00%
6 Years +- - 0.00%0.00%
Total Portfolio 11,317,862.64$ 11,348,888.43$ 100.00%
City of San Jacinto Maturity Distribution Market Value Basis July 1, 2021 to July 31, 2021
$-
$500,000
$1,000,000
$1,500,000
$2,000,000
$2,500,000
$3,000,000
$3,500,000
$4,000,000
$4,500,000
0-3 M 3-6 M 6-9 M 9-12 M 1-2 Yr 2-3 Yr 3-4 Yr 4-5 Yr 5-6 Yr 6 Yr +
Maturity Distribution Comparison
July 1, 2021 July 31, 2021
0-3 M
0.31%
9-12 M
3.31%
1-2 Yr
33.91%
2-3 Yr
22.40%
3-4 Yr
25.94%
4-5 Yr
14.12%
Maturity Distribution
Page 6
3.A.3.a
Packet Pg. 69 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Security Distribution 0-3 Months 3-6 Months 6-9 Months 9-12 Months 1-2 Years 2-3 Years 3-4 Years 4-5 Years Total Portfolio
Cash -$ -$ -$ -$ -$ -$ -$ -$ -$
Money Market Funds 34,615 - - - - - - - 34,615
Certificates of Deposit - - - - - - - - -
Commercial Paper - - - - - - - - -
U.S. Treasury Notes - - - 376,167 854,539 1,239,381 2,406,013 1,190,447 6,066,548
U.S. Agency Notes - - - - - - - - -
Federal Inst. (GSE)*- - - - 2,126,896 1,072,635 538,304 411,992 4,149,827
Corporate Notes - - - - 867,498 230,400 - - 1,097,899
Asset Backed (ABS)- - - - - - - - -
Municipal Bonds - - - - - - - - -
Total 34,615$ -$ -$ 376,167$ 3,848,934$ 2,542,417$ 2,944,317$ 1,602,440$ 11,348,888$
*Mortgage backed securities shown to effective maturity.
City of San Jacinto Maturity Distribution Market Value Basis as of July 31, 2021
$-
$5,000,000
0-3 Months 3-6 Months 6-9 Months 9-12 Months 1-2 Years 2-3 Years 3-4 Years 4-5 Years
Maturity Distribution By Type Municipal Bonds
Asset Backed (ABS)
Corporate Notes
Federal Inst. (GSE)*
U.S. Agency Notes
U.S. Treasury Notes
Commercial Paper
Certificates of Deposit
Money Market Funds
Cash
Page 7
3.A.3.a
Packet Pg. 70 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
S&P Rating Distribution
July 31, 2021
Ending Balance Portfolio Allocation
Short Term Rating Distribution
A-1+-$ 0.00%
A-1 - 0.00%
A-2 - 0.00%
Total Short Term Ratings -$ 0.00%
Long Term Rating Distribution
AAA Rating 574,738.06$ 5.06%
AA Rating 10,688,862.27 94.18%
A Rating 85,288.10 0.75%
Below A - 0.00%
Not Rated - 0.00%
Total Long Term Rating 11,348,888.43$ 100.00%
Total Portfolio 11,348,888.43$ 100.00%
Moody's Rating Distribution
July 31, 2021
Ending Balance Portfolio Allocation
Short Term Rating Distribution
P-1 -$ 0.00%
P-2 - 0.00%
Total Short Term Ratings -$ 0.00%
Long Term Rating Distribution
Aaa Rating 10,494,227.23$ 92.47%
Aa Rating 624,260.75 5.50%
A Rating 230,400.45 2.03%
Below A - 0.00%
Not Rated - 0.00%
Total Long Term Rating 11,348,888.43$ 100.00%
Total Portfolio 11,348,888.43$ 100.00%
City of San Jacinto Rating Distribution Market Value Basis as of July 31, 2021
AAA Rating
5.06%
AA Rating
94.18%
A Rating
0.75%
Portfolio Allocation By Standard and Poors' Rating
Aaa Rating
92.47%
Aa Rating
5.50%
A Rating
2.03%
Portfolio Allocation By Moody's Rating
Page 8
3.A.3.a
Packet Pg. 71 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Security Distribution
July 1, 2021
Beginning Balance
Portfolio
Allocation
July 31, 2021
Ending Balance Book Yield
Portfolio
Allocation
Change in
Allocation
Permitted by
Policy*Compliant
Cash -$ 0.00%-$ 0.00%0.00%0.00%YES
LGIP - 0.00%- 0.00%0.00%0.00%YES
U.S. Treasury Notes 6,036,360.73 53.33%6,066,547.96 0.78%53.45%0.12%NO
U.S. Agency Notes - 0.00%- 0.00%0.00%0.00%YES
FNMA 729,032.04 6.44%732,210.04 0.39%6.45%0.01%NO
FHLMC 2,105,850.74 18.61%2,108,446.60 1.34%18.58%-0.03%NO
FFCB 774,478.02 6.84%775,988.39 0.31%6.84%-0.01%NO
FHLB 531,269.11 4.69%533,181.96 1.08%4.70%0.00%NO
Fed Instrumentality Subtotal 4,140,629.90$ 36.58%4,149,826.99$ 0.95%36.57%-0.02%NO
Asset Backed Securities - 0.00%- 0.00%0.00%0.00%YES
Commercial Paper - 0.00%- 0.00%0.00%0.00%YES
Corporate Notes 1,102,305.42 9.74%1,097,898.92 1.04%9.67%-0.07%NO
Bankers Acceptances - 0.00%- 0.00%0.00%0.00%YES
Money Market Funds 38,566.58 0.34%34,614.56 0.01%0.31%-0.04%YES
Municipal Bonds - 0.00%- 0.00%0.00%0.00%YES
Intergovernmental Funds - 0.00%- 0.00%0.00%0.00%YES
Certificates of Deposit - 0.00%- 0.00%0.00%0.00%YES
Total Portfolio Market Value 11,317,862.64$ 100.00%11,348,888.43$ 0.86%100.00%
*Permitted allocation based on aggregate assets as defined within the investment policy.
City of San Jacinto Market Value Basis Security Distribution July 1, 2021 to July 31, 2021
$-
$1,000,000
$2,000,000
$3,000,000
$4,000,000
$5,000,000
$6,000,000
$7,000,000
CashLGIPUSTAgencyFNMAFHLMCFFCBFHLBABSCPCorpBAMMFMuniInter GovCDAsset Balance By Security Type
(in millions)
July 1, 2021 July 31, 2021
UST
53.45%
FNMA
6.45%
FHLMC
18.58%
FFCB
6.84%
FHLB
4.70%
Corp
9.67%
MMF
0.31%
Ending Portfolio Allocation
Page 9
3.A.3.a
Packet Pg. 72 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Security Distribution
July 1, 2021
Beginning Balance
Portfolio
Allocation
July 31, 2021
Ending Balance Book Yield
Portfolio
Allocation
Change in
Allocation
Permitted by
Policy*Compliant
Cash -$ 0.00%-$ 0.00%0.00%0.00%YES
U.S. Treasury Notes 5,994,799.04 53.37%6,015,885.76 0.78%53.48%0.11%NO
U.S. Agency Notes - 0.00%- 0.00%0.00%0.00%YES
FNMA 732,693.00 6.52%732,693.00 0.39%6.51%-0.01%NO
FHLMC 2,070,796.02 18.44%2,070,796.02 1.34%18.41%-0.03%NO
FFCB 773,408.50 6.89%773,408.50 0.31%6.87%-0.01%NO
FHLB 523,332.00 4.66%523,332.00 1.08%4.65%-0.01%NO
Fed Instrumentality Subtotal 4,100,229.52$ 36.50%4,100,229.52$ 0.94%36.45%-0.06%NO
Asset Backed Securities - 0.00%- 0.00%0.00%0.00%YES
Commercial Paper - 0.00%- 0.00%0.00%0.00%YES
Corporate Notes 1,099,150.30 9.79%1,099,150.30 1.04%9.77%-0.01%NO
Bankers Acceptances - 0.00%- 0.00%0.00%0.00%YES
Money Market Funds 38,566.58 0.34%34,614.56 0.01%0.31%-0.04%YES
Municipal Bonds - 0.00%- 0.00%0.00%0.00%YES
Intergovernmental Funds - 0.00%- 0.00%0.00%0.00%YES
Certificates of Deposit - 0.00%- 0.00%0.00%0.00%YES
Total Portfolio Historical Cost 11,232,745.44$ 100.00%11,249,880.14$ 0.86%100.00%
*Permitted allocation based on aggregate assets as defined within the investment policy.
City of San Jacinto Historical Cost Basis Security Distribution July 1, 2021 to July 31, 2021
$-
$1,000,000
$2,000,000
$3,000,000
$4,000,000
$5,000,000
$6,000,000
$7,000,000
CashUSTAgencyFNMAFHLMCFFCBFHLBABSCPCorpBAMMFMuniInter GovCDAsset Balance By Security Type
(in millions)
July 1, 2021 July 31, 2021
UST
53.48%
FNMA
6.51%
FHLMC
18.41%
FFCB
6.87%
FHLB
4.65%
Corp
9.77%
MMF
0.31%
Ending Portfolio Allocation
Page 10
3.A.3.a
Packet Pg. 73 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Policy
Section Description Compliance Requirement Compliant
Policy
Section Description Compliance Requirement Compliant
IX. 1,2 Municipal Bonds Rated A or better by 1 NRSRO, 5% issuer limitation, 30% total portfolio limit,
5-year maturity limit Compliant IX. 14 Pass-Through
Securities
Issuer debt rated at least A by 2 NRSRO's; Must be rated in the AA category by
2 NRSRO's; 20% total portfolio limit, 5-year maturity limit Compliant
IX. 1 U.S. Treasury No limitations Compliant
IX. 2 Federal Agency No limitations Compliant
IX. 3 Bankers
Acceptances
Rated A1 or better and have long term debt rated A or better by 2 NRSRO's;
Maturity ≤ to 180 days, 40% total portfolio limit, 5% issuer limit Compliant
IX. 4 Federally Insured
Time Deposits
Limited to amounts covered under federal insurance; 20% total portfolio
limit in combination with IX.5; 5-year maturity limit Compliant IX. 17.b Money Market
Funds
Registered with SEC under 1940 Act, have highest ranking by 2 NRSRO's;
retained advisor registered (or exempt from registration) with 5-years
experience investing in securities authorized by CA 53601 and at least $500
million of assets; 20% total portfolio limit
Compliant
IX. 5 Time Deposits
Fully collateralized per CA law, 20% limit when combined with IX.4; Issuer
must have long-term debt rated A or higher and/or short-term debt rated
A1 or higher by 2 NRSRO's, 5-year maturity limit
Compliant IX. 18 Supranationals
US dollar denominated senior unsecured unsubordinated obligations issued or
unconditionally guaranteed by IBRD, IFC, or IADB; rated AA or higher by 1
NRSRO; 30% total portfolio limit; 10% issuer limit; 5-year maturity limit
Compliant
IX. 6 CDARS 30% limit in combination of CD's (including CDARS); 5-year maturity limit Compliant X.A.1 Futures and Options Prohibited Compliant
IX. 7 Negotiable CD's
Issuer must have long-term debt rated A or higher and/or short-term debt
rated A1 or higher by 2 NRSRO's; Maturity ≤ to 5 years, 30% total portfolio
limit, 5% issuer limit
Compliant X.A.2
Inverse Floaters,
Range Notes, and
Mortgage Derived
IO Strips
Prohibited Compliant
IX. 8 Collateralized
Bank Deposits
Collateralized with pleged securities per CA Government Code Section
53651 Compliant X.A.3 Potential Zero
Accrual Securities Prohibited Compliant
X.A.5 Purchasing
Securities on Margin Prohibited Compliant
X.A.6 Reverse Repos or
other leverage Prohibited Compliant
X.A.7 Foreign Currency
Securities Prohibited Compliant
X.B.2 Single Issuer
Limitation
5% issuer limitation, except U.S. Government, its agencies & enterprises,
Money Market Mutual Funds, Mutual Funds, LAIF, LGIP's, and Supranationals Compliant
IX. 11 Local Agency
Investment Fund 70% total portfolio limit, up to the maximum permitted balance Compliant X.C.2 Callable Security
Limitation 20% of total portfolio (excluding Make Whole Call securities)Compliant
IX. 12 Local Government
Investment Pools
Riveride County Investment Fund limited to 70% of the portfolio; JPA Pools
limited to 50% of the portfolio Compliant X.C.3 Maximum Security
Maturity Individual security maturities limited to 5-years or less Compliant
IX. 13 Corporate Bonds
Corporations organized and operating in the U.S. or depository institutions
licensed by the U.S. or any state and operating in the U.S.; Rated in the A
category or better by 2 NRSRO's, 5-year maturity limit; 30% total portfolio
limit, 5% issuer limit
Compliant X.C.4 Portfolio Duration
Limitation
Average portfolio duration will be managed to be approximatly equal to the
Market Benchmark selected by the City (typically +/- 20 of benchmark
duration)
Compliant
City of San Jacinto Portfolio Compliance July 1, 2021 to July 31, 2021
IX. 17.e Mutual Funds
Invests in securities authorized by specified provisions in CA Government Code
Section 53601; have highest ranking by 2 NRSRO's; retained advisor registered
(or exempt from registration) with 5-years experience investing in securities
authorized by CA 53601 and at least $500 million of assets; 10% per fund limit;
20% limit when combined with IX.17.b
Compliant
IX. 9 Repurchase
Agreements
Collateralized at 102% in accordance with policy; 1-year maturity limit, no %
portfolio limit, collateral held by custodian bank; subject to master
repurchase agreement substantially in SIFMA's form
Compliant
IX. 10 Commercial Paper
Issuer is organized and operating in the U.S. with assets of at least $500
million; Issuer short-term ratings of A1 or higher and long-term ratings of A
or higher by 2 NRSRO's; Maturity ≤ 270 days; 25% total portfolio limit; 5%
issuer limit
Compliant
Page 11
3.A.3.a
Packet Pg. 74 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Additional Disclosure
This information is for the sole purposes of the client and is not intended to provide specific advice or recommendations. Please review the contents of this information carefully. Should you have any
questions regarding the information presented, calculation methodology, investment portfolio, security detail, or any other facet of this information, please feel free to contact us.
Public Trust Advisors, LLC (Public Trust) statements and reports are intended to detail our investment advisory activity as well as the activity of certain client accounts managed by Public Trust. The
custodian bank maintains the control of assets and executes and settles all investment transactions. The custodian statement is the official record of security and cash holdings transactions. Public
Trust recognizes that clients may use these reports to facilitate record keeping; therefore, it is recommended that the client reconcile this information with their custodian bank statement. Many
custodians use a settlement date basis that may result in the need to reconcile due to a timing difference. The underlying market value, amortized cost, and accrued interest may differ between the
custodian and this statement or report. This can be attributed to differences in calculation methodologies and pricing sources used.
Public Trust does not have the authority to withdraw funds from or deposit funds to the custodian. Our clients retain responsibility for their internal accounting policies, implementing and enforcing
internal controls, and generating ledger entries or otherwise recording transactions. The total market value represents prices obtained from various sources; it may be impacted by the frequency at
which prices are reported, and such prices are not guaranteed. Prices received from pricing vendors are generally based on current market quotes but when such quotes are not available, the pricing
vendors use a variety of techniques to estimate value. These estimates, particularly for fixed-income securities, may be based on certain minimum principal amounts (e.g. $1 million) and may not
reflect all the factors that affect the value of the security including liquidity risk. The prices provided are not firm bids or offers. Certain securities may reflect N/A or unavailable where the price for
such security is generally not available from a pricing source. The market value of a security, including those priced at par value, may differ from its purchase price and may not closely reflect the
value at which the security may be sold or purchased based on various market factors. The securities in this investment portfolio, including shares of mutual funds, are not guaranteed or otherwise
protected by Public Trust, the FDIC (except for certain non-negotiable certificates of deposit), or any government agency unless specifically stated otherwise.
Clients may be permitted to establish one or more unmanaged accounts for the purposes of client reporting. Clients may also be permitted to provide externally managed assets for the purposes of
client reporting. Public Trust defines unmanaged accounts or assets as one where the investment direction remains the sole responsibility of the client rather than the Investment Manager.
Unmanaged accounts or external assets do not receive ongoing supervision and monitoring services. The Investment Manager does not make any investment recommendations and may not charge a
fee for reporting on these accounts or assets. The primary purpose for this service is to include unmanaged accounts or assets owned by the client in the performance reports provided by the
Investment Manager. The Investment Manager assumes no liability for the underlying performance of any unmanaged accounts or assets, and it is the client’s sole responsibility for the accuracy or
correctness of any such performance.
Beginning and ending balances are based on market value plus accrued interest on a trade date basis. Statements and reports made available to the end user either from Public Trust or through the
online reporting platform may present information and portfolio analytics using various optional methods including, but not limited to, historical cost, amortized cost, and market value. All
information is assumed to be correct, but the accuracy has not been confirmed and therefore is not guaranteed to be correct. Information is obtained from third party sources that may or may not
be verified. The data in this report is unaudited and is only applicable for the date denoted on the report. Market values may change day-to-day based on numerous circumstances such as trading
volume, news released about the underlying issuer, issuer performance, etc. Underlying market values may be priced via numerous aspects as certain securities are short term in nature and not
readily traded. Performance results are shown net of all fees and expenses and reflect the reinvestment of dividends and other earnings.
Many factors affect performance including changes in market conditions and interest rates and in response to other economic, political, or financial developments. Investment involves risk including
the possible loss of principal. No assurance can be given that the performance objectives of a given strategy will be achieved. Past performance is no guarantee of future results. Any financial and/or
investment decision may incur losses.
The investment advisor providing these services is Public Trust Advisors, LLC, an investment adviser registered with the U.S.Securities and Exchange Commission (SEC) under the Investment Advisers
Act of 1940, as amended. Registration with the SEC does not imply a certain level of skill or training. Public Trust is required to maintain a written disclosure brochure of our background and business
experience. If you would like to receive a copy of our current disclosure brochure, Privacy Policy, or Code of Ethics, or have any questions regarding your account please contact us.
Public Trust Advisors
717 17th Street, Suite 1850
Denver, CO 80202
Page 12
3.A.3.a
Packet Pg. 75 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Portfolio Holdings
Portfolio Income
Portfolio Transactions
Issuer Concentration
Security Concentration
Portfolio Activity Summary
City of San Jacinto Detail
Page 13
3.A.3.a
Packet Pg. 76 Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Month End Report Trade Date copySan Jacinto, City of (66779)Month End (M1 Y2022)07/01/2021 - 07/31/2021Dated: 08/05/2021Locked Down3.A.3.aPacket Pg. 77Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Holdings Report Trade Date (San Jacinto, City of (66779))1Income Detail Report Trade Date (San Jacinto, City of (66779))5Transactions Realized Gain Loss Report (San Jacinto, City of (66779))7Issuer Concentration with Yield GASB 40 Trade Date (San Jacinto, City of(66779))8Security Type GASB 40 Trade Date (San Jacinto, City of (66779))13Portfolio Activity Summary (San Jacinto, City of (66779))18Table of ContentsDated: 08/05/20213.A.3.aPacket Pg. 78Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Description,Identifier,Security Type,CouponEffective Maturity,Final Maturity,Callable,Next Call DateOriginal Cost,Current Units,Market PriceTrade Date,Settle DateMoodysRating,S&P Rating,Fitch RatingBook Value,Book Value + AccruedAccrued Balance,Net Unrealized Gain/LossMarket Value,Market Value + AccruedFEDERAL HOME LOAN MORTGAGE CORP3137EAEP0AGCY BOND1.50002/12/202502/12/2025N---299,769.00300,000.00103.588602/13/202002/14/2020AaaAA+---299,834.86301,947.362,112.5010,931.08310,765.94312,878.44FEDERAL HOME LOAN BANKS3130AJ7E3AGCY BOND1.37502/17/202302/17/2023N---299,448.00300,000.00101.959202/20/202002/21/2020AaaAA+---299,711.80301,590.971,879.176,165.76305,877.57307,756.73FEDERAL HOME LOAN BANKS3130AJHU6AGCY BOND0.50004/14/202504/14/2025N---223,884.00225,000.00100.040404/15/202004/16/2020AaaAA+---224,169.59224,503.96334.38921.26225,090.85225,425.22FEDERAL HOME LOAN MORTGAGE CORP3137EAEQ8AGCY BOND0.37504/20/202304/20/2023N---334,162.50335,000.00100.389404/17/202004/20/2020AaaAA+---334,518.86334,871.31352.451,785.57336,304.43336,656.87FEDERAL HOME LOAN MORTGAGE CORP3137EAER6AGCY BOND0.37505/05/202305/05/2023N---334,859.30335,000.00100.353505/05/202005/07/2020AaaAA+---334,917.36335,217.46300.101,267.02336,184.37336,484.48FEDERAL FARM CREDIT BANKS FUNDING CORP3133ELG81AGCY BOND0.30006/08/202306/08/2023N---333,907.90335,000.00100.216106/05/202006/09/2020AaaAA+---334,323.48334,471.44147.961,400.54335,724.02335,871.97FEDERAL HOME LOAN MORTGAGE CORP3137EAEV7AGCY BOND0.25008/24/202308/24/2023N---234,760.30235,000.00100.092908/19/202008/21/2020AaaAA+---234,835.37235,091.58256.22382.87235,218.24235,474.46FEDERAL NATIONAL MORTGAGE ASSOCIATION3135G05X7AGCY BOND0.37508/25/202508/25/2025N---413,057.80415,000.0099.112808/25/202008/27/2020AaaAA+---413,415.31414,089.69674.38-2,097.39411,317.92411,992.30FEDERAL FARM CREDIT BANKS FUNDING CORP3133EMGX4AGCY BOND0.12511/23/202211/23/2022N---219,579.80220,000.00100.003511/16/202011/23/2020AaaAA+---219,724.62219,776.5651.94283.14220,007.76220,059.70FEDERAL NATIONAL MORTGAGE ASSOCIATION3135G06H1AGCY BOND0.25011/27/202311/27/2023N---319,635.20320,000.00100.023611/23/202011/25/2020AaaAA+---319,718.07319,860.29142.22357.45320,075.52320,217.74FEDERAL FARM CREDIT BANKS FUNDING CORP3133EMRZ7AGCY BOND0.25002/26/202402/26/2024N---219,920.80220,000.0099.918102/22/202102/26/2021AaaAA+---219,932.14220,168.95236.81-112.23219,819.91220,056.71EXXON MOBIL CORP30231GBB7CORP1.90208/16/202208/16/2022N---75,000.0075,000.00101.756808/13/201908/16/2019Aa2AA----75,000.0075,653.81653.811,317.5776,317.5776,971.38APPLE INC037833DE7CORP2.40012/13/202201/13/2023Y12/13/2022304,260.00300,000.00102.857012/10/201912/12/2019Aa1AA+---301,968.84302,328.84360.006,602.01308,570.85308,930.85MICROSOFT CORP594918AT1CORP2.37502/01/202305/01/2023Y02/01/2023246,484.45235,000.00102.911704/28/202004/30/2020AaaAAA---241,280.45242,675.761,395.31561.95241,842.41243,237.72WALMART INC931142EK5CORP3.40005/26/202306/26/2023Y05/26/2023243,666.00225,000.00105.606604/29/202005/01/2020Aa2AA---236,103.79236,847.54743.751,510.97237,614.77238,358.52PEPSICO INC713448FB9CORP0.40010/07/202310/07/2023N---84,951.5585,000.00100.212310/06/202010/07/2020A1A+---84,964.6985,072.35107.67215.7585,180.4385,288.10Holdings Report Trade DateSan Jacinto, City of (66779)As of 07/31/2021Return to Table of ContentsDated: 08/05/202113.A.3.aPacket Pg. 79Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Description,Identifier,Security Type,CouponEffective Maturity,Final Maturity,Callable,Next Call DateOriginal Cost,Current Units,Market PriceTrade Date,Settle DateMoodysRating,S&P Rating,Fitch RatingBook Value,Book Value + AccruedAccrued Balance,Net Unrealized Gain/LossMarket Value,Market Value + AccruedAMAZON.COM INC023135BW5CORP0.45005/12/202405/12/2024N---144,788.30145,000.0099.978705/11/202105/12/2021A1AA---144,803.74144,946.92143.19165.43144,969.16145,112.35FHMS K-033 A23137B4WB8FHLMC3.06006/08/202307/25/2023Y---258,544.92250,000.00104.684112/12/201912/17/2019AaaAA+---254,399.70255,037.20637.507,310.48261,710.17262,347.67FHMS K-725 A2US3137BWWD24FHLMC3.00212/20/202301/25/2024Y---289,012.50280,000.00105.780512/12/201912/17/2019AaaAAA---285,237.68285,938.14700.4710,947.64296,185.32296,885.78FHMS K-024 A23137AXHP1FHLMC CMO2.57308/16/202209/25/2022Y---319,687.50320,000.00102.197705/02/201905/07/2019AaaAA+---319,529.32320,215.46686.137,503.45327,032.77327,718.90FIRST AMER:GVT OBLG Y31846V203MMFUND0.01007/31/202107/31/2021N---34,614.5634,614.561.0000------AaaAAAm---34,614.5634,614.560.000.0034,614.5634,614.56UNITED STATES TREASURY912828L57US GOV1.75009/30/202209/30/2022N---174,890.63175,000.00101.914106/26/201906/27/2019AaaAA+---174,960.85175,990.051,029.203,388.82178,349.67179,378.88UNITED STATES TREASURY912828Y87US GOV1.75007/31/202407/31/2024N---351,162.11350,000.00104.183612/06/201912/10/2019AaaAA+---350,762.42350,779.0616.6413,880.18364,642.60364,659.24UNITED STATES TREASURY912828YE4US GOV1.25008/31/202408/31/2024N---294,257.81300,000.00102.683612/06/201912/10/2019AaaAA+---296,203.74297,773.031,569.2911,847.06308,050.80309,620.09UNITED STATES TREASURY9128286Z8US GOV1.75006/30/202406/30/2024N---95,304.3095,000.00104.089812/06/201912/10/2019AaaAA+---95,197.3895,341.95144.573,687.9398,885.3199,029.88UNITED STATES TREASURY912828V80US GOV2.25001/31/202401/31/2024N---188,837.30185,000.00104.941412/12/201912/17/2019AaaAA+---187,358.03187,369.3411.316,783.56194,141.59194,152.90UNITED STATES TREASURY912828YE4US GOV1.25008/31/202408/31/2024N---376,012.50370,000.00102.683603/02/202003/04/2020AaaAA+---374,152.54376,088.011,935.465,776.78379,929.32381,864.78UNITED STATES TREASURY912828YY0US GOV1.75012/31/202412/31/2024N---166,500.00160,000.00104.460903/02/202003/04/2020AaaAA+---164,627.61164,871.09243.482,509.83167,137.44167,380.92UNITED STATES TREASURY912828T91US GOV1.62510/31/202310/31/2023N---114,808.20110,000.00103.132806/05/202006/09/2020AaaAA+---113,192.11113,643.84451.73253.97113,446.08113,897.81UNITED STATES TREASURY912828T26US GOV1.37509/30/202309/30/2023N---263,835.35255,000.00102.500006/05/202006/09/2020AaaAA+---260,788.96261,967.291,178.33586.04261,375.00262,553.33UNITED STATES TREASURY912828ZC7US GOV1.12502/28/202502/28/2025N---226,943.75220,000.00102.308606/05/202006/09/2020AaaAA+---225,276.35226,312.081,035.73-197.43225,078.92226,114.65UNITED STATES TREASURY91282CAN1US GOV0.12509/30/202209/30/2022N---274,914.06275,000.00100.023410/13/202010/14/2020AaaAA+---274,948.98275,064.50115.52115.37275,064.35275,179.87Holdings Report Trade DateSan Jacinto, City of (66779)As of 07/31/2021Return to Table of ContentsDated: 08/05/202123.A.3.aPacket Pg. 80Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Description,Identifier,Security Type,CouponEffective Maturity,Final Maturity,Callable,Next Call DateOriginal Cost,Current Units,Market PriceTrade Date,Settle DateMoodysRating,S&P Rating,Fitch RatingBook Value,Book Value + AccruedAccrued Balance,Net Unrealized Gain/LossMarket Value,Market Value + AccruedUNITED STATES TREASURY912828Z52US GOV1.37501/31/202501/31/2025N---130,966.80125,000.00103.183610/13/202010/14/2020AaaAA+---129,862.31129,866.984.67-882.81128,979.50128,984.17UNITED STATES TREASURY912828ZW3US GOV0.25006/30/202506/30/2025N---253,894.34255,000.0098.882811/02/202011/04/2020AaaAA+---254,069.43254,124.8655.43-1,918.29252,151.14252,206.57UNITED STATES TREASURY912828ZT0US GOV0.25005/31/202505/31/2025N---233,971.88235,000.0098.964812/03/202012/04/2020AaaAA+---234,121.70234,221.2299.52-1,554.42232,567.28232,666.80UNITED STATES TREASURY912828ZT0US GOV0.25005/31/202505/31/2025N---189,094.53190,000.0098.964801/06/202101/08/2021AaaAA+---189,209.68189,290.1480.46-1,176.56188,033.12188,113.58UNITED STATES TREASURY91282CAT8US GOV0.25010/31/202510/31/2025N---188,567.58190,000.0098.539101/06/202101/08/2021AaaAA+---188,733.64188,853.68120.04-1,509.35187,224.29187,344.33UNITED STATES TREASURY91282CAZ4US GOV0.37511/30/202511/30/2025N---204,375.39205,000.0099.023402/04/202102/05/2021AaaAA+---204,437.84204,568.07130.23-1,439.87202,997.97203,128.20UNITED STATES TREASURY912828ZL7US GOV0.37504/30/202504/30/2025N---154,461.13155,000.0099.519502/24/202102/26/2021AaaAA+---154,515.84154,662.73146.89-260.61154,255.23154,402.12UNITED STATES TREASURY91282CBC4US GOV0.37512/31/202512/31/2025N---153,395.51155,000.0098.914102/24/202102/26/2021AaaAA+---153,536.09153,586.6350.54-219.23153,316.86153,367.40UNITED STATES TREASURY91282CBH3US GOV0.37501/31/202601/31/2026N---122,236.33125,000.0098.847703/29/202103/31/2021AaaAA+---122,426.90122,428.171.271,132.73123,559.63123,560.90UNITED STATES TREASURY91282CBU4US GOV0.12503/31/202303/31/2023N---399,875.00400,000.0099.953103/29/202103/31/2021AaaAA+---399,895.98400,064.01168.03-83.58399,812.40399,980.43UNITED STATES TREASURY91282CBT7US GOV0.75003/31/202603/31/2026N---299,566.41300,000.00100.429705/06/202105/10/2021AaaAA+---299,586.36300,342.51756.151,702.74301,289.10302,045.25UNITED STATES TREASURY91282CCC3US GOV0.25005/15/202405/15/2024N---219,510.16220,000.0099.812506/03/202106/07/2021AaaAA+---219,534.99219,651.56116.5852.51219,587.50219,704.08UNITED STATES TREASURY91282CCF6US GOV0.75005/31/202605/31/2026N---219,028.91220,000.00100.328106/03/202106/07/2021AaaAA+---219,057.68219,337.18279.511,664.14220,721.82221,001.33UNITED STATES TREASURY91282CBR1US GOV0.25003/15/202403/15/2024N---348,550.78350,000.0099.918007/02/202107/06/2021AaaAA+---348,588.65348,919.15330.501,124.35349,713.00350,043.50UNITED STATES TREASURY9128287C8US GOV1.75007/15/202207/15/2022N---370,925.00370,000.00101.585910/29/201910/30/2019AaaAA+---370,331.47370,630.59299.125,536.36375,867.83376,166.95------------03/13/202403/20/2024------11,249,880.1411,179,614.56---------AaaAA+---11,218,381.7311,240,667.9022,286.17108,220.5311,326,602.2611,348,888.43Holdings Report Trade DateSan Jacinto, City of (66779)As of 07/31/2021Return to Table of ContentsDated: 08/05/202133.A.3.aPacket Pg. 81Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
* Filtered By: Description ¹ "Payable" and Description ¹ "Receivable". * Weighted by: Market Value + Accrued.Holdings Report Trade DateSan Jacinto, City of (66779)As of 07/31/2021Return to Table of ContentsDated: 08/05/202143.A.3.aPacket Pg. 82Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Identifier,DescriptionFinal MaturityEnding Current UnitsEarned InterestIncomeRealized Gain,Realized LossAccretion IncomeAmortization ExpenseMisc IncomeNet Earned IncomeInterest PaymentReceived,Ending Interest Due91282CCF6UNITED STATES TREASURY05/31/2026220,000.00139.750.000.0016.210.000.00155.970.000.0091282CBT7UNITED STATES TREASURY03/31/2026300,000.00190.570.000.007.450.000.00198.030.000.0091282CBH3UNITED STATES TREASURY01/31/2026125,000.0040.130.000.0048.010.000.0088.140.00234.3891282CBC4UNITED STATES TREASURY12/31/2025155,000.0048.960.000.0027.610.000.0076.570.000.0091282CAZ4UNITED STATES TREASURY11/30/2025205,000.0065.110.000.0010.890.000.0076.010.000.0091282CAT8UNITED STATES TREASURY10/31/2025190,000.0040.010.000.0024.900.000.0064.910.000.003135G05X7FEDERAL NATIONAL MORTGAGE ASSOCIATION08/25/2025415,000.00129.690.000.0033.030.000.00162.720.000.00912828ZW3UNITED STATES TREASURY06/30/2025255,000.0053.700.000.0019.910.000.0073.610.000.00912828ZT0UNITED STATES TREASURY05/31/2025235,000.0049.760.000.0019.300.000.0069.060.000.00912828ZT0UNITED STATES TREASURY05/31/2025190,000.0040.230.000.0017.360.000.0057.590.000.00912828ZL7UNITED STATES TREASURY04/30/2025155,000.0048.960.000.0010.790.000.0059.760.000.003130AJHU6FEDERAL HOME LOAN BANKS04/14/2025225,000.0093.750.000.0018.780.000.00112.530.000.00912828ZC7UNITED STATES TREASURY02/28/2025220,000.00208.490.000.000.00-123.020.0085.470.000.003137EAEP0FEDERAL HOME LOAN MORTGAGE CORP02/12/2025300,000.00375.000.000.003.890.000.00378.890.000.00912828Z52UNITED STATES TREASURY01/31/2025125,000.00147.110.000.000.00-118.390.0028.720.00859.38912828YY0UNITED STATES TREASURY12/31/2024160,000.00235.870.000.000.00-112.670.00123.200.000.00912828YE4UNITED STATES TREASURY08/31/2024300,000.00315.900.000.00100.860.000.00416.760.000.00912828YE4UNITED STATES TREASURY08/31/2024370,000.00389.610.000.000.00-111.830.00277.780.000.00912828Y87UNITED STATES TREASURY07/31/2024350,000.00524.240.000.000.00-21.150.00503.090.003,062.509128286Z8UNITED STATES TREASURY06/30/202495,000.00140.050.000.000.00-5.590.00134.460.000.0091282CCC3UNITED STATES TREASURY05/15/2024220,000.0046.330.000.0013.990.000.0060.330.000.00023135BW5AMAZON.COM INC05/12/2024145,000.0054.380.000.005.910.000.0060.280.000.0091282CBR1UNITED STATES TREASURY03/15/2024350,000.0061.820.000.0037.870.000.0099.690.000.003133EMRZ7FEDERAL FARM CREDIT BANKS FUNDING CORP02/26/2024220,000.0045.830.000.002.250.000.0048.090.000.00912828V80UNITED STATES TREASURY01/31/2024185,000.00356.270.000.000.00-78.770.00277.490.002,081.25US3137BWWD24FHMS K-725 A201/25/2024280,000.00700.480.000.000.00-197.110.00503.37700.480.003135G06H1FEDERAL NATIONAL MORTGAGE ASSOCIATION11/27/2023320,000.0066.670.000.0010.200.000.0076.870.000.00912828T91UNITED STATES TREASURY10/31/2023110,000.00150.580.000.000.00-119.220.0031.360.000.00713448FB9PEPSICO INC10/07/202385,000.0028.330.000.001.360.000.0029.700.000.00912828T26UNITED STATES TREASURY09/30/2023255,000.00296.980.000.000.00-225.750.0071.230.000.00Income Detail Report Trade DateSan Jacinto, City of (66779)07/01/2021 - 07/31/2021Return to Table of ContentsDated: 08/05/202153.A.3.aPacket Pg. 83Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
* Filtered By: Description ¹ "Payable" and Description ¹ "Receivable". * Weighted by: Ending Market Value + Accrued.Identifier,DescriptionFinal MaturityEnding Current UnitsEarned InterestIncomeRealized Gain,Realized LossAccretion IncomeAmortization ExpenseMisc IncomeNet Earned IncomeInterest PaymentReceived,Ending Interest Due3137EAEV7FEDERAL HOME LOAN MORTGAGE CORP08/24/2023235,000.0048.960.000.006.810.000.0055.770.000.003137B4WB8FHMS K-033 A207/25/2023250,000.00637.500.000.000.00-216.230.00421.27637.500.00931142EK5WALMART INC06/26/2023225,000.00637.500.000.000.00-514.630.00122.870.000.003133ELG81FEDERAL FARM CREDIT BANKS FUNDING CORP06/08/2023335,000.0083.750.000.0030.830.000.00114.580.000.003137EAER6FEDERAL HOME LOAN MORTGAGE CORP05/05/2023335,000.00104.690.000.003.990.000.00108.680.000.00594918AT1MICROSOFT CORP05/01/2023235,000.00465.100.000.000.00-351.150.00113.950.000.003137EAEQ8FEDERAL HOME LOAN MORTGAGE CORP04/20/2023335,000.00104.690.000.0023.620.000.00128.310.000.0091282CBU4UNITED STATES TREASURY03/31/2023400,000.0042.350.000.005.290.000.0047.640.000.003130AJ7E3FEDERAL HOME LOAN BANKS02/17/2023300,000.00343.750.000.0015.760.000.00359.510.000.00037833DE7APPLE INC01/13/2023300,000.00600.000.000.000.00-120.580.00479.423,600.000.003133EMGX4FEDERAL FARM CREDIT BANKS FUNDING CORP11/23/2022220,000.0022.920.000.0017.690.000.0040.610.000.00912828L57UNITED STATES TREASURY09/30/2022175,000.00259.390.000.002.820.000.00262.210.000.0091282CAN1UNITED STATES TREASURY09/30/2022275,000.0029.120.000.003.710.000.0032.820.000.003137AXHP1FHMS K-024 A209/25/2022320,000.00686.130.000.00-6.080.000.00680.05686.130.0030231GBB7EXXON MOBIL CORP08/16/202275,000.00118.880.000.000.000.000.00118.880.000.009128287C8UNITED STATES TREASURY07/15/2022370,000.00549.530.000.000.00-29.260.00520.273,237.500.00912828XG0UNITED STATES TREASURY06/30/20220.0043.313,567.370.007.870.000.003,618.540.000.00912828J76UNITED STATES TREASURY03/31/20220.0043.042,400.440.003.170.000.002,446.650.000.0031846V203FIRST AMER:GVT OBLG Y07/31/202134,614.560.160.000.000.000.000.000.160.140.16------03/20/202411,179,614.569,905.335,967.810.00546.06-2,345.350.0014,073.858,861.756,237.67Income Detail Report Trade DateSan Jacinto, City of (66779)07/01/2021 - 07/31/2021Return to Table of ContentsDated: 08/05/202163.A.3.aPacket Pg. 84Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
* Does not Lock Down. * Filtered By: Type = Buy or Type = Sell or Type = Call Redemption or Type = Put Redemption or Type = Corporate Action Sell or Type = Cash Transfer or Type = Maturity or Type = Coupon or Type = Principal Paydown or Type = Money Market Funds. * Weighted by: AbsoluteValue of Principal. * MMF transactions are expanded. * The Transaction Detail/Trading Activity reports provide our most up-to-date transactional details. As such, these reports are subject to change even after the other reports on the website have been locked down. While these reports can be useful tools in understanding recent activity,due to their dynamic nature we do not recommend using them for booking journal entries or reconciliation.IdentifierDescriptionCurrent UnitsTypeSettle DatePricePrincipalRealized Gain/LossAmount31846V203FIRST AMER:GVT OBLG Y0.00Money Market Funds06/30/2021---0.000.000.143137AXHP1FHMS K-024 A20.00Coupon07/01/2021---0.000.00686.133137B4WB8FHMS K-033 A20.00Coupon07/01/2021---0.000.00637.50US3137BWWD24FHMS K-725 A20.00Coupon07/01/2021---0.000.00700.4831846V203FIRST AMER:GVT OBLG Y0.14Buy07/02/20211.0000.140.00-0.1431846V203FIRST AMER:GVT OBLG Y-195,773.35Sell07/06/20211.000-195,773.350.00195,773.3531846V203FIRST AMER:GVT OBLG Y183,063.75Buy07/06/20211.000183,063.750.00-183,063.75912828J76UNITED STATES TREASURY-180,000.00Sell07/06/2021101.238-182,228.912,400.44183,063.75912828XG0UNITED STATES TREASURY-150,000.00Sell07/06/2021101.996-152,994.143,567.37153,046.1191282CBR1UNITED STATES TREASURY350,000.00Buy07/06/202199.586348,550.780.00-348,819.4631846V203FIRST AMER:GVT OBLG Y3,600.00Buy07/13/20211.0003,600.000.00-3,600.00037833DE7APPLE INC0.00Coupon07/13/2021---0.000.003,600.0031846V203FIRST AMER:GVT OBLG Y3,237.50Buy07/15/20211.0003,237.500.00-3,237.509128287C8UNITED STATES TREASURY0.00Coupon07/15/2021---0.000.003,237.50CCYUSDUS DOLLAR0.00Cash Transfer07/26/2021---0.000.00-104.1731846V203FIRST AMER:GVT OBLG Y1,919.94Buy07/26/20211.0001,919.940.00-1,919.9431846V203FIRST AMER:GVT OBLG Y0.00Money Market Funds07/31/2021---0.000.000.16912828V80UNITED STATES TREASURY0.00Coupon07/31/2021---0.000.002,081.25912828Y87UNITED STATES TREASURY0.00Coupon07/31/2021---0.000.003,062.50912828Z52UNITED STATES TREASURY0.00Coupon07/31/2021---0.000.00859.3891282CBH3UNITED STATES TREASURY0.00Coupon07/31/2021---0.000.00234.38------16,047.98---------9,375.715,967.816,237.67Transactions Realized Gain Loss ReportSan Jacinto, City of (66779)07/01/2021 - 07/31/2021Return to Table of ContentsDated: 08/05/202173.A.3.aPacket Pg. 85Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Amazon.com, Inc.Apple Inc.Exxon Mobil CorporationIdentifierSecurity TypeDescription,Issuer ConcentrationEnding Current UnitsCoupon TypeCallableDurationBookYieldYieldEndingEffectiveMaturity,Final MaturityEnding AccruedBalanceEnding Book Value,Book Value + AccruedMarket Value,Ending Market Value +Accrued% of MarketValue023135BW5CORPAMAZON.COM INCAmazon.com, Inc.145,000.00FixedN2.7600.4990.45805/12/202405/12/2024143.19144,803.74144,946.92144,969.16145,112.351.280%023135BW5CORPAMAZON.COM INCAmazon.com, Inc.145,000.00FixedN2.7600.4990.45805/12/202405/12/2024143.19144,803.74144,946.92144,969.16145,112.351.280%IdentifierSecurity TypeDescription,Issuer ConcentrationEnding Current UnitsCoupon TypeCallableDurationBookYieldYieldEndingEffectiveMaturity,Final MaturityEnding AccruedBalanceEnding Book Value,Book Value + AccruedMarket Value,Ending Market Value +Accrued% of MarketValue037833DE7CORPAPPLE INCApple Inc.300,000.00FixedY1.3561.9110.30812/13/202201/13/2023360.00301,968.84302,328.84308,570.85308,930.852.724%037833DE7CORPAPPLE INCApple Inc.300,000.00FixedY1.3561.9110.30812/13/202201/13/2023360.00301,968.84302,328.84308,570.85308,930.852.724%IdentifierSecurity TypeDescription,Issuer ConcentrationEnding Current UnitsCoupon TypeCallableDurationBookYieldYieldEndingEffectiveMaturity,Final MaturityEnding AccruedBalanceEnding Book Value,Book Value + AccruedMarket Value,Ending Market Value +Accrued% of MarketValue30231GBB7CORPEXXON MOBIL CORPExxon Mobil Corporation75,000.00FixedN1.0291.9020.21708/16/202208/16/2022653.8175,000.0075,653.8176,317.5776,971.380.674%Issuer Concentration with Yield GASB 40 Trade DateSan Jacinto, City of (66779)As of 07/31/2021Return to Table of ContentsDated: 08/05/202183.A.3.aPacket Pg. 86Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Farm Credit SystemFederal Home Loan BanksFederal Home Loan Mortgage CorporationIdentifierSecurity TypeDescription,Issuer ConcentrationEnding Current UnitsCoupon TypeCallableDurationBookYieldYieldEndingEffectiveMaturity,Final MaturityEnding AccruedBalanceEnding Book Value,Book Value + AccruedMarket Value,Ending Market Value +Accrued% of MarketValue30231GBB7CORPEXXON MOBIL CORPExxon Mobil Corporation75,000.00FixedN1.0291.9020.21708/16/202208/16/2022653.8175,000.0075,653.8176,317.5776,971.380.674%IdentifierSecurity TypeDescription,Issuer ConcentrationEnding Current UnitsCoupon TypeCallableDurationBookYieldYieldEndingEffectiveMaturity,Final MaturityEnding AccruedBalanceEnding Book Value,Book Value + AccruedMarket Value,Ending Market Value +Accrued% of MarketValue3133ELG81AGCY BONDFEDERAL FARM CREDIT BANKSFUNDING CORPFarm Credit System335,000.00FixedN1.8490.4100.18306/08/202306/08/2023147.96334,323.48334,471.44335,724.02335,871.972.964%3133EMGX4AGCY BONDFEDERAL FARM CREDIT BANKSFUNDING CORPFarm Credit System220,000.00FixedN1.3120.2210.12211/23/202211/23/202251.94219,724.62219,776.56220,007.76220,059.701.942%3133EMRZ7AGCY BONDFEDERAL FARM CREDIT BANKSFUNDING CORPFarm Credit System220,000.00FixedN2.5590.2620.28202/26/202402/26/2024236.81219,932.14220,168.95219,819.91220,056.711.941%---AGCY BONDFEDERAL FARM CREDIT BANKSFUNDING CORPFarm Credit System775,000.00FixedN1.8980.3140.19406/27/202306/27/2023436.71773,980.24774,416.95775,551.68775,988.396.847%IdentifierSecurity TypeDescription,Issuer ConcentrationEnding Current UnitsCoupon TypeCallableDurationBookYieldYieldEndingEffectiveMaturity,Final MaturityEnding AccruedBalanceEnding Book Value,Book Value + AccruedMarket Value,Ending Market Value +Accrued% of MarketValue3130AJ7E3AGCY BONDFEDERAL HOME LOAN BANKSFederal Home Loan Banks300,000.00FixedN1.5261.4380.10702/17/202302/17/20231,879.17299,711.80301,590.97305,877.57307,756.732.701%3130AJHU6AGCY BONDFEDERAL HOME LOAN BANKSFederal Home Loan Banks225,000.00FixedN3.6620.6010.48904/14/202504/14/2025334.38224,169.59224,503.96225,090.85225,425.221.987%---AGCY BONDFEDERAL HOME LOAN BANKSFederal Home Loan Banks525,000.00FixedN2.4291.0810.26901/16/202401/16/20242,213.54523,881.39526,094.93530,968.42533,181.964.688%IdentifierSecurity TypeDescription,Issuer ConcentrationEnding Current UnitsCoupon TypeCallableDurationBookYieldYieldEndingEffectiveMaturity,Final MaturityEnding AccruedBalanceEnding Book Value,Book Value + AccruedMarket Value,Ending Market Value +Accrued% of MarketValue3137AXHP1FHLMC CMOFHMS K-024 A2Federal Home Loan Mortgage Corporation320,000.00FixedY1.0322.5630.30408/16/202209/25/2022686.13319,529.32320,215.46327,032.77327,718.902.887%3137B4WB8FHLMCFHMS K-033 A2Federal Home Loan Mortgage Corporation250,000.00VariableY1.8061.9900.42006/08/202307/25/2023637.50254,399.70255,037.20261,710.17262,347.672.311%US3137BWWD24FHLMCFHMS K-725 A2Federal Home Loan Mortgage Corporation280,000.00VariableY2.3072.1210.48612/20/202301/25/2024700.47285,237.68285,938.14296,185.32296,885.782.615%3137EAEP0AGCY BONDFEDERAL HOME LOAN MORTGAGECORPFederal Home Loan Mortgage Corporation300,000.00FixedN3.4251.5160.47502/12/202502/12/20252,112.50299,834.86301,947.36310,765.94312,878.442.744%3137EAEQ8AGCY BONDFEDERAL HOME LOAN MORTGAGECORPFederal Home Loan Mortgage Corporation335,000.00FixedN1.7150.4590.14904/20/202304/20/2023352.45334,518.86334,871.31336,304.43336,656.872.969%3137EAER6AGCY BONDFEDERAL HOME LOAN MORTGAGECORPFederal Home Loan Mortgage Corporation335,000.00FixedN1.7570.3890.17405/05/202305/05/2023300.10334,917.36335,217.46336,184.37336,484.482.968%3137EAEV7AGCY BONDFEDERAL HOME LOAN MORTGAGECORPFederal Home Loan Mortgage Corporation235,000.00FixedN2.0580.2840.20508/24/202308/24/2023256.22234,835.37235,091.58235,218.24235,474.462.077%Issuer Concentration with Yield GASB 40 Trade DateSan Jacinto, City of (66779)As of 07/31/2021Return to Table of ContentsDated: 08/05/202193.A.3.aPacket Pg. 87Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Federal National Mortgage AssociationMicrosoft CorporationPepsiCo, Inc.U.S. BancorpUnited StatesIdentifierSecurity TypeDescription,Issuer ConcentrationEnding Current UnitsCoupon TypeCallableDurationBookYieldYieldEndingEffectiveMaturity,Final MaturityEnding AccruedBalanceEnding Book Value,Book Value + AccruedMarket Value,Ending Market Value +Accrued% of MarketValue---------Federal Home Loan Mortgage Corporation2,055,000.00------2.0021.3260.31308/15/202309/01/20235,045.372,063,273.142,068,318.502,103,401.242,108,446.6018.570%IdentifierSecurity TypeDescription,Issuer ConcentrationEnding Current UnitsCoupon TypeCallableDurationBookYieldYieldEndingEffectiveMaturity,Final MaturityEnding AccruedBalanceEnding Book Value,Book Value + AccruedMarket Value,Ending Market Value +Accrued% of MarketValue3135G05X7AGCY BONDFEDERAL NATIONAL MORTGAGEASSOCIATIONFederal National Mortgage Association415,000.00FixedN4.0240.4700.59608/25/202508/25/2025674.38413,415.31414,089.69411,317.92411,992.303.631%3135G06H1AGCY BONDFEDERAL NATIONAL MORTGAGEASSOCIATIONFederal National Mortgage Association320,000.00FixedN2.3160.2880.24011/27/202311/27/2023142.22319,718.07319,860.29320,075.52320,217.742.826%---AGCY BONDFEDERAL NATIONAL MORTGAGEASSOCIATIONFederal National Mortgage Association735,000.00FixedN3.2770.3910.44011/19/202411/19/2024816.60733,133.38733,949.97731,393.44732,210.046.457%IdentifierSecurity TypeDescription,Issuer ConcentrationEnding Current UnitsCoupon TypeCallableDurationBookYieldYieldEndingEffectiveMaturity,Final MaturityEnding AccruedBalanceEnding Book Value,Book Value + AccruedMarket Value,Ending Market Value +Accrued% of MarketValue594918AT1CORPMICROSOFT CORPMicrosoft Corporation235,000.00FixedY1.4850.5830.42902/01/202305/01/20231,395.31241,280.45242,675.76241,842.41243,237.722.135%594918AT1CORPMICROSOFT CORPMicrosoft Corporation235,000.00FixedY1.4850.5830.42902/01/202305/01/20231,395.31241,280.45242,675.76241,842.41243,237.722.135%IdentifierSecurity TypeDescription,Issuer ConcentrationEnding Current UnitsCoupon TypeCallableDurationBookYieldYieldEndingEffectiveMaturity,Final MaturityEnding AccruedBalanceEnding Book Value,Book Value + AccruedMarket Value,Ending Market Value +Accrued% of MarketValue713448FB9CORPPEPSICO INCPepsiCo, Inc.85,000.00FixedN2.1730.4190.30210/07/202310/07/2023107.6784,964.6985,072.3585,180.4385,288.100.752%713448FB9CORPPEPSICO INCPepsiCo, Inc.85,000.00FixedN2.1730.4190.30210/07/202310/07/2023107.6784,964.6985,072.3585,180.4385,288.100.752%IdentifierSecurity TypeDescription,Issuer ConcentrationEnding Current UnitsCoupon TypeCallableDurationBookYieldYieldEndingEffectiveMaturity,Final MaturityEnding AccruedBalanceEnding Book Value,Book Value + AccruedMarket Value,Ending Market Value +Accrued% of MarketValue31846V203MMFUNDFIRST AMER:GVT OBLG YU.S. Bancorp34,614.56FixedN0.0000.0100.01007/31/202107/31/20210.0034,614.5634,614.5634,614.5634,614.560.306%31846V203MMFUNDFIRST AMER:GVT OBLG YU.S. Bancorp34,614.56FixedN0.0000.0100.01007/31/202107/31/20210.0034,614.5634,614.5634,614.5634,614.560.306%Issuer Concentration with Yield GASB 40 Trade DateSan Jacinto, City of (66779)As of 07/31/2021Return to Table of ContentsDated: 08/05/2021103.A.3.aPacket Pg. 88Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Walmart Inc.IdentifierSecurity TypeDescription,Issuer ConcentrationEnding Current UnitsCoupon TypeCallableDurationBookYieldYieldEndingEffectiveMaturity,Final MaturityEnding AccruedBalanceEnding Book Value,Book Value + AccruedMarket Value,Ending Market Value +Accrued% of MarketValue912828L57US GOVUNITED STATES TREASURYUnited States175,000.00FixedN1.1561.7700.11209/30/202209/30/20221,029.20174,960.85175,990.05178,349.67179,378.881.575%912828Y87US GOVUNITED STATES TREASURYUnited States350,000.00FixedN2.9101.6750.34807/31/202407/31/202416.64350,762.42350,779.06364,642.60364,659.243.219%912828YE4US GOVUNITED STATES TREASURYUnited States300,000.00FixedN3.0181.6730.37508/31/202408/31/20241,569.29296,203.74297,773.03308,050.80309,620.092.720%9128286Z8US GOVUNITED STATES TREASURYUnited States95,000.00FixedN2.8511.6770.34006/30/202406/30/2024144.5795,197.3895,341.9598,885.3199,029.880.873%912828V80US GOVUNITED STATES TREASURYUnited States185,000.00FixedN2.4201.7260.26801/31/202401/31/202411.31187,358.03187,369.34194,141.59194,152.901.714%912828YE4US GOVUNITED STATES TREASURYUnited States370,000.00FixedN3.0180.8800.37508/31/202408/31/20241,935.46374,152.54376,088.01379,929.32381,864.783.354%912828YY0US GOVUNITED STATES TREASURYUnited States160,000.00FixedN3.3240.8880.43412/31/202412/31/2024243.48164,627.61164,871.09167,137.44167,380.921.476%912828T91US GOVUNITED STATES TREASURYUnited States110,000.00FixedN2.2110.3280.23010/31/202310/31/2023451.73113,192.11113,643.84113,446.08113,897.811.002%912828T26US GOVUNITED STATES TREASURYUnited States255,000.00FixedN2.1340.3210.21909/30/202309/30/20231,178.33260,788.96261,967.29261,375.00262,553.332.308%912828ZC7US GOVUNITED STATES TREASURYUnited States220,000.00FixedN3.5020.4490.47502/28/202502/28/20251,035.73225,276.35226,312.08225,078.92226,114.651.987%91282CAN1US GOVUNITED STATES TREASURYUnited States275,000.00FixedN1.1680.1410.10509/30/202209/30/2022115.52274,948.98275,064.50275,064.35275,179.872.428%912828Z52US GOVUNITED STATES TREASURYUnited States125,000.00FixedN3.4030.2570.45801/31/202501/31/20254.67129,862.31129,866.98128,979.50128,984.171.139%912828ZW3US GOVUNITED STATES TREASURYUnited States255,000.00FixedN3.8900.3440.53906/30/202506/30/202555.43254,069.43254,124.86252,151.14252,206.572.226%912828ZT0US GOVUNITED STATES TREASURYUnited States235,000.00FixedN3.8090.3480.52305/31/202505/31/202599.52234,121.70234,221.22232,567.28232,666.802.053%912828ZT0US GOVUNITED STATES TREASURYUnited States190,000.00FixedN3.8090.3590.52305/31/202505/31/202580.46189,209.68189,290.14188,033.12188,113.581.660%91282CAT8US GOVUNITED STATES TREASURYUnited States190,000.00FixedN4.2170.4080.59810/31/202510/31/2025120.04188,733.64188,853.68187,224.29187,344.331.653%91282CAZ4US GOVUNITED STATES TREASURYUnited States205,000.00FixedN4.2890.4390.60411/30/202511/30/2025130.23204,437.84204,568.07202,997.97203,128.201.792%912828ZL7US GOVUNITED STATES TREASURYUnited States155,000.00FixedN3.7170.4590.50404/30/202504/30/2025146.89154,515.84154,662.73154,255.23154,402.121.362%91282CBC4US GOVUNITED STATES TREASURYUnited States155,000.00FixedN4.3710.5920.62512/31/202512/31/202550.54153,536.09153,586.63153,316.86153,367.401.354%91282CBH3US GOVUNITED STATES TREASURYUnited States125,000.00FixedN4.4460.8420.63501/31/202601/31/20261.27122,426.90122,428.17123,559.63123,560.901.091%91282CBU4US GOVUNITED STATES TREASURYUnited States400,000.00FixedN1.6660.1410.15303/31/202303/31/2023168.03399,895.98400,064.01399,812.40399,980.433.530%91282CBT7US GOVUNITED STATES TREASURYUnited States300,000.00FixedN4.5710.7800.65603/31/202603/31/2026756.15299,586.36300,342.51301,289.10302,045.252.660%91282CCC3US GOVUNITED STATES TREASURYUnited States220,000.00FixedN2.7800.3260.31705/15/202405/15/2024116.58219,534.99219,651.56219,587.50219,704.081.939%91282CCF6US GOVUNITED STATES TREASURYUnited States220,000.00FixedN4.7370.8410.68105/31/202605/31/2026279.51219,057.68219,337.18220,721.82221,001.331.949%91282CBR1US GOVUNITED STATES TREASURYUnited States350,000.00FixedN2.6150.4050.28103/15/202403/15/2024330.50348,588.65348,919.15349,713.00350,043.503.088%9128287C8US GOVUNITED STATES TREASURYUnited States370,000.00FixedN0.9541.6550.09607/15/202207/15/2022299.12370,331.47370,630.59375,867.83376,166.953.318%---US GOVUNITED STATES TREASURYUnited States5,990,000.00FixedN2.9750.7690.37908/07/202408/07/202410,370.226,005,377.526,015,747.756,056,177.746,066,547.9653.469%Issuer Concentration with Yield GASB 40 Trade DateSan Jacinto, City of (66779)As of 07/31/2021Return to Table of ContentsDated: 08/05/2021113.A.3.aPacket Pg. 89Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Summary * Grouped by: Issuer Concentration. * Groups Sorted by: Issuer Concentration. * Filtered By: Description ¹ "Payable" and Description ¹ "Receivable". * Weighted by: Ending Market Value + Accrued, except Book Yield by Base Book Value + Accrued.IdentifierSecurity TypeDescription,Issuer ConcentrationEnding Current UnitsCoupon TypeCallableDurationBookYieldYieldEndingEffectiveMaturity,Final MaturityEnding AccruedBalanceEnding Book Value,Book Value + AccruedMarket Value,Ending Market Value +Accrued% of MarketValue931142EK5CORPWALMART INCWalmart Inc.225,000.00FixedY1.7750.6650.31205/26/202306/26/2023743.75236,103.79236,847.54237,614.77238,358.522.098%931142EK5CORPWALMART INCWalmart Inc.225,000.00FixedY1.7750.6650.31205/26/202306/26/2023743.75236,103.79236,847.54237,614.77238,358.522.098%IdentifierSecurity TypeDescription,Issuer ConcentrationEnding Current UnitsCoupon TypeCallableDurationBookYieldYieldEndingEffectiveMaturity,Final MaturityEnding AccruedBalanceEnding Book Value,Book Value + AccruedMarket Value,Ending Market Value +Accrued% of MarketValue------------11,179,614.56------2.5820.8540.34903/13/202403/20/202422,286.1711,218,381.7311,240,667.9011,326,602.2611,348,888.43100.000%Issuer Concentration with Yield GASB 40 Trade DateSan Jacinto, City of (66779)As of 07/31/2021Return to Table of ContentsDated: 08/05/2021123.A.3.aPacket Pg. 90Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
AGCY BONDIdentifier,Description,Security Type% of MarketValue +AccruedCoupon TypeCallableDurationS&PRating,Moody'sRatingEnding Current UnitsEndingEffectiveMaturity,Final MaturityBookYield,YieldEnding AccruedBalanceOriginal CostEnding Book Value,Book Value + AccruedMarket Value,Ending Market Value +Accrued3133EMGX4FEDERAL FARM CREDIT BANKS FUNDINGCORPAGCY BOND1.939%FixedN1.312AA+Aaa220,000.0011/23/202211/23/20220.2210.12251.94219,579.80219,724.62219,776.56220,007.76220,059.703130AJ7E3FEDERAL HOME LOAN BANKSAGCY BOND2.712%FixedN1.526AA+Aaa300,000.0002/17/202302/17/20231.4380.1071,879.17299,448.00299,711.80301,590.97305,877.57307,756.733137EAEQ8FEDERAL HOME LOAN MORTGAGE CORPAGCY BOND2.966%FixedN1.715AA+Aaa335,000.0004/20/202304/20/20230.4590.149352.45334,162.50334,518.86334,871.31336,304.43336,656.873137EAER6FEDERAL HOME LOAN MORTGAGE CORPAGCY BOND2.965%FixedN1.757AA+Aaa335,000.0005/05/202305/05/20230.3890.174300.10334,859.30334,917.36335,217.46336,184.37336,484.483133ELG81FEDERAL FARM CREDIT BANKS FUNDINGCORPAGCY BOND2.960%FixedN1.849AA+Aaa335,000.0006/08/202306/08/20230.4100.183147.96333,907.90334,323.48334,471.44335,724.02335,871.973137EAEV7FEDERAL HOME LOAN MORTGAGE CORPAGCY BOND2.075%FixedN2.058AA+Aaa235,000.0008/24/202308/24/20230.2840.205256.22234,760.30234,835.37235,091.58235,218.24235,474.463135G06H1FEDERAL NATIONAL MORTGAGEASSOCIATIONAGCY BOND2.822%FixedN2.316AA+Aaa320,000.0011/27/202311/27/20230.2880.240142.22319,635.20319,718.07319,860.29320,075.52320,217.74Security Type GASB 40 Trade DateSan Jacinto, City of (66779)As of 07/31/2021Return to Table of ContentsDated: 08/05/2021133.A.3.aPacket Pg. 91Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
CORPFHLMCIdentifier,Description,Security Type% of MarketValue +AccruedCoupon TypeCallableDurationS&PRating,Moody'sRatingEnding Current UnitsEndingEffectiveMaturity,Final MaturityBookYield,YieldEnding AccruedBalanceOriginal CostEnding Book Value,Book Value + AccruedMarket Value,Ending Market Value +Accrued3133EMRZ7FEDERAL FARM CREDIT BANKS FUNDINGCORPAGCY BOND1.939%FixedN2.559AA+Aaa220,000.0002/26/202402/26/20240.2620.282236.81219,920.80219,932.14220,168.95219,819.91220,056.713137EAEP0FEDERAL HOME LOAN MORTGAGE CORPAGCY BOND2.757%FixedN3.425AA+Aaa300,000.0002/12/202502/12/20251.5160.4752,112.50299,769.00299,834.86301,947.36310,765.94312,878.443130AJHU6FEDERAL HOME LOAN BANKSAGCY BOND1.986%FixedN3.662AA+Aaa225,000.0004/14/202504/14/20250.6010.489334.38223,884.00224,169.59224,503.96225,090.85225,425.223135G05X7FEDERAL NATIONAL MORTGAGEASSOCIATIONAGCY BOND3.630%FixedN4.024AA+Aaa415,000.0008/25/202508/25/20250.4700.596674.38413,057.80413,415.31414,089.69411,317.92411,992.30------AGCY BOND28.751%FixedN2.419AA+Aaa3,240,000.0001/10/202401/10/20240.5880.2826,488.113,232,984.603,235,101.443,241,589.563,256,386.513,262,874.63Identifier,Description,Security Type% of MarketValue +AccruedCoupon TypeCallableDurationS&PRating,Moody'sRatingEnding Current UnitsEndingEffectiveMaturity,Final MaturityBookYield,YieldEnding AccruedBalanceOriginal CostEnding Book Value,Book Value + AccruedMarket Value,Ending Market Value +Accrued30231GBB7EXXON MOBIL CORPCORP0.678%FixedN1.029AA-Aa275,000.0008/16/202208/16/20221.9020.217653.8175,000.0075,000.0075,653.8176,317.5776,971.38037833DE7APPLE INCCORP2.722%FixedY1.356AA+Aa1300,000.0012/13/202201/13/20231.9110.308360.00304,260.00301,968.84302,328.84308,570.85308,930.85594918AT1MICROSOFT CORPCORP2.143%FixedY1.485AAAAaa235,000.0002/01/202305/01/20230.5830.4291,395.31246,484.45241,280.45242,675.76241,842.41243,237.72931142EK5WALMART INCCORP2.100%FixedY1.775AAAa2225,000.0005/26/202306/26/20230.6650.312743.75243,666.00236,103.79236,847.54237,614.77238,358.52713448FB9PEPSICO INCCORP0.752%FixedN2.173A+A185,000.0010/07/202310/07/20230.4190.302107.6784,951.5584,964.6985,072.3585,180.4385,288.10023135BW5AMAZON.COM INCCORP1.279%FixedN2.760AAA1145,000.0005/12/202405/12/20240.4990.458143.19144,788.30144,803.74144,946.92144,969.16145,112.35------CORP9.674%Fixed---1.702AAAa21,065,000.0004/22/202305/27/20231.0380.3493,403.731,099,150.301,084,121.511,087,525.241,094,495.191,097,898.92Identifier,Description,Security Type% of MarketValue +AccruedCoupon TypeCallableDurationS&PRating,Moody'sRatingEnding Current UnitsEndingEffectiveMaturity,Final MaturityBookYield,YieldEnding AccruedBalanceOriginal CostEnding Book Value,Book Value + AccruedMarket Value,Ending Market Value +Accrued3137B4WB8FHMS K-033 A2FHLMC2.312%VariableY1.806AA+Aaa250,000.0006/08/202307/25/20231.9900.420637.50258,544.92254,399.70255,037.20261,710.17262,347.67US3137BWWD24FHMS K-725 A2FHLMC2.616%VariableY2.307AAAAaa280,000.0012/20/202301/25/20242.1210.486700.47289,012.50285,237.68285,938.14296,185.32296,885.78------FHLMC4.928%VariableY2.072AAAAaa530,000.0009/20/202310/31/20232.0590.4551,337.97547,557.42539,637.37540,975.34557,895.49559,233.46Security Type GASB 40 Trade DateSan Jacinto, City of (66779)As of 07/31/2021Return to Table of ContentsDated: 08/05/2021143.A.3.aPacket Pg. 92Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
FHLMC CMOMMFUNDUS GOVIdentifier,Description,Security Type% of MarketValue +AccruedCoupon TypeCallableDurationS&PRating,Moody'sRatingEnding Current UnitsEndingEffectiveMaturity,Final MaturityBookYield,YieldEnding AccruedBalanceOriginal CostEnding Book Value,Book Value + AccruedMarket Value,Ending Market Value +Accrued3137AXHP1FHMS K-024 A2FHLMC CMO2.888%FixedY1.032AA+Aaa320,000.0008/16/202209/25/20222.5630.304686.13319,687.50319,529.32320,215.46327,032.77327,718.903137AXHP1FHMS K-024 A2FHLMC CMO2.888%FixedY1.032AA+Aaa320,000.0008/16/202209/25/20222.5630.304686.13319,687.50319,529.32320,215.46327,032.77327,718.90Identifier,Description,Security Type% of MarketValue +AccruedCoupon TypeCallableDurationS&PRating,Moody'sRatingEnding Current UnitsEndingEffectiveMaturity,Final MaturityBookYield,YieldEnding AccruedBalanceOriginal CostEnding Book Value,Book Value + AccruedMarket Value,Ending Market Value +Accrued31846V203FIRST AMER:GVT OBLG YMMFUND0.305%FixedN0.000AAAmAaa34,614.5607/31/202107/31/20210.0100.0100.0034,614.5634,614.5634,614.5634,614.5634,614.5631846V203FIRST AMER:GVT OBLG YMMFUND0.305%FixedN0.000AAAmAaa34,614.5607/31/202107/31/20210.0100.0100.0034,614.5634,614.5634,614.5634,614.5634,614.56Identifier,Description,Security Type% of MarketValue +AccruedCoupon TypeCallableDurationS&PRating,Moody'sRatingEnding Current UnitsEndingEffectiveMaturity,Final MaturityBookYield,YieldEnding AccruedBalanceOriginal CostEnding Book Value,Book Value + AccruedMarket Value,Ending Market Value +Accrued9128287C8UNITED STATES TREASURYUS GOV3.315%FixedN0.954AA+Aaa370,000.0007/15/202207/15/20221.6550.096299.12370,925.00370,331.47370,630.59375,867.83376,166.95912828L57UNITED STATES TREASURYUS GOV1.581%FixedN1.156AA+Aaa175,000.0009/30/202209/30/20221.7700.1121,029.20174,890.63174,960.85175,990.05178,349.67179,378.8891282CAN1UNITED STATES TREASURYUS GOV2.425%FixedN1.168AA+Aaa275,000.0009/30/202209/30/20220.1410.105115.52274,914.06274,948.98275,064.50275,064.35275,179.8791282CBU4UNITED STATES TREASURYUS GOV3.524%FixedN1.666AA+Aaa400,000.0003/31/202303/31/20230.1410.153168.03399,875.00399,895.98400,064.01399,812.40399,980.43912828T26UNITED STATES TREASURYUS GOV2.313%FixedN2.134AA+Aaa255,000.0009/30/202309/30/20230.3210.2191,178.33263,835.35260,788.96261,967.29261,375.00262,553.33912828T91UNITED STATES TREASURYUS GOV1.004%FixedN2.211AA+Aaa110,000.0010/31/202310/31/20230.3280.230451.73114,808.20113,192.11113,643.84113,446.08113,897.81912828V80UNITED STATES TREASURYUS GOV1.711%FixedN2.420AA+Aaa185,000.0001/31/202401/31/20241.7260.26811.31188,837.30187,358.03187,369.34194,141.59194,152.9091282CBR1UNITED STATES TREASURYUS GOV3.084%FixedN2.615AA+Aaa350,000.0003/15/202403/15/20240.4050.281330.50348,550.78348,588.65348,919.15349,713.00350,043.5091282CCC3UNITED STATES TREASURYUS GOV1.936%FixedN2.780AA+Aaa220,000.0005/15/202405/15/20240.3260.317116.58219,510.16219,534.99219,651.56219,587.50219,704.089128286Z8UNITED STATES TREASURYUS GOV0.873%FixedN2.851AA+Aaa95,000.0006/30/202406/30/20241.6770.340144.5795,304.3095,197.3895,341.9598,885.3199,029.88912828Y87UNITED STATES TREASURYUS GOV3.213%FixedN2.910AA+Aaa350,000.0007/31/202407/31/20241.6750.34816.64351,162.11350,762.42350,779.06364,642.60364,659.24Security Type GASB 40 Trade DateSan Jacinto, City of (66779)As of 07/31/2021Return to Table of ContentsDated: 08/05/2021153.A.3.aPacket Pg. 93Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
SummaryIdentifier,Description,Security Type% of MarketValue +AccruedCoupon TypeCallableDurationS&PRating,Moody'sRatingEnding Current UnitsEndingEffectiveMaturity,Final MaturityBookYield,YieldEnding AccruedBalanceOriginal CostEnding Book Value,Book Value + AccruedMarket Value,Ending Market Value +Accrued912828YE4UNITED STATES TREASURYUS GOV2.728%FixedN3.018AA+Aaa300,000.0008/31/202408/31/20241.6730.3751,569.29294,257.81296,203.74297,773.03308,050.80309,620.09912828YE4UNITED STATES TREASURYUS GOV3.365%FixedN3.018AA+Aaa370,000.0008/31/202408/31/20240.8800.3751,935.46376,012.50374,152.54376,088.01379,929.32381,864.78912828YY0UNITED STATES TREASURYUS GOV1.475%FixedN3.324AA+Aaa160,000.0012/31/202412/31/20240.8880.434243.48166,500.00164,627.61164,871.09167,137.44167,380.92912828Z52UNITED STATES TREASURYUS GOV1.137%FixedN3.403AA+Aaa125,000.0001/31/202501/31/20250.2570.4584.67130,966.80129,862.31129,866.98128,979.50128,984.17912828ZC7UNITED STATES TREASURYUS GOV1.992%FixedN3.502AA+Aaa220,000.0002/28/202502/28/20250.4490.4751,035.73226,943.75225,276.35226,312.08225,078.92226,114.65912828ZL7UNITED STATES TREASURYUS GOV1.361%FixedN3.717AA+Aaa155,000.0004/30/202504/30/20250.4590.504146.89154,461.13154,515.84154,662.73154,255.23154,402.12912828ZT0UNITED STATES TREASURYUS GOV2.050%FixedN3.809AA+Aaa235,000.0005/31/202505/31/20250.3480.52399.52233,971.88234,121.70234,221.22232,567.28232,666.80912828ZT0UNITED STATES TREASURYUS GOV1.658%FixedN3.809AA+Aaa190,000.0005/31/202505/31/20250.3590.52380.46189,094.53189,209.68189,290.14188,033.12188,113.58912828ZW3UNITED STATES TREASURYUS GOV2.222%FixedN3.890AA+Aaa255,000.0006/30/202506/30/20250.3440.53955.43253,894.34254,069.43254,124.86252,151.14252,206.5791282CAT8UNITED STATES TREASURYUS GOV1.651%FixedN4.217AA+Aaa190,000.0010/31/202510/31/20250.4080.598120.04188,567.58188,733.64188,853.68187,224.29187,344.3391282CAZ4UNITED STATES TREASURYUS GOV1.790%FixedN4.289AA+Aaa205,000.0011/30/202511/30/20250.4390.604130.23204,375.39204,437.84204,568.07202,997.97203,128.2091282CBC4UNITED STATES TREASURYUS GOV1.351%FixedN4.371AA+Aaa155,000.0012/31/202512/31/20250.5920.62550.54153,395.51153,536.09153,586.63153,316.86153,367.4091282CBH3UNITED STATES TREASURYUS GOV1.089%FixedN4.446AA+Aaa125,000.0001/31/202601/31/20260.8420.6351.27122,236.33122,426.90122,428.17123,559.63123,560.9091282CBT7UNITED STATES TREASURYUS GOV2.661%FixedN4.571AA+Aaa300,000.0003/31/202603/31/20260.7800.656756.15299,566.41299,586.36300,342.51301,289.10302,045.2591282CCF6UNITED STATES TREASURYUS GOV1.947%FixedN4.737AA+Aaa220,000.0005/31/202605/31/20260.8410.681279.51219,028.91219,057.68219,337.18220,721.82221,001.33---UNITED STATES TREASURYUS GOV53.455%FixedN2.975AA+Aaa5,990,000.0008/07/202408/07/20240.7690.37910,370.226,015,885.766,005,377.526,015,747.756,056,177.746,066,547.96Identifier,Description,Security Type% of MarketValue +AccruedCoupon TypeCallableDurationS&PRating,Moody'sRatingEnding Current UnitsEndingEffectiveMaturity,Final MaturityBookYield,YieldEnding AccruedBalanceOriginal CostEnding Book Value,Book Value + AccruedMarket Value,Ending Market Value +Accrued---------100.000%------2.582AA+Aaa11,179,614.5603/13/202403/20/20240.8540.34922,286.1711,249,880.1411,218,381.7311,240,667.9011,326,602.2611,348,888.43Security Type GASB 40 Trade DateSan Jacinto, City of (66779)As of 07/31/2021Return to Table of ContentsDated: 08/05/2021163.A.3.aPacket Pg. 94Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
* Grouped by: Security Type. * Groups Sorted by: Security Type. * Filtered By: Description ¹ "Payable" and Description ¹ "Receivable". * Weighted by: Ending Market Value + Accrued, except Book Yield by Base Book Value + Accrued.Security Type GASB 40 Trade DateSan Jacinto, City of (66779)As of 07/31/2021Return to Table of ContentsDated: 08/05/2021173.A.3.aPacket Pg. 95Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Identifier,Description,Security TypeInterest/DividendReceivedTransfers In/OutPurchasesPurchasedAccruedIncomeSalesDisposed AccruedMaturities andRedemptionsPaydownsNet RealizedGain/LossBeginning OriginalCost,Ending Original CostBeginning MarketValue,Ending Market Value31846V203FIRST AMER:GVT OBLG YMMFUND0.140.00191,821.330.00-195,773.350.000.000.000.0038,566.5834,614.5638,566.5834,614.56CCYUSDReceivableCASH0.000.000.000.000.000.000.000.000.000.146,237.670.146,237.67CCYUSDCashCASH0.00-104.170.000.000.000.000.000.000.000.000.000.000.003137AXHP1FHMS K-024 A2FHLMC CMO686.130.000.000.000.000.000.000.000.00319,687.50319,687.50327,007.33327,032.77912828L57UNITED STATES TREASURYUS GOV0.000.000.000.000.000.000.000.000.00174,890.63174,890.63178,520.48178,349.6730231GBB7EXXON MOBIL CORPCORP0.000.000.000.000.000.000.000.000.0075,000.0075,000.0076,387.1076,317.579128287C8UNITED STATES TREASURYUS GOV3,237.500.000.000.000.000.000.000.000.00370,925.00370,925.00376,301.47375,867.83912828Y87UNITED STATES TREASURYUS GOV0.000.000.000.000.000.000.000.000.00351,162.11351,162.11363,753.95364,642.60912828YE4UNITED STATES TREASURYUS GOV0.000.000.000.000.000.000.000.000.00294,257.81294,257.81307,101.60308,050.809128286Z8UNITED STATES TREASURYUS GOV0.000.000.000.000.000.000.000.000.0095,304.3095,304.3098,666.4398,885.31037833DE7APPLE INCCORP3,600.000.000.000.000.000.000.000.000.00304,260.00304,260.00309,688.35308,570.853137B4WB8FHMS K-033 A2FHLMC637.500.000.000.000.000.000.000.000.00258,544.92258,544.92262,171.20261,710.17US3137BWWD24FHMS K-725 A2FHLMC700.480.000.000.000.000.000.000.000.00289,012.50289,012.50296,095.83296,185.32912828V80UNITED STATES TREASURYUS GOV0.000.000.000.000.000.000.000.000.00188,837.30188,837.30193,968.24194,141.593137EAEP0FEDERAL HOME LOAN MORTGAGECORPAGCY BOND0.000.000.000.000.000.000.000.000.00299,769.00299,769.00309,623.47310,765.943130AJ7E3FEDERAL HOME LOAN BANKSAGCY BOND0.000.000.000.000.000.000.000.000.00299,448.00299,448.00305,742.28305,877.57912828YE4UNITED STATES TREASURYUS GOV0.000.000.000.000.000.000.000.000.00376,012.50376,012.50378,758.64379,929.32912828YY0UNITED STATES TREASURYUS GOV0.000.000.000.000.000.000.000.000.00166,500.00166,500.00166,524.96167,137.443130AJHU6FEDERAL HOME LOAN BANKSAGCY BOND0.000.000.000.000.000.000.000.000.00223,884.00223,884.00223,750.79225,090.853137EAEQ8FEDERAL HOME LOAN MORTGAGECORPAGCY BOND0.000.000.000.000.000.000.000.000.00334,162.50334,162.50335,749.26336,304.43594918AT1MICROSOFT CORPCORP0.000.000.000.000.000.000.000.000.00246,484.45246,484.45242,884.97241,842.41Portfolio Activity SummarySan Jacinto, City of (66779)07/01/2021 - 07/31/2021Return to Table of ContentsDated: 08/05/2021183.A.3.aPacket Pg. 96Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Identifier,Description,Security TypeInterest/DividendReceivedTransfers In/OutPurchasesPurchasedAccruedIncomeSalesDisposed AccruedMaturities andRedemptionsPaydownsNet RealizedGain/LossBeginning OriginalCost,Ending Original CostBeginning MarketValue,Ending Market Value931142EK5WALMART INCCORP0.000.000.000.000.000.000.000.000.00243,666.00243,666.00238,445.00237,614.773137EAER6FEDERAL HOME LOAN MORTGAGECORPAGCY BOND0.000.000.000.000.000.000.000.000.00334,859.30334,859.30335,847.30336,184.37912828T91UNITED STATES TREASURYUS GOV0.000.000.000.000.000.000.000.000.00114,808.20114,808.20113,338.72113,446.083133ELG81FEDERAL FARM CREDIT BANKSFUNDING CORPAGCY BOND0.000.000.000.000.000.000.000.000.00333,907.90333,907.90335,226.45335,724.02912828T26UNITED STATES TREASURYUS GOV0.000.000.000.000.000.000.000.000.00263,835.35263,835.35261,146.01261,375.00912828ZC7UNITED STATES TREASURYUS GOV0.000.000.000.000.000.000.000.000.00226,943.75226,943.75224,073.52225,078.923137EAEV7FEDERAL HOME LOAN MORTGAGECORPAGCY BOND0.000.000.000.000.000.000.000.000.00234,760.30234,760.30234,944.31235,218.243135G05X7FEDERAL NATIONAL MORTGAGEASSOCIATIONAGCY BOND0.000.000.000.000.000.000.000.000.00413,057.80413,057.80409,013.85411,317.92713448FB9PEPSICO INCCORP0.000.000.000.000.000.000.000.000.0084,951.5584,951.5585,071.6185,180.4391282CAN1UNITED STATES TREASURYUS GOV0.000.000.000.000.000.000.000.000.00274,914.06274,914.06274,946.38275,064.35912828Z52UNITED STATES TREASURYUS GOV0.000.000.000.000.000.000.000.000.00130,966.80130,966.80128,452.13128,979.50912828ZW3UNITED STATES TREASURYUS GOV0.000.000.000.000.000.000.000.000.00253,894.34253,894.34250,557.39252,151.143133EMGX4FEDERAL FARM CREDIT BANKSFUNDING CORPAGCY BOND0.000.000.000.000.000.000.000.000.00219,579.80219,579.80219,802.85220,007.763135G06H1FEDERAL NATIONAL MORTGAGEASSOCIATIONAGCY BOND0.000.000.000.000.000.000.000.000.00319,635.20319,635.20319,397.94320,075.52912828ZT0UNITED STATES TREASURYUS GOV0.000.000.000.000.000.000.000.000.00233,971.88233,971.88231,126.26232,567.28912828ZT0UNITED STATES TREASURYUS GOV0.000.000.000.000.000.000.000.000.00189,094.53189,094.53186,868.04188,033.1291282CAT8UNITED STATES TREASURYUS GOV0.000.000.000.000.000.000.000.000.00188,567.58188,567.58185,836.34187,224.2991282CAZ4UNITED STATES TREASURYUS GOV0.000.000.000.000.000.000.000.000.00204,375.39204,375.39201,388.52202,997.973133EMRZ7FEDERAL FARM CREDIT BANKSFUNDING CORPAGCY BOND0.000.000.000.000.000.000.000.000.00219,920.80219,920.80219,164.51219,819.91Portfolio Activity SummarySan Jacinto, City of (66779)07/01/2021 - 07/31/2021Return to Table of ContentsDated: 08/05/2021193.A.3.aPacket Pg. 97Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
* Weighted by: Ending Market Value + Accrued. * Holdings Displayed by: Lot.Identifier,Description,Security TypeInterest/DividendReceivedTransfers In/OutPurchasesPurchasedAccruedIncomeSalesDisposed AccruedMaturities andRedemptionsPaydownsNet RealizedGain/LossBeginning OriginalCost,Ending Original CostBeginning MarketValue,Ending Market Value912828ZL7UNITED STATES TREASURYUS GOV0.000.000.000.000.000.000.000.000.00154,461.13154,461.13153,383.35154,255.2391282CBC4UNITED STATES TREASURYUS GOV0.000.000.000.000.000.000.000.000.00153,395.51153,395.51152,123.98153,316.8691282CBH3UNITED STATES TREASURYUS GOV0.000.000.000.000.000.000.000.000.00122,236.33122,236.33122,544.00123,559.6391282CBU4UNITED STATES TREASURYUS GOV0.000.000.000.000.000.000.000.000.00399,875.00399,875.00399,359.20399,812.40912828J76UNITED STATES TREASURYUS GOV0.000.000.000.00-182,228.91-834.840.000.002,400.44179,374.220.00182,235.960.0091282CBT7UNITED STATES TREASURYUS GOV0.000.000.000.000.000.000.000.000.00299,566.41299,566.41298,793.10301,289.10023135BW5AMAZON.COM INCCORP0.000.000.000.000.000.000.000.000.00144,788.30144,788.30144,728.85144,969.1691282CCC3UNITED STATES TREASURYUS GOV0.000.000.000.000.000.000.000.000.00219,510.16219,510.16218,813.98219,587.5091282CCF6UNITED STATES TREASURYUS GOV0.000.000.000.000.000.000.000.000.00219,028.91219,028.91218,848.52220,721.82912828XG0UNITED STATES TREASURYUS GOV0.000.000.000.00-152,994.14-51.970.000.003,567.37148,089.850.00153,023.400.0091282CBR1UNITED STATES TREASURYUS GOV0.000.00348,550.78-268.680.000.000.000.000.000.00348,550.780.00349,713.00---------8,861.75-104.17540,372.11-268.68-530,996.40-886.810.000.005,967.8111,232,745.5811,256,117.8111,289,764.5311,332,839.93Portfolio Activity SummarySan Jacinto, City of (66779)07/01/2021 - 07/31/2021Return to Table of ContentsDated: 08/05/2021203.A.3.aPacket Pg. 98Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
Additional Disclosure:This information is for the sole purposes of the client and is not intended to provide specific advice or recommendations. Please review the contents of this information carefully. Should you have any questions regarding theinformation presented, calculation methodology, investment portfolio, security detail, or any other facet of this information, please feel free to contact us.Public Trust Advisors, LLC (Public Trust) statements and reports are intended to detail our investment advisory activity as well as the activity of certain client accounts managed by Public Trust. The custodian bank maintainsthe control of assets and executes and settles all investment transactions. The custodian statement is the official record of security and cash holdings transactions. Public Trust recognizes that clients may use these reports tofacilitate record keeping; therefore, it is recommended that the client reconcile this information with their custodian bank statement. Many custodians use a settlement date basis that may result in the need to reconcile due to atiming difference. The underlying market value, amortized cost, and accrued interest may differ between the custodian and this statement or report. This can be attributed to differences in calculation methodologies and pricingsources used.Public Trust does not have the authority to withdraw funds from or deposit funds to the custodian. Our clients retain responsibility for their internal accounting policies, implementing and enforcing internal controls, andgenerating ledger entries or otherwise recording transactions. The total market value represents prices obtained from various sources; it may be impacted by the frequency at which prices are reported, and such prices are notguaranteed. Prices received from pricing vendors are generally based on current market quotes but when such quotes are not available, the pricing vendors use a variety of techniques to estimate value. These estimates,particularly for fixed-income securities, may be based on certain minimum principal amounts (e.g. $1 million) and may not reflect all the factors that affect the value of the security including liquidity risk. The prices provided arenot firm bids or offers. Certain securities may reflect N/A or unavailable where the price for such security is generally not available from a pricing source. The market value of a security, including those priced at par value, maydiffer from its purchase price and may not closely reflect the value at which the security may be sold or purchased based on various market factors. The securities in this investment portfolio, including shares of mutual funds,are not guaranteed or otherwise protected by Public Trust, the FDIC (except for certain non-negotiable certificates of deposit), or any government agency unless specifically stated otherwise.Clients may be permitted to establish one or more unmanaged accounts for the purposes of client reporting. Clients may also be permitted to provide externally managed assets for the purposes of client reporting. Public Trustdefines unmanaged accounts or assets as one where the investment direction remains the sole responsibility of the client rather than the Investment Manager. Unmanaged accounts or external assets do not receive ongoingsupervision and monitoring services. The Investment Manager does not make any investment recommendations and may not charge a fee for reporting on these accounts or assets. The primary purpose for this service is toinclude unmanaged accounts or assets owned by the client in the performance reports provided by the Investment Manager. The Investment Manager assumes no liability for the underlying performance of any unmanagedaccounts or assets, and it is the client’s sole responsibility for the accuracy or correctness of any such performance.Beginning and ending balances are based on market value plus accrued interest on a trade date basis. Statements and reports made available to the end user either from Public Trust or through the online reporting platformmay present information and portfolio analytics using various optional methods including, but not limited to, historical cost, amortized cost, and market value. All information is assumed to be correct, but the accuracy has notbeen confirmed and therefore is not guaranteed to be correct. Information is obtained from third party sources that may or may not be verified. The data in this report is unaudited and is only applicable for the date denoted onthe report. Market values may change day-to-day based on numerous circumstances such as trading volume, news released about the underlying issuer, issuer performance, etc. Underlying market values may be priced vianumerous aspects as certain securities are short term in nature and not readily traded. Performance results are shown net of all fees and expenses and reflect the reinvestment of dividends and other earnings.Many factors affect performance including changes in market conditions and interest rates and in response to other economic, political, or financial developments. Investment involves risk including the possible loss ofprincipal. No assurance can be given that the performance objectives of a given strategy will be achieved. Past performance is no guarantee of future results. Any financial and/or investment decision may incur losses.The investment advisor providing these services is Public Trust Advisors, LLC, an investment adviser registered with the U.S. Securities and Exchange Commission (SEC) under the Investment Advisers Act of 1940, asamended. Registration with the SEC does not imply a certain level of skill or training. Public Trust is required to maintain a written disclosure brochure of our background and business experience. If you would like to receive acopy of our current disclosure brochure, Privacy Policy, or Code of Ethics, or have any questions regarding your account please contact us.Public Trust Advisors717 17th St. Suite 1850Denver, CO 802023.A.3.aPacket Pg. 99Attachment: 2021-22 July Treasurers Report with signature (Treasurer’s Report at July 31, 2021)
September 7, 2021
TO: City Council
REQUESTED BY: Tom Prill, Deputy City Manager
APPROVED BY: Robert A. Johnson, City Manager
SUBJECT: San Jacinto Power – 2020 Power Content Label and Attestation
RECOMMENDATION:
Staff recommends that the City Council provide the attestation specified under California’s
Power Source Disclosure (PSD) Program, which requires the governing council of a public
agency providing retail electric service to endorse the accuracy of each annual report and power
content label, as submitted to the California Energy Commission, for the previous year. In the
case of San Jacinto Power (SJP), such attestations will be based on the California Choice Energy
Authority’s (CalChoice) technical review, and they will address the 2020 Annual Reports and
Power Content Labels (PCL) prepared for the SJP community choice aggregation (CCA)
program.
BACKGROUND:
California Public Utilities Code requires all retail sellers of electric energy, including SJP , to
disclose “accurate, reliable, and simple-to-understand information on sources of energy” that are
delivered to their respective customers via an annual Power Content Label (PCL). The PCL is
analogous to a nutrition label, conveying information regarding the various power
sources/products that are procured on behalf of each retail electricity customer. California’s
retail electricity sellers, including SJP, will each have unique PCLs based on internally adopted
procurement policies and related power purchases that were completed during the reporting year.
The PCL format is highly prescriptive, offering little flexibility to retail sellers when presenting
such information to customers – the CEC administers these requirements under California’s
Power Source Disclosure Program.
Information presented in each PCL includes the proportionate share of total energy supply
related to specific fuel sources/resource categories, including both renewable and conventional
generating technologies. If a retail seller procures a certain percentage of its energy
requirements from the market at large (meaning, sources of power that cannot be traced back to a
specific generator), the PCL must identify such purchases as “unspecified sources of power.” It
is very common for most retail electricity sellers to utilize an “unspecified source of power.”
In accordance with statewide mandates and internally adopted planning targets, SJP procured a
substantial portion of its electric energy supply from generating resources utilizing various
renewable fuel sources in 2020. Renewable fuel sources may include biomass & waste,
hydroelectricity, solar, geothermal, and wind. For SJP Prime Power customers, 38.2% of the
total energy supply was sourced from renewable energy resources. For SJP Pure Green
customers, 99.8% of energy deliveries were sourced from renewable energy resources. Recent
changes to power source disclosure regulations have also altered the manner in which certain
3.A.4
Packet Pg. 100
renewable energy purchases must be reported/reflected on the PCL. More specifically,
“unbundled” renewable energy certificates (meaning, renewable energy attributes that are
sold/purchased separately from associated electric power) must now be displayed outside the
area in which “bundled” renewable energy purchases (meaning, renewable energy attribute s that
are sold/purchased with associated electric power) are reported. This adaptation to the PCL
format may result in some customer confusion, as determining the total quantity of renewable
energy purchased on behalf of each customer now requires the summation of two values:
“Eligible Renewable” plus “Percentage of Retail Sales Covered by Retired Unbundled RECs.”
SJP is prepared to answer related questions should they arise.
Consistent with applicable regulations, all customers currently enrolled in the SJP program will
soon receive the PCL via U.S. mail.
To fulfill its Power Source Disclosure Program reporting obligations for 2020, SJP as a public
agency must provide the CEC with the City Council’s attestation regarding the accuracy of the
information included in the annual Power Source Disclosure Report (submitted to the CEC
earlier in 2021, according to the applicable reporting deadline) and PCL, consistent with the
following elements of PSD Program regulations.
A retail supplier that is a public agency providing electric services is not required to
comply with the provisions of subdivision (a)(1) if the board of directors of the public
agency submits to the Energy Commission an attestation of the veracity of each annual
report and power content label for the previous year.
In the preceding excerpt from applicable regulations, subdivision (a)(1) refers to a third-party
audit, which is not necessary for public agencies, including the City.
While developing SJP’s PCL, California Choice Energy Authority (CalChoice) and its technical
consultants performed a detailed review of all power purchases completed for the 2020 calendar
year. The review performed by CalChoice and its technical consultants found no inaccuracies or
inconsistencies in such information, which was subsequently entered in SJP’s annual Power
Source Disclosure reports and PCL. To fulfill its attestation requirements for 2020, Council is
being asked to provide an attestation covering both the PCL and associated Annual Reports, as
specified in the excerpt above – both elements of the PSD Program reflect information that was
consistently and accurately presented for the SJP CCA Program.
Based on reviews previously completed by staff and CalChoice’s technical consultants, the staff
requests that City Council provide the requisite attestation at this time.
Upon approval, a copy of this staff report and related meeting minutes will be forwarded to the
CEC, thereby completing SJP’s attestation requirements under California’s Power Source
Disclosure Program for the 2020 calendar year.
FISCAL IMPACT:
None.
ATTACHMENTS:
3.A.4
Packet Pg. 101
2020 PSD SJP PrimePower
2020 PSD SJP PureGreen
3.A.4
Packet Pg. 102
Version: April 2021
Adjusted Net
Procured (MWh)
Percent of Total
Retail Sales
Renewable Procurements 51,961 31.2%
Biomass & Biowaste 8,369 5.0%
Geothermal 35,592 21.4%
Eligible Hydroelectric 8,000 4.8%
Solar - 0.0%
Wind - 0.0%
Coal - 0.0%
Large Hydroelectric 309 0.2%
Natural gas - 0.0%
Nuclear 2,482 1.5%
Other - 0.0%
Unspecified Power 111,635 67.1%
Total 166,387 100.0%
166,387
743
6.7%
Total Retail Sales (MWh)
GHG Emissions Intensity (converted to lbs CO2e/MWh)
Percentage of Retail Sales Covered by Retired Unbundled
RECs
2020 POWER SOURCE DISCLOSURE ANNUAL REPORT
SCHEDULE 3: POWER CONTENT LABEL DATA
For the Year Ending December 31, 2020
San Jacinto Power
SJP PrimePower
Instructions: No data input is needed on this schedule. Retail suppliers should use
these auto-populated calculations to fill out their Power Content Labels.
3.A.4.a
Packet Pg. 103 Attachment: 2020 PSD SJP PrimePower (San Jacinto Power – 2020 Power Content Label and Attestation)
Version: April 2021
Adjusted Net
Procured (MWh)
Percent of Total
Retail Sales
Renewable Procurements 39 32.8%
Biomass & Biowaste - 0.0%
Geothermal 39 32.8%
Eligible Hydroelectric - 0.0%
Solar - 0.0%
Wind - 0.0%
Coal - 0.0%
Large Hydroelectric - 0.0%
Natural gas - 0.0%
Nuclear - 0.0%
Other - 0.0%
Unspecified Power 80 67.2%
Total 119 100.0%
119
868
67.2%
Total Retail Sales (MWh)
GHG Emissions Intensity (converted to lbs CO2e/MWh)
Percentage of Retail Sales Covered by Retired Unbundled
RECs
2020 POWER SOURCE DISCLOSURE ANNUAL REPORT
SCHEDULE 3: POWER CONTENT LABEL DATA
For the Year Ending December 31, 2020
San Jacinto Power
SJP PureGreen
Instructions: No data input is needed on this schedule. Retail suppliers should use
these auto-populated calculations to fill out their Power Content Labels.
3.A.4.b
Packet Pg. 104 Attachment: 2020 PSD SJP PureGreen (San Jacinto Power – 2020 Power Content Label and Attestation)
September 7, 2021
TO: City Council
REQUESTED BY: Travis Randel, Community Development Director
APPROVED BY: Robert A. Johnson, City Manager
SUBJECT: Appointment of Planning Commissioners for term starting November 1,
2021
RECOMMENDATION:
That the City Council reappoint Corrine Awad, Michael Health, and Taurus Jones to the
Planning Commission for terms starting November 1, 2021.
DISCUSSION:
The Planning Commission is comprised of five commissioners appointed by the City Council to
overlapping four-year terms. The terms for Commissioners Corrine Awad, Michael Heath, and
Taurus Jones expire on October 31, 2021.
Corrine Awad was appointed to the Commission on February 19, 2019, to fill the unexpired term
vacated by Jerry Mossbarger, Michael Heath were appointed to the Commission on March 2,
2020, to fill the unexpired term vacated by Leslie Moore, and Taurus Jones was appointed to the
Commission on March 2, 2021, to fill the unexpired term vacated by Jeremy Fontes.
The Authority of the San Jacinto Planning Commission is vested in the California Government
Code and the City of San Jacinto Municipal Code (Chapters 2 and 17).
Government Code §65100 requires that each city and county establish a Local Planning Agency
and that "the legislative body of each cit y and county shall by ordinance assign the functions of
the planning agency to a planning department, one or more planning commissions,
administrative bodies or hearing officers, the legislative body itself, or any combination thereof,
as it deems appropriate and necessary. In the absence of an assignment, the legislative body shall
carry out all the functions of the planning agency."
The San Jacinto Planning Commission was established under Ordinance 251 on November 27,
1945, and amended by Ordinance 502 on January 6, 1970, and Ordinance 602 on October 4,
1977.
Chapter 17.700 of the Development Code enumerates the duties and authority of the Planning
Commission as follows:
1. The review of development projects, including referrals from the Director;
2. The review of appeals from the Director's decisions;
3. The recommendation, to the Council for final decisions, on development agreements,
Development Code amendments, General Plan amendments, specific plans and
4.1
Packet Pg. 105
amendments, Zoning Map amendments, environmental documents related to any of the
foregoing, and other applicable policy or regulatory matters related to the City's planning
process; and
4. The above-listed functions shall be performed in compliance with Table 6-1 (Review
Authority), Article 6 (Permit Procedures), and the California Environmental Quality Act
(CEQA).
California Government Code §54970, known as the Maddy Act, required that City Council cause
to be prepared a list of appointments of all ongoing boards, commissions, and committees which
are appointed by the City Council on or before December 31st of each year. This list shall include
all appointive terms which will expire during the next calendar year with the name of the
incumbent appointee, the date of appointment, the date the term expires, and the necessary
qualifications for the position.
The Maddy Act takes into consideration a vast and largely untapped reservoir of talent which
exists among the citizenry that all too frequently is not aware of the opportunities for
participation on local regulatory and advisory boards and commissions. For that reason, the
Maddy Act was enacted for maximum public awareness of appointments to be made by the
Governor, the City Council, or other legislative bodies. On December 29, 2020, the City Clerk's
office posted the necessary notifications, thereby satisfying the requirement of the Maddy Act.
Staff is recommending that the City Council re-appoint Corrine Awad, Michael Heath, and
Taurus Jones to the Planning Commission commencing November 1, 2021, through October 31,
2025.
FISCAL IMPACT:
There is no impact to the General Fund.
4.1
Packet Pg. 106