|
CITY OF PLEASANTON
<br /> Portfolio Management Page 1
<br /> Portfolio Details with Earnings - Investments
<br /> January 31, 2023
<br /> Average Purchase Current Days To Accrued Unrealized Maturity
<br /> CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value YTM
<br /> -- Rat Maturity Interest Gain/Loss Date
<br /> Certificates of Deposit-Bank
<br /> SYS 1090 1090 FREMON 10/21/2021 257,958.09 257,958.09 257,958.09 0.150 79 0.150 496.13 0.00 04/21/2023
<br /> UBB1091 1091 VCB 04/11/2022 261,206.57 261,206.57 261,206.57 0.500 435 0.500 1,059.14 0.00 04/11/2024
<br /> Subtotal and Average 519,164.66 519,164.66 519,164.66 519,164.66 0.326 258 0.326 1,555.27 0.00
<br /> LAIF - _ -
<br /> SYS5 5 LAIF 30,000,000.00 29,441,677.74 30,000,000.00 2.425 1 2.425 25,716.51 -558,322.26
<br /> Subtotal and Average 30,000,000.00 30,000,000.00 29,441,677.74 30,000,000.00 2.425 1 2.425 25,716.51 -558,322.26
<br /> Fidelity-Government Fund
<br /> SYS2 2 FID 0.00 0.00 0.00 0.010 1 0.010 331,133.68 0.00
<br /> SYS2A 2A FID 0.00 0.00 0.00 0.010 1 0.010 578,034.65 0.00
<br /> Subtotal and Average 0.00 0.00 0.00 0.00 0.000 0 0.000 909,168.33 0.00
<br /> Medium Term Notes
<br /> 88579YBH3 6053 3M 02/14/2020 2,000,000.00 1,901,220.00 2,016,869.48 2.000 744 1.822 18,555.56 -115,649.48 02/14/2025
<br /> 037833BU3 6024 APPL 08/31/2018 1,500,000.00 1,498,590.00 1,487,250.00 2.850 22 3.054 18,762.50 11,340.00 02/23/2023
<br /> 037833CU2 6045 APPL 05/03/2019 2,000,000.00 1,957,540.00 2,009,000.00 2.850 465 2.753 12,666.67 -51,460.00 05/11/2024
<br /> 037833DM9 6048 APPL 01/07/2020 1,040,000.00 996,028.80 1,040,000.00 1.800 588 1.799 7,280.00 -43,971.20 09/11/2024
<br /> 037833DF4 6049 APPL 01/13/2020 1,000,000.00 969,220.00 1,037,212.20 2.750 712 1.964 1,375.00 -67,992.20 01/13/2025
<br /> 037833EB2 6065 APPL 02/08/2021 2,000,000.00 1,800,020.00 1,996,860.00 0.700 1103 0.732 6,727.78 -196,840.00 02/08/2026
<br /> 037833BY5 6066 APPL 02/23/2021 3,000,000.00 2,913,210.00 3,331,380.00 3.250 1118 0.980 42,791.67 -418,170.00 02/23/2026
<br /> 084670BJ6 6060 BERK 03/24/2020 1,500,000.00 1,499,130.00 1,505,119.50 3.000 10 2.874 21,250.00 -5,989.50 02/11/2023
<br /> 17325FAS7 6051 CITIBN 01/23/2020 1,000,000.00 989,420.00 1,065,374.39 3.650 356 1.943 811.11 -75,954.39 01/23/2024
<br /> 46632FSCO 6068 JP 06/22/2021 3,000,000.00 2,612,910.00 3,000,000.00 1.100 1237 1.100 3,575.00 -387,090.00 06/22/2026
<br /> 594918BQ6 6022 MICROS 07/12/2018 2,000,000.00 1,971,840.00 1,896,800.00 2.000 188 3.107 19,222.22 75,040.00 08/08/2023
<br /> 594918ATI 6023 MICROS 08/31/2018 1,500,000.00 1,492,215.00 1,457,400.00 2.375 89 3.031 8,906.25 34,815.00 05/01/2023
<br /> 69371RQ25 6062 PCAR 03/31/2020 1,330,000.00 1,277,837.40 1,294,196.40 2.150 561 2.808 13,185.47 -16,359.00 08/15/2024
<br /> 89236TGL3 6046 TOYOTA 10/24/2019 1,600,000.00 1,531,840.00 1,599,984.00 2.000 614 2.000 10,133.33 -68,144.00 10/07/2024
<br /> 892331AC3 6047 TOYOTA 01/07/2020 1,000,000.00 995,360.00 1,055,220.25 3.419 169 1.800 1,044.69 -59,860.25 07/20/2023
<br /> 89236THW8 6067 TOYOTA 03/09/2021 3,000,000.00 2,710,410.00 2,959,140.00 0.800 1073 1.090 1,466.66 -248,730.00 01/09/2026
<br /> 89788JAA7 6058 TRU 03/13/2020 2,000,000.00 1,874,700.00 1,969,486.00 1.500 768 1.821 11,750.00 -94,786.00 03/10/2025
<br /> 30231GAF9 6056 XOM 03/11/2020 3,000,000.00 2,908,410.00 3,145,587.00 2.709 764 1.689 32,733.75 -237,177.00 03/06/2025
<br /> 30231GBH4 6064 XOM 04/20/2020 2,000,000.00 1,943,660.00 2,113,800.00 2.992 777 1.777 21,941.33 -170,140.00 03/19/2025
<br /> Subtotal and Average 38,161,836.56 35,470,000.00 33,843,561.20 35,980,679.22 2.214 694 1.863 254,178.99 -2,137,118.02
<br /> Federal Agency Issues-Coupon
<br /> 3133EKGC4 3574 FFCB 04/17/2019 2,000,000.00 1,991,780.00 1,987,140.00 2.250 63 2.420 14,500.00 4,640.00 04/05/2023
<br /> 313OAQF65 3576 FHLB 12/22/2021 3,000,000.00 2,724,390.00 2,995,657.09 1.250 1419 1.280 4,166.66 -271,267.09 12/21/2026
<br /> Portfolio PLST
<br /> CC
<br /> :un Date:03/07/2023-14:27
<br /> PM(PRF_PM8)7.3.11
<br />
|