ATCH 2 - Napa Quarterly Investment Holdings Report 2023-6-30

Attachment 2
Sector Par Value Original Cost Market Value
U.S. Treasuries 112,185,000.00 108,729,176.61 102,803,399.59 Federal Agencies 6,965,000.00 7,005,571.05 6,657,547.86 Federal Agency CMBS 9,990,233.22 9,816,965.26 9,561,545.43 Municipals 10,025,000.00 10,144,542.80 9,434,890.80
Supra-National Agencies 2,910,000.00 2,966,391.60 2,746,359.68 Certificates of Deposit 1,600,000.00 1,600,000.00 1,598,918.88 Corporate Notes 42,110,000.00 42,056,182.95 39,996,148.57 Asset-Backed Securities 17,649,102.65 17,657,296.84 17,260,569.46 California Asset Management Trust 25,799,509.71 25,799,509.71 25,799,509.71 Local Agency Investment Fund 72,189,771.02 72,189,771.02 72,189,771.02 Total 301,423,616.60 297,965,407.84 288,048,661.00
Market Value Basis
Interest Earned $1,235,766
Change in Market Value ($2,120,156) City of Napa -0.41% 0.25% 1.30% 3.05% Total Dollar Return ($884,390) -0.85% -0.42% 0.89% 2.79% Accrual Basis
Interest Earned $1,235,766
Realized Gains / (Losses) ($1,026,710)
Change in Amortized Cost $171,171
Total Earnings $380,227
Portfolio values as of June 30, 2023 excluding accrued interest.

Portfolio earnings and performance excludes funds in the California Asset Management Trust and the Local Agency Investment Fund.

City of Napa
Quarterly Investment Report - Summary and Performance
BofA ML 1-5 Year U.S. Treasury/Agency Index
Total Return Performance
Current
Quarter
Since Inception
(3/31/99)1 Year 5 Year
as of June 30, 2023
Portfolio Earnings

Page 1 of 10 ends

Attachment 2
Par Purchase Coupon Maturity Original Yield to Accrued Market CUSIP Description 3Q23 4Q23 Value Settlement Date Rate Date Cost Maturity Interest Value LAIF and CAMP
N/A California Asset Management Trust AAAm AAAm 25,799,509.71 6/30/2023 5.24% 7/1/2023 25,799,509.71 5.24% - 25,799,509.71 N/A Local Agency Investment Fund NR NR 72,189,771.02 6/30/2023 3.15% 7/1/2023 72,189,771.02 3.15% - 72,189,771.02 Total LAIF and CAMP 97,989,280.73 97,989,280.73 3.70% - 97,989,280.73 U.S. Treasuries
9128282U3 U.S. Treasury AA+ AA+ 2,130,000.00 5/9/2022 1.88% 8/31/2024 2,085,985.55 2.80% 13,348.68 2,046,463.96 91282CCX7 U.S. Treasury AA+ AA+ 1,750,000.00 10/6/2021 0.38% 9/15/2024 1,743,847.65 0.50% 1,925.95 1,649,375.00 91282CCX7 U.S. Treasury AA+ AA+ 3,000,000.00 10/6/2021 0.38% 9/15/2024 2,987,343.75 0.52% 3,301.63 2,827,500.00 9128282Y5 U.S. Treasury AA+ AA+ 1,320,000.00 12/4/2019 2.13% 9/30/2024 1,347,121.88 1.68% 7,050.82 1,269,262.50 91282CDB4 U.S. Treasury AA+ AA+ 1,000,000.00 10/15/2021 0.63% 10/15/2024 998,867.19 0.66% 1,314.89 942,031.20 9128283J7 U.S. Treasury AA+ AA+ 1,130,000.00 1/6/2020 2.13% 11/30/2024 1,154,498.05 1.66% 2,033.85 1,082,151.51 91282CDS7 U.S. Treasury AA+ AA+ 7,000,000.00 1/18/2022 1.13% 1/15/2025 6,977,851.56 1.23% 36,329.42 6,582,187.50 91282CDZ1 U.S. Treasury AA+ AA+ 3,900,000.00 5/9/2022 1.50% 2/15/2025 3,754,664.06 2.91% 21,977.90 3,681,234.18 912828ZT0 U.S. Treasury AA+ AA+ 3,500,000.00 10/6/2021 0.25% 5/31/2025 3,442,851.56 0.70% 741.12 3,202,500.00 912828XZ8 U.S. Treasury AA+ AA+ 1,545,000.00 12/4/2020 2.75% 6/30/2025 1,710,423.63 0.39% 115.46 1,481,993.05 91282CAB7 U.S. Treasury AA+ AA+ 525,000.00 5/5/2021 0.25% 7/31/2025 516,386.72 0.64% 547.48 477,585.94 912828K74 U.S. Treasury AA+ AA+ 300,000.00 11/4/2022 2.00% 8/15/2025 280,933.59 4.46% 2,254.14 282,937.50 91282CAJ0 U.S. Treasury AA+ AA+ 2,000,000.00 9/6/2022 0.25% 8/31/2025 1,815,312.50 3.54% 1,671.20 1,814,375.00 91282CAM3 U.S. Treasury AA+ AA+ 500,000.00 6/30/2021 0.25% 9/30/2025 489,414.06 0.76% 314.21 452,812.50 91282CAM3 U.S. Treasury AA+ AA+ 3,750,000.00 9/3/2021 0.25% 9/30/2025 3,693,017.58 0.63% 2,356.56 3,396,093.75 91282CFP1 U.S. Treasury N/A AA+ 3,600,000.00 5/17/2023 4.25% 10/15/2025 3,634,734.38 3.83% 32,188.52 3,559,500.00 91282CBC4 U.S. Treasury AA+ AA+ 3,000,000.00 2/2/2021 0.38% 12/31/2025 2,993,554.69 0.42% 30.57 2,704,218.60 91282CBH3 U.S. Treasury AA+ AA+ 1,315,000.00 3/3/2021 0.38% 1/31/2026 1,294,812.70 0.69% 2,056.96 1,180,417.90 91282CBH3 U.S. Treasury AA+ AA+ 2,000,000.00 4/5/2021 0.38% 1/31/2026 1,951,328.13 0.89% 3,128.45 1,795,312.40 91282CBH3 U.S. Treasury AA+ AA+ 675,000.00 9/3/2021 0.38% 1/31/2026 665,850.59 0.69% 1,055.85 605,917.94 91282CBH3 U.S. Treasury AA+ AA+ 5,000,000.00 1/18/2022 0.38% 1/31/2026 4,794,531.25 1.43% 7,821.13 4,488,281.00 91282CBQ3 U.S. Treasury AA+ AA+ 5,000,000.00 10/6/2021 0.50% 2/28/2026 4,919,140.63 0.88% 8,355.98 4,491,406.00 91282CBT7 U.S. Treasury AA+ AA+ 2,000,000.00 6/4/2021 0.75% 3/31/2026 1,999,218.75 0.76% 3,770.49 1,807,500.00 91282CBW0 U.S. Treasury AA+ AA+ 3,000,000.00 10/6/2021 0.75% 4/30/2026 2,979,140.63 0.91% 3,790.76 2,701,875.00 91282CCF6 U.S. Treasury AA+ AA+ 2,000,000.00 6/4/2021 0.75% 5/31/2026 1,995,781.25 0.79% 1,270.49 1,796,250.00 91282CCJ8 U.S. Treasury AA+ AA+ 2,285,000.00 8/4/2021 0.88% 6/30/2026 2,308,207.03 0.66% 54.33 2,058,642.19 91282CCJ8 U.S. Treasury AA+ AA+ 1,100,000.00 4/5/2022 0.88% 6/30/2026 1,022,656.25 2.64% 26.16 991,031.25 91282CCP4 U.S. Treasury AA+ AA+ 2,100,000.00 1/5/2022 0.63% 7/31/2026 2,035,195.31 1.32% 5,474.79 1,870,968.75 9128282A7 U.S. Treasury AA+ AA+ 2,580,000.00 5/4/2022 1.50% 8/15/2026 2,423,688.28 3.02% 14,539.23 2,358,281.25 91282CCZ2 U.S. Treasury AA+ AA+ 550,000.00 10/6/2021 0.88% 9/30/2026 548,281.25 0.94% 1,209.70 492,078.13 91282CCZ2 U.S. Treasury AA+ AA+ 2,000,000.00 10/6/2021 0.88% 9/30/2026 1,990,390.63 0.97% 4,398.91 1,789,375.00 912828YQ7 U.S. Treasury AA+ AA+ 2,050,000.00 12/16/2021 1.63% 10/31/2026 2,086,835.94 1.24% 5,612.43 1,874,468.75 91282CDG3 U.S. Treasury AA+ AA+ 1,200,000.00 1/18/2022 1.13% 10/31/2026 1,178,578.13 1.51% 2,274.45 1,079,250.00 91282CDG3 U.S. Treasury AA+ AA+ 650,000.00 2/14/2022 1.13% 10/31/2026 626,970.70 1.92% 1,232.00 584,593.75 912828U24 U.S. Treasury AA+ AA+ 2,000,000.00 5/9/2022 2.00% 11/15/2026 1,912,578.13 3.04% 5,108.70 1,850,000.00 91282CDK4 U.S. Treasury AA+ AA+ 1,200,000.00 12/3/2021 1.25% 11/30/2026 1,203,421.88 1.19% 1,270.49 1,081,125.00 912828V98 U.S. Treasury AA+ AA+ 1,825,000.00 7/6/2022 2.25% 2/15/2027 1,771,248.05 2.94% 15,426.80 1,696,964.94 912828V98 U.S. Treasury AA+ AA+ 6,030,000.00 8/5/2022 2.25% 2/15/2027 5,906,808.98 2.73% 50,971.82 5,606,958.11 91282CEN7 U.S. Treasury AA+ AA+ 1,350,000.00 12/7/2022 2.75% 4/30/2027 1,292,625.00 3.81% 6,254.76 1,275,328.13 912828X88 U.S. Treasury AA+ AA+ 1,800,000.00 9/6/2022 2.38% 5/15/2027 1,717,664.06 3.44% 5,459.92 1,676,250.00 912828X88 U.S. Treasury AA+ AA+ 2,900,000.00 11/4/2022 2.38% 5/15/2027 2,675,136.72 4.28% 8,796.53 2,700,625.00 City of Napa
Quarterly Investment Report - Holdings Report
as of June 30, 2023
FY Quarter
S&P Rating

