14 - Laserfiche WebLink

CITY OF PLEASANTON Portfolio Management Page 2 Portfolio Details - Investments June 30, 2018 Average Purchase Stated YTM YTM Days to Maturity CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate 360 365 Maturity Date Federal Agency Issues-Coupon 313382WY5 3517 FEDERAL HOME LOAN BANK 12/09/2014 500,000.00 497,870.00 489,690.00 1.000 1.519 1.540 143 11/21/2018 3130A6RC3 3524 FEDERAL HOME LOAN BANK 11/04/2015 2,000,000.00 1,993,860.00 2,000,000.00 1.150 1.134 1.150 124 11/02/2018 313379EE5 3539 FEDERAL HOME LOAN BANK 08/22/2016 1,000,000.00 992,740.00 1,017,150.00 1.625 0.991 1.005 348 06/14/2019 313380FB8 3543 FEDERAL HOME LOAN BANK 10/07/2016 2,000,000.00 1,976,060.00 2,015,820.00 1.375 1.085 1.100 439 09/13/2019 3130A5K73 3547 FEDERAL HOME LOAN BANK 11/18/2016 2,000,000.00 1,996,100.00 2,004,800.00 1.200 1.054 1.069 87 09/26/2018 3130AAE46 3550 FEDERAL HOME LOAN BANK 12/12/2016 2,000,000.00 1,989,580.00 2,000,460.00 1.250 1.222 1.239 199 01/16/2019 313379EE5 3554 FEDERAL HOME LOAN BANK 12/15/2016 2,000,000.00 1,985,480.00 2,009,000.00 1.625 1.421 1.441 348 06/14/2019 313383HU8 3555 FEDERAL HOME LOAN BANK 12/15/2016 2,000,000.00 1,967,460.00 2,003,040.00 1.750 1.682 1.705 712 06/12/2020 313383MC2 3572 FEDERAL HOME LOAN BANK 12/20/2017 2,000,000.00 1,970,700.00 2,001,580.00 2.125 2.072 2.101 1,076 06/11/2021 3134G3A91 3552 FREDDIE MAC 12/14/2016 2,000,000.00 1,973,520.00 1,998,000.00 1.400 1.418 1.438 417 08/22/2019 3134G9GZ4 4355 FREDDIE MAC 05/25/2016 1,410,000.00 1,386,565.80 1,409,647.50 1.300 1.289 1.307 512 11/25/2019 3136G1BE8 3538 FEDERAL NATIONAL MORTGAGE ASSN 08/08/2016 500,000.00 499,710.00 501,310.00 1.000 0.853 0.865 24 07/25/2018 3136FTS67 3540 FEDERAL NATIONAL MORTGAGE ASSN 08/22/2016 1,000,000.00 996,000.00 1,018,640.00 1.700 0.935 0.948 241 02/27/2019 3136G17C7 3541 FEDERAL NATIONAL MORTGAGE ASSN 08/29/2016 825,000.00 815,298.00 829,463.25 1.250 1.041 1.055 361 06/27/2019 3136G0E23 3542 FEDERAL NATIONAL MORTGAGE ASSN 10/07/2016 500,000.00 494,250.00 505,520.00 1.500 1.105 1.120 450 09/24/2019 3136G06Q9 3545 FEDERAL NATIONAL MORTGAGE ASSN 11/10/2016 1,010,000.00 1,005,707.50 1,011,545.30 1.050 0.961 0.974 148 11/26/2018 3136G14U0 3556 FEDERAL NATIONAL MORTGAGE ASSN 12/15/2016 700,000.00 691,558.00 695,072.00 1.200 1.465 1.485 358 06/24/2019 3135G0F73 3568 FEDERAL NATIONAL MORTGAGE ASSN 02/10/2017 1,000,000.00 973,270.00 993,100.00 1.500 1.665 1.688 883 11/30/2020 Subtotal and Average 38,783,654.55 35,445,000.00 35,131,629.30 35,481,208.05 1.280 1.298 354 Treasury Securities-Coupon 912828WW6 2350 U S TREASURY 12/15/2016 2,000,000.00 1,983,600.00 2,012,180.00 1.625 1.369 1.388 395 07/31/2019 912828N22 2351 U S TREASURY 12/15/2016 1,000,000.00 996,090.00 1,000,000.00 1.250 1.233 1.250 167 12/15/2018 912828XH8 2352 U S TREASURY 12/16/2016 2,000,000.00 1,964,460.00 1,990,764.00 1.625 1.736 1.760 730 06/30/2020 912828XM7 2353 U S TREASURY 12/19/2017 2,000,000.00 1,962,340.00 1,986,500.00 1.625 1.864 1.890 761 07/31/2020 912828L32 2354 U S TREASURY 12/19/2017 2,000,000.00 1,950,320.00 1,972,640.00 1.375 1.872 1.898 792 08/31/2020 Subtotal and Average 8,962,084.00 9,000,000.00 8,856,810.00 8,962,084.00 1.656 1.679 612 Federal Agency Issues-Callable 3133EFGN1 4321 FEDERAL FARM CREDIT BANK 10/07/2015 1,000,000.00 994,190.00 1,000,000.00 1.200 1.184 1.200 190 01/07/2019 3133EFKY2 4329 FEDERAL FARM CREDIT BANK 10/30/2015 2,000,000.00 1,970,880.00 2,000,000.00 1.360 1.341 1.360 484 10/28/2019 3133EFV20 4351 FEDERAL FARM CREDIT BANK 04/21/2016 891,000.00 873,625.50 891,000.00 1.490 1.470 1.490 638 03/30/2020 3133EGBG9 4363 FEDERAL FARM CREDIT BANK 06/02/2016 1,000,000.00 998,650.00 998,000.00 1.000 1.076 1.091 53 08/23/2018 3133EGBG9 4364 FEDERAL FARM CREDIT BANK 06/03/2016 1,000,000.00 998,650.00 998,000.00 1.000 1.077 1.091 53 08/23/2018 3133EGWF8 4375 FEDERAL FARM CREDIT BANK 10/05/2016 2,000,000.00 1,967,500.00 1,998,200.00 1.170 1.184 1.201 459 10/03/2019 Portfolio PLST Run Date:07/24/2018-15:01 CC PM(PRF_PM2)7 3 0