City of Alameda
Finance Department
2263 Santa Clara Avenue, Room 220
Alameda, California 94501
(510) 747-4881
May 16, 2023
Honorable Mayor and City Council:
I have reviewed the City of Alameda’s Investment Transactions Report for the Quarter Ending March 31, 2023.
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 March 31, 2023, the City of Alameda has sufficient funds to meet its pool’s expenditure requirements for the next six months.
Sincerely,
Kevin Kennedy
City Treasurer
4XDUWHUO\,QYHVWPHQWTransactions 5HSRUW
California
CHANDLER ASSET MANAGEMENT, INC. | 800.317.4747 | www.chandlerasset.com
INVESTMENT REPORT
City of Alameda
Investment Transactions Reporting
For the Quarter Ending March 31, 2023
Transaction Ledger
City of Alameda - Account #270
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 01/25/2023 24422EWR6 400,000.00 John Deere Capital Corp Note
4.75% Due: 01/20/2028
101.539 4.40% 406,156.00 844.44 407,000.44 0.00
Purchase 01/26/2023 91282CGC9 450,000.00 US Treasury Note
3.875% Due: 12/31/2027
101.383 3.57% 456,222.66 1,252.42 457,475.08 0.00
Purchase 02/08/2023
91282CGH8 1,200,000.00 US Treasury Note
3.5% Due: 01/31/2028
98.598 3.81% 1,183,171.88 928.18 1,184,100.06 0.00
Purchase 03/02/2023
47800CAC0 200,000.00 John Deere Owner Trust 2023-A A3
5.01% Due: 11/15/2027
100.055 5.04% 200,109.38 0.00 200,109.38 0.00
Purchase 03/09/2023 57636QAW4 310,000.00 MasterCard Inc Callable Note Cont 2/9/28
4.875% Due: 03/09/2028
99.903 4.90% 309,699.30 0.00 309,699.30 0.00
Purchase 03/17/2023
91282CGP0 850,000.00 US Treasury Note
4% Due: 02/29/2028
100.883 3.80% 857,503.91 1,570.65 859,074.56 0.00
Subtotal 3,410,000.00 3,412,863.13 4,595.69 3,417,458.82 0.00 TOTAL ACQUISITIONS 3,410,000.00 3,412,863.13 4,595.69 3,417,458.82 0.00
DISPOSITIONS
Sale 01/26/2023
3135G0U43 405,000.00 FNMA Note
2.875% Due: 09/12/2023
98.763 2.96% 399,990.15 4,334.06 404,324.21 -4,801.38
Sale 02/08/2023 3135G05G4 775,000.00 FNMA Note
0.25% Due: 07/10/2023
98.101 0.32% 760,282.75 150.69 760,433.44 -14,485.95
Sale 02/08/2023
3137EAEV7 425,000.00 FHLMC Note
0.25% Due: 08/24/2023
97.506 0.28% 414,400.50 484.03 414,884.53 -10,521.72
Sale 03/09/2023
24422EVN6 350,000.00 John Deere Capital Corp Note
0.45% Due: 01/17/2024
95.959 0.47% 335,856.50 227.50 336,084.00 -14,069.12
December 31, 2022 through March 31, 2023
As of March 31, 2023
36 Transaction Ledger
City of Alameda - Account #270
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
Sale 03/15/2023 3130A0F70 750,000.00 FHLB Note
3.375% Due: 12/08/2023
98.833 2.77% 741,244.46 6,820.31 748,064.77 -11,850.25
Subtotal 2,705,000.00 2,651,774.36 12,016.59 2,663,790.95 -55,728.42 TOTAL DISPOSITIONS 2,705,000.00 2,651,774.36 12,016.59 2,663,790.95 -55,728.42 December 31, 2022 through March 31, 2023
As of March 31, 2023
37 Transaction Ledger
City of Alameda - Account #270
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 01/03/2023 316175603 427.33 Fidelity Institutional Government MMKT Fund #657
1.000 3.81% 427.33 0.00 427.33 0.00
Purchase 01/07/2023 316175603 7,840.63 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 7,840.63 0.00 7,840.63 0.00
Purchase 01/10/2023 316175603 968.75 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 968.75 0.00 968.75 0.00
Purchase 01/13/2023 316175603 3,190.00 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 3,190.00 0.00 3,190.00 0.00
Purchase 01/15/2023 316175603 12,421.25 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 12,421.25 0.00 12,421.25 0.00
Purchase 01/17/2023 316175603 787.50 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 787.50 0.00 787.50 0.00
Purchase 01/17/2023 316175603 670.08 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 670.08 0.00 670.08 0.00
Purchase 01/17/2023 316175603 91.00 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 91.00 0.00 91.00 0.00
Purchase 01/17/2023 316175603 319.00 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 319.00 0.00 319.00 0.00
Purchase 01/17/2023 316175603 423.00 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 423.00 0.00 423.00 0.00
Purchase 01/17/2023 316175603 115.50 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 115.50 0.00 115.50 0.00
Purchase 01/17/2023 316175603 91.71 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 91.71 0.00 91.71 0.00
Purchase 01/17/2023 316175603 354.04 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 354.04 0.00 354.04 0.00
Purchase 01/17/2023 316175603 74.00 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 74.00 0.00 74.00 0.00
Purchase 01/17/2023 316175603 814.00 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 814.00 0.00 814.00 0.00
December 31, 2022 through March 31, 2023
As of March 31, 2023
38 Transaction Ledger
City of Alameda - Account #270
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
Purchase 01/17/2023 316175603 206.25 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 206.25 0.00 206.25 0.00
Purchase 01/17/2023 316175603 1,271.25 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 1,271.25 0.00 1,271.25 0.00
Purchase 01/17/2023 316175603 70.83 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 70.83 0.00 70.83 0.00
Purchase 01/17/2023 316175603 6,319.47 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 6,319.47 0.00 6,319.47 0.00
Purchase 01/17/2023 316175603 5,227.91 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 5,227.91 0.00 5,227.91 0.00
Purchase 01/17/2023 316175603 11,003.10 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 11,003.10 0.00 11,003.10 0.00
Purchase 01/17/2023 316175603 9,467.89 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 9,467.89 0.00 9,467.89 0.00
Purchase 01/17/2023 316175603 21,030.26 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 21,030.26 0.00 21,030.26 0.00
Purchase 01/17/2023 316175603 11,836.29 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 11,836.29 0.00 11,836.29 0.00
Purchase 01/17/2023 316175603 10,318.23 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 10,318.23 0.00 10,318.23 0.00
Purchase 01/17/2023 316175603 22,356.66 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 22,356.66 0.00 22,356.66 0.00
Purchase 01/18/2023 316175603 13,187.05 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 13,187.05 0.00 13,187.05 0.00
Purchase 01/20/2023 316175603 113.75 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 113.75 0.00 113.75 0.00
Purchase 01/20/2023 316175603 435.42 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 435.42 0.00 435.42 0.00
Purchase 01/20/2023 316175603 573.50 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 573.50 0.00 573.50 0.00
Purchase 01/20/2023 316175603 31,912.55 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 31,912.55 0.00 31,912.55 0.00
December 31, 2022 through March 31, 2023
As of March 31, 2023
39 Transaction Ledger
City of Alameda - Account #270
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
Purchase 01/20/2023 316175603 8,263.99 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 8,263.99 0.00 8,263.99 0.00
Purchase 01/21/2023 316175603 8,225.63 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 8,225.63 0.00 8,225.63 0.00
Purchase 01/23/2023 316175603 121.00 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 121.00 0.00 121.00 0.00
Purchase 01/23/2023 316175603 6,553.69 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 6,553.69 0.00 6,553.69 0.00
Purchase 01/25/2023 24422EWR6 400,000.00 John Deere Capital Corp Note
4.75% Due: 01/20/2028
101.539
4.40% 406,156.00 844.44 407,000.44 0.00
Purchase 01/25/2023 316175603 151.25 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 151.25 0.00 151.25 0.00
Purchase 01/25/2023 316175603 468.13 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 468.13 0.00 468.13 0.00
Purchase 01/25/2023 316175603 27,371.74 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 27,371.74 0.00 27,371.74 0.00
Purchase 01/26/2023 91282CGC9 450,000.00 US Treasury Note
3.875% Due: 12/31/2027
101.383
3.57% 456,222.66 1,252.42 457,475.08 0.00
Purchase 01/31/2023 316175603 2,750.00 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 2,750.00 0.00 2,750.00 0.00
Purchase 02/01/2023 316175603 860.67 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 860.67 0.00 860.67 0.00
Purchase 02/05/2023 316175603 2,340.00 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 2,340.00 0.00 2,340.00 0.00
Purchase 02/08/2023 91282CGH8 1,200,000.00 US Treasury Note
3.5% Due: 01/31/2028
98.598
3.81% 1,183,171.88 928.18 1,184,100.06 0.00
Purchase 02/12/2023 316175603 8,175.00 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 8,175.00 0.00 8,175.00 0.00
Purchase 02/15/2023 316175603 28,943.75 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 28,943.75 0.00 28,943.75 0.00
Purchase 02/15/2023 316175603 10,122.50 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 10,122.50 0.00 10,122.50 0.00
December 31, 2022 through March 31, 2023
As of March 31, 2023
40 Transaction Ledger
City of Alameda - Account #270
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
Purchase 02/15/2023 316175603 22,952.33 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 22,952.33 0.00 22,952.33 0.00
Purchase 02/15/2023 316175603 91.71 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 91.71 0.00 91.71 0.00
Purchase 02/15/2023 316175603 354.04 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 354.04 0.00 354.04 0.00
Purchase 02/15/2023 316175603 206.25 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 206.25 0.00 206.25 0.00
Purchase 02/15/2023 316175603 1,271.25 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 1,271.25 0.00 1,271.25 0.00
Purchase 02/15/2023 316175603 423.00 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 423.00 0.00 423.00 0.00
Purchase 02/15/2023 316175603 814.00 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 814.00 0.00 814.00 0.00
Purchase 02/15/2023 316175603 74.00 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 74.00 0.00 74.00 0.00
Purchase 02/15/2023 316175603 319.00 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 319.00 0.00 319.00 0.00
Purchase 02/15/2023 316175603 91.00 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 91.00 0.00 91.00 0.00
Purchase 02/15/2023 316175603 670.08 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 670.08 0.00 670.08 0.00
Purchase 02/15/2023 316175603 6,328.41 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 6,328.41 0.00 6,328.41 0.00
Purchase 02/15/2023 316175603 7,986.28 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 7,986.28 0.00 7,986.28 0.00
Purchase 02/15/2023 316175603 11,090.20 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 11,090.20 0.00 11,090.20 0.00
Purchase 02/15/2023 316175603 10,806.48 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 10,806.48 0.00 10,806.48 0.00
Purchase 02/15/2023 316175603 7,678.41 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 7,678.41 0.00 7,678.41 0.00
December 31, 2022 through March 31, 2023
As of March 31, 2023
41 Transaction Ledger
City of Alameda - Account #270
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
Purchase 02/15/2023 316175603 11,879.24 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 11,879.24 0.00 11,879.24 0.00
Purchase 02/16/2023 316175603 115.50 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 115.50 0.00 115.50 0.00
Purchase 02/16/2023 316175603 70.83 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 70.83 0.00 70.83 0.00
Purchase 02/21/2023 316175603 435.42 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 435.42 0.00 435.42 0.00
Purchase 02/21/2023 316175603 573.50 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 573.50 0.00 573.50 0.00
Purchase 02/21/2023 316175603 121.00 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 121.00 0.00 121.00 0.00
Purchase 02/21/2023 316175603 3,745.86 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 3,745.86 0.00 3,745.86 0.00
Purchase 02/21/2023 316175603 6,427.74 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 6,427.74 0.00 6,427.74 0.00
Purchase 02/21/2023 316175603 12,686.11 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 12,686.11 0.00 12,686.11 0.00
Purchase 02/21/2023 316175603 29,078.25 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 29,078.25 0.00 29,078.25 0.00
Purchase 02/21/2023 316175603 128.02 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 128.02 0.00 128.02 0.00
Purchase 02/24/2023 316175603 200.00 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 200.00 0.00 200.00 0.00
Purchase 02/25/2023 316175603 1,921.88 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 1,921.88 0.00 1,921.88 0.00
Purchase 02/27/2023 316175603 468.13 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 468.13 0.00 468.13 0.00
Purchase 02/27/2023 316175603 151.25 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 151.25 0.00 151.25 0.00
Purchase 02/27/2023 316175603 26,410.50 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 26,410.50 0.00 26,410.50 0.00
December 31, 2022 through March 31, 2023
As of March 31, 2023
42 Transaction Ledger
City of Alameda - Account #270
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
Purchase 02/28/2023 316175603 28,693.75 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 28,693.75 0.00 28,693.75 0.00
Purchase 03/01/2023 316175603 369.41 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 369.41 0.00 369.41 0.00
Purchase 03/02/2023 47800CAC0 200,000.00 John Deere Owner Trust 2023-A A3
5.01% Due: 11/15/2027
100.055 5.04% 200,109.38 0.00 200,109.38 0.00
Purchase 03/08/2023 316175603 11,281.25 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 11,281.25 0.00 11,281.25 0.00
Purchase 03/09/2023 316175603 336,084.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 336,084.00 0.00 336,084.00 0.00
Purchase 03/09/2023 57636QAW4 310,000.00 MasterCard Inc Callable Note Cont 2/9/28
4.875% Due: 03/09/2028
99.903
4.90% 309,699.30 0.00 309,699.30 0.00
Purchase 03/11/2023 316175603 3,075.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 3,075.00 0.00 3,075.00 0.00
Purchase 03/13/2023 316175603 11,500.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 11,500.00 0.00 11,500.00 0.00
Purchase 03/15/2023 316175603 748,064.77 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 748,064.77 0.00 748,064.77 0.00
Purchase 03/15/2023 316175603 11,290.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 11,290.00 0.00 11,290.00 0.00
Purchase 03/15/2023 316175603 91.71 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 91.71 0.00 91.71 0.00
Purchase 03/15/2023 316175603 354.04 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 354.04 0.00 354.04 0.00
Purchase 03/15/2023 316175603 670.08 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 670.08 0.00 670.08 0.00
Purchase 03/15/2023 316175603 91.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 91.00 0.00 91.00 0.00
Purchase 03/15/2023 316175603 319.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 319.00 0.00 319.00 0.00
December 31, 2022 through March 31, 2023
As of March 31, 2023
43 Transaction Ledger
City of Alameda - Account #270
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
Purchase 03/15/2023 316175603 74.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 74.00 0.00 74.00 0.00
Purchase 03/15/2023 316175603 814.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 814.00 0.00 814.00 0.00
Purchase 03/15/2023 316175603 423.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 423.00 0.00 423.00 0.00
Purchase 03/15/2023 316175603 1,271.25 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 1,271.25 0.00 1,271.25 0.00
Purchase 03/15/2023 316175603 206.25 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 206.25 0.00 206.25 0.00
Purchase 03/15/2023 316175603 6,012.92 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 6,012.92 0.00 6,012.92 0.00
Purchase 03/15/2023 316175603 5,000.21 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 5,000.21 0.00 5,000.21 0.00
Purchase 03/15/2023 316175603 7,786.77 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 7,786.77 0.00 7,786.77 0.00
Purchase 03/15/2023 316175603 7,718.59 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 7,718.59 0.00 7,718.59 0.00
Purchase 03/15/2023 316175603 11,070.71 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 11,070.71 0.00 11,070.71 0.00
Purchase 03/15/2023 316175603 9,427.63 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 9,427.63 0.00 9,427.63 0.00
Purchase 03/15/2023 316175603 21,510.65 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 21,510.65 0.00 21,510.65 0.00
Purchase 03/16/2023 316175603 70.83 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 70.83 0.00 70.83 0.00
Purchase 03/16/2023 316175603 115.50 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 115.50 0.00 115.50 0.00
Purchase 03/17/2023 316175603 656.25 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 656.25 0.00 656.25 0.00
Purchase 03/17/2023 91282CGP0 850,000.00 US Treasury Note 4% Due: 02/29/2028
100.883
3.80% 857,503.91 1,570.65 859,074.56 0.00
December 31, 2022 through March 31, 2023
As of March 31, 2023
44 Transaction Ledger
City of Alameda - Account #270
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
Purchase 03/18/2023 316175603 1,087.50 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 1,087.50 0.00 1,087.50 0.00
Purchase 03/20/2023 316175603 573.50 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 573.50 0.00 573.50 0.00
Purchase 03/20/2023 316175603 435.42 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 435.42 0.00 435.42 0.00
Purchase 03/20/2023 316175603 27,581.39 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 27,581.39 0.00 27,581.39 0.00
Purchase 03/20/2023 316175603 12,161.53 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 12,161.53 0.00 12,161.53 0.00
Purchase 03/20/2023 316175603 25,348.30 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 25,348.30 0.00 25,348.30 0.00
Purchase 03/21/2023 316175603 121.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 121.00 0.00 121.00 0.00
Purchase 03/21/2023 316175603 6,066.85 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 6,066.85 0.00 6,066.85 0.00
Purchase 03/23/2023 316175603 1,921.88 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 1,921.88 0.00 1,921.88 0.00
Purchase 03/27/2023 316175603 151.25 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 151.25 0.00 151.25 0.00
Purchase 03/27/2023 316175603 468.13 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 468.13 0.00 468.13 0.00
Purchase 03/27/2023 316175603 25,686.26 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 25,686.26 0.00 25,686.26 0.00
Purchase 03/31/2023 316175603 40,181.25 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 40,181.25 0.00 40,181.25 0.00
Subtotal 5,219,662.05 5,222,525.18 4,595.69 5,227,120.87 0.00 December 31, 2022 through March 31, 2023
As of March 31, 2023
45 Transaction Ledger
City of Alameda - Account #270
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
Short Sale 03/09/2023 316175603 -309,699.30 Fidelity Institutional Government MMKT Fund #657
1.000 -309,699.30 0.00 -309,699.30 0.00
Subtotal -309,699.30 -309,699.30 0.00 -309,699.30 0.00
TOTAL ACQUISITIONS 4,909,962.75 4,912,825.88 4,595.69 4,917,421.57 0.00
DISPOSITIONS
Closing
Purchase
03/09/2023
316175603 -309,699.30 Fidelity Institutional Government MMKT Fund #657
1.000 -309,699.30 0.00 -309,699.30 0.00
Subtotal -309,699.30 -309,699.30 0.00 -309,699.30 0.00
Sale 01/25/2023
316175603 407,000.44 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 407,000.44 0.00 407,000.44 0.00
Sale 01/26/2023 3135G0U43 405,000.00 FNMA Note
2.875% Due: 09/12/2023
98.763
2.96% 399,990.15 4,334.06 404,324.21 -4,801.38
Sale 01/26/2023 316175603 53,150.87 Fidelity Institutional Government MMKT Fund #657
1.000
3.81% 53,150.87 0.00 53,150.87 0.00
Sale 02/08/2023 3135G05G4 775,000.00 FNMA Note
0.25% Due: 07/10/2023
98.101
0.32% 760,282.75 150.69 760,433.44 -14,485.95
Sale 02/08/2023 3137EAEV7 425,000.00 FHLMC Note
0.25% Due: 08/24/2023
97.506
0.28% 414,400.50 484.03 414,884.53 -10,521.72
Sale 02/08/2023 316175603 8,782.09 Fidelity Institutional Government MMKT Fund #657
1.000
3.93% 8,782.09 0.00 8,782.09 0.00
Sale 03/02/2023 316175603 200,109.38 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 200,109.38 0.00 200,109.38 0.00
Sale 03/09/2023 24422EVN6 350,000.00 John Deere Capital Corp Note
0.45% Due: 01/17/2024
95.959
0.47% 335,856.50 227.50 336,084.00 -14,069.12
Sale 03/09/2023 316175603 309,699.30 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 309,699.30 0.00 309,699.30 0.00
December 31, 2022 through March 31, 2023
As of March 31, 2023
46 Transaction Ledger
City of Alameda - Account #270
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
Sale 03/15/2023 3130A0F70 750,000.00 FHLB Note
3.375% Due: 12/08/2023
98.833
2.77% 741,244.46 6,820.31 748,064.77 -11,850.25
Sale 03/17/2023 316175603 859,074.56 Fidelity Institutional Government MMKT Fund #657
1.000
4.20% 859,074.56 0.00 859,074.56 0.00
Subtotal 4,542,816.64 4,489,591.00 12,016.59 4,501,607.59 -55,728.42 Paydown 01/17/2023 02582JJR2 0.00 American Express 2021-1 A
0.9% Due: 11/15/2026
100.000 0.00 206.25 206.25 0.00
Paydown 01/17/2023 02582JJT8 0.00 American Express Credit Trust 2022-2 A
3.39% Due: 05/17/2027
100.000 0.00 1,271.25 1,271.25 0.00
Paydown 01/17/2023 362554AC1 0.00 GM Financial Securitized Term 2021-4 A3
0.68% Due: 09/16/2026
100.000 0.00 70.83 70.83 0.00
Paydown 01/17/2023 380146AC4 0.00 GM Financial Auto Receivables 2022-1 A3
1.26% Due: 11/16/2026
100.000 0.00 115.50 115.50 0.00
Paydown 01/17/2023 43813DAC2 6,285.06 Honda Auto Receivables 2020-2 A3
0.82% Due: 07/15/2024
100.000 6,285.06 34.41 6,319.47 0.00
Paydown 01/17/2023 43815BAC4 0.00 Honda Auto Receivables Trust 2022-1 A3
1.88% Due: 05/15/2026
100.000 0.00 423.00 423.00 0.00
Paydown 01/17/2023 448977AD0 0.00 Hyundai Auto Receivables Trust 2022-A A3
2.22% Due: 10/15/2026
100.000 0.00 814.00 814.00 0.00
Paydown 01/17/2023 44935FAD6 0.00 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due: 05/15/2026
100.000 0.00 74.00 74.00 0.00
Paydown 01/17/2023 47787JAC2 0.00 John Deere Owner Trust 2022-A A3
2.32% Due: 09/16/2026
100.000 0.00 319.00 319.00 0.00
Paydown 01/17/2023 47787NAC3 5,208.55 John Deere Owner Trust 2020-B A3
0.51% Due: 11/15/2024
100.000 5,208.55 19.36 5,227.91 0.00
Paydown 01/17/2023 47788UAC6 10,956.00 John Deere Owner Trust 2021-A A3
0.36% Due: 09/15/2025
100.000 10,956.00 47.10 11,003.10 0.00
December 31, 2022 through March 31, 2023
As of March 31, 2023
47 Transaction Ledger
City of Alameda - Account #270
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
Paydown 01/17/2023 47789KAC7 9,417.94 John Deere Owner Trust 2020-A A3
1.1% Due: 08/15/2024
100.000 9,417.94 49.95 9,467.89 0.00
Paydown 01/17/2023 47789QAC4 0.00 John Deere Owner Trust 2021-B A3
0.52% Due: 03/16/2026
100.000 0.00 91.00 91.00 0.00
Paydown 01/17/2023 47800AAC4 0.00 John Deere Owner Trust 2022-B A3
3.74% Due: 02/16/2027
100.000 0.00 670.08 670.08 0.00
Paydown 01/17/2023 58769EAC2 21,020.69 Mercedes-Benz Auto Lease Trust 2020-B A3
0.4% Due: 11/15/2023
100.000 21,020.69 9.57 21,030.26 0.00
Paydown 01/17/2023 65479JAD5 11,765.98 Nissan Auto Receivables Owner 2019-C A3
1.93% Due: 07/15/2024
100.000 11,765.98 70.31 11,836.29 0.00
Paydown 01/17/2023 89236XAC0 10,289.10 Toyota Auto Receivables 2020-D A3
0.35% Due: 01/15/2025
100.000 10,289.10 29.13 10,318.23 0.00
Paydown 01/17/2023 89238FAD5 0.00 Toyota Auto Receivables OT 2022-B A3
2.93% Due: 09/15/2026
100.000 0.00 354.04 354.04 0.00
Paydown 01/17/2023 89238JAC9 0.00 Toyota Auto Receivables Trust 2021-D A3
0.71% Due: 04/15/2026
100.000 0.00 91.71 91.71 0.00
Paydown 01/17/2023 89240BAC2 22,288.20 Toyota Auto Receivables Owners 2021-A A3
0.26% Due: 05/15/2025
100.000 22,288.20 68.46 22,356.66 0.00
Paydown 01/18/2023 43813KAC6 13,146.07 Honda Auto Receivables Trust 2020-3 A3
0.37% Due: 10/18/2024
100.000 13,146.07 40.98 13,187.05 0.00
Paydown 01/20/2023 36262XAC8 0.00 GM Financial Auto Lease Trust 2021-3 A2
0.39% Due: 10/21/2024
100.000 0.00 113.75 113.75 0.00
Paydown 01/20/2023 36265MAC9 0.00 GM Financial Auto Lease Trust 2022-1 A3
1.9% Due: 03/20/2025
100.000 0.00 435.42 435.42 0.00
Paydown 01/20/2023 92290BAA9 31,831.15 Verizon Owner Trust 2020-B A
0.47% Due: 02/20/2025
100.000 31,831.15 81.40 31,912.55 0.00
December 31, 2022 through March 31, 2023
As of March 31, 2023
48 Transaction Ledger
City of Alameda - Account #270
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
Paydown 01/20/2023 92348AAA3 8,250.45 Verizon Owner Trust 2019-C A1A
1.94% Due: 04/22/2024
100.000 8,250.45 13.54 8,263.99 0.00
Paydown 01/20/2023 92348KAV5 0.00 Verizon Master Trust 2022-5 A1A
3.72% Due: 07/20/2027
100.000 0.00 573.50 573.50 0.00
Paydown 01/23/2023 43813GAC5 6,533.97 Honda Auto Receivables Trust 2021-1 A3
0.27% Due: 04/21/2025
100.000 6,533.97 19.72 6,553.69 0.00
Paydown 01/23/2023 43815GAC3 0.00 Honda Auto Receivables Trust 2021-4 A3
0.88% Due: 01/21/2026
100.000 0.00 121.00 121.00 0.00
Paydown 01/25/2023 05601XAC3 0.00 BMW Vehicle Lease Trust 2022-1 A3
1.1% Due: 03/25/2025
100.000 0.00 151.25 151.25 0.00
Paydown 01/25/2023 05602RAD3 0.00 BMW Vehicle Owner Trust 2022-A A3
3.21% Due: 08/25/2026
100.000 0.00 468.13 468.13 0.00
Paydown 01/25/2023 09690AAC7 27,290.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due: 12/26/2024
100.000 27,290.00 81.74 27,371.74 0.00
Paydown 02/15/2023 02582JJR2 0.00 American Express 2021-1 A
0.9% Due: 11/15/2026
100.000 0.00 206.25 206.25 0.00
Paydown 02/15/2023 02582JJT8 0.00 American Express Credit Trust 2022-2 A
3.39% Due: 05/17/2027
100.000 0.00 1,271.25 1,271.25 0.00
Paydown 02/15/2023 43813DAC2 6,298.29 Honda Auto Receivables 2020-2 A3
0.82% Due: 07/15/2024
100.000 6,298.29 30.12 6,328.41 0.00
Paydown 02/15/2023 43815BAC4 0.00 Honda Auto Receivables Trust 2022-1 A3
1.88% Due: 05/15/2026
100.000 0.00 423.00 423.00 0.00
Paydown 02/15/2023 448977AD0 0.00 Hyundai Auto Receivables Trust 2022-A A3
2.22% Due: 10/15/2026
100.000 0.00 814.00 814.00 0.00
Paydown 02/15/2023 44935FAD6 0.00 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due: 05/15/2026
100.000 0.00 74.00 74.00 0.00
Paydown 02/15/2023 47787JAC2 0.00 John Deere Owner Trust 2022-A A3
2.32% Due: 09/16/2026
100.000 0.00 319.00 319.00 0.00
Paydown 02/15/2023 47787NAC3 7,969.13 John Deere Owner Trust 2020-B A3
0.51% Due: 11/15/2024
100.000 7,969.13 17.15 7,986.28 0.00
December 31, 2022 through March 31, 2023
As of March 31, 2023
49 Transaction Ledger
City of Alameda - Account #270
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
Paydown 02/15/2023 47788UAC6 11,046.39 John Deere Owner Trust 2021-A A3
0.36% Due: 09/15/2025
100.000 11,046.39 43.81 11,090.20 0.00
Paydown 02/15/2023 47789KAC7 10,765.16 John Deere Owner Trust 2020-A A3
1.1% Due: 08/15/2024
100.000 10,765.16 41.32 10,806.48 0.00
Paydown 02/15/2023 47789QAC4 0.00 John Deere Owner Trust 2021-B A3
0.52% Due: 03/16/2026
100.000 0.00 91.00 91.00 0.00
Paydown 02/15/2023 47800AAC4 0.00 John Deere Owner Trust 2022-B A3
3.74% Due: 02/16/2027
100.000 0.00 670.08 670.08 0.00
Paydown 02/15/2023 58769EAC2 7,675.85 Mercedes-Benz Auto Lease Trust 2020-B A3
0.4% Due: 11/15/2023
100.000 7,675.85 2.56 7,678.41 0.00
Paydown 02/15/2023 65479JAD5 11,827.86 Nissan Auto Receivables Owner 2019-C A3
1.93% Due: 07/15/2024
100.000 11,827.86 51.38 11,879.24 0.00
Paydown 02/15/2023 89236XAC0 10,096.37 Toyota Auto Receivables 2020-D A3
0.35% Due: 01/15/2025
100.000 10,096.37 26.13 10,122.50 0.00
Paydown 02/15/2023 89238FAD5 0.00 Toyota Auto Receivables OT 2022-B A3
2.93% Due: 09/15/2026
100.000 0.00 354.04 354.04 0.00
Paydown 02/15/2023 89238JAC9 0.00 Toyota Auto Receivables Trust 2021-D A3
0.71% Due: 04/15/2026
100.000 0.00 91.71 91.71 0.00
Paydown 02/15/2023 89240BAC2 22,888.70 Toyota Auto Receivables Owners 2021-A A3
0.26% Due: 05/15/2025
100.000 22,888.70 63.63 22,952.33 0.00
Paydown 02/16/2023 362554AC1 0.00 GM Financial Securitized Term 2021-4 A3
0.68% Due: 09/16/2026
100.000 0.00 70.83 70.83 0.00
Paydown 02/16/2023 380146AC4 0.00 GM Financial Auto Receivables 2022-1 A3
1.26% Due: 11/16/2026
100.000 0.00 115.50 115.50 0.00
Paydown 02/21/2023 36262XAC8 3,632.11 GM Financial Auto Lease Trust 2021-3 A2
0.39% Due: 10/21/2024
100.000 3,632.11 113.75 3,745.86 0.00
December 31, 2022 through March 31, 2023
As of March 31, 2023
50 Transaction Ledger
City of Alameda - Account #270
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
Paydown 02/21/2023 36265MAC9 0.00 GM Financial Auto Lease Trust 2022-1 A3
1.9% Due: 03/20/2025
100.000 0.00 435.42 435.42 0.00
Paydown 02/21/2023 43813GAC5 6,409.49 Honda Auto Receivables Trust 2021-1 A3
0.27% Due: 04/21/2025
100.000 6,409.49 18.25 6,427.74 0.00
Paydown 02/21/2023 43813KAC6 12,649.18 Honda Auto Receivables Trust 2020-3 A3
0.37% Due: 10/18/2024
100.000 12,649.18 36.93 12,686.11 0.00
Paydown 02/21/2023 43815GAC3 0.00 Honda Auto Receivables Trust 2021-4 A3
0.88% Due: 01/21/2026
100.000 0.00 121.00 121.00 0.00
Paydown 02/21/2023 92290BAA9 29,009.32 Verizon Owner Trust 2020-B A
0.47% Due: 02/20/2025
100.000 29,009.32 68.93 29,078.25 0.00
Paydown 02/21/2023 92348AAA3 127.81 Verizon Owner Trust 2019-C A1A
1.94% Due: 04/22/2024
100.000 127.81 0.21 128.02 0.00
Paydown 02/21/2023 92348KAV5 0.00 Verizon Master Trust 2022-5 A1A
3.72% Due: 07/20/2027
100.000 0.00 573.50 573.50 0.00
Paydown 02/27/2023 05601XAC3 0.00 BMW Vehicle Lease Trust 2022-1 A3
1.1% Due: 03/25/2025
100.000 0.00 151.25 151.25 0.00
Paydown 02/27/2023 05602RAD3 0.00 BMW Vehicle Owner Trust 2022-A A3
3.21% Due: 08/25/2026
100.000 0.00 468.13 468.13 0.00
Paydown 02/27/2023 09690AAC7 26,336.26 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due: 12/26/2024
100.000 26,336.26 74.24 26,410.50 0.00
Paydown 03/15/2023 02582JJR2 0.00 American Express 2021-1 A
0.9% Due: 11/15/2026
100.000 0.00 206.25 206.25 0.00
Paydown 03/15/2023 02582JJT8 0.00 American Express Credit Trust 2022-2 A
3.39% Due: 05/17/2027
100.000 0.00 1,271.25 1,271.25 0.00
Paydown 03/15/2023 43813DAC2 5,987.11 Honda Auto Receivables 2020-2 A3
0.82% Due: 07/15/2024
100.000 5,987.11 25.81 6,012.92 0.00
Paydown 03/15/2023 43815BAC4 0.00 Honda Auto Receivables Trust 2022-1 A3
1.88% Due: 05/15/2026
100.000 0.00 423.00 423.00 0.00
Paydown 03/15/2023 448977AD0 0.00 Hyundai Auto Receivables Trust 2022-A A3
2.22% Due: 10/15/2026
100.000 0.00 814.00 814.00 0.00
December 31, 2022 through March 31, 2023
As of March 31, 2023
51 Transaction Ledger
City of Alameda - Account #270
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
Paydown 03/15/2023 44935FAD6 0.00 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due: 05/15/2026
100.000 0.00 74.00 74.00 0.00
Paydown 03/15/2023 47787JAC2 0.00 John Deere Owner Trust 2022-A A3
2.32% Due: 09/16/2026
100.000 0.00 319.00 319.00 0.00
Paydown 03/15/2023 47787NAC3 4,986.45 John Deere Owner Trust 2020-B A3
0.51% Due: 11/15/2024
100.000 4,986.45 13.76 5,000.21 0.00
Paydown 03/15/2023 47788UAC6 7,746.27 John Deere Owner Trust 2021-A A3
0.36% Due: 09/15/2025
100.000 7,746.27 40.50 7,786.77 0.00
Paydown 03/15/2023 47789KAC7 7,687.14 John Deere Owner Trust 2020-A A3
1.1% Due: 08/15/2024
100.000 7,687.14 31.45 7,718.59 0.00
Paydown 03/15/2023 47789QAC4 0.00 John Deere Owner Trust 2021-B A3
0.52% Due: 03/16/2026
100.000 0.00 91.00 91.00 0.00
Paydown 03/15/2023 47800AAC4 0.00 John Deere Owner Trust 2022-B A3
3.74% Due: 02/16/2027
100.000 0.00 670.08 670.08 0.00
Paydown 03/15/2023 65479JAD5 11,038.35 Nissan Auto Receivables Owner 2019-C A3
1.93% Due: 07/15/2024
100.000 11,038.35 32.36 11,070.71 0.00
Paydown 03/15/2023 89236XAC0 9,404.44 Toyota Auto Receivables 2020-D A3
0.35% Due: 01/15/2025
100.000 9,404.44 23.19 9,427.63 0.00
Paydown 03/15/2023 89238FAD5 0.00 Toyota Auto Receivables OT 2022-B A3
2.93% Due: 09/15/2026
100.000 0.00 354.04 354.04 0.00
Paydown 03/15/2023 89238JAC9 0.00 Toyota Auto Receivables Trust 2021-D A3
0.71% Due: 04/15/2026
100.000 0.00 91.71 91.71 0.00
Paydown 03/15/2023 89240BAC2 21,451.98 Toyota Auto Receivables Owners 2021-A A3
0.26% Due: 05/15/2025
100.000 21,451.98 58.67 21,510.65 0.00
Paydown 03/16/2023 362554AC1 0.00 GM Financial Securitized Term 2021-4 A3
0.68% Due: 09/16/2026
100.000 0.00 70.83 70.83 0.00
December 31, 2022 through March 31, 2023
As of March 31, 2023
52 Transaction Ledger
City of Alameda - Account #270
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
Paydown 03/16/2023 380146AC4 0.00 GM Financial Auto Receivables 2022-1 A3
1.26% Due: 11/16/2026
100.000 0.00 115.50 115.50 0.00
Paydown 03/20/2023 36262XAC8 27,468.82 GM Financial Auto Lease Trust 2021-3 A2
0.39% Due: 10/21/2024
100.000 27,468.82 112.57 27,581.39 0.00
Paydown 03/20/2023 36265MAC9 0.00 GM Financial Auto Lease Trust 2022-1 A3
1.9% Due: 03/20/2025
100.000 0.00 435.42 435.42 0.00
Paydown 03/20/2023 43813KAC6 12,128.50 Honda Auto Receivables Trust 2020-3 A3
0.37% Due: 10/18/2024
100.000 12,128.50 33.03 12,161.53 0.00
Paydown 03/20/2023 92290BAA9 25,290.73 Verizon Owner Trust 2020-B A
0.47% Due: 02/20/2025
100.000 25,290.73 57.57 25,348.30 0.00
Paydown 03/20/2023 92348KAV5 0.00 Verizon Master Trust 2022-5 A1A
3.72% Due: 07/20/2027
100.000 0.00 573.50 573.50 0.00
Paydown 03/21/2023 43813GAC5 6,050.04 Honda Auto Receivables Trust 2021-1 A3
0.27% Due: 04/21/2025
100.000 6,050.04 16.81 6,066.85 0.00
Paydown 03/21/2023 43815GAC3 0.00 Honda Auto Receivables Trust 2021-4 A3
0.88% Due: 01/21/2026
100.000 0.00 121.00 121.00 0.00
Paydown 03/27/2023 05601XAC3 0.00 BMW Vehicle Lease Trust 2022-1 A3
1.1% Due: 03/25/2025
100.000 0.00 151.25 151.25 0.00
Paydown 03/27/2023 05602RAD3 0.00 BMW Vehicle Owner Trust 2022-A A3
3.21% Due: 08/25/2026
100.000 0.00 468.13 468.13 0.00
Paydown 03/27/2023 09690AAC7 25,619.26 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due: 12/26/2024
100.000 25,619.26 67.00 25,686.26 0.00
Subtotal 515,874.17 515,874.17 20,530.43 536,404.60 0.00 TOTAL DISPOSITIONS 4,748,991.51 4,695,765.87 32,547.02 4,728,312.89 -55,728.42 December 31, 2022 through March 31, 2023
As of March 31, 2023
53 Transaction Ledger
City of Alameda - Account #270
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
Other Transactions
Interest 01/07/2023 3135G0X24 965,000.00 FNMA Note
1.625% Due: 01/07/2025
0.000 7,840.63 0.00 7,840.63 0.00
Interest 01/10/2023 3135G05G4 775,000.00 FNMA Note
0.25% Due: 07/10/2023
0.000 968.75 0.00 968.75 0.00
Interest 01/13/2023
89236TJT3 440,000.00 Toyota Motor Credit Corp Note
1.45% Due: 01/13/2025
0.000 3,190.00 0.00 3,190.00 0.00
Interest 01/15/2023
26444HAC5 500,000.00 Duke Energy Florida LLC Callable Note Cont 10/15/2026
3.2% Due: 01/15/2027
0.000 8,000.00 0.00 8,000.00 0.00
Interest 01/15/2023
79466LAG9 510,000.00 Salesforce.com Inc Callable Note Cont 7/15/2022
0.625% Due: 07/15/2024
0.000 1,593.75 0.00 1,593.75 0.00
Interest 01/15/2023
87612EBM7 290,000.00 Target Corp Callable Note Cont 12/15/2026
1.95% Due: 01/15/2027
0.000 2,827.50 0.00 2,827.50 0.00
Interest 01/17/2023
24422EVN6 350,000.00 John Deere Capital Corp Note
0.45% Due: 01/17/2024
0.000 787.50 0.00 787.50 0.00
Interest 01/21/2023
3137EAEU9 1,025,000.00 FHLMC Note
0.375% Due: 07/21/2025
0.000 1,921.88 0.00 1,921.88 0.00
Interest 01/21/2023
90331HPL1 615,000.00 US Bank NA Callable Note Cont 12/21/2024
2.05% Due: 01/21/2025
0.000 6,303.75 0.00 6,303.75 0.00
Interest 01/31/2023
91282CFB2 200,000.00 US Treasury Note
2.75% Due: 07/31/2027
0.000 2,750.00 0.00 2,750.00 0.00
Interest 02/05/2023
89788MAA0 390,000.00 Truist Financial Corp Callable Note Cont 07/03/2025
1.2% Due: 08/05/2025
0.000 2,340.00 0.00 2,340.00 0.00
Interest 02/12/2023
3137EAEP0 1,090,000.00 FHLMC Note
1.5% Due: 02/12/2025
0.000 8,175.00 0.00 8,175.00 0.00
December 31, 2022 through March 31, 2023
As of March 31, 2023
54 Transaction Ledger
City of Alameda - Account #270
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
Interest 02/15/2023 69371RQ25 125,000.00 Paccar Financial Corp Note
2.15% Due: 08/15/2024
0.000 1,343.75 0.00 1,343.75 0.00
Interest 02/15/2023
756109BG8 350,000.00 Realty Income Corp Calllable Note Cont 5/15/2027
3.95% Due: 08/15/2027
0.000 6,912.50 0.00 6,912.50 0.00
Interest 02/15/2023
912828B66 900,000.00 US Treasury Note
2.75% Due: 02/15/2024
0.000 12,375.00 0.00 12,375.00 0.00
Interest 02/15/2023
912828D56 700,000.00 US Treasury Note
2.375% Due: 08/15/2024
0.000 8,312.50 0.00 8,312.50 0.00
Interest 02/24/2023
3137EAEV7 160,000.00 FHLMC Note
0.25% Due: 08/24/2023
0.000 200.00 0.00 200.00 0.00
Interest 02/25/2023
3135G05X7 1,025,000.00 FNMA Note
0.375% Due: 08/25/2025
0.000 1,921.88 0.00 1,921.88 0.00
Interest 02/28/2023
912828ZC7 900,000.00 US Treasury Note
1.125% Due: 02/28/2025
0.000 5,062.50 0.00 5,062.50 0.00
Interest 02/28/2023
91282CCW9 260,000.00 US Treasury Note
0.75% Due: 08/31/2026
0.000 975.00 0.00 975.00 0.00
Interest 02/28/2023
91282CFH9 1,450,000.00 US Treasury Note
3.125% Due: 08/31/2027
0.000 22,656.25 0.00 22,656.25 0.00
Interest 03/08/2023
3130AB3H7 950,000.00 FHLB Note
2.375% Due: 03/08/2024
0.000 11,281.25 0.00 11,281.25 0.00
Interest 03/11/2023
037833DN7 300,000.00 Apple Inc Callable Note Cont 7/11/2026
2.05% Due: 09/11/2026
0.000 3,075.00 0.00 3,075.00 0.00
Interest 03/13/2023
3130A2UW4 800,000.00 FHLB Note
2.875% Due: 09/13/2024
0.000 11,500.00 0.00 11,500.00 0.00
Interest 03/15/2023
06368FAC3 250,000.00 Bank of Montreal Note
1.25% Due: 09/15/2026
0.000 1,562.50 0.00 1,562.50 0.00
Interest 03/15/2023
084664CZ2 585,000.00 Berkshire Hathaway Callable Note Cont 2/15/2027
2.3% Due: 03/15/2027
0.000 6,727.50 0.00 6,727.50 0.00
Interest 03/15/2023
91282CBR1 650,000.00 US Treasury Note
0.25% Due: 03/15/2024
0.000 812.50 0.00 812.50 0.00
December 31, 2022 through March 31, 2023
As of March 31, 2023
55 Transaction Ledger
City of Alameda - Account #270
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
Interest 03/15/2023 91282CED9 250,000.00 US Treasury Note
1.75% Due: 03/15/2025
0.000 2,187.50 0.00 2,187.50 0.00
Interest 03/17/2023
931142ER0 125,000.00 Wal-Mart Stores Callable Note Cont 08/17/2026
1.05% Due: 09/17/2026
0.000 656.25 0.00 656.25 0.00
Interest 03/18/2023
808513BN4 290,000.00 Charles Schwab Corp Callable Note Cont 2/18/2024
0.75% Due: 03/18/2024
0.000 1,087.50 0.00 1,087.50 0.00
Interest 03/23/2023
3137EAEX3 1,025,000.00 FHLMC Note
0.375% Due: 09/23/2025
0.000 1,921.88 0.00 1,921.88 0.00
Interest 03/31/2023
91282CAM3 1,200,000.00 US Treasury Note
0.25% Due: 09/30/2025
0.000 1,500.00 0.00 1,500.00 0.00
Interest 03/31/2023
91282CCZ2 1,520,000.00 US Treasury Note
0.875% Due: 09/30/2026
0.000 6,650.00 0.00 6,650.00 0.00
Interest 03/31/2023
91282CEF4 500,000.00 US Treasury Note
2.5% Due: 03/31/2027
0.000 6,250.00 0.00 6,250.00 0.00
Interest 03/31/2023
91282CFM8 1,250,000.00 US Treasury Note
4.125% Due: 09/30/2027
0.000 25,781.25 0.00 25,781.25 0.00
Subtotal 22,715,000.00 187,451.27 0.00 187,451.27 0.00
Dividend 01/03/2023
316175603 266,694.14 Fidelity Institutional Government MMKT Fund #657
0.000 427.33 0.00 427.33 0.00
Dividend 02/01/2023
316175603 34,366.46 Fidelity Institutional Government MMKT Fund #657
0.000 860.67 0.00 860.67 0.00
Dividend 03/01/2023
316175603 70,180.33 Fidelity Institutional Government MMKT Fund #657
0.000 369.41 0.00 369.41 0.00
Subtotal 371,240.93 1,657.41 0.00 1,657.41 0.00
TOTAL Other Transactions 23,086,240.93 189,108.68 0.00 189,108.68 0.00 December 31, 2022 through March 31, 2023
As of March 31, 2023
56 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 March 31, 2023
© PFM Asset Management LLC pfmam.com
CITY OF ALAMEDA
For the Quarter Ended March 31, 2023
Portfolio Activity
|
Quarterly Portfolio Transactions
Trade
Date
Settle
Date Par ($) CUSIP
Maturity
Date
Transact
Amount ($)Coupon
Yield
at Market
Realized
G/L (BV)Security Description
BUY
1/3/2023 1/6/2023 135,000.00 14913R3B1 CATERPILLAR FINL SERVICE CORPORATE NOTES 4.80% 1/6/2026 134,966.25 4.81% 1/3/2023 1/10/2023 325,000.00 20271RAQ3 COMMONWEALTH BK AUSTR NY CORPORATE 5.07% 1/10/2025 325,000.00 5.08% 1/4/2023 1/12/2023 305,000.00 63253QAA2 NATIONAL AUSTRALIA BK/NY CORPORATE NOTES 4.96% 1/12/2026 305,000.00 4.97% 1/5/2023 1/9/2023 175,000.00 713448CY2 PEPSICO INC CORP NOTES (CALLABLE) 3.50% 7/17/2025 172,744.64 4.76% 1/9/2023 1/12/2023 175,000.00 89236TKN4 TOYOTA MOTOR CREDIT CORP CORPORATE NOTES 4.80% 1/10/2025 174,924.75 4.82% 1/17/2023 1/19/2023 100,000.00 61747YEZ4 MORGAN STANLEY CORPORATE NOTES (CALLABLE 5.05% 1/28/2027 99,998.00 5.05% 1/17/2023 1/20/2023 345,000.00 06051GLE7 BANK OF AMERICA CORP NOTES (CALLABLE) 5.08% 1/20/2027 345,000.00 5.08% 1/18/2023 1/25/2023 120,000.00 58770AAC7 MBART 2023-1 A3 4.51% 11/15/2027 119,985.60 4.51% 1/19/2023 1/24/2023 25,000.00 693475BL8 PNC FINANCIAL SERVICES CORP NOTES (CALLA 4.75% 1/26/2027 25,000.00 4.76% 1/23/2023 1/26/2023 35,000.00 857477BZ5 STATE STREET CORP NOTES (CALLABLE) 4.85% 1/26/2026 35,000.00 4.86% 1/23/2023 1/26/2023 175,000.00 742718FY0 PROCTER & GAMBLE CO/THE CORPORATE NOTES 4.10% 1/26/2026 174,882.75 4.12% 1/24/2023 1/26/2023 225,000.00 458140AS9 INTEL CORP NOTES (CALLABLE) 3.70% 7/29/2025 224,345.63 4.60% 1/24/2023 1/30/2023 145,000.00 891940AC2 TAOT 2023-A A3 4.63% 9/15/2027 144,999.93 4.63% 1/30/2023 2/1/2023 350,000.00 30231GAT9 EXXON MOBIL CORP NOTES (CALLABLE) 3.04% 3/1/2026 341,165.71 4.37% 1/31/2023 2/2/2023 500,000.00 91282CGE5 US TREASURY N/B NOTES 3.87% 1/15/2026 500,299.34 3.92% 2/2/2023 2/9/2023 55,000.00 63743HFH0 NATIONAL RURAL UTIL COOP CORP NOTES (CAL 4.45% 3/13/2026 54,960.95 4.47% 2/6/2023 2/9/2023 500,000.00 91282CGE5 US TREASURY N/B NOTES 3.87% 1/15/2026 498,486.49 4.08% 45 © PFM Asset Management LLC pfmam.com
CITY OF ALAMEDA
For the Quarter Ended March 31, 2023
Portfolio Activity
|
Quarterly Portfolio Transactions
Trade
Date
Settle
Date Par ($) CUSIP
Maturity
Date
Transact
Amount ($)Coupon
Yield
at Market
Realized
G/L (BV)Security Description
BUY
2/13/2023 2/15/2023 160,000.00 713448FQ6 PEPSICO INC CORP NOTES (CALLABLE) 4.55% 2/13/2026 159,907.20 4.57% 2/13/2023 2/23/2023 155,000.00 41285JAD0 HDMOT 2023-A A3 5.05% 12/15/2027 154,984.39 5.05% 2/27/2023 3/1/2023 120,000.00 194162AQ6 COLGATE-PALMOLIVE CO CORPORATE NOTES 4.80% 3/2/2026 119,860.80 4.84% 3/2/2023 3/7/2023 750,000.00 91282CGL9 US TREASURY N/B NOTES 4.00% 2/15/2026 738,561.76 4.64% 3/6/2023 3/13/2023 300,000.00 20271RAR1 COMMONWEALTH BK AUSTR NY CORPORATE 5.31% 3/13/2026 300,000.00 5.32% 3/7/2023 3/14/2023 150,000.00 641062BK9 NESTLE HOLDINGS INC CORPORATE NOTES 5.25% 3/13/2026 149,950.50 5.26% 3/28/2023 3/31/2023 160,000.00 50117KAC4 KCOT 2023-1A A3 5.02% 6/15/2027 159,974.96 5.02% 3/28/2023 3/31/2023 120,000.00 344928AD8 FORDO 2023-A A3 4.65% 2/15/2028 119,987.48 4.65% Total BUY 5,605,000.00 5,579,987.13 0.00
INTEREST
1/1/2023 1/1/2023 95,000.00 646140DN0 NJ TURNPIKE AUTHORITY TXBL REV BONDS 0.89% 1/1/2025 426.08 1/1/2023 1/1/2023 110,000.00 341271AD6 FL ST BOARD OF ADMIN TXBL REV BONDS 1.25% 7/1/2025 691.90 1/3/2023 1/3/2023 MONEY0002 MONEY MARKET FUND 363.87
1/10/2023 1/10/2023 250,000.00 21688AAS1 COOPERATIEVE RABOBANK UA CORPORATE 1.37% 1/10/2025 1,718.75 1/10/2023 1/10/2023 55,000.00 24422EVY2 JOHN DEERE CAPITAL CORP CORPORATE NOTES 1.25% 1/10/2025 343.75 1/13/2023 1/13/2023 175,000.00 02665WEA5 AMERICAN HONDA FINANCE CORPORATE NOTES 1.50% 1/13/2025 1,312.50 1/15/2023 1/15/2023 100,000.00 44935FAD6 HART 2021-C A3 0.74% 5/15/2026 61.67 46 © PFM Asset Management LLC pfmam.com
CITY OF ALAMEDA
For the Quarter Ended March 31, 2023
Portfolio Activity
|
Quarterly Portfolio Transactions
Trade
Date
Settle
Date Par ($) CUSIP
Maturity
Date
Transact
Amount ($)Coupon
Yield
at Market
Realized
G/L (BV)Security Description
INTEREST
1/15/2023 1/15/2023 25,992.63 65479JAD5 NAROT 2019-C A3 1.93% 7/15/2024 41.80 1/15/2023 1/15/2023 93,439.88 44933LAC7 HART 2021-A A3 0.38% 9/15/2025 29.59 1/15/2023 1/15/2023 195,000.00 43815BAC4 HAROT 2022-1 A3 1.88% 5/15/2026 305.50 1/15/2023 1/15/2023 290,000.00 254683CW3 DCENT 2022-A3 A3 3.56% 7/15/2027 860.33 1/15/2023 1/15/2023 8,967.66 58769EAC2 MBALT 2020-B A3 0.40% 11/15/2023 2.99 1/15/2023 1/15/2023 280,000.00 576004GY5 MASSACHUSETTS CMNWLTH MUNICIPAL BONDS 3.66% 1/15/2025 3,843.00 1/15/2023 1/15/2023 150,000.00 44918MAD2 HART 2022-B A3 3.72% 11/16/2026 465.00 1/15/2023 1/15/2023 185,000.00 14317HAC5 CARMX 2022-2 A3 3.49% 2/16/2027 538.04 1/15/2023 1/15/2023 105,000.00 91282CBE0 US TREASURY NOTES 0.12% 1/15/2024 65.63 1/15/2023 1/15/2023 1,225,000.00 91282CEY3 US TREASURY N/B NOTES 3.00% 7/15/2025 18,375.00 1/15/2023 1/15/2023 215,000.00 14317DAC4 CARMX 2021-3 A3 0.55% 6/15/2026 98.54 1/15/2023 1/15/2023 33,130.35 65479CAD0 NAROT 2020-B A3 0.55% 7/15/2024 15.18 1/15/2023 1/15/2023 74,547.11 14316HAC6 CARMX 2020-4 A3 0.50% 8/15/2025 31.06 1/15/2023 1/15/2023 144,485.66 14314QAC8 CARMX 2021-2 A3 0.52% 2/17/2026 62.61 1/15/2023 1/15/2023 325,000.00 14041NFY2 COMET 2021-A3 A3 1.04% 11/15/2026 281.67 1/15/2023 1/15/2023 450,000.00 14041NFZ9 COMET 2022-A1 A1 2.80% 3/15/2027 1,050.00 1/15/2023 1/15/2023 255,000.00 448977AD0 HART 2022-A A3 2.22% 10/15/2026 471.75 47 © PFM Asset Management LLC pfmam.com
CITY OF ALAMEDA
For the Quarter Ended March 31, 2023
Portfolio Activity
|
Quarterly Portfolio Transactions
Trade
Date
Settle
Date Par ($) CUSIP
Maturity
Date
Transact
Amount ($)Coupon
Yield
at Market
Realized
G/L (BV)Security Description
INTEREST
1/15/2023 1/15/2023 235,000.00 50117EAC8 KCOT 2022-1A A3 2.67% 10/15/2026 522.88 1/15/2023 1/15/2023 38,814.37 14315FAD9 CARMX 2020-3 A3 0.62% 3/17/2025 20.05 1/15/2023 1/15/2023 175,000.00 02582JJT8 AMXCA 2022-2 A 3.39% 5/17/2027 494.38 1/15/2023 1/15/2023 160,000.00 98163KAC6 WOART 2021-D A3 0.81% 10/15/2026 108.00 1/15/2023 1/15/2023 245,000.00 14318MAD1 CARMX 2022-3 A3 3.97% 4/15/2027 810.54 1/15/2023 1/15/2023 32,625.53 14315XAC2 CARMX 2020-1 A3 1.89% 12/16/2024 51.39 1/15/2023 1/15/2023 75,000.00 345286AC2 FORDO 2022-A A3 1.29% 6/15/2026 80.63 1/15/2023 1/15/2023 290,000.00 02008JAC0 ALLYA 2022-1 A3 3.31% 11/15/2026 799.92 1/15/2023 1/15/2023 135,000.00 89238FAD5 TAOT 2022-B A3 2.93% 9/15/2026 329.63 1/15/2023 1/15/2023 140,000.00 14043QAC6 COPAR 2022-1 A3 3.17% 4/15/2027 369.83 1/15/2023 1/15/2023 18,230.07 89233MAD5 TAOT 2019-D A3 1.92% 1/16/2024 29.17 1/15/2023 1/15/2023 135,000.00 14044CAC6 COPAR 2021-1 A3 0.77% 9/15/2026 86.63 1/15/2023 1/15/2023 87,841.78 50117EAB0 KCOT 2022-1A A2 2.34% 4/15/2025 171.29 1/15/2023 1/15/2023 1,500,000.00 91282CCL3 US TREASURY N/B NOTES 0.37% 7/15/2024 2,812.50 1/15/2023 1/15/2023 55,654.95 14316NAC3 CARMX 2021-1 A3 0.34% 12/15/2025 15.77 1/15/2023 1/15/2023 170,000.00 50117XAE2 KCOT 2021-2A A3 0.56% 11/17/2025 79.33 1/15/2023 1/15/2023 215,000.00 41284YAD8 HDMOT 2022-A A3 3.06% 2/15/2027 548.25 48 © PFM Asset Management LLC pfmam.com
CITY OF ALAMEDA
For the Quarter Ended March 31, 2023
Portfolio Activity
|
Quarterly Portfolio Transactions
Trade
Date
Settle
Date Par ($) CUSIP
Maturity
Date
Transact
Amount ($)Coupon
Yield
at Market
Realized
G/L (BV)Security Description
INTEREST
1/15/2023 1/15/2023 140,000.00 254683CP8 DCENT 2021-A1 A1 0.58% 9/15/2026 67.67 1/15/2023 1/15/2023 105,000.00 50117TAC5 KCOT 2021-1A A3 0.62% 8/15/2025 54.25 1/15/2023 1/15/2023 405,000.00 02008MAC3 ALLYA 2022-2 A3 4.76% 5/17/2027 1,606.50 1/15/2023 1/15/2023 9,607.92 34531KAD4 FORDO 2019-C A3 1.87% 3/15/2024 14.97 1/15/2023 1/15/2023 140,000.00 14043GAD6 COPAR 2022-2 A3 3.66% 5/17/2027 427.00 1/15/2023 1/15/2023 280,000.00 14318UAD3 CARMX 2022-4 A3 5.34% 8/16/2027 1,246.00 1/15/2023 1/15/2023 225,000.00 50117JAC7 KCOT 2022-2A A3 4.09% 12/15/2026 766.88 1/15/2023 1/15/2023 5,596.35 02007TAC9 ALLYA 2019-4 A3 1.84% 6/17/2024 8.58 1/15/2023 1/15/2023 155,000.00 65480JAC4 NAROT 2022-B A3 4.46% 5/17/2027 576.08 1/15/2023 1/15/2023 365,000.00 58768PAC8 MBART 2022-1 A3 5.21% 8/16/2027 1,584.71 1/15/2023 1/15/2023 135,000.00 89238JAC9 TAOT 2021-D A3 0.71% 4/15/2026 79.88 1/16/2023 1/16/2023 100,000.00 380146AC4 GMCAR 2022-1 A3 1.26% 11/16/2026 105.00 1/16/2023 1/16/2023 115,000.00 362585AC5 GMCAR 2022-2 A3 3.10% 2/16/2027 297.08 1/16/2023 1/16/2023 145,000.00 36265WAD5 GMCAR 2022-3 A3 3.64% 4/16/2027 439.83 1/16/2023 1/16/2023 69,548.12 362590AC5 GMCAR 2020-3 A3 0.45% 4/16/2025 26.08 1/16/2023 1/16/2023 15,146.43 36258NAC6 GMCAR 2020-1 A3 1.84% 9/16/2024 23.22 1/16/2023 1/16/2023 110,000.00 362554AC1 GMCAR 2021-4 A3 0.68% 9/16/2026 62.33 49 © PFM Asset Management LLC pfmam.com
CITY OF ALAMEDA
For the Quarter Ended March 31, 2023
Portfolio Activity
|
Quarterly Portfolio Transactions
Trade
Date
Settle
Date Par ($) CUSIP
Maturity
Date
Transact
Amount ($)Coupon
Yield
at Market
Realized
G/L (BV)Security Description
INTEREST
1/17/2023 1/17/2023 175,000.00 713448CY2 PEPSICO INC CORP NOTES (CALLABLE) 3.50% 7/17/2025 3,062.50 1/18/2023 1/18/2023 75,236.90 43813KAC6 HAROT 2020-3 A3 0.37% 10/18/2024 23.20 1/18/2023 1/18/2023 19,795.48 43813VAC2 HAROT 2019-4 A3 1.83% 1/18/2024 30.19 1/20/2023 1/20/2023 125,722.34 380144AC9 GMALT 2021-2 A3 0.34% 5/20/2024 35.62 1/20/2023 1/20/2023 98,300.35 92290BAA9 VZOT 2020-B A 0.47% 2/20/2025 38.50 1/20/2023 1/20/2023 7,330.99 92348AAA3 VZOT 2019-C A1A 1.94% 4/22/2024 11.85 1/20/2023 1/20/2023 170,000.00 92868KAC7 VALET 2021-1 A3 1.02% 6/22/2026 144.50 1/20/2023 1/20/2023 100,000.00 92868AAC9 VWALT 2022-A A3 3.44% 7/21/2025 286.67 1/20/2023 1/20/2023 15,746.44 92348TAA2 VZOT 2020-A A1A 1.85% 7/22/2024 24.28 1/20/2023 1/20/2023 53,371.76 36261RAC2 GMALT 2021-1 A3 0.26% 2/20/2024 11.56 1/20/2023 1/20/2023 95,119.65 89238EAC0 TLOT 2021-A A3 0.39% 4/22/2024 30.91 1/21/2023 1/21/2023 135,000.00 43815GAC3 HAROT 2021-4 A3 0.88% 1/21/2026 99.00 1/24/2023 1/24/2023 175,000.00 38141GZH0 GOLDMAN SACHS GROUP INC (CALLABLE) CORP 1.75% 1/24/2025 1,537.38 1/25/2023 1/25/2023 45,000.00 17327CAN3 CITIGROUP INC CORP NOTES (CALLABLE) 2.01% 1/25/2026 453.15 1/25/2023 1/25/2023 33,398.51 05591RAC8 BMWLT 2021-1 A3 0.29% 1/25/2024 8.07 1/25/2023 1/25/2023 125,000.00 05602RAD3 BMWOT 2022-A A3 3.21% 8/25/2026 334.38 1/27/2023 1/27/2023 175,000.00 459200KS9 IBM CORP CORPORATE NOTES 4.00% 7/27/2025 3,500.00 50 © PFM Asset Management LLC pfmam.com
CITY OF ALAMEDA
For the Quarter Ended March 31, 2023
Portfolio Activity
|
Quarterly Portfolio Transactions
Trade
Date
Settle
Date Par ($) CUSIP
Maturity
Date
Transact
Amount ($)Coupon
Yield
at Market
Realized
G/L (BV)Security Description
INTEREST
1/28/2023 1/28/2023 145,000.00 89788MAH5 TRUIST FIN CORP NOTES (CALLABLE) 4.26% 7/28/2026 3,088.50 1/29/2023 1/29/2023 225,000.00 458140AS9 INTEL CORP NOTES (CALLABLE) 3.70% 7/29/2025 4,162.50 1/30/2023 1/30/2023 225,000.00 025816CG2 AMERICAN EXPRESS CO CORP NOTES (CALLABLE 2.50% 7/30/2024 2,812.50 2/1/2023 2/1/2023 85,000.00 54438CYH9 LOS ANGELES CCD, CA TXBL GO BONDS 0.44% 8/1/2023 188.70 2/1/2023 2/1/2023 MONEY0002 MONEY MARKET FUND 384.92
2/1/2023 2/1/2023 155,000.00 798306WM4 SAN JUAN USD, CA TXBL GO BONDS 0.49% 8/1/2023 386.73 2/6/2023 2/6/2023 90,000.00 857477BR3 STATE STREET CORP (CALLABLE) CORPORATE N 1.74% 2/6/2026 785.70 2/7/2023 2/7/2023 65,000.00 63743HFC1 NATIONAL RURAL UTIL COOP CORPORATE NOTES 1.87% 2/7/2025 609.38 2/8/2023 2/8/2023 90,000.00 63743HEU2 NATIONAL RURAL UTIL COOP CORPORATE NOTES 0.35% 2/8/2024 157.50 2/9/2023 2/9/2023 150,000.00 02665WDY4 AMERICAN HONDA FINANCE CORPORATE NOTES 0.75% 8/9/2024 562.50 2/9/2023 2/9/2023 120,000.00 69371RR40 PACCAR FINANCIAL CORP CORPORATE NOTES 0.50% 8/9/2024 300.00 2/11/2023 2/11/2023 30,000.00 69371RQ90 PACCAR FINANCIAL CORP CORPORATE NOTES 0.35% 8/11/2023 52.50 2/12/2023 2/12/2023 95,000.00 05565EBU8 BMW US CAPITAL LLC CORPORATE NOTES 0.75% 8/12/2024 356.25 2/12/2023 2/12/2023 175,000.00 459200HU8 IBM CORP NOTES 3.62% 2/12/2024 3,171.88 2/15/2023 2/15/2023 52,461.88 14316NAC3 CARMX 2021-1 A3 0.34% 12/15/2025 14.86 2/15/2023 2/15/2023 215,000.00 14317DAC4 CARMX 2021-3 A3 0.55% 6/15/2026 98.54 2/15/2023 2/15/2023 235,000.00 50117EAC8 KCOT 2022-1A A3 2.67% 10/15/2026 522.88 51 © PFM Asset Management LLC pfmam.com
CITY OF ALAMEDA
For the Quarter Ended March 31, 2023
Portfolio Activity
|
Quarterly Portfolio Transactions
Trade
Date
Settle
Date Par ($) CUSIP
Maturity
Date
Transact
Amount ($)Coupon
Yield
at Market
Realized
G/L (BV)Security Description
INTEREST
2/15/2023 2/15/2023 100,000.00 44935FAD6 HART 2021-C A3 0.74% 5/15/2026 61.67 2/15/2023 2/15/2023 9,946.84 89233MAD5 TAOT 2019-D A3 1.92% 1/16/2024 15.91 2/15/2023 2/15/2023 750,000.00 91282CDZ1 US TREASURY N/B NOTES 1.50% 2/15/2025 5,625.00 2/15/2023 2/15/2023 185,000.00 14317HAC5 CARMX 2022-2 A3 3.49% 2/16/2027 538.04 2/15/2023 2/15/2023 2,010.42 02007TAC9 ALLYA 2019-4 A3 1.84% 6/17/2024 3.08 2/15/2023 2/15/2023 405,000.00 02008MAC3 ALLYA 2022-2 A3 4.76% 5/17/2027 1,606.50 2/15/2023 2/15/2023 280,000.00 14318UAD3 CARMX 2022-4 A3 5.34% 8/16/2027 1,246.00 2/15/2023 2/15/2023 75,000.00 345286AC2 FORDO 2022-A A3 1.29% 6/15/2026 80.63 2/15/2023 2/15/2023 815,000.00 91282CBM2 US TREASURY NOTES 0.12% 2/15/2024 509.38 2/15/2023 2/15/2023 135,000.00 89238FAD5 TAOT 2022-B A3 2.93% 9/15/2026 329.63 2/15/2023 2/15/2023 175,000.00 02582JJT8 AMXCA 2022-2 A 3.39% 5/17/2027 494.38 2/15/2023 2/15/2023 28,833.86 14315XAC2 CARMX 2020-1 A3 1.89% 12/16/2024 45.41 2/15/2023 2/15/2023 160,000.00 98163KAC6 WOART 2021-D A3 0.81% 10/15/2026 108.00 2/15/2023 2/15/2023 225,000.00 50117JAC7 KCOT 2022-2A A3 4.09% 12/15/2026 766.88 2/15/2023 2/15/2023 1,250,000.00 91282CCT6 US TREASURY N/B NOTES 0.37% 8/15/2024 2,343.75 2/15/2023 2/15/2023 140,000.00 254683CP8 DCENT 2021-A1 A1 0.58% 9/15/2026 67.67 2/15/2023 2/15/2023 2,398.69 58769EAC2 MBALT 2020-B A3 0.40% 11/15/2023 0.80 52 © PFM Asset Management LLC pfmam.com
CITY OF ALAMEDA
For the Quarter Ended March 31, 2023
Portfolio Activity
|
Quarterly Portfolio Transactions
Trade
Date
Settle
Date Par ($) CUSIP
Maturity
Date
Transact
Amount ($)Coupon
Yield
at Market
Realized
G/L (BV)Security Description
INTEREST
2/15/2023 2/15/2023 18,996.64 65479JAD5 NAROT 2019-C A3 1.93% 7/15/2024 30.55 2/15/2023 2/15/2023 105,000.00 50117TAC5 KCOT 2021-1A A3 0.62% 8/15/2025 54.25 2/15/2023 2/15/2023 87,640.45 44933LAC7 HART 2021-A A3 0.38% 9/15/2025 27.75 2/15/2023 2/15/2023 135,000.00 14044CAC6 COPAR 2021-1 A3 0.77% 9/15/2026 86.63 2/15/2023 2/15/2023 3,010.66 34531KAD4 FORDO 2019-C A3 1.87% 3/15/2024 4.69 2/15/2023 2/15/2023 365,000.00 58768PAC8 MBART 2022-1 A3 5.21% 8/16/2027 1,584.71 2/15/2023 2/15/2023 290,000.00 02008JAC0 ALLYA 2022-1 A3 3.31% 11/15/2026 799.92 2/15/2023 2/15/2023 170,000.00 50117XAE2 KCOT 2021-2A A3 0.56% 11/17/2025 79.33 2/15/2023 2/15/2023 81,671.13 50117EAB0 KCOT 2022-1A A2 2.34% 4/15/2025 159.26 2/15/2023 2/15/2023 136,373.93 14314QAC8 CARMX 2021-2 A3 0.52% 2/17/2026 59.10 2/15/2023 2/15/2023 325,000.00 14041NFY2 COMET 2021-A3 A3 1.04% 11/15/2026 281.67 2/15/2023 2/15/2023 255,000.00 448977AD0 HART 2022-A A3 2.22% 10/15/2026 471.75 2/15/2023 2/15/2023 145,000.00 891940AC2 TAOT 2023-A A3 4.63% 9/15/2027 279.73 2/15/2023 2/15/2023 140,000.00 14043QAC6 COPAR 2022-1 A3 3.17% 4/15/2027 369.83 2/15/2023 2/15/2023 450,000.00 14041NFZ9 COMET 2022-A1 A1 2.80% 3/15/2027 1,050.00 2/15/2023 2/15/2023 245,000.00 14318MAD1 CARMX 2022-3 A3 3.97% 4/15/2027 810.54 2/15/2023 2/15/2023 155,000.00 65480JAC4 NAROT 2022-B A3 4.46% 5/17/2027 576.08 53 © PFM Asset Management LLC pfmam.com
CITY OF ALAMEDA
For the Quarter Ended March 31, 2023
Portfolio Activity
|
Quarterly Portfolio Transactions
Trade
Date
Settle
Date Par ($) CUSIP
Maturity
Date
Transact
Amount ($)Coupon
Yield
at Market
Realized
G/L (BV)Security Description
INTEREST
2/15/2023 2/15/2023 1,000,000.00 91282CFE6 US TREASURY N/B NOTES 3.12% 8/15/2025 15,625.00 2/15/2023 2/15/2023 75,000.00 194162AM5 COLGATE-PALMOLIVE CO CORPORATE NOTES 3.10% 8/15/2025 1,201.25 2/15/2023 2/15/2023 34,691.19 14315FAD9 CARMX 2020-3 A3 0.62% 3/17/2025 17.92 2/15/2023 2/15/2023 69,441.51 14316HAC6 CARMX 2020-4 A3 0.50% 8/15/2025 28.93 2/15/2023 2/15/2023 195,000.00 43815BAC4 HAROT 2022-1 A3 1.88% 5/15/2026 305.50 2/15/2023 2/15/2023 135,000.00 89238JAC9 TAOT 2021-D A3 0.71% 4/15/2026 79.88 2/15/2023 2/15/2023 27,294.84 65479CAD0 NAROT 2020-B A3 0.55% 7/15/2024 12.51 2/15/2023 2/15/2023 120,000.00 58770AAC7 MBART 2023-1 A3 4.51% 11/15/2027 300.67 2/15/2023 2/15/2023 215,000.00 41284YAD8 HDMOT 2022-A A3 3.06% 2/15/2027 548.25 2/15/2023 2/15/2023 140,000.00 14043GAD6 COPAR 2022-2 A3 3.66% 5/17/2027 427.00 2/15/2023 2/15/2023 290,000.00 254683CW3 DCENT 2022-A3 A3 3.56% 7/15/2027 860.33 2/15/2023 2/15/2023 150,000.00 44918MAD2 HART 2022-B A3 3.72% 11/16/2026 465.00 2/16/2023 2/16/2023 90,000.00 46647PBY1 JPMORGAN CHASE & CO CORP NOTES (CALLABLE 0.56% 2/16/2025 253.35 2/16/2023 2/16/2023 110,000.00 362554AC1 GMCAR 2021-4 A3 0.68% 9/16/2026 62.33 2/16/2023 2/16/2023 100,000.00 380146AC4 GMCAR 2022-1 A3 1.26% 11/16/2026 105.00 2/16/2023 2/16/2023 12,049.17 36258NAC6 GMCAR 2020-1 A3 1.84% 9/16/2024 18.48 2/16/2023 2/16/2023 145,000.00 36265WAD5 GMCAR 2022-3 A3 3.64% 4/16/2027 439.83 54 © PFM Asset Management LLC pfmam.com
CITY OF ALAMEDA
For the Quarter Ended March 31, 2023
Portfolio Activity
|
Quarterly Portfolio Transactions
Trade
Date
Settle
Date Par ($) CUSIP
Maturity
Date
Transact
Amount ($)Coupon
Yield
at Market
Realized
G/L (BV)Security Description
INTEREST
2/16/2023 2/16/2023 63,649.20 362590AC5 GMCAR 2020-3 A3 0.45% 4/16/2025 23.87 2/16/2023 2/16/2023 115,000.00 362585AC5 GMCAR 2022-2 A3 3.10% 2/16/2027 297.08 2/18/2023 2/18/2023 265,000.00 61747YEM3 MORGAN STANLEY CORP NOTES (CALLABLE) 2.63% 2/18/2026 3,484.75 2/18/2023 2/18/2023 13,481.70 43813VAC2 HAROT 2019-4 A3 1.83% 1/18/2024 20.56 2/18/2023 2/18/2023 67,795.73 43813KAC6 HAROT 2020-3 A3 0.37% 10/18/2024 20.90 2/20/2023 2/20/2023 39,975.70 36261RAC2 GMALT 2021-1 A3 0.26% 2/20/2024 8.66 2/20/2023 2/20/2023 111.85 92348AAA3 VZOT 2019-C A1A 1.94% 4/22/2024 0.18 2/20/2023 2/20/2023 10,793.12 92348TAA2 VZOT 2020-A A1A 1.85% 7/22/2024 16.64 2/20/2023 2/20/2023 109,416.26 380144AC9 GMALT 2021-2 A3 0.34% 5/20/2024 31.00 2/20/2023 2/20/2023 82,471.62 89238EAC0 TLOT 2021-A A3 0.39% 4/22/2024 26.80 2/20/2023 2/20/2023 83,245.07 92290BAA9 VZOT 2020-B A 0.47% 2/20/2025 32.60 2/20/2023 2/20/2023 100,000.00 92868AAC9 VWALT 2022-A A3 3.44% 7/21/2025 286.67 2/20/2023 2/20/2023 170,000.00 92868KAC7 VALET 2021-1 A3 1.02% 6/22/2026 144.50 2/21/2023 2/21/2023 135,000.00 43815GAC3 HAROT 2021-4 A3 0.88% 1/21/2026 99.00 2/22/2023 2/22/2023 250,000.00 21688AAU6 COOPERAT RABOBANK UA/NY CORPORATE NOTES 3.87% 8/22/2024 4,843.75 2/25/2023 2/25/2023 125,000.00 05602RAD3 BMWOT 2022-A A3 3.21% 8/25/2026 334.38 2/25/2023 2/25/2023 25,659.19 05591RAC8 BMWLT 2021-1 A3 0.29% 1/25/2024 6.20 55 © PFM Asset Management LLC pfmam.com
CITY OF ALAMEDA
For the Quarter Ended March 31, 2023
Portfolio Activity
|
Quarterly Portfolio Transactions
Trade
Date
Settle
Date Par ($) CUSIP
Maturity
Date
Transact
Amount ($)Coupon
Yield
at Market
Realized
G/L (BV)Security Description
INTEREST
3/1/2023 3/1/2023 MONEY0002 MONEY MARKET FUND 291.82
3/1/2023 3/1/2023 350,000.00 30231GAT9 EXXON MOBIL CORP NOTES (CALLABLE) 3.04% 3/1/2026 5,325.25 3/4/2023 3/4/2023 40,000.00 025816CQ0 AMERICAN EXPRESS CO CORP NOTES (CALLABLE 2.25% 3/4/2025 450.00 3/9/2023 3/9/2023 175,000.00 931142EW9 WALMART INC CORPORATE NOTES 3.90% 9/9/2025 3,412.50 3/10/2023 3/10/2023 590,000.00 771196BT8 ROCHE HOLDINGS INC (CALLABLE) CORPORATE 2.13% 3/10/2025 6,289.40 3/13/2023 3/13/2023 220,000.00 14913R2P1 CATERPILLAR FINL SERVICE CORPORATE NOTES 0.60% 9/13/2024 660.00 3/14/2023 3/14/2023 330,000.00 641062AU8 NESTLE HOLDINGS INC CORP NOTES (CALLABLE 0.60% 9/14/2024 999.90 3/15/2023 3/15/2023 185,000.00 14317HAC5 CARMX 2022-2 A3 3.49% 2/16/2027 538.04 3/15/2023 3/15/2023 280,000.00 14318UAD3 CARMX 2022-4 A3 5.34% 8/16/2027 1,246.00 3/15/2023 3/15/2023 105,000.00 50117TAC5 KCOT 2021-1A A3 0.62% 8/15/2025 54.25 3/15/2023 3/15/2023 215,000.00 14317DAC4 CARMX 2021-3 A3 0.55% 6/15/2026 98.54 3/15/2023 3/15/2023 50,000.00 437076CR1 HOME DEPOT INC NOTES (CALLABLE) 4.00% 9/15/2025 977.78 3/15/2023 3/15/2023 135,000.00 14044CAC6 COPAR 2021-1 A3 0.77% 9/15/2026 86.63 3/15/2023 3/15/2023 315,000.00 650036DS2 NY ST URBAN DEV CORP TXBL REV BONDS 0.62% 3/15/2024 976.50 3/15/2023 3/15/2023 170,000.00 50117XAE2 KCOT 2021-2A A3 0.56% 11/17/2025 79.33 3/15/2023 3/15/2023 700,000.00 91282CFK2 US TREASURY N/B NOTES 3.50% 9/15/2025 12,250.00 3/15/2023 3/15/2023 140,000.00 14043GAD6 COPAR 2022-2 A3 3.66% 5/17/2027 427.00 56 © PFM Asset Management LLC pfmam.com
CITY OF ALAMEDA
For the Quarter Ended March 31, 2023
Portfolio Activity
|
Quarterly Portfolio Transactions
Trade
Date
Settle
Date Par ($) CUSIP
Maturity
Date
Transact
Amount ($)Coupon
Yield
at Market
Realized
G/L (BV)Security Description
INTEREST
3/15/2023 3/15/2023 255,000.00 448977AD0 HART 2022-A A3 2.22% 10/15/2026 471.75 3/15/2023 3/15/2023 21,446.95 65479CAD0 NAROT 2020-B A3 0.55% 7/15/2024 9.83 3/15/2023 3/15/2023 135,000.00 89238FAD5 TAOT 2022-B A3 2.93% 9/15/2026 329.63 3/15/2023 3/15/2023 155,000.00 41285JAD0 HDMOT 2023-A A3 5.05% 12/15/2027 478.35 3/15/2023 3/15/2023 140,000.00 14043QAC6 COPAR 2022-1 A3 3.17% 4/15/2027 369.83 3/15/2023 3/15/2023 145,000.00 891940AC2 TAOT 2023-A A3 4.63% 9/15/2027 559.46 3/15/2023 3/15/2023 128,787.48 14314QAC8 CARMX 2021-2 A3 0.52% 2/17/2026 55.81 3/15/2023 3/15/2023 120,000.00 58770AAC7 MBART 2023-1 A3 4.51% 11/15/2027 451.00 3/15/2023 3/15/2023 175,000.00 02582JJT8 AMXCA 2022-2 A 3.39% 5/17/2027 494.38 3/15/2023 3/15/2023 245,000.00 14318MAD1 CARMX 2022-3 A3 3.97% 4/15/2027 810.54 3/15/2023 3/15/2023 290,000.00 254683CW3 DCENT 2022-A3 A3 3.56% 7/15/2027 860.33 3/15/2023 3/15/2023 30,650.84 14315FAD9 CARMX 2020-3 A3 0.62% 3/17/2025 15.84 3/15/2023 3/15/2023 75,000.00 345286AC2 FORDO 2022-A A3 1.29% 6/15/2026 80.63 3/15/2023 3/15/2023 64,412.06 14316HAC6 CARMX 2020-4 A3 0.50% 8/15/2025 26.84 3/15/2023 3/15/2023 215,000.00 41284YAD8 HDMOT 2022-A A3 3.06% 2/15/2027 548.25 3/15/2023 3/15/2023 155,000.00 65480JAC4 NAROT 2022-B A3 4.46% 5/17/2027 576.08 3/15/2023 3/15/2023 49,374.38 14316NAC3 CARMX 2021-1 A3 0.34% 12/15/2025 13.99 57 © PFM Asset Management LLC pfmam.com
CITY OF ALAMEDA
For the Quarter Ended March 31, 2023
Portfolio Activity
|
Quarterly Portfolio Transactions
Trade
Date
Settle
Date Par ($) CUSIP
Maturity
Date
Transact
Amount ($)Coupon
Yield
at Market
Realized
G/L (BV)Security Description
INTEREST
3/15/2023 3/15/2023 100,000.00 44935FAD6 HART 2021-C A3 0.74% 5/15/2026 61.67 3/15/2023 3/15/2023 325,000.00 14041NFY2 COMET 2021-A3 A3 1.04% 11/15/2026 281.67 3/15/2023 3/15/2023 75,598.17 50117EAB0 KCOT 2022-1A A2 2.34% 4/15/2025 147.42 3/15/2023 3/15/2023 225,000.00 50117JAC7 KCOT 2022-2A A3 4.09% 12/15/2026 766.88 3/15/2023 3/15/2023 405,000.00 02008MAC3 ALLYA 2022-2 A3 4.76% 5/17/2027 1,606.50 3/15/2023 3/15/2023 200,000.00 91282CBR1 US TREASURY NOTES 0.25% 3/15/2024 250.00 3/15/2023 3/15/2023 11,963.86 65479JAD5 NAROT 2019-C A3 1.93% 7/15/2024 19.24 3/15/2023 3/15/2023 290,000.00 02008JAC0 ALLYA 2022-1 A3 3.31% 11/15/2026 799.92 3/15/2023 3/15/2023 195,000.00 43815BAC4 HAROT 2022-1 A3 1.88% 5/15/2026 305.50 3/15/2023 3/15/2023 140,000.00 254683CP8 DCENT 2021-A1 A1 0.58% 9/15/2026 67.67 3/15/2023 3/15/2023 1,998.38 89233MAD5 TAOT 2019-D A3 1.92% 1/16/2024 3.20 3/15/2023 3/15/2023 25,194.08 14315XAC2 CARMX 2020-1 A3 1.89% 12/16/2024 39.68 3/15/2023 3/15/2023 235,000.00 50117EAC8 KCOT 2022-1A A3 2.67% 10/15/2026 522.88 3/15/2023 3/15/2023 81,774.55 44933LAC7 HART 2021-A A3 0.38% 9/15/2025 25.90 3/15/2023 3/15/2023 450,000.00 14041NFZ9 COMET 2022-A1 A1 2.80% 3/15/2027 1,050.00 3/15/2023 3/15/2023 135,000.00 89238JAC9 TAOT 2021-D A3 0.71% 4/15/2026 79.88 3/15/2023 3/15/2023 160,000.00 98163KAC6 WOART 2021-D A3 0.81% 10/15/2026 108.00 58 © PFM Asset Management LLC pfmam.com
CITY OF ALAMEDA
For the Quarter Ended March 31, 2023
Portfolio Activity
|
Quarterly Portfolio Transactions
Trade
Date
Settle
Date Par ($) CUSIP
Maturity
Date
Transact
Amount ($)Coupon
Yield
at Market
Realized
G/L (BV)Security Description
INTEREST
3/15/2023 3/15/2023 925,000.00 91282CCX7 US TREASURY N/B NOTES 0.37% 9/15/2024 1,734.38 3/15/2023 3/15/2023 365,000.00 58768PAC8 MBART 2022-1 A3 5.21% 8/16/2027 1,584.71 3/15/2023 3/15/2023 150,000.00 44918MAD2 HART 2022-B A3 3.72% 11/16/2026 465.00 3/16/2023 3/16/2023 170,000.00 46647PBS4 JPMORGAN CHASE & CO CORPORATE NOTES (CAL 0.65% 9/16/2024 555.05 3/16/2023 3/16/2023 115,000.00 362585AC5 GMCAR 2022-2 A3 3.10% 2/16/2027 297.08 3/16/2023 3/16/2023 110,000.00 362554AC1 GMCAR 2021-4 A3 0.68% 9/16/2026 62.33 3/16/2023 3/16/2023 100,000.00 380146AC4 GMCAR 2022-1 A3 1.26% 11/16/2026 105.00 3/16/2023 3/16/2023 57,963.82 362590AC5 GMCAR 2020-3 A3 0.45% 4/16/2025 21.74 3/16/2023 3/16/2023 9,113.79 36258NAC6 GMCAR 2020-1 A3 1.84% 9/16/2024 13.97 3/16/2023 3/16/2023 145,000.00 36265WAD5 GMCAR 2022-3 A3 3.64% 4/16/2027 439.83 3/18/2023 3/18/2023 7,365.88 43813VAC2 HAROT 2019-4 A3 1.83% 1/18/2024 11.23 3/18/2023 3/18/2023 145,000.00 808513BN4 CHARLES SCHWAB CORP NOTES (CALLABLE) 0.75% 3/18/2024 543.75 3/18/2023 3/18/2023 60,635.81 43813KAC6 HAROT 2020-3 A3 0.37% 10/18/2024 18.70 3/20/2023 3/20/2023 100,000.00 92868AAC9 VWALT 2022-A A3 3.44% 7/21/2025 286.67 3/20/2023 3/20/2023 26,177.31 36261RAC2 GMALT 2021-1 A3 0.26% 2/20/2024 5.67 3/20/2023 3/20/2023 69,524.45 92290BAA9 VZOT 2020-B A 0.47% 2/20/2025 27.23 3/20/2023 3/20/2023 92,471.37 380144AC9 GMALT 2021-2 A3 0.34% 5/20/2024 26.20 59 © PFM Asset Management LLC pfmam.com
CITY OF ALAMEDA
For the Quarter Ended March 31, 2023
Portfolio Activity
|
Quarterly Portfolio Transactions
Trade
Date
Settle
Date Par ($) CUSIP
Maturity
Date
Transact
Amount ($)Coupon
Yield
at Market
Realized
G/L (BV)Security Description
INTEREST
3/20/2023 3/20/2023 170,000.00 92868KAC7 VALET 2021-1 A3 1.02% 6/22/2026 144.50 3/20/2023 3/20/2023 6,541.63 92348TAA2 VZOT 2020-A A1A 1.85% 7/22/2024 10.09 3/20/2023 3/20/2023 69,767.18 89238EAC0 TLOT 2021-A A3 0.39% 4/22/2024 22.67 3/21/2023 3/21/2023 135,000.00 43815GAC3 HAROT 2021-4 A3 0.88% 1/21/2026 99.00 3/23/2023 3/23/2023 455,000.00 4581X0DZ8 INTER-AMERICAN DEVEL BK NOTES 0.50% 9/23/2024 1,137.50 3/25/2023 3/25/2023 18,233.27 05591RAC8 BMWLT 2021-1 A3 0.29% 1/25/2024 4.41 3/25/2023 3/25/2023 125,000.00 05602RAD3 BMWOT 2022-A A3 3.21% 8/25/2026 334.38 3/30/2023 3/30/2023 200,000.00 857477BM4 STATE STREET CORP NOTES (CALLABLE) 2.90% 3/30/2026 2,901.00 Total INTEREST 40,540,067.14 181,760.93 0.00
MATURITY
3/17/2023 3/17/2023 350,000.00 22552G3C2 CREDIT SUISSE NEW YORK CERT DEPOS 0.59% 3/17/2023 352,093.68 Total MATURITY 350,000.00 352,093.68 0.00
PAYDOWNS
1/15/2023 1/15/2023 6,597.26 34531KAD4 FORDO 2019-C A3 1.87% 3/15/2024 6,597.26 1/15/2023 1/15/2023 6,995.99 65479JAD5 NAROT 2019-C A3 1.93% 7/15/2024 6,995.99 1/15/2023 1/15/2023 3,585.93 02007TAC9 ALLYA 2019-4 A3 1.84% 6/17/2024 3,585.93 1/15/2023 1/15/2023 3,193.07 14316NAC3 CARMX 2021-1 A3 0.34% 12/15/2025 3,193.07 60 © PFM Asset Management LLC pfmam.com
CITY OF ALAMEDA
For the Quarter Ended March 31, 2023
Portfolio Activity
|
Quarterly Portfolio Transactions
Trade
Date
Settle
Date Par ($) CUSIP
Maturity
Date
Transact
Amount ($)Coupon
Yield
at Market
Realized
G/L (BV)Security Description
PAYDOWNS
1/15/2023 1/15/2023 6,170.65 50117EAB0 KCOT 2022-1A A2 2.34% 4/15/2025 6,170.65 1/15/2023 1/15/2023 5,105.60 14316HAC6 CARMX 2020-4 A3 0.50% 8/15/2025 5,105.60 1/15/2023 1/15/2023 3,791.67 14315XAC2 CARMX 2020-1 A3 1.89% 12/16/2024 3,791.67 1/15/2023 1/15/2023 5,799.43 44933LAC7 HART 2021-A A3 0.38% 9/15/2025 5,799.43 1/15/2023 1/15/2023 6,568.97 58769EAC2 MBALT 2020-B A3 0.40% 11/15/2023 6,568.97 1/15/2023 1/15/2023 8,283.23 89233MAD5 TAOT 2019-D A3 1.92% 1/16/2024 8,283.23 1/15/2023 1/15/2023 8,111.73 14314QAC8 CARMX 2021-2 A3 0.52% 2/17/2026 8,111.73 1/15/2023 1/15/2023 4,123.18 14315FAD9 CARMX 2020-3 A3 0.62% 3/17/2025 4,123.18 1/15/2023 1/15/2023 5,835.51 65479CAD0 NAROT 2020-B A3 0.55% 7/15/2024 5,835.51 1/16/2023 1/16/2023 3,097.26 36258NAC6 GMCAR 2020-1 A3 1.84% 9/16/2024 3,097.26 1/16/2023 1/16/2023 5,898.92 362590AC5 GMCAR 2020-3 A3 0.45% 4/16/2025 5,898.92 1/18/2023 1/18/2023 7,441.17 43813KAC6 HAROT 2020-3 A3 0.37% 10/18/2024 7,441.17 1/18/2023 1/18/2023 6,313.78 43813VAC2 HAROT 2019-4 A3 1.83% 1/18/2024 6,313.78 1/20/2023 1/20/2023 12,648.03 89238EAC0 TLOT 2021-A A3 0.39% 4/22/2024 12,648.03 1/20/2023 1/20/2023 7,219.14 92348AAA3 VZOT 2019-C A1A 1.94% 4/22/2024 7,219.14 1/20/2023 1/20/2023 4,953.32 92348TAA2 VZOT 2020-A A1A 1.85% 7/22/2024 4,953.32 1/20/2023 1/20/2023 15,055.28 92290BAA9 VZOT 2020-B A 0.47% 2/20/2025 15,055.28 61 © PFM Asset Management LLC pfmam.com
CITY OF ALAMEDA
For the Quarter Ended March 31, 2023
Portfolio Activity
|
Quarterly Portfolio Transactions
Trade
Date
Settle
Date Par ($) CUSIP
Maturity
Date
Transact
Amount ($)Coupon
Yield
at Market
Realized
G/L (BV)Security Description
PAYDOWNS
1/20/2023 1/20/2023 13,396.06 36261RAC2 GMALT 2021-1 A3 0.26% 2/20/2024 13,396.06 1/20/2023 1/20/2023 16,306.08 380144AC9 GMALT 2021-2 A3 0.34% 5/20/2024 16,306.08 1/25/2023 1/25/2023 7,739.32 05591RAC8 BMWLT 2021-1 A3 0.29% 1/25/2024 7,739.32 2/15/2023 2/15/2023 7,948.46 89233MAD5 TAOT 2019-D A3 1.92% 1/16/2024 7,948.46 2/15/2023 2/15/2023 5,029.45 14316HAC6 CARMX 2020-4 A3 0.50% 8/15/2025 5,029.45 2/15/2023 2/15/2023 5,865.90 44933LAC7 HART 2021-A A3 0.38% 9/15/2025 5,865.90 2/15/2023 2/15/2023 2,010.42 02007TAC9 ALLYA 2019-4 A3 1.84% 6/17/2024 2,010.42 2/15/2023 2/15/2023 7,032.78 65479JAD5 NAROT 2019-C A3 1.93% 7/15/2024 7,032.78 2/15/2023 2/15/2023 3,010.66 34531KAD4 FORDO 2019-C A3 1.87% 3/15/2024 3,010.66 2/15/2023 2/15/2023 3,639.78 14315XAC2 CARMX 2020-1 A3 1.89% 12/16/2024 3,639.78 2/15/2023 2/15/2023 3,087.50 14316NAC3 CARMX 2021-1 A3 0.34% 12/15/2025 3,087.50 2/15/2023 2/15/2023 6,072.96 50117EAB0 KCOT 2022-1A A2 2.34% 4/15/2025 6,072.96 2/15/2023 2/15/2023 2,398.69 58769EAC2 MBALT 2020-B A3 0.40% 11/15/2023 2,398.69 2/15/2023 2/15/2023 7,586.45 14314QAC8 CARMX 2021-2 A3 0.52% 2/17/2026 7,586.45 2/15/2023 2/15/2023 5,847.89 65479CAD0 NAROT 2020-B A3 0.55% 7/15/2024 5,847.89 2/15/2023 2/15/2023 4,040.35 14315FAD9 CARMX 2020-3 A3 0.62% 3/17/2025 4,040.35 2/16/2023 2/16/2023 2,935.38 36258NAC6 GMCAR 2020-1 A3 1.84% 9/16/2024 2,935.38 62 © PFM Asset Management LLC pfmam.com
CITY OF ALAMEDA
For the Quarter Ended March 31, 2023
Portfolio Activity
|
Quarterly Portfolio Transactions
Trade
Date
Settle
Date Par ($) CUSIP
Maturity
Date
Transact
Amount ($)Coupon
Yield
at Market
Realized
G/L (BV)Security Description
PAYDOWNS
2/16/2023 2/16/2023 5,685.38 362590AC5 GMCAR 2020-3 A3 0.45% 4/16/2025 5,685.38 2/18/2023 2/18/2023 7,159.92 43813KAC6 HAROT 2020-3 A3 0.37% 10/18/2024 7,159.92 2/18/2023 2/18/2023 6,115.82 43813VAC2 HAROT 2019-4 A3 1.83% 1/18/2024 6,115.82 2/20/2023 2/20/2023 13,798.39 36261RAC2 GMALT 2021-1 A3 0.26% 2/20/2024 13,798.39 2/20/2023 2/20/2023 111.85 92348AAA3 VZOT 2019-C A1A 1.94% 4/22/2024 111.85 2/20/2023 2/20/2023 12,704.44 89238EAC0 TLOT 2021-A A3 0.39% 4/22/2024 12,704.44 2/20/2023 2/20/2023 13,720.62 92290BAA9 VZOT 2020-B A 0.47% 2/20/2025 13,720.62 2/20/2023 2/20/2023 16,944.89 380144AC9 GMALT 2021-2 A3 0.34% 5/20/2024 16,944.89 2/20/2023 2/20/2023 4,251.49 92348TAA2 VZOT 2020-A A1A 1.85% 7/22/2024 4,251.49 2/25/2023 2/25/2023 7,425.92 05591RAC8 BMWLT 2021-1 A3 0.29% 1/25/2024 7,425.92 3/15/2023 3/15/2023 1,998.38 89233MAD5 TAOT 2019-D A3 1.92% 1/16/2024 1,998.38 3/15/2023 3/15/2023 5,234.15 65479CAD0 NAROT 2020-B A3 0.55% 7/15/2024 5,234.15 3/15/2023 3/15/2023 4,896.19 14316HAC6 CARMX 2020-4 A3 0.50% 8/15/2025 4,896.19 3/15/2023 3/15/2023 2,764.61 14317DAC4 CARMX 2021-3 A3 0.55% 6/15/2026 2,764.61 3/15/2023 3/15/2023 3,463.05 14315XAC2 CARMX 2020-1 A3 1.89% 12/16/2024 3,463.05 3/15/2023 3/15/2023 2,958.14 14316NAC3 CARMX 2021-1 A3 0.34% 12/15/2025 2,958.14 3/15/2023 3/15/2023 5,603.04 44933LAC7 HART 2021-A A3 0.38% 9/15/2025 5,603.04 63 © PFM Asset Management LLC pfmam.com
CITY OF ALAMEDA
For the Quarter Ended March 31, 2023
Portfolio Activity
|
Quarterly Portfolio Transactions
Trade
Date
Settle
Date Par ($) CUSIP
Maturity
Date
Transact
Amount ($)Coupon
Yield
at Market
Realized
G/L (BV)Security Description
PAYDOWNS
3/15/2023 3/15/2023 7,302.66 14314QAC8 CARMX 2021-2 A3 0.52% 2/17/2026 7,302.66 3/15/2023 3/15/2023 6,563.34 65479JAD5 NAROT 2019-C A3 1.93% 7/15/2024 6,563.34 3/15/2023 3/15/2023 3,865.95 14315FAD9 CARMX 2020-3 A3 0.62% 3/17/2025 3,865.95 3/15/2023 3/15/2023 5,823.29 50117EAB0 KCOT 2022-1A A2 2.34% 4/15/2025 5,823.29 3/16/2023 3/16/2023 2,831.30 36258NAC6 GMCAR 2020-1 A3 1.84% 9/16/2024 2,831.30 3/16/2023 3/16/2023 5,657.47 362590AC5 GMCAR 2020-3 A3 0.45% 4/16/2025 5,657.47 3/18/2023 3/18/2023 5,831.70 43813VAC2 HAROT 2019-4 A3 1.83% 1/18/2024 5,831.70 3/18/2023 3/18/2023 6,865.19 43813KAC6 HAROT 2020-3 A3 0.37% 10/18/2024 6,865.19 3/20/2023 3/20/2023 13,898.51 36261RAC2 GMALT 2021-1 A3 0.26% 2/20/2024 13,898.51 3/20/2023 3/20/2023 15,819.88 380144AC9 GMALT 2021-2 A3 0.34% 5/20/2024 15,819.88 3/20/2023 3/20/2023 11,961.83 92290BAA9 VZOT 2020-B A 0.47% 2/20/2025 11,961.83 3/20/2023 3/20/2023 12,837.61 89238EAC0 TLOT 2021-A A3 0.39% 4/22/2024 12,837.61 3/20/2023 3/20/2023 3,546.61 92348TAA2 VZOT 2020-A A1A 1.85% 7/22/2024 3,546.61 3/25/2023 3/25/2023 7,331.25 05591RAC8 BMWLT 2021-1 A3 0.29% 1/25/2024 7,331.25 Total PAYDOWNS 465,710.12 465,710.12 0.00
64 © PFM Asset Management LLC pfmam.com
CITY OF ALAMEDA
For the Quarter Ended March 31, 2023
Portfolio Activity
|
Quarterly Portfolio Transactions
Trade
Date
Settle
Date Par ($) CUSIP
Maturity
Date
Transact
Amount ($)Coupon
Yield
at Market
Realized
G/L (BV)Security Description
SELL
1/4/2023 1/6/2023 310,000.00 3135G05G4 FANNIE MAE NOTES 0.25% 7/10/2023 303,301.59 -6,964.69 1/6/2023 1/9/2023 285,000.00 91282CBM2 US TREASURY NOTES 0.12% 2/15/2024 271,460.09 -13,221.82 1/6/2023 1/9/2023 15,000.00 91282CBM2 US TREASURY NOTES 0.12% 2/15/2024 14,287.37 -702.10 1/6/2023 1/10/2023 350,000.00 3137EAEW5 FREDDIE MAC NOTES 0.25% 9/8/2023 339,807.03 -10,503.51 1/11/2023 1/12/2023 210,000.00 3137EAEV7 FREDDIE MAC NOTES 0.25% 8/24/2023 204,388.45 -5,769.10 1/17/2023 1/20/2023 345,000.00 06051GJC4 BANC OF AMERICA CORP (CALLABLE) 1.48% 5/19/2024 341,604.49 -4,264.20 1/25/2023 1/26/2023 200,000.00 110122DT2 BRISTOL-MYERS SQUIBB CO (CALLABLE) CORP 0.53% 11/13/2023 193,541.78 -6,676.00 1/25/2023 1/26/2023 400,000.00 3137EAEV7 FREDDIE MAC NOTES 0.25% 8/24/2023 390,010.22 -10,333.97 1/30/2023 2/1/2023 5,000.00 3137EAEW5 FREDDIE MAC NOTES 0.25% 9/8/2023 4,867.92 -136.72 1/30/2023 2/1/2023 245,000.00 3137EAEW5 FREDDIE MAC NOTES 0.25% 9/8/2023 238,527.84 -6,724.37 1/30/2023 2/1/2023 85,000.00 54438CYH9 LOS ANGELES CCD, CA TXBL GO BONDS 0.44% 8/1/2023 83,225.20 -1,774.80 1/31/2023 2/2/2023 50,000.00 69371RQ82 PACCAR FINANCIAL CORP CORPORATE NOTES 0.80% 6/8/2023 49,375.50 -676.50 1/31/2023 2/2/2023 220,000.00 3137EAEV7 FREDDIE MAC NOTES 0.25% 8/24/2023 214,686.39 -5,513.51 1/31/2023 2/2/2023 250,000.00 3137EAEW5 FREDDIE MAC NOTES 0.25% 9/8/2023 243,442.50 -6,791.14 2/6/2023 2/9/2023 40,000.00 3137EAEW5 FREDDIE MAC NOTES 0.25% 9/8/2023 38,980.74 -1,058.67 2/7/2023 2/9/2023 25,000.00 3137EAEW5 FREDDIE MAC NOTES 0.25% 9/8/2023 24,355.22 -669.56 2/7/2023 2/9/2023 500,000.00 3137EAEW5 FREDDIE MAC NOTES 0.25% 9/8/2023 487,104.30 -13,388.32 65 © PFM Asset Management LLC pfmam.com
CITY OF ALAMEDA
For the Quarter Ended March 31, 2023
Portfolio Activity
|
Quarterly Portfolio Transactions
Trade
Date
Settle
Date Par ($) CUSIP
Maturity
Date
Transact
Amount ($)Coupon
Yield
at Market
Realized
G/L (BV)Security Description
SELL
2/14/2023 2/15/2023 200,000.00 3137EAEW5 FREDDIE MAC NOTES 0.25% 9/8/2023 195,014.06 -5,192.83 2/28/2023 3/1/2023 15,000.00 91282CBE0 US TREASURY NOTES 0.12% 1/15/2024 14,373.03 -622.33 3/3/2023 3/7/2023 775,000.00 3137EAEW5 FREDDIE MAC NOTES 0.25% 9/8/2023 756,952.62 -18,971.67 3/9/2023 3/13/2023 365,000.00 91282CBM2 US TREASURY NOTES 0.12% 2/15/2024 348,051.72 -16,483.82 3/9/2023 3/13/2023 90,000.00 91282CBE0 US TREASURY NOTES 0.12% 1/15/2024 86,231.38 -3,746.08 Total SELL 4,980,000.00 4 ,843,589.44 -140,185.71
66