|
CITY OF PLEASANTON
<br /> Portfolio Management Pagel
<br /> Portfolio Details with Earnings - Investments
<br /> April 30, 2023
<br /> Average Purchase Current Days To Accrued Unrealized Maturity
<br /> CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate Maturity YTM Interest Gain/Loss Date
<br /> Certificates of Deposit-Bank
<br /> SYS 1093 1093 FREMON 04/21/2023 230,000.00 230,000.00 230,000.00 4.000 356 4.000 252.05 0.00 04/21/2024
<br /> UBB1091 1091 VCB 04/11/2022 261,206.57 261,206.57 261,206.57 0.500 346 0.500 1,377.59 0.00 04/11/2024
<br /> Subtotal and Average 509,845.30 491,206.57 491,206.57 491,206.57 2.139 351 2.139 1,629.64 0.00
<br /> LAIF
<br /> SYS5 5 LAIF 65,000,000.00 64,123,171.39 65,000,000.00 2.870 1 2.870 96,249.66 -876,828.61
<br /> Subtotal and Average 54,166,666.67 65,000,000.00 64,123,171.39 65,000,000.00 2.870 1 2.870 96,249.66 -876,828.61
<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,906,420.00 2,016,869.48 2.000 655 1.822 8,555.56 -110,449.48 02/14/2025
<br /> 037833CU2 6045 APPL 05/03/2019 2,000,000.00 1,963,800.00 2,009,000.00 2.850 376 2.753 26,916.67 -45,200.00 05/11/2024
<br /> 037833DM9 6048 APPL 01/07/2020 1,040,000.00 1,004,848.00 1,040,000.00 1.800 499 1.799 2,600.00 -35,152.00 09/11/2024
<br /> 037833DF4 6049 APPL 01/13/2020 1,000,000.00 974,660.00 1,037,212.20 2.750 623 1.964 8,250.00 -62,552.20 01/13/2025
<br /> 037833EB2 6065 APPL 02/08/2021 2,000,000.00 1,824,580.00 1,996,860.00 0.700 1014 0.732 3,227.78 -172,280.00 02/08/2026
<br /> 037833BY5 6066 APPL 02/23/2021 3,000,000.00 2,933,280.00 3,331,380.00 3.250 1029 0.980 18,416.67 -398,100.00 02/23/2026
<br /> 17325FAS7 6051 CITIBN 01/23/2020 1,000,000.00 988,170.00 1,065,374.39 3.650 267 1.943 9,936.11 -77,204.39 01/23/2024
<br /> 46632FSCO 6068 JP 06/22/2021 3,000,000.00 2,645,250.00 3,000,000.00 1.100 1148 1,100 11,825.00 -354,750.00 06/22/2026
<br /> 594918BQ6 6022 MICROS 07/12/2018 2,000,000.00 1,985,900.00 1,896,800.00 2.000 99 3.107 9,222.22 89,100.00 08/08/2023
<br /> 594918AT1 6023 MICROS 08/31/2018 1,500,000.00 1,500,000.00 1,457,400.00 2.375 0 3.031 17,812.50 42,600.00 05/01/2023
<br /> 69371RQ25 6062 PCAR 03/31/2020 1,330,000.00 1,286,163.20 1,294,196.40 2.150 472 2.808 6,036.72 -8,033.20 08/15/2024
<br /> 89236TGL3 6046 TOYOTA 10/24/2019 1,600,000.00 1,540,144.00 1,599,984.00 2.000 525 2.000 2,133.33 -59,840.00 10/07/2024
<br /> 892331AC3 6047 TOYOTA 01/07/2020 1,000,000.00 994,430.00 1,055,220.25 3.419 80 1.800 9,592.19 -60,790.25 07/20/2023
<br /> 89236THWB 6067 TOYOTA 03/09/2021 3,000,000.00 2,730,900.00 2,959,140.00 0.800 984 1.090 7,466.66 -228,240.00 01/09/2026
<br /> 89788JAA7 6058 TRU 03/13/2020 2,000,000.00 1,856,000.00 1,969,486.00 1.500 679 1.821 4,250.00 -113,486.00 03/10/2025
<br /> 30231GAF9 6056 XOM 03/11/2020 3,000,000.00 2,910,690.00 3,145,587.00 2.709 675 1.689 12,416.25 -234,897.00 03/06/2025
<br /> 30231GBH4 6064 XOM 04/20/2020 2,000,000.00 1,946,840.00 2,113,800.00 2.992 688 1.777 6,981.33 -166,960.00 03/19/2025
<br /> Subtotal and Average 32,988,309.72 32,470,000.00 30,992,075.20 32,968,309.72 2.150 666 1.763 165,638.99 -1,996,234.52
<br /> Federal Agency Issues-Coupon
<br /> 313OAQF65 3576 FHLB 12/22/2021 3,000,000.00 2,744,760.00 2,995,657.09 1.250 1330 1.280 13,541.66 -250,897.09 12/21/2026
<br /> Subtotal and Average 3,260,609.09 3,000,000.00 2,744,760.00 2,995,657.09 1.250 1330 1.280 13,541.66 -250,897.09
<br /> Portfolio PLST
<br /> CC
<br /> Run Date:06/05/2023-16:16 PM(PRF_PM8)7.3.11
<br /> Report Ver.7.3.11
<br />
|