05 - Laserfiche WebLink

CITY OF PLEASANTON Portfolio Management Page 2 Portfolio Details - Investments March 31, 2019 Average Purchase Stated YTM YTM Days to Maturity CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate 360 365 Maturity Date Subtotal and Average 38,008,607.43 38,315,000.00 38,292,649.56 38,007,010.66 2.736 2.774 811 Federal Agency Issues-Coupon 3133EFW52 3549 FEDERAL FARM CREDIT BANK 12/12/2016 1,500,000.00 1,495,530.00 1,491,735.00 1.150 1.352 1.370 91 07/01/2019 3133ECN59 3553 FEDERAL FARM CREDIT BANK 12/14/2016 1,000,000.00 998,860.00 993,410.00 1.080 1.343 1.362 30 05/01/2019 3133EG6C4 3569 FEDERAL FARM CREDIT BANK 02/10/2017 1,000,000.00 993,090.00 1,001,200.00 1.550 1.488 1.509 308 02/03/2020 3133EA6M5 3571 FEDERAL FARM CREDIT BANK 02/13/2017 500,000.00 499,540.00 499,015.00 1.220 1.292 1.310 29 04/30/2019 313379EE5 3539 FEDERAL HOME LOAN BANK 08/22/2016 1,000,000.00 998,420.00 1,017,150.00 1.625 0.991 1.005 74 06/14/2019 313380FB8 3543 FEDERAL HOME LOAN BANK 10/07/2016 2,000,000.00 1.990,240.00 2,015,820.00 1.375 1.085 1.100 165 09/13/2019 313379EE5 3554 FEDERAL HOME LOAN BANK 12/15/2016 2,000,000.00 1,996,840.00 2,009,000.00 1.625 1.421 1.441 74 06/14/2019 313383HU8 3555 FEDERAL HOME LOAN BANK 12/15/2016 2,000,000.00 1,983,780.00 2,003,040.00 1.750 1.682 1.705 438 06/12/2020 313383MC2 3572 FEDERAL HOME LOAN BANK 12/20/2017 2,000,000.00 1,989,560.00 2,001,580.00 2.125 2.072 2.101 802 06/11/2021 3134G3A91 3552 FREDDIE MAC 12/14/2016 2,000,000.00 1,992,000.00 1,998,000.00 1.400 1.418 1.438 143 08/22/2019 3134G9GZ4 4355 FREDDIE MAC 05/25/2016 1,410,000.00 1,399,608.30 1,409,647.50 1.300 1.289 1.307 238 11/25/2019 3136G17C7 3541 FEDERAL NATIONAL MORTGAGE ASSN 08/29/2016 825,000.00 822,599.25 829,463.25 1.250 1.041 1.055 87 06/27/2019 3136G0E23 3542 FEDERAL NATIONAL MORTGAGE ASSN 10/07/2016 500,000.00 497,690.00 505,520.00 1.500 1.105 1.120 176 09/24/2019 3136G14U0 3556 FEDERAL NATIONAL MORTGAGE ASSN 12/15/2016 700,000.00 697,956.00 695,072.00 1.200 1.465 1.485 84 06/24/2019 3135G0F73 3568 FEDERAL NATIONAL MORTGAGE ASSN 02/10/2017 1,000,000.00 985,750.00 993,100.00 1.500 1.665 1.688 609 11/30/2020 Subtotal and Average 19,462,752.75 19,435,000.00 19,341,463.55 19,462,752.75 1.428 1.448 266 Treasury Securities-Coupon 912828VWV6 2350 U S TREASURY 12/15/2016 2,000,000.00 1,994,220.00 2,012,180.00 1.625 1.369 1.388 121 07/31/2019 912828XH8 2352 U S TREASURY 12/16/2016 2,000,000.00 1,980,940.00 1,990,764.00 1.625 1.736 1.760 456 06/30/2020 912828XM7 2353 U S TREASURY 12/19/2017 2,000,000.00 1,979,920.00 1,986,500.00 1.625 1.864 1.890 487 07/31/2020 912828L32 2354 U S TREASURY 12/19/2017 2,000,000.00 1,971,880.00 1,972,640.00 1.375 1.872 1.898 518 08/31/2020 912828L65 2355 U S TREASURY 02/27/2019 2,000,000.00 1,970,940.00 1,965,172.32 1.375 2.092 2.121 548 09/30/2020 912828XE5 2356 U S TREASURY 02/27/2019 2,000,000.00 1,986,555.16 1,983,230.22 1.500 2.446 2.480 426 05/31/2020 Subtotal and Average 11,910,486.54 12,000,000.00 11,884,455.16 11,910,486.54 1.895 1.921 425 Federal Agency Issues-Callable 3133EFKY2 4329 FEDERAL FARM CREDIT BANK 10/30/2015 2,000,000.00 1,988,720.00 2,000,000.00 1.360 1.341 1.360 210 10/28/2019 3133EFV20 4351 FEDERAL FARM CREDIT BANK 04/21/2016 891,000.00 882,482.04 891,000.00 1.490 1.470 1.490 364 03/30/2020 3133EGWF8 4375 FEDERAL FARM CREDIT BANK 10/05/2016 2,000,000.00 1,988,260.00 1,998,200.00 1.170 1.184 1.201 185 10/03/2019 3133EHGG2 4386 FEDERAL FARM CREDIT BANK 04/26/2017 2,000,000.00 1,983,060.00 1,998,000.00 1.930 1.929 1.956 750 04/20/2021 3133EHGG2 4388 FEDERAL FARM CREDIT BANK 04/26/2017 2,000,000.00 1,983,060.00 1,996,700.00 1.930 1.946 1.973 750 04/20/2021 3133EHHA4 4391 FEDERAL FARM CREDIT BANK 06/08/2017 1,475,000.00 1,463,539.25 1,474,115.00 1.620 1.619 1.641 392 04/27/2020 3133EHQM8 4392 FEDERAL FARM CREDIT BANK 07/05/2017 2,000,000.00 1,981,380.00 1,995,300.00 1.950 1.981 2.008 918 10/05/2021 Portfolio PLST CC Run Date.05/13/2019-09:09 PM(PRF_PM2)7.3.0