Loading...
08. FEBRUARY 28, 2022 Introduction Month Ending Ending Book Value Interest Unrealized Gain/(Loss) Yeild at Cost March 31, 2021 $ 82,572,447 51,795$ $ 445 1.141% April 30, 2021 82,806,639 57,091 8,964 1.102% May 31, 2021 92,628,493 28,920 13,425 1.081% June 30, 2021 99,802,173 70,198 7,057 1.065% July 31, 2021 101,225,837 31,327 840 0.781% August 31, 2021 104,175,256 82,937 22,140 0.655% September 30, 2021 106,587,623 38,052 22,376 0.629% October 31, 2021 107,164,395 40,440 1,220 0.611% November 30, 2021 112,132,172 57,396 35,708 0.575% December 31, 2021 116,355,758 58,476 44,609 0.542% January 31, 2022 120,564,268 47,036 (14,587)0.518% February 28, 2022 126,190,574 67,240 18,495 0.496% CITY OF EASTVALE Treasurer's Report Fiscal Year 2021-22 as of February 28, 2022 In accordance with the City Investment Policy,a quarterly investment report shall be filed with the City Council which provides a clear picture of the status of the current investments.The report for the month ending February 28,2022 has been prepared by City Staff.We hereby certify that this report accurately reflects all pooled investments and is in compliance with the City’s Investment Policy. Combined with anticipated revenues,the portfolio contains sufficient investment liquidity to meet budgeted expenditures for the next six months. 12 MONTH BALANCES eastvaleca.gov Schedule of Investments Par Value Book Value Price @ Cost (Fair Value) Market Value Yield Money Market Accounts: Citizens Business Bank - Money Market 3,006,174$ 3,006,174$ 3,006,174$ 0.100% First American Govt Oblig Fund CI Y 99,566 99,566 99,566 0.010% Total Money Market 3,105,739$ 3,105,739$ 3,105,739$ 0.097% Sweep Accounts: Citizens Business Bank - General Sweep 59,066,345$ 59,066,345$ 59,066,345$ 0.100% Total Sweep Accounts 59,066,345$ 59,066,345$ 59,066,345$ 0.100% Pooled Investment Accounts: CAMP Pool 10,373,371$ 10,373,371$ 10,373,371$ 0.060% Local Agency Investment Fund*3,343,253 3,343,253 3,334,691 0.210% Total Pooled Investment 13,716,624$ 13,716,624$ 13,708,062$ 0.097% PFM Managed Investment Portfolio: U.S. Treasury Bond / Note 15,607,000$ 15,492,445$ 15,258,129$ 1.300% Supra-National Agency Bond / Note 845,000 844,295 823,374 0.460% Municipal Bond / Note 1,570,000 1,573,575 1,541,274 1.120% Federal Agency Collaterized Mortgage 595,210 599,788 600,822 2.280% Asset-Back Security / Collateralized 983,045 982,941 970,481 1.080% Certificate of Deposit 2,310,000 2,310,000 2,313,635 1.440% Federal Agency Bond / Note 10,800,000 10,798,084 10,579,075 0.960% Corporate Note 5,654,000 5,700,038 5,665,032 1.870% Total PFM Managed Investments 38,364,255$ 38,301,165$ 37,751,823$ 1.281% 114,252,963$ 114,189,874$ 113,631,970$ 0.496% Checking Account: Citizens Business Bank - General Account 12,000,000$ 12,000,000$ 12,000,000$ 0.000% Citizens Business Bank - HdL Holding 700$ 700$ 700$ 0.000% Total Inactive Deposits 12,000,700$ 12,000,700$ 12,000,700$ 0.000% 12,000,700$ 12,000,700$ 12,000,700$ 126,253,663$ 126,190,574$ 125,632,670$ *yield as of the prior quarter end CITY OF EASTVALE Treasurer's Report Fiscal Year 2021-22 as of February 28, 2022 ACTIVE DEPOSITS TOTAL INACTIVE DEPOSITS TOTAL INACTIVE DEPOSITS ACTIVE DEPOSITS Institution 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. eastvaleca.gov Dash Board Report Card I. PORTFOLIO DIVERSIFICATION Money Market 2.73%Sweep 51.98%LAIF 2.93%CAMP Pool 9.13%Certificates of Deposit 2.04%U.S. Treasury Bond/ Note 13.43%Supra-National Agency Bond/Note 0.72%Municipal Bond / Note 1.36%Federal Agency Collaterized Mortgage 0.53%Asset-Backed Security/ Collateralized 0.85%Federal Agency Bond/ Note 9.31%Corporate Note 4.99%100.00% Less Than 90 Days 66.94%90 days to Six Months (26 Weeks)1.55%Six Months to One Year (52 Weeks)1.10%One to Two Years (104 Weeks)8.82%Two to Three Years (156 Weeks)6.66%Three to Four Years (208 Weeks)13.10%Four to Five Years 1.82%Five Years +0.00%100.00% II. PORTFOLIO PERFORMANCE MEASURES Yield at Cost - February 28, 2022 0.496% Annual Investment Income Budget 799,390$ A Investment Income Received-YTD 02/28/2022 535,210 B Less Investment Fees (26,674) C Net Investment Income Received-YTD 02/28/2022 508,536$ B+C Over/(Under) Annual Budget (290,854)$ C-B % of Annual Budget 63.615% Net Yield Annualized at Cost - February 28, 2022 0.404% CITY OF EASTVALE Treasurer's Report Fiscal Year 2021-22 as of February 28, 2022 DIVERSIFICATION BY INSTRUMENT DIVERSIFICATION BY MATURITY Prepared by the Finance Department in accordance with the adopted Investment Policy eastvaleca.gov Dash Board Report Card Diversification by Maturity Diversification by Investment CITY OF EASTVALE Treasurer's Report Fiscal Year 2021-22 as of February 28, 2022 CAMP Pool 20.2% Local Agency Investment Fund 6.5%U.S. Treasury Bond / Note 29.7% Supra-National Agency Bond / Note 1.6% Municipal Bond / Note 3.0% Federal Agency Collaterized Mortgage 1.2% Asset-Back Security / Collateralized 1.9% Certificate of Deposit 4.5% Federal Agency Bond / Note 20.6% Corporate Note 11.0% 0% 10% 20% 30% 40% 50% 60% 70% 80% 0 - 0.25 0.25 - 0.50 0.50 - 1 1 - 2 2 - 3 3 - 4 4 - 5 >5% of PortfolioMaturity in Years Prepared by the Finance Department in accordance with the adopted Investment Policy eastvaleca.gov Dash Board Report Card CITY OF EASTVALE Treasurer's Report Fiscal Year 2021-22 as of February 28, 2022 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 2017-18 2018-19 2019-20 2020-21 2021-22 YTDInterest Income ReceivedFiscal Year Prepared by the Finance Department in accordance with the adopted Investment Policy eastvaleca.gov Cash Breakdown per Fund Balance Reserve Policy Schedule of Investments - February 28, 2022 Money Market Accounts 3,105,739$ Sweep Accounts 59,066,345 Pooled Investment Accounts 13,716,624 PFM Managed Investments 38,301,165 Checking Account 12,000,700 Grand Total Cash - February 28, 2022 126,190,574$ Breakdown of Total Cash at February 28, 2022 Restricted Funds (Non-Discretionary Per Law)21,592,380$ Committed (Per Formal Action of City Council)73,455,029 Designated/ Assigned (Per City's Intent): Fire Operations/ Improvements (Per FY 21-22 Budget)5,169,363$ General Fund Emergency Contingency: To meet City's cash obligations for the next six months General Fund Adopted Budget Expenditures - FY 2021-22 (Per Fund Balance Reserve Policy)17,926,307 Total Designated/ Assigned 23,095,670 Unassigned 8,047,495 Grand Total Cash - February 28, 2022 126,190,574$ Fiscal Year 2021-22 as of February 28, 2022 Treasurer's Report CITY OF EASTVALE Prepared by the Finance Department in accordance with the adopted Investment Policy eastvaleca.gov Investment Income Detail Yield at Cost - February 28, 2022 0.496% Annual Investment Income Budget A 799,390$ Investment Income Received YTD: Money Market (CBB)2,001$ Sweep (CBB)26,858 Money Market (PFM)5 LAIF 6,681 CAMP Pool 3,601 Certificate of Deposits 14,143 Municipal Bond/Note 9,765 U.S. Treasury Bond/ Note 131,310 Federal Agency Bond/ Note 76,307 Federal Agency Commercial Mortgage Backed Security 2,044 Asset-Backed Security 27,680 Corporate Note 103,665 Supra-National Agency Bond/Note 350 Realized Gain/ (Loss)130,802 Total Investment Income Received-YTD 02/28/2022 B 535,210 Less Investment Fees Paid: Trust Fees-U.S. Bank (2,666) Mgmt Fee-PFM (24,009) Total Investment Fees Paid-YTD 02/28/2022 C (26,674) Net Investment Income Received-YTD 02/28/2022 B+C 508,536$ Investment Income Over/(Under) Annual Budget C-B (290,854)$ % of Annual Budget 63.615% Net Yield Annualized at Cost - February 28, 2022 0.404% Fiscal Year 2021-22 as of February 28, 2022 Treasurer's Report CITY OF EASTVALE Prepared by the Finance Department in accordance with the adopted Investment Policy eastvaleca.gov