Loading...
06. DECEMBER 31, 2020 Institution Par Value Book Value Price @ Cost (Fair Value) Market Value Yield Money Market Accounts: Citizens Business Bank - Money Market 3,002,009$ 3,002,009$ 3,002,009$ 0.200% First American Govt Oblig Fund CI Y 205,140 205,140 205,140 0.010% Total Money Market 3,207,149$ 3,207,149$ 3,207,149$ 0.188% Pooled Investment Accounts: CAMP Pool 10,365,852$ 10,365,852$ 10,365,852$ 0.120% Local Agency Investment Fund*3,327,669 3,327,669 3,341,361 0.576% Total Pooled Investment 13,693,520$ 13,693,520$ 13,707,212$ 0.231% PFM Managed Investment Portfolio: U.S. Treasury Bond / Note 9,500,000$ 9,509,540$ 10,006,779$ 2.030% Supra-National Agency Bond / Note 1,200,000 1,199,110 1,210,322 2.210% Municipal Bond / Note 1,570,000 1,575,939 1,609,390 1.120% Federal Agency Collaterized Mortgage 1,248,129 1,260,352 1,286,381 2.410% Asset-Back Security / Collateralized 1,547,035 1,546,944 1,570,679 2.670% Certificate of Deposit 2,920,000 2,920,000 2,969,818 1.840% Federal Agency Bond / Note 12,665,000 12,663,092 12,887,659 0.940% Corporate Note 6,670,000 6,733,661 6,949,094 2.270% Total PFM Managed Investments 37,320,164$ 37,408,638$ 38,490,122$ 1.696% ACTIVE DEPOSITS TOTAL 54,220,833$ 54,309,307$ 55,404,484$ 1.238% Checking Account: Citizens Business Bank - General Account 20,498,048$ 20,498,048$ 20,498,048$ 0.000% Citizens Business Bank - HdL Holding 7,817$ 7,817$ 7,817$ 0.000% Total Inactive Deposits 20,505,865$ 20,505,865$ 20,505,865$ 0.000% INACTIVE DEPOSITS TOTAL 20,505,865$ 20,505,865$ 20,505,865$ GRAND TOTAL CASH 74,726,699$ 74,815,173$ 75,910,349$ *yield as of the prior quarter end CITY OF EASTVALE Schedule of Investments Fiscal Year 2020-21 as of December 31, 2020 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. ACTIVE DEPOSITS INACTIVE DEPOSITS I. PORTFOLIO DIVERSIFICATION DIVERSIFICATION BY INSTRUMENT Money Market 5.91% LAIF 6.13% CAMP Pool 19.09% Certificates of Deposit 5.38% U.S. Treasury Bond/ Note 17.51% Supra-National Agency Bond/Note 2.21% Municipal Bond / Note 2.90% Federal Agency Collaterized Mortgage 2.32% Asset-Backed Security/ Collateralized 2.85% Federal Agency Bond/ Note 23.32% Corporate Note 12.40% 100.00% DIVERSIFICATION BY MATURITY (PFM PORTFOLIO ONLY) Less Than 90 Days 21.93% 90 days to Six Months (26 Weeks)1.43% Six Months to One Year (52 Weeks)3.64% One to Two Years (104 Weeks)14.44% Two to Three Years (156 Weeks)28.31% Three to Four Years (208 Weeks)11.20% Four to Five Years 19.05% Five Years +0.00% 100.00% II. PORTFOLIO PERFORMANCE MEASURES Yield at Cost - December 31, 2020 1.238% Annual Investment Income Budget 756,379$ Investment Income Received: Money Market 15$ LAIF 19,123 CAMP Pool 12,092 Certificate of Deposits - U.S. Treasury Bond/ Note 128,103 Federal Agency Bond/ Note 77,388 Asset-Backed Security/ Collateralized 84,180 Corporate Note 73,685 Supra-National Agency Bond/Note 18,764 Realized Gain/ (Loss)160,523 Total Investment Income Received-YTD 12/31/2020 573,873 Less Investment Fees Paid: Trust Fees-U.S. Bank (2,590) Mgmt Fee-PFM (17,433) Total Investment Fees Paid-YTD 12/31/2020 (20,023) Net Investment Income Received-YTD 12/31/2020 553,851$ Over/(Under) Annual Budget (202,529)$ % of Annual Budget 73.224% Net Yield Annualized at Cost - December 31, 2020 1.090% CITY OF EASTVALE Dash Board Report Card Fiscal Year 2020-21 as of December 31, 2020 Diversification by Maturity Diversification by Investment CITY OF EASTVALE Dash Board Report Card Fiscal Year 2020-21 as of December 31, 2020 CAMP Pool 20% Local Agency Investment Fund* 6% U.S. Treasury Bond / Note 19% Supra-National Agency Bond / Note 2% Municipal Bond / Note 3% Federal Agency Collaterized Mortgage 3% 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 Schedule of Investments - December 31, 2020 Money Market Accounts 3,207,149$ Pooled Investment Accounts 13,693,520$ PFM Managed Investments 37,408,638$ Checking Account 20,505,865$ Grand Total Cash - December 31, 2020 74,815,173$ Breakdown of Total Cash at December 31, 2020 Restricted Funds (Non-Discretionary Per Law)29,838,796$ 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 13,058,719 Grand Total Cash - December 31, 2020 74,815,173 CITY OF EASTVALE Cash Breakdown per Fund Balance Reserve Policy Fiscal Year 2020-21 as of December 31, 2020 Yield at Cost - December 31, 2020 1.238% Annual Investment Income Budget 756,379$ Investment Income Received YTD: Money Market (CBB)2,516$ Money Market (PFM)15 LAIF 19,123 CAMP Pool 12,092 Certificate of Deposits - U.S. Treasury Bond/ Note 128,103 Federal Agency Bond/ Note 77,388 Asset-Backed Security/ Collateralized 84,180 Corporate Note 73,685 Supra-National Agency Bond/Note 18,764 Realized Gain/ (Loss)160,523 Total Investment Income Received-YTD 12/31/2020 573,873 Less Investment Fees Paid: Trust Fees-U.S. Bank (2,590) Mgmt Fee-PFM (17,433) Total Investment Fees Paid-YTD 12/31/2020 (20,023) Net Investment Income Received-YTD 12/31/2020 553,851$ Over/(Under) Annual Budget (202,529)$ % of Annual Budget 73.224% Net Yield Annualized at Cost - December 31, 2020 1.090% CITY OF EASTVALE Investment Income Fiscal Year 2020-21 as of December 31, 2020