|
CITY OF PLEASANTON
<br /> Portfolio Management Page 3
<br /> Portfolio Details with Earnings - Investments
<br /> February 28, 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 /> Federal Agency Issues-Callable
<br /> 3130APVC6 4602 FHLB 12/09/2021 3,000,000.00 2,657,340.00 2,988,000.00 1.375 1371 1.458 10,312.50 -330,660.00 12/01/2026
<br /> 3130AQEC3 4603 FHLB 12/30/2021 3,000,000.00 2,660,790.00 3,000,000.00 1.370 1400 1.370 6,964.17 -339,210.00 12/30/2026
<br /> 3130AQEF6 4604 FHLB 12/30/2021 3,000,000.00 2,661,300.00 2,998,500.00 1.375 1400 1.385 6,989.58 -337,200.00 12/30/2026
<br /> 3130AQG80 4605 FHLB 01/03/2022 3,000,000.00 2,666,040.00 2,999,250.00 1.420 1399 1.425 7,336.67 -333,210.00 12/29/2026
<br /> 313OAQG80 4606 FHLB 01/10/2022 3,000,000.00 2,666,040.00 2,982,750.00 1.420 1399 1.540 7,336.67 -316,710.00 12/29/2026
<br /> 3130AQLD3 4607 FHLB 02/08/2022 3,000,000.00 2,695,170.00 2,975,010.00 1.750 1429 1.926 4,812.50 -279,840.00 01/28/2027
<br /> 3130AQW66 4608 FHLB 03/08/2022 3,000,000.00 2,718,870.00 2,995,500.00 2.080 1457 2.111 1,040.00 -276,630.00 02/25/2027
<br /> 3134GVZ68 4535 FHLMC 06/23/2020 3,000,000.00 2,730,840.00 2,998,950.00 0.700 845 0.707 3,966.67 -268,110.00 06/23/2025
<br /> 3134GWA55 4545 FHLMC 09/09/2020 3,000,000.00 2,697,420.00 2,998,950.00 0.650 923 0.657 9,316.67 -301,530.00 09/09/2025
<br /> 3134GWW93 4547 FHLMC 09/30/2020 3,000,000.00 2,682,030.00 3,000,000.00 0.550 944 0.550 6,920.83 -317,970.00 09/30/2025
<br /> 3134GWWT9 4549 FHLMC 10/07/2020 3,000,000.00 2,696,370.00 2,997,600.00 0.550 944 0.566 6,920.83 -301,230.00 09/30/2025
<br /> 3134GW31`1 4550 FHLMC 10/28/2020 3,000,000.00 2,693,220.00 3,000,000.00 0.600 972 0.600 6,150.00 -306,780.00 10/28/2025
<br /> 3134GXDM3 4554 FHLMC 12/01/2020 3,000,000.00 2,674,950.00 3,000,000.00 0.620 1006 0.620 4,650.00 -325,050.00 12/01/2025
<br /> 3136G4YH0 4538 FNMA 07/14/2020 3,250,000.00 2,941,445.00 3,248,862.50 0.700 866 0.707 2,970.14 -307,417.50 07/14/2025
<br /> 3136G4A45 4541 FNMA 07/22/2020 3,000,000.00 2,713,920.00 3,000,000.00 0.710 874 0.710 2,307.50 -286,080.00 07/22/2025
<br /> 3135GA3W9 4552 FNMA 11/25/2020 3,000,000.00 2,675,850.00 3,000,000.00 0.600 1000 0.600 4,800.00 -324,150.00 11/25/2025
<br /> 3135G06R9 4556 FNMA 01/28/2021 3,000,000.00 2,649,780.00 3,000,000.00 0.550 1064 0.550 1,512.50 -350,220.00 01/28/2026
<br /> Subtotal and Average 158,420,440.80 158,630,000.00 141,192,712.95 158,420,440.80 0.898 1126 0.916 304,282.87 -17,227,727.85
<br /> Supranationals
<br /> 45950VPS9 7000 IFC 06/28/2021 1,000,000.00 882,880.00 980,200.00 0.500 1093 0.935 69.44 -97,320.00 02/26/2026
<br /> Subtotal and Average 980,200.00 1,000,000.00 882,880.00 980,200.00 0.500 1093 0.935 69.44 -97,320.00
<br /> Total and Average 229,597,008.52 227,619,164.66 207,255,216.25 227,890,912.27 1.320 912 1.280 1,484,033.07 -20,635,696.02
<br /> Portfolio PLST
<br /> CC
<br /> :un Date:04/05/2023-07:35 PM(PRF PM8)7.3.11
<br />
|