Loading...
03. SEPTEMBER 30, 2018Book Value (Fair Value) Par Price @ Market Institution Value Cost Value Yield ACTIVE DEPOSITS Money Market Accounts: Citizens Business Bank - Money Market 1,184,858.53$ 1,184,858.53$ 1,184,858.53$ 0.350% First American Govt Oblig Fund CI Y 308,551.25 308,551.25 308,551.25 1.730% Total Money Market 1,493,409.78$ 1,493,409.78$ 1,493,409.78$ 0.635% Pooled Investment Accounts: Local Agency Investment Fund 13,119,840.69$ 13,119,840.69$ 13,095,265.51$ 2.063% Total Pooled Investment 13,119,840.69$ 13,119,840.69$ 13,095,265.51$ 2.063% PFM Managed Investment Portfolio: U.S. Treasury Bond/ Note 11,565,000.00$ 11,485,653.31$ 11,197,932.44$ 2.070% Supra-National Agency Bond/Note 3,110,000.00$ 3,111,357.69$ 3,064,324.37$ 2.250% Federal Agency Collaterized Mortgage 397,143.26$ 402,995.26$ 398,596.11$ 2.420% Asset-Back Security/ Collateralized 2,356,980.20$ 2,356,775.05$ 2,337,110.73$ 2.460% Certificate of Deposit 6,035,000.00$ 6,034,500.90$ 6,003,556.34$ 2.440% Federal Agency Bond/ Note 3,505,000.00$ 3,497,527.00$ 3,390,358.99$ 1.910% Corporate Note 8,245,000.00$ 8,305,134.80$ 8,104,341.57$ 2.260% Total PFM Managed Investments 35,214,123.46$ 35,193,944.01$ 34,496,220.55$ 2.208% ACTIVE DEPOSITS TOTAL 49,827,373.93$ 49,807,194.48$ 49,084,895.84$ 2.123% INACTIVE DEPOSITS Checking Account: Citizens Business Bank - Checking 13,679,173.31$ 13,679,173.31$ 13,679,173.31$ 0.000% Total 13,679,173.31$ 13,679,173.31$ 0.000% INACTIVE DEPOSITS TOTAL 13,679,173.31$ 13,679,173.31$ GRAND TOTAL CASH 63,486,367.79$ 62,764,069.15$ Ernie Reyna Finance Director 9/30/2018 City of Eastvale Schedule of Investments As of September 30, 2018 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. I. PORTFOLIO DIVERSIFICATION DIVERSIFICATION BY INSTRUMENT Money Market 3.00% LAIF 26.34% Certificates of Deposit 12.12% U.S. Treasury Bond/ Note 23.06% Supra-National Agency Bond/Note 6.25% Federal Agency Collaterized Mortgage 0.81% Asset-Backed Security/ Collateralized 4.73% Federal Agency Bond/ Note 7.02% Corporate Note 16.67% 100.00% DIVERSIFICATION BY MATURITY Less Than 90 Days 29.34% Six Months (26 Weeks)0.50% One Year (52 Weeks)6.35% Two Years (104 Weeks)17.19% Three Years (156 Weeks)20.75% Four Years (208 Weeks)19.99% Five Years +5.88% 100.00% II. PORTFOLIO PERFORMANCE MEASURES Yield at Cost -September 30, 2018 2.123% Annual Investment Income Budget 211,000$ Investment Income Received: Money Market 454.46$ LAIF 71,284.75 Certificate of Deposits 11,863.29 U.S. Treasury Bond/ Note (8,145.49) Federal Agency Bond/ Note 1,138.31 Asset-Backed Security/ Collateralized 4,749.09 Corporate Note 20,826.00 Supra-National Agency Bond/Note - Realized Gain/ (Loss)(5,086.66) Total Investment Income Received-YTD 9/30/2018 97,083.75 Less Investment Fees Paid: Trust Fees-U.S. Bank (2,013.97) Mgmt Fee-PFM (2,759.70) Total Investment Fees Paid-YTD 9/30/2018 (4,773.67) Net Investment Income Received-YTD 9/30/2018 92,310.08$ Over/(Under) Annual Budget (118,689.92)$ % of Annual Budget 43.749% Net Yield Annualized at Cost - September 30, 2018 2.085% City of Eastvale Dash Board Report Card As of September 30, 2018 City of Eastvale Cash Breakdown per Fund Balance Reserve Policy September 30, 2018 Schedule of Investments - September 30, 2018 Money Market Accounts 1,493,409.78$ Pooled Investment Accounts 13,119,840.69 PFM Managed Investments 35,193,944.01 Checking Account 13,679,173.31 Grand Total Cash - September 30, 2018 63,486,367.79$ Breakdown of Total Cash at September 30, 2018 Restricted Funds (Non-Discretionary Per Law)30,531,621.79$ Committed (Per Formal Action of City Council)9,300,000.00 Designated/ Assigned (Per City's Intent): Fire Operations/ Improvements (Per FY 18-19 Adopted Budget)6,915,221.00 General Fund Emergency Contingency: To meet City's cash obligations for the next six months General Fund Adopted Budget Expenditures-FY 2018-19 (Per Fund Balance Reserve Policy)9,766,182.00 Total Designated/ Assigned 16,681,403.00 Unassigned 6,973,343.00 Grand Total Cash - September 30, 2018 63,486,367.79 Yield at Cost -September 30, 2018 2.123% Annual Investment Income Budget 211,000$ Investment Income Received: Money Market 454.46$ LAIF 71,284.75 Certificate of Deposits 11,863.29 U.S. Treasury Bond/ Note (8,145.49) Federal Agency Bond/ Note 1,138.31 Asset-Backed Security/ Collateralized 4,749.09 Corporate Note 20,826.00 Supra-National Agency Bond/Note - Realized Gain/ (Loss)(5,086.66) Total Investment Income Received-YTD 9/30/2018 97,083.75 Less Investment Fees Paid: Trust Fees-U.S. Bank (2,013.97) Mgmt Fee-PFM (2,759.70) Total Investment Fees Paid-YTD 9/30/2018 (4,773.67) Net Investment Income Received-YTD 9/30/2018 92,310.08$ Over/(Under) Annual Budget (118,689.92)$ % of Annual Budget 43.749% Net Yield Annualized at Cost - September 30, 2018 2.085% City of Eastvale Investment Income As of September 30, 2018