HomeMy WebLinkAbout4.4 - 1722 Q1 Investment Report - 2018
Page 1 of 5
STAFF REPORT
CITY COUNCIL
DATE: December 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 September 30, 2017
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, 2017 including a monthly transaction ledger. The
City’s investment por tfolio for this period totaled $218,372,564 (book value) with an
average market yield of 1.51%. 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 November 7, 2017, the City Council approved as part of the First Quarter Budget
Review, a budget adjustment of $450,000, to account for additional projected interest
revenue. This report does not include an additional adjustment to the budget for interest
revenue.
DESCRIPTION:
The total investment portfolio of $218,372,564 (book value) is comprised of
$158,285,369 managed by Chandler Asset Management (Chandler), and $60,087,195
invested by the City in local government pools. The average market yield of the
Chandler portfolio and the local pools was 1.66% and 1.13% respectively. The total
investment portfolio balance fluctuates throughout the year due to normal cash flow
Page 2 of 5
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) left the fed funds target rate unchanged
at a range of 1.00% - 1.25% at the September meeting. The Federal Reserve’s (Fed)
updated economic projections still indicate one more rate hike before the year end,
however, the Fed lowered its median longer-run fed funds rate projection to 2.8% from
3.0% The Fed’s other economic projections were little changed, although the median
2018 inflation forecast was lowered slightly, suggesting the FOMC now thinks inflation
may remain below the Fed’s 2.0% target until 2019.
Gross Domestic Product (GDP) grew by 3.0% in the third quarter, following growth of
3.1% in the second quarter and 1.2% in the first quarter. The consensus forecast
currently calls for GDP growth of about 2.7% in the current quarter. Tax reform or fiscal
stimulus may ultimately help fuel even stronger economic growth, but the timing and
magnitude of such programs remains uncertain.
The Treasury yield curve steepened in September, partially reversing some of the
curve flattening that has happened year-to-date. The 2-year Treasury yield increased
16 basis points in September to 1.48% and the 10-year Treasury yield increased 22
basis points to 2.33%. On a year-to-date basis, the 2-year Treasury yield increased 29
basis points and the 10-year Treasury yield declined 11 basis points.
City of Dublin Portfolio
The City's portfolio managed by Chandler has maintained a healthy balance of
investment types. As illustrated in Chart 1 below, the City utilized a large portion ($10
million) of funds held in the Local Government Investment Pools to meet cash flow
needs. This leaves overall funding levels with Chandler relatively unchanged, giving the
City the opportunity to earn a higher rate of return on the majority of its funds.
Page 3 of 5
Chart 1: Investments by Type, June 30, 2017 - September 30, 2017
The market value of the City's portfolio decreased $12.3 million since June 30, 2017
(see Table 1 below), but increased $10.1 million from the same quarter the prior year.
The quarter-over-quarter decrease in the City’s cash balance was due to large
payments made for two of the City’s Capital Improvement Projects (Dougherty Road
Improvements and Fallon Sports Park Phase II).
Table 1: Portfolio Values and Yield to Maturity
Page 4 of 5
Overall market yield-to-maturity (YTM) increased from 1.44% to 1.51%, 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 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 pla ce. As shown in
Table 3, the quarterly LAIF yield continues to increase, signifying the relative health of
the current economic climate.
Table 3: Quarterly LAIF Yields, Recent Seven Years and Three Quarters
NOTICING REQUIREMENTS/PUBLIC OUTREACH:
None.
ATTACHMENTS:
1. City of Dublin Investment Report for Period Ending September 2017
2. Transaction Ledger - July - September 2017
Page 5 of 5
6225 Lusk Blvd | San Diego, CA 92121 | Phone 800.317.4747 | Fax 858.546.3741 | www.chandlerasset.com
CHANDLER ASSET MANAGEMENT
Period Ending
September 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
GDPgrew by 3.0%in thethirdquarter,followinggrowth of 3.1%in thesecondquarter and 1.2%in thefirstquarter.
TheconsensusforecastcurrentlycallsforGDPgrowth ofabout 2.7%in thecurrentquarter.Taxreform or fiscal
stimulusmayultimatelyhelpfuelevenstrongereconomicgrowth,but thetiming and magnitude of suchprograms
remains uncertain.
Economic Update
TheTreasuryyieldcurvesteepened in September,partiallyreversingsome of thecurveflatteningthat hashappened
year-to-date.The2-yearTreasuryyieldincreased 16 basispoints in September to 1.48%and the10-yearTreasury
yieldincreased about22 basispoints to 2.33%.On ayear-to-datebasis,the2-yearTreasuryyieldincreased 29 basis
points and the10-yearTreasuryyielddeclined 11 basispoints.Sincethebeginning of thisyear,we believemarket
participantshavegrownskepticalthattheTrumpadministrationwilldeliver on many of theirlegislativeobjectives.
However,theadministrationrecentlyoutlinedageneralframeworkfortaxreform,sparkingsomerenewedoptimism
that changes to the tax code may help boost economic growth.
The Federal Open Market Committee (FOMC) left the fed funds target rate unchanged at a range of 1.00%-1.25% at
the September 19-20 meeting. As expected, the Committee announced plans to initiate the balance sheet
normalization program in October. The process of unwinding the Fed’s $4.5 trillion balance sheet will begin gradually
by allowing $6 billion per month in Treasury securities and $4 billion per month in mortgage-backed and agency
securities to roll off the balance sheet. Over time, the amounts will slowly increase to $30 billion per month in Treasury
securities and $20 billion per month in mortgage-backed and agency securities. The Fed’s plans to unwind the
balance sheet was widely telegraphed and the policy statement was generally in line with expectations. There were no
dissenting votes among FOMC members in September. The Fed’s updated economic projections still indicate one
more rate hike before year-end is expected. However, the Fed lowered its median longer-run fed funds rate projection
to 2.8% from 3.0%. The Fed’s other economic projections were little changed, although the median 2018 inflation
forecast was lowered slightly, suggesting that the Committee now thinks inflation may remain below the Fed’s 2.0%
target until 2019.
3
Attachment 1
U.S.payrollsdeclined33,000 in September,wellbelowthe+80,000consensusestimate.However,Septemberpayrollswerelikely
significantlydistorted by thehurricanes.Theunemploymentratedecreased to 4.2%in Septemberfrom4.4%in August,and thelabor
participationrateincreased to 63.1%from62.9%.Abroadermeasure of unemploymentcalledtheU-6,whichincludesthosewhoare
marginallyattached to thelaborforce and employedparttimeforeconomicreasons,declined to 8.3%from8.6%.Wagesjumped0.5%
in September. On a year-over-year basis wages were up 2.9% in September, versus up 2.7% year-over-year in August.
Employment
Source: US Department of Labor Source: US Department of Labor
-100
-50
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)
3.0%
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 2.2%year-over-year in September,versus up 1.9%year-over-year in August.CoreCPI(CPI
lessfood and energy)was up just1.7%year-over-year in September,unchangedforthepastfiveconsecutivemonths.Theincrease in
headlineCPIinflationwasdriven in part byan increase in energypricesfollowingthehurricanes.ThePersonalConsumption
Expenditures(PCE)indexwas up 1.6%year-over-year in September,versus up 1.4%year-over-year in August.However,CorePCE
(excludingfood and energy)wasunchanged on ayear-over-yearbasis in September,up just1.3%.InflationremainsbelowtheFed's
2.0% 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,retailsaleswere up 4.4%in September,versus up 3.5%year-over-year in August.On amonth-over-month
basis,retailsalesincreased1.6%in September,followinga0.1%decline in August.Theincrease in Septemberretailsaleswas
generally in linewithexpectations,and wasdriven in largepart by asurge in hurricane-relatedreplacementdemandforvehicles as well
as aspike in post-hurricanegasolineprices.However,excludingautos and gas,retailsalesgrew at amoderatepace,up 0.5%in
September,month-over-month.Meanwhile,theconsumerconfidenceindexremainedstrong in September at 119.8versus120.4 in
August, despite weakness in the hurricane states of Texas and Florida.
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
TheIndex of LeadingEconomicIndicators(LEI)declined0.2%in September,followinga0.4%increase in August and a0.3%increase
in July.It wasthefirstmonthlydecline in morethanayear.However,six of thetenindexcomponentsmadepositivecontributions,and
thosethatmadenegativecontributionswerelikelydistorted by thehurricanes.On ayear-over-yearbasis,theLEIwas up 4.0%in
September,versus up 4.4%in August.According to theConferenceBoard,“the trend in the US LEIremainsconsistentwithcontinuing
solid growth in the US economy for the second half of the year.” Meanwhile, the Chicago Fed National Activity Index (CFNAI) improved in
September to 0.17from-0.37 in August.However,on a3-monthmovingaveragebasis,theindexheld at -0.16 in September.Thethree
monthmovingaverage,whichsmooths out some of themonthlyvolatility,points to subpareconomicgrowth.Overall,we believethe
economy remains on a slow growth trajectory.
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
Totalhousingstartswereweakerthanexpected in September,down4.7%.Single-familystartsdecreased4.6%in September,while
multi-familystartsdeclined5.1%.Permitswerealsoslightlyweakerthanexpected in September,down4.5%,due to weakness in multi-
familypermits.Overall,Septemberhousingstartsweresoft,but activitymayrebound in thefourthquarter as hurricane-related
rebuildingeffortsintensify.According to theCase-Shiller20-Cityhomepriceindex,homepriceswere up 5.8%year-over-year in July,
versus up 5.6% year-over-year in June.
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 60.8 in Septemberfrom58.0 in August.Areadingabove
50.0suggeststhemanufacturingsector is expanding.However,IndustrialProductionwas up just1.6%year-over-year in September
versus up 1.2%year-over-year in August.AlthoughtheISMManufacturingindex(which is based on asurveyfromarelativelysmall
sample size of roughly 300 manufacturing firms) has been quite strong, Industrial Production has been lackluster.
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
-4.0%
-3.0%
-2.0%
-1.0%
0.0%
1.0%
2.0%
3.0%
Industrial Production
YO
Y
(
%
)
C
h
a
n
g
e
9
Attachment 1
ThirdquarterGDPgrew at abetterthanexpectedannualizedrate of 3.0%.An increase in inventoriesboostedthirdquartereconomic
growth,whichmayreverse in thefourthquarter.Nevertheless,thethirdquarterGDPreportwassolid,withmuch of thegrowthdriven
by personalconsumptionexpenditures.Spending on durable goods wasparticularlystrong in thequarter,whichmayreflecthurricane-
related demand for replacement vehicles.
Gross Domestic Product (GDP)
Source: US Department of Commerce Source: US Department of Commerce
12/163/176/179/17
2.0%1.3%2.2%1.6%
1.3%-0.2%0.6%1.0%
-1.6%0.2%0.2%0.4%
0.0%-0.2%0.1%0.1%
0.1%0.1%-0.2%-0.1%
1.8%1.2%3.1%3.0%
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
The yield curve has flattened meaningfully this year. The spread between 2-year and 10-year Treasury yields was just 85 basis points at
the endof September,compared to 126at the endof2016.In thethreemonthsending in September,the2-yearTreasuryyield
increased about tenbasispointswhilethe10-yearTreasuryyieldincreasedjustthreebasispoints.Immediatelyfollowingthe US
Presidentialelectionlastfall,theTreasuryyieldcurvesteepenedmeaningfully,driven by heightenedexpectationsfortaxreform,fiscal
stimulus,and above-trendeconomicgrowth under theTrumpadministration.However,marketparticipantsareskepticaltheTrump
administration will deliver on their legislative agenda.
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
Sep-17
Jun-17
Sep-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
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, 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
9/30/2017 6/30/2017
Benchmark* Portfolio Portfolio
Average Maturity (yrs) 2.69 2.57 2.65
Modified Duration 2.58 2.41 2.45
Average Purchase Yield n/a 1.60% 1.54%
Average Market Yield 1.61% 1.66% 1.62%
Average Quality** AAA AA/Aa1 AA/Aa1
Total Market Value 158,631,241 158,015,885
*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
5.1%
Agency
36.8%
Commercial
Paper
2.0%
Money Market
Fund FI
0.2%
US Corporate
22.4%
US Treasury
31.8%
Negotiable CD
1.8%
Sector Distribution
City of Dublin
September 30, 2017 June 30, 2017
ABS
6.6%
Agency
37.6%
Commercial
Paper
1.9% Money Market
Fund FI
0.3%
US Corporate
22.4%
US Treasury
31.3%
16
Attachment 1
Issuers
City of Dublin – Account #10198 As of 9/30/2017
Issue Name Investment Type % Portfolio
Government of United States US Treasury 31.77%
Federal National Mortgage Association Agency 15.90%
Federal Home Loan Bank Agency 14.96%
Federal Home Loan Mortgage Corp Agency 5.95%
John Deere ABS ABS 2.05%
Bank of Tokyo-Mit UFJ Commercial Paper 1.99%
Bank of Nova Scotia Houston Negotiable CD 1.75%
Pepsico Inc US Corporate 1.75%
ChevronTexaco Corp US Corporate 1.74%
Honda ABS ABS 1.61%
US Bancorp US Corporate 1.28%
Qualcomm Inc US Corporate 1.28%
Chubb Corporation US Corporate 1.28%
Wells Fargo Corp US Corporate 1.22%
Microsoft US Corporate 1.15%
Honda Motor Corporation US Corporate 1.15%
JP Morgan Chase & Co US Corporate 1.15%
Exxon Mobil Corp US Corporate 1.15%
State Street Bank US Corporate 1.14%
Deere & Company US Corporate 1.12%
Bank of New York US Corporate 1.11%
Apple Inc US Corporate 1.11%
Eli Lilly & Co US Corporate 1.00%
HSBC USA Corp US Corporate 0.96%
Cisco Systems US Corporate 0.86%
Oracle Corp US Corporate 0.81%
Nissan ABS ABS 0.73%
Toyota ABS ABS 0.70%
Berkshire Hathaway US Corporate 0.64%
General Electric Co US Corporate 0.48%
17
Attachment 1
Issuers
City of Dublin – Account #10198 As of 9/30/2017
Issue Name Investment Type % Portfolio
First American Govt Oblig Fund Money Market Fund FI 0.23%
Total 100.00%
18
Attachment 1
AAA AA A <A NR
09/30/17 2.7% 80.1% 13.4% 0.0% 3.8%
06/30/17 4.3% 78.5% 13.5% 0.0% 3.7%
Source: S&P Ratings
Quality Distribution
September 30, 2017 vs. June 30, 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
9/30/2017 6/30/2017
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 BAML 1-5 Yr US Treasury/Agency Index
Duration Distribution
City of Dublin
Portfolio Compared to the Benchmark as of September 30, 2017
0 - 0.25 0.25 - 0.50 0.50 - 1 1 - 2 2 - 3 3 - 4 4 - 5 5+
Portfolio 4.6% 7.8% 10.5% 15.6% 23.2% 23.4% 14.9% 0.0%
Benchmark* 0.1% 0.0% 1.7% 32.7% 28.4% 22.4% 14.8% 0.0%
*BAML 1-5 Yr US Treasury/Agency Index
20
Attachment 1
Investment Performance
-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
September 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.39% 0.43% 1.11% 1.30% N/A N/A 1.12%
BAML 1-5 Yr US Treasury/Agency Index 0.29% -0.04% 0.74% 1.09% N/A N/A 0.94%
*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/2017 6/30/2017
Portfolio Portfolio
Average Maturity (yrs) 0.00 0.00
Modified Duration 0.00 0.00
Average Purchase Yield 1.13% 1.05%
Average Market Yield 1.13% 1.05%
Average Quality AAA/NR NR/NR
Total Market Value 60,197,021 73,109,353
22
Attachment 1
LAIF
66.9%
Local Gov
Investment Pool
33.1%
Sector Distribution
City of Dublin Reporting Account
September 30, 2017 June 30, 2017
LAIF
55.0%
Local Gov
Investment Pool
45.1%
23
Attachment 1
Issuers
City of Dublin Reporting Account – Account #10219 As of 9/30/2017
Issue Name Investment Type % Portfolio
Local Agency Investment Fund LAIF 66.92%
CAMP Local Gov Investment Pool 33.08%
Total 100.00%
24
Attachment 1
SECTION 3
Consolidated Information
25
Attachment 1
Portfolio Characteristics
City of Dublin Consolidated
9/30/2017 6/30/2017
Portfolio Portfolio
Average Maturity (yrs) 1.87 1.81
Modified Duration 1.74 1.67
Average Purchase Yield 1.47% 1.39%
Average Market Yield 1.51% 1.44%
Average Quality AA+/Aa1 AA/Aa1
Total Market Value 218,828,262 231,125,238
26
Attachment 1
ABS
3.7%
Agency
26.7%
Commercial
Paper
1.4%
LAIF
18.4% Local Gov
Investment Pool
9.1%
Money Market
Fund FI
0.2%
US Corporate
16.2%
US Treasury
23.0%
Negotiable CD
1.3%
Sector Distribution
City of Dublin Consolidated
September 30, 2017 June 30, 2017
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%
27
Attachment 1
SECTION 4
Portfolio Holdings
28
Attachment 1
Holdings Report
For the Month Ending 9/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
89236WAC2 Toyota Auto Receivables Owner 2015-A
1.120% Due 02/15/2019
287,924.78 02/24/2015
0.60%
287,881.25
287,919.25
99.94
1.36%
287,759.07
143.32
0.18%
(160.18)
Aaa / AAA
NR
1.38
0.25
47788NAB4 John Deere Owner Trust 2016-B A2
1.090% Due 02/15/2019
704,478.82 07/19/2016
0.91%
704,435.85
704,455.70
99.94
1.40%
704,034.94
341.28
0.44%
(420.76)
Aaa / NR
AAA
1.38
0.20
43813NAC0 Honda Auto Receivables 2015-2 A3
1.040% Due 02/21/2019
491,259.05 05/13/2015
0.36%
491,183.64
491,231.15
99.89
1.45%
490,708.20
141.92
0.31%
(522.95)
NR / AAA
AAA
1.39
0.28
65478WAB1 Nissan Auto Receivables Owner 2016-C A2A
1.070% Due 05/15/2019
520,510.52 08/02/2016
0.83%
520,490.02
520,498.50
99.91
1.37%
520,054.82
247.53
0.33%
(443.68)
Aaa / NR
AAA
1.62
0.30
89231LAB3 Toyota Auto Receivables Owner 2016-D
1.060% Due 05/15/2019
821,316.81 10/04/2016
0.87%
821,251.10
821,275.72
99.88
1.39%
820,370.50
386.93
0.52%
(905.22)
Aaa / AAA
NR
1.62
0.35
43814TAB8 Honda Auto Receivables 2017-1 A2
1.420% Due 07/22/2019
807,014.91 03/21/2017
1.28%
806,995.63
806,999.89
99.96
1.50%
806,708.20
318.32
0.51%
(291.69)
Aaa / NR
AAA
1.81
0.53
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.96
99.96
1.56%
654,757.00
436.67
0.41%
(240.96)
Aaa / NR
AAA
2.04
0.63
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.38
99.97
1.52%
629,830.53
411.60
0.40%
(166.85)
Aaa / NR
AAA
2.29
0.65
43814PAB6 Honda Auto Receivables Owner T 17-3 A2
1.570% Due 01/21/2020
460,000.00 09/25/2017
1.58%
459,959.11
459,959.21
99.99
1.58%
459,969.64
40.12
0.29%
10.43
NR / AAA
AAA
2.31
0.89
47788MAC4 John Deere Owner Trust 2016-A A3
1.360% Due 04/15/2020
1,115,000.00 02/23/2016
1.12%
1,114,824.50
1,114,891.90
99.83
1.60%
1,113,076.63
673.96
0.70%
(1,815.27)
Aaa / NR
AAA
2.54
0.73
43814QAC2 Honda Auto Receivables 2016-2 A3
1.390% Due 04/15/2020
805,000.00 05/24/2016
1.24%
804,984.38
804,989.77
99.81
1.61%
803,479.36
497.31
0.51%
(1,510.41)
Aaa / NR
AAA
2.54
0.87
47788BAB0 John Deere Owner Trust 2017-B A2A
1.590% Due 04/15/2020
455,000.00 07/11/2017
1.60%
454,960.46
454,963.42
99.94
1.66%
454,740.20
321.53
0.29%
(223.22)
Aaa / NR
AAA
2.54
0.92
47788BAD6 John Deere Owner Trust 2017-B A3
1.820% Due 10/15/2021
320,000.00 07/11/2017
1.83%
319,976.58
319,977.71
99.93
1.86%
319,789.44
258.84
0.20%
(188.27)
Aaa / NR
AAA
4.04
2.12
Total ABS 8,072,504.89 1.16%
8,071,936.69
8,072,157.56
1.52%
8,065,278.53
4,219.33
5.09%
(6,879.03)
Aaa / AAA
Aaa
2.09
0.63
Agency
313381B20 FHLB Note
0.750% Due 12/08/2017
2,000,000.00 12/13/2012
0.75%
1,999,980.00
1,999,999.25
99.94
1.08%
1,998,732.00
4,708.33
1.26%
(1,267.25)
Aaa / AA+
AAA
0.19
0.19
3135G0TG8 FNMA Note
0.875% Due 02/08/2018
3,000,000.00 01/21/2015
0.97%
2,991,390.00
2,998,994.34
99.87
1.25%
2,996,022.00
3,864.58
1.89%
(2,972.34)
Aaa / AA+
AAA
0.36
0.35
3137EADP1 FHLMC Note
0.875% Due 03/07/2018
3,000,000.00 01/27/2015
1.01%
2,987,610.00
2,998,284.63
99.86
1.20%
2,995,734.00
1,750.00
1.89%
(2,550.63)
Aaa / AA+
AAA
0.43
0.43
313378A43 FHLB Note
1.375% Due 03/09/2018
4,000,000.00 Various
0.96%
4,047,840.00
4,007,192.87
100.09
1.18%
4,003,492.00
3,361.12
2.53%
(3,700.87)
Aaa / AA+
AAA
0.44
0.44
313379DT3 FHLB Note
1.250% Due 06/08/2018
2,000,000.00 08/18/2015
1.12%
2,007,360.00
2,001,796.88
99.97
1.29%
1,999,490.00
7,847.22
1.27%
(2,306.88)
Aaa / AA+
AAA
0.69
0.68
City of Dublin - Account #10198
29
Attachment 1
Holdings Report
For the Month Ending 9/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
3135G0G72 FNMA Note
1.125% Due 12/14/2018
2,500,000.00 12/18/2015
1.37%
2,481,975.00
2,492,733.72
99.65
1.42%
2,491,312.50
8,359.38
1.58%
(1,421.22)
Aaa / AA+
AAA
1.21
1.19
3133782M2 FHLB Note
1.500% Due 03/08/2019
2,750,000.00 04/24/2015
1.21%
2,779,892.50
2,761,079.93
100.04
1.47%
2,751,168.75
2,635.42
1.74%
(9,911.18)
Aaa / AA+
AAA
1.44
1.42
3137EADG1 FHLMC Note
1.750% Due 05/30/2019
1,000,000.00 01/29/2015
1.28%
1,019,690.00
1,007,547.21
100.43
1.48%
1,004,345.00
5,881.94
0.64%
(3,202.21)
Aaa / AA+
AAA
1.66
1.63
3135G0ZG1 FNMA Note
1.750% Due 09/12/2019
2,500,000.00 10/28/2014
1.68%
2,508,350.00
2,503,337.18
100.42
1.53%
2,510,600.00
2,309.03
1.58%
7,262.82
Aaa / AA+
AAA
1.95
1.91
3137EADM8 FHLMC Note
1.250% Due 10/02/2019
2,500,000.00 12/18/2015
1.64%
2,464,700.00
2,481,314.77
99.43
1.54%
2,485,680.00
15,538.19
1.58%
4,365.23
Aaa / AA+
AAA
2.01
1.96
3135G0A78 FNMA Note
1.625% Due 01/21/2020
2,000,000.00 04/07/2015
1.44%
2,016,580.00
2,007,981.91
100.13
1.57%
2,002,522.00
6,319.44
1.27%
(5,459.91)
Aaa / AA+
AAA
2.31
2.25
313383HU8 FHLB Note
1.750% Due 06/12/2020
2,000,000.00 10/08/2015
1.46%
2,026,040.00
2,015,017.21
100.17
1.69%
2,003,316.00
10,597.22
1.27%
(11,701.21)
Aaa / AA+
NR
2.70
2.61
3135G0F73 FNMA Note
1.500% Due 11/30/2020
2,500,000.00 12/04/2015
1.87%
2,455,750.00
2,471,893.96
99.33
1.72%
2,483,242.50
12,604.17
1.57%
11,348.54
Aaa / AA+
AAA
3.17
3.06
3130A7CV5 FHLB Note
1.375% Due 02/18/2021
3,470,000.00 Various
1.45%
3,457,221.20
3,461,310.33
98.97
1.69%
3,434,137.55
5,698.99
2.17%
(27,172.78)
Aaa / AA+
AAA
3.39
3.28
3135G0J20 FNMA Note
1.375% Due 02/26/2021
5,000,000.00 Various
1.29%
5,018,675.00
5,013,826.16
98.77
1.75%
4,938,440.00
6,684.02
3.12%
(75,386.16)
Aaa / AA+
AAA
3.41
3.31
313379RB7 FHLB Note
1.875% Due 06/11/2021
3,000,000.00 08/30/2017
1.67%
3,022,620.00
3,022,111.87
100.30
1.79%
3,009,039.00
17,187.50
1.91%
(13,072.87)
Aaa / AA+
AAA
3.70
3.54
3130A8QS5 FHLB Note
1.125% Due 07/14/2021
2,500,000.00 07/25/2016
1.28%
2,481,475.00
2,485,886.69
97.69
1.76%
2,442,170.00
6,015.63
1.54%
(43,716.69)
Aaa / AA+
AAA
3.79
3.68
3137EAEC9 FHLMC Note
1.125% Due 08/12/2021
3,000,000.00 Various
1.33%
2,971,215.00
2,977,435.43
97.46
1.81%
2,923,752.00
4,593.76
1.85%
(53,683.43)
Aaa / AA+
AAA
3.87
3.75
3135G0Q89 FNMA Note
1.375% Due 10/07/2021
2,000,000.00 10/06/2016
1.45%
1,992,924.00
1,994,315.17
98.11
1.86%
1,962,250.00
13,291.67
1.25%
(32,065.17)
Aaa / AA+
AAA
4.02
3.86
3135G0S38 FNMA Note
2.000% Due 01/05/2022
2,500,000.00 01/30/2017
2.04%
2,495,475.00
2,496,085.88
100.25
1.94%
2,506,352.50
11,944.44
1.59%
10,266.62
Aaa / AA+
AAA
4.27
4.05
313378CR0 FHLB Note
2.250% Due 03/11/2022
2,000,000.00 06/19/2017
1.86%
2,035,280.00
2,033,173.43
101.31
1.94%
2,026,106.00
2,500.00
1.28%
(7,067.43)
Aaa / AA+
NR
4.45
4.21
3135G0T45 FNMA Note
1.875% Due 04/05/2022
3,250,000.00 05/05/2017
1.99%
3,232,125.00
3,233,580.52
99.77
1.93%
3,242,606.25
28,945.31
2.06%
9,025.73
Aaa / AA+
AAA
4.52
4.27
Total Agency 58,470,000.00 1.41%
58,494,167.70
58,464,899.34
1.59%
58,210,510.05
182,637.36
36.81%
(254,389.29)
Aaa / AA+
Aaa
2.49
2.40
City of Dublin - Account #10198
30
Attachment 1
Holdings Report
For the Month Ending 9/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
06538BY80 Bank of Tokyo Mitsubishi NY Discount CP
1.330% Due 11/08/2017
3,160,000.00 07/07/2017
1.35%
3,145,523.69
3,155,563.71
99.86
1.35%
3,155,563.71
0.00
1.99%
0.00
P-1 / A-1
NR
0.11
0.11
Total Commercial Paper 3,160,000.00 1.35%
3,145,523.69
3,155,563.71
1.35%
3,155,563.71
0.00
1.99%
0.00
P-1 / A-1
NR
0.11
0.11
Money Market Fund FI
31846V203 First American Govt Obligation Fund
367,387.22 Various
0.61%
367,387.22
367,387.22
1.00
0.61%
367,387.22
0.00
0.23%
0.00
Aaa / AAA
AAA
0.00
0.00
Total Money Market Fund FI 367,387.22 0.61%
367,387.22
367,387.22
0.61%
367,387.22
0.00
0.23%
0.00
Aaa / AAA
Aaa
0.00
0.00
Negotiable CD
06417GXH6 Bank of Nova Scotia Yankee CD
1.570% Due 08/09/2018
2,775,000.00 08/08/2017
1.57%
2,775,000.00
2,775,000.00
100.00
1.57%
2,775,000.00
6,414.10
1.75%
0.00
P-1 / A-1
NR
0.86
0.85
Total Negotiable CD 2,775,000.00 1.57%
2,775,000.00
2,775,000.00
1.57%
2,775,000.00
6,414.10
1.75%
0.00
Aaa / AA
NR
0.86
0.85
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,294.69
100.05
1.22%
750,387.75
4,366.67
0.48%
93.06
A1 / AA-
AA-
0.14
0.14
40428HPH9 HSBC USA Inc Note
1.625% Due 01/16/2018
500,000.00 11/25/2013
1.69%
498,705.00
499,908.30
100.04
1.49%
500,186.50
1,692.71
0.32%
278.20
A2 / A
AA-
0.30
0.29
713448CR7 PepsiCo Inc Note
1.250% Due 04/30/2018
1,430,000.00 Various
1.26%
1,429,428.40
1,429,889.87
99.92
1.39%
1,428,851.71
7,497.57
0.91%
(1,038.16)
A1 / A+
A
0.58
0.58
037833AJ9 Apple Inc Note
1.000% Due 05/03/2018
1,750,000.00 Various
1.34%
1,726,740.00
1,746,578.56
99.77
1.40%
1,745,905.00
7,194.44
1.11%
(673.56)
Aa1 / AA+
NR
0.59
0.59
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,751,867.34
100.08
1.59%
1,751,450.75
8,100.85
1.11%
(416.59)
Aa2 / AA-
NR
0.73
0.64
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,165.74
100.46
1.49%
1,004,570.00
3,500.00
0.64%
3,404.26
A1 / A
AA-
0.84
0.75
084664BY6 Berkshire Hathaway Note
2.000% Due 08/15/2018
1,000,000.00 12/12/2013
1.89%
1,004,960.00
1,000,926.72
100.49
1.43%
1,004,931.00
2,555.56
0.64%
4,004.28
Aa2 / AA
A+
0.87
0.86
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,341.50
100.75
1.58%
1,360,191.15
2,390.63
0.86%
8,849.65
A1 / AA-
NR
1.42
1.39
532457BF4 Eli Lilly & Co Note
1.950% Due 03/15/2019
1,575,000.00 Various
1.91%
1,577,796.75
1,575,944.76
100.49
1.61%
1,582,692.30
1,365.00
1.00%
6,747.54
A2 / AA-
A
1.45
1.43
94974BFU9 Wells Fargo Corp Note
2.125% Due 04/22/2019
1,900,000.00 Various
2.07%
1,904,120.50
1,901,630.81
100.55
1.77%
1,910,448.10
17,832.28
1.22%
8,817.29
A2 / A
AA-
1.56
1.52
02665WAH4 American Honda Finance Note
2.250% Due 08/15/2019
1,800,000.00 Various
2.08%
1,812,627.00
1,805,553.69
100.79
1.82%
1,814,283.00
5,175.00
1.15%
8,729.31
A1 / A+
NR
1.87
1.83
City of Dublin - Account #10198
31
Attachment 1
Holdings Report
For the Month Ending 9/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
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
756,379.44
100.78
1.87%
755,818.50
958.33
0.48%
(560.94)
A1 / A
AA-
1.95
1.82
68389XAX3 Oracle Corp Note
2.250% Due 10/08/2019
1,250,000.00 Various
1.73%
1,272,172.50
1,262,664.46
101.24
1.62%
1,265,498.75
13,515.63
0.81%
2,834.29
A1 / AA-
A+
2.02
1.95
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,032.92
100.71
2.03%
1,007,119.00
9,104.17
0.64%
6,086.08
A2 / A
AA-
2.12
2.04
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,795,196.12
100.54
2.00%
1,809,691.20
7,650.00
1.15%
14,495.08
A3 / A-
A+
2.32
2.16
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,609.12
100.08
1.82%
1,331,018.78
10,320.43
0.85%
1,409.66
A1 / A+
A
2.58
2.41
747525AD5 Qualcomm Inc Note
2.250% Due 05/20/2020
2,000,000.00 Various
2.22%
2,001,128.80
2,001,507.35
101.06
1.84%
2,021,180.00
16,375.01
1.28%
19,672.65
A1 / A
NR
2.64
2.53
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,018,364.04
100.88
2.05%
1,008,844.00
5,079.86
0.64%
(9,520.04)
A2 / A
A
2.79
2.68
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,002,946.03
100.73
2.05%
2,014,654.00
18,911.11
1.28%
11,707.97
A3 / A
A
3.10
2.87
24422ETF6 John Deere Capital Corp Note
2.550% Due 01/08/2021
750,000.00 Various
2.42%
753,733.15
753,017.26
101.27
2.14%
759,552.00
4,409.38
0.48%
6,534.74
A2 / A
A
3.28
3.11
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,809,333.87
100.76
1.99%
1,813,597.20
3,333.00
1.15%
4,263.33
Aaa / AA+
NR
3.42
3.27
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,169.62
100.05
2.09%
1,000,491.00
7,875.00
0.64%
321.38
Aa2 / AA-
NR
3.63
3.37
857477AV5 State Street Bank Note
1.950% Due 05/19/2021
1,800,000.00 Various
1.91%
1,802,989.00
1,802,419.17
99.33
2.14%
1,787,925.60
12,870.00
1.14%
(14,493.57)
A1 / A
AA-
3.64
3.47
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,244.90
98.23
2.03%
1,817,332.70
4,221.60
1.15%
(29,912.20)
Aaa / AAA
AA+
3.86
3.71
91159HHP8 US Bancorp Note
2.625% Due 01/24/2022
2,000,000.00 05/23/2017
2.36%
2,023,280.00
2,021,531.27
101.39
2.28%
2,027,878.00
9,770.83
1.28%
6,346.73
A1 / A+
AA
4.32
4.05
Total US Corporate 35,135,000.00 1.94%
35,258,345.85
35,216,517.55
1.82%
35,274,497.99
186,065.06
22.35%
57,980.44
A1 / A+
A+
2.23
2.12
US Treasury
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,108.25
100.09
1.43%
1,751,641.50
2,247.93
1.11%
1,533.25
Aaa / AA+
AAA
1.41
1.40
912828D80 US Treasury Note
1.625% Due 08/31/2019
3,000,000.00 Various
1.78%
2,977,822.56
2,991,439.68
100.28
1.48%
3,008,436.00
4,174.72
1.90%
16,996.32
Aaa / AA+
AAA
1.92
1.88
912828G61 US Treasury Note
1.500% Due 11/30/2019
4,500,000.00 Various
1.45%
4,507,600.72
4,504,291.83
99.98
1.51%
4,499,298.00
22,684.43
2.85%
(4,993.83)
Aaa / AA+
AAA
2.17
2.11
912828G95 US Treasury Note
1.625% Due 12/31/2019
3,000,000.00 01/08/2015
1.50%
3,017,470.99
3,007,911.57
100.22
1.52%
3,006,681.00
12,319.97
1.90%
(1,230.57)
Aaa / AA+
AAA
2.25
2.19
912828H52 US Treasury Note
1.250% Due 01/31/2020
4,500,000.00 Various
1.53%
4,440,542.42
4,471,788.99
99.34
1.54%
4,470,471.00
9,476.91
2.82%
(1,317.99)
Aaa / AA+
AAA
2.34
2.29
City of Dublin - Account #10198
32
Attachment 1
Holdings Report
For the Month Ending 9/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
912828K58 US Treasury Note
1.375% Due 04/30/2020
1,750,000.00 05/06/2015
1.55%
1,735,171.88
1,742,325.23
99.50
1.57%
1,741,250.00
10,069.63
1.10%
(1,075.23)
Aaa / AA+
AAA
2.58
2.51
912828XE5 US Treasury Note
1.500% Due 05/31/2020
3,000,000.00 Various
1.67%
2,976,025.68
2,986,999.25
99.78
1.58%
2,993,436.00
15,122.95
1.90%
6,436.75
Aaa / AA+
AAA
2.67
2.59
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,410.39
100.05
1.60%
1,500,820.50
4,106.66
0.95%
(3,589.89)
Aaa / AA+
AAA
2.84
2.75
912828L99 US Treasury Note
1.375% Due 10/31/2020
5,000,000.00 Various
1.69%
4,927,376.14
4,954,315.39
99.17
1.65%
4,958,595.00
28,770.38
3.14%
4,279.61
Aaa / AA+
AAA
3.09
2.99
912828N89 US Treasury Note
1.375% Due 01/31/2021
2,000,000.00 03/15/2016
1.49%
1,988,834.83
1,992,368.59
98.94
1.70%
1,978,828.00
4,633.15
1.25%
(13,540.59)
Aaa / AA+
AAA
3.34
3.24
912828S76 US Treasury Note
1.125% Due 07/31/2021
1,500,000.00 12/12/2016
1.89%
1,449,262.83
1,458,024.07
97.57
1.78%
1,463,496.00
2,843.07
0.92%
5,471.93
Aaa / AA+
AAA
3.84
3.72
912828T34 US Treasury Note
1.125% Due 09/30/2021
2,750,000.00 Various
1.66%
2,682,431.10
2,694,159.39
97.37
1.81%
2,677,705.25
85.00
1.69%
(16,454.14)
Aaa / AA+
AAA
4.00
3.89
912828U65 US Treasury Note
1.750% Due 11/30/2021
2,500,000.00 12/28/2016
2.06%
2,464,461.50
2,469,919.83
99.66
1.83%
2,491,505.00
14,702.87
1.58%
21,585.17
Aaa / AA+
AAA
4.17
3.98
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,119.50
100.05
1.86%
1,500,762.00
4,738.45
0.95%
(1,357.50)
Aaa / AA+
AAA
4.34
4.13
912828J76 US Treasury Note
1.750% Due 03/31/2022
3,000,000.00 04/25/2017
1.85%
2,985,830.37
2,987,074.15
99.43
1.88%
2,983,008.00
144.23
1.88%
(4,066.15)
Aaa / AA+
AAA
4.50
4.31
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,742.30
99.38
1.89%
2,732,919.75
20,249.32
1.74%
(6,822.55)
Aaa / AA+
AAA
4.58
4.35
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,228.81
99.35
1.90%
1,490,215.50
8,821.72
0.94%
(6,013.31)
Aaa / AA+
AAA
4.67
4.43
912828XW5 US Treasury Note
1.750% Due 06/30/2022
3,000,000.00 07/25/2017
1.86%
2,984,072.55
2,984,665.41
99.27
1.91%
2,978,085.00
13,267.66
1.89%
(6,580.41)
Aaa / AA+
AAA
4.75
4.52
912828L24 US Treasury Note
1.875% Due 08/31/2022
2,000,000.00 09/27/2017
1.92%
1,995,944.20
1,995,950.97
99.74
1.93%
1,994,844.00
3,211.33
1.26%
(1,106.97)
Aaa / AA+
AAA
4.92
4.67
Total US Treasury 50,500,000.00 1.69%
50,128,190.40
50,233,843.60
1.68%
50,221,997.50
181,670.38
31.77%
(11,846.10)
Aaa / AA+
Aaa
3.27
3.15
TOTAL PORTFOLIO 158,479,892.11 1.60%
158,240,551.55
158,285,368.98 1.66%
158,070,235.00
561,006.23
100.00%
(215,133.98)
Aa1 / AA
Aaa
2.57
2.41
TOTAL MARKET VALUE PLUS ACCRUALS 158,631,241.23
City of Dublin - Account #10198
33
Attachment 1
Holdings Report
For the Month Ending 9/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,171,017.88 Various
1.12%
40,171,017.88
40,171,017.88
1.00
1.12%
40,171,017.88
109,825.92
66.92%
0.00
NR / NR
NR
0.00
0.00
Total LAIF 40,171,017.88 1.12%
40,171,017.88
40,171,017.88
1.12%
40,171,017.88
109,825.92
66.92%
0.00
NR / NR
NR
0.00
0.00
Local Gov Investment Pool
90CAMP$00 Public Financial Management CAMP
19,916,176.73 Various
1.14%
19,916,176.73
19,916,176.73
1.00
1.14%
19,916,176.73
0.00
33.08%
0.00
NR / AAA
NR
0.00
0.00
Total Local Gov Investment Pool 19,916,176.73 1.14%
19,916,176.73
19,916,176.73
1.14%
19,916,176.73
0.00
33.08%
0.00
NR / AAA
NR
0.00
0.00
TOTAL PORTFOLIO 60,087,194.61 1.13%
60,087,194.61
60,087,194.61 1.13%
60,087,194.61
109,825.92
100.00%
0.00
NR / AAA
NR
0.00
0.00
TOTAL MARKET VALUE PLUS ACCRUALS 60,197,020.53
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 07/07/2017 06538BY80 3,160,000.00 Bank of Tokyo Mitsubishi NY Discount CP
1.33% Due: 11/08/2017 99.542 1.35% 3,145,523.69 0.00 3,145,523.69 0.00
Purchase 07/18/2017 47788BAB0 455,000.00 John Deere Owner Trust 2017-B A2A
1.59% Due: 04/15/2020 99.991 1.60% 454,960.46 0.00 454,960.46 0.00
Purchase 07/18/2017 47788BAD6 320,000.00 John Deere Owner Trust 2017-B A3
1.82% Due: 10/15/2021 99.993 1.83% 319,976.58 0.00 319,976.58 0.00
Purchase 07/26/2017 912828XW5 3,000,000.00 US Treasury Note
1.75% Due: 06/30/2022 99.469 1.86% 2,984,072.55 3,709.24 2,987,781.79 0.00
Purchase 08/09/2017 06417GXH6 2,775,000.00 Bank of Nova Scotia Yankee CD
1.57% Due: 08/09/2018 100.000 1.57% 2,775,000.00 0.00 2,775,000.00 0.00
Purchase 08/31/2017 313379RB7 3,000,000.00 FHLB Note
1.875% Due: 06/11/2021 100.754 1.67% 3,022,620.00 12,500.00 3,035,120.00 0.00
Purchase 09/28/2017 912828L24 2,000,000.00 US Treasury Note
1.875% Due: 08/31/2022 99.797 1.92% 1,995,944.20 2,900.55 1,998,844.75 0.00
Purchase 09/29/2017 43814PAB6 460,000.00 Honda Auto Receivables Owner T 17-3 A2
1.57% Due: 01/21/2020 99.991 1.58% 459,959.11 0.00 459,959.11 0.00
Subtotal 15,170,000.00 15,158,056.59 19,109.79 15,177,166.38 0.00
TOTAL ACQUISITIONS 15,170,000.00 15,158,056.59 19,109.79 15,177,166.38 0.00
DISPOSITIONS
Sale 07/13/2017 3134G3Y53 2,000,000.00 FHLMC Callable Note 1X 11/28/14
0.85% Due: 11/28/2017 99.889 1.15% 1,997,780.00 2,125.00 1,999,905.00 -2220.00
Sale 07/26/2017 912828G61 2,000,000.00 US Treasury Note
1.5% Due: 11/30/2019 100.164 1.43% 2,003,274.54 4,590.16 2,007,864.70 1205.29
Sale 08/09/2017 313381B20 2,000,000.00 FHLB Note
0.75% Due: 12/08/2017 99.865 1.16% 1,997,300.00 2,541.67 1,999,841.67 -2698.67
Sale 08/31/2017 912828RH5 2,000,000.00 US Treasury Note
1.375% Due: 09/30/2018 100.136 1.25% 2,002,727.68 11,495.90 2,014,223.58 1495.77
Subtotal 8,000,000.00 8,001,082.22 20,752.73 8,021,834.95 -2,217.61
June 30, 2017 through September 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 07/07/2017 06538BU76 2,935,000.00 Bank of Tokyo Mitsubishi NY Discount CP
1.18% Due: 07/07/2017 99.600 2,935,000.00 0.00 2,935,000.00 0.00
Subtotal 2,935,000.00 2,935,000.00 0.00 2,935,000.00 0.00
TOTAL DISPOSITIONS 14,462,266.93 14,463,349.15 52,560.55 14,515,909.70 -2,217.61
June 30, 2017 through September 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 07/15/2017 90LAIF$00 96,835.43 Local Agency Investment Fund State Pool 1.000 1.01% 96,835.43 0.00 96,835.43 0.00
Purchase 07/31/2017 90CAMP$00 32,077.30 Public Financial Management CAMP 1.000 1.13% 32,077.30 0.00 32,077.30 0.00
Purchase 08/31/2017 90CAMP$00 25,333.69 Public Financial Management CAMP 1.000 1.13% 25,333.69 0.00 25,333.69 0.00
Purchase 09/30/2017 90CAMP$00 20,735.95 Public Financial Management CAMP 1.000 1.14% 20,735.95 0.00 20,735.95 0.00
Subtotal 174,982.37 174,982.37 0.00 174,982.37 0.00
Security
Contribution 07/25/2017 90CAMP$00 4,000,000.00 Public Financial Management CAMP 1.000 4,000,000.00 0.00 4,000,000.00 0.00
Security
Contribution 08/21/2017 90CAMP$00 2,700,000.00 Public Financial Management CAMP 1.000 2,700,000.00 0.00 2,700,000.00 0.00
Subtotal 6,700,000.00 6,700,000.00 0.00 6,700,000.00 0.00
TOTAL ACQUISITIONS 6,874,982.37 6,874,982.37 0.00 6,874,982.37 0.00
DISPOSITIONS
Security
Withdrawal 07/31/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 08/04/2017 90CAMP$00 9,000,000.00 Public Financial Management CAMP 1.000 9,000,000.00 0.00 9,000,000.00 0.00
Security
Withdrawal 08/16/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
Withdrawal 09/06/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 09/13/2017 90CAMP$00 1,300,000.00 Public Financial Management CAMP 1.000 1,300,000.00 0.00 1,300,000.00 0.00
Security
Withdrawal 09/15/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
Subtotal 19,800,000.00 19,800,000.00 0.00 19,800,000.00 0.00
TOTAL DISPOSITIONS 19,800,000.00 19,800,000.00 0.00 19,800,000.00 0.00
June 30, 2017 through September 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 07/07/2017 06538BY80 3,160,000.00 Bank of Tokyo Mitsubishi NY Discount CP
1.33% Due: 11/08/2017 99.542 1.35% 3,145,523.69 0.00 3,145,523.69 0.00
Purchase 07/15/2017 90LAIF$00 96,835.43 Local Agency Investment Fund State Pool 1.000 1.01% 96,835.43 0.00 96,835.43 0.00
Purchase 07/18/2017 47788BAB0 455,000.00 John Deere Owner Trust 2017-B A2A
1.59% Due: 04/15/2020 99.991 1.60% 454,960.46 0.00 454,960.46 0.00
Purchase 07/18/2017 47788BAD6 320,000.00 John Deere Owner Trust 2017-B A3
1.82% Due: 10/15/2021 99.993 1.83% 319,976.58 0.00 319,976.58 0.00
Purchase 07/26/2017 912828XW5 3,000,000.00 US Treasury Note
1.75% Due: 06/30/2022 99.469 1.86% 2,984,072.55 3,709.24 2,987,781.79 0.00
Purchase 07/31/2017 90CAMP$00 32,077.30 Public Financial Management CAMP 1.000 1.13% 32,077.30 0.00 32,077.30 0.00
Purchase 08/09/2017 06417GXH6 2,775,000.00 Bank of Nova Scotia Yankee CD
1.57% Due: 08/09/2018 100.000 1.57% 2,775,000.00 0.00 2,775,000.00 0.00
Purchase 08/31/2017 313379RB7 3,000,000.00 FHLB Note
1.875% Due: 06/11/2021 100.754 1.67% 3,022,620.00 12,500.00 3,035,120.00 0.00
Purchase 08/31/2017 90CAMP$00 25,333.69 Public Financial Management CAMP 1.000 1.13% 25,333.69 0.00 25,333.69 0.00
Purchase 09/28/2017 912828L24 2,000,000.00 US Treasury Note
1.875% Due: 08/31/2022 99.797 1.92% 1,995,944.20 2,900.55 1,998,844.75 0.00
Purchase 09/29/2017 43814PAB6 460,000.00 Honda Auto Receivables Owner T 17-3 A2
1.57% Due: 01/21/2020 99.991 1.58% 459,959.11 0.00 459,959.11 0.00
Purchase 09/30/2017 90CAMP$00 20,735.95 Public Financial Management CAMP 1.000 1.14% 20,735.95 0.00 20,735.95 0.00
Subtotal 15,344,982.37 15,333,038.96 19,109.79 15,352,148.75 0.00
Security
Contribution 07/25/2017 90CAMP$00 4,000,000.00 Public Financial Management CAMP 1.000 4,000,000.00 0.00 4,000,000.00 0.00
Security
Contribution 08/21/2017 90CAMP$00 2,700,000.00 Public Financial Management CAMP 1.000 2,700,000.00 0.00 2,700,000.00 0.00
Subtotal 6,700,000.00 6,700,000.00 0.00 6,700,000.00 0.00
TOTAL ACQUISITIONS 22,044,982.37 22,033,038.96 19,109.79 22,052,148.75 0.00
June 30, 2017 through September 30, 2017
39
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
DISPOSITIONS
Sale 07/13/2017 3134G3Y53 2,000,000.00 FHLMC Callable Note 1X 11/28/14
0.85% Due: 11/28/2017 99.889 1.15% 1,997,780.00 2,125.00 1,999,905.00 -2220.00
Sale 07/26/2017 912828G61 2,000,000.00 US Treasury Note
1.5% Due: 11/30/2019 100.164 1.43% 2,003,274.54 4,590.16 2,007,864.70 1205.29
Sale 08/09/2017 313381B20 2,000,000.00 FHLB Note
0.75% Due: 12/08/2017 99.865 1.16% 1,997,300.00 2,541.67 1,999,841.67 -2698.67
Sale 08/31/2017 912828RH5 2,000,000.00 US Treasury Note
1.375% Due: 09/30/2018 100.136 1.25% 2,002,727.68 11,495.90 2,014,223.58 1495.77
Subtotal 8,000,000.00 8,001,082.22 20,752.73 8,021,834.95 -2,217.61
Maturity 07/07/2017 06538BU76 2,935,000.00 Bank of Tokyo Mitsubishi NY Discount CP
1.18% Due: 07/07/2017 99.600 2,935,000.00 0.00 2,935,000.00 0.00
Subtotal 2,935,000.00 2,935,000.00 0.00 2,935,000.00 0.00
Security
Withdrawal 07/31/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 08/04/2017 90CAMP$00 9,000,000.00 Public Financial Management CAMP 1.000 9,000,000.00 0.00 9,000,000.00 0.00
Security
Withdrawal 08/16/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
Withdrawal 09/06/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 09/13/2017 90CAMP$00 1,300,000.00 Public Financial Management CAMP 1.000 1,300,000.00 0.00 1,300,000.00 0.00
Security
Withdrawal 09/15/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
Subtotal 19,800,000.00 19,800,000.00 0.00 19,800,000.00 0.00
TOTAL DISPOSITIONS 34,262,266.93 34,263,349.15 52,560.55 34,315,909.70 -2,217.61
June 30, 2017 through September 30, 2017
40
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.
41
Attachment 1
Transaction Ledger
6/30/17 Thru 7/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 07/03/2017 31846V203 1,079.36 First American Govt Obligation Fund 1.000 0.57 %1,079.36 0.00 1,079.36 0.00
Purchase 07/05/2017 31846V203 24,444.45 First American Govt Obligation Fund 1.000 0.57 %24,444.45 0.00 24,444.45 0.00
Purchase 07/07/2017 06538BY80 3,160,000.00 Bank of Tokyo Mitsubishi NY Discount CP
1.33% Due 11/8/2017
99.542 1.35 %3,145,523.69 0.00 3,145,523.69 0.00
Purchase 07/07/2017 31846V203 2,935,000.00 First American Govt Obligation Fund 1.000 0.57 %2,935,000.00 0.00 2,935,000.00 0.00
Purchase 07/08/2017 31846V203 9,562.50 First American Govt Obligation Fund 1.000 0.57 %9,562.50 0.00 9,562.50 0.00
Purchase 07/13/2017 31846V203 1,999,905.00 First American Govt Obligation Fund 1.000 0.57 %1,999,905.00 0.00 1,999,905.00 0.00
Purchase 07/14/2017 31846V203 25,937.50 First American Govt Obligation Fund 1.000 0.57 %25,937.50 0.00 25,937.50 0.00
Purchase 07/15/2017 90LAIF$00 96,835.43 Local Agency Investment Fund State Pool 1.000 1.01 %96,835.43 0.00 96,835.43 0.00
Purchase 07/16/2017 31846V203 4,062.50 First American Govt Obligation Fund 1.000 0.57 %4,062.50 0.00 4,062.50 0.00
Purchase 07/17/2017 31846V203 1,660.67 First American Govt Obligation Fund 1.000 0.57 %1,660.67 0.00 1,660.67 0.00
Purchase 07/17/2017 31846V203 932.46 First American Govt Obligation Fund 1.000 0.57 %932.46 0.00 932.46 0.00
Purchase 07/17/2017 31846V203 15,860.04 First American Govt Obligation Fund 1.000 0.57 %15,860.04 0.00 15,860.04 0.00
Purchase 07/17/2017 31846V203 818.75 First American Govt Obligation Fund 1.000 0.57 %818.75 0.00 818.75 0.00
Purchase 07/17/2017 31846V203 1,263.67 First American Govt Obligation Fund 1.000 0.57 %1,263.67 0.00 1,263.67 0.00
Purchase 07/17/2017 31846V203 102,126.58 First American Govt Obligation Fund 1.000 0.57 %102,126.58 0.00 102,126.58 0.00
Purchase 07/17/2017 31846V203 771.75 First American Govt Obligation Fund 1.000 0.57 %771.75 0.00 771.75 0.00
Purchase 07/17/2017 31846V203 77,612.37 First American Govt Obligation Fund 1.000 0.57 %77,612.37 0.00 77,612.37 0.00
Purchase 07/17/2017 31846V203 106,931.96 First American Govt Obligation Fund 1.000 0.57 %106,931.96 0.00 106,931.96 0.00
Purchase 07/17/2017 31846V203 55,902.42 First American Govt Obligation Fund 1.000 0.57 %55,902.42 0.00 55,902.42 0.00
Purchase 07/18/2017 31846V203 13,528.54 First American Govt Obligation Fund 1.000 0.57 %13,528.54 0.00 13,528.54 0.00
Purchase 07/18/2017 31846V203 101,353.57 First American Govt Obligation Fund 1.000 0.57 %101,353.57 0.00 101,353.57 0.00
Purchase 07/18/2017 47788BAB0 455,000.00 John Deere Owner Trust 2017-B A2A
1.59% Due 4/15/2020
99.991 1.60 %454,960.46 0.00 454,960.46 0.00
Purchase 07/18/2017 47788BAD6 320,000.00 John Deere Owner Trust 2017-B A3
1.82% Due 10/15/2021
99.993 1.83 %319,976.58 0.00 319,976.58 0.00
Purchase 07/21/2017 31846V203 16,250.00 First American Govt Obligation Fund 1.000 0.57 %16,250.00 0.00 16,250.00 0.00
Purchase 07/21/2017 31846V203 93,417.13 First American Govt Obligation Fund 1.000 0.57 %93,417.13 0.00 93,417.13 0.00
Purchase 07/21/2017 31846V203 1,029.50 First American Govt Obligation Fund 1.000 0.57 %1,029.50 0.00 1,029.50 0.00
Purchase 07/23/2017 31846V203 20,250.00 First American Govt Obligation Fund 1.000 0.57 %20,250.00 0.00 20,250.00 0.00
Purchase 07/24/2017 31846V203 26,250.00 First American Govt Obligation Fund 1.000 0.57 %26,250.00 0.00 26,250.00 0.00
Execution Time: 8/23/2017 10:06:34 AMChandler Asset Management - CONFIDENTIAL Page 8
Attachment 2
Transaction Ledger
6/30/17 Thru 7/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 07/26/2017 912828XW5 3,000,000.00 US Treasury Note
1.75% Due 6/30/2022
99.469 1.86 %2,984,072.55 3,709.24 2,987,781.79 0.00
Purchase 07/31/2017 31846V203 76,562.50 First American Govt Obligation Fund 1.000 0.60 %76,562.50 0.00 76,562.50 0.00
Purchase 07/31/2017 90CAMP$00 32,077.30 Public Financial Management CAMP 1.000 1.13 %32,077.30 0.00 32,077.30 0.00
Subtotal 12,776,425.95 12,745,959.23 3,709.24 12,749,668.47 0.00
Security
Contribution
07/25/2017 90CAMP$00 4,000,000.00 Public Financial Management 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
Short Sale 07/18/2017 31846V203 -774,937.04 First American Govt Obligation Fund 1.000 -774,937.04 0.00 -774,937.04 0.00
Subtotal -774,937.04 -774,937.04 0.00 -774,937.04 0.00
TOTAL ACQUISITIONS 16,001,488.91 15,971,022.19 3,709.24 15,974,731.43 0.00
DISPOSITIONS
Closing
Purchase
07/18/2017 31846V203 -774,937.04 First American Govt Obligation Fund 1.000 -774,937.04 0.00 -774,937.04 0.00
Subtotal -774,937.04 -774,937.04 0.00 -774,937.04 0.00
Sale 07/07/2017 31846V203 3,145,523.69 First American Govt Obligation Fund 1.000 0.57 %3,145,523.69 0.00 3,145,523.69 0.00
Sale 07/13/2017 3134G3Y53 2,000,000.00 FHLMC Callable Note 1X 11/28/14
0.85% Due 11/28/2017
99.889 1.15 %1,997,780.00 2,125.00 1,999,905.00 -2,220.00
Sale 07/18/2017 31846V203 774,937.04 First American Govt Obligation Fund 1.000 0.57 %774,937.04 0.00 774,937.04 0.00
Sale 07/26/2017 31846V203 979,917.09 First American Govt Obligation Fund 1.000 0.57 %979,917.09 0.00 979,917.09 0.00
Sale 07/26/2017 912828G61 2,000,000.00 US Treasury Note
1.5% Due 11/30/2019
100.164 1.43 %2,003,274.54 4,590.16 2,007,864.70 1,205.29
Subtotal 8,900,377.82 8,901,432.36 6,715.16 8,908,147.52 -1,014.71
Paydown 07/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 07/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 07/17/2017 47787VAC5 15,847.89 John Deere Owner Trust 2014-A A3
0.92% Due 4/16/2018
100.000 15,847.89 12.15 15,860.04 0.00
Paydown 07/17/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
Execution Time: 8/23/2017 10:06:34 AMChandler Asset Management - CONFIDENTIAL Page 9
Attachment 2
Transaction Ledger
6/30/17 Thru 7/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 07/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 07/17/2017 47788NAB4 101,177.72 John Deere Owner Trust 2016-B A2
1.09% Due 2/15/2019
100.000 101,177.72 948.86 102,126.58 0.00
Paydown 07/17/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 07/17/2017 65478WAB1 76,950.57 Nissan Auto Receivables Owner 2016-C
A2A
1.07% Due 5/15/2019
100.000 76,950.57 661.80 77,612.37 0.00
Paydown 07/17/2017 89231LAB3 105,936.23 Toyota Auto Receivables Owner 2016-D
1.06% Due 5/15/2019
100.000 105,936.23 995.73 106,931.96 0.00
Paydown 07/17/2017 89236WAC2 55,486.32 Toyota Auto Receivables Owner 2015-A
1.12% Due 2/15/2019
100.000 55,486.32 416.10 55,902.42 0.00
Paydown 07/18/2017 43814GAC4 13,519.87 Honda Auto Receivables 2014-2 A3
0.77% Due 3/19/2018
100.000 13,519.87 8.67 13,528.54 0.00
Paydown 07/18/2017 43814NAB1 101,128.82 Honda Auto Receivables 2016-1 A2
1.01% Due 6/18/2018
100.000 101,128.82 224.75 101,353.57 0.00
Paydown 07/21/2017 43813NAC0 92,764.12 Honda Auto Receivables 2015-2 A3
1.04% Due 2/21/2019
100.000 92,764.12 653.01 93,417.13 0.00
Paydown 07/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 562,811.54 562,811.54 10,397.87 573,209.41 0.00
Maturity 07/07/2017 06538BU76 2,935,000.00 Bank of Tokyo Mitsubishi NY Discount CP
1.18% Due 7/7/2017
99.600 2,935,000.00 0.00 2,935,000.00 0.00
Subtotal 2,935,000.00 2,935,000.00 0.00 2,935,000.00 0.00
Security
Withdrawal
07/25/2017 31846V203 104.17 First American Govt Obligation Fund 1.000 104.17 0.00 104.17 0.00
Security
Withdrawal
07/31/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
Subtotal 2,500,104.17 2,500,104.17 0.00 2,500,104.17 0.00
TOTAL DISPOSITIONS 14,123,356.49 14,124,411.03 17,113.03 14,141,524.06 -1,014.71
OTHER TRANSACTIONS
Interest 07/05/2017 3135G0S38 2,500,000.00 FNMA Note
2% Due 1/5/2022
0.000 24,444.45 0.00 24,444.45 0.00
Execution Time: 8/23/2017 10:06:34 AMChandler Asset Management - CONFIDENTIAL Page 10
Attachment 2
Transaction Ledger
6/30/17 Thru 7/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 07/08/2017 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/2017 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/2017 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/16/2017 40428HPH9 500,000.00 HSBC USA Inc Note
1.625% Due 1/16/2018
0.000 4,062.50 0.00 4,062.50 0.00
Interest 07/21/2017 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/2017 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/2017 91159HHP8 2,000,000.00 US Bancorp Note
2.625% Due 1/24/2022
0.000 26,250.00 0.00 26,250.00 0.00
Interest 07/31/2017 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/2017 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/2017 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/2017 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/2017 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 24,050,000.00 203,319.45 0.00 203,319.45 0.00
Dividend 07/03/2017 31846V203 436,922.92 First American Govt Obligation Fund 0.000 1,079.36 0.00 1,079.36 0.00
Dividend 07/15/2017 90LAIF$00 3,825,316,362.2
0
Local Agency Investment Fund State Pool 0.000 96,835.43 0.00 96,835.43 0.00
Dividend 07/31/2017 90CAMP$00 32,938,029.79 Public Financial Management CAMP 0.000 32,077.30 0.00 32,077.30 0.00
Subtotal 3,858,691,314.9
1
129,992.09 0.00 129,992.09 0.00
TOTAL OTHER TRANSACTIONS 3,882,741,314.9
1
333,311.54 0.00 333,311.54 0.00
Execution Time: 8/23/2017 10:06:34 AMChandler Asset Management - CONFIDENTIAL Page 11
Attachment 2
Transaction Ledger
7/31/17 Thru 8/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 08/01/2017 31846V203 10,500.00 First American Govt Obligation Fund 1.000 0.60 %10,500.00 0.00 10,500.00 0.00
Purchase 08/01/2017 31846V203 641.84 First American Govt Obligation Fund 1.000 0.60 %641.84 0.00 641.84 0.00
Purchase 08/08/2017 31846V203 27,462.50 First American Govt Obligation Fund 1.000 0.60 %27,462.50 0.00 27,462.50 0.00
Purchase 08/09/2017 06417GXH6 2,775,000.00 Bank of Nova Scotia Yankee CD
1.57% Due 8/9/2018
100.000 1.57 %2,775,000.00 0.00 2,775,000.00 0.00
Purchase 08/12/2017 31846V203 16,875.00 First American Govt Obligation Fund 1.000 0.60 %16,875.00 0.00 16,875.00 0.00
Purchase 08/15/2017 31846V203 30,250.00 First American Govt Obligation Fund 1.000 0.60 %30,250.00 0.00 30,250.00 0.00
Purchase 08/15/2017 31846V203 1,660.67 First American Govt Obligation Fund 1.000 0.60 %1,660.67 0.00 1,660.67 0.00
Purchase 08/15/2017 31846V203 932.46 First American Govt Obligation Fund 1.000 0.60 %932.46 0.00 932.46 0.00
Purchase 08/15/2017 31846V203 818.75 First American Govt Obligation Fund 1.000 0.60 %818.75 0.00 818.75 0.00
Purchase 08/15/2017 31846V203 1,263.67 First American Govt Obligation Fund 1.000 0.60 %1,263.67 0.00 1,263.67 0.00
Purchase 08/15/2017 31846V203 129,838.50 First American Govt Obligation Fund 1.000 0.60 %129,838.50 0.00 129,838.50 0.00
Purchase 08/15/2017 31846V203 771.75 First American Govt Obligation Fund 1.000 0.60 %771.75 0.00 771.75 0.00
Purchase 08/15/2017 31846V203 72,813.93 First American Govt Obligation Fund 1.000 0.60 %72,813.93 0.00 72,813.93 0.00
Purchase 08/15/2017 31846V203 98,266.69 First American Govt Obligation Fund 1.000 0.60 %98,266.69 0.00 98,266.69 0.00
Purchase 08/15/2017 31846V203 51,448.69 First American Govt Obligation Fund 1.000 0.60 %51,448.69 0.00 51,448.69 0.00
Purchase 08/18/2017 31846V203 23,856.25 First American Govt Obligation Fund 1.000 0.60 %23,856.25 0.00 23,856.25 0.00
Purchase 08/18/2017 31846V203 95,262.64 First American Govt Obligation Fund 1.000 0.60 %95,262.64 0.00 95,262.64 0.00
Purchase 08/21/2017 31846V203 85,583.53 First American Govt Obligation Fund 1.000 0.60 %85,583.53 0.00 85,583.53 0.00
Purchase 08/21/2017 31846V203 1,029.50 First American Govt Obligation Fund 1.000 0.60 %1,029.50 0.00 1,029.50 0.00
Purchase 08/26/2017 31846V203 34,375.00 First American Govt Obligation Fund 1.000 0.60 %34,375.00 0.00 34,375.00 0.00
Purchase 08/31/2017 313379RB7 3,000,000.00 FHLB Note
1.875% Due 6/11/2021
100.754 1.67 %3,022,620.00 12,500.00 3,035,120.00 0.00
Purchase 08/31/2017 31846V203 37,500.00 First American Govt Obligation Fund 1.000 0.61 %37,500.00 0.00 37,500.00 0.00
Purchase 08/31/2017 90CAMP$00 25,333.69 Public Financial Management CAMP 1.000 1.13 %25,333.69 0.00 25,333.69 0.00
Subtotal 6,521,485.06 6,544,105.06 12,500.00 6,556,605.06 0.00
Security
Contribution
08/21/2017 90CAMP$00 2,700,000.00 Public Financial Management CAMP 1.000 2,700,000.00 0.00 2,700,000.00 0.00
Subtotal 2,700,000.00 2,700,000.00 0.00 2,700,000.00 0.00
TOTAL ACQUISITIONS 9,221,485.06 9,244,105.06 12,500.00 9,256,605.06 0.00
Execution Time: 9/28/2017 10:58:56 AMChandler Asset Management - CONFIDENTIAL Page 8
Attachment 2
Transaction Ledger
7/31/17 Thru 8/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
Sale 08/09/2017 313381B20 2,000,000.00 FHLB Note
0.75% Due 12/8/2017
99.865 1.16 %1,997,300.00 2,541.67 1,999,841.67 -2,698.67
Sale 08/09/2017 31846V203 775,158.33 First American Govt Obligation Fund 1.000 0.60 %775,158.33 0.00 775,158.33 0.00
Sale 08/31/2017 31846V203 1,020,896.42 First American Govt Obligation Fund 1.000 0.61 %1,020,896.42 0.00 1,020,896.42 0.00
Sale 08/31/2017 912828RH5 2,000,000.00 US Treasury Note
1.375% Due 9/30/2018
100.136 1.25 %2,002,727.68 11,495.90 2,014,223.58 1,495.77
Subtotal 5,796,054.75 5,796,082.43 14,037.57 5,810,120.00 -1,202.90
Paydown 08/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 08/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 08/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 08/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 08/15/2017 47788NAB4 128,981.54 John Deere Owner Trust 2016-B A2
1.09% Due 2/15/2019
100.000 128,981.54 856.96 129,838.50 0.00
Paydown 08/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 08/15/2017 65478WAB1 72,220.75 Nissan Auto Receivables Owner 2016-C
A2A
1.07% Due 5/15/2019
100.000 72,220.75 593.18 72,813.93 0.00
Paydown 08/15/2017 89231LAB3 97,364.54 Toyota Auto Receivables Owner 2016-D
1.06% Due 5/15/2019
100.000 97,364.54 902.15 98,266.69 0.00
Paydown 08/15/2017 89236WAC2 51,084.37 Toyota Auto Receivables Owner 2015-A
1.12% Due 2/15/2019
100.000 51,084.37 364.32 51,448.69 0.00
Paydown 08/18/2017 43814NAB1 95,123.00 Honda Auto Receivables 2016-1 A2
1.01% Due 6/18/2018
100.000 95,123.00 139.64 95,262.64 0.00
Paydown 08/21/2017 43813NAC0 85,010.91 Honda Auto Receivables 2015-2 A3
1.04% Due 2/21/2019
100.000 85,010.91 572.62 85,583.53 0.00
Paydown 08/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 529,785.11 529,785.11 9,905.67 539,690.78 0.00
Security
Withdrawal
08/04/2017 90CAMP$00 9,000,000.00 Public Financial Management CAMP 1.000 9,000,000.00 0.00 9,000,000.00 0.00
Security
Withdrawal
08/16/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
Execution Time: 9/28/2017 10:58:56 AMChandler Asset Management - CONFIDENTIAL Page 9
Attachment 2
Transaction Ledger
7/31/17 Thru 8/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
Security
Withdrawal
08/25/2017 31846V203 104.17 First American Govt Obligation Fund 1.000 104.17 0.00 104.17 0.00
Subtotal 11,000,104.17 11,000,104.17 0.00 11,000,104.17 0.00
TOTAL DISPOSITIONS 17,325,944.03 17,325,971.71 23,943.24 17,349,914.95 -1,202.90
OTHER TRANSACTIONS
Interest 08/01/2017 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/08/2017 3135G0TG8 3,000,000.00 FNMA Note
0.875% Due 2/8/2018
0.000 13,125.00 0.00 13,125.00 0.00
Interest 08/08/2017 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/2017 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/2017 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/2017 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/2017 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/2017 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/2017 912828C24 1,750,000.00 US Treasury Note
1.5% Due 2/28/2019
0.000 13,125.00 0.00 13,125.00 0.00
Interest 08/31/2017 912828D80 3,000,000.00 US Treasury Note
1.625% Due 8/31/2019
0.000 24,375.00 0.00 24,375.00 0.00
Subtotal 24,870,000.00 180,818.75 0.00 180,818.75 0.00
Dividend 08/01/2017 31846V203 1,259,454.15 First American Govt Obligation Fund 0.000 641.84 0.00 641.84 0.00
Execution Time: 9/28/2017 10:58:56 AMChandler Asset Management - CONFIDENTIAL Page 10
Attachment 2
Transaction Ledger
7/31/17 Thru 8/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
Dividend 08/31/2017 90CAMP$00 26,170,107.09 Public Financial Management CAMP 0.000 25,333.69 0.00 25,333.69 0.00
Subtotal 27,429,561.24 25,975.53 0.00 25,975.53 0.00
TOTAL OTHER TRANSACTIONS 52,299,561.24 206,794.28 0.00 206,794.28 0.00
Execution Time: 9/28/2017 10:58:56 AMChandler Asset Management - CONFIDENTIAL Page 11
Attachment 2
Transaction Ledger
8/31/17 Thru 9/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 09/01/2017 31846V203 34,341.75 First American Govt Obligation Fund 1.000 0.61 %34,341.75 0.00 34,341.75 0.00
Purchase 09/01/2017 31846V203 507.34 First American Govt Obligation Fund 1.000 0.61 %507.34 0.00 507.34 0.00
Purchase 09/07/2017 31846V203 13,125.00 First American Govt Obligation Fund 1.000 0.61 %13,125.00 0.00 13,125.00 0.00
Purchase 09/08/2017 31846V203 20,625.00 First American Govt Obligation Fund 1.000 0.61 %20,625.00 0.00 20,625.00 0.00
Purchase 09/09/2017 31846V203 27,500.00 First American Govt Obligation Fund 1.000 0.61 %27,500.00 0.00 27,500.00 0.00
Purchase 09/11/2017 31846V203 31,125.00 First American Govt Obligation Fund 1.000 0.61 %31,125.00 0.00 31,125.00 0.00
Purchase 09/12/2017 31846V203 21,875.00 First American Govt Obligation Fund 1.000 0.61 %21,875.00 0.00 21,875.00 0.00
Purchase 09/15/2017 31846V203 15,356.25 First American Govt Obligation Fund 1.000 0.61 %15,356.25 0.00 15,356.25 0.00
Purchase 09/15/2017 31846V203 1,881,660.67 First American Govt Obligation Fund 1.000 0.61 %1,881,660.67 0.00 1,881,660.67 0.00
Purchase 09/15/2017 31846V203 932.46 First American Govt Obligation Fund 1.000 0.61 %932.46 0.00 932.46 0.00
Purchase 09/15/2017 31846V203 818.75 First American Govt Obligation Fund 1.000 0.61 %818.75 0.00 818.75 0.00
Purchase 09/15/2017 31846V203 1,145.46 First American Govt Obligation Fund 1.000 0.61 %1,145.46 0.00 1,145.46 0.00
Purchase 09/15/2017 31846V203 922.13 First American Govt Obligation Fund 1.000 0.61 %922.13 0.00 922.13 0.00
Purchase 09/15/2017 31846V203 1,263.67 First American Govt Obligation Fund 1.000 0.61 %1,263.67 0.00 1,263.67 0.00
Purchase 09/15/2017 31846V203 110,721.28 First American Govt Obligation Fund 1.000 0.61 %110,721.28 0.00 110,721.28 0.00
Purchase 09/15/2017 31846V203 771.75 First American Govt Obligation Fund 1.000 0.61 %771.75 0.00 771.75 0.00
Purchase 09/15/2017 31846V203 73,051.06 First American Govt Obligation Fund 1.000 0.61 %73,051.06 0.00 73,051.06 0.00
Purchase 09/15/2017 31846V203 103,440.48 First American Govt Obligation Fund 1.000 0.61 %103,440.48 0.00 103,440.48 0.00
Purchase 09/15/2017 31846V203 51,647.55 First American Govt Obligation Fund 1.000 0.61 %51,647.55 0.00 51,647.55 0.00
Purchase 09/18/2017 31846V203 70,840.86 First American Govt Obligation Fund 1.000 0.61 %70,840.86 0.00 70,840.86 0.00
Purchase 09/21/2017 31846V203 84,943.85 First American Govt Obligation Fund 1.000 0.61 %84,943.85 0.00 84,943.85 0.00
Purchase 09/21/2017 31846V203 64,014.59 First American Govt Obligation Fund 1.000 0.61 %64,014.59 0.00 64,014.59 0.00
Purchase 09/28/2017 912828L24 2,000,000.00 US Treasury Note
1.875% Due 8/31/2022
99.797 1.92 %1,995,944.20 2,900.55 1,998,844.75 0.00
Purchase 09/29/2017 43814PAB6 460,000.00 Honda Auto Receivables Owner T 17-3 A2
1.57% Due 1/21/2020
99.991 1.58 %459,959.11 0.00 459,959.11 0.00
Purchase 09/30/2017 31846V203 41,718.75 First American Govt Obligation Fund 1.000 0.61 %41,718.75 0.00 41,718.75 0.00
Purchase 09/30/2017 90CAMP$00 20,735.95 Public Financial Management CAMP 1.000 1.14 %20,735.95 0.00 20,735.95 0.00
Subtotal 5,133,084.60 5,128,987.91 2,900.55 5,131,888.46 0.00
TOTAL ACQUISITIONS 5,133,084.60 5,128,987.91 2,900.55 5,131,888.46 0.00
Execution Time: 10/30/2017 10:36:40 AMChandler Asset Management - CONFIDENTIAL Page 8
Attachment 2
Transaction Ledger
8/31/17 Thru 9/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 09/28/2017 31846V203 1,998,844.75 First American Govt Obligation Fund 1.000 0.61 %1,998,844.75 0.00 1,998,844.75 0.00
Sale 09/29/2017 31846V203 459,959.11 First American Govt Obligation Fund 1.000 0.61 %459,959.11 0.00 459,959.11 0.00
Subtotal 2,458,803.86 2,458,803.86 0.00 2,458,803.86 0.00
Paydown 09/15/2017 161571HH0 1,880,000.00 Chase CHAIT Pool #2016-A7
1.06% Due 9/16/2019
100.000 1,880,000.00 1,660.67 1,881,660.67 0.00
Paydown 09/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 09/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 09/15/2017 47788BAB0 0.00 John Deere Owner Trust 2017-B A2A
1.59% Due 4/15/2020
100.000 0.00 1,145.46 1,145.46 0.00
Paydown 09/15/2017 47788BAD6 0.00 John Deere Owner Trust 2017-B A3
1.82% Due 10/15/2021
100.000 0.00 922.13 922.13 0.00
Paydown 09/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 09/15/2017 47788NAB4 109,981.48 John Deere Owner Trust 2016-B A2
1.09% Due 2/15/2019
100.000 109,981.48 739.80 110,721.28 0.00
Paydown 09/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 09/15/2017 65478WAB1 72,522.27 Nissan Auto Receivables Owner 2016-C
A2A
1.07% Due 5/15/2019
100.000 72,522.27 528.79 73,051.06 0.00
Paydown 09/15/2017 89231LAB3 102,624.33 Toyota Auto Receivables Owner 2016-D
1.06% Due 5/15/2019
100.000 102,624.33 816.15 103,440.48 0.00
Paydown 09/15/2017 89236WAC2 51,330.91 Toyota Auto Receivables Owner 2015-A
1.12% Due 2/15/2019
100.000 51,330.91 316.64 51,647.55 0.00
Paydown 09/18/2017 43814NAB1 70,781.29 Honda Auto Receivables 2016-1 A2
1.01% Due 6/18/2018
100.000 70,781.29 59.57 70,840.86 0.00
Paydown 09/21/2017 43813NAC0 84,444.91 Honda Auto Receivables 2015-2 A3
1.04% Due 2/21/2019
100.000 84,444.91 498.94 84,943.85 0.00
Paydown 09/21/2017 43814TAB8 62,985.09 Honda Auto Receivables 2017-1 A2
1.42% Due 7/22/2019
100.000 62,985.09 1,029.50 64,014.59 0.00
Subtotal 2,434,670.28 2,434,670.28 11,504.28 2,446,174.56 0.00
Security
Withdrawal
09/06/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
09/13/2017 90CAMP$00 1,300,000.00 Public Financial Management CAMP 1.000 1,300,000.00 0.00 1,300,000.00 0.00
Execution Time: 10/30/2017 10:36:40 AMChandler Asset Management - CONFIDENTIAL Page 9
Attachment 2
Transaction Ledger
8/31/17 Thru 9/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
09/15/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
09/25/2017 31846V203 104.17 First American Govt Obligation Fund 1.000 104.17 0.00 104.17 0.00
Subtotal 6,300,104.17 6,300,104.17 0.00 6,300,104.17 0.00
TOTAL DISPOSITIONS 11,193,578.31 11,193,578.31 11,504.28 11,205,082.59 0.00
OTHER TRANSACTIONS
Interest 09/01/2017 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/2017 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/07/2017 3137EADP1 3,000,000.00 FHLMC Note
0.875% Due 3/7/2018
0.000 13,125.00 0.00 13,125.00 0.00
Interest 09/08/2017 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/09/2017 313378A43 4,000,000.00 FHLB Note
1.375% Due 3/9/2018
0.000 27,500.00 0.00 27,500.00 0.00
Interest 09/11/2017 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
Interest 09/11/2017 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/2017 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/15/2017 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/30/2017 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/2017 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 25,475,000.00 205,666.75 0.00 205,666.75 0.00
Dividend 09/01/2017 31846V203 208,288.35 First American Govt Obligation Fund 0.000 507.34 0.00 507.34 0.00
Execution Time: 10/30/2017 10:36:40 AMChandler Asset Management - CONFIDENTIAL Page 10
Attachment 2
Transaction Ledger
8/31/17 Thru 9/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
Dividend 09/30/2017 90CAMP$00 19,895,440.78 Public Financial Management CAMP 0.000 20,735.95 0.00 20,735.95 0.00
Subtotal 20,103,729.13 21,243.29 0.00 21,243.29 0.00
TOTAL OTHER TRANSACTIONS 45,578,729.13 226,910.04 0.00 226,910.04 0.00
Execution Time: 10/30/2017 10:36:40 AMChandler Asset Management - CONFIDENTIAL Page 11
Attachment 2