|
CITY OF PLEASANTON
<br /> Portfolio Management Page 3
<br /> Portfolio Details with Earnings - Investments
<br /> March 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 /> 3130APVC6 4602 FHLB 12/09/2021 3,000,000.00 2,722,800.00 2,988,000.00 1.375 1340 1.458 13,750.00 -265,200.00 12/01/2026
<br /> 3130AQEC3 4603 FHLB 12/30/2021 3,000,000.00 2,706,720.00 3,000,000.00 1.370 1369 1.370 10,389.17 -293,280.00 12/30/2026
<br /> 3130AQEF6 4604 FHLB 12/30/2021 3,000,000.00 2,707,200.00 2,998,500.00 1.375 1369 1.385 10,427.08 -291,300.00 12/30/2026
<br /> 313OAQG60 4605 FHLB 01/03/2022 3,000,000.00 2,670,480.00 2,999,250.00 1.420 1368 1.425 10,886.67 -328,770.00 12/29/2026
<br /> 313OAQG80 4606 FHLB 0111012022 3,000,000.00 2,670,480.00 2,982,750.00 1.420 1368 1.540 10,886.67 -312,270.00 12/29/2026
<br /> 3130AQLD3 4607 FHLB 02/08/2022 3,000,000.00 2,739,660.00 2,975,010.00 1.750 1398 1.926 9,187.50 -235,350.00 01/28/2027
<br /> 313OAQW66 4608 FHLB 03/08/2022 3,000,000.00 2,784,510.00 2,995,500.00 2.080 1426 2.111 6,240.00 -210,990.00 02/25/2027
<br /> 3134GVZ68 4535 FHLMC 06/23/2020 3,000,000.00 2,780,880.00 2,998,950.00 0.700 814 0.707 5,716.67 -218,070.00 06/23/2025
<br /> 3134GWA55 4545 FHLMC 09/09/2020 3,000,000.00 2,750,280.00 2,998,950.00 0.650 892 0.657 1,191.67 -248,670.00 09/09/2025
<br /> 3134GWW93 4547 FHLMC 09/30/2020 3,000,000.00 2,739,510.00 3,000,000.00 0.550 913 0.550 45.83 -260,490.00 09/30/2025
<br /> 3134GWWT9 4549 FHLMC 10/07/2020 3,000,000.00 2,749,560.00 2,997,600.00 0.550 913 0.566 45.83 -248,040.00 09/30/2025
<br /> 3134GW3F1 4550 FHLMC 10/28/2020 3,000,000.00 2,747,010.00 3,000,000.00 0.600 941 0.600 7,650.00 -252,990.00 10/28/2025
<br /> 3134GXDM3 4554 FHLMC 12/01/2020 3,000,000.00 2,735,850.00 3,000,000.00 0.620 975 0.620 6,200.00 -264,150.00 12/01/2025
<br /> 3136G4YH0 4538 FNMA 07/14/2020 3,250,000.00 3,008,135.00 3,248,862.50 0.700 835 0.707 4,865.97 -240,727.50 07/14/2025
<br /> 3136G4A45 4541 FNMA 07/22/2020 3,000,000.00 2,775,660.00 3,000,000.00 0.710 843 0.710 4,082.50 -224,340.00 07/22/2025
<br /> 3135GA3W9 4552 FNMA 11/25/2020 3,000,000.00 2,743,380.00 3,000,000.00 0.600 969 0.600 6,300.00 -256,620.00 11/25/2025
<br /> 3135G06R9 4556 FNMA 01/28/2021 3,000,000.00 2,716,560.00 3,000,000.00 0.550 1033 0.550 2,887.50 -283,440.00 01/28/2026
<br /> Subtotal and Average 158,420,440.80 158,630,000.00 144,142,512.70 158,420,440.80 0.898 1095 0.916 275,388.81 -14,277,928.10
<br /> Supranationals
<br /> 45950VPS9 7000 IFC 06/28/2021 1,000,000.00 902,370.00 980,200.00 0.500 1062 0.935 486.11 -77,830.00 02/26/2026
<br /> Subtotal and Average 980,200.00 1,000,000.00 902,370.00 980,200.00 0.500 1062 0.935 486.11 -77,830.00
<br /> Total and Average 231,116,718.72 237,619,164.66 220,669,939.62 237,890,912.27 1.409 848 1.371 1,523,441.29 -17,220,972.65
<br /> Portfolio PLST
<br /> CC
<br /> Wn Date.05/08/2023-12:54
<br /> PM(PRF PM8)7.3.11
<br />
|