Palo Alto City Council
February 12, 2024

Purchase Current
Rate
Maturity Days To
Date Maturity
YTM
360
YTM
365Par Value Market ValueCUSIP Investment # Issuer Date Book Value Negotiable Certificates of Deposits
07371CH69
29260MBH7
31944MBB0
15118RRH2
15523RCP9
15634VAA0
17783PAH4
12545JBB0
17248MAC1
17286TAG0
18507MAA9
200339FB0
29278TMR8
20825WAR1
14042TCP0
14042RQB0
20416TAW2
21686QAE9
21933PAA0
22258JAB7
22282XAA8
225645DN7
227563CF8
14622LAK8
15568PAK2
222327AD0
178180GV1
236334AD0
243594AR9
24773RCR4
88340AAA9
2669 NCD
2343 NCD
2389 NCD
2063 NCD
2324 NCD
2903 NCD
2785 NCD
2904 NCD
2504 NCD
2267 NCD
2881 NCD
2856 NCD
2215 NCD
2643 NCD
2089 NCD
2609 NCD
2756 NCD
2834 NCD
2860 NCD
2695 NCD
2901 NCD
2296 NCD
2875 NCD
2870 NCD
2862 NCD
2477 NCD
2809 NCD
2917 NCD
2690 NCD
2670 NCD
2778 NCD
Beal Bank USA - Las Vegas, NV
Encore Bank
03/02/2022
05/21/2020
08/20/2020
08/30/2019
03/27/2020
05/24/2023
01/18/2023
05/17/2023
03/04/2021
02/27/2020
04/26/2023
03/30/2023
01/29/2020
12/23/2021
09/05/2019
11/17/2021
12/21/2022
02/23/2023
04/04/2023
09/30/2022
05/19/2023
03/20/2020
04/14/2023
04/25/2023
03/31/2023
01/29/2021
01/25/2023
12/28/2023
09/23/2022
03/09/2022
12/22/2022
248,764.00
249,000.00
248,000.00
245,000.00
248,385.00
249,000.00
249,000.00
249,000.00
248,605.19
244,886.55
249,000.00
249,000.00
245,000.00
248,703.55
245,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
248,000.00
249,000.00
249,000.00
249,000.00
247,990.97
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
248,000.00
245,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
245,000.00
249,000.00
249,000.00
245,000.00
249,000.00
245,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
248,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
228,644.25
220,399.86
230,575.52
239,793.75
236,806.47
249,037.35
248,940.24
249,341.13
218,109.06
235,494.00
248,992.53
249,174.30
236,454.40
223,826.10
239,764.35
223,870.92
248,892.93
248,895.42
248,940.24
246,019.47
248,980.08
236,311.76
248,957.67
248,083.68
249,129.48
202,705.92
247,383.99
250,367.01
235,695.93
228,270.75
248,965.14

2.050

1.150

0.450

1.850

1.000

5.150

4.900

5.000

0.650

1.650

5.150

5.250

1.800

1.250

1.900

1.100

5.000

5.100

5.350

4.400

5.250

1.100

5.100

4.750

5.300

1.100

4.500

5.450

3.700

2.000

5.150

2.053

1.134

0.444

1.826

1.189

5.079

4.834

4.937

0.691

1.668

5.086

5.179

1.779

1.273

1.873

1.084

4.935

5.029

5.281

4.341

5.178

1.085

5.033

4.688

5.231

1.154

4.438

5.381

3.651

1.975

5.079

2.081 02/24/2027

1.150 05/21/2027

0.450 08/20/2025

1.852 08/30/2024

1.206 03/27/2025

5.150 11/25/2024

4.901 01/18/2024

5.006 05/17/2028

0.701 03/04/2027

1.691 02/27/2025

5.157 04/28/2025

5.251 09/30/2024

1.803 01/29/2025

1.291 12/23/2026

1.900 09/05/2024

1.100 11/17/2026

5.004 06/21/2024

5.099 02/23/2024

5.354 04/04/2024

4.402 09/27/2027

5.250 02/20/2024

1.100 03/20/2025

5.103 04/14/2026

4.753 04/25/2025

5.304 03/31/2027

1.170 01/29/2030

4.500 01/27/2025

5.455 12/28/2028

3.701 09/23/2027

2.003 02/25/2027

5.150 12/23/2024
1,150
1,236
597First Carolina Bank
Celtic Bank 242
Central State Bank IOWA
Centris Fed Credit Union Bank
City Federal Credit Union
CIBM Bank
451
329
17 1,598
1,158
423
Cinfed Fed Credtit Union Bank
Citadel Federal Credit Union
Clearpath Federal Credit Union
Comerica Bank Texas
Enerbank USA
483
273
394
Connexus Credit Union
Capital One Bank USA NA
Capital One Bank USA NA
Communitywide Fed. Cr. Union
Cooper Choice Network CU
Corning Federal Credit Union
County Schools FCU
1,087
248
1,051
172
53 94
1,365
50Covantage Credit Union
Crescent Bank & Trust
Cross River Bank
444
834
Carter Federal Credit Union
Cental Valley Community Bank
Country Club Bank
480
1,185
2,220
392City National Bank
Dannemora Fed Credit Union
Decorah Bank Trust Company
Delta Natl Bank & TR
1,823
1,361
1,151
357The District Fed Cr Union
Portfolio CPA
AP
Run Date: 01/21/2024 - 18:49 FI (PRF_FI) 7.3.11
Report Ver. 7.3.11
Item 14
Attachment B - Investment Portfolio

Item 14: Staff Report
Pg.
12 Packet Pg. 385 of 428

Fund ALL - Portfolio Listings
Investments by Fund
December 31, 2023

Purchase Current
Rate
Maturity Days To
Date Maturity
YTM
360
YTM
365Par Value Market ValueCUSIP Investment # Issuer Date Book Value Negotiable Certificates of Deposits
27004PBV4
28619WAH6
29367RMN3
308682BM4
33847E4E4
31925YAE2
73319FAF6
319477AV7
32022RNT0
320165JK0
30960QAK3
31976UAA6
33651FAF6
335857CK2
307811DM8
32110YRQ0
35638CAE9
32026UG83
33715LET3
31986JAD3
33766LAJ7
37424PAC8
387625AA4
39981MAC6
397129AJ6
404730DA8
06251A2Q2
41166MAF2
446438SB0
42228LAM3
44931EAD3
2545 NCD
2915 NCD
2897 NCD
2486 NCD
2414 NCD
2877 NCD
2285 NCD
2907 NCD
2390 NCD
2076 NCD
2479 NCD
2759 NCD
2812 NCD
2451 NCD
2644 NCD
2465 NCD
2868 NCD
2861 NCD
2845 NCD
2554 NCD
2061 NCD
2456 NCD
2042 NCD
2846 NCD
2725 NCD
2447 NCD
2457 NCD
2776 NCD
2891 NCD
2816 NCD
2743 NCD
Eaglemark Savings Bank
Elements Financial FCU
Enterprise Bank
07/07/2021
12/20/2023
05/19/2023
02/12/2021
09/30/2020
04/25/2023
03/18/2020
05/19/2023
08/19/2020
09/04/2019
01/27/2021
12/16/2022
01/31/2023
11/30/2020
01/14/2022
12/31/2020
04/14/2023
03/31/2023
03/24/2023
07/28/2021
08/23/2019
11/30/2020
05/08/2019
03/24/2023
11/28/2022
11/16/2020
12/14/2020
12/27/2022
05/05/2023
01/30/2023
12/09/2022
248,499.27
249,000.00
249,000.00
248,362.93
249,000.00
249,000.00
249,000.00
249,000.00
248,000.00
245,000.00
248,741.93
249,000.00
249,000.00
248,637.24
248,247.73
248,751.11
249,000.00
249,000.00
249,000.00
248,577.96
245,000.00
248,651.97
245,000.00
249,000.00
249,000.00
206,318.59
248,756.72
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
248,000.00
245,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
245,000.00
249,000.00
245,000.00
249,000.00
249,000.00
207,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
225,638.82
250,130.46
245,875.05
210,417.45
240,419.46
249,219.12
237,309.45
249,024.90
230,600.32
239,504.65
227,927.13
248,743.53
248,887.95
220,330.14
209,431.41
219,139.92
248,459.67
248,571.72
249,413.34
219,744.99
240,070.60
214,174.86
242,701.90
248,937.75
248,828.19
191,036.16
229,177.11
248,877.99
248,220.63
244,495.59
248,905.38

0.850

5.350

4.250

1.000

0.400

4.900

1.100

5.150

0.450

1.750

0.500

5.050

4.850

0.650

1.600

0.600

4.850

5.000

5.350

0.850

1.950

0.800

2.550

5.350

4.950

0.350

0.500

5.100

4.800

4.250

5.000

0.919

5.282

4.196

1.037

0.394

4.838

1.085

0.932 07/07/2026

5.355 12/20/2028

4.255 05/19/2028

1.052 02/12/2029

0.400 09/30/2024

4.905 04/25/2028

1.100 03/18/2025
05/19/2025
918
1,815
1,600
1,869
273
Farmers & Merchant State Bank
Flagstar Bank FSB
First Bank of the Lake
Poppy Bank
1,576
442
First-Citizens Bank 504
1st Financial Bank 0.444

1.727

0.543

4.985

4.781

0.691

1.630

0.625

4.783

4.931

5.300

0.892

1.925

0.825

2.513

5.276

4.877

0.491

0.543

5.027

4.734

4.193

4.931

0.450 08/19/2025

1.751 09/04/2024

0.550 01/27/2026

5.054 12/16/2024

4.847 01/31/2024

0.701 11/30/2026

1.653 01/22/2030

0.633 12/31/2026

4.850 10/15/2024

5.000 12/30/2024

5.374 09/24/2024

0.905 02/26/2027

1.952 08/23/2024

0.836 11/30/2027

2.548 05/08/2024

5.350 03/25/2024

4.945 05/28/2024

0.498 10/20/2025

0.550 12/15/2025

5.097 03/27/2024

4.800 05/05/2025

4.251 02/01/2027

5.000 06/10/2024
596
First Farmers Bank & Trust
Farmers Insurance Group CU
First Class Community CU
First Source Federal Cr Union
First Oklahoma Bank
247
757
350
30 1,064
2,213
1,095
288
Farmers &Merchants Bank
First National Bank of America
Freedom First Fed CU Bank
First Foundation Bank
First Technology Federal Credi
First Community Credit Union
Firstier Bank
364
267
1,152
235
Gesa Credit Union 1,429
128Grant County Bank West V.

Grow Financial Fed CU
Greenwood Credit Union
Haddon Savings Bank
Bank Hapoalim BM
84 148
658
714
Harborstone Credit Union
Huntington National Bank
Healthcare Systems FCU
IC Federal Credit Union
86 490
1,127
161
Portfolio CPA
AP
Run Date: 01/21/2024 - 18:49 FI (PRF_FI) 7.3.11
Report Ver. 7.3.11
Item 14
Attachment B - Investment Portfolio

Item 14: Staff Report
Pg.
13 Packet Pg. 386 of 428

Fund ALL - Portfolio Listings
Investments by Fund
December 31, 2023

Purchase Current
Rate
Maturity Days To
Date Maturity
YTM
360
YTM
365Par Value Market ValueCUSIP Investment # Issuer Date Book Value Negotiable Certificates of Deposits
45776NFE1
45791JAC0
45780PAQ8
48040PJL0
50116CAX7
48836LAV4
49306SK54
49332PAC4
920133AJ4
50625LBG7
523343AA9
52470QAN4
53955LAB3
530520AC9
538036SS4
554479EK7
56102AAQ9
59001PAP4
58404DDB4
589227AG2
59013KPS9
60425SJQ3
560507AN5
56065GAG3
62384RAR7
61690UY20
61768EQV8
625925AP7
63008MAW1
642858AA2
23204HNL8
2757 NCD
2836 NCD
2556 NCD
2452 NCD
1798 NCD
2731 NCD
2885 NCD
2914 NCD
2748 NCD
2879 NCD
2918 NCD
2469 NCD
2823 NCD
2803 NCD
2599 NCD
2819 NCD
2402 NCD
2672 NCD
2010 NCD
2059 NCD
2610 NCD
2478 NCD
2144 NCD
2038 NCD
2719 NCD
2815 NCD
2849 NCD
1800 NCD
2896 NCD
2760 NCD
2848 NCD
INS Bank 12/14/2022
02/27/2023
07/29/2021
11/27/2020
05/31/2017
11/23/2022
04/28/2023
12/29/2023
12/14/2022
04/14/2023
12/29/2023
12/30/2020
02/10/2023
01/27/2023
10/18/2021
02/09/2023
08/31/2020
03/07/2022
01/10/2019
08/30/2019
11/19/2021
01/28/2021
11/08/2019
04/26/2019
11/09/2022
02/02/2023
03/23/2023
05/22/2017
05/17/2023
12/14/2022
03/22/2023
249,000.00
249,000.00
249,000.00
248,513.94
245,000.00
249,000.00
249,000.00
249,000.00
249,000.00
242,714.55
249,000.00
248,379.08
249,000.00
249,000.00
248,527.46
249,000.00
249,000.00
241,763.57
245,000.00
245,000.00
248,604.66
248,525.94
245,000.00
245,000.00
248,865.13
249,000.00
249,000.00
245,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
245,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
245,000.00
245,000.00
249,000.00
249,000.00
245,000.00
245,000.00
249,000.00
249,000.00
249,000.00
245,000.00
249,000.00
249,000.00
249,000.00
248,987.55
248,970.12
225,188.13
213,778.95
242,336.85
248,945.22
248,706.18
249,600.09
248,868.03
242,555.88
255,389.34
209,974.23
248,860.56
247,613.07
217,513.95
248,255.49
232,563.51
228,761.28
244,916.70
239,693.30
228,103.92
210,766.05
238,348.25
242,929.75
248,442.24
246,256.02
249,500.49
242,630.85
249,009.96
249,077.19
249,403.38

4.900

5.100

0.900

0.750

2.500

5.150

5.000

5.400

5.100

3.100

4.050

0.850

4.900

4.500

1.100

4.600

0.400

0.550

3.300

1.800

1.100

1.000

1.900

2.600

4.850

4.250

5.250

2.350

4.900

5.000

5.300

4.835

5.036

0.888

0.790

2.465

5.083

4.931

5.399

5.038

4.931

3.994

0.889

4.830

4.442

1.135

4.532

0.394

1.904

3.254

1.775

1.152

1.024

1.875

2.567

4.825

4.191

5.178

2.317

4.838

4.931

5.227

4.902 12/14/2027

5.105 02/27/2025

0.900 07/29/2026

0.801 11/26/2027

2.500 05/31/2024

5.154 11/25/2024

5.000 05/01/2024

5.474 12/27/2024

5.108 12/13/2024

5.000 05/27/2025

4.050 12/29/2028

0.901 12/21/2028

4.897 02/12/2024

4.503 01/27/2026

1.151 10/18/2027

4.595 08/09/2024

0.400 06/30/2025

1.930 03/10/2026

3.299 01/03/2024

1.800 08/30/2024

1.168 05/19/2026

1.039 01/29/2029

1.902 11/08/2024

2.602 04/26/2024

4.892 05/09/2025

4.250 02/02/2026

5.250 03/24/2025

2.349 05/02/2024

4.905 05/17/2028

5.000 12/15/2025

5.300 09/23/2024
1,443
423
940
1,425
151
329
121
361
347
512
1,824
1,816
42 Insight Credit Union
Inst. for Sav in Newburyport
Jonesboro State Bank
Kansas State Bank Manhattan
Kembra Financial Credit Union
Key Bank
Keypoint Credit Union Bank
Valley Strong Credit Union
Lafayette Federal Credit Union
Ledyark National Bank
Legacy Bank & Trust Company
Local Gov't Fed. Credit Union
Liberty First Credit Union
Live Oak Banking Company
Machias Savings Bank
Malaga Bank FSB
757
1,386
221
546
799
2 Meritrust Federal Credit Union
Medallion Bank - Salt Lake
Merchants State Bank
Merrick Bank
242
869
1,855
312
116
494
763
448
122
1,598
714
266
Minwest Bank MV
Maine Savings Credit Union
Mainstreet Bank
Mountain America FD Credit Uni
Morgan Stanley Bank NA
Morgan Stanley Bank NA
Municipal Trust and Savings
Nano Banc
New Brunswick Postal FCU
Customers Bank
Portfolio CPA
AP
Run Date: 01/21/2024 - 18:49 FI (PRF_FI) 7.3.11
Report Ver. 7.3.11
Item 14
Attachment B - Investment Portfolio

Item 14: Staff Report
Pg.
14 Packet Pg. 387 of 428

Fund ALL - Portfolio Listings
Investments by Fund
December 31, 2023

Purchase Current
Rate
Maturity Days To
Date Maturity
YTM
360
YTM
365Par Value Market ValueCUSIP Investment # Issuer Date Book Value Negotiable Certificates of Deposits
654062LK2
664122AS7
64907LAN3
67117NAA6
67886WAD9
68609EAC5
69506YSA8
70146NAA5
70320KAR2
710665GD6
732329BD8
70962LAE2
740367HP5
693963AE0
724468AC7
710275AD0
732770BJ0
74048CAT9
712303BF2
744562AS8
75102EAC2
76857RCF9
75472RAU5
77535MAC7
7954504D4
805508BT4
856285UJ8
84229LBV3
15987UAJ7
81618LAE7
79772FAF3
2906 NCD
2854 NCD
2872 NCD
2905 NCD
2751 NCD
2765 NCD
2420 NCD
2825 NCD
2429 NCD
2468 NCD
2686 NCD
2565 NCD
2047 NCD
2852 NCD
2873 NCD
2853 NCD
2488 NCD
2895 NCD
2863 NCD
2796 NCD
2798 NCD
2892 NCD
2188 NCD
2717 NCD
2102 NCD
2710 NCD
2403 NCD
2882 NCD
2799 NCD
2857 NCD
2297 NCD
Nicolet National Bank
Northeast Community Bank
New Valley Bank & Trust
Oahu Fed Credit Union Bank
Oklahomas Credit Union
Oregon State Credit Union
Pacific Western Bank
Parkside Credit Union
Pathfinder Bank
05/30/2023
03/28/2023
04/17/2023
05/16/2023
12/14/2022
12/21/2022
09/30/2020
02/21/2023
10/13/2020
12/30/2020
09/15/2022
09/01/2021
08/16/2019
03/27/2023
04/14/2023
03/30/2023
02/24/2021
05/12/2023
03/30/2023
01/20/2023
01/25/2023
05/12/2023
12/30/2019
11/09/2022
09/18/2019
10/28/2022
09/04/2020
04/28/2023
01/19/2023
03/31/2023
03/27/2020
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
248,822.28
247,838.53
249,000.00
248,667.95
245,000.00
249,000.00
249,000.00
249,000.00
247,979.01
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
245,000.00
248,845.88
245,000.00
248,619.27
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
245,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
245,000.00
249,000.00
245,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,064.74
249,169.32
248,967.63
248,970.12
248,656.38
248,865.54
230,715.93
248,865.54
230,427.09
200,723.88
238,340.31
224,007.87
240,296.00
249,241.53
246,592.17
248,624.01
201,177.06
249,094.62
249,181.77
248,977.59
248,731.08
249,079.68
237,162.45
249,014.94
239,482.60
249,000.00
231,532.65
243,253.08
248,907.87
249,303.78
237,105.27

5.150

5.450

5.000

5.150

5.000

5.050

0.450

5.000

0.500

0.900

3.500

0.850

2.000

5.150

4.350

4.800

1.000

4.900

5.450

4.750

4.900

4.950

1.850

4.900

1.900

4.900

0.500

4.000

4.650

5.400

1.100

5.082

5.375

4.939

5.082

4.938

4.978

0.443

4.930

0.533

0.967

3.453

0.889

1.972

5.087

4.290

4.735

1.055

4.838

5.375

4.687

4.828

4.888

1.824

4.868

1.873

4.877

0.493

5.153 12/02/2024

5.450 03/28/2028

5.007 06/17/2025

5.153 11/18/2024

5.006 12/16/2024

5.047 03/21/2024

0.450 09/30/2025

