|
City of Pleasanton
<br /> CITY OF PLEASANTON
<br /> Portfolio Management
<br /> PLEASANTON,
<br /> Portfolio Summary
<br /> February 28, 2023
<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.23 640 230 0.322 0.326
<br /> LAIF 30,000,000.00 29,441,677.74 30,000,000.00 13.16 1 1 2.588 2.624
<br /> Medium Term Notes 32,470,000.00 30,551,390.90 32,988,309.72 14.48 1,772 727 1.739 1.763
<br /> Federal Agency Issues-Coupon 5,000,000.00 4,667,390.00 4,982,797.09 2.19 1,675 850 1.711 1.735
<br /> Federal Agency Issues-Callable 158,630,000 00 141,192,712.95 158,420,440.80 69.52 1,822 1,126 0.903 0.916
<br /> Supranationals 1,000,000 00 882,880 00 980,200.00 0.43 1,704 1,093 0 922 0.935
<br /> 227,619,164.66 207,255,216.25 227,890,912.27 100.00% 1,569 912 1.262 1.280
<br /> Investments
<br /> Total Earnings February 28 Month Ending Fiscal Year To Date
<br /> Current Year 251,071.61 1,894,969.11
<br /> Average Daily Balance 229,597,008.52 223,421,718.77
<br /> Effective Rate of Return 1.43% 1.27%
<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 02/01/2023-02/28/2023 Portfolio PLST
<br /> CC
<br /> Run Date 04/05/2023-07 35
<br /> PM(PRF_PM1)7.3.11
<br /> Report Ver.7.3.11
<br />
|