09. MARCH 31, 2022
Introduction
Month Ending
Ending Book
Value Interest
Realized
Gain/(Loss)
Yeild at
Cost
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%
March 31, 2022 $ 128,945,337 42,619$ $ 2,088 0.506%
CITY OF EASTVALE
Treasurer's Report
Fiscal Year 2021-22 as of March 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 March 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,429$ 3,006,429$ 3,006,429$ 0.100%
First American Govt Oblig Fund CI Y 93,868 93,868 93,868 0.010%
Total Money Market 3,100,297$ 3,100,297$ 3,100,297$ 0.097%
Sweep Accounts:
Citizens Business Bank - General Sweep 61,713,833$ 61,713,833$ 61,713,833$ 0.100%
Total Sweep Accounts 61,713,833$ 61,713,833$ 61,713,833$ 0.100%
Pooled Investment Accounts:
CAMP Pool 10,375,599$ 10,375,599$ 10,375,599$ 0.250%
Local Agency Investment Fund*3,343,253 3,343,253 3,334,691 0.210%
Total Pooled Investment 13,718,851$ 13,718,851$ 13,710,290$ 0.240%
PFM Managed Investment Portfolio:
U.S. Treasury Bond / Note 15,882,000$ 15,756,362$ 15,158,977$ 1.300%
Supra-National Agency Bond / Note 845,000 844,323 808,815 0.460%
Municipal Bond / Note 1,570,000 1,573,402 1,507,732 1.120%
Federal Agency Commecial 562,772 567,050 565,058 2.260%
Asset-Back Security / Collateralized 937,327 937,228 916,236 1.010%
Certificate of Deposit 2,310,000 2,310,000 2,305,644 1.440%
Federal Agency Bond / Note 10,270,000 10,267,287 9,863,921 0.930%
Corporate Note 6,044,000 6,081,353 5,957,382 1.920%
Total PFM Managed Investments 38,421,099$ 38,337,006$ 37,083,764$ 1.289%
116,954,080$ 116,869,987$ 115,608,183$ 0.506%
Checking Account:
Citizens Business Bank - General Account 12,074,650$ 12,074,650$ 12,074,650$ 0.000%
Citizens Business Bank - HdL Holding 700$ 700$ 700$ 0.000%
Total Inactive Deposits 12,075,350$ 12,075,350$ 12,075,350$ 0.000%
12,075,350$ 12,075,350$ 12,075,350$
129,029,430$ 128,945,337$ 127,683,533$
*yield as of the prior quarter end
CITY OF EASTVALE
Treasurer's Report
Fiscal Year 2021-22 as of March 31, 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.68%Sweep 53.38%LAIF 2.88%CAMP Pool 8.97%Certificates of Deposit 1.99%U.S. Treasury Bond/ Note 13.11%Supra-National Agency Bond/Note 0.70%Municipal Bond / Note 1.30%Federal Agency Collaterized Mortgage 0.49%Asset-Backed Security/ Collateralized 0.79%Federal Agency Bond/ Note 8.53%Corporate Note 5.15%100.00%
Less Than 90 Days 67.98%90 days to Six Months (26 Weeks)1.44%Six Months to One Year (52 Weeks)1.34%One to Two Years (104 Weeks)8.88%Two to Three Years (156 Weeks)5.61%Three to Four Years (208 Weeks)13.33%Four to Five Years 1.42%Five Years +0.00%100.00%
II. PORTFOLIO PERFORMANCE MEASURES
Yield at Cost - March 31, 2022 0.506%
Annual Investment Income Budget 799,390$ A
Investment Income Received-YTD 03/31/2022 577,829 B
Less Investment Fees (30,042) C
Net Investment Income Received-YTD 03/31/2022 547,786$ B+C
Over/(Under) Annual Budget (251,604)$ C-B
% of Annual Budget 68.526%
Net Yield Annualized at Cost - March 31, 2022 0.408%
CITY OF EASTVALE
Treasurer's Report
Fiscal Year 2021-22 as of March 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 March 31, 2022
CAMP Pool
20.4%
Local Agency Investment
Fund
6.6%U.S. Treasury Bond / Note
29.8%Supra-National Agency
Bond / Note
1.6%
Municipal Bond / Note
3.0%
Federal Agency Commecial
1.1%
Asset-Back Security /
Collateralized
1.8%
Certificate of Deposit
4.5%
Federal Agency Bond / Note
19.4%
Corporate Note
11.7%
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 March 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 - March 31, 2022
Money Market Accounts 3,100,297$
Sweep Accounts 61,713,833
Pooled Investment Accounts 13,718,851
PFM Managed Investments 38,337,006
Checking Account 12,075,350
Grand Total Cash - March 31, 2022 128,945,337$
Breakdown of Total Cash at March 31, 2022
Restricted Funds (Non-Discretionary Per Law)34,590,964$
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,196,326)
Grand Total Cash - March 31, 2022 128,945,337$
Fiscal Year 2021-22 as of March 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 - March 31, 2022 0.506%
Annual Investment Income Budget A 799,390$
Investment Income Received YTD:
Money Market (CBB)2,256$
Sweep (CBB)31,867
Money Market (PFM)5
LAIF 6,681
CAMP Pool 5,828
Certificate of Deposits 15,849
Municipal Bond/Note 9,765
U.S. Treasury Bond/ Note 135,481
Federal Agency Bond/ Note 87,368
Federal Agency Commercial Mortgage Backed Security 4,979
Asset-Backed Security 29,124
Corporate Note 113,974
Supra-National Agency Bond/Note 1,763
Realized Gain/ (Loss)132,889
Total Investment Income Received-YTD 03/31/2022 B 577,829
Less Investment Fees Paid:
Trust Fees-U.S. Bank (3,006)
Mgmt Fee-PFM (27,037)
Total Investment Fees Paid-YTD 03/31/2022 C (30,042)
Net Investment Income Received-YTD 03/31/2022 B+C 547,786$
Investment Income Over/(Under) Annual Budget C-B (251,604)$
% of Annual Budget 68.526%
Net Yield Annualized at Cost - March 31, 2022 0.408%
Fiscal Year 2021-22 as of March 31, 2022
Treasurer's Report
CITY OF EASTVALE
Prepared by the Finance Department in accordance with the adopted Investment Policy eastvaleca.gov