|
THE CITY Of
<br /> _,,.. ......r -�-�; �� City of Pleasanton
<br /> LE� �I�1TONGCITY OF PLEASANTON
<br /> Pi Portfolio Management
<br /> Portfolio Summary
<br /> June 30, 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.48 457 226 0.889 0.901
<br /> LAIF 50,000,000.00 49,906,343.45 50,000,000.00 24.16 1 1 1.829 1.854
<br /> Medium Term Notes 13,250,000.00 13,000,403.61 13,159,329.41 6.36 1,119 868 2.218 2.249
<br /> Federal Agency Issues-Coupon 35,445,000.00 35,131,629.30 35,481,208.05 17.14 977 354 1.280 1.298
<br /> Treasury Securities-Coupon 9,000,000.00 8,856,810.00 8,962,084.00 4.33 1,012 612 1.656 1.679
<br /> Federal Agency Issues-Callable 98,511,000.00 97,253,397.69 98,378,863.19 47.53 1,160 588 1.562 1.583
<br /> 207,193,159.68 205,135,743.73 206,968,644.33 100.00% 836 423 1.621 1.643
<br /> Investments
<br /> Total Earnings June 30 Month Ending Fiscal Year To Date Fiscal Year Ending
<br /> Current Year 270,903.46 2,659,617.97 2,659,617.97
<br /> Average Daily Balance 210,729,434.60 200,689,982.09
<br /> Effective Rate of Return 1.56% 1.33%
<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 will 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 /> inclu pre iums or discounts and are adjusted at year end on the general ledger.
<br /> TINA OLSON, DIRECTOR OF FINANCE
<br /> Reporting period 06/01/2018-06/30/2018 Portfolio PLST
<br /> CC
<br /> Run Date:07/24/2018-15:01
<br /> PM(PRF_PM1)7.3 0
<br /> Report Ver.7.3 3
<br />
|