HomeMy WebLinkAbout4.5 - 1468 Q3 Investment Report
Page 1 of 4
STAFF REPORT
CITY COUNCIL
DATE: June 6, 2017
TO: Honorable Mayor and Councilmembers
FROM:
Christopher L. Foss, City Manager
SUBJECT:
City Treasurer's Informational Report of Investments for the Quarter
Ending March 31, 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 March 31, 2017, and includes a monthly
transaction ledger. The City’s investment portfolio for this period totaled
$235,886,943 (book value) with an average market yield of 1.31%. 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.
This report reflects a large a significant increase ($29.8 million) in total cash since
December 31, 2016, which accounts for some large one-time payments, including grant
funds, developer deposits, and impact fees payments. Total General Fund interest
income for Fiscal Year 2016-17 is projected at $840,880, which includes a budget
increase of $375,000 approved as part of the 2nd Quarter Financial Review of February
21, 2017. No additional budget changes are recommended at this time.
Page 2 of 4
DESCRIPTION:
The total investment portfolio of $235,886,943 (book value) is comprised of
$147,162,538 managed by Chandler Asset Management (Chandler), and $88,724,404
invested by the City in local government pools. The average market yield of the
Chandler portfolio and the local pools was 1.57% and 0.88% respectively. The total
investment portfolio balance fluctuates throughout the year due to normal 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 (the Fed) raised the fed funds target rate by 25
basis points to a range of 0.75% - 1.00% in March. The Fed noted economic activity
expanded at a moderate pace, labor market gains reminded solid, and inflation was
moving closer to the Fed’s 2.0% target. The Fed is still projecting a 1.4% fed funds rate
by the end of the year.
The domestic economic data remains indicative of slow growth, with the economy at or
near full employment. Consumer confidence is strong, manufacturing indicators have
improved, and housing trends remain favorable. Chandler expects GDP growth of 2.0%
-2.5% in 2017.
The Treasury yield curve continued to flatten modestly in March. Short -term Treasury
yields increased while the rest of the Treasury yield curve was essentially unchanged.
At the end of 2016, following the election, US Treasury yields increased meaningfully
driven by heightened expectations for fiscal stimulus and growth under the Trump
administration and the Republican-controlled Congress. Some of the post-election
exuberance regarding fiscal spending, tax reform, and healthcare reform has started to
wane, as market participants begin to sense the timeline and magnitude of such
policies may be delayed or potentially less robust than previously hoped.
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’s holdings as managed by
Chandler remained consistent with the prior quarter. The primary change in allocation
was due to the increased cash received by the City, deposited into the Local
Government Investment Pool.
Page 3 of 4
Chart 1: Investments by Type, December 31, 2016 - March 31, 2017
The market value of the City's portfolio increased $29.8 million since December 31,
2016 (see Table 1 below), and $34.1 million from the same quarter the prior year, due
to an increase in grant funds, developer deposits, and impact fees received from
various development projects.
Table 1: Portfolio Values and Yield to Maturity
Overall market yield-to-maturity (YTM) increased from 1.28%% to 1.31% (See Table 2
below). For detailed monthly transactions, see Attachment 2.
Page 4 of 4
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 allowab le in LAIF with any excesses resulting from the timing
of large payments deposited into CAMP as a temporary holding place.
Table 3: Quarterly LAIF Yields, Recent Seven Years and One Quarter
NOTICING REQUIREMENTS/PUBLIC OUTREACH:
None.
ATTACHMENTS:
1. City of Dublin Investment Report for Period Ending March 2017
2. Transaction Ledger - January - March 2017
6225 Lusk Blvd | San Diego, CA 92121 | Phone 800.317.4747 | Fax 858.546.3741 | www.chandlerasset.com
CHANDLER ASSET MANAGEMENT
Period Ending
March 31, 2017
City of Dublin
Investment Report
Table of Contents
SECTION 1 Economic Update
SECTION 2 Account Profile
SECTION 3 Consolidated Information
SECTION 4 Portfolio Holdings
SECTION 5 Transactions
1
SECTION 1
Economic Update
2
Domesticeconomicdataremainsindicative of slowgrowth.Theeconomy is likely atornear fullemployment,
consumerconfidence is strong,manufacturingindicatorshaveimproved,and housingtrendsremainfavorable.
Lookingfurther ahead,apotentialboost in fiscalstimuluscouldprovideafurthertailwind to economicgrowth.GDP
grew by 2.1% in the fourth quarter. We expect GDP growth of 2.0%-2.5% in 2017.
Economic Update
TheFederalOpenMarketCommittee(FOMC)raisedthefedfundstargetrate by25 basispoints to arange of 0.75%-
1.00%in March.Therewas one dissentingvotefromMinneapolisFedPresidentNeelKashkariwhopreferred no rate
hike.TheFednotedeconomicactivityexpanded at amoderatepace,labormarketgainsremainsolid,and inflation is
movingclose to the Fed’s 2.0%target.TheFed is stillprojectinga1.4%fedfundsrate by the endof thisyear,which
impliestwomore 25 basispointhikes.Thelong-runfedfundsrateprojectionwasalsounchanged at 3.0%.Notably,
theFedanticipatesthelonger-runneutrallevel of thefedfundsrate(thelevel of thefedfundsratethat is neither
stimulative to theeconomy nor contractionary)is likely to remainrelativelylowwhichshouldwarrantagradualpace of
ratehikes.FedChairYellenindicatedthecurrentlevel of thefedfundsrate is belowtheneutralrate,butnot
significantlylower.TheFOMCdid not make any decisions about theirbalancesheetreinvestmentplans and will
continue that discussion during future meetings.
TheTreasuryyieldcurvecontinued to flattenmodestly in March.Short-termTreasuryyields(under2-yearmaturities)
increasedwhiletherest of Treasuryyieldcurvewasessentiallyunchanged.Meanwhilesovereignyields in Germany
increased in March,and yields in Japanwerelittlechanged.At the endof2016,followingtheelection,US Treasury
yieldsincreasedmeaningfullydriven by heightenedexpectationsforfiscalstimulus and growth under theTrump
administration and Republican-controlledCongress.Some of thepost-electionexuberanceregardingfiscalspending,
taxreform,and healthcarereform has started to wane,as marketparticipantsbegin to sensethetimeline and
magnitude of such policies may be delayed or potentially less robust than previously hoped.
3
Nonfarmpayrollsweresignificantlylowerthanexpected in March,up 98,000versustheconsensusforecast of 175,000.January and
Februarypayrollswerereviseddown by 38,000.On atrailing3-month and 6-monthbasis,payrollsincreased byan average of 178,000
and 163,000 per month,respectively.Theunemploymentratefell to 4.5%in Marchfrom4.7%in February.Theparticipationratewas
unchanged at 63.0%.Abroadermeasure of unemploymentcalledtheU-6,whichincludesthosewhoaremarginallyattached to the
laborforce and employedparttimeforeconomicreasons,decreased to 8.9%in Marchfrom9.2%in February.Wagegrowthrose0.2%
in March,versusexpectationsfora0.3%increase.Thisfollows an upwardlyrevisedgain of 0.3%in February(previously0.2%).On a
year-over-year basis, wages were up 2.7% in March, vs. 2.8% in February.
Employment
Source: US Department of Labor Source: US Department of Labor
0
50
100
150
200
250
300
350
400
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
TheConsumerPriceIndex(CPI)was up 2.4%year-over-year in March,versus up 2.7%year-over-year in February.CoreCPI(CPIless
food and energy)was up 2.0%year-over-year in March,versus up 2.2%year-over-year in February.ThePersonalConsumption
Expenditures(PCE)indexwas up 2.1%year-over-year in February,versus up 1.9%year-over-year in January.CorePCE(excluding
food and energy)was up 1.8%year-over-year in February,versus up 1.7%year-over-year in January.CoreCPI isin linewiththeFed's
2.0% target, and the Fed's primary inflation gauge (PCE) may be approaching the Fed'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
On ayear-over-yearbasis,totalretailsaleswere up 5.2%in Marchcomparedwitha5.1%increase in February.On amonth-over-
monthbasis,retailsalesdeclined0.2%in March,followingadownwardlyrevised0.3%decrease in February(previouslyreported up
0.1%).Excludingautos and gas,retailsalesincreased0.1%in March,followinga0.1%gain in February.Overall,Marchretailsales
trends and thedownwardrevisions to Februarysalesresultsweredisappointing.Meanwhile,theconsumerconfidenceindexremained
robust in March at 125.6 versus 116.1 in February.
Consumer
Source: US Department of Commerce Source: Federal Reserve
0.0%
1.0%
2.0%
3.0%
4.0%
5.0%
6.0%
7.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
TheIndex of LeadingEconomicIndicators(LEI)rose0.6%in February,exceedingexpectations of 0.4%,followinga0.6%increase in
January.TheLEIsuggeststhateconomicgrowthmay be accelerating.Meanwhile,theChicagoFedNationalActivityIndex(CFNAI)also
suggeststhatthepace of economicgrowth is increasing.TheCFNAIincreased to 0.25 in February on a3-monthmovingaveragebasis
from0.07 in January.Notably,areadingabove0.70 on athree-monthmovingaveragebasismaypoint to asustainedincrease in
inflation.
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
Totalhousingstartsrose3.0%in February,followinga1.9%decrease in January.Single-familystartsrose6.5%in February,but multi-
familystartsdeclined3.7%.On ayear-over-yearbasis,totalhousingstartswere up 6.2%in February.Permitswereweakerthan
expected in February,due to adecline in multi-familypermits.According to theCase-Shiller20-Cityhomepriceindex,homeprices
were up 5.7% year-over-year in January, compared to 5.5% in December.
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
TheInstituteforSupplyManagement(ISM)manufacturingindexdecreased to 57.2 in Marchfrom57.7 in February,suggestingthat
manufacturingactivityremainsabovetrend.Notably,areadingabove50.0suggeststhemanufacturingsector is expanding.Meanwhile,
capacityutilization,which is productiondivided by capacity,decreased to 75.4%in Februaryfrom75.5%in January.Thecapacity
utilizationrateremainsbelowthelong-runaverage of 79.9%(1972-2016),suggestingthere is stillexcesscapacity in theindustrial
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
According to thethirdestimate,fourthquarterrealGDPgrew atan annualizedrate of 2.1%,0.2%highercompared to theprior
estimate.Thiscompares to growth of 3.5%in thethirdquarter of2016.Personalconsumptionexpenditurescontinued to fuelGDP
growth in thefourthquarter,while net exportsdetractedfromgrowth.MarketparticipantsareforecastingGDPgrowth of 1.5%in thefirst
quarter of 2017.
Gross Domestic Product (GDP)
Source: US Department of Commerce Source: US Department of Commerce
3/166/169/1612/16
1.1%2.9%2.0%2.4%
-0.6%-1.3%0.5%1.5%
0.0%0.2%0.9%-1.8%
-0.1%0.0%0.2%-0.1%
0.4%-0.3%0.0%0.1%
0.8%1.4%3.5%2.1%
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
Source: Bloomberg
Overthepastthreemonths,theyieldcurveflattened,followingadramaticpost-electioncurvesteepener.In thepastthreemonths,the
2-yearTreasuryyield is upabout 7basispoints and the10-yearTreasuryyield is down about 6basispoints.Notably,shorter-term
yields(1-year and under)are up morethan 20 basispointsduringthattimeperiod.On ayear-over-yearbasisthe2-yearTreasuryyield
has increased 53 basis points and 10-year Treasury yield is up about 62 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
Mar-17
Dec-16
Mar-16
Yi
e
l
d
(
%
)
11
SECTION 2
Account Profile
12
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
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 issuerComplies
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 maturityComplies
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
March 31, 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
Portfolio Characteristics
City of Dublin
3/31/2017 12/31/2016
Benchmark* Portfolio Portfolio
Average Maturity (yrs) 2.71 2.59 2.67
Modified Duration 2.60 2.37 2.46
Average Purchase Yield n/a 1.47% 1.43%
Average Market Yield 1.47% 1.57% 1.52%
Average Quality** AAA AA/Aa1 AA/Aa1
Contributions/Withdrawals -313
Total Market Value 147,286,090 146,650,812
*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
ABS
8.1%
Agency
36.6%
Commercial
Paper
2.0%
Money Market
Fund FI
0.8%
US Corporate
23.8%
US Treasury
28.6%
Sector Distribution
City of Dublin
March 31, 2017 December 31, 2016
ABS
7.7%
Agency
37.8%
Commercial
Paper
2.0%
Money Market
Fund FI
0.1%
US Corporate
22.6%
US Treasury
28.6%
Negotiable CD
1.3%
16
Issuers
City of Dublin – Account #10198 As of 3/31/2017
Issue Name Investment Type % Portfolio
Government of United States US Treasury 28.63%
Federal National Mortgage Association Agency 14.88%
Federal Home Loan Bank Agency 14.02%
Federal Home Loan Mortgage Corp Agency 7.75%
Honda ABS ABS 2.33%
John Deere ABS ABS 2.19%
Bank of Tokyo-Mit UFJ Commercial Paper 1.99%
Pepsico Inc US Corporate 1.89%
Wells Fargo Corp US Corporate 1.31%
JP Morgan ABS ABS 1.28%
Chubb Corporation US Corporate 1.27%
Toyota ABS ABS 1.27%
Honda Motor Corporation US Corporate 1.24%
JP Morgan Chase & Co US Corporate 1.23%
Microsoft US Corporate 1.23%
Exxon Mobil Corp US Corporate 1.23%
State Street Bank US Corporate 1.21%
Deere & Company US Corporate 1.20%
Bank of New York US Corporate 1.20%
ChevronTexaco Corp US Corporate 1.20%
Apple Inc US Corporate 1.19%
Qualcomm Inc US Corporate 1.18%
United Technology Corp US Corporate 1.09%
Eli Lilly & Co US Corporate 1.08%
Nissan ABS ABS 1.06%
HSBC USA Corp US Corporate 1.03%
US Bancorp US Corporate 1.02%
Cisco Systems US Corporate 0.93%
Oracle Corp US Corporate 0.87%
First American Govt Oblig Fund Money Market Fund FI 0.83%
17
Issuers
City of Dublin – Account #10198 As of 3/31/2017
Issue Name Investment Type % Portfolio
Berkshire Hathaway US Corporate 0.69%
General Electric Co US Corporate 0.51%
Total 100.00%
18
AAA AA A <A NR
03/31/17 5.8% 75.0% 14.9% 0.0% 4.4%
12/31/16 5.9% 77.4% 13.6% 0.0% 3.1%
Source: S&P Ratings
Quality Distribution
March 31, 2017 vs. December 31, 2016
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
3/31/2017 12/31/2016
19
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+
3/31/2017 12/31/2016
Duration Distribution
City of Dublin
March 31, 2017 vs. December 31, 2016
0 - 0.25 0.25 - 0.50 0.50 - 1 1 - 2 2 - 3 3 - 4 4 - 5 5+
03/31/17 3.5% 5.3% 13.8% 17.7% 24.9% 21.4% 13.4% 0.0%
12/31/16 4.0% 4.1% 11.1% 17.7% 29.0% 22.3% 11.9% 0.0%
20
Investment Performance
-0.20%
0.00%
0.20%
0.40%
0.60%
0.80%
1.00%
1.20%
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
March 31, 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.43% 0.25% 0.97% 1.12% N/A N/A 1.03%
BAML 1-5 Yr US Treasury/Agency Index 0.37% -0.09% 0.76% 0.97% N/A N/A 0.88%
*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
Portfolio Characteristics
City of Dublin Reporting Account
3/31/2017 12/31/2016
Portfolio Portfolio
Average Maturity (yrs) 0.00 0.00
Modified Duration 0.00 0.00
Average Purchase Yield 0.88% 0.67%
Average Market Yield 0.88% 0.67%
Average Quality NR/NR NR/NR
Contributions/Withdrawals 29,050,000
Total Market Value 88,821,255 59,664,840
22
LAIF
56.4%
Local Gov
Investment Pool
43.6%
Sector Distribution
City of Dublin Reporting Account
March 31, 2017 December 31, 2016
LAIF
83.8%
Local Gov
Investment Pool
16.2%
23
Issuers
City of Dublin Reporting Account – Account #10219 As of 3/31/2017
Issue Name Investment Type % Portfolio
Local Agency Investment Fund LAIF 56.38%
CAMP Local Gov Investment Pool 43.62%
Total 100.00%
24
SECTION 3
Consolidated Information
25
Portfolio Characteristics
City of Dublin Consolidated
3/31/2017 12/31/2016
Portfolio Portfolio
Average Maturity (yrs) 1.62 1.89
Modified Duration 1.48 1.75
Average Purchase Yield 1.25% 1.21%
Average Market Yield 1.31% 1.27%
Average Quality AA/Aa1 AA/Aa1
Contributions/Withdrawals
Total Market Value 236,107,345 206,315,652
26
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%
Sector Distribution
City of Dublin Consolidated
March 31, 2017 December 31, 2016
ABS
5.5%
Agency
26.9%
Commercial
Paper
1.4%
LAIF
24.2% Local Gov
Investment Pool
4.7%
Money Market
Fund FI
0.0%
US Corporate
16.1%
US Treasury
20.3%
Negotiable CD
0.9%
27
SECTION 4
Portfolio Holdings
28
Holdings Report
For the Month Ending 3/31/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
89231TAB6 Toyota Auto Receivables Owner 2015-C
0.920% Due 02/15/2018
28,452.19 08/18/2015
0.67%
28,449.90
28,451.38
99.99
1.43%
28,448.58
11.63
0.02%
(2.80)
Aaa / AAA
NR
0.88
0.02
43814GAC4 Honda Auto Receivables 2014-2 A3
0.770% Due 03/19/2018
122,317.65 05/13/2014
0.29%
122,302.96
122,317.02
99.93
1.32%
122,230.56
34.01
0.08%
(86.46)
Aaa / AAA
NR
0.97
0.13
47787VAC5 John Deere Owner Trust 2014-A A3
0.920% Due 04/16/2018
136,380.26 04/02/2014
0.85%
136,358.41
136,379.98
99.96
1.29%
136,322.16
55.76
0.09%
(57.82)
Aaa / NR
AAA
1.04
0.12
43814NAB1 Honda Auto Receivables 2016-1 A2
1.010% Due 06/18/2018
581,338.68 02/16/2016
0.68%
581,280.61
581,308.20
99.98
1.10%
581,221.83
212.03
0.39%
(86.37)
NR / AAA
AAA
1.22
0.22
89236WAC2 Toyota Auto Receivables Owner 2015-A
1.120% Due 02/15/2019
629,452.80 02/24/2015
0.67%
629,357.64
629,424.58
99.90
1.35%
628,840.97
313.33
0.43%
(583.61)
Aaa / AAA
NR
1.88
0.43
47788NAB4 John Deere Owner Trust 2016-B A2
1.090% Due 02/15/2019
1,325,000.00 07/19/2016
0.98%
1,324,919.18
1,324,940.66
99.91
1.28%
1,323,823.40
641.89
0.90%
(1,117.26)
Aaa / NR
AAA
1.88
0.47
43813NAC0 Honda Auto Receivables 2015-2 A3
1.040% Due 02/21/2019
1,047,738.15 05/13/2015
0.45%
1,047,577.32
1,047,657.21
99.85
1.35%
1,046,169.69
302.68
0.71%
(1,487.52)
NR / AAA
AAA
1.90
0.48
65478WAB1 Nissan Auto Receivables Owner 2016-C A2A
1.070% Due 05/15/2019
930,000.00 08/02/2016
0.91%
929,963.36
929,971.87
99.88
1.30%
928,865.40
442.27
0.63%
(1,106.47)
Aaa / NR
AAA
2.12
0.54
89231LAB3 Toyota Auto Receivables Owner 2016-D
1.060% Due 05/15/2019
1,215,000.00 10/04/2016
0.93%
1,214,902.80
1,214,920.39
99.83
1.32%
1,212,899.27
572.40
0.82%
(2,021.12)
Aaa / AAA
NR
2.12
0.66
43814TAB8 Honda Auto Receivables 2017-1 A2
1.420% Due 07/22/2019
870,000.00 03/21/2017
1.43%
869,979.21
869,979.31
100.03
1.39%
870,242.73
102.95
0.59%
263.42
Aaa / NR
AAA
2.31
0.83
161571HH0 Chase CHAIT Pool #2016-A7
1.060% Due 09/16/2019
1,880,000.00 09/06/2016
0.80%
1,879,837.94
1,879,926.26
99.92
1.25%
1,878,460.28
885.69
1.28%
(1,465.98)
Aaa / AAA
AAA
2.46
0.44
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.46
99.98
1.53%
654,842.80
791.46
0.45%
(154.66)
Aaa / NR
AAA
2.54
1.06
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,996.80
100.00
1.48%
629,996.85
411.60
0.43%
0.05
Aaa / NR
AAA
2.79
1.04
47788MAC4 John Deere Owner Trust 2016-A A3
1.360% Due 04/15/2020
1,115,000.00 02/23/2016
1.16%
1,114,824.50
1,114,870.56
99.79
1.54%
1,112,681.92
673.96
0.76%
(2,188.64)
Aaa / NR
AAA
3.04
1.18
43814QAC2 Honda Auto Receivables 2016-2 A3
1.390% Due 04/15/2020
805,000.00 05/24/2016
1.27%
804,984.38
804,987.75
99.80
1.54%
803,402.88
497.31
0.55%
(1,584.87)
Aaa / NR
AAA
3.04
1.34
Total ABS 11,970,679.73 0.98%
11,969,732.38
11,970,129.43
1.36%
11,958,449.32
5,948.97
8.12%
(11,680.11)
Aaa / AAA
Aaa
2.27
0.68
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.89
1.01%
1,997,852.00
5,808.33
1.36%
(2,148.00)
Aaa / AA+
AAA
0.66
0.65
313381B20 FHLB Note
0.750% Due 12/08/2017
4,000,000.00 12/13/2012
0.75%
3,999,960.00
3,999,994.49
99.77
1.08%
3,990,968.00
9,416.67
2.72%
(9,026.49)
Aaa / AA+
AAA
0.69
0.68
3135G0TG8 FNMA Note
0.875% Due 02/08/2018
3,000,000.00 01/21/2015
0.97%
2,991,390.00
2,997,578.68
99.81
1.10%
2,994,315.00
3,864.58
2.04%
(3,263.68)
Aaa / AA+
AAA
0.86
0.85
City of Dublin - Account #10198
29
Holdings Report
For the Month Ending 3/31/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
3137EADP1 FHLMC Note
0.875% Due 03/07/2018
3,000,000.00 01/27/2015
1.01%
2,987,610.00
2,996,285.19
99.77
1.12%
2,993,214.00
1,750.00
2.03%
(3,071.19)
Aaa / AA+
AAA
0.93
0.93
313378A43 FHLB Note
1.375% Due 03/09/2018
4,000,000.00 Various
0.96%
4,047,840.00
4,015,471.45
100.23
1.13%
4,009,176.00
3,361.12
2.72%
(6,295.45)
Aaa / AA+
AAA
0.94
0.93
313379DT3 FHLB Note
1.250% Due 06/08/2018
2,000,000.00 08/18/2015
1.12%
2,007,360.00
2,003,112.19
100.09
1.17%
2,001,800.00
7,847.22
1.36%
(1,312.19)
Aaa / AA+
AAA
1.19
1.17
3135G0G72 FNMA Note
1.125% Due 12/14/2018
2,500,000.00 12/18/2015
1.37%
2,481,975.00
2,489,704.73
99.76
1.27%
2,493,970.00
8,359.38
1.70%
4,265.27
Aaa / AA+
AAA
1.71
1.68
3133782M2 FHLB Note
1.500% Due 03/08/2019
2,750,000.00 04/24/2015
1.21%
2,779,892.50
2,764,956.84
100.26
1.36%
2,757,262.75
2,635.42
1.87%
(7,694.09)
Aaa / AA+
AAA
1.94
1.90
3137EADG1 FHLMC Note
1.750% Due 05/30/2019
1,000,000.00 01/29/2015
1.28%
1,019,690.00
1,009,826.32
100.78
1.38%
1,007,834.00
5,881.94
0.69%
(1,992.32)
Aaa / AA+
AAA
2.16
2.11
3135G0ZG1 FNMA Note
1.750% Due 09/12/2019
2,500,000.00 10/28/2014
1.68%
2,508,350.00
2,504,196.12
100.63
1.49%
2,515,755.00
2,309.03
1.71%
11,558.88
Aaa / AA+
AAA
2.45
2.39
3137EADM8 FHLMC Note
1.250% Due 10/02/2019
2,500,000.00 12/18/2015
1.64%
2,464,700.00
2,476,637.07
99.44
1.48%
2,486,057.50
15,538.19
1.70%
9,420.43
Aaa / AA+
AAA
2.51
2.44
3135G0A78 FNMA Note
1.625% Due 01/21/2020
2,000,000.00 04/07/2015
1.44%
2,016,580.00
2,009,716.70
100.18
1.56%
2,003,688.00
6,319.44
1.36%
(6,028.70)
Aaa / AA+
AAA
2.81
2.72
313383HU8 FHLB Note
1.750% Due 06/12/2020
2,000,000.00 10/08/2015
1.46%
2,026,040.00
2,017,807.21
100.19
1.69%
2,003,788.00
10,597.22
1.37%
(14,019.21)
Aaa / AA+
NR
3.20
3.08
3135G0F73 FNMA Note
1.500% Due 11/30/2020
2,500,000.00 12/04/2015
1.87%
2,455,750.00
2,467,444.64
99.17
1.73%
2,479,225.00
12,604.17
1.69%
11,780.36
Aaa / AA+
AAA
3.67
3.53
3130A7CV5 FHLB Note
1.375% Due 02/18/2021
3,470,000.00 Various
1.45%
3,457,221.20
3,460,023.75
98.47
1.78%
3,416,884.71
5,698.99
2.32%
(43,139.04)
Aaa / AA+
AAA
3.89
3.75
3135G0J20 FNMA Note
1.375% Due 02/26/2021
5,000,000.00 Various
1.29%
5,018,675.00
5,015,860.06
98.24
1.84%
4,911,970.00
6,684.02
3.34%
(103,890.06)
Aaa / AA+
AAA
3.91
3.77
3130A8QS5 FHLB Note
1.125% Due 07/14/2021
2,500,000.00 07/25/2016
1.28%
2,481,475.00
2,484,017.85
96.87
1.89%
2,421,830.00
6,015.63
1.65%
(62,187.85)
Aaa / AA+
AAA
4.29
4.15
3137EAEC9 FHLMC Note
1.125% Due 08/12/2021
3,000,000.00 Various
1.33%
2,971,215.00
2,974,508.91
96.56
1.95%
2,896,911.00
4,593.76
1.97%
(77,597.91)
Aaa / AA+
AAA
4.37
4.22
3135G0Q89 FNMA Note
1.375% Due 10/07/2021
2,000,000.00 10/06/2016
1.45%
1,992,924.00
1,993,606.02
97.56
1.94%
1,951,126.00
13,291.67
1.33%
(42,480.02)
Aaa / AA+
AAA
4.52
4.32
3135G0S38 FNMA Note
2.000% Due 01/05/2022
2,500,000.00 01/30/2017
2.04%
2,495,475.00
2,495,625.83
99.96
2.01%
2,499,067.50
11,388.89
1.70%
3,441.67
Aaa / AA+
AAA
4.77
4.50
Total Agency 54,220,000.00 1.29%
54,204,122.70
54,176,374.05
1.50%
53,832,694.46
143,965.67
36.65%
(343,679.59)
Aaa / AA+
Aaa
2.55
2.47
City of Dublin - Account #10198
30
Holdings Report
For the Month Ending 3/31/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,925,668.33
99.68
1.20%
2,925,668.33
0.00
1.99%
0.00
P-1 / A-1
NR
0.27
0.27
Total Commercial Paper 2,935,000.00 1.20%
2,923,263.26
2,925,668.33
1.20%
2,925,668.33
0.00
1.99%
0.00
P-1 / A-1
NR
0.27
0.27
Money Market Fund FI
31846V203 First American Govt Obligation Fund
1,217,919.97 Various
0.34%
1,217,919.97
1,217,919.97
1.00
0.34%
1,217,919.97
0.00
0.83%
0.00
Aaa / AAA
NR
0.00
0.00
Total Money Market Fund FI 1,217,919.97 0.34%
1,217,919.97
1,217,919.97
0.34%
1,217,919.97
0.00
0.83%
0.00
Aaa / AAA
NR
0.00
0.00
US Corporate
91159HHD5 US Bancorp Callable Note Cont 4/15/2017
1.650% Due 05/15/2017
1,500,000.00 08/12/2016
0.95%
1,506,885.00
1,500,399.96
100.01
1.33%
1,500,130.50
9,350.00
1.02%
(269.46)
A1 / A+
AA
0.12
0.04
913017BU2 United Tech Corp Note
1.800% Due 06/01/2017
1,600,000.00 06/22/2015
1.04%
1,623,360.00
1,602,015.50
100.10
1.21%
1,601,563.20
9,600.00
1.09%
(452.30)
A3 / A-
A-
0.17
0.17
36962G6K5 General Electric Capital Corp Note
1.600% Due 11/20/2017
750,000.00 10/28/2014
1.31%
756,577.50
751,373.26
100.06
1.50%
750,463.50
4,366.67
0.51%
(909.76)
A1 / AA-
AA-
0.64
0.63
40428HPH9 HSBC USA Inc Note
1.625% Due 01/16/2018
500,000.00 11/25/2013
1.69%
498,705.00
499,751.46
99.94
1.70%
499,686.00
1,692.71
0.34%
(65.46)
A2 / A
AA-
0.80
0.78
713448CR7 PepsiCo Inc Note
1.250% Due 04/30/2018
1,430,000.00 Various
1.26%
1,429,428.40
1,429,794.35
99.95
1.30%
1,429,213.50
7,497.57
0.98%
(580.85)
A1 / A
A
1.08
1.07
037833AJ9 Apple Inc Note
1.000% Due 05/03/2018
1,750,000.00 Various
1.34%
1,726,740.00
1,743,652.75
99.70
1.28%
1,744,708.00
7,194.44
1.19%
1,055.25
Aa1 / AA+
NR
1.09
1.07
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,753,152.02
100.32
1.43%
1,755,619.25
8,100.85
1.20%
2,467.23
Aa2 / AA-
NR
1.23
1.13
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,944.32
100.66
1.57%
1,006,555.00
3,500.00
0.69%
4,610.68
A1 / A
AA-
1.34
1.23
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,460.02
100.74
1.45%
1,007,392.00
2,555.56
0.69%
5,931.98
Aa2 / AA
A+
1.38
1.35
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,817.27
101.04
1.57%
1,364,084.55
2,390.63
0.93%
12,267.28
A1 / AA-
NR
1.92
1.87
532457BF4 Eli Lilly & Co Note
1.950% Due 03/15/2019
1,575,000.00 Various
1.91%
1,577,796.75
1,576,270.97
100.70
1.59%
1,585,991.93
1,365.00
1.08%
9,720.96
A2 / AA-
A
1.96
1.91
94974BFU9 Wells Fargo Corp Note
2.125% Due 04/22/2019
1,900,000.00 Various
2.07%
1,904,120.50
1,902,156.23
100.38
1.94%
1,907,235.20
17,832.28
1.31%
5,078.97
A2 / A
AA-
2.06
1.99
02665WAH4 American Honda Finance Note
2.250% Due 08/15/2019
1,800,000.00 Various
2.08%
1,812,627.00
1,807,041.72
100.87
1.87%
1,815,737.40
5,175.00
1.24%
8,695.68
A1 / A+
NR
2.38
2.30
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
758,098.78
100.95
1.89%
757,109.25
958.33
0.51%
(989.53)
A1 / A
AA-
2.45
2.29
City of Dublin - Account #10198
31
Holdings Report
For the Month Ending 3/31/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
68389XAX3 Oracle Corp Note
2.250% Due 10/08/2019
1,250,000.00 Various
1.73%
1,272,172.50
1,265,809.10
101.22
1.75%
1,265,303.75
13,515.63
0.87%
(505.35)
A1 / AA-
A+
2.52
2.42
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,277.46
100.47
2.19%
1,004,692.00
9,104.17
0.69%
3,414.54
A2 / A
AA-
2.62
2.50
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,154.53
100.34
2.12%
1,806,197.40
7,650.00
1.23%
12,042.87
A3 / A-
A+
2.82
2.63
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,533.19
100.39
1.71%
1,335,238.87
10,320.43
0.91%
5,705.68
A1 / A
A
3.08
2.89
747525AD5 Qualcomm Inc Note
2.250% Due 05/20/2020
1,715,000.00 05/19/2015
2.27%
1,713,347.20
1,713,963.03
100.22
2.18%
1,718,798.73
14,041.57
1.18%
4,835.70
A1 / A+
NR
3.14
2.99
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,021,668.49
100.53
2.21%
1,005,294.00
5,079.86
0.69%
(16,374.49)
A2 / A
A
3.29
3.13
00440EAT4 ACE INA Holdings Inc Callable Note Cont 10/3/2020
2.300% Due 11/03/2020
1,850,000.00 02/14/2017
2.27%
1,852,220.00
1,852,147.90
100.36
2.19%
1,856,645.20
17,492.78
1.27%
4,497.30
A3 / A
A
3.60
3.32
24422ETF6 John Deere Capital Corp Note
2.550% Due 01/08/2021
750,000.00 Various
2.42%
753,733.15
753,479.31
100.75
2.34%
755,652.76
4,409.38
0.52%
2,173.45
A2 / A
A
3.78
3.56
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,703.63
100.19
2.17%
1,803,481.20
3,333.00
1.23%
(7,222.43)
Aaa / AA+
NR
3.92
3.73
857477AV5 State Street Bank Note
1.950% Due 05/19/2021
1,800,000.00 Various
1.91%
1,802,989.00
1,802,753.04
98.25
2.40%
1,768,483.81
12,870.00
1.21%
(34,269.23)
A1 / A
AA-
4.14
3.91
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,846,886.55
97.44
2.17%
1,802,691.80
4,221.60
1.23%
(44,194.75)
Aaa / AAA
AA+
4.36
4.17
Total US Corporate 34,800,000.00 1.82%
34,926,070.25
34,871,304.84
1.81%
34,847,968.80
183,617.46
23.78%
(23,336.04)
A1 / A+
A+
2.33
2.21
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,705.96
100.29
1.18%
2,005,860.00
75.14
1.36%
4,154.04
Aaa / AA+
AAA
1.50
1.48
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,146.71
100.47
1.25%
1,758,204.00
2,282.61
1.20%
8,057.29
Aaa / AA+
AAA
1.92
1.88
912828D80 US Treasury Note
1.625% Due 08/31/2019
3,000,000.00 Various
1.78%
2,977,822.56
2,989,198.58
100.60
1.37%
3,017,931.00
4,239.13
2.05%
28,732.42
Aaa / AA+
AAA
2.42
2.36
912828G61 US Treasury Note
1.500% Due 11/30/2019
6,500,000.00 Various
1.45%
6,510,978.81
6,507,635.35
100.17
1.44%
6,510,920.00
32,678.57
4.44%
3,284.65
Aaa / AA+
AAA
2.67
2.59
912828G95 US Treasury Note
1.625% Due 12/31/2019
3,000,000.00 01/08/2015
1.50%
3,017,470.99
3,009,675.05
100.46
1.45%
3,013,827.00
12,254.83
2.05%
4,151.95
Aaa / AA+
AAA
2.75
2.67
912828H52 US Treasury Note
1.250% Due 01/31/2020
4,500,000.00 Various
1.53%
4,440,542.42
4,465,729.57
99.36
1.48%
4,470,997.50
9,323.20
3.04%
5,267.93
Aaa / AA+
AAA
2.84
2.77
912828K58 US Treasury Note
1.375% Due 04/30/2020
1,750,000.00 05/06/2015
1.55%
1,735,171.88
1,740,834.27
99.47
1.55%
1,740,772.25
10,103.59
1.19%
(62.02)
Aaa / AA+
AAA
3.08
2.99
912828XE5 US Treasury Note
1.500% Due 05/31/2020
3,000,000.00 Various
1.67%
2,976,025.68
2,984,554.09
99.75
1.58%
2,992,500.00
15,082.42
2.04%
7,945.91
Aaa / AA+
AAA
3.17
3.07
City of Dublin - Account #10198
32
Holdings Report
For the Month Ending 3/31/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,505,190.95
100.01
1.62%
1,500,175.50
4,040.06
1.02%
(5,015.45)
Aaa / AA+
AAA
3.34
3.23
912828L99 US Treasury Note
1.375% Due 10/31/2020
5,000,000.00 Various
1.69%
4,927,376.14
4,946,890.62
98.91
1.69%
4,945,310.00
28,867.40
3.38%
(1,580.62)
Aaa / AA+
AAA
3.59
3.46
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,222.00
98.60
1.75%
1,971,954.00
4,558.01
1.34%
(19,268.00)
Aaa / AA+
AAA
3.84
3.71
912828S76 US Treasury Note
1.125% Due 07/31/2021
1,500,000.00 12/12/2016
1.89%
1,449,262.83
1,452,533.29
96.98
1.85%
1,454,766.00
2,796.96
0.99%
2,232.71
Aaa / AA+
AAA
4.34
4.20
912828T34 US Treasury Note
1.125% Due 09/30/2021
2,750,000.00 Various
1.65%
2,682,431.10
2,687,160.20
96.75
1.88%
2,660,517.75
84.53
1.81%
(26,642.45)
Aaa / AA+
AAA
4.50
4.36
912828U65 US Treasury Note
1.750% Due 11/30/2021
2,500,000.00 12/28/2016
2.06%
2,464,461.50
2,466,300.72
99.35
1.90%
2,483,692.50
14,663.46
1.70%
17,391.78
Aaa / AA+
AAA
4.67
4.43
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,364.52
99.78
1.92%
1,496,718.00
4,661.60
1.02%
(5,646.52)
Aaa / AA+
AAA
4.84
4.59
Total US Treasury 42,250,000.00 1.61%
41,935,215.79
42,001,141.88
1.57%
42,024,145.50
145,711.51
28.63%
23,003.62
Aaa / AA+
Aaa
3.20
3.09
TOTAL PORTFOLIO 147,393,599.70 1.48%
147,176,324.35
147,162,538.50 1.57%
146,806,846.38
479,243.61
100.00%
(355,692.12)
Aa1 / AA
Aaa
2.59
2.37
TOTAL MARKET VALUE PLUS ACCRUALS 147,286,089.99
City of Dublin - Account #10198
33
Holdings Report
For the Month Ending 3/31/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
49,978,566.40 Various
0.83%
49,978,566.40
49,978,566.40
1.00
0.83%
49,978,566.40
96,850.46
56.38%
0.00
NR / NR
NR
0.00
0.00
Total LAIF 49,978,566.40 0.83%
49,978,566.40
49,978,566.40
0.83%
49,978,566.40
96,850.46
56.38%
0.00
NR / NR
NR
0.00
0.00
Local Gov Investment Pool
90CAMP$00 Public Financial Management CAMP
38,745,837.98 Various
0.95%
38,745,837.98
38,745,837.98
1.00
0.95%
38,745,837.98
0.00
43.62%
0.00
NR / NR
NR
0.00
0.00
Total Local Gov Investment Pool 38,745,837.98 0.95%
38,745,837.98
38,745,837.98
0.95%
38,745,837.98
0.00
43.62%
0.00
NR / NR
NR
0.00
0.00
TOTAL PORTFOLIO 88,724,404.38 0.88%
88,724,404.38
88,724,404.38 0.88%
88,724,404.38
96,850.46
100.00%
0.00
NR / NR
NR
0.00
0.00
TOTAL MARKET VALUE PLUS ACCRUALS 88,821,254.84
City of Dublin Reporting Account - Account #10219
34
SECTION 5
Transactions
35
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 01/31/2017 3135G0S38 2,500,000.00 FNMA Note
2% Due: 01/05/2022 99.819 2.04% 2,495,475.00 3,055.56 2,498,530.56 0.00
Purchase 02/17/2017 00440EAT4 1,850,000.00 ACE INA Holdings Inc Callable Note Cont 10/3/2020
2.3% Due: 11/03/2020 100.120 2.27% 1,852,220.00 12,292.22 1,864,512.22 0.00
Purchase 02/28/2017 912828V72 1,500,000.00 US Treasury Note
1.875% Due: 01/31/2022 100.160 1.84% 1,502,407.37 2,175.41 1,504,582.78 0.00
Purchase 03/02/2017 47787XAB3 655,000.00 John Deere Owner Trust 2017-A A2
1.5% Due: 10/15/2019 100.000 1.50% 654,997.38 0.00 654,997.38 0.00
Purchase 03/07/2017 06538BU76 2,935,000.00 Bank of Tokyo Mitsubishi NY Discount CP
1.18% Due: 07/07/2017 99.600 1.20% 2,923,263.26 0.00 2,923,263.26 0.00
Purchase 03/28/2017 43814TAB8 870,000.00 Honda Auto Receivables 2017-1 A2
1.42% Due: 07/22/2019 99.998 1.43% 869,979.21 0.00 869,979.21 0.00
Purchase 03/28/2017 654747AB0 630,000.00 Nissan Auto Receivables 2017-A A2A
1.47% Due: 01/15/2020 99.999 1.47% 629,996.79 0.00 629,996.79 0.00
Subtotal 10,940,000.00 10,928,339.01 17,523.19 10,945,862.20 0.00
TOTAL ACQUISITIONS 10,940,000.00 10,928,339.01 17,523.19 10,945,862.20 0.00
DISPOSITIONS
Sale 01/31/2017 3133ECMM3 2,000,000.00 FFCB Note
0.6% Due: 04/25/2017 100.012 0.55% 2,000,240.00 3,200.00 2,003,440.00 330.84
Sale 02/15/2017 3134G3Y53 2,000,000.00 FHLMC Callable Note 1X 11/28/14
0.85% Due: 11/28/2017 99.998 0.85% 1,999,960.00 3,636.11 2,003,596.11 -40.00
Sale 02/28/2017 912828C24 1,250,000.00 US Treasury Note
1.5% Due: 02/28/2019 100.648 1.17% 1,258,101.29 0.00 1,258,101.29 7991.69
Subtotal 5,250,000.00 5,258,301.29 6,836.11 5,265,137.40 8,282.53
Maturity 03/01/2017 06417GNP9 1,850,000.00 Bank of Nova Scotia Yankee CD
1.26% Due: 03/01/2017 100.000 1,850,000.00 11,849.25 1,861,849.25 0.00
December 31, 2016 through March 31, 2017
36
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 03/06/2017 06538BQ63 2,960,000.00 Bank of Tokyo Mitsubishi NY Discount CP
1.03% Due: 03/06/2017 99.628 2,960,000.00 0.00 2,960,000.00 0.00
Subtotal 4,810,000.00 4,810,000.00 11,849.25 4,821,849.25 0.00
TOTAL DISPOSITIONS 11,518,688.41 11,526,989.70 48,399.99 11,575,389.69 8,282.53
December 31, 2016 through March 31, 2017
37
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 01/15/2017 90LAIF$00 84,985.60 Local Agency Investment Fund State Pool 1.000 0.67% 84,985.60 0.00 84,985.60 0.00
Purchase 01/27/2017 90CAMP$00 7,018.23 Public Financial Management CAMP 1.000 0.66% 7,018.23 0.00 7,018.23 0.00
Purchase 02/28/2017 90CAMP$00 2,605.36 Public Financial Management CAMP 1.000 0.83% 2,605.36 0.00 2,605.36 0.00
Purchase 03/31/2017 90CAMP$00 6,940.35 Public Financial Management CAMP 1.000 0.95% 6,940.35 0.00 6,940.35 0.00
Subtotal 101,549.54 101,549.54 0.00 101,549.54 0.00
Security
Contribution 01/04/2017 90CAMP$00 5,000,000.00 Public Financial Management CAMP 1.000 5,000,000.00 0.00 5,000,000.00 0.00
Security
Contribution 02/17/2017 90CAMP$00 1,800,000.00 Public Financial Management CAMP 1.000 1,800,000.00 0.00 1,800,000.00 0.00
Security
Contribution 02/24/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
Security
Contribution 03/10/2017 90CAMP$00 1,500,000.00 Public Financial Management CAMP 1.000 1,500,000.00 0.00 1,500,000.00 0.00
Security
Contribution 03/27/2017 90CAMP$00 28,500,000.00 Public Financial Management CAMP 1.000 28,500,000.00 0.00 28,500,000.00 0.00
Security
Contribution 03/31/2017 90CAMP$00 6,500,000.00 Public Financial Management CAMP 1.000 6,500,000.00 0.00 6,500,000.00 0.00
Subtotal 44,300,000.00 44,300,000.00 0.00 44,300,000.00 0.00
TOTAL ACQUISITIONS 44,401,549.54 44,401,549.54 0.00 44,401,549.54 0.00
DISPOSITIONS
Security
Withdrawal 01/06/2017 90CAMP$00 850,000.00 Public Financial Management CAMP 1.000 850,000.00 0.00 850,000.00 0.00
Security
Withdrawal 01/13/2017 90CAMP$00 4,300,000.00 Public Financial Management CAMP 1.000 4,300,000.00 0.00 4,300,000.00 0.00
Security
Withdrawal 01/20/2017 90CAMP$00 2,100,000.00 Public Financial Management CAMP 1.000 2,100,000.00 0.00 2,100,000.00 0.00
Security
Withdrawal 01/27/2017 90CAMP$00 1,500,000.00 Public Financial Management CAMP 1.000 1,500,000.00 0.00 1,500,000.00 0.00
Security
Withdrawal 02/03/2017 90CAMP$00 900,000.00 Public Financial Management CAMP 1.000 900,000.00 0.00 900,000.00 0.00
Security
Withdrawal 02/13/2017 90CAMP$00 3,600,000.00 Public Financial Management CAMP 1.000 3,600,000.00 0.00 3,600,000.00 0.00
Security
Withdrawal 03/03/2017 90CAMP$00 900,000.00 Public Financial Management CAMP 1.000 900,000.00 0.00 900,000.00 0.00
December 31, 2016 through March 31, 2017
38
Transaction Ledger
City of Dublin Reporting Account - Account #10219
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price
Acq/Disp
Yield Amount
Interest
Pur/Sold Total Amount Gain/Loss
Security
Withdrawal 03/20/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
Subtotal 15,250,000.00 15,250,000.00 0.00 15,250,000.00 0.00
TOTAL DISPOSITIONS 15,250,000.00 15,250,000.00 0.00 15,250,000.00 0.00
December 31, 2016 through March 31, 2017
39
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
Transaction Ledger
12/31/16 Thru 1/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 01/03/2017 31846V203 77.51 First American Govt Obligation Fund 1.000 0.01 %77.51 0.00 77.51 0.00
Purchase 01/08/2017 31846V203 9,562.50 First American Govt Obligation Fund 1.000 0.01 %9,562.50 0.00 9,562.50 0.00
Purchase 01/14/2017 31846V203 25,937.50 First American Govt Obligation Fund 1.000 0.01 %25,937.50 0.00 25,937.50 0.00
Purchase 01/15/2017 90LAIF$00 84,985.60 Local Agency Investment Fund State Pool 1.000 0.67 %84,985.60 0.00 84,985.60 0.00
Purchase 01/16/2017 31846V203 4,062.50 First American Govt Obligation Fund 1.000 0.01 %4,062.50 0.00 4,062.50 0.00
Purchase 01/17/2017 31846V203 1,203.54 First American Govt Obligation Fund 1.000 0.01 %1,203.54 0.00 1,203.54 0.00
Purchase 01/17/2017 31846V203 1,263.67 First American Govt Obligation Fund 1.000 0.01 %1,263.67 0.00 1,263.67 0.00
Purchase 01/17/2017 31846V203 1,073.25 First American Govt Obligation Fund 1.000 0.01 %1,073.25 0.00 1,073.25 0.00
Purchase 01/17/2017 31846V203 829.25 First American Govt Obligation Fund 1.000 0.01 %829.25 0.00 829.25 0.00
Purchase 01/17/2017 31846V203 1,660.67 First American Govt Obligation Fund 1.000 0.01 %1,660.67 0.00 1,660.67 0.00
Purchase 01/17/2017 31846V203 932.46 First American Govt Obligation Fund 1.000 0.01 %932.46 0.00 932.46 0.00
Purchase 01/17/2017 31846V203 73,196.88 First American Govt Obligation Fund 1.000 0.01 %73,196.88 0.00 73,196.88 0.00
Purchase 01/17/2017 31846V203 61,425.25 First American Govt Obligation Fund 1.000 0.01 %61,425.25 0.00 61,425.25 0.00
Purchase 01/17/2017 31846V203 60,905.60 First American Govt Obligation Fund 1.000 0.01 %60,905.60 0.00 60,905.60 0.00
Purchase 01/17/2017 31846V203 66,030.53 First American Govt Obligation Fund 1.000 0.01 %66,030.53 0.00 66,030.53 0.00
Purchase 01/18/2017 31846V203 40,939.35 First American Govt Obligation Fund 1.000 0.01 %40,939.35 0.00 40,939.35 0.00
Purchase 01/18/2017 31846V203 109,119.21 First American Govt Obligation Fund 1.000 0.01 %109,119.21 0.00 109,119.21 0.00
Purchase 01/21/2017 31846V203 16,250.00 First American Govt Obligation Fund 1.000 0.01 %16,250.00 0.00 16,250.00 0.00
Purchase 01/23/2017 31846V203 20,250.00 First American Govt Obligation Fund 1.000 0.01 %20,250.00 0.00 20,250.00 0.00
Purchase 01/23/2017 31846V203 108,537.21 First American Govt Obligation Fund 1.000 0.01 %108,537.21 0.00 108,537.21 0.00
Purchase 01/27/2017 90CAMP$00 7,018.23 Public Financial Management CAMP 1.000 0.66 %7,018.23 0.00 7,018.23 0.00
Purchase 01/31/2017 3135G0S38 2,500,000.00 FNMA Note
2% Due 1/5/2022
99.819 2.04 %2,495,475.00 3,055.56 2,498,530.56 0.00
Purchase 01/31/2017 31846V203 62,500.00 First American Govt Obligation Fund 1.000 0.19 %62,500.00 0.00 62,500.00 0.00
Subtotal 3,257,760.71 3,253,235.71 3,055.56 3,256,291.27 0.00
Security
Contribution
01/04/2017 90CAMP$00 5,000,000.00 Public Financial Management CAMP 1.000 5,000,000.00 0.00 5,000,000.00 0.00
Subtotal 5,000,000.00 5,000,000.00 0.00 5,000,000.00 0.00
TOTAL ACQUISITIONS 8,257,760.71 8,253,235.71 3,055.56 8,256,291.27 0.00
Execution Time: 2/17/2017 10:20:32 AMChandler Asset Management - CONFIDENTIAL Page 7
Transaction Ledger
12/31/16 Thru 1/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 01/31/2017 3133ECMM3 2,000,000.00 FFCB Note
0.6% Due 4/25/2017
100.012 0.55 %2,000,240.00 3,200.00 2,003,440.00 330.84
Sale 01/31/2017 31846V203 495,090.56 First American Govt Obligation Fund 1.000 0.19 %495,090.56 0.00 495,090.56 0.00
Subtotal 2,495,090.56 2,495,330.56 3,200.00 2,498,530.56 330.84
Paydown 01/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 01/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 01/17/2017 47787VAC5 72,950.48 John Deere Owner Trust 2014-A A3
0.92% Due 4/16/2018
100.000 72,950.48 246.40 73,196.88 0.00
Paydown 01/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 01/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 01/17/2017 65478WAB1 0.00 Nissan Auto Receivables Owner 2016-C
A2A
1.07% Due 5/15/2019
100.000 0.00 829.25 829.25 0.00
Paydown 01/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 01/17/2017 89231MAC9 61,339.71 Toyota Auto Receivables Owner 2014-A
0.67% Due 12/15/2017
100.000 61,339.71 85.54 61,425.25 0.00
Paydown 01/17/2017 89231TAB6 60,747.19 Toyota Auto Receivables Owner 2015-C
0.92% Due 2/15/2018
100.000 60,747.19 158.41 60,905.60 0.00
Paydown 01/17/2017 89236WAC2 65,263.26 Toyota Auto Receivables Owner 2015-A
1.12% Due 2/15/2019
100.000 65,263.26 767.27 66,030.53 0.00
Paydown 01/18/2017 43814GAC4 40,785.86 Honda Auto Receivables 2014-2 A3
0.77% Due 3/19/2018
100.000 40,785.86 153.49 40,939.35 0.00
Paydown 01/18/2017 43814NAB1 108,360.21 Honda Auto Receivables 2016-1 A2
1.01% Due 6/18/2018
100.000 108,360.21 759.00 109,119.21 0.00
Paydown 01/23/2017 43813NAC0 107,358.47 Honda Auto Receivables 2015-2 A3
1.04% Due 2/21/2019
100.000 107,358.47 1,178.74 108,537.21 0.00
Subtotal 516,805.18 516,805.18 10,311.69 527,116.87 0.00
Security
Withdrawal
01/06/2017 90CAMP$00 850,000.00 Public Financial Management CAMP 1.000 850,000.00 0.00 850,000.00 0.00
Security
Withdrawal
01/13/2017 90CAMP$00 4,300,000.00 Public Financial Management CAMP 1.000 4,300,000.00 0.00 4,300,000.00 0.00
Security
Withdrawal
01/20/2017 90CAMP$00 2,100,000.00 Public Financial Management CAMP 1.000 2,100,000.00 0.00 2,100,000.00 0.00
Execution Time: 2/17/2017 10:20:32 AMChandler Asset Management - CONFIDENTIAL Page 8
Transaction Ledger
12/31/16 Thru 1/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
01/25/2017 31846V203 104.17 First American Govt Obligation Fund 1.000 104.17 0.00 104.17 0.00
Security
Withdrawal
01/27/2017 90CAMP$00 1,500,000.00 Public Financial Management CAMP 1.000 1,500,000.00 0.00 1,500,000.00 0.00
Subtotal 8,750,104.17 8,750,104.17 0.00 8,750,104.17 0.00
TOTAL DISPOSITIONS 11,761,999.91 11,762,239.91 13,511.69 11,775,751.60 330.84
OTHER TRANSACTIONS
Interest 01/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 01/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 01/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 01/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 01/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 01/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 01/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 01/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 01/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 01/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 18,050,000.00 138,562.50 0.00 138,562.50 0.00
Dividend 01/03/2017 31846V203 89,051.91 First American Govt Obligation Fund 0.000 77.51 0.00 77.51 0.00
Dividend 01/15/2017 90LAIF$00 4,589,156,162.0
8
Local Agency Investment Fund State Pool 0.000 84,985.60 0.00 84,985.60 0.00
Execution Time: 2/17/2017 10:20:32 AMChandler Asset Management - CONFIDENTIAL Page 9
Transaction Ledger
12/31/16 Thru 1/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 01/27/2017 90CAMP$00 9,679,274.04 Public Financial Management CAMP 0.000 7,018.23 0.00 7,018.23 0.00
Subtotal 4,598,924,488.0
3
92,081.34 0.00 92,081.34 0.00
TOTAL OTHER TRANSACTIONS 4,616,974,488.0
3
230,643.84 0.00 230,643.84 0.00
Execution Time: 2/17/2017 10:20:32 AMChandler Asset Management - CONFIDENTIAL Page 10
Transaction Ledger
1/31/17 Thru 2/28/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 02/01/2017 31846V203 10,500.00 First American Govt Obligation Fund 1.000 0.19 %10,500.00 0.00 10,500.00 0.00
Purchase 02/01/2017 31846V203 51.78 First American Govt Obligation Fund 1.000 0.19 %51.78 0.00 51.78 0.00
Purchase 02/08/2017 31846V203 27,462.50 First American Govt Obligation Fund 1.000 0.19 %27,462.50 0.00 27,462.50 0.00
Purchase 02/12/2017 31846V203 16,875.00 First American Govt Obligation Fund 1.000 0.19 %16,875.00 0.00 16,875.00 0.00
Purchase 02/15/2017 31846V203 2,003,596.11 First American Govt Obligation Fund 1.000 0.19 %2,003,596.11 0.00 2,003,596.11 0.00
Purchase 02/15/2017 31846V203 30,250.00 First American Govt Obligation Fund 1.000 0.19 %30,250.00 0.00 30,250.00 0.00
Purchase 02/15/2017 31846V203 1,203.54 First American Govt Obligation Fund 1.000 0.19 %1,203.54 0.00 1,203.54 0.00
Purchase 02/15/2017 31846V203 1,263.67 First American Govt Obligation Fund 1.000 0.19 %1,263.67 0.00 1,263.67 0.00
Purchase 02/15/2017 31846V203 932.46 First American Govt Obligation Fund 1.000 0.19 %932.46 0.00 932.46 0.00
Purchase 02/15/2017 31846V203 1,073.25 First American Govt Obligation Fund 1.000 0.19 %1,073.25 0.00 1,073.25 0.00
Purchase 02/15/2017 31846V203 1,660.67 First American Govt Obligation Fund 1.000 0.19 %1,660.67 0.00 1,660.67 0.00
Purchase 02/15/2017 31846V203 829.25 First American Govt Obligation Fund 1.000 0.19 %829.25 0.00 829.25 0.00
Purchase 02/15/2017 31846V203 72,426.37 First American Govt Obligation Fund 1.000 0.19 %72,426.37 0.00 72,426.37 0.00
Purchase 02/15/2017 31846V203 60,924.34 First American Govt Obligation Fund 1.000 0.19 %60,924.34 0.00 60,924.34 0.00
Purchase 02/15/2017 31846V203 60,511.08 First American Govt Obligation Fund 1.000 0.19 %60,511.08 0.00 60,511.08 0.00
Purchase 02/15/2017 31846V203 67,151.05 First American Govt Obligation Fund 1.000 0.19 %67,151.05 0.00 67,151.05 0.00
Purchase 02/17/2017 00440EAT4 1,850,000.00 ACE INA Holdings Inc Callable Note Cont
10/3/2020
2.3% Due 11/3/2020
100.120 2.27 %1,852,220.00 12,292.22 1,864,512.22 0.00
Purchase 02/18/2017 31846V203 23,856.25 First American Govt Obligation Fund 1.000 0.19 %23,856.25 0.00 23,856.25 0.00
Purchase 02/21/2017 31846V203 105,820.65 First American Govt Obligation Fund 1.000 0.19 %105,820.65 0.00 105,820.65 0.00
Purchase 02/21/2017 31846V203 39,065.38 First American Govt Obligation Fund 1.000 0.19 %39,065.38 0.00 39,065.38 0.00
Purchase 02/21/2017 31846V203 108,592.99 First American Govt Obligation Fund 1.000 0.19 %108,592.99 0.00 108,592.99 0.00
Purchase 02/26/2017 31846V203 34,375.00 First American Govt Obligation Fund 1.000 0.19 %34,375.00 0.00 34,375.00 0.00
Purchase 02/28/2017 31846V203 46,875.00 First American Govt Obligation Fund 1.000 0.18 %46,875.00 0.00 46,875.00 0.00
Purchase 02/28/2017 90CAMP$00 2,605.36 Public Financial Management CAMP 1.000 0.83 %2,605.36 0.00 2,605.36 0.00
Purchase 02/28/2017 912828V72 1,500,000.00 US Treasury Note
1.875% Due 1/31/2022
100.160 1.84 %1,502,407.37 2,175.41 1,504,582.78 0.00
Subtotal 6,067,901.70 6,072,529.07 14,467.63 6,086,996.70 0.00
Security
Contribution
02/17/2017 90CAMP$00 1,800,000.00 Public Financial Management CAMP 1.000 1,800,000.00 0.00 1,800,000.00 0.00
Execution Time: 3/23/2017 7:36:09 AMChandler Asset Management - CONFIDENTIAL Page 8
Transaction Ledger
1/31/17 Thru 2/28/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
02/24/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 2,800,000.00 2,800,000.00 0.00 2,800,000.00 0.00
TOTAL ACQUISITIONS 8,867,901.70 8,872,529.07 14,467.63 8,886,996.70 0.00
DISPOSITIONS
Sale 02/15/2017 3134G3Y53 2,000,000.00 FHLMC Callable Note 1X 11/28/14
0.85% Due 11/28/2017
99.998 0.85 %1,999,960.00 3,636.11 2,003,596.11 -40.00
Sale 02/17/2017 31846V203 1,864,512.22 First American Govt Obligation Fund 1.000 0.19 %1,864,512.22 0.00 1,864,512.22 0.00
Sale 02/28/2017 31846V203 246,481.49 First American Govt Obligation Fund 1.000 0.18 %246,481.49 0.00 246,481.49 0.00
Sale 02/28/2017 912828C24 1,250,000.00 US Treasury Note
1.5% Due 2/28/2019
100.648 1.17 %1,258,101.29 0.00 1,258,101.29 7,991.69
Subtotal 5,360,993.71 5,369,055.00 3,636.11 5,372,691.11 7,951.69
Paydown 02/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 02/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 02/15/2017 47787VAC5 72,235.90 John Deere Owner Trust 2014-A A3
0.92% Due 4/16/2018
100.000 72,235.90 190.47 72,426.37 0.00
Paydown 02/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 02/15/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 02/15/2017 65478WAB1 0.00 Nissan Auto Receivables Owner 2016-C
A2A
1.07% Due 5/15/2019
100.000 0.00 829.25 829.25 0.00
Paydown 02/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 02/15/2017 89231MAC9 60,873.04 Toyota Auto Receivables Owner 2014-A
0.67% Due 12/15/2017
100.000 60,873.04 51.30 60,924.34 0.00
Paydown 02/15/2017 89231TAB6 60,399.24 Toyota Auto Receivables Owner 2015-C
0.92% Due 2/15/2018
100.000 60,399.24 111.84 60,511.08 0.00
Execution Time: 3/23/2017 7:36:09 AMChandler Asset Management - CONFIDENTIAL Page 9
Transaction Ledger
1/31/17 Thru 2/28/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 02/15/2017 89236WAC2 66,444.69 Toyota Auto Receivables Owner 2015-A
1.12% Due 2/15/2019
100.000 66,444.69 706.36 67,151.05 0.00
Paydown 02/21/2017 43813NAC0 104,734.96 Honda Auto Receivables 2015-2 A3
1.04% Due 2/21/2019
100.000 104,734.96 1,085.69 105,820.65 0.00
Paydown 02/21/2017 43814GAC4 38,938.06 Honda Auto Receivables 2014-2 A3
0.77% Due 3/19/2018
100.000 38,938.06 127.32 39,065.38 0.00
Paydown 02/21/2017 43814NAB1 107,925.19 Honda Auto Receivables 2016-1 A2
1.01% Due 6/18/2018
100.000 107,925.19 667.80 108,592.99 0.00
Subtotal 511,551.08 511,551.08 9,903.62 521,454.70 0.00
Security
Withdrawal
02/03/2017 90CAMP$00 900,000.00 Public Financial Management CAMP 1.000 900,000.00 0.00 900,000.00 0.00
Security
Withdrawal
02/13/2017 90CAMP$00 3,600,000.00 Public Financial Management CAMP 1.000 3,600,000.00 0.00 3,600,000.00 0.00
Security
Withdrawal
02/24/2017 31846V203 104.17 First American Govt Obligation Fund 1.000 104.17 0.00 104.17 0.00
Subtotal 4,500,104.17 4,500,104.17 0.00 4,500,104.17 0.00
TOTAL DISPOSITIONS 10,372,648.96 10,380,710.25 13,539.73 10,394,249.98 7,951.69
OTHER TRANSACTIONS
Interest 02/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 02/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 02/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 02/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 02/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 02/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 02/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 02/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
Execution Time: 3/23/2017 7:36:09 AMChandler Asset Management - CONFIDENTIAL Page 10
Transaction Ledger
1/31/17 Thru 2/28/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 02/28/2017 912828C24 3,000,000.00 US Treasury Note
1.5% Due 2/28/2019
0.000 22,500.00 0.00 22,500.00 0.00
Interest 02/28/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 26,120,000.00 190,193.75 0.00 190,193.75 0.00
Dividend 02/01/2017 31846V203 270,114.06 First American Govt Obligation Fund 0.000 51.78 0.00 51.78 0.00
Dividend 02/28/2017 90CAMP$00 1,436,292.27 Public Financial Management CAMP 0.000 2,605.36 0.00 2,605.36 0.00
Subtotal 1,706,406.33 2,657.14 0.00 2,657.14 0.00
TOTAL OTHER TRANSACTIONS 27,826,406.33 192,850.89 0.00 192,850.89 0.00
Execution Time: 3/23/2017 7:36:09 AMChandler Asset Management - CONFIDENTIAL Page 11
Transaction Ledger
2/28/17 Thru 3/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 03/01/2017 31846V203 1,861,849.25 First American Govt Obligation Fund 1.000 0.18 %1,861,849.25 0.00 1,861,849.25 0.00
Purchase 03/01/2017 31846V203 34,341.75 First American Govt Obligation Fund 1.000 0.18 %34,341.75 0.00 34,341.75 0.00
Purchase 03/01/2017 31846V203 100.79 First American Govt Obligation Fund 1.000 0.18 %100.79 0.00 100.79 0.00
Purchase 03/02/2017 47787XAB3 655,000.00 John Deere Owner Trust 2017-A A2
1.5% Due 10/15/2019
100.000 1.50 %654,997.38 0.00 654,997.38 0.00
Purchase 03/06/2017 31846V203 2,960,000.00 First American Govt Obligation Fund 1.000 0.18 %2,960,000.00 0.00 2,960,000.00 0.00
Purchase 03/07/2017 06538BU76 2,935,000.00 Bank of Tokyo Mitsubishi NY Discount CP
1.18% Due 7/7/2017
99.600 1.20 %2,923,263.26 0.00 2,923,263.26 0.00
Purchase 03/07/2017 31846V203 13,125.00 First American Govt Obligation Fund 1.000 0.18 %13,125.00 0.00 13,125.00 0.00
Purchase 03/08/2017 31846V203 20,625.00 First American Govt Obligation Fund 1.000 0.18 %20,625.00 0.00 20,625.00 0.00
Purchase 03/09/2017 31846V203 27,500.00 First American Govt Obligation Fund 1.000 0.18 %27,500.00 0.00 27,500.00 0.00
Purchase 03/11/2017 31846V203 8,625.00 First American Govt Obligation Fund 1.000 0.18 %8,625.00 0.00 8,625.00 0.00
Purchase 03/12/2017 31846V203 21,875.00 First American Govt Obligation Fund 1.000 0.18 %21,875.00 0.00 21,875.00 0.00
Purchase 03/15/2017 31846V203 15,356.25 First American Govt Obligation Fund 1.000 0.18 %15,356.25 0.00 15,356.25 0.00
Purchase 03/15/2017 31846V203 829.25 First American Govt Obligation Fund 1.000 0.18 %829.25 0.00 829.25 0.00
Purchase 03/15/2017 31846V203 1,660.67 First American Govt Obligation Fund 1.000 0.18 %1,660.67 0.00 1,660.67 0.00
Purchase 03/15/2017 31846V203 932.46 First American Govt Obligation Fund 1.000 0.18 %932.46 0.00 932.46 0.00
Purchase 03/15/2017 31846V203 1,263.67 First American Govt Obligation Fund 1.000 0.18 %1,263.67 0.00 1,263.67 0.00
Purchase 03/15/2017 31846V203 1,073.25 First American Govt Obligation Fund 1.000 0.18 %1,073.25 0.00 1,073.25 0.00
Purchase 03/15/2017 31846V203 1,203.54 First American Govt Obligation Fund 1.000 0.18 %1,203.54 0.00 1,203.54 0.00
Purchase 03/15/2017 31846V203 39,955.13 First American Govt Obligation Fund 1.000 0.18 %39,955.13 0.00 39,955.13 0.00
Purchase 03/15/2017 31846V203 31,021.89 First American Govt Obligation Fund 1.000 0.18 %31,021.89 0.00 31,021.89 0.00
Purchase 03/15/2017 31846V203 57,087.59 First American Govt Obligation Fund 1.000 0.18 %57,087.59 0.00 57,087.59 0.00
Purchase 03/15/2017 31846V203 61,559.68 First American Govt Obligation Fund 1.000 0.18 %61,559.68 0.00 61,559.68 0.00
Purchase 03/20/2017 31846V203 37,268.98 First American Govt Obligation Fund 1.000 0.18 %37,268.98 0.00 37,268.98 0.00
Purchase 03/20/2017 31846V203 104,732.93 First American Govt Obligation Fund 1.000 0.18 %104,732.93 0.00 104,732.93 0.00
Purchase 03/21/2017 31846V203 101,242.43 First American Govt Obligation Fund 1.000 0.18 %101,242.43 0.00 101,242.43 0.00
Purchase 03/28/2017 43814TAB8 870,000.00 Honda Auto Receivables 2017-1 A2
1.42% Due 7/22/2019
99.998 1.43 %869,979.21 0.00 869,979.21 0.00
Purchase 03/28/2017 654747AB0 630,000.00 Nissan Auto Receivables 2017-A A2A
1.47% Due 1/15/2020
99.999 1.47 %629,996.79 0.00 629,996.79 0.00
Purchase 03/31/2017 31846V203 29,218.75 First American Govt Obligation Fund 1.000 0.34 %29,218.75 0.00 29,218.75 0.00
Execution Time: 4/25/2017 12:57:46 PMChandler Asset Management - CONFIDENTIAL Page 8
Transaction Ledger
2/28/17 Thru 3/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 03/31/2017 90CAMP$00 6,940.35 Public Financial Management CAMP 1.000 0.95 %6,940.35 0.00 6,940.35 0.00
Subtotal 10,529,388.61 10,517,625.25 0.00 10,517,625.25 0.00
Security
Contribution
03/10/2017 90CAMP$00 1,500,000.00 Public Financial Management CAMP 1.000 1,500,000.00 0.00 1,500,000.00 0.00
Security
Contribution
03/27/2017 90CAMP$00 28,500,000.00 Public Financial Management CAMP 1.000 28,500,000.00 0.00 28,500,000.00 0.00
Security
Contribution
03/31/2017 90CAMP$00 6,500,000.00 Public Financial Management CAMP 1.000 6,500,000.00 0.00 6,500,000.00 0.00
Subtotal 36,500,000.00 36,500,000.00 0.00 36,500,000.00 0.00
TOTAL ACQUISITIONS 47,029,388.61 47,017,625.25 0.00 47,017,625.25 0.00
DISPOSITIONS
Sale 03/02/2017 31846V203 654,997.38 First American Govt Obligation Fund 1.000 0.18 %654,997.38 0.00 654,997.38 0.00
Sale 03/07/2017 31846V203 2,923,263.26 First American Govt Obligation Fund 1.000 0.18 %2,923,263.26 0.00 2,923,263.26 0.00
Sale 03/28/2017 31846V203 1,499,976.00 First American Govt Obligation Fund 1.000 0.18 %1,499,976.00 0.00 1,499,976.00 0.00
Subtotal 5,078,236.64 5,078,236.64 0.00 5,078,236.64 0.00
Paydown 03/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 03/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 03/15/2017 47787VAC5 39,820.04 John Deere Owner Trust 2014-A A3
0.92% Due 4/16/2018
100.000 39,820.04 135.09 39,955.13 0.00
Paydown 03/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 03/15/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 03/15/2017 65478WAB1 0.00 Nissan Auto Receivables Owner 2016-C
A2A
1.07% Due 5/15/2019
100.000 0.00 829.25 829.25 0.00
Paydown 03/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 03/15/2017 89231MAC9 31,004.58 Toyota Auto Receivables Owner 2014-A
0.67% Due 12/15/2017
100.000 31,004.58 17.31 31,021.89 0.00
Execution Time: 4/25/2017 12:57:46 PMChandler Asset Management - CONFIDENTIAL Page 9
Transaction Ledger
2/28/17 Thru 3/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 03/15/2017 89231TAB6 57,022.06 Toyota Auto Receivables Owner 2015-C
0.92% Due 2/15/2018
100.000 57,022.06 65.53 57,087.59 0.00
Paydown 03/15/2017 89236WAC2 60,915.34 Toyota Auto Receivables Owner 2015-A
1.12% Due 2/15/2019
100.000 60,915.34 644.34 61,559.68 0.00
Paydown 03/20/2017 43814GAC4 37,166.65 Honda Auto Receivables 2014-2 A3
0.77% Due 3/19/2018
100.000 37,166.65 102.33 37,268.98 0.00
Paydown 03/20/2017 43814NAB1 104,155.97 Honda Auto Receivables 2016-1 A2
1.01% Due 6/18/2018
100.000 104,155.97 576.96 104,732.93 0.00
Paydown 03/21/2017 43813NAC0 100,247.51 Honda Auto Receivables 2015-2 A3
1.04% Due 2/21/2019
100.000 100,247.51 994.92 101,242.43 0.00
Subtotal 430,332.15 430,332.15 9,499.32 439,831.47 0.00
Maturity 03/01/2017 06417GNP9 1,850,000.00 Bank of Nova Scotia Yankee CD
1.26% Due 3/1/2017
100.000 1,850,000.00 11,849.25 1,861,849.25 0.00
Maturity 03/06/2017 06538BQ63 2,960,000.00 Bank of Tokyo Mitsubishi NY Discount CP
1.03% Due 3/6/2017
99.628 2,960,000.00 0.00 2,960,000.00 0.00
Subtotal 4,810,000.00 4,810,000.00 11,849.25 4,821,849.25 0.00
Security
Withdrawal
03/03/2017 90CAMP$00 900,000.00 Public Financial Management CAMP 1.000 900,000.00 0.00 900,000.00 0.00
Security
Withdrawal
03/20/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
03/27/2017 31846V203 104.17 First American Govt Obligation Fund 1.000 104.17 0.00 104.17 0.00
Subtotal 2,000,104.17 2,000,104.17 0.00 2,000,104.17 0.00
TOTAL DISPOSITIONS 12,318,672.96 12,318,672.96 21,348.57 12,340,021.53 0.00
OTHER TRANSACTIONS
Interest 03/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 03/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 03/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 03/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
Execution Time: 4/25/2017 12:57:46 PMChandler Asset Management - CONFIDENTIAL Page 10
Transaction Ledger
2/28/17 Thru 3/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 03/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 03/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 03/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 03/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 03/31/2017 912828RH5 2,000,000.00 US Treasury Note
1.375% Due 9/30/2018
0.000 13,750.00 0.00 13,750.00 0.00
Interest 03/31/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 22,475,000.00 170,666.75 0.00 170,666.75 0.00
Dividend 03/01/2017 31846V203 2,105,070.88 First American Govt Obligation Fund 0.000 100.79 0.00 100.79 0.00
Dividend 03/31/2017 90CAMP$00 4,238,897.63 Public Financial Management CAMP 0.000 6,940.35 0.00 6,940.35 0.00
Subtotal 6,343,968.51 7,041.14 0.00 7,041.14 0.00
TOTAL OTHER TRANSACTIONS 28,818,968.51 177,707.89 0.00 177,707.89 0.00
Execution Time: 4/25/2017 12:57:46 PMChandler Asset Management - CONFIDENTIAL Page 11