THE CITY OF
<br /> ern -_.- City of Pleasanton
<br /> Inga CITY OF PLEASANTON
<br /> PLEASAYNTON, Portfolio Management
<br /> Portfolio Summary
<br /> July 31, 2023
<br /> Par Market Book %of Days to YTM YTM
<br /> Investments Value Value Value Portfolio Tenn Maturity 360 Equiv. 365 Equiv.
<br /> Certificates of Deposit-Bank 491,206.57 491,206.57 491,206.57 0.21 560 259 2.110 2.139
<br /> LAIF 37,000,000.00 36,438,654.46 37,000,000.00 16.06 1 1 3.260 3.305
<br /> Medium Terre Notes 29,970,000.00 28,342,674.90 30,475,689.47 13.23 1,792 626 1.677 1.701
<br /> Federal Agency Issues-Coupon 3,000,000.00 2,693,190.00 2,995,657.09 1.30 1,825 1,238 1.262 1.280
<br /> Federal Agency Issues-Callable 158,630,000.00 143,378,587.95 158,420,440.80 68.77 1,822 973 0.903 0.916
<br /> Supranationals 1,000,000.00 894,820.00 980,200.00 0.43 1,704 940 0.922 0.935
<br /> 230,091,206.57 212,239,133.88 230,363,193.93 100.00% 1,523 773 1.392 1.411
<br /> Investments
<br /> Total Earnings July 31 Month Ending Fiscal Year To Date
<br /> Current Year 248,812.84 248,812.84
<br /> Average Daily Balance 241,332,522.47 241,332,522.47
<br /> Effective Rate of Return 1.21% 1.21%
<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 20,2023 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 /> 26�1�-
<br /> SUSAN HSIEH,DIRECTOR OF FINANCE
<br /> Reporting period 07/0112023-0713112023 Portfolio PLST
<br /> CC
<br /> Run Date:09/06/2023-13:35 PM(PRF PM1)7.3.11
<br /> Report Ver.7.3.11
<br />
|