©2010 Wells Fargo Bank, N.A.
All rights reserved. Member FDIC.
Account number: January 1, 2025 - January 31, 2025 Page 2 of 2 Prior account number: 145998008
Daily ledger balance summary
Date Balance Date Balance Date Balance
12/31 1,421,983.13
01/02 1,749,497.13
01/07 1,889,157.89
01/09 1,878,927.89
01/13 1,875,890.09
01/15 1,878,890.09
01/22 1,878,862.41
Average daily ledger balance $1,843,746.16
Sheet Seq = 0019495
Sheet 00002 of 00002
Local Agency Investment Fund
P.O. Box 942809
Sacramento, CA 94209-0001
(916) 653-3001
February 12, 2025
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 2025 Statement
Tran Type Definitions
Effective
Date
Transaction
Date
Tran
Type Confirm
Number
Web
Confirm
Number Authorized Caller Amount
1/15/2025 1/14/2025 QRD 1766310 N/A SYSTEM 8,116.70
Account Summary
Total Deposit: 8,116.70 Beginning Balance: 697,894.12
Total Withdrawal: 0.00 Ending Balance: 706,010.82
MONTHLY ACCOUNT STATEMENT
City of Bell | Account # | As of January 31, 2025
CHANDLER ASSET MANAGEMENT | chandlerasset.com
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 at the end of the statement.
Chandler Team:
For questions about your account, please call (800) 317-4747, or contact [email protected]
Custodian:
US Bank
CONFIDENTIAL | 2
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
PORTFOLIO SUMMARY
Portfolio Characteristics
Sector Allocation
Performance Review
Account Summary
Maturity Distribution
Top Issuers
Credit Quality (S&P)
Total Rate of Return** 1M 3M YTD 1YR 2YRS 3YRS 5YRS 10YRS Since Inception (07/01/17)
City of Bell 0.48% 1.01% 0.48% 4.46% 4.50% 2.44% 1.79% -- 1.95% Benchmark Return 0.43% 0.96% 0.43% 4.14% 4.04% 1.87% 1.38% -- 1.65% Average Modified Duration 1.82
Average Coupon 3.36%
Average Purchase YTM 4.05%
Average Market YTM 4.36%
Average Quality* AA+
Average Final Maturity 2.16
Average Life 1.88
End Values as of
12/31/2024
End Values as of
01/31/2025
Market Value 11,341,366.86 11,392,829.09
Accrued Interest 80,428.83 82,601.29
Total Market Value 11,421,795.69 11,475,430.38
Income Earned 39,242.95 38,611.10
Cont/WD 0.00 0.00
Par 11,508,979.12 11,541,036.26
Book Value 11,407,867.80 11,443,165.18
Cost Value 11,342,042.46 11,376,119.50
Government of The United States 40.66%
FHLMC 9.65%
Federal Home Loan Banks 5.59%
Farm Credit System 3.97%
International Bank for Recon and Dev 2.21%
FNMA 1.92%
American Express Credit Master Trust 1.91%
Inter-American Development Bank 1.89%
**Periods over 1 year are annualized.
Benchmark: ICE BofA 1-3 Year US Treasury & Agency Index Secondary Benchmark:
*The credit quality is a weighted average calculation of the highest of S&P , Moody’s and Fitch
CONFIDENTIAL | 3
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
STATEMENT OF COMPLIANCE
Rules Name Limit Actual Compliance
Status Notes
AGENCY MORTGAGE SECURITIES (CMOS)
Max % (MV) 100.0 9.6 Compliant
Max Maturity (Years) 5.0 4.0 Compliant
ASSET BACKED SECURITIES
Max % (MV; Non Agency ABS & MBS) 20.0 8.9 Compliant
Max % Issuer (MV) 5.0 1.9 Compliant
Max Maturity (Years) 5.0 4.5 Compliant
Min Rating (AA- by 1) 0.0 0.0 Compliant
BANKERS' ACCEPTANCES
Max % (MV) 40.0 0.0 Compliant
Max % Issuer (MV) 5.0 0.0 Compliant
Max Maturity (Days) 180 0.0 Compliant
Min Rating (A-1 by 1 or A- by 1) 0.0 0.0 Compliant
CERTIFICATE OF DEPOSIT PLACEMENT SERVICE (CDARS)
Max % (MV) 30.0 0.0 Compliant
Max Maturity (Years) 5.0 0.0 Compliant
CERTIFICATES OF DEPOSIT
Max % (MV) 30.0 0.0 Compliant
Max % Issuer (MV) 5.0 0.0 Compliant
Max Maturity (Years) 5.0 0.0 Compliant
COMMERCIAL PAPER
Max % (MV) 25.0 0.0 Compliant
Max % Issuer (MV) 5.0 0.0 Compliant
Max Maturity (Days) 270 0.0 Compliant
Min Rating (A-1 by 1, A- by 1) 0.0 0.0 Compliant
CORPORATE MEDIUM TERM NOTES
Max % (MV) 30.0 23.3 Compliant
Max % Issuer (MV) 5.0 1.8 Compliant
Max Maturity (Years) 5 4 Compliant
Min Rating (A- by 1) 0.0 0.0 Compliant
FEDERAL AGENCIES
Max % (MV) 100.0 11.5 Compliant
Max % Issuer (MV) 25.0 5.6 Compliant
Max Maturity (Years) 5 3 Compliant
CONFIDENTIAL | 4
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
STATEMENT OF COMPLIANCE
Rules Name Limit Actual Compliance
Status Notes
LOCAL AGENCY INVESTMENT FUND (LAIF)
Max Concentration (MV) 75.0 0.0 Compliant
MONEY MARKET MUTUAL FUNDS
Max % (MV; Money Market Fund & Mutual Fund) 20.0 0.3 Compliant Max % Issuer (MV) 20.0 0.3 Compliant
Min Rating (AAA by 2) 0.0 0.0 Compliant
MORTGAGE-BACKED SECURITIES (NON-AGENCY)
Max % (MV) 20.0 0.0 Compliant
Max % Issuer (MV) 5.0 0.0 Compliant
Max Maturity (Years) 5.0 0.0 Compliant
Min Rating (AA- by 1) 0.0 0.0 Compliant
MUNICIPAL SECURITIES (ALL STATES)
Max % (MV) 30.0 0.9 Compliant
Max % Issuer (MV) 5.0 0.9 Compliant
Max Maturity (Years) 5.0 3.7 Compliant
Min Rating (A- by 1) 0.0 0.0 Compliant
MUTUAL FUNDS
Max % (MV; Money Market Fund & Mutual Fund) 20.0 0.3 Compliant Max % Issuer (MV) 10.0 0.3 Compliant
Max % Issuer (MV) 10.0 0.0 Compliant
NEGOTIABLE CERTIFICATES OF DEPOSIT (NCD)
Max % (MV) 30.0 0.0 Compliant
Max % Issuer (MV) 5.0 0.0 Compliant
Max Maturity (Years) 5 0.0 Compliant
Min Rating (A-1 by 1 or A- by 1 if > FDIC Limit) 0.0 0.0 Compliant
REPURCHASE AGREEMENTS
Max Maturity (Years) 1.0 0.0 Compliant
SUPRANATIONAL OBLIGATIONS
Max % (MV) 30.0 4.8 Compliant
Max % Issuer (MV) 10.0 2.2 Compliant
Max Maturity (Years) 5 3 Compliant
Min Rating (AA- by 1) 0.0 0.0 Compliant
U.S. TREASURIES
Max % (MV) 100.0 40.7 Compliant
CONFIDENTIAL | 5
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
STATEMENT OF COMPLIANCE
Rules Name Limit Actual Compliance
Status Notes
Max Maturity (Years) 5 4 Compliant
CONFIDENTIAL | 6
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
RECONCILIATION SUMMARY
Accrual Activity Summary
Fair Market Activity Summary
Month to Date Fiscal Year to Date
(07/01/2024)
Beginning Book Value 11,407,867.80 11,203,855.05
Maturities/Calls (350,000.00) (2,415,000.00)
Principal Paydowns (30,443.71) (158,429.28)
Purchases 867,674.21 5,358,580.37
Sales (457,610.56) (2,587,856.99)
Change in Cash, Payables, Receivables (46.77) (2,345.10) Amortization/Accretion 5,724.19 44,361.11
Realized Gain (Loss) 0.02 0.02
Ending Book Value 11,443,165.18 11,443,165.18
Month to Date Fiscal Year to Date
(07/01/2024)
Beginning Market Value 11,341,366.86 11,044,781.18
Maturities/Calls (350,000.00) (2,415,000.00)
Principal Paydowns (30,443.71) (158,429.28)
Purchases 867,674.21 5,358,580.37
Sales (457,610.56) (2,587,856.99)
Change in Cash, Payables, Receivables (46.77) (2,345.10) Amortization/Accretion 5,724.19 44,361.11
Change in Net Unrealized Gain (Loss) 16,164.85 108,737.79 Realized Gain (Loss) 0.02 0.02
Ending Market Value 11,392,829.09 11,392,829.09
Maturities / Calls
Month to Date (350,000.00)
Fiscal Year to Date (2,415,000.00)
Principal Paydowns
Month to Date (30,443.71)
Fiscal Year to Date (158,429.28)
Purchases
Month to Date 867,674.21
Fiscal Year to Date 5,358,580.37
Sales
Month to Date (457,610.56)
Fiscal Year to Date (2,587,856.99)
Interest Received
Month to Date 30,714.45
Fiscal Year to Date 218,871.32
Purchased / Sold Interest
Month to Date 0.00
Fiscal Year to Date (13,920.52)
CONFIDENTIAL | 7
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
HOLDINGS REPORT
Cusip Security Description Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody's/
S&P/
Fitch
Maturity
Duration
ABS
05593AAC3 BMWLT 2023-1 A3 5.16
11/25/2025 2,035.70 02/07/2023
5.43%
2,035.65
2,035.68
100.04
4.68%
2,036.55
1.75 0.02%
0.87 Aaa/AAA
NA
0.82 0.08
43815GAC3 HAROT 2021-4 A3 0.88
01/21/2026 4,225.77 11/16/2021
0.42%
4,224.88
4,225.64
99.37 4.91%
4,199.13
1.03 0.04%
(26.51)
Aaa/NA
AAA
0.97 0.16
47789QAC4 JDOT 2021-B A3 0.52
03/16/2026 4,247.71 07/13/2021
0.52%
4,247.34
4,247.66
99.66 3.58%
4,233.37
0.98 0.04%
(14.29)
Aaa/NA
AAA
1.12 0.11
43815BAC4 HAROT 2022-1 A3 1.88
05/15/2026 14,846.64 02/15/2022
0.28%
14,844.41
14,846.18
99.26 4.76%
14,736.23
12.41 0.13%
(109.94)
Aaa/AAA
NA
1.28 0.26
44935FAD6 HART 2021-C A3 0.74
05/15/2026 1,570.84 11/09/2021
0.75%
1,570.49
1,570.78
99.75 4.80%
1,566.87
0.52 0.01%
(3.91)
NA/AAA
AAA
1.28 0.06
43815PAC3 HAROT 2022-2 A3 3.73
07/20/2026 16,159.60 08/15/2022
3.87%
16,158.64
16,159.30
99.66 4.68%
16,104.51
21.77 0.14%
(54.79)
NA/AAA
AAA
1.47 0.37
47787JAC2 JDOT 2022 A3 0.36 09/15/2026 11,493.72 03/10/2022
2.34%
11,491.18
11,493.06
99.24 4.28%
11,406.62
11.85 0.10%
(86.44)
Aaa/NA
AAA
1.62 0.39
362554AC1 GMCAR 2021-4 A3 0.68
09/16/2026 4,355.55 10/13/2021
0.68%
4,355.44
4,355.53
99.22 4.37%
4,321.47
1.23 0.04%
(34.06)
Aaa/AAA
NA
1.62 0.21
380146AC4 GMCAR 2022-1 A3 1.26
11/16/2026 5,664.88 01/11/2022
1.24%
5,664.38
5,664.76
99.23 4.64%
5,621.18
2.97 0.05%
(43.57)
NA/AAA
AAA
1.79 0.23
379929AD4 GMALT 2023-3 A3 5.38
11/20/2026 10,000.00 08/08/2023
5.38%
9,998.80
9,999.34
100.43
4.61%
10,042.62
16.44 0.09%
43.28 NA/AAA
AAA
1.80 0.51
47800AAC4 JDOT 2022-B A3 3.74
02/16/2027 25,231.49 07/12/2022
3.77%
25,229.08
25,230.60
99.55 4.53%
25,118.72
41.94 0.22%
(111.88)
Aaa/NA
AAA
2.04 0.58
36269FAD8 GMALT 2024-1 A3 5.09
03/22/2027 65,000.00 02/08/2024
5.09%
64,991.88
64,994.41
100.57
4.55%
65,373.59
101.09
0.57%
379.19
NA/AAA
AAA
2.14 0.97
448979AD6 HART 2023-A A3 4.58
04/15/2027 43,324.91 04/04/2023
5.14%
43,320.68
43,322.59
100.01
4.61%
43,327.86
88.19 0.38%
5.27 NA/AAA
AAA
2.20 0.54
36265WAD5 GMCAR 2022-3 A3 3.64
04/16/2027 16,116.38 07/06/2022
3.93%
16,116.27
16,116.34
99.63 4.61%
16,056.18
24.44 0.14%
(60.16)
Aaa/NA
AAA
2.21 0.40
43815JAC7 HAROT 2023-1 A3 5.04
04/21/2027 22,004.23 02/16/2023
5.09%
22,000.14
22,002.05
100.32
4.55%
22,074.47
30.81 0.19%
72.42 Aaa/NA
AAA
2.22 0.58
38012QAD0 GMALT 2024-3 A3 4.21
10/20/2027 30,000.00 09/24/2024
4.61%
29,996.45
29,996.84
99.50 4.58%
29,851.48
38.59 0.26%
(145.36)
NA/AAA
AAA
2.72 1.47
58770AAC7 MBART 2023-1 A3 4.51
11/15/2027 26,438.89 01/18/2023
4.56%
26,435.72
26,437.11
99.98 4.59%
26,433.29
53.00 0.23%
(3.82)
NA/AAA
AAA
2.79 0.60
CONFIDENTIAL | 8
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
HOLDINGS REPORT
Cusip Security Description Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody's/
S&P/
Fitch
Maturity
Duration
58769GAD5 MBALT 2024-B A3 4.23
02/15/2028 45,000.00 09/17/2024
4.24%
44,992.43
44,993.22
99.61 4.52%
44,824.80
84.60 0.39%
(168.42)
NA/AAA
AAA
3.04 1.54
362583AD8 GMCAR 2023-2 A3 4.47
02/16/2028 40,000.00 04/04/2023
4.51%
39,998.90
39,999.31
99.97 4.55%
39,989.80
74.50 0.35%
(9.51)
Aaa/AAA
NA
3.04 0.69
47787CAC7 JDOT 2023-C A3 5.48
05/15/2028 105,000.00 09/12/2023
5.40%
104,992.79
104,994.92
101.08
4.77%
106,135.16
255.73
0.93%
1,140.24
Aaa/NA
AAA
3.29 1.39
438123AC5 HAROT 2023-4 A3 5.67
06/21/2028 35,000.00 11/01/2023
5.74%
34,993.84
34,995.49
101.48
4.51%
35,516.83
55.13 0.31%
521.35
Aaa/NA
AAA
3.39 1.18
89239FAD4 TAOT 2023-D A3 5.54
08/15/2028 45,000.00 11/07/2023
6.30%
44,995.15
44,996.39
101.42
4.54%
45,639.43
110.80
0.40%
643.04
NA/AAA
AAA
3.54 1.33
02582JKD1 AMXCA 2023-3 A 5.23
09/15/2028 115,000.00 09/12/2023
5.29%
114,994.86
114,996.27
101.26
4.46%
116,443.65
267.31
1.02%
1,447.38
NA/AAA
AAA
3.62 1.52
89238DAD0 TAOT 2024-A A3 4.83
10/16/2028 60,000.00 01/23/2024
4.89%
59,987.99
59,990.56
100.39
4.58%
60,234.11
128.80
0.53%
243.56
Aaa/AAA
NA
3.71 1.31
448973AD9 HART 2024-A A3 4.99
02/15/2029 45,000.00 03/11/2024
5.05%
44,990.08
44,991.84
100.75
4.59%
45,338.84
99.80 0.40%
347.00
NA/AAA
AAA
4.04 1.65
44934QAD3 HART 2024-B A3 4.84
03/15/2029 30,000.00 07/16/2024
4.90%
29,995.47
29,995.98
100.59
4.59%
30,176.48
64.53 0.26%
180.50
NA/AAA
AAA
4.12 1.97
02582JKH2 AMXCA 2024-1 A 5.23
04/16/2029 100,000.00 04/16/2024
5.30%
99,979.50
99,982.70
101.57
4.52%
101,573.87
232.44
0.89%
1,591.17
NA/AAA
AAA
4.21 2.03
448976AD2 HART 2024-C A3 4.41
05/15/2029 50,000.00 10/08/2024
4.46%
49,996.34
49,996.58
99.74 4.58%
49,868.90
98.00 0.44%
(127.68)
NA/AAA
AAA
4.28 2.10
38014AAD3 GMCAR 2024-4 A3 4.4
08/16/2029 35,000.00 10/08/2024
4.32%
34,993.26
34,993.67
99.74 4.58%
34,907.43
64.17 0.31%
(86.24)
Aaa/AAA
NA
4.54 1.87
Total ABS 1,007,716.32 4.83%
1,007,592.03
1,007,624.80
100.54
4.57%
1,013,153.45
1,984.83
8.89%
5,528.65
Aaa/AAA
AAA
3.23 1.30
AGENCY
3135G06G3 FEDERAL NATIONAL MORTGAGE
ASSOCIATION 0.5 11/07/2025 225,000.00 11/18/2020
0.52%
224,768.25
224,964.36
97.21 4.26%
218,727.92
262.50
1.92%
(6,236.43)
Aaa/AA+
AA+
0.77 0.74
3130B3A29 FEDERAL HOME LOAN BANKS 4.0
10/09/2026 200,000.00 10/21/2024
4.00%
199,998.00
199,998.28
99.81 4.11%
199,627.41
2,444.44
1.75%
(370.87)
Aaa/AA+
AA+
1.69 1.59
3130AXU63 FEDERAL HOME LOAN BANKS
4.625 11/17/2026 160,000.00 11/16/2023
4.69%
159,716.80
159,831.01
100.68
4.22%
161,082.64
1,521.11
1.41%
1,251.63
Aaa/AA+
AA+
1.79 1.69
3133ERDS7 FEDERAL FARM CREDIT BANKS
FUNDING CORP 4.75 05/06/2027 225,000.00 06/25/2024
4.55%
226,206.00
225,951.86
101.08
4.24%
227,427.41
2,523.44
2.00%
1,475.54
Aaa/AA+
AA+
2.26 2.10
CONFIDENTIAL | 9
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
HOLDINGS REPORT
Cusip Security Description Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody's/
S&P/
Fitch
Maturity
Duration
3133ERFJ5 FEDERAL FARM CREDIT BANKS
FUNDING CORP 4.5 05/20/2027 115,000.00 05/23/2024
4.79%
114,070.80
114,286.28
100.63
4.21%
115,719.02
1,020.63
1.02%
1,432.74
Aaa/AA+
AA+
2.30 2.14
3130ATS57 FEDERAL HOME LOAN BANKS 4.5
03/10/2028 275,000.00 03/21/2023
3.99%
281,206.75
278,874.52
100.60
4.29%
276,655.27
4,846.88
2.43%
(2,219.25)
Aaa/AA+
AA+
3.11 2.82
3133EPN50 FEDERAL FARM CREDIT BANKS
FUNDING CORP 4.25 12/15/2028 110,000.00 12/28/2023
3.89%
111,789.70
111,394.84
99.73 4.32%
109,706.55
597.36
0.96%
(1,688.29)
Aaa/AA+
AA+
3.87 3.51
Total Agency 1,310,000.00 3.66%
1,317,756.30
1,315,301.15
99.94 4.24%
1,308,946.22
13,216.35
11.49%
(6,354.93)
Aaa/AA+
AA+
2.18 2.02
AGENCY CMBS
3137BNGT5 FHMS K-054 A2 2.745
01/25/2026 165,437.39 02/15/2023
4.65%
157,094.44
162,770.84
98.36 4.45%
162,719.63
378.44
1.43%
(51.20)
Aaa/AA+
AAA
0.98 0.87
3137BVZ82 FHMS K-063 A2 3.43 01/25/2027 110,000.00 02/06/2024
4.48%
106,811.72
107,891.57
98.02 4.47%
107,820.94
314.42
0.95%
(70.63)
Aaa/AA+
AAA
1.98 1.74
3137FETN0 FHMS K-073 A2 3.35 01/25/2028 160,000.00 05/24/2023
4.27%
153,775.00
156,050.45
96.80 4.50%
154,874.72
446.67
1.36%
(1,175.73)
Aaa/AA+
AAA
2.98 2.68
3137FHPJ6 FHMS K-080 A2 3.926
07/25/2028 110,000.00 01/23/2024
4.45%
107,567.97
108,127.13
97.89 4.55%
107,681.22
359.88
0.95%
(445.90)
Aaa/AA+
AA+
3.48 3.17
3137FJEH8 FHMS K-081 A2 3.9 08/25/2028 105,000.00 09/15/2023
4.86%
100,553.91
101,804.92
97.73 4.56%
102,621.35
341.25
0.90%
816.43
Aaa/AA+
AAA
3.57 3.23
3137H4BY5 FHMS K-746 A2 2.031
09/25/2028 110,000.00 10/03/2023
5.30%
94,625.78
98,778.19
91.49 4.61%
100,637.35
186.18
0.88%
1,859.16
Aaa/AA+
AAA
3.65 3.39
3137FJXV6 FHMS K-083 A2 4.05 09/25/2028 100,000.00 03/13/2024
4.53%
97,941.41
98,346.05
98.13 4.57%
98,128.19
337.50
0.86%
(217.86)
Aaa/AA+
AAA
3.65 3.30
3137FJKE8 FHMS K-082 A2 3.92 09/25/2028 54,000.00 09/20/2024
3.81%
54,141.33
54,128.64
97.77 4.56%
52,796.66
176.40
0.46%
(1,331.98)
Aaa/AA+
AAA
3.65 3.26
3137FKZZ2 FHMS K-088 A2 3.69 01/25/2029 110,000.00 01/18/2024
4.43%
106,343.36
107,099.84
96.72 4.59%
106,388.01
338.25
0.93%
(711.83)
Aaa/AA+
AA+
3.99 3.55
3137H5YC5 FHMS K-748 A2 2.26 01/25/2029 115,000.00 04/11/2024
4.94%
102,174.81
104,343.39
91.62 4.62%
105,366.19
216.58
0.92%
1,022.79
Aaa/AA+
AAA
3.99 3.64
Total Agency
CMBS 1,139,437.39 4.60%
1,081,029.73
1,099,341.01
96.52 4.54%
1,099,034.27
3,095.56
9.65%
(306.75)
Aaa/AA+
AAA
3.04 2.74
CASH
CCYUSD Receivable 592.99 --
0.00%
592.99
592.99
1.00 0.00%
592.99
0.00 0.01%
0.00 Aaa/AAA
AAA
0.00 0.00
CONFIDENTIAL | 10
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
HOLDINGS REPORT
Cusip Security Description Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody's/
S&P/
Fitch
Maturity
Duration
Total Cash 592.99 0.00%
592.99
592.99
1.00 0.00%
592.99
0.00 0.01%
0.00 Aaa/AAA
AAA
0.00 0.00
CORPORATE
63743HFE7
NATIONAL RURAL UTILITIES
COOPERATIVE FINANCE CORP
3.45 06/15/2025
35,000.00 04/27/2022
3.46%
34,990.55
34,999.18
99.56 4.64%
34,847.38
154.29
0.31%
(151.80)
A2/A-
A
0.37 0.36
6174468C6 MORGAN STANLEY 4.0
07/23/2025 140,000.00 03/15/2024
5.31%
137,649.40
139,176.57
99.79 4.45%
139,706.06
124.44
1.23%
529.49
A1/A-
A+
0.47 0.46
931142EW9 WALMART INC 3.9 09/09/2025 30,000.00 09/06/2022
3.92%
29,979.00
29,996.45
99.72 4.37%
29,915.74
461.50
0.26%
(80.71)
Aa2/AA
AA
0.61 0.58
437076CR1 HOME DEPOT INC 4.0
09/15/2025 40,000.00 09/12/2022
4.01%
39,985.60
39,997.46
99.80 4.33%
39,918.03
604.44
0.35%
(79.43)
A2/A
A
0.62 0.59
20030NCS8 COMCAST CORP 3.95
10/15/2025 140,000.00 03/11/2024
4.94%
137,895.80
139,072.85
99.61 4.51%
139,459.12
1,628.28
1.22%
386.27
A3/A-
A-
0.70 0.68
857477BR3 STATE STREET CORP 1.746
02/06/2026 35,000.00 02/02/2022
1.75%
35,000.00
35,000.00
99.97 4.93%
34,990.60
297.06
0.31%
(9.40)
Aa3/A
AA-
1.02 0.01
00440EAV9 CHUBB INA HOLDINGS LLC 3.35
05/03/2026 135,000.00 08/24/2023
5.19%
128,866.95
132,143.34
98.61 4.51%
133,116.98
1,105.50
1.17%
973.64
A2/A
A
1.25 1.20
61747YET8 MORGAN STANLEY 4.679
07/17/2026 60,000.00 07/18/2022
4.68%
60,000.00
60,000.00
99.95 5.65%
59,972.67
109.18
0.53%
(27.33)
A1/A-
A+
1.46 0.45
69371RS56 PACCAR FINANCIAL CORP 5.05
08/10/2026 80,000.00 12/08/2023
4.96%
80,172.00
80,098.31
100.86
4.46%
80,689.54
1,919.00
0.71%
591.23
A1/A+
NA
1.52 1.42
931142ER0 WALMART INC 1.05 09/17/2026 25,000.00 09/08/2021
1.09%
24,952.75
24,984.65
95.03 4.25%
23,758.65
97.71 0.21%
(1,226.01)
Aa2/AA
AA
1.63 1.57
89115A2V3 TORONTO-DOMINION BANK
5.264 12/11/2026 55,000.00 12/04/2023
5.26%
55,000.00
55,000.00
101.10
4.64%
55,603.17
402.11
0.49%
603.17
A2/A-
AA-
1.86 1.74
78016HZT0 ROYAL BANK OF CANADA 4.875
01/19/2027 105,000.00 01/10/2024
4.88%
104,973.75
104,982.83
100.60
4.55%
105,626.11
170.63
0.93%
643.29
A1/A
AA-
1.97 1.85
06051GLE7 BANK OF AMERICA CORP 5.08
01/20/2027 135,000.00 08/22/2023
5.90%
132,557.85
134,020.36
100.30
5.22%
135,404.74
209.55
1.19%
1,384.37
A1/A-
AA-
1.97 0.93
037833CJ7 APPLE INC 3.35 02/09/2027 150,000.00 01/24/2023
4.09%
145,929.00
147,963.12
98.15 4.32%
147,228.99
2,400.83
1.29%
(734.13)
Aaa/AA+
NA
2.02 1.89
17275RBQ4 CISCO SYSTEMS INC 4.8
02/26/2027 60,000.00 02/21/2024
4.85%
59,922.00
59,946.27
100.76
4.41%
60,458.39
1,240.00
0.53%
512.13
A1/AA-
NA
2.07 1.83
CONFIDENTIAL | 11
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
HOLDINGS REPORT
Cusip Security Description Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody's/
S&P/
Fitch
Maturity
Duration
857477CL5 STATE STREET CORP 4.993
03/18/2027 125,000.00 03/13/2024
4.99%
125,000.00
125,000.00
100.90
4.54%
126,128.32
2,305.80
1.11%
1,128.32
Aa3/A
AA-
2.13 1.89
665859AW4 NORTHERN TRUST CORP 4.0
05/10/2027 150,000.00 09/28/2022
4.74%
145,396.50
147,735.17
98.85 4.54%
148,279.10
1,350.00
1.30%
543.92
A2/A+
A+
2.27 2.12
14913UAL4 CATERPILLAR FINANCIAL
SERVICES CORP 5.0 05/14/2027 140,000.00 05/21/2024
4.93%
140,257.04
140,196.92
101.15
4.46%
141,607.29
1,497.22
1.24%
1,410.37
A2/A
A+
2.28 2.12
63743HFT4
NATIONAL RURAL UTILITIES
COOPERATIVE FINANCE CORP
4.12 09/16/2027
140,000.00 11/18/2024
4.61%
138,184.20
138,314.53
98.84 4.59%
138,375.69
2,163.00
1.21%
61.16 A2/A-
A
2.62 2.42
24422EXZ7 JOHN DEERE CAPITAL CORP 4.65
01/07/2028 95,000.00 01/06/2025
4.66%
94,971.50
94,972.10
100.50
4.47%
95,474.57
269.96
0.84%
502.47
A1/A
A+
2.93 2.70
438516CJ3 HONEYWELL INTERNATIONAL
INC 4.95 02/15/2028 125,000.00 02/13/2023
4.44%
127,803.75
126,683.81
101.34
4.47%
126,669.46
2,853.13
1.11%
(14.36)
A2/A
A
3.04 2.66
79466LAF1 SALESFORCE INC 3.7 04/11/2028 140,000.00 08/21/2024
4.10%
138,121.20
138,351.81
97.58 4.52%
136,609.34
1,582.78
1.20%
(1,742.46)
A1/A+
NA
3.19 2.93
58933YBH7 MERCK & CO INC 4.05
05/17/2028 30,000.00 05/08/2023
4.07%
29,975.70
29,984.03
98.93 4.40%
29,679.69
249.75
0.26%
(304.33)
A1/A+
NA
3.29 3.02
46647PEU6 JPMORGAN CHASE & CO 4.915
01/24/2029 65,000.00 01/16/2025
4.92%
65,000.00
65,000.00
100.11
4.95%
65,071.00
62.12 0.57%
71.00 A1/A
AA-
3.98 2.73
09247XAP6 BLACKROCK FINANCE INC 3.25
04/30/2029 150,000.00 07/29/2024
4.58%
141,568.50
142,472.40
94.78 4.62%
142,164.02
1,232.29
1.25%
(308.37)
Aa3/AA-
NA
4.24 3.87
437076DC3 HOME DEPOT INC 4.75
06/25/2029 75,000.00 --
4.79%
74,851.75
74,871.40
100.29
4.67%
75,220.41
356.25
0.66%
349.01
A2/A
A
4.40 3.84
69371RT48 PACCAR FINANCIAL CORP 4.0
09/26/2029 70,000.00 09/23/2024
4.05%
69,855.80
69,865.91
97.08 4.71%
67,955.88
972.22
0.60%
(1,910.03)
A1/A+
NA
4.65 4.12
26444HAH4 DUKE ENERGY FLORIDA LLC 2.5
12/01/2029 150,000.00 12/16/2024
4.72%
135,454.50
135,824.16
90.25 4.79%
135,373.04
625.00
1.19%
(451.13)
A1/A
NA
4.83 4.43
Total Corporate 2,680,000.00 4.68%
2,634,315.09
2,646,653.63
98.93 4.60%
2,649,303.99
26,444.04
23.25%
2,650.35
A1/A
A+
2.39 2.09
MONEY MARKET
FUND
31846V203 FIRST AMER:GVT OBLG Y 38,289.56 --
4.02%
38,289.56
38,289.56
1.00 4.02%
38,289.56
0.00 0.34%
0.00 Aaa/
AAAm
AAA
0.00 0.00
CONFIDENTIAL | 12
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
HOLDINGS REPORT
Cusip Security Description Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody's/
S&P/
Fitch
Maturity
Duration
Total Money
Market Fund 38,289.56 4.02%
38,289.56
38,289.56
1.00 4.02%
38,289.56
0.00 0.34%
0.00 Aaa/
AAAm
AAA
0.00 0.00
MUNICIPAL
BONDS
13063D7D4 CALIFORNIA STATE 5.5
10/01/2028 100,000.00 10/04/2023
5.12%
101,634.00
101,203.24
103.14
4.56%
103,136.00
1,833.33
0.91%
1,932.76
Aa2/AA-
AA
3.67 3.24
Total Municipal
Bonds 100,000.00 5.12%
101,634.00
101,203.24
103.14
4.56%
103,136.00
1,833.33
0.91%
1,932.76
Aa2/AA-
AA
3.67 3.24
SUPRANATIONAL
45950KDF4 INTERNATIONAL FINANCE CORP
4.375 01/15/2027 80,000.00 11/29/2023
4.49%
79,739.20
79,836.31
100.13
4.30%
80,104.78
155.59
0.70%
268.47
Aaa/AAA
NA
1.96 1.85
4581X0EM6
INTER-AMERICAN
DEVELOPMENT BANK 4.375
02/01/2027
215,000.00 12/05/2023
4.41%
214,817.25
214,883.69
100.16
4.29%
215,341.26
4,703.13
1.89%
457.57
Aaa/AAA
NA
2.00 1.89
459058KT9
INTERNATIONAL BANK FOR
RECONSTRUCTION AND
DEVELOPM 3.5 07/12/2028
140,000.00 09/07/2023
4.54%
133,740.60
135,544.70
97.30 4.35%
136,222.40
258.61
1.20%
677.71
Aaa/AAA
NA
3.45 3.19
459058KW2
INTERNATIONAL BANK FOR
RECONSTRUCTION AND
DEVELOPM 4.625 08/01/2028
115,000.00
--
4.92%
113,575.80
113,961.32
100.89
4.35%
116,023.60
2,659.38
1.02%
2,062.28
Aaa/AAA
NA
3.50 3.20
Total
Supranational 550,000.00 4.56%
541,872.85
544,226.02
99.60 4.32%
547,692.04
7,776.70
4.81%
3,466.03
Aaa/AAA
NA
2.67 2.49
US TREASURY
912828J27 UNITED STATES TREASURY 2.0
02/15/2025 250,000.00 06/25/2024
5.29%
244,902.34
249,695.01
99.98 2.54%
249,954.47
2,309.78
2.19%
259.45
Aaa/AA+
AA+
0.04 0.03
912797NR4 UNITED STATES TREASURY
03/18/2025 150,000.00 01/21/2025
4.32%
149,030.63
149,206.88
99.50 4.31%
149,242.66
0.00 1.31%
35.78 P-1/A-1+
F1+
0.13 0.12
912828ZF0 UNITED STATES TREASURY 0.5
03/31/2025 125,000.00 03/25/2021
0.58%
124,609.38
124,984.51
99.43 4.24%
124,283.85
212.91
1.09%
(700.66)
Aaa/AA+
AA+
0.16 0.15
91282CEH0 UNITED STATES TREASURY 2.625
04/15/2025 150,000.00 07/29/2024
4.96%
147,580.08
149,317.94
99.67 4.31%
149,500.78
1,179.09
1.31%
182.84
Aaa/AA+
AA+
0.20 0.19
CONFIDENTIAL | 13
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
HOLDINGS REPORT
Cusip Security Description Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody's/
S&P/
Fitch
Maturity
Duration
912797KS5 UNITED STATES TREASURY
04/17/2025 150,000.00 01/21/2025
4.30%
148,513.92
148,688.75
99.15 4.28%
148,727.82
0.00 1.31%
39.07 P-1/A-1+
F1+
0.21 0.20
912828ZT0 UNITED STATES TREASURY 0.25
05/31/2025 250,000.00 02/25/2021
0.60%
246,337.89
249,719.75
98.69 4.38%
246,722.66
108.17
2.17%
(2,997.09)
Aaa/AA+
AA+
0.33 0.32
91282CEU1 UNITED STATES TREASURY 2.875
06/15/2025 150,000.00 08/21/2024
4.53%
148,037.11
149,114.39
99.47 4.35%
149,201.95
568.68
1.31%
87.57 Aaa/AA+
AA+
0.37 0.36
91282CEY3 UNITED STATES TREASURY 3.0
07/15/2025 260,000.00 06/23/2023
4.71%
251,417.97
258,123.40
99.42 4.31%
258,501.95
366.30
2.27%
378.56
Aaa/AA+
AA+
0.45 0.44
912828K74 UNITED STATES TREASURY 2.0
08/15/2025 150,000.00 11/18/2024
4.26%
147,363.28
148,088.62
98.79 4.33%
148,179.20
1,385.87
1.30%
90.58 Aaa/AA+
AA+
0.54 0.52
91282CFK2 UNITED STATES TREASURY 3.5
09/15/2025 150,000.00 12/30/2024
4.26%
149,208.98
149,307.09
99.51 4.32%
149,264.06
2,015.88
1.31%
(43.03)
Aaa/AA+
AA+
0.62 0.59
91282CAZ4 UNITED STATES TREASURY 0.375
11/30/2025 175,000.00 12/09/2020
0.41%
174,699.22
174,949.98
96.87 4.29%
169,521.68
113.58
1.49%
(5,428.30)
Aaa/AA+
AA+
0.83 0.80
9128286L9 UNITED STATES TREASURY 2.25
03/31/2026 275,000.00 --
3.11%
268,007.23
272,477.41
97.79 4.23%
268,909.18
2,107.83
2.36%
(3,568.23)
Aaa/AA+
AA+
1.16 1.11
912828R36 UNITED STATES TREASURY 1.625
05/15/2026 265,000.00 --
2.74%
256,468.75
261,551.62
96.78 4.24%
256,459.96
927.87
2.25%
(5,091.66)
Aaa/AA+
AA+
1.28 1.24
91282CHH7 UNITED STATES TREASURY 4.125
06/15/2026 100,000.00 10/21/2024
4.04%
100,125.00
100,103.79
99.88 4.21%
99,878.91
543.96
0.88%
(224.88)
Aaa/AA+
AA+
1.37 1.31
912828YG9 UNITED STATES TREASURY 1.625
09/30/2026 200,000.00 12/28/2021
1.24%
203,531.25
201,232.68
95.91 4.21%
191,828.12
1,107.14
1.68%
(9,404.56)
Aaa/AA+
AA+
1.66 1.60
912828U24 UNITED STATES TREASURY 2.0
11/15/2026 265,000.00 03/29/2022
2.55%
258,602.73
262,533.40
96.23 4.22%
255,010.74
1,141.99
2.24%
(7,522.66)
Aaa/AA+
AA+
1.79 1.71
91282CEF4 UNITED STATES TREASURY 2.5
03/31/2027 200,000.00 05/25/2022
4.27%
197,890.63
199,060.91
96.53 4.20%
193,054.69
1,703.30
1.69%
(6,006.22)
Aaa/AA+
AA+
2.16 2.05
912828X88 UNITED STATES TREASURY 2.375
05/15/2027 275,000.00 --
2.96%
267,540.04
271,554.55
96.02 4.23%
264,042.97
1,407.29
2.32%
(7,511.58)
Aaa/AA+
AA+
2.28 2.17
91282CFM8 UNITED STATES TREASURY 4.125
09/30/2027 260,000.00 10/26/2022
4.19%
259,278.91
259,610.79
99.77 4.22%
259,400.78
3,653.57
2.28%
(210.01)
Aaa/AA+
AA+
2.66 2.45
91282CGC9 UNITED STATES TREASURY 3.875
12/31/2027 300,000.00 --
4.18%
297,187.51
297,498.04
99.04 4.23%
297,117.19
1,027.62
2.61%
(380.85)
Aaa/AA+
AA+
2.91 2.71
91282CGT2 UNITED STATES TREASURY 3.625
03/31/2028 240,000.00 04/19/2023
3.73%
238,828.13
239,251.61
98.16 4.25%
235,593.75
2,963.74
2.07%
(3,657.86)
Aaa/AA+
AA+
3.16 2.91
91282CHK0 UNITED STATES TREASURY 4.0
06/30/2028 200,000.00 12/30/2024
4.29%
197,953.13
198,004.42
99.16 4.27%
198,328.12
707.18
1.74%
323.70
Aaa/AA+
AA+
3.41 3.14
CONFIDENTIAL | 14
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
HOLDINGS REPORT
Cusip Security Description Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody's/
S&P/
Fitch
Maturity
Duration
91282CLK5 UNITED STATES TREASURY 3.625
08/31/2029 175,000.00 09/25/2024
3.51%
175,922.85
175,857.23
97.12 4.33%
169,955.08
2,698.72
1.49%
(5,902.15)
Aaa/AA+
AA+
4.58 4.09
Total US Treasury 4,715,000.00 3.43%
4,653,036.96
4,689,932.77
98.27 4.17%
4,632,680.58
28,250.47
40.66%
(57,252.20)
Aaa/AA+
AA+
1.51 1.41
Total Portfolio 11,541,036.26 4.05%
11,376,119.50
11,443,165.18
98.42 4.36%
11,392,829.09
82,601.29
100.00%
(50,336.09)
Aa1/AA
AA+
2.16 1.82
Total Market
Value + Accrued 11,475,430.38
CONFIDENTIAL | 15
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
TRANSACTION LEDGER
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 01/03/2025 31846V203 639.76 FIRST AMER:GVT OBLG Y 1.000 4.09% (639.76) 0.00 (639.76) 0.00 Purchase 01/06/2025 31846V203 80,450.00 FIRST AMER:GVT OBLG Y 1.000 4.09% (80,450.00) 0.00 (80,450.00) 0.00 Purchase 01/09/2025 24422EXZ7 95,000.00 JOHN DEERE CAPITAL CORP 4.65 01/07/2028 99.970 4.66% (94,971.50) 0.00 (94,971.50) 0.00 Purchase 01/10/2025 31846V203 2,120.00 FIRST AMER:GVT OBLG Y 1.000 4.09% (2,120.00) 0.00 (2,120.00) 0.00 Purchase 01/10/2025 31846V203 130,000.00 FIRST AMER:GVT OBLG Y 1.000 4.09% (130,000.00) 0.00 (130,000.00) 0.00 Purchase 01/13/2025 31846V203 3,500.00 FIRST AMER:GVT OBLG Y 1.000 4.09% (3,500.00) 0.00 (3,500.00) 0.00 Purchase 01/13/2025 31846V203 140,000.00 FIRST AMER:GVT OBLG Y 1.000 4.09% (140,000.00) 0.00 (140,000.00) 0.00 Purchase 01/15/2025 31846V203 0.40 FIRST AMER:GVT OBLG Y 1.000 4.09% (0.40) 0.00 (0.40) 0.00 Purchase 01/15/2025 31846V203 23,202.51 FIRST AMER:GVT OBLG Y 1.000 4.09% (23,202.51) 0.00 (23,202.51) 0.00 Purchase 01/16/2025 31846V203 2,875.18 FIRST AMER:GVT OBLG Y 1.000 4.09% (2,875.18) 0.00 (2,875.18) 0.00 Purchase 01/16/2025 31846V203 1,170.76 FIRST AMER:GVT OBLG Y 1.000 4.09% (1,170.76) 0.00 (1,170.76) 0.00
Purchase 01/17/2025 31846V203 1,403.70 FIRST AMER:GVT OBLG Y 1.000 4.09% (1,403.70) 0.00 (1,403.70) 0.00 Purchase 01/21/2025 31846V203 2,835.09 FIRST AMER:GVT OBLG Y 1.000 4.09% (2,835.09) 0.00 (2,835.09) 0.00 Purchase 01/21/2025 31846V203 8,933.57 FIRST AMER:GVT OBLG Y 1.000 4.09% (8,933.57) 0.00 (8,933.57) 0.00 Purchase 01/22/2025 912797KS5 150,000.00 UNITED STATES TREASURY 04/17/2025 99.009 4.30% (148,513.92) 0.00 (148,513.92) 0.00 Purchase 01/22/2025 912797NR4 150,000.00 UNITED STATES TREASURY 03/18/2025 99.354 4.32% (149,030.63) 0.00 (149,030.63) 0.00 Purchase 01/23/2025 31846V203 2,800.00 FIRST AMER:GVT OBLG Y 1.000 4.09% (2,800.00) 0.00 (2,800.00) 0.00 Purchase 01/24/2025 46647PEU6 65,000.00 JPMORGAN CHASE & CO
4.915 01/24/2029 100.000 4.92% (65,000.00) 0.00 (65,000.00) 0.00 Purchase 01/27/2025 31846V203 2,280.68 FIRST AMER:GVT OBLG Y 1.000 4.09% (2,280.68) 0.00 (2,280.68) 0.00 Purchase 01/27/2025 31846V203 7,946.51 FIRST AMER:GVT OBLG Y 1.000 4.09% (7,946.51) 0.00 (7,946.51) 0.00 Total Purchase 870,158.16 (867,674.21) 0.00 (867,674.21) 0.00 TOTAL
ACQUISITIONS 870,158.16 (867,674.21) 0.00 (867,674.21) 0.00 OTHER
Maturity 01/06/2025 3133ENKS8 (80,000.00)
FEDERAL FARM CREDIT
BANKS FUNDING CORP
1.125 01/06/2025
100.000 1.13% 80,000.00 0.00 80,000.00 0.00
CONFIDENTIAL | 16
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
TRANSACTION LEDGER
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
Maturity 01/10/2025 89236TKN4 (130,000.00) TOYOTA MOTOR CREDIT CORP 4.8 01/10/2025 100.000 4.80% 130,000.00 0.00 130,000.00 0.00 Maturity 01/13/2025 02665WEA5 (140,000.00)
AMERICAN HONDA
FINANCE CORP 1.5
01/13/2025
100.000 1.50% 140,000.00 0.00 140,000.00 0.00
Total Maturity (350,000.00) 350,000.00 0.00 350,000.00 0.00 Sale 01/09/2025 31846V203 (94,971.50) FIRST AMER:GVT OBLG Y 1.000 4.09% 94,971.50 0.00 94,971.50 0.00 Sale 01/22/2025 31846V203 (297,544.55) FIRST AMER:GVT OBLG Y 1.000 4.09% 297,544.55 0.00 297,544.55 0.00 Sale 01/24/2025 31846V203 (65,094.51) FIRST AMER:GVT OBLG Y 1.000 4.09% 65,094.51 0.00 65,094.51 0.00 Total Sale (457,610.56) 457,610.56 0.00 457,610.56 0.00
TOTAL OTHER
TRANSACTIONS (807,610.56) 807,610.56 0.00 807,610.56 0.00 OTHER
Coupon 01/01/2025 3137FJKE8 0.00 FHMS K-082 A2 3.92
09/25/2028 3.80% 176.40 0.00 176.40 0.00
Coupon 01/01/2025 3137FETN0 0.00 FHMS K-073 A2 3.35
01/25/2028 4.22% 446.67 0.00 446.67 0.00
Coupon 01/01/2025 3137FKZZ2 0.00 FHMS K-088 A2 3.69
01/25/2029 4.40% 338.25 0.00 338.25 0.00
Coupon 01/01/2025 3137BNGT5 0.00 FHMS K-054 A2 2.745
01/25/2026 4.42% 390.53
0.00 390.53 0.00
Coupon 01/01/2025 3137FHPJ6 0.00 FHMS K-080 A2 3.926
07/25/2028 4.42% 359.88 0.00 359.88 0.00
Coupon 01/01/2025 3137BVZ82 0.00 FHMS K-063 A2 3.43
01/25/2027 4.43% 314.42 0.00 314.42 0.00
Coupon 01/01/2025 3137FJXV6 0.00 FHMS K-083 A2 4.05
09/25/2028 4.51% 337.50 0.00 337.50 0.00
Coupon 01/01/2025 3137FJEH8 0.00 FHMS K-081 A2 3.9
08/25/2028 4.81% 341.25 0.00 341.25 0.00
Coupon 01/01/2025 3137H5YC5 0.00 FHMS K-748 A2 2.26
01/25/2029 4.89% 216.58 0.00 216.58 0.00
Coupon 01/01/2025 3137H4BY5 0.00 FHMS K-746 A2 2.031
09/25/2028 5.17% 186.18 0.00 186.18 0.00
CONFIDENTIAL | 17
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
TRANSACTION LEDGER
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
Coupon 01/06/2025 3133ENKS8 0.00
FEDERAL FARM CREDIT
BANKS FUNDING CORP
1.125 01/06/2025
1.13% 450.00 0.00 450.00 0.00
Coupon 01/10/2025 89236TKN4 0.00 TOYOTA MOTOR CREDIT
CORP 4.8 01/10/2025 4.80% 3,120.00 0.00 3,120.00 0.00
Coupon 01/12/2025 459058KT9 0.00
INTERNATIONAL BANK
FOR RECONSTRUCTION
AND DEVELOPM 3.5
07/12/2028
4.54% 2,450.00 0.00 2,450.00 0.00
Coupon 01/13/2025 02665WEA5 0.00
AMERICAN HONDA
FINANCE CORP 1.5
01/13/2025
1.50% 1,050.00 0.00 1,050.00 0.00
Coupon 01/15/2025 47789QAC4 0.00 JDOT 2021-B A3 0.52
03/16/2026 0.53% 2.47 0.00 2.47 0.00
Coupon 01/15/2025 44935FAD6 0.00 HART 2021-C A3 0.74
05/15/2026 0.77% 1.61 0.00 1.61 0.00
Coupon 01/15/2025 43815BAC4 0.00 HAROT 2022-1 A3 1.88
05/15/2026 1.90% 27.18 0.00 27.18 0.00
Coupon 01/15/2025 47787JAC2 0.00 JDOT 2022 A3 0.36
09/15/2026 2.35% 25.47 0.00 25.47 0.00
Coupon 01/15/2025 47800AAC4 0.00 JDOT 2022-B A3 3.74
02/16/2027 3.78% 85.62 0.00 85.62 0.00
Coupon 01/15/2025 58769GAD5 0.00 MBALT 2024-B A3 4.23
02/15/2028 4.28% 158.63 0.00 158.63 0.00
Coupon 01/15/2025 448976AD2 0.00 HART 2024-C A3 4.41
05/15/2029 4.45% 183.75 0.00 183.75 0.00
Coupon 01/15/2025 45950KDF4 0.00 INTERNATIONAL FINANCE
CORP 4.375 01/15/2027 4.49% 1,750.40 0.00 1,750.40 0.00 Coupon 01/15/2025 58770AAC7 0.00 MBART 2023-1 A3 4.51
11/15/2027 4.56% 107.19 0.00 107.19 0.00
Coupon 01/15/2025 448979AD6 0.00 HART 2023-A A3 4.58
04/15/2027 4.63% 179.12 0.00 179.12 0.00
Coupon 01/15/2025 91282CEY3 0.00 UNITED STATES TREASURY
3.0 07/15/2025 4.71% 3,900.00 0.00 3,900.00 0.00
CONFIDENTIAL | 18
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
TRANSACTION LEDGER
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
Coupon 01/15/2025 89238DAD0 0.00 TAOT 2024-A A3 4.83
10/16/2028 4.89% 241.50 0.00 241.50 0.00
Coupon 01/15/2025 44934QAD3 0.00 HART 2024-B A3 4.84
03/15/2029 4.90% 121.00 0.00 121.00 0.00
Coupon 01/15/2025 448973AD9 0.00 HART 2024-A A3 4.99
02/15/2029 5.05% 187.12 0.00 187.12 0.00
Coupon 01/15/2025 02582JKD1 0.00 AMXCA 2023-3 A 5.23
09/15/2028 5.29% 501.21 0.00 501.21 0.00
Coupon 01/15/2025 02582JKH2 0.00 AMXCA 2024-1 A 5.23
04/16/2029 5.30% 435.83 0.00 435.83 0.00
Coupon 01/15/2025 47787CAC7 0.00 JDOT 2023-C A3 5.48
05/15/2028 5.55% 479.50 0.00 479.50 0.00
Coupon 01/15/2025 89239FAD4 0.00 TAOT 2023-D A3 5.54
08/15/2028 5.61% 207.75 0.00 207.75 0.00
Coupon 01/16/2025 362554AC1 0.00 GMCAR 2021-4 A3 0.68
09/16/2026 0.68% 2.97 0.00 2.97 0.00
Coupon 01/16/2025 380146AC4 0.00 GMCAR 2022-1 A3 1.26
11/16/2026 1.27% 7.07 0.00 7.07 0.00
Coupon 01/16/2025 36265WAD5 0.00 GMCAR 2022-3 A3 3.64
04/16/2027 3.67% 54.19 0.00 54.19 0.00
Coupon 01/16/2025 38014AAD3 0.00 GMCAR 2024-4 A3 4.4
08/16/2029 4.45% 128.33 0.00
128.33 0.00
Coupon 01/16/2025 362583AD8 0.00 GMCAR 2023-2 A3 4.47
02/16/2028 4.51% 149.00 0.00 149.00 0.00
Coupon 01/17/2025 61747YET8 0.00 MORGAN STANLEY 4.679
07/17/2026 4.68% 1,403.70 0.00 1,403.70 0.00
Coupon 01/18/2025 43815PAC3 0.00 HAROT 2022-2 A3 3.73
07/20/2026 3.76% 56.48 0.00 56.48 0.00
Coupon 01/19/2025 78016HZT0 0.00 ROYAL BANK OF CANADA
4.875 01/19/2027 4.88% 2,559.38 0.00 2,559.38 0.00
Coupon 01/20/2025 38012QAD0 0.00 GMALT 2024-3 A3 4.21
10/20/2027 4.25% 105.25 0.00 105.25 0.00
Coupon 01/20/2025 36269FAD8 0.00 GMALT 2024-1 A3 5.09
03/22/2027 5.15% 275.71 0.00 275.71 0.00
CONFIDENTIAL | 19
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
TRANSACTION LEDGER
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
Coupon 01/20/2025 379929AD4 0.00 GMALT 2023-3 A3 5.38
11/20/2026 5.45% 44.83 0.00 44.83 0.00
Coupon 01/20/2025 06051GLE7 0.00 BANK OF AMERICA CORP
5.08 01/20/2027 5.67% 3,429.00 0.00 3,429.00 0.00
Coupon 01/21/2025 43815GAC3 0.00 HAROT 2021-4 A3 0.88
01/21/2026 0.90% 4.03 0.00 4.03 0.00
Coupon 01/21/2025 43815JAC7 0.00 HAROT 2023-1 A3 5.04
04/21/2027 5.11% 99.79 0.00 99.79 0.00
Coupon 01/21/2025 438123AC5 0.00 HAROT 2023-4 A3 5.67
06/21/2028 5.75% 165.38 0.00 165.38 0.00
Coupon 01/23/2025 6174468C6 0.00 MORGAN STANLEY 4.0
07/23/2025 5.31% 2,800.00 0.00 2,800.00 0.00
Coupon 01/25/2025 05593AAC3 0.00 BMWLT 2023-1 A3 5.16
11/25/2025 5.22% 16.57 0.00 16.57 0.00
Total Coupon 0.00 30,074.69 0.00 30,074.69 0.00
Custody Fee 01/24/2025 CCYUSD (94.51) Cash 0.00% (94.51) 0.00 (94.51) 0.00 Total Custody
Fee (94.51) (94.51) 0.00 (94.51) 0.00
Dividend 01/31/2025 31846V203 0.00 FIRST AMER:GVT OBLG Y 4.07% 592.99 0.00 592.99 0.00 Total Dividend 0.00 592.99 0.00 592.99 0.00
Management
Fee 01/10/2025
CCYUSD (1,000.00) Cash 0.00% (1,000.00) 0.00 (1,000.00) 0.00 Total
Management
Fee (1,000.00) (1,000.00) 0.00 (1,000.00) 0.00
Principal
Paydown 01/01/2025 3137BNGT5 5,285.52 FHMS K-054 A2 2.745 01/25/2026 4.42% 5,285.52 -- 5,285.52 0.00
Principal
Paydown 01/15/2025 47789QAC4 1,455.22 JDOT 2021-B A3 0.52 03/16/2026 0.53% 1,455.22 -- 1,455.22 0.00
Principal
Paydown 01/15/2025 44935FAD6 1,041.51 HART 2021-C A3 0.74 05/15/2026 0.77% 1,041.51 -- 1,041.51 0.00
Principal
Paydown 01/15/2025 43815BAC4 2,501.24 HAROT 2022-1 A3 1.88 05/15/2026 1.90% 2,501.24 -- 2,501.24 (0.01)
CONFIDENTIAL | 20
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
TRANSACTION LEDGER
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
Principal
Paydown 01/15/2025 47787JAC2 1,680.58 JDOT 2022 A3 0.36 09/15/2026 2.35% 1,680.58 -- 1,680.58 0.00
Principal
Paydown 01/15/2025 47800AAC4 2,239.04 JDOT 2022-B A3 3.74 02/16/2027 3.78% 2,239.04 -- 2,239.04 (0.00)
Principal
Paydown 01/15/2025 58770AAC7 2,082.65 MBART 2023-1 A3 4.51 11/15/2027 4.56% 2,082.65 -- 2,082.65 0.00
Principal
Paydown 01/15/2025 448979AD6 3,607.32 HART 2023-A A3 4.58 04/15/2027 4.63% 3,607.32 -- 3,607.32 0.00
Principal
Paydown 01/16/2025 362554AC1 890.46 GMCAR 2021-4 A3 0.68 09/16/2026 0.68% 890.46 -- 890.46 (0.00)
Principal
Paydown 01/16/2025 380146AC4 1,064.14 GMCAR 2022-1 A3 1.26 11/16/2026 1.27% 1,064.14 -- 1,064.14 0.00
Principal
Paydown 01/16/2025 36265WAD5 1,749.78 GMCAR 2022-3 A3 3.64 04/16/2027 3.67% 1,749.78 -- 1,749.78 0.00
Principal
Paydown 01/18/2025 43815PAC3 2,009.57 HAROT 2022-2 A3 3.73 07/20/2026 3.76% 2,009.57 -- 2,009.57 0.00
Principal
Paydown 01/21/2025 43815GAC3 1,264.77 HAROT 2021-4 A3 0.88 01/21/2026 0.90% 1,264.77 -- 1,264.77 (0.00)
Principal
Paydown 01/21/2025 43815JAC7 1,754.47 HAROT 2023-1 A3 5.04 04/21/2027 5.11% 1,754.47 -- 1,754.47
(0.00)
Principal
Paydown 01/25/2025 05593AAC3 1,817.44 BMWLT 2023-1 A3 5.16 11/25/2025 5.22% 1,817.44 -- 1,817.44 0.00
Total Principal
Paydown 30,443.71 30,443.71 -- 30,443.71 0.02
TOTAL OTHER
TRANSACTIONS 29,349.20 60,016.88 0.00 60,016.88 0.02
CONFIDENTIAL | 21
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
INCOME EARNED
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
CASH & EQUIVALENTS
31846V203 FIRST AMER:GVT OBLG Y
38,289.56
85,741.96
410,158.16
(457,610.56)
38,289.56
0.00 639.76
0.00 639.76
0.00 0.00
0.00 639.76
639.76
912797KS5 UNITED STATES TREASURY
04/17/2025
01/21/2025
01/22/2025
150,000.00
0.00 148,513.92
0.00 148,688.75
0.00 0.00
0.00 0.00
174.83
0.00 174.83
174.83
174.83
912797NR4 UNITED STATES TREASURY
03/18/2025
01/21/2025
01/22/2025
150,000.00
0.00 149,030.63
0.00 149,206.88
0.00 0.00
0.00 0.00
176.25
0.00 176.25
176.25
176.25
CCYUSD Receivable
592.99
639.76
0.00 0.00
592.99
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 Total Cash & Equivalents 338,882.55
86,381.72
707,702.71
(457,610.56)
336,778.18
0.00 639.76
0.00 639.76
351.08
0.00 351.08
990.84 990.84
FIXED INCOME
00440EAV9 CHUBB INA HOLDINGS LLC
3.35 05/03/2026
08/24/2023
08/28/2023
135,000.00
131,949.14
0.00 0.00
132,143.34
728.63
0.00 1,105.50
376.88
194.20
0.00 194.20
571.08
571.08
02582JKD1 AMXCA 2023-3 A 5.23
09/15/2028
09/12/2023
09/19/2023
115,000.00
114,996.19
0.00 0.00
114,996.27
267.31
501.21
267.31
501.21
0.09 0.00
0.09 501.30
501.30
02582JKH2 AMXCA 2024-1 A 5.23
04/16/2029
04/16/2024
04/23/2024
100,000.00
99,982.35
0.00 0.00
99,982.70
232.44
435.83
232.44
435.83
0.35 0.00
0.35 436.18
436.18
CONFIDENTIAL | 22
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
INCOME EARNED
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
02665WEA5 AMERICAN HONDA FINANCE
CORP 1.5 01/13/2025
04/18/2024
04/22/2024
0.00 139,821.14
0.00 (140,000.00)
0.00 980.00
1,050.00
0.00 70.00
178.86
0.00 178.86
248.86
248.86
037833CJ7 APPLE INC 3.35 02/09/2027
01/24/2023
01/26/2023
150,000.00
147,877.56
0.00 0.00
147,963.12
1,982.08
0.00 2,400.83
418.75
85.56 0.00
85.56 504.31
504.31
05593AAC3 BMWLT 2023-1 A3 5.16
11/25/2025
02/07/2023
02/15/2023
2,035.70
3,853.10
0.00 (1,817.44)
2,035.68
3.31 16.57
1.75 15.01
0.02 0.00
0.02 15.02
15.02 06051GLE7 BANK OF AMERICA CORP
5.08 01/20/2027
08/22/2023
08/24/2023
135,000.00
133,934.33
0.00 0.00
134,020.36
3,067.05
3,429.00
209.55
571.50
86.03 0.00
86.03 657.53
657.53
09247XAP6 BLACKROCK FINANCE INC
3.25 04/30/2029
07/29/2024
07/30/2024
150,000.00
142,321.75
0.00 0.00
142,472.40
826.04
0.00 1,232.29
406.25
150.65
0.00 150.65
556.90
556.90
13063D7D4 CALIFORNIA STATE 5.5
10/01/2028
10/04/2023
10/11/2023
100,000.00
101,231.12
0.00 0.00
101,203.24
1,375.00
0.00 1,833.33
458.33
0.00 (27.88)
(27.88)
430.46
430.46
14913UAL4
CATERPILLAR FINANCIAL
SERVICES CORP 5.0
05/14/2027
05/21/2024
05/23/2024
140,000.00
140,204.26
0.00 0.00
140,196.92
913.89
0.00 1,497.22
583.33
0.00 (7.34)
(7.34)
576.00
576.00
17275RBQ4 CISCO SYSTEMS INC 4.8
02/26/2027
02/21/2024
02/26/2024
60,000.00
59,944.06
0.00 0.00
59,946.27
1,000.00
0.00 1,240.00
240.00
2.21 0.00
2.21 242.21
242.21
20030NCS8 COMCAST CORP 3.95
10/15/2025
03/11/2024
03/13/2024
140,000.00
138,960.58
0.00 0.00
139,072.85
1,167.44
0.00 1,628.28
460.83
112.27
0.00 112.27
573.11
573.11
CONFIDENTIAL | 23
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
INCOME EARNED
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
24422EXZ7 JOHN DEERE CAPITAL CORP
4.65 01/07/2028
01/06/2025
01/09/2025
95,000.00
0.00 94,971.50
0.00 94,972.10
0.00 0.00
269.96
269.96
0.60 0.00
0.60 270.56
270.56
26444HAH4 DUKE ENERGY FLORIDA LLC
2.5 12/01/2029
12/16/2024
12/17/2024
150,000.00
135,575.04
0.00 0.00
135,824.16
312.50
0.00 625.00
312.50
249.12
0.00 249.12
561.62
561.62
3130ATS57 FEDERAL HOME LOAN BANKS
4.5 03/10/2028
03/21/2023
03/22/2023
275,000.00
278,980.53
0.00 0.00
278,874.52
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
4.625 11/17/2026
11/16/2023
11/17/2023
160,000.00
159,823.00
0.00 0.00
159,831.01
904.44
0.00 1,521.11
616.67
8.01 0.00
8.01 624.68
624.68
3130B3A29 FEDERAL HOME LOAN BANKS
4.0 10/09/2026
10/21/2024
10/22/2024
200,000.00
199,998.20
0.00 0.00
199,998.28
1,777.78
0.00 2,444.44
666.67
0.09 0.00
0.09 666.75
666.75
3133ENKS8
FEDERAL FARM CREDIT
BANKS FUNDING CORP 1.125
01/06/2025
01/06/2022
01/11/2022
0.00 79,999.18
0.00 (80,000.00)
0.00 437.50
450.00
0.00 12.50
0.83 0.00
0.83 13.33
13.33 3133EPN50
FEDERAL FARM CREDIT
BANKS FUNDING CORP 4.25
12/15/2028
12/28/2023
12/29/2023
110,000.00
111,425.44
0.00 0.00
111,394.84
207.78
0.00 597.36
389.58
0.00 (30.60)
(30.60)
358.98
358.98
3133ERDS7
FEDERAL FARM CREDIT
BANKS FUNDING CORP 4.75
05/06/2027
06/25/2024
06/26/2024
225,000.00
225,987.67
0.00 0.00
225,951.86
1,632.81
0.00 2,523.44
890.63
0.00 (35.81)
(35.81)
854.81
854.81
3133ERFJ5
FEDERAL FARM CREDIT
BANKS FUNDING CORP 4.5
05/20/2027
05/23/2024
05/24/2024
115,000.00
114,259.88
0.00 0.00
114,286.28
589.38
0.00 1,020.63
431.25
26.40 0.00
26.40 457.65
457.65
CONFIDENTIAL | 24
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
INCOME EARNED
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
3135G06G3
FEDERAL NATIONAL
MORTGAGE ASSOCIATION 0.5
11/07/2025
11/18/2020
11/19/2020
225,000.00
224,960.39
0.00 0.00
224,964.36
168.75
0.00 262.50
93.75 3.96
0.00 3.96
97.71 97.71
3137BNGT5 FHMS K-054 A2 2.745
01/25/2026
02/15/2023
02/21/2023
165,437.39
167,715.76
0.00 (5,285.52)
162,770.84
390.53
390.53
378.44
378.44
340.59
0.00 340.59
719.03
719.03
3137BVZ82 FHMS K-063 A2 3.43
01/25/2027
02/06/2024
02/09/2024
110,000.00
107,798.07
0.00 0.00
107,891.57
314.42
314.42
314.42
314.42
93.51 0.00
93.51 407.93
407.93
3137FETN0 FHMS K-073 A2 3.35
01/25/2028
05/24/2023
05/30/2023
160,000.00
155,935.38
0.00 0.00
156,050.45
446.67
446.67
446.67
446.67
115.07
0.00 115.07
561.74
561.74
3137FHPJ6 FHMS K-080 A2 3.926
07/25/2028
01/23/2024
01/26/2024
110,000.00
108,080.53
0.00 0.00
108,127.13
359.88
359.88
359.88
359.88
46.60 0.00
46.60 406.48
406.48
3137FJEH8 FHMS K-081 A2 3.9
08/25/2028
09/15/2023
09/20/2023
105,000.00
101,727.36
0.00 0.00
101,804.92
341.25
341.25
341.25
341.25
77.56 0.00
77.56 418.81
418.81
3137FJKE8
FHMS K-082 A2 3.92
09/25/2028
09/20/2024
09/25/2024
54,000.00
54,131.69
0.00 0.00
54,128.64
176.40
176.40
176.40
176.40
0.00 (3.05)
(3.05)
173.35
173.35
3137FJXV6 FHMS K-083 A2 4.05
09/25/2028
03/13/2024
03/18/2024
100,000.00
98,306.85
0.00 0.00
98,346.05
337.50
337.50
337.50
337.50
39.20 0.00
39.20 376.70
376.70
3137FKZZ2 FHMS K-088 A2 3.69
01/25/2029
01/18/2024
01/25/2024
110,000.00
107,036.97
0.00 0.00
107,099.84
338.25
338.25
338.25
338.25
62.87 0.00
62.87 401.12
401.12
CONFIDENTIAL | 25
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
INCOME EARNED
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
3137H4BY5 FHMS K-746 A2 2.031
09/25/2028
10/03/2023
10/06/2023
110,000.00
98,512.23
0.00 0.00
98,778.19
186.18
186.18
186.18
186.18
265.96
0.00 265.96
452.14
452.14
3137H5YC5 FHMS K-748 A2 2.26
01/25/2029
04/11/2024
04/16/2024
115,000.00
104,112.38
0.00 0.00
104,343.39
216.58
216.58
216.58
216.58
231.02
0.00 231.02
447.60
447.60
362554AC1 GMCAR 2021-4 A3 0.68
09/16/2026
10/13/2021
10/21/2021
4,355.55
5,245.99
0.00 (890.46)
4,355.53
1.49 2.97
1.23 2.72
0.01 0.00
0.01 2.72
2.72 362583AD8 GMCAR 2023-2 A3 4.47
02/16/2028
04/04/2023
04/12/2023
40,000.00
39,999.29
0.00 0.00
39,999.31
74.50 149.00
74.50 149.00
0.02 0.00
0.02 149.02
149.02
36265WAD5 GMCAR 2022-3 A3 3.64
04/16/2027
07/06/2022
07/13/2022
16,116.38
17,866.11
0.00 (1,749.78)
16,116.34
27.10 54.19
24.44 51.54
0.01 0.00
0.01 51.54
51.54 36269FAD8 GMALT 2024-1 A3 5.09
03/22/2027
02/08/2024
02/15/2024
65,000.00
64,994.19
0.00 0.00
64,994.41
101.09
275.71
101.09
275.71
0.22 0.00
0.22 275.93
275.93
379929AD4 GMALT 2023-3 A3 5.38
11/20/2026
08/08/2023
08/16/2023
10,000.00
9,999.31
0.00 0.00
9,999.34
16.44 44.83
16.44 44.83
0.03 0.00
0.03 44.86
44.86 38012QAD0 GMALT 2024-3 A3 4.21
10/20/2027
09/24/2024
10/02/2024
30,000.00
29,996.74
0.00 0.00
29,996.84
38.59 105.25
38.59 105.25
0.10 0.00
0.10 105.35
105.35
380146AC4 GMCAR 2022-1 A3 1.26
11/16/2026
01/11/2022
01/19/2022
5,664.88
6,728.86
0.00 (1,064.14)
5,664.76
3.53 7.07
2.97 6.51
0.03 0.00
0.03 6.54
6.54
CONFIDENTIAL | 26
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
INCOME EARNED
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
38014AAD3 GMCAR 2024-4 A3 4.4
08/16/2029
10/08/2024
10/16/2024
35,000.00
34,993.55
0.00 0.00
34,993.67
64.17 128.33
64.17 128.33
0.12 0.00
0.12 128.45
128.45
437076CR1 HOME DEPOT INC 4.0
09/15/2025
09/12/2022
09/19/2022
40,000.00
39,997.12
0.00 0.00
39,997.46
471.11
0.00 604.44
133.33
0.35 0.00
0.35 133.68
133.68
437076DC3 HOME DEPOT INC 4.75
06/25/2029 75,000.00
74,868.97
0.00 0.00
74,871.40
59.38 0.00
356.25
296.88
5.48 (3.05)
2.42 299.30
299.30
438123AC5 HAROT 2023-4 A3 5.67
06/21/2028
11/01/2023
11/08/2023
35,000.00
34,995.37
0.00 0.00
34,995.49
55.13 165.38
55.13 165.38
0.11 0.00
0.11 165.49
165.49
43815BAC4 HAROT 2022-1 A3 1.88
05/15/2026
02/15/2022
02/23/2022
14,846.64
17,347.31
0.00 (2,501.25)
14,846.18
14.50 27.18
12.41 25.09
0.11 0.00
0.11 25.20
25.20 43815GAC3 HAROT 2021-4 A3 0.88
01/21/2026
11/16/2021
11/24/2021
4,225.77
5,490.36
0.00 (1,264.77)
4,225.64
1.34 4.03
1.03 3.72
0.05 0.00
0.05 3.77
3.77 43815JAC7 HAROT 2023-1 A3 5.04
04/21/2027
02/16/2023
02/24/2023
22,004.23
23,756.26
0.00 (1,754.47)
22,002.05
33.26 99.79
30.81 97.33
0.26 0.00
0.26 97.60
97.60 43815PAC3 HAROT 2022-2 A3 3.73
07/20/2026
08/15/2022
08/24/2022
16,159.60
18,168.81
0.00 (2,009.57)
16,159.30
24.47 56.48
21.77 53.77
0.06 0.00
0.06 53.83
53.83 438516CJ3 HONEYWELL INTERNATIONAL
INC 4.95 02/15/2028
02/13/2023
02/15/2023
125,000.00
126,732.23
0.00 0.00
126,683.81
2,337.50
0.00 2,853.13
515.63
0.00 (48.42)
(48.42)
467.20
467.20
CONFIDENTIAL | 27
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
INCOME EARNED
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
448973AD9 HART 2024-A A3 4.99
02/15/2029
03/11/2024
03/20/2024
45,000.00
44,991.67
0.00 0.00
44,991.84
99.80 187.12
99.80 187.12
0.17 0.00
0.17 187.29
187.29
448976AD2 HART 2024-C A3 4.41
05/15/2029
10/08/2024
10/16/2024
50,000.00
49,996.51
0.00 0.00
49,996.58
98.00 183.75
98.00 183.75
0.07 0.00
0.07 183.82
183.82
448979AD6 HART 2023-A A3 4.58
04/15/2027
04/04/2023
04/12/2023
43,324.91
46,929.62
0.00 (3,607.32)
43,322.59
95.53 179.12
88.19 171.78
0.29 0.00
0.29 172.07
172.07
44934QAD3 HART 2024-B A3 4.84
03/15/2029
07/16/2024
07/24/2024
30,000.00
29,995.90
0.00 0.00
29,995.98
64.53 121.00
64.53 121.00
0.08 0.00
0.08 121.08
121.08
44935FAD6 HART 2021-C A3 0.74
05/15/2026
11/09/2021
11/17/2021
1,570.84
2,612.24
0.00 (1,041.51)
1,570.78
0.86 1.61
0.52 1.27
0.05 0.00
0.05 1.31
1.31 4581X0EM6
INTER-AMERICAN
DEVELOPMENT BANK 4.375
02/01/2027
12/05/2023
12/12/2023
215,000.00
214,878.75
0.00 0.00
214,883.69
3,919.27
0.00 4,703.13
783.85
4.94 0.00
4.94 788.79
788.79
459058KT9
INTERNATIONAL BANK FOR
RECONSTRUCTION AND
DEVELOPM 3.5 07/12/2028
09/07/2023
09/11/2023
140,000.00
135,434.82
0.00 0.00
135,544.70
2,300.28
2,450.00
258.61
408.33
109.88
0.00 109.88
518.21
518.21
459058KW2
INTERNATIONAL BANK FOR
RECONSTRUCTION AND
DEVELOPM 4.625 08/01/2028 115,000.00
113,936.11
0.00 0.00
113,961.32
2,216.15
0.00 2,659.38
443.23
25.21 0.00
25.21 468.44
468.44
45950KDF4 INTERNATIONAL FINANCE
CORP 4.375 01/15/2027
11/29/2023
12/06/2023
80,000.00
79,829.19
0.00 0.00
79,836.31
1,614.26
1,750.40
155.59
291.73
7.12 0.00
7.12 298.85
298.85
CONFIDENTIAL | 28
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
INCOME EARNED
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
46647PEU6 JPMORGAN CHASE & CO
4.915 01/24/2029
01/16/2025
01/24/2025
65,000.00
0.00 65,000.00
0.00 65,000.00
0.00 0.00
62.12 62.12
0.00 0.00
0.00 62.12
62.12 47787CAC7 JDOT 2023-C A3 5.48
05/15/2028
09/12/2023
09/19/2023
105,000.00
104,994.78
0.00 0.00
104,994.92
255.73
479.50
255.73
479.50
0.13 0.00
0.13 479.63
479.63
47787JAC2 JDOT 2022 A3 0.36
09/15/2026
03/10/2022
03/16/2022
11,493.72
13,173.50
0.00 (1,680.58)
11,493.06
13.58 25.47
11.85 23.74
0.14 0.00
0.14 23.87
23.87 47789QAC4 JDOT 2021-B A3 0.52
03/16/2026
07/13/2021
07/21/2021
4,247.71
5,702.86
0.00 (1,455.22)
4,247.66
1.32 2.47
0.98 2.13
0.02 0.00
0.02 2.16
2.16 47800AAC4 JDOT 2022-B A3 3.74
02/16/2027
07/12/2022
07/20/2022
25,231.49
27,469.53
0.00 (2,239.04)
25,230.60
45.66 85.62
41.94 81.90
0.12 0.00
0.12 82.02
82.02 58769GAD5 MBALT 2024-B A3 4.23
02/15/2028
09/17/2024
09/25/2024
45,000.00
44,993.03
0.00 0.00
44,993.22
84.60 158.63
84.60 158.63
0.19 0.00
0.19 158.82
158.82
58770AAC7 MBART 2023-1 A3 4.51
11/15/2027
01/18/2023
01/25/2023
26,438.89
28,519.56
0.00 (2,082.65)
26,437.11
57.17 107.19
53.00 103.02
0.20 0.00
0.20 103.21
103.21
58933YBH7 MERCK & CO INC 4.05
05/17/2028
05/08/2023
05/17/2023
30,000.00
29,983.61
0.00 0.00
29,984.03
148.50
0.00 249.75
101.25
0.41 0.00
0.41 101.66
101.66
6174468C6 MORGAN STANLEY 4.0
07/23/2025
03/15/2024
03/19/2024
140,000.00
139,028.16
0.00 0.00
139,176.57
2,457.78
2,800.00
124.44
466.67
148.41
0.00 148.41
615.08
615.08
CONFIDENTIAL | 29
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
INCOME EARNED
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
61747YET8 MORGAN STANLEY 4.679
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
COOPERATIVE FINANCE CORP
3.45 06/15/2025
04/27/2022
05/04/2022
35,000.00
34,998.99
0.00 0.00
34,999.18
53.67 0.00
154.29
100.63
0.19 0.00
0.19 100.81
100.81
63743HFT4
NATIONAL RURAL UTILITIES
COOPERATIVE FINANCE CORP
4.12 09/16/2027
11/18/2024
11/19/2024
140,000.00
138,259.93
0.00 0.00
138,314.53
1,682.33
0.00 2,163.00
480.67
54.60 0.00
54.60 535.26
535.26
665859AW4 NORTHERN TRUST CORP 4.0
05/10/2027
09/28/2022
09/30/2022
150,000.00
147,650.38
0.00 0.00
147,735.17
850.00
0.00 1,350.00
500.00
84.79 0.00
84.79 584.79
584.79
69371RS56 PACCAR FINANCIAL CORP
5.05 08/10/2026
12/08/2023
12/13/2023
80,000.00
80,103.80
0.00 0.00
80,098.31
1,582.33
0.00 1,919.00
336.67
0.00 (5.49)
(5.49)
331.18
331.18
69371RT48 PACCAR FINANCIAL CORP 4.0
09/26/2029
09/23/2024
09/26/2024
70,000.00
69,863.46
0.00 0.00
69,865.91
738.89
0.00 972.22
233.33
2.45 0.00
2.45 235.78
235.78
78016HZT0 ROYAL BANK OF CANADA
4.875 01/19/2027
01/10/2024
01/19/2024
105,000.00
104,982.08
0.00 0.00
104,982.83
2,303.44
2,559.38
170.63
426.57
0.74 0.00
0.74 427.31
427.31
79466LAF1 SALESFORCE INC 3.7
04/11/2028
08/21/2024
08/22/2024
140,000.00
138,307.95
0.00 0.00
138,351.81
1,151.11
0.00 1,582.78
431.67
43.86 0.00
43.86 475.52
475.52
857477BR3 STATE STREET CORP 1.746
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.93 0.00
0.00 0.00
50.93 50.93
CONFIDENTIAL | 30
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
INCOME EARNED
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
857477CL5 STATE STREET CORP 4.993
03/18/2027
03/13/2024
03/18/2024
125,000.00
125,000.00
0.00 0.00
125,000.00
1,785.69
0.00 2,305.80
520.10
0.00 0.00
0.00 520.10
520.10
89115A2V3 TORONTO-DOMINION BANK
5.264 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
89236TKN4 TOYOTA MOTOR CREDIT
CORP 4.8 01/10/2025
01/10/2023
01/12/2023
0.00 129,998.89
0.00 (130,000.00)
0.00 2,964.00
3,120.00
0.00 156.00
1.11 0.00
1.11 157.11
157.11
89238DAD0 TAOT 2024-A A3 4.83
10/16/2028
01/23/2024
01/30/2024
60,000.00
59,990.34
0.00 0.00
59,990.56
128.80
241.50
128.80
241.50
0.22 0.00
0.22 241.72
241.72
89239FAD4 TAOT 2023-D A3 5.54
08/15/2028
11/07/2023
11/14/2023
45,000.00
44,996.31
0.00 0.00
44,996.39
110.80
207.75
110.80
207.75
0.09 0.00
0.09 207.84
207.84
9128286L9 UNITED STATES TREASURY
2.25 03/31/2026 275,000.00
272,292.54
0.00 0.00
272,477.41
1,580.87
0.00 2,107.83
526.96
221.17
(36.30)
184.87
711.83
711.83
912828J27 UNITED STATES TREASURY 2.0
02/15/2025
06/25/2024
06/26/2024
250,000.00
249,019.68
0.00 0.00
249,695.01
1,888.59
0.00 2,309.78
421.20
675.33
0.00 675.33
1,096.53
1,096.53
912828K74 UNITED STATES TREASURY 2.0
08/15/2025
11/18/2024
11/19/2024
150,000.00
147,784.76
0.00 0.00
148,088.62
1,133.15
0.00 1,385.87
252.72
303.86
0.00 303.86
556.58
556.58
912828R36 UNITED STATES TREASURY
1.625 05/15/2026 265,000.00
261,323.20
0.00 0.00
261,551.62
559.10
0.00 927.87
368.77
292.00
(63.58)
228.42
597.19
597.19
CONFIDENTIAL | 31
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
INCOME EARNED
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
912828U24 UNITED STATES TREASURY 2.0
11/15/2026
03/29/2022
03/30/2022
265,000.00
262,416.12
0.00 0.00
262,533.40
688.12
0.00 1,141.99
453.87
117.28
0.00 117.28
571.14
571.14
912828X88 UNITED STATES TREASURY
2.375 05/15/2027 275,000.00
271,426.33
0.00 0.00
271,554.55
847.98
0.00 1,407.29
559.31
128.22
0.00 128.22
687.53
687.53
912828YG9 UNITED STATES TREASURY
1.625 09/30/2026
12/28/2021
12/29/2021
200,000.00
201,295.74
0.00 0.00
201,232.68
830.36
0.00 1,107.14
276.79
0.00 (63.06)
(63.06)
213.73
213.73
912828ZF0 UNITED STATES TREASURY 0.5
03/31/2025
03/25/2021
03/29/2021
125,000.00
124,976.24
0.00 0.00
124,984.51
159.68
0.00 212.91
53.23 8.28
0.00 8.28
61.51 61.51
912828ZT0 UNITED STATES TREASURY
0.25 05/31/2025
02/25/2021
02/26/2021
250,000.00
249,646.74
0.00 0.00
249,719.75
54.95 0.00
108.17
53.23 73.01
0.00 73.01
126.23
126.23
91282CAZ4 UNITED STATES TREASURY
0.375 11/30/2025
12/09/2020
12/10/2020
175,000.00
174,944.84
0.00 0.00
174,949.98
57.69 0.00
113.58
55.89 5.13
0.00 5.13
61.02 61.02
91282CEF4 UNITED STATES TREASURY 2.5
03/31/2027
05/25/2022
05/26/2022
200,000.00
199,023.97
0.00 0.00
199,060.91
1,277.47
0.00 1,703.30
425.82
36.94 0.00
36.94 462.77
462.77
91282CEH0 UNITED STATES TREASURY
2.625 04/15/2025
07/29/2024
07/30/2024
150,000.00
149,028.29
0.00 0.00
149,317.94
843.75
0.00 1,179.09
335.34
289.64
0.00 289.64
624.98
624.98
91282CEU1 UNITED STATES TREASURY
2.875 06/15/2025
08/21/2024
08/22/2024
150,000.00
148,909.51
0.00 0.00
149,114.39
201.41
0.00 568.68
367.27
204.88
0.00 204.88
572.15
572.15
CONFIDENTIAL | 32
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
INCOME EARNED
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
91282CEY3 UNITED STATES TREASURY 3.0
07/15/2025
06/23/2023
06/26/2023
260,000.00
257,768.67
0.00 0.00
258,123.40
3,603.26
3,900.00
366.30
663.04
354.72
0.00 354.72
1,017.76
1,017.76
91282CFK2 UNITED STATES TREASURY 3.5
09/15/2025
12/30/2024
12/31/2024
150,000.00
149,212.05
0.00 0.00
149,307.09
1,566.30
0.00 2,015.88
449.59
95.05 0.00
95.05 544.63
544.63
91282CFM8 UNITED STATES TREASURY
4.125 09/30/2027
10/26/2022
10/27/2022
260,000.00
259,598.37
0.00 0.00
259,610.79
2,740.18
0.00 3,653.57
913.39
12.43 0.00
12.43 925.82
925.82
91282CGC9 UNITED STATES TREASURY
3.875 12/31/2027 300,000.00
297,425.07
0.00 0.00
297,498.04
32.11 0.00
1,027.62
995.51
72.96 0.00
72.96 1,068.48
1,068.48
91282CGT2 UNITED STATES TREASURY
3.625 03/31/2028
04/19/2023
04/20/2023
240,000.00
239,231.51
0.00 0.00
239,251.61
2,222.80
0.00 2,963.74
740.93
20.10 0.00
20.10 761.04
761.04
91282CHH7 UNITED STATES TREASURY
4.125 06/15/2026
10/21/2024
10/22/2024
100,000.00
100,110.23
0.00 0.00
100,103.79
192.65
0.00 543.96
351.30
0.00 (6.45)
(6.45)
344.86
344.86
91282CHK0 UNITED STATES TREASURY 4.0
06/30/2028
12/30/2024
12/31/2024
200,000.00
197,954.73
0.00 0.00
198,004.42
22.10 0.00
707.18
685.08
49.69 0.00
49.69 734.77
734.77
91282CLK5 UNITED STATES TREASURY
3.625 08/31/2029
09/25/2024
09/26/2024
175,000.00
175,873.12
0.00 0.00
175,857.23
2,155.47
0.00 2,698.72
543.25
0.00 (15.89)
(15.89)
527.36
527.36
931142ER0 WALMART INC 1.05
09/17/2026
09/08/2021
09/17/2021
25,000.00
24,983.85
0.00 0.00
24,984.65
75.83 0.00
97.71 21.88
0.80 0.00
0.80 22.68
22.68
CONFIDENTIAL | 33
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
INCOME EARNED
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
931142EW9 WALMART INC 3.9
09/09/2025
09/06/2022
09/09/2022
30,000.00
29,995.95
0.00 0.00
29,996.45
364.00
0.00 461.50
97.50 0.50
0.00 0.50
98.00 98.00
Total Fixed Income 11,202,153.71
11,321,486.08
159,971.50
(380,443.69)
11,106,387.00
80,428.83
30,074.69
82,601.29
32,247.14
5,826.04
(452.92)
5,373.11
37,620.26 37,620.26
TOTAL PORTFOLIO 11,541,036.26
11,407,867.80
867,674.21
(838,054.25)
11,443,165.18
80,428.83
30,714.45
82,601.29
32,886.90
6,177.12
(452.92)
5,724.19
38,611.10 38,611.10
CONFIDENTIAL | 34
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount FEBRUARY 2025
02/03/2025 Dividend 31846V203 0.00 FIRST AMER:GVT OBLG Y 592.99 592.99 02/03/2025 Coupon 4581X0EM6 0.00 INTER-AMERICAN DEVELOPMENT BANK 4.375 02/01/2027 4,703.13 4,703.13
02/03/2025 Coupon 459058KW2 0.00 INTERNATIONAL BANK FOR RECONSTRUCTION AND DEVELOPM 4.625 08/01/2028 2,659.95 2,659.95
02/06/2025 Coupon 857477BR3 35,000.00 STATE STREET CORP 1.746 02/06/2026 305.55 305.55 02/06/2025 Effective Maturity 857477BR3 35,000.00 STATE STREET CORP 1.746 02/06/2026 35,000.00 35,000.00 02/10/2025 Coupon 037833CJ7 150,000.00 APPLE INC 3.35 02/09/2027 2,512.50 2,512.50 02/10/2025 Coupon 69371RS56 80,000.00 PACCAR FINANCIAL CORP 5.05 08/10/2026 2,020.00 2,020.00 02/17/2025 Coupon 362554AC1 4,355.55 GMCAR 2021-4 A3 0.68 09/16/2026 2.81 2.81 02/17/2025 Principal Paydown 362554AC1 4,355.55 GMCAR 2021-4 A3 0.68 09/16/2026 811.62 811.62 02/17/2025 Coupon 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 149.00 149.00 02/17/2025 Principal Paydown 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 1,909.55 1,909.55 02/17/2025 Coupon 36265WAD5 16,116.38 GMCAR 2022-3 A3 3.64 04/16/2027 49.33 49.33 02/17/2025 Principal Paydown 36265WAD5 16,116.38 GMCAR 2022-3 A3 3.64 04/16/2027 1,581.11 1,581.11 02/17/2025 Coupon 380146AC4 5,664.88 GMCAR 2022-1 A3 1.26 11/16/2026 6.06 6.06 02/17/2025 Principal Paydown 380146AC4 5,664.88 GMCAR 2022-1 A3 1.26 11/16/2026 942.47 942.47 02/17/2025 Coupon 38014AAD3 35,000.00 GMCAR 2024-4 A3 4.4 08/16/2029 128.33 128.33 02/17/2025 Coupon 43815BAC4 14,846.64 HAROT 2022-1 A3 1.88 05/15/2026 23.26 23.26 02/17/2025 Principal Paydown 43815BAC4 14,846.64
HAROT 2022-1 A3 1.88 05/15/2026 2,255.10 2,255.10
02/17/2025 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.13 187.13 02/17/2025 Coupon 448976AD2 50,000.00 HART 2024-C A3 4.41 05/15/2029 183.75 183.75 02/17/2025 Coupon 448979AD6 43,324.91 HART 2023-A A3 4.58 04/15/2027 165.36 165.36 02/17/2025 Principal Paydown 448979AD6 43,324.91 HART 2023-A A3 4.58 04/15/2027 3,267.41 3,267.41 02/17/2025 Coupon 44934QAD3 30,000.00 HART 2024-B A3 4.84 03/15/2029 121.00 121.00 02/17/2025 Coupon 44935FAD6 1,570.84 HART 2021-C A3 0.74 05/15/2026 0.97 0.97 02/17/2025 Principal Paydown 44935FAD6 1,570.84 HART 2021-C A3 0.74 05/15/2026 922.99 922.99 02/17/2025 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 479.50 479.50 02/17/2025 Coupon 47787JAC2 11,493.72 JDOT 2022 A3 0.36 09/15/2026 22.22 22.22 02/17/2025 Principal Paydown 47787JAC2 11,493.72 JDOT 2022 A3 0.36 09/15/2026 1,460.83 1,460.83 02/17/2025 Coupon 47789QAC4 4,247.71 JDOT 2021-B A3 0.52 03/16/2026 1.84 1.84
CONFIDENTIAL | 35
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 02/17/2025 Principal Paydown 47789QAC4 4,247.71 JDOT 2021-B A3 0.52 03/16/2026 1,662.62 1,662.62 02/17/2025 Coupon 47800AAC4 25,231.49 JDOT 2022-B A3 3.74 02/16/2027 78.64 78.64 02/17/2025 Principal Paydown 47800AAC4 25,231.49 JDOT 2022-B A3 3.74 02/16/2027 2,336.60 2,336.60 02/17/2025 Coupon 58769GAD5 45,000.00 MBALT 2024-B A3 4.23 02/15/2028 158.63 158.63 02/17/2025 Coupon 58770AAC7 26,438.89 MBART 2023-1 A3 4.51 11/15/2027 99.37 99.37 02/17/2025 Principal Paydown 58770AAC7 26,438.89 MBART 2023-1 A3 4.51 11/15/2027 1,626.56 1,626.56 02/17/2025 Coupon 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 241.50 241.50 02/17/2025 Coupon 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 207.75 207.75 02/18/2025 Coupon 02582JKD1 115,000.00 AMXCA 2023-3 A 5.23 09/15/2028 501.21 501.21 02/18/2025 Coupon 02582JKH2 100,000.00 AMXCA 2024-1 A 5.23 04/16/2029 435.83 435.83 02/18/2025 Coupon 43815PAC3 16,159.60 HAROT 2022-2 A3 3.73 07/20/2026 50.72 50.72 02/18/2025 Principal Paydown 43815PAC3 16,159.60 HAROT 2022-2 A3 3.73 07/20/2026 1,867.19 1,867.19 02/18/2025 Coupon 438516CJ3 125,000.00 HONEYWELL INTERNATIONAL INC 4.95 02/15/2028 3,093.75 3,093.75
02/18/2025 Coupon 912828J27 250,000.00 UNITED STATES TREASURY 2.0 02/15/2025 2,500.00 2,500.00 02/18/2025 Final Maturity 912828J27 250,000.00 UNITED STATES TREASURY 2.0 02/15/2025 250,000.00 250,000.00 02/18/2025 Coupon 912828K74 150,000.00 UNITED STATES TREASURY 2.0 08/15/2025 1,500.00 1,500.00 02/20/2025 Coupon 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 275.71 275.71 02/20/2025 Coupon 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 44.83 44.83 02/20/2025 Coupon 38012QAD0 30,000.00 GMALT 2024-3 A3 4.21 10/20/2027 105.25 105.25 02/21/2025 Coupon 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 165.38 165.38 02/21/2025 Coupon 43815GAC3 4,225.77 HAROT 2021-4 A3 0.88 01/21/2026 3.10 3.10 02/21/2025 Principal Paydown 43815GAC3 4,225.77 HAROT 2021-4 A3 0.88 01/21/2026 1,126.37 1,126.37 02/21/2025 Coupon 43815JAC7 22,004.23 HAROT 2023-1 A3 5.04 04/21/2027 93.56 93.56 02/21/2025 Principal Paydown 43815JAC7 22,004.23 HAROT 2023-1 A3 5.04 04/21/2027 1,614.26 1,614.26 02/25/2025 Coupon 05593AAC3 2,035.70 BMWLT 2023-1 A3 5.16 11/25/2025 5.77 5.77 02/25/2025 Effective Maturity 05593AAC3 2,035.70 BMWLT 2023-1 A3 5.16 11/25/2025 1,342.02 1,342.02 02/25/2025 Coupon 3137BNGT5 165,437.39 FHMS K-054 A2 2.745 01/25/2026 378.44 378.44 02/25/2025 Principal Paydown 3137BNGT5 165,437.39 FHMS K-054 A2 2.745 01/25/2026 308.21 308.21 02/25/2025 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42 02/25/2025 Coupon 3137FETN0 160,000.00 FHMS K-073 A2 3.35 01/25/2028 446.67 446.67 02/25/2025 Coupon 3137FHPJ6 110,000.00 FHMS K-080 A2 3.926 07/25/2028 359.88 359.88
CONFIDENTIAL | 36
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 02/25/2025 Coupon 3137FJEH8 105,000.00 FHMS K-081 A2 3.9 08/25/2028 341.25 341.25 02/25/2025 Coupon 3137FJKE8 54,000.00 FHMS K-082 A2 3.92 09/25/2028 176.40 176.40 02/25/2025 Coupon 3137FJXV6 100,000.00 FHMS K-083 A2 4.05 09/25/2028 337.50 337.50 02/25/2025 Coupon 3137FKZZ2 110,000.00 FHMS K-088 A2 3.69 01/25/2029 338.25 338.25 02/25/2025 Coupon 3137H4BY5 110,000.00 FHMS K-746 A2 2.031 09/25/2028 186.18 186.18 02/25/2025 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 02/26/2025 Coupon 17275RBQ4 60,000.00 CISCO SYSTEMS INC 4.8 02/26/2027 1,440.00 1,440.00 02/28/2025 Coupon 91282CLK5 175,000.00 UNITED STATES TREASURY 3.625 08/31/2029 3,171.88 3,171.88 February 2025
Total 310,627.91 30,990.11 341,618.02
MARCH 2025
03/10/2025 Coupon 3130ATS57 275,000.00 FEDERAL HOME LOAN BANKS 4.5 03/10/2028 6,187.50 6,187.50 03/10/2025 Coupon 931142EW9 30,000.00 WALMART INC 3.9 09/09/2025 585.00 585.00 03/17/2025 Coupon 02582JKD1 115,000.00 AMXCA 2023-3 A 5.23 09/15/2028 501.21 501.21 03/17/2025 Coupon 02582JKH2 100,000.00 AMXCA 2024-1 A 5.23 04/16/2029 435.83 435.83 03/17/2025 Coupon 362554AC1 4,355.55 GMCAR 2021-4 A3 0.68 09/16/2026 2.35 2.35 03/17/2025 Principal Paydown 362554AC1 4,355.55 GMCAR 2021-4 A3 0.68 09/16/2026 790.35 790.35 03/17/2025 Coupon 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 141.89 141.89 03/17/2025 Principal Paydown 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 2,326.22 2,326.22 03/17/2025 Coupon 36265WAD5 16,116.38 GMCAR 2022-3 A3 3.64 04/16/2027 44.53 44.53 03/17/2025 Principal Paydown 36265WAD5 16,116.38 GMCAR 2022-3 A3 3.64 04/16/2027 1,469.59 1,469.59 03/17/2025 Coupon 380146AC4 5,664.88 GMCAR 2022-1 A3 1.26 11/16/2026 5.07 5.07 03/17/2025 Principal Paydown 380146AC4 5,664.88 GMCAR 2022-1 A3 1.26 11/16/2026 913.50 913.50 03/17/2025 Coupon 38014AAD3 35,000.00 GMCAR 2024-4 A3 4.4 08/16/2029 128.33 128.33 03/17/2025 Coupon 437076CR1 40,000.00 HOME DEPOT INC 4.0 09/15/2025 800.00 800.00 03/17/2025 Coupon 43815BAC4 14,846.64 HAROT 2022-1 A3 1.88 05/15/2026 19.73 19.73 03/17/2025 Principal Paydown 43815BAC4 14,846.64 HAROT 2022-1 A3 1.88 05/15/2026 2,190.58 2,190.58 03/17/2025 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.13 187.13 03/17/2025 Coupon 448976AD2 50,000.00 HART 2024-C A3 4.41 05/15/2029 183.75 183.75 03/17/2025 Coupon 448979AD6 43,324.91 HART 2023-A A3 4.58 04/15/2027 152.89 152.89 03/17/2025 Principal Paydown 448979AD6 43,324.91 HART 2023-A A3 4.58 04/15/2027 3,165.25 3,165.25 03/17/2025 Coupon 44934QAD3 30,000.00 HART 2024-B A3 4.84 03/15/2029 121.00 121.00
CONFIDENTIAL | 37
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 03/17/2025 Coupon 44935FAD6 1,570.84 HART 2021-C A3 0.74 05/15/2026 0.40 0.40 03/17/2025 Effective Maturity 44935FAD6 1,570.84 HART 2021-C A3 0.74 05/15/2026 647.85 647.85 03/17/2025 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 479.50 479.50 03/17/2025 Coupon 47787JAC2 11,493.72 JDOT 2022 A3 0.36 09/15/2026 19.40 19.40 03/17/2025 Principal Paydown 47787JAC2 11,493.72 JDOT 2022 A3 0.36 09/15/2026 1,207.02 1,207.02 03/17/2025 Coupon 47789QAC4 4,247.71 JDOT 2021-B A3 0.52 03/16/2026 1.12 1.12 03/17/2025 Principal Paydown 47789QAC4 4,247.71 JDOT 2021-B A3 0.52 03/16/2026 1,431.28 1,431.28 03/17/2025 Coupon 47800AAC4 25,231.49 JDOT 2022-B A3 3.74 02/16/2027 71.36 71.36 03/17/2025 Principal Paydown 47800AAC4 25,231.49 JDOT 2022-B A3 3.74 02/16/2027 2,063.33 2,063.33 03/17/2025 Coupon 58769GAD5 45,000.00 MBALT 2024-B A3 4.23 02/15/2028 158.63 158.63 03/17/2025 Coupon 58770AAC7 26,438.89 MBART 2023-1 A3 4.51 11/15/2027 93.25 93.25 03/17/2025 Principal Paydown 58770AAC7 26,438.89 MBART 2023-1 A3 4.51 11/15/2027 1,568.53 1,568.53 03/17/2025 Coupon 63743HFT4 140,000.00 NATIONAL RURAL UTILITIES COOPERATIVE FINANCE CORP 4.12 09/16/2027 2,884.00 2,884.00
03/17/2025 Coupon 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 241.50 241.50 03/17/2025 Coupon 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 207.75 207.75 03/17/2025 Coupon 91282CFK2 150,000.00 UNITED STATES TREASURY 3.5 09/15/2025 2,625.00 2,625.00 03/17/2025 Coupon 931142ER0 25,000.00 WALMART INC 1.05 09/17/2026 131.25 131.25 03/18/2025 Coupon 43815PAC3 16,159.60 HAROT 2022-2 A3 3.73 07/20/2026 44.91 44.91 03/18/2025 Principal Paydown 43815PAC3 16,159.60 HAROT 2022-2 A3 3.73 07/20/2026 1,810.49 1,810.49 03/18/2025 Coupon 857477CL5 125,000.00 STATE STREET CORP 4.993 03/18/2027 3,120.63 3,120.63 03/18/2025 Final Maturity 912797NR4 150,000.00 UNITED STATES TREASURY 03/18/2025 150,000.00 150,000.00 03/20/2025 Coupon 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 275.71 275.71 03/20/2025 Coupon 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 44.83 44.83 03/20/2025 Principal Paydown 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 871.46 871.46 03/20/2025 Coupon 38012QAD0 30,000.00 GMALT 2024-3 A3 4.21 10/20/2027 105.25 105.25 03/21/2025 Coupon 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 165.38 165.38 03/21/2025 Coupon 43815GAC3 4,225.77 HAROT 2021-4 A3 0.88 01/21/2026 2.27 2.27 03/21/2025 Principal Paydown 43815GAC3 4,225.77 HAROT 2021-4 A3 0.88 01/21/2026 1,095.10 1,095.10 03/21/2025 Coupon 43815JAC7 22,004.23 HAROT 2023-1 A3 5.04 04/21/2027 86.78 86.78 03/21/2025 Principal Paydown 43815JAC7 22,004.23 HAROT 2023-1 A3 5.04 04/21/2027 1,560.34 1,560.34 03/25/2025 Coupon 3137BNGT5 165,437.39 FHMS K-054 A2 2.745 01/25/2026 377.73 377.73
CONFIDENTIAL | 38
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 03/25/2025 Principal Paydown 3137BNGT5 165,437.39 FHMS K-054 A2 2.745 01/25/2026 370.29 370.29 03/25/2025 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42 03/25/2025 Coupon 3137FETN0 160,000.00 FHMS K-073 A2 3.35 01/25/2028 446.67 446.67 03/25/2025 Coupon 3137FHPJ6 110,000.00 FHMS K-080 A2 3.926 07/25/2028 359.88 359.88 03/25/2025 Coupon 3137FJEH8 105,000.00 FHMS K-081 A2 3.9 08/25/2028 341.25 341.25 03/25/2025 Coupon 3137FJKE8 54,000.00 FHMS K-082 A2 3.92 09/25/2028 176.40 176.40 03/25/2025 Coupon 3137FJXV6 100,000.00 FHMS K-083 A2 4.05 09/25/2028 337.50 337.50 03/25/2025 Coupon 3137FKZZ2 110,000.00 FHMS K-088 A2 3.69 01/25/2029 338.25 338.25 03/25/2025 Coupon 3137H4BY5 110,000.00 FHMS K-746 A2 2.031 09/25/2028 186.18 186.18 03/25/2025 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 03/26/2025 Coupon 69371RT48 70,000.00 PACCAR FINANCIAL CORP 4.0 09/26/2029 1,400.00 1,400.00 03/31/2025 Coupon 9128286L9 275,000.00 UNITED STATES TREASURY 2.25 03/31/2026 3,093.75 3,093.75 03/31/2025 Coupon 912828YG9 200,000.00 UNITED STATES TREASURY 1.625 09/30/2026 1,625.00 1,625.00 03/31/2025 Coupon 912828ZF0 125,000.00 UNITED STATES TREASURY 0.5 03/31/2025 312.50 312.50 03/31/2025 Final Maturity 912828ZF0 125,000.00 UNITED STATES TREASURY 0.5 03/31/2025 125,000.00 125,000.00 03/31/2025 Coupon 91282CEF4 200,000.00 UNITED STATES TREASURY 2.5 03/31/2027 2,500.00 2,500.00 03/31/2025 Coupon 91282CFM8 260,000.00 UNITED STATES TREASURY 4.125 09/30/2027 5,362.50 5,362.50 03/31/2025 Coupon 91282CGT2 240,000.00 UNITED STATES TREASURY 3.625 03/31/2028 4,350.00 4,350.00 March 2025 Total 298,481.17 41,993.72 340,474.89
APRIL 2025
04/01/2025 Coupon 13063D7D4 100,000.00 CALIFORNIA STATE 5.5 10/01/2028 2,750.00 2,750.00 04/09/2025 Coupon 3130B3A29 200,000.00 FEDERAL HOME LOAN BANKS 4.0 10/09/2026 3,955.56 3,955.56 04/11/2025 Coupon 79466LAF1 140,000.00 SALESFORCE INC 3.7 04/11/2028 2,590.00 2,590.00 04/15/2025 Coupon 02582JKD1 115,000.00 AMXCA 2023-3 A 5.23 09/15/2028 501.21 501.21 04/15/2025 Coupon 02582JKH2 100,000.00 AMXCA 2024-1 A 5.23 04/16/2029 435.83 435.83 04/15/2025 Coupon 20030NCS8 140,000.00 COMCAST CORP 3.95 10/15/2025 2,765.00 2,765.00 04/15/2025 Coupon 43815BAC4 14,846.64 HAROT 2022-1 A3 1.88 05/15/2026 16.29 16.29 04/15/2025 Principal Paydown 43815BAC4 14,846.64 HAROT 2022-1 A3 1.88 05/15/2026 2,217.41 2,217.41 04/15/2025 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.13 187.13 04/15/2025 Coupon 448976AD2 50,000.00 HART 2024-C A3 4.41 05/15/2029 183.75 183.75 04/15/2025 Coupon 448979AD6 43,324.91 HART 2023-A A3 4.58 04/15/2027 140.81 140.81 04/15/2025 Principal Paydown 448979AD6 43,324.91 HART 2023-A A3 4.58 04/15/2027 3,291.48 3,291.48
CONFIDENTIAL | 39
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 04/15/2025 Coupon 44934QAD3 30,000.00 HART 2024-B A3 4.84 03/15/2029 121.00 121.00 04/15/2025 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 479.50 479.50 04/15/2025 Coupon 47787JAC2 11,493.72 JDOT 2022 A3 0.36 09/15/2026 17.06 17.06 04/15/2025 Principal Paydown 47787JAC2 11,493.72 JDOT 2022 A3 0.36 09/15/2026 1,544.57 1,544.57 04/15/2025 Coupon 47789QAC4 4,247.71 JDOT 2021-B A3 0.52 03/16/2026 0.50 0.50 04/15/2025 Effective Maturity 47789QAC4 4,247.71 JDOT 2021-B A3 0.52 03/16/2026 1,153.81 1,153.81 04/15/2025 Coupon 47800AAC4 25,231.49 JDOT 2022-B A3 3.74 02/16/2027 64.93 64.93 04/15/2025 Principal Paydown 47800AAC4 25,231.49 JDOT 2022-B A3 3.74 02/16/2027 2,782.75 2,782.75 04/15/2025 Coupon 58769GAD5 45,000.00 MBALT 2024-B A3 4.23 02/15/2028 158.63 158.63 04/15/2025 Coupon 58770AAC7 26,438.89 MBART 2023-1 A3 4.51 11/15/2027 87.36 87.36 04/15/2025 Principal Paydown 58770AAC7 26,438.89 MBART 2023-1 A3 4.51 11/15/2027 1,637.17 1,637.17 04/15/2025 Coupon 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 241.50 241.50 04/15/2025 Coupon 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 207.75 207.75 04/15/2025 Coupon 91282CEH0 150,000.00 UNITED STATES TREASURY 2.625 04/15/2025 1,968.75 1,968.75 04/15/2025 Final Maturity 91282CEH0 150,000.00 UNITED STATES TREASURY 2.625 04/15/2025 150,000.00 150,000.00 04/16/2025 Coupon 362554AC1 4,355.55 GMCAR 2021-4 A3 0.68 09/16/2026 1.90 1.90 04/16/2025 Principal Paydown 362554AC1 4,355.55 GMCAR 2021-4 A3 0.68 09/16/2026 812.73 812.73 04/16/2025 Coupon 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 133.22 133.22 04/16/2025 Principal Paydown 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 2,449.14 2,449.14 04/16/2025 Coupon 36265WAD5 16,116.38 GMCAR 2022-3 A3 3.64 04/16/2027 40.08 40.08 04/16/2025 Principal Paydown 36265WAD5 16,116.38 GMCAR 2022-3 A3 3.64 04/16/2027 1,523.61 1,523.61 04/16/2025 Coupon 380146AC4 5,664.88 GMCAR 2022-1 A3 1.26 11/16/2026 4.11 4.11 04/16/2025 Principal Paydown 380146AC4 5,664.88 GMCAR 2022-1 A3 1.26 11/16/2026 911.86 911.86 04/16/2025 Coupon 38014AAD3 35,000.00 GMCAR 2024-4 A3 4.4 08/16/2029 128.33 128.33 04/17/2025 Final Maturity 912797KS5 150,000.00 UNITED STATES TREASURY 04/17/2025 150,000.00 150,000.00 04/18/2025 Coupon 43815PAC3 16,159.60 HAROT 2022-2 A3 3.73 07/20/2026 39.28 39.28 04/18/2025 Principal Paydown 43815PAC3 16,159.60 HAROT 2022-2 A3 3.73 07/20/2026 1,841.47 1,841.47 04/21/2025 Coupon 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 275.71 275.71 04/21/2025 Coupon 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 40.93 40.93 04/21/2025 Principal Paydown 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 1,051.83 1,051.83 04/21/2025 Coupon 38012QAD0 30,000.00 GMALT 2024-3 A3 4.21 10/20/2027 105.25 105.25 04/21/2025 Coupon 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 165.38 165.38
CONFIDENTIAL | 40
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 04/21/2025 Coupon 43815GAC3 4,225.77 HAROT 2021-4 A3 0.88 01/21/2026 1.47 1.47 04/21/2025 Principal Paydown 43815GAC3 4,225.77 HAROT 2021-4 A3 0.88 01/21/2026 1,101.01 1,101.01 04/21/2025 Coupon 43815JAC7 22,004.23 HAROT 2023-1 A3 5.04 04/21/2027 80.22 80.22 04/21/2025 Principal Paydown 43815JAC7 22,004.23 HAROT 2023-1 A3 5.04 04/21/2027 1,605.05 1,605.05 04/25/2025 Coupon 3137BNGT5 165,437.39 FHMS K-054 A2 2.745 01/25/2026 376.89 376.89 04/25/2025 Principal Paydown 3137BNGT5 165,437.39 FHMS K-054 A2 2.745 01/25/2026 309.43 309.43 04/25/2025 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42 04/25/2025 Coupon 3137FETN0 160,000.00 FHMS K-073 A2 3.35 01/25/2028 446.67 446.67 04/25/2025 Coupon 3137FHPJ6 110,000.00 FHMS K-080 A2 3.926 07/25/2028 359.88 359.88 04/25/2025 Coupon 3137FJEH8 105,000.00 FHMS K-081 A2 3.9 08/25/2028 341.25 341.25 04/25/2025 Coupon 3137FJKE8 54,000.00 FHMS K-082 A2 3.92 09/25/2028 176.40 176.40 04/25/2025 Coupon 3137FJXV6 100,000.00 FHMS K-083 A2 4.05 09/25/2028 337.50 337.50 04/25/2025 Coupon 3137FKZZ2 110,000.00 FHMS K-088 A2 3.69 01/25/2029 338.25 338.25 04/25/2025 Coupon 3137H4BY5 110,000.00 FHMS K-746 A2 2.031 09/25/2028 186.18 186.18 04/25/2025 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 04/30/2025 Coupon 09247XAP6 150,000.00 BLACKROCK FINANCE INC 3.25 04/30/2029 2,437.50 2,437.50 April 2025 Total 324,233.31 23,419.94 347,653.25
MAY 2025
05/05/2025 Coupon 00440EAV9 135,000.00 CHUBB INA HOLDINGS LLC 3.35 05/03/2026 2,261.25 2,261.25 05/06/2025 Coupon 3133ERDS7 225,000.00 FEDERAL FARM CREDIT BANKS FUNDING CORP
4.75 05/06/2027 5,343.75 5,343.75
05/07/2025 Coupon 3135G06G3 225,000.00 FEDERAL NATIONAL MORTGAGE ASSOCIATION
0.5 11/07/2025 562.50 562.50
05/12/2025 Coupon 665859AW4 150,000.00 NORTHERN TRUST CORP 4.0 05/10/2027 3,000.00 3,000.00 05/14/2025 Coupon 14913UAL4 140,000.00 CATERPILLAR FINANCIAL SERVICES CORP 5.0 05/14/2027 3,500.00 3,500.00
05/15/2025 Coupon 02582JKD1 115,000.00 AMXCA 2023-3 A 5.23 09/15/2028 501.21 501.21 05/15/2025 Coupon 02582JKH2 100,000.00 AMXCA 2024-1 A 5.23 04/16/2029 435.83 435.83 05/15/2025 Coupon 43815BAC4 14,846.64 HAROT 2022-1 A3 1.88 05/15/2026 12.82 12.82 05/15/2025 Principal Paydown 43815BAC4 14,846.64 HAROT 2022-1 A3 1.88 05/15/2026 2,136.53 2,136.53 05/15/2025 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.13 187.13 05/15/2025 Coupon 448976AD2 50,000.00 HART 2024-C A3 4.41 05/15/2029 183.75 183.75
CONFIDENTIAL | 41
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 05/15/2025 Coupon 448979AD6 43,324.91 HART 2023-A A3 4.58 04/15/2027 128.24 128.24 05/15/2025 Principal Paydown 448979AD6 43,324.91 HART 2023-A A3 4.58 04/15/2027 3,154.16 3,154.16 05/15/2025 Coupon 44934QAD3 30,000.00 HART 2024-B A3 4.84 03/15/2029 121.00 121.00 05/15/2025 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 479.50 479.50 05/15/2025 Coupon 47787JAC2 11,493.72 JDOT 2022 A3 0.36 09/15/2026 14.08 14.08 05/15/2025 Principal Paydown 47787JAC2 11,493.72 JDOT 2022 A3 0.36 09/15/2026 1,425.60 1,425.60 05/15/2025 Coupon 47800AAC4 25,231.49 JDOT 2022-B A3 3.74 02/16/2027 56.25 56.25 05/15/2025 Principal Paydown 47800AAC4 25,231.49 JDOT 2022-B A3 3.74 02/16/2027 2,441.42 2,441.42 05/15/2025 Coupon 58769GAD5 45,000.00 MBALT 2024-B A3 4.23 02/15/2028 158.63 158.63 05/15/2025 Coupon 58770AAC7 26,438.89 MBART 2023-1 A3 4.51 11/15/2027 81.20 81.20 05/15/2025 Principal Paydown 58770AAC7 26,438.89 MBART 2023-1 A3 4.51 11/15/2027 1,568.85 1,568.85 05/15/2025 Coupon 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 241.50 241.50 05/15/2025 Coupon 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 207.75 207.75 05/15/2025 Coupon 912828R36 265,000.00 UNITED STATES TREASURY 1.625 05/15/2026 2,153.13 2,153.13 05/15/2025 Coupon 912828U24 265,000.00 UNITED STATES TREASURY 2.0 11/15/2026 2,650.00 2,650.00 05/15/2025 Coupon 912828X88 275,000.00 UNITED STATES TREASURY 2.375 05/15/2027 3,265.63 3,265.63 05/16/2025 Coupon 362554AC1 4,355.55 GMCAR 2021-4 A3 0.68 09/16/2026 1.44 1.44 05/16/2025 Principal Paydown 362554AC1 4,355.55 GMCAR 2021-4 A3 0.68 09/16/2026 786.00 786.00 05/16/2025 Coupon 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 124.10 124.10 05/16/2025 Principal Paydown 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 2,311.02 2,311.02 05/16/2025 Coupon 36265WAD5 16,116.38 GMCAR 2022-3 A3 3.64 04/16/2027 35.45 35.45 05/16/2025 Principal Paydown 36265WAD5 16,116.38 GMCAR 2022-3 A3 3.64 04/16/2027 1,461.07 1,461.07 05/16/2025 Coupon 380146AC4 5,664.88 GMCAR 2022-1 A3 1.26 11/16/2026 3.15 3.15 05/16/2025 Principal Paydown 380146AC4 5,664.88 GMCAR 2022-1 A3 1.26 11/16/2026 873.07 873.07 05/16/2025 Coupon 38014AAD3 35,000.00 GMCAR 2024-4 A3 4.4 08/16/2029 128.33 128.33 05/19/2025 Coupon 3130AXU63 160,000.00 FEDERAL HOME LOAN BANKS 4.625 11/17/2026 3,700.00 3,700.00
05/19/2025 Coupon 43815PAC3 16,159.60 HAROT 2022-2 A3 3.73 07/20/2026 33.56 33.56 05/19/2025 Principal Paydown 43815PAC3 16,159.60 HAROT 2022-2 A3 3.73 07/20/2026 1,769.72 1,769.72 05/19/2025 Coupon 58933YBH7 30,000.00 MERCK & CO INC 4.05 05/17/2028 607.50 607.50 05/20/2025 Coupon 3133ERFJ5 115,000.00 FEDERAL FARM CREDIT BANKS FUNDING CORP
4.5 05/20/2027 2,587.50 2,587.50
CONFIDENTIAL | 42
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 05/20/2025 Coupon 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 275.71 275.71 05/20/2025 Coupon 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 36.21 36.21 05/20/2025 Principal Paydown 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 1,318.14 1,318.14 05/20/2025 Coupon 38012QAD0 30,000.00 GMALT 2024-3 A3 4.21 10/20/2027 105.25 105.25 05/21/2025 Coupon 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 165.38 165.38 05/21/2025 Coupon 43815GAC3 4,225.77 HAROT 2021-4 A3 0.88 01/21/2026 0.66 0.66 05/21/2025 Effective Maturity 43815GAC3 4,225.77 HAROT 2021-4 A3 0.88 01/21/2026 903.29 903.29 05/21/2025 Coupon 43815JAC7 22,004.23 HAROT 2023-1 A3 5.04 04/21/2027 73.48 73.48 05/21/2025 Principal Paydown 43815JAC7 22,004.23 HAROT 2023-1 A3 5.04 04/21/2027 1,538.71 1,538.71 05/26/2025 Coupon 3137BNGT5 165,437.39 FHMS K-054 A2 2.745 01/25/2026 376.18 376.18 05/26/2025 Principal Paydown 3137BNGT5 165,437.39 FHMS K-054 A2 2.745 01/25/2026 330.28 330.28 05/26/2025 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42 05/26/2025 Coupon 3137FETN0 160,000.00 FHMS K-073 A2 3.35 01/25/2028 446.67 446.67 05/26/2025 Coupon 3137FHPJ6 110,000.00 FHMS K-080 A2 3.926 07/25/2028 359.88 359.88 05/26/2025 Coupon 3137FJEH8 105,000.00 FHMS K-081 A2 3.9 08/25/2028 341.25 341.25 05/26/2025 Coupon 3137FJKE8 54,000.00 FHMS K-082 A2 3.92 09/25/2028 176.40 176.40 05/26/2025 Coupon 3137FJXV6 100,000.00 FHMS K-083 A2 4.05 09/25/2028 337.50 337.50 05/26/2025 Coupon 3137FKZZ2 110,000.00 FHMS K-088 A2 3.69 01/25/2029 338.25 338.25 05/26/2025 Coupon 3137H4BY5 110,000.00 FHMS K-746 A2 2.031 09/25/2028 186.18 186.18 05/26/2025 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 May 2025 Total 22,017.87 36,516.18 58,534.05
JUNE 2025
06/02/2025 Coupon 26444HAH4 150,000.00 DUKE ENERGY FLORIDA LLC 2.5 12/01/2029 1,875.00 1,875.00 06/02/2025 Coupon 912828ZT0 250,000.00 UNITED STATES TREASURY 0.25 05/31/2025 312.50 312.50 06/02/2025 Final Maturity 912828ZT0 250,000.00 UNITED STATES TREASURY 0.25 05/31/2025 250,000.00 250,000.00 06/02/2025 Coupon 91282CAZ4 175,000.00 UNITED STATES TREASURY 0.375 11/30/2025 328.13 328.13 06/11/2025 Coupon 89115A2V3 55,000.00 TORONTO-DOMINION BANK 5.264 12/11/2026 1,447.60 1,447.60 06/16/2025 Coupon 02582JKD1 115,000.00 AMXCA 2023-3 A 5.23 09/15/2028 501.21 501.21 06/16/2025 Coupon 02582JKH2 100,000.00 AMXCA 2024-1 A 5.23 04/16/2029 435.83 435.83 06/16/2025 Coupon 3133EPN50 110,000.00 FEDERAL FARM CREDIT BANKS FUNDING CORP
4.25 12/15/2028 2,337.50 2,337.50
06/16/2025 Coupon 362554AC1 4,355.55 GMCAR 2021-4 A3 0.68 09/16/2026 1.00 1.00
CONFIDENTIAL | 43
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 06/16/2025 Principal Paydown 362554AC1 4,355.55 GMCAR 2021-4 A3 0.68 09/16/2026 751.74 751.74 06/16/2025 Coupon 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 115.49 115.49 06/16/2025 Principal Paydown 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 2,156.63 2,156.63 06/16/2025 Coupon 36265WAD5 16,116.38 GMCAR 2022-3 A3 3.64 04/16/2027 31.02 31.02 06/16/2025 Principal Paydown 36265WAD5 16,116.38 GMCAR 2022-3 A3 3.64 04/16/2027 1,433.81 1,433.81 06/16/2025 Coupon 380146AC4 5,664.88 GMCAR 2022-1 A3 1.26 11/16/2026 2.24 2.24 06/16/2025 Principal Paydown 380146AC4 5,664.88 GMCAR 2022-1 A3 1.26 11/16/2026 855.55 855.55 06/16/2025 Coupon 38014AAD3 35,000.00 GMCAR 2024-4 A3 4.4 08/16/2029 128.33 128.33 06/16/2025 Coupon 43815BAC4 14,846.64 HAROT 2022-1 A3 1.88 05/15/2026 9.47 9.47 06/16/2025 Principal Paydown 43815BAC4 14,846.64 HAROT 2022-1 A3 1.88 05/15/2026 2,084.16 2,084.16 06/16/2025 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.13 187.13 06/16/2025 Coupon 448976AD2 50,000.00 HART 2024-C A3 4.41 05/15/2029 183.75 183.75 06/16/2025 Coupon 448979AD6 43,324.91 HART 2023-A A3 4.58 04/15/2027 116.20 116.20 06/16/2025 Principal Paydown 448979AD6 43,324.91 HART 2023-A A3 4.58 04/15/2027 3,095.60 3,095.60 06/16/2025 Coupon 44934QAD3 30,000.00 HART 2024-B A3 4.84 03/15/2029 121.00 121.00 06/16/2025 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 479.50 479.50 06/16/2025 Principal Paydown 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 4,571.16 4,571.16 06/16/2025 Coupon 47787JAC2 11,493.72 JDOT 2022 A3 0.36 09/15/2026 11.32 11.32 06/16/2025 Principal Paydown 47787JAC2 11,493.72 JDOT 2022 A3 0.36 09/15/2026 1,153.61 1,153.61 06/16/2025 Coupon 47800AAC4 25,231.49 JDOT 2022-B A3 3.74 02/16/2027 48.64 48.64 06/16/2025 Principal Paydown 47800AAC4 25,231.49 JDOT 2022-B A3 3.74 02/16/2027 1,545.94 1,545.94 06/16/2025 Coupon 58769GAD5 45,000.00 MBALT 2024-B A3 4.23 02/15/2028 158.63 158.63 06/16/2025 Coupon 58770AAC7 26,438.89 MBART 2023-1 A3 4.51 11/15/2027 75.31 75.31 06/16/2025 Principal Paydown 58770AAC7 26,438.89 MBART 2023-1 A3 4.51 11/15/2027 1,540.93 1,540.93 06/16/2025 Coupon 63743HFE7 35,000.00 NATIONAL RURAL UTILITIES COOPERATIVE FINANCE CORP 3.45 06/15/2025 603.75 603.75
06/16/2025 Final Maturity 63743HFE7 35,000.00 NATIONAL RURAL UTILITIES COOPERATIVE FINANCE CORP 3.45 06/15/2025 35,000.00 35,000.00
06/16/2025 Coupon 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 241.50 241.50 06/16/2025 Coupon 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 207.75 207.75 06/16/2025 Coupon 91282CEU1 150,000.00 UNITED STATES TREASURY 2.875 06/15/2025 2,156.25 2,156.25 06/16/2025 Final Maturity 91282CEU1 150,000.00 UNITED STATES TREASURY 2.875 06/15/2025 150,000.00 150,000.00
CONFIDENTIAL | 44
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 06/16/2025 Coupon 91282CHH7 100,000.00 UNITED STATES TREASURY 4.125 06/15/2026 2,062.50 2,062.50 06/18/2025 Coupon 43815PAC3 16,159.60 HAROT 2022-2 A3 3.73 07/20/2026 28.06 28.06 06/18/2025 Principal Paydown 43815PAC3 16,159.60 HAROT 2022-2 A3 3.73 07/20/2026 1,591.66 1,591.66 06/20/2025 Coupon 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 275.71 275.71 06/20/2025 Coupon 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 30.30 30.30 06/20/2025 Principal Paydown 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 1,196.62 1,196.62 06/20/2025 Coupon 38012QAD0 30,000.00 GMALT 2024-3 A3 4.21 10/20/2027 105.25 105.25 06/23/2025 Coupon 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 165.38 165.38 06/23/2025 Coupon 43815JAC7 22,004.23 HAROT 2023-1 A3 5.04 04/21/2027 67.02 67.02 06/23/2025 Principal Paydown 43815JAC7 22,004.23 HAROT 2023-1 A3 5.04 04/21/2027 1,504.82 1,504.82 06/25/2025 Coupon 3137BNGT5 165,437.39 FHMS K-054 A2 2.745 01/25/2026 375.42 375.42 06/25/2025 Principal Paydown 3137BNGT5 165,437.39 FHMS K-054 A2 2.745 01/25/2026 6,557.18 6,557.18 06/25/2025 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42 06/25/2025 Coupon 3137FETN0 160,000.00 FHMS K-073 A2 3.35 01/25/2028 446.67 446.67 06/25/2025 Coupon 3137FHPJ6 110,000.00 FHMS K-080 A2 3.926 07/25/2028 359.88 359.88 06/25/2025 Coupon 3137FJEH8 105,000.00 FHMS K-081 A2 3.9 08/25/2028 341.25 341.25 06/25/2025 Coupon 3137FJKE8 54,000.00 FHMS K-082 A2 3.92 09/25/2028 176.40 176.40 06/25/2025 Coupon 3137FJXV6 100,000.00 FHMS K-083 A2 4.05 09/25/2028 337.50 337.50 06/25/2025 Coupon 3137FKZZ2 110,000.00 FHMS K-088 A2 3.69 01/25/2029 338.25 338.25 06/25/2025 Coupon 3137H4BY5 110,000.00 FHMS K-746 A2 2.031 09/25/2028 186.18 186.18 06/25/2025 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 06/25/2025 Coupon 437076DC3 75,000.00 HOME DEPOT INC 4.75 06/25/2029 1,781.25 1,781.25 06/30/2025 Coupon 91282CGC9 300,000.00 UNITED STATES TREASURY 3.875 12/31/2027 5,812.50 5,812.50 06/30/2025 Coupon 91282CHK0 200,000.00 UNITED STATES TREASURY 4.0 06/30/2028 4,000.00 4,000.00 June 2025 Total 465,039.40 29,536.56 494,575.96
JULY 2025
07/07/2025 Coupon 24422EXZ7 95,000.00 JOHN DEERE CAPITAL CORP 4.65 01/07/2028 2,184.21 2,184.21 07/14/2025 Coupon 459058KT9 140,000.00 INTERNATIONAL BANK FOR RECONSTRUCTION AND DEVELOPM 3.5 07/12/2028 2,450.00 2,450.00
07/15/2025 Coupon 02582JKD1 115,000.00 AMXCA 2023-3 A 5.23 09/15/2028 501.21 501.21 07/15/2025 Coupon 02582JKH2 100,000.00 AMXCA 2024-1 A 5.23 04/16/2029 435.83 435.83 07/15/2025 Coupon 43815BAC4 14,846.64 HAROT 2022-1 A3 1.88 05/15/2026 6.21 6.21
CONFIDENTIAL | 45
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 07/15/2025 Principal Paydown 43815BAC4 14,846.64 HAROT 2022-1 A3 1.88 05/15/2026 2,029.88 2,029.88 07/15/2025 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.13 187.13 07/15/2025 Coupon 448976AD2 50,000.00 HART 2024-C A3 4.41 05/15/2029 183.75 183.75 07/15/2025 Coupon 448979AD6 43,324.91 HART 2023-A A3 4.58 04/15/2027 104.39 104.39 07/15/2025 Principal Paydown 448979AD6 43,324.91 HART 2023-A A3 4.58 04/15/2027 3,031.92 3,031.92 07/15/2025 Coupon 44934QAD3 30,000.00 HART 2024-B A3 4.84 03/15/2029 121.00 121.00 07/15/2025 Coupon 45950KDF4 80,000.00 INTERNATIONAL FINANCE CORP 4.375 01/15/2027 1,750.40 1,750.40
07/15/2025 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 458.63 458.63 07/15/2025 Principal Paydown 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 7,284.71 7,284.71 07/15/2025 Coupon 47787JAC2 11,493.72 JDOT 2022 A3 0.36 09/15/2026 9.09 9.09 07/15/2025 Principal Paydown 47787JAC2 11,493.72 JDOT 2022 A3 0.36 09/15/2026 1,366.11 1,366.11 07/15/2025 Coupon 47800AAC4 25,231.49 JDOT 2022-B A3 3.74 02/16/2027 43.82 43.82 07/15/2025 Principal Paydown 47800AAC4 25,231.49 JDOT 2022-B A3 3.74 02/16/2027 1,309.40 1,309.40 07/15/2025 Coupon 58769GAD5 45,000.00 MBALT 2024-B A3 4.23 02/15/2028 158.63 158.63 07/15/2025 Coupon 58770AAC7 26,438.89 MBART 2023-1 A3 4.51 11/15/2027 69.52 69.52 07/15/2025 Principal Paydown 58770AAC7 26,438.89 MBART 2023-1 A3 4.51 11/15/2027 1,510.22 1,510.22 07/15/2025 Coupon 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 241.50 241.50 07/15/2025 Coupon 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 207.75 207.75 07/15/2025 Coupon 91282CEY3 260,000.00 UNITED STATES TREASURY 3.0 07/15/2025 3,900.00 3,900.00 07/15/2025 Final Maturity 91282CEY3 260,000.00 UNITED STATES TREASURY 3.0 07/15/2025 260,000.00 260,000.00 07/16/2025 Coupon 362554AC1 4,355.55 GMCAR 2021-4 A3 0.68 09/16/2026 0.57 0.57 07/16/2025 Principal Paydown 362554AC1 4,355.55 GMCAR 2021-4 A3 0.68 09/16/2026 722.19 722.19 07/16/2025 Coupon 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 107.46 107.46 07/16/2025 Principal Paydown 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 2,114.90 2,114.90 07/16/2025 Coupon 36265WAD5 16,116.38 GMCAR 2022-3 A3 3.64 04/16/2027 26.67 26.67 07/16/2025 Principal Paydown 36265WAD5 16,116.38 GMCAR 2022-3 A3 3.64 04/16/2027 1,402.45 1,402.45 07/16/2025 Coupon 380146AC4 5,664.88 GMCAR 2022-1 A3 1.26 11/16/2026 1.34 1.34 07/16/2025 Principal Paydown 380146AC4 5,664.88 GMCAR 2022-1 A3 1.26 11/16/2026 836.67 836.67 07/16/2025 Coupon 38014AAD3 35,000.00 GMCAR 2024-4 A3 4.4 08/16/2029 128.33 128.33 07/17/2025 Coupon 61747YET8 60,000.00 MORGAN STANLEY 4.679 07/17/2026 1,403.70 1,403.70 07/17/2025 Effective Maturity 61747YET8 60,000.00 MORGAN STANLEY 4.679 07/17/2026 60,000.00 60,000.00
CONFIDENTIAL | 46
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 07/18/2025 Coupon 43815PAC3 16,159.60 HAROT 2022-2 A3 3.73 07/20/2026 23.11 23.11 07/18/2025 Principal Paydown 43815PAC3 16,159.60 HAROT 2022-2 A3 3.73 07/20/2026 1,552.11 1,552.11 07/21/2025 Coupon 06051GLE7 135,000.00 BANK OF AMERICA CORP 5.08 01/20/2027 3,429.00 3,429.00 07/21/2025 Coupon 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 275.71 275.71 07/21/2025 Principal Paydown 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 2,263.09 2,263.09 07/21/2025 Coupon 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 24.94 24.94 07/21/2025 Principal Paydown 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 1,144.44 1,144.44 07/21/2025 Coupon 38012QAD0 30,000.00 GMALT 2024-3 A3 4.21 10/20/2027 105.25 105.25 07/21/2025 Coupon 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 165.38 165.38 07/21/2025 Coupon 43815JAC7 22,004.23 HAROT 2023-1 A3 5.04 04/21/2027 60.70 60.70 07/21/2025 Principal Paydown 43815JAC7 22,004.23 HAROT 2023-1 A3 5.04 04/21/2027 1,469.16 1,469.16 07/21/2025 Coupon 78016HZT0 105,000.00 ROYAL BANK OF CANADA 4.875 01/19/2027 2,559.38 2,559.38 07/23/2025 Coupon 6174468C6 140,000.00 MORGAN STANLEY 4.0 07/23/2025 2,800.00 2,800.00 07/23/2025 Final Maturity 6174468C6 140,000.00 MORGAN STANLEY 4.0 07/23/2025 140,000.00 140,000.00 07/24/2025 Coupon 46647PEU6 65,000.00 JPMORGAN CHASE & CO 4.915 01/24/2029 1,597.38 1,597.38 07/25/2025 Coupon 3137BNGT5 165,437.39 FHMS K-054 A2 2.745 01/25/2026 360.42 360.42 07/25/2025 Principal Paydown 3137BNGT5 165,437.39 FHMS K-054 A2 2.745 01/25/2026 3,523.96 3,523.96 07/25/2025 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42 07/25/2025 Coupon 3137FETN0 160,000.00 FHMS K-073 A2 3.35 01/25/2028 446.67 446.67 07/25/2025 Coupon 3137FHPJ6 110,000.00 FHMS K-080 A2 3.926 07/25/2028 359.88 359.88 07/25/2025 Coupon 3137FJEH8 105,000.00 FHMS K-081 A2 3.9 08/25/2028 341.25 341.25 07/25/2025 Coupon 3137FJKE8 54,000.00 FHMS K-082 A2 3.92 09/25/2028 176.40 176.40 07/25/2025 Coupon 3137FJXV6 100,000.00 FHMS K-083 A2 4.05 09/25/2028 337.50 337.50 07/25/2025 Coupon 3137FKZZ2 110,000.00 FHMS K-088 A2 3.69 01/25/2029 338.25 338.25 07/25/2025 Coupon 3137H4BY5 110,000.00 FHMS K-746 A2 2.031 09/25/2028 186.18 186.18 07/25/2025 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 July 2025 Total 491,561.22 28,799.51 520,360.73
AUGUST 2025
08/01/2025 Coupon 4581X0EM6 215,000.00 INTER-AMERICAN DEVELOPMENT BANK 4.375 02/01/2027 4,703.13 4,703.13
08/01/2025 Coupon 459058KW2 115,000.00 INTERNATIONAL BANK FOR RECONSTRUCTION AND DEVELOPM 4.625 08/01/2028 2,659.38 2,659.38
CONFIDENTIAL | 47
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 08/11/2025 Coupon 037833CJ7 150,000.00 APPLE INC 3.35 02/09/2027 2,512.50 2,512.50 08/11/2025 Coupon 69371RS56 80,000.00 PACCAR FINANCIAL CORP 5.05 08/10/2026 2,020.00 2,020.00 08/15/2025 Coupon 02582JKD1 115,000.00 AMXCA 2023-3 A 5.23 09/15/2028 501.21 501.21 08/15/2025 Coupon 02582JKH2 100,000.00 AMXCA 2024-1 A 5.23 04/16/2029 435.83 435.83 08/15/2025 Coupon 43815BAC4 14,846.64 HAROT 2022-1 A3 1.88 05/15/2026 3.03 3.03 08/15/2025 Effective Maturity 43815BAC4 14,846.64 HAROT 2022-1 A3 1.88 05/15/2026 1,932.98 1,932.98 08/15/2025 Coupon 438516CJ3 125,000.00 HONEYWELL INTERNATIONAL INC 4.95 02/15/2028 3,093.75 3,093.75
08/15/2025 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.13 187.13 08/15/2025 Coupon 448976AD2 50,000.00 HART 2024-C A3 4.41 05/15/2029 183.75 183.75 08/15/2025 Coupon 448979AD6 43,324.91 HART 2023-A A3 4.58 04/15/2027 92.82 92.82 08/15/2025 Principal Paydown 448979AD6 43,324.91 HART 2023-A A3 4.58 04/15/2027 2,945.40 2,945.40 08/15/2025 Coupon 44934QAD3 30,000.00 HART 2024-B A3 4.84 03/15/2029 121.00 121.00 08/15/2025 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 425.36 425.36 08/15/2025 Principal Paydown 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 5,570.08 5,570.08 08/15/2025 Coupon 47787JAC2 11,493.72 JDOT 2022 A3 0.36 09/15/2026 6.45 6.45 08/15/2025 Principal Paydown 47787JAC2 11,493.72 JDOT 2022 A3 0.36 09/15/2026 1,237.76 1,237.76 08/15/2025 Coupon 47800AAC4 25,231.49 JDOT 2022-B A3 3.74 02/16/2027 39.74 39.74 08/15/2025 Principal Paydown 47800AAC4 25,231.49 JDOT 2022-B A3 3.74 02/16/2027 1,228.73 1,228.73 08/15/2025 Coupon 58769GAD5 45,000.00 MBALT 2024-B A3 4.23 02/15/2028 158.63 158.63 08/15/2025 Coupon 58770AAC7 26,438.89 MBART 2023-1 A3 4.51 11/15/2027 63.84 63.84 08/15/2025 Principal Paydown 58770AAC7 26,438.89 MBART 2023-1 A3 4.51 11/15/2027 1,341.66 1,341.66 08/15/2025 Coupon 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 241.50 241.50 08/15/2025 Coupon 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 207.75 207.75 08/15/2025 Coupon 912828K74 150,000.00 UNITED STATES TREASURY 2.0 08/15/2025 1,500.00 1,500.00 08/15/2025 Final Maturity 912828K74 150,000.00 UNITED STATES TREASURY 2.0 08/15/2025 150,000.00 150,000.00 08/18/2025 Coupon 362554AC1 4,355.55 GMCAR 2021-4 A3 0.68 09/16/2026 0.16 0.16 08/18/2025 Effective Maturity 362554AC1 4,355.55 GMCAR 2021-4 A3 0.68 09/16/2026 287.83 287.83 08/18/2025 Coupon 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 99.58 99.58 08/18/2025 Principal Paydown 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 2,052.81 2,052.81 08/18/2025 Coupon 36265WAD5 16,116.38 GMCAR 2022-3 A3 3.64 04/16/2027 22.42 22.42 08/18/2025 Principal Paydown 36265WAD5 16,116.38 GMCAR 2022-3 A3 3.64 04/16/2027 1,359.70 1,359.70
CONFIDENTIAL | 48
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 08/18/2025 Coupon 380146AC4 5,664.88 GMCAR 2022-1 A3 1.26 11/16/2026 0.46 0.46 08/18/2025 Effective Maturity 380146AC4 5,664.88 GMCAR 2022-1 A3 1.26 11/16/2026 436.59 436.59 08/18/2025 Coupon 38014AAD3 35,000.00 GMCAR 2024-4 A3 4.4 08/16/2029 128.33 128.33 08/18/2025 Coupon 43815PAC3 16,159.60 HAROT 2022-2 A3 3.73 07/20/2026 18.29 18.29 08/18/2025 Principal Paydown 43815PAC3 16,159.60 HAROT 2022-2 A3 3.73 07/20/2026 1,504.67 1,504.67 08/20/2025 Coupon 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 266.11 266.11 08/20/2025 Principal Paydown 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 5,014.53 5,014.53 08/20/2025 Coupon 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 19.81 19.81 08/20/2025 Principal Paydown 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 1,093.26 1,093.26 08/20/2025 Coupon 38012QAD0 30,000.00 GMALT 2024-3 A3 4.21 10/20/2027 105.25 105.25 08/21/2025 Coupon 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 165.38 165.38 08/21/2025 Principal Paydown 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 1,259.62 1,259.62 08/21/2025 Coupon 43815JAC7 22,004.23 HAROT 2023-1 A3 5.04 04/21/2027 54.53 54.53 08/21/2025 Principal Paydown 43815JAC7 22,004.23 HAROT 2023-1 A3 5.04 04/21/2027 1,424.32 1,424.32 08/25/2025 Coupon 3137BNGT5 165,437.39 FHMS K-054 A2 2.745 01/25/2026 352.36 352.36 08/25/2025 Principal Paydown 3137BNGT5 165,437.39 FHMS K-054 A2 2.745 01/25/2026 298.99 298.99 08/25/2025 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42 08/25/2025 Coupon 3137FETN0 160,000.00 FHMS K-073 A2 3.35 01/25/2028 446.67 446.67 08/25/2025 Coupon 3137FHPJ6 110,000.00 FHMS K-080 A2 3.926 07/25/2028 359.88 359.88 08/25/2025 Coupon 3137FJEH8 105,000.00 FHMS K-081 A2 3.9 08/25/2028 341.25 341.25 08/25/2025 Coupon 3137FJKE8 54,000.00 FHMS K-082 A2 3.92 09/25/2028 176.40 176.40 08/25/2025 Coupon 3137FJXV6 100,000.00 FHMS K-083 A2 4.05 09/25/2028 337.50 337.50 08/25/2025 Coupon 3137FKZZ2 110,000.00 FHMS K-088 A2 3.69 01/25/2029 338.25 338.25 08/25/2025 Coupon 3137H4BY5 110,000.00 FHMS K-746 A2 2.031 09/25/2028 186.18 186.18 08/25/2025 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 08/26/2025 Coupon 17275RBQ4 60,000.00 CISCO SYSTEMS INC 4.8 02/26/2027 1,440.00 1,440.00 August 2025 Total 178,988.92 24,546.58 203,535.50
SEPTEMBER 2025
09/02/2025 Coupon 91282CLK5 175,000.00 UNITED STATES TREASURY 3.625 08/31/2029 3,171.88 3,171.88 09/09/2025 Coupon 931142EW9 30,000.00 WALMART INC 3.9 09/09/2025 585.00 585.00 09/09/2025 Final Maturity 931142EW9 30,000.00 WALMART INC 3.9 09/09/2025 30,000.00 30,000.00 09/10/2025 Coupon 3130ATS57 275,000.00 FEDERAL HOME LOAN BANKS 4.5 03/10/2028 6,187.50 6,187.50
CONFIDENTIAL | 49
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 09/15/2025 Coupon 02582JKD1 115,000.00 AMXCA 2023-3 A 5.23 09/15/2028 501.21 501.21 09/15/2025 Coupon 02582JKH2 100,000.00 AMXCA 2024-1 A 5.23 04/16/2029 435.83 435.83 09/15/2025 Coupon 437076CR1 40,000.00 HOME DEPOT INC 4.0 09/15/2025 800.00 800.00 09/15/2025 Final Maturity 437076CR1 40,000.00 HOME DEPOT INC 4.0 09/15/2025 40,000.00 40,000.00 09/15/2025 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.13 187.13 09/15/2025 Coupon 448976AD2 50,000.00 HART 2024-C A3 4.41 05/15/2029 183.75 183.75 09/15/2025 Coupon 448979AD6 43,324.91 HART 2023-A A3 4.58 04/15/2027 81.58 81.58 09/15/2025 Principal Paydown 448979AD6 43,324.91 HART 2023-A A3 4.58 04/15/2027 2,885.01 2,885.01 09/15/2025 Coupon 44934QAD3 30,000.00 HART 2024-B A3 4.84 03/15/2029 121.00 121.00 09/15/2025 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 399.92 399.92 09/15/2025 Principal Paydown 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 4,423.32 4,423.32 09/15/2025 Coupon 47787JAC2 11,493.72 JDOT 2022 A3 0.36 09/15/2026 4.06 4.06 09/15/2025 Principal Paydown 47787JAC2 11,493.72 JDOT 2022 A3 0.36 09/15/2026 1,205.56 1,205.56 09/15/2025 Coupon 47800AAC4 25,231.49 JDOT 2022-B A3 3.74 02/16/2027 35.91 35.91 09/15/2025 Principal Paydown 47800AAC4 25,231.49 JDOT 2022-B A3 3.74 02/16/2027 1,279.86 1,279.86 09/15/2025 Coupon 58769GAD5 45,000.00 MBALT 2024-B A3 4.23 02/15/2028 158.63 158.63 09/15/2025 Coupon 58770AAC7 26,438.89 MBART 2023-1 A3 4.51 11/15/2027 58.80 58.80 09/15/2025 Principal Paydown 58770AAC7 26,438.89 MBART 2023-1 A3 4.51 11/15/2027 1,302.29 1,302.29 09/15/2025 Coupon 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 241.50 241.50 09/15/2025 Coupon 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 207.75 207.75 09/15/2025 Principal Paydown 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 210.12 210.12 09/15/2025 Coupon 91282CFK2 150,000.00 UNITED STATES TREASURY 3.5 09/15/2025 2,625.00 2,625.00 09/15/2025 Final Maturity 91282CFK2 150,000.00 UNITED STATES TREASURY 3.5 09/15/2025 150,000.00 150,000.00 09/16/2025 Coupon 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 91.93 91.93 09/16/2025 Principal Paydown 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 2,012.80 2,012.80 09/16/2025 Coupon 36265WAD5 16,116.38 GMCAR 2022-3 A3 3.64 04/16/2027 18.30 18.30 09/16/2025 Principal Paydown 36265WAD5 16,116.38 GMCAR 2022-3 A3 3.64 04/16/2027 1,293.89 1,293.89 09/16/2025 Coupon 38014AAD3 35,000.00 GMCAR 2024-4 A3 4.4 08/16/2029 128.33 128.33 09/16/2025 Coupon 63743HFT4 140,000.00 NATIONAL RURAL UTILITIES COOPERATIVE FINANCE CORP 4.12 09/16/2027 2,884.00 2,884.00
09/17/2025 Coupon 931142ER0 25,000.00 WALMART INC 1.05 09/17/2026 131.25 131.25 09/18/2025 Coupon 43815PAC3 16,159.60 HAROT 2022-2 A3 3.73 07/20/2026 13.61 13.61
CONFIDENTIAL | 50
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 09/18/2025 Principal Paydown 43815PAC3 16,159.60 HAROT 2022-2 A3 3.73 07/20/2026 1,466.77 1,466.77 09/18/2025 Coupon 857477CL5 125,000.00 STATE STREET CORP 4.993 03/18/2027 3,120.63 3,120.63 09/22/2025 Coupon 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 244.84 244.84 09/22/2025 Principal Paydown 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 7,602.48 7,602.48 09/22/2025 Coupon 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 14.90 14.90 09/22/2025 Principal Paydown 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 1,258.66 1,258.66 09/22/2025 Coupon 38012QAD0 30,000.00 GMALT 2024-3 A3 4.21 10/20/2027 105.25 105.25 09/22/2025 Coupon 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 159.42 159.42 09/22/2025 Principal Paydown 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 2,041.58 2,041.58 09/22/2025 Coupon 43815JAC7 22,004.23 HAROT 2023-1 A3 5.04 04/21/2027 48.55 48.55 09/22/2025 Principal Paydown 43815JAC7 22,004.23 HAROT 2023-1 A3 5.04 04/21/2027 1,390.22 1,390.22 09/25/2025 Coupon 3137BNGT5 165,437.39 FHMS K-054 A2 2.745 01/25/2026 351.68 351.68 09/25/2025 Principal Paydown 3137BNGT5 165,437.39 FHMS K-054 A2 2.745 01/25/2026 299.47 299.47 09/25/2025 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42 09/25/2025 Coupon 3137FETN0 160,000.00 FHMS K-073 A2 3.35 01/25/2028 446.67 446.67 09/25/2025 Coupon 3137FHPJ6 110,000.00 FHMS K-080 A2 3.926 07/25/2028 359.88 359.88 09/25/2025 Coupon 3137FJEH8 105,000.00 FHMS K-081 A2 3.9 08/25/2028 341.25 341.25 09/25/2025 Coupon 3137FJKE8 54,000.00 FHMS K-082 A2 3.92 09/25/2028 176.40 176.40 09/25/2025 Coupon 3137FJXV6 100,000.00 FHMS K-083 A2 4.05 09/25/2028 337.50 337.50 09/25/2025 Coupon 3137FKZZ2 110,000.00 FHMS K-088 A2 3.69 01/25/2029 338.25 338.25 09/25/2025 Coupon 3137H4BY5 110,000.00 FHMS K-746 A2 2.031 09/25/2028 186.18 186.18 09/25/2025 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 09/26/2025 Coupon 69371RT48 70,000.00 PACCAR FINANCIAL CORP 4.0 09/26/2029 1,400.00 1,400.00 09/30/2025 Coupon 9128286L9 275,000.00 UNITED STATES TREASURY 2.25 03/31/2026 3,093.75 3,093.75 09/30/2025 Coupon 912828YG9 200,000.00 UNITED STATES TREASURY 1.625 09/30/2026 1,625.00 1,625.00 09/30/2025 Coupon 91282CEF4 200,000.00 UNITED STATES TREASURY 2.5 03/31/2027 2,500.00 2,500.00 09/30/2025 Coupon 91282CFM8 260,000.00 UNITED STATES TREASURY 4.125 09/30/2027 5,362.50 5,362.50 09/30/2025 Coupon 91282CGT2 240,000.00 UNITED STATES TREASURY 3.625 03/31/2028 4,350.00 4,350.00 September 2025
Total 248,672.03 44,347.50 293,019.53
OCTOBER 2025
10/01/2025 Coupon 13063D7D4 100,000.00 CALIFORNIA STATE 5.5 10/01/2028 2,750.00 2,750.00
CONFIDENTIAL | 51
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 10/09/2025 Coupon 3130B3A29 200,000.00 FEDERAL HOME LOAN BANKS 4.0 10/09/2026 4,000.00 4,000.00 10/14/2025 Coupon 79466LAF1 140,000.00 SALESFORCE INC 3.7 04/11/2028 2,590.00 2,590.00 10/15/2025 Coupon 02582JKD1 115,000.00 AMXCA 2023-3 A 5.23 09/15/2028 501.21 501.21 10/15/2025 Coupon 02582JKH2 100,000.00 AMXCA 2024-1 A 5.23 04/16/2029 435.83 435.83 10/15/2025 Coupon 20030NCS8 140,000.00 COMCAST CORP 3.95 10/15/2025 2,765.00 2,765.00 10/15/2025 Final Maturity 20030NCS8 140,000.00 COMCAST CORP 3.95 10/15/2025 140,000.00 140,000.00 10/15/2025 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.13 187.13 10/15/2025 Coupon 448976AD2 50,000.00 HART 2024-C A3 4.41 05/15/2029 183.75 183.75 10/15/2025 Coupon 448979AD6 43,324.91 HART 2023-A A3 4.58 04/15/2027 70.57 70.57 10/15/2025 Principal Paydown 448979AD6 43,324.91 HART 2023-A A3 4.58 04/15/2027 2,779.29 2,779.29 10/15/2025 Coupon 44934QAD3 30,000.00 HART 2024-B A3 4.84 03/15/2029 121.00 121.00 10/15/2025 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 379.72 379.72 10/15/2025 Principal Paydown 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 5,169.12 5,169.12 10/15/2025 Coupon 47787JAC2 11,493.72 JDOT 2022 A3 0.36 09/15/2026 1.73 1.73 10/15/2025 Effective Maturity 47787JAC2 11,493.72 JDOT 2022 A3 0.36 09/15/2026 892.66 892.66 10/15/2025 Coupon 47800AAC4 25,231.49 JDOT 2022-B A3 3.74 02/16/2027 31.93 31.93 10/15/2025 Principal Paydown 47800AAC4 25,231.49 JDOT 2022-B A3 3.74 02/16/2027 1,498.10 1,498.10 10/15/2025 Coupon 58769GAD5 45,000.00 MBALT 2024-B A3 4.23 02/15/2028 158.63 158.63 10/15/2025 Coupon 58770AAC7 26,438.89 MBART 2023-1 A3 4.51 11/15/2027 53.90 53.90 10/15/2025 Principal Paydown 58770AAC7 26,438.89 MBART 2023-1 A3 4.51 11/15/2027 1,252.55 1,252.55 10/15/2025 Coupon 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 241.50 241.50 10/15/2025 Principal Paydown 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 2,732.53 2,732.53 10/15/2025 Coupon 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 206.78 206.78 10/15/2025 Principal Paydown 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 2,430.02 2,430.02 10/16/2025 Coupon 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 84.43 84.43 10/16/2025 Principal Paydown 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 1,931.38 1,931.38 10/16/2025 Coupon 36265WAD5 16,116.38 GMCAR 2022-3 A3 3.64 04/16/2027 14.37 14.37 10/16/2025 Principal Paydown 36265WAD5 16,116.38 GMCAR 2022-3 A3 3.64 04/16/2027 1,206.25 1,206.25 10/16/2025 Coupon 38014AAD3 35,000.00 GMCAR 2024-4 A3 4.4 08/16/2029 128.33 128.33 10/20/2025 Coupon 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 212.59 212.59 10/20/2025 Principal Paydown 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 7,441.22 7,441.22 10/20/2025 Coupon 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 9.26 9.26
CONFIDENTIAL | 52
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 10/20/2025 Principal Paydown 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 1,177.79 1,177.79 10/20/2025 Coupon 38012QAD0 30,000.00 GMALT 2024-3 A3 4.21 10/20/2027 105.25 105.25 10/20/2025 Coupon 43815PAC3 16,159.60 HAROT 2022-2 A3 3.73 07/20/2026 9.05 9.05 10/20/2025 Principal Paydown 43815PAC3 16,159.60 HAROT 2022-2 A3 3.73 07/20/2026 1,413.93 1,413.93 10/21/2025 Coupon 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 149.78 149.78 10/21/2025 Principal Paydown 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 1,960.83 1,960.83 10/21/2025 Coupon 43815JAC7 22,004.23 HAROT 2023-1 A3 5.04 04/21/2027 42.71 42.71 10/21/2025 Principal Paydown 43815JAC7 22,004.23 HAROT 2023-1 A3 5.04 04/21/2027 1,338.65 1,338.65 10/27/2025 Coupon 3137BNGT5 165,437.39 FHMS K-054 A2 2.745 01/25/2026 350.99 350.99 10/27/2025 Principal Paydown 3137BNGT5 165,437.39 FHMS K-054 A2 2.745 01/25/2026 6,115.32 6,115.32 10/27/2025 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42 10/27/2025 Coupon 3137FETN0 160,000.00 FHMS K-073 A2 3.35 01/25/2028 446.67 446.67 10/27/2025 Coupon 3137FHPJ6 110,000.00 FHMS K-080 A2 3.926 07/25/2028 359.88 359.88 10/27/2025 Coupon 3137FJEH8 105,000.00 FHMS K-081 A2 3.9 08/25/2028 341.25 341.25 10/27/2025 Coupon 3137FJKE8 54,000.00 FHMS K-082 A2 3.92 09/25/2028 176.40 176.40 10/27/2025 Coupon 3137FJXV6 100,000.00 FHMS K-083 A2 4.05 09/25/2028 337.50 337.50 10/27/2025 Coupon 3137FKZZ2 110,000.00 FHMS K-088 A2 3.69 01/25/2029 338.25 338.25 10/27/2025 Coupon 3137H4BY5 110,000.00 FHMS K-746 A2 2.031 09/25/2028 186.18 186.18 10/27/2025 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 10/30/2025 Coupon 09247XAP6 150,000.00 BLACKROCK FINANCE INC 3.25 04/30/2029 2,437.50 2,437.50 October 2025
Total 179,339.63 20,940.06 200,279.70
NOVEMBER 2025
11/03/2025 Coupon 00440EAV9 135,000.00 CHUBB INA HOLDINGS LLC 3.35 05/03/2026 2,261.25 2,261.25 11/06/2025 Coupon 3133ERDS7 225,000.00 FEDERAL FARM CREDIT BANKS FUNDING CORP
4.75 05/06/2027 5,343.75 5,343.75
11/07/2025 Coupon 3135G06G3 225,000.00 FEDERAL NATIONAL MORTGAGE ASSOCIATION
0.5 11/07/2025 562.50 562.50
11/07/2025 Final Maturity 3135G06G3 225,000.00 FEDERAL NATIONAL MORTGAGE ASSOCIATION
0.5 11/07/2025 225,000.00 225,000.00
11/10/2025 Coupon 665859AW4 150,000.00 NORTHERN TRUST CORP 4.0 05/10/2027 3,000.00 3,000.00 11/14/2025 Coupon 14913UAL4 140,000.00 CATERPILLAR FINANCIAL SERVICES CORP 5.0 05/14/2027 3,500.00 3,500.00
CONFIDENTIAL | 53
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 11/17/2025 Coupon 02582JKD1 115,000.00 AMXCA 2023-3 A 5.23 09/15/2028 501.21 501.21 11/17/2025 Coupon 02582JKH2 100,000.00 AMXCA 2024-1 A 5.23 04/16/2029 435.83 435.83 11/17/2025 Coupon 3130AXU63 160,000.00 FEDERAL HOME LOAN BANKS 4.625 11/17/2026 3,700.00 3,700.00
11/17/2025 Coupon 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 77.24 77.24 11/17/2025 Principal Paydown 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 1,639.84 1,639.84 11/17/2025 Coupon 36265WAD5 16,116.38 GMCAR 2022-3 A3 3.64 04/16/2027 10.71 10.71 11/17/2025 Principal Paydown 36265WAD5 16,116.38 GMCAR 2022-3 A3 3.64 04/16/2027 1,178.06 1,178.06 11/17/2025 Coupon 38014AAD3 35,000.00 GMCAR 2024-4 A3 4.4 08/16/2029 128.33 128.33 11/17/2025 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.13 187.13 11/17/2025 Coupon 448976AD2 50,000.00 HART 2024-C A3 4.41 05/15/2029 183.75 183.75 11/17/2025 Coupon 448979AD6 43,324.91 HART 2023-A A3 4.58 04/15/2027 59.96 59.96 11/17/2025 Principal Paydown 448979AD6 43,324.91 HART 2023-A A3 4.58 04/15/2027 2,649.81 2,649.81 11/17/2025 Coupon 44934QAD3 30,000.00 HART 2024-B A3 4.84 03/15/2029 121.00 121.00 11/17/2025 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 356.12 356.12 11/17/2025 Principal Paydown 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 5,538.95 5,538.95 11/17/2025 Coupon 47800AAC4 25,231.49 JDOT 2022-B A3 3.74 02/16/2027 27.26 27.26 11/17/2025 Principal Paydown 47800AAC4 25,231.49 JDOT 2022-B A3 3.74 02/16/2027 1,595.34 1,595.34 11/17/2025 Coupon 58769GAD5 45,000.00 MBALT 2024-B A3 4.23 02/15/2028 158.63 158.63 11/17/2025 Coupon 58770AAC7 26,438.89 MBART 2023-1 A3 4.51 11/15/2027 49.20 49.20 11/17/2025 Principal Paydown 58770AAC7 26,438.89 MBART 2023-1 A3 4.51 11/15/2027 1,225.36 1,225.36 11/17/2025 Coupon 58933YBH7 30,000.00 MERCK & CO INC 4.05 05/17/2028 607.50 607.50 11/17/2025 Coupon 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 230.50 230.50 11/17/2025 Principal Paydown 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 3,153.71 3,153.71 11/17/2025 Coupon 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 195.56 195.56 11/17/2025 Principal Paydown 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 2,374.98 2,374.98 11/17/2025 Coupon 912828R36 265,000.00 UNITED STATES TREASURY 1.625 05/15/2026 2,153.13 2,153.13 11/17/2025 Coupon 912828U24 265,000.00 UNITED STATES TREASURY 2.0 11/15/2026 2,650.00 2,650.00 11/17/2025 Coupon 912828X88 275,000.00 UNITED STATES TREASURY 2.375 05/15/2027 3,265.63 3,265.63 11/18/2025 Coupon 43815PAC3 16,159.60 HAROT 2022-2 A3 3.73 07/20/2026 4.66 4.66 11/18/2025 Principal Paydown 43815PAC3 16,159.60 HAROT 2022-2 A3 3.73 07/20/2026 1,376.36 1,376.36
CONFIDENTIAL | 54
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 11/20/2025 Coupon 3133ERFJ5 115,000.00 FEDERAL FARM CREDIT BANKS FUNDING CORP
4.5 05/20/2027 2,587.50 2,587.50
11/20/2025 Coupon 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 181.03 181.03 11/20/2025 Principal Paydown 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 6,933.32 6,933.32 11/20/2025 Coupon 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 3.98 3.98 11/20/2025 Effective Maturity 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 887.79 887.79 11/20/2025 Coupon 38012QAD0 30,000.00 GMALT 2024-3 A3 4.21 10/20/2027 105.25 105.25 11/21/2025 Coupon 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 140.51 140.51 11/21/2025 Principal Paydown 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 1,913.76 1,913.76 11/21/2025 Coupon 43815JAC7 22,004.23 HAROT 2023-1 A3 5.04 04/21/2027 37.09 37.09 11/21/2025 Principal Paydown 43815JAC7 22,004.23 HAROT 2023-1 A3 5.04 04/21/2027 1,176.52 1,176.52 11/25/2025 Coupon 3137BNGT5 165,437.39 FHMS K-054 A2 2.745 01/25/2026 337.00 337.00 11/25/2025 Principal Paydown 3137BNGT5 165,437.39 FHMS K-054 A2 2.745 01/25/2026 6,364.14 6,364.14 11/25/2025 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42 11/25/2025 Coupon 3137FETN0 160,000.00 FHMS K-073 A2 3.35 01/25/2028 446.67 446.67 11/25/2025 Coupon 3137FHPJ6 110,000.00 FHMS K-080 A2 3.926 07/25/2028 359.88 359.88 11/25/2025 Coupon 3137FJEH8 105,000.00 FHMS K-081 A2 3.9 08/25/2028 341.25 341.25 11/25/2025 Coupon 3137FJKE8 54,000.00 FHMS K-082 A2 3.92 09/25/2028 176.40 176.40 11/25/2025 Coupon 3137FJXV6 100,000.00 FHMS K-083 A2 4.05 09/25/2028 337.50 337.50 11/25/2025 Coupon 3137FKZZ2 110,000.00 FHMS K-088 A2 3.69 01/25/2029 338.25 338.25 11/25/2025 Coupon 3137H4BY5 110,000.00 FHMS K-746 A2 2.031 09/25/2028 186.18 186.18 11/25/2025 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 November 2025
Total 263,007.92 35,880.31 298,888.23
DECEMBER 2025
12/01/2025 Coupon 26444HAH4 150,000.00 DUKE ENERGY FLORIDA LLC 2.5 12/01/2029 1,875.00 1,875.00 12/01/2025 Coupon 91282CAZ4 175,000.00 UNITED STATES TREASURY 0.375 11/30/2025 328.13 328.13 12/01/2025 Final Maturity 91282CAZ4 175,000.00 UNITED STATES TREASURY 0.375 11/30/2025 175,000.00 175,000.00 12/11/2025 Coupon 89115A2V3 55,000.00 TORONTO-DOMINION BANK 5.264 12/11/2026 1,447.60 1,447.60 12/15/2025 Coupon 02582JKD1 115,000.00 AMXCA 2023-3 A 5.23 09/15/2028 501.21 501.21 12/15/2025 Coupon 02582JKH2 100,000.00 AMXCA 2024-1 A 5.23 04/16/2029 435.83 435.83
CONFIDENTIAL | 55
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 12/15/2025 Coupon 3133EPN50 110,000.00 FEDERAL FARM CREDIT BANKS FUNDING CORP
4.25 12/15/2028 2,337.50 2,337.50
12/15/2025 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.13 187.13 12/15/2025 Coupon 448976AD2 50,000.00 HART 2024-C A3 4.41 05/15/2029 183.75 183.75 12/15/2025 Coupon 448979AD6 43,324.91 HART 2023-A A3 4.58 04/15/2027 49.84 49.84 12/15/2025 Principal Paydown 448979AD6 43,324.91 HART 2023-A A3 4.58 04/15/2027 2,393.82 2,393.82 12/15/2025 Coupon 44934QAD3 30,000.00 HART 2024-B A3 4.84 03/15/2029 121.00 121.00 12/15/2025 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 330.82 330.82 12/15/2025 Principal Paydown 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 4,114.96 4,114.96 12/15/2025 Coupon 47800AAC4 25,231.49 JDOT 2022-B A3 3.74 02/16/2027 22.28 22.28 12/15/2025 Principal Paydown 47800AAC4 25,231.49 JDOT 2022-B A3 3.74 02/16/2027 1,190.37 1,190.37 12/15/2025 Coupon 58769GAD5 45,000.00 MBALT 2024-B A3 4.23 02/15/2028 158.63 158.63 12/15/2025 Coupon 58770AAC7 26,438.89 MBART 2023-1 A3 4.51 11/15/2027 44.59 44.59 12/15/2025 Principal Paydown 58770AAC7 26,438.89 MBART 2023-1 A3 4.51 11/15/2027 1,166.56 1,166.56 12/15/2025 Coupon 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 217.81 217.81 12/15/2025 Principal Paydown 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 2,973.14 2,973.14 12/15/2025 Coupon 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 184.60 184.60 12/15/2025 Principal Paydown 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 2,241.65 2,241.65 12/15/2025 Coupon 91282CHH7 100,000.00 UNITED STATES TREASURY 4.125 06/15/2026 2,062.50 2,062.50 12/16/2025 Coupon 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 71.13 71.13 12/16/2025 Principal Paydown 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 1,547.81 1,547.81 12/16/2025 Coupon 36265WAD5 16,116.38 GMCAR 2022-3 A3 3.64 04/16/2027 7.14 7.14 12/16/2025 Principal Paydown 36265WAD5 16,116.38 GMCAR 2022-3 A3 3.64 04/16/2027 1,120.11 1,120.11 12/16/2025 Coupon 38014AAD3 35,000.00 GMCAR 2024-4 A3 4.4 08/16/2029 128.33 128.33 12/18/2025 Coupon 43815PAC3 16,159.60 HAROT 2022-2 A3 3.73 07/20/2026 0.38 0.38 12/18/2025 Effective Maturity 43815PAC3 16,159.60 HAROT 2022-2 A3 3.73 07/20/2026 121.77 121.77 12/22/2025 Coupon 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 151.62 151.62 12/22/2025 Principal Paydown 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 6,247.27 6,247.27 12/22/2025 Coupon 38012QAD0 30,000.00 GMALT 2024-3 A3 4.21 10/20/2027 105.25 105.25 12/22/2025 Coupon 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 131.47 131.47 12/22/2025 Principal Paydown 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 1,818.20 1,818.20 12/22/2025 Coupon 43815JAC7 22,004.23 HAROT 2023-1 A3 5.04 04/21/2027 32.15 32.15
CONFIDENTIAL | 56
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 12/22/2025 Principal Paydown 43815JAC7 22,004.23 HAROT 2023-1 A3 5.04 04/21/2027 1,123.32 1,123.32 12/25/2025 Coupon 3137BNGT5 165,437.39 FHMS K-054 A2 2.745 01/25/2026 322.45 322.45 12/25/2025 Principal Paydown 3137BNGT5 165,437.39 FHMS K-054 A2 2.745 01/25/2026 40,186.74 40,186.74 12/25/2025 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42 12/25/2025 Coupon 3137FETN0 160,000.00 FHMS K-073 A2 3.35 01/25/2028 446.67 446.67 12/25/2025 Coupon 3137FHPJ6 110,000.00 FHMS K-080 A2 3.926 07/25/2028 359.88 359.88 12/25/2025 Coupon 3137FJEH8 105,000.00 FHMS K-081 A2 3.9 08/25/2028 341.25 341.25 12/25/2025 Coupon 3137FJKE8 54,000.00 FHMS K-082 A2 3.92 09/25/2028 176.40 176.40 12/25/2025 Coupon 3137FJXV6 100,000.00 FHMS K-083 A2 4.05 09/25/2028 337.50 337.50 12/25/2025 Coupon 3137FKZZ2 110,000.00 FHMS K-088 A2 3.69 01/25/2029 338.25 338.25 12/25/2025 Coupon 3137H4BY5 110,000.00 FHMS K-746 A2 2.031 09/25/2028 186.18 186.18 12/25/2025 Coupon 3137H5YC5 115,000.00 FHMS K-748 A2 2.26 01/25/2029 216.58 216.58 12/26/2025 Coupon 437076DC3 75,000.00 HOME DEPOT INC 4.75 06/25/2029 1,781.25 1,781.25 12/31/2025 Coupon 91282CGC9 300,000.00 UNITED STATES TREASURY 3.875 12/31/2027 5,812.50 5,812.50 12/31/2025 Coupon 91282CHK0 200,000.00 UNITED STATES TREASURY 4.0 06/30/2028 4,000.00 4,000.00 December 2025
Total 241,245.72 25,749.00 266,994.72
Grand Total 47,722,356.86 3,023,215.11 342,719.46 3,365,934.57
CONFIDENTIAL | 57
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
IMPORTANT DISCLOSURES
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 high rating by S&P , Moody’s and Fitch respectively.
CONFIDENTIAL | 58
City of Bell | Account # | As of January 31, 2025
Execution Time: 02/05/2025 12:37:05 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
BENCHMARK INDEX & DISCLOSURES
Benchmark 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.