|
THE CITY OF •
<br /> _'- f _r ;,....-.2..-1.:sE. City of Pleasanton
<br /> u' II -'" I le ��pLEASANTONc Portfolio Management
<br /> Portfolio Summary
<br /> November 30, 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 255 0.553 0.561
<br /> LAIF 28,000,000.00 28,000,000.00 28,000,000.00 14.73 1 1 1.055 1.070
<br /> Medium Term Notes 7,000,000.00 6,955,100.00 7,004,530.00 3.68 1,176 680 1.415 1.434
<br /> Federal Agency Issues-Coupon 45,445,000.00 45,217,544.20 45,491,584.66 23.93 917 421 1.171 1.187
<br /> Treasury Securities-Coupon 5,000,000.00 4,977,850.00 5,002,944.00 2.63 1,045 695 1.488 1.508
<br /> Federal Agency Issues-Callable 103,701,000.00 102,900,700.16 103,633,666.95 54.51 1,180 604 1.305 1.323
<br /> 190,129,953.94 189,035,148.30 190,116,679.55 100.00% 936 475 1.241 1.258
<br /> Investments
<br /> Total Earnings November 30 Month Ending Fiscal Year To Date
<br /> Current Year 194,170.35 970,887.73
<br /> Average Daily Balance 187,924,981.49 193,292,575.28
<br /> Effective Rate of Return 1.26% 1.20%
<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 p ium or discounts and are adjusted at year end on the general ledger.
<br /> T NA OLSON,DIRECTOR OF FINANCE
<br /> Reporting period 11/01/2017-11/30/2017 Portfolio PLST
<br /> CC
<br /> Run Date:12/20/2017-14:21 PM(PRF_PM1)7.3.0
<br /> Report Ver.7.3.3
<br />
|