|
CITY OF PLEASANTON
<br /> Portfolio Management Page 1
<br /> Portfolio Details with Earnings - Investments
<br /> March 31, 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 1090 1090 FREMON 10/21/2021 257,958.09 257,958.09 257,958.09 0.150 20 0.150 558.68 0.00 04/21/2023
<br /> UBB1091 1091 VCB 04/11/2022 261,206.57 261,206.57 261,206.57 0.500 376 0.500 1,270.25 0.00 04/11/2024
<br /> Subtotal and Average 519,164.66 519,164.66 519,164.66 519,164.66 0.326 199 0.326 1,828.93 0.00
<br /> LAIF -
<br /> SYS5 5 LAIF 40,000,000.00 39,460,413.16 40,000,000.00 2.831 1 2.831 179,991.78 -539,586.84
<br /> Subtotal and Average 33,225,806.45 40,000,000.00 39,460,413.16 40,000,000.00 2.831 1 2.831 179,991.78 -539,586.84
<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,904,040.00 2,016,869.48 2.000 685 1.822 5,222.22 -112,829.48 02/14/2025
<br /> 037833CU2 6045 APPL 05/03/2019 2,000,000.00 1,965,640.00 2,009,000.00 2.850 406 2.753 22,166.67 -43,360.00 05/11/2024
<br /> 037833DM9 6048 APPL 01/07/2020 1,040,000.00 1,002,144.00 1,040,000.00 1.800 529 1.799 1,040.00 -37,856.00 09/11/2024
<br /> 037833DF4 6049 APPL 01/13/2020 1,000,000.00 973,530.00 1,037,212.20 2.750 653 1.964 5,958.33 -63,682.20 01/13/2025
<br /> 037833EB2 6065 APPL 02/08/2021 2,000,000.00 1,818,280.00 1,996,860.00 0.700 1044 0.732 2,061.11 -178,580.00 02/08/2026
<br /> 037833BY5 6066 APPL 02/23/2021 3,000,000.00 2,932,860.00 3,331,380.00 3.250 1059 0.980 10,291.67 -398,520.00 02/23/2026
<br /> 17325FAS7 6051 CITIBN 01/23/2020 1,000,000.00 986,320.00 1,065,374.39 3.650 297 1.943 6,894.44 -79,054.39 01/23/2024
<br /> 46632FSCO 6068 JP 06/22/2021 3,000,000.00 2,633,460.00 3,000,000.00 1.100 1178 1.100 9,075.00 -366,540.00 06/22/2026
<br /> 594918BQ6 6022 MICROS 07/12/2018 2,000,000.00 1,979,840.00 1,896,800.00 2.000 129 3.107 5,888.89 83,040.00 08/08/2023
<br /> 594918AT1 6023 MICROS 08/31/2018 1,500,000.00 1,497,255.00 1,457,400.00 2.375 30 3.031 14,843.75 39,855.00 05/01/2023
<br /> 69371RQ25 6062 PCAR 03/31/2020 1,330,000.00 1,282,346.10 1,294,196.40 2.150 502 2.808 3,653.81 -11,850.30 08/15/2024
<br /> 89236TGL3 6046 TOYOTA 10/24/2019 1,600,000.00 1,538,624.00 1,599,984.00 2.000 555 2.000 15,466.67 -61,360.00 10/07/2024
<br /> 892331AC3 6047 TOYOTA 01/07/2020 1,000,000.00 994,630.00 1,055,220.25 3.419 110 1.800 6,743.03 -60,590.25 07/20/2023
<br /> 89236THWB 6067 TOYOTA 03/09/2021 3,000,000.00 2,715,180.00 2,959,140.00 0.800 1014 1.090 5,466.66 -243,960.00 01/09/2026
<br /> 89788JAA7 6058 TRU 03/13/2020 2,000,000.00 1,835,720.00 1,969,486.00 1.500 709 1.821 1,750.00 -133,766.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 705 1.689 5,643.75 -234,897.00 03/06/2025
<br /> 30231GBH4 6064 XOM 04/20/2020 2,000,000.00 1,945,720.00 2,113,800.00 2.992 718 1.777 1,994.67 -168,080.00 03/19/2025
<br /> Subtotal and Average 32,988,309.72 32,470,000.00 30,916,279.10 32,988,309.72 2.150 696 1.763 124,160.67 -2,072,030.62
<br /> Federal Agency Issues-Coupon
<br /> 3133EKGC4 3574 FFCB 04/17/2019 2,000,000.00 1,999,740.00 1,987,140.00 2.250 4 2.420 22,000.00 12,600.00 04/05/2023
<br /> 313OAQF65 3576 FHLB 12/22/2021 3,000,000.00 2,729,460.00 2,995,657.09 1.250 1360 1.280 10,416.66 -266,197.09 12/21/2026
<br /> Subtotal and Average 4,982,797.09 5,000,000.00 4,729,200.00 4,982,797.09 1.649 819 1.735 32,416.66 -253,597.09
<br /> Portfolio PLST
<br /> CC
<br /> ;un Date:05/08/2023-12:54
<br /> PM(PRF PM8)7.3.11
<br />
|