Page 2 of 10 ends

Attachment 2
Par Purchase Coupon Maturity Original Yield to Accrued Market CUSIP Description 3Q23 4Q23 Value Settlement Date Rate Date Cost Maturity Interest Value City of Napa
Quarterly Investment Report - Holdings Report
as of June 30, 2023
FY Quarter
S&P Rating
91282CFB2 U.S. Treasury AA+ AA+ 960,000.00 1/5/2023 2.75% 7/31/2027 910,950.00 3.98% 11,012.15 905,100.00 91282CAH4 U.S. Treasury AA+ AA+ 2,800,000.00 12/7/2022 0.50% 8/31/2027 2,407,015.63 3.77% 4,679.35 2,401,875.00 91282CAU5 U.S. Treasury AA+ AA+ 2,440,000.00 1/5/2023 0.50% 10/31/2027 2,071,903.13 3.97% 2,055.43 2,082,387.50 9128283F5 U.S. Treasury AA+ AA+ 3,725,000.00 1/31/2023 2.25% 11/15/2027 3,489,713.87 3.70% 10,704.31 3,430,492.19 91282CBB6 U.S. Treasury N/A AA+ 2,800,000.00 5/17/2023 0.63% 12/31/2027 2,460,062.50 3.49% 47.55 2,392,250.00 9128283W8 U.S. Treasury N/A AA+ 3,900,000.00 4/6/2023 2.75% 2/15/2028 3,797,320.31 3.34% 40,292.82 3,665,390.82 91282CBZ3 U.S. Treasury N/A AA+ 3,000,000.00 6/5/2023 1.25% 4/30/2028 2,665,312.50 3.76% 6,317.93 2,620,781.40 Total U.S. Treasuries 112,185,000.00 108,729,176.61 2.06% 361,973.07 102,803,399.59 Federal Agencies
3130AUZC1 Federal Home Loan Banks N/A AA+ 4,000,000.00 4/6/2023 4.63% 3/14/2025 4,051,200.00 3.93% 68,861.11 3,967,388.00 3135G05X7 Federal National Mortgage Association AA+ AA+ 950,000.00 8/31/2020 0.38% 8/25/2025 945,744.00 0.47% 1,246.88 863,739.05 3137EAEX3 Federal Home Loan Mortgage Corporation AA+ AA+ 1,475,000.00 9/25/2020 0.38% 9/23/2025 1,470,560.25 0.44% 1,505.73 1,337,621.45 3135G06G3 Federal National Mortgage Association AA+ AA+ 540,000.00 11/12/2020 0.50% 11/7/2025 538,066.80 0.57% 405.00 488,799.36 Total Federal Agencies 6,965,000.00 7,005,571.05 2.53% 72,018.72 6,657,547.86 Federal Agency CMBSs
3137BTU25 Federal Home Loan Mortgage Corporation AA+ AA+ 494,585.61 2/2/2021 3.06% 11/1/2023 527,989.46 0.58% 1,262.02 490,299.11 3136AJB54 Federal National Mortgage Association AA+ AA+ 209,574.13 12/18/2019 3.35% 3/1/2024 219,758.13 2.14% 584.36 206,368.42 3137FBTA4 Federal Home Loan Mortgage Corporation AA+ AA+ 966,073.48 5/31/2022 3.06% 8/1/2024 967,356.53 3.00% 2,466.71 939,967.09 3137BGK24 Federal Home Loan Mortgage Corporation AA+ AA+ 785,000.00 3/25/2020 3.06% 12/1/2024 823,882.03 1.95% 2,003.06 758,821.73 3137BJP64 Federal Home Loan Mortgage Corporation AA+ AA+ 700,000.00 8/8/2022 3.21% 3/1/2025 694,777.34 3.51% 1,869.58 675,208.83 3137BSP72 Federal Home Loan Mortgage Corporation N/A AA+ 1,200,000.00 4/17/2023 2.65% 8/1/2026 1,145,390.63 4.14% 2,653.00 1,123,842.66 3137BTUM1 Federal Home Loan Mortgage Corporation N/A AA+ 1,380,000.00 5/24/2023 3.35% 11/1/2026 1,337,521.88 4.31% 3,849.05 1,317,729.58 3137BVZ82 Federal Home Loan Mortgage Corporation N/A AA+ 2,000,000.00 5/24/2023 3.43% 1/1/2027 1,939,453.13 4.34% 5,716.67 1,911,605.80 3137F1G44 Federal Home Loan Mortgage Corporation N/A AA+ 2,255,000.00 6/13/2023 3.24% 4/1/2027 2,160,836.13 4.44% 6,094.14 2,137,702.21 Total Federal Agency CMOs 9,990,233.22 9,816,965.26 3.71% 26,498.59 9,561,545.43 Municipals
797412DL4 San Diego County AAA AAA 500,000.00 7/22/2020 0.59% 5/1/2024 500,000.00 0.59% 494.17 480,485.00 040654XU4 Arizona St Transprtn Brd Highw AA+ AA+ 1,320,000.00 2/12/2020 1.96% 7/1/2024 1,320,000.00 1.96% 12,922.80 1,277,839.20
20772KJW0 State Of Connecticut AA- AA- 190,000.00 6/11/2020 2.00% 7/1/2024 190,000.00 2.00% 1,898.10 183,977.00 874857KK0 Tamalpais Union High School District NR NR 790,000.00 10/9/2019 2.02% 8/1/2024 790,000.00 2.02% 6,652.46 762,879.30 574193TQ1 Maryland St AAA AAA 400,000.00 8/5/2020 0.51% 8/1/2024 399,888.00 0.52% 850.00 379,484.00 797272QP9 San Diego Community College District AAA AAA 315,000.00 10/16/2019 2.05% 8/1/2024 315,000.00 2.05% 2,685.38 303,316.65 605581MZ7 Mississippi State AA AA 155,000.00 8/6/2020 0.57% 11/1/2024 155,000.00 0.57% 145.96 145,014.90 650036DT0 New York State Urban Development Corp NR NR 1,220,000.00 12/23/2020 0.87% 3/15/2025 1,220,000.00 0.87% 3,125.23 1,127,975.40 91412HGE7 University Of California AA AA 400,000.00 7/16/2020 0.88% 5/15/2025 400,000.00 0.88% 451.31 372,576.00 341271AD6 Florida St Hurrican Cat Fund AA AA 495,000.00 9/16/2020 1.26% 7/1/2025 495,000.00 1.26% 3,113.55 458,632.35 341271AD6 Florida St Hurrican Cat Fund AA AA 190,000.00 9/16/2020 1.26% 7/1/2025 191,343.30 1.11% 1,195.10 176,040.70 341271AD6 Florida St Hurrican Cat Fund AA AA 200,000.00 9/16/2020 1.26% 7/1/2025 201,326.00 1.12% 1,258.00 185,306.00 977123X78 Wisconsin Department of Transportation AAA AAA 820,000.00 7/30/2020 0.77% 7/1/2025 820,000.00 0.77% 3,173.40 754,154.00 798306WP7 San Juan, California NR NR 525,000.00 10/29/2020 0.85% 8/1/2025 525,000.00 0.85% 1,863.75 483,425.25 799408Z85 San Ramon Valley, California AA+ AA+ 525,000.00 10/20/2020 0.74% 8/1/2025 525,000.00 0.74% 1,618.75 480,653.25 54438CYK2 Los Angeles, California AA+ AA+ 530,000.00 11/10/2020 0.77% 8/1/2025 530,000.00 0.77% 1,707.04 486,598.30 60412AVJ9 Minnesota St AAA AAA 355,000.00 8/25/2020 0.63% 8/1/2025 355,000.00 0.63% 931.88 325,570.50 20772KEW5 State Of Connecticut AA- AA- 850,000.00 11/19/2020 3.74% 9/15/2025 966,985.50 0.83% 9,367.90 828,282.50

