|
CITY OF PLEASANTON
<br />Portfolio Management
<br />November 30, 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.110137491,206.57491,206.57 2.139
<br />LAIF 24,000,000.00 111.14 3.790123,671,385.7424,000,000.00 3.843
<br />Medium Term Notes 28,578,889.47 1,78813.26 1.58554526,618,866.8027,970,000.00 1.607
<br />Federal Agency Issues - Coupon 2,995,657.09 1,8251.39 1.2621,1162,720,940.003,000,000.00 1.280
<br />Federal Agency Issues - Callable 158,420,440.80 1,82273.52 0.903851145,455,957.55158,630,000.00 0.916
<br />Supranationals 980,200.00 1,7040.45 0.922818907,140.001,000,000.00 0.935
<br />215,466,393.93 100.00%Investments 199,865,496.66215,091,206.57 1,612 718 1.323 1.342
<br />Current Year
<br />November 30
<br />243,947.47
<br />Fiscal Year To Date
<br />1,399,523.88
<br />Average Daily Balance
<br />Effective Rate of Return
<br />215,466,393.93 224,512,979.45
<br />1.49%1.38%
<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 11/01/2023-11/30/2023
<br />Run Date: 12/26/2023 - 13:53 PM (PRF_PM1) 7.3.11
<br />Report Ver. 7.3.11
<br />for 12/26/2023
<br />Page 108 of 201
|