4.999 02/21/2024

0.540 10/14/2025

0.981 12/31/2029

3.501 09/15/2027

0.901 09/01/2026

2.000 08/16/2024

5.157 03/27/2025

4.350 04/13/2028

4.800 03/30/2027

1.070 02/25/2030

4.905 06/14/2027

5.450 03/30/2028

4.752 01/20/2028

4.895 07/25/2024

4.955 05/12/2028

1.850 12/30/2024

4.935 11/10/2025

1.900 09/18/2024

4.945 10/28/2027

0.500 09/04/2025
04/28/2028
336
1,548
533
322
350
80 638
51 652
People's Bank 2,191
1,353
974
Ponce De Leon Federal Bank
Pentagon Fed Cred Union
Preferred Bank LA California
Pacific Alliance Bank
228
451
Pitney Bowes Bank, Inc.

People Bank / Coldwater OH
Pony Express Bank
1,564
1,184
2,247
1,260
1,550
1,480
206
Premier Community Bank
People's Security Bank & Trust
Public Service Credit Union
Raiz Federal Credit Union
RiverBank 1,593
364Rayond James Bank NA
Rogue Credit Union 679
Sallie Mae Bank 261
Sawyer Savings Bank
State Bank of India
1,396
612
Southern Bank 1,579
17Charles Schwab Bank
Select Bank Forest VA
San Francisco Credit Union

4.586

5.332

1.085

4.650 01/18/2024

5.406 03/31/2028

1.100 03/27/2025
1,551
451
Portfolio CPA
AP
Run Date: 01/21/2024 - 18:49 FI (PRF_FI) 7.3.11
Report Ver. 7.3.11
Item 14
Attachment B - Investment Portfolio

Item 14: Staff Report
Pg.
15 Packet Pg. 388 of 428

Fund ALL - Portfolio Listings
Investments by Fund
December 31, 2023

Purchase Current
Rate
Maturity Days To
Date Maturity
YTM
360
YTM
365Par Value Market ValueCUSIP Investment # Issuer Date Book Value Negotiable Certificates of Deposits
819866BR4
82671DAB3
87164DVY3
86804DCQ9
84611JAB9
78472EAC8
33646CNJ9
84133PFL7
84485EAG2
84503PAD2
87165FZN7
87868YAH6
882214AA7
88413QCK2
89235MLC3
902684AB5
90407LAD5
90307LAA2
91334AAC7
39573LBM9
90352RAU9
90353EAR4
938828BJ8
930584AC1
95960NKE6
949764AF1
98321PAJ9
98138MAX8
956310BM7
2718 NCD
2804 NCD
2886 NCD
2491 NCD
2807 NCD
2827 NCD
2754 NCD
2821 NCD
2333 NCD
2890 NCD
2563 NCD
2797 NCD
2464 NCD
2157 NCD
2551 NCD
2832 NCD
2742 NCD
2786 NCD
2711 NCD
2552 NCD
2325 NCD
2546 NCD
2049 NCD
2894 NCD
2342 NCD
2843 NCD
2446 NCD
2749 NCD
2855 NCD
Sharonview Fed Credit Union
Signature Federal Credit Union
Synovus Bank
10/31/2022
01/31/2023
04/28/2023
02/17/2021
01/27/2023
02/27/2023
12/16/2022
02/06/2023
03/31/2020
05/12/2023
08/20/2021
01/19/2023
12/23/2020
11/25/2019
07/15/2021
02/24/2023
12/09/2022
01/17/2023
10/28/2022
07/21/2021
03/31/2020
07/15/2021
08/23/2019
05/15/2023
05/13/2020
03/17/2023
11/27/2020
12/14/2022
03/28/2023
248,848.01
249,000.00
249,000.00
248,265.47
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
248,803.09
245,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
248,937.95
247,686.55
245,000.00
249,000.00
248,000.00
249,000.00
248,857.51
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
245,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,000.00
245,000.00
249,000.00
248,000.00
249,000.00
249,000.00
249,000.00
249,000.00
249,002.49
246,495.06
248,850.60
212,977.17
248,942.73
246,258.51
249,286.35
247,381.50
246,495.06
248,800.80
224,789.73
248,987.55
228,507.30
238,113.05
226,014.81
248,800.80
248,748.51
248,937.75
247,610.58
225,683.64
237,349.29
200,965.41
240,224.95
248,845.62
231,401.36
249,498.00
229,426.11
249,007.47
249,134.46

5.000

4.400

5.000

0.800

5.050

4.350

5.050

4.550

1.150

5.100

0.900

5.100

0.450

1.950

0.950

4.850

4.950

4.850

4.600

0.950

1.150

1.750

2.050

5.000

1.050

5.250

0.500

5.100

5.450

4.966

4.341

4.945

0.861

4.985

4.290

4.980

4.487

1.134

5.031

0.887

5.031

0.483

1.923

0.936

4.787

4.879

4.783

4.539

0.937

1.155

1.801

2.024

4.950

1.035

5.185

0.515

5.032

5.381

5.035 10/31/2025

4.401 01/31/2028

5.013 07/29/2024

0.873 02/17/2028

5.054 01/26/2024

4.349 02/28/2028

5.050 06/16/2028

4.550 02/06/2025

1.150 03/28/2024

5.101 05/10/2024

0.900 08/20/2026

5.100 07/21/2025

0.490 12/23/2025

1.950 11/25/2024

0.950 07/15/2026

4.854 08/25/2025

4.947 03/08/2024

4.849 01/17/2024

4.602 04/28/2025

0.950 07/21/2026

1.171 03/31/2025

1.826 07/15/2031

2.052 08/23/2024

5.019 08/15/2024

1.050 11/13/2025

5.257 03/17/2025

0.522 11/28/2025

5.102 12/14/2027

5.456 03/28/2028
669
1,491
210
1,508
25 Sunwest Bank
Space Age Federal Credit Union
SPCO Credit Union 1,519
1,628
402
87 First Source Bank
Southeast Bank
Southwest Financial Fed. Credi
Southwest Heritage Cr. Union
Synchrony Bank
130
962
567
722
329
926
602
67 Technology Credit Union
Texas Bank Henderson
Third Federal Savings and Loan
Toyota Financial Savings Bank
Ufirst Federal Credit Union
Umassfive College Fed Cr Union
Uncle Credit Union 16
United Heritage Credit Union
Greenstate Credit Union
USAlliance Federal Credit Unio
USF Federal Credit Union
Washington Federal
483
932
455
2,752
235
227
682
441
697
1,443
1,548
Wahoo State Bank
Western State Bank
Wells Fargo Bank
Wyoming Bank & Trust
Workers Fed Credit Union
West Town Bank and Trust
Subtotal and Average 44,167,761.81 44,196,000.00 42,694,303.61 3.269 3.314 776 Portfolio CPA
AP
Run Date: 01/21/2024 - 18:49 FI (PRF_FI) 7.3.11
Report Ver. 7.3.11
Item 14
Attachment B - Investment Portfolio

Item 14: Staff Report
Pg.
16 Packet Pg. 389 of 428

Fund ALL - Portfolio Listings
Investments by Fund
December 31, 2023

Purchase Current
Rate
Maturity Days To
Date Maturity
YTM
360
YTM
365Par Value Market ValueCUSIP Investment # Issuer Date Book Value Corporate Medium Term Bonds
037833CU2
037833DF4
037833EB2
037833CJ7
02079KAH0
02079KAC1
02079KAJ6
02079KAJ6
478160CN2
478160BY9
478160BY9
594918BX1
594918BJ2
594918BJ2
525555AB4
85440KAC8
85440KAC8
85440KAC8
85440KAC8
98459LAA1
98459LAA1
2053 MTN
2401 MTN
2489 MTN
2667 MTN
2507 MTN
2675 MTN
2689 MTN
2837 MTN
2466 MTN
2508 MTN
2509 MTN
2212 MTN
2450 MTN
2506 MTN
2182 MTN
2648 MTN
2658 MTN
2709 MTN
2761 MTN
2376 MTN
2511 MTN
Apple, Inc. 08/06/2019
08/28/2020
02/08/2021
02/23/2022
03/01/2021
03/14/2022
09/14/2022
02/15/2023
12/23/2020
03/01/2021
03/01/2021
01/22/2020
11/18/2020
03/01/2021
12/12/2019
01/07/2022
02/01/2022
10/19/2022
12/12/2022
07/01/2020
03/01/2021
1,504,093.29
1,532,380.30
700,084.66
1,500,000.00
1,500,000.00
700,000.00
1,485,975.00
1,469,685.00
648,319.00
730,507.50
187,740.00
944,370.00
893,770.00
2,502,556.00
1,873,680.00
1,923,500.00
961,750.00
1,795,518.00
2,850,153.60
175,694.40
1,000,900.00
1,356,285.00
452,095.00
1,383,410.70
406,885.50
1,892,980.00
2,839,470.00

2.850

2.750

0.700

3.350

0.450

1.998

0.800

0.800

0.550

2.450

2.450

2.875

3.125

3.125

6.875

1.289

1.289

1.289

1.289

0.873

0.873

1.998

0.620

0.684

2.115

0.668

2.197

3.442

3.964

0.479

0.812

0.812

1.727

0.572

0.753

1.934

1.479

1.849

4.487

4.142

0.616

0.638

2.025 05/11/2024

0.628 01/13/2025

0.694 02/08/2026

2.145 02/09/2027

0.678 08/15/2025

2.228 08/15/2026

3.489 08/15/2027

4.020 08/15/2027

0.486 09/01/2025

0.823 03/01/2026

0.824 03/01/2026

1.751 02/06/2024

0.580 11/03/2025

0.763 11/03/2025

1.960 02/01/2024

1.500 06/01/2027

1.875 06/01/2027

4.550 06/01/2027

4.200 06/01/2027

0.625 04/15/2025

0.646 04/15/2025
131
378Apple, Inc.

Apple, Inc. 769
Apple, Inc. 775,227.91 750,000.00 1,135
592Alphabet (Google) Inc.

Alphabet (Google) Inc.

Alphabet (Google) Inc.

Alphabet (Google) Inc.

Johnson & Johnson
Johnson & Johnson
Johnson & Johnson
Microsoft Corporation
Microsoft Corporation
Microsoft Corporation
Stanford University
Stanford University
Stanford University
Stanford University
Stanford University
Yale University
199,272.52 200,000.00
994,280.23 1,000,000.00
1,000,000.00
2,800,000.00
2,000,000.00
2,000,000.00
1,000,000.00
1,800,000.00
2,920,000.00
180,000.00
957
911,173.08 1,322
1,322
609
2,503,959.80
2,002,101.88
2,065,533.78
1,032,758.49
1,801,815.47
3,047,829.72
187,260.64
790
790
36 672
672
1,003,914.30
1,489,646.18
490,513.50
1,000,000.00
1,500,000.00
500,000.00
31 1,247
1,247
1,247
1,247
470
1,377,779.79
409,576.39
1,530,000.00
450,000.00
2,006,168.72
3,008,442.05
2,000,000.00
3,000,000.00Yale University 470
Subtotal and Average 29,043,812.70 29,330,000.00 27,775,244.70 1.585 1.607 715 Federal Agency Bonds
31315PL23
31315PEM7
31315P2J7
31315P2J7
31315PRA9
3132X0WL1
3130H0AU7
3130H0AU7
1428 Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
01/09/2015
04/08/2016
04/21/2016
04/26/2016
10/18/2016
10/06/2017
01/09/2018
01/11/2018
404,643.99
487,639.18
404,000.00
474,000.00
402,072.92
472,255.68

3.330

4.350

3.300

3.300

4.810

2.250

2.625

2.625

2.540

2.296

2.084

2.159

2.131

2.332

2.546

2.623

2.575 03/27/2024

2.328 08/04/2025

2.112 05/01/2024

2.189 05/01/2024

2.160 02/03/2026

2.365 08/23/2024

2.581 08/01/2024

2.660 08/01/2024
86 581
121
121
764
235
213
213
1580
1595
1604
1710
1867
1893
1901
1,505,432.39
1,505,064.96
1,574,829.06
999,318.14
1,500,000.00
1,500,000.00
1,500,000.00
1,000,000.00
1,000,000.00
1,500,000.00
1,490,580.00
1,490,580.00
1,517,100.00
982,460.00
1,000,230.27
1,499,719.52
986,210.00
1,479,315.00
Portfolio CPA
AP
Run Date: 01/21/2024 - 18:49 FI (PRF_FI) 7.3.11
Report Ver. 7.3.11
Item 14
Attachment B - Investment Portfolio

Item 14: Staff Report
Pg.
17 Packet Pg. 390 of 428

Fund ALL - Portfolio Listings
Investments by Fund
December 31, 2023

Purchase Current
Rate
Maturity Days To
Date Maturity
YTM
360
YTM
365Par Value Market ValueCUSIP Investment # Issuer Date Book Value Federal Agency Bonds
31315P4B2
31422BEJ5
31315PCY3
31315PEM7
31315PB99
31422BZS2
31422BF54
31422BF54
31422BH78
31422BX54
31422BZ45
31422B2E9
31422B3D0
31422B4A5
31422B3W8
31422B3D0
31422B6K1
31422B6A3
31422B7E4
31422XAW2
31422XCB6
31422XDX7
31422XDX7
31422XEE8
31422XEL2
31422XFJ6
31422XDX7
31422XDX7
31422XNM0
31422XPS5
31422XQM7
1999 Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Agricultural Mortgage
12/14/2018
04/09/2019
04/08/2019
09/09/2019
03/11/2020
05/13/2020
06/24/2020
06/24/2020
07/08/2020
10/08/2020
10/21/2020
10/29/2020
11/20/2020
12/11/2020
12/16/2020
12/09/2020
01/15/2021
01/15/2021
01/28/2021
02/25/2021
03/04/2021
03/29/2021
03/31/2021
04/07/2021
04/15/2021
04/29/2021
05/20/2021
06/08/2021
10/05/2021
11/17/2021
12/01/2021
549,162.36
999,876.41
549,000.00
1,000,000.00
678,000.00
548,176.50
992,000.00

3.460

2.350

5.250

4.350

2.850

1.500

1.400

1.400

1.400

1.300

1.280

1.340

1.150

1.300

1.450

1.150

0.480

1.290

1.320

1.530

1.470

0.830

0.830

2.070

1.375

1.660

0.830

0.830

1.050

1.150

1.320

3.018

2.365

2.420

1.659

1.050

1.479

1.380

1.380

1.380

1.286

1.262

1.321

1.134

1.282

1.430

1.144

0.493

1.319

1.301

1.509

1.581

0.828

0.913

2.074

1.311

1.627

0.864

0.820

1.035

1.272

1.301

3.060 01/30/2024

2.398 04/09/2024

2.454 11/20/2024

1.683 08/04/2025

1.064 11/19/2027

1.500 05/13/2030

1.400 06/24/2030

1.400 06/24/2030

1.400 07/08/2030

1.304 09/27/2030

1.280 10/21/2030

1.340 10/29/2030

1.150 11/20/2030

1.300 12/11/2030

1.450 12/16/2030

1.160 11/20/2030

0.500 01/15/2026

1.338 01/15/2031

1.320 01/28/2031

1.530 02/25/2031

1.602 03/04/2031

0.840 03/27/2026

0.926 03/27/2026

2.103 04/07/2031

1.330 04/13/2028

1.650 04/29/2031

0.876 03/27/2026

0.831 03/27/2026

1.050 10/05/2026

1.290 11/17/2026

1.320 12/01/2026
29 992034
2035 693,598.62 679,972.98 324
2098 572,134.50 550,000.00 547,976.00 581
2301 1,673,163.29
2,000,000.00
1,750,000.00
2,000,000.00
1,500,000.00
2,000,000.00
2,000,000.00
2,000,000.00
1,500,000.00
1,500,000.00
2,000,000.00
999,307.74
1,569,000.00
2,000,000.00
1,750,000.00
2,000,000.00
1,500,000.00
2,000,000.00
2,000,000.00
2,000,000.00
1,500,000.00
1,500,000.00
2,000,000.00
1,000,000.00
1,500,000.00
1,500,000.00
1,000,000.00
1,500,000.00
1,000,000.00
1,500,000.00
1,500,000.00
1,500,000.00
2,000,000.00
1,500,000.00
1,500,000.00
255,000.00
1,499,995.38
1,685,920.00
1,459,535.00
1,668,040.00
1,249,905.00
1,645,260.00
1,639,720.00
1,645,720.00
1,223,580.00
1,226,250.00
1,652,220.00
815,720.00
1,418
2,324
2,366
2,366
2,380
2,461
2,485
2,493
2,515
2,536
2,541
2,515
745
2340 Call
2366 Call
2367 Call
2381 Call
2425 Call
2435 Call
2439 Call
2449
2458 Call
2459 Call
2461
2471 1,499,388.33
1,495,248.75
1,000,000.00
1,500,000.00
991,217.80
1,391,370.00
1,222,110.00
815,720.00
2473 Call
2484 Call
2496 Call
2513
2,571
2,584
2,612
2,619
816
1,240,230.00
828,490.00
2519 1,499,663.79
1,496,836.14
1,496,955.00
2,003,662.10
1,500,989.25
1,498,489.27
254,990.25
1,391,940.00
1,391,940.00
1,286,610.00
1,793,560.00
1,256,550.00
1,391,940.00
236,629.80
2524 816
2527 Call
2529
2,653
1,564
2,675
816
2530
2533
2540 816
2593 1,000,000.00
996,097.73
1,000,000.00
1,000,000.00
1,000,000.00
920,610.00 1,008
1,051
1,065
2621 919,830.00
2625 1,000,000.00 923,730.00
Portfolio CPA
AP
Run Date: 01/21/2024 - 18:49 FI (PRF_FI) 7.3.11
Report Ver. 7.3.11
Item 14
Attachment B - Investment Portfolio

Item 14: Staff Report
Pg.
18 Packet Pg. 391 of 428

Fund ALL - Portfolio Listings
Investments by Fund
December 31, 2023

Purchase Current
Rate
Maturity Days To
Date Maturity
YTM
360
YTM
365Par Value Market ValueCUSIP Investment # Issuer Date Book Value Federal Agency Bonds
31422XRK0
31422XRY0
3133EC7D0
3133EEVD9
3133EDWX6
3133EAG44
3133ELQ31
3133ELQ31
3133EL3H5
3133EL4W1
3133EL4W1
3133EL7K4
3133EMBH4
3133EMBJ0
3133EMAZ5
3133EMFG2
3133EMFG2
3133EMNB4
3133EMRE4
3133EMUG5
3133EN5S5
3133EPFB6
3133EPFB6
3133EPHA6
3133EPHA6
3133EPHJ7
3130AJMF3
3130AJP78
3130AJP78
3130AJR76
3130AJRG6
2634 Federal Agricultural Mortgage
Federal Agricultural Mortgage
Federal Farm Credit Bank .

Federal Farm Credit Bank .

Federal Farm Credit Bank .

Federal Farm Credit Bank .

Federal Farm Credit Bank .

Federal Farm Credit Bank .

Federal Farm Credit Bank .

Federal Farm Credit Bank .

Federal Farm Credit Bank .

Federal Farm Credit Bank .

Federal Farm Credit Bank .

Federal Farm Credit Bank .

Federal Farm Credit Bank .

Federal Farm Credit Bank .

Federal Farm Credit Bank .

Federal Farm Credit Bank .

Federal Farm Credit Bank .

Federal Farm Credit Bank .

Federal Farm Credit Bank .

Federal Farm Credit Bank .

Federal Farm Credit Bank .

Federal Farm Credit Bank .

Federal Farm Credit Bank .

Federal Farm Credit Bank .

Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
01/04/2022
12/29/2021
05/13/2016
05/04/2017
06/21/2017
03/13/2020
07/01/2020
07/01/2020
08/12/2020
09/03/2020
09/10/2020
09/22/2020
09/29/2020
09/29/2020
10/01/2020
11/04/2020
11/04/2020
01/14/2021
04/01/2021
05/27/2021
01/10/2023
04/12/2023
04/14/2023
04/28/2023
04/28/2023
04/28/2023
05/28/2020
06/11/2020
06/11/2020
06/29/2020
06/24/2020
1,500,000.00
1,500,000.00
1,001,463.18
899,987.51
1,500,000.00
1,500,000.00
1,000,000.00
900,000.00
1,382,190.00
1,273,515.00
974,440.00

