09-15-2020 - AGENDA ITEM 02 CONSIDERATION OF INVESTMENT REPORT FOR THE MONTH ENDED JULY 31, 202012/1/2020
Print Staff Report
AGENDA ITEM NO. 2
DATE: September 15, 2020
TO: Mayor and City Council
FROM: David Carmany
City Manager
AGENDA STAFF REPORT
City of West Covina I Office of the City Manager
SUBJECT: CONSIDERATION OF INVESTMENT REPORT FOR THE MONTH ENDED JULY 31,
2020
RECOMMENDATION:
It is recommended that the City Council receive and file the Investment Report for the month ended July 31,
2020.
BACKGROUND:
California Government Code Section 53646 requires that cities report detailed information on all securities,
investments, and monies of the City and that cities report the market value of the investments held. California
Government Code Section 53601 and the City's Investment Policy define the types of investments allowed.
The City's Investment Policy was last revised and adopted by the City Council on July 2, 2019. The City's
Investment Policy has set primary goals of the portfolio management of safety, liquidity and yield.
Bond reserves are held and invested by a Trustee. The investment of these funds is governed by an investment
policy approved by the City Council as a part of the governing documents for each specific bond issue.
DISCUSSION:
The Investment Report (Attachment No. 1) presents the City's and the Successor Agency's cash and
investments for the month ended July 31, 2020. This report is in compliance with California Government
Code Section 53646 regarding the reporting of detailed information on all securities, investments, and monies
of the City as well as reporting of the market value of the investments held. All the investments contained
within the portfolio are in full compliance with Government Code Section 53601 and the City's Investment
Policy as to the types of investments allowed. As stated in the attached report, there are sufficient funds to
meet the budgeted expenditures over the next six months. The City's surplus funds are deposited with the Los
Angeles County Investment Pool (LACIP), the Local Agency Investment Fund (LAIF) and Chandler Asset
Management (Attachment No. 2).
On July 31, 2020, the investment portfolio had a market value of $83,318,934 and the bond reserves had a
market value of $6,659,060.
Prepared by: Robbeyn Bird, Finance Director
https://destinyhosted.com/print_ag_memo.Gfm?seq=956&rev_num=0&mode=6demal&reloaded=true&id=93782 1/2
City of West Covina Short Term
Transaction Ledger
OR
Account #10479
As of July 31, 2020
Transaction Settlement CUSIP
Type Date
DISPOSITIONS
Quantity
Security Description Price Acq/Disp
Yield
Amount
Interest
Pur/Sold
Total Amount
Gain/Loss
Security 07/27/2020 31846V203
41.67
First American Govt Obligation Fund 1.000
41.67
0.00
41.67
0.00
Withdrawal
Class Y
Subtotal
67.16
67.16
0.00
67.16
0.00
TOTAL DISPOSITIONS
23,23S.17
23,23S.17
629.14
23,864.31
0.00
OTHER TRANSACTIONS
Dividend 07/01/2020 31846V203
64,704.99
First American Govt Obligation Fund 0.000
0.26
0.00
0.26
0.00
Class Y
Subtotal
64,704.99
0.26
0.00
0.26
0.00
TOTAL OTHER TRANSACTIONS
64,704.99
0.26
0.00
0.26
0.00
Chandler Asset Management -CONFIDENTIAL Page 6 Execution Time: 8/3/2020 6:S4:07 PM
12/1/2020 Print Staff Report
Additional David Carmany, City Manager
Approval:
Attachments
Attachment No. 1 - Investment Report
Attachment No. 2 - Chandler Report
CITY Achieve Fiscal Sustainability and Financial Stability
COUNCIL Engage in Proactive Economic Development
GOALS &
OBJECTIVES:
https://destinyhosted.com/print_ag_memo.Gfm?seq=956&rev_num=0&mode=6demal&reloaded=true&id=93782 2/2
ATTACHMENT NO. 1
City of West Covina
Investment Report
For the Month Ended July 31, 2020
Interest/
Yield to
Maturity
%
Description
Book Value
Market Value
Maturity
Date
Portfolio
Cash and Cash Equivalents
Wells Fargo Checking Account
$ 6,052,273
$ 6,052,273
0.00%
n/a
6.73%
Pacific Western Bank Checking - HPP (CDBG)
3,664
3,664
0.00%
me
0.00%
Pacific Western Bank Checking - HPP(LMIHF)
2,114
2,114
0.00%
n/a
0.00%
Los Angeles County Investment Pool (LACIP)
60,153
60,153
0.84 %
n/a
0.07%
Los Angeles County Investment Pool (LACIP) - CFD
5,259
5,259
0,84 %
n/a
0.01 %
Local Agency Investment Fund (LAIF)
65,926,040
65,926,040
1.22%
n/a
73.27%
Wells Fargo Checking Account- Successor Agency
5,444,827
5,444,827
0.00%
n/a
6.05%
Wells Fargo Checking Account -CFD
5,484,948
5,484,948
0.00%
n/a
6.10%
Investments - Chandler Asset Management
Asset -Backed Securities
99,456
99,980
0.37 %
See attached
0.11 %
Federal Agencies
-
-
0.00%
See attached
0.00%
Collateralized Mortgage Obligation
149,093
151,241
1.33 %
See attached
0.17 %
Money Market Funds
88,435
88,435
0.01 %
See attached
0.10 %
US Treasury
0.00%
See attached
0.00%
Total Cash and Investments
$ 83,316,262
$ 83,318,934
Bond Reserves
Lease Revenue Bonds, 2006 Series A & 2006 Series B (Taxable)
First American Treasury Obligations Fund Class D
$ 1,071.000
$ 1,071,000
0.01 %
n/a
1.19 %
First American Treasury Obligations Fund Class D
585,372
585,372
0.01 %
n/a
0.65 %
1996 Special Tax Refunding Bonds - Successor Agency
First American Treasury Obligations Fund Class D
5,002,688
5,002,688
7.01 %
9/1/2022
5.56 %
First American Treasury Obligations Fund Class D
0.01 %
n/a
0.00%
Total Bond Reserves
$ 6,669,060
$ 6,659,060
Total Investment Portfolio
$ 89,975,322
$ 89,977,994
100.00%
Blended Yield of Cash and Investments
0.92 %
Benchmarks:
LAIF
0.92%
LACIP
0,71%
6mo U.S. Treasury
0.17%
2yr U.S. Treasury
0.18%
5 r U.S. Treasury
0.33%
I hereby certify that the investments are in compliance with the investment policy adopted by the City Council. The investment portfolio provides
sufficient funds to meet the budgeted expenditures over the next six months. This report meets the requirements of Government Code Section
53646.
PREPARED BY:
REVIEWED BY:
Robbeyn Bird - nance Director Colleen B. Rozatti - City Treasurer
APPROVED BY:
David Ca y - City Manager
ATTACHMENT NO.2 OR
City of West Covina Short Term - Account #10479
MONTHLY ACCOUNT STATEMENT
JULY 1, 2020 THROUGH JULY 31, 2020
Chandler Team:
For questions about your account, please call (800) 317-4747,
or contact operations@chandlerasset.com
Custodian
US Bank
Christopher Isles
(503)464-3685
CHANDLER ASSET MANAGEMENT
chandlerasset.com
Information contained herein is confidential. We urge you to compare this statement to the one you receive from your qualified custodian. Please see Important Disclosures.
City of West Covina Short Term Portfolio Summary
Account #10479 As of July 31, 2020
PORTFOLIO CHARACTERISTICS
Average Modified Duration
0.48
Average Coupon
2.07%
Average Purchase YTM
1.85%
Average Market YTM
0.70%
Average S&P/Moody Rating
AAA/Aaa
Average Final Maturity
0.88 yrs
Average Life
0.49 yrs
SECTOR ALLOCATION
44.6%
ass 29.4%
Mo v xe ra 26.0%
PERFORMANCE REVIEW
ACCOUNT SUMMARY
Beg. Values
End Values
as of 6/30/20
as of 7/31/20
Market Value
339,478
339,656
Accrued Interest
490
468
Total Market Value
339,968
340,124
Income Earned
622
569
Cont/WD
-67
Par
335,627
336,190
Book Value
336,460
336,985
Cost Value
338,138
338,760
MATURITY DISTRIBUTION
0-.25 .25-.5 .5-1 1-2 2-3 3-4 4-5 5+
Maturity (Yrs)
TOP ISSUERS
Federal Home Loan Mortgage Corp
44.6%
First American Govt Oblig Fund
26.0%
Honda ABS
22.5%
John Deere ABS
6.9%
Total
100.0%
CREDIT QUALITY (S&P)
u�rzer
_. -
---—AAA(48.5%)
Annualized
TOTAL RATE OF RETURN
1M 9w 3M _W YTD 1YR
2YRS 3YRS 5YR5
10YRS
7/31/2016
City of West Covina Short Term
0.07% 0.17% 1.59% 2.74%
3.20% 2.23% N/A
N/A
1.80%
ICE BAML 1-3 Yr US Treasury/Agency Index
0.10% 0.20% 3.03% 4.28%
4.06% 2.65% N/A
N/A
2.03%
Chandler Asset Management - CONFIDENTIAL Paee 1 Execution Time: 8/3/2020 6:54:07 PM
Category
Treasurylssues
Federal Agencies
Municipal Securities
Supranationals
Medium Term Notes
Collateralized Certificates of Deposit
Negotiable Certificates of Deposit
Banker's Acceptances
Commercial Paper
Asset -Backed Securities/ Mortgage -
Backed Securities
Money Market Mutual Funds
Prohibited Securities
Repurchase Agreements
Local Agency Investment Fund (LAIF)
Los Angeles County Investment Pool
Max per Security Type
Max per Issuer
Maximum Maturity
*Account is terminating and liquidat
Statement of Compliance
As of July 31, 2020
City of West Covina
Assets managed by Chandler Asset Management are in full compliance with state law and the District's investment policy.
CAN
Standard
Comment
No limitations
Complies
No limitations
Complies
"A" or higher by a NRSRO; 30% maximum; 5% max per issuer
Complies
"AA" rated or higher by a NRSRO; 30% max; 10% max per issuer, Unsubordinated obligations issued by: BIRD, IFC, IADB
Complies
"A" rated or higher by a NRSRO; 30% maximum; 5% max per issuer; Issued by corporations organized and operating within
Complies
the U.S.
25% maximum
Complies
"A" rated or better by a NRSRO; 30% maximum
Complies
40% maximum; 30% max per one commercial bank; 180 days max maturity
Complies
A-1/P-1 rating or higher by both S&P and Moody's; 25% maximum; 5% per issuer; 270 days max maturity; Eligible paper is
Complies
limited to corporations organized and operating within the U.S. with total assets of at least $500 million
"AA" or better by a NRSRO; "A" rated issuer rating or higher by a NRSRO; 20% maximum
Complies*
"AAA" rated or highest rating by a NRSRO; 20% maximum; 10% per fund
Complies
Inverse floaters; Ranges notes, Interest -only strips from mortgaged backed securities; Zero interest accrual securities;
Complies
Reverse Repurchase Agreements
20% maximum; 100 days max maturity; collateralized 102%of market value; Not used by investment adviser
Complies
Maximum program; Not used by investment adviser
Complies
Maximum program; Not used by investment adviser
Complies
No more than 40%of the City's total portfolio shall be invested in a single security type or with a single financial institution
Complies
No more than 5% in any single issuer except US Gov, Agencies, Supranationals, Money Market Funds, LAIF, or LGIP
Complies
5 years
Complies
all positions as they mature
City of West Covina Short Term Reconciliation Summary
Account #10479 As of July 31, 2020 OR
BOOK VALUE RECONCILIATION
BEGINNING BOOK VALUE
$336,459.75
Acquisition
+Security Purchases $0.00
+ Money Market Fund Purchases $23,797.41
+ Money Market Contributions $0.00
+Security Contributions $0.00
+ Security Transfers $0.00
Total Acquisitions
$23,797.41
Dispositions
Security Sales
$0.00
- Money Market Fund Sales
$0.00
- MMF Withdrawals
$67.16
- Security Withdrawals
$0.00
- Security Transfers
$0.00
- Other Dispositions
$0.00
- Maturites
$0.00
Calls
$0.00
Principal Paydowns
$23,168.01
Total Dispositions
$23,235.17
Amortization/Accretion
+/- Net Accretion
($37.41)
($37.41)
Gain/Loss on Dispositions
+/- Realized Gain/Loss
$0.00
$0.00
ENDING BOOK VALUE
$336,984.58
BEGINNING BALANCE
Acquisition
Contributions
$0.
Security Sale Proceeds
$0.
Accrued Interest Received
$0.
Interest Received
$629.
Dividend Received
$0.
Principal on Maturities
$0.
Interest on Maturities
$0.
Calls/Redemption (Principal)
$0.
Interest from Calls/Redemption
$0.
Principal Paydown
$23,168.
Total Acquisitions
$23,797.
$64,704.99
Dispositions
Withdrawals
$67.16
Security Purchase
$0.00
Accrued Interest Paid
$0.00
Total Dispositions
$67.16
ENDING BOOK VALUE
$88,435.24
Chandler Asset Management - CONFIDENTIAL Page 3 Execution Time: 8/3/2020 6:54:07 PM
City of West Covina Short Term
Holdings Report
Account #10479
A5 of July 31, 2020
ABS
Security Description
Par Value/Units
Purchase Date Cost Value
Book Yield Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.
Gain/Loss
Moody/S&P
Fitch
Maturity
DurationCUSIP
43811BACS
Honda Auto Receivables Trust 2017-2
14,539.38
04/27/2018 14,313.34
100.23
14,572.18
4.29%
Aaa / AAA
1.04
A3
2.62% 14,468.04
0.24%
10.86
104.14
NR
0.16
1.68% Due 8/16/2021
43814WAB1
Honda Auto Receivables Trust 2019-1
61,766.73
02/19/2019 61,762.75
100.44
62,039.61
18.26%
NR/AAA
1.14
A2
2.77% 61,764.97
0.35%
61.34
274.64
AAA
0.18
2.75% Due 9/20/2021
47788BAD6
John Deere Owner Trust 2017-B A3
3,238.59
07/11/2017 3,238.35
100.15
3,243.30
0.95%
Aaa / NR
1.21
1.82%Due 10/15/2021
1.83% 3,238.52
0.53%
2.62
4.78
AAA
0.11
47788CAC6
John Deere Owner Trust 2018-A A3
19,985.10
02/21/2018 19,983.67
100.70
20,124.93
5.92%
Aaa / NR
1.72
2.66%Due 4/18/2022
2.68% 19,984.51
0.48%
23.63
140.42
AAA
0.32
99,298.11
99,980.02
29.42%
Aaa / AAA
1.24
Total ABS
99,529.80
2.70% 99,456.04
0.37%
98.45
523.98
AAA
0.20
CMO
3137BFDQ1
FHLMC K717 A2
148,224.67
01/04/2018 151,027.05
102.03
151,240.89
44.58%
NR/NR
1.15
2.991% Due 9/25/2021
2.37% 149,093.30
1.33%
369.45
2,147.59
AAA
0.95
151,027.05
151,240.89
44.58%
NR/NR
1.15
Total CMO
148,224.67
2.37% 149,093.30
1.33%
369.45
2,147.59
AAA
0.95
MONEY MARKET FUND FI
31846V203 First American Govt Obligation Fund
Class Y
Total Money Market Fund FI
TOTAL PORTFOLIO
W
88,435.24 Various
88,435.24
1.00
0.01%
88,435.24
0.01%
88,435.24
88,435.24 0.01%
88,435.24
0.01%
338,760.40
336,189.71 1.85%
336,984.58
0.70%
88,435.24
26.00%
Aaa / AAA
0.00
0.00
0.00
AAA
0.00
88,435.24
26.00%
Aaa / AAA
0.00
0.00
0.00
AAA
0.00
339,656.15
100.00%
Aaa / AAA
0.88
467.90
2,671.57
AAA
0.48
TOTAL MARKET VALUE PLUS ACCRUED 340,124.05
Chandler Asset Management - CONFIDENTIAL Page 4 Execution Time: 8/3/2020 6:54:07 PM
City of West
Covina Short Term
Transaction Ledger
OR
Account #10479
A5 of July 31, 2020
Transaction
Type
ACQUISITIONS
Settlement
Date
CUSIP
Quantity
Security Description
Price Acq/Disp
Yield
Amount
Interest
Pur/Sold
Total Amount
Gain/Loss
Purchase
07/01/2020
31846V203
0.26
First American Govt Obligation Fund
1.000
0.01%
0.26
0.00
0.26
0.00
Class Y
Purchase
07/15/2020
31846V203
4,086.43
First American Govt Obligation Fund
1.000
0.01%
4,086.43
0.00
4,086.43
0.00
Class Y
Purchase
07/15/2020
31846V203
994.93
First American Govt Obligation Fund
1.000
0.01%
994.93
0.00
994.93
0.00
Class Y
Purchase
07/15/2020
31846V203
2,351.79
First American Govt Obligation Fund
1.000
0.01%
2,351.79
0.00
2,351.79
0.00
Class Y
Purchase
07/20/2020
31846V203
15,773.36
First American Govt Obligation Fund
1.000
0.01%
15,773.36
0.00
15,773.36
0.00
Class Y
Purchase
07/27/2020
31846V203
590.64
First American Govt Obligation Fund
1.000
0.01%
590.64
0.00
590.64
0.00
Class Y
Subtotal
23,797.41
23,797.41
0.00
23,797.41
0.00
TOTAL ACQUISITIONS
23,797.41
23,797.41
0.00
23,797.41
0.00
DISPOSITIONS
i
-
Paydown
07/15/2020
43811BACS
4,060.39
Honda Auto Receivables Trust 2017-2
100.000
4,060.39
26.04
4,086.43
0.00
A3
1.68% Due 8/16/2021
Paydown
07/15/2020
47788BAD6
988.52
John Deere Owner Trust 2017-B A3
100.000
988.52
6.41
994.93
0.00
1.82% Due 10/15/2021
Paydown
07/15/2020
47788CAC6
2,302.39
John Deere Owner Trust 2018-A A3
100.000
2,302.39
49.40
2,351.79
0.00
2.66% Due 4/18/2022
Paydown
07/20/2020
43814WAB1
15,596.07
Honda Auto Receivables Trust 2019-1
100.000
15,596.07
177.29
15,773.36
0.00
A2
2.75% Due 9/20/2021
Paydown
07/27/2020
3137BFDQ1
220.64
FHLMC K717 A2
100.000
220.64
370.00
590.64
0.00
2.991% Due 9/25/2021
Subtotal
23,168.01
23,168.01
629.14
23,797.15
0.00
Security
07/06/2020
31846V203
25.49
First American Govt Obligation Fund
1.000
25.49
0.00
25.49
0.00
Withdrawal
Class Y
Chandler Asset Management
- CONFIDENTIAL
Page 5
Execution
Time: 8/3/2020 6:54:07 PM