Loading...
01. JUL 31, 2021 Schedule of Investments Par Value Book Value Price @ Cost (Fair Value) Market Value Yield Money Market Accounts: Citizens Business Bank - Money Market 3,004,420$ 3,004,420$ 3,004,420$ 0.100% First American Govt Oblig Fund CI Y 199,221 199,221 199,221 0.010% Total Money Market 3,203,641$ 3,203,641$ 3,203,641$ 0.094% Sweep Accounts: Citizens Business Bank - General Sweep 34,495,466$ 34,495,466$ 34,495,466$ 0.100% Total Sweep Accounts 34,495,466$ 34,495,466$ 34,495,466$ 0.100% Pooled Investment Accounts: CAMP Pool 10,370,216$ 10,370,216$ 10,370,216$ 0.050% Local Agency Investment Fund*3,339,296 3,339,296 3,339,573 0.310% Total Pooled Investment 13,709,512$ 13,709,512$ 13,709,789$ 0.113% PFM Managed Investment Portfolio: U.S. Treasury Bond / Note 13,150,000$ 13,109,954$ 13,480,040$ 1.610% Supra-National Agency Bond / Note 280,000 279,535 279,628 32.000% Municipal Bond / Note 1,570,000 1,574,757 1,597,409 1.120% Federal Agency Collaterized Mortgage 1,063,035 1,070,753 1,088,547 2.380% Asset-Back Security / Collateralized 1,117,738 1,117,647 1,126,431 1.880% Certificate of Deposit 1,930,000 1,930,000 1,956,698 1.520% Federal Agency Bond / Note 12,270,000 12,267,816 12,407,371 0.950% Corporate Note 6,409,000 6,456,077 6,592,327 2.060% Total PFM Managed Investments 37,789,773$ 37,806,540$ 38,528,450$ 1.702% 89,198,391$ 89,215,159$ 89,937,346$ 0.781% Checking Account: Citizens Business Bank - General Account 12,003,848$ 12,003,848$ 12,003,848$ 0.000% Citizens Business Bank - HdL Holding 6,830$ 6,830$ 6,830$ 0.000% Total Inactive Deposits 12,010,678$ 12,010,678$ 12,010,678$ 0.000% 12,010,678$ 12,010,678$ 12,010,678$ 101,209,070$ 101,225,837$ 101,948,024$ *yield as of the prior quarter end GRAND TOTAL CASH Per Government Code requirements, the Investment Report is in compliance with the City of Eastvale's Investment Policy, and there are adequate funds available to meet budgeted and actual expenditures for the next six months. CITY OF EASTVALE Treasurer's Report Fiscal Year 2021-22 as of July 31, 2021 ACTIVE DEPOSITS TOTAL INACTIVE DEPOSITS TOTAL INACTIVE DEPOSITS ACTIVE DEPOSITS Institution eastvaleca.gov Dash Board Report Card I. PORTFOLIO DIVERSIFICATION Money Market 3.59%Sweep 38.67%LAIF 3.74%CAMP Pool 11.62%Certificates of Deposit 2.16%U.S. Treasury Bond/ Note 14.69%Supra-National Agency Bond/Note 0.31%Municipal Bond / Note 1.77%Federal Agency Collaterized Mortgage 1.20%Asset-Backed Security/ Collateralized 1.25%Federal Agency Bond/ Note 13.75%Corporate Note 7.24%100.00% Less Than 90 Days 23.15%90 days to Six Months (26 Weeks)1.63%Six Months to One Year (52 Weeks)4.14%One to Two Years (104 Weeks)18.19%Two to Three Years (156 Weeks)18.19%Three to Four Years (208 Weeks)19.75%Four to Five Years 14.93%Five Years +0.00%100.00% II. PORTFOLIO PERFORMANCE MEASURES Yield at Cost - July 31, 2021 0.781% Annual Investment Income Budget 799,390$ Investment Income Received: Money Market 1$ LAIF 2,724 CAMP Pool 446 Certificate of Deposits - U.S. Treasury Bond/ Note 540 Federal Agency Bond/ Note 4,059 Asset-Backed Security/ Collateralized 7,960 Corporate Note 13,699 Supra-National Agency Bond/Note - Realized Gain/ (Loss)840 Total Investment Income Received-YTD 07/31/2021 30,268 Less Investment Fees Paid: Trust Fees-U.S. Bank (400) Mgmt Fee-PFM (3,000) Total Investment Fees Paid-YTD 07/31/2021 (3,400) Net Investment Income Received-YTD 07/31/2021 26,868$ Over/(Under) Annual Budget (772,522)$ % of Annual Budget 3.361% Net Yield Annualized at Cost - July 31, 2021 0.766% CITY OF EASTVALE Treasurer's Report Fiscal Year 2021-22 as of July 31, 2021 DIVERSIFICATION BY INSTRUMENT DIVERSIFICATION BY MATURITY (PFM & CAMP PORTFOLIO ONLY) eastvaleca.gov Dash Board Report Card Diversification by Maturity Diversification by Investment CITY OF EASTVALE Treasurer's Report Fiscal Year 2021-22 as of July 31, 2021 CAMP Pool 20% Local Agency Investment Fund* 6% U.S. Treasury Bond / Note 26% Supra-National Agency Bond / Note 0% Municipal Bond / Note 3% Federal Agency Collaterized Mortgage 2% Asset-Back Security / Collateralized 2% Certificate of Deposit 4% Federal Agency Bond / Note 24% Corporate Note 13% 0% 5% 10% 15% 20% 25% 0 - 0.25 0.25 - 0.50 0.50 - 1 1 - 2 2 - 3 3 - 4 4 - 5 +5 +% of PortfolioMaturity in Years eastvaleca.gov Dash Board Report Card CITY OF EASTVALE Treasurer's Report Fiscal Year 2021-22 as of July 31, 2021 Year Over Year Interest Income - 200,000 400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 1,600,000 1,800,000 2017-18 2018-19 2019-20 2020-21 2021-22 YTDInterest Income ReceivedFiscal Year eastvaleca.gov Cash Breakdown per Fund Balance Reserve Policy Schedule of Investments - July 31, 2021 Money Market Accounts 3,203,641$ Sweep Accounts 34,495,466$ Pooled Investment Accounts 13,709,512 PFM Managed Investments 37,806,540 Checking Account 12,010,678 Grand Total Cash - July 31, 2021 101,225,837$ Breakdown of Total Cash at July 31, 2021 Restricted Funds (Non-Discretionary Per Law)37,385,353$ Committed (Per Formal Action of City Council)31,065,500 Designated/ Assigned (Per City's Intent): Fire Operations/ Improvements (Per FY 21-22 Budget)4,966,263$ General Fund Emergency Contingency: To meet City's cash obligations for the next six months General Fund Adopted Budget Expenditures - FY 2021-22 (Per Fund Balance Reserve Policy)13,133,584 Total Designated/ Assigned 18,099,847 Unassigned 14,675,137 Grand Total Cash - July 31, 2021 101,225,837$ Fiscal Year 2021-22 as of July 31, 2021 Treasurer's Report CITY OF EASTVALE eastvaleca.gov Investment Income Yield at Cost - July 31, 2021 0.781% Annual Investment Income Budget A 799,390$ Investment Income Received YTD: Money Market (CBB)247$ Sweep (CBB)1,670 Money Market (PFM)1 LAIF 2,724 CAMP Pool 446 Certificate of Deposits - U.S. Treasury Bond/ Note 540 Federal Agency Bond/ Note 4,059 Asset-Backed Security/ Collateralized 7,960 Corporate Note 13,699 Supra-National Agency Bond/Note - Realized Gain/ (Loss)840 Total Investment Income Received-YTD 07/31/2021 B 32,185 Less Investment Fees Paid: Trust Fees-U.S. Bank (400) Mgmt Fee-PFM (3,000) Total Investment Fees Paid-YTD 07/31/2021 C (3,400) Net Investment Income Received-YTD 07/31/2021 B+C 28,785$ Investment Income Over/(Under) Annual Budget C-B (770,605)$ % of Annual Budget 3.601% Net Yield Annualized at Cost - July 31, 2021 0.766% Fiscal Year 2021-22 as of July 31, 2021 Treasurer's Report CITY OF EASTVALE eastvaleca.gov