Laserfiche WebLink
CITY OF PLEASANTON <br /> Portfolio Management Page 1 <br /> Portfolio Details - Investments <br /> August 31, 2017 <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 /> 14042RBF7 1061 Capital One Bank NA 10/28/2015 245,000.00 244,989.81 245,000.00 1 200 1.184 1.200 59 10/30/2017 <br /> SYS 1068 East West Bank 07/29/2017 246,497 91 246,497.91 246,497 91 0.595 0.587 0.595 330 07/28/2018 <br /> SYS1068 1066 Fremont Bank 10/21/2016 245,000.00 245,000.00 245,000.00 0.500 0.493 0.500 50 10/21/2017 <br /> SYS1087 1067 Heritage Bank of Commerce 10/21/2016 245,000.00 245,000 00 245,000.00 0.500 0.493 0.500 50 10/21/2017 <br /> SYS1084 1084 Valley Community Bank 04/11/2016 245,000.00 245,000.00 245,000.00 0.650 0.641 0.650 222 04/11/2018 <br /> Subtotal and Average 1,226,497.91 1,226,497.91 1,226,487.72 1,226,497.91 0.679 0.689 142 <br /> LAIF <br /> SYS5 5 LOCAL AGENCY INVESTMENT FUND 30,000,000 00 30,000,000.00 30,000,000.00 0 920 0.907 0.920 1 <br /> Subtotal and Average 30,000,000.00 30,000,000.00 30,000,000.00 30,000,000.00 0.907 0.920 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 8007 Apple Inc. 04/08/2015 2,000,000 00 1,995,100.00 1,993,360.00 1 000 1.095 1 110 244 05/03/2018 <br /> 037833CQ1 6014 Apple Inc. 07/05/2017 1,000,000.00 1,012,010 00 1,005,600.00 2.300 2 222 2.253 1,713 05/11/2022 <br /> 594918BN3 6009 Microsoft Corp 08/08/2016 2,000,000.00 1,985,760.00 1,998,240 00 1 100 1.114 1.130 706 08/08/2019 <br /> 594918BV5 6011 Microsoft Corp 04/27/2017 2,000,000 00 2,012,220.00 2,010,780 00 1.850 1 628 1.650 888 02/06/2020 <br /> Subtotal and Average 7,009,591.29 7,000,000.00 7,005,090.00 7,007,980.00 1.415 1.435 771 <br /> Federal Agency Issues-Coupon <br /> 3133EE2W9 3521 FEDERAL FARM CREDIT BANK 07/01/2015 1,000,000 00 999,870.00 998,950.00 1.050 1.075 1 090 181 03/01/2018 <br /> 3133EFQD2 3527 FEDERAL FARM CREDIT BANK 11/23/2015 1,000,000.00 998,880.00 1,000,000.00 1 080 1.065 1 080 264 05/23/2018 <br /> 3133EFRQ2 3529 FEDERAL FARM CREDIT BANK 12/03/2015 2,000,000.00 1,999,820 00 2,000,000.00 1.300 1 282 1.300 458 12/03/2018 <br /> 3133EFSH1 3530 FEDERAL FARM CREDIT BANK 12/18/2015 1,000,000.00 999,750 00 997,890 00 1.170 1 239 1.256 286 06/14/2018 <br /> 3133EFD87 3533 FEDERAL FARM CREDIT BANK 03/02/2016 2,000,000.00 1,994,140.00 1,995,620.00 0.875 0.958 0 971 297 06/25/2018 <br /> 3133EFN78 3534 FEDERAL FARM CREDIT BANK 03/21/2016 2,000,000 00 1,999,920.00 2,000,000.00 0 900 0.888 0.900 20 09/21/2017 <br /> 3133EFWQ6 3544 FEDERAL FARM CREDIT BANK 11/10/2016 2,000,000.00 1,995,700.00 2,003,000.00 1.030 0.937 0.950 395 10/01/2018 <br /> 3133EGJ48 3546 FEDERAL FARM CREDIT BANK 11/16/2016 2,000,000.00 1,990,060.00 1,994,140.00 0.890 1.024 1.038 441 11/18/2018 <br /> 3133EGS48 3548 FEDERAL FARM CREDIT BANK 12/06/2016 2,000,000.00 1,999,420.00 2,000,000 00 1.000 0.971 0.985 186 03/06/2018 <br /> 3133EFW52 3549 FEDERAL FARM CREDIT BANK 12/12/2016 1,500,000.00 1,492,980.00 1,491,735.00 1.150 1.352 1 370 668 07/01/2019 <br /> 3133EFX51 3551 FEDERAL FARM CREDIT BANK 12/13/2016 1,000,000.00 995,120.00 994,870.00 1.000 1.235 1 252 493 01/07/2019 <br /> Portfolio PLST <br /> CC <br /> Run Date 10/09/2017-10 41 PM(PRF_PM2)7 3 0 <br /> Report Ver 7 3 3 <br />