10 - Laserfiche WebLink

CITY OF PLEASANTON Portfolio Management Page Portfolio Details with Earnings - Investments March 31, 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,765,640.00 2,997,750.00 0.700 821 0.715 5,308.33 -232,110.00 06/30/2025 3133EMBJO 4548 FFCB 10/05/2020 3,340,000.00 3,059,807.40 3,336,660.00 0.530 912 0.550 98.34 -276,852.60 09/29/2025 3133EMUK6 4575 FFCB 03/25/2021 3,000,000.00 2,713,440.00 3,000,000.00 1.050 1089 1.050 525.00 -286,560.00 03/25/2026 3133EMH21 4595 FFCB 06/24/2021 3,000,000.00 2,709,870.00 2,997,000.00 0.900 1171 0.920 7,950.00 -287,130.00 06/15/2026 3130AJZ36 4544 FHLB 08/27/2020 3,000,000.00 2,749,830.00 2,997,000.00 0.600 879 0.620 1,700.00 -247,170.00 08/27/2025 3130AKGD2 4553 FHLB 11/25/2020 3,000,000.00 2,723,610.00 2,996,250.00 0.570 969 0.595 5,985.00 -272,640.00 11/25/2025 313OAKQ74 4555 FHLB 01/22/2021 3,000,000.00 2,723,580.00 3,000,000.00 0.625 1027 0.625 3,593.75 -276,420.00 01/22/2026 3130AKRN8 4557 FHLB 01/28/2021 3,000,000.00 2,724,390.00 3,000,000.00 0.650 1033 0.650 3,412.50 -275,610.00 01/28/2026 3130AKXQ4 4558 FHLB 02/12/2021 3,000,000.00 2,715,120.00 3,000,000.00 0.600 1048 0.110 2,450.00 -284,880.00 02/12/2026 313OAKZ25 4559 FHLB 02/26/2021 3,000,000.00 2,716,320.00 3,000,000.00 0.650 1062 0.650 1,895.83 -283,680.00 02/26/2026 3130AL3S1 4560 FHLB 02/17/2021 3,000,000.00 2,717,190.00 3,000,000.00 0.625 1053 0.625 2,291.67 -282,810.00 02/17/2026 3130AL5X8 4561 FHLB 02/24/2021 3,000,000.00 2,697,000.00 3,000,000.00 0.650 1060 0.650 2,004.17 -303,000.00 02/24/2026 313OAKXJO 4562 FHLB 02/24/2021 3,125,000.00 2,825,750.00 3,122,500.00 0.600 1060 0.616 1,927.08 -296,750.00 02/24/2026 3130ALCV4 4563 FHLB 02/24/2021 3,000,000.00 2,704,980.00 3,000,000.00 0.750 1060 0.750 2,312.50 -295,020.00 02/24/2026 3130ALDN1 4565 FHLB 03/16/2021 3,000,000.00 2,724,000.00 3,000,000.00 0.800 1080 0.800 1,000.00 -276,000.00 03/16/2026 3130ALGC2 4569 FHLB 03/23/2021 3,000,000.00 2,718,450.00 3,000,000.00 0.875 1087 0.875 583.33 -281,550.00 03/23/2026 3130ALMM3 4571 FHLB 03/30/2021 3,000,000.00 2,727,450.00 3,000,000.00 1.000 1094 1.000 83.33 -272,550.00 03/30/2026 3130ALGR9 4572 FHLB 03/15/2021 3,000,000.00 2,712,600.00 2,989,560.00 0.850 1062 0.922 2,479.17 -276,960.00 02/26/2026 3130ALGR9 4574 FHLB 03/18/2021 3,000,000.00 2,712,600.00 2,985,960.00 0.850 1062 0.947 2,479.17 -273,360.00 02/26/2026 3130ALGC2 4576 FHLB 03/23/2021 3,000,000.00 2,718,450.00 2,987,700.00 0.875 1087 0.959 583.33 -269,250.00 03/23/2026 3130ALGR9 4577 FHLB 03/22/2021 3,000,000.00 2,712,600.00 2,982,510.00 0.850 1062 0.971 2,479.17 -269,910.00 02/26/2026 3130ALNT7 4578 FHLB 03/30/2021 3,000,000.00 2,736,000.00 2,998,050.00 0.980 1094 0.993 81.67 -262,050.00 03/30/2026 3130ALGR9 4579 FHLB 03/31/2021 3,000,000.00 2,712,600.00 2,978,517.00 0.850 1062 1.000 2,479.17 -265,917.00 02/26/2026 3130ALUC6 4580 FHLB 04/15/2021 3,000,000.00 2,730,360.00 2,995,500.00 1.020 1110 1.050 14,110.00 -265,140.00 04/15/2026 3130ALMM3 4581 FHLB 04/05/2021 3,000,000.00 2,727,450.00 2,996,250.00 1.000 1094 1.025 83.33 -268,800.00 03/30/2026 3130AMCL4 4585 FHLB 05/20/2021 2,795,000.00 2,544,735.70 2,795,000.00 1.020 1144 1.019 10,453.30 -250,264.30 05/19/2026 3130AMH62 4587 FHLB 05/26/2021 3,000,000.00 2,728,230.00 2,998,500.00 1.000 1151 1.010 10,416.67 -270,270.00 05/26/2026 3130AMGW6 4588 FHLB 05/26/2021 3,000,000.00 2,726,520.00 2,998,950.00 0.980 1151 0.987 10,208.33 -272,430.00 05/26/2026 3130AMHB1 4590 FHLB 06/02/2021 2,750,000.00 2,491,032.50 2,746,562.50 0.875 1151 0.900 8,355.03 -255,530.00 05/26/2026 3130AMH62 4591 FHLB 06/02/2021 1,500,000.00 1,364,115.00 1,500,000.00 1.000 1151 0.999 5,208.33 -135,885.00 05/26/2026 3130AMSL7 4592 FHLB 06/30/2021 3,000,000.00 2,718,510.00 3,000,000.00 1.030 1186 1.030 7,810.83 -281,490.00 06/30/2026 3130AMYA4 4594 FHLB 06/30/2021 3,000,000.00 2,722,020.00 3,000,000.00 1.070 1186 1.070 8,114.17 -277,980.00 06/30/2026 3130AN2Q2 4596 FHLB 06/30/2021 1,500,000.00 1,357,935.00 1,500,000.00 1.000 1186 1.000 3,791.67 -142,065.00 06/30/2026 3130AMWK4 4597 FHLB 07/14/2021 3,000,000.00 2,719,560.00 2,999,250.00 1.020 1200 1.025 6,545.00 -279,690.00 07/14/2026 3130AP2P9 4598 FHLB 09/30/2021 3,000,000.00 2,693,670.00 2,983,500.00 0.920 1278 1.033 76.67 -289,830.00 09/30/2026 3130APC94 4599 FHLB 10/14/2021 3,000,000.00 2,705,160.00 2,997,750.00 1.070 1292 1.085 14,890.83 -292,590.00 10/14/2026 3130APU78 4600 FHLB 12/09/2021 530,000.00 479,294.90 526,947.20 1.300 1333 1.420 2,430.64 -47,652.30 11/24/2026 3130APUR4 4601 FHLB 12/09/2021 1,840,000.00 1,663,967.20 1,829,401.60 1.300 1333 1.420 8,438.44 -165,434.40 11/24/2026 Portfolio PI-ST CC !un Date:05/08/2023-12:54 PM(PRF PM8)7.3.11