MONTHLY ACCOUNT STATEMENT
City of Orange - Account #10888
JANUARY 1, 2023 THROUGH JANUARY 31, 2023
Information contained herein is confidential. We urge you to compare this statement to the one you receive from your qualified custodian. Please see Important Disclosures.
CHANDLER
ASSET MANAGEMENT
chandlerasset.com
Chandler Team:
For questions about your account, please call (800) 317-4747, or contact
[email protected]
Custodian
US Bank
Alexander Bazan
(503) 402-5305
ACCOUNT SUMMARY
Beg. Values
as of
12/31/22
End Values
as of
1/31/23
Market Value
74,651,303
75,379,434
Accrued Interest
157,475
168,298
Total Market Value
74,808,778
75,547,732
Income Earned
60,324
66,330
Cont/WD
-5,505
Par
80,644,384
80,692,830
Book Value
80,560,714
80,610,716
Cost Value
80,641,782
80,690,227
TOP ISSUERS
Federal Home Loan Bank
23.3%
Federal Home Loan Mortgage Corp
22.8%
Federal National Mortgage Assoc
22.3%
Toyota Motor Corp
6.0%
HSBC Holdings PLC
3.9%
Coca Cola Co.
3.8%
Government of United States
3.6%
Apple Inc
3.6%
Total
89.3%
PORTFOLIO CHARACTERISTICS
Average Modified Duration
1.98 Average Coupon
0.96%
Average Purchase YTM
1.02%
Average Market YTM
4.50%
Average S&P/Moody Rating
AA/Aa1
Average Final Maturity
2.10 yrs
Average Life
2.05 yrs
CREDIT QUALITY (S&P)
MATURITY DISTRIBUTION
SECTOR ALLOCATION
Portfolio Summary
As of January 31, 2023
City of Orange
Account #10888
PERFORMANCE REVIEW
Annualized
TOTAL RATE OF RETURN
1M
3M
YTD
1YR
2YRS
3YRS
5YRS
10YRS
12/31/2021
City of Orange
1.00%
2.15%
1.00%
-4.07%
N/A
N/A
N/A
N/A
-4.72%
ICE BofA 1-5 Yr US Treasury & Agency Index
1.04%
2.20%
1.04%
-3.39%
N/A
N/A
N/A
N/A
-3.94%
Execution Time: 2/2/2023 2:21:50 AM
Chandler Asset Management - CONFIDENTIAL
BOOK VALUE RECONCILIATION
BEGINNING BOOK VALUE
$80,560,713.50
Acquisition
+ Security Purchases
$0.00
+ Money Market Fund Purchases
$53,950.67
+ Money Market Contributions
$0.00
+ Security Contributions
$0.00
+ Security Transfers
$0.00
Total Acquisitions
$53,950.67
Dispositions
- Security Sales
$0.00
- Money Market Fund Sales
$0.00
- MMF Withdrawals
$5,505.05
- Security Withdrawals
$0.00
- Security Transfers
$0.00
- Other Dispositions
$0.00
- Maturities
$0.00
- Calls
$0.00
- Principal Paydowns
$0.00
Total Dispositions
$5,505.05
Amortization/Accretion
+/- Net Accretion
$1,556.99
$1,556.99
Gain/Loss on Dispositions
+/- Realized Gain/Loss
$0.00
$0.00
ENDING BOOK VALUE
$80,610,716.11
CASH TRANSACTION SUMMARY
BEGINNING BALANCE
$49,384.18
Acquisition
Contributions
$0.00
Security Sale Proceeds
$0.00
Accrued Interest Received
$0.00
Interest Received
$53,420.61
Dividend Received
$530.06
Principal on Maturities
$0.00
Interest on Maturities
$0.00
Calls/Redemption (Principal)
$0.00
Interest from Calls/Redemption
$0.00
Principal Paydown
$0.00
Total Acquisitions
$53,950.67
Dispositions
Withdrawals
$5,505.05
Security Purchase
$0.00
Accrued Interest Paid
$0.00
Total Dispositions
$5,505.05
ENDING BOOK VALUE
$97,829.80
Reconciliation Summary
As of January 31, 2023
City of Orange
Account #10888
Execution Time: 2/2/2023 2:21:50 AM
Chandler Asset Management - CONFIDENTIAL
Holdings Report
As of January 31, 2023
City of Orange
Account #10888
CUSIP
Security Description
Par Value/Units
Purchase Date
Book Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody/S&P
Fitch
Maturity
Duration
ABS
92348KAA1
Verizon Master Trust
2021-1
A
0.5%
Due
5/20/2027
220,000.00
10/21/2022
4.28%
204,668.75
206,456.49
94.42 3.97%
207,732.78
33.61 0.28%
1,276.29
Aaa / AAA
AAA
4.30 1.64
Total ABS
220,000.00
4.28%
204,668.75
206,456.49
3.97%
207,732.78
33.61 0.28%
1,276.29
Aaa / AAA
AAA
4.30 1.64
AGENCY
3135GABN0
FNMA Callable Note Qtrly
12/29/2021
0.28%
Due
12/29/2023
3,500,000.00
12/29/2020
0.28%
3,500,000.00
3,500,000.00
95.92 4.91%
3,357,266.50
871.11
4.45%
(
142,733.50
)
Aaa / AA+
AAA
0.91 0.89
3130ALLM4
FHLB Callable Note Qtrly
6/28/2021
0.35%
Due
3/28/2024
5,000,000.00
03/29/2021
0.37%
4,997,000.00
4,998,846.58
95.08 4.77%
4,753,840.00
5,979.17
6.30%
(
245,006.58
)
Aaa / AA+
NR
1.16 1.13
3134GWXC5
FHLMC Callable Note Qtrly
9/29/2021
0.35%
Due
3/29/2024
5,000,000.00
12/10/2020
0.35%
5,000,000.00
5,000,000.00
94.97 4.86%
4,748,465.00
5,930.56
6.29%
(
251,535.00
)
Aaa / NR
AAA
1.16 1.13
3135GA4S7
FNMA Callable Note Qtrly
11/17/2022
0.375%
Due
5/17/2024
5,000,000.00
11/20/2020
0.38%
5,000,000.00
5,000,000.00
94.57 4.75%
4,728,590.00
3,854.17
6.26%
(
271,410.00
)
Aaa / AA+
AAA
1.29 1.26
3135GA5Y3
FNMA Callable Note Qtrly
12/14/2021
0.375%
Due
6/14/2024
4,375,000.00
12/14/2020
0.38%
4,375,000.00
4,375,000.00
94.30 4.72%
4,125,646.88
2,141.93
5.46%
(
249,353.12
)
Aaa / AA+
AAA
1.37 1.34
3134GWVE3
FHLMC Callable Note Qtrly
3/25/2021
0.4%
Due
9/25/2024
4,575,000.00
11/19/2020
0.41%
4,573,627.50
4,574,412.34
93.42 4.59%
4,273,868.93
6,405.00
5.67%
(
300,543.41
)
Aaa / NR
AAA
1.65 1.61
3135GA4W8
FNMA Callable Note Qtrly
11/18/2022
0.5%
Due
2/18/2025
5,000,000.00
11/20/2020
0.50%
5,000,000.00
5,000,000.00
92.46 4.39%
4,623,225.00
11,319.44
6.13%
(
376,775.00
)
Aaa / AA+
AAA
2.05 1.99
3130ANA42
FHLB Callable Note Qtrly
1/28/2022
0.65%
Due
4/28/2025
4,000,000.00
07/28/2021
0.65%
4,000,000.00
4,000,000.00
92.30 4.29%
3,691,844.00
216.67
4.89%
(
308,156.00
)
Aaa / AA+
NR
2.24 2.18
3130AMBG6
FHLB Callable Note Qtrly
7/29/2021
0.75%
Due
4/29/2025
5,000,000.00
05/04/2021
0.75%
5,000,000.00
5,000,000.00
92.50 4.29%
4,624,915.00
9,583.33
6.13%
(
375,085.00
)
Aaa / AA+
NR
2.24 2.18
3134GW3Z7
FHLMC Callable Note Qtrly
10/28/2021
0.6%
Due
10/28/2025
9,000,000.00
10/28/2020
0.60%
9,000,000.00
9,000,000.00
90.88 4.15%
8,179,011.00
13,950.00
10.84%
(
820,989.00
)
Aaa / NR
AAA
2.74 2.66
3130ANDF4
FHLB Callable Note Annual
7/29/2022
0.9%
Due
7/29/2026
5,000,000.00
07/29/2021
0.90%
5,010,000.00
5,000,000.00
89.64 4.11%
4,481,975.00
250.00
5.93%
(
518,025.00
)
Aaa / AA+
NR
3.49 3.38
Total Agency
55,450,000.00
0.52%
55,455,627.50
55,448,258.92
4.50%
51,588,647.31
60,501.38
68.37%
(
3,859,611.61
)
Aaa / AA+
AAA
1.92 1.87
Execution Time: 2/2/2023 2:21:50 AM
Chandler Asset Management - CONFIDENTIAL
Holdings Report
As of January 31, 2023
City of Orange
Account #10888
CUSIP
Security Description
Par Value/Units
Purchase Date
Book Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody/S&P
Fitch
Maturity
Duration
CORPORATE
69371RR81
Paccar Financial Corp Note
3.15%
Due
6/13/2024
895,000.00
06/06/2022
3.16%
894,794.15
894,859.76
98.16 4.55%
878,496.20
3,759.00
1.17%
(
16,363.56
)
A
1 / A+
NR
1.37 1.31
40434CAD7
HSBC USA Inc Note
3.5%
Due
6/23/2024
3,000,000.00
12/10/2019
2.14%
3,174,900.00
3,053,620.52
98.12 4.91%
2,943,579.00
11,083.33
3.91%
(
110,041.52
)
A
1 / A-
A+
1.39 1.34
191216CL2
Coca Cola Company Callable Note Cont
8/6/2024
1.75%
Due
9/6/2024
3,000,000.00
09/20/2019
2.00%
2,964,750.00
2,988,664.78
96.12 4.29%
2,883,519.00
21,145.83
3.84%
(
105,145.78
)
A
1 / A+
A
1.60 1.54
14913Q3B3
Caterpillar Finl Service Note
2.15%
Due
11/8/2024
1,250,000.00
05/31/2022
2.87%
1,229,100.00
1,234,829.89
96.12 4.46%
1,201,447.50
6,196.18
1.60%
(
33,382.39
)
A
2 / A
A
1.77 1.70
06051GJR1
Bank of America Corp Callable Note
Cont
4/22/2024
0.976%
Due
4/22/2025
1,250,000.00
05/31/2022
4.07%
1,192,012.50
1,205,423.83
94.76 5.29%
1,184,526.25
3,355.00
1.57%
(
20,897.58
)
A
2 / A-
AA-
2.22 2.13
24422EWF2
John Deere Capital Corp Note
3.4%
Due
6/6/2025
280,000.00
06/01/2022
3.41%
279,935.60
279,949.70
97.61 4.48%
273,316.68
1,454.44
0.36%
(
6,633.02
)
A
2 / A
A
2.35 2.21
06406RBF3
Bank of NY Mellon Corp Callable Note
Cont
6/13/2024
3.43%
Due
6/13/2025
955,000.00
06/08/2022
3.43%
955,000.00
955,000.00
98.30 4.72%
938,745.90
4,367.53
1.25%
(
16,254.10
)
A
1 / A
AA-
2.37 1.31
91324PEN8
United Health Group Inc Note
5.15%
Due
10/15/2025
775,000.00
12/28/2022
4.56%
786,780.00
786,398.88
101.95
4.38%
790,107.85
10,310.73
1.06%
3,708.97
A
3 / A+
A
2.71 2.48
89236THP3
Toyota Motor Credit Corp Note
0.8%
Due
10/16/2025
5,000,000.00
11/19/2020
0.70%
5,025,000.00
5,013,783.48
90.71 4.48%
4,535,280.00
11,666.67
6.02%
(
478,503.48
)
A
1 / A+
A+
2.71 2.62
63743HFF4
National Rural Utilities Note
5.45%
Due
10/30/2025
495,000.00
10/20/2022
5.50%
494,336.70
494,393.04
101.97
4.68%
504,728.24
6,819.31
0.68%
10,335.20
A
2 / A-
A
2.75 2.50
037833EB2
Apple Inc Callable Note Cont
1/8/2026
0.7%
Due
2/8/2026
3,000,000.00
02/08/2021
0.70%
2,999,730.00
2,999,836.91
90.10 4.23%
2,703,039.00
10,091.67
3.59%
(
296,797.91
)
Aaa / AA+
NR
3.02 2.92
46647PBK1
JP Morgan Chase & Co Callable Note
Cont
4/22/2025
2.083%
Due
4/22/2026
1,250,000.00
05/31/2022
4.43%
1,190,825.00
1,200,993.10
93.92 5.00%
1,173,940.00
7,160.31
1.56%
(
27,053.10
)
A
1 / A-
AA-
3.22 2.12
61747YET8
Morgan Stanley Callable Note Cont
7/17/2025
4.679%
Due
7/17/2026
775,000.00
12/28/2022
5.48%
764,390.25
764,660.61
99.16 5.04%
768,522.55
1,410.20
1.02%
3,861.94
A
1 / A-
A+
3.46 2.29
Total Corporate
21,925,000.00
2.26%
21,951,554.20
21,872,414.50
4.59%
20,779,248.17
98,820.20
27.64%
(
1,093,166.33
)
A
1 / A+
A+
2.31 2.08
Execution Time: 2/2/2023 2:21:50 AM
Chandler Asset Management - CONFIDENTIAL
Holdings Report
As of January 31, 2023
City of Orange
Account #10888
CUSIP
Security Description
Par Value/Units
Purchase Date
Book Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody/S&P
Fitch
Maturity
Duration
MONEY MARKET FUND
31846V203
First American Govt Obligation Fund
Class Y
97,829.80
Various
3.83%
97,829.80
97,829.80
1.00 3.83%
97,829.80
0.00 0.13%
0.00 Aaa / AAA
AAA
0.00 0.00
Total Money Market Fund
97,829.80
3.83%
97,829.80
97,829.80
3.83%
97,829.80
0.00 0.13%
0.00 Aaa / AAA
AAA
0.00 0.00
US TREASURY
91282CCZ2
US Treasury Note
0.875%
Due
9/30/2026
3,000,000.00
09/30/2021
1.01%
2,980,546.88
2,985,756.40
90.20 3.76%
2,705,976.00
8,942.31
3.59%
(
279,780.40
)
Aaa / AA+
AAA
3.67 3.53
Total US Treasury
3,000,000.00
1.01%
2,980,546.88
2,985,756.40
3.76%
2,705,976.00
8,942.31
3.59%
(
279,780.40
)
Aaa / AA+
AAA
3.67 3.53
TOTAL PORTFOLIO
80,692,829.80
1.02%
80,690,227.13
80,610,716.11
4.50%
75,379,434.06
168,297.50
100.00%
(
5,231,282.05
)
Aa
1 / AA
AA+
2.10 1.98
TOTAL MARKET VALUE PLUS ACCRUED
75,547,731.56
Execution Time: 2/2/2023 2:21:50 AM
Chandler Asset Management - CONFIDENTIAL
Transaction Ledger
As of January 31, 2023
City of Orange
Account #10888
Transaction
Type
Settlement
Date
CUSIP
Quantity
Security Description
Price
Acq/Disp
Yield
Amount
Interest
Pur/Sold
Total Amount
Gain/Loss
ACQUISITIONS
Purchase
01/03/2023
31846V203
530.06
First American Govt Obligation Fund
Class Y
1.000
3.79%
530.06
0.00 530.06
0.00 Purchase
01/17/2023
31846V203
17,828.94
First American Govt Obligation Fund
Class Y
1.000
3.79%
17,828.94
0.00 17,828.94
0.00 Purchase
01/20/2023
31846V203
91.67 First American Govt Obligation Fund
Class Y
1.000
3.79%
91.67 0.00
91.67 0.00
Purchase
01/28/2023
31846V203
13,000.00
First American Govt Obligation Fund
Class Y
1.000
3.79%
13,000.00
0.00 13,000.00
0.00 Purchase
01/29/2023
31846V203
22,500.00
First American Govt Obligation Fund
Class Y
1.000
3.79%
22,500.00
0.00 22,500.00
0.00 Subtotal
53,950.67
53,950.67
0.00 53,950.67
0.00 TOTAL ACQUISITIONS
53,950.67
53,950.67
0.00 53,950.67
0.00 DISPOSITIONS
Paydown
01/20/2023
92348KAA1
0.00 Verizon Master Trust
2021-1
A
0.5%
Due
5/20/2027
100.000
0.00 91.67
91.67 0.00
Subtotal
0.00 0.00
91.67 91.67
0.00 Security
Withdrawal
01/09/2023
31846V203
4,986.69
First American Govt Obligation Fund
Class Y
1.000
4,986.69
0.00 4,986.69
0.00 Security
Withdrawal
01/25/2023
31846V203
518.36
First American Govt Obligation Fund
Class Y
1.000
518.36
0.00 518.36
0.00 Subtotal
5,505.05
5,505.05
0.00 5,505.05
0.00 TOTAL DISPOSITIONS
5,505.05
5,505.05
91.67 5,596.72
0.00 OTHER TRANSACTIONS
Interest
01/17/2023
61747YET8
775,000.00
Morgan Stanley Callable Note Cont
7/17/2025
4.679%
Due
7/17/2026
0.000
17,828.94
0.00 17,828.94
0.00 Interest
01/28/2023
3130ANA42
4,000,000.00
FHLB Callable Note Qtrly
1/28/2022
0.65%
Due
4/28/2025
0.000
13,000.00
0.00 13,000.00
0.00 Execution Time: 2/2/2023 2:21:50 AM
Chandler Asset Management - CONFIDENTIAL
Transaction Ledger
As of January 31, 2023
City of Orange
Account #10888
Transaction
Type
Settlement
Date
CUSIP
Quantity
Security Description
Price
Acq/Disp
Yield
Amount
Interest
Pur/Sold
Total Amount
Gain/Loss
OTHER TRANSACTIONS
Interest
01/29/2023
3130ANDF4
5,000,000.00
FHLB Callable Note Annual
7/29/2022
0.9%
Due
7/29/2026
0.000
22,500.00
0.00 22,500.00
0.00 Subtotal
9,775,000.00
53,328.94
0.00 53,328.94
0.00 Dividend
01/03/2023
31846V203
49,384.18
First American Govt Obligation Fund
Class Y
0.000
530.06
0.00 530.06
0.00 Subtotal
49,384.18
530.06
0.00 530.06
0.00 TOTAL OTHER TRANSACTIONS
9,824,384.18
53,859.00
0.00 53,859.00
0.00 Execution Time: 2/2/2023 2:21:50 AM
Chandler Asset Management - CONFIDENTIAL
Income Earned
As of January 31, 2023
City of Orange
Account #10888
CUSIP
Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
FIXED INCOME
037833EB2
Apple Inc
Callable Note Cont
1/8/2026
0.7%
Due
02/08/2026
02/08/2021
02/08/2021
3,000,000.00
2,999,832.32
0.00 0.00
2,999,836.91
8,341.67
0.00 10,091.67
1,750.00
4.59 0.00
4.59 1,754.59
1,754.59
06051GJR1
Bank of America Corp
Callable Note Cont
4/22/2024
0.976%
Due
04/22/2025
05/31/2022
06/02/2022
1,250,000.00
1,203,719.93
0.00 0.00
1,205,423.83
2,338.33
0.00 3,355.00
1,016.67
1,703.90
0.00 1,703.90
2,720.57
2,720.57
06406RBF3
Bank of NY Mellon Corp
Callable Note Cont
6/13/2024
3.43%
Due
06/13/2025
06/08/2022
06/13/2022
955,000.00
955,000.00
0.00 0.00
955,000.00
1,637.83
0.00 4,367.53
2,729.70
0.00 0.00
0.00 2,729.70
2,729.70
14913Q3B3
Caterpillar Finl Service
Note
2.15%
Due
11/08/2024
05/31/2022
06/02/2022
1,250,000.00
1,234,101.91
0.00 0.00
1,234,829.89
3,956.60
0.00 6,196.18
2,239.58
727.98
0.00 727.98
2,967.56
2,967.56
191216CL2
Coca Cola Company
Callable Note Cont
8/6/2024
1.75%
Due
09/06/2024
09/20/2019
09/20/2019
3,000,000.00
2,988,062.05
0.00 0.00
2,988,664.78
16,770.83
0.00 21,145.83
4,375.00
602.73
0.00 602.73
4,977.73
4,977.73
24422EWF2
John Deere Capital Corp
Note
3.4%
Due
06/06/2025
06/01/2022
06/06/2022
280,000.00
279,947.88
0.00 0.00
279,949.70
661.11
0.00 1,454.44
793.33
1.82 0.00
1.82 795.15
795.15
3130ALLM4
FHLB
Callable Note Qtrly
6/28/2021
0.35%
Due
03/28/2024
03/29/2021
03/29/2021
5,000,000.00
4,998,761.64
0.00 0.00
4,998,846.58
4,520.83
0.00 5,979.17
1,458.34
84.94 0.00
84.94 1,543.28
1,543.28
3130AMBG6
FHLB
Callable Note Qtrly
7/29/2021
0.75%
Due
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
6,458.33
0.00 9,583.33
3,125.00
0.00 0.00
0.00 3,125.00
3,125.00
3130ANA42
FHLB
Callable Note Qtrly
1/28/2022
0.65%
Due
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
11,050.00
13,000.00
216.67
2,166.67
0.00 0.00
0.00 2,166.67
2,166.67
Execution Time: 2/2/2023 2:21:50 AM
Chandler Asset Management - CONFIDENTIAL
Income Earned
As of January 31, 2023
City of Orange
Account #10888
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
3130ANDF4
FHLB
Callable Note Annual
7/29/2022
0.9%
Due
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
19,000.00
22,500.00
250.00
3,750.00
0.00 0.00
0.00 3,750.00
3,750.00
3134GW3Z7
FHLMC
Callable Note Qtrly
10/28/2021
0.6%
Due
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
9,450.00
0.00 13,950.00
4,500.00
0.00 0.00
0.00 4,500.00
4,500.00
3134GWVE3
FHLMC
Callable Note Qtrly
3/25/2021
0.4%
Due
09/25/2024
11/19/2020
11/19/2020
4,575,000.00
4,574,382.08
0.00 0.00
4,574,412.34
4,880.00
0.00 6,405.00
1,525.00
30.26 0.00
30.26 1,555.26
1,555.26
3134GWXC5
FHLMC
Callable Note Qtrly
9/29/2021
0.35%
Due
03/29/2024
12/10/2020
12/10/2020
5,000,000.00
5,000,000.00
0.00 0.00
5,000,000.00
4,472.22
0.00 5,930.56
1,458.34
0.00 0.00
0.00 1,458.34
1,458.34
3135GA4S7
FNMA
Callable Note Qtrly
11/17/2022
0.375%
Due
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
2,291.67
0.00 3,854.17
1,562.50
0.00 0.00
0.00 1,562.50
1,562.50
3135GA4W8
FNMA
Callable Note Qtrly
11/18/2022
0.5%
Due
02/18/2025
11/20/2020
11/20/2020
5,000,000.00
5,000,000.00
0.00 0.00
5,000,000.00
9,236.11
0.00 11,319.44
2,083.33
0.00 0.00
0.00 2,083.33
2,083.33
3135GA5Y3
FNMA
Callable Note Qtrly
12/14/2021
0.375%
Due
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
774.74
0.00 2,141.93
1,367.19
0.00 0.00
0.00 1,367.19
1,367.19
3135GABN0
FNMA
Callable Note Qtrly
12/29/2021
0.28%
Due
12/29/2023
12/29/2020
12/29/2020
3,500,000.00
3,500,000.00
0.00 0.00
3,500,000.00
54.44 0.00
871.11
816.67
0.00 0.00
0.00 816.67
816.67
40434CAD7
HSBC USA Inc
Note
3.5%
Due
06/23/2024
12/10/2019
12/10/2019
3,000,000.00
3,056,892.64
0.00 0.00
3,053,620.52
2,333.33
0.00 11,083.33
8,750.00
0.00 3,272.12
(
3,272.12
)
5,477.88
5,477.88
Execution Time: 2/2/2023 2:21:50 AM
Chandler Asset Management - CONFIDENTIAL
Income Earned
As of January 31, 2023
City of Orange
Account #10888
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
46647PBK1
JP Morgan Chase & Co
Callable Note Cont
4/22/2025
2.083%
Due
04/22/2026
05/31/2022
06/02/2022
1,250,000.00
1,199,701.25
0.00 0.00
1,200,993.10
4,990.52
0.00 7,160.31
2,169.79
1,291.85
0.00 1,291.85
3,461.64
3,461.64
61747YET8
Morgan Stanley
Callable Note Cont
7/17/2025
4.679%
Due
07/17/2026
12/28/2022
12/30/2022
775,000.00
764,406.64
0.00 0.00
764,660.61
16,217.28
17,828.94
1,410.20
3,021.86
253.97
0.00 253.97
3,275.83
3,275.83
63743HFF4
National Rural Utilities
Note
5.45%
Due
10/30/2025
10/20/2022
10/31/2022
495,000.00
494,374.26
0.00 0.00
494,393.04
4,571.19
0.00 6,819.31
2,248.12
18.78 0.00
18.78 2,266.90
2,266.90
69371RR81
Paccar Financial Corp
Note
3.15%
Due
06/13/2024
06/06/2022
06/13/2022
895,000.00
894,851.03
0.00 0.00
894,859.76
1,409.63
0.00 3,759.00
2,349.37
8.73 0.00
8.73 2,358.10
2,358.10
89236THP3
Toyota Motor Credit Corp
Note
0.8%
Due
10/16/2025
11/19/2020
11/19/2020
5,000,000.00
5,014,215.96
0.00 0.00
5,013,783.48
8,333.33
0.00 11,666.67
3,333.34
0.00 432.48
(
432.48
)
2,900.86
2,900.86
91282CCZ2
US Treasury
Note
0.875%
Due
09/30/2026
09/30/2021
09/30/2021
3,000,000.00
2,985,426.14
0.00 0.00
2,985,756.40
6,706.73
0.00 8,942.31
2,235.58
330.26
0.00 330.26
2,565.84
2,565.84
91324PEN8
United Health Group Inc
Note
5.15%
Due
10/15/2025
12/28/2022
12/30/2022
775,000.00
786,756.90
0.00 0.00
786,398.88
6,984.69
0.00 10,310.73
3,326.04
0.00 358.02
(
358.02
)
2,968.02
2,968.02
92348KAA1
Verizon Master Trust
2021-1
A
0.5%
Due
05/20/2027
10/21/2022
10/25/2022
220,000.00
205,896.69
0.00 0.00
206,456.49
33.61 91.67
33.61 91.67
559.80
0.00 559.80
651.47
651.47
Total Fixed Income
80,595,000.00
80,511,329.32
0.00 0.00
80,512,886.31
157,475.02
53,420.61
168,297.50
64,243.09
5,619.61
4,062.62
1,556.99
65,800.08
65,800.08
Execution Time: 2/2/2023 2:21:50 AM
Chandler Asset Management - CONFIDENTIAL
Income Earned
As of January 31, 2023
City of Orange
Account #10888
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 & EQUIVALENT
31846V203
First American
Govt Obligation Fund Class Y
Various
Various
97,829.80
49,384.18
53,950.67
5,505.05
97,829.80
0.00 530.06
0.00 530.06
0.00 0.00
0.00 530.06
530.06
Total Cash & Equivalent
97,829.80
49,384.18
53,950.67
5,505.05
97,829.80
0.00 530.06
0.00 530.06
0.00 0.00
0.00 530.06
530.06
TOTAL PORTFOLIO
80,692,829.80
80,560,713.50
53,950.67
5,505.05
80,610,716.11
157,475.02
53,950.67
168,297.50
64,773.15
5,619.61
4,062.62
1,556.99
66,330.14
66,330.14
Execution Time: 2/2/2023 2:21:50 AM
Chandler Asset Management - CONFIDENTIAL
Cash Flow Report
As of January 31, 2023
City of Orange
Account #10888
Payment Date
Transaction Type
CUSIP
Quantity
Security Description
Principal Amount
Income
Total Amount
02/08/2023
Interest
037833EB2
3,000,000.00
Apple Inc Callable Note Cont
1/8/2026
0.7%
Due
2/8/2026
0.00 10,500.00
10,500.00
02/18/2023
Interest
3135GA4W8
5,000,000.00
FNMA Callable Note Qtrly
11/18/2022
0.5%
Due
2/18/2025
0.00 12,500.00
12,500.00
02/20/2023
Paydown
92348KAA1
220,000.00
Verizon Master Trust
2021-1
A
0.5%
Due
5/20/2027
0.00 91.67
91.67 FEB 2023
0.00 23,091.67
23,091.67
03/06/2023
Interest
191216CL2
3,000,000.00
Coca Cola Company Callable Note Cont
8/6/2024
1.75%
Due
9/6/2024
0.00 26,250.00
26,250.00
03/20/2023
Paydown
92348KAA1
220,000.00
Verizon Master Trust
2021-1
A
0.5%
Due
5/20/2027
0.00 91.67
91.67 03/25/2023
Interest
3134GWVE3
4,575,000.00
FHLMC Callable Note Qtrly
3/25/2021
0.4%
Due
9/25/2024
0.00 9,150.00
9,150.00
03/28/2023
Interest
3130ALLM4
5,000,000.00
FHLB Callable Note Qtrly
6/28/2021
0.35%
Due
3/28/2024
0.00 8,750.00
8,750.00
03/29/2023
Interest
3134GWXC5
5,000,000.00
FHLMC Callable Note Qtrly
9/29/2021
0.35%
Due
3/29/2024
0.00 8,750.00
8,750.00
03/31/2023
Interest
91282CCZ2
3,000,000.00
US Treasury Note
0.875%
Due
9/30/2026
0.00 13,125.00
13,125.00
MAR 2023
0.00 66,116.67
66,116.67
04/15/2023
Interest
91324PEN8
775,000.00
United Health Group Inc Note
5.15%
Due
10/15/2025
0.00 18,514.97
18,514.97
04/16/2023
Interest
89236THP3
5,000,000.00
Toyota Motor Credit Corp Note
0.8%
Due
10/16/2025
0.00 20,000.00
20,000.00
04/20/2023
Paydown
92348KAA1
220,000.00
Verizon Master Trust
2021-1
A
0.5%
Due
5/20/2027
0.00 91.67
91.67 04/22/2023
Interest
06051GJR1
1,250,000.00
Bank of America Corp Callable Note Cont
4/22/2024
0.976%
Due
4/22/2025
0.00 6,100.00
6,100.00
04/22/2023
Interest
46647PBK1
1,250,000.00
JP Morgan Chase & Co Callable Note Cont
4/22/2025
2.083%
Due
4/22/2026
0.00 13,018.75
13,018.75
04/28/2023
Interest
3134GW3Z7
9,000,000.00
FHLMC Callable Note Qtrly
10/28/2021
0.6%
Due
10/28/2025
0.00 27,000.00
27,000.00
04/29/2023
Interest
3130AMBG6
5,000,000.00
FHLB Callable Note Qtrly
7/29/2021
0.75%
Due
4/29/2025
0.00 18,750.00
18,750.00
Execution Time: 2/2/2023 2:21:50 AM
Chandler Asset Management - CONFIDENTIAL
Cash Flow Report
As of January 31, 2023
City of Orange
Account #10888
Payment Date
Transaction Type
CUSIP
Quantity
Security Description
Principal Amount
Income
Total Amount
04/30/2023
Interest
63743HFF4
495,000.00
National Rural Utilities Note
5.45%
Due
10/30/2025
0.00 13,488.75
13,488.75
APR 2023
0.00 116,964.14
116,964.14
05/08/2023
Interest
14913Q3B3
1,250,000.00
Caterpillar Finl Service Note
2.15%
Due
11/8/2024
0.00 13,437.50
13,437.50
05/17/2023
Interest
3135GA4S7
5,000,000.00
FNMA Callable Note Qtrly
11/17/2022
0.375%
Due
5/17/2024
0.00 9,375.00
9,375.00
05/20/2023
Paydown
92348KAA1
220,000.00
Verizon Master Trust
2021-1
A
0.5%
Due
5/20/2027
0.00 91.67
91.67 MAY 2023
0.00 22,904.17
22,904.17
06/06/2023
Interest
24422EWF2
280,000.00
John Deere Capital Corp Note
3.4%
Due
6/6/2025
0.00 4,760.00
4,760.00
06/13/2023
Interest
06406RBF3
955,000.00
Bank of NY Mellon Corp Callable Note Cont
6/13/2024
3.43%
Due
6/13/2025
0.00 16,378.25
16,378.25
06/13/2023
Interest
69371RR81
895,000.00
Paccar Financial Corp Note
3.15%
Due
6/13/2024
0.00 14,096.25
14,096.25
06/14/2023
Interest
3135GA5Y3
4,375,000.00
FNMA Callable Note Qtrly
12/14/2021
0.375%
Due
6/14/2024
0.00 8,203.13
8,203.13
06/20/2023
Paydown
92348KAA1
220,000.00
Verizon Master Trust
2021-1
A
0.5%
Due
5/20/2027
0.00 91.67
91.67 06/23/2023
Interest
40434CAD7
3,000,000.00
HSBC USA Inc Note
3.5%
Due
6/23/2024
0.00 52,500.00
52,500.00
06/29/2023
Interest
3135GABN0
3,500,000.00
FNMA Callable Note Qtrly
12/29/2021
0.28%
Due
12/29/2023
0.00 4,900.00
4,900.00
JUN 2023
0.00 100,929.30
100,929.30
07/17/2023
Interest
61747YET8
775,000.00
Morgan Stanley Callable Note Cont
7/17/2025
4.679%
Due
7/17/2026
0.00 18,131.13
18,131.13
07/20/2023
Paydown
92348KAA1
220,000.00
Verizon Master Trust
2021-1
A
0.5%
Due
5/20/2027
0.00 91.67
91.67 07/28/2023
Call
3130ANA42
4,000,000.00
FHLB Callable Note Qtrly
1/28/2022
0.65%
Due
4/28/2025
4,000,000.00
13,000.00
4,013,000.00
Execution Time: 2/2/2023 2:21:50 AM
Chandler Asset Management - CONFIDENTIAL
Cash Flow Report
As of January 31, 2023
City of Orange
Account #10888
Payment Date
Transaction Type
CUSIP
Quantity
Security Description
Principal Amount
Income
Total Amount
07/29/2023
Interest
3130ANDF4
5,000,000.00
FHLB Callable Note Annual
7/29/2022
0.9%
Due
7/29/2026
0.00 22,500.00
22,500.00
JUL 2023
4,000,000.00
53,722.80
4,053,722.80
08/08/2023
Interest
037833EB2
3,000,000.00
Apple Inc Callable Note Cont
1/8/2026
0.7%
Due
2/8/2026
0.00 10,500.00
10,500.00
08/18/2023
Interest
3135GA4W8
5,000,000.00
FNMA Callable Note Qtrly
11/18/2022
0.5%
Due
2/18/2025
0.00 12,500.00
12,500.00
08/20/2023
Paydown
92348KAA1
220,000.00
Verizon Master Trust
2021-1
A
0.5%
Due
5/20/2027
0.00 91.67
91.67 AUG 2023
0.00 23,091.67
23,091.67
09/06/2023
Interest
191216CL2
3,000,000.00
Coca Cola Company Callable Note Cont
8/6/2024
1.75%
Due
9/6/2024
0.00 26,250.00
26,250.00
09/20/2023
Paydown
92348KAA1
220,000.00
Verizon Master Trust
2021-1
A
0.5%
Due
5/20/2027
0.00 91.67
91.67 09/25/2023
Interest
3134GWVE3
4,575,000.00
FHLMC Callable Note Qtrly
3/25/2021
0.4%
Due
9/25/2024
0.00 9,150.00
9,150.00
09/28/2023
Interest
3130ALLM4
5,000,000.00
FHLB Callable Note Qtrly
6/28/2021
0.35%
Due
3/28/2024
0.00 8,750.00
8,750.00
09/29/2023
Interest
3134GWXC5
5,000,000.00
FHLMC Callable Note Qtrly
9/29/2021
0.35%
Due
3/29/2024
0.00 8,750.00
8,750.00
09/30/2023
Interest
91282CCZ2
3,000,000.00
US Treasury Note
0.875%
Due
9/30/2026
0.00 13,125.00
13,125.00
SEP 2023
0.00 66,116.67
66,116.67
10/15/2023
Interest
91324PEN8
775,000.00
United Health Group Inc Note
5.15%
Due
10/15/2025
0.00 19,956.25
19,956.25
10/16/2023
Interest
89236THP3
5,000,000.00
Toyota Motor Credit Corp Note
0.8%
Due
10/16/2025
0.00 20,000.00
20,000.00
10/20/2023
Paydown
92348KAA1
220,000.00
Verizon Master Trust
2021-1
A
0.5%
Due
5/20/2027
0.00 91.67
91.67 10/22/2023
Interest
06051GJR1
1,250,000.00
Bank of America Corp Callable Note Cont
4/22/2024
0.976%
Due
4/22/2025
0.00 6,100.00
6,100.00
10/22/2023
Interest
46647PBK1
1,250,000.00
JP Morgan Chase & Co Callable Note Cont
4/22/2025
2.083%
Due
4/22/2026
0.00 13,018.75
13,018.75
Execution Time: 2/2/2023 2:21:50 AM
Chandler Asset Management - CONFIDENTIAL
Cash Flow Report
As of January 31, 2023
City of Orange
Account #10888
Payment Date
Transaction Type
CUSIP
Quantity
Security Description
Principal Amount
Income
Total Amount
10/28/2023
Interest
3134GW3Z7
9,000,000.00
FHLMC Callable Note Qtrly
10/28/2021
0.6%
Due
10/28/2025
0.00 27,000.00
27,000.00
10/29/2023
Interest
3130AMBG6
5,000,000.00
FHLB Callable Note Qtrly
7/29/2021
0.75%
Due
4/29/2025
0.00 18,750.00
18,750.00
10/31/2023
Interest
63743HFF4
495,000.00
National Rural Utilities Note
5.45%
Due
10/30/2025
0.00 13,488.75
13,488.75
OCT 2023
0.00 118,405.42
118,405.42
11/08/2023
Interest
14913Q3B3
1,250,000.00
Caterpillar Finl Service Note
2.15%
Due
11/8/2024
0.00 13,437.50
13,437.50
11/17/2023
Interest
3135GA4S7
5,000,000.00
FNMA Callable Note Qtrly
11/17/2022
0.375%
Due
5/17/2024
0.00 9,375.00
9,375.00
11/20/2023
Paydown
92348KAA1
220,000.00
Verizon Master Trust
2021-1
A
0.5%
Due
5/20/2027
0.00 91.67
91.67 NOV 2023
0.00 22,904.17
22,904.17
12/06/2023
Interest
24422EWF2
280,000.00
John Deere Capital Corp Note
3.4%
Due
6/6/2025
0.00 4,760.00
4,760.00
12/13/2023
Interest
69371RR81
895,000.00
Paccar Financial Corp Note
3.15%
Due
6/13/2024
0.00 14,096.25
14,096.25
12/13/2023
Interest
06406RBF3
955,000.00
Bank of NY Mellon Corp Callable Note Cont
6/13/2024
3.43%
Due
6/13/2025
0.00 16,378.25
16,378.25
12/14/2023
Interest
3135GA5Y3
4,375,000.00
FNMA Callable Note Qtrly
12/14/2021
0.375%
Due
6/14/2024
0.00 8,203.13
8,203.13
12/20/2023
Paydown
92348KAA1
220,000.00
Verizon Master Trust
2021-1
A
0.5%
Due
5/20/2027
0.00 91.67
91.67 12/23/2023
Interest
40434CAD7
3,000,000.00
HSBC USA Inc Note
3.5%
Due
6/23/2024
0.00 52,500.00
52,500.00
12/29/2023
Maturity
3135GABN0
3,500,000.00
FNMA Callable Note Qtrly
12/29/2021
0.28%
Due
12/29/2023
3,500,000.00
4,900.00
3,504,900.00
DEC 2023
3,500,000.00
100,929.30
3,600,929.30
01/17/2024
Interest
61747YET8
775,000.00
Morgan Stanley Callable Note Cont
7/17/2025
4.679%
Due
7/17/2026
0.00 18,131.13
18,131.13
01/20/2024
Paydown
92348KAA1
220,000.00
Verizon Master Trust
2021-1
A
0.5%
Due
5/20/2027
0.00 91.67
91.67 Execution Time: 2/2/2023 2:21:50 AM
Chandler Asset Management - CONFIDENTIAL
Cash Flow Report
As of January 31, 2023
City of Orange
Account #10888
Payment Date
Transaction Type
CUSIP
Quantity
Security Description
Principal Amount
Income
Total Amount
01/29/2024
Interest
3130ANDF4
5,000,000.00
FHLB Callable Note Annual
7/29/2022
0.9%
Due
7/29/2026
0.00 22,500.00
22,500.00
JAN 2024
0.00 40,722.80
40,722.80
TOTAL
7,500,000.00
755,898.78
8,255,898.78
Execution Time: 2/2/2023 2:21:50 AM
Chandler Asset Management - CONFIDENTIAL
Important Disclosures
City of Orange
Account #10888
Chandler Asset Management, Inc.
;͞
Chandler
͟Ϳ
is an SEC registered investment adviser. For additional information about our firm, please see our current disclosures (Form ADV). To obtain a copy of our current disclosures, you may contact your client service representative by calling the number on the front of this statement or you may visit our website at www.chandlerasset.com.
Information contained in this monthly statement is confidential and is provided for informational purposes only and should not be construed as specific investment or legal advice. The information contained herein was obtained from sources believed to be reliable as of the date of this statement, but may become outdated or superseded at any time without notice.
Custody:
Your qualified custodian bank maintains control of all assets reflected in this statement and we urge you to compare this statement to the one you receive from your qualified custodian. Chandler does not have any authority to withdraw or deposit funds from/to the custodian account.
Valuation:
Prices are provided by IDC, an independent pricing source. In the event IDC does not provide a price or if the price provided is not reflective of fair market value, Chandler will obtain pricing from an alternative approved third party pricing source in accordance with our written valuation policy and procedures. Our valuation procedures are also disclosed in Item 5 of our Form ADV Part 2A.
Performance:
Performance results are presented gross-of-advisory fees and represent the client ͛
s Total Return. The deduction of advisory fees lowers performance results. These results include the reinvestment of dividends and other earnings. Past performance may not be indicative of future results. Therefore, clients should not assume that future performance of any specific investment or investment strategy will be profitable or equal to past performance levels. All investment strategies have the potential for profit or loss. Economic factors, market conditions or changes in investment strategies, contributions or withdrawals may materially alter the performance and results of your portfolio.
Source ice Data Indices, LLC ("ICE"), used with permission. ICE PERMITS USE OF THE ICE INDICES AND RELATED DATA ON AN "AS IS" BASIS; ICE, ITS AFFILIATES AND THEIR RESPECTIVE
THIRD PARTY SUPPLIERS DISCLAIM ANY AND ALL WARRANTIES AND REPRESENTATIONS, EXPRESS AND/OR IMPLIED, INCLUDING ANY WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE OR USE, INCLUDING THE INDICES, INDEX DATA AND ANY DATA INCLUDED IN, RELATED TO, OR DERIVED THEREFROM. NEITHER ICE DATA, ITS AFFILIATES OR
THEIR RESPECTIVE THIRD PARTY PROVIDERS GUARANTEE THE QUALITY, ADEQUACY, ACCURACY, TIMELINESS OR COMPLETENESS OF THE INDICES OR THE INDEX DATA OR ANY COMPONENT THEREOF, AND THE INDICES AND INDEX DATA AND ALL COMPONENTS THEREOF ARE PROVIDED ON AN "AS IS" BASIS AND LICENSEE'S USE IS AT LICENSEE'S OWN RISK. ICE DATA, ITS AFFILIATES AND THEIR RESPECTIVE THIRD PARTY DO NOT SPONSOR, ENDORSE, OR RECOMMEND CHANDLER, OR ANY OF ITS PRODUCTS OR SERVICES.
Index returns assume reinvestment of all distributions. Historical performance results for investment indexes generally do not reflect the deduction of transaction and/or custodial charges or the deduction of an investment management fee, the incurrence of which would have the effect of decreasing historical performance results. It is not possible to invest directly in an index.
Ratings:
Ratings information have been provided by Moody
͛
s, S&P and Fitch through data feeds we believe to be reliable as of the date of this statement, however we cannot guarantee its accuracy.
Security level ratings for U.S. Agency issued mortgage-backed securities ;͞
MBS
͟Ϳ
reflect the issuer rating because the securities themselves are not rated. The issuing U.S. Agency guarantees the full and timely payment of both principal and interest and carries a AA+/Aaa/AAA by S&P, Moody ͛
s and Fitch respectively.
Execution Time: 2/2/2023 2:21:50 AM
Chandler Asset Management - CONFIDENTIAL
Benchmark Index & Disclosures
City of Orange
Account #10888
Benchmark Index
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.
Execution Time: 2/2/2023 2:21:50 AM
Chandler Asset Management - CONFIDENTIAL