09 - Laserfiche WebLink

CITY OF PLEASANTON Portfolio Management Page Portfolio Details with Earnings - Investments June 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 3133EMUK6 4575 FFCB 03/25/2021 3,000,000.00 2,715,450.00 3,000,000.00 1.050 998 1.050 8,400.00 •284,550.00 03125/2026 3133EMH21 4595 FFCB 06/24/2021 3,000,000.00 2,684,970.00 2,997,000.00 0.900 1080 0.920 1,200.00 -312,030.00 06/15/2026 3130AJZ36 4544 FHLB 08/27/2020 3,000,000.00 2,726,460.00 2,997,000.00 0.600 788 0.620 6,200.00 -270,540.00 08/27/2025 3130AKGD2 4553 FHLB 11/25/2020 3,000,000.00 2,716,800.00 2,996,250.00 0.570 878 0.595 1,710.00 -279,450.00 11/25/2025 3130AKQ74 4555 FHLB 01/22/2021 3,000,000.00 2,700,060.00 3,000,000.00 0.625 936 0.625 8,281.25 -299,940.00 01/22/2026 3130AKRNB 4557 FHLB 01/28/2021 3,000,000.00 2,700,300.00 3,000,000.00 0.650 942 0.650 8,287.50 -299,700.00 01/28/2026 3130AKXQ4 4558 FHLB 02/12/2021 3,000,000.00 2,691,450.00 3,000,000.00 0.600 957 0.110 6,950.00 -308,550.00 02/12/2026 313OAKZ25 4559 FHLB 02/26/2021 3,000,000.00 2,691,840.00 3,000,000.00 0.650 971 0.650 6,770.83 -308,160.00 02/26/2026 3130AL3S1 4560 FHLB 02/17/2021 3,000,000.00 2,672,550.00 3,000,000.00 0.625 962 0.625 6,979.17 -327,450.00 02/17/2026 3130AL5X8 4561 FHLB 02/24/2021 3,000,000.00 2,672,610.00 3,000,000.00 0.650 969 0.650 6,879.17 -327,390.00 02/2412026 3130AKXJ0 4562 FHLB 02/24/2021 3,125,000.00 2,800,656.25 3,122,500.00 0.600 969 0.616 6,614.58 -321,843.75 02/24/2026 3130ALCV4 4563 FHLB 02/24/2021 3,000,000.00 2,679,930.00 3,000,000.00 0.750 969 0.750 7,937.50 -320,070.00 02/24/2026 3130ALDN1 4565 FHLB 03/16/2021 3,000,000.00 2,698,560.00 3,000,000.00 0.800 989 0.800 7,000.00 -301,440.00 03/16/2026 3130ALGC2 4569 FHLB 03/23/2021 3,000,000.00 2,675,730.00 3,000,000.00 0.875 996 0.875 7,145.83 -324,270.00 03123/2026 3130ALMM3 4571 FHLB 03/3012021 3,000,000.00 2,683,620.00 3,000,000.00 1.000 1003 1.000 7,583.33 -316,380.00 03/30/2026 3130ALGR9 4572 FHLB 03/15/2021 3,000,000.00 2,686,740.00 2,989,560.00 0.850 971 0.922 8,854.17 -302,820.00 02/26/2026 3130ALGRQ 4574 FHLB 03/1812021 3,000,000.00 2,686,740.00 2,985,960.00 0.850 971 0.947 8,854.17 -299,220.00 02/26/2026 3130ALGC2 4576 FHLB 03/23/2021 3,000,000.00 2,675,730.00 2,987,700.00 0.875 996 0.959 7,145.83 -311,970.00 03/2312026 3130ALGR9 4577 FHLB 03/22/2021 3,000,000.00 2,686,740.00 2,982,510.00 0.850 971 0.971 8,854.17 -295,770.00 02/26/2026 3130ALNT7 4578 FHLB 03/30/2021 3,000,000.00 2,709,270.00 2,998,050.00 0.980 1003 0.993 7,431.67 -288,780.00 03/30/2026 3130ALGR9 4579 FHLB 03/31/2021 3,000,000.00 2,686,740.00 2,978,517.00 0.850 971 1.000 8,854.17 -291,777.00 02126/2026 3130ALUC6 4580 FHLB 04/15/2021 3,000,000.00 2,704,830.00 2,995,500.00 1.020 1019 1.050 6,460.00 -290,670.00 04/15/2026 3130ALMM3 4581 FHLB 04105/2021 3,000,000.00 2,683,620.00 2,996,250.00 1.000 1003 1.025 7,583.33 -312,630.00 03/30/2026 3130AMCL4 4585 FHLB 05/20/2021 2,795,000.00 2,518,686.30 2,795,000.00 1.020 1053 1.019 3,326.05 -276,313.70 05119/2026 3130AMH62 4587 FHLB 05/26/2021 3,000,000.00 2,700,480.00 2,998,500.00 1.000 1060 1.010 2,916.67 -298,020.00 05/2612026 3130AMGW6 4588 FHLB 05/26/2021 3,000,000.00 2,698,890.00 2,998,950.00 0.980 1060 0.987 2,858.33 -300,060.00 05/26/2026 3130AMHB1 4590 FHLB 06/02/2021 2,750,000.00 2,466,337.50 2,746,562.50 0.875 1060 0.900 2,339.41 -280,225.00 05/26/2026 3130AMH62 4591 FHLB 06/02/2021 1,500,000.00 1,350,240.00 1,500,000.00 1.000 1060 0.999 1,458.33 -149,760.00 05/26/2026 3130AMSL7 4592 FHLB 06/30/2021 3,000,000.00 2,692,500.00 3,000,000.00 1.030 1095 1.030 85.83 -307,500.00 06/30/2026 3130AMYA4 4594 FHLB 06/30/2021 3,000,000.00 2,695,800.00 3,000,000.00 1.070 1095 1.070 89.17 -304,200.00 06/30/2026 3130AN2Q2 4596 FHLB 06/30/2021 1,500,000.00 1,345,020.00 1,500,000.00 1.000 1095 1.000 41.67 -154,980.00 06/30/2026 3130AMWK4 4597 FHLB 07/14/2021 3,000,000.00 2,690,910.00 2,999,250.00 1.020 1109 1.025 14,195.00 -308,340.00 07/1412026 3130AP2P9 4598 FHLB 09/30/2021 3,000,000.00 2,668,740.00 2,983,500.00 0.920 1187 1.033 6,976.67 -314,760.00 09/30/2026 3130APC94 4599 FHLB 10/14/2021 3,000,000.00 2,684,340.00 2,997,750.00 1.070 1201 1.085 6,865.83 -313,410.00 10/14/2026 3130APU78 4600 FHLB 12/09/2021 530,000.00 476,666.10 526,947.20 1.300 1242 1.420 708.14 -50,281.10 11/24/2026 3130APUR4 4601 FHLB 12/09/2021 1,840,000.00 1,654,840.80 1,829,401.60 1.300 1242 1.420 2,458.44 -174,560.80 11/2412026 3130APVC6 4602 FHLB 12/09/2021 3,000,000.00 2,703,810.00 2,988,000.00 1.375 1249 1.458 3,437.50 -284,190.00 12/01/2026 3130AQEC3 4603 FHLB 12/30/2021 3,000,000.00 2,698,830.00 3,000,000.00 1.370 1278 1.370 114.17 -301,170.00 12/3012026 Portfolio PLST Run Dare:08/01/2023-13:08 CC PM(PRF_PM8)7.3.11