Laserfiche WebLink
CITY OF PLEASANTON <br />Portfolio Management <br />Portfolio Details -Investments <br />July 31, 2019 <br />Page 2 <br />Federal Agency Issues -Coupon <br />3133EG6C4 <br />3569 <br />Average Purchase <br />02/10/2017 <br />3133EKGC4 <br />3574 <br />Stated <br />YTM <br />YTM <br />Days to Maturity <br />CUSIP <br />Investment # Issuer <br />Balance Date <br />Par Value <br />Market Value <br />Book Value <br />Rate <br />360 <br />365 Maturity Date <br />Medium Term Notes <br />3134G3A91 <br />3552 <br />FREDDIE MAC <br />12/14/2016 <br />3134G9GZ4 <br />4355 <br />FREDDIE MAC <br />05/25/2016 <br />3136GOE23 <br />94988J5N3 <br />6033 Wells Fargo Bank <br />12/21/2018 <br />2,000,000.00 <br />2,007,100.00 <br />1,974,193.46 <br />2.600 <br />3.205 <br />3.250 <br />533 01/15/2021 <br />94988J5N3 <br />6043 Wells Fargo Bank <br />02/28/2019 <br />2,000,000.00 <br />2,007,100.00 <br />1,988,309.82 <br />2.600 <br />2.881 <br />2.921 <br />533 01/15/2021 <br />94988J5L7 <br />6019 Wells Fargo Bank NA <br />06/21/2018 <br />2,000,000.00 <br />1,999,960.00 <br />1,984,470.80 <br />2.400 <br />2.869 <br />2.909 <br />167 01/15/2020 <br />912828XE5 <br />Subtotal and Average <br />41,977,995.61 <br />42,315,000.00 <br />42,623,222.32 <br />41,971,193.82 <br />993,010.00 <br />2.729 <br />2.767 <br />760 <br />Federal Agency Issues -Coupon <br />3133EG6C4 <br />3569 <br />FEDERAL FARM CREDIT BANK <br />02/10/2017 <br />3133EKGC4 <br />3574 <br />FEDERAL FARM CREDIT BANK <br />04/17/2019 <br />313380F68 <br />3543 <br />FEDERAL HOME LOAN BANK <br />10/07/2016 <br />313383HU8 <br />3555 <br />FEDERAL HOME LOAN BANK <br />1 211 5/2 0 1 6 <br />313383MC2 <br />3572 <br />FEDERAL HOME LOAN BANK <br />12/20/2017 <br />3134G3A91 <br />3552 <br />FREDDIE MAC <br />12/14/2016 <br />3134G9GZ4 <br />4355 <br />FREDDIE MAC <br />05/25/2016 <br />3136GOE23 <br />3542 <br />FEDERAL NATIONAL MORTGAGE ASSN <br />10/07/2016 <br />3135GOF73 <br />3568 <br />FEDERAL NATIONAL MORTGAGE ASSN <br />02/10/2017 <br />2.072 <br />2.101 <br />Subtotal and Average 13,916,547.60 <br />06/11/2021 <br />Treasury Securities -Coupon <br />1,999,140.00 <br />1,998,000.00 <br />912828XH8 <br />2352 <br />U S TREASURY <br />12/16/2016 <br />912828XM7 <br />2353 <br />U S TREASURY <br />12/19/2017 <br />912828L32 <br />2354 <br />U S TREASURY <br />12/19/2017 <br />912828L65 <br />2355 <br />U S TREASURY <br />02/27/2019 <br />912828XE5 <br />2356 <br />U S TREASURY <br />02/27/2019 <br />Subtotal and Average 11,838,242.35 <br />Federal Agency Issues -Callable <br />3133EFKY2 <br />4329 <br />FEDERAL FARM CREDIT BANK <br />3133EFV20 <br />4351 <br />FEDERAL FARM CREDIT BANK <br />3133EGWF8 <br />4375 <br />FEDERAL FARM CREDIT BANK <br />3133EHGG2 <br />4386 <br />FEDERAL FARM CREDIT BANK <br />3133EHGG2 <br />4388 <br />FEDERAL FARM CREDIT BANK <br />3133EHHA4 <br />4391 <br />FEDERAL FARM CREDIT BANK <br />3133EHOM8 <br />4392 <br />FEDERAL FARM CREDIT BANK <br />3133EHPV9 <br />4393 <br />FEDERAL FARM CREDIT BANK <br />3133EGMM4 <br />4394 <br />FEDERAL FARM CREDIT BANK <br />Run Date. 09/03/2019 - 11 43 <br />1,000,000.00 <br />997,450.00 <br />1,001,200.00 <br />1.550 <br />1.488 <br />1.509 <br />186 <br />02103/2020 <br />2,000,000.00 <br />2,024,720.00 <br />1,988,640.00 <br />2.250 <br />2.388 <br />2.421 <br />1,343 <br />04/05/2023 <br />2,000,000.00 <br />1,998,060.00 <br />2,015,820.00 <br />1.375 <br />1.085 <br />1.100 <br />43 <br />09/13/2019 <br />2,000,000.00 <br />1,995,320.00 <br />2,003,040.00 <br />1.750 <br />1.682 <br />1.705 <br />316 <br />06/12/2020 <br />2,000,000.00 <br />2,007,060.00 <br />2,001,580.00 <br />2.125 <br />2.072 <br />2.101 <br />680 <br />06/11/2021 <br />2,000,000.00 <br />1,999,140.00 <br />1,998,000.00 <br />1.400 <br />1.418 <br />1.438 <br />21 <br />08/22/2019 <br />1,410,000.00 <br />1,406, 362.20 <br />1,409,647.50 <br />1.300 <br />1.289 <br />1.307 <br />116 <br />11 /25/2019 <br />500,000.00 <br />499,535.00 <br />505,520.00 <br />1.500 <br />1.105 <br />1.120 <br />54 <br />09/24/2019 <br />1,000,000.00 <br />993,010.00 <br />993,100.00 <br />1.500 <br />1.665 <br />1.688 <br />487 <br />11/30/2020 <br />13,910,000.00 <br />13,920,667.20 <br />13,916,547.60 <br />992,500.00 <br />1.639 <br />1.661 <br />406 <br />445 <br />2,000,000.00 <br />1,991,640.00 <br />1,990,764.00 <br />1.625 <br />1.736 <br />1.760 <br />334 <br />06/30/2020 <br />2,000,000.00 <br />1,991,260.00 <br />1,986,500.00 <br />1.625 <br />1.864 <br />1.890 <br />365 <br />07/31/2020 <br />2,000,000.00 <br />1,985,620.00 <br />1,972,640.00 <br />1.375 <br />1.872 <br />1.898 <br />396 <br />08/31/2020 <br />2,000,000.00 <br />1,984,920.00 <br />1,965,172.32 <br />1.375 <br />2.092 <br />2.121 <br />426 <br />09/30/2020 <br />2,000,000.00 <br />1,990,000.00 <br />1,975,895.06 <br />1.500 <br />2.446 <br />2.480 <br />304 <br />05/31/2020 <br />10,000,000.00 <br />9,943,440.00 <br />9,890,971.38 <br />2.001 <br />2.029 <br />366 <br />10/30/2015 <br />2,000,000.00 <br />1,995,480.00 <br />2,000,000.00 <br />1.360 <br />1.341 <br />1.360 <br />88 <br />10/28/2019 <br />04/21/2016 <br />891,000.00 <br />886,215.33 <br />891,000.00 <br />1.490 <br />1.470 <br />1.490 <br />242 <br />03/30/2020 <br />10/05/2016 <br />2,000,000.00 <br />1,996,680.00 <br />1,998,200.00 <br />1.170 <br />1.184 <br />1.201 <br />63 <br />10/03/2019 <br />04/26/2017 <br />2,000,000.00 <br />1,991,260.00 <br />1,998,000.00 <br />1.930 <br />1.929 <br />1.956 <br />628 <br />04120/2021 <br />04/26/2017 <br />2,000,000.00 <br />1,991,260.00 <br />1,996,700.00 <br />1.930 <br />1.946 <br />1.973 <br />628 <br />04120/2021 <br />06/08/2017 <br />1,475,000.00 <br />1,470,442.25 <br />1,474,115.00 <br />1.620 <br />1.619 <br />1.641 <br />270 <br />04/27/2020 <br />07/05/2017 <br />2,000,000.00 <br />1,999,020.00 <br />1,995,300.00 <br />1.950 <br />1.981 <br />2.008 <br />796 <br />10/05/2021 <br />07/06/2017 <br />1,000,000.00 <br />996,400.00 <br />997,600.00 <br />1.730 <br />1.777 <br />1.801 <br />516 <br />12!29/2020 <br />09/14/2017 <br />1,000,000.00 <br />990,720.00 <br />992,500.00 <br />1.375 <br />1.602 <br />1.624 <br />445 <br />10/19/2020 <br />Portfolio PLST <br />CC <br />PM (PRF_PM2) 7.3.0 <br />