Laserfiche WebLink
CITY OF PLEASANTON <br />Portfolio Management <br />Portfolio Details -Investments <br />July 31, 2019 <br />Page 3 <br />Average <br />Purchase <br />Stated <br />YTM <br />YTM <br />Days to Maturity <br />CUSIP <br />Investment # <br />Issuer Balance <br />Date <br />Par Value <br />Market Value <br />Book Value <br />Rate <br />360 <br />365 Maturity Date <br />Federal Agency Issues -Callable <br />3133EHXM0 <br />4395 <br />FEDERAL FARM CREDIT BANK <br />10/04/2017 <br />2,000,000.00 <br />1,986,260.00 <br />1,990,460.00 <br />1.930 <br />2.022 <br />2.050 <br />858 12/06/2021 <br />3133EHD83 <br />4396 <br />FEDERAL FARM CREDIT BANK <br />10/05/2017 <br />2,000,000.00 <br />1,989,000.00 <br />2,000,000.00 <br />2.000 <br />1.973 <br />2.000 <br />796 10/05/2021 <br />3133EHS20 <br />4397 <br />FEDERAL FARM CREDIT BANK <br />11/21/2017 <br />2,000,000.00 <br />1,990,460.00 <br />1,996,200.00 <br />2.090 <br />2.111 <br />2.140 <br />837 11/15/2021 <br />3133EHS20 <br />4398 <br />FEDERAL FARM CREDIT BANK <br />11/30/2017 <br />2,000,000.00 <br />1,990,460.00 <br />1,993,000.00 <br />2.090 <br />2.153 <br />2.183 <br />837 11/15/2021 <br />3133EGEW1 <br />4407 <br />FEDERAL FARM CREDIT BANK <br />06/21/2018 <br />1,000,000.00 <br />995,010.00 <br />966,750.00 <br />1.730 <br />2.776 <br />2.814 <br />774 09/13/2021 <br />3133EGKA2 <br />4408 <br />FEDERAL FARM CREDIT BANK <br />07/11/2018 <br />2,000,000.00 <br />1,978,880.00 <br />1,924,560.00 <br />1.500 <br />2.787 <br />2.826 <br />705 07/06/2021 <br />3133EGAZ8 <br />4409 <br />FEDERAL FARM CREDIT BANK <br />07/11/2018 <br />1,000,000.00 <br />993,900.00 <br />969,750.00 <br />1.580 <br />2.756 <br />2.794 <br />566 02/17/2021 <br />3133EGEE1 <br />4416 <br />FEDERAL FARM CREDIT BANK <br />12/18/2018 <br />3,000,000.00 <br />2,977,680.00 <br />2,878,553.40 <br />1.980 <br />2.910 <br />2.950 <br />1,412 06/13/2023 <br />3133EF026 <br />4418 <br />FEDERAL FARM CREDIT BANK <br />12/18/2018 <br />1,500,000.00 <br />1,492,740.00 <br />1,460,707.27 <br />2.150 <br />2.850 <br />2.890 <br />1,147 09/21/2022 <br />3133EHJP9 <br />4420 <br />FEDERAL FARM CREDIT BANK <br />12/18/2018 <br />2,500,000.00 <br />2,500,000.00 <br />2,453,032.85 <br />2.000 <br />2.772 <br />2.810 <br />655 05/17/2021 <br />3133EKPA8 <br />4444 <br />FEDERAL FARM CREDIT BANK <br />06/05/2019 <br />3,000,000.00 <br />3,000,060.00 <br />2,997,750.00 <br />2.570 <br />2.557 <br />2.593 <br />1,222 12/05/2022 <br />3133EKOW9 <br />4446 <br />FEDERAL FARM CREDIT BANK <br />06/17/2019 <br />2,000,000.00 <br />2,000,000.00 <br />2,000,000.00 <br />2.360 <br />2.328 <br />2.360 <br />1,782 06/17/2024 <br />3133EKRJ7 <br />4457 <br />FEDERAL FARM CREDIT BANK <br />06/19/2019 <br />2,000,000.00 <br />2,002,180.00 <br />2,000,000.00 <br />2.400 <br />2.367 <br />2.400 <br />1,418 06/19/2023 <br />3133EKRP3 <br />4458 <br />FEDERAL FARM CREDIT BANK <br />06/21/2019 <br />3,000,000.00 <br />2,996,040.00 <br />3,000,000.00 <br />2.220 <br />2.190 <br />2.220 <br />1,786 06/21/2024 <br />3130A6NA1 <br />4327 <br />FEDERAL HOME LOAN BANK <br />10/29/2015 <br />770,000.00 <br />768,552.40 <br />770,000.00 <br />1.400 <br />1.381 <br />1.400 <br />89 10/29/2019 <br />3130A87M9 <br />4365 <br />FEDERAL HOME LOAN BANK <br />06/06/2016 <br />2,000,000.00 <br />1,989,500.00 <br />2,000,000.00 <br />1.470 <br />1.450 <br />1.470 <br />215 03/03/2020 <br />3130AC6P4 <br />4419 <br />FEDERAL HOME LOAN BANK <br />12/18/2018 <br />1,000,000.00 <br />1,000,040.00 <br />974,435.92 <br />2.160 <br />2.860 <br />2.900 <br />1,112 08/17/2022 <br />3130AFSZ1 <br />4426 <br />FEDERAL HOME LOAN BANK <br />02/05/2019 <br />820,000.00 <br />822,091.00 <br />819,590.00 <br />3.000 <br />2.970 <br />3.011 <br />1,649 02/05/2024 <br />3130AGDU6 <br />4437 <br />FEDERAL HOME LOAN BANK <br />05/08/2019 <br />2,000,000.00 <br />2,001,540.00 <br />1,997,000.00 <br />2.730 <br />2.724 <br />2.762 <br />1,742 05/08/2024 <br />3130AGLR4 <br />4447 <br />FEDERAL HOME LOAN BANK <br />06/19/2019 <br />2,000,000.00 <br />2,000,340.00 <br />2,000,000.00 <br />2.280 <br />2.249 <br />2.280 <br />1,418 06/19/2023 <br />3130AGMS1 <br />4459 <br />FEDERAL HOME LOAN BANK <br />06/26/2019 <br />1,945,000.00 <br />1,942,315.90 <br />1,945,000.00 <br />2.370 <br />2.338 <br />2.370 <br />1,791 06/26/2024 <br />3134GSRX9 <br />4346 <br />FREDDIE MAC <br />03/30/2016 <br />1,000,000.00 <br />998,770.00 <br />1,000,000.00 <br />1.400 <br />1.381 <br />1.400 <br />60 09/30/2019 <br />313408S83 <br />4348 <br />FREDDIE MAC <br />03/30/2016 <br />1,700,000.00 <br />1,695,699.00 <br />1,700,000.00 <br />1.500 <br />1.480 <br />1.500 <br />151 12/30/2019 <br />313409RY5 <br />4362 <br />FREDDIE MAC <br />06/13/2016 <br />2,000,000.00 <br />1,994,620.00 <br />2,000,000.00 <br />1.375 <br />1.356 <br />1.375 <br />134 12/13/2019 <br />3134GABK9 <br />4372 <br />FREDDIE MAC <br />08/30/2016 <br />2,000,000.00 <br />1,998,520.00 <br />2,000,000.00 <br />1.160 <br />1.144 <br />1.160 <br />27 08/28/2019 <br />3134GBL03 <br />4385 <br />FREDDIE MAC <br />05/22/2017 <br />1,000,000.00 <br />996,340.00 <br />1,000,000.00 <br />1.650 <br />1.627 <br />1.650 <br />295 05/22/2020 <br />33134GBH08 <br />4387 <br />FREDDIE MAC <br />04/27/2017 <br />1,000,000.00 <br />996,310.00 <br />1,000,000.00 <br />1.700 <br />1.680 <br />1.703 <br />361 07/27/2020 <br />3134GBHC9 <br />4389 <br />FREDDIE MAC <br />05/15/2017 <br />2,000,000.00 <br />1,994,440.00 <br />1,999,300.00 <br />1.850 <br />1.835 <br />1.860 <br />453 10/27/2020 <br />3134GBW32 <br />4404 <br />FREDDIE MAC <br />04/30/2018 <br />2,000,000.00 <br />1,997,760.00 <br />1,966,562.00 <br />2.000 <br />2.644 <br />2.681 <br />477 11/20/2020 <br />3134GBYE6 <br />4405 <br />FREDDIE MAC <br />04/30/2018 <br />500,000.00 <br />498,260.00 <br />488,860.00 <br />1.750 <br />2.644 <br />2.680 <br />453 10/27/2020 <br />3134GTCP6 <br />4429 <br />FREDDIE MAC <br />04/17/2019 <br />2,000,000.00 <br />2,001,820.00 <br />1,998,000.00 <br />2.625 <br />2.619 <br />2.655 <br />1,173 10/17/2022 <br />3134GTEF6 <br />4431 <br />FREDDIE MAC <br />04/25/2019 <br />2,000,000.00 <br />2,001,960.00 <br />2,000,000.00 <br />2.750 <br />2.712 <br />2.750 <br />1,363 04/25/2023 <br />3134GTDL4 <br />4432 <br />FREDDIE MAC <br />04/12/2019 <br />2,000,000.00 <br />2,005,845.56 <br />2,000,305.56 <br />2.750 <br />2.712 <br />2.750 <br />1,714 04/10/2024 <br />3134GTDW0 <br />4434 <br />FREDDIE MAC <br />04/30/2019 <br />1,940,000.00 <br />1,946,499.00 <br />1,938,545.00 <br />2.750 <br />2.728 <br />2.766 <br />1,734 04/30/2024 <br />3134GTC04 <br />4435 <br />FREDDIE MAC <br />05/03/2019 <br />2,000,000.00 <br />2,005,830.00 <br />1,999,450.00 <br />2.700 <br />2.674 <br />2.711 <br />1,734 04/30/2024 <br />3134GTLSO <br />4438 <br />FREDDIE MAC <br />05/14/2019 <br />2,000,000.00 <br />2,013,020.00 <br />2,000,000.00 <br />2.560 <br />2.525 <br />2.560 <br />1,748 05/14/2024 <br />Portfolio PLST <br />CC <br />Run Date. 09/0312019 - 11'43 <br />PM (PRF_PM2) 7.3.0 <br />