Transaction Ledger
As of May 31, 2023
City of Salinas Consolidated
Account #10951
Transaction
Type
Settlement
Date
CUSIP
Quantity
Security Description
Price
Acq/Disp
Yield
Amount
Interest
Pur/Sold
Total Amount
Gain/Loss
ACQUISITIONS
Purchase
07/01/2022
66815L2J7
1,370,000.00
Northwestern Mutual Glbl Note
4%
Due
7/1/2025
99.966
4.01%
1,369,534.20
0.00 1,369,534.20
0.00 Purchase
07/07/2022
90CASH$00
13,000.00
Cash Custodial Cash Account
1.000
13,000.00
0.00 13,000.00
0.00 Purchase
07/10/2022
90CASH$00
10,125.00
Cash Custodial Cash Account
1.000
10,125.00
0.00 10,125.00
0.00 Purchase
07/11/2022
90CASH$00
3,285.27
Cash Custodial Cash Account
1.000
3,285.27
0.00 3,285.27
0.00 Purchase
07/13/2022
90CASH$00
24,787.50
Cash Custodial Cash Account
1.000
24,787.50
0.00 24,787.50
0.00 Purchase
07/14/2022
90CASH$00
2,000,000.00
Cash Custodial Cash Account
1.000
2,000,000.00
0.00 2,000,000.00
0.00 Purchase
07/14/2022
91282CEH0
2,000,000.00
US Treasury Note
2.625%
Due
4/15/2025
98.570
3.17%
1,971,406.25
12,909.84
1,984,316.09
0.00 Purchase
07/15/2022
90CASH$00
10,930.65
Cash Custodial Cash Account
1.000
10,930.65
0.00 10,930.65
0.00 Purchase
07/16/2022
90CASH$00
698.63
Cash Custodial Cash Account
1.000
698.63
0.00 698.63
0.00 Purchase
07/26/2022
90CASH$00
250,000.00
Cash Custodial Cash Account
1.000
250,000.00
0.00 250,000.00
0.00 Purchase
07/26/2022
90CASH$00
2,851.37
Cash Custodial Cash Account
1.000
2,851.37
0.00 2,851.37
0.00 Purchase
07/28/2022
90CASH$00
729.45
Cash Custodial Cash Account
1.000
729.45
0.00 729.45
0.00 Purchase
08/01/2022
90CASH$00
16,250.00
Cash Custodial Cash Account
1.000
16,250.00
0.00 16,250.00
0.00 Purchase
08/11/2022
90CASH$00
1,363.70
Cash Custodial Cash Account
1.000
1,363.70
0.00 1,363.70
0.00 Purchase
08/12/2022
90CASH$00
10,500.00
Cash Custodial Cash Account
1.000
10,500.00
0.00 10,500.00
0.00 Purchase
08/15/2022
90CASH$00
2,200,000.00
Cash Custodial Cash Account
1.000
2,200,000.00
0.00 2,200,000.00
0.00 Purchase
08/15/2022
90CASH$00
76,634.59
Cash Custodial Cash Account
1.000
76,634.59
0.00 76,634.59
0.00 Purchase
08/16/2022
90CASH$00
250,000.00
Cash Custodial Cash Account
1.000
250,000.00
0.00 250,000.00
0.00 Purchase
08/16/2022
90CASH$00
22,299.32
Cash Custodial Cash Account
1.000
22,299.32
0.00 22,299.32
0.00 Purchase
08/24/2022
90CASH$00
5,250.00
Cash Custodial Cash Account
1.000
5,250.00
0.00 5,250.00
0.00 Purchase
08/25/2022
90CASH$00
3,000.00
Cash Custodial Cash Account
1.000
3,000.00
0.00 3,000.00
0.00 Purchase
08/28/2022
90CASH$00
753.77
Cash Custodial Cash Account
1.000
753.77
0.00 753.77
0.00 Purchase
09/05/2022
90CASH$00
23,075.00
Cash Custodial Cash Account
1.000
23,075.00
0.00 23,075.00
0.00 Purchase
09/07/2022
90CASH$00
13,812.50
Cash Custodial Cash Account
1.000
13,812.50
0.00 13,812.50
0.00 Purchase
09/08/2022
90CASH$00
36,562.50
Cash Custodial Cash Account
1.000
36,562.50
0.00 36,562.50
0.00
Chandler Asset Management - CONFIDENTIAL
Execution Time: 6/6/2023 10:32:25 AM
Transaction Ledger
As of May 31, 2023
City of Salinas Consolidated
Account #10951
Transaction
Type
Settlement
Date
CUSIP
Quantity
Security Description
Price
Acq/Disp
Yield
Amount
Interest
Pur/Sold
Total Amount
Gain/Loss
ACQUISITIONS
Purchase
09/13/2022
90CASH$00
17,550.00
Cash Custodial Cash Account
1.000
17,550.00
0.00 17,550.00
0.00 Purchase
09/15/2022
90CASH$00
26,384.59
Cash Custodial Cash Account
1.000
26,384.59
0.00 26,384.59
0.00 Purchase
09/15/2022
90CASH$00
2,100,000.00
Cash Custodial Cash Account
1.000
2,100,000.00
0.00 2,100,000.00
0.00 Purchase
09/16/2022
90CASH$00
721.92
Cash Custodial Cash Account
1.000
721.92
0.00 721.92
0.00 Purchase
09/23/2022
90CASH$00
1,302,607.22
Cash Custodial Cash Account
1.000
1,302,607.22
0.00 1,302,607.22
0.00 Purchase
09/28/2022
90CASH$00
753.77
Cash Custodial Cash Account
1.000
753.77
0.00 753.77
0.00 Purchase
09/30/2022
3133ENP95
1,200,000.00
FFCB Note
4.25%
Due
9/30/2025
99.306
4.50%
1,191,668.40
0.00 1,191,668.40
0.00 Purchase
10/10/2022
90CASH$00
18,687.50
Cash Custodial Cash Account
1.000
18,687.50
0.00 18,687.50
0.00 Purchase
10/15/2022
90CASH$00
38,118.15
Cash Custodial Cash Account
1.000
38,118.15
0.00 38,118.15
0.00 Purchase
10/16/2022
90CASH$00
698.63
Cash Custodial Cash Account
1.000
698.63
0.00 698.63
0.00 Purchase
10/18/2022
90CASH$00
6,785.00
Cash Custodial Cash Account
1.000
6,785.00
0.00 6,785.00
0.00 Purchase
10/20/2022
90CASH$00
1,303,549.00
Cash Custodial Cash Account
1.000
1,303,549.00
0.00 1,303,549.00
0.00 Purchase
10/25/2022
912828U24
1,550,000.00
US Treasury Note
2%
Due
11/15/2026
90.953
4.46%
1,409,773.44
13,730.98
1,423,504.42
0.00 Purchase
10/28/2022
90CASH$00
729.45
Cash Custodial Cash Account
1.000
729.45
0.00 729.45
0.00 Purchase
11/01/2022
90CASH$00
15,187.50
Cash Custodial Cash Account
1.000
15,187.50
0.00 15,187.50
0.00 Purchase
11/02/2022
90CASH$00
711.06
Cash Custodial Cash Account
1.000
711.06
0.00 711.06
0.00 Purchase
11/05/2022
90CASH$00
2,456.25
Cash Custodial Cash Account
1.000
2,456.25
0.00 2,456.25
0.00 Purchase
11/06/2022
90CASH$00
1,625.00
Cash Custodial Cash Account
1.000
1,625.00
0.00 1,625.00
0.00 Purchase
11/10/2022
90CASH$00
9,500.00
Cash Custodial Cash Account
1.000
9,500.00
0.00 9,500.00
0.00 Purchase
11/11/2022
90CASH$00
18,525.00
Cash Custodial Cash Account
1.000
18,525.00
0.00 18,525.00
0.00 Purchase
11/13/2022
90CASH$00
22,100.00
Cash Custodial Cash Account
1.000
22,100.00
0.00 22,100.00
0.00 Purchase
11/15/2022
90CASH$00
50,509.59
Cash Custodial Cash Account
1.000
50,509.59
0.00 50,509.59
0.00 Purchase
11/15/2022
90CASH$00
1,300,000.00
Cash Custodial Cash Account
1.000
1,300,000.00
0.00 1,300,000.00
0.00 Purchase
11/16/2022
61747YEX9
1,000,000.00
Morgan Stanley Callable Note Cont
10/16/2025
6.138%
Due
10/16/2026
101.521
5.56%
1,015,210.00
4,774.00
1,019,984.00
0.00
Chandler Asset Management - CONFIDENTIAL
Execution Time: 6/6/2023 10:32:25 AM
Transaction Ledger
As of May 31, 2023
City of Salinas Consolidated
Account #10951
Transaction
Type
Settlement
Date
CUSIP
Quantity
Security Description
Price
Acq/Disp
Yield
Amount
Interest
Pur/Sold
Total Amount
Gain/Loss
ACQUISITIONS
Purchase
11/16/2022
90CASH$00
15,553.17
Cash Custodial Cash Account
1.000
15,553.17
0.00 15,553.17
0.00 Purchase
11/18/2022
91282CFW6
450,000.00
US Treasury Note
4.5%
Due
11/15/2025
100.742
4.23%
453,339.84
167.82
453,507.66
0.00 Purchase
11/21/2022
90CASH$00
25,025.00
Cash Custodial Cash Account
1.000
25,025.00
0.00 25,025.00
0.00 Purchase
11/26/2022
90CASH$00
3,125.00
Cash Custodial Cash Account
1.000
3,125.00
0.00 3,125.00
0.00 Purchase
11/28/2022
90CASH$00
4,816.27
Cash Custodial Cash Account
1.000
4,816.27
0.00 4,816.27
0.00 Purchase
11/30/2022
90CASH$00
250,000.00
Cash Custodial Cash Account
1.000
250,000.00
0.00 250,000.00
0.00 Purchase
11/30/2022
90CASH$00
246.58
Cash Custodial Cash Account
1.000
246.58
0.00 246.58
0.00 Purchase
12/02/2022
90CASH$00
374.19
Cash Custodial Cash Account
1.000
374.19
0.00 374.19
0.00 Purchase
12/03/2022
90CASH$00
24,544.00
Cash Custodial Cash Account
1.000
24,544.00
0.00 24,544.00
0.00 Purchase
12/09/2022
90CASH$00
5,400.00
Cash Custodial Cash Account
1.000
5,400.00
0.00 5,400.00
0.00 Purchase
12/13/2022
90CASH$00
42,003.50
Cash Custodial Cash Account
1.000
42,003.50
0.00 42,003.50
0.00 Purchase
12/14/2022
90CASH$00
24,992.50
Cash Custodial Cash Account
1.000
24,992.50
0.00 24,992.50
0.00 Purchase
12/15/2022
90CASH$00
34,937.50
Cash Custodial Cash Account
1.000
34,937.50
0.00 34,937.50
0.00 Purchase
12/15/2022
90CASH$00
2,100,000.00
Cash Custodial Cash Account
1.000
2,100,000.00
0.00 2,100,000.00
0.00 Purchase
12/15/2022
91282CFW6
1,750,000.00
US Treasury Note
4.5%
Due
11/15/2025
101.508
3.95%
1,776,386.72
6,526.24
1,782,912.96
0.00 Purchase
12/16/2022
90CASH$00
698.63
Cash Custodial Cash Account
1.000
698.63
0.00 698.63
0.00 Purchase
12/16/2022
91282CGA3
675,000.00
US Treasury Note
4%
Due
12/15/2025
100.125
3.96%
675,843.75
74.18 675,917.93
0.00 Purchase
12/17/2022
90CASH$00
21,125.00
Cash Custodial Cash Account
1.000
21,125.00
0.00 21,125.00
0.00 Purchase
12/22/2022
90CASH$00
17,875.00
Cash Custodial Cash Account
1.000
17,875.00
0.00 17,875.00
0.00 Purchase
12/23/2022
90CASH$00
3,500.00
Cash Custodial Cash Account
1.000
3,500.00
0.00 3,500.00
0.00 Purchase
12/28/2022
90CASH$00
20,013.83
Cash Custodial Cash Account
1.000
20,013.83
0.00 20,013.83
0.00 Purchase
01/01/2023
90CASH$00
27,400.00
Cash Custodial Cash Account
1.000
27,400.00
0.00 27,400.00
0.00 Purchase
01/04/2023
90CASH$00
625.66
Cash Custodial Cash Account
1.000
625.66
0.00 625.66
0.00 Purchase
01/07/2023
90CASH$00
13,000.00
Cash Custodial Cash Account
1.000
13,000.00
0.00 13,000.00
0.00
Chandler Asset Management - CONFIDENTIAL
Execution Time: 6/6/2023 10:32:25 AM
Transaction Ledger
As of May 31, 2023
City of Salinas Consolidated
Account #10951
Transaction
Type
Settlement
Date
CUSIP
Quantity
Security Description
Price
Acq/Disp
Yield
Amount
Interest
Pur/Sold
Total Amount
Gain/Loss
ACQUISITIONS
Purchase
01/10/2023
90CASH$00
10,125.00
Cash Custodial Cash Account
1.000
10,125.00
0.00 10,125.00
0.00 Purchase
01/11/2023
90CASH$00
250,000.00
Cash Custodial Cash Account
1.000
250,000.00
0.00 250,000.00
0.00 Purchase
01/11/2023
90CASH$00
3,339.73
Cash Custodial Cash Account
1.000
3,339.73
0.00 3,339.73
0.00 Purchase
01/13/2023
90CASH$00
24,787.50
Cash Custodial Cash Account
1.000
24,787.50
0.00 24,787.50
0.00 Purchase
01/15/2023
90CASH$00
10,437.50
Cash Custodial Cash Account
1.000
10,437.50
0.00 10,437.50
0.00 Purchase
01/16/2023
90CASH$00
721.92
Cash Custodial Cash Account
1.000
721.92
0.00 721.92
0.00 Purchase
01/24/2023
06051GLE7
1,300,000.00
Bank of America Corp Callable Note
2 X
1/20/2026
5.08%
Due
1/20/2027
100.230
5.00%
1,302,990.00
733.78
1,303,723.78
0.00 Purchase
01/24/2023
90CASH$00
11,560.25
Cash Custodial Cash Account
1.000
11,560.25
0.00 11,560.25
0.00 Purchase
01/26/2023
9128286L9
1,800,000.00
US Treasury Note
2.25%
Due
3/31/2026
95.445
3.78%
1,718,015.63
13,129.12
1,731,144.75
0.00 Purchase
01/28/2023
90CASH$00
753.77
Cash Custodial Cash Account
1.000
753.77
0.00 753.77
0.00 Purchase
02/01/2023
90CASH$00
16,250.00
Cash Custodial Cash Account
1.000
16,250.00
0.00 16,250.00
0.00 Purchase
02/02/2023
90CASH$00
878.27
Cash Custodial Cash Account
1.000
878.27
0.00 878.27
0.00 Purchase
02/11/2023
90CASH$00
1,386.30
Cash Custodial Cash Account
1.000
1,386.30
0.00 1,386.30
0.00 Purchase
02/12/2023
90CASH$00
10,500.00
Cash Custodial Cash Account
1.000
10,500.00
0.00 10,500.00
0.00 Purchase
02/15/2023
90CASH$00
59,625.00
Cash Custodial Cash Account
1.000
59,625.00
0.00 59,625.00
0.00 Purchase
02/16/2023
90CASH$00
19,571.92
Cash Custodial Cash Account
1.000
19,571.92
0.00 19,571.92
0.00 Purchase
02/22/2023
90CASH$00
2,187,870.54
Cash Custodial Cash Account
1.000
2,187,870.54
0.00 2,187,870.54
0.00 Purchase
02/23/2023
02665WEC1
1,300,000.00
American Honda Finance Note
4.75%
Due
1/12/2026
99.385
4.98%
1,292,005.00
7,032.64
1,299,037.64
0.00 Purchase
02/23/2023
3133EPBM6
2,200,000.00
FFCB Note
4.125%
Due
8/23/2027
99.458
4.26%
2,188,076.00
0.00 2,188,076.00
0.00 Purchase
02/24/2023
90CASH$00
5,250.00
Cash Custodial Cash Account
1.000
5,250.00
0.00 5,250.00
0.00 Purchase
02/25/2023
90CASH$00
3,000.00
Cash Custodial Cash Account
1.000
3,000.00
0.00 3,000.00
0.00 Purchase
02/28/2023
90CASH$00
753.77
Cash Custodial Cash Account
1.000
753.77
0.00 753.77
0.00 Purchase
03/02/2023
90CASH$00
521.85
Cash Custodial Cash Account
1.000
521.85
0.00 521.85
0.00
Chandler Asset Management - CONFIDENTIAL
Execution Time: 6/6/2023 10:32:25 AM
Transaction Ledger
As of May 31, 2023
City of Salinas Consolidated
Account #10951
Transaction
Type
Settlement
Date
CUSIP
Quantity
Security Description
Price
Acq/Disp
Yield
Amount
Interest
Pur/Sold
Total Amount
Gain/Loss
ACQUISITIONS
Purchase
03/07/2023
90CASH$00
13,812.50
Cash Custodial Cash Account
1.000
13,812.50
0.00 13,812.50
0.00 Purchase
03/08/2023
90CASH$00
36,562.50
Cash Custodial Cash Account
1.000
36,562.50
0.00 36,562.50
0.00 Purchase
03/13/2023
00440EAV9
1,300,000.00
Chubb INA Holdings Inc Callable Note
Cont
2/3/2026
3.35%
Due
5/3/2026
95.012
5.09%
1,235,156.00
15,726.39
1,250,882.39
0.00 Purchase
03/13/2023
90CASH$00
1,300,000.00
Cash Custodial Cash Account
1.000
1,300,000.00
0.00 1,300,000.00
0.00 Purchase
03/13/2023
90CASH$00
17,550.00
Cash Custodial Cash Account
1.000
17,550.00
0.00 17,550.00
0.00 Purchase
03/15/2023
90CASH$00
25,875.00
Cash Custodial Cash Account
1.000
25,875.00
0.00 25,875.00
0.00 Purchase
03/16/2023
90CASH$00
652.05
Cash Custodial Cash Account
1.000
652.05
0.00 652.05
0.00 Purchase
03/28/2023
90CASH$00
680.82
Cash Custodial Cash Account
1.000
680.82
0.00 680.82
0.00 Purchase
03/30/2023
90CASH$00
25,500.00
Cash Custodial Cash Account
1.000
25,500.00
0.00 25,500.00
0.00 Purchase
03/31/2023
90CASH$00
20,250.00
Cash Custodial Cash Account
1.000
20,250.00
0.00 20,250.00
0.00 Purchase
04/04/2023
90CASH$00
782.13
Cash Custodial Cash Account
1.000
782.13
0.00 782.13
0.00 Purchase
04/10/2023
90CASH$00
18,687.50
Cash Custodial Cash Account
1.000
18,687.50
0.00 18,687.50
0.00 Purchase
04/15/2023
90CASH$00
34,875.00
Cash Custodial Cash Account
1.000
34,875.00
0.00 34,875.00
0.00 Purchase
04/16/2023
90CASH$00
31,241.42
Cash Custodial Cash Account
1.000
31,241.42
0.00 31,241.42
0.00 Purchase
04/18/2023
90CASH$00
6,785.00
Cash Custodial Cash Account
1.000
6,785.00
0.00 6,785.00
0.00 Purchase
04/25/2023
3133EPGW9
2,200,000.00
FFCB Note
3.875%
Due
4/25/2028
100.502
3.76%
2,211,044.00
0.00 2,211,044.00
0.00 Purchase
04/28/2023
90CASH$00
753.77
Cash Custodial Cash Account
1.000
753.77
0.00 753.77
0.00 Purchase
05/01/2023
90CASH$00
15,187.50
Cash Custodial Cash Account
1.000
15,187.50
0.00 15,187.50
0.00 Purchase
05/02/2023
90CASH$00
1,269.82
Cash Custodial Cash Account
1.000
1,269.82
0.00 1,269.82
0.00 Purchase
05/03/2023
90CASH$00
21,775.00
Cash Custodial Cash Account
1.000
21,775.00
0.00 21,775.00
0.00 Purchase
05/06/2023
90CASH$00
1,625.00
Cash Custodial Cash Account
1.000
1,625.00
0.00 1,625.00
0.00 Purchase
05/10/2023
90CASH$00
9,500.00
Cash Custodial Cash Account
1.000
9,500.00
0.00 9,500.00
0.00 Purchase
05/11/2023
90CASH$00
18,525.00
Cash Custodial Cash Account
1.000
18,525.00
0.00 18,525.00
0.00 Purchase
05/13/2023
90CASH$00
22,100.00
Cash Custodial Cash Account
1.000
22,100.00
0.00 22,100.00
0.00
Chandler Asset Management - CONFIDENTIAL
Execution Time: 6/6/2023 10:32:25 AM
Transaction Ledger
As of May 31, 2023
City of Salinas Consolidated
Account #10951
Transaction
Type
Settlement
Date
CUSIP
Quantity
Security Description
Price
Acq/Disp
Yield
Amount
Interest
Pur/Sold
Total Amount
Gain/Loss
ACQUISITIONS
Purchase
05/15/2023
90CASH$00
99,500.00
Cash Custodial Cash Account
1.000
99,500.00
0.00 99,500.00
0.00 Purchase
05/16/2023
90CASH$00
15,529.88
Cash Custodial Cash Account
1.000
15,529.88
0.00 15,529.88
0.00 Purchase
05/17/2023
58933YBH7
290,000.00
Merck & Co Callable Note Cont
4/17/2028
4.05%
Due
5/17/2028
99.919
4.07%
289,765.10
0.00 289,765.10
0.00 Purchase
05/21/2023
90CASH$00
25,025.00
Cash Custodial Cash Account
1.000
25,025.00
0.00 25,025.00
0.00 Purchase
05/24/2023
91282CHA2
2,400,000.00
US Treasury Note
3.5%
Due
4/30/2028
98.910
3.74%
2,373,843.75
5,478.26
2,379,322.01
0.00 Purchase
05/26/2023
90CASH$00
3,125.00
Cash Custodial Cash Account
1.000
3,125.00
0.00 3,125.00
0.00 Purchase
05/28/2023
90CASH$00
4,791.95
Cash Custodial Cash Account
1.000
4,791.95
0.00 4,791.95
0.00 Subtotal
41,022,659.87
40,711,717.95
80,283.25
40,792,001.20
0.00 Security
Contribution
08/15/2022
90CASH$00
76,634.59
Cash Custodial Cash Account
1.000
76,634.59
0.00 76,634.59
0.00 Security
Contribution
12/23/2022
90CASH$00
3,500.00
Cash Custodial Cash Account
1.000
3,500.00
0.00 3,500.00
0.00 Security
Contribution
12/28/2022
90CASH$00
20,013.83
Cash Custodial Cash Account
1.000
20,013.83
0.00 20,013.83
0.00 Subtotal
100,148.42
100,148.42
0.00 100,148.42
0.00 Short Sale
07/01/2022
90CASH$00
-1,369,534.20
Cash Custodial Cash Account
1.000
-1,369,534.20
0.00 -1,369,534.20
0.00 Short Sale
07/14/2022
90CASH$00
-1,984,316.09
Cash Custodial Cash Account
1.000
-1,984,316.09
0.00 -1,984,316.09
0.00 Short Sale
11/16/2022
90CASH$00
-1,019,984.00
Cash Custodial Cash Account
1.000
-1,019,984.00
0.00 -1,019,984.00
0.00 Short Sale
12/15/2022
90CASH$00
-1,782,912.96
Cash Custodial Cash Account
1.000
-1,782,912.96
0.00 -1,782,912.96
0.00 Short Sale
03/13/2023
90CASH$00
-1,250,882.39
Cash Custodial Cash Account
1.000
-1,250,882.39
0.00 -1,250,882.39
0.00 Subtotal
-7,407,629.64
-7,407,629.64
0.00 -7,407,629.64
0.00 TOTAL ACQUISITIONS
33,715,178.65
33,404,236.73
80,283.25
33,484,519.98
0.00
Chandler Asset Management - CONFIDENTIAL
Execution Time: 6/6/2023 10:32:25 AM
Transaction Ledger
As of May 31, 2023
City of Salinas Consolidated
Account #10951
Transaction
Type
Settlement
Date
CUSIP
Quantity
Security Description
Price
Acq/Disp
Yield
Amount
Interest
Pur/Sold
Total Amount
Gain/Loss
DISPOSITIONS
Closing
Purchase
07/01/2022
90CASH$00
-1,369,534.20
Cash Custodial Cash Account
1.000
-1,369,534.20
0.00 -1,369,534.20
0.00 Closing
Purchase
07/14/2022
90CASH$00
-1,984,316.09
Cash Custodial Cash Account
1.000
-1,984,316.09
0.00 -1,984,316.09
0.00 Closing
Purchase
11/16/2022
90CASH$00
-1,019,984.00
Cash Custodial Cash Account
1.000
-1,019,984.00
0.00 -1,019,984.00
0.00 Closing
Purchase
12/15/2022
90CASH$00
-1,782,912.96
Cash Custodial Cash Account
1.000
-1,782,912.96
0.00 -1,782,912.96
0.00 Closing
Purchase
03/13/2023
90CASH$00
-1,250,882.39
Cash Custodial Cash Account
1.000
-1,250,882.39
0.00 -1,250,882.39
0.00 Subtotal
-7,407,629.64
-7,407,629.64
0.00 -7,407,629.64
0.00 Sale
07/01/2022
90CASH$00
1,369,534.20
Cash Custodial Cash Account
1.000
1,369,534.20
0.00 1,369,534.20
0.00 Sale
07/14/2022
90CASH$00
1,984,316.09
Cash Custodial Cash Account
1.000
1,984,316.09
0.00 1,984,316.09
0.00 Sale
09/30/2022
90CASH$00
1,191,668.40
Cash Custodial Cash Account
1.000
1,191,668.40
0.00 1,191,668.40
0.00 Sale
10/25/2022
90CASH$00
1,423,504.42
Cash Custodial Cash Account
1.000
1,423,504.42
0.00 1,423,504.42
0.00 Sale
11/16/2022
90CASH$00
1,019,984.00
Cash Custodial Cash Account
1.000
1,019,984.00
0.00 1,019,984.00
0.00 Sale
11/18/2022
90CASH$00
453,507.66
Cash Custodial Cash Account
1.000
453,507.66
0.00 453,507.66
0.00 Sale
12/15/2022
90CASH$00
1,782,912.96
Cash Custodial Cash Account
1.000
1,782,912.96
0.00 1,782,912.96
0.00 Sale
12/16/2022
90CASH$00
675,917.93
Cash Custodial Cash Account
1.000
675,917.93
0.00 675,917.93
0.00 Sale
01/24/2023
06051GHF9
1,300,000.00
Bank of America Corp Callable Note
1 X
3/5/2023
3.55%
Due
3/5/2024
99.805
3.27%
1,297,465.00
17,819.03
1,315,284.03
-2,922.27
Sale
01/26/2023
3137EAER6
1,310,000.00
FHLMC Note
0.375%
Due
5/5/2023
98.815
2.14%
1,294,476.50
1,105.31
1,295,581.81
-9,352.02
Sale
01/26/2023
90CASH$00
435,562.94
Cash Custodial Cash Account
1.000
435,562.94
0.00 435,562.94
0.00 Sale
02/22/2023
912828ZH6
2,200,000.00
US Treasury Note
0.25%
Due
4/15/2023
99.359
1.90%
2,185,906.25
1,964.29
2,187,870.54
-9,002.42
Sale
02/23/2023
02665WBP5
1,300,000.00
American Honda Finance Note
2.9%
Due
2/16/2024
97.873
3.02%
1,272,349.00
733.06
1,273,082.06
-26,126.16
Sale
02/23/2023
90CASH$00
2,214,031.58
Cash Custodial Cash Account
1.000
2,214,031.58
0.00 2,214,031.58
0.00
Chandler Asset Management - CONFIDENTIAL
Execution Time: 6/6/2023 10:32:25 AM
Transaction Ledger
As of May 31, 2023
City of Salinas Consolidated
Account #10951
Transaction
Type
Settlement
Date
CUSIP
Quantity
Security Description
Price
Acq/Disp
Yield
Amount
Interest
Pur/Sold
Total Amount
Gain/Loss
DISPOSITIONS
Sale
03/13/2023
90CASH$00
1,250,882.39
Cash Custodial Cash Account
1.000
1,250,882.39
0.00 1,250,882.39
0.00 Sale
04/25/2023
90CASH$00
23,588.04
Cash Custodial Cash Account
1.000
23,588.04
0.00 23,588.04
0.00 Sale
04/25/2023
912828ZU7
2,200,000.00
US Treasury Note
0.25%
Due
6/15/2023
99.340
2.19%
2,185,476.56
1,979.40
2,187,455.96
-8,664.78
Sale
05/17/2023
90CASH$00
289,765.10
Cash Custodial Cash Account
1.000
289,765.10
0.00 289,765.10
0.00 Sale
05/24/2023
90CASH$00
194,842.04
Cash Custodial Cash Account
1.000
194,842.04
0.00 194,842.04
0.00 Sale
05/24/2023
912828ZY9
2,200,000.00
US Treasury Note
0.125%
Due
7/15/2023
99.250
2.15%
2,183,500.00
979.97
2,184,479.97
-10,250.31
Subtotal
24,820,017.75
24,729,191.06
24,581.06
24,753,772.12
-66,317.96
Maturity
07/14/2022
912796K57
2,000,000.00
US Treasury Bill
0.755%
Due
7/14/2022
100.000
2,000,000.00
0.00 2,000,000.00
0.00 Maturity
07/26/2022
38148PLT2
250,000.00
Goldman Sachs Negotiable CD
2.3%
Due
7/26/2022
100.000
250,000.00
0.00 250,000.00
0.00 Maturity
08/15/2022
912828YA2
2,200,000.00
US Treasury Note
1.5%
Due
8/15/2022
100.000
2,200,000.00
0.00 2,200,000.00
0.00 Maturity
08/16/2022
87270LAJ2
250,000.00
TIAA FSB Negotiable CD
2.2%
Due
8/16/2022
100.000
250,000.00
0.00 250,000.00
0.00 Maturity
09/15/2022
912796U49
2,100,000.00
US Treasury Bill
1.59%
Due
9/15/2022
100.000
2,100,000.00
0.00 2,100,000.00
0.00 Maturity
09/23/2022
06417MRR8
1,300,000.00
Bank of Nova Scotia Houston Yankee CD
0.2%
Due
9/23/2022
100.000
1,300,000.00
2,607.22
1,302,607.22
0.00 Maturity
10/20/2022
89114WJB2
1,300,000.00
Toronto Dominion Yankee CD
0.27%
Due
10/20/2022
100.000
1,300,000.00
3,549.00
1,303,549.00
0.00 Maturity
11/15/2022
62479MLF8
1,300,000.00
MUFG Bank Ltd/NY Discount CP
1.97%
Due
11/15/2022
99.015
1,300,000.00
0.00 1,300,000.00
0.00 Maturity
11/30/2022
62384RAD8
250,000.00
MOUNTAIN AMERICA FD CRED
Negotiable CD
2.4%
Due
11/30/2022
100.000
250,000.00
0.00 250,000.00
0.00 Maturity
12/15/2022
912828YW4
2,100,000.00
US Treasury Note
1.625%
Due
12/15/2022
100.000
2,100,000.00
0.00 2,100,000.00
0.00
Chandler Asset Management - CONFIDENTIAL
Execution Time: 6/6/2023 10:32:25 AM
Transaction Ledger
As of May 31, 2023
City of Salinas Consolidated
Account #10951
Transaction
Type
Settlement
Date
CUSIP
Quantity
Security Description
Price
Acq/Disp
Yield
Amount
Interest
Pur/Sold
Total Amount
Gain/Loss
DISPOSITIONS
Maturity
01/11/2023
61747MF63
250,000.00
Morgan Stanley Bank Negotiable CD
2.65%
Due
1/11/2023
100.000
250,000.00
0.00 250,000.00
0.00 Maturity
03/13/2023
00440EAP2
1,300,000.00
Chubb INA Holdings Inc Note
2.7%
Due
3/13/2023
100.000
1,300,000.00
0.00 1,300,000.00
0.00 Subtotal
14,600,000.00
14,600,000.00
6,156.22
14,606,156.22
0.00 Security
Withdrawal
07/07/2022
90CASH$00
13,000.00
Cash Custodial Cash Account
1.000
13,000.00
0.00 13,000.00
0.00 Security
Withdrawal
07/11/2022
90CASH$00
13,410.27
Cash Custodial Cash Account
1.000
13,410.27
0.00 13,410.27
0.00 Security
Withdrawal
07/13/2022
90CASH$00
24,787.50
Cash Custodial Cash Account
1.000
24,787.50
0.00 24,787.50
0.00 Security
Withdrawal
07/14/2022
90CASH$00
15,683.91
Cash Custodial Cash Account
1.000
15,683.91
0.00 15,683.91
0.00 Security
Withdrawal
07/15/2022
90CASH$00
10,930.65
Cash Custodial Cash Account
1.000
10,930.65
0.00 10,930.65
0.00 Security
Withdrawal
07/18/2022
90CASH$00
698.63
Cash Custodial Cash Account
1.000
698.63
0.00 698.63
0.00 Security
Withdrawal
07/26/2022
90CASH$00
252,851.37
Cash Custodial Cash Account
1.000
252,851.37
0.00 252,851.37
0.00 Security
Withdrawal
07/28/2022
90CASH$00
729.45
Cash Custodial Cash Account
1.000
729.45
0.00 729.45
0.00 Security
Withdrawal
08/01/2022
90CASH$00
16,250.00
Cash Custodial Cash Account
1.000
16,250.00
0.00 16,250.00
0.00 Security
Withdrawal
08/09/2022
90CASH$00
141,565.06
Cash Custodial Cash Account
1.000
141,565.06
0.00 141,565.06
0.00 Security
Withdrawal
08/11/2022
90CASH$00
1,363.70
Cash Custodial Cash Account
1.000
1,363.70
0.00 1,363.70
0.00 Security
Withdrawal
08/12/2022
90CASH$00
10,500.00
Cash Custodial Cash Account
1.000
10,500.00
0.00 10,500.00
0.00 Security
Withdrawal
08/15/2022
90CASH$00
2,276,634.59
Cash Custodial Cash Account
1.000
2,276,634.59
0.00 2,276,634.59
0.00
Chandler Asset Management - CONFIDENTIAL
Execution Time: 6/6/2023 10:32:25 AM
Transaction Ledger
As of May 31, 2023
City of Salinas Consolidated
Account #10951
Transaction
Type
Settlement
Date
CUSIP
Quantity
Security Description
Price
Acq/Disp
Yield
Amount
Interest
Pur/Sold
Total Amount
Gain/Loss
DISPOSITIONS
Security
Withdrawal
08/15/2022
90CASH$00
76,634.59
Cash Custodial Cash Account
1.000
76,634.59
0.00 76,634.59
0.00 Security
Withdrawal
08/16/2022
90CASH$00
272,299.32
Cash Custodial Cash Account
1.000
272,299.32
0.00 272,299.32
0.00 Security
Withdrawal
08/24/2022
90CASH$00
5,250.00
Cash Custodial Cash Account
1.000
5,250.00
0.00 5,250.00
0.00 Security
Withdrawal
08/25/2022
90CASH$00
3,000.00
Cash Custodial Cash Account
1.000
3,000.00
0.00 3,000.00
0.00 Security
Withdrawal
08/29/2022
90CASH$00
753.77
Cash Custodial Cash Account
1.000
753.77
0.00 753.77
0.00 Security
Withdrawal
09/06/2022
90CASH$00
23,075.00
Cash Custodial Cash Account
1.000
23,075.00
0.00 23,075.00
0.00 Security
Withdrawal
09/07/2022
90CASH$00
13,812.50
Cash Custodial Cash Account
1.000
13,812.50
0.00 13,812.50
0.00 Security
Withdrawal
09/08/2022
90CASH$00
36,562.50
Cash Custodial Cash Account
1.000
36,562.50
0.00 36,562.50
0.00 Security
Withdrawal
09/13/2022
90CASH$00
17,550.00
Cash Custodial Cash Account
1.000
17,550.00
0.00 17,550.00
0.00 Security
Withdrawal
09/15/2022
90CASH$00
2,126,384.59
Cash Custodial Cash Account
1.000
2,126,384.59
0.00 2,126,384.59
0.00 Security
Withdrawal
09/16/2022
90CASH$00
721.92
Cash Custodial Cash Account
1.000
721.92
0.00 721.92
0.00 Security
Withdrawal
12/05/2022
90CASH$00
31,652.99
Cash Custodial Cash Account
1.000
31,652.99
0.00 31,652.99
0.00 Security
Withdrawal
12/23/2022
90CASH$00
3,500.00
Cash Custodial Cash Account
1.000
3,500.00
0.00 3,500.00
0.00 Security
Withdrawal
12/28/2022
90CASH$00
20,013.83
Cash Custodial Cash Account
1.000
20,013.83
0.00 20,013.83
0.00
Chandler Asset Management - CONFIDENTIAL
Execution Time: 6/6/2023 10:32:25 AM
Transaction Ledger
As of May 31, 2023
City of Salinas Consolidated
Account #10951
Transaction
Type
Settlement
Date
CUSIP
Quantity
Security Description
Price
Acq/Disp
Yield
Amount
Interest
Pur/Sold
Total Amount
Gain/Loss
DISPOSITIONS
Security
Withdrawal
04/27/2023
90CASH$00
37,176.92
Cash Custodial Cash Account
1.000
37,176.92
0.00 37,176.92
0.00 Security
Withdrawal
05/05/2023
90CASH$00
6,267.12
Cash Custodial Cash Account
1.000
6,267.12
0.00 6,267.12
0.00 Subtotal
5,453,060.18
5,453,060.18
0.00 5,453,060.18
0.00 TOTAL DISPOSITIONS
37,465,448.29
37,374,621.60
30,737.28
37,405,358.88
-66,317.96
Chandler Asset Management - CONFIDENTIAL
Execution Time: 6/6/2023 10:32:25 AM