Laserfiche WebLink
CITY OF PLEASANTON <br />Portfolio Management <br />Portfolio Details - Investments <br />August 31, 2020 <br />Page 2 <br />Average <br />Purchase <br />Stated <br />YTM <br />YTM <br />Days to Maturity <br />CUSIP <br />Investment # <br />Issuer Balance <br />Date <br />Par Value <br />Market Value <br />Book Value <br />Rate <br />360 <br />365 <br />Maturity Date <br />Medium Term Notes <br />89236TEL5 <br />6035 <br />Toyota Motor Credit Corp <br />01/10/2019 <br />1,180,000.00 <br />1,241,183.00 <br />1,151,479.40 <br />2.700 <br />3.304 <br />3.350 <br />862 01/11/2023 <br />89236TDQ5 <br />6040 <br />Toyota Motor Credit Corp <br />02/05/2019 <br />1,200,000.00 <br />1,208,760.00 <br />1,211,256.00 <br />3.489 <br />3.106 <br />3.149 <br />497 01/11/2022 <br />89236TGL3 <br />6046 <br />Toyota Motor Credit Corp <br />10/24/2019 <br />1,600,000.00 <br />1,688,240.00 <br />1,599,984.00 <br />2.000 <br />1.973 <br />2.000 <br />1,497 10/07/2024 <br />892331AC3 <br />6047 <br />Toyota Motor Credit Corp <br />01/07/2020 <br />1,000,000.00 <br />1,081,480.00 <br />1,055,220.25 <br />3.419 <br />1.775 <br />1.800 <br />1,052 07/20/2023 <br />89788JAA7 <br />6058 <br />Truist Bank <br />03/13/2020 <br />2,000,000.00 <br />2,074,453.33 <br />1,969,819.33 <br />1.500 <br />1.796 <br />1.821 <br />1,651 03/10/2025 <br />94988J5N3 <br />6033 <br />Wells Fargo Bank <br />12/21/2018 <br />2,000,000.00 <br />2,017,560.00 <br />1,974,193.46 <br />2.600 <br />3.205 <br />3.250 <br />136 01/15/2021 <br />94988J5N3 <br />6043 <br />Wells Fargo Bank <br />02/28/2019 <br />2,000,000.00 <br />2,017,560.00 <br />1,988,309.82 <br />2.600 <br />2.881 <br />2.921 <br />136 01/15/2021 <br />95001D5Y2 <br />6054 <br />Wells Fargo Bank NA <br />03/17/2020 <br />3,000,000.00 <br />2,994,600.00 <br />3,000,000.00 <br />1.750 <br />1.726 <br />1.750 <br />1,658 03/17/2025 <br />30231GAF9 <br />6056 <br />EXXON MOBIL CORPORATION <br />03/11/2020 <br />3,000,000.00 <br />3,253,698.75 <br />3,146,715.75 <br />2.709 <br />1.667 <br />1.690 <br />1,647 03/06/2025 <br />30231GSH4 <br />6064 <br />EXXON MOBIL CORPORATION <br />04/20/2020 <br />2,000,000.00 <br />2,208,572.89 <br />2,118,952.89 <br />2.992 <br />1.753 <br />1.777 <br />1,660 03/19/2025 <br />Subtotal <br />and Average 51,852,267.76 <br />51,785,000.00 <br />54,079,936.92 <br />51,848,883.78 <br />2.498 <br />2.533 <br />953 <br />Federal Agency Issues - Coupon <br />3133EKGC4 <br />3574 <br />FEDERAL FARM CREDIT BANK <br />04/17/2019 <br />2,000,000.00 <br />2,105,360.00 <br />1,987,140.00 <br />2.250 <br />2.388 <br />2.421 <br />946 04/05/2023 <br />313383MC2 <br />3572 <br />FEDERAL HOME LOAN BANK <br />12/20/2017 <br />2,000,000.00 <br />2,031,940.00 <br />2,001,580.00 <br />2.125 <br />2.072 <br />2.101 <br />283 06/11/2021 <br />3135GOF73 <br />3568 <br />FEDERAL NATIONAL MORTGAGE ASSN <br />02/10/2017 <br />1,000,000.00 <br />1,003,450.00 <br />993,100.00 <br />1.500 <br />1.665 <br />1.688 <br />90 11/30/2020 <br />Subtotal and Average 4,981,820.00 <br />5,000,000.00 <br />5,140,750.00 <br />4,981,820.00 <br />2.117 <br />2.146 <br />509 <br />Treasury Securities <br />- Coupon <br />9128281-65 <br />2355 <br />U S TREASURY <br />02/27/2019 <br />2,000,000.00 <br />2,002,000.00 <br />1,965,172.32 <br />1.375 <br />2.092 <br />2.121 <br />29 09/30/2020 <br />Subtotal and Average 3,874,178.77 <br />2,000,000.00 <br />2,002,000.00 <br />1,965,172.32 <br />2.092 <br />2.121 <br />29 <br />Federal Agency Issues - Callable <br />3133EKRP3 <br />4458 <br />FEDERAL FARM CREDIT BANK <br />06/21/2019 <br />3,000,000.00 <br />3,038,820.00 <br />3,000,000.00 <br />2.220 <br />2.190 <br />2.220 <br />1,389 06/21/2024 <br />3133EKM94 <br />4471 <br />FEDERAL FARM CREDIT BANK <br />09/11/2019 <br />2,000,000.00 <br />2,000,860.00 <br />2,000,000.00 <br />1.900 <br />1.874 <br />1.900 <br />1,105 09/11/2023 <br />3133EK61-5 <br />4478 <br />FEDERAL FARM CREDIT BANK <br />11/12/2019 <br />2,000,000.00 <br />2,034,860.00 <br />2,000,000.00 <br />1.790 <br />1.765 <br />1.790 <br />1,533 11/12/2024 <br />3133EKH41 <br />4480 <br />FEDERAL FARM CREDIT BANK <br />11/08/2019 <br />2,000,000.00 <br />2,000,260.00 <br />2,000,000.00 <br />2.000 <br />1.972 <br />2.000 <br />1,463 09/03/2024 <br />3133ELBFO <br />4483 <br />FEDERAL FARM CREDIT BANK <br />11/27/2019 <br />2,000,000.00 <br />2,007,360.00 <br />2,000,000.00 <br />1.890 <br />1.864 <br />1.890 <br />1,548 11/27/2024 <br />3133ELMJO <br />4517 <br />FEDERAL FARM CREDIT BANK <br />02/12/2020 <br />2,000,000.00 <br />2,010,060.00 <br />2,000,000.00 <br />1.690 <br />1.667 <br />1.690 <br />1,259 02/12/2024 <br />3133ELRN6 <br />4523 <br />FEDERAL FARM CREDIT BANK <br />03/05/2020 <br />3,000,000.00 <br />3,004,650.00 <br />3,000,000.00 <br />1.500 <br />1.479 <br />1.500 <br />1,646 03/05/2025 <br />3133ELE42 <br />4533 <br />FEDERAL FARM CREDIT BANK <br />06/18/2020 <br />2,000,000.00 <br />2,000,731.11 <br />1,999,211.11 <br />0.800 <br />0.804 <br />0.815 <br />1,735 06/02/2025 <br />3133ELQ49 <br />4537 <br />FEDERAL FARM CREDIT BANK <br />07/06/2020 <br />3,000,000.00 <br />3,000,380.00 <br />2,998,100.00 <br />0.700 <br />0.706 <br />0.715 <br />1,763 06/30/2025 <br />3133ELZ64 <br />4542 <br />FEDERAL FARM CREDIT BANK <br />07/27/2020 <br />2,000,000.00 <br />1,995,840.00 <br />1,998,500.00 <br />0.640 <br />0.648 <br />0.657 <br />1,609 01/27/2025 <br />3130AGZR9 <br />4472 <br />FEDERAL HOME LOAN BANK <br />09/24/2019 <br />2,000,000.00 <br />2,002,180.00 <br />2,000,000.00 <br />1.950 <br />1.923 <br />1.950 <br />1,484 09/24/2024 <br />3130AHMM2 <br />4487 <br />FEDERAL HOME LOAN BANK <br />12/11/2019 <br />2,000,000.00 <br />2,006,120.00 <br />2,000,000.00 <br />1.850 <br />1.825 <br />1.850 <br />1,379 06/11/2024 <br />3130AHN66 <br />4491 <br />FEDERAL HOME LOAN BANK <br />12/16/2019 <br />2,000,000.00 <br />2,007,080.00 <br />2,000,000.00 <br />1.940 <br />1.913 <br />1.940 <br />1,567 12/16/2024 <br />Portfolio PLST <br />CC <br />Run Date. 09/24/2020 - 1539 <br />PM (PRF PM2) 7.3.0 <br />