THE CITY OF
<br /> VS ' City of Pleasanton
<br /> LE�5�4I T N� CITY OF PLntpON
<br /> Portfolio Management
<br /> Portfolio Summary
<br /> November 30, 2019
<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 994,760.96 994,760.96 994,760.96 0.53 638 255 2.065 2.094
<br /> LAIF 25,000,000.00 25,000,000.00 25,000,000.00 13.35 1 1 2.403 2.436
<br /> Medium Term Notes 41,915,000.00 42,397,993.11 41,570,482.26 22.19 1,148 718 2.778 2.816
<br /> Federal Agency issues-Coupon 8,000,000.00 8,054,630.00 7,986,060.00 4.26 1,308 546 1.929 1.956
<br /> Treasury Securities-Coupon 10,000,000.00 9,988,040.00 9,890,971.38 5.28 856 243 2.001 2.029
<br /> Federal Agency Issues-Callable 102,226,000.00 102,201,433.13 101,887,256.52 54.39 1,590 1,214 2.151 2.181
<br /> 188,135,760.96 188,636,857.20 187,329,531.12 100.00% 1,224 857 2.306 2.338
<br /> Investments
<br /> Total Earnings November 30 Month Ending Fiscal Year To Date
<br /> Current Year 466,730.45 1,916,887.60
<br /> Average Daily Balance 187,744,120.80 196,098,417.80
<br /> Effective Rate of Return 3.02% 2.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 19,2018 and
<br /> 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 include premiums or
<br /> disco s d are adjusted at year end on the general ledger.
<br /> i.t I ."'" k-D••— 1 /
<br /> ' TINA OLSON,DIRECTOR OF FINANCE
<br /> Reporting period 11/01/2019-11/30/2019 Portfolio PLST
<br /> CC
<br /> Run Date:12/11/2019-09:31
<br /> PM(PRF_PM1)7.3.0
<br /> Report Ver.7.3.3
<br />
|