THE CITY OF
<br /> ,,, ��� City of Pleasanton
<br /> 1. •••••=6; ,,
<br /> -
<br /> �� M M .�. CITY OF PLEASANTON
<br /> PLEASANTON. Portfolio Management
<br /> Portfolio Summary
<br /> January 31, 2018
<br /> Investments Term Maturity Par Market Book %of to YTM YTM
<br /> Value Value Value Portfolio 360 Equiv. 365 Equiv.
<br /> Certificates of Deposit-Bank 983,953 94 983,953 94 983,953 94 0 48 456 193 0 553 0.561
<br /> LAIF 38,000,000 00 38,000,000.00 38,000,000.00 18.62 1 1 1.222 1.239
<br /> Medium Term Notes 9,000,000.00 8,891,543.33 9,000,313 33 4 41 1,271 827 1 628 1 651
<br /> Federal Agency Issues-Coupon 45,445,000 00 45,122,992 75 45,485,740.55 22.29 947 415 1.225 1.242
<br /> Treasury Securities-Coupon 9,000,000.00 8,888,206.35 8,970,440 35 4 40 1,012 763 1 656 1 679
<br /> Federal Agency Issues-Callable 101,701,000.00 100,559,949 20 101,630,072 78 49 80 1,152 573 1 334 1 352
<br /> 204,129,953.94 202,446,645.57 204,070,520.95 100.00% 888 449 1.312 1.330
<br /> Investments
<br /> Total Earnings January 31 Month Ending Fiscal Year To Date
<br /> Current Year 230,851.48 1,404,801.17
<br /> Average Daily Balance 205,434,429.77 195,670,782.51
<br /> Effective Rate of Return 1.32% 1.22%
<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 wil 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 01/01/2018-01/31/2018 Portfolio PLST
<br /> CC
<br /> Run Date 02/20/2018-10.17 PM(PRF_PM1)7 3 0
<br /> Report Ver.7.3.3
<br />
|