|
THE CITY OF
<br /> �^_, F1: r III
<br /> City of Pleasanton
<br /> INN wAR
<br /> 1k E A Tom
<br /> i\lc, Portfolio Management
<br /> Portfolio Summary
<br /> April 30, 2018
<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 987,159.68 987,159.68 987,159.68 0.45 457 287 0.889 0.901
<br /> LAIF 50,000,000.00 49,876,900.50 50,000,000.00 23.00 1 1 1.410 1.430
<br /> Medium Term Notes 11,250,000.00 11,076,461.66 11,235,599.16 5.17 1,213 773 1.796 1.821
<br /> Federal Agency Issues-Coupon 42,445,000.00 42,073,572.50 42,486,790.55 19.54 970 353 1.240 1.257
<br /> Treasury Securities-Coupon 9,000,000.00 8,845,210.00 8,962,084.00 4.12 1,012 673 1.656 1.679
<br /> Federal Agency Issues-Callable 103,801,000.00 102,455,986.08 103,715,494.09 47.71 1,121 586 1.487 1.507
<br /> 217,483,159.68 215,315,290.42 217,387,127.48 100.00% 831 418 1.441 1.461
<br /> Investments
<br /> Total Earnings April 30 Month Ending Fiscal Year To Date
<br /> Current Year 242,989.33 2,106,697.05
<br /> Average Daily Balance 204,756,134.04 198,313,301.15
<br /> Effective Rate of Return 1.44% 1.28%
<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 eet 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 /> zinclud re ms or discounts and are adjusted at year end on the general ledger.l
<br /> TINA OLSON, DIRECTOR OF FINANCE
<br /> Reporting period 04/01/2018-04/30/2018
<br /> Portfolio PLST
<br /> CC
<br /> Run Date 05/14/2018-12:58 PM(PRF_PM1)7.3.0
<br /> Report Ver.7.3.3
<br />
|