10 - Laserfiche WebLink

CITY OF PLEASANTON INVESTMENT ACTIVITY SUMMARY AND ANALYSIS AS OF SEPTEMBER 30,2022 SUMMARY: Primary City Managed Investment Portfolio The City of Pleasanton General investment portfolio has a decrease of $21 .9 million based on the investment book value, from $241,007,459 to $ 219,038,987 during the last quarter ending September 30, 2022. This decrease in the portfolio during the quarter ending September 30, 2022 was primarily to accommodate large disbursements to various vendors: CaIPERS for FY 2022/23 Unfunded Pension Liability, Bay Cities Joint Powers for insurance, and Contractors for various construction and service contracts. The fiscal year to date effective rate of return on the portfolio was 1 .24 percent. The average days to maturity (ADM) increased from 1,068 days on June 30, 2022 to 1 ,089 days on September 30, 2022. The City's investment in the LAIF decreased to $15.0 million from $35.0 million last quarter ending June 30, 2022. The quarterly LAIF apportionment interest rate was 1 .35 percent with ADM of 304 days. The average monthly effective yield was 1 .09 percent in July, 1 .28 in August, and 1 .51 in September. During the quarter, only $2.0 million in securities was matured, which the City used to fund operating cost. As of September 30, 2022, approximately 73.4 percent of the total portfolio consisted of federal agency securities, while the LAIF investment was 7.4 percent of the portfolio. Corporate notes accounted for 18.5 percent of the portfolio. • Fair Market Value of total portfolio - $197,799,021 • Fiscal year-to-date effective rate of return - 1 .24 percent • Weighted average days to maturity - 1 ,089 days • Fiscal year-to-date net interest earnings - $704,847 ASSET COMPOSITION: Investment Percent of Portfolio Certificates of Deposit - Bank 0.30% LAIF 7.40% Medium Term Notes 18.50% Federal Agency Issues - Coupon 2.40% Federal Agency Issues - Callable 71.00% Supranationals 0.40% 100.00%