1.320

2.150

2.125

2.300

2.910

2.630

1.330

1.330

0.570

0.610

0.610

0.550

0.530

0.530

1.250

1.370

1.370

1.380

1.420

1.980

5.900

5.840

5.840

5.800

5.800

6.080

1.320

1.400

1.400

1.250

1.360

1.301

2.120

1.930

2.274

2.143

1.089

1.311

1.311

0.587

0.611

0.611

0.542

0.522

0.537

1.246

1.351

1.351

1.361

1.834

1.887

5.819

5.760

5.759

5.720

5.720

5.996

1.301

1.380

1.427

1.232

1.341

1.320 01/04/2027

2.150 12/29/2031

1.956 12/13/2024

2.306 03/25/2024

2.172 10/07/2024

1.104 08/03/2026

1.330 07/01/2030

1.330 07/01/2030

0.595 08/12/2025

0.620 08/25/2025

0.620 08/25/2025

0.549 09/16/2025

0.530 09/29/2025

0.545 09/29/2025

1.263 06/24/2030

1.370 11/04/2030

1.370 11/04/2030

1.380 01/14/2031

1.859 02/18/2031

1.913 03/24/2031

5.900 01/10/2033

5.840 04/12/2032

5.839 04/12/2032

5.800 04/28/2031

5.800 04/28/2031

6.080 04/28/2033

1.320 11/28/2028

1.400 06/11/2029

1.447 06/11/2029

1.250 06/29/2029

1.360 06/24/2030
1,099
2,919
347
2640 Call
1615
1787 893,727.00 84
1822 502,598.67 500,000.00 492,690.00 280
2314 1,038,025.60
1,500,000.00
1,500,000.00
1,499,394.79
1,499,751.40
1,499,750.42
1,500,000.00
1,500,000.00
1,499,607.50
1,998,335.00
1,500,000.00
1,500,000.00
1,500,000.00
1,457,186.60
1,004,334.65
1,500,000.00
1,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
1,500,000.00
1,000,000.00
997,580.25
1,000,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
2,000,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,000,000.00
1,500,000.00
1,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
1,500,000.00
1,000,000.00
1,000,000.00
900,000.00
963,630.00 945
2371 Call
2372 Call
2391 Call
2406 Call
2408 Call
2416 Call
2417 Call
2423 Call
2427 Call
2442 Call
2443 Call
2472 Call
2525 Call
2538 Call
2789 Call
2865 Call
2880 Call
2884 Call
2887 Call
2888 Call
2347 Call
2358 Call
2361 Call
2368 Call
2369 Call
1,241,795.18
1,241,795.18
1,405,665.00
1,409,730.00
1,409,730.00
1,404,225.00
1,401,720.00
1,401,720.00
1,635,880.00
1,239,630.00
1,239,630.00
1,230,330.00
1,218,420.00
852,820.00
2,373
2,373
589
602
602
624
637
637
2,366
2,499
2,499
2,570
2,605
2,639
3,297
3,024
3,024
2,674
2,674
3,405
1,793
1,988
1,988
2,006
2,366
1,495,890.00
992,130.00
992,130.00
992,350.00
992,350.00
1,996,160.00
1,311,360.00
863,020.00
863,020.00
900,000.00 769,149.00
1,500,000.00 1,500,000.00 1,247,670.00
Portfolio CPA
AP
Run Date: 01/21/2024 - 18:49 FI (PRF_FI) 7.3.11
Report Ver. 7.3.11
Item 14
Attachment B - Investment Portfolio

Item 14: Staff Report
Pg.
19 Packet Pg. 392 of 428

Fund ALL - Portfolio Listings
Investments by Fund
December 31, 2023

Purchase Current
Rate
Maturity Days To
Date Maturity
YTM
360
YTM
365Par Value Market ValueCUSIP Investment # Issuer Date Book Value Federal Agency Bonds
3130AJSR1
3130AJSR1
3130AJSR1
3130AJZ36
3130AJZ36
3130AK3Z7
3130AJZ36
3130AKAZ91
3130AJQS1
3130AKQN9
3130AKQV1
3130AKVH6
3130AKYB6
3130AL2J2
3130ALF66
3130ALF33
3130APPJ8
3130APV77
3130APW84
3130APXD2
3130APWY7
3130APXT7
3130AQSM6
3130AQX65
3130AQYA5
3130AQYG2
3130AQZD8
3130ATKJ5
3130AUFY5
3130AUJJ4
3130AULM4
2375 Call Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
Federal Home Loan Bank
07/09/2020
07/09/2020
07/09/2020
08/27/2020
08/27/2020
09/29/2020
09/16/2020
09/29/2020
11/04/2020
01/28/2021
01/28/2021
02/10/2021
02/18/2021
02/26/2021
02/25/2021
03/25/2021
11/04/2021
12/10/2021
12/03/2021
12/17/2021
12/07/2021
12/17/2021
02/25/2022
03/04/2022
02/28/2022
02/28/2022
02/25/2022
10/14/2022
01/05/2023
01/30/2023
01/26/2023
1,500,000.00
1,500,000.00
1,498,923.83
1,499,503.33
1,499,503.33
1,499,476.67
1,180,000.00
1,500,000.00
1,199,741.79
1,500,000.00
1,500,000.00
1,500,000.00
2,000,000.00
1,500,000.00
1,500,000.00
1,920,214.91
1,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
1,500,000.00
1,000,000.00
1,499,772.08
1,499,982.83
1,094,594.59
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,180,000.00
1,500,000.00
1,200,000.00
1,500,000.00
1,500,000.00
1,500,000.00
2,000,000.00
1,500,000.00
1,500,000.00
1,925,000.00
1,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
1,500,000.00
1,000,000.00
1,500,000.00
1,500,000.00
1,094,594.59
1,500,000.00
1,248,960.00
1,248,960.00
1,248,960.00
1,409,190.00
1,409,190.00
1,402,710.00
1,108,562.80
1,401,525.00
997,380.00

1.390

1.390

1.390

0.600

0.600

0.570

0.600

0.520

1.350

1.400

1.400

1.350

1.400

1.500

1.625

0.750

2.000

1.500

1.500

1.550

1.350

1.600

2.050

2.250

2.250

2.500

2.625

4.375

4.750

5.555

5.620

1.370

1.370

1.382

0.611

0.611

0.582

0.591

0.512

1.334

1.380

1.380

1.331

1.380

1.479

1.602

0.853

1.972

1.479

1.479

1.528

1.331

1.578

2.021

2.219

2.219

2.470

2.589

4.400

4.790

5.479

5.543

1.390 07/09/2030

1.390 07/09/2030

1.401 07/09/2030

0.620 08/27/2025

0.620 08/27/2025

0.590 09/29/2025

0.599 08/27/2025

0.520 09/29/2025

1.353 06/25/2030

1.400 01/09/2031

1.400 01/28/2031

1.350 02/10/2031

1.400 02/18/2031

1.500 02/26/2031

1.625 02/25/2031

0.865 03/16/2026

2.000 11/04/2031

1.500 12/10/2026

1.500 12/03/2026

1.550 12/17/2026

1.350 12/07/2026

1.600 12/17/2026

2.050 02/25/2027

2.250 03/04/2027

2.250 02/24/2027

2.504 02/25/2027

2.625 02/25/2027

4.461 03/08/2024

4.856 01/05/2024

5.555 01/27/2028

5.620 01/26/2033
2,381
2,381
2,381
604
2377 Call
2384 Call
2395 Call
2399 Call
2405 Call
2411 Call
2419 Call
2445 Call
2475 Call
2476 Call
2485 Call
2490 Call
2494 Call
2500 Call
2520 Call
2607 Call
2613 Call
2616 Call
2618 Call
2619 Call
2620 Call
2659 Call
2662 Call
2663 Call
2664 Call
2665 Call
2703
604
637
604
637
2,367
2,565
2,584
2,597
2,605
2,613
2,612
805
1,224,435.00
1,230,825.00
1,225,185.00
1,638,640.00
1,237,395.00
1,248,915.00
1,779,296.75
841,840.00 2,864
1,074
1,067
1,081
1,071
1,081
1,151
1,158
1,150
1,151
1,151
67 921,310.00
922,450.00
922,860.00
918,090.00
924,230.00
936,150.00
941,920.00
942,040.00
1,423,920.00
952,930.00
1,496,910.00
1,499,910.00
1,089,898.78
1,494,015.00
2787 4
2794 Call
2802 Call
1,487
3,313
Portfolio CPA
AP
Run Date: 01/21/2024 - 18:49 FI (PRF_FI) 7.3.11
Report Ver. 7.3.11
Item 14
Attachment B - Investment Portfolio

Item 14: Staff Report
Pg.
20 Packet Pg. 393 of 428

Fund ALL - Portfolio Listings
Investments by Fund
December 31, 2023

Purchase Current
Rate
Maturity Days To
Date Maturity
YTM
360
YTM
365Par Value Market ValueCUSIP Investment # Issuer Date Book Value Federal Agency Bonds
3130AUU28
3130AVCN0
3130AVYF3
3134GVUA4
3134GV3B2
3134GV3U0
3134GV4E5
3134GV5D6
3134GV5A2
3134GV7L6
3134GV7L6
3134GWNC6
3134GWC53
3134GWA55
3134GWD52
3134GWP75
3134GWP75
3134GWVV5
3134GWW93
3134GWW93
3134GWXK7
3134GWXX9
3134GWY26
3134GWYZ3
3134GWZ33
3134GWZL3
3134GW3T1
3134GW3H7
3134GWZZ2
3134GW3Z7
3134GW3X2
2824 Federal Home Loan Bank 02/08/2023
03/13/2023
05/24/2023
05/18/2020
06/30/2020
06/29/2020
07/01/2020
07/08/2020
07/15/2020
07/29/2020
07/29/2020
08/20/2020
09/15/2020
09/09/2020
09/04/2020
09/23/2020
09/23/2020
10/15/2020
09/30/2020
09/30/2020
09/30/2020
10/15/2020
10/08/2020
10/28/2020
10/22/2020
10/29/2020
10/28/2020
10/29/2020
10/28/2020
10/28/2020
10/27/2020
1,000,000.00
499,990.00
1,000,000.00
500,000.00
999,460.00
499,985.00

5.000

5.375

6.000

1.200

1.400

1.250

1.200

1.200

1.375

1.350

1.350

0.625

0.650

0.650

0.680

0.625

0.625

0.500

0.550

0.550

0.550

0.550

0.570

0.530

1.250

0.570

1.400

0.610

1.300

0.600

0.625

4.931

5.311

5.917

1.183

1.380

1.232

1.183

1.183

1.356

1.331

1.331

0.616

0.641

0.641

0.670

0.616

0.616

0.493

0.542

0.542

0.542

0.542

0.562

0.522

1.232

0.562

1.380

0.601

1.282

0.591

0.616

5.000 02/08/2024

5.385 03/13/2024

6.000 05/24/2033

1.200 05/18/2028

1.400 06/28/2030

1.250 06/29/2029

1.199 12/29/2028

1.200 01/08/2029

1.375 07/15/2030

1.350 07/29/2030

1.350 07/29/2030

0.625 08/19/2025

0.650 09/15/2025

0.650 09/09/2025

0.679 09/02/2025

0.625 09/23/2025

0.625 09/23/2025

0.500 10/15/2025

0.550 09/30/2025

0.550 09/30/2025

0.550 09/30/2025

0.550 10/15/2025

0.570 10/08/2025

0.530 10/28/2025

1.250 10/22/2030

0.570 10/29/2025

1.400 10/28/2030

0.610 10/29/2025

1.300 10/28/2030

0.600 10/28/2025

0.625 10/27/2025
38 722844 Federal Home Loan Bank
2902 Call
2345 Call
2370 Call
2373 Call
2379 Call
2380 Call
2382 Call
2386 Call
2387 Call
2396 Call
2400 Call
2404 Call
2407 Call
2409 Call
2410 Call
2418 Call
2421 Call
2422 Call
2424 Call
2426 Call
2428 Call
2430 Call
2431 Call
2432 Call
2433 Call
2434 Call
2436 Call
2437 Call
2438 Call
Federal Home Loan Bank 1,000,000.00
455,000.00
1,000,000.00
455,000.00
994,960.00 3,431
1,599
2,370
2,006
1,824
1,834
2,387
2,401
2,401
596
Fed. Home Loan Mortgage Corp.

Fed. Home Loan Mortgage Corp.

Fed. Home Loan Mortgage Corp.

Fed. Home Loan Mortgage Corp.

Fed. Home Loan Mortgage Corp.

Fed. Home Loan Mortgage Corp.

Fed. Home Loan Mortgage Corp.

Fed. Home Loan Mortgage Corp.

Fed. Home Loan Mortgage Corp.

Fed. Home Loan Mortgage Corp.

Fed. Home Loan Mortgage Corp.

Fed. Home Loan Mortgage Corp.

Fed. Home Loan Mortgage Corp.

Fed. Home Loan Mortgage Corp.

Fed. Home Loan Mortgage Corp.

Fed. Home Loan Mortgage Corp.

Fed. Home Loan Mortgage Corp.

Fed. Home Loan Mortgage Corp.

Fed. Home Loan Mortgage Corp.

Fed. Home Loan Mortgage Corp.

Fed. Home Loan Mortgage Corp.

Fed. Home Loan Mortgage Corp.

Fed. Home Loan Mortgage Corp.

Fed. Home Loan Mortgage Corp.

Fed. Home Loan Mortgage Corp.

Fed. Home Loan Mortgage Corp.

Fed. Home Loan Mortgage Corp.

Fed. Home Loan Mortgage Corp.
402,047.10
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,000,000.00
1,500,000.00
1,447,000.00
1,500,000.00
1,500,000.00
1,000,000.00
1,500,000.00
2,000,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
2,000,000.00
1,500,000.00
2,000,000.00
750,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,000,000.00
1,500,000.00
1,447,000.00
1,500,000.00
1,500,000.00
1,000,000.00
1,500,000.00
2,000,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
2,000,000.00
1,500,000.00
2,000,000.00
750,000.00
1,250,655.00
1,281,915.00
1,295,595.00
1,294,755.00
1,247,130.00
1,243,665.00
1,243,665.00
940,640.00
1,406,760.00
1,357,908.21
1,409,400.00
1,404,975.00
936,650.00
623
617
610
631
631
1,402,230.00
1,869,420.00
1,402,065.00
1,402,065.00
1,398,300.00
1,399,875.00
1,395,795.00
1,227,075.00
1,396,680.00
1,652,880.00
1,397,175.00
1,641,160.00
698,805.00
653
638
638
638
653
646
666
2,486
667
2,492
667
2,492
666
1,500,000.00 1,500,000.00 1,398,405.00 665
Portfolio CPA
AP
Run Date: 01/21/2024 - 18:49 FI (PRF_FI) 7.3.11
Report Ver. 7.3.11
Item 14
Attachment B - Investment Portfolio

Item 14: Staff Report
Pg.
21 Packet Pg. 394 of 428

Fund ALL - Portfolio Listings
Investments by Fund
December 31, 2023

Purchase Current
Rate
Maturity Days To
Date Maturity
YTM
360
YTM
365Par Value Market ValueCUSIP Investment # Issuer Date Book Value Federal Agency Bonds
3134GW6N1
3134GW6N1
31364CCC0
3136G4R62
3136G4S87
3136G4Q97
3136G4V59
3136G44G5
3136G43L5
3136G44L4
3135G05Q2
3135GAAS0
3135G06Q1
880591CJ9
880591ER9
880591CJ9
880591CJ9
2440 Call Fed. Home Loan Mortgage Corp.

Fed. Home Loan Mortgage Corp.

Federal National Mortgage Asso
Federal National Mortgage Asso
Federal National Mortgage Asso
Federal National Mortgage Asso
Federal National Mortgage Asso
Federal National Mortgage Asso
Federal National Mortgage Asso
Federal National Mortgage Asso
Federal National Mortgage Asso
Federal National Mortgage Asso
Federal National Mortgage Asso
Tennessee Valley Authority
11/05/2020
11/05/2020
11/10/2016
08/28/2020
08/27/2020
08/27/2020
08/27/2020
09/22/2020
09/30/2020
09/25/2020
12/07/2020
12/23/2020
12/30/2020
11/20/2015
01/15/2016
04/18/2016
11/10/2016
1,500,000.00
1,500,000.00
548,986.80
1,500,000.00
1,500,000.00
500,000.00
1,242,180.00
1,242,180.00
532,360.00

1.400

1.400

7.125

0.625

0.650

0.650

0.625

0.515

0.550

0.600

0.875

1.400

0.640

6.750

2.875

6.750

6.750

1.380

1.380

2.367

0.616

0.641

0.641

0.616

0.507

0.542

0.591

1.139

1.380

0.597

2.807

2.564

2.337

2.317

1.400 11/05/2030

1.400 11/05/2030

2.400 04/30/2026

0.625 08/28/2025

0.650 08/27/2025

0.650 08/27/2025

0.625 08/27/2025

0.515 09/22/2025

0.550 09/30/2025

0.600 09/25/2025

1.155 08/05/2030

1.400 12/23/2030

0.605 12/30/2025

2.846 11/01/2025

2.600 09/15/2024

2.370 11/01/2025

2.350 11/01/2025
2,500
2,500
850
2444 Call
1715
2392 Call
2393 Call
2394 Call
2397 Call
2412 Call
2413 Call
2415 Call
2460
1,000,000.00
1,000,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,965,147.66
1,500,000.00
1,000,675.06
1,061,939.74
751,293.81
1,000,000.00
1,000,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
2,000,000.00
1,500,000.00
1,000,000.00
1,000,000.00
750,000.00
939,730.00 605
940,250.00 604
1,410,375.00
1,409,790.00
1,402,470.00
1,402,065.00
1,404,060.00
1,629,860.00
1,234,065.00
925,810.00
604
604
630
638
633
2,408
2,548
729
2463 Call
2467 Call
1508 1,043,730.00
738,787.50
670
1519 Tennessee Valley Authority 258
1589 Tennessee Valley Authority 830,406.79 775,000.00 808,890.75 670 1714 Tennessee Valley Authority 1,340,430.83 1,250,000.00 1,304,662.50 670 Subtotal and Average 198,788,258.46 198,355,594.59 178,632,300.01 1.587 1.610 1,560 Treasury Securities (Notes)
91282CBC4
91282CBQ3
91282CCP4
91282CFN6
91282CER8
2505 TB
2516 TB
2587 TB
2701 TB
2740 TB
U.S. Treasury
U.S. Treasury
U.S. Treasury
U.S. Treasury
U.S. Treasury
02/26/2021
03/09/2021
09/24/2021
10/07/2022
11/23/2022
1,489,213.41
1,489,506.78
1,489,570.45
1,000,353.50
1,486,975.61
1,500,000.00
1,500,000.00
1,500,000.00
1,000,000.00
1,500,000.00
1,390,140.00
1,386,150.00
1,373,970.00
994,880.00

0.375

0.500

0.625

4.250

2.500

0.731

0.819

0.888

4.142

4.636

0.742 12/31/2025

0.831 02/28/2026

0.901 07/31/2026

4.199 09/30/2024

4.700 05/31/2024
730
789
942
273
1511,483,245.00
Subtotal and Average 6,955,619.75 7,000,000.00 6,628,385.00 2.109 2.139 598 Municipal Bonds
010878AS5
010878BK1
010831DS1
010831DT9
2173 MUN
2691 MUN
2005 MUN
2566 MUN
County of Alameda 12/05/2019
09/21/2022
12/24/2018
08/13/2021
302,708.32
1,439,948.56
505,928.16
116,361.37
290,000.00
1,500,000.00
505,000.00
110,000.00
286,894.10
1,431,720.00
494,940.40
107,123.50

4.000

3.699

3.365

3.395

2.139

4.281

3.175

0.925

2.168 08/01/2026

4.340 08/01/2031

3.220 06/01/2025

0.938 06/01/2026
943
2,769
517
County of Alameda
Alameda County Joint Pws Auth.

