10. APRIL 30, 2022
Introduction
Month Ending
Ending Book
Value Interest
Realized
Gain/(Loss)
Yeild at
Cost
May 31, 2021 $ 92,628,493 51,795$ $ 13,425 1.081%
June 30, 2021 $ 99,802,173 57,091$ $ 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 48,744$ $ 18,495 0.496%
March 31, 2022 $ 128,945,337 40,531$ $ 2,088 0.506%
April 30, 2022 $ 128,533,660 43,611$ $ (1,239)0.642%
CITY OF EASTVALE
Treasurer's Report
Fiscal Year 2021-22 as of April 30, 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 April 30,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,668$ 3,006,668$ 3,006,668$ 0.100%
First American Govt Oblig Fund CI Y 199,817 199,817 199,817 0.010%
Total Money Market 3,206,484$ 3,206,484$ 3,206,484$ 0.094%
Sweep Accounts:
Citizens Business Bank - General Sweep 27,335,142$ 27,335,142$ 27,335,142$ 0.100%
Total Sweep Accounts 27,335,142$ 27,335,142$ 27,335,142$ 0.100%
Pooled Investment Accounts:
CAMP Pool 35,384,120$ 35,384,120$ 35,384,120$ 0.500%
Local Agency Investment Fund*12,345,887 12,345,887 12,207,040 0.290%
Total Pooled Investment 47,730,007$ 47,730,007$ 47,591,160$ 0.446%
PFM Managed Investment Portfolio:
U.S. Treasury Bond / Note 16,447,000$ 16,279,331$ 15,524,044$ 1.350%
Supra-National Agency Bond / Note 845,000 844,351 804,143 0.460%
Municipal Bond / Note 1,570,000 1,573,235 1,495,021 1.120%
Federal Agency Commecial 438,843 442,594 438,756 2.170%
Asset-Back Security / Collateralized 891,673 891,579 866,074 0.930%
Certificate of Deposit 1,785,000 1,785,000 1,776,115 1.320%
Federal Agency Bond / Note 10,270,000 10,267,259 9,785,243 0.930%
Corporate Note 6,144,000 6,177,977 5,973,098 2.060%
Total PFM Managed Investments 38,391,516$ 38,261,326$ 36,662,494$ 1.321%
116,663,150$ 116,532,960$ 114,795,279$ 0.642%
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$
128,663,850$ 128,533,660$ 126,795,979$
*yield as of the prior quarter end
CITY OF EASTVALE
Treasurer's Report
Fiscal Year 2021-22 as of April 30, 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.79%Sweep 23.81%LAIF 10.63%CAMP Pool 30.82%Certificates of Deposit 1.55%U.S. Treasury Bond/ Note 13.52%Supra-National Agency Bond/Note 0.70%Municipal Bond / Note 1.30%Federal Agency Collaterized Mortgage 0.38%Asset-Backed Security/ Collateralized 0.75%Federal Agency Bond/ Note 8.52%Corporate Note 5.20%100.00%
Less Than 90 Days 68.33%90 days to Six Months (26 Weeks)0.93%Six Months to One Year (52 Weeks)1.01%One to Two Years (104 Weeks)8.61%Two to Three Years (156 Weeks)7.72%Three to Four Years (208 Weeks)11.79%Four to Five Years 1.61%Five Years +0.00%100.00%
II. PORTFOLIO PERFORMANCE MEASURES
Yield at Cost - April 30, 2022 0.642%
Annual Investment Income Budget 799,390$ A
Investment Income Received-YTD 03/31/2022 620,201 B
Less Investment Fees (33,113) C
Net Investment Income Received-YTD 03/31/2022 587,087$ B+C
Over/(Under) Annual Budget (212,303)$ C-B
% of Annual Budget 73.442%
Net Yield Annualized at Cost - April 30, 2022 0.537%
CITY OF EASTVALE
Treasurer's Report
Fiscal Year 2021-22 as of April 30, 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 April 30, 2022
CAMP Pool
42.0%
Local Agency
Investment Fund
14.5%U.S. Treasury
Bond / Note
18.4%
Supra-National Agency
Bond / Note
1.0%
Municipal Bond / Note
1.8%
Federal Agency Commecial
0.5%
Asset-Back Security /
Collateralized
1.0%
Certificate of Deposit
2.1%
Federal Agency Bond /
Note
11.6%
Corporate Note
7.1%
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 April 30, 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 - April 30, 2022
Money Market Accounts 3,206,484$
Sweep Accounts 27,335,142
Pooled Investment Accounts 47,730,007
PFM Managed Investments 38,261,326
Checking Account 12,000,700
Grand Total Cash - April 30, 2022 128,533,660$
Breakdown of Total Cash at April 30, 2022
Restricted Funds (Non-Discretionary Per Law)34,480,527$
Committed (Per Formal Action of City Council)73,455,029
Designated/ Assigned (Per City's Intent):
Fire Operations
(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 (2,497,566)
Grand Total Cash - April 30, 2022 128,533,660$
Fiscal Year 2021-22 as of April 30, 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 - April 30, 2022 0.642%
Annual Investment Income Budget A 799,390$
Investment Income Received YTD:
Money Market (CBB)2,495$
Sweep (CBB)35,720
Money Market (PFM)5
LAIF 9,316
CAMP Pool 14,350
Certificate of Deposits 15,849
Municipal Bond/Note 14,085
U.S. Treasury Bond/ Note 135,386
Federal Agency Bond/ Note 94,477
Federal Agency Commercial Mortgage Backed Security 5,754
Asset-Backed Security 30,548
Corporate Note 128,803
Supra-National Agency Bond/Note 1,763
Realized Gain/ (Loss)131,650
Total Investment Income Received-YTD 03/31/2022 B 620,201
Less Investment Fees Paid:
Trust Fees-U.S. Bank (3,336)
Mgmt Fee-PFM (29,777)
Total Investment Fees Paid-YTD 04/30/2022 C (33,113)
Net Investment Income Received-YTD 04/30/2022 B+C 587,087$
Investment Income Over/(Under) Annual Budget C-B (212,303)$
% of Annual Budget 73.442%
Net Yield Annualized at Cost - April 30, 2022 0.537%
Fiscal Year 2021-22 as of April 30, 2022
Treasurer's Report
CITY OF EASTVALE
Prepared by the Finance Department in accordance with the adopted Investment Policy eastvaleca.gov