HomeMy WebLinkAbout4.8 City Treasurer's Informational Report of Investments for the Quarter Ending September 30, 2021STAFF REPORT
CITY COUNCIL
Page 1 of 5
Agenda Item 4.8
DATE:November 16, 2021
TO:Honorable Mayor and City Councilmembers
FROM:Linda Smith, City Manager
SUBJECT:City Treasurer's Informational Report of Investments for the Quarter Ending September 30, 2021Prepared by:Chris Rhoades,Financial Analyst
EXECUTIVE SUMMARY:The City Council will receive an informational report of the City’s investments through the quarter ending September 30, 2021 including a monthly transaction ledger. The City’s investment portfolio for this period totaled $328,128,102 (market value) with an average market yield of 0.44%. 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 City Treasurer's Informational Report of Investments for the Quarter Ending September 30, 2021.
FINANCIAL IMPACT:There is no financial impact resulting from this report. 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 revenues and expenditures, the quarterly cash balance can vary from quarter to quarter.
DESCRIPTION:The total investment portfolio (market value) consists of $234,606,258 managed by Chandler Asset Management and $93,521,844 invested by the City in local government pools, the Local Agency Investment Fund (LAIF) and the California Asset Management Program (CAMP). The average market yield of the Chandler portfolio and the local pools was 0.56% and 0.14% respectively. The total investment portfolio balance fluctuates throughout the year due to normal cash flow
152
Page 2 of 5
needs and includes both discretionary and restricted funds. Economic Update HighlightsThe following are some highlights from the Economic Update included in the Investment Report prepared by Chandler (Attachment 1).While some pockets of the economy remain dislocated, US real gross domestic product has recovered to pre-pandemic levels. The recovery has been fueled by robust fiscal spending, accommodative monetary policy, and vaccinations. These factors are beginning to moderate but should continue to provide tailwinds for the economy in the coming quarters. COVID-19 infection rates have started to decline, but the health crisis continues to disrupt economic activity and has weighed on consumer sentiment. Supply chain and labor market disruptions are also likely to continue over the near to intermediate term, putting ongoing upward pressure on transportation and labor costs. Some pandemic-related fiscal relief has started to phase out, but an infrastructure spending plan is on the horizon. Meanwhile, the Federal Reserve remains accommodative and continues to facilitate further improvement in the labor market. Overall, Chandler believes the US economy continues to grow at a strong, pace but that economic data will remain somewhat choppy over the near-term. The Federal Open Market Committee (FOMC) kept monetary policy unchanged at its September meeting but indicated that they are preparing to reduce the magnitude of their asset purchases. The fed funds target rate remains in the range of 0.0%to 0.25%. For now, the Fed continues to purchase $80 billion of Treasuries per month, and $40 billion of agency mortgage-backed securities per month. However, the Fed is now widely expected to make the official announcement about tapering asset purchases at the next FOMC meeting in early November. The tapering process would likely commence December 1st, and Fed Chair Powell signaled that asset purchases would likely end by mid-2022. The projected timeline for liftoff on rate hikes was also pulled forward in the Fed’s updated summary of economic projections. The median estimate among Fed policymakers now calls for one 25-basis-point rate hike in 2022, versus the previous outlook of no rate hikes next year. Chandler believes the Fed will be cautious as it moves toward a slow and steady withdrawal of monetary policy accommodation, amid a backdrop of an improving labor market and growing economy.City of Dublin PortfolioThe City's aggregate portfolio has maintained a healthy balance of investment types with minimal change from the prior quarter as shown below in Chart 1.
Chart 1: Investments by TypeJune 30, 2021and March31, 2021
153
Page 3 of 5
The market value of the City's portfolio decreased by $4,131,027 from the June 30, 2021 quarter. The quarterly change results from the normal fluctuations in the timing of incoming revenue,predominantly the receipt of property tax allocations and sales tax revenue, expenditures on Capital Projects, and payments to Alameda County for Police and Fire Services. The City’s portfolio increased $23.3 million from the same quarter the prior year due to the excess of revenues over expenditures trending on an annual basis (see Table 1 below). Overall market yield-to-maturity stays consistent at 0.44% (shown in Table 2) due to the factors discussed in theEconomic Update Highlights. For detailed monthly transactions, see Attachment 2.
154
Page 4 of 5
Table 1: Portfolio Values and Yield to Maturity
Table 2: Quarterly Holdings (Market Value) by Type, and YTM, 5 Quarters
Funds Managed by the City The following table present the quarterly yields for LAIF and CAMP over the most recent eight quarters.
September 30, 2020
Holdings Market Value
Market
Value
Par
Value
Book
Value
Market
Value
% of
Subtotal
% of Total
Portfolio
Book
Yield
Market
Yield
Managed by City
LAIF 50,069,345 50,323,677 50,364,764 50,364,764 50,364,764 53.9%15.6%0.21%0.21%
CAMP 37,890,432 47,323,490 43,129,270 43,129,270 43,129,270 46.1%13.4%0.05%0.05%
SUBTOTAL 87,959,776.47 97,647,167 93,494,034 93,494,034 93,494,034 100.00%28.95%0.14%0.14%
Accrued Interest 100,879.68 38,855 27,810
88,060,656.15 97,686,022 93,521,844
Managed by Chandler
ABS 10,967,071 9,835,052 13,652,190 13,654,440 13,665,558 5.8%4.2%0.67%0.38%
Agency 86,962,937 75,581,659 63,570,000 63,894,533 65,306,279 27.9%19.7%1.63%0.46%
CMO - - 2,000,000 2,140,390 2,138,464 0.9%0.6%0.72%0.76%
Money Market 287,330 756,163 809,873 809,873 809,873 0.3%0.3%0.01%0.01%
Negotiable CD 2,499,825 2,500,000 2,500,000 2,500,588 1.1%0.8%0.20%0.17%
Supranational 6,901,940 19,043,767 22,740,000 22,696,181 22,656,506 9.7%7.0%0.96%0.69%
Corporate 48,948,015 54,161,172 56,155,000 56,642,598 57,831,563 24.7%17.4%1.94%0.77%
US Treasury 61,909,753 71,745,729 68,000,000 67,926,800 68,951,352 29.5%21.1%1.52%0.48%
SUBTOTAL 215,977,047 233,623,366 229,427,063 230,264,815 233,860,181 100.00%71.05%1.52%0.56%
Accrued Interest 822,822 949,741 746,077
216,799,869 234,573,108 234,606,258
TOTAL PORTFOLIO 304,860,526 332,259,129 322,921,097 323,758,849 328,128,102 100.00%0.44%
23,267,576
(4,131,027)
September 30, 2021
Change from Prior Year
Change from Prior Quarter
June 30, 2021
Holdings (Market Value)9/30/20 12/31/20 3/31/21 6/30/21 9/30/21
LAIF/CAMP 87,959,776 109,794,497 95,786,151 97,647,167 93,494,034
ABS 10,967,071 8,651,697 7,785,198 9,835,052 13,665,558
Agency 86,962,937 88,099,396 78,831,782 75,581,659 65,306,279
CMO - - - - 2,138,464
Money Market 287,330 1,494,033 7,546,801 756,163 809,873
Negotiable CD - - - 2,499,825 2,500,588
Supranational 6,901,940 9,291,429 14,391,293 19,043,767 22,656,506
Corporate 48,948,015 49,090,006 48,771,479 54,161,172 57,831,563
US Treasury 61,909,753 59,632,976 67,900,673 71,745,729 68,951,352
Accrued Interest 923,702 1,069,828 847,391 988,596 773,887
TOTAL 304,860,526 327,123,861 321,860,767 332,259,129 328,128,102
YIELD TO MATURITY 0.34%0.28%0.39%0.39%0.44%
155
Page 5 of 5
Table 3: Quarterly Portfolio Yields, Recent 8Quarters
Market Yield LAIF CAMP Chandler
9/30/19 2.25%2.25%1.81%
12/31/19 2.03%1.77%1.75%
3/31/20 1.74%1.50%0.89%
6/30/20 1.15%0.48%0.36%
9/30/20 0.66%0.25%0.30%
12/31/20 0.52%0.12%0.27%
3/31/21 0.35%0.07%0.46%
6/30/21 0.25%0.05%0.49%
9/30/21 0.21%0.05%0.56%
STRATEGIC PLAN INITIATIVE:Strategy 2: Explore New City Revenue Streams for Long Term Financial StabilityObjective 2D: Continue to maintain strong fiscal policies.
NOTICING REQUIREMENTS/PUBLIC OUTREACH:The City Council Agenda was posted.
ATTACHMENTS:1) City of Dublin Investment Report for Period Ending September 20212) Transaction Ledger – July through September 2021
156
CHANDLER ASSET MANAGEMENT, INC. | 800.317.4747 | www.chandlerasset.com
INVESTMENT REPORT
Period Ending September 30, 2021
City of Dublin
Attachment 1
157
SECTION 1 Economic Update
SECTION 2 Account Profile
SECTION 3 Consolidated Information
SECTION 4 Portfolio Holdings
SECTION 5 Transactions
Table of Contents As of September 30, 2021
1
158
SECTION |Section 1 |Economic Update
2
159
Economic Update
While some p ockets of the economy remain dislocated,US real gross domestic product (GDP)has recovered to pre-
pandemic levels.The recovery has been fueled by robust fiscal spending,accommodative monetary policy,and
vaccinations.These factors are beginning to moderate but should continue to provide tailwinds for the economy in the
coming quarters.Covid infection rates have started to decline, but the health crisis continues to disrupt economic activity
and has weighed on consumer sentiment.Supply chain and labor market disruptions are also likely to continue over the
near-to intermediate-term,putting ongoing upward pressure on transportation,input,and labor costs.Some pandemic-
related fiscal relief has started to phase out,but an infrastructure spending plan is on the horizon.Meanwhile,the Federal
Reserve remains accommodative and continues to facilitate further improvement in the labor market.Overall,we believe
the US economy continues to grow at a strong,above-trend,pace but we believe economic data will remain somewhat
choppy over the near-term.
The Federal Open Market Committee (FOMC)kept monetary policy unchanged at its September meeting but indicated that
they are preparing to reduce the magnitude of their asset purchases.The fed funds target rate remains in the range of 0.0%
to 0.25%.For now,the Fed continues to purchase $80 billion of Treasuries per month,and $40 billion of agency mortgage-
backed securities permonth.However,the Fed is now widely expected to make the official announcement abouttapering
asset purchases at the next FOMC meeting in early November.The tapering process would likely commence December 1st,
and Fed Chair Powell signaled that asset purchases would likely end by mid-2022.The projected timeline for liftoff on rate
hikes was also pulled forward in the Fed’s updated summary of economic projections.The median estimate among Fed
policymakers now calls for one 25 basis point rate hike in 2022,versus the previous outlook for no rate hikes next year.
Monetary policy remains highly accommodative for now but the Fed is moving toward a path of policy normalization.We
believe the Fed will be cautious as it moves toward a slow and steady withdrawal of monetary policy accommodation,amid
a backdrop of an improving labor market and growing economy.
The Treasury yield curve steepened in September.The 10-year Treasury yield rose nearly 18 basis points in September to
1.49%,while the 2-year Treasury yield rose about seven basis points to 0.28%.We believe some of the factors that put
downward pressure on longer-term rates over the summer including concerns about the Delta COVID-19 variant,market
technicals,and uneven global vaccination rates,have started to ease.We expect the front-end of the curve to remain
anchored near zero over the near-term and believe the yield curve may be poised for further steepening.At the end of
September, the 10-year Treasury yield was down about 25 basis points from its high this year in March.
3
160
Source: US Department of Labor Source: US Department of Labor
Employment
Job growth was weaker than expected in September,but the unemployment rate fell below 5%for the first time since March 2020.U.S.
nonfarm payrolls increased by 194,000 in September,versus the consensus forecast of 500,000.However,July and August payrolls were revised
up a total of 169,000.On a trailing 3-month and 6-month basis,payrolls increased at a solid pace,up an average of 550,000 and 582,000 per
month,respectively.The U-3 unemployment rate declined to 4.8%in September from 5.2%in August,a bigger decline than expected.The
labor participation rate declined slightly to 61.6%in September but the employment-population ratio increased modestly to 58.7%.The U-6
underemployment rate,which includes those who are marginally attached to the labor force and employed part time for economic reasons,
declined to 8.5%in September from 8.8%in August. Annualized average hourly earnings were up by 4.6%in September versus 4.0%in August,
reflecting strong wage growth driven in part by the ongoing imbalance in the supply and demand for labor.Although labor force participation
has been slow to recover and more than 7.6 million people remain unemployed,the labor market has made significant progress over the past
year.
-22,000
-18,000
-14,000
-10,000
-6,000
-2,000
2,000
6,000
MOM Change In (000's)Nonfarm Payroll (000's)
Non-farm Payroll (000's)
3 month average (000's)
0.0%
4.0%
8.0%
12.0%
16.0%
20.0%
24.0%
Unemployment Rate
Underemployment Rate (U6)
Unemployment Rate (U3)Rate (%)4
161
Initial Claims for Unemployment
326 364 351 335 312 345 354 349 377 387 399 424 368 386
2,714 2,811 2,820 2,715 2,852 2,805 2,908 2,865 2,899 2,980
3,296 3,262 3,265
-
1,000
2,000
3,000
4,000
5,000
6,000
In thousandsInitial Jobless Claims
Continuing Claims
Initial Claims For Unemployment July 02, 2021 -October 01, 2021
In the most recent week,the number of initial jobless claims was 326,000 versus 364,000 in the prior week.The level of continuing
unemployment claims (where the data is lagged by one week)declined to 2.714 million from 2.811 million in the prior week.Continuing
jobless claims have declined significantly from the peak of nearly 25 million in May 2020,but they remained above the 2019 (pre-pandemic)
average of 1.7 million.
Source: US Department of Labor
5
162
Source: US Department of Labor Source: US Department of Commerce
Inflation
The Consumer Price Index (CPI)was up 5.3%year-over-year in August,versus up 5.4%year-over-year in July.Core CPI (CPI less food and
energy)was up 4.0%year-over-year in August (below expectations),versus up 4.3%in July,suggesting that pricing pressures may be easing
slightly.The Personal Consumption Expenditures (PCE)index was up 4.3%year-over-year in August,versus up 4.2%in July.Core PCE was up
3.6%year-over-year in August, unchanged from July.Current inflation readings are running well above the Fed’s longer-run target of around
2.0%.While the Fed believes many of the factors fueling higher inflation will be temporary,the upward pressure on inflation from supply
chain bottlenecks and pandemic-related disruptions is likely to remain elevated over the near-term.
0.0%
0.5%
1.0%
1.5%
2.0%
2.5%
3.0%
3.5%
4.0%
4.5%
5.0%
5.5%
6.0%
Personal Consumption Expenditures (PCE)
PCE Price Deflator YOY % Change
PCE Core Deflator YOY % Change
YOY( %) Change0.0%
0.5%
1.0%
1.5%
2.0%
2.5%
3.0%
3.5%
4.0%
4.5%
5.0%
5.5%
6.0%
Consumer Price Index (CPI)
CPI YOY % Change
Core CPI YOY % Change
YOY( %) Change6
163
On a year-over-year basis,retail sales were up 15.1%in August.On a month-over-month basis,retail sales were stronger than expected in
August, up 0.7%versus expectations of a 0.7%decline.The month-over-month gain was driven largely by increases in online shopping,
furniture and home furnishings,and general merchandise stores.These gains were partially offset by declines in vehicles,electronics and
appliances, sporting goods,hobby,musical instrument,and bookstores, on a seasonally adjusted basis.Excluding vehicles and gas,retail sales
were up 2.0% month-over-month, following a 1.4% decline in July. In our view, the August retail sales report indicates that consumers have the
propensity to spend but their spending patterns continue to be influenced by the pandemic,with the delta virus outbreak driving more people
back to online shopping in the month.Furthermore,we believe high prices fueled by supply chain constraints on bigger ticket items like
vehicles and appliances may now be pressuring sales of those items.The Consumer Confidence index declined to 109.3 in September from
115.2 in August. Consumers remain concerned about the Delta variant and the economic impact of the virus.
Source: US Department of Commerce Source: The Conference Board
-30.0%
-20.0%
-10.0%
0.0%
10.0%
20.0%
30.0%
40.0%
50.0%
60.0%
Retail Sales YOY % Change
YOY (%) Change80
90
100
110
120
130
140
Index LevelConsumer Confidence
Consumer
7
164
Source: The Conference Board Source: Federal Reserve Bank of Chicago
Economic Activity
The Conference Board’s Leading Economic Index (LEI)increased 0.9%month-over-month in August (slightly above expectations),following a
0.8%increase in July.On a year-over-year basis,the LEI was up 10.0%in August.According to the Conference Board,the LEI’s sharp increase in
August suggests the economy is on a rapidly rising trajectory.The Conference Board is forecasting 6.0%GDP growth for 2021 and 4.0%GDP
growth in 2022.Meanwhile,the Chicago Fed National Activity Index (CFNAI)declined to 0.29 in August from 0.75 in July, pulled down by
production and employment.However,on a 3-month moving average basis,the CFNAI improved to 0.43 in August from 0.36 in July.A reading
above zero signals above-trend economic growth.
-8.00
-6.00
-4.00
-2.00
0.00
2.00
4.00
6.00
Chicago Fed National Activity Index (CFNAI)3 Month Average-8.0%
-6.0%
-4.0%
-2.0%
0.0%
2.0%
4.0%
Leading Economic Indicators (LEI)MOM ( %) Change8
165
Source: US Department of Commerce Source: S&P
Housing
0
200
400
600
800
1000
1200
1400
1600
1800
2000
MOM Change (In Thousands of Units)Housing Starts
Multi Family Housing Starts
Single Family Housing Starts
0.0%
3.0%
6.0%
9.0%
12.0%
15.0%
18.0%
21.0%
24.0%
S&P/Case -Shiller 20 City Composite Home Price Index YOY( %) ChangeTotal housing starts increased 3.9%in August to an annual pace of 1,615,000,led by multi-family starts.Single-family starts declined 2.8%in
August whilemulti-family starts rose 20.6%.On a year-over-year basis,housing starts were up 17.4%in August.According to the Case-Shiller 20-
City home price index,home prices were up 20.0%year-over-year in July versus up 19.1%year-over-year in June.Low mortgage rates and tight
supply continue to support prices.
9
166
Source: Institute for Supply Management Source: Federal Reserve
Manufacturing
The Institute for Suppl y Management (ISM)manufacturing index increased to 61.1 in September from 59.9 in August.The index points to
continued strength in manufacturing,as readings above 50.0 are indicative of expansion in the manufacturing sector.New orders were
particularly strong,increasing to 66.7 in August from 64.9 in July,which The Industrial Production index was up 6.0%year-over-year in August,
versus up 6.6%in July.On a month-over-month basis,the Industrial Production index increased 0.4%in August,following a 0.8%increase in
July.Capacity Utilization increased to 76.4%in August from 76.2%in July but remains well below the long-run average of 79.8%.Chip shortages
and other supply chain bottlenecks continue to weigh on activity in the manufacturing sector.
40
42
44
46
48
50
52
54
56
58
60
62
64
66
Institute of Supply Management Purchasing Manager
Index
EXPANDING
CONTRACTING
-20.0%
-15.0%
-10.0%
-5.0%
0.0%
5.0%
10.0%
15.0%
20.0%
Industrial Production
YOY( %) Change10
167
Source: US Department of Commerce Source: US Department of Commerce
9/20 12/20 3/21 6/21
25.5% 2.3% 7.4% 7.9%
11.7% 4.0% -0.4% -0.7%
-3.3% -1.7% -1.6% -0.2%
-0.3% -0.2% 0.8% -0.4%
0.1% 0.1% 0.0% 0.0%
33.8% 4.5% 6.3% 6.7%
Components of GDP
Federal Government Expenditures
State and Local (Consumption and Gross
Investment)
Net Exports and Imports
Total
Gross Private Domestic Investment
Personal Consumption Expenditures
-35.0%
-30.0%
-25.0%
-20.0%
-15.0%
-10.0%
-5.0%
0.0%
5.0%
10.0%
15.0%
20.0%
25.0%
30.0%
35.0%
Gross Domestic Product (GDP)
GDP QOQ % Change
GDP YOY % Change
Gross Domestic Product (GDP)
Real US gross domestic product (GDP)grew at an annualized rate of 6.7%in the second quarter,following 6.3%growth in the first quarter.As of
the second quarter, real US GDP had exceeded its pre-pandemic level.The consensus forecast for full year 2021 US gross domestic product
growth has moderated but remains well above the long-run trend growth rate of about 1.8%.The current Bloomberg consensus estimates for
2021 and 2022 US GDP growth are 5.9% and 4.1%, respectively, following a 3.4% decline in 2020.
11
168
Federal Reserve
Source: Federal Reserve Source: Bloomberg
Last year,the Fed took a wide range of aggressive actions to help stabilize and provide liquidity to the financial markets.The Fed lowered the
fed funds target rate to a range of 0.0%-0.25%and started purchasing Treasury and agency mortgage-backed securities (MBS)to support
smooth market functioning.Last year,policymakers reinstated the Commercial Paper Funding Facility and Money Market Mutual Fund
Liquidity Facility.The Fed also established the Primary Market Corporate Credit Facility,Secondary Market Corporate Credit Facility,Term
Asset-Backed Securities Loan Facility,Paycheck Protection Program Liquidity Facility,Main Street Lending Facility,and Municipal Liquidity
Facility.The Fed has also provided short-term funding through large-scale repo operations and lowered the reserve requirement for
depository institutions.Notably, many of the Fed's lending facilities expired at the end of 2020,including the Fed’s corporate credit,asset-
backed securities,municipal lending,and Main Street Lending programs.In June 2021,the Fed announced plans to unwind its corporate credit
facility.The Fed is now widely expected to start tapering their Treasury and agency MBS purchases before this year-end,and stop making asset
purchases around the middle of next year.
0.00%
0.50%
1.00%
1.50%
2.00%
Effective Federal Funds Rate
Yield (%)3,000,000
4,000,000
5,000,000
6,000,000
7,000,000
8,000,000
9,000,000
Federal Reserve Balance Sheet Assets
In$ millions12
169
Source: Bloomberg Source: Bloomberg
0.0%
0.5%
1.0%
1.5%
2.0%
2.5%
3.0%
US Treasury Note Yields
2-Year
5-Year
10-Year
Yield (%)0.0%
0.5%
1.0%
1.5%
2.0%
2.5%
3.0%
US Treasury Yield Curve
Sep-21
Jun-21
Sep-20
Yield (%)Bond Yields
The treasury yield curve is steeper on a year-over-year basis.At the end of September,the 2-year Treasury yield was about 15 basis points
higher and the 10-Year Treasury yield was about 80 basis points higher,year-over-year.However,the yield curve was less steep than the
historical average.The spread between the 2-year Treasury yield and 10-year Treasury yield was 121 basis points at September month-end
compared to the average historical spread (since 2002)of about 135 basis points.We believe the curve remains poised for furthersteepening,
amid a growing economy and improving labor market, while the Fed is expected to slowly normalize monetary policy.
13
170
Section 2|SECTION |Section 2 |Account Profile
14
171
Objectives
Chandler Asset Management Performance Objective
The performance objective of the City of Dublin is to earn a return that equals or exceeds the return on of
the ICE BAML 1-5 Year Treasury 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.
As of September 30, 2021
15
172
Compliance As of September 30, 2021
Category Standard Comment
U.S. Treasury Issues No limitations; Full faith and credit of the U.S. are pledged for payment of principal and interest.Complies
Federal Agencies
35% max per agency issuer; 25% max callables for agency securities; Federal Agencies or U.S. Government Sponsored Enterprises (GSE),
participations, or other instruments, including those issued by or fully guaranteed as to principal and interest by federal agencies or U.S.
GSEs.
Complies
Municipal Securities "A" rated or higher by a NRSRO; 5% max per issuer; Obligations of the State of California, any of the other 49 states, or any local agency
within the state of California; Complies
Supranational Securities
"AA" rating category or better by a Nationally Recognized Statistical Rating Organization ("NRSRO"); 30% maximum; 10% max per issuer; U.S.
dollar denominated senior unsecured unsubordinated obligations issued or unconditionally guaranteed by the International Bank for
Reconstruction and Development ("IBRD"), the International Finance Corporation ("IFC") or the Inter-American Development Bank ("IADB")
Complies
Asset-Backed Securities/Mortgage-
Backed Securities/ Collateralized
Mortgage Obligations
"AA" rated or higher by a NRSRO; 20% maximum (combined); 5% max per issuer Complies
Corporate 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
Negotiable Certificates of Deposit
"A" long-term debt rated and/or "A-1" short-term rated or higher 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; Issued by a nationally or state-
chartered bank, a savings association or a federal association, a state or federal credit union, or by a state-licensed branch of a foreign bank.
Complies
Time Deposits/ Certificates of Deposit 10% maximum; Collateralized/FDIC Insured; 1 year max maturity Complies
Commercial Paper
"A-1" rated or higher by a NRSRO; 25% maximum; 5% max per issuer; 10% max of the outstanding commercial paper of an issuing
corporation; 20% max amount invested in CP of any one issuer in combination with any other debt from that issuer; 270 days max maturity;
Issuer of the commercial paper shall meet all conditions in either A) (1) Organized and operating in the U.S. as a general corp, (2) Has AUM >
$500 million, (3) "A" rated issuer debt (if any) or higher by a NRSRO; or B) (1) Organized in the U.S. as a special purpose corp, trust, LLC, (2)
Has program wide credit enhancements including, but not limited to, over collateralization, LOC, or surety bond, (3) "A-1" rated or higher by
a NRSRO
Complies
Banker’s Acceptances "A-1" short-term 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
Money Market Mutual Funds and
Mutual Funds
Highest rating or "AAA" rated by two NRSROs; SEC registered adviser with AUM >$500 million and experience > 5 years; 20% maximum in
Mutual Funds and Money Market Mutual Funds; 20% max in Money Market Mutual Fund; 10% max per one Mutual Fund Complies
Local Agency Investment Fund (LAIF) Maximum permitted by LAIF; Not used by investment adviser Complies
California Asset Management Program
(CAMP)Issued by joint powers authority organized pursuant to California Government Code; Not used by investment adviser Complies
Prohibited Securities Inverse floaters; Ranges notes, Mortgage-derived, Interest-only strips; Any investment in a security not specifically listed as an Authorized
and Suitable Investment in the policy.Complies
Max Per Issuer 5% max per issuer, except US Government, its Agencies and instrumentalities (including agency backed-mortgage pools), Supranational
securities, or Money Market Mutual Funds Complies
Maximum Maturity 5 years, unless otherwise stated in the policy Complies
City of Dublin
Assets managed by Chandler Asset Management are in full compliance with state law and with the City's investment policy.
16
173
Portfolio Characteristics
City of Dublin
9/30/2021 6/30/2021
Benchmark*Portfolio Portfolio
Average Maturity (yrs)2.65 2.80 2.76
Average Modified Duration 2.58 2.58 2.57
Average Purchase Yield n/a 1.52%1.60%
Average Market Yield 0.46%0.56%0.49%
Average Quality**AAA AA/Aa1 AA/Aa1
Total Market Value 234,606,258 234,573,108
*ICE BofA 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.
As of September 30, 2021
17
174
City of Dublin
Sector Distribution
ABS
5.8%
Agency
27.9%
Corporate
24.8%
Money Market
Fund
0.3%
Negotiable CD
1.1%
Supranational
9.7%
US Treasury
29.5%
CMO
0.9%
September 30, 2021 June 30, 2021
ABS
4.2%
Agency
32.4%
Corporate
23.2%
Money Market
Fund
0.3%
Negotiable CD
1.1%
Supranational
8.1%
US Treasury
30.7%
As of September 30, 2021
18
175
Issue Name Investment Type % Portfolio
Government of United States US Treasury 29.46%
Federal National Mortgage Association Agency 11.75%
Federal Home Loan Bank Agency 8.75%
Inter-American Dev Bank Supranational 5.33%
Federal Home Loan Mortgage Corp Agency 4.59%
Intl Bank Recon and Development Supranational 4.35%
Federal Farm Credit Bank Agency 2.86%
JP Morgan Chase & Co Corporate 1.79%
Bank of America Corp Corporate 1.62%
US Bancorp Corporate 1.59%
Honda Motor Corporation Corporate 1.55%
Royal Bank of Canada Corporate 1.55%
Charles Schwab Corp/The Corporate 1.47%
Toronto Dominion Holdings Corporate 1.46%
Apple Inc Corporate 1.36%
Morgan Stanley Corporate 1.30%
Hyundai Auot Receivables ABS 1.19%
Chubb Corporation Corporate 1.15%
Honeywell Corp Corporate 1.09%
Bank of Nova Scotia Houston Negotiable CD 1.07%
Bank of Montreal Chicago Corporate 1.06%
Toyota Motor Corp Corporate 1.06%
PNC Financial Services Group Corporate 1.00%
John Deere ABS ABS 1.00%
Federal Home Loan Mortgage Corp CMO 0.91%
Deere & Company Corporate 0.91%
Wal-Mart Stores Corporate 0.87%
Berkshire Hathaway Corporate 0.82%
Amazon.com Inc Corporate 0.79%
Nissan ABS ABS 0.67%
Toyota ABS ABS 0.61%
Hyundai Auto Lease Securitization ABS 0.60%
Metlife Inc Corporate 0.55%
Bank of New York Corporate 0.54%
Honda ABS ABS 0.51%
Mercedes-Benz Auto Lease Trust ABS 0.48%
Toyota Lease Owner Trust ABS 0.46%
ChevronTexaco Corp Corporate 0.45%
Issuers
City of Dublin –Account #10198
As of September 30, 2021
19
176
Issue Name Investment Type % Portfolio
First American Govt Oblig Fund Money Market Fund 0.35%
Merck & Company Corporate 0.33%
BMW Vehicle Lease Trust ABS 0.30%
United Health Group Inc Corporate 0.26%
Salesforce.com Inc Corporate 0.20%
TOTAL 100.00%
Issuers
City of Dublin –Account #10198
As of September 30, 2021
20
177
AAA AA A <A NR
09/30/21 14.1%64.5%17.5%1.3%2.7%
06/30/21 11.8%69.4%15.9%1.3%1.6%
Source: S&P Ratings
September 30, 2021 vs. June 30, 2021
0.0%
10.0%
20.0%
30.0%
40.0%
50.0%
60.0%
70.0%
80.0%
AAA AA A <A NR
9/30/2021 6/30/2021
Quality Distribution
City of Dublin
As of September 30, 2021
21
178
0.0%
5.0%
10.0%
15.0%
20.0%
25.0%
30.0%
35.0%
40.0%
0 - 0.25 0.25 - 0.50 0.50 - 1 1 - 2 2 - 3 3 - 4 4 - 5 5+
City of Dublin ICE BofA 1-5 Yr US Treasury & Agency Index
Portfolio Compared to the Benchmark as of September 30, 2021
0 -0.25 0.25 -0.50 0.50 - 1 1 - 2 2 - 3 3 - 4 4 - 5 5+
Portfolio 1.1% 3.0% 10.2% 20.9% 26.5% 21.9% 16.4% 0.0%
Benchmark*0.0% 0.0% 1.7% 34.6% 27.9% 18.7% 17.0% 0.0%
*ICE BofA 1-5 Yr US Treasury & Agency Index
Duration Distribution
City of Dublin
As of September 30, 2021
22
179
-1.00%
-0.50%
0.00%
0.50%
1.00%
1.50%
2.00%
2.50%
3.00%
3.50%
4.00%
12 months 2 years 3 years 5 years 10 years Since Inception
City of Dublin ICE BofA 1-5 Yr US Treasury & Agency Index
Total Rate of Return Annualized Since Inception 10/31/2013
Annualized
TOTAL RATE OF RETURN 3 months 12 months 2 years 3 years 5 years 10 years Since
Inception
City of Dublin 0.01%-0.08%2.25%3.32%2.03%N/A 1.78%
ICE BofA 1-5 Yr US Treasury & Agency Index 0.01%-0.38%2.06%3.23%1.80%N/A 1.61%
*ICE BofA 1-3 Yr US Treasury & Agency Index to 12/31/14
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.
Investment Performance
City of Dublin
As of September 30, 2021
23
180
Portfolio Characteristics
City of Dublin Reporting Account
9/30/2021
Portfolio
6/30/2021
Portfolio
Average Maturity (yrs)0.00 0.00
Modified Duration 0.00 0.00
Average Purchase Yield 0.14%0.15%
Average Market Yield 0.14%0.15%
Average Quality*AAA/NR AAA/NR
Total Market Value 93,521,844 97,686,022
*Portfolio is S&P and Moody’s, respectively.
As of September 30, 2021
24
181
City of Dublin Reporting Account
Sector Distribution
LAIF
53.9%
Local Gov
Investment Pool
46.1%
September 30, 2021 June 30, 2021
LAIF
51.6%
Local Gov
Investment Pool
48.4%
As of September 30, 2021
25
182
Issue Name Investment Type % Portfolio
Local Agency Investment Fund LAIF 53.88%
CAMP Local Gov Investment Pool 46.12%
TOTAL 100.00%
Issuers
City of Dublin Reporting Account –Account #10219
As of September 30, 2021
26
183
SECTION |Section 3 |Consolidated Information
27
184
Portfolio Characteristics
City of Dublin Consolidated
9/30/2021 6/30/2021
Portfolio Portfolio
Average Maturity (yrs)2.00 1.95
Modified Duration 1.84 1.81
Average Purchase Yield 1.12%1.17%
Average Market Yield 0.44%0.39%
Average Quality*AA+/Aa1 AA+/Aa1
Total Market Value 328,128,102 332,259,129
* Portfolio is S&P and Moody’s respectively.
As of September 30, 2021
28
185
City of Dublin Consolidated
Sector Distribution
ABS
4.2%
Agency
20.0%
Corporate
17.7%
LAIF
15.4%
Local Gov
Investment Pool
13.1%
Money Market
Fund
0.2%
Negotiable CD
0.8%
Supranational
6.9%
US Treasury
21.1%
CMO
0.7%
September 30, 2021 June 30, 2021
ABS
3.0%
Agency
22.9%
Corporate
16.4%
LAIF
15.2%
Local Gov
Investment Pool
14.2%
Money Market
Fund
0.2%
Negotiable CD
0.8%
Supranational
5.8%
US Treasury
21.7%
As of September 30, 2021
29
186
SECTION |Section 4 |Portfolio Holdings
30
187
Holdings Report
City of Dublin -Account #10198
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
43815HAC1 Honda Auto Receivables Trust 2018-3 A3
2.950% Due 08/22/2022
68,037.50 08/21/2018
2.56%
68,028.17
68,035.42
100.22
0.22%
68,190.31
55.75
0.03%
154.89
Aaa / NR
AAA
0.89
0.08
47788EAC2 John Deere Owner Trust 2018-B A3
3.080% Due 11/15/2022
61,991.45 07/18/2018
3.10%
61,986.75
61,990.23
100.19
0.18%
62,110.04
84.86
0.03%
119.81
Aaa / NR
AAA
1.13
0.07
65479GAD1 Nissan Auto Receivables Trust 2018-B A3
3.060% Due 03/15/2023
232,614.05 07/17/2018
3.08%
232,606.50
232,613.25
100.49
0.41%
233,753.16
316.36
0.10%
1,139.91
Aaa / AAA
NR
1.45
0.18
89231PAD0 Toyota Auto Receivables Trust 2018-D A3
3.180% Due 03/15/2023
407,621.51 08/29/2019
2.04%
416,331.24
411,191.62
100.67
0.30%
410,335.86
576.11
0.18%
(855.76)
Aaa / AAA
NR
1.45
0.23
44891VAC5 Hyundai Auto Lease Trust 2021-B A3
0.330% Due 06/17/2024
1,420,000.00 06/08/2021
0.34%
1,419,787.00
1,419,814.76
99.90
0.39%
1,418,570.06
208.27
0.60%
(1,244.70)
Aaa / AAA
NR
2.72
1.63
65479JAD5 Nissan Auto Receivables Owner 2019-C A3
1.930% Due 07/15/2024
1,311,925.08 10/16/2019
1.94%
1,311,855.82
1,311,884.25
101.00
0.22%
1,325,031.21
1,125.34
0.57%
13,146.96
Aaa / AAA
NR
2.79
0.58
89237VAB5 Toyota Auto Receivables Trust 2020-C A3
0.440% Due 10/15/2024
1,025,000.00 07/21/2020
0.44%
1,024,921.08
1,024,943.15
100.18
0.25%
1,026,857.30
200.44
0.44%
1,914.15
Aaa / AAA
NR
3.04
0.93
43813KAC6 Honda Auto Receivables Trust 2020-3 A3
0.370% Due 10/18/2024
1,120,000.00 09/22/2020
0.38%
1,119,835.47
1,119,888.21
100.11
0.28%
1,121,251.04
149.64
0.48%
1,362.83
NR / AAA
AAA
3.05
1.20
89239CAC3 Toyota Lease Owner Trust 2021-B A3
0.420% Due 10/21/2024
1,090,000.00 07/27/2021
0.42%
1,089,985.28
1,089,986.26
100.00
0.42%
1,089,991.28
139.88
0.46%
5.02
Aaa / NR
AAA
3.06
1.96
47787NAC3 John Deere Owner Trust 2020-B A3
0.510% Due 11/15/2024
515,000.00 07/14/2020
0.52%
514,921.51
514,948.41
100.21
0.30%
516,080.47
116.73
0.22%
1,132.06
Aaa / NR
AAA
3.13
0.97
58769KAD6 Mercedes-Benz Auto Lease Trust 2021-B A3
0.400% Due 11/15/2024
1,135,000.00 06/22/2021
0.40%
1,134,914.31
1,134,922.97
99.98
0.41%
1,134,733.28
201.78
0.48%
(189.69)
NR / AAA
AAA
3.13
1.80
09690AAC7 BMW Vehicle Lease Trust 2021-2 A3
0.330% Due 12/26/2024
710,000.00 09/08/2021
0.34%
709,926.73
709,928.14
99.91
0.38%
709,343.25
104.13
0.30%
(584.89)
Aaa / NR
AAA
3.24
1.77
47788UAC6 John Deere Owner Trust 2021-A A3
0.360% Due 09/15/2025
800,000.00 03/02/2021
0.37%
799,846.24
799,870.21
99.91
0.41%
799,316.80
128.00
0.34%
(553.41)
Aaa / NR
AAA
3.96
1.78
44933LAC7 Hyundai Auto Receivables Trust 2021-A A3
0.380% Due 09/15/2025
725,000.00 04/20/2021
0.38%
724,923.73
724,934.42
99.96
0.40%
724,704.93
122.44
0.31%
(229.49)
NR / AAA
AAA
3.96
1.75
44934KAC8 Hyundai Auto Receivables Trust 2021-B A3
0.380% Due 01/15/2026
2,065,000.00 07/20/2021
0.39%
2,064,544.25
2,064,570.12
99.80
0.48%
2,060,936.08
348.76
0.88%
(3,634.04)
NR / AAA
AAA
4.30
2.08
47789QAC4 John Deere Owner Trust 2021-B A3
0.520% Due 03/16/2026
965,000.00 07/13/2021
0.52%
964,913.92
964,918.57
99.93
0.55%
964,352.49
223.02
0.41%
(566.08)
Aaa / NR
AAA
4.46
2.41
TOTAL ABS 13,652,189.59 0.67%
13,659,328.00
13,654,439.99 0.38%
13,665,557.56
4,101.51
5.83%
11,117.57
Aaa / AAA
Aaa
3.30
1.52
As of September 30, 2021
31
188
Holdings Report
City of Dublin -Account #10198
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
Agency
313378CR0 FHLB Note
2.250% Due 03/11/2022
2,000,000.00 06/19/2017
1.86%
2,035,280.00
2,003,292.80
100.96
0.10%
2,019,204.00
2,500.00
0.86%
15,911.20
Aaa / AA+
NR
0.44
0.45
3135G0T45 FNMA Note
1.875% Due 04/05/2022
3,250,000.00 05/05/2017
1.99%
3,232,125.00
3,248,145.71
100.92
0.08%
3,279,916.25
29,791.67
1.41%
31,770.54
Aaa / AA+
AAA
0.51
0.51
3135G0T94 FNMA Note
2.375% Due 01/19/2023
2,500,000.00 03/28/2018
2.70%
2,463,675.00
2,490,179.64
102.83
0.20%
2,570,665.00
11,875.00
1.10%
80,485.36
Aaa / AA+
AAA
1.30
1.28
313383QR5 FHLB Note
3.250% Due 06/09/2023
1,500,000.00 08/28/2018
2.87%
1,525,005.00
1,508,826.98
105.08
0.24%
1,576,215.00
15,166.67
0.68%
67,388.02
Aaa / AA+
NR
1.69
1.64
3137EAEN5 FHLMC Note
2.750% Due 06/19/2023
2,000,000.00 07/16/2018
2.88%
1,988,360.00
1,995,947.36
104.29
0.25%
2,085,816.00
15,583.33
0.90%
89,868.64
Aaa / AA+
AAA
1.72
1.68
3135G05G4 FNMA Note
0.250% Due 07/10/2023
2,350,000.00 07/08/2020
0.32%
2,344,947.50
2,347,014.64
99.97
0.26%
2,349,405.45
1,321.88
1.00%
2,390.81
Aaa / AA+
AAA
1.78
1.77
3133EKZK5 FFCB Note
1.600% Due 08/14/2023
4,000,000.00 08/26/2019
1.54%
4,009,000.00
4,004,238.95
102.43
0.30%
4,097,068.00
8,355.56
1.75%
92,829.05
Aaa / AA+
AAA
1.87
1.85
313383YJ4 FHLB Note
3.375% Due 09/08/2023
5,000,000.00 Various
2.90%
5,102,615.00
5,042,280.17
106.03
0.26%
5,301,390.00
10,781.25
2.26%
259,109.83
Aaa / AA+
NR
1.94
1.89
3130A0F70 FHLB Note
3.375% Due 12/08/2023
5,000,000.00 Various
2.73%
5,147,870.00
5,065,692.57
106.66
0.32%
5,332,915.00
52,968.75
2.30%
267,222.43
Aaa / AA+
AAA
2.19
2.11
3135G0V34 FNMA Note
2.500% Due 02/05/2024
2,000,000.00 02/27/2019
2.58%
1,992,340.00
1,996,359.06
105.02
0.35%
2,100,310.00
7,777.78
0.90%
103,950.94
Aaa / AA+
AAA
2.35
2.28
3130A1XJ2 FHLB Note
2.875% Due 06/14/2024
3,795,000.00 Various
1.96%
3,958,639.85
3,883,597.20
106.45
0.47%
4,039,868.58
32,428.80
1.74%
156,271.38
Aaa / AA+
NR
2.71
2.60
3133EKWV4 FFCB Note
1.850% Due 07/26/2024
2,500,000.00 08/13/2019
1.65%
2,524,140.00
2,513,738.97
103.70
0.53%
2,592,395.00
8,350.69
1.11%
78,656.03
Aaa / AA+
AAA
2.82
2.75
3130A2UW4 FHLB Note
2.875% Due 09/13/2024
2,000,000.00 10/10/2019
1.58%
2,122,020.00
2,073,117.04
106.89
0.52%
2,137,726.00
2,875.00
0.91%
64,608.96
Aaa / AA+
AAA
2.96
2.85
3135G0W66 FNMA Note
1.625% Due 10/15/2024
2,000,000.00 11/08/2019
1.80%
1,983,400.00
1,989,757.64
103.32
0.52%
2,066,426.00
14,986.11
0.89%
76,668.36
Aaa / AA+
AAA
3.04
2.95
3135G0X24 FNMA Note
1.625% Due 01/07/2025
4,200,000.00 Various
1.18%
4,287,898.80
4,259,429.24
103.39
0.58%
4,342,317.00
15,925.00
1.86%
82,887.76
Aaa / AA+
AAA
3.27
3.18
3137EAEP0 FHLMC Note
1.500% Due 02/12/2025
4,200,000.00 Various
1.23%
4,254,786.30
4,237,346.91
102.85
0.64%
4,319,632.80
8,575.00
1.84%
82,285.89
Aaa / AA+
AAA
3.37
3.28
3135G03U5 FNMA Note
0.625% Due 04/22/2025
1,825,000.00 04/22/2020
0.67%
1,821,240.50
1,822,322.59
99.77
0.69%
1,820,760.53
5,037.76
0.78%
(1,562.06)
Aaa / AA+
AAA
3.56
3.51
As of September 30, 2021
32
189
Holdings Report
City of Dublin -Account #10198
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
3135G04Z3 FNMA Note
0.500% Due 06/17/2025
3,435,000.00 06/17/2020
0.54%
3,427,889.55
3,429,717.84
99.22
0.71%
3,408,368.45
4,961.67
1.45%
(21,349.39)
Aaa / AA+
AAA
3.72
3.67
3137EAEU9 FHLMC Note
0.375% Due 07/21/2025
1,745,000.00 07/21/2020
0.48%
1,736,309.90
1,738,382.37
98.65
0.74%
1,721,447.74
1,272.40
0.73%
(16,934.63)
Aaa / AA+
AAA
3.81
3.77
3135G05X7 FNMA Note
0.375% Due 08/25/2025
2,755,000.00 08/25/2020
0.47%
2,742,106.60
2,744,934.10
98.43
0.78%
2,711,776.81
1,033.13
1.16%
(33,157.29)
Aaa / AA+
AAA
3.90
3.86
3137EAEX3 FHLMC Note
0.375% Due 09/23/2025
2,655,000.00 09/23/2020
0.44%
2,647,008.45
2,648,633.92
98.34
0.80%
2,610,802.22
221.25
1.11%
(37,831.70)
Aaa / AA+
AAA
3.98
3.94
3135G06G3 FNMA Note
0.500% Due 11/07/2025
2,860,000.00 11/09/2020
0.57%
2,849,761.20
2,851,577.31
98.67
0.83%
2,821,853.32
5,720.00
1.21%
(29,723.99)
Aaa / AA+
AAA
4.11
4.04
TOTAL Agency 63,570,000.00 1.63%
64,196,418.65
63,894,533.01 0.46%
65,306,279.15
257,508.70
27.95%
1,411,746.14
Aaa / AA+
Aaa
2.58
2.53
CMO
3137BFE98 FHLMC K041 A2
3.171% Due 10/25/2024
2,000,000.00 07/01/2021
0.72%
2,151,406.25
2,140,390.23
106.92
0.76%
2,138,464.00
5,285.00
0.91%
(1,926.23)
Aaa / AAA
AAA
3.07
2.86
TOTAL CMO 2,000,000.00 0.72%
2,151,406.25
2,140,390.23 0.76%
2,138,464.00
5,285.00
0.91%
(1,926.23)
Aaa / AAA
Aaa
3.07
2.86
Corporate
91159HHP8 US Bancorp Callable Note Cont 12/23/2021
2.625% Due 01/24/2022
1,000,000.00 05/23/2017
2.35%
1,011,640.00
1,000,577.82
100.54
0.27%
1,005,423.00
4,885.42
0.43%
4,845.18
A2 / A+
A+
0.32
0.23
808513AT2 Charles Schwab Corp Callable Note Cont 12/25/2022
2.650% Due 01/25/2023
2,000,000.00 05/21/2019
2.74%
1,993,920.00
1,997,822.43
102.90
0.29%
2,058,072.00
9,716.67
0.88%
60,249.57
A2 / A
A
1.32
1.22
084670BR8 Berkshire Hathaway Callable Note Cont 1/15/2023
2.750% Due 03/15/2023
1,865,000.00 Various
3.35%
1,818,500.75
1,850,152.31
103.13
0.32%
1,923,320.42
2,279.44
0.82%
73,168.11
Aa2 / AA
A+
1.45
1.27
58933YAF2 Merck & Co Note
2.800% Due 05/18/2023
740,000.00 10/26/2018
3.41%
720,996.80
733,204.15
103.93
0.38%
769,079.04
7,654.89
0.33%
35,874.89
A1 / A+
A+
1.63
1.59
46625HRL6 JP Morgan Chase Callable Note Cont 3/18/2023
2.700% Due 05/18/2023
500,000.00 12/20/2018
3.74%
479,055.00
492,253.22
103.43
0.35%
517,143.50
4,987.50
0.22%
24,890.28
A2 / A-
AA-
1.63
1.43
69353RFL7 PNC Bank Callable Note Cont 5/9/2023
3.500% Due 06/08/2023
2,210,000.00 Various
3.53%
2,206,955.80
2,208,972.87
105.03
0.36%
2,321,101.12
24,279.30
1.00%
112,128.25
A2 / A
A+
1.69
1.56
166764AH3 Chevron Corp Callable Note Cont 3/24/2023
3.191% Due 06/24/2023
1,000,000.00 11/08/2018
3.59%
983,170.00
993,693.75
104.23
0.33%
1,042,320.00
8,597.97
0.45%
48,626.25
Aa2 / AA-
NR
1.73
1.45
As of September 30, 2021
33
190
Holdings Report
City of Dublin -Account #10198
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
931142EK5 Wal-Mart Stores Callable Note Cont 5/26/2023
3.400% Due 06/26/2023
1,380,000.00 Various
3.41%
1,379,641.30
1,379,875.58
105.13
0.29%
1,450,795.39
12,381.66
0.62%
70,919.81
Aa2 / AA
AA
1.74
1.61
02665WCJ8 American Honda Finance Note
3.450% Due 07/14/2023
1,000,000.00 Various
3.54%
996,275.00
998,563.50
105.24
0.50%
1,052,424.00
7,379.17
0.45%
53,860.50
A3 / A-
NR
1.79
1.74
06406RAJ6 Bank of NY Mellon Corp Note
3.450% Due 08/11/2023
1,200,000.00 08/24/2018
3.42%
1,201,836.00
1,200,689.13
105.76
0.35%
1,269,078.00
5,750.00
0.54%
68,388.87
A1 / A
AA-
1.86
1.81
06051GHF9 Bank of America Corp Callable Note 1X 3/5/2023
3.550% Due 03/05/2024
2,400,000.00 Various
2.75%
2,434,650.00
2,417,104.62
104.21
0.59%
2,501,090.40
6,153.33
1.07%
83,985.78
A2 / A-
AA-
2.43
1.40
89114QCB2 Toronto Dominion Bank Note
3.250% Due 03/11/2024
2,300,000.00 03/26/2019
2.95%
2,331,234.00
2,315,392.67
106.25
0.67%
2,443,671.80
4,152.78
1.04%
128,279.13
A1 / A
AA-
2.45
2.36
037833CU2 Apple Inc Callable Note Cont 3/11/2024
2.850% Due 05/11/2024
3,000,000.00 Various
2.56%
3,038,334.00
3,020,204.84
105.56
0.56%
3,166,740.00
33,250.00
1.36%
146,535.16
Aa1 / AA+
NR
2.61
2.35
023135BW5 Amazon.com Inc Note
0.450% Due 05/12/2024
1,865,000.00 05/10/2021
0.50%
1,862,277.10
1,862,629.88
99.77
0.54%
1,860,721.69
3,240.44
0.79%
(1,908.19)
A1 / AA
AA-
2.62
2.59
24422ETT6 John Deere Capital Corp Note
2.650% Due 06/24/2024
2,000,000.00 Various
1.31%
2,093,680.00
2,070,594.97
105.53
0.61%
2,110,660.00
14,280.56
0.91%
40,065.03
A2 / A
A
2.73
2.63
02665WCZ2 American Honda Finance Note
2.400% Due 06/27/2024
1,500,000.00 07/10/2019
2.49%
1,493,742.00
1,496,546.36
104.36
0.79%
1,565,404.50
9,400.00
0.67%
68,858.14
A3 / A-
NR
2.74
2.65
79466LAG9 Salesforce.com Inc Callable Note Cont 7/15/2022
0.625% Due 07/15/2024
465,000.00 06/29/2021
0.64%
464,762.85
464,780.33
100.19
0.39%
465,863.51
637.76
0.20%
1,083.18
A2 / A+
NR
2.79
0.79
78013XZU5 Royal Bank of Canada Note
2.550% Due 07/16/2024
2,500,000.00 09/10/2019
2.28%
2,531,325.00
2,518,044.19
104.90
0.77%
2,622,490.00
13,281.25
1.12%
104,445.81
A2 / A
AA-
2.79
2.69
46647PAU0 JP Morgan Chase & Co Callable Note 1X 7/23/2023
3.797% Due 07/23/2024
2,500,000.00 09/12/2019
2.10%
2,632,175.00
2,576,530.22
105.68
0.64%
2,642,082.50
17,930.28
1.13%
65,552.28
A2 / A-
AA-
2.81
1.75
90331HPL1 US Bank NA Callable Note Cont 12/21/2024
2.050% Due 01/21/2025
2,610,000.00 01/16/2020
2.10%
2,604,440.70
2,606,324.23
103.55
0.93%
2,702,634.12
10,403.75
1.16%
96,309.89
A1 / AA-
AA-
3.31
3.11
00440EAS6 Chubb INA Holdings Inc Note
3.150% Due 03/15/2025
2,500,000.00 Various
0.76%
2,753,600.00
2,702,622.88
107.37
0.98%
2,684,155.00
3,500.00
1.15%
(18,467.88)
A3 / A
A
3.46
3.29
61747YEA9 Morgan Stanley Callable Note Cont 5/30/2024
0.790% Due 05/30/2025
3,040,000.00 05/26/2021
0.73%
3,041,611.70
3,041,476.93
99.68
0.91%
3,030,241.60
8,005.34
1.30%
(11,235.33)
A1 / BBB+
A
3.67
2.63
438516CB0 Honeywell Intl Callable Note Cont 5/1/2025
1.350% Due 06/01/2025
2,500,000.00 06/23/2020
0.85%
2,559,500.00
2,543,944.66
101.60
0.89%
2,540,065.00
11,250.00
1.09%
(3,879.66)
A2 / A
A
3.67
3.48
78015K7H1 Royal Bank of Canada Note
1.150% Due 06/10/2025
1,000,000.00 02/22/2021
0.86%
1,012,240.00
1,010,529.37
100.15
1.11%
1,001,547.00
3,545.83
0.43%
(8,982.37)
A2 / A
AA-
3.70
3.60
02665WDL2 American Honda Finance Note
1.200% Due 07/08/2025
1,000,000.00 08/10/2021
1.00%
1,007,640.00
1,007,372.12
100.51
1.06%
1,005,106.00
2,766.67
0.43%
(2,266.12)
A3 / A-
NR
3.77
3.67
As of September 30, 2021
34
191
Holdings Report
City of Dublin -Account #10198
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
89114QCK2 Toronto Dominion Bank Note
0.750% Due 09/11/2025
1,000,000.00 02/16/2021
0.81%
997,230.00
997,604.10
98.68
1.09%
986,792.00
416.67
0.42%
(10,812.10)
A1 / A
AA-
3.95
3.87
06051GHY8 Bank of America Corp Callable Note Cont 2/13/2025
2.015% Due 02/13/2026
1,250,000.00 03/04/2021
1.07%
1,291,725.00
1,286,934.61
102.51
1.25%
1,281,418.75
3,358.33
0.55%
(5,515.86)
A2 / A-
AA-
4.38
3.25
46647PBH8 JP Morgan Chase & Co Callable Note Mthly 3/13/2025
2.005% Due 03/13/2026
1,000,000.00 04/29/2021
1.20%
1,030,270.00
1,026,970.93
102.40
1.29%
1,023,950.00
1,002.50
0.44%
(3,020.93)
A2 / A-
AA-
4.45
3.33
808513BR5 Charles Schwab Corp Callable Note Cont 4/13/2026
1.150% Due 05/13/2026
1,370,000.00 05/11/2021
1.20%
1,366,821.60
1,367,067.03
100.13
1.12%
1,371,839.91
6,039.42
0.59%
4,772.88
A2 / A
A
4.62
4.39
91324PEC2 United Health Group Inc Callable Note Cont 4/15/2026
1.150% Due 05/15/2026
605,000.00 Various
1.08%
606,957.25
606,838.86
100.03
1.14%
605,171.82
2,551.09
0.26%
(1,667.04)
A3 / A+
A
4.62
4.39
89236TJK2 Toyota Motor Credit Corp Note
1.125% Due 06/18/2026
2,485,000.00 06/15/2021
1.13%
2,483,906.60
2,483,969.47
99.40
1.26%
2,470,017.94
7,998.59
1.06%
(13,951.53)
A1 / A+
A+
4.72
4.56
58989V2D5 Met Tower Global Funding Note
1.250% Due 09/14/2026
1,285,000.00 09/07/2021
1.27%
1,283,817.80
1,283,828.81
99.45
1.37%
1,277,917.08
758.51
0.55%
(5,911.73)
Aa3 / AA-
AA-
4.96
4.78
06368FAC3 Bank of Montreal Note
1.250% Due 09/15/2026
2,500,000.00 Various
1.29%
2,495,539.50
2,495,578.58
99.17
1.42%
2,479,282.50
1,388.89
1.06%
(16,296.08)
A2 / A-
AA-
4.96
4.79
931142ER0 Wal-Mart Stores Callable Note Cont 08/17/2026
1.050% Due 09/17/2026
585,000.00 09/08/2021
1.09%
583,894.35
583,902.83
99.82
1.09%
583,942.91
238.88
0.25%
40.08
Aa2 / AA
AA
4.97
4.74
TOTAL Corporate 56,155,000.00 1.94%
56,793,365.10
56,642,598.25 0.77%
57,831,562.50
253,462.89
24.76%
1,188,964.25
A1 / A
A+
3.01
2.69
Money Market Fund
31846V203 First American Govt Obligation Fund Class Y 809,873.32 Various
0.01%
809,873.32
809,873.32
1.00
0.01%
809,873.32
0.00
0.35%
0.00
Aaa / AAA
AAA
0.00
0.00
TOTAL Money Market Fund 809,873.32 0.01%
809,873.32
809,873.32 0.01%
809,873.32
0.00
0.35%
0.00
Aaa / AAA
Aaa
0.00
0.00
As of September 30, 2021
35
192
Holdings Report
City of Dublin -Account #10198
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
Negotiable CD
06417MQL2 Bank of Nova Scotia Houston Yankee CD
0.200% Due 06/23/2022
2,500,000.00 06/29/2021
0.20%
2,499,999.81
2,499,999.86
100.02
0.17%
2,500,587.50
1,388.89
1.07%
587.64
P-1 / A-1
F-1+
0.73
0.73
TOTAL Negotiable CD 2,500,000.00 0.20%
2,499,999.81
2,499,999.86 0.17%
2,500,587.50
1,388.89
1.07%
587.64
Aaa / AA
Aaa
0.73
0.73
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,999,268.84
100.58
0.21%
2,011,500.00
7,222.22
0.86%
12,231.16
Aaa / NR
AAA
0.32
0.32
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,490,384.73
101.48
0.20%
2,537,047.50
2,065.97
1.08%
46,662.77
Aaa / AAA
AAA
0.96
0.95
4581X0DZ8 Inter-American Dev Bank Note
0.500% Due 09/23/2024
3,680,000.00 09/15/2021
0.52%
3,677,276.80
3,677,296.68
99.70
0.60%
3,669,103.52
408.89
1.56%
(8,193.16)
Aaa / AAA
NR
2.98
2.95
459058JB0 Intl. Bank Recon & Development Note
0.625% Due 04/22/2025
2,260,000.00 04/15/2020
0.70%
2,251,253.80
2,253,778.03
99.63
0.73%
2,251,638.00
6,238.54
0.96%
(2,140.03)
Aaa / AAA
NR
3.56
3.50
4581X0DN5 Inter-American Dev Bank Note
0.625% Due 07/15/2025
1,685,000.00 01/13/2021
0.53%
1,692,329.75
1,691,173.60
99.38
0.79%
1,674,590.07
2,223.26
0.71%
(16,583.53)
Aaa / AAA
NR
3.79
3.73
459058JL8 Intl. Bank Recon & Development Note
0.500% Due 10/28/2025
6,000,000.00 Various
0.55%
5,986,632.00
5,988,516.95
98.63
0.84%
5,917,614.00
12,750.00
2.53%
(70,902.95)
Aaa / AAA
AAA
4.08
4.02
4581X0DV7 Inter-American Dev Bank Note
0.875% Due 04/20/2026
4,615,000.00 04/13/2021
0.97%
4,593,863.30
4,595,761.67
99.57
0.97%
4,595,012.44
18,059.39
1.97%
(749.23)
Aaa / AAA
AAA
4.56
4.44
TOTAL Supranational 22,740,000.00 0.96%
22,643,350.65
22,696,180.50 0.69%
22,656,505.53
48,968.27
9.68%
(39,674.97)
Aaa / AAA
Aaa
3.24
3.19
US Treasury
912828J76 US Treasury Note
1.750% Due 03/31/2022
3,000,000.00 04/25/2017
1.85%
2,985,830.37
2,998,575.16
100.84
0.06%
3,025,314.00
144.23
1.29%
26,738.84
Aaa / AA+
AAA
0.50
0.50
912828WZ9 US Treasury Note
1.750% Due 04/30/2022
1,750,000.00 05/23/2017
1.84%
1,742,964.84
1,749,176.24
100.98
0.06%
1,767,227.00
12,885.93
0.76%
18,050.76
Aaa / AA+
AAA
0.58
0.58
912828XR6 US Treasury Note
1.750% Due 05/31/2022
1,500,000.00 06/28/2017
1.81%
1,496,020.65
1,499,464.11
101.12
0.07%
1,516,758.00
8,821.72
0.65%
17,293.89
Aaa / AA+
AAA
0.67
0.66
912828XW5 US Treasury Note
1.750% Due 06/30/2022
3,000,000.00 07/25/2017
1.86%
2,984,072.55
2,997,593.19
101.24
0.09%
3,037,266.00
13,267.66
1.30%
39,672.81
Aaa / AA+
AAA
0.75
0.75
912828L24 US Treasury Note
1.875% Due 08/31/2022
2,000,000.00 09/27/2017
1.92%
1,995,944.20
1,999,246.59
101.63
0.09%
2,032,656.00
3,211.33
0.87%
33,409.41
Aaa / AA+
AAA
0.92
0.91
As of September 30, 2021
36
193
Holdings Report
City of Dublin -Account #10198
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
912828L57 US Treasury Note
1.750% Due 09/30/2022
3,750,000.00 Various
2.02%
3,702,841.80
3,740,401.59
101.65
0.10%
3,811,961.25
180.29
1.62%
71,559.66
Aaa / AA+
AAA
1.00
1.00
912828M49 US Treasury Note
1.875% Due 10/31/2022
1,000,000.00 01/30/2018
2.47%
973,359.38
993,931.35
101.91
0.12%
1,019,062.00
7,846.47
0.44%
25,130.65
Aaa / AA+
AAA
1.08
1.07
9128284D9 US Treasury Note
2.500% Due 03/31/2023
3,750,000.00 Various
2.75%
3,706,123.05
3,736,714.04
103.45
0.19%
3,879,491.25
257.55
1.65%
142,777.21
Aaa / AA+
AAA
1.50
1.48
912828R69 US Treasury Note
1.625% Due 05/31/2023
1,500,000.00 05/30/2018
2.67%
1,427,167.97
1,475,789.13
102.32
0.23%
1,534,863.00
8,191.60
0.66%
59,073.87
Aaa / AA+
AAA
1.67
1.64
912828U57 US Treasury Note
2.125% Due 11/30/2023
5,000,000.00 Various
2.53%
4,908,242.19
4,959,008.41
103.88
0.33%
5,194,140.00
35,706.97
2.23%
235,131.59
Aaa / AA+
AAA
2.17
2.11
912828V80 US Treasury Note
2.250% Due 01/31/2024
5,000,000.00 Various
2.32%
4,983,691.41
4,992,098.49
104.38
0.36%
5,219,140.00
18,953.80
2.23%
227,041.51
Aaa / AA+
AAA
2.34
2.28
912828WJ5 US Treasury Note
2.500% Due 05/15/2024
1,750,000.00 06/10/2019
1.91%
1,798,261.72
1,775,659.15
105.38
0.44%
1,844,062.50
16,525.14
0.79%
68,403.35
Aaa / AA+
AAA
2.62
2.53
9128282N9 US Treasury Note
2.125% Due 07/31/2024
2,000,000.00 08/30/2019
1.44%
2,064,531.25
2,037,131.50
104.61
0.48%
2,092,266.00
7,160.33
0.89%
55,134.50
Aaa / AA+
AAA
2.84
2.75
912828YH7 US Treasury Note
1.500% Due 09/30/2024
3,500,000.00 Various
1.65%
3,474,941.41
3,484,503.16
102.90
0.52%
3,601,580.50
144.23
1.54%
117,077.34
Aaa / AA+
AAA
3.00
2.94
9128283J7 US Treasury Note
2.125% Due 11/30/2024
3,000,000.00 Various
1.76%
3,051,650.40
3,032,965.14
104.87
0.57%
3,146,016.00
21,424.19
1.35%
113,050.86
Aaa / AA+
AAA
3.17
3.05
912828ZC7 US Treasury Note
1.125% Due 02/28/2025
3,500,000.00 03/24/2020
0.52%
3,603,222.66
3,571,413.35
101.64
0.64%
3,557,557.50
3,371.89
1.52%
(13,855.85)
Aaa / AA+
AAA
3.42
3.35
912828ZL7 US Treasury Note
0.375% Due 04/30/2025
4,000,000.00 Various
0.38%
3,998,593.75
3,998,967.43
98.86
0.70%
3,954,532.00
6,277.18
1.69%
(44,435.43)
Aaa / AA+
AAA
3.58
3.55
91282CAM3 US Treasury Note
0.250% Due 09/30/2025
2,500,000.00 10/16/2020
0.32%
2,491,406.25
2,493,056.52
97.82
0.80%
2,445,507.50
17.17
1.04%
(47,549.02)
Aaa / AA+
AAA
4.00
3.97
91282CBC4 US Treasury Note
0.375% Due 12/31/2025
1,000,000.00 12/29/2020
0.38%
999,921.88
999,933.60
97.95
0.87%
979,492.00
947.69
0.42%
(20,441.60)
Aaa / AA+
AAA
4.25
4.20
91282CBH3 US Treasury Note
0.375% Due 01/31/2026
4,000,000.00 02/23/2021
0.58%
3,960,625.00
3,965,410.31
97.82
0.89%
3,912,656.00
2,527.17
1.67%
(52,754.31)
Aaa / AA+
AAA
4.34
4.28
91282CBQ3 US Treasury Note
0.500% Due 02/28/2026
2,500,000.00 03/26/2021
0.83%
2,459,960.94
2,464,105.22
98.27
0.90%
2,456,835.00
1,070.44
1.05%
(7,270.22)
Aaa / AA+
AAA
4.42
4.35
91282CBT7 US Treasury Note
0.750% Due 03/31/2026
5,000,000.00 Various
0.85%
4,974,804.69
4,977,267.48
99.26
0.92%
4,962,890.00
103.02
2.12%
(14,377.48)
Aaa / AA+
AAA
4.50
4.41
91282CCF6 US Treasury Note
0.750% Due 05/31/2026
2,000,000.00 06/18/2021
0.91%
1,985,000.00
1,985,847.65
99.12
0.94%
1,982,422.00
5,040.98
0.85%
(3,425.65)
Aaa / AA+
AAA
4.67
4.56
As of September 30, 2021
37
194
Holdings Report
City of Dublin -Account #10198
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
91282CCW9 US Treasury Note
0.750% Due 08/31/2026
2,000,000.00 08/30/2021
0.77%
1,998,515.63
1,998,540.83
98.88
0.98%
1,977,656.00
1,284.53
0.84%
(20,884.83)
Aaa / AA+
AAA
4.92
4.81
TOTAL US Treasury 68,000,000.00 1.52%
67,767,693.99
67,926,799.64 0.48%
68,951,351.50
175,361.51
29.46%
1,024,551.86
Aaa / AA+
Aaa
2.69
2.64
TOTAL PORTFOLIO 229,427,062.91 1.52%
230,521,435.77
230,264,814.80 0.56%
233,860,181.06
746,076.77
100.00%
3,595,366.26
Aa1 / AA
Aaa
2.80
2.58
TOTAL MARKET VALUE PLUS ACCRUALS 234,606,257.83
As of September 30, 2021
38
195
Holdings Report
City of Dublin Reporting Account -Account #10219
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 50,364,764.44 Various
0.21%
50,364,764.44
50,364,764.44
1.00
0.21%
50,364,764.44
27,810.15
53.88%
0.00
NR / NR
NR
0.00
0.00
TOTAL LAIF 50,364,764.44 0.21%
50,364,764.44
50,364,764.44 0.21%
50,364,764.44
27,810.15
53.88%
0.00
NR / NR
NR
0.00
0.00
Local Gov Investment Pool
90CAMP$00 California Asset Mgmt Program CAMP 43,129,269.68 Various
0.05%
43,129,269.68
43,129,269.68
1.00
0.05%
43,129,269.68
0.00
46.12%
0.00
NR / AAA
NR
0.00
0.00
TOTAL Local Gov Investment Pool 43,129,269.68 0.05%
43,129,269.68
43,129,269.68 0.05%
43,129,269.68
0.00
46.12%
0.00
NR / AAA
NR
0.00
0.00
TOTAL PORTFOLIO 93,494,034.12 0.14%
93,494,034.12
93,494,034.12 0.14%
93,494,034.12
27,810.15
100.00%
0.00
NR / AAA
NR
0.00
0.00
TOTAL MARKET VALUE PLUS ACCRUALS 93,521,844.27
As of September 30, 2021
39
196
SECTION |Section 5 |Transactions
40
197
Transaction Ledger
City of Dublin -Account #10198
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 07/07/2021 3137BFE98 2,000,000.00 FHLMC K041 A2
3.171% Due: 10/25/2024
107.570 0.72%2,151,406.25 1,057.00 2,152,463.25 0.00
Purchase 07/12/2021 79466LAG9 465,000.00 Salesforce.com Inc Callable Note Cont 7/15/2022
0.625% Due: 07/15/2024
99.949 0.64%464,762.85 0.00 464,762.85 0.00
Purchase 07/21/2021 47789QAC4 965,000.00 John Deere Owner Trust 2021-B A3
0.52% Due: 03/16/2026
99.991 0.52%964,913.92 0.00 964,913.92 0.00
Purchase 07/28/2021 44934KAC8 2,065,000.00 Hyundai Auto Receivables Trust 2021-B A3
0.38% Due: 01/15/2026
99.978 0.39%2,064,544.25 0.00 2,064,544.25 0.00
Purchase 08/02/2021 89239CAC3 1,090,000.00 Toyota Lease Owner Trust 2021-B A3
0.42% Due: 10/21/2024
99.999 0.42%1,089,985.28 0.00 1,089,985.28 0.00
Purchase 08/12/2021 02665WDL2 1,000,000.00 American Honda Finance Note
1.2% Due: 07/08/2025
100.764 1.00%1,007,640.00 1,133.33 1,008,773.33 0.00
Purchase 08/31/2021 91282CCW9 2,000,000.00 US Treasury Note
0.75% Due: 08/31/2026
99.926 0.77%1,998,515.63 0.00 1,998,515.63 0.00
Purchase 09/14/2021 58989V2D5 1,285,000.00 Met Tower Global Funding Note
1.25% Due: 09/14/2026
99.908 1.27%1,283,817.80 0.00 1,283,817.80 0.00
Purchase 09/15/2021 06368FAC3 1,650,000.00 Bank of Montreal Note
1.25% Due: 09/15/2026
99.792 1.29%1,646,568.00 0.00 1,646,568.00 0.00
Purchase 09/15/2021 06368FAC3 850,000.00 Bank of Montreal Note
1.25% Due: 09/15/2026
99.879 1.28%848,971.50 0.00 848,971.50 0.00
Purchase 09/15/2021 09690AAC7 710,000.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due: 12/26/2024
99.990 0.34%709,926.73 0.00 709,926.73 0.00
Purchase 09/17/2021 931142ER0 585,000.00 Wal-Mart Stores Callable Note Cont 08/17/2026
1.05% Due: 09/17/2026
99.811 1.09%583,894.35 0.00 583,894.35 0.00
June 30, 2021 through September 30, 2021
As of September 30, 2021
41
198
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
Purchase 09/23/2021 4581X0DZ8 3,680,000.00 Inter-American Dev Bank Note
0.5% Due: 09/23/2024
99.926 0.52%3,677,276.80 0.00 3,677,276.80 0.00
Subtotal 18,345,000.00 18,492,223.36 2,190.33 18,494,413.69 0.00
TOTAL ACQUISITIONS 18,345,000.00 18,492,223.36 2,190.33 18,494,413.69 0.00
DISPOSITIONS
Sale 07/02/2021 912828U65 2,000,000.00 US Treasury Note
1.75% Due: 11/30/2021
100.703 2.06%2,014,062.50 3,060.11 2,017,122.61 16,451.51
Sale 09/10/2021 912828V72 1,500,000.00 US Treasury Note
1.875% Due: 01/31/2022
100.711 1.84%1,510,664.06 3,133.49 1,513,797.55 10,472.60
Sale 09/13/2021 3135G0Q89 2,000,000.00 FNMA Note
1.375% Due: 10/07/2021
100.088 1.45%2,001,760.00 11,916.67 2,013,676.67 1,853.00
Sale 09/16/2021 3135G0S38 2,500,000.00 FNMA Note
2% Due: 01/05/2022
100.591 2.04%2,514,775.00 9,861.11 2,524,636.11 15,054.04
Sale 09/16/2021 912828WZ9 1,000,000.00 US Treasury Note
1.75% Due: 04/30/2022
101.059 1.84%1,010,585.94 6,610.05 1,017,195.99 11,090.12
Subtotal 9,000,000.00 9,051,847.50 34,581.43 9,086,428.93 54,921.27
Call 07/08/2021 594918BP8 1,850,000.00 Microsoft Callable Note Cont 7/8/2021
1.55% Due: 08/08/2021
100.000 1.60%1,850,000.00 11,947.92 1,861,947.92 0.00
Subtotal 1,850,000.00 1,850,000.00 11,947.92 1,861,947.92 0.00
Maturity 07/14/2021 3130A8QS5 2,500,000.00 FHLB Note
1.125% Due: 07/14/2021
100.000 2,500,000.00 0.00 2,500,000.00 0.00
June 30, 2021 through September 30, 2021
As of September 30, 2021
42
199
Transaction Ledger
City of Dublin -Account #10198
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
Maturity 08/12/2021 3137EAEC9 3,000,000.00 FHLMC Note
1.125% Due: 08/12/2021
100.000 3,000,000.00 0.00 3,000,000.00 0.00
Subtotal 5,500,000.00 5,500,000.00 0.00 5,500,000.00 0.00
TOTAL DISPOSITIONS 16,350,000.00 16,401,847.50 46,529.35 16,448,376.85 54,921.27
June 30, 2021 through September 30, 2021
As of September 30, 2021
43
200
Transaction Ledger
City of Dublin Reporting Account -Account #10219
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 07/15/2021 90LAIF$00 41,087.83 Local Agency Investment Fund State Pool 1.000 0.25%41,087.83 0.00 41,087.83 0.00
Purchase 07/31/2021 90CAMP$00 2,105.17 California Asset Mgmt Program CAMP 1.000 0.05%2,105.17 0.00 2,105.17 0.00
Purchase 08/31/2021 90CAMP$00 1,917.15 California Asset Mgmt Program CAMP 1.000 0.05%1,917.15 0.00 1,917.15 0.00
Purchase 09/30/2021 90CAMP$00 1,757.25 California Asset Mgmt Program CAMP 1.000 0.05%1,757.25 0.00 1,757.25 0.00
Subtotal 46,867.40 46,867.40 0.00 46,867.40 0.00
Security
Contribution
07/12/2021 90CAMP$00 4,000,000.00 California Asset Mgmt Program CAMP 1.000 4,000,000.00 0.00 4,000,000.00 0.00
Security
Contribution
09/02/2021 90CAMP$00 2,500,000.00 California Asset Mgmt Program CAMP 1.000 2,500,000.00 0.00 2,500,000.00 0.00
Security
Contribution
09/27/2021 90CAMP$00 1,100,000.00 California Asset Mgmt Program CAMP 1.000 1,100,000.00 0.00 1,100,000.00 0.00
Subtotal 7,600,000.00 7,600,000.00 0.00 7,600,000.00 0.00
TOTAL ACQUISITIONS 7,646,867.40 7,646,867.40 0.00 7,646,867.40 0.00
DISPOSITIONS
Security
Withdrawal
07/19/2021 90CAMP$00 750,000.00 California Asset Mgmt Program CAMP 1.000 750,000.00 0.00 750,000.00 0.00
Security
Withdrawal
07/26/2021 90CAMP$00 3,100,000.00 California Asset Mgmt Program CAMP 1.000 3,100,000.00 0.00 3,100,000.00 0.00
Security
Withdrawal
08/02/2021 90CAMP$00 250,000.00 California Asset Mgmt Program CAMP 1.000 250,000.00 0.00 250,000.00 0.00
Security
Withdrawal
08/06/2021 90CAMP$00 1,200,000.00 California Asset Mgmt Program CAMP 1.000 1,200,000.00 0.00 1,200,000.00 0.00
June 30, 2021 through September 30, 2021
As of September 30, 2021
44
201
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
08/13/2021 90CAMP$00 2,000,000.00 California Asset Mgmt Program CAMP 1.000 2,000,000.00 0.00 2,000,000.00 0.00
Security
Withdrawal
08/20/2021 90CAMP$00 4,000,000.00 California Asset Mgmt Program CAMP 1.000 4,000,000.00 0.00 4,000,000.00 0.00
Security
Withdrawal
09/07/2021 90CAMP$00 500,000.00 California Asset Mgmt Program CAMP 1.000 500,000.00 0.00 500,000.00 0.00
Subtotal 11,800,000.00 11,800,000.00 0.00 11,800,000.00 0.00
TOTAL DISPOSITIONS 11,800,000.00 11,800,000.00 0.00 11,800,000.00 0.00
June 30, 2021 through September 30, 2021
As of September 30, 2021
45
202
Transaction Ledger
City of Dublin Consolidated -Account #10221
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 07/07/2021 3137BFE98 2,000,000.00 FHLMC K041 A2
3.171% Due: 10/25/2024
107.570 0.72%2,151,406.25 1,057.00 2,152,463.25 0.00
Purchase 07/12/2021 79466LAG9 465,000.00 Salesforce.com Inc Callable Note Cont 7/15/2022
0.625% Due: 07/15/2024
99.949 0.64%464,762.85 0.00 464,762.85 0.00
Purchase 07/15/2021 90LAIF$00 41,087.83 Local Agency Investment Fund State Pool 1.000 0.25%41,087.83 0.00 41,087.83 0.00
Purchase 07/21/2021 47789QAC4 965,000.00 John Deere Owner Trust 2021-B A3
0.52% Due: 03/16/2026
99.991 0.52%964,913.92 0.00 964,913.92 0.00
Purchase 07/28/2021 44934KAC8 2,065,000.00 Hyundai Auto Receivables Trust 2021-B A3
0.38% Due: 01/15/2026
99.978 0.39%2,064,544.25 0.00 2,064,544.25 0.00
Purchase 07/31/2021 90CAMP$00 2,105.17 California Asset Mgmt Program CAMP 1.000 0.05%2,105.17 0.00 2,105.17 0.00
Purchase 08/02/2021 89239CAC3 1,090,000.00 Toyota Lease Owner Trust 2021-B A3
0.42% Due: 10/21/2024
99.999 0.42%1,089,985.28 0.00 1,089,985.28 0.00
Purchase 08/12/2021 02665WDL2 1,000,000.00 American Honda Finance Note
1.2% Due: 07/08/2025
100.764 1.00%1,007,640.00 1,133.33 1,008,773.33 0.00
Purchase 08/31/2021 90CAMP$00 1,917.15 California Asset Mgmt Program CAMP 1.000 0.05%1,917.15 0.00 1,917.15 0.00
Purchase 08/31/2021 91282CCW9 2,000,000.00 US Treasury Note
0.75% Due: 08/31/2026
99.926 0.77%1,998,515.63 0.00 1,998,515.63 0.00
Purchase 09/14/2021 58989V2D5 1,285,000.00 Met Tower Global Funding Note
1.25% Due: 09/14/2026
99.908 1.27%1,283,817.80 0.00 1,283,817.80 0.00
Purchase 09/15/2021 06368FAC3 1,650,000.00 Bank of Montreal Note
1.25% Due: 09/15/2026
99.792 1.29%1,646,568.00 0.00 1,646,568.00 0.00
Purchase 09/15/2021 06368FAC3 850,000.00 Bank of Montreal Note
1.25% Due: 09/15/2026
99.879 1.28%848,971.50 0.00 848,971.50 0.00
Purchase 09/15/2021 09690AAC7 710,000.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due: 12/26/2024
99.990 0.34%709,926.73 0.00 709,926.73 0.00
Purchase 09/17/2021 931142ER0 585,000.00 Wal-Mart Stores Callable Note Cont 08/17/2026
1.05% Due: 09/17/2026
99.811 1.09%583,894.35 0.00 583,894.35 0.00
Purchase 09/23/2021 4581X0DZ8 3,680,000.00 Inter-American Dev Bank Note
0.5% Due: 09/23/2024
99.926 0.52%3,677,276.80 0.00 3,677,276.80 0.00
June 30, 2021 through September 30, 2021
As of September 30, 2021
46
203
Transaction Ledger
City of Dublin Consolidated -Account #10221
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
Purchase 09/30/2021 90CAMP$00 1,757.25 California Asset Mgmt Program CAMP 1.000 0.05%1,757.25 0.00 1,757.25 0.00
Subtotal 18,391,867.40 18,539,090.76 2,190.33 18,541,281.09 0.00
Security
Contribution
07/12/2021 90CAMP$00 4,000,000.00 California Asset Mgmt Program CAMP 1.000 4,000,000.00 0.00 4,000,000.00 0.00
Security
Contribution
09/02/2021 90CAMP$00 2,500,000.00 California Asset Mgmt Program CAMP 1.000 2,500,000.00 0.00 2,500,000.00 0.00
Security
Contribution
09/27/2021 90CAMP$00 1,100,000.00 California Asset Mgmt Program CAMP 1.000 1,100,000.00 0.00 1,100,000.00 0.00
Subtotal 7,600,000.00 7,600,000.00 0.00 7,600,000.00 0.00
TOTAL ACQUISITIONS 25,991,867.40 26,139,090.76 2,190.33 26,141,281.09 0.00
DISPOSITIONS
Sale 07/02/2021 912828U65 2,000,000.00 US Treasury Note
1.75% Due: 11/30/2021
100.703 2.06%2,014,062.50 3,060.11 2,017,122.61 16,451.51
Sale 09/10/2021 912828V72 1,500,000.00 US Treasury Note
1.875% Due: 01/31/2022
100.711 1.84%1,510,664.06 3,133.49 1,513,797.55 10,472.60
Sale 09/13/2021 3135G0Q89 2,000,000.00 FNMA Note
1.375% Due: 10/07/2021
100.088 1.45%2,001,760.00 11,916.67 2,013,676.67 1,853.00
Sale 09/16/2021 3135G0S38 2,500,000.00 FNMA Note
2% Due: 01/05/2022
100.591 2.04%2,514,775.00 9,861.11 2,524,636.11 15,054.04
Sale 09/16/2021 912828WZ9 1,000,000.00 US Treasury Note
1.75% Due: 04/30/2022
101.059 1.84%1,010,585.94 6,610.05 1,017,195.99 11,090.12
Subtotal 9,000,000.00 9,051,847.50 34,581.43 9,086,428.93 54,921.27
June 30, 2021 through September 30, 2021
As of September 30, 2021
47
204
Transaction Ledger
City of Dublin Consolidated -Account #10221
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
Call 07/08/2021 594918BP8 1,850,000.00 Microsoft Callable Note Cont 7/8/2021
1.55% Due: 08/08/2021
100.000 1.60%1,850,000.00 11,947.92 1,861,947.92 0.00
Subtotal 1,850,000.00 1,850,000.00 11,947.92 1,861,947.92 0.00
Maturity 07/14/2021 3130A8QS5 2,500,000.00 FHLB Note
1.125% Due: 07/14/2021
100.000 2,500,000.00 0.00 2,500,000.00 0.00
Maturity 08/12/2021 3137EAEC9 3,000,000.00 FHLMC Note
1.125% Due: 08/12/2021
100.000 3,000,000.00 0.00 3,000,000.00 0.00
Subtotal 5,500,000.00 5,500,000.00 0.00 5,500,000.00 0.00
Security
Withdrawal
07/19/2021 90CAMP$00 750,000.00 California Asset Mgmt Program CAMP 1.000 750,000.00 0.00 750,000.00 0.00
Security
Withdrawal
07/26/2021 90CAMP$00 3,100,000.00 California Asset Mgmt Program CAMP 1.000 3,100,000.00 0.00 3,100,000.00 0.00
Security
Withdrawal
08/02/2021 90CAMP$00 250,000.00 California Asset Mgmt Program CAMP 1.000 250,000.00 0.00 250,000.00 0.00
Security
Withdrawal
08/06/2021 90CAMP$00 1,200,000.00 California Asset Mgmt Program CAMP 1.000 1,200,000.00 0.00 1,200,000.00 0.00
Security
Withdrawal
08/13/2021 90CAMP$00 2,000,000.00 California Asset Mgmt Program CAMP 1.000 2,000,000.00 0.00 2,000,000.00 0.00
Security
Withdrawal
08/20/2021 90CAMP$00 4,000,000.00 California Asset Mgmt Program CAMP 1.000 4,000,000.00 0.00 4,000,000.00 0.00
Security
Withdrawal
09/07/2021 90CAMP$00 500,000.00 California Asset Mgmt Program CAMP 1.000 500,000.00 0.00 500,000.00 0.00
Subtotal 11,800,000.00 11,800,000.00 0.00 11,800,000.00 0.00
TOTAL DISPOSITIONS 28,150,000.00 28,201,847.50 46,529.35 28,248,376.85 54,921.27
June 30, 2021 through September 30, 2021
As of September 30, 2021
48
205
Important Disclosures
2021 Chandler Asset Management,Inc, An Independent Registered Investment Adviser.
Information contained herein is confidential.Prices are provided by IDC,an independent pricing source.In the event IDC does not provide a price or if the price provided is not reflective of fair market
value,Chandler will obtain pricing from an alternative approved third party pricing source in accordance with our written valuation policy and procedures.Our valuation procedures are also disclosed in
Item 5 of our Form ADV Part 2A.
Performance results are presented gross-of-advisory fees and represent the client’s Total Return.The deduction of advisory fees lowers performance results.These results include the reinvestment of
dividends and other earnings.Past performance may not be indicative of future results.Therefore,clients should not assume that future performance of any specific investment or investment strategy
will be profitable or equal to past performance levels.All investment strategies have the potential for profit or loss.Economic factors,market conditions or changes in investment strategies,
contributions or withdrawals may materially alter the performance and results of your portfolio.
Index returns assume reinvestment of all distributions.Historical performance results for investment indexes generally do not reflect the deduction of transaction and/or custodial charges or the
deduction of an investment management fee,the incurrence of which would have the effect of decreasing historical performance results.It is not possible to invest directly in an index.
Source ice Data Indices,LLC ("ICE"),used with permission. ICE permits use of the ICE indices and related data on an "as is"basis; ICE,its affiliates and their respective third party suppliers disclaim any and
all warranties and representations, express and/or implied,including any warranties of merchantability or fitness for a particular purpose or use,including the indices,index data and any data included
in,related to,or derived therefrom.Neither ICE data,its affiliates or their respective third party providers guarantee the quality,adequacy,accuracy,timeliness or completeness of the indices or the
index data or any component thereof,and the indices and index data and all components thereof are provided on an "as is"basis and licensee's use it at licensee's own risk. ICE data,its affiliates and their
respective third party do not sponsor,endorse,or recommend chandler asset management,or any of its products or services.
This report is provided for informational purposes only and should not be construed as a specific investment or legal advice.The information contained herein was obtained from sources believed to be
reliable as of the date of publication,but may become outdated or superseded at any time without notice.Any opinions or views expressed are based on current market conditions and are subject to
change.This report may contain forecasts and forward-looking statements which are inherently limited and should not be relied upon as indicator of future results.Past performance is not indicative of
future results.This report is not intended to constitute an offer,solicitation,recommendation or advice regarding any securities or investment strategy and should not be regarded by recipients as a
substitute for the exercise of their own judgment.
Fixed income investments are subject to interest, credit and market risk.Interest rate risk:the value of fixed income investments will decline as interest rates rise.Credit risk:the possibility that the
borrower may not be able to repay interest and principal.Low rated bonds generally have to pay higher interest rates to attract investors willing to take on greater risk.Market risk:the bond market in
general could decline due to economic conditions,especially during periods of rising interest rates.
Ratings information have been provided by Moody’s,S&P and Fitch through data feeds we believe to be reliable as of the date of this statement, however we cannot guarantee its accuracy.
Security level ratings for U.S.Agency issued mortgage-backed securities (“MBS”)reflect the issuer rating because the securities themselves are not rated.The issuing U.S.Agency guarantees the full and
timely payment of both principal and interest and carries a AA+/Aaa/AAA by S&P,Moody’s and Fitch respectively.
As of September 30, 2021
49
206
Benchmark Disclosures
ICE BofA 1-5 Yr US Treasury & Agency Index*
The ICE BofA 1-5 Year US Treasury &Agency Index tracks the performance of US dollar denominated US Treasury and nonsubordinated US agency debt issued in the US domestic market.Qualifying
securities must have an investment grade rating (based on an average of Moody’s,S&P and Fitch).Qualifying securities must have at least one year remaining term to final maturity and less than five
years remaining term to final maturity,at least 18 months to maturity at time of issuance,a fixed coupon schedule,and a minimum amount outstanding of $1 billion for sovereigns and $250 million for
agencies.
The ICE BofA 1-3 Year US Treasury &Agency Index tracks the performance of US dollar denominated US Treasury and nonsubordinated US agency debt issued in the US domestic market.Qualifying
securities must have an investment grade rating (based on an average of Moody’s,S&P and Fitch).Qualifying securities must have at least one year remaining term to final maturity and less than three
years remaining term to final maturity,at least 18 months to maturity at time of issuance,a fixed coupon schedule,and a minimum amount outstanding of $1 billion for sovereigns and $250 million for
agencies.
As of September 30, 2021
50
207
Transaction Ledger
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 09/01/2021 31846V203 13.75 First American Govt Obligation Fund
Class Y
1.000 0.01%13.75 0.00 13.75 0.00
Purchase 09/05/2021 31846V203 42,600.00 First American Govt Obligation Fund
Class Y
1.000 0.01%42,600.00 0.00 42,600.00 0.00
Purchase 09/08/2021 31846V203 84,375.00 First American Govt Obligation Fund
Class Y
1.000 0.01%84,375.00 0.00 84,375.00 0.00
Purchase 09/10/2021 31846V203 1,513,797.55 First American Govt Obligation Fund
Class Y
1.000 0.01%1,513,797.55 0.00 1,513,797.55 0.00
Purchase 09/11/2021 31846V203 63,625.00 First American Govt Obligation Fund
Class Y
1.000 0.01%63,625.00 0.00 63,625.00 0.00
Purchase 09/13/2021 31846V203 2,013,676.67 First American Govt Obligation Fund
Class Y
1.000 0.01%2,013,676.67 0.00 2,013,676.67 0.00
Purchase 09/13/2021 31846V203 38,775.00 First American Govt Obligation Fund
Class Y
1.000 0.01%38,775.00 0.00 38,775.00 0.00
Purchase 09/14/2021 31846V203 21,875.00 First American Govt Obligation Fund
Class Y
1.000 0.01%21,875.00 0.00 21,875.00 0.00
Purchase 09/14/2021 58989V2D5 1,285,000.00 Met Tower Global Funding Note
1.25% Due 9/14/2026
99.908 1.27%1,283,817.80 0.00 1,283,817.80 0.00
Purchase 09/15/2021 06368FAC3 1,650,000.00 Bank of Montreal Note
1.25% Due 9/15/2026
99.792 1.29%1,646,568.00 0.00 1,646,568.00 0.00
Purchase 09/15/2021 06368FAC3 850,000.00 Bank of Montreal Note
1.25% Due 9/15/2026
99.879 1.28%848,971.50 0.00 848,971.50 0.00
Purchase 09/15/2021 09690AAC7 710,000.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due 12/26/2024
99.990 0.34%709,926.73 0.00 709,926.73 0.00
Purchase 09/15/2021 31846V203 65,018.75 First American Govt Obligation Fund
Class Y
1.000 0.01%65,018.75 0.00 65,018.75 0.00
Purchase 09/15/2021 31846V203 390.50 First American Govt Obligation Fund
Class Y
1.000 0.01%390.50 0.00 390.50 0.00
Purchase 09/15/2021 31846V203 375.83 First American Govt Obligation Fund
Class Y
1.000 0.01%375.83 0.00 375.83 0.00
Purchase 09/15/2021 31846V203 229.58 First American Govt Obligation Fund
Class Y
1.000 0.01%229.58 0.00 229.58 0.00
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 11
Attachment 2
208
Transaction Ledger
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 09/15/2021 31846V203 653.92 First American Govt Obligation Fund
Class Y
1.000 0.01%653.92 0.00 653.92 0.00
Purchase 09/15/2021 31846V203 218.88 First American Govt Obligation Fund
Class Y
1.000 0.01%218.88 0.00 218.88 0.00
Purchase 09/15/2021 31846V203 240.00 First American Govt Obligation Fund
Class Y
1.000 0.01%240.00 0.00 240.00 0.00
Purchase 09/15/2021 31846V203 752.70 First American Govt Obligation Fund
Class Y
1.000 0.01%752.70 0.00 752.70 0.00
Purchase 09/15/2021 31846V203 378.33 First American Govt Obligation Fund
Class Y
1.000 0.01%378.33 0.00 378.33 0.00
Purchase 09/15/2021 31846V203 52,348.90 First American Govt Obligation Fund
Class Y
1.000 0.01%52,348.90 0.00 52,348.90 0.00
Purchase 09/15/2021 31846V203 111,378.17 First American Govt Obligation Fund
Class Y
1.000 0.01%111,378.17 0.00 111,378.17 0.00
Purchase 09/15/2021 31846V203 76,660.72 First American Govt Obligation Fund
Class Y
1.000 0.01%76,660.72 0.00 76,660.72 0.00
Purchase 09/15/2021 31846V203 38,198.96 First American Govt Obligation Fund
Class Y
1.000 0.01%38,198.96 0.00 38,198.96 0.00
Purchase 09/16/2021 31846V203 3,541,832.10 First American Govt Obligation Fund
Class Y
1.000 0.01%3,541,832.10 0.00 3,541,832.10 0.00
Purchase 09/17/2021 931142ER0 585,000.00 Wal-Mart Stores Callable Note Cont
08/17/2026
1.05% Due 9/17/2026
99.811 1.09%583,894.35 0.00 583,894.35 0.00
Purchase 09/20/2021 31846V203 610.40 First American Govt Obligation Fund
Class Y
1.000 0.01%610.40 0.00 610.40 0.00
Purchase 09/20/2021 31846V203 345.33 First American Govt Obligation Fund
Class Y
1.000 0.01%345.33 0.00 345.33 0.00
Purchase 09/21/2021 31846V203 50,190.11 First American Govt Obligation Fund
Class Y
1.000 0.01%50,190.11 0.00 50,190.11 0.00
Purchase 09/23/2021 31846V203 4,978.13 First American Govt Obligation Fund
Class Y
1.000 0.01%4,978.13 0.00 4,978.13 0.00
Purchase 09/23/2021 4581X0DZ8 3,680,000.00 Inter-American Dev Bank Note
0.5% Due 9/23/2024
99.926 0.52%3,677,276.80 0.00 3,677,276.80 0.00
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 12 209
Transaction Ledger
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 09/27/2021 31846V203 5,285.00 First American Govt Obligation Fund
Class Y
1.000 0.01%5,285.00 0.00 5,285.00 0.00
Purchase 09/30/2021 31846V203 154,062.50 First American Govt Obligation Fund
Class Y
1.000 0.01%154,062.50 0.00 154,062.50 0.00
Purchase 09/30/2021 90CAMP$00 1,757.25 California Asset Mgmt Program CAMP 1.000 0.05%1,757.25 0.00 1,757.25 0.00
Subtotal 16,644,644.03 16,635,099.21 0.00 16,635,099.21 0.00
Security
Contribution
09/02/2021 90CAMP$00 2,500,000.00 California Asset Mgmt Program CAMP 1.000 2,500,000.00 0.00 2,500,000.00 0.00
Security
Contribution
09/27/2021 90CAMP$00 1,100,000.00 California Asset Mgmt Program CAMP 1.000 1,100,000.00 0.00 1,100,000.00 0.00
Subtotal 3,600,000.00 3,600,000.00 0.00 3,600,000.00 0.00
Short Sale 09/15/2021 31846V203 -709,926.73 First American Govt Obligation Fund
Class Y
1.000 -709,926.73 0.00 -709,926.73 0.00
Short Sale 09/17/2021 31846V203 -583,894.35 First American Govt Obligation Fund
Class Y
1.000 -583,894.35 0.00 -583,894.35 0.00
Subtotal -1,293,821.08 -1,293,821.08 0.00 -1,293,821.08 0.00
TOTAL ACQUISITIONS 18,950,822.95 18,941,278.13 0.00 18,941,278.13 0.00
DISPOSITIONS
Closing
Purchase
09/15/2021 31846V203 -709,926.73 First American Govt Obligation Fund
Class Y
1.000 -709,926.73 0.00 -709,926.73 0.00
Closing
Purchase
09/17/2021 31846V203 -583,894.35 First American Govt Obligation Fund
Class Y
1.000 -583,894.35 0.00 -583,894.35 0.00
Subtotal -1,293,821.08 -1,293,821.08 0.00 -1,293,821.08 0.00
Sale 09/10/2021 912828V72 1,500,000.00 US Treasury Note
1.875% Due 1/31/2022
100.711 1.84%1,510,664.06 3,133.49 1,513,797.55 10,472.60
Sale 09/13/2021 3135G0Q89 2,000,000.00 FNMA Note
1.375% Due 10/7/2021
100.088 1.45%2,001,760.00 11,916.67 2,013,676.67 1,853.00
Sale 09/14/2021 31846V203 1,283,817.80 First American Govt Obligation Fund
Class Y
1.000 0.01%1,283,817.80 0.00 1,283,817.80 0.00
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 13 210
Transaction Ledger
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
DISPOSITIONS
Sale 09/15/2021 31846V203 1,646,568.00 First American Govt Obligation Fund
Class Y
1.000 0.01%1,646,568.00 0.00 1,646,568.00 0.00
Sale 09/15/2021 31846V203 848,971.50 First American Govt Obligation Fund
Class Y
1.000 0.01%848,971.50 0.00 848,971.50 0.00
Sale 09/15/2021 31846V203 709,926.73 First American Govt Obligation Fund
Class Y
1.000 0.01%709,926.73 0.00 709,926.73 0.00
Sale 09/16/2021 3135G0S38 2,500,000.00 FNMA Note
2% Due 1/5/2022
100.591 2.04%2,514,775.00 9,861.11 2,524,636.11 15,054.04
Sale 09/16/2021 912828WZ9 1,000,000.00 US Treasury Note
1.75% Due 4/30/2022
101.059 1.84%1,010,585.94 6,610.05 1,017,195.99 11,090.12
Sale 09/17/2021 31846V203 583,894.35 First American Govt Obligation Fund
Class Y
1.000 0.01%583,894.35 0.00 583,894.35 0.00
Sale 09/23/2021 31846V203 3,677,276.80 First American Govt Obligation Fund
Class Y
1.000 0.01%3,677,276.80 0.00 3,677,276.80 0.00
Subtotal 15,750,455.18 15,788,240.18 31,521.32 15,819,761.50 38,469.76
Paydown 09/15/2021 44891VAC5 0.00 Hyundai Auto Lease Trust 2021-B A3
0.33% Due 6/17/2024
100.000 0.00 390.50 390.50 0.00
Paydown 09/15/2021 44933LAC7 0.00 Hyundai Auto Receivables Trust 2021-A
A3
0.38% Due 9/15/2025
100.000 0.00 229.58 229.58 0.00
Paydown 09/15/2021 44934KAC8 0.00 Hyundai Auto Receivables Trust 2021-B
A3
0.38% Due 1/15/2026
100.000 0.00 653.92 653.92 0.00
Paydown 09/15/2021 47787NAC3 0.00 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
100.000 0.00 218.88 218.88 0.00
Paydown 09/15/2021 47788EAC2 37,942.46 John Deere Owner Trust 2018-B A3
3.08% Due 11/15/2022
100.000 37,942.46 256.50 38,198.96 0.00
Paydown 09/15/2021 47788UAC6 0.00 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
100.000 0.00 240.00 240.00 0.00
Paydown 09/15/2021 47789QAC4 0.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
100.000 0.00 752.70 752.70 0.00
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 14 211
Transaction Ledger
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
DISPOSITIONS
Paydown 09/15/2021 58769KAD6 0.00 Mercedes-Benz Auto Lease Trust 2021-
B A3
0.4% Due 11/15/2024
100.000 0.00 378.33 378.33 0.00
Paydown 09/15/2021 65479GAD1 51,624.09 Nissan Auto Receivables Trust 2018-B
A3
3.06% Due 3/15/2023
100.000 51,624.09 724.81 52,348.90 0.00
Paydown 09/15/2021 65479JAD5 109,092.70 Nissan Auto Receivables Owner 2019-C
A3
1.93% Due 7/15/2024
100.000 109,092.70 2,285.47 111,378.17 0.00
Paydown 09/15/2021 89231PAD0 75,380.76 Toyota Auto Receivables Trust 2018-D
A3
3.18% Due 3/15/2023
100.000 75,380.76 1,279.96 76,660.72 0.00
Paydown 09/15/2021 89237VAB5 0.00 Toyota Auto Receivables Trust 2020-C
A3
0.44% Due 10/15/2024
100.000 0.00 375.83 375.83 0.00
Paydown 09/20/2021 43813KAC6 0.00 Honda Auto Receivables Trust 2020-3
A3
0.37% Due 10/18/2024
100.000 0.00 345.33 345.33 0.00
Paydown 09/20/2021 89239CAC3 0.00 Toyota Lease Owner Trust 2021-B A3
0.42% Due 10/21/2024
100.000 0.00 610.40 610.40 0.00
Paydown 09/21/2021 43815HAC1 49,900.18 Honda Auto Receivables Trust 2018-3
A3
2.95% Due 8/22/2022
100.000 49,900.18 289.93 50,190.11 0.00
Paydown 09/27/2021 3137BFE98 0.00 FHLMC K041 A2
3.171% Due 10/25/2024
100.000 0.00 5,285.00 5,285.00 0.00
Subtotal 323,940.19 323,940.19 14,317.14 338,257.33 0.00
Security
Withdrawal
09/07/2021 90CAMP$00 500,000.00 California Asset Mgmt Program CAMP 1.000 500,000.00 0.00 500,000.00 0.00
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 15 212
Transaction Ledger
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
DISPOSITIONS
Security
Withdrawal
09/24/2021 31846V203 104.17 First American Govt Obligation Fund
Class Y
1.000 104.17 0.00 104.17 0.00
Subtotal 500,104.17 500,104.17 0.00 500,104.17 0.00
TOTAL DISPOSITIONS 15,280,678.46 15,318,463.46 45,838.46 15,364,301.92 38,469.76
OTHER TRANSACTIONS
Interest 09/05/2021 06051GHF9 2,400,000.00 Bank of America Corp Callable Note 1X
3/5/2023
3.55% Due 3/5/2024
0.000 42,600.00 0.00 42,600.00 0.00
Interest 09/08/2021 313383YJ4 5,000,000.00 FHLB Note
3.375% Due 9/8/2023
0.000 84,375.00 0.00 84,375.00 0.00
Interest 09/11/2021 313378CR0 2,000,000.00 FHLB Note
2.25% Due 3/11/2022
0.000 22,500.00 0.00 22,500.00 0.00
Interest 09/11/2021 89114QCB2 2,300,000.00 Toronto Dominion Bank Note
3.25% Due 3/11/2024
0.000 37,375.00 0.00 37,375.00 0.00
Interest 09/11/2021 89114QCK2 1,000,000.00 Toronto Dominion Bank Note
0.75% Due 9/11/2025
0.000 3,750.00 0.00 3,750.00 0.00
Interest 09/13/2021 3130A2UW4 2,000,000.00 FHLB Note
2.875% Due 9/13/2024
0.000 28,750.00 0.00 28,750.00 0.00
Interest 09/13/2021 46647PBH8 1,000,000.00 JP Morgan Chase & Co Callable Note
Mthly 3/13/2025
2.005% Due 3/13/2026
0.000 10,025.00 0.00 10,025.00 0.00
Interest 09/14/2021 4581X0CZ9 2,500,000.00 Inter-American Dev Bank Note
1.75% Due 9/14/2022
0.000 21,875.00 0.00 21,875.00 0.00
Interest 09/15/2021 00440EAS6 2,500,000.00 Chubb INA Holdings Inc Note
3.15% Due 3/15/2025
0.000 39,375.00 0.00 39,375.00 0.00
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 16 213
Transaction Ledger
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
OTHER TRANSACTIONS
Interest 09/15/2021 084670BR8 1,865,000.00 Berkshire Hathaway Callable Note Cont
1/15/2023
2.75% Due 3/15/2023
0.000 25,643.75 0.00 25,643.75 0.00
Interest 09/23/2021 3137EAEX3 2,655,000.00 FHLMC Note
0.375% Due 9/23/2025
0.000 4,978.13 0.00 4,978.13 0.00
Interest 09/30/2021 9128284D9 3,750,000.00 US Treasury Note
2.5% Due 3/31/2023
0.000 46,875.00 0.00 46,875.00 0.00
Interest 09/30/2021 912828J76 3,000,000.00 US Treasury Note
1.75% Due 3/31/2022
0.000 26,250.00 0.00 26,250.00 0.00
Interest 09/30/2021 912828L57 3,750,000.00 US Treasury Note
1.75% Due 9/30/2022
0.000 32,812.50 0.00 32,812.50 0.00
Interest 09/30/2021 912828YH7 3,500,000.00 US Treasury Note
1.5% Due 9/30/2024
0.000 26,250.00 0.00 26,250.00 0.00
Interest 09/30/2021 91282CAM3 2,500,000.00 US Treasury Note
0.25% Due 9/30/2025
0.000 3,125.00 0.00 3,125.00 0.00
Interest 09/30/2021 91282CBT7 5,000,000.00 US Treasury Note
0.75% Due 3/31/2026
0.000 18,750.00 0.00 18,750.00 0.00
Subtotal 46,720,000.00 475,309.38 0.00 475,309.38 0.00
Dividend 09/01/2021 31846V203 1,677,545.89 First American Govt Obligation Fund
Class Y
0.000 13.75 0.00 13.75 0.00
Dividend 09/30/2021 90CAMP$00 43,127,512.43 California Asset Mgmt Program CAMP 0.000 1,757.25 0.00 1,757.25 0.00
Subtotal 44,805,058.32 1,771.00 0.00 1,771.00 0.00
TOTAL OTHER TRANSACTIONS 91,525,058.32 477,080.38 0.00 477,080.38 0.00
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 17 214
Income Earned
As of September 30, 2021
City of Dublin Consolidated
Account #10221
CUSIP Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
FIXED INCOME
00440EAS6 Chubb INA Holdings Inc
Note
3.15% Due 03/15/2025
Various
Various
2,500,000.00
2,707,443.40
0.00
0.00
2,702,622.88
36,312.50
39,375.00
3,500.00
6,562.50
0.00
4,820.52
(4,820.52)
1,741.98
1,741.98
023135BW5 Amazon.com Inc
Note
0.45% Due 05/12/2024
05/10/2021
05/12/2021
1,865,000.00
1,862,555.35
0.00
0.00
1,862,629.88
2,541.06
0.00
3,240.44
699.38
74.53
0.00
74.53
773.91
773.91
02665WCJ8 American Honda Finance
Note
3.45% Due 07/14/2023
Various
Various
1,000,000.00
998,497.31
0.00
0.00
998,563.50
4,504.17
0.00
7,379.17
2,875.00
66.19
0.00
66.19
2,941.19
2,941.19
02665WCZ2 American Honda Finance
Note
2.4% Due 06/27/2024
07/10/2019
07/12/2019
1,500,000.00
1,496,442.75
0.00
0.00
1,496,546.36
6,400.00
0.00
9,400.00
3,000.00
103.61
0.00
103.61
3,103.61
3,103.61
02665WDL2 American Honda Finance
Note
1.2% Due 07/08/2025
08/10/2021
08/12/2021
1,000,000.00
1,007,532.85
0.00
0.00
1,007,372.12
1,766.67
0.00
2,766.67
1,000.00
0.00
160.73
(160.73)
839.27
839.27
037833CU2 Apple Inc
Callable Note Cont 3/11/2024
2.85% Due 05/11/2024
Various
Various
3,000,000.00
3,020,884.37
0.00
0.00
3,020,204.84
26,125.00
0.00
33,250.00
7,125.00
0.00
679.53
(679.53)
6,445.47
6,445.47
06051GHF9 Bank of America Corp
Callable Note 1X 3/5/2023
3.55% Due 03/05/2024
Various
Various
2,400,000.00
2,417,683.80
0.00
0.00
2,417,104.62
41,653.34
42,600.00
6,153.33
7,099.99
0.00
579.18
(579.18)
6,520.81
6,520.81
06051GHY8 Bank of America Corp
Callable Note Cont 2/13/2025
2.015% Due 02/13/2026
03/04/2021
03/08/2021
1,250,000.00
1,287,628.87
0.00
0.00
1,286,934.61
1,259.38
0.00
3,358.33
2,098.95
0.00
694.26
(694.26)
1,404.69
1,404.69
06368FAC3 Bank of Montreal
Note
1.25% Due 09/15/2026
Various
09/15/2021
2,500,000.00
0.00
2,495,539.50
0.00
2,495,578.58
0.00
0.00
1,388.89
1,388.89
39.08
0.00
39.08
1,427.97
1,427.97
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 18 215
Income Earned
As of September 30, 2021
City of Dublin Consolidated
Account #10221
CUSIP Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
06406RAJ6 Bank of NY Mellon Corp
Note
3.45% Due 08/11/2023
08/24/2018
08/28/2018
1,200,000.00
1,200,719.58
0.00
0.00
1,200,689.13
2,300.00
0.00
5,750.00
3,450.00
0.00
30.45
(30.45)
3,419.55
3,419.55
084670BR8 Berkshire Hathaway
Callable Note Cont 1/15/2023
2.75% Due 03/15/2023
Various
Various
1,865,000.00
1,849,311.87
0.00
0.00
1,850,152.31
23,649.24
25,643.75
2,279.44
4,273.95
840.44
0.00
840.44
5,114.39
5,114.39
09690AAC7 BMW Vehicle Lease Trust
2021-2 A3
0.33% Due 12/26/2024
09/08/2021
09/15/2021
710,000.00
0.00
709,926.73
0.00
709,928.14
0.00
0.00
104.13
104.13
1.41
0.00
1.41
105.54
105.54
166764AH3 Chevron Corp
Callable Note Cont 3/24/2023
3.191% Due 06/24/2023
11/08/2018
11/13/2018
1,000,000.00
993,393.93
0.00
0.00
993,693.75
5,938.81
0.00
8,597.97
2,659.16
299.82
0.00
299.82
2,958.98
2,958.98
24422ETT6 John Deere Capital Corp
Note
2.65% Due 06/24/2024
Various
Various
2,000,000.00
2,072,719.20
0.00
0.00
2,070,594.97
9,863.88
0.00
14,280.56
4,416.68
0.00
2,124.23
(2,124.23)
2,292.45
2,292.45
3130A0F70 FHLB
Note
3.375% Due 12/08/2023
Various
Various
5,000,000.00
5,068,162.22
0.00
0.00
5,065,692.57
38,906.25
0.00
52,968.75
14,062.50
0.00
2,469.65
(2,469.65)
11,592.85
11,592.85
3130A1XJ2 FHLB
Note
2.875% Due 06/14/2024
Various
Various
3,795,000.00
3,886,290.12
0.00
0.00
3,883,597.20
23,336.61
0.00
32,428.80
9,092.19
0.00
2,692.92
(2,692.92)
6,399.27
6,399.27
3130A2UW4 FHLB
Note
2.875% Due 09/13/2024
10/10/2019
10/11/2019
2,000,000.00
2,075,151.84
0.00
0.00
2,073,117.04
26,833.33
28,750.00
2,875.00
4,791.67
0.00
2,034.80
(2,034.80)
2,756.87
2,756.87
313378CR0 FHLB
Note
2.25% Due 03/11/2022
06/19/2017
06/20/2017
2,000,000.00
2,003,906.37
0.00
0.00
2,003,292.80
21,250.00
22,500.00
2,500.00
3,750.00
0.00
613.57
(613.57)
3,136.43
3,136.43
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 19 216
Income Earned
As of September 30, 2021
City of Dublin Consolidated
Account #10221
CUSIP Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
313383QR5 FHLB
Note
3.25% Due 06/09/2023
08/28/2018
08/29/2018
1,500,000.00
1,509,256.87
0.00
0.00
1,508,826.98
11,104.17
0.00
15,166.67
4,062.50
0.00
429.89
(429.89)
3,632.61
3,632.61
313383YJ4 FHLB
Note
3.375% Due 09/08/2023
Various
Various
5,000,000.00
5,044,074.24
0.00
0.00
5,042,280.17
81,093.76
84,375.00
10,781.25
14,062.49
0.00
1,794.07
(1,794.07)
12,268.42
12,268.42
3133EKWV4 FFCB
Note
1.85% Due 07/26/2024
08/13/2019
08/14/2019
2,500,000.00
2,514,139.52
0.00
0.00
2,513,738.97
4,496.53
0.00
8,350.69
3,854.16
0.00
400.55
(400.55)
3,453.61
3,453.61
3133EKZK5 FFCB
Note
1.6% Due 08/14/2023
08/26/2019
08/27/2019
4,000,000.00
4,004,425.41
0.00
0.00
4,004,238.95
3,022.22
0.00
8,355.56
5,333.34
0.00
186.46
(186.46)
5,146.88
5,146.88
3135G03U5 FNMA
Note
0.625% Due 04/22/2025
04/22/2020
04/24/2020
1,825,000.00
1,822,260.76
0.00
0.00
1,822,322.59
4,087.24
0.00
5,037.76
950.52
61.83
0.00
61.83
1,012.35
1,012.35
3135G04Z3 FNMA
Note
0.5% Due 06/17/2025
06/17/2020
06/19/2020
3,435,000.00
3,429,600.89
0.00
0.00
3,429,717.84
3,530.42
0.00
4,961.67
1,431.25
116.95
0.00
116.95
1,548.20
1,548.20
3135G05G4 FNMA
Note
0.25% Due 07/10/2023
07/08/2020
07/10/2020
2,350,000.00
2,346,876.22
0.00
0.00
2,347,014.64
832.29
0.00
1,321.88
489.59
138.42
0.00
138.42
628.01
628.01
3135G05X7 FNMA
Note
0.375% Due 08/25/2025
08/25/2020
08/27/2020
2,755,000.00
2,744,722.04
0.00
0.00
2,744,934.10
172.19
0.00
1,033.13
860.94
212.06
0.00
212.06
1,073.00
1,073.00
3135G06G3 FNMA
Note
0.5% Due 11/07/2025
11/09/2020
11/12/2020
2,860,000.00
2,851,408.63
0.00
0.00
2,851,577.31
4,528.33
0.00
5,720.00
1,191.67
168.68
0.00
168.68
1,360.35
1,360.35
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 20 217
Income Earned
As of September 30, 2021
City of Dublin Consolidated
Account #10221
CUSIP Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
3135G0Q89 FNMA
Note
Due 10/07/2021
10/06/2016
10/07/2016
0.00
1,999,860.50
0.00
1,999,907.00
0.00
11,000.00
11,916.67
0.00
916.67
46.50
0.00
46.50
963.17
963.17
3135G0S38 FNMA
Note
Due 01/05/2022
01/30/2017
01/31/2017
0.00
2,499,683.25
0.00
2,499,720.96
0.00
7,777.78
9,861.11
0.00
2,083.33
37.71
0.00
37.71
2,121.04
2,121.04
3135G0T45 FNMA
Note
1.875% Due 04/05/2022
05/05/2017
05/08/2017
3,250,000.00
3,247,846.63
0.00
0.00
3,248,145.71
24,713.54
0.00
29,791.67
5,078.13
299.08
0.00
299.08
5,377.21
5,377.21
3135G0T94 FNMA
Note
2.375% Due 01/19/2023
03/28/2018
03/29/2018
2,500,000.00
2,489,559.41
0.00
0.00
2,490,179.64
6,927.08
0.00
11,875.00
4,947.92
620.23
0.00
620.23
5,568.15
5,568.15
3135G0V34 FNMA
Note
2.5% Due 02/05/2024
02/27/2019
02/28/2019
2,000,000.00
1,996,231.60
0.00
0.00
1,996,359.06
3,611.11
0.00
7,777.78
4,166.67
127.46
0.00
127.46
4,294.13
4,294.13
3135G0W66 FNMA
Note
1.625% Due 10/15/2024
11/08/2019
11/12/2019
2,000,000.00
1,989,480.82
0.00
0.00
1,989,757.64
12,277.78
0.00
14,986.11
2,708.33
276.82
0.00
276.82
2,985.15
2,985.15
3135G0X24 FNMA
Note
1.625% Due 01/07/2025
Various
Various
4,200,000.00
4,260,922.44
0.00
0.00
4,259,429.24
10,237.50
0.00
15,925.00
5,687.50
81.85
1,575.05
(1,493.20)
4,194.30
4,194.30
3137BFE98 FHLMC
K041 A2
3.171% Due 10/25/2024
07/01/2021
07/07/2021
2,000,000.00
2,144,233.03
0.00
0.00
2,140,390.23
5,285.00
5,285.00
5,285.00
5,285.00
0.00
3,842.80
(3,842.80)
1,442.20
1,442.20
3137EAEN5 FHLMC
Note
2.75% Due 06/19/2023
07/16/2018
07/17/2018
2,000,000.00
1,995,753.15
0.00
0.00
1,995,947.36
11,000.00
0.00
15,583.33
4,583.33
194.21
0.00
194.21
4,777.54
4,777.54
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 21 218
Income Earned
As of September 30, 2021
City of Dublin Consolidated
Account #10221
CUSIP Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
3137EAEP0 FHLMC
Note
1.5% Due 02/12/2025
Various
Various
4,200,000.00
4,238,257.81
0.00
0.00
4,237,346.91
3,325.00
0.00
8,575.00
5,250.00
29.30
940.20
(910.90)
4,339.10
4,339.10
3137EAEU9 FHLMC
Note
0.375% Due 07/21/2025
07/21/2020
07/23/2020
1,745,000.00
1,738,239.45
0.00
0.00
1,738,382.37
727.08
0.00
1,272.40
545.32
142.92
0.00
142.92
688.24
688.24
3137EAEX3 FHLMC
Note
0.375% Due 09/23/2025
09/23/2020
09/25/2020
2,655,000.00
2,648,502.48
0.00
0.00
2,648,633.92
4,369.69
4,978.13
221.25
829.69
131.44
0.00
131.44
961.13
961.13
43813KAC6 Honda Auto Receivables Trust
2020-3 A3
0.37% Due 10/18/2024
09/22/2020
09/29/2020
1,120,000.00
1,119,883.89
0.00
0.00
1,119,888.21
149.64
345.33
149.64
345.33
4.32
0.00
4.32
349.65
349.65
43815HAC1 Honda Auto Receivables Trust
2018-3 A3
2.95% Due 08/22/2022
08/21/2018
08/28/2018
68,037.50
117,933.73
0.00
49,900.18
68,035.42
96.64
289.93
55.75
249.04
1.87
0.00
1.87
250.91
250.91
438516CB0 Honeywell Intl
Callable Note Cont 5/1/2025
1.35% Due 06/01/2025
06/23/2020
06/25/2020
2,500,000.00
2,544,952.57
0.00
0.00
2,543,944.66
8,437.50
0.00
11,250.00
2,812.50
0.00
1,007.91
(1,007.91)
1,804.59
1,804.59
44891VAC5 Hyundai Auto Lease Trust
2021-B A3
0.33% Due 06/17/2024
06/08/2021
06/16/2021
1,420,000.00
1,419,806.98
0.00
0.00
1,419,814.76
208.27
390.50
208.27
390.50
7.78
0.00
7.78
398.28
398.28
44933LAC7 Hyundai Auto Receivables Trust
2021-A A3
0.38% Due 09/15/2025
04/20/2021
04/28/2021
725,000.00
724,932.36
0.00
0.00
724,934.42
122.44
229.58
122.44
229.58
2.06
0.00
2.06
231.64
231.64
44934KAC8 Hyundai Auto Receivables Trust
2021-B A3
0.38% Due 01/15/2026
07/20/2021
07/28/2021
2,065,000.00
2,064,558.18
0.00
0.00
2,064,570.12
348.76
653.92
348.76
653.92
11.94
0.00
11.94
665.86
665.86
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 22 219
Income Earned
As of September 30, 2021
City of Dublin Consolidated
Account #10221
CUSIP Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
4581X0CZ9 Inter-American Dev Bank
Note
1.75% Due 09/14/2022
11/28/2017
11/30/2017
2,500,000.00
2,489,555.83
0.00
0.00
2,490,384.73
20,295.14
21,875.00
2,065.97
3,645.83
828.90
0.00
828.90
4,474.73
4,474.73
4581X0DN5 Inter-American Dev Bank
Note
0.625% Due 07/15/2025
01/13/2021
01/15/2021
1,685,000.00
1,691,307.51
0.00
0.00
1,691,173.60
1,345.66
0.00
2,223.26
877.60
0.00
133.91
(133.91)
743.69
743.69
4581X0DV7 Inter-American Dev Bank
Note
0.875% Due 04/20/2026
04/13/2021
04/20/2021
4,615,000.00
4,595,414.41
0.00
0.00
4,595,761.67
14,694.29
0.00
18,059.39
3,365.10
347.26
0.00
347.26
3,712.36
3,712.36
4581X0DZ8 Inter-American Dev Bank
Note
0.5% Due 09/23/2024
09/15/2021
09/23/2021
3,680,000.00
0.00
3,677,276.80
0.00
3,677,296.68
0.00
0.00
408.89
408.89
19.88
0.00
19.88
428.77
428.77
459058FY4 Intl. Bank Recon & Development
Note
2% Due 01/26/2022
10/26/2017
10/30/2017
2,000,000.00
1,999,081.37
0.00
0.00
1,999,268.84
3,888.89
0.00
7,222.22
3,333.33
187.47
0.00
187.47
3,520.80
3,520.80
459058JB0 Intl. Bank Recon & Development
Note
0.625% Due 04/22/2025
04/15/2020
04/22/2020
2,260,000.00
2,253,634.34
0.00
0.00
2,253,778.03
5,061.46
0.00
6,238.54
1,177.08
143.69
0.00
143.69
1,320.77
1,320.77
459058JL8 Intl. Bank Recon & Development
Note
0.5% Due 10/28/2025
Various
Various
6,000,000.00
5,988,285.44
0.00
0.00
5,988,516.95
10,250.00
0.00
12,750.00
2,500.00
249.22
17.71
231.51
2,731.51
2,731.51
46625HRL6 JP Morgan Chase
Callable Note Cont 3/18/2023
2.7% Due 05/18/2023
12/20/2018
12/24/2018
500,000.00
491,861.97
0.00
0.00
492,253.22
3,862.50
0.00
4,987.50
1,125.00
391.25
0.00
391.25
1,516.25
1,516.25
46647PAU0 JP Morgan Chase & Co
Callable Note 1X 7/23/2023
3.797% Due 07/23/2024
09/12/2019
09/16/2019
2,500,000.00
2,578,767.95
0.00
0.00
2,576,530.22
10,019.86
0.00
17,930.28
7,910.42
0.00
2,237.73
(2,237.73)
5,672.69
5,672.69
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 23 220
Income Earned
As of September 30, 2021
City of Dublin Consolidated
Account #10221
CUSIP Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
46647PBH8 JP Morgan Chase & Co
Callable Note Mthly 3/13/2025
2.005% Due 03/13/2026
04/29/2021
04/30/2021
1,000,000.00
1,027,613.61
0.00
0.00
1,026,970.93
9,356.67
10,025.00
1,002.50
1,670.83
0.00
642.68
(642.68)
1,028.15
1,028.15
47787NAC3 John Deere Owner Trust
2020-B A3
0.51% Due 11/15/2024
07/14/2020
07/22/2020
515,000.00
514,946.56
0.00
0.00
514,948.41
116.73
218.88
116.73
218.88
1.85
0.00
1.85
220.73
220.73
47788EAC2 John Deere Owner Trust
2018-B A3
3.08% Due 11/15/2022
07/18/2018
07/25/2018
61,991.45
99,931.79
0.00
37,942.46
61,990.23
136.80
256.50
84.86
204.56
0.90
0.00
0.90
205.46
205.46
47788UAC6 John Deere Owner Trust
2021-A A3
0.36% Due 09/15/2025
03/02/2021
03/10/2021
800,000.00
799,866.70
0.00
0.00
799,870.21
128.00
240.00
128.00
240.00
3.51
0.00
3.51
243.51
243.51
47789QAC4 John Deere Owner Trust
2021-B A3
0.52% Due 03/16/2026
07/13/2021
07/21/2021
965,000.00
964,916.63
0.00
0.00
964,918.57
557.56
752.70
223.02
418.16
1.94
0.00
1.94
420.10
420.10
58769KAD6 Mercedes-Benz Auto Lease Trust
2021-B A3
0.4% Due 11/15/2024
06/22/2021
06/29/2021
1,135,000.00
1,134,920.21
0.00
0.00
1,134,922.97
201.78
378.33
201.78
378.33
2.76
0.00
2.76
381.09
381.09
58933YAF2 Merck & Co
Note
2.8% Due 05/18/2023
10/26/2018
10/30/2018
740,000.00
732,860.93
0.00
0.00
733,204.15
5,928.22
0.00
7,654.89
1,726.67
343.22
0.00
343.22
2,069.89
2,069.89
58989V2D5 Met Tower Global Funding
Note
1.25% Due 09/14/2026
09/07/2021
09/14/2021
1,285,000.00
0.00
1,283,817.80
0.00
1,283,828.81
0.00
0.00
758.51
758.51
11.01
0.00
11.01
769.52
769.52
61747YEA9 Morgan Stanley
Callable Note Cont 5/30/2024
0.79% Due 05/30/2025
05/26/2021
06/01/2021
3,040,000.00
3,041,510.07
0.00
0.00
3,041,476.93
6,004.00
0.00
8,005.34
2,001.34
0.00
33.14
(33.14)
1,968.20
1,968.20
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 24 221
Income Earned
As of September 30, 2021
City of Dublin Consolidated
Account #10221
CUSIP Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
65479GAD1 Nissan Auto Receivables Trust
2018-B A3
3.06% Due 03/15/2023
07/17/2018
07/25/2018
232,614.05
284,236.96
0.00
51,624.09
232,613.25
386.56
724.81
316.36
654.61
0.38
0.00
0.38
654.99
654.99
65479JAD5 Nissan Auto Receivables Owner
2019-C A3
1.93% Due 07/15/2024
10/16/2019
10/23/2019
1,311,925.08
1,420,972.26
0.00
109,092.70
1,311,884.25
1,218.92
2,285.47
1,125.34
2,191.89
4.69
0.00
4.69
2,196.58
2,196.58
69353RFL7 PNC Bank
Callable Note Cont 5/9/2023
3.5% Due 06/08/2023
Various
Various
2,210,000.00
2,208,922.77
0.00
0.00
2,208,972.87
17,833.47
0.00
24,279.30
6,445.83
50.10
0.00
50.10
6,495.93
6,495.93
78013XZU5 Royal Bank of Canada
Note
2.55% Due 07/16/2024
09/10/2019
09/12/2019
2,500,000.00
2,518,575.42
0.00
0.00
2,518,044.19
7,968.75
0.00
13,281.25
5,312.50
0.00
531.23
(531.23)
4,781.27
4,781.27
78015K7H1 Royal Bank of Canada
Note
1.15% Due 06/10/2025
02/22/2021
02/24/2021
1,000,000.00
1,010,763.70
0.00
0.00
1,010,529.37
2,587.50
0.00
3,545.83
958.33
0.00
234.33
(234.33)
724.00
724.00
79466LAG9 Salesforce.com Inc
Callable Note Cont 7/15/2022
0.625% Due 07/15/2024
06/29/2021
07/12/2021
465,000.00
464,773.86
0.00
0.00
464,780.33
395.57
0.00
637.76
242.19
6.47
0.00
6.47
248.66
248.66
808513AT2 Charles Schwab Corp
Callable Note Cont 12/25/2022
2.65% Due 01/25/2023
05/21/2019
05/23/2019
2,000,000.00
1,997,686.61
0.00
0.00
1,997,822.43
5,300.00
0.00
9,716.67
4,416.67
135.82
0.00
135.82
4,552.49
4,552.49
808513BR5 Charles Schwab Corp
Callable Note Cont 4/13/2026
1.15% Due 05/13/2026
05/11/2021
05/13/2021
1,370,000.00
1,367,014.81
0.00
0.00
1,367,067.03
4,726.50
0.00
6,039.42
1,312.92
52.22
0.00
52.22
1,365.14
1,365.14
89114QCB2 Toronto Dominion Bank
Note
3.25% Due 03/11/2024
03/26/2019
03/28/2019
2,300,000.00
2,315,910.36
0.00
0.00
2,315,392.67
35,298.61
37,375.00
4,152.78
6,229.17
0.00
517.69
(517.69)
5,711.48
5,711.48
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 25 222
Income Earned
As of September 30, 2021
City of Dublin Consolidated
Account #10221
CUSIP Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
89114QCK2 Toronto Dominion Bank
Note
0.75% Due 09/11/2025
02/16/2021
02/18/2021
1,000,000.00
997,554.22
0.00
0.00
997,604.10
3,541.67
3,750.00
416.67
625.00
49.88
0.00
49.88
674.88
674.88
89231PAD0 Toyota Auto Receivables Trust
2018-D A3
3.18% Due 03/15/2023
08/29/2019
08/30/2019
407,621.51
487,472.05
0.00
75,380.76
411,191.62
682.64
1,279.96
576.11
1,173.43
0.00
899.67
(899.67)
273.76
273.76
89236TJK2 Toyota Motor Credit Corp
Note
1.125% Due 06/18/2026
06/15/2021
06/18/2021
2,485,000.00
2,483,951.51
0.00
0.00
2,483,969.47
5,668.91
0.00
7,998.59
2,329.68
17.96
0.00
17.96
2,347.64
2,347.64
89237VAB5 Toyota Auto Receivables Trust
2020-C A3
0.44% Due 10/15/2024
07/21/2020
07/27/2020
1,025,000.00
1,024,941.62
0.00
0.00
1,024,943.15
200.44
375.83
200.44
375.83
1.53
0.00
1.53
377.36
377.36
89239CAC3 Toyota Lease Owner Trust
2021-B A3
0.42% Due 10/21/2024
07/27/2021
08/02/2021
1,090,000.00
1,089,985.77
0.00
0.00
1,089,986.26
368.78
610.40
139.88
381.50
0.49
0.00
0.49
381.99
381.99
90331HPL1 US Bank NA
Callable Note Cont 12/21/2024
2.05% Due 01/21/2025
01/16/2020
01/21/2020
2,610,000.00
2,606,232.94
0.00
0.00
2,606,324.23
5,945.00
0.00
10,403.75
4,458.75
91.29
0.00
91.29
4,550.04
4,550.04
91159HHP8 US Bancorp
Callable Note Cont 12/23/2021
2.625% Due 01/24/2022
05/23/2017
05/26/2017
1,000,000.00
1,000,786.67
0.00
0.00
1,000,577.82
2,697.92
0.00
4,885.42
2,187.50
0.00
208.85
(208.85)
1,978.65
1,978.65
9128282N9 US Treasury
Note
2.125% Due 07/31/2024
08/30/2019
08/30/2019
2,000,000.00
2,038,208.82
0.00
0.00
2,037,131.50
3,695.65
0.00
7,160.33
3,464.68
0.00
1,077.32
(1,077.32)
2,387.36
2,387.36
9128283J7 US Treasury
Note
2.125% Due 11/30/2024
Various
Various
3,000,000.00
3,033,820.64
0.00
0.00
3,032,965.14
16,198.77
0.00
21,424.19
5,225.42
0.00
855.50
(855.50)
4,369.92
4,369.92
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 26 223
Income Earned
As of September 30, 2021
City of Dublin Consolidated
Account #10221
CUSIP Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
9128284D9 US Treasury
Note
2.5% Due 03/31/2023
Various
Various
3,750,000.00
3,735,984.04
0.00
0.00
3,736,714.04
39,446.72
46,875.00
257.55
7,685.83
730.00
0.00
730.00
8,415.83
8,415.83
912828J76 US Treasury
Note
1.75% Due 03/31/2022
04/25/2017
04/26/2017
3,000,000.00
2,998,339.00
0.00
0.00
2,998,575.16
22,090.16
26,250.00
144.23
4,304.07
236.16
0.00
236.16
4,540.23
4,540.23
912828L24 US Treasury
Note
1.875% Due 08/31/2022
09/27/2017
09/28/2017
2,000,000.00
1,999,178.91
0.00
0.00
1,999,246.59
103.59
0.00
3,211.33
3,107.74
67.68
0.00
67.68
3,175.42
3,175.42
912828L57 US Treasury
Note
1.75% Due 09/30/2022
Various
Various
3,750,000.00
3,739,610.52
0.00
0.00
3,740,401.59
27,612.70
32,812.50
180.29
5,380.09
791.07
0.00
791.07
6,171.16
6,171.16
912828M49 US Treasury
Note
1.875% Due 10/31/2022
01/30/2018
01/31/2018
1,000,000.00
993,470.44
0.00
0.00
993,931.35
6,317.93
0.00
7,846.47
1,528.54
460.91
0.00
460.91
1,989.45
1,989.45
912828R69 US Treasury
Note
1.625% Due 05/31/2023
05/30/2018
05/31/2018
1,500,000.00
1,474,592.55
0.00
0.00
1,475,789.13
6,193.65
0.00
8,191.60
1,997.95
1,196.58
0.00
1,196.58
3,194.53
3,194.53
912828U57 US Treasury
Note
2.125% Due 11/30/2023
Various
Various
5,000,000.00
4,957,451.78
0.00
0.00
4,959,008.41
26,997.95
0.00
35,706.97
8,709.02
1,556.63
0.00
1,556.63
10,265.65
10,265.65
912828V72 US Treasury
Note
Due 01/31/2022
02/27/2017
02/28/2017
0.00
1,500,203.52
0.00
1,500,191.46
0.00
2,445.65
3,133.49
0.00
687.84
0.00
12.06
(12.06)
675.78
675.78
912828V80 US Treasury
Note
2.25% Due 01/31/2024
Various
Various
5,000,000.00
4,991,820.26
0.00
0.00
4,992,098.49
9,782.60
0.00
18,953.80
9,171.20
278.23
0.00
278.23
9,449.43
9,449.43
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 27 224
Income Earned
As of September 30, 2021
City of Dublin Consolidated
Account #10221
CUSIP Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
912828WJ5 US Treasury
Note
2.5% Due 05/15/2024
06/10/2019
06/11/2019
1,750,000.00
1,776,463.51
0.00
0.00
1,775,659.15
12,958.56
0.00
16,525.14
3,566.58
0.00
804.36
(804.36)
2,762.22
2,762.22
912828WZ9 US Treasury
Note
1.75% Due 04/30/2022
05/23/2017
05/24/2017
1,750,000.00
2,748,521.47
0.00
999,495.82
1,749,176.24
16,304.64
6,610.05
12,885.93
3,191.34
150.59
0.00
150.59
3,341.93
3,341.93
912828XR6 US Treasury
Note
1.75% Due 05/31/2022
06/28/2017
06/29/2017
1,500,000.00
1,499,397.67
0.00
0.00
1,499,464.11
6,670.08
0.00
8,821.72
2,151.64
66.44
0.00
66.44
2,218.08
2,218.08
912828XW5 US Treasury
Note
1.75% Due 06/30/2022
07/25/2017
07/26/2017
3,000,000.00
2,997,327.73
0.00
0.00
2,997,593.19
8,987.77
0.00
13,267.66
4,279.89
265.46
0.00
265.46
4,545.35
4,545.35
912828YH7 US Treasury
Note
1.5% Due 09/30/2024
Various
Various
3,500,000.00
3,484,078.58
0.00
0.00
3,484,503.16
22,090.16
26,250.00
144.23
4,304.07
424.58
0.00
424.58
4,728.65
4,728.65
912828ZC7 US Treasury
Note
1.125% Due 02/28/2025
03/24/2020
03/25/2020
3,500,000.00
3,573,132.77
0.00
0.00
3,571,413.35
108.77
0.00
3,371.89
3,263.12
0.00
1,719.42
(1,719.42)
1,543.70
1,543.70
912828ZL7 US Treasury
Note
0.375% Due 04/30/2025
Various
Various
4,000,000.00
3,998,943.73
0.00
0.00
3,998,967.43
5,054.34
0.00
6,277.18
1,222.84
57.61
33.91
23.70
1,246.54
1,246.54
91282CAM3 US Treasury
Note
0.25% Due 09/30/2025
10/16/2020
10/19/2020
2,500,000.00
2,492,913.84
0.00
0.00
2,493,056.52
2,629.78
3,125.00
17.17
512.39
142.68
0.00
142.68
655.07
655.07
91282CBC4 US Treasury
Note
0.375% Due 12/31/2025
12/29/2020
12/31/2020
1,000,000.00
999,932.32
0.00
0.00
999,933.60
641.98
0.00
947.69
305.71
1.28
0.00
1.28
306.99
306.99
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 28 225
Income Earned
As of September 30, 2021
City of Dublin Consolidated
Account #10221
CUSIP Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
91282CBH3 US Treasury
Note
0.375% Due 01/31/2026
02/23/2021
02/24/2021
4,000,000.00
3,964,754.79
0.00
0.00
3,965,410.31
1,304.35
0.00
2,527.17
1,222.82
655.52
0.00
655.52
1,878.34
1,878.34
91282CBQ3 US Treasury
Note
0.5% Due 02/28/2026
03/26/2021
03/29/2021
2,500,000.00
2,463,436.78
0.00
0.00
2,464,105.22
34.53
0.00
1,070.44
1,035.91
668.44
0.00
668.44
1,704.35
1,704.35
91282CBT7 US Treasury
Note
0.75% Due 03/31/2026
Various
Various
5,000,000.00
4,976,852.15
0.00
0.00
4,977,267.48
15,778.69
18,750.00
103.02
3,074.33
415.33
0.00
415.33
3,489.66
3,489.66
91282CCF6 US Treasury
Note
0.75% Due 05/31/2026
06/18/2021
06/21/2021
2,000,000.00
1,985,598.34
0.00
0.00
1,985,847.65
3,811.48
0.00
5,040.98
1,229.50
249.31
0.00
249.31
1,478.81
1,478.81
91282CCW9 US Treasury
Note
0.75% Due 08/31/2026
08/30/2021
08/31/2021
2,000,000.00
1,998,516.44
0.00
0.00
1,998,540.83
41.44
0.00
1,284.53
1,243.09
24.39
0.00
24.39
1,267.48
1,267.48
91324PEC2 United Health Group Inc
Callable Note Cont 4/15/2026
1.15% Due 05/15/2026
Various
Various
605,000.00
606,872.16
0.00
0.00
606,838.86
1,971.29
0.00
2,551.09
579.80
0.00
33.30
(33.30)
546.50
546.50
931142EK5 Wal-Mart Stores
Callable Note Cont 5/26/2023
3.4% Due 06/26/2023
Various
06/27/2018
1,380,000.00
1,379,869.69
0.00
0.00
1,379,875.58
8,471.67
0.00
12,381.66
3,909.99
5.89
0.00
5.89
3,915.88
3,915.88
931142ER0 Wal-Mart Stores
Callable Note Cont 08/17/2026
1.05% Due 09/17/2026
09/08/2021
09/17/2021
585,000.00
0.00
583,894.35
0.00
583,902.83
0.00
0.00
238.88
238.88
8.48
0.00
8.48
247.36
247.36
Total Fixed Income 226,117,189.59
225,549,275.99
8,750,455.18
7,323,255.43
226,954,941.62
950,535.90
521,147.84
744,687.88
315,299.82
15,535.46
37,069.58
(21,534.12)
293,765.70 293,765.70
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 29 226
Income Earned
As of September 30, 2021
City of Dublin Consolidated
Account #10221
CUSIP Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
CASH & EQUIVALENT
06417MQL2 Bank of Nova Scotia Houston
Yankee CD
0.2% Due 06/23/2022
06/29/2021
06/30/2021
2,500,000.00
2,499,999.84
0.00
0.00
2,499,999.86
972.22
0.00
1,388.89
416.67
0.02
0.00
0.02
416.69
416.69
31846V203 First American
Govt Obligation Fund Class Y
Various
Various
809,873.32
1,677,545.89
6,589,065.70
7,456,738.27
809,873.32
0.00
13.75
0.00
13.75
0.00
0.00
0.00
13.75
13.75
Total Cash & Equivalent 3,309,873.32
4,177,545.73
6,589,065.70
7,456,738.27
3,309,873.18
972.22
13.75
1,388.89
430.42
0.02
0.00
0.02
430.44 430.44
LOCAL AGENCY INVESTMENT FUND
90LAIF$00 Local Agency Investment Fund
State Pool
Various
Various
50,364,764.44
50,364,764.44
0.00
0.00
50,364,764.44
19,186.03
0.00
27,810.15
8,624.12
0.00
0.00
0.00
8,624.12
8,624.12
Total Local Agency Investment Fund 50,364,764.44
50,364,764.44
0.00
0.00
50,364,764.44
19,186.03
0.00
27,810.15
8,624.12
0.00
0.00
0.00
8,624.12 8,624.12
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 30 227
Income Earned
As of September 30, 2021
City of Dublin Consolidated
Account #10221
CUSIP Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income
INVESTMENT POOL
90CAMP$00 California Asset Mgmt Program
CAMP
Various
Various
43,129,269.68
40,027,512.43
3,601,757.25
500,000.00
43,129,269.68
0.00
1,757.25
0.00
1,757.25
0.00
0.00
0.00
1,757.25
1,757.25
Total Investment Pool 43,129,269.68
40,027,512.43
3,601,757.25
500,000.00
43,129,269.68
0.00
1,757.25
0.00
1,757.25
0.00
0.00
0.00
1,757.25 1,757.25
TOTAL PORTFOLIO 322,921,097.03
320,119,098.59
18,941,278.13
15,279,993.70
323,758,848.92
970,694.15
522,918.84
773,886.92
326,111.61
15,535.48
37,069.58
(21,534.10)
304,577.51 304,577.51
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 31 228
Cash Flow Report
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
10/05/2021 Interest 3135G0T45 3,250,000.00 FNMA Note
1.875% Due 4/5/2022
0.00 30,468.75 30,468.75
10/15/2021 Dividend 90LAIF$00 4,632,942,011.03 Local Agency Investment Fund State Pool 0.00 27,443.18 27,443.18
10/15/2021 Interest 3135G0W66 2,000,000.00 FNMA Note
1.625% Due 10/15/2024
0.00 16,250.00 16,250.00
10/15/2021 Paydown 44891VAC5 1,420,000.00 Hyundai Auto Lease Trust 2021-B A3
0.33% Due 6/17/2024
0.00 390.50 390.50
10/15/2021 Paydown 44934KAC8 2,065,000.00 Hyundai Auto Receivables Trust 2021-B A3
0.38% Due 1/15/2026
0.00 653.92 653.92
10/15/2021 Paydown 47787NAC3 515,000.00 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
0.00 218.88 218.88
10/15/2021 Paydown 65479JAD5 1,311,925.08 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
37,172.31 2,110.01 39,282.32
10/15/2021 Paydown 89237VAB5 1,025,000.00 Toyota Auto Receivables Trust 2020-C A3
0.44% Due 10/15/2024
0.00 375.83 375.83
10/15/2021 Paydown 47788EAC2 61,991.45 John Deere Owner Trust 2018-B A3
3.08% Due 11/15/2022
4,290.53 159.11 4,449.64
10/15/2021 Paydown 47789QAC4 965,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
0.00 418.17 418.17
10/15/2021 Paydown 65479GAD1 232,614.05 Nissan Auto Receivables Trust 2018-B A3
3.06% Due 3/15/2023
54,212.85 593.17 54,806.02
10/15/2021 Paydown 89231PAD0 407,621.51 Toyota Auto Receivables Trust 2018-D A3
3.18% Due 3/15/2023
22,306.21 1,080.20 23,386.41
10/15/2021 Paydown 58769KAD6 1,135,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
0.00 378.33 378.33
10/15/2021 Paydown 44933LAC7 725,000.00 Hyundai Auto Receivables Trust 2021-A A3
0.38% Due 9/15/2025
0.00 229.58 229.58
10/15/2021 Paydown 47788UAC6 800,000.00 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
0.00 240.00 240.00
10/18/2021 Paydown 43813KAC6 1,120,000.00 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
0.00 345.33 345.33
10/20/2021 Interest 4581X0DV7 4,615,000.00 Inter-American Dev Bank Note
0.875% Due 4/20/2026
0.00 20,190.63 20,190.63
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 32 229
Cash Flow Report
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
10/20/2021 Paydown 89239CAC3 1,090,000.00 Toyota Lease Owner Trust 2021-B A3
0.42% Due 10/21/2024
0.00 381.50 381.50
10/21/2021 Paydown 43815HAC1 68,037.50 Honda Auto Receivables Trust 2018-3 A3
2.95% Due 8/22/2022
5,593.54 167.26 5,760.80
10/21/2021 Paydown 3137BFE98 0.00 FHLMC K041 A2
3.171% Due 10/25/2024
0.00 5,285.00 5,285.00
10/22/2021 Interest 3135G03U5 1,825,000.00 FNMA Note
0.625% Due 4/22/2025
0.00 5,703.13 5,703.13
10/22/2021 Interest 459058JB0 2,260,000.00 Intl. Bank Recon & Development Note
0.625% Due 4/22/2025
0.00 7,062.50 7,062.50
10/25/2021 Paydown 3137BFE98 2,000,000.00 FHLMC K041 A2
3.171% Due 10/25/2024
0.00 5,285.00 5,285.00
10/25/2021 Paydown 09690AAC7 710,000.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due 12/26/2024
0.00 260.33 260.33
10/28/2021 Interest 459058JL8 6,000,000.00 Intl. Bank Recon & Development Note
0.5% Due 10/28/2025
0.00 15,000.00 15,000.00
10/30/2021 Interest 912828WZ9 1,750,000.00 US Treasury Note
1.75% Due 4/30/2022
0.00 15,312.50 15,312.50
10/31/2021 Interest 912828M49 1,000,000.00 US Treasury Note
1.875% Due 10/31/2022
0.00 9,375.00 9,375.00
10/31/2021 Interest 912828ZL7 4,000,000.00 US Treasury Note
0.375% Due 4/30/2025
0.00 7,500.00 7,500.00
OCT 2021 123,575.44 172,877.81 296,453.25
11/07/2021 Interest 3135G06G3 2,860,000.00 FNMA Note
0.5% Due 11/7/2025
0.00 7,150.00 7,150.00
11/11/2021 Interest 037833CU2 3,000,000.00 Apple Inc Callable Note Cont 3/11/2024
2.85% Due 5/11/2024
0.00 42,750.00 42,750.00
11/12/2021 Interest 023135BW5 1,865,000.00 Amazon.com Inc Note
0.45% Due 5/12/2024
0.00 4,196.25 4,196.25
11/13/2021 Interest 808513BR5 1,370,000.00 Charles Schwab Corp Callable Note Cont 4/13/2026
1.15% Due 5/13/2026
0.00 7,877.50 7,877.50
11/15/2021 Interest 912828WJ5 1,750,000.00 US Treasury Note
2.5% Due 5/15/2024
0.00 21,875.00 21,875.00
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 33 230
Cash Flow Report
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
11/15/2021 Interest 91324PEC2 605,000.00 United Health Group Inc Callable Note Cont
4/15/2026
1.15% Due 5/15/2026
0.00 3,401.45 3,401.45
11/15/2021 Paydown 47787NAC3 515,000.00 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
0.00 218.88 218.88
11/15/2021 Paydown 47788UAC6 800,000.00 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
0.00 240.00 240.00
11/15/2021 Paydown 58769KAD6 1,135,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
0.00 378.33 378.33
11/15/2021 Paydown 65479GAD1 232,614.05 Nissan Auto Receivables Trust 2018-B A3
3.06% Due 3/15/2023
50,396.14 454.92 50,851.06
11/15/2021 Paydown 44891VAC5 1,420,000.00 Hyundai Auto Lease Trust 2021-B A3
0.33% Due 6/17/2024
0.00 390.50 390.50
11/15/2021 Paydown 44933LAC7 725,000.00 Hyundai Auto Receivables Trust 2021-A A3
0.38% Due 9/15/2025
0.00 229.58 229.58
11/15/2021 Paydown 47789QAC4 965,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
0.00 418.17 418.17
11/15/2021 Paydown 89231PAD0 407,621.51 Toyota Auto Receivables Trust 2018-D A3
3.18% Due 3/15/2023
22,345.76 1,021.09 23,366.85
11/15/2021 Paydown 89237VAB5 1,025,000.00 Toyota Auto Receivables Trust 2020-C A3
0.44% Due 10/15/2024
0.00 375.83 375.83
11/15/2021 Paydown 44934KAC8 2,065,000.00 Hyundai Auto Receivables Trust 2021-B A3
0.38% Due 1/15/2026
0.00 653.92 653.92
11/15/2021 Paydown 47788EAC2 61,991.45 John Deere Owner Trust 2018-B A3
3.08% Due 11/15/2022
4,311.26 148.10 4,459.36
11/15/2021 Paydown 65479JAD5 1,311,925.08 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
37,255.94 2,050.23 39,306.17
11/18/2021 Interest 58933YAF2 740,000.00 Merck & Co Note
2.8% Due 5/18/2023
0.00 10,360.00 10,360.00
11/18/2021 Interest 46625HRL6 500,000.00 JP Morgan Chase Callable Note Cont 3/18/2023
2.7% Due 5/18/2023
0.00 6,750.00 6,750.00
11/18/2021 Paydown 43813KAC6 1,120,000.00 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
0.00 345.33 345.33
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 34 231
Cash Flow Report
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
11/20/2021 Paydown 89239CAC3 1,090,000.00 Toyota Lease Owner Trust 2021-B A3
0.42% Due 10/21/2024
0.00 381.50 381.50
11/21/2021 Paydown 43815HAC1 68,037.50 Honda Auto Receivables Trust 2018-3 A3
2.95% Due 8/22/2022
5,607.29 153.51 5,760.80
11/25/2021 Paydown 09690AAC7 710,000.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due 12/26/2024
0.00 195.25 195.25
11/25/2021 Paydown 3137BFE98 2,000,000.00 FHLMC K041 A2
3.171% Due 10/25/2024
0.00 5,285.00 5,285.00
11/30/2021 Interest 61747YEA9 3,040,000.00 Morgan Stanley Callable Note Cont 5/30/2024
0.79% Due 5/30/2025
0.00 11,941.29 11,941.29
11/30/2021 Interest 912828R69 1,500,000.00 US Treasury Note
1.625% Due 5/31/2023
0.00 12,187.50 12,187.50
11/30/2021 Interest 912828U57 5,000,000.00 US Treasury Note
2.125% Due 11/30/2023
0.00 53,125.00 53,125.00
11/30/2021 Interest 9128283J7 3,000,000.00 US Treasury Note
2.125% Due 11/30/2024
0.00 31,875.00 31,875.00
11/30/2021 Interest 912828XR6 1,500,000.00 US Treasury Note
1.75% Due 5/31/2022
0.00 13,125.00 13,125.00
11/30/2021 Interest 91282CCF6 2,000,000.00 US Treasury Note
0.75% Due 5/31/2026
0.00 7,500.00 7,500.00
NOV 2021 119,916.39 247,054.13 366,970.52
12/01/2021 Interest 438516CB0 2,500,000.00 Honeywell Intl Callable Note Cont 5/1/2025
1.35% Due 6/1/2025
0.00 16,875.00 16,875.00
12/08/2021 Interest 69353RFL7 2,210,000.00 PNC Bank Callable Note Cont 5/9/2023
3.5% Due 6/8/2023
0.00 38,675.00 38,675.00
12/08/2021 Interest 3130A0F70 5,000,000.00 FHLB Note
3.375% Due 12/8/2023
0.00 84,375.00 84,375.00
12/09/2021 Interest 313383QR5 1,500,000.00 FHLB Note
3.25% Due 6/9/2023
0.00 24,375.00 24,375.00
12/10/2021 Interest 78015K7H1 1,000,000.00 Royal Bank of Canada Note
1.15% Due 6/10/2025
0.00 5,750.00 5,750.00
12/14/2021 Interest 3130A1XJ2 3,795,000.00 FHLB Note
2.875% Due 6/14/2024
0.00 54,553.13 54,553.13
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 35 232
Cash Flow Report
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
12/15/2021 Paydown 44891VAC5 1,420,000.00 Hyundai Auto Lease Trust 2021-B A3
0.33% Due 6/17/2024
0.00 390.50 390.50
12/15/2021 Paydown 47787NAC3 515,000.00 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
0.00 218.88 218.88
12/15/2021 Paydown 58769KAD6 1,135,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
0.00 378.33 378.33
12/15/2021 Paydown 89237VAB5 1,025,000.00 Toyota Auto Receivables Trust 2020-C A3
0.44% Due 10/15/2024
0.00 375.83 375.83
12/15/2021 Paydown 47788UAC6 800,000.00 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
0.00 240.00 240.00
12/15/2021 Paydown 65479GAD1 232,614.05 Nissan Auto Receivables Trust 2018-B A3
3.06% Due 3/15/2023
46,551.21 326.41 46,877.62
12/15/2021 Paydown 44934KAC8 2,065,000.00 Hyundai Auto Receivables Trust 2021-B A3
0.38% Due 1/15/2026
0.00 653.92 653.92
12/15/2021 Paydown 65479JAD5 1,311,925.08 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
37,339.76 1,990.31 39,330.07
12/15/2021 Paydown 44933LAC7 725,000.00 Hyundai Auto Receivables Trust 2021-A A3
0.38% Due 9/15/2025
0.00 229.58 229.58
12/15/2021 Paydown 47788EAC2 61,991.45 John Deere Owner Trust 2018-B A3
3.08% Due 11/15/2022
4,332.10 137.03 4,469.13
12/15/2021 Paydown 47789QAC4 965,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
0.00 418.17 418.17
12/15/2021 Paydown 89231PAD0 407,621.51 Toyota Auto Receivables Trust 2018-D A3
3.18% Due 3/15/2023
22,385.39 961.87 23,347.26
12/17/2021 Interest 3135G04Z3 3,435,000.00 FNMA Note
0.5% Due 6/17/2025
0.00 8,587.50 8,587.50
12/18/2021 Interest 89236TJK2 2,485,000.00 Toyota Motor Credit Corp Note
1.125% Due 6/18/2026
0.00 13,978.13 13,978.13
12/18/2021 Paydown 43813KAC6 1,120,000.00 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
0.00 345.33 345.33
12/19/2021 Interest 3137EAEN5 2,000,000.00 FHLMC Note
2.75% Due 6/19/2023
0.00 27,500.00 27,500.00
12/20/2021 Paydown 89239CAC3 1,090,000.00 Toyota Lease Owner Trust 2021-B A3
0.42% Due 10/21/2024
0.00 381.50 381.50
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 36 233
Cash Flow Report
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
12/21/2021 Paydown 43815HAC1 68,037.50 Honda Auto Receivables Trust 2018-3 A3
2.95% Due 8/22/2022
5,621.08 139.72 5,760.80
12/23/2021 Call 91159HHP8 1,000,000.00 US Bancorp Callable Note Cont 12/23/2021
2.625% Due 1/24/2022
1,000,000.00 10,864.58 1,010,864.58
12/24/2021 Interest 166764AH3 1,000,000.00 Chevron Corp Callable Note Cont 3/24/2023
3.191% Due 6/24/2023
0.00 15,955.00 15,955.00
12/24/2021 Interest 24422ETT6 2,000,000.00 John Deere Capital Corp Note
2.65% Due 6/24/2024
0.00 26,500.00 26,500.00
12/25/2021 Paydown 09690AAC7 710,000.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due 12/26/2024
0.00 195.25 195.25
12/25/2021 Paydown 3137BFE98 2,000,000.00 FHLMC K041 A2
3.171% Due 10/25/2024
0.00 5,285.00 5,285.00
12/26/2021 Interest 931142EK5 1,380,000.00 Wal-Mart Stores Callable Note Cont 5/26/2023
3.4% Due 6/26/2023
0.00 23,460.00 23,460.00
12/27/2021 Interest 02665WCZ2 1,500,000.00 American Honda Finance Note
2.4% Due 6/27/2024
0.00 18,000.00 18,000.00
12/31/2021 Interest 912828XW5 3,000,000.00 US Treasury Note
1.75% Due 6/30/2022
0.00 26,250.00 26,250.00
12/31/2021 Interest 91282CBC4 1,000,000.00 US Treasury Note
0.375% Due 12/31/2025
0.00 1,875.00 1,875.00
DEC 2021 1,116,229.54 410,240.97 1,526,470.51
01/07/2022 Interest 3135G0X24 4,200,000.00 FNMA Note
1.625% Due 1/7/2025
0.00 34,125.00 34,125.00
01/08/2022 Interest 02665WDL2 1,000,000.00 American Honda Finance Note
1.2% Due 7/8/2025
0.00 6,000.00 6,000.00
01/10/2022 Interest 3135G05G4 2,350,000.00 FNMA Note
0.25% Due 7/10/2023
0.00 2,937.50 2,937.50
01/14/2022 Interest 02665WCJ8 1,000,000.00 American Honda Finance Note
3.45% Due 7/14/2023
0.00 17,250.00 17,250.00
01/15/2022 Interest 79466LAG9 465,000.00 Salesforce.com Inc Callable Note Cont 7/15/2022
0.625% Due 7/15/2024
0.00 1,477.34 1,477.34
01/15/2022 Interest 4581X0DN5 1,685,000.00 Inter-American Dev Bank Note
0.625% Due 7/15/2025
0.00 5,265.63 5,265.63
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 37 234
Cash Flow Report
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
01/15/2022 Paydown 47787NAC3 515,000.00 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
0.00 218.88 218.88
01/15/2022 Paydown 47788UAC6 800,000.00 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
0.00 240.00 240.00
01/15/2022 Paydown 47789QAC4 965,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
0.00 418.17 418.17
01/15/2022 Paydown 58769KAD6 1,135,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
0.00 378.33 378.33
01/15/2022 Paydown 44891VAC5 1,420,000.00 Hyundai Auto Lease Trust 2021-B A3
0.33% Due 6/17/2024
0.00 390.50 390.50
01/15/2022 Paydown 89231PAD0 407,621.51 Toyota Auto Receivables Trust 2018-D A3
3.18% Due 3/15/2023
22,425.09 902.55 23,327.64
01/15/2022 Paydown 89237VAB5 1,025,000.00 Toyota Auto Receivables Trust 2020-C A3
0.44% Due 10/15/2024
29,965.06 375.83 30,340.89
01/15/2022 Paydown 44933LAC7 725,000.00 Hyundai Auto Receivables Trust 2021-A A3
0.38% Due 9/15/2025
0.00 229.58 229.58
01/15/2022 Paydown 44934KAC8 2,065,000.00 Hyundai Auto Receivables Trust 2021-B A3
0.38% Due 1/15/2026
0.00 653.92 653.92
01/15/2022 Paydown 47788EAC2 61,991.45 John Deere Owner Trust 2018-B A3
3.08% Due 11/15/2022
4,353.04 125.91 4,478.95
01/15/2022 Paydown 65479JAD5 1,311,925.08 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
37,423.78 1,930.25 39,354.03
01/15/2022 Paydown 65479GAD1 232,614.05 Nissan Auto Receivables Trust 2018-B A3
3.06% Due 3/15/2023
42,677.88 207.71 42,885.59
01/16/2022 Interest 78013XZU5 2,500,000.00 Royal Bank of Canada Note
2.55% Due 7/16/2024
0.00 31,875.00 31,875.00
01/18/2022 Paydown 43813KAC6 1,120,000.00 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
0.00 345.33 345.33
01/19/2022 Interest 3135G0T94 2,500,000.00 FNMA Note
2.375% Due 1/19/2023
0.00 29,687.50 29,687.50
01/20/2022 Paydown 89239CAC3 1,090,000.00 Toyota Lease Owner Trust 2021-B A3
0.42% Due 10/21/2024
0.00 381.50 381.50
01/21/2022 Interest 90331HPL1 2,610,000.00 US Bank NA Callable Note Cont 12/21/2024
2.05% Due 1/21/2025
0.00 26,752.50 26,752.50
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 38 235
Cash Flow Report
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
01/21/2022 Interest 3137EAEU9 1,745,000.00 FHLMC Note
0.375% Due 7/21/2025
0.00 3,271.88 3,271.88
01/21/2022 Paydown 43815HAC1 68,037.50 Honda Auto Receivables Trust 2018-3 A3
2.95% Due 8/22/2022
5,634.89 125.91 5,760.80
01/23/2022 Interest 46647PAU0 2,500,000.00 JP Morgan Chase & Co Callable Note 1X 7/23/2023
3.797% Due 7/23/2024
0.00 47,462.50 47,462.50
01/25/2022 Interest 808513AT2 2,000,000.00 Charles Schwab Corp Callable Note Cont 12/25/2022
2.65% Due 1/25/2023
0.00 26,500.00 26,500.00
01/25/2022 Paydown 09690AAC7 710,000.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due 12/26/2024
0.00 195.25 195.25
01/25/2022 Paydown 3137BFE98 2,000,000.00 FHLMC K041 A2
3.171% Due 10/25/2024
0.00 5,285.00 5,285.00
01/26/2022 Interest 3133EKWV4 2,500,000.00 FFCB Note
1.85% Due 7/26/2024
0.00 23,125.00 23,125.00
01/26/2022 Maturity 459058FY4 2,000,000.00 Intl. Bank Recon & Development Note
2% Due 1/26/2022
2,000,000.00 20,000.00 2,020,000.00
01/31/2022 Interest 912828V80 5,000,000.00 US Treasury Note
2.25% Due 1/31/2024
0.00 56,250.00 56,250.00
01/31/2022 Interest 91282CBH3 4,000,000.00 US Treasury Note
0.375% Due 1/31/2026
0.00 7,500.00 7,500.00
01/31/2022 Interest 9128282N9 2,000,000.00 US Treasury Note
2.125% Due 7/31/2024
0.00 21,250.00 21,250.00
JAN 2022 2,142,479.74 373,134.47 2,515,614.21
02/05/2022 Interest 3135G0V34 2,000,000.00 FNMA Note
2.5% Due 2/5/2024
0.00 25,000.00 25,000.00
02/11/2022 Interest 06406RAJ6 1,200,000.00 Bank of NY Mellon Corp Note
3.45% Due 8/11/2023
0.00 20,700.00 20,700.00
02/12/2022 Interest 3137EAEP0 4,200,000.00 FHLMC Note
1.5% Due 2/12/2025
0.00 31,500.00 31,500.00
02/13/2022 Interest 06051GHY8 1,250,000.00 Bank of America Corp Callable Note Cont 2/13/2025
2.015% Due 2/13/2026
0.00 12,593.75 12,593.75
02/14/2022 Interest 3133EKZK5 4,000,000.00 FFCB Note
1.6% Due 8/14/2023
0.00 32,000.00 32,000.00
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 39 236
Cash Flow Report
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
02/15/2022 Paydown 47788EAC2 61,991.45 John Deere Owner Trust 2018-B A3
3.08% Due 11/15/2022
4,374.08 114.74 4,488.82
02/15/2022 Paydown 89231PAD0 407,621.51 Toyota Auto Receivables Trust 2018-D A3
3.18% Due 3/15/2023
22,464.86 843.12 23,307.98
02/15/2022 Paydown 44891VAC5 1,420,000.00 Hyundai Auto Lease Trust 2021-B A3
0.33% Due 6/17/2024
0.00 390.50 390.50
02/15/2022 Paydown 47787NAC3 515,000.00 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
0.00 218.88 218.88
02/15/2022 Paydown 47789QAC4 965,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
0.00 418.17 418.17
02/15/2022 Paydown 58769KAD6 1,135,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
0.00 378.33 378.33
02/15/2022 Paydown 89237VAB5 1,025,000.00 Toyota Auto Receivables Trust 2020-C A3
0.44% Due 10/15/2024
29,976.04 364.85 30,340.89
02/15/2022 Paydown 44933LAC7 725,000.00 Hyundai Auto Receivables Trust 2021-A A3
0.38% Due 9/15/2025
0.00 229.58 229.58
02/15/2022 Paydown 44934KAC8 2,065,000.00 Hyundai Auto Receivables Trust 2021-B A3
0.38% Due 1/15/2026
0.00 653.92 653.92
02/15/2022 Paydown 65479JAD5 1,311,925.08 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
37,507.99 1,870.06 39,378.05
02/15/2022 Paydown 47788UAC6 800,000.00 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
0.00 240.00 240.00
02/15/2022 Paydown 65479GAD1 232,614.05 Nissan Auto Receivables Trust 2018-B A3
3.06% Due 3/15/2023
38,775.98 98.88 38,874.86
02/18/2022 Paydown 43813KAC6 1,120,000.00 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
0.00 345.33 345.33
02/20/2022 Paydown 89239CAC3 1,090,000.00 Toyota Lease Owner Trust 2021-B A3
0.42% Due 10/21/2024
0.00 381.50 381.50
02/21/2022 Paydown 43815HAC1 68,037.50 Honda Auto Receivables Trust 2018-3 A3
2.95% Due 8/22/2022
5,648.75 112.05 5,760.80
02/25/2022 Interest 3135G05X7 2,755,000.00 FNMA Note
0.375% Due 8/25/2025
0.00 5,165.63 5,165.63
02/25/2022 Paydown 3137BFE98 2,000,000.00 FHLMC K041 A2
3.171% Due 10/25/2024
0.00 5,285.00 5,285.00
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 40 237
Cash Flow Report
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
02/25/2022 Paydown 09690AAC7 710,000.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due 12/26/2024
0.00 195.25 195.25
02/28/2022 Interest 912828L24 2,000,000.00 US Treasury Note
1.875% Due 8/31/2022
0.00 18,750.00 18,750.00
02/28/2022 Interest 91282CBQ3 2,500,000.00 US Treasury Note
0.5% Due 2/28/2026
0.00 6,250.00 6,250.00
02/28/2022 Interest 912828ZC7 3,500,000.00 US Treasury Note
1.125% Due 2/28/2025
0.00 19,687.50 19,687.50
02/28/2022 Interest 91282CCW9 2,000,000.00 US Treasury Note
0.75% Due 8/31/2026
0.00 7,500.00 7,500.00
FEB 2022 138,747.70 191,287.04 330,034.74
03/05/2022 Interest 06051GHF9 2,400,000.00 Bank of America Corp Callable Note 1X 3/5/2023
3.55% Due 3/5/2024
0.00 42,600.00 42,600.00
03/08/2022 Interest 313383YJ4 5,000,000.00 FHLB Note
3.375% Due 9/8/2023
0.00 84,375.00 84,375.00
03/11/2022 Interest 89114QCB2 2,300,000.00 Toronto Dominion Bank Note
3.25% Due 3/11/2024
0.00 37,375.00 37,375.00
03/11/2022 Interest 89114QCK2 1,000,000.00 Toronto Dominion Bank Note
0.75% Due 9/11/2025
0.00 3,750.00 3,750.00
03/11/2022 Maturity 313378CR0 2,000,000.00 FHLB Note
2.25% Due 3/11/2022
2,000,000.00 22,500.00 2,022,500.00
03/13/2022 Interest 46647PBH8 1,000,000.00 JP Morgan Chase & Co Callable Note Mthly
3/13/2025
2.005% Due 3/13/2026
0.00 10,025.00 10,025.00
03/13/2022 Interest 3130A2UW4 2,000,000.00 FHLB Note
2.875% Due 9/13/2024
0.00 28,750.00 28,750.00
03/14/2022 Interest 4581X0CZ9 2,500,000.00 Inter-American Dev Bank Note
1.75% Due 9/14/2022
0.00 21,875.00 21,875.00
03/14/2022 Interest 58989V2D5 1,285,000.00 Met Tower Global Funding Note
1.25% Due 9/14/2026
0.00 8,031.25 8,031.25
03/15/2022 Interest 06368FAC3 2,500,000.00 Bank of Montreal Note
1.25% Due 9/15/2026
0.00 15,625.00 15,625.00
03/15/2022 Interest 00440EAS6 2,500,000.00 Chubb INA Holdings Inc Note
3.15% Due 3/15/2025
0.00 39,375.00 39,375.00
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 41 238
Cash Flow Report
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
03/15/2022 Interest 084670BR8 1,865,000.00 Berkshire Hathaway Callable Note Cont 1/15/2023
2.75% Due 3/15/2023
0.00 25,643.75 25,643.75
03/15/2022 Paydown 44933LAC7 725,000.00 Hyundai Auto Receivables Trust 2021-A A3
0.38% Due 9/15/2025
0.00 229.58 229.58
03/15/2022 Paydown 44934KAC8 2,065,000.00 Hyundai Auto Receivables Trust 2021-B A3
0.38% Due 1/15/2026
0.00 653.92 653.92
03/15/2022 Paydown 47787NAC3 515,000.00 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
22,294.98 218.88 22,513.86
03/15/2022 Paydown 47788UAC6 800,000.00 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
0.00 240.00 240.00
03/15/2022 Paydown 47789QAC4 965,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
0.00 418.17 418.17
03/15/2022 Paydown 65479JAD5 1,311,925.08 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
37,592.38 1,809.74 39,402.12
03/15/2022 Paydown 44891VAC5 1,420,000.00 Hyundai Auto Lease Trust 2021-B A3
0.33% Due 6/17/2024
0.00 390.50 390.50
03/15/2022 Paydown 89231PAD0 407,621.51 Toyota Auto Receivables Trust 2018-D A3
3.18% Due 3/15/2023
22,504.69 783.59 23,288.28
03/15/2022 Paydown 89237VAB5 1,025,000.00 Toyota Auto Receivables Trust 2020-C A3
0.44% Due 10/15/2024
29,987.04 353.85 30,340.89
03/15/2022 Paydown 47788EAC2 61,991.45 John Deere Owner Trust 2018-B A3
3.08% Due 11/15/2022
4,395.23 103.51 4,498.74
03/15/2022 Paydown 58769KAD6 1,135,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
0.00 378.33 378.33
03/17/2022 Interest 931142ER0 585,000.00 Wal-Mart Stores Callable Note Cont 08/17/2026
1.05% Due 9/17/2026
0.00 3,071.25 3,071.25
03/18/2022 Paydown 43813KAC6 1,120,000.00 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
53,169.08 345.33 53,514.41
03/20/2022 Paydown 89239CAC3 1,090,000.00 Toyota Lease Owner Trust 2021-B A3
0.42% Due 10/21/2024
0.00 381.50 381.50
03/21/2022 Paydown 43815HAC1 68,037.50 Honda Auto Receivables Trust 2018-3 A3
2.95% Due 8/22/2022
5,662.63 98.17 5,760.80
03/23/2022 Interest 3137EAEX3 2,655,000.00 FHLMC Note
0.375% Due 9/23/2025
0.00 4,978.13 4,978.13
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 42 239
Cash Flow Report
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
03/23/2022 Interest 4581X0DZ8 3,680,000.00 Inter-American Dev Bank Note
0.5% Due 9/23/2024
0.00 9,200.00 9,200.00
03/25/2022 Paydown 3137BFE98 2,000,000.00 FHLMC K041 A2
3.171% Due 10/25/2024
0.00 5,285.00 5,285.00
03/25/2022 Paydown 09690AAC7 710,000.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due 12/26/2024
0.00 195.25 195.25
03/31/2022 Interest 9128284D9 3,750,000.00 US Treasury Note
2.5% Due 3/31/2023
0.00 46,875.00 46,875.00
03/31/2022 Interest 912828YH7 3,500,000.00 US Treasury Note
1.5% Due 9/30/2024
0.00 26,250.00 26,250.00
03/31/2022 Interest 91282CAM3 2,500,000.00 US Treasury Note
0.25% Due 9/30/2025
0.00 3,125.00 3,125.00
03/31/2022 Interest 91282CBT7 5,000,000.00 US Treasury Note
0.75% Due 3/31/2026
0.00 18,750.00 18,750.00
03/31/2022 Interest 912828L57 3,750,000.00 US Treasury Note
1.75% Due 9/30/2022
0.00 32,812.50 32,812.50
03/31/2022 Maturity 912828J76 3,000,000.00 US Treasury Note
1.75% Due 3/31/2022
3,000,000.00 26,250.00 3,026,250.00
MAR 2022 5,175,606.03 523,122.20 5,698,728.23
04/05/2022 Maturity 3135G0T45 3,250,000.00 FNMA Note
1.875% Due 4/5/2022
3,250,000.00 30,468.75 3,280,468.75
04/15/2022 Interest 3135G0W66 2,000,000.00 FNMA Note
1.625% Due 10/15/2024
0.00 16,250.00 16,250.00
04/15/2022 Paydown 44891VAC5 1,420,000.00 Hyundai Auto Lease Trust 2021-B A3
0.33% Due 6/17/2024
0.00 390.50 390.50
04/15/2022 Paydown 44933LAC7 725,000.00 Hyundai Auto Receivables Trust 2021-A A3
0.38% Due 9/15/2025
0.00 229.58 229.58
04/15/2022 Paydown 44934KAC8 2,065,000.00 Hyundai Auto Receivables Trust 2021-B A3
0.38% Due 1/15/2026
0.00 653.92 653.92
04/15/2022 Paydown 47787NAC3 515,000.00 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
22,303.72 209.40 22,513.12
04/15/2022 Paydown 47789QAC4 965,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
0.00 418.17 418.17
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 43 240
Cash Flow Report
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
04/15/2022 Paydown 65479JAD5 1,311,925.08 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
37,676.96 1,749.28 39,426.24
04/15/2022 Paydown 89237VAB5 1,025,000.00 Toyota Auto Receivables Trust 2020-C A3
0.44% Due 10/15/2024
29,998.03 342.86 30,340.89
04/15/2022 Paydown 47788UAC6 800,000.00 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
0.00 240.00 240.00
04/15/2022 Paydown 47788EAC2 61,991.45 John Deere Owner Trust 2018-B A3
3.08% Due 11/15/2022
4,416.47 92.23 4,508.70
04/15/2022 Paydown 89231PAD0 407,621.51 Toyota Auto Receivables Trust 2018-D A3
3.18% Due 3/15/2023
22,544.60 723.95 23,268.55
04/15/2022 Paydown 58769KAD6 1,135,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
0.00 378.33 378.33
04/18/2022 Paydown 43813KAC6 1,120,000.00 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
53,185.47 328.94 53,514.41
04/20/2022 Interest 4581X0DV7 4,615,000.00 Inter-American Dev Bank Note
0.875% Due 4/20/2026
0.00 20,190.63 20,190.63
04/20/2022 Paydown 89239CAC3 1,090,000.00 Toyota Lease Owner Trust 2021-B A3
0.42% Due 10/21/2024
0.00 381.50 381.50
04/21/2022 Paydown 43815HAC1 68,037.50 Honda Auto Receivables Trust 2018-3 A3
2.95% Due 8/22/2022
5,676.55 84.25 5,760.80
04/22/2022 Interest 459058JB0 2,260,000.00 Intl. Bank Recon & Development Note
0.625% Due 4/22/2025
0.00 7,062.50 7,062.50
04/22/2022 Interest 3135G03U5 1,825,000.00 FNMA Note
0.625% Due 4/22/2025
0.00 5,703.13 5,703.13
04/25/2022 Paydown 3137BFE98 2,000,000.00 FHLMC K041 A2
3.171% Due 10/25/2024
0.00 5,285.00 5,285.00
04/25/2022 Paydown 09690AAC7 710,000.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due 12/26/2024
0.00 195.25 195.25
04/28/2022 Interest 459058JL8 6,000,000.00 Intl. Bank Recon & Development Note
0.5% Due 10/28/2025
0.00 15,000.00 15,000.00
04/30/2022 Interest 912828M49 1,000,000.00 US Treasury Note
1.875% Due 10/31/2022
0.00 9,375.00 9,375.00
04/30/2022 Interest 912828ZL7 4,000,000.00 US Treasury Note
0.375% Due 4/30/2025
0.00 7,500.00 7,500.00
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 44 241
Cash Flow Report
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
04/30/2022 Maturity 912828WZ9 1,750,000.00 US Treasury Note
1.75% Due 4/30/2022
1,750,000.00 15,312.50 1,765,312.50
APR 2022 5,175,801.80 138,565.67 5,314,367.47
05/07/2022 Interest 3135G06G3 2,860,000.00 FNMA Note
0.5% Due 11/7/2025
0.00 7,150.00 7,150.00
05/11/2022 Interest 037833CU2 3,000,000.00 Apple Inc Callable Note Cont 3/11/2024
2.85% Due 5/11/2024
0.00 42,750.00 42,750.00
05/12/2022 Interest 023135BW5 1,865,000.00 Amazon.com Inc Note
0.45% Due 5/12/2024
0.00 4,196.25 4,196.25
05/13/2022 Interest 808513BR5 1,370,000.00 Charles Schwab Corp Callable Note Cont 4/13/2026
1.15% Due 5/13/2026
0.00 7,877.50 7,877.50
05/15/2022 Interest 912828WJ5 1,750,000.00 US Treasury Note
2.5% Due 5/15/2024
0.00 21,875.00 21,875.00
05/15/2022 Interest 91324PEC2 605,000.00 United Health Group Inc Callable Note Cont
4/15/2026
1.15% Due 5/15/2026
0.00 3,478.75 3,478.75
05/15/2022 Paydown 44891VAC5 1,420,000.00 Hyundai Auto Lease Trust 2021-B A3
0.33% Due 6/17/2024
0.00 390.50 390.50
05/15/2022 Paydown 89231PAD0 407,621.51 Toyota Auto Receivables Trust 2018-D A3
3.18% Due 3/15/2023
22,584.58 664.21 23,248.79
05/15/2022 Paydown 89237VAB5 1,025,000.00 Toyota Auto Receivables Trust 2020-C A3
0.44% Due 10/15/2024
30,009.03 331.86 30,340.89
05/15/2022 Paydown 47787NAC3 515,000.00 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
22,312.45 199.92 22,512.37
05/15/2022 Paydown 47788UAC6 800,000.00 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
0.00 240.00 240.00
05/15/2022 Paydown 47789QAC4 965,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
0.00 418.17 418.17
05/15/2022 Paydown 58769KAD6 1,135,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
0.00 378.33 378.33
05/15/2022 Paydown 44934KAC8 2,065,000.00 Hyundai Auto Receivables Trust 2021-B A3
0.38% Due 1/15/2026
0.00 653.92 653.92
05/15/2022 Paydown 47788EAC2 61,991.45 John Deere Owner Trust 2018-B A3
3.08% Due 11/15/2022
4,437.81 80.90 4,518.71
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 45 242
Cash Flow Report
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
05/15/2022 Paydown 65479JAD5 1,311,925.08 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
37,761.73 1,688.68 39,450.41
05/15/2022 Paydown 44933LAC7 725,000.00 Hyundai Auto Receivables Trust 2021-A A3
0.38% Due 9/15/2025
0.00 229.58 229.58
05/18/2022 Interest 46625HRL6 500,000.00 JP Morgan Chase Callable Note Cont 3/18/2023
2.7% Due 5/18/2023
0.00 6,750.00 6,750.00
05/18/2022 Interest 58933YAF2 740,000.00 Merck & Co Note
2.8% Due 5/18/2023
0.00 10,360.00 10,360.00
05/18/2022 Paydown 43813KAC6 1,120,000.00 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
53,201.87 312.54 53,514.41
05/20/2022 Paydown 89239CAC3 1,090,000.00 Toyota Lease Owner Trust 2021-B A3
0.42% Due 10/21/2024
0.00 381.50 381.50
05/21/2022 Paydown 43815HAC1 68,037.50 Honda Auto Receivables Trust 2018-3 A3
2.95% Due 8/22/2022
5,690.51 70.29 5,760.80
05/25/2022 Paydown 3137BFE98 2,000,000.00 FHLMC K041 A2
3.171% Due 10/25/2024
0.00 5,285.00 5,285.00
05/25/2022 Paydown 09690AAC7 710,000.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due 12/26/2024
0.00 195.25 195.25
05/30/2022 Interest 61747YEA9 3,040,000.00 Morgan Stanley Callable Note Cont 5/30/2024
0.79% Due 5/30/2025
0.00 12,008.00 12,008.00
05/31/2022 Interest 912828U57 5,000,000.00 US Treasury Note
2.125% Due 11/30/2023
0.00 53,125.00 53,125.00
05/31/2022 Interest 9128283J7 3,000,000.00 US Treasury Note
2.125% Due 11/30/2024
0.00 31,875.00 31,875.00
05/31/2022 Interest 91282CCF6 2,000,000.00 US Treasury Note
0.75% Due 5/31/2026
0.00 7,500.00 7,500.00
05/31/2022 Interest 912828R69 1,500,000.00 US Treasury Note
1.625% Due 5/31/2023
0.00 12,187.50 12,187.50
05/31/2022 Maturity 912828XR6 1,500,000.00 US Treasury Note
1.75% Due 5/31/2022
1,500,000.00 13,125.00 1,513,125.00
MAY 2022 1,675,997.98 245,778.65 1,921,776.63
06/01/2022 Interest 438516CB0 2,500,000.00 Honeywell Intl Callable Note Cont 5/1/2025
1.35% Due 6/1/2025
0.00 16,875.00 16,875.00
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 46 243
Cash Flow Report
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
06/08/2022 Interest 3130A0F70 5,000,000.00 FHLB Note
3.375% Due 12/8/2023
0.00 84,375.00 84,375.00
06/08/2022 Interest 69353RFL7 2,210,000.00 PNC Bank Callable Note Cont 5/9/2023
3.5% Due 6/8/2023
0.00 38,675.00 38,675.00
06/09/2022 Interest 313383QR5 1,500,000.00 FHLB Note
3.25% Due 6/9/2023
0.00 24,375.00 24,375.00
06/10/2022 Interest 78015K7H1 1,000,000.00 Royal Bank of Canada Note
1.15% Due 6/10/2025
0.00 5,750.00 5,750.00
06/14/2022 Interest 3130A1XJ2 3,795,000.00 FHLB Note
2.875% Due 6/14/2024
0.00 54,553.13 54,553.13
06/15/2022 Paydown 44891VAC5 1,420,000.00 Hyundai Auto Lease Trust 2021-B A3
0.33% Due 6/17/2024
0.00 390.50 390.50
06/15/2022 Paydown 47787NAC3 515,000.00 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
22,321.19 190.44 22,511.63
06/15/2022 Paydown 47789QAC4 965,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
0.00 418.17 418.17
06/15/2022 Paydown 58769KAD6 1,135,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
0.00 378.33 378.33
06/15/2022 Paydown 89237VAB5 1,025,000.00 Toyota Auto Receivables Trust 2020-C A3
0.44% Due 10/15/2024
30,020.03 320.86 30,340.89
06/15/2022 Paydown 47788EAC2 61,991.45 John Deere Owner Trust 2018-B A3
3.08% Due 11/15/2022
4,459.26 69.51 4,528.77
06/15/2022 Paydown 89231PAD0 407,621.51 Toyota Auto Receivables Trust 2018-D A3
3.18% Due 3/15/2023
22,624.63 604.36 23,228.99
06/15/2022 Paydown 44933LAC7 725,000.00 Hyundai Auto Receivables Trust 2021-A A3
0.38% Due 9/15/2025
0.00 229.58 229.58
06/15/2022 Paydown 44934KAC8 2,065,000.00 Hyundai Auto Receivables Trust 2021-B A3
0.38% Due 1/15/2026
0.00 653.92 653.92
06/15/2022 Paydown 65479JAD5 1,311,925.08 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
37,846.69 1,627.95 39,474.64
06/15/2022 Paydown 47788UAC6 800,000.00 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
0.00 240.00 240.00
06/17/2022 Interest 3135G04Z3 3,435,000.00 FNMA Note
0.5% Due 6/17/2025
0.00 8,587.50 8,587.50
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 47 244
Cash Flow Report
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
06/18/2022 Interest 89236TJK2 2,485,000.00 Toyota Motor Credit Corp Note
1.125% Due 6/18/2026
0.00 13,978.13 13,978.13
06/18/2022 Paydown 43813KAC6 1,120,000.00 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
53,218.27 296.14 53,514.41
06/19/2022 Interest 3137EAEN5 2,000,000.00 FHLMC Note
2.75% Due 6/19/2023
0.00 27,500.00 27,500.00
06/20/2022 Paydown 89239CAC3 1,090,000.00 Toyota Lease Owner Trust 2021-B A3
0.42% Due 10/21/2024
0.00 381.50 381.50
06/21/2022 Paydown 43815HAC1 68,037.50 Honda Auto Receivables Trust 2018-3 A3
2.95% Due 8/22/2022
5,704.50 56.30 5,760.80
06/23/2022 Maturity 06417MQL2 2,500,000.00 Bank of Nova Scotia Houston Yankee CD
0.2% Due 6/23/2022
2,500,000.00 5,069.44 2,505,069.44
06/24/2022 Interest 166764AH3 1,000,000.00 Chevron Corp Callable Note Cont 3/24/2023
3.191% Due 6/24/2023
0.00 15,955.00 15,955.00
06/24/2022 Interest 24422ETT6 2,000,000.00 John Deere Capital Corp Note
2.65% Due 6/24/2024
0.00 26,500.00 26,500.00
06/25/2022 Paydown 09690AAC7 710,000.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due 12/26/2024
0.00 195.25 195.25
06/25/2022 Paydown 3137BFE98 2,000,000.00 FHLMC K041 A2
3.171% Due 10/25/2024
0.00 5,285.00 5,285.00
06/26/2022 Interest 931142EK5 1,380,000.00 Wal-Mart Stores Callable Note Cont 5/26/2023
3.4% Due 6/26/2023
0.00 23,460.00 23,460.00
06/27/2022 Interest 02665WCZ2 1,500,000.00 American Honda Finance Note
2.4% Due 6/27/2024
0.00 18,000.00 18,000.00
06/30/2022 Interest 91282CBC4 1,000,000.00 US Treasury Note
0.375% Due 12/31/2025
0.00 1,875.00 1,875.00
06/30/2022 Maturity 912828XW5 3,000,000.00 US Treasury Note
1.75% Due 6/30/2022
3,000,000.00 26,250.00 3,026,250.00
JUN 2022 5,676,194.57 403,116.01 6,079,310.58
07/07/2022 Interest 3135G0X24 4,200,000.00 FNMA Note
1.625% Due 1/7/2025
0.00 34,125.00 34,125.00
07/08/2022 Interest 02665WDL2 1,000,000.00 American Honda Finance Note
1.2% Due 7/8/2025
0.00 6,000.00 6,000.00
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 48 245
Cash Flow Report
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
07/10/2022 Interest 3135G05G4 2,350,000.00 FNMA Note
0.25% Due 7/10/2023
0.00 2,937.50 2,937.50
07/14/2022 Interest 02665WCJ8 1,000,000.00 American Honda Finance Note
3.45% Due 7/14/2023
0.00 17,250.00 17,250.00
07/15/2022 Interest 79466LAG9 465,000.00 Salesforce.com Inc Callable Note Cont 7/15/2022
0.625% Due 7/15/2024
0.00 1,453.13 1,453.13
07/15/2022 Interest 4581X0DN5 1,685,000.00 Inter-American Dev Bank Note
0.625% Due 7/15/2025
0.00 5,265.63 5,265.63
07/15/2022 Paydown 47787NAC3 515,000.00 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
22,329.94 180.95 22,510.89
07/15/2022 Paydown 47788UAC6 800,000.00 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
0.00 240.00 240.00
07/15/2022 Paydown 47789QAC4 965,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
0.00 418.17 418.17
07/15/2022 Paydown 44933LAC7 725,000.00 Hyundai Auto Receivables Trust 2021-A A3
0.38% Due 9/15/2025
0.00 229.58 229.58
07/15/2022 Paydown 44934KAC8 2,065,000.00 Hyundai Auto Receivables Trust 2021-B A3
0.38% Due 1/15/2026
0.00 653.92 653.92
07/15/2022 Paydown 65479JAD5 1,311,925.08 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
37,931.85 1,567.08 39,498.93
07/15/2022 Paydown 44891VAC5 1,420,000.00 Hyundai Auto Lease Trust 2021-B A3
0.33% Due 6/17/2024
0.00 390.50 390.50
07/15/2022 Paydown 89231PAD0 407,621.51 Toyota Auto Receivables Trust 2018-D A3
3.18% Due 3/15/2023
22,664.76 544.40 23,209.16
07/15/2022 Paydown 89237VAB5 1,025,000.00 Toyota Auto Receivables Trust 2020-C A3
0.44% Due 10/15/2024
30,031.04 309.85 30,340.89
07/15/2022 Paydown 47788EAC2 61,991.45 John Deere Owner Trust 2018-B A3
3.08% Due 11/15/2022
4,480.82 58.06 4,538.88
07/15/2022 Paydown 58769KAD6 1,135,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
0.00 378.33 378.33
07/16/2022 Interest 78013XZU5 2,500,000.00 Royal Bank of Canada Note
2.55% Due 7/16/2024
0.00 31,875.00 31,875.00
07/18/2022 Paydown 43813KAC6 1,120,000.00 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
53,234.68 279.73 53,514.41
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 49 246
Cash Flow Report
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
07/19/2022 Interest 3135G0T94 2,500,000.00 FNMA Note
2.375% Due 1/19/2023
0.00 29,687.50 29,687.50
07/20/2022 Paydown 89239CAC3 1,090,000.00 Toyota Lease Owner Trust 2021-B A3
0.42% Due 10/21/2024
0.00 381.50 381.50
07/21/2022 Interest 3137EAEU9 1,745,000.00 FHLMC Note
0.375% Due 7/21/2025
0.00 3,271.88 3,271.88
07/21/2022 Interest 90331HPL1 2,610,000.00 US Bank NA Callable Note Cont 12/21/2024
2.05% Due 1/21/2025
0.00 26,752.50 26,752.50
07/21/2022 Paydown 43815HAC1 68,037.50 Honda Auto Receivables Trust 2018-3 A3
2.95% Due 8/22/2022
5,718.52 42.28 5,760.80
07/23/2022 Interest 46647PAU0 2,500,000.00 JP Morgan Chase & Co Callable Note 1X 7/23/2023
3.797% Due 7/23/2024
0.00 47,462.50 47,462.50
07/25/2022 Interest 808513AT2 2,000,000.00 Charles Schwab Corp Callable Note Cont 12/25/2022
2.65% Due 1/25/2023
0.00 26,500.00 26,500.00
07/25/2022 Paydown 09690AAC7 710,000.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due 12/26/2024
0.00 195.25 195.25
07/25/2022 Paydown 3137BFE98 2,000,000.00 FHLMC K041 A2
3.171% Due 10/25/2024
0.00 5,285.00 5,285.00
07/26/2022 Interest 3133EKWV4 2,500,000.00 FFCB Note
1.85% Due 7/26/2024
0.00 23,125.00 23,125.00
07/31/2022 Interest 912828V80 5,000,000.00 US Treasury Note
2.25% Due 1/31/2024
0.00 56,250.00 56,250.00
07/31/2022 Interest 91282CBH3 4,000,000.00 US Treasury Note
0.375% Due 1/31/2026
0.00 7,500.00 7,500.00
07/31/2022 Interest 9128282N9 2,000,000.00 US Treasury Note
2.125% Due 7/31/2024
0.00 21,250.00 21,250.00
JUL 2022 176,391.61 351,860.24 528,251.85
08/05/2022 Interest 3135G0V34 2,000,000.00 FNMA Note
2.5% Due 2/5/2024
0.00 25,000.00 25,000.00
08/11/2022 Interest 06406RAJ6 1,200,000.00 Bank of NY Mellon Corp Note
3.45% Due 8/11/2023
0.00 20,700.00 20,700.00
08/12/2022 Interest 3137EAEP0 4,200,000.00 FHLMC Note
1.5% Due 2/12/2025
0.00 31,500.00 31,500.00
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 50 247
Cash Flow Report
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
08/13/2022 Interest 06051GHY8 1,250,000.00 Bank of America Corp Callable Note Cont 2/13/2025
2.015% Due 2/13/2026
0.00 12,593.75 12,593.75
08/14/2022 Interest 3133EKZK5 4,000,000.00 FFCB Note
1.6% Due 8/14/2023
0.00 32,000.00 32,000.00
08/15/2022 Paydown 47788UAC6 800,000.00 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
0.00 240.00 240.00
08/15/2022 Paydown 44934KAC8 2,065,000.00 Hyundai Auto Receivables Trust 2021-B A3
0.38% Due 1/15/2026
0.00 653.92 653.92
08/15/2022 Paydown 47787NAC3 515,000.00 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
22,338.68 171.46 22,510.14
08/15/2022 Paydown 47789QAC4 965,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
0.00 418.17 418.17
08/15/2022 Paydown 65479JAD5 1,311,925.08 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
38,017.20 1,506.07 39,523.27
08/15/2022 Paydown 89237VAB5 1,025,000.00 Toyota Auto Receivables Trust 2020-C A3
0.44% Due 10/15/2024
30,042.05 298.84 30,340.89
08/15/2022 Paydown 58769KAD6 1,135,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
0.00 378.33 378.33
08/15/2022 Paydown 47788EAC2 61,991.45 John Deere Owner Trust 2018-B A3
3.08% Due 11/15/2022
4,502.47 46.56 4,549.03
08/15/2022 Paydown 89231PAD0 407,621.51 Toyota Auto Receivables Trust 2018-D A3
3.18% Due 3/15/2023
22,704.95 484.34 23,189.29
08/15/2022 Paydown 44891VAC5 1,420,000.00 Hyundai Auto Lease Trust 2021-B A3
0.33% Due 6/17/2024
0.00 390.50 390.50
08/15/2022 Paydown 44933LAC7 725,000.00 Hyundai Auto Receivables Trust 2021-A A3
0.38% Due 9/15/2025
0.00 229.58 229.58
08/18/2022 Paydown 43813KAC6 1,120,000.00 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
53,251.10 263.31 53,514.41
08/20/2022 Paydown 89239CAC3 1,090,000.00 Toyota Lease Owner Trust 2021-B A3
0.42% Due 10/21/2024
0.00 381.50 381.50
08/21/2022 Paydown 43815HAC1 68,037.50 Honda Auto Receivables Trust 2018-3 A3
2.95% Due 8/22/2022
5,732.58 28.22 5,760.80
08/22/2022 Paydown 43815HAC1 68,037.50 Honda Auto Receivables Trust 2018-3 A3
2.95% Due 8/22/2022
5,746.67 0.00 5,746.67
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 51 248
Cash Flow Report
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
08/25/2022 Interest 3135G05X7 2,755,000.00 FNMA Note
0.375% Due 8/25/2025
0.00 5,165.63 5,165.63
08/25/2022 Paydown 3137BFE98 2,000,000.00 FHLMC K041 A2
3.171% Due 10/25/2024
0.00 5,285.00 5,285.00
08/25/2022 Paydown 09690AAC7 710,000.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due 12/26/2024
0.00 195.25 195.25
08/31/2022 Interest 91282CBQ3 2,500,000.00 US Treasury Note
0.5% Due 2/28/2026
0.00 6,250.00 6,250.00
08/31/2022 Interest 912828ZC7 3,500,000.00 US Treasury Note
1.125% Due 2/28/2025
0.00 19,687.50 19,687.50
08/31/2022 Interest 91282CCW9 2,000,000.00 US Treasury Note
0.75% Due 8/31/2026
0.00 7,500.00 7,500.00
08/31/2022 Maturity 912828L24 2,000,000.00 US Treasury Note
1.875% Due 8/31/2022
2,000,000.00 18,750.00 2,018,750.00
AUG 2022 2,182,335.70 190,117.93 2,372,453.63
09/05/2022 Interest 06051GHF9 2,400,000.00 Bank of America Corp Callable Note 1X 3/5/2023
3.55% Due 3/5/2024
0.00 42,600.00 42,600.00
09/08/2022 Interest 313383YJ4 5,000,000.00 FHLB Note
3.375% Due 9/8/2023
0.00 84,375.00 84,375.00
09/11/2022 Interest 89114QCB2 2,300,000.00 Toronto Dominion Bank Note
3.25% Due 3/11/2024
0.00 37,375.00 37,375.00
09/11/2022 Interest 89114QCK2 1,000,000.00 Toronto Dominion Bank Note
0.75% Due 9/11/2025
0.00 3,750.00 3,750.00
09/13/2022 Interest 3130A2UW4 2,000,000.00 FHLB Note
2.875% Due 9/13/2024
0.00 28,750.00 28,750.00
09/13/2022 Interest 46647PBH8 1,000,000.00 JP Morgan Chase & Co Callable Note Mthly
3/13/2025
2.005% Due 3/13/2026
0.00 10,025.00 10,025.00
09/14/2022 Interest 58989V2D5 1,285,000.00 Met Tower Global Funding Note
1.25% Due 9/14/2026
0.00 8,031.25 8,031.25
09/14/2022 Maturity 4581X0CZ9 2,500,000.00 Inter-American Dev Bank Note
1.75% Due 9/14/2022
2,500,000.00 21,875.00 2,521,875.00
09/15/2022 Interest 00440EAS6 2,500,000.00 Chubb INA Holdings Inc Note
3.15% Due 3/15/2025
0.00 39,375.00 39,375.00
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 52 249
Cash Flow Report
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
09/15/2022 Interest 084670BR8 1,865,000.00 Berkshire Hathaway Callable Note Cont 1/15/2023
2.75% Due 3/15/2023
0.00 25,643.75 25,643.75
09/15/2022 Interest 06368FAC3 2,500,000.00 Bank of Montreal Note
1.25% Due 9/15/2026
0.00 15,625.00 15,625.00
09/15/2022 Paydown 44933LAC7 725,000.00 Hyundai Auto Receivables Trust 2021-A A3
0.38% Due 9/15/2025
0.00 229.58 229.58
09/15/2022 Paydown 47788EAC2 61,991.45 John Deere Owner Trust 2018-B A3
3.08% Due 11/15/2022
4,524.23 35.01 4,559.24
09/15/2022 Paydown 44891VAC5 1,420,000.00 Hyundai Auto Lease Trust 2021-B A3
0.33% Due 6/17/2024
0.00 390.50 390.50
09/15/2022 Paydown 44934KAC8 2,065,000.00 Hyundai Auto Receivables Trust 2021-B A3
0.38% Due 1/15/2026
0.00 653.92 653.92
09/15/2022 Paydown 65479JAD5 1,311,925.08 Nissan Auto Receivables Owner 2019-C A3
1.93% Due 7/15/2024
38,102.74 1,444.92 39,547.66
09/15/2022 Paydown 89231PAD0 407,621.51 Toyota Auto Receivables Trust 2018-D A3
3.18% Due 3/15/2023
22,745.21 424.17 23,169.38
09/15/2022 Paydown 89237VAB5 1,025,000.00 Toyota Auto Receivables Trust 2020-C A3
0.44% Due 10/15/2024
30,053.07 287.82 30,340.89
09/15/2022 Paydown 47787NAC3 515,000.00 John Deere Owner Trust 2020-B A3
0.51% Due 11/15/2024
22,347.43 161.97 22,509.40
09/15/2022 Paydown 47788UAC6 800,000.00 John Deere Owner Trust 2021-A A3
0.36% Due 9/15/2025
0.00 240.00 240.00
09/15/2022 Paydown 47789QAC4 965,000.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
0.00 418.17 418.17
09/15/2022 Paydown 58769KAD6 1,135,000.00 Mercedes-Benz Auto Lease Trust 2021-B A3
0.4% Due 11/15/2024
0.00 378.33 378.33
09/17/2022 Interest 931142ER0 585,000.00 Wal-Mart Stores Callable Note Cont 08/17/2026
1.05% Due 9/17/2026
0.00 3,071.25 3,071.25
09/18/2022 Paydown 43813KAC6 1,120,000.00 Honda Auto Receivables Trust 2020-3 A3
0.37% Due 10/18/2024
53,267.52 246.89 53,514.41
09/20/2022 Paydown 89239CAC3 1,090,000.00 Toyota Lease Owner Trust 2021-B A3
0.42% Due 10/21/2024
0.00 381.50 381.50
09/23/2022 Interest 3137EAEX3 2,655,000.00 FHLMC Note
0.375% Due 9/23/2025
0.00 4,978.13 4,978.13
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 53 250
Cash Flow Report
As of September 30, 2021
City of Dublin Consolidated
Account #10221
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount
09/23/2022 Interest 4581X0DZ8 3,680,000.00 Inter-American Dev Bank Note
0.5% Due 9/23/2024
0.00 9,200.00 9,200.00
09/25/2022 Paydown 3137BFE98 2,000,000.00 FHLMC K041 A2
3.171% Due 10/25/2024
0.00 5,285.00 5,285.00
09/25/2022 Paydown 09690AAC7 710,000.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due 12/26/2024
0.00 195.25 195.25
09/30/2022 Interest 91282CBT7 5,000,000.00 US Treasury Note
0.75% Due 3/31/2026
0.00 18,750.00 18,750.00
09/30/2022 Interest 9128284D9 3,750,000.00 US Treasury Note
2.5% Due 3/31/2023
0.00 46,875.00 46,875.00
09/30/2022 Interest 912828YH7 3,500,000.00 US Treasury Note
1.5% Due 9/30/2024
0.00 26,250.00 26,250.00
09/30/2022 Interest 91282CAM3 2,500,000.00 US Treasury Note
0.25% Due 9/30/2025
0.00 3,125.00 3,125.00
09/30/2022 Maturity 912828L57 3,750,000.00 US Treasury Note
1.75% Due 9/30/2022
3,750,000.00 32,812.50 3,782,812.50
SEP 2022 6,421,040.20 473,259.91 6,894,300.11
TOTAL 30,124,316.70 3,720,415.03 33,844,731.73
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 54 251
Important DisclosuresCity of Dublin Consolidated
Account #10221
Chandler Asset Management, Inc. ;͞Chandler͟Ϳis an SEC registered investment adviser. For additional information about our firm, please see our current disclosures (Form ADV). To
obtain a copy of our current disclosures, you may contact your client service representative by calling the number on the front of this statement or you may visit our website at
www.chandlerasset.com.
Information contained in this monthly statement is confidential and is provided for informational purposes only and should not be construed as specific investment or legal advice. The
information contained herein was obtained from sources believed to be reliable as of the date of this statement, but may become outdated or superseded at any time without
notice.
Custody: Your qualified custodian bank maintains control of all assets reflected in this statement and we urge you to compare this statement to the one you receive from your qualified
custodian. Chandler does not have any authority to withdraw or deposit funds from/to the custodian account.
Valuation: Prices are provided by IDC, an independent pricing source. In the event IDC does not provide a price or if the price provided is not reflective of fair market value, Chandler will
obtain pricing from an alternative approved third party pricing source in accordance with our written valuation policy and procedures. Our valuation procedures are also disclosed in
Item 5 of our Form ADV Part 2A.
Performance: Performance results are presented gross-of-advisory fees and represent the client ͛s Total Return. The deduction of advisory fees lowers performance results. These results
include the reinvestment of dividends and other earnings. Past performance may not be indicative of future results. Therefore, clients should not assume that future performance of any
specific investment or investment strategy will be profitable or equal to past performance levels. All investment strategies have the potential for profit or loss. Economic factors, market
conditions or changes in investment strategies, contributions or withdrawals may materially alter the performance and results of your portfolio.
Source ice Data Indices, LLC ("ICE"), used with permission. ICE PERMITS USE OF THE ICE INDICES AND RELATED DATA ON AN "AS IS" BASIS; ICE, ITS AFFILIATES AND THEIR RESPECTIVE
THIRD PARTY SUPPLIERS DISCLAIM ANY AND ALL WARRANTIES AND REPRESENTATIONS, EXPRESS AND/OR IMPLIED, INCLUDING ANY WARRANTIES OF MERCHANTABILITY OR FITNESS
FOR A PARTICULAR PURPOSE OR USE, INCLUDING THE INDICES, INDEX DATA AND ANY DATA INCLUDED IN, RELATED TO, OR DERIVED THEREFROM. NEITHER ICE DATA, ITS AFFILIATES OR
THEIR RESPECTIVE THIRD PARTY PROVIDERS GUARANTEE THE QUALITY, ADEQUACY, ACCURACY, TIMELINESS OR COMPLETENESS OF THE INDICES OR THE INDEX DATA OR ANY
COMPONENT THEREOF, AND THE INDICES AND INDEX DATA AND ALL COMPONENTS THEREOF ARE PROVIDED ON AN "AS IS" BASIS AND LICENSEE'S USE IS AT LICENSEE'S OWN RISK. ICE
DATA, ITS AFFILIATES AND THEIR RESPECTIVE THIRD PARTY DO NOT SPONSOR, ENDORSE, OR RECOMMEND CHANDLER, OR ANY OF ITS PRODUCTS OR SERVICES.
Index returns assume reinvestment of all distributions. Historical performance results for investment indexes generally do not reflect the deduction of transaction and/or custodial
charges or the deduction of an investment management fee, the incurrence of which would have the effect of decreasing historical performance results. It is not possible to invest
directly in an index.
Ratings: Ratings information have been provided by Moody͛s, S&P and Fitch through data feeds we believe to be reliable as of the date of this statement, however we cannot guarantee
its accuracy.
Security level ratings for U.S. Agency issued mortgage-backed securities ;͞MBS͟Ϳreflect the issuer rating because the securities themselves are not rated. The issuing U.S. Agency
guarantees the full and timely payment of both principal and interest and carries a AA+/Aaa/AAA by S&P, Moody ͛s and Fitch respectively.
Execution Time: 10/8/2021 1:38:54 PMChandler Asset Management - CONFIDENTIAL Page 55 252