|
City of Pleasanton
<br /> CITY OF PLEASANTON
<br /> PLEASANTON,, Portfolio Management
<br /> Portfolio Summary
<br /> March 31, 2023
<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.22 640 199 0.322 0.326
<br /> IAIF 40,000,000.00 39,460,413.16 40,000,000.00 16.81 1 1 2.792 2.831
<br /> Medium Term Notes 32,470,000.00 30,916,279.10 32,988,309.72 13.87 1,772 696 1.739 1.763
<br /> Federal Agency Issues-Coupon 5,000,000.00 4,729,200.00 4,982,797.09 2.09 1,675 819 1.711 1.735
<br /> Federal Agency Issues-Callable 158,630,000.00 144,142,512.70 158,420,440.80 66.59 1,822 1,095 0 903 0.916
<br /> Supranationals 1,000,000.00 902,370.00 980,200 00 0.41 1,704 1,062 0 922 0.935
<br /> Investments 237,619,164.66 220,669,939.62 237,890,912.27 100.00% 1,503 848 1.352 1.371
<br /> Total Earnings March 31 Month Ending Fiscal Year To Date
<br /> Current Year 260,815.27 2,176,893.33
<br /> Average Daily Balance 231,116,718.72 224,292,320.95
<br /> Effective Rate of Return 1.33% 1.29%
<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 03/01/2023-03/31/2023 Portfolio PLST
<br /> CC
<br /> Run Date-05/08/2023-12 54
<br /> PM(PRF_PM1)7 3 11
<br /> Report Ver 7 3 11
<br />
|