07 - Laserfiche WebLink

CITY OF PLEASANTON Portfolio Management Page Portfolio Details with Earnings - Investments December 31, 2022 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-Coupon 3133EKGC4 3574 FFCB 04/17/2019 2,000,000.00 1,989,440.00 1,987,140.00 2.250 94 2.420 33,250.00 2,300.00 04/05/2023 3130AQF65 3576 FHLB 12/22/2021 3,000,000.00 2,689,380.00 2,995,657.09 1.250 1450 1.280 1,041.66 -306,277.09 12/21/2026 Subtotal and Average 4,982,797.09 5,000,000.00 4,678,820.00 4,982,797.09 1.649 909 1.735 34,291.66 -303,977.09 Federal Agency Issues-Callable 3133ELQ49 4537 FFCB 07/06/2020 3,000,000.00 2,711,730.00 2,997,750.00 0.700 911 0.715 58.33 -286,020.00 06/30/2025 3133EMBJ0 4548 FFCB 10/05/2020 3,340,000.00 2,982,686.80 3,336,660.00 0.530 1002 0.550 4,523.84 -353,973.20 09/29/2025 3133EMUK6 4575 FFCB 03/25/2021 3,000,000.00 2,698,350.00 3,000,000.00 1.050 1179 1.050 8,400.00 -301,650.00 03/25/2026 3133EMH21 4595 FFCB 06/24/2021 3,000,000.00 2,666,730.00 2,997,000.00 0.900 1261 0.920 1,200.00 -330,270.00 06/15/2026 3130AJZ36 4544 FHLB 08/27/2020 3,000,000.00 2,706,780.00 2,997,000.00 0.600 969 0.620 6,200.00 -290,220.00 08/27/2025 3130AKGD2 4553 FHLB 11/25/2020 3,000,000.00 2,660,940.00 2,996,250.00 0.570 1059 0.595 1,710.00 -335,310.00 11/25/2025 3130AKQ74 4555 FHLB 01/22/2021 3,000,000.00 2,672,010.00 3,000,000.00 0.625 1117 0.625 8,281.25 -327,990.00 01/22/2026 3130AKRNB 4557 FHLB 01/28/2021 3,000,000.00 2,676,540.00 3,000,000.00 0.650 1123 0.650 8,287.50 -323,460.00 01/28/2026 3130AKXQ4 4558 FHLB 02/12/2021 3,000,000.00 2,664,690.00 3,000,000.00 0.600 1138 0.110 6,950.00 -335,310.00 02/12/2026 3130AKZ25 4559 FHLB 02/26/2021 3,000,000.00 2,665,320.00 3,000,000.00 0.650 1152 0.650 6,770.83 -334,680.00 02/26/2026 3130AL3S1 4560 FHLB 02/17/2021 3,000,000.00 2,665,470.00 3,000,000.00 0.625 1143 0.625 6,979.17 -334,530.00 02/17/2026 3130ALSXB 4561 FHLB 02/24/2021 3,000,000.00 2,665,830.00 3,000,000.00 0.650 1150 0.650 6,879.17 -334,170.00 02/24/2026 313OAKXJ0 4562 FHLB 02/24/2021 3,125,000.00 2,772,406.25 3,122,500.00 0.600 1150 0.616 6,614.58 -350,093.75 02/24/2026 3130ALCV4 4563 FHLB 02/24/2021 3,000,000.00 2,674,260.00 3,000,000.00 0.750 1150 0.750 7,937.50 -325,740.00 02/24/2026 3130ALDN1 4565 FHLB 03/16/2021 3,000,000.00 2,674,170.00 3,000,000.00 0.800 1170 0.800 7,000.00 -325,830.00 03/16/2026 3130ALGC2 4569 FHLB 03/23/2021 3,000,000.00 2,679,210.00 3,000,000.00 0.875 1177 0.875 7,145.83 -320,790.00 03/23/2026 3130ALMM3 4571 FHLB 03/30/2021 3,000,000.00 2,688,720.00 3,000,000.00 1.000 1184 1.000 7,583.33 -311,280.00 03/30/2026 3130ALGR9 4572 FHLB 03/15/2021 3,000,000.00 2,681,070.00 2,989,560.00 0.850 1152 0.922 8,854.17 -308,490.00 02/26/2026 3130ALGR9 4574 FHLB 03/18/2021 3,000,000.00 2,681,070.00 2,985,960.00 0.850 1152 0.947 8,854.17 -304,890.00 02/26/2026 3130ALGC2 4576 FHLB 03/23/2021 3,000,000.00 2,679,210.00 2,987,700.00 0.875 1177 0.959 7,145.83 -308,490.00 03/23/2026 3130ALGR9 4577 FHLB 03/22/2021 3,000,000.00 2,681,070.00 2,982,510.00 0.850 1152 0.971 8,854,17 -301,440.00 02/26/2026 3130ALNT7 4578 FHLB 03/30/2021 3,000,000.00 2,686,950.00 2,998,050.00 0.980 1184 0.993 7,431.67 -311,100.00 03/30/2026 3130ALGR9 4579 FHLB 03/31/2021 3,000,000.00 2,681,070.00 2,978,517.00 0.850 1152 1.000 8,854.17 -297,447.00 02/26/2026 3130ALUC6 4580 FHLB 04/15/2021 3,000,000.00 2,686,710.00 2,995,500.00 1.020 1200 1.050 21,760.00 -308,790.00 04/15/2026 3130ALMM3 4581 FHLB 04/05/2021 3,000,000.00 2,688,720.00 2,996,250.00 1.000 1184 1.025 7,583.33 -307,530.00 03/30/2026 3130AMCL4 4585 FHLB 05/20/2021 2,795,000.00 2,489,841.90 2,795,000.00 1.020 1234 1.019 3,326.05 -305,158.10 05/19/2026 3130AMH62 4587 FHLB 05/26/2021 3,000,000.00 2,674,980.00 2,998,500.00 1.000 1241 1.010 2,916.67 -323,520.00 05/26/2026 3130AMGW6 4588 FHLB 05/26/2021 3,000,000.00 2,674,170.00 2,998,950.00 0.980 1241 0.987 2,858.33 -324,780.00 05/26/2026 3130AMHB1 4590 FHLB 06/02/2021 2,750,000.00 2,442,440.00 2,746,562.50 0.875 1241 0.900 2,339.41 -304,122.50 05/26/2026 3130AMH62 4591 FHLB 06/02/2021 1,500,000.00 1,337,490.00 1,500,000.00 1.000 1241 0.999 1,458.33 -162,510.00 05/26/2026 3130AMSL7 4592 FHLB 06/30/2021 3,000,000.00 2,671,350.00 3,000,000.00 1.030 1276 1.030 85.83 -328,650.00 06/30/2026 3130AMYA4 4594 FHLB 06/30/2021 3,000,000.00 2,675,130.00 3,000,000.00 1.070 1276 1.070 89.17 -324,870.00 06/30/2026 3130AN2Q2 4596 FHLB 06/30/2021 1,500,000.00 1,334,265.00 1,500,000.00 1.000 1276 1.000 41.67 -165,735.00 06/30/2026 Portfolio PLST CC Run Date:02/06/2023-16:25 PM(PRF_PM8)7.3.11