HomeMy WebLinkAbout4.11 - 1553 Q4 Investment Report
Page 1 of 5
STAFF REPORT
CITY COUNCIL
DATE: September 5, 2017
TO: Honorable Mayor and City Councilmembers
FROM:
Christopher L. Foss, City Manager
SUBJECT:
City Treasurer's Informational Report of Investments for the Quarter
Ending June 30, 2017
Prepared by: Jay Baksa, Financial Analyst
EXECUTIVE SUMMARY:
The City of Dublin's Investment Policy calls for a semi-annual report of investments.
This report is for the quarter ending June 30, 2017, and includes a monthly
transaction ledger. The City’s investment portfolio for this period totaled
$230,654,931 (book value) with an average market yield of 1.44%. All investment
transactions continue to comply with the City's Investment Policy and the California
Government Code. 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:
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.
On February 21, 2017, the City Council approved as part of the Mid-Year Budget
Review, a budget adjustment of $375,000, to account for additional projec ted interest
revenue due to the increasing interest rates. No further budget change is needed at this
time.
DESCRIPTION:
The total investment portfolio of $230,654,931 (book value) is comprised of
$157,642,719 managed by Chandler Asset Management (Chandler), and $73,012,212
invested by the City in local government pools. The average market yield of the
Page 2 of 5
Chandler portfolio and the local pools was 1.62% and 1.05% respectively. The total
investment portfolio balance fluctuates throughout the year due to norm al cash flow
needs and includes both discretionary and restricted funds.
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) raised the fed funds target by 25 basis
points to a range of 1.00% - 1.25% at the June 13-14, 2017 meeting. The FOMC still
expects the fed funds rate to reach 1.4% by the end of the year (which implies one
more rate hike before year end) and 3.0% over the longer term.
Domestic economic data remains indicative of slow growth. The economy is likely at or
near full employment, consumer confidence is strong, manufacturing indicators are
reflecting modest expansion, and housing trends remain favorable. GDP grew by 1.4%
in the first quarter, following growth of 2.1% in the fourth quarter. Overall Chandler
expects modest economic growth of about 2.0% - 2.5% for the full year 2017.
Treasury yields increased modestly in June. The 2 -year and 10-year Treasury yields
both increased by ten basis points month -over-month, while the 5-year Treasury yield
increased 14 basis points. On a year-over-year basis, Treasury yields have increased
meaningfully, with the 2-year Treasury yield up 80 basis points and the 10-year
Treasury yield up 83 basis points. The Federal Reserve has raised the fed funds target
rate by 25 basis points three times in the past year.
City of Dublin Portfolio
The City's portfolio managed by Chandler has maintained a healthy ba lance of
investment types. In the Quarter ending June 30, 2017, Chandler focused on
purchasing securities across the Treasury, Agency and Corporate sectors with
maturities ranging from May 2020 to May 2022, to keep the City’s portfolio in line with
Chandler's targets. As illustrated in Chart 1 below, the City’s holdings shifted slightly
due to the focused purchasing of those securities. In addition, the City shifted $10
million from funds held in the Local Government Investment Pools to Chandler based
on cash flow needs and the historically higher rate of return achieved on funds invested
with Chandler.
Page 3 of 5
Chart 1: Investments by Type, March 31, 2017 - June 30, 2017
The market value of the City's portfolio decreased $4.98 million since March 31, 2017
(see Table 1 below), but increased $27.8 million from the same quarter the prior year.
The year-over-year increase is due to an increase in Impact Fees received from various
development projects; the quarter-over-quarter decrease is due to large payments for
two of the City’s Capital Improvement Projects (Fallon Sports Park Phase II and The
Wave).
Page 4 of 5
Table 1: Portfolio Values and Yield to Maturity
Overall market yield-to-maturity (YTM) increased from 1.31%% to 1.44% (See 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 Investment 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 resulting from the timing
of large payments deposited into CAMP as a temporary holding place.
Page 5 of 5
Table 3: Quarterly LAIF Yields, Recent Seven Years and One Quarter
NOTICING REQUIREMENTS/PUBLIC OUTREACH:
N/A
ATTACHMENTS:
1. City of Dublin Investment Report for Period Ending June 2017
2. Transaction Ledger - April - June 2017
6225 Lusk Blvd | San Diego, CA 92121 | Phone 800.317.4747 | Fax 858.546.3741 | www.chandlerasset.com
CHANDLER ASSET MANAGEMENT
Period Ending
June 30, 2017
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
Domesticeconomicdataremainsindicative of slowgrowth.Theeconomy is likely atornear fullemployment,
consumerconfidence is strong,manufacturingindicatorsareindicative of modestexpansion,and housingtrends
remainfavorable.Looking ahead,apotentialboost in fiscalstimuluscouldprovideafurthertailwind to economic
growth.GDPgrew by 1.4%in thefirstquarter,followinggrowth of 2.1%in thefourthquarter.We expectmodest
economic growth of about 2.0%-2.5% for the full year 2017.
Economic Update
TheFederalOpenMarketCommittee(FOMC)raisedthefedfundstargetrate by25 basispoints to arange of 1.00%-
1.25% atthe June13-14meeting. However,the FOMCstatement indicatedthatthe stance ofmonetarypolicy remains
accommodative.TheFOMCalsonotedthateconomicactivity hasbeen risingmoderately and jobgainshave been
solid,but inflation has recentlydeclined.Nevertheless,theFOMCexpectsinflation to stabilizearound2.0%overthe
mediumterm.TheCommitteeexpects to begintrimmingthe Fed’s balancesheetlaterthisyear.The Fed’s updated
Summary of EconomicProjectionsreflectsdownwardrevisions to the Fed’s medianunemploymentrateprojections
forthisyear and futureyears,as well as adownwardrevision to the Fed’s median 2017 inflationforecast.Theupdated
projectionssuggestthattheFedanticipatesthelabormarket to tightenfurtheroverthecomingyearswithoutmuch
impact on inflation.TheFedstillexpectsthefedfundsrate to reach1.4%by the endof thisyear(whichimplies one
morerate hikebefore year-end) and3.0%over the longer-run.
Treasuryyieldsincreasedmodestly in June,led by the5-yearnote.The2-year and 10-yearTreasuryyieldsboth
increased by tenbasispointsmonth-over-month,whilethe5-yearTreasuryyieldincreased 14 basispoints.Themove
higher in domesticyieldsoccurredlate in themonth,coincidingwithhawkishcommentsfromECBPresidentDraghi.
Hiscommentsalsoprovidedacatalystforsovereignyields in Germany and Japan to movehigher.On ayear-over-
yearbasis,Treasuryyieldshaveincreasedmeaningfully,withthe2-yearTreasuryyield up80 basispoints and the 10-
yearTreasuryyield up83 basispoints.TheFederalReserve has raisedthefedfundstargetrate by25 basispoints
threetimesinthe past year.
3
Attachment 1
Jobgrowthwasstrongerthanexpected in June but wagesremainedlackluster.Nonfarmpayrollsincreased by 222,000versusthe
consensusforecast of 178,000.In addition,April and Maypayrollswererevised upby 47,000 in total.Theaverageincrease in monthly
payrollswas194,000duringthesecondquarter,up from166,000 per monthduringthefirstquarter.Theunemploymentrateticked up
to 4.4%in Junefrom4.3%in May,but thelaborparticipationratealso edgedup to 62.8%from62.7%.Abroadermeasure of
unemploymentcalledtheU-6,whichincludesthosewhoaremarginallyattached to thelaborforce and employedparttimefor
economicreasons,increased to 8.6%in Junefrom8.4%in May,howeverthiscompares to 9.6%in June 2016.Wagegrowthrosejust
0.2%in June,followingadownwardlyrevisedgain of 0.1%in May.On ayear-over-yearbasis,wageswere up 2.5%in June,versus
2.4% in May.
Employment
Source: US Department of Labor Source: US Department of Labor
0
50
100
150
200
250
300
350
M
O
M
C
h
a
n
g
e
I
n
(
0
0
0
'
s
)
Nonfarm Payroll (000's)
4.0%
5.0%
6.0%
7.0%
8.0%
9.0%
10.0%
11.0%
12.0%
13.0%
Unemployment Rate
Underemployment Rate (U6)
Unemployment Rate (U3)
Ra
t
e
(
%
)
4
Attachment 1
TheConsumerPriceIndex(CPI)was up 1.9%year-over-year in May,versus up 2.2%year-over-year in April.CoreCPI(CPIlessfood
and energy)was up just1.7%year-over-year in May,versus up 1.9%year-over-year in April.ThePersonalConsumptionExpenditures
(PCE)indexwas up 1.4%year-over-year in May,versus up 1.7%year-over-year in April.CorePCE(excludingfood and energy)was
also up just1.4%year-over-year in May,versus up 1.5%year-over-year in April.CoreCPI is has fallenbackbelowtheFed's2.0%
target, and the Fed's primary inflation gauge (PCE) also remains below the target.
Inflation
Source: US Department of Labor Source: US Department of Labor
-0.5%
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 % Change
YO
Y
(
%
)
C
h
a
n
g
e
-0.5%
0.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 % Change
YO
Y
(
%
)
C
h
a
n
g
e
5
Attachment 1
On ayear-over-yearbasis,totalretailsaleswere up 3.8%in Maycomparedwitha4.6%increase in April.On amonth-over-month
basis,retailsalesdeclined0.3%in May,belowexpectationsfora0.1%increase,followinga0.4%increase in April.Excludingautos and
gas,retailsaleswereflat in May,followinga0.5%gain in April.Overall,consumerspendingtrendsremainsoft.However,theconsumer
confidence index remained strong in June at 118.9 versus 117.6 in May.
Consumer
Source: US Department of Commerce Source: Federal Reserve
0.0%
1.0%
2.0%
3.0%
4.0%
5.0%
6.0%
Retail Sales YOY % Change
YO
Y
(
%
)
C
h
a
n
g
e
85
90
95
100
105
110
115
120
125
130
In
d
e
x
L
e
v
e
l
Consumer Confidence
6
Attachment 1
The Index of Leading Economic Indicators (LEI) rose 0.3% in May, in line with expectations, following a 0.2% increase in April. According
to theConferenceBoard,theLEIsuggestseconomicgrowthwillremain on,or possiblymoderatelyabove,itslong-termtrend ofabout
2%growththroughyear-end.However,theChicagoFedNationalActivityIndex(CFNAI)declined to 0.04 in May on a3-monthmoving
average basis from 0.21 in April. The index declined meaningfully in May, which weighed on the three month moving average.
Economic Activity
-0.4%
-0.3%
-0.2%
-0.1%
0.0%
0.1%
0.2%
0.3%
0.4%
0.5%
0.6%
0.7%
Leading Economic Indicators (LEI)
M
O
M
(
%
)
C
h
a
n
g
e
-0.60
-0.40
-0.20
0.00
0.20
0.40
0.60
Chicago Fed National Activity Index
(CFNAI)
3
M
o
n
t
h
A
v
e
r
a
g
e
Source: The Conference Board Source: Federal Reserve Bank of Chicago
7
Attachment 1
Totalhousingstartsfell5.5%in May,followinga2.8%decrease in April,missingexpectations.Single-familystartsdeclined3.9%in
May,and multi-familystartsfell9.7%.Permitswerealsoweakerthanexpected in May,down4.9%.According to theCase-Shiller 20-
City home price index, home prices were up 5.7% year-over-year in April, versus up 5.9% year-over-year in March.
Housing
Source: US Census Bureau Source: S&P
0
200
400
600
800
1000
1200
1400
1600
M
O
M
C
h
a
n
g
e
(
I
n
T
h
o
u
s
a
n
d
s
o
f
U
n
i
t
s
)
Housing Starts
Multi Family Housing Starts
Single Family Housing Starts
3.5%
4.0%
4.5%
5.0%
5.5%
6.0%
6.5%
S&P/CaseShiller 20 City Composite Home
Price Index
YO
Y
(
%
)
C
h
a
n
g
e
8
Attachment 1
TheInstituteforSupplyManagement(ISM)manufacturingindexincreased to 57.8 in Junefrom54.9 in May,suggestingthat
manufacturingactivity is accelerating.Thereportwasstrongerthanexpected.Notably,areadingabove50.0suggeststhe
manufacturingsector is expanding.However,capacityutilization,which is productiondivided by capacity,decreased to 76.6%in May
from76.7%in April.Thecapacityutilizationrateremainsbelowthelong-runaverage of 79.9%(1972-2016),suggestingthere is still
excess capacity in the industrial sector.
Manufacturing
Source: Institute for Supply Management Source: Federal Reserve
46
48
50
52
54
56
58
60
Institute of Supply Management Purchasing
Manager Index
Expanding
Contracting
74.0%
75.0%
76.0%
77.0%
78.0%
79.0%
80.0%
Capacity Utilization
Ra
t
e
(
%
)
9
Attachment 1
FirstquarterGDPgrowthwasrevised up to 1.4%fromthesecondestimate of 1.2%and theadvanceestimate of 0.7%.Themost
recentupwardrevisionwasdriven byan increase in consumerspending andnet exports.Economicgrowth is believed to have
improved in thesecondquarter to apace ofabout 3.0%.TheconsensusforecastcurrentlycallsforGDPgrowth ofabout 2.4%in the
third quarter.
Gross Domestic Product (GDP)
Source: US Department of Commerce Source: US Department of Commerce
6/169/1612/163/17
2.9%2.0%2.4%0.8%
-1.3%0.5%1.5%0.6%
0.2%0.9%-1.8%0.2%
0.0%0.2%-0.1%-0.1%
-0.3%0.0%0.1%0.0%
1.4%3.5%2.1%1.4%
Federal Government Expenditures
Total
Net Exports and Imports
Personal Consumption Expenditures
Gross Private Domestic Investment
State and Local (Consumption and Gross
Investment)
Components of GDP
-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
Overthepastthreemonthstheyieldcurveflattened.Thespreadbetween2-year and 10-yearTreasuryyieldsnarrowed to 92 basis
points asof June 30,compared to 114 basispoints on March 31.In thethreemonthsending in June,the2-yearTreasuryyield
increasednearly 13 basispointswhilethe10-yearTreasuryyielddecreasedeightbasispoints.Immediatelyfollowingthe US
Presidentialelectionlastfall,theTreasuryyieldcurvesteepenedmeaningfully,driven by heightenedexpectationsforfiscalstimulus and
economicgrowth under theTrumpadministration.However,as thepost-electionexuberancestarted to waneearlierthisyear,theyield
curveflattened.Sincetheelection,the2-yearTreasuryyield is upabout60 basispoints and the10-yearTreasuryyield is upabout50
basis points.
Bond Yields
Source: Bloomberg
0.0%
0.5%
1.0%
1.5%
2.0%
2.5%
3.0%
3.5%
US Treasury Note Yields
2-Year
5-Year
10-Year
Yi
e
l
d
(
%
)
0.0%
0.5%
1.0%
1.5%
2.0%
2.5%
3.0%
3.5%
US Treasury Yield Curve
Jun-17
Mar-17
Jun-16
Yi
e
l
d
(
%
)
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
Bank of America Merrill Lynch 1-5 Year Treasury and Agency 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
Municipal Issues "A" rated or higher by a NRSRO; 5% max per issuer Complies
Medium Term Notes "A" rated or higher by a NRSRO; 30% max; 5% max per issuer Complies
Banker’s Acceptances "A-1" rated or higher by a NRSRO; 40% max; 5% max per issuer; 180 days
max maturity
Complies
Commercial Paper "A-1" rated or higher by a NRSRO; 25% max; 5% max per issuer; 270 days
max maturity
Complies
Negotiable Certificates of Deposit "A" or better long term debt rating/"A-1" or higher short term rating by a
NRSRO; 30% max; 5% max per issuer
Complies
Corporate Debt (All)20% max per issuer Complies
Time Deposits 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% max; 5% max per issue
Complies
Money Market Mutual Funds "AAA" rated by two NRSROs or SEC registered adviser; 20% max; 10%
max per fund
Complies
LAIF $50 million limit Complies
CAMP Not used by adviser Complies
Supranationals Not listed as authorized investment in investment policy Complies
Max Per Issuer 5% (except US Government, agencies, money market mutual funds)Complies
Maximum Maturity 5 years Complies
City of Dublin
June 30, 2017
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
6/30/2017 3/31/2017
Benchmark* Portfolio Portfolio
Average Maturity (yrs) 2.70 2.65 2.59
Modified Duration 2.59 2.45 2.37
Average Purchase Yield n/a 1.54% 1.47%
Average Market Yield 1.53% 1.62% 1.57%
Average Quality** AAA AA/Aa1 AA/Aa1
Contributions/Withdrawals 9,999,687
Total Market Value 158,015,885 147,286,090
*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.
Multiple securities were purchased across the Treasury, Agency and Corporate sectors to keep the portfolio maturity
distribution in-line with Chandler targets. The purchased securities ranged in maturity from May 2020 to May 2022.
One security was called and one matured, in addition to a $10 million contribution during the reporting period, to help
facilitate the new holdings in the City’s portfolio.
15
Attachment 1
ABS
6.6%
Agency
37.6%
Commercial
Paper
1.9% Money
Market Fund
FI
0.3%
US
Corporate
22.4%
US Treasury
31.3%
Sector Distribution
City of Dublin
June 30, 2017 March 31, 2017
ABS
8.1%
Agency
36.7%
Commercial
Paper
2.0%
Money
Market Fund
FI
0.8%
US
Corporate
23.8%
US Treasury
28.6%
16
Attachment 1
Issuers
City of Dublin – Account #10198 As of 6/30/2017
Issue Name Investment Type % Portfolio
Government of United States US Treasury 30.34%
Federal National Mortgage Association Agency 15.98%
Federal Home Loan Bank Agency 14.39%
Federal Home Loan Mortgage Corp Agency 7.24%
Bank of Tokyo-Mit UFJ Commercial Paper 1.86%
John Deere ABS ABS 1.79%
Pepsico Inc US Corporate 1.75%
ChevronTexaco Corp US Corporate 1.74%
Honda ABS ABS 1.71%
US Bancorp US Corporate 1.29%
Qualcomm Inc US Corporate 1.28%
Chubb Corporation US Corporate 1.28%
Wells Fargo Corp US Corporate 1.21%
JP Morgan ABS ABS 1.19%
Honda Motor Corporation US Corporate 1.16%
Exxon Mobil Corp US Corporate 1.16%
JP Morgan Chase & Co US Corporate 1.15%
Microsoft US Corporate 1.15%
Deere & Company US Corporate 1.13%
State Street Bank US Corporate 1.13%
Bank of New York US Corporate 1.12%
Apple Inc US Corporate 1.11%
Eli Lilly & Co US Corporate 1.01%
Toyota ABS ABS 0.99%
HSBC USA Corp US Corporate 0.96%
AT&T Corporation US Treasury 0.95%
Nissan ABS ABS 0.87%
Cisco Systems US Corporate 0.87%
Oracle Corp US Corporate 0.80%
Berkshire Hathaway US Corporate 0.64%
17
Attachment 1
Issuers
City of Dublin – Account #10198 As of 6/30/2017
Issue Name Investment Type % Portfolio
General Electric Co US Corporate 0.48%
First American Govt Oblig Fund Money Market Fund FI 0.28%
Total 100.00%
18
Attachment 1
AAA AA A <A NR
06/30/17 4.3% 78.5% 13.5% 0.0% 3.7%
03/31/17 5.8% 75.0% 14.9% 0.0% 4.4%
Source: S&P Ratings
Quality Distribution
June 30, 2017 vs. March 31, 2017
City of Dublin
0.00%
10.00%
20.00%
30.00%
40.00%
50.00%
60.00%
70.00%
80.00%
90.00%
AAA AA A <A NR
6/30/2017 3/31/2017
19
Attachment 1
0.00%
5.00%
10.00%
15.00%
20.00%
25.00%
30.00%
0 - 0.25 0.25 - 0.50 0.50 - 1 1 - 2 2 - 3 3 - 4 4 - 5 5+
6/30/2017 3/31/2017
Duration Distribution
City of Dublin
June 30, 2017 vs. March 31, 2017
0 - 0.25 0.25 - 0.50 0.50 - 1 1 - 2 2 - 3 3 - 4 4 - 5 5+
06/30/17 3.5% 6.9% 13.8% 10.6% 27.5% 21.5% 16.3% 0.0%
03/31/17 3.5% 5.3% 13.8% 17.7% 24.9% 21.4% 13.4% 0.0%
20
Attachment 1
Investment Performance
-0.60%
-0.40%
-0.20%
0.00%
0.20%
0.40%
0.60%
0.80%
1.00%
1.20%
1.40%
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
June 30, 2017
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.48% 0.02% 1.25% 1.15% N/A N/A 1.09%
BAML 1-5 Yr US Treasury/Agency Index 0.38% -0.49% 0.94% 1.01% N/A N/A 0.93%
*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
6/30/2017 3/31/2017
Portfolio Portfolio
Average Maturity (yrs) 0.00 0.00
Modified Duration 0.00 0.00
Average Purchase Yield 1.05% 0.88%
Average Market Yield 1.05% 0.88%
Average Quality NR/NR NR/NR
Contributions/Withdrawals -15,900,000
Total Market Value 73,109,353 88,821,255
22
Attachment 1
LAIF
54.9%
Local Gov
Investment
Pool
45.1%
Sector Distribution
City of Dublin Reporting Account
June 30, 2017 March 31, 2017
LAIF
56.4%
Local Gov
Investment
Pool
43.6%
23
Attachment 1
Issuers
City of Dublin Reporting Account – Account #10219 As of 6/30/2017
Issue Name Investment Type % Portfolio
Local Agency Investment Fund LAIF 54.95%
CAMP Local Gov Investment Pool 45.05%
Total 100.00%
24
Attachment 1
SECTION 3
Consolidated Information
25
Attachment 1
Portfolio Characteristics
City of Dublin Consolidated
6/30/2017 3/31/2017
Portfolio Portfolio
Average Maturity (yrs) 1.81 1.62
Modified Duration 1.67 1.48
Average Purchase Yield 1.39% 1.25%
Average Market Yield 1.44% 1.31%
Average Quality AA/Aa1 AA/Aa1
Contributions/Withdrawals
Total Market Value 231,125,238 236,107,345
26
Attachment 1
ABS
4.5%
Agency
25.7%
Commercial
Paper
1.3%
LAIF
17.4% Local Gov
Investment
Pool
14.3%
Money
Market Fund
FI
0.2%
US
Corporate
15.3%
US Treasury
21.4%
Sector Distribution
City of Dublin Consolidated
June 30, 2017 March 31, 2017
ABS
5.1%
Agency
22.9%
Commercial
Paper
1.2%
LAIF
21.2%
Local Gov
Investment
Pool
16.4%
Money
Market Fund
FI
0.5%
US
Corporate
14.8%
US Treasury
17.9%
27
Attachment 1
SECTION 4
Portfolio Holdings
28
Attachment 1
Holdings Report
For the Month Ending 6/30/2017
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
43814GAC4 Honda Auto Receivables 2014-2 A3
0.770% Due 03/19/2018
13,519.87 05/13/2014
0.29%
13,518.25
13,519.87
99.97
1.53%
13,515.79
3.76
0.01%
(4.08)
Aaa / AAA
NR
0.72
0.03
47787VAC5 John Deere Owner Trust 2014-A A3
0.920% Due 04/16/2018
15,847.89 04/02/2014
0.31%
15,845.35
15,847.89
99.98
1.89%
15,844.49
6.48
0.01%
(3.40)
Aaa / NR
AAA
0.79
0.02
43814NAB1 Honda Auto Receivables 2016-1 A2
1.010% Due 06/18/2018
267,033.11 02/16/2016
0.57%
267,006.43
267,021.98
99.96
1.38%
266,929.08
97.39
0.17%
(92.90)
NR / AAA
AAA
0.97
0.11
89236WAC2 Toyota Auto Receivables Owner 2015-A
1.120% Due 02/15/2019
445,826.38 02/24/2015
0.62%
445,758.98
445,812.08
99.90
1.43%
445,379.14
221.92
0.28%
(432.94)
Aaa / AAA
NR
1.63
0.33
47788NAB4 John Deere Owner Trust 2016-B A2
1.090% Due 02/15/2019
1,044,619.56 07/19/2016
0.92%
1,044,555.84
1,044,578.99
99.91
1.39%
1,043,672.00
506.06
0.66%
(906.99)
Aaa / NR
AAA
1.63
0.31
43813NAC0 Honda Auto Receivables 2015-2 A3
1.040% Due 02/21/2019
753,478.99 05/13/2015
0.37%
753,363.33
753,428.45
99.86
1.41%
752,436.09
217.67
0.48%
(992.36)
NR / AAA
AAA
1.65
0.38
65478WAB1 Nissan Auto Receivables Owner 2016-C A2A
1.070% Due 05/15/2019
742,204.11 08/02/2016
0.85%
742,174.87
742,184.30
99.87
1.40%
741,261.09
352.96
0.47%
(923.21)
Aaa / NR
AAA
1.87
0.39
89231LAB3 Toyota Auto Receivables Owner 2016-D
1.060% Due 05/15/2019
1,127,241.91 10/04/2016
0.88%
1,127,151.73
1,127,176.73
99.85
1.39%
1,125,584.65
531.06
0.71%
(1,592.08)
Aaa / AAA
NR
1.87
0.45
43814TAB8 Honda Auto Receivables 2017-1 A2
1.420% Due 07/22/2019
870,000.00 03/21/2017
1.27%
869,979.21
869,981.54
99.99
1.44%
869,912.13
343.17
0.55%
(69.41)
Aaa / NR
AAA
2.06
0.67
161571HH0 Chase CHAIT Pool #2016-A7
1.060% Due 09/16/2019
1,880,000.00 09/06/2016
0.76%
1,879,837.94
1,879,966.44
99.93
1.41%
1,878,764.80
885.69
1.19%
(1,201.64)
Aaa / AAA
AAA
2.21
0.19
47787XAB3 John Deere Owner Trust 2017-A A2
1.500% Due 10/15/2019
655,000.00 02/22/2017
1.50%
654,997.38
654,997.71
99.97
1.54%
654,808.74
436.67
0.41%
(188.97)
Aaa / NR
AAA
2.29
0.84
654747AB0 Nissan Auto Receivables 2017-A A2A
1.470% Due 01/15/2020
630,000.00 03/21/2017
1.47%
629,996.79
629,997.09
99.97
1.52%
629,780.13
411.60
0.40%
(216.96)
Aaa / NR
AAA
2.55
0.84
47788MAC4 John Deere Owner Trust 2016-A A3
1.360% Due 04/15/2020
1,115,000.00 02/23/2016
1.11%
1,114,824.50
1,114,881.17
99.78
1.60%
1,112,499.06
673.96
0.70%
(2,382.11)
Aaa / NR
AAA
2.79
0.95
43814QAC2 Honda Auto Receivables 2016-2 A3
1.390% Due 04/15/2020
805,000.00 05/24/2016
1.23%
804,984.38
804,988.75
99.79
1.59%
803,295.01
497.31
0.51%
(1,693.74)
Aaa / NR
AAA
2.79
1.09
Total ABS 10,364,771.82 0.96%
10,363,994.98
10,364,382.99
1.46%
10,353,682.20
5,185.70
6.56%
(10,700.79)
Aaa / AAA
Aaa
2.11
0.53
Agency
3134G3Y53 FHLMC Callable Note 1X 11/28/14
0.850% Due 11/28/2017
2,000,000.00 11/28/2012
0.85%
2,000,000.00
2,000,000.00
99.87
1.16%
1,997,452.00
1,558.33
1.27%
(2,548.00)
Aaa / AA+
AAA
0.41
0.41
313381B20 FHLB Note
0.750% Due 12/08/2017
4,000,000.00 12/13/2012
0.75%
3,999,960.00
3,999,996.49
99.80
1.21%
3,991,920.00
1,916.67
2.53%
(8,076.49)
Aaa / AA+
AAA
0.44
0.44
3135G0TG8 FNMA Note
0.875% Due 02/08/2018
3,000,000.00 01/21/2015
0.97%
2,991,390.00
2,998,282.64
99.80
1.20%
2,994,147.00
10,427.08
1.90%
(4,135.64)
Aaa / AA+
AAA
0.61
0.60
3137EADP1 FHLMC Note
0.875% Due 03/07/2018
3,000,000.00 01/27/2015
1.01%
2,987,610.00
2,997,279.44
99.74
1.25%
2,992,233.00
8,312.50
1.90%
(5,046.44)
Aaa / AA+
AAA
0.68
0.68
City of Dublin - Account #10198
29
Attachment 1
Holdings Report
For the Month Ending 6/30/2017
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
313378A43 FHLB Note
1.375% Due 03/09/2018
4,000,000.00 Various
0.96%
4,047,840.00
4,011,354.77
100.10
1.23%
4,004,004.00
17,111.12
2.54%
(7,350.77)
Aaa / AA+
AAA
0.69
0.68
313379DT3 FHLB Note
1.250% Due 06/08/2018
2,000,000.00 08/18/2015
1.12%
2,007,360.00
2,002,458.13
99.96
1.29%
1,999,266.00
1,597.22
1.27%
(3,192.13)
Aaa / AA+
AAA
0.94
0.93
3135G0G72 FNMA Note
1.125% Due 12/14/2018
2,500,000.00 12/18/2015
1.37%
2,481,975.00
2,491,210.95
99.64
1.37%
2,491,122.50
1,328.13
1.58%
(88.45)
Aaa / AA+
AAA
1.46
1.44
3133782M2 FHLB Note
1.500% Due 03/08/2019
2,750,000.00 04/24/2015
1.21%
2,779,892.50
2,763,028.98
100.12
1.43%
2,753,377.00
12,947.92
1.75%
(9,651.98)
Aaa / AA+
AAA
1.69
1.65
3137EADG1 FHLMC Note
1.750% Due 05/30/2019
1,000,000.00 01/29/2015
1.28%
1,019,690.00
1,008,692.99
100.67
1.39%
1,006,740.00
1,506.94
0.64%
(1,952.99)
Aaa / AA+
AAA
1.92
1.88
3135G0ZG1 FNMA Note
1.750% Due 09/12/2019
2,500,000.00 10/28/2014
1.68%
2,508,350.00
2,503,769.00
100.60
1.47%
2,514,947.50
13,246.53
1.60%
11,178.50
Aaa / AA+
AAA
2.20
2.14
3137EADM8 FHLMC Note
1.250% Due 10/02/2019
2,500,000.00 12/18/2015
1.64%
2,464,700.00
2,478,963.14
99.45
1.50%
2,486,247.50
7,725.69
1.58%
7,284.36
Aaa / AA+
AAA
2.26
2.21
3135G0A78 FNMA Note
1.625% Due 01/21/2020
2,000,000.00 04/07/2015
1.44%
2,016,580.00
2,008,854.04
100.26
1.52%
2,005,298.00
14,444.44
1.28%
(3,556.04)
Aaa / AA+
AAA
2.56
2.48
313383HU8 FHLB Note
1.750% Due 06/12/2020
2,000,000.00 10/08/2015
1.46%
2,026,040.00
2,016,419.84
100.34
1.63%
2,006,794.00
1,847.22
1.27%
(9,625.84)
Aaa / AA+
NR
2.95
2.86
3135G0F73 FNMA Note
1.500% Due 11/30/2020
2,500,000.00 12/04/2015
1.87%
2,455,750.00
2,469,657.14
99.39
1.69%
2,484,637.50
3,229.17
1.57%
14,980.36
Aaa / AA+
AAA
3.42
3.31
3130A7CV5 FHLB Note
1.375% Due 02/18/2021
3,470,000.00 Various
1.45%
3,457,221.20
3,460,663.52
98.92
1.68%
3,432,635.04
17,627.12
2.18%
(28,028.48)
Aaa / AA+
AAA
3.64
3.51
3135G0J20 FNMA Note
1.375% Due 02/26/2021
5,000,000.00 Various
1.29%
5,018,675.00
5,014,848.67
98.77
1.72%
4,938,635.00
23,871.52
3.14%
(76,213.67)
Aaa / AA+
AAA
3.66
3.53
3130A8QS5 FHLB Note
1.125% Due 07/14/2021
2,500,000.00 07/25/2016
1.28%
2,481,475.00
2,484,947.16
97.44
1.79%
2,435,935.00
13,046.88
1.55%
(49,012.16)
Aaa / AA+
AAA
4.04
3.90
3137EAEC9 FHLMC Note
1.125% Due 08/12/2021
3,000,000.00 Various
1.33%
2,971,215.00
2,975,964.17
97.27
1.82%
2,918,058.00
13,031.26
1.85%
(57,906.17)
Aaa / AA+
AAA
4.12
3.98
3135G0Q89 FNMA Note
1.375% Due 10/07/2021
2,000,000.00 10/06/2016
1.45%
1,992,924.00
1,993,958.66
98.20
1.82%
1,963,912.00
6,416.67
1.25%
(30,046.66)
Aaa / AA+
AAA
4.27
4.11
3135G0S38 FNMA Note
2.000% Due 01/05/2022
2,500,000.00 01/30/2017
2.04%
2,495,475.00
2,495,854.60
100.33
1.92%
2,508,312.50
23,888.89
1.60%
12,457.90
Aaa / AA+
AAA
4.52
4.26
313378CR0 FHLB Note
2.250% Due 03/11/2022
2,000,000.00 06/19/2017
1.86%
2,035,280.00
2,035,055.03
101.43
1.93%
2,028,608.00
13,750.00
1.29%
(6,447.03)
Aaa / AA+
NR
4.70
4.41
3135G0T45 FNMA Note
1.875% Due 04/05/2022
3,250,000.00 05/05/2017
1.99%
3,232,125.00
3,232,663.34
99.69
1.94%
3,239,795.00
13,710.94
2.06%
7,131.66
Aaa / AA+
AAA
4.77
4.52
Total Agency 59,470,000.00 1.35%
59,471,527.70
59,443,922.70
1.54%
59,194,076.54
222,542.24
37.60%
(249,846.16)
Aaa / AA+
Aaa
2.52
2.43
City of Dublin - Account #10198
30
Attachment 1
Holdings Report
For the Month Ending 6/30/2017
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
Commercial Paper
06538BU76 Bank of Tokyo Mitsubishi NY Discount CP
1.180% Due 07/07/2017
2,935,000.00 03/06/2017
1.20%
2,923,263.26
2,934,422.78
99.98
1.20%
2,934,422.78
0.00
1.86%
0.00
P-1 / A-1
NR
0.02
0.02
Total Commercial Paper 2,935,000.00 1.20%
2,923,263.26
2,934,422.78
1.20%
2,934,422.78
0.00
1.86%
0.00
P-1 / A-1
NR
0.02
0.02
Money Market Fund FI
31846V203 First American Govt Obligation Fund
436,922.92 Various
0.57%
436,922.92
436,922.92
1.00
0.57%
436,922.92
0.00
0.28%
0.00
Aaa / AAA
NR
0.00
0.00
Total Money Market Fund FI 436,922.92 0.57%
436,922.92
436,922.92
0.57%
436,922.92
0.00
0.28%
0.00
Aaa / AAA
NR
0.00
0.00
US Corporate
36962G6K5 General Electric Capital Corp Note
1.600% Due 11/20/2017
750,000.00 10/28/2014
1.31%
756,577.50
750,836.92
100.06
1.44%
750,458.25
1,366.67
0.48%
(378.67)
A1 / AA-
AA-
0.39
0.39
40428HPH9 HSBC USA Inc Note
1.625% Due 01/16/2018
500,000.00 11/25/2013
1.69%
498,705.00
499,829.45
100.03
1.56%
500,168.00
3,723.96
0.32%
338.55
A2 / A
AA-
0.55
0.54
713448CR7 PepsiCo Inc Note
1.250% Due 04/30/2018
1,430,000.00 Various
1.26%
1,429,428.40
1,429,841.85
99.84
1.45%
1,427,666.24
3,028.82
0.91%
(2,175.61)
A1 / A+
A
0.83
0.82
037833AJ9 Apple Inc Note
1.000% Due 05/03/2018
1,750,000.00 Various
1.34%
1,726,740.00
1,745,107.67
99.64
1.43%
1,743,656.25
2,819.44
1.11%
(1,451.42)
Aa1 / AA+
NR
0.84
0.83
166764AE0 Chevron Corp Callable Note Cont 5/24/2018
1.718% Due 06/24/2018
1,750,000.00 Various
1.57%
1,758,299.00
1,752,513.19
100.22
1.47%
1,753,832.50
584.60
1.11%
1,319.31
Aa2 / AA-
NR
0.98
0.89
06406HCL1 Bank of New York Callable Note Cont 7/2/2018
2.100% Due 08/01/2018
1,000,000.00 02/05/2014
1.94%
1,006,820.00
1,001,557.16
100.50
1.60%
1,004,971.00
8,750.00
0.64%
3,413.84
A1 / A
AA-
1.09
0.98
084664BY6 Berkshire Hathaway Note
2.000% Due 08/15/2018
1,000,000.00 12/12/2013
1.89%
1,004,960.00
1,001,194.83
100.48
1.57%
1,004,814.00
7,555.56
0.64%
3,619.17
Aa2 / AA
A+
1.13
1.10
17275RAR3 Cisco Systems Note
2.125% Due 03/01/2019
1,350,000.00 11/14/2014
2.05%
1,354,063.50
1,351,580.68
100.81
1.63%
1,360,945.80
9,562.50
0.87%
9,365.12
A1 / AA-
NR
1.67
1.63
532457BF4 Eli Lilly & Co Note
1.950% Due 03/15/2019
1,575,000.00 Various
1.91%
1,577,796.75
1,576,108.76
100.44
1.69%
1,581,972.53
9,043.13
1.01%
5,863.77
A2 / AA-
A
1.71
1.67
94974BFU9 Wells Fargo Corp Note
2.125% Due 04/22/2019
1,900,000.00 Various
2.07%
1,904,120.50
1,901,894.96
100.52
1.83%
1,909,900.90
7,738.54
1.21%
8,005.94
A2 / A
AA-
1.81
1.76
02665WAH4 American Honda Finance Note
2.250% Due 08/15/2019
1,800,000.00 Various
2.08%
1,812,627.00
1,806,301.77
100.85
1.84%
1,815,283.80
15,300.00
1.16%
8,982.03
A1 / A+
NR
2.13
2.05
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
757,243.81
100.99
1.82%
757,391.25
5,270.83
0.48%
147.44
A1 / A
AA-
2.20
2.04
68389XAX3 Oracle Corp Note
2.250% Due 10/08/2019
1,250,000.00 Various
1.73%
1,272,172.50
1,264,245.38
101.23
1.69%
1,265,400.00
6,484.38
0.80%
1,154.62
A1 / AA-
A+
2.27
2.20
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,001,155.86
100.84
2.01%
1,008,354.00
3,166.67
0.64%
7,198.14
A2 / A
AA-
2.37
2.29
City of Dublin - Account #10198
31
Attachment 1
Holdings Report
For the Month Ending 6/30/2017
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
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,794,672.48
100.31
2.12%
1,805,583.60
17,775.00
1.15%
10,911.12
A3 / A-
A+
2.57
2.38
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,570.95
99.94
1.87%
1,329,155.45
4,169.18
0.84%
(415.50)
A1 / A+
A
2.84
2.66
747525AD5 Qualcomm Inc Note
2.250% Due 05/20/2020
2,000,000.00 Various
2.22%
2,001,128.80
2,001,651.50
100.95
1.91%
2,018,970.00
5,125.00
1.28%
17,318.50
A1 / A
NR
2.89
2.78
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,020,025.29
101.20
1.97%
1,012,001.00
11,017.36
0.65%
(8,024.29)
A2 / A
A
3.04
2.89
00440EAT4 ACE 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,003,192.87
100.57
2.12%
2,011,404.00
7,411.11
1.28%
8,211.13
A3 / A
A
3.35
3.11
24422ETF6 John Deere Capital Corp Note
2.550% Due 01/08/2021
750,000.00 Various
2.42%
753,733.15
753,249.54
101.38
2.14%
760,378.50
9,190.62
0.49%
7,128.96
A2 / A
A
3.53
3.32
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,810,022.49
100.66
2.04%
1,811,802.60
13,332.00
1.16%
1,780.11
Aaa / AA+
NR
3.67
3.48
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,181.41
99.70
2.18%
996,978.00
2,625.00
0.63%
(3,203.41)
Aa2 / AA-
NR
3.88
3.69
857477AV5 State Street Bank Note
1.950% Due 05/19/2021
1,800,000.00 Various
1.91%
1,802,989.00
1,802,587.02
98.74
2.29%
1,777,269.60
4,095.01
1.13%
(25,317.42)
A1 / A
AA-
3.89
3.71
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,064.74
97.84
2.10%
1,810,091.80
11,390.35
1.15%
(36,972.94)
Aaa / AAA
AA+
4.11
3.93
91159HHP8 US Bancorp Note
2.625% Due 01/24/2022
2,000,000.00 05/23/2017
2.36%
2,023,280.00
2,022,788.17
101.04
2.38%
2,020,744.00
22,895.83
1.29%
(2,044.17)
A1 / A+
AA
4.57
4.24
Total US Corporate 35,135,000.00 1.94%
35,258,345.85
35,224,418.75
1.88%
35,239,193.07
193,421.56
22.42%
14,774.32
A1 / A+
A+
2.48
2.35
US Treasury
912828RH5 US Treasury Note
1.375% Due 09/30/2018
2,000,000.00 10/30/2014
1.32%
2,004,459.82
2,001,422.15
100.04
1.34%
2,000,782.00
6,912.57
1.27%
(640.15)
Aaa / AA+
AAA
1.25
1.23
912828C24 US Treasury Note
1.500% Due 02/28/2019
1,750,000.00 08/18/2014
1.50%
1,750,347.65
1,750,127.58
100.21
1.37%
1,753,622.50
8,773.78
1.12%
3,494.92
Aaa / AA+
AAA
1.67
1.63
912828D80 US Treasury Note
1.625% Due 08/31/2019
3,000,000.00 Various
1.78%
2,977,822.56
2,990,313.01
100.46
1.41%
3,013,710.00
16,294.16
1.92%
23,396.99
Aaa / AA+
AAA
2.17
2.11
912828G61 US Treasury Note
1.500% Due 11/30/2019
6,500,000.00 Various
1.45%
6,510,978.81
6,506,921.26
100.09
1.46%
6,506,097.00
8,258.20
4.12%
(824.26)
Aaa / AA+
AAA
2.42
2.36
912828G95 US Treasury Note
1.625% Due 12/31/2019
3,000,000.00 01/08/2015
1.50%
3,017,470.99
3,008,798.13
100.38
1.47%
3,011,250.00
132.47
1.91%
2,451.87
Aaa / AA+
AAA
2.50
2.44
912828H52 US Treasury Note
1.250% Due 01/31/2020
4,500,000.00 Various
1.53%
4,440,542.42
4,468,742.73
99.39
1.49%
4,472,401.50
23,463.40
2.85%
3,658.77
Aaa / AA+
AAA
2.59
2.52
912828K58 US Treasury Note
1.375% Due 04/30/2020
1,750,000.00 05/06/2015
1.55%
1,735,171.88
1,741,575.67
99.55
1.54%
1,742,139.00
4,054.01
1.11%
563.33
Aaa / AA+
AAA
2.84
2.76
912828XE5 US Treasury Note
1.500% Due 05/31/2020
3,000,000.00 Various
1.67%
2,976,025.68
2,985,769.98
99.85
1.55%
2,995,548.00
3,811.47
1.90%
9,778.02
Aaa / AA+
AAA
2.92
2.84
City of Dublin - Account #10198
32
Attachment 1
Holdings Report
For the Month Ending 6/30/2017
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
912828XM7 US Treasury Note
1.625% Due 07/31/2020
1,500,000.00 09/08/2015
1.52%
1,507,622.21
1,504,802.80
100.12
1.59%
1,501,758.00
10,167.47
0.96%
(3,044.80)
Aaa / AA+
AAA
3.09
2.98
912828L99 US Treasury Note
1.375% Due 10/31/2020
5,000,000.00 Various
1.69%
4,927,376.14
4,950,582.72
99.18
1.63%
4,958,985.00
11,582.88
3.15%
8,402.28
Aaa / AA+
AAA
3.34
3.24
912828N89 US Treasury Note
1.375% Due 01/31/2021
2,000,000.00 03/15/2016
1.49%
1,988,834.83
1,991,792.16
98.95
1.68%
1,979,062.00
11,470.99
1.26%
(12,730.16)
Aaa / AA+
AAA
3.59
3.46
912828S76 US Treasury Note
1.125% Due 07/31/2021
1,500,000.00 12/12/2016
1.89%
1,449,262.83
1,455,263.68
97.47
1.77%
1,462,032.00
7,039.02
0.93%
6,768.32
Aaa / AA+
AAA
4.09
3.95
912828T34 US Treasury Note
1.125% Due 09/30/2021
2,750,000.00 Various
1.65%
2,682,431.10
2,690,640.67
97.27
1.79%
2,675,018.50
7,776.64
1.70%
(15,622.17)
Aaa / AA+
AAA
4.25
4.11
912828U65 US Treasury Note
1.750% Due 11/30/2021
2,500,000.00 12/28/2016
2.06%
2,464,461.50
2,468,100.39
99.74
1.81%
2,493,457.50
3,705.60
1.58%
25,357.11
Aaa / AA+
AAA
4.42
4.23
912828V72 US Treasury Note
1.875% Due 01/31/2022
1,500,000.00 02/27/2017
1.84%
1,502,407.37
1,502,242.68
100.13
1.85%
1,501,875.00
11,731.70
0.96%
(367.68)
Aaa / AA+
AAA
4.59
4.34
912828J76 US Treasury Note
1.750% Due 03/31/2022
3,000,000.00 04/25/2017
1.85%
2,985,830.37
2,986,349.92
99.48
1.86%
2,984,532.00
13,196.72
1.90%
(1,817.92)
Aaa / AA+
AAA
4.75
4.52
912828WZ9 US Treasury Note
1.750% Due 04/30/2022
2,750,000.00 05/23/2017
1.84%
2,738,944.75
2,739,177.88
99.43
1.87%
2,734,209.50
8,152.32
1.74%
(4,968.38)
Aaa / AA+
AAA
4.84
4.60
912828XR6 US Treasury Note
1.750% Due 05/31/2022
1,500,000.00 06/28/2017
1.81%
1,496,020.65
1,496,025.08
99.41
1.88%
1,491,211.50
2,223.36
0.95%
(4,813.58)
Aaa / AA+
AAA
4.92
4.68
Total US Treasury 49,500,000.00 1.65%
49,156,011.56
49,238,648.49
1.61%
49,277,691.00
158,746.76
31.29%
39,042.51
Aaa / AA+
Aaa
3.22
3.11
TOTAL PORTFOLIO 157,841,694.74 1.54%
157,610,066.27
157,642,718.63 1.62%
157,435,988.51
579,896.26
100.00%
(206,730.12)
Aa1 / AA
Aaa
2.65
2.45
TOTAL MARKET VALUE PLUS ACCRUALS 158,015,884.77
City of Dublin - Account #10198
33
Attachment 1
Holdings Report
For the Month Ending 6/30/2017
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,074,182.45 Various
1.01%
40,074,182.45
40,074,182.45
1.00
1.01%
40,074,182.45
97,140.98
54.95%
0.00
NR / NR
NR
0.00
0.00
Total LAIF 40,074,182.45 1.01%
40,074,182.45
40,074,182.45
1.01%
40,074,182.45
97,140.98
54.95%
0.00
NR / NR
NR
0.00
0.00
Local Gov Investment Pool
90CAMP$00 Public Financial Management CAMP
32,938,029.79 Various
1.09%
32,938,029.79
32,938,029.79
1.00
1.09%
32,938,029.79
0.00
45.05%
0.00
NR / NR
NR
0.00
0.00
Total Local Gov Investment Pool 32,938,029.79 1.09%
32,938,029.79
32,938,029.79
1.09%
32,938,029.79
0.00
45.05%
0.00
NR / NR
NR
0.00
0.00
TOTAL PORTFOLIO 73,012,212.24 1.05%
73,012,212.24
73,012,212.24 1.05%
73,012,212.24
97,140.98
100.00%
0.00
NR / NR
NR
0.00
0.00
TOTAL MARKET VALUE PLUS ACCRUALS 73,109,353.22
City of Dublin Reporting Account - Account #10219
34
Attachment 1
SECTION 5
Transactions
35
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 04/21/2017 00440EAT4 150,000.00 ACE INA Holdings Inc Callable Note Cont 10/3/2020
2.3% Due: 11/03/2020 100.846 2.04% 151,269.00 1,610.00 152,879.00 0.00
Purchase 04/21/2017 747525AD5 285,000.00 Qualcomm Inc Note
2.25% Due: 05/20/2020 100.976 1.92% 287,781.60 2,689.69 290,471.29 0.00
Purchase 04/25/2017 166764BG4 1,000,000.00 Chevron Corp Callable Note Cont 4/15/2021
2.1% Due: 05/16/2021 100.019 2.09% 1,000,190.00 9,275.00 1,009,465.00 0.00
Purchase 04/26/2017 912828J76 3,000,000.00 US Treasury Note
1.75% Due: 03/31/2022 99.528 1.85% 2,985,830.37 3,729.51 2,989,559.88 0.00
Purchase 05/08/2017 3135G0T45 3,250,000.00 FNMA Note
1.875% Due: 04/05/2022 99.450 1.99% 3,232,125.00 4,739.58 3,236,864.58 0.00
Purchase 05/24/2017 912828WZ9 2,750,000.00 US Treasury Note
1.75% Due: 04/30/2022 99.598 1.84% 2,738,944.75 3,138.59 2,742,083.34 0.00
Purchase 05/26/2017 91159HHP8 2,000,000.00 US Bancorp Note
2.625% Due: 01/24/2022 101.164 2.36% 2,023,280.00 17,791.67 2,041,071.67 0.00
Purchase 06/20/2017 313378CR0 2,000,000.00 FHLB Note
2.25% Due: 03/11/2022 101.764 1.86% 2,035,280.00 12,375.00 2,047,655.00 0.00
Purchase 06/29/2017 912828XR6 1,500,000.00 US Treasury Note
1.75% Due: 05/31/2022 99.735 1.81% 1,496,020.65 2,079.92 1,498,100.57 0.00
Subtotal 15,935,000.00 15,950,721.37 57,428.96 16,008,150.33 0.00
TOTAL ACQUISITIONS 15,935,000.00 15,950,721.37 57,428.96 16,008,150.33 0.00
DISPOSITIONS
Call 04/15/2017 91159HHD5 1,500,000.00 US Bancorp Callable Note Cont 4/15/2017
1.65% Due: 05/15/2017 100.000 1.65% 1,500,000.00 10,312.50 1,510,312.50 0.00
Subtotal 1,500,000.00 1,500,000.00 10,312.50 1,510,312.50 0.00
March 31, 2017 through June 30, 2017
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
Maturity 06/01/2017 913017BU2 1,600,000.00 United Tech Corp Note
1.8% Due: 06/01/2017 100.000 1,600,000.00 0.00 1,600,000.00 0.00
Subtotal 1,600,000.00 1,600,000.00 0.00 1,600,000.00 0.00
TOTAL DISPOSITIONS 4,705,907.91 4,705,907.91 44,195.19 4,750,103.10 0.00
March 31, 2017 through June 30, 2017
37
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 04/15/2017 90LAIF$00 95,616.05 Local Agency Investment Fund State Pool 1.000 0.83% 95,616.05 0.00 95,616.05 0.00
Purchase 04/30/2017 90CAMP$00 30,214.95 Public Financial Management CAMP 1.000 0.96% 30,214.95 0.00 30,214.95 0.00
Purchase 05/31/2017 90CAMP$00 31,996.42 Public Financial Management CAMP 1.000 0.96% 31,996.42 0.00 31,996.42 0.00
Purchase 06/30/2017 90CAMP$00 29,980.44 Public Financial Management CAMP 1.000 1.09% 29,980.44 0.00 29,980.44 0.00
Subtotal 187,807.86 187,807.86 0.00 187,807.86 0.00
Security
Contribution 04/26/2017 90CAMP$00 2,000,000.00 Public Financial Management CAMP 1.000 2,000,000.00 0.00 2,000,000.00 0.00
Security
Contribution 05/26/2017 90CAMP$00 3,000,000.00 Public Financial Management CAMP 1.000 3,000,000.00 0.00 3,000,000.00 0.00
Subtotal 5,000,000.00 5,000,000.00 0.00 5,000,000.00 0.00
TOTAL ACQUISITIONS 5,187,807.86 5,187,807.86 0.00 5,187,807.86 0.00
DISPOSITIONS
Security
Withdrawal 04/07/2017 90CAMP$00 1,100,000.00 Public Financial Management CAMP 1.000 1,100,000.00 0.00 1,100,000.00 0.00
Security
Withdrawal 04/18/2017 90LAIF$00 10,000,000.00 Local Agency Investment Fund State Pool 1.000 10,000,000.00 0.00 10,000,000.00 0.00
Security
Withdrawal 05/16/2017 90CAMP$00 3,000,000.00 Public Financial Management CAMP 1.000 3,000,000.00 0.00 3,000,000.00 0.00
Security
Withdrawal 06/02/2017 90CAMP$00 2,500,000.00 Public Financial Management CAMP 1.000 2,500,000.00 0.00 2,500,000.00 0.00
Security
Withdrawal 06/09/2017 90CAMP$00 3,300,000.00 Public Financial Management CAMP 1.000 3,300,000.00 0.00 3,300,000.00 0.00
Security
Withdrawal 06/27/2017 90CAMP$00 1,000,000.00 Public Financial Management CAMP 1.000 1,000,000.00 0.00 1,000,000.00 0.00
Subtotal 20,900,000.00 20,900,000.00 0.00 20,900,000.00 0.00
TOTAL DISPOSITIONS 20,900,000.00 20,900,000.00 0.00 20,900,000.00 0.00
March 31, 2017 through June 30, 2017
38
Attachment 1
Transaction Ledger
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 04/15/2017 90LAIF$00 95,616.05 Local Agency Investment Fund State Pool 1.000 0.83% 95,616.05 0.00 95,616.05 0.00
Purchase 04/21/2017 00440EAT4 150,000.00 ACE INA Holdings Inc Callable Note Cont 10/3/2020
2.3% Due: 11/03/2020 100.846 2.04% 151,269.00 1,610.00 152,879.00 0.00
Purchase 04/21/2017 747525AD5 285,000.00 Qualcomm Inc Note
2.25% Due: 05/20/2020 100.976 1.92% 287,781.60 2,689.69 290,471.29 0.00
Purchase 04/25/2017 166764BG4 1,000,000.00 Chevron Corp Callable Note Cont 4/15/2021
2.1% Due: 05/16/2021 100.019 2.09% 1,000,190.00 9,275.00 1,009,465.00 0.00
Purchase 04/26/2017 912828J76 3,000,000.00 US Treasury Note
1.75% Due: 03/31/2022 99.528 1.85% 2,985,830.37 3,729.51 2,989,559.88 0.00
Purchase 04/30/2017 90CAMP$00 30,214.95 Public Financial Management CAMP 1.000 0.96% 30,214.95 0.00 30,214.95 0.00
Purchase 05/08/2017 3135G0T45 3,250,000.00 FNMA Note
1.875% Due: 04/05/2022 99.450 1.99% 3,232,125.00 4,739.58 3,236,864.58 0.00
Purchase 05/24/2017 912828WZ9 2,750,000.00 US Treasury Note
1.75% Due: 04/30/2022 99.598 1.84% 2,738,944.75 3,138.59 2,742,083.34 0.00
Purchase 05/26/2017 91159HHP8 2,000,000.00 US Bancorp Note
2.625% Due: 01/24/2022 101.164 2.36% 2,023,280.00 17,791.67 2,041,071.67 0.00
Purchase 05/31/2017 90CAMP$00 31,996.42 Public Financial Management CAMP 1.000 0.96% 31,996.42 0.00 31,996.42 0.00
Purchase 06/20/2017 313378CR0 2,000,000.00 FHLB Note
2.25% Due: 03/11/2022 101.764 1.86% 2,035,280.00 12,375.00 2,047,655.00 0.00
Purchase 06/29/2017 912828XR6 1,500,000.00 US Treasury Note
1.75% Due: 05/31/2022 99.735 1.81% 1,496,020.65 2,079.92 1,498,100.57 0.00
Purchase 06/30/2017 90CAMP$00 29,980.44 Public Financial Management CAMP 1.000 1.09% 29,980.44 0.00 29,980.44 0.00
Subtotal 16,122,807.86 16,138,529.23 57,428.96 16,195,958.19 0.00
Security
Contribution 04/26/2017 90CAMP$00 2,000,000.00 Public Financial Management CAMP 1.000 2,000,000.00 0.00 2,000,000.00 0.00
March 31, 2017 through June 30, 2017
39
Attachment 1
Disclosure
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.
40
Attachment 1
Transaction Ledger
3/31/17 Thru 4/30/17
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 04/02/2017 31846V203 15,625.00 First American Govt Obligation Fund 1.000 0.34 %15,625.00 0.00 15,625.00 0.00
Purchase 04/03/2017 31846V203 506.42 First American Govt Obligation Fund 1.000 0.34 %506.42 0.00 506.42 0.00
Purchase 04/07/2017 31846V203 13,750.00 First American Govt Obligation Fund 1.000 0.34 %13,750.00 0.00 13,750.00 0.00
Purchase 04/08/2017 31846V203 14,062.50 First American Govt Obligation Fund 1.000 0.34 %14,062.50 0.00 14,062.50 0.00
Purchase 04/15/2017 31846V203 1,510,312.50 First American Govt Obligation Fund 1.000 0.34 %1,510,312.50 0.00 1,510,312.50 0.00
Purchase 04/15/2017 90LAIF$00 95,616.05 Local Agency Investment Fund State Pool 1.000 0.83 %95,616.05 0.00 95,616.05 0.00
Purchase 04/17/2017 31846V203 1,203.54 First American Govt Obligation Fund 1.000 0.34 %1,203.54 0.00 1,203.54 0.00
Purchase 04/17/2017 31846V203 1,073.25 First American Govt Obligation Fund 1.000 0.34 %1,073.25 0.00 1,073.25 0.00
Purchase 04/17/2017 31846V203 437.33 First American Govt Obligation Fund 1.000 0.34 %437.33 0.00 437.33 0.00
Purchase 04/17/2017 31846V203 1,660.67 First American Govt Obligation Fund 1.000 0.34 %1,660.67 0.00 1,660.67 0.00
Purchase 04/17/2017 31846V203 1,263.67 First American Govt Obligation Fund 1.000 0.34 %1,263.67 0.00 1,263.67 0.00
Purchase 04/17/2017 31846V203 932.46 First American Govt Obligation Fund 1.000 0.34 %932.46 0.00 932.46 0.00
Purchase 04/17/2017 31846V203 44,858.85 First American Govt Obligation Fund 1.000 0.34 %44,858.85 0.00 44,858.85 0.00
Purchase 04/17/2017 31846V203 31,458.69 First American Govt Obligation Fund 1.000 0.34 %31,458.69 0.00 31,458.69 0.00
Purchase 04/17/2017 31846V203 28,474.00 First American Govt Obligation Fund 1.000 0.34 %28,474.00 0.00 28,474.00 0.00
Purchase 04/17/2017 31846V203 67,542.53 First American Govt Obligation Fund 1.000 0.34 %67,542.53 0.00 67,542.53 0.00
Purchase 04/18/2017 31846V203 39,771.65 First American Govt Obligation Fund 1.000 0.34 %39,771.65 0.00 39,771.65 0.00
Purchase 04/18/2017 31846V203 111,749.50 First American Govt Obligation Fund 1.000 0.34 %111,749.50 0.00 111,749.50 0.00
Purchase 04/21/2017 00440EAT4 150,000.00 ACE INA Holdings Inc Callable Note Cont
10/3/2020
2.3% Due 11/3/2020
100.846 2.04 %151,269.00 1,610.00 152,879.00 0.00
Purchase 04/21/2017 31846V203 789.28 First American Govt Obligation Fund 1.000 0.34 %789.28 0.00 789.28 0.00
Purchase 04/21/2017 31846V203 107,781.32 First American Govt Obligation Fund 1.000 0.34 %107,781.32 0.00 107,781.32 0.00
Purchase 04/21/2017 747525AD5 285,000.00 Qualcomm Inc Note
2.25% Due 5/20/2020
100.976 1.92 %287,781.60 2,689.69 290,471.29 0.00
Purchase 04/22/2017 31846V203 20,187.50 First American Govt Obligation Fund 1.000 0.34 %20,187.50 0.00 20,187.50 0.00
Purchase 04/24/2017 31846V203 1,173.54 First American Govt Obligation Fund 1.000 0.34 %1,173.54 0.00 1,173.54 0.00
Purchase 04/25/2017 166764BG4 1,000,000.00 Chevron Corp Callable Note Cont 4/15/2021
2.1% Due 5/16/2021
100.019 2.09 %1,000,190.00 9,275.00 1,009,465.00 0.00
Purchase 04/26/2017 912828J76 3,000,000.00 US Treasury Note
1.75% Due 3/31/2022
99.528 1.85 %2,985,830.37 3,729.51 2,989,559.88 0.00
Purchase 04/30/2017 31846V203 67,646.25 First American Govt Obligation Fund 1.000 0.36 %67,646.25 0.00 67,646.25 0.00
Execution Time: 5/16/2017 12:06:00 PMChandler Asset Management - CONFIDENTIAL Page 8
Attachment 2
Transaction Ledger
3/31/17 Thru 4/30/17
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 04/30/2017 90CAMP$00 30,214.95 Public Financial Management CAMP 1.000 0.96 %30,214.95 0.00 30,214.95 0.00
Subtotal 6,643,091.45 6,633,162.42 17,304.20 6,650,466.62 0.00
Security
Contribution
04/19/2017 31846V203 10,000,000.00 First American Govt Obligation Fund 1.000 10,000,000.00 0.00 10,000,000.00 0.00
Security
Contribution
04/26/2017 90CAMP$00 2,000,000.00 Public Financial Management CAMP 1.000 2,000,000.00 0.00 2,000,000.00 0.00
Subtotal 12,000,000.00 12,000,000.00 0.00 12,000,000.00 0.00
TOTAL ACQUISITIONS 18,643,091.45 18,633,162.42 17,304.20 18,650,466.62 0.00
DISPOSITIONS
Sale 04/21/2017 31846V203 443,350.29 First American Govt Obligation Fund 1.000 0.34 %443,350.29 0.00 443,350.29 0.00
Sale 04/25/2017 31846V203 1,009,465.00 First American Govt Obligation Fund 1.000 0.34 %1,009,465.00 0.00 1,009,465.00 0.00
Sale 04/26/2017 31846V203 2,989,559.88 First American Govt Obligation Fund 1.000 0.34 %2,989,559.88 0.00 2,989,559.88 0.00
Subtotal 4,442,375.17 4,442,375.17 0.00 4,442,375.17 0.00
Call 04/15/2017 91159HHD5 1,500,000.00 US Bancorp Callable Note Cont 4/15/2017
1.65% Due 5/15/2017
100.000 1.65 %1,500,000.00 10,312.50 1,510,312.50 0.00
Subtotal 1,500,000.00 1,500,000.00 10,312.50 1,510,312.50 0.00
Paydown 04/17/2017 161571HH0 0.00 Chase CHAIT Pool #2016-A7
1.06% Due 9/16/2019
100.000 0.00 1,660.67 1,660.67 0.00
Paydown 04/17/2017 43814QAC2 0.00 Honda Auto Receivables 2016-2 A3
1.39% Due 4/15/2020
100.000 0.00 932.46 932.46 0.00
Paydown 04/17/2017 47787VAC5 44,754.29 John Deere Owner Trust 2014-A A3
0.92% Due 4/16/2018
100.000 44,754.29 104.56 44,858.85 0.00
Paydown 04/17/2017 47788MAC4 0.00 John Deere Owner Trust 2016-A A3
1.36% Due 4/15/2020
100.000 0.00 1,263.67 1,263.67 0.00
Paydown 04/17/2017 47788NAB4 0.00 John Deere Owner Trust 2016-B A2
1.09% Due 2/15/2019
100.000 0.00 1,203.54 1,203.54 0.00
Paydown 04/17/2017 654747AB0 0.00 Nissan Auto Receivables 2017-A A2A
1.47% Due 1/15/2020
100.000 0.00 437.33 437.33 0.00
Execution Time: 5/16/2017 12:06:00 PMChandler Asset Management - CONFIDENTIAL Page 9
Attachment 2
Transaction Ledger
3/31/17 Thru 4/30/17
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 04/17/2017 65478WAB1 30,629.44 Nissan Auto Receivables Owner 2016-C
A2A
1.07% Due 5/15/2019
100.000 30,629.44 829.25 31,458.69 0.00
Paydown 04/17/2017 89231LAB3 0.00 Toyota Auto Receivables Owner 2016-D
1.06% Due 5/15/2019
100.000 0.00 1,073.25 1,073.25 0.00
Paydown 04/17/2017 89231TAB6 28,452.19 Toyota Auto Receivables Owner 2015-C
0.92% Due 2/15/2018
100.000 28,452.19 21.81 28,474.00 0.00
Paydown 04/17/2017 89236WAC2 66,955.04 Toyota Auto Receivables Owner 2015-A
1.12% Due 2/15/2019
100.000 66,955.04 587.49 67,542.53 0.00
Paydown 04/18/2017 43814GAC4 39,693.16 Honda Auto Receivables 2014-2 A3
0.77% Due 3/19/2018
100.000 39,693.16 78.49 39,771.65 0.00
Paydown 04/18/2017 43814NAB1 111,260.21 Honda Auto Receivables 2016-1 A2
1.01% Due 6/18/2018
100.000 111,260.21 489.29 111,749.50 0.00
Paydown 04/21/2017 43813NAC0 106,873.28 Honda Auto Receivables 2015-2 A3
1.04% Due 2/21/2019
100.000 106,873.28 908.04 107,781.32 0.00
Paydown 04/21/2017 43814TAB8 0.00 Honda Auto Receivables 2017-1 A2
1.42% Due 7/22/2019
100.000 0.00 789.28 789.28 0.00
Paydown 04/24/2017 47787XAB3 0.00 John Deere Owner Trust 2017-A A2
1.5% Due 10/15/2019
100.000 0.00 1,173.54 1,173.54 0.00
Subtotal 428,617.61 428,617.61 11,552.67 440,170.28 0.00
Security
Withdrawal
04/07/2017 90CAMP$00 1,100,000.00 Public Financial Management CAMP 1.000 1,100,000.00 0.00 1,100,000.00 0.00
Security
Withdrawal
04/18/2017 90LAIF$00 10,000,000.00 Local Agency Investment Fund State Pool 1.000 10,000,000.00 0.00 10,000,000.00 0.00
Security
Withdrawal
04/25/2017 31846V203 104.17 First American Govt Obligation Fund 1.000 104.17 0.00 104.17 0.00
Subtotal 11,100,104.17 11,100,104.17 0.00 11,100,104.17 0.00
TOTAL DISPOSITIONS 17,471,096.95 17,471,096.95 21,865.17 17,492,962.12 0.00
OTHER TRANSACTIONS
Interest 04/02/2017 3137EADM8 2,500,000.00 FHLMC Note
1.25% Due 10/2/2019
0.000 15,625.00 0.00 15,625.00 0.00
Interest 04/07/2017 3135G0Q89 2,000,000.00 FNMA Note
1.375% Due 10/7/2021
0.000 13,750.00 0.00 13,750.00 0.00
Interest 04/08/2017 68389XAX3 1,250,000.00 Oracle Corp Note
2.25% Due 10/8/2019
0.000 14,062.50 0.00 14,062.50 0.00
Execution Time: 5/16/2017 12:06:00 PMChandler Asset Management - CONFIDENTIAL Page 10
Attachment 2
Transaction Ledger
3/31/17 Thru 4/30/17
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 04/22/2017 94974BFU9 1,900,000.00 Wells Fargo Corp Note
2.125% Due 4/22/2019
0.000 20,187.50 0.00 20,187.50 0.00
Interest 04/30/2017 713448CR7 1,430,000.00 PepsiCo Inc Note
1.25% Due 4/30/2018
0.000 8,937.50 0.00 8,937.50 0.00
Interest 04/30/2017 713448CS5 1,330,000.00 PepsiCo Inc Callable Note Cont 3/30/2020
1.85% Due 4/30/2020
0.000 12,302.50 0.00 12,302.50 0.00
Interest 04/30/2017 912828K58 1,750,000.00 US Treasury Note
1.375% Due 4/30/2020
0.000 12,031.25 0.00 12,031.25 0.00
Interest 04/30/2017 912828L99 5,000,000.00 US Treasury Note
1.375% Due 10/31/2020
0.000 34,375.00 0.00 34,375.00 0.00
Subtotal 17,160,000.00 131,271.25 0.00 131,271.25 0.00
Dividend 04/03/2017 31846V203 1,233,544.97 First American Govt Obligation Fund 0.000 506.42 0.00 506.42 0.00
Dividend 04/15/2017 90LAIF$00 4,496,881,177.6
0
Local Agency Investment Fund State Pool 0.000 95,616.05 0.00 95,616.05 0.00
Dividend 04/30/2017 90CAMP$00 38,745,837.98 Public Financial Management CAMP 0.000 30,214.95 0.00 30,214.95 0.00
Subtotal 4,536,860,560.5
5
126,337.42 0.00 126,337.42 0.00
TOTAL OTHER TRANSACTIONS 4,554,020,560.5
5
257,608.67 0.00 257,608.67 0.00
Execution Time: 5/16/2017 12:06:00 PMChandler Asset Management - CONFIDENTIAL Page 11
Attachment 2
Transaction Ledger
4/30/17 Thru 5/31/17
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 05/01/2017 31846V203 1,580.55 First American Govt Obligation Fund 1.000 0.36 %1,580.55 0.00 1,580.55 0.00
Purchase 05/03/2017 31846V203 31,750.00 First American Govt Obligation Fund 1.000 0.36 %31,750.00 0.00 31,750.00 0.00
Purchase 05/08/2017 3135G0T45 3,250,000.00 FNMA Note
1.875% Due 4/5/2022
99.450 1.99 %3,232,125.00 4,739.58 3,236,864.58 0.00
Purchase 05/13/2017 31846V203 11,940.97 First American Govt Obligation Fund 1.000 0.36 %11,940.97 0.00 11,940.97 0.00
Purchase 05/15/2017 31846V203 1,660.67 First American Govt Obligation Fund 1.000 0.36 %1,660.67 0.00 1,660.67 0.00
Purchase 05/15/2017 31846V203 932.46 First American Govt Obligation Fund 1.000 0.36 %932.46 0.00 932.46 0.00
Purchase 05/15/2017 31846V203 46,240.82 First American Govt Obligation Fund 1.000 0.36 %46,240.82 0.00 46,240.82 0.00
Purchase 05/15/2017 31846V203 818.75 First American Govt Obligation Fund 1.000 0.36 %818.75 0.00 818.75 0.00
Purchase 05/15/2017 31846V203 1,263.67 First American Govt Obligation Fund 1.000 0.36 %1,263.67 0.00 1,263.67 0.00
Purchase 05/15/2017 31846V203 172,739.31 First American Govt Obligation Fund 1.000 0.36 %172,739.31 0.00 172,739.31 0.00
Purchase 05/15/2017 31846V203 771.75 First American Govt Obligation Fund 1.000 0.36 %771.75 0.00 771.75 0.00
Purchase 05/15/2017 31846V203 76,972.26 First American Govt Obligation Fund 1.000 0.36 %76,972.26 0.00 76,972.26 0.00
Purchase 05/15/2017 31846V203 1,073.25 First American Govt Obligation Fund 1.000 0.36 %1,073.25 0.00 1,073.25 0.00
Purchase 05/15/2017 31846V203 57,115.39 First American Govt Obligation Fund 1.000 0.36 %57,115.39 0.00 57,115.39 0.00
Purchase 05/16/2017 31846V203 10,500.00 First American Govt Obligation Fund 1.000 0.36 %10,500.00 0.00 10,500.00 0.00
Purchase 05/17/2017 31846V203 34,668.13 First American Govt Obligation Fund 1.000 0.36 %34,668.13 0.00 34,668.13 0.00
Purchase 05/17/2017 31846V203 100,393.71 First American Govt Obligation Fund 1.000 0.36 %100,393.71 0.00 100,393.71 0.00
Purchase 05/19/2017 31846V203 17,550.00 First American Govt Obligation Fund 1.000 0.36 %17,550.00 0.00 17,550.00 0.00
Purchase 05/20/2017 31846V203 28,500.00 First American Govt Obligation Fund 1.000 0.36 %28,500.00 0.00 28,500.00 0.00
Purchase 05/22/2017 31846V203 94,717.17 First American Govt Obligation Fund 1.000 0.36 %94,717.17 0.00 94,717.17 0.00
Purchase 05/22/2017 31846V203 1,029.50 First American Govt Obligation Fund 1.000 0.36 %1,029.50 0.00 1,029.50 0.00
Purchase 05/24/2017 912828WZ9 2,750,000.00 US Treasury Note
1.75% Due 4/30/2022
99.598 1.84 %2,738,944.75 3,138.59 2,742,083.34 0.00
Purchase 05/26/2017 91159HHP8 2,000,000.00 US Bancorp Note
2.625% Due 1/24/2022
101.164 2.36 %2,023,280.00 17,791.67 2,041,071.67 0.00
Purchase 05/28/2017 31846V203 8,500.00 First American Govt Obligation Fund 1.000 0.36 %8,500.00 0.00 8,500.00 0.00
Purchase 05/30/2017 31846V203 27,500.00 First American Govt Obligation Fund 1.000 0.38 %27,500.00 0.00 27,500.00 0.00
Purchase 05/31/2017 31846V203 93,125.00 First American Govt Obligation Fund 1.000 0.38 %93,125.00 0.00 93,125.00 0.00
Purchase 05/31/2017 90CAMP$00 31,996.42 Public Financial Management CAMP 1.000 0.96 %31,996.42 0.00 31,996.42 0.00
Subtotal 8,853,339.78 8,847,689.53 25,669.84 8,873,359.37 0.00
Execution Time: 6/23/2017 11:24:57 AMChandler Asset Management - CONFIDENTIAL Page 8
Attachment 2
Transaction Ledger
4/30/17 Thru 5/31/17
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
05/26/2017 90CAMP$00 3,000,000.00 Public Financial Management CAMP 1.000 3,000,000.00 0.00 3,000,000.00 0.00
Subtotal 3,000,000.00 3,000,000.00 0.00 3,000,000.00 0.00
TOTAL ACQUISITIONS 11,853,339.78 11,847,689.53 25,669.84 11,873,359.37 0.00
DISPOSITIONS
Sale 05/08/2017 31846V203 3,236,864.58 First American Govt Obligation Fund 1.000 0.36 %3,236,864.58 0.00 3,236,864.58 0.00
Sale 05/24/2017 31846V203 2,742,083.34 First American Govt Obligation Fund 1.000 0.36 %2,742,083.34 0.00 2,742,083.34 0.00
Sale 05/26/2017 31846V203 2,041,071.67 First American Govt Obligation Fund 1.000 0.36 %2,041,071.67 0.00 2,041,071.67 0.00
Subtotal 8,020,019.59 8,020,019.59 0.00 8,020,019.59 0.00
Paydown 05/15/2017 161571HH0 0.00 Chase CHAIT Pool #2016-A7
1.06% Due 9/16/2019
100.000 0.00 1,660.67 1,660.67 0.00
Paydown 05/15/2017 43814QAC2 0.00 Honda Auto Receivables 2016-2 A3
1.39% Due 4/15/2020
100.000 0.00 932.46 932.46 0.00
Paydown 05/15/2017 47787VAC5 46,170.57 John Deere Owner Trust 2014-A A3
0.92% Due 4/16/2018
100.000 46,170.57 70.25 46,240.82 0.00
Paydown 05/15/2017 47787XAB3 0.00 John Deere Owner Trust 2017-A A2
1.5% Due 10/15/2019
100.000 0.00 818.75 818.75 0.00
Paydown 05/15/2017 47788MAC4 0.00 John Deere Owner Trust 2016-A A3
1.36% Due 4/15/2020
100.000 0.00 1,263.67 1,263.67 0.00
Paydown 05/15/2017 47788NAB4 171,535.77 John Deere Owner Trust 2016-B A2
1.09% Due 2/15/2019
100.000 171,535.77 1,203.54 172,739.31 0.00
Paydown 05/15/2017 654747AB0 0.00 Nissan Auto Receivables 2017-A A2A
1.47% Due 1/15/2020
100.000 0.00 771.75 771.75 0.00
Paydown 05/15/2017 65478WAB1 76,170.32 Nissan Auto Receivables Owner 2016-C
A2A
1.07% Due 5/15/2019
100.000 76,170.32 801.94 76,972.26 0.00
Paydown 05/15/2017 89231LAB3 0.00 Toyota Auto Receivables Owner 2016-D
1.06% Due 5/15/2019
100.000 0.00 1,073.25 1,073.25 0.00
Paydown 05/15/2017 89236WAC2 56,590.39 Toyota Auto Receivables Owner 2015-A
1.12% Due 2/15/2019
100.000 56,590.39 525.00 57,115.39 0.00
Execution Time: 6/23/2017 11:24:57 AMChandler Asset Management - CONFIDENTIAL Page 9
Attachment 2
Transaction Ledger
4/30/17 Thru 5/31/17
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 05/18/2017 43814GAC4 34,615.11 Honda Auto Receivables 2014-2 A3
0.77% Due 3/19/2018
100.000 34,615.11 53.02 34,668.13 0.00
Paydown 05/18/2017 43814NAB1 99,998.06 Honda Auto Receivables 2016-1 A2
1.01% Due 6/18/2018
100.000 99,998.06 395.65 100,393.71 0.00
Paydown 05/22/2017 43813NAC0 93,901.75 Honda Auto Receivables 2015-2 A3
1.04% Due 2/21/2019
100.000 93,901.75 815.42 94,717.17 0.00
Paydown 05/22/2017 43814TAB8 0.00 Honda Auto Receivables 2017-1 A2
1.42% Due 7/22/2019
100.000 0.00 1,029.50 1,029.50 0.00
Subtotal 578,981.97 578,981.97 11,414.87 590,396.84 0.00
Security
Withdrawal
05/16/2017 90CAMP$00 3,000,000.00 Public Financial Management CAMP 1.000 3,000,000.00 0.00 3,000,000.00 0.00
Security
Withdrawal
05/25/2017 31846V203 104.17 First American Govt Obligation Fund 1.000 104.17 0.00 104.17 0.00
Subtotal 3,000,104.17 3,000,104.17 0.00 3,000,104.17 0.00
TOTAL DISPOSITIONS 11,599,105.73 11,599,105.73 11,414.87 11,610,520.60 0.00
OTHER TRANSACTIONS
Interest 05/03/2017 00440EAT4 2,000,000.00 ACE INA Holdings Inc Callable Note Cont
10/3/2020
2.3% Due 11/3/2020
0.000 23,000.00 0.00 23,000.00 0.00
Interest 05/03/2017 037833AJ9 1,750,000.00 Apple Inc Note
1% Due 5/3/2018
0.000 8,750.00 0.00 8,750.00 0.00
Interest 05/13/2017 40428HPN6 1,000,000.00 HSBC USA Inc Note
2.375% Due 11/13/2019
0.000 11,940.97 0.00 11,940.97 0.00
Interest 05/16/2017 166764BG4 1,000,000.00 Chevron Corp Callable Note Cont 4/15/2021
2.1% Due 5/16/2021
0.000 10,500.00 0.00 10,500.00 0.00
Interest 05/19/2017 857477AV5 1,800,000.00 State Street Bank Note
1.95% Due 5/19/2021
0.000 17,550.00 0.00 17,550.00 0.00
Interest 05/20/2017 36962G6K5 750,000.00 General Electric Capital Corp Note
1.6% Due 11/20/2017
0.000 6,000.00 0.00 6,000.00 0.00
Interest 05/20/2017 747525AD5 2,000,000.00 Qualcomm Inc Note
2.25% Due 5/20/2020
0.000 22,500.00 0.00 22,500.00 0.00
Interest 05/28/2017 3134G3Y53 2,000,000.00 FHLMC Callable Note 1X 11/28/14
0.85% Due 11/28/2017
0.000 8,500.00 0.00 8,500.00 0.00
Interest 05/30/2017 3135G0F73 2,500,000.00 FNMA Note
1.5% Due 11/30/2020
0.000 18,750.00 0.00 18,750.00 0.00
Execution Time: 6/23/2017 11:24:57 AMChandler Asset Management - CONFIDENTIAL Page 10
Attachment 2
Transaction Ledger
4/30/17 Thru 5/31/17
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 05/30/2017 3137EADG1 1,000,000.00 FHLMC Note
1.75% Due 5/30/2019
0.000 8,750.00 0.00 8,750.00 0.00
Interest 05/31/2017 912828G61 6,500,000.00 US Treasury Note
1.5% Due 11/30/2019
0.000 48,750.00 0.00 48,750.00 0.00
Interest 05/31/2017 912828U65 2,500,000.00 US Treasury Note
1.75% Due 11/30/2021
0.000 21,875.00 0.00 21,875.00 0.00
Interest 05/31/2017 912828XE5 3,000,000.00 US Treasury Note
1.5% Due 5/31/2020
0.000 22,500.00 0.00 22,500.00 0.00
Subtotal 27,800,000.00 229,365.97 0.00 229,365.97 0.00
Dividend 05/01/2017 31846V203 8,857,701.08 First American Govt Obligation Fund 0.000 1,580.55 0.00 1,580.55 0.00
Dividend 05/31/2017 90CAMP$00 39,676,052.93 Public Financial Management CAMP 0.000 31,996.42 0.00 31,996.42 0.00
Subtotal 48,533,754.01 33,576.97 0.00 33,576.97 0.00
TOTAL OTHER TRANSACTIONS 76,333,754.01 262,942.94 0.00 262,942.94 0.00
Execution Time: 6/23/2017 11:24:57 AMChandler Asset Management - CONFIDENTIAL Page 11
Attachment 2
Transaction Ledger
5/31/17 Thru 6/30/17
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 06/01/2017 31846V203 14,400.00 First American Govt Obligation Fund 1.000 0.38 %14,400.00 0.00 14,400.00 0.00
Purchase 06/01/2017 31846V203 1,600,000.00 First American Govt Obligation Fund 1.000 0.38 %1,600,000.00 0.00 1,600,000.00 0.00
Purchase 06/01/2017 31846V203 1,768.50 First American Govt Obligation Fund 1.000 0.38 %1,768.50 0.00 1,768.50 0.00
Purchase 06/08/2017 31846V203 27,500.00 First American Govt Obligation Fund 1.000 0.38 %27,500.00 0.00 27,500.00 0.00
Purchase 06/12/2017 31846V203 17,500.00 First American Govt Obligation Fund 1.000 0.38 %17,500.00 0.00 17,500.00 0.00
Purchase 06/14/2017 31846V203 14,062.50 First American Govt Obligation Fund 1.000 0.38 %14,062.50 0.00 14,062.50 0.00
Purchase 06/15/2017 31846V203 1,660.67 First American Govt Obligation Fund 1.000 0.38 %1,660.67 0.00 1,660.67 0.00
Purchase 06/15/2017 31846V203 932.46 First American Govt Obligation Fund 1.000 0.38 %932.46 0.00 932.46 0.00
Purchase 06/15/2017 31846V203 29,642.36 First American Govt Obligation Fund 1.000 0.38 %29,642.36 0.00 29,642.36 0.00
Purchase 06/15/2017 31846V203 818.75 First American Govt Obligation Fund 1.000 0.38 %818.75 0.00 818.75 0.00
Purchase 06/15/2017 31846V203 1,263.67 First American Govt Obligation Fund 1.000 0.38 %1,263.67 0.00 1,263.67 0.00
Purchase 06/15/2017 31846V203 109,892.40 First American Govt Obligation Fund 1.000 0.38 %109,892.40 0.00 109,892.40 0.00
Purchase 06/15/2017 31846V203 771.75 First American Govt Obligation Fund 1.000 0.38 %771.75 0.00 771.75 0.00
Purchase 06/15/2017 31846V203 81,730.15 First American Govt Obligation Fund 1.000 0.38 %81,730.15 0.00 81,730.15 0.00
Purchase 06/15/2017 31846V203 88,831.34 First American Govt Obligation Fund 1.000 0.38 %88,831.34 0.00 88,831.34 0.00
Purchase 06/15/2017 31846V203 60,553.17 First American Govt Obligation Fund 1.000 0.38 %60,553.17 0.00 60,553.17 0.00
Purchase 06/19/2017 31846V203 103,358.78 First American Govt Obligation Fund 1.000 0.38 %103,358.78 0.00 103,358.78 0.00
Purchase 06/20/2017 313378CR0 2,000,000.00 FHLB Note
2.25% Due 3/11/2022
101.764 1.86 %2,035,280.00 12,375.00 2,047,655.00 0.00
Purchase 06/20/2017 31846V203 34,520.32 First American Govt Obligation Fund 1.000 0.38 %34,520.32 0.00 34,520.32 0.00
Purchase 06/21/2017 31846V203 94,218.16 First American Govt Obligation Fund 1.000 0.38 %94,218.16 0.00 94,218.16 0.00
Purchase 06/21/2017 31846V203 1,029.50 First American Govt Obligation Fund 1.000 0.38 %1,029.50 0.00 1,029.50 0.00
Purchase 06/24/2017 31846V203 15,032.50 First American Govt Obligation Fund 1.000 0.38 %15,032.50 0.00 15,032.50 0.00
Purchase 06/29/2017 912828XR6 1,500,000.00 US Treasury Note
1.75% Due 5/31/2022
99.735 1.81 %1,496,020.65 2,079.92 1,498,100.57 0.00
Purchase 06/30/2017 31846V203 24,375.00 First American Govt Obligation Fund 1.000 0.57 %24,375.00 0.00 24,375.00 0.00
Purchase 06/30/2017 90CAMP$00 29,980.44 Public Financial Management CAMP 1.000 1.09 %29,980.44 0.00 29,980.44 0.00
Subtotal 5,853,842.42 5,885,143.07 14,454.92 5,899,597.99 0.00
TOTAL ACQUISITIONS 5,853,842.42 5,885,143.07 14,454.92 5,899,597.99 0.00
Execution Time: 7/12/2017 9:09:17 AMChandler Asset Management - CONFIDENTIAL Page 8
Attachment 2
Transaction Ledger
5/31/17 Thru 6/30/17
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
Sale 06/20/2017 31846V203 2,047,655.00 First American Govt Obligation Fund 1.000 0.38 %2,047,655.00 0.00 2,047,655.00 0.00
Sale 06/29/2017 31846V203 1,498,100.57 First American Govt Obligation Fund 1.000 0.38 %1,498,100.57 0.00 1,498,100.57 0.00
Subtotal 3,545,755.57 3,545,755.57 0.00 3,545,755.57 0.00
Paydown 06/15/2017 161571HH0 0.00 Chase CHAIT Pool #2016-A7
1.06% Due 9/16/2019
100.000 0.00 1,660.67 1,660.67 0.00
Paydown 06/15/2017 43814QAC2 0.00 Honda Auto Receivables 2016-2 A3
1.39% Due 4/15/2020
100.000 0.00 932.46 932.46 0.00
Paydown 06/15/2017 47787VAC5 29,607.51 John Deere Owner Trust 2014-A A3
0.92% Due 4/16/2018
100.000 29,607.51 34.85 29,642.36 0.00
Paydown 06/15/2017 47787XAB3 0.00 John Deere Owner Trust 2017-A A2
1.5% Due 10/15/2019
100.000 0.00 818.75 818.75 0.00
Paydown 06/15/2017 47788MAC4 0.00 John Deere Owner Trust 2016-A A3
1.36% Due 4/15/2020
100.000 0.00 1,263.67 1,263.67 0.00
Paydown 06/15/2017 47788NAB4 108,844.67 John Deere Owner Trust 2016-B A2
1.09% Due 2/15/2019
100.000 108,844.67 1,047.73 109,892.40 0.00
Paydown 06/15/2017 654747AB0 0.00 Nissan Auto Receivables 2017-A A2A
1.47% Due 1/15/2020
100.000 0.00 771.75 771.75 0.00
Paydown 06/15/2017 65478WAB1 80,996.13 Nissan Auto Receivables Owner 2016-C
A2A
1.07% Due 5/15/2019
100.000 80,996.13 734.02 81,730.15 0.00
Paydown 06/15/2017 89231LAB3 87,758.09 Toyota Auto Receivables Owner 2016-D
1.06% Due 5/15/2019
100.000 87,758.09 1,073.25 88,831.34 0.00
Paydown 06/15/2017 89236WAC2 60,080.99 Toyota Auto Receivables Owner 2015-A
1.12% Due 2/15/2019
100.000 60,080.99 472.18 60,553.17 0.00
Paydown 06/19/2017 43814NAB1 103,047.30 Honda Auto Receivables 2016-1 A2
1.01% Due 6/18/2018
100.000 103,047.30 311.48 103,358.78 0.00
Paydown 06/20/2017 43814GAC4 34,489.51 Honda Auto Receivables 2014-2 A3
0.77% Due 3/19/2018
100.000 34,489.51 30.81 34,520.32 0.00
Paydown 06/21/2017 43813NAC0 93,484.13 Honda Auto Receivables 2015-2 A3
1.04% Due 2/21/2019
100.000 93,484.13 734.03 94,218.16 0.00
Paydown 06/21/2017 43814TAB8 0.00 Honda Auto Receivables 2017-1 A2
1.42% Due 7/22/2019
100.000 0.00 1,029.50 1,029.50 0.00
Subtotal 598,308.33 598,308.33 10,915.15 609,223.48 0.00
Maturity 06/01/2017 913017BU2 1,600,000.00 United Tech Corp Note
1.8% Due 6/1/2017
100.000 1,600,000.00 0.00 1,600,000.00 0.00
Subtotal 1,600,000.00 1,600,000.00 0.00 1,600,000.00 0.00
Execution Time: 7/12/2017 9:09:17 AMChandler Asset Management - CONFIDENTIAL Page 9
Attachment 2
Transaction Ledger
5/31/17 Thru 6/30/17
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
06/02/2017 90CAMP$00 2,500,000.00 Public Financial Management CAMP 1.000 2,500,000.00 0.00 2,500,000.00 0.00
Security
Withdrawal
06/09/2017 90CAMP$00 3,300,000.00 Public Financial Management CAMP 1.000 3,300,000.00 0.00 3,300,000.00 0.00
Security
Withdrawal
06/26/2017 31846V203 104.17 First American Govt Obligation Fund 1.000 104.17 0.00 104.17 0.00
Security
Withdrawal
06/27/2017 90CAMP$00 1,000,000.00 Public Financial Management CAMP 1.000 1,000,000.00 0.00 1,000,000.00 0.00
Subtotal 6,800,104.17 6,800,104.17 0.00 6,800,104.17 0.00
TOTAL DISPOSITIONS 12,544,168.07 12,544,168.07 10,915.15 12,555,083.22 0.00
OTHER TRANSACTIONS
Interest 06/01/2017 913017BU2 1,600,000.00 United Tech Corp Note
1.8% Due 6/1/2017
0.000 14,400.00 0.00 14,400.00 0.00
Interest 06/08/2017 313379DT3 2,000,000.00 FHLB Note
1.25% Due 6/8/2018
0.000 12,500.00 0.00 12,500.00 0.00
Interest 06/08/2017 313381B20 4,000,000.00 FHLB Note
0.75% Due 12/8/2017
0.000 15,000.00 0.00 15,000.00 0.00
Interest 06/12/2017 313383HU8 2,000,000.00 FHLB Note
1.75% Due 6/12/2020
0.000 17,500.00 0.00 17,500.00 0.00
Interest 06/14/2017 3135G0G72 2,500,000.00 FNMA Note
1.125% Due 12/14/2018
0.000 14,062.50 0.00 14,062.50 0.00
Interest 06/24/2017 166764AE0 1,750,000.00 Chevron Corp Callable Note Cont 5/24/2018
1.718% Due 6/24/2018
0.000 15,032.50 0.00 15,032.50 0.00
Interest 06/30/2017 912828G95 3,000,000.00 US Treasury Note
1.625% Due 12/31/2019
0.000 24,375.00 0.00 24,375.00 0.00
Subtotal 16,850,000.00 112,870.00 0.00 112,870.00 0.00
Dividend 06/01/2017 31846V203 3,273,320.68 First American Govt Obligation Fund 0.000 1,768.50 0.00 1,768.50 0.00
Dividend 06/30/2017 90CAMP$00 32,908,049.35 Public Financial Management CAMP 0.000 29,980.44 0.00 29,980.44 0.00
Subtotal 36,181,370.03 31,748.94 0.00 31,748.94 0.00
TOTAL OTHER TRANSACTIONS 53,031,370.03 144,618.94 0.00 144,618.94 0.00
Execution Time: 7/12/2017 9:09:17 AMChandler Asset Management - CONFIDENTIAL Page 10
Attachment 2