|
CITY OF PLEASANTON
<br />Portfolio Management
<br />October 31, 2023
<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 491,206.57 5600.23 2.110167491,206.57491,206.57 2.139
<br />LAIF 24,000,000.00 111.14 3.620123,671,385.7424,000,000.00 3.670
<br />Medium Term Notes 28,578,889.47 1,78813.26 1.58557526,386,369.1027,970,000.00 1.607
<br />Federal Agency Issues - Coupon 2,995,657.09 1,8251.39 1.2621,1462,678,190.003,000,000.00 1.280
<br />Federal Agency Issues - Callable 158,420,440.80 1,82273.52 0.903881143,613,297.80158,630,000.00 0.916
<br />Supranationals 980,200.00 1,7040.45 0.922848895,270.001,000,000.00 0.935
<br />215,466,393.93 100.00%Investments 197,735,719.21215,091,206.57 1,612 744 1.304 1.322
<br />Current Year
<br />October 31
<br />247,078.55
<br />Fiscal Year To Date
<br />1,155,576.41
<br />Average Daily Balance
<br />Effective Rate of Return
<br />216,627,684.25 226,719,463.72
<br />1.51%1.34%
<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 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 />__________________________________________________ ____________________
<br />SUSAN HSIEH, DIRECTOR OF FINANCE
<br />Portfolio PLST
<br />CC
<br />Reporting period 10/01/2023-10/31/2023
<br />Run Date: 11/27/2023 - 16:41 PM (PRF_PM1) 7.3.11
<br />Report Ver. 7.3.11
<br />11/28/2023
<br />Page 137 of 270
|