Page 3 of 10 ends

Attachment 2
Par Purchase Coupon Maturity Original Yield to Accrued Market CUSIP Description 3Q23 4Q23 Value Settlement Date Rate Date Cost Maturity Interest Value City of Napa
Quarterly Investment Report - Holdings Report
as of June 30, 2023
FY Quarter
S&P Rating
544647FC9 LA Unified School District NR NR 245,000.00 11/10/2021 1.46% 7/1/2026 245,000.00 1.46% 1,782.38 222,680.50 Total Municipals 10,025,000.00 10,144,542.80 1.15% 55,237.16 9,434,890.80 Supra-National Agencies
4581X0DZ8 Inter-American Development Bank AAA AAA 1,785,000.00 9/23/2021 0.50% 9/23/2024 1,783,679.10 0.52% 2,429.58 1,682,192.93 4581X0DK1 Inter-American Development Bank AAA AAA 1,125,000.00 2/23/2021 1.75% 3/14/2025 1,182,712.50 0.47% 5,851.56 1,064,166.75 Total Supranationals 2,910,000.00 2,966,391.60 0.50% 8,281.14 2,746,359.68 Certificates of Deposit
89115B6K1 Toronto-Dominion Bank A A 1,600,000.00 10/31/2022 5.60% 10/27/2025 1,600,000.00 5.58% 60,480.00 1,598,918.88 Total Certificates of Deposit 1,600,000.00 1,600,000.00 5.58% 60,480.00 1,598,918.88 Corporate Notes
025816CV9 American Express BBB+ BBB+ 400,000.00 5/3/2022 3.38% 5/3/2024 399,960.00 3.38% 2,175.00 392,150.40 02665WCZ2 American Honda Finance A- A- 125,000.00 7/16/2019 2.40% 6/27/2024 124,357.50 2.51% 33.33 121,193.13 38141EC23 Goldman Sachs Group Inc BBB+ BBB+ 1,100,000.00 7/18/2019 3.85% 7/8/2024 1,148,202.00 2.90% 20,351.53 1,079,306.80 91159HHX1 US Bancorp A+ A 1,085,000.00 8/1/2019 2.40% 7/30/2024 1,084,034.35 2.42% 10,922.33 1,046,791.73 05565EBU8 Bmw Financial Services Na Llc A A 245,000.00 8/12/2021 0.75% 8/12/2024 244,977.95 0.75% 709.48 232,286.22 904764BN6 Unilever Plc A+ A+ 100,000.00 8/12/2021 0.63% 8/12/2024 100,000.00 0.63% 241.71 94,588.90 254687FK7 The Walt Disney Corporation BBB+ A- 1,085,000.00 9/6/2019 1.75% 8/30/2024 1,080,573.20 1.84% 6,381.91 1,040,627.84
12189LAT8 Burlington Northern Santa Fe AA- AA- 800,000.00 2/26/2020 3.40% 9/1/2024 858,240.00 1.72% 9,066.67 780,104.80 06406RAL1 Bank of New York Mellon A A 180,000.00 1/28/2020 2.10% 10/24/2024 180,792.00 2.00% 703.50 171,979.38 693475AY1 PNC Financial Services Group A- A- 700,000.00 11/8/2019 2.20% 11/1/2024 699,769.00 2.21% 2,566.67 664,853.70 89236TGT6 Toyota Motor Corp A+ A+ 500,000.00 5/26/2020 1.80% 2/13/2025 504,885.00 1.58% 3,450.00 473,486.50 89236TGT6 Toyota Motor Corp A+ A+ 390,000.00 5/26/2020 1.80% 2/13/2025 393,810.30 1.58% 2,691.00 369,319.47 771196BT8 Roche Holdings AA AA 1,725,000.00 3/10/2022 2.13% 3/10/2025 1,725,000.00 2.13% 11,339.58 1,639,973.03 05565EBK0 Bmw Financial Services Na Llc A A 660,000.00 8/16/2021 3.90% 4/9/2025 725,432.40 1.12% 5,863.00 643,879.50 437076CM2 Home Depot Inc A A 125,000.00 3/28/2022 2.70% 4/15/2025 124,781.25 2.76% 712.50 119,650.50 06051GKS7 Bank Of America Co A- A- 400,000.00 4/27/2022 3.84% 4/25/2025 399,852.00 3.85% 2,816.73 391,583.20 037833DT4 Apple Inc AA+ AA+ 800,000.00 5/14/2020 1.13% 5/11/2025 801,680.00 1.08% 1,250.00 744,382.40 166764BW9 Chevron Corporation AA- AA- 500,000.00 5/15/2020 1.55% 5/11/2025 502,480.00 1.45% 1,079.17 468,308.00 369550BG2 General Dynamics Corp. A- A- 900,000.00 3/8/2021 3.50% 5/15/2025 993,708.00 0.96% 4,025.00 873,677.70 63743HFE7 National Rural Utilities Co Finance Corp A- A- 265,000.00 5/4/2022 3.45% 6/15/2025 264,928.45 3.46% 406.33 254,963.13 06051GFS3 Bank Of America Co A- A- 815,000.00 9/1/2020 3.88% 8/1/2025 930,925.60 0.91% 13,158.85 789,998.25 61747YEG6 Morgan Stanley A- A- 180,000.00 10/19/2021 1.16% 10/21/2025 180,000.00 1.16% 407.40 168,160.50 61747YEG6 Morgan Stanley A- A- 500,000.00 5/20/2022 1.16% 10/21/2025 467,560.00 3.18% 1,131.67 467,112.50 172967KG5 Citigroup Inc BBB+ BBB+ 900,000.00 10/6/2021 3.70% 1/12/2026 990,855.00 1.26% 15,632.50 862,820.10 17327CAN3 Citigroup Inc BBB+ BBB+ 245,000.00 1/25/2022 2.01% 1/25/2026 245,000.00 2.01% 2,138.20 230,243.65 46647PBH8 JPMorgan Chase A- A- 795,000.00 10/6/2021 2.01% 3/13/2026 816,393.45 1.38% 4,781.93 747,033.68 06051GKM0 Bank Of America Co A- A- 1,000,000.00 5/10/2022 3.38% 4/2/2026 979,350.00 3.96% 8,366.00 958,256.00 46647PCZ7 JPMorgan Chase A- A- 500,000.00 4/26/2022 4.08% 4/26/2026 499,740.00 4.09% 3,683.33 486,252.50 04636NAA1 Astrazeneca A A 500,000.00 7/19/2021 1.20% 5/28/2026 500,530.00 1.18% 550.00 451,261.50 24422EWX3 Deere & Company N/A A 685,000.00 6/8/2023 4.75% 6/8/2026 684,602.70 4.77% 2,078.79 682,840.20 24422EWX3 Deere & Company N/A A 390,000.00 6/8/2023 4.75% 6/8/2026 390,581.10 4.70% 1,183.54 388,770.33 427866AX6 Hershey Co. A A 1,730,000.00 1/30/2023 2.30% 8/15/2026 1,615,543.20 4.33% 15,031.78 1,614,631.49 025816CM9 American Express BBB+ BBB+ 800,000.00 12/16/2021 1.65% 11/4/2026 798,760.00 1.68% 2,090.00 712,203.20 24422EWA3 Deere & Company A A 500,000.00 1/13/2022 1.70% 1/11/2027 497,180.00 1.82% 4,013.89 450,204.50

