08 - Laserfiche WebLink

CITY OF PLEASANTON Portfolio Management Page Portfolio Details with Earnings - Investments February 28, 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,725,050.00 2,997,750.00 0.700 852 0.715 3,558.33 -272,700.00 06/30/2025 3133EMBJ0 4548 FFCB 10/05/2020 3,340,000.00 2,988,164.40 3,336,660.00 0.530 943 0.550 7,474.18 -348,495.60 09/29/2025 3133EMUK6 4575 FFCB 03/25/2021 3,000,000.00 2,680,470.00 3,000,000.00 1.050 1120 1.050 13,650.00 -319,530.00 03/25/2026 3133EMH21 4595 FFCB 06/24/2021 3,000,000.00 2,648,220.00 2,997,000.00 0.900 1202 0.920 5,700.00 -348,780.00 06/15/2026 3130AJZ36 4544 FHLB 08/27/2020 3,000,000.00 2,708,850.00 2,997,000.00 0.600 910 0.620 200.00 -288,150.00 08/27/2025 3130AKGD2 4553 FHLB 11/25/2020 3,000,000.00 2,673,390.00 2,996,250.00 0.570 1000 0.595 4,560.00 -322,860.00 11/25/2025 3130AKQ74 4555 FHLB 01/22/2021 3,000,000.00 2,665,710.00 3,000,000.00 0.625 1058 0.625 2,031.25 -334,290.00 01/22/2026 3130AKRN8 4557 FHLB 01/28/2021 3,000,000.00 2,666,340.00 3,000,000.00 0.650 1064 0.650 1,787.50 -333,660.00 01/28/2026 3130AKXQ4 4558 FHLB 02/12/2021 3,000,000.00 2,653,260.00 3,000,000.00 0.600 1079 0.110 950.00 -346,740.00 02/12/2026 313OAKZ25 4559 FHLB 02/26/2021 3,000,000.00 2,644,920.00 3,000,000.00 0.650 1093 0.650 270.83 -355,080.00 02/26/2026 3130AL3S1 4560 FHLB 02/17/2021 3,000,000.00 2,661,510.00 3,000,000.00 0.625 1084 0.625 729.17 -338,490.00 02/17/2026 3130AL5X8 4561 FHLB 02/24/2021 3,000,000.00 2,654,400.00 3,000,000.00 0.650 1091 0.650 379.17 -345,600.00 02/24/2026 3130AKXJO 4562 FHLB 02/24/2021 3,125,000.00 2,751,343.75 3,122,500.00 0.600 1091 0.616 364.58 -371,156.25 02/24/2026 3130ALCV4 4563 FHLB 02/24/2021 3,000,000.00 2,662,590.00 3,000,000.00 0.750 1091 0.750 437.50 -337,410.00 02/24/2026 3130ALDN1 4565 FHLB 03/16/2021 3,000,000.00 2,661,630.00 3,000,000.00 0.800 1111 0.800 11,000.00 -338,370.00 03/16/2026 3130ALGC2 4569 FHLB 03/23/2021 3,000,000.00 2,666,250.00 3,000,000.00 0.875 1118 0.875 11,520.83 -333,750.00 03/23/2026 3130ALMM3 4571 FHLB 03/30/2021 3,000,000.00 2,680,200.00 3,000,000.00 1.000 1125 1.000 12,583.33 -319,800.00 03/30/2026 3130ALGR9 4572 FHLB 03/15/2021 3,000,000.00 2,661,330.00 2,989,560.00 0.850 1093 0.922 354.17 -328,230.00 02/26/2026 3130ALGR9 4574 FHLB 03/18/2021 3,000,000.00 2,661,330.00 2,985,960.00 0.850 1093 0.947 354.17 -324,630.00 02/26/2026 3130ALGC2 4576 FHLB 03/23/2021 3,000,000.00 2,666,250.00 2,987,700.00 0.875 1118 0.959 11,520.83 -321,450.00 03/23/2026 3130ALGR9 4577 FHLB 03/22/2021 3,000,000.00 2,661,330.00 2,982,510.00 0.850 1093 0.971 354.17 -321,180.00 02/26/2026 3130ALNT7 4578 FHLB 03/30/2021 3,000,000.00 2,673,390.00 2,998,050.00 0.980 1125 0.993 12,331.67 -324,660.00 03/30/2026 3130ALGR9 4579 FHLB 03/31/2021 3,000,000.00 2,661,330.00 2,978,517.00 0.850 1093 1.000 354.17 -317,187.00 02/26/2026 3130ALUC6 4580 FHLB 04/15/2021 3,000,000.00 2,668,650.00 2,995,500.00 1.020 1141 1.050 11,560.00 -326,850.00 04/15/2026 3130ALMM3 4581 FHLB 04/05/2021 3,000,000.00 2,680,200.00 2,996,250.00 1.000 1125 1.025 12,583.33 -316,050.00 03/30/2026 3130AMCL4 4585 FHLB 05/20/2021 2,795,000.00 2,477,320.30 2,795,000.00 1.020 1175 1.019 8,077.55 -317,679.70 05/19/2026 3130AMH62 4587 FHLB 05/26/2021 3,000,000.00 2,655,810.00 2,998,500.00 1.000 1182 1.010 7,916.67 -342,690.00 05/26/2026 3130AMGW6 4588 FHLB 05/26/2021 3,000,000.00 2,654,040.00 2,998,950.00 0.980 1182 0.987 7,758.33 -344,910.00 05/26/2026 3130AMHB1 4590 FHLB 06/02/2021 2,750,000.00 2,424,372.50 2,746,562.50 0.875 1182 0.900 6,349.83 -322,190.00 05/26/2026 3130AMH62 4591 FHLB 06/02/2021 1,500,000.00 1,327,905.00 1,500,000.00 1.000 1182 0.999 3,958.33 -172,095.00 05/26/2026 3130AMSL7 4592 FHLB 06/30/2021 3,000,000.00 2,656,560.00 3,000,000.00 1.030 1217 1.030 5,235.83 -343,440.00 06/30/2026 3130AMYA4 4594 FHLB 06/30/2021 3,000,000.00 2,660,190.00 3,000,000.00 1.070 1217 1.070 5,439.17 -339,810.00 06/30/2026 3130AN2Q2 4596 FHLB 06/30/2021 1,500,000.00 1,326,915.00 1,500,000.00 1.000 1217 1.000 2,541.67 -173,085.00 06/30/2026 3130AMWK4 4597 FHLB 07/14/2021 3,000,000.00 2,646,930.00 2,999,250.00 1.020 1231 1.025 3,995.00 -352,320.00 07/14/2026 3130AP2139 4598 FHLB 09/30/2021 3,000,000.00 2,621,280.00 2,983,500.00 0.920 1309 1.033 11,576.67 -362,220.00 09/30/2026 3130APC94 4599 FHLB 10/14/2021 3,000,000.00 2,636,220.00 2,997,750.00 1.070 1323 1.085 12,215.83 -361,530.00 10/14/2026 3130APU78 4600 FHLB 12/09/2021 530,000.00 469,103.00 526,947.20 1.300 1364 1.420 1,856.47 -57,844.20 11/24/2026 3130APUR4 4601 FHLB 12/09/2021 1,840,000.00 1,628,584.00 1,829,401.60 1.300 1364 1.420 6,445.11 -200,817.60 11/24/2026 Portfolio PLST CC ;un Date:04/05/2023-07:35 PM(PRF PM8)7.3.11