12. JUNE 30, 2022
Introduction
Month Ending
Ending Book
Value Interest
Realized
Gain/(Loss)
Yeild at
Cost
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.642%
June 30, 2022 $ 138,570,047 99,770$ $ (7,937)0.966%
CITY OF EASTVALE
Treasurer's Report
Fiscal Year 2021-22 as of June 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 June
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,007,179$ 3,007,179$ 3,007,179$ 0.100%
First American Govt Oblig Fund CI Y 209,067 209,067 209,067 1.000%
Total Money Market 3,216,245$ 3,216,245$ 3,216,245$ 0.159%
Sweep Accounts:
Citizens Business Bank - General Sweep 17,061,380$ 17,061,380$ 17,061,380$ 0.100%
Total Sweep Accounts 17,061,380$ 17,061,380$ 17,061,380$ 0.100%
Pooled Investment Accounts:
CAMP Pool 55,474,271$ 55,474,271$ 55,474,271$ 1.140%
Local Agency Investment Fund*12,345,887 12,345,887 12,207,040 0.290%
Total Pooled Investment 67,820,158$ 67,820,158$ 67,681,310$ 0.985%
PFM Managed Investment Portfolio:
U.S. Treasury Bond / Note 17,832,000$ 17,565,573$ 16,773,006$ 1.480%
Supra-National Agency Bond / Note 845,000 844,408 803,769 0.460%
Municipal Bond / Note 1,570,000 1,572,895 1,493,708 1.120%
Federal Agency Commecial 303,095 305,927 302,032 2.050%
Asset-Back Security / Collateralized 817,102 817,015 790,139 0.770%
Certificate of Deposit 1,495,000 1,495,000 1,482,838 1.440%
Federal Agency Bond / Note 9,695,000 9,692,716 9,203,318 0.960%
Corporate Note 6,019,000 6,051,015 5,819,594 2.030%
Total PFM Managed Investments 38,576,197$ 38,344,551$ 36,668,404$ 1.386%
126,673,980$ 126,442,334$ 124,627,340$ 0.966%
Checking Account:
Citizens Business Bank - General Account 12,127,013$ 12,127,013$ 12,127,013$ 0.000%
Citizens Business Bank - HdL Holding 700$ 700$ 700$ 0.000%
Total Inactive Deposits 12,127,713$ 12,127,713$ 12,127,713$ 0.000%
12,127,713$ 12,127,713$ 12,127,713$
138,801,693$ 138,570,047$ 136,755,053$
*yield as of the prior quarter end
CITY OF EASTVALE
Treasurer's Report
Fiscal Year 2021-22 as of June 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.58%Sweep 13.69%LAIF 9.79%CAMP Pool 44.51%Certificates of Deposit 1.19%U.S. Treasury Bond/ Note 13.46%Supra-National Agency Bond/Note 0.64%Municipal Bond / Note 1.20%Federal Agency Collaterized Mortgage 0.24%Asset-Backed Security/ Collateralized 0.63%Federal Agency Bond/ Note 7.38%Corporate Note 4.67%100.00%
Less Than 90 Days 71.14%90 days to Six Months (26 Weeks)0.43%Six Months to One Year (52 Weeks)1.81%One to Two Years (104 Weeks)6.85%Two to Three Years (156 Weeks)7.59%Three to Four Years (208 Weeks)10.82%Four to Five Years 1.35%Five Years +0.00%100.00%
II. PORTFOLIO PERFORMANCE MEASURES
Yield at Cost - June 30, 2022 0.966%
Annual Investment Income Budget 799,390$ A
Investment Income Received-YTD 06/30/2022 802,466 B
Less Investment Fees (39,727) C
Net Investment Income Received-YTD 06/30/2022 762,739$ B+C
Over/(Under) Annual Budget (36,651)$ C-B
% of Annual Budget 95.415%
Net Yield Annualized at Cost - June 30, 2022 0.853%
CITY OF EASTVALE
Treasurer's Report
Fiscal Year 2021-22 as of June 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 June 30, 2022
CAMP Pool
53.2%
Local Agency
Investment Fund
11.7%
U.S. Treasury
Bond / Note
16.1%
Supra-National Agency
Bond / Note
0.8%
Municipal Bond / Note
1.4%
Federal Agency Commecial
0.3%
Asset-Back Security /
Collateralized
0.8%
Certificate of Deposit
1.4%
Federal Agency Bond /
Note
8.8%Corporate Note
5.6%
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 June 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 - June 30, 2022
Money Market Accounts 3,216,245$
Sweep Accounts 17,061,380
Pooled Investment Accounts 67,820,158
PFM Managed Investments 38,344,551
Checking Account 12,127,713
Grand Total Cash - June 30, 2022 138,570,047$
Breakdown of Total Cash at June 30, 2022
Restricted Funds (Non-Discretionary Per Law)37,172,895$
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 4,846,453
Grand Total Cash - June 30, 2022 138,570,047$
Fiscal Year 2021-22 as of June 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 - June 30, 2022 0.966%
Annual Investment Income Budget A 799,390$
Investment Income Received YTD:
Money Market (CBB)3,006$
Sweep (CBB)37,507
Money Market (PFM)19
LAIF 9,316
CAMP Pool 104,500
Certificate of Deposits 18,634
Municipal Bond/Note 15,923
U.S. Treasury Bond/ Note 162,974
Federal Agency Bond/ Note 148,163
Federal Agency Commercial Mortgage Backed Security 14,531
Asset-Backed Security 32,653
Corporate Note 130,398
Supra-National Agency Bond/Note 2,113
Realized Gain/ (Loss)122,730
Total Investment Income Received-YTD 06/30/2022 B 802,466
Less Investment Fees Paid:
Trust Fees-U.S. Bank (3,978)
Mgmt Fee-PFM (35,749)
Total Investment Fees Paid-YTD 06/30/2022 C (39,727)
Net Investment Income Received-YTD 06/30/2022 B+C 762,739$
Investment Income Over/(Under) Annual Budget C-B (36,651)$
% of Annual Budget 95.415%
Net Yield Annualized at Cost - June 30, 2022 0.853%
Fiscal Year 2021-22 as of June 30, 2022
Treasurer's Report
CITY OF EASTVALE
Prepared by the Finance Department in accordance with the adopted Investment Policy eastvaleca.gov