Page 4 of 10 ends

Attachment A
Par Purchase Coupon Maturity Original Yield to Accrued Market CUSIP Description 3Q23 4Q23 Value Settlement Date Rate Date Cost Maturity Interest Value City of Napa
Quarterly Investment Report - Holdings Report
as of June 30, 2023
FY Quarter
S&P Rating
87612EBM7 Target Corp A A 215,000.00 1/24/2022 1.95% 1/15/2027 214,634.50 1.99% 1,933.21 196,730.59 87612EBM7 Target Corp A A 800,000.00 1/25/2022 1.95% 1/15/2027 801,752.00 1.90% 7,193.33 732,020.80 06406RBA4 Bank of New York Mellon A A 700,000.00 1/28/2022 2.05% 1/26/2027 700,847.00 2.02% 6,178.47 629,141.80 459200KM2 IBM A- A- 500,000.00 2/25/2022 2.20% 2/9/2027 493,830.00 2.47% 4,338.89 454,172.50 459200KM2 IBM A- A- 900,000.00 5/20/2022 2.20% 2/9/2027 841,185.00 3.72% 7,810.00 817,510.50 438516CE4 Honeywell International A A 800,000.00 3/3/2022 1.10% 3/1/2027 762,624.00 2.09% 2,933.33 705,229.60 89788MAD4 Truist Fin Corp A- A- 1,200,000.00 3/14/2022 1.27% 3/2/2027 1,127,520.00 2.57% 5,025.77 1,058,372.40 89788MAD4 Truist Fin Corp A- A- 1,200,000.00 3/14/2022 1.27% 3/2/2027 1,086,720.00 3.42% 5,025.77 1,058,372.40 89236TJZ9 Toyota Motor Corp A+ A+ 1,000,000.00 5/10/2022 3.05% 3/22/2027 968,140.00 3.77% 8,387.50 935,172.00 023135CF1 Amazon.Com Inc AA AA 1,000,000.00 5/20/2022 3.30% 4/13/2027 989,180.00 3.54% 7,150.00 952,224.00 437076CN0 Home Depot Inc A A 1,200,000.00 5/10/2022 2.88% 4/15/2027 1,161,660.00 3.59% 7,283.33 1,126,360.80 665859AW4 Northern Trust A+ A+ 800,000.00 5/12/2022 4.00% 5/10/2027 807,728.00 3.79% 4,533.33 769,196.80 665859AW4 Northern Trust A+ A+ 400,000.00 5/20/2022 4.00% 5/10/2027 403,848.00 3.79% 2,266.67 384,598.40 91324PEG3 Unitedhealth Group Inc A+ A+ 200,000.00 5/20/2022 3.70% 5/15/2027 199,892.00 3.71% 945.56 192,578.40 63254ABE7 National Australia Bank Ltd AA- AA- 1,000,000.00 6/13/2022 3.91% 6/9/2027 991,330.00 4.10% 2,386.39 954,941.00 458140BY5 Intel Corporation A A 1,200,000.00 8/12/2022 3.75% 8/5/2027 1,201,452.00 3.72% 18,250.00 1,146,948.00 931142EX7 Wal-Mart Stores AA AA 1,200,000.00 9/14/2022 3.95% 9/9/2027 1,201,944.00 3.91% 14,746.67 1,176,076.80 57636QAW4 Mastercard Inc A+ A+ 920,000.00 3/17/2023 4.88% 3/9/2028 922,364.40 4.82% 13,953.33 929,335.24 63743HFG2 National Rural Utilities Co Finance Corp N/A A- 1,085,000.00 6/13/2023 4.80% 3/15/2028 1,081,820.95 4.87% 15,334.67 1,073,636.80 369550BC1 General Dynamics Corp. N/A A- 850,000.00 5/17/2023 3.75% 5/15/2028 831,351.00 4.24% 4,072.92 813,586.85 30303M8L9 Meta Platforms N/A AA- 1,080,000.00 6/5/2023 4.60% 5/15/2028 1,081,620.00 4.56% 8,004.00 1,066,956.84 539830BZ1 Lockheed Martin Corp N/A A- 170,000.00 5/25/2023 4.45% 5/15/2028 169,694.00 4.49% 756.50 167,469.55 539830BZ1 Lockheed Martin Corp N/A A- 480,000.00 6/6/2023 4.45% 5/15/2028 478,272.00 4.53% 2,136.00 472,855.20 63253QAE4 National Australia Bank Ltd N/A AA- 1,585,000.00 6/13/2023 4.90% 6/13/2028 1,582,289.65 4.94% 3,883.25 1,569,766.57 Total Corporate Notes 42,110,000.00 42,056,182.95 3.03% 315,562.21 39,996,148.57 Asset-Backed Securities
89238EAC0 Toyota Lease Owner Trust AAA AAA 41,025.59 4/21/2021 0.39% 4/22/2024 41,020.80 0.39% 4.89 40,922.32 380144AC9 GM Financial Auto Leasing Trust AAA AAA 71,728.98 5/26/2021 0.34% 5/20/2024 71,717.72 0.35% 7.45 71,560.12 65479CAD0 Nissan Auto Receivables AAA AAA 2,530.98 6/30/2020 0.55% 7/15/2024 2,530.91 0.55% 0.62 2,527.45 05591RAD6 BMW Financial Services NA LLC AAA AAA 103,002.08 3/10/2021 0.37% 7/25/2024 102,997.99 0.37% 6.35 102,524.72 89237VAB5 Toyota Motor Corp AAA AAA 45,235.21 7/27/2020 0.44% 10/15/2024 45,231.74 0.44% 8.85 44,934.59 14315XAC2 Carmax Auto Owner Trust AAA AAA 15,288.37 1/22/2020 1.89% 12/16/2024 15,285.37 1.89% 12.84 15,217.50 92290BAA9 Verizon Owner Trust NR NR 71,639.05 8/12/2020 0.47% 2/20/2025 71,624.00 0.47% 10.29 71,167.41 14315FAD9 Carmax Auto Owner Trust AAA AAA 11,961.18 7/22/2020 0.62% 3/17/2025 11,959.13 0.62% 3.30 11,862.19 362590AC5 Gm Financial Securitized Term NR NR 91,132.18 8/19/2020 0.45% 4/16/2025 91,111.32 0.45% 17.09 89,835.20 50117TAC5 Kubota Credit NR NR 168,401.95 4/14/2021 0.62% 8/15/2025 168,367.50 0.62% 46.40 162,649.93 44933LAC7 Hyundai Auto Receivables AAA AAA 153,891.66 4/28/2021 0.38% 9/15/2025 153,875.47 0.38% 25.99 149,958.40 43815EAC8 Honda Auto Receivables AAA AAA 325,606.86 8/25/2021 0.41% 11/18/2025 325,602.10 0.41% 48.21 313,340.11 14316NAC3 Carmax Auto Owner Trust AAA AAA 71,342.19 1/27/2021 0.34% 12/15/2025 71,328.09 0.34% 10.78 69,277.43 43815GAC3 Honda Auto Receivables NR NR 460,000.00 11/24/2021 0.88% 1/21/2026 459,903.03 0.89% 112.44 442,247.91 14314QAC8 Carmax Auto Owner Trust AAA AAA 251,316.37 4/21/2021 0.52% 2/17/2026 251,262.22 0.52% 58.08 242,478.00 345286AC2 Ford Credit Auto Owner Trust AAA AAA 385,000.00 1/24/2022 1.29% 6/15/2026 384,954.26 1.29% 220.73 369,630.88 05602RAD3 Bmw Vehicle Owner Trust AAA AAA 450,000.00 5/18/2022 3.21% 8/25/2026 449,976.60 3.21% 240.75 437,560.83 448977AD0 Hyundai Auto Receivables AAA AAA 830,000.00 3/16/2022 2.22% 10/15/2026 829,968.05 2.22% 818.93 796,892.88 98163KAC6 World Omni Auto Rec Trust AAA AAA 350,000.00 11/3/2021 0.81% 10/15/2026 349,952.33 0.81% 126.00 335,754.34 14041NFY2 Capital One Financial Corp AAA AAA 1,075,000.00 11/30/2021 1.04% 11/15/2026 1,074,851.87 1.04% 496.89 1,011,932.33

