Loading...
10. APRIL 30, 2021 Schedule of Investments Par Value Book Value Price @ Cost (Fair Value) Market Value Yield Money Market Accounts: Citizens Business Bank - Money Market 3,003,626$ 3,003,626$ 3,003,626$ 0.150% First American Govt Oblig Fund CI Y 204,790 204,790 204,790 0.010% Total Money Market 3,208,415$ 3,208,415$ 3,208,415$ 0.141% Pooled Investment Accounts: CAMP Pool 10,368,868$ 10,368,868$ 10,368,868$ 0.060% Local Agency Investment Fund*3,336,571 3,336,571 3,340,808 0.357% Total Pooled Investment 13,705,439$ 13,705,439$ 13,709,676$ 0.132% PFM Managed Investment Portfolio: U.S. Treasury Bond / Note 12,410,000$ 12,383,067$ 12,768,409$ 1.730% Supra-National Agency Bond / Note 280,000 279,485 279,471 0.320% Municipal Bond / Note 1,570,000 1,575,270 1,594,557 1.120% Federal Agency Collaterized Mortgage 1,154,366 1,167,047 1,186,261 2.380% Asset-Back Security / Collateralized 1,407,098 1,406,989 1,420,632 2.070% Certificate of Deposit 2,295,000 2,295,000 2,331,805 1.560% Federal Agency Bond / Note 12,270,000 12,267,971 12,393,098 0.960% Corporate Note 6,208,000 6,275,158 6,431,776 2.160% Total PFM Managed Investments 37,594,464$ 37,649,986$ 38,406,007$ 1.537% 54,508,318$ 54,563,841$ 55,324,099$ 1.102% Checking Account: Citizens Business Bank - General Account 28,235,262$ 28,235,262$ 28,235,262$ 0.000% Citizens Business Bank - HdL Holding 7,537$ 7,537$ 7,537$ 0.000% Total Inactive Deposits 28,242,799$ 28,242,799$ 28,242,799$ 0.000% 28,242,799$ 28,242,799$ 28,242,799$ 82,751,117$ 82,806,639$ 83,566,897$ *yield as of the prior quarter end 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. CITY OF EASTVALE Treasurer's Report Fiscal Year 2020-21 as of April 30, 2021 ACTIVE DEPOSITS TOTAL INACTIVE DEPOSITS TOTAL INACTIVE DEPOSITS ACTIVE DEPOSITS Institution eastvaleca.gov Dash Board Report Card I. PORTFOLIO DIVERSIFICATION DIVERSIFICATION BY INSTRUMENTMoney Market 5.88%LAIF 6.11%CAMP Pool 19.00%Certificates of Deposit 4.21%U.S. Treasury Bond/ Note 22.69%Supra-National Agency Bond/Note 0.51%Municipal Bond / Note 2.89%Federal Agency Collaterized Mortgage 2.14%Asset-Backed Security/ Collateralized 2.58%Federal Agency Bond/ Note 22.48%Corporate Note 11.50%100.00% DIVERSIFICATION BY MATURITY (PFM & CAMP PORTFOLIO ONLY) Less Than 90 Days 21.32%90 days to Six Months (26 Weeks)0.03%Six Months to One Year (52 Weeks)6.04%One to Two Years (104 Weeks)14.09%Two to Three Years (156 Weeks)24.47%Three to Four Years (208 Weeks)18.16%Four to Five Years 15.88%Five Years +0.00%100.00% II. PORTFOLIO PERFORMANCE MEASURES Yield at Cost - April 30, 2021 1.102% Annual Investment Income Budget 556,379$ Investment Income Received: Money Market 19$ LAIF 28,026 CAMP Pool 15,108 Certificate of Deposits 4,320 U.S. Treasury Bond/ Note 179,685 Federal Agency Bond/ Note 117,464 Asset-Backed Security/ Collateralized 104,028 Corporate Note 175,506 Supra-National Agency Bond/Note 29,310 Realized Gain/ (Loss)147,691 Total Investment Income Received-YTD 04/30/2021 801,157 Less Investment Fees Paid: Trust Fees-U.S. Bank (4,310) Mgmt Fee-PFM (29,280) Total Investment Fees Paid-YTD 04/30/2021 (33,589) Net Investment Income Received-YTD 04/30/2021 767,568$ Over/(Under) Annual Budget 211,189$ % of Annual Budget 137.958% Net Yield Annualized at Cost - April 30, 2021 0.856% CITY OF EASTVALE Treasurer's Report Fiscal Year 2020-21 as of April 30, 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 April 30, 2021 CAMP Pool 20% Local Agency Investment Fund* 6% U.S. Treasury Bond / Note 25% Supra-National Agency Bond / Note 1% Municipal Bond / Note 3%Federal Agency Collaterized Mortgage 2% Asset-Back Security / Collateralized 3% Certificate of Deposit 4% Federal Agency Bond / Note 24% 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 eastvaleca.gov Dash Board Report Card CITY OF EASTVALE Treasurer's Report Fiscal Year 2020-21 as of April 30, 2021 Year Over Year Interest Income - 200,000 400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 1,600,000 1,800,000 2016-17 2017-18 2018-19 2019-20 2020-21 YTDInterest Income ReceivedFiscal Year eastvaleca.gov Cash Breakdown per Fund Balance Reserve Policy Schedule of Investments - April 30, 2021 Money Market Accounts 3,208,415$ Pooled Investment Accounts 13,705,439 PFM Managed Investments 37,649,986 Checking Account 28,242,799 Grand Total Cash - April 30, 2021 82,806,639$ Breakdown of Total Cash at April 30, 2021 Restricted Funds (Non-Discretionary Per Law)38,899,340$ Committed (Per Formal Action of City Council)30,745,000 Designated/ Assigned (Per City's Intent): Fire Operations/ Improvements (Per FY 20-21 Budget)3,445,158$ 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)12,805,628 Total Designated/ Assigned 16,250,786 Unassigned (3,088,487) Grand Total Cash - April 30, 2021 82,806,639$ Fiscal Year 2020-21 as of April 30, 2021 Treasurer's Report CITY OF EASTVALE eastvaleca.gov Investment Income Yield at Cost - April 30, 2021 1.102% Annual Investment Income Budget A 556,379$ Investment Income Received YTD: Money Market (CBB)4,132$ Money Market (PFM)19 LAIF 28,026 CAMP Pool 15,108 Certificate of Deposits 4,320 U.S. Treasury Bond/ Note 179,685 Federal Agency Bond/ Note 117,464 Asset-Backed Security/ Collateralized 104,028 Corporate Note 175,506 Supra-National Agency Bond/Note 29,310 Realized Gain/ (Loss)147,691 Total Investment Income Received-YTD 04/30/2021 B 801,157 Less Investment Fees Paid: Trust Fees-U.S. Bank (4,310) Mgmt Fee-PFM (29,280) Total Investment Fees Paid-YTD 04/30/2021 C (33,589) Net Investment Income Received-YTD 04/30/2021 B+C 767,568$ Investment Income Over/(Under) Annual Budget C-B 211,189$ % of Annual Budget 137.958% Net Yield Annualized at Cost - April 30, 2021 0.856% Fiscal Year 2020-21 as of April 30, 2021 Treasurer's Report CITY OF EASTVALE eastvaleca.gov