07 - Laserfiche WebLink

CITY OF PLEASANTON Portfolio Management Page 2 Portfolio Details with Earnings -Investments November 30, 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,984,060.00 1,987,140.00 2.250 125 2.420 29,500.00 -3,080.00 04/05/2023 313OAQF65 3576 FHLB 12/22/2021 3,000,000.00 2,688,450.00 2,995,657.09 1.250 1481 1.280 16,666.66 -307,207.09 12/21/2026 Subtotal and Average 4,982,797.09 5,000,000.00 4,672,510.00 4,982,797.09 1.649 940 1.735 46,166.66 -310,287.09 Federal Agency Issues-Callable 3133ELQ49 4537 FFCB 07/06/2020 3,000,000.00 2,728,320.00 2,997,750.00 0.700 942 0.715 8,808.33 -269,430.00 06/30/2025 3133EMBJO 4548 FFCB 10/05/2020 3,340,000.00 2,976,068.03 3,336,955.03 0.530 1033 0.550 3,048.68 -360,887.00 09/29/2025 3133EMUK6 4575 FFCB 03/25/2021 3,000,000.00 2,693,700.00 3,000,000.00 1.050 1210 1.050 5,775.00 -306,300.00 03/25/2026 3133EMH21 4595 FFCB 06/24/2021 3,000,000.00 2,662,680.00 2,997,000.00 0.900 1292 0.920 12,450.00 -334,320.00 06/15/2026 3130AJZ36 4544 FHLB 08/27/2020 3,000,000.00 2,697,900.00 2,997,000.00 0.600 1000 0.620 4,700.00 -299,100.00 08/27/2025 3130AKGD2 4553 FHLB 11/25/2020 3,000,000.00 2,675,370.00 2,996,250.00 0.570 1090 0.595 285.00 -320,880.00 11/25/2025 313OAKQ74 4555 FHLB 01/22/2021 3,000,000.00 2,665,890.00 3,000,000.00 0.625 1148 0.625 6,718.75 -334,110.00 01/22/2026 3130AKRN8 4557 FHLB 01/28/2021 3,000,000.00 2,670,660.00 3,000,000.00 0.650 1154 0.650 6,662.50 -329,340.00 01/28/2026 313OAKX04 4558 FHLB 02/12/2021 3,000,000.00 2,658,570.00 3,000,000.00 0.600 1169 0.110 5,450.00 -341,430.00 02/12/2026 313OAKZ25 4559 FHLB 02/26/2021 3,000,000.00 2,659,770.00 3,000,000.00 0.650 1183 0.650 5,145.83 -340,230.00 02/26/2026 3130AL3S1 4560 FHLB 02/17/2021 3,000,000.00 2,659,530.00 3,000,000.00 0.625 1174 0.625 5,416.67 -340,470.00 02/17/2026 3130AL5X8 4561 FHLB 02/24/2021 3,000,000.00 2,660,220.00 3,000,000.00 0.650 1181 0.650 5,254.17 -339,780.00 02/24/2026 313OAKXJO 4562 FHLB 02/24/2021 3,125,000.00 2,766,437.50 3,122,500.00 0.600 1181 0.616 5,052.08 -356,062.50 02/24/2026 3130ALCV4 4563 FHLB 02/24/2021 3,000,000.00 2,669,040.00 3,000,000.00 0.750 1181 0.750 6,062.50 -330,960.00 02/24/2026 3130ALDN1 4565 FHLB 03/16/2021 3,000,000.00 2,668,920.00 3,000,000.00 0.800 1201 0.800 5,000.00 -331,080.00 03/16/2026 3130ALGC2 4569 FHLB 03/23/2021 3,000,000.00 2,674,140.00 3,000,000.00 0.875 1208 0.875 4,958.33 -325,860.00 03/23/2026 3130ALMM3 4571 FHLB 03/30/2021 3,000,000.00 2,683,860.00 3,000,000.00 1.000 1215 1.000 5,083.33 -316,140.00 03/30/2026 3130ALGR9 4572 FHLB 03/15/2021 3,000,000.00 2,675,880.00 2,989,560.00 0.850 1183 0.922 6,729.17 -313,680.00 02/26/2026 3130ALGR9 4574 FHLB 03/18/2021 3,000,000.00 2,675,880.00 2,985,960.00 0.850 1183 0.947 6,729.17 -310,080.00 02/26/2026 3130ALGC2 4576 FHLB 03/23/2021 3,000,000.00 2,674,140.00 2,987,700.00 0.875 1208 0.959 4,958.33 -313,560.00 03/23/2026 3130ALGR9 4577 FHLB 03/22/2021 3,000,000.00 2,675,880.00 2,982,510.00 0.850 1183 0.971 6,729.17 -306,630.00 02/26/2026 3130ALNT7 4578 FHLB 03/30/2021 3,000,000.00 2,682,030.00 2,998,050.00 0.980 1215 0.993 4,981.67 -316,020.00 03/30/2026 3130ALGR9 4579 FHLB 03/31/2021 3,000,000.00 2,675,880.00 2,978,517.00 0.850 1183 1.000 6,729.17 -302,637.00 02/26/2026 3130ALUC6 4580 FHLB 04/15/2021 3,000,000.00 2,682,360.00 2,995,500.00 1.020 1231 1.050 19,210.00 -313,140.00 04/15/2026 3130ALMM3 4581 FHLB 04/05/2021 3,000,000.00 2,683,860.00 2,996,250.00 1.000 1215 1.025 5,083.33 -312,390.00 03/30/2026 3130AMCL4 4585 FHLB 05/20/2021 2,795,000.00 2,485,649.40 2,795,000.00 1.020 1265 1.019 950.30 -309,350.60 05/19/2026 3130AMH62 4587 FHLB 05/26/2021 3,000,000.00 2,670,870.00 2,998,500.00 1.000 1272 1.010 416.67 -327,630.00 05/26/2026 3130AMGW6 4588 FHLB 05/26/2021 3,000,000.00 2,670,060.00 2,998,950.00 0.980 1272 0.987 408.33 -328,890.00 05/26/2026 3130AMHB1 4590 FHLB 06/02/2021 2,750,000.00 2,438,507.50 2,746,562.50 0.875 1272 0.900 334.20 -308,055.00 05/26/2026 3130AMH62 4591 FHLB 06/02/2021 1,500,000.00 1,335,435.00 1,500,000.00 1.000 1272 0.999 208.33 -164,565.00 05/26/2026 3130AMSL7 4592 FHLB 06/30/2021 3,000,000.00 2,667,480.00 3,000,000.00 1.030 1307 1.030 12,960.83 -332,520.00 06/30/2026 3130AMYA4 4594 FHLB 06/30/2021 3,000,000.00 2,671,320.00 3,000,000.00 1.070 1307 1.070 13,464.17 -328,680.00 06/30/2026 3130AN2Q2 4596 FHLB 06/30/2021 1,500,000.00 1,332,300.00 1,500,000.00 1.000 1307 1.000 6,291.67 -167,700.00 06/30/2026 Portfolio PLST CC Run Date:01/03/2023-09:58 PM(PRF_PM8)7.3.11