|
CITY OF PLEASANTON
<br /> Portfolio Management Page 3
<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 Rate Maturity YTM Interest Gain/Loss Date
<br /> Federal Agency Issues-Callable
<br /> 3130APUR4 4601 FHLB 12/09/2021 1,840,000.00 1,664,151.20 1,829,401.60 1.300 1392 1.420 4,451.78 -165,250.40 11/24/2026
<br /> 3130APVC6 4602 FHLB 12/09/2021 3,000,000.00 2,716,020.00 2,988,000.00 1.375 1399 1.458 6,875.00 -271,980.00 12/01/2026
<br /> 3130AQEC3 4603 FHLB 12/30/2021 3,000,000.00 2,711,520.00 3,000,000.00 1.370 1428 1.370 3,539.17 -288,480.00 12/30/2026
<br /> 3130AQEF6 4604 FHLB 12/30/2021 3,000,000.00 2,712,060.00 2,998,500.00 1.375 1428 1.385 3,552.08 -286,440.00 12/30/2026
<br /> 3130AQG80 4605 FHLB 01/03/2022 3,000,000.00 2,716,680.00 2,999,250.00 1.420 1427 1.425 3,786.67 -282,570.00 12/29/2026
<br /> 3130AQG80 4606 FHLB 01/10/2022 3,000,000.00 2,716,680.00 2,982,750.00 1.420 1427 1.540 3,786.67 -266,070.00 12/29/2026
<br /> 3130AQLD3 4607 FHLB 02/08/2022 3,000,000.00 2,746,860.00 2,975,010.00 1.750 1457 1.926 437.50 -228,150.00 01/28/2027
<br /> 3130AQW66 4608 FHLB 03/08/2022 3,000,000.00 2,780,070.00 2,995,500.00 2.080 1485 2.111 27,040.00 -215,430.00 02/25/2027
<br /> 3134GVZ68 4535 FHLMC 06/23/2020 3,000,000.00 2,757,450.00 2,998,950.00 0.700 873 0.707 2,216.67 -241,500.00 06/23/2025
<br /> 3134GWA55 4545 FHLMC 09/09/2020 3,000,000.00 2,737,950.00 2,998,950.00 0.650 951 0.657 7,691.67 -261,000.00 09/09/2025
<br /> 3134GWW93 4547 FHLMC 09/30/2020 3,000,000.00 2,726,310.00 3,000,000.00 0.550 972 0.550 5,545.83 -273,690.00 09/30/2025
<br /> 3134GWWT9 4549 FHLMC 10/07/2020 3,000,000.00 2,726,310.00 2,997,600.00 0.550 972 0.566 5,545.83 -271,290.00 09/30/2025
<br /> 3134GW3F1 4550 FHLMC 10/28/2020 3,000,000.00 2,724,030.00 3,000,000.00 0.600 1000 0.600 4,650.00 -275,970.00 10/28/2025
<br /> 3134GXDM3 4554 FHLMC 12/01/2020 3,000,000.00 2,718,630.00 3,000,000.00 0.620 1034 0.620 3,100.00 -281,370.00 12/01/2025
<br /> 3136G4YH0 4538 FNMA 07/14/2020 3,250,000.00 2,982,460.00 3,248,862.50 0.700 894 0.707 1,074.31 -266,402.50 07/14/2025
<br /> 3136G4A45 4541 FNMA 07/22/2020 3,000,000.00 2,752,020.00 3,000,000.00 0.710 902 0.710 532.50 -247,980.00 07/22/2025
<br /> 3135GA3W9 4552 FNMA 11/25/2020 3,000,000.00 2,711,100.00 3,000,000.00 0.600 1028 0.600 3,300.00 -288,900.00 11/25/2025
<br /> 3135G06R9 4556 FNMA 01/28/2021 3,000,000.00 2,695,440.00 3,000,000.00 0.550 1092 0.550 137.50 -304,560.00 01/28/2026
<br /> Subtotal and Average 158,420,440.80 158,630,000.00 143,543,549.60 158,420,440.80 0.898 1154 0.916 335,275.92 -14,876,891.20
<br /> Supranationals
<br /> 45950VPS9 7000 IFC 06/28/2021 1,000,000.00 896,780.00 980,200.00 0.500 1121 0.935 2,152.78 -83,420.00 02/26/2026
<br /> Subtotal and Average 980,200.00 1,000,000.00 896,780.00 980,200.00 0.500 1121 0.935 2,152.78 -83,420.00
<br /> Total and Average 233,064,439.11 230,619,164.66 212,960,903.20 230,883,281.77 1.315 924 1.276 1,546,714.46 -17,922,378.57
<br /> Portfolio PLST
<br /> :un Date:03/07/2023-14:27 CC
<br /> PM(PRF_PM8)7.3.11
<br />
|