01-19-2021 - AGENDA ITEM 03 CONSIDERATION OF INVESTMENT REPORT FOR THE MONTH ENDED NOVEMBER 30, 2020AGENDA ITEM NO.3
AGENDA STAFF REPORT
City of West Covina I Office of the City Manager
DATE: January 19, 2021
TO: Mayor and City Council
FROM: David Carmany
City Manager
SUBJECT: CONSIDERATION OF INVESTMENT REPORT FOR THE MONTH ENDED
NOVEMBER 30, 2020
RECOMMENDATION:
It is recommended that the City Council receive and file the Investment Report for the month ended November
30, 2020.
BACKGROUND:
California Government Code Section 53646 requires that cities report detailed information on all securities,
investments, and monies of the City and to 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 for 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 November 30, 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 Local Agency Investment Fund (LAIF) and Chandler Asset Management (Attachment No. 2).
At November 30, 2020, the investment portfolio had a market value of $76,997,617 and the bond reserves had
a market value of $23,078,963.
Prepared by: Robbeyn Bird, Finance Director
Additional Approval: David Carmany, City Manager
Attachments
City of West Covina Short Term
Transaction Ledger
OR
Account #10479
As of November 30, 2020
Transaction Settlement CUSIP
Type Date
DISPOSITIONS
Quantity
Security Description Price Acq/Disp
Yield
Amount
Interest
Pur/Sold
Total Amount
Gain/Loss
Security 11/25/2020 31846V203
41.67
First American Govt Obligation Fund 1.000
41.67
0.00
41.67
0.00
Withdrawal
Class Y
Subtotal
67.20
67.20
0.00
67.20
0.00
TOTAL DISPOSITIONS
21,931.28
21,931.28
437.74
22,369.02
0.00
OTHER TRANSACTIONS
Dividend 11/02/2020 31846V203
157,730.29
First American Govt Obligation Fund 0.000
0.74
0.00
0.74
0.00
Class Y
Subtotal
157,730.29
0.74
0.00
0.74
0.00
TOTAL OTHER TRANSACTIONS
157,730.29
0.74
0.00
0.74
0.00
Chandler Asset Management- CONFIDENTIAL Paee 6 Execution Time: 12/2/202012:31:53 PM
Attachment No. 1 - Investment Report
Attachment No. 2 - Chandler Report
CITY COUNCIL GOALS & OBJECTIVES: Achieve Fiscal Sustainability and Financial Stability
Enhance the City Image and Effectiveness
/N Y NEW: It)1 Will IICG]f I
City of West Covina
Investment Report
For the Month Ended November 30, 2020
Cash and Cash Equivalents
Wells Fargo Checking Account
Pacific Western Bank Checking - HPP (CDBG)
Pacific Western Bank Checking - HPP (LMIHF)
Local Agency Investment Fund (LAIF)
Wells Fargo Checking Account - Successor Agency
Wells Fargo Checking Account - CFD
Investments - Chandler Asset Management
Asset -Backed Securities
Collateralized Mortgage Obligation
Money Market Funds
US Treasury
Total Cash and Investments
Bond Reserves
Lease Revenue Bonds, 2006 Series A & 2006 Series B (Taxable)
First American Treasury Obligations Fund Class D
First American Treasury Obligations Fund Class D
1996 Special Tax Refunding Bonds - Successor Agency
First American Treasury Obligations Fund Class D
Income Cash
First American Treasury Obligations Fund Class D
Lease Revenue Bonds - 2020 Series A (Taxable)
First American Treasury Obligations Fund Class Z
First American Treasury Obligations Fund Class D
Total Bond Reserves
Interest]
Yield to
Maturity
%of
Book Value Market Value
Maturity
Date
Portfolio
$ 5,676,090 $
5,676,090
0.00%
n/a
5.67%
3,664
3,664
0.00%
n/a
0.00%
2,102
2,102
0.00%
n/a
0.00%
67,570,299
67,570,299
0.62%
n/a
67.52%
2,250,615
2,250,615
0.00%
n/a
2.25%
1,154,687
1,154,687
0.00%
n/a
1.15%
10,615
10,648
0.34%
See attached
0.01%
147,987
149,546
0.44%
See attached
0.15%
179,966
179,966
0.01%
See attached
0.18 %
0.00%
See attached
0.00%
$ 76,996,025 $ 76,997,617
$ 1,071,000 $
1,071,000
0.01%
n/a
1.07%
585,372
585,372
0.01%
n/a
0.58%
5,002,670
5,002,670
7.01%
9/1/2022
5.00%
-
-
1.87 %
n/a
0.00%
-
-
0.00%
n/a
0.00%
16,419,921
16,419,921
0.01%
8/1/2035
16.41%
0.01%
n/a
0.00%
$ 23,078,963 $ 23,078,963
Total Investment Portfolio $100,074,988 $100,076,580 100.00%
Blended Yield of Cash and Invesunenrs
0.58%
Benchmarks:
IAIF
6mo U.S. Treasury
2yr U.S. Treasury
5 r U.S. Treasury
0.58%
0.09%
0.16%
0.36%
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: REVIEW Y:
Robbeyn Bird - Fldance Director Colleen B. Rozatti - City Trea r
APPROVED BY:
David Carmany -C anager
ATTACHMENT NO.2 C11%
City of West Covina Short Term - Account #10479
MONTHLY ACCOUNT STATEMENT
NOVEMBER 1, 2020THROUGH NOVEMBER 30, 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
Account #10479
PORTFOLIO CHARACTERISTICS
Average Modified Duration
0.29
Average Coupon
1.39%
Average Purchase YTM
1.12%
Average Market YTM
0.21%
Average S&P/Moody Rating
AAA/Aaa
Average Final Maturity
0.40 yrs
Average Life
0.29 yrs
SECTOR ALLOCATION
Money — ra 52.8%
CMO a4.a%
nes 1
3.1%
PERFORMANCE REVIEW
Portfolio Summary
As of November 30, 2020
ACCOUNT SUMMARY
Beg. Values
End Values
as of 10/31/20
as of 11/30/20
Market Value
340,134
340,159
Accrued Interest
401
379
Total Market Value
340,535
340,539
Income Earned
414
367
Cont/WD
-67
Par
337,584
337,955
Book Value
338,246
338,567
Cost Value
340,318
340,739
MATURITY DISTRIBUTION
0-.25 .25-.5 .5-1 1-2 2-3 3-4 4-5 5+
Maturity (Yrs)
cap
TOP ISSUERS
First American Govt Oblig Fund
52.8%
Federal Home Loan Mortgage Corp
44.0%
John Deere ABS
2.4%
Honda ABS
0.7%
Total
100.0%
CREDIT QUALITY (S&P)
---NR (46.4%)
Annualized
TOTAL RATE OF RETURN
1M 'V 3M YTD 1YR
2YRS 3YRS 5YR5
10YRS
7/31/2016
City of West Covina Short Term
0.02% 0.18% 1.79% 1.96%
2.93% 2.31% N/A
N/A
1.71%
ICE BAML 1-3 Yr US Treasury/Agency Index
0.05% 0.03% 3.04% 3.26%
3.70% 2.73% N/A
N/A
1.87%
Chandler Asset Management- CONFIDENTIAL Page 1 Execution Time: 12/2/202012:31:53 PM
Statement of Compliance
As of November 30, 2020
CAS
City of West Covina
Assets managed by Chandler Asset Management are in full compliance with state law and the District's investment policy.
Category Standard Comment
Treasury Issues No limitations Complies
Federal Agencies No limitations Complies
Municipal Securities "A" or higher by a NRSRO; 30% maximum; 5% max per issuer Complies
Supranationals
"AA" rated or higher by a NRSRO; 30% max; 10%max per issuer; Unsubordinated obligations issued by: IBRD, IFC, IADB
Complies
Medium Term Notes
"A" rated or higher by a NRSRO; 30% maximum; 5% max per issuer; Issued by corporations organized and operating within
Complies
the U.S.
Collateralized Certificates of Deposit
25% maximum
Complies
Negotiable Certificates of Deposit
"A" rated or better by a NRSRO; 30% maximum
Complies
Banker's Acceptances
40% maximum; 30% max per one commercial bank; 180 days max maturity
Complies
Commercial Paper
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
Asset -Backed Securities/ Mortgage-
"AA" or better by a NRSRO; "A" rated issuer rating or higher by a NRSRO; 20% maximum
Complies*
Backed Securities
Money Market Mutual Funds
"AAA" rated or highest rating by a NRSRO; 20% maximum; 10% per fund
Complies
Prohibited Securities
Inverse floaters; Ranges notes, Interest -only strips from mortgaged backed securities; Zero interest accrual securities;
Complies
Reverse Repurchase Agreements
Repurchase Agreements
20% maximum; 100 days max maturity; collateralized 102% of market value; Not used by investment adviser
Complies
Local Agency Investment Fund (LAIF)
Maximum program; Not used by investment adviser
Complies
Los Angeles County Investment Pool
Maximum program; Not used by investment adviser
Complies
Max per Security Type
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
Max per Issuer
No more than 5% in any single issuer except US Gov, Agencies, Supranationals, Money Market Funds, LAIF, or LGIP
Complies
Maximum Maturity
5 years
Complies
*Account is terminating and liquidating all positions as they mature.
City of West Covina Short Term Reconciliation Summary
Account #10479 As of November 30, 2020
BOOK VALUE RECONCILIATION
BEGINNING BOOK VALUE
$338,245.76
Acquisition
+Security Purchases $0.00
+ Money Market Fund Purchases $22,302.56
+ Money Market Contributions $0.00
+Security Contributions $0.00
+ Security Transfers $0.00
Total Acquisitions
$22,302.56
Dispositions
Security Sales
$0.00
- Money Market Fund Sales
$0.00
- MMF Withdrawals
$67.20
- Security Withdrawals
$0.00
- Security Transfers
$0.00
- Other Dispositions
$0.00
- Maturites
$0.00
Calls
$0.00
Principal Paydowns
$21,864.08
Total Dispositions
$21,931.28
Amortization/Accretion
+/- Net Accretion
($49.57)
($49.57)
Gain/Loss on Dispositions
+/- Realized Gain/Loss
$0.00
$0.00
ENDING BOOK VALUE
$338,567.47
BEGINNING BALANCE
Acquisition
Contributions
Security Sale Proceeds
Accrued Interest Received
Interest Received
Dividend Received
Principal on Maturities
Interest on Maturities
Calls/Redemption (Principal)
Interest from Calls/Redemption
Principal Paydown
Total Acquisitions
$437.
$0.
$157,730.29
Dispositions
Withdrawals
$67.20
Security Purchase
$0.00
Accrued Interest Paid
$0.00
Total Dispositions
$67.20
ENDING BOOK VALUE
$179,965.65
Chandler Asset Management- CONFIDENTIAL Page 3 Execution Time: 12/2/202012:31:53 PM
City of West Covina Short Term
Holdings Report
Account #10479
As of November 30, 2020
Security Description
ABS
Par Value/Units
Purchase Date
Book Yield
Cost Value
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
91.72
04/27/2018
90.29
100.07
91.78
0.03%
Aaa/AAA
0.71
A3
2.63%
91.41
0.23%
0.07
0.37
NR
0.04
1.68% Due 8/16/2021
43814WAB1 Honda Auto Receivables Trust 2019-1
2,305.93
02/19/2019
2,305.78
100.12
2,308.64
0.68%
NR/AAA
0.81
A2
2.77%
2,305.88
0.40%
2.29
2.76
AAA
0.05
2.75% Due 9/20/2021
47788CAC6 John Deere Owner Trust 2018-A A3
8,218.00
02/21/2018
8,217.42
100.36
8,247.82
2.42%
Aaa / NR
1.38
2.66%Due 4/18/2022
2.68%
8,217.81
0.33%
9.72
30.01
AAA
0.15
10,613.49
10,648.24
3.13%
Aaa/AAA
1.25
Total ABS
10,615.65
2.70%
10,615.10
0.34%
12.08
33.14
AAA
0.13
CMO
3137BFDQ1 FHLMC K717 A2
147,373.94
01/04/2018
150,160.24
101.47
149,545.51
44.02%
NR/NR
0.82
2.991% Due 9/25/2021
2.37%
147,986.72
0.44%
367.33
1,558.79
AAA
0.65
150,160.24
149,545.51
44.02%
NR/NR
0.82
Total CMO
147,373.94
2.37%
147,986.72
0.44%
367.33
1,558.79
AAA
0.65
MONEY MARKET FUND FI
'
31846V203 First American Govt Obligation Fund
179,965.65
Various
179,965.65
1.00
179,965.65
52.85%
Aaa / AAA
0.00
Class
0.01%
179,965.65
0.01%
0.00
0.00
AAA
0.00
179,965.65
179,965.65
52.85%
Aaa / AAA
0.00
Total Money Market Fund FI
179,965.65
0.01%
179,965.65
0.01%
0.00
0.00
AAA
0.00
340,739.38
340,159.40
100.00%
Aaa/AAA
0.40
TOTAL PORTFOLIO
337,955.24
1.12%
338,567.47
0.21%
379.41
1,591.93
AAA
0.29
TOTAL MARKET VALUE PLUS ACCRUED
340,538.81
Chandler Asset Management- CONFIDENTIAL Page 4 Execution Time: 12/2/202012:31:53 PM
City of West
Covina Short Term
Transaction Ledger
OR
Account #10479
As of November 30,
2020
Transaction
Type
ACQUISITIONS
Settlement
Date
CUSIP
Quantity
Security Description
Price Acq/Disp
Yield
Amount
Interest
Pur/Sold Total
Amount
Gain/Loss
Purchase
11/02/2020
31846V203
0.74
First American Govt Obligation Fund
1.000
0.01%
0.74
0.00
0.74
0.00
Class Y
Purchase
11/16/2020
31846V203
3,398.37
First American Govt Obligation Fund
1.000
0.01%
3,398.37
0.00
3,398.37
0.00
Class Y
Purchase
11/16/2020
31846V203
59.65
First American Govt Obligation Fund
1.000
0.01%
59.65
0.00
59.65
0.00
Class Y
Purchase
11/16/2020
31846V203
3,929.34
First American Govt Obligation Fund
1.000
0.01%
3,929.34
0.00
3,929.34
0.00
Class Y
Purchase
11/18/2020
31846V203
14,336.07
First American Govt Obligation Fund
1.000
0.01%
14,336.07
0.00
14,336.07
0.00
Class Y
Purchase
11/25/2020
31846V203
578.39
First American Govt Obligation Fund
1.000
0.01%
578.39
0.00
578.39
0.00
Class Y
Subtotal
22,302.56
22,302.56
0.00
22,302.56
0.00
TOTAL ACQUISITIONS
22,302.56
22,302.56
0.00
22,302.56
0.00
DISPOSITIONS
ll�
i
limmob
Paydown
11/16/2020
43811BACS
3,393.49
Honda Auto Receivables Trust 2017-2
100.000
3,393.49
4.88
3,398.37
0.00
A3
1.68% Due 8/16/2021
Paydown
11/16/2020
47788BAD6
59.56
John Deere Owner Trust 2017-B A3
100.000
1.83%
59.56
0.09
59.65
0.00
1.82% Due 10/15/2021
Paydown
11/16/2020
47788CAC6
3,902.47
John Deere Owner Trust 2018-A A3
100.000
3,902.47
26.87
3,929.34
0.00
2.66% Due 4/18/2022
Paydown
11/18/2020
43814WAB1
14,298.02
Honda Auto Receivables Trust 2019-1
100.000
14,298.02
38.05
14,336.07
0.00
A2
2.75% Due 9/20/2021
Paydown
11/25/2020
3137BFDQ1
210.54
FHLMC K717 A2
100.000
210.54
367.85
578.39
0.00
2.991% Due 9/25/2021
Subtotal
21,864.08
21,864.08
437.74
22,301.82
0.00
Security
11/04/2020
31846V203
25.53
First American Govt Obligation Fund
1.000
25.53
0.00
25.53
0.00
Withdrawal
Class Y
Chandler Asset Management-
CONFIDENTIAL
Page 5
Execution Time:
12/2/202012:31:53 PM