HomeMy WebLinkAbout4.3 - 1832 Quarterly Investment Report
Page 1 of 5
STAFF REPORT
CITY COUNCIL
DATE: February 20, 2018
TO: Honorable Mayor and City Councilmembers
FROM:
Christopher L. Foss, City Manager
SUBJECT:
City Treasurer's Informational Report of Investments for the Quarter
Ending December 31, 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 December 31, 2017 including a monthly transaction ledger. The
City’s investment port folio for this period totaled $241,220,605 (book value) with an
average market yield of 1.77%. 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 does not include any adjustment to the amended budget for interest
revenue, which is currently at $1,326,000 in the General Fund.
DESCRIPTION:
The total investment portfolio of $241,220,605 (book value) is comprised of
$158,849,158 managed by Chandler Asset Management (Chandler), and $82,371,447
invested by the City in local government pools. The average market yield of the
Chandler portfolio and the local pools was 2.00 and 1.32%, respectively. The total
investment portfolio balance fluctuates throughout the year due to normal cash flow
needs and includes both discretionary and restricted funds.
Page 2 of 5
Economic Update Highlights
The following are some highlights from the Economic Update included in the attached
Investment Report prepared by Chandler (Attachment 1):
The Federal Open Market Committee (FOMC) raised the fed funds target rate by 25
basis points to a range of 1.25% - 1.50% at the December 13 meeting. The FOMC’s
economic projections indicate the Fed still plans to hike the fed funds rate three times in
2018 to a median level of 2.1%. The Fed also left its long-run fed funds rate forecast
unchanged at 2.8%. Chandler believes that the long-run forecast is too high and closer
to 2.0% - 2.5%.
GDP grew by 3.2% in the third quarter. The consensus estimate for the fourth quarter
GDP growth is 2.7%. The economic data has been favorable with the economy at or
near full employment, consumer confidence being strong, and leading indicators
suggesting the economy will continue to grow modestly. Tax reform may have the
propensity to prolong the current business cycle and provide a tailwind to economic
growth in 2018. Chandler is forecasting GDP growth of about 2.5% in 2018.
The Treasury yield curve continued to flatten in December. The 2 -year Treasury
increased about ten basis points to 1.88% and the 10-year Treasury yield was
essentially unchanged. On a year-over-year basis, the 2-year Treasury yield increased
nearly 70 basis points in 2017 and the 10-Year Treasury yield declined slightly.
City of Dublin Portfolio
The City's portfolio managed by Chandler has maintained a healthy balance of
investment types. In the September quarter the City utilized funds held in the Local
Government Investment Pools to meet cash flow needs. In the current quarter the City
deposited a property tax payment into the Local Government Investment Pools, which
saw an increase, as illustrated in Chart 1 below. The City left funding levels with
Chandler relatively unchanged, providing the opportunity to earn a higher rate of return
on the majority of its funds.
Page 3 of 5
Chart 1: Investments by Type, September 30, 2017 - December 31, 2017
The market value of the City's portfolio increased $21.8 million from September 30,
2017 (see Table 1 below), and $34.3 million from the same quarter the prior year . The
quarter-over-quarter increase was due to multiple payments made in the September
quarter and the receipt of property tax revenue in the current quarter.
Table 1: Portfolio Values and Yield to Maturity
Page 4 of 5
Overall market yield-to-maturity increased from 1.51%to 1.77% (see Table 2 below).
For detailed monthly transactions, see Attachment 2.
Table 2: Quarterly Holdings (Par Value) by Type, and YTM, 5 Quarters
Funds Managed by the City
The City participates in two local agency investment pools managed by government
finance professionals and treasurers: the Local Agency Investment Fund (LAIF) and the
California Asset Management Program (CAMP). The City has typically carried close to
the $50 million maximum allowable in LAIF with any excesses resulting fr om the timing
of large payments deposited into CAMP as a temporary holding place.
LAIF rates have increased to 1.20% as of December 2017, the highest in the seven
year period shown in Table 3 below.
Table 3: Quarterly LAIF Yields, Recent Eight Years
Page 5 of 5
NOTICING REQUIREMENTS/PUBLIC OUTREACH:
None.
ATTACHMENTS:
1. City of Dublin Investment Report for Period Ending December 2017
2. Transaction Ledger - October - December 2017
6225 Lusk Blvd | San Diego, CA 92121 | Phone 800.317.4747 | Fax 858.546.3741 | www.chandlerasset.com
CHANDLER ASSET MANAGEMENT
Period Ending
December 31, 2017
City of Dublin
Investment Report
Attachment I
Table of Contents
SECTION 1 Economic Update
SECTION 2 Account Profile
SECTION 3 Consolidated Information
SECTION 4 Portfolio Holdings
SECTION 5 Transactions
1
Attachment I
SECTION 1
Economic Update
2
Attachment I
GDPgrew by 3.2%in thethirdquarter,followinggrowth of 3.1%in thesecondquarter and 1.2%in thefirstquarter.
TheconsensusestimateforfourthquarterGDPgrowth is 2.7%.Overall,economicdata hasbeen favorable.The
economy is atornear fullemployment,consumerconfidence is strong,and leadingindicatorssuggesttheeconomy
willcontinue to growmodestly.Taxreformmayhavethepropensity to prolongthecurrentbusinesscycle and provide
atailwind to economicgrowth in 2018,even as we enterthethirdyear of monetarypolicytightening by theFed.We
are forecasting GDP growth of about 2.5% in 2018.
Economic Update
TheFederalOpenMarketCommittee(FOMC)raisedthefedfundstargetrate by25 basispoints to arange of 1.25%-
1.50%at theDecember 13 meeting.Nevertheless,theFedbelievesthestance of monetarypolicyremains
accommodative.Notablythereweretwodissentingvotes by FedPresidentsEvans and Kashkari,whopreferred to
keepthefedfundsrateunchanged.BothEvans and Kashkariwillrotate outas votingFOMCmembersthisyear.The
Fedsaideconomicactivity hadbeen “rising at asolidrate.”However,overallinflationforitemsotherthanfood and
energy has declined.TheFOMC’seconomicprojectionsindicatetheFedstillplans to hikethefedfundsratethree
times in 2018 to amedianlevel of 2.1%.TheFedalsoleftitslong-runfedfundsrateforecastunchanged at 2.8%.We
expecttheFed to remain on apathtowardmonetarypolicynormalizationthisyear.We alsobelievetheFed
Presidentsthatarerotating in as votingFOMCmembersthisyearmay be slightlymorehawkishthanlastyear's
votingmembers.However,we continue to believethattheFed’sterminalrateforecast is toohigh,and believethelong-
run rate is probably closer to 2.0%-2.5%.
TheTreasuryyieldcurvecontinued to flatten in December.The2-yearTreasuryyieldincreased about tenbasispoints
in December to 1.88%and the10-yearTreasuryyieldwasessentiallyunchanged.On ayear-over-yearbasis,the 2-
yearTreasuryyieldincreasednearly 70 basispoints in 2017and the10-yearTreasuryyielddeclinedslightly.Allelse
beingequal,we believetheFed'splan to normalizethebalancesheetcouldhelppromoteasteeperyieldcurveover
an intermediatetimehorizon.Taxreformmayalso be stimulative to theeconomy and driveyields at thelong endof
the curve higher.
3
Attachment I
U.S.nonfarmpayrollsrose by 148,000 in December,belowtheconsensusforecast of 191,000 but still enough to absorb new entrants
into the labor market. October and November payrolls were revised down by a net total of 9,000. Nevertheless, on a trailing 3-month and
6-month basis, payrolls increased by an average of 204,000 and 166,000 per month, respectively. The unemployment rate and the labor
participationratewereunchanged in December at 4.1%and 62.7%,respectively.Abroadermeasure of unemploymentcalledtheU-6,
whichincludesthosewhoaremarginallyattached to thelaborforce and employedparttimeforeconomicreasons,edgedup to 8.1%in
Decemberfrom8.0%in November and 7.9%in October.Wagesrose0.3%in December,followingadownwardlyrevised0.1%
increase in November. Wages were up 2.5% on a year-over-year basis in December, in line with expectations.
Employment
Source: US Department of Labor Source: US Department of Labor
0
50
100
150
200
250
300
350
M
O
M
C
h
a
n
g
e
I
n
(
0
0
0
'
s
)
Nonfarm Payroll (000's)
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 I
TheConsumerPriceIndex(CPI)was up 2.2%year-over-year in November,versus up 2.0%year-over-year in October.CoreCPI(CPI
lessfood and energy)was up 1.7%year-over-year in November,versus up 1.8%year-over-year in October.CoreCPIremainssoft.
ThePersonalConsumptionExpenditures(PCE)indexwas up 1.8%year-over-year in November,versus up 1.6%year-over-year in
October.However,CorePCE(excludingfood and energy)was up just1.5%on ayear-over-yearbasis in November.PCEinflation
remains well below 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
Attachment I
On ayear-over-yearbasis,retailsaleswere up 5.8%in November,versus up 4.9%year-over-year in October.On amonth-over-month
basis, retail sales increased 0.8% in November, far exceeding expectations. Excluding autos and gas, the month-over-month figure was
up 0.8% as well. This growth bodes well for retailers in the fourth quarter. Meanwhile, the Consumer Confidence index eased slightly but
remained strong in December at 122.1 down from 128.6 in November.
Consumer
Source: US Department of Commerce Source: The Conference Board
0.0%
1.0%
2.0%
3.0%
4.0%
5.0%
6.0%
7.0%
Retail Sales YOY % Change
YO
Y
(
%
)
C
h
a
n
g
e
85
90
95
100
105
110
115
120
125
130
135
In
d
e
x
L
e
v
e
l
Consumer Confidence
6
Attachment I
TheIndex of LeadingEconomicIndicators(LEI)rose0.4%in November,exceedingexpectations,followinga1.2%increase in October.
Theindexswungsharplyhigher in October,driven by ahurricane-relatedrebound,but returned to asteadypace of growth in
November.According to theConferenceBoard,thegrowth of theLEIsuggeststhatsolideconomicgrowth in the US economywill
continueintothefirsthalf of2018.TheChicagoFedNationalActivityIndex(CFNAI)increased in November to 0.41from0.31 in
October, on a 3-month moving average basis. The index suggests that the economy is growing at a solid pace.
Economic Activity
-0.4%
-0.2%
0.0%
0.2%
0.4%
0.6%
0.8%
1.0%
1.2%
1.4%
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 I
Totalhousingstartswerestrongerthanexpected in November,up 3.3%.Single-familystartsincreased5.3%in November,whilemulti-
familystartsweredownslightly.Permitswerealsobetterthanthanexpected in November.According to theCase-Shiller20-Cityhome
priceindex,homepriceswere up 6.4%year-over-year in October,versus up 6.2%year-over-year in September.Pricingremainsfirm,
helped by an acceleration in demand and lack of supply.
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
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 I
TheInstituteforSupplyManagement(ISM)manufacturingindexrose to 59.7 in Decemberfrom58.2 in November.Theindexremains
indicative of strength in themanufacturingsector.Areadingabove50.0suggeststhemanufacturingsector is expanding.TheIndustrial
Productionindexwas up 3.4%year-over-year in Novemberversus up 2.9%year-over-year in October.Themanufacturingcomponent
wasverystrong in October but softened in November.Nevertheless,theindexsuggeststhatactivity in thefactorysectoraccelerated in
the fourth quarter. With Capacity Utilization at just 77.1% in November though, there is still excess capacity for growth.
Manufacturing
Source: Institute for Supply Management Source: Federal Reserve
46
48
50
52
54
56
58
60
62
Institute of Supply Management Purchasing
Manager Index
Expanding
Contracting
-4.0%
-3.0%
-2.0%
-1.0%
0.0%
1.0%
2.0%
3.0%
4.0%
Industrial Production
YO
Y
(
%
)
C
h
a
n
g
e
9
Attachment I
ThirdquarterGDPgrew atan annualizedrate of 3.2%,followinggrowth of 3.1%in thesecondquarter.Thirdquartereconomicgrowth
got aboostfromnonresidentialfixedinvestment,alongwithabuild in inventorieswhichmayhavereversed in thefourthquarter.
Nevertheless, the third quarter GDP report was solid.
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.5%
1.3%-0.2%0.6%1.2%
-1.6%0.2%0.2%0.4%
0.0%-0.2%0.1%0.1%
0.1%0.1%-0.2%0.0%
1.8%1.2%3.1%3.2%
State and Local (Consumption and Gross
Investment)
Components of GDP
Total
Net Exports and Imports
Personal Consumption Expenditures
Gross Private Domestic Investment
Federal Government Expenditures
-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 I
Source: Bloomberg
Theyieldcurveflattenedmeaningfully in 2017.Thespreadbetween2-year and 10-yearTreasuryyieldswasjust 52 basispoints at the
endof theyear,compared to 126at the endof2016.During 2017,theFederalReserveraisedthefedfundsratethreetimes(inMarch,
June,and December)by atotal of75 basispoints,whichlargelyfueledtheincrease in shorterrates.However,inflationexpectations
remain muted, which we believe has kept a lid on longer-term rates.
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
Dec-17
Sep-17
Dec-16
Yi
e
l
d
(
%
)
11
Attachment I
SECTION 2
Account Profile
12
Attachment I
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 I
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 Deposit10% 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
December 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
Attachment I
Portfolio Characteristics
City of Dublin
12/31/2017 9/30/2017
Benchmark* Portfolio Portfolio
Average Maturity (yrs) 2.68 2.55 2.57
Modified Duration 2.57 2.39 2.41
Average Purchase Yield n/a 1.67% 1.60%
Average Market Yield 1.98% 2.00% 1.66%
Average Quality** AAA AA/Aa1 AA/Aa1
Total Market Value 158,173,214 158,631,241
*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 I
ABS
4.1%
Agency
35.1%
Commercial
Paper
2.0%
Money Market
Fund FI
0.1%
Negotiable
CD
1.8%
US Corporate
21.8%
US Treasury
32.3%
Supranational
2.8%
Sector Distribution
City of Dublin
December 31, 2017 September 30, 2017
ABS
5.1%
Agency
36.8%
Commercial
Paper
2.0% Money Market
Fund FI
0.2%
Negotiable
CD
1.8%
US Corporate
22.4%
US Treasury
31.8%
16
Attachment I
Issuers
City of Dublin – Account #10198 As of 12/31/2017
Issue Name Investment Type % Portfolio
Government of United States US Treasury 32.34%
Federal National Mortgage Association Agency 15.85%
Federal Home Loan Bank Agency 13.65%
Federal Home Loan Mortgage Corp Agency 5.55%
Bank of Tokyo-Mit UFJ Commercial Paper 2.00%
John Deere ABS ABS 1.77%
Bank of Nova Scotia Houston Negotiable CD 1.77%
Pepsico Inc US Corporate 1.74%
ChevronTexaco Corp US Corporate 1.74%
Inter-American Dev Bank Supranational 1.55%
Honda ABS ABS 1.32%
US Bancorp US Corporate 1.29%
Chubb Corporation US Corporate 1.27%
Intl Bank Recon and Development Supranational 1.26%
Qualcomm Inc US Corporate 1.26%
Wells Fargo Corp US Corporate 1.21%
Honda Motor Corporation US Corporate 1.15%
JP Morgan Chase & Co US Corporate 1.15%
Microsoft US Corporate 1.15%
Exxon Mobil Corp US Corporate 1.14%
State Street Bank US Corporate 1.12%
Deere & Company US Corporate 1.12%
Bank of New York US Corporate 1.12%
Apple Inc US Corporate 1.11%
Eli Lilly & Co US Corporate 1.00%
HSBC USA Corp US Corporate 0.95%
Cisco Systems US Corporate 0.86%
Oracle Corp US Corporate 0.80%
Berkshire Hathaway US Corporate 0.64%
Nissan ABS ABS 0.57%
17
Attachment I
Issuers
City of Dublin – Account #10198 As of 12/31/2017
Issue Name Investment Type % Portfolio
Toyota ABS ABS 0.44%
First American Govt Oblig Fund Money Market Fund FI 0.13%
Total 100.00%
18
Attachment I
AAA AA A <A NR
12/31/17 2.2% 78.4% 13.4% 0.0% 6.0%
09/30/17 2.7% 80.1% 13.4% 0.0% 3.8%
Source: S&P Ratings
Quality Distribution
December 31, 2017 vs. September 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
12/31/2017 9/30/2017
19
Attachment I
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 December 31, 2017
0 - 0.25 0.25 - 0.50 0.50 - 1 1 - 2 2 - 3 3 - 4 4 - 5 5+
Portfolio 7.9% 6.2% 5.7% 20.4% 19.9% 26.3% 13.6% 0.0%
Benchmark* 0.0% 0.0% 1.7% 33.2% 28.5% 22.3% 14.4% 0.0%
*BAML 1-5 Yr US Treasury/Agency Index
20
Attachment I
Investment Performance
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
December 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.29%1.01% 1.18% 1.11% N/A N/A 0.98%
BAML 1-5 Yr US Treasury/Agency Index -0.38%0.66% 0.88% 0.91% N/A N/A 0.79%
*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 I
Portfolio Characteristics
City of Dublin Reporting Account
12/31/2017 9/30/2017
Portfolio Portfolio
Average Maturity (yrs) 0.00 0.00
Modified Duration 0.00 0.00
Average Purchase Yield 1.32% 1.13%
Average Market Yield 1.32% 1.13%
Average Quality AAA/NR AAA/NR
Total Market Value 82,491,846 60,197,021
22
Attachment I
LAIF
49.0%
Local Gov
Investment
Pool
51.0%
Sector Distribution
City of Dublin Reporting Account
December 31, 2017 September 30, 2017
LAIF
66.9%
Local Gov
Investment
Pool
33.1%
23
Attachment I
Issuers
City of Dublin Reporting Account – Account #10219 As of 12/31/2017
Issue Name Investment Type % Portfolio
Local Agency Investment Fund LAIF 51.03%
CAMP Local Gov Investment Pool 48.97%
Total 100.00%
24
Attachment I
SECTION 3
Consolidated Information
25
Attachment I
Portfolio Characteristics
City of Dublin Consolidated
12/31/2017 9/30/2017
Portfolio Portfolio
Average Maturity (yrs) 1.68 1.87
Modified Duration 1.57 1.74
Average Purchase Yield 1.55% 1.47%
Average Market Yield 1.77% 1.51%
Average Quality AA+/Aaa AA+/Aa1
Total Market Value 240,665,060 218,828,262
26
Attachment I
ABS
2.7%
Agency
23.0%
Commercial
Paper
1.3%
LAIF
16.8%
Local Gov
Investment Pool
17.5%
Money Market
Fund FI
0.1%
Negotiable CD
1.2%
US Corporate
14.3%
US Treasury
21.3%
Supranational
1.8%
Sector Distribution
City of Dublin Consolidated
December 31, 2017 September 30, 2017
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%
Negotiable CD
1.3%
US Corporate
16.2%
US Treasury
23.0%
27
Attachment I
SECTION 4
Portfolio Holdings
28
Attachment I
Holdings Report
For the Month Ending 12/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
89236WAC2 Toyota Auto Receivables Owner 2015-A
1.120% Due 02/15/2019
152,147.52 02/24/2015
0.61%
152,124.52
152,146.56
99.93
1.64%
152,033.95
75.74
0.10%
(112.61)
Aaa / AAA
NR
1.13
0.14
47788NAB4 John Deere Owner Trust 2016-B A2
1.090% Due 02/15/2019
348,076.01 07/19/2016
0.91%
348,054.78
348,066.68
99.94
1.81%
347,860.83
168.62
0.22%
(205.85)
Aaa / NR
AAA
1.13
0.09
43813NAC0 Honda Auto Receivables 2015-2 A3
1.040% Due 02/21/2019
264,906.72 05/13/2015
0.36%
264,866.06
264,894.40
99.86
1.84%
264,546.26
76.53
0.17%
(348.14)
NR / AAA
AAA
1.14
0.17
65478WAB1 Nissan Auto Receivables Owner 2016-C A2A
1.070% Due 05/15/2019
320,528.31 08/02/2016
0.82%
320,515.69
320,522.06
99.93
1.46%
320,294.88
152.43
0.20%
(227.18)
Aaa / NR
AAA
1.37
0.19
89231LAB3 Toyota Auto Receivables Owner 2016-D
1.060% Due 05/15/2019
541,479.44 10/04/2016
0.87%
541,436.12
541,456.57
99.85
1.70%
540,653.05
255.10
0.34%
(803.52)
Aaa / AAA
NR
1.37
0.24
43814TAB8 Honda Auto Receivables 2017-1 A2
1.420% Due 07/22/2019
586,317.08 03/21/2017
1.28%
586,303.07
586,307.69
99.86
1.78%
585,523.17
231.27
0.37%
(784.52)
Aaa / NR
AAA
1.56
0.38
47787XAB3 John Deere Owner Trust 2017-A A2
1.500% Due 10/15/2019
649,966.02 02/22/2017
1.50%
649,963.42
649,964.25
99.87
1.84%
649,114.52
433.31
0.41%
(849.73)
Aaa / NR
AAA
1.79
0.39
654747AB0 Nissan Auto Receivables 2017-A A2A
1.470% Due 01/15/2020
577,231.16 03/21/2017
1.47%
577,228.22
577,229.02
99.82
1.84%
576,190.40
377.12
0.36%
(1,038.62)
Aaa / NR
AAA
2.04
0.49
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,963.66
99.72
1.92%
458,720.28
260.79
0.29%
(1,243.38)
NR / AAA
AAA
2.06
0.80
47788MAC4 John Deere Owner Trust 2016-A A3
1.360% Due 04/15/2020
1,029,947.56 02/23/2016
1.04%
1,029,785.44
1,029,857.61
99.72
1.87%
1,027,070.85
622.55
0.65%
(2,786.76)
Aaa / NR
AAA
2.29
0.55
43814QAC2 Honda Auto Receivables 2016-2 A3
1.390% Due 04/15/2020
784,651.05 05/24/2016
1.24%
784,635.82
784,642.06
99.67
1.92%
782,061.63
484.74
0.49%
(2,580.43)
Aaa / NR
AAA
2.29
0.63
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,967.05
99.75
1.95%
453,870.24
321.53
0.29%
(1,096.81)
Aaa / NR
AAA
2.29
0.69
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,979.10
99.25
2.22%
317,612.16
258.84
0.20%
(2,366.94)
Aaa / NR
AAA
3.79
1.89
Total ABS 6,490,250.87 1.22%
6,489,809.29
6,489,996.71 1.84%
6,475,552.22
3,718.57
4.10%
(14,444.49)
Aaa / AAA
Aaa
1.95
0.52
Agency
3135G0TG8 FNMA Note
0.875% Due 02/08/2018
3,000,000.00 01/21/2015
0.97%
2,991,390.00
2,999,706.04
99.95
1.34%
2,998,554.00
10,427.08
1.90%
(1,152.04)
Aaa / AA+
AAA
0.11
0.10
313378A43 FHLB Note
1.375% Due 03/09/2018
4,000,000.00 Various
0.96%
4,047,840.00
4,003,030.95
100.01
1.33%
4,000,288.00
17,111.12
2.54%
(2,742.95)
Aaa / AA+
AAA
0.19
0.19
313379DT3 FHLB Note
1.250% Due 06/08/2018
2,000,000.00 08/18/2015
1.12%
2,007,360.00
2,001,135.63
99.86
1.57%
1,997,182.00
1,597.22
1.26%
(3,953.63)
Aaa / AA+
AAA
0.44
0.43
3135G0G72 FNMA Note
1.125% Due 12/14/2018
2,500,000.00 12/18/2015
1.37%
2,481,975.00
2,494,256.50
99.34
1.83%
2,483,382.50
1,328.13
1.57%
(10,874.00)
Aaa / AA+
AAA
0.95
0.94
3133782M2 FHLB Note
1.500% Due 03/08/2019
2,750,000.00 04/24/2015
1.21%
2,779,892.50
2,759,130.88
99.59
1.85%
2,738,703.00
12,947.92
1.74%
(20,427.88)
Aaa / AA+
AAA
1.18
1.16
City of Dublin - Account #10198
29
Attachment I
Holdings Report
For the Month Ending 12/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
3137EADG1 FHLMC Note
1.750% Due 05/30/2019
1,000,000.00 01/29/2015
1.28%
1,019,690.00
1,006,401.43
99.85
1.85%
998,534.00
1,506.94
0.63%
(7,867.43)
Aaa / AA+
AAA
1.41
1.39
3135G0ZG1 FNMA Note
1.750% Due 09/12/2019
2,500,000.00 10/28/2014
1.68%
2,508,350.00
2,502,905.37
99.72
1.92%
2,492,920.00
13,246.53
1.58%
(9,985.37)
Aaa / AA+
AAA
1.70
1.66
3137EADM8 FHLMC Note
1.250% Due 10/02/2019
2,500,000.00 12/18/2015
1.64%
2,464,700.00
2,483,666.40
98.81
1.94%
2,470,227.50
7,725.69
1.57%
(13,438.90)
Aaa / AA+
AAA
1.75
1.72
3135G0A78 FNMA Note
1.625% Due 01/21/2020
2,000,000.00 04/07/2015
1.44%
2,016,580.00
2,007,109.78
99.34
1.95%
1,986,896.00
14,444.44
1.27%
(20,213.78)
Aaa / AA+
AAA
2.06
2.00
313383HU8 FHLB Note
1.750% Due 06/12/2020
2,000,000.00 10/08/2015
1.46%
2,026,040.00
2,013,614.59
99.32
2.03%
1,986,464.00
1,847.22
1.26%
(27,150.59)
Aaa / AA+
NR
2.45
2.38
3137EAEK1 FHLMC Note
1.875% Due 11/17/2020
2,400,000.00 11/28/2017
1.91%
2,397,336.00
2,397,417.10
99.48
2.06%
2,387,421.60
5,750.00
1.51%
(9,995.50)
Aaa / AA+
AAA
2.88
2.78
3135G0F73 FNMA Note
1.500% Due 11/30/2020
2,500,000.00 12/04/2015
1.87%
2,455,750.00
2,474,130.77
98.53
2.02%
2,463,265.00
3,229.17
1.56%
(10,865.77)
Aaa / AA+
AAA
2.92
2.83
3130A7CV5 FHLB Note
1.375% Due 02/18/2021
3,470,000.00 Various
1.45%
3,457,221.20
3,461,957.13
97.76
2.12%
3,392,379.57
17,627.12
2.16%
(69,577.56)
Aaa / AA+
AAA
3.14
3.03
3135G0J20 FNMA Note
1.375% Due 02/26/2021
5,000,000.00 Various
1.29%
5,018,675.00
5,012,803.64
97.89
2.07%
4,894,745.00
23,871.52
3.11%
(118,058.64)
Aaa / AA+
AAA
3.16
3.05
313379RB7 FHLB Note
1.875% Due 06/11/2021
3,000,000.00 08/30/2017
1.67%
3,022,620.00
3,020,603.87
99.15
2.13%
2,974,512.00
3,125.00
1.88%
(46,091.87)
Aaa / AA+
AAA
3.45
3.31
3130A8QS5 FHLB Note
1.125% Due 07/14/2021
2,500,000.00 07/25/2016
1.28%
2,481,475.00
2,486,826.21
96.68
2.10%
2,416,942.50
13,046.88
1.54%
(69,883.71)
Aaa / AA+
AAA
3.54
3.42
3137EAEC9 FHLMC Note
1.125% Due 08/12/2021
3,000,000.00 Various
1.33%
2,971,215.00
2,978,906.68
96.53
2.13%
2,895,876.00
13,031.26
1.84%
(83,030.68)
Aaa / AA+
AAA
3.62
3.50
3135G0Q89 FNMA Note
1.375% Due 10/07/2021
2,000,000.00 10/06/2016
1.45%
1,992,924.00
1,994,671.69
97.25
2.14%
1,945,044.00
6,416.67
1.23%
(49,627.69)
Aaa / AA+
AAA
3.77
3.63
3135G0S38 FNMA Note
2.000% Due 01/05/2022
2,500,000.00 01/30/2017
2.04%
2,495,475.00
2,496,317.15
99.34
2.17%
2,483,532.50
24,444.44
1.59%
(12,784.65)
Aaa / AA+
AAA
4.02
3.80
313378CR0 FHLB Note
2.250% Due 03/11/2022
2,000,000.00 06/19/2017
1.86%
2,035,280.00
2,031,291.83
100.15
2.21%
2,002,980.00
13,750.00
1.28%
(28,311.83)
Aaa / AA+
NR
4.19
3.96
3135G0T45 FNMA Note
1.875% Due 04/05/2022
3,250,000.00 05/05/2017
1.99%
3,232,125.00
3,234,497.70
98.75
2.18%
3,209,518.00
14,557.29
2.04%
(24,979.70)
Aaa / AA+
AAA
4.26
4.05
Total Agency 55,870,000.00 1.47%
55,903,913.70
55,860,381.34 1.94%
55,219,367.17
221,031.64
35.05%
(641,014.17)
Aaa / AA+
Aaa
2.45
2.36
Commercial Paper
06538CCD1 Bank of Tokyo Mitsubishi NY Discount CP
1.450% Due 03/13/2018
3,170,000.00 11/07/2017
1.48%
3,154,039.93
3,160,934.68
99.71
1.48%
3,160,934.68
0.00
2.00%
0.00
P-1 / A-1
NR
0.20
0.20
Total Commercial Paper 3,170,000.00 1.48%
3,154,039.93
3,160,934.68 1.48%
3,160,934.68
0.00
2.00%
0.00
P-1 / A-1
NR
0.20
0.20
City of Dublin - Account #10198
30
Attachment I
Holdings Report
For the Month Ending 12/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
Money Market Fund FI
31846V203 First American Govt Obligation Fund 205,517.22 Various
0.87%
205,517.22
205,517.22
1.00
0.87%
205,517.22
0.00
0.13%
0.00
Aaa / AAA
AAA
0.00
0.00
Total Money Market Fund FI 205,517.22 0.87%
205,517.22
205,517.22 0.87%
205,517.22
0.00
0.13%
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
17,548.02
1.77%
0.00
P-1 / A-1
NR
0.61
0.60
Total Negotiable CD 2,775,000.00 1.57%
2,775,000.00
2,775,000.00 1.57%
2,775,000.00
17,548.02
1.77%
0.00
Aaa / AA
NR
0.61
0.60
Supranational
459058FY4 Intl. Bank Recon & Development Note
2.000% Due 01/26/2022
2,000,000.00 10/26/2017
2.12%
1,990,320.00
1,990,713.70
99.04
2.25%
1,980,744.00
17,222.22
1.26%
(9,969.70)
Aaa / NR
AAA
4.07
3.85
4581X0CZ9 Inter-American Dev Bank Note
1.750% Due 09/14/2022
2,500,000.00 11/28/2017
2.18%
2,451,675.00
2,452,559.16
97.58
2.29%
2,439,570.00
13,003.47
1.55%
(12,989.16)
NR / NR
AAA
4.71
4.46
Total Supranational 4,500,000.00 2.15%
4,441,995.00
4,443,272.86 2.27%
4,420,314.00
30,225.69
2.81%
(22,958.86)
Aaa / NR
Aaa
4.42
4.19
US Corporate
40428HPH9 HSBC USA Inc Note
1.625% Due 01/16/2018
500,000.00 11/25/2013
1.69%
498,705.00
499,987.14
99.99
1.79%
499,963.00
3,723.96
0.32%
(24.14)
A2 / A
AA-
0.04
0.04
713448CR7 PepsiCo Inc Note
1.250% Due 04/30/2018
1,430,000.00 Various
1.26%
1,429,428.40
1,429,937.89
99.92
1.50%
1,428,807.38
3,028.82
0.91%
(1,130.51)
A1 / A+
A
0.33
0.33
037833AJ9 Apple Inc Note
1.000% Due 05/03/2018
1,750,000.00 Various
1.34%
1,726,740.00
1,748,049.46
99.75
1.73%
1,745,674.00
2,819.44
1.11%
(2,375.46)
Aa1 / AA+
NR
0.34
0.34
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,221.51
100.00
1.71%
1,749,996.50
584.60
1.11%
(1,225.01)
Aa2 / AA-
NR
0.48
0.40
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,000,774.32
100.10
1.90%
1,000,950.00
8,750.00
0.64%
175.68
A1 / A
AA-
0.58
0.50
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,658.61
100.06
1.89%
1,000,645.00
7,555.56
0.64%
(13.61)
Aa2 / AA
A+
0.62
0.61
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,102.32
100.11
2.03%
1,351,516.05
9,562.50
0.86%
413.73
A1 / AA-
NR
1.16
1.14
532457BF4 Eli Lilly & Co Note
1.950% Due 03/15/2019
1,575,000.00 Various
1.91%
1,577,796.75
1,575,780.77
99.92
2.02%
1,573,708.50
9,043.13
1.00%
(2,072.27)
A2 / AA-
A
1.20
1.18
94974BFU9 Wells Fargo Corp Note
2.125% Due 04/22/2019
1,900,000.00 Various
2.07%
1,904,120.50
1,901,366.66
99.98
2.14%
1,899,701.70
7,738.54
1.21%
(1,664.96)
A2 / A
A+
1.31
1.28
02665WAH4 American Honda Finance Note
2.250% Due 08/15/2019
1,800,000.00 Various
2.08%
1,812,627.00
1,804,805.60
100.15
2.16%
1,802,691.00
15,300.00
1.15%
(2,114.60)
A2 / A+
NR
1.62
1.57
City of Dublin - Account #10198
31
Attachment I
Holdings Report
For the Month Ending 12/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
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
755,515.07
100.26
2.13%
751,955.25
5,270.83
0.48%
(3,559.82)
A1 / A
AA-
1.70
1.57
68389XAX3 Oracle Corp Note
2.250% Due 10/08/2019
1,250,000.00 Various
1.73%
1,272,172.50
1,261,083.55
100.45
1.99%
1,255,651.25
6,484.38
0.80%
(5,432.30)
A1 / AA-
A+
1.77
1.72
40428HPN6 HSBC USA Inc Note
2.375% Due 11/13/2019
1,000,000.00 11/07/2014
2.32%
1,002,440.00
1,000,909.99
100.12
2.31%
1,001,160.00
3,166.67
0.63%
250.01
A2 / A
AA-
1.87
1.81
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,719.78
99.93
2.28%
1,798,795.80
17,775.00
1.15%
3,076.02
A3 / A-
A+
2.06
1.91
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,647.30
99.19
2.22%
1,319,284.19
4,169.18
0.84%
(10,363.11)
A1 / A+
A
2.33
2.18
747525AD5 Qualcomm Inc Note
2.250% Due 05/20/2020
2,000,000.00 Various
2.22%
2,001,128.80
2,001,363.19
99.23
2.58%
1,984,578.00
5,125.00
1.26%
(16,785.19)
A1 / A
NR
2.39
2.30
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,016,702.79
100.21
2.29%
1,002,101.00
11,017.36
0.64%
(14,601.79)
A2 / A
A
2.54
2.42
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,699.18
99.84
2.36%
1,996,816.00
7,411.11
1.27%
(5,883.18)
A3 / A
A
2.84
2.65
24422ETF6 John Deere Capital Corp Note
2.550% Due 01/08/2021
750,000.00 Various
2.42%
753,733.15
752,784.96
100.39
2.42%
752,894.26
9,190.62
0.48%
109.30
A2 / A
A
3.02
2.86
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,808,645.24
99.78
2.30%
1,795,971.60
13,332.00
1.14%
(12,673.64)
Aaa / AA+
NR
3.17
3.02
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,157.82
99.18
2.35%
991,814.00
2,625.00
0.63%
(8,343.82)
Aa2 / AA-
NR
3.38
3.23
857477AV5 State Street Bank Note
1.950% Due 05/19/2021
1,800,000.00 Various
1.91%
1,802,989.00
1,802,251.33
98.56
2.40%
1,774,018.80
4,095.01
1.12%
(28,232.53)
A1 / A
AA-
3.38
3.24
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,425.03
97.37
2.31%
1,801,295.06
11,390.35
1.15%
(46,129.97)
Aaa / AAA
AA+
3.61
3.45
91159HHP8 US Bancorp Note
2.625% Due 01/24/2022
2,000,000.00 05/23/2017
2.36%
2,023,280.00
2,020,274.37
100.57
2.48%
2,011,484.00
22,895.83
1.29%
(8,790.37)
A1 / A+
AA
4.07
3.79
Total US Corporate 34,385,000.00 1.95%
34,501,768.35
34,458,863.88
2.16%
34,291,472.34
192,054.89
21.80%
(167,391.54)
A1 / A+
A+
2.02
1.92
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,088.91
99.60
1.85%
1,743,028.00
8,919.20
1.11%
(7,060.91)
Aaa / AA+
AAA
1.16
1.14
912828D80 US Treasury Note
1.625% Due 08/31/2019
3,000,000.00 Various
1.78%
2,977,822.56
2,992,566.37
99.59
1.87%
2,987,814.00
16,564.23
1.90%
(4,752.37)
Aaa / AA+
AAA
1.67
1.62
912828G61 US Treasury Note
1.500% Due 11/30/2019
2,000,000.00 Various
1.45%
2,003,378.10
2,001,685.35
99.28
1.89%
1,985,546.00
2,637.36
1.26%
(16,139.35)
Aaa / AA+
AAA
1.92
1.87
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,025.01
99.48
1.89%
2,984,298.00
134.67
1.89%
(22,727.01)
Aaa / AA+
AAA
2.00
1.96
912828H52 US Treasury Note
1.250% Due 01/31/2020
4,500,000.00 Various
1.53%
4,440,542.42
4,474,835.25
98.68
1.90%
4,440,411.00
23,539.41
2.82%
(34,424.25)
Aaa / AA+
AAA
2.08
2.03
City of Dublin - Account #10198
32
Attachment I
Holdings Report
For the Month Ending 12/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
912828K58 US Treasury Note
1.375% Due 04/30/2020
1,750,000.00 05/06/2015
1.55%
1,735,171.88
1,743,074.78
98.76
1.92%
1,728,329.75
4,121.20
1.10%
(14,745.03)
Aaa / AA+
AAA
2.33
2.28
912828XE5 US Treasury Note
1.500% Due 05/31/2020
3,000,000.00 Various
1.67%
2,976,025.68
2,988,228.50
99.02
1.92%
2,970,468.00
3,956.04
1.88%
(17,760.50)
Aaa / AA+
AAA
2.42
2.36
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,017.98
99.23
1.93%
1,488,457.50
10,200.41
0.95%
(15,560.48)
Aaa / AA+
AAA
2.58
2.50
912828L99 US Treasury Note
1.375% Due 10/31/2020
5,000,000.00 Various
1.69%
4,927,376.14
4,958,048.05
98.39
1.96%
4,919,335.00
11,774.86
3.12%
(38,713.05)
Aaa / AA+
AAA
2.84
2.75
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,945.02
98.09
2.02%
1,961,876.00
11,508.15
1.25%
(31,069.02)
Aaa / AA+
AAA
3.09
2.98
912828S76 US Treasury Note
1.125% Due 07/31/2021
1,500,000.00 12/12/2016
1.89%
1,449,262.83
1,460,784.46
96.70
2.08%
1,450,546.50
7,061.82
0.92%
(10,237.96)
Aaa / AA+
AAA
3.58
3.47
912828T34 US Treasury Note
1.125% Due 09/30/2021
2,750,000.00 Various
1.66%
2,682,431.10
2,697,678.11
96.49
2.10%
2,653,428.25
7,904.36
1.68%
(44,249.86)
Aaa / AA+
AAA
3.75
3.63
912828U65 US Treasury Note
1.750% Due 11/30/2021
2,500,000.00 12/28/2016
2.06%
2,464,461.50
2,471,739.28
98.61
2.12%
2,465,137.50
3,846.15
1.56%
(6,601.78)
Aaa / AA+
AAA
3.92
3.75
912828V72 US Treasury Note
1.875% Due 01/31/2022
1,500,000.00 02/27/2017
1.84%
1,502,407.37
1,501,996.32
98.96
2.14%
1,484,413.50
11,769.70
0.95%
(17,582.82)
Aaa / AA+
AAA
4.09
3.88
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,798.37
98.36
2.16%
2,950,782.00
13,413.46
1.87%
(37,016.37)
Aaa / AA+
AAA
4.25
4.05
912828WZ9 US Treasury Note
1.750% Due 04/30/2022
2,750,000.00 05/23/2017
1.84%
2,738,944.75
2,740,306.72
98.28
2.17%
2,702,625.75
8,329.33
1.71%
(37,680.97)
Aaa / AA+
AAA
4.33
4.13
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,432.54
98.26
2.17%
1,473,867.00
2,307.69
0.93%
(22,565.54)
Aaa / AA+
AAA
4.42
4.21
912828XW5 US Treasury Note
1.750% Due 06/30/2022
3,000,000.00 07/25/2017
1.86%
2,984,072.55
2,985,479.47
98.19
2.17%
2,945,742.00
145.03
1.86%
(39,737.47)
Aaa / AA+
AAA
4.50
4.30
912828L24 US Treasury Note
1.875% Due 08/31/2022
2,000,000.00 09/27/2017
1.92%
1,995,944.20
1,996,158.49
98.59
2.19%
1,971,876.00
12,741.71
1.25%
(24,282.49)
Aaa / AA+
AAA
4.67
4.41
912828L57 US Treasury Note
1.750% Due 09/30/2022
3,750,000.00 Various
2.02%
3,702,841.80
3,704,302.08
98.00
2.20%
3,674,853.75
16,766.83
2.33%
(29,448.33)
Aaa / AA+
AAA
4.75
4.50
Total US Treasury 51,750,000.00 1.72%
51,326,809.58
51,455,191.06 2.03%
50,982,835.50
177,641.61
32.34%
(472,355.56)
Aaa / AA+
Aaa
3.19
3.07
TOTAL PORTFOLIO 159,145,768.09 1.67%
158,798,853.07
158,849,157.75 2.00%
157,530,993.13
642,220.42
100.00%
(1,318,164.62)
Aa1 / AA
Aaa
2.55
2.39
TOTAL MARKET VALUE PLUS ACCRUALS 158,173,213.55
City of Dublin - Account #10198
33
Attachment I
Holdings Report
For the Month Ending 12/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
40,279,741.38 Various
1.28%
40,279,741.38
40,279,741.38
1.00
1.28%
40,279,741.38
120,398.86
48.97%
0.00
NR / NR
NR
0.00
0.00
Total LAIF 40,279,741.38 1.28%
40,279,741.38
40,279,741.38
1.28%
40,279,741.38
120,398.86
48.97%
0.00
NR / NR
NR
0.00
0.00
Local Gov Investment Pool
90CAMP$00 Public Financial Management CAMP
42,091,706.09 Various
1.36%
42,091,706.09
42,091,706.09
1.00
1.36%
42,091,706.09
0.00
51.03%
0.00
NR / AAA
NR
0.00
0.00
Total Local Gov Investment Pool 42,091,706.09 1.36%
42,091,706.09
42,091,706.09
1.36%
42,091,706.09
0.00
51.03%
0.00
NR / AAA
NR
0.00
0.00
TOTAL PORTFOLIO 82,371,447.47 1.32%
82,371,447.47
82,371,447.47 1.32%
82,371,447.47
120,398.86
100.00%
0.00
NR / AAA
NR
0.00
0.00
TOTAL MARKET VALUE PLUS ACCRUALS 82,491,846.33
City of Dublin Reporting Account - Account #10219
34
Attachment I
SECTION 5
Transactions
35
Attachment I
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 10/06/2017 912828L57 2,500,000.00 US Treasury Note
1.75% Due: 09/30/2022 98.980 1.97% 2,474,511.72 721.15 2,475,232.87 0.00
Purchase 10/30/2017 459058FY4 2,000,000.00 Intl. Bank Recon & Development Note
2% Due: 01/26/2022 99.516 2.12% 1,990,320.00 10,444.44 2,000,764.44 0.00
Purchase 10/31/2017 912828L57 500,000.00 US Treasury Note
1.75% Due: 09/30/2022 98.754 2.02% 493,769.53 745.19 494,514.72 0.00
Purchase 11/08/2017 06538CCD1 3,170,000.00 Bank of Tokyo Mitsubishi NY Discount CP
1.45% Due: 03/13/2018 99.497 1.48% 3,154,039.93 0.00 3,154,039.93 0.00
Purchase 11/29/2017 3137EAEK1 2,400,000.00 FHLMC Note
1.875% Due: 11/17/2020 99.889 1.91% 2,397,336.00 1,750.00 2,399,086.00 0.00
Purchase 11/30/2017 4581X0CZ9 2,500,000.00 Inter-American Dev Bank Note
1.75% Due: 09/14/2022 98.067 2.18% 2,451,675.00 9,236.11 2,460,911.11 0.00
Purchase 12/29/2017 912828L57 750,000.00 US Treasury Note
1.75% Due: 09/30/2022 97.941 2.21% 734,560.55 3,245.19 737,805.74 0.00
Subtotal 13,820,000.00 13,696,212.73 26,142.08 13,722,354.81 0.00
TOTAL ACQUISITIONS 13,820,000.00 13,696,212.73 26,142.08 13,722,354.81 0.00
DISPOSITIONS
Sale 10/06/2017 912828G61 2,500,000.00 US Treasury Note
1.5% Due: 11/30/2019 99.941 1.53% 2,498,535.16 13,114.75 2,511,649.91 -3834.10
Sale 10/27/2017 313381B20 2,000,000.00 FHLB Note
0.75% Due: 12/08/2017 99.960 1.10% 1,999,200.00 5,791.67 2,004,991.67 -799.54
Sale 11/29/2017 3137EADP1 3,000,000.00 FHLMC Note
0.875% Due: 03/07/2018 99.872 1.34% 2,996,160.00 5,979.17 3,002,139.17 -2769.26
Subtotal 7,500,000.00 7,493,895.16 24,885.59 7,518,780.75 -7,402.90
Maturity 11/08/2017 06538BY80 3,160,000.00 Bank of Tokyo Mitsubishi NY Discount CP
1.33% Due: 11/08/2017 99.542 3,160,000.00 0.00 3,160,000.00 0.00
September 30, 2017 through December 31, 2017
36
Attachment I
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 11/20/2017 36962G6K5 750,000.00 General Electric Capital Corp Note
1.6% Due: 11/20/2017 100.000 750,000.00 0.00 750,000.00 0.00
Subtotal 3,910,000.00 3,910,000.00 0.00 3,910,000.00 0.00
TOTAL DISPOSITIONS 12,992,254.02 12,986,149.18 50,145.57 13,036,294.75 -7,402.90
September 30, 2017 through December 31, 2017
37
Attachment I
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 10/15/2017 90LAIF$00 108,723.50 Local Agency Investment Fund State Pool 1.000 1.12% 108,723.50 0.00 108,723.50 0.00
Purchase 10/31/2017 90CAMP$00 22,883.11 Public Financial Management CAMP 1.000 1.16% 22,883.11 0.00 22,883.11 0.00
Purchase 12/31/2017 90CAMP$00 32,918.56 Public Financial Management CAMP 1.000 1.36% 32,918.56 0.00 32,918.56 0.00
Subtotal 164,525.17 164,525.17 0.00 164,525.17 0.00
Security
Contribution 10/13/2017 90CAMP$00 4,400,000.00 Public Financial Management CAMP 1.000 4,400,000.00 0.00 4,400,000.00 0.00
Security
Contribution 10/24/2017 90CAMP$00 3,000,000.00 Public Financial Management CAMP 1.000 3,000,000.00 0.00 3,000,000.00 0.00
Security
Contribution 12/08/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
Contribution 12/18/2017 90CAMP$00 22,000,000.00 Public Financial Management CAMP 1.000 22,000,000.00 0.00 22,000,000.00 0.00
Subtotal 31,900,000.00 31,900,000.00 0.00 31,900,000.00 0.00
TOTAL ACQUISITIONS 32,064,525.17 32,064,525.17 0.00 32,064,525.17 0.00
DISPOSITIONS
Security
Withdrawal 10/30/2017 90CAMP$00 4,900,000.00 Public Financial Management CAMP 1.000 4,900,000.00 0.00 4,900,000.00 0.00
Security
Withdrawal 11/30/2017 90CAMP$00 4,880,272.31 Public Financial Management CAMP 1.000 4,880,272.31 0.00 4,880,272.31 0.00
Subtotal 9,780,272.31 9,780,272.31 0.00 9,780,272.31 0.00
TOTAL DISPOSITIONS 9,780,272.31 9,780,272.31 0.00 9,780,272.31 0.00
September 30, 2017 through December 31, 2017
38
Attachment I
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.
39
Attachment I
Transaction Ledger
9/30/17 Thru 10/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 10/02/2017 31846V203 15,625.00 First American Govt Obligation Fund 1.000 0.61 %15,625.00 0.00 15,625.00 0.00
Purchase 10/02/2017 31846V203 577.49 First American Govt Obligation Fund 1.000 0.61 %577.49 0.00 577.49 0.00
Purchase 10/05/2017 31846V203 29,622.39 First American Govt Obligation Fund 1.000 0.61 %29,622.39 0.00 29,622.39 0.00
Purchase 10/06/2017 31846V203 36,417.04 First American Govt Obligation Fund 1.000 0.61 %36,417.04 0.00 36,417.04 0.00
Purchase 10/06/2017 912828L57 2,500,000.00 US Treasury Note
1.75% Due 9/30/2022
98.980 1.97 %2,474,511.72 721.15 2,475,232.87 0.00
Purchase 10/07/2017 31846V203 13,750.00 First American Govt Obligation Fund 1.000 0.61 %13,750.00 0.00 13,750.00 0.00
Purchase 10/08/2017 31846V203 14,062.50 First American Govt Obligation Fund 1.000 0.61 %14,062.50 0.00 14,062.50 0.00
Purchase 10/15/2017 90LAIF$00 108,723.50 Local Agency Investment Fund State Pool 1.000 1.12 %108,723.50 0.00 108,723.50 0.00
Purchase 10/16/2017 31846V203 932.46 First American Govt Obligation Fund 1.000 0.61 %932.46 0.00 932.46 0.00
Purchase 10/16/2017 31846V203 818.75 First American Govt Obligation Fund 1.000 0.61 %818.75 0.00 818.75 0.00
Purchase 10/16/2017 31846V203 602.88 First American Govt Obligation Fund 1.000 0.61 %602.88 0.00 602.88 0.00
Purchase 10/16/2017 31846V203 485.33 First American Govt Obligation Fund 1.000 0.61 %485.33 0.00 485.33 0.00
Purchase 10/16/2017 31846V203 1,263.66 First American Govt Obligation Fund 1.000 0.61 %1,263.66 0.00 1,263.66 0.00
Purchase 10/16/2017 31846V203 111,400.47 First American Govt Obligation Fund 1.000 0.61 %111,400.47 0.00 111,400.47 0.00
Purchase 10/16/2017 31846V203 771.75 First American Govt Obligation Fund 1.000 0.61 %771.75 0.00 771.75 0.00
Purchase 10/16/2017 31846V203 65,791.20 First American Govt Obligation Fund 1.000 0.61 %65,791.20 0.00 65,791.20 0.00
Purchase 10/16/2017 31846V203 95,520.12 First American Govt Obligation Fund 1.000 0.61 %95,520.12 0.00 95,520.12 0.00
Purchase 10/16/2017 31846V203 46,998.48 First American Govt Obligation Fund 1.000 0.61 %46,998.48 0.00 46,998.48 0.00
Purchase 10/18/2017 31846V203 381.16 First American Govt Obligation Fund 1.000 0.61 %381.16 0.00 381.16 0.00
Purchase 10/22/2017 31846V203 20,187.50 First American Govt Obligation Fund 1.000 0.61 %20,187.50 0.00 20,187.50 0.00
Purchase 10/23/2017 31846V203 80,654.16 First American Govt Obligation Fund 1.000 0.61 %80,654.16 0.00 80,654.16 0.00
Purchase 10/23/2017 31846V203 76,385.49 First American Govt Obligation Fund 1.000 0.61 %76,385.49 0.00 76,385.49 0.00
Purchase 10/27/2017 31846V203 2,004,991.67 First American Govt Obligation Fund 1.000 0.61 %2,004,991.67 0.00 2,004,991.67 0.00
Purchase 10/30/2017 31846V203 45,302.50 First American Govt Obligation Fund 1.000 0.61 %45,302.50 0.00 45,302.50 0.00
Purchase 10/30/2017 459058FY4 2,000,000.00 Intl. Bank Recon & Development Note
2% Due 1/26/2022
99.516 2.12 %1,990,320.00 10,444.44 2,000,764.44 0.00
Purchase 10/31/2017 31846V203 46,406.25 First American Govt Obligation Fund 1.000 0.63 %46,406.25 0.00 46,406.25 0.00
Purchase 10/31/2017 90CAMP$00 22,883.11 Public Financial Management CAMP 1.000 1.16 %22,883.11 0.00 22,883.11 0.00
Execution Time: 11/22/2017 12:49:00 PMChandler Asset Management - CONFIDENTIAL Page 8
Attachment II
Transaction Ledger
9/30/17 Thru 10/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 10/31/2017 912828L57 500,000.00 US Treasury Note
1.75% Due 9/30/2022
98.754 2.02 %493,769.53 745.19 494,514.72 0.00
Subtotal 7,840,554.86 7,799,156.11 11,910.78 7,811,066.89 0.00
Security
Contribution
10/13/2017 90CAMP$00 4,400,000.00 Public Financial Management CAMP 1.000 4,400,000.00 0.00 4,400,000.00 0.00
Security
Contribution
10/24/2017 90CAMP$00 3,000,000.00 Public Financial Management CAMP 1.000 3,000,000.00 0.00 3,000,000.00 0.00
Subtotal 7,400,000.00 7,400,000.00 0.00 7,400,000.00 0.00
TOTAL ACQUISITIONS 15,240,554.86 15,199,156.11 11,910.78 15,211,066.89 0.00
DISPOSITIONS
Sale 10/06/2017 912828G61 2,500,000.00 US Treasury Note
1.5% Due 11/30/2019
99.941 1.53 %2,498,535.16 13,114.75 2,511,649.91 -3,834.10
Sale 10/27/2017 313381B20 2,000,000.00 FHLB Note
0.75% Due 12/8/2017
99.960 1.10 %1,999,200.00 5,791.67 2,004,991.67 -799.54
Sale 10/30/2017 31846V203 2,000,764.44 First American Govt Obligation Fund 1.000 0.61 %2,000,764.44 0.00 2,000,764.44 0.00
Sale 10/31/2017 31846V203 494,514.72 First American Govt Obligation Fund 1.000 0.63 %494,514.72 0.00 494,514.72 0.00
Subtotal 6,995,279.16 6,993,014.32 18,906.42 7,011,920.74 -4,633.64
Paydown 10/16/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 10/16/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 10/16/2017 47788BAB0 0.00 John Deere Owner Trust 2017-B A2A
1.59% Due 4/15/2020
100.000 0.00 602.88 602.88 0.00
Paydown 10/16/2017 47788BAD6 0.00 John Deere Owner Trust 2017-B A3
1.82% Due 10/15/2021
100.000 0.00 485.33 485.33 0.00
Paydown 10/16/2017 47788MAC4 0.00 John Deere Owner Trust 2016-A A3
1.36% Due 4/15/2020
100.000 0.00 1,263.66 1,263.66 0.00
Paydown 10/16/2017 47788NAB4 110,760.57 John Deere Owner Trust 2016-B A2
1.09% Due 2/15/2019
100.000 110,760.57 639.90 111,400.47 0.00
Paydown 10/16/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
Execution Time: 11/22/2017 12:49:00 PMChandler Asset Management - CONFIDENTIAL Page 9
Attachment II
Transaction Ledger
9/30/17 Thru 10/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 10/16/2017 65478WAB1 65,327.08 Nissan Auto Receivables Owner 2016-C
A2A
1.07% Due 5/15/2019
100.000 65,327.08 464.12 65,791.20 0.00
Paydown 10/16/2017 89231LAB3 94,794.62 Toyota Auto Receivables Owner 2016-D
1.06% Due 5/15/2019
100.000 94,794.62 725.50 95,520.12 0.00
Paydown 10/16/2017 89236WAC2 46,729.75 Toyota Auto Receivables Owner 2015-A
1.12% Due 2/15/2019
100.000 46,729.75 268.73 46,998.48 0.00
Paydown 10/18/2017 43814PAB6 0.00 Honda Auto Receivables Owner T 17-3 A2
1.57% Due 1/21/2020
100.000 0.00 381.16 381.16 0.00
Paydown 10/23/2017 43813NAC0 80,228.40 Honda Auto Receivables 2015-2 A3
1.04% Due 2/21/2019
100.000 80,228.40 425.76 80,654.16 0.00
Paydown 10/23/2017 43814TAB8 75,430.52 Honda Auto Receivables 2017-1 A2
1.42% Due 7/22/2019
100.000 75,430.52 954.97 76,385.49 0.00
Subtotal 473,270.94 473,270.94 8,734.97 482,005.91 0.00
Security
Withdrawal
10/25/2017 31846V203 104.17 First American Govt Obligation Fund 1.000 104.17 0.00 104.17 0.00
Security
Withdrawal
10/30/2017 90CAMP$00 4,900,000.00 Public Financial Management CAMP 1.000 4,900,000.00 0.00 4,900,000.00 0.00
Subtotal 4,900,104.17 4,900,104.17 0.00 4,900,104.17 0.00
TOTAL DISPOSITIONS 12,368,654.27 12,366,389.43 27,641.39 12,394,030.82 -4,633.64
OTHER TRANSACTIONS
Interest 10/02/2017 3137EADM8 2,500,000.00 FHLMC Note
1.25% Due 10/2/2019
0.000 15,625.00 0.00 15,625.00 0.00
Interest 10/05/2017 3135G0T45 3,250,000.00 FNMA Note
1.875% Due 4/5/2022
0.000 29,622.39 0.00 29,622.39 0.00
Interest 10/07/2017 3135G0Q89 2,000,000.00 FNMA Note
1.375% Due 10/7/2021
0.000 13,750.00 0.00 13,750.00 0.00
Interest 10/08/2017 68389XAX3 1,250,000.00 Oracle Corp Note
2.25% Due 10/8/2019
0.000 14,062.50 0.00 14,062.50 0.00
Interest 10/22/2017 94974BFU9 1,900,000.00 Wells Fargo Corp Note
2.125% Due 4/22/2019
0.000 20,187.50 0.00 20,187.50 0.00
Interest 10/30/2017 713448CR7 1,430,000.00 PepsiCo Inc Note
1.25% Due 4/30/2018
0.000 8,937.50 0.00 8,937.50 0.00
Interest 10/30/2017 713448CS5 1,330,000.00 PepsiCo Inc Callable Note Cont 3/30/2020
1.85% Due 4/30/2020
0.000 12,302.50 0.00 12,302.50 0.00
Execution Time: 11/22/2017 12:49:00 PMChandler Asset Management - CONFIDENTIAL Page 10
Attachment II
Transaction Ledger
9/30/17 Thru 10/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 10/30/2017 912828WZ9 2,750,000.00 US Treasury Note
1.75% Due 4/30/2022
0.000 24,062.50 0.00 24,062.50 0.00
Interest 10/31/2017 912828K58 1,750,000.00 US Treasury Note
1.375% Due 4/30/2020
0.000 12,031.25 0.00 12,031.25 0.00
Interest 10/31/2017 912828L99 5,000,000.00 US Treasury Note
1.375% Due 10/31/2020
0.000 34,375.00 0.00 34,375.00 0.00
Subtotal 23,160,000.00 184,956.14 0.00 184,956.14 0.00
Dividend 10/02/2017 31846V203 383,012.22 First American Govt Obligation Fund 0.000 577.49 0.00 577.49 0.00
Dividend 10/15/2017 90LAIF$00 3,694,377,948.9
4
Local Agency Investment Fund State Pool 0.000 108,723.50 0.00 108,723.50 0.00
Dividend 10/31/2017 90CAMP$00 22,416,176.73 Public Financial Management CAMP 0.000 22,883.11 0.00 22,883.11 0.00
Subtotal 3,717,177,137.8
9
132,184.10 0.00 132,184.10 0.00
TOTAL OTHER TRANSACTIONS 3,740,337,137.8
9
317,140.24 0.00 317,140.24 0.00
Execution Time: 11/22/2017 12:49:00 PMChandler Asset Management - CONFIDENTIAL Page 11
Attachment II
Transaction Ledger
10/31/17 Thru 11/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 11/01/2017 31846V203 457.16 First American Govt Obligation Fund 1.000 0.63 %457.16 0.00 457.16 0.00
Purchase 11/03/2017 31846V203 31,750.00 First American Govt Obligation Fund 1.000 0.63 %31,750.00 0.00 31,750.00 0.00
Purchase 11/08/2017 06538CCD1 3,170,000.00 Bank of Tokyo Mitsubishi NY Discount CP
1.45% Due 3/13/2018
99.497 1.48 %3,154,039.93 0.00 3,154,039.93 0.00
Purchase 11/08/2017 31846V203 3,160,000.00 First American Govt Obligation Fund 1.000 0.63 %3,160,000.00 0.00 3,160,000.00 0.00
Purchase 11/13/2017 31846V203 11,743.06 First American Govt Obligation Fund 1.000 0.63 %11,743.06 0.00 11,743.06 0.00
Purchase 11/15/2017 31846V203 932.46 First American Govt Obligation Fund 1.000 0.63 %932.46 0.00 932.46 0.00
Purchase 11/15/2017 31846V203 818.75 First American Govt Obligation Fund 1.000 0.63 %818.75 0.00 818.75 0.00
Purchase 11/15/2017 31846V203 602.88 First American Govt Obligation Fund 1.000 0.63 %602.88 0.00 602.88 0.00
Purchase 11/15/2017 31846V203 485.33 First American Govt Obligation Fund 1.000 0.63 %485.33 0.00 485.33 0.00
Purchase 11/15/2017 31846V203 17,739.80 First American Govt Obligation Fund 1.000 0.63 %17,739.80 0.00 17,739.80 0.00
Purchase 11/15/2017 31846V203 143,384.02 First American Govt Obligation Fund 1.000 0.63 %143,384.02 0.00 143,384.02 0.00
Purchase 11/15/2017 31846V203 3,938.93 First American Govt Obligation Fund 1.000 0.63 %3,938.93 0.00 3,938.93 0.00
Purchase 11/15/2017 31846V203 69,398.88 First American Govt Obligation Fund 1.000 0.63 %69,398.88 0.00 69,398.88 0.00
Purchase 11/15/2017 31846V203 98,459.28 First American Govt Obligation Fund 1.000 0.63 %98,459.28 0.00 98,459.28 0.00
Purchase 11/15/2017 31846V203 47,292.73 First American Govt Obligation Fund 1.000 0.63 %47,292.73 0.00 47,292.73 0.00
Purchase 11/16/2017 31846V203 10,500.00 First American Govt Obligation Fund 1.000 0.63 %10,500.00 0.00 10,500.00 0.00
Purchase 11/19/2017 31846V203 17,550.00 First American Govt Obligation Fund 1.000 0.63 %17,550.00 0.00 17,550.00 0.00
Purchase 11/20/2017 31846V203 28,500.00 First American Govt Obligation Fund 1.000 0.63 %28,500.00 0.00 28,500.00 0.00
Purchase 11/20/2017 31846V203 750,000.00 First American Govt Obligation Fund 1.000 0.63 %750,000.00 0.00 750,000.00 0.00
Purchase 11/20/2017 31846V203 601.83 First American Govt Obligation Fund 1.000 0.63 %601.83 0.00 601.83 0.00
Purchase 11/21/2017 31846V203 75,412.77 First American Govt Obligation Fund 1.000 0.63 %75,412.77 0.00 75,412.77 0.00
Purchase 11/21/2017 31846V203 74,456.43 First American Govt Obligation Fund 1.000 0.63 %74,456.43 0.00 74,456.43 0.00
Purchase 11/29/2017 3137EAEK1 2,400,000.00 FHLMC Note
1.875% Due 11/17/2020
99.889 1.91 %2,397,336.00 1,750.00 2,399,086.00 0.00
Purchase 11/29/2017 31846V203 603,053.17 First American Govt Obligation Fund 1.000 0.63 %603,053.17 0.00 603,053.17 0.00
Purchase 11/30/2017 31846V203 100,000.00 First American Govt Obligation Fund 1.000 0.68 %100,000.00 0.00 100,000.00 0.00
Purchase 11/30/2017 4581X0CZ9 2,500,000.00 Inter-American Dev Bank Note
1.75% Due 9/14/2022
98.067 2.18 %2,451,675.00 9,236.11 2,460,911.11 0.00
Subtotal 13,317,077.48 13,250,128.41 10,986.11 13,261,114.52 0.00
Execution Time: 12/26/2017 3:00:13 PMChandler Asset Management - CONFIDENTIAL Page 8
Attachment II
Transaction Ledger
10/31/17 Thru 11/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
Short Sale 11/08/2017 31846V203 -3,154,039.93 First American Govt Obligation Fund 1.000 -3,154,039.93 0.00 -3,154,039.93 0.00
Subtotal -3,154,039.93 -3,154,039.93 0.00 -3,154,039.93 0.00
TOTAL ACQUISITIONS 10,163,037.55 10,096,088.48 10,986.11 10,107,074.59 0.00
DISPOSITIONS
Closing
Purchase
11/08/2017 31846V203 -3,154,039.93 First American Govt Obligation Fund 1.000 -3,154,039.93 0.00 -3,154,039.93 0.00
Subtotal -3,154,039.93 -3,154,039.93 0.00 -3,154,039.93 0.00
Sale 11/08/2017 31846V203 3,154,039.93 First American Govt Obligation Fund 1.000 0.63 %3,154,039.93 0.00 3,154,039.93 0.00
Sale 11/29/2017 3137EADP1 3,000,000.00 FHLMC Note
0.875% Due 3/7/2018
99.872 1.34 %2,996,160.00 5,979.17 3,002,139.17 -2,769.26
Sale 11/30/2017 31846V203 2,460,911.11 First American Govt Obligation Fund 1.000 0.68 %2,460,911.11 0.00 2,460,911.11 0.00
Subtotal 8,614,951.04 8,611,111.04 5,979.17 8,617,090.21 -2,769.26
Paydown 11/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 11/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 11/15/2017 47788BAB0 0.00 John Deere Owner Trust 2017-B A2A
1.59% Due 4/15/2020
100.000 0.00 602.88 602.88 0.00
Paydown 11/15/2017 47788BAD6 0.00 John Deere Owner Trust 2017-B A3
1.82% Due 10/15/2021
100.000 0.00 485.33 485.33 0.00
Paydown 11/15/2017 47788MAC4 16,476.13 John Deere Owner Trust 2016-A A3
1.36% Due 4/15/2020
100.000 16,476.13 1,263.67 17,739.80 0.00
Paydown 11/15/2017 47788NAB4 142,844.73 John Deere Owner Trust 2016-B A2
1.09% Due 2/15/2019
100.000 142,844.73 539.29 143,384.02 0.00
Paydown 11/15/2017 654747AB0 3,167.18 Nissan Auto Receivables 2017-A A2A
1.47% Due 1/15/2020
100.000 3,167.18 771.75 3,938.93 0.00
Paydown 11/15/2017 65478WAB1 68,993.01 Nissan Auto Receivables Owner 2016-C
A2A
1.07% Due 5/15/2019
100.000 68,993.01 405.87 69,398.88 0.00
Execution Time: 12/26/2017 3:00:13 PMChandler Asset Management - CONFIDENTIAL Page 9
Attachment II
Transaction Ledger
10/31/17 Thru 11/30/17
City of Dublin Consolidated
Account #10221
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price
Acq/Disp
Yield Amount
Interest
Pur/Sold Total Amount Gain/Loss
DISPOSITIONS
Paydown 11/15/2017 89231LAB3 97,817.52 Toyota Auto Receivables Owner 2016-D
1.06% Due 5/15/2019
100.000 97,817.52 641.76 98,459.28 0.00
Paydown 11/15/2017 89236WAC2 47,067.61 Toyota Auto Receivables Owner 2015-A
1.12% Due 2/15/2019
100.000 47,067.61 225.12 47,292.73 0.00
Paydown 11/20/2017 43814PAB6 0.00 Honda Auto Receivables Owner T 17-3 A2
1.57% Due 1/21/2020
100.000 0.00 601.83 601.83 0.00
Paydown 11/21/2017 43813NAC0 75,056.54 Honda Auto Receivables 2015-2 A3
1.04% Due 2/21/2019
100.000 75,056.54 356.23 75,412.77 0.00
Paydown 11/21/2017 43814TAB8 73,590.72 Honda Auto Receivables 2017-1 A2
1.42% Due 7/22/2019
100.000 73,590.72 865.71 74,456.43 0.00
Subtotal 525,013.44 525,013.44 8,510.65 533,524.09 0.00
Maturity 11/08/2017 06538BY80 3,160,000.00 Bank of Tokyo Mitsubishi NY Discount CP
1.33% Due 11/8/2017
99.542 3,160,000.00 0.00 3,160,000.00 0.00
Maturity 11/20/2017 36962G6K5 750,000.00 General Electric Capital Corp Note
1.6% Due 11/20/2017
100.000 750,000.00 0.00 750,000.00 0.00
Subtotal 3,910,000.00 3,910,000.00 0.00 3,910,000.00 0.00
Security
Withdrawal
11/27/2017 31846V203 104.17 First American Govt Obligation Fund 1.000 104.17 0.00 104.17 0.00
Security
Withdrawal
11/30/2017 90CAMP$00 4,880,272.31 Public Financial Management CAMP 1.000 4,880,272.31 0.00 4,880,272.31 0.00
Subtotal 4,880,376.48 4,880,376.48 0.00 4,880,376.48 0.00
TOTAL DISPOSITIONS 14,776,301.03 14,772,461.03 14,489.82 14,786,950.85 -2,769.26
OTHER TRANSACTIONS
Interest 11/03/2017 00440EAT4 2,000,000.00 ACE INA Holdings Inc Callable Note Cont
10/3/2020
2.3% Due 11/3/2020
0.000 23,000.00 0.00 23,000.00 0.00
Interest 11/03/2017 037833AJ9 1,750,000.00 Apple Inc Note
1% Due 5/3/2018
0.000 8,750.00 0.00 8,750.00 0.00
Interest 11/13/2017 40428HPN6 1,000,000.00 HSBC USA Inc Note
2.375% Due 11/13/2019
0.000 11,743.06 0.00 11,743.06 0.00
Interest 11/16/2017 166764BG4 1,000,000.00 Chevron Corp Callable Note Cont 4/15/2021
2.1% Due 5/16/2021
0.000 10,500.00 0.00 10,500.00 0.00
Interest 11/19/2017 857477AV5 1,800,000.00 State Street Bank Note
1.95% Due 5/19/2021
0.000 17,550.00 0.00 17,550.00 0.00
Execution Time: 12/26/2017 3:00:13 PMChandler Asset Management - CONFIDENTIAL Page 10
Attachment II
Transaction Ledger
10/31/17 Thru 11/30/17
City of Dublin Consolidated
Account #10221
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price
Acq/Disp
Yield Amount
Interest
Pur/Sold Total Amount Gain/Loss
OTHER TRANSACTIONS
Interest 11/20/2017 36962G6K5 750,000.00 General Electric Capital Corp Note
1.6% Due 11/20/2017
0.000 6,000.00 0.00 6,000.00 0.00
Interest 11/20/2017 747525AD5 2,000,000.00 Qualcomm Inc Note
2.25% Due 5/20/2020
0.000 22,500.00 0.00 22,500.00 0.00
Interest 11/30/2017 3135G0F73 2,500,000.00 FNMA Note
1.5% Due 11/30/2020
0.000 18,750.00 0.00 18,750.00 0.00
Interest 11/30/2017 3137EADG1 1,000,000.00 FHLMC Note
1.75% Due 5/30/2019
0.000 8,750.00 0.00 8,750.00 0.00
Interest 11/30/2017 912828G61 2,000,000.00 US Treasury Note
1.5% Due 11/30/2019
0.000 15,000.00 0.00 15,000.00 0.00
Interest 11/30/2017 912828U65 2,500,000.00 US Treasury Note
1.75% Due 11/30/2021
0.000 21,875.00 0.00 21,875.00 0.00
Interest 11/30/2017 912828XE5 3,000,000.00 US Treasury Note
1.5% Due 5/31/2020
0.000 22,500.00 0.00 22,500.00 0.00
Interest 11/30/2017 912828XR6 1,500,000.00 US Treasury Note
1.75% Due 5/31/2022
0.000 13,125.00 0.00 13,125.00 0.00
Subtotal 22,800,000.00 200,043.06 0.00 200,043.06 0.00
Dividend 11/01/2017 31846V203 580,952.14 First American Govt Obligation Fund 0.000 457.16 0.00 457.16 0.00
Subtotal 580,952.14 457.16 0.00 457.16 0.00
TOTAL OTHER TRANSACTIONS 23,380,952.14 200,500.22 0.00 200,500.22 0.00
Execution Time: 12/26/2017 3:00:13 PMChandler Asset Management - CONFIDENTIAL Page 11
Attachment II
Transaction Ledger
11/30/17 Thru 12/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 12/01/2017 31846V203 623.72 First American Govt Obligation Fund 1.000 0.68 %623.72 0.00 623.72 0.00
Purchase 12/08/2017 31846V203 12,500.00 First American Govt Obligation Fund 1.000 0.68 %12,500.00 0.00 12,500.00 0.00
Purchase 12/11/2017 31846V203 28,125.00 First American Govt Obligation Fund 1.000 0.68 %28,125.00 0.00 28,125.00 0.00
Purchase 12/12/2017 31846V203 17,500.00 First American Govt Obligation Fund 1.000 0.68 %17,500.00 0.00 17,500.00 0.00
Purchase 12/14/2017 31846V203 14,062.50 First American Govt Obligation Fund 1.000 0.68 %14,062.50 0.00 14,062.50 0.00
Purchase 12/15/2017 31846V203 21,281.41 First American Govt Obligation Fund 1.000 0.68 %21,281.41 0.00 21,281.41 0.00
Purchase 12/15/2017 31846V203 5,852.73 First American Govt Obligation Fund 1.000 0.68 %5,852.73 0.00 5,852.73 0.00
Purchase 12/15/2017 31846V203 602.88 First American Govt Obligation Fund 1.000 0.68 %602.88 0.00 602.88 0.00
Purchase 12/15/2017 31846V203 485.33 First American Govt Obligation Fund 1.000 0.68 %485.33 0.00 485.33 0.00
Purchase 12/15/2017 31846V203 69,821.30 First American Govt Obligation Fund 1.000 0.68 %69,821.30 0.00 69,821.30 0.00
Purchase 12/15/2017 31846V203 103,207.05 First American Govt Obligation Fund 1.000 0.68 %103,207.05 0.00 103,207.05 0.00
Purchase 12/15/2017 31846V203 50,369.53 First American Govt Obligation Fund 1.000 0.68 %50,369.53 0.00 50,369.53 0.00
Purchase 12/15/2017 31846V203 66,006.47 First American Govt Obligation Fund 1.000 0.68 %66,006.47 0.00 66,006.47 0.00
Purchase 12/15/2017 31846V203 87,780.59 First American Govt Obligation Fund 1.000 0.68 %87,780.59 0.00 87,780.59 0.00
Purchase 12/15/2017 31846V203 42,161.09 First American Govt Obligation Fund 1.000 0.68 %42,161.09 0.00 42,161.09 0.00
Purchase 12/18/2017 31846V203 601.83 First American Govt Obligation Fund 1.000 0.68 %601.83 0.00 601.83 0.00
Purchase 12/21/2017 31846V203 71,358.57 First American Govt Obligation Fund 1.000 0.68 %71,358.57 0.00 71,358.57 0.00
Purchase 12/21/2017 31846V203 72,455.22 First American Govt Obligation Fund 1.000 0.68 %72,455.22 0.00 72,455.22 0.00
Purchase 12/24/2017 31846V203 15,032.50 First American Govt Obligation Fund 1.000 0.68 %15,032.50 0.00 15,032.50 0.00
Purchase 12/29/2017 912828L57 750,000.00 US Treasury Note
1.75% Due 9/30/2022
97.941 2.21 %734,560.55 3,245.19 737,805.74 0.00
Purchase 12/31/2017 31846V203 50,625.00 First American Govt Obligation Fund 1.000 0.87 %50,625.00 0.00 50,625.00 0.00
Purchase 12/31/2017 90CAMP$00 32,918.56 Public Financial Management CAMP 1.000 1.36 %32,918.56 0.00 32,918.56 0.00
Subtotal 1,513,371.28 1,497,931.83 3,245.19 1,501,177.02 0.00
Security
Contribution
12/08/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
Contribution
12/18/2017 90CAMP$00 22,000,000.00 Public Financial Management CAMP 1.000 22,000,000.00 0.00 22,000,000.00 0.00
Subtotal 24,500,000.00 24,500,000.00 0.00 24,500,000.00 0.00
TOTAL ACQUISITIONS 26,013,371.28 25,997,931.83 3,245.19 26,001,177.02 0.00
Execution Time: 1/12/2018 10:49:05 AMChandler Asset Management - CONFIDENTIAL Page 8
Attachment II
Transaction Ledger
11/30/17 Thru 12/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 12/29/2017 31846V203 737,805.74 First American Govt Obligation Fund 1.000 0.68 %737,805.74 0.00 737,805.74 0.00
Subtotal 737,805.74 737,805.74 0.00 737,805.74 0.00
Paydown 12/15/2017 43814QAC2 20,348.95 Honda Auto Receivables 2016-2 A3
1.39% Due 4/15/2020
100.000 20,348.95 932.46 21,281.41 0.00
Paydown 12/15/2017 47787XAB3 5,033.98 John Deere Owner Trust 2017-A A2
1.5% Due 10/15/2019
100.000 5,033.98 818.75 5,852.73 0.00
Paydown 12/15/2017 47788BAB0 0.00 John Deere Owner Trust 2017-B A2A
1.59% Due 4/15/2020
100.000 0.00 602.88 602.88 0.00
Paydown 12/15/2017 47788BAD6 0.00 John Deere Owner Trust 2017-B A3
1.82% Due 10/15/2021
100.000 0.00 485.33 485.33 0.00
Paydown 12/15/2017 47788MAC4 68,576.31 John Deere Owner Trust 2016-A A3
1.36% Due 4/15/2020
100.000 68,576.31 1,244.99 69,821.30 0.00
Paydown 12/15/2017 47788NAB4 102,797.51 John Deere Owner Trust 2016-B A2
1.09% Due 2/15/2019
100.000 102,797.51 409.54 103,207.05 0.00
Paydown 12/15/2017 654747AB0 49,601.66 Nissan Auto Receivables 2017-A A2A
1.47% Due 1/15/2020
100.000 49,601.66 767.87 50,369.53 0.00
Paydown 12/15/2017 65478WAB1 65,662.12 Nissan Auto Receivables Owner 2016-C
A2A
1.07% Due 5/15/2019
100.000 65,662.12 344.35 66,006.47 0.00
Paydown 12/15/2017 89231LAB3 87,225.23 Toyota Auto Receivables Owner 2016-D
1.06% Due 5/15/2019
100.000 87,225.23 555.36 87,780.59 0.00
Paydown 12/15/2017 89236WAC2 41,979.90 Toyota Auto Receivables Owner 2015-A
1.12% Due 2/15/2019
100.000 41,979.90 181.19 42,161.09 0.00
Paydown 12/18/2017 43814PAB6 0.00 Honda Auto Receivables Owner T 17-3 A2
1.57% Due 1/21/2020
100.000 0.00 601.83 601.83 0.00
Paydown 12/21/2017 43813NAC0 71,067.39 Honda Auto Receivables 2015-2 A3
1.04% Due 2/21/2019
100.000 71,067.39 291.18 71,358.57 0.00
Paydown 12/21/2017 43814TAB8 71,676.59 Honda Auto Receivables 2017-1 A2
1.42% Due 7/22/2019
100.000 71,676.59 778.63 72,455.22 0.00
Subtotal 583,969.64 583,969.64 8,014.36 591,984.00 0.00
Execution Time: 1/12/2018 10:49:05 AMChandler Asset Management - CONFIDENTIAL Page 9
Attachment II
Transaction Ledger
11/30/17 Thru 12/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
12/26/2017 31846V203 104.17 First American Govt Obligation Fund 1.000 104.17 0.00 104.17 0.00
Subtotal 104.17 104.17 0.00 104.17 0.00
TOTAL DISPOSITIONS 1,321,879.55 1,321,879.55 8,014.36 1,329,893.91 0.00
OTHER TRANSACTIONS
Interest 12/08/2017 313379DT3 2,000,000.00 FHLB Note
1.25% Due 6/8/2018
0.000 12,500.00 0.00 12,500.00 0.00
Interest 12/11/2017 313379RB7 3,000,000.00 FHLB Note
1.875% Due 6/11/2021
0.000 28,125.00 0.00 28,125.00 0.00
Interest 12/12/2017 313383HU8 2,000,000.00 FHLB Note
1.75% Due 6/12/2020
0.000 17,500.00 0.00 17,500.00 0.00
Interest 12/14/2017 3135G0G72 2,500,000.00 FNMA Note
1.125% Due 12/14/2018
0.000 14,062.50 0.00 14,062.50 0.00
Interest 12/24/2017 166764AE0 1,750,000.00 Chevron Corp Callable Note Cont 5/24/2018
1.718% Due 6/24/2018
0.000 15,032.50 0.00 15,032.50 0.00
Interest 12/31/2017 912828G95 3,000,000.00 US Treasury Note
1.625% Due 12/31/2019
0.000 24,375.00 0.00 24,375.00 0.00
Interest 12/31/2017 912828XW5 3,000,000.00 US Treasury Note
1.75% Due 6/30/2022
0.000 26,250.00 0.00 26,250.00 0.00
Subtotal 17,250,000.00 137,845.00 0.00 137,845.00 0.00
Dividend 12/01/2017 31846V203 212,974.41 First American Govt Obligation Fund 0.000 623.72 0.00 623.72 0.00
Dividend 12/31/2017 90CAMP$00 42,058,787.53 Public Financial Management CAMP 0.000 32,918.56 0.00 32,918.56 0.00
Subtotal 42,271,761.94 33,542.28 0.00 33,542.28 0.00
TOTAL OTHER TRANSACTIONS 59,521,761.94 171,387.28 0.00 171,387.28 0.00
Execution Time: 1/12/2018 10:49:05 AMChandler Asset Management - CONFIDENTIAL Page 10
Attachment II