|
THE CITY OF
<br /> ®`amu, :=11^ri�®,: City of Pleasanton
<br /> CITY OF PLEASANTON
<br /> pLE ASAN TONG Portfolio Management
<br /> Portfolio Summary
<br /> October 31, 2017
<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 983,953.94 983,953.94 983,953.94 0.52 456 285 0.553 0.561
<br /> LAIF 28,000,000.00 28,000,000.00 28,000,000.00 14.88 1 1 0.907 0.920
<br /> Medium Term Notes 7,000,000.00 6,979,910.00 7,007,980.00 3.73 1,176 710 1.415 1.435
<br /> Federal Agency Issues-Coupon 47,445,000.00 47,296,220.05 47,491,584.66 25.24 909 432 1.161 1.177
<br /> Treasury Securities-Coupon 5,000,000.00 4,994,530.00 5,002,944.00 2.66 1,045 725 • 1.488 1.508
<br /> Federal Agency Issues-Callable 99,701,000.00 99,076,838.56 99,642,028.81 52.96 1,169 600 1.272 1.290
<br /> 188,129,953.94 187,331,452.55 188,128,491.21 100.00% 923 • 474 1.197 1.214
<br /> Investments
<br /> Total Earnings October 31 Month Ending Fiscal Year To Date
<br /> Current Year 186,388.01 773,150.26
<br /> Average Daily Balance 190,206,879.83 194,601,744.50
<br /> Effective Rate of Return 1.15% 1.18% •
<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 /> include re iums or discounts and are adjusted at year end on the general ledger.
<br /> IA p
<br /> ia-Lt- i
<br /> TINA OLSON,DIRECTOR OF FINANCE
<br /> Reporting period 10/01/2017-10/31/2017 Portfolio PLST
<br /> CC
<br /> Run Date:12/04/2017-14:46 PM(PRF_PM1)7.3.0
<br /> Report Ver.7.3.3
<br />
|