|
THE CITY OF
<br /> •• . _I, r n .p./ r IICity of Pleasanton
<br /> L��S�4NT�N� CITY OF PLEASANTON
<br /> Portfolio Management
<br /> Portfolio Summary
<br /> May 31, 2018
<br /> Par Market Book %of Days to YTM YTM
<br /> Investments Value Value Value Portfolio Term Maturity 360 Equiv. 365 Equiv.
<br /> Certificates of Deposit-Bank 987,159.68 987,159.68 987,159.68 0.47 457 256 0.889 0.901
<br /> LAIF 50,000,000.00 49,876,900.50 50,000,000.00 23.69 1 1 1.731 1.755
<br /> Medium Term Notes 9,250,000.00 9,087,660.00 9,222,672.50 4.37 1,233 909 1.946 1.973
<br /> Federal Agency Issues-Coupon 40,445,000.00 40,136,590.65 40,486,060.55 19.18 968 339 1.251 1.269
<br /> Treasury Securities-Coupon 9,000,000.00 8,865,430.00 8,962,084.00 4.25 1,012 642 1.656 1.679
<br /> Federal Agency Issues-Callable 101,511,000.00 100,349,792.24 101,404,283.75 48.04 1,139 589 1.529 1.551
<br /> 211,193,159.68 209,303,533.07 211,062,260.48 100.00% 832 416 1.544 1.566
<br /> Investments
<br /> Total Earnings May 31 Month Ending Fiscal Year To Date
<br /> Current Year 281,701.02 2,388,714.51
<br /> Average Daily Balance 214,281,189.51 199,790,926.64
<br /> Effective Rate of Return 1.55% 1.30%
<br /> I hereby certify that, to the best of my knowledge, this report includes all investments in the cash management program, is in accordance with the City's current investment policy dated June 20,
<br /> 2017 and w meet the City's cash flow needs for the next six months. Market value amounts are from Bank of New York Mellon (safekeeping bank)month-end statements. Book value amounts
<br /> include miu or discounts and are adjusted at year end on the general ledger.
<br /> TINA OLSON, DIRECTOR OF FINANCE
<br /> Reporting period 05/01/2018-05/31/2018 Portfolio PLST
<br /> CC
<br /> Run Date 06/20/2018-12.38 PM(PRF_PM1)7 3.0
<br /> Report Ver 7 3.3
<br />
|