|
CITY OF PLEASANTON
<br /> Portfolio Management Page
<br /> Portfolio Details with Earnings - Investments
<br /> July 31, 2023
<br /> Average Purchase Current Days To Accrued Unrealized Maturity
<br /> CUSIP Investment X Issuer Balance Date Par Value Market Value Book Value Rate Maturity YTM Interest Gain/Loss Date
<br /> Federal Agency Issues-Callable
<br /> 313OAQGBO 4605 FHLB 01/03/2022 3,000,000.00 2,701,140.00 2,999,250.00 1.420 1246 1.425 3,786.67 -298,110.00 12/29/2026
<br /> 313OAQGBO 4606 FHLB 01/10/2022 3,000,000.00 2,701,140.00 2,982,750.00 1.420 1246 1.540 3,786.67 -281,610.00 12/29/2026
<br /> 313OAQLD3 4607 FHLB 02/08/2022 3,000,000.00 2,721,930.00 2,975,010.00 1.750 1276 1.926 437.50 -253,080.00 01/28/2027
<br /> 313OAQW66 4608 FHLB 03/08/2022 3,000,000.00 2,727,450.00 2,995,500.00 2.080 1304 2.111 27,040.00 -268,050.00 02/25/2027
<br /> 3134GVZ68 4535 FHLMC 06/23/2020 3,000,000.00 2,755,290.00 2,998,950.00 0.700 692 0.707 2,216.67 -243,660.00 06/23/2025
<br /> 3134GWA55 4545 FHLMC 09/09/2020 3,000,000.00 2,739,750.00 2,998,950.00 0.650 770 0.657 7,691.67 -259,200.00 09/09/2025
<br /> 3134GWW93 4547 FHLMC 09/30/2020 3,000,000.00 2,732,040.00 3,000,000.00 0.550 791 0.550 5,545.83 -267,960.00 09/30/2025
<br /> 3134GWWT9 4549 FHLMC 10/07/2020 3,000,000.00 2,724,000.00 2,997,600.00 0.550 791 0.566 5,545.83 -273,600.00 09/30/2025
<br /> 3134GW3F1 4550 FHLMC 10/28/2020 3,000,000.00 2,723,880.00 3,000,000.00 0.600 819 0.600 4,650.00 -276,120.00 10/28/2025
<br /> 3134GXDM3 4554 FHLMC 12/01/2020 3,000,000.00 2,720,370.00 3,000,000.00 0.620 853 0.620 3,100.00 -279,630.00 12/01/2025
<br /> 3136G4YHO 4538 FNMA 07/14/2020 3,250,000.00 2,991,267.50 3,248,862.50 0.700 713 0.707 1,074.31 -257,595.00 07/14/2025
<br /> 3136G4A45 4541 FNMA 07/22/2020 3,000,000.00 2,759,910.00 3,000,000.00 0.710 721 0.710 532.50 -240,090.00 07/22/2025
<br /> 3135GA3W9 4552 FNMA 11/25/2020 3,000,000.00 2,725,710.00 3,000,000.00 0.600 847 0.600 3,300.00 -274,290.00 11/25/2025
<br /> 3135GO6R9 4556 FNMA 01/28/2021 3,000,000.00 2,699,190.00 3,000,000.00 0.550 911 0.550 137.50 -300,810.00 01/28/2026
<br /> Subtotal and Average 158,420,440.80 158,630,000.00 143,378,587.95 158,420,440.80 0.898 973 0.916 335,275.92 -15,041,852.85
<br /> Supranationals
<br /> 45950VPS9 7000 IFC 06/28/2021 1,000,000.00 894,820.00 980,200.00 0.500 940 0.935 2,152.78 -85,380.00 02/26/2026
<br /> Subtotal and Average 980,200.00 1,000,000.00 894,820.00 980,200.00 0.500 940 0.935 2,152.78 -85,380.00
<br /> Total and Average 241,332,522.47 230,091,206.57 212,239,133.88 230,363,193.93 1.448 773 1.411 1,556,826.79 -18,124,060.05
<br /> Portfolio PLST
<br /> CC
<br /> Run Date:09/06/2023-13:35 PM(PRF_PM8)7.3.11
<br />
|