07 - Laserfiche WebLink

CITY OF PLEASANTON Portfolio Management Page 2 Portfolio Details with Earnings - Investments August 31, 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 3130AKZ25 4559 FHLB 02/26/2021 3,000,000.00 2,699,670.00 3,000,000.00 0.650 909 0.650 270.83 -300,330.00 02/26/2026 3130AUS1 4560 FHLB 02/17/2021 3,000,000.00 2,700,270.00 3,000,000.00 0.625 900 0.625 729.17 -299,730.00 02/17/2026 3130AL5X8 4561 FHLB 02/24/2021 3,000,000.00 2,700,120.00 3,000,000.00 0.650 907 0.650 379.17 -299,880.00 02/24/2026 3130AKXJ0 4562 FHLB 02/24/2021 3,125,000.00 2,809,031.25 3,122,500.00 0.600 907 0.616 364.58 -313,468.75 02/24/2026 3130ALCV4 4563 FHLB 02/24/2021 3,000,000.00 2,706,990.00 3,000,000.00 0.750 907 0.750 437.50 -293,010.00 02/24/2026 3130ALDN1 4565 FHLB 03/16/2021 3,000,000.00 2,705,880.00 3,000,000.00 0.800 927 0.800 11,000.00 -294,120.00 03/16/2026 3130ALGC2 4569 FHLB 03/23/2021 3,000,000.00 2,709,540.00 3,000,000.00 0.875 934 0.875 11,520.83 -290,460.00 03/23/2026 3130ALMM3 4571 FHLB 03/30/2021 3,000,000.00 2,716,740.00 3,000,000.00 1.000 941 1.000 12,583.33 -283,260.00 03/30/2026 3130ALGR9 4572 FHLB 03/15/2021 3,000,000.00 2,713,500.00 2,989,560.00 0.850 909 0.922 354.17 -276,060.00 02/26/2026 3130ALGR9 4574 FHLB 03/18/2021 3,000,000.00 2,713,500.00 2,985,960.00 0.850 909 0.947 354.17 -272,460.00 02/26/2026 3130ALGC2 4576 FHLB 03/23/2021 3,000,000.00 2,709,540.00 2,987,700.00 0.875 934 0.959 11,520.83 -278,160.00 03/23/2026 3130ALGR9 4577 FHLB 03/22/2021 3,000,000.00 2,713,500.00 2,982,510.00 0.850 909 0.971 354.17 -269,010.00 02/26/2026 3130ALNT7 4578 FHLB 03/30/2021 3,000,000.00 2,715,330.00 2,998,050.00 0.980 941 0.993 12,331.67 -282,720.00 03/30/2026 3130ALGR9 4579 FHLB 03/31/2021 3,000,000.00 2,713,500.00 2,978,517.00 0.850 909 1.000 354.17 -265,017.00 02/26/2026 3130ALUC6 4580 FHLB 04/15/2021 3,000,000.00 2,714,130.00 2,995,500.00 1.020 957 1.050 11,560.00 -281,370.00 04/15/2026 3130ALMM3 4581 FHLB 04/05/2021 3,000,000.00 2,716,740.00 2,996,250.00 1.000 941 1.025 12,583.33 -279,510.00 03/30/2026 3130AMCL4 4585 FHLB 05/20/2021 2,795,000.00 2,522,347.75 2,795,000.00 1.020 991 1.019 8,077.55 -272,652.25 05/19/2026 3130AMH62 4587 FHLB 05/26/2021 3,000,000.00 2,704,260.00 2,998,500.00 1.000 998 1.010 7,916.67 -294,240.00 05/26/2026 3130AMGW6 4588 FHLB 05/26/2021 3,000,000.00 2,702,760.00 2,998,950.00 0.980 998 0.987 7,758.33 -296,190.00 05/26/2026 3130AMHB1 4590 FHLB 06/02/2021 2,750,000.00 2,470,270.00 2,746,562.50 0.875 998 0.900 6,349.83 -276,292.50 05/26/2026 3130AMH62 4591 FHLB 06/02/2021 1,500,000.00 1,352,130.00 1,500,000.00 1.000 998 0.999 3,958.33 -147,870.00 05/26/2026 3130AMSL7 4592 FHLB 06/30/2021 3,000,000.00 2,698,020.00 3,000,000.00 1.030 1033 1.030 5,235.83 -301,980.00 06/30/2026 3130AMYA4 4594 FHLB 06/30/2021 3,000,000.00 2,701,140.00 3,000,000.00 1.070 1033 1.070 5,439.17 -298,860.00 06/30/2026 3130AN2Q2 4596 FHLB 06/30/2021 1,500,000.00 1,347,840.00 1,500,000.00 1.000 1033 1.000 2,541.67 -152,160.00 06/30/2026 3130AMWK4 4597 FHLB 07/14/2021 3,000,000.00 2,691,780.00 2,999,250.00 1.020 1047 1.025 3,995.00 -307,470.00 07/14/2026 3130AP2P9 4598 FHLB 09/30/2021 3,000,000.00 2,665,020.00 2,983,500.00 0.920 1125 1.033 11,576.67 -318,480.00 09/30/2026 3130APC94 4599 FHLB 10/14/2021 3,000,000.00 2,678,430.00 2,997,750.00 1.070 1139 1.085 12,215.83 -319,320.00 10/14/2026 3130APU78 4600 FHLB 12/09/2021 530,000.00 475,765.10 526,947.20 1.300 1180 1.420 1,856.47 -51,182.10 11/24/2026 3130APUR4 4601 FHLB 12/09/2021 1,840,000.00 1,651,712.80 1,829,401.60 1.300 1180 1.420 6,445.11 -177,688.80 11/24/2026 3130APVC6 4602 FHLB 12/09/2021 3,000,000.00 2,698,380.00 2,988,000.00 1.375 1187 1.458 10,312.50 -289,620.00 12/01/2026 3130AQEC3 4603 FHLB 12/30/2021 3,000,000.00 2,691,990.00 3,000,000.00 1.370 1216 1.370 6,964.17 -308,010.00 12/30/2026 3130AQEF6 4604 FHLB 12/30/2021 3,000,000.00 2,692,440.00 2,998,500.00 1.375 1216 1.385 6,989.58 -306,060.00 12/30/2026 3130AQG80 4605 FHLB 01/03/2022 3,000,000.00 2,696,550.00 2,999,250.00 1.420 1215 1.425 7,336.67 -302,700.00 12/29/2026 3130AQG80 4606 FHLB 01/10/2022 3,000,000.00 2,696,550.00 2,982,750.00 1.420 1215 1.540 7,336.67 -286,200.00 12/29/2026 3130AQLD3 4607 FHLB 02/08/2022 3,000,000.00 2,712,150.00 2,975,010.00 1.750 1245 1.926 4,812.50 -262,860.00 01/28/2027 3130AQW66 4608 FHLB 03/08/2022 3,000,000.00 2,737,320.00 2,995,500.00 2.080 1273 2.111 1,040.00 -258,180.00 02/25/2027 3134GVZ68 4535 FHLMC 06/23/2020 3,000,000.00 2,767,590.00 2,998,950.00 0.700 661 0.707 3,966.67 -231,360.00 06/23/2025 3134GWA55 4545 FHLMC 09/09/2020 3,000,000.00 2,744,940.00 2,998,950.00 0.650 739 0.657 9,316.67 -254,010.00 09/09/2025 Portfolio PI-ST CC Run Date:10/03/2023-16:42 PM(PRF_PM6)7.3.11