CITY OF PLEASANTON
<br />Portfolio Management
<br />July 31, 2024
<br />City of Pleasanton
<br />Portfolio Summary
<br />% of
<br />Portfolio
<br />Book
<br />ValueInvestmentsMarket
<br />Value
<br />Par
<br />Value
<br />Days to
<br />MaturityTerm
<br />YTM
<br />360 Equiv.
<br />YTM
<br />365 Equiv.
<br />Certificates of Deposit - Bank 489,245.20 2620.21 4.823154489,245.20489,245.20 4.890
<br />LAIF 44,305,517.89 119.04 4.419144,142,298.2244,305,517.89 4.480
<br />Medium Term Notes 25,504,515.08 1,79810.96 1.48235224,192,162.5024,970,000.00 1.503
<br />Federal Agency Issues - Coupon 2,995,657.09 1,8251.29 1.2628722,798,880.003,000,000.00 1.280
<br />Federal Agency Issues - Callable 158,420,440.80 1,82268.08 0.903607149,539,497.60158,630,000.00 0.916
<br />Supranationals 980,200.00 1,7040.42 0.922574940,420.001,000,000.00 0.935
<br />232,695,576.06 100.00%Investments 222,102,503.52232,394,763.09 1,469 466 1.649 1.672
<br />Current Year
<br />July 31
<br />397,186.05
<br />Fiscal Year To Date
<br />397,186.05
<br />Average Daily Balance
<br />Effective Rate of Return
<br />249,460,826.05 249,460,826.05
<br />1.87%1.87%
<br />Total Earnings Month Ending
<br />I 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 18, 2024 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 />__________________________________________________ ____________________
<br />SUSAN HSIEH, DIRECTOR OF FINANCE
<br />Portfolio PLST
<br />CC
<br />Reporting period 07/01/2024-07/31/2024
<br />Run Date: 09/06/2024 - 16:28 PM (PRF_PM1) 7.3.11
<br />Report Ver. 7.3.11
<br />9/6/2024
<br />Page 19 of 114
|