08 - Laserfiche WebLink

CITY OF PLEASANTON Portfolio Management Page Portfolio Details with Earnings - Investments April 30, 2023 Average Purchase Current Days To Accrued Unrealized Maturity CUSIP Investment# Issuer Balance Date_ Par Value Market Value Book Value Rate Maturity YTM Interest Gain/Loss Date Federal Agency Issues-Callable 3133ELQ49 4537 FFCB 07/06/2020 3,000,000.00 2,775,750.00 2,997,750.00 0.700 791 0.715 7,058.33 -222,000.00 06/30/2025 3133EMBJO 4548 FFCB 10/05/2020 3,340,000.00 3,057,135.40 3,336,660.00 0.530 882 0.550 1,573.51 -279,524.60 09/29/2025 3133EMUK6 4575 FFCB 03/25/2021 3,000,000.00 2,740,890.00 3,000,000.00 1.050 1059 1.050 3,150.00 -259,110.00 03/25/2026 3133EMH21 4595 FFCB 06/24/2021 3,000,000.00 2,708,610.00 2,997,000.00 0.900 1141 0.920 10,200.00 -288,390.00 06/15/2026 3130AJ736 4544 FHLB 08/27/2020 3,000,000.00 2,758,110.00 2,997,000.00 0.600 849 0.620 3,200.00 -238,890.00 08/27/2025 3130AKGD2 4553 FHLB 11/25/2020 3,000,000.00 2,738,220.00 2,996,250.00 0.570 939 0.595 7,410.00 -258,030.00 11/25/2025 313OAKQ74 4555 FHLB 01/22/2021 3,000,000.00 2,722,800.00 3,000,000.00 0.625 997 0.625 5,156.25 -277,200.00 01/22/2026 313OAKRNB 4557 FHLB 01/28/2021 3,000,000.00 2,723,610.00 3,000,000.00 0.650 1003 0.650 5,037.50 -276,390.00 01/28/2026 3130AKXQ4 4558 FHLB 02/12/2021 3,000,000.00 2,714,370.00 3,000,000.00 0.600 1018 0.110 3,950.00 -285,630.00 02/12/2026 313OAKZ25 4559 FHLB 02/26/2021 3,000,000.00 2,715,570.00 3,000,000.00 0.650 1032 0.650 3,520.83 -284,430.00 02/26/2026 3130AL3S1 4560 FHLB 02/17/2021 3,000,000.00 2,715,390.00 3,000,000.00 0.625 1023 0.625 3,854.17 -284,610.00 02/17/2026 3130AL5X8 4561 FHLB 02/24/2021 3,000,000.00 2,716,080.00 3,000,000.00 0.650 1030 0.650 3,629.17 -283,920.00 02/24/2026 313OAKXJO 4562 FHLB 02/24/2021 3,125,000.00 2,825,187.50 3,122,500.00 0.600 1030 0.616 3,489.58 -297,312.50 02/24/2026 3130ALCV4 4563 FHLB 02/24/2021 3,000,000.00 2,722,230.00 3,000,000.00 0.750 1030 0.750 4,187.50 -277,770.00 02/24/2026 3130ALDN1 4565 FHLB 03/16/2021 3,000,000.00 2,722,620.00 3,000,000.00 0.800 1050 0.800 3,000.00 -277,380.00 03/16/2026 3130ALGC2 4569 FHLB 03/23/2021 3,000,000.00 2,727,330.00 3,000,000.00 0.875 1057 0.875 2,770.83 -272,670.00 03/23/2026 3130ALMM3 4571 FHLB 03/30/2021 3,000,000.00 2,736,180.00 3,000,000.00 1.000 1064 1.000 2,563.33 -263.820.00 03/30/2026 3130ALGR9 4572 FHLB 03/15/2021 3,000,000.00 2,731,170.00 2,989,560.00 0.850 1032 0.922 4,604.17 -258,390.00 02/26/2026 3130ALGR9 4574 FHLB 03/18/2021 3,000,000.00 2,731,170.00 2,985,960.00 0.850 1032 0.947 4,604.17 -254,790.00 02/26/2026 3130ALGC2 4576 FHLB 03/23/2021 3,000,000.00 2,727,330.00 2,987,700.00 0.875 1057 0.959 2,770.83 -260,370.00 03/23/2026 3130ALGR9 4577 FHLB 03/22/2021 3,000,000.00 2,731,170.00 2,982,510.00 0.850 1032 0.971 4,604.17 -251,340.00 02/26/2026 3130ALNT7 4578 FHLB 03/30/2021 3,000,000.00 2,734,590.00 2,998,050.00 0.980 1064 0.993 2,531.67 -263,460.00 03/30/2026 3130ALGR9 4579 FHLB 03/31/2021 3,000,000.00 2,731,170.00 2,978,517.00 0.850 1032 1.000 4,604.17 -247,347.00 02/26/2026 3130ALUC6 4580 FHLB 04/15/2021 3,000,000.00 2,725,860.00 2,995,500.00 1.020 1080 1.050 1,360.00 -269,640.00 04/15/2026 3130ALMM3 4581 FHLB 04/05/2021 3,000,000.00 2,736,180.00 2,996,250.00 1.000 1064 1.025 2,583.33 -260,070.00 03/30/2026 3130AMCL4 4585 FHLB 05/20/2021 2,795,000.00 2,543,058.70 2,795,000.00 1.020 1114 1.019 12,829.05 -251,941.30 05/19/2026 3130AMH62 4587 FHLB 05/26/2021 3,000,000.00 2,726,490.00 2,998,500.00 1.000 1121 1.010 12,916.67 -272,010.00 05/26/2026 3130AMGW6 4588 FHLB 05/26/2021 3,000,000.00 2,724,810.00 2,998,950.00 0.980 1121 0.987 12,658.33 -274.140.00 05/26/2026 3130AMHB1 4590 FHLB 06/02/2021 2,750,000.00 2,489,657.50 2,746,562.50 0.875 1121 0.900 10,360.24 -256,905.00 05/26/2026 3130AMH62 4591 FHLB 06/02/2021 1,500,000.00 1,363,245.00 1,500,000.00 1.000 1121 0.999 6,458.33 -136,755.00 05/26/2026 3130AMSL7 4592 FHLB 06/30/2021 3,000,000.00 2,716,440.00 3,000,000.00 1.030 1156 1.030 10,385.83 -283,560.00 06/30/2026 3130AMYA4 4594 FHLB 06/30/2021 3,000,000.00 2,719,890.00 3,000,000.00 1.070 1156 1.070 10,789.17 -280,110.00 06/30/2026 3130AN2Q2 4596 FHLB 06/30/2021 1,500,000.00 1,356,930.00 1,500,000.00 1.000 1156 1.000 5,041.67 -143,070.00 06/30/2026 3130AMWK4 4597 FHLB 07/14/2021 3,000,000.00 2,717,610.00 2,999,250.00 1.020 1170 1.025 9,095.00 -281,640.00 07/14/2026 3130AP2P9 4598 FHLB 09/30/2021 3,000,000.00 2,690,670.00 2,983,500.00 0.920 1248 1.033 2,376.67 -292,830.00 09/30/2026 3130APC94 4599 FHLB 10/14/2021 3,000,000.00 2,702,130.00 2,997,750.00 1.070 1262 1.085 1,515.83 -295,620.00 10/14/2026 Portfolio PLST Run Date:06105/2023-16:16 C PM(PRF_PMB)7.3.11