05. NOVEMBER 30 ,2021
Schedule of Investments
Par Value
Book Value Price
@ Cost
(Fair Value)
Market Value Yield
Money Market Accounts:
Citizens Business Bank - Money Market 3,005,432$ 3,005,432$ 3,005,432$ 0.100%
First American Govt Oblig Fund CI Y 164,973 164,973 164,973 0.010%
Total Money Market 3,170,406$ 3,170,406$ 3,170,406$ 0.095%
Sweep Accounts:
Citizens Business Bank - General Sweep 45,067,252$ 45,067,252$ 45,067,252$ 0.100%
Total Sweep Accounts 45,067,252$ 45,067,252$ 45,067,252$ 0.100%
Pooled Investment Accounts:
CAMP Pool 10,371,987$ 10,371,987$ 10,371,987$ 0.050%
Local Agency Investment Fund*3,341,329 3,341,329 3,340,907 0.300%
Total Pooled Investment 13,713,316$ 13,713,316$ 13,712,893$ 0.111%
PFM Managed Investment Portfolio:
U.S. Treasury Bond / Note 15,162,000$ 15,089,505$ 15,183,209$ 1.350%
Supra-National Agency Bond / Note 845,000 844,211 835,801 0.460%
Municipal Bond / Note 1,570,000 1,574,077 1,576,256 1.120%
Federal Agency Collaterized Mortgage 769,780 775,294 783,298 2.350%
Asset-Back Security / Collateralized 1,147,953 1,147,834 1,147,068 1.300%
Certificate of Deposit 1,930,000 1,930,000 1,947,511 1.510%
Federal Agency Bond / Note 10,800,000 10,798,317 10,780,581 0.960%
Corporate Note 5,909,000 5,951,533 6,008,631 2.030%
Total PFM Managed Investments 38,133,733$ 38,110,769$ 38,262,355$ 1.343%
100,084,706$ 100,061,742$ 100,212,906$ 0.575%
Checking Account:
Citizens Business Bank - General Account 12,061,088$ 12,061,088$ 12,061,088$ 0.000%
Citizens Business Bank - HdL Holding 9,342$ 9,342$ 9,342$ 0.000%
Total Inactive Deposits 12,070,430$ 12,070,430$ 12,070,430$ 0.000%
12,070,430$ 12,070,430$ 12,070,430$
112,155,136$ 112,132,172$ 112,283,336$
*yield as of the prior quarter end
CITY OF EASTVALE
Treasurer's Report
Fiscal Year 2021-22 as of November 30, 2021
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 3.16%Sweep 44.97%LAIF 3.33%CAMP Pool 10.35%Certificates of Deposit 1.94%U.S. Treasury Bond/ Note 15.15%Supra-National Agency Bond/Note 0.83%Municipal Bond / Note 1.57%Federal Agency Collaterized Mortgage 0.78%Asset-Backed Security/ Collateralized 1.14%Federal Agency Bond/ Note 10.76%Corporate Note 6.00%100.00%
Less Than 90 Days 59.60%90 days to Six Months (26 Weeks)0.54%Six Months to One Year (52 Weeks)2.36%One to Two Years (104 Weeks)10.39%Two to Three Years (156 Weeks)6.19%Three to Four Years (208 Weeks)12.04%Four to Five Years 5.55%Five Years +0.00%96.67%
II. PORTFOLIO PERFORMANCE MEASURES
Yield at Cost - November 30, 2021 0.575%
Annual Investment Income Budget 799,390$
Investment Income Received: Money Market 1,263$ Sweep 14,541 LAIF 4,758 CAMP Pool 2,216 Certificate of Deposits - U.S. Treasury Bond/ Note 80,055 Federal Agency Bond/ Note 44,378 Asset-Backed Security/ Collateralized 21,475 Corporate Note 74,958 Supra-National Agency Bond/Note 350 Realized Gain/ (Loss)82,284 Total Investment Income Received-YTD 11/30/2021 326,278
Less Investment Fees Paid: Trust Fees-U.S. Bank (1,666) Mgmt Fee-PFM (15,000) Total Investment Fees Paid-YTD 11/30/2021 (16,666)
Net Investment Income Received-YTD 11/30/2021 309,611$
Over/(Under) Annual Budget (489,779)$ % of Annual Budget 38.731%
Net Yield Annualized at Cost - November 30, 2021 0.508%
CITY OF EASTVALE
Treasurer's Report
Fiscal Year 2021-22 as of November 30, 2021
DIVERSIFICATION BY INSTRUMENT
DIVERSIFICATION BY MATURITY (DOES NOT INCLUDE LAIF)
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 November 30, 2021
CAMP Pool
20.0%
Local Agency Investment
Fund
6.4%U.S. Treasury Bond / Note
29.2%
Supra-National Agency
Bond / Note
1.6%
Municipal Bond / Note
3.0%
Federal Agency Collaterized
Mortgage
1.5%
Asset-Back Security /
Collateralized
2.2%
Certificate of Deposit
3.7%
Federal Agency Bond / Note
20.7%
Corporate Note
11.6%
0%
10%
20%
30%
40%
50%
60%
70%
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 November 30, 2021
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 - November 30, 2021
Money Market Accounts 3,170,406$
Sweep Accounts 45,067,252
Pooled Investment Accounts 13,713,316
PFM Managed Investments 38,110,769
Checking Account 12,070,430
Grand Total Cash - November 30, 2021 112,132,172$
Breakdown of Total Cash at November 30, 2021
Restricted Funds (Non-Discretionary Per Law)41,413,348$
Committed (Per Formal Action of City Council)31,065,500
Designated/ Assigned (Per City's Intent):
Fire Operations/ Improvements
(Per FY 21-22 Budget)4,966,263$
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)13,133,584
Total Designated/ Assigned 18,099,847
Unassigned 21,553,477
Grand Total Cash - November 30, 2021 112,132,172$
Fiscal Year 2021-22 as of November 30, 2021
Treasurer's Report
CITY OF EASTVALE
Prepared by the Finance Department in accordance with the adopted Investment Policy eastvaleca.gov
Investment Income
Yield at Cost - November 30, 2021 0.575%
Annual Investment Income Budget A 799,390$
Investment Income Received YTD:
Money Market (CBB)1,260$
Sweep (CBB)14,541
Money Market (PFM)3
LAIF 4,758
CAMP Pool 2,216
Certificate of Deposits -
Municipal Bond/Note 6,159
U.S. Treasury Bond/ Note 80,055
Federal Agency Bond/ Note 44,378
Asset-Backed Security/ Collateralized 21,475
Corporate Note 74,958
Supra-National Agency Bond/Note 350
Realized Gain/ (Loss)82,284
Total Investment Income Received-YTD 11/30/2021 B 332,436
Less Investment Fees Paid:
Trust Fees-U.S. Bank (1,666)
Mgmt Fee-PFM (15,000)
Total Investment Fees Paid-YTD 11/30/2021 C (16,666)
Net Investment Income Received-YTD 11/30/2021 B+C 315,770$
Investment Income Over/(Under) Annual Budget C-B (483,620)$
% of Annual Budget 39.501%
Net Yield Annualized at Cost - November 30, 2021 0.508%
Fiscal Year 2021-22 as of November 30, 2021
Treasurer's Report
CITY OF EASTVALE
Prepared by the Finance Department in accordance with the adopted Investment Policy eastvaleca.gov