|
THE CITY OF
<br /> City of Pleasanton
<br /> CITY OF PLEASANTON
<br /> PLEASANTON,,. Portfolio Management
<br /> Portfolio Summary
<br /> April 30, 2023
<br /> Par Market Book %of Days to YTM YTM
<br /> InvestmentsPar
<br /> Value Value Portfolio Term Maturity 360 Equiv. 365 Equiv.
<br /> Certificates of Deposit-Bank 491,206.57 491,206.57 491,206.57 0.19 560 351 2.110 2.139
<br /> LAIF 65,000,000.00 64,123,171.39 65,000,000.00 24.92 1 1 2.831 2.870
<br /> Medium Term Notes 32,470,000.00 30,992,075.20 32,988,309.72 12.65 1,772 666 1.739 1.763
<br /> Federal Agency Issues-Coupon 3,000,000.00 2,744,760.00 2.995.657.09 1.15 1,825 1,330 1.262 1.280
<br /> Federal Agency Issues-Callable 158,630,000.00 144,406,180.80 158,420,440.80 60.73 1,822 1,065 0.903 0.916
<br /> Supranationals 1,000,000.00 905,970.00 980,200.00 0.38 1,704 1,032 0.922 0.935
<br /> 260,591,206.57 243,663,363.96 260,875,814.18 100.00% 1,359 751 1.496 1.516
<br /> Investments
<br /> Total Earnings April 30 Month Ending Fiscal Year To Date
<br /> Current Year 319,574.68 2,496,468.01
<br /> Average Daily Balance 250,326,071.57 226,861,441.08
<br /> Effective Rate of Return 1.55% 1.32%
<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 /> w �/t-:�712e2-
<br /> 3
<br /> SUSAN HSIEH,DIRECTOR OF FINANCE
<br /> Reporting period 04/01/2023-04/30/2023 Portfolio PLST
<br /> CC
<br /> Run Date06/05/2023-16 16 PM(PRF_PM1)7.3.11
<br /> Report Ver.7.3.11
<br />
|