|
CITY OF PLEASANTON
<br /> Portfolio Management Page
<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 ValueYTM
<br /> Rate Maturity Interest Gain/Loss Date
<br /> Federal Agency Issues-Callable
<br /> 3130APU78 4600 FHLB 12/09/2021 530,000.00 478,277.30 526,947.20 1.300 1303 1.420 3,004.81 -48,669.90 11/24/2026
<br /> 3130APUR4 4601 FHLB 12/09/2021 1,840,000.00 1,660,434.40 1,829,401.60 1.300 1303 1.420 10,431.78 -168,967.20 11/24/2026
<br /> 3130APVC6 4602 FHLB 12/09/2021 3,000,000.00 2,716,620.00 2,988,000.00 1.375 1310 1.458 17,187.50 -271,380.00 12/01/2026
<br /> 3130AQEC3 4603 FHLB 12/30/2021 3,000,000.00 2,711,160.00 3,000,000.00 1.370 1339 1.370 13,814.17 -288,840.00 12/30/2026
<br /> 3130AQEF6 4604 FHLB 12/30/2021 3,000,000.00 2,711,640.00 2,998,500.00 1.375 1339 1.385 13,864.58 -286,860.00 12/30/2026
<br /> 3130AQGBO 4605 FHLB 01/03/2022 3,000,000.00 2,716,110.00 2,999,250.00 1.420 1338 1.425 14,436.67 -283,140.00 12/29/2026
<br /> 3130AQGSO 4606 FHLB 01/10/2022 3,000,000.00 2,716,110.00 2,982,750.00 1.420 1338 1.540 14,436.67 -266,640.00 12/29/2026
<br /> 3130AQLD3 4607 FHLB 02/08/2022 3,000,000.00 2,753,370.00 2,975,010.00 1.750 1368 1.926 13,562.50 -221,640.00 01/28/2027
<br /> 3130AQW66 4608 FHLB 03/08/2022 3,000,000.00 2,779,170.00 2,995,500.00 2.080 1396 2.111 11,440.00 -216,330.00 02/25/2027
<br /> 3134GVZ68 4535 FHLMC 06/23/2020 3,000,000.00 2,777,280.00 2,998,950.00 0.700 784 0.707 7,466.67 -221,670.00 06/23/2025
<br /> 3134GWA55 4545 FHLMC 09/09/2020 3,000,000.00 2,758,230.00 2,998,950.00 0.650 862 0.657 2,816.67 -240,720.00 09/09/2025
<br /> 3134GWW93 4547 FHLMC 09/30/2020 3,000,000.00 2,747,100.00 3,000,000.00 0.550 883 0.550 1,420.83 -252,900.00 09/30/2025
<br /> 3134GWWT9 4549 FHLMC 10/07/2020 3,000,000.00 2,747,100.00 2,997,600.00 0.550 883 0.566 1,420.83 -250,500.00 09/30/2025
<br /> 3134GW3F1 4550 FHLMC 10/28/2020 3,000,000.00 2,745,510.00 3,000,000.00 0.600 911 0.600 150.00 -254,490.00 10/28/2025
<br /> 3134GXDM3 4554 FHLMC 12/01/2020 3,000,000.00 2,735,130.00 3,000,000.00 0.620 945 0.620 7,750.00 -264,870.00 12/01/2025
<br /> 3136G4YH0 4538 FNMA 07/14/2020 3,250,000.00 3,004,495.00 3,248,862.50 0.700 805 0.707 6,761.81 -244,367.50 07/14/2025
<br /> 3136G4A45 4541 FNMA 07/22/2020 3,000,000.00 2,772,360.00 3,000,000.00 0.710 813 0.710 5,857.50 -227,640.00 07/22/2025
<br /> 3135GA3W9 4552 FNMA 11/25/2020 3,000,000.00 2,740,440.00 3,000,000.00 0.600 939 0.600 7,800.00 -259,560.00 11/25/2025
<br /> 3135G06R9 4556 FNMA 01/28/2021 3,000,000.00 2,715,990.00 3,000,000.00 0.550 1003 0.550 4,262.50 -284,010.00 01/28/2026
<br /> Subtotal and Average 158,420,440.80 158,630,000.00 144,406,180.80 158,420,440.80 0.898 1065 0.916 353,745.79 -14,014,260.00
<br /> Supranationals
<br /> 45950VPS9 7000 IFC 06/28/2021 1,000,000 00 905,970.00 980,200.00 0.500 1032 0.935 902.78 -74,230.00 02/26/2026
<br /> Subtotal and Average 980,200 00 1,000,000.00 905,970.00 980,200.00 0.500 1032 0.935 902.78 -74,230.00
<br /> Total and Average 250,326,071.57 260,591,206.57 243,663,363.96 260,875,814.18 1.552 751 1.516 1,540,876.85 -17,212,450.22
<br /> Portfolio PLST
<br /> CC
<br /> Run Date:06/05/2023-16:16 PM(PRF_PM8)7.3.11
<br />
|