07 - Laserfiche WebLink

CITY OF PLEASANTON INVESTMENT ACTIVITY SUMMARY AND ANALYSIS AS JUNE,2022 SUMMARY: Primary City Managed Investment Portfolio The City of Pleasanton General investment portfolio has an increase of $22.0 million based on the investment book value, from $219,001,527 to $241,007,459 during the last quarter ending June 30, 2022. The increase in the portfolio during the quarter ending June 30, 2022 was primarily due to investing the property tax and sales tax installment that remained in the City's general bank account at the Fiscal Year End. The fiscal year to date effective rate of return on the portfolio was 1.19 percent. The average days to maturity (ADM) decreased from 1,261 days on March 31, 2022 to 1 ,068 days on June 30, 2022. The City's investment in the LAIF increased to$35 million from $10 million last quarter ending March 31, 2022. The quarterly LAIF apportionment interest rate was 0.75 percent with ADM of 311 days. The average monthly effective yield was 0.523 percent in April, 0.684 in May, and 0.861 in June. During the quarter, only $3.2 million in securities matured,which the City used to fund operating costs and purchased one certificate of deposit. The yield of the new certificate of deposit was 0.5 percent. As of June 30, 2022, approximately 67.8 percent of the total portfolio consisted of federal agency securities, while the LAIF investment was 14.52 percent of the portfolio. Corporate notes accounted for 17.05 percent of the portfolio. • Fair Market Value of total portfolio- $227,563,508 • Fiscal year-to-date effective rate of return - 1.19 percent • Weighted average days to maturity - 1,068 days • Fiscal year-to-date net interest earnings - $2,585,947 ASSET COMPOSITION: Investment Percent of Portfolio Certificates of Deposit- Bank 0.22% LAIF 14.52% Medium Term Notes 17.05% Federal Agency Issues - Coupon 2.07% Federal Agency Issues - Callable 65.73% Supranationals 0.41% 100.00%