Alameda County Joint Pws Auth. 882
Portfolio CPA
AP
Run Date: 01/21/2024 - 18:49 FI (PRF_FI) 7.3.11
Report Ver. 7.3.11
Item 14
Attachment B - Investment Portfolio

Item 14: Staff Report
Pg.
22 Packet Pg. 395 of 428

Fund ALL - Portfolio Listings
Investments by Fund
December 31, 2023

Purchase Current
Rate
Maturity Days To
Date Maturity
YTM
360
YTM
365Par Value Market ValueCUSIP Investment # Issuer Date Book Value Municipal Bonds
010411CT1
03667PFN7
03667PHJ4
03667PHL9
072024XC1
084154G49
088006KA8
088006KB6
088023PL4
121457EQ4
119174AJ9
12082SDN1
127109QD1
142665DJ4
13034AL73
13034AL99
13067WRC8
13067WRD6
15722TJR3
15722TJQ5
15722TJS1
15722TJQ5
157432KL8
17131RAU0
13124MCE3
13124MCB9
13124MCB9
134159A77
21969AAJ1
212204JJ1
212204JK8
2835 MUN
2069 MUN
2694 MUN
2784 MUN
2558 MUN
2817 MUN
2612 MUN
2680 MUN
2682 MUN
1548 MUN
2734 MUN
2570 MUN
2119 MUN
1857 MUN
2666 MUN
2893 MUN
2633 MUN
2645 MUN
2564 MUN
2589 MUN
2830 MUN
2842 MUN
2698 MUN
2653 MUN
2544 MUN
2646 MUN
2791 MUN
2753 MUN
2601 MUN
2103 MUN
2120 MUN
State of Alabama 02/15/2023
08/16/2019
09/23/2022
01/05/2023
07/26/2021
01/26/2023
11/15/2021
04/01/2022
04/13/2022
02/24/2016
11/18/2022
08/30/2021
10/08/2019
09/27/2017
02/16/2022
05/08/2023
12/13/2021
12/23/2021
08/16/2021
09/29/2021
02/13/2023
03/07/2023
10/06/2022
01/10/2022
07/01/2021
12/27/2021
01/09/2023
12/07/2022
10/14/2021
09/12/2019
09/20/2019
980,477.99
503,112.94
936,391.20
546,318.01
1,762,702.82
207,535.81
349,564.47
466,442.85
920,431.12
248,406.93
565,965.83
1,010,239.98
2,000,000.00
321,190.50
203,344.70
450,697.79
178,223.97
295,538.98
286,220.57
124,941.23
184,710.70
941,324.31
257,700.59
980,052.18
561,956.31
597,772.17
156,058.91
421,673.81
504,645.95
401,877.46
976,539.74
1,000,000.00
500,000.00
1,080,000.00
675,000.00
1,750,000.00
250,000.00
350,000.00
490,000.00
920,000.00
240,000.00
685,000.00
1,000,000.00
2,000,000.00
305,000.00
210,000.00
500,000.00
180,000.00
300,000.00
285,000.00
125,000.00
205,000.00
1,000,000.00
300,000.00
1,000,000.00
550,000.00
600,000.00
170,000.00
500,000.00
500,000.00
400,000.00
990,000.00
975,450.00
494,435.00
934,070.40
558,920.25
1,620,727.50
207,642.50
320,827.50
438,329.50
880,679.20
243,763.20
568,234.90
924,010.00
1,868,440.00
310,581.50
191,280.60
437,775.00
167,428.80
271,251.00
260,398.80
117,408.75
183,196.20
939,270.00
265,137.00
908,690.00
483,477.50
552,498.00
156,541.10
429,385.00
429,040.00
366,180.00
889,970.40

3.450

3.026

1.661

1.861

1.079

1.856

1.147

1.327

2.700

6.238

1.882

1.367

2.385

5.234

1.035

1.466

0.790

0.920

1.080

0.880

1.287

0.880

2.329

0.840

1.865

1.097

1.097

1.472

2.242

2.213

2.263

4.142

1.876

4.389

4.911

0.739

4.524

1.183

2.810

2.644

3.557

5.076

0.947

2.342

2.850

2.224

3.728

1.301

1.430

0.897

0.897

4.296

4.783

4.931

1.676

1.425

1.233

4.625

4.714

2.052

2.071

2.505

4.200 11/01/2026

1.902 08/01/2024

4.450 08/01/2029

4.980 08/01/2031

0.750 04/01/2026

4.586 08/01/2031

1.200 06/01/2026

2.850 06/01/2027

2.681 08/01/2026

3.606 08/01/2025

5.147 07/01/2030

0.960 08/01/2026

2.375 08/01/2027

2.890 08/01/2026

2.254 10/01/2026

3.780 10/01/2028

1.320 12/01/2025

1.450 12/01/2026

0.910 08/01/2026

0.910 08/01/2025

4.356 08/01/2027

4.850 08/01/2025

5.000 06/01/2030

1.700 06/01/2026

1.445 07/01/2029

1.250 07/01/2026

4.690 07/01/2026

4.780 08/01/2029

2.081 05/01/2030

2.100 08/01/2028

2.539 08/01/2029
1,035
213Antelope Valley Community Coll
Antelope Valley Community Coll
Antelope Valley Community Coll
Bay Area Toll Authority
2,039
2,769
821
Berkeley Unified School Dist.

Beverly Hills Public Fing Auth
Beverly Hills Public Fing Auth
Beverly Hills Unified Sch Dist
Burlingame School District
City of Buena Park
2,769
882
1,247
943
578
2,373
943Burbank Unified School Distri.

Cabrillo Community College Dis
Carlsbad Unified School Dist .

CA Infrastructure -Econ Dev Bk
CA Infrastructure -Econ Dev Bk
CA ST Dept of WTR Resources
CA ST Dept of WTR Resources
Chabot-Las Positas CCD
1,308
943
1,004
1,735
700
1,065
943
Chabot-Las Positas CCD 578
Chabot-Las Positas CCD 1,308
578Chabot-Las Positas CCD
Chaffey Community Clg District
City of Chula Vista
2,343
882
Calleguas Municipal Water Dist
Calleguas Municipal Water Dist
Calleguas Municipal Water Dist
Campbell Union High Sch Dist
City of Corona
2,008
912
912
2,039
2,312
1,674
2,039
Contra Costa Community College
Contra Costa Community College
Portfolio CPA
AP
Run Date: 01/21/2024 - 18:49 FI (PRF_FI) 7.3.11
Report Ver. 7.3.11
Item 14
Attachment B - Investment Portfolio

Item 14: Staff Report
Pg.
23 Packet Pg. 396 of 428

Fund ALL - Portfolio Listings
Investments by Fund
December 31, 2023

Purchase Current
Rate
Maturity Days To
Date Maturity
YTM
360
YTM
365Par Value Market ValueCUSIP Investment # Issuer Date Book Value Municipal Bonds
212204JK8
212204JF9
212204LM1
250375JX1
250375LA8
250433UA5
284035AK8
3133EPAF2
357172VA0
357172C52
345102PF8
345102PG6
359819DN6
359819DM8
359819DN6
3733844V5
373384RX6
373384RY4
373384RY4
373385BU6
373384RY4
373384RW8
378612AL9
378612AL9
378612AJ4
378460A74
378460C64
419792DA1
419791YS1
419791YT9
419792F92
2244 MUN
2291 MUN
2555 MUN
2611 MUN
2738 MUN
2635 MUN
2696 MUN
2829
Contra Costa Community College
Contra Costa Community College
Contra Costa Community College
Desert Community Clg Dist
Desert Community Clg Dist
Desert Sands Unif Sch District
City of El Segundo
02/07/2020
03/09/2020
08/02/2021
11/12/2021
11/23/2022
12/16/2021
09/29/2022
02/10/2023
06/28/2016
10/01/2021
10/06/2022
01/27/2023
02/14/2018
02/14/2018
08/29/2019
07/29/2016
04/10/2017
01/26/2018
03/19/2018
10/31/2018
01/31/2020
03/23/2020
09/16/2019
10/02/2019
09/29/2021
11/25/2022
12/22/2023
10/19/2016
10/25/2018
12/06/2018
01/30/2023
1,510,032.34
323,793.58
1,013,275.38
197,733.26
187,150.44
892,538.97
771,908.65
499,925.07
527,693.31
237,734.74
1,204,548.58
513,302.44
997,019.55
750,420.02
375,714.74
1,831,785.10
254,737.91
1,128,924.72
205,050.91
343,099.87
451,758.56
1,013,610.49
1,340,443.22
400,636.20
1,397,647.03
471,823.27
887,223.03
1,062,349.36
254,401.76
829,116.89
666,707.19
1,500,000.00
320,000.00
1,000,000.00
200,000.00
200,000.00
880,000.00
935,000.00
500,000.00
500,000.00
235,000.00
1,230,000.00
540,000.00
995,000.00
750,000.00
365,000.00
1,825,000.00
250,000.00
1,095,000.00
200,000.00
350,000.00
425,000.00
1,000,000.00
1,345,000.00
400,000.00
1,365,000.00
535,000.00
1,095,000.00
1,045,000.00
250,000.00
800,000.00
700,000.00
1,348,440.00
306,713.60
924,690.00
178,752.00
190,748.00
826,152.80
791,916.95
499,590.00
509,130.00
198,311.80
1,200,726.00
509,754.60
962,324.20
730,402.50
353,013.40
1,780,543.00
247,557.50
1,093,959.75
199,810.00
335,629.00
424,596.25
990,810.00
1,227,917.75
365,180.00
1,286,662.65
477,257.45
881,113.65
1,011,925.75
250,492.50
810,192.00
661,724.00

2.263

1.918

1.300

1.169

3.000

1.982

2.267

4.750

6.080

2.020

0.575

0.906

3.160

3.040

3.160

2.375

4.000

4.310

4.310

2.720

4.310

3.820

2.265

2.265

2.108

1.113

1.830

3.150

5.230

5.330

1.033

2.100

1.128

0.764

1.479

4.965

1.390

5.118

4.833

2.994

1.825

4.241

4.172

3.028

2.959

1.913

1.972

2.739

2.979

3.204

3.412

1.837

1.889

2.318

2.194

1.075

4.686

4.438

2.431

3.363

3.304

4.172

2.130 08/01/2029

1.143 08/01/2025

0.775 08/01/2026

1.500 08/01/2027

5.034 08/01/2027

1.410 08/01/2026

5.190 07/01/2031

4.900 02/08/2024

3.035 02/01/2026

1.851 08/01/2031

4.300 08/01/2024

4.230 08/01/2025

3.070 08/01/2026

3.000 08/01/2025

1.940 08/01/2026

1.999 02/01/2025

2.777 10/01/2025

3.020 10/01/2026

3.248 10/01/2026

3.460 02/01/2027

1.863 10/01/2026

1.915 10/01/2024

2.350 06/01/2028

2.225 06/01/2028

1.090 06/01/2026

4.751 09/01/2027

4.499 09/01/2032

2.465 10/01/2026

3.410 02/01/2025

3.350 02/01/2026

4.230 08/01/2025
2,039
578
943
1,308
1,308
943
2,738
38Federal Farm Credit Bank .

Fremon Union High School Distr
Fremon Union High School Distr
Foothill-De Anza Comm Clg Dist
Foothill-De Anza Comm Clg Dist
Fullerton School District
Fullerton School District
Fullerton School District
State of Georgia
1646 MUN
2595 MUN
2699 MUN
2818 MUN
1916 MUN
1917 MUN
2085 MUN
1666 MUN
1775 MUN
1919 MUN
1945 MUN
1967 MUN
2229 MUN
2332 MUN
2109 MUN
2137 MUN
2590 MUN
2739 MUN
2916 MUN
1685 MUN
1961 MUN
1995 MUN
2820 MUN
762
2,769
213
578
943
578
943
397
State of Georgia 639
State of Georgia 1,004
1,004
1,127
1,004
274
State of Georgia
State of Georgia
State of Georgia
State of Georgia
City of Glendora 1,613
1,613
882
City of Glendora
City of Glendora
Glendale Unified School Dist.

Glendale Unified School Dist.

State of Hawaii
1,339
3,166
1,004
397State of Hawaii
State of Hawaii 762
State of Hawaii 578
Portfolio CPA
AP
Run Date: 01/21/2024 - 18:49 FI (PRF_FI) 7.3.11
Report Ver. 7.3.11
Item 14
Attachment B - Investment Portfolio

Item 14: Staff Report
Pg.
24 Packet Pg. 397 of 428

Fund ALL - Portfolio Listings
Investments by Fund
December 31, 2023

Purchase Current
Rate
Maturity Days To
Date Maturity
YTM
360
YTM
365Par Value Market ValueCUSIP Investment # Issuer Date Book Value Municipal Bonds
446201AE5
446201AE5
446216HN6
446201AE5
530319SP8
503433AK0
544290JH3
544351NP0
544351MS5
544351NQ8
544351LQ0
544351KV0
544351QX0
544351MR7
544351KT5
54438CYN6
54438CYL0
54438CYL0
54438CYL0
54438CMS8
5447122K7
544495VX9
544495VX9
57582PUT5
57582PUT5
57582PUS7
5741926N5
5741926N5
601670ML3
562784AM0
586840ND8
2560 MUN
2562 MUN
2790 MUN
2840 MUN
2768 MUN
2660 MUN
2681 MUN
1969 MUN
2008 MUN
2200 MUN
2213 MUN
2283 MUN
2692 MUN
2783 MUN
2800 MUN
2487 MUN
2592 MUN
2614 MUN
2642 MUN
2871 MUN
2641 MUN
1949 MUN
1965 MUN
2227 MUN
2543 MUN
2684 MUN
2184 MUN
2581 MUN
2746 MUN
2647 MUN
2104 MUN
City of Huntington Beach
City of Huntington Beach
City of Huntington Beach
City of Huntington Beach
Liberty Union High Sch Distr
City of La Habra
08/12/2021
08/13/2021
01/09/2023
03/03/2023
12/15/2022
02/07/2022
03/24/2022
11/02/2018
01/07/2019
01/06/2020
01/22/2020
03/05/2020
09/28/2022
12/23/2022
01/17/2023
01/28/2021
09/30/2021
11/15/2021
12/21/2021
04/10/2023
12/21/2021
03/29/2018
10/29/2018
01/30/2020
07/01/2021
04/05/2022
12/16/2019
09/23/2021
12/02/2022
01/05/2022
10/08/2019
1,010,107.93
1,009,672.24
685,875.87
159,166.15
462,448.54
499,920.04
494,369.29
293,090.23
1,008,941.18
868,172.78
1,014,841.83
1,040,680.82
999,563.39
293,772.52
307,013.81
1,021,692.78
250,596.94
1,497,137.62
274,132.61
1,136,327.74
1,055,826.14
1,599,514.29
448,600.08
280,337.56
1,170,968.51
1,053,704.27
516,565.19
258,943.87
544,621.15
657,652.50
1,000,000.00
1,000,000.00
1,000,000.00
805,000.00
175,000.00
530,000.00
500,000.00
500,000.00
295,000.00
1,000,000.00
840,000.00
985,000.00
1,000,000.00
1,000,000.00
300,000.00
310,000.00
1,000,000.00
250,000.00
1,500,000.00
275,000.00
1,000,000.00
1,000,000.00
1,500,000.00
425,000.00
250,000.00
1,000,000.00
1,000,000.00
500,000.00
245,000.00
630,000.00
650,000.00
1,000,000.00
921,130.00
921,130.00
700,688.10
161,197.75
467,242.70
433,340.00
485,590.00
286,138.20
974,920.00
812,330.40
917,714.65
966,240.00
983,120.00
293,847.00
305,195.00
855,640.00
229,667.50
1,378,005.00
252,634.25
1,126,960.00
1,003,860.00
1,546,320.00
438,124.00
253,665.00
1,014,660.00
1,005,200.00
497,680.00
243,863.20
555,754.50
548,561.00
932,980.00

1.344

1.344

1.731

1.344

1.484

2.673

1.000

3.300

3.500

3.400

3.050

3.150

4.400

3.450

2.840

1.806

1.174

1.174

1.174

7.530

5.130

5.516

5.516

4.910

4.910

4.760

4.350

4.350

1.451

2.341

2.214

0.909

0.927

4.931

5.340

4.614

2.638

2.522

3.530

3.077

2.360

2.413

1.519

4.346

4.724

4.290

1.432

1.064

1.233

1.282

4.615

1.085

3.254

3.600

2.331

1.484

2.968

2.089

0.690

4.802

2.129

2.183

0.921 06/15/2026

0.939 06/15/2026

5.000 05/01/2029

5.414 06/15/2026

4.678 08/01/2028

2.675 08/01/2031

2.557 10/01/2024

3.579 09/01/2026

3.119 09/01/2026

2.393 09/01/2027

2.446 09/01/2029

1.541 09/01/2026

4.406 09/01/2032

4.790 09/01/2025

4.350 09/01/2024

1.452 08/01/2030

1.078 08/01/2026

1.250 08/01/2026

1.300 08/01/2026

4.680 08/01/2029

1.100 06/01/2025

3.300 07/01/2027

3.650 07/01/2027

2.363 05/01/2029

1.505 05/01/2029

3.010 05/01/2027

2.118 08/01/2025

0.700 08/01/2025

4.869 08/01/2028

2.159 01/01/2032

2.214 07/01/2027
896
896
1,947
896
1,674
2,769
274Los Altos Elementary Sch Distr
City of Los Angeles 974
City of Los Angeles 974
City of Los Angeles 1,339
2,070
974
City of Los Angeles
City of Los Angeles
City of Los Angeles 3,166
609City of Los Angeles
City of Los Angeles 244
Los Angeles Community College
Los Angeles Community College
Los Angeles Community College
Los Angeles Community College
Los Angeles Community College
Los Angeles Cnty Met Tran Auth
Los Angeles Dept. of WTR & PWR
Los Angeles Dept. of WTR & PWR
State of Massachusetts
State of Massachusetts
State of Massachusetts
State of Maryland
2,404
943
943
943
2,039
517
1,277
1,277
1,947
1,947
1,216
578
State of Maryland 578
Milpitas Unified School Distr
City of Manhattan Beach
Menlo Park City School Dist.
1,674
2,922
1,277
Portfolio CPA
AP
Run Date: 01/21/2024 - 18:49 FI (PRF_FI) 7.3.11
Report Ver. 7.3.11
Item 14
Attachment B - Investment Portfolio

Item 14: Staff Report
Pg.
25 Packet Pg. 398 of 428

Fund ALL - Portfolio Listings
Investments by Fund
December 31, 2023

Purchase Current
Rate
Maturity Days To
Date Maturity
YTM
360
YTM
365Par Value Market ValueCUSIP Investment # Issuer Date Book Value Municipal Bonds
62451FJE1
56781RGU5
56781RGT8
56781RJL2
56781RJJ7
56781RKH9
56781RKH9
56781RKU0
56781RKD8
623040KQ4
623040KX9
605581LM7
605581LM7
605581HL4
605581HL4
6055805W5
6055805V7
605581QR1
605581LL9
630337AL7
64985HWS2
6500357D4
650036AV8
649791PQ7
649791PS3
649791PR5
649791PS3
649791PS3
672240WY0
672240WY0
672240WY0
2708 MUN
1858 MUN
1973 MUN
2084 MUN
2287 MUN
2495 MUN
2499 MUN
2568 MUN
2588 MUN
2208 MUN
2661 MUN
1968 MUN
1972 MUN
2087 MUN
2090 MUN
2096 MUN
2189 MUN
2626 MUN
2629 MUN
2055 MUN
2007 MUN
2097 MUN
2683 MUN
2146 MUN
2224 MUN
2575 MUN
2677 MUN
2678 MUN
2293 MUN
2307 MUN
2313 MUN
Mtn. View-Whisman School Dist.

Marin Community College Dist.

Marin Community College Dist.

Marin Community College Dist.

Marin Community College Dist.

Marin Community College Dist.

Marin Community College Dist.

Marin Community College Dist.

Marin Community College Dist.

