THE CITY Of
<br /> NM ..........na a a'. City of Pleasanton
<br /> 111- CITY OF PLEASANTON
<br /> LEASANTON@ Portfolio Management
<br /> Portfolio Summary
<br /> April 30, 2020
<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 1,004,904.30 1,004,904.30 1,004,904.30 0.44 639 289 1.697 1.720
<br /> LAIF 55,000,000.00 55,090,354.94 55,000,000.00 24.32 1 1 1.657 1.680
<br /> Medium Term Notes 51,785,000.00 53,523,573.98 51,863,944.59 22.94 1,449 1,076 2.498 2.533
<br /> Federal Agency Issues-Coupon 7,000,000.00 7,158,990.00 6,984,860.00 3.09 1,339 463 1.992 2.020
<br /> Treasury Securities-Coupon 10,000,000.00 10,034,240.00 9,890,971.38 4.37 856 91 2.001 2.029
<br /> Federal Agency Issues-Callable 101,390,000.00 101,851,173.78 101,374,912.18 44.83 1,690 1,515 1.891 1.917
<br /> 226,179,904.30 228,663,237.00 226,119,592.45 100.00% 1,172 946 1.980 2.008
<br /> Investments
<br /> Cash,Pending Redemptions
<br /> Pending Redemptions 2,000,000.00 2,000,000.00 2,000,000.00
<br /> Subtotal 2,000,000.00 2,000,000.00
<br /> Total Cash,Pending Redemptions 228,179,904.30 230,663,237.00 228,119,592.45 1,172 946 1.980 2.008
<br /> and Investments
<br /> Total Earnings April 30 Month Ending Fiscal Year To Date
<br /> Current Year 463,288.86 4,154,683.01
<br /> Average Daily Balance 222,374,828.67 204,848,595.43
<br /> Effective Rate of Return 2.53% 2.43%
<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 18,2019 and
<br /> will me t 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 /> discnts an are adjusted at year end on the general ledger.
<br /> /lesLf
<br /> TINA OLSON,DIRECTOR OF FINANCE `
<br /> Reporting period 04/01/2020-04/30/2020 Portfolio PLST
<br /> CC
<br /> Run Date:05/14/2020-08:00 PM(PRF_PM1)7.3.0
<br /> Report Ver.7.3.3
<br />
|