|
City of Pleasanton
<br /> S�NTCJI� CITY OF PLEASANTON
<br /> * Portfolio Management
<br /> PL,E
<br /> Portfolio Summary
<br /> January 31, 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 519,164.66 519,164.66 519,164.66 0.22 640 258 0.322 0 326
<br /> LAIF 30,000,000.00 29,441,677.74 30,000,000.00 12.99 1 1 2.392 2.425
<br /> Medium Term Notes 35,470,000.00 33,843,561.20 35,980,679.22 15.58 1,737 694 1.837 1.863
<br /> Federal Agency Issues-Coupon 5,000,000.00 4,716,170.00 4,982,797.09 2.16 1,675 878 1.711 1.735
<br /> Federal Agency Issues-Callable 158,630,000.00 143,543,549.60 158,420,440.80 68.61 1,822 1,154 0 903 0 916
<br /> Supranationals 1,000,000.00 896,780.00 980,200.00 0.42 1,704 1,121 0.922 0 935
<br /> 230,619,164.66 212,960,903.20 230,883,281.77 100.00% 1,566 924 1.258 1.276
<br /> Investments
<br /> Total Earnings January 31 month Ending Fiscal Year To Date
<br /> Current Year 276,891.59 1,643,897.50
<br /> Average Daily Balance 233,064,439.11 222,617,494.99
<br /> Effective Rate of Return 1.40% 1.25%
<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 /> C � 8
<br /> SUSAN HSIEH, DIRECTOR OF FINANCE
<br /> Reporting period 01/01/2023-01/31/2023 Portfolio PLST
<br /> CC
<br /> Run Date-03/07/2023-1427 PM(PRF_PM1)7.3.11
<br /> Report Ver 7 3.11
<br />
|