Attachment 2
Sector Par Value Original Cost Market Value
U.S. Treasuries 126,195,000.00 124,372,914.51 116,915,390.29 Federal Agencies 4,430,000.00 4,419,175.60 4,089,252.90 Federal Agency CMBS 3,361,577.17 3,450,891.11 3,279,473.84 Municipals 10,025,000.00 10,144,542.80 9,343,452.70
Supra-National Agencies 3,755,000.00 3,809,574.85 3,537,112.18 Certificates of Deposit 2,525,000.00 2,525,000.00 2,515,362.53 Corporate Notes 40,085,000.00 40,386,279.00 37,899,859.07 Asset-Backed Securities 11,762,095.34 11,760,745.59 11,377,181.40 California Asset Management Trust 399,498.54 399,498.54 399,498.54 Local Agency Investment Fund 56,511,686.51 56,511,686.51 56,511,686.51 Total 259,049,857.56 257,780,308.51 245,868,269.96
Market Value Basis
Interest Earned $810,029
Change in Market Value $1,023,724 City of Napa 0.97% -4.98% 0.99% 3.06% Total Dollar Return $1,833,753 0.94% -5.25% 0.66% 2.81% Accrual Basis
Interest Earned $810,029
Realized Gains / (Losses) ($296,963)
Change in Amortized Cost $37,864
Total Earnings $550,930
Portfolio values as of December 31, 2022 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 December 31, 2022
Portfolio Earnings
Attachment 2
Par Purchase Coupon Maturity Original Yield to Accrued Market CUSIP Description 1Q23 2Q23 Value Settlement Date Rate Date Cost Maturity Interest Value LAIF and CAMP
N/A California Asset Management Trust AAAm AAAm 399,498.54 12/31/2022 4.30% 1/1/2023 399,498.54 4.30% - 399,498.54 N/A Local Agency Investment Fund NR NR 56,511,686.51 12/31/2022 2.07% 1/1/2023 56,511,686.51 2.07% - 56,511,686.51 Total LAIF and CAMP 56,911,185.05 56,911,185.05 2.09% - 56,911,185.05 U.S. Treasuries
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,166.62 1,266,168.82 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,617.66 2,351,428.00 9128282U3 U.S. Treasury AA+ AA+ 4,000,000.00 5/9/2022 1.88% 8/31/2024 3,917,343.75 2.80% 25,483.43 3,825,000.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,510.02 1,697,250.00 912828V98 U.S. Treasury AA+ AA+ 6,030,000.00 8/5/2022 2.25% 2/15/2027 5,906,808.98 2.73% 51,246.81 5,607,900.00 9128286G0 U.S. Treasury AA+ AA+ 1,115,000.00 8/12/2021 2.38% 2/29/2024 1,172,448.63 0.35% 8,997.77 1,085,905.41 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,193.37 1,848,437.60 912828K74 U.S. Treasury N/A AA+ 2,500,000.00 11/4/2022 2.00% 8/15/2025 2,341,113.28 4.46% 18,885.87 2,359,765.50 912828W71 U.S. Treasury AA+ AA+ 150,000.00 1/6/2020 2.13% 3/31/2024 152,935.55 1.64% 814.39 145,289.07 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,110.99 1,081,445.26 9128285K2 U .S. Treasury AA+ AA+ 5,000,000.00 5/9/2022 2.88% 10/31/2023 5,025,390.63 2.52% 24,620.17 4,924,219.00 91282CDZ1 U
.S. Treasury AA+ AA+ 3,900,000.00 5/9/2022 1.50% 2/15/2025 3,754,664.06 2.91% 22,096.47 3,669,656.25 91282CCX7 U.S. Treasury AA+ AA+ 1,850,000.00 10/6/2021 0.38% 9/15/2024 1,843,496.09 0.50% 2,069.75 1,723,679.78 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,356.35 2,795,156.40 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,494.48 4,453,906.00 91282CDR9 U.S. Treasury AA+ AA+ 7,000,000.00 1/18/2022 0.75% 12/31/2023 6,974,296.88 0.94% 145.03 6,729,843.40 91282CDA6 U.S. Treasury AA+ AA+ 1,000,000.00 10/6/2021 0.25% 9/30/2023 999,257.81 0.29% 638.74 967,187.50 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,379.08 6,548,281.60 91282CEN7 U.S. Treasury N/A AA+ 1,350,000.00 12/7/2022 2.75% 4/30/2027 1,292,625.00 3.81% 6,358.43 1,278,914.13 91282CBC4 U.S. Treasury AA+ AA+ 3,000,000.00 2/2/2021 0.38% 12/31/2025 2,993,554.69 0.42% 31.08 2,679,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,705.46 1,870,625.00 912828ZT0 U.S. Treasury AA+ AA+ 3,500,000.00 10/6/2021 0.25% 5/31/2025 3,442,851.56 0.70% 769.23 3,175,156.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,492.53 1,854,890.52
912828ZY9 U.S. Treasury AA+ AA+ 600,000.00 2/2/2021 0.13% 7/15/2023 599,742.19 0.14% 346.47 585,375.00 91282CCZ2 U.S. Treasury AA+ AA+ 550,000.00 10/6/2021 0.88% 9/30/2026 548,281.25 0.94% 1,229.57 488,296.88 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,471.15 1,775,625.00 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,312.15 1,073,062.56 91282CDG3 U.S. Treasury AA+ AA+ 650,000.00 2/14/2022 1.13% 10/31/2026 626,970.70 1.92% 1,252.42 581,242.22 912828Y87 U.S. Treasury AA+ AA+ 1,200,000.00 12/4/2019 1.75% 7/31/2024 1,204,171.87 1.67% 8,788.04 1,147,687.44 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,698.90 1,797,812.40 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,318.68 1,783,437.60 91282CAM3 U.S. Treasury AA+ AA+ 500,000.00 6/30/2021 0.25% 9/30/2025 489,414.06 0.76% 319.37 448,828.10 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,395.26 3,366,210.75 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,063.62 1,169,528.13
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,138.59 1,778,750.00 91282CBH3 U.S. Treasury AA+ AA+ 675,000.00 9/3/2021 0.38% 1/31/2026 665,850.59 0.69% 1,059.27 600,328.12 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,846.47 4,446,875.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,832.42 1,792,500.00 91282CCG4 U.S. Treasury AA+ AA+ 1,000,000.00 7/7/2021 0.25% 6/15/2024 995,429.69 0.41% 116.76 938,593.80 91282CDM0 U.S. Treasury AA+ AA+ 3,000,000.00 12/3/2021 0.50% 11/30/2023 2,994,492.19 0.59% 1,318.68 2,886,093.60 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,318.68 1,076,250.00 91282CAH4 U.S. Treasury N/A AA+ 2,800,000.00 12/7/2022 0.50% 8/31/2027 2,407,015.63 3.77% 4,756.91 2,383,062.64 City of Napa
Quarterly Investment Report - Holdings Report
as of December 31, 2022
FY Quarter
S&P Rating
Attachment 2
Par Purchase Coupon Maturity Original Yield to Accrued Market CUSIP Description 1Q23 2Q23 Value Settlement Date Rate Date Cost Maturity Interest Value City of Napa
Quarterly Investment Report - Holdings Report
as of December 31, 2022
FY Quarter
S&P Rating
912828W71 U.S. Treasury AA+ AA+ 9,000,000.00 10/6/2021 2.13% 3/31/2024 9,383,554.69 0.40% 48,863.32 8,717,344.20 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,550.41 1,677,375.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,942.34 2,702,437.50 912828X70 U.S. Treasury AA+ AA+ 1,200,000.00 5/6/2019 2.00% 4/30/2024 1,180,828.13 2.34% 4,110.50 1,157,812.56 91282CCJ8 U.S. Treasury AA+ AA+ 2,285,000.00 8/4/2021 0.88% 6/30/2026 2,308,207.03 0.66% 55.23 2,042,218.75 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.59 983,125.00 91282CDB4 U.S. Treasury AA+ AA+ 1,000,000.00 10/15/2021 0.63% 10/15/2024 998,867.19 0.66% 1,339.29 933,593.80 912828XZ8 U.S. Treasury AA+ AA+ 1,545,000.00 12/4/2020 2.75% 6/30/2025 1,710,423.63 0.39% 117.37 1,487,545.31 91282CAB7 U.S. Treasury AA+ AA+ 525,000.00 5/5/2021 0.25% 7/31/2025 516,386.72 0.64% 549.25 473,648.44 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,853.59 2,681,250.00 Total U.S. Treasuries 126,195,000.00 124,372,914.51 1.60% 389,175.03 116,915,390.29 Federal Agencies
3137EAEV7 Federal Home Loan Mortgage Corporation AA+ AA+ 150,000.00 8/31/2020 0.25% 8/24/2023 149,871.00 0.28% 132.29 145,662.15 3137EAEV7 Federal Home Loan Mortgage Corporation AA+ AA+ 750,000.00 9/1/2020 0.25% 8/24/2023 750,120.00 0.24% 661.46 728,310.75
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 856,685.30 3137EAEW5 Federal Home Loan Mortgage Corporation AA+ AA+ 565,000.00 9/4/2020 0.25% 9/8/2023 564,813.55 0.26% 443.37 547,649.98 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 485,197.02 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,325,747.70 Total Federal Agencies 4,430,000.00 4,419,175.60 0.40% 4,394.73 4,089,252.90 Federal Agency CMBSs
3137F
BTA4 Federal Home Loan Mortgage Corporation AA+ AA+ 974,605.97 5/31/2022 3.06% 8/1/2024 975,900.36 3.00% 2,488.49 951,724.33 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 676,828.60 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 760,501.06 3136AJB54 Federal National Mortgage Association AA+ AA+ 346,160.66 12/18/2019 3.35% 3/1/2024 362,981.92 2.14% 965.21 341,586.69 3137BTU25 Federal Home Loan Mortgage Corporation AA+ AA+ 555,810.54 2/2/2021 3.06% 11/1/2023 593,349.46 0.58% 1,418.24 548,833.16 Total Federal Agency CMOs 3,361,577.17 3,450,891.11 2.37% 8,744.58 3,279,473.84 Municipals
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,268,216.40 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 452,420.10 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 173,656.20 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 182,796.00 20772KJW0 State Of Connecticut A+ AA- 190,000.00 6/11/2020 2.00% 7/1/2024 190,000.00 2.00% 1,898.10 182,692.60 20772KEW5 State Of Connecticut A+ AA- 850,000.00 11/19/2020 3.74% 9/15/2025 966,985.50 0.83% 9,367.90
834,589.50
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 302,522.85 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 476,925.75 574193TQ1 Maryland St AAA AAA 400,000.00 8/5/2020 0.51% 8/1/2024 399,888.00 0.52% 850.00 376,992.00 60412AVJ9 Minnesota St AAA AAA 355,000.00 8/25/2020 0.63% 8/1/2025 355,000.00 0.63% 931.88 320,948.40 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 757,973.40 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 480,969.70 797412DL4 San Diego County AAA AAA 500,000.00 7/22/2020 0.59% 5/1/2024 500,000.00 0.59% 494.17 471,710.00 605581MZ7 Mississippi State AA AA 155,000.00 8/6/2020 0.57% 11/1/2024 155,000.00 0.57% 145.96 143,058.80 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 218,924.65 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 473,691.75 650036DT0 New York State Urban Development Corp AA+ AA+ 1,220,000.00 12/23/2020 0.87% 3/15/2025 1,220,000.00 0.87% 3,125.23 1,120,240.60
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 743,904.00
Attachment 2
Par Purchase Coupon Maturity Original Yield to Accrued Market CUSIP Description 1Q23 2Q23 Value Settlement Date Rate Date Cost Maturity Interest Value City of Napa
Quarterly Investment Report - Holdings Report
as of December 31, 2022
FY Quarter
S&P Rating
91412HGE7 University Of California AA AA 400,000.00 7/16/2020 0.88% 5/15/2025 400,000.00 0.88% 451.31 361,220.00 Total Municipals 10,025,000.00 10,144,542.80 1.15% 55,237.16 9,343,452.70 Supra-National Agencies
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,061,750.25 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,663,307.63 459058JM6 International Bank of Reconstruction and Dev. AAA AAA 845,000.00 11/24/2020 0.25% 11/24/2023 843,183.25 0.32% 217.12 812,054.30 Total Supranationals 3,755,000.00 3,809,574.85 0.46% 8,498.26 3,537,112.18 Certificates of Deposit
22552G3C2 Credit Suisse NY A-1 A-2 925,000.00 3/23/2021 0.59% 3/17/2023 925,000.00 0.59% 4,396.32 916,070.05 89115B6K1 Toronto-Dominion Bank N/A A 1,600,000.00 10/31/2022 5.60% 10/27/2025 1,600,000.00 5.58% 15,431.11 1,599,292.48 Total Certificates of Deposit 2,525,000.00 2,525,000.00 3.76% 19,827.43 2,515,362.53 Corporate Notes
002824BE9 Abbot Laboratories AA- AA- 990,000.00 5/14/2019 3.40% 11/30/2023 1,015,730.10 2.79% 2,898.50 977,150.79 023135BW5 Amazon.Com Inc AA AA 350,000.00 5/12/2021 0.45% 5/12/2024 349,489.00 0.50% 214.38 330,183.35 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 949,652.00
025816CV9 American Express BBB+ BBB+ 400,000.00 5/3/2022 3.38% 5/3/2024 399,960.00 3.38% 2,175.00 391,301.20 02665WCZ2 American Honda Finance A- A- 125,000.00 7/16/2019 2.40% 6/27/2024 124,357.50 2.51% 33.33 120,314.75
025816CM9 American Express BBB+ BBB+ 800,000.00 12/16/2021 1.65% 11/4/2026 798,760.00 1.68% 2,090.00 707,620.00 037833DT4 Apple Inc AA+ AA+ 800,000.00 5/14/2020 1.13% 5/11/2025 801,680.00 1.08% 1,250.00 736,883.20 04636NAC7 Astrazeneca A- A 415,000.00 5/28/2021 0.70% 5/28/2024 414,962.65 0.70% 266.29 391,750.87 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 228,969.41 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 644,825.94 04636NAA1 Astrazeneca A- A 500,000.00 7/19/2021 1.20% 5/28/2026 500,530.00 1.18% 550.00 445,536.00 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 628,436.90 14913Q2V0 Caterpillar Financial A A 1,055,000.00 7/12/2019 2.85% 5/17/2024 1,079,792.50 2.33% 3,674.92 1,026,232.26 06406RAS6 Bank of New York Mellon A A 230,000.00 4/26/2021 0.50% 4/26/2024 229,753.90 0.54% 207.64 216,915.07 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,348.00 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 793,519.05
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 953,731.00 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,876.78 166764BW9 Chevron Corporation AA- AA- 500,000.00 5/15/2020 1.55% 5/11/2025 502,480.00 1.45% 1,079.17 465,854.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 866,114.10 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,994.40 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,120,382.40 254687FK7 The Walt Disney Corporation BBB+ BBB+ 1,085,000.00 9/6/2019 1.75% 8/30/2024 1,080,573.20 1.84% 6,381.91 1,034,165.58 24422EWA3 Deere & Company A A 500,000.00 1/13/2022 1.70% 1/11/2027 497,180.00 1.82% 4,013.89 446,958.50 24422EVQ9 Deere & Company A A 315,000.00 6/10/2021 0.45% 6/7/2024 314,606.25 0.49% 94.50 296,106.62 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,595.75 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 875,629.80
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,080,874.30 17327CAN3 Citigroup Inc BBB+ BBB+ 245,000.00 1/25/2022 2.01% 1/25/2026 245,000.00 2.01% 2,138.20 227,229.42 24422EVU0 Deere & Company A A 200,000.00 9/10/2021 0.63% 9/10/2024 199,870.00 0.65% 385.42 186,493.40 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,043,577.96 61746BDQ6 Morgan Stanley A- A- 790,000.00 7/23/2019 3.88% 4/29/2024 836,238.70 2.56% 5,272.15 776,324.31
Attachment 2
Par Purchase Coupon Maturity Original Yield to Accrued Market CUSIP Description 1Q23 2Q23 Value Settlement Date Rate Date Cost Maturity Interest Value City of Napa
Quarterly Investment Report - Holdings Report
as of December 31, 2022
FY Quarter
S&P Rating
46647PBH8 JPMorgan Chase A- A- 795,000.00 10/6/2021 2.01% 3/13/2026 816,393.45 1.38% 4,781.93 734,537.07 808513AY1 Charles Schwab A A 1,000,000.00 4/29/2019 3.55% 2/1/2024 1,034,750.00 2.76% 14,791.67 985,349.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,154,121.60 61747YEG6 Morgan Stanley A- A- 180,000.00 10/19/2021 1.16% 10/21/2025 180,000.00 1.16% 407.40 165,632.22 61747YEG6 Morgan Stanley A- A- 500,000.00 5/20/2022 1.16% 10/21/2025 467,560.00 3.18% 1,131.67 460,089.50 904764AX5 Unilever Plc A+ A+ 485,000.00 9/6/2019 2.60% 5/5/2024 499,525.75 1.93% 1,961.56 471,090.20 87612EBM7 Target Corp A A 215,000.00 1/24/2022 1.95% 1/15/2027 214,634.50 1.99% 1,933.21 195,016.40 87612EBM7 Target Corp A A 800,000.00 1/25/2022 1.95% 1/15/2027 801,752.00 1.90% 7,193.33 725,642.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 958,069.00 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 931,044.00 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,634,556.53 459200JY8 I BM A- A- 850,000.00 8/31/2020 3.00% 5/15/2024 923,797.00 0.63% 3,258.33 827,543.00 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 255,031.23
459200KM2 IBM A- A- 500,000.00 2/25/2022 2.20% 2/9/2027 493,830.00 2.47% 4,338.89 449,739.00 459200KM2 IBM A- A- 900,000.00 5/20/2022 2.20% 2/9/2027 841,185.00 3.72% 7,810.00 809,530.20 665859AW4 Northern Trust A+ A+ 800,000.00 5/12/2022 4.00% 5/10/2027 807,728.00 3.79% 4,533.33 781,616.00 665859AW4 Northern Trust A+ A+ 400,000.00 5/20/2022 4.00% 5/10/2027 403,848.00 3.79% 2,266.67 390,808.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 484,904.50 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,065,889.20 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,065,889.20 438516CE4 Honeywell International A A 800,000.00 3/3/2022 1.10% 3/1/2027 762,624.00 2.09% 2,933.33 696,966.40 89236TGT6 T oyota Motor Corp A+ A+ 500,000.00 5/26/2020 1.80% 2/13/2025 504,885.00 1.58% 3,450.00 470,910.00 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 367,309.80 904764BN6 Unilever Plc A+ A+ 100,000.00 8/12/2021 0.63% 8/12/2024 100,000.00 0.63% 241.71 93,838.00
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 669,713.10 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,180,564.80 91324PEG3 Unitedhealth Group Inc A+ A+ 200,000.00 5/20/2022 3.70% 5/15/2027 199,892.00 3.71% 945.56 193,405.60 91324PEB4 Unitedhealth Group Inc A+ A+ 270,000.00 5/19/2021 0.55% 5/15/2024 269,719.20 0.59% 189.75 254,505.51 Total Corporate Notes 40,085,000.00 40,386,279.00 2.44% 282,342.54 37,899,859.07 Asset-Backed Securities
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 438,535.80 05591RAD6 BMW Financial Services NA LLC AAA AAA 210,000.00 3/10/2021 0.37% 7/25/2024 209,991.66 0.37% 12.95 204,993.18 14318MAD1 Carmax Auto Owner Trust AAA AAA 1,125,000.00 7/20/2022 3.97% 4/15/2027 1,124,973.45 3.97% 1,985.00 1,092,648.38 14316NAC3 Carmax Auto Owner Trust AAA AAA 107,599.55 1/27/2021 0.34% 12/15/2025 107,578.28 0.34% 16.26 103,852.08 14314QAC8 Carmax Auto Owner Trust AAA AAA 366,030.33 4/21/2021 0.52% 2/17/2026 365,951.45 0.52% 84.59 352,311.92 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,003,739.33
14315FAD9 Carmax Auto Owner Trust AAA AAA 31,051.51 7/22/2020 0.62% 3/17/2025 31,046.19 0.62% 8.56 30,517.31 14315XAC2 Carmax Auto Owner Trust AAA AAA 45,675.78 1/22/2020 1.89% 12/16/2024 45,666.82 1.89% 38.37 45,129.47 254683CS2 Discover Financial Services NR NR 1,430,000.00 5/26/2022 3.32% 5/17/2027 1,429,883.74 3.32% 2,110.04 1,379,176.08 362590AC5 Gm Financial Securitized Term NR NR 178,506.83 8/19/2020 0.45% 4/16/2025 178,465.99 0.45% 33.47 174,383.43 380146AC4 Gm Financial Securitized Term AAA AAA 350,000.00 1/19/2022 1.26% 11/16/2026 349,969.59 1.26% 183.75 331,221.00 254683CW3 Discover Financial Services AAA AAA 950,000.00 8/9/2022 3.56% 7/15/2027 949,882.11 3.56% 1,503.11 920,762.61 380144AC9 GM Financial Auto Leasing Trust AAA AAA 441,824.23 5/26/2021 0.34% 5/20/2024 441,754.87 0.35% 45.90 436,450.41 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 366,261.51 448977AD0 Hyundai Auto Receivables AAA AAA 830,000.00 3/16/2022 2.22% 10/15/2026 829,968.05 2.22% 818.93 790,521.96 65480EAD3 Nissan Auto Lease Trust AAA AAA 2,125.70 9/29/2020 0.43% 10/16/2023 2,125.48 0.43% 0.41 2,123.25
Attachment 2
Par Purchase Coupon Maturity Original Yield to Accrued Market CUSIP Description 1Q23 2Q23 Value Settlement Date Rate Date Cost Maturity Interest Value City of Napa
Quarterly Investment Report - Holdings Report
as of December 31, 2022
FY Quarter
S&P Rating
43815GAC3 Honda Auto Receivables NR NR 460,000.00 11/24/2021 0.88% 1/21/2026 459,903.03 0.89% 112.44 436,560.65 65479CAD0 Nissan Auto Receivables AAA AAA 86,138.90 6/30/2020 0.55% 7/15/2024 86,136.54 0.55% 21.06 85,294.34 50117TAC5 Kubota Credit NR NR 200,000.00 4/14/2021 0.62% 8/15/2025 199,959.08 0.62% 55.11 190,504.86 43815EAC8 Honda Auto Receivables AAA AAA 390,000.00 8/25/2021 0.41% 11/18/2025 389,994.31 0.41% 57.74 371,504.60 44891TAD8 Hyundai Auto Lease Securitization Trust AAA AAA 140,000.00 1/20/2021 0.42% 12/16/2024 139,988.35 0.42% 26.13 137,745.48 44933LAC7 Hyundai Auto Receivables AAA AAA 242,943.69 4/28/2021 0.38% 9/15/2025 242,918.13 0.38% 41.03 234,966.95 89238EAC0 Toyota Lease Owner Trust AAA AAA 249,689.07 4/21/2021 0.39% 4/22/2024 249,659.93 0.39% 29.75 246,282.46 89237VAB5 Toyota Motor Corp AAA AAA 138,417.29 7/27/2020 0.44% 10/15/2024 138,406.64 0.44% 27.07 136,253.02 58768PAC8 Mercedes-Benz Auto Receivables N/A AAA 1,235,000.00 11/22/2022 5.21% 8/16/2027 1,234,755.72 5.21% 2,859.71 1,245,089.70 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 332,765.83 92290BAA9 Verizon Owner Trust NR NR 292,092.46 8/12/2020 0.47% 2/20/2025 292,031.12 0.47% 41.95 287,585.79 Total Asset-Backed Securities 11,762,095.34 11,760,745.59 2.27% 11,197.70 11,377,181.40 Total 259,049,857.56 257,780,308.51 1.85% 779,417.43 245,868,269.96
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 399,498.54 12/31/2022 4.30% 1/1/2023 399,498.54 4.30% - 399,498.54 1 N/A Local Agency Investment Fund NR 56,511,686.51 12/31/2022 2.07% 1/1/2023 56,511,686.51 2.07% - 56,511,686.51 1 Total LAIF and CAMP 56,911,185.05 56,911,185.05 - 56,911,185.05 Other
22552G3C2 Credit Suisse NY A-2 925,000.00 3/23/2021 0.59% 3/17/2023 925,000.00 0.59% 4,396.32 916,070.05 76 912828ZY9 U.S. Treasury AA+ 600,000.00 2/2/2021 0.13% 7/15/2023 599,742.19 0.14% 346.47 585,375.00 196 3137EAEV7 Federal Home Loan Mortgage Corporation AA+ 150,000.00 8/31/2020 0.25% 8/24/2023 149,871.00 0.28% 132.29 145,662.15 236 3137EAEV7 Federal Home Loan Mortgage Corporation AA+ 750,000.00 8/31/2020 0.25% 8/24/2023 750,120.00 0.24% 661.46 728,310.75 236 3137EAEW5 Federal Home Loan Mortgage Corporation AA+ 565,000.00 9/4/2020 0.25% 9/8/2023 564,813.55 0.26% 443.37 547,649.98 251 91282CDA6 U.S. Treasury AA+ 1,000,000.00 10/6/2021 0.25% 9/30/2023 999,257.81 0.29% 638.74 967,187.50 273 65480EAD3 Nissan Auto Lease Trust AAA 2,125.70 9/29/2020 0.43% 10/16/2023 2,125.48 0.43% 0.41 2,123.25 289 9128285K2 U.S. Treasury AA+ 5,000,000.00 5/9/2022 2.88% 10/31/2023 5,025,390.63 2.52% 24,620.17 4,924,219.00 304 3137BTU25 Federal Home Loan Mortgage Corporation AA+ 555,810.54 2/2/2021 3.06% 11/1/2023 593,349.46 0.58% 1,418.24 548,833.16 305 459058JM6 International Bank of Reconstruction and Dev. AAA 845,000.00 11/24/2020 0.25% 11/24/2023 843,183.25 0.32% 217.12 812,054.30 328 002824BE9 Abbot Laboratories AA- 990,000.00 5/14/2019 3.40% 11/30/2023 1,015,730.10 2.79% 2,898.50 977,150.79 334 91282CDM0 U.S. Treasury AA+ 3,000,000.00 12/3/2021 0.50% 11/30/2023 2,994,492.19 0.59% 1,318.68 2,886,093.60 334 91282CDR9 U.S. Treasury AA+ 7,000,000.00 1/18/2022 0.75% 12/31/2023 6,974,296.88 0.94% 145.03 6,729,843.40 365 808513AY1 Charles Schwab A 1,000,000.00 4/29/2019 3.55% 2/1/2024 1,034,750.00 2.76% 14,791.67 985,349.00 397 9128286G0 U.S. Treasury AA+ 1,115,000.00 8/12/2021 2.38% 2/29/2024 1,172,448.63 0.35% 8,997.77 1,085,905.41 425 3136AJB54 Federal National Mortgage Association AA+ 346,160.66 12/18/2019 3.35% 3/1/2024 362,981.92 2.14% 965.21 341,586.69 426 912828W71 U.S. Treasury AA+ 150,000.00 1/6/2020 2.13% 3/31/2024 152,935.55 1.64% 814.39 145,289.07 456 912828W71 U.S. Treasury AA+ 9,000,000.00 1/6/2020 2.13% 3/31/2024 9,383,554.69 0.40% 48,863.32 8,717,344.20 456 89238EAC0 Toyota Lease Owner Trust AAA 249,689.07 4/21/2021 0.39% 4/22/2024 249,659.93 0.39% 29.75 246,282.46 478 06406RAS6 Bank of New York Mellon A 230,000.00 4/26/2021 0.50% 4/26/2024 229,753.90 0.54% 207.64 216,915.07 482 61746BDQ6 Morgan Stanley A- 790,000.00 7/23/2019 3.88% 4/29/2024 836,238.70 2.56% 5,272.15 776,324.31 485 912828X70 U.S. Treasury AA+ 1,200,000.00 5/6/2019 2.00% 4/30/2024 1,180,828.13 2.34% 4,110.50 1,157,812.56 486 797412DL4 San Diego County AAA 500,000.00 7/22/2020 0.59% 5/1/2024 500,000.00 0.59% 494.17 471,710.00 487 025816CV9 American Express BBB+ 400,000.00 5/3/2022 3.38% 5/3/2024 399,960.00 3.38% 2,175.00 391,301.20 489 904764AX5 Unilever Plc A+ 485,000.00 9/6/2019 2.60% 5/5/2024 499,525.75 1.93% 1,961.56 471,090.20 491 023135BW5 Amazon.Com Inc AA 350,000.00 5/12/2021 0.45% 5/12/2024 349,489.00 0.50% 214.38 330,183.35 498 459200JY8 IBM A- 850,000.00 8/31/2020 3.00% 5/15/2024 923,797.00 0.63% 3,258.33 827,543.00 501 91324PEB4 Unitedhealth Group Inc A+ 270,000.00 5/19/2021 0.55% 5/15/2024 269,719.20 0.59% 189.75 254,505.51 501 14913Q2V0 Caterpillar Financial A 1,055,000.00 7/12/2019 2.85% 5/17/2024 1,079,792.50 2.33% 3,674.92 1,026,232.26 503 380144AC9 GM Financial Auto Leasing Trust AAA 441,824.23 5/26/2021 0.34% 5/20/2024 441,754.87 0.35% 45.90 436,450.41 506 04636NAC7 Astrazeneca A 415,000.00 5/28/2021 0.70% 5/28/2024 414,962.65 0.70% 266.29 391,750.87 514 24422EVQ9 Deere & Company A 315,000.00 6/10/2021 0.45% 6/7/2024 314,606.25 0.49% 94.50 296,106.62 524 91282CCG4 U.S. Treasury AA+ 1,000,000.00 7/7/2021 0.25% 6/15/2024 995,429.69 0.41% 116.76 938,593.80 532 02665WCZ2 American Honda Finance A- 125,000.00 7/16/2019 2.40% 6/27/2024 124,357.50 2.51% 33.33 120,314.75 544 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,268,216.40 548 20772KJW0 State Of Connecticut AA- 190,000.00 6/11/2020 2.00% 7/1/2024 190,000.00 2.00% 1,898.10 182,692.60 548 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,080,874.30 555 65479CAD0 Nissan Auto Receivables AAA 86,138.90 6/30/2020 0.55% 7/15/2024 86,136.54 0.55% 21.06 85,294.34 562 05591RAD6 BMW Financial Services NA LLC AAA 210,000.00 3/10/2021 0.37% 7/25/2024 209,991.66 0.37% 12.95 204,993.18 572 City of Napa
Quarterly Investment Report - Maturity Report
as of December 31, 2022
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 December 31, 2022
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,043,577.96 577 912828Y87 U.S. Treasury AA+ 1,200,000.00 12/4/2019 1.75% 7/31/2024 1,204,171.87 1.67% 8,788.04 1,147,687.44 578 3137FBTA4 Federal Home Loan Mortgage Corporation AA+ 974,605.97 5/31/2022 3.06% 8/1/2024 975,900.36 3.00% 2,488.49 951,724.33 579 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 302,522.85 579 574193TQ1 Maryland St AAA 400,000.00 8/5/2020 0.51% 8/1/2024 399,888.00 0.52% 850.00 376,992.00 579 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 757,973.40 579 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 228,969.41 590 904764BN6 Unilever Plc A+ 100,000.00 8/12/2021 0.63% 8/12/2024 100,000.00 0.63% 241.71 93,838.00 590 254687FK7 The Walt Disney Corporation BBB+ 1,085,000.00 9/6/2019 1.75% 8/30/2024 1,080,573.20 1.84% 6,381.91 1,034,165.58 608 9128282U3 U.S. Treasury AA+ 4,000,000.00 5/9/2022 1.88% 8/31/2024 3,917,343.75 2.80% 25,483.43 3,825,000.00 609 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,994.40 610 24422EVU0 Deere & Company A 200,000.00 9/10/2021 0.63% 9/10/2024 199,870.00 0.65% 385.42 186,493.40 619 91282CCX7 U.S. Treasury AA+ 1,850,000.00 10/6/2021 0.38% 9/15/2024 1,843,496.09 0.50% 2,069.75 1,723,679.78 624 91282CCX7 U.S. Treasury AA+ 3,000,000.00 10/6/2021 0.38% 9/15/2024 2,987,343.75 0.52% 3,356.35 2,795,156.40 624 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,663,307.63 632 9128282Y5 U.S. Treasury AA+ 1,320,000.00 12/4/2019 2.13% 9/30/2024 1,347,121.88 1.68% 7,166.62 1,266,168.82 639 89237VAB5 Toyota Motor Corp AAA 138,417.29 7/27/2020 0.44% 10/15/2024 138,406.64 0.44% 27.07 136,253.02 654 91282CDB4 U.S. Treasury AA+ 1,000,000.00 10/15/2021 0.63% 10/15/2024 998,867.19 0.66% 1,339.29 933,593.80 654 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,876.78 663 605581MZ7 Mississippi State AA 155,000.00 8/6/2020 0.57% 11/1/2024 155,000.00 0.57% 145.96 143,058.80 671 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 669,713.10 671 9128283J7 U.S. Treasury AA+ 1,130,000.00 1/6/2020 2.13% 11/30/2024 1,154,498.05 1.66% 2,110.99 1,081,445.26 700 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 760,501.06 701 14315XAC2 Carmax Auto Owner Trust AAA 45,675.78 1/22/2020 1.89% 12/16/2024 45,666.82 1.89% 38.37 45,129.47 716 44891TAD8 Hyundai Auto Lease Securitization Trust AAA 140,000.00 1/20/2021 0.42% 12/16/2024 139,988.35 0.42% 26.13 137,745.48 716 91282CDS7 U.S. Treasury AA+ 7,000,000.00 1/18/2022 1.13% 1/15/2025 6,977,851.56 1.23% 36,379.08 6,548,281.60 746 89236TGT6 Toyota Motor Corp A+ 500,000.00 5/26/2020 1.80% 2/13/2025 504,885.00 1.58% 3,450.00 470,910.00 775 89236TGT6 Toyota Motor Corp A+ 390,000.00 5/26/2020 1.80% 2/13/2025 393,810.30 1.58% 2,691.00 367,309.80 775 91282CDZ1 U.S. Treasury AA+ 3,900,000.00 5/9/2022 1.50% 2/15/2025 3,754,664.06 2.91% 22,096.47 3,669,656.25 777 92290BAA9 Verizon Owner Trust NR 292,092.46 8/12/2020 0.47% 2/20/2025 292,031.12 0.47% 41.95 287,585.79 782 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 676,828.60 791 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,634,556.53 800 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,061,750.25 804 650036DT0 New York State Urban Development Corp AA+ 1,220,000.00 12/23/2020 0.87% 3/15/2025 1,220,000.00 0.87% 3,125.23 1,120,240.60 805 14315FAD9 Carmax Auto Owner Trust AAA 31,051.51 7/22/2020 0.62% 3/17/2025 31,046.19 0.62% 8.56 30,517.31 807 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 644,825.94 830 437076CM2 Home Depot Inc A 125,000.00 3/28/2022 2.70% 4/15/2025 124,781.25 2.76% 712.50 119,595.75 836 362590AC5 Gm Financial Securitized Term NR 178,506.83 8/19/2020 0.45% 4/16/2025 178,465.99 0.45% 33.47 174,383.43 837 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,348.00 846 037833DT4 Apple Inc AA+ 800,000.00 5/14/2020 1.13% 5/11/2025 801,680.00 1.08% 1,250.00 736,883.20 862 166764BW9 Chevron Corporation AA- 500,000.00 5/15/2020 1.55% 5/11/2025 502,480.00 1.45% 1,079.17 465,854.50 862 369550BG2 General Dynamics Corp. A- 900,000.00 3/8/2021 3.50% 5/15/2025 993,708.00 0.96% 4,025.00 875,629.80 866 91412HGE7 University Of California AA 400,000.00 7/16/2020 0.88% 5/15/2025 400,000.00 0.88% 451.31 361,220.00 866 912828ZT0 U.S. Treasury AA+ 3,500,000.00 10/6/2021 0.25% 5/31/2025 3,442,851.56 0.70% 769.23 3,175,156.25 882 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 255,031.23 897 912828XZ8 U.S. Treasury AA+ 1,545,000.00 12/4/2020 2.75% 6/30/2025 1,710,423.63 0.39% 117.37 1,487,545.31 912
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 December 31, 2022
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 452,420.10 913 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 173,656.20 913 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 182,796.00 913 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 743,904.00 913 91282CAB7 U.S. Treasury AA+ 525,000.00 5/5/2021 0.25% 7/31/2025 516,386.72 0.64% 549.25 473,648.44 943 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 793,519.05 944 798306WP7 San Juan, California NR 525,000.00 10/29/2020 0.85% 8/1/2025 525,000.00 0.85% 1,863.75 476,925.75 944 60412AVJ9 Minnesota St AAA 355,000.00 8/25/2020 0.63% 8/1/2025 355,000.00 0.63% 931.88 320,948.40 944 54438CYK2 Los Angeles, California AA+ 530,000.00 11/10/2020 0.77% 8/1/2025 530,000.00 0.77% 1,707.04 480,969.70 944 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 473,691.75 944 50117TAC5 Kubota Credit NR 200,000.00 4/14/2021 0.62% 8/15/2025 199,959.08 0.62% 55.11 190,504.86 958 912828K74 U.S. Treasury AA+ 2,500,000.00 11/4/2022 2.00% 8/15/2025 2,341,113.28 4.46% 18,885.87 2,359,765.50 958 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 856,685.30 968 91282CAJ0 U.S. Treasury AA+ 2,000,000.00 9/6/2022 0.25% 8/31/2025 1,815,312.50 3.54% 1,698.90 1,797,812.40 974 20772KEW5 State Of Connecticut AA- 850,000.00 11/19/2020 3.74% 9/15/2025 966,985.50 0.83% 9,367.90 834,589.50 989 44933LAC7 Hyundai Auto Receivables AAA 242,943.69 4/28/2021 0.38% 9/15/2025 242,918.13 0.38% 41.03 234,966.95 989 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,325,747.70 997 91282CAM3 U.S. Treasury AA+ 500,000.00 6/30/2021 0.25% 9/30/2025 489,414.06 0.76% 319.37 448,828.10 1,004 91282CAM3 U.S. Treasury AA+ 3,750,000.00 6/30/2021 0.25% 9/30/2025 3,693,017.58 0.63% 2,395.26 3,366,210.75 1,004 61747YEG6 Morgan Stanley A- 180,000.00 10/19/2021 1.16% 10/21/2025 180,000.00 1.16% 407.40 165,632.22 1,025 61747YEG6 Morgan Stanley A- 500,000.00 10/19/2021 1.16% 10/21/2025 467,560.00 3.18% 1,131.67 460,089.50 1,025 89115B6K1 Toronto-Dominion Bank A 1,600,000.00 10/31/2022 5.60% 10/27/2025 1,600,000.00 5.58% 15,431.11 1,599,292.48 1,031 3135G06G3 Federal National Mortgage Association AA+ 540,000.00 11/12/2020 0.50% 11/7/2025 538,066.80 0.57% 405.00 485,197.02 1,042 43815EAC8 Honda Auto Receivables AAA 390,000.00 8/25/2021 0.41% 11/18/2025 389,994.31 0.41% 57.74 371,504.60 1,053 14316NAC3 Carmax Auto Owner Trust AAA 107,599.55 1/27/2021 0.34% 12/15/2025 107,578.28 0.34% 16.26 103,852.08 1,080 91282CBC4 U.S. Treasury AA+ 3,000,000.00 2/2/2021 0.38% 12/31/2025 2,993,554.69 0.42% 31.08 2,679,375.00 1,096 172967KG5 Citigroup Inc BBB+ 900,000.00 10/6/2021 3.70% 1/12/2026 990,855.00 1.26% 15,632.50 866,114.10 1,108 43815GAC3 Honda Auto Receivables NR 460,000.00 11/24/2021 0.88% 1/21/2026 459,903.03 0.89% 112.44 436,560.65 1,117 17327CAN3 Citigroup Inc BBB+ 245,000.00 1/25/2022 2.01% 1/25/2026 245,000.00 2.01% 2,138.20 227,229.42 1,121 91282CBH3 U.S. Treasury AA+ 1,315,000.00 3/3/2021 0.38% 1/31/2026 1,294,812.70 0.69% 2,063.62 1,169,528.13 1,127 91282CBH3 U.S. Treasury AA+ 2,000,000.00 3/3/2021 0.38% 1/31/2026 1,951,328.13 0.89% 3,138.59 1,778,750.00 1,127 91282CBH3 U.S. Treasury AA+ 675,000.00 3/3/2021 0.38% 1/31/2026 665,850.59 0.69% 1,059.27 600,328.12 1,127 91282CBH3 U.S. Treasury AA+ 5,000,000.00 3/3/2021 0.38% 1/31/2026 4,794,531.25 1.43% 7,846.47 4,446,875.00 1,127 14314QAC8 Carmax Auto Owner Trust AAA 366,030.33 4/21/2021 0.52% 2/17/2026 365,951.45 0.52% 84.59 352,311.92 1,144 91282CBQ3 U.S. Treasury AA+ 5,000,000.00 10/6/2021 0.50% 2/28/2026 4,919,140.63 0.88% 8,494.48 4,453,906.00 1,155 46647PBH8 JPMorgan Chase A- 795,000.00 10/6/2021 2.01% 3/13/2026 816,393.45 1.38% 4,781.93 734,537.07 1,168 91282CBT7 U.S. Treasury AA+ 2,000,000.00 6/4/2021 0.75% 3/31/2026 1,999,218.75 0.76% 3,832.42 1,792,500.00 1,186 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 953,731.00 1,188 46647PCZ7 JPMorgan Chase A- 500,000.00 4/26/2022 4.08% 4/26/2026 499,740.00 4.09% 3,683.33 484,904.50 1,212 91282CBW0 U.S. Treasury AA+ 3,000,000.00 10/6/2021 0.75% 4/30/2026 2,979,140.63 0.91% 3,853.59 2,681,250.00 1,216 04636NAA1 Astrazeneca A 500,000.00 7/19/2021 1.20% 5/28/2026 500,530.00 1.18% 550.00 445,536.00 1,244 91282CCF6 U.S. Treasury AA+ 2,000,000.00 6/4/2021 0.75% 5/31/2026 1,995,781.25 0.79% 1,318.68 1,783,437.60 1,247 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 366,261.51 1,262 91282CCJ8 U.S. Treasury AA+ 2,285,000.00 8/4/2021 0.88% 6/30/2026 2,308,207.03 0.66% 55.23 2,042,218.75 1,277 91282CCJ8 U.S. Treasury AA+ 1,100,000.00 8/4/2021 0.88% 6/30/2026 1,022,656.25 2.64% 26.59 983,125.00 1,277 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 218,924.65 1,278
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 December 31, 2022
91282CCP4 U.S. Treasury AA+ 2,100,000.00 1/5/2022 0.63% 7/31/2026 2,035,195.31 1.32% 5,492.53 1,854,890.52 1,308 9128282A7 U.S. Treasury AA+ 2,580,000.00 5/4/2022 1.50% 8/15/2026 2,423,688.28 3.02% 14,617.66 2,351,428.00 1,323 05602RAD3 Bmw Vehicle Owner Trust AAA 450,000.00 5/18/2022 3.21% 8/25/2026 449,976.60 3.21% 240.75 438,535.80 1,333 91282CCZ2 U.S. Treasury AA+ 550,000.00 10/6/2021 0.88% 9/30/2026 548,281.25 0.94% 1,229.57 488,296.88 1,369 91282CCZ2 U.S. Treasury AA+ 2,000,000.00 10/6/2021 0.88% 9/30/2026 1,990,390.63 0.97% 4,471.15 1,775,625.00 1,369 448977AD0 Hyundai Auto Receivables AAA 830,000.00 3/16/2022 2.22% 10/15/2026 829,968.05 2.22% 818.93 790,521.96 1,384 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 332,765.83 1,384 912828YQ7 U.S. Treasury AA+ 2,050,000.00 12/16/2021 1.63% 10/31/2026 2,086,835.94 1.24% 5,705.46 1,870,625.00 1,400 91282CDG3 U.S. Treasury AA+ 1,200,000.00 1/18/2022 1.13% 10/31/2026 1,178,578.13 1.51% 2,312.15 1,073,062.56 1,400 91282CDG3 U.S. Treasury AA+ 650,000.00 1/18/2022 1.13% 10/31/2026 626,970.70 1.92% 1,252.42 581,242.22 1,400 025816CM9 American Express BBB+ 800,000.00 12/16/2021 1.65% 11/4/2026 798,760.00 1.68% 2,090.00 707,620.00 1,404 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,003,739.33 1,415 912828U24 U.S. Treasury AA+ 2,000,000.00 5/9/2022 2.00% 11/15/2026 1,912,578.13 3.04% 5,193.37 1,848,437.60 1,415 380146AC4 Gm Financial Securitized Term AAA 350,000.00 1/19/2022 1.26% 11/16/2026 349,969.59 1.26% 183.75 331,221.00 1,416 91282CDK4 U.S. Treasury AA+ 1,200,000.00 12/3/2021 1.25% 11/30/2026 1,203,421.88 1.19% 1,318.68 1,076,250.00 1,430 24422EWA3 Deere & Company A 500,000.00 1/13/2022 1.70% 1/11/2027 497,180.00 1.82% 4,013.89 446,958.50 1,472 87612EBM7 Target Corp A 215,000.00 1/24/2022 1.95% 1/15/2027 214,634.50 1.99% 1,933.21 195,016.40 1,476 87612EBM7 Target Corp A 800,000.00 1/24/2022 1.95% 1/15/2027 801,752.00 1.90% 7,193.33 725,642.40 1,476 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 628,436.90 1,487 459200KM2 IBM A- 500,000.00 2/25/2022 2.20% 2/9/2027 493,830.00 2.47% 4,338.89 449,739.00 1,501 459200KM2 IBM A- 900,000.00 2/25/2022 2.20% 2/9/2027 841,185.00 3.72% 7,810.00 809,530.20 1,501 912828V98 U.S. Treasury AA+ 1,825,000.00 7/6/2022 2.25% 2/15/2027 1,771,248.05 2.94% 15,510.02 1,697,250.00 1,507 912828V98 U.S. Treasury AA+ 6,030,000.00 7/6/2022 2.25% 2/15/2027 5,906,808.98 2.73% 51,246.81 5,607,900.00 1,507 438516CE4 Honeywell International A 800,000.00 3/3/2022 1.10% 3/1/2027 762,624.00 2.09% 2,933.33 696,966.40 1,521 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,065,889.20 1,522 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,065,889.20 1,522 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 931,044.00 1,542 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 949,652.00 1,564 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,092,648.38 1,566 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,120,382.40 1,566 91282CEN7 U.S. Treasury AA+ 1,350,000.00 12/7/2022 2.75% 4/30/2027 1,292,625.00 3.81% 6,358.43 1,278,914.13 1,581 665859AW4 Northern Trust A+ 800,000.00 5/12/2022 4.00% 5/10/2027 807,728.00 3.79% 4,533.33 781,616.00 1,591 665859AW4 Northern Trust A+ 400,000.00 5/12/2022 4.00% 5/10/2027 403,848.00 3.79% 2,266.67 390,808.00 1,591 912828X88 U.S. Treasury AA+ 1,800,000.00 9/6/2022 2.38% 5/15/2027 1,717,664.06 3.44% 5,550.41 1,677,375.00 1,596 912828X88 U.S. Treasury AA+ 2,900,000.00 9/6/2022 2.38% 5/15/2027 2,675,136.72 4.28% 8,942.34 2,702,437.50 1,596 91324PEG3 Unitedhealth Group Inc A+ 200,000.00 5/20/2022 3.70% 5/15/2027 199,892.00 3.71% 945.56 193,405.60 1,596 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,379,176.08 1,598 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 958,069.00 1,621 254683CW3 Discover Financial Services AAA 950,000.00 8/9/2022 3.56% 7/15/2027 949,882.11 3.56% 1,503.11 920,762.61 1,657 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,154,121.60 1,678 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,245,089.70 1,689 91282CAH4 U.S. Treasury AA+ 2,800,000.00 12/7/2022 0.50% 8/31/2027 2,407,015.63 3.77% 4,756.91 2,383,062.64 1,704 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,180,564.80 1,713 Total Other 202,138,672.51 200,869,123.46 779,417.43 188,957,084.91 Total LAIF, CAMP, and Securities 259,049,857.56 257,780,308.51 779,417.43 245,868,269.96