THE CITY OF
<br /> I
<br /> City of Pleasanton
<br /> tt� CITY OF PLEASANTON
<br /> PLEASANTON, Portfolio Management
<br /> Portfolio Summary
<br /> November 30, 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.25 640 320 0.322 0.326
<br /> LAIF 6,000,000.00 5,884,565.77 6,000,000.00 2.86 1 1 1.980 2.007
<br /> Medium Term Notes 38,650,000.00 36,801,079.00 39,135,768.75 18.63 1,713 699 1.933 1.960
<br /> Federal Agency Issues-Coupon 5,000,000.00 4,672,510.00 4,982,797.09 2.37 1,675 940 1.711 1.735
<br /> Federal Agency Issues-Callable 158,630,000.00 141,612,600.66 158,421,056.66 75.42 1,822 1,216 0.903 0.916
<br /> Supranationals 1,000,000.00 885,170.00 980,200.00 0.47 1,704 1,183 0.922 0.935
<br /> 209,799,164.66 190,375,090.09 210,038,987.16 100.00% 1,743 1,076 1.144 1.160
<br /> Investments
<br /> Total Earnings November 30 Month Ending- Fiscal Year To Date
<br /> Current Year 210,627.33 1,130,728.23
<br /> Average Daily Balance 212,338,987.16 220,853,306.04
<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 /> SUSAN HSIEH,DIRECTOR OF FINANCE
<br /> Reporting period 11/01/2022-11/30/2022 Portfolio PLST
<br /> CC
<br /> Run Date:01/03/2023-09:58 PM(PRF_PM 1)7.3.11
<br /> Report Ver-7.3.11
<br />
|