Laserfiche WebLink
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 />