|
CITY OF PLEASANTON
<br /> Portfolio Management Page
<br /> Portfolio Details with Earnings - Investments
<br /> December 31, 2022
<br /> Average Purchase Current Days To Accrued Unrealized Maturity
<br /> CUSIP Investment# Issuer Balance Date Par Value Market Value Book ValueYTM
<br /> Rat Maturity Interest Gain/Loss Date
<br /> Federal Agency Issues-Callable
<br /> 3130AMWK4 4597 FHLB 07/14/2021 3,000,000.00 2,667,270.00 2,999,250.00 1.020 1290 1.025 14,195.00 -331,980.00 07/14/2026
<br /> 3130AP2P9 4598 FHLB 09/30/2021 3,000,000.00 2,640,720.00 2,983,500.00 0.920 1368 1.033 6,976.67 -342,780.00 09/30/2026
<br /> 3130APC94 4599 FHLB 10/14/2021 3,000,000.00 2,652,780.00 2,997,750.00 1,070 1382 1.085 22,915.83 -344,970.00 10/14/2026
<br /> 3130APU78 4600 FHLB 12/09/2021 530,000.00 471,355.50 526,947.20 1.300 1423 1.420 708.14 -55,591.70 11/24/2026
<br /> 3130APUR4 4601 FHLB 12/09/2021 1,840,000.00 1,636,404.00 1,829,401.60 1.300 1423 1.420 2,458.44 -192,997.60 11/24/2026
<br /> 3130APVC6 4602 FHLB 12/09/2021 3,000,000.00 2,674,500.00 2,988,000.00 1.375 1430 1.458 3,437.50 -313,500.00 12/01/2026
<br /> 3130AQEC3 4603 FHLB 12/30/2021 3,000,000.00 2,668,650.00 3,000,000.00 1.370 1459 1.370 114.17 -331,350.00 12/30/2026
<br /> 3130AQEF6 4604 FHLB 12/30/2021 3,000,000.00 2,669,190.00 2,998,500.00 1.375 1459 1.385 114.58 -329,310.00 12/30/2026
<br /> 313OAQGBO 4605 FHLB 01/03/2022 3,000,000.00 2,674,050.00 2,999,250.00 1.420 1458 1.425 236.67 -325,200.00 12/29/2026
<br /> 313OAQG80 4606 FHLB 01/10/2022 3,000,000.00 2,674,050.00 2,982,750.00 1.420 1458 1.540 236.67 -308,700.00 12/29/2026
<br /> 3130AQLD3 4607 FHLB 02/08/2022 3,000,000.00 2,702,550.00 2,975,010.00 1.750 1488 1.926 22,312.50 -272,460.00 01/28/2027
<br /> 313OAQW66 4608 FHLB 03/08/2022 3,000,000.00 2,731,320.00 2,995,500.00 2.080 1516 2.111 21,840.00 -264,180.00 02/25/2027
<br /> 3134GVZ68 4535 FHLMC 06/23/2020 3,000,000.00 2,726,190.00 2,998,950.00 0.700 904 0.707 466.67 -272,760.00 06/23/2025
<br /> 3134GWA55 4545 FHLMC 09/09/2020 3,000,000.00 2,692,290.00 2,998,950.00 0.650 982 0.657 6,066.67 -306,660.00 09/09/2025
<br /> 3134GWW93 4547 FHLMC 09/30/2020 3,000,000.00 2,698,620.00 3,000,000.00 0.550 1003 0.550 4,170.83 -301,380.00 09/30/2025
<br /> 3134GWWT9 4549 FHLMC 10/07/2020 3,000,000.00 2,698,620.00 2,997,600.00 0.550 1003 0.566 4,170.83 -298,980.00 09/30/2025
<br /> 3134GW3F1 4550 FHLMC 10/28/2020 3,000,000.00 2,695,560.00 3,000,000.00 0.600 1031 0.600 12,150.00 -304,440.00 10/28/2025
<br /> 3134GXDM3 4554 FHLMC 12/01/2020 3,000,000.00 2,687,700.00 3,000,000.00 0.620 1065 0.620 1,550.00 -312,300.00 12/01/2025
<br /> 3136G4YH0 4538 FNMA 07/14/2020 3,250,000.00 2,952,430.00 3,248,862.50 0.700 925 0.707 10,553.47 -296,432.50 07/14/2025
<br /> 3136G4A45 4541 FNMA 07/22/2020 3,000,000.00 2,724,270.00 3,000,000.00 0.710 933 0.710 9,407.50 -275,730.00 07/22/2025
<br /> 3135GA3W9 4552 FNMA 11/25/2020 3,000,000.00 2,687,400.00 3,000,000.00 0.600 1059 0.600 1,800.00 -312,600.00 11/25/2025
<br /> 3135G06R9 4556 FNMA 01/28/2021 3,000,000.00 2,668,170.00 3,000,000.00 0.550 1123 0.550 7,012.50 -331,830.00 01/28/2026
<br /> Subtotal and Average 1.56,421,036.79 158,630,000.00 141,785,469.45 159,420,440.80 0.898 1185 0.916 347,868.94 -16,634,971.35
<br /> Supranationals
<br /> 45950VPS9 7000 IFC 06/28/2021 1,000,000.00 885.680.00 980,200.00 0.500 1152 0.935 1,736.11 -94,520.00 02/26/2026
<br /> Subtotal and Average 980,200.00 1,000,000.00 885,680.00 980.200.00 0.500 1152 0.935 1,736.11 -94,520.00
<br /> Total and Average 220,877,676.97 233,799,164.66 214,083,147.35 234,038,371.30 1.303 939 1.268 1,628,773.57 -19,955,223.95
<br /> Portfolio PLST
<br /> Run Date:02/06/2023-16:25 CC
<br /> PM(PRF_PMO)7.3.11
<br />
|