|
CITY OF PLEASANTON
<br /> Portfolio Management Page 1
<br /> Portfolio Details - Investments
<br /> April 30, 2018
<br /> Average Purchase Stated YTM YTM Days to Maturity
<br /> CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate 360 365 Maturity Date
<br /> Certificates of Deposit-Bank
<br /> SYS 1068 East West Bank 07/29/2017 246,497.91 246,497.91 246,497.91 0.595 0.587 0.595 88 07/28/2018
<br /> SYS1070 1070 Fremont Bank 10/21/2017 246,227.97 246,227.97 246,227.97 0.500 0.493 0.500 173 10/21/2018
<br /> SYS 1069 1069 Heritage Bank of Commerce 10/21/2017 246,228.06 246,228.06 246,228.06 0.500 0.493 0.500 173 10/21/2018
<br /> VCB 1072 United Business Bank 04/11/2018 248,205.74 248,205.74 248,205.74 2.000 1.973 2.000 711 04/11/2020
<br /> Subtotal and Average 986,091.10 987,159.68 987,159.68 987,159.68 0.889 0.901 287
<br /> LAIF
<br /> SYS5 5 LOCAL AGENCY INVESTMENT FUND 50,000,000.00 49,876,900.50 50,000,000.00 1.430 1.410 1.430 1
<br /> Subtotal and Average 40,000,000.00 50,000,000.00 49,876,900.50 50,000,000.00 1.410 1.430 1
<br /> Fidelity-Government Fund
<br /> SYS2 2 Fidelity-Money Market Fund 0.00 0.00 0.00 0.010 0.010 0.010 1
<br /> SYS2A 2A Fidelity-Money Market Fund 0.00 0.00 0.00 0.010 0.010 0.010 1
<br /> Subtotal and Average 0.00 0.00 0.00 0.00 0.000 0.000 0
<br /> Medium Term Notes
<br /> 037833AJ9 6007 Apple Inc. 04/08/2015 2,000,000.00 1,999,900.00 1,993,360.00 1.000 1.095 1.110 2 05/03/2018
<br /> 037833CQ1 6014 Apple Inc. 07/05/2017 1,000,000.00 969,010.00 1,002,150.00 2.300 2.222 2.253 1,471 05/11/2022
<br /> 037833CQ1 6015 Apple Inc. 12/20/2017 2,000,000.00 1,943,003.33 1,995,783.33 2.300 2.378 2.411 1,471 05/11/2022
<br /> 594918BN3 6009 Microsoft Corp 08/08/2016 2,000,000.00 1,964,480.00 1,998,240.00 1.100 1.114 1.130 464 08/08/2019
<br /> 594918BV5 6011 Microsoft Corp 04/27/2017 2,000,000.00 1,973,600.00 2,010,780.00 1.850 1.628 1.650 646 02/06/2020
<br /> 594918BG8 6016 Microsoft Corp 02/28/2018 1,000,000.00 989,448.89 994,128.89 2.000 2.441 2.475 917 11/03/2020
<br /> 594918BG8 6017 Microsoft Corp 03/01/2018 1,250,000.00 1,237,019.44 1,241,156.94 2.000 2.496 2.530 917 11/03/2020
<br /> Subtotal and Average 11,235,599.16 11,250,000.00 11,076,461.66 11,235,599.16 1.796 1.821 773
<br /> Federal Agency Issues-Coupon
<br /> 3133EFQD2 3527 FEDERAL FARM CREDIT BANK 11/23/2015 1,000,000.00 999,600.00 1,000,000.00 1.080 1.065 1.080 22 05/23/2018
<br /> 3133EFRQ2 3529 FEDERAL FARM CREDIT BANK 12/03/2015 2,000,000.00 1,989,060.00 2,000,000.00 1.300 1.282 1.300 216 12/03/2018
<br /> 3133EFSH1 3530 FEDERAL FARM CREDIT BANK 12/18/2015 1,000,000.00 999,280.00 997,890.00 1.170 1.239 1.256 44 06/14/2018
<br /> 3133EFD87 3533 FEDERAL FARM CREDIT BANK 03/02/2016 2,000,000.00 1,997,240.00 1,995,620.00 0.875 0.958 0.971 55 06/25/2018
<br /> 3133EFWQ6 3544 FEDERAL FARM CREDIT BANK 11/10/2016 2,000,000.00 1,992,060.00 2,003,000.00 1.030 0.937 0.950 153 10/01/2018
<br /> 3133EGJ48 3546 FEDERAL FARM CREDIT BANK 11/16/2016 2,000,000.00 1,986,520.00 1,994,140.00 0.890 1.024 1.038 199 11/16/2018
<br /> 3133EFW52 3549 FEDERAL FARM CREDIT BANK 12/12/2016 1,500,000.00 1,478,820.00 1,491,735.00 1.150 1.352 1.370 426 07/01/2019
<br /> 3133EFX51 3551 FEDERAL FARM CREDIT BANK 12/13/2016 1,000,000.00 991,340.00 994,870.00 1.000 1.235 1.252 251 01/07/2019
<br /> 3133ECN59 3553 FEDERAL FARM CREDIT BANK 12/14/2016 1,000,000.00 988,090.00 993,410.00 1.080 1.343 1.362 365 05/01/2019
<br /> Portfolio PLST
<br /> CC
<br /> Run Date:05/14/2018-12:58
<br /> PM(PRF PM2)7.3.0
<br /> Report Ver.7.3.3
<br />
|