07 - Laserfiche WebLink

CITY OF PLEASANTON Portfolio Management Page 2 Portfolio Details - Investments June 30, 2020 Average Purchase Stated YTM YTM Days to Maturity CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate 360 365 Maturity Date Medium Term Notes 89236TEL5 6035 Toyota Motor Credit Corp 01/10/2019 1,180,000.00 1,239,590.00 1,151,479.40 2.700 3.304 3.350 924 01/11/2023 89236TDQ5 6040 Toyota Motor Credit Corp 02/05/2019 1,200,000.00 1,206,804.00 1,211,256.00 3.489 3.106 3.149 559 01/11/2022 89236TGL3 6046 Toyota Motor Credit Corp 10/24/2019 1,600,000.00 1,664,880.00 1,599,984.00 2.000 1.973 2.000 1,559 10/07/2024 892331AC3 6047 Toyota Motor Credit Corp 01/07/2020 1,000,000.00 1,079,880.00 1,055,220.25 3.419 1.775 1.800 1,114 07/20/2023 89788JAA7 6058 Truist Bank 03/13/2020 2,000,000.00 2,053,093.33 1,969,819.33 1.500 1.796 1.821 1,713 03/10/2025 94988J5N3 6033 Wells Fargo Bank 12/21/2018 2,000,000.00 2,024,180.00 1,974,193.46 2.600 3.205 3.250 198 01/15/2021 94988J5N3 6043 Wells Fargo Bank 02/28/2019 2,000,000.00 2,024,180.00 1,988,309.82 2.600 2.881 2.921 198 01/15/2021 95001D5Y2 6054 Wells Fargo Bank NA 03/17/2020 3,000,000.00 3,007,440.00 3,000,000.00 1.750 1.726 1.750 1,720 03/17/2025 30231GAF9 6056 EXXON MOBIL CORPORATION 03/11/2020 3,000,000.00 3,220,848.75 3,146,715.75 2.709 1.667 1.690 1,709 03/06/2025 30231GBH4 6064 EXXON MOBIL CORPORATION 04/20/2020 2,000,000.00 2,176,732.89 2,118,952.89 2.992 1.753 1.777 1,722 03/19/2025 Subtotal and Average 51,857,912.59 51,785,000.00 54,000,635.58 51,857,912.59 2.498 2.533 1,015 Federal Agency Issues-Coupon 3133EKGC4 3574 FEDERAL FARM CREDIT BANK 04/17/2019 2,000,000.00 2,107,140.00 1,987,140.00 2.250 2.388 2.421 1,008 04/05/2023 313383MC2 3572 FEDERAL HOME LOAN BANK 12/20/2017 2,000,000.00 2,034,080.00 2,001,580.00 2.125 2.072 2.101 345 06/11/2021 3135G0F73 3568 FEDERAL NATIONAL MORTGAGE ASSN 02/10/2017 1,000,000.00 1,005,380.00 993,100.00 1.500 1.665 1.688 152 11/30/2020 Subtotal and Average 5,716,268.00 5,000,000.00 5,146,600.00 4,981,820.00 2.117 2.146 571 Treasury Securities-Coupon 912828XM7 2353 U S TREASURY 12/19/2017 2,000,000.00 2,002,400.00 1,986,500.00 1.625 1.864 1.890 30 07/31/2020 912828L32 2354 U S TREASURY 12/19/2017 2,000,000.00 2,003,960.00 1,972,640.00 1.375 1.872 1.898 61 08/31/2020 912828L65 2355 U S TREASURY 02/27/2019 2,000,000.00 2,005,940.00 1,965,172.32 1.375 2.092 2.121 91 09/30/2020 Subtotal and Average 7,848,717.52 6,000,000.00 6,012,300.00 5,924,312.32 1.942 1.969 61 Federal Agency Issues-Callable 3133EKRP3 4458 FEDERAL FARM CREDIT BANK 06/21/2019 3,000,000.00 3,045,270.00 3,000,000.00 2.220 2.190 2.220 1,451 06/21/2024 3133EKM94 4471 FEDERAL FARM CREDIT BANK 09/11/2019 2,000,000.00 2,003,340.00 2,000,000.00 1.900 1.874 1.900 1,167 09/11/2023 3133EK6L5 4478 FEDERAL FARM CREDIT BANK 11/12/2019 2,000,000.00 2,038,580.00 2,000,000.00 1.790 1.765 1.790 1,595 11/12/2024 3133EKH41 4480 FEDERAL FARM CREDIT BANK 11/08/2019 2,000,000.00 2,002,560.00 2,000,000.00 2.000 1.972 2.000 1,525 09/03/2024 3133ELBFO 4483 FEDERAL FARM CREDIT BANK 11/27/2019 2,000,000.00 2,012,000.00 2,000,000.00 1.890 1.864 1.890 1,610 11/27/2024 3133ELMJ0 4517 FEDERAL FARM CREDIT BANK 02/12/2020 2,000,000.00 2,013,220.00 2,000,000.00 1.690 1.667 1.690 1,321 02/12/2024 3133ELRN6 4523 FEDERAL FARM CREDIT BANK 03/05/2020 3,000,000.00 3,005,400.00 3,000,000.00 1.500 1.479 1.500 1,708 03/05/2025 3133ELE42 4533 FEDERAL FARM CREDIT BANK 06/18/2020 2,000,000.00 2,000,811.11 1,999,211.11 0.800 0.804 0.815 1,797 06/02/2025 3130AGZR9 4472 FEDERAL HOME LOAN BANK 09/24/2019 2,000,000.00 2,007,960.00 2,000,000.00 1.950 1.923 1.950 1,546 09/24/2024 3130AHMM2 4487 FEDERAL HOME LOAN BANK 12/11/2019 2,000,000.00 2,012,160.00 2,000,000.00 1.850 1.825 1.850 1,441 06/11/2024 3130AHN66 4491 FEDERAL HOME LOAN BANK 12/16/2019 2,000,000.00 2,013,360.00 2,000,000.00 1.940 1.913 1.940 1,629 12/16/2024 Portfolio PLST CC Run Date:07/15/2020-17:17 PM(PRF_PM2)7.3.0