05. NOVEMEBER 30, 2023Introduction
Month Ending
Active Deposits
Ending Book
Value
Inactive
Deposits
Ending Book
Value Interest
Realized
Gain/(Loss)
Yield at
Cost
December 31, 2022 $ 148,512,941 $ 12,000,700 308,283$ $ (8,044)2.833%
January 31, 2023 154,418,779 12,000,700 390,849 (26,577)3.303%
February 28, 2023 162,629,841 12,016,072 407,911 (116)3.274%
March 31, 2023 162,694,333 12,001,949 408,993 (14,774)3.304%
April 30, 2023 167,020,458 12,034,275 425,285 (14,092)3.366%
May 31, 2023 172,587,028 12,052,233 495,818 (6,939)3.410%
June 30, 2023 177,726,380 12,006,037 456,894 (15,281)3.337%
July 31, 2023 176,282,165 12,355,943 506,040 (116,443)3.513%
August 31, 2023 178,926,480 12,437,030 539,415 (139,395)3.639%
September 30, 2023 183,237,505 12,006,536 488,349 (164,751)3.637%
October 31, 2023 182,724,022 12,394,050 589,614 (29,059)3.690%
November 30, 2023 183,475,275 12,054,647 535,918 (5,426)3.713%
CITY OF EASTVALE
Treasurer's Report
Fiscal Year 2023-24 as of November 30, 2023
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 November 30,2023 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
Prepared by the Finance Department in accordance with the adopted Investment Policy 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,011,449$ 3,011,449$ 3,011,449$ 0.100%
First American Govt Oblig Fund CI Y 27,562 27,562 27,562 4.980%
Total Money Market 3,039,011$ 3,039,011$ 3,039,011$ 0.144%
Sweep Accounts:
Citizens Business Bank - General Sweep 38,465,122$ 38,465,122$ 38,465,122$ 0.100%
Total Sweep Accounts 38,465,122$ 38,465,122$ 38,465,122$ 0.100%
Pooled Investment Accounts:
CAMP Pool 101,280,971$ 101,280,971$ 101,280,971$ 5.580%
Local Agency Investment Fund*1,429,493 1,429,493 1,407,805 3.590%
Total Pooled Investment 102,710,463$ 102,710,463$ 102,688,776$ 5.552%
PFM Managed Investment Portfolio:
U.S. Treasury Bond / Note 18,620,000$ 18,068,539$ 17,144,595$ 2.280%
U.S. Treasury Bill 210,000 209,816 209,815 5.270%
Supra-National Agency Bond / Note 565,000 564,887 543,694 0.520%
Municipal Bond / Note 1,110,000 1,110,313 1,052,558 0.780%
Federal Agency Commercial 4,836,961 4,739,105 4,739,895 4.940%
Asset-Back Security / Collateralized 1,735,833 1,735,609 1,728,734 4.350%
Certificate of Deposit 720,000 720,000 712,766 5.260%
Federal Agency Bond / Note 4,220,000 4,215,894 3,927,161 0.560%
Bank Note 555,000 554,311 557,082 5.500%
Corporate Note 7,364,000 7,342,206 7,132,994 3.130%
Total PFM Managed Investments 39,936,794$ 39,260,679$ 37,749,296$ 2.715%
184,151,391$ 183,475,275$ 181,942,205$ 3.713%
Checking Account:
Citizens Business Bank - General Account 12,053,947$ 12,053,947$ 12,053,947$ 0.000%
Citizens Business Bank - HdL Holding 700$ 700$ 700$ 0.000%
Total Inactive Deposits 12,054,647$ 12,054,647$ 12,054,647$ 0.000%
12,054,647$ 12,054,647$ 12,054,647$
196,206,038$ 195,529,923$ 193,996,852$
*yield as of the prior quarter end
CITY OF EASTVALE
Treasurer's Report
Fiscal Year 2023-24 as of November 30, 2023
GRAND TOTAL CASH
ACTIVE DEPOSITS TOTAL
INACTIVE DEPOSITS TOTAL
INACTIVE DEPOSITS
ACTIVE DEPOSITS
Institution
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.
Prepared by the Finance Department in accordance with the adopted Investment Policy eastvaleca.gov
Dash Board Report Card
I. PORTFOLIO DIVERSIFICATION
Money Market 1.67%Sweep 21.14%LAIF 0.77%CAMP Pool 55.67%Certificates of Deposit 0.39%U.S. Treasury Bond/ Note 9.42%U.S. Treasury Bill 0.12%Supra-National Agency Bond/Note 0.30%Municipal Bond / Note 0.58%Federal Agency Collaterized Mortgage 2.61%Asset-Backed Security/ Collateralized 0.95%Federal Agency Bond/ Note 2.16%Bank Note 0.31%Corporate Note 3.92%100.00%
Less Than 90 Days 79.20%90 days to Six Months (26 Weeks)0.42%Six Months to One Year (52 Weeks)0.99%One to Two Years (104 Weeks)3.73%Two to Three Years (156 Weeks)6.72%Three to Four Years (208 Weeks)2.58%Four to Five Years 5.67%Five Years +0.00%99.31%
II. PORTFOLIO PERFORMANCE MEASURES
Yield at Cost - November 30, 2023 3.713%
Annual Investment Income Budget 2,539,578$ A
Investment Income Received-YTD 11/30/2023 2,204,261 B
Less Investment Fees (17,007) C
Net Investment Income Received-YTD 11/30/2023 2,187,254$ B+C
Over/(Under) Annual Budget (352,324)$ C-B
% of Annual Budget 86.127%
Net Yield Annualized at Cost - November 30, 2023 3.721%
CITY OF EASTVALE
Treasurer's Report
Fiscal Year 2023-24 as of November 30, 2023
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 2023-24 as of November 30, 2023
CAMP Pool
72.1%
Local Agency Investment
Fund
1.0%
U.S. Treasury
Bond / Note
12.2%
U.S. Treasury Bill
0.1%Supra-National Agency
Bond / Note
0.4%
Municipal Bond / Note
0.7%
Federal Agency
Commercial
3.4%
Asset-Back Security / Collateralized1.2%
Certificate of Deposit0.5%
Federal Agency Bond / Note
2.8%
Bank Note
0.4%Corporate Note5.1%
0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
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 2023-24 as of November 30, 2023
Year Over Year Interest Income
-
500,000
1,000,000
1,500,000
2,000,000
2,500,000
3,000,000
3,500,000
4,000,000
4,500,000
2018-19 2019-20 2020-21 2021-22 2022-23 2023-24 YTDNet Interest 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, 2023
Money Market Accounts 3,039,011$
Sweep Accounts 38,465,122
Pooled Investment Accounts 102,710,463
PFM Managed Investments 39,260,679
Checking Account 12,054,647
Grand Total Cash - November 30, 2023 195,529,923$
Breakdown of Total Cash at November 30, 2023
Non-Spendable & Restricted Funds (Non-Discretionary Per Law):47,224,138$
per 06/30/2022 audited financials
Committed (Formal Action of City Council):101,915,029
per fiscal year 2023-24 budget
Assigned (City's Intent):
per fiscal year 2023-24 budget
Fire Operations
per fiscal year 2023-24 budget 5,915,138
General Fund Emergency Contingency:
per fund balance reserve policy +16,727,608
All Funds Adopted Budget
Revenues 108,054,398 Expenditures 107,946,849
All Funds Net Revenue -107,549
Total Designated/ Assigned 22,535,197
Unassigned*23,855,559
Grand Total Cash - November 30, 2023 195,529,923$
Fiscal Year 2023-24 as of November 30, 2023
Treasurer's Report
CITY OF EASTVALE
*Restricted,committed,and assigned figures based on estimated fund balances at the end of the fiscal
year,06/30/2024.However cash estimates in this report are based on the current month.As a result,it is
typical that a variance exists between projected unassigned cash balance and current unassigned cash
balances.The variance will not be resolved until the end of the fiscal year.A negative unassigned cash
balance in the current period does not indicate a cash flow issue for the city.As an example,the General
and Fire Funds are projected to end the fiscal year with a combined unassigned cash balance of
$29,923,103.
Prepared by the Finance Department in accordance with the adopted Investment Policy eastvaleca.gov
Investment Income Detail
Yield at Cost - November 30, 2023 3.713%
Annual Investment Income Budget A 2,539,578$
Investment Income Received YTD:
Money Market (CBB)1,262$
Sweep (CBB)14,672
Money Market (PFM)6,256
LAIF 23,812
CAMP Pool 2,304,265
Certificate of Deposits 19,637
Municipal Bond/Note 9,765
U.S. Treasury Bill 133,610
U.S. Treasury Bond/ Note 477
Federal Agency Bond/ Note 13,294
Federal Agency Commercial Mortgage Backed Security 20,371
Asset-Backed Security 33,651
Corporate Note 77,942
Bank Note (1,092)
Supra-National Agency Bond/Note 1,413
Realized Gain/ (Loss)(455,074)
Total Investment Income Received-YTD 11/30/2023 B 2,204,261
Less Investment Fees Paid:
Trust Fees-U.S. Bank (1,884)
Management Fee-PFM (15,124)
Total Investment Fees Paid-YTD 11/30/2023 C (17,007)
Net Investment Income Received-YTD 11/30/2023 B+C 2,187,254$
Investment Income Over/(Under) Annual Budget C-B (352,324)$
% of Annual Budget 86.127%
Net Yield Annualized at Cost - November 30, 2023 3.721%
Fiscal Year 2023-24 as of November 30, 2023
Treasurer's Report
CITY OF EASTVALE
Prepared by the Finance Department in accordance with the adopted Investment Policy eastvaleca.gov