HomeMy WebLinkAboutAgenda Report - February 21, 2018 C-04TM
CITY OF LODI
COUNCIL COMMUNICATION
AGENDA ITEM
C-4
AGENDA TITLE: Accept the Quarterly Investment Report as Required by the City of Lodi Investment
Policy
MEETING DATE: February 21, 2018
PREPARED BY: Deputy City Manager
RECOMMENDED ACTION: Accept the quarterly investment report as required by the City of
Lodi Investment Policy.
BACKGROUND INFORMATION: Government Code Section 53646 prescribes suggested investment
reporting requirements for California public agencies. The City
Council adopted Resolution 2016-10 on January 20, 2016, requiring
the Treasurer to submit a quarterly investment reporting in accordance with Section 53646. The attached
Treasurer's Report for the quarter ending December 31, 2017 is in compliance with the State's reporting
recommendations and the City of Lodi's Investment Policy and Internal Control Guidelines.
FISCAL IMPACT: Not applicable.
FUNDING AVAILABLE: As per attached report.
Attachment
av�c� of
Andrew Keys
Treasurer
APPROVED: it '
Stephen chwabaiie , City Manager
TYPE OF INVESTMENT
Cash and Equivalents
Farmers & Merchants Bank Main *
Farmers & Merchants Bank Payroll *
Local Agency Investment Fund
Farmer's & Merchants Bank Money Market *
Wells Fargo Bank Money Market *
Total Demand Deposit Accounts
Bond Mutual Fund
CAL TRUST Short Term Fund
CAL TRUST Medium Term Fund
Total Bond Mutual Funds
Local Bank Certificates of Deposit
Farmers & Merchants Bank **
Bank of the West
BBVA Compass
Total Local Bank Certificates of Deposit
Negotiable Certificates of Deposit
Morgan Stanley Bank NA **
Morgan Stanley Private Bank **
Wex Bank Interest Bearing **
Pacific City Bank Interest **
Marquis Bank Interest Bearing **
Belmont Savings Bank Interest **
TIAA FSB Interest Bearing **
Ally Bank Interest Banking **
Berkshire Bank Pittsfield **
Nebraskaland National Bank **
MB Financial Bank NA Interest **
Merrick Bank Interest Bearing **
Discover Bank Interest Bearing **
Third Fed Savings & Loan Cleveland **
BMW Bank North America **
Capital One Bank USA NA **
Capital One NA Interest **
Goldman Sachs Bank USA**
Wells Fargo Bank NA Interest **
JP Morgan Chase Bank NA **
Total Negotiable Certificates of Deposit
CITY OF LODI
SUMMARY OF CASH AND INVESTED FUNDS
FOR THE QUARTER ENDED December 31, 2017
Interest Rate Maturity Date Par Value
Cost
Market Value % of Portfolio
INVESTMENTS SUBTOTAL NOT INCLUDING CASH
& EQUIVALENTS
Due on Demand
Due on Demand
Due on Demand
Due on Demand
Due on Demand
Interest Rate Maturity Date Par Value
Due on Demand
Due on Demand
Interest Rate
1.00% 11/7/2019 2,000,000 2,000,000
0.75% 3/10/2018 250,000 250,000
1.00% 3/13/2018 249,995 249,995
2,499,995 2,499,995
7,340,150
28,758
34,715,161
3,440,426
3,125
7,340,150
28,758
34,715,161
3,440,426
3,125
45, 527,621 45, 527,6 21
8.32%
0.03%
39.35%
3.90%
0.00%
51.60%
Cost Market Value % of Portfolio
12, 348, 377 12, 348, 377 14.00%
22,877,640 22,877,640 25.93%
35,226,017 35,226,017 39.93%
Maturity Date Par Value Cost Market Value % of Portfolio
2,000,000 2.27%
250,000
249,995
2,499,995
0.28%
0.28%
2.83%
Interest Rate Maturity Date Par Value Cost
1.80% 11/22/2019 250,000 250,000
1.75% 11/22/2019 250,000 250,000
1.75% 11/22/2019 250,000 250,000
1.70% 11/25/2019 250,000 250,000
1.70% 11/29/2019 250,000 250,000
1.95% 11/23/2020 250,000 250,000
1.95% 11/23/2020 250,000 250,000
2.05% 11/24/2020 250,000 250,000
1.85% 11/24/2020 250,000 250,000
1.85% 11/27/2020 250,000 250,000
2.00% 11/17/2021 250,000 250,000
2.10% 11/17/2021 250,000 250,000
2.15% 11/22/2021 250,000 250,000
2.10% 11/24/2021 250,000 250,000
2.20% 11/29/2021 250,000 250,000
2.40% 11/22/2022 250,000 250,000
2.40% 11/22/2022 250,000 250,000
2.40% 11/22/2022 250,000 250,000
2.40% 11/22/2022 250,000 250,000
2.30% 11/30/2022 250,000 250,000
Market Value
249,140
248,909
248,909
248,657
248,635
248,468
248,472
249,168
247,767
247,743
247,582
248,511
248,964
248,493
249,410
248,984
248,984
248,984
248,691
247,777
% of Portfolio
0.28%
0.28%
0.28%
0.28%
0.28%
0.28%
0.28%
0.28%
0.28%
0.28%
0.28%
0.28%
0.28%
0.28%
0.28%
0.28%
0.28%
0.2896
0.28%
0.28%
5,000,000 5,000,000
7,499,995 42,726,012
TOTAL ALL INVESTMENTS INCLUDING
CASH & EQUIVALENTS 7,499,995 88,253,633
* End of month bank balances are reflected on this report.
** Investments purchased during this this reporting period.
4,972,245
42,698,257
88,225,877
5.64%
48.40%
100.00%
CERTIFICATION
I certify this report accurately reflects all city pooled investments and is in conformity with state law and the investment policy statement adopted
by the City Council on January 20, 2016. The investment program herein shown provides sufficient cash liquidity to meet the next six months
estimated expenditures.
Andrew Keys, Treasurer/ector of Finance
Review Date
san Bjork, Senior Bu gat na st
Review
e
IRS Section 115 Retirement Benefit Trust Funds Market Value
Public Agency Retirement Services - Pension Stabilization Fund
Balanced Strategy Mutual Fund $ 5,229,493
Total Pension Stabilization Fund
$ 5,229,493
Ca1PERS - California Employer's Retiree Benefit Trust (CERBT)
CERBT Strategy 2 $
Total CERBT $
Total Section 115 Retirement Benefit Trust Funds
1,152,004
1,152,004
$ 6,381,497
Restricted Cash Accounts Market Value
PCE/TCE Central Plume Remediation Fund
Farmers & Merchants Bank Money Market $
Total PCE/TCE Central Plume Account $
2,356,971
2,356,971
Total Restriction Cash Accounts
$ 2,356,971