Loading...
04. OCTOBER 31, 2020 Institution Par Value Book Value Price @ Cost (Fair Value) Market Value Yield Money Market Accounts: Citizens Business Bank - Money Market 3,000,973$ 3,000,973$ 3,000,973$ 0.250% First American Govt Oblig Fund CI Y 237,319 237,319 237,319 0.010% Total Money Market 3,238,292$ 3,238,292$ 3,238,292$ 0.232% Pooled Investment Accounts: CAMP Pool 10,363,632$ 10,363,632$ 10,363,632$ 0.190% Local Agency Investment Fund*3,327,669 3,327,669 3,341,361 0.685% Total Pooled Investment 13,691,301$ 13,691,301$ 13,704,993$ 0.310% PFM Managed Investment Portfolio: U.S. Treasury Bond / Note 9,880,000$ 9,902,714$ 10,425,086$ 2.000% Supra-National Agency Bond / Note 920,000 919,574 933,754 2.770% Municipal Bond / Note 1,570,000 1,576,279 1,597,605 1.120% Federal Agency Collaterized Mortgage 1,264,210 1,277,491 1,306,157 2.410% Asset-Back Security / Collateralized 1,784,602 1,784,496 1,814,217 2.660% Certificate of Deposit 3,620,000 3,620,000 3,672,030 1.920% Federal Agency Bond / Note 11,580,000 11,579,918 11,782,149 0.980% Corporate Note 6,670,000 6,737,213 6,960,210 2.270% Total PFM Managed Investments 37,288,812$ 37,397,685$ 38,491,209$ 1.752% ACTIVE DEPOSITS TOTAL 54,218,405$ 54,327,278$ 55,434,494$ 1.298% Checking Account: Citizens Business Bank - General Account 20,264,782$ 20,264,782$ 20,264,782$ 0.000% Citizens Business Bank - HdL Holding 9,998$ 9,998$ 9,998$ 0.000% Total Inactive Deposits 20,274,780$ 20,274,780$ 20,274,780$ 0.000% INACTIVE DEPOSITS TOTAL 20,274,780$ 20,274,780$ 20,274,780$ GRAND TOTAL CASH 74,493,185$ 74,602,058$ 75,709,274$ *yield as of the prior quarter end CITY OF EASTVALE Schedule of Investments Fiscal Year 2020-21 as of October 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.96% LAIF 6.13% CAMP Pool 19.08% Certificates of Deposit 6.66% U.S. Treasury Bond/ Note 18.23% Supra-National Agency Bond/Note 1.69% Municipal Bond / Note 2.90% Federal Agency Collaterized Mortgage 2.35% Asset-Backed Security/ Collateralized 3.28% Federal Agency Bond/ Note 21.32% Corporate Note 12.40% 100.00% DIVERSIFICATION BY MATURITY (PFM PORTFOLIO ONLY) Less Than 90 Days 22.65% 90 days to Six Months (26 Weeks)2.15% Six Months to One Year (52 Weeks)2.94% One to Two Years (104 Weeks)13.47% Two to Three Years (156 Weeks)24.16% Three to Four Years (208 Weeks)14.54% Four to Five Years 20.10% Five Years +0.00% 100.00% II. PORTFOLIO PERFORMANCE MEASURES Yield at Cost - October 31, 2020 1.298% Annual Investment Income Budget 677,570$ Investment Income Received: Money Market 255$ LAIF 19,123 CAMP Pool 9,873 Certificate of Deposits - U.S. Treasury Bond/ Note 71,917 Federal Agency Bond/ Note 43,357 Asset-Backed Security/ Collateralized 76,941 Corporate Note 52,712 Supra-National Agency Bond/Note 18,764 Realized Gain/ (Loss)152,592 Total Investment Income Received-YTD 10/31/2020 445,534 Less Investment Fees Paid: Trust Fees-U.S. Bank (1,737) Mgmt Fee-PFM (11,582) Total Investment Fees Paid-YTD 10/31/2020 (13,319) Net Investment Income Received-YTD 10/31/2020 432,215$ Over/(Under) Annual Budget (245,355)$ % of Annual Budget 63.789% Net Yield Annualized at Cost - October 31, 2020 1.200% CITY OF EASTVALE Dash Board Report Card Fiscal Year 2020-21 as of October 31, 2020 Diversification by Maturity Diversification by Investment CITY OF EASTVALE Dash Board Report Card Fiscal Year 2020-21 as of October 31, 2020 CAMP Pool 20% Local Agency Investment Fund* 6% U.S. Treasury Bond / Note 20% Supra-National Agency Bond / Note 2% Municipal Bond / Note 3% Federal Agency Collaterized Mortgage 3% Asset-Back Security / Collateralized 3% Certificate of Deposit 7% Federal Agency Bond / Note 23% 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 - October 31, 2020 Money Market Accounts 3,238,292$ Pooled Investment Accounts 13,691,301$ PFM Managed Investments 37,397,685$ Checking Account 20,274,780$ Grand Total Cash - October 31, 2020 74,602,058$ Breakdown of Total Cash at October 31, 2020 Restricted Funds (Non-Discretionary Per Law)29,753,799$ 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 12,930,602 Grand Total Cash - October 31, 2020 74,602,058 CITY OF EASTVALE Cash Breakdown per Fund Balance Reserve Policy Fiscal Year 2020-21 as of October 31, 2020 Yield at Cost - October 31, 2020 1.298% Annual Investment Income Budget 677,570$ Investment Income Received YTD: Money Market 255$ LAIF 19,123 CAMP Pool 9,873 Certificate of Deposits - U.S. Treasury Bond/ Note 71,917 Federal Agency Bond/ Note 43,357 Asset-Backed Security/ Collateralized 76,941 Corporate Note 52,712 Supra-National Agency Bond/Note 18,764 Realized Gain/ (Loss)152,592 Total Investment Income Received-YTD 10/31/2020 445,534 Less Investment Fees Paid: Trust Fees-U.S. Bank (1,737) Mgmt Fee-PFM (11,582) Total Investment Fees Paid-YTD 10/31/2020 (13,319) Net Investment Income Received-YTD 10/31/2020 432,215$ Over/(Under) Annual Budget (245,355)$ % of Annual Budget 63.789% Net Yield Annualized at Cost - October 31, 2020 1.200% CITY OF EASTVALE Investment Income Fiscal Year 2020-21 as of October 31, 2020