Page 5 of 10 ends

Page 6 of 10 ends

Attachment 2
S&P Par Purchase Coupon Maturity Original Yield to Accrued Market Days to CUSIP Description Rating Value Settlement Date Rate Date Cost Maturity Interest Value Maturity LAIF and CAMP
N/A California Asset Management Trust AAAm 25,799,509.71 6/30/2023 5.24% 7/1/2023 25,799,509.71 5.24% - 25,799,509.71 1 N/A Local Agency Investment Fund NR 72,189,771.02 6/30/2023 3.15% 7/1/2023 72,189,771.02 3.15% - 72,189,771.02 1 Total LAIF and CAMP 97,989,280.73 97,989,280.73 - 97,989,280.73 Other
3137BTU25 Federal Home Loan Mortgage Corporation AA+ 494,585.61 2/2/2021 3.06% 11/1/2023 527,989.46 0.58% 1,262.02 490,299.11 124 3136AJB54 Federal National Mortgage Association AA+ 209,574.13 12/18/2019 3.35% 3/1/2024 219,758.13 2.14% 584.36 206,368.42 245 89238EAC0 Toyota Lease Owner Trust AAA 41,025.59 4/21/2021 0.39% 4/22/2024 41,020.80 0.39% 4.89 40,922.32 297 797412DL4 San Diego County AAA 500,000.00 7/22/2020 0.59% 5/1/2024 500,000.00 0.59% 494.17 480,485.00 306 025816CV9 American Express BBB+ 400,000.00 5/3/2022 3.38% 5/3/2024 399,960.00 3.38% 2,175.00 392,150.40 308 380144AC9 GM Financial Auto Leasing Trust AAA 71,728.98 5/26/2021 0.34% 5/20/2024 71,717.72 0.35% 7.45 71,560.12 325 02665WCZ2 American Honda Finance A- 125,000.00 7/16/2019 2.40% 6/27/2024 124,357.50 2.51% 33.33 121,193.13 363 040654XU4 Arizona St Transprtn Brd Highw AA+ 1,320,000.00 2/12/2020 1.96% 7/1/2024 1,320,000.00 1.96% 12,922.80 1,277,839.20 367 20772KJW0 State Of Connecticut AA- 190,000.00 6/11/2020 2.00% 7/1/2024 190,000.00 2.00% 1,898.10 183,977.00 367 38141EC23 Goldman Sachs Group Inc BBB+ 1,100,000.00 7/18/2019 3.85% 7/8/2024 1,148,202.00 2.90% 20,351.53 1,079,306.80 374 65479CAD0 Nissan Auto Receivables AAA 2,530.98 6/30/2020 0.55% 7/15/2024 2,530.91 0.55% 0.62 2,527.45 381 05591RAD6 BMW Financial Services NA LLC AAA 103,002.08 3/10/2021 0.37% 7/25/2024 102,997.99 0.37% 6.35 102,524.72 391 91159HHX1 US Bancorp A 1,085,000.00 8/1/2019 2.40% 7/30/2024 1,084,034.35 2.42% 10,922.33 1,046,791.73 396 3137FBTA4 Federal Home Loan Mortgage Corporation AA+ 966,073.48 5/31/2022 3.06% 8/1/2024 967,356.53 3.00% 2,466.71 939,967.09 398 874857KK0 Tamalpais Union High School District NR 790,000.00 10/9/2019 2.02% 8/1/2024 790,000.00 2.02% 6,652.46 762,879.30 398 574193TQ1 Maryland St AAA 400,000.00 8/5/2020 0.51% 8/1/2024 399,888.00 0.52% 850.00 379,484.00 398 797272QP9 San Diego Community College District AAA 315,000.00 10/16/2019 2.05% 8/1/2024 315,000.00 2.05% 2,685.38 303,316.65 398 05565EBU8 Bmw Financial Services Na Llc A 245,000.00 8/12/2021 0.75% 8/12/2024 244,977.95 0.75% 709.48 232,286.22 409 904764BN6 Unilever Plc A+ 100,000.00 8/12/2021 0.63% 8/12/2024 100,000.00 0.63% 241.71 94,588.90 409 254687FK7 The Walt Disney Corporation A- 1,085,000.00 9/6/2019 1.75% 8/30/2024 1,080,573.20 1.84% 6,381.91 1,040,627.84 427 9128282U3 U.S. Treasury AA+ 2,130,000.00 5/9/2022 1.88% 8/31/2024 2,085,985.55 2.80% 13,348.68 2,046,463.96 428 12189LAT8 Burlington Northern Santa Fe AA- 800,000.00 2/26/2020 3.40% 9/1/2024 858,240.00 1.72% 9,066.67 780,104.80 429 91282CCX7 U.S. Treasury AA+ 1,750,000.00 10/6/2021 0.38% 9/15/2024 1,743,847.65 0.50% 1,925.95 1,649,375.00 443 91282CCX7 U.S. Treasury AA+ 3,000,000.00 10/6/2021 0.38% 9/15/2024 2,987,343.75 0.52% 3,301.63 2,827,500.00 443 4581X0DZ8 Inter-American Development Bank AAA 1,785,000.00 9/23/2021 0.50% 9/23/2024 1,783,679.10 0.52% 2,429.58 1,682,192.93 451 9128282Y5 U.S. Treasury AA+ 1,320,000.00 12/4/2019 2.13% 9/30/2024 1,347,121.88 1.68% 7,050.82 1,269,262.50 458 89237VAB5 Toyota Motor Corp AAA 45,235.21 7/27/2020 0.44% 10/15/2024 45,231.74 0.44% 8.85 44,934.59 473 91282CDB4 U.S. Treasury AA+ 1,000,000.00 10/15/2021 0.63% 10/15/2024 998,867.19 0.66% 1,314.89 942,031.20 473 06406RAL1 Bank of New York Mellon A 180,000.00 1/28/2020 2.10% 10/24/2024 180,792.00 2.00% 703.50 171,979.38 482 605581MZ7 Mississippi State AA 155,000.00 8/6/2020 0.57% 11/1/2024 155,000.00 0.57% 145.96 145,014.90 490 693475AY1 PNC Financial Services Group A- 700,000.00 11/8/2019 2.20% 11/1/2024 699,769.00 2.21% 2,566.67 664,853.70 490 9128283J7 U.S. Treasury AA+ 1,130,000.00 1/6/2020 2.13% 11/30/2024 1,154,498.05 1.66% 2,033.85 1,082,151.51 519 3137BGK24 Federal Home Loan Mortgage Corporation AA+ 785,000.00 3/25/2020 3.06% 12/1/2024 823,882.03 1.95% 2,003.06 758,821.73 520 14315XAC2 Carmax Auto Owner Trust AAA 15,288.37 1/22/2020 1.89% 12/16/2024 15,285.37 1.89% 12.84 15,217.50 535 91282CDS7 U.S. Treasury AA+ 7,000,000.00 1/18/2022 1.13% 1/15/2025 6,977,851.56 1.23% 36,329.42 6,582,187.50 565 89236TGT6 Toyota Motor Corp A+ 500,000.00 5/26/2020 1.80% 2/13/2025 504,885.00 1.58% 3,450.00 473,486.50 594 89236TGT6 Toyota Motor Corp A+ 390,000.00 5/26/2020 1.80% 2/13/2025 393,810.30 1.58% 2,691.00 369,319.47 594 91282CDZ1 U.S. Treasury AA+ 3,900,000.00 5/9/2022 1.50% 2/15/2025 3,754,664.06 2.91% 21,977.90 3,681,234.18 596 92290BAA9 Verizon Owner Trust NR 71,639.05 8/12/2020 0.47% 2/20/2025 71,624.00 0.47% 10.29 71,167.41 601 City of Napa
Quarterly Investment Report - Maturity Report
as of June 30, 2023

Page 7 of 10 ends

