MONTHLY ACCOUNT STATEMENT
City of Orange | Account #10888 | As of April 30, 2024
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 Orange | Account #10888 | As of April 30, 2024
Execution Time: 05/02/2024 11:31:05 AM 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
Total Rate of Return 1M 3M YTD 1YR 2YRS 3YRS 5YRS 10YRS Since Inception (01/01/22)
City of Orange (0.25%) (0.12%) 0.26% 3.03% 1.71% -- -- -- (0.50%) Benchmark Return* (0.75%) (1.11%) (0.76%) 1.26% 1.07% -- -- -- (0.82%) Average Modified Duration 1.81
Average Coupon 2.32%
Average Purchase YTM 2.34%
Average Market YTM 5.20%
Average Quality AA
Average Final Maturity 2.07
Average Life 2.00
Beg. Values as of
04/01/2024
End Values as of
04/30/2024
Market Value 99,079,244.75 98,760,036.45
Accrued Interest 452,672.67 520,014.17
Total Market Value 99,531,917.43 99,280,050.63
Income Earned 158,792.77 197,073.35
Cont/WD 0.00 0.00
Par 102,154,375.96 102,193,226.56
Book Value 101,938,166.69 102,060,252.26
Cost Value 101,965,872.83 102,140,720.02
Federal Home Loan Banks 19.26%
FNMA 13.31%
FHLMC 13.06%
United States 10.91%
Farm Credit System 8.12%
Toyota Motor Corporation 4.74%
HSBC Holdings plc 3.03%
The Coca-Cola Company 3.00%
*Periods over 1 year are annualized.
Benchmark: ICE BofA 1-5 Year Unsubordinated US Treasury & Agency Index Secondary Benchmark:
*See Footnote
The credit quality is a weighted average calculation of the highest of S&P , Moody’s’ and Fitch CONFIDENTIAL | 3
City of Orange | Account #10888 | As of April 30, 2024
Execution Time: 05/02/2024 11:31:05 AM 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/2023)
Beginning Book Value 101,938,166.69 100,852,347.86
Maturities/Calls (1,250,000.00) (11,190,000.00)
Principal Paydowns 0.00 0.00
Purchases 8,366,878.16 33,958,847.19
Sales (4,294,536.16) (23,219,812.06)
Change in Cash, Payables, Receivables (2,705,482.31) 1,728,737.02 Amortization/Accretion 5,225.87 62,928.07
Realized Gain (Loss) 0.00 (132,795.81)
Ending Book Value 102,060,252.26 102,060,252.26
Month to Date Fiscal Year to Date
(07/01/2023)
Beginning Market Value 99,079,244.75 95,651,766.03
Maturities/Calls (1,250,000.00) (11,190,000.00)
Principal Paydowns 0.00 0.00
Purchases 8,366,878.16 33,958,847.19
Sales (4,294,536.16) (23,219,812.06)
Change in Cash, Payables, Receivables (2,705,482.31) 1,728,737.02 Amortization/Accretion 5,225.87 62,928.07
Change in Net Unrealized Gain (Loss) (441,293.87) 1,900,366.02 Realized Gain (Loss) 0.00 (132,795.81)
Ending Market Value 98,760,036.45 98,760,036.45
Maturities / Calls
Month to Date (1,250,000.00)
Fiscal Year to Date (11,190,000.00)
Principal Paydowns
Month to Date 0.00
Fiscal Year to Date 0.00
Purchases
Month to Date 8,366,878.16
Fiscal Year to Date 33,958,847.19
Sales
Month to Date (4,294,536.16)
Fiscal Year to Date (23,219,812.06)
Interest Received
Month to Date 148,304.06
Fiscal Year to Date 1,409,473.88
Purchased / Sold Interest
Month to Date (23,798.08)
Fiscal Year to Date (74,139.41)
CONFIDENTIAL | 4
City of Orange | Account #10888 | As of April 30, 2024
Execution Time: 05/02/2024 11:31:05 AM 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 100,000.00 02/07/2023
5.43%
99,997.62
99,998.66
99.75 5.71%
99,753.96
86.00 0.10%
(244.70)
Aaa/AAA
NA
1.57 0.50
43815JAC7 HAROT 2023-1 A3 5.04 04/21/2027 210,000.00 02/16/2023
5.09%
209,960.98
209,972.09
99.45 5.57%
208,838.76
294.00
0.21%
(1,133.33)
Aaa/NA
AAA
2.97 1.17
92348KAA1 VZMT 2021-1 A 0.5 05/20/2027 220,000.00 10/21/2022
5.37%
204,668.75
210,180.57
99.73 0.99%
219,408.84
33.61 0.22%
9,228.27
Aaa/AAA
AAA
3.05 0.55
47800CAC0 JDOT 2023 A3 5.01 11/15/2027 395,000.00 02/22/2023
3.39%
394,928.03
394,945.87
99.28 5.59%
392,137.79
879.53
0.40%
(2,808.08)
Aaa/NA
AAA
3.54 1.37
05592XAD2 BMWOT 2023-A A3 5.47
02/25/2028 190,000.00 07/11/2023
5.47%
189,966.33
189,972.09
99.92 5.59%
189,850.57
173.22
0.19%
(121.53)
NA/AAA
AAA
3.82 1.47
02582JJZ4 AMXCA 2023-1 A 4.87 05/15/2028 350,000.00 06/07/2023
4.87%
349,968.96
349,974.52
99.00 5.45%
346,494.79
757.56
0.35%
(3,479.74)
NA/AAA
AAA
4.04 1.89
438123AC5 HAROT 2023-4 A3 5.67 06/21/2028 330,000.00 11/01/2023
5.74%
329,941.89
329,947.92
100.40
5.53%
331,325.97
519.75
0.34%
1,378.05
Aaa/NA
AAA
4.14 1.89
02582JKD1 AMXCA 2023-3 A 5.23 09/15/2028 1,055,000.00 09/12/2023
5.29%
1,054,952.84
1,054,958.66
99.72 5.42%
1,052,050.85
2,452.29
1.07%
(2,907.81)
NA/AAA
AAA
4.38 2.17
161571HT4 CHAIT 2023-1 A 5.16 09/15/2028 1,060,000.00 09/07/2023
5.17%
1,059,706.17
1,059,743.00
99.34 5.52%
1,052,984.07
2,430.93
1.07%
(6,758.93)
NR/AAA
AAA
4.38 2.17
Total ABS 3,910,000.00 5.07%
3,894,091.57
3,899,693.38
99.56 5.25%
3,892,845.60
7,626.89
3.94%
(6,847.78)
Aaa/AAA
AAA
4.00 1.82
AGENCY
3135GA4S7 FEDERAL NATIONAL MORTGAGE
ASSOCIATION 0.375 05/17/2024 5,000,000.00 11/20/2020
0.37%
5,000,000.00
5,000,000.00
99.78 5.14%
4,988,761.45
8,541.67
5.05%
(11,238.55)
Aaa/AA+
AA+
0.05 0.05
3135GA5Y3 FEDERAL NATIONAL MORTGAGE
ASSOCIATION 0.375 06/14/2024 4,375,000.00 12/14/2020
0.38%
4,375,000.00
4,375,000.00
99.40 5.29%
4,348,861.04
6,243.49
4.40%
(26,138.96)
Aaa/AA+
AA+
0.12 0.12
3134GWVE3 FEDERAL HOME LOAN MORTGAGE
CORP 0.4 09/25/2024 4,575,000.00 11/19/2020
0.41%
4,573,627.50
4,574,856.50
97.99 5.49%
4,483,150.01
1,830.00
4.54%
(91,706.49)
Aaa/AA+
AA+
0.41 0.39
3135GA4W8 FEDERAL NATIONAL MORTGAGE
ASSOCIATION 0.5 02/18/2025 3,950,000.00 11/20/2020
0.50%
3,950,000.00
3,950,000.00
96.29 5.29%
3,803,616.56
4,004.86
3.85%
(146,383.45)
Aaa/AA+
AA+
0.80 0.78
3130ANA42 FEDERAL HOME LOAN BANKS 0.65
04/28/2025 4,000,000.00 07/28/2021
0.65%
4,000,000.00
4,000,000.00
95.56 5.29%
3,822,296.08
6,716.67
3.87%
(177,703.92)
Aaa/AA+
AA+
0.99 0.97
3130AMBG6 FEDERAL HOME LOAN BANKS 0.75
04/29/2025 5,000,000.00 05/04/2021
0.75%
5,000,000.00
5,000,000.00
95.64 5.30%
4,782,037.60
208.33
4.84%
(217,962.40)
Aaa/AA+
AA+
1.00 0.97
CONFIDENTIAL | 5
City of Orange | Account #10888 | As of April 30, 2024
Execution Time: 05/02/2024 11:31:05 AM 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
3134GW3Z7 FEDERAL HOME LOAN MORTGAGE
CORP 0.6 10/28/2025 9,000,000.00 10/28/2020
0.60%
9,000,000.00
9,000,000.00
93.51 5.17%
8,415,858.60
450.00
8.52%
(584,141.40)
Aaa/AA+
AA+
1.50 1.45
3133EPCF0 FEDERAL FARM CREDIT BANKS
FUNDING CORP 4.5 03/02/2026 2,000,000.00 03/27/2023
4.01%
2,026,680.00
2,016,706.17
98.91 5.13%
1,978,161.44
14,750.00
2.00%
(38,544.73)
Aaa/AA+
AA+
1.84 1.73
3133EPQC2 FEDERAL FARM CREDIT BANKS
FUNDING CORP 4.625 07/17/2026 2,000,000.00 07/28/2023
4.66%
1,998,260.00
1,998,702.24
99.00 5.11%
1,979,921.74
26,722.22
2.00%
(18,780.50)
Aaa/AA+
AA+
2.21 2.05
3130ANDF4 FEDERAL HOME LOAN BANKS 0.9
07/29/2026 5,000,000.00 07/29/2021
0.90%
5,010,000.00
5,000,000.00
90.86 5.27%
4,542,993.90
11,500.00
4.60%
(457,006.10)
Aaa/AA+
AA+
2.25 2.17
3133EPDJ1 FEDERAL FARM CREDIT BANKS
FUNDING CORP 4.375 09/15/2027 2,000,000.00 03/27/2023
3.81%
2,045,720.00
2,034,514.12
98.37 4.90%
1,967,327.98
11,180.56
1.99%
(67,186.14)
Aaa/AA+
AA+
3.38 3.08
3130ATS57 FEDERAL HOME LOAN BANKS 4.5
03/10/2028 2,000,000.00 03/27/2023
3.82%
2,060,420.00
2,047,060.13
99.20 4.73%
1,983,920.82
12,750.00
2.01%
(63,139.31)
Aaa/AA+
AA+
3.86 3.48
3130AEB25 FEDERAL HOME LOAN BANKS 3.25
06/09/2028 2,000,000.00 07/24/2023
4.15%
1,921,180.00
1,933,615.95
94.34 4.78%
1,886,898.06
25,638.89
1.91%
(46,717.89)
Aaa/AA+
AA+
4.11 3.73
3130AXQK7 FEDERAL HOME LOAN BANKS 4.75
12/08/2028 2,000,000.00 01/29/2024
4.05%
2,060,660.00
2,057,514.16
99.92 4.77%
1,998,481.38
46,972.22
2.02%
(59,032.78)
Aaa/AA+
AA+
4.61 4.00
3133ERDH1 FEDERAL FARM CREDIT BANKS
FUNDING CORP 4.75 04/30/2029 2,100,000.00 04/29/2024
4.70%
2,104,263.00
2,104,260.67
99.90 4.77%
2,097,832.00
277.08
2.12%
(6,428.66)
Aaa/AA+
AA+
5.00 4.40
Total Agency 55,000,000.00 1.52%
55,125,810.50
55,092,229.93
96.59 5.17%
53,080,118.66
177,785.99
53.75%
(2,012,111.27)
Aaa/AA+
AA+
1.63 1.52
CASH
CCYUSD Receivable 13,178.41 --
0.00%
13,178.41
13,178.41
1.00 0.00%
13,178.41
0.00 0.01%
0.00 Aaa/AAA
AAA
0.00 0.00
Total Cash 13,178.41 0.00%
13,178.41
13,178.41
1.00 0.00%
13,178.41
0.00 0.01%
0.00 Aaa/AAA
AAA
0.00 0.00
CORPORATE
69371RR81 PACCAR FINANCIAL CORP 3.15
06/13/2024 895,000.00 06/06/2022
3.16%
894,794.15
894,987.89
99.77 5.00%
892,973.79
10,807.13
0.90%
(2,014.10)
A1/A+
NA
0.12 0.12
40434CAD7 HSBC USA INC 3.5 06/23/2024 3,000,000.00 12/10/2019
2.19%
3,174,900.00
3,005,594.27
99.64 5.88%
2,989,315.77
36,458.33
3.03%
(16,278.50)
A2/A-
A+
0.15 0.15
191216CL2 COCA-COLA CO 1.75 09/06/2024 3,000,000.00 09/20/2019
1.99%
2,964,750.00
2,997,511.31
98.71 5.50%
2,961,243.18
8,020.83
3.00%
(36,268.13)
A1/A+
WR
0.35 0.34
14913Q3B3 CATERPILLAR FINANCIAL SERVICES
CORP 2.15 11/08/2024 1,250,000.00 05/31/2022
2.86%
1,229,100.00
1,245,514.72
98.26 5.58%
1,228,200.80
12,914.93
1.24%
(17,313.92)
A2/A
A+
0.53 0.50
CONFIDENTIAL | 6
City of Orange | Account #10888 | As of April 30, 2024
Execution Time: 05/02/2024 11:31:05 AM 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
24422EWF2 JOHN DEERE CAPITAL CORP 3.4
06/06/2025 280,000.00 06/01/2022
3.41%
279,935.60
279,976.44
97.87 5.42%
274,036.06
3,834.44
0.28%
(5,940.38)
A1/A
A+
1.10 1.05
06406RBF3 BANK OF NEW YORK MELLON CORP
3.43 06/13/2025 955,000.00 06/08/2022
3.43%
955,000.00
955,000.00
99.67 6.14%
951,838.84
12,556.66
0.96%
(3,161.16)
A1/A
AA-
1.12 0.12
91324PEN8 UNITEDHEALTH GROUP INC 5.15
10/15/2025 775,000.00 12/28/2022
4.56%
786,780.00
781,144.08
99.75 5.33%
773,080.03
1,773.89
0.78%
(8,064.05)
A2/A+
A
1.46 1.38
89236THP3 TOYOTA MOTOR CREDIT CORP 0.8
10/16/2025 5,000,000.00 11/19/2020
0.70%
5,025,000.00
5,007,435.83
93.69 5.34%
4,684,705.15
1,666.67
4.74%
(322,730.68)
A1/A+
A+
1.46 1.42
63743HFF4
NATIONAL RURAL UTILITIES
COOPERATIVE FINANCE CORP 5.45
10/30/2025
495,000.00 10/20/2022
5.50%
494,336.70
494,668.65
99.83 5.57%
494,156.81
74.94 0.50%
(511.85)
A2/A-
A
1.50 1.42
037833EB2 APPLE INC 0.7 02/08/2026 3,000,000.00 02/08/2021
0.70%
2,999,730.00
2,999,904.18
92.45 5.22%
2,773,373.82
4,841.67
2.81%
(226,530.36)
Aaa/AA+
NA
1.78 1.72
713448FQ6 PEPSICO INC 4.55 02/13/2026 195,000.00 02/13/2023
4.57%
194,886.90
194,932.49
98.93 5.18%
192,908.94
1,922.38
0.20%
(2,023.55)
A1/A+
NA
1.79 1.68
907818GE2 UNION PACIFIC CORP 4.75
02/21/2026 470,000.00 02/13/2023
4.77%
469,689.80
469,812.92
99.15 5.24%
466,004.77
4,340.97
0.47%
(3,808.15)
A3/A-
A-
1.81 1.69
46647PBK1 JPMORGAN CHASE & CO 2.083
04/22/2026 1,250,000.00 05/31/2022
3.92%
1,190,825.00
1,228,733.55
96.41 5.91%
1,205,148.25
650.94
1.22%
(23,585.30)
A1/A-
AA-
1.98 0.94
61747YET8 MORGAN STANLEY 4.679
07/17/2026 775,000.00 12/28/2022
5.26%
764,390.25
769,954.46
98.70 5.80%
764,922.73
10,475.76
0.77%
(5,031.73)
A1/A-
A+
2.21 1.15
24422EXD6 JOHN DEERE CAPITAL CORP 5.15
09/08/2026 505,000.00 09/05/2023
5.18%
504,641.45
504,718.66
99.82 5.23%
504,096.25
3,828.88
0.51%
(622.40)
A1/A
A+
2.36 2.18
713448FW3 PEPSICO INC 5.125 11/10/2026 380,000.00 11/08/2023
5.13%
379,897.40
379,913.60
99.97 5.14%
379,897.96
9,250.63
0.38%
(15.64)
A1/A+
NA
2.53 2.29
06368LAQ9 BANK OF MONTREAL 4.7
09/14/2027 1,000,000.00 03/30/2023
4.91%
991,550.00
993,610.60
97.75 5.44%
977,489.98
6,136.11
0.99%
(16,120.62)
A2/A-
AA-
3.38 3.05
78016FZW7 ROYAL BANK OF CANADA 4.9
01/12/2028 1,000,000.00 03/30/2023
4.95%
997,990.00
998,446.50
98.32 5.40%
983,202.10
14,836.11
1.00%
(15,244.40)
A1/A
AA-
3.70 3.29
713448FL7 PEPSICO INC 3.6 02/18/2028 1,500,000.00 03/27/2024
4.49%
1,452,735.00
1,453,865.11
95.16 5.01%
1,427,360.58
10,950.00
1.45%
(26,504.53)
A1/A+
NA
3.80 3.47
69371RS80 PACCAR FINANCIAL CORP 4.6
01/31/2029 1,200,000.00 03/27/2024
4.70%
1,194,684.00
1,194,786.12
97.57 5.18%
1,170,849.66
13,953.33
1.19%
(23,936.46)
A1/A+
NA
4.76 4.16
17275RBR2 CISCO SYSTEMS INC 4.85
02/26/2029 1,250,000.00 02/27/2024
4.84%
1,250,650.00
1,250,627.52
98.75 5.14%
1,234,400.74
10,946.18
1.25%
(16,226.79)
A1/AA-
NA
4.83 4.21
CONFIDENTIAL | 7
City of Orange | Account #10888 | As of April 30, 2024
Execution Time: 05/02/2024 11:31:05 AM 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 Corporate 28,175,000.00 2.87%
28,196,266.25
28,101,138.87
97.07 5.44%
27,329,206.22
180,240.77
27.67%
(771,932.65)
A1/A
A+
1.78 1.54
MONEY MARKET
FUND
31846V203 FIRST AMER:GVT OBLG Y 75,048.15 --
4.93%
75,048.15
75,048.15
1.00 4.93%
75,048.15
0.00 0.08%
0.00 Aaa/
AAAm
AAA
0.00 0.00
Total Money
Market Fund 75,048.15 4.93%
75,048.15
75,048.15
1.00 4.93%
75,048.15
0.00 0.08%
0.00 Aaa/
AAAm
AAA
0.00 0.00
SUPRANATIONAL
4581X0EK0 INTER-AMERICAN DEVELOPMENT
BANK 4.5 05/15/2026 1,720,000.00 06/27/2023
4.53%
1,718,675.60
1,719,056.17
98.80 5.12%
1,699,377.25
35,690.00
1.72%
(19,678.92)
Aaa/AAA
NA
2.04 1.88
459058KT9
INTERNATIONAL BANK FOR
RECONSTRUCTION AND DEVELOPM
3.5 07/12/2028
2,000,000.00 07/24/2023
4.19%
1,938,380.00
1,947,896.60
94.92 4.85%
1,898,312.94
21,194.44
1.92%
(49,583.66)
Aaa/AAA
NA
4.20 3.80
Total
Supranational 3,720,000.00 4.35%
3,657,055.60
3,666,952.78
96.75 4.98%
3,597,690.19
56,884.44
3.64%
(69,262.59)
Aaa/AAA
NA
3.18 2.90
US TREASURY
91282CCZ2 UNITED STATES TREASURY 0.875
09/30/2026 3,000,000.00 09/30/2021
1.01%
2,980,546.88
2,990,603.70
90.82 4.95%
2,724,492.18
2,223.36
2.76%
(266,111.52)
Aaa/AA+
AA+
2.42 2.34
9128284N7 UNITED STATES TREASURY 2.875
05/15/2028 2,000,000.00 07/31/2023
4.23%
1,883,281.25
1,901,622.77
93.05 4.79%
1,860,937.50
26,538.46
1.88%
(40,685.27)
Aaa/AA+
AA+
4.04 3.69
912810FE3 UNITED STATES TREASURY 5.5
08/15/2028 2,100,000.00 04/29/2024
4.59%
2,173,746.09
2,173,699.06
103.02
4.71%
2,163,410.15
24,115.38
2.19%
(10,288.91)
Aaa/AA+
AA+
4.29 3.76
9128285M8 UNITED STATES TREASURY 3.125
11/15/2028 2,000,000.00 12/28/2023
3.86%
1,935,078.13
1,939,593.17
93.40 4.76%
1,867,968.76
28,846.15
1.89%
(71,624.41)
Aaa/AA+
AA+
4.54 4.10
91282CKD2 UNITED STATES TREASURY 4.25
02/28/2029 2,200,000.00 03/27/2024
4.18%
2,206,617.19
2,206,492.06
97.96 4.73%
2,155,140.64
15,752.72
2.18%
(51,351.42)
Aaa/AA+
AA+
4.83 4.28
Total US Treasury 11,300,000.00 3.41%
11,179,269.54
11,212,010.75
95.53 4.80%
10,771,949.23
97,476.08
10.91%
(440,061.52)
Aaa/AA+
AA+
3.93 3.55
CONFIDENTIAL | 8
City of Orange | Account #10888 | As of April 30, 2024
Execution Time: 05/02/2024 11:31:05 AM 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 Portfolio 102,193,226.56 2.34%
102,140,720.02
102,060,252.26
96.65 5.20%
98,760,036.45
520,014.17
100.00%
(3,300,215.81)
Aa2/AA-
AA
2.07 1.81
Total Market
Value + Accrued 99,280,050.63
CONFIDENTIAL | 9
City of Orange | Account #10888 | As of April 30, 2024
Execution Time: 05/02/2024 11:31:05 AM 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 04/01/2024 31846V203 2,717,850.00 FIRST AMER:GVT OBLG Y 1.000 4.94% (2,717,850.00) 0.00 (2,717,850.00) 0.00 Purchase 04/02/2024 31846V203 810.72 FIRST AMER:GVT OBLG Y 1.000 4.94% (810.72) 0.00 (810.72) 0.00 Purchase 04/15/2024 31846V203 4,598.04 FIRST AMER:GVT OBLG Y 1.000 4.91% (4,598.04) 0.00 (4,598.04) 0.00 Purchase 04/15/2024 31846V203 27,583.80 FIRST AMER:GVT OBLG Y 1.000 4.91% (27,583.80) 0.00 (27,583.80) 0.00 Purchase 04/16/2024 31846V203 20,000.00 FIRST AMER:GVT OBLG Y 1.000 4.91% (20,000.00) 0.00 (20,000.00) 0.00 Purchase 04/22/2024 31846V203 1,270,769.67 FIRST AMER:GVT OBLG Y 1.000 4.91% (1,270,769.67) 0.00 (1,270,769.67) 0.00 Purchase 04/22/2024 31846V203 882.00 FIRST AMER:GVT OBLG Y 1.000 4.91% (882.00) 0.00 (882.00) 0.00 Purchase 04/25/2024 31846V203 624.84 FIRST AMER:GVT OBLG Y 1.000 4.92% (624.84) 0.00 (624.84) 0.00 Purchase 04/29/2024 31846V203 45,750.00 FIRST AMER:GVT OBLG Y 1.000 4.92% (45,750.00) 0.00 (45,750.00) 0.00 Purchase 04/30/2024 912810FE3 2,100,000.00 UNITED STATES TREASURY 5.5 08/15/2028 103.512 4.59% (2,173,746.09) (23,798.08) (2,197,544.17) 0.00 Purchase 04/30/2024 3133ERDH1 2,100,000.00
FEDERAL FARM CREDIT
BANKS FUNDING CORP 4.75
04/30/2029
100.203 4.70% (2,104,263.00) 0.00 (2,104,263.00) 0.00
Total Purchase 8,288,869.07 (8,366,878.16) (23,798.08) (8,390,676.24) 0.00 TOTAL ACQUISITIONS 8,288,869.07 (8,366,878.16) (23,798.08) (8,390,676.24) 0.00
DISPOSITIONS
Sale 04/12/2024 31846V203 (6,217.74) FIRST AMER:GVT OBLG Y 1.000 4.91% 6,217.74 0.00 6,217.74 0.00 Sale 04/30/2024 31846V203 (4,288,318.42) FIRST AMER:GVT OBLG Y 1.000 4.93% 4,288,318.42 0.00 4,288,318.42 0.00 Total Sale (4,294,536.16) 4,294,536.16 0.00 4,294,536.16 0.00 TOTAL DISPOSITIONS (4,294,536.16) 4,294,536.16 0.00 4,294,536.16 0.00 OTHER
TRANSACTIONS
Call Redemption 04/22/2024 06051GJR1 (1,250,000.00) BANK OF AMERICA CORP 0.976 04/22/2025 100.000 0.98% 1,250,000.00 0.00 1,250,000.00 0.00 Total Call Redemption (1,250,000.00) 1,250,000.00 0.00 1,250,000.00 0.00 Coupon 04/15/2024 47800CAC0 0.00 JDOT 2023 A3 5.01 11/15/2027 5.07% 1,649.13 0.00 1,649.13 0.00 Coupon 04/15/2024 161571HT4 0.00 CHAIT 2023-1 A 5.16
09/15/2028 5.23% 4,558.00 0.00 4,558.00 0.00
CONFIDENTIAL | 10
City of Orange | Account #10888 | As of April 30, 2024
Execution Time: 05/02/2024 11:31:05 AM 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 04/15/2024 91324PEN8 0.00 UNITEDHEALTH GROUP INC
5.15 10/15/2025 4.56% 19,956.25 0.00 19,956.25 0.00
Coupon 04/15/2024 02582JJZ4 0.00 AMXCA 2023-1 A 4.87
05/15/2028 4.92% 1,420.42 0.00 1,420.42 0.00
Coupon 04/15/2024 02582JKD1 0.00 AMXCA 2023-3 A 5.23
09/15/2028 5.29% 4,598.04 0.00 4,598.04 0.00
Coupon 04/16/2024 89236THP3 0.00 TOYOTA MOTOR CREDIT CORP
0.8 10/16/2025 0.70% 20,000.00 0.00 20,000.00 0.00
Coupon 04/20/2024 92348KAA1 0.00 VZMT 2021-1 A 0.5 05/20/2027 66.89% 91.67 0.00 91.67 0.00 Coupon 04/21/2024 43815JAC7 0.00 HAROT 2023-1 A3 5.04
04/21/2027 5.10% 882.00 0.00 882.00 0.00
Coupon 04/21/2024 438123AC5 0.00 HAROT 2023-4 A3 5.67
06/21/2028 5.75% 1,559.25 0.00 1,559.25 0.00
Coupon 04/22/2024 46647PBK1 0.00 JPMORGAN CHASE & CO 2.083 04/22/2026 3.38% 13,018.75 0.00 13,018.75 0.00
Coupon 04/22/2024 06051GJR1 0.00 BANK OF AMERICA CORP 0.976 04/22/2025 0.98% 6,100.00 0.00 6,100.00 0.00
Coupon 04/25/2024 05593AAC3 0.00 BMWLT 2023-1 A3 5.16
11/25/2025 5.22% 430.00 0.00 430.00 0.00
Coupon 04/25/2024 05592XAD2 0.00 BMWOT 2023-A A3 5.47
02/25/2028 5.54% 866.08 0.00 866.08 0.00
Coupon 04/28/2024 3134GW3Z7 0.00
FEDERAL HOME LOAN
MORTGAGE CORP 0.6
10/28/2025
0.60% 27,000.00 0.00 27,000.00 0.00
Coupon 04/29/2024 3130AMBG6 0.00 FEDERAL HOME LOAN BANKS
0.75 04/29/2025 0.75% 18,750.00 0.00 18,750.00 0.00
Coupon 04/30/2024 63743HFF4 0.00
NATIONAL RURAL UTILITIES
COOPERATIVE FINANCE CORP
5.45 10/30/2025
5.50% 13,488.75 0.00 13,488.75 0.00
Total Coupon 0.00 134,368.34 0.00 134,368.34 0.00
Custody Fee 04/25/2024 CCYUSD (671.24) Cash 0.00% (671.24) 0.00 (671.24) 0.00 Total Custody Fee (671.24) (671.24) 0.00 (671.24) 0.00
Dividend 04/30/2024 31846V203 0.00 FIRST AMER:GVT OBLG Y 4.93% 13,178.41 0.00 13,178.41 0.00 Total Dividend 0.00 13,178.41 0.00 13,178.41 0.00
CONFIDENTIAL | 11
City of Orange | Account #10888 | As of April 30, 2024
Execution Time: 05/02/2024 11:31:05 AM 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
Management Fee 04/12/2024 CCYUSD (6,217.74) Cash 0.00% (6,217.74) 0.00 (6,217.74) 0.00 Total Management Fee (6,217.74) (6,217.74) 0.00 (6,217.74) 0.00
TOTAL OTHER
TRANSACTIONS (1,256,888.98) 1,390,657.77 0.00 1,390,657.77 0.00 CONFIDENTIAL | 12
City of Orange | Account #10888 | As of April 30, 2024
Execution Time: 05/02/2024 11:31:05 AM 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
75,048.15
280,715.24
4,088,869.07
(4,294,536.16)
75,048.15
0.00 810.72
0.00 810.72
0.00 0.00
0.00 810.72
810.72
CCYUSD Receivable
13,178.41
13,935.72
0.00 0.00
13,178.41
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 Total Cash & Equivalents 88,226.56
294,650.96
4,088,869.07
(4,294,536.16)
88,226.56
0.00 810.72
0.00 810.72
0.00 0.00
0.00 810.72 810.72
FIXED INCOME
02582JJZ4 AMXCA 2023-1 A 4.87
05/15/2028
06/07/2023
06/14/2023
350,000.00
349,974.00
0.00 0.00
349,974.52
757.56
1,420.42
757.56
1,420.42
0.52 0.00
0.52 1,420.94
1,420.94
02582JKD1 AMXCA 2023-3 A 5.23
09/15/2028
09/12/2023
09/19/2023
1,055,000.00
1,054,957.88
0.00 0.00
1,054,958.66
2,452.29
4,598.04
2,452.29
4,598.04
0.78 0.00
0.78 4,598.82
4,598.82
037833EB2 APPLE INC 0.7 02/08/2026
02/08/2021
02/08/2021
3,000,000.00
2,999,899.75
0.00 0.00
2,999,904.18
3,091.67
0.00 4,841.67
1,750.00
4.44 0.00
4.44 1,754.44
1,754.44
05592XAD2 BMWOT 2023-A A3 5.47
02/25/2028
07/11/2023
07/18/2023
190,000.00
189,971.49
0.00 0.00
189,972.09
173.22
866.08
173.22
866.08
0.60 0.00
0.60 866.68
866.68
05593AAC3 BMWLT 2023-1 A3 5.16
11/25/2025
02/07/2023
02/15/2023
100,000.00
99,998.58
0.00 0.00
99,998.66
86.00 430.00
86.00 430.00
0.07 0.00
0.07 430.07
430.07
CONFIDENTIAL | 13
City of Orange | Account #10888 | As of April 30, 2024
Execution Time: 05/02/2024 11:31:05 AM 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
06051GJR1 BANK OF AMERICA CORP
0.976 04/22/2025
05/31/2022
06/02/2022
0.00 1,247,962.51
0.00 (1,250,000.00)
0.00 5,388.33
6,100.00
0.00 711.67
2,037.49
0.00 2,037.49
2,749.15
2,749.15
06368LAQ9 BANK OF MONTREAL 4.7
09/14/2027
03/30/2023
03/31/2023
1,000,000.00
993,454.88
0.00 0.00
993,610.60
2,219.44
0.00 6,136.11
3,916.67
155.71
0.00 155.71
4,072.38
4,072.38
06406RBF3 BANK OF NEW YORK MELLON
CORP 3.43 06/13/2025
06/08/2022
06/13/2022
955,000.00
955,000.00
0.00 0.00
955,000.00
9,826.95
0.00 12,556.66
2,729.71
0.00 0.00
0.00 2,729.71
2,729.71
14913Q3B3
CATERPILLAR FINANCIAL
SERVICES CORP 2.15
11/08/2024
05/31/2022
06/02/2022
1,250,000.00
1,244,810.22
0.00 0.00
1,245,514.72
10,675.35
0.00 12,914.93
2,239.58
704.49
0.00 704.49
2,944.08
2,944.08
161571HT4 CHAIT 2023-1 A 5.16
09/15/2028
09/07/2023
09/15/2023
1,060,000.00
1,059,738.17
0.00 0.00
1,059,743.00
2,430.93
4,558.00
2,430.93
4,558.00
4.82 0.00
4.82 4,562.82
4,562.82
17275RBR2 CISCO SYSTEMS INC 4.85
02/26/2029
02/27/2024
02/29/2024
1,250,000.00
1,250,638.40
0.00 0.00
1,250,627.52
5,894.10
0.00 10,946.18
5,052.08
0.00 (10.88)
(10.88)
5,041.21
5,041.21
191216CL2 COCA-COLA CO 1.75
09/06/2024
09/20/2019
09/20/2019
3,000,000.00
2,996,928.02
0.00 0.00
2,997,511.31
3,645.83
0.00 8,020.83
4,375.00
583.29
0.00 583.29
4,958.29
4,958.29
24422EWF2 JOHN DEERE CAPITAL CORP
3.4 06/06/2025
06/01/2022
06/06/2022
280,000.00
279,974.67
0.00 0.00
279,976.44
3,041.11
0.00 3,834.44
793.33
1.76 0.00
1.76 795.10
795.10
24422EXD6 JOHN DEERE CAPITAL CORP
5.15 09/08/2026
09/05/2023
09/08/2023
505,000.00
504,708.84
0.00 0.00
504,718.66
1,661.59
0.00 3,828.88
2,167.29
9.81 0.00
9.81 2,177.11
2,177.11
CONFIDENTIAL | 14
City of Orange | Account #10888 | As of April 30, 2024
Execution Time: 05/02/2024 11:31:05 AM 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
3130AEB25 FEDERAL HOME LOAN BANKS
3.25 06/09/2028
07/24/2023
07/25/2023
2,000,000.00
1,932,288.27
0.00 0.00
1,933,615.95
20,222.22
0.00 25,638.89
5,416.67
1,327.68
0.00 1,327.68
6,744.35
6,744.35
3130AMBG6 FEDERAL HOME LOAN BANKS
0.75 04/29/2025
05/04/2021
05/04/2021
5,000,000.00
5,000,000.00
0.00 0.00
5,000,000.00
15,833.33
18,750.00
208.33
3,125.00
0.00 0.00
0.00 3,125.00
3,125.00
3130ANA42 FEDERAL HOME LOAN BANKS
0.65 04/28/2025
07/28/2021
07/28/2021
4,000,000.00
4,000,000.00
0.00 0.00
4,000,000.00
4,550.00
0.00 6,716.67
2,166.67
0.00 0.00
0.00 2,166.67
2,166.67
3130ANDF4 FEDERAL HOME LOAN BANKS
0.9 07/29/2026
07/29/2021
07/29/2021
5,000,000.00
5,000,000.00
0.00 0.00
5,000,000.00
7,750.00
0.00 11,500.00
3,750.00
0.00 0.00
0.00 3,750.00
3,750.00
3130ATS57 FEDERAL HOME LOAN BANKS
4.5 03/10/2028
03/27/2023
03/28/2023
2,000,000.00
2,048,062.12
0.00 0.00
2,047,060.13
5,250.00
0.00 12,750.00
7,500.00
0.00 (1,001.99)
(1,001.99)
6,498.01
6,498.01
3130AXQK7 FEDERAL HOME LOAN BANKS
4.75 12/08/2028
01/29/2024
01/30/2024
2,000,000.00
2,058,539.98
0.00 0.00
2,057,514.16
39,055.56
0.00 46,972.22
7,916.67
0.00 (1,025.82)
(1,025.82)
6,890.85
6,890.85
3133EPCF0
FEDERAL FARM CREDIT
BANKS FUNDING CORP 4.5
03/02/2026
03/27/2023
03/28/2023
2,000,000.00
2,017,454.21
0.00 0.00
2,016,706.17
7,250.00
0.00 14,750.00
7,500.00
0.00 (748.04)
(748.04)
6,751.96
6,751.96
3133EPDJ1
FEDERAL FARM CREDIT
BANKS FUNDING CORP 4.375
09/15/2027
03/27/2023
03/28/2023
2,000,000.00
2,035,354.56
0.00 0.00
2,034,514.12
3,888.89
0.00 11,180.56
7,291.67
0.00 (840.44)
(840.44)
6,451.23
6,451.23
3133EPQC2
FEDERAL FARM CREDIT
BANKS FUNDING CORP 4.625
07/17/2026
07/28/2023
07/31/2023
2,000,000.00
1,998,653.99
0.00 0.00
1,998,702.24
19,013.89
0.00 26,722.22
7,708.33
48.24 0.00
48.24 7,756.58
7,756.58
CONFIDENTIAL | 15
City of Orange | Account #10888 | As of April 30, 2024
Execution Time: 05/02/2024 11:31:05 AM 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
3133ERDH1
FEDERAL FARM CREDIT
BANKS FUNDING CORP 4.75
04/30/2029
04/29/2024
04/30/2024
2,100,000.00
0.00 2,104,263.00
0.00 2,104,260.67
0.00 0.00
277.08
277.08
0.00 (2.33)
(2.33)
274.75
274.75
3134GW3Z7
FEDERAL HOME LOAN
MORTGAGE CORP 0.6
10/28/2025
10/28/2020
10/28/2020
9,000,000.00
9,000,000.00
0.00 0.00
9,000,000.00
22,950.00
27,000.00
450.00
4,500.00
0.00 0.00
0.00 4,500.00
4,500.00
3134GWVE3
FEDERAL HOME LOAN
MORTGAGE CORP 0.4
09/25/2024
11/19/2020
11/19/2020
4,575,000.00
4,574,827.22
0.00 0.00
4,574,856.50
305.00
0.00 1,830.00
1,525.00
29.29 0.00
29.29 1,554.29
1,554.29
3135GA4S7
FEDERAL NATIONAL
MORTGAGE ASSOCIATION
0.375 05/17/2024
11/20/2020
11/20/2020
5,000,000.00
5,000,000.00
0.00 0.00
5,000,000.00
6,979.17
0.00 8,541.67
1,562.50
0.00 0.00
0.00 1,562.50
1,562.50
3135GA4W8
FEDERAL NATIONAL
MORTGAGE ASSOCIATION 0.5
02/18/2025
11/20/2020
11/20/2020
3,950,000.00
3,950,000.00
0.00 0.00
3,950,000.00
2,359.03
0.00 4,004.86
1,645.83
0.00 0.00
0.00 1,645.83
1,645.83
3135GA5Y3
FEDERAL NATIONAL
MORTGAGE ASSOCIATION
0.375 06/14/2024
12/14/2020
12/14/2020
4,375,000.00
4,375,000.00
0.00 0.00
4,375,000.00
4,876.30
0.00 6,243.49
1,367.19
0.00 0.00
0.00 1,367.19
1,367.19
40434CAD7 HSBC USA INC 3.5
06/23/2024
12/10/2019
12/10/2019
3,000,000.00
3,008,760.83
0.00 0.00
3,005,594.27
27,708.33
0.00 36,458.33
8,750.00
0.00 (3,166.57)
(3,166.57)
5,583.43
5,583.43
438123AC5 HAROT 2023-4 A3 5.67
06/21/2028
11/01/2023
11/08/2023
330,000.00
329,946.88
0.00 0.00
329,947.92
519.75
1,559.25
519.75
1,559.25
1.03 0.00
1.03 1,560.28
1,560.28
43815JAC7 HAROT 2023-1 A3 5.04
04/21/2027
02/16/2023
02/24/2023
210,000.00
209,971.32
0.00 0.00
209,972.09
294.00
882.00
294.00
882.00
0.77 0.00
0.77 882.77
882.77
CONFIDENTIAL | 16
City of Orange | Account #10888 | As of April 30, 2024
Execution Time: 05/02/2024 11:31:05 AM 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
4581X0EK0
INTER-AMERICAN
DEVELOPMENT BANK 4.5
05/15/2026
06/27/2023
07/06/2023
1,720,000.00
1,719,018.12
0.00 0.00
1,719,056.17
29,240.00
0.00 35,690.00
6,450.00
38.06 0.00
38.06 6,488.06
6,488.06
459058KT9
INTERNATIONAL BANK FOR
RECONSTRUCTION AND
DEVELOPM 3.5 07/12/2028
07/24/2023
07/26/2023
2,000,000.00
1,946,876.97
0.00 0.00
1,947,896.60
15,361.11
0.00 21,194.44
5,833.33
1,019.64
0.00 1,019.64
6,852.97
6,852.97
46647PBK1 JPMORGAN CHASE & CO
2.083 04/22/2026
05/31/2022
06/02/2022
1,250,000.00
1,226,941.43
0.00 0.00
1,228,733.55
11,499.90
13,018.75
650.94
2,169.79
1,792.12
0.00 1,792.12
3,961.91
3,961.91
47800CAC0 JDOT 2023 A3 5.01
11/15/2027
02/22/2023
03/02/2023
395,000.00
394,944.61
0.00 0.00
394,945.87
879.53
1,649.13
879.53
1,649.13
1.26 0.00
1.26 1,650.39
1,650.39
61747YET8 MORGAN STANLEY 4.679
07/17/2026
12/28/2022
12/30/2022
775,000.00
769,612.00
0.00 0.00
769,954.46
7,453.91
0.00 10,475.76
3,021.85
342.46
0.00 342.46
3,364.31
3,364.31
63743HFF4
NATIONAL RURAL UTILITIES
COOPERATIVE FINANCE CORP
5.45 10/30/2025
10/20/2022
10/31/2022
495,000.00
494,650.48
0.00 0.00
494,668.65
11,315.56
13,488.75
74.94 2,248.13
18.17 0.00
18.17 2,266.30
2,266.30
69371RR81 PACCAR FINANCIAL CORP
3.15 06/13/2024
06/06/2022
06/13/2022
895,000.00
894,979.44
0.00 0.00
894,987.89
8,457.75
0.00 10,807.13
2,349.38
8.45 0.00
8.45 2,357.82
2,357.82
69371RS80 PACCAR FINANCIAL CORP 4.6
01/31/2029
03/27/2024
03/28/2024
1,200,000.00
1,194,696.01
0.00 0.00
1,194,786.12
9,353.33
0.00 13,953.33
4,600.00
90.10 0.00
90.10 4,690.10
4,690.10
713448FL7 PEPSICO INC 3.6 02/18/2028
03/27/2024
03/28/2024
1,500,000.00
1,452,867.95
0.00 0.00
1,453,865.11
6,450.00
0.00 10,950.00
4,500.00
997.15
0.00 997.15
5,497.15
5,497.15
CONFIDENTIAL | 17
City of Orange | Account #10888 | As of April 30, 2024
Execution Time: 05/02/2024 11:31:05 AM 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
713448FQ6 PEPSICO INC 4.55 02/13/2026
02/13/2023
02/15/2023
195,000.00
194,929.39
0.00 0.00
194,932.49
1,183.00
0.00 1,922.38
739.38
3.10 0.00
3.10 742.48
742.48
713448FW3 PEPSICO INC 5.125
11/10/2026
11/08/2023
11/10/2023
380,000.00
379,910.79
0.00 0.00
379,913.60
7,627.71
0.00 9,250.63
1,622.92
2.81 0.00
2.81 1,625.73
1,625.73
78016FZW7 ROYAL BANK OF CANADA 4.9
01/12/2028
03/30/2023
03/31/2023
1,000,000.00
998,412.01
0.00 0.00
998,446.50
10,752.78
0.00 14,836.11
4,083.33
34.50 0.00
34.50 4,117.83
4,117.83
89236THP3 TOYOTA MOTOR CREDIT
CORP 0.8 10/16/2025
11/19/2020
11/19/2020
5,000,000.00
5,007,854.35
0.00 0.00
5,007,435.83
18,333.33
20,000.00
1,666.67
3,333.33
0.00 (418.53)
(418.53)
2,914.81
2,914.81
907818GE2 UNION PACIFIC CORP 4.75
02/21/2026
02/13/2023
02/21/2023
470,000.00
469,804.43
0.00 0.00
469,812.92
2,480.56
0.00 4,340.97
1,860.42
8.49 0.00
8.49 1,868.91
1,868.91
912810FE3 UNITED STATES TREASURY 5.5
08/15/2028
04/29/2024
04/30/2024
2,100,000.00
0.00 2,173,746.09
0.00 2,173,699.06
0.00 (23,798.08)
24,115.38
317.30
0.00 (47.03)
(47.03)
270.27
270.27
9128284N7 UNITED STATES TREASURY
2.875 05/15/2028
07/31/2023
07/31/2023
2,000,000.00
1,899,621.88
0.00 0.00
1,901,622.77
21,799.45
0.00 26,538.46
4,739.01
2,000.89
0.00 2,000.89
6,739.90
6,739.90
9128285M8 UNITED STATES TREASURY
3.125 11/15/2028
12/28/2023
12/29/2023
2,000,000.00
1,938,500.82
0.00 0.00
1,939,593.17
23,695.05
0.00 28,846.15
5,151.10
1,092.35
0.00 1,092.35
6,243.45
6,243.45
91282CCZ2 UNITED STATES TREASURY
0.875 09/30/2026
09/30/2021
09/30/2021
3,000,000.00
2,990,284.09
0.00 0.00
2,990,603.70
71.72 13,125.00
2,223.36
15,276.64
319.60
0.00 319.60
15,596.24
15,596.24
CONFIDENTIAL | 18
City of Orange | Account #10888 | As of April 30, 2024
Execution Time: 05/02/2024 11:31:05 AM 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
91282CKD2 UNITED STATES TREASURY
4.25 02/28/2029
03/27/2024
03/28/2024
2,200,000.00
2,206,602.47
0.00 0.00
2,206,492.06
8,130.43
0.00 15,752.72
7,622.28
0.00 (110.41)
(110.41)
7,511.87
7,511.87
91324PEN8 UNITEDHEALTH GROUP INC
5.15 10/15/2025
12/28/2022
12/30/2022
775,000.00
781,490.55
0.00 0.00
781,144.08
18,404.10
19,956.25
1,773.89
3,326.04
0.00 (346.47)
(346.47)
2,979.57
2,979.57
92348KAA1 VZMT 2021-1 A 0.5
05/20/2027
10/21/2022
10/25/2022
220,000.00
209,916.13
0.00 0.00
210,180.57
33.61 91.67
33.61 91.67
264.44
0.00 264.44
356.11
356.11
Total Fixed Income 102,105,000.00
98,938,790.73
4,278,009.09
(1,250,000.00)
101,972,025.70
452,672.67
123,695.26
520,014.17
191,036.76
12,944.38
(7,718.50)
5,225.87
196,262.63 196,262.63
TOTAL PORTFOLIO 102,193,226.56
99,233,441.69
8,366,878.16
(5,544,536.16)
102,060,252.26
452,672.67
124,505.98
520,014.17
191,847.48
12,944.38
(7,718.50)
5,225.87
197,073.35 197,073.35
CONFIDENTIAL | 19
City of Orange | Account #10888 | As of April 30, 2024
Execution Time: 05/02/2024 11:31:05 AM 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
MAY 2024
05/01/2024 Dividend 31846V203 0.00 13,178.41 13,178.41
05/08/2024 Coupon 14913Q3B3 1,250,000.00 CATERPILLAR FINANCIAL SERVICES CORP 2.15 11/08/2024 13,437.50 13,437.50
05/10/2024 Coupon 713448FW3 380,000.00 PEPSICO INC 5.125 11/10/2026 9,737.50 9,737.50 05/15/2024 Coupon 02582JJZ4 350,000.00 AMXCA 2023-1 A 4.87 05/15/2028 1,420.42 1,420.42 05/15/2024 Coupon 02582JKD1 1,055,000.00 AMXCA 2023-3 A 5.23 09/15/2028 4,598.04 4,598.04 05/15/2024 Coupon 161571HT4 1,060,000.00 CHAIT 2023-1 A 5.16 09/15/2028 4,558.00 4,558.00 05/15/2024 Coupon 4581X0EK0 1,720,000.00 INTER-AMERICAN DEVELOPMENT BANK 4.5 05/15/2026 38,700.00 38,700.00
05/15/2024 Coupon 47800CAC0 395,000.00 JDOT 2023 A3 5.01 11/15/2027 1,649.13 1,649.13 05/15/2024 Coupon 9128284N7 2,000,000.00 UNITED STATES TREASURY 2.875 05/15/2028 28,750.00 28,750.00 05/15/2024 Coupon 9128285M8 2,000,000.00 UNITED STATES TREASURY 3.125 11/15/2028 31,250.00 31,250.00 05/17/2024 Coupon 3135GA4S7 5,000,000.00 FEDERAL NATIONAL MORTGAGE ASSOCIATION
0.375 05/17/2024 9,375.00 9,375.00
05/17/2024 Final Maturity 3135GA4S7 5,000,000.00 FEDERAL NATIONAL MORTGAGE ASSOCIATION
0.375 05/17/2024 5,000,000.00 5,000,000.00
05/20/2024 Coupon 92348KAA1 220,000.00 VZMT 2021-1 A 0.5 05/20/2027 91.67 91.67 05/20/2024 Effective Maturity 92348KAA1 220,000.00 VZMT 2021-1 A 0.5 05/20/2027 220,000.00 220,000.00 05/21/2024 Coupon 438123AC5 330,000.00 HAROT 2023-4 A3 5.67 06/21/2028 1,559.25 1,559.25 05/21/2024 Coupon 43815JAC7 210,000.00 HAROT 2023-1 A3 5.04 04/21/2027 882.00 882.00 05/27/2024 Coupon 05592XAD2 190,000.00 BMWOT 2023-A A3 5.47 02/25/2028 866.08 866.08 05/27/2024 Coupon 05593AAC3 100,000.00 BMWLT 2023-1 A3 5.16 11/25/2025 430.00 430.00 05/27/2024 Principal Paydown 05593AAC3 100,000.00 BMWLT 2023-1 A3 5.16 11/25/2025 9,457.31 9,457.31 May 2024 Total 5,242,635.72 147,304.58 5,389,940.31
JUNE 2024
06/06/2024 Coupon 24422EWF2 280,000.00 JOHN DEERE CAPITAL CORP 3.4 06/06/2025 4,760.00 4,760.00 06/10/2024 Coupon 3130AEB25 2,000,000.00 FEDERAL HOME LOAN BANKS 3.25 06/09/2028 32,500.00 32,500.00 06/10/2024 Coupon 3130AXQK7 2,000,000.00 FEDERAL HOME LOAN BANKS 4.75 12/08/2028 56,736.11 56,736.11 06/13/2024 Coupon 06406RBF3 955,000.00 BANK OF NEW YORK MELLON CORP 3.43 06/13/2025 16,378.25 16,378.25
06/13/2024 Coupon 69371RR81 895,000.00 PACCAR FINANCIAL CORP 3.15 06/13/2024 14,096.25 14,096.25 06/13/2024 Final Maturity 69371RR81 895,000.00 PACCAR FINANCIAL CORP 3.15 06/13/2024 895,000.00 895,000.00 CONFIDENTIAL | 20
City of Orange | Account #10888 | As of April 30, 2024
Execution Time: 05/02/2024 11:31:05 AM 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/14/2024 Coupon 3135GA5Y3 4,375,000.00 FEDERAL NATIONAL MORTGAGE ASSOCIATION
0.375 06/14/2024 8,203.13 8,203.13
06/14/2024 Final Maturity 3135GA5Y3 4,375,000.00 FEDERAL NATIONAL MORTGAGE ASSOCIATION
0.375 06/14/2024 4,375,000.00 4,375,000.00
06/17/2024 Coupon 02582JJZ4 350,000.00 AMXCA 2023-1 A 4.87 05/15/2028 1,420.42 1,420.42 06/17/2024 Coupon 02582JKD1 1,055,000.00 AMXCA 2023-3 A 5.23 09/15/2028 4,598.04 4,598.04 06/17/2024 Coupon 161571HT4 1,060,000.00 CHAIT 2023-1 A 5.16 09/15/2028 4,558.00 4,558.00 06/17/2024 Coupon 47800CAC0 395,000.00 JDOT 2023 A3 5.01 11/15/2027 1,649.13 1,649.13 06/21/2024 Coupon 438123AC5 330,000.00 HAROT 2023-4 A3 5.67 06/21/2028 1,559.25 1,559.25 06/21/2024 Coupon 43815JAC7 210,000.00 HAROT 2023-1 A3 5.04 04/21/2027 882.00 882.00 06/24/2024 Coupon 40434CAD7 3,000,000.00 HSBC USA INC 3.5 06/23/2024 51,625.00 51,625.00 06/24/2024 Final Maturity 40434CAD7 3,000,000.00 HSBC USA INC 3.5 06/23/2024 3,000,000.00 3,000,000.00 06/25/2024 Coupon 05592XAD2 190,000.00 BMWOT 2023-A A3 5.47 02/25/2028 866.08 866.08 06/25/2024 Coupon 05593AAC3 100,000.00 BMWLT 2023-1 A3 5.16 11/25/2025 389.33 389.33 06/25/2024 Principal Paydown 05593AAC3 100,000.00 BMWLT 2023-1 A3 5.16 11/25/2025 14,768.50 14,768.50 June 2024 Total 8,284,768.50 200,220.99 8,484,989.48
JULY 2024
07/12/2024 Coupon 459058KT9 2,000,000.00 INTERNATIONAL BANK FOR RECONSTRUCTION AND DEVELOPM 3.5 07/12/2028 35,000.00 35,000.00
07/12/2024 Coupon 78016FZW7 1,000,000.00 ROYAL BANK OF CANADA 4.9 01/12/2028 24,500.00 24,500.00 07/15/2024 Coupon 02582JJZ4 350,000.00 AMXCA 2023-1 A 4.87 05/15/2028 1,420.42 1,420.42 07/15/2024 Coupon 02582JKD1 1,055,000.00 AMXCA 2023-3 A 5.23 09/15/2028 4,598.04 4,598.04 07/15/2024 Coupon 161571HT4 1,060,000.00 CHAIT 2023-1 A 5.16 09/15/2028 4,558.00 4,558.00 07/15/2024 Coupon 47800CAC0 395,000.00 JDOT 2023 A3 5.01 11/15/2027 1,649.13 1,649.13 07/17/2024 Coupon 3133EPQC2 2,000,000.00 FEDERAL FARM CREDIT BANKS FUNDING CORP
4.625 07/17/2026 46,250.00 46,250.00
07/17/2024 Coupon 61747YET8 775,000.00 MORGAN STANLEY 4.679 07/17/2026 18,131.13 18,131.13 07/22/2024 Coupon 438123AC5 330,000.00 HAROT 2023-4 A3 5.67 06/21/2028 1,559.25 1,559.25 07/22/2024 Coupon 43815JAC7 210,000.00 HAROT 2023-1 A3 5.04 04/21/2027 882.00 882.00 07/25/2024 Coupon 05592XAD2 190,000.00 BMWOT 2023-A A3 5.47 02/25/2028 866.08 866.08 07/25/2024 Coupon 05593AAC3 100,000.00 BMWLT 2023-1 A3 5.16 11/25/2025 325.83 325.83 07/25/2024 Principal Paydown 05593AAC3 100,000.00 BMWLT 2023-1 A3 5.16 11/25/2025 13,877.16 13,877.16 CONFIDENTIAL | 21
City of Orange | Account #10888 | As of April 30, 2024
Execution Time: 05/02/2024 11:31:05 AM 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/29/2024 Coupon 3130ANA42 4,000,000.00 FEDERAL HOME LOAN BANKS 0.65 04/28/2025 13,000.00 13,000.00 07/29/2024 Coupon 3130ANDF4 5,000,000.00 FEDERAL HOME LOAN BANKS 0.9 07/29/2026 22,500.00 22,500.00 07/31/2024 Coupon 69371RS80 1,200,000.00 PACCAR FINANCIAL CORP 4.6 01/31/2029 27,600.00 27,600.00 July 2024 Total 13,877.16 202,839.87 216,717.03
AUGUST 2024
08/08/2024 Coupon 037833EB2 3,000,000.00 APPLE INC 0.7 02/08/2026 10,500.00 10,500.00 08/13/2024 Coupon 713448FQ6 195,000.00 PEPSICO INC 4.55 02/13/2026 4,436.25 4,436.25 08/15/2024 Coupon 02582JJZ4 350,000.00 AMXCA 2023-1 A 4.87 05/15/2028 1,420.42 1,420.42 08/15/2024 Coupon 02582JKD1 1,055,000.00 AMXCA 2023-3 A 5.23 09/15/2028 4,598.04 4,598.04 08/15/2024 Coupon 161571HT4 1,060,000.00 CHAIT 2023-1 A 5.16 09/15/2028 4,558.00 4,558.00 08/15/2024 Coupon 47800CAC0 395,000.00 JDOT 2023 A3 5.01 11/15/2027 1,649.13 1,649.13 08/15/2024 Coupon 912810FE3 2,100,000.00 UNITED STATES TREASURY 5.5 08/15/2028 57,750.00 57,750.00 08/19/2024 Coupon 3135GA4W8 3,950,000.00 FEDERAL NATIONAL MORTGAGE ASSOCIATION
0.5 02/18/2025 9,875.00 9,875.00
08/19/2024 Coupon 713448FL7 1,500,000.00 PEPSICO INC 3.6 02/18/2028 27,000.00 27,000.00 08/21/2024 Coupon 438123AC5 330,000.00 HAROT 2023-4 A3 5.67 06/21/2028 1,559.25 1,559.25 08/21/2024 Coupon 43815JAC7 210,000.00 HAROT 2023-1 A3 5.04 04/21/2027 882.00 882.00 08/21/2024 Coupon 907818GE2 470,000.00 UNION PACIFIC CORP 4.75 02/21/2026 11,162.50 11,162.50 08/26/2024 Coupon 05592XAD2 190,000.00 BMWOT 2023-A A3 5.47 02/25/2028 866.08 866.08 08/26/2024 Coupon 05593AAC3 100,000.00 BMWLT 2023-1 A3 5.16 11/25/2025 266.16 266.16 08/26/2024 Principal Paydown 05593AAC3 100,000.00 BMWLT 2023-1 A3 5.16 11/25/2025 12,147.82 12,147.82 08/26/2024 Coupon 17275RBR2 1,250,000.00 CISCO SYSTEMS INC 4.85 02/26/2029 30,312.50 30,312.50 August 2024 Total 12,147.82 166,835.32 178,983.15
SEPTEMBER 2024
09/03/2024 Coupon 3133EPCF0 2,000,000.00 FEDERAL FARM CREDIT BANKS FUNDING CORP
4.5 03/02/2026 45,000.00 45,000.00
09/03/2024 Coupon 91282CKD2 2,200,000.00 UNITED STATES TREASURY 4.25 02/28/2029 46,750.00 46,750.00 09/06/2024 Coupon 191216CL2 3,000,000.00 COCA-COLA CO 1.75 09/06/2024 26,250.00 26,250.00 09/06/2024 Final Maturity 191216CL2 3,000,000.00 COCA-COLA CO 1.75 09/06/2024 3,000,000.00 3,000,000.00 09/09/2024 Coupon 24422EXD6 505,000.00 JOHN DEERE CAPITAL CORP 5.15 09/08/2026 13,003.75 13,003.75 09/10/2024 Coupon 3130ATS57 2,000,000.00 FEDERAL HOME LOAN BANKS 4.5 03/10/2028 45,000.00 45,000.00 CONFIDENTIAL | 22
City of Orange | Account #10888 | As of April 30, 2024
Execution Time: 05/02/2024 11:31:05 AM 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/13/2024 Coupon 06406RBF3 955,000.00 BANK OF NEW YORK MELLON CORP 3.43 06/13/2025 14,050.44 14,050.44
09/16/2024 Coupon 02582JJZ4 350,000.00 AMXCA 2023-1 A 4.87 05/15/2028 1,420.42 1,420.42 09/16/2024 Coupon 02582JKD1 1,055,000.00 AMXCA 2023-3 A 5.23 09/15/2028 4,598.04 4,598.04 09/16/2024 Coupon 06368LAQ9 1,000,000.00 BANK OF MONTREAL 4.7 09/14/2027 23,500.00 23,500.00 09/16/2024 Coupon 161571HT4 1,060,000.00 CHAIT 2023-1 A 5.16 09/15/2028 4,558.00 4,558.00 09/16/2024 Coupon 3133EPDJ1 2,000,000.00 FEDERAL FARM CREDIT BANKS FUNDING CORP
4.375 09/15/2027 43,750.00 43,750.00
09/16/2024 Coupon 47800CAC0 395,000.00 JDOT 2023 A3 5.01 11/15/2027 1,649.13 1,649.13 09/23/2024 Coupon 438123AC5 330,000.00 HAROT 2023-4 A3 5.67 06/21/2028 1,559.25 1,559.25 09/23/2024 Coupon 43815JAC7 210,000.00 HAROT 2023-1 A3 5.04 04/21/2027 882.00 882.00 09/25/2024 Coupon 05592XAD2 190,000.00 BMWOT 2023-A A3 5.47 02/25/2028 866.08 866.08 09/25/2024 Coupon 05593AAC3 100,000.00 BMWLT 2023-1 A3 5.16 11/25/2025 213.92 213.92 09/25/2024 Principal Paydown 05593AAC3 100,000.00 BMWLT 2023-1 A3 5.16 11/25/2025 11,130.59 11,130.59 09/25/2024 Coupon 3134GWVE3 4,575,000.00 FEDERAL HOME LOAN MORTGAGE CORP 0.4 09/25/2024 9,150.00 9,150.00
09/25/2024 Final Maturity 3134GWVE3 4,575,000.00 FEDERAL HOME LOAN MORTGAGE CORP 0.4 09/25/2024 4,575,000.00 4,575,000.00
09/30/2024 Coupon 91282CCZ2 3,000,000.00 UNITED STATES TREASURY 0.875 09/30/2026 13,125.00 13,125.00 September 2024 Total 7,586,130.59 295,326.03 7,881,456.62 OCTOBER 2024
10/15/2024 Coupon 02582JJZ4 350,000.00 AMXCA 2023-1 A 4.87 05/15/2028 1,420.42 1,420.42 10/15/2024 Coupon 02582JKD1 1,055,000.00 AMXCA 2023-3 A 5.23 09/15/2028 4,598.04 4,598.04 10/15/2024 Coupon 161571HT4 1,060,000.00 CHAIT 2023-1 A 5.16 09/15/2028 4,558.00 4,558.00 10/15/2024 Coupon 47800CAC0 395,000.00 JDOT 2023 A3 5.01 11/15/2027 1,649.13 1,649.13 10/15/2024 Coupon 91324PEN8 775,000.00 UNITEDHEALTH GROUP INC 5.15 10/15/2025 19,956.25 19,956.25 10/16/2024 Coupon 89236THP3 5,000,000.00 TOYOTA MOTOR CREDIT CORP 0.8 10/16/2025 20,000.00 20,000.00 10/21/2024 Coupon 438123AC5 330,000.00 HAROT 2023-4 A3 5.67 06/21/2028 1,559.25 1,559.25 10/21/2024 Coupon 43815JAC7 210,000.00 HAROT 2023-1 A3 5.04 04/21/2027 882.00 882.00 10/22/2024 Coupon 46647PBK1 1,250,000.00 JPMORGAN CHASE & CO 2.083 04/22/2026 13,018.75 13,018.75 10/25/2024 Coupon 05592XAD2 190,000.00 BMWOT 2023-A A3 5.47 02/25/2028 866.08 866.08 10/25/2024 Coupon 05593AAC3 100,000.00 BMWLT 2023-1 A3 5.16 11/25/2025 166.06 166.06 CONFIDENTIAL | 23
City of Orange | Account #10888 | As of April 30, 2024
Execution Time: 05/02/2024 11:31:05 AM 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/25/2024 Principal Paydown 05593AAC3 100,000.00 BMWLT 2023-1 A3 5.16 11/25/2025 10,482.61 10,482.61 10/28/2024 Coupon 3134GW3Z7 9,000,000.00 FEDERAL HOME LOAN MORTGAGE CORP 0.6 10/28/2025 27,000.00 27,000.00
10/29/2024 Coupon 3130AMBG6 5,000,000.00 FEDERAL HOME LOAN BANKS 0.75 04/29/2025 18,750.00 18,750.00 10/30/2024 Coupon 3133ERDH1 2,100,000.00 FEDERAL FARM CREDIT BANKS FUNDING CORP
4.75 04/30/2029 49,875.00 49,875.00
10/30/2024 Coupon 63743HFF4 495,000.00 NATIONAL RURAL UTILITIES COOPERATIVE FINANCE CORP 5.45 10/30/2025 13,488.75 13,488.75
October 2024 Total 10,482.61 177,787.73 188,270.33
NOVEMBER 2024
11/08/2024 Coupon 14913Q3B3 1,250,000.00 CATERPILLAR FINANCIAL SERVICES CORP 2.15 11/08/2024 13,437.50 13,437.50
11/08/2024 Final Maturity 14913Q3B3 1,250,000.00 CATERPILLAR FINANCIAL SERVICES CORP 2.15 11/08/2024 1,250,000.00 1,250,000.00
11/12/2024 Coupon 713448FW3 380,000.00 PEPSICO INC 5.125 11/10/2026 9,737.50 9,737.50 11/15/2024 Coupon 02582JJZ4 350,000.00 AMXCA 2023-1 A 4.87 05/15/2028 1,420.42 1,420.42 11/15/2024 Coupon 02582JKD1 1,055,000.00 AMXCA 2023-3 A 5.23 09/15/2028 4,598.04 4,598.04 11/15/2024 Coupon 161571HT4 1,060,000.00 CHAIT 2023-1 A 5.16 09/15/2028 4,558.00 4,558.00 11/15/2024 Coupon 4581X0EK0 1,720,000.00 INTER-AMERICAN DEVELOPMENT BANK 4.5 05/15/2026 38,700.00 38,700.00
11/15/2024 Coupon 47800CAC0 395,000.00 JDOT 2023 A3 5.01 11/15/2027 1,649.13 1,649.13 11/15/2024 Coupon 9128284N7 2,000,000.00 UNITED STATES TREASURY 2.875 05/15/2028 28,750.00 28,750.00 11/15/2024 Coupon 9128285M8 2,000,000.00 UNITED STATES TREASURY 3.125 11/15/2028 31,250.00 31,250.00 11/21/2024 Coupon 438123AC5 330,000.00 HAROT 2023-4 A3 5.67 06/21/2028 1,559.25 1,559.25 11/21/2024 Coupon 43815JAC7 210,000.00 HAROT 2023-1 A3 5.04 04/21/2027 882.00 882.00 11/25/2024 Coupon 05592XAD2 190,000.00 BMWOT 2023-A A3 5.47 02/25/2028 866.08 866.08 11/25/2024 Coupon 05593AAC3 100,000.00 BMWLT 2023-1 A3 5.16 11/25/2025 120.98 120.98 11/25/2024 Principal Paydown 05593AAC3 100,000.00 BMWLT 2023-1 A3 5.16 11/25/2025 11,090.43 11,090.43 November 2024 Total 1,261,090.43 137,528.90 1,398,619.33 DECEMBER 2024
12/06/2024 Coupon 24422EWF2 280,000.00 JOHN DEERE CAPITAL CORP 3.4 06/06/2025 4,760.00 4,760.00 12/09/2024 Coupon 3130AEB25 2,000,000.00 FEDERAL HOME LOAN BANKS 3.25 06/09/2028 32,500.00 32,500.00 12/09/2024 Coupon 3130AXQK7 2,000,000.00 FEDERAL HOME LOAN BANKS 4.75 12/08/2028 47,500.00 47,500.00 CONFIDENTIAL | 24
City of Orange | Account #10888 | As of April 30, 2024
Execution Time: 05/02/2024 11:31:05 AM 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/13/2024 Coupon 06406RBF3 955,000.00 BANK OF NEW YORK MELLON CORP 3.43 06/13/2025 14,050.44 14,050.44
12/16/2024 Coupon 02582JJZ4 350,000.00 AMXCA 2023-1 A 4.87 05/15/2028 1,420.42 1,420.42 12/16/2024 Coupon 02582JKD1 1,055,000.00 AMXCA 2023-3 A 5.23 09/15/2028 4,598.04 4,598.04 12/16/2024 Coupon 161571HT4 1,060,000.00 CHAIT 2023-1 A 5.16 09/15/2028 4,558.00 4,558.00 12/16/2024 Coupon 47800CAC0 395,000.00 JDOT 2023 A3 5.01 11/15/2027 1,649.13 1,649.13 12/23/2024 Coupon 438123AC5 330,000.00 HAROT 2023-4 A3 5.67 06/21/2028 1,559.25 1,559.25 12/23/2024 Coupon 43815JAC7 210,000.00 HAROT 2023-1 A3 5.04 04/21/2027 882.00 882.00 12/23/2024 Principal Paydown 43815JAC7 210,000.00 HAROT 2023-1 A3 5.04 04/21/2027 9,704.45 9,704.45 12/25/2024 Coupon 05592XAD2 190,000.00 BMWOT 2023-A A3 5.47 02/25/2028 866.08 866.08 12/25/2024 Coupon 05593AAC3 100,000.00 BMWLT 2023-1 A3 5.16 11/25/2025 73.30 73.30 12/25/2024 Principal Paydown 05593AAC3 100,000.00 BMWLT 2023-1 A3 5.16 11/25/2025 11,423.28 11,423.28 December 2024 Total 21,127.73 114,416.65 135,544.38
JANUARY 2025
01/13/2025 Coupon 459058KT9 2,000,000.00 INTERNATIONAL BANK FOR RECONSTRUCTION AND DEVELOPM 3.5 07/12/2028 35,000.00 35,000.00
01/13/2025 Coupon 78016FZW7 1,000,000.00 ROYAL BANK OF CANADA 4.9 01/12/2028 24,500.00 24,500.00 01/15/2025 Coupon 02582JJZ4 350,000.00 AMXCA 2023-1 A 4.87 05/15/2028 1,420.42 1,420.42 01/15/2025 Coupon 02582JKD1 1,055,000.00 AMXCA 2023-3 A 5.23 09/15/2028 4,598.04 4,598.04 01/15/2025 Coupon 161571HT4 1,060,000.00 CHAIT 2023-1 A 5.16 09/15/2028 4,558.00 4,558.00 01/15/2025 Coupon 47800CAC0 395,000.00 JDOT 2023 A3 5.01 11/15/2027 1,649.13 1,649.13 01/15/2025 Principal Paydown 47800CAC0 395,000.00 JDOT 2023 A3 5.01 11/15/2027 18,614.95 18,614.95 01/17/2025 Coupon 3133EPQC2 2,000,000.00 FEDERAL FARM CREDIT BANKS FUNDING CORP
4.625 07/17/2026 46,250.00 46,250.00
01/17/2025 Coupon 61747YET8 775,000.00 MORGAN STANLEY 4.679 07/17/2026 18,131.13 18,131.13 01/21/2025 Coupon 438123AC5 330,000.00 HAROT 2023-4 A3 5.67 06/21/2028 1,559.25 1,559.25 01/21/2025 Coupon 43815JAC7 210,000.00 HAROT 2023-1 A3 5.04 04/21/2027 841.24 841.24 01/21/2025 Principal Paydown 43815JAC7 210,000.00 HAROT 2023-1 A3 5.04 04/21/2027 13,557.58 13,557.58 01/27/2025 Coupon 05592XAD2 190,000.00 BMWOT 2023-A A3 5.47 02/25/2028 866.08 866.08 01/27/2025 Coupon 05593AAC3 100,000.00 BMWLT 2023-1 A3 5.16 11/25/2025 24.18 24.18 01/27/2025 Effective Maturity 05593AAC3 100,000.00 BMWLT 2023-1 A3 5.16 11/25/2025 5,622.30 5,622.30 01/28/2025 Coupon 3130ANA42 4,000,000.00 FEDERAL HOME LOAN BANKS 0.65 04/28/2025 13,000.00 13,000.00 CONFIDENTIAL | 25
City of Orange | Account #10888 | As of April 30, 2024
Execution Time: 05/02/2024 11:31:05 AM 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
01/29/2025 Coupon 3130ANDF4 5,000,000.00 FEDERAL HOME LOAN BANKS 0.9 07/29/2026 22,500.00 22,500.00 01/31/2025 Coupon 69371RS80 1,200,000.00 PACCAR FINANCIAL CORP 4.6 01/31/2029 27,600.00 27,600.00 January 2025 Total 37,794.82 202,497.46 240,292.28
FEBRUARY 2025
02/10/2025 Coupon 037833EB2 3,000,000.00 APPLE INC 0.7 02/08/2026 10,500.00 10,500.00 02/13/2025 Coupon 713448FQ6 195,000.00 PEPSICO INC 4.55 02/13/2026 4,436.25 4,436.25 02/17/2025 Coupon 161571HT4 1,060,000.00 CHAIT 2023-1 A 5.16 09/15/2028 4,558.00 4,558.00 02/17/2025 Coupon 47800CAC0 395,000.00 JDOT 2023 A3 5.01 11/15/2027 1,571.41 1,571.41 02/17/2025 Principal Paydown 47800CAC0 395,000.00 JDOT 2023 A3 5.01 11/15/2027 19,739.32 19,739.32 02/18/2025 Coupon 02582JJZ4 350,000.00 AMXCA 2023-1 A 4.87 05/15/2028 1,420.42 1,420.42 02/18/2025 Coupon 02582JKD1 1,055,000.00 AMXCA 2023-3 A 5.23 09/15/2028 4,598.04 4,598.04 02/18/2025 Coupon 3135GA4W8 3,950,000.00 FEDERAL NATIONAL MORTGAGE ASSOCIATION
0.5 02/18/2025 9,875.00 9,875.00
02/18/2025 Final Maturity 3135GA4W8 3,950,000.00 FEDERAL NATIONAL MORTGAGE ASSOCIATION
0.5 02/18/2025 3,950,000.00 3,950,000.00
02/18/2025 Coupon 713448FL7 1,500,000.00 PEPSICO INC 3.6 02/18/2028 27,000.00 27,000.00 02/18/2025 Coupon 912810FE3 2,100,000.00 UNITED STATES TREASURY 5.5 08/15/2028 57,750.00 57,750.00 02/21/2025 Coupon 438123AC5 330,000.00 HAROT 2023-4 A3 5.67 06/21/2028 1,559.25 1,559.25 02/21/2025 Coupon 43815JAC7 210,000.00 HAROT 2023-1 A3 5.04 04/21/2027 784.30 784.30 02/21/2025 Principal Paydown 43815JAC7 210,000.00 HAROT 2023-1 A3 5.04 04/21/2027 13,357.20 13,357.20 02/21/2025 Coupon 907818GE2 470,000.00 UNION PACIFIC CORP 4.75 02/21/2026 11,162.50 11,162.50 02/25/2025 Coupon 05592XAD2 190,000.00 BMWOT 2023-A A3 5.47 02/25/2028 866.08 866.08 02/26/2025 Coupon 17275RBR2 1,250,000.00 CISCO SYSTEMS INC 4.85 02/26/2029 30,312.50 30,312.50 02/28/2025 Coupon 91282CKD2 2,200,000.00 UNITED STATES TREASURY 4.25 02/28/2029 46,750.00 46,750.00 February 2025 Total 3,983,096.52 213,143.75 4,196,240.27 MARCH 2025
03/03/2025 Coupon 3133EPCF0 2,000,000.00 FEDERAL FARM CREDIT BANKS FUNDING CORP
4.5 03/02/2026 45,000.00 45,000.00
03/10/2025 Coupon 24422EXD6 505,000.00 JOHN DEERE CAPITAL CORP 5.15 09/08/2026 13,003.75 13,003.75 03/10/2025 Coupon 3130ATS57 2,000,000.00 FEDERAL HOME LOAN BANKS 4.5 03/10/2028 45,000.00 45,000.00 03/13/2025 Coupon 06406RBF3 955,000.00 BANK OF NEW YORK MELLON CORP 3.43 06/13/2025 14,050.44 14,050.44
CONFIDENTIAL | 26
City of Orange | Account #10888 | As of April 30, 2024
Execution Time: 05/02/2024 11:31:05 AM 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/14/2025 Coupon 06368LAQ9 1,000,000.00 BANK OF MONTREAL 4.7 09/14/2027 23,500.00 23,500.00 03/17/2025 Coupon 02582JJZ4 350,000.00 AMXCA 2023-1 A 4.87 05/15/2028 1,420.42 1,420.42 03/17/2025 Coupon 02582JKD1 1,055,000.00 AMXCA 2023-3 A 5.23 09/15/2028 4,598.04 4,598.04 03/17/2025 Coupon 161571HT4 1,060,000.00 CHAIT 2023-1 A 5.16 09/15/2028 4,558.00 4,558.00 03/17/2025 Coupon 3133EPDJ1 2,000,000.00 FEDERAL FARM CREDIT BANKS FUNDING CORP
4.375 09/15/2027 43,750.00 43,750.00
03/17/2025 Coupon 47800CAC0 395,000.00 JDOT 2023 A3 5.01 11/15/2027 1,489.00 1,489.00 03/17/2025 Principal Paydown 47800CAC0 395,000.00 JDOT 2023 A3 5.01 11/15/2027 17,824.94 17,824.94 03/21/2025 Coupon 438123AC5 330,000.00 HAROT 2023-4 A3 5.67 06/21/2028 1,559.25 1,559.25 03/21/2025 Coupon 43815JAC7 210,000.00 HAROT 2023-1 A3 5.04 04/21/2027 728.20 728.20 03/21/2025 Principal Paydown 43815JAC7 210,000.00 HAROT 2023-1 A3 5.04 04/21/2027 12,958.47 12,958.47 03/25/2025 Coupon 05592XAD2 190,000.00 BMWOT 2023-A A3 5.47 02/25/2028 866.08 866.08 03/25/2025 Principal Paydown 05592XAD2 190,000.00 BMWOT 2023-A A3 5.47 02/25/2028 3,367.94 3,367.94 March 2025 Total 34,151.34 199,523.17 233,674.52
Grand Total 220,825,000.00 26,487,303.25 2,057,424.45 28,544,727.70 CONFIDENTIAL | 27
City of Orange | Account #10888 | As of April 30, 2024
Execution Time: 05/02/2024 11:31:05 AM 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 AA+/Aaa/AAA by S&P , Moody’s and Fitch respectively.
CONFIDENTIAL | 28
City of Orange | Account #10888 | As of April 30, 2024
Execution Time: 05/02/2024 11:31:05 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
BENCHMARK INDEX & DISCLOSURES
Benchmark Disclosure
ICE BofA 1-5 Yr US Treasury & Agency
Index
The ICE BofA 1-5 Year US Treasury & Agency Index tracks the performance of US dollar denominated US Treasury and nonsubordinated US agency debt issued in the US domestic market. Qualifying securities must have an investment grade rating (based on an average of Moody’s, S&P and Fitch). Qualifying securities must have at least one year remaining term to final maturity and less than five years remaining term to final maturity, at least 18 months to maturity at time of issuance, a fixed coupon schedule, and a minimum amount outstanding of $1 billion for sovereigns and $250 million for agencies.