|
CITY OF PLEASANTON
<br />Portfolio Management
<br />Portfolio Details -Investments
<br />August 31, 2019
<br />Page 2
<br />Federal Agency Issues -Coupon
<br />3133EFKY2
<br />Average Purchase
<br />3133EG6C4
<br />3569
<br />FEDERAL FARM CREDIT BANK
<br />Stated
<br />YTM
<br />YTM 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 />366 Maturity Data
<br />Medium Term Notes
<br />313383MC2
<br />3572
<br />FEDERAL HOME LOAN BANK
<br />12/20/2017
<br />3134G9GZ4
<br />4355
<br />FREDDIE MAC
<br />05/25/2016
<br />94988J5N3
<br />6043 Wells Fargo Bank
<br />02/28/2019
<br />2,000,000.00
<br />2,014,740.00
<br />1,988,309.82
<br />2.600
<br />2.881
<br />2.921 502 01/15/2021
<br />94988J5L7
<br />6019 Wells Fargo Bank NA
<br />06/21/2018
<br />2,000,000.00
<br />2,001,820.00
<br />1,984,470.80
<br />2.400
<br />2.869
<br />2.909 136 01/15/2020
<br />912828XM7
<br />Subtotal and Average
<br />40,424,169.30
<br />40,316,000.00
<br />40,892,776.47
<br />39,972,953.82
<br />U S TREASURY
<br />2.810
<br />2.849 767
<br />Federal Agency Issues -Coupon
<br />3133EFKY2
<br />4329
<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 />313380FB8
<br />3543
<br />FEDERAL HOME LOAN BANK
<br />10/07/2016
<br />313383HU8
<br />3555
<br />FEDERAL HOME LOAN BANK
<br />12/15/2016
<br />313383MC2
<br />3572
<br />FEDERAL HOME LOAN BANK
<br />12/20/2017
<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 />1.750
<br />Subtotal and Average 13,272,031.37
<br />1.705
<br />Treasury Securities -Coupon
<br />06/12/2020
<br />2,000,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 />499,840.00
<br />Subtotal and Average 9,890,971.38
<br />505,520.00
<br />Federal Agency Issues -Callable
<br />3133EFKY2
<br />4329
<br />3133EFV20
<br />4351
<br />3133EGWF8
<br />4375
<br />3133EHGG2
<br />4386
<br />3133EHGG2
<br />4388
<br />3133EHHA4
<br />4391
<br />3133EHOM8
<br />4392
<br />3133EHPV9
<br />4393
<br />3133EGMM4
<br />4394
<br />3133EHXM0
<br />4395
<br />3133EHD83
<br />4396
<br />Run Date: 09/11/2019 - 13:07
<br />1,000,000.00
<br />999,180.00
<br />2,000,000.00
<br />1,001,200.00
<br />2,000,000.00
<br />1.550
<br />1.488
<br />1.509
<br />155
<br />02/03/2020
<br />2,000,000.00
<br />2,055,660.00
<br />887,783.49
<br />1,988,640.00
<br />1.490
<br />2.250
<br />2.388
<br />2.421
<br />1,312
<br />04/05/2023
<br />2,000,000.00
<br />1,999,520.00
<br />1,998,200.00
<br />2,015,820.00
<br />1.184
<br />1.375
<br />1.085
<br />1.100
<br />12
<br />09/13/2019
<br />2,000,000.00
<br />1,998,900.00
<br />1.930
<br />2,003,040.00
<br />1.956
<br />1.750
<br />1.682
<br />1.705
<br />285
<br />06/12/2020
<br />2,000,000.00
<br />2,019,440.00
<br />1.946
<br />2,001,580.00
<br />597 04/20/2021
<br />2.125
<br />2.072
<br />2.101
<br />649
<br />06/11/2021
<br />1,410,000.00
<br />1,407,673.50
<br />1.641
<br />1,409,647.50
<br />FEDERAL FARM CREDIT BANK
<br />1.300
<br />1.289
<br />1.307
<br />85
<br />11/25/2019
<br />500,000.00
<br />499,840.00
<br />765 10/05/2021
<br />505,520.00
<br />07/06/2017
<br />1.500
<br />1.105
<br />1.120
<br />23
<br />09/24/2019
<br />1,000,000.00
<br />998,020.00
<br />FEDERAL FARM CREDIT BANK
<br />993,100.00
<br />1,000,000.00
<br />1.500
<br />1.665
<br />1.688
<br />456
<br />11/30/2020
<br />11,910,000.00
<br />11,978,233.b0
<br />10/04/2017
<br />11,918,547.50
<br />2,000,000.00
<br />1,990,460.00
<br />1.676
<br />1.699
<br />440
<br />827 12/06/2021
<br />2,000,000.00
<br />1,996,560.00
<br />2,000,000.00
<br />1,990,764.00
<br />2,000,000.00
<br />1.625
<br />1.736
<br />1.760
<br />303
<br />06/30/2020
<br />2,000,000.00
<br />1,996,480.00
<br />1,986,500.00
<br />1.625
<br />1.864
<br />1.890
<br />334
<br />07/31/2020
<br />2,000,000.00
<br />1,991,880.00
<br />1,972,640.00
<br />1.375
<br />1.872
<br />1.898
<br />365
<br />08/31/2020
<br />2,000,000.00
<br />1,991,560.00
<br />1,965,172.32
<br />1.375
<br />2.092
<br />2.121
<br />395
<br />09/30/2020
<br />2,000,000.00
<br />1,994,920.00
<br />1,975,895.06
<br />1.500
<br />2.446
<br />2.480
<br />273
<br />05/31/2020
<br />10,000,000.00
<br />9,971,400.00
<br />9,890,971.38
<br />2.001
<br />2.029
<br />334
<br />FEDERAL FARM CREDIT BANK
<br />10/30/2015
<br />2,000,000.00
<br />1,997,900.00
<br />2,000,000.00
<br />1.360
<br />1.341
<br />1.360
<br />57 10/28/2019
<br />FEDERAL FARM CREDIT BANK
<br />04/21/2016
<br />891,000.00
<br />887,783.49
<br />891,000.00
<br />1.490
<br />1.470
<br />1.490
<br />211 03/30/2020
<br />FEDERAL FARM CREDIT BANK
<br />10/05/2016
<br />2,000,000.00
<br />1,998,340.00
<br />1,998,200.00
<br />1.170
<br />1.184
<br />1.201
<br />32 10/03/2019
<br />FEDERAL FARM CREDIT BANK
<br />04/26/2017
<br />2,000,000.00
<br />1,997,500.00
<br />1,998,000.00
<br />1.930
<br />1.929
<br />1.956
<br />597 04/20/2021
<br />FEDERAL FARM CREDIT BANK
<br />04/26/2017
<br />2,000,000.00
<br />1,997,500.00
<br />1,996,700.00
<br />1.930
<br />1.946
<br />1.973
<br />597 04/20/2021
<br />FEDERAL FARM CREDIT BANK
<br />06/08/2017
<br />1,475,000.00
<br />1,472,728.50
<br />1,474,115.00
<br />1.620
<br />1.619
<br />1.641
<br />239 04/27/2020
<br />FEDERAL FARM CREDIT BANK
<br />07/05/2017
<br />2,000,000.00
<br />2,000,020.00
<br />1,995,300.00
<br />1.950
<br />1.981
<br />2.008
<br />765 10/05/2021
<br />FEDERAL FARM CREDIT BANK
<br />07/06/2017
<br />1,000,000.00
<br />1,000,000.00
<br />997,600.00
<br />1.730
<br />1.777
<br />1.801
<br />485 12/29/2020
<br />FEDERAL FARM CREDIT BANK
<br />09/14/2017
<br />1,000,000.00
<br />994,870.00
<br />992,500.00
<br />1.375
<br />1.602
<br />1.624
<br />414 10/19/2020
<br />FEDERAL FARM CREDIT BANK
<br />10/04/2017
<br />2,000,000.00
<br />2,000,000.00
<br />1,990,460.00
<br />1.930
<br />2.022
<br />2.050
<br />827 12/06/2021
<br />FEDERAL FARM CREDIT BANK
<br />10/05/2017
<br />2,000,000.00
<br />2,000,000.00
<br />2,000,000.00
<br />2.000
<br />1.973
<br />2.000
<br />765 10/05/2021
<br />Portfolio PLST
<br />CC
<br />PM (PRF_PM2) 7.3.0
<br />
|