|
THE CITY OF
<br /> _
<br /> City of Pleasanton
<br /> CITY OF PLEASANTON
<br /> Portfolio Management
<br /> PLEASANTON,@ PortfolioSummary
<br /> June 30, 2023
<br /> Par Market Book %of Days to YTM YTM
<br /> Investments Value Value Value Portfolio Term Maturity 360 Equiv. 365 Equiv.
<br /> Certificates of Deposit-Bank 491,206.57 491,206.57 491,206.57 0.19 560 290 2.110 2.139
<br /> LAIF 60,000,000.00 59,089,709.94 60,000,000.00 23.58 1 1 3.124 3.167
<br /> Medium Term Notes 30,970,000.00 29,246,421.10 31,530,909.72 12.39 1,776 636 1.681 1.704
<br /> Federal Agency Issues-Coupon 3,000,000.00 2,697,960.00 2,995,657.09 1.18 1,825 1,269 1.262 1.280
<br /> Federal Agency Issues-Callable 158,630,000.00 142,952,072.95 158,420,440.80 62.27 1,822 1,004 0.903 0.916
<br /> Supranationals 1,000,000.00 892.680.00 980,200.00 0.39 1,704 971 0.922 0.935
<br /> Investments 254,091,206.57 235,370,050.56 254,418,414.18 100.00% 1,384 723 1.530 1.551
<br /> Total Earnings June 30 Month Ending Fiscal Year To Date Fiscal Year Ending
<br /> Current Year 327,475.73 3,198,600.26 3,198,600.26
<br /> Average Daily Balance 255,218,414.18 231,809,318.78
<br /> Effective Rate of Return 1.56% 1.38%
<br /> 1 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 21,2022 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 /> (ALJ 7l 7—/—tf z3-
<br /> SUSAN
<br /> 3SUSAN HSIEH,DIRECTOR OF FINANCE
<br /> Reporting period 06/01/2023-06/30/2023 Portfolio PLST
<br /> CC
<br /> Run Date 08/01/2023-13'08 PM(PRF_PM1)7 3.11
<br /> Report Ver.7.3.11
<br />
|