11. MAY 31, 2022
Introduction
Month Ending
Ending Book
Value Interest
Realized
Gain/(Loss)
Yeild at
Cost
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%
May 31, 2022 $ 131,179,470 82,495$ $ (983)0.850%
CITY OF EASTVALE
Treasurer's Report
Fiscal Year 2021-22 as of May 31, 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 May 31,
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,931$ 3,006,931$ 3,006,931$ 0.100%
First American Govt Oblig Fund CI Y 199,817 199,817 199,817 0.360%
Total Money Market 3,206,748$ 3,206,748$ 3,206,748$ 0.116%
Sweep Accounts:
Citizens Business Bank - General Sweep 9,829,245$ 9,829,245$ 9,829,245$ 0.100%
Total Sweep Accounts 9,829,245$ 9,829,245$ 9,829,245$ 0.100%
Pooled Investment Accounts:
CAMP Pool 55,422,375$ 55,422,375$ 55,422,375$ 0.820%
Local Agency Investment Fund*12,345,887 12,345,887 12,207,040 0.290%
Total Pooled Investment 67,768,262$ 67,768,262$ 67,629,415$ 0.723%
PFM Managed Investment Portfolio:
U.S. Treasury Bond / Note 16,667,000$ 16,482,811$ 15,818,390$ 1.370%
Supra-National Agency Bond / Note 845,000 844,380 808,484 0.460%
Municipal Bond / Note 1,570,000 1,573,062 1,499,825 1.120%
Federal Agency Commecial 390,664 393,834 390,975 2.140%
Asset-Back Security / Collateralized 851,488 851,397 827,873 0.850%
Certificate of Deposit 1,785,000 1,785,000 1,776,732 1.320%
Federal Agency Bond / Note 10,270,000 10,267,231 9,830,487 0.930%
Corporate Note 6,144,000 6,176,799 6,017,682 2.060%
Total PFM Managed Investments 38,523,151$ 38,374,514$ 36,970,448$ 1.327%
119,327,407$ 119,178,770$ 117,635,857$ 0.850%
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$
131,328,107$ 131,179,470$ 129,636,557$
*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 2021-22 as of May 31, 2022
ACTIVE DEPOSITS TOTAL
INACTIVE DEPOSITS TOTAL
INACTIVE DEPOSITS
ACTIVE DEPOSITS
Institution
eastvaleca.gov
Dash Board Report Card
I. PORTFOLIO DIVERSIFICATION
Money Market 2.73%Sweep 8.36%LAIF 10.38%CAMP Pool 47.11%Certificates of Deposit 1.51%U.S. Treasury Bond/ Note 13.45%Supra-National Agency Bond/Note 0.69%Municipal Bond / Note 1.27%Federal Agency Collaterized Mortgage 0.33%Asset-Backed Security/ Collateralized 0.70%Federal Agency Bond/ Note 8.36%Corporate Note 5.12%100.00%
Less Than 90 Days 69.48%90 days to Six Months (26 Weeks)0.23%Six Months to One Year (52 Weeks)1.47%One to Two Years (104 Weeks)8.52%Two to Three Years (156 Weeks)7.44%Three to Four Years (208 Weeks)11.34%Four to Five Years 1.53%Five Years +0.00%100.00%
II. PORTFOLIO PERFORMANCE MEASURES
Yield at Cost - May 31, 2022 0.850%
Annual Investment Income Budget 799,390$ A
Investment Income Received-YTD 03/31/2022 702,696 B
Less Investment Fees (36,510) C
Net Investment Income Received-YTD 03/31/2022 666,186$ B+C
Over/(Under) Annual Budget (133,204)$ C-B
% of Annual Budget 83.337%
Net Yield Annualized at Cost - May 31, 2022 0.737%
CITY OF EASTVALE
Treasurer's Report
Fiscal Year 2021-22 as of May 31, 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 May 31, 2022
CAMP Pool
53.0%
Local Agency
Investment Fund
11.7%
U.S. Treasury
Bond / Note
15.1%
Supra-National Agency
Bond / Note
0.8%
Municipal Bond / Note
1.4%
Federal Agency Commecial
0.4%
Asset-Back Security /
Collateralized
0.8%
Certificate of Deposit
1.7%
Federal Agency Bond /
Note
9.4%
Corporate Note
5.8%
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 May 31, 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 - May 31, 2022
Money Market Accounts 3,206,748$
Sweep Accounts 9,829,245
Pooled Investment Accounts 67,768,262
PFM Managed Investments 38,374,514
Checking Account 12,000,700
Grand Total Cash - May 31, 2022 131,179,470$
Breakdown of Total Cash at May 31, 2022
Restricted Funds (Non-Discretionary Per Law)35,190,294$
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 (561,523)
Grand Total Cash - May 31, 2022 131,179,470$
Fiscal Year 2021-22 as of May 31, 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 - May 31, 2022 0.850%
Annual Investment Income Budget A 799,390$
Investment Income Received YTD:
Money Market (CBB)2,758$
Sweep (CBB)36,542
Money Market (PFM)6
LAIF 9,316
CAMP Pool 52,605
Certificate of Deposits 15,849
Municipal Bond/Note 15,923
U.S. Treasury Bond/ Note 138,055
Federal Agency Bond/ Note 125,096
Federal Agency Commercial Mortgage Backed Security 12,263
Asset-Backed Security 31,702
Corporate Note 129,801
Supra-National Agency Bond/Note 2,113
Realized Gain/ (Loss)130,667
Total Investment Income Received-YTD 03/31/2022 B 702,696
Less Investment Fees Paid:
Trust Fees-U.S. Bank (3,672)
Mgmt Fee-PFM (32,838)
Total Investment Fees Paid-YTD 05/31/2022 C (36,510)
Net Investment Income Received-YTD 05/31/2022 B+C 666,186$
Investment Income Over/(Under) Annual Budget C-B (133,204)$
% of Annual Budget 83.337%
Net Yield Annualized at Cost - May 31, 2022 0.737%
Fiscal Year 2021-22 as of May 31, 2022
Treasurer's Report
CITY OF EASTVALE
Prepared by the Finance Department in accordance with the adopted Investment Policy eastvaleca.gov