THE CITY Of
<br /> m .ra a to ra r ill City of Pleasanton
<br /> L��1S�4NTC�N� CITY OF PLEASANTON
<br /> Portfolio Management
<br /> Portfolio Summary
<br /> July 31, 2022
<br /> Investments Par Market Book /of Days to YTM YTM
<br /> Value Value Value Portfolio Term Maturity 360 Equiv. 365 Equiv.
<br /> Certificates of Deposit-Bank 519,164.66 519,164.66 519,164.66 0.23 640 442 0.322 0.326
<br /> LAIF 21,000,000.00 21,000,000.00 21,000,000.00 9.25 1 1 1.075 1.090
<br /> Medium Term Notes 40,650,000.00 39,609,066.50 41,100,528.75 18.11 1,691 784 1.965 1.992
<br /> Federal Agency Issues-Coupon 5,000,000.00 4,797,120.00 4,982,797.09 2.20 1,675 1,062 1.711 1.735
<br /> Federal Agency Issues-Callable 158,630,000.00 147,849,401.14 158,423,309.99 69.79 1,822 1,338 0.903 0.916
<br /> Supranationals 1,000,000.00 921,500.00 980,200.00 0.43 1,704 1,305 0.922 0.935
<br /> 226,799,164.66 214,696,252.30 227,006,000.49 100.00% 1,624 1,106 1.128 1.144
<br /> Investments
<br /> Total Earnings July 31 Month Ending Fiscal Year To Date
<br /> Current Year 221,007.90 221,007.90
<br /> Average Daily Balance 231,813,722.26 231,813,722.26
<br /> Effective Rate of Return 1.12% 1.12%
<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 16,2020 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 /> discounts and are adjusted at year end on the general ledger.
<br /> [/\,--_--- 9/ /713Z ZSusan Hsieh,DIRECTOR OF FINANCE
<br /> Reporting period 07/01/2022-07/31/2022 Portfolio PLST
<br /> CC
<br /> Run Date:09/09/2022-09:19 PM(PRF_PM1)7.3.0
<br /> Report Ver.7.3.3
<br />
|