HomeMy WebLinkAboutItem 4.10 - 2299 Q1 Investment Report
Page 1 of 5
STAFF REPORT
CITY COUNCIL
DATE: November 20, 2018
TO: Honorable Mayor and City Councilmembers
FROM:
Christopher L. Foss, City Manager
SUBJECT:
City Treasurer's Informational Report of Investments for the Quarter
Ending September 30, 2018
Prepared by: Jay Baksa, Financial Analyst
EXECUTIVE SUMMARY:
The City Council will receive an informational report of the City’s investments through
the quarter ending September 30, 2018 including a monthly transaction ledger. The
City’s investment portfolio for this period totaled $254,650,649 (book value) with an
average market yield of 2.61%. As required by the Policy, the City Treasurer
(Administrative Services Director) affirms that the City is able to meet its expenditure
requirements for the next six months.
STAFF RECOMMENDATION:
Receive the report.
FINANCIAL IMPACT:
There is no financial impact resulting from this report. Fiscal Year 2018 -19 interest
income is budgeted at $2.3 million in all City funds ($1.3 million in the General Fund).
Investments are made in accordance with the City Investment Policy and State
Law. Interest earned is apportioned between funds (i.e. General Fund, Gas Tax
Fund, etc.) based upon their proportionate share of the total cash balance. Based
on the financial needs of the City including the timing of receipt of revenues and
payment of expenditures, the quarterly cash balance can vary from quarter to quarter.
DESCRIPTION:
The total investment portfolio of $254,650,649 (book value) is comprised of
$161,006,691 managed by Chandler Asset Management (Chandler), and $93,643,958
invested by the City in local government pools. The average market yield of the
Chandler portfolio and the local pools was 2.90% and 2.11% respectively. The total
investment portfolio balance fluctuates throughout the year due to normal cash flow
needs and includes both discretionary and restricted funds.
Page 2 of 5
Economic Update Highlights
The following are some highlights from the Economic Update included in the attached
Investment Report prepared by Chandler (Attachment 1).
The Federal Open Market Committee (FOMC) voted to raise the fed funds target rate by
25 basis points to a range of 2.00%-2.25% at the September 26th meeting. Once again,
in its policy statement, the FOMC noted that economic acti vity has been rising at a
“strong rate” and policymakers expect that further gradual increases in the fed funds
rate will be appropriate which points to one more fed funds rate hike this year and three
more hikes next year.
Economic data remains favorable but predictive economic indicators suggest that
economic growth is unlikely to accelerate. The Core PCE Index suggests that inflation is
in line with the Fed's 2.0% target. Market participants are forecasting annualized GDP
growth of about 3.0% in the third quarter, 2.8% in the fourth quarter, and 2.5% next
year.
Treasury yields increased in September. At month-end, the two-year Treasury yield was
up 19 basis points to 2.82%, while the 10-year Treasury yield was up 20 basis points to
3.06%. The spread between two- and 10-year Treasury yields remained narrow at just
24 basis points at month-end. Over the past 20 years, the average spread between two -
and 10-year Treasuries has been about 140 basis points. While Chandler believes an
upward bias to rates across the Treasury yield curve will occur, they predict it will
remain quite flat over the intermediate-term.
City of Dublin Portfolio
The City's portfolio managed by Chandler has maintained a healthy balance of
investment types and remained relatively uncha nged from the quarter ending June 30,
2018, as illustrated in Chart 1 below:
Page 3 of 5
Chart 1: Investments by Type, June 30, 2018 - September 30, 2018
The market value of the City's portfolio decreased by $2.08 million from the June 30,
2018 quarter (see Table 1 below) and increased $33.39 million from the same quarter
the prior year. The quarterly decrease was due to the normal quarterly fluctuations in
timing between when revenue is received and spent, while the yearly increase is
attributed both to growth in City revenues and to the timing of cash inflows and outflows.
Page 4 of 5
Table 1: Portfolio Values and Yield to Maturity
Overall market yield-to-maturity (YTM) increased from 2.40% to 2.61% as shown in
Table 2 below. For detailed monthly transactions, see Attachment 2.
Table 2: Quarterly Holdings (Par Value) by Type, and YTM, 5 Quarters
Funds Managed by the City
The City participates in two local agency investment pools managed by government
finance professionals and treasurers: the Local Agency Investme nt Fund (LAIF) and the
California Asset Management Program (CAMP). The City has typically carried close to
the $50 million maximum allowable in LAIF with any excesses deposited into CAMP.
Page 5 of 5
LAIF quarterly rates are currently the highest measured since 2011, as shown below.
Table 3: Quarterly LAIF Yields, Recent Seven Years and Three Quarters
STRATEGIC PLAN INITIATIVE:
This report is consistent with Strategy #1: Assure the City's long-term financial
sustainability; Strategic Objective A: Maintain strong conservative fiscal policies.
NOTICING REQUIREMENTS/PUBLIC OUTREACH:
None.
ATTACHMENTS:
1. City of Dublin Investment Report for Period Ending September 2018
2. Transaction Ledger - July - September 2018
6225 Lusk Blvd | San Diego, CA 92121 | Phone 800.317.4747 | Fax 858.546.3741 | www.chandlerasset.com
CHANDLER ASSET MAN AGEMEN T
Period Ending
September 30, 2018
City of Dublin
Investment Report
Attachment 1
Table of Contents
SECTION 1 Economic Update
SECTION 2 Account Profile
SECTION 3 Consolidated Information
SECTION 4 Portfolio Holdings
SECTION 5 Transactions
1
Attachment 1
SECTION 1
Economic Update
2
Attachment 1
Economic data remains favorable but predictive economic indicators suggest that economic growth is unlikely to
accelerate. Although the labor market is strong and consumer confidence is high,we do not believe the economy is
close to overheating. The Core PCE Index suggests that inflation is in line with the Fed's 2.0% target. Market
participants are forecasting annualized GDP growth of about 3.0%in the third quarter, 2.8%in the fourth quarter,and
2.5% next year.
Economic Update
▪
▪
▪
As expected, the Federal Open Market Committee (FOMC) voted to raise the fed funds target rate by 25 basis points
to a range of 2.00%-2.25%at the September 26th meeting. The vote was unanimous, including a vote from the new
Board of Governors Vice Chair, Richard Clarida. The Fed raised its median forecast for GDP growth in 2018 and 2019
and left its forecasts for unemployment and inflation relatively unchanged. The Fed also kept its fed funds rate
forecasts unchanged with the exception of the longer-run target which increased slightly to 3.0%. The Fed’s forecast
points to one more fed funds rate hike this year and three more hikes next year. Once again,in its policy statement,
the FOMC noted that economic activity has been rising at a “strong rate”and policymakers expect that further gradual
increases in the fed funds rate will be appropriate. The FOMC continues to believe risks to the economic outlook are
roughly balanced. Market participants believe there is a very high probability that there will be another rate hike in
December.
Treasury yields increased in September.At month-end, the 2-year Treasury yield was up 19 basis points to 2.82%,
while the 10-year Treasury yield was up 20 basis points to 3.06%. The spread between 2- and 10-year Treasury yields
remained narrow at just 24 basis points at month-end. Over the past 20 years, the average spread between 2- and 10-
year Treasuries has been about 140 basis points.We foresee an upward bias to rates across the Treasury yield
curve but believe that the yield curve will remain quite flat over the intermediate-term.
3
Attachment 1
U.S. payrolls rose by 134,000 in September, below the consensus forecast of 185,000. However, July and August payrolls were revised
up by a total of 87,000.On a trailing 3-month and 6-month basis payrolls increased by an average of 190,000 and 203,000 per month,
respectively, more than enough to absorb new entrants into the labor market. The unemployment rate declined further in September to
3.7% from 3.8%in August. The labor participation rate was unchanged month-over-month at 62.7%. A broader measure of
unemployment called the U-6, which includes those who are marginally attached to the labor force and employed part time for economic
reasons, increased to 7.5% from 7.4%in August. Wages rose 0.3%in September on a month-over-month basis,in line with
expectations. Wages were up 2.8%on a year-over-year basis in September, versus up 2.9% year-over-year in August. The average
workweek was unchanged at 34.5 hours. Overall, the September employment report indicates the labor market remains strong,and
there is steady but modest upward pressure on wages.
Employment
Source: US Department of Labor Source: US Department of Labor
0
50
100
150
200
250
300
350
MOM Change In (000's)Nonfarm Payroll (000's)
2.0%
3.0%
4.0%
5.0%
6.0%
7.0%
8.0%
9.0%
10.0%
11.0%
12.0%
Unemployment Rate
Underemployment Rate (U6)
Unemployment Rate (U3)Rate (%)4
Attachment 1
The Consumer Price Index (CPI) was up 2.7% year-over-year in August, versus up 2.9% year-over-year in July. Core CPI(CPI less food
and energy) was up 2.2% year-over-year in August, down from 2.4% year-over-year in July. The Personal Consumption Expenditures
(PCE) index was up 2.2% year-over-year in August, down slightly from 2.3% year-over-year in July. Core PCE (excluding food and
energy) was up 2.0%on a year-over-year basis in August, unchanged from 2.0%in July. Core PCE inflation, which is the Fed's primary
inflation gauge, remains in line with the Fed’s 2.0% target.
Inflation
Source: US Department of Labor Source: US Department of Commerce
0.0%
0.5%
1.0%
1.5%
2.0%
2.5%
3.0%
3.5%
Consumer Price Index (CPI)
CPI YOY % Change
Core CPI YOY % ChangeYOY( %) Change0.0%
0.5%
1.0%
1.5%
2.0%
2.5%
3.0%
3.5%
Personal Consumption Expenditures
(PCE)
PCE Price Deflator YOY % Change
PCE Core Deflator YOY % ChangeYOY( %) Change5
Attachment 1
On a year-over-year basis, retail sales were up 6.6%in August, versus up 6.7% year-over-year in July.On a month-over-month basis,
retail sales increased just 0.1%in August, following an upwardly revised increase of 0.7%in July. Strong sales in July were somewhat
offset by softer trends in August,but the overall pace of consumer spending in the third quarter appears solid. The Consumer Confidence
Index remains very strong at 138.4 in September,up from 134.7 in August. Ongoing strength in the labor market continues to support
consumer confidence and spending trends.
Consumer
Source: US Department of Commerce Source: The Conference Board
0.0%
1.0%
2.0%
3.0%
4.0%
5.0%
6.0%
7.0%
8.0%
Retail Sales YOY % Change
YOY (%) Change85
90
95
100
105
110
115
120
125
130
135
140
145
Index LevelConsumer Confidence
6
Attachment 1
The Index of Leading Economic Indicators (LEI) rose 0.4% month-over-month in August, following a 0.7% increase in July. According to
the Conference Board, the index points to solid US economic growth for the remainder of the year. However, the Conference Board also
warns that industrial companies that are more sensitive to business cycles should prepare for a possible moderation in economic growth
next year. The Chicago Fed National Activity Index (CFNAI) was unchanged month-over-month in August at 0.18, suggesting that
economic activity remains steady. On a 3-month moving average basis, the index increased to 0.24 in August from 0.02 in July.
Economic Activity
-0.2%
0.0%
0.2%
0.4%
0.6%
0.8%
1.0%
1.2%
1.4%
Leading Economic Indicators (LEI)MOM ( %) Change-0.60
-0.40
-0.20
0.00
0.20
0.40
0.60
Chicago Fed National Activity Index
(CFNAI)3 Month AverageSource: The Conference Board Source: Federal Reserve Bank of Chicago
7
Attachment 1
Total housing starts increased 9.2%in August. Single-family starts increased 1.9%in August while multi-family starts surged 29%.
However, permits fell 5.7%in August. According to the Case-Shiller 20-City home price index, home prices were up 5.9% year-over-year
in July, versus 6.4%in June. Housing data tends to be volatile on a month-over-month basis. Broadly speaking, the housing sector is
facing a few different headwinds including supply constraints, rising mortgage interest rates,and a shortage of skilled labor,and housing
trends have softened.
Housing
Source: US Department of Commerce Source: S&P
0
200
400
600
800
1000
1200
1400
1600
1800
MOM Change (In Thousands of Units)Housing Starts
Multi Family Housing Starts
Single Family Housing Starts
4.5%
5.0%
5.5%
6.0%
6.5%
7.0%
7.5%
S&P/CaseShiller 20 City Composite Home
Price Index YOY( %) Change8
Attachment 1
The Institute for Supply Management (ISM) manufacturing index edged down to 59.8 in September from 61.3 in August (the highest level
since May 2004). A reading above 50.0 suggests the manufacturing sector is expanding. The Industrial Production index was up 4.9%
year-over-year in August versus up 4.0% year-over-year in July.On a month-over-month basis, the manufacturing component of the
index edged up just 0.2%in August, following a 0.3% increase in July, pointing to modest growth in the sector. Capacity Utilization
increased to 78.1%in August from 77.9%in July,but remains below the long-run average of 79.8% indicating there is still excess
capacity for growth.
Manufacturing
Source: Institute for Supply Management Source: Federal Reserve
46
48
50
52
54
56
58
60
62
Institute of Supply Management
Purchasing Manager Index
Expanding
Contracting
-3.0%
-2.0%
-1.0%
0.0%
1.0%
2.0%
3.0%
4.0%
5.0%
6.0%
Industrial Production
YOY( %) Change9
Attachment 1
Annualized second quarter GDP grew at an annualized pace of 4.2%, according to the third estimate, following growth of 2.2%in the first
quarter. Consumer spending and exports were particularly strong in the second quarter. Market participants estimate the economy grew
3.0% in the third quarter. GDP growth is expected to ease back toward the 2.5%-3.0% range in the fourth quarter.
Gross Domestic Product (GDP)
Source: US Department of Commerce Source: US Department of Commerce
9/17 12/17 3/18 6/18
1.5% 2.6% 0.4% 2.6%
1.5% 0.1% 1.6% -0.1%
0.0% -0.9% 0.0% 1.2%
-0.1% 0.3% 0.2% 0.2%
-0.1% 0.2% 0.1% 0.2%
2.8% 2.3% 2.2% 4.2%
Total
Components of GDP
Net Exports and Imports
Personal Consumption Expenditures
Gross Private Domestic Investment
Federal Government Expenditures
State and Local (Consumption and Gross
Investment)
-2.0%
-1.0%
0.0%
1.0%
2.0%
3.0%
4.0%
5.0%
6.0%
Gross Domestic Product (GDP)
GDP QOQ % Change
GDP YOY % Change
10
Attachment 1
Source: Bloomberg
On a year-over-year basis, Treasury yields have increased and the Treasury yield curve has flattened. The spread between 2-Year and
10-year Treasury yields has narrowed from 85 basis points to 24 basis points, year-over-year as of September month-end. Rate hikes by
the Federal Reserve have put upward pressure on rates, while supply and demand imbalances, technical factors,and subdued inflation
expectations have contributed to the curve flattening.
Bond Yields
Source: Bloomberg
0.0%
0.5%
1.0%
1.5%
2.0%
2.5%
3.0%
3.5%
4.0%
US Treasury Note Yields
2-Year
5-Year
10-YearYield (%)0.0%
0.5%
1.0%
1.5%
2.0%
2.5%
3.0%
3.5%
4.0%
US Treasury Yield Curve
Sep-18
Jun-18
Sep-17Yield (%)11
Attachment 1
SECTION 2
Account Profile
12
Attachment 1
Objectives
Chandler Asset Management Performance Objective
The performance objective of the City of Dublin is to earn a return that equals or exceeds the return on of the
ICE BAML 1-5 Year Treasury andAgency Index.
Investment Objectives
The investment objectives of the City of Dublin are first,to provide safety of principal;second,to provide
adequate liquidity to meet all requirements which might be reasonably anticipated;third,to attain a market
average rate of return on its investments throughout economic cycles;and fourth,to be diversified to avoid
incurring unreasonable and avoidable risks regarding specific security types or individual financial
institutions.
Strategy
In order to achieve this objective,the portfolio invests in high quality fixed income instruments consistent with
the City's investment policy and California Government Code.
13
Attachment 1
Compliance
Category Standard Comment
Treasury Issues No limitations Complies
Agency Issues 35% max per issuer; 25% max callables Complies
Supranationals "AA" rated or equivalent by a NRSRO; 30% maximum; 5% max per issuer; USD denominated
senior unsecured unsubordinated obligations issued by: IBRD, IFC, IADB
Complies
Municipal Securities "A" rated or higher by a NRSRO; 5% max per issuer Complies
Medium Term Notes "A" rated or higher by a NRSRO; 30% maximum; 5% max per issuer; Issued by corporations
organized and operating within the U.S. or by depository institutions licensed by the U.S. or any
state and operating within the U.S.
Complies
Banker’s Acceptances "A-1" rated or higher by a NRSRO; 40% maximum; 5% max per issuer; 20% max amount invested
in BA with any one financial institution in combination with any other debt from that financial
institution; 180 days max maturity
Complies
Commercial Paper "A-1" rated or higher by a NRSRO; 25% maximum; 5% max per issuer; 20% max amount invested
in CP of any one issuer in combination with any other debt from that issuer; 270 days max maturity
Complies
Negotiable Certificates of Deposit "A" or better long term debt rating and/or "A-1" or higher short term rating by a NRSRO; 30%
maximum; 5% max per issuer; 20% max amount invested in NCDs with any one financial institution
in combination with any other debt from that financial institution.
Complies
Time Deposits/ Certificates of
Deposit
10% max; Collateralized/FDIC Insured; 1 year max maturity Complies
Asset-Backed and Mortgage-
Backed Securities (ABS/MBS)
"AA" rated or higher by a NRSRO; "A" rated or higher for the issuer's debt by a NRSRO; 20%
maximum; 5% max per issue
Complies
Money Market Mutual Funds and
Mutual Funds
Highest rating or "AAA" rated by two NRSROs; SEC registered adviser with AUM >$500 million
and experience greater than 5 years; 10% per one Mutual Fund; 20% maximum in Money Market
Mutual Funds; 20% maximum combined of total portfolio in these securities
Complies
LAIF Max program limit Complies
CAMP Not used by adviser Complies
Max Per Issuer 5% (except US Government, Agencies and its instrumentalities including agency backed-mortgage
pools, Money Market Mutual Funds)
Complies
Maximum Maturity 5 years Complies
City of Dublin
September 30, 2018
COMPLIANCE WITH INVESTMENT POLICY
Assets managed by Chandler Asset Management are in full compliance with state law and with the City's investment policy.
14
Attachment 1
Portfolio Characteristics
City of Dublin
9/30/2018 6/30/2018
Benchmark*Portfolio Portfolio
Average Maturity (yrs)2.68 2.61 2.63
Modified Duration 2.55 2.38 2.43
Average Purchase Yield n/a 1.98%1.90%
Average Market Yield 2.85%2.90%2.69%
Average Quality**AAA AA/Aa1 AA/Aa1
Total Market Value 158,369,049 157,957,588
*ICE BAML 1-5 Yr US Treasury/Agency Index
**Benchmark is a blended rating of S&P, Moody’s, and Fitch. Portfolio is S&P and Moody’s respectively.
15
Attachment 1
ABS
6.3%
Agency
31.8%
Foreign
Corporate
0.9%
Money Market
Fund FI
1.6%
Supranational
2.7%
US Corporate
23.3%
US Treasury
33.5%
Sector Distribution
City of Dublin
September 30, 2018 June 30, 2018
ABS
4.3%
Agency
30.7%
Foreign
Corporate
0.9%
Money Market
Fund FI
1.5%Supranational
2.8%US Corporate
23.7%
US Treasury
34.5%
Negotiable CD
1.8%
16
Attachment 1
Issuers
City of Dublin –Account #10198 As of 9/30/2018
Issue Name Investment Type % Portfolio
Government of United States US Treasury 33.45%
Federal National Mortgage Association Agency 14.34%
Federal Home Loan Bank Agency 10.67%
Federal Home Loan Mortgage Corp Agency 6.76%
John Deere ABS ABS 1.95%
Honda ABS ABS 1.59%
First American Govt Oblig Fund Money Market Fund FI 1.56%
Inter-American Dev Bank Supranational 1.50%
PNC Financial Services Group US Corporate 1.41%
Oracle Corp US Corporate 1.40%
Honda Motor Corporation US Corporate 1.33%
Qualcomm Inc US Corporate 1.26%
Chubb Corporation US Corporate 1.25%
IBM Corp US Corporate 1.25%
Toyota ABS ABS 1.24%
US Bancorp US Corporate 1.24%
Bank of New York US Corporate 1.23%
Intl Bank Recon and Development Supranational 1.23%
Wells Fargo Corp US Corporate 1.21%
JP Morgan Chase & Co US Corporate 1.13%
Microsoft US Corporate 1.12%
Exxon Mobil Corp US Corporate 1.12%
State Street Bank US Corporate 1.11%
Deere & Company US Corporate 1.10%
Eli Lilly & Co US Corporate 0.99%
HSBC Holdings PLC Foreign Corporate 0.93%
Wal-Mart Stores US Corporate 0.88%
Nissan ABS ABS 0.87%
Cisco Systems US Corporate 0.85%
Pepsico Inc US Corporate 0.83%
17
Attachment 1
Issuers
City of Dublin –Account #10198 As of 9/30/2018
Issue Name Investment Type % Portfolio
General Dynamics Corp US Corporate 0.72%
HSBC Holdings PLC US Corporate 0.63%
ChevronTexaco Corp US Corporate 0.62%
American Express ABS ABS 0.62%
Berkshire Hathaway US Corporate 0.62%
Total 100.00%
18
Attachment 1
AAA AA A <A NR
09/30/18 5.9%71.7%16.6%0.0%5.8%
06/30/18 5.1%74.0%16.3%0.0%4.6%
Source: S&P Ratings
Quality Distribution
September 30, 2018 vs. June 30, 2018
City of Dublin
0.00%
10.00%
20.00%
30.00%
40.00%
50.00%
60.00%
70.00%
80.00%
AAA AA A <A NR
9/30/2018 6/30/2018
19
Attachment 1
0.00%
5.00%
10.00%
15.00%
20.00%
25.00%
30.00%
35.00%
0 - 0.25 0.25 - 0.50 0.50 - 1 1 - 2 2 - 3 3 - 4 4 - 5 5+
City of Dublin ICE BAML 1-5 Yr US Treasury/Agency Index
Duration Distribution
City of Dublin
Portfolio Compared to the Benchmark as of September 30, 2018
0 -0.25 0.25 -0.50 0.50 - 1 1 - 2 2 - 3 3 - 4 4 - 5 5+
Portfolio 2.4% 5.5% 8.2% 17.9% 31.5% 22.5% 12.1% 0.0%
Benchmark*0.0% 0.0% 1.8% 33.2% 29.2% 21.6% 14.1% 0.0%
*ICE BAML 1-5 Yr US Treasury/Agency Index
20
Attachment 1
Investment Performance
-0.80%
-0.60%
-0.40%
-0.20%
0.00%
0.20%
0.40%
0.60%
0.80%
1.00%
12 months 2 years 3 years 5 years 10 years Since Inception
City of Dublin City of Dublin Custom Index*
City of Dublin
Period Ending
September 30, 2018
Total Rate of Return
Annualized Since Inception
October 31, 2013
Annualized
3 months 12 months 2 years 3 years 5 years 10 years Since
Inception
City of Dublin 0.26%-0.16%0.13%0.68%N/A N/A 0.86%
ICE BAML 1-5 Yr US Treasury/Agency Index 0.06%-0.55%-0.29%0.31%N/A N/A 0.64%
*ICE BAML 1-3 Yr US Treasury/Agency Index to 12/31/2014
Total rate of return: A measure of a portfolio’s performance over time.It is the internal rate of return, which equates the beginning value of the portfolio with the ending value;it includes
interest earnings, realized and unrealized gains and losses in the portfolio.
21
Attachment 1
Portfolio Characteristics
City of Dublin Reporting Account
9/30/2018 6/30/2018
Portfolio Portfolio
Average Maturity (yrs)0.00 0.00
Modified Duration 0.00 0.00
Average Purchase Yield 2.11%1.93%
Average Market Yield 2.11%1.93%
Average Quality AAA/NR AAA/NR
Total Market Value 93,849,705 96,341,584
22
Attachment 1
LAIF
43.6%
Local Gov
Investment Pool
56.4%
Sector Distribution
City of Dublin Reporting Account
September 30, 2018 June 30, 2018
LAIF
42.3%Local Gov
Investment Pool
57.7%
23
Attachment 1
Issuers
City of Dublin Reporting Account –Account #10219 As of 9/30/2018
Issue Name Investment Type % Portfolio
CAMP Local Gov Investment Pool 56.37%
Local Agency Investment Fund LAIF 43.63%
Total 100.00%
24
Attachment 1
SECTION 3
Consolidated Information
25
Attachment 1
Portfolio Characteristics
City of Dublin Consolidated
9/30/2018 6/30/2018
Portfolio Portfolio
Average Maturity (yrs)1.64 1.63
Modified Duration 1.50 1.51
Average Purchase Yield 2.03%1.91%
Average Market Yield 2.61%2.40%
Average Quality AA+/Aaa AA+/Aaa
Total Market Value 252,218,754 254,299,172
26
Attachment 1
ABS
3.9%
Agency
19.9%
Foreign
Corporate
0.6%
LAIF
16.2%
Local Gov
Investment Pool
21.0%
Money Market
Fund FI
1.0%
Supranational
1.7%
US Corporate
14.6%
US Treasury
21.0%
Sector Distribution
City of Dublin Consolidated
September 30, 2018 June 30, 2018
ABS
2.7%
Agency
19.0%
Foreign
Corporate
0.6%
LAIF
16.0%
Local Gov
Investment Pool
21.9%
Money Market
Fund FI
0.9%
Supranational
1.7%
US Corporate
14.7%
US Treasury
21.4%
Negotiable CD
1.1%
27
Attachment 1
SECTION 4
Portfolio Holdings
28
Attachment 1
Holdings Report
For the Month Ending 9/30/2018
CUSIP Security Description 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
Duration
ABS
47787XAB3 John Deere Owner Trust 2017-A A2
1.500% Due 10/15/2019
89,594.24 02/22/2017
1.21%
89,593.89
89,594.10
99.93
2.65%
89,530.71
59.73
0.06%
(63.39)
Aaa / NR
AAA
1.04
0.06
654747AB0 Nissan Auto Receivables 2017-A A2A
1.470% Due 01/15/2020
157,205.83 03/21/2017
1.23%
157,205.03
157,205.46
99.87
2.46%
157,001.71
102.71
0.10%
(203.75)
Aaa / NR
AAA
1.29
0.13
43814PAB6 Honda Auto Receivables Owner T 17-3 A2
1.570% Due 01/21/2020
240,686.54 09/25/2017
1.10%
240,665.14
240,674.45
99.72
2.58%
240,020.46
136.46
0.15%
(653.99)
NR / AAA
AAA
1.31
0.27
47788MAC4 John Deere Owner Trust 2016-A A3
1.360% Due 04/15/2020
372,635.83 02/23/2016
1.02%
372,577.17
372,613.93
99.68
2.62%
371,435.13
225.24
0.23%
(1,178.80)
Aaa / NR
AAA
1.54
0.26
43814QAC2 Honda Auto Receivables 2016-2 A3
1.390% Due 04/15/2020
317,801.91 05/24/2016
1.16%
317,795.75
317,799.46
99.61
2.61%
316,561.14
196.33
0.20%
(1,238.32)
Aaa / NR
AAA
1.54
0.32
47788BAB0 John Deere Owner Trust 2017-B A2A
1.590% Due 04/15/2020
207,548.74 07/11/2017
1.30%
207,530.71
207,538.63
99.74
2.58%
207,005.29
146.67
0.13%
(533.34)
Aaa / NR
AAA
1.54
0.26
89238BAB8 Toyota Auto Receivables Owner 2018-A A2A
2.100% Due 10/15/2020
1,975,000.00 01/23/2018
1.71%
1,974,798.16
1,974,847.80
99.70
2.70%
1,969,124.38
1,843.33
1.24%
(5,723.42)
Aaa / AAA
NR
2.04
0.50
47788BAD6 John Deere Owner Trust 2017-B A3
1.820% Due 10/15/2021
320,000.00 07/11/2017
1.63%
319,976.58
319,983.23
98.63
3.01%
315,615.34
258.84
0.20%
(4,367.89)
Aaa / NR
AAA
3.04
1.16
47788CAC6 John Deere Owner Trust 2016-B A4
2.660% Due 04/18/2022
515,000.00 02/21/2018
2.68%
514,962.97
514,968.24
99.27
3.13%
511,222.99
608.84
0.32%
(3,745.25)
Aaa / NR
AAA
3.55
1.62
43814UAG4 Honda Auto Receivables 2018-2 A3
3.010% Due 05/18/2022
610,000.00 05/22/2018
3.03%
609,986.70
609,987.84
99.89
3.08%
609,323.51
663.04
0.39%
(664.33)
NR / AAA
AAA
3.63
2.02
43815HAC1 Honda Auto Receivables Owner 2018-3 A3
2.950% Due 08/22/2022
1,360,000.00 08/21/2018
2.98%
1,359,813.41
1,359,817.77
99.67
3.12%
1,355,529.68
1,114.44
0.86%
(4,288.09)
Aaa / NR
AAA
3.90
2.10
02582JHE3 American Express Credit 2017-3 A
1.770% Due 11/15/2022
1,000,000.00 06/28/2018
2.57%
980,625.00
981,763.28
98.15
3.02%
981,530.00
786.67
0.62%
(233.28)
NR / AAA
AAA
4.13
1.49
47788EAC2 John Deere Owner Trust 2018-B A3
3.080% Due 11/15/2022
1,585,000.00 07/18/2018
3.10%
1,584,879.86
1,584,885.05
99.83
3.18%
1,582,351.43
2,169.69
1.00%
(2,533.62)
Aaa / NR
AAA
4.13
2.11
65479GAD1 Nissan Auto Receivables Owner 2018-B A3
3.060% Due 03/15/2023
1,220,000.00 07/17/2018
3.08%
1,219,960.47
1,219,962.06
99.70
3.21%
1,216,308.28
1,659.20
0.77%
(3,653.78)
Aaa / AAA
NR
4.46
2.35
Total ABS 9,970,473.09 2.41%
9,950,370.84
9,951,641.30 2.97%
9,922,560.05
9,971.19
6.27%
(29,081.25)
Aaa / AAA
Aaa
3.25
1.44
Agency
3135G0G72 FNMA Note
1.125% Due 12/14/2018
1,000,000.00 12/18/2015
1.37%
992,790.00
999,510.06
99.77
2.22%
997,742.00
3,343.75
0.63%
(1,768.06)
Aaa / AA+
AAA
0.21
0.20
3133782M2 FHLB Note
1.500% Due 03/08/2019
2,750,000.00 04/24/2015
1.21%
2,779,892.50
2,753,347.28
99.63
2.35%
2,739,860.75
2,635.42
1.73%
(13,486.53)
Aaa / AA+
AAA
0.44
0.43
3137EADG1 FHLMC Note
1.750% Due 05/30/2019
1,000,000.00 01/29/2015
1.28%
1,019,690.00
1,003,001.45
99.50
2.51%
995,005.00
5,881.94
0.63%
(7,996.45)
Aaa / AA+
AAA
0.66
0.65
3135G0ZG1 FNMA Note
1.750% Due 09/12/2019
2,500,000.00 10/28/2014
1.68%
2,508,350.00
2,501,624.00
99.18
2.63%
2,479,410.00
2,309.03
1.57%
(22,214.00)
Aaa / AA+
AAA
0.95
0.93
City of Dublin -Account #10198
29
Attachment 1
Holdings Report
For the Month Ending 9/30/2018
CUSIP Security Description 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
Duration
3137EADM8 FHLMC Note
1.250% Due 10/02/2019
2,500,000.00 12/18/2015
1.64%
2,464,700.00
2,490,644.61
98.62
2.65%
2,465,552.50
15,538.19
1.57%
(25,092.11)
Aaa / AA+
AAA
1.01
0.98
3135G0A78 FNMA Note
1.625% Due 01/21/2020
2,000,000.00 04/07/2015
1.44%
2,016,580.00
2,004,521.82
98.58
2.74%
1,971,538.00
6,319.44
1.25%
(32,983.82)
Aaa / AA+
AAA
1.31
1.28
313383HU8 FHLB Note
1.750% Due 06/12/2020
2,000,000.00 10/08/2015
1.46%
2,026,040.00
2,009,452.46
98.19
2.84%
1,963,882.00
10,597.22
1.25%
(45,570.46)
Aaa / AA+
NR
1.70
1.65
3137EAEK1 FHLMC Note
1.875% Due 11/17/2020
2,400,000.00 11/28/2017
1.91%
2,397,336.00
2,398,088.01
98.00
2.85%
2,352,052.80
16,750.00
1.50%
(46,035.21)
Aaa / AA+
AAA
2.13
2.05
3135G0F73 FNMA Note
1.500% Due 11/30/2020
2,500,000.00 12/04/2015
1.87%
2,455,750.00
2,480,768.27
97.19
2.85%
2,429,747.50
12,604.17
1.54%
(51,020.77)
Aaa / AA+
AAA
2.17
2.10
3130A7CV5 FHLB Note
1.375% Due 02/18/2021
3,470,000.00 Various
1.45%
3,457,221.20
3,463,876.46
96.58
2.87%
3,351,162.91
5,698.99
2.12%
(112,713.55)
Aaa / AA+
AAA
2.39
2.32
3135G0J20 FNMA Note
1.375% Due 02/26/2021
5,000,000.00 Various
1.29%
5,018,675.00
5,009,769.45
96.54
2.87%
4,827,020.00
6,684.02
3.05%
(182,749.45)
Aaa / AA+
AAA
2.41
2.34
313379RB7 FHLB Note
1.875% Due 06/11/2021
3,000,000.00 08/30/2017
1.67%
3,022,620.00
3,016,129.04
97.39
2.89%
2,921,688.00
17,187.50
1.86%
(94,441.04)
Aaa / AA+
AAA
2.70
2.59
3130A8QS5 FHLB Note
1.125% Due 07/14/2021
2,500,000.00 07/25/2016
1.28%
2,481,475.00
2,489,614.15
95.35
2.87%
2,383,870.00
6,015.63
1.51%
(105,744.15)
Aaa / AA+
AAA
2.79
2.71
3137EAEC9 FHLMC Note
1.125% Due 08/12/2021
3,000,000.00 Various
1.33%
2,971,215.00
2,983,272.47
95.17
2.89%
2,854,950.00
4,593.76
1.81%
(128,322.47)
Aaa / AA+
AAA
2.87
2.78
3135G0Q89 FNMA Note
1.375% Due 10/07/2021
2,000,000.00 10/06/2016
1.45%
1,992,924.00
1,995,729.60
95.54
2.93%
1,910,702.00
13,291.67
1.21%
(85,027.60)
Aaa / AA+
AAA
3.02
2.90
3135G0S38 FNMA Note
2.000% Due 01/05/2022
2,500,000.00 01/30/2017
2.04%
2,495,475.00
2,497,003.44
97.11
2.93%
2,427,830.00
11,944.44
1.54%
(69,173.44)
Aaa / AA+
AAA
3.27
3.11
313378CR0 FHLB Note
2.250% Due 03/11/2022
2,000,000.00 06/19/2017
1.86%
2,035,280.00
2,025,708.38
97.74
2.94%
1,954,746.00
2,500.00
1.24%
(70,962.38)
Aaa / AA+
NR
3.45
3.28
3135G0T45 FNMA Note
1.875% Due 04/05/2022
3,250,000.00 05/05/2017
1.99%
3,232,125.00
3,237,219.33
96.47
2.94%
3,135,171.00
29,791.67
2.00%
(102,048.33)
Aaa / AA+
AAA
3.52
3.33
3135G0T94 FNMA Note
2.375% Due 01/19/2023
2,500,000.00 03/28/2018
2.70%
2,463,675.00
2,467,520.45
97.49
3.00%
2,437,167.50
11,875.00
1.55%
(30,352.95)
Aaa / AA+
AAA
4.31
4.03
313383QR5 FHLB Note
3.250% Due 06/09/2023
1,500,000.00 08/28/2018
2.87%
1,525,005.00
1,524,532.13
101.06
3.01%
1,515,826.50
15,166.67
0.97%
(8,705.63)
Aaa / AA+
NR
4.69
4.28
3137EAEN5 FHLMC Note
2.750% Due 06/19/2023
2,000,000.00 07/16/2018
2.88%
1,988,360.00
1,988,852.01
98.77
3.03%
1,975,412.00
16,805.56
1.26%
(13,440.01)
Aaa / AA+
AAA
4.72
4.35
Total Agency 51,370,000.00 1.72%
51,345,178.70
51,340,184.87 2.82%
50,090,336.46
217,534.07
31.77%
(1,249,848.41)
Aaa / AA+
Aaa
2.47
2.36
City of Dublin -Account #10198
30
Attachment 1
Holdings Report
For the Month Ending 9/30/2018
CUSIP Security Description 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
Duration
Foreign Corporate
404280BF5 HSBC Holdings PLC Note
2.650% Due 01/05/2022
1,500,000.00 01/12/2018
2.89%
1,486,320.00
1,488,746.34
97.11
3.60%
1,456,605.00
9,495.83
0.93%
(32,141.34)
A2 / A
AA-
3.27
3.07
Total Foreign Corporate 1,500,000.00 2.89%
1,486,320.00
1,488,746.34 3.60%
1,456,605.00
9,495.83
0.93%
(32,141.34)
A2 / A
AA-
3.27
3.07
Money Market Fund FI
31846V203 First American Govt Obligation Fund 2,477,480.99 Various
1.67%
2,477,480.99
2,477,480.99
1.00
1.67%
2,477,480.99
0.00
1.56%
0.00
Aaa / AAA
AAA
0.00
0.00
Total Money Market Fund FI 2,477,480.99 1.67%
2,477,480.99
2,477,480.99 1.67%
2,477,480.99
0.00
1.56%
0.00
Aaa / AAA
Aaa
0.00
0.00
Supranational
459058FY4 Intl. Bank Recon & Development Note
2.000% Due 01/26/2022
2,000,000.00 10/26/2017
2.12%
1,990,320.00
1,992,419.73
96.74
3.04%
1,934,824.00
7,222.22
1.23%
(57,595.73)
Aaa / NR
AAA
3.33
3.17
4581X0CZ9 Inter-American Dev Bank Note
1.750% Due 09/14/2022
2,500,000.00 11/28/2017
2.18%
2,451,675.00
2,460,102.17
95.18
3.05%
2,379,595.00
2,065.97
1.50%
(80,507.17)
NR / NR
AAA
3.96
3.77
Total Supranational 4,500,000.00 2.15%
4,441,995.00
4,452,521.90 3.05%
4,314,419.00
9,288.19
2.73%
(138,102.90)
Aaa / NR
Aaa
3.67
3.50
US Corporate
17275RAR3 Cisco Systems Note
2.125% Due 03/01/2019
1,350,000.00 11/14/2014
2.05%
1,354,063.50
1,350,392.57
99.85
2.48%
1,347,960.15
2,390.63
0.85%
(2,432.42)
A1 / AA-
NR
0.42
0.42
532457BF4 Eli Lilly & Co Note
1.950% Due 03/15/2019
1,575,000.00 Various
1.91%
1,577,796.75
1,575,294.12
99.56
2.93%
1,568,016.45
1,365.00
0.99%
(7,277.67)
A2 / AA-
A
0.45
0.45
94974BFU9 Wells Fargo Corp Note
2.125% Due 04/22/2019
1,900,000.00 Various
2.07%
1,904,120.50
1,900,582.84
99.68
2.70%
1,893,975.10
17,832.28
1.21%
(6,607.74)
A2 / A-
A+
0.56
0.55
02665WAH4 American Honda Finance Note
2.250% Due 08/15/2019
1,800,000.00 Various
2.08%
1,812,627.00
1,802,585.75
99.54
2.79%
1,791,660.60
5,175.00
1.13%
(10,925.15)
A2 / A+
NR
0.87
0.86
06406HCW7 Bank of New York Callable Note Cont 8/11/2019
2.300% Due 09/11/2019
750,000.00 04/22/2015
1.82%
764,722.50
752,950.14
99.52
2.82%
746,370.00
958.33
0.47%
(6,580.14)
A1 / A
AA-
0.95
0.93
68389XAX3 Oracle Corp Note
2.250% Due 10/08/2019
1,250,000.00 Various
1.73%
1,272,172.50
1,256,392.37
99.50
2.75%
1,243,752.50
13,515.63
0.79%
(12,639.87)
A1 / AA-
A
1.02
0.99
40428HPN6 HSBC USA Inc Note
2.375% Due 11/13/2019
1,000,000.00 11/07/2014
2.32%
1,002,440.00
1,000,545.19
99.34
2.98%
993,380.00
9,104.17
0.63%
(7,165.19)
A2 / A
AA-
1.12
1.09
46625HKA7 JP Morgan Chase Callable Note Cont 12/23/2019
2.250% Due 01/23/2020
1,800,000.00 Various
2.37%
1,790,172.00
1,797,273.63
98.98
3.05%
1,781,580.60
7,650.00
1.13%
(15,693.03)
A3 / A-
AA-
1.32
1.28
713448CS5 PepsiCo Inc Callable Note Cont 3/30/2020
1.850% Due 04/30/2020
1,330,000.00 04/27/2015
1.86%
1,329,241.90
1,329,760.58
98.41
2.88%
1,308,863.64
10,320.43
0.83%
(20,896.94)
A1 / A+
A
1.58
1.53
747525AD5 Qualcomm Inc Note
2.250% Due 05/20/2020
2,000,000.00 Various
2.22%
2,001,128.80
2,000,935.43
98.69
3.07%
1,973,824.00
16,375.01
1.26%
(27,111.43)
A2 / A-
NR
1.64
1.58
City of Dublin -Account #10198
31
Attachment 1
Holdings Report
For the Month Ending 9/30/2018
CUSIP Security Description 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
Duration
24422ESY6 John Deere Capital Corp Note
2.375% Due 07/14/2020
1,000,000.00 09/15/2016
1.69%
1,025,153.50
1,011,773.21
98.74
3.10%
987,395.00
5,079.86
0.63%
(24,378.21)
A2 / A
A
1.79
1.73
00440EAT4 Chubb INA Holdings Inc Callable Note Cont
10/3/2020
2.300% Due 11/03/2020
2,000,000.00 Various
2.25%
2,003,489.00
2,001,966.70
98.18
3.21%
1,963,620.00
18,911.11
1.25%
(38,346.70)
A3 / A
A
2.10
2.00
24422ETF6 John Deere Capital Corp Note
2.550% Due 01/08/2021
750,000.00 Various
2.42%
753,733.15
752,095.67
98.64
3.18%
739,781.26
4,409.38
0.47%
(12,314.41)
A2 / A
A
2.28
2.17
30231GAV4 Exxon Mobil Corp Callable Note Cont 2/1/2021
2.222% Due 03/01/2021
1,800,000.00 Various
2.06%
1,813,024.00
1,806,601.82
98.01
3.08%
1,764,232.20
3,333.00
1.12%
(42,369.62)
Aaa / AA+
NR
2.42
2.33
369550BE7 General Dynamics Corp Note
3.000% Due 05/11/2021
1,130,000.00 05/08/2018
3.24%
1,122,146.50
1,123,171.18
99.47
3.21%
1,123,956.76
13,183.33
0.72%
785.58
A2 / A+
NR
2.61
2.47
166764BG4 Chevron Corp Callable Note Cont 4/15/2021
2.100% Due 05/16/2021
1,000,000.00 04/20/2017
2.09%
1,000,190.00
1,000,122.82
97.54
3.08%
975,430.00
7,875.00
0.62%
(24,692.82)
Aa2 / AA-
NR
2.63
2.51
857477AV5 State Street Bank Note
1.950% Due 05/19/2021
1,800,000.00 Various
1.91%
1,802,989.00
1,801,753.27
96.75
3.25%
1,741,525.20
12,870.00
1.11%
(60,228.07)
A1 / A
AA-
2.64
2.52
594918BP8 Microsoft Callable Note Cont 7/8/21
1.550% Due 08/08/2021
1,850,000.00 Various
1.59%
1,846,471.85
1,847,959.62
95.98
3.03%
1,775,678.10
4,221.60
1.12%
(72,281.52)
Aaa / AAA
AA+
2.86
2.76
68389XBK0 Oracle Corp Callable Note Cont 8/01/21
1.900% Due 09/15/2021
1,000,000.00 06/28/2018
3.08%
964,080.00
966,956.05
96.55
3.13%
965,525.00
844.44
0.61%
(1,431.05)
A1 / AA-
A
2.96
2.84
91159HHP8 US Bancorp Callable Cont 12/23/2021
2.625% Due 01/24/2022
2,000,000.00 05/23/2017
2.35%
2,023,280.00
2,016,415.74
97.76
3.34%
1,955,210.00
9,770.83
1.24%
(61,205.74)
A1 / A+
AA-
3.32
3.13
44932HAH6 IBM Credit Corp Note
3.000% Due 02/06/2023
2,000,000.00 02/26/2018
3.09%
1,991,340.00
1,992,372.10
98.31
3.42%
1,966,130.00
9,166.67
1.25%
(26,242.10)
A1 / A+
A+
4.36
4.02
084670BR8 Berkshire Hathaway Callable Note Cont 1/15/2023
2.750% Due 03/15/2023
1,000,000.00 04/20/2018
3.28%
976,380.00
978,496.01
97.67
3.32%
976,650.00
1,222.22
0.62%
(1,846.01)
Aa2 / AA
A+
4.46
4.15
69353RFL7 PNC Bank Callable Note Cont 5/9/2023
3.500% Due 06/08/2023
2,210,000.00 Various
3.53%
2,206,955.80
2,207,142.42
99.64
3.58%
2,202,015.27
24,279.30
1.41%
(5,127.15)
A2 / A
NR
4.69
4.24
931142EK5 Wal-Mart Stores Callable Note Cont 5/26/2023
3.400% Due 06/26/2023
1,380,000.00 Various
3.41%
1,379,641.30
1,379,660.17
100.44
3.30%
1,386,007.15
12,251.34
0.88%
6,346.98
Aa2 / AA
AA
4.74
4.24
02665WCJ8 American Honda Finance Note
3.450% Due 07/14/2023
300,000.00 07/11/2018
3.49%
299,481.00
299,502.91
99.85
3.48%
299,543.10
2,156.25
0.19%
40.19
A2 / A+
NR
4.79
4.35
06406RAJ6 Bank of NY Mellon Corp Note
3.450% Due 08/11/2023
1,200,000.00 08/24/2018
3.42%
1,201,836.00
1,201,801.49
99.51
3.56%
1,194,171.60
5,520.00
0.76%
(7,629.89)
A1 / A
AA-
4.87
4.42
Total US Corporate 37,175,000.00 2.40%
37,218,676.55
37,154,503.80 3.11%
36,666,253.68
219,780.81
23.29%
(488,250.12)
A1 / A+
A+
2.40
2.26
US Treasury
912828D80 US Treasury Note
1.625% Due 08/31/2019
1,250,000.00 Various
1.78%
1,240,759.40
1,248,295.69
99.09
2.64%
1,238,622.50
1,739.47
0.78%
(9,673.19)
Aaa / AA+
AAA
0.92
0.90
912828G61 US Treasury Note
1.500% Due 11/30/2019
2,000,000.00 Various
1.45%
2,003,378.10
2,001,026.18
98.63
2.70%
1,972,578.00
10,081.97
1.25%
(28,448.18)
Aaa / AA+
AAA
1.17
1.14
912828G95 US Treasury Note
1.625% Due 12/31/2019
3,000,000.00 01/08/2015
1.50%
3,017,470.99
3,004,394.25
98.66
2.72%
2,959,923.00
12,319.97
1.88%
(44,471.25)
Aaa / AA+
AAA
1.25
1.22
City of Dublin -Account #10198
32
Attachment 1
Holdings Report
For the Month Ending 9/30/2018
CUSIP Security Description 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
Duration
912828H52 US Treasury Note
1.250% Due 01/31/2020
4,500,000.00 Various
1.53%
4,440,542.42
4,483,874.69
98.06
2.74%
4,412,812.50
9,476.91
2.79%
(71,062.19)
Aaa / AA+
AAA
1.34
1.31
912828K58 US Treasury Note
1.375% Due 04/30/2020
1,750,000.00 05/06/2015
1.55%
1,735,171.88
1,745,299.00
97.83
2.78%
1,712,060.00
10,069.63
1.09%
(33,239.00)
Aaa / AA+
AAA
1.58
1.54
912828XE5 US Treasury Note
1.500% Due 05/31/2020
3,000,000.00 Various
1.67%
2,976,025.68
2,991,876.20
97.91
2.79%
2,937,186.00
15,122.95
1.86%
(54,690.20)
Aaa / AA+
AAA
1.67
1.62
912828XM7 US Treasury Note
1.625% Due 07/31/2020
1,500,000.00 09/08/2015
1.52%
1,507,622.21
1,502,853.53
97.88
2.82%
1,468,242.00
4,106.66
0.93%
(34,611.53)
Aaa / AA+
AAA
1.84
1.78
912828L99 US Treasury Note
1.375% Due 10/31/2020
5,000,000.00 Various
1.69%
4,927,376.14
4,969,124.34
97.06
2.84%
4,852,930.00
28,770.38
3.08%
(116,194.34)
Aaa / AA+
AAA
2.09
2.02
912828N89 US Treasury Note
1.375% Due 01/31/2021
2,000,000.00 03/15/2016
1.49%
1,988,834.83
1,994,655.51
96.67
2.86%
1,933,360.00
4,633.15
1.22%
(61,295.51)
Aaa / AA+
AAA
2.34
2.27
912828S76 US Treasury Note
1.125% Due 07/31/2021
1,500,000.00 12/12/2016
1.89%
1,449,262.83
1,468,975.62
95.25
2.88%
1,428,691.50
2,843.07
0.90%
(40,284.12)
Aaa / AA+
AAA
2.84
2.75
912828T34 US Treasury Note
1.125% Due 09/30/2021
2,750,000.00 Various
1.66%
2,682,431.10
2,708,119.54
94.97
2.89%
2,611,642.00
85.00
1.65%
(96,477.54)
Aaa / AA+
AAA
3.00
2.91
912828U65 US Treasury Note
1.750% Due 11/30/2021
2,500,000.00 12/28/2016
2.06%
2,464,461.50
2,477,138.28
96.54
2.90%
2,413,477.50
14,702.87
1.53%
(63,660.78)
Aaa / AA+
AAA
3.17
3.03
912828V72 US Treasury Note
1.875% Due 01/31/2022
1,500,000.00 02/27/2017
1.84%
1,502,407.37
1,501,630.80
96.73
2.91%
1,450,957.50
4,738.45
0.92%
(50,673.30)
Aaa / AA+
AAA
3.34
3.19
912828J76 US Treasury Note
1.750% Due 03/31/2022
3,000,000.00 04/25/2017
1.85%
2,985,830.37
2,989,947.43
96.16
2.91%
2,884,686.00
144.23
1.82%
(105,261.43)
Aaa / AA+
AAA
3.50
3.36
912828WZ9 US Treasury Note
1.750% Due 04/30/2022
2,750,000.00 05/23/2017
1.84%
2,738,944.75
2,741,981.57
96.06
2.92%
2,641,611.50
20,249.32
1.68%
(100,370.07)
Aaa / AA+
AAA
3.58
3.41
912828XR6 US Treasury Note
1.750% Due 05/31/2022
1,500,000.00 06/28/2017
1.81%
1,496,020.65
1,497,037.08
95.96
2.92%
1,439,413.50
8,821.72
0.91%
(57,623.58)
Aaa / AA+
AAA
3.67
3.49
912828XW5 US Treasury Note
1.750% Due 06/30/2022
3,000,000.00 07/25/2017
1.86%
2,984,072.55
2,987,895.14
95.88
2.92%
2,876,367.00
13,267.66
1.82%
(111,528.14)
Aaa / AA+
AAA
3.75
3.58
912828L24 US Treasury Note
1.875% Due 08/31/2022
2,000,000.00 09/27/2017
1.92%
1,995,944.20
1,996,774.31
96.11
2.93%
1,922,266.00
3,211.33
1.22%
(74,508.31)
Aaa / AA+
AAA
3.92
3.73
912828L57 US Treasury Note
1.750% Due 09/30/2022
3,750,000.00 Various
2.02%
3,702,841.80
3,711,500.89
95.56
2.93%
3,583,447.50
180.29
2.26%
(128,053.39)
Aaa / AA+
AAA
4.00
3.82
912828M49 US Treasury Note
1.875% Due 10/31/2022
1,000,000.00 01/30/2018
2.47%
973,359.38
977,092.75
95.95
2.93%
959,492.00
7,846.47
0.61%
(17,600.75)
Aaa / AA+
AAA
4.09
3.86
9128284D9 US Treasury Note
2.500% Due 03/31/2023
3,750,000.00 Various
2.75%
3,706,123.05
3,710,044.79
98.14
2.94%
3,680,418.75
257.55
2.32%
(29,626.04)
Aaa / AA+
AAA
4.50
4.22
City of Dublin -Account #10198
33
Attachment 1
Holdings Report
For the Month Ending 9/30/2018
CUSIP Security Description 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
Duration
912828R69 US Treasury Note
1.625% Due 05/31/2023
1,500,000.00 05/30/2018
2.67%
1,427,167.97
1,432,073.96
94.29
2.94%
1,414,278.00
8,191.60
0.90%
(17,795.96)
Aaa / AA+
AAA
4.67
4.42
Total US Treasury 54,500,000.00 1.84%
53,946,049.17
54,141,611.55 2.85%
52,794,462.75
180,860.65
33.45%
(1,347,148.80)
Aaa / AA+
Aaa
2.78
2.67
TOTAL PORTFOLIO 161,492,954.08 1.98%
160,866,071.25
161,006,690.75 2.90%
157,722,117.93
646,930.74
100.00%
(3,284,572.82)
Aa1 / AA
Aaa
2.61
2.38
TOTAL MARKET VALUE PLUS ACCRUALS 158,369,048.67
City of Dublin -Account #10198
34
Attachment 1
Holdings Report
For the Month Ending 9/30/2018
CUSIP Security Description 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
Duration
LAIF
90LAIF$00 Local Agency Investment Fund State Pool 40,744,773.11 Various
2.09%
40,744,773.11
40,744,773.11
1.00
2.09%
40,744,773.11
205,746.82
43.63%
0.00
NR / NR
NR
0.00
0.00
Total LAIF 40,744,773.11 2.09%
40,744,773.11
40,744,773.11 2.09%
40,744,773.11
205,746.82
43.63%
0.00
NR / NR
NR
0.00
0.00
Local Gov Investment Pool
90CAMP$00 California Asset Mgmt Program CAMP 52,899,184.97 Various
2.12%
52,899,184.97
52,899,184.97
1.00
2.12%
52,899,184.97
0.00
56.37%
0.00
NR / AAA
NR
0.00
0.00
Total Local Gov Investment Pool 52,899,184.97 2.12%
52,899,184.97
52,899,184.97 2.12%
52,899,184.97
0.00
56.37%
0.00
NR / AAA
NR
0.00
0.00
TOTAL PORTFOLIO 93,643,958.08 2.11%
93,643,958.08
93,643,958.08 2.11%
93,643,958.08
205,746.82
100.00%
0.00
NR / AAA
NR
0.00
0.00
TOTAL MARKET VALUE PLUS ACCRUALS 93,849,704.90
City of Dublin Reporting Account -Account #10219
35
Attachment 1
SECTION 5
Transactions
36
Attachment 1
Transaction Ledger
City of Dublin -Account #10198
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price
Acq/Disp
Yield Amount
Interest
Pur/Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 07/16/2018 02665WCJ8 300,000.00 American Honda Finance Note
3.45% Due: 07/14/2023 99.827 3.49%299,481.00 0.00 299,481.00 0.00
Purchase 07/17/2018 3137EAEN5 2,000,000.00 FHLMC Note
2.75% Due: 06/19/2023 99.418 2.88%1,988,360.00 5,500.00 1,993,860.00 0.00
Purchase 07/25/2018 47788EAC2 1,585,000.00 John Deere Owner Trust 2018-B A3
3.08% Due: 11/15/2022 99.992 3.10%1,584,879.86 0.00 1,584,879.86 0.00
Purchase 07/25/2018 65479GAD1 1,220,000.00 Nissan Auto Receivables Owner 2018-B A3
3.06% Due: 03/15/2023 99.997 3.08%1,219,960.47 0.00 1,219,960.47 0.00
Purchase 08/28/2018 06406RAJ6 1,200,000.00 Bank of NY Mellon Corp Note
3.45% Due: 08/11/2023 100.153 3.42%1,201,836.00 1,725.00 1,203,561.00 0.00
Purchase 08/28/2018 43815HAC1 1,360,000.00 Honda Auto Receivables Owner 2018-3 A3
2.95% Due: 08/22/2022 99.986 2.98%1,359,813.41 0.00 1,359,813.41 0.00
Purchase 08/29/2018 313383QR5 1,500,000.00 FHLB Note
3.25% Due: 06/09/2023 101.667 2.87%1,525,005.00 10,833.33 1,535,838.33 0.00
Subtotal 9,165,000.00 9,179,335.74 18,058.33 9,197,394.07 0.00
TOTAL ACQUISITIONS 9,165,000.00 9,179,335.74 18,058.33 9,197,394.07 0.00
DISPOSITIONS
Sale 07/18/2018 912828D80 1,250,000.00 US Treasury Note
1.625% Due: 08/31/2019 99.074 2.47%1,238,427.73 7,727.58 1,246,155.31 -9485.26
Sale 07/20/2018 3135G0G72 1,500,000.00 FNMA Note
1.125% Due: 12/14/2018 99.587 2.16%1,493,805.00 1,687.50 1,495,492.50 -4735.12
Subtotal 2,750,000.00 2,732,232.73 9,415.08 2,741,647.81 -14,220.38
Maturity 08/01/2018 06406HCL1 1,000,000.00 Bank of New York Callable Note Cont 7/2/2018
2.1% Due: 08/01/2018 100.000 1,000,000.00 0.00 1,000,000.00 0.00
Maturity 08/09/2018 06417GXH6 2,775,000.00 Bank of Nova Scotia Yankee CD
1.57% Due: 08/09/2018 100.000 2,775,000.00 44,172.61 2,819,172.61 0.00
June 30, 2018 through September 30, 2018
37
Attachment 1
Transaction Ledger
City of Dublin -Account #10198
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price
Acq/Disp
Yield Amount
Interest
Pur/Sold Total Amount Gain/Loss
Maturity 08/15/2018 084664BY6 1,000,000.00 Berkshire Hathaway Note
2% Due: 08/15/2018 100.000 1,000,000.00 0.00 1,000,000.00 0.00
Subtotal 4,775,000.00 4,775,000.00 44,172.61 4,819,172.61 0.00
TOTAL DISPOSITIONS 8,542,998.21 8,525,230.94 99,857.30 8,625,088.24 -14,220.38
June 30, 2018 through September 30, 2018
38
Attachment 1
Transaction Ledger
City of Dublin Reporting Account -Account #10219
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price
Acq/Disp
Yield Amount
Interest
Pur/Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 07/15/2018 90LAIF$00 192,423.97 Local Agency Investment Fund State Pool 1.000 1.90%192,423.97 0.00 192,423.97 0.00
Purchase 07/31/2018 90CAMP$00 103,196.26 California Asset Mgmt Program CAMP 1.000 2.09%103,196.26 0.00 103,196.26 0.00
Purchase 08/31/2018 90CAMP$00 96,567.21 California Asset Mgmt Program CAMP 1.000 2.12%96,567.21 0.00 96,567.21 0.00
Purchase 09/30/2018 90CAMP$00 88,014.04 California Asset Mgmt Program CAMP 1.000 2.12%88,014.04 0.00 88,014.04 0.00
Subtotal 480,201.48 480,201.48 0.00 480,201.48 0.00
Security
Contribution 07/09/2018 90CAMP$00 3,000,000.00 California Asset Mgmt Program CAMP 1.000 3,000,000.00 0.00 3,000,000.00 0.00
Security
Contribution 07/27/2018 90CAMP$00 1,900,000.00 California Asset Mgmt Program CAMP 1.000 1,900,000.00 0.00 1,900,000.00 0.00
Security
Contribution 08/31/2018 90CAMP$00 1,500,000.00 California Asset Mgmt Program CAMP 1.000 1,500,000.00 0.00 1,500,000.00 0.00
Security
Contribution 09/24/2018 90CAMP$00 4,000,000.00 California Asset Mgmt Program CAMP 1.000 4,000,000.00 0.00 4,000,000.00 0.00
Subtotal 10,400,000.00 10,400,000.00 0.00 10,400,000.00 0.00
TOTAL ACQUISITIONS 10,880,201.48 10,880,201.48 0.00 10,880,201.48 0.00
DISPOSITIONS
Security
Withdrawal 07/16/2018 90CAMP$00 500,000.00 California Asset Mgmt Program CAMP 1.000 500,000.00 0.00 500,000.00 0.00
Security
Withdrawal 07/23/2018 90CAMP$00 800,000.00 California Asset Mgmt Program CAMP 1.000 800,000.00 0.00 800,000.00 0.00
Security
Withdrawal 08/03/2018 90CAMP$00 2,300,000.00 California Asset Mgmt Program CAMP 1.000 2,300,000.00 0.00 2,300,000.00 0.00
Security
Withdrawal 08/14/2018 90CAMP$00 2,200,000.00 California Asset Mgmt Program CAMP 1.000 2,200,000.00 0.00 2,200,000.00 0.00
Security
Withdrawal 08/20/2018 90CAMP$00 5,000,000.00 California Asset Mgmt Program CAMP 1.000 5,000,000.00 0.00 5,000,000.00 0.00
Security
Withdrawal 08/24/2018 90CAMP$00 1,800,000.00 California Asset Mgmt Program CAMP 1.000 1,800,000.00 0.00 1,800,000.00 0.00
June 30, 2018 through September 30, 2018
39
Attachment 1
Transaction Ledger
City of Dublin Reporting Account -Account #10219
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price
Acq/Disp
Yield Amount
Interest
Pur/Sold Total Amount Gain/Loss
Security
Withdrawal 09/10/2018 90CAMP$00 800,000.00 California Asset Mgmt Program CAMP 1.000 800,000.00 0.00 800,000.00 0.00
Subtotal 13,400,000.00 13,400,000.00 0.00 13,400,000.00 0.00
TOTAL DISPOSITIONS 13,400,000.00 13,400,000.00 0.00 13,400,000.00 0.00
June 30, 2018 through September 30, 2018
40
Attachment 1
Disclosure
2018 Chandler Asset Management, Inc,An Independent Registered Investment Adviser.
Information contained herein is confidential.Prices are provided by IDC,an independent pricing source.In the event IDC does not provide a
price or if the price provided is not reflective of fair market value, Chandler will obtain pricing from an alternative approved third party pricing
source in accordance with our written valuation policy and procedures.Our valuation procedures are also disclosed in Item 5 of our Form ADV
Part 2A.
Performance results are presented gross-of-fees and represent the client’s Total Return.These results include the reinvestment of dividends
and other earnings.Past performance may not be indicative of future results.Therefore,no current or prospective client should assume that
future performance of any specific investment or investment strategy will be profitable or equal to past performance levels.All investment
strategies have the potential for profit or loss.Economic factors, market conditions or changes in investment strategies, contributions or
withdrawals may materially alter the performance and results of your portfolio.
Index returns assume reinvestment of all distributions.Historical performance results for investment indexes generally do not reflect the
deduction of transaction and/or custodial charges or the deduction of an investment management fee, the incurrence of which would have the
effect of decreasing historical performance results.It is not possible to invest directly in an index.
Source ice Data Indices,LLC ("ICE"),used with permission.ICE PERMITS USE OF THE ICE INDICES AND RELATED DATA ON AN "AS IS"
BASIS;ICE,ITS AFFILIATES AND THEIR RESPECTIVE THIRD PARTY SUPPLIERS DISCLAIM ANY AND ALL WARRANTIES AND
REPRESENTATIONS, EXPRESS AND/OR IMPLIED,INCLUDING ANY WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A
PARTICULAR PURPOSE OR USE,INCLUDING THE INDICES, INDEX DATA AND ANY DATA INCLUDED IN,RELATED TO,OR DERIVED
THEREFROM.NEITHER ICE DATA,ITS AFFILIATES OR THEIR RESPECTIVE THIRD PARTY PROVIDERS GUARANTEE THE QUALITY,
ADEQUACY,ACCURACY,TIMELINESS OR COMPLETENESS OF THE INDICES OR THE INDEX DATA OR ANY COMPONENT THEREOF,
AND THE INDICES AND INDEX DATA AND ALL COMPONENTS THEREOF ARE PROVIDED ON AN "AS IS" BASIS AND LICENSEE'S USE
IS AT LICENSEE'S OWN RISK.ICE DATA,ITS AFFILIATES AND THEIR RESPECTIVE THIRD PARTY DO NOT SPONSOR, ENDORSE,OR
RECOMMEND CHANDLER ASSET MANAGEMENT,OR ANY OF ITS PRODUCTS OR SERVICES.
This report is provided for informational purposes only and should not be construed as a specific investment or legal advice.The information
contained herein was obtained from sources believed to be reliable as of the date of publication, but may become outdated or superseded at
any time without notice.Any opinions or views expressed are based on current market conditions and are subject to change.This report may
contain forecasts and forward-looking statements which are inherently limited and should not be relied upon as indicator of future results.Past
performance is not indicative of future results.This report is not intended to constitute an offer,solicitation,recommendation or advice regarding
any securities or investment strategy and should not be regarded by recipients as a substitute for the exercise of their own judgment.
Fixed income investments are subject to interest,credit and market risk.Interest rate risk:the value of fixed income investments will decline as
interest rates rise.Credit risk:the possibility that the borrower may not be able to repay interest and principal.Low rated bonds generally have
to pay higher interest rates to attract investors willing to take on greater risk.Market risk:the bond market in general could decline due to
economic conditions, especially during periods of rising interest rates.
41
Attachment 1
Transaction Ledger
6/30/18 Thru 7/31/18
City of Dublin Consolidated
Account #10221
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price
Acq/Disp
Yield Amount
Interest
Pur/Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 07/02/2018 31846V203 3,414.34 First American Govt Obligation Fund 1.000 1.50 %3,414.34 0.00 3,414.34 0.00
Purchase 07/05/2018 31846V203 44,875.00 First American Govt Obligation Fund 1.000 1.50 %44,875.00 0.00 44,875.00 0.00
Purchase 07/08/2018 31846V203 9,562.50 First American Govt Obligation Fund 1.000 1.50 %9,562.50 0.00 9,562.50 0.00
Purchase 07/14/2018 31846V203 25,937.50 First American Govt Obligation Fund 1.000 1.50 %25,937.50 0.00 25,937.50 0.00
Purchase 07/15/2018 90LAIF$00 192,423.97 Local Agency Investment Fund State Pool 1.000 1.90 %192,423.97 0.00 192,423.97 0.00
Purchase 07/16/2018 02665WCJ8 300,000.00 American Honda Finance Note
3.45% Due 7/14/2023
99.827 3.49 %299,481.00 0.00 299,481.00 0.00
Purchase 07/16/2018 31846V203 1,475.00 First American Govt Obligation Fund 1.000 1.50 %1,475.00 0.00 1,475.00 0.00
Purchase 07/16/2018 31846V203 48,678.96 First American Govt Obligation Fund 1.000 1.50 %48,678.96 0.00 48,678.96 0.00
Purchase 07/16/2018 31846V203 48,221.19 First American Govt Obligation Fund 1.000 1.50 %48,221.19 0.00 48,221.19 0.00
Purchase 07/16/2018 31846V203 24,140.40 First American Govt Obligation Fund 1.000 1.50 %24,140.40 0.00 24,140.40 0.00
Purchase 07/16/2018 31846V203 485.33 First American Govt Obligation Fund 1.000 1.50 %485.33 0.00 485.33 0.00
Purchase 07/16/2018 31846V203 1,141.58 First American Govt Obligation Fund 1.000 1.50 %1,141.58 0.00 1,141.58 0.00
Purchase 07/16/2018 31846V203 52,864.11 First American Govt Obligation Fund 1.000 1.50 %52,864.11 0.00 52,864.11 0.00
Purchase 07/16/2018 31846V203 45,021.10 First American Govt Obligation Fund 1.000 1.50 %45,021.10 0.00 45,021.10 0.00
Purchase 07/16/2018 31846V203 35,455.32 First American Govt Obligation Fund 1.000 1.50 %35,455.32 0.00 35,455.32 0.00
Purchase 07/16/2018 31846V203 3,456.25 First American Govt Obligation Fund 1.000 1.50 %3,456.25 0.00 3,456.25 0.00
Purchase 07/17/2018 3137EAEN5 2,000,000.00 FHLMC Note
2.75% Due 6/19/2023
99.418 2.88 %1,988,360.00 5,500.00 1,993,860.00 0.00
Purchase 07/18/2018 31846V203 1,246,155.31 First American Govt Obligation Fund 1.000 1.50 %1,246,155.31 0.00 1,246,155.31 0.00
Purchase 07/18/2018 31846V203 39,867.97 First American Govt Obligation Fund 1.000 1.50 %39,867.97 0.00 39,867.97 0.00
Purchase 07/18/2018 31846V203 1,530.08 First American Govt Obligation Fund 1.000 1.50 %1,530.08 0.00 1,530.08 0.00
Purchase 07/19/2018 31846V203 29,027.78 First American Govt Obligation Fund 1.000 1.50 %29,027.78 0.00 29,027.78 0.00
Purchase 07/20/2018 31846V203 1,495,492.50 First American Govt Obligation Fund 1.000 1.50 %1,495,492.50 0.00 1,495,492.50 0.00
Purchase 07/21/2018 31846V203 16,250.00 First American Govt Obligation Fund 1.000 1.50 %16,250.00 0.00 16,250.00 0.00
Purchase 07/23/2018 31846V203 20,250.00 First American Govt Obligation Fund 1.000 1.50 %20,250.00 0.00 20,250.00 0.00
Purchase 07/23/2018 31846V203 62,774.76 First American Govt Obligation Fund 1.000 1.50 %62,774.76 0.00 62,774.76 0.00
Purchase 07/24/2018 31846V203 26,250.00 First American Govt Obligation Fund 1.000 1.50 %26,250.00 0.00 26,250.00 0.00
Purchase 07/25/2018 47788EAC2 1,585,000.00 John Deere Owner Trust 2018-B A3
3.08% Due 11/15/2022
99.992 3.10 %1,584,879.86 0.00 1,584,879.86 0.00
Purchase 07/25/2018 65479GAD1 1,220,000.00 Nissan Auto Receivables Owner 2018-B A3
3.06% Due 3/15/2023
99.997 3.08 %1,219,960.47 0.00 1,219,960.47 0.00
Execution Time: 8/30/2018 6:38:42 AMChandler Asset Management - CONFIDENTIAL Page 8
Attachment 2
Transaction Ledger
6/30/18 Thru 7/31/18
City of Dublin Consolidated
Account #10221
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price
Acq/Disp
Yield Amount
Interest
Pur/Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 07/26/2018 31846V203 20,000.00 First American Govt Obligation Fund 1.000 1.50 %20,000.00 0.00 20,000.00 0.00
Purchase 07/31/2018 31846V203 76,562.50 First American Govt Obligation Fund 1.000 1.50 %76,562.50 0.00 76,562.50 0.00
Purchase 07/31/2018 90CAMP$00 103,196.26 California Asset Mgmt Program CAMP 1.000 2.09 %103,196.26 0.00 103,196.26 0.00
Subtotal 8,779,509.71 8,767,191.04 5,500.00 8,772,691.04 0.00
Security
Contribution
07/09/2018 90CAMP$00 3,000,000.00 California Asset Mgmt Program CAMP 1.000 3,000,000.00 0.00 3,000,000.00 0.00
Security
Contribution
07/27/2018 90CAMP$00 1,900,000.00 California Asset Mgmt Program CAMP 1.000 1,900,000.00 0.00 1,900,000.00 0.00
Subtotal 4,900,000.00 4,900,000.00 0.00 4,900,000.00 0.00
Short Sale 07/25/2018 31846V203 -1,584,879.86 First American Govt Obligation Fund 1.000 -1,584,879.86 0.00 -1,584,879.86 0.00
Subtotal -1,584,879.86 -1,584,879.86 0.00 -1,584,879.86 0.00
TOTAL ACQUISITIONS 12,094,629.85 12,082,311.18 5,500.00 12,087,811.18 0.00
DISPOSITIONS
Closing
Purchase
07/25/2018 31846V203 -1,584,879.86 First American Govt Obligation Fund 1.000 -1,584,879.86 0.00 -1,584,879.86 0.00
Subtotal -1,584,879.86 -1,584,879.86 0.00 -1,584,879.86 0.00
Sale 07/16/2018 31846V203 299,481.00 First American Govt Obligation Fund 1.000 1.50 %299,481.00 0.00 299,481.00 0.00
Sale 07/17/2018 31846V203 1,993,860.00 First American Govt Obligation Fund 1.000 1.50 %1,993,860.00 0.00 1,993,860.00 0.00
Sale 07/18/2018 912828D80 1,250,000.00 US Treasury Note
1.625% Due 8/31/2019
99.074 2.47 %1,238,427.73 7,727.58 1,246,155.31 -9,485.26
Sale 07/20/2018 3135G0G72 1,500,000.00 FNMA Note
1.125% Due 12/14/2018
99.587 2.16 %1,493,805.00 1,687.50 1,495,492.50 -4,735.12
Sale 07/25/2018 31846V203 1,219,960.47 First American Govt Obligation Fund 1.000 1.50 %1,219,960.47 0.00 1,219,960.47 0.00
Sale 07/25/2018 31846V203 1,584,879.86 First American Govt Obligation Fund 1.000 1.50 %1,584,879.86 0.00 1,584,879.86 0.00
Subtotal 7,848,181.33 7,830,414.06 9,415.08 7,839,829.14 -14,220.38
Paydown 07/16/2018 02582JHE3 0.00 American Express Credit 2017-3 A
1.77% Due 11/15/2022
100.000 0.00 1,475.00 1,475.00 0.00
Paydown 07/16/2018 43814QAC2 48,150.79 Honda Auto Receivables 2016-2 A3
1.39% Due 4/15/2020
100.000 48,150.79 528.17 48,678.96 0.00
Execution Time: 8/30/2018 6:38:42 AMChandler Asset Management - CONFIDENTIAL Page 9
Attachment 2
Transaction Ledger
6/30/18 Thru 7/31/18
City of Dublin Consolidated
Account #10221
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price
Acq/Disp
Yield Amount
Interest
Pur/Sold Total Amount Gain/Loss
DISPOSITIONS
Paydown 07/16/2018 47787XAB3 47,909.88 John Deere Owner Trust 2017-A A2
1.5% Due 10/15/2019
100.000 47,909.88 311.31 48,221.19 0.00
Paydown 07/16/2018 47788BAB0 23,761.62 John Deere Owner Trust 2017-B A2A
1.59% Due 4/15/2020
100.000 23,761.62 378.78 24,140.40 0.00
Paydown 07/16/2018 47788BAD6 0.00 John Deere Owner Trust 2017-B A3
1.82% Due 10/15/2021
100.000 0.00 485.33 485.33 0.00
Paydown 07/16/2018 47788CAC6 0.00 John Deere Owner Trust 2016-B A4
2.66% Due 4/18/2022
100.000 0.00 1,141.58 1,141.58 0.00
Paydown 07/16/2018 47788MAC4 52,240.62 John Deere Owner Trust 2016-A A3
1.36% Due 4/15/2020
100.000 52,240.62 623.49 52,864.11 0.00
Paydown 07/16/2018 654747AB0 44,663.43 Nissan Auto Receivables 2017-A A2A
1.47% Due 1/15/2020
100.000 44,663.43 357.67 45,021.10 0.00
Paydown 07/16/2018 89231LAB3 35,424.03 Toyota Auto Receivables Owner 2016-D
1.06% Due 5/15/2019
100.000 35,424.03 31.29 35,455.32 0.00
Paydown 07/16/2018 89238BAB8 0.00 Toyota Auto Receivables Owner 2018-A
A2A
2.1% Due 10/15/2020
100.000 0.00 3,456.25 3,456.25 0.00
Paydown 07/18/2018 43814PAB6 39,401.53 Honda Auto Receivables Owner T 17-3 A2
1.57% Due 1/21/2020
100.000 39,401.53 466.44 39,867.97 0.00
Paydown 07/18/2018 43814UAG4 0.00 Honda Auto Receivables 2018-2 A3
3.01% Due 5/18/2022
100.000 0.00 1,530.08 1,530.08 0.00
Paydown 07/23/2018 43814TAB8 62,563.51 Honda Auto Receivables 2017-1 A2
1.42% Due 7/22/2019
100.000 62,563.51 211.25 62,774.76 0.00
Subtotal 354,115.41 354,115.41 10,996.64 365,112.05 0.00
Security
Withdrawal
07/16/2018 90CAMP$00 500,000.00 California Asset Mgmt Program CAMP 1.000 500,000.00 0.00 500,000.00 0.00
Security
Withdrawal
07/23/2018 90CAMP$00 800,000.00 California Asset Mgmt Program CAMP 1.000 800,000.00 0.00 800,000.00 0.00
Security
Withdrawal
07/25/2018 31846V203 104.17 First American Govt Obligation Fund 1.000 104.17 0.00 104.17 0.00
Subtotal 1,300,104.17 1,300,104.17 0.00 1,300,104.17 0.00
TOTAL DISPOSITIONS 7,917,521.05 7,899,753.78 20,411.72 7,920,165.50 -14,220.38
OTHER TRANSACTIONS
Interest 07/05/2018 3135G0S38 2,500,000.00 FNMA Note
2% Due 1/5/2022
0.000 25,000.00 0.00 25,000.00 0.00
Execution Time: 8/30/2018 6:38:42 AMChandler Asset Management - CONFIDENTIAL Page 10
Attachment 2
Transaction Ledger
6/30/18 Thru 7/31/18
City of Dublin Consolidated
Account #10221
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price
Acq/Disp
Yield Amount
Interest
Pur/Sold Total Amount Gain/Loss
OTHER TRANSACTIONS
Interest 07/05/2018 404280BF5 1,500,000.00 HSBC Holdings PLC Note
2.65% Due 1/5/2022
0.000 19,875.00 0.00 19,875.00 0.00
Interest 07/08/2018 24422ETF6 750,000.00 John Deere Capital Corp Note
2.55% Due 1/8/2021
0.000 9,562.50 0.00 9,562.50 0.00
Interest 07/14/2018 24422ESY6 1,000,000.00 John Deere Capital Corp Note
2.375% Due 7/14/2020
0.000 11,875.00 0.00 11,875.00 0.00
Interest 07/14/2018 3130A8QS5 2,500,000.00 FHLB Note
1.125% Due 7/14/2021
0.000 14,062.50 0.00 14,062.50 0.00
Interest 07/19/2018 3135G0T94 2,500,000.00 FNMA Note
2.375% Due 1/19/2023
0.000 29,027.78 0.00 29,027.78 0.00
Interest 07/21/2018 3135G0A78 2,000,000.00 FNMA Note
1.625% Due 1/21/2020
0.000 16,250.00 0.00 16,250.00 0.00
Interest 07/23/2018 46625HKA7 1,800,000.00 JP Morgan Chase Callable Note Cont
12/23/2019
2.25% Due 1/23/2020
0.000 20,250.00 0.00 20,250.00 0.00
Interest 07/24/2018 91159HHP8 2,000,000.00 US Bancorp Callable Cont 12/23/2021
2.625% Due 1/24/2022
0.000 26,250.00 0.00 26,250.00 0.00
Interest 07/26/2018 459058FY4 2,000,000.00 Intl. Bank Recon & Development Note
2% Due 1/26/2022
0.000 20,000.00 0.00 20,000.00 0.00
Interest 07/31/2018 912828H52 4,500,000.00 US Treasury Note
1.25% Due 1/31/2020
0.000 28,125.00 0.00 28,125.00 0.00
Interest 07/31/2018 912828N89 2,000,000.00 US Treasury Note
1.375% Due 1/31/2021
0.000 13,750.00 0.00 13,750.00 0.00
Interest 07/31/2018 912828S76 1,500,000.00 US Treasury Note
1.125% Due 7/31/2021
0.000 8,437.50 0.00 8,437.50 0.00
Interest 07/31/2018 912828V72 1,500,000.00 US Treasury Note
1.875% Due 1/31/2022
0.000 14,062.50 0.00 14,062.50 0.00
Interest 07/31/2018 912828XM7 1,500,000.00 US Treasury Note
1.625% Due 7/31/2020
0.000 12,187.50 0.00 12,187.50 0.00
Subtotal 29,550,000.00 268,715.28 0.00 268,715.28 0.00
Dividend 07/02/2018 31846V203 2,291,367.29 First American Govt Obligation Fund 0.000 3,414.34 0.00 3,414.34 0.00
Dividend 07/15/2018 90LAIF$00 3,688,159,292.1
6
Local Agency Investment Fund State Pool 0.000 192,423.97 0.00 192,423.97 0.00
Execution Time: 8/30/2018 6:38:42 AMChandler Asset Management - CONFIDENTIAL Page 11
Attachment 2
Transaction Ledger
6/30/18 Thru 7/31/18
City of Dublin Consolidated
Account #10221
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price
Acq/Disp
Yield Amount
Interest
Pur/Sold Total Amount Gain/Loss
OTHER TRANSACTIONS
Dividend 07/31/2018 90CAMP$00 59,211,407.46 California Asset Mgmt Program CAMP 0.000 103,196.26 0.00 103,196.26 0.00
Subtotal 3,749,662,066.9
1
299,034.57 0.00 299,034.57 0.00
TOTAL OTHER TRANSACTIONS 3,779,212,066.9
1
567,749.85 0.00 567,749.85 0.00
Execution Time: 8/30/2018 6:38:42 AMChandler Asset Management - CONFIDENTIAL Page 12
Attachment 2
Transaction Ledger
As of August 31, 2018
City of Dublin Consolidated
Account #10221
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 08/01/2018 31846V203 10,500.00 First American Govt Obligation Fund 1.000 1.50%10,500.00 0.00 10,500.00 0.00
Purchase 08/01/2018 31846V203 1,000,000.00 First American Govt Obligation Fund 1.000 1.50%1,000,000.00 0.00 1,000,000.00 0.00
Purchase 08/01/2018 31846V203 2,486.71 First American Govt Obligation Fund 1.000 1.50%2,486.71 0.00 2,486.71 0.00
Purchase 08/06/2018 31846V203 30,000.00 First American Govt Obligation Fund 1.000 1.50%30,000.00 0.00 30,000.00 0.00
Purchase 08/08/2018 31846V203 14,337.50 First American Govt Obligation Fund 1.000 1.50%14,337.50 0.00 14,337.50 0.00
Purchase 08/09/2018 31846V203 2,819,172.61 First American Govt Obligation Fund 1.000 1.50%2,819,172.61 0.00 2,819,172.61 0.00
Purchase 08/12/2018 31846V203 16,875.00 First American Govt Obligation Fund 1.000 1.50%16,875.00 0.00 16,875.00 0.00
Purchase 08/15/2018 31846V203 30,250.00 First American Govt Obligation Fund 1.000 1.50%30,250.00 0.00 30,250.00 0.00
Purchase 08/15/2018 31846V203 1,000,000.00 First American Govt Obligation Fund 1.000 1.50%1,000,000.00 0.00 1,000,000.00 0.00
Purchase 08/15/2018 31846V203 1,475.00 First American Govt Obligation Fund 1.000 1.50%1,475.00 0.00 1,475.00 0.00
Purchase 08/15/2018 31846V203 46,129.29 First American Govt Obligation Fund 1.000 1.50%46,129.29 0.00 46,129.29 0.00
Purchase 08/15/2018 31846V203 61,967.12 First American Govt Obligation Fund 1.000 1.50%61,967.12 0.00 61,967.12 0.00
Purchase 08/15/2018 31846V203 29,518.33 First American Govt Obligation Fund 1.000 1.50%29,518.33 0.00 29,518.33 0.00
Purchase 08/15/2018 31846V203 485.33 First American Govt Obligation Fund 1.000 1.50%485.33 0.00 485.33 0.00
Purchase 08/15/2018 31846V203 1,141.58 First American Govt Obligation Fund 1.000 1.50%1,141.58 0.00 1,141.58 0.00
Purchase 08/15/2018 31846V203 64,365.55 First American Govt Obligation Fund 1.000 1.50%64,365.55 0.00 64,365.55 0.00
Purchase 08/15/2018 31846V203 44,176.74 First American Govt Obligation Fund 1.000 1.50%44,176.74 0.00 44,176.74 0.00
Purchase 08/15/2018 31846V203 2,074.00 First American Govt Obligation Fund 1.000 1.50%2,074.00 0.00 2,074.00 0.00
Purchase 08/15/2018 31846V203 3,456.25 First American Govt Obligation Fund 1.000 1.50%3,456.25 0.00 3,456.25 0.00
Purchase 08/18/2018 31846V203 23,856.25 First American Govt Obligation Fund 1.000 1.50%23,856.25 0.00 23,856.25 0.00
Purchase 08/20/2018 31846V203 38,241.09 First American Govt Obligation Fund 1.000 1.50%38,241.09 0.00 38,241.09 0.00
Purchase 08/20/2018 31846V203 1,530.08 First American Govt Obligation Fund 1.000 1.50%1,530.08 0.00 1,530.08 0.00
Purchase 08/21/2018 31846V203 58,203.46 First American Govt Obligation Fund 1.000 1.50%58,203.46 0.00 58,203.46 0.00
Purchase 08/26/2018 31846V203 34,375.00 First American Govt Obligation Fund 1.000 1.50%34,375.00 0.00 34,375.00 0.00
Purchase 08/28/2018 06406RAJ6 1,200,000.00 Bank of NY Mellon Corp Note
3.45% Due 8/11/2023
100.153 3.42%1,201,836.00 1,725.00 1,203,561.00 0.00
Execution Time: 9/5/2018 1:06:35 PMChandler Asset Management - CONFIDENTIAL Page 10
Attachment 2
Transaction Ledger
As of August 31, 2018
City of Dublin Consolidated
Account #10221
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 08/28/2018 43815HAC1 1,360,000.00 Honda Auto Receivables Owner 2018-3
A3
2.95% Due 8/22/2022
99.986 2.98%1,359,813.41 0.00 1,359,813.41 0.00
Purchase 08/29/2018 313383QR5 1,500,000.00 FHLB Note
3.25% Due 6/9/2023
101.667 2.87%1,525,005.00 10,833.33 1,535,838.33 0.00
Purchase 08/31/2018 31846V203 28,906.25 First American Govt Obligation Fund 1.000 1.53%28,906.25 0.00 28,906.25 0.00
Purchase 08/31/2018 90CAMP$00 96,567.21 California Asset Mgmt Program CAMP 1.000 2.12%96,567.21 0.00 96,567.21 0.00
Subtotal 9,520,090.35 9,546,744.76 12,558.33 9,559,303.09 0.00
Security
Contribution
08/31/2018 90CAMP$00 1,500,000.00 California Asset Mgmt Program CAMP 1.000 1,500,000.00 0.00 1,500,000.00 0.00
Subtotal 1,500,000.00 1,500,000.00 0.00 1,500,000.00 0.00
TOTAL ACQUISITIONS 11,020,090.35 11,046,744.76 12,558.33 11,059,303.09 0.00
DISPOSITIONS
Sale 08/28/2018 31846V203 1,359,813.41 First American Govt Obligation Fund 1.000 1.50%1,359,813.41 0.00 1,359,813.41 0.00
Sale 08/28/2018 31846V203 1,203,561.00 First American Govt Obligation Fund 1.000 1.50%1,203,561.00 0.00 1,203,561.00 0.00
Sale 08/29/2018 31846V203 1,535,838.33 First American Govt Obligation Fund 1.000 1.50%1,535,838.33 0.00 1,535,838.33 0.00
Subtotal 4,099,212.74 4,099,212.74 0.00 4,099,212.74 0.00
Paydown 08/15/2018 02582JHE3 0.00 American Express Credit 2017-3 A
1.77% Due 11/15/2022
100.000 0.00 1,475.00 1,475.00 0.00
Paydown 08/15/2018 43814QAC2 45,656.90 Honda Auto Receivables 2016-2 A3
1.39% Due 4/15/2020
100.000 45,656.90 472.39 46,129.29 0.00
Paydown 08/15/2018 47787XAB3 61,715.70 John Deere Owner Trust 2017-A A2
1.5% Due 10/15/2019
100.000 61,715.70 251.42 61,967.12 0.00
Paydown 08/15/2018 47788BAB0 29,171.03 John Deere Owner Trust 2017-B A2A
1.59% Due 4/15/2020
100.000 29,171.03 347.30 29,518.33 0.00
Paydown 08/15/2018 47788BAD6 0.00 John Deere Owner Trust 2017-B A3
1.82% Due 10/15/2021
100.000 0.00 485.33 485.33 0.00
Paydown 08/15/2018 47788CAC6 0.00 John Deere Owner Trust 2016-B A4
2.66% Due 4/18/2022
100.000 0.00 1,141.58 1,141.58 0.00
Execution Time: 9/5/2018 1:06:35 PMChandler Asset Management - CONFIDENTIAL Page 11
Attachment 2
Transaction Ledger
As of August 31, 2018
City of Dublin Consolidated
Account #10221
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
DISPOSITIONS
Paydown 08/15/2018 47788MAC4 63,801.26 John Deere Owner Trust 2016-A A3
1.36% Due 4/15/2020
100.000 63,801.26 564.29 64,365.55 0.00
Paydown 08/15/2018 654747AB0 43,873.78 Nissan Auto Receivables 2017-A A2A
1.47% Due 1/15/2020
100.000 43,873.78 302.96 44,176.74 0.00
Paydown 08/15/2018 65479GAD1 0.00 Nissan Auto Receivables Owner 2018-B
A3
3.06% Due 3/15/2023
100.000 0.00 2,074.00 2,074.00 0.00
Paydown 08/15/2018 89238BAB8 0.00 Toyota Auto Receivables Owner 2018-A
A2A
2.1% Due 10/15/2020
100.000 0.00 3,456.25 3,456.25 0.00
Paydown 08/20/2018 43814PAB6 37,826.20 Honda Auto Receivables Owner T 17-3
A2
1.57% Due 1/21/2020
100.000 37,826.20 414.89 38,241.09 0.00
Paydown 08/20/2018 43814UAG4 0.00 Honda Auto Receivables 2018-2 A3
3.01% Due 5/18/2022
100.000 0.00 1,530.08 1,530.08 0.00
Paydown 08/21/2018 43814TAB8 58,066.24 Honda Auto Receivables 2017-1 A2
1.42% Due 7/22/2019
100.000 58,066.24 137.22 58,203.46 0.00
Subtotal 340,111.11 340,111.11 12,652.71 352,763.82 0.00
Maturity 08/01/2018 06406HCL1 1,000,000.00 Bank of New York Callable Note Cont
7/2/2018
2.1% Due 8/1/2018
100.000 1,000,000.00 0.00 1,000,000.00 0.00
Maturity 08/09/2018 06417GXH6 2,775,000.00 Bank of Nova Scotia Yankee CD
1.57% Due 8/9/2018
100.000 2,775,000.00 44,172.61 2,819,172.61 0.00
Maturity 08/15/2018 084664BY6 1,000,000.00 Berkshire Hathaway Note
2% Due 8/15/2018
100.000 1,000,000.00 0.00 1,000,000.00 0.00
Subtotal 4,775,000.00 4,775,000.00 44,172.61 4,819,172.61 0.00
Security
Withdrawal
08/03/2018 90CAMP$00 2,300,000.00 California Asset Mgmt Program CAMP 1.000 2,300,000.00 0.00 2,300,000.00 0.00
Security
Withdrawal
08/14/2018 90CAMP$00 2,200,000.00 California Asset Mgmt Program CAMP 1.000 2,200,000.00 0.00 2,200,000.00 0.00
Security
Withdrawal
08/20/2018 90CAMP$00 5,000,000.00 California Asset Mgmt Program CAMP 1.000 5,000,000.00 0.00 5,000,000.00 0.00
Execution Time: 9/5/2018 1:06:35 PMChandler Asset Management - CONFIDENTIAL Page 12
Attachment 2
Transaction Ledger
As of August 31, 2018
City of Dublin Consolidated
Account #10221
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
DISPOSITIONS
Security
Withdrawal
08/24/2018 90CAMP$00 1,800,000.00 California Asset Mgmt Program CAMP 1.000 1,800,000.00 0.00 1,800,000.00 0.00
Security
Withdrawal
08/27/2018 31846V203 104.17 First American Govt Obligation Fund 1.000 104.17 0.00 104.17 0.00
Subtotal 11,300,104.17 11,300,104.17 0.00 11,300,104.17 0.00
TOTAL DISPOSITIONS 20,514,428.02 20,514,428.02 56,825.32 20,571,253.34 0.00
OTHER TRANSACTIONS
Interest 08/01/2018 06406HCL1 1,000,000.00 Bank of New York Callable Note Cont
7/2/2018
2.1% Due 8/1/2018
0.000 10,500.00 0.00 10,500.00 0.00
Interest 08/06/2018 44932HAH6 2,000,000.00 IBM Credit Corp Note
3% Due 2/6/2023
0.000 30,000.00 0.00 30,000.00 0.00
Interest 08/08/2018 594918BP8 1,850,000.00 Microsoft Callable Note Cont 7/8/21
1.55% Due 8/8/2021
0.000 14,337.50 0.00 14,337.50 0.00
Interest 08/12/2018 3137EAEC9 3,000,000.00 FHLMC Note
1.125% Due 8/12/2021
0.000 16,875.00 0.00 16,875.00 0.00
Interest 08/15/2018 02665WAH4 1,800,000.00 American Honda Finance Note
2.25% Due 8/15/2019
0.000 20,250.00 0.00 20,250.00 0.00
Interest 08/15/2018 084664BY6 1,000,000.00 Berkshire Hathaway Note
2% Due 8/15/2018
0.000 10,000.00 0.00 10,000.00 0.00
Interest 08/18/2018 3130A7CV5 3,470,000.00 FHLB Note
1.375% Due 2/18/2021
0.000 23,856.25 0.00 23,856.25 0.00
Interest 08/26/2018 3135G0J20 5,000,000.00 FNMA Note
1.375% Due 2/26/2021
0.000 34,375.00 0.00 34,375.00 0.00
Interest 08/31/2018 912828D80 1,250,000.00 US Treasury Note
1.625% Due 8/31/2019
0.000 10,156.25 0.00 10,156.25 0.00
Interest 08/31/2018 912828L24 2,000,000.00 US Treasury Note
1.875% Due 8/31/2022
0.000 18,750.00 0.00 18,750.00 0.00
Subtotal 22,370,000.00 189,100.00 0.00 189,100.00 0.00
Dividend 08/01/2018 31846V203 1,582,471.27 First American Govt Obligation Fund 0.000 2,486.71 0.00 2,486.71 0.00
Execution Time: 9/5/2018 1:06:35 PMChandler Asset Management - CONFIDENTIAL Page 13
Attachment 2
Transaction Ledger
As of August 31, 2018
City of Dublin Consolidated
Account #10221
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
OTHER TRANSACTIONS
Dividend 08/31/2018 90CAMP$00 48,014,603.72 California Asset Mgmt Program CAMP 0.000 96,567.21 0.00 96,567.21 0.00
Subtotal 49,597,074.99 99,053.92 0.00 99,053.92 0.00
TOTAL OTHER TRANSACTIONS 71,967,074.99 288,153.92 0.00 288,153.92 0.00
Execution Time: 9/5/2018 1:06:35 PMChandler Asset Management - CONFIDENTIAL Page 14
Attachment 2
Transaction Ledger
As of September 30, 2018
City of Dublin Consolidated
Account #10221
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 09/01/2018 31846V203 34,341.75 First American Govt Obligation Fund 1.000 1.53%34,341.75 0.00 34,341.75 0.00
Purchase 09/04/2018 31846V203 5,161.46 First American Govt Obligation Fund 1.000 1.53%5,161.46 0.00 5,161.46 0.00
Purchase 09/08/2018 31846V203 20,625.00 First American Govt Obligation Fund 1.000 1.53%20,625.00 0.00 20,625.00 0.00
Purchase 09/11/2018 31846V203 31,125.00 First American Govt Obligation Fund 1.000 1.53%31,125.00 0.00 31,125.00 0.00
Purchase 09/12/2018 31846V203 21,875.00 First American Govt Obligation Fund 1.000 1.53%21,875.00 0.00 21,875.00 0.00
Purchase 09/14/2018 31846V203 21,875.00 First American Govt Obligation Fund 1.000 1.53%21,875.00 0.00 21,875.00 0.00
Purchase 09/15/2018 31846V203 38,606.25 First American Govt Obligation Fund 1.000 1.53%38,606.25 0.00 38,606.25 0.00
Purchase 09/17/2018 31846V203 1,475.00 First American Govt Obligation Fund 1.000 1.53%1,475.00 0.00 1,475.00 0.00
Purchase 09/17/2018 31846V203 44,779.70 First American Govt Obligation Fund 1.000 1.53%44,779.70 0.00 44,779.70 0.00
Purchase 09/17/2018 31846V203 50,001.79 First American Govt Obligation Fund 1.000 1.53%50,001.79 0.00 50,001.79 0.00
Purchase 09/17/2018 31846V203 25,699.33 First American Govt Obligation Fund 1.000 1.53%25,699.33 0.00 25,699.33 0.00
Purchase 09/17/2018 31846V203 485.33 First American Govt Obligation Fund 1.000 1.53%485.33 0.00 485.33 0.00
Purchase 09/17/2018 31846V203 1,141.58 First American Govt Obligation Fund 1.000 1.53%1,141.58 0.00 1,141.58 0.00
Purchase 09/17/2018 31846V203 6,780.28 First American Govt Obligation Fund 1.000 1.53%6,780.28 0.00 6,780.28 0.00
Purchase 09/17/2018 31846V203 61,955.14 First American Govt Obligation Fund 1.000 1.53%61,955.14 0.00 61,955.14 0.00
Purchase 09/17/2018 31846V203 46,481.29 First American Govt Obligation Fund 1.000 1.53%46,481.29 0.00 46,481.29 0.00
Purchase 09/17/2018 31846V203 3,111.00 First American Govt Obligation Fund 1.000 1.53%3,111.00 0.00 3,111.00 0.00
Purchase 09/17/2018 31846V203 3,456.25 First American Govt Obligation Fund 1.000 1.53%3,456.25 0.00 3,456.25 0.00
Purchase 09/18/2018 31846V203 38,968.66 First American Govt Obligation Fund 1.000 1.53%38,968.66 0.00 38,968.66 0.00
Purchase 09/18/2018 31846V203 1,530.08 First American Govt Obligation Fund 1.000 1.53%1,530.08 0.00 1,530.08 0.00
Purchase 09/21/2018 31846V203 57,963.30 First American Govt Obligation Fund 1.000 1.53%57,963.30 0.00 57,963.30 0.00
Purchase 09/21/2018 31846V203 2,563.22 First American Govt Obligation Fund 1.000 1.53%2,563.22 0.00 2,563.22 0.00
Purchase 09/30/2018 31846V203 121,406.25 First American Govt Obligation Fund 1.000 1.67%121,406.25 0.00 121,406.25 0.00
Purchase 09/30/2018 90CAMP$00 88,014.04 California Asset Mgmt Program CAMP 1.000 2.12%88,014.04 0.00 88,014.04 0.00
Subtotal 729,421.70 729,421.70 0.00 729,421.70 0.00
Execution Time: 10/12/2018 11:10:25 AMChandler Asset Management - CONFIDENTIAL Page 10
Attachment 2
Transaction Ledger
As of September 30, 2018
City of Dublin Consolidated
Account #10221
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
ACQUISITIONS
Security
Contribution
09/24/2018 90CAMP$00 4,000,000.00 California Asset Mgmt Program CAMP 1.000 4,000,000.00 0.00 4,000,000.00 0.00
Subtotal 4,000,000.00 4,000,000.00 0.00 4,000,000.00 0.00
TOTAL ACQUISITIONS 4,729,421.70 4,729,421.70 0.00 4,729,421.70 0.00
DISPOSITIONS
Paydown 09/17/2018 02582JHE3 0.00 American Express Credit 2017-3 A
1.77% Due 11/15/2022
100.000 0.00 1,475.00 1,475.00 0.00
Paydown 09/17/2018 43814QAC2 44,360.20 Honda Auto Receivables 2016-2 A3
1.39% Due 4/15/2020
100.000 44,360.20 419.50 44,779.70 0.00
Paydown 09/17/2018 47787XAB3 49,827.51 John Deere Owner Trust 2017-A A2
1.5% Due 10/15/2019
100.000 49,827.51 174.28 50,001.79 0.00
Paydown 09/17/2018 47788BAB0 25,390.69 John Deere Owner Trust 2017-B A2A
1.59% Due 4/15/2020
100.000 25,390.69 308.64 25,699.33 0.00
Paydown 09/17/2018 47788BAD6 0.00 John Deere Owner Trust 2017-B A3
1.82% Due 10/15/2021
100.000 0.00 485.33 485.33 0.00
Paydown 09/17/2018 47788CAC6 0.00 John Deere Owner Trust 2016-B A4
2.66% Due 4/18/2022
100.000 0.00 1,141.58 1,141.58 0.00
Paydown 09/17/2018 47788EAC2 0.00 John Deere Owner Trust 2018-B A3
3.08% Due 11/15/2022
100.000 0.00 6,780.28 6,780.28 0.00
Paydown 09/17/2018 47788MAC4 61,463.16 John Deere Owner Trust 2016-A A3
1.36% Due 4/15/2020
100.000 61,463.16 491.98 61,955.14 0.00
Paydown 09/17/2018 654747AB0 46,232.08 Nissan Auto Receivables 2017-A A2A
1.47% Due 1/15/2020
100.000 46,232.08 249.21 46,481.29 0.00
Paydown 09/17/2018 65479GAD1 0.00 Nissan Auto Receivables Owner 2018-B
A3
3.06% Due 3/15/2023
100.000 0.00 3,111.00 3,111.00 0.00
Execution Time: 10/12/2018 11:10:25 AMChandler Asset Management - CONFIDENTIAL Page 11
Attachment 2
Transaction Ledger
As of September 30, 2018
City of Dublin Consolidated
Account #10221
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
DISPOSITIONS
Paydown 09/17/2018 89238BAB8 0.00 Toyota Auto Receivables Owner 2018-A
A2A
2.1% Due 10/15/2020
100.000 0.00 3,456.25 3,456.25 0.00
Paydown 09/18/2018 43814PAB6 38,603.26 Honda Auto Receivables Owner T 17-3
A2
1.57% Due 1/21/2020
100.000 38,603.26 365.40 38,968.66 0.00
Paydown 09/18/2018 43814UAG4 0.00 Honda Auto Receivables 2018-2 A3
3.01% Due 5/18/2022
100.000 0.00 1,530.08 1,530.08 0.00
Paydown 09/21/2018 43814TAB8 57,894.79 Honda Auto Receivables 2017-1 A2
1.42% Due 7/22/2019
100.000 57,894.79 68.51 57,963.30 0.00
Paydown 09/21/2018 43815HAC1 0.00 Honda Auto Receivables Owner 2018-3
A3
2.95% Due 8/22/2022
100.000 0.00 2,563.22 2,563.22 0.00
Subtotal 323,771.69 323,771.69 22,620.26 346,391.95 0.00
Security
Withdrawal
09/10/2018 90CAMP$00 800,000.00 California Asset Mgmt Program CAMP 1.000 800,000.00 0.00 800,000.00 0.00
Security
Withdrawal
09/25/2018 31846V203 104.17 First American Govt Obligation Fund 1.000 104.17 0.00 104.17 0.00
Subtotal 800,104.17 800,104.17 0.00 800,104.17 0.00
TOTAL DISPOSITIONS 1,123,875.86 1,123,875.86 22,620.26 1,146,496.12 0.00
OTHER TRANSACTIONS
Interest 09/01/2018 17275RAR3 1,350,000.00 Cisco Systems Note
2.125% Due 3/1/2019
0.000 14,343.75 0.00 14,343.75 0.00
Interest 09/01/2018 30231GAV4 1,800,000.00 Exxon Mobil Corp Callable Note Cont
2/1/2021
2.222% Due 3/1/2021
0.000 19,998.00 0.00 19,998.00 0.00
Interest 09/08/2018 3133782M2 2,750,000.00 FHLB Note
1.5% Due 3/8/2019
0.000 20,625.00 0.00 20,625.00 0.00
Interest 09/11/2018 06406HCW7 750,000.00 Bank of New York Callable Note Cont
8/11/2019
2.3% Due 9/11/2019
0.000 8,625.00 0.00 8,625.00 0.00
Execution Time: 10/12/2018 11:10:25 AMChandler Asset Management - CONFIDENTIAL Page 12
Attachment 2
Transaction Ledger
As of September 30, 2018
City of Dublin Consolidated
Account #10221
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
OTHER TRANSACTIONS
Interest 09/11/2018 313378CR0 2,000,000.00 FHLB Note
2.25% Due 3/11/2022
0.000 22,500.00 0.00 22,500.00 0.00
Interest 09/12/2018 3135G0ZG1 2,500,000.00 FNMA Note
1.75% Due 9/12/2019
0.000 21,875.00 0.00 21,875.00 0.00
Interest 09/14/2018 4581X0CZ9 2,500,000.00 Inter-American Dev Bank Note
1.75% Due 9/14/2022
0.000 21,875.00 0.00 21,875.00 0.00
Interest 09/15/2018 084670BR8 1,000,000.00 Berkshire Hathaway Callable Note Cont
1/15/2023
2.75% Due 3/15/2023
0.000 13,750.00 0.00 13,750.00 0.00
Interest 09/15/2018 532457BF4 1,575,000.00 Eli Lilly & Co Note
1.95% Due 3/15/2019
0.000 15,356.25 0.00 15,356.25 0.00
Interest 09/15/2018 68389XBK0 1,000,000.00 Oracle Corp Callable Note Cont 8/01/21
1.9% Due 9/15/2021
0.000 9,500.00 0.00 9,500.00 0.00
Interest 09/30/2018 9128284D9 3,750,000.00 US Treasury Note
2.5% Due 3/31/2023
0.000 46,875.00 0.00 46,875.00 0.00
Interest 09/30/2018 912828J76 3,000,000.00 US Treasury Note
1.75% Due 3/31/2022
0.000 26,250.00 0.00 26,250.00 0.00
Interest 09/30/2018 912828L57 3,750,000.00 US Treasury Note
1.75% Due 9/30/2022
0.000 32,812.50 0.00 32,812.50 0.00
Interest 09/30/2018 912828T34 2,750,000.00 US Treasury Note
1.125% Due 9/30/2021
0.000 15,468.75 0.00 15,468.75 0.00
Subtotal 30,475,000.00 289,854.25 0.00 289,854.25 0.00
Dividend 09/04/2018 31846V203 1,870,519.25 First American Govt Obligation Fund 0.000 5,161.46 0.00 5,161.46 0.00
Dividend 09/30/2018 90CAMP$00 52,811,170.93 California Asset Mgmt Program CAMP 0.000 88,014.04 0.00 88,014.04 0.00
Subtotal 54,681,690.18 93,175.50 0.00 93,175.50 0.00
TOTAL OTHER TRANSACTIONS 85,156,690.18 383,029.75 0.00 383,029.75 0.00
Execution Time: 10/12/2018 11:10:25 AMChandler Asset Management - CONFIDENTIAL Page 13
Attachment 2