Attachment 2
S&P Par Purchase Coupon Maturity Original Yield to Accrued Market Days to CUSIP Description Rating Value Settlement Date Rate Date Cost Maturity Interest Value Maturity City of Napa
Quarterly Investment Report - Maturity Report
as of June 30, 2023
3137BJP64 Federal Home Loan Mortgage Corporation AA+ 700,000.00 8/8/2022 3.21% 3/1/2025 694,777.34 3.51% 1,869.58 675,208.83 610 771196BT8 Roche Holdings AA 1,725,000.00 3/10/2022 2.13% 3/10/2025 1,725,000.00 2.13% 11,339.58 1,639,973.03 619 3130AUZC1 Federal Home Loan Banks AA+ 4,000,000.00 4/6/2023 4.63% 3/14/2025 4,051,200.00 3.93% 68,861.11 3,967,388.00 623 4581X0DK1 Inter-American Development Bank AAA 1,125,000.00 2/23/2021 1.75% 3/14/2025 1,182,712.50 0.47% 5,851.56 1,064,166.75 623 650036DT0 New York State Urban Development Corp NR 1,220,000.00 12/23/2020 0.87% 3/15/2025 1,220,000.00 0.87% 3,125.23 1,127,975.40 624 14315FAD9 Carmax Auto Owner Trust AAA 11,961.18 7/22/2020 0.62% 3/17/2025 11,959.13 0.62% 3.30 11,862.19 626 05565EBK0 Bmw Financial Services Na Llc A 660,000.00 8/16/2021 3.90% 4/9/2025 725,432.40 1.12% 5,863.00 643,879.50 649 437076CM2 Home Depot Inc A 125,000.00 3/28/2022 2.70% 4/15/2025 124,781.25 2.76% 712.50 119,650.50 655 362590AC5 Gm Financial Securitized Term NR 91,132.18 8/19/2020 0.45% 4/16/2025 91,111.32 0.45% 17.09 89,835.20 656 06051GKS7 Bank Of America Co A- 400,000.00 4/27/2022 3.84% 4/25/2025 399,852.00 3.85% 2,816.73 391,583.20 665 037833DT4 Apple Inc AA+ 800,000.00 5/14/2020 1.13% 5/11/2025 801,680.00 1.08% 1,250.00 744,382.40 681 166764BW9 Chevron Corporation AA- 500,000.00 5/15/2020 1.55% 5/11/2025 502,480.00 1.45% 1,079.17 468,308.00 681 369550BG2 General Dynamics Corp. A- 900,000.00 3/8/2021 3.50% 5/15/2025 993,708.00 0.96% 4,025.00 873,677.70 685 91412HGE7 University Of California AA 400,000.00 7/16/2020 0.88% 5/15/2025 400,000.00 0.88% 451.31 372,576.00 685 912828ZT0 U.S. Treasury AA+ 3,500,000.00 10/6/2021 0.25% 5/31/2025 3,442,851.56 0.70% 741.12 3,202,500.00 701 63743HFE7 National Rural Utilities Co Finance Corp A- 265,000.00 5/4/2022 3.45% 6/15/2025 264,928.45 3.46% 406.33 254,963.13 716 912828XZ8 U.S. Treasury AA+ 1,545,000.00 12/4/2020 2.75% 6/30/2025 1,710,423.63 0.39% 115.46 1,481,993.05 731 341271AD6 Florida St Hurrican Cat Fund AA 495,000.00 9/16/2020 1.26% 7/1/2025 495,000.00 1.26% 3,113.55 458,632.35 732 341271AD6 Florida St Hurrican Cat Fund AA 190,000.00 9/16/2020 1.26% 7/1/2025 191,343.30 1.11% 1,195.10 176,040.70 732 341271AD6 Florida St Hurrican Cat Fund AA 200,000.00 9/16/2020 1.26% 7/1/2025 201,326.00 1.12% 1,258.00 185,306.00 732 977123X78 Wisconsin Department of Transportation AAA 820,000.00 7/30/2020 0.77% 7/1/2025 820,000.00 0.77% 3,173.40 754,154.00 732 91282CAB7 U.S. Treasury AA+ 525,000.00 5/5/2021 0.25% 7/31/2025 516,386.72 0.64% 547.48 477,585.94 762 06051GFS3 Bank Of America Co A- 815,000.00 9/1/2020 3.88% 8/1/2025 930,925.60 0.91% 13,158.85 789,998.25 763 798306WP7 San Juan, California NR 525,000.00 10/29/2020 0.85% 8/1/2025 525,000.00 0.85% 1,863.75 483,425.25 763 799408Z85 San Ramon Valley, California AA+ 525,000.00 10/20/2020 0.74% 8/1/2025 525,000.00 0.74% 1,618.75 480,653.25 763 54438CYK2 Los Angeles, California AA+ 530,000.00 11/10/2020 0.77% 8/1/2025 530,000.00 0.77% 1,707.04 486,598.30 763 60412AVJ9 Minnesota St AAA 355,000.00 8/25/2020 0.63% 8/1/2025 355,000.00 0.63% 931.88 325,570.50 763 50117TAC5 Kubota Credit NR 168,401.95 4/14/2021 0.62% 8/15/2025 168,367.50 0.62% 46.40 162,649.93 777 912828K74 U.S. Treasury AA+ 300,000.00 11/4/2022 2.00% 8/15/2025 280,933.59 4.46% 2,254.14 282,937.50 777 3135G05X7 Federal National Mortgage Association AA+ 950,000.00 8/31/2020 0.38% 8/25/2025 945,744.00 0.47% 1,246.88 863,739.05 787 91282CAJ0 U.S. Treasury AA+ 2,000,000.00 9/6/2022 0.25% 8/31/2025 1,815,312.50 3.54% 1,671.20 1,814,375.00 793 20772KEW5 State Of Connecticut AA- 850,000.00 11/19/2020 3.74% 9/15/2025 966,985.50 0.83% 9,367.90 828,282.50 808 44933LAC7 Hyundai Auto Receivables AAA 153,891.66 4/28/2021 0.38% 9/15/2025 153,875.47 0.38% 25.99 149,958.40 808 3137EAEX3 Federal Home Loan Mortgage Corporation AA+ 1,475,000.00 9/25/2020 0.38% 9/23/2025 1,470,560.25 0.44% 1,505.73 1,337,621.45 816 91282CAM3 U.S. Treasury AA+ 500,000.00 6/30/2021 0.25% 9/30/2025 489,414.06 0.76% 314.21 452,812.50 823 91282CAM3 U.S. Treasury AA+ 3,750,000.00 6/30/2021 0.25% 9/30/2025 3,693,017.58 0.63% 2,356.56 3,396,093.75 823 91282CFP1 U.S. Treasury AA+ 3,600,000.00 5/17/2023 4.25% 10/15/2025 3,634,734.38 3.83% 32,188.52 3,559,500.00 838 61747YEG6 Morgan Stanley A- 180,000.00 10/19/2021 1.16% 10/21/2025 180,000.00 1.16% 407.40 168,160.50 844 61747YEG6 Morgan Stanley A- 500,000.00 10/19/2021 1.16% 10/21/2025 467,560.00 3.18% 1,131.67 467,112.50 844 89115B6K1 Toronto-Dominion Bank A 1,600,000.00 10/31/2022 5.60% 10/27/2025 1,600,000.00 5.58% 60,480.00 1,598,918.88 850 3135G06G3 Federal National Mortgage Association AA+ 540,000.00 11/12/2020 0.50% 11/7/2025 538,066.80 0.57% 405.00 488,799.36 861 43815EAC8 Honda Auto Receivables AAA 325,606.86 8/25/2021 0.41% 11/18/2025 325,602.10 0.41% 48.21 313,340.11 872 14316NAC3 Carmax Auto Owner Trust AAA 71,342.19 1/27/2021 0.34% 12/15/2025 71,328.09 0.34% 10.78 69,277.43 899 91282CBC4 U.S. Treasury AA+ 3,000,000.00 2/2/2021 0.38% 12/31/2025 2,993,554.69 0.42% 30.57 2,704,218.60 915 172967KG5 Citigroup Inc BBB+ 900,000.00 10/6/2021 3.70% 1/12/2026 990,855.00 1.26% 15,632.50 862,820.10 927 43815GAC3 Honda Auto Receivables NR 460,000.00 11/24/2021 0.88% 1/21/2026 459,903.03 0.89% 112.44 442,247.91 936

Page 8 of 10 ends

