Laserfiche WebLink
CITY OF PLEASANTON <br />Portfolio Management <br />Portfolio Details -Investments <br />July 31, 2019 <br />Page 1 <br />CUSIP Investment # <br />Average <br />Issuer Balance <br />Purchase <br />Date <br />Par Value <br />Market Value <br />Book Value <br />Stated <br />Rate <br />YTM <br />360 <br />YTM Days to Maturity <br />365 Maturity Date <br />Certificates of Deposit -Bank <br />1 <br />SYS2A <br />2A <br />Fidelity -Money Market Fund <br />0.00 <br />0.00 <br />0.00 <br />SYS EWB 1076 <br />East West Bank <br />07/24/2018 <br />247,349.68 <br />247,349.66 <br />247,349.68 <br />2.450 <br />2.450 <br />2.484 358 07/24/2020 <br />SYS 1078 1076 <br />Fremont Bank <br />10/22/2018 <br />247,461.93 <br />247,461.93 <br />247,461.93 <br />2.620 <br />2.620 <br />2.656 447 10/21/2020 <br />SYS 1077 1077 <br />Heritage Bank of Commerce <br />10/21/2018 <br />247,462.27 <br />247,462.27 <br />247,462.27 <br />1.750 <br />1.750 <br />1.774 81 10/21/2019 <br />VCB 1072 <br />United Business Bank <br />04/11/2018 <br />248,205.74 <br />248,205.74 <br />248,205.74 <br />2.000 <br />1.973 <br />2.000 254 04/11/2020 <br />LAIF <br />SYS5 5 <br />Fidelity -Government Fund <br />Subtotal and Average 990,479.62 990,479.62 990,479.62 990,479.62 2.198 2.228 285 <br />LOCAL AGENCY INVESTMENT FUND <br />Subtotal and Average 20,887,096.77 <br />22,000,000.00 22,000,000.00 22,000,000.00 2.436 2.403 2.436 1 <br />SYS2 <br />2 <br />Fidelity -Money Market Fund <br />0.00 <br />0.00 <br />0.00 <br />0.010 <br />0.010 <br />0.010 <br />1 <br />SYS2A <br />2A <br />Fidelity -Money Market Fund <br />0.00 <br />0.00 <br />0.00 <br />0.010 <br />0.010 <br />0.010 <br />1 <br />Subtotal and Average 0.00 <br />0.00 <br />0.00 <br />0.00 <br />0.000 <br />0.000 <br />0 <br />Medium Term Notes <br />037833001 <br />6014 <br />Apple Inc. <br />07/05/2017 <br />1,000,000.00 <br />1,005,310.00 <br />1,002,150.00 <br />2.300 <br />2.222 <br />2.253 <br />1,014 05/11/2022 <br />037833001 <br />6015 <br />Apple Inc. <br />12/20/2017 <br />2,000,000.00 <br />2,010,620.00 <br />1,990,800.00 <br />2.300 <br />2.378 <br />2.411 <br />1,014 05/11/2022 <br />037833BU3 <br />6024 <br />Apple Inc. <br />08/31/2018 <br />1,500,000.00 <br />1,534,710.00 <br />1,487,250.00 <br />2.850 <br />3.013 <br />3.054 <br />1,302 02/23/2023 <br />037833DC1 <br />6044 <br />Apple Inc. <br />04/16/2019 <br />2,000,000.00 <br />2,001,506.67 <br />1,968,726.67 <br />2.100 <br />2.608 <br />2.644 <br />1,138 09/12/2022 <br />037833CU2 <br />6045 <br />Apple Inc. <br />05/03/2019 <br />2,000,000.00 <br />2,052,380.00 <br />2,009,000.00 <br />2.850 <br />2.716 <br />2.753 <br />1,745 05/11/2024 <br />064159JG2 <br />6026 <br />Bank of Nova Scotia <br />11/02/2018 <br />2,000,000.00 <br />2,020,320.00 <br />1,956,244.08 <br />2.700 <br />3.350 <br />3.396 <br />949 03/07/2022 <br />06406HBU2 <br />6025 <br />BANK OF NEWYORK MELLON <br />08/31/2018 <br />2,685,000.00 <br />2,757,897.75 <br />2,756,406.81 <br />4.150 <br />2.959 <br />3.000 <br />550 02/01/2021 <br />06406RAE7 <br />6041 <br />BANK OF NEWYORK MELLON <br />02/26/2019 <br />2,000,000.00 <br />2,038,740.00 <br />2,003,610.13 <br />2.950 <br />2.861 <br />2.901 <br />1,277 01/29/2023 <br />594918BN3 <br />6009 <br />Microsoft Corp <br />08/08/2016 <br />2,000,000.00 <br />1,999,520.00 <br />1,998,240.00 <br />1.100 <br />1.114 <br />1.130 <br />7 08/08/2019 <br />594918BV5 <br />6011 <br />Microsoft Corp <br />04/27/2017 <br />2,000,000.00 <br />1,995,980.00 <br />2,010,780.00 <br />1.850 <br />1.628 <br />1.650 <br />189 02/06/2020 <br />594918BG8 <br />6016 <br />Microsoft Corp <br />02/28/2018 <br />1,000,000.00 <br />999,430.00 <br />987,740.00 <br />2.000 <br />2.441 <br />2.475 <br />460 11/03/2020 <br />594918BG8 <br />6017 <br />Microsoft Corp <br />03/01/2018 <br />1,250,000.00 <br />1,249,287.50 <br />1,232,962.50 <br />2.000 <br />2.496 <br />2.530 <br />460 11/03/2020 <br />5949186P8 <br />6018 <br />Microsoft Corp <br />06/21/2018 <br />2,000,000.00 <br />1,979,940.00 <br />1,921,000.00 <br />1.550 <br />2.839 <br />2.878 <br />738 08/08/2021 <br />594918606 <br />6022 <br />Microsoft Corp <br />07/12/2018 <br />2,000,000.00 <br />1,995,060.00 <br />1,896,800.00 <br />2.000 <br />3.065 <br />3.107 <br />1,468 08/08/2023 <br />594918AT1 <br />6023 <br />Microsoft Corp <br />08/31/2018 <br />1,500,000.00 <br />1,514,880.00 <br />1,457,400.00 <br />2.375 <br />2.990 <br />3.032 <br />1,369 05/01/2023 <br />89233P5T9 <br />6034 <br />Toyota Motor Credit Corp <br />12/24/2018 <br />2,000,000.00 <br />2,047,220.00 <br />2,008,057.39 <br />3.300 <br />3.117 <br />3.160 <br />895 01/12/2022 <br />89236TEL5 <br />6035 <br />Toyota Motor Credit Corp <br />01/10/2019 <br />1,180,000.00 <br />1,195,198.40 <br />1,151,479.40 <br />2.700 <br />3.304 <br />3.350 <br />1,259 01/11/2023 <br />89236TD05 <br />6040 <br />Toyota Motor Credit Corp <br />02/05/2019 <br />1,200,000.00 <br />1,210,812.00 <br />1,211,256.00 <br />3.489 <br />3.106 <br />3.149 <br />894 01/11/2022 <br />90331HNJ8 <br />6031 <br />US BANK <br />12/20/2018 <br />5,000,000.00 <br />5,000,250.00 <br />4,974,316.76 <br />2.350 <br />2.791 <br />2.830 <br />175 01/23/2020 <br />Portfolio PLST <br />CC <br />Run Date. 09/0312019 - 11'43 <br />PM (PRF_PM2) 7.3.0 <br />Report Ver. 7.3.3 <br />