Laserfiche WebLink
CITY OF PLEASANTON <br /> Portfolio Management Page 2 <br /> Portfolio Details - Investments <br /> January 31, 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 /> Federal Agency Issues-Coupon <br /> 3133EG6C4 3569 FEDERAL FARM CREDIT BANK 02/10/2017 1,000,000 00 987,110.00 1,001,200.00 1.550 1 488 1 509 732 02/03/2020 <br /> 3133EA6M5 3571 FEDERAL FARM CREDIT BANK 02/13/2017 500,000.00 494,615 00 499,015.00 1 220 1 292 1.310 453 04/30/2019 <br /> 313382WY5 3517 FEDERAL HOME LOAN BANK 12/09/2014 500,000.00 496,290 00 489,690.00 1 000 1.519 1.540 293 11/21/2018 <br /> 313381GD1 3523 FEDERAL HOME LOAN BANK 11/04/2015 2,000,000 00 1,997,460.00 2,010,280.00 1.250 1 037 1 051 139 06/20/2018 <br /> 3130A6RC3 3524 FEDERAL HOME LOAN BANK 11/04/2015 2,000,000 00 1,988,880.00 2,000,000.00 1.150 1.134 1 150 274 11/02/2018 <br /> 313379EE5 3539 FEDERAL HOME LOAN BANK 08/22/2016 1,000,000 00 994,240.00 1,017,150 00 1.625 0.991 1 005 498 06/14/2019 <br /> 313380FB8 3543 FEDERAL HOME LOAN BANK 10/07/2016 2,000,000.00 1,975,400 00 2,015,820.00 1 375 1 085 1.100 589 09/13/2019 <br /> 3130A5K73 3547 FEDERAL HOME LOAN BANK 11/18/2016 2,000,000 00 1,992,440.00 2,004,800.00 1.200 1.054 1 069 237 09/26/2018 <br /> 3130AAE46 3550 FEDERAL HOME LOAN BANK 12/12/2016 2,000,000.00 1,986,740 00 2,000,460.00 1 250 1.222 1.239 349 01/16/2019 <br /> 313379EE5 3554 FEDERAL HOME LOAN BANK 12/15/2016 2,000,000 00 1,988,480 00 2,009,000.00 1 625 1 421 1 441 498 06/14/2019 <br /> 313383HU8 3555 FEDERAL HOME LOAN BANK 12/15/2016 2,000,000 00 1,976,320 00 2,003,040.00 1 750 1 682 1 705 862 06/12/2020 <br /> 313383MC2 3572 FEDERAL HOME LOAN BANK 12/20/2017 2,000,000 00 1,983,942.50 2,002,642 50 2.125 2.072 2 101 1,226 06/11/2021 <br /> 3130A57K9 4297 FEDERAL HOME LOAN BANK 05/04/2015 1,000,000 00 998,620.00 1,000,730 00 1 000 0.962 0 975 92 05/04/2018 <br /> 3134G3A91 3552 FREDDIE MAC 12/14/2016 2,000,000 00 1,977,180.00 1,998,000 00 1.400 1.418 1 438 567 08/22/2019 <br /> 3134G9GZ4 4355 FREDDIE MAC 05/25/2016 1,410,000.00 1,388,666 70 1,409,647.50 1 300 1.289 1.307 662 11/25/2019 <br /> 3136G1BE8 3538 FEDERAL NATIONAL MORTGAGE ASSN 08/08/2016 500,000 00 498,375.00 501,310.00 1.000 0.853 0 865 174 07/25/2018 <br /> 3136FTS67 3540 FEDERAL NATIONAL MORTGAGE ASSN 08/22/2016 1,000,000 00 996,940 00 1,018,640.00 1.700 0 935 0 948 391 02/27/2019 <br /> 3136G17C7 3541 FEDERAL NATIONAL MORTGAGE ASSN 08/29/2016 825,000.00 815,075 25 829,463.25 1 250 1 041 1 055 511 06/27/2019 <br /> 3136G0E23 3542 FEDERAL NATIONAL MORTGAGE ASSN 10/07/2016 500,000 00 494,955.00 505,520 00 1 500 1.105 1.120 600 09/24/2019 <br /> 3136G06Q9 3545 FEDERAL NATIONAL MORTGAGE ASSN 11/10/2016 1,010,000.00 1,002,960.30 1,011,545 30 1 050 0.961 0.974 298 11/26/2018 <br /> 3136G14U0 3556 FEDERAL NATIONAL MORTGAGE ASSN 12/15/2016 700,000.00 691,978 00 695,072.00 1 200 1 465 1.485 508 06/24/2019 <br /> 3135G0F73 3568 FEDERAL NATIONAL MORTGAGE ASSN 02/10/2017 1,000,000 00 978,270.00 993,100 00 1.500 1.665 1 688 1,033 11/30/2020 <br /> Subtotal and Average 45,485,740.55 45,445,000.00 45,122,992.75 45,485,740.55 1.225 1.242 415 <br /> Treasury Securities-Coupon <br /> 912828WW6 2350 U S TREASURY 12/15/2016 2,000,000 00 1,986,960 00 2,012,180.00 1.625 1 369 1 388 545 07/31/2019 <br /> 912828N22 2351 U S TREASURY 12/15/2016 1,000,000.00 994,450.00 1,000,000 00 1 250 1.233 1.250 317 12/15/2018 <br /> 912828XH8 2352 U S TREASURY 12/16/2016 2,000,000.00 1,971,880 00 1,990,764.00 1 625 1 736 1 760 880 06/30/2020 <br /> 912828XM7 2353 U S TREASURY 12/19/2017 2,000,000 00 1,970,240.00 1,986,500 00 1.625 1.864 1 890 911 07/31/2020 <br /> 912828L32 2354 U S TREASURY 12/19/2017 2,000,000.00 1,964,676.35 1,980,996.35 1 375 1.872 1.898 942 08/31/2020 <br /> Subtotal and Average 8,982,491.11 9,000,000.00 8,888,206.35 8,970,440.35 1.656 1.679 763 <br /> Federal Agency Issues-Callable <br /> 3133ECL44 4235 FEDERAL FARM CREDIT BANK 04/15/2013 1,900,000 00 1,898,176.00 1,899,050.00 1.000 0.996 1.010 69 04/11/2018 <br /> 3133ECMF8 4237 FEDERAL FARM CREDIT BANK 04/24/2013 2,000,000.00 1,997,700.00 1,997,500.00 0.980 0 992 1 006 82 04/24/2018 <br /> 3133EFGN1 4321 FEDERAL FARM CREDIT BANK 10/07/2015 1,000,000.00 993,310 00 1,000,000.00 1 200 1 184 1.200 340 01/07/2019 <br /> Portfolio PLST <br /> CC <br /> Run Date 02/20/2018-10 17 PM(PRF_PM2)7.3.0 <br />