Agenda
Regular Meeting of the
Bell City Council/Bell Community Housing Authority/Successor Agency to the Bell Community Redevelopment Agency/ Bell Public Finance Authority
Wednesday, January 25, 2023
5:45 P.M. CLOSED SESSION
7:00 P.M. OPEN SESSION
BELL COMMUNITY CENTER
6250 PINE AVENUE, BELL CA 90201
Monica Arroyo
Mayor
Fidencio J. Gallardo Ana Maria Quintana Vice-Mayor Council Member
Alicia Romero Ali Saleh Council Member Council Member
Welcome to the City Council Meeting
The Bell City Council and staff welcome you. This is your City Government.
Individual participation is a basic part of American Democracy and all Bell residents are encouraged to attend meetings of the City Council. Regular City Council meetings are held the second and fourth Wednesday of the m onth at 7:00 p.m., Bell Co mmunity Center , 6 250 Pine Avenue. For more information, you may call City Hall during regular business hours 8:00 a.m. to 4:00 p.m., Monday through Friday at (323) 588-6211 Extension 2615.
City Council Organization
There are five City Council members, one of whom serves as Mayor and is the presiding officer of the City Council. These are your elected representatives who act as a Board of Directors for the City of Bell. City Council members are like you, concerned residents of the community who provide guidance in the operation of your City.
Addressing the City Council
If you wish to speak to the City Council on any item which is listed or not listed on the City Council Agenda, please complete a Request to Speak Card available in the back of the City Council Chambers. Pl ease submit the completed card to the City Clerk prior to the meeting. The Mayor will call you to the microphone at the appropriate time if you have filled out a Request to Speak Card. At that time, approach the podium and please clearly state your name and address, and proceed to make your comments.
Compliance with Americans with Disabilities Act
The City of Bell, in complying with the Americans with Disabilities Act (ADA), request individuals who require special accommodation(s) to access, attend, and or participate in a City meeting due to disability. Please contact the City Clerk’s Office, (323) 588 -6211, Ext. 2615 , at least one business day prior to the scheduled meeting to ensure that we may assist you.
Statement Regarding Compensation for Members of the Bell City Council
Compensation for the members of the Bell City Council is $673 a month. In accordance with Government Code Section 54952.3, Councilmembers will not receive any additional compensation or stipend for the convening of the following regular meetings: Successor Agency to the Bell Community Redevelopment Agency, the Bell Community Housing Authority, the Bell Public Finance Authority, the Bell Surplus Property Authority, and the Bell Solid Waste Authority.
Meeting of the
Bell City Council and Related Agencies
January 25, 2023
REGULAR JOINT MEETING OF THE
Bell City Council/Bell Community Housing Authority/Successor Agency to the Bell Community Redevelopment Agency/Bell Public Finance Authority
January 25, 2023
5:45 P.M. Closed Session
7:00 P.M. Regular Meeting
Location: Bell Community Center, 6250 Pine Avenue, Bell CA 90201
Call to Order
Roll Call of the City Council in their capacities as Councilmembers/Members of all Related Agencies: Quintana, Romero, Saleh, Gallardo and Arroyo
Communications from the Public on Closed Session Items
This is the time for members of the public to address the City Council and related Authorities and Agencies only on items that are listed under Closed Session.
Closed Session
The City Council and the related Authorities and Agencies will recess to closed session to confer with legal counsel regarding the following matters:
a) CONFERENCE WITH REAL PROPERTY NEGOTIATORS (Pursuant to Government Code section 54956.8)
Property: 4777 E Gage Avenue, Bell CA 90201
Agency negotiators: Michael Antwine (City Manager), and Dave Aleshire (City Attorney) Negotiating parties: To be Determined
Under negotiation: Price and Terms of Payment
b) CONFERENCE WITH REAL PROPERTY NEGOTIATORS (Pursuant to Government Code section 54956.8)
Property: 7030 Atlantic Avenue, Bell CA 90201
Agency negotiators: Michael Antwine (City Manager), and Dave Aleshire (City Attorney) Negotiating parties: To be Determined
Under negotiation: Price and Terms of Payment
MEETING WILL BE HELD IN-PERSON AT THE BELL COMMUNITY CENTER
PUBLIC COMMENT: If you wish to make a comment on items listed on the agenda, you may attend the meeting in -person at Bell Community Center. Please complete a Request to Speak Card available in the location and wait until the mayor calls you to approach the podium. Please clearly state your name and address and proceed to make your comments .
You may also sub mit input electronically through a temporary public comment email established for City of Bell City Council meetings at [email protected]. Your written comment must be submitted by 4pm on Wednesday, January 25, 2023. Any emails received after the time indicated will not be included in the record. Written Comments will be subject to the three minute time limitation (approximately 350 words).
The meeting will be recorded and live streamed on the City’s website at http://www.cityofbell.org/?NavID=101
Meeting of the
Bell City Council and Related Agencies
January 25, 2023
c) CONFERENCE WITH REAL PROPERTY NEGOTIATORS (Pursuant to Government Code section 54956.8)
Property: 4410 Gage Avenue, Bell CA 90201
Agency negotiators: Michael Antwine (City Manager), and Dave Aleshire (City Attorney) Negotiating parties: To be Determined
Under negotiation: Price and Terms of Payment
d) CONFERENCE WITH REAL PRO PERTY NEGOTIATORS (Pursuant to Government Code section 54956.8)
Property: Caltrans Parcel 1958
Agency negotiators: Michael Antwine (City Manager), and Dave Aleshire (City Attorney) Negotiating parties: To be Determined
Under negotiation: Price and Terms of Payment
Reconvene Regular City Council Meeting
Call to Order
Roll Call of the City Council in their capacities as Councilmembers/Members of all Related Agencies: Quintana, Romero, Saleh, Gallardo and Arroyo
Pledge of Allegiance
City Attorney Report
The City Attorney will report out on any action(s) to be taken by the City Council/Agencies on Closed Session matters.
Presentations and Recognitions
None
Communications from the Public
This is the time members of the public may address the City Council and related Authorities and Agencies on items that are on the agenda and on non- agenda items that are under the subject matter jurisdiction of City Council and/or its related authorities and agencies. (Each speaker is limited to three minutes)
Mayor and City Council Communications
Pursuant to Assembly Bill 1234, this is the time and place to provide a brief report on meetings, seminars and conferences attended by the Mayor and City Councilmembers.
City Manager Report
In this portion of the agenda, the City Manager will provide a brief report on items of interest to the City Council and/or the community.
Meeting of the
Bell City Council and Related Agencies
January 25, 2023
Public Hearing(s)
The following item has been posted as a Public Hearing as required by law. The Mayor will open the Public Hearing(s) to receive public testimony only on the item(s) listed under this section.
1. Approve Resolution No. 2023-04 Ordering the Vacation of the Alley Located South of Gage Avenue Between Clarkson Avenue and Atlantic Avenue. (City Council)
Recommendation: It is recommended that the City Council read by title only, waive further reading and adopt Resolution 2023-04:
A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF
BELL ORDERING THE VACATION OF THE ALLEY LOCATED
SOUTH OF GAGE AVENUE BETWEEN CLARKSON AVENUE
AND ATLANTIC AVENUE
Business Session
2. Consideration and Adoption of Resolution Accepting, Approving and Adopting the Tentative Agreement for a Successor Memorandum of Understanding between the City of Bell and the Bell City Employees Association for the period of July 1, 2022 through June 30, 2024 . (City Council)
Recommendation: It is recommended that the City Council read by title only, waive further reading and adopt Resolution 2023-06:
A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF
BELL, CALIFORNIA, ACCEPTING, APPROVING AND
ADOPTING THE TENTATIVE AGREEMENT FOR A
SUCCESSOR MOU BETWEEN THE CITY OF BELL AND THE
BELL CITY EMPLOYEES ASSOCIATION FOR THE PERIOD OF
JULY 1, 2022 THROUGH JUNE 30, 2024
3. 2023 Amended and Restated Employment Agreement for Carlos Islas as Chief of Police. (City Council)
Recommendation: It is recommended that the City Council approve the 2023 amended and restated employment agreement for Carlos Islas as Chief of Police, with a two (2) year agreement term commencing on January 25, 2023.
4. Consideration to approve Amendment No. 2 with Real Estate Consulting & Services, Inc. (REC&S), for additional Mobile Home Parks and Housing Unit Maintenance Services . (Bell Community Housing Authority)
Recommendation: It is recommended that the Chair and Members of the Board read by title only, waive further reading and adopt Resolution 2023-07 titled:
A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF
BELL AUTHORIZING FY 2022- 23 BUDGET AMENDMENT TO
TRANSFER $120,000 FROM THE BELL COMMUNITY
HOUSING AUTHORITY (BCHA) FUND BALANCE RESERVE
Meeting of the
Bell City Council and Related Agencies
January 25, 2023
TO THE BCHA ACCOUNT FOR MISCELLANEOUS REPAIRS
AND EMERGENCY REPAIRS FOR ADDITIONAL MOBILE
HOME PARKS AND HOUSING UNIT MAINTENANCE
SERVICES
5. Economic Development Branding & Marketing Strategy. (City Council)
Recommendation: It is recommended that the City Council:
1. Approve the execution of the 2023 Economic Development Branding & Marketing Strategy; and
2. Authorize City Manager to engage various marketing, public relations, real estate, and economic feasibility consultant firms to work on the Economic Development Strategy.
Consent Calendar
The following Consent Calendar items are expected to be routine and non- controversial. They are acted upon by the City Council and related authorities at one time without discussion. The reading of the full text of ordinances and resolutions will be waived unless a Councilmember requests otherwise.
Recommendation: Approve agenda items 6 through 10.
6. Authorize the City Manager or his designee to Purchase Vehicles for the Bell Police Department. (City Council)
7. It is recommended that the City Council:
1. Read by title only, waive further reading and adopt Resolution No. 2023-05 titled:
“A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF
BELL ACCEPTING THE FLORENCE AVENUE IMPROVEMENT
PROJECT AS COMPLETE AND AUTHORIZING STAFF TO
PREPARE AND FILE THE NOTICE OF COMPLETION WITH
THE LOS ANGELES COUNTY RECORDER”
2. Authorize staff to release retention thirty-five (35) days after the filing of the Notice of Completion.
8. City of Bell & Bell Successor Agency Investment Reports as of November 2022. (City Council/Successor Agency to the Bell Community Redevelopment Agency)
9. General Warrants, Successor Agency to the Bell Community Redevelopment Agency and Community Housing Authority Warrants dated January 25 , 2023 . (Council/Successor Agency to the Bell Community Redevelopment Agency/Bell Community Housing Authority).
10. It is recommended that the City Council read by title only, waive further reading and adopt Ordinance No. 1278 titled:
Meeting of the
Bell City Council and Related Agencies
January 25, 2023
AN ORDINANCE OF THE CITY COUNCIL OF THE CITY OF
BELL, AMENDING CHAPTER 17.08 (DEFINITIONS) AND
CHAPTER 17.84 (SIGNS) OF TITLE 17 (ZON ING), RELATING
TO DIGITAL BILLBOARDS
Pending Items – None
Next Regular Meeting, Wednesday, February 8, 2023
I, Angela Bustamante, City Clerk of the City of Bell, certify that a true, accurate copy of the foregoing agenda was posted January 20 , 2023 at least seventy-two (72) hours prior to the meeting as required by law.
________________________________
Angela Bustamante, City Clerk
REGULAR MEETING OF THE
BELL CITY COUNCIL AND RELATED AGENCIES
January 25, 2023
5:45 P.M. Closed Session
7:00 P.M. Regular Session
INDEX
Agenda Category Item Number Page Numbers
CLOSED SESSION a - d
AGENDA & INDEX 1-8
PUBLIC HEARINGS 1 9-18
BUSINESS SESSION 2 19-57
3 58-90
4 91-150
5 151-155
CONSENT CALENDAR 6 156-278
7 279-283
8 284-373
9 374-456
10 457-464
STEP A STEP B STEP C STEP D STEP E
Accountant 5,954.68 6,252.41 6,565.03 6,893.28 7,237.95 Accounting Asst I 3,636.21 3,818.02 4,008.93 4,209.37 4,419.84 Accounting Asst II 3,915.93 4,111.72 4,317.31 4,533.17 4,759.83 Account Clerk 3,335.30 3,502.06 3,677.17 3,861.02 4,054.07 Accounting Specialist 4,672.93 4,906.57 5,151.90 5,409.50 5,679.97 Administrative Specialist 4,408.42 4,628.84 4,860.28 5,103.30 5,358.46 Assistant City Clerk 5,122.41 5,378.53 5,647.45 5,929.83 6,226.32 Assistant Planner 5,610.47 5,891.00 6,185.55 6,494.82 6,819.57 Associate Planner 6,076.52 6,380.35 6,699.37 7,034.34 7,386.05 Associate Civil Engineer 7,219.00 7,579.95 7,958.95 8,356.89 8,774.74 Business License Officer 2,881.23 3,025.29 3,176.56 3,335.40 3,502.17 Code Enforcement Officer 4,919.52 5,165.50 5,423.77 5,694.96 5,979.71 Code Enforcement Supervisor 6,415.13 6,735.89 7,072.68 7,426.32 7,797.63 Community Services Technician 4,147.13 4,354.47 4,572.22 4,800.83 5,040.87 Dispatcher 4,790.01 5,029.51 5,280.99 5,545.04 5,822.29 Economic Development Specialist 5,122.41 5,378.53 5,647.45 5,929.83 6,226.32 Executive Assistant 5,486.72 5,761.06 6,049.11 6,351.57 6,669.15 Filling Officer 3,636.20 3,818.01 4,008.91 4,209.36 4,419.83 Housing Coordinator 3,915.93 4,111.72 4,317.31 4,533.17 4,759.83 Housing Rehabilitation Technician 4,871.00 5,114.55 5,370.28 5,638.79 5,920.73 Housing Specialist 5,764.86 6,053.10 6,355.76 6,673.55 7,007.22 Maintenance Worker I 3,751.51 3,939.09 4,136.04 4,342.84 4,559.98 Maintenance Worker II 3,942.69 4,139.83 4,346.82 4,564.16 4,792.37 Management Analyst 5,122.41 5,378.53 5,647.45 5,929.83 6,226.32 Office Assistant I 3,031.60 3,183.18 3,342.34 3,509.46 3,684.93 Office Assistant II 3,544.16 3,721.37 3,907.44 4,102.81 4,307.95 Office Coordinator 4,207.76 4,418.15 4,639.06 4,871.01 5,114.56 Park Maintenance Worker 3,942.69 4,139.83 4,346.82 4,564.16 4,792.37 Parking Enforcement Officer 4,031.82 4,233.41 4,445.08 4,667.33 4,900.70 Classification Positions & Salary Ranges
effective January 2, 2023 through June 30, 2023
1
STEP A STEP B STEP C STEP D STEP E
Permit Technician 4,395.96 4,615.76 4,846.54 5,088.87 5,343.31 Police Records Specialist 3,915.93 4,111.72 4,317.31 4,533.17 4,759.83 Police Records Supervisor 5,890.76 6,185.30 6,494.56 6,819.29 7,160.25 Property & Evidence Specialist 4,584.96 4,814.20 5,054.91 5,307.66 5,573.04 Public Works Field Supervisor 5,857.56 6,150.44 6,457.96 6,780.86 7,119.90 Recreation Coorinator 4,710.59 4,946.12 5,193.42 5,453.09 5,725.75 Recreation Supervisor 6,155.02 6,462.77 6,785.91 7,125.20 7,481.46 Senior Accountant 7,060.49 7,413.52 7,784.19 8,173.40 8,582.07 Senior Code Enforcement Officer 5,912.03 6,207.64 6,518.02 6,843.92 7,186.11 Senior Economic Development Specialist 5,890.76 6,185.30 6,494.56 6,819.29 7,160.25 Senior Human Resource Analyst 5,890.76 6,185.30 6,494.56 6,819.29 7,160.25 Senior Management Analyst 5,890.76 6,185.30 6,494.56 6,819.29 7,160.25 Senior Parking Enforcement Officer 5,754.98 6,042.73 6,344.86 6,662.11 6,995.21 Senior Recreation Supervisor 6,110.75 6,416.29 6,737.10 7,073.96 7,427.66 2
STEP A STEP B STEP C STEP D STEP E
Accountant 6,133.32 6,439.98 6,761.98 7,100.08 7,455.09 Accounting Asst I 3,745.30 3,932.56 4,129.19 4,335.65 4,552.44 Accounting Asst II 4,033.40 4,235.07 4,446.83 4,669.17 4,902.63 Account Clerk 3,435.36 3,607.13 3,787.48 3,976.86 4,175.70 Accounting Specialist 4,813.11 5,053.77 5,306.46 5,571.78 5,850.37 Administrative Specialist 4,540.67 4,767.71 5,006.09 5,256.40 5,519.22 Assistant City Clerk 5,276.08 5,539.88 5,816.88 6,107.72 6,413.11 Assistant Planner 5,778.79 6,067.73 6,371.11 6,689.67 7,024.15 Associate Planner 6,258.82 6,571.76 6,900.35 7,245.37 7,607.63 Associate Civil Engineer 7,435.57 7,807.35 8,197.72 8,607.60 9,037.98 Business License Officer 2,967.67 3,116.05 3,271.85 3,435.45 3,607.22 Code Enforcement Officer 5,067.11 5,320.46 5,586.49 5,865.81 6,159.10 Code Enforcement Supervisor 6,607.58 6,937.96 7,284.86 7,649.11 8,031.56 Community Services Technician 4,271.54 4,485.12 4,709.38 4,944.85 5,192.09 Dispatcher 4,933.71 5,180.40 5,439.42 5,711.39 5,996.96 Economic Development Specialist 5,276.08 5,539.88 5,816.88 6,107.72 6,413.11 Executive Assistant 5,651.33 5,933.89 6,230.59 6,542.12 6,869.22 Filling Officer 3,745.29 3,932.55 4,129.18 4,335.64 4,552.42 Housing Coordinator 4,033.40 4,235.07 4,446.83 4,669.17 4,902.63 Housing Rehabilitation Technician 5,017.13 5,267.99 5,531.39 5,807.96 6,098.35 Housing Specialist 5,937.81 6,234.70 6,546.43 6,873.75 7,217.44 Maintenance Worker I 3,864.05 4,057.26 4,260.12 4,473.13 4,696.78 Maintenance Worker II 4,060.97 4,264.02 4,477.22 4,701.08 4,936.14 Management Analyst 5,276.08 5,539.88 5,816.88 6,107.72 6,413.11 Office Assistant I 3,122.55 3,278.68 3,442.61 3,614.74 3,795.48 Office Assistant II 3,650.49 3,833.01 4,024.66 4,225.90 4,437.19 Office Coordinator 4,333.99 4,550.69 4,778.23 5,017.14 5,268.00 Park Maintenance Worker 4,060.97 4,264.02 4,477.22 4,701.08 4,936.14 Parking Enforcement Officer 4,152.77 4,360.41 4,578.43 4,807.35 5,047.72 Classification Positions & Salary Ranges
effective July 3, 2023 through June 30, 2024
3
STEP A STEP B STEP C STEP D STEP E
Permit Technician 4,527.84 4,754.23 4,991.94 5,241.54 5,503.61 Police Records Specialist 4,033.40 4,235.07 4,446.83 4,669.17 4,902.63 Police Records Supervisor 6,067.48 6,370.86 6,689.40 7,023.87 7,375.06 Property & Evidence Specialist 4,722.50 4,958.63 5,206.56 5,466.89 5,740.23 Public Works Field Supervisor 6,033.29 6,334.95 6,651.70 6,984.28 7,333.50 Recreation Coorinator 4,851.90 5,094.50 5,349.22 5,616.69 5,897.52 Recreation Supervisor 6,339.67 6,656.65 6,989.48 7,338.96 7,705.91 Senior Accountant 7,272.31 7,635.92 8,017.72 8,418.60 8,839.53 Senior Code Enforcement Officer 6,089.39 6,393.86 6,713.56 7,049.24 7,401.70 Senior Economic Development Specialist 6,067.48 6,370.86 6,689.40 7,023.87 7,375.06 Senior Human Resource Analyst 6,067.48 6,370.86 6,689.40 7,023.87 7,375.06 Senior Management Analyst 6,067.48 6,370.86 6,689.40 7,023.87 7,375.06 Senior Parking Enforcement Officer 5,927.63 6,224.01 6,535.21 6,861.97 7,205.07 Senior Recreation Supervisor 6,294.07 6,608.78 6,939.22 7,286.18 7,650.49 4
Report Date: 01/25/2023
Issuer / Book Market % of YTM
CUSIP Security Value Value * Portfolio (Market Y)
LAIF 18,348,560 18,348,560 63.80% 2.01%
See Attached Asset-Backed Security 871,261 841,786 3.00% 5.31% See Attached Agency Issues 2,563,800 2,472,764 8.60% 4.67% See Attached Commercial Mortagage 560,175 553,282 1.93% 5.06% See Attached Corporate 2,412,162 2,332,277 8.11% 4.69%
See Attached Money Market 30,105 30,105 0.11% 3.35%
See Attached Supranational 530,738 499,260 1.74% 4.58%
See Attached US Treasury 3,856,043 3,666,724 12.74% 4.24% Accrued Interest 37,347
Totals 29,172,844$ 28,782,104$ 100%
Bank Account Balances:
Wells Fargo Bank Stagecoach Sweep General Checking: 1,948,055.75$ Wells Fargo Bank Commercial Checking Choice IV-Public Funds: 52,108.00 Wells Fargo Bank Bell Community Housing Authority Checking Account: 1 -
Wells Fargo Bank Payroll Account: 2
-
Wells Fargo Bank Worker's Compensation Account: 3
65,465.05
2,065,628.80$
The City's investment and banking liquidity is adequate for it to meet its expenditure requirements for the next 180 days. There have been no variances to the City Investment Policy. 1 The Bell Community Housing Authority Account - This bank account segregates the financial activities pertinent of the Housing Authority, Fund 90.
This bank account was transitioned to zero balance account (ZBA) status in 2013 and is reconciled to the City's General Ledger. 2 Payroll Account - This bank account segregates payroll activities. This bank account was transitioned to zero balance account (ZBA) status in 2013 and is reconciled to the City's General Ledger. 3 Workers' Compensation - This bank account was established for joint access by City Staff and the City's third -party administrator, AdminSure, to administer workers' compensation programming.
The account is reimbursed by bank transfers as necessary. * Current market valuation is required for investments with maturities of more than twelve months. MV includes accrued interest earned as of 11/30/2022 City of Bell Investment Report
LAIF Deposit and Core Investments
November 2022
MONTH FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23
JULY 25,600,523.51$ 25,320,562.61$ 27,158,657.80$ 36,441,274.21$ AUGUST 23,650,305.37 23,739,062.20 28,268,929.13 35,223,821.96$ SEPTEMBER 21,748,944.76 21,690,804.87 26,397,025.57 32,811,437.12$ OCTOBER 21,193,173.66 21,605,826.32 26,237,986.42 31,444,024.32$ NOVEMBER 20,099,691.81 22,017,659.98 25,741,196.73 31,238,472.56$ DECEMBER 21,785,287.59 24,124,656.89 28,966,073.71 JANUARY 24,770,584.76 27,425,271.30 33,505,081.56 FEBRUARY 25,232,601.81 25,221,695.57 33,233,351.99 MARCH 25,624,394.74 25,161,017.39 32,837,890.46
APRIL 26,944,295.13 25,811,974.54 34,829,178.84
MAY 29,010,371.43 28,685,142.78 37,384,223.90
JUNE 29,238,115.42 28,279,502.12 38,524,813.01
City of Bell
Historical Summary of Invested Funds & Bank Deposits
Report Date: 01/25/2023
Issuer / Book Market % of YTM
Security Value Value * Portfolio (Purchase Y)
LAIF 578,816 578,816 100.00% 2.01%
Totals 578,816$ 578,816$ 100.00% Bank Account Balances:
Wells Fargo Bank Successor to RDA: 264,942$
* Current market valuation is required for investments with maturities of more than twelve months.
City of Bell Successor to Redevelopment Agency - This bank account segregates the financial activities of the Successor Agency and is reconciled to the City's General Ledger each month.
Bell Successor Agency Investment Report
November 2022
All Investments
MONTH FY 2020-21 FY 2021-22 FY 2022-23
JULY 2,652,039.24$ 2,634,143.35$ 2,596,401.97$
AUGUST 2,653,373.37 2,601,063.64 2,591,745.15$
SEPTEMBER 986,026.30 890,531.10 852,536.05$
OCTOBER 995,957.79 886,165.69 856,629.31$
NOVEMBER 995,957.04 876,829.70 843,758.80$
DECEMBER 995,914.01 873,108.41
JANUARY 1,895,562.17 1,459,106.09
FEBRUARY 1,747,081.95 1,325,546.77
MARCH 1,140,655.41 1,014,355.71
APRIL 1,144,094.97 1,000,743.36
MAY 1,131,195.10 994,985.29
JUNE 2,770,827.46 2,595,074.09
Community Redevelopment Agency / Successor Agency
Historical Summary of Invested Funds & Bank Deposits
STAGECOACH SWEEP
WELLS FARGO BANK, N.A.
P.O. BOX 63020
THIS STATEMENT COVERS 11/01/2022 THROUGH 11/30/2022
FOR QUESTIONS, PLEASE CALL YOUR CUSTOMER SERVICE OFFICER OR CUSTOMER CARE FOR BUSINESS (CC4B) SERVICE OFFICE AT 1-800-AT-WELLS (1-800-289-3557).
ALLSPRING TREASURY PLUS MMF A CLS
Transaction Detail
Daily Balance Information
Date Investment Balance Annualized Fund Yield Daily Dividend Factor Daily Accrual 11-01 1,441,016.23 2.525 % .000069205 99.73
11-02 1,133,023.47 2.521 % .000069073 78.26
11-03 1,101,203.85 3.146 % .000086213 94.94
11-04 1,133,029.74 3.163 % .000086676 98.21
11-05* 1,133,029.74 3.163 % .000086676 98.21
11-06* 1,133,029.74 3.163 % .000086676 98.21
SAN FRANCISCO, CA 94163 Page 1 of 2
CITY OF BELL
GENERAL FUND OPERATING
ATTN CITY TREASURER
6330 PINE AVE
BELL CA 90201-1221
Account Number - DDA
4159281427
11-01-2022 Beginning Balance 1,374,195.89
11-01-2022 Next Day Sweep Purchase 64,067.91
11-01-2022 Reinvested Dividend 2,752.43
11-02-2022 Sweep Funds Return To DDA 307,992.76
11-03-2022 Sweep Funds Return To DDA 31,819.62
11-04-2022 Next Day Sweep Purchase 31,825.89
11-07-2022 Next Day Sweep Purchase 24,309.55
11-08-2022 Sweep Funds Return To DDA 7,166.14
11-09-2022 Sweep Funds Return To DDA 15,146.76
11-10-2022 Sweep Funds Return To DDA 210,793.67
11-14-2022 Sweep Funds Return To DDA 58,645.11
11-15-2022 Sweep Funds Return To DDA 141,058.35
11-16-2022 Sweep Funds Return To DDA 69,990.20
11-17-2022 Sweep Funds Return To DDA 28,614.32
11-18-2022 Next Day Sweep Purchase 981,905.77
11-21-2022 Next Day Sweep Purchase 175,349.82
11-22-2022 Sweep Funds Return To DDA 12,663.66
11-23-2022 Sweep Funds Return To DDA 143,156.72
11-25-2022 Sweep Funds Return To DDA 47,893.10
11-28-2022 Sweep Funds Return To DDA 82,938.18
11-29-2022 Sweep Funds Return To DDA 51,017.10
11-30-2022 Next Day Sweep Purchase 502,544.18
11-30-2022 Ending Balance 1,948,055.75
FUND SUMMARY
Dividends Earned YTD 12,732.25
Federal Withholding YTD .00
7-Day Simple Yield 3.20280 %
Federal Withholding .00
Beginning Balance 1,374,195.89
Prior Months Dividends Reinvested 2,752.43 +
Shares Purchased 1,780,003.12 +
Shares Redeemed 1,208,895.69 -
Ending Balance 1,948,055.75
Dividends Earned in Current Month 3,265.59
Funds Pending Redemption 2,948.83-
XXXXXXXXX
STAGECOACH SWEEP
Date Investment Balance Annualized Fund Yield Daily Dividend Factor Daily Accrual 11-07 1,157,339.29 3.150 % .000086314 99.89
11-08 1,150,173.15 3.161 % .000086629 99.64
11-09 1,135,026.39 3.174 % .000086979 98.72
11-10 924,232.72 3.165 % .000086722 80.15
11-11* 865,587.61 3.165 % .000086722 75.07
11-12* 865,587.61 3.165 % .000086722 75.07
11-13* 865,587.61 3.165 % .000086722 75.07
11-14 865,587.61 3.238 % .000088726 76.80
11-15 724,529.26 3.180 % .000087146 63.14
11-16 654,539.06 3.216 % .000088115 57.67
11-17 625,924.74 3.164 % .000086696 54.27
11-18 1,607,830.51 3.190 % .000087408 140.54
11-19* 1,607,830.51 3.190 % .000087408 140.54
11-20* 1,607,830.51 3.190 % .000087408 140.54
11-21 1,783,180.33 3.197 % .000087594 156.20
11-22 1,770,516.67 3.189 % .000087395 154.73
11-23 1,627,359.95 3.194 % .000087530 142.44
11-24* 1,579,466.85 3.194 % .000087530 138.25
11-25 1,579,466.85 3.180 % .000087142 137.64
11-26* 1,496,528.67 3.180 % .000087142 130.41
11-27* 1,496,528.67 3.180 % .000087142 130.41
11-28 1,496,528.67 3.198 % .000087634 131.15
11-29 1,445,511.57 3.202 % .000087730 126.81
11-30 1,948,055.75 3.239 % .000088758 172.91
TOTAL MTD 3,265.62
* Indicates non-business day
THANK YOU FOR BANKING WITH WELLS FARGO.
MONEY MARKET MUTUAL FUNDS (EACH, A "MMMF") ARE NOT FDIC INSURED, HAVE NO BANK GUARANTY AND MAY LOSE VALUE.
An Investment in a MMMF is not insured by the Federal Deposit Insurance Corporation or any other government agency. Although the MMMF's seek to preserve the value of customer's investment at $1.00 per share, it is possible to lose money by investing in a MMMF.
Allspring Funds Management, LLC, a wholly owned subsidiary of Allspring Global Investments Holdings, LLC ("Allspring Global"), provides investment advisory and administrative services for the Allspring Funds?. Other subsidiaries of Allspring Global provide sub-advisory and other services for the funds. The funds are distributed by Allspring Funds Distributor, LLC, Member FINRA/SIPC, a subsidiary of Allspring Global.
This material must be accompanied or preceded by a current prospectus for name of the Fund(s) selected. Please read the prospectus carefully before investing.
11/01/2022 - 11/30/2022
Account Number - DDA
4159281427
XXXXXXXXX
Choice IV-Public Funds {NIB}
Account number: 4159281427 November 1, 2022 - November 30, 2022 Page 1 of 8 Prior account number: 145398000
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
(182)
Questions?
Call your Customer Service Officer or Client Services
1-800-AT WELLS (1-800-289-3557)
5:00 AM TO 6:00 PM Pacific Time Monday - Friday
Online: wellsfargo.com
Write: Wells Fargo Bank, N.A. (182)
PO Box 63020
San Francisco, CA 94163
CITY OF BELL
GENERAL FUND OPERATING
ATTN CITY TREASURER
6330 PINE AVE
BELL CA 90201-1221
Account summary
Choice IV-Public Funds {NIB}
Account number Beginning balance Total credits Total debits Ending balance 4159281427 $54,263.00 $3,909,258.70 -$3,911,413.70 $52,108.00 Credits
Deposits
Effective
date
Posted
date Amount
Transaction detail
11/02 531.00 Deposit
11/02 1,228.00 Deposit
11/04 225.00 Deposit
11/04 289.00 Deposit
11/14 218.50 Deposit
11/14 363.50 Deposit
11/14 575.00 Deposit
11/14 931.05 Deposit
11/14 1,395.07 Deposit
11/21 11/22 218.00 Reversal of Check Posted 11-21-22 Reposted 11-22-22 as Serial 0000079505 Our Ref: 11-21-22 00000000
$5,974.12 Total deposits
Electronic deposits/bank credits
Effective
date
Posted
date Amount
Transaction detail
11/01 17.66 Southern Califor Single 221101
Just*Energy*Uut*Payment*20220922000070U101322\
11/01 209.00 11/01Bankcard Deposit -0328029701
11/01 236.33 11/01Bankcard Deposit -0328029700
11/01 434.00 11/01Bankcard Deposit -0328029701
11/01 1,008.11 11/01Bankcard Deposit -0328029700
11/01 2,299.33 CC Tm PA LLC Cci AP 820 221021 02750915
33**\Ref*PO*00514644\Dtm*003*221101\SE*8*0001\GE*
Sheet Seq = 0019603
Sheet 00001 of 00008
XXXXXXXX
XXXXXXXXX
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
Account number: 4159281427 November 1, 2022 - November 30, 2022 Page 2 of 8 Prior account number: 145398000
Electronic deposits/bank credits (continued)
Effective
date
Posted
date Amount
Transaction detail
11/01 3,419.98 Cctm1 LLC Cci AP 820 221021 02745778
98**\Ref*PO*00514710\Dtm*003*221101\SE*8*0001\GE*
11/01 3,848.00 LA County Gen-Pymt 221027 500110 NTE*202210275506989 *A2300242267 *500110
11/01 5,895.25 Square Inc 221101P2 221101 L210761370160 City of Bell 11/01 10,611.40 Desktop Check Deposit
11/01 37,572.94 Southern Califor Single 221101 SCG*Uut*Payment*20220922000070U101222\ 11/01 294.95 ZBA Funding Account Transfer From 4121929244 11/01 307,992.76 Sweep Transfer From Investment
11/02 100.00 11/02Bankcard Deposit -0328029700
11/02 266.72 Square Inc 221102P2 221102 L210761557775 City of Bell 11/02 1,682.87 Active Network, Registrati 000000005953308 Rmr*IV*13575698**1682.87*1682.87*0\Ref*PO*RN 0011
11/02 198,704.10 Desktop Check Deposit
11/02 31,819.62 Sweep Transfer From Investment
11/03 16.00 11/03Bankcard Deposit -0328029701
11/03 209.00 11/03Bankcard Deposit -0328029701
11/03 482.00 Active Network, Registrati 000000005953851 Rmr*IV*13578339**482*482*0\Ref*PO*RN 0011549 City
11/03 2,874.87 11/03Bankcard Deposit -0328029700
11/03 3,719.54 Desktop Check Deposit
11/03 28,161.79 ZBA Funding Account Transfer From 4121929244 11/04 20.00 11/04Bankcard Deposit -0328029701
11/04 240.00 11/04Bankcard Deposit -0328029700
11/04 1,029.73 Square Inc 221104P2 221104 L210762217085 City of Bell 11/07 8,514.70 Desktop Check Deposit
11/07 16,473.69 LA County Gen-Pymt 221102 500110 NTE*202211025512130 *A2300249272 *500110
11/07 56,875.25 ZBA Funding Account Transfer From 4121929244 11/07 7,166.14 Sweep Transfer From Investment
11/08 16.00 11/08Bankcard Deposit -0328029701
11/08 150.00 11/08Bankcard Deposit -0328029701
11/08 170.30 11/08Bankcard Deposit -0328029700
11/08 194.69 11/08Bankcard Deposit -0328029700
11/08 912.82 Square Inc 221108P2 221108 L210763048410 City of Bell 11/08 30,611.27 Desktop Check Deposit
11/08 73,030.72 Apport St of CA Apsapports 110322 388 Bell City Treasurer 11/08 15,146.76 Sweep Transfer From Investment
11/09 38.27 Ce Solutions D Operating Fgwap0000605615 Cagasuut2210 11/09 781.67 11/09Bankcard Deposit -0328029700
11/09 790.81 Square Inc 221109P2 221109 L210763240146 City of Bell 11/09 877.85 11/09Bankcard Deposit -0328029700
11/09 4,807.92 Desktop Check Deposit
11/09 19,145.60 Ce Solutions D Operating Fgwap0000605530 Caelectricityuut2210 11/09 53,930.41 ZBA Funding Account Transfer From 4121929244 11/09 210,793.67 Sweep Transfer From Investment
11/10 10.00 11/10Bankcard Deposit -0328029700
11/10 16.00 11/10Bankcard Deposit -0328029701
11/10 170.30 11/10Bankcard Deposit -0328029700
Sheet Seq = 0019604
Sheet 00002 of 00008
XXXXXXXXX
XXXXXXXX
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
Account number: 4159281427 November 1, 2022 - November 30, 2022 Page 3 of 8 Prior account number: 145398000
Electronic deposits/bank credits (continued)
Effective
date
Posted
date Amount
Transaction detail
11/10 731.72 Active Network, Registrati 000000005956741 Rmr*IV*13582632**731.72*731.72*0\Ref*PO*RN 001154
11/10 1,581.62 Square Inc 221110P2 221110 L210763556767 City of Bell 11/10 3,242.99 Desktop Check Deposit
11/10 5,698.62 Lacmta Corp Pmt 1171427
|003|20221014~SE|35|0081~GE|0001|14842904~Iea|000
11/10 34,829.88 ZBA Funding Account Transfer From 4121929244 11/10 58,645.11 Sweep Transfer From Investment
11/14 15.00 11/14Bankcard Deposit -0328029701
11/14 30.00 11/14Bankcard Deposit -0328029700
11/14 288.00 11/14Bankcard Deposit -0328029701
11/14 500.06 Square Inc 221114P2 221114 L210764467015 City of Bell 11/14 2,225.26 WT Fed#06968 Bank of America, N /Org=PMAm Corporation Aaf City of Bell Srf# 2022111400127466 Trn#221114048639 Rfb# Oct 22 Alarm Fee 11/14 24,017.42 Desktop Check Deposit
11/14 141,058.35 Sweep Transfer From Investment
11/15 10.00 11/15Bankcard Deposit -0328029700
11/15 110.00 11/15Bankcard Deposit -0328029700
11/15 147.86 Square Inc 221115P2 221115 L210764649507 City of Bell 11/15 211.50 11/15Bankcard Deposit -0328029701
11/15 508.13 Desktop Check Deposit
11/15 69,990.20 Sweep Transfer From Investment
11/16 104.00 Square Inc 221116P2 221116 L210764837621 City of Bell 11/16 110.00 11/16Bankcard Deposit -0328029700
11/16 30,265.14 Desktop Check Deposit
11/16 28,614.32 Sweep Transfer From Investment
11/17 16.00 11/17Bankcard Deposit -0328029701
11/17 120.00 Cash Only Customer Deposit
11/17 142.50 Cash Only Customer Deposit
11/17 328.00 Cash Only Customer Deposit
11/17 640.00 11/17Bankcard Deposit -0328029700
11/17 688.46 Desktop Check Deposit
11/17 905.32 11/17Bankcard Deposit -0328029700
11/17 1,075.13 Square Inc 221117P2 221117 L210765159254 City of Bell 11/17 2,948.63 Active Network, Registrati 000000005958700 Rmr*IV*13587088**2948.63*2948.63*0\Ref*PO*RN 0011
11/17 221,090.41 Southern Califor EDI Paymts 2211100001 003*221001***20^Dtm*003*221031***20^SE*15*86879^G
11/17 800,000.00 WT Seq135120 Cal State Treasurer /Org=State of California - Laif Srf# Ec22111769116376 Trn#221117135120 Rfb# 245990010050016
11/17 5.59 ZBA Funding Account Transfer From 4121929244 11/18 20.00 11/18Bankcard Deposit -0328029700
11/18 1,311.01 Cash Only Customer Deposit
11/18 3,716.19 Square Inc 221118P2 221118 L210765498829 City of Bell 11/18 46,375.00 Lacounty Develop Payment 221118 0000000895 Rmr*IV*067249**0046375.00\ 11/18 137,234.67 LA County Gen-Pymt 221115 Pta-11600 NTE*202211155523924 *A2300268343 *Pta-11600
11/21 17.00 Cash Only Customer Deposit
11/21 290.75 Square Inc 221121P2 221121 L210766141039 City of Bell 11/21 410.00 Cash Only Customer Deposit
Sheet Seq = 0019605
Sheet 00003 of 00008
XXXXXXXXX
XXXXXXXX
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
Account number: 4159281427 November 1, 2022 - November 30, 2022 Page 4 of 8 Prior account number: 145398000
Electronic deposits/bank credits (continued)
Effective
date
Posted
date Amount
Transaction detail
11/21 1,500.00 Jpmorgan Chase B Payment
Rmr*IV*16597-0002815095**1500.00*1500.00*0.00\
11/21 30,396.51 Desktop Check Deposit
11/21 59,705.30 Desktop Check Deposit
11/21 12,663.66 Sweep Transfer From Investment
11/22 100.00 11/22Bankcard Deposit -0328029700
11/22 209.00 11/22Bankcard Deposit -0328029701
11/22 900.00 11/22Bankcard Deposit -0328029700
11/22 1,153.55 Square Inc 221122P2 221122 L210766335532 City of Bell 11/22 5,348.14 Desktop Check Deposit
11/22 65,669.13 Apport St of CA Apsapports 111722 388 Bell City Treasurer 11/22 2,807.42 ZBA Funding Account Transfer From 4121929244 11/22 143,156.72 Sweep Transfer From Investment
11/23 54.00 Cash Only Customer Deposit
11/23 248.00 11/23Bankcard Deposit -0328029700
11/23 694.05 Cash Only Customer Deposit
11/23 2,278.07 Amer Tower 1942 EDI Paymnt Nov 23 43Rent_40008337 096913399\Iea*00001*096913399\
11/23 11,131.66 Desktop Check Deposit
11/23 18,720.37 LA County Gen-Pymt 221121 500110 NTE*202211205530540 *A2300277273 *500110
11/23 47,893.10 Sweep Transfer From Investment
11/25 15.00 11/25Bankcard Deposit -0328029701
11/25 110.00 11/25Bankcard Deposit -0328029700
11/25 276.32 Square Inc 221124P2 221124 L210766850741 City of Bell 11/25 397.46 Active Network, Registrati 000000005961634 Rmr*IV*13591937**397.46*397.46*0\Ref*PO*RN 001154
11/25 82,938.18 Sweep Transfer From Investment
11/28 220.00 Cash Only Customer Deposit
11/28 1,188.09 Usb AP Payment AP Payment 0001-340281439 City of Bell 11/28 3,866.08 Desktop Check Deposit
11/28 51,017.10 Sweep Transfer From Investment
11/29 97.88 Square Inc 221129P2 221129 L210767622398 City of Bell 11/29 402.26 11/29Bankcard Deposit -0328029700
11/29 3,229.30 Desktop Check Deposit
11/29 4,614.50 LA County Gen-Pymt 221122 500110 NTE*202211225533479 *A2300289029 *500110
11/29 67,444.62 Lacmta Corp Pmt 1172400
7444.62~Dtm|003|20221118~SE|33|0166~GE|0001|15051
11/29 81,310.03 Lacmta Corp Pmt 1172401
1310.03~Dtm|003|20221118~SE|33|0108~GE|0001|15051
11/29 425,535.90 CA Dept Tax&Fee Cdtfa-Ltax 112222 19005 City of Bell 11/30 15.00 11/30Bankcard Deposit -0328029701
11/30 316.00 Cash Only Customer Deposit
11/30 797.63 11/30Bankcard Deposit -0328029700
11/30 972.69 11/30Bankcard Deposit -0328029700
11/30 1,667.60 Square Inc 221130P2 221130 L210767808812 City of Bell 11/30 2,108.71 Desktop Check Deposit
Sheet Seq = 0019606
Sheet 00004 of 00008
XXXXXXXXX
XXXXXXXX
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
Account number: 4159281427 November 1, 2022 - November 30, 2022 Page 5 of 8 Prior account number: 145398000
Electronic deposits/bank credits (continued)
Effective
date
Posted
date Amount
Transaction detail
11/30 3,106.09 Cash Only Customer Deposit
11/30 2,948.83 Sweep Transfer From Investment
$3,903,284.58 Total electronic deposits/bank credits
$3,909,258.70 Total credits
Debits
Electronic debits/bank debits
Effective
date
Posted
date Amount
Transaction detail
11/01 3,424.78 < Business to Business ACH Debit - AFLAC Insurance 102822 Vw090255722 City of Bell
11/01 435.88 ZBA Funding Account Transfer to 4159281401 11/02 8,798.43 WT Seq453560 City of Bell /Bnf=City of Bell Srf# Gb00000054401367 Trn#221102453560 Rfb# 2746
11/02 1,874.27 ZBA Funding Account Transfer to 4121929244 11/02 402.83 ZBA Funding Account Transfer to 4159281401 11/03 5,563.31 < Business to Business ACH Debit - Calpers 3100 5686383552 100000016932076 11/03 11,940.28 < Business to Business ACH Debit - Calpers 3100 5686383552 100000016932152 11/03 15,005.78 < Business to Business ACH Debit - Calpers 3100 5686383552 100000016932037 11/03 16,886.87 < Business to Business ACH Debit - Calpers 3100 5686383552 100000016931997 11/03 19,794.07 < Business to Business ACH Debit - Calpers 3100 5686383552 100000016932115 11/03 1,005.62 ZBA Funding Account Transfer to 4159281401 11/03 31,825.89 Sweep Transfer to Investment
11/04 277.18 ZBA Funding Account Transfer to 4159281401 11/04 24,309.55 Sweep Transfer to Investment
11/07 4,569.32 WT Seq456350 City of Bell /Bnf=City of Bell Srf# Gb00000054504506 Trn#221107456350 Rfb# 2747
11/07 1,480.65 ZBA Funding Account Transfer to 4159281401 11/08 383.20 < Business to Business ACH Debit - Calpers 1800 5686383552 100000016971670 11/08 143,407.39 < Business to Business ACH Debit - Calpers 1800 5686383552 100000016971662 11/08 8,324.41 ZBA Funding Account Transfer to 4121929244 11/09 3,196.74 ACH Prep Origintn - General Fund - File 2956000677 Coid 2956000677 11/09 235,956.80 ZBA Funding Account Transfer to 4159281401 11/10 0.75 Bankcard Discount Fee - 0328029701
11/10 1.36 Bankcard Discount Fee - 0328029701
11/10 1.74 Bankcard Fee - 0328029701
11/10 2.36 Bankcard Discount Fee - 0328029701
11/10 2.48 Bankcard Discount Fee - 0328029700
11/10 2.59 Bankcard Discount Fee - 0328029700
11/10 4.05 Bankcard Fee - 0328029700
11/10 10.94 Bankcard Discount Fee - 0328029700
11/10 28.66 Bankcard Interchange Fee - 0328029701
11/10 31.59 Bankcard Discount Fee - 0328029700
11/10 306.20 Bankcard Interchange Fee - 0328029700
11/10 1,047.22 < Business to Business ACH Debit - Expertpay Expertpay xxxxx0677 City of Bell 11/10 12,894.34 < Business to Business ACH Debit - Wright Express Fleet Debi 221109 9100005154093 City of Bell (3)
Sheet Seq = 0019607
Sheet 00005 of 00008
XXXXXXXXX
XXXXXXXX
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
Account number: 4159281427 November 1, 2022 - November 30, 2022 Page 6 of 8 Prior account number: 145398000
Electronic debits/bank debits (continued)
Effective
date
Posted
date Amount
Transaction detail
11/10 83,637.73 ZBA Funding Account Transfer to 4159281401 11/14 806.25 Client Analysis Srvc Chrg 221110 Svc Chge 1022 000004159281427 11/14 9,481.94 ZBA Funding Account Transfer to 4121929244 11/14 13,042.17 ZBA Funding Account Transfer to 4159281401 11/15 3,488.45 WT Seq455913 City of Bell /Bnf=City of Bell Srf# Gb00000054660818 Trn#221115455913 Rfb# 2748
11/15 7,108.29 ZBA Funding Account Transfer to 4121929244 11/15 619.24 ZBA Funding Account Transfer to 4159281401 11/16 26,615.94 ZBA Funding Account Transfer to 4121929244 11/16 556.11 ZBA Funding Account Transfer to 4159281401 11/17 5,110.82 < Business to Business ACH Debit - Calpers 3100 5686383552 100000016963943 11/17 12,236.15 < Business to Business ACH Debit - Calpers 3100 5686383552 100000016964009 11/17 14,020.92 < Business to Business ACH Debit - Calpers 3100 5686383552 100000016963905 11/17 17,046.18 < Business to Business ACH Debit - Calpers 3100 5686383552 100000016963861 11/17 18,201.08 < Business to Business ACH Debit - Calpers 3100 5686383552 100000016963978 11/17 981,905.77 Sweep Transfer to Investment
11/18 11,074.19 ZBA Funding Account Transfer to 4121929244 11/18 175,349.82 Sweep Transfer to Investment
11/21 4,843.40 WT Seq453375 City of Bell /Bnf=City of Bell Srf# Gb00000054777256 Trn#221121453375 Rfb# 2750
11/21 17,827.08 WT Fed#09816 US Bank, NA /Ftr/Bnf=U.S. Bank National Association Srf# Gw00000054771744 Trn#221121142305 Rfb# 2749
11/21 3,893.20 ZBA Funding Account Transfer to 4121929244 11/22 3,196.74 ACH Prep Origintn - General Fund - File 2956000677 Coid 2956000677 11/22 239,447.75 ZBA Funding Account Transfer to 4159281401 11/23 732.81 ZBA Funding Account Transfer to 4121929244 11/23 593.49 ZBA Funding Account Transfer to 4159281401 11/25 1,047.22 < Business to Business ACH Debit - Expertpay Expertpay xxxxx0677 City of Bell 11/25 93,555.11 ZBA Funding Account Transfer to 4159281401 11/28 9,230.26 ZBA Funding Account Transfer to 4121929244 11/28 2,558.15 ZBA Funding Account Transfer to 4159281401 11/29 1,906.40 WT Seq454622 City of Bell /Bnf=City of Bell Srf# Gb00000054917103 Trn#221129454622 Rfb# 2752
11/29 156.00 ZBA Funding Account Transfer to 4121929244 11/29 535.08 ZBA Funding Account Transfer to 4159281401 11/29 502,544.18 Sweep Transfer to Investment
11/30 4,057.98 < Business to Business ACH Debit - AFLAC Insurance 112822 Vw090600898 City of Bell
$2,819,623.43 Total electronic debits/bank debits
< Business to Business ACH: If this is a business account, this transaction has a return time frame of one business day from post date. This time frame does not apply to consumer accounts.
Checks paid
Number Amount Date Number Amount Date Number Amount Date 7955 218.00 11/21
77669 * 65.00 11/30
78862 * 100.00 11/22
79091 * 160.00 11/07
79107 * 46.03 11/03
79289 * 140.00 11/15
79505 * 218.00 11/22
79605 * 696.76 11/21
79609 * 50.00 11/16
79658 * 20.00 11/10
79666 * 20.00 11/04
79782 * 100.00 11/15
Sheet Seq = 0019608
Sheet 00006 of 00008
XXXXXXXXX
XXXXXXXX
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
Account number: 4159281427 November 1, 2022 - November 30, 2022 Page 7 of 8 Prior account number: 145398000
Checks paid (continued)
Number Amount Date Number Amount Date Number Amount Date 79787 * 74.40 11/15
79788 150.00 11/04
79790 * 90.00 11/01
79798 * 195,131.30 11/01
79803 * 75.63 11/21
79807 * 215.56 11/07
79809 * 50.00 11/14
79813 * 1,095.00 11/02
79814 43,676.73 11/01
79815 15,164.25 11/01
79818 * 16,193.08 11/01
79820 * 21,725.00 11/02
79831 * 450.00 11/01
79835 * 101.84 11/01
79856 * 876.09 11/14
79859 * 65,647.12 11/03
79860 29,780.19 11/03
79861 10,000.00 11/07
79863 * 24,093.99 11/09
79864 23,633.00 11/21
79865 45,114.00 11/01
79866 32,649.51 11/01
79867 12,283.00 11/15
79869 * 2,350.65 11/03
79870 773.38 11/02
79871 15.60 11/07
79872 100.00 11/17
79873 50.00 11/02
79874 300.00 11/01
79875 100.00 11/01
79876 100.00 11/14
79878 * 724.53 11/09
79879 1,062.54 11/01
79880 870.13 11/01
79881 1,254.95 11/01
79884 * 1,982.57 11/02
79885 1,946.23 11/03
79886 500.00 11/16
79887 1,521.45 11/03
79888 101.84 11/09
79889 32.00 11/03
79890 109.00 11/08
79893 * 93.71 11/03
79896 * 5,262.06 11/02
79897 356.80 11/01
79898 120.98 11/07
79899 225.13 11/14
79900 1,000.00 11/14
79901 172.38 11/01
79902 731.45 11/02
79903 1,695.00 11/09
79904 5,000.00 11/03
79905 662.24 11/02
79906 198.96 11/02
79908 * 127.40 11/07
79909 2,775.00 11/04
79910 220.00 11/14
79911 773.50 11/01
79913 * 100.00 11/30
79914 529.03 11/01
79915 100.00 11/07
79916 2,162.88 11/02
79917 60.07 11/01
79918 470.23 11/02
79919 365.69 11/01
79920 50.01 11/02
79921 9,215.25 11/01
79922 97.31 11/09
79923 392.72 11/09
79924 95.10 11/08
79925 92.98 11/07
79926 105.66 11/14
79927 4,876.30 11/10
79928 199.50 11/10
79929 19,480.61 11/14
79930 10,503.12 11/17
79931 44,843.29 11/15
79932 16,500.00 11/14
79933 11,714.00 11/14
79934 76,164.50 11/14
79935 50.00 11/28
79936 2,934.60 11/07
79937 100.00 11/25
79938 832.56 11/15
79939 349.42 11/07
79940 156.00 11/14
79941 301.54 11/15
79942 3,322.95 11/07
79944 * 5,508.00 11/09
79945 56.00 11/14
79946 78.48 11/14
79947 100.00 11/22
79948 1,848.36 11/14
79949 385.27 11/09
79950 539.00 11/07
79951 707.32 11/07
79952 2,656.21 11/10
79955 * 56.37 11/14
79956 382.22 11/10
79959 * 1,315.46 11/08
79960 300.00 11/08
79961 1,586.98 11/16
79962 20.28 11/15
79963 260.95 11/14
79965 * 2,822.95 11/14
79966 529.69 11/15
79967 678.07 11/15
79968 365.69 11/14
79969 17,855.30 11/15
79971 * 13,145.00 11/14
79972 11,131.24 11/14
79973 3,675.00 11/21
79974 708.65 11/15
79975 1,974.27 11/18
79976 163.37 11/16
79977 464.29 11/21
79978 635.52 11/14
79980 * 9,480.47 11/14
79982 * 78.00 11/14
79983 2,500.00 11/29
79984 41.02 11/18
79986 * 427.80 11/22
79987 707.06 11/16
79989 * 287.37 11/14
79990 63.70 11/15
79991 1,935.00 11/17
79992 470.23 11/15
79993 5,857.46 11/14
79996 * 650.15 11/28
79997 119.30 11/23
79998 50.36 11/21
79999 9,700.37 11/22
80000 33.47 11/23
80001 1,457.91 11/23
80002 16,061.49 11/29
80003 10,945.30 11/23
80004 22,307.40 11/28
80005 16,625.00 11/29
80006 42,822.81 11/29
80007 53,739.55 11/23
80008 829.00 11/21
80009 161.70 11/22
80010 735.68 11/28
80012 * 407.00 11/21
80013 28.17 11/28
80014 1,055.05 11/28
80020 * 407.92 11/22
80023 * 100.00 11/18
80024 1,819.06 11/28
80025 810.57 11/18
Sheet Seq = 0019609
Sheet 00007 of 00008
XXXXXXXXXX
XXXXXXXX
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
Account number: 4159281427 November 1, 2022 - November 30, 2022 Page 8 of 8 Prior account number: 145398000
Checks paid (continued)
Number Amount Date Number Amount Date Number Amount Date 80026 344.93 11/22
80029 * 54.63 11/25
80030 5,658.38 11/23
80032 * 5,100.00 11/23
80034 * 403.50 11/21
80035 1,800.00 11/22
80036 2,356.00 11/21
80037 27.00 11/28
80038 1,875.00 11/28
80039 10.94 11/23
80041 * 2,745.00 11/30
80042 387.00 11/28
80043 240.75 11/22
80044 568.52 11/23
80045 487.91 11/28
80047 * 66.58 11/23
80050 * 3,121.50 11/28
80053 * 6,035.00 11/28
80054 1,204.00 11/28
80055 232.22 11/30
80057 * 5,853.35 11/30
80058 378.16 11/28
80060 * 120.53 11/29
80067 * 475.78 11/28
$1,091,790.27 Total checks paid
* Gap in check sequence.
$3,911,413.70 Total debits
Daily ledger balance summary
Date Balance Date Balance Date Balance
10/31 54,263.00
11/01 60,611.00
11/02 248,704.00
11/03 75,728.00
11/04 50,000.00
11/07 114,294.00
11/08 80,592.00
11/09 99,606.00
11/10 98,426.00
11/14 74,017.00
11/15 54,878.00
11/16 83,792.00
11/17 50,693.00
11/18 50,000.00
11/21 95,611.00
11/22 59,027.00
11/23 61,020.00
11/25 50,000.00
11/28 53,866.00
11/29 53,229.00
11/30 52,108.00
Average daily ledger balance $74,090.60
The United States Postal Service (USPS) continues to adapt to the global impact of the labor market and supply chain issues. As a result, there could be a change to when you receive mail from Wells Fargo, and when we receive mail from you.
The USPS now advises a delivery time of five business days for First Class mail. Items such as deposit adjustment notices, returned items, lockbox items, and other documents delivered by mail are subject to the new delivery standard.
If you have questions, speak to your banker about what electronic delivery options are available for your account or service.
Sheet Seq = 0019610
Sheet 00008 of 00008
XXXXXXXXX
XXXXXXXX
Commercial Checking Acct Public Funds
Account number: 4121929244 November 1, 2022 - November 30, 2022 Page 1 of 3 ©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
(182)
Questions?
Call your Customer Service Officer or Client Services
1-800-AT WELLS (1-800-289-3557)
5:00 AM TO 6:00 PM Pacific Time Monday - Friday
Online: wellsfargo.com
Write: Wells Fargo Bank, N.A. (182)
PO Box 63020
San Francisco, CA 94163
CITY OF BELL
BCHA
6330 PINE AVE
BELL CA 90201-1221
Account summary
Commercial Checking Acct Public Funds
Account number Beginning balance Total credits Total debits Ending balance 4121929244 $0.00 $293,143.44 -$293,143.44 $0.00
Credits
Electronic deposits/bank credits
Effective
date
Posted
date Amount
Transaction detail
11/01 389.00 121108250 Ccddeposit 221101 xxxxx0548 Bell Community Housing 11/02 1,874.27 ZBA Balance Account Transfer From 4159281427 11/03 28,492.79 Desktop Check Deposit
11/07 31,878.33 Desktop Check Deposit
11/07 36,325.63 Desktop Check Deposit
11/08 8,324.41 ZBA Balance Account Transfer From 4159281427 11/09 53,930.41 Desktop Check Deposit
11/10 50,942.09 Desktop Check Deposit
11/14 9,481.94 ZBA Balance Account Transfer From 4159281427 11/15 4,370.02 Desktop Check Deposit
11/15 7,108.29 ZBA Balance Account Transfer From 4159281427 11/16 3,627.54 Desktop Check Deposit
11/16 26,615.94 ZBA Balance Account Transfer From 4159281427 11/17 5.59 Desktop Check Deposit
11/18 11,074.19 ZBA Balance Account Transfer From 4159281427 11/21 1,000.00 Desktop Check Deposit
11/21 3,893.20 ZBA Balance Account Transfer From 4159281427 11/22 3,690.73 Desktop Check Deposit
11/23 732.81 ZBA Balance Account Transfer From 4159281427 11/28 9,230.26 ZBA Balance Account Transfer From 4159281427 11/29 156.00 ZBA Balance Account Transfer From 4159281427 $293,143.44 Total electronic deposits/bank credits
$293,143.44 Total credits
Sheet Seq = 0016155
Sheet 00001 of 00003
XXXXXXXXX
XXXXXXXXX
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
Account number: 4121929244 November 1, 2022 - November 30, 2022 Page 2 of 3 Debits
Electronic debits/bank debits
Effective
date
Posted
date Amount
Transaction detail
11/01 294.95 ZBA Balance Account Transfer to 4159281427 11/03 28,161.79 ZBA Balance Account Transfer to 4159281427 11/07 56,875.25 ZBA Balance Account Transfer to 4159281427 11/09 53,930.41 ZBA Balance Account Transfer to 4159281427 11/10 34,829.88 ZBA Balance Account Transfer to 4159281427 11/17 5.59 ZBA Balance Account Transfer to 4159281427
11/22 2,807.42 ZBA Balance Account Transfer to 4159281427 $176,905.29 Total electronic debits/bank debits
Checks paid
Number Amount Date Number Amount Date Number Amount Date 8076 5,480.80 11/14
8077 328.00 11/14
8078 331.00 11/03
8079 11,398.79 11/15
8080 15,808.86 11/16
8081 1,603.19 11/07
8082 86.99 11/01
8083 61.88 11/02
8084 7.06 11/01
8085 1,812.39 11/02
8087 * 15,479.35 11/10
8088 7,093.19 11/08
8089 185.50 11/10
8090 1,837.55 11/07
8091 4,382.83 11/07
8092 1,093.84 11/08
8093 5,591.26 11/16
8094 3,168.00 11/07
8095 337.14 11/07
8096 90.18 11/10
8097 357.18 11/10
8098 137.38 11/08
8099 543.48 11/16
8100 6,574.19 11/18
8101 498.08 11/14
8102 79.52 11/15
8103 7.06 11/14
8104 330.00 11/21
8105 8,299.88 11/16
8106 3,168.00 11/14
8107 186.13 11/22
8108 67.70 11/28
8110 * 732.81 11/23
8111 9,162.56 11/28
8112 480.46 11/22
8113 4,563.20 11/21
8114 216.72 11/22
8115 4,500.00 11/18
8119 * 156.00 11/29
$116,238.15 Total checks paid
* Gap in check sequence.
$293,143.44 Total debits
Daily ledger balance summary
Date Balance Date Balance Date Balance
10/31 0.00
11/01 0.00
11/02 0.00
11/03 0.00
11/07 0.00
11/08 0.00
11/09 0.00
11/10 0.00
11/14 0.00
11/15 0.00
11/16 0.00
11/17 0.00
11/18 0.00
11/21 0.00
11/22 0.00
11/23 0.00
11/28 0.00
11/29 0.00
Average daily ledger balance $0.00
Sheet Seq = 0016156
Sheet 00002 of 00003
XXXXXXXXX
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
Account number: 4121929244 November 1, 2022 - November 30, 2022 Page 3 of 3 The United States Postal Service (USPS) continues to adapt to the global impact of the labor market and supply chain issues. As a result, there could be a change to when you receive mail from Wells Fargo, and when we receive mail from you.
The USPS now advises a delivery time of five business days for First Class mail. Items such as deposit adjustment notices, returned items, lockbox items, and other documents delivered by mail are subject to the new delivery standard.
If you have questions, speak to your banker about what electronic delivery options are available for your account or service.
Sheet Seq = 0016157
Sheet 00003 of 00003
XXXXXXXXX
Choice IV-Public Funds {NIB}
Account number: 4159281401 November 1, 2022 - November 30, 2022 Page 1 of 3 Prior account number: 145098007
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
(182)
Questions?
Call your Customer Service Officer or Client Services
1-800-AT WELLS (1-800-289-3557)
5:00 AM TO 6:00 PM Pacific Time Monday - Friday
Online: wellsfargo.com
Write: Wells Fargo Bank, N.A. (182)
PO Box 63020
San Francisco, CA 94163
CITY OF BELL
PAYROLL ACCOUNT
ATTN CITY TREASURER
6330 PINE AVE
BELL CA 90201-1221
Account summary
Choice IV-Public Funds {NIB}
Account number Beginning balance Total credits Total debits Ending balance 4159281401 $0.00 $674,103.79 -$674,103.79 $0.00
Credits
Electronic deposits/bank credits
Effective
date
Posted
date Amount
Transaction detail
11/01 435.88 ZBA Balance Account Transfer From 4159281427 11/02 402.83 ZBA Balance Account Transfer From 4159281427 11/03 1,005.62 ZBA Balance Account Transfer From 4159281427 11/04 277.18 ZBA Balance Account Transfer From 4159281427 11/07 1,480.65 ZBA Balance Account Transfer From 4159281427 11/09 235,956.80 ZBA Balance Account Transfer From 4159281427 11/10 83,637.73 ZBA Balance Account Transfer From 4159281427 11/14 13,042.17 ZBA Balance Account Transfer From 4159281427 11/15 619.24 ZBA Balance Account Transfer From 4159281427 11/16 556.11 ZBA Balance Account Transfer From 4159281427 11/22 239,447.75 ZBA Balance Account Transfer From 4159281427 11/23 593.49 ZBA Balance Account Transfer From 4159281427 11/25 93,555.11 ZBA Balance Account Transfer From 4159281427 11/28 2,558.15 ZBA Balance Account Transfer From 4159281427 11/29 535.08 ZBA Balance Account Transfer From 4159281427 $674,103.79 Total electronic deposits/bank credits
$674,103.79 Total credits
Sheet Seq = 0019600
Sheet 00001 of 00003
XXXXXXXXX
XXXXXXXX
XXXXXXXXX
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
Account number: 4159281401 November 1, 2022 - November 30, 2022 Page 2 of 3 Prior account number: 145098007
Debits
Electronic debits/bank debits
Effective
date
Posted
date Amount
Transaction detail
11/09 235,956.80 ACH Prep Origintn - City of Bell Pay - File 1956000677 Coid 1956000677 11/10 14,178.89 < Business to Business ACH Debit - Employment Devel EDD Eftpmt 80097165 Txp*80097165*01102*221111*T*000*T*1417889*T*14178
11/10 69,458.84 < Business to Business ACH Debit - IRS Usataxpymt 111022 270271430436857 City of Bell
11/14 7,598.51 < Business to Business ACH Debit - Voya NAT Trst182 Spnsr P/R 221110 664486 0001 City of Bell
11/22 239,447.75 ACH Prep Origintn - City of Bell Pay - File 1956000677 Coid 1956000677 11/23 593.49 WT Fed#01481 Jpmorgan Chase Ban /Ftr/Bnf=NEW York Life Insurance Srf# Gw00000054839654 Trn#221123112615 Rfb# 2751
11/25 7,598.51 < Business to Business ACH Debit - Voya NAT Trst182 Spnsr P/R 221123 664486 0001 City of Bell
11/25 15,198.87 < Business to Business ACH Debit - Employment Devel EDD Eftpmt 80097165 Txp*80097165*01102*221125*T*000*T*1519887*T*15198
11/25 69,938.73 < Business to Business ACH Debit - IRS Usataxpymt 112522 270272955585241 City of Bell
$659,970.39 Total electronic debits/bank debits
< Business to Business ACH: If this is a business account, this transaction has a return time frame of one business day from post date. This time frame does not apply to consumer accounts.
Checks paid
Number Amount Date Number Amount Date Number Amount Date 40791 95.81 11/07
40799 * 288.37 11/07
40804 * 718.19 11/03
40805 666.60 11/07
40806 277.18 11/04
40807 287.43 11/03
40809 * 429.87 11/07
40813 * 435.88 11/01
40814 402.83 11/02
40815 480.13 11/14
40816 764.88 11/14
40818 * 556.11 11/16
40819 459.93 11/14
40820 622.60 11/14
40821 619.24 11/15
40822 495.99 11/14
40823 480.98 11/14
40824 402.83 11/14
40825 622.23 11/14
40826 577.16 11/14
40827 536.93 11/14
40830 * 351.72 11/28
40831 483.99 11/28
40832 535.08 11/29
40833 511.03 11/25
40834 559.12 11/28
40835 307.97 11/25
40836 613.22 11/28
40837 550.10 11/28
$14,133.40 Total checks paid
* Gap in check sequence.
$674,103.79 Total debits
Daily ledger balance summary
Date Balance Date Balance Date Balance
10/31 0.00
11/01 0.00
11/02 0.00
11/03 0.00
11/04 0.00
11/07 0.00
11/09 0.00
11/10 0.00
11/14 0.00
11/15 0.00
11/16 0.00
11/22 0.00
Sheet Seq = 0019601
Sheet 00002 of 00003
XXXXXXXXX
XXXXXXXX
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
Account number: 4159281401 November 1, 2022 - November 30, 2022 Page 3 of 3 Prior account number: 145098007
Daily ledger balance summary (continued)
Date Balance Date Balance Date Balance
11/23 0.00
11/25 0.00
11/28 0.00 11/29 0.00
Average daily ledger balance $0.00
The United States Postal Service (USPS) continues to adapt to the global impact of the labor market and supply chain issues. As a result, there could be a change to when you receive mail from Wells Fargo, and when we receive mail from you.
The USPS now advises a delivery time of five business days for First Class mail. Items such as deposit adjustment notices, returned items, lockbox items, and other documents delivered by mail are subject to the new delivery standard.
If you have questions, speak to your banker about what electronic delivery options are available for your account or service.
Sheet Seq = 0019602
Sheet 00003 of 00003
XXXXXXXXX
XXXXXXXXX
Choice IV-Public Funds {NIB}
Account number: 4159804517 November 1, 2022 - November 30, 2022 Page 1 of 3 Prior account number: 145701262
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
(182)
Questions?
Call your Customer Service Officer or Client Services
1-800-AT WELLS (1-800-289-3557)
5:00 AM TO 6:00 PM Pacific Time Monday - Friday
Online: wellsfargo.com
Write: Wells Fargo Bank, N.A. (182)
PO Box 63020
San Francisco, CA 94163
CITY OF BELL
WORKERS COMPENSATION
ATTN CITY TREASURER
6330 PINE AVE
BELL CA 90201-1221
Account summary
Choice IV-Public Funds {NIB}
Account number Beginning balance Total credits Total debits Ending balance 4159804517 $58,475.66 $24,158.13 -$17,168.74 $65,465.05 Credits
Deposits
Effective
date
Posted
date Amount
Transaction detail
11/04 11/07 421.47 Reversal of Check Posted 11-04-22 Reposted 11-07-22 as Serial 0000016440 Our Ref: 11-04-22 00000000
11/18 11/21 130.66 Reversal of Check Posted 11-18-22 Refer to Maker Our Ref: 11-18-22 00000000 $552.13 Total deposits
Electronic deposits/bank credits
Effective
date
Posted
date Amount
Transaction detail
11/02 8,798.43 WT Seq453560 City of Bell /Org=City of Bell Srf# Gb00000054401367 Trn#221102453560 Rfb# 2746
11/07 4,569.32 WT Seq456350 City of Bell /Org=City of Bell Srf# Gb00000054504506 Trn#221107456350 Rfb# 2747
11/15 3,488.45 WT Seq455913 City of Bell /Org=City of Bell Srf# Gb00000054660818 Trn#221115455913 Rfb# 2748
11/21 4,843.40 WT Seq453375 City of Bell /Org=City of Bell Srf# Gb00000054777256 Trn#221121453375 Rfb# 2750
11/29 1,906.40 WT Seq454622 City of Bell /Org=City of Bell Srf# Gb00000054917103 Trn#221129454622 Rfb# 2752
$23,606.00 Total electronic deposits/bank credits
$24,158.13 Total credits
Sheet Seq = 0012536
Sheet 00001 of 00003
XXXXXXXXX
XXXXXXXX
XXXXXXXXX
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
Account number: 4159804517 November 1, 2022 - November 30, 2022 Page 2 of 3 Prior account number: 145701262
Debits
Checks paid
Number Amount Date Number Amount Date Number Amount Date 16311 422.60 11/08
16337 * 422.60 11/08
16373 * 184.50 11/03
16403 * 1,101.83 11/09
16407 * 422.60 11/14
16416 * 75.63 11/14
16417 580.00 11/10
16418 254.66 11/01
16420 * 289.36 11/01
16424 * 79.32 11/01
16425 73.80 11/04
16426 660.00 11/07
16427 19.48 11/02
16428 168.84 11/14
16429 168.84 11/14
16430 71.82 11/03
16431 580.00 11/07
16432 148.67 11/07
16433 168.84 11/07
16434 168.84 11/07
16435 423.10 11/07
16436 254.29 11/14
16437 393.24 11/14
16438 200.90 11/07
16439 260.54 11/07
16440 421.47 11/07
16441 88.47 11/04
16441 421.47 11/04
16442 189.63 11/18
16443 29.23 11/07
16444 65.76 11/08
16445 168.84 11/10
16446 32.49 11/16
16447 16.11 11/16
16448 422.60 11/14
16449 172.98 11/15
16451 * 945.00 11/14
16452 65.50 11/09
16453 163.57 11/16
16454 33.52 11/10
16456 * 254.66 11/15
16457 132.00 11/14
16459 * 130.66 11/18
16460 131.25 11/14
16461 126.69 11/30
16462 113.78 11/15
16463 605.00 11/30
16464 268.71 11/17
16465 209.22 11/17
16466 200.90 11/21
16467 156.50 11/21
16468 169.99 11/21
16469 300.97 11/21
16470 90.00 11/30
16471 126.64 11/21
16472 418.44 11/21
16474 * 377.32 11/23
16475 132.86 11/22
16476 163.68 11/22
16477 262.00 11/18
16478 182.60 11/18
16479 345.00 11/23
16480 13.10 11/21
16481 422.60 11/28
16482 172.98 11/28
16483 416.75 11/28
16484 59.41 11/23
16486 * 254.66 11/29
16490 * 99.43 11/30
$17,168.74 Total checks paid
* Gap in check sequence.
$17,168.74 Total debits
Daily ledger balance summary
Date Balance Date Balance Date Balance
10/31 58,475.66
11/01 57,852.32
11/02 66,631.27
11/03 66,374.95
11/04 65,791.21
11/07 67,720.41
11/08 66,809.45
11/09 65,642.12
11/10 64,859.76
11/14 61,745.47
11/15 64,692.50
11/16 64,480.33
11/17 64,002.40
11/18 63,237.51
11/21 66,825.03
11/22 66,528.49
11/23 65,746.76
11/28 64,734.43
11/29 66,386.17
11/30 65,465.05
Average daily ledger balance $65,051.37
The United States Postal Service (USPS) continues to adapt to the global impact of the labor market and supply chain issues. As a result, there could be a change to when you receive mail from Wells Fargo, and when we receive mail from you.
Sheet Seq = 0012537
Sheet 00002 of 00003
XXXXXXXXX
XXXXXXXX
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
Account number: 4159804517 November 1, 2022 - November 30, 2022 Page 3 of 3 Prior account number: 145701262
The USPS now advises a delivery time of five business days for First Class mail. Items such as deposit adjustment notices, returned items, lockbox items, and other documents delivered by mail are subject to the new delivery standard.
If you have questions, speak to your banker about what electronic delivery options are available for your account or service.
Sheet Seq = 0012538
Sheet 00003 of 00003
XXXXXXXXX
XXXXXXXX
12/5/22, 10:38 AM LAIF Regular Monthly Statement
https://laifms.treasurer.ca.gov/RegularStatement.aspx 1/1 Local Agency Investment Fund
P.O. Box 942809
Sacramento, CA 94209-0001
(916) 653-3001
December 05, 2022
LAIF Home
PMIA Average Monthly
Yields
CITY OF BELL
CITY TREASURER
6330 PINE A VENUE
BELL, CA 90201
Account Number: 98-19-059
November 2022 Statement
Tran Type Definitions
Effective
Date
Transaction
Date
Tran
Type Confirm
Number
Web
Confirm
Number Authorized Caller Amount
11/17/2022 11/16/2022 RW 1718123 1678457 ELISA GRATIL -800,000.00 Account Summary
Total Deposit: 0.00 Beginning Balance: 19,148,560.07
Total Withdrawal: -800,000.00 Ending Balance: 18,348,560.07 XXXXXX
November 2.007
October 1.772
September 1.513
0.00003699565555327
0.980760962
LAIF Earnings Ratio(2):
LAIF Fair Value Factor(1):
PMIA Daily(1): 1.63%
1.35LAIF Apportionment Rate(2):
PMIA Quarter to Date(1): 1.29%
304PMIA Average Life(1):
Treasuries
66.35%
Agencies
19.46%
Certificates of
Deposit/Bank Notes
6.63%
Time
Deposits
2.58%
Commercial
Paper
4.54%
Corporate
Bonds
0.26%
Loans
0.18%
Notes: The apportionment rate includes interest earned on the CalPERS Supplemental Pension Payment pursuant to Government Code 20825 (c)(1) and interest earned on the Wildfire Fund loan pursuant to Public Utility Code 3288 (a).
Source:
(1) State of California, Office of the Treasurer
(2) State of Calfiornia, Office of the Controller
PMIA Average Monthly
Effective Yields(1)
PMIA/LAIF Performance Report
as of 12/14/22
Daily rates are now available here. View PMIA Daily Rates Quarterly Performance
Quarter Ended 09/30/22
Chart does not include $3,542,000.00 in mortgages, which equates to 0.002%. Percentages may not total 100% due to rounding.
Pooled Money Investment Account
Monthly Portfolio Composition (1)
11/30/22
$203.7 billion
12/5/22, 10:37 AM LAIF Regular Monthly Statement
https://laifms.treasurer.ca.gov/RegularStatement.aspx 1/1 Local Agency Investment Fund
P.O. Box 942809
Sacramento, CA 94209-0001
(916) 653-3001
December 05, 2022
LAIF Home
PMIA Average Monthly
Yields
S/A CITY OF BELL FOR CITY OF BELL
COMMUNITY REDEVELOPMENT AGENCY
FINANCE DIRECTOR
6330 PINE A VENUE
BELL, CA 90201
Account Number: 65-19-011
November 2022 Statement
Tran Type Definitions
Account Summary
Total Deposit: 0.00 Beginning Balance: 578,816.45
Total Withdrawal: 0.00 Ending Balance: 578,816.45
XXXXXX
Choice IV-Public Funds {NIB}
Account number: 4159281450 November 1, 2022 - November 30, 2022 Page 1 of 1 Prior account number: 145998008
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
(182)
Questions?
Call your Customer Service Officer or Client Services
1-800-AT WELLS (1-800-289-3557)
5:00 AM TO 6:00 PM Pacific Time Monday - Friday
Online: wellsfargo.com
Write: Wells Fargo Bank, N.A. (182)
PO Box 63020
San Francisco, CA 94163
CITY OF BELL
SUCCESSOR AGENCY
ATTN CITY TREASURER
6330 PINE AVE
BELL CA 90201-1221
Account summary
Choice IV-Public Funds {NIB}
Account number Beginning balance Total credits Total debits Ending balance 4159281450 $277,812.86 $0.00 -$12,870.51 $264,942.35
Debits
Checks paid
Number Amount Date Number Amount Date Number Amount Date 6033 120.00 11/04
6034 7,140.00 11/04
6035 6.56 11/02
6036 0.75 11/01
6037 0.75 11/14
6038 1,271.20 11/21
6039 4,331.25 11/23
$12,870.51 Total checks paid
$12,870.51 Total debits
Daily ledger balance summary
Date Balance Date Balance Date Balance
10/31 277,812.86
11/01 277,812.11
11/02 277,805.55
11/04 270,545.55
11/14 270,544.80
11/21 269,273.60
11/23 264,942.35
Average daily ledger balance $269,692.61
The United States Postal Service (USPS) continues to adapt to the global impact of the labor market and supply chain issues. As a result, there could be a change to when you receive mail from Wells Fargo, and when we receive mail from you.
The USPS now advises a delivery time of five business days for First Class mail. Items such as deposit adjustment notices, returned items, lockbox items, and other documents delivered by mail are subject to the new delivery standard.
If you have questions, speak to your banker about what electronic delivery options are available for your account or service.
Sheet Seq = 0019611
Sheet 00001 of 00001
XXXXXXXXX
XXXXXXXX
XXXXXXXXX
MONTHLY ACCOUNT STATEMENT
City of Bell - Account #10531
NOVEMBER 1, 2022 THROUGH NOVEMBER 30, 2022
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 [email protected]
Custodian
US Bank
Alexander Bazan
(503) 402-5305
XXXXX
ACCOUNT SUMMARY
Beg. Values
as of 10/31/22
End Values
as of 11/30/22
Market Value 10,306,269 10,396,197
Accrued Interest 43,267 37,347
Total Market Value 10,349,536 10,433,544
Income Earned 13,362 14,066
Cont/WD -1,086
Par 10,785,884 10,824,598
Book Value 10,808,530 10,824,284
Cost Value 10,886,596 10,903,295
TOP ISSUERS
Government of United States 35.2%
Federal Home Loan Mortgage Corp 10.6%
Federal Home Loan Bank 8.8%
Federal National Mortgage Assoc 7.1%
Federal Farm Credit Bank 2.6%
Intl Bank Recon and Development 2.4%
John Deere ABS 1.8%
Bank of New York 1.7%
Total 70.3%
PORTFOLIO CHARACTERISTICS
Average Modified Duration 1.67
Average Coupon 1.80%
Average Purchase YTM 1.60%
Average Market YTM 4.59%
Average S&P/Moody Rating AA/Aa1
Average Final Maturity 1.93 yrs
Average Life 1.76 yrs
CREDIT QUALITY (S&P)
MATURITY DISTRIBUTION
SECTOR ALLOCATION
Portfolio Summary
As of November 30, 2022
City of Bell
Account #10531
PERFORMANCE REVIEW
Annualized
TOTAL RATE OF RETURN 1M 3M YTD 1YR 2YRS 3YRS 5YRS 10YRS 6/30/2017 City of Bell 0.83% -0.24% -3.10% -3.25% -1.76% -0.04% 0.98% N/A 0.92% ICE BofA 1-3 Yr US Treasury & Agency Index 0.63% -0.65% -3.85% -4.09% -2.19% -0.41% 0.73% N/A 0.67% Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 1 XXXXX
Category Standard Comment
Treasury Issues No limitation; Full faith and credit of the U.S. are pledged for the payment of principal and interest Complies Federal Agencies 25% max per Agency/GSE issuer; Federal agencies or U.S. government-sponsored enterprises Complies Supranationals
"AA" rating category or higher by a Nationally Recognized Statistical Rating Organization ("NRSRO"); 30% maximum; 10% max per issuer; USD denominated senior unsecured unsubordinated obligations; Issued or unconditionally guaranteed by International Bank for Reconstruction and Development (IBRD), International Finance Corporation (IFC), or Inter-American Development Bank (IADB)
Complies
Municipal Issues
"A" rating category or better by a NRSRO; 30% maximum; 5% max per issuer; Obligations of the City, State of California, local agency within the state of California, and any of the other 49 states in addition to California; Including bonds payable solely out of the revenues from a revenue-producing property owned, controlled, or operated by a state or by a department, board, agency, or authority of any of the other 49 states, in addition to California.
Complies
Time Deposit (TD)/Certificate of Deposit
(CD)
20% maximum (combination of FDIC and Collateralized TDs/ CDs); Amount per institution is limited to maximum covered under FDIC; Non-negotiable Certificates of Deposit in excess of insured amounts which are fully collateralized with securities in accordance with California law.
Complies
Negotiable Certificates of Deposit (NCD)
No rating required if amount of the NCD is covered by FDIC insured limit; If above FDIC insured limit, requires "A-1" or better short-term rating by a NRSRO; or "A" long-term rating category or higher by a NRSRO; 30% maximum (combined with CDARS); 5% max per issuer
Complies
Banker’s Acceptances "A-1" or better short term rating by a NRSRO; or "A" or better long-term debt rating category by a NRSRO; 40% maximum; 5% max per issuer ; 180 days max maturity Complies
Commercial Paper
"A-1" rated or better by a NRSRO; "A" rated or better long-term debt issuer by a NRSRO; 25% maximum; 5% max per issuer; 10% max of the outstanding commercial paper of any single issuer; 270 days max maturity; Issuer is a corporation organized and operating within the U.S. with asset > $ 500 million Complies
Corporate Medium Term Notes "A" rating category or higher by a NRSRO; 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 Asset-Backed, Mortgage-Backed,
Mortgage Pass-Through Securities,
Collateralized Mortgage Obligations
"AA" rating category or better by a NRSRO; 20% maximum (combined ABS/MBS/CMO); 5% max per single Asset-backed or Commercial Mortgage security issuer; There is no issuer limitation on any Mortgage security where the issuer is US Treasury or Federal Agency/GSE; From Issuers not defined in sections 3 (U.S. Treasuries) and 4 (Federal Agencies) of the Authorized Investments section of the policy.
Complies
Mutual Funds and Money Market Mutual
Funds
Highest rating or AAA rated by two NRSROs or SEC registered with AUM >$500 million; 10% max per one Mutual Fund; 20% maximum in Money Market Mutual Funds; 20% maximum combined Mutual Funds and Money Market Mutual Funds Complies Local Agency Investment Fund (LAIF) Max amount permitted by LAIF; Not used by Investment Adviser Complies Local Government Investment Pools Other LGIPS permitted Complies Repurchase Agreements 1 year max maturity; 102% collateralized; Not used by Investment Adviser Complies Prohibited
Inverse floaters; Ranges notes, Mortgage derived Interest-only strips; Zero interest accrual securities if held to maturity; Purchasing or selling securities on margin; Reverse Repurchase Agreements; Securities Lending; Foreign currency denominated securities
Complies
City of Bell
As of November 30, 2022
Assets managed by Chandler Asset Management are in full compliance with state law and the Client's investment policy.
Statement of Compliance
Max Callables 20% max of callable securities (does not include "make whole call") Complies Max per Issuer 5% of portfolio in securities issued by any single issuer, unless otherwise specified in the policy Complies Modified duration +/- 20% of market benchmark duration Complies Maximum maturity 5 years Complies
BOOK VALUE RECONCILIATION
BEGINNING BOOK VALUE $10,808,529.70
Acquisition
+ Security Purchases $269,297.85
+ Money Market Fund Purchases $69,678.77
+ Money Market Contributions $0.00
+ Security Contributions $0.00
+ Security Transfers $0.00
Total Acquisitions $338,976.62
Dispositions
- Security Sales $222,011.72
- Money Market Fund Sales $47,730.58
- MMF Withdrawals $1,085.89
- Security Withdrawals $0.00
- Security Transfers $0.00
- Other Dispositions $0.00
- Maturites $0.00
- Calls $0.00
- Principal Paydowns $47,148.70
Total Dispositions $317,976.89
Amortization/Accretion
+/- Net Accretion ($2,099.48)
($2,099.48)
Gain/Loss on Dispositions
+/- Realized Gain/Loss ($3,146.26)
($3,146.26)
ENDING BOOK VALUE $10,824,283.69
CASH TRANSACTION SUMMARY
BEGINNING BALANCE $9,242.63
Acquisition
Contributions $0.00
Security Sale Proceeds $222,011.72
Accrued Interest Received $76.14
Interest Received $22,421.11
Dividend Received $108.96
Principal on Maturities $0.00
Interest on Maturities $0.00
Calls/Redemption (Principal) $0.00
Interest from Calls/Redemption $0.00
Principal Paydown $47,148.70
Total Acquisitions $291,766.63
Dispositions
Withdrawals $1,085.89
Security Purchase $269,297.85
Accrued Interest Paid $520.59
Total Dispositions $270,904.33
ENDING BOOK VALUE $30,104.93
Reconciliation Summary
As of November 30, 2022
City of Bell
Account #10531
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 3 XXXXX
Holdings Report
As of November 30, 2022
City of Bell
Account #10531
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
92348AAA3 Verizon Owner Trust 2019-C A1A
1.94% Due 4/22/2024
3,696.98 10/01/2019
1.95%
3,696.70
3,696.89
99.73 4.60%
3,686.98
2.19 0.04%
(9.91)
NR / AAA
AAA
1.39 0.10
89232HAC9 Toyota Auto Receivable Own 2020-A A3
1.66% Due 5/15/2024
35,661.07 07/06/2020
0.70%
36,446.73
35,957.58
99.34 4.78%
35,427.03
26.31 0.34%
(530.55)
Aaa / AAA
NR
1.46 0.21
65479JAD5 Nissan Auto Receivables Owner 2019-C
A3
1.93% Due 7/15/2024
12,110.11 10/16/2019
1.94%
12,109.46
12,109.89
99.58 4.69%
12,059.64
10.39 0.12%
(50.25)
Aaa / AAA
NR
1.62 0.15
47789KAC7 John Deere Owner Trust 2020-A A3
1.1% Due 8/15/2024
13,696.40 03/04/2020
1.11%
13,695.57
13,696.08
98.96 4.86%
13,554.64
6.70 0.13%
(141.44)
Aaa / NR
AAA
1.71 0.27
43813KAC6 Honda Auto Receivables Trust 2020-3
A3
0.37% Due 10/18/2024
30,334.06 09/22/2020
0.38%
30,329.60
30,332.69
97.60 5.39%
29,605.59
4.05 0.28%
(727.10)
NR / AAA
AAA
1.88 0.48
47787NAC3 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
10,383.15 07/14/2020
0.52%
10,381.57
10,382.64
98.16 5.44%
10,191.71
2.35 0.10%
(190.93)
Aaa / NR
AAA
1.96 0.37
58769KAD6 Mercedes-Benz Auto Lease Trust 2021-
B A3
0.4% Due 11/15/2024
50,000.00 06/22/2021
0.40%
49,996.23
49,998.34
96.60 5.54%
48,301.26
8.89 0.46%
(1,697.08)
NR / AAA
AAA
1.96 0.66
09690AAC7 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due 12/26/2024
35,000.00 09/08/2021
0.34%
34,996.39
34,998.31
97.25 5.50%
34,037.43
1.93 0.33%
(960.88)
Aaa / NR
AAA
2.07 0.53
89236XAC0 Toyota Auto Receivables 2020-D A3
0.35% Due 1/15/2025
23,701.66 10/06/2020
0.36%
23,697.24
23,699.45
97.97 5.27%
23,219.89
3.69 0.22%
(479.56)
NR / AAA
AAA
2.13 0.41
92290BAA9 Verizon Owner Trust 2020-B A
0.47% Due 2/20/2025
52,103.08 08/04/2020
0.48%
52,092.14
52,097.71
98.16 5.52%
51,145.65
7.48 0.49%
(952.06)
Aaa / NR
AAA
2.23 0.36
05601XAC3 BMW Vehicle Lease Trust 2022-1 A3
1.1% Due 3/25/2025
35,000.00 01/11/2022
1.11%
34,994.77
34,996.85
96.27 5.45%
33,692.79
6.42 0.32%
(1,304.06)
NR / AAA
AAA
2.32 0.87
43813GAC5 Honda Auto Receivables Trust 2021-1
A3
0.27% Due 4/21/2025
18,861.43 02/17/2021
0.27%
18,861.09
18,861.29
96.74 5.91%
18,246.56
1.41 0.17%
(614.73)
Aaa / NR
AAA
2.39 0.58
44891RAC4 Hyundai Auto Receivables Trust 2020-C
A3
0.38% Due 5/15/2025
37,913.41 10/20/2020
0.39%
37,904.67
37,910.21
97.14 5.81%
36,829.31
6.40 0.35%
(1,080.90)
NR / AAA
AAA
2.46 0.52
89240BAC2 Toyota Auto Receivables Owners 2021-
A A3
0.26% Due 5/15/2025
55,332.60 02/02/2021
0.27%
55,322.32
55,328.33
97.24 4.90%
53,802.96
6.39 0.52%
(1,525.37)
Aaa / NR
AAA
2.46 0.59
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 4 XXXXX
Holdings Report
As of November 30, 2022
City of Bell
Account #10531
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
36266FAC3 GM Financial Auto Lease Trust 2022-2
A3
3.42% Due 6/20/2025
55,000.00 05/03/2022
3.45%
54,994.26
54,995.72
97.50 5.37%
53,624.79
57.48 0.51%
(1,370.93)
NR / AAA
AAA
2.56 1.31
47788UAC6 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
37,236.15 03/02/2021
0.37%
37,228.99
37,232.43
95.98 5.77%
35,739.25
5.96 0.34%
(1,493.18)
Aaa / NR
AAA
2.79 0.74
43815GAC3 Honda Auto Receivables Trust 2021-4
A3
0.88% Due 1/21/2026
35,000.00 11/16/2021
0.89%
34,992.62
34,994.94
94.54 5.19%
33,088.38
8.56 0.32%
(1,906.56)
Aaa / NR
AAA
3.15 1.28
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,997.49
94.57 5.29%
42,554.60
10.40 0.41%
(2,442.89)
Aaa / NR
AAA
3.29 1.15
44935FAD6 Hyundai Auto Receivables Trust 2021-C
A3
0.74% Due 5/15/2026
25,000.00 11/09/2021
0.75%
24,994.42
24,996.25
93.96 5.60%
23,489.23
8.22 0.23%
(1,507.02)
NR / AAA
AAA
3.46 1.26
43815BAC4 Honda Auto Receivables Trust 2022-1
A3
1.88% Due 5/15/2026
55,000.00 02/15/2022
1.89%
54,991.73
54,993.70
94.74 5.16%
52,105.50
45.96 0.50%
(2,888.20)
Aaa / AAA
NR
3.46 1.63
43815PAC3 Honda Auto Receivables 2022-2 A3
3.73% Due 7/20/2026
35,000.00 08/15/2022
3.76%
34,997.91
34,998.09
97.56 5.00%
34,145.40
47.14 0.33%
(852.69)
NR / AAA
AAA
3.64 1.98
362554AC1 GM Financial Securitized Term 2021-4
A3
0.68% Due 9/16/2026
25,000.00 10/13/2021
0.68%
24,999.36
24,999.57
93.87 5.87%
23,468.30
7.08 0.22%
(1,531.27)
Aaa / AAA
NR
3.80 1.20
47787JAC2 John Deere Owner Trust 2022-A A3
2.32% Due 9/16/2026
45,000.00 03/10/2022
2.34%
44,990.05
44,992.07
95.38 5.32%
42,920.91
46.40 0.41%
(2,071.16)
Aaa / NR
AAA
3.80 1.56
380146AC4 GM Financial Auto Receivables 2022-1
A3
1.26% Due 11/16/2026
25,000.00 01/11/2022
1.27%
24,997.83
24,998.40
95.00 4.94%
23,750.44
13.13 0.23%
(1,247.96)
NR / AAA
AAA
3.96 1.38
47800AAC4 John Deere Owner Trust 2022-B A3
3.74% Due 2/16/2027
45,000.00 07/12/2022
3.77%
44,995.70
44,996.14
97.59 5.14%
43,916.79
74.80 0.42%
(1,079.35)
Aaa / NR
AAA
4.22 1.77
36265WAD5 GM Financial Securitized Auto 2022-3
A3
3.64% Due 4/16/2027
30,000.00 07/06/2022
3.67%
29,999.79
29,999.82
97.27 5.14%
29,180.80
45.50 0.28%
(819.02)
Aaa / NR
AAA
4.38 1.87
Total ABS 871,030.10 1.35%
871,703.13
871,260.88 5.31%
841,785.83
465.23
8.07%
(29,475.05)
Aaa / AAA
AAA
2.82 0.99
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 5 XXXX
Holdings Report
As of November 30, 2022
City of Bell
Account #10531
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
3133ELNW0 FFCB Note
1.45% Due 2/21/2023
200,000.00 02/19/2020
1.44%
200,040.96
200,003.06
99.30 4.60%
198,590.00
805.56
1.91%
(1,413.06)
Aaa / AA+
AAA
0.23 0.22
3130ADRG9 FHLB Note
2.75% Due 3/10/2023
225,000.00 01/16/2019
2.71%
225,355.50
225,023.26
99.56 4.32%
224,014.50
1,392.19
2.16%
(1,008.76)
Aaa / AA+
NR
0.27 0.27
3137EAER6 FHLMC Note
0.375% Due 5/5/2023
200,000.00 05/05/2020
0.39%
199,916.00
199,988.09
98.21 4.62%
196,415.20
54.17 1.88%
(3,572.89)
Aaa / AA+
AAA
0.43 0.42
3135G04Q3 FNMA Note
0.25% Due 5/22/2023
160,000.00 05/20/2020
0.35%
159,518.40
159,924.35
97.91 4.72%
156,660.16
10.00 1.50%
(3,264.19)
Aaa / AA+
AAA
0.47 0.47
3135G05G4 FNMA Note
0.25% Due 7/10/2023
165,000.00 07/08/2020
0.32%
164,645.25
164,928.40
97.32 4.75%
160,578.83
161.56
1.54%
(4,349.57)
Aaa / AA+
AAA
0.61 0.60
3135G0U43 FNMA Note
2.875% Due 9/12/2023
225,000.00 09/25/2019
1.63%
235,737.00
227,114.75
98.51 4.83%
221,647.95
1,419.53
2.14%
(5,466.80)
Aaa / AA+
AAA
0.78 0.76
3137EAEY1 FHLMC Note
0.125% Due 10/16/2023
150,000.00 10/14/2020
0.25%
149,440.50
149,837.00
95.98 4.85%
143,974.50
23.44 1.38%
(5,862.50)
Aaa / AA+
AAA
0.88 0.86
3137EAEZ8 FHLMC Note
0.25% Due 11/6/2023
220,000.00 11/03/2020
0.28%
219,802.00
219,938.58
95.78 4.93%
210,721.94
38.19 2.02%
(9,216.64)
Aaa / AA+
AAA
0.93 0.91
3130A0F70 FHLB Note
3.375% Due 12/8/2023
225,000.00 08/19/2019
1.52%
242,329.50
229,103.48
98.56 4.84%
221,753.48
3,649.22
2.16%
(7,350.00)
Aaa / AA+
AAA
1.02 0.97
3130AB3H7 FHLB Note
2.375% Due 3/8/2024
225,000.00 06/14/2019
1.95%
229,304.25
226,154.62
97.04 4.80%
218,329.43
1,232.03
2.10%
(7,825.19)
Aaa / AA+
NR
1.27 1.22
3130A1XJ2 FHLB Note
2.875% Due 6/14/2024
250,000.00 03/24/2020
0.99%
269,372.50
257,047.97
97.28 4.73%
243,197.50
3,334.20
2.36%
(13,850.47)
Aaa / AA+
NR
1.54 1.46
3133ENKS8 FFCB Note
1.125% Due 1/6/2025
80,000.00 01/06/2022
1.20%
79,820.00
79,873.46
93.34 4.48%
74,669.60
362.50
0.72%
(5,203.86)
Aaa / AA+
AAA
2.10 2.03
3135G06G3 FNMA Note
0.5% Due 11/7/2025
225,000.00 11/18/2020
0.52%
224,768.25
224,863.05
89.87 4.20%
202,210.88
75.00 1.94%
(22,652.17)
Aaa / AA+
AAA
2.94 2.86
Total Agency 2,550,000.00 1.10%
2,600,050.11
2,563,800.07 4.67%
2,472,763.97
12,557.59
23.82%
(91,036.10)
Aaa / AA+
AAA
1.01 0.97
CMO
3137B3NX2 FHLMC K031 A2
3.3% Due 4/25/2023
188,960.46 03/12/2019
2.70%
192,776.57
189,272.87
99.23 4.96%
187,504.43
103.93
1.80%
(1,768.44)
Aaa / NR
NR
0.40 0.34
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 6 XXXXX
Holdings Report
As of November 30, 2022
City of Bell
Account #10531
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
CMO
3137B4GY6 FHLMC K032 A2
3.31% Due 5/25/2023
170,000.00 07/23/2019
2.21%
176,726.95
170,841.47
99.07 5.06%
168,416.70
93.78 1.62%
(2,424.77)
NR / NR
AAA
0.48 0.41
3137B5JM6 FHLMC K034 A2
3.531% Due 7/25/2023
199,502.34 08/28/2018
3.03%
203,733.97
200,060.57
98.93 5.15%
197,360.62
587.04
1.90%
(2,699.95)
NR / NR
AAA
0.65 0.53
Total CMO 558,462.80 2.67%
573,237.49
560,174.91 5.06%
553,281.75
784.75
5.31%
(6,893.16)
Aaa / NR
AAA
0.51 0.43
CORPORATE
89236TEL5 Toyota Motor Credit Corp Note
2.7% Due 1/11/2023
130,000.00 01/25/2019
3.22%
127,519.60
129,929.52
99.78 4.61%
129,711.53
1,365.00
1.26%
(217.99)
A1 / A+
A+
0.12 0.11
037833DE7 Apple Inc Callable Note Cont
12/13/2022
2.4% Due 1/13/2023
130,000.00 11/26/2018
3.50%
124,549.10
129,844.47
99.73 4.65%
129,645.36
1,196.00
1.25%
(199.11)
Aaa / AA+
NR
0.12 0.12
747525AR4 Qualcomm Inc Callable Note Cont
12/30/2022
2.6% Due 1/30/2023
135,000.00 02/11/2020
1.75%
138,195.45
135,088.17
99.72 4.28%
134,617.28
1,179.75
1.30%
(470.89)
A2 / A
NR
0.17 0.17
06406FAD5 Bank of NY Mellon Corp Callable Note
Cont 6/16/2023
2.2% Due 8/16/2023
125,000.00 04/11/2019
2.90%
121,436.25
124,419.54
98.21 4.79%
122,758.75
802.08
1.18%
(1,660.79)
A1 / A
AA-
0.71 0.69
24422EVN6 John Deere Capital Corp Note
0.45% Due 1/17/2024
95,000.00 03/01/2021
0.47%
94,932.55
94,973.51
95.46 4.62%
90,683.49
159.13
0.87%
(4,290.02)
A2 / A
A
1.13 1.10
594918BX1 Microsoft Callable Note Cont 12/6/2023
2.875% Due 2/6/2024
125,000.00 03/05/2020
1.06%
133,325.00
127,253.29
98.20 4.45%
122,745.88
1,148.00
1.19%
(4,507.41)
Aaa / AAA
AAA
1.19 1.14
89114QCB2 Toronto Dominion Bank Note
3.25% Due 3/11/2024
130,000.00 07/16/2019
2.49%
134,290.00
131,177.35
97.94 4.92%
127,326.68
938.89
1.23%
(3,850.67)
A1 / A
AA-
1.28 1.23
808513BN4 Charles Schwab Corp Callable Note
Cont 2/18/2024
0.75% Due 3/18/2024
160,000.00 Various
0.58%
160,733.00
160,326.84
94.97 4.78%
151,957.76
243.33
1.46%
(8,369.08)
A2 / A
A
1.30 1.26
023135BW5 Amazon.com Inc Note
0.45% Due 5/12/2024
85,000.00 05/10/2021
0.50%
84,875.90
84,940.21
94.39 4.49%
80,234.48
20.19 0.77%
(4,705.73)
A1 / AA
AA-
1.45 1.41
14913R2L0 Caterpillar Financial Service Note
0.45% Due 5/17/2024
135,000.00 05/10/2021
0.50%
134,819.10
134,912.03
94.06 4.70%
126,974.79
23.63 1.22%
(7,937.24)
A2 / A
A
1.46 1.43
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 7 XXXXX
Holdings Report
As of November 30, 2022
City of Bell
Account #10531
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
79466LAG9 Salesforce.com Inc Callable Note Cont
7/15/2022
0.625% Due 7/15/2024
20,000.00 06/29/2021
0.64%
19,989.80
19,994.51
93.81 4.63%
18,761.00
47.22 0.18%
(1,233.51)
A2 / A+
NR
1.62 1.58
91159HHX1 US Bancorp Callable Note Cont
6/28/2024
2.4% Due 7/30/2024
150,000.00 03/25/2021
0.65%
158,425.50
154,081.43
96.51 4.60%
144,763.65
1,210.00
1.40%
(9,317.78)
A2 / A+
A+
1.67 1.59
69371RR40 Paccar Financial Corp Note
0.5% Due 8/9/2024
50,000.00 08/03/2021
0.52%
49,973.00
49,984.80
93.08 4.81%
46,541.45
77.78 0.45%
(3,443.35)
A1 / A+
NR
1.69 1.64
78015K7C2 Royal Bank of Canada Note
2.25% Due 11/1/2024
135,000.00 09/22/2020
0.69%
143,487.45
138,969.11
95.22 4.89%
128,550.38
253.13
1.23%
(10,418.73)
A1 / A
AA-
1.92 1.84
69371RR57 Paccar Financial Corp Note
0.9% Due 11/8/2024
90,000.00 11/02/2021
0.90%
89,994.60
89,996.51
92.90 4.78%
83,610.09
51.75 0.80%
(6,386.42)
A1 / A+
NR
1.94 1.88
46647PAH9 JP Morgan Chase & Co Callable Note 2X
3/1/2024
3.22% Due 3/1/2025
140,000.00 08/19/2020
0.91%
151,212.60
143,969.68
97.36 5.42%
136,304.00
1,127.00
1.32%
(7,665.68)
A1 / A-
AA-
2.25 1.20
06406RBC0 Bank of NY Mellon Corp Callable Note
Cont 3/25/2025
3.35% Due 4/25/2025
60,000.00 04/19/2022
3.35%
59,991.60
59,993.28
96.91 4.72%
58,146.00
201.00
0.56%
(1,847.28)
A1 / A
AA-
2.40 2.27
63743HFE7 National Rural Utilities Note
3.45% Due 6/15/2025
35,000.00 04/27/2022
3.46%
34,990.55
34,992.30
96.41 4.97%
33,743.36
694.31
0.33%
(1,248.94)
A2 / A-
A
2.54 2.35
931142EW9 Wal-Mart Stores Note
3.9% Due 9/9/2025
30,000.00 09/06/2022
3.92%
29,979.00
29,980.59
98.76 4.38%
29,626.62
266.50
0.29%
(353.97)
Aa2 / AA
AA
2.78 2.58
437076CR1 Home Depot Callable Note Cont
8/15/2025
4% Due 9/15/2025
40,000.00 09/12/2022
4.01%
39,985.60
39,986.56
99.16 4.32%
39,664.44
320.00
0.38%
(322.12)
A2 / A
A
2.79 2.59
91324PEN8 United Health Group Inc Note
5.15% Due 10/15/2025
35,000.00 10/25/2022
5.15%
34,996.85
34,996.95
101.59
4.55%
35,556.57
165.23
0.34%
559.62
A3 / A+
A
2.88 2.64
857477BR3 State Street Bank Callable Note Cont
2/6/2025
1.746% Due 2/6/2026
35,000.00 02/02/2022
1.75%
35,000.00
35,000.00
93.09 5.13%
32,580.45
195.21
0.31%
(2,419.55)
A1 / A
AA-
3.19 2.08
61747YET8 Morgan Stanley Callable Note Cont
7/17/2025
4.679% Due 7/17/2026
60,000.00 07/18/2022
4.68%
60,000.00
60,000.00
98.86 5.14%
59,317.38
1,021.58
0.58%
(682.62)
A1 / A-
A+
3.63 2.40
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 8 XXXXX
Holdings Report
As of November 30, 2022
City of Bell
Account #10531
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
931142ER0 Wal-Mart Stores Callable Note Cont
08/17/2026
1.05% Due 9/17/2026
25,000.00 09/08/2021
1.09%
24,952.75
24,964.14
88.81 4.27%
22,201.53
53.96 0.21%
(2,762.61)
Aa2 / AA
AA
3.80 3.64
665859AW4 Northern Trust Company Callable Note
Cont 4/10/2027
4% Due 5/10/2027
150,000.00 09/28/2022
4.75%
145,396.50
145,566.09
97.92 4.52%
146,884.20
350.00
1.41%
1,318.11
A2 / A+
A+
4.44 4.01
931142EX7 Wal-Mart Stores Callable Note Cont
09/09/2027
3.95% Due 9/9/2027
100,000.00 09/27/2022
4.70%
96,706.00
96,820.91
99.37 4.10%
99,369.90
899.72
0.96%
2,548.99
Aa2 / AA
AA
4.78 4.27
Total Corporate 2,405,000.00 2.04%
2,429,757.75
2,412,161.79 4.69%
2,332,277.02
14,010.39
22.49%
(79,884.77)
A1 / A+
AA-
1.79 1.59
MONEY MARKET FUND
31846V203 First American Govt Obligation Fund
Class Y
30,104.93 Various
3.35%
30,104.93
30,104.93
1.00 3.35%
30,104.93
0.00 0.29%
0.00 Aaa / AAA
AAA
0.00 0.00
Total Money Market Fund 30,104.93 3.35%
30,104.93
30,104.93 3.35%
30,104.93
0.00 0.29%
0.00 Aaa / AAA
AAA
0.00 0.00
SUPRANATIONAL
459058JM6 Intl. Bank Recon & Development Note
0.25% Due 11/24/2023
105,000.00 11/17/2020
0.32%
104,774.25
104,926.19
95.79 4.68%
100,581.60
5.10 0.96%
(4,344.59)
Aaa / AAA
AAA
0.98 0.96
459058GQ0 Intl. Bank Recon & Development Note
2.5% Due 3/19/2024
150,000.00 01/26/2021
0.26%
160,491.00
154,339.21
97.32 4.64%
145,977.00
750.00
1.41%
(8,362.21)
Aaa / AAA
AAA
1.30 1.25
4581X0DZ8 Inter-American Dev Bank Note
0.5% Due 9/23/2024
170,000.00 09/15/2021
0.52%
169,874.20
169,924.01
93.12 4.49%
158,309.10
160.56
1.52%
(11,614.91)
Aaa / AAA
NR
1.82 1.77
45950KCR9 International Finance Corp Note
1.375% Due 10/16/2024
100,000.00 07/12/2021
0.54%
102,690.00
101,548.45
94.39 4.52%
94,391.80
171.88
0.91%
(7,156.65)
Aaa / AAA
NR
1.88 1.82
Total Supranational 525,000.00 0.41%
537,829.45
530,737.86 4.58%
499,259.50
1,087.54
4.80%
(31,478.36)
Aaa / AAA
AAA
1.51 1.46
US TREASURY
912828ZU7 US Treasury Note
0.25% Due 6/15/2023
220,000.00 06/24/2021
0.25%
220,000.00
220,000.00
97.68 4.65%
214,886.76
253.96
2.06%
(5,113.24)
Aaa / AA+
AAA
0.54 0.53
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 9 XXXXX
Holdings Report
As of November 30, 2022
City of Bell
Account #10531
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
912828T26 US Treasury Note
1.375% Due 9/30/2023
225,000.00 08/15/2019
1.46%
224,252.93
224,849.69
97.25 4.79%
218,803.73
526.96
2.10%
(6,045.96)
Aaa / AA+
AAA
0.83 0.81
912828V80 US Treasury Note
2.25% Due 1/31/2024
225,000.00 10/29/2019
1.67%
230,370.12
226,472.12
97.31 4.64%
218,944.35
1,692.09
2.11%
(7,527.77)
Aaa / AA+
AAA
1.17 1.13
912828WJ5 US Treasury Note
2.5% Due 5/15/2024
200,000.00 12/12/2019
1.74%
206,460.94
202,124.31
97.04 4.62%
194,086.00
220.99
1.86%
(8,038.31)
Aaa / AA+
AAA
1.46 1.41
91282CCG4 US Treasury Note
0.25% Due 6/15/2024
250,000.00 06/17/2021
0.43%
248,681.64
249,322.12
93.63 4.58%
234,062.50
288.59
2.25%
(15,259.62)
Aaa / AA+
AAA
1.54 1.50
91282CCT6 US Treasury Note
0.375% Due 8/15/2024
250,000.00 08/25/2021
0.45%
249,443.36
249,680.38
93.29 4.50%
233,222.75
275.14
2.24%
(16,457.63)
Aaa / AA+
AAA
1.71 1.67
91282CDH1 US Treasury Note
0.75% Due 11/15/2024
225,000.00 11/18/2021
0.83%
224,437.50
224,631.70
93.23 4.39%
209,768.63
74.59 2.01%
(14,863.07)
Aaa / AA+
AAA
1.96 1.91
912828ZF0 US Treasury Note
0.5% Due 3/31/2025
125,000.00 03/25/2021
0.58%
124,609.38
124,772.78
91.88 4.19%
114,848.63
106.46
1.10%
(9,924.15)
Aaa / AA+
AAA
2.33 2.27
912828ZT0 US Treasury Note
0.25% Due 5/31/2025
250,000.00 02/25/2021
0.60%
246,337.89
247,852.19
90.73 4.19%
226,836.00
1.72 2.17%
(21,016.19)
Aaa / AA+
AAA
2.50 2.44
91282CAZ4 US Treasury Note
0.375% Due 11/30/2025
175,000.00 12/09/2020
0.41%
174,699.22
174,818.64
89.64 4.08%
156,864.23
1.80 1.50%
(17,954.41)
Aaa / AA+
AAA
3.00 2.93
9128286L9 US Treasury Note
2.25% Due 3/31/2026
275,000.00 Various
3.07%
268,007.23
267,748.29
94.55 4.01%
260,014.70
1,053.91
2.50%
(7,733.59)
Aaa / AA+
AAA
3.33 3.15
912828R36 US Treasury Note
1.625% Due 5/15/2026
265,000.00 Various
2.66%
256,468.75
255,708.53
92.30 4.03%
244,586.79
190.33
2.35%
(11,121.74)
Aaa / AA+
AAA
3.46 3.30
912828YG9 US Treasury Note
1.625% Due 9/30/2026
200,000.00 12/28/2021
1.24%
203,531.25
202,845.75
91.81 3.95%
183,617.20
553.57
1.77%
(19,228.55)
Aaa / AA+
AAA
3.84 3.64
912828U24 US Treasury Note
2% Due 11/15/2026
265,000.00 03/29/2022
2.56%
258,602.73
259,533.38
92.88 3.96%
246,129.09
234.25
2.36%
(13,404.29)
Aaa / AA+
AAA
3.96 3.74
91282CEF4 US Treasury Note
2.5% Due 3/31/2027
200,000.00 05/25/2022
2.73%
197,890.63
198,115.87
94.43 3.91%
188,867.20
851.65
1.82%
(9,248.67)
Aaa / AA+
AAA
4.33 4.03
912828X88 US Treasury Note
2.375% Due 5/15/2027
275,000.00 Various
2.97%
267,540.04
268,274.56
93.82 3.90%
258,016.55
288.67
2.48%
(10,258.01)
Aaa / AA+
AAA
4.46 4.16
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 10 XXXXX
Holdings Report
As of November 30, 2022
City of Bell
Account #10531
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
91282CFM8 US Treasury Note
4.125% Due 9/30/2027
260,000.00 10/26/2022
4.19%
259,278.91
259,292.94
101.22
3.85%
263,168.88
1,826.79
2.54%
3,875.94
Aaa / AA+
AAA
4.84 4.32
Total US Treasury 3,885,000.00 1.72%
3,860,612.52
3,856,043.25 4.24%
3,666,723.99
8,441.47
35.22%
(189,319.26)
Aaa / AA+
AAA
2.71 2.57
TOTAL PORTFOLIO 10,824,597.83 1.60%
10,903,295.38
10,824,283.69 4.59%
10,396,196.99
37,346.97
100.00%
(428,086.70)
Aa1 / AA
AAA
1.93 1.67
TOTAL MARKET VALUE PLUS ACCRUED 10,433,543.96
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 11 XXXXX
Transaction Ledger
As of November 30, 2022
City of Bell
Account #10531
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 11/01/2022 31846V203 1,518.75 First American Govt Obligation Fund Class Y
1.000 2.61% 1,518.75 0.00 1,518.75 0.00
Purchase 11/01/2022 31846V203 108.96 First American Govt Obligation Fund Class Y
1.000 2.61% 108.96 0.00 108.96 0.00
Purchase 11/05/2022 31846V203 375.00 First American Govt Obligation Fund Class Y
1.000 2.61% 375.00 0.00 375.00 0.00
Purchase 11/06/2022 31846V203 275.00 First American Govt Obligation Fund Class Y
1.000 2.61% 275.00 0.00 275.00 0.00
Purchase 11/07/2022 31846V203 562.50 First American Govt Obligation Fund Class Y
1.000 2.61% 562.50 0.00 562.50 0.00
Purchase 11/08/2022 31846V203 405.00 First American Govt Obligation Fund Class Y
1.000 2.61% 405.00 0.00 405.00 0.00
Purchase 11/10/2022 31846V203 3,000.00 First American Govt Obligation Fund Class Y
1.000 2.61% 3,000.00 0.00 3,000.00 0.00
Purchase 11/12/2022 31846V203 191.25 First American Govt Obligation Fund Class Y
1.000 2.61% 191.25 0.00 191.25 0.00
Purchase 11/15/2022 31846V203 12,203.13 First American Govt Obligation Fund Class Y
1.000 2.61% 12,203.13 0.00 12,203.13 0.00
Purchase 11/15/2022 31846V203 1,292.32 First American Govt Obligation Fund Class Y
1.000 2.61% 1,292.32 0.00 1,292.32 0.00
Purchase 11/15/2022 31846V203 2,775.85 First American Govt Obligation Fund Class Y
1.000 2.61% 2,775.85 0.00 2,775.85 0.00
Purchase 11/15/2022 31846V203 3,714.74 First American Govt Obligation Fund Class Y
1.000 2.61% 3,714.74 0.00 3,714.74 0.00
Purchase 11/15/2022 31846V203 2,729.18 First American Govt Obligation Fund Class Y
1.000 2.61% 2,729.18 0.00 2,729.18 0.00
Purchase 11/15/2022 31846V203 6,621.36 First American Govt Obligation Fund Class Y
1.000 2.61% 6,621.36 0.00 6,621.36 0.00
Purchase 11/15/2022 31846V203 2,346.44 First American Govt Obligation Fund Class Y
1.000 2.61% 2,346.44 0.00 2,346.44 0.00
Purchase 11/15/2022 31846V203 3,907.46 First American Govt Obligation Fund Class Y
1.000 2.61% 3,907.46 0.00 3,907.46 0.00
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 12 XXXXX
Transaction Ledger
As of November 30, 2022
City of Bell
Account #10531
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 11/15/2022 31846V203 19.50 First American Govt Obligation Fund Class Y
1.000 2.61% 19.50 0.00 19.50 0.00
Purchase 11/15/2022 31846V203 87.00 First American Govt Obligation Fund Class Y
1.000 2.61% 87.00 0.00 87.00 0.00
Purchase 11/15/2022 31846V203 15.42 First American Govt Obligation Fund Class Y
1.000 2.61% 15.42 0.00 15.42 0.00
Purchase 11/15/2022 31846V203 86.17 First American Govt Obligation Fund Class Y
1.000 2.61% 86.17 0.00 86.17 0.00
Purchase 11/15/2022 31846V203 140.25 First American Govt Obligation Fund Class Y
1.000 2.61% 140.25 0.00 140.25 0.00
Purchase 11/15/2022 31846V203 16.67 First American Govt Obligation Fund Class Y
1.000 2.61% 16.67 0.00 16.67 0.00
Purchase 11/15/2022 31846V203 1,982.53 First American Govt Obligation Fund Class Y
1.000 2.61% 1,982.53 0.00 1,982.53 0.00
Purchase 11/15/2022 31846V203 2,877.20 First American Govt Obligation Fund Class Y
1.000 2.61% 2,877.20 0.00 2,877.20 0.00
Purchase 11/16/2022 31846V203 26.25 First American Govt Obligation Fund Class Y
1.000 2.61% 26.25 0.00 26.25 0.00
Purchase 11/16/2022 31846V203 91.00 First American Govt Obligation Fund Class Y
1.000 2.61% 91.00 0.00 91.00 0.00
Purchase 11/16/2022 31846V203 14.17 First American Govt Obligation Fund Class Y
1.000 2.61% 14.17 0.00 14.17 0.00
Purchase 11/17/2022 31846V203 303.75 First American Govt Obligation Fund Class Y
1.000 2.61% 303.75 0.00 303.75 0.00
Purchase 11/18/2022 31846V203 108.79 First American Govt Obligation Fund Class Y
1.000 2.61% 108.79 0.00 108.79 0.00
Purchase 11/18/2022 31846V203 2,896.47 First American Govt Obligation Fund Class Y
1.000 2.61% 2,896.47 0.00 2,896.47 0.00
Purchase 11/21/2022 31846V203 156.75 First American Govt Obligation Fund Class Y
1.000 2.61% 156.75 0.00 156.75 0.00
Purchase 11/21/2022 31846V203 25.67 First American Govt Obligation Fund Class Y
1.000 2.61% 25.67 0.00 25.67 0.00
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 13 XXXXX
Transaction Ledger
As of November 30, 2022
City of Bell
Account #10531
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 11/21/2022 31846V203 1,398.33 First American Govt Obligation Fund Class Y
1.000 2.61% 1,398.33 0.00 1,398.33 0.00
Purchase 11/21/2022 31846V203 8,853.21 First American Govt Obligation Fund Class Y
1.000 2.61% 8,853.21 0.00 8,853.21 0.00
Purchase 11/21/2022 31846V203 2,304.28 First American Govt Obligation Fund Class Y
1.000 2.61% 2,304.28 0.00 2,304.28 0.00
Purchase 11/22/2022 31846V203 200.00 First American Govt Obligation Fund Class Y
1.000 2.61% 200.00 0.00 200.00 0.00
Purchase 11/22/2022 9128286L9 145,000.00 US Treasury Note
2.25% Due 3/31/2026
93.973 4.19% 136,260.35 475.03 136,735.38 0.00
Purchase 11/22/2022 912828R36 145,000.00 US Treasury Note
1.625% Due 5/15/2026
91.750 4.20% 133,037.50 45.56 133,083.06 0.00
Purchase 11/24/2022 31846V203 131.25 First American Govt Obligation Fund Class Y
1.000 2.61% 131.25 0.00 131.25 0.00
Purchase 11/25/2022 31846V203 3,758.05 First American Govt Obligation Fund Class Y
1.000 2.61% 3,758.05 0.00 3,758.05 0.00
Purchase 11/25/2022 31846V203 1,007.86 First American Govt Obligation Fund Class Y
1.000 2.61% 1,007.86 0.00 1,007.86 0.00
Purchase 11/25/2022 31846V203 32.08 First American Govt Obligation Fund Class Y
1.000 2.61% 32.08 0.00 32.08 0.00
Purchase 11/25/2022 31846V203 9.63 First American Govt Obligation Fund Class Y
1.000 2.61% 9.63 0.00 9.63 0.00
Purchase 11/25/2022 31846V203 468.92 First American Govt Obligation Fund Class Y
1.000 2.61% 468.92 0.00 468.92 0.00
Purchase 11/30/2022 31846V203 640.63 First American Govt Obligation Fund Class Y
1.000 3.35% 640.63 0.00 640.63 0.00
Subtotal 359,678.77 338,976.62 520.59 339,497.21 0.00
TOTAL ACQUISITIONS 359,678.77 338,976.62 520.59 339,497.21 0.00 Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 14 XXXXX
Transaction Ledger
As of November 30, 2022
City of Bell
Account #10531
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
DISPOSITIONS
Sale 11/22/2022 31846V203 47,730.58 First American Govt Obligation Fund Class Y
1.000 2.61% 47,730.58 0.00 47,730.58 0.00
Sale 11/22/2022 912828VB3 225,000.00 US Treasury Note
1.75% Due 5/15/2023
98.672 1.60% 222,011.72 76.14 222,087.86 -3,146.26
Subtotal 272,730.58 269,742.30 76.14 269,818.44 -3,146.26 Paydown 11/15/2022 43815BAC4 0.00 Honda Auto Receivables Trust 2022-1 A3
1.88% Due 5/15/2026
100.000 0.00 86.17 86.17 0.00
Paydown 11/15/2022 43815NAC8 1,979.59 Honda Auto Receivables Trust 2019-3 A3
1.78% Due 8/15/2023
100.000 1,979.59 2.94 1,982.53 0.00
Paydown 11/15/2022 44891RAC4 2,864.29 Hyundai Auto Receivables Trust 2020-C A3
0.38% Due 5/15/2025
100.000 2,864.29 12.91 2,877.20 0.00
Paydown 11/15/2022 44935FAD6 0.00 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due 5/15/2026
100.000 0.00 15.42 15.42 0.00
Paydown 11/15/2022 47787JAC2 0.00 John Deere Owner Trust 2022-A A3
2.32% Due 9/16/2026
100.000 0.00 87.00 87.00 0.00
Paydown 11/15/2022 47787NAC3 1,287.36 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
100.000 1,287.36 4.96 1,292.32 0.00
Paydown 11/15/2022 47788UAC6 2,763.85 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
100.000 2,763.85 12.00 2,775.85 0.00
Paydown 11/15/2022 47789KAC7 3,698.79 John Deere Owner Trust 2020-A A3
1.1% Due 8/15/2024
100.000 3,698.79 15.95 3,714.74 0.00
Paydown 11/15/2022 47789QAC4 0.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
100.000 0.00 19.50 19.50 0.00
Paydown 11/15/2022 47800AAC4 0.00 John Deere Owner Trust 2022-B A3
3.74% Due 2/16/2027
100.000 0.00 140.25 140.25 0.00
Paydown 11/15/2022 58769KAD6 0.00 Mercedes-Benz Auto Lease Trust 2021- B A3
0.4% Due 11/15/2024
100.000 0.00 16.67 16.67 0.00
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 15 XXXXX
Transaction Ledger
As of November 30, 2022
City of Bell
Account #10531
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
DISPOSITIONS
Paydown 11/15/2022 65479JAD5 2,705.35 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
100.000 2,705.35 23.83 2,729.18 0.00
Paydown 11/15/2022 89232HAC9 6,562.95 Toyota Auto Receivable Own 2020-A A3
1.66% Due 5/15/2024
100.000 6,562.95 58.41 6,621.36 0.00
Paydown 11/15/2022 89236XAC0 2,338.84 Toyota Auto Receivables 2020-D A3
0.35% Due 1/15/2025
100.000 2,338.84 7.60 2,346.44 0.00
Paydown 11/15/2022 89240BAC2 3,894.63 Toyota Auto Receivables Owners 2021- A A3
0.26% Due 5/15/2025
100.000 3,894.63 12.83 3,907.46 0.00
Paydown 11/16/2022 362554AC1 0.00 GM Financial Securitized Term 2021-4 A3
0.68% Due 9/16/2026
100.000 0.00 14.17 14.17 0.00
Paydown 11/16/2022 36265WAD5 0.00 GM Financial Securitized Auto 2022-3 A3
3.64% Due 4/16/2027
100.000 0.00 91.00 91.00 0.00
Paydown 11/16/2022 380146AC4 0.00 GM Financial Auto Receivables 2022-1 A3
1.26% Due 11/16/2026
100.000 0.00 26.25 26.25 0.00
Paydown 11/18/2022 43813KAC6 2,886.23 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
100.000 2,886.23 10.24 2,896.47 0.00
Paydown 11/18/2022 43815PAC3 0.00 Honda Auto Receivables 2022-2 A3
3.73% Due 7/20/2026
100.000 0.00 108.79 108.79 0.00
Paydown 11/21/2022 36266FAC3 0.00 GM Financial Auto Lease Trust 2022-2 A3
3.42% Due 6/20/2025
100.000 0.00 156.75 156.75 0.00
Paydown 11/21/2022 43813GAC5 1,393.77 Honda Auto Receivables Trust 2021-1 A3
0.27% Due 4/21/2025
100.000 1,393.77 4.56 1,398.33 0.00
Paydown 11/21/2022 43815GAC3 0.00 Honda Auto Receivables Trust 2021-4 A3
0.88% Due 1/21/2026
100.000 0.00 25.67 25.67 0.00
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 16 XXXXX
Transaction Ledger
As of November 30, 2022
City of Bell
Account #10531
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
DISPOSITIONS
Paydown 11/21/2022 92290BAA9 8,829.34 Verizon Owner Trust 2020-B A
0.47% Due 2/20/2025
100.000 8,829.34 23.87 8,853.21 0.00
Paydown 11/21/2022 92348AAA3 2,294.59 Verizon Owner Trust 2019-C A1A
1.94% Due 4/22/2024
100.000 2,294.59 9.69 2,304.28 0.00
Paydown 11/25/2022 05601XAC3 0.00 BMW Vehicle Lease Trust 2022-1 A3
1.1% Due 3/25/2025
100.000 0.00 32.08 32.08 0.00
Paydown 11/25/2022 09690AAC7 0.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due 12/26/2024
100.000 0.00 9.63 9.63 0.00
Paydown 11/25/2022 3137B3NX2 3,229.53 FHLMC K031 A2Due 4/25/2023 100.000 3,229.53 528.52 3,758.05 0.00 Paydown 11/25/2022 3137B4GY6 0.00 FHLMC K032 A2Due 5/25/2023 100.000 0.00 468.92 468.92 0.00 Paydown 11/25/2022 3137B5JM6 419.59 FHLMC K034 A2
3.531% Due 7/25/2023
100.000 419.59 588.27 1,007.86 0.00
Subtotal 47,148.70 47,148.70 2,614.85 49,763.55 0.00
Security
Withdrawal
11/15/2022 31846V203 1,000.00 First American Govt Obligation Fund Class Y
1.000 1,000.00 0.00 1,000.00 0.00
Security
Withdrawal
11/28/2022 31846V203 85.89 First American Govt Obligation Fund Class Y
1.000 85.89 0.00 85.89 0.00
Subtotal 1,085.89 1,085.89 0.00 1,085.89 0.00
TOTAL DISPOSITIONS 320,965.17 317,976.89 2,690.99 320,667.88 -3,146.26
OTHER TRANSACTIONS
Interest 11/01/2022 78015K7C2 135,000.00 Royal Bank of Canada Note
2.25% Due 11/1/2024
0.000 1,518.75 0.00 1,518.75 0.00
Interest 11/05/2022 3137EAER6 200,000.00 FHLMC Note
0.375% Due 5/5/2023
0.000 375.00 0.00 375.00 0.00
Interest 11/06/2022 3137EAEZ8 220,000.00 FHLMC Note
0.25% Due 11/6/2023
0.000 275.00 0.00 275.00 0.00
Interest 11/07/2022 3135G06G3 225,000.00 FNMA Note
0.5% Due 11/7/2025
0.000 562.50 0.00 562.50 0.00
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 17 XXXXX
Transaction Ledger
As of November 30, 2022
City of Bell
Account #10531
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
OTHER TRANSACTIONS
Interest 11/08/2022 69371RR57 90,000.00 Paccar Financial Corp Note
0.9% Due 11/8/2024
0.000 405.00 0.00 405.00 0.00
Interest 11/10/2022 665859AW4 150,000.00 Northern Trust Company Callable Note Cont 4/10/2027
4% Due 5/10/2027
0.000 3,000.00 0.00 3,000.00 0.00
Interest 11/12/2022 023135BW5 85,000.00 Amazon.com Inc Note
0.45% Due 5/12/2024
0.000 191.25 0.00 191.25 0.00
Interest 11/15/2022 912828R36 120,000.00 US Treasury Note
1.625% Due 5/15/2026
0.000 975.00 0.00 975.00 0.00
Interest 11/15/2022 912828U24 265,000.00 US Treasury Note 2% Due 11/15/2026
0.000 2,650.00 0.00 2,650.00 0.00
Interest 11/15/2022 912828VB3 225,000.00 US Treasury Note
1.75% Due 5/15/2023
0.000 1,968.75 0.00 1,968.75 0.00
Interest 11/15/2022 912828WJ5 200,000.00 US Treasury Note
2.5% Due 5/15/2024
0.000 2,500.00 0.00 2,500.00 0.00
Interest 11/15/2022 912828X88 275,000.00 US Treasury Note
2.375% Due 5/15/2027
0.000 3,265.63 0.00 3,265.63 0.00
Interest 11/15/2022 91282CDH1 225,000.00 US Treasury Note
0.75% Due 11/15/2024
0.000 843.75 0.00 843.75 0.00
Interest 11/17/2022 14913R2L0 135,000.00 Caterpillar Financial Service Note
0.45% Due 5/17/2024
0.000 303.75 0.00 303.75 0.00
Interest 11/22/2022 3135G04Q3 160,000.00 FNMA Note
0.25% Due 5/22/2023
0.000 200.00 0.00 200.00 0.00
Interest 11/24/2022 459058JM6 105,000.00 Intl. Bank Recon & Development Note
0.25% Due 11/24/2023
0.000 131.25 0.00 131.25 0.00
Interest 11/30/2022 912828ZT0 250,000.00 US Treasury Note
0.25% Due 5/31/2025
0.000 312.50 0.00 312.50 0.00
Interest 11/30/2022 91282CAZ4 175,000.00 US Treasury Note
0.375% Due 11/30/2025
0.000 328.13 0.00 328.13 0.00
Subtotal 3,240,000.00 19,806.26 0.00 19,806.26 0.00
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 18 XXXXXX
Transaction Ledger
As of November 30, 2022
City of Bell
Account #10531
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
OTHER TRANSACTIONS
Dividend 11/01/2022 31846V203 10,761.38 First American Govt Obligation Fund Class Y
0.000 108.96 0.00 108.96 0.00
Subtotal 10,761.38 108.96 0.00 108.96 0.00
TOTAL OTHER TRANSACTIONS 3,250,761.38 19,915.22 0.00 19,915.22 0.00 Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 19 XXXXX
Income Earned
As of November 30, 2022
City of Bell
Account #10531
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
Note
0.45% Due 05/12/2024
05/10/2021
05/12/2021
85,000.00
84,936.82
0.00 0.00
84,940.21
179.56
191.25
20.19 31.88
3.39 0.00
3.39 35.27
35.27 037833DE7 Apple Inc
Callable Note Cont 12/13/2022
2.4% Due 01/13/2023
11/26/2018
11/28/2018
130,000.00
129,735.96
0.00 0.00
129,844.47
936.00
0.00 1,196.00
260.00
108.51
0.00 108.51
368.51
368.51
05601XAC3 BMW Vehicle Lease Trust
2022-1 A3
1.1% Due 03/25/2025
01/11/2022
01/19/2022
35,000.00
34,996.65
0.00 0.00
34,996.85
6.42 32.08
6.42 32.08
0.20 0.00
0.20 32.28
32.28 06406FAD5 Bank of NY Mellon Corp
Callable Note Cont 6/16/2023
2.2% Due 08/16/2023
04/11/2019
04/15/2019
125,000.00
124,352.05
0.00 0.00
124,419.54
572.92
0.00 802.08
229.16
67.49 0.00
67.49 296.65
296.65
06406RBC0 Bank of NY Mellon Corp
Callable Note Cont 3/25/2025
3.35% Due 04/25/2025
04/19/2022
04/26/2022
60,000.00
59,993.05
0.00 0.00
59,993.28
33.50 0.00
201.00
167.50
0.23 0.00
0.23 167.73
167.73
09690AAC7 BMW Vehicle Lease Trust
2021-2 A3
0.33% Due 12/26/2024
09/08/2021
09/15/2021
35,000.00
34,998.18
0.00 0.00
34,998.31
1.93 9.63
1.93 9.63
0.13 0.00
0.13 9.76
9.76 14913R2L0 Caterpillar Financial Service
Note
0.45% Due 05/17/2024
05/10/2021
05/17/2021
135,000.00
134,907.07
0.00 0.00
134,912.03
276.75
303.75
23.63 50.63
4.96 0.00
4.96 55.59
55.59 24422EVN6 John Deere Capital Corp
Note
0.45% Due 01/17/2024
03/01/2021
03/04/2021
95,000.00
94,971.58
0.00 0.00
94,973.51
123.50
0.00 159.13
35.63 1.93
0.00 1.93
37.56 37.56
3130A0F70 FHLB
Note
3.375% Due 12/08/2023
08/19/2019
08/20/2019
225,000.00
229,434.41
0.00 0.00
229,103.48
3,016.41
0.00 3,649.22
632.81
0.00 330.93
(330.93)
301.88
301.88
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 20 XXXXX
Income Earned
As of November 30, 2022
City of Bell
Account #10531
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
3130A1XJ2 FHLB
Note
2.875% Due 06/14/2024
03/24/2020
03/25/2020
250,000.00
257,424.87
0.00 0.00
257,047.97
2,735.24
0.00 3,334.20
598.96
0.00 376.90
(376.90)
222.06
222.06
3130AB3H7 FHLB
Note
2.375% Due 03/08/2024
06/14/2019
06/17/2019
225,000.00
226,229.43
0.00 0.00
226,154.62
786.72
0.00 1,232.03
445.31
0.00 74.81
(74.81)
370.50
370.50
3130ADRG9 FHLB
Note
2.75% Due 03/10/2023
01/16/2019
01/17/2019
225,000.00
225,030.31
0.00 0.00
225,023.26
876.56
0.00 1,392.19
515.63
0.00 7.05
(7.05)
508.58
508.58
3133ELNW0 FFCB
Note
1.45% Due 02/21/2023
02/19/2020
02/21/2020
200,000.00
200,004.19
0.00 0.00
200,003.06
563.89
0.00 805.56
241.67
0.00 1.13
(1.13)
240.54
240.54
3133ENKS8 FFCB
Note
1.125% Due 01/06/2025
01/06/2022
01/11/2022
80,000.00
79,868.51
0.00 0.00
79,873.46
287.50
0.00 362.50
75.00 4.95
0.00 4.95
79.95 79.95
3135G04Q3 FNMA
Note
0.25% Due 05/22/2023
05/20/2020
05/22/2020
160,000.00
159,911.16
0.00 0.00
159,924.35
176.67
200.00
10.00 33.33
13.19 0.00
13.19 46.52
46.52 3135G05G4 FNMA
Note
0.25% Due 07/10/2023
07/08/2020
07/10/2020
165,000.00
164,918.68
0.00 0.00
164,928.40
127.19
0.00 161.56
34.37 9.72
0.00 9.72
44.09 44.09
3135G06G3 FNMA
Note
0.5% Due 11/07/2025
11/18/2020
11/19/2020
225,000.00
224,859.21
0.00 0.00
224,863.05
543.75
562.50
75.00 93.75
3.84 0.00
3.84 97.59
97.59 3135G0U43 FNMA
Note
2.875% Due 09/12/2023
09/25/2019
09/26/2019
225,000.00
227,337.36
0.00 0.00
227,114.75
880.47
0.00 1,419.53
539.06
0.00 222.61
(222.61)
316.45
316.45
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 21 XXXXXX
Income Earned
As of November 30, 2022
City of Bell
Account #10531
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
3137B3NX2 FHLMC
K031 A2
3.3% Due 04/25/2023
03/12/2019
03/15/2019
188,960.46
192,586.53
0.00 3,229.53
189,272.87
105.70
528.52
103.93
526.75
0.00 84.13
(84.13)
442.62
442.62
3137B4GY6 FHLMC
K032 A2
3.31% Due 05/25/2023
07/23/2019
07/26/2019
170,000.00
170,985.72
0.00 0.00
170,841.47
93.78 468.92
93.78 468.92
0.00 144.25
(144.25)
324.67
324.67
3137B5JM6 FHLMC
K034 A2
3.531% Due 07/25/2023
08/28/2018
08/31/2018
199,502.34
200,552.44
0.00 419.59
200,060.57
588.27
588.27
587.04
587.04
0.00 72.28
(72.28)
514.76
514.76
3137EAER6 FHLMC
Note
0.375% Due 05/05/2023
05/05/2020
05/07/2020
200,000.00
199,985.78
0.00 0.00
199,988.09
366.67
375.00
54.17 62.50
2.31 0.00
2.31 64.81
64.81 3137EAEY1 FHLMC
Note
0.125% Due 10/16/2023
10/14/2020
10/16/2020
150,000.00
149,821.68
0.00 0.00
149,837.00
7.81 0.00
23.44 15.63
15.32 0.00
15.32 30.95
30.95 3137EAEZ8 FHLMC
Note
0.25% Due 11/06/2023
11/03/2020
11/05/2020
220,000.00
219,933.16
0.00 0.00
219,938.58
267.36
275.00
38.19 45.83
5.42 0.00
5.42 51.25
51.25 362554AC1 GM Financial Securitized Term
2021-4 A3
0.68% Due 09/16/2026
10/13/2021
10/21/2021
25,000.00
24,999.55
0.00 0.00
24,999.57
7.08 14.17
7.08 14.17
0.02 0.00
0.02 14.19
14.19 36265WAD5 GM Financial Securitized Auto
2022-3 A3
3.64% Due 04/16/2027
07/06/2022
07/13/2022
30,000.00
29,999.81
0.00 0.00
29,999.82
45.50 91.00
45.50 91.00
0.01 0.00
0.01 91.01
91.01 36266FAC3 GM Financial Auto Lease Trust
2022-2 A3
3.42% Due 06/20/2025
05/03/2022
05/11/2022
55,000.00
54,995.51
0.00 0.00
54,995.72
57.48 156.75
57.48 156.75
0.21 0.00
0.21 156.96
156.96
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 22 XXXXX
Income Earned
As of November 30, 2022
City of Bell
Account #10531
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
380146AC4 GM Financial Auto Receivables
2022-1 A3
1.26% Due 11/16/2026
01/11/2022
01/19/2022
25,000.00
24,998.34
0.00 0.00
24,998.40
13.13 26.25
13.13 26.25
0.06 0.00
0.06 26.31
26.31 437076CR1 Home Depot
Callable Note Cont 8/15/2025
4% Due 09/15/2025
09/12/2022
09/19/2022
40,000.00
39,986.17
0.00 0.00
39,986.56
186.67
0.00 320.00
133.33
0.39 0.00
0.39 133.72
133.72
43813GAC5 Honda Auto Receivables Trust
2021-1 A3
0.27% Due 04/21/2025
02/17/2021
02/24/2021
18,861.43
20,255.03
0.00 1,393.77
18,861.29
1.52 4.56
1.41 4.45
0.03 0.00
0.03 4.48
4.48 43813KAC6 Honda Auto Receivables Trust
2020-3 A3
0.37% Due 10/18/2024
09/22/2020
09/29/2020
30,334.06
33,218.66
0.00 2,886.23
30,332.69
4.44 10.24
4.05 9.85
0.26 0.00
0.26 10.11
10.11 43815BAC4 Honda Auto Receivables Trust
2022-1 A3
1.88% Due 05/15/2026
02/15/2022
02/23/2022
55,000.00
54,993.49
0.00 0.00
54,993.70
45.96 86.17
45.96 86.17
0.21 0.00
0.21 86.38
86.38 43815GAC3 Honda Auto Receivables Trust
2021-4 A3
0.88% Due 01/21/2026
11/16/2021
11/24/2021
35,000.00
34,994.75
0.00 0.00
34,994.94
8.56 25.67
8.56 25.67
0.19 0.00
0.19 25.86
25.86 43815NAC8 Honda Auto Receivables Trust
2019-3 A3
Due 08/15/2023
08/20/2019
08/27/2019
0.00 1,979.59
0.00 1,979.59
0.00 1.57
2.94 0.00
1.37 0.00
0.00 0.00
1.37 1.37
43815PAC3 Honda Auto Receivables
2022-2 A3
3.73% Due 07/20/2026
08/15/2022
08/24/2022
35,000.00
34,998.04
0.00 0.00
34,998.09
47.14 108.79
47.14 108.79
0.05 0.00
0.05 108.84
108.84
44891RAC4 Hyundai Auto Receivables Trust
2020-C A3
0.38% Due 05/15/2025
10/20/2020
10/28/2020
37,913.41
40,774.03
0.00 2,864.29
37,910.21
6.89 12.91
6.40 12.42
0.47 0.00
0.47 12.89
12.89 Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 23 XXXXX
Income Earned
As of November 30, 2022
City of Bell
Account #10531
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
44935FAD6 Hyundai Auto Receivables Trust
2021-C A3
0.74% Due 05/15/2026
11/09/2021
11/17/2021
25,000.00
24,996.11
0.00 0.00
24,996.25
8.22 15.42
8.22 15.42
0.14 0.00
0.14 15.56
15.56 4581X0DZ8 Inter-American Dev Bank
Note
0.5% Due 09/23/2024
09/15/2021
09/23/2021
170,000.00
169,920.57
0.00 0.00
169,924.01
89.72 0.00
160.56
70.84 3.44
0.00 3.44
74.28 74.28
459058GQ0 Intl. Bank Recon & Development
Note
2.5% Due 03/19/2024
01/26/2021
01/28/2021
150,000.00
154,613.84
0.00 0.00
154,339.21
437.50
0.00 750.00
312.50
0.00 274.63
(274.63)
37.87 37.87
459058JM6 Intl. Bank Recon & Development
Note
0.25% Due 11/24/2023
11/17/2020
11/24/2020
105,000.00
104,920.01
0.00 0.00
104,926.19
114.48
131.25
5.10 21.87
6.18 0.00
6.18 28.05
28.05 45950KCR9 International Finance Corp
Note
1.375% Due 10/16/2024
07/12/2021
07/14/2021
100,000.00
101,616.26
0.00 0.00
101,548.45
57.29 0.00
171.88
114.59
0.00 67.81
(67.81)
46.78 46.78
46647PAH9 JP Morgan Chase & Co
Callable Note 2X 3/1/2024
3.22% Due 03/01/2025
08/19/2020
08/21/2020
140,000.00
144,230.84
0.00 0.00
143,969.68
751.33
0.00 1,127.00
375.67
0.00 261.16
(261.16)
114.51
114.51
47787JAC2 John Deere Owner Trust
2022-A A3
2.32% Due 09/16/2026
03/10/2022
03/16/2022
45,000.00
44,991.84
0.00 0.00
44,992.07
46.40 87.00
46.40 87.00
0.23 0.00
0.23 87.23
87.23 47787NAC3 John Deere Owner Trust
2020-B A3
0.51% Due 11/15/2024
07/14/2020
07/22/2020
10,383.15
11,669.89
0.00 1,287.36
10,382.64
2.65 4.96
2.35 4.66
0.11 0.00
0.11 4.77
4.77 47788UAC6 John Deere Owner Trust
2021-A A3
0.36% Due 09/15/2025
03/02/2021
03/10/2021
37,236.15
39,995.82
0.00 2,763.85
37,232.43
6.40 12.00
5.96 11.56
0.46 0.00
0.46 12.02
12.02 Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 24 XXXXX
Income Earned
As of November 30, 2022
City of Bell
Account #10531
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
47789KAC7 John Deere Owner Trust
2020-A A3
1.1% Due 08/15/2024
03/04/2020
03/11/2020
13,696.40
17,394.77
0.00 3,698.79
13,696.08
8.50 15.95
6.70 14.15
0.10 0.00
0.10 14.25
14.25 47789QAC4 John Deere Owner Trust
2021-B A3
0.52% Due 03/16/2026
07/13/2021
07/21/2021
45,000.00
44,997.40
0.00 0.00
44,997.49
10.40 19.50
10.40 19.50
0.09 0.00
0.09 19.59
19.59 47800AAC4 John Deere Owner Trust
2022-B A3
3.74% Due 02/16/2027
07/12/2022
07/20/2022
45,000.00
44,996.04
0.00 0.00
44,996.14
74.80 140.25
74.80 140.25
0.10 0.00
0.10 140.35
140.35
58769KAD6 Mercedes-Benz Auto Lease Trust
2021-B A3
0.4% Due 11/15/2024
06/22/2021
06/29/2021
50,000.00
49,998.22
0.00 0.00
49,998.34
8.89 16.67
8.89 16.67
0.12 0.00
0.12 16.79
16.79 594918BX1 Microsoft
Callable Note Cont 12/6/2023
2.875% Due 02/06/2024
03/05/2020
03/09/2020
125,000.00
127,435.99
0.00 0.00
127,253.29
848.52
0.00 1,148.00
299.48
0.00 182.70
(182.70)
116.78
116.78
61747YET8 Morgan Stanley
Callable Note Cont 7/17/2025
4.679% Due 07/17/2026
07/18/2022
07/20/2022
60,000.00
60,000.00
0.00 0.00
60,000.00
787.63
0.00 1,021.58
233.95
0.00 0.00
0.00 233.95
233.95
63743HFE7 National Rural Utilities
Note
3.45% Due 06/15/2025
04/27/2022
05/04/2022
35,000.00
34,992.05
0.00 0.00
34,992.30
593.69
0.00 694.31
100.62
0.25 0.00
0.25 100.87
100.87
65479JAD5 Nissan Auto Receivables Owner
2019-C A3
1.93% Due 07/15/2024
10/16/2019
10/23/2019
12,110.11
14,815.18
0.00 2,705.35
12,109.89
12.71 23.83
10.39 21.51
0.06 0.00
0.06 21.57
21.57 665859AW4 Northern Trust Company
Callable Note Cont 4/10/2027
4% Due 05/10/2027
09/28/2022
09/30/2022
150,000.00
145,484.03
0.00 0.00
145,566.09
2,850.00
3,000.00
350.00
500.00
82.06 0.00
82.06 582.06
582.06
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 25 XXXXX
Income Earned
As of November 30, 2022
City of Bell
Account #10531
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
69371RR40 Paccar Financial Corp
Note
0.5% Due 08/09/2024
08/03/2021
08/09/2021
50,000.00
49,984.06
0.00 0.00
49,984.80
56.94 0.00
77.78 20.84
0.74 0.00
0.74 21.58
21.58 69371RR57 Paccar Financial Corp
Note
0.9% Due 11/08/2024
11/02/2021
11/08/2021
90,000.00
89,996.36
0.00 0.00
89,996.51
389.25
405.00
51.75 67.50
0.15 0.00
0.15 67.65
67.65 747525AR4 Qualcomm Inc
Callable Note Cont 12/30/2022
2.6% Due 01/30/2023
02/11/2020
02/13/2020
135,000.00
135,179.38
0.00 0.00
135,088.17
887.25
0.00 1,179.75
292.50
0.00 91.21
(91.21)
201.29
201.29
78015K7C2 Royal Bank of Canada
Note
2.25% Due 11/01/2024
09/22/2020
09/24/2020
135,000.00
139,138.98
0.00 0.00
138,969.11
1,518.75
1,518.75
253.13
253.13
0.00 169.87
(169.87)
83.26 83.26
79466LAG9 Salesforce.com Inc
Callable Note Cont 7/15/2022
0.625% Due 07/15/2024
06/29/2021
07/12/2021
20,000.00
19,994.23
0.00 0.00
19,994.51
36.81 0.00
47.22 10.41
0.28 0.00
0.28 10.69
10.69 808513BN4 Charles Schwab Corp
Callable Note Cont 2/18/2024
0.75% Due 03/18/2024
Various
Various
160,000.00
160,348.98
0.00 0.00
160,326.84
143.33
0.00 243.33
100.00
0.82 22.96
(22.14)
77.86 77.86
857477BR3 State Street Bank
Callable Note Cont 2/6/2025
1.746% Due 02/06/2026
02/02/2022
02/07/2022
35,000.00
35,000.00
0.00 0.00
35,000.00
144.29
0.00 195.21
50.92 0.00
0.00 0.00
50.92 50.92
89114QCB2 Toronto Dominion Bank
Note
3.25% Due 03/11/2024
07/16/2019
07/18/2019
130,000.00
131,253.14
0.00 0.00
131,177.35
586.81
0.00 938.89
352.08
0.00 75.79
(75.79)
276.29
276.29
89232HAC9 Toyota Auto Receivable Own
2020-A A3
1.66% Due 05/15/2024
07/06/2020
07/08/2020
35,661.07
42,594.93
0.00 6,562.95
35,957.58
31.15 58.41
26.31 53.57
0.00 74.40
(74.40)
(20.83)
(20.83)
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 26 XXXXX
Income Earned
As of November 30, 2022
City of Bell
Account #10531
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
89236TEL5 Toyota Motor Credit Corp
Note
2.7% Due 01/11/2023
01/25/2019
01/29/2019
130,000.00
129,877.96
0.00 0.00
129,929.52
1,072.50
0.00 1,365.00
292.50
51.56 0.00
51.56 344.06
344.06
89236XAC0 Toyota Auto Receivables
2020-D A3
0.35% Due 01/15/2025
10/06/2020
10/13/2020
23,701.66
26,037.98
0.00 2,338.84
23,699.45
4.05 7.60
3.69 7.24
0.31 0.00
0.31 7.55
7.55 89240BAC2 Toyota Auto Receivables Owners
2021-A A3
0.26% Due 05/15/2025
02/02/2021
02/08/2021
55,332.60
59,222.37
0.00 3,894.63
55,328.33
6.84 12.83
6.39 12.38
0.59 0.00
0.59 12.97
12.97 91159HHX1 US Bancorp
Callable Note Cont 6/28/2024
2.4% Due 07/30/2024
03/25/2021
03/29/2021
150,000.00
154,294.38
0.00 0.00
154,081.43
910.00
0.00 1,210.00
300.00
0.00 212.95
(212.95)
87.05 87.05
9128286L9 US Treasury
Note
2.25% Due 03/31/2026
Various
Various
275,000.00
131,458.86
136,260.35
0.00 267,748.29
257.14
(475.03)
1,053.91
321.74
64.21 35.13
29.08 350.82
350.82
912828R36 US Treasury
Note
1.625% Due 05/15/2026
Various
Various
265,000.00
122,647.78
133,037.50
0.00 255,708.53
900.82
929.44
190.33
218.95
84.77 61.52
23.25 242.20
242.20
912828T26 US Treasury
Note
1.375% Due 09/30/2023
08/15/2019
08/16/2019
225,000.00
224,834.81
0.00 0.00
224,849.69
271.98
0.00 526.96
254.98
14.88 0.00
14.88 269.86
269.86
912828U24 US Treasury
Note
2% Due 11/15/2026
03/29/2022
03/30/2022
265,000.00
259,419.89
0.00 0.00
259,533.38
2,448.37
2,650.00
234.25
435.88
113.49
0.00 113.49
549.37
549.37
912828V80 US Treasury
Note
2.25% Due 01/31/2024
10/29/2019
10/30/2019
225,000.00
226,575.79
0.00 0.00
226,472.12
1,279.38
0.00 1,692.09
412.71
0.00 103.67
(103.67)
309.04
309.04
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 27 XXXX
Income Earned
As of November 30, 2022
City of Bell
Account #10531
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
912828VB3 US Treasury
Note
Due 05/15/2023
01/17/2020
01/21/2020
0.00 225,177.05
0.00 225,157.98
0.00 1,818.95
2,044.89
0.00 225.94
0.00 19.07
(19.07)
206.87
206.87
912828WJ5 US Treasury
Note
2.5% Due 05/15/2024
12/12/2019
12/13/2019
200,000.00
202,244.33
0.00 0.00
202,124.31
2,309.78
2,500.00
220.99
411.21
0.00 120.02
(120.02)
291.19
291.19
912828X88 US Treasury
Note
2.375% Due 05/15/2027
Various
Various
275,000.00
268,150.47
0.00 0.00
268,274.56
3,017.16
3,265.63
288.67
537.14
124.09
0.00 124.09
661.23
661.23
912828YG9 US Treasury
Note
1.625% Due 09/30/2026
12/28/2021
12/29/2021
200,000.00
202,906.77
0.00 0.00
202,845.75
285.71
0.00 553.57
267.86
0.00 61.02
(61.02)
206.84
206.84
912828ZF0 US Treasury
Note
0.5% Due 03/31/2025
03/25/2021
03/29/2021
125,000.00
124,764.77
0.00 0.00
124,772.78
54.95 0.00
106.46
51.51 8.01
0.00 8.01
59.52 59.52
912828ZT0 US Treasury
Note
0.25% Due 05/31/2025
02/25/2021
02/26/2021
250,000.00
247,781.54
0.00 0.00
247,852.19
262.98
312.50
1.72 51.24
70.65 0.00
70.65 121.89
121.89
912828ZU7 US Treasury
Note
0.25% Due 06/15/2023
06/24/2021
06/25/2021
220,000.00
220,000.00
0.00 0.00
220,000.00
208.88
0.00 253.96
45.08 0.00
0.00 0.00
45.08 45.08
91282CAZ4 US Treasury
Note
0.375% Due 11/30/2025
12/09/2020
12/10/2020
175,000.00
174,813.67
0.00 0.00
174,818.64
276.13
328.13
1.80 53.80
4.97 0.00
4.97 58.77
58.77 91282CCG4 US Treasury
Note
0.25% Due 06/15/2024
06/17/2021
06/18/2021
250,000.00
249,285.94
0.00 0.00
249,322.12
237.36
0.00 288.59
51.23 36.18
0.00 36.18
87.41 87.41
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 28 XXXXX
Income Earned
As of November 30, 2022
City of Bell
Account #10531
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
91282CCT6 US Treasury
Note
0.375% Due 08/15/2024
08/25/2021
08/26/2021
250,000.00
249,664.99
0.00 0.00
249,680.38
198.71
0.00 275.14
76.43 15.39
0.00 15.39
91.82 91.82
91282CDH1 US Treasury
Note
0.75% Due 11/15/2024
11/18/2021
11/19/2021
225,000.00
224,616.24
0.00 0.00
224,631.70
779.55
843.75
74.59 138.79
15.46 0.00
15.46 154.25
154.25
91282CEF4 US Treasury
Note
2.5% Due 03/31/2027
05/25/2022
05/26/2022
200,000.00
198,080.12
0.00 0.00
198,115.87
439.56
0.00 851.65
412.09
35.75 0.00
35.75 447.84
447.84
91282CFM8 US Treasury
Note
4.125% Due 09/30/2027
10/26/2022
10/27/2022
260,000.00
259,280.91
0.00 0.00
259,292.94
942.86
0.00 1,826.79
883.93
12.03 0.00
12.03 895.96
895.96
91324PEN8 United Health Group Inc
Note
5.15% Due 10/15/2025
10/25/2022
10/28/2022
35,000.00
34,996.86
0.00 0.00
34,996.95
15.02 0.00
165.23
150.21
0.09 0.00
0.09 150.30
150.30
92290BAA9 Verizon Owner Trust
2020-B A
0.47% Due 02/20/2025
08/04/2020
08/12/2020
52,103.08
60,925.91
0.00 8,829.34
52,097.71
8.75 23.87
7.48 22.60
1.14 0.00
1.14 23.74
23.74 92348AAA3 Verizon Owner Trust
2019-C A1A
1.94% Due 04/22/2024
10/01/2019
10/08/2019
3,696.98
5,991.42
0.00 2,294.59
3,696.89
3.55 9.69
2.19 8.33
0.06 0.00
0.06 8.39
8.39 931142ER0 Wal-Mart Stores
Callable Note Cont 08/17/2026
1.05% Due 09/17/2026
09/08/2021
09/17/2021
25,000.00
24,963.36
0.00 0.00
24,964.14
32.08 0.00
53.96 21.88
0.78 0.00
0.78 22.66
22.66 931142EW9 Wal-Mart Stores
Note
3.9% Due 09/09/2025
09/06/2022
09/09/2022
30,000.00
29,980.02
0.00 0.00
29,980.59
169.00
0.00 266.50
97.50 0.57
0.00 0.57
98.07 98.07
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 29 XXXXX
Income Earned
As of November 30, 2022
City of Bell
Account #10531
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
931142EX7 Wal-Mart Stores
Callable Note Cont 09/09/2027
3.95% Due 09/09/2027
09/27/2022
09/29/2022
100,000.00
96,766.19
0.00 0.00
96,820.91
570.56
0.00 899.72
329.16
54.72 0.00
54.72 383.88
383.88
Total Fixed Income 10,794,492.90
10,799,287.07
269,297.85
272,306.68
10,794,178.76
43,266.84
21,976.66
37,346.97
16,056.79
1,048.52
3,148.00
(2,099.48)
13,957.31 13,957.31
CASH & EQUIVALENT
31846V203 First American
Govt Obligation Fund Class Y
Various
Various
30,104.93
9,242.63
69,678.77
48,816.47
30,104.93
0.00 108.96
0.00 108.96
0.00 0.00
0.00 108.96
108.96
Total Cash & Equivalent 30,104.93
9,242.63
69,678.77
48,816.47
30,104.93
0.00 108.96
0.00 108.96
0.00 0.00
0.00 108.96
108.96
TOTAL PORTFOLIO 10,824,597.83
10,808,529.70
338,976.62
321,123.15
10,824,283.69
43,266.84
22,085.62
37,346.97
16,165.75
1,048.52
3,148.00
(2,099.48)
14,066.27 14,066.27
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 30 XXXXX
Cash Flow Report
As of November 30, 2022
City of Bell
Account #10531
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 12/01/2022 Purchase 31846V203 114,633.58 First American Govt Obligation Fund Class Y -114,633.58 0.00 -114,633.58 12/01/2022 Purchase 023135CN4 135,000.00 Amazon.com Inc Note
4.6% Due 12/1/2025
-134,991.90 0.00 -134,991.90
12/01/2022 Sale 3133ELNW0 115,000.00 FFCB Note
1.45% Due 2/21/2023
114,633.58 463.19 115,096.77
12/01/2022 Short Sale 31846V203 -134,991.90 First American Govt Obligation Fund Class Y 134,991.90 0.00 134,991.90 12/08/2022 Interest 3130A0F70 225,000.00 FHLB Note
3.375% Due 12/8/2023
0.00 3,796.88 3,796.88
12/14/2022 Interest 3130A1XJ2 250,000.00 FHLB Note
2.875% Due 6/14/2024
0.00 3,593.75 3,593.75
12/15/2022 Interest 63743HFE7 35,000.00 National Rural Utilities Note
3.45% Due 6/15/2025
0.00 741.27 741.27
12/15/2022 Interest 912828ZU7 220,000.00 US Treasury Note
0.25% Due 6/15/2023
0.00 275.00 275.00
12/15/2022 Interest 91282CCG4 250,000.00 US Treasury Note
0.25% Due 6/15/2024
0.00 312.50 312.50
12/15/2022 Paydown 89232HAC9 35,661.07 Toyota Auto Receivable Own 2020-A A3
1.66% Due 5/15/2024
2,720.99 49.33 2,770.32
12/15/2022 Paydown 44935FAD6 25,000.00 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due 5/15/2026
0.00 15.42 15.42
12/15/2022 Paydown 58769KAD6 50,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
0.00 16.67 16.67
12/15/2022 Paydown 47787JAC2 45,000.00 John Deere Owner Trust 2022-A A3
2.32% Due 9/16/2026
0.00 87.00 87.00
12/15/2022 Paydown 47800AAC4 45,000.00 John Deere Owner Trust 2022-B A3
3.74% Due 2/16/2027
0.00 140.25 140.25
12/15/2022 Paydown 47789KAC7 13,696.40 John Deere Owner Trust 2020-A A3
1.1% Due 8/15/2024
634.45 12.56 647.01
12/15/2022 Paydown 89236XAC0 23,701.66 Toyota Auto Receivables 2020-D A3
0.35% Due 1/15/2025
953.02 6.91 959.93
12/15/2022 Paydown 43815BAC4 55,000.00 Honda Auto Receivables Trust 2022-1 A3
1.88% Due 5/15/2026
0.00 86.17 86.17
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 31 XXXXX
Cash Flow Report
As of November 30, 2022
City of Bell
Account #10531
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 12/15/2022 Paydown 44891RAC4 37,913.41 Hyundai Auto Receivables Trust 2020-C A3
0.38% Due 5/15/2025
2,521.08 12.01 2,533.09
12/15/2022 Paydown 47787NAC3 10,383.15 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
739.77 4.41 744.18
12/15/2022 Paydown 47788UAC6 37,236.15 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
1,613.18 11.17 1,624.35
12/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
12/15/2022 Paydown 65479JAD5 12,110.11 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
592.66 19.48 612.14
12/15/2022 Paydown 89240BAC2 55,332.60 Toyota Auto Receivables Owners 2021-A A3
0.26% Due 5/15/2025
3,449.86 11.99 3,461.85
12/16/2022 Paydown 36265WAD5 30,000.00 GM Financial Securitized Auto 2022-3 A3
3.64% Due 4/16/2027
0.00 91.00 91.00
12/16/2022 Paydown 380146AC4 25,000.00 GM Financial Auto Receivables 2022-1 A3
1.26% Due 11/16/2026
0.00 26.25 26.25
12/16/2022 Paydown 362554AC1 25,000.00 GM Financial Securitized Term 2021-4 A3
0.68% Due 9/16/2026
0.00 14.17 14.17
12/18/2022 Paydown 43813KAC6 30,334.06 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
2,523.56 9.35 2,532.91
12/18/2022 Paydown 43815PAC3 35,000.00 Honda Auto Receivables 2022-2 A3
3.73% Due 7/20/2026
0.00 108.79 108.79
12/19/2022 Paydown 3137B3NX2 0.00 FHLMC K031 A2
3.3% Due 4/25/2023
3,229.53 528.52 3,758.05
12/19/2022 Paydown 3137B5JM6 0.00 FHLMC K034 A2
3.531% Due 7/25/2023
419.59 588.27 1,007.86
12/20/2022 Paydown 92348AAA3 3,696.98 Verizon Owner Trust 2019-C A1A
1.94% Due 4/22/2024
201.48 5.98 207.46
12/20/2022 Paydown 36266FAC3 55,000.00 GM Financial Auto Lease Trust 2022-2 A3
3.42% Due 6/20/2025
0.00 156.75 156.75
12/20/2022 Paydown 92290BAA9 52,103.08 Verizon Owner Trust 2020-B A
0.47% Due 2/20/2025
1,919.93 20.41 1,940.34
12/21/2022 Paydown 43815GAC3 35,000.00 Honda Auto Receivables Trust 2021-4 A3
0.88% Due 1/21/2026
0.00 25.67 25.67
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 32 XXXXX
Cash Flow Report
As of November 30, 2022
City of Bell
Account #10531
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 12/21/2022 Paydown 43813GAC5 18,861.43 Honda Auto Receivables Trust 2021-1 A3
0.27% Due 4/21/2025
1,176.71 4.24 1,180.95
12/25/2022 Interest 3137B5JM6 199,502.34 FHLMC K034 A2
3.531% Due 7/25/2023
0.00 587.04 587.04
12/25/2022 Paydown 05601XAC3 35,000.00 BMW Vehicle Lease Trust 2022-1 A3
1.1% Due 3/25/2025
0.00 32.08 32.08
12/25/2022 Paydown 09690AAC7 35,000.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due 12/26/2024
0.00 9.63 9.63
12/25/2022 Paydown 3137B4GY6 170,000.00 FHLMC K032 A2
3.31% Due 5/25/2023
0.00 468.92 468.92
12/30/2022 Call 747525AR4 135,000.00 Qualcomm Inc Callable Note Cont 12/30/2022
2.6% Due 1/30/2023
135,000.00 1,462.50 136,462.50
DEC 2022 157,695.81 13,815.03 171,510.84
01/06/2023 Interest 3133ENKS8 80,000.00 FFCB Note
1.125% Due 1/6/2025
0.00 450.00 450.00
01/10/2023 Interest 3135G05G4 165,000.00 FNMA Note
0.25% Due 7/10/2023
0.00 206.25 206.25
01/11/2023 Maturity 89236TEL5 130,000.00 Toyota Motor Credit Corp Note
2.7% Due 1/11/2023
130,000.00 1,755.00 131,755.00
01/13/2023 Maturity 037833DE7 130,000.00 Apple Inc Callable Note Cont 12/13/2022
2.4% Due 1/13/2023
130,000.00 1,560.00 131,560.00
01/15/2023 Interest 79466LAG9 20,000.00 Salesforce.com Inc Callable Note Cont 7/15/2022
0.625% Due 7/15/2024
0.00 62.50 62.50
01/15/2023 Paydown 89236XAC0 23,701.66 Toyota Auto Receivables 2020-D A3
0.35% Due 1/15/2025
949.97 6.64 956.61
01/15/2023 Paydown 44935FAD6 25,000.00 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due 5/15/2026
0.00 15.42 15.42
01/15/2023 Paydown 47787JAC2 45,000.00 John Deere Owner Trust 2022-A A3
2.32% Due 9/16/2026
0.00 87.00 87.00
01/15/2023 Paydown 47789KAC7 13,696.40 John Deere Owner Trust 2020-A A3
1.1% Due 8/15/2024
636.20 11.97 648.17
01/15/2023 Paydown 47800AAC4 45,000.00 John Deere Owner Trust 2022-B A3
3.74% Due 2/16/2027
0.00 140.25 140.25
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 33 XXXXX
Cash Flow Report
As of November 30, 2022
City of Bell
Account #10531
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 01/15/2023 Paydown 65479JAD5 12,110.11 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
594.00 18.52 612.52
01/15/2023 Paydown 89232HAC9 35,661.07 Toyota Auto Receivable Own 2020-A A3
1.66% Due 5/15/2024
2,635.89 45.57 2,681.46
01/15/2023 Paydown 43815BAC4 55,000.00 Honda Auto Receivables Trust 2022-1 A3
1.88% Due 5/15/2026
0.00 86.17 86.17
01/15/2023 Paydown 47787NAC3 10,383.15 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
740.06 4.10 744.16
01/15/2023 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/2023 Paydown 58769KAD6 50,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
3,844.04 16.67 3,860.71
01/15/2023 Paydown 89240BAC2 55,332.60 Toyota Auto Receivables Owners 2021-A A3
0.26% Due 5/15/2025
3,450.99 11.24 3,462.23
01/15/2023 Paydown 44891RAC4 37,913.41 Hyundai Auto Receivables Trust 2020-C A3
0.38% Due 5/15/2025
2,522.00 11.21 2,533.21
01/15/2023 Paydown 47788UAC6 37,236.15 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
1,613.70 10.69 1,624.39
01/16/2023 Paydown 36265WAD5 30,000.00 GM Financial Securitized Auto 2022-3 A3
3.64% Due 4/16/2027
0.00 91.00 91.00
01/16/2023 Paydown 380146AC4 25,000.00 GM Financial Auto Receivables 2022-1 A3
1.26% Due 11/16/2026
0.00 26.25 26.25
01/16/2023 Paydown 362554AC1 25,000.00 GM Financial Securitized Term 2021-4 A3
0.68% Due 9/16/2026
0.00 14.17 14.17
01/17/2023 Interest 24422EVN6 95,000.00 John Deere Capital Corp Note
0.45% Due 1/17/2024
0.00 213.75 213.75
01/17/2023 Interest 61747YET8 60,000.00 Morgan Stanley Callable Note Cont 7/17/2025
4.679% Due 7/17/2026
0.00 1,380.31 1,380.31
01/18/2023 Paydown 43813KAC6 30,334.06 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
2,524.34 8.57 2,532.91
01/18/2023 Paydown 43815PAC3 35,000.00 Honda Auto Receivables 2022-2 A3
3.73% Due 7/20/2026
0.00 108.79 108.79
01/19/2023 Paydown 3137B3NX2 188,960.46 FHLMC K031 A2
3.3% Due 4/25/2023
47,819.34 528.52 48,347.86
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 34 XXXXX
Cash Flow Report
As of November 30, 2022
City of Bell
Account #10531
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 01/20/2023 Paydown 36266FAC3 55,000.00 GM Financial Auto Lease Trust 2022-2 A3
3.42% Due 6/20/2025
0.00 156.75 156.75
01/20/2023 Paydown 92290BAA9 52,103.08 Verizon Owner Trust 2020-B A
0.47% Due 2/20/2025
1,920.68 19.66 1,940.34
01/20/2023 Paydown 92348AAA3 3,696.98 Verizon Owner Trust 2019-C A1A
1.94% Due 4/22/2024
201.94 5.65 207.59
01/21/2023 Paydown 43813GAC5 18,861.43 Honda Auto Receivables Trust 2021-1 A3
0.27% Due 4/21/2025
1,176.99 3.98 1,180.97
01/21/2023 Paydown 43815GAC3 35,000.00 Honda Auto Receivables Trust 2021-4 A3
0.88% Due 1/21/2026
0.00 25.67 25.67
01/25/2023 Interest 3137B5JM6 199,502.34 FHLMC K034 A2
3.531% Due 7/25/2023
0.00 587.04 587.04
01/25/2023 Paydown 05601XAC3 35,000.00 BMW Vehicle Lease Trust 2022-1 A3
1.1% Due 3/25/2025
0.00 32.08 32.08
01/25/2023 Paydown 09690AAC7 35,000.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due 12/26/2024
2,912.79 9.63 2,922.42
01/25/2023 Paydown 3137B4GY6 170,000.00 FHLMC K032 A2
3.31% Due 5/25/2023
0.00 468.92 468.92
01/30/2023 Interest 91159HHX1 150,000.00 US Bancorp Callable Note Cont 6/28/2024
2.4% Due 7/30/2024
0.00 1,800.00 1,800.00
01/31/2023 Interest 912828V80 225,000.00 US Treasury Note
2.25% Due 1/31/2024
0.00 2,531.25 2,531.25
JAN 2023 333,542.93 12,530.69 346,073.62
02/06/2023 Interest 857477BR3 35,000.00 State Street Bank Callable Note Cont 2/6/2025
1.746% Due 2/6/2026
0.00 305.55 305.55
02/06/2023 Interest 594918BX1 125,000.00 Microsoft Callable Note Cont 12/6/2023
2.875% Due 2/6/2024
0.00 1,796.88 1,796.88
02/09/2023 Interest 69371RR40 50,000.00 Paccar Financial Corp Note
0.5% Due 8/9/2024
0.00 125.00 125.00
02/15/2023 Interest 91282CCT6 250,000.00 US Treasury Note
0.375% Due 8/15/2024
0.00 468.75 468.75
02/15/2023 Paydown 43815BAC4 55,000.00 Honda Auto Receivables Trust 2022-1 A3
1.88% Due 5/15/2026
0.00 86.17 86.17
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 35 XXXXX
Cash Flow Report
As of November 30, 2022
City of Bell
Account #10531
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 02/15/2023 Paydown 47787NAC3 10,383.15 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
740.35 3.78 744.13
02/15/2023 Paydown 47789KAC7 13,696.40 John Deere Owner Trust 2020-A A3
1.1% Due 8/15/2024
637.95 11.39 649.34
02/15/2023 Paydown 89236XAC0 23,701.66 Toyota Auto Receivables 2020-D A3
0.35% Due 1/15/2025
946.89 6.36 953.25
02/15/2023 Paydown 89240BAC2 55,332.60 Toyota Auto Receivables Owners 2021-A A3
0.26% Due 5/15/2025
3,452.11 10.49 3,462.60
02/15/2023 Paydown 44935FAD6 25,000.00 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due 5/15/2026
0.00 15.42 15.42
02/15/2023 Paydown 47787JAC2 45,000.00 John Deere Owner Trust 2022-A A3
2.32% Due 9/16/2026
0.00 87.00 87.00
02/15/2023 Paydown 47800AAC4 45,000.00 John Deere Owner Trust 2022-B A3
3.74% Due 2/16/2027
0.00 140.25 140.25
02/15/2023 Paydown 65479JAD5 12,110.11 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
595.33 17.57 612.90
02/15/2023 Paydown 58769KAD6 50,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
3,844.39 15.39 3,859.78
02/15/2023 Paydown 89232HAC9 35,661.07 Toyota Auto Receivable Own 2020-A A3
1.66% Due 5/15/2024
2,550.43 41.92 2,592.35
02/15/2023 Paydown 44891RAC4 37,913.41 Hyundai Auto Receivables Trust 2020-C A3
0.38% Due 5/15/2025
2,522.93 10.41 2,533.34
02/15/2023 Paydown 47788UAC6 37,236.15 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
1,614.23 10.20 1,624.43
02/15/2023 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/16/2023 Interest 06406FAD5 125,000.00 Bank of NY Mellon Corp Callable Note Cont 6/16/2023
2.2% Due 8/16/2023
0.00 1,375.00 1,375.00
02/16/2023 Paydown 362554AC1 25,000.00 GM Financial Securitized Term 2021-4 A3
0.68% Due 9/16/2026
0.00 14.17 14.17
02/16/2023 Paydown 380146AC4 25,000.00 GM Financial Auto Receivables 2022-1 A3
1.26% Due 11/16/2026
0.00 26.25 26.25
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 36 XXXXX
Cash Flow Report
As of November 30, 2022
City of Bell
Account #10531
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 02/16/2023 Paydown 36265WAD5 30,000.00 GM Financial Securitized Auto 2022-3 A3
3.64% Due 4/16/2027
0.00 91.00 91.00
02/18/2023 Paydown 43815PAC3 35,000.00 Honda Auto Receivables 2022-2 A3
3.73% Due 7/20/2026
0.00 108.79 108.79
02/18/2023 Paydown 43813KAC6 30,334.06 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
2,525.11 7.80 2,532.91
02/19/2023 Paydown 3137B3NX2 188,960.46 FHLMC K031 A2
3.3% Due 4/25/2023
47,971.12 397.02 48,368.14
02/20/2023 Paydown 36266FAC3 55,000.00 GM Financial Auto Lease Trust 2022-2 A3
3.42% Due 6/20/2025
0.00 156.75 156.75
02/20/2023 Paydown 92290BAA9 52,103.08 Verizon Owner Trust 2020-B A
0.47% Due 2/20/2025
1,921.44 18.90 1,940.34
02/20/2023 Paydown 92348AAA3 3,696.98 Verizon Owner Trust 2019-C A1A
1.94% Due 4/22/2024
202.40 5.32 207.72
02/21/2023 Maturity 3133ELNW0 85,000.00 FFCB Note
1.45% Due 2/21/2023
85,000.00 616.25 85,616.25
02/21/2023 Paydown 43813GAC5 18,861.43 Honda Auto Receivables Trust 2021-1 A3
0.27% Due 4/21/2025
1,177.28 3.71 1,180.99
02/21/2023 Paydown 43815GAC3 35,000.00 Honda Auto Receivables Trust 2021-4 A3
0.88% Due 1/21/2026
0.00 25.67 25.67
02/25/2023 Interest 3137B5JM6 199,502.34 FHLMC K034 A2
3.531% Due 7/25/2023
0.00 587.04 587.04
02/25/2023 Paydown 3137B4GY6 170,000.00 FHLMC K032 A2
3.31% Due 5/25/2023
42,302.88 468.92 42,771.80
02/25/2023 Paydown 05601XAC3 35,000.00 BMW Vehicle Lease Trust 2022-1 A3
1.1% Due 3/25/2025
0.00 32.08 32.08
02/25/2023 Paydown 09690AAC7 35,000.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due 12/26/2024
2,913.50 8.82 2,922.32
FEB 2023 200,918.34 7,115.52 208,033.86
03/01/2023 Interest 46647PAH9 140,000.00 JP Morgan Chase & Co Callable Note 2X 3/1/2024
3.22% Due 3/1/2025
0.00 2,254.00 2,254.00
03/08/2023 Interest 3130AB3H7 225,000.00 FHLB Note
2.375% Due 3/8/2024
0.00 2,671.88 2,671.88
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 37 XXXXX
Cash Flow Report
As of November 30, 2022
City of Bell
Account #10531
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 03/09/2023 Interest 931142EW9 30,000.00 Wal-Mart Stores Note
3.9% Due 9/9/2025
0.00 585.00 585.00
03/09/2023 Interest 931142EX7 100,000.00 Wal-Mart Stores Callable Note Cont 09/09/2027
3.95% Due 9/9/2027
0.00 1,975.00 1,975.00
03/10/2023 Maturity 3130ADRG9 225,000.00 FHLB Note
2.75% Due 3/10/2023
225,000.00 3,093.75 228,093.75
03/11/2023 Interest 89114QCB2 130,000.00 Toronto Dominion Bank Note
3.25% Due 3/11/2024
0.00 2,112.50 2,112.50
03/12/2023 Interest 3135G0U43 225,000.00 FNMA Note
2.875% Due 9/12/2023
0.00 3,234.38 3,234.38
03/15/2023 Interest 437076CR1 40,000.00 Home Depot Callable Note Cont 8/15/2025 4% Due 9/15/2025
0.00 782.22 782.22
03/15/2023 Paydown 44891RAC4 37,913.41 Hyundai Auto Receivables Trust 2020-C A3
0.38% Due 5/15/2025
2,523.85 9.61 2,533.46
03/15/2023 Paydown 47789KAC7 13,696.40 John Deere Owner Trust 2020-A A3
1.1% Due 8/15/2024
639.70 10.81 650.51
03/15/2023 Paydown 89236XAC0 23,701.66 Toyota Auto Receivables 2020-D A3
0.35% Due 1/15/2025
943.79 6.08 949.87
03/15/2023 Paydown 44935FAD6 25,000.00 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due 5/15/2026
0.00 15.42 15.42
03/15/2023 Paydown 47787JAC2 45,000.00 John Deere Owner Trust 2022-A A3
2.32% Due 9/16/2026
0.00 87.00 87.00
03/15/2023 Paydown 47788UAC6 37,236.15 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
1,614.75 9.72 1,624.47
03/15/2023 Paydown 43815BAC4 55,000.00 Honda Auto Receivables Trust 2022-1 A3
1.88% Due 5/15/2026
0.00 86.17 86.17
03/15/2023 Paydown 47800AAC4 45,000.00 John Deere Owner Trust 2022-B A3
3.74% Due 2/16/2027
0.00 140.25 140.25
03/15/2023 Paydown 58769KAD6 50,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
3,844.75 14.10 3,858.85
03/15/2023 Paydown 89232HAC9 35,661.07 Toyota Auto Receivable Own 2020-A A3
1.66% Due 5/15/2024
2,464.62 38.39 2,503.01
03/15/2023 Paydown 47787NAC3 10,383.15 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
740.64 3.47 744.11
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 38 XXXXX
Cash Flow Report
As of November 30, 2022
City of Bell
Account #10531
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 03/15/2023 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/2023 Paydown 65479JAD5 12,110.11 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
596.68 16.61 613.29
03/15/2023 Paydown 89240BAC2 55,332.60 Toyota Auto Receivables Owners 2021-A A3
0.26% Due 5/15/2025
3,453.23 9.75 3,462.98
03/16/2023 Paydown 362554AC1 25,000.00 GM Financial Securitized Term 2021-4 A3
0.68% Due 9/16/2026
0.00 14.17 14.17
03/16/2023 Paydown 380146AC4 25,000.00 GM Financial Auto Receivables 2022-1 A3
1.26% Due 11/16/2026
0.00 26.25 26.25
03/16/2023 Paydown 36265WAD5 30,000.00 GM Financial Securitized Auto 2022-3 A3
3.64% Due 4/16/2027
0.00 91.00 91.00
03/17/2023 Interest 931142ER0 25,000.00 Wal-Mart Stores Callable Note Cont 08/17/2026
1.05% Due 9/17/2026
0.00 131.25 131.25
03/18/2023 Interest 808513BN4 160,000.00 Charles Schwab Corp Callable Note Cont 2/18/2024
0.75% Due 3/18/2024
0.00 600.00 600.00
03/18/2023 Paydown 43815PAC3 35,000.00 Honda Auto Receivables 2022-2 A3
3.73% Due 7/20/2026
0.00 108.79 108.79
03/18/2023 Paydown 43813KAC6 30,334.06 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
2,525.89 7.02 2,532.91
03/19/2023 Interest 459058GQ0 150,000.00 Intl. Bank Recon & Development Note
2.5% Due 3/19/2024
0.00 1,875.00 1,875.00
03/19/2023 Paydown 3137B3NX2 188,960.46 FHLMC K031 A2
3.3% Due 4/25/2023
48,123.39 265.10 48,388.49
03/19/2023 Paydown 3137B5JM6 199,502.34 FHLMC K034 A2
3.531% Due 7/25/2023
7,886.85 18.57 7,905.42
03/20/2023 Paydown 36266FAC3 55,000.00 GM Financial Auto Lease Trust 2022-2 A3
3.42% Due 6/20/2025
0.00 156.75 156.75
03/20/2023 Paydown 92290BAA9 52,103.08 Verizon Owner Trust 2020-B A
0.47% Due 2/20/2025
1,922.19 18.15 1,940.34
03/20/2023 Paydown 92348AAA3 3,696.98 Verizon Owner Trust 2019-C A1A
1.94% Due 4/22/2024
202.85 5.00 207.85
03/21/2023 Paydown 43815GAC3 35,000.00 Honda Auto Receivables Trust 2021-4 A3
0.88% Due 1/21/2026
0.00 25.67 25.67
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 39 XXXXX
Cash Flow Report
As of November 30, 2022
City of Bell
Account #10531
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 03/21/2023 Paydown 43813GAC5 18,861.43 Honda Auto Receivables Trust 2021-1 A3
0.27% Due 4/21/2025
1,177.56 3.45 1,181.01
03/23/2023 Interest 4581X0DZ8 170,000.00 Inter-American Dev Bank Note
0.5% Due 9/23/2024
0.00 425.00 425.00
03/25/2023 Interest 3137B5JM6 199,502.34 FHLMC K034 A2
3.531% Due 7/25/2023
0.00 563.83 563.83
03/25/2023 Paydown 3137B4GY6 170,000.00 FHLMC K032 A2
3.31% Due 5/25/2023
42,434.02 352.23 42,786.25
03/25/2023 Paydown 05601XAC3 35,000.00 BMW Vehicle Lease Trust 2022-1 A3
1.1% Due 3/25/2025
0.00 32.08 32.08
03/25/2023 Paydown 09690AAC7 35,000.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due 12/26/2024
2,914.20 8.02 2,922.22
03/31/2023 Interest 9128286L9 275,000.00 US Treasury Note
2.25% Due 3/31/2026
0.00 3,093.75 3,093.75
03/31/2023 Interest 91282CFM8 260,000.00 US Treasury Note
4.125% Due 9/30/2027
0.00 5,362.50 5,362.50
03/31/2023 Interest 912828YG9 200,000.00 US Treasury Note
1.625% Due 9/30/2026
0.00 1,625.00 1,625.00
03/31/2023 Interest 912828ZF0 125,000.00 US Treasury Note
0.5% Due 3/31/2025
0.00 312.50 312.50
03/31/2023 Interest 912828T26 225,000.00 US Treasury Note
1.375% Due 9/30/2023
0.00 1,546.88 1,546.88
03/31/2023 Interest 91282CEF4 200,000.00 US Treasury Note
2.5% Due 3/31/2027
0.00 2,500.00 2,500.00
MAR 2023 349,008.96 36,343.57 385,352.53
04/15/2023 Interest 91324PEN8 35,000.00 United Health Group Inc Note
5.15% Due 10/15/2025
0.00 836.16 836.16
04/15/2023 Paydown 43815BAC4 55,000.00 Honda Auto Receivables Trust 2022-1 A3
1.88% Due 5/15/2026
0.00 86.17 86.17
04/15/2023 Paydown 47800AAC4 45,000.00 John Deere Owner Trust 2022-B A3
3.74% Due 2/16/2027
0.00 140.25 140.25
04/15/2023 Paydown 47788UAC6 37,236.15 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
1,615.29 9.23 1,624.52
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 40 XXXXX
Cash Flow Report
As of November 30, 2022
City of Bell
Account #10531
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 04/15/2023 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/2023 Paydown 58769KAD6 50,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
3,845.10 12.82 3,857.92
04/15/2023 Paydown 44891RAC4 37,913.41 Hyundai Auto Receivables Trust 2020-C A3
0.38% Due 5/15/2025
2,524.78 8.81 2,533.59
04/15/2023 Paydown 89232HAC9 35,661.07 Toyota Auto Receivable Own 2020-A A3
1.66% Due 5/15/2024
2,378.44 34.98 2,413.42
04/15/2023 Paydown 44935FAD6 25,000.00 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due 5/15/2026
0.00 15.42 15.42
04/15/2023 Paydown 47787JAC2 45,000.00 John Deere Owner Trust 2022-A A3
2.32% Due 9/16/2026
0.00 87.00 87.00
04/15/2023 Paydown 47787NAC3 10,383.15 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
740.93 3.15 744.08
04/15/2023 Paydown 47789KAC7 13,696.40 John Deere Owner Trust 2020-A A3
1.1% Due 8/15/2024
641.46 10.22 651.68
04/15/2023 Paydown 65479JAD5 12,110.11 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
598.02 15.65 613.67
04/15/2023 Paydown 89236XAC0 23,701.66 Toyota Auto Receivables 2020-D A3
0.35% Due 1/15/2025
940.64 5.81 946.45
04/15/2023 Paydown 89240BAC2 55,332.60 Toyota Auto Receivables Owners 2021-A A3
0.26% Due 5/15/2025
3,454.35 9.00 3,463.35
04/16/2023 Interest 3137EAEY1 150,000.00 FHLMC Note
0.125% Due 10/16/2023
0.00 93.75 93.75
04/16/2023 Interest 45950KCR9 100,000.00 International Finance Corp Note
1.375% Due 10/16/2024
0.00 687.50 687.50
04/16/2023 Paydown 362554AC1 25,000.00 GM Financial Securitized Term 2021-4 A3
0.68% Due 9/16/2026
0.00 14.17 14.17
04/16/2023 Paydown 36265WAD5 30,000.00 GM Financial Securitized Auto 2022-3 A3
3.64% Due 4/16/2027
0.00 91.00 91.00
04/16/2023 Paydown 380146AC4 25,000.00 GM Financial Auto Receivables 2022-1 A3
1.26% Due 11/16/2026
0.00 26.25 26.25
04/18/2023 Paydown 43815PAC3 35,000.00 Honda Auto Receivables 2022-2 A3
3.73% Due 7/20/2026
0.00 108.79 108.79
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 41 XXXXX
Cash Flow Report
As of November 30, 2022
City of Bell
Account #10531
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 04/18/2023 Paydown 43813KAC6 30,334.06 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
2,526.67 6.24 2,532.91
04/19/2023 Paydown 3137B5JM6 199,502.34 FHLMC K034 A2
3.531% Due 7/25/2023
472.28 1.11 473.39
04/19/2023 Paydown 3137B3NX2 188,960.46 FHLMC K031 A2
3.3% Due 4/25/2023
48,276.14 132.76 48,408.90
04/20/2023 Paydown 92348AAA3 3,696.98 Verizon Owner Trust 2019-C A1A
1.94% Due 4/22/2024
203.31 4.67 207.98
04/20/2023 Paydown 36266FAC3 55,000.00 GM Financial Auto Lease Trust 2022-2 A3
3.42% Due 6/20/2025
0.00 156.75 156.75
04/20/2023 Paydown 92290BAA9 52,103.08 Verizon Owner Trust 2020-B A
0.47% Due 2/20/2025
1,922.94 17.40 1,940.34
04/21/2023 Paydown 43813GAC5 18,861.43 Honda Auto Receivables Trust 2021-1 A3
0.27% Due 4/21/2025
1,177.85 3.18 1,181.03
04/21/2023 Paydown 43815GAC3 35,000.00 Honda Auto Receivables Trust 2021-4 A3
0.88% Due 1/21/2026
0.00 25.67 25.67
04/25/2023 Interest 3137B5JM6 199,502.34 FHLMC K034 A2
3.531% Due 7/25/2023
0.00 562.44 562.44
04/25/2023 Interest 06406RBC0 60,000.00 Bank of NY Mellon Corp Callable Note Cont 3/25/2025
3.35% Due 4/25/2025
0.00 1,005.00 1,005.00
04/25/2023 Paydown 3137B4GY6 170,000.00 FHLMC K032 A2
3.31% Due 5/25/2023
42,565.57 235.18 42,800.75
04/25/2023 Paydown 05601XAC3 35,000.00 BMW Vehicle Lease Trust 2022-1 A3
1.1% Due 3/25/2025
0.00 32.08 32.08
04/25/2023 Paydown 09690AAC7 35,000.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due 12/26/2024
2,914.91 7.22 2,922.13
APR 2023 116,798.68 4,505.33 121,304.01
05/01/2023 Interest 78015K7C2 135,000.00 Royal Bank of Canada Note
2.25% Due 11/1/2024
0.00 1,518.75 1,518.75
05/05/2023 Maturity 3137EAER6 200,000.00 FHLMC Note
0.375% Due 5/5/2023
200,000.00 375.00 200,375.00
05/06/2023 Interest 3137EAEZ8 220,000.00 FHLMC Note
0.25% Due 11/6/2023
0.00 275.00 275.00
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 42 XXXXX
Cash Flow Report
As of November 30, 2022
City of Bell
Account #10531
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 05/07/2023 Interest 3135G06G3 225,000.00 FNMA Note
0.5% Due 11/7/2025
0.00 562.50 562.50
05/08/2023 Interest 69371RR57 90,000.00 Paccar Financial Corp Note
0.9% Due 11/8/2024
0.00 405.00 405.00
05/10/2023 Interest 665859AW4 150,000.00 Northern Trust Company Callable Note Cont 4/10/2027
4% Due 5/10/2027
0.00 3,000.00 3,000.00
05/12/2023 Interest 023135BW5 85,000.00 Amazon.com Inc Note
0.45% Due 5/12/2024
0.00 191.25 191.25
05/15/2023 Interest 912828R36 265,000.00 US Treasury Note
1.625% Due 5/15/2026
0.00 2,153.13 2,153.13
05/15/2023 Interest 912828U24 265,000.00 US Treasury Note 2% Due 11/15/2026
0.00 2,650.00 2,650.00
05/15/2023 Interest 912828WJ5 200,000.00 US Treasury Note
2.5% Due 5/15/2024
0.00 2,500.00 2,500.00
05/15/2023 Interest 91282CDH1 225,000.00 US Treasury Note
0.75% Due 11/15/2024
0.00 843.75 843.75
05/15/2023 Interest 912828X88 275,000.00 US Treasury Note
2.375% Due 5/15/2027
0.00 3,265.63 3,265.63
05/15/2023 Paydown 44935FAD6 25,000.00 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due 5/15/2026
0.00 15.42 15.42
05/15/2023 Paydown 47787JAC2 45,000.00 John Deere Owner Trust 2022-A A3
2.32% Due 9/16/2026
0.00 87.00 87.00
05/15/2023 Paydown 47789KAC7 13,696.40 John Deere Owner Trust 2020-A A3
1.1% Due 8/15/2024
643.23 9.63 652.86
05/15/2023 Paydown 89236XAC0 23,701.66 Toyota Auto Receivables 2020-D A3
0.35% Due 1/15/2025
937.47 5.53 943.00
05/15/2023 Paydown 47800AAC4 45,000.00 John Deere Owner Trust 2022-B A3
3.74% Due 2/16/2027
0.00 140.25 140.25
05/15/2023 Paydown 65479JAD5 12,110.11 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
599.36 14.69 614.05
05/15/2023 Paydown 89232HAC9 35,661.07 Toyota Auto Receivable Own 2020-A A3
1.66% Due 5/15/2024
2,291.90 31.69 2,323.59
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 43 XXXXX
Cash Flow Report
As of November 30, 2022
City of Bell
Account #10531
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 05/15/2023 Paydown 43815BAC4 55,000.00 Honda Auto Receivables Trust 2022-1 A3
1.88% Due 5/15/2026
0.00 86.17 86.17
05/15/2023 Paydown 47787NAC3 10,383.15 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
741.22 2.84 744.06
05/15/2023 Paydown 47789QAC4 45,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
1,954.55 19.50 1,974.05
05/15/2023 Paydown 58769KAD6 50,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
3,845.45 11.54 3,856.99
05/15/2023 Paydown 89240BAC2 55,332.60 Toyota Auto Receivables Owners 2021-A A3
0.26% Due 5/15/2025
3,455.47 8.25 3,463.72
05/15/2023 Paydown 44891RAC4 37,913.41 Hyundai Auto Receivables Trust 2020-C A3
0.38% Due 5/15/2025
2,525.71 8.01 2,533.72
05/15/2023 Paydown 47788UAC6 37,236.15 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
1,615.81 8.75 1,624.56
05/16/2023 Paydown 36265WAD5 30,000.00 GM Financial Securitized Auto 2022-3 A3
3.64% Due 4/16/2027
0.00 91.00 91.00
05/16/2023 Paydown 362554AC1 25,000.00 GM Financial Securitized Term 2021-4 A3
0.68% Due 9/16/2026
0.00 14.17 14.17
05/16/2023 Paydown 380146AC4 25,000.00 GM Financial Auto Receivables 2022-1 A3
1.26% Due 11/16/2026
0.00 26.25 26.25
05/17/2023 Interest 14913R2L0 135,000.00 Caterpillar Financial Service Note
0.45% Due 5/17/2024
0.00 303.75 303.75
05/18/2023 Paydown 43813KAC6 30,334.06 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
2,527.45 5.46 2,532.91
05/18/2023 Paydown 43815PAC3 35,000.00 Honda Auto Receivables 2022-2 A3
3.73% Due 7/20/2026
0.00 108.79 108.79
05/19/2023 Paydown 3137B5JM6 199,502.34 FHLMC K034 A2
3.531% Due 7/25/2023
34,692.38 81.67 34,774.05
05/20/2023 Paydown 36266FAC3 55,000.00 GM Financial Auto Lease Trust 2022-2 A3
3.42% Due 6/20/2025
0.00 156.75 156.75
05/20/2023 Paydown 92348AAA3 3,696.98 Verizon Owner Trust 2019-C A1A
1.94% Due 4/22/2024
203.77 4.34 208.11
05/20/2023 Paydown 92290BAA9 52,103.08 Verizon Owner Trust 2020-B A
0.47% Due 2/20/2025
1,923.70 16.64 1,940.34
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 44 XXXXX
Cash Flow Report
As of November 30, 2022
City of Bell
Account #10531
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 05/21/2023 Paydown 43813GAC5 18,861.43 Honda Auto Receivables Trust 2021-1 A3
0.27% Due 4/21/2025
1,178.13 2.92 1,181.05
05/21/2023 Paydown 43815GAC3 35,000.00 Honda Auto Receivables Trust 2021-4 A3
0.88% Due 1/21/2026
1,587.01 25.67 1,612.68
05/22/2023 Maturity 3135G04Q3 160,000.00 FNMA Note
0.25% Due 5/22/2023
160,000.00 200.00 160,200.00
05/24/2023 Interest 459058JM6 105,000.00 Intl. Bank Recon & Development Note
0.25% Due 11/24/2023
0.00 131.25 131.25
05/25/2023 Interest 3137B5JM6 199,502.34 FHLMC K034 A2
3.531% Due 7/25/2023
0.00 460.36 460.36
05/25/2023 Paydown 05601XAC3 35,000.00 BMW Vehicle Lease Trust 2022-1 A3
1.1% Due 3/25/2025
3,112.70 32.08 3,144.78
05/25/2023 Paydown 09690AAC7 35,000.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due 12/26/2024
2,915.61 6.42 2,922.03
05/25/2023 Paydown 3137B4GY6 170,000.00 FHLMC K032 A2
3.31% Due 5/25/2023
42,697.53 117.77 42,815.30
05/31/2023 Interest 912828ZT0 250,000.00 US Treasury Note
0.25% Due 5/31/2025
0.00 312.50 312.50
05/31/2023 Interest 91282CAZ4 175,000.00 US Treasury Note
0.375% Due 11/30/2025
0.00 328.13 328.13
MAY 2023 469,448.45 20,615.20 490,063.65
06/01/2023 Interest 023135CN4 135,000.00 Amazon.com Inc Note
4.6% Due 12/1/2025
0.00 3,105.00 3,105.00
06/08/2023 Interest 3130A0F70 225,000.00 FHLB Note
3.375% Due 12/8/2023
0.00 3,796.88 3,796.88
06/14/2023 Interest 3130A1XJ2 250,000.00 FHLB Note
2.875% Due 6/14/2024
0.00 3,593.75 3,593.75
06/15/2023 Interest 91282CCG4 250,000.00 US Treasury Note
0.25% Due 6/15/2024
0.00 312.50 312.50
06/15/2023 Interest 63743HFE7 35,000.00 National Rural Utilities Note
3.45% Due 6/15/2025
0.00 603.75 603.75
06/15/2023 Maturity 912828ZU7 220,000.00 US Treasury Note
0.25% Due 6/15/2023
220,000.00 275.00 220,275.00
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 45 XXXXX
Cash Flow Report
As of November 30, 2022
City of Bell
Account #10531
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 06/15/2023 Paydown 89232HAC9 35,661.07 Toyota Auto Receivable Own 2020-A A3
1.66% Due 5/15/2024
2,204.99 28.52 2,233.51
06/15/2023 Paydown 58769KAD6 50,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
3,845.80 10.26 3,856.06
06/15/2023 Paydown 44891RAC4 37,913.41 Hyundai Auto Receivables Trust 2020-C A3
0.38% Due 5/15/2025
2,526.63 7.21 2,533.84
06/15/2023 Paydown 47788UAC6 37,236.15 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
1,616.34 8.26 1,624.60
06/15/2023 Paydown 44935FAD6 25,000.00 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due 5/15/2026
1,248.02 15.42 1,263.44
06/15/2023 Paydown 47787JAC2 45,000.00 John Deere Owner Trust 2022-A A3
2.32% Due 9/16/2026
0.00 87.00 87.00
06/15/2023 Paydown 47800AAC4 45,000.00 John Deere Owner Trust 2022-B A3
3.74% Due 2/16/2027
0.00 140.25 140.25
06/15/2023 Paydown 65479JAD5 12,110.11 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
600.71 13.73 614.44
06/15/2023 Paydown 43815BAC4 55,000.00 Honda Auto Receivables Trust 2022-1 A3
1.88% Due 5/15/2026
0.00 86.17 86.17
06/15/2023 Paydown 47787NAC3 10,383.15 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
741.51 2.52 744.03
06/15/2023 Paydown 47789KAC7 13,696.40 John Deere Owner Trust 2020-A A3
1.1% Due 8/15/2024
645.00 9.04 654.04
06/15/2023 Paydown 47789QAC4 45,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
1,954.73 18.65 1,973.38
06/15/2023 Paydown 89236XAC0 23,701.66 Toyota Auto Receivables 2020-D A3
0.35% Due 1/15/2025
934.26 5.26 939.52
06/15/2023 Paydown 89240BAC2 55,332.60 Toyota Auto Receivables Owners 2021-A A3
0.26% Due 5/15/2025
3,456.60 7.50 3,464.10
06/16/2023 Paydown 36265WAD5 30,000.00 GM Financial Securitized Auto 2022-3 A3
3.64% Due 4/16/2027
0.00 91.00 91.00
06/16/2023 Paydown 362554AC1 25,000.00 GM Financial Securitized Term 2021-4 A3
0.68% Due 9/16/2026
0.00 14.17 14.17
06/16/2023 Paydown 380146AC4 25,000.00 GM Financial Auto Receivables 2022-1 A3
1.26% Due 11/16/2026
0.00 26.25 26.25
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 46 XXXXXX
Cash Flow Report
As of November 30, 2022
City of Bell
Account #10531
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 06/18/2023 Paydown 43815PAC3 35,000.00 Honda Auto Receivables 2022-2 A3
3.73% Due 7/20/2026
0.00 108.79 108.79
06/18/2023 Paydown 43813KAC6 30,334.06 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
2,528.23 4.68 2,532.91
06/19/2023 Paydown 3137B5JM6 199,502.34 FHLMC K034 A2
3.531% Due 7/25/2023
356.07 0.84 356.91
06/20/2023 Paydown 36266FAC3 55,000.00 GM Financial Auto Lease Trust 2022-2 A3
3.42% Due 6/20/2025
0.00 156.75 156.75
06/20/2023 Paydown 92290BAA9 52,103.08 Verizon Owner Trust 2020-B A
0.47% Due 2/20/2025
1,924.45 15.89 1,940.34
06/20/2023 Paydown 92348AAA3 3,696.98 Verizon Owner Trust 2019-C A1A
1.94% Due 4/22/2024
204.22 4.01 208.23
06/21/2023 Paydown 43813GAC5 18,861.43 Honda Auto Receivables Trust 2021-1 A3
0.27% Due 4/21/2025
1,178.42 2.65 1,181.07
06/21/2023 Paydown 43815GAC3 35,000.00 Honda Auto Receivables Trust 2021-4 A3
0.88% Due 1/21/2026
1,587.39 24.50 1,611.89
06/25/2023 Interest 3137B5JM6 199,502.34 FHLMC K034 A2
3.531% Due 7/25/2023
0.00 459.31 459.31
06/25/2023 Paydown 05601XAC3 35,000.00 BMW Vehicle Lease Trust 2022-1 A3
1.1% Due 3/25/2025
3,126.34 29.23 3,155.57
06/25/2023 Paydown 09690AAC7 35,000.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due 12/26/2024
2,916.31 5.62 2,921.93
JUN 2023 253,596.02 13,070.36 266,666.38
07/06/2023 Interest 3133ENKS8 80,000.00 FFCB Note
1.125% Due 1/6/2025
0.00 450.00 450.00
07/10/2023 Maturity 3135G05G4 165,000.00 FNMA Note
0.25% Due 7/10/2023
165,000.00 206.25 165,206.25
07/15/2023 Interest 79466LAG9 20,000.00 Salesforce.com Inc Callable Note Cont 7/15/2022
0.625% Due 7/15/2024
0.00 62.50 62.50
07/15/2023 Paydown 89236XAC0 23,701.66 Toyota Auto Receivables 2020-D A3
0.35% Due 1/15/2025
931.02 4.99 936.01
07/15/2023 Paydown 44891RAC4 37,913.41 Hyundai Auto Receivables Trust 2020-C A3
0.38% Due 5/15/2025
2,527.56 6.41 2,533.97
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 47 XXXXXX
Cash Flow Report
As of November 30, 2022
City of Bell
Account #10531
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 07/15/2023 Paydown 47789KAC7 13,696.40 John Deere Owner Trust 2020-A A3
1.1% Due 8/15/2024
646.77 8.45 655.22
07/15/2023 Paydown 44935FAD6 25,000.00 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due 5/15/2026
1,248.23 14.65 1,262.88
07/15/2023 Paydown 47787JAC2 45,000.00 John Deere Owner Trust 2022-A A3
2.32% Due 9/16/2026
0.00 87.00 87.00
07/15/2023 Paydown 47787NAC3 10,383.15 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
741.80 2.21 744.01
07/15/2023 Paydown 47788UAC6 37,236.15 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
1,616.86 7.78 1,624.64
07/15/2023 Paydown 47789QAC4 45,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
1,954.90 17.81 1,972.71
07/15/2023 Paydown 65479JAD5 12,110.11 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
602.06 12.76 614.82
07/15/2023 Paydown 89240BAC2 55,332.60 Toyota Auto Receivables Owners 2021-A A3
0.26% Due 5/15/2025
3,457.72 6.75 3,464.47
07/15/2023 Paydown 43815BAC4 55,000.00 Honda Auto Receivables Trust 2022-1 A3
1.88% Due 5/15/2026
0.00 86.17 86.17
07/15/2023 Paydown 47800AAC4 45,000.00 John Deere Owner Trust 2022-B A3
3.74% Due 2/16/2027
0.00 140.25 140.25
07/15/2023 Paydown 58769KAD6 50,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
3,846.15 8.98 3,855.13
07/15/2023 Paydown 89232HAC9 35,661.07 Toyota Auto Receivable Own 2020-A A3
1.66% Due 5/15/2024
2,117.72 25.47 2,143.19
07/16/2023 Paydown 362554AC1 25,000.00 GM Financial Securitized Term 2021-4 A3
0.68% Due 9/16/2026
1,187.70 14.17 1,201.87
07/16/2023 Paydown 380146AC4 25,000.00 GM Financial Auto Receivables 2022-1 A3
1.26% Due 11/16/2026
0.00 26.25 26.25
07/16/2023 Paydown 36265WAD5 30,000.00 GM Financial Securitized Auto 2022-3 A3
3.64% Due 4/16/2027
0.00 91.00 91.00
07/17/2023 Interest 24422EVN6 95,000.00 John Deere Capital Corp Note
0.45% Due 1/17/2024
0.00 213.75 213.75
07/17/2023 Interest 61747YET8 60,000.00 Morgan Stanley Callable Note Cont 7/17/2025
4.679% Due 7/17/2026
0.00 1,403.70 1,403.70
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 48 XXXXXX
Cash Flow Report
As of November 30, 2022
City of Bell
Account #10531
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 07/18/2023 Paydown 43813KAC6 30,334.06 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
2,529.01 3.90 2,532.91
07/18/2023 Paydown 43815PAC3 35,000.00 Honda Auto Receivables 2022-2 A3
3.73% Due 7/20/2026
0.00 108.79 108.79
07/19/2023 Paydown 3137B5JM6 199,502.34 FHLMC K034 A2
3.531% Due 7/25/2023
70,007.88 164.80 70,172.68
07/20/2023 Paydown 36266FAC3 55,000.00 GM Financial Auto Lease Trust 2022-2 A3
3.42% Due 6/20/2025
0.00 156.75 156.75
07/20/2023 Paydown 92290BAA9 52,103.08 Verizon Owner Trust 2020-B A
0.47% Due 2/20/2025
1,925.20 15.14 1,940.34
07/20/2023 Paydown 92348AAA3 3,696.98 Verizon Owner Trust 2019-C A1A
1.94% Due 4/22/2024
204.68 3.68 208.36
07/21/2023 Paydown 43815GAC3 35,000.00 Honda Auto Receivables Trust 2021-4 A3
0.88% Due 1/21/2026
1,587.75 23.34 1,611.09
07/21/2023 Paydown 43813GAC5 18,861.43 Honda Auto Receivables Trust 2021-1 A3
0.27% Due 4/21/2025
1,178.70 2.39 1,181.09
07/25/2023 Interest 3137B5JM6 199,502.34 FHLMC K034 A2
3.531% Due 7/25/2023
0.00 253.31 253.31
07/25/2023 Paydown 05601XAC3 35,000.00 BMW Vehicle Lease Trust 2022-1 A3
1.1% Due 3/25/2025
3,140.05 26.36 3,166.41
07/25/2023 Paydown 09690AAC7 35,000.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due 12/26/2024
2,917.01 4.82 2,921.83
07/30/2023 Interest 91159HHX1 150,000.00 US Bancorp Callable Note Cont 6/28/2024
2.4% Due 7/30/2024
0.00 1,800.00 1,800.00
07/31/2023 Interest 912828V80 225,000.00 US Treasury Note
2.25% Due 1/31/2024
0.00 2,531.25 2,531.25
JUL 2023 269,368.77 7,991.83 277,360.60
08/06/2023 Interest 594918BX1 125,000.00 Microsoft Callable Note Cont 12/6/2023
2.875% Due 2/6/2024
0.00 1,796.88 1,796.88
08/06/2023 Interest 857477BR3 35,000.00 State Street Bank Callable Note Cont 2/6/2025
1.746% Due 2/6/2026
0.00 305.55 305.55
08/09/2023 Interest 69371RR40 50,000.00 Paccar Financial Corp Note
0.5% Due 8/9/2024
0.00 125.00 125.00
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 49 XXXXX
Cash Flow Report
As of November 30, 2022
City of Bell
Account #10531
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 08/15/2023 Interest 91282CCT6 250,000.00 US Treasury Note
0.375% Due 8/15/2024
0.00 468.75 468.75
08/15/2023 Paydown 43815BAC4 55,000.00 Honda Auto Receivables Trust 2022-1 A3
1.88% Due 5/15/2026
0.00 86.17 86.17
08/15/2023 Paydown 47800AAC4 45,000.00 John Deere Owner Trust 2022-B A3
3.74% Due 2/16/2027
0.00 140.25 140.25
08/15/2023 Paydown 44935FAD6 25,000.00 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due 5/15/2026
1,248.44 13.88 1,262.32
08/15/2023 Paydown 47787JAC2 45,000.00 John Deere Owner Trust 2022-A A3
2.32% Due 9/16/2026
0.00 87.00 87.00
08/15/2023 Paydown 47787NAC3 10,383.15 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
742.09 1.89 743.98
08/15/2023 Paydown 47789KAC7 13,696.40 John Deere Owner Trust 2020-A A3
1.1% Due 8/15/2024
648.54 7.86 656.40
08/15/2023 Paydown 47789QAC4 45,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
1,955.09 16.96 1,972.05
08/15/2023 Paydown 65479JAD5 12,110.11 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
603.42 11.79 615.21
08/15/2023 Paydown 89236XAC0 23,701.66 Toyota Auto Receivables 2020-D A3
0.35% Due 1/15/2025
927.75 4.71 932.46
08/15/2023 Paydown 89240BAC2 55,332.60 Toyota Auto Receivables Owners 2021-A A3
0.26% Due 5/15/2025
3,458.85 6.00 3,464.85
08/15/2023 Paydown 47788UAC6 37,236.15 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
1,617.39 7.29 1,624.68
08/15/2023 Paydown 58769KAD6 50,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
3,846.51 7.69 3,854.20
08/15/2023 Paydown 44891RAC4 37,913.41 Hyundai Auto Receivables Trust 2020-C A3
0.38% Due 5/15/2025
2,528.49 5.61 2,534.10
08/15/2023 Paydown 89232HAC9 35,661.07 Toyota Auto Receivable Own 2020-A A3
1.66% Due 5/15/2024
2,030.09 22.54 2,052.63
08/16/2023 Maturity 06406FAD5 125,000.00 Bank of NY Mellon Corp Callable Note Cont 6/16/2023
2.2% Due 8/16/2023
125,000.00 1,375.00 126,375.00
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 50 XXXXX
Cash Flow Report
As of November 30, 2022
City of Bell
Account #10531
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 08/16/2023 Paydown 362554AC1 25,000.00 GM Financial Securitized Term 2021-4 A3
0.68% Due 9/16/2026
1,187.98 13.49 1,201.47
08/16/2023 Paydown 36265WAD5 30,000.00 GM Financial Securitized Auto 2022-3 A3
3.64% Due 4/16/2027
0.00 91.00 91.00
08/16/2023 Paydown 380146AC4 25,000.00 GM Financial Auto Receivables 2022-1 A3
1.26% Due 11/16/2026
0.00 26.25 26.25
08/18/2023 Paydown 43815PAC3 35,000.00 Honda Auto Receivables 2022-2 A3
3.73% Due 7/20/2026
0.00 108.79 108.79
08/18/2023 Paydown 43813KAC6 30,334.06 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
2,529.79 3.12 2,532.91
08/19/2023 Paydown 3137B5JM6 199,502.34 FHLMC K034 A2
3.531% Due 7/25/2023
86,086.87 202.65 86,289.52
08/20/2023 Paydown 36266FAC3 55,000.00 GM Financial Auto Lease Trust 2022-2 A3
3.42% Due 6/20/2025
0.00 156.75 156.75
08/20/2023 Paydown 92348AAA3 3,696.98 Verizon Owner Trust 2019-C A1A
1.94% Due 4/22/2024
205.14 3.35 208.49
08/20/2023 Paydown 92290BAA9 52,103.08 Verizon Owner Trust 2020-B A
0.47% Due 2/20/2025
1,925.96 14.38 1,940.34
08/21/2023 Paydown 43813GAC5 18,861.43 Honda Auto Receivables Trust 2021-1 A3
0.27% Due 4/21/2025
1,178.99 2.12 1,181.11
08/21/2023 Paydown 43815GAC3 35,000.00 Honda Auto Receivables Trust 2021-4 A3
0.88% Due 1/21/2026
1,588.13 22.17 1,610.30
08/25/2023 Paydown 05601XAC3 35,000.00 BMW Vehicle Lease Trust 2022-1 A3
1.1% Due 3/25/2025
3,153.80 23.49 3,177.29
08/25/2023 Paydown 09690AAC7 35,000.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due 12/26/2024
2,917.73 4.01 2,921.74
AUG 2023 245,381.05 5,162.39 250,543.44
09/01/2023 Interest 46647PAH9 140,000.00 JP Morgan Chase & Co Callable Note 2X 3/1/2024
3.22% Due 3/1/2025
0.00 2,254.00 2,254.00
09/08/2023 Interest 3130AB3H7 225,000.00 FHLB Note
2.375% Due 3/8/2024
0.00 2,671.88 2,671.88
09/09/2023 Interest 931142EW9 30,000.00 Wal-Mart Stores Note
3.9% Due 9/9/2025
0.00 585.00 585.00
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 51 XXXXX
Cash Flow Report
As of November 30, 2022
City of Bell
Account #10531
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 09/09/2023 Interest 931142EX7 100,000.00 Wal-Mart Stores Callable Note Cont 09/09/2027
3.95% Due 9/9/2027
0.00 1,975.00 1,975.00
09/11/2023 Interest 89114QCB2 130,000.00 Toronto Dominion Bank Note
3.25% Due 3/11/2024
0.00 2,112.50 2,112.50
09/12/2023 Maturity 3135G0U43 225,000.00 FNMA Note
2.875% Due 9/12/2023
225,000.00 3,234.38 228,234.38
09/15/2023 Interest 437076CR1 40,000.00 Home Depot Callable Note Cont 8/15/2025 4% Due 9/15/2025
0.00 800.00 800.00
09/15/2023 Paydown 44935FAD6 25,000.00 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due 5/15/2026
1,248.64 13.11 1,261.75
09/15/2023 Paydown 47787JAC2 45,000.00 John Deere Owner Trust 2022-A A3
2.32% Due 9/16/2026
0.00 87.00 87.00
09/15/2023 Paydown 47789KAC7 13,696.40 John Deere Owner Trust 2020-A A3
1.1% Due 8/15/2024
650.33 7.26 657.59
09/15/2023 Paydown 89236XAC0 23,701.66 Toyota Auto Receivables 2020-D A3
0.35% Due 1/15/2025
924.44 4.44 928.88
09/15/2023 Paydown 47800AAC4 45,000.00 John Deere Owner Trust 2022-B A3
3.74% Due 2/16/2027
0.00 140.25 140.25
09/15/2023 Paydown 65479JAD5 12,110.11 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
604.78 10.82 615.60
09/15/2023 Paydown 89232HAC9 35,661.07 Toyota Auto Receivable Own 2020-A A3
1.66% Due 5/15/2024
1,942.09 19.73 1,961.82
09/15/2023 Paydown 43815BAC4 55,000.00 Honda Auto Receivables Trust 2022-1 A3
1.88% Due 5/15/2026
0.00 86.17 86.17
09/15/2023 Paydown 47787NAC3 10,383.15 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
742.38 1.58 743.96
09/15/2023 Paydown 47788UAC6 37,236.15 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
1,617.91 6.81 1,624.72
09/15/2023 Paydown 47789QAC4 45,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
1,955.27 16.11 1,971.38
09/15/2023 Paydown 58769KAD6 50,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
3,846.86 6.41 3,853.27
09/15/2023 Paydown 89240BAC2 55,332.60 Toyota Auto Receivables Owners 2021-A A3
0.26% Due 5/15/2025
3,459.97 5.25 3,465.22
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 52 XXXXX
Cash Flow Report
As of November 30, 2022
City of Bell
Account #10531
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 09/15/2023 Paydown 44891RAC4 37,913.41 Hyundai Auto Receivables Trust 2020-C A3
0.38% Due 5/15/2025
2,529.41 4.81 2,534.22
09/16/2023 Paydown 36265WAD5 30,000.00 GM Financial Securitized Auto 2022-3 A3
3.64% Due 4/16/2027
0.00 91.00 91.00
09/16/2023 Paydown 380146AC4 25,000.00 GM Financial Auto Receivables 2022-1 A3
1.26% Due 11/16/2026
1,139.13 26.25 1,165.38
09/16/2023 Paydown 362554AC1 25,000.00 GM Financial Securitized Term 2021-4 A3
0.68% Due 9/16/2026
1,188.26 12.82 1,201.08
09/17/2023 Interest 931142ER0 25,000.00 Wal-Mart Stores Callable Note Cont 08/17/2026
1.05% Due 9/17/2026
0.00 131.25 131.25
09/18/2023 Interest 808513BN4 160,000.00 Charles Schwab Corp Callable Note Cont 2/18/2024
0.75% Due 3/18/2024
0.00 600.00 600.00
09/18/2023 Paydown 43813KAC6 30,334.06 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
2,530.57 2.34 2,532.91
09/18/2023 Paydown 43815PAC3 35,000.00 Honda Auto Receivables 2022-2 A3
3.73% Due 7/20/2026
0.00 108.79 108.79
09/19/2023 Interest 459058GQ0 150,000.00 Intl. Bank Recon & Development Note
2.5% Due 3/19/2024
0.00 1,875.00 1,875.00
09/20/2023 Paydown 92348AAA3 3,696.98 Verizon Owner Trust 2019-C A1A
1.94% Due 4/22/2024
205.60 3.02 208.62
09/20/2023 Paydown 92290BAA9 52,103.08 Verizon Owner Trust 2020-B A
0.47% Due 2/20/2025
1,926.71 13.63 1,940.34
09/20/2023 Paydown 36266FAC3 55,000.00 GM Financial Auto Lease Trust 2022-2 A3
3.42% Due 6/20/2025
0.00 156.75 156.75
09/21/2023 Paydown 43815GAC3 35,000.00 Honda Auto Receivables Trust 2021-4 A3
0.88% Due 1/21/2026
1,588.50 21.01 1,609.51
09/21/2023 Paydown 43813GAC5 18,861.43 Honda Auto Receivables Trust 2021-1 A3
0.27% Due 4/21/2025
1,179.26 1.86 1,181.12
09/23/2023 Interest 4581X0DZ8 170,000.00 Inter-American Dev Bank Note
0.5% Due 9/23/2024
0.00 425.00 425.00
09/25/2023 Paydown 05601XAC3 35,000.00 BMW Vehicle Lease Trust 2022-1 A3
1.1% Due 3/25/2025
3,167.63 20.59 3,188.22
09/25/2023 Paydown 09690AAC7 35,000.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due 12/26/2024
2,918.43 3.21 2,921.64
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 53 XXXXX
Cash Flow Report
As of November 30, 2022
City of Bell
Account #10531
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 09/30/2023 Interest 91282CFM8 260,000.00 US Treasury Note
4.125% Due 9/30/2027
0.00 5,362.50 5,362.50
09/30/2023 Interest 9128286L9 275,000.00 US Treasury Note
2.25% Due 3/31/2026
0.00 3,093.75 3,093.75
09/30/2023 Interest 912828YG9 200,000.00 US Treasury Note
1.625% Due 9/30/2026
0.00 1,625.00 1,625.00
09/30/2023 Interest 912828ZF0 125,000.00 US Treasury Note
0.5% Due 3/31/2025
0.00 312.50 312.50
09/30/2023 Interest 91282CEF4 200,000.00 US Treasury Note
2.5% Due 3/31/2027
0.00 2,500.00 2,500.00
09/30/2023 Maturity 912828T26 225,000.00 US Treasury Note
1.375% Due 9/30/2023
225,000.00 1,546.88 226,546.88
SEP 2023 485,366.17 31,975.66 517,341.83
10/15/2023 Interest 91324PEN8 35,000.00 United Health Group Inc Note
5.15% Due 10/15/2025
0.00 901.25 901.25
10/15/2023 Paydown 44891RAC4 37,913.41 Hyundai Auto Receivables Trust 2020-C A3
0.38% Due 5/15/2025
2,530.34 4.01 2,534.35
10/15/2023 Paydown 47788UAC6 37,236.15 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
1,618.44 6.32 1,624.76
10/15/2023 Paydown 58769KAD6 50,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
3,847.21 5.13 3,852.34
10/15/2023 Paydown 89232HAC9 35,661.07 Toyota Auto Receivable Own 2020-A A3
1.66% Due 5/15/2024
1,853.71 17.05 1,870.76
10/15/2023 Paydown 43815BAC4 55,000.00 Honda Auto Receivables Trust 2022-1 A3
1.88% Due 5/15/2026
2,637.23 86.17 2,723.40
10/15/2023 Paydown 47787NAC3 10,383.15 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
742.67 1.26 743.93
10/15/2023 Paydown 47789KAC7 13,696.40 John Deere Owner Trust 2020-A A3
1.1% Due 8/15/2024
652.12 6.67 658.79
10/15/2023 Paydown 47789QAC4 45,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
1,955.45 15.26 1,970.71
10/15/2023 Paydown 89236XAC0 23,701.66 Toyota Auto Receivables 2020-D A3
0.35% Due 1/15/2025
921.10 4.17 925.27
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 54 XXXXX
Cash Flow Report
As of November 30, 2022
City of Bell
Account #10531
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 10/15/2023 Paydown 89240BAC2 55,332.60 Toyota Auto Receivables Owners 2021-A A3
0.26% Due 5/15/2025
3,461.10 4.50 3,465.60
10/15/2023 Paydown 44935FAD6 25,000.00 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due 5/15/2026
1,248.85 12.34 1,261.19
10/15/2023 Paydown 47787JAC2 45,000.00 John Deere Owner Trust 2022-A A3
2.32% Due 9/16/2026
1,847.48 87.00 1,934.48
10/15/2023 Paydown 47800AAC4 45,000.00 John Deere Owner Trust 2022-B A3
3.74% Due 2/16/2027
0.00 140.25 140.25
10/15/2023 Paydown 65479JAD5 12,110.11 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
606.13 9.85 615.98
10/16/2023 Interest 45950KCR9 100,000.00 International Finance Corp Note
1.375% Due 10/16/2024
0.00 687.50 687.50
10/16/2023 Maturity 3137EAEY1 150,000.00 FHLMC Note
0.125% Due 10/16/2023
150,000.00 93.75 150,093.75
10/16/2023 Paydown 362554AC1 25,000.00 GM Financial Securitized Term 2021-4 A3
0.68% Due 9/16/2026
1,188.53 12.15 1,200.68
10/16/2023 Paydown 380146AC4 25,000.00 GM Financial Auto Receivables 2022-1 A3
1.26% Due 11/16/2026
1,144.13 25.05 1,169.18
10/16/2023 Paydown 36265WAD5 30,000.00 GM Financial Securitized Auto 2022-3 A3
3.64% Due 4/16/2027
0.00 91.00 91.00
10/18/2023 Paydown 43815PAC3 35,000.00 Honda Auto Receivables 2022-2 A3
3.73% Due 7/20/2026
0.00 108.79 108.79
10/18/2023 Paydown 43813KAC6 30,334.06 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
2,531.35 1.56 2,532.91
10/20/2023 Paydown 36266FAC3 55,000.00 GM Financial Auto Lease Trust 2022-2 A3
3.42% Due 6/20/2025
0.00 156.75 156.75
10/20/2023 Paydown 92290BAA9 52,103.08 Verizon Owner Trust 2020-B A
0.47% Due 2/20/2025
1,927.47 12.87 1,940.34
10/20/2023 Paydown 92348AAA3 3,696.98 Verizon Owner Trust 2019-C A1A
1.94% Due 4/22/2024
206.06 2.69 208.75
10/21/2023 Paydown 43813GAC5 18,861.43 Honda Auto Receivables Trust 2021-1 A3
0.27% Due 4/21/2025
1,179.55 1.59 1,181.14
10/21/2023 Paydown 43815GAC3 35,000.00 Honda Auto Receivables Trust 2021-4 A3
0.88% Due 1/21/2026
1,588.87 19.84 1,608.71
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 55 XXXXX
Cash Flow Report
As of November 30, 2022
City of Bell
Account #10531
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 10/25/2023 Interest 06406RBC0 60,000.00 Bank of NY Mellon Corp Callable Note Cont 3/25/2025
3.35% Due 4/25/2025
0.00 1,005.00 1,005.00
10/25/2023 Paydown 05601XAC3 35,000.00 BMW Vehicle Lease Trust 2022-1 A3
1.1% Due 3/25/2025
3,181.52 17.69 3,199.21
10/25/2023 Paydown 09690AAC7 35,000.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due 12/26/2024
2,919.13 2.41 2,921.54
OCT 2023 189,788.44 3,539.87 193,328.31
11/01/2023 Interest 78015K7C2 135,000.00 Royal Bank of Canada Note
2.25% Due 11/1/2024
0.00 1,518.75 1,518.75
11/06/2023 Maturity 3137EAEZ8 220,000.00 FHLMC Note
0.25% Due 11/6/2023
220,000.00 275.00 220,275.00
11/07/2023 Interest 3135G06G3 225,000.00 FNMA Note
0.5% Due 11/7/2025
0.00 562.50 562.50
11/08/2023 Interest 69371RR57 90,000.00 Paccar Financial Corp Note
0.9% Due 11/8/2024
0.00 405.00 405.00
11/10/2023 Interest 665859AW4 150,000.00 Northern Trust Company Callable Note Cont 4/10/2027
4% Due 5/10/2027
0.00 3,000.00 3,000.00
11/12/2023 Interest 023135BW5 85,000.00 Amazon.com Inc Note
0.45% Due 5/12/2024
0.00 191.25 191.25
11/15/2023 Interest 912828R36 265,000.00 US Treasury Note
1.625% Due 5/15/2026
0.00 2,153.13 2,153.13
11/15/2023 Interest 912828X88 275,000.00 US Treasury Note
2.375% Due 5/15/2027
0.00 3,265.63 3,265.63
11/15/2023 Interest 912828U24 265,000.00 US Treasury Note 2% Due 11/15/2026
0.00 2,650.00 2,650.00
11/15/2023 Interest 91282CDH1 225,000.00 US Treasury Note
0.75% Due 11/15/2024
0.00 843.75 843.75
11/15/2023 Interest 912828WJ5 200,000.00 US Treasury Note
2.5% Due 5/15/2024
0.00 2,500.00 2,500.00
11/15/2023 Paydown 47787NAC3 10,383.15 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
742.96 0.95 743.91
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 56 XXXXXX
Cash Flow Report
As of November 30, 2022
City of Bell
Account #10531
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 11/15/2023 Paydown 47788UAC6 37,236.15 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
1,618.96 5.84 1,624.80
11/15/2023 Paydown 47789QAC4 45,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
1,955.62 14.42 1,970.04
11/15/2023 Paydown 65479JAD5 12,110.11 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
607.50 8.87 616.37
11/15/2023 Paydown 89240BAC2 55,332.60 Toyota Auto Receivables Owners 2021-A A3
0.26% Due 5/15/2025
3,462.22 3.75 3,465.97
11/15/2023 Paydown 43815BAC4 55,000.00 Honda Auto Receivables Trust 2022-1 A3
1.88% Due 5/15/2026
2,648.80 82.03 2,730.83
11/15/2023 Paydown 47800AAC4 45,000.00 John Deere Owner Trust 2022-B A3
3.74% Due 2/16/2027
0.00 140.25 140.25
11/15/2023 Paydown 89232HAC9 35,661.07 Toyota Auto Receivable Own 2020-A A3
1.66% Due 5/15/2024
1,764.97 14.48 1,779.45
11/15/2023 Paydown 44891RAC4 37,913.41 Hyundai Auto Receivables Trust 2020-C A3
0.38% Due 5/15/2025
2,531.26 3.21 2,534.47
11/15/2023 Paydown 47789KAC7 13,696.40 John Deere Owner Trust 2020-A A3
1.1% Due 8/15/2024
653.91 6.07 659.98
11/15/2023 Paydown 89236XAC0 23,701.66 Toyota Auto Receivables 2020-D A3
0.35% Due 1/15/2025
917.71 3.91 921.62
11/15/2023 Paydown 44935FAD6 25,000.00 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due 5/15/2026
1,249.06 11.57 1,260.63
11/15/2023 Paydown 47787JAC2 45,000.00 John Deere Owner Trust 2022-A A3
2.32% Due 9/16/2026
1,849.85 83.43 1,933.28
11/15/2023 Paydown 58769KAD6 50,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
3,847.56 3.85 3,851.41
11/16/2023 Paydown 36265WAD5 30,000.00 GM Financial Securitized Auto 2022-3 A3
3.64% Due 4/16/2027
0.00 91.00 91.00
11/16/2023 Paydown 362554AC1 25,000.00 GM Financial Securitized Term 2021-4 A3
0.68% Due 9/16/2026
1,188.81 11.47 1,200.28
11/16/2023 Paydown 380146AC4 25,000.00 GM Financial Auto Receivables 2022-1 A3
1.26% Due 11/16/2026
1,149.14 23.85 1,172.99
11/17/2023 Interest 14913R2L0 135,000.00 Caterpillar Financial Service Note
0.45% Due 5/17/2024
0.00 303.75 303.75
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 57 XXXXX
Cash Flow Report
As of November 30, 2022
City of Bell
Account #10531
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 11/18/2023 Paydown 43815PAC3 35,000.00 Honda Auto Receivables 2022-2 A3
3.73% Due 7/20/2026
0.00 108.79 108.79
11/18/2023 Paydown 43813KAC6 30,334.06 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
2,532.13 0.78 2,532.91
11/20/2023 Paydown 92348AAA3 3,696.98 Verizon Owner Trust 2019-C A1A
1.94% Due 4/22/2024
206.53 2.35 208.88
11/20/2023 Paydown 92290BAA9 52,103.08 Verizon Owner Trust 2020-B A
0.47% Due 2/20/2025
1,928.22 12.12 1,940.34
11/20/2023 Paydown 36266FAC3 55,000.00 GM Financial Auto Lease Trust 2022-2 A3
3.42% Due 6/20/2025
0.00 156.75 156.75
11/21/2023 Paydown 43813GAC5 18,861.43 Honda Auto Receivables Trust 2021-1 A3
0.27% Due 4/21/2025
1,179.83 1.33 1,181.16
11/21/2023 Paydown 43815GAC3 35,000.00 Honda Auto Receivables Trust 2021-4 A3
0.88% Due 1/21/2026
1,589.24 18.68 1,607.92
11/24/2023 Maturity 459058JM6 105,000.00 Intl. Bank Recon & Development Note
0.25% Due 11/24/2023
105,000.00 131.25 105,131.25
11/25/2023 Paydown 05601XAC3 35,000.00 BMW Vehicle Lease Trust 2022-1 A3
1.1% Due 3/25/2025
3,195.46 14.77 3,210.23
11/25/2023 Paydown 09690AAC7 35,000.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due 12/26/2024
2,919.83 1.61 2,921.44
11/30/2023 Interest 912828ZT0 250,000.00 US Treasury Note
0.25% Due 5/31/2025
0.00 312.50 312.50
11/30/2023 Interest 91282CAZ4 175,000.00 US Treasury Note
0.375% Due 11/30/2025
0.00 328.13 328.13
NOV 2023 364,739.57 19,266.77 384,006.34
TOTAL 3,435,653.19 175,932.22 3,611,585.41
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 58 XXXXX
Important Disclosures
City of Bell
Account #10531
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: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 59 XXXXX
Benchmark Index & Disclosures
City of Bell
Account #10531
Benchmark Index Disclosure
ICE BofA 1-3 Yr US Treasury & Agency
Index
The ICE BofA 1-3 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 three 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.
Execution Time: 12/1/2022 8:17:09 PMChandler Asset Management - CONFIDENTIAL Page 60 XXXXX