08 - Laserfiche WebLink

CITY OF PLEASANTON Portfolio Management Page Portfolio Details with Earnings - Investments January 31, 2023 Average Purchase Current Days To Accrued Unrealized Maturity CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rata Maturity YTM Interest Gain/Loss Date Subtotal and Average 4,982,797.09 5,000,000.00 4,716,170.00 4,982,797.09 1.649 878 1.735 18,666.66 -266,627.09 Federal Agency Issues-Callable 3133ELQ49 4537 FFCB 07/06/2020 3,000,000.00 2,755,860.00 2,997,750.00 0.700 880 0.715 1,808.33 -241,890.00 06/30/2025 3133EMBJ0 4548 FFCB 10/05/2020 3,340,000.00 3,033,755.40 3,336,660.00 0.530 971 0.550 5,999.01 -302,904.60 09/29/2025 3133EMUK6 4575 FFCB 03/25/2021 3,000,000.00 2,725,050.00 3,000,000.00 1.050 1148 1.050 11,025.00 -274,950.00 03/25/2026 3133FMH21 4595 FFCB 06/24/2021 3,000,000.00 2,699,670.00 2,997,000.00 0.900 1230 0.920 3,450.00 -297,330.00 06/15/2026 3130AJZ36 4544 FHLB 08/27/2020 3,000,000.00 2,737,500.00 2,997,000.00 0.600 938 0.620 7,700.00 -259,500.00 08/27/2025 3130AKGD2 4553 FHLB 11/25/2020 3,000,000.00 2,708,730.00 2,996,250.00 0.570 1028 0.595 3,135.00 -287,520.00 11/25/2025 3130AKQ74 4555 FHLB 01/22/2021 3,000,000.00 2,702,880.00 3,000,000.00 0.625 1086 0.625 468.75 -297,120.00 01/22/2026 3130AKRNB 4557 FHLB 01/28/2021 3,000,000.00 2,703,750.00 3,000,000.00 0.650 1092 0.650 162.50 -296,250.00 01/28/2026 3130AKXQ4 4558 FHLB 02/12/2021 3,000,000.00 2,690,250.00 3,000,000.00 0.600 1107 0.110 8,450.00 -309,750.00 02/12/2026 3130AKZ25 4559 FHLB 02/26/2021 3,000,000.00 2,691,360.00 3,000,000.00 0.650 1121 0.650 8,395.83 -308,640.00 02/26/2026 3130AL3S1 4560 FHLB 02/17/2021 3,000,000.00 2,691,210.00 3,000,000.00 0.625 1112 0.625 8,541.67 -308,790.00 02/17/2026 3130AL5X8 4561 FHLB 02/24/2021 3,000,000.00 2,691,840.00 3,000,000.00 0.650 1119 0.650 8,504.17 -308,160.00 02/24/2026 3130AKXJ0 4562 FHLB 02/24/2021 3,125,000.00 2,799,562.50 3,122,500.00 0.600 1119 0.616 8,177.08 -322,937.50 02/24/2026 3130ALCV4 4563 FHLB 02/24/2021 3,000,000.00 2,700,300.00 3,000,000.00 0.750 1119 0.750 9,812.50 -299,700.00 02/24/2026 3130ALDN1 4565 FHLB 03/16/2021 3,000,000.00 2,705,400.00 3,000,000.00 0.800 1139 0.800 9,000.00 -294,600.00 03/16/2026 3130ALGC2 4569 FHLB 03/23/2021 3,000,000.00 2,710,350.00 3,000,000.00 0.875 1146 0.875 9,333.33 -289,650.00 03/23/2026 3130ALMM3 4571 FHLB 03/30/2021 3,000,000.00 2,719,860.00 3,000,000.00 1.000 1153 1.000 10,083.33 -280,140.00 03/30/2026 3130ALGR9 4572 FHLB 03/15/2021 3,000,000.00 2,708,310.00 2,989,560.00 0.850 1121 0.922 10,979.17 -281,250.00 02/26/2026 3130ALGR9 4574 FHLB 03/18/2021 3,000,000.00 2,708,310.00 2,985,960.00 0.850 1121 0.947 10,979.17 -277,650.00 02/26/2026 3130ALGC2 4576 FHLB 03/23/2021 3,000,000.00 2,710,350.00 2,987,700.00 0.875 1146 0.959 9,333.33 -277,350.00 03/23/2026 3130ALGR9 4577 FHLB 03/22/2021 3,000,000.00 2,708,310.00 2,982,510.00 0.850 1121 0.971 10,979.17 -274,200.00 02/26/2026 3130ALNT7 4578 FHLB 03/30/2021 3,000,000.00 2,718,120.00 2,998,050.00 0.980 1153 0.993 9,881.67 -279,930.00 03/30/2026 3130ALGR9 4579 FHLB 03/31/2021 3,000,000.00 2,708,310.00 2,978,517.00 0.850 1121 1.000 10,979.17 -270,207.00 02/26/2026 3130ALUC6 4580 FHLB 04/15/2021 3,000,000.00 2,717,400.00 2,995,500.00 1.020 1169 1.050 9,010.00 -278,100.00 04/15/2026 3130ALMM3 4581 FHLB 04/05/2021 3,000,000.00 2,719,860.00 2,996,250.00 1.000 1153 1.025 10,083.33 -276,390.00 03/30/2026 3130AMCL4 4585 FHLB 05/20/2021 2,795,000.00 2,524,667.60 2,795,000.00 1.020 1203 1.019 5,701.80 -270,332.40 05/19/2026 3130AMH62 4587 FHLB 05/26/2021 3,000,000.00 2,706,780.00 2,998,500.00 1.000 1210 1.010 5,416.67 -291,720.00 05/26/2026 3130AMGW6 4588 FHLB 05/26/2021 3,000,000.00 2,704,980.00 2,998,950.00 0.980 1210 0.987 5,308.33 -293,970.00 05/26/2026 3130AMHB1 4590 FHLB 06/02/2021 2,750,000.00 2,470,820.00 2,746,562.50 0.875 1210 0.900 4,344.62 -275,742.50 05/26/2026 3130AMH62 4591 FHLB 06/02/2021 1,500,000.00 1,353,390.00 1,500,000.00 1.000 1210 0.999 2,708.33 -146,610.00 05/26/2026 3130AMSL7 4592 FHLB 06/30/2021 3,000,000.00 2,708,910.00 3,000,000.00 1.030 1245 1.030 2,660.83 -291,090.00 06/30/2026 3130AMYA4 4594 FHLB 06/30/2021 3,000,000.00 2,712,630.00 3,000,000.00 1.070 1245 1.070 2,764.17 -287,370.00 06/30/2026 3130AN2Q2 4596 FHLB 06/30/2021 1,500,000.00 1,353,075.00 1,500,000.00 1.000 1245 1.000 1,291.67 -146,925.00 06/30/2026 3130AMWK4 4597 FHLB 07/14/2021 3,000,000.00 2,699,760.00 2,999,250.00 1.020 1259 1.025 1,445.00 -299,490.00 07/14/2026 3130AP2P9 4598 FHLB 09/30/2021 3,000,000.00 2,677,140.00 2,983,500.00 0.920 1337 1.033 9,276.67 -306,360.00 09/30/2026 3130APC94 4599 FHLB 10/14/2021 3,000,000.00 2,690,010.00 2,997,750.00 1.070 1351 1.085 9,540.83 -307,740.00 10/14/2026 3130APU78 4600 FHLB 12/09/2021 530,000.00 479,347.90 526,947.20 1.300 1392 1.420 1,282.31 -47,599.30 11/24/2026 Portfolio PLST CC Wn Date:03/07/2023-14:27 PM(PRF PMS)7.3,11