Attachment 2
S&P Par Purchase Coupon Maturity Original Yield to Accrued Market Days to CUSIP Description Rating Value Settlement Date Rate Date Cost Maturity Interest Value Maturity City of Napa
Quarterly Investment Report - Maturity Report
as of June 30, 2023
17327CAN3 Citigroup Inc BBB+ 245,000.00 1/25/2022 2.01% 1/25/2026 245,000.00 2.01% 2,138.20 230,243.65 940 91282CBH3 U.S. Treasury AA+ 1,315,000.00 3/3/2021 0.38% 1/31/2026 1,294,812.70 0.69% 2,056.96 1,180,417.90 946 91282CBH3 U.S. Treasury AA+ 2,000,000.00 3/3/2021 0.38% 1/31/2026 1,951,328.13 0.89% 3,128.45 1,795,312.40 946 91282CBH3 U.S. Treasury AA+ 675,000.00 3/3/2021 0.38% 1/31/2026 665,850.59 0.69% 1,055.85 605,917.94 946 91282CBH3 U.S. Treasury AA+ 5,000,000.00 3/3/2021 0.38% 1/31/2026 4,794,531.25 1.43% 7,821.13 4,488,281.00 946 14314QAC8 Carmax Auto Owner Trust AAA 251,316.37 4/21/2021 0.52% 2/17/2026 251,262.22 0.52% 58.08 242,478.00 963 91282CBQ3 U.S. Treasury AA+ 5,000,000.00 10/6/2021 0.50% 2/28/2026 4,919,140.63 0.88% 8,355.98 4,491,406.00 974 46647PBH8 JPMorgan Chase A- 795,000.00 10/6/2021 2.01% 3/13/2026 816,393.45 1.38% 4,781.93 747,033.68 987 91282CBT7 U.S. Treasury AA+ 2,000,000.00 6/4/2021 0.75% 3/31/2026 1,999,218.75 0.76% 3,770.49 1,807,500.00 1,005 06051GKM0 Bank Of America Co A- 1,000,000.00 5/10/2022 3.38% 4/2/2026 979,350.00 3.96% 8,366.00 958,256.00 1,007 46647PCZ7 JPMorgan Chase A- 500,000.00 4/26/2022 4.08% 4/26/2026 499,740.00 4.09% 3,683.33 486,252.50 1,031 91282CBW0 U.S. Treasury AA+ 3,000,000.00 10/6/2021 0.75% 4/30/2026 2,979,140.63 0.91% 3,790.76 2,701,875.00 1,035 04636NAA1 Astrazeneca A 500,000.00 7/19/2021 1.20% 5/28/2026 500,530.00 1.18% 550.00 451,261.50 1,063 91282CCF6 U.S. Treasury AA+ 2,000,000.00 6/4/2021 0.75% 5/31/2026 1,995,781.25 0.79% 1,270.49 1,796,250.00 1,066 24422EWX3 Deere & Company A 685,000.00 6/8/2023 4.75% 6/8/2026 684,602.70 4.77% 2,078.79 682,840.20 1,074 24422EWX3 Deere & Company A 390,000.00 6/8/2023 4.75% 6/8/2026 390,581.10 4.70% 1,183.54 388,770.33 1,074 345286AC2 Ford Credit Auto Owner Trust AAA 385,000.00 1/24/2022 1.29% 6/15/2026 384,954.26 1.29% 220.73 369,630.88 1,081 91282CCJ8 U.S. Treasury AA+ 2,285,000.00 8/4/2021 0.88% 6/30/2026 2,308,207.03 0.66% 54.33 2,058,642.19 1,096 91282CCJ8 U.S. Treasury AA+ 1,100,000.00 8/4/2021 0.88% 6/30/2026 1,022,656.25 2.64% 26.16 991,031.25 1,096 544647FC9 LA Unified School District NR 245,000.00 11/10/2021 1.46% 7/1/2026 245,000.00 1.46% 1,782.38 222,680.50 1,097 91282CCP4 U.S. Treasury AA+ 2,100,000.00 1/5/2022 0.63% 7/31/2026 2,035,195.31 1.32% 5,474.79 1,870,968.75 1,127 3137BSP72 Federal Home Loan Mortgage Corporation AA+ 1,200,000.00 4/17/2023 2.65% 8/1/2026 1,145,390.63 4.14% 2,653.00 1,123,842.66 1,128 427866AX6 Hershey Co. A 1,730,000.00 1/30/2023 2.30% 8/15/2026 1,615,543.20 4.33% 15,031.78 1,614,631.49 1,142 9128282A7 U.S. Treasury AA+ 2,580,000.00 5/4/2022 1.50% 8/15/2026 2,423,688.28 3.02% 14,539.23 2,358,281.25 1,142 05602RAD3 Bmw Vehicle Owner Trust AAA 450,000.00 5/18/2022 3.21% 8/25/2026 449,976.60 3.21% 240.75 437,560.83 1,152 91282CCZ2 U.S. Treasury AA+ 550,000.00 10/6/2021 0.88% 9/30/2026 548,281.25 0.94% 1,209.70 492,078.13 1,188 91282CCZ2 U.S. Treasury AA+ 2,000,000.00 10/6/2021 0.88% 9/30/2026 1,990,390.63 0.97% 4,398.91 1,789,375.00 1,188 448977AD0 Hyundai Auto Receivables AAA 830,000.00 3/16/2022 2.22% 10/15/2026 829,968.05 2.22% 818.93 796,892.88 1,203 98163KAC6 World Omni Auto Rec Trust AAA 350,000.00 11/3/2021 0.81% 10/15/2026 349,952.33 0.81% 126.00 335,754.34 1,203 912828YQ7 U.S. Treasury AA+ 2,050,000.00 12/16/2021 1.63% 10/31/2026 2,086,835.94 1.24% 5,612.43 1,874,468.75 1,219 91282CDG3 U.S. Treasury AA+ 1,200,000.00 1/18/2022 1.13% 10/31/2026 1,178,578.13 1.51% 2,274.45 1,079,250.00 1,219 91282CDG3 U.S. Treasury AA+ 650,000.00 1/18/2022 1.13% 10/31/2026 626,970.70 1.92% 1,232.00 584,593.75 1,219 3137BTUM1 Federal Home Loan Mortgage Corporation AA+ 1,380,000.00 5/24/2023 3.35% 11/1/2026 1,337,521.88 4.31% 3,849.05 1,317,729.58 1,220 025816CM9 American Express BBB+ 800,000.00 12/16/2021 1.65% 11/4/2026 798,760.00 1.68% 2,090.00 712,203.20 1,223 14041NFY2 Capital One Financial Corp AAA 1,075,000.00 11/30/2021 1.04% 11/15/2026 1,074,851.87 1.04% 496.89 1,011,932.33 1,234 912828U24 U.S. Treasury AA+ 2,000,000.00 5/9/2022 2.00% 11/15/2026 1,912,578.13 3.04% 5,108.70 1,850,000.00 1,234 380146AC4 Gm Financial Securitized Term AAA 350,000.00 1/19/2022 1.26% 11/16/2026 349,969.59 1.26% 183.75 334,164.04 1,235 91282CDK4 U.S. Treasury AA+ 1,200,000.00 12/3/2021 1.25% 11/30/2026 1,203,421.88 1.19% 1,270.49 1,081,125.00 1,249 3137BVZ82 Federal Home Loan Mortgage Corporation AA+ 2,000,000.00 5/24/2023 3.43% 1/1/2027 1,939,453.13 4.34% 5,716.67 1,911,605.80 1,281 24422EWA3 Deere & Company A 500,000.00 1/13/2022 1.70% 1/11/2027 497,180.00 1.82% 4,013.89 450,204.50 1,291 87612EBM7 Target Corp A 215,000.00 1/24/2022 1.95% 1/15/2027 214,634.50 1.99% 1,933.21 196,730.59 1,295 87612EBM7 Target Corp A 800,000.00 1/24/2022 1.95% 1/15/2027 801,752.00 1.90% 7,193.33 732,020.80 1,295 06406RBA4 Bank of New York Mellon A 700,000.00 1/28/2022 2.05% 1/26/2027 700,847.00 2.02% 6,178.47 629,141.80 1,306 459200KM2 IBM A- 500,000.00 2/25/2022 2.20% 2/9/2027 493,830.00 2.47% 4,338.89 454,172.50 1,320 459200KM2 IBM A- 900,000.00 2/25/2022 2.20% 2/9/2027 841,185.00 3.72% 7,810.00 817,510.50 1,320 912828V98 U.S. Treasury AA+ 1,825,000.00 7/6/2022 2.25% 2/15/2027 1,771,248.05 2.94% 15,426.80 1,696,964.94 1,326

