|
CITY OF PLEASANTON
<br />Portfolio Management
<br />June 30, 2025
<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 484,448.75 2620.19 3.802171484,448.75484,448.75 3.855
<br />LAIF 66,500,000.00 125.74 4.419166,474,862.0066,500,000.00 4.480
<br />Gov't Money Market 5,506,228.63 12.13 4.05415,506,228.635,506,228.63 4.110
<br />Medium Term Notes 21,745,905.00 1,6198.42 2.71276021,361,810.0021,500,000.00 2.750
<br />Federal Agency Issues - Coupon 2,995,657.09 1,8251.16 1.2625382,887,920.003,000,000.00 1.280
<br />Treasury Securities - Coupon 20,256,097.69 9887.84 3.95992320,400,421.0020,200,000.00 4.014
<br />Federal Agency Issues - Callable 137,427,790.80 1,82253.20 0.943307134,199,465.50137,630,000.00 0.956
<br />Supranationals 2,952,980.00 1,3141.14 2.9258192,959,730.003,000,000.00 2.966
<br />Asset Backed Securities 439,972.22 1,4360.17 4.3711,416442,645.08440,000.00 4.431
<br />258,309,080.18 100.00%Investments 254,717,530.96258,260,677.38 1,222 318 2.327 2.360
<br />Cash
<br />(not included in yield calculations)
<br />Passbook/Checking 1,027,282.08 1 0.00011,027,282.081,027,282.08 0.000
<br />259,336,362.26Total Cash and Investments 255,744,813.04259,287,959.46 1,222 318 2.327 2.360
<br />Current Year
<br />June 30
<br />362,556.01
<br />Fiscal Year To Date
<br />4,136,703.32 4,136,703.32
<br />Fiscal Year Ending
<br />Average Daily Balance
<br />Effective Rate of Return
<br />261,524,567.29 240,378,415.58
<br />1.72%1.69%
<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 are adjusted at year end on the general ledger.
<br />__________________________________________________ ____________________
<br />SUSAN HSIEH, DIRECTOR OF FINANCE
<br />Portfolio PLST
<br />CC
<br />Reporting period 06/01/2025-06/30/2025
<br />Run Date: 08/06/2025 - 23:30 PM (PRF_PM1) 7.3.11
<br />Report Ver. 7.3.11
<br />8/8/2025
<br />Page 167 of 674
|