Loading...
07. JANUARY 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,002,486$ 3,002,486$ 3,002,486$ 0.200% First American Govt Oblig Fund CI Y 381,726 381,726 381,726 0.010% Total Money Market 3,384,212$ 3,384,212$ 3,384,212$ 0.179% Pooled Investment Accounts: CAMP Pool 10,366,903$ 10,366,903$ 10,365,852$ 0.120% Local Agency Investment Fund*3,332,930 3,332,930 3,340,500 0.458% Total Pooled Investment 13,699,833$ 13,699,833$ 13,706,352$ 0.202% PFM Managed Investment Portfolio: U.S. Treasury Bond / Note 9,500,000$ 9,510,362$ 9,990,447$ 2.030% Supra-National Agency Bond / Note 1,200,000 1,199,186 1,208,671 2.210% Municipal Bond / Note 1,570,000 1,575,766 1,609,523 1.120% Federal Agency Collaterized Mortgage 1,183,029 1,194,113 1,218,777 2.390% Asset-Back Security / Collateralized 1,475,553 1,475,458 1,497,482 2.580% Certificate of Deposit 2,920,000 2,920,000 2,966,598 1.840% Federal Agency Bond / Note 12,665,000 12,663,042 12,882,133 0.940% Corporate Note 6,670,000 6,731,704 6,935,176 2.270% Total PFM Managed Investments 37,183,582$ 37,269,631$ 38,308,807$ 1.689% 54,267,627$ 54,353,676$ 55,399,371$ 1.220% Checking Account: Citizens Business Bank - General Account 27,061,219$ 27,061,219$ 27,061,219$ 0.000% Citizens Business Bank - HdL Holding 6,832$ 6,832$ 6,832$ 0.000% Total Inactive Deposits 27,068,051$ 27,068,051$ 27,068,051$ 0.000% 27,068,051$ 27,068,051$ 27,068,051$ 81,335,678$ 81,421,727$ 82,467,422$ *yield as of the prior quarter end CITY OF EASTVALE Treasurer's Report Fiscal Year 2020-21 as of January 31, 2021 ACTIVE DEPOSITS TOTAL INACTIVE DEPOSITS TOTAL INACTIVE DEPOSITS ACTIVE DEPOSITS Institution 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. eastvaleca.gov Dash Board Report Card I. PORTFOLIO DIVERSIFICATION DIVERSIFICATION BY INSTRUMENTMoney Market 6.23%LAIF 6.13%CAMP Pool 19.07%Certificates of Deposit 5.37%U.S. Treasury Bond/ Note 17.50%Supra-National Agency Bond/Note 2.21%Municipal Bond / Note 2.90%Federal Agency Collaterized Mortgage 2.20%Asset-Backed Security/ Collateralized 2.71%Federal Agency Bond/ Note 23.30%Corporate Note 12.39%100.00% DIVERSIFICATION BY MATURITY (PFM PORTFOLIO ONLY) Less Than 90 Days 23.44%90 days to Six Months (26 Weeks)1.70%Six Months to One Year (52 Weeks)3.59%One to Two Years (104 Weeks)14.12%Two to Three Years (156 Weeks)26.74%Three to Four Years (208 Weeks)14.23%Four to Five Years 16.18%Five Years +0.00%100.00% II. PORTFOLIO PERFORMANCE MEASURES Yield at Cost - January 31, 2021 1.220% Annual Investment Income Budget 756,379$ Investment Income Received: Money Market 16$ LAIF 24,385 CAMP Pool 13,143 Certificate of Deposits - U.S. Treasury Bond/ Note 129,149 Federal Agency Bond/ Note 82,284 Asset-Backed Security/ Collateralized 88,412 Corporate Note 96,974 Supra-National Agency Bond/Note 25,708 Realized Gain/ (Loss)160,523 Total Investment Income Received-YTD 01/31/2021 620,593 Less Investment Fees Paid: Trust Fees-U.S. Bank (3,005) Mgmt Fee-PFM (20,517) Total Investment Fees Paid-YTD 01/31/2021 (23,523) Net Investment Income Received-YTD 01/31/2021 597,071$ Over/(Under) Annual Budget (159,309)$ % of Annual Budget 78.938% Net Yield Annualized at Cost - January 31, 2021 1.047% CITY OF EASTVALE Treasurer's Report Fiscal Year 2020-21 as of January 31, 2021 eastvaleca.gov Dash Board Report Card Diversification by Maturity Diversification by Investment CITY OF EASTVALE Treasurer's Report Fiscal Year 2020-21 as of January 31, 2021 CAMP Pool 20% Local Agency Investment Fund* 7% U.S. Treasury Bond / Note 19% Supra-National Agency Bond / Note 2% Municipal Bond / Note 3%Federal Agency Collaterized Mortgage 2% Asset-Back Security / Collateralized 3% Certificate of Deposit 6% Federal Agency Bond / Note 25% Corporate Note 13% 0% 5% 10% 15% 20% 25% 30% 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 Cash Breakdown per Fund Balance Reserve Policy Schedule of Investments - January 31, 2021 Money Market Accounts 3,384,212$ Pooled Investment Accounts 13,699,833$ PFM Managed Investments 37,269,631$ Checking Account 27,068,051$ Grand Total Cash - January 31, 2021 81,421,727$ Breakdown of Total Cash at January 31, 2021 Restricted Funds (Non-Discretionary Per Law)38,248,762$ Committed (Per Formal Action of City Council)10,500,000 Designated/ Assigned (Per City's Intent):- Fire Operations/ Improvements (Per FY 20-21 Budget)9,576,930 General Fund Emergency Contingency: To meet City's cash obligations for the next six months General Fund Adopted Budget Expenditures-FY 2020-21 (Per Fund Balance Reserve Policy)11,840,728 Total Designated/ Assigned 21,417,658 Unassigned 11,255,306 Grand Total Cash - January 31, 2021 81,421,727 Fiscal Year 2020-21 as of January 31, 2021 Treasurer's Report CITY OF EASTVALE eastvaleca.gov Investment Income Yield at Cost - January 31, 2021 1.220% Annual Investment Income Budget A 756,379$ Investment Income Received YTD: Money Market (CBB)2,993$ Money Market (PFM)16 LAIF 24,385 CAMP Pool 13,143 Certificate of Deposits - U.S. Treasury Bond/ Note 129,149 Federal Agency Bond/ Note 82,284 Asset-Backed Security/ Collateralized 88,412 Corporate Note 96,974 Supra-National Agency Bond/Note 25,708 Realized Gain/ (Loss)160,523 Total Investment Income Received-YTD 01/31/2021 B 620,593 Less Investment Fees Paid: Trust Fees-U.S. Bank (3,005) Mgmt Fee-PFM (20,517) Total Investment Fees Paid-YTD 01/31/2021 C (23,523) Net Investment Income Received-YTD 01/31/2021 B+C 597,071$ Investment Income Over/(Under) Annual Budget C-B (159,309)$ % of Annual Budget 78.938% Net Yield Annualized at Cost - January 31, 2021 1.047% Fiscal Year 2020-21 as of January 31, 2021 Treasurer's Report CITY OF EASTVALE eastvaleca.gov