|
CITY OF PLEASANTON
<br /> Portfolio Management Page 3
<br /> Portfolio Details with Earnings - Investments
<br /> November 30, 2022
<br /> Average Purchase Current Days To Accrued Unrealized Maturity
<br /> CUSIP Investment# Issuer Balance Date Par Value Market Value Book ValueRate Maturity YTM
<br /> Interest Gain/Loss Date
<br /> Federal Agency Issues-Callable
<br /> 3130AMWK4 4597 FHLB 07/14/2021 3,000,000.00 2,663,730.00 2,999,250.00 1.020 1321 1.025 11,645.00 -335,520.00 07/14/2026
<br /> 3130AP2P9 4598 FHLB 09/30/2021 3,000,000.00 2,637,690.00 2,983,500.00 0.920 1399 1.033 4,676.67 -345,810.00 09/30/2026
<br /> 3130APC94 4599 FHLB 10/14/2021 3,000,000.00 2,650,290.00 2,997,750.00 1.070 1413 1.085 20,240.83 -347,460.00 10/14/2026
<br /> 3130APU78 4600 FHLB 12/09/2021 530,000.00 471,048.10 526,947.20 1.300 1454 1.420 133.97 -55,899.10 11/24/2026
<br /> 3130APUR4 4601 FHLB 12/09/2021 1,840,000.00 1,635,336.80 1,829,401.60 1.300 1454 1.420 465.11 -194,064.80 11/24/2026
<br /> 3130APVC6 4602 FHLB 12/09/2021 3,000,000.00 2,672,820.00 2,988,000.00 1.375 1461 1.458 20,625.00 -315,180.00 12/01/2026
<br /> 3130AQEC3 4603 FHLB 12/30/2021 3,000,000.00 2,666,760.00 3,000,000.00 1.370 1490 1.370 17,239.17 -333,240.00 12/30/2026
<br /> 3130AQEF6 4604 FHLB 12/30/2021 3,000,000.00 2,667,300.00 2,998,500.00 1.375 1490 1.385 17,302.08 -331,200.00 12/30/2026
<br /> 313OAQG80 4605 FHLB 01/03/2022 3,000,000.00 2,672,190.00 2,999,250.00 1.420 1489 1.425 17,986.67 -327,060.00 12/29/2026
<br /> 313OAQG80 4606 FHLB 01/10/2022 3,000,000.00 2,672,190.00 2,982,750.00 1.420 1489 1.540 17,986.67 -310,560.00 12/29/2026
<br /> 3130AQLD3 4607 FHLB 02/08/2022 3,000,000.00 2,701,170.00 2,975,010.00 1.750 1519 1.926 17,937.50 -273,840.00 01/28/2027
<br /> 313OAQW66 4608 FHLB 03/08/2022 3,000,000.00 2,730,510.00 2,995,500.00 2.080 1547 2.111 16,640.00 -264,990.00 02/25/2027
<br /> 3134GVZ68 4535 FHLMC 06/23/2020 3,000,000.00 2,721,030.00 2,998,950.00 0.700 935 0.707 9,216.67 -277,920.00 06/23/2025
<br /> 3134GWA55 4545 FHLMC 09/09/2020 3,000,000.00 2,701,110.00 2,998,950.00 0.650 1013 0.657 4,441.67 -297,840.00 09/09/2025
<br /> 3134GWW93 4547 FHLMC 09/30/2020 3,000,000.00 2,697,540.00 3,000,000.00 0.550 1034 0.550 2,795.83 -302,460.00 09/30/2025
<br /> 3134GWWT9 4549 FHLMC 10/07/2020 3,000,000.00 2,697,860.83 2,997,920.83 0.550 1034 0.566 2,795.83 -300,060.00 09/30/2025
<br /> 3134GW3F1 4550 FHLMC 10/28/2020 3,000,000.00 2,695,260.00 3,000,000.00 0.600 1062 0.600 10,650.00 -304,740.00 10/28/2025
<br /> 3134GXDM3 4554 FHLMC 12/01/2020 3,000,000.00 2,682,120.00 3,000,000.00 0.620 1096 0.620 9,300.00 -317,880.00 12/01/2025
<br /> 3136G4YH0 4538 FNMA 07/14/2020 3,250,000.00 2,945,897.50 3,248,862.50 0.700 956 0.707 8,657.64 -302,965.00 07/14/2025
<br /> 3136G4A45 4541 FNMA 07/22/2020 3,000,000.00 2,718,180.00 3,000,000.00 0.710 964 0.710 7,632.50 -281,820.00 07/22/2025
<br /> 3135GA3W9 4552 FNMA 11/25/2020 3,000,000.00 2,681,880.00 3,000,000.00 0.600 1090 0.600 300.00 -318,120.00 11/25/2025
<br /> 3135G06R9 4556 FNMA 01/28/2021 3,000,000.00 2,662,080.00 3,000,000.00 0.550 1154 0.550 5,637.50 -337,920.00 01/28/2026
<br /> Subtotal and Average 158,421,056.66 158,630,000.00 141,612,600.66 158,421,056.66 0.898 1216 0.916 416,361.99 -16,808,456.00
<br /> Supranationals
<br /> 45950VPS9 7000 IFC 06/28/2021 1,000,000.00 885,170.00 980,200.00 0.500 1183 0.935 1,319.44 -95,030.00 02/26/2026
<br /> Subtotal and Average 980,200.00 1,000,000.00 885,170.00 980,200.00 0.500 1183 0.935 1,319.44 -95,030.00
<br /> Total and Average 212,338,987.16 209,799,164.66 190,375,090.09 210,038,987.16 1.199 1076 1.160 1,623,879.38 -19,663,897.07
<br /> Portfolio PLST
<br /> CC
<br /> Run Date:01/03/2023-09:58
<br /> PM(PRF-PMS)7.3.11
<br />
|