4XDUWHUO\,QYHVWPHQWTransactions 5HSRUW
California
EXHIBIT 1
City of Alameda
Finance Department
2263 Santa Clara Avenue, Room 220
Alameda, California 94501
(510) 747-4881
September 17, 2024
Honorable Mayor and City Council:
I have reviewed the City of Alameda’s Investment Transactions Report for the Quarter E nding June 30, 2024 and Annual Investment Report for the Fiscal Year Ending June 30, 2024.
The City’s Investment Portfolio is in compliance with its statement of Investment Policy as established by my office.
I can confirm that as of June 30, 2024, the City of Alameda has sufficient funds to meet its pool’s expenditure requirements for the next six months.
Sincerely,
Kevin Kennedy
City Treasurer
CHANDLER ASSET MANAGEMENT, INC. | 800.317.4747 | www.chandlerasset.com
INVESTMENT REPORT
City of Alameda
Investment Transactions Reporting
For the Quarter Ending June 30, 2024
MONTHLY ACCOUNT STATEMENT
City of Alameda | Account #270 | 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 | 14
City of Alameda | Account #270 | As of April 30, 2024
Execution Time: 05/02/2024 11:25:00 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 316175603 6,960.00 FIDELITY IMM:GOVT III 1.000 4.97% (6,960.00) 0.00 (6,960.00) 0.00 Purchase 04/01/2024 316175603 20,234.38 FIDELITY IMM:GOVT III 1.000 4.97% (20,234.38) 0.00 (20,234.38) 0.00 Purchase 04/01/2024 316175603 1,643.26 FIDELITY IMM:GOVT III 1.000 4.97% (1,643.26) 0.00 (1,643.26) 0.00 Purchase 04/01/2024 316175603 40,181.25 FIDELITY IMM:GOVT III 1.000 4.97% (40,181.25) 0.00 (40,181.25) 0.00 Purchase 04/15/2024 316175603 6,709.50 FIDELITY IMM:GOVT III 1.000 4.94% (6,709.50) 0.00 (6,709.50) 0.00 Purchase 04/15/2024 316175603 108,642.28 FIDELITY IMM:GOVT III 1.000 4.94% (108,642.28) 0.00 (108,642.28) 0.00 Purchase 04/16/2024 316175603 5,753.67 FIDELITY IMM:GOVT III 1.000 4.95% (5,753.67) 0.00 (5,753.67) 0.00 Purchase 04/16/2024 316175603 5,813.18 FIDELITY IMM:GOVT III 1.000 4.95% (5,813.18) 0.00 (5,813.18) 0.00 Purchase 04/19/2024 91282CKG5 1,000,000.00 UNITED STATES TREASURY
4.125 03/31/2029 97.582 4.68% (975,820.31) (2,141.39) (977,961.70) 0.00 Purchase 04/19/2024 3133ERAK7 1,000,000.00
FEDERAL FARM CREDIT
BANKS FUNDING CORP 4.375
04/10/2029
98.433 4.73% (984,330.00) (1,093.75) (985,423.75) 0.00
Purchase 04/22/2024 316175603 4,437.22 FIDELITY IMM:GOVT III 1.000 4.93% (4,437.22) 0.00 (4,437.22) 0.00 Purchase 04/22/2024 316175603 2,275.00 FIDELITY IMM:GOVT III 1.000 4.93% (2,275.00) 0.00 (2,275.00) 0.00 Purchase 04/22/2024 316175603 50,526.82 FIDELITY IMM:GOVT III 1.000 4.93% (50,526.82) 0.00 (50,526.82) 0.00 Purchase 04/23/2024 316175603 7,118.00 FIDELITY IMM:GOVT III 1.000 4.95% (7,118.00) 0.00 (7,118.00) 0.00 Purchase 04/23/2024 02582JKH2 195,000.00 AMXCA 2024-1 A 5.23 04/16/2029 99.980 5.30% (194,960.03) 0.00 (194,960.03) 0.00 Purchase 04/25/2024 316175603 10,567.68 FIDELITY IMM:GOVT III 1.000 4.95% (10,567.68) 0.00 (10,567.68) 0.00 Purchase 04/29/2024 316175603 1,175.00 FIDELITY IMM:GOVT III 1.000 4.96% (1,175.00) 0.00 (1,175.00) 0.00 Purchase 04/29/2024 316175603 6,017.00 FIDELITY IMM:GOVT III 1.000 4.96% (6,017.00) 0.00 (6,017.00) 0.00 Purchase 04/30/2024 316175603 19,087.50 FIDELITY IMM:GOVT III 1.000 4.95% (19,087.50) 0.00 (19,087.50) 0.00 Total Purchase 2,492,141.74 (2,452,252.08) (3,235.14) (2,455,487.22) 0.00 TOTAL ACQUISITIONS 2,492,141.74 (2,452,252.08) (3,235.14) (2,455,487.22) 0.00
DISPOSITIONS
Sale 04/19/2024 912828ZC7 (900,000.00) UNITED STATES TREASURY
1.125 02/28/2025 96.582 0.81% 869,238.28 (1,375.68) 870,613.96 (33,182.48) Sale 04/19/2024 3135G0X24 (965,000.00)
FEDERAL NATIONAL
MORTGAGE ASSOCIATION
1.625 01/07/2025
97.405 1.69% 939,958.25 (4,443.02) 944,401.27 (27,995.95) CONFIDENTIAL | 15
City of Alameda | Account #270 | As of April 30, 2024
Execution Time: 05/02/2024 11:25:00 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
Sale 04/19/2024 316175603 (148,370.22) FIDELITY IMM:GOVT III 1.000 4.95% 148,370.22 0.00 148,370.22 0.00 Sale 04/23/2024 316175603 (194,960.03) FIDELITY IMM:GOVT III 1.000 4.95% 194,960.03 0.00 194,960.03 0.00 Total Sale (2,208,330.25) 2,152,526.78 (5,818.70) 2,158,345.48 (61,178.43) TOTAL DISPOSITIONS (2,208,330.25) 2,152,526.78 (5,818.70) 2,158,345.48 (61,178.43) OTHER
TRANSACTIONS
Coupon 04/01/2024 13063DRK6 0.00 CALIFORNIA STATE 2.4
10/01/2024 1.92% 6,960.00 0.00 6,960.00 0.00
Coupon 04/14/2024 78016EZ59 0.00 ROYAL BANK OF CANADA 3.375 04/14/2025 3.39% 4,387.50 0.00 4,387.50 0.00
Coupon 04/15/2024 89240BAC2 0.00 TAOT 2021-A A3 0.26
05/15/2025 0.29% 7.03 0.00 7.03 0.00
Coupon 04/15/2024 47788UAC6 0.00 JDOT 2021 A3 0.36 09/15/2025 0.38% 9.77 0.00 9.77 0.00 Coupon 04/15/2024 47789QAC4 0.00 JDOT 2021-B A3 0.52
03/16/2026 0.53% 40.76 0.00 40.76 0.00
Coupon 04/15/2024 89238JAC9 0.00 TAOT 2021-D A3 0.71
04/15/2026 0.71% 51.25 0.00 51.25 0.00
Coupon 04/15/2024 44935FAD6 0.00 HART 2021-C A3 0.74
05/15/2026 0.76% 39.38 0.00 39.38 0.00
Coupon 04/15/2024 02582JJR2 0.00 AMXCA 2021-1 A 0.9
11/15/2024 5.60% 206.25 0.00 206.25 0.00
Coupon 04/15/2024 43815BAC4 0.00 HAROT 2022-1 A3 1.88
05/15/2026 1.90% 335.68 0.00 335.68 0.00
Coupon 04/15/2024 448977AD0 0.00 HART 2022-A A3 2.22
10/15/2026 2.23% 651.95 0.00 651.95 0.00
Coupon 04/15/2024 47787JAC2 0.00 JDOT 2022 A3 0.36 09/15/2026 2.35% 221.50 0.00 221.50 0.00 Coupon 04/15/2024 89238FAD5 0.00 TAOT 2022-B A3 2.93
09/15/2026 2.95% 306.97 0.00 306.97 0.00
Coupon 04/15/2024 02582JJT8 0.00 AMXCA 2022-2 A 05/17/2027 3.42% 1,271.25 0.00 1,271.25 0.00 Coupon 04/15/2024 47800AAC4 0.00 JDOT 2022-B A3 3.74
02/16/2027 3.77% 670.08 0.00 670.08 0.00
Coupon 04/15/2024 47800CAC0 0.00 JDOT 2023 A3 5.01 11/15/2027 5.04% 835.00 0.00 835.00 0.00 CONFIDENTIAL | 16
City of Alameda | Account #270 | As of April 30, 2024
Execution Time: 05/02/2024 11:25:00 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 161571HT4 0.00 CHAIT 2023-1 A 5.16
09/15/2028 5.23% 2,322.00 0.00 2,322.00 0.00
Coupon 04/15/2024 437918AC9 0.00 HAROT 2024-1 A3 5.21
08/15/2028 5.27% 2,062.29 0.00 2,062.29 0.00
Coupon 04/15/2024 448973AD9 0.00 HART 2024-A A3 4.99
02/15/2029 5.05% 710.38 0.00 710.38 0.00
Coupon 04/16/2024 362554AC1 0.00 GMCAR 2021-4 A3 0.68
09/16/2026 0.68% 41.38 0.00 41.38 0.00
Coupon 04/16/2024 380146AC4 0.00 GMCAR 2022-1 A3 1.26
11/16/2026 1.27% 79.31 0.00 79.31 0.00
Coupon 04/20/2024 4581X0DV7 0.00
INTER-AMERICAN
DEVELOPMENT BANK 0.875
04/20/2026
0.97% 2,275.00 0.00 2,275.00 0.00
Coupon 04/20/2024 36265MAC9 0.00 GMALT 2022-1 A3 1.9
03/20/2025 0.00% 60.38 0.00 60.38 0.00
Coupon 04/20/2024 36269FAD8 0.00 GMALT 2024-1 A3 5.09
03/22/2027 5.15% 1,230.08 0.00 1,230.08 0.00
Coupon 04/21/2024 43813GAC5 0.00 HAROT 2021-1 A3 0.27
04/21/2025 0.27% 1.84 0.00 1.84 0.00
Coupon 04/21/2024 43815GAC3 0.00 HAROT 2021-4 A3 0.88
01/21/2026 0.90% 65.75 0.00 65.75 0.00
Coupon 04/22/2024 46647PBK1 0.00 JPMORGAN CHASE & CO 2.083 04/22/2026 1.11% 1,749.72 0.00 1,749.72 0.00
Coupon 04/22/2024 3135G03U5 0.00
FEDERAL NATIONAL
MORTGAGE ASSOCIATION
0.625 04/22/2025
0.67% 2,687.50 0.00 2,687.50 0.00
Coupon 04/23/2024 06051GHT9 0.00 BANK OF AMERICA CORP 3.559 04/23/2027 4.29% 7,118.00 0.00 7,118.00 0.00
Coupon 04/25/2024 05602RAD3 0.00 BMWOT 2022-A A3 3.21
08/25/2026 3.23% 371.81 0.00 371.81 0.00
Coupon 04/28/2024 6174468Q5 0.00 MORGAN STANLEY 2.188
04/28/2026 3.78% 6,017.00 0.00 6,017.00 0.00
Coupon 04/28/2024 459058JL8 0.00
INTERNATIONAL BANK FOR
RECONSTRUCTION AND
DEVELOPM 0.5 10/28/2025
0.52% 1,175.00 0.00 1,175.00 0.00
CONFIDENTIAL | 17
City of Alameda | Account #270 | As of April 30, 2024
Execution Time: 05/02/2024 11:25:00 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/30/2024 91282CAT8 0.00 UNITED STATES TREASURY 0.25 10/31/2025 0.50% 1,375.00 0.00 1,375.00 0.00
Coupon 04/30/2024 91282CDG3 0.00 UNITED STATES TREASURY
1.125 10/31/2026 1.25% 2,868.75 0.00 2,868.75 0.00
Coupon 04/30/2024 91282CHA2 0.00 UNITED STATES TREASURY 3.5 04/30/2028 3.42% 8,750.00 0.00 8,750.00 0.00
Coupon 04/30/2024 91282CJF9 0.00 UNITED STATES TREASURY
4.875 10/31/2028 4.83% 6,093.75 0.00 6,093.75 0.00
Total Coupon 0.00 63,049.31 0.00 63,049.31 0.00
Dividend 04/30/2024 316175603 0.00 FIDELITY IMM:GOVT III 4.95% 1,796.57 0.00 1,796.57 0.00 Total Dividend 0.00 1,796.57 0.00 1,796.57 0.00
Principal Paydown 04/15/2024 89240BAC2 14,625.88 TAOT 2021-A A3 0.26 05/15/2025 0.29% 14,625.88 -- 14,625.88 (0.00)
Principal Paydown 04/15/2024 47788UAC6 5,039.49 JDOT 2021 A3 0.36 09/15/2025 0.38% 5,039.49 -- 5,039.49 0.00 Principal Paydown 04/15/2024 47789QAC4 9,874.71 JDOT 2021-B A3 0.52 03/16/2026 0.53% 9,874.71 -- 9,874.71 0.00
Principal Paydown 04/15/2024 89238JAC9 7,584.24 TAOT 2021-D A3 0.71 04/15/2026 0.71% 7,584.24 -- 7,584.24 0.00
Principal Paydown 04/15/2024 44935FAD6 6,500.26 HART 2021-C A3 0.74 05/15/2026 0.76% 6,500.26 -- 6,500.26 0.00
Principal Paydown 04/15/2024 43815BAC4 16,161.14 HAROT 2022-1 A3 1.88 05/15/2026 1.90% 16,161.14 -- 16,161.14 (0.00)
Principal Paydown 04/15/2024 448977AD0 25,822.22 HART 2022-A A3 2.22 10/15/2026 2.23% 25,822.22 -- 25,822.22 (0.00)
Principal Paydown 04/15/2024 47787JAC2 7,493.58 JDOT 2022 A3 0.36 09/15/2026 2.35% 7,493.58 -- 7,493.58 0.00 Principal Paydown 04/15/2024 89238FAD5 8,121.22 TAOT 2022-B A3 2.93 09/15/2026 2.95% 8,121.22 -- 8,121.22 (0.00)
Principal Paydown 04/16/2024 362554AC1 5,753.67 GMCAR 2021-4 A3 0.68 09/16/2026 0.68% 5,753.67 -- 5,753.67 (0.00)
Principal Paydown 04/16/2024 380146AC4 5,692.49 GMCAR 2022-1 A3 1.26 11/16/2026 1.27% 5,692.49 -- 5,692.49 0.00
Principal Paydown 04/20/2024 36265MAC9 37,050.30 GMALT 2022-1 A3 1.9 03/20/2025 0.00% 37,050.30 -- 37,050.30 (0.00)
CONFIDENTIAL | 18
City of Alameda | Account #270 | As of April 30, 2024
Execution Time: 05/02/2024 11:25:00 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
Principal Paydown 04/21/2024 43813GAC5 4,040.21 HAROT 2021-1 A3 0.27 04/21/2025 0.27% 4,040.21 -- 4,040.21 (0.00)
Principal Paydown 04/21/2024 43815GAC3 8,078.26 HAROT 2021-4 A3 0.88 01/21/2026 0.90% 8,078.26 -- 8,078.26 (0.00)
Principal Paydown 04/25/2024 05602RAD3 10,195.87 BMWOT 2022-A A3 3.21 08/25/2026 3.23% 10,195.87 -- 10,195.87 (0.00)
Total Principal
Paydown 172,033.54 172,033.54 -- 172,033.54 (0.01)
TOTAL OTHER
TRANSACTIONS 172,033.54 236,879.42 0.00 236,879.42 (0.01)
MONTHLY ACCOUNT STATEMENT
City of Alameda | Account #270 | As of May 31, 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 | 15
City of Alameda | Account #270 | As of May 31, 2024
Execution Time: 06/04/2024 07:41:42 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
TRANSACTION LEDGER
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 05/01/2024 316175603 4,153.25 FIDELITY IMM:GOVT III 1.000 4.95% (4,153.25) 0.00 (4,153.25) 0.00 Purchase 05/01/2024 316175603 1,796.57 FIDELITY IMM:GOVT III 1.000 4.95% (1,796.57) 0.00 (1,796.57) 0.00 Purchase 05/01/2024 316175603 6,093.75 FIDELITY IMM:GOVT III 1.000 4.95% (6,093.75) 0.00 (6,093.75) 0.00 Purchase 05/07/2024 316175603 2,562.50 FIDELITY IMM:GOVT III 1.000 4.94% (2,562.50) 0.00 (2,562.50) 0.00 Purchase 05/10/2024 316175603 10,400.00 FIDELITY IMM:GOVT III 1.000 4.94% (10,400.00) 0.00 (10,400.00) 0.00 Purchase 05/13/2024 316175603 6,652.50 FIDELITY IMM:GOVT III 1.000 4.94% (6,652.50) 0.00 (6,652.50) 0.00 Purchase 05/15/2024 316175603 144,206.03 FIDELITY IMM:GOVT III 1.000 4.94% (144,206.03) 0.00 (144,206.03) 0.00 Purchase 05/16/2024 316175603 5,426.79 FIDELITY IMM:GOVT III 1.000 4.94% (5,426.79) 0.00 (5,426.79) 0.00 Purchase 05/16/2024 316175603 5,738.04 FIDELITY IMM:GOVT III 1.000 4.94% (5,738.04) 0.00 (5,738.04) 0.00 Purchase 05/16/2024 36269WAD1 185,000.00 GMALT 2024-2 A3 5.39 07/20/2027 99.994 5.85% (184,989.25) 0.00 (184,989.25) 0.00 Purchase 05/20/2024 316175603 1,231.80 FIDELITY IMM:GOVT III 1.000 4.95% (1,231.80) 0.00 (1,231.80) 0.00 Purchase 05/20/2024 316175603 1,086.34 FIDELITY IMM:GOVT III 1.000 4.95% (1,086.34) 0.00 (1,086.34) 0.00 Purchase 05/21/2024 316175603 11,841.87 FIDELITY IMM:GOVT III 1.000 4.94% (11,841.87) 0.00 (11,841.87) 0.00 Purchase 05/21/2024 437930AC4 175,000.00 HONDO-242-A3 5.27 11/20/2028 99.988 5.27% (174,978.74) 0.00 (174,978.74) 0.00 Purchase 05/23/2024 437076CW0 470,000.00 HOME DEPOT INC 4.9 04/15/2029 100.247 4.84% (471,158.75) (2,430.94) (473,589.69) 0.00 Purchase 05/23/2024 437076CW0 165,000.00 HOME DEPOT INC 4.9 04/15/2029 100.202 4.85% (165,333.30) (853.42) (166,186.72) 0.00 Purchase 05/23/2024 316175603 56,774.68 FIDELITY IMM:GOVT III 1.000 4.95% (56,774.68) 0.00 (56,774.68) 0.00 Purchase 05/23/2024 58770JAD6 135,000.00 MBALT 2024-A A3 5.32 01/18/2028 99.988 5.73% (134,984.21) 0.00 (134,984.21) 0.00 Purchase 05/28/2024 316175603 10,280.37 FIDELITY IMM:GOVT III 1.000 4.95% (10,280.37) 0.00 (10,280.37) 0.00 Purchase 05/31/2024 316175603 26,750.00 FIDELITY IMM:GOVT III 1.000 4.96% (26,750.00) 0.00 (26,750.00) 0.00 Total Purchase 1,424,994.49 (1,426,438.74) (3,284.36) (1,429,723.10) 0.00 TOTAL
ACQUISITIONS 1,424,994.49 (1,426,438.74) (3,284.36) (1,429,723.10) 0.00
DISPOSITIONS
Sale 05/16/2024 316175603 (184,989.25) FIDELITY IMM:GOVT III 1.000 4.94% 184,989.25 0.00 184,989.25 0.00 CONFIDENTIAL | 16
City of Alameda | Account #270 | As of May 31, 2024
Execution Time: 06/04/2024 07:41:42 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
TRANSACTION LEDGER
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
Sale 05/21/2024 316175603 (174,978.74) FIDELITY IMM:GOVT III 1.000 4.94% 174,978.74 0.00 174,978.74 0.00 Sale 05/23/2024 13063DRK6 (580,000.00) CALIFORNIA STATE 2.4 10/01/2024 98.862 1.92% 573,399.60 (2,010.67) 575,410.27 (7,567.84) Sale 05/23/2024 78016EZ59 (260,000.00) ROYAL BANK OF CANADA
3.375 04/14/2025 98.144 3.39% 255,174.40 (950.63) 256,125.03 (4,796.99) Total Sale (1,199,967.99) 1,188,541.99 (2,961.30) 1,191,503.29 (12,364.83) TOTAL
DISPOSITIONS (1,199,967.99) 1,188,541.99 (2,961.30) 1,191,503.29 (12,364.83) OTHER
Coupon 05/01/2024 06367WB85 0.00 BANK OF MONTREAL 1.85
05/01/2025 0.86% 4,153.25 0.00 4,153.25 0.00
Coupon 05/01/2024 3133EPA47 0.00
FEDERAL FARM CREDIT
BANKS FUNDING CORP
4.875 11/01/2028
4.49% 6,093.75 0.00 6,093.75 0.00
Coupon 05/07/2024 3135G06G3 0.00
FEDERAL NATIONAL
MORTGAGE ASSOCIATION
0.5 11/07/2025
0.56% 2,562.50 0.00 2,562.50 0.00
Coupon 05/10/2024 665859AW4 0.00 NORTHERN TRUST CORP
4.0 05/10/2027 3.88% 10,400.00 0.00 10,400.00 0.00
Coupon 05/12/2024 023135BX3 0.00 AMAZON.COM INC 1.0
05/12/2026 1.09% 3,950.00 0.00 3,950.00 0.00
Coupon 05/13/2024 808513BR5 0.00 CHARLES SCHWAB CORP
1.15 05/13/2026 1.48% 2,702.50 0.00 2,702.50 0.00
Coupon 05/15/2024 89240BAC2 0.00 TAOT 2021-A A3 0.26
05/15/2025 0.30% 3.86 0.00 3.86 0.00
Coupon 05/15/2024 47788UAC6 0.00 JDOT 2021 A3 0.36
09/15/2025 0.38% 8.26 0.00 8.26 0.00
Coupon 05/15/2024 91324PEC2 0.00 UNITEDHEALTH GROUP
INC 1.15 05/15/2026 1.09% 3,622.50 0.00 3,622.50 0.00
Coupon 05/15/2024 47789QAC4 0.00 JDOT 2021-B A3 0.52
03/16/2026 0.53% 36.48 0.00 36.48 0.00
Coupon 05/15/2024 89238JAC9 0.00 TAOT 2021-D A3 0.71
04/15/2026 0.71% 46.77 0.00 46.77 0.00
CONFIDENTIAL | 17
City of Alameda | Account #270 | As of May 31, 2024
Execution Time: 06/04/2024 07:41:42 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
TRANSACTION LEDGER
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
Coupon 05/15/2024 44935FAD6 0.00 HART 2021-C A3 0.74
05/15/2026 0.76% 35.37 0.00 35.37 0.00
Coupon 05/15/2024 02582JJR2 0.00 AMXCA 2021-1 A 0.9
11/15/2024 5.61% 206.25 0.00 206.25 0.00
Coupon 05/15/2024 43815BAC4 0.00 HAROT 2022-1 A3 1.88
05/15/2026 1.90% 310.36 0.00 310.36 0.00
Coupon 05/15/2024 448977AD0 0.00 HART 2022-A A3 2.22
10/15/2026 2.23% 604.18 0.00 604.18 0.00
Coupon 05/15/2024 47787JAC2 0.00 JDOT 2022 A3 0.36
09/15/2026 2.35% 207.01 0.00 207.01 0.00
Coupon 05/15/2024 89238FAD5 0.00 TAOT 2022-B A3 2.93
09/15/2026 2.95% 287.14 0.00 287.14 0.00
Coupon 05/15/2024 02582JJT8 0.00 AMXCA 2022-2 A
05/17/2027 3.42% 1,271.25 0.00 1,271.25 0.00
Coupon 05/15/2024 47800AAC4 0.00 JDOT 2022-B A3 3.74
02/16/2027 3.77% 670.08 0.00 670.08 0.00
Coupon 05/15/2024 47800CAC0 0.00 JDOT 2023 A3 5.01
11/15/2027 5.04% 835.00 0.00 835.00 0.00
Coupon 05/15/2024 341081GN1 0.00 FLORIDA POWER & LIGHT
CO 4.4 05/15/2028 4.68% 8,800.00 0.00 8,800.00 0.00
Coupon 05/15/2024 161571HT4 0.00 CHAIT 2023-1 A 5.16
09/15/2028 5.23% 2,322.00 0.00 2,322.00 0.00
Coupon 05/15/2024 437918AC9 0.00 HAROT 2024-1 A3 5.21
08/15/2028 5.27% 2,062.29 0.00 2,062.29 0.00
Coupon 05/15/2024 448973AD9 0.00 HART 2024-A A3 4.99
02/15/2029 5.05% 852.46 0.00 852.46 0.00
Coupon 05/15/2024 02582JKH2 0.00 AMXCA 2024-1 A 5.23
04/16/2029 5.29% 623.24 0.00 623.24 0.00
Coupon 05/16/2024 362554AC1 0.00 GMCAR 2021-4 A3 0.68
09/16/2026 0.68% 38.12 0.00 38.12 0.00
Coupon 05/16/2024 380146AC4 0.00 GMCAR 2022-1 A3 1.26
11/16/2026 1.27% 73.33 0.00 73.33 0.00
Coupon 05/20/2024 36265MAC9 0.00 GMALT 2022-1 A3 1.9
03/20/2025 0.00% 1.72 0.00 1.72 0.00
CONFIDENTIAL | 18
City of Alameda | Account #270 | As of May 31, 2024
Execution Time: 06/04/2024 07:41:42 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
TRANSACTION LEDGER
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
Coupon 05/20/2024 36269FAD8 0.00 GMALT 2024-1 A3 5.09
03/22/2027 5.15% 1,230.08 0.00 1,230.08 0.00
Coupon 05/21/2024 43813GAC5 0.00 HAROT 2021-1 A3 0.27
04/21/2025 0.27% 0.93 0.00 0.93 0.00
Coupon 05/21/2024 43815GAC3 0.00 HAROT 2021-4 A3 0.88
01/21/2026 0.90% 59.82 0.00 59.82 0.00
Coupon 05/25/2024 05602RAD3 0.00 BMWOT 2022-A A3 3.21
08/25/2026 3.23% 344.54 0.00 344.54 0.00
Coupon 05/31/2024 91282CAZ4 0.00 UNITED STATES TREASURY
0.375 11/30/2025 0.76% 2,062.50 0.00 2,062.50 0.00
Coupon 05/31/2024 91282CET4 0.00 UNITED STATES TREASURY
2.625 05/31/2027 3.06% 6,562.50 0.00 6,562.50 0.00
Coupon 05/31/2024 91282CHE4 0.00 UNITED STATES TREASURY
3.625 05/31/2028 4.00% 18,125.00 0.00 18,125.00 0.00
Total Coupon 0.00 81,165.04 0.00 81,165.04 0.00
Dividend 05/31/2024 316175603 0.00 FIDELITY IMM:GOVT III 4.96% 1,365.87 0.00 1,365.87 0.00 Total Dividend 0.00 1,365.87 0.00 1,365.87 0.00
Principal
Paydown 05/15/2024 89240BAC2 14,104.13 TAOT 2021-A A3 0.26 05/15/2025 0.30% 14,104.13 -- 14,104.13 0.00
Principal
Paydown 05/15/2024 47788UAC6 6,795.26 JDOT 2021 A3 0.36 09/15/2025 0.38% 6,795.26 -- 6,795.26 0.00
Principal
Paydown 05/15/2024 47789QAC4 13,984.98 JDOT 2021-B A3 0.52 03/16/2026 0.53% 13,984.98 -- 13,984.98 (0.00)
Principal
Paydown 05/15/2024 89238JAC9 7,398.23 TAOT 2021-D A3 0.71 04/15/2026 0.71% 7,398.23 -- 7,398.23 0.00
Principal
Paydown 05/15/2024 44935FAD6 6,028.69 HART 2021-C A3 0.74 05/15/2026 0.76% 6,028.69 -- 6,028.69 (0.00)
Principal
Paydown 05/15/2024 43815BAC4 15,556.47 HAROT 2022-1 A3 1.88 05/15/2026 1.90% 15,556.47 -- 15,556.47 0.00
Principal
Paydown 05/15/2024 448977AD0 25,091.91 HART 2022-A A3 2.22 10/15/2026 2.23% 25,091.91 -- 25,091.91 (0.00)
Principal
Paydown 05/15/2024 47787JAC2 9,249.73 JDOT 2022 A3 0.36 09/15/2026 2.35% 9,249.73 -- 9,249.73 (0.00)
CONFIDENTIAL | 19
City of Alameda | Account #270 | As of May 31, 2024
Execution Time: 06/04/2024 07:41:42 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
TRANSACTION LEDGER
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
Principal
Paydown 05/15/2024 89238FAD5 8,150.07 TAOT 2022-B A3 2.93 09/15/2026 2.95% 8,150.07 -- 8,150.07 (0.00)
Principal
Paydown 05/15/2024 47800AAC4 15,042.06 JDOT 2022-B A3 3.74 02/16/2027 3.77% 15,042.06 -- 15,042.06 0.00
Principal
Paydown 05/16/2024 362554AC1 5,738.04 GMCAR 2021-4 A3 0.68 09/16/2026 0.68% 5,738.04 -- 5,738.04 (0.00)
Principal
Paydown 05/16/2024 380146AC4 5,315.34 GMCAR 2022-1 A3 1.26 11/16/2026 1.27% 5,315.34 -- 5,315.34 0.00
Principal
Paydown 05/20/2024 36265MAC9 1,086.34 GMALT 2022-1 A3 1.9 03/20/2025 0.00% 1,086.34 -- 1,086.34 (0.00)
Principal
Paydown 05/21/2024 43813GAC5 3,864.42 HAROT 2021-1 A3 0.27 04/21/2025 0.27% 3,864.42 -- 3,864.42 0.00
Principal
Paydown 05/21/2024 43815GAC3 7,916.70 HAROT 2021-4 A3 0.88 01/21/2026 0.90% 7,916.70 -- 7,916.70 (0.01)
Principal
Paydown 05/25/2024 05602RAD3 9,935.83 BMWOT 2022-A A3 3.21 08/25/2026 3.23% 9,935.83 -- 9,935.83 0.00
Total Principal
Paydown 155,258.20 155,258.20 -- 155,258.20 (0.01)
TOTAL OTHER
TRANSACTIONS 155,258.20 237,789.11 0.00 237,789.11 (0.01)
MONTHLY ACCOUNT STATEMENT
City of Alameda | Account #270 | As of June 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 | 14
City of Alameda | Account #270 | As of June 30, 2024
Execution Time: 07/03/2024 07:47:56 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
TRANSACTION LEDGER
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 06/03/2024 316175603 1,365.87 FIDELITY IMM:GOVT III 1.000 4.96% (1,365.87) 0.00 (1,365.87) 0.00 Purchase 06/10/2024 316175603 11,810.50 FIDELITY IMM:GOVT III 1.000 4.94% (11,810.50) 0.00 (11,810.50) 0.00 Purchase 06/10/2024 316175603 7,750.00 FIDELITY IMM:GOVT III 1.000 4.94% (7,750.00) 0.00 (7,750.00) 0.00 Purchase 06/11/2024 096919AD7 225,000.00 BMWOT 2024-A A3 5.18 02/26/2029 99.985 5.18% (224,965.82) 0.00 (224,965.82) 0.00 Purchase 06/17/2024 316175603 15,259.14 FIDELITY IMM:GOVT III 1.000 4.93% (15,259.14) 0.00 (15,259.14) 0.00 Purchase 06/17/2024 316175603 4,884.50 FIDELITY IMM:GOVT III 1.000 4.93% (4,884.50) 0.00 (4,884.50) 0.00 Purchase 06/17/2024 316175603 109,254.00 FIDELITY IMM:GOVT III 1.000 4.93% (109,254.00) 0.00 (109,254.00) 0.00 Purchase 06/17/2024 316175603 3,695.79 FIDELITY IMM:GOVT III 1.000 4.93% (3,695.79) 0.00 (3,695.79) 0.00 Purchase 06/18/2024 316175603 4,966.69 FIDELITY IMM:GOVT III 1.000 4.95% (4,966.69) 0.00 (4,966.69) 0.00 Purchase 06/20/2024 316175603 5,469.33 FIDELITY IMM:GOVT III 1.000 4.96% (5,469.33) 0.00 (5,469.33) 0.00 Purchase 06/21/2024 316175603 251.59 FIDELITY IMM:GOVT III 1.000 4.95% (251.59) 0.00 (251.59) 0.00 Purchase 06/21/2024 316175603 7,781.67 FIDELITY IMM:GOVT III 1.000 4.95% (7,781.67) 0.00 (7,781.67) 0.00 Purchase 06/25/2024 316175603 10,292.88 FIDELITY IMM:GOVT III 1.000 4.95% (10,292.88) 0.00 (10,292.88) 0.00 Purchase 06/27/2024 91282CKT7 800,000.00 UNITED STATES TREASURY
4.5 05/31/2029 100.715 4.34% (805,718.75) (2,655.74) (808,374.49) 0.00 Purchase 06/27/2024 3133ERGL9 1,000,000.00
FEDERAL FARM CREDIT
BANKS FUNDING CORP
4.5 06/07/2028
100.033 4.49% (1,000,330.00) (2,500.00) (1,002,830.00) 0.00 Purchase 06/27/2024 316175603 282,016.42 FIDELITY IMM:GOVT III 1.000 4.97% (282,016.42) 0.00 (282,016.42) 0.00 Total Purchase 2,489,798.38 (2,495,812.95) (5,155.74) (2,500,968.69) 0.00 TOTAL
ACQUISITIONS 2,489,798.38 (2,495,812.95) (5,155.74) (2,500,968.69) 0.00
DISPOSITIONS
Sale 06/11/2024 316175603 (224,965.82) FIDELITY IMM:GOVT III 1.000 4.94% 224,965.82 0.00 224,965.82 0.00 Sale 06/27/2024 3137EAEP0 (1,090,000.00)
FEDERAL HOME LOAN
MORTGAGE CORP 1.5
02/12/2025
97.669 1.52% 1,064,592.10 (6,131.25) 1,070,723.35 (25,302.13) Sale 06/27/2024 91282CED9 (250,000.00) UNITED STATES TREASURY
1.75 03/15/2025 97.574 2.70% 243,935.55 (1,236.41) 245,171.96 (4,427.28) CONFIDENTIAL | 15
City of Alameda | Account #270 | As of June 30, 2024
Execution Time: 07/03/2024 07:47:56 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
TRANSACTION LEDGER
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
Sale 06/27/2024 6174468Q5 (550,000.00) MORGAN STANLEY 2.188 04/28/2026 97.060 3.85% 533,830.00 (1,972.24) 535,802.24 (6,190.21) Sale 06/27/2024 316175603 (241,523.36) FIDELITY IMM:GOVT III 1.000 4.97% 241,523.36 0.00 241,523.36 0.00 Total Sale (2,356,489.18) 2,308,846.83 (9,339.90) 2,318,186.73 (35,919.62) TOTAL
DISPOSITIONS (2,356,489.18) 2,308,846.83 (9,339.90) 2,318,186.73 (35,919.62) OTHER
Coupon 06/08/2024 89115A2C5 0.00 TORONTO-DOMINION
BANK 4.108 06/08/2027 4.18% 11,810.50 0.00 11,810.50 0.00 Coupon 06/08/2024 3133EPME2 0.00
FEDERAL FARM CREDIT
BANKS FUNDING CORP
3.875 06/08/2028
3.96% 7,750.00 0.00 7,750.00 0.00
Coupon 06/15/2024 89240BAC2 0.00 TAOT 2021-A A3 0.26
05/15/2025 0.00% 0.80 0.00 0.80 0.00
Coupon 06/15/2024 47788UAC6 0.00 JDOT 2021 A3 0.36
09/15/2025 0.38% 6.22 0.00 6.22 0.00
Coupon 06/15/2024 47789QAC4 0.00 JDOT 2021-B A3 0.52
03/16/2026 0.53% 30.42 0.00 30.42 0.00
Coupon 06/15/2024 89238JAC9 0.00 TAOT 2021-D A3 0.71
04/15/2026 0.71% 42.39 0.00 42.39 0.00
Coupon 06/15/2024 44935FAD6 0.00 HART 2021-C A3 0.74
05/15/2026 0.76% 31.66 0.00 31.66 0.00
Coupon 06/15/2024 02582JJR2 0.00 AMXCA 2021-1 A 0.9
11/15/2024 5.59% 206.25 0.00 206.25 0.00
Coupon 06/15/2024 43815BAC4 0.00 HAROT 2022-1 A3 1.88
05/15/2026 1.90% 285.99 0.00 285.99 0.00
Coupon 06/15/2024 448977AD0 0.00 HART 2022-A A3 2.22
10/15/2026 2.23% 557.76 0.00 557.76 0.00
Coupon 06/15/2024 47787JAC2 0.00 JDOT 2022 A3 0.36
09/15/2026 2.35% 189.13 0.00 189.13 0.00
Coupon 06/15/2024 89238FAD5 0.00 TAOT 2022-B A3 2.93
09/15/2026 2.95% 267.24 0.00 267.24 0.00
CONFIDENTIAL | 16
City of Alameda | Account #270 | As of June 30, 2024
Execution Time: 07/03/2024 07:47:56 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
TRANSACTION LEDGER
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
Coupon 06/15/2024 02582JJT8 0.00 AMXCA 2022-2 A
05/17/2027 3.42% 1,271.25 0.00 1,271.25 0.00
Coupon 06/15/2024 47800AAC4 0.00 JDOT 2022-B A3 3.74
02/16/2027 3.77% 623.20 0.00 623.20 0.00
Coupon 06/15/2024 47800CAC0 0.00 JDOT 2023 A3 5.01
11/15/2027 5.04% 835.00 0.00 835.00 0.00
Coupon 06/15/2024 756109BS2 0.00 REALTY INCOME CORP 4.7 12/15/2028 4.71% 7,050.00 0.00 7,050.00 0.00
Coupon 06/15/2024 74340XCG4 0.00 PROLOGIS LP 4.875
06/15/2028 4.97% 6,093.75 0.00 6,093.75 0.00
Coupon 06/15/2024 161571HT4 0.00 CHAIT 2023-1 A 5.16
09/15/2028 5.23% 2,322.00 0.00 2,322.00 0.00
Coupon 06/15/2024 437918AC9 0.00 HAROT 2024-1 A3 5.21
08/15/2028 5.27% 2,062.29 0.00 2,062.29 0.00
Coupon 06/15/2024 448973AD9 0.00 HART 2024-A A3 4.99
02/15/2029 5.05% 852.46 0.00 852.46 0.00
Coupon 06/15/2024 02582JKH2 0.00 AMXCA 2024-1 A 5.23
04/16/2029 5.29% 849.87 0.00 849.87 0.00
Coupon 06/15/2024 58770JAD6 0.00 MBALT 2024-A A3 5.32
01/18/2028 5.39% 438.90 0.00 438.90 0.00
Coupon 06/16/2024 362554AC1 0.00 GMCAR 2021-4 A3 0.68
09/16/2026 0.68% 34.87 0.00 34.87 0.00
Coupon 06/16/2024 380146AC4 0.00 GMCAR 2022-1 A3 1.26
11/16/2026 1.27% 67.75 0.00 67.75 0.00
Coupon 06/17/2024 3135G04Z3 0.00
FEDERAL NATIONAL
MORTGAGE ASSOCIATION
0.5 06/17/2025
0.51% 2,562.50 0.00 2,562.50 0.00
Coupon 06/18/2024 89236TJK2 0.00 TOYOTA MOTOR CREDIT
CORP 1.125 06/18/2026 1.24% 4,275.00 0.00 4,275.00 0.00 Coupon 06/18/2024 437930AC4 0.00 HONDO-242-A3 5.27
11/20/2028 5.27% 691.69 0.00 691.69 0.00
Coupon 06/19/2024 06051GJD2 0.00 BANK OF AMERICA CORP
1.319 06/19/2026 1.25% 3,297.50 0.00 3,297.50 0.00
Coupon 06/20/2024 36269FAD8 0.00 GMALT 2024-1 A3 5.09
03/22/2027 5.15% 1,230.08 0.00 1,230.08 0.00
CONFIDENTIAL | 17
City of Alameda | Account #270 | As of June 30, 2024
Execution Time: 07/03/2024 07:47:56 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
TRANSACTION LEDGER
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
Coupon 06/20/2024 36269WAD1 0.00 GMALT 2024-2 A3 5.39
07/20/2027 5.45% 941.75 0.00 941.75 0.00
Coupon 06/21/2024 43813GAC5 0.00 HAROT 2021-1 A3 0.27
04/21/2025 0.00% 0.06 0.00 0.06 0.00
Coupon 06/21/2024 43815GAC3 0.00 HAROT 2021-4 A3 0.88
01/21/2026 0.90% 54.02 0.00 54.02 0.00
Coupon 06/25/2024 05602RAD3 0.00 BMWOT 2022-A A3 3.21
08/25/2026 3.23% 317.96 0.00 317.96 0.00
Coupon 06/30/2024 91282CEW7 0.00 UNITED STATES TREASURY
3.25 06/30/2027 3.12% 8,125.00 0.00 8,125.00 0.00
Coupon 06/30/2024 91282CGC9 0.00 UNITED STATES TREASURY
3.875 12/31/2027 3.57% 8,718.75 0.00 8,718.75 0.00
Coupon 06/30/2024 91282CJR3 0.00 UNITED STATES TREASURY
3.75 12/31/2028 3.97% 16,875.00 0.00 16,875.00 0.00
Total Coupon 0.00 90,769.01 0.00 90,769.01 0.00
Dividend 06/30/2024 316175603 0.00 FIDELITY IMM:GOVT III 4.96% 916.35 0.00 916.35 0.00 Total Dividend 0.00 916.35 0.00 916.35 0.00
Principal
Paydown 06/15/2024 89240BAC2 3,695.79 TAOT 2021-A A3 0.26 05/15/2025 0.00% 3,695.79 -- 3,695.79 0.00
Principal
Paydown 06/15/2024 47788UAC6 4,590.71 JDOT 2021 A3 0.36 09/15/2025 0.38% 4,590.71 -- 4,590.71 0.00
Principal
Paydown 06/15/2024 47789QAC4 8,459.13 JDOT 2021-B A3 0.52 03/16/2026 0.53% 8,459.13 -- 8,459.13 0.00
Principal
Paydown 06/15/2024 89238JAC9 7,114.36 TAOT 2021-D A3 0.71 04/15/2026 0.71% 7,114.36 -- 7,114.36 (0.01)
Principal
Paydown 06/15/2024 44935FAD6 5,973.63 HART 2021-C A3 0.74 05/15/2026 0.76% 5,973.63 -- 5,973.63 0.00
Principal
Paydown 06/15/2024 43815BAC4 15,364.04 HAROT 2022-1 A3 1.88 05/15/2026 1.90% 15,364.04 -- 15,364.04 (0.00)
Principal
Paydown 06/15/2024 448977AD0 24,932.75 HART 2022-A A3 2.22 10/15/2026 2.23% 24,932.75 -- 24,932.75 0.00
Principal
Paydown 06/15/2024 47787JAC2 6,204.73 JDOT 2022 A3 0.36 09/15/2026 2.35% 6,204.73 -- 6,204.73 (0.00)
CONFIDENTIAL | 18
City of Alameda | Account #270 | As of June 30, 2024
Execution Time: 07/03/2024 07:47:56 PM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747
TRANSACTION LEDGER
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
Principal
Paydown 06/15/2024 89238FAD5 8,144.78 TAOT 2022-B A3 2.93 09/15/2026 2.95% 8,144.78 -- 8,144.78 0.00
Principal
Paydown 06/15/2024 47800AAC4 10,724.28 JDOT 2022-B A3 3.74 02/16/2027 3.77% 10,724.28 -- 10,724.28 (0.00)
Principal
Paydown 06/16/2024 362554AC1 5,626.56 GMCAR 2021-4 A3 0.68 09/16/2026 0.68% 5,626.56 -- 5,626.56 (0.00)
Principal
Paydown 06/16/2024 380146AC4 5,580.97 GMCAR 2022-1 A3 1.26 11/16/2026 1.27% 5,580.97 -- 5,580.97 (0.00)
Principal
Paydown 06/21/2024 43813GAC5 251.59 HAROT 2021-1 A3 0.27 04/21/2025 0.00% 251.59 -- 251.59 (0.00)
Principal
Paydown 06/21/2024 43815GAC3 7,727.59 HAROT 2021-4 A3 0.88 01/21/2026 0.90% 7,727.59 -- 7,727.59 0.01
Principal
Paydown 06/25/2024 05602RAD3 9,974.92 BMWOT 2022-A A3 3.21 08/25/2026 3.23% 9,974.92 -- 9,974.92 0.00
Total Principal
Paydown 124,365.83 124,365.83 -- 124,365.83 0.00
TOTAL OTHER
TRANSACTIONS 124,365.83 216,051.19 0.00 216,051.19 0.00 Client Management Team
Monique Spyke, Managing Director 44 Montgomery Street, 3rd Floor San Francisco, CA 94104
415-982-5544
PFM Asset Management LLC
213 Market Street
Harrisburg, PA 17101-2141
717-232-2723
Investment Transactions Reporting
CITY OF ALAMEDA
For the Quarter Ending June 30, 2024
CITY OF ALAMEDA
MONTHLY TRANSACTIONS
For the Month Ending
April 30, 2024
Customer Service
PO Box 11813
Harrisburg, PA 17108-1813
Accounts included in Statement
03060050 CITY OF ALAMEDA (PFM)
https://www.pfmam.comOnline Access 1-717-232-2723Customer Service For the Month Ending April 30, 2024Managed Account Security Transactions & Interest CITY OF ALAMEDA (PFM) - 03060050
Transaction Type
Trade CUSIPSecurity DescriptionSettle Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
BUY
04/03/24 US TREASURY N/B NOTES
DTD 03/15/2024 4.250% 03/15/2027
91282CKE0 (694,996.09) (1,536.01) (696,532.10) 700,000.00 04/01/24 04/04/24 ADOBE INC CORPORATE NOTES
DTD 04/04/2024 4.850% 04/04/2027
00724PAE9 (144,927.50) 0.00 (144,927.50) 145,000.00 04/01/24 04/05/24 US TREASURY N/B NOTES
DTD 03/15/2024 4.250% 03/15/2027
91282CKE0 (695,269.53) (1,697.69) (696,967.22) 700,000.00 04/03/24 04/05/24 US TREASURY N/B NOTES
DTD 03/31/2024 4.500% 03/31/2026
91282CKH3 (249,169.92) (153.69) (249,323.61) 250,000.00 04/03/24 04/12/24 US TREASURY N/B NOTES
DTD 03/15/2024 4.250% 03/15/2027
91282CKE0 (863,002.93) (2,829.48) (865,832.41) 875,000.00 04/10/24 04/22/24 JPMORGAN CHASE & CO CORPORATE
NOTES (CAL
DTD 04/22/2024 5.571% 04/22/2028
46647PEE2 (215,000.00) 0.00 (215,000.00) 215,000.00 04/15/24 04/19/24 MORGAN STANLEY CORP NOTES
(CALLABLE)
DTD 04/19/2024 5.652% 04/13/2028
61747YFP5 (25,000.00) 0.00 (25,000.00) 25,000.00 04/17/24 (6,216.87) (2,893,582.84)(2,887,365.97) 2,910,000.00 Transaction Type Sub-Total
INTEREST
04/01/24 BMW US CAPITAL LLC CORP NOTES
DTD 04/01/2022 3.250% 04/01/2025
05565EBZ7 0.00 1,787.50 1,787.50 110,000.00 04/01/24 04/01/24 MONEY MARKET FUND MONEY0002 0.00 738.35 738.35 0.00 04/01/24 04/03/24 AMERICAN HONDA FINANCE
CORPORATE NOTES
DTD 10/04/2023 5.800% 10/03/2025
02665WEQ0 0.00 2,307.11 2,307.11 80,000.00 04/03/24 04/15/24 US TREASURY NOTES
DTD 10/15/2023 4.625% 10/15/2026
91282CJC6 0.00 62,437.50 62,437.50 2,700,000.00 04/15/24 04/15/24 KCOT 2022-1A A3
DTD 03/23/2022 2.670% 10/15/2026
50117EAC8 0.00 522.88 522.88 235,000.00 04/15/24
04/15/24 CARMX 2020-4 A3
DTD 10/21/2020 0.500% 08/15/2025
14316HAC6 0.00 3.09 3.09 7,410.93 04/15/24
04/15/24 DCENT 2022-A3 A3
DTD 08/09/2022 3.560% 07/15/2027
254683CW3 0.00 860.33 860.33 290,000.00 04/15/24
Account 03060050 Page 33
For the Month Ending April 30, 2024Managed Account Security Transactions & Interest CITY OF ALAMEDA (PFM) - 03060050
Transaction Type
Trade CUSIPSecurity DescriptionSettle Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
INTEREST
04/15/24 AMXCA 2023-1 A
DTD 06/14/2023 4.870% 05/15/2028
02582JJZ4 0.00 405.83 405.83 100,000.00 04/15/24
04/15/24 AMXCA 2022-2 A
DTD 05/24/2022 3.390% 05/17/2027
02582JJT8 0.00 494.38 494.38 175,000.00 04/15/24
04/15/24 COPAR 2021-1 A3
DTD 10/27/2021 0.770% 09/15/2026
14044CAC6 0.00 50.83 50.83 79,222.73 04/15/24
04/15/24 BACCT 2023-A2 A2
DTD 12/14/2023 4.980% 11/15/2028
05522RDH8 0.00 518.75 518.75 125,000.00 04/15/24
04/15/24 KCOT 2022-1A A2
DTD 03/23/2022 2.340% 04/15/2025
50117EAB0 0.00 1.41 1.41 722.23 04/15/24
04/15/24 CARMX 2022-3 A3
DTD 07/20/2022 3.970% 04/15/2027
14318MAD1 0.00 810.54 810.54 245,000.00 04/15/24
04/15/24 TAOT 2023-B A3
DTD 05/23/2023 4.710% 02/15/2028
891941AD8 0.00 706.50 706.50 180,000.00 04/15/24
04/15/24 HAROT 2022-1 A3
DTD 02/23/2022 1.880% 05/15/2026
43815BAC4 0.00 242.44 242.44 154,746.05 04/15/24
04/15/24 KCOT 2021-1A A3
DTD 04/14/2021 0.620% 08/15/2025
50117TAC5 0.00 17.48 17.48 33,826.63 04/15/24
04/15/24 ALLYA 2022-1 A3
DTD 05/18/2022 3.310% 11/15/2026
02008JAC0 0.00 627.67 627.67 227,555.87 04/15/24
04/15/24 FITAT 2023-1 A3
DTD 08/23/2023 5.530% 08/15/2028
31680EAD3 0.00 1,059.92 1,059.92 230,000.00 04/15/24 04/15/24 TAOT 2023-D A3
DTD 11/14/2023 5.540% 08/15/2028
89239FAD4 0.00 369.33 369.33 80,000.00 04/15/24
04/15/24 FORDO 2023-A A3
DTD 03/31/2023 4.650% 02/15/2028
344928AD8 0.00 465.00 465.00 120,000.00 04/15/24
04/15/24 FORDO 2022-A A3
DTD 01/24/2022 1.290% 06/15/2026
345286AC2 0.00 48.15 48.15 44,786.08 04/15/24
04/15/24 KCOT 2022-2A A3
DTD 07/21/2022 4.090% 12/15/2026
50117JAC7 0.00 766.88 766.88 225,000.00 04/15/24
04/15/24 COPAR 2022-2 A3
DTD 08/10/2022 3.660% 05/17/2027
14043GAD6 0.00 427.00 427.00 140,000.00 04/15/24
04/15/24 WOART 2021-D A3
DTD 11/03/2021 0.810% 10/15/2026
98163KAC6 0.00 60.15 60.15 89,105.53 04/15/24
Account 03060050 Page 34
For the Month Ending April 30, 2024Managed Account Security Transactions & Interest CITY OF ALAMEDA (PFM) - 03060050
Transaction Type
Trade CUSIPSecurity DescriptionSettle Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
INTEREST
04/15/24 ALLYA 2022-2 A3
DTD 10/12/2022 4.760% 05/17/2027
02008MAC3 0.00 1,606.50 1,606.50 405,000.00 04/15/24 04/15/24 KCOT 2021-2A A3
DTD 07/28/2021 0.560% 11/17/2025
50117XAE2 0.00 38.75 38.75 83,043.17 04/15/24
04/15/24 MBART 2023-1 A3
DTD 01/25/2023 4.510% 11/15/2027
58770AAC7 0.00 451.00 451.00 120,000.00 04/15/24
04/15/24 CARMX 2021-3 A3
DTD 07/28/2021 0.550% 06/15/2026
14317DAC4 0.00 45.68 45.68 99,669.59 04/15/24
04/15/24 HART 2021-C A3
DTD 11/17/2021 0.740% 05/15/2026
44935FAD6 0.00 32.82 32.82 53,219.85 04/15/24
04/15/24 CARMX 2021-1 A3
DTD 01/27/2021 0.340% 12/15/2025
14316NAC3 0.00 3.66 3.66 12,909.29 04/15/24
04/15/24 TAOT 2022-B A3
DTD 04/13/2022 2.930% 09/15/2026
89238FAD5 0.00 285.80 285.80 117,052.35 04/15/24
04/15/24 TAOT 2021-D A3
DTD 11/15/2021 0.710% 04/15/2026
89238JAC9 0.00 44.64 44.64 75,447.18 04/15/24
04/15/24 HDMOT 2023-B A3
DTD 09/27/2023 5.690% 08/15/2028
41285YAC9 0.00 995.75 995.75 210,000.00 04/15/24
04/15/24 COMET 2022-A1 A1
DTD 03/30/2022 2.800% 03/15/2027
14041NFZ9 0.00 1,050.00 1,050.00 450,000.00 04/15/24 04/15/24 HDMOT 2023-A A3
DTD 02/23/2023 5.050% 12/15/2027
41285JAD0 0.00 652.29 652.29 155,000.00 04/15/24
04/15/24 HUNT 2024-1A A3
DTD 02/22/2024 5.230% 01/16/2029
446144AE7 0.00 610.17 610.17 140,000.00 04/15/24
04/15/24 HART 2022-A A3
DTD 03/16/2022 2.220% 10/15/2026
448977AD0 0.00 377.84 377.84 204,235.20 04/15/24
04/15/24 HART 2022-B A3
DTD 07/20/2022 3.720% 11/16/2026
44918MAD2 0.00 465.00 465.00 150,000.00 04/15/24
04/15/24 LOCKHEED MARTIN CORP NOTES
(CALLABLE)
DTD 10/24/2022 4.950% 10/15/2025
539830BU2 0.00 1,856.25 1,856.25 75,000.00 04/15/24 04/15/24 NAROT 2022-B A3
DTD 09/28/2022 4.460% 05/17/2027
65480JAC4 0.00 576.08 576.08 155,000.00 04/15/24
Account 03060050 Page 35
For the Month Ending April 30, 2024Managed Account Security Transactions & Interest CITY OF ALAMEDA (PFM) - 03060050
Transaction Type
Trade CUSIPSecurity DescriptionSettle Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
INTEREST
04/15/24 HART 2021-A A3
DTD 04/28/2021 0.380% 09/15/2025
44933LAC7 0.00 4.99 4.99 15,768.57 04/15/24
04/15/24 DCENT 2023-A1 A
DTD 04/11/2023 4.310% 03/15/2028
254683CY9 0.00 520.79 520.79 145,000.00 04/15/24
04/15/24 KCOT 2023-1A A3
DTD 03/31/2023 5.020% 06/15/2027
50117KAC4 0.00 669.33 669.33 160,000.00 04/15/24
04/15/24 TAOT 2023-A A3
DTD 01/30/2023 4.630% 09/15/2027
891940AC2 0.00 559.46 559.46 145,000.00 04/15/24
04/15/24 CARMX 2022-4 A3
DTD 10/31/2022 5.340% 08/16/2027
14318UAD3 0.00 1,246.00 1,246.00 280,000.00 04/15/24 04/15/24 COMET 2021-A3 A3
DTD 11/30/2021 1.040% 11/15/2026
14041NFY2 0.00 281.67 281.67 325,000.00 04/15/24
04/15/24 KCOT 2023-2A A3
DTD 07/26/2023 5.280% 01/18/2028
500945AC4 0.00 528.00 528.00 120,000.00 04/15/24
04/15/24 MBART 2022-1 A3
DTD 11/22/2022 5.210% 08/16/2027
58768PAC8 0.00 1,584.71 1,584.71 365,000.00 04/15/24 04/15/24 US TREASURY NOTES
DTD 04/15/2023 3.750% 04/15/2026
91282CGV7 0.00 22,968.75 22,968.75 1,225,000.00 04/15/24 04/15/24 FORDO 2023-B A3
DTD 06/26/2023 5.230% 05/15/2028
344930AD4 0.00 457.63 457.63 105,000.00 04/15/24
04/15/24 HDMOT 2022-A A3
DTD 04/20/2022 3.060% 02/15/2027
41284YAD8 0.00 392.29 392.29 153,839.60 04/15/24
04/15/24 DCENT 2021-A1 A1
DTD 09/27/2021 0.580% 09/15/2026
254683CP8 0.00 67.67 67.67 140,000.00 04/15/24
04/15/24 CHAIT 2024-A1 A
DTD 01/31/2024 4.600% 01/15/2027
161571HV9 0.00 1,590.83 1,590.83 415,000.00 04/15/24 04/15/24 COPAR 2022-1 A3
DTD 05/04/2022 3.170% 04/15/2027
14043QAC6 0.00 367.91 367.91 139,271.63 04/15/24
04/15/24 CARMX 2021-2 A3
DTD 04/21/2021 0.520% 02/17/2026
14314QAC8 0.00 18.34 18.34 42,327.87 04/15/24
04/15/24 CARMX 2022-2 A3
DTD 04/28/2022 3.490% 02/16/2027
14317HAC5 0.00 447.11 447.11 153,735.03 04/15/24
04/15/24 NAROT 2023-A A3
DTD 04/26/2023 4.910% 11/15/2027
65480WAD3 0.00 1,145.67 1,145.67 280,000.00 04/15/24 Account 03060050 Page 36
For the Month Ending April 30, 2024Managed Account Security Transactions & Interest CITY OF ALAMEDA (PFM) - 03060050
Transaction Type
Trade CUSIPSecurity DescriptionSettle Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
INTEREST
04/16/24 GMCAR 2022-1 A3
DTD 01/19/2022 1.260% 11/16/2026
380146AC4 0.00 72.10 72.10 68,662.23 04/16/24
04/16/24 GMCAR 2021-4 A3
DTD 10/21/2021 0.680% 09/16/2026
362554AC1 0.00 36.42 36.42 64,263.45 04/16/24
04/16/24 GMCAR 2022-3 A3
DTD 07/13/2022 3.640% 04/16/2027
36265WAD5 0.00 439.83 439.83 145,000.00 04/16/24
04/16/24 GMCAR 2023-2 A3
DTD 04/12/2023 4.470% 02/16/2028
362583AD8 0.00 335.25 335.25 90,000.00 04/16/24
04/16/24 GMCAR 2022-2 A3
DTD 04/13/2022 3.100% 02/16/2027
362585AC5 0.00 270.41 270.41 104,676.01 04/16/24
04/20/24 VALET 2021-1 A3
DTD 12/13/2021 1.020% 06/22/2026
92868KAC7 0.00 74.45 74.45 87,592.05 04/20/24
04/20/24 VWALT 2022-A A3
DTD 06/14/2022 3.440% 07/21/2025
92868AAC9 0.00 194.04 194.04 67,687.39 04/20/24
04/21/24 HAROT 2021-4 A3
DTD 11/24/2021 0.880% 01/21/2026
43815GAC3 0.00 53.79 53.79 73,352.02 04/21/24
04/22/24 JPMORGAN CHASE & CO CORP NOTE
(CALLABLE)
DTD 10/23/2023 6.070% 10/22/2027
46647PDW3 0.00 3,621.77 3,621.77 120,000.00 04/22/24 04/24/24 BANK OF NY MELLON (CALLABLE) CORP
NOTES
DTD 04/24/2020 1.600% 04/24/2025
06406RAN7 0.00 880.00 880.00 110,000.00 04/24/24
04/25/24 BMWOT 2023-A A3
DTD 07/18/2023 5.470% 02/25/2028
05592XAD2 0.00 364.67 364.67 80,000.00 04/25/24
04/25/24 BMWOT 2022-A A3
DTD 05/18/2022 3.210% 08/25/2026
05602RAD3 0.00 265.58 265.58 99,281.90 04/25/24
04/26/24 JPMORGAN CHASE & CO (CALLABLE)
CORPORATE
DTD 04/26/2022 4.080% 04/26/2026
46647PCZ7 0.00 4,590.00 4,590.00 225,000.00 04/26/24 04/28/24 PNC FINANCIAL SERVICES CORP NOTE
(CALLAB
DTD 10/28/2022 5.671% 10/28/2025
693475BH7 0.00 4,253.25 4,253.25 150,000.00 04/28/24 Account 03060050 Page 37
For the Month Ending April 30, 2024Managed Account Security Transactions & Interest CITY OF ALAMEDA (PFM) - 03060050
Transaction Type
Trade CUSIPSecurity DescriptionSettle Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
INTEREST
04/28/24 TRUIST FINANCIAL CORP NOTES
(CALLABLE)
DTD 10/28/2022 5.900% 10/28/2026
89788MAJ1 0.00 4,572.50 4,572.50 155,000.00 04/28/24 04/30/24 NATIONAL RURAL UTIL COOP
CORPORATE NOTES
DTD 10/31/2022 5.450% 10/30/2025
63743HFF4 0.00 1,090.00 1,090.00 40,000.00 04/30/24 05/02/24 CITIGROUP INC CORP NOTES
(CALLABLE)
DTD 10/30/2020 5.996% 10/30/2024
172967MT5 0.00 2,821.84 2,821.84 185,000.00 04/30/24 141,608.30 141,608.30 0.00 14,253,410.43 Transaction Type Sub-Total
PAYDOWNS
04/15/24 CARMX 2022-2 A3
DTD 04/28/2022 3.490% 02/16/2027
14317HAC5 9,522.90 0.00 9,522.90 1.45 0.00 9,522.90 04/15/24 04/15/24 WOART 2021-D A3
DTD 11/03/2021 0.810% 10/15/2026
98163KAC6 7,203.28 0.00 7,203.28 0.98 0.00 7,203.28 04/15/24 04/15/24 CARMX 2020-4 A3
DTD 10/21/2020 0.500% 08/15/2025
14316HAC6 3,960.22 0.00 3,960.22 0.88 0.00 3,960.22 04/15/24 04/15/24 HART 2021-A A3
DTD 04/28/2021 0.380% 09/15/2025
44933LAC7 4,349.64 0.00 4,349.64 0.46 0.00 4,349.64 04/15/24 04/15/24 KCOT 2022-1A A2
DTD 03/23/2022 2.340% 04/15/2025
50117EAB0 722.23 0.00 722.23 0.03 0.00 722.23 04/15/24 04/15/24 COPAR 2022-1 A3
DTD 05/04/2022 3.170% 04/15/2027
14043QAC6 7,891.25 0.00 7,891.25 1.72 0.00 7,891.25 04/15/24 04/15/24 KCOT 2022-1A A3
DTD 03/23/2022 2.670% 10/15/2026
50117EAC8 11,913.52 0.00 11,913.52 1.70 0.00 11,913.52 04/15/24 04/15/24 HART 2021-C A3
DTD 11/17/2021 0.740% 05/15/2026
44935FAD6 5,416.88 0.00 5,416.88 1.21 0.00 5,416.88 04/15/24 04/15/24 HAROT 2022-1 A3
DTD 02/23/2022 1.880% 05/15/2026
43815BAC4 11,671.94 0.00 11,671.94 1.76 0.00 11,671.94 04/15/24 04/15/24 TAOT 2021-D A3
DTD 11/15/2021 0.710% 04/15/2026
89238JAC9 6,605.63 0.00 6,605.63 0.14 0.00 6,605.63 04/15/24 04/15/24 KCOT 2021-2A A3
DTD 07/28/2021 0.560% 11/17/2025
50117XAE2 9,059.95 0.00 9,059.95 0.34 0.00 9,059.95 04/15/24 Account 03060050 Page 38
For the Month Ending April 30, 2024Managed Account Security Transactions & Interest CITY OF ALAMEDA (PFM) - 03060050
Transaction Type
Trade CUSIPSecurity DescriptionSettle Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
PAYDOWNS
04/15/24 HART 2022-A A3
DTD 03/16/2022 2.220% 10/15/2026
448977AD0 14,965.15 0.00 14,965.15 0.58 0.00 14,965.15 04/15/24 04/15/24 CARMX 2021-3 A3
DTD 07/28/2021 0.550% 06/15/2026
14317DAC4 8,527.78 0.00 8,527.78 1.40 0.00 8,527.78 04/15/24 04/15/24 HDMOT 2022-A A3
DTD 04/20/2022 3.060% 02/15/2027
41284YAD8 12,440.42 0.00 12,440.42 2.07 0.00 12,440.42 04/15/24 04/15/24 CARMX 2021-1 A3
DTD 01/27/2021 0.340% 12/15/2025
14316NAC3 2,445.56 0.00 2,445.56 0.48 0.00 2,445.56 04/15/24 04/15/24 COPAR 2021-1 A3
DTD 10/27/2021 0.770% 09/15/2026
14044CAC6 6,417.49 0.00 6,417.49 0.12 0.00 6,417.49 04/15/24 04/15/24 FORDO 2022-A A3
DTD 01/24/2022 1.290% 06/15/2026
345286AC2 3,600.19 0.00 3,600.19 0.43 0.00 3,600.19 04/15/24 04/15/24 TAOT 2022-B A3
DTD 04/13/2022 2.930% 09/15/2026
89238FAD5 7,561.14 0.00 7,561.14 0.18 0.00 7,561.14 04/15/24 04/15/24 KCOT 2021-1A A3
DTD 04/14/2021 0.620% 08/15/2025
50117TAC5 5,819.62 0.00 5,819.62 1.19 0.00 5,819.62 04/15/24 04/15/24 ALLYA 2022-1 A3
DTD 05/18/2022 3.310% 11/15/2026
02008JAC0 16,073.47 0.00 16,073.47 3.11 0.00 16,073.47 04/15/24 04/15/24 CARMX 2021-2 A3
DTD 04/21/2021 0.520% 02/17/2026
14314QAC8 5,926.83 0.00 5,926.83 1.28 0.00 5,926.83 04/15/24 04/15/24 HART 2022-B A3
DTD 07/20/2022 3.720% 11/16/2026
44918MAD2 980.79 0.00 980.79 0.00 0.00 980.79 04/15/24 04/16/24 GMCAR 2022-1 A3
DTD 01/19/2022 1.260% 11/16/2026
380146AC4 5,174.99 0.00 5,174.99 0.45 0.00 5,174.99 04/16/24 04/16/24 GMCAR 2022-2 A3
DTD 04/13/2022 3.100% 02/16/2027
362585AC5 6,301.63 0.00 6,301.63 1.32 0.00 6,301.63 04/16/24 04/16/24 GMCAR 2021-4 A3
DTD 10/21/2021 0.680% 09/16/2026
362554AC1 5,063.23 0.00 5,063.23 0.13 0.00 5,063.23 04/16/24 04/20/24 VWALT 2022-A A3
DTD 06/14/2022 3.440% 07/21/2025
92868AAC9 11,553.54 0.00 11,553.54 0.92 0.00 11,553.54 04/20/24 04/20/24 VALET 2021-1 A3
DTD 12/13/2021 1.020% 06/22/2026
92868KAC7 8,162.59 0.00 8,162.59 0.32 0.00 8,162.59 04/20/24 04/21/24 HAROT 2021-4 A3
DTD 11/24/2021 0.880% 01/21/2026
43815GAC3 6,609.49 0.00 6,609.49 1.39 0.00 6,609.49 04/21/24 Account 03060050 Page 39
For the Month Ending April 30, 2024Managed Account Security Transactions & Interest CITY OF ALAMEDA (PFM) - 03060050
Transaction Type
Trade CUSIPSecurity DescriptionSettle Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
PAYDOWNS
04/25/24 BMWOT 2022-A A3
DTD 05/18/2022 3.210% 08/25/2026
05602RAD3 7,282.77 0.00 7,282.77 0.38 0.00 7,282.77 04/25/24
0.00 0.00 26.42 213,224.12 213,224.12 213,224.12 Transaction Type Sub-Total SELL
04/03/24 JOHN DEERE CAPITAL CORP
CORPORATE NOTES
DTD 06/06/2022 3.400% 06/06/2025
24422EWF2 83,307.65 939.25 84,246.90 (1,672.80) (1,684.70) FIFO 85,000.00 04/01/24 04/03/24 COOPERATIEVE RABOBANK UA
CORPORATE NOTES
DTD 01/12/2022 1.375% 01/10/2025
21688AAS1 242,315.00 792.53 243,107.53 (6,920.00) (7,487.81) FIFO 250,000.00 04/01/24 04/03/24 HOME DEPOT INC NOTES (CALLABLE)
DTD 09/19/2022 4.000% 09/15/2025
437076CR1 49,274.50 100.00 49,374.50 (707.50) (716.76) FIFO 50,000.00 04/01/24 04/03/24 US TREASURY NOTES
DTD 06/15/2022 2.875% 06/15/2025
91282CEU1 146,326.17 1,296.11 147,622.28 (3,480.47) (3,594.68) FIFO 150,000.00 04/01/24 04/03/24 US TREASURY NOTES
DTD 07/15/2022 3.000% 07/15/2025
91282CEY3 146,408.20 976.65 147,384.85 (3,339.85) (3,481.81) FIFO 150,000.00 04/01/24 04/03/24 TOYOTA MOTOR CREDIT CORP
CORPORATE NOTES
DTD 06/30/2022 3.950% 06/30/2025
89236TKC8 123,181.25 1,275.52 124,456.77 (1,700.00) (1,769.67) FIFO 125,000.00 04/01/24 04/05/24 US TREASURY NOTES
DTD 07/15/2022 3.000% 07/15/2025
91282CEY3 317,408.20 2,169.64 319,577.84 (7,045.90) (7,354.50) FIFO 325,000.00 04/03/24 04/05/24 US TREASURY NOTES
DTD 07/15/2022 3.000% 07/15/2025
91282CEY3 610,400.39 4,172.39 614,572.78 (12,011.72) (13,473.60) FIFO 625,000.00 04/03/24 04/12/24 US TREASURY NOTES
DTD 07/15/2022 3.000% 07/15/2025
91282CEY3 121,811.52 906.59 122,718.11 (2,670.90) (2,966.66) FIFO 125,000.00 04/10/24 04/12/24 US TREASURY NOTES
DTD 08/15/2022 3.125% 08/15/2025
91282CFE6 731,044.92 3,670.16 734,715.08 (10,253.91) (14,981.57) FIFO 750,000.00 04/10/24 04/18/24 US TREASURY N/B NOTES
DTD 03/15/2024 4.250% 03/15/2027
91282CKE0 147,890.63 588.99 148,479.62 (1,037.10) (1,050.99) FIFO 150,000.00 04/15/24 04/19/24 MORGAN STANLEY CORPORATE NOTES
(CALLABLE
DTD 01/19/2023 5.050% 01/28/2027
61747YEZ4 24,764.00 284.06 25,048.06 (235.50) (235.66) FIFO 25,000.00 04/17/24 Account 03060050 Page 40
For the Month Ending April 30, 2024Managed Account Security Transactions & Interest CITY OF ALAMEDA (PFM) - 03060050
Transaction Type
Trade CUSIPSecurity DescriptionSettle Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
17,171.89 (58,798.41)(51,075.65) 2,761,304.32 2,744,132.43 2,810,000.00 Transaction Type Sub-Total 69,990.58 152,563.32 222,553.90 (51,049.23) (58,798.41)Managed Account Sub-Total Total Security Transactions ($51,049.23)$222,553.90 $152,563.32 $69,990.58 ($58,798.41) Account 03060050 Page 41
CITY OF ALAMEDA
MONTHLY TRANSACTIONS
For the Month Ending
May 31, 2024
Customer Service
PO Box 11813
Harrisburg, PA 17108-1813
Accounts included in Statement
03060050 CITY OF ALAMEDA (PFM)
https://www.pfmam.comOnline Access 1-717-232-2723Customer Service For the Month Ending May 31, 2024Managed Account Security Transactions & Interest CITY OF ALAMEDA (CHANDLER) - 03060055
Transaction Type
Trade CUSIPSecurity DescriptionSettle Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
BUY
05/16/24 GMALT 2024-2 A3
DTD 05/16/2024 5.390% 07/20/2027
36269WAD1 (184,989.25) 0.00 (184,989.25) 185,000.00 05/07/24 05/21/24 HAROT 2024-2 A3
DTD 05/21/2024 5.270% 11/20/2028
437930AC4 (174,978.74) 0.00 (174,978.74) 175,000.00 05/14/24 05/23/24 MBALT 2024-A A3
DTD 05/23/2024 5.320% 01/18/2028
58770JAD6 (134,984.21) 0.00 (134,984.21) 135,000.00 05/17/24 05/23/24 HOME DEPOT INC CORP NOTES
(CALLABLE)
DTD 12/04/2023 4.900% 04/15/2029
437076CW0 (471,158.75) (2,430.94) (473,589.69) 470,000.00 05/21/24 05/23/24 HOME DEPOT INC CORP NOTES
(CALLABLE)
DTD 12/04/2023 4.900% 04/15/2029
437076CW0 (165,333.30) (853.42) (166,186.72) 165,000.00 05/21/24 (3,284.36) (1,134,728.61)(1,131,444.25) 1,130,000.00 Transaction Type Sub-Total
INTEREST
05/01/24 MONEY MARKET FUND MONEY0002 0.00 1,796.57 1,796.57 0.00 05/01/24 05/01/24 FEDERAL FARM CREDIT BANK NOTES
DTD 10/25/2023 4.875% 11/01/2028
3133EPA47 0.00 6,093.75 6,093.75 250,000.00 05/01/24 05/01/24 BANK OF MONTREAL
DTD 04/22/2020 1.850% 05/01/2025
06367WB85 0.00 4,153.25 4,153.25 449,000.00 05/01/24 05/07/24 FANNIE MAE NOTES
DTD 11/12/2020 0.500% 11/07/2025
3135G06G3 0.00 2,562.50 2,562.50 1,025,000.00 05/07/24 05/10/24 NORTHERN TRUST CORP NOTE
(CALLABLE)
DTD 05/10/2022 4.000% 05/10/2027
665859AW4 0.00 10,400.00 10,400.00 520,000.00 05/10/24 05/12/24 AMAZON INC CORP NOTES (CALLABLE)
DTD 05/12/2021 1.000% 05/12/2026
023135BX3 0.00 3,950.00 3,950.00 790,000.00 05/12/24 05/13/24 CHARLES SCHWAB CORP CORP NOTES
(CALLABLE
DTD 05/13/2021 1.150% 05/13/2026
808513BR5 0.00 2,702.50 2,702.50 470,000.00 05/13/24 05/15/24 TOYOTA AUTO RECEIVABLES
DTD 02/08/2021 0.260% 05/15/2025
89240BAC2 0.00 3.86 3.86 17,799.93 05/15/24
05/15/24 TAOT 2021-D A3
DTD 11/15/2021 0.710% 04/15/2026
89238JAC9 0.00 46.77 46.77 79,040.32 05/15/24
Account 03060055 Page 24
For the Month Ending May 31, 2024Managed Account Security Transactions & Interest CITY OF ALAMEDA (CHANDLER) - 03060055
Transaction Type
Trade CUSIPSecurity DescriptionSettle Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
INTEREST
05/15/24 FLORIDA POWER & LIGHT CORP NOTES
(CALLAB
DTD 05/15/2023 4.400% 05/15/2028
341081GN1 0.00 8,800.00 8,800.00 400,000.00 05/15/24 05/15/24 JDOT 2023-A A3
DTD 03/02/2023 5.010% 11/15/2027
47800CAC0 0.00 835.00 835.00 200,000.00 05/15/24
05/15/24 JDOT 2022-A A3
DTD 03/16/2022 2.320% 09/16/2026
47787JAC2 0.00 207.01 207.01 107,074.12 05/15/24
05/15/24 HART 2021-C A3
DTD 11/17/2021 0.740% 05/15/2026
44935FAD6 0.00 35.37 35.37 57,363.56 05/15/24
05/15/24 TAOT 2022-B A3
DTD 04/13/2022 2.930% 09/15/2026
89238FAD5 0.00 287.14 287.14 117,601.67 05/15/24
05/15/24 HART 2022-A A3
DTD 03/16/2022 2.220% 10/15/2026
448977AD0 0.00 604.18 604.18 326,583.62 05/15/24
05/15/24 UNITEDHEALTH GROUP INC
(CALLABLE) CORPOR
DTD 05/19/2021 1.150% 05/15/2026
91324PEC2 0.00 3,622.50 3,622.50 630,000.00 05/15/24 05/15/24 HAROT 2024-1 A3
DTD 02/21/2024 5.210% 08/15/2028
437918AC9 0.00 2,062.29 2,062.29 475,000.00 05/15/24 05/15/24 AMXCA 2022-2 A
DTD 05/24/2022 3.390% 05/17/2027
02582JJT8 0.00 1,271.25 1,271.25 450,000.00 05/15/24 05/15/24 JDOT 2021-A A3
DTD 03/10/2021 0.360% 09/15/2025
47788UAC6 0.00 8.26 8.26 27,522.86 05/15/24
05/15/24 AMXCA 2024-1 A
DTD 04/23/2024 5.230% 04/16/2029
02582JKH2 0.00 623.24 623.24 195,000.00 05/15/24
05/15/24 HART 2024-A A3
DTD 03/20/2024 4.990% 02/15/2029
448973AD9 0.00 852.46 852.46 205,000.00 05/15/24
05/15/24 CHAIT 2023-A1 A
DTD 09/15/2023 5.160% 09/15/2028
161571HT4 0.00 2,322.00 2,322.00 540,000.00 05/15/24 05/15/24 JDOT 2021-B A3
DTD 07/21/2021 0.520% 03/16/2026
47789QAC4 0.00 36.48 36.48 84,195.62 05/15/24
05/15/24 HAROT 2022-1 A3
DTD 02/23/2022 1.880% 05/15/2026
43815BAC4 0.00 310.36 310.36 198,102.60 05/15/24
05/15/24 JDOT 2022-B A3
DTD 07/20/2022 3.740% 02/16/2027
47800AAC4 0.00 670.08 670.08 215,000.00 05/15/24
Account 03060055 Page 25
For the Month Ending May 31, 2024Managed Account Security Transactions & Interest CITY OF ALAMEDA (CHANDLER) - 03060055
Transaction Type
Trade CUSIPSecurity DescriptionSettle Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
INTEREST
05/15/24 AMXCA 2021-1 A
DTD 11/17/2021 0.900% 11/16/2026
02582JJR2 0.00 206.25 206.25 275,000.00 05/15/24
05/16/24 GMCAR 2021-4 A3
DTD 10/21/2021 0.680% 09/16/2026
362554AC1 0.00 38.12 38.12 67,273.00 05/16/24
05/16/24 GMCAR 2022-1 A3
DTD 01/19/2022 1.260% 11/16/2026
380146AC4 0.00 73.33 73.33 69,835.97 05/16/24
05/20/24 GMALT 2022-1 A3
DTD 02/23/2022 1.900% 03/20/2025
36265MAC9 0.00 1.72 1.72 1,086.34 05/20/24
05/20/24 GMALT 2024-1 A3
DTD 02/15/2024 5.090% 03/22/2027
36269FAD8 0.00 1,230.08 1,230.08 290,000.00 05/20/24 05/21/24 HAROT 2021-4 A3
DTD 11/24/2021 0.880% 01/21/2026
43815GAC3 0.00 59.82 59.82 81,574.25 05/21/24
05/21/24 HAROT 2021-1 A3
DTD 02/24/2021 0.270% 04/21/2025
43813GAC5 0.00 0.93 0.93 4,116.01 05/21/24
05/25/24 BMWOT 2022-A A3
DTD 05/18/2022 3.210% 08/25/2026
05602RAD3 0.00 344.54 344.54 128,798.79 05/25/24
05/31/24 US TREASURY NOTES
DTD 05/31/2023 3.625% 05/31/2028
91282CHE4 0.00 18,125.00 18,125.00 1,000,000.00 05/31/24 05/31/24 US TREASURY NOTES
DTD 11/30/2020 0.375% 11/30/2025
91282CAZ4 0.00 2,062.50 2,062.50 1,100,000.00 05/31/24 05/31/24 US TREASURY NOTES
DTD 05/31/2022 2.625% 05/31/2027
91282CET4 0.00 6,562.50 6,562.50 500,000.00 05/31/24 82,961.61 82,961.61 0.00 11,346,968.66 Transaction Type Sub-Total
PAYDOWNS
05/15/24 JDOT 2021-A A3
DTD 03/10/2021 0.360% 09/15/2025
47788UAC6 6,795.26 0.00 6,795.26 1.31 0.00 6,795.26 05/15/24 05/15/24 TOYOTA AUTO RECEIVABLES
DTD 02/08/2021 0.260% 05/15/2025
89240BAC2 14,104.13 0.00 14,104.13 2.61 0.00 14,104.13 05/15/24 05/15/24 HART 2021-C A3
DTD 11/17/2021 0.740% 05/15/2026
44935FAD6 6,028.69 0.00 6,028.69 1.35 0.00 6,028.69 05/15/24 05/15/24 HAROT 2022-1 A3
DTD 02/23/2022 1.880% 05/15/2026
43815BAC4 15,556.47 0.00 15,556.47 2.34 0.00 15,556.47 05/15/24 Account 03060055 Page 26
For the Month Ending May 31, 2024Managed Account Security Transactions & Interest CITY OF ALAMEDA (CHANDLER) - 03060055
Transaction Type
Trade CUSIPSecurity DescriptionSettle Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
PAYDOWNS
05/15/24 JDOT 2022-A A3
DTD 03/16/2022 2.320% 09/16/2026
47787JAC2 9,249.73 0.00 9,249.73 2.05 0.00 9,249.73 05/15/24 05/15/24 JDOT 2021-B A3
DTD 07/21/2021 0.520% 03/16/2026
47789QAC4 13,984.98 0.00 13,984.98 1.24 0.00 13,984.98 05/15/24 05/15/24 HART 2022-A A3
DTD 03/16/2022 2.220% 10/15/2026
448977AD0 25,091.91 0.00 25,091.91 0.97 0.00 25,091.91 05/15/24 05/15/24 TAOT 2021-D A3
DTD 11/15/2021 0.710% 04/15/2026
89238JAC9 7,398.23 0.00 7,398.23 0.16 0.00 7,398.23 05/15/24 05/15/24 TAOT 2022-B A3
DTD 04/13/2022 2.930% 09/15/2026
89238FAD5 8,150.07 0.00 8,150.07 0.19 0.00 8,150.07 05/15/24 05/15/24 JDOT 2022-B A3
DTD 07/20/2022 3.740% 02/16/2027
47800AAC4 15,042.06 0.00 15,042.06 1.44 0.00 15,042.06 05/15/24 05/16/24 GMCAR 2022-1 A3
DTD 01/19/2022 1.260% 11/16/2026
380146AC4 5,315.34 0.00 5,315.34 0.46 0.00 5,315.34 05/16/24 05/16/24 GMCAR 2021-4 A3
DTD 10/21/2021 0.680% 09/16/2026
362554AC1 5,738.04 0.00 5,738.04 0.15 0.00 5,738.04 05/16/24 05/20/24 GMALT 2022-1 A3
DTD 02/23/2022 1.900% 03/20/2025
36265MAC9 1,086.34 0.00 1,086.34 0.01 0.00 1,086.34 05/20/24 05/21/24 HAROT 2021-1 A3
DTD 02/24/2021 0.270% 04/21/2025
43813GAC5 3,864.42 0.00 3,864.42 0.08 0.00 3,864.42 05/21/24 05/21/24 HAROT 2021-4 A3
DTD 11/24/2021 0.880% 01/21/2026
43815GAC3 7,916.70 0.00 7,916.70 1.67 0.00 7,916.70 05/21/24 05/25/24 BMWOT 2022-A A3
DTD 05/18/2022 3.210% 08/25/2026
05602RAD3 9,935.83 0.00 9,935.83 0.52 0.00 9,935.83 05/25/24
0.00 0.00 16.55 155,258.20 155,258.20 155,258.20 Transaction Type Sub-Total SELL
05/23/24 CALIFORNIA ST MUNICIPAL
DTD 10/16/2019 2.400% 10/01/2024
13063DRK6 573,399.60 2,010.67 575,410.27 (19,923.00) (7,567.84) FIFO 580,000.00 05/21/24 05/23/24 ROYAL BANK OF CANADA
DTD 04/07/2022 3.375% 04/14/2025
78016EZ59 255,174.40 950.63 256,125.03 (4,729.40) (4,796.99) FIFO 260,000.00 05/21/24 2,961.30 (12,364.83)(24,652.40) 831,535.30 828,574.00 840,000.00 Transaction Type Sub-Total Account 03060055 Page 27
For the Month Ending May 31, 2024Managed Account Security Transactions & Interest CITY OF ALAMEDA (CHANDLER) - 03060055
Transaction Type
Trade CUSIPSecurity DescriptionSettle Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
(147,612.05) 82,638.55 (64,973.50) (24,635.85) (12,364.83)Managed Account Sub-Total Total Security Transactions ($24,635.85)($64,973.50)$82,638.55 ($147,612.05) ($12,364.83) Account 03060055 Page 28
CITY OF ALAMEDA
MONTHLY TRANSACTIONS
For the Month Ending
June 30, 2024
Customer Service
PO Box 11813
Harrisburg, PA 17108-1813
Accounts included in Statement
03060050 CITY OF ALAMEDA (PFM)
https://www.pfmam.comOnline Access 1-717-232-2723Customer Service For the Month Ending June 30, 2024Managed Account Security Transactions & Interest CITY OF ALAMEDA (CHANDLER) - 03060055
Transaction Type
Trade CUSIPSecurity DescriptionSettle Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
BUY
06/11/24 BMWOT 2024-A A3
DTD 06/11/2024 5.180% 02/26/2029
096919AD7 (224,965.82) 0.00 (224,965.82) 225,000.00 06/04/24 06/27/24 US TREASURY N/B NOTES
DTD 05/31/2024 4.500% 05/31/2029
91282CKT7 (805,718.75) (2,655.74) (808,374.49) 800,000.00 06/26/24 06/27/24 FEDERAL FARM CREDIT BANK NOTES
DTD 06/07/2024 4.500% 06/07/2028
3133ERGL9 (1,000,330.00) (2,500.00) (1,002,830.00) 1,000,000.00 06/26/24 (5,155.74) (2,036,170.31)(2,031,014.57) 2,025,000.00 Transaction Type Sub-Total
INTEREST
06/03/24 MONEY MARKET FUND MONEY0002 0.00 1,365.87 1,365.87 0.00 06/03/24 06/08/24 TORONTO-DOMINION BANK
CORPORATE NOTES
DTD 06/08/2022 4.108% 06/08/2027
89115A2C5 0.00 11,810.50 11,810.50 575,000.00 06/08/24 06/08/24 FEDERAL FARM CREDIT BANK NOTES
DTD 06/08/2023 3.875% 06/08/2028
3133EPME2 0.00 7,750.00 7,750.00 400,000.00 06/08/24 06/15/24 JDOT 2023-A A3
DTD 03/02/2023 5.010% 11/15/2027
47800CAC0 0.00 835.00 835.00 200,000.00 06/15/24
06/15/24 MBALT 2024-A A3
DTD 05/23/2024 5.320% 01/18/2028
58770JAD6 0.00 438.90 438.90 135,000.00 06/15/24
06/15/24 TOYOTA AUTO RECEIVABLES
DTD 02/08/2021 0.260% 05/15/2025
89240BAC2 0.00 0.80 0.80 3,695.80 06/15/24
06/15/24 JDOT 2021-B A3
DTD 07/21/2021 0.520% 03/16/2026
47789QAC4 0.00 30.42 30.42 70,210.64 06/15/24
06/15/24 AMXCA 2022-2 A
DTD 05/24/2022 3.390% 05/17/2027
02582JJT8 0.00 1,271.25 1,271.25 450,000.00 06/15/24 06/15/24 CHAIT 2023-A1 A
DTD 09/15/2023 5.160% 09/15/2028
161571HT4 0.00 2,322.00 2,322.00 540,000.00 06/15/24 06/15/24 TAOT 2022-B A3
DTD 04/13/2022 2.930% 09/15/2026
89238FAD5 0.00 267.24 267.24 109,451.60 06/15/24
06/15/24 TAOT 2021-D A3
DTD 11/15/2021 0.710% 04/15/2026
89238JAC9 0.00 42.39 42.39 71,642.09 06/15/24
06/15/24 HART 2021-C A3
DTD 11/17/2021 0.740% 05/15/2026
44935FAD6 0.00 31.66 31.66 51,334.87 06/15/24
Account 03060055 Page 24
For the Month Ending June 30, 2024Managed Account Security Transactions & Interest CITY OF ALAMEDA (CHANDLER) - 03060055
Transaction Type
Trade CUSIPSecurity DescriptionSettle Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
INTEREST
06/15/24 REALTY INCOME CORP CORPORATE
NOTES (CALL
DTD 04/05/2023 4.700% 12/15/2028
756109BS2 0.00 7,050.00 7,050.00 300,000.00 06/15/24 06/15/24 HAROT 2024-1 A3
DTD 02/21/2024 5.210% 08/15/2028
437918AC9 0.00 2,062.29 2,062.29 475,000.00 06/15/24 06/15/24 JDOT 2021-A A3
DTD 03/10/2021 0.360% 09/15/2025
47788UAC6 0.00 6.22 6.22 20,727.60 06/15/24
06/15/24 JDOT 2022-A A3
DTD 03/16/2022 2.320% 09/16/2026
47787JAC2 0.00 189.13 189.13 97,824.39 06/15/24
06/15/24 AMXCA 2021-1 A
DTD 11/17/2021 0.900% 11/16/2026
02582JJR2 0.00 206.25 206.25 275,000.00 06/15/24
06/15/24 HART 2024-A A3
DTD 03/20/2024 4.990% 02/15/2029
448973AD9 0.00 852.46 852.46 205,000.00 06/15/24
06/15/24 HART 2022-A A3
DTD 03/16/2022 2.220% 10/15/2026
448977AD0 0.00 557.76 557.76 301,491.71 06/15/24
06/15/24 JDOT 2022-B A3
DTD 07/20/2022 3.740% 02/16/2027
47800AAC4 0.00 623.20 623.20 199,957.94 06/15/24
06/15/24 AMXCA 2024-1 A
DTD 04/23/2024 5.230% 04/16/2029
02582JKH2 0.00 849.88 849.88 195,000.00 06/15/24
06/15/24 HAROT 2022-1 A3
DTD 02/23/2022 1.880% 05/15/2026
43815BAC4 0.00 285.99 285.99 182,546.13 06/15/24
06/16/24 GMCAR 2021-4 A3
DTD 10/21/2021 0.680% 09/16/2026
362554AC1 0.00 34.87 34.87 61,534.96 06/16/24
06/16/24 GMCAR 2022-1 A3
DTD 01/19/2022 1.260% 11/16/2026
380146AC4 0.00 67.75 67.75 64,520.63 06/16/24
06/17/24 FANNIE MAE NOTES
DTD 06/19/2020 0.500% 06/17/2025
3135G04Z3 0.00 2,562.50 2,562.50 1,025,000.00 06/17/24 06/17/24 PROLOGIS LP CORPORATE NOTES
(CALLABLE)
DTD 06/26/2023 4.875% 06/15/2028
74340XCG4 0.00 6,093.75 6,093.75 0.00 06/17/24
06/18/24 TOYOTA MOTOR CREDIT CORP
CORPORATE NOTES
DTD 06/18/2021 1.125% 06/18/2026
89236TJK2 0.00 4,275.00 4,275.00 760,000.00 06/18/24 Account 03060055 Page 25
For the Month Ending June 30, 2024Managed Account Security Transactions & Interest CITY OF ALAMEDA (CHANDLER) - 03060055
Transaction Type
Trade CUSIPSecurity DescriptionSettle Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
INTEREST
06/18/24 HAROT 2024-2 A3
DTD 05/21/2024 5.270% 11/20/2028
437930AC4 0.00 691.69 691.69 175,000.00 06/18/24
06/19/24 BANK OF AMERICA CORP NOTES
(CALLABLE)
DTD 06/16/2020 1.319% 06/19/2026
06051GJD2 0.00 3,297.50 3,297.50 500,000.00 06/19/24 06/20/24 GMALT 2024-2 A3
DTD 05/16/2024 5.390% 07/20/2027
36269WAD1 0.00 941.75 941.75 185,000.00 06/20/24
06/20/24 GMALT 2024-1 A3
DTD 02/15/2024 5.090% 03/22/2027
36269FAD8 0.00 1,230.08 1,230.08 290,000.00 06/20/24 06/21/24 HAROT 2021-4 A3
DTD 11/24/2021 0.880% 01/21/2026
43815GAC3 0.00 54.02 54.02 73,657.55 06/21/24
06/21/24 HAROT 2021-1 A3
DTD 02/24/2021 0.270% 04/21/2025
43813GAC5 0.00 0.06 0.06 251.59 06/21/24
06/25/24 BMWOT 2022-A A3
DTD 05/18/2022 3.210% 08/25/2026
05602RAD3 0.00 317.96 317.96 118,862.96 06/25/24
06/30/24 US TREASURY NOTES
DTD 06/30/2022 3.250% 06/30/2027
91282CEW7 0.00 8,125.00 8,125.00 500,000.00 06/30/24 06/30/24 US TREASURY NOTES
DTD 12/31/2022 3.875% 12/31/2027
91282CGC9 0.00 8,718.75 8,718.75 450,000.00 06/30/24 06/30/24 US TREASURY N/B NOTES
DTD 12/31/2023 3.750% 12/31/2028
91282CJR3 0.00 16,875.00 16,875.00 900,000.00 06/30/24 92,134.89 92,134.89 0.00 9,962,710.46 Transaction Type Sub-Total
PAYDOWNS
06/15/24 TOYOTA AUTO RECEIVABLES
DTD 02/08/2021 0.260% 05/15/2025
89240BAC2 3,695.80 0.00 3,695.80 0.69 0.00 3,695.80 06/15/24 06/15/24 JDOT 2021-B A3
DTD 07/21/2021 0.520% 03/16/2026
47789QAC4 8,459.13 0.00 8,459.13 0.75 0.00 8,459.13 06/15/24 06/15/24 HAROT 2022-1 A3
DTD 02/23/2022 1.880% 05/15/2026
43815BAC4 15,364.04 0.00 15,364.04 2.31 0.00 15,364.04 06/15/24 06/15/24 TAOT 2021-D A3
DTD 11/15/2021 0.710% 04/15/2026
89238JAC9 7,114.37 0.00 7,114.37 0.15 0.00 7,114.37 06/15/24 06/15/24 TAOT 2022-B A3
DTD 04/13/2022 2.930% 09/15/2026
89238FAD5 8,144.78 0.00 8,144.78 0.19 0.00 8,144.78 06/15/24 Account 03060055 Page 26
For the Month Ending June 30, 2024Managed Account Security Transactions & Interest CITY OF ALAMEDA (CHANDLER) - 03060055
Transaction Type
Trade CUSIPSecurity DescriptionSettle Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
PAYDOWNS
06/15/24 JDOT 2022-B A3
DTD 07/20/2022 3.740% 02/16/2027
47800AAC4 10,724.28 0.00 10,724.28 1.02 0.00 10,724.28 06/15/24 06/15/24 HART 2022-A A3
DTD 03/16/2022 2.220% 10/15/2026
448977AD0 24,932.75 0.00 24,932.75 0.96 0.00 24,932.75 06/15/24 06/15/24 JDOT 2021-A A3
DTD 03/10/2021 0.360% 09/15/2025
47788UAC6 4,590.71 0.00 4,590.71 0.88 0.00 4,590.71 06/15/24 06/15/24 HART 2021-C A3
DTD 11/17/2021 0.740% 05/15/2026
44935FAD6 5,973.63 0.00 5,973.63 1.33 0.00 5,973.63 06/15/24 06/15/24 JDOT 2022-A A3
DTD 03/16/2022 2.320% 09/16/2026
47787JAC2 6,204.73 0.00 6,204.73 1.37 0.00 6,204.73 06/15/24 06/16/24 GMCAR 2021-4 A3
DTD 10/21/2021 0.680% 09/16/2026
362554AC1 5,626.56 0.00 5,626.56 0.14 0.00 5,626.56 06/16/24 06/16/24 GMCAR 2022-1 A3
DTD 01/19/2022 1.260% 11/16/2026
380146AC4 5,580.97 0.00 5,580.97 0.49 0.00 5,580.97 06/16/24 06/21/24 HAROT 2021-1 A3
DTD 02/24/2021 0.270% 04/21/2025
43813GAC5 251.59 0.00 251.59 0.00 0.00 251.59 06/21/24 06/21/24 HAROT 2021-4 A3
DTD 11/24/2021 0.880% 01/21/2026
43815GAC3 7,727.59 0.00 7,727.59 1.63 0.00 7,727.59 06/21/24 06/25/24 BMWOT 2022-A A3
DTD 05/18/2022 3.210% 08/25/2026
05602RAD3 9,974.92 0.00 9,974.92 0.52 0.00 9,974.92 06/25/24
0.00 0.00 12.43 124,365.85 124,365.85 124,365.85 Transaction Type Sub-Total SELL
06/27/24 MORGAN STANLEY CORP NOTES
(CALLABLE)
DTD 04/23/2020 2.188% 04/28/2026
6174468Q5 242,650.00 896.47 243,546.47 6,497.50 (902.59) FIFO 250,000.00 06/26/24 06/27/24 US TREASURY NOTES
DTD 03/15/2022 1.750% 03/15/2025
91282CED9 243,935.55 1,236.41 245,171.96 634.77 (4,427.28) FIFO 250,000.00 06/26/24 06/27/24 MORGAN STANLEY CORP NOTES
(CALLABLE)
DTD 04/23/2020 2.188% 04/28/2026
6174468Q5 291,180.00 1,075.77 292,255.77 8,760.00 (278.59) FIFO 300,000.00 06/26/24 06/27/24 FREDDIE MAC NOTES
DTD 02/14/2020 1.500% 02/12/2025
3137EAEP0 1,064,592.10 6,131.25 1,070,723.35 (24,568.60) (25,302.13) FIFO 1,090,000.00 06/26/24 Account 03060055 Page 27
For the Month Ending June 30, 2024Managed Account Security Transactions & Interest CITY OF ALAMEDA (CHANDLER) - 03060055
Transaction Type
Trade CUSIPSecurity DescriptionSettle Par Proceeds
Principal Accrued
Interest Total Cost
Realized G/L Realized G/L Sale
Amort Cost Method
9,339.90 (30,910.59)(8,676.33) 1,851,697.55 1,842,357.65 1,890,000.00 Transaction Type Sub-Total (64,291.07) 96,319.05 32,027.98 (8,663.90) (30,910.59)Managed Account Sub-Total Total Security Transactions ($8,663.90)$32,027.98 $96,319.05 ($64,291.07) ($30,910.59) Account 03060055 Page 28