|
THE CITY Of
<br /> CITY OF PLEASANTON city of Pleasanton
<br /> PLEASAI�TON.1, Portfolio Management
<br /> Portfolio Summary
<br /> December 31, 2022
<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 519,164.66 519,164.66 519,164.66 0.22 640 289 0.322 0.326
<br /> LAIF 30,000,000.00 29,441,677.74 30,000,000.00 12.82 1 1 2.143 2.173
<br /> Medium Term Notes 38,650,000.00 36,772,335.50 39,135,768.75 16.72 1,713 668 1.933 1.960
<br /> Federal Agency Issues-Coupon 51000,000.00 4,678,820.00 4,982,797.09 2.13 1,675 909 1.711 1.735
<br /> Federal Agency Issues-Callable 158,630,000.00 141,785,469.45 158,420,440.80 67.69 1,822 1,185 0.903 0.916
<br /> Supranationals 1,000,000.00 885,680.00 980.200.00 0.42 1,704 1,152 0.922 0.935
<br /> Investments 233,799,164.66 214,083,147.35 234,038,371.30 100.00% 1,564 939 1.250 1.268
<br /> Total Earnings December 31 Month Ending Fiscal Year To Date
<br /> Current Year 227,344.19 1,358,072.42
<br /> Average Daily Balance 220,877,676.97 220,857,412.01
<br /> Effective Rate of Return 1.21% 1.22%
<br /> 1 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 21,2022 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 /> Y-12
<br /> �Z
<br /> SUSAN HSIEH,DIRECTOR OF FINANCE
<br /> Reporting period 12/01/2022-12/31/2022
<br /> Portfolio PLST
<br /> CC
<br /> Run Date 02/06/2023-16'.25 PM(PRF_PM1)7.3.11
<br /> Report Ver.7.3.11
<br />
|