Mt. San Antonio Community Coll
Mt. San Antonio Community Coll
State of Mississippi
10/19/2022
09/28/2017
11/05/2018
08/29/2019
03/06/2020
02/25/2021
02/25/2021
09/14/2021
09/29/2021
02/04/2020
02/07/2022
11/07/2018
11/07/2018
08/30/2019
09/04/2019
09/09/2019
12/19/2019
12/09/2021
12/06/2021
08/08/2019
01/04/2019
09/09/2019
03/28/2022
10/31/2019
01/30/2020
09/13/2021
03/16/2022
03/21/2022
03/09/2020
03/13/2020
03/16/2020
1,061,992.10
506,865.07
119,114.33
261,839.32
327,953.45
1,000,000.00
708,265.77
1,000,000.00
282,413.40
230,000.00
805,907.22
1,512,025.99
503,698.12
757,953.77
505,132.75
157,164.07
254,733.30
1,006,777.52
261,413.77
595,670.40
448,263.65
713,925.80
960,756.25
1,500,467.62
586,732.65
1,545,408.09
1,000,050.83
998,814.83
1,554,920.17
1,537,369.84
1,070,108.08
1,135,000.00
500,000.00
120,000.00
250,000.00
310,000.00
1,000,000.00
710,000.00
1,000,000.00
285,000.00
230,000.00
785,000.00
1,500,000.00
500,000.00
750,000.00
500,000.00
150,000.00
250,000.00
1,000,000.00
250,000.00
595,000.00
450,000.00
700,000.00
1,000,000.00
1,500,000.00
580,000.00
1,500,000.00
1,000,000.00
1,000,000.00
1,500,000.00
1,500,000.00
1,080,000.00
1,065,367.75
484,055.00
116,520.00
242,505.00
311,726.70
836,060.00
593,602.60
916,020.00
259,595.10
209,679.50
705,424.55
1,476,225.00
492,075.00
737,872.50
491,915.00
150,454.50
249,365.00
849,420.00
246,270.00
585,355.05
443,245.50
675,780.00
907,330.00
1,455,975.00
546,847.20
1,432,860.00
942,840.00
942,840.00
1,319,430.00
1,319,430.00
949,989.60

1.893

3.272

3.172

3.330

5.000

1.451

1.451

0.893

0.679

2.569

2.649

3.751

3.751

2.987

2.987

4.681

4.511

2.117

3.646

2.200

2.120

3.070

1.496

2.120

2.360

2.260

2.360

2.360

2.110

2.110

2.110

4.487

2.791

3.452

1.874

1.193

1.431

1.470

0.880

1.025

2.533

2.173

3.377

3.401

1.745

1.783

1.888

2.079

1.992

1.080

1.968

2.860

2.071

2.777

2.063

1.933

0.794

2.325

2.367

1.436

1.638

2.247

4.550 09/01/2026

2.830 08/01/2027

3.500 08/01/2026

1.900 08/01/2027

1.210 08/01/2025

1.451 08/01/2030

1.490 08/01/2030

0.893 08/01/2026

1.040 08/01/2026

2.569 08/01/2029

2.203 08/01/2030

3.424 11/01/2026

3.449 11/01/2026

1.770 12/01/2024

1.807 12/01/2024

1.914 11/01/2025

2.108 11/01/2024

2.020 10/01/2031

1.095 11/01/2025

1.996 08/01/2024

2.900 07/15/2024

2.100 03/15/2026

2.816 03/15/2027

2.091 02/15/2025

1.960 02/15/2027

0.805 02/15/2026

2.358 02/15/2027

2.400 02/15/2027

1.456 01/15/2030

1.661 01/15/2030

2.279 01/15/2030
974
1,308
943
1,308
578
2,404
2,404
943
943
2,039
2,404
1,035
1,035
335
State of Mississippi
State of Mississippi
State of Mississippi 335
State of Mississippi 670
State of Mississippi 305
State of Mississippi 2,830
670State of Mississippi
City of Napa Solid Waste
New York St Envrnmntl Facs
New York State Urban Dev Corp.

New York State Urban Dev Corp.

New York State Envrnmntl Corp
New York State Envrnmntl Corp
New York State Envrnmntl Corp
New York State Envrnmntl Corp
New York State Envrnmntl Corp
City of Oakland
213
196
804
1,169
411
1,141
776
1,141
1,141
2,206
2,206
2,206
City of Oakland
City of Oakland
Portfolio CPA
AP
Run Date: 01/21/2024 - 18:49 FI (PRF_FI) 7.3.11
Report Ver. 7.3.11
Item 14
Attachment B - Investment Portfolio

Item 14: Staff Report
Pg.
26 Packet Pg. 399 of 428

Fund ALL - Portfolio Listings
Investments by Fund
December 31, 2023

Purchase Current
Rate
Maturity Days To
Date Maturity
YTM
360
YTM
365Par Value Market ValueCUSIP Investment # Issuer Date Book Value Municipal Bonds
672240WX2
672240ZA9
672319CF5
677765GY9
677765GY9
677765HA0
677765GZ6
6775207G7
677521CT1
683050BW7
68442CCY0
685585FD8
68607LXQ5
68607LXQ5
68609TDT2
68607LXQ5
68607LXQ5
68609BXT9
68609TVS4
68608KA24
68609TU30
68609TT81
68609TZT8
68609T3M8
68607LXQ5
692039QX1
69511AAS3
69511AAT1
70227RBM1
702274CS8
697379TV7
2316 MUN
2919 MUN
2630 MUN
2165 MUN
2175 MUN
2179 MUN
2341 MUN
1832 MUN
2308 MUN
2847 MUN
2578 MUN
1910 MUN
1974 MUN
2015 MUN
2223 MUN
2230 MUN
2266 MUN
2310 MUN
2378 MUN
2542 MUN
2549 MUN
2584 MUN
2624 MUN
2627 MUN
2679 MUN
2859 MUN
2138 MUN
2139 MUN
2573 MUN
2615 MUN
2838 MUN
City of Oakland 03/16/2020
12/26/2023
12/06/2021
11/22/2019
12/06/2019
12/11/2019
05/08/2020
06/30/2017
03/13/2020
03/17/2023
09/16/2021
01/25/2018
11/06/2018
01/16/2019
01/30/2020
01/31/2020
02/24/2020
03/13/2020
07/02/2020
07/01/2021
07/08/2021
09/24/2021
11/19/2021
11/26/2021
04/01/2022
03/23/2023
10/23/2019
10/23/2019
09/09/2021
12/01/2021
02/17/2023
1,492,296.63
1,459,891.99
476,253.95
598,697.42
278,875.10
966,235.45
1,205,621.52
905,197.19
544,305.15
557,782.29
322,018.94
164,368.38
529,075.00
475,030.73
572,853.95
545,045.62
1,104,749.75
369,500.81
359,632.17
1,045,458.86
1,242,955.19
265,424.73
247,963.56
899,233.28
1,080,631.13
451,563.30
1,015,782.37
580,190.98
122,923.32
582,423.42
1,551,404.64
1,500,000.00
1,350,000.00
450,000.00
600,000.00
280,000.00
970,000.00
1,185,000.00
900,000.00
500,000.00
600,000.00
315,000.00
165,000.00
500,000.00
445,000.00
570,000.00
495,000.00
1,000,000.00
350,000.00
355,000.00
870,000.00
1,225,000.00
265,000.00
250,000.00
900,000.00
1,000,000.00
500,000.00
1,015,000.00
580,000.00
120,000.00
550,000.00
1,500,000.00
1,348,050.00
1,455,070.50
449,860.50
555,744.00
259,347.20
866,578.60
1,079,167.65
900,090.00
510,945.00
555,456.00
302,538.60
160,832.10
511,665.00
455,381.85
566,927.70
506,548.35
1,023,330.00
337,004.50
302,286.05
908,280.00
1,086,060.50
249,669.75
229,440.00
754,398.00
1,023,330.00
452,805.00
981,139.60
552,699.40
112,599.60
535,617.50
1,544,385.00

2.070

5.650

4.676

2.237

2.237

2.337

2.287

4.971

5.262

1.440

2.095

3.125

5.892

5.892

3.227

5.892

5.892

3.080

1.672

5.332

1.484

0.803

0.984

2.037

5.892

1.512

2.563

2.663

1.984

3.500

5.862

2.151

4.523

1.562

2.271

2.327

2.382

1.849

2.416

1.710

4.339

0.690

3.208

3.516

3.537

1.641

2.583

2.482

1.302

1.433

1.943

1.134

0.690

1.292

2.020

3.259

4.458

2.469

2.611

0.903

1.380

4.698

2.181 01/15/2029

4.586 07/15/2033

1.584 12/15/2025

2.303 08/01/2027

2.360 08/01/2027

2.415 08/01/2029

1.875 08/01/2028

2.450 04/01/2024

1.734 09/01/2026

4.400 08/01/2026

0.700 08/15/2025

3.253 08/01/2027

3.565 06/01/2027

3.587 06/01/2027

1.664 05/01/2024

2.619 06/01/2027

2.517 06/01/2027

1.320 05/01/2027

1.452 06/01/2030

1.970 08/01/2030

1.150 08/01/2028

0.700 08/01/2025

1.310 08/01/2026

2.048 11/01/2031

3.304 06/01/2027

4.520 08/01/2027

2.503 06/01/2025

2.647 06/01/2026

0.915 05/01/2026

1.400 12/01/2026

4.764 07/01/2027
1,841
3,483
714
City of Oakland
City of Oakland Pension
Ohlone Community College Distr
Ohlone Community College Distr
Ohlone Community College Distr
Ohlone Community College Distr
State of Ohio
1,308
1,308
2,039
1,674
91 State of Ohio 974
City of Ontario (Pub Fin Auth)
Orange Cnty Water District
Orchard School District
State of Oregon
943
592
1,308
1,247
1,247
121
State of Oregon
State of Oregon
State of Oregon 1,247
1,247
1,216
2,343
2,404
1,674
578
State of Oregon
State of Oregon
State of Oregon
State of Oregon
State of Oregon
State of Oregon
State of Oregon 943
State of Oregon 2,861
1,247
1,308
517
State of Oregon
Oxnard Union High School Distr
City of Pacifica
City of Pacifica 882
Pasadena CA Public Finance Aut
Pasadena CA Public Finance Aut
Palo Alto Unified School Dist.
851
1,065
1,277
Portfolio CPA
AP
Run Date: 01/21/2024 - 18:49 FI (PRF_FI) 7.3.11
Report Ver. 7.3.11
Item 14
Attachment B - Investment Portfolio

Item 14: Staff Report
Pg.
27 Packet Pg. 400 of 428

Fund ALL - Portfolio Listings
Investments by Fund
December 31, 2023

Purchase Current
Rate
Maturity Days To
Date Maturity
YTM
360
YTM
365Par Value Market ValueCUSIP Investment # Issuer Date Book Value Municipal Bonds
697379TV7
697379TV7
697511FU2
697511FD0
752111HE7
757710UE6
757710UE6
76222RYN6
76222RXB3
76222RXB3
76886PJP9
76886PJS3
752147HH4
752147HK7
757889EH9
757889EG1
801139AE6
801139AF3
801315KU5
796720NC0
796720NV8
801546PJ5
801686TF3
80168ACV7
80168FPC4
80181PCT2
80181PCU9
80181PCV7
80181PCW5
801747AF3
797356DL3
2839 MUN
2841 MUN
2582 MUN
2676 MUN
2889 MUN
2388 MUN
2763 MUN
2192 MUN
2219 MUN
2239 MUN
2596 MUN
2733 MUN
2522 MUN
2805 MUN
2130 MUN
2253 MUN
2603 MUN
2747 MUN
2385 MUN
2166 MUN
2365 MUN
1899 MUN
2557 MUN
2181 MUN
2793 MUN
1906 MUN
1907 MUN
1908 MUN
1909 MUN
2671 MUN
2602 MUN
Palo Alto Unified School Dist.

Palo Alto Unified School Dist.

Polomar Community Clge Distri
Polomar Community Clge Distri
Rancho Water Dist. Fin. Auth.

Redondo Beach Unified School D
Redondo Beach Unified School D
State of Rhode Island
02/21/2023
03/06/2023
10/13/2021
03/15/2022
05/03/2023
08/06/2020
12/14/2022
12/20/2019
01/27/2020
02/06/2020
10/04/2021
11/17/2022
03/29/2021
01/19/2023
10/16/2019
02/13/2020
10/18/2021
12/02/2022
07/21/2020
12/12/2019
07/07/2020
01/12/2018
08/02/2021
12/12/2019
01/12/2023
01/25/2018
01/25/2018
01/25/2018
01/25/2018
03/03/2022
10/21/2021
1,552,161.59
1,519,142.81
1,000,000.00
325,823.51
626,171.78
759,216.30
590,724.78
259,884.38
1,566,620.48
576,414.79
1,368,566.45
473,313.88
450,000.00
584,200.00
1,000,000.00
1,105,861.53
174,719.46
1,101,292.73
493,785.05
1,500,000.00
2,000,000.00
1,460,000.00
1,262,523.21
1,554,002.59
845,953.67
464,106.00
463,238.85
468,507.77
277,948.54
1,013,880.08
1,009,152.15
1,500,000.00
1,480,000.00
1,000,000.00
335,000.00
600,000.00
750,000.00
715,000.00
260,000.00
1,500,000.00
550,000.00
1,365,000.00
560,000.00
450,000.00
635,000.00
1,000,000.00
1,095,000.00
175,000.00
1,250,000.00
490,000.00
1,500,000.00
2,000,000.00
1,460,000.00
1,250,000.00
1,555,000.00
1,000,000.00
465,000.00
465,000.00
470,000.00
280,000.00
1,000,000.00
1,000,000.00
1,544,385.00
1,523,793.20
918,200.00
308,953.75
611,760.00
626,325.00
597,096.50
252,457.40
1,448,730.00
531,201.00
1,254,216.60
487,732.00
437,373.00
579,005.70
932,490.00
1,033,931.85
159,502.00
1,116,662.50
424,707.50
1,384,650.00
1,739,020.00
1,441,720.80
1,148,362.50
1,438,888.15
840,360.00
460,205.85
451,575.45
453,000.10
267,198.40
930,720.00
840,610.00

5.862

5.862

1.031

1.199

5.125

1.660

1.660

2.000

3.250

3.250

1.124

1.785

0.634

0.956

2.284

2.159

1.176

1.465

1.653

2.590

1.848

2.680

1.146

2.434

1.634

2.500

2.750

3.000

3.000

2.470

1.984

4.683

4.941

1.016

2.288

4.284

1.439

4.783

2.231

2.077

1.990

1.006

5.022

0.625

4.164

2.252

1.727

1.223

5.178

1.483

2.554

1.822

2.643

0.742

2.416

4.418

2.968

3.008

3.107

3.205

2.030

1.824

4.748 07/01/2027

5.010 07/01/2027

1.031 08/01/2026

2.320 08/01/2026

4.344 08/01/2030

1.459 08/01/2030

4.850 08/01/2030

2.262 01/15/2025

2.106 04/01/2028

2.018 04/01/2028

1.020 08/01/2026

5.092 08/01/2029

0.633 09/01/2024

4.222 09/01/2026

2.284 08/01/2027

1.751 08/01/2026

1.240 08/01/2026

5.250 08/01/2027

1.504 08/01/2029

2.590 08/01/2028

1.848 08/01/2029

2.680 08/01/2024

0.752 08/01/2026

2.450 06/01/2028

4.480 06/01/2030

3.010 06/01/2024

3.050 06/01/2025

3.150 06/01/2026

3.250 06/01/2027

2.058 08/01/2027

1.850 07/01/2031
1,277
1,277
943
943
2,404
2,404
2,404
380
State of Rhode Island 1,552
1,552
943
State of Rhode Island
Riverside Cmnty College Distt.

Riverside Cmnty College Distt.

Rancho Santiago Comm College D
Rancho Santiago Comm College D
Redwood City School District
Redwood City School District
City of Santa Ana
2,039
244
974
1,308
943
943
City of Santa Ana 1,308
2,039
1,674
2,039
213
Santa Barbara Unified School D
San Bernardino Cmty College Di
San Bernardino Cmty College Di
County of Santa Clara
Santa Clarita Community Colleg
Santa Clara Valley Water Dist.

Santa Clara Valley Water Dist.

Santa Cruz County Capital Fin.

Santa Cruz County Capital Fin.

Santa Cruz County Capital Fin.

Santa Cruz County Capital Fin.

Santa Cruz MET Transit Dist.

San Diego Unified Sch District
943
1,613
2,343
152
517
882
1,247
1,308
2,738
Portfolio CPA
AP
Run Date: 01/21/2024 - 18:49 FI (PRF_FI) 7.3.11
Report Ver. 7.3.11
Item 14
Attachment B - Investment Portfolio

Item 14: Staff Report
Pg.
28 Packet Pg. 401 of 428

Fund ALL - Portfolio Listings
Investments by Fund
December 31, 2023

Purchase Current
Rate
Maturity Days To
Date Maturity
YTM
360
YTM
365Par Value Market ValueCUSIP Investment # Issuer Date Book Value Municipal Bonds
797356DL3
797356DH2
797356DF6
797356DH2
797272QS3
797272RN3
797272RT0
797400MR6
797412DN0
797412DM2
797412DN0
797412DN0
797412DQ3
797412DR1
797508JW9
797508JX7
797508HF8
817409N35
817409N76
797646NC6
797646T48
797646T55
797646T48
797646ND4
7976466C5
7976466F8
79773KKQ6
79773KKT0
79773KDG6
79773KKX1
79765D5Y2
2606 MUN
2617 MUN
2693 MUN
2767 MUN
2550 MUN
2639 MUN
2651 MUN
2632 MUN
2580 MUN
2600 MUN
2604 MUN
2623 MUN
2688 MUN
2716 MUN
2536 MUN
2537 MUN
2674 MUN
2320 MUN
2531 MUN
1509 MUN
1711 MUN
1712 MUN
1839 MUN
2014 MUN
2148 MUN
2762 MUN
2864 MUN
2883 MUN
2910 MUN
2913 MUN
2911 MUN
San Diego Unified Sch District
San Diego Unified Sch District
San Diego Unified Sch District
San Diego Unified Sch District
San Diego Community College Di
San Diego Community College Di
San Diego Community College Di
San Diego Regl Trans Commissio
San Diego Cnty Wtr Authority
San Diego Cnty Wtr Authority
San Diego Cnty Wtr Authority
San Diego Cnty Wtr Authority
San Diego Cnty Wtr Authority
San Diego Cnty Wtr Authority
San Dieguito Union High Sch Di
San Dieguito Union High Sch Di
San Dieguito Union High Sch Di
Sequoia Union High School Dist
Sequoia Union High School Dist
City & County of San Francisco
City & County of San Francisco
City & County of San Francisco
City & County of San Francisco
City & County of San Francisco
City & County of San Francisco
City & County of San Francisco
City & County of San Francisco
City & County of San Francisco
City & County of San Francisco
City & County of San Francisco
City & Cnty of San Francisco
10/23/2021
11/17/2021
09/23/2022
12/16/2022
07/09/2021
12/28/2021
01/10/2022
12/08/2021
09/17/2021
10/08/2021
10/20/2021
11/19/2021
09/12/2022
10/24/2022
06/09/2021
06/09/2021
03/11/2022
03/18/2020
04/30/2021
11/27/2015
11/01/2016
11/01/2016
07/14/2017
01/16/2019
10/31/2019
12/14/2022
04/11/2023
04/21/2023
10/20/2023
12/15/2023
11/07/2023
895,819.95
268,431.30
242,644.71
892,860.75
267,248.94
1,991,652.17
498,734.57
198,805.25
876,413.46
209,705.38
248,984.12
744,419.66
1,144,122.04
187,494.96
430,000.00
435,000.00
432,444.68
401,929.58
255,385.92
1,029,269.62
2,106,101.60
244,891.84
228,711.95
1,488,943.98
1,105,312.18
479,897.47
1,024,736.28
532,997.07
526,930.88
328,629.20
1,001,691.01
900,000.00
270,000.00
260,000.00
1,000,000.00
255,000.00
1,980,000.00
500,000.00
200,000.00
875,000.00
210,000.00
250,000.00
750,000.00
1,275,000.00
225,000.00
430,000.00
435,000.00
435,000.00
400,000.00
250,000.00
1,000,000.00
2,105,000.00
245,000.00
230,000.00
1,420,000.00
1,120,000.00
575,000.00
1,000,000.00
500,000.00
635,000.00
305,000.00
1,000,000.00
756,549.00
236,169.00
240,047.60
874,700.00
238,812.60
1,835,519.40
423,455.00
185,366.00
807,187.50
199,107.30
230,625.00
691,875.00
1,126,577.25
194,035.50
394,783.00
392,617.95
407,608.05
383,248.00
223,207.50
1,008,630.00
2,027,283.40
231,478.45
221,508.40
1,454,349.80
995,780.80
484,242.00
1,015,050.00
528,035.00
545,166.55
327,701.15
1,063,520.00

