12 - Laserfiche WebLink

CITY OF PLEASANTON Portfolio Management Page 2 Portfolio Details - Investments June 30, 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 Medium Term Notes 94988J5N3 6043 Wells Fargo Bank 02/28/2019 2,000,000.00 2,014,371.11 1,994,520.93 2.600 2.881 2.921 564 01/15/2021 94988J5L7 6019 Wells Fargo Bank NA 06/21/2018 2,000,000.00 2,000,600.00 1,984,470.80 2.400 2.869 2.909 198 01/15/2020 Subtotal and Average 41,981,829.93 42,315,000.00 42,696,383.98 41,981,829.93 2.729 2.767 791 Federal Agency Issues-Coupon 3133EFW52 3549 FEDERAL FARM CREDIT BANK 12/12/2016 1,500,000.00 1,500,000.00 1,491,735.00 1.150 1.352 1.370 0 07/01/2019 3133EG6C4 3569 FEDERAL FARM CREDIT BANK 02/10/2017 1,000,000.00 997,430.00 1,001,200.00 1.550 1.488 1.509 217 02/03/2020 3133EKGC4 3574 FEDERAL FARM CREDIT BANK 04/17/2019 2,000,000.00 2,027,040.00 1,988,640.00 2.250 2.388 2.421 1,374 04/05/2023 313380FB8 3543 FEDERAL HOME LOAN BANK 10/07/2016 2,000,000.00 1,996,620.00 2,015,820.00 1.375 1.085 1.100 74 09/13/2019 313383HU8 3555 FEDERAL HOME LOAN BANK 12/15/2016 2,000,000.00 1,994,960.00 2,003,040.00 1.750 1.682 1.705 347 06/12/2020 313383MC2 3572 FEDERAL HOME LOAN BANK 12/20/2017 2,000,000.00 2,010,600.00 2,001,580.00 2.125 2.072 2.101 711 06/11/2021 3134G3A91 3552 FREDDIE MAC 12/14/2016 2,000,000.00 1,997,560.00 1,998,000.00 1.400 1.418 1.438 52 08/22/2019 3134G9GZ4 4355 FREDDIE MAC 05/25/2016 1,410,000.00 1,405,079.10 1,409,647.50 1.300 1.289 1.307 147 11/25/2019 3136G0E23 3542 FEDERAL NATIONAL MORTGAGE ASSN 10/07/2016 500,000.00 499,175.00 505,520.00 1.500 1.105 1.120 85 09/24/2019 3135G0F73 3568 FEDERAL NATIONAL MORTGAGE ASSN 02/10/2017 1.000,000.00 995,100.00 993,100.00 1.500 1.665 1.688 518 11/30/2020 Subtotal and Average 17,971,370.85 15,410,000.00 15,423,564.10 15,408,282.50 1.611 1.633 395 Treasury Securities-Coupon 912828VWV6 2350 U S TREASURY 12/15/2016 2,000,000.00 1,998,960.00 2,012,180.00 1.625 1.369 1.388 30 07/31/2019 912828XH8 2352 U S TREASURY 12/16/2016 2,000,000.00 1,993,440.00 1,990,764.00 1.625 1.736 1.760 365 06/30/2020 912828XM7 2353 U S TREASURY 12/19/2017 2,000,000.00 1,993,360.00 1,986,500.00 1.625 1.864 1.890 396 07/31/2020 912828L32 2354 U S TREASURY 12/19/2017 2,000,000.00 1,987,660.00 1,972,640.00 1.375 1.872 1.898 427 08/31/2020 912828L65 2355 U S TREASURY 02/27/2019 2,000,000.00 1,987,180.00 1,965,172.32 1.375 2.092 2.121 457 09/30/2020 912828XE5 2356 U S TREASURY 02/27/2019 2,000.000.00 1,990,780.00 1,975,895.06 1.500 2.446 2.480 335 05/31/2020 Subtotal and Average 11,903,151.38 12,000,000.00 11,961,380.00 11,903,151.38 1.894 1.921 334 Federal Agency Issues-Callable 3133EFKY2 4329 FEDERAL FARM CREDIT BANK 10/30/2015 2,000,000.00 1,993,980.00 2,000,000.00 1.360 1.341 1.360 119 10/28/2019 3133EFV20 4351 FEDERAL FARM CREDIT BANK 04/21/2016 891,000.00 886,108.41 891,000.00 1.490 1.470 1.490 273 03/30/2020 3133EGWF8 4375 FEDERAL FARM CREDIT BANK 10/05/2016 2,000,000.00 1,996,080.00 1,998,200.00 1.170 1.184 1.201 94 10/03/2019 3133EHGG2 4386 FEDERAL FARM CREDIT BANK 04/26/2017 2,000,000.00 1,991,900.00 1,998,000.00 1.930 1.929 1.956 659 04/20/2021 3133EHGG2 4388 FEDERAL FARM CREDIT BANK 04/26/2017 2,000,000.00 1,991,900.00 1,996,700.00 1.930 1.946 1.973 659 04/20/2021 3133EHHA4 4391 FEDERAL FARM CREDIT BANK 06/08/2017 1,475,000.00 1,470,766.75 1,474,115.00 1.620 1.619 1.641 301 04/27/2020 3133EHQM8 4392 FEDERAL FARM CREDIT BANK 07/05/2017 2,000,000.00 2,000,020.00 1,995,300.00 1.950 1.981 2.008 827 10/05/2021 3133EHPV9 4393 FEDERAL FARM CREDIT BANK 07/06/2017 1,000,000.00 998,460.00 997,600.00 1.730 1.777 1.801 547 12/29/2020 3133EGMM4 4394 FEDERAL FARM CREDIT BANK 09/14/2017 1,000,000.00 993,040.00 992,500.00 1.375 1.602 1.624 476 10/19/2020 Portfolio PLST CC Run Date:08/01/2019-10:10 PM(PRF_PM2)7.3.0