Loading...
06. JANUARY 31, 2022 Schedule of Investments Par Value Book Value Price @ Cost (Fair Value) Market Value Yield Money Market Accounts: Citizens Business Bank - Money Market 3,005,943$ 3,005,943$ 3,005,943$ 0.100% First American Govt Oblig Fund CI Y 99,566 99,566 99,566 0.010% Total Money Market 3,105,509$ 3,105,509$ 3,105,509$ 0.097% Sweep Accounts: Citizens Business Bank - General Sweep 53,454,806$ 53,454,806$ 53,454,806$ 0.100% Total Sweep Accounts 53,454,806$ 53,454,806$ 53,454,806$ 0.100% Pooled Investment Accounts: CAMP Pool 10,372,880$ 10,372,880$ 10,372,880$ 0.050% Local Agency Investment Fund*3,343,253 3,343,253 3,334,691 0.210% Total Pooled Investment 13,716,133$ 13,716,133$ 13,707,571$ 0.089% PFM Managed Investment Portfolio: U.S. Treasury Bond / Note 15,962,000$ 15,873,307$ 15,721,846$ 1.290% Supra-National Agency Bond / Note 845,000 844,268 828,151 0.460% Municipal Bond / Note 1,570,000 1,573,731 1,550,962 1.120% Federal Agency Collaterized Mortgage 630,376 635,240 639,261 2.300% Asset-Back Security / Collateralized 1,034,150 1,034,042 1,024,640 1.160% Certificate of Deposit 1,930,000 1,930,000 1,939,411 1.520% Federal Agency Bond / Note 10,800,000 10,798,156 10,639,489 0.960% Corporate Note 5,544,000 5,585,489 5,583,477 1.930% Total PFM Managed Investments 38,315,526$ 38,274,235$ 37,927,237$ 1.290% 108,591,974$ 108,550,682$ 108,195,123$ 0.518% Checking Account: Citizens Business Bank - General Account 12,000,000$ 12,000,000$ 12,000,000$ 0.000% Citizens Business Bank - HdL Holding 13,586$ 13,586$ 13,586$ 0.000% Total Inactive Deposits 12,013,586$ 12,013,586$ 12,013,586$ 0.000% 12,013,586$ 12,013,586$ 12,013,586$ 120,605,560$ 120,564,268$ 120,208,709$ *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 January 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.87%Sweep 49.41%LAIF 3.08%CAMP Pool 9.59%Certificates of Deposit 1.79%U.S. Treasury Bond/ Note 14.53%Supra-National Agency Bond/Note 0.77%Municipal Bond / Note 1.43%Federal Agency Collaterized Mortgage 0.59%Asset-Backed Security/ Collateralized 0.95%Federal Agency Bond/ Note 9.83%Corporate Note 5.16%100.00% Less Than 90 Days 64.95%90 days to Six Months (26 Weeks)0.87%Six Months to One Year (52 Weeks)2.01%One to Two Years (104 Weeks)9.82%Two to Three Years (156 Weeks)6.22%Three to Four Years (208 Weeks)11.62%Four to Five Years 4.52%Five Years +0.00%100.00% II. PORTFOLIO PERFORMANCE MEASURES Yield at Cost - January 31, 2022 0.518% Annual Investment Income Budget 799,390$ A Investment Income Received-YTD 01/31/2022 467,970 B Less Investment Fees (23,274) C Net Investment Income Received-YTD 01/31/2022 444,696$ B+C Over/(Under) Annual Budget (354,694)$ C-B % of Annual Budget 55.629% Net Yield Annualized at Cost - January 31, 2022 0.434% CITY OF EASTVALE Treasurer's Report Fiscal Year 2021-22 as of January 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 January 31, 2022 CAMP Pool 20.1% Local Agency Investment Fund 6.5%U.S. Treasury Bond / Note 30.4%Supra-National Agency Bond / Note 1.6% Municipal Bond / Note 3.0% Federal Agency Collaterized Mortgage 1.2% Asset-Back Security / Collateralized 2.0% Certificate of Deposit 3.8% Federal Agency Bond / Note 20.6% Corporate Note 10.8% 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 January 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 - January 31, 2022 Money Market Accounts 3,105,509$ Sweep Accounts 53,454,806 Pooled Investment Accounts 13,716,133 PFM Managed Investments 38,274,235 Checking Account 12,013,586 Grand Total Cash - January 31, 2022 120,564,268$ Breakdown of Total Cash at January 31, 2022 Restricted Funds (Non-Discretionary Per Law)20,629,667$ Committed (Per Formal Action of City Council)73,455,029 Designated/ Assigned (Per City's Intent): Fire Operations/ Improvements (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 3,383,903 Grand Total Cash - January 31, 2022 120,564,268$ Fiscal Year 2021-22 as of January 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 - January 31, 2022 0.518% Annual Investment Income Budget A 799,390$ Investment Income Received YTD: Money Market (CBB)1,770$ Sweep (CBB)22,701 Money Market (PFM)4 LAIF 6,681 CAMP Pool 3,110 Certificate of Deposits 3,849 Municipal Bond/Note 7,951 U.S. Treasury Bond/ Note 114,111 Federal Agency Bond/ Note 72,550 Federal Agency Commercial Mortgage Backed Security 1,058 Asset-Backed Security 26,177 Corporate Note 95,352 Supra-National Agency Bond/Note 350 Realized Gain/ (Loss)112,306 Total Investment Income Received-YTD 01/31/2022 B 467,970 Less Investment Fees Paid: Trust Fees-U.S. Bank (2,314) Mgmt Fee-PFM (20,961) Total Investment Fees Paid-YTD 01/31/2022 C (23,274) Net Investment Income Received-YTD 01/31/2022 B+C 444,696$ Investment Income Over/(Under) Annual Budget C-B (354,694)$ % of Annual Budget 55.629% Net Yield Annualized at Cost - January 31, 2022 0.434% Fiscal Year 2021-22 as of January 31, 2022 Treasurer's Report CITY OF EASTVALE Prepared by the Finance Department in accordance with the adopted Investment Policy eastvaleca.gov