Page 9 of 10 ends

Attachment 2
S&P Par Purchase Coupon Maturity Original Yield to Accrued Market Days to CUSIP Description Rating Value Settlement Date Rate Date Cost Maturity Interest Value Maturity City of Napa
Quarterly Investment Report - Maturity Report
as of June 30, 2023
912828V98 U.S. Treasury AA+ 6,030,000.00 7/6/2022 2.25% 2/15/2027 5,906,808.98 2.73% 50,971.82 5,606,958.11 1,326 438516CE4 Honeywell International A 800,000.00 3/3/2022 1.10% 3/1/2027 762,624.00 2.09% 2,933.33 705,229.60 1,340 89788MAD4 Truist Fin Corp A- 1,200,000.00 3/14/2022 1.27% 3/2/2027 1,127,520.00 2.57% 5,025.77 1,058,372.40 1,341 89788MAD4 Truist Fin Corp A- 1,200,000.00 3/14/2022 1.27% 3/2/2027 1,086,720.00 3.42% 5,025.77 1,058,372.40 1,341 89236TJZ9 Toyota Motor Corp A+ 1,000,000.00 5/10/2022 3.05% 3/22/2027 968,140.00 3.77% 8,387.50 935,172.00 1,361 3137F1G44 Federal Home Loan Mortgage Corporation AA+ 2,255,000.00 6/13/2023 3.24% 4/1/2027 2,160,836.13 4.44% 6,094.14 2,137,702.21 1,371 023135CF1 Amazon.Com Inc AA 1,000,000.00 5/20/2022 3.30% 4/13/2027 989,180.00 3.54% 7,150.00 952,224.00 1,383 14318MAD1 Carmax Auto Owner Trust AAA 1,125,000.00 7/20/2022 3.97% 4/15/2027 1,124,973.45 3.97% 1,985.00 1,098,205.76 1,385 437076CN0 Home Depot Inc A 1,200,000.00 5/10/2022 2.88% 4/15/2027 1,161,660.00 3.59% 7,283.33 1,126,360.80 1,385 91282CEN7 U.S. Treasury AA+ 1,350,000.00 12/7/2022 2.75% 4/30/2027 1,292,625.00 3.81% 6,254.76 1,275,328.13 1,400 665859AW4 Northern Trust A+ 800,000.00 5/12/2022 4.00% 5/10/2027 807,728.00 3.79% 4,533.33 769,196.80 1,410 665859AW4 Northern Trust A+ 400,000.00 5/12/2022 4.00% 5/10/2027 403,848.00 3.79% 2,266.67 384,598.40 1,410 91324PEG3 Unitedhealth Group Inc A+ 200,000.00 5/20/2022 3.70% 5/15/2027 199,892.00 3.71% 945.56 192,578.40 1,415 912828X88 U.S. Treasury AA+ 1,800,000.00 9/6/2022 2.38% 5/15/2027 1,717,664.06 3.44% 5,459.92 1,676,250.00 1,415 912828X88 U.S. Treasury AA+ 2,900,000.00 9/6/2022 2.38% 5/15/2027 2,675,136.72 4.28% 8,796.53 2,700,625.00 1,415 254683CS2 Discover Financial Services NR 1,430,000.00 5/26/2022 3.32% 5/17/2027 1,429,883.74 3.32% 2,110.04 1,378,787.12 1,417 63254ABE7 National Australia Bank Ltd AA- 1,000,000.00 6/13/2022 3.91% 6/9/2027 991,330.00 4.10% 2,386.39 954,941.00 1,440 254683CW3 Discover Financial Services AAA 950,000.00 8/9/2022 3.56% 7/15/2027 949,882.11 3.56% 1,503.11 917,748.93 1,476 91282CFB2 U.S. Treasury AA+ 960,000.00 1/5/2023 2.75% 7/31/2027 910,950.00 3.98% 11,012.15 905,100.00 1,492 458140BY5 Intel Corporation A 1,200,000.00 8/12/2022 3.75% 8/5/2027 1,201,452.00 3.72% 18,250.00 1,146,948.00 1,497 58768PAC8 Mercedes-Benz Auto Receivables AAA 1,235,000.00 11/22/2022 5.21% 8/16/2027 1,234,755.72 5.21% 2,859.71 1,226,294.98 1,508 91282CAH4 U.S. Treasury AA+ 2,800,000.00 12/7/2022 0.50% 8/31/2027 2,407,015.63 3.77% 4,679.35 2,401,875.00 1,523 931142EX7 Wal-Mart Stores AA 1,200,000.00 9/14/2022 3.95% 9/9/2027 1,201,944.00 3.91% 14,746.67 1,176,076.80 1,532 91282CAU5 U.S. Treasury AA+ 2,440,000.00 1/5/2023 0.50% 10/31/2027 2,071,903.13 3.97% 2,055.43 2,082,387.50 1,584 9128283F5 U.S. Treasury AA+ 3,725,000.00 1/31/2023 2.25% 11/15/2027 3,489,713.87 3.70% 10,704.31 3,430,492.19 1,599 91282CBB6 U.S. Treasury AA+ 2,800,000.00 5/17/2023 0.63% 12/31/2027 2,460,062.50 3.49% 47.55 2,392,250.00 1,645 9128283W8 U.S. Treasury AA+ 3,900,000.00 4/6/2023 2.75% 2/15/2028 3,797,320.31 3.34% 40,292.82 3,665,390.82 1,691 57636QAW4 Mastercard Inc A+ 920,000.00 3/17/2023 4.88% 3/9/2028 922,364.40 4.82% 13,953.33 929,335.24 1,714 63743HFG2 National Rural Utilities Co Finance Corp A- 1,085,000.00 6/13/2023 4.80% 3/15/2028 1,081,820.95 4.87% 15,334.67 1,073,636.80 1,720 05522RDF2 Bank Of America Co AAA 2,150,000.00 6/2/2023 5.00% 4/15/2028 2,160,162.11 4.89% 4,777.78 2,138,803.45 1,751 91282CBZ3 U.S. Treasury AA+ 3,000,000.00 6/5/2023 1.25% 4/30/2028 2,665,312.50 3.76% 6,317.93 2,620,781.40 1,766 02582JJZ4 American Express Co AAA 810,000.00 6/14/2023 4.87% 5/15/2028 809,928.15 4.87% 1,862.78 805,294.55 1,781 05522RDG0 Bank Of America Co AAA 725,000.00 6/16/2023 4.79% 5/15/2028 724,835.86 4.79% 1,446.98 719,235.60 1,781 14041NGD7 Capital One Financial Corp AAA 1,755,000.00 5/24/2023 4.42% 5/15/2028 1,754,597.58 4.42% 7,972.58 1,723,756.09 1,781 344930AD4 Ford Credit Auto Owner Trust AAA 640,000.00 6/26/2023 5.23% 5/15/2028 639,991.36 5.23% 464.89 637,066.69 1,781 369550BC1 General Dynamics Corp. A- 850,000.00 5/17/2023 3.75% 5/15/2028 831,351.00 4.24% 4,072.92 813,586.85 1,781 30303M8L9 Meta Platforms AA- 1,080,000.00 6/5/2023 4.60% 5/15/2028 1,081,620.00 4.56% 8,004.00 1,066,956.84 1,781 539830BZ1 Lockheed Martin Corp A- 170,000.00 5/25/2023 4.45% 5/15/2028 169,694.00 4.49% 756.50 167,469.55 1,781 539830BZ1 Lockheed Martin Corp A- 480,000.00 5/25/2023 4.45% 5/15/2028 478,272.00 4.53% 2,136.00 472,855.20 1,781 63253QAE4 National Australia Bank Ltd AA- 1,585,000.00 6/13/2023 4.90% 6/13/2028 1,582,289.65 4.94% 3,883.25 1,569,766.57 1,810 254683CZ6 Discover Financial Services AAA 1,505,000.00 6/28/2023 4.93% 6/15/2028 1,504,796.67 4.93% 618.30 1,498,937.71 1,812 Total Other 203,434,335.87 199,976,127.11 928,112.69 190,059,380.27 Total LAIF, CAMP, and Securities 301,423,616.60 297,965,407.84 928,112.69 288,048,661.00

Page 10 of 10 ends

Napa City CouncilAugust 15, 2023

Napa City Council
August 15, 2023