|
CITY OF PLEASANTON
<br />Portfolio Management
<br />December 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.20 2.110106491,206.57491,206.57 2.139
<br />LAIF 59,000,000.00 123.56 3.875158,619,044.7359,000,000.00 3.929
<br />Medium Term Notes 28,578,889.47 1,78811.41 1.58551426,825,757.2027,970,000.00 1.607
<br />Federal Agency Issues - Coupon 2,995,657.09 1,8251.20 1.2621,0852,759,040.003,000,000.00 1.280
<br />Federal Agency Issues - Callable 158,420,440.80 1,82263.25 0.903820147,143,471.48158,630,000.00 0.916
<br />Supranationals 980,200.00 1,7040.39 0.922787918,920.001,000,000.00 0.935
<br />250,466,393.93 100.00%
<br />Investments
<br />236,757,439.98250,091,206.57 1,386 594 1.688 1.711
<br />Current Year
<br />December 31
<br />298,478.66
<br />Fiscal Year To Date
<br />1,698,002.54
<br />Average Daily Balance
<br />Effective Rate of Return
<br />230,337,361.67 225,494,261.24
<br />1.49%1.53%
<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 12/01/2023-12/31/2023
<br />Run Date: 01/30/2024 - 10:04 PM (PRF_PM1) 7.3.11
<br />Report Ver. 7.3.11
<br />2/2/2024
<br />Page 164 of 228
|