Loading...
03. SEPTEMBER 30, 2020 Institution Par Value Book Value Price @ Cost (Fair Value) Market Value Yield Money Market Accounts: Citizens Business Bank - Money Market 3,000,357$ 3,000,357$ 3,000,357$ 0.250% First American Govt Oblig Fund CI Y 34,806 34,806 34,806 0.010% Total Money Market 3,035,162$ 3,035,162$ 3,035,162$ 0.247% Pooled Investment Accounts: CAMP Pool 10,361,972$ 10,361,972$ 10,361,972$ 0.270% Local Agency Investment Fund*3,320,617 3,320,617 3,336,931 0.784% Total Pooled Investment 13,682,590$ 13,682,590$ 13,698,903$ 0.395% PFM Managed Investment Portfolio: U.S. Treasury Bond / Note 10,540,000$ 10,550,653$ 11,139,824$ 2.040% Supra-National Agency Bond / Note 920,000 919,515 935,558 2.770% Municipal Bond / Note 1,425,000 1,431,452 1,457,486 1.160% Federal Agency Collaterized Mortgage 1,270,197 1,283,995 1,313,789 2.410% Asset-Back Security / Collateralized 1,898,001 1,897,889 1,931,237 2.650% Certificate of Deposit 3,685,000 3,684,998 3,740,367 1.950% Federal Agency Bond / Note 11,400,000 11,427,212 11,666,819 1.030% Corporate Note 6,135,000 6,168,505 6,401,166 2.400% Total PFM Managed Investments 37,273,197$ 37,364,218$ 38,586,245$ 1.810% ACTIVE DEPOSITS TOTAL 53,990,949$ 54,081,969$ 55,320,311$ 1.364% Checking Account: Citizens Business Bank - General Account 19,888,890$ 19,888,890$ 19,888,890$ 0.000% Citizens Business Bank - HdL Holding 3,230$ 3,230$ 3,230$ 0.000% Total Inactive Deposits 19,892,120$ 19,892,120$ 19,892,120$ 0.000% INACTIVE DEPOSITS TOTAL 19,892,120$ 19,892,120$ 19,892,120$ GRAND TOTAL CASH 73,883,069$ 73,974,089$ 75,212,430$ *yield as of the prior quarter end CITY OF EASTVALE Schedule of Investments Fiscal Year 2020-21 as of September 30, 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.61% LAIF 6.14% CAMP Pool 19.16% Certificates of Deposit 6.81% U.S. Treasury Bond/ Note 19.51% Supra-National Agency Bond/Note 1.70% Municipal Bond / Note 2.65% Federal Agency Collaterized Mortgage 2.37% Asset-Backed Security/ Collateralized 3.51% Federal Agency Bond/ Note 21.13% Corporate Note 11.41% 100.00% DIVERSIFICATION BY MATURITY (PFM PORTFOLIO ONLY) Less Than 90 Days 22.74% 90 days to Six Months (26 Weeks)0.71% Six Months to One Year (52 Weeks)4.39% One to Two Years (104 Weeks)12.58% Two to Three Years (156 Weeks)24.83% Three to Four Years (208 Weeks)13.64% Four to Five Years 21.11% Five Years +0.00% 100.00% II. PORTFOLIO PERFORMANCE MEASURES Yield at Cost - September 30, 2020 1.364% Annual Investment Income Budget 677,570$ Investment Income Received: Money Market 256$ LAIF - CAMP Pool 10,540 Certificate of Deposits - U.S. Treasury Bond/ Note 83,347 Federal Agency Bond/ Note 39,610 Asset-Backed Security/ Collateralized 80,313 Corporate Note 48,395 Supra-National Agency Bond/Note 16,603 Realized Gain/ (Loss)138,229 Total Investment Income Received-YTD 09/30/2020 417,293 Less Investment Fees Paid: Trust Fees-U.S. Bank (1,310) Mgmt Fee-PFM (8,948) Total Investment Fees Paid-YTD 09/30/2020 (10,258) Net Investment Income Received-YTD 09/30/2020 407,034$ Over/(Under) Annual Budget (270,536)$ % of Annual Budget 60.073% Net Yield Annualized at Cost - September 30, 2020 1.288% CITY OF EASTVALE Dash Board Report Card Fiscal Year 2020-21 as of September 30, 2020 Diversification by Maturity Diversification by Investment CITY OF EASTVALE Dash Board Report Card Fiscal Year 2020-21 as of September 30, 2020 CAMP Pool 20% Local Agency Investment Fund* 6% U.S. Treasury Bond / Note 21% Supra-National Agency Bond / Note 2% Municipal Bond / Note 3% Federal Agency Collaterized Mortgage 3% Asset-Back Security / Collateralized 4% Certificate of Deposit 7% Federal Agency Bond / Note 22% Corporate Note 12% 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 - September 30, 2020 Money Market Accounts 3,035,162$ Pooled Investment Accounts 13,682,590$ PFM Managed Investments 37,364,218$ Checking Account 19,892,120$ Grand Total Cash - September 30, 2020 73,974,089$ Breakdown of Total Cash at September 30, 2020 Restricted Funds (Non-Discretionary Per Law)-$ 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 (Per FY20-21 Budget)6,689,368 Grand Total Cash - September 30, 2020 38,607,026 CITY OF EASTVALE Cash Breakdown per Fund Balance Reserve Policy Fiscal Year 2020-21 as of September 30, 2020 Yield at Cost - September 30, 2020 1.364% Annual Investment Income Budget 677,570$ Investment Income Received YTD: Money Market 256$ LAIF - CAMP Pool 10,540 Certificate of Deposits - U.S. Treasury Bond/ Note 83,347 Federal Agency Bond/ Note 39,610 Asset-Backed Security/ Collateralized 80,313 Corporate Note 48,395 Supra-National Agency Bond/Note 16,603 Realized Gain/ (Loss)138,229 Total Investment Income Received-YTD 09/30/2020 417,293 Less Investment Fees Paid: Trust Fees-U.S. Bank (1,310) Mgmt Fee-PFM (8,948) Total Investment Fees Paid-YTD 09/30/2020 (10,258) Net Investment Income Received-YTD 09/30/2020 407,034$ Over/(Under) Annual Budget (270,536)$ % of Annual Budget 60.073% Net Yield Annualized at Cost - September 30, 2020 1.288% CITY OF EASTVALE Investment Income Fiscal Year 2020-21 as of September 30, 2020