Loading...
05. NOVEMBER 30, 2020 Institution Par Value Book Value Price @ Cost (Fair Value) Market Value Yield Money Market Accounts: Citizens Business Bank - Money Market 3,001,499$ 3,001,499$ 3,001,499$ 0.210% First American Govt Oblig Fund CI Y 237,319 237,319 237,319 0.010% Total Money Market 3,238,818$ 3,238,818$ 3,238,818$ 0.195% Pooled Investment Accounts: CAMP Pool 10,364,786$ 10,364,786$ 10,364,786$ 0.140% Local Agency Investment Fund*3,327,669 3,327,669 3,341,361 0.685% Total Pooled Investment 13,692,455$ 13,692,455$ 13,706,147$ 0.272% PFM Managed Investment Portfolio: U.S. Treasury Bond / Note 9,555,000$ 9,562,937$ 10,069,506$ 2.040% Supra-National Agency Bond / Note 1,200,000 1,199,033 1,212,050 2.210% Municipal Bond / Note 1,570,000 1,576,112 1,606,821 1.120% Federal Agency Collaterized Mortgage 1,258,550 1,271,284 1,299,100 2.410% Asset-Back Security / Collateralized 1,672,758 1,672,660 1,698,960 2.660% Certificate of Deposit 2,920,000 2,920,000 2,968,214 1.840% Federal Agency Bond / Note 12,350,000 12,348,455 12,565,968 0.950% Corporate Note 6,670,000 6,735,466 6,955,032 2.270% Total PFM Managed Investments 37,196,308$ 37,285,947$ 38,375,651$ 1.712% ACTIVE DEPOSITS TOTAL 54,127,581$ 54,217,220$ 55,320,616$ 1.258% Checking Account: Citizens Business Bank - General Account 19,875,263$ 19,875,263$ 19,875,263$ 0.000% Citizens Business Bank - HdL Holding 16,583$ 16,583$ 16,583$ 0.000% Total Inactive Deposits 19,891,846$ 19,891,846$ 19,891,846$ 0.000% INACTIVE DEPOSITS TOTAL 19,891,846$ 19,891,846$ 19,891,846$ GRAND TOTAL CASH 74,019,427$ 74,109,066$ 75,212,461$ *yield as of the prior quarter end CITY OF EASTVALE Schedule of Investments Fiscal Year 2020-21 as of November 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.97% LAIF 6.14% CAMP Pool 19.12% Certificates of Deposit 5.39% U.S. Treasury Bond/ Note 17.64% Supra-National Agency Bond/Note 2.21% Municipal Bond / Note 2.91% Federal Agency Collaterized Mortgage 2.34% Asset-Backed Security/ Collateralized 3.09% Federal Agency Bond/ Note 22.78% Corporate Note 12.42% 100.00% DIVERSIFICATION BY MATURITY (PFM PORTFOLIO ONLY) Less Than 90 Days 21.98% 90 days to Six Months (26 Weeks)1.44% Six Months to One Year (52 Weeks)2.96% One to Two Years (104 Weeks)14.87% Two to Three Years (156 Weeks)27.19% Three to Four Years (208 Weeks)12.22% Four to Five Years 19.35% Five Years +0.00% 100.00% II. PORTFOLIO PERFORMANCE MEASURES Yield at Cost - November 30, 2020 1.258% Annual Investment Income Budget 677,570$ Investment Income Received: Money Market 267$ LAIF 19,123 CAMP Pool 11,026 Certificate of Deposits - U.S. Treasury Bond/ Note 111,678 Federal Agency Bond/ Note 47,894 Asset-Backed Security/ Collateralized 80,679 Corporate Note 65,544 Supra-National Agency Bond/Note 18,764 Realized Gain/ (Loss)156,904 Total Investment Income Received-YTD 11/30/2020 511,879 Less Investment Fees Paid: Trust Fees-U.S. Bank (2,163) Mgmt Fee-PFM (14,565) Total Investment Fees Paid-YTD 11/30/2020 (16,729) Net Investment Income Received-YTD 11/30/2020 495,151$ Over/(Under) Annual Budget (182,419)$ % of Annual Budget 73.077% Net Yield Annualized at Cost - November 30, 2020 1.134% CITY OF EASTVALE Dash Board Report Card Fiscal Year 2020-21 as of November 30, 2020 Diversification by Maturity Diversification by Investment CITY OF EASTVALE Dash Board Report Card Fiscal Year 2020-21 as of November 30, 2020 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 3% Asset-Back Security / Collateralized 3% Certificate of Deposit 6% Federal Agency Bond / Note 24% 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 - November 30, 2020 Money Market Accounts 3,238,818$ Pooled Investment Accounts 13,692,455$ PFM Managed Investments 37,285,947$ Checking Account 19,891,846$ Grand Total Cash - November 30, 2020 74,109,066$ Breakdown of Total Cash at November 30, 2020 Restricted Funds (Non-Discretionary Per Law)29,557,177$ 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,634,231 Grand Total Cash - November 30, 2020 74,109,066 CITY OF EASTVALE Cash Breakdown per Fund Balance Reserve Policy Fiscal Year 2020-21 as of November 30, 2020 Yield at Cost - November 30, 2020 1.258% Annual Investment Income Budget 677,570$ Investment Income Received YTD: Money Market 267$ LAIF 19,123 CAMP Pool 11,026 Certificate of Deposits - U.S. Treasury Bond/ Note 111,678 Federal Agency Bond/ Note 47,894 Asset-Backed Security/ Collateralized 80,679 Corporate Note 65,544 Supra-National Agency Bond/Note 18,764 Realized Gain/ (Loss)156,904 Total Investment Income Received-YTD 11/30/2020 511,879 Less Investment Fees Paid: Trust Fees-U.S. Bank (2,163) Mgmt Fee-PFM (14,565) Total Investment Fees Paid-YTD 11/30/2020 (16,729) Net Investment Income Received-YTD 11/30/2020 495,151$ Over/(Under) Annual Budget (182,419)$ % of Annual Budget 73.077% Net Yield Annualized at Cost - November 30, 2020 1.134% CITY OF EASTVALE Investment Income Fiscal Year 2020-21 as of November 30, 2020