Agenda
Regular Meeting of the
B
ell City Council/Bell Community Housing Authority/Successor Agency to the Bell Community Redevelopment Agency/ Bell Public Finance Authority Wednesday, February 28, 2024
6 :00 P.M. CLOSED SESSION
7:00 P.M. OPEN SESSION
BEL
L COMMUNITY CENTER
6250 PINE AVENUE, BELL CA 90201
Fidencio J. Gallardo
Mayor
Ana Maria Quintana Monica Arroyo
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. Please 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 Membe
rs 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
February 28, 2024
REGULAR JOINT MEETING OF THE
B
ell City Council/Bell Community Housing Authority/Successor Agency to the Bell Community Redevelopment Agency/Bell Public Finance Authority Febr
uary 28, 2024
6:
00 P.M. Closed Session Meeting
7:00 P.M. Regular Meeting
Locat
ion: Bell Community Center, 6250 Pine Avenue, Bell CA 90201
C
all to Order
R
oll Call of the City Council in their capacities as Councilmembers/Members of all Related Agencies: Arroyo, Romero, Saleh, Quintana, and Gallardo C
ommunications from the Public on Closed Session Items
Thi
s 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.
C
losed Session
The C
ity Council and the related Authorities and Agencies will recess to closed session to confer with legal counsel regarding the following matters:
a. C
ONFERENCE WITH REAL PROPERTY NEGOTIATORS (Pursuant to Government Code section 54956.8)
Property: 4410 Gage Avenue, Bell CA 90201
Agency negotiators: Michael L. Antwine II (City Manager), and Dave Aleshire (City Attorney)
Negotiating parties: To be Determi
ned
b. C
ONFERENCE WITH REAL PROPERTY NEGOTIATORS (Pursuant to Government Code section 54956.8)
Property: 5107 Filmore Avenue, Bell CA 90201
Agency negotiators: Michael L. Antwine II (City Manager), and Dave Aleshire (City Attorney)
Negotiating parties: To be Determi
ned
MEETING WILL BE HELD IN-PERSON AT THE BELL COMMUNITY CENTER P
UBLIC 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 submit 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, February 28, 2024.
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
February 28, 2024
c. CONFERENCE WITH REAL PROPERTY NEGOTIATORS (Pursuant to Government Code section 54956.8)
Properties: 6317-023-19, 6317-029-018, 6317-023-009, 6317-023-008, and 6317-023-007 Agency negotiators: Michael L. Antwine II (City Manager), and Dave Aleshire (City Attorney)
Negotiating parties: To be Determi
ned
d. P
otential Initiation of litigation pursuant Government Code Section 54956.9(d)(4): One Ca
se
e. CO
NFERENCE WITH LABOR NEGOTIATORS- Government Code Section 54957.6, Agency designated representatives: Michael L. Antwine II (City Manager), and Dave A
leshire (City Attorney) Employee Organization: Bell Police Officers Association (BPOA) R
econvene Regular City Council Meeting
C
all to Order
R
oll Call of the City Council in their capacities as Councilmembers/Members of all Related Agencies: Arroyo, Romero, Saleh, Quintana and Gallardo P
ledge of Allegiance
C
ity Attorney Report
The C
ity Attorney will report out on any action(s) to be taken by the City Council/Agencies on Closed Session matters.
P
resentations and Recognitions
a. P
roclamation declaring the month of March 2024 as Bleeding Disorders Awareness Month
b. Introduction of New City Employees
C
ommunications from the Public
Thi
s 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)
M
ayor and City Council Communications
P
ursuant 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.
C
ity Manager Report
I
n 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
February 28, 2024
Business Session
1. The For
mation of A Public Art Program. (City Council)
R
ecommendation: It is recommended that the City Council provide staff with direction to further develop an Arts in Public Places Program.
2. C
onsideration to approve a new Contract Service Agreement with Kosmont Real Estat e S
ervices dba Kosmont Realty for Pre -Disposition Real Estate Advisory/Due Diligenc e S
ervices for city-owned properties that are required to undergo the Surplus Land Act (SLA) process. (City Council)
R
ecommendation: It is recommended that the City Council approve a new Contact Service Agreement with Kosmont Real Estate Services for Pre-Disposition Real Estate Advisory/Due Diligence Services not to exceed $50,000.
3. M
id-Year Budget Report for Fiscal Year 2023-24. (City Council) R
ecommendation: It is recommended that the City Council receive and file the Mid-Year Budget Report for Fiscal Year 2023-24.
C
onsent Calendar
The f
ollowing 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.
R
ecommendation: Approve agenda items 4 through 7.
4. R
eceive and File Donations Reports for the month of August 2023 through December 2023. (City Council)
5 . Receive and File the City of Bell & Bell Successor Agency Investment Reports as of January 2024. (City Council)
6. G
eneral Warrants, Successor Agency to the Bell Community Redevelopment Agency and Community Housing Authority Warrants of February 28 , 2024. (Council/Successor Agency to the Bell Community Redevelopment Agency/Bell Community Housing Authority). 7 . Minutes for the Regular City Council Meetings of November 9, 2022, and January 24, 2024, and f
or the Special City Council Meeting of October 7, 2023. (City Council/Successor Agency to the Bell Community Redevelopment Agency)
P
ending Items – None
N
ext Regular Meeting, Wednesday, March 13, 2024
I
, Angela Bustamante, City Clerk of the City of Bell, certify that a true, accurate copy of the foregoing agenda was posted February 25, 2024 at least seventy-two (72) hours prior to the meeting as required by law.
__________________________
Angela Bustamante, City Clerk
REGULAR MEETING OF THE
BE
LL CITY COUNCIL AND RELATED AGENCIES
Fe
bruary 28, 2024
6:00
P.M. Closed Session
7:00 P.M. Regular Session
I
NDEX
A
genda Category Item Number Page Numbers
C
LOSED SESSION a – e
AG
ENDA & INDEX 1-6
P
UBLIC HEARINGS None
B
USINESS SESSION 1 7
2 8-18
3 19
CO
NSENT CALENDAR 4 20-25
5 26-114
6 115-168
7 169-187
UNDER SEPARATE COVER
AGENDA ITEM NO. 3
3. Mi d -Year Budget Report for Fiscal Year 2023-24. (City Council) R
ecommendation: It is recommended that the City Council
receive and file the Mid-Year Budget Report for Fiscal Year 2023-24.
Report Date: 2/28/24
Issuer / Book Market % of YTM
CUSIP Security Value Value * Portfolio (Market Y)
LAIF 20,971,692 20,971,692 65.60% 3.93%
See Attached Asset-Backed Security 904,093 902,164 2.90% 5.93% See Attached Agency Issues 1,333,253 1,313,889 4.11% 5.33% See Attached Commercial Mortagage 734,211 740,383 2.32% 5.44% See Attached Commercial Paper 201,350 201,350 0.63% 5.93% See Attached Corporate 2,591,359 2,576,459 8.06% 5.78%
See Attached Money Market 102,864 102,864 0.33% 4.97%
See Attached Municipal Bonds 101,532 104,820 0.33% 5.43% See Attached Supranational 963,475 963,648 3.02% 5.37%
See Attached US Treasury 4,128,411 4,026,154 12.60% 5.15% Accrued Interest 65,882 0.21%
Totals 32,032,242$ 31,969,305$ 100%
Bank Account Balances:
Wells Fargo Bank Stagecoach Sweep General Checking: 6,095,521.10$ Wells Fargo Bank Commercial Checking Choice IV-Public Funds: 78,533.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
67,111.23
6,241,165.33$
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 1/31/2024.
City of Bell Investment Report
LAIF Deposit and Core Investments
January 2024
MONTH FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24
JULY 25,320,562.61$ 27,158,657.80$ 36,441,274.21$ 34,062,482.19$ AUGUST 23,739,062.20 28,268,929.13 35,223,821.96$ 33,390,312.50$ SEPTEMBER 21,690,804.87 26,397,025.57 32,811,437.12$ 34,034,650.49$ OCTOBER 21,605,826.32 26,237,986.42 31,444,024.32$ 33,199,454.80$ NOVEMBER 22,017,659.98 25,741,196.73 31,238,472.56$ 32,354,418.96$ DECEMBER 24,124,656.89 28,966,073.71 33,614,575.25$ 33,684,522.39$ JANUARY 27,425,271.30 33,505,081.56 36,436,046.86$ 38,273,406.85$ FEBRUARY 25,221,695.57 33,233,351.99 37,509,622.83$ MARCH 25,161,017.39 32,837,890.46 36,515,694.26$
APRIL 25,811,974.54 34,829,178.84 37,952,579.87$
MAY 28,685,142.78 37,384,223.90 41,029,417.85$
JUNE 28,279,502.12 38,524,813.01 41,641,408.12$
City of Bell
Historical Summary of Invested Funds & Bank Deposits
Report Date: 2/28/24
Issuer / Book Market % of YTM
Security Value Value * Portfolio (Purchase Y)
LAIF 674,809 674,809 100.00% 3.93%
Totals 674,809$ 674,809$ 100.00% Bank Account Balances:
Wells Fargo Bank Successor to RDA: 1,153,257.45$
* 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. * Current market valuation is required for investments with maturities of more than twelve months. MV includes accrued interest earned as of 06/30/2023.
Bell Successor Agency Investment Report
January 2024
All Investments
MONTH FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24
JULY 2,652,039.24$ 2,634,143.35$ 2,596,401.97$ 2,926,113.98$ AUGUST 2,653,373.37 2,601,063.64 2,591,745.15$ 2,925,008.88$ SEPTEMBER 986,026.30 890,531.10 852,536.05$ 1,235,549.02$ OCTOBER 995,957.79 886,165.69 856,629.31$ 1,258,468.03$ NOVEMBER 995,957.04 876,829.70 843,758.80$ 1,257,061.62$ DECEMBER 995,914.01 873,108.41 841,336.47$ 1,499,506.53$ JANUARY 1,895,562.17 1,459,106.09 1,265,533.12$ 1,828,066.88$ FEBRUARY 1,747,081.95 1,325,546.77 1,262,014.62$
MARCH 1,140,655.41 1,014,355.71 1,077,986.33$
APRIL 1,144,094.97 1,000,743.36 1,073,088.31$
MAY 1,131,195.10 994,985.29 1,044,488.11$
JUNE 2,770,827.46 2,595,074.09 2,912,224.74$
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 01/01/2024 THROUGH 01/31/2024
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
Date Description Amount
1 01 2024 Beginning Balance 1,776,099.70
1 02 2024 Sweep Funds Return To DDA 105,253.56
1 02 2024 Reinvested Dividend 6,934.39
1 03 2024 Next Day Sweep Purchase 1,182,106.52
1 04 2024 Next Day Sweep Purchase 15,282.63
1 05 2024 Sweep Funds Return To DDA 85,894.52
1 08 2024 Sweep Funds Return To DDA 66,211.23
1 09 2024 Next Day Sweep Purchase 1,991.83
1 10 2024 Next Day Sweep Purchase 4,755.31
1 11 2024 Next Day Sweep Purchase 10,359.33
1 12 2024 Sweep Funds Return To DDA 204,411.46
1 16 2024 Next Day Sweep Purchase 73,774.55
1 17 2024 Sweep Funds Return To DDA 405,546.97
1 18 2024 Sweep Funds Return To DDA 70,708.77
1 19 2024 Sweep Funds Return To DDA 230,274.78
1 22 2024 Next Day Sweep Purchase 3,015,004.27
1 23 2024 Next Day Sweep Purchase 4,451.79
1 24 2024 Sweep Funds Return To DDA 89,888.76
1 25 2024 Next Day Sweep Purchase 744,615.44
1 26 2024 Next Day Sweep Purchase 32,317.59
1 29 2024 Next Day Sweep Purchase 147,612.43
1 30 2024 Next Day Sweep Purchase 55,068.76
1 31 2024 Next Day Sweep Purchase 283,336.61
1 31 2024 Ending Balance 6,095,521.10
Daily Balance Information
Date Investment Balance Annualized Fund Yield Daily Dividend Factor Daily Accrual 01 01* 1,677,780.53 4.860 % .000133158 223.41
01 02 1,677,780.53 4.845 % .000132742 222.71
01 03 2,859,887.05 4.825 % .000132215 378.12
01 04 2,875,169.68 4.824 %
.000132176 380.03
01 05 2,789,275.16 4.815 % .000131919 367.96
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
FUND SUMMARY
Dividends Earned YTD 13,965.43
Federal Withholding YTD .00
7 Day Simple Yield 4.81961 %
Federal Withholding .00
Beginning Balance 1,776,099.70
Prior Months Dividends Reinvested 6,934.39 +
Shares Purchased 5,570,677.06 +
Shares Redeemed 1,258,190.05
Ending Balance 6,095,521.10
Dividends Earned in Current Month 13,965.43
Funds Pending Redemption 51,338.70
STAGECOACH SWEEP
Date Investment Balance Annualized Fund Yield Daily Dividend Factor Daily Accrual 01 06* 2,723,063.93 4.815 % .000131919 359.22
01 07* 2,723,063.93 4.815 % .000131919 359.22
01 08 2,723,063.93 4.821 % .000132087 359.68
01 09 2,725,055.76 4.819 % .000132040 359.82
01 10 2,729,811.07 4.816 % .000131954 360.21
01 11 2,740,170.40 4.815 % .000131939 361.54
01 12 2,535,758.94 4.816 % .000131949 334.59
01 13* 2,535,758.94 4.816 % .000131949 334.59
01 14* 2,535,758.94 4.816 % .000131949 334.59
01 15* 2,535,758.94 4.816 % .000131949 334.59
01 16 2,609,533.49 4.814 % .000131915 344.24
01 17 2,203,986.52 4.809 % .000131774 290.43
01 18 2,133,277.75 4.817 % .000131994 281.58
01 19 1,903,002.97 4.815 % .000131942 251.09
01 20* 1,903,002.97 4.815 % .000131942 251.09
01 21* 1,903,002.97 4.815 % .000131942 251.09
01 22 4,918,007.24 4.800 % .000131508 646.76
01 23 4,922,459.03 4.818 % .000132007 649.80
01 24 4,832,570.27 4.816 % .000131960 637.71
01 25 5,577,185.71 4.817 % .000131976 736.05
01 26 5,609,503.30 4.817 % .000131973 740.30
01 27* 5,609,503.30 4.817 % .000131973 740.30
01 28* 5,609,503.30 4.817 % .000131973 740.30
01 29 5,757,115.73 4.818 % .000132022 760.07
01 30 5,812,184.49 4.818 % .000132010 767.27
01 31 6,095,521.10 4.832 % .000132407 807.09
TOTAL MTD 13,965.45
* 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.
01/01/2024 01/31/2024
Account Number DDA
Choice IV-Public Funds {NIB}
Account number: January 1, 2024 - January 31, 2024 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 $50,000.00 $8,092,786.65 -$8,064,253.65 $78,533.00
Credits
Deposits
Effective
date
Posted
date Amount
Transaction detail
01/16 01/17 4,861.61 Reversal of Check Posted 1-16-24 Refer to Maker Our Ref: 1-16-24 00000000 01/18 01/19 1,091.48 Reversal of Check Posted 1-18-24 Refer to Maker Our Ref: 1-18-24 00000000 $5,953.09 Total deposits
Electronic deposits/bank credits
Effective
date
Posted
date Amount
Transaction detail
01/02 14.85 Southern Califor Single 240102
Just*Energy*Uut*Payment*20231122000070U121323\
01/02 165.97 Desktop Check Deposit
01/02 2,368.31 CC Tm PA LLC Cci AP 820 231221 02959807 31**\Ref*PO*00514644\Dtm*003*240101\SE*8*0001\GE*
01/02 3,556.78 Cctm1 LLC Cci AP 820 231221 02959254
78**\Ref*PO*00514710\Dtm*003*240101\SE*8*0001\GE*
01/02 3,848.00 LA County Gen-Pymt 231227 500110 NTE*202312275979604 *A2400367359 *500110
01/02 26,188.01 LA County Gen-Pymt 231227 Pta-11600 NTE*202312275977931 *A2400365686 *Pta-11600
01/02 35,633.55 Southern Califor Single 240102 SCG*Uut*Payment*20231122000070U121423\ 01/02 44,154.12 Desktop Check Deposit
01/02 52,316.48 Lacmta Corp Pmt 1201556
2316.48~Dtm|003|20231219~SE|33|0234~GE|0001|20009
01/02 307,586.14 LA County Gen-Pymt 231227 500110 NTE*202312275979267 *A2400367022 *500110
01/02 806,811.18 LA County Gen-Pymt 231227 Pta-11600 NTE*202312275977932 *A2400365687 *Pta-11600
Sheet Seq = 0018580
Sheet 00001 of 00008
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
Account number: January 1, 2024 - January 31, 2024 Page 2 of 8 Prior account number: 145398000
Electronic deposits/bank credits (continued)
Effective
date
Posted
date Amount
Transaction detail
01/02 348.00 ZBA Funding Account Transfer From
01/03 12.00 Cash Only Customer Deposit
01/03 24.00 01/03Bankcard Deposit -0328029701
01/03 237.74 01/03Bankcard Deposit -0328029700
01/03 263.90 Active Network, Registrati 000000006106305 Rmr*IV*13881038**263.9*263.9*0\Ref*PO*RN 0011549
01/03 300.25 Cash Only Customer Deposit
01/03 326.00 01/03Bankcard Deposit -0328029701
01/03 1,910.21 Cash Only Customer Deposit
01/03 8,115.00 WT Seq456587 City of Bell, Successor /Org=City of Bell Srf# Gb00000064266851 Trn#240103456587 Rfb# 2879
01/03 12,377.52 01/03Bankcard Deposit -0328029700
01/03 48,678.89 Desktop Check Deposit
01/04 228.90 01/04Bankcard Deposit -0328029700
01/04 11,910.05 Desktop Check Deposit
01/04 67,294.39 Apport St of CA Apsapports 122923 388 Bell City Treasurer 01/04 79,800.68 ZBA Funding Account Transfer From
01/04 85,894.52 Sweep Transfer From Investment
01/05 10.00 01/05Bankcard Deposit -0328029700
01/05 20.00 Cash Only Customer Deposit
01/05 35.00 01/05Bankcard Deposit -0328029701
01/05 886.62 Square Inc 240105P2 240105 L210850196449 City of Bell 01/05 1,026.10 Cash Only Customer Deposit
01/05 1,317.66 01/05Bankcard Deposit -0328029700
01/05 56,299.32 Desktop Check Deposit
01/05 66,211.23 Sweep Transfer From Investment
01/08 199.88 Cash Only Customer Deposit
01/08 708.48 01/08Bankcard Deposit -0328029700
01/08 9,975.26
01/08Bankcard Deposit -0328029700
01/08 20,050.00 Desktop Check Deposit
01/09 15.00 01/09Bankcard Deposit -0328029701
01/09 114.42 01/09Bankcard Deposit -0328029700
01/09 341.98 Square Inc 240109P2 240109 L210850780829 City of Bell 01/09 998.88 01/09Bankcard Deposit -0328029700
01/09 10,040.23 Desktop Check Deposit
01/10 24.00 01/10Bankcard Deposit -0328029701
01/10 74.88 01/10Bankcard Deposit -0328029700
01/10 209.00 01/10Bankcard Deposit -0328029701
01/10 260.41 Square Inc 240110P2 240110 L210850949415 City of Bell 01/10 530.93 01/10Bankcard Deposit -0328029700
01/10 27,589.11 Desktop Check Deposit
01/11 10.00 01/11Bankcard Deposit -0328029700
01/11 24.00 01/11Bankcard Deposit -0328029701
01/11 35.00 Cash Only Customer Deposit
01/11 115.46 Desktop Check Deposit
01/11 116.96 Ce Solutions D Operating Fgwap0000675929 Cagasuut2312 01/11 236.14 Square Inc 240111P2 240111 L210851126267 City of Bell 01/11 253.35 Cash Only Customer Deposit
01/11 297.08 01/11Bankcard Deposit -0328029700
Sheet Seq = 0018581
Sheet 00002 of 00008
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
Account number: January 1, 2024 - January 31, 2024 Page 3 of 8 Prior account number: 145398000
Electronic deposits/bank credits (continued)
Effective
date
Posted
date Amount
Transaction detail
01/11 2,132.25 Active Network, Registrati 000000006109080 Rmr*IV*13886092**2132.25*2132.25*0\Ref*PO*RN 0011
01/11 2,611.32 WT Fed#04408 Bank of America, N /Org=PMAm Corporation Aaf City of Bell Srf# 2024011100440193 Trn#240111139729 Rfb# Dec 23 Alarmfee
01/11 11,375.88 Ce Solutions D Operating Fgwap0000675842 Caelectricityuut2312 01/11 204,411.46 Sweep Transfer From Investment
01/12 10.00 01/12Bankcard Deposit -0328029700
01/12 146.63 Cash Only Customer Deposit
01/12 209.00 01/12Bankcard Deposit -0328029701
01/12 942.92 Square Inc 240112P2 240112 L210851321883 City of Bell 01/12 72,357.00 Lacounty Develop Payment 240112 0000000895 Rmr*IV*57418**72357\ 01/16 2,712.95 Square Inc 240115P2 240115 L210851739692 City of Bell 01/16 6,020.69 Desktop Check Deposit
01/16 174,026.06 Southern Califor EDI Paymts 2401100001 003*231201***20^Dtm*003*231231***20^SE*15*96452^G
01/16 405,546.97 Sweep Transfer From Investment
01/17 6.96 Square Inc 240117P2 240117 L210852090002 City of Bell 01/17 13.00 01/17Bankcard Deposit -0328029701
01/17 98.00 Cash Only Customer Deposit
01/17 103.20 01/17Bankcard Deposit -0328029700
01/17 140.22 01/17Bankcard Deposit -0328029700
01/17 218.60 Cash Only Customer Deposit
01/17 875.48 Cash Only Customer Deposit
01/17 5,206.96 Desktop Check Deposit
01/17 70,708.77 Sweep Transfer From Investment
01/18 114.42 01/18Bankcard Deposit -0328029700
01/18 228.98 01/18Bankcard Deposit -0328029700
01/18 297.00 01/18Bankcard Deposit -0328029701
01/18 3,137.34 Active Network, Registrati 000000006111052 Rmr*IV*13889818**3137.34*3137.34*0\Ref*PO*RN 0011
01/18 64,099.33
Desktop Check Deposit
01/18 87,384.57 ZBA Funding Account Transfer From
01/18 230,274.78 Sweep Transfer From Investment
01/19 389.60 01/19Bankcard Deposit -0328029700
01/19 668.77 Square Inc 240119P2 240119 L210852463114 City of Bell 01/19 1,593.33 Cash Only Customer Deposit
01/19 3,058.96 Cash Only Customer Deposit
01/19 5,081.07 Desktop Check Deposit
01/19 14,354.00 Lacounty Develop Payment 240119 0000000895 Rmr*IV*58605**14354\ 01/19 3,240,974.70 LA County Gen-Pymt 240116 Pta-11600 NTE*202401165997947 *A2400394611 *Pta-11600
01/22 150.36 Square Inc 240122P2 240122 L210852888114 City of Bell 01/22 225.51 01/22Bankcard Deposit -0328029700
01/22 229.00 01/22Bankcard Deposit -0328029701
01/22 940.50 LA County Gen-Pymt 240117 500110 NTE*202401176001192 *A2400397860 *500110
01/22 2,401.73 Amer Tower 1942 EDI Paymnt Jan 20 43Rent_40010089 M*003*20240201\SE*16*000007189\GE*000001*06041412
01/22 10,448.35 Desktop Check Deposit
01/22 61,582.10 Apport St of CA Apsapports 011724 388 Bell City Treasurer Sheet Seq = 0018582
Sheet 00003 of 00008
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
Account number: January 1, 2024 - January 31, 2024 Page 4 of 8 Prior account number: 145398000
Electronic deposits/bank credits (continued)
Effective
date
Posted
date Amount
Transaction detail
01/23 2.50 01/23Bankcard Deposit -0328029701
01/23 114.42 01/23Bankcard Deposit -0328029700
01/23 121.86 Square Inc 240123P2 240123 L210853061633 City of Bell 01/23 273.00 01/23Bankcard Deposit -0328029701
01/23 440.60 01/23Bankcard Deposit -0328029700
01/23 1,241.38 Jpmorgan Chase B Payment
Rmr*IV*20914-0003099814**1241.38*1241.38*0.00\
01/23 2,504.59 Cash Only Customer Deposit
01/23 471,486.13 Desktop Check Deposit
01/23 89,888.76 Sweep Transfer From Investment
01/24 10.00 01/24Bankcard Deposit -0328029700
01/24 201.11 01/24Bankcard Deposit -0328029700
01/24 274.42 Square Inc 240124P2 240124 L210853233905 City of Bell 01/24 8,256.18 Active Network, Registrati 000000006113984 Rmr*IV*13895209**8256.18*8256.18*0\Ref*PO*RN 0011
01/24 60,992.59 Desktop Check Deposit
01/24 256,567.13 CA Dept Tax&Fee Cdtfa-Ltax 011924 19005 City of Bell 01/24 326.25 ZBA Funding Account Transfer From
01/25 114.42 01/25Bankcard Deposit -0328029700
01/25 209.00 01/25Bankcard Deposit -0328029701
01/25 295.58 01/25Bankcard Deposit -0328029700
01/25 448.83 Square Inc 240125P2 240125 L210853413701 City of Bell 01/25 1,732.00 Cash Only Customer Deposit
01/25 2,541.52 Cash Only Customer Deposit
01/25 149,561.74 Desktop Check Deposit
01/26 188.51 01/26Bankcard Deposit -0328029700
01/26 325.42 Square Inc 240126P2 240126 L210853599727 City of Bell 01/26 635.50 Cash Only Customer Deposit
01/29 4.25
01/29Bankcard Deposit -0328029701
01/29 3,982.91 Desktop Check Deposit
01/29 58,208.99 Lacmta Corp Pmt 1203231
8208.99~Dtm|003|20240116~SE|33|0190~GE|0001|20377
01/29 70,175.81 Lacmta Corp Pmt 1203232
0175.81~Dtm|003|20240116~SE|33|0001~GE|0001|20377
01/29 222,491.75 Desktop Check Deposit
01/30 64.73 Square Inc 240130P2 240130 L210854218211 City of Bell 01/30 278.50 01/30Bankcard Deposit -0328029701
01/30 827.39 01/30Bankcard Deposit -0328029700
01/30 993.32 01/30Bankcard Deposit -0328029700
01/30 10,131.79 Desktop Check Deposit
01/30 43,647.60 Lacmta Corp Pmt 1203644
3647.60~Dtm|003|20240119~SE|33|0214~GE|0001|20400
01/30 49,319.17 Lacmta Corp Pmt 1203645
9319.17~Dtm|003|20240119~SE|33|0213~GE|0001|20400
01/31 209.00 01/31Bankcard Deposit -0328029701
01/31 275.31 01/31Bankcard Deposit -0328029700
01/31 487.84 Cash Only Customer Deposit
01/31 910.54 Cash Only Customer Deposit
01/31 975.54 Cash Only Customer Deposit
Sheet Seq = 0018583
Sheet 00004 of 00008
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
Account number: January 1, 2024 - January 31, 2024 Page 5 of 8 Prior account number: 145398000
Electronic deposits/bank credits (continued)
Effective
date
Posted
date Amount
Transaction detail
01/31 1,043.47 Square Inc 240131P2 240131 L210854390775 City of Bell 01/31 1,146.24 Cash Only Customer Deposit
01/31 3,466.61 Active Network, Registrati 000000006116123 Rmr*IV*13898302**3466.61*3466.61*0\Ref*PO*RN 0011
01/31 3,646.28 01/31Bankcard Deposit -0328029700
01/31 28,553.84 Desktop Check Deposit
01/31 51,338.70 Sweep Transfer From Investment
$8,086,833.56 Total electronic deposits/bank credits
$8,092,786.65 Total credits
Debits
Electronic debits/bank debits
Effective
date
Posted
date Amount
Transaction detail
01/02 1,182,106.52 Sweep Transfer to Investment
01/03 10,721.82 ZBA Funding Account Transfer to
01/03 15,282.63 Sweep Transfer to Investment
01/04 3,321.74 ACH Prep Origintn - General Fund - File 2956000677 Coid 2956000677 01/04 5,643.50 WT Seq454134 City of Bell, Workers C /Bnf=City of Bell, Workers Compensation Srf# Gb00000064301917 Trn#240104454134 Rfb# 2880
01/04 267,170.30 ZBA Funding Account Transfer to
01/05 2,247.22 < Business to Business ACH Debit - Expertpay Expertpay xxxxx0677 City of Bell 01/05 95,437.73 ZBA Funding Account Transfer to
01/08 1,060.29 WT Seq454566 City of Bell, Workers C /Bnf=City of Bell, Workers Compensation Srf# Gb00000064416368 Trn#240108454566 Rfb# 2881
01/08 7,614.60 ZBA Funding Account Transfer to
01/08 1,991.83 Sweep Transfer to Investment
01/09 4,755.31 Sweep Transfer to Investment
01/10 234.00 ZBA Funding Account Transfer to
01/10 10,359.33 Sweep Transfer to Investment
01/11 158.40 Client Analysis Srvc Chrg 240110 Svc Chge 1223 01/11 0.87 Bankcard Discount Fee - 0328029701
01/11 1.13 Bankcard Discount Fee - 0328029701
01/11 1.30 Bankcard Discount Fee - 0328029700
01/11 1.76 Bankcard Fee - 0328029701
01/11 1.87 Bankcard Discount Fee - 0328029701
01/11 4.02 Bankcard Fee - 0328029700
01/11 4.70 Bankcard Discount Fee - 0328029700
01/11 13.71 Bankcard Discount Fee - 0328029700
01/11 25.21 Bankcard Interchange Fee - 0328029701
01/11 36.40 Bankcard Discount Fee - 0328029700
01/11 389.47 Bankcard Interchange Fee - 0328029700
01/11 449.58 <
Business to Business ACH Debit - Calpers 1800 5686383552 100000017391026 01/11 6,367.19 < Business to Business ACH Debit - Calpers 3100 5686383552 100000017349083 01/11 13,687.28 < Business to Business ACH Debit - Calpers 3100 5686383552 100000017349199 01/11 14,966.17 < Business to Business ACH Debit - Calpers 3100 5686383552 100000017349023 01/11 18,504.48 < Business to Business ACH Debit - Calpers 3100 5686383552 100000017348962 Sheet Seq = 0018584
Sheet 00005 of 00008
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
Account number: January 1, 2024 - January 31, 2024 Page 6 of 8 Prior account number: 145398000
Electronic debits/bank debits (continued)
Effective
date
Posted
date Amount
Transaction detail
01/11 22,392.41 < Business to Business ACH Debit - Calpers 3100 5686383552 100000017349148 01/11 169,856.77 < Business to Business ACH Debit - Calpers 1800 5686383552 100000017391024 01/12 73,774.55 Sweep Transfer to Investment
01/16 7,373.09 WT Seq456613 City of Bell, Workers C /Bnf=City of Bell, Workers Compensation Srf# Gb00000064584362 Trn#240116456613 Rfb# 2886
01/16 13,312.50 WT Seq453347 City of Bell, Workers C /Bnf=City of Bell, Workers Compensation Srf# Gb00000064571719 Trn#240116453347 Rfb# 2883
01/16 21,935.81 WT Seq453331 City of Bell, Workers C /Bnf=City of Bell, Workers Compensation Srf# Gb00000064571693 Trn#240116453331 Rfb# 2882
01/16 184,493.75 WT Fed#09214 Zions Bancorporati /Ftr/Bnf=Zb, NA DBA Zions Bank Srf# Gw00000064571813 Trn#240116187635 Rfb# 2885
01/16 292,712.50 WT Fed#09245 Zions Bancorporati /Ftr/Bnf=Zb, NA DBA Zions Bank Srf# Gw00000064571431 Trn#240116187121 Rfb# 2884
01/16 6,749.04 ZBA Funding Account Transfer to
01/17 9,258.44 ZBA Funding Account Transfer to
01/18 3,241.74 ACH Prep Origintn - General Fund - File 2956000677 Coid 2956000677 01/18 3,275.00 WT Seq457726 City of Bell, Successor /Bnf=City of Bell, Successor Agency Srf# Gb00000064645406 Trn#240118457726 Rfb# 2888
01/18 28,868.54 WT Fed#08803 US Bank, NA /Ftr/Bnf=U.S. Bank National Association Srf# Gw00000064644833 Trn#240118174200 Rfb# 2889
01/18 267,958.27 ZBA Funding Account Transfer to
01/19 2,247.22 < Business to Business ACH Debit - Expertpay Expertpay xxxxx0677 City of Bell 01/19 96,008.34 ZBA Funding Account Transfer to
01/19 3,015,004.27 Sweep Transfer to Investment
01/22 4,624.52 < Business to Business ACH Debit - AFLAC Columbus Achpmt 240120 71113604 Vw09063763401
01/22 9,584.88 < Business to Business ACH Debit - Wright Express Fleet Debi 240119 9100005154093 City of Bell (3)
01/22 9,064.74 ZBA Funding Account Transfer to
01/22 4,451.79 Sweep Transfer to Investment
01/23 6,370.89 < Business to Business ACH Debit - Calpers 3100 5686383552 100000017384489 01/23 14,771.19 < Business to Business ACH Debit - Calpers 3100 5686383552 100000017384550 01/23 14,946.72 < Business to Business ACH Debit - Calpers 3100 5686383552 100000017384455 01/23 17,537.77 < Business to Business ACH Debit - Calpers 3100 5686383552 100000017384423 01/23 24,393.38 < Business to Business ACH Debit - Calpers 3100 5686383552 100000017384517 01/23 1,915.99
ZBA Funding Account Transfer to
01/24 744,615.44 Sweep Transfer to Investment
01/25 18,656.15 WT Seq455425 City of Bell, Workers C /Bnf=City of Bell, Workers Compensation Srf# Gb00000064781955 Trn#240125455425 Rfb# 2890
01/25 8,348.35 ZBA Funding Account Transfer to
01/25 32,317.59 Sweep Transfer to Investment
01/26 147,612.43 Sweep Transfer to Investment
01/29 355.77 ZBA Funding Account Transfer to
01/29 55,068.76 Sweep Transfer to Investment
01/30 665.00 ZBA Funding Account Transfer to
Sheet Seq = 0018585
Sheet 00006 of 00008
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
Account number: January 1, 2024 - January 31, 2024 Page 7 of 8 Prior account number: 145398000
Electronic debits/bank debits (continued)
Effective
date
Posted
date Amount
Transaction detail
01/30 283,336.61 Sweep Transfer to Investment
01/31 14,687.21 ZBA Funding Account Transfer to
$7,294,347.78 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 82052 17,268.20 01/09
82090 * 39,520.98 01/05
82138 * 62.00 01/25
82152 * 50.00 01/08
82244 * 26,674.40 01/02
82246 * 41,822.75 01/03
82317 * 5,750.00 01/04
82370 * 50.00 01/02
82371 95.96 01/02
82373 * 647.00 01/26
82377 * 2,386.46 01/02
82382 * 200.00 01/16
82384 * 90.98 01/02
82390 * 251.39 01/16
82391 201.02 01/02
82399 * 181.96 01/16
82400 236.92 01/16
82404 * 1,757.00 01/17
82414 * 6.00 01/10
82420 * 23,926.75 01/02
82465 * 1,050.00 01/02
82470 * 56.00 01/10
82480 * 2,142.30 01/02
82488 * 18.31 01/03
82494 * 676.90 01/08
82497 * 128,866.98 01/19
82499 * 12,460.00 01/17
82500 32,984.71 01/22
82501 16,495.47 01/18
82502 31,437.85 01/19
82503 17,388.68 01/18
82504 27,016.99 01/17
82505 1,900.00 01/16
82506 153.24 01/24
82507 2,671.27 01/16
82508 211.68 01/22
82509 1,320.07 01/16
82510 318.57 01/18
82511 842.34 01/16
82512 75.00 01/19
82513 4,173.13 01/16
82514 7,335.08 01/17
82515 101.84 01/23
82516 84.00 01/18
82517 6,932.50 01/17
82518 85.39 01/17
82519 1,904.99 01/16
82520 104.32 01/18
82522 * 516.00 01/16
82523 2,217.18 01/11
82524 1,328.70 01/16
82525 1,091.48 01/18
82525 1,091.48 01/23
82526 824.74 01/17
82528 * 177.95 01/29
82529 136.00 01/17
82530 90.00 01/18
82531 75.00 01/17
82532 388.79 01/16
82533 1,851.00 01/16
82535 * 4,861.61 01/16
82536 654.26 01/22
82537 1,091.70 01/18
82538 179.46 01/17
82540 * 6,893.67 01/16
82542 * 190.00 01/19
82543 1,197.13 01/16
82544 4,355.00 01/22
82545 1,654.00 01/25
82546 3,856.00 01/17
82547 2,551.99 01/22
82548 59.00 01/17
82549 194.55 01/18
82550 450.00 01/16
82551 104.00 01/17
82552 3,496.00 01/30
82553 20,957.50 01/30
82554 11,932.70 01/31
82555 17,666.00 01/23
82556 14,146.04 01/16
82557 36,511.11 01/18
82558 256.54 01/19
82559 1,460.29 01/17
82561 * 231.27 01/19
82562 2,389.22 01/23
82563 113.36 01/22
82564 2,993.05 01/22
82565 618.50 01/18
82566 1,676.52 01/17
82567 2,458.44 01/16
82568 7,936.53 01/16
82569 304.10 01/18
82570 63.17 01/22
82571 951.08 01/18
82572 7,850.82 01/17
82573 554.76 01/23
82574 150.00 01/22
82575 100.00 01/25
82576 259.44 01/19
82577 676.31 01/18
82579 * 140.00 01/22
82580 1,213.40 01/22
82581 1,762.57 01/17
82582 625.66 01/30
82583 2,725.27 01/29
82584 1,640.00 01/31
82586 * 1,385.52 01/30
82590 * 568.00 01/30
82592 * 3,378.03 01/29
82593 4,100.42 01/30
82596 * 171.90 01/31
82598 * 714.20 01/29
82599 950.00 01/29
82600 5,445.00 01/30
82601 1,132.95 01/29
82602 458.50 01/29
82604 * 645.00 01/29
82605 9,382.72 01/29
82609 * 278.60 01/29
82610 203.00 01/29
Sheet Seq = 0018586
Sheet 00007 of 00008
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
Account number: January 1, 2024 - January 31, 2024 Page 8 of 8 Prior account number: 145398000
Checks paid (continued)
Number Amount Date Number Amount Date Number Amount Date 82612 * 1,637.55 01/29
82620 * 856.00 01/30
82622 * 9,945.00 01/29
82625 * 120.18 01/30
82627 * 669.43 01/29
82639 * 39,009.34 01/29
82640 1,729.64 01/29
82648 * 1,133.30 01/31
82649 1,741.57 01/31
82651 * 1,213.40 01/31
82652 29,596.73 01/31
82653 2,557.14 01/31
82654 38.61 01/30
82656 * 8,916.42 01/31
$769,905.87 Total checks paid
* Gap in check sequence.
$8,064,253.65 Total debits
Daily ledger balance summary
Date Balance Date Balance Date Balance
12/31 50,000.00
01/02 94,267.00
01/03 98,667.00
01/04 61,910.00
01/05 50,510.00
01/08 70,050.00
01/09 59,537.00
01/10 77,570.00
01/11 50,109.00
01/12 50,000.00
01/16 56,020.00
01/17 55,423.00
01/18 61,696.00
01/19 54,331.00
01/22 57,152.00
01/23 521,486.00
01/24 103,345.00
01/25 197,110.00
01/26 50,000.00
01/29 276,402.00
01/30 60,070.00
01/31 78,533.00
Average daily ledger balance $87,091.06
Sheet Seq = 0018587
Sheet 00008 of 00008
Commercial Checking Acct Public Funds
Account number: January 1, 2024 - January 31, 2024 Page 1 of 2 ©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 $0.00 $242,119.52 -$242,119.52 $0.00
Credits
Electronic deposits/bank credits
Effective
date
Posted
date Amount
Transaction detail
01/02 348.00 121108250 Ccddeposit 240102 xxxxx0548 Bell Community Housing 01/03 10,721.82 ZBA Balance Account Transfer From
01/04 720.00 Bell Properties Owner Paym 240102 Bell Properties City of Bell 01/04 835.00 Bell Properties Owner Paym 240102 Bell Properties City of Bell 01/04 985.00 Bell Properties Owner Paym 240102 Bell Properties City of Bell 01/04 1,020.00 Bell Properties Owner Paym 240102 Bell Properties City of Bell 01/04 1,255.00 Bell Properties Owner Paym 240102 Bell Properties City of Bell 01/04 1,620.00 Bell Properties Owner Paym 240102 Bell Properties City of Bell 01/04 1,770.00 Bell Properties Owner Paym 240102 Bell Properties City of Bell 01/04 1,840.00 Bell Properties Owner Paym 240102 Bell Properties City of Bell 01/04 2,170.00 Bell Properties Owner Paym 240102 Bell Properties City of Bell 01/04 2,380.00 Bell Properties Owner Paym 240102 Bell Properties City of Bell 01/04 3,810.00 Bell Properties Owner Paym 240102 Bell Properties City of Bell 01/04 5,070.00 Bell Properties Owner Paym 240102 Bell Properties City of Bell 01/04 9,435.00 Bell Properties Owner Paym 240102 Bell Properties City of Bell 01/04 15,327.80 Bell Properties Owner Paym 240102 Bell Properties City of Bell 01/04 31,562.88 Bell Properties Owner Paym 240102 Bell Properties City of Bell 01/10 234.00 ZBA Balance Account Transfer From
01/16 6,749.04 ZBA Balance Account Transfer From
01/17 9,258.44 ZBA Balance Account Transfer From
01/18 50,000.00 Bell Properties Owner Paym 240115 Bell Properties City of Bell 01/18 50,000.00 Bell Properties Owner Paym 240115 Bell Properties City of Bell 01/22 9,064.74 ZBA Balance Account Transfer From
01/23 1,915.99 ZBA Balance Account Transfer From
01/24 326.25 Desktop Check Deposit
Sheet Seq = 0015836
Sheet 00001 of 00002
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
Account number: January 1, 2024 - January 31, 2024 Page 2 of 2 Electronic deposits/bank credits (continued)
Effective
date
Posted
date Amount
Transaction detail
01/25 8,348.35 ZBA Balance Account Transfer From
01/30 665.00 ZBA Balance Account Transfer From
01/31 14,687.21 ZBA Balance Account Transfer From
$242,119.52 Total electronic deposits/bank credits
$242,119.52 Total credits
Debits
Electronic debits/bank debits
Effective
date
Posted
date Amount
Transaction detail
01/02 348.00 ZBA Balance Account Transfer to
01/04 79,800.68 ZBA Balance Account Transfer to
01/18 87,384.57 ZBA Balance Account Transfer to
01/24 326.25 ZBA Balance Account Transfer to
$167,859.50 Total electronic debits/bank debits
Checks paid
Number Amount Date Number Amount Date Number Amount Date 8450 234.00 01/10
8458 * 665.00 01/30
8467 * 10,721.82 01/03
8478 * 73.05 01/17
8479 5,410.15 01/18
8480 5,999.00 01/16
8482 * 92.10 01/22
8483 269.89 01/18
8484 665.84 01/16
8485 84.20 01/16
8486 9,174.81 01/17
8487 1,915.99 01/23
8488 8,788.64 01/22
8489 6,935.39 01/18
8490 8,348.35 01/25
8491 184.00 01/22
8492 10.58 01/17
8494 * 46.41 01/31
8495 334.43 01/31
8496 4,803.98 01/31
8498 * 9,502.39 01/31
$74,260.02 Total checks paid
* Gap in check sequence.
$242,119.52 Total debits
Daily ledger balance summary
Date Balance Date Balance Date Balance
12/31 0.00
01/02 0.00
01/03 0.00
01/04 0.00
01/10 0.00
01/16 0.00
01/17 0.00
01/18 0.00
01/22 0.00
01/23 0.00
01/24 0.00
01/25 0.00
01/30 0.00
01/31 0.00
Average daily ledger balance $0.00
Sheet Seq = 0015837
Sheet 00002 of 00002
Choice IV-Public Funds {NIB}
Account number: January 1, 2024 - January 31, 2024 Page 1 of 2 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 $0.00 $734,545.01 -$734,545.01 $0.00
Credits
Electronic deposits/bank credits
Effective
date
Posted
date Amount
Transaction detail
01/04 267,170.30 ZBA Balance Account Transfer From
01/05 95,437.73 ZBA Balance Account Transfer From
01/08 7,614.60 ZBA Balance Account Transfer From
01/18 267,958.27 ZBA Balance Account Transfer From
01/19 96,008.34 ZBA Balance Account Transfer From
01/29 355.77 ZBA Balance Account Transfer From
$734,545.01 Total electronic deposits/bank credits
$734,545.01 Total credits
Debits
Electronic debits/bank debits
Effective
date
Posted
date Amount
Transaction detail
01/04 267,170.30 ACH Prep Origintn - City of Bell Pay - File 1956000677 Coid 1956000677 01/05 15,634.28 < Business to Business ACH Debit - Employment Devel EDD Eftpmt 80097165 Txp*80097165*01102*240105*T*000*T*1563428*T*15634
01/05 79,803.45 < Business to Business ACH Debit - IRS Usataxpymt 010524 270440574949434 City of Bell
01/08 7,428.51 < Business to Business ACH Debit - Voya NAT Trst182 Spnsr P/R 240105 664486 0001 City of Bell
01/18 593.49 WT Fed#05150 Jpmorgan Chase Ban /Ftr/Bnf=NEW York Life Insurance Srf# Gw00000064636631 Trn#240118141301 Rfb# 2887
01/18 267,257.42 ACH Prep Origintn - City of Bell Pay - File 1956000677 Coid 1956000677 Sheet Seq = 0018578
Sheet 00001 of 00002
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
Account number: January 1, 2024 - January 31, 2024 Page 2 of 2 Prior account number: 145098007
Electronic debits/bank debits (continued)
Effective
date
Posted
date Amount
Transaction detail
01/19 7,178.51 < Business to Business ACH Debit - Voya NAT Trst182 Spnsr P/R 240118 664486 0001 City of Bell
01/19 14,366.70 < Business to Business ACH Debit - Employment Devel EDD Eftpmt 80097165 Txp*80097165*01102*240119*T*000*T*1436670*T*14366
01/19 74,463.13 < Business to Business ACH Debit - IRS Usataxpymt 011924 270441962080699 City of Bell
$733,895.79 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 40892 107.36 01/18 40893 186.09 01/08 40895 * 355.77 01/29 $649.22 Total checks paid
* Gap in check sequence.
$734,545.01 Total debits
Daily ledger balance summary
Date Balance Date Balance Date Balance
12/31 0.00
01/04 0.00
01/05 0.00
01/08 0.00
01/18 0.00
01/19 0.00
01/29 0.00
Average daily ledger balance $0.00
Sheet Seq = 0018579
Sheet 00002 of 00002
Choice IV-Public Funds {NIB}
Account number: January 1, 2024 - January 31, 2024 Page 1 of 2 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 $53,936.54 $68,146.48 -$54,971.79 $67,111.23
Credits
Deposits
Effective
date
Posted
date Amount
Transaction detail
01/19 01/22 165.14 Reversal of Check Posted 1-19-24 Refer to Maker Our Ref: 1-19-24 00000000 $165.14 Total deposits
Electronic deposits/bank credits
Effective
date
Posted
date Amount
Transaction detail
01/04 5,643.50 WT Seq454134 City of Bell, General F /Org=City of Bell Srf# Gb00000064301917 Trn#240104454134 Rfb# 2880
01/08 1,060.29 WT Seq454566 City of Bell, General F /Org=City of Bell Srf# Gb00000064416368 Trn#240108454566 Rfb# 2881
01/16 7,373.09 WT Seq456613 City of Bell, General F /Org=City of Bell Srf# Gb00000064584362 Trn#240116456613 Rfb# 2886
01/16 13,312.50 WT Seq453347 City of Bell, General F /Org=City of Bell Srf# Gb00000064571719 Trn#240116453347 Rfb# 2883
01/16 21,935.81 WT Seq453331 City of Bell, General F /Org=City of Bell Srf# Gb00000064571693 Trn#240116453331 Rfb# 2882
01/25 18,656.15 WT Seq455425 City of Bell, General F /Org=City of Bell Srf# Gb00000064781955 Trn#240125455425 Rfb# 2890
$67,981.34 Total electronic deposits/bank credits
$68,146.48 Total credits
Sheet Seq = 0052050
Sheet 00001 of 00002
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
Account number: January 1, 2024 - January 31, 2024 Page 2 of 2 Prior account number: 145701262
Debits
Checks paid
Number Amount Date Number Amount Date Number Amount Date 17348 87.33 01/08
17480 * 580.00 01/25
17488 * 580.00 01/04
17498 * 193.54 01/04
17514 * 192.89 01/11
17517 * 580.00 01/25
17518 195.85 01/05
17519 102.80 01/02
17521 * 454.66 01/02
17522 250.49 01/02
17524 * 460.24 01/02
17526 * 580.00 01/08
17527 193.54 01/04
17529 * 120.00 01/02
17531 * 13,312.50 01/18
17532 267.80 01/11
17533 580.00 01/12
17534 21.19 01/08
17535 49.20 01/08
17536 87.33 01/16
17537 54.77 01/08
17538 91.59 01/18
17539 258.60 01/18
17540 242.74 01/12
17541 153.81 01/09
17542 800.00 01/17
17543 580.00 01/25
17544 282.39 01/10
17545 370.17 01/18
17546 109.40 01/12
17547 109.40 01/12
17548 580.00 01/29
17549 1,698.64 01/16
17550 31.41 01/16
17551 142.34 01/17
17552 182.74 01/17
17553 169.81 01/16
17554 211.72 01/16
17555 120.05 01/16
17556 291.84 01/18
17557 154.01 01/16
17558 176.29 01/22
17560 * 422.60 01/29
17561 138.58 01/22
17562 109.40 01/19
17563 253.48 01/19
17564 179.19 01/19
17565 195.25 01/17
17566 625.00 01/19
17567 5.74 01/24
17568 7.97 01/24
17569 824.79 01/22
17572 * 154.01 01/22
17573 14.99 01/24
17574 4,330.27 01/18
17575 955.00 01/29
17576 1,237.50 01/23
17578 * 267.80 01/24
17579 580.00 01/22
17580 165.14 01/19
17580 165.14 01/29
17581 124.38 01/23
17582 223.29 01/29
17583 206.59 01/24
17584 142.32 01/24
17585 182.74 01/24
17586 124.38 01/23
17587 258.60 01/29
17588 258.60 01/29
17589 1,790.16 01/22
17590 550.00 01/23
17591 3,620.00 01/26
17594 * 258.60 01/29
17595 258.60 01/29
17596 1,102.20 01/24
17597 4,233.78 01/26
17599 * 220.50 01/29
17601 * 210.10 01/29
17603 * 308.00 01/29
17605 * 3,290.00 01/29
17606 1,155.75 01/25
17609 * 73.84 01/26
17611 * 46.43 01/29
$54,971.79 Total checks paid
* Gap in check sequence.
$54,971.79 Total debits
Daily ledger balance summary
Date Balance Date Balance Date Balance
12/31 53,936.54
01/02 52,548.35
01/04 57,224.77
01/05 57,028.92
01/08 57,296.72
01/09 57,142.91
01/10 56,860.52
01/11 56,399.83
01/12 55,358.29
01/16 95,506.72
01/17 94,186.39
01/18 75,531.42
01/19 74,199.21
01/22 70,700.52
01/23 68,664.26
01/24 66,733.91
01/25 82,494.31
01/26 74,566.69
01/29 67,111.23
Average daily ledger balance $65,755.55
Sheet Seq = 0052051
Sheet 00002 of 00002
2/1/24, 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
February 01, 2024
LAIF Home
PMIA Average Monthly
Yields
CITY OF BELL
CITY TREASURER
6330 PINE A VENUE
BELL, CA 90201
Account Number:
January 2024 Statement
Tran Type Definitions
Effective
Date
Transaction
Date
Tran
Type Confirm
Number
Web
Confirm
Number Authorized Caller Amount
1/12/2024 1/11/2024 QRD 1746658 N/A SYSTEM 202,475.16
Account Summary
Total Deposit: 202,475.16 Beginning Balance: 20,769,217.14 Total Withdrawal: 0.00 Ending Balance: 20,971,692.30
2/1/24, 10 39 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
February 01, 2024
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:
January 2024 Statement
Tran Type Definitions
Effective
Date
Transaction
Date
Tran
Type Confirm
Number
Web
Confirm
Number Authorized Caller Amount
1/12/2024 1/11/2024 QRD 1745742 N/A SYSTEM 6,694.21
Account Summary
Total Deposit: 6,694.21 Beginning Balance: 668,115.22
Total Withdrawal: 0.00 Ending Balance: 674,809.43
Choice IV-Public Funds {NIB}
Account number: January 1, 2024 - January 31, 2024 Page 1 of 2 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 $831,391.31 $340,847.00 -$18,980.86 $1,153,257.45
Credits
Electronic deposits/bank credits
Effective
date
Posted
date Amount
Transaction detail
01/02 337,572.00 LA County Gen-Pymt 231227 Pta-11602 NTE*202312275977933 *A2400365688 *Pta-11602
01/18 3,275.00 WT Seq457726 City of Bell, General F /Org=City of Bell Srf# Gb00000064645406 Trn#240118457726 Rfb# 2888
$340,847.00 Total electronic deposits/bank credits
$340,847.00 Total credits
Debits
Electronic debits/bank debits
Effective
date
Posted
date Amount
Transaction detail
01/03 8,115.00 WT Seq456587 City of Bell, General F /Bnf=City of Bell, General Fund Operating Srf# Gb00000064266851 Trn#240103456587 Rfb# 2879
$8,115.00 Total electronic debits/bank debits
Sheet Seq = 0018588
Sheet 00001 of 00002
©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
Account number: January 1, 2024 - January 31, 2024 Page 2 of 2 Prior account number: 145998008
Checks paid
Number Amount Date Number Amount Date Number Amount Date 6097 10,826.25 01/05
6106 * 7.75 01/16
6107 25.85 01/17 6109 * 6.01 01/31
$10,865.86 Total checks paid
* Gap in check sequence.
$18,980.86 Total debits
Daily ledger balance summary
Date Balance Date Balance Date Balance
12/31 831,391.31
01/02 1,168,963.31
01/03 1,160,848.31
01/05 1,150,022.06
01/16 1,150,014.31
01/17 1,149,988.46
01/18 1,153,263.46
01/31 1,153,257.45
Average daily ledger balance $1,142,515.45
Sheet Seq = 0018589
Sheet 00002 of 00002
MONTHLY ACCOUNT STATEMENT
City of Bell - Account #
JANUARY 1, 2024 THROUGH JANUARY 31, 2024
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
ACCOUNT SUMMARY
Beg. Values
as of 12/31/23
End Values
as of 1/31/24
Market Value 10,890,074 10,931,731
Accrued Interest 64,672 65,882
Total Market Value 10,954,747 10,997,613
Income Earned 26,172 27,321
Cont/WD -1,091
Par 11,112,228 11,142,018
Book Value 11,035,269 11,060,549
Cost Value 11,087,560 11,105,929
TOP ISSUERS
Government of United States 36.8%
Federal Home Loan Bank 8.4%
Federal Home Loan Mortgage Corp 6.7%
Intl Bank Recon and Development 3.7%
Inter-American Dev Bank 3.5%
Royal Bank of Canada 2.2%
John Deere ABS 2.0%
Paccar Financial 2.0%
Total 65.3%
PORTFOLIO CHARACTERISTICS
Average Modified Duration 1.80
Average Coupon 2.78%
Average Purchase YTM 3.00%
Average Market YTM 4.67%
Average S&P/Moody Rating AA/Aa1
Average Final Maturity 2.14 yrs
Average Life 1.94 yrs
CREDIT QUALITY (S&P)
MATURITY DISTRIBUTION
SECTOR ALLOCATION
Portfolio Summary
As of January 31, 2024
City of Bell
Account #
PERFORMANCE REVIEW
Annualized
TOTAL RATE OF RETURN 1M 3M YTD 1YR 2YRS 3YRS 5YRS 10YRS 6/30/2017 City of Bell 0.40% 2.82% 0.40% 4.55% 1.45% 0.57% 1.67% N/A 1.58% ICE BofA 1-3 Yr US Treasury & Agency Index 0.38% 2.53% 0.38% 3.96% 0.75% 0.09% 1.32% N/A 1.28% Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 1
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 City of Bell
As of January 31, 2024
Assets managed by Chandler Asset Management are in full compliance with state law and the Client's investment policy.
Statement of Compliance
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
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 $11,035,269.01
Acquisition
+ Security Purchases $378,873.07
+ Money Market Fund Purchases $416,811.31
+ Money Market Contributions $0.00
+ Security Contributions $0.00
+ Security Transfers $0.00
Total Acquisitions $795,684.38
Dispositions
- Security Sales $185,273.33
- Money Market Fund Sales $379,443.57
- MMF Withdrawals $1,090.78
- Security Withdrawals $0.00
- Security Transfers $0.00
- Other Dispositions $0.00
- Maturities $170,000.00
- Calls $0.00
- Principal Paydowns $36,487.17
Total Dispositions $772,294.85
Amortization/Accretion
+/- Net Accretion $1,630.82
$1,630.82
Gain/Loss on Dispositions
+/- Realized Gain/Loss $259.86
$259.86
ENDING BOOK VALUE $11,060,549.22
CASH TRANSACTION SUMMARY
BEGINNING BALANCE $66,587.06
Acquisition
Contributions $0.00
Security Sale Proceeds $185,273.33
Accrued Interest Received $2,026.92
Interest Received $22,189.55
Dividend Received $834.34
Principal on Maturities $170,000.00
Interest on Maturities $0.00
Calls/Redemption (Principal) $0.00
Interest from Calls/Redemption $0.00
Principal Paydown $36,487.17
Total Acquisitions $416,811.31
Dispositions
Withdrawals $1,090.78
Security Purchase $378,873.07
Accrued Interest Paid $570.50
Total Dispositions $380,534.35
ENDING BOOK VALUE $102,864.02
Reconciliation Summary
As of January 31, 2024
City of Bell
Account #
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 3
Holdings Report
As of January 31, 2024
City of Bell
Account #
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
05601XAC3 BMW Vehicle Lease Trust 2022-1 A3
1.1% Due 3/25/2025
5,502.26 01/11/2022
1.11%
5,501.44
5,502.21
99.57 5.54%
5,478.82
1.01 0.05%
(23.39)
NR / AAA
AAA
1.15 0.10
43813GAC5 Honda Auto Receivables Trust 2021-1
A3
0.27% Due 4/21/2025
3,300.32 02/17/2021
0.27%
3,300.26
3,300.32
99.04 5.83%
3,268.78
0.25 0.03%
(31.54)
Aaa / NR
AAA
1.22 0.17
44891RAC4 Hyundai Auto Receivables Trust 2020-C
A3
0.38% Due 5/15/2025
3,707.86 10/20/2020
0.39%
3,707.00
3,707.85
99.58 6.05%
3,692.30
0.63 0.03%
(15.55)
NR / AAA
AAA
1.29 0.07
89240BAC2 Toyota Auto Receivables Owners 2021-
A A3
0.26% Due 5/15/2025
10,333.92 02/02/2021
0.27%
10,332.00
10,333.85
99.11 5.84%
10,242.01
1.19 0.09%
(91.84)
Aaa / NR
AAA
1.29 0.16
36266FAC3 GM Financial Auto Lease Trust 2022-2
A3
3.42% Due 6/20/2025
40,605.31 05/03/2022
3.45%
40,601.06
40,604.41
99.46 5.90%
40,384.42
42.43 0.37%
(219.99)
NR / AAA
AAA
1.39 0.22
47788UAC6 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
9,733.31 03/02/2021
0.37%
9,731.45
9,732.95
98.38 5.45%
9,575.98
1.56 0.09%
(156.97)
Aaa / NR
AAA
1.62 0.32
05593AAC3 BMW Vehicle Lease Trust 2023-1 A3
5.16% Due 11/25/2025
15,000.00 02/07/2023
5.22%
14,999.64
14,999.80
99.84 5.43%
14,976.26
12.90 0.14%
(23.54)
Aaa / AAA
NR
1.82 0.73
43815GAC3 Honda Auto Receivables Trust 2021-4
A3
0.88% Due 1/21/2026
22,560.61 11/16/2021
0.89%
22,555.85
22,559.06
97.36 5.43%
21,965.15
5.51 0.20%
(593.91)
Aaa / NR
AAA
1.98 0.58
47789QAC4 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
25,096.46 07/13/2021
0.52%
25,094.23
25,095.78
97.46 5.42%
24,459.99
5.80 0.22%
(635.79)
Aaa / NR
AAA
2.12 0.52
44935FAD6 Hyundai Auto Receivables Trust 2021-C
A3
0.74% Due 5/15/2026
15,933.18 11/09/2021
0.75%
15,929.63
15,932.11
97.48 5.63%
15,530.96
5.24 0.14%
(401.15)
NR / AAA
AAA
2.29 0.51
43815BAC4 Honda Auto Receivables Trust 2022-1
A3
1.88% Due 5/15/2026
50,306.05 02/15/2022
1.89%
50,298.49
50,303.04
97.67 5.29%
49,135.08
42.03 0.45%
(1,167.96)
Aaa / AAA
NR
2.29 0.68
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.89
98.66 5.18%
34,531.70
47.14 0.31%
(467.19)
NR / AAA
AAA
2.47 0.94
362554AC1 GM Financial Securitized Term 2021-4
A3
0.68% Due 9/16/2026
16,877.00 10/13/2021
0.68%
16,876.56
16,876.86
96.77 5.75%
16,331.15
4.78 0.15%
(545.71)
Aaa / AAA
NR
2.63 0.64
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 4
Holdings Report
As of January 31, 2024
City of Bell
Account #
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
47787JAC2 John Deere Owner Trust 2022-A A3
2.32% Due 9/16/2026
35,588.45 03/10/2022
2.34%
35,580.58
35,584.81
97.86 5.30%
34,828.35
36.70 0.32%
(756.46)
Aaa / NR
AAA
2.63 0.72
380146AC4 GM Financial Auto Receivables 2022-1
A3
1.26% Due 11/16/2026
19,609.31 01/11/2022
1.27%
19,607.61
19,608.65
97.25 5.41%
19,070.27
10.29 0.17%
(538.38)
NR / AAA
AAA
2.79 0.66
379929AD4 GM Financial Auto Leasing 2023-3 A3
5.38% Due 11/20/2026
10,000.00 08/08/2023
5.45%
9,998.80
9,999.04
100.63
5.01%
10,063.27
16.44 0.09%
64.23 NR / AAA
AAA
2.81 1.45
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,997.55
98.57 5.16%
44,357.49
74.80 0.40%
(640.06)
Aaa / NR
AAA
3.05 1.02
448979AD6 Hyundai Auto Receivables Trust 2023-A
A3
4.58% Due 4/15/2027
50,000.00 04/04/2023
4.63%
49,995.12
49,996.55
99.49 4.98%
49,742.75
101.78
0.45%
(253.80)
NR / AAA
AAA
3.21 1.43
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.89
98.55 5.12%
29,564.10
45.50 0.27%
(435.79)
Aaa / NR
AAA
3.21 1.00
43815JAC7 Honda Auto Receivables Owner 2023-1
A3
5.04% Due 4/21/2027
25,000.00 02/16/2023
5.10%
24,995.35
24,996.73
100.21
4.95%
25,051.85
35.00 0.23%
55.12 Aaa / NR
AAA
3.22 1.48
58770AAC7 Mercedes-Benz Auto Receivable 2023-1
A3
4.51% Due 11/15/2027
35,000.00 01/18/2023
4.56%
34,995.80
34,997.03
99.38 5.07%
34,783.95
70.16 0.32%
(213.08)
NR / AAA
AAA
3.79 1.19
362583AD8 GM Auto Receivable Trust 2023-2 A3
4.47% Due 2/16/2028
40,000.00 04/04/2023
4.51%
39,998.90
39,999.17
99.39 4.89%
39,755.56
74.50 0.36%
(243.61)
Aaa / AAA
NR
4.05 1.63
47787CAC7 John Deere Owner Trust 2023-C A3
5.48% Due 5/15/2028
105,000.00 09/12/2023
5.55%
104,992.79
104,993.54
101.53
4.81%
106,602.83
255.73
0.97%
1,609.29
Aaa / NR
AAA
4.29 2.06
438123AC5 Honda Auto Receivables OT 2023-4 A3
5.67% Due 6/21/2028
35,000.00 11/01/2023
5.74%
34,993.84
34,994.24
102.06
4.80%
35,719.46
55.13 0.33%
725.22
Aaa / NR
AAA
4.39 2.18
89239FAD4 Toyota Auto Receivables Owner 2023-D
A3
5.54% Due 8/15/2028
45,000.00 11/07/2023
5.61%
44,995.15
44,995.44
102.07
4.73%
45,929.93
110.80
0.42%
934.49
NR / AAA
AAA
4.54 2.35
02582JKD1 American Express Credit Trust 2023-3 A
5.23% Due 9/15/2028
115,000.00 09/12/2023
5.29%
114,994.86
114,995.50
101.74
4.57%
116,995.25
267.31
1.07%
1,999.75
NR / AAA
AAA
4.63 2.39
89238DAD0 Toyota Auto Receivables OT 2024-A A3
4.83% Due 10/16/2028
60,000.00 01/23/2024
4.89%
59,987.99
59,988.01
100.21
4.78%
60,126.18
8.05 0.55%
138.17
Aaa / AAA
NR
4.71 2.21
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 5
Holdings Report
As of January 31, 2024
City of Bell
Account #
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
Total ABS 904,154.04 3.98%
904,057.80
904,093.28 5.05%
902,163.84
1,332.66
8.22%
(1,929.44)
Aaa / AAA
AAA
3.42 1.44
AGENCY
3130AB3H7 FHLB Note
2.375% Due 3/8/2024
225,000.00 06/14/2019
1.95%
229,304.25
225,089.78
99.72 5.11%
224,360.78
2,122.66
2.06%
(729.00)
Aaa / AA+
NR
0.10 0.10
3130A1XJ2 FHLB Note
2.875% Due 6/14/2024
250,000.00 03/24/2020
0.99%
269,372.50
251,683.47
99.17 5.16%
247,914.50
938.37
2.26%
(3,768.97)
Aaa / AA+
NR
0.37 0.36
3133ENKS8 FFCB Note
1.125% Due 1/6/2025
80,000.00 01/06/2022
1.20%
79,820.00
79,943.90
96.68 4.82%
77,341.68
62.50 0.70%
(2,602.22)
Aaa / AA+
AA+
0.93 0.91
3135G06G3 FNMA Note
0.5% Due 11/7/2025
225,000.00 11/18/2020
0.52%
224,768.25
224,917.60
93.52 4.35%
210,419.33
262.50
1.92%
(14,498.27)
Aaa / AA+
AA+
1.77 1.72
3130AXU63 Federal Home Loan Banks Note
4.625% Due 11/17/2026
160,000.00 11/16/2023
4.69%
159,716.80
159,736.44
101.44
4.07%
162,301.44
1,521.11
1.49%
2,565.00
Aaa / AA+
NR
2.80 2.58
3130ATS57 FHLB Note
4.5% Due 3/10/2028
275,000.00 03/21/2023
3.99%
281,206.75
280,126.13
101.76
4.03%
279,852.65
4,846.88
2.59%
(273.48)
Aaa / AA+
NR
4.11 3.66
3133EPN50 FFCB Note
4.25% Due 12/15/2028
110,000.00 12/28/2023
3.89%
111,789.70
111,756.14
101.54
3.90%
111,699.06
597.36
1.02%
(57.08)
Aaa / AA+
AA+
4.88 4.35
Total Agency 1,325,000.00 2.40%
1,355,978.25
1,333,253.46 4.52%
1,313,889.44
10,351.38
12.04%
(19,364.02)
Aaa / AA+
AA+
2.07 1.89
CMO
3137BNGT5 FHLMC K054 A2
2.745% Due 1/25/2026
175,000.00 02/15/2023
4.92%
166,174.81
169,088.39
96.58 4.62%
169,015.18
400.31
1.54%
(73.21)
NR / AAA
NR
1.99 1.76
3137FETN0 FHLMC K073 A2
3.35% Due 1/25/2028
160,000.00 05/24/2023
4.34%
153,775.00
154,678.92
96.42 4.33%
154,268.48
89.33 1.40%
(410.44)
NR / NR
AAA
3.99 3.56
3137FHPJ6 FHLMC Multifamily Structured K080 -
A2
3.926% Due 7/25/2028
110,000.00 01/23/2024
4.52%
107,567.97
107,576.86
98.23 4.34%
108,050.69
359.88
0.99%
473.83
Aaa / NR
NR
4.48 4.01
3137FJEH8 FHLMC K081 A2
3.9% Due 8/25/2028
105,000.00 09/15/2023
4.89%
100,553.91
100,884.71
98.12 4.33%
103,027.47
341.25
0.94%
2,142.76
NR / NR
AAA
4.57 4.07
3137H4BY5 FHLMC K746 A2
2.031% Due 9/25/2028
110,000.00 10/03/2023
5.33%
94,625.78
95,624.77
90.26 4.38%
99,285.56
186.18
0.90%
3,660.79
NR / NR
AAA
4.65 4.28
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 6
Holdings Report
As of January 31, 2024
City of Bell
Account #
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
3137FKZZ2 FHLMC K088 A2
3.69% Due 1/25/2029
110,000.00 01/18/2024
4.44%
106,343.36
106,357.56
97.03 4.35%
106,735.42
338.25
0.97%
377.86
Aaa / NR
NR
4.99 4.39
Total CMO 770,000.00 4.72%
729,040.83
734,211.21 4.41%
740,382.80
1,715.20
6.75%
6,171.59
Aaa / AAA
AAA
3.92 3.50
COMMERCIAL PAPER
62479LDC6 MUFG Bank Ltd Discount CP
5.66% Due 4/12/2024
210,000.00 07/25/2023
5.93%
201,349.63
201,349.63
95.88 5.93%
201,349.63
6,306.19
1.89%
0.00 P-1 / A-1
NR
0.20 0.19
Total Commercial Paper 210,000.00 5.93%
201,349.63
201,349.63 5.93%
201,349.63
6,306.19
1.89%
0.00 P-1 / A-1
NR
0.20 0.19
CORPORATE
594918BX1 Microsoft Callable Note Cont 12/6/2023
2.875% Due 2/6/2024
125,000.00 03/05/2020
2.86%
133,325.00
125,000.00
99.97 4.55%
124,960.75
1,746.96
1.15%
(39.25)
Aaa / AAA
NR
0.02 0.01
89114QCB2 Toronto Dominion Bank Note
3.25% Due 3/11/2024
130,000.00 07/16/2019
2.49%
134,290.00
130,098.53
99.78 5.21%
129,709.71
1,643.06
1.19%
(388.82)
A1 / A
AA-
0.11 0.11
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,011.75
99.40 5.37%
159,038.24
443.33
1.45%
(973.51)
A2 / A-
A
0.13 0.13
023135BW5 Amazon.com Inc Note
0.45% Due 5/12/2024
85,000.00 05/10/2021
0.50%
84,875.90
84,988.56
98.63 5.41%
83,833.29
83.94 0.76%
(1,155.27)
A1 / AA
AA-
0.28 0.28
14913R2L0 Caterpillar Financial Service Note
0.45% Due 5/17/2024
135,000.00 05/10/2021
0.50%
134,819.10
134,982.50
98.59 5.30%
133,099.61
124.88
1.21%
(1,882.89)
A2 / A
A+
0.29 0.29
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,998.47
97.87 5.41%
19,574.52
5.56 0.18%
(423.95)
A2 / A+
NR
0.45 0.44
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
151,050.53
98.52 5.45%
147,773.85
10.00 1.34%
(3,276.68)
A3 / A
A
0.50 0.49
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 7
Holdings Report
As of January 31, 2024
City of Bell
Account #
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
69371RR40 Paccar Financial Corp Note
0.5% Due 8/9/2024
50,000.00 08/03/2021
0.52%
49,973.00
49,995.32
97.49 5.44%
48,745.65
119.44
0.44%
(1,249.67)
A1 / A+
NR
0.52 0.51
78015K7C2 Royal Bank of Canada Note
2.25% Due 11/1/2024
135,000.00 09/22/2020
0.69%
143,487.45
136,551.41
97.74 5.36%
131,944.82
759.38
1.21%
(4,606.59)
A1 / A
AA-
0.75 0.72
69371RR57 Paccar Financial Corp Note
0.9% Due 11/8/2024
90,000.00 11/02/2021
0.90%
89,994.60
89,998.62
96.83 5.15%
87,146.10
186.75
0.79%
(2,852.52)
A1 / A+
NR
0.77 0.75
89236TKN4 Toyota Motor Credit Corp Note
4.8% Due 1/10/2025
130,000.00 01/10/2023
4.84%
129,910.30
129,957.67
99.79 5.02%
129,732.85
364.00
1.18%
(224.82)
A1 / A+
A+
0.95 0.91
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
140,252.46
99.81 5.36%
139,729.66
1,878.33
1.29%
(522.80)
A1 / A-
AA-
1.08 0.08
63743HFE7 National Rural Utilities Note
3.45% Due 6/15/2025
35,000.00 04/27/2022
3.46%
34,990.55
34,995.85
98.08 4.91%
34,328.14
154.29
0.31%
(667.71)
A2 / A-
A
1.37 1.31
931142EW9 Wal-Mart Stores Note
3.9% Due 9/9/2025
30,000.00 09/06/2022
3.92%
29,979.00
29,988.77
99.10 4.48%
29,730.84
461.50
0.27%
(257.93)
Aa2 / AA
AA
1.61 1.51
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,992.19
99.15 4.55%
39,659.64
604.44
0.37%
(332.55)
A2 / A
A
1.62 1.53
46647PDM5 JP Morgan Chase & Co Callable Note
Cont 12/15/2024
5.546% Due 12/15/2025
60,000.00 09/19/2023
6.22%
59,686.80
59,737.85
100.06
5.45%
60,033.66
425.19
0.55%
295.81
A1 / A-
AA-
1.87 0.84
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
96.47 5.35%
33,764.40
297.06
0.31%
(1,235.60)
A1 / A
AA-
2.02 0.98
00440EAV9 Chubb INA Holdings Inc Callable Note
Cont 2/3/2026
3.35% Due 5/3/2026
135,000.00 08/24/2023
5.19%
128,866.95
129,850.49
97.15 4.69%
131,147.10
1,105.50
1.20%
1,296.61
A3 / A
A
2.25 2.12
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
99.33 5.15%
59,595.12
109.18
0.54%
(404.88)
A1 / A-
A+
2.46 1.39
69371RS56 Paccar Financial Corp Note
5.05% Due 8/10/2026
80,000.00 12/08/2023
4.96%
80,172.00
80,163.14
101.40
4.46%
81,116.88
1,919.00
0.76%
953.74
A1 / A+
NR
2.53 2.30
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,975.18
92.20 4.22%
23,049.90
97.71 0.21%
(1,925.28)
Aa2 / AA
AA
2.63 2.53
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 8
Holdings Report
As of January 31, 2024
City of Bell
Account #
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
89115A2V3 Toronto-Dominion Bank Note
5.264% Due 12/11/2026
55,000.00 12/04/2023
5.26%
55,000.00
55,000.00
101.70
4.62%
55,933.96
402.11
0.51%
933.96
A1 / A
AA-
2.86 2.62
78016HZT0 ROYAL BANK OF CANADA Note
4.875% Due 1/19/2027
105,000.00 01/10/2024
4.88%
104,973.75
104,974.06
100.52
4.68%
105,545.58
170.63
0.96%
571.52
A1 / A
AA-
2.97 2.73
06051GLE7 Bank of America Corp Callable Note 2X
1/20/2026
5.08% Due 1/20/2027
135,000.00 08/22/2023
6.13%
132,557.85
132,873.66
100.02
5.06%
135,021.60
209.55
1.23%
2,147.94
A1 / A-
AA-
2.97 1.85
037833CJ7 Apple Inc Callable Note Cont 11/9/2026
3.35% Due 2/9/2027
150,000.00 01/24/2023
4.09%
145,929.00
146,952.96
97.41 4.27%
146,113.50
2,400.83
1.35%
(839.46)
Aaa / AA+
NR
3.03 2.79
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
146,734.06
98.57 4.47%
147,859.50
1,350.00
1.36%
1,125.44
A2 / A+
A+
3.27 3.01
438516CJ3 Honeywell Intl Callable Note Cont
01/15/2028
4.95% Due 2/15/2028
125,000.00 02/13/2023
4.44%
127,803.75
127,255.50
102.73
4.19%
128,409.50
2,853.13
1.19%
1,154.00
A2 / A
A
4.04 3.50
58933YBH7 Merck & Co Callable Note Cont
4/17/2028
4.05% Due 5/17/2028
30,000.00 05/08/2023
4.07%
29,975.70
29,979.16
99.54 4.17%
29,860.80
249.75
0.27%
(118.36)
A1 / A+
NR
4.30 3.80
Total Corporate 2,600,000.00 3.00%
2,626,306.45
2,591,358.69 4.95%
2,576,459.17
20,175.50
23.61%
(14,899.52)
A1 / A+
A+
1.61 1.34
MONEY MARKET FUND
31846V203 First American Govt Obligation Fund
Class Y
102,864.02 Various
4.95%
102,864.02
102,864.02
1.00 4.95%
102,864.02
0.00 0.94%
0.00 Aaa / AAA
AAA
0.00 0.00
Total Money Market Fund 102,864.02 4.95%
102,864.02
102,864.02 4.95%
102,864.02
0.00 0.94%
0.00 Aaa / AAA
AAA
0.00 0.00
MUNICIPAL BONDS
13063D7D4 California State STE-GO
5.5% Due 10/1/2028
100,000.00 10/04/2023
5.12%
101,634.00
101,532.38
104.82
4.35%
104,819.60
1,680.56
0.97%
3,287.22
Aa2 / AA-
AA
4.67 4.04
Total Municipal Bonds 100,000.00 5.12%
101,634.00
101,532.38 4.35%
104,819.60
1,680.56
0.97%
3,287.22
Aa2 / AA-
AA
4.67 4.04
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 9
Holdings Report
As of January 31, 2024
City of Bell
Account #
CUSIP Security Description Par Value/Units Purchase Date Book Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody/S&P
Fitch
Maturity
Duration
SUPRANATIONAL
459058GQ0 Intl. Bank Recon & Development Note
2.5% Due 3/19/2024
150,000.00 01/26/2021
0.26%
160,491.00
150,430.26
99.61 5.41%
149,411.40
1,375.00
1.37%
(1,018.86)
Aaa / AAA
AAA
0.13 0.13
4581X0DZ8 Inter-American Dev Bank Note
0.5% Due 9/23/2024
170,000.00 09/15/2021
0.52%
169,874.20
169,973.03
97.06 5.19%
165,008.63
302.22
1.50%
(4,964.40)
Aaa / AAA
NR
0.65 0.63
45950KCR9 International Finance Corp Note
1.375% Due 10/16/2024
100,000.00 07/12/2021
0.54%
102,690.00
100,583.21
97.43 5.11%
97,433.30
401.04
0.89%
(3,149.91)
Aaa / AAA
NR
0.71 0.69
45950KDF4 International Finance Corp Note
4.375% Due 1/15/2027
80,000.00 11/29/2023
4.49%
79,739.20
79,752.29
100.24
4.29%
80,191.20
155.56
0.73%
438.91
Aaa / AAA
NR
2.96 2.74
4581X0EM6 Inter-American Dev Bank Note
4.375% Due 2/1/2027
215,000.00 12/05/2023
4.41%
214,817.25
214,825.38
100.76
4.10%
216,641.10
1,280.30
1.98%
1,815.72
Aaa / AAA
NR
3.01 2.77
459058KT9 Intl. Bank Recon & Development Note
3.5% Due 7/12/2028
140,000.00 09/07/2023
4.54%
133,740.60
134,247.45
97.93 4.01%
137,097.24
258.61
1.25%
2,849.79
Aaa / AAA
NR
4.45 4.06
459058KW2 Intl. Bank Recon & Development Note
4.625% Due 8/1/2028
115,000.00 Various
4.92%
113,575.80
113,663.63
102.49
4.01%
117,865.11
1,846.79
1.09%
4,201.48
Aaa / AAA
NR
4.50 3.98
Total Supranational 970,000.00 2.76%
974,928.05
963,475.25 4.59%
963,647.98
5,619.52
8.81%
172.73
Aaa / AAA
AAA
2.31 2.11
US TREASURY
912797JE8 US Treasury Bill
5.263% Due 2/20/2024
75,000.00 12/27/2023
5.38%
74,407.97
74,407.97
99.21 5.38%
74,407.97
383.72
0.68%
0.00 P-1 / A-1+
F-1+
0.05 0.05
91282CBV2 US Treasury Note
0.375% Due 4/15/2024
270,000.00 06/23/2023
5.36%
259,548.05
267,369.24
99.00 5.32%
267,289.47
301.54
2.43%
(79.77)
Aaa / AA+
AA+
0.21 0.20
912828WJ5 US Treasury Note
2.5% Due 5/15/2024
200,000.00 12/12/2019
1.74%
206,460.94
200,416.06
99.20 5.29%
198,398.40
1,071.43
1.81%
(2,017.66)
Aaa / AA+
AA+
0.29 0.28
91282CCG4 US Treasury Note
0.25% Due 6/15/2024
250,000.00 06/17/2021
0.43%
248,681.64
249,837.17
98.20 5.18%
245,507.75
81.97 2.23%
(4,329.42)
Aaa / AA+
AA+
0.37 0.36
91282CCT6 US Treasury Note
0.375% Due 8/15/2024
250,000.00 08/25/2021
0.45%
249,443.36
249,899.45
97.54 5.05%
243,838.00
433.08
2.22%
(6,061.45)
Aaa / AA+
AA+
0.54 0.53
91282CDH1 US Treasury Note
0.75% Due 11/15/2024
225,000.00 11/18/2021
0.83%
224,437.50
224,851.65
96.81 4.92%
217,819.35
361.61
1.98%
(7,032.30)
Aaa / AA+
AA+
0.79 0.77
912828ZF0 US Treasury Note
0.5% Due 3/31/2025
125,000.00 03/25/2021
0.58%
124,609.38
124,886.79
95.40 4.60%
119,252.88
211.75
1.09%
(5,633.91)
Aaa / AA+
AA+
1.16 1.13
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 10
Holdings Report
As of January 31, 2024
City of Bell
Account #
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
912828ZT0 US Treasury Note
0.25% Due 5/31/2025
250,000.00 02/25/2021
0.60%
246,337.89
248,857.80
94.54 4.52%
236,357.50
107.58
2.15%
(12,500.30)
Aaa / AA+
AA+
1.33 1.30
91282CEY3 US Treasury Note
3% Due 7/15/2025
260,000.00 06/23/2023
4.71%
251,417.97
253,935.37
98.00 4.43%
254,810.14
364.29
2.32%
874.77
Aaa / AA+
AA+
1.45 1.40
91282CAZ4 US Treasury Note
0.375% Due 11/30/2025
175,000.00 12/09/2020
0.41%
174,699.22
174,889.36
93.20 4.27%
163,105.43
112.96
1.48%
(11,783.93)
Aaa / AA+
AA+
1.83 1.79
9128286L9 US Treasury Note
2.25% Due 3/31/2026
275,000.00 Various
3.09%
268,007.23
270,294.74
96.10 4.15%
264,268.68
2,096.31
2.42%
(6,026.06)
Aaa / AA+
AA+
2.16 2.06
912828R36 US Treasury Note
1.625% Due 5/15/2026
265,000.00 Various
2.69%
256,468.75
258,854.81
94.57 4.13%
250,621.63
922.77
2.29%
(8,233.18)
Aaa / AA+
AA+
2.29 2.20
912828YG9 US Treasury Note
1.625% Due 9/30/2026
200,000.00 12/28/2021
1.24%
203,531.25
201,977.17
93.97 4.03%
187,937.60
1,101.09
1.72%
(14,039.57)
Aaa / AA+
AA+
2.67 2.55
912828U24 US Treasury Note
2% Due 11/15/2026
265,000.00 03/29/2022
2.56%
258,602.73
261,148.78
94.68 4.03%
250,911.54
1,135.71
2.29%
(10,237.24)
Aaa / AA+
AA+
2.79 2.66
91282CEF4 US Treasury Note
2.5% Due 3/31/2027
200,000.00 05/25/2022
2.73%
197,890.63
198,624.74
95.66 3.97%
191,312.60
1,693.99
1.75%
(7,312.14)
Aaa / AA+
AA+
3.16 2.97
912828X88 US Treasury Note
2.375% Due 5/15/2027
275,000.00 Various
2.97%
267,540.04
270,040.70
95.11 3.98%
261,550.85
1,399.56
2.39%
(8,489.85)
Aaa / AA+
AA+
3.29 3.10
91282CFM8 US Treasury Note
4.125% Due 9/30/2027
260,000.00 10/26/2022
4.19%
259,278.91
259,464.09
100.61
3.94%
261,584.44
3,633.61
2.41%
2,120.35
Aaa / AA+
AA+
3.67 3.33
91282CGC9 US Treasury Note
3.875% Due 12/31/2027
100,000.00 05/25/2023
3.98%
99,578.13
99,641.16
99.80 3.93%
99,804.70
340.66
0.91%
163.54
Aaa / AA+
AA+
3.92 3.59
91282CGT2 US Treasury Note
3.625% Due 3/31/2028
240,000.00 04/19/2023
3.73%
238,828.13
239,014.25
98.91 3.91%
237,375.12
2,947.54
2.19%
(1,639.13)
Aaa / AA+
AA+
4.17 3.78
Total US Treasury 4,160,000.00 2.48%
4,109,769.72
4,128,411.30 4.46%
4,026,154.05
18,701.17
36.78%
(102,257.25)
Aaa / AA+
AA+
1.94 1.83
TOTAL PORTFOLIO 11,142,018.06 3.00%
11,105,928.75
11,060,549.22 4.67%
10,931,730.53
65,882.18
100.00%
(128,818.69)
Aa1 / AA
AA+
2.14 1.80
TOTAL MARKET VALUE PLUS ACCRUED 10,997,612.71
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 11
Transaction Ledger
As of January 31, 2024
City of Bell
Account #
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 01/02/2024 31846V203 834.34 First American Govt Obligation Fund Class Y
1.000 4.98% 834.34 0.00 834.34 0.00
Purchase 01/05/2024 31846V203 35,748.11 First American Govt Obligation Fund Class Y
1.000 4.98% 35,748.11 0.00 35,748.11 0.00
Purchase 01/06/2024 31846V203 450.00 First American Govt Obligation Fund Class Y
1.000 4.98% 450.00 0.00 450.00 0.00
Purchase 01/10/2024 31846V203 3,120.00 First American Govt Obligation Fund Class Y
1.000 4.98% 3,120.00 0.00 3,120.00 0.00
Purchase 01/12/2024 31846V203 2,450.00 First American Govt Obligation Fund Class Y
1.000 4.98% 2,450.00 0.00 2,450.00 0.00
Purchase 01/15/2024 31846V203 4,341.70 First American Govt Obligation Fund Class Y
1.000 4.98% 4,341.70 0.00 4,341.70 0.00
Purchase 01/16/2024 31846V203 1,144.08 First American Govt Obligation Fund Class Y
1.000 4.98% 1,144.08 0.00 1,144.08 0.00
Purchase 01/16/2024 31846V203 1,261.39 First American Govt Obligation Fund Class Y
1.000 4.98% 1,261.39 0.00 1,261.39 0.00
Purchase 01/16/2024 31846V203 3,452.74 First American Govt Obligation Fund Class Y
1.000 4.98% 3,452.74 0.00 3,452.74 0.00
Purchase 01/16/2024 31846V203 479.50 First American Govt Obligation Fund Class Y
1.000 4.98% 479.50 0.00 479.50 0.00
Purchase 01/16/2024 31846V203 190.83 First American Govt Obligation Fund Class Y
1.000 4.98% 190.83 0.00 190.83 0.00
Purchase 01/16/2024 31846V203 91.00 First American Govt Obligation Fund Class Y
1.000 4.98% 91.00 0.00 91.00 0.00
Purchase 01/16/2024 31846V203 501.21 First American Govt Obligation Fund Class Y
1.000 4.98% 501.21 0.00 501.21 0.00
Purchase 01/16/2024 31846V203 149.00 First American Govt Obligation Fund Class Y
1.000 4.98% 149.00 0.00 149.00 0.00
Purchase 01/16/2024 31846V203 207.75 First American Govt Obligation Fund Class Y
1.000 4.98% 207.75 0.00 207.75 0.00
Purchase 01/16/2024 31846V203 140.25 First American Govt Obligation Fund Class Y
1.000 4.98% 140.25 0.00 140.25 0.00
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 12
Transaction Ledger
As of January 31, 2024
City of Bell
Account #
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 01/16/2024 31846V203 131.54 First American Govt Obligation Fund Class Y
1.000 4.98% 131.54 0.00 131.54 0.00
Purchase 01/16/2024 31846V203 2,008.43 First American Govt Obligation Fund Class Y
1.000 4.98% 2,008.43 0.00 2,008.43 0.00
Purchase 01/16/2024 31846V203 1,340.33 First American Govt Obligation Fund Class Y
1.000 4.98% 1,340.33 0.00 1,340.33 0.00
Purchase 01/16/2024 31846V203 2,511.94 First American Govt Obligation Fund Class Y
1.000 4.98% 2,511.94 0.00 2,511.94 0.00
Purchase 01/16/2024 31846V203 1,665.82 First American Govt Obligation Fund Class Y
1.000 4.98% 1,665.82 0.00 1,665.82 0.00
Purchase 01/16/2024 31846V203 2,334.18 First American Govt Obligation Fund Class Y
1.000 4.98% 2,334.18 0.00 2,334.18 0.00
Purchase 01/16/2024 31846V203 4,508.74 First American Govt Obligation Fund Class Y
1.000 4.98% 4,508.74 0.00 4,508.74 0.00
Purchase 01/16/2024 31846V203 2,542.58 First American Govt Obligation Fund Class Y
1.000 4.98% 2,542.58 0.00 2,542.58 0.00
Purchase 01/17/2024 31846V203 1,617.45 First American Govt Obligation Fund Class Y
1.000 4.98% 1,617.45 0.00 1,617.45 0.00
Purchase 01/17/2024 31846V203 95,000.00 First American Govt Obligation Fund Class Y
1.000 4.98% 95,000.00 0.00 95,000.00 0.00
Purchase 01/18/2024 31846V203 108.79 First American Govt Obligation Fund Class Y
1.000 4.98% 108.79 0.00 108.79 0.00
Purchase 01/18/2024 31846V203 1,113.34 First American Govt Obligation Fund Class Y
1.000 4.98% 1,113.34 0.00 1,113.34 0.00
Purchase 01/19/2024 78016HZT0 105,000.00 ROYAL BANK OF CANADA Note
4.875% Due 1/19/2027
99.975 4.88% 104,973.75 0.00 104,973.75 0.00
Purchase 01/20/2024 31846V203 3,429.00 First American Govt Obligation Fund Class Y
1.000 4.98% 3,429.00 0.00 3,429.00 0.00
Purchase 01/22/2024 31846V203 105.00 First American Govt Obligation Fund Class Y
1.000 4.98% 105.00 0.00 105.00 0.00
Purchase 01/22/2024 31846V203 165.38 First American Govt Obligation Fund Class Y
1.000 4.98% 165.38 0.00 165.38 0.00
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 13
Transaction Ledger
As of January 31, 2024
City of Bell
Account #
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 01/22/2024 31846V203 44.83 First American Govt Obligation Fund Class Y
1.000 4.98% 44.83 0.00 44.83 0.00
Purchase 01/22/2024 31846V203 6,686.10 First American Govt Obligation Fund Class Y
1.000 4.98% 6,686.10 0.00 6,686.10 0.00
Purchase 01/22/2024 31846V203 858.38 First American Govt Obligation Fund Class Y
1.000 4.98% 858.38 0.00 858.38 0.00
Purchase 01/22/2024 31846V203 1,836.59 First American Govt Obligation Fund Class Y
1.000 4.98% 1,836.59 0.00 1,836.59 0.00
Purchase 01/24/2024 31846V203 101,031.42 First American Govt Obligation Fund Class Y
1.000 4.98% 101,031.42 0.00 101,031.42 0.00
Purchase 01/25/2024 3137FKZZ2 110,000.00 FHLMC K088 A2
3.69% Due 1/25/2029
96.676 4.44% 106,343.36 270.60 106,613.96 0.00
Purchase 01/25/2024 31846V203 50,520.72 First American Govt Obligation Fund Class Y
1.000 4.98% 50,520.72 0.00 50,520.72 0.00
Purchase 01/25/2024 31846V203 64.50 First American Govt Obligation Fund Class Y
1.000 4.98% 64.50 0.00 64.50 0.00
Purchase 01/25/2024 31846V203 400.31 First American Govt Obligation Fund Class Y
1.000 4.98% 400.31 0.00 400.31 0.00
Purchase 01/25/2024 31846V203 446.67 First American Govt Obligation Fund Class Y
1.000 4.98% 446.67 0.00 446.67 0.00
Purchase 01/25/2024 31846V203 341.25 First American Govt Obligation Fund Class Y
1.000 4.98% 341.25 0.00 341.25 0.00
Purchase 01/25/2024 31846V203 186.18 First American Govt Obligation Fund Class Y
1.000 4.98% 186.18 0.00 186.18 0.00
Purchase 01/25/2024 31846V203 3,606.19 First American Govt Obligation Fund Class Y
1.000 4.98% 3,606.19 0.00 3,606.19 0.00
Purchase 01/26/2024 3137FHPJ6 110,000.00 FHLMC Multifamily Structured K080 - A2
3.926% Due 7/25/2028
97.789 4.52% 107,567.97 299.90 107,867.87 0.00
Purchase 01/30/2024 31846V203 1,800.00 First American Govt Obligation Fund Class Y
1.000 4.95% 1,800.00 0.00 1,800.00 0.00
Purchase 01/30/2024 89238DAD0 60,000.00 Toyota Auto Receivables OT 2024-A A3
4.83% Due 10/16/2028
99.980 4.89% 59,987.99 0.00 59,987.99 0.00
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 14
Transaction Ledger
As of January 31, 2024
City of Bell
Account #
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 01/31/2024 31846V203 843.75 First American Govt Obligation Fund Class Y
1.000 4.95% 843.75 0.00 843.75 0.00
Purchase 01/31/2024 31846V203 75,000.00 First American Govt Obligation Fund Class Y
1.000 4.95% 75,000.00 0.00 75,000.00 0.00
Subtotal 801,811.31 795,684.38 570.50 796,254.88 0.00
Short Sale 01/30/2024 31846V203 -59,987.99 First American Govt Obligation Fund Class Y
1.000 -59,987.99 0.00 -59,987.99 0.00
Subtotal -59,987.99 -59,987.99 0.00 -59,987.99 0.00
TOTAL ACQUISITIONS 741,823.32 735,696.39 570.50 736,266.89 0.00
DISPOSITIONS
Closing
Purchase
01/30/2024 31846V203 -59,987.99 First American Govt Obligation Fund Class Y
1.000 -59,987.99 0.00 -59,987.99 0.00
Subtotal -59,987.99 -59,987.99 0.00 -59,987.99 0.00
Sale 01/05/2024 91324PEN8 35,000.00 United Health Group Inc Note
5.15% Due 10/15/2025
100.993 5.15% 35,347.55 400.56 35,748.11 349.44
Sale 01/19/2024 31846V203 104,973.75 First American Govt Obligation Fund Class Y
1.000 4.98% 104,973.75 0.00 104,973.75 0.00
Sale 01/24/2024 912828V80 100,000.00 US Treasury Note
2.25% Due 1/31/2024
99.949 1.67% 99,949.22 1,082.20 101,031.42 -61.53
Sale 01/25/2024 31846V203 106,613.96 First American Govt Obligation Fund Class Y
1.000 4.98% 106,613.96 0.00 106,613.96 0.00
Sale 01/25/2024 912828V80 50,000.00 US Treasury Note
2.25% Due 1/31/2024
99.953 1.67% 49,976.56 544.16 50,520.72 -28.05
Sale 01/26/2024 31846V203 107,867.87 First American Govt Obligation Fund Class Y
1.000 4.98% 107,867.87 0.00 107,867.87 0.00
Sale 01/30/2024 31846V203 59,987.99 First American Govt Obligation Fund Class Y
1.000 4.95% 59,987.99 0.00 59,987.99 0.00
Subtotal 564,443.57 564,716.90 2,026.92 566,743.82 259.86 Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 15
Transaction Ledger
As of January 31, 2024
City of Bell
Account #
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
DISPOSITIONS
Paydown 01/16/2024 02582JKD1 0.00 American Express Credit Trust 2023-3 A
5.23% Due 9/15/2028
100.000 0.00 501.21 501.21 0.00
Paydown 01/16/2024 362554AC1 1,133.87 GM Financial Securitized Term 2021-4 A3
0.68% Due 9/16/2026
100.000 1,133.87 10.21 1,144.08 0.00
Paydown 01/16/2024 362583AD8 0.00 GM Auto Receivable Trust 2023-2 A3
4.47% Due 2/16/2028
100.000 0.00 149.00 149.00 0.00
Paydown 01/16/2024 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 01/16/2024 380146AC4 1,239.50 GM Financial Auto Receivables 2022-1 A3
1.26% Due 11/16/2026
100.000 1,239.50 21.89 1,261.39 0.00
Paydown 01/16/2024 43815BAC4 3,368.65 Honda Auto Receivables Trust 2022-1 A3
1.88% Due 5/15/2026
100.000 3,368.65 84.09 3,452.74 0.00
Paydown 01/16/2024 44891RAC4 2,006.62 Hyundai Auto Receivables Trust 2020-C A3
0.38% Due 5/15/2025
100.000 2,006.62 1.81 2,008.43 0.00
Paydown 01/16/2024 448979AD6 0.00 Hyundai Auto Receivables Trust 2023-A A3
4.58% Due 4/15/2027
100.000 0.00 190.83 190.83 0.00
Paydown 01/16/2024 44935FAD6 1,329.68 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due 5/15/2026
100.000 1,329.68 10.65 1,340.33 0.00
Paydown 01/16/2024 47787CAC7 0.00 John Deere Owner Trust 2023-C A3
5.48% Due 5/15/2028
100.000 0.00 479.50 479.50 0.00
Paydown 01/16/2024 47787JAC2 2,438.42 John Deere Owner Trust 2022-A A3
2.32% Due 9/16/2026
100.000 2,438.42 73.52 2,511.94 0.00
Paydown 01/16/2024 47788UAC6 1,662.40 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
100.000 1,662.40 3.42 1,665.82 0.00
Paydown 01/16/2024 47789QAC4 2,322.30 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
100.000 2,322.30 11.88 2,334.18 0.00
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 16
Transaction Ledger
As of January 31, 2024
City of Bell
Account #
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
DISPOSITIONS
Paydown 01/16/2024 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 01/16/2024 58769KAD6 4,507.24 Mercedes-Benz Auto Lease Trust 2021- B A3
0.4% Due 11/15/2024
100.000 4,507.24 1.50 4,508.74 0.00
Paydown 01/16/2024 58770AAC7 0.00 Mercedes-Benz Auto Receivable 2023-1 A3
4.51% Due 11/15/2027
100.000 0.00 131.54 131.54 0.00
Paydown 01/16/2024 89239FAD4 0.00 Toyota Auto Receivables Owner 2023-D A3
5.54% Due 8/15/2028
100.000 0.00 207.75 207.75 0.00
Paydown 01/16/2024 89240BAC2 2,539.79 Toyota Auto Receivables Owners 2021- A A3
0.26% Due 5/15/2025
100.000 2,539.79 2.79 2,542.58 0.00
Paydown 01/18/2024 43813KAC6 1,113.00 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
100.000 1,113.00 0.34 1,113.34 0.00
Paydown 01/18/2024 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 01/22/2024 36266FAC3 6,551.70 GM Financial Auto Lease Trust 2022-2 A3
3.42% Due 6/20/2025
100.000 6,551.70 134.40 6,686.10 0.00
Paydown 01/22/2024 379929AD4 0.00 GM Financial Auto Leasing 2023-3 A3
5.38% Due 11/20/2026
100.000 0.00 44.83 44.83 0.00
Paydown 01/22/2024 438123AC5 0.00 Honda Auto Receivables OT 2023-4 A3
5.67% Due 6/21/2028
100.000 0.00 165.38 165.38 0.00
Paydown 01/22/2024 43813GAC5 857.44 Honda Auto Receivables Trust 2021-1 A3
0.27% Due 4/21/2025
100.000 857.44 0.94 858.38 0.00
Paydown 01/22/2024 43815GAC3 1,818.71 Honda Auto Receivables Trust 2021-4 A3
0.88% Due 1/21/2026
100.000 1,818.71 17.88 1,836.59 0.00
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 17
Transaction Ledger
As of January 31, 2024
City of Bell
Account #
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
DISPOSITIONS
Paydown 01/22/2024 43815JAC7 0.00 Honda Auto Receivables Owner 2023-1 A3
5.04% Due 4/21/2027
100.000 0.00 105.00 105.00 0.00
Paydown 01/25/2024 05593AAC3 0.00 BMW Vehicle Lease Trust 2023-1 A3
5.16% Due 11/25/2025
100.000 0.00 64.50 64.50 0.00
Paydown 01/25/2024 05601XAC3 3,597.85 BMW Vehicle Lease Trust 2022-1 A3
1.1% Due 3/25/2025
100.000 3,597.85 8.34 3,606.19 0.00
Paydown 01/25/2024 3137BNGT5 0.00 FHLMC K054 A2
2.745% Due 1/25/2026
100.000 0.00 400.31 400.31 0.00
Paydown 01/25/2024 3137FETN0 0.00 FHLMC K073 A2
3.35% Due 1/25/2028
100.000 0.00 446.67 446.67 0.00
Paydown 01/25/2024 3137FJEH8 0.00 FHLMC K081 A2
3.9% Due 8/25/2028
100.000 0.00 341.25 341.25 0.00
Paydown 01/25/2024 3137H4BY5 0.00 FHLMC K746 A2
2.031% Due 9/25/2028
100.000 0.00 186.18 186.18 0.00
Subtotal 36,487.17 36,487.17 4,137.65 40,624.82 0.00
Maturity 01/17/2024 24422EVN6 95,000.00 John Deere Capital Corp Note
0.45% Due 1/17/2024
100.000 95,000.00 0.00 95,000.00 0.00
Maturity 01/31/2024 912828V80 75,000.00 US Treasury Note
2.25% Due 1/31/2024
100.000 75,000.00 0.00 75,000.00 0.00
Subtotal 170,000.00 170,000.00 0.00 170,000.00 0.00
Security
Withdrawal
01/08/2024 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
01/26/2024 31846V203 90.78 First American Govt Obligation Fund Class Y
1.000 90.78 0.00 90.78 0.00
Subtotal 1,090.78 1,090.78 0.00 1,090.78 0.00
TOTAL DISPOSITIONS 712,033.53 712,306.86 6,164.57 718,471.43 259.86
OTHER TRANSACTIONS
Interest 01/06/2024 3133ENKS8 80,000.00 FFCB Note
1.125% Due 1/6/2025
0.000 450.00 0.00 450.00 0.00
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 18
Transaction Ledger
As of January 31, 2024
City of Bell
Account #
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
OTHER TRANSACTIONS
Interest 01/10/2024 89236TKN4 130,000.00 Toyota Motor Credit Corp Note
4.8% Due 1/10/2025
0.000 3,120.00 0.00 3,120.00 0.00
Interest 01/12/2024 459058KT9 140,000.00 Intl. Bank Recon & Development Note
3.5% Due 7/12/2028
0.000 2,450.00 0.00 2,450.00 0.00
Interest 01/15/2024 45950KDF4 80,000.00 International Finance Corp Note
4.375% Due 1/15/2027
0.000 379.20 0.00 379.20 0.00
Interest 01/15/2024 79466LAG9 20,000.00 Salesforce.com Inc Callable Note Cont 7/15/2022
0.625% Due 7/15/2024
0.000 62.50 0.00 62.50 0.00
Interest 01/15/2024 91282CEY3 260,000.00 US Treasury Note 3% Due 7/15/2025
0.000 3,900.00 0.00 3,900.00 0.00
Interest 01/17/2024 24422EVN6 95,000.00 John Deere Capital Corp Note
0.45% Due 1/17/2024
0.000 213.75 0.00 213.75 0.00
Interest 01/17/2024 61747YET8 60,000.00 Morgan Stanley Callable Note Cont 7/17/2025
4.679% Due 7/17/2026
0.000 1,403.70 0.00 1,403.70 0.00
Interest 01/20/2024 06051GLE7 135,000.00 Bank of America Corp Callable Note 2X 1/20/2026
5.08% Due 1/20/2027
0.000 3,429.00 0.00 3,429.00 0.00
Interest 01/30/2024 91159HHX1 150,000.00 US Bancorp Callable Note Cont 6/28/2024
2.4% Due 7/30/2024
0.000 1,800.00 0.00 1,800.00 0.00
Interest 01/31/2024 912828V80 75,000.00 US Treasury Note
2.25% Due 1/31/2024
0.000 843.75 0.00 843.75 0.00
Subtotal 1,225,000.00 18,051.90 0.00 18,051.90 0.00
Dividend 01/02/2024 31846V203 66,587.06 First American Govt Obligation Fund Class Y
0.000 834.34 0.00 834.34 0.00
Subtotal 66,587.06 834.34 0.00 834.34 0.00
TOTAL OTHER TRANSACTIONS 1,291,587.06 18,886.24 0.00 18,886.24 0.00 Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 19
Income Earned
As of January 31, 2024
City of Bell
Account #
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
00440EAV9 Chubb INA Holdings Inc
Callable Note Cont 2/3/2026
3.35% Due 05/03/2026
08/24/2023
08/28/2023
135,000.00
129,656.29
0.00 0.00
129,850.49
728.63
0.00 1,105.50
376.87
194.20
0.00 194.20
571.07
571.07
023135BW5 Amazon.com Inc
Note
0.45% Due 05/12/2024
05/10/2021
05/12/2021
85,000.00
84,985.05
0.00 0.00
84,988.56
52.06 0.00
83.94 31.88
3.51 0.00
3.51 35.39
35.39 02582JKD1 American Express Credit Trust
2023-3 A
5.23% Due 09/15/2028
09/12/2023
09/19/2023
115,000.00
114,995.35
0.00 0.00
114,995.50
267.31
501.21
267.31
501.21
0.15 0.00
0.15 501.36
501.36
037833CJ7 Apple Inc
Callable Note Cont 11/9/2026
3.35% Due 02/09/2027
01/24/2023
01/26/2023
150,000.00
146,867.40
0.00 0.00
146,952.96
1,982.08
0.00 2,400.83
418.75
85.56 0.00
85.56 504.31
504.31
05593AAC3 BMW Vehicle Lease Trust
2023-1 A3
5.16% Due 11/25/2025
02/07/2023
02/15/2023
15,000.00
14,999.79
0.00 0.00
14,999.80
12.90 64.50
12.90 64.50
0.01 0.00
0.01 64.51
64.51 05601XAC3 BMW Vehicle Lease Trust
2022-1 A3
1.1% Due 03/25/2025
01/11/2022
01/19/2022
5,502.26
9,099.97
0.00 3,597.85
5,502.21
1.67 8.34
1.01 7.68
0.09 0.00
0.09 7.77
7.77 06051GLE7 Bank of America Corp
Callable Note 2X 1/20/2026
5.08% Due 01/20/2027
08/22/2023
08/24/2023
135,000.00
132,812.85
0.00 0.00
132,873.66
3,067.05
3,429.00
209.55
571.50
60.81 0.00
60.81 632.31
632.31
13063D7D4 California State
STE-GO
5.5% Due 10/01/2028
10/04/2023
10/11/2023
100,000.00
101,560.26
0.00 0.00
101,532.38
1,222.22
0.00 1,680.56
458.34
0.00 27.88
(27.88)
430.46
430.46
14913R2L0 Caterpillar Financial Service
Note
0.45% Due 05/17/2024
05/10/2021
05/17/2021
135,000.00
134,977.39
0.00 0.00
134,982.50
74.25 0.00
124.88
50.63 5.11
0.00 5.11
55.74 55.74
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 20
Income Earned
As of January 31, 2024
City of Bell
Account #
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
24422EVN6 John Deere Capital Corp
Note
Due 01/17/2024
03/01/2021
03/04/2021
0.00 94,998.97
0.00 95,000.00
0.00 194.75
213.75
0.00 19.00
1.03 0.00
1.03 20.03
20.03 3130A1XJ2 FHLB
Note
2.875% Due 06/14/2024
03/24/2020
03/25/2020
250,000.00
252,072.93
0.00 0.00
251,683.47
339.41
0.00 938.37
598.96
0.00 389.46
(389.46)
209.50
209.50
3130AB3H7 FHLB
Note
2.375% Due 03/08/2024
06/14/2019
06/17/2019
225,000.00
225,167.08
0.00 0.00
225,089.78
1,677.34
0.00 2,122.66
445.32
0.00 77.30
(77.30)
368.02
368.02
3130ATS57 FHLB
Note
4.5% Due 03/10/2028
03/21/2023
03/22/2023
275,000.00
280,232.14
0.00 0.00
280,126.13
3,815.63
0.00 4,846.88
1,031.25
0.00 106.01
(106.01)
925.24
925.24
3130AXU63 Federal Home Loan Banks
Note
4.625% Due 11/17/2026
11/16/2023
11/17/2023
160,000.00
159,728.43
0.00 0.00
159,736.44
904.44
0.00 1,521.11
616.67
8.01 0.00
8.01 624.68
624.68
3133ENKS8 FFCB
Note
1.125% Due 01/06/2025
01/06/2022
01/11/2022
80,000.00
79,938.79
0.00 0.00
79,943.90
437.50
450.00
62.50 75.00
5.11 0.00
5.11 80.11
80.11 3133EPN50 FFCB
Note
4.25% Due 12/15/2028
12/28/2023
12/29/2023
110,000.00
111,786.74
0.00 0.00
111,756.14
207.78
0.00 597.36
389.58
0.00 30.60
(30.60)
358.98
358.98
3135G06G3 FNMA
Note
0.5% Due 11/07/2025
11/18/2020
11/19/2020
225,000.00
224,913.64
0.00 0.00
224,917.60
168.75
0.00 262.50
93.75 3.96
0.00 3.96
97.71 97.71
3137BNGT5 FHLMC
K054 A2
2.745% Due 01/25/2026
02/15/2023
02/21/2023
175,000.00
168,826.59
0.00 0.00
169,088.39
400.31
400.31
400.31
400.31
261.80
0.00 261.80
662.11
662.11
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 21
Income Earned
As of January 31, 2024
City of Bell
Account #
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
3137FETN0 FHLMC
K073 A2
3.35% Due 01/25/2028
05/24/2023
05/30/2023
160,000.00
154,565.48
0.00 0.00
154,678.92
89.33 446.67
89.33 446.67
113.44
0.00 113.44
560.11
560.11
3137FHPJ6 FHLMC Multifamily Structured
K080 - A2
3.926% Due 07/25/2028
01/23/2024
01/26/2024
110,000.00
0.00 107,567.97
0.00 107,576.86
0.00 (299.90)
359.88
59.98 8.89
0.00 8.89
68.87 68.87
3137FJEH8 FHLMC
K081 A2
3.9% Due 08/25/2028
09/15/2023
09/20/2023
105,000.00
100,808.18
0.00 0.00
100,884.71
341.25
341.25
341.25
341.25
76.53 0.00
76.53 417.78
417.78
3137FKZZ2 FHLMC
K088 A2
3.69% Due 01/25/2029
01/18/2024
01/25/2024
110,000.00
0.00 106,343.36
0.00 106,357.56
0.00 (270.60)
338.25
67.65 14.20
0.00 14.20
81.85 81.85
3137H4BY5 FHLMC
K746 A2
2.031% Due 09/25/2028
10/03/2023
10/06/2023
110,000.00
95,362.32
0.00 0.00
95,624.77
186.18
186.18
186.18
186.18
262.45
0.00 262.45
448.63
448.63
362554AC1 GM Financial Securitized Term
2021-4 A3
0.68% Due 09/16/2026
10/13/2021
10/21/2021
16,877.00
18,010.70
0.00 1,133.87
16,876.86
5.10 10.21
4.78 9.89
0.03 0.00
0.03 9.92
9.92 362583AD8 GM Auto Receivable Trust
2023-2 A3
4.47% Due 02/16/2028
04/04/2023
04/12/2023
40,000.00
39,999.14
0.00 0.00
39,999.17
74.50 149.00
74.50 149.00
0.03 0.00
0.03 149.03
149.03
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.89
0.00 0.00
29,999.89
45.50 91.00
45.50 91.00
0.00 0.00
0.00 91.00
91.00 36266FAC3 GM Financial Auto Lease Trust
2022-2 A3
3.42% Due 06/20/2025
05/03/2022
05/11/2022
40,605.31
47,155.77
0.00 6,551.70
40,604.41
49.28 134.40
42.43 127.55
0.34 0.00
0.34 127.89
127.89
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 22
Income Earned
As of January 31, 2024
City of Bell
Account #
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
379929AD4 GM Financial Auto Leasing
2023-3 A3
5.38% Due 11/20/2026
08/08/2023
08/16/2023
10,000.00
9,998.99
0.00 0.00
9,999.04
16.44 44.83
16.44 44.83
0.05 0.00
0.05 44.88
44.88 380146AC4 GM Financial Auto Receivables
2022-1 A3
1.26% Due 11/16/2026
01/11/2022
01/19/2022
19,609.31
20,848.06
0.00 1,239.50
19,608.65
10.95 21.89
10.29 21.23
0.09 0.00
0.09 21.32
21.32 437076CR1 Home Depot
Callable Note Cont 8/15/2025
4% Due 09/15/2025
09/12/2022
09/19/2022
40,000.00
39,991.78
0.00 0.00
39,992.19
471.11
0.00 604.44
133.33
0.41 0.00
0.41 133.74
133.74
438123AC5 Honda Auto Receivables OT
2023-4 A3
5.67% Due 06/21/2028
11/01/2023
11/08/2023
35,000.00
34,994.09
0.00 0.00
34,994.24
55.13 165.38
55.13 165.38
0.15 0.00
0.15 165.53
165.53
43813GAC5 Honda Auto Receivables Trust
2021-1 A3
0.27% Due 04/21/2025
02/17/2021
02/24/2021
3,300.32
4,157.75
0.00 857.44
3,300.32
0.31 0.94
0.25 0.88
0.01 0.00
0.01 0.89
0.89 43813KAC6 Honda Auto Receivables Trust
2020-3 A3
Due 10/18/2024
09/22/2020
09/29/2020
0.00 1,113.00
0.00 1,113.00
0.00 0.15
0.34 0.00
0.19 0.00
0.00 0.00
0.19 0.19
43815BAC4 Honda Auto Receivables Trust
2022-1 A3
1.88% Due 05/15/2026
02/15/2022
02/23/2022
50,306.05
53,671.27
0.00 3,368.65
50,303.04
44.85 84.09
42.03 81.27
0.42 0.00
0.42 81.69
81.69 43815GAC3 Honda Auto Receivables Trust
2021-4 A3
0.88% Due 01/21/2026
11/16/2021
11/24/2021
22,560.61
24,377.51
0.00 1,818.71
22,559.06
5.96 17.88
5.51 17.43
0.26 0.00
0.26 17.69
17.69 43815JAC7 Honda Auto Receivables Owner
2023-1 A3
5.04% Due 04/21/2027
02/16/2023
02/24/2023
25,000.00
24,996.61
0.00 0.00
24,996.73
35.00 105.00
35.00 105.00
0.12 0.00
0.12 105.12
105.12
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 23
Income Earned
As of January 31, 2024
City of Bell
Account #
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
43815PAC3 Honda Auto Receivables
2022-2 A3
3.73% Due 07/20/2026
08/15/2022
08/24/2022
35,000.00
34,998.83
0.00 0.00
34,998.89
47.14 108.79
47.14 108.79
0.06 0.00
0.06 108.85
108.85
438516CJ3 Honeywell Intl
Callable Note Cont 01/15/2028
4.95% Due 02/15/2028
02/13/2023
02/15/2023
125,000.00
127,303.92
0.00 0.00
127,255.50
2,337.50
0.00 2,853.13
515.63
0.00 48.42
(48.42)
467.21
467.21
44891RAC4 Hyundai Auto Receivables Trust
2020-C A3
0.38% Due 05/15/2025
10/20/2020
10/28/2020
3,707.86
5,714.43
0.00 2,006.62
3,707.85
0.97 1.81
0.63 1.47
0.04 0.00
0.04 1.51
1.51 448979AD6 Hyundai Auto Receivables Trust
2023-A A3
4.58% Due 04/15/2027
04/04/2023
04/12/2023
50,000.00
49,996.40
0.00 0.00
49,996.55
101.78
190.83
101.78
190.83
0.15 0.00
0.15 190.98
190.98
44935FAD6 Hyundai Auto Receivables Trust
2021-C A3
0.74% Due 05/15/2026
11/09/2021
11/17/2021
15,933.18
17,261.59
0.00 1,329.68
15,932.11
5.68 10.65
5.24 10.21
0.20 0.00
0.20 10.41
10.41 4581X0DZ8 Inter-American Dev Bank
Note
0.5% Due 09/23/2024
09/15/2021
09/23/2021
170,000.00
169,969.47
0.00 0.00
169,973.03
231.39
0.00 302.22
70.83 3.56
0.00 3.56
74.39 74.39
4581X0EM6 Inter-American Dev Bank
Note
4.375% Due 02/01/2027
12/05/2023
12/12/2023
215,000.00
214,820.44
0.00 0.00
214,825.38
496.44
0.00 1,280.30
783.86
4.94 0.00
4.94 788.80
788.80
459058GQ0 Intl. Bank Recon & Development
Note
2.5% Due 03/19/2024
01/26/2021
01/28/2021
150,000.00
150,714.05
0.00 0.00
150,430.26
1,062.50
0.00 1,375.00
312.50
0.00 283.79
(283.79)
28.71 28.71
459058KT9 Intl. Bank Recon & Development
Note
3.5% Due 07/12/2028
09/07/2023
09/11/2023
140,000.00
134,137.57
0.00 0.00
134,247.45
2,300.28
2,450.00
258.61
408.33
109.88
0.00 109.88
518.21
518.21
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 24
Income Earned
As of January 31, 2024
City of Bell
Account #
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
459058KW2 Intl. Bank Recon & Development
Note
4.625% Due 08/01/2028
Various
Various
115,000.00
113,638.42
0.00 0.00
113,663.63
1,403.56
0.00 1,846.79
443.23
25.21 0.00
25.21 468.44
468.44
45950KCR9 International Finance Corp
Note
1.375% Due 10/16/2024
07/12/2021
07/14/2021
100,000.00
100,653.29
0.00 0.00
100,583.21
286.46
0.00 401.04
114.58
0.00 70.08
(70.08)
44.50 44.50
45950KDF4 International Finance Corp
Note
4.375% Due 01/15/2027
11/29/2023
12/06/2023
80,000.00
79,745.17
0.00 0.00
79,752.29
243.06
379.20
155.56
291.70
7.12 0.00
7.12 298.82
298.82
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
140,522.33
0.00 0.00
140,252.46
1,502.67
0.00 1,878.33
375.66
0.00 269.87
(269.87)
105.79
105.79
46647PDM5 JP Morgan Chase & Co
Callable Note Cont 12/15/2024
5.546% Due 12/15/2025
09/19/2023
09/21/2023
60,000.00
59,725.95
0.00 0.00
59,737.85
147.89
0.00 425.19
277.30
11.90 0.00
11.90 289.20
289.20
47787CAC7 John Deere Owner Trust
2023-C A3
5.48% Due 05/15/2028
09/12/2023
09/19/2023
105,000.00
104,993.37
0.00 0.00
104,993.54
255.73
479.50
255.73
479.50
0.17 0.00
0.17 479.67
479.67
47787JAC2 John Deere Owner Trust
2022-A A3
2.32% Due 09/16/2026
03/10/2022
03/16/2022
35,588.45
38,022.77
0.00 2,438.42
35,584.81
39.21 73.52
36.70 71.01
0.46 0.00
0.46 71.47
71.47 47788UAC6 John Deere Owner Trust
2021-A A3
0.36% Due 09/15/2025
03/02/2021
03/10/2021
9,733.31
11,395.23
0.00 1,662.40
9,732.95
1.82 3.42
1.56 3.16
0.12 0.00
0.12 3.28
3.28 47789QAC4 John Deere Owner Trust
2021-B A3
0.52% Due 03/16/2026
07/13/2021
07/21/2021
25,096.46
27,417.96
0.00 2,322.30
25,095.78
6.34 11.88
5.80 11.34
0.12 0.00
0.12 11.46
11.46 Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 25
Income Earned
As of January 31, 2024
City of Bell
Account #
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
47800AAC4 John Deere Owner Trust
2022-B A3
3.74% Due 02/16/2027
07/12/2022
07/20/2022
45,000.00
44,997.45
0.00 0.00
44,997.55
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
Due 11/15/2024
06/22/2021
06/29/2021
0.00 4,507.23
0.00 4,507.24
0.00 0.80
1.50 0.00
0.70 0.01
0.00 0.01
0.71 0.71
58770AAC7 Mercedes-Benz Auto Receivable
2023-1 A3
4.51% Due 11/15/2027
01/18/2023
01/25/2023
35,000.00
34,996.93
0.00 0.00
34,997.03
70.16 131.54
70.16 131.54
0.10 0.00
0.10 131.64
131.64
58933YBH7 Merck & Co
Callable Note Cont 4/17/2028
4.05% Due 05/17/2028
05/08/2023
05/17/2023
30,000.00
29,978.75
0.00 0.00
29,979.16
148.50
0.00 249.75
101.25
0.41 0.00
0.41 101.66
101.66
594918BX1 Microsoft
Callable Note Cont 12/6/2023
2.875% Due 02/06/2024
03/05/2020
03/09/2020
125,000.00
125,000.00
0.00 0.00
125,000.00
1,447.48
0.00 1,746.96
299.48
0.00 0.00
0.00 299.48
299.48
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
1,278.93
1,403.70
109.18
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,995.59
0.00 0.00
34,995.85
53.67 0.00
154.29
100.62
0.26 0.00
0.26 100.88
100.88
665859AW4 Northern Trust Company
Callable Note Cont 4/10/2027
4% Due 05/10/2027
09/28/2022
09/30/2022
150,000.00
146,649.26
0.00 0.00
146,734.06
850.00
0.00 1,350.00
500.00
84.80 0.00
84.80 584.80
584.80
69371RR40 Paccar Financial Corp
Note
0.5% Due 08/09/2024
08/03/2021
08/09/2021
50,000.00
49,994.56
0.00 0.00
49,995.32
98.61 0.00
119.44
20.83 0.76
0.00 0.76
21.59 21.59
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 26
Income Earned
As of January 31, 2024
City of Bell
Account #
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
69371RR57 Paccar Financial Corp
Note
0.9% Due 11/08/2024
11/02/2021
11/08/2021
90,000.00
89,998.46
0.00 0.00
89,998.62
119.25
0.00 186.75
67.50 0.16
0.00 0.16
67.66 67.66
69371RS56 Paccar Financial Corp
Note
5.05% Due 08/10/2026
12/08/2023
12/13/2023
80,000.00
80,168.63
0.00 0.00
80,163.14
1,582.33
0.00 1,919.00
336.67
0.00 5.49
(5.49)
331.18
331.18
78015K7C2 Royal Bank of Canada
Note
2.25% Due 11/01/2024
09/22/2020
09/24/2020
135,000.00
136,726.93
0.00 0.00
136,551.41
506.25
0.00 759.38
253.13
0.00 175.52
(175.52)
77.61 77.61
78016HZT0 ROYAL BANK OF CANADA
Note
4.875% Due 01/19/2027
01/10/2024
01/19/2024
105,000.00
0.00 104,973.75
0.00 104,974.06
0.00 0.00
170.63
170.63
0.31 0.00
0.31 170.94
170.94
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,998.18
0.00 0.00
19,998.47
57.64 62.50
5.56 10.42
0.29 0.00
0.29 10.71
10.71 808513BN4 Charles Schwab Corp
Callable Note Cont 2/18/2024
0.75% Due 03/18/2024
Various
Various
160,000.00
160,034.62
0.00 0.00
160,011.75
343.33
0.00 443.33
100.00
0.85 23.72
(22.87)
77.13 77.13
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
246.14
0.00 297.06
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
130,176.86
0.00 0.00
130,098.53
1,290.97
0.00 1,643.06
352.09
0.00 78.33
(78.33)
273.76
273.76
89115A2V3 Toronto-Dominion Bank
Note
5.264% Due 12/11/2026
12/04/2023
12/11/2023
55,000.00
55,000.00
0.00 0.00
55,000.00
160.84
0.00 402.11
241.27
0.00 0.00
0.00 241.27
241.27
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 27
Income Earned
As of January 31, 2024
City of Bell
Account #
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
89236TKN4 Toyota Motor Credit Corp
Note
4.8% Due 01/10/2025
01/10/2023
01/12/2023
130,000.00
129,953.86
0.00 0.00
129,957.67
2,964.00
3,120.00
364.00
520.00
3.81 0.00
3.81 523.81
523.81
89238DAD0 Toyota Auto Receivables OT
2024-A A3
4.83% Due 10/16/2028
01/23/2024
01/30/2024
60,000.00
0.00 59,987.99
0.00 59,988.01
0.00 0.00
8.05 8.05
0.02 0.00
0.02 8.07
8.07 89239FAD4 Toyota Auto Receivables Owner
2023-D A3
5.54% Due 08/15/2028
11/07/2023
11/14/2023
45,000.00
44,995.33
0.00 0.00
44,995.44
110.80
207.75
110.80
207.75
0.11 0.00
0.11 207.86
207.86
89240BAC2 Toyota Auto Receivables Owners
2021-A A3
0.26% Due 05/15/2025
02/02/2021
02/08/2021
10,333.92
12,873.55
0.00 2,539.79
10,333.85
1.49 2.79
1.19 2.49
0.09 0.00
0.09 2.58
2.58 91159HHX1 US Bancorp
Callable Note Cont 6/28/2024
2.4% Due 07/30/2024
03/25/2021
03/29/2021
150,000.00
151,270.57
0.00 0.00
151,050.53
1,510.00
1,800.00
10.00 300.00
0.00 220.04
(220.04)
79.96 79.96
9128286L9 US Treasury
Note
2.25% Due 03/31/2026
Various
Various
275,000.00
270,109.87
0.00 0.00
270,294.74
1,572.24
0.00 2,096.31
524.07
221.16
36.29 184.87
708.94
708.94
912828R36 US Treasury
Note
1.625% Due 05/15/2026
Various
Various
265,000.00
258,626.39
0.00 0.00
258,854.81
556.03
0.00 922.77
366.74
292.00
63.58 228.42
595.16
595.16
912828U24 US Treasury
Note
2% Due 11/15/2026
03/29/2022
03/30/2022
265,000.00
261,031.50
0.00 0.00
261,148.78
684.34
0.00 1,135.71
451.37
117.28
0.00 117.28
568.65
568.65
912828V80 US Treasury
Note
Due 01/31/2024
10/29/2019
10/30/2019
0.00 225,103.67
0.00 225,015.36
0.00 2,118.55
2,470.11
0.00 351.56
0.00 88.31
(88.31)
263.25
263.25
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 28
Income Earned
As of January 31, 2024
City of Bell
Account #
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
912828WJ5 US Treasury
Note
2.5% Due 05/15/2024
12/12/2019
12/13/2019
200,000.00
200,540.08
0.00 0.00
200,416.06
645.60
0.00 1,071.43
425.83
0.00 124.02
(124.02)
301.81
301.81
912828X88 US Treasury
Note
2.375% Due 05/15/2027
Various
Various
275,000.00
269,912.49
0.00 0.00
270,040.70
843.32
0.00 1,399.56
556.24
128.21
0.00 128.21
684.45
684.45
912828YG9 US Treasury
Note
1.625% Due 09/30/2026
12/28/2021
12/29/2021
200,000.00
202,040.23
0.00 0.00
201,977.17
825.82
0.00 1,101.09
275.27
0.00 63.06
(63.06)
212.21
212.21
912828ZF0 US Treasury
Note
0.5% Due 03/31/2025
03/25/2021
03/29/2021
125,000.00
124,878.52
0.00 0.00
124,886.79
158.81
0.00 211.75
52.94 8.27
0.00 8.27
61.21 61.21
912828ZT0 US Treasury
Note
0.25% Due 05/31/2025
02/25/2021
02/26/2021
250,000.00
248,784.79
0.00 0.00
248,857.80
54.64 0.00
107.58
52.94 73.01
0.00 73.01
125.95
125.95
91282CAZ4 US Treasury
Note
0.375% Due 11/30/2025
12/09/2020
12/10/2020
175,000.00
174,884.23
0.00 0.00
174,889.36
57.38 0.00
112.96
55.58 5.13
0.00 5.13
60.71 60.71
91282CBV2 US Treasury
Note
0.375% Due 04/15/2024
06/23/2023
06/26/2023
270,000.00
266,267.16
0.00 0.00
267,369.24
215.78
0.00 301.54
85.76 1,102.08
0.00 1,102.08
1,187.84
1,187.84
91282CCG4 US Treasury
Note
0.25% Due 06/15/2024
06/17/2021
06/18/2021
250,000.00
249,799.77
0.00 0.00
249,837.17
29.03 0.00
81.97 52.94
37.40 0.00
37.40 90.34
90.34 91282CCT6 US Treasury
Note
0.375% Due 08/15/2024
08/25/2021
08/26/2021
250,000.00
249,883.54
0.00 0.00
249,899.45
354.11
0.00 433.08
78.97 15.91
0.00 15.91
94.88 94.88
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 29
Income Earned
As of January 31, 2024
City of Bell
Account #
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
91282CDH1 US Treasury
Note
0.75% Due 11/15/2024
11/18/2021
11/19/2021
225,000.00
224,835.68
0.00 0.00
224,851.65
217.89
0.00 361.61
143.72
15.97 0.00
15.97 159.69
159.69
91282CEF4 US Treasury
Note
2.5% Due 03/31/2027
05/25/2022
05/26/2022
200,000.00
198,587.79
0.00 0.00
198,624.74
1,270.49
0.00 1,693.99
423.50
36.95 0.00
36.95 460.45
460.45
91282CEY3 US Treasury
Note
3% Due 07/15/2025
06/23/2023
06/26/2023
260,000.00
253,580.64
0.00 0.00
253,935.37
3,603.26
3,900.00
364.29
661.03
354.73
0.00 354.73
1,015.76
1,015.76
91282CFM8 US Treasury
Note
4.125% Due 09/30/2027
10/26/2022
10/27/2022
260,000.00
259,451.67
0.00 0.00
259,464.09
2,725.20
0.00 3,633.61
908.41
12.42 0.00
12.42 920.83
920.83
91282CGC9 US Treasury
Note
3.875% Due 12/31/2027
05/25/2023
05/26/2023
100,000.00
99,633.37
0.00 0.00
99,641.16
10.65 0.00
340.66
330.01
7.79 0.00
7.79 337.80
337.80
91282CGT2 US Treasury
Note
3.625% Due 03/31/2028
04/19/2023
04/20/2023
240,000.00
238,994.15
0.00 0.00
239,014.25
2,210.66
0.00 2,947.54
736.88
20.10 0.00
20.10 756.98
756.98
91324PEN8 United Health Group Inc
Note
Due 10/15/2025
10/25/2022
10/28/2022
0.00 34,998.10
0.00 34,998.11
0.00 380.53
400.56
0.00 20.03
0.01 0.00
0.01 20.04
20.04 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,974.38
0.00 0.00
24,975.18
75.83 0.00
97.71 21.88
0.80 0.00
0.80 22.68
22.68 931142EW9 Wal-Mart Stores
Note
3.9% Due 09/09/2025
09/06/2022
09/09/2022
30,000.00
29,988.18
0.00 0.00
29,988.77
364.00
0.00 461.50
97.50 0.59
0.00 0.59
98.09 98.09
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 30
Income Earned
As of January 31, 2024
City of Bell
Account #
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
Total Fixed Income 10,754,154.04
10,692,924.35
378,873.07
391,500.64
10,681,927.60
59,345.69
23,645.97
59,192.27
23,492.55
3,812.59
2,181.77
1,630.82
25,123.37
25,123.37
CASH & EQUIVALENT
31846V203 First American
Govt Obligation Fund Class Y
Various
Various
102,864.02
66,587.06
356,823.32
320,546.36
102,864.02
0.00 834.34
0.00 834.34
0.00 0.00
0.00 834.34
834.34
62479LDC6 MUFG Bank Ltd
Discount CP
5.66% Due 04/12/2024
07/25/2023
07/25/2023
210,000.00
201,349.63
0.00 0.00
201,349.63
5,282.67
0.00 6,306.19
1,023.52
0.00 0.00
0.00 1,023.52
1,023.52
912797JE8 US Treasury
Bill
5.263% Due 02/20/2024
12/27/2023
12/28/2023
75,000.00
74,407.97
0.00 0.00
74,407.97
43.85 0.00
383.72
339.87
0.00 0.00
0.00 339.87
339.87
Total Cash & Equivalent 387,864.02
342,344.66
356,823.32
320,546.36
378,621.62
5,326.52
834.34
6,689.91
2,197.73
0.00 0.00
0.00 2,197.73
2,197.73
TOTAL PORTFOLIO 11,142,018.06
11,035,269.01
735,696.39
712,047.00
11,060,549.22
64,672.21
24,480.31
65,882.18
25,690.28
3,812.59
2,181.77
1,630.82
27,321.10
27,321.10
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 31
Cash Flow Report
As of January 31, 2024
City of Bell
Account #
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 02/01/2024 Interest 459058KW2 115,000.00 Intl. Bank Recon & Development Note
4.625% Due 8/1/2028
0.00 1,846.79 1,846.79
02/01/2024 Interest 4581X0EM6 215,000.00 Inter-American Dev Bank Note
4.375% Due 2/1/2027
0.00 1,280.30 1,280.30
02/01/2024 Paydown 3137FHPJ6 110,000.00 FHLMC Multifamily Structured K080 - A2
3.926% Due 7/25/2028
0.00 359.88 359.88
02/05/2024 Call 594918BX1 125,000.00 Microsoft Callable Note Cont 12/6/2023
2.875% Due 2/6/2024
125,000.00 1,786.89 126,786.89
02/06/2024 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/09/2024 Interest 037833CJ7 150,000.00 Apple Inc Callable Note Cont 11/9/2026
3.35% Due 2/9/2027
0.00 2,512.50 2,512.50
02/09/2024 Interest 69371RR40 50,000.00 Paccar Financial Corp Note
0.5% Due 8/9/2024
0.00 125.00 125.00
02/10/2024 Interest 69371RS56 80,000.00 Paccar Financial Corp Note
5.05% Due 8/10/2026
0.00 2,020.00 2,020.00
02/15/2024 Interest 438516CJ3 125,000.00 Honeywell Intl Callable Note Cont 01/15/2028
4.95% Due 2/15/2028
0.00 3,093.75 3,093.75
02/15/2024 Interest 91282CCT6 250,000.00 US Treasury Note
0.375% Due 8/15/2024
0.00 468.75 468.75
02/15/2024 Paydown 02582JKD1 115,000.00 American Express Credit Trust 2023-3 A
5.23% Due 9/15/2028
0.00 501.21 501.21
02/15/2024 Paydown 448979AD6 50,000.00 Hyundai Auto Receivables Trust 2023-A A3
4.58% Due 4/15/2027
0.00 190.83 190.83
02/15/2024 Paydown 89238DAD0 60,000.00 Toyota Auto Receivables OT 2024-A A3
4.83% Due 10/16/2028
0.00 120.75 120.75
02/15/2024 Paydown 44891RAC4 3,707.86 Hyundai Auto Receivables Trust 2020-C A3
0.38% Due 5/15/2025
3,707.86 1.17 3,709.03
02/15/2024 Paydown 47787CAC7 105,000.00 John Deere Owner Trust 2023-C A3
5.48% Due 5/15/2028
0.00 479.50 479.50
02/15/2024 Paydown 47788UAC6 9,733.31 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
1,080.07 2.92 1,082.99
02/15/2024 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: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 32
Cash Flow Report
As of January 31, 2024
City of Bell
Account #
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 02/15/2024 Paydown 89239FAD4 45,000.00 Toyota Auto Receivables Owner 2023-D A3
5.54% Due 8/15/2028
0.00 207.75 207.75
02/15/2024 Paydown 44935FAD6 15,933.18 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due 5/15/2026
1,326.54 9.83 1,336.37
02/15/2024 Paydown 47787JAC2 35,588.45 John Deere Owner Trust 2022-A A3
2.32% Due 9/16/2026
1,757.83 68.80 1,826.63
02/15/2024 Paydown 47789QAC4 25,096.46 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
1,791.53 10.88 1,802.41
02/15/2024 Paydown 58770AAC7 35,000.00 Mercedes-Benz Auto Receivable 2023-1 A3
4.51% Due 11/15/2027
0.00 131.54 131.54
02/15/2024 Paydown 89240BAC2 10,333.92 Toyota Auto Receivables Owners 2021-A A3
0.26% Due 5/15/2025
5,166.12 2.24 5,168.36
02/15/2024 Paydown 43815BAC4 50,306.05 Honda Auto Receivables Trust 2022-1 A3
1.88% Due 5/15/2026
3,042.05 78.81 3,120.86
02/16/2024 Paydown 362554AC1 16,877.00 GM Financial Securitized Term 2021-4 A3
0.68% Due 9/16/2026
1,203.68 9.56 1,213.24
02/16/2024 Paydown 362583AD8 40,000.00 GM Auto Receivable Trust 2023-2 A3
4.47% Due 2/16/2028
0.00 149.00 149.00
02/16/2024 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/16/2024 Paydown 380146AC4 19,609.31 GM Financial Auto Receivables 2022-1 A3
1.26% Due 11/16/2026
1,185.79 20.59 1,206.38
02/18/2024 Call 808513BN4 100,000.00 Charles Schwab Corp Callable Note Cont 2/18/2024
0.75% Due 3/18/2024
100,000.00 312.50 100,312.50
02/18/2024 Paydown 43815PAC3 35,000.00 Honda Auto Receivables 2022-2 A3
3.73% Due 7/20/2026
0.00 108.79 108.79
02/19/2024 Paydown 3137BNGT5 0.00 FHLMC K054 A2
2.745% Due 1/25/2026
0.00 400.31 400.31
02/19/2024 Paydown 3137FJEH8 0.00 FHLMC K081 A2
3.9% Due 8/25/2028
0.00 341.25 341.25
02/19/2024 Paydown 3137H4BY5 0.00 FHLMC K746 A2
2.031% Due 9/25/2028
0.00 186.18 186.18
02/20/2024 Maturity 912797JE8 75,000.00 US Treasury Bill
5.263% Due 2/20/2024
74,407.97 592.03 75,000.00
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 33
Cash Flow Report
As of January 31, 2024
City of Bell
Account #
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 02/20/2024 Paydown 379929AD4 10,000.00 GM Financial Auto Leasing 2023-3 A3
5.38% Due 11/20/2026
0.00 44.83 44.83
02/20/2024 Paydown 36266FAC3 40,605.31 GM Financial Auto Lease Trust 2022-2 A3
3.42% Due 6/20/2025
6,763.46 115.73 6,879.19
02/21/2024 Paydown 438123AC5 35,000.00 Honda Auto Receivables OT 2023-4 A3
5.67% Due 6/21/2028
0.00 165.38 165.38
02/21/2024 Paydown 43815GAC3 22,560.61 Honda Auto Receivables Trust 2021-4 A3
0.88% Due 1/21/2026
1,733.01 16.54 1,749.55
02/21/2024 Paydown 43813GAC5 3,300.32 Honda Auto Receivables Trust 2021-1 A3
0.27% Due 4/21/2025
1,649.96 0.74 1,650.70
02/21/2024 Paydown 43815JAC7 25,000.00 Honda Auto Receivables Owner 2023-1 A3
5.04% Due 4/21/2027
0.00 105.00 105.00
02/25/2024 Paydown 05601XAC3 5,502.26 BMW Vehicle Lease Trust 2022-1 A3
1.1% Due 3/25/2025
2,745.12 5.04 2,750.16
02/25/2024 Paydown 3137BNGT5 175,000.00 FHLMC K054 A2
2.745% Due 1/25/2026
0.00 400.31 400.31
02/25/2024 Paydown 3137FETN0 160,000.00 FHLMC K073 A2
3.35% Due 1/25/2028
0.00 446.67 446.67
02/25/2024 Paydown 3137FKZZ2 110,000.00 FHLMC K088 A2
3.69% Due 1/25/2029
0.00 338.25 338.25
02/25/2024 Paydown 3137H4BY5 110,000.00 FHLMC K746 A2
2.031% Due 9/25/2028
0.00 186.18 186.18
02/25/2024 Paydown 05593AAC3 15,000.00 BMW Vehicle Lease Trust 2023-1 A3
5.16% Due 11/25/2025
0.00 64.50 64.50
02/25/2024 Paydown 3137FJEH8 105,000.00 FHLMC K081 A2
3.9% Due 8/25/2028
0.00 341.25 341.25
FEB 2024 332,560.99 20,187.52 352,748.51
03/01/2024 Call 46647PAH9 140,000.00 JP Morgan Chase & Co Callable Note 2X 3/1/2024
3.22% Due 3/1/2025
140,000.00 2,254.00 142,254.00
03/01/2024 Paydown 3137FHPJ6 110,000.00 FHLMC Multifamily Structured K080 - A2
3.926% Due 7/25/2028
0.00 359.88 359.88
03/08/2024 Maturity 3130AB3H7 225,000.00 FHLB Note
2.375% Due 3/8/2024
225,000.00 2,671.88 227,671.88
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 34
Cash Flow Report
As of January 31, 2024
City of Bell
Account #
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 03/09/2024 Interest 931142EW9 30,000.00 Wal-Mart Stores Note
3.9% Due 9/9/2025
0.00 585.00 585.00
03/10/2024 Interest 3130ATS57 275,000.00 FHLB Note
4.5% Due 3/10/2028
0.00 6,187.50 6,187.50
03/11/2024 Maturity 89114QCB2 130,000.00 Toronto Dominion Bank Note
3.25% Due 3/11/2024
130,000.00 2,112.50 132,112.50
03/15/2024 Interest 437076CR1 40,000.00 Home Depot Callable Note Cont 8/15/2025 4% Due 9/15/2025
0.00 800.00 800.00
03/15/2024 Paydown 44935FAD6 15,933.18 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due 5/15/2026
1,326.77 9.01 1,335.78
03/15/2024 Paydown 43815BAC4 50,306.05 Honda Auto Receivables Trust 2022-1 A3
1.88% Due 5/15/2026
3,055.38 74.05 3,129.43
03/15/2024 Paydown 47788UAC6 9,733.31 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
1,080.42 2.60 1,083.02
03/15/2024 Paydown 47800AAC4 45,000.00 John Deere Owner Trust 2022-B A3
3.74% Due 2/16/2027
1,832.29 140.25 1,972.54
03/15/2024 Paydown 47787CAC7 105,000.00 John Deere Owner Trust 2023-C A3
5.48% Due 5/15/2028
0.00 479.50 479.50
03/15/2024 Paydown 47787JAC2 35,588.45 John Deere Owner Trust 2022-A A3
2.32% Due 9/16/2026
1,760.08 65.41 1,825.49
03/15/2024 Paydown 02582JKD1 115,000.00 American Express Credit Trust 2023-3 A
5.23% Due 9/15/2028
0.00 501.21 501.21
03/15/2024 Paydown 448979AD6 50,000.00 Hyundai Auto Receivables Trust 2023-A A3
4.58% Due 4/15/2027
0.00 190.83 190.83
03/15/2024 Paydown 47789QAC4 25,096.46 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
1,791.70 10.10 1,801.80
03/15/2024 Paydown 58770AAC7 35,000.00 Mercedes-Benz Auto Receivable 2023-1 A3
4.51% Due 11/15/2027
0.00 131.54 131.54
03/15/2024 Paydown 89238DAD0 60,000.00 Toyota Auto Receivables OT 2024-A A3
4.83% Due 10/16/2028
0.00 241.50 241.50
03/15/2024 Paydown 89239FAD4 45,000.00 Toyota Auto Receivables Owner 2023-D A3
5.54% Due 8/15/2028
0.00 207.75 207.75
03/15/2024 Paydown 89240BAC2 10,333.92 Toyota Auto Receivables Owners 2021-A A3
0.26% Due 5/15/2025
5,167.80 1.12 5,168.92
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 35
Cash Flow Report
As of January 31, 2024
City of Bell
Account #
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 03/16/2024 Paydown 380146AC4 19,609.31 GM Financial Auto Receivables 2022-1 A3
1.26% Due 11/16/2026
1,190.99 19.34 1,210.33
03/16/2024 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/16/2024 Paydown 362554AC1 16,877.00 GM Financial Securitized Term 2021-4 A3
0.68% Due 9/16/2026
1,203.96 8.88 1,212.84
03/16/2024 Paydown 362583AD8 40,000.00 GM Auto Receivable Trust 2023-2 A3
4.47% Due 2/16/2028
0.00 149.00 149.00
03/17/2024 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/2024 Maturity 808513BN4 60,000.00 Charles Schwab Corp Callable Note Cont 2/18/2024
0.75% Due 3/18/2024
60,000.00 225.00 60,225.00
03/18/2024 Paydown 43815PAC3 35,000.00 Honda Auto Receivables 2022-2 A3
3.73% Due 7/20/2026
1,838.10 108.79 1,946.89
03/19/2024 Maturity 459058GQ0 150,000.00 Intl. Bank Recon & Development Note
2.5% Due 3/19/2024
150,000.00 1,875.00 151,875.00
03/20/2024 Paydown 379929AD4 10,000.00 GM Financial Auto Leasing 2023-3 A3
5.38% Due 11/20/2026
0.00 44.83 44.83
03/20/2024 Paydown 36266FAC3 40,605.31 GM Financial Auto Lease Trust 2022-2 A3
3.42% Due 6/20/2025
6,765.10 96.45 6,861.55
03/21/2024 Paydown 438123AC5 35,000.00 Honda Auto Receivables OT 2023-4 A3
5.67% Due 6/21/2028
0.00 165.38 165.38
03/21/2024 Paydown 43813GAC5 3,300.32 Honda Auto Receivables Trust 2021-1 A3
0.27% Due 4/21/2025
1,650.36 0.37 1,650.73
03/21/2024 Paydown 43815JAC7 25,000.00 Honda Auto Receivables Owner 2023-1 A3
5.04% Due 4/21/2027
0.00 105.00 105.00
03/21/2024 Paydown 43815GAC3 22,560.61 Honda Auto Receivables Trust 2021-4 A3
0.88% Due 1/21/2026
1,733.41 15.27 1,748.68
03/23/2024 Interest 4581X0DZ8 170,000.00 Inter-American Dev Bank Note
0.5% Due 9/23/2024
0.00 425.00 425.00
03/25/2024 Paydown 05601XAC3 5,502.26 BMW Vehicle Lease Trust 2022-1 A3
1.1% Due 3/25/2025
2,757.14 2.53 2,759.67
03/25/2024 Paydown 3137FKZZ2 110,000.00 FHLMC K088 A2
3.69% Due 1/25/2029
0.00 338.25 338.25
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 36
Cash Flow Report
As of January 31, 2024
City of Bell
Account #
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 03/25/2024 Paydown 05593AAC3 15,000.00 BMW Vehicle Lease Trust 2023-1 A3
5.16% Due 11/25/2025
0.00 64.50 64.50
03/25/2024 Paydown 3137BNGT5 175,000.00 FHLMC K054 A2
2.745% Due 1/25/2026
0.00 400.31 400.31
03/25/2024 Paydown 3137FETN0 160,000.00 FHLMC K073 A2
3.35% Due 1/25/2028
0.00 446.67 446.67
03/25/2024 Paydown 3137FJEH8 105,000.00 FHLMC K081 A2
3.9% Due 8/25/2028
0.00 341.25 341.25
03/25/2024 Paydown 3137H4BY5 110,000.00 FHLMC K746 A2
2.031% Due 9/25/2028
0.00 186.18 186.18
03/31/2024 Interest 912828YG9 200,000.00 US Treasury Note
1.625% Due 9/30/2026
0.00 1,625.00 1,625.00
03/31/2024 Interest 91282CGT2 240,000.00 US Treasury Note
3.625% Due 3/31/2028
0.00 4,350.00 4,350.00
03/31/2024 Interest 912828ZF0 125,000.00 US Treasury Note
0.5% Due 3/31/2025
0.00 312.50 312.50
03/31/2024 Interest 91282CEF4 200,000.00 US Treasury Note
2.5% Due 3/31/2027
0.00 2,500.00 2,500.00
03/31/2024 Interest 91282CFM8 260,000.00 US Treasury Note
4.125% Due 9/30/2027
0.00 5,362.50 5,362.50
03/31/2024 Interest 9128286L9 275,000.00 US Treasury Note
2.25% Due 3/31/2026
0.00 3,093.75 3,093.75
MAR 2024 738,153.50 39,509.63 777,663.13
04/01/2024 Interest 13063D7D4 100,000.00 California State STE-GO
5.5% Due 10/1/2028
0.00 2,597.22 2,597.22
04/01/2024 Paydown 3137FHPJ6 110,000.00 FHLMC Multifamily Structured K080 - A2
3.926% Due 7/25/2028
0.00 359.88 359.88
04/12/2024 Maturity 62479LDC6 210,000.00 MUFG Bank Ltd Discount CP
5.66% Due 4/12/2024
201,349.63 8,650.37 210,000.00
04/15/2024 Maturity 91282CBV2 270,000.00 US Treasury Note
0.375% Due 4/15/2024
270,000.00 506.25 270,506.25
04/15/2024 Paydown 43815BAC4 50,306.05 Honda Auto Receivables Trust 2022-1 A3
1.88% Due 5/15/2026
3,068.77 69.26 3,138.03
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 37
Cash Flow Report
As of January 31, 2024
City of Bell
Account #
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 04/15/2024 Paydown 47789QAC4 25,096.46 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
1,791.87 9.32 1,801.19
04/15/2024 Paydown 58770AAC7 35,000.00 Mercedes-Benz Auto Receivable 2023-1 A3
4.51% Due 11/15/2027
0.00 131.54 131.54
04/15/2024 Paydown 89239FAD4 45,000.00 Toyota Auto Receivables Owner 2023-D A3
5.54% Due 8/15/2028
0.00 207.75 207.75
04/15/2024 Paydown 47787CAC7 105,000.00 John Deere Owner Trust 2023-C A3
5.48% Due 5/15/2028
0.00 479.50 479.50
04/15/2024 Paydown 47787JAC2 35,588.45 John Deere Owner Trust 2022-A A3
2.32% Due 9/16/2026
1,762.34 62.00 1,824.34
04/15/2024 Paydown 47788UAC6 9,733.31 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
1,080.78 2.27 1,083.05
04/15/2024 Paydown 47800AAC4 45,000.00 John Deere Owner Trust 2022-B A3
3.74% Due 2/16/2027
1,835.95 134.54 1,970.49
04/15/2024 Paydown 02582JKD1 115,000.00 American Express Credit Trust 2023-3 A
5.23% Due 9/15/2028
0.00 501.21 501.21
04/15/2024 Paydown 448979AD6 50,000.00 Hyundai Auto Receivables Trust 2023-A A3
4.58% Due 4/15/2027
0.00 190.83 190.83
04/15/2024 Paydown 44935FAD6 15,933.18 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due 5/15/2026
1,326.99 8.19 1,335.18
04/15/2024 Paydown 89238DAD0 60,000.00 Toyota Auto Receivables OT 2024-A A3
4.83% Due 10/16/2028
0.00 241.50 241.50
04/16/2024 Interest 45950KCR9 100,000.00 International Finance Corp Note
1.375% Due 10/16/2024
0.00 687.50 687.50
04/16/2024 Paydown 362554AC1 16,877.00 GM Financial Securitized Term 2021-4 A3
0.68% Due 9/16/2026
1,204.23 8.20 1,212.43
04/16/2024 Paydown 380146AC4 19,609.31 GM Financial Auto Receivables 2022-1 A3
1.26% Due 11/16/2026
1,196.21 18.09 1,214.30
04/16/2024 Paydown 362583AD8 40,000.00 GM Auto Receivable Trust 2023-2 A3
4.47% Due 2/16/2028
0.00 149.00 149.00
04/16/2024 Paydown 36265WAD5 30,000.00 GM Financial Securitized Auto 2022-3 A3
3.64% Due 4/16/2027
1,621.84 91.00 1,712.84
04/18/2024 Paydown 43815PAC3 35,000.00 Honda Auto Receivables 2022-2 A3
3.73% Due 7/20/2026
1,838.54 103.08 1,941.62
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 38
Cash Flow Report
As of January 31, 2024
City of Bell
Account #
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 04/20/2024 Paydown 36266FAC3 40,605.31 GM Financial Auto Lease Trust 2022-2 A3
3.42% Due 6/20/2025
6,766.73 77.17 6,843.90
04/20/2024 Paydown 379929AD4 10,000.00 GM Financial Auto Leasing 2023-3 A3
5.38% Due 11/20/2026
0.00 44.83 44.83
04/21/2024 Paydown 438123AC5 35,000.00 Honda Auto Receivables OT 2023-4 A3
5.67% Due 6/21/2028
0.00 165.38 165.38
04/21/2024 Paydown 43815GAC3 22,560.61 Honda Auto Receivables Trust 2021-4 A3
0.88% Due 1/21/2026
1,733.81 14.00 1,747.81
04/21/2024 Paydown 43815JAC7 25,000.00 Honda Auto Receivables Owner 2023-1 A3
5.04% Due 4/21/2027
0.00 105.00 105.00
04/25/2024 Paydown 3137BNGT5 175,000.00 FHLMC K054 A2
2.745% Due 1/25/2026
0.00 400.31 400.31
04/25/2024 Paydown 3137FETN0 160,000.00 FHLMC K073 A2
3.35% Due 1/25/2028
0.00 446.67 446.67
04/25/2024 Paydown 3137FKZZ2 110,000.00 FHLMC K088 A2
3.69% Due 1/25/2029
0.00 338.25 338.25
04/25/2024 Paydown 3137H4BY5 110,000.00 FHLMC K746 A2
2.031% Due 9/25/2028
0.00 186.18 186.18
04/25/2024 Paydown 05593AAC3 15,000.00 BMW Vehicle Lease Trust 2023-1 A3
5.16% Due 11/25/2025
0.00 64.50 64.50
04/25/2024 Paydown 3137FJEH8 105,000.00 FHLMC K081 A2
3.9% Due 8/25/2028
0.00 341.25 341.25
APR 2024 496,577.69 17,392.04 513,969.73
05/01/2024 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/01/2024 Paydown 3137FHPJ6 110,000.00 FHLMC Multifamily Structured K080 - A2
3.926% Due 7/25/2028
0.00 359.88 359.88
05/03/2024 Interest 00440EAV9 135,000.00 Chubb INA Holdings Inc Callable Note Cont 2/3/2026
3.35% Due 5/3/2026
0.00 2,261.25 2,261.25
05/07/2024 Interest 3135G06G3 225,000.00 FNMA Note
0.5% Due 11/7/2025
0.00 562.50 562.50
05/08/2024 Interest 69371RR57 90,000.00 Paccar Financial Corp Note
0.9% Due 11/8/2024
0.00 405.00 405.00
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 39
Cash Flow Report
As of January 31, 2024
City of Bell
Account #
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 05/10/2024 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/2024 Maturity 023135BW5 85,000.00 Amazon.com Inc Note
0.45% Due 5/12/2024
85,000.00 191.25 85,191.25
05/15/2024 Interest 912828U24 265,000.00 US Treasury Note 2% Due 11/15/2026
0.00 2,650.00 2,650.00
05/15/2024 Interest 91282CDH1 225,000.00 US Treasury Note
0.75% Due 11/15/2024
0.00 843.75 843.75
05/15/2024 Interest 912828R36 265,000.00 US Treasury Note
1.625% Due 5/15/2026
0.00 2,153.13 2,153.13
05/15/2024 Interest 912828X88 275,000.00 US Treasury Note
2.375% Due 5/15/2027
0.00 3,265.63 3,265.63
05/15/2024 Maturity 912828WJ5 200,000.00 US Treasury Note
2.5% Due 5/15/2024
200,000.00 2,500.00 202,500.00
05/15/2024 Paydown 44935FAD6 15,933.18 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due 5/15/2026
1,327.21 7.37 1,334.58
05/15/2024 Paydown 47788UAC6 9,733.31 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
1,081.12 1.95 1,083.07
05/15/2024 Paydown 47800AAC4 45,000.00 John Deere Owner Trust 2022-B A3
3.74% Due 2/16/2027
1,839.61 128.82 1,968.43
05/15/2024 Paydown 43815BAC4 50,306.05 Honda Auto Receivables Trust 2022-1 A3
1.88% Due 5/15/2026
3,082.23 64.45 3,146.68
05/15/2024 Paydown 47787JAC2 35,588.45 John Deere Owner Trust 2022-A A3
2.32% Due 9/16/2026
1,764.60 58.60 1,823.20
05/15/2024 Paydown 47789QAC4 25,096.46 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
1,792.03 8.55 1,800.58
05/15/2024 Paydown 58770AAC7 35,000.00 Mercedes-Benz Auto Receivable 2023-1 A3
4.51% Due 11/15/2027
0.00 131.54 131.54
05/15/2024 Paydown 02582JKD1 115,000.00 American Express Credit Trust 2023-3 A
5.23% Due 9/15/2028
0.00 501.21 501.21
05/15/2024 Paydown 448979AD6 50,000.00 Hyundai Auto Receivables Trust 2023-A A3
4.58% Due 4/15/2027
0.00 190.83 190.83
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 40
Cash Flow Report
As of January 31, 2024
City of Bell
Account #
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 05/15/2024 Paydown 47787CAC7 105,000.00 John Deere Owner Trust 2023-C A3
5.48% Due 5/15/2028
0.00 479.50 479.50
05/15/2024 Paydown 89238DAD0 60,000.00 Toyota Auto Receivables OT 2024-A A3
4.83% Due 10/16/2028
0.00 241.50 241.50
05/15/2024 Paydown 89239FAD4 45,000.00 Toyota Auto Receivables Owner 2023-D A3
5.54% Due 8/15/2028
0.00 207.75 207.75
05/16/2024 Paydown 380146AC4 19,609.31 GM Financial Auto Receivables 2022-1 A3
1.26% Due 11/16/2026
1,201.45 16.84 1,218.29
05/16/2024 Paydown 362583AD8 40,000.00 GM Auto Receivable Trust 2023-2 A3
4.47% Due 2/16/2028
0.00 149.00 149.00
05/16/2024 Paydown 362554AC1 16,877.00 GM Financial Securitized Term 2021-4 A3
0.68% Due 9/16/2026
1,204.51 7.52 1,212.03
05/16/2024 Paydown 36265WAD5 30,000.00 GM Financial Securitized Auto 2022-3 A3
3.64% Due 4/16/2027
1,627.02 86.08 1,713.10
05/17/2024 Interest 3130AXU63 160,000.00 Federal Home Loan Banks Note
4.625% Due 11/17/2026
0.00 3,700.00 3,700.00
05/17/2024 Interest 58933YBH7 30,000.00 Merck & Co Callable Note Cont 4/17/2028
4.05% Due 5/17/2028
0.00 607.50 607.50
05/17/2024 Maturity 14913R2L0 135,000.00 Caterpillar Financial Service Note
0.45% Due 5/17/2024
135,000.00 303.75 135,303.75
05/18/2024 Paydown 43815PAC3 35,000.00 Honda Auto Receivables 2022-2 A3
3.73% Due 7/20/2026
1,838.99 97.36 1,936.35
05/20/2024 Paydown 36266FAC3 40,605.31 GM Financial Auto Lease Trust 2022-2 A3
3.42% Due 6/20/2025
6,768.37 57.88 6,826.25
05/20/2024 Paydown 379929AD4 10,000.00 GM Financial Auto Leasing 2023-3 A3
5.38% Due 11/20/2026
0.00 44.83 44.83
05/21/2024 Paydown 438123AC5 35,000.00 Honda Auto Receivables OT 2023-4 A3
5.67% Due 6/21/2028
0.00 165.38 165.38
05/21/2024 Paydown 43815JAC7 25,000.00 Honda Auto Receivables Owner 2023-1 A3
5.04% Due 4/21/2027
0.00 105.00 105.00
05/21/2024 Paydown 43815GAC3 22,560.61 Honda Auto Receivables Trust 2021-4 A3
0.88% Due 1/21/2026
1,734.22 12.73 1,746.95
05/25/2024 Paydown 3137FETN0 160,000.00 FHLMC K073 A2
3.35% Due 1/25/2028
0.00 446.67 446.67
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 41
Cash Flow Report
As of January 31, 2024
City of Bell
Account #
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 05/25/2024 Paydown 3137H4BY5 110,000.00 FHLMC K746 A2
2.031% Due 9/25/2028
0.00 186.18 186.18
05/25/2024 Paydown 05593AAC3 15,000.00 BMW Vehicle Lease Trust 2023-1 A3
5.16% Due 11/25/2025
0.00 64.50 64.50
05/25/2024 Paydown 3137BNGT5 175,000.00 FHLMC K054 A2
2.745% Due 1/25/2026
0.00 400.31 400.31
05/25/2024 Paydown 3137FJEH8 105,000.00 FHLMC K081 A2
3.9% Due 8/25/2028
0.00 341.25 341.25
05/25/2024 Paydown 3137FKZZ2 110,000.00 FHLMC K088 A2
3.69% Due 1/25/2029
0.00 338.25 338.25
05/31/2024 Interest 91282CAZ4 175,000.00 US Treasury Note
0.375% Due 11/30/2025
0.00 328.13 328.13
05/31/2024 Interest 912828ZT0 250,000.00 US Treasury Note
0.25% Due 5/31/2025
0.00 312.50 312.50
MAY 2024 445,261.36 29,504.87 474,766.23
06/01/2024 Paydown 3137FHPJ6 110,000.00 FHLMC Multifamily Structured K080 - A2
3.926% Due 7/25/2028
0.00 359.88 359.88
06/11/2024 Interest 89115A2V3 55,000.00 Toronto-Dominion Bank Note
5.264% Due 12/11/2026
0.00 1,447.60 1,447.60
06/14/2024 Maturity 3130A1XJ2 250,000.00 FHLB Note
2.875% Due 6/14/2024
250,000.00 3,593.75 253,593.75
06/15/2024 Interest 3133EPN50 110,000.00 FFCB Note
4.25% Due 12/15/2028
0.00 2,337.50 2,337.50
06/15/2024 Interest 46647PDM5 60,000.00 JP Morgan Chase & Co Callable Note Cont 12/15/2024
5.546% Due 12/15/2025
0.00 1,663.80 1,663.80
06/15/2024 Interest 63743HFE7 35,000.00 National Rural Utilities Note
3.45% Due 6/15/2025
0.00 603.75 603.75
06/15/2024 Maturity 91282CCG4 250,000.00 US Treasury Note
0.25% Due 6/15/2024
250,000.00 312.50 250,312.50
06/15/2024 Paydown 02582JKD1 115,000.00 American Express Credit Trust 2023-3 A
5.23% Due 9/15/2028
0.00 501.21 501.21
06/15/2024 Paydown 44935FAD6 15,933.18 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due 5/15/2026
1,327.44 6.55 1,333.99
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 42
Cash Flow Report
As of January 31, 2024
City of Bell
Account #
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 06/15/2024 Paydown 89238DAD0 60,000.00 Toyota Auto Receivables OT 2024-A A3
4.83% Due 10/16/2028
0.00 241.50 241.50
06/15/2024 Paydown 47787JAC2 35,588.45 John Deere Owner Trust 2022-A A3
2.32% Due 9/16/2026
1,766.87 55.18 1,822.05
06/15/2024 Paydown 47789QAC4 25,096.46 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
1,792.19 7.77 1,799.96
06/15/2024 Paydown 58770AAC7 35,000.00 Mercedes-Benz Auto Receivable 2023-1 A3
4.51% Due 11/15/2027
0.00 131.54 131.54
06/15/2024 Paydown 43815BAC4 50,306.05 Honda Auto Receivables Trust 2022-1 A3
1.88% Due 5/15/2026
3,095.74 59.62 3,155.36
06/15/2024 Paydown 448979AD6 50,000.00 Hyundai Auto Receivables Trust 2023-A A3
4.58% Due 4/15/2027
0.00 190.83 190.83
06/15/2024 Paydown 47787CAC7 105,000.00 John Deere Owner Trust 2023-C A3
5.48% Due 5/15/2028
0.00 479.50 479.50
06/15/2024 Paydown 47788UAC6 9,733.31 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
1,081.48 1.62 1,083.10
06/15/2024 Paydown 47800AAC4 45,000.00 John Deere Owner Trust 2022-B A3
3.74% Due 2/16/2027
1,843.29 123.08 1,966.37
06/15/2024 Paydown 89239FAD4 45,000.00 Toyota Auto Receivables Owner 2023-D A3
5.54% Due 8/15/2028
0.00 207.75 207.75
06/16/2024 Paydown 36265WAD5 30,000.00 GM Financial Securitized Auto 2022-3 A3
3.64% Due 4/16/2027
1,632.22 81.15 1,713.37
06/16/2024 Paydown 362583AD8 40,000.00 GM Auto Receivable Trust 2023-2 A3
4.47% Due 2/16/2028
0.00 149.00 149.00
06/16/2024 Paydown 380146AC4 19,609.31 GM Financial Auto Receivables 2022-1 A3
1.26% Due 11/16/2026
1,206.71 15.58 1,222.29
06/16/2024 Paydown 362554AC1 16,877.00 GM Financial Securitized Term 2021-4 A3
0.68% Due 9/16/2026
1,204.80 6.83 1,211.63
06/18/2024 Paydown 43815PAC3 35,000.00 Honda Auto Receivables 2022-2 A3
3.73% Due 7/20/2026
1,839.43 91.65 1,931.08
06/20/2024 Paydown 379929AD4 10,000.00 GM Financial Auto Leasing 2023-3 A3
5.38% Due 11/20/2026
0.00 44.83 44.83
06/20/2024 Paydown 36266FAC3 40,605.31 GM Financial Auto Lease Trust 2022-2 A3
3.42% Due 6/20/2025
6,770.01 38.59 6,808.60
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 43
Cash Flow Report
As of January 31, 2024
City of Bell
Account #
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 06/21/2024 Paydown 438123AC5 35,000.00 Honda Auto Receivables OT 2023-4 A3
5.67% Due 6/21/2028
0.00 165.38 165.38
06/21/2024 Paydown 43815GAC3 22,560.61 Honda Auto Receivables Trust 2021-4 A3
0.88% Due 1/21/2026
1,734.62 11.46 1,746.08
06/21/2024 Paydown 43815JAC7 25,000.00 Honda Auto Receivables Owner 2023-1 A3
5.04% Due 4/21/2027
0.00 105.00 105.00
06/25/2024 Paydown 3137BNGT5 175,000.00 FHLMC K054 A2
2.745% Due 1/25/2026
0.00 400.31 400.31
06/25/2024 Paydown 3137FETN0 160,000.00 FHLMC K073 A2
3.35% Due 1/25/2028
0.00 446.67 446.67
06/25/2024 Paydown 3137FKZZ2 110,000.00 FHLMC K088 A2
3.69% Due 1/25/2029
0.00 338.25 338.25
06/25/2024 Paydown 3137H4BY5 110,000.00 FHLMC K746 A2
2.031% Due 9/25/2028
0.00 186.18 186.18
06/25/2024 Paydown 3137FJEH8 105,000.00 FHLMC K081 A2
3.9% Due 8/25/2028
0.00 341.25 341.25
06/25/2024 Paydown 05593AAC3 15,000.00 BMW Vehicle Lease Trust 2023-1 A3
5.16% Due 11/25/2025
1,474.30 64.50 1,538.80
06/28/2024 Call 91159HHX1 150,000.00 US Bancorp Callable Note Cont 6/28/2024
2.4% Due 7/30/2024
150,000.00 1,480.00 151,480.00
06/30/2024 Interest 91282CGC9 100,000.00 US Treasury Note
3.875% Due 12/31/2027
0.00 1,937.50 1,937.50
JUN 2024 676,769.10 18,229.06 694,998.16
07/01/2024 Paydown 3137FHPJ6 110,000.00 FHLMC Multifamily Structured K080 - A2
3.926% Due 7/25/2028
0.00 359.88 359.88
07/06/2024 Interest 3133ENKS8 80,000.00 FFCB Note
1.125% Due 1/6/2025
0.00 450.00 450.00
07/10/2024 Interest 89236TKN4 130,000.00 Toyota Motor Credit Corp Note
4.8% Due 1/10/2025
0.00 3,120.00 3,120.00
07/12/2024 Interest 459058KT9 140,000.00 Intl. Bank Recon & Development Note
3.5% Due 7/12/2028
0.00 2,450.00 2,450.00
07/15/2024 Interest 91282CEY3 260,000.00 US Treasury Note 3% Due 7/15/2025
0.00 3,900.00 3,900.00
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 44
Cash Flow Report
As of January 31, 2024
City of Bell
Account #
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 07/15/2024 Interest 45950KDF4 80,000.00 International Finance Corp Note
4.375% Due 1/15/2027
0.00 1,750.00 1,750.00
07/15/2024 Maturity 79466LAG9 20,000.00 Salesforce.com Inc Callable Note Cont 7/15/2022
0.625% Due 7/15/2024
20,000.00 62.50 20,062.50
07/15/2024 Paydown 44935FAD6 15,933.18 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due 5/15/2026
1,327.66 5.73 1,333.39
07/15/2024 Paydown 47788UAC6 9,733.31 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
1,081.83 1.30 1,083.13
07/15/2024 Paydown 47800AAC4 45,000.00 John Deere Owner Trust 2022-B A3
3.74% Due 2/16/2027
1,846.97 117.34 1,964.31
07/15/2024 Paydown 43815BAC4 50,306.05 Honda Auto Receivables Trust 2022-1 A3
1.88% Due 5/15/2026
3,109.31 54.77 3,164.08
07/15/2024 Paydown 47787CAC7 105,000.00 John Deere Owner Trust 2023-C A3
5.48% Due 5/15/2028
0.00 479.50 479.50
07/15/2024 Paydown 47787JAC2 35,588.45 John Deere Owner Trust 2022-A A3
2.32% Due 9/16/2026
1,769.13 51.77 1,820.90
07/15/2024 Paydown 02582JKD1 115,000.00 American Express Credit Trust 2023-3 A
5.23% Due 9/15/2028
0.00 501.21 501.21
07/15/2024 Paydown 448979AD6 50,000.00 Hyundai Auto Receivables Trust 2023-A A3
4.58% Due 4/15/2027
0.00 190.83 190.83
07/15/2024 Paydown 47789QAC4 25,096.46 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
1,792.36 6.99 1,799.35
07/15/2024 Paydown 58770AAC7 35,000.00 Mercedes-Benz Auto Receivable 2023-1 A3
4.51% Due 11/15/2027
0.00 131.54 131.54
07/15/2024 Paydown 89238DAD0 60,000.00 Toyota Auto Receivables OT 2024-A A3
4.83% Due 10/16/2028
0.00 241.50 241.50
07/15/2024 Paydown 89239FAD4 45,000.00 Toyota Auto Receivables Owner 2023-D A3
5.54% Due 8/15/2028
0.00 207.75 207.75
07/16/2024 Paydown 380146AC4 19,609.31 GM Financial Auto Receivables 2022-1 A3
1.26% Due 11/16/2026
1,212.01 14.31 1,226.32
07/16/2024 Paydown 36265WAD5 30,000.00 GM Financial Securitized Auto 2022-3 A3
3.64% Due 4/16/2027
1,637.45 76.19 1,713.64
07/16/2024 Paydown 362554AC1 16,877.00 GM Financial Securitized Term 2021-4 A3
0.68% Due 9/16/2026
1,205.08 6.15 1,211.23
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 45
Cash Flow Report
As of January 31, 2024
City of Bell
Account #
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 07/16/2024 Paydown 362583AD8 40,000.00 GM Auto Receivable Trust 2023-2 A3
4.47% Due 2/16/2028
0.00 149.00 149.00
07/17/2024 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
07/18/2024 Paydown 43815PAC3 35,000.00 Honda Auto Receivables 2022-2 A3
3.73% Due 7/20/2026
1,839.88 85.93 1,925.81
07/19/2024 Interest 78016HZT0 105,000.00 ROYAL BANK OF CANADA Note
4.875% Due 1/19/2027
0.00 2,559.38 2,559.38
07/20/2024 Interest 06051GLE7 135,000.00 Bank of America Corp Callable Note 2X 1/20/2026
5.08% Due 1/20/2027
0.00 3,429.00 3,429.00
07/20/2024 Paydown 379929AD4 10,000.00 GM Financial Auto Leasing 2023-3 A3
5.38% Due 11/20/2026
0.00 44.83 44.83
07/20/2024 Paydown 36266FAC3 40,605.31 GM Financial Auto Lease Trust 2022-2 A3
3.42% Due 6/20/2025
6,771.64 19.30 6,790.94
07/21/2024 Paydown 438123AC5 35,000.00 Honda Auto Receivables OT 2023-4 A3
5.67% Due 6/21/2028
0.00 165.38 165.38
07/21/2024 Paydown 43815JAC7 25,000.00 Honda Auto Receivables Owner 2023-1 A3
5.04% Due 4/21/2027
0.00 105.00 105.00
07/21/2024 Paydown 43815GAC3 22,560.61 Honda Auto Receivables Trust 2021-4 A3
0.88% Due 1/21/2026
1,735.02 10.19 1,745.21
07/25/2024 Paydown 05593AAC3 15,000.00 BMW Vehicle Lease Trust 2023-1 A3
5.16% Due 11/25/2025
1,479.95 58.16 1,538.11
07/25/2024 Paydown 3137FETN0 160,000.00 FHLMC K073 A2
3.35% Due 1/25/2028
0.00 446.67 446.67
07/25/2024 Paydown 3137FJEH8 105,000.00 FHLMC K081 A2
3.9% Due 8/25/2028
0.00 341.25 341.25
07/25/2024 Paydown 3137H4BY5 110,000.00 FHLMC K746 A2
2.031% Due 9/25/2028
0.00 186.18 186.18
07/25/2024 Paydown 3137BNGT5 175,000.00 FHLMC K054 A2
2.745% Due 1/25/2026
0.00 400.31 400.31
07/25/2024 Paydown 3137FKZZ2 110,000.00 FHLMC K088 A2
3.69% Due 1/25/2029
0.00 338.25 338.25
JUL 2024 46,808.29 23,921.79 70,730.08
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 46
Cash Flow Report
As of January 31, 2024
City of Bell
Account #
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 08/01/2024 Interest 4581X0EM6 215,000.00 Inter-American Dev Bank Note
4.375% Due 2/1/2027
0.00 4,703.13 4,703.13
08/01/2024 Interest 459058KW2 115,000.00 Intl. Bank Recon & Development Note
4.625% Due 8/1/2028
0.00 2,659.38 2,659.38
08/01/2024 Paydown 3137FHPJ6 110,000.00 FHLMC Multifamily Structured K080 - A2
3.926% Due 7/25/2028
0.00 359.88 359.88
08/06/2024 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/2024 Interest 037833CJ7 150,000.00 Apple Inc Callable Note Cont 11/9/2026
3.35% Due 2/9/2027
0.00 2,512.50 2,512.50
08/09/2024 Maturity 69371RR40 50,000.00 Paccar Financial Corp Note
0.5% Due 8/9/2024
50,000.00 125.00 50,125.00
08/10/2024 Interest 69371RS56 80,000.00 Paccar Financial Corp Note
5.05% Due 8/10/2026
0.00 2,020.00 2,020.00
08/15/2024 Interest 438516CJ3 125,000.00 Honeywell Intl Callable Note Cont 01/15/2028
4.95% Due 2/15/2028
0.00 3,093.75 3,093.75
08/15/2024 Maturity 91282CCT6 250,000.00 US Treasury Note
0.375% Due 8/15/2024
250,000.00 468.75 250,468.75
08/15/2024 Paydown 02582JKD1 115,000.00 American Express Credit Trust 2023-3 A
5.23% Due 9/15/2028
0.00 501.21 501.21
08/15/2024 Paydown 44935FAD6 15,933.18 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due 5/15/2026
1,327.87 4.92 1,332.79
08/15/2024 Paydown 89238DAD0 60,000.00 Toyota Auto Receivables OT 2024-A A3
4.83% Due 10/16/2028
0.00 241.50 241.50
08/15/2024 Paydown 448979AD6 50,000.00 Hyundai Auto Receivables Trust 2023-A A3
4.58% Due 4/15/2027
0.00 190.83 190.83
08/15/2024 Paydown 47789QAC4 25,096.46 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
1,792.52 6.22 1,798.74
08/15/2024 Paydown 58770AAC7 35,000.00 Mercedes-Benz Auto Receivable 2023-1 A3
4.51% Due 11/15/2027
0.00 131.54 131.54
08/15/2024 Paydown 89239FAD4 45,000.00 Toyota Auto Receivables Owner 2023-D A3
5.54% Due 8/15/2028
0.00 207.75 207.75
08/15/2024 Paydown 47787CAC7 105,000.00 John Deere Owner Trust 2023-C A3
5.48% Due 5/15/2028
0.00 479.50 479.50
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 47
Cash Flow Report
As of January 31, 2024
City of Bell
Account #
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 08/15/2024 Paydown 47787JAC2 35,588.45 John Deere Owner Trust 2022-A A3
2.32% Due 9/16/2026
1,771.40 48.35 1,819.75
08/15/2024 Paydown 47788UAC6 9,733.31 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
1,082.19 0.97 1,083.16
08/15/2024 Paydown 47800AAC4 45,000.00 John Deere Owner Trust 2022-B A3
3.74% Due 2/16/2027
1,850.66 111.58 1,962.24
08/15/2024 Paydown 43815BAC4 50,306.05 Honda Auto Receivables Trust 2022-1 A3
1.88% Due 5/15/2026
3,122.94 49.90 3,172.84
08/16/2024 Paydown 36265WAD5 30,000.00 GM Financial Securitized Auto 2022-3 A3
3.64% Due 4/16/2027
1,642.67 71.23 1,713.90
08/16/2024 Paydown 362554AC1 16,877.00 GM Financial Securitized Term 2021-4 A3
0.68% Due 9/16/2026
1,205.36 5.47 1,210.83
08/16/2024 Paydown 362583AD8 40,000.00 GM Auto Receivable Trust 2023-2 A3
4.47% Due 2/16/2028
0.00 149.00 149.00
08/16/2024 Paydown 380146AC4 19,609.31 GM Financial Auto Receivables 2022-1 A3
1.26% Due 11/16/2026
1,217.32 13.04 1,230.36
08/18/2024 Paydown 43815PAC3 35,000.00 Honda Auto Receivables 2022-2 A3
3.73% Due 7/20/2026
1,840.32 80.21 1,920.53
08/20/2024 Paydown 379929AD4 10,000.00 GM Financial Auto Leasing 2023-3 A3
5.38% Due 11/20/2026
0.00 44.83 44.83
08/21/2024 Paydown 438123AC5 35,000.00 Honda Auto Receivables OT 2023-4 A3
5.67% Due 6/21/2028
0.00 165.38 165.38
08/21/2024 Paydown 43815GAC3 22,560.61 Honda Auto Receivables Trust 2021-4 A3
0.88% Due 1/21/2026
1,735.44 8.91 1,744.35
08/21/2024 Paydown 43815JAC7 25,000.00 Honda Auto Receivables Owner 2023-1 A3
5.04% Due 4/21/2027
0.00 105.00 105.00
08/25/2024 Paydown 05593AAC3 15,000.00 BMW Vehicle Lease Trust 2023-1 A3
5.16% Due 11/25/2025
1,485.62 51.80 1,537.42
08/25/2024 Paydown 3137FJEH8 105,000.00 FHLMC K081 A2
3.9% Due 8/25/2028
0.00 341.25 341.25
08/25/2024 Paydown 3137BNGT5 175,000.00 FHLMC K054 A2
2.745% Due 1/25/2026
0.00 400.31 400.31
08/25/2024 Paydown 3137FETN0 160,000.00 FHLMC K073 A2
3.35% Due 1/25/2028
0.00 446.67 446.67
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 48
Cash Flow Report
As of January 31, 2024
City of Bell
Account #
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 08/25/2024 Paydown 3137FKZZ2 110,000.00 FHLMC K088 A2
3.69% Due 1/25/2029
0.00 338.25 338.25
08/25/2024 Paydown 3137H4BY5 110,000.00 FHLMC K746 A2
2.031% Due 9/25/2028
0.00 186.18 186.18
AUG 2024 320,074.31 20,629.74 340,704.05
09/01/2024 Paydown 3137FHPJ6 110,000.00 FHLMC Multifamily Structured K080 - A2
3.926% Due 7/25/2028
0.00 359.88 359.88
09/09/2024 Interest 931142EW9 30,000.00 Wal-Mart Stores Note
3.9% Due 9/9/2025
0.00 585.00 585.00
09/10/2024 Interest 3130ATS57 275,000.00 FHLB Note
4.5% Due 3/10/2028
0.00 6,187.50 6,187.50
09/15/2024 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/2024 Paydown 43815BAC4 50,306.05 Honda Auto Receivables Trust 2022-1 A3
1.88% Due 5/15/2026
3,136.62 45.01 3,181.63
09/15/2024 Paydown 44935FAD6 15,933.18 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due 5/15/2026
1,328.09 4.10 1,332.19
09/15/2024 Paydown 47787CAC7 105,000.00 John Deere Owner Trust 2023-C A3
5.48% Due 5/15/2028
0.00 479.50 479.50
09/15/2024 Paydown 47788UAC6 9,733.31 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
1,082.53 0.65 1,083.18
09/15/2024 Paydown 47800AAC4 45,000.00 John Deere Owner Trust 2022-B A3
3.74% Due 2/16/2027
1,854.36 105.81 1,960.17
09/15/2024 Paydown 47787JAC2 35,588.45 John Deere Owner Trust 2022-A A3
2.32% Due 9/16/2026
1,773.68 44.92 1,818.60
09/15/2024 Paydown 47789QAC4 25,096.46 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
1,792.69 5.44 1,798.13
09/15/2024 Paydown 58770AAC7 35,000.00 Mercedes-Benz Auto Receivable 2023-1 A3
4.51% Due 11/15/2027
1,458.54 131.54 1,590.08
09/15/2024 Paydown 02582JKD1 115,000.00 American Express Credit Trust 2023-3 A
5.23% Due 9/15/2028
0.00 501.21 501.21
09/15/2024 Paydown 448979AD6 50,000.00 Hyundai Auto Receivables Trust 2023-A A3
4.58% Due 4/15/2027
2,850.26 190.83 3,041.09
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 49
Cash Flow Report
As of January 31, 2024
City of Bell
Account #
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 09/15/2024 Paydown 89238DAD0 60,000.00 Toyota Auto Receivables OT 2024-A A3
4.83% Due 10/16/2028
0.00 241.50 241.50
09/15/2024 Paydown 89239FAD4 45,000.00 Toyota Auto Receivables Owner 2023-D A3
5.54% Due 8/15/2028
0.00 207.75 207.75
09/16/2024 Paydown 380146AC4 19,609.31 GM Financial Auto Receivables 2022-1 A3
1.26% Due 11/16/2026
1,222.65 11.76 1,234.41
09/16/2024 Paydown 36265WAD5 30,000.00 GM Financial Securitized Auto 2022-3 A3
3.64% Due 4/16/2027
1,647.93 66.24 1,714.17
09/16/2024 Paydown 362583AD8 40,000.00 GM Auto Receivable Trust 2023-2 A3
4.47% Due 2/16/2028
0.00 149.00 149.00
09/16/2024 Paydown 362554AC1 16,877.00 GM Financial Securitized Term 2021-4 A3
0.68% Due 9/16/2026
1,205.64 4.79 1,210.43
09/17/2024 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/2024 Paydown 43815PAC3 35,000.00 Honda Auto Receivables 2022-2 A3
3.73% Due 7/20/2026
1,840.77 74.49 1,915.26
09/20/2024 Paydown 379929AD4 10,000.00 GM Financial Auto Leasing 2023-3 A3
5.38% Due 11/20/2026
0.00 44.83 44.83
09/21/2024 Paydown 438123AC5 35,000.00 Honda Auto Receivables OT 2023-4 A3
5.67% Due 6/21/2028
0.00 165.38 165.38
09/21/2024 Paydown 43815JAC7 25,000.00 Honda Auto Receivables Owner 2023-1 A3
5.04% Due 4/21/2027
0.00 105.00 105.00
09/21/2024 Paydown 43815GAC3 22,560.61 Honda Auto Receivables Trust 2021-4 A3
0.88% Due 1/21/2026
1,735.84 7.64 1,743.48
09/23/2024 Maturity 4581X0DZ8 170,000.00 Inter-American Dev Bank Note
0.5% Due 9/23/2024
170,000.00 425.00 170,425.00
09/25/2024 Paydown 05593AAC3 15,000.00 BMW Vehicle Lease Trust 2023-1 A3
5.16% Due 11/25/2025
1,491.32 45.41 1,536.73
09/25/2024 Paydown 3137FJEH8 105,000.00 FHLMC K081 A2
3.9% Due 8/25/2028
0.00 341.25 341.25
09/25/2024 Paydown 3137BNGT5 175,000.00 FHLMC K054 A2
2.745% Due 1/25/2026
0.00 400.31 400.31
09/25/2024 Paydown 3137FKZZ2 110,000.00 FHLMC K088 A2
3.69% Due 1/25/2029
0.00 338.25 338.25
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 50
Cash Flow Report
As of January 31, 2024
City of Bell
Account #
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 09/25/2024 Paydown 3137FETN0 160,000.00 FHLMC K073 A2
3.35% Due 1/25/2028
0.00 446.67 446.67
09/25/2024 Paydown 3137H4BY5 110,000.00 FHLMC K746 A2
2.031% Due 9/25/2028
0.00 186.18 186.18
09/30/2024 Interest 9128286L9 275,000.00 US Treasury Note
2.25% Due 3/31/2026
0.00 3,093.75 3,093.75
09/30/2024 Interest 912828YG9 200,000.00 US Treasury Note
1.625% Due 9/30/2026
0.00 1,625.00 1,625.00
09/30/2024 Interest 912828ZF0 125,000.00 US Treasury Note
0.5% Due 3/31/2025
0.00 312.50 312.50
09/30/2024 Interest 91282CEF4 200,000.00 US Treasury Note
2.5% Due 3/31/2027
0.00 2,500.00 2,500.00
09/30/2024 Interest 91282CFM8 260,000.00 US Treasury Note
4.125% Due 9/30/2027
0.00 5,362.50 5,362.50
09/30/2024 Interest 91282CGT2 240,000.00 US Treasury Note
3.625% Due 3/31/2028
0.00 4,350.00 4,350.00
SEP 2024 194,420.92 30,077.84 224,498.76
10/01/2024 Interest 13063D7D4 100,000.00 California State STE-GO
5.5% Due 10/1/2028
0.00 2,750.00 2,750.00
10/01/2024 Paydown 3137FHPJ6 110,000.00 FHLMC Multifamily Structured K080 - A2
3.926% Due 7/25/2028
0.00 359.88 359.88
10/15/2024 Paydown 47787JAC2 35,588.45 John Deere Owner Trust 2022-A A3
2.32% Due 9/16/2026
1,775.96 41.49 1,817.45
10/15/2024 Paydown 47789QAC4 25,096.46 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
1,792.85 4.66 1,797.51
10/15/2024 Paydown 58770AAC7 35,000.00 Mercedes-Benz Auto Receivable 2023-1 A3
4.51% Due 11/15/2027
1,464.13 126.06 1,590.19
10/15/2024 Paydown 43815BAC4 50,306.05 Honda Auto Receivables Trust 2022-1 A3
1.88% Due 5/15/2026
3,150.37 40.10 3,190.47
10/15/2024 Paydown 448979AD6 50,000.00 Hyundai Auto Receivables Trust 2023-A A3
4.58% Due 4/15/2027
2,861.40 179.95 3,041.35
10/15/2024 Paydown 47787CAC7 105,000.00 John Deere Owner Trust 2023-C A3
5.48% Due 5/15/2028
0.00 479.50 479.50
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 51
Cash Flow Report
As of January 31, 2024
City of Bell
Account #
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 10/15/2024 Paydown 47788UAC6 9,733.31 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
1,082.89 0.32 1,083.21
10/15/2024 Paydown 47800AAC4 45,000.00 John Deere Owner Trust 2022-B A3
3.74% Due 2/16/2027
1,858.06 100.04 1,958.10
10/15/2024 Paydown 89239FAD4 45,000.00 Toyota Auto Receivables Owner 2023-D A3
5.54% Due 8/15/2028
0.00 207.75 207.75
10/15/2024 Paydown 02582JKD1 115,000.00 American Express Credit Trust 2023-3 A
5.23% Due 9/15/2028
0.00 501.21 501.21
10/15/2024 Paydown 44935FAD6 15,933.18 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due 5/15/2026
1,328.32 3.28 1,331.60
10/15/2024 Paydown 89238DAD0 60,000.00 Toyota Auto Receivables OT 2024-A A3
4.83% Due 10/16/2028
0.00 241.50 241.50
10/16/2024 Maturity 45950KCR9 100,000.00 International Finance Corp Note
1.375% Due 10/16/2024
100,000.00 687.50 100,687.50
10/16/2024 Paydown 36265WAD5 30,000.00 GM Financial Securitized Auto 2022-3 A3
3.64% Due 4/16/2027
1,653.19 61.25 1,714.44
10/16/2024 Paydown 380146AC4 19,609.31 GM Financial Auto Receivables 2022-1 A3
1.26% Due 11/16/2026
1,228.02 10.47 1,238.49
10/16/2024 Paydown 362554AC1 16,877.00 GM Financial Securitized Term 2021-4 A3
0.68% Due 9/16/2026
1,205.92 4.10 1,210.02
10/16/2024 Paydown 362583AD8 40,000.00 GM Auto Receivable Trust 2023-2 A3
4.47% Due 2/16/2028
0.00 149.00 149.00
10/18/2024 Paydown 43815PAC3 35,000.00 Honda Auto Receivables 2022-2 A3
3.73% Due 7/20/2026
1,841.21 68.77 1,909.98
10/20/2024 Paydown 379929AD4 10,000.00 GM Financial Auto Leasing 2023-3 A3
5.38% Due 11/20/2026
0.00 44.83 44.83
10/21/2024 Paydown 438123AC5 35,000.00 Honda Auto Receivables OT 2023-4 A3
5.67% Due 6/21/2028
0.00 165.38 165.38
10/21/2024 Paydown 43815JAC7 25,000.00 Honda Auto Receivables Owner 2023-1 A3
5.04% Due 4/21/2027
1,270.96 105.00 1,375.96
10/21/2024 Paydown 43815GAC3 22,560.61 Honda Auto Receivables Trust 2021-4 A3
0.88% Due 1/21/2026
1,736.24 6.37 1,742.61
10/25/2024 Paydown 3137FETN0 160,000.00 FHLMC K073 A2
3.35% Due 1/25/2028
0.00 446.67 446.67
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 52
Cash Flow Report
As of January 31, 2024
City of Bell
Account #
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 10/25/2024 Paydown 3137H4BY5 110,000.00 FHLMC K746 A2
2.031% Due 9/25/2028
0.00 186.18 186.18
10/25/2024 Paydown 3137FJEH8 105,000.00 FHLMC K081 A2
3.9% Due 8/25/2028
0.00 341.25 341.25
10/25/2024 Paydown 3137FKZZ2 110,000.00 FHLMC K088 A2
3.69% Due 1/25/2029
0.00 338.25 338.25
10/25/2024 Paydown 05593AAC3 15,000.00 BMW Vehicle Lease Trust 2023-1 A3
5.16% Due 11/25/2025
1,497.04 39.00 1,536.04
10/25/2024 Paydown 3137BNGT5 175,000.00 FHLMC K054 A2
2.745% Due 1/25/2026
0.00 400.31 400.31
OCT 2024 125,746.56 8,090.07 133,836.63
11/01/2024 Maturity 78015K7C2 135,000.00 Royal Bank of Canada Note
2.25% Due 11/1/2024
135,000.00 1,518.75 136,518.75
11/01/2024 Paydown 3137FHPJ6 110,000.00 FHLMC Multifamily Structured K080 - A2
3.926% Due 7/25/2028
0.00 359.88 359.88
11/03/2024 Interest 00440EAV9 135,000.00 Chubb INA Holdings Inc Callable Note Cont 2/3/2026
3.35% Due 5/3/2026
0.00 2,261.25 2,261.25
11/07/2024 Interest 3135G06G3 225,000.00 FNMA Note
0.5% Due 11/7/2025
0.00 562.50 562.50
11/08/2024 Maturity 69371RR57 90,000.00 Paccar Financial Corp Note
0.9% Due 11/8/2024
90,000.00 405.00 90,405.00
11/10/2024 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/15/2024 Interest 912828R36 265,000.00 US Treasury Note
1.625% Due 5/15/2026
0.00 2,153.13 2,153.13
11/15/2024 Interest 912828X88 275,000.00 US Treasury Note
2.375% Due 5/15/2027
0.00 3,265.63 3,265.63
11/15/2024 Interest 912828U24 265,000.00 US Treasury Note 2% Due 11/15/2026
0.00 2,650.00 2,650.00
11/15/2024 Maturity 91282CDH1 225,000.00 US Treasury Note
0.75% Due 11/15/2024
225,000.00 843.75 225,843.75
11/15/2024 Paydown 43815BAC4 50,306.05 Honda Auto Receivables Trust 2022-1 A3
1.88% Due 5/15/2026
3,164.18 35.16 3,199.34
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 53
Cash Flow Report
As of January 31, 2024
City of Bell
Account #
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 11/15/2024 Paydown 47787CAC7 105,000.00 John Deere Owner Trust 2023-C A3
5.48% Due 5/15/2028
0.00 479.50 479.50
11/15/2024 Paydown 47800AAC4 45,000.00 John Deere Owner Trust 2022-B A3
3.74% Due 2/16/2027
1,861.78 94.24 1,956.02
11/15/2024 Paydown 89239FAD4 45,000.00 Toyota Auto Receivables Owner 2023-D A3
5.54% Due 8/15/2028
0.00 207.75 207.75
11/15/2024 Paydown 44935FAD6 15,933.18 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due 5/15/2026
1,328.54 2.46 1,331.00
11/15/2024 Paydown 47787JAC2 35,588.45 John Deere Owner Trust 2022-A A3
2.32% Due 9/16/2026
1,778.23 38.06 1,816.29
11/15/2024 Paydown 02582JKD1 115,000.00 American Express Credit Trust 2023-3 A
5.23% Due 9/15/2028
0.00 501.21 501.21
11/15/2024 Paydown 448979AD6 50,000.00 Hyundai Auto Receivables Trust 2023-A A3
4.58% Due 4/15/2027
2,872.59 169.03 3,041.62
11/15/2024 Paydown 47789QAC4 25,096.46 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
1,793.01 3.89 1,796.90
11/15/2024 Paydown 58770AAC7 35,000.00 Mercedes-Benz Auto Receivable 2023-1 A3
4.51% Due 11/15/2027
1,469.74 120.56 1,590.30
11/15/2024 Paydown 89238DAD0 60,000.00 Toyota Auto Receivables OT 2024-A A3
4.83% Due 10/16/2028
0.00 241.50 241.50
11/16/2024 Paydown 380146AC4 19,609.31 GM Financial Auto Receivables 2022-1 A3
1.26% Due 11/16/2026
1,233.39 9.19 1,242.58
11/16/2024 Paydown 36265WAD5 30,000.00 GM Financial Securitized Auto 2022-3 A3
3.64% Due 4/16/2027
1,658.48 56.23 1,714.71
11/16/2024 Paydown 362554AC1 16,877.00 GM Financial Securitized Term 2021-4 A3
0.68% Due 9/16/2026
1,206.20 3.42 1,209.62
11/16/2024 Paydown 362583AD8 40,000.00 GM Auto Receivable Trust 2023-2 A3
4.47% Due 2/16/2028
0.00 149.00 149.00
11/17/2024 Interest 3130AXU63 160,000.00 Federal Home Loan Banks Note
4.625% Due 11/17/2026
0.00 3,700.00 3,700.00
11/17/2024 Interest 58933YBH7 30,000.00 Merck & Co Callable Note Cont 4/17/2028
4.05% Due 5/17/2028
0.00 607.50 607.50
11/18/2024 Paydown 43815PAC3 35,000.00 Honda Auto Receivables 2022-2 A3
3.73% Due 7/20/2026
1,841.65 63.05 1,904.70
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 54
Cash Flow Report
As of January 31, 2024
City of Bell
Account #
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 11/20/2024 Paydown 379929AD4 10,000.00 GM Financial Auto Leasing 2023-3 A3
5.38% Due 11/20/2026
0.00 44.83 44.83
11/21/2024 Paydown 43815JAC7 25,000.00 Honda Auto Receivables Owner 2023-1 A3
5.04% Due 4/21/2027
1,275.84 99.66 1,375.50
11/21/2024 Paydown 43815GAC3 22,560.61 Honda Auto Receivables Trust 2021-4 A3
0.88% Due 1/21/2026
1,736.64 5.10 1,741.74
11/21/2024 Paydown 438123AC5 35,000.00 Honda Auto Receivables OT 2023-4 A3
5.67% Due 6/21/2028
0.00 165.38 165.38
11/25/2024 Paydown 3137FKZZ2 110,000.00 FHLMC K088 A2
3.69% Due 1/25/2029
0.00 338.25 338.25
11/25/2024 Paydown 05593AAC3 15,000.00 BMW Vehicle Lease Trust 2023-1 A3
5.16% Due 11/25/2025
1,502.78 32.56 1,535.34
11/25/2024 Paydown 3137FETN0 160,000.00 FHLMC K073 A2
3.35% Due 1/25/2028
0.00 446.67 446.67
11/25/2024 Paydown 3137FJEH8 105,000.00 FHLMC K081 A2
3.9% Due 8/25/2028
0.00 341.25 341.25
11/25/2024 Paydown 3137H4BY5 110,000.00 FHLMC K746 A2
2.031% Due 9/25/2028
0.00 186.18 186.18
11/25/2024 Paydown 3137BNGT5 175,000.00 FHLMC K054 A2
2.745% Due 1/25/2026
0.00 400.31 400.31
11/30/2024 Interest 912828ZT0 250,000.00 US Treasury Note
0.25% Due 5/31/2025
0.00 312.50 312.50
11/30/2024 Interest 91282CAZ4 175,000.00 US Treasury Note
0.375% Due 11/30/2025
0.00 328.13 328.13
NOV 2024 474,723.05 26,202.46 500,925.51
12/01/2024 Paydown 3137FHPJ6 110,000.00 FHLMC Multifamily Structured K080 - A2
3.926% Due 7/25/2028
0.00 359.88 359.88
12/11/2024 Interest 89115A2V3 55,000.00 Toronto-Dominion Bank Note
5.264% Due 12/11/2026
0.00 1,447.60 1,447.60
12/15/2024 Interest 63743HFE7 35,000.00 National Rural Utilities Note
3.45% Due 6/15/2025
0.00 603.75 603.75
12/15/2024 Interest 3133EPN50 110,000.00 FFCB Note
4.25% Due 12/15/2028
0.00 2,337.50 2,337.50
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 55
Cash Flow Report
As of January 31, 2024
City of Bell
Account #
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 12/15/2024 Interest 46647PDM5 60,000.00 JP Morgan Chase & Co Callable Note Cont 12/15/2024
5.546% Due 12/15/2025
0.00 1,663.80 1,663.80
12/15/2024 Paydown 47787CAC7 105,000.00 John Deere Owner Trust 2023-C A3
5.48% Due 5/15/2028
0.00 479.50 479.50
12/15/2024 Paydown 47787JAC2 35,588.45 John Deere Owner Trust 2022-A A3
2.32% Due 9/16/2026
1,780.52 34.62 1,815.14
12/15/2024 Paydown 47800AAC4 45,000.00 John Deere Owner Trust 2022-B A3
3.74% Due 2/16/2027
1,865.49 88.44 1,953.93
12/15/2024 Paydown 89238DAD0 60,000.00 Toyota Auto Receivables OT 2024-A A3
4.83% Due 10/16/2028
0.00 241.50 241.50
12/15/2024 Paydown 02582JKD1 115,000.00 American Express Credit Trust 2023-3 A
5.23% Due 9/15/2028
0.00 501.21 501.21
12/15/2024 Paydown 44935FAD6 15,933.18 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due 5/15/2026
1,328.76 1.64 1,330.40
12/15/2024 Paydown 43815BAC4 50,306.05 Honda Auto Receivables Trust 2022-1 A3
1.88% Due 5/15/2026
3,178.05 30.20 3,208.25
12/15/2024 Paydown 448979AD6 50,000.00 Hyundai Auto Receivables Trust 2023-A A3
4.58% Due 4/15/2027
2,883.82 158.07 3,041.89
12/15/2024 Paydown 47789QAC4 25,096.46 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
1,793.18 3.11 1,796.29
12/15/2024 Paydown 58770AAC7 35,000.00 Mercedes-Benz Auto Receivable 2023-1 A3
4.51% Due 11/15/2027
1,475.39 115.03 1,590.42
12/15/2024 Paydown 89239FAD4 45,000.00 Toyota Auto Receivables Owner 2023-D A3
5.54% Due 8/15/2028
0.00 207.75 207.75
12/16/2024 Paydown 36265WAD5 30,000.00 GM Financial Securitized Auto 2022-3 A3
3.64% Due 4/16/2027
1,663.78 51.20 1,714.98
12/16/2024 Paydown 380146AC4 19,609.31 GM Financial Auto Receivables 2022-1 A3
1.26% Due 11/16/2026
1,238.81 7.89 1,246.70
12/16/2024 Paydown 362554AC1 16,877.00 GM Financial Securitized Term 2021-4 A3
0.68% Due 9/16/2026
1,206.48 2.74 1,209.22
12/16/2024 Paydown 362583AD8 40,000.00 GM Auto Receivable Trust 2023-2 A3
4.47% Due 2/16/2028
1,831.04 149.00 1,980.04
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 56
Cash Flow Report
As of January 31, 2024
City of Bell
Account #
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 12/18/2024 Paydown 43815PAC3 35,000.00 Honda Auto Receivables 2022-2 A3
3.73% Due 7/20/2026
1,842.10 57.32 1,899.42
12/20/2024 Paydown 379929AD4 10,000.00 GM Financial Auto Leasing 2023-3 A3
5.38% Due 11/20/2026
0.00 44.83 44.83
12/21/2024 Paydown 43815GAC3 22,560.61 Honda Auto Receivables Trust 2021-4 A3
0.88% Due 1/21/2026
1,737.05 3.82 1,740.87
12/21/2024 Paydown 43815JAC7 25,000.00 Honda Auto Receivables Owner 2023-1 A3
5.04% Due 4/21/2027
1,280.73 94.30 1,375.03
12/21/2024 Paydown 438123AC5 35,000.00 Honda Auto Receivables OT 2023-4 A3
5.67% Due 6/21/2028
0.00 165.38 165.38
12/25/2024 Paydown 3137FJEH8 105,000.00 FHLMC K081 A2
3.9% Due 8/25/2028
0.00 341.25 341.25
12/25/2024 Paydown 3137FKZZ2 110,000.00 FHLMC K088 A2
3.69% Due 1/25/2029
0.00 338.25 338.25
12/25/2024 Paydown 05593AAC3 15,000.00 BMW Vehicle Lease Trust 2023-1 A3
5.16% Due 11/25/2025
1,508.54 26.10 1,534.64
12/25/2024 Paydown 3137BNGT5 175,000.00 FHLMC K054 A2
2.745% Due 1/25/2026
0.00 400.31 400.31
12/25/2024 Paydown 3137FETN0 160,000.00 FHLMC K073 A2
3.35% Due 1/25/2028
0.00 446.67 446.67
12/25/2024 Paydown 3137H4BY5 110,000.00 FHLMC K746 A2
2.031% Due 9/25/2028
0.00 186.18 186.18
12/31/2024 Interest 91282CGC9 100,000.00 US Treasury Note
3.875% Due 12/31/2027
0.00 1,937.50 1,937.50
DEC 2024 26,613.74 12,526.34 39,140.08
01/01/2025 Paydown 3137FHPJ6 110,000.00 FHLMC Multifamily Structured K080 - A2
3.926% Due 7/25/2028
0.00 359.88 359.88
01/06/2025 Maturity 3133ENKS8 80,000.00 FFCB Note
1.125% Due 1/6/2025
80,000.00 450.00 80,450.00
01/10/2025 Maturity 89236TKN4 130,000.00 Toyota Motor Credit Corp Note
4.8% Due 1/10/2025
130,000.00 3,120.00 133,120.00
01/12/2025 Interest 459058KT9 140,000.00 Intl. Bank Recon & Development Note
3.5% Due 7/12/2028
0.00 2,450.00 2,450.00
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 57
Cash Flow Report
As of January 31, 2024
City of Bell
Account #
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 01/15/2025 Interest 91282CEY3 260,000.00 US Treasury Note 3% Due 7/15/2025
0.00 3,900.00 3,900.00
01/15/2025 Interest 45950KDF4 80,000.00 International Finance Corp Note
4.375% Due 1/15/2027
0.00 1,750.00 1,750.00
01/15/2025 Paydown 47787CAC7 105,000.00 John Deere Owner Trust 2023-C A3
5.48% Due 5/15/2028
0.00 479.50 479.50
01/15/2025 Paydown 47800AAC4 45,000.00 John Deere Owner Trust 2022-B A3
3.74% Due 2/16/2027
1,869.22 82.63 1,951.85
01/15/2025 Paydown 89239FAD4 45,000.00 Toyota Auto Receivables Owner 2023-D A3
5.54% Due 8/15/2028
0.00 207.75 207.75
01/15/2025 Paydown 43815BAC4 50,306.05 Honda Auto Receivables Trust 2022-1 A3
1.88% Due 5/15/2026
3,191.98 25.22 3,217.20
01/15/2025 Paydown 02582JKD1 115,000.00 American Express Credit Trust 2023-3 A
5.23% Due 9/15/2028
0.00 501.21 501.21
01/15/2025 Paydown 44935FAD6 15,933.18 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due 5/15/2026
1,328.98 0.82 1,329.80
01/15/2025 Paydown 58770AAC7 35,000.00 Mercedes-Benz Auto Receivable 2023-1 A3
4.51% Due 11/15/2027
1,481.04 109.49 1,590.53
01/15/2025 Paydown 89238DAD0 60,000.00 Toyota Auto Receivables OT 2024-A A3
4.83% Due 10/16/2028
0.00 241.50 241.50
01/15/2025 Paydown 47787JAC2 35,588.45 John Deere Owner Trust 2022-A A3
2.32% Due 9/16/2026
1,782.80 31.18 1,813.98
01/15/2025 Paydown 448979AD6 50,000.00 Hyundai Auto Receivables Trust 2023-A A3
4.58% Due 4/15/2027
2,895.10 147.06 3,042.16
01/15/2025 Paydown 47789QAC4 25,096.46 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
1,793.35 2.33 1,795.68
01/16/2025 Paydown 380146AC4 19,609.31 GM Financial Auto Receivables 2022-1 A3
1.26% Due 11/16/2026
1,244.23 6.59 1,250.82
01/16/2025 Paydown 362554AC1 16,877.00 GM Financial Securitized Term 2021-4 A3
0.68% Due 9/16/2026
1,206.77 2.05 1,208.82
01/16/2025 Paydown 362583AD8 40,000.00 GM Auto Receivable Trust 2023-2 A3
4.47% Due 2/16/2028
1,838.23 142.18 1,980.41
01/16/2025 Paydown 36265WAD5 30,000.00 GM Financial Securitized Auto 2022-3 A3
3.64% Due 4/16/2027
1,669.10 46.15 1,715.25
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 58
Cash Flow Report
As of January 31, 2024
City of Bell
Account #
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 01/17/2025 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
01/18/2025 Paydown 43815PAC3 35,000.00 Honda Auto Receivables 2022-2 A3
3.73% Due 7/20/2026
1,842.54 51.60 1,894.14
01/19/2025 Interest 78016HZT0 105,000.00 ROYAL BANK OF CANADA Note
4.875% Due 1/19/2027
0.00 2,559.38 2,559.38
01/20/2025 Interest 06051GLE7 135,000.00 Bank of America Corp Callable Note 2X 1/20/2026
5.08% Due 1/20/2027
0.00 3,429.00 3,429.00
01/20/2025 Paydown 379929AD4 10,000.00 GM Financial Auto Leasing 2023-3 A3
5.38% Due 11/20/2026
0.00 44.83 44.83
01/21/2025 Paydown 43815GAC3 22,560.61 Honda Auto Receivables Trust 2021-4 A3
0.88% Due 1/21/2026
1,737.46 2.55 1,740.01
01/21/2025 Paydown 43815JAC7 25,000.00 Honda Auto Receivables Owner 2023-1 A3
5.04% Due 4/21/2027
1,285.64 88.92 1,374.56
01/21/2025 Paydown 438123AC5 35,000.00 Honda Auto Receivables OT 2023-4 A3
5.67% Due 6/21/2028
0.00 165.38 165.38
01/25/2025 Paydown 3137FKZZ2 110,000.00 FHLMC K088 A2
3.69% Due 1/25/2029
0.00 338.25 338.25
01/25/2025 Paydown 05593AAC3 15,000.00 BMW Vehicle Lease Trust 2023-1 A3
5.16% Due 11/25/2025
1,514.33 19.61 1,533.94
01/25/2025 Paydown 3137FETN0 160,000.00 FHLMC K073 A2
3.35% Due 1/25/2028
0.00 446.67 446.67
01/25/2025 Paydown 3137FJEH8 105,000.00 FHLMC K081 A2
3.9% Due 8/25/2028
0.00 341.25 341.25
01/25/2025 Paydown 3137H4BY5 110,000.00 FHLMC K746 A2
2.031% Due 9/25/2028
0.00 186.18 186.18
01/25/2025 Paydown 3137BNGT5 175,000.00 FHLMC K054 A2
2.745% Due 1/25/2026
13,176.72 400.31 13,577.03
JAN 2025 249,857.49 23,533.17 273,390.66
TOTAL 4,127,567.00 269,804.53 4,397,371.53
Execution Time: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 59
Important Disclosures
City of Bell
Account #
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: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 60
Benchmark Index & Disclosures
City of Bell
Account #
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: 2/3/2024 10:16:14 PMChandler Asset Management - CONFIDENTIAL Page 61