07 - Laserfiche WebLink

CITY OF PLEASANTON Portfolio Management Paget Portfolio Details with Earnings - Investments July 31, 2023 Average Purchase Current Days To Accrued Unrealized Maturity CUSIP Investment# Issuer Balance Date Per Value Market Value Book Value Rate Maturitv YTM Interest Gain/Loss Date Federal Agency Issues-Callable 3133EMH21 4595 FFCB 06/24/2021 3,000,000.00 2,687,160.00 2,997,000.00 0.900 1049 0.920 3,450.00 -309,840.00 06/15/2026 3130AJZ36 4544 FHLB 08/27/2020 3,000,000.00 2,740,230.00 2,997,000.00 0.600 757 0.620 7,700.00 -256,770.00 08/27/2025 3130AKGD2 4553 FHLB 11/25/2020 3,000,000.00 2,723,760.00 2,996,250.00 0.570 847 0.595 3,135.00 -272,490.00 11/25/2025 3130AKQ74 4555 FHLB 01/22/2021 3,000,000.00 2,705,820.00 3,000,000.00 0.625 905 0.625 468.75 -294,180.00 01/22/2026 3130AKRN8 4557 FHLB 01/28/2021 3,000,000.00 2,709,270.00 3,000,000.00 0.650 911 0.650 162.50 -290,730.00 01/28/2026 3130AKXQ4 4558 FHLB 02/12/2021 3,000,000.00 2,697,150.00 3,000,000.00 0.600 926 0.110 8,450.00 -302,850.00 02/12/2026 3130AKZ25 4559 FHLB 02/26/2021 3,000,000.00 2,697,180.00 3,000,000.00 0.650 940 0.650 8,395.83 -302,820.00 02/26/2026 3130AL3S1 4560 FHLB 02/17/2021 3,000,000.00 2,697,720.00 3,000,000.00 0.625 931 0.625 8,541.67 -302,280.00 02/17/2026 3130AL5X8 4561 FHLB 02/24/2021 3,000,000.00 2,697,840.00 3,000,000.00 0.650 938 0.650 8,504.17 -302,160.00 02/24/2026 3130AKXJ0 4562 FHLB 02/24/2021 3,125,000.00 2,807,031.25 3,122,500.00 0.600 938 0.616 8,177.08 -315,468.75 02/24/2026 3130ALCV4 4563 FHLB 02/24/2021 3,000,000.00 2,699,820.00 3,000,000.00 0.750 938 0.750 9,812.50 -300,180.00 02/24/2026 3130ALDN1 4565 FHLB 03/16/2021 3,000,000.00 2,703,150.00 3,000,000.00 0.800 958 0.800 9,000.00 -296,850.00 03/16/2026 3130ALGC2 4569 FHLB 03/23/2021 3,000,000.00 2,706,990.00 3,000,000.00 0.875 965 0.875 9,333.33 -293,010.00 03/23/2026 3130ALMM3 4571 FHLB 03/30/2021 3,000,000.00 2,714,730.00 3,000,000.00 1.000 972 1.000 10,083.33 -285,270.00 03/30/2026 3130ALGR9 4572 FHLB 03/15/2021 3,000,000.00 2,711,430.00 2,989,560.00 0.850 940 0.922 10,979.17 -278,130.00 02/26/2026 3130ALGR9 4574 FHLB 03/18/2021 3,000,000.00 2,711,430.00 2,985,960.00 0.850 940 0.947 10,979.17 -274,530.00 02/26/2026 3130ALGC2 4576 FHLB 03/23/2021 3,000,000.00 2,706,990.00 2,987,700.00 0.875 965 0.959 9,333.33 -280,710.00 03/23/2026 3130ALGR9 4577 FHLB 03/22/2021 3,000,000.00 2,711,430.00 2,982,510.00 0.850 940 0.971 10,979.17 -271,080.00 02/26/2026 3130ALNT7 4578 FHLB 03/30/2021 3,000,000.00 2,710,590.00 2,998,050.00 0.980 972 0.993 9,881.67 -287,460.00 03/30/2026 3130ALGR9 4579 FHLB 03/31/2021 3,000,000.00 2,711,430.00 2,978,517.00 0.850 940 1.000 10,979.17 -267,087.00 02/26/2026 3130ALUC6 4580 FHLB 04/15/2021 3,000,000.00 2,708,400.00 2,995,500.00 1.020 988 1.050 9,010.00 -287,100.00 04/15/2026 3130ALMM3 4581 FHLB 04/05/2021 3,000,000.00 2,714,730.00 2,996,250.00 1.000 972 1.025 10,083.33 -281,520.00 03/30/2026 3130AMCL4 4585 FHLB 05/20/2021 2,795,000.00 2,521,257.70 2,795,000.00 1.020 1022 1.019 5,701.80 -273,742.30 05/19/2026 3130AMH62 4587 FHLB 05/26/2021 3,000,000.00 2,703,270.00 2,998,500.00 1.000 1029 1.010 5,416.67 -295,230.00 05/26/2026 3130AMGW6 4588 FHLB 05/26/2021 3,000,000.00 2,701,710.00 2,998,950.00 0.980 1029 0.987 5,308.33 -297,240.00 05/26/2026 3130AMHB1 4590 FHLB 06/02/2021 2,750,000.00 2,469,115.00 2,746,562.50 0.875 1029 0.900 4,344.62 -277,447.50 05/26/2026 3130AMH62 4591 FHLB 06/02/2021 1,500,000.00 1,351,635.00 1,500,000.00 1.000 1029 0.999 2,708.33 -148,365.00 05/26/2026 3130AMSL7 4592 FHLB 06/30/2021 3,000,000.00 2,694,480.00 3,000,000.00 1.030 1064 1.030 2,660.83 -305,520.00 06/30/2026 3130AMYA4 4594 FHLB 06/30/2021 3,000,000.00 2,697,660.00 3,000,000.00 1.070 1064 1.070 2,764.17 -302,340.00 06/30/2026 3130AN2Q2 4596 FHLB 06/30/2021 1,500,000.00 1,346,025.00 11500,000.00 1.000 1064 1.000 1,291.67 -153,975.00 06/30/2026 3130AMWK4 4597 FHLB 07/14/2021 3,000,000.00 2,693,010.00 2,999,250.00 1,020 1078 1.025 1,445.00 -306,240.00 07/14/2026 3130AP2P9 4598 FHLB 09/30/2021 3,000,000.00 2,669,430.00 2,983,500.00 0.920 1156 1.033 9,276.67 -314,070.00 09/30/2026 3130APC94 4599 FHLB 10/14/2021 3,000,000.00 2,684,430.00 2,997,750.00 1.070 1170 1.085 9,540.83 -313,320.00 10/14/2026 3130APU78 4600 FHLB 12/09/2021 530,000.00 476,432.90 526,947.20 1.300 1211 1.420 1,282.31 -50,514.30 11/24/2026 3130APUR4 4601 FHLB 12/09/2021 1,840,000.00 1,654,031.20 1,829,401.60 1.300 1211 1.420 4,451.78 -175,370.40 11/24/2026 3130APVC6 4602 FHLB 12/09/2021 3,000,000.00 2,702,220.00 2,988,000.00 1.375 1218 1.458 6,875.00 -285,780.00 12/01/2026 3130AQEC3 4603 FHLB 12/30/2021 3,000,000.00 2,696,520.00 3,000,000.00 1.370 1247 1.370 3,539.17 -303,480.00 12/30/2026 3130AQEF6 4604 FHLB 12/30/2021 3,000,000.00 2,696,970.00 2,998,500.00 1.375 1247 1.385 3,552.08 -301,530.00 12/30/2026 Portfolio PLST CC Run Date:09/06/2023-13:35 PM(PRF_PMB)7.3.11