1.984

1.599

1.201

1.599

2.407

1.445

2.113

1.036

0.971

0.743

0.971

0.971

1.331

1.431

1.074

1.372

1.860

1.735

2.103

5.450

2.290

2.390

2.290

5.600

2.100

2.350

6.000

6.000

1.784

6.000

6.000

2.024

1.712

4.053

4.241

1.007

1.193

2.120

1.292

0.887

0.838

1.134

1.282

3.945

5.079

1.059

1.353

2.070

1.381

1.658

3.067

2.219

2.376

2.682

3.304

2.337

4.744

4.146

4.273

5.375

4.803

5.889

2.053 07/01/2031

1.736 07/01/2028

4.110 07/01/2026

4.300 07/01/2028

1.021 08/01/2027

1.210 08/01/2026

2.150 08/01/2031

1.310 04/01/2026

0.900 05/01/2026

0.850 05/01/2025

1.150 05/01/2026

1.300 05/01/2026

4.000 05/01/2028

5.150 05/01/2029

1.074 08/01/2026

1.372 08/01/2027

2.099 08/01/2026

1.400 07/01/2025

1.681 07/01/2029

3.110 06/15/2025

2.249 06/15/2025

2.410 06/15/2026

2.720 06/15/2025

3.350 06/15/2026

2.369 06/15/2029

4.810 06/15/2032

4.203 06/15/2025

4.332 06/15/2028

5.450 06/15/2029

4.870 06/15/2032

5.971 10/01/2032
2,738
1,643
912
1,643
1,308
943
2,769
821
851
486
851
851
1,582
1,947
943
1,308
943
547
2,008
531
531
896
531
896
1,992
3,088
531
1,627
1,992
3,088
3,196
Portfolio CPA
AP
Run Date: 01/21/2024 - 18:49 FI (PRF_FI) 7.3.11
Report Ver. 7.3.11
Item 14
Attachment B - Investment Portfolio

Item 14: Staff Report
Pg.
29 Packet Pg. 402 of 428

Fund ALL - Portfolio Listings
Investments by Fund
December 31, 2023

Purchase Current
Rate
Maturity Days To
Date Maturity
YTM
360
YTM
365Par Value Market ValueCUSIP Investment # Issuer Date Book Value Municipal Bonds
79772EBC2
79772ECL1
79772ECJ6
79772ECF4
79772EDY2
79772EDA4
797669ZJ0
797669ZR2
797669ZR2
826239GD1
826239GD1
82707BDP1
798306WQ5
798135E96
798153NF5
798189PK6
798189QA7
798186N81
798186P30
798186P22
802309NY6
802385RC0
802385RV8
802385RT3
802385RS5
802498VW2
802498ZA6
802498ZF5
799038NP5
799038NP5
799017UW6
1937 MUN
2132 MUN
2309 MUN
2571 MUN
2608 MUN
2628 MUN
2572 MUN
2636 MUN
2766 MUN
2501 MUN
2535 MUN
2828 MUN
2707 MUN
2656 MUN
2622 MUN
1966 MUN
2105 MUN
2518 MUN
2700 MUN
2774 MUN
2706 MUN
2091 MUN
2481 MUN
2482 MUN
2810 MUN
2561 MUN
2637 MUN
2792 MUN
2521 MUN
2523 MUN
1902 MUN
San Francisco Cmnty Facs Dist
San Francisco Cmnty Facs Dist
San Francisco Cmnty Facs Dist
San Francisco Cmnty Facs Dist
San Francisco Cmnty Facs Dist
San Francisco Cmnty Facs Dist
SF Bay Area Rapid Transit Dist
SF Bay Area Rapid Transit Dist
SF Bay Area Rapid Transit Dist
Sierra Joint Com. College Dist
Sierra Joint Com. College Dist
Silicon Valley Clean Water
03/02/2018
10/11/2019
03/13/2020
08/30/2021
11/03/2021
11/29/2021
09/08/2021
12/16/2021
12/15/2022
03/09/2021
05/27/2021
02/10/2023
10/17/2022
01/28/2022
11/18/2021
10/29/2018
10/01/2019
03/15/2021
10/07/2022
12/21/2022
10/17/2022
09/05/2019
01/22/2021
01/22/2021
01/23/2023
08/12/2021
12/20/2021
01/09/2023
04/14/2021
04/14/2021
01/16/2018
674,752.05
371,313.90
138,357.02
304,658.67
584,945.31
1,321,265.00
503,825.19
509,396.88
352,608.50
585,000.00
499,044.16
221,458.10
500,936.75
357,059.46
343,641.70
315,000.00
500,000.00
997,012.56
858,688.13
757,524.10
421,486.15
334,376.33
576,126.47
610,424.12
773,379.71
651,569.76
213,054.67
665,384.02
2,000,658.67
1,500,494.00
998,118.03
680,000.00
350,000.00
130,000.00
300,000.00
575,000.00
1,295,000.00
500,000.00
480,000.00
405,000.00
585,000.00
500,000.00
245,000.00
545,000.00
350,000.00
345,000.00
315,000.00
500,000.00
1,000,000.00
990,000.00
850,000.00
455,000.00
315,000.00
570,000.00
600,000.00
850,000.00
650,000.00
215,000.00
825,000.00
2,000,000.00
1,500,000.00
1,000,000.00
648,652.00
332,258.50
124,950.80
295,866.00
493,407.50
1,214,192.00
492,455.00
422,976.00
356,886.00
502,134.75
429,175.00
220,438.75
501,405.45
332,962.00
318,628.20
309,128.40
460,545.00
938,040.00
865,972.80
758,506.00
421,967.00
303,426.90
480,071.10
529,248.00
762,305.50
595,465.00
195,736.00
668,398.50
1,942,180.00
1,456,635.00
968,100.00

3.250

3.648

3.468

3.108

2.591

2.236

1.971

2.768

2.768

1.445

1.445

1.380

1.201

2.500

1.311

3.728

2.350

0.558

1.224

1.014

1.508

3.472

1.696

1.496

1.244

0.989

0.849

1.624

0.500

0.500

2.699

3.451

2.398

1.577

0.741

2.305

1.425

0.419

1.846

4.832

1.425

1.461

4.301

4.586

1.686

1.459

3.676

2.317

0.739

4.487

4.341

4.586

1.972

1.499

1.085

3.965

0.877

1.193

4.694

0.444

0.444

2.786

3.499 09/01/2027

2.431 09/01/2029

1.599 09/01/2027

0.752 09/01/2024

2.337 09/01/2031

1.445 09/01/2026

0.425 07/01/2024

1.872 07/01/2031

4.899 07/01/2031

1.445 08/01/2029

1.481 08/01/2029

4.361 08/01/2027

4.650 08/01/2026

1.710 09/01/2026

1.480 06/01/2026

3.727 09/01/2027

2.350 08/01/2028

0.750 08/01/2025

4.550 08/01/2028

4.401 08/01/2027

4.650 08/01/2026

2.000 08/01/2028

1.520 08/01/2030

1.100 08/01/2028

4.020 08/01/2027

0.890 07/01/2026

1.210 08/01/2026

4.760 08/01/2031

0.450 09/01/2024

0.450 09/01/2024

2.825 09/01/2025
1,339
2,070
1,339
244
2,800
974
182
2,738
2,738
2,039
2,039
1,308
943San Juan Unified School Dist
City of San Jose 974
San Jose Financing Authority
San Jose Evergreen Cmnty Colll
San Jose Evergreen Cmnty Colll
San Jose Unified School Dist.

San Jose Unified School Dist.

San Jose Unified School Dist.

Santa Maria JT Union High Sch
Santa Monica Cmnty College Dis
Santa Monica Cmnty College Dis
Santa Monica Cmnty College Dis
Santa Monica Cmnty College Dis
Santa Monica-Malibu USD
882
1,339
1,674
578
1,674
1,308
943
1,674
2,404
1,674
1,308
912
Santa Monica-Malibu USD 943
Santa Monica-Malibu USD 2,769
244San Mateo Cnty Comm. College D
San Mateo Cnty Comm. College D
San Mateo Foster City SCH Dist
244
609
Portfolio CPA
AP
Run Date: 01/21/2024 - 18:49 FI (PRF_FI) 7.3.11
Report Ver. 7.3.11
Item 14
Attachment B - Investment Portfolio

Item 14: Staff Report
Pg.
30 Packet Pg. 403 of 428

Fund ALL - Portfolio Listings
Investments by Fund
December 31, 2023

Purchase Current
Rate
Maturity Days To
Date Maturity
YTM
360
YTM
365Par Value Market ValueCUSIP Investment # Issuer Date Book Value Municipal Bonds
799017UW6
799017WD6
799017VM7
799017XW3
799055QV3
799055ME5
799017WE4
83412PFQ0
83412PHQ8
83412PGZ9
83412PHE5
83412PHU9
83412PHW5
83412PHB1
835569GT5
839278JM1
839278KC1
839278KB3
839278KA5
839278JZ2
799289MR1
7994082K4
799408Z93
867578UT1
867578US3
892404CN2
87970GPS0
87970GPQ4
880541XY8
880541XX0
880541XX0
1940 MUN
2153 MUN
2178 MUN
2567 MUN
2585 MUN
2591 MUN
2782 MUN
2176 MUN
2579 MUN
2583 MUN
2594 MUN
2597 MUN
2598 MUN
2649 MUN
2577 MUN
1914 MUN
2161 MUN
2162 MUN
2163 MUN
2164 MUN
2150 MUN
2605 MUN
2813 MUN
2100 MUN
2101 MUN
2493 MUN
2539 MUN
2569 MUN
1673 MUN
1674 MUN
1676 MUN
San Mateo Foster City SCH Dist
San Mateo Foster City SCH Dist
San Mateo Foster City SCH Dist
San Mateo Foster City SCH Dist
San Mateo Foster City SCH Dist
San Mateo Foster City SCH Dist
San Mateo Foster City SCH Dist
Solano Cnty Community Clg Dist
Solano Cnty Community Clg Dist
Solano Cnty Community Clg Dist
Solano Cnty Community Clg Dist
Solano Cnty Community Clg Dist
Solano Cnty Community Clg Dist
Solano Cnty Community Clg Dist
Sonoma Cnty Jr. College Distr.

South Pasadena Unified School
South Pasadena Unified School
South Pasadena Unified School
South Pasadena Unified School
South Pasadena Unified School
San Rafael City High Sch Distr
San Ramon Vly Unif Sch Dist.

San Ramon Vly Unif Sch Dist.

Sunnyvale Elementary Sch Distr
Sunnyvale Elementary Sch Distr
Tracy Unified School District
Temecula Valley Unified School
Temecula Valley Unified School
State of Tennessee
03/09/2018
11/07/2019
12/11/2019
09/21/2021
09/27/2021
09/29/2021
12/22/2022
12/09/2019
10/06/2021
10/06/2021
10/06/2021
10/06/2021
10/06/2021
01/07/2022
09/15/2021
02/15/2018
12/12/2019
12/12/2019
12/12/2019
12/12/2019
11/13/2019
11/03/2021
01/26/2023
09/19/2019
09/19/2019
02/08/2021
06/16/2021
08/27/2021
08/25/2016
08/25/2016
08/25/2016
995,533.43
1,346,177.91
1,578,003.65
500,000.00
178,922.24
1,290,650.03
375,697.25
1,160,383.81
750,000.00
200,629.29
386,927.88
745,504.46
822,482.07
345,160.63
161,229.81
179,443.78
412,911.21
274,665.09
156,580.91
413,966.44
1,755,000.00
1,507,611.40
866,673.30
135,000.00
135,000.00
504,885.10
250,000.00
356,351.12
1,003,877.60
1,653,483.94
701,478.04
1,000,000.00
1,360,000.00
1,565,000.00
500,000.00
175,000.00
1,185,000.00
425,000.00
1,150,000.00
750,000.00
200,000.00
390,000.00
750,000.00
825,000.00
350,000.00
155,000.00
180,000.00
370,000.00
250,000.00
145,000.00
390,000.00
1,755,000.00
1,500,000.00
935,000.00
135,000.00
135,000.00
500,000.00
250,000.00
355,000.00
1,000,000.00
1,650,000.00
700,000.00
968,100.00
1,240,551.20
1,447,484.15
455,880.00
163,318.75
1,210,821.15
381,539.50
1,069,810.50
685,972.50
182,926.00
321,824.10
632,497.50
680,781.75
307,818.00
147,250.00
172,074.60
381,403.40
257,032.50
148,129.10
394,937.40
1,725,972.30
1,293,450.00
858,591.80
121,390.65
123,560.10
435,280.00
221,072.50
325,726.70
948,090.00
1,588,092.00
673,736.00

2.699

2.237

2.542

0.925

1.799

6.000

2.337

2.717

1.025

1.025

1.861

1.761

1.861

1.479

2.447

3.000

5.000

5.000

5.000

5.000

1.965

1.914

1.034

2.190

2.090

1.644

1.503

1.051

2.116

2.066

2.066

2.959

2.447

2.311

0.912

0.897

2.297

4.685

2.462

1.011

0.887

1.948

1.834

1.879

1.775

0.843

3.057

2.598

2.549

2.500

2.378

1.938

1.805

4.044

2.157

2.061

1.437

1.482

0.887

1.923

1.893

1.893

3.000 09/01/2025

2.480 09/01/2028

2.343 09/01/2028

0.925 09/01/2026

0.910 08/01/2026

2.329 08/01/2026

4.750 09/01/2029

2.496 08/01/2028

1.025 08/01/2026

0.900 08/01/2026

1.975 08/01/2031

1.860 08/01/2030

1.905 08/01/2031

1.800 08/01/2028

0.855 08/01/2026

3.100 08/01/2027

2.634 08/01/2029

2.584 08/01/2028

2.534 08/01/2027

2.411 08/01/2026

1.965 08/01/2024

1.830 08/01/2030

4.100 08/01/2026

2.187 09/01/2028

2.090 09/01/2027

1.457 08/01/2029

1.503 08/01/2028

0.900 08/01/2026

1.950 08/01/2026

1.920 08/01/2025

1.920 08/01/2025
609
1,705
1,705
974
943
943
2,070
1,674
943
943
2,769
2,404
2,769
1,674
943
1,308
2,039
1,674
1,308
943
213
2,404
943
1,705
1,339
2,039
1,674
943
943
State of Tennessee 578
State of Tennessee 578
Portfolio CPA
AP
Run Date: 01/21/2024 - 18:49 FI (PRF_FI) 7.3.11
Report Ver. 7.3.11
Item 14
Attachment B - Investment Portfolio

Item 14: Staff Report
Pg.
31 Packet Pg. 404 of 428

Fund ALL - Portfolio Listings
Investments by Fund
December 31, 2023

Purchase Current
Rate
Maturity Days To
Date Maturity
YTM
360
YTM
365Par Value Market ValueCUSIP Investment # Issuer Date Book Value Municipal Bonds
880541QU4
891371BB1
901072LD8
901072MB1
901072LX4
8827237P8
8827237T0
8827237T0
8827237N3
8827235K1
882724RF6
882723A90
91412GQG3
91412GQG3
91412HGF4
91412HJN4
917542QR6
917542QV7
93974CRC6
93974CRC6
97705MNU5
97705MNP6
97705MNP6
977100AC0
987388GX7
987388GX7
2001 MUN
2795 MUN
2715 MUN
2758 MUN
2814 MUN
2195 MUN
2225 MUN
2255 MUN
2311 MUN
2541 MUN
2548 MUN
2631 MUN
2077 MUN
2095 MUN
2685 MUN
2866 MUN
1731 MUN
2306 MUN
1802 MUN
2196 MUN
2547 MUN
2574 MUN
2576 MUN
2822 MUN
2657 MUN
2687 MUN
State of Tennessee
City of Torrance JT PWRS Fin A
Tustin Unif Sch Dist Facs Impt
Tustin Unif Sch Dist Facs Impt
Tustin Unif Sch Dist Facs Impt
State of Texas
12/20/2018
01/12/2023
10/24/2022
12/09/2022
01/26/2023
12/23/2019
01/30/2020
02/14/2020
03/16/2020
06/30/2021
07/02/2021
12/07/2021
08/26/2019
09/09/2019
04/05/2022
04/05/2023
01/04/2017
03/13/2020
05/23/2017
12/24/2019
07/02/2021
09/09/2021
09/13/2021
01/30/2023
02/17/2022
09/02/2022
205,907.01
373,173.13
573,763.40
165,398.29
451,281.66
1,525,839.70
1,002,884.95
1,349,591.17
252,999.72
254,591.68
1,058,082.04
515,277.73
1,521,164.75
1,015,935.48
416,078.92
208,209.52
166,183.48
714,165.17
490,722.57
507,384.22
2,118,579.94
1,545,968.90
1,029,933.81
875,809.03
1,000,000.00
470,612.21
205,000.00
445,000.00
650,000.00
205,000.00
500,000.00
1,500,000.00
940,000.00
1,265,000.00
250,000.00
245,000.00
1,000,000.00
500,000.00
1,500,000.00
1,000,000.00
440,000.00
230,000.00
165,000.00
698,684.05
485,000.00
500,000.00
2,000,000.00
1,500,000.00
1,000,000.00
865,000.00
1,000,000.00
500,000.00
203,450.20
376,087.30
580,833.50
168,356.25
446,795.00
1,462,005.00
903,838.20
1,216,335.45
246,382.50
238,590.80
892,620.00
485,755.00
1,464,525.00
976,350.00
398,428.80
207,621.00
164,551.20
690,202.03
483,627.45
498,585.00
1,755,640.00
1,424,535.00
949,690.00
873,823.00
930,580.00
465,290.00

3.728

2.637

1.145

1.754

1.145

3.051

3.521

3.521

2.899

2.922

2.426

2.831

3.050

3.050

1.316

1.272

4.554

3.539

4.669

4.669

2.451

2.089

2.089

5.700

2.082

2.082

2.860

5.001

4.783

4.843

4.098

1.975

2.191

2.192

1.231

0.641

1.480

1.030

1.930

1.797

3.028

4.311

2.904

1.948

2.416

1.978

1.553

0.739

0.769

5.039

2.053

3.846

2.900 08/01/2024

5.070 06/01/2032

4.850 08/01/2027

4.910 08/01/2031

4.155 08/01/2027

2.003 10/01/2025

2.221 10/01/2029

2.222 10/01/2029

1.248 10/01/2024

0.650 10/01/2025

1.501 10/01/2030

1.045 10/01/2025

1.957 05/15/2025

1.821 05/15/2025

3.070 05/15/2027

4.371 05/15/2027

2.944 07/01/2024

1.975 07/01/2025

2.450 08/01/2024

2.005 08/01/2024

1.575 05/01/2031

0.750 05/01/2026

0.780 05/01/2026

5.109 05/01/2026

2.082 08/01/2027

3.900 08/01/2027
213
3,074
1,308
2,769
1,308
639
State of Texas 2,100
2,100
274
State of Texas
State of Texas
State of Texas 639
State of Texas 2,465
639State of Texas
University of California
University of California
University of California
University of California
State of Utah
500
500
1,230
1,230
182
State of Utah 547
State of Washington
State of Washington
State of Wisconsin
213
213
2,677
851State of Wisconsin
State of Wisconsin 851
State of Wisconsin 2
Yosemite Community College Dis
Yosemite Community College Dis
851
1,308
1,308
Subtotal and Average 220,915,246.84 221,423,684.05 207,679,271.88 2.460 2.494 1,334 Supranationals (World Bank) Bonds
4581X0DV7
45818WDH6
4581X0EB0
2528 IADB
2586 IADB
2652 IADB
Inter-American Dev. Bank
Inter-American Dev. Bank
Inter-American Dev. Bank
04/20/2021
09/27/2021
01/13/2022
1,997,835.39
1,993,886.88
999,259.87
2,000,000.00
2,000,000.00
1,000,000.00
1,854,220.00
1,841,200.00
926,040.00

0.875

0.800

1.500

0.910

0.914

1.504

0.923 04/20/2026

0.927 06/17/2026

1.525 01/13/2027
840
898
1,108
Portfolio CPA
AP
Run Date: 01/21/2024 - 18:49 FI (PRF_FI) 7.3.11
Report Ver. 7.3.11
Item 14
Attachment B - Investment Portfolio

Item 14: Staff Report
Pg.
32 Packet Pg. 405 of 428

Fund ALL - Portfolio Listings
Investments by Fund
December 31, 2023

Purchase Current
Rate
Maturity Days To
Date Maturity
YTM
360
YTM
365Par Value Market ValueCUSIP Investment # Issuer Date Book Value Supranationals (World Bank) Bonds
4581X0EB0
459058JL8
459058JS3
45905U5Y6
459058JL8
459058JL8
459058JS3
459058JS3
459058JS3
45906M2L4
45906M2Z3
45906M3K5
45906M2L4
45906M3K5
459058JN4
459058JT1
459058JT1
459058KW2
45950VPE0
45950VPH3
45950VPJ9
45950VPJ9
45950VPS9
45950VPT7
45950VPU4
45950VPU4
45950VPY6
45950KCX6
2655 IADB
2470 IBRD
2492 IBRD
2497 IBRD
2498 IBRD
2510 IBRD
2534 IBRD
2553 IBRD
2559 IBRD
2650 IBRD
2673 IBRD
2735 IBRD
2736 IBRD
2744 IBRD
2775 IBRD
2779 IBRD
2826 IBRD
2912 IBRD
2441 IFC
Inter-American Dev. Bank 01/14/2022
01/08/2021
02/10/2021
02/18/2021
02/18/2021
03/01/2021
05/26/2021
07/15/2021
08/12/2021
01/07/2022
03/17/2022
11/22/2022
11/23/2022
12/01/2022
12/21/2022
12/22/2022
02/10/2023
10/27/2023
10/30/2020
11/30/2020
01/25/2021
02/11/2021
02/26/2021
03/15/2021
03/23/2021
03/23/2021
05/28/2021
01/12/2022
998,834.55
1,500,340.65
1,500,000.00
1,500,000.00
1,497,304.16
1,492,001.99
1,493,965.41
1,493,771.12
1,492,785.51
984,664.76
1,000,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,000,000.00
1,000,000.00
2,000,000.00
1,000,000.00
1,500,000.00
1,000,000.00
1,500,000.00
1,500,000.00
1,000,000.00
1,000,000.00
1,500,000.00
1,500,000.00
1,500,000.00
1,500,000.00
2,000,000.00
1,500,000.00
2,000,000.00
1,500,000.00
1,000,000.00
926,040.00
1,397,910.00
1,386,810.00
1,383,450.00
1,397,910.00
1,397,910.00
1,386,810.00
1,386,810.00
1,386,810.00
920,760.00

1.500

0.500

0.650

0.600

0.500

0.500

0.650

0.650

0.650

0.650

2.050

4.500

0.650

4.500

0.750

0.850

0.850

4.625

0.350

0.350

0.580

0.580

0.500

0.625

0.750

0.750

0.750

0.750

1.518

0.480

0.641

0.591

0.591

0.787

0.833

0.839

0.871

1.368

2.107

4.684

4.480

4.681

3.807

4.241

4.310

4.967

0.306

0.296

0.501

0.522

0.616

0.554

0.746

0.887

0.642

1.518

1.540 01/13/2027

0.487 10/28/2025

0.650 02/10/2026

0.600 02/18/2026

0.600 10/28/2025

0.798 10/28/2025

0.845 02/10/2026

0.851 02/10/2026

0.883 02/10/2026

1.387 02/24/2026

2.136 03/17/2025

4.749 09/30/2027

4.542 02/24/2026

4.746 09/30/2027

3.860 11/24/2027

4.300 02/10/2027

4.370 02/10/2027

5.036 08/01/2028

0.310 10/15/2025

0.300 11/15/2025

0.508 01/15/2026

0.530 01/15/2026

0.625 02/26/2026

0.562 03/15/2026

0.757 03/23/2026

0.900 03/23/2026

0.651 05/15/2026

1.540 10/08/2026
1,108
666Intl Bk Recon & Development
Intl Bk Recon & Development
Intl Bk Recon & Development
Intl Bk Recon & Development
Intl Bk Recon & Development
Intl Bk Recon & Development
Intl Bk Recon & Development
Intl Bk Recon & Development
Intl Bk Recon & Development
Intl Bk Recon & Development
Intl Bk Recon & Development
Intl Bk Recon & Development
Intl Bk Recon & Development
Intl Bk Recon & Development
Intl Bk Recon & Development
Intl Bk Recon & Development
Intl Bk Recon & Development
International Finance Corp.

International Finance Corp.

International Finance Corp.

International Finance Corp.

International Finance Corp.

International Finance Corp.

International Finance Corp.

International Finance Corp.

International Finance Corp.

International Finance Corp.
771
779
666
666
771
771
771
785
998,990.74 967,440.00 441
1,983,407.61
923,096.07
1,986,600.00
920,760.00
1,368
785
1,487,665.84
890,572.33
1,489,950.00
881,990.00
1,368
1,423
1,136
1,136
1,674
653
1,354,046.08
1,350,904.91
983,442.24
1,348,575.00
1,348,575.00
1,025,650.00
932,870.001,000,000.00
1,500,000.00
1,502,152.79
1,501,501.93
1,496,032.06
2,000,000.00
1,499,759.40
1,993,468.16
1,500,000.00
978,975.14
2454 IFC 1,407,945.00
1,385,175.00
1,385,175.00
1,377,900.00
1,857,280.00
1,384,005.00
1,845,340.00
1,395,915.00
912,330.00
684
2483 IFC 745
2502 IFC 745
2503 IFC 787
2514 IFC 804
2515 IFC 812
2517 IFC 812
2532 IFC 865
2654 IFC 1,011
Subtotal and Average 43,888,665.59
615,665,374.43
44,500,000.00
616,711,287.92
41,446,155.00
576,479,076.85

1.559

2.353

1.581

2.386
887
Total Investments and Average 1,142
Portfolio CPA
AP
Run Date: 01/21/2024 - 18:49 FI (PRF_FI) 7.3.11
Report Ver. 7.3.11
Item 14
Attachment B - Investment Portfolio

Item 14: Staff Report
Pg.
33 Packet Pg. 406 of 428

1 General Investment Guidelines: Full Compliance
a) The max. stated final maturity of individual securities in the portfolio should be 10 years. b) A max. of 30 percent of the par value of the portfolio shall be invested in securities with maturities 24.9% beyond 5 years.
c) The City shall maintain a minimum of one month's cash needs in short term investments. d) At least
$50 million shall be maintained in securities maturing in less than 2 years.

Plus two managed pool accounts which provide instant liquidity:
- Local Agency Investment Fund (LAIF) - maximum investment limit is $75 million $43.8 million - Fidelity Investments $28.1 million
e) Should market value of the portfolio fall below 95 percent of the book value, report this fact within a 93.6% reasonable time to the City Council and evaluate if there are risk of holding securities to maturity. d) Commitments to purchase securities newly introduced on the market shall be made no more than three (3) working days before pricing.
f) Whenever possible, the City will obtain three or more quotations on the purchase or sale of comparable securities (excludes new issues, LAIF, City of Palo Alto bonds, money market accounts, and mutual funds).
2 U.S. Government Securities:

Full Compliance
a) There is no limit on purchase of these securities.
b) Securities will not exceed 10 years maturity.
3 U.S. Government Agency Securities: Full Compliance
a) There is no limit on purchase of these securities except for:

Callable and Multi-step-up securities provided that:
- The potential call dates are known at the time of purchase; - the interest rates at which they "step-up" are known at the time of purchase; and - the entire face value of the security is redeemed at the call date. - No more than 25 percent
of the par value of portfolio. 24.84%
b) Securities will not exceed 10 years maturity.
4 California State, California Local Government Agencies, and other United States State Bonds: Full Compliance a) Having at time of investment a minimum Double A (AA/Aa2) rating as provided by a nationally recognized rating service (e.g., Moody’s, Fitch, and/or Standard and Poor’s). b) May not exceed 40 percent of the par value of the portfolio. 35.82% 5 Certificates of Deposit (CD): Full Compliance
a) May not exceed 20 percent of the par value of the portfolio; None Held b) No more than 10 percent of the par value of the portfolio in collateralized CDs in any institution. c) Purchase collateralized deposits only from federally insured large banks that are rated by a nationally recognized rating agency (e.g. Moody's, Fitch, and/or Standard & Poor's). d) For non-rated banks, deposit should be limited to amounts federally insured (FDIC) e) Rollovers are not permitted without specific instruction from authorized City staff. 6 Banker's Acceptance Notes (BA):

Full Compliance
a) No more than 30 percent of the par value of the portfolio. None Held b) Not to exceed 180 days maturity.
c) No more than $5 million with any one institution.
$173.1 million

1.14%
Attachment C
Investment Policy Compliance
As of December 31, 2023
Investment Policy Requirements
Compliance
Check / Actual
Item 14
Attachment C -
Investment Policy
Compliance

Item 14: Staff Report
Pg.
34 Packet Pg. 407 of 428

Attachment C
Investment Policy Compliance
As of December 31, 2023
Investment Policy Requirements
Compliance
Check / Actual
7 Commercial Paper: Full Compliance
a) No more than 15 percent of the par value of the portfolio. None Held b) Having highest letter or numerical rating from a nationally recognized rating service. c) Not to exceed 270 days maturity.
d) No more than $3 million or 10 percent
of the outstanding commercial paper of any one institution, whichever is lesser.
8 Short-Term Repurchase Agreement (REPO): Full Compliance a) Not to exceed 1 year. None Held
b) Market value of securities that underlay a repurchase agreement shall be valued at 102 percent or greater of the funds borrowed against those securities. 9 Money Market Deposit Accounts Full Compliance
a) Liquid bank accounts which seek to maintain a net asset value of $1.00. 10 Mutual Funds: Full Compliance
a) No more than 20 percent of the par value of the portfolio. None Held b) No more than 10 percent of the par value with any one institution. 11 Negotiable Certificates of Deposit (NCD): Full Compliance a) No more than 20 percent of the par value of the portfolio. 7.17% b) No more than $5 million in any one institution. Federally Insured 12 Medium-Term Corporate Notes: Full Compliance
a) No more than 10 percent of the par value of the portfolio. 4.75% b) Not to exceed 5 years maturity.
c) Securities eligible for investment shall have a minimum rating of AA or Aa2 from a nationally recognized rating service.
d) No more than $5 million of the par value may be invested in securities of any single issuer, other than the U.S. Government, its agencies and instrumentality. e) If securities owned by the City are downgraded by either rating agencies to a level below AA it shall be the City's policy to review the credit situation and make a determination as to whether to sell or retain such securities.
13 Supranational Organizations Securities:

Full Compliance
a) Securities will not exceed 5 years maturity
b) No more than 20 percent of the par value of the portfolio. 7.22% c) No more than 10 percent in any one institution. Full Compliance d) Securities eligible for investment shall have a minimum rating of AA or Aa2 from a nationally recognized rating service.
14 Prohibited Investments:
a) Reverse Repurchase Agreements
b) Derivatives as defined in Appendix B of the Investment Policy 15 All securities shall be delivered to the City's safekeeping custodian, and held in the name of the City, with the exception of :
- Certificates of Deposit, Mutual Funds, and Local Agency Investment Fund (LAIF) Full Compliance
None Held
Full Compliance
Item 14
Attachment C -
Investment Policy
Compliance

Item 14: Staff Report
Pg.
35 Packet Pg. 408 of 428

City Council
Staff Report
From: City Manager
Report Type: INFORMATION REPORTS
Lead Department: Administrative Services
Meeting Date: February 12, 2024
Report #:2401-2567
TITLE
Sales Tax Digest Summary Calendar 2023 (July 2023 - Sept 2023)

DISCUSSION
This report transmits information regarding the City of Palo Alto’s sales tax receipts for the third quarter (July - September) of 2023. Further and more detailed levels of information can be found in the attached City of Palo Alto Sales Tax Digest Summary and Legislative Update 2023 Q3 (Attachment A).

The City’s sales tax cash receipts of $9.6 million for the third quarter (July to September 2023) is $0.90 million (10.3%) higher than the same quarter of the prior year (see Attachment A, Historical Analysis by Calendar Quarter). When adjusted for non-period related payments, the overall economic quarter over quarter sales tax activity (Q3 2022 to Q3 2023) in Palo Alto increased by $0.96 million (13.9%). Statewide, Q3 2023 sales tax cash receipts decreased 3.2% from Q3 2022.

For the year ending in the third quarter of 2023, sales tax cash receipts for the city increased by

9.7% from the prior year. When adjusted for non-period related payments, the overall economic sales tax activity in Palo Alto for the year increased by 6.0%. In comparison, statewide sales tax cash receipts decreased by 0.3% and Northern California decreased by 0.8%.

The third quarter includes $1.5 million of sales tax receipts from the county pool. The City’ s share of the county pool for this quarter is 6.7%, up 0.8% from the third quarter of 2022.

County pools are primarily from online purchases from out-of-state companies, remote sellers who ship merchandise to California/ County destinations, and private vehicle sales that are not directly allocated to a jurisdiction. County pools are allocated to local jurisdictions based on each jurisdiction’ s share of total sales taxes.

ATTACHMENTS
Attachment A: 2023 Q3 Sales Tax Data and Legislative Update APPROVED BY:

Kiely Nose, Assistant City Manager
Item 15
Item 15 Staff Report

Item 15: Staff Report
Pg.
1 Packet Pg. 409 of 428

City of Palo Alto
Sales Tax Digest Summary
Collections through November 2023
Sales July through September 2023 (2023Q3)

www.avenuinsights.com (800) 800-8181 Page 1
California Overview
For the year ending in the third quarter of 2023, cash receipts decreased 0.3% statewide, and decreased

0.4% in S.F. Bay Area. However, when adjusted for non-period related payments, the overall economic sales tax activity for the year ending in third quarter of 2023 decreased by 1.3% statewide and decreased by 3.2% in S.F. Bay Area.

City of Palo Alto
For the year ending in the third quarter of 2023, sales tax cash receipts for the city increased by 9.7% from the prior year. However, when adjusted for non-period related payments, the overall economic sales tax activity in Palo Alto for the year ending in third quarter of 2023 increased by 6.0%.

Same quarter sales tax cash receipts decreased by 3 .2% in California from Q 3 2022 to Q3 2023. Overall, the decline in sales tax cash receipts in California in Q3 2023 when compared to the same quarter in the prior year was due to a combination of factors, including consumer responses to higher prices and higher interest rates. While inflation rates have been declining, the cumulative impact of higher prices and economic uncertainty have started to impact consumer confidence and ultimately impacted consumer demand in Q3 2023 . Interest rate increases made financing larger purchases, such as new autos, more expensive.

The Palo Alto citywide sales tax cash receipts increas ed by 10.3% over the Q3 202 2 to Q3 2023 period .

Palo Alto’s growth bucked the overall statewide decreasing trend during the same period. Key reasons for the Palo Alto increase during this period (while the rest of the state was down) were a 11.6% increase in restaurants economic activity, a 14.5% increase in the auto leasing segment, along with an increase in non-period cash payments.

The Transportation Category in Palo Alto saw the largest decline in taxable sales on an economic basis over the past year, falling by 5.7%. This was largely driven by a 6.9% year-over-year decline in taxable sales of new autos. The average price of a new car in California was $47,899 in 2023Q3, down from $48,259 in 2022Q3, a 0.7% decrease. The average price of a Tesla in California declined by $14,317 in the year ended 2023Q3, from $ 65,000 in 2022Q 3 to $ 50,683 in 2023Q 3, a 22 .0% decline. The dec rease in the Transportation category for the Palo Alto can also be attributed to CDTFA’s determination that Tesla had not been reporting the local tax correctly based on Point-of-Sale criteria for auto dealerships.

Item 15
Attachment A - 2023 Q3
Sales Tax Data and
Legislative Update

Item 15: Staff Report
Pg.
2 Packet Pg. 410 of 428

City of Palo Alto

www.avenuinsights.com (800) 800-8181 Page 2 % of Total / % Change Palo Alto California
Statewide S.F. Bay Area Sacramento
Valley Central Valley South Coast Inland Empire North Coast General Retail 26.2 / -1.1 28.3 / 0.6 23.6 / -4.0 28.5 / 0.5 37.0 / 0.8 26.9 / 2.2 33.6 / -0.8 27.1 / 2.6 Food Products 17.2 / 10.4 21.0 / 2.7 23.0 / 4.0 16.6 / 2.2 14.7 / 2.8 22.9 / 3.1 17.6 / -2.0 18.2 / 1.4 Transportation 17.9 / -5.7 23.9 / -3.8 19.9 / -5.2 26.6 / -5.9 22.8 / -3.2 24.9 / -2.5 24.7 / -7.7 28.9 / -7.2 Business to Business 35.5 / 19.7 16.0 / -4.2 21.7 / -5.8 14.7 / 0.3 14.8 / -3.4 15.6 / -4.5 11.1 / -1.2 10.2 / -9.6 Misc/Other 3.2 / -12.0 10.8 / -4.0 11.7 / -6.2 1.1 / 1.8 0.7 / -6.9 1.1 / -0.4 13.0 / -6.0 1.0 / 11.0 Total 100.0 / 6.0 100.0 / -1.3 100.0 / -3.2 100.0 / -2.3 100.0 / -1.2 100.0 / -0.3 100.0 / -3.6 100.0 / -2.9 Palo Alto California
Statewide S.F. Bay Area Sacramento
Valley Central Valley South Coast Inland Empire North Coast Largest Segment Leasing Restaurants Restaurants Miscellaneous Retail
Miscellaneous
Retail Restaurants Miscellaneous
Retail Restaurants
% of Total / % Change 21.9 / 14.5 15.1 / 5.1 17.0 / 6.2 11.7 / 10.5 14.8 / 11.0 16.9 / 5.3 16.5 / 1.6 11.5 / 1.4 2nd Largest Segment Restaurants Auto Sales -
New
Auto Sales -
New Restaurants Department
Stores
Auto Sales -
New Restaurants Auto Sales -
New
% of Total / % Change 15.4 / 11.6 11.5 / -0.3 9.6 / -2.7 11.3 / 3.1 10.9 / -1.9 12.8 / 0.4 11.3 / 2.4 11.4 / 0.9 3rd Largest Segment Auto Sales -
New
Miscellaneous
Retail
Department
Stores
Auto Sales -
New Restaurants Miscellaneous
Retail
Auto Sales -
New
Department
Stores
% of Total / % Change 14.0 / -6.9 9.9 / 9.4 7.7 / -2.9 11.3 / -1.1 9.8 / 4.8 8.6 / 14.9 11.1 / -1.7 10.8 / 20.0 ECONOMIC CATEGORY ANALYSIS FOR YEAR ENDED 3rd Quarter 2023 ECONOMIC SEGMENT ANALYSIS FOR YEAR ENDED 3rd Quarter 2023

Regional Overview
The first chart on page two shows adjusted economic benchmark year amounts, which means that it shows the year ended third quarter of 2023 compared to the year ended third quarter of 2022 (benchmark years are rolling annual comparisons through the current quarter). The growth rates are different between the state and Palo Alto because the sales tax from businesses in Palo Alto performed better overall than the statewide average.

Regional Overview Chart (Economic)
BENCHMARK YEAR 2023Q3 COMPARED TO BENCHMARK YEAR 2022Q3

Item 15
Attachment A - 2023 Q3
Sales Tax Data and
Legislative Update

Item 15: Staff Report
Pg.
3 Packet Pg. 411 of 428

City of Palo Alto

www.avenuinsights.com (800) 800-8181 Page 3 $-
$5,000,000
$10,000,000
$15,000,000
$20,000,000
$25,000,000
$30,000,000
$35,000,000
Quarterly Benchmark Year
Leasing

22.0%
Restaurants

15.5%
Auto Sales - New

14.0%
Office Equipment

8.2%Apparel Stores

6.6%
All Other

33.8%
Net Pools & Adjustments

23.9%
Gross Historical Sales Tax Cash Receipts by Benchmark Year and Quarter (Before Adjustments)

Net Cash Receipts for Benchmark Year third Quarter 2023: $36,691,136

*Benchmark year (BMY) is the sum of the current and 3 previous quarters (2023Q3 BMY is sum of 2023 Q3, 2023 Q2, 2023 Q1, 2022 Q4)

Item 15
Attachment A - 2023 Q3
Sales Tax Data and
Legislative Update

Item 15: Staff Report
Pg.
4 Packet Pg. 412 of 428

City of Palo Alto

www.avenuinsights.com (800) 800-8181 Page 2 Anderson Honda Macy's Department Store Shreve & Co.

Apple Stores Magnussen's Toyota of Palo Alto Stanford Health Care Arco AM/PM Mini Marts Neiman Marcus Tesla
Audi Palo Alto Nordstrom Department Store Tesla Lease Trust Bloomingdale's Richemont Tiffany & Company
Hengehold Trucks Rivian Automotive Union 76 Service Stations Hermes Sephora Varian Medical Systems
HP Enterprise Services Shell Service Stations Volvo Cars Palo Alto Louis Vuitton
TOP 25 SALES/USE TAX CONTRIBUTORS

The following list identifies Palo Alto’s Top 25 Sales/Use Tax contributors. The list is in alphabetical order and represents th e year ended third quarter of 2023. The Top 25 Sales/Use Tax contributors generate

61.9% of Palo Alto’s total sales and use tax revenue.

Item 15
Attachment A - 2023 Q3
Sales Tax Data and
Legislative Update

Item 15: Staff Report
Pg.
5 Packet Pg. 413 of 428

City of Palo Alto

www.avenuinsights.com (800) 800-8181 Page 5
$-
$500,000
$1,000,000
$1,500,000
$2,000,000
$2,500,000
$3,000,000
$3,500,000
$4,000,000
$4,500,000
$5,000,000
Benchmark Year 2023Q3 Benchmark Year 2022Q3
Sales Tax from Largest Non-Confidential Sales Tax Segments (Economic)

Item 15
Attachment A - 2023 Q3
Sales Tax Data and
Legislative Update

Item 15: Staff Report
Pg.
6 Packet Pg. 414 of 428

City of Palo Alto

www.avenuinsights.com (800) 800-8181 Page 5

Economic Category % 2023Q3 2023Q2 2023Q1 2022Q4 2022Q3 2022Q2 2022Q1 2021Q4 2021Q3 2021Q2 2021Q1 Business To Business 27.3% 2,619,833 2,439,519 2,350,567 2,571,178 2,194,817 2,095,020 2,031,199 2,136,501 1,689,561 1,559,814 1,700,725 M isc ellaneous/Other 19.5% 1,870,170 1,546,096 1,302,322 1,517,005 1,597,816 1,724,861 1,701,538 1,687,189 1,812,731 1,743,358 1,558,859 Gener al Retail 19.1% 1,834,297 2,017,885 1,640,927 2,305,038 1,802,777 1,920,316 1,639,417 2,282,253 1,687,461 1,740,666 1,153,240 Food Products 13.3% 1,277,173 1,349,926 1,195,458 1,260,287 1,230,824 1,227,240 1,018,577 1,083,309 999,729 912,939 635,705 Subtotal Ec onomic (Loc al Business) 79.3% 7,601,473 7,353,426 6,489,274 7,653,508 6,826,234 6,967,438 6,390,731 7,189,252 6,189,482 5,956,778 5,048,529 Net Pools & Adjus tments 20.7% 1,986,175 2,084,763 1,586,938 1,935,580 1,862,181 686,044 1,721,924 1,806,328 584,508 1,513,663 1,741,273 Total C ash Rec eipts 100.0% 9,587,647 9,438,189 8,076,212 9,589,088 8,688,414 7,653,481 8,112,655 8,995,580 6,773,990 7,470,441 6,789,802 Economi c Segment % 2023Q3 2023Q2 2023Q1 2022Q4 2022Q3 2022Q2 2022Q1 2021Q4 2021Q3 2021Q2 2021Q1 M isc ellaneous/Other 48.4% 4,635,983 4,197,978 3,818,384 4,490,992 4,087,158 4,008,008 3,949,786 3,969,954 3,752,178 3,570,610 3,406,995 Res taurants 12.0% 1,154,189 1,214,502 1,073,621 1,114,637 1,102,248 1,093,944 902,707 947,771 884,911 799,544 540,244 M isc ellaneous Retail 5.0% 480,649 512,077 448,322 545,797 381,616 479,710 432,956 679,381 412,016 514,516 338,032 Appa rel Stores 5.0% 478,973 509,894 423,470 538,573 435,730 495,508 392,724 540,782 406,274 398,447 264,318 Department Stores 4.5% 435,388 492,374 356,626 533,032 423,601 454,349 367,144 525,295 388,703 384,763 237,522 Ser v ic e Stations 2.4% 229,911 222,029 192,723 215,640 233,387 250,715 191,755 190,610 181,460 157,268 116,258 Food Markets 1.1% 103,251 111,465 101,978 116,810 99,811 104,253 91,634 108,203 90,773 89,773 74,397 Business Serv ices 0.9% 83,130 93,106 74,150 98,027 62,683 80,950 62,025 227,256 73,169 41,858 70,763 Subtotal Ec onomic (Loc al Business) 79.3% 7,601,473 7,353,426 6,489,274 7,653,508 6,826,234 6,967,438 6,390,731 7,189,252 6,189,482 5,956,778 5,048,529 Net Pools & Adjus tments 20.7% 1,986,175 2,084,763 1,586,938 1,935,580 1,862,181 686,044 1,721,924 1,806,328 584,508 1,513,663 1,741,273 Total C ash Rec eipts 100.0% 9,587,647 9,438,189 8,076,212 9,589,088 8,688,414 7,653,481 8,112,655 8,995,580 6,773,990 7,470,441 6,789,802

Historical Analysis by Calendar Quarter

The chart above shows the categories and segments in quarterly economic basis amounts. The total amount is the net cash recei pts, and it was obtained by adding up the categories/segments with the “Net Pools & Adjustments” amount.

Item 15
Attachment A - 2023 Q3 Sales Tax
Data and Legislative Update

Item 15: Staff Report
Pg.
7 Packet Pg. 415 of 428

City of Palo Alto

www.avenuinsights.com (800) 800-8181 Page 7 Economic Category % 2023Q3 2022Q3 2021Q3 2020Q3 2019Q3 2018Q3 2017Q3 2016Q3 2015Q3 2014Q3 Business To Business 28.7% 10,537,037 8,801,184 7,087,412 8,271,109 8,206,755 6,135,995 5,533,774 5,274,809 4,252,383 4,537,394 M isc ellaneous/Other 17.0% 6,254,742 6,703,263 6,886,475 5,536,429 8,213,787 7,119,601 6,064,700 6,214,339 5,685,238 5,340,922 Gener al Retail 21.0% 7,715,221 7,711,008 6,188,795 5,169,077 7,806,118 8,438,880 8,410,442 8,066,588 8,097,731 8,085,021 Food Products 13.9% 5,101,072 4,618,590 3,229,004 3,381,024 4,912,510 4,799,026 4,641,731 4,623,265 4,411,228 4,126,302 Subtotal Ec onomic (Loc al Business) 80.7% 29,608,071 27,834,045 23,391,686 22,357,638 29,139,170 26,493,501 24,650,648 24,179,001 22,446,580 22,089,640 Net Pools & Adjus tments 19.3% 7,083,065 5,616,086 4,983,730 5,500,512 5,787,830 5,476,835 4,896,415 4,110,008 4,201,030 3,612,493 Total 100.0% 36,691,136 33,450,131 28,375,417 27,858,150 34,927,000 31,970,336 29,547,063 28,289,009 26,647,610 25,702,133

Economi c Segment % 2023Q3 2022Q3 2021Q3 2020Q3 2019Q3 2018Q3 2017Q3 2016Q3 2015Q3 2014Q3 M isc ellaneous/Other 48.2% 17,688,682 16,315,061 14,908,971 14,585,390 17,361,346 14,617,927 12,927,875 12,448,262 11,022,846 11,018,397 Res taurants 12.5% 4,580,374 4,105,455 2,788,501 2,900,521 4,337,084 4,196,932 4,040,236 4,021,805 3,835,898 3,602,981 M isc ellaneous Retail 5.2% 1,893,775 2,024,139 1,754,067 1,220,669 1,658,961 1,688,462 2,034,384 1,992,497 1,519,840 1,518,777 Appa rel Stores 5.3% 1,947,222 1,873,085 1,433,338 1,193,933 1,951,720 1,931,597 1,721,857 1,631,712 1,656,560 1,663,440 Department Stores 5.0% 1,817,415 1,774,002 1,326,441 1,014,928 1,842,137 2,085,700 2,032,059 2,188,368 2,402,334 2,376,717 Ser v ic e Stations 2.4% 866,745 866,857 566,228 505,818 693,546 671,528 601,794 554,825 668,928 784,615 Business Serv ices 1.0% 380,071 471,450 269,485 550,605 845,213 819,254 790,083 832,423 839,442 670,259 Food Markets 1.2% 433,789 403,997 344,656 385,774 449,163 482,100 502,359 509,109 500,731 454,455 Subtotal Ec onomic (Loc al Business) 80.7% 29,608,071 27,834,045 23,391,686 22,357,638 29,139,170 26,493,501 24,650,648 24,179,001 22,446,580 22,089,640 Net Pools & Adjus tments 19.3% 7,083,065 5,616,086 4,983,730 5,500,512 5,787,830 5,476,835 4,896,415 4,110,008 4,201,030 3,612,493 Total 100.0% 36,691,136 33,450,131 28,375,417 27,858,150 34,927,000 31,970,336 29,547,063 28,289,009 26,647,610 25,702,133

Historical Analysis by Calendar BMY from 2014Q3 to 2023Q3

The chart above shows the categories and segments in benchmark year economic basis amounts. The total amount is the net cash receipts, and it was obtained by adding up the categories/segments with the “Net Pools & Adjustments” amount. Benchmark year (BMY) is the sum of the current and 3 previous quarters (2023Q3 BMY is sum of 2023 Q3, 2023 Q2, 2023 Q1, 2022 Q4).

Item 15
Attachment A - 2023 Q3 Sales Tax
Data and Legislative Update

Item 15: Staff Report
Pg.
8 Packet Pg. 416 of 428

City of Palo Alto

www.avenuinsights.com (800) 800-8181 Page 8

General Retail
Food Products
Transportation
Business to Business
Misc/Other
2023/3 Total
2022/3 Total
% Chg
Largest Gain
Second Largest
Gain
Largest Decline
Second Largest
Decline
Campbell -2.3% 1.6% -5.4% -14.2% -5.5% 2,621,244 2,734,865 -4.2% I.T. Infrastructure Office Equipment Light Industry Electronic Equipment Cupertino 3.0% 7.6% 11.8% -2.5% 11.0% 8,679,509 8,777,018 -1.1% Restaurants Service Stations I.T. Infrastructure Office Equipment Gilroy -2.6% 3.0% 8.3% 16.9% -11.9% 4,574,449 4,463,250 2.5% Auto Sales - New Heavy Industry Bldg.Matls-Whsle Service Stations Los Altos -4.8% -3.1% -13.6% -49.6% -4.4% 596,170 666,060 -10.5% Food Markets Auto Parts/Repair Electronic Equipment Service Stations Los Gatos -8.3% 9.2% -1.0% -8.1% -49.9% 1,406,816 1,485,590 -5.3% Food Processing Eqp Liquor Stores Miscellaneous Other Furniture/Appliance Milpitas -0.9% 3.7% 1.2% -20.4% -6.5% 5,852,181 6,231,427 -6.1% Restaurants Auto Sales - New Office Equipment Furniture/Appliance Morgan Hill 4.2% -0.1% 11.4% 5.0% 1.7% 2,790,740 2,631,056 6.1% Auto Sales - New Misc. Vehicle Sales Auto Parts/Repair Energy Sales Mountain View 5.8% -5.0% -12.4% 7.0% 10.3% 4,920,160 4,992,780 -1.5% Business Services Auto Parts/Repair Auto Sales - New Office Equipment Palo Alto -1.3% 3.1% 21.7% 29.7% 0.4% 7,840,790 6,881,458 13.9% Office Equipment Auto Sales - New Furniture/Appliance Bldg.Matls-Whsle San Jose -2.5% 3.4% -7.9% 13.4% 3.0% 50,232,059 49,442,213 1.6% Office Equipment Miscellaneous Other Auto Sales - New Electronic Equipment Santa Clara -6.4% 14.4% -6.1% 0.8% -10.6% 12,959,968 13,097,600 -1.1% Light Industry Restaurants Office Equipment Heavy Industry County of Santa Clara 3.2% -11.2% 55.2% -31.8% 8.6% 1,294,694 1,345,716 -3.8% Misc. Vehicle Sales Health & Government Food Processing Eqp Heavy Industry Saratoga -0.6% 1.6% -5.3% -47.8% 24.0% 277,630 289,988 -4.3% Light Industry Auto Parts/Repair Business Services Service Stations Sunnyvale 19.7% 2.9% 19.7% -4.6% 11.4% 7,488,182 7,145,562 4.8% Auto Sales - New Miscellaneous Retail Bldg.Matls-Whsle Office Equipment Quarterly Analysis by Sales Tax Category: Change from 2022Q3 to 2023Q3 (Economic)

Unlike the chart on page one which showed a ‘benchmark year’ through third quarter of 2023, the chart above shows a comparison of one quarter only – third quarter of 2023 to third quarter of 2022. This chart is for local ‘brick and mortar’ businesses and it excludes county pools and adjustments.

Item 15
Attachment A - 2023 Q3 Sales Tax
Data and Legislative Update

Item 15: Staff Report
Pg.
9 Packet Pg. 417 of 428

City of Palo Alto

www.avenuinsights.com (800) 800-8181 Page 9 California Avenue % CHANGE QoQ 2023Q3 QE 2022Q3 QE 23Q3 % OF TOTAL 22Q3 % OF TOTAL FOOD PRODUCTS 12.2% 96,166 85,732 58.8% 53.8%
GENERAL RETAIL -14.9% 26,767 31,459 16.4% 19.7%
ALL OTHER -3.9% 40,657 42,294 24.9% 26.5%
TOTAL 2.6% 163,590 159,485 100.0% 100.0%
El Camino Real and Midtown % CHANGE QoQ 2023Q3 QE 2022Q3 QE 23Q3 % OF TOTAL 22Q3 % OF TOTAL FOOD PRODUCTS -0.3% 156,519 156,984 25.8% 27.3%
GENERAL RETAIL -5.5% 34,492 36,481 5.7% 6.4%
ALL OTHER 9.4% 416,432 380,604 68.6% 66.3%
TOTAL 5.8% 607,443 574,069 100.0% 100.0%
Greater Downtown % CHANGE QoQ 2023Q3 QE 2022Q3 QE 23Q3 % OF TOTAL 22Q3 % OF TOTAL FOOD PRODUCTS 5.5% 514,021 487,139 63.6% 57.5%
GENERAL RETAIL -18.2% 246,806 301,594 30.6% 35.6%
BUSINESS TO BUSINESS -21.4% 32,847 41,770 4.1% 4.9%
CONSTRUCTION -23.9% 9,586 12,591 1.2% 1.5%
TRANSPORTATION -2.1% 3,331 3,402 0.4% 0.4%
MISCELLANEOUS 53.4% 1,058 690 0.1% 0.1%
TOTAL -4.7% 807,651 847,186 100.0% 100.0%
Stanford Shopping Center % CHANGE QoQ 2023Q3 QE 2022Q3 QE 23Q3 % OF TOTAL 22Q3 % OF TOTAL GENERAL RETAIL 3.1% 1,332,525 1,291,996 76.4% 76.4%
FOOD PRODUCTS 0.0% 156,813 156,883 9.0% 9.3%
ALL OTHER 5.1% 255,596 243,153 14.6% 14.4%
TOTAL 3.1% 1,744,934 1,692,032 100.0% 100.0%
City of Palo Alto Geo Areas & Citywide Chart Data: Change from 2022Q3 to 2023Q3 (Economic)

Item 15
Attachment A - 2023 Q3 Sales Tax
Data and Legislative Update

Item 15: Staff Report
Pg.
10 Packet Pg. 418 of 428

City of Palo Alto

www.avenuinsights.com (800) 800-8181 Page 10

Town And Country Shopping Center % CHANGE QoQ 2023Q3 QE 2022Q3 QE 23Q3 % OF TOTAL 22Q3 % OF TOTAL FOOD PRODUCTS -1.5% 110,125 111,844 61.4% 62.2%
GENERAL RETAIL 2.3% 66,420 64,948 37.0% 36.1%
ALL OTHER -8.5% 2,892 3,161 1.6% 1.8%
TOTAL -0.3% 179,437 179,953 100.0% 100.0%
All Other Geos combined with Balance of Jurisdiction % CHANGE QoQ 2023Q3 QE 2022Q3 QE 23Q3 % OF TOTAL 22Q3 % OF TOTAL BUSINESS TO BUSINESS 29.2% 2,660,006 2,058,913 36.6% 32.3% GENERAL RETAIL -1.0% 1,781,083 1,799,951 24.5% 28.3%
TRANSPORTATION 21.8% 1,629,334 1,338,217 22.4% 21.0%
FOOD PRODUCTS 4.2% 1,114,697 1,069,613 15.4% 16.8%
MISCELLANEOUS -4.8% 45,461 47,759 0.6% 0.7%
CONSTRUCTION -49.7% 27,610 54,920 0.4% 0.9%
TOTAL 14.0% 7,258,191 6,369,373 100.0% 100.0%
All Geo Area Totals Comparison 23Q3 & 22Q3 % CHANGE QoQ 2023Q3 QE 2022Q3 QE 23Q3 % OF TOTAL 22Q3 % OF TOTAL Balance of Jurisdiction 28.7% 3,755,136 2,916,649 51.7% 45.8% Stanford Shopping Center 3.1% 1,744,934 1,692,032 24.0% 26.6% Greater Downtown -4.7% 807,651 847,186 11.1% 13.3%
El Camino Real and Midtown 5.8% 607,443 574,069 8.4% 9.0% Town And Country Shopping Center -0.3% 179,437 179,953 2.5% 2.8% California Avenue 2.6% 163,590 159,485 2.3% 2.5%
TOTAL 14.0% 7,258,191 6,369,373 100.0% 100.0%
Palo Alto citywide QE 23Q3 & 22Q3 % CHANGE QoQ 2023Q3 QE 2022Q3 QE 23Q3 % OF TOTAL 22Q3 % OF TOTAL BUSINESS TO BUSINESS 29.7% 2,854,009 2,200,581 36.4% 32.0% GENERAL RETAIL -1.3% 1,834,297 1,857,838 23.4% 27.0%
TRANSPORTATION 21.7% 1,632,961 1,342,342 20.8% 19.5%
FOOD PRODUCTS 3.1% 1,277,173 1,239,211 16.3% 18.0%
MISCELLANEOUS 18.0% 205,832 174,396 2.6% 2.5%
CONSTRUCTION -45.6% 36,519 67,091 0.5% 1.0%
TOTAL 13.9% 7,840,790 6,881,458 100.0% 100.0%
City of Palo Alto Geo Areas & Citywide Chart Data: Change from 2022Q3 to 2023Q3 (Economic) Cont.

Item 15
Attachment A - 2023 Q3 Sales Tax
Data and Legislative Update

Item 15: Staff Report
Pg.
11 Packet Pg. 419 of 428