City of Alameda
Finance Department
2263 Santa Clara Avenue, Room 220
Alameda, California 94501
(510) 747-4881
September 5, 2023
Honorable Mayor and City Council:
I have reviewed the City of Alameda’s Investment Transactions Report for the Quarter Ending June 30, 2023 and the Annual Investment Report for the Fiscal year Ending June 30, 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 June 30, 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 June 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 04/14/2023 3130ATS57 1,000,000.00 FHLB Note
4.5% Due: 03/10/2028
103.860 3.63% 1,038,600.00 4,250.00 1,042,850.00 0.00
Purchase 05/02/2023 880591EZ1 500,000.00 Tennessee Valley Authority Note
3.875% Due: 03/15/2028
100.301 3.81% 501,505.00 1,722.22 503,227.22 0.00
Purchase 05/08/2023
91282CHA2 500,000.00 US Treasury Note
3.5% Due: 04/30/2028
100.348 3.42% 501,738.28 380.43 502,118.71 0.00
Purchase 05/23/2023
341081GN1 400,000.00 Florida Power and Light Callable Note Cont 3/15/2028
4.4% Due: 05/15/2028
98.782 4.68% 395,128.00 244.44 395,372.44 0.00
Purchase 06/08/2023
3133EPME2 400,000.00 FFCB Note
3.875% Due: 06/08/2028
99.604 3.96% 398,416.00 0.00 398,416.00 0.00
Purchase 06/20/2023
91282CHE4 1,000,000.00 US Treasury Note
3.625% Due: 05/31/2028
98.348 4.00% 983,476.56 1,980.87 985,457.43 0.00
Subtotal 3,800,000.00 3,818,863.84 8,577.96 3,827,441.80 0.00 TOTAL ACQUISITIONS 3,800,000.00 3,818,863.84 8,577.96 3,827,441.80 0.00
DISPOSITIONS
Sale 04/14/2023
3130AB3H7 650,000.00 FHLB Note
2.375% Due: 03/08/2024
97.876 2.37% 636,194.00 1,543.75 637,737.75 -13,814.44
Sale 04/14/2023 3137EAEV7 160,000.00 FHLMC Note
0.25% Due: 08/24/2023
98.296 0.28% 157,273.60 55.56 157,329.16 -2,706.78
Sale 05/02/2023
912828V23 260,000.00 US Treasury Note
2.25% Due: 12/31/2023
98.262 1.78% 255,480.47 1,971.55 257,452.02 -5,289.27
Sale 05/08/2023
912828B66 320,000.00 US Treasury Note
2.75% Due: 02/15/2024
98.430 2.31% 314,975.00 1,993.37 316,968.37 -6,046.68
Sale 05/08/2023
912828V23 190,000.00 US Treasury Note
2.25% Due: 12/31/2023
98.309 1.78% 186,786.33 1,511.60 188,297.93 -3,762.29
March 31, 2023 through June 30, 2023
As of June 30, 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 05/23/2023 808513BN4 290,000.00 Charles Schwab Corp Callable Note Cont 2/18/2024
0.75% Due: 03/18/2024
95.904 0.77% 278,121.60 392.71 278,514.31 -11,838.71
Sale 06/08/2023
3130AB3H7 300,000.00 FHLB Note
2.375% Due: 03/08/2024
97.803 2.37% 293,409.00 1,781.25 295,190.25 -6,594.24
Sale 06/16/2023
3130A1XJ2 300,000.00 FHLB Note
2.875% Due: 06/14/2024
97.591 1.97% 292,773.00 47.92 292,820.92 -9,796.48
Sale 06/16/2023
912828B66 580,000.00 US Treasury Note
2.75% Due: 02/15/2024
98.313 2.31% 570,212.50 5,331.35 575,543.85 -11,384.09
Subtotal 3,050,000.00 2,985,225.50 14,629.06 2,999,854.56 -71,232.98 TOTAL DISPOSITIONS 3,050,000.00 2,985,225.50 14,629.06 2,999,854.56 -71,232.98 March 31, 2023 through June 30, 2023
As of June 30, 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 04/01/2023 316175603 6,960.00 Fidelity Institutional Government MMKT Fund #657
1.000 4.46% 6,960.00 0.00 6,960.00 0.00
Purchase 04/03/2023 316175603 691.27 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 691.27 0.00 691.27 0.00
Purchase 04/07/2023 316175603 6,911.25 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 6,911.25 0.00 6,911.25 0.00
Purchase 04/14/2023 3130ATS57 1,000,000.00 FHLB Note
4.5% Due: 03/10/2028
103.860
3.63% 1,038,600.00 4,250.00 1,042,850.00 0.00
Purchase 04/14/2023 316175603 4,387.50 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 4,387.50 0.00 4,387.50 0.00
Purchase 04/15/2023 316175603 2,884.38 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 2,884.38 0.00 2,884.38 0.00
Purchase 04/17/2023 316175603 10,086.09 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 10,086.09 0.00 10,086.09 0.00
Purchase 04/17/2023 316175603 22,940.35 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 22,940.35 0.00 22,940.35 0.00
Purchase 04/17/2023 316175603 70.83 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 70.83 0.00 70.83 0.00
Purchase 04/17/2023 316175603 115.50 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 115.50 0.00 115.50 0.00
Purchase 04/17/2023 316175603 423.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 423.00 0.00 423.00 0.00
Purchase 04/17/2023 316175603 814.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 814.00 0.00 814.00 0.00
Purchase 04/17/2023 316175603 354.04 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 354.04 0.00 354.04 0.00
Purchase 04/17/2023 316175603 91.71 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 91.71 0.00 91.71 0.00
Purchase 04/17/2023 316175603 206.25 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 206.25 0.00 206.25 0.00
March 31, 2023 through June 30, 2023
As of June 30, 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 04/17/2023 316175603 1,271.25 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 1,271.25 0.00 1,271.25 0.00
Purchase 04/17/2023 316175603 74.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 74.00 0.00 74.00 0.00
Purchase 04/17/2023 316175603 319.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 319.00 0.00 319.00 0.00
Purchase 04/17/2023 316175603 91.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 91.00 0.00 91.00 0.00
Purchase 04/17/2023 316175603 670.08 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 670.08 0.00 670.08 0.00
Purchase 04/17/2023 316175603 1,196.83 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 1,196.83 0.00 1,196.83 0.00
Purchase 04/17/2023 316175603 6,358.63 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 6,358.63 0.00 6,358.63 0.00
Purchase 04/17/2023 316175603 5,669.19 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 5,669.19 0.00 5,669.19 0.00
Purchase 04/17/2023 316175603 8,084.11 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 8,084.11 0.00 8,084.11 0.00
Purchase 04/17/2023 316175603 7,315.43 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 7,315.43 0.00 7,315.43 0.00
Purchase 04/17/2023 316175603 9,097.30 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 9,097.30 0.00 9,097.30 0.00
Purchase 04/18/2023 316175603 12,421.55 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 12,421.55 0.00 12,421.55 0.00
Purchase 04/20/2023 316175603 2,275.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 2,275.00 0.00 2,275.00 0.00
Purchase 04/20/2023 316175603 573.50 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 573.50 0.00 573.50 0.00
Purchase 04/20/2023 316175603 435.42 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 435.42 0.00 435.42 0.00
Purchase 04/20/2023 316175603 34,204.17 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 34,204.17 0.00 34,204.17 0.00
March 31, 2023 through June 30, 2023
As of June 30, 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 04/20/2023 316175603 26,931.76 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 26,931.76 0.00 26,931.76 0.00
Purchase 04/21/2023 316175603 121.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 121.00 0.00 121.00 0.00
Purchase 04/21/2023 316175603 6,469.10 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 6,469.10 0.00 6,469.10 0.00
Purchase 04/22/2023 316175603 4,437.22 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 4,437.22 0.00 4,437.22 0.00
Purchase 04/23/2023 316175603 7,118.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 7,118.00 0.00 7,118.00 0.00
Purchase 04/25/2023 316175603 468.13 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 468.13 0.00 468.13 0.00
Purchase 04/25/2023 316175603 165.85 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 165.85 0.00 165.85 0.00
Purchase 04/25/2023 316175603 28,146.52 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 28,146.52 0.00 28,146.52 0.00
Purchase 04/28/2023 316175603 7,192.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 7,192.00 0.00 7,192.00 0.00
Purchase 04/30/2023 316175603 22,368.75 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 22,368.75 0.00 22,368.75 0.00
Purchase 05/01/2023 316175603 10,903.25 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 10,903.25 0.00 10,903.25 0.00
Purchase 05/01/2023 316175603 696.57 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 696.57 0.00 696.57 0.00
Purchase 05/02/2023 880591EZ1 500,000.00 Tennessee Valley Authority Note
3.875% Due: 03/15/2028
100.301
3.81% 501,505.00 1,722.22 503,227.22 0.00
Purchase 05/07/2023 316175603 2,562.50 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 2,562.50 0.00 2,562.50 0.00
Purchase 05/08/2023 316175603 3,147.59 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 3,147.59 0.00 3,147.59 0.00
Purchase 05/08/2023 316175603 5,106.25 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 5,106.25 0.00 5,106.25 0.00
March 31, 2023 through June 30, 2023
As of June 30, 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 05/08/2023 91282CHA2 500,000.00 US Treasury Note
3.5% Due: 04/30/2028
100.348
3.42% 501,738.28 380.43 502,118.71 0.00
Purchase 05/10/2023 316175603 10,400.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 10,400.00 0.00 10,400.00 0.00
Purchase 05/12/2023 316175603 3,950.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 3,950.00 0.00 3,950.00 0.00
Purchase 05/13/2023 316175603 2,702.50 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 2,702.50 0.00 2,702.50 0.00
Purchase 05/15/2023 316175603 3,622.50 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 3,622.50 0.00 3,622.50 0.00
Purchase 05/15/2023 316175603 354.04 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 354.04 0.00 354.04 0.00
Purchase 05/15/2023 316175603 91.71 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 91.71 0.00 91.71 0.00
Purchase 05/15/2023 316175603 206.25 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 206.25 0.00 206.25 0.00
Purchase 05/15/2023 316175603 1,271.25 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 1,271.25 0.00 1,271.25 0.00
Purchase 05/15/2023 316175603 835.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 835.00 0.00 835.00 0.00
Purchase 05/15/2023 316175603 423.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 423.00 0.00 423.00 0.00
Purchase 05/15/2023 316175603 814.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 814.00 0.00 814.00 0.00
Purchase 05/15/2023 316175603 74.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 74.00 0.00 74.00 0.00
Purchase 05/15/2023 316175603 319.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 319.00 0.00 319.00 0.00
Purchase 05/15/2023 316175603 670.08 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 670.08 0.00 670.08 0.00
Purchase 05/15/2023 316175603 5,711.76 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 5,711.76 0.00 5,711.76 0.00
March 31, 2023 through June 30, 2023
As of June 30, 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 05/15/2023 316175603 7,206.51 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 7,206.51 0.00 7,206.51 0.00
Purchase 05/15/2023 316175603 10,322.34 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 10,322.34 0.00 10,322.34 0.00
Purchase 05/15/2023 316175603 10,635.29 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 10,635.29 0.00 10,635.29 0.00
Purchase 05/15/2023 316175603 17,431.46 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 17,431.46 0.00 17,431.46 0.00
Purchase 05/15/2023 316175603 8,845.31 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 8,845.31 0.00 8,845.31 0.00
Purchase 05/15/2023 316175603 19,806.63 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 19,806.63 0.00 19,806.63 0.00
Purchase 05/16/2023 316175603 70.83 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 70.83 0.00 70.83 0.00
Purchase 05/16/2023 316175603 115.50 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 115.50 0.00 115.50 0.00
Purchase 05/18/2023 316175603 10,695.66 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 10,695.66 0.00 10,695.66 0.00
Purchase 05/22/2023 316175603 22,265.86 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 22,265.86 0.00 22,265.86 0.00
Purchase 05/22/2023 316175603 573.50 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 573.50 0.00 573.50 0.00
Purchase 05/22/2023 316175603 435.42 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 435.42 0.00 435.42 0.00
Purchase 05/22/2023 316175603 31,475.68 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 31,475.68 0.00 31,475.68 0.00
Purchase 05/22/2023 316175603 5,710.78 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 5,710.78 0.00 5,710.78 0.00
Purchase 05/23/2023 316175603 121.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 121.00 0.00 121.00 0.00
March 31, 2023 through June 30, 2023
As of June 30, 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 05/23/2023 341081GN1 400,000.00 Florida Power and Light Callable Note Cont 3/15/2028
4.4% Due: 05/15/2028
98.782
4.68% 395,128.00 244.44 395,372.44 0.00
Purchase 05/25/2023 316175603 468.13 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 468.13 0.00 468.13 0.00
Purchase 05/25/2023 316175603 13,906.77 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 13,906.77 0.00 13,906.77 0.00
Purchase 05/25/2023 316175603 25,311.05 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 25,311.05 0.00 25,311.05 0.00
Purchase 05/31/2023 316175603 8,625.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 8,625.00 0.00 8,625.00 0.00
Purchase 06/01/2023 316175603 2,204.20 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 2,204.20 0.00 2,204.20 0.00
Purchase 06/01/2023 316175603 331.63 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 331.63 0.00 331.63 0.00
Purchase 06/08/2023 3133EPME2 400,000.00 FFCB Note
3.875% Due: 06/08/2028
99.604
3.96% 398,416.00 0.00 398,416.00 0.00
Purchase 06/08/2023 316175603 11,810.50 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 11,810.50 0.00 11,810.50 0.00
Purchase 06/14/2023 316175603 14,375.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 14,375.00 0.00 14,375.00 0.00
Purchase 06/15/2023 316175603 670.08 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 670.08 0.00 670.08 0.00
Purchase 06/15/2023 316175603 354.04 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 354.04 0.00 354.04 0.00
Purchase 06/15/2023 316175603 91.71 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 91.71 0.00 91.71 0.00
Purchase 06/15/2023 316175603 1,271.25 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 1,271.25 0.00 1,271.25 0.00
Purchase 06/15/2023 316175603 835.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 835.00 0.00 835.00 0.00
March 31, 2023 through June 30, 2023
As of June 30, 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 06/15/2023 316175603 206.25 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 206.25 0.00 206.25 0.00
Purchase 06/15/2023 316175603 423.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 423.00 0.00 423.00 0.00
Purchase 06/15/2023 316175603 814.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 814.00 0.00 814.00 0.00
Purchase 06/15/2023 316175603 74.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 74.00 0.00 74.00 0.00
Purchase 06/15/2023 316175603 319.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 319.00 0.00 319.00 0.00
Purchase 06/15/2023 316175603 5,542.03 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 5,542.03 0.00 5,542.03 0.00
Purchase 06/15/2023 316175603 3,461.83 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 3,461.83 0.00 3,461.83 0.00
Purchase 06/15/2023 316175603 7,228.29 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 7,228.29 0.00 7,228.29 0.00
Purchase 06/15/2023 316175603 6,896.89 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 6,896.89 0.00 6,896.89 0.00
Purchase 06/15/2023 316175603 11,013.71 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 11,013.71 0.00 11,013.71 0.00
Purchase 06/15/2023 316175603 9,192.04 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 9,192.04 0.00 9,192.04 0.00
Purchase 06/15/2023 316175603 21,119.65 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 21,119.65 0.00 21,119.65 0.00
Purchase 06/16/2023 316175603 868,364.77 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 868,364.77 0.00 868,364.77 0.00
Purchase 06/16/2023 316175603 70.83 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 70.83 0.00 70.83 0.00
Purchase 06/16/2023 316175603 115.50 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 115.50 0.00 115.50 0.00
Purchase 06/17/2023 316175603 2,562.50 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 2,562.50 0.00 2,562.50 0.00
March 31, 2023 through June 30, 2023
As of June 30, 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 06/18/2023 316175603 4,275.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 4,275.00 0.00 4,275.00 0.00
Purchase 06/19/2023 316175603 3,297.50 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 3,297.50 0.00 3,297.50 0.00
Purchase 06/20/2023 316175603 435.42 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 435.42 0.00 435.42 0.00
Purchase 06/20/2023 316175603 573.50 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 573.50 0.00 573.50 0.00
Purchase 06/20/2023 316175603 33,798.74 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 33,798.74 0.00 33,798.74 0.00
Purchase 06/20/2023 316175603 10,702.58 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 10,702.58 0.00 10,702.58 0.00
Purchase 06/20/2023 316175603 21,645.50 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 21,645.50 0.00 21,645.50 0.00
Purchase 06/20/2023 91282CHE4 1,000,000.00 US Treasury Note
3.625% Due: 05/31/2028
98.348
4.00% 983,476.56 1,980.87 985,457.43 0.00
Purchase 06/21/2023 316175603 121.00 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 121.00 0.00 121.00 0.00
Purchase 06/21/2023 316175603 5,983.92 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 5,983.92 0.00 5,983.92 0.00
Purchase 06/23/2023 316175603 1,235.48 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 1,235.48 0.00 1,235.48 0.00
Purchase 06/26/2023 316175603 468.13 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 468.13 0.00 468.13 0.00
Purchase 06/26/2023 316175603 16,548.86 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 16,548.86 0.00 16,548.86 0.00
Purchase 06/26/2023 316175603 27,812.79 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 27,812.79 0.00 27,812.79 0.00
Purchase 06/30/2023 316175603 25,843.75 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 25,843.75 0.00 25,843.75 0.00
Subtotal 5,420,384.80 5,439,248.64 8,577.96 5,447,826.60 0.00 March 31, 2023 through June 30, 2023
As of June 30, 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 06/20/2023 316175603 -985,457.43 Fidelity Institutional Government MMKT Fund #657
1.000 -985,457.43 0.00 -985,457.43 0.00
Subtotal -985,457.43 -985,457.43 0.00 -985,457.43 0.00
TOTAL ACQUISITIONS 4,434,927.37 4,453,791.21 8,577.96 4,462,369.17 0.00
DISPOSITIONS
Closing
Purchase
06/20/2023
316175603 -985,457.43 Fidelity Institutional Government MMKT Fund #657
1.000 -985,457.43 0.00 -985,457.43 0.00
Subtotal -985,457.43 -985,457.43 0.00 -985,457.43 0.00
Sale 04/14/2023
3130AB3H7 650,000.00 FHLB Note
2.375% Due: 03/08/2024
97.876
2.37% 636,194.00 1,543.75 637,737.75 -13,814.44
Sale 04/14/2023 3137EAEV7 160,000.00 FHLMC Note
0.25% Due: 08/24/2023
98.296
0.28% 157,273.60 55.56 157,329.16 -2,706.78
Sale 04/14/2023 316175603 247,783.09 Fidelity Institutional Government MMKT Fund #657
1.000
4.46% 247,783.09 0.00 247,783.09 0.00
Sale 05/02/2023 316175603 245,775.20 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 245,775.20 0.00 245,775.20 0.00
Sale 05/02/2023 912828V23 260,000.00 US Treasury Note
2.25% Due: 12/31/2023
98.262
1.78% 255,480.47 1,971.55 257,452.02 -5,289.27
Sale 05/08/2023 912828B66 320,000.00 US Treasury Note
2.75% Due: 02/15/2024
98.430
2.31% 314,975.00 1,993.37 316,968.37 -6,046.68
Sale 05/08/2023 912828V23 190,000.00 US Treasury Note
2.25% Due: 12/31/2023
98.309
1.78% 186,786.33 1,511.60 188,297.93 -3,762.29
Sale 05/23/2023 316175603 116,858.13 Fidelity Institutional Government MMKT Fund #657
1.000
4.48% 116,858.13 0.00 116,858.13 0.00
March 31, 2023 through June 30, 2023
As of June 30, 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 05/23/2023 808513BN4 290,000.00 Charles Schwab Corp Callable Note Cont 2/18/2024
0.75% Due: 03/18/2024
95.904
0.77% 278,121.60 392.71 278,514.31 -11,838.71
Sale 06/08/2023 3130AB3H7 300,000.00 FHLB Note
2.375% Due: 03/08/2024
97.803
2.37% 293,409.00 1,781.25 295,190.25 -6,594.24
Sale 06/08/2023 316175603 103,225.75 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 103,225.75 0.00 103,225.75 0.00
Sale 06/16/2023 3130A1XJ2 300,000.00 FHLB Note
2.875% Due: 06/14/2024
97.591
1.97% 292,773.00 47.92 292,820.92 -9,796.48
Sale 06/16/2023 912828B66 580,000.00 US Treasury Note
2.75% Due: 02/15/2024
98.313
2.31% 570,212.50 5,331.35 575,543.85 -11,384.09
Sale 06/20/2023 316175603 985,457.43 Fidelity Institutional Government MMKT Fund #657
1.000
4.73% 985,457.43 0.00 985,457.43 0.00
Subtotal 4,749,099.60 4,684,325.10 14,629.06 4,698,954.16 -71,232.98 Paydown 04/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 04/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 04/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 04/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 04/17/2023 43813DAC2 6,336.91 Honda Auto Receivables 2020-2 A3
0.82% Due: 07/15/2024
100.000 6,336.91 21.72 6,358.63 0.00
Paydown 04/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 04/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
March 31, 2023 through June 30, 2023
As of June 30, 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 04/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 04/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 04/17/2023 47787NAC3 5,657.55 John Deere Owner Trust 2020-B A3
0.51% Due: 11/15/2024
100.000 5,657.55 11.64 5,669.19 0.00
Paydown 04/17/2023 47788UAC6 8,045.94 John Deere Owner Trust 2021-A A3
0.36% Due: 09/15/2025
100.000 8,045.94 38.17 8,084.11 0.00
Paydown 04/17/2023 47789KAC7 7,291.03 John Deere Owner Trust 2020-A A3
1.1% Due: 08/15/2024
100.000 7,291.03 24.40 7,315.43 0.00
Paydown 04/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 04/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 04/17/2023 47800CAC0 0.00 John Deere Owner Trust 2023-A A3
5.01% Due: 11/15/2027
100.000 0.00 1,196.83 1,196.83 0.00
Paydown 04/17/2023 65479JAD5 9,082.69 Nissan Auto Receivables Owner 2019-C A3
1.93% Due: 07/15/2024
100.000 9,082.69 14.61 9,097.30 0.00
Paydown 04/17/2023 89236XAC0 10,065.64 Toyota Auto Receivables 2020-D A3
0.35% Due: 01/15/2025
100.000 10,065.64 20.45 10,086.09 0.00
Paydown 04/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 04/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 04/17/2023 89240BAC2 22,886.32 Toyota Auto Receivables Owners 2021-A A3
0.26% Due: 05/15/2025
100.000 22,886.32 54.03 22,940.35 0.00
Paydown 04/18/2023 43813KAC6 12,392.26 Honda Auto Receivables Trust 2020-3 A3
0.37% Due: 10/18/2024
100.000 12,392.26 29.29 12,421.55 0.00
March 31, 2023 through June 30, 2023
As of June 30, 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 04/20/2023 36262XAC8 34,100.53 GM Financial Auto Lease Trust 2021-3 A2
0.39% Due: 10/21/2024
100.000 34,100.53 103.64 34,204.17 0.00
Paydown 04/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 04/20/2023 92290BAA9 26,884.09 Verizon Owner Trust 2020-B A
0.47% Due: 02/20/2025
100.000 26,884.09 47.67 26,931.76 0.00
Paydown 04/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 04/21/2023 43813GAC5 6,453.65 Honda Auto Receivables Trust 2021-1 A3
0.27% Due: 04/21/2025
100.000 6,453.65 15.45 6,469.10 0.00
Paydown 04/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 04/25/2023 05601XAC3 14.60 BMW Vehicle Lease Trust 2022-1 A3
1.1% Due: 03/25/2025
100.000 1.10% 14.60 151.25 165.85 0.00
Paydown 04/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 04/25/2023 09690AAC7 28,086.56 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due: 12/26/2024
100.000 28,086.56 59.96 28,146.52 0.00
Paydown 05/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 05/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 05/15/2023 43813DAC2 5,694.37 Honda Auto Receivables 2020-2 A3
0.82% Due: 07/15/2024
100.000 5,694.37 17.39 5,711.76 0.00
Paydown 05/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 05/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
March 31, 2023 through June 30, 2023
As of June 30, 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 05/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 05/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 05/15/2023 47787NAC3 7,197.27 John Deere Owner Trust 2020-B A3
0.51% Due: 11/15/2024
100.000 7,197.27 9.24 7,206.51 0.00
Paydown 05/15/2023 47788UAC6 10,286.58 John Deere Owner Trust 2021-A A3
0.36% Due: 09/15/2025
100.000 10,286.58 35.76 10,322.34 0.00
Paydown 05/15/2023 47789KAC7 10,617.57 John Deere Owner Trust 2020-A A3
1.1% Due: 08/15/2024
100.000 10,617.57 17.72 10,635.29 0.00
Paydown 05/15/2023 47789QAC4 17,340.46 John Deere Owner Trust 2021-B A3
0.52% Due: 03/16/2026
100.000 17,340.46 91.00 17,431.46 0.00
Paydown 05/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 05/15/2023 47800CAC0 0.00 John Deere Owner Trust 2023-A A3
5.01% Due: 11/15/2027
100.000 0.00 835.00 835.00 0.00
Paydown 05/15/2023 89236XAC0 8,827.80 Toyota Auto Receivables 2020-D A3
0.35% Due: 01/15/2025
100.000 8,827.80 17.51 8,845.31 0.00
Paydown 05/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 05/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 05/15/2023 89240BAC2 19,757.56 Toyota Auto Receivables Owners 2021-A A3
0.26% Due: 05/15/2025
100.000 19,757.56 49.07 19,806.63 0.00
Paydown 05/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 05/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
March 31, 2023 through June 30, 2023
As of June 30, 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 05/18/2023 43813KAC6 10,670.19 Honda Auto Receivables Trust 2020-3 A3
0.37% Due: 10/18/2024
100.000 10,670.19 25.47 10,695.66 0.00
Paydown 05/22/2023 36262XAC8 31,383.12 GM Financial Auto Lease Trust 2021-3 A2
0.39% Due: 10/21/2024
100.000 31,383.12 92.56 31,475.68 0.00
Paydown 05/22/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 05/22/2023 43813GAC5 5,696.78 Honda Auto Receivables Trust 2021-1 A3
0.27% Due: 04/21/2025
100.000 5,696.78 14.00 5,710.78 0.00
Paydown 05/22/2023 92290BAA9 22,228.72 Verizon Owner Trust 2020-B A
0.47% Due: 02/20/2025
100.000 22,228.72 37.14 22,265.86 0.00
Paydown 05/22/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 05/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 05/25/2023 05601XAC3 13,755.53 BMW Vehicle Lease Trust 2022-1 A3
1.1% Due: 03/25/2025
100.000 13,755.53 151.24 13,906.77 0.00
Paydown 05/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 05/25/2023 09690AAC7 25,258.82 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due: 12/26/2024
100.000 25,258.82 52.23 25,311.05 0.00
Paydown 06/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 06/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 06/15/2023 43813DAC2 5,528.53 Honda Auto Receivables 2020-2 A3
0.82% Due: 07/15/2024
100.000 5,528.53 13.50 5,542.03 0.00
Paydown 06/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
March 31, 2023 through June 30, 2023
As of June 30, 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 06/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 06/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 06/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 06/15/2023 47787NAC3 3,455.65 John Deere Owner Trust 2020-B A3
0.51% Due: 11/15/2024
100.000 3,455.65 6.18 3,461.83 0.00
Paydown 06/15/2023 47788UAC6 7,195.62 John Deere Owner Trust 2021-A A3
0.36% Due: 09/15/2025
100.000 7,195.62 32.67 7,228.29 0.00
Paydown 06/15/2023 47789KAC7 6,888.90 John Deere Owner Trust 2020-A A3
1.1% Due: 08/15/2024
100.000 6,888.90 7.99 6,896.89 0.00
Paydown 06/15/2023 47789QAC4 10,930.22 John Deere Owner Trust 2021-B A3
0.52% Due: 03/16/2026
100.000 10,930.22 83.49 11,013.71 0.00
Paydown 06/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 06/15/2023 47800CAC0 0.00 John Deere Owner Trust 2023-A A3
5.01% Due: 11/15/2027
100.000 0.00 835.00 835.00 0.00
Paydown 06/15/2023 89236XAC0 9,177.10 Toyota Auto Receivables 2020-D A3
0.35% Due: 01/15/2025
100.000 9,177.10 14.94 9,192.04 0.00
Paydown 06/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 06/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 06/15/2023 89240BAC2 21,074.86 Toyota Auto Receivables Owners 2021-A A3
0.26% Due: 05/15/2025
100.000 21,074.86 44.79 21,119.65 0.00
Paydown 06/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
March 31, 2023 through June 30, 2023
As of June 30, 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 06/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 06/20/2023 36262XAC8 33,716.38 GM Financial Auto Lease Trust 2021-3 A2
0.39% Due: 10/21/2024
100.000 33,716.38 82.36 33,798.74 0.00
Paydown 06/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 06/20/2023 43813KAC6 10,680.40 Honda Auto Receivables Trust 2020-3 A3
0.37% Due: 10/18/2024
100.000 10,680.40 22.18 10,702.58 0.00
Paydown 06/20/2023 92290BAA9 21,617.07 Verizon Owner Trust 2020-B A
0.47% Due: 02/20/2025
100.000 21,617.07 28.43 21,645.50 0.00
Paydown 06/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 06/21/2023 43813GAC5 5,971.20 Honda Auto Receivables Trust 2021-1 A3
0.27% Due: 04/21/2025
100.000 5,971.20 12.72 5,983.92 0.00
Paydown 06/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 06/26/2023 05601XAC3 16,410.23 BMW Vehicle Lease Trust 2022-1 A3
1.1% Due: 03/25/2025
100.000 16,410.23 138.63 16,548.86 0.00
Paydown 06/26/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 06/26/2023 09690AAC7 27,767.51 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due: 12/26/2024
100.000 27,767.51 45.28 27,812.79 0.00
Subtotal 546,426.21 546,426.21 22,716.73 569,142.94 0.00 TOTAL DISPOSITIONS 4,310,068.38 4,245,293.88 37,345.79 4,282,639.67 -71,232.98 March 31, 2023 through June 30, 2023
As of June 30, 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 04/01/2023 13063DRK6 580,000.00 California State Taxable GO
2.4% Due: 10/01/2024
0.000 6,960.00 0.00 6,960.00 0.00
Interest 04/07/2023 69371RR73 485,000.00 Paccar Financial Corp Note
2.85% Due: 04/07/2025
0.000 6,911.25 0.00 6,911.25 0.00
Interest 04/14/2023
78016EZ59 260,000.00 Royal Bank of Canada Note
3.375% Due: 04/14/2025
0.000 4,387.50 0.00 4,387.50 0.00
Interest 04/15/2023
3135G0W66 355,000.00 FNMA Note
1.625% Due: 10/15/2024
0.000 2,884.38 0.00 2,884.38 0.00
Interest 04/20/2023
4581X0DV7 520,000.00 Inter-American Dev Bank Note
0.875% Due: 04/20/2026
0.000 2,275.00 0.00 2,275.00 0.00
Interest 04/22/2023 3135G03U5 860,000.00 FNMA Note
0.625% Due: 04/22/2025
0.000 2,687.50 0.00 2,687.50 0.00
Interest 04/22/2023
46647PBK1 168,000.00 JP Morgan Chase & Co Callable Note Cont 4/22/2025
2.083% Due: 04/22/2026
0.000 1,749.72 0.00 1,749.72 0.00
Interest 04/23/2023
06051GHT9 400,000.00 Bank of America Corp Callable Note 1X 4/23/2026
3.559% Due: 04/23/2027
0.000 7,118.00 0.00 7,118.00 0.00
Interest 04/28/2023
459058JL8 470,000.00 Intl. Bank Recon & Development Note
0.5% Due: 10/28/2025
0.000 1,175.00 0.00 1,175.00 0.00
Interest 04/28/2023
6174468Q5 550,000.00 Morgan Stanley Callable Note Cont 4/28/2025
2.188% Due: 04/28/2026
0.000 6,017.00 0.00 6,017.00 0.00
Interest 04/30/2023
9128283D0 900,000.00 US Treasury Note
2.25% Due: 10/31/2024
0.000 10,125.00 0.00 10,125.00 0.00
Interest 04/30/2023
912828X70 800,000.00 US Treasury Note
2% Due: 04/30/2024
0.000 8,000.00 0.00 8,000.00 0.00
Interest 04/30/2023
91282CAT8 1,100,000.00 US Treasury Note
0.25% Due: 10/31/2025
0.000 1,375.00 0.00 1,375.00 0.00
March 31, 2023 through June 30, 2023
As of June 30, 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 04/30/2023 91282CDG3 510,000.00 US Treasury Note
1.125% Due: 10/31/2026
0.000 2,868.75 0.00 2,868.75 0.00
Interest 05/01/2023
06367WB85 449,000.00 Bank of Montreal Note
1.85% Due: 05/01/2025
0.000 4,153.25 0.00 4,153.25 0.00
Interest 05/01/2023
78015K7C2 600,000.00 Royal Bank of Canada Note
2.25% Due: 11/01/2024
0.000 6,750.00 0.00 6,750.00 0.00
Interest 05/07/2023
3135G06G3 1,025,000.00 FNMA Note
0.5% Due: 11/07/2025
0.000 2,562.50 0.00 2,562.50 0.00
Interest 05/08/2023
14913Q3B3 475,000.00 Caterpillar Finl Service Note
2.15% Due: 11/08/2024
0.000 5,106.25 0.00 5,106.25 0.00
Interest 05/10/2023
665859AW4 520,000.00 Northern Trust Company Callable Note Cont 4/10/2027
4% Due: 05/10/2027
0.000 10,400.00 0.00 10,400.00 0.00
Interest 05/12/2023
023135BX3 790,000.00 Amazon.com Inc Callable Note Cont 4/12/2026 1% Due: 05/12/2026
0.000 3,950.00 0.00 3,950.00 0.00
Interest 05/13/2023
808513BR5 470,000.00 Charles Schwab Corp Callable Note Cont 4/13/2026
1.15% Due: 05/13/2026
0.000 2,702.50 0.00 2,702.50 0.00
Interest 05/15/2023
91324PEC2 630,000.00 United Health Group Inc Callable Note Cont 4/15/2026
1.15% Due: 05/15/2026
0.000 3,622.50 0.00 3,622.50 0.00
Interest 05/31/2023
91282CAZ4 1,100,000.00 US Treasury Note
0.375% Due: 11/30/2025
0.000 2,062.50 0.00 2,062.50 0.00
Interest 05/31/2023
91282CET4 500,000.00 US Treasury Note
2.625% Due: 05/31/2027
0.000 6,562.50 0.00 6,562.50 0.00
Interest 06/01/2023
46647PCH7 535,000.00 JP Morgan Chase & Co Callable Note Cont 6/1/2024
0.824% Due: 06/01/2025
0.000 2,204.20 0.00 2,204.20 0.00
Interest 06/08/2023
89115A2C5 575,000.00 Toronto-Dominion Bank Note
4.108% Due: 06/08/2027
0.000 11,810.50 0.00 11,810.50 0.00
March 31, 2023 through June 30, 2023
As of June 30, 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 06/14/2023 3130A1XJ2 1,000,000.00 FHLB Note
2.875% Due: 06/14/2024
0.000 14,375.00 0.00 14,375.00 0.00
Interest 06/17/2023
3135G04Z3 1,025,000.00 FNMA Note
0.5% Due: 06/17/2025
0.000 2,562.50 0.00 2,562.50 0.00
Interest 06/18/2023
89236TJK2 760,000.00 Toyota Motor Credit Corp Note
1.125% Due: 06/18/2026
0.000 4,275.00 0.00 4,275.00 0.00
Interest 06/19/2023
06051GJD2 500,000.00 Bank of America Corp Callable Note Cont 6/19/2025
1.319% Due: 06/19/2026
0.000 3,297.50 0.00 3,297.50 0.00
Interest 06/23/2023
46647PCK0 255,000.00 JP Morgan Chase & Co Callable Note Cont 6/23/2024
0.969% Due: 06/23/2025
0.000 1,235.48 0.00 1,235.48 0.00
Interest 06/30/2023
912828XX3 900,000.00 US Treasury Note
2% Due: 06/30/2024
0.000 9,000.00 0.00 9,000.00 0.00
Interest 06/30/2023
91282CEW7 500,000.00 US Treasury Note
3.25% Due: 06/30/2027
0.000 8,125.00 0.00 8,125.00 0.00
Interest 06/30/2023
91282CGC9 450,000.00 US Treasury Note
3.875% Due: 12/31/2027
0.000 8,718.75 0.00 8,718.75 0.00
Subtotal 21,017,000.00 178,010.03 0.00 178,010.03 0.00
Dividend 04/03/2023
316175603 245,499.55 Fidelity Institutional Government MMKT Fund #657
0.000 691.27 0.00 691.27 0.00
Dividend 05/01/2023
316175603 6,295.47 Fidelity Institutional Government MMKT Fund #657
0.000 696.57 0.00 696.57 0.00
Dividend 06/01/2023
316175603 128,622.26 Fidelity Institutional Government MMKT Fund #657
0.000 331.63 0.00 331.63 0.00
Subtotal 380,417.28 1,719.47 0.00 1,719.47 0.00
TOTAL Other Transactions 21,397,417.28 179,729.50 0.00 179,729.50 0.00 March 31, 2023 through June 30, 2023
As of June 30, 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 June 30, 2023