HomeMy WebLinkAbout4.3 City Treasurer's Informational Report of Investments for the Quarter Ending December 31, 2021STAFF REPORT
CITY COUNCIL
Page 1 of 5
Agenda Item 4.3
DATE:February 15, 2022
TO:Honorable Mayor and City Councilmembers
FROM:Linda Smith, City Manager
SUBJECT:City Treasurer's Informational Report of Investments for the Quarter Ending December 31, 2021Preparedby:Chris Rhoades,Financial Analyst
EXECUTIVE SUMMARY:The City Council will receive an informational report of the City’s investments through the quarter ending December 31, 2021 including a monthly transaction ledger. The City’s investment portfolio for this period totaled $382,522,878 (market value) with an average market yield of 0.60%. 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 December 31, 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 $233,062,790 managed by Chandler Asset Management (Chandler), and $149,460,088 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.91% and 0.11% respectively.
113
Page 2 of 5
The total investment portfolio balance fluctuates throughout the year due to normal cash flow 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).Chandler believes economic growth is likely to moderate but remain above trend in 2022, as US fiscal support begins to wane and the Federal Reserve becomes less accommodative. Chandlerexpects that continued improvement in the labor market, particularly an increase in the participation rate, will help drive economic growth this year as the health situation improves. Consumer spending, the largest component of US GDP, should also remain solid, supported by healthy consumer balance sheets and an improving labor market, in Chandler’s view. Chandleranticipates inventory rebuilding will likely be a significant driver of US GDP growth in the second half of the year as well. Chandler’s outlook is predicated on an improving global health backdrop, though risks to the downside remain. Over the near term, Chandler believes the Omicron variant will hinder economic growth and expects financial market volatility will be elevated. Inflation readings continue to run hot, but Chandler believes inflation may be at or near a peak and pricing pressures are likely to abate as we move through the year.City of Dublin PortfolioThe City's aggregate portfolio has maintained a healthy balance of investment types with minimalchange from the prior quarter as shown below in Chart 1.
114
Page 3 of 5
Chart 1: Investments by TypeDecember 31, 2021 and September 30, 2021
The market value of the City's portfolio increased by $54,394,775 from the September 30, 2021quarter. A significant component of this increase from the prior quarter and, in turn, the increase over the prior year, is the receipt of the 2021 Lease Revenue Bond funds, exceeding $20 million. Outside the receipt of the bond funds, the quarterly change results from the normal fluctuations in the timing of incoming revenue, predominantly the receipt of property tax allocations, over $22 million, and sales tax revenue, and expenditures on Capital Projects as well as payments to Alameda County for Police and Fire Services. The City’s portfolio increased $55.4 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.60%(shown in Table 2) due to the factors discussed in the Economic Update Highlights. For detailed monthly transactions, see Attachment 2.
115
Page 4 of 5
Table 1: Portfolio Values and Yield to Maturity
Table 2: Quarterly Holdings (Market Value) by Type, and YTM, 5 Quarters
December 31, 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,189,403 50,364,764 50,395,433 50,395,433 50,395,433 33.7%13.3%0.22%0.22%
CAMP 59,605,094 43,129,270 99,038,042 99,038,042 99,038,042 66.3%26.1%0.05%0.05%
SUBTOTAL 109,794,497 93,494,034 149,433,475 149,433,475 149,433,475 100.00%39.35%0.11%0.11%
Accrued Interest 73,594 27,810 26,613
109,868,091 93,521,844 149,460,088
Managed by Chandler
ABS 8,651,697 13,665,558 14,798,561 14,798,588 14,715,444 6.3%3.9%0.60%0.80%
Agency 88,099,396 65,306,279 63,570,000 63,862,223 64,567,126 27.8%16.7%1.63%0.78%
CMO - 2,138,464 2,000,000 2,128,606 2,102,544 0.9%0.5%0.72%1.19%
Money Market 1,494,033 809,873 287,150 287,150 287,150 0.1%0.1%0.01%0.01%
Negotiable CD 2,500,588 5,000,000 5,000,099 4,996,560 2.2%1.3%0.23%0.34%
Supranational 9,291,429 22,656,506 22,740,000 22,701,331 22,424,573 9.7%6.0%0.96%1.01%
Corporate 49,090,006 57,831,563 55,155,000 55,606,179 56,130,717 24.2%14.5%1.93%1.13%
US Treasury 59,632,976 68,951,352 66,750,000 66,661,201 66,952,848 28.8%17.6%1.47%0.87%
SUBTOTAL 216,259,536 233,860,181 230,300,712 231,045,377 232,176,962 100.00%60.65%1.49%0.91%
Accrued Interest 996,234 746,077 885,828
217,255,770 234,606,258 233,062,790
TOTAL PORTFOLIO 327,123,861 328,128,102 379,734,186 380,478,852 382,522,878 100.00%0.60%
23,267,576 55,399,017
(4,131,027) 54,394,775
December 31, 2021
Change from Prior Year
Change from Prior Quarter
September 30, 2021
Holdings (Market Value)12/31/20 3/31/21 6/30/21 9/30/21 12/31/21
LAIF/CAMP 109,794,497 95,786,151 97,647,167 93,494,034 149,433,475
ABS 8,651,697 7,785,198 9,835,052 13,665,558 14,715,444
Agency 88,099,396 78,831,782 75,581,659 65,306,279 64,567,126
CMO - - - 2,138,464 2,102,544
Money Market 1,494,033 7,546,801 756,163 809,873 287,150
Negotiable CD - - 2,499,825 2,500,588 4,996,560
Supranational 9,291,429 14,391,293 19,043,767 22,656,506 22,424,573
Corporate 49,090,006 48,771,479 54,161,172 57,831,563 56,130,717
US Treasury 59,632,976 67,900,673 71,745,729 68,951,352 66,952,848
Accrued Interest 1,069,828 847,391 988,596 773,887 912,441
TOTAL 327,123,861 321,860,767 332,259,129 328,128,102 382,522,878
YIELD TO MATURITY 0.28%0.39%0.39%0.44%0.60%
116
Page 5 of 5
Funds Managed by the City The City participates in two local agency investment pools managed by government finance professionals and treasurers: the Local Agency Investment Fund (LAIF) and the California Asset Management Program (CAMP). The following table reflects the most recent quarterly yields.
Table 3: Quarterly Portfolio Yields, Recent 8Quarters
Market Yield LAIF CAMP Chandler
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%
12/31/21 0.22%0.05%0.91%
STRATEGIC PLAN INITIATIVE:Strategy 2, Objective D: 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 December 31, 20212) Transaction Ledger – October through December 2021
117
CHANDLER ASSET MANAGEMENT, INC. | 800.317.4747 | www.chandlerasset.com
INVESTMENT REPORT
Period Ending December 31, 2021
City of Dublin
Attachment 1
118
SECTION 1 Economic Update
SECTION 2 Account Profile
SECTION 3 Consolidated Information
SECTION 4 Portfolio Holdings
SECTION 5 Transactions
Table of Contents As of December 31, 2021
1
119
SECTION |Section 1 |Economic Update
2
120
Economic Update
We believe economic growth islikely to moderate but remain above-trend in 2022,as US fiscal support begins to wane, and
the Federal Reserve becomes less accommodative. We expect continued improvement in the labor market,particularly an
increase in the participation rate,will help drive economic growth this year as the health situation improves.Consumer
spending,the largest component of US GDP,should also remain solid,supported by healthy consumer balance sheets and
an improving labor market,in our view.We anticipate inventory rebuilding will likely be a significant driver of US GDP
growth in the second half of the year as well.Our outlook is predicated on an improving global health backdrop, though
risks to the downside remain.Over the near-term,we believe the omicron variant will hinder economic growth and we
expect financial market volatility will be elevated. Inflation readings continue to run hot, but we believe inflation may be at
or near a peak and pricing pressures are likely to abate as we move through the year.
The Federal Open Market Committee (FOMC)kept the fed funds target rate unchanged in December,in a range of 0.0%-
0.25%,but announced plans to accelerate the pace of their tapering process.The Fed will reduce the magnitude of their
monthly asset purchases by $30 billionin January,doubling the pace of the monthly reduction in asset purchases that began
in November.Should the Fed continue to reduce their monthly asset purchases at the new pace,their bond-buying
program would end this spring (late-March or mid-April).The FOMC’s updated Summary of Economic Projections indicates
that policymakers may be prepared to hike the fed funds rate three times in 2022 (based on the median estimate),up from
the previous projection of just one 25 basis point hike.The Fed’s updated projections suggest that these hikes would be
amid a backdrop of strong economic growth.With inflation now more elevated and prolonged than originally anticipated,
we believe the Fed’s decision to accelerate the tapering process is prudent.However,we do not believe that monetary
policy is on a pre-set course and expect the Fed will adjust policy if necessary,depending on developments in the
economy.
In December,the 2-year Treasury yield increased nearly 17 basis points to 0.73%,the 5-year Treasury yield increased ten
basis points to 1.26%,and the 10-year Treasury yield increased about seven basis points to 1.51%in the month.So far in
January, we have seen a relatively swift move upward in Treasury yields across the curve.
3
121
Source: US Department of Labor Source: US Department of Labor
Employment
Job growth slowed in December,with US nonfarm payroll growth of just 199,000 in the month versus the consensus forecast of 450,000,but the
unemployment rate still declined to 3.9%,the lowest level since February 2020.On a trailing 3-month and 6-month basis,payrolls increased an
average of 365,000 and 508,000 per month,respectively,which still compares favorably to the average job gains in the five years leading up to
the pandemic of about 196,000 per month.We believe a variety of factors are keeping some workers out of the labor force for now,which
continues to hold back job growth despite strong demand from employers.The labor participation rate was unchanged in December at 61.9%
and remains lower than the pre-pandemic level of 63.4%.The employment-population ratio increased to 59.5%in December form 59.3%in
November,but also remains below the pre-pandemic level of 61.2%.The U-6 underemployment rate,which includes those who are marginally
attached to the labor force and employed part time foreconomic reasons,declined to 7.3%in December from 7.7%in November (versus 7.0%
in February 2020).Annualized average hourly earnings rose 0.6%month-over-month and were up 4.7%year-over-year in December versus
5.1% in November.
-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
122
Initial Claims for Unemployment
-
5,000
10,000
15,000
20,000
25,000
In thousandsInitial Jobless Claims
Continuing Claims
Initial Claims For Unemployment May 01, 2020 -January 14, 2022
In the most recent week,the number of initial jobless claims was 286,000,versus 231,000 in the prior week.The level of continuing
unemployment claims (where the data is lagged by one week)declined to 1.635 million from 1.551 million in the prior week.Continuing
jobless claims have declined significantly from the peak of nearly 25 millionin May 2020,and are in the range of pre-pandemic levels (the 2019
average was 1.7 million).
Source: US Department of Labor
5
123
Source: US Department of Labor Source: US Department of Commerce
Inflation
The Consumer Price Index (CPI)was up 7.0%year-over-year in December,versus up 6.8%year-over-year in November.Core CPI (CPI less food
and energy)was up 5.5%year-over-year in December,versus up 4.9%in November.Pricing pressures were widespread in December,with
notable gains for used cars and trucks,new vehicles,food,and rent.The Personal Consumption Expenditures (PCE)index was up 5.7%year-
over-year in November,up from 5.1%in October.Core PCE was up 4.7%year-over-year in November,versus up 4.2%in October.Current
inflation readings continue to run well above the Fed’s longer-run target of around 2.0%.While we believeyear-over-year inflation may be at
or near a peak, and pricing pressures are likely to abate as we move through the year,we expect inflationary pressures will remain elevated
over the near-term.
0.0%
1.0%
2.0%
3.0%
4.0%
5.0%
6.0%
7.0%
8.0%
Personal Consumption Expenditures (PCE)
PCE Price Deflator YOY % Change
PCE Core Deflator YOY % Change
YOY( %) Change0.0%
1.0%
2.0%
3.0%
4.0%
5.0%
6.0%
7.0%
8.0%
Consumer Price Index (CPI)
CPI YOY % Change
Core CPI YOY % Change
YOY( %) Change6
124
On a year-over-year basis,retail sales were up 16.9%in December versus up 18.2%in November.On a month-over-month basis,retail sales
were softer than expected in December,down 1.9%versus expectations of down 0.1%,following a modest gain of just 0.2%in November.
Excluding vehicles and gas,retail sales were down 2.5%month-over-month.In our view,the data suggests that consumers started shopping
early in the holiday season and that high gas prices are likely taking some wallet share.We believe the surge in Omicron virus cases likely
hindered December sales as well.We remain constructive on the outlook for consumerspending this year,but we believe the current surge in
virus cases is likely to take a toll on January retail sales.Looking further ahead,we believe high levels of consumer savings along with
improvement in the health situation and continued improvement in the labor market,should provide a healthy tailwind for consumer
spending.The Consumer Confidence index increased to 115.8 in December from 111.9 in November.The improvement came despite the
arrival of the omicron variant and still elevated inflation.
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
125
Source: The Conference Board Source: Federal Reserve Bank of Chicago
Economic Activity
The Conference Board’s Leading Economic Index (LEI)increased 0.8%month-over-month in December,following a 0.7%increase in November.
On a year-over-year basis,the LEI was up 8.5%in December versus up 8.4%in November.The Conference Board believes the December
increase in the LEI suggests that the economic expansion will continue into the spring, but they caution that headwinds from the virus,labor
shortages,inflation,and expected rate hikes by the Fed pose risks to the outlook.The Conference Board expects GDP growth to moderate in
the first quarter to 2.2%but they are forecasting 3.5%growth for the full year.Meanwhile,the Chicago Fed National Activity Index (CFNAI)
declined to -0.15 in December from 0.44 in November, suggesting that economic growth declined in December. We believe the rapid spread of
the Omicron variant in December contributed to the overall decline.On a 3-month moving average basis,the CFNAI increased to 0.33 in
December versus 0.40 in November.
-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
126
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 1.4%in December to an annual pace of 1,702,000.Single-family starts declined 2.3%while multi-family starts
increased 10.6%, month-over-month. On a year-over-year basis total housing starts were up 2.5% in December. According to the Case-Shiller 20-
City home price index,home prices were up 18.4%year-over-year in October versus up 19.1%year-over-year in September,suggesting the
acceleration in home prices is easing. However, tight supply will likely continue to support prices.
9
127
Source: Institute for Supply Management Source: Federal Reserve
Manufacturing
The Institute for Supply Management (ISM)manufacturing index declined to 58.7 in December from 61.1 in November. Nevertheless,readings
above 50.0 are indicative of expansion in the manufacturing sector.The Industrial Production index was up 3.7%in December,versus up 5.0%
in November.On a month-over-month basis,the Industrial Production index declined 0.1%in December,following an upwardly revised 0.7%
increase in November.Manufacturing production likely remains constrained by supply chain bottlenecks,and capacity utilization declined to
76.5%in December from 76.6%in November.Although capacity utilization remains below its longer-run average of 79.6%,itis running above
the pre-pandemic level of 76.3%.
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
128
Source: US Department of Commerce Source: US Department of Commerce
12/20 3/21 6/21 9/21
2.3% 7.4% 7.9% 1.4%
4.0% -0.4% -0.7% 2.1%
-1.7% -1.6% -0.2% -1.3%
-0.2% 0.8% -0.4% -0.4%
0.1% 0.0% 0.0% 0.5%
4.5% 6.3% 6.7% 2.3%
Gross Private Domestic Investment
Personal Consumption Expenditures
Components of GDP
Federal Government Expenditures
State and Local (Consumption and Gross
Investment)
Net Exports and Imports
Total
-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)growth decelerated in the third quarter of 2021 amid widespread supply chain disruptions and a surge in
the Covid Delta variant.However,third quarter growth was slightly better than previously estimated.According to the final estimate,third
quarter GDP grew at an annualized rate of 2.3%in the third quarter,revised up from the second estimate of 2.1%and the advance estimate of
2.0%.This follows a much stronger pace of growth in the first half of 2021,with first and second quarter annualized GDP growth up 6.3%and
6.7%,respectively.The consensus estimate is 5.9%GDP growth in the fourth quarter,and 2.9%GDP growth in the current quarter.We
anticipate the recent surge of omicron cases in the US will hamper current quarter economic growth.
11
129
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,and 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.
Many of the Fed's lending facilities expired at the end of 2020.In June 2021,the Fed announced plans to unwind its corporate credit facility.
The Fed started to taper their Treasury and agency MBS purchases in November 2021,and we believe the Fed's bond-buying program islikely
to end in the spring of 2022. The Fed has also signaled that they are likely to start hiking the fed funds target rate in 2022.
0.00%
0.50%
1.00%
1.50%
2.00%
2.50%
Effective Federal Funds Rate
Yield (%)2,000,000
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
130
Source: Bloomberg Source: Bloomberg
0.0%
0.5%
1.0%
1.5%
2.0%
2.5%
US Treasury Note Yields
2-Year
5-Year
10-Year
Yield (%)0.0%
0.5%
1.0%
1.5%
2.0%
2.5%
US Treasury Yield Curve
Dec-21
Sep-21
Dec-20
Yield (%)Bond Yields
At the end of December,the 2-year Treasury yield was about 61 basis points higher and the 10-Year Treasury yield was about 60 basis points
higher,year-over-year.The spread between the 2-year Treasury yield and 10-year Treasury yield was 78 basis points at year-end compared to
the average historical spread (since 2002) of about 135 basis points.
13
131
Section 2|SECTION |Section 2 |Account Profile
14
132
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 December 31, 2021
15
133
Compliance As of December 31, 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
134
Portfolio Characteristics
City of Dublin
12/31/2021 9/30/2021
Benchmark*Portfolio Portfolio
Average Maturity (yrs)2.64 2.67 2.80
Average Modified Duration 2.57 2.47 2.58
Average Purchase Yield n/a 1.49%1.52%
Average Market Yield 0.85%0.91%0.56%
Average Quality**AAA AA/Aa1 AA/Aa1
Total Market Value 233,062,790 234,606,258
*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 December 31, 2021
17
135
City of Dublin
Sector Distribution
ABS
6.3%
Agency
27.8%
CMO
0.9%
Corporate
24.2%
Money Market
Fund
0.1%
Negotiable CD
2.1%
Supranational
9.6%
US Treasury
28.8%
December 31, 2021 September 30, 2021
ABS
5.8%
Agency
28.0%
CMO
0.9%
Corporate
24.8%
Money Market
Fund
0.4%
Negotiable CD
1.1%
Supranational
9.7%
US Treasury
29.5%
As of December 31, 2021
18
136
Issue Name Investment Type % Portfolio
Government of United States US Treasury 28.82%
Federal National Mortgage Association Agency 11.71%
Federal Home Loan Bank Agency 8.68%
Inter-American Dev Bank Supranational 5.31%
Federal Home Loan Mortgage Corp Agency 4.57%
Intl Bank Recon and Development Supranational 4.33%
Federal Farm Credit Bank Agency 2.87%
JP Morgan Chase & Co Corporate 1.79%
Bank of America Corp Corporate 1.62%
Royal Bank of Canada Corporate 1.55%
Honda Motor Corporation Corporate 1.55%
Charles Schwab Corp/The Corporate 1.47%
Toronto Dominion Holdings Corporate 1.46%
Hyundai Auot Receivables ABS 1.42%
Apple Inc Corporate 1.35%
Morgan Stanley Corporate 1.29%
US Bancorp Corporate 1.16%
Chubb Corporation Corporate 1.14%
Honeywell Corp Corporate 1.08%
Bank of Nova Scotia Houston Negotiable CD 1.07%
Svenska Handelsbanken NY Negotiable CD 1.07%
Bank of Montreal Chicago Corporate 1.05%
Toyota Motor Corp Corporate 1.05%
PNC Financial Services Group Corporate 0.99%
John Deere ABS ABS 0.97%
Federal Home Loan Mortgage Corp CMO 0.90%
Deere & Company Corporate 0.89%
Wal-Mart Stores Corporate 0.87%
Berkshire Hathaway Corporate 0.82%
Honda ABS ABS 0.81%
Amazon.com Inc Corporate 0.79%
Hyundai Auto Lease Securitization ABS 0.61%
Bank of New York Corporate 0.54%
Metlife Inc Corporate 0.54%
Toyota ABS ABS 0.53%
Nissan ABS ABS 0.49%
Mercedes-Benz Auto Lease Trust ABS 0.48%
Toyota Lease Owner Trust ABS 0.46%
Issuers
City of Dublin –Account #10198
As of December 31, 2021
19
137
Issue Name Investment Type % Portfolio
ChevronTexaco Corp Corporate 0.44%
Merck & Company Corporate 0.33%
BMW Vehicle Lease Trust ABS 0.30%
United Health Group Inc Corporate 0.26%
GM Financial Securitized Term Auto Trust ABS 0.25%
Salesforce.com Inc Corporate 0.20%
First American Govt Oblig Fund Money Market Fund 0.12%
TOTAL 100.00%
Issuers
City of Dublin –Account #10198
As of December 31, 2021
20
138
AAA AA A <A NR
12/31/21 15.1%63.7%17.0%1.3%2.9%
09/30/21 14.1%64.5%17.5%1.3%2.7%
Source: S&P Ratings
December 31, 2021 vs. September 30, 2021
0.0%
10.0%
20.0%
30.0%
40.0%
50.0%
60.0%
70.0%
AAA AA A <A NR
12/31/2021 9/30/2021
Quality Distribution
City of Dublin
As of December 31, 2021
21
139
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 December 31, 2021
0 -0.25 0.25 -0.50 0.50 - 1 1 - 2 2 - 3 3 - 4 4 - 5 5+
Portfolio 2.0% 3.8% 7.6% 24.7% 24.8% 22.8% 14.3% 0.0%
Benchmark*0.0% 0.0% 1.7% 34.8% 27.8% 18.8% 16.8% 0.0%
*ICE BofA 1-5 Yr US Treasury & Agency Index
Duration Distribution
City of Dublin
As of December 31, 2021
22
140
-1.50%
-1.00%
-0.50%
0.00%
0.50%
1.00%
1.50%
2.00%
2.50%
3.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.66%-0.94%1.66%2.63%2.07%N/A 1.65%
ICE BofA 1-5 Yr US Treasury & Agency Index -0.69%-1.09%1.53%2.41%1.88%N/A 1.47%
*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 December 31, 2021
23
141
Portfolio Characteristics
City of Dublin Reporting Account
12/31/2021
Portfolio
9/30/2021
Portfolio
Average Maturity (yrs)0.00 0.00
Modified Duration 0.00 0.00
Average Purchase Yield 0.11%0.14%
Average Market Yield 0.11%0.14%
Average Quality*AAA/NR AAA/NR
Total Market Value 149,460,088 93,521,844
*Portfolio is S&P and Moody’s, respectively.
As of December 31, 2021
24
142
City of Dublin Reporting Account
Sector Distribution
LAIF
33.7%
Local Gov
Investment Pool
66.3%
December 31, 2021 September 30, 2021
LAIF
53.9%
Local Gov
Investment Pool
46.1%
As of December 31, 2021
25
143
Issue Name Investment Type % Portfolio
CAMP Local Gov Investment Pool 66.26%
Local Agency Investment Fund LAIF 33.74%
TOTAL 100.00%
Issuers
City of Dublin Reporting Account –Account #10219
As of December 31, 2021
26
144
SECTION |Section 3 |Consolidated Information
27
145
Portfolio Characteristics
City of Dublin Consolidated
12/31/2021 9/30/2021
Portfolio Portfolio
Average Maturity (yrs)1.63 2.00
Modified Duration 1.50 1.84
Average Purchase Yield 0.94%1.12%
Average Market Yield 0.60%0.44%
Average Quality*AA+/Aa1 AA+/Aa1
Total Market Value 382,522,878 328,128,102
* Portfolio is S&P and Moody’s respectively.
As of December 31, 2021
28
146
City of Dublin Consolidated
Sector Distribution
ABS
3.8%
Agency
17.0%
CMO
0.6%
Corporate
14.8%
LAIF
13.2%
Local Gov
Investment Pool
25.9%
Money Market
Fund
0.1%
Negotiable CD
1.3%
Supranational
5.9%
US Treasury
17.6%
December 31, 2021 September 30, 2021
ABS
4.2%
Agency
20.0%
CMO
0.7%
Corporate
17.7%
LAIF
15.4%
Local Gov
Investment Pool
13.1%
Money Market
Fund
0.3%
Negotiable CD
0.8%
Supranational
6.9%
US Treasury
21.1%
As of December 31, 2021
29
147
SECTION |Section 4 |Portfolio Holdings
30
148
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
65479GAD1 Nissan Auto Receivables Trust 2018-B A3
3.060% Due 03/15/2023
98,576.96 07/17/2018
3.08%
98,573.76
98,576.85
100.21
0.48%
98,779.93
134.06
0.04%
203.08
Aaa / AAA
NR
1.20
0.08
89231PAD0 Toyota Auto Receivables Trust 2018-D A3
3.180% Due 03/15/2023
206,220.51 08/29/2019
2.00%
210,626.86
207,713.15
100.44
0.36%
207,126.24
291.46
0.09%
(586.91)
Aaa / AAA
NR
1.20
0.16
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,838.63
99.37
0.73%
1,411,110.80
208.27
0.61%
(8,727.83)
Aaa / AAA
NR
2.46
1.56
65479JAD5 Nissan Auto Receivables Owner 2019-C A3
1.930% Due 07/15/2024
1,028,763.91 10/16/2019
1.94%
1,028,709.60
1,028,734.79
100.81
0.38%
1,037,068.09
882.45
0.45%
8,333.30
Aaa / AAA
NR
2.54
0.52
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,947.86
99.92
0.55%
1,024,175.90
200.44
0.44%
(771.96)
Aaa / AAA
NR
2.79
0.74
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,901.43
99.72
0.65%
1,116,869.60
149.64
0.48%
(3,031.83)
NR / AAA
AAA
2.80
0.99
89239CAC3 Toyota Lease Owner Trust 2021-B A3
0.420% Due 10/21/2024
1,090,000.00 07/27/2021
0.40%
1,089,985.28
1,089,987.76
99.15
0.90%
1,080,742.63
139.88
0.46%
(9,245.13)
Aaa / NR
AAA
2.81
1.79
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,954.09
99.85
0.69%
514,211.54
116.73
0.22%
(742.55)
Aaa / NR
AAA
2.88
0.83
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,931.45
99.25
0.81%
1,126,440.97
201.78
0.48%
(8,490.48)
NR / AAA
AAA
2.88
1.85
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,936.25
99.24
0.80%
704,580.58
39.05
0.30%
(5,355.67)
Aaa / NR
AAA
2.99
1.64
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,880.97
99.19
0.84%
793,528.00
128.00
0.34%
(6,352.97)
Aaa / NR
AAA
3.71
1.70
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,940.72
99.25
0.84%
719,587.88
122.44
0.31%
(5,352.84)
NR / AAA
AAA
3.71
1.62
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,606.74
98.90
0.98%
2,042,194.14
348.76
0.88%
(22,412.60)
NR / AAA
AAA
4.04
1.85
43815GAC3 Honda Auto Receivables Trust 2021-4 A3
0.880% Due 01/21/2026
765,000.00 11/16/2021
0.89%
764,838.74
764,843.91
99.76
0.99%
763,154.06
187.00
0.33%
(1,689.85)
Aaa / NR
AAA
4.06
2.13
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,924.51
98.86
1.02%
954,003.83
223.02
0.41%
(10,920.68)
Aaa / NR
AAA
4.21
2.30
44935FAD6 Hyundai Auto Receivables Trust 2021-C A3
0.740% Due 05/15/2026
545,000.00 11/09/2021
0.75%
544,878.36
544,883.10
99.31
1.05%
541,263.48
179.24
0.23%
(3,619.62)
NR / AAA
AAA
4.37
2.19
As of December 31, 2021
31
149
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
362554AC1 GM Financial Securitized Term 2021-4 A3
0.680% Due 09/16/2026
585,000.00 10/13/2021
0.66%
584,985.08
584,985.94
99.25
1.06%
580,606.07
165.75
0.25%
(4,379.87)
Aaa / AAA
NR
4.71
1.98
TOTAL ABS 14,798,561.38 0.60%
14,801,131.92
14,798,588.15 0.80%
14,715,443.74
3,717.97
6.32%
(83,144.41)
Aaa / AAA
Aaa
3.29
1.54
Agency
313378CR0 FHLB Note
2.250% Due 03/11/2022
2,000,000.00 06/19/2017
1.86%
2,035,280.00
2,001,411.20
100.41
0.16%
2,008,110.00
13,750.00
0.87%
6,698.80
Aaa / AA+
NR
0.19
0.19
3135G0T45 FNMA Note
1.875% Due 04/05/2022
3,250,000.00 05/05/2017
1.99%
3,232,125.00
3,249,062.88
100.41
0.30%
3,263,383.50
14,557.29
1.41%
14,320.62
Aaa / AA+
AAA
0.26
0.26
3135G0T94 FNMA Note
2.375% Due 01/19/2023
2,500,000.00 03/28/2018
2.70%
2,463,675.00
2,492,081.69
102.05
0.41%
2,551,347.50
26,718.75
1.11%
59,265.81
Aaa / AA+
AAA
1.05
1.03
313383QR5 FHLB Note
3.250% Due 06/09/2023
1,500,000.00 08/28/2018
2.87%
1,525,005.00
1,507,508.66
103.86
0.56%
1,557,838.50
2,979.17
0.67%
50,329.84
Aaa / AA+
NR
1.44
1.41
3137EAEN5 FHLMC Note
2.750% Due 06/19/2023
2,000,000.00 07/16/2018
2.88%
1,988,360.00
1,996,542.96
103.15
0.59%
2,062,924.00
1,833.33
0.89%
66,381.04
Aaa / AA+
AAA
1.47
1.44
3135G05G4 FNMA Note
0.250% Due 07/10/2023
2,350,000.00 07/08/2020
0.32%
2,344,947.50
2,347,439.14
99.46
0.60%
2,337,404.00
2,790.63
1.00%
(10,035.14)
Aaa / AA+
AAA
1.52
1.52
3133EKZK5 FFCB Note
1.600% Due 08/14/2023
4,000,000.00 08/26/2019
1.54%
4,009,000.00
4,003,667.13
101.96
0.39%
4,078,236.00
24,355.56
1.76%
74,568.87
Aaa / AA+
AAA
1.62
1.59
313383YJ4 FHLB Note
3.375% Due 09/08/2023
5,000,000.00 Various
2.90%
5,102,615.00
5,036,778.37
104.57
0.65%
5,228,470.00
52,968.76
2.27%
191,691.63
Aaa / AA+
NR
1.69
1.63
3130A0F70 FHLB Note
3.375% Due 12/08/2023
5,000,000.00 Various
2.73%
5,147,870.00
5,058,118.98
105.07
0.73%
5,253,670.00
10,781.25
2.26%
195,551.02
Aaa / AA+
AAA
1.94
1.88
3135G0V34 FNMA Note
2.500% Due 02/05/2024
2,000,000.00 02/27/2019
2.58%
1,992,340.00
1,996,749.92
103.56
0.78%
2,071,160.00
20,277.78
0.90%
74,410.08
Aaa / AA+
AAA
2.10
2.03
3130A1XJ2 FHLB Note
2.875% Due 06/14/2024
3,795,000.00 Various
1.96%
3,958,639.85
3,875,338.89
104.87
0.87%
3,979,687.47
5,152.24
1.71%
104,348.58
Aaa / AA+
NR
2.45
2.37
3133EKWV4 FFCB Note
1.850% Due 07/26/2024
2,500,000.00 08/13/2019
1.65%
2,524,140.00
2,512,510.61
102.93
0.70%
2,573,350.00
19,913.19
1.11%
60,839.39
Aaa / AA+
AAA
2.57
2.49
3130A2UW4 FHLB Note
2.875% Due 09/13/2024
2,000,000.00 10/10/2019
1.58%
2,122,020.00
2,066,877.00
105.11
0.95%
2,102,102.00
17,250.00
0.91%
35,225.00
Aaa / AA+
AAA
2.70
2.59
3135G0W66 FNMA Note
1.625% Due 10/15/2024
2,000,000.00 11/08/2019
1.80%
1,983,400.00
1,990,606.56
101.88
0.94%
2,037,648.00
6,861.11
0.88%
47,041.44
Aaa / AA+
AAA
2.79
2.72
3135G0X24 FNMA Note
1.625% Due 01/07/2025
4,200,000.00 Various
1.18%
4,287,898.80
4,254,850.11
101.83
1.01%
4,276,750.80
32,987.50
1.85%
21,900.69
Aaa / AA+
AAA
3.02
2.92
As of December 31, 2021
32
150
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
3137EAEP0 FHLMC Note
1.500% Due 02/12/2025
4,200,000.00 Various
1.23%
4,254,786.30
4,234,553.48
101.46
1.02%
4,261,496.40
24,325.00
1.84%
26,942.92
Aaa / AA+
AAA
3.12
3.02
3135G03U5 FNMA Note
0.625% Due 04/22/2025
1,825,000.00 04/22/2020
0.67%
1,821,240.50
1,822,512.22
98.64
1.04%
1,800,165.40
2,186.20
0.77%
(22,346.82)
Aaa / AA+
AAA
3.31
3.26
3135G04Z3 FNMA Note
0.500% Due 06/17/2025
3,435,000.00 06/17/2020
0.54%
3,427,889.55
3,430,076.48
98.03
1.08%
3,367,217.15
667.92
1.45%
(62,859.33)
Aaa / AA+
AAA
3.46
3.42
3137EAEU9 FHLMC Note
0.375% Due 07/21/2025
1,745,000.00 07/21/2020
0.48%
1,736,309.90
1,738,820.69
97.48
1.10%
1,701,017.28
2,908.33
0.73%
(37,803.41)
Aaa / AA+
AAA
3.56
3.51
3135G05X7 FNMA Note
0.375% Due 08/25/2025
2,755,000.00 08/25/2020
0.47%
2,742,106.60
2,745,584.43
97.29
1.14%
2,680,314.71
3,615.94
1.15%
(65,269.72)
Aaa / AA+
AAA
3.65
3.60
3137EAEX3 FHLMC Note
0.375% Due 09/23/2025
2,655,000.00 09/23/2020
0.44%
2,647,008.45
2,649,037.01
97.32
1.11%
2,583,713.25
2,710.31
1.11%
(65,323.76)
Aaa / AA+
AAA
3.73
3.68
3135G06G3 FNMA Note
0.500% Due 11/07/2025
2,860,000.00 11/09/2020
0.57%
2,849,761.20
2,852,094.59
97.59
1.14%
2,791,119.76
2,145.00
1.20%
(60,974.83)
Aaa / AA+
AAA
3.85
3.79
TOTAL Agency 63,570,000.00 1.63%
64,196,418.65
63,862,223.00 0.78%
64,567,125.72
291,735.26
27.83%
704,902.72
Aaa / AA+
Aaa
2.33
2.28
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,128,605.65
105.13
1.19%
2,102,544.00
5,285.00
0.90%
(26,061.65)
Aaa / AAA
AAA
2.82
2.62
TOTAL CMO 2,000,000.00 0.72%
2,151,406.25
2,128,605.65 1.19%
2,102,544.00
5,285.00
0.90%
(26,061.65)
Aaa / AAA
Aaa
2.82
2.62
Corporate
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,998,238.93
101.85
0.75%
2,037,098.00
22,966.67
0.88%
38,859.07
A2 / A
A
1.07
0.97
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,852,729.64
102.11
0.71%
1,904,355.23
15,101.32
0.82%
51,625.59
Aa2 / AA
A+
1.20
1.02
58933YAF2 Merck & Co Note
2.800% Due 05/18/2023
740,000.00 10/26/2018
3.41%
720,996.80
734,256.71
102.95
0.65%
761,828.52
2,474.89
0.33%
27,571.81
A1 / A+
A+
1.38
1.36
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
493,453.06
102.28
0.81%
511,383.00
1,612.50
0.22%
17,929.94
A2 / A-
AA-
1.38
1.20
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,209,126.53
103.76
0.71%
2,293,111.47
4,941.80
0.99%
83,984.94
A2 / A
A+
1.44
1.33
As of December 31, 2021
33
151
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
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
994,613.20
102.97
0.76%
1,029,695.00
620.47
0.44%
35,081.80
Aa2 / AA-
NR
1.48
1.21
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,893.66
104.03
0.51%
1,435,663.68
651.66
0.62%
55,770.02
Aa2 / AA
AA
1.48
1.38
02665WCJ8 American Honda Finance Note
3.450% Due 07/14/2023
1,000,000.00 Various
3.54%
996,275.00
998,766.51
104.09
0.76%
1,040,940.00
16,004.17
0.45%
42,173.49
A3 / A-
NR
1.53
1.48
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,595.76
104.20
0.82%
1,250,414.40
16,100.00
0.54%
49,818.64
A1 / A
AA-
1.61
1.56
06051GHF9 Bank of America Corp Callable Note 1X 3/5/2023
3.550% Due 03/05/2024
2,400,000.00 Various
2.77%
2,434,650.00
2,415,328.52
102.98
1.00%
2,471,510.40
27,453.33
1.07%
56,181.88
A2 / A-
AA-
2.18
1.15
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,313,805.08
104.52
1.16%
2,403,909.40
22,840.28
1.04%
90,104.32
A1 / A
AA-
2.19
2.11
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,018,120.93
104.17
0.92%
3,125,130.00
11,875.00
1.35%
107,009.07
Aaa / AA+
NR
2.36
2.13
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,858.45
99.04
0.86%
1,847,062.43
1,142.31
0.79%
(15,796.02)
A1 / AA
AA-
2.36
2.34
24422ETT6 John Deere Capital Corp Note
2.650% Due 06/24/2024
2,000,000.00 Various
1.32%
2,093,680.00
2,064,080.69
103.83
1.08%
2,076,644.00
1,030.56
0.89%
12,563.31
A2 / A
A
2.48
2.40
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,864.09
103.02
1.16%
1,545,321.00
400.00
0.66%
48,456.91
A3 / A-
NR
2.49
2.42
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,800.18
99.09
0.99%
460,764.32
1,364.32
0.20%
(4,035.86)
A2 / A+
NR
2.54
2.50
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,516,415.08
103.34
1.21%
2,583,387.50
29,218.75
1.12%
66,972.42
A2 / A
AA-
2.54
2.44
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.11%
2,632,175.00
2,569,667.86
104.23
1.06%
2,605,685.00
41,661.53
1.14%
36,017.14
A2 / A-
AA-
2.56
1.50
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,604.17
102.31
1.25%
2,670,340.59
23,780.00
1.16%
63,736.42
A1 / AA-
AA-
3.06
2.86
00440EAS6 Chubb INA Holdings Inc Note
3.150% Due 03/15/2025
2,500,000.00 Various
0.76%
2,753,600.00
2,687,839.92
105.57
1.37%
2,639,290.00
23,187.50
1.14%
(48,549.92)
A3 / A
A
3.21
3.03
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,375.31
98.71
1.12%
3,000,844.80
2,068.05
1.29%
(40,530.51)
A1 / BBB+
A
3.41
3.36
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,540,853.75
100.44
1.21%
2,511,060.00
2,812.50
1.08%
(29,793.75)
A2 / A
A
3.42
3.25
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,009,810.75
99.18
1.39%
991,795.00
670.83
0.43%
(18,015.75)
A2 / A
AA-
3.44
3.36
As of December 31, 2021
34
152
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
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,006,879.21
99.65
1.30%
996,531.00
5,766.67
0.43%
(10,348.21)
A3 / A-
NR
3.52
3.41
89114QCK2 Toronto Dominion Bank Note
0.750% Due 09/11/2025
1,000,000.00 02/16/2021
0.81%
997,230.00
997,757.06
97.37
1.48%
973,703.00
2,291.67
0.42%
(24,054.06)
A1 / A
AA-
3.70
3.61
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.09%
1,291,725.00
1,284,805.55
101.33
1.40%
1,266,591.25
9,655.21
0.55%
(18,214.30)
A2 / A-
AA-
4.12
3.92
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,025,000.06
101.22
1.61%
1,012,204.00
6,015.00
0.44%
(12,796.06)
A2 / A-
AA-
4.20
3.08
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,227.17
98.71
1.46%
1,352,290.01
2,100.67
0.58%
(14,937.16)
A2 / A
A
4.37
4.23
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,736.76
98.97
1.39%
598,789.68
889.02
0.26%
(7,947.08)
A3 / A+
A
4.37
4.24
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,484,024.56
98.54
1.46%
2,448,674.27
1,009.53
1.05%
(35,350.29)
A1 / A+
A+
4.47
4.33
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,888.37
97.89
1.72%
1,257,923.77
4,774.13
0.54%
(25,964.60)
Aa3 / AA-
AA-
4.71
4.52
06368FAC3 Bank of Montreal Note
1.250% Due 09/15/2026
2,500,000.00 Various
1.29%
2,495,539.50
2,495,803.32
97.92
1.71%
2,448,000.00
9,201.39
1.05%
(47,803.32)
A2 / A-
AA-
4.71
4.53
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,958.53
98.94
1.28%
578,776.77
1,774.50
0.25%
(5,181.76)
Aa2 / AA
AA
4.72
4.56
TOTAL Corporate 55,155,000.00 1.93%
55,781,725.10
55,606,179.37 1.13%
56,130,717.49
313,456.23
24.22%
524,538.12
A1 / A
A+
2.81
2.58
Money Market Fund
31846V203 First American Govt Obligation Fund Class Y 287,150.19 Various
0.01%
287,150.19
287,150.19
1.00
0.01%
287,150.19
0.00
0.12%
0.00
Aaa / AAA
AAA
0.00
0.00
TOTAL Money Market Fund 287,150.19 0.01%
287,150.19
287,150.19 0.01%
287,150.19
0.00
0.12%
0.00
Aaa / AAA
Aaa
0.00
0.00
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.91
99.95
0.31%
2,498,692.50
2,666.67
1.07%
(1,307.41)
P-1 / A-1
F-1+
0.48
0.48
As of December 31, 2021
35
153
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
86959RTW0 Svenska Handelsbanken NY Yankee CD
0.255% Due 10/14/2022
2,500,000.00 10/15/2021
0.25%
2,500,126.08
2,500,099.06
99.91
0.36%
2,497,867.50
1,381.25
1.07%
(2,231.56)
P-1 / A-1+
F-1+
0.79
0.78
TOTAL Negotiable CD 5,000,000.00 0.23%
5,000,125.89
5,000,098.97 0.34%
4,996,560.00
4,047.92
2.15%
(3,538.97)
Aaa / AA+
Aaa
0.63
0.63
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,843.77
100.10
0.54%
2,002,020.00
17,222.22
0.87%
2,176.23
Aaa / NR
AAA
0.07
0.07
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,492,926.70
100.95
0.40%
2,523,655.00
13,003.47
1.09%
30,728.30
Aaa / AAA
AAA
0.70
0.70
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,525.27
98.68
0.99%
3,631,240.00
5,008.89
1.56%
(46,285.27)
Aaa / AAA
NR
2.73
2.70
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,254,218.69
98.37
1.13%
2,223,184.60
2,707.29
0.96%
(31,034.09)
Aaa / AAA
NR
3.31
3.26
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,690,762.92
98.16
1.16%
1,653,970.73
4,856.08
0.71%
(36,792.19)
Aaa / AAA
NR
3.54
3.47
459058JL8 Intl. Bank Recon & Development Note
0.500% Due 10/28/2025
6,000,000.00 Various
0.55%
5,986,632.00
5,989,226.93
97.46
1.18%
5,847,714.00
5,250.00
2.51%
(141,512.93)
Aaa / AAA
AAA
3.83
3.77
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,596,826.61
98.44
1.25%
4,542,789.10
7,964.08
1.95%
(54,037.51)
Aaa / AAA
AAA
4.30
4.20
TOTAL Supranational 22,740,000.00 0.96%
22,643,350.65
22,701,330.89 1.01%
22,424,573.43
56,012.03
9.65%
(276,757.46)
Aaa / AAA
Aaa
2.98
2.93
US Treasury
912828XW5 US Treasury Note
1.750% Due 06/30/2022
3,000,000.00 07/25/2017
1.86%
2,984,072.55
2,998,407.26
100.76
0.23%
3,022,734.00
145.03
1.30%
24,326.74
Aaa / AA+
AAA
0.50
0.50
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,454.11
101.05
0.29%
2,020,938.00
12,741.71
0.87%
21,483.89
Aaa / AA+
AAA
0.67
0.66
912828L57 US Treasury Note
1.750% Due 09/30/2022
3,750,000.00 Various
2.02%
3,702,841.80
3,742,827.56
101.07
0.32%
3,789,990.00
16,766.83
1.63%
47,162.44
Aaa / AA+
AAA
0.75
0.74
912828M49 US Treasury Note
1.875% Due 10/31/2022
1,000,000.00 01/30/2018
2.47%
973,359.38
995,344.81
101.25
0.37%
1,012,461.00
3,211.33
0.44%
17,116.19
Aaa / AA+
AAA
0.83
0.83
9128284D9 US Treasury Note
2.500% Due 03/31/2023
3,750,000.00 Various
2.75%
3,706,123.05
3,738,952.70
102.47
0.51%
3,842,580.00
23,952.61
1.66%
103,627.30
Aaa / AA+
AAA
1.25
1.23
912828R69 US Treasury Note
1.625% Due 05/31/2023
1,500,000.00 05/30/2018
2.67%
1,427,167.97
1,479,458.66
101.51
0.55%
1,522,675.50
2,142.86
0.65%
43,216.84
Aaa / AA+
AAA
1.41
1.40
As of December 31, 2021
36
154
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
912828U57 US Treasury Note
2.125% Due 11/30/2023
5,000,000.00 Various
2.53%
4,908,242.19
4,963,782.12
102.70
0.71%
5,134,765.00
9,340.66
2.21%
170,982.88
Aaa / AA+
AAA
1.92
1.88
912828V80 US Treasury Note
2.250% Due 01/31/2024
5,000,000.00 Various
2.32%
4,983,691.41
4,992,951.70
103.09
0.75%
5,154,295.00
47,078.80
2.23%
161,343.30
Aaa / AA+
AAA
2.08
2.02
912828WJ5 US Treasury Note
2.500% Due 05/15/2024
1,750,000.00 06/10/2019
1.91%
1,798,261.72
1,773,192.44
103.90
0.84%
1,818,290.25
5,680.25
0.78%
45,097.81
Aaa / AA+
AAA
2.37
2.30
9128282N9 US Treasury Note
2.125% Due 07/31/2024
2,000,000.00 08/30/2019
1.44%
2,064,531.25
2,033,827.73
103.20
0.87%
2,063,984.00
17,785.33
0.89%
30,156.27
Aaa / AA+
AAA
2.58
2.50
912828YH7 US Treasury Note
1.500% Due 09/30/2024
3,500,000.00 Various
1.65%
3,474,941.41
3,485,805.18
101.60
0.91%
3,556,056.00
13,413.47
1.53%
70,250.82
Aaa / AA+
AAA
2.75
2.68
9128283J7 US Treasury Note
2.125% Due 11/30/2024
3,000,000.00 Various
1.76%
3,051,650.40
3,030,341.63
103.36
0.95%
3,100,899.00
5,604.40
1.33%
70,557.37
Aaa / AA+
AAA
2.92
2.83
912828ZC7 US Treasury Note
1.125% Due 02/28/2025
3,500,000.00 03/24/2020
0.52%
3,603,222.66
3,566,140.45
100.38
1.00%
3,513,398.00
13,378.80
1.51%
(52,742.45)
Aaa / AA+
AAA
3.16
3.09
912828ZL7 US Treasury Note
0.375% Due 04/30/2025
4,000,000.00 Various
0.38%
3,998,593.75
3,999,040.10
97.81
1.04%
3,912,500.00
2,569.06
1.68%
(86,540.10)
Aaa / AA+
AAA
3.33
3.29
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,494.05
96.88
1.10%
2,421,875.00
1,596.84
1.04%
(71,619.05)
Aaa / AA+
AAA
3.75
3.71
91282CBC4 US Treasury Note
0.375% Due 12/31/2025
1,000,000.00 12/29/2020
0.38%
999,921.88
999,937.54
96.97
1.15%
969,727.00
10.36
0.42%
(30,210.54)
Aaa / AA+
AAA
4.00
3.95
91282CBH3 US Treasury Note
0.375% Due 01/31/2026
4,000,000.00 02/23/2021
0.58%
3,960,625.00
3,967,420.57
96.79
1.18%
3,871,564.00
6,277.17
1.66%
(95,856.57)
Aaa / AA+
AAA
4.09
4.03
91282CBQ3 US Treasury Note
0.500% Due 02/28/2026
2,500,000.00 03/26/2021
0.83%
2,459,960.94
2,466,155.07
97.21
1.19%
2,430,175.00
4,247.24
1.04%
(35,980.07)
Aaa / AA+
AAA
4.16
4.09
91282CBT7 US Treasury Note
0.750% Due 03/31/2026
5,000,000.00 Various
0.85%
4,974,804.69
4,978,541.17
98.15
1.20%
4,907,615.00
9,581.05
2.11%
(70,926.17)
Aaa / AA+
AAA
4.25
4.15
91282CCF6 US Treasury Note
0.750% Due 05/31/2026
2,000,000.00 06/18/2021
0.91%
1,985,000.00
1,986,612.19
98.00
1.22%
1,960,000.00
1,318.68
0.84%
(26,612.19)
Aaa / AA+
AAA
4.42
4.32
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,615.62
97.82
1.23%
1,956,406.00
5,096.69
0.84%
(42,209.62)
Aaa / AA+
AAA
4.67
4.55
91282CDG3 US Treasury Note
1.125% Due 10/31/2026
5,000,000.00 Various
1.25%
4,970,498.06
4,970,898.16
99.40
1.25%
4,969,920.00
9,633.97
2.14%
(978.16)
Aaa / AA+
AAA
4.84
4.68
TOTAL US Treasury 66,750,000.00 1.47%
66,513,376.19
66,661,200.82 0.87%
66,952,847.75
211,573.14
28.82%
291,646.93
Aaa / AA+
Aaa
2.81
2.75
TOTAL PORTFOLIO 230,300,711.57 1.49%
231,374,684.84
231,045,377.04 0.91%
232,176,962.32
885,827.55
100.00%
1,131,585.28
Aa1 / AA
Aaa
2.67
2.47
TOTAL MARKET VALUE PLUS ACCRUALS 233,062,789.87
As of December 31, 2021
37
155
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,395,432.88 Various
0.22%
50,395,432.88
50,395,432.88
1.00
0.22%
50,395,432.88
26,612.95
33.74%
0.00
NR / NR
NR
0.00
0.00
TOTAL LAIF 50,395,432.88 0.22%
50,395,432.88
50,395,432.88 0.22%
50,395,432.88
26,612.95
33.74%
0.00
NR / NR
NR
0.00
0.00
Local Gov Investment Pool
90CAMP$00 California Asset Mgmt Program CAMP 99,038,041.80 Various
0.05%
99,038,041.80
99,038,041.80
1.00
0.05%
99,038,041.80
0.00
66.26%
0.00
NR / AAA
NR
0.00
0.00
TOTAL Local Gov Investment Pool 99,038,041.80 0.05%
99,038,041.80
99,038,041.80 0.05%
99,038,041.80
0.00
66.26%
0.00
NR / AAA
NR
0.00
0.00
TOTAL PORTFOLIO 149,433,474.68 0.11%
149,433,474.68
149,433,474.68 0.11%
149,433,474.68
26,612.95
100.00%
0.00
NR / AAA
NR
0.00
0.00
TOTAL MARKET VALUE PLUS ACCRUALS 149,460,087.63
As of December 31, 2021
38
156
SECTION |Section 5 |Transactions
39
157
Transaction Ledger
City of Dublin -Account #10198
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 10/15/2021 86959RTW0 2,500,000.00 Svenska Handelsbanken NY Yankee CD
0.255% Due: 10/14/2022
100.005 0.25%2,500,126.08 0.00 2,500,126.08 0.00
Purchase 10/21/2021 362554AC1 585,000.00 GM Financial Securitized Term 2021-4 A3
0.68% Due: 09/16/2026
99.997 0.68%584,985.08 0.00 584,985.08 0.00
Purchase 11/17/2021 44935FAD6 545,000.00 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due: 05/15/2026
99.978 0.75%544,878.36 0.00 544,878.36 0.00
Purchase 11/17/2021 91282CDG3 2,000,000.00 US Treasury Note
1.125% Due: 10/31/2026
99.316 1.27%1,986,328.13 1,056.63 1,987,384.76 0.00
Purchase 11/24/2021 43815GAC3 765,000.00 Honda Auto Receivables Trust 2021-4 A3
0.88% Due: 01/21/2026
99.979 0.89%764,838.74 0.00 764,838.74 0.00
Purchase 12/22/2021 91282CDG3 1,750,000.00 US Treasury Note
1.125% Due: 10/31/2026
99.520 1.23%1,741,591.80 2,828.04 1,744,419.84 0.00
Purchase 12/29/2021 91282CDG3 1,250,000.00 US Treasury Note
1.125% Due: 10/31/2026
99.406 1.25%1,242,578.13 2,291.95 1,244,870.08 0.00
Subtotal 9,395,000.00 9,365,326.32 6,176.62 9,371,502.94 0.00
TOTAL ACQUISITIONS 9,395,000.00 9,365,326.32 6,176.62 9,371,502.94 0.00
DISPOSITIONS
Sale 10/15/2021 912828J76 3,000,000.00 US Treasury Note
1.75% Due: 03/31/2022
100.773 1.85%3,023,203.13 2,163.46 3,025,366.59 24,517.76
Sale 11/17/2021 912828WZ9 1,750,000.00 US Treasury Note
1.75% Due: 04/30/2022
100.766 1.84%1,763,398.44 1,438.19 1,764,836.63 14,038.71
Sale 11/23/2021 912828XR6 250,000.00 US Treasury Note
1.75% Due: 05/31/2022
100.879 1.81%252,197.27 2,103.83 254,301.10 2,267.03
Sale 12/22/2021 912828XR6 1,250,000.00 US Treasury Note
1.75% Due: 05/31/2022
100.719 1.81%1,258,984.38 1,322.12 1,260,306.50 9,279.64
Subtotal 6,250,000.00 6,297,783.22 7,027.60 6,304,810.82 50,103.14
September 30, 2021 through December 31, 2021
As of December 31, 2021
40
158
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
Call 12/23/2021 91159HHP8 1,000,000.00 US Bancorp Callable Note Cont 12/23/2021
2.625% Due: 01/24/2022
100.000 2.35%1,000,000.00 10,864.58 1,010,864.58 0.00
Subtotal 1,000,000.00 1,000,000.00 10,864.58 1,010,864.58 0.00
TOTAL DISPOSITIONS 7,250,000.00 7,297,783.22 17,892.18 7,315,675.40 50,103.14
September 30, 2021 through December 31, 2021
As of December 31, 2021
41
159
Transaction Ledger
City of Dublin Reporting Account -Account #10219
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp
Yield Amount Interest
Pur/Sold Total Amount Gain/Loss
ACQUISITIONS
Purchase 10/15/2021 90LAIF$00 30,668.44 Local Agency Investment Fund State Pool 1.000 0.21%30,668.44 0.00 30,668.44 0.00
Purchase 10/31/2021 90CAMP$00 2,462.84 California Asset Mgmt Program CAMP 1.000 0.05%2,462.84 0.00 2,462.84 0.00
Purchase 11/30/2021 90CAMP$00 2,908.59 California Asset Mgmt Program CAMP 1.000 0.05%2,908.59 0.00 2,908.59 0.00
Purchase 12/31/2021 90CAMP$00 3,400.69 California Asset Mgmt Program CAMP 1.000 0.05%3,400.69 0.00 3,400.69 0.00
Subtotal 39,440.56 39,440.56 0.00 39,440.56 0.00
Security
Contribution
10/08/2021 90CAMP$00 5,000,000.00 California Asset Mgmt Program CAMP 1.000 5,000,000.00 0.00 5,000,000.00 0.00
Security
Contribution
10/18/2021 90CAMP$00 24,000,000.00 California Asset Mgmt Program CAMP 1.000 24,000,000.00 0.00 24,000,000.00 0.00
Security
Contribution
11/02/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
Security
Contribution
11/12/2021 90CAMP$00 5,800,000.00 California Asset Mgmt Program CAMP 1.000 5,800,000.00 0.00 5,800,000.00 0.00
Security
Contribution
11/29/2021 90CAMP$00 1,800,000.00 California Asset Mgmt Program CAMP 1.000 1,800,000.00 0.00 1,800,000.00 0.00
Security
Contribution
12/03/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
September 30, 2021 through December 31, 2021
As of December 31, 2021
42
160
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
Contribution
12/23/2021 90CAMP$00 28,000,000.00 California Asset Mgmt Program CAMP 1.000 28,000,000.00 0.00 28,000,000.00 0.00
Subtotal 68,200,000.00 68,200,000.00 0.00 68,200,000.00 0.00
TOTAL ACQUISITIONS 68,239,440.56 68,239,440.56 0.00 68,239,440.56 0.00
DISPOSITIONS
Security
Withdrawal
10/22/2021 90CAMP$00 3,200,000.00 California Asset Mgmt Program CAMP 1.000 3,200,000.00 0.00 3,200,000.00 0.00
Security
Withdrawal
11/05/2021 90CAMP$00 2,200,000.00 California Asset Mgmt Program CAMP 1.000 2,200,000.00 0.00 2,200,000.00 0.00
Security
Withdrawal
11/19/2021 90CAMP$00 4,800,000.00 California Asset Mgmt Program CAMP 1.000 4,800,000.00 0.00 4,800,000.00 0.00
Security
Withdrawal
12/10/2021 90CAMP$00 2,100,000.00 California Asset Mgmt Program CAMP 1.000 2,100,000.00 0.00 2,100,000.00 0.00
Subtotal 12,300,000.00 12,300,000.00 0.00 12,300,000.00 0.00
TOTAL DISPOSITIONS 12,300,000.00 12,300,000.00 0.00 12,300,000.00 0.00
September 30, 2021 through December 31, 2021
As of December 31, 2021
43
161
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 10/15/2021 86959RTW0 2,500,000.00 Svenska Handelsbanken NY Yankee CD
0.255% Due: 10/14/2022
100.005 0.25%2,500,126.08 0.00 2,500,126.08 0.00
Purchase 10/15/2021 90LAIF$00 30,668.44 Local Agency Investment Fund State Pool 1.000 0.21%30,668.44 0.00 30,668.44 0.00
Purchase 10/21/2021 362554AC1 585,000.00 GM Financial Securitized Term 2021-4 A3
0.68% Due: 09/16/2026
99.997 0.68%584,985.08 0.00 584,985.08 0.00
Purchase 10/31/2021 90CAMP$00 2,462.84 California Asset Mgmt Program CAMP 1.000 0.05%2,462.84 0.00 2,462.84 0.00
Purchase 11/17/2021 44935FAD6 545,000.00 Hyundai Auto Receivables Trust 2021-C A3
0.74% Due: 05/15/2026
99.978 0.75%544,878.36 0.00 544,878.36 0.00
Purchase 11/17/2021 91282CDG3 2,000,000.00 US Treasury Note
1.125% Due: 10/31/2026
99.316 1.27%1,986,328.13 1,056.63 1,987,384.76 0.00
Purchase 11/24/2021 43815GAC3 765,000.00 Honda Auto Receivables Trust 2021-4 A3
0.88% Due: 01/21/2026
99.979 0.89%764,838.74 0.00 764,838.74 0.00
Purchase 11/30/2021 90CAMP$00 2,908.59 California Asset Mgmt Program CAMP 1.000 0.05%2,908.59 0.00 2,908.59 0.00
Purchase 12/22/2021 91282CDG3 1,750,000.00 US Treasury Note
1.125% Due: 10/31/2026
99.520 1.23%1,741,591.80 2,828.04 1,744,419.84 0.00
Purchase 12/29/2021 91282CDG3 1,250,000.00 US Treasury Note
1.125% Due: 10/31/2026
99.406 1.25%1,242,578.13 2,291.95 1,244,870.08 0.00
Purchase 12/31/2021 90CAMP$00 3,400.69 California Asset Mgmt Program CAMP 1.000 0.05%3,400.69 0.00 3,400.69 0.00
Subtotal 9,434,440.56 9,404,766.88 6,176.62 9,410,943.50 0.00
Security
Contribution
10/08/2021 90CAMP$00 5,000,000.00 California Asset Mgmt Program CAMP 1.000 5,000,000.00 0.00 5,000,000.00 0.00
Security
Contribution
10/18/2021 90CAMP$00 24,000,000.00 California Asset Mgmt Program CAMP 1.000 24,000,000.00 0.00 24,000,000.00 0.00
Security
Contribution
11/02/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
Security
Contribution
11/12/2021 90CAMP$00 5,800,000.00 California Asset Mgmt Program CAMP 1.000 5,800,000.00 0.00 5,800,000.00 0.00
September 30, 2021 through December 31, 2021
As of December 31, 2021
44
162
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
Security
Contribution
11/29/2021 90CAMP$00 1,800,000.00 California Asset Mgmt Program CAMP 1.000 1,800,000.00 0.00 1,800,000.00 0.00
Security
Contribution
12/03/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
12/23/2021 90CAMP$00 28,000,000.00 California Asset Mgmt Program CAMP 1.000 28,000,000.00 0.00 28,000,000.00 0.00
Subtotal 68,200,000.00 68,200,000.00 0.00 68,200,000.00 0.00
TOTAL ACQUISITIONS 77,634,440.56 77,604,766.88 6,176.62 77,610,943.50 0.00
DISPOSITIONS
Sale 10/15/2021 912828J76 3,000,000.00 US Treasury Note
1.75% Due: 03/31/2022
100.773 1.85%3,023,203.13 2,163.46 3,025,366.59 24,517.76
Sale 11/17/2021 912828WZ9 1,750,000.00 US Treasury Note
1.75% Due: 04/30/2022
100.766 1.84%1,763,398.44 1,438.19 1,764,836.63 14,038.71
Sale 11/23/2021 912828XR6 250,000.00 US Treasury Note
1.75% Due: 05/31/2022
100.879 1.81%252,197.27 2,103.83 254,301.10 2,267.03
Sale 12/22/2021 912828XR6 1,250,000.00 US Treasury Note
1.75% Due: 05/31/2022
100.719 1.81%1,258,984.38 1,322.12 1,260,306.50 9,279.64
Subtotal 6,250,000.00 6,297,783.22 7,027.60 6,304,810.82 50,103.14
Call 12/23/2021 91159HHP8 1,000,000.00 US Bancorp Callable Note Cont 12/23/2021
2.625% Due: 01/24/2022
100.000 2.35%1,000,000.00 10,864.58 1,010,864.58 0.00
Subtotal 1,000,000.00 1,000,000.00 10,864.58 1,010,864.58 0.00
Security
Withdrawal
10/22/2021 90CAMP$00 3,200,000.00 California Asset Mgmt Program CAMP 1.000 3,200,000.00 0.00 3,200,000.00 0.00
September 30, 2021 through December 31, 2021
As of December 31, 2021
45
163
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
Security
Withdrawal
11/05/2021 90CAMP$00 2,200,000.00 California Asset Mgmt Program CAMP 1.000 2,200,000.00 0.00 2,200,000.00 0.00
Security
Withdrawal
11/19/2021 90CAMP$00 4,800,000.00 California Asset Mgmt Program CAMP 1.000 4,800,000.00 0.00 4,800,000.00 0.00
Security
Withdrawal
12/10/2021 90CAMP$00 2,100,000.00 California Asset Mgmt Program CAMP 1.000 2,100,000.00 0.00 2,100,000.00 0.00
Subtotal 12,300,000.00 12,300,000.00 0.00 12,300,000.00 0.00
TOTAL DISPOSITIONS 19,550,000.00 19,597,783.22 17,892.18 19,615,675.40 50,103.14
September 30, 2021 through December 31, 2021
As of December 31, 2021
46
164
Important Disclosures
2022 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 December 31, 2021
47
165
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 December 31, 2021
48
166
Holdings Report
As of December 31, 2021
City of Dublin Consolidated
Account #10221
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
US TREASURY
9128283J7 US Treasury Note
2.125% Due 11/30/2024
3,000,000.00 Various
1.76%
3,051,650.40
3,030,341.63
103.36
0.95%
3,100,899.00
5,604.40
0.81%
70,557.37
Aaa / AA+
AAA
2.92
2.83
912828ZC7 US Treasury Note
1.125% Due 2/28/2025
3,500,000.00 03/24/2020
0.52%
3,603,222.66
3,566,140.45
100.38
1.00%
3,513,398.00
13,378.80
0.92%
(52,742.45)
Aaa / AA+
AAA
3.16
3.09
912828ZL7 US Treasury Note
0.375% Due 4/30/2025
4,000,000.00 Various
0.38%
3,998,593.75
3,999,040.10
97.81
1.04%
3,912,500.00
2,569.06
1.02%
(86,540.10)
Aaa / AA+
AAA
3.33
3.29
91282CAM3 US Treasury Note
0.25% Due 9/30/2025
2,500,000.00 10/16/2020
0.32%
2,491,406.25
2,493,494.05
96.88
1.10%
2,421,875.00
1,596.84
0.63%
(71,619.05)
Aaa / AA+
AAA
3.75
3.71
91282CBC4 US Treasury Note
0.375% Due 12/31/2025
1,000,000.00 12/29/2020
0.38%
999,921.88
999,937.54
96.97
1.15%
969,727.00
10.36
0.25%
(30,210.54)
Aaa / AA+
AAA
4.00
3.95
91282CBH3 US Treasury Note
0.375% Due 1/31/2026
4,000,000.00 02/23/2021
0.58%
3,960,625.00
3,967,420.57
96.79
1.18%
3,871,564.00
6,277.17
1.01%
(95,856.57)
Aaa / AA+
AAA
4.09
4.03
91282CBQ3 US Treasury Note
0.5% Due 2/28/2026
2,500,000.00 03/26/2021
0.83%
2,459,960.94
2,466,155.07
97.21
1.19%
2,430,175.00
4,247.24
0.64%
(35,980.07)
Aaa / AA+
AAA
4.16
4.09
91282CBT7 US Treasury Note
0.75% Due 3/31/2026
5,000,000.00 Various
0.85%
4,974,804.69
4,978,541.17
98.15
1.20%
4,907,615.00
9,581.05
1.29%
(70,926.17)
Aaa / AA+
AAA
4.25
4.15
91282CCF6 US Treasury Note
0.75% Due 5/31/2026
2,000,000.00 06/18/2021
0.91%
1,985,000.00
1,986,612.19
98.00
1.22%
1,960,000.00
1,318.68
0.51%
(26,612.19)
Aaa / AA+
AAA
4.42
4.32
91282CCW9 US Treasury Note
0.75% Due 8/31/2026
2,000,000.00 08/30/2021
0.77%
1,998,515.63
1,998,615.62
97.82
1.23%
1,956,406.00
5,096.69
0.51%
(42,209.62)
Aaa / AA+
AAA
4.67
4.55
91282CDG3 US Treasury Note
1.125% Due 10/31/2026
5,000,000.00 Various
1.25%
4,970,498.06
4,970,898.16
99.40
1.25%
4,969,920.00
9,633.97
1.30%
(978.16)
Aaa / AA+
AAA
4.84
4.68
Total US Treasury 66,750,000.00 1.47%
66,513,376.19
66,661,200.82 0.87%
66,952,847.75
211,573.14
17.56%
291,646.93
Aaa / AA+
AAA
2.81
2.75
TOTAL PORTFOLIO 379,734,186.25 0.94%
380,808,159.52
380,478,851.72 0.60%
381,610,437.00
912,440.50
100.00%
1,131,585.28
Aa1 / AA+
AAA
1.63
1.50
TOTAL MARKET VALUE PLUS ACCRUED 382,522,877.50
Execution Time: 1/24/2022 1:15:30 PMChandler Asset Management - CONFIDENTIAL Page 10
Attachment 2
167
Transaction Ledger
As of December 31, 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 12/01/2021 31846V203 16,875.00 First American Govt Obligation Fund
Class Y
1.000 0.01%16,875.00 0.00 16,875.00 0.00
Purchase 12/01/2021 31846V203 4.52 First American Govt Obligation Fund
Class Y
1.000 0.01%4.52 0.00 4.52 0.00
Purchase 12/08/2021 31846V203 123,050.00 First American Govt Obligation Fund
Class Y
1.000 0.01%123,050.00 0.00 123,050.00 0.00
Purchase 12/09/2021 31846V203 24,375.00 First American Govt Obligation Fund
Class Y
1.000 0.01%24,375.00 0.00 24,375.00 0.00
Purchase 12/10/2021 31846V203 5,750.00 First American Govt Obligation Fund
Class Y
1.000 0.01%5,750.00 0.00 5,750.00 0.00
Purchase 12/14/2021 31846V203 54,553.13 First American Govt Obligation Fund
Class Y
1.000 0.01%54,553.13 0.00 54,553.13 0.00
Purchase 12/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 12/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 12/15/2021 31846V203 313.68 First American Govt Obligation Fund
Class Y
1.000 0.01%313.68 0.00 313.68 0.00
Purchase 12/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 12/15/2021 31846V203 229.58 First American Govt Obligation Fund
Class Y
1.000 0.01%229.58 0.00 229.58 0.00
Purchase 12/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 12/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 12/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 12/15/2021 31846V203 418.17 First American Govt Obligation Fund
Class Y
1.000 0.01%418.17 0.00 418.17 0.00
Purchase 12/15/2021 31846V203 44,592.60 First American Govt Obligation Fund
Class Y
1.000 0.01%44,592.60 0.00 44,592.60 0.00
Execution Time: 1/24/2022 1:15:30 PMChandler Asset Management - CONFIDENTIAL Page 11 168
Transaction Ledger
As of December 31, 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 12/15/2021 31846V203 94,036.29 First American Govt Obligation Fund
Class Y
1.000 0.01%94,036.29 0.00 94,036.29 0.00
Purchase 12/15/2021 31846V203 65,591.51 First American Govt Obligation Fund
Class Y
1.000 0.01%65,591.51 0.00 65,591.51 0.00
Purchase 12/16/2021 31846V203 331.50 First American Govt Obligation Fund
Class Y
1.000 0.01%331.50 0.00 331.50 0.00
Purchase 12/17/2021 31846V203 8,587.50 First American Govt Obligation Fund
Class Y
1.000 0.01%8,587.50 0.00 8,587.50 0.00
Purchase 12/18/2021 31846V203 13,978.13 First American Govt Obligation Fund
Class Y
1.000 0.01%13,978.13 0.00 13,978.13 0.00
Purchase 12/19/2021 31846V203 27,500.00 First American Govt Obligation Fund
Class Y
1.000 0.01%27,500.00 0.00 27,500.00 0.00
Purchase 12/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 12/20/2021 31846V203 381.50 First American Govt Obligation Fund
Class Y
1.000 0.01%381.50 0.00 381.50 0.00
Purchase 12/21/2021 31846V203 504.90 First American Govt Obligation Fund
Class Y
1.000 0.01%504.90 0.00 504.90 0.00
Purchase 12/22/2021 91282CDG3 1,750,000.00 US Treasury Note
1.125% Due 10/31/2026
99.520 1.23%1,741,591.80 2,828.04 1,744,419.84 0.00
Purchase 12/23/2021 31846V203 1,010,864.58 First American Govt Obligation Fund
Class Y
1.000 0.01%1,010,864.58 0.00 1,010,864.58 0.00
Purchase 12/24/2021 31846V203 42,455.00 First American Govt Obligation Fund
Class Y
1.000 0.01%42,455.00 0.00 42,455.00 0.00
Purchase 12/26/2021 31846V203 23,460.00 First American Govt Obligation Fund
Class Y
1.000 0.01%23,460.00 0.00 23,460.00 0.00
Purchase 12/27/2021 31846V203 18,000.00 First American Govt Obligation Fund
Class Y
1.000 0.01%18,000.00 0.00 18,000.00 0.00
Purchase 12/27/2021 31846V203 195.25 First American Govt Obligation Fund
Class Y
1.000 0.01%195.25 0.00 195.25 0.00
Purchase 12/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
Execution Time: 1/24/2022 1:15:30 PMChandler Asset Management - CONFIDENTIAL Page 12 169
Transaction Ledger
As of December 31, 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 12/29/2021 31846V203 5.23 First American Govt Obligation Fund
Class Y
1.000 0.01%5.23 0.00 5.23 0.00
Purchase 12/29/2021 91282CDG3 1,250,000.00 US Treasury Note
1.125% Due 10/31/2026
99.406 1.25%1,242,578.13 2,291.95 1,244,870.08 0.00
Purchase 12/31/2021 31846V203 28,125.00 First American Govt Obligation Fund
Class Y
1.000 0.01%28,125.00 0.00 28,125.00 0.00
Purchase 12/31/2021 90CAMP$00 3,400.69 California Asset Mgmt Program CAMP 1.000 0.05%3,400.69 0.00 3,400.69 0.00
Subtotal 4,615,466.55 4,599,636.48 5,119.99 4,604,756.47 0.00
Security
Contribution
12/03/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
12/23/2021 90CAMP$00 28,000,000.00 California Asset Mgmt Program CAMP 1.000 28,000,000.00 0.00 28,000,000.00 0.00
Subtotal 30,500,000.00 30,500,000.00 0.00 30,500,000.00 0.00
TOTAL ACQUISITIONS 35,115,466.55 35,099,636.48 5,119.99 35,104,756.47 0.00
DISPOSITIONS
Sale 12/22/2021 31846V203 484,113.34 First American Govt Obligation Fund
Class Y
1.000 0.01%484,113.34 0.00 484,113.34 0.00
Sale 12/22/2021 912828XR6 1,250,000.00 US Treasury Note
1.75% Due 5/31/2022
100.719 1.81%1,258,984.38 1,322.12 1,260,306.50 9,279.64
Sale 12/29/2021 31846V203 1,244,870.08 First American Govt Obligation Fund
Class Y
1.000 0.01%1,244,870.08 0.00 1,244,870.08 0.00
Subtotal 2,978,983.42 2,987,967.80 1,322.12 2,989,289.92 9,279.64
Call 12/23/2021 91159HHP8 1,000,000.00 US Bancorp Callable Note Cont
12/23/2021
2.625% Due 1/24/2022
100.000 2.35%1,000,000.00 10,864.58 1,010,864.58 0.00
Subtotal 1,000,000.00 1,000,000.00 10,864.58 1,010,864.58 0.00
Paydown 12/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
Execution Time: 1/24/2022 1:15:30 PMChandler Asset Management - CONFIDENTIAL Page 13 170
Transaction Ledger
As of December 31, 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 12/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 12/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 12/15/2021 44935FAD6 0.00 Hyundai Auto Receivables Trust 2021-C
A3
0.74% Due 5/15/2026
100.000 0.00 313.68 313.68 0.00
Paydown 12/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 12/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 12/15/2021 47789QAC4 0.00 John Deere Owner Trust 2021-B A3
0.52% Due 3/16/2026
100.000 0.00 418.17 418.17 0.00
Paydown 12/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 12/15/2021 65479GAD1 44,228.45 Nissan Auto Receivables Trust 2018-B
A3
3.06% Due 3/15/2023
100.000 44,228.45 364.15 44,592.60 0.00
Paydown 12/15/2021 65479JAD5 92,233.35 Nissan Auto Receivables Owner 2019-C
A3
1.93% Due 7/15/2024
100.000 92,233.35 1,802.94 94,036.29 0.00
Paydown 12/15/2021 89231PAD0 64,873.11 Toyota Auto Receivables Trust 2018-D
A3
3.18% Due 3/15/2023
100.000 64,873.11 718.40 65,591.51 0.00
Paydown 12/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 12/16/2021 362554AC1 0.00 GM Financial Securitized Term 2021-4
A3
0.68% Due 9/16/2026
100.000 0.00 331.50 331.50 0.00
Execution Time: 1/24/2022 1:15:30 PMChandler Asset Management - CONFIDENTIAL Page 14 171
Transaction Ledger
As of December 31, 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 12/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 12/20/2021 89239CAC3 0.00 Toyota Lease Owner Trust 2021-B A3
0.42% Due 10/21/2024
100.000 0.00 381.50 381.50 0.00
Paydown 12/21/2021 43815GAC3 0.00 Honda Auto Receivables Trust 2021-4
A3
0.88% Due 1/21/2026
100.000 0.00 504.90 504.90 0.00
Paydown 12/27/2021 09690AAC7 0.00 BMW Vehicle Lease Trust 2021-2 A3
0.33% Due 12/26/2024
100.000 0.00 195.25 195.25 0.00
Paydown 12/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 201,334.91 201,334.91 13,147.86 214,482.77 0.00
Security
Withdrawal
12/10/2021 90CAMP$00 2,100,000.00 California Asset Mgmt Program CAMP 1.000 2,100,000.00 0.00 2,100,000.00 0.00
Security
Withdrawal
12/23/2021 31846V203 104.17 First American Govt Obligation Fund
Class Y
1.000 104.17 0.00 104.17 0.00
Subtotal 2,100,104.17 2,100,104.17 0.00 2,100,104.17 0.00
TOTAL DISPOSITIONS 6,280,422.50 6,289,406.88 25,334.56 6,314,741.44 9,279.64
OTHER TRANSACTIONS
Interest 12/01/2021 438516CB0 2,500,000.00 Honeywell Intl Callable Note Cont
5/1/2025
1.35% Due 6/1/2025
0.000 16,875.00 0.00 16,875.00 0.00
Interest 12/08/2021 3130A0F70 5,000,000.00 FHLB Note
3.375% Due 12/8/2023
0.000 84,375.00 0.00 84,375.00 0.00
Interest 12/08/2021 69353RFL7 2,210,000.00 PNC Bank Callable Note Cont 5/9/2023
3.5% Due 6/8/2023
0.000 38,675.00 0.00 38,675.00 0.00
Interest 12/09/2021 313383QR5 1,500,000.00 FHLB Note
3.25% Due 6/9/2023
0.000 24,375.00 0.00 24,375.00 0.00
Execution Time: 1/24/2022 1:15:30 PMChandler Asset Management - CONFIDENTIAL Page 15 172
Transaction Ledger
As of December 31, 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 12/10/2021 78015K7H1 1,000,000.00 Royal Bank of Canada Note
1.15% Due 6/10/2025
0.000 5,750.00 0.00 5,750.00 0.00
Interest 12/14/2021 3130A1XJ2 3,795,000.00 FHLB Note
2.875% Due 6/14/2024
0.000 54,553.13 0.00 54,553.13 0.00
Interest 12/17/2021 3135G04Z3 3,435,000.00 FNMA Note
0.5% Due 6/17/2025
0.000 8,587.50 0.00 8,587.50 0.00
Interest 12/18/2021 89236TJK2 2,485,000.00 Toyota Motor Credit Corp Note
1.125% Due 6/18/2026
0.000 13,978.13 0.00 13,978.13 0.00
Interest 12/19/2021 3137EAEN5 2,000,000.00 FHLMC Note
2.75% Due 6/19/2023
0.000 27,500.00 0.00 27,500.00 0.00
Interest 12/24/2021 166764AH3 1,000,000.00 Chevron Corp Callable Note Cont
3/24/2023
3.191% Due 6/24/2023
0.000 15,955.00 0.00 15,955.00 0.00
Interest 12/24/2021 24422ETT6 2,000,000.00 John Deere Capital Corp Note
2.65% Due 6/24/2024
0.000 26,500.00 0.00 26,500.00 0.00
Interest 12/26/2021 931142EK5 1,380,000.00 Wal-Mart Stores Callable Note Cont
5/26/2023
3.4% Due 6/26/2023
0.000 23,460.00 0.00 23,460.00 0.00
Interest 12/27/2021 02665WCZ2 1,500,000.00 American Honda Finance Note
2.4% Due 6/27/2024
0.000 18,000.00 0.00 18,000.00 0.00
Interest 12/31/2021 912828XW5 3,000,000.00 US Treasury Note
1.75% Due 6/30/2022
0.000 26,250.00 0.00 26,250.00 0.00
Interest 12/31/2021 91282CBC4 1,000,000.00 US Treasury Note
0.375% Due 12/31/2025
0.000 1,875.00 0.00 1,875.00 0.00
Subtotal 33,805,000.00 386,708.76 0.00 386,708.76 0.00
Dividend 12/01/2021 31846V203 421,046.92 First American Govt Obligation Fund
Class Y
0.000 4.52 0.00 4.52 0.00
Dividend 12/29/2021 31846V203 259,019.96 First American Govt Obligation Fund
Class Y
0.000 5.23 0.00 5.23 0.00
Execution Time: 1/24/2022 1:15:30 PMChandler Asset Management - CONFIDENTIAL Page 16 173
Transaction Ledger
As of December 31, 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
Dividend 12/31/2021 90CAMP$00 99,034,641.11 California Asset Mgmt Program CAMP 0.000 3,400.69 0.00 3,400.69 0.00
Subtotal 99,714,707.99 3,410.44 0.00 3,410.44 0.00
TOTAL OTHER TRANSACTIONS 133,519,707.99 390,119.20 0.00 390,119.20 0.00
Execution Time: 1/24/2022 1:15:30 PMChandler Asset Management - CONFIDENTIAL Page 17 174
STAFF REPORT
CITY COUNCIL
Page 1 of 2
Agenda Item 4.4
DATE:February 15, 2022
TO:Honorable Mayor and City Councilmembers
FROM:Linda Smith, City Manager
SUBJECT:Payment Issuance Report and Electronic Funds TransfersPreparedby:Veronica Briggs,Senior Finance Technician
EXECUTIVE SUMMARY:The City Council will receive a listing of payments issued from January 1, 2022 –January 31, 2022totaling $13,690,767.41.
STAFF RECOMMENDATION:Receive the report.
FINANCIAL IMPACT:SUMMARY OF PAYMENTS ISSUEDJanuary 1, 2022 –January 31, 2022Total Number of Payments: 269Total Amount of Payments: $13,690,767.41
DESCRIPTION:The Payment Issuance Report (Attachment 1) provides a listing of all payments for the period beginning January 1, 2022 through January 31, 2022. This report is provided in accordance with the policy adopted November 15, 2011, in Resolution No.189-11. The listing of payments has been reviewed in accordance with the policies for processing payments and expenditures.The City’s practice of reporting payments to the City Council after the payments have been made is in compliance with California Government Code Sections 37208 (b) and (c), which allow for an agency to make payments without first being audited by the legislative body, as long as such payments are: 1) conforming to a budget approved by ordinance or resolution of the legislative body; and 2) presented to the legislative body for ratification and approval in the form of an
175
Page 2 of 2
audited comprehensive annual financial report.
STRATEGIC PLAN INITIATIVE:None.
NOTICING REQUIREMENTS/PUBLIC OUTREACH:The City Council Agenda was posted.
ATTACHMENTS:1) Payment Issuance Report for January 2022
176
Print Date: 02/01/2022 City of Dublin
Page 1 of 9 Payment Issuance Report
Payments Dated 1/1/2022 through 1/31/2022
Date Issued Payee Amount Description
01/04/2022 4LEAF INC. 61,210.00 BLDG INSP/PLAN CHECK SVCS NOV 2021
01/04/2022 AMP PRINTING, INC. 166.03 BUSINESS CARDS
01/04/2022 APEX GRADING 17,580.00 MAINTENANCE SVCS-FALLON VILLAGE GHAD
18,800.00 MAINTENANCE SVCS-SCHAEFER RANCH GHAD
Check Total: 36,380.00
01/04/2022 AT&T - CALNET 3 784.05 SERVICE TO 12/14/2021
01/04/2022 BAY ALARM COMPANY 270.00 ALARM SERVICES CORP YARD
207.00 ALARM SERVICES SENIOR CENTER
Check Total: 477.00
01/04/2022 CASCADIA CONSULTING GROUP, INC 4,798.75 SB 1383 IMPLEMENTATION ASSISTANCE
01/04/2022 CENTRO LEGAL 1,539.75 HUMAN SERVICES GRANT OCT 2021
01/04/2022 CINTAS CORP 93.48 FIRST AID KIT SUPPLIES
01/04/2022 DR MANAGEMENT, LLC 56,000.00 IMPACT FEE RIGHTS TO REIMBURSEMENT
01/04/2022 ENGEO INC 362.00 FALLON CROSSING GHAD PROFESSIONAL SVCS
2,212.75 FALLON VILLAGE GHAD PROFESSIONAL SVCS
5,402.25 SCHAEFER RANCH GHAD PROFESSIONAL SVCS
Check Total: 7,977.00
01/04/2022 J+C ENTERPRISES 154.00 EVIDENCE SUPPLIES
01/04/2022 LIVERMORE AUTO GROUP 1,620.19 POLICE VEHICLE MAINT & REPAIRS
01/04/2022 LOCAL GOVERNMENT COMMISSION 2,636.36 CIVIC SPARK PRGM TO SUPPORT CLIMATE ACTION PLN
01/04/2022 NEW HAMPSHIRE DEPT OF SAFETY 600.00 DRUG AWARENESS TRAINING REG-COWENS
01/04/2022 NICHOLS CONSULTING ENGINEERS 967.50 ENGINEERING SERVICES - JUL 2021
01/04/2022 PG&E 9,152.74 SERVICE TO 11/14/2021
50,686.48 SERVICE TO 12/06/2021
2,883.11 SERVICE TO 12/07/2021
Check Total: 62,722.33
01/04/2022 PHOENIX GROUP INFO SYS. 247.59 PARKING CITATION PROCESSING - NOV 2021
01/04/2022 PRIME TIME ENTERTAINMENT 1,250.00 TREE LIGHTING EVENT AUDIO SYSTEM RENTAL
01/04/2022 QUADIENT LEASING USA, INC. 1,073.36 NEOPOST MAIL MACHINE LEASE NOV 2021-JAN 2022
01/04/2022 SELECT IMAGING 441.57 ELECTRICAL METER TAGS
674.01 SENIOR CENTER BALLROOM SIGN
Check Total: 1,115.58
01/04/2022 SPECTRUM COMMUNITY SVCS INC. 1,677.08 HUMAN SERVICES GRANT NOV 2021
01/04/2022 SURF TO SNOW ENVIRONMENTAL 411.00 SPILL RESPONSE ASSISTANCE & MRP INSPECTION
01/04/2022 THE ECOHERO SHOW, LLC. 5,000.00 DUBLIN SCHOOLS RECYCLING EDUCATION
01/04/2022 TIREHUB, LLC. 4,695.45 POLICE VEHICLE MAINTENANCE
01/04/2022 TREASURER ALAMEDA COUNTY 3,017.26 RETURN OF ASSET SEIZURE FUNDS
01/04/2022 TREASURER ALAMEDA COUNTY 1,145.00 PARKING CITATIONS COLLECTED - NOV 2021
Vendor Total: 4,162.26
01/04/2022 TYLER BUSINESS FORMS 65.73 TAX FORMS
01/04/2022 TYLER TECHNOLOGIES, INC. 5,015.85 TYLER MUNIS ERP SOFTWARE IMPLEMENTATION
01/04/2022 WILLDAN HOMELAND SOLUTIONS 190,185.25 ENERGY EFFICIENCY/INFRASTRUCTURE IMPROV
Payments Issued 1/4/2022 Total: 453,025.59
01/07/2022 CAL PERS 75,857.33 PERS RETIREMENT PLAN: PE 12/31/21
01/07/2022 EMPLOYMENT DEVELOPMENT DEPT 26,076.08 CA STATE WITHHOLDING: PE 12/31/21
01/07/2022 I C M A 401 PLAN 1,129.78 DEFERRED COMP 401A: PE 12/31/21
01/07/2022 I C M A 457 PLAN 29,433.18 DEFERRED COMP 457: PE 12/31/21
01/07/2022 INTERNAL REVENUE SERVICE 83,071.10 FEDERAL WITHHOLDING: PE 12/31/21
Attachment 1
177
Print Date: 02/01/2022 City of Dublin
Page 2 of 9 Payment Issuance Report
Payments Dated 1/1/2022 through 1/31/2022
Date Issued Payee Amount Description
01/07/2022 US BANK - PARS 738.94 PARS: PE 12/31/21
Payments Issued 1/7/2022 Total: 216,306.41
01/10/2022 ADVANCED INTEGRATED PEST 5,060.00 PEST CONTROL SERVICES DEC 2021
01/10/2022 AMP PRINTING, INC. 219.40 PRINTING SERVICES FOR HOLIDAY HOME DECOR
01/10/2022 AT&T 2,204.92 PUBLIC SAFETY COMPLEX DATA SERVICES
51.07 SERVICES FOR TOLL FREE NUMBER TO 12/11/21
Check Total: 2,255.99
01/10/2022 AT&T - CALNET 3 313.07 SERVICE TO 12/26/2021 135.77 SERVICE TO 12/27/2021
Check Total: 448.84
01/10/2022 BAY ALARM COMPANY 541.86 ALARM SERVICES SHANNON CENTER 264.00 ALARM SERVICES CIVIC CENTER 330.00 ALARM SERVICES CORP YARD 138.00 ALARM SERVICES FIRE STATION #16 352.75 ALARM SERVICES FIRE STATION #17 108.00 ALARM SERVICES HERITAGE CENTER 1,802.13 ALARM SERVICES HERITAGE PARK 484.30 ALARM SERVICES SENIOR CENTER 842.41 ALARM SERVICES SHANNON CENTER 1,972.00 ALARM SERVICES THE WAVE
Check Total: 6,835.45
01/10/2022 BFS LANDSCAPE ARCHITECTURE 15,642.50 FALLON SPORTS PARK DESIGN SVCS - PHASE 3
01/10/2022 BKF ENGINEERS 38,494.50 ANNUAL STREET RESURFACING PROJECT 251.00 SAN RAMON RD TRAIL LIGHTING DESIGN 9,993.75 TASSAJARA RD GAP CLOSURE PROJECT
Check Total: 48,739.25
01/10/2022 BLUETOAD, INC. 570.00 SPRING 2022 ACTIVITY GUIDE DIGITAL EDITION
01/10/2022 BSK ASSOCIATES INC. 4,930.50 PRE-CONSTRUCTION SOIL SAMPLING 1,018.25 TESTING/INSP DON BIDDLE COMMUNITY PARK 419.25 TESTING/INSP FALLON SPORTS PARK PH3 2,511.50 TESTING/INSP HERITAGE PARK CEMETARY IMPROV
Check Total: 8,879.50
01/10/2022 CAL PERS HEALTH PREMIUM 141,804.07 HEALTH INSURANCE PREMIUM - JAN 2022
01/10/2022 CALLANDER ASSOCIATES INC. 37,203.51 WALLIS RANCH PARK DESIGN SERVICES
01/10/2022 COMCAST 118.63 CIVIC CENTER CABLE SERVICE JAN 2022
01/10/2022 DEDECKER SCULPTURES INC. 650.00 REIMBURSEMENT FOR HCAC PRESENTATION
01/10/2022 DU-ALL SAFETY, LLC 999.90 SAFETY INSPECTION REPORT WRITE-UP
01/10/2022 DUTCHOVER & ASSOCIATES 880.00 LANDSCAPE PLAN CHECK & INSPECTIONS
01/10/2022 EAST BAY CHAPTER ICC 180.00 ICC EAST BAY CHAPTER MEMBERSHIP-SHREEVE
01/10/2022 EVERYTHING GROWS INTERIOR 204.51 PLANT SERVICE JAN 2021
01/10/2022 HARRELL HARRIS PHOTOGRAPHY 300.00 BASKETBALL LEAGUE PHOTOGRAPHY
01/10/2022 HARRIS & ASSOCIATES 1,080.00 DESIGN/CONSTR SUPPORT-2021 SLURRY SEAL PROJ
01/10/2022 KIMLEY-HORN AND ASSOC. INC. 11,777.46 HOUSING ELEMENT UPDATE CONSULTING SERVICES 2,851.50 PREPARE CEQA DOCS FOR EAST RANCH PROJECT
Check Total: 14,628.96
01/10/2022 LANLOGIC INC. 31,773.05 SONICWALL FOR VARIOUS FACILITIES
01/10/2022 MCE CORPORATION 9,497.42 LANDSCAPE MAINTENANCE DSRSD DEC 2021
01/10/2022 MNS ENGINEERS, INC. 77.50 CONSTR MGMT/INSP-SLIDE TOWER ANCHOR INSTALL
178
Print Date: 02/01/2022 City of Dublin
Page 3 of 9 Payment Issuance Report
Payments Dated 1/1/2022 through 1/31/2022
Date Issued Payee Amount Description
4,340.00 DON BIDDLE COMMUNITY PARK INSPECTIONS 4,840.48 FALLON SPORTS PARK PH3 PW INSPECTIONS 2,015.00 INSPECTIONS/CONSTR MGMT SR RD TRAIL LIGHTING 8,082.00 IRON HORSE TRAIL BRIDGE AT DUBLIN BLVD
Check Total: 19,354.98
01/10/2022 PAKPOUR CONSULTING GROUP, INC. 8,550.00 CONSTRUCTION MGMT-DON BIDDLE COMM PARK 16,371.50 CONSTRUCTION MGMT-FALLON SPORTS PARK PH3
Check Total: 24,921.50
01/10/2022 PG&E 836.06 SERVICE TO 11/30/2021 247.38 SERVICE TO 12/02/2021 5,427.59 SERVICE TO 12/07/2021 258.06 SERVICE TO 12/08/2021 82.81 SERVICE TO 12/09/2021 4,026.91 SERVICE TO 12/12/2021 428.68 SERVICE TO 12/13/2021 9,665.21 SERVICE TO 12/14/2021 65.56 SERVICE TO 12/15/2021
Check Total: 21,038.26
01/10/2022 PGADESIGN INC. 11,029.18 HERITAGE PARK IMPROVEMENTS DESIGN SVCS
01/10/2022 PLEASANTON EVENT RENTALS INC 123.48 VETERANS DAY LUNCH SUPPLIES
01/10/2022 PRUDENTIAL OVERALL SUPPLY 86.12 MAT SERVICE - SENIOR CENTER
01/10/2022 RAYNE OF SAN JOSE 194.00 WATER SOFTENER SERVICE-FIRE STATION 17
01/10/2022 ROBERT HALF INC 792.00 PW TEMPORARY OFFICE STAFF-DYER
01/10/2022 RRM DESIGN GROUP, A CA CORP 5,867.75 CONSULTING SVCS-MULTI-FAM DEV & ADU'S
01/10/2022 SAN FRANCISCO ELEVATOR SVC INC 394.70 ELEVATOR MAINTENANCE/INSPECTION DEC 2021
01/10/2022 SELECT IMAGING 71.28 EMPLOYEE NAME BADGES 297.99 NAME PLATES, CAR MAGNETS FOR CC MEMBERS
Check Total: 369.27
01/10/2022 SESAC, INC. 1,025.00 ANNUAL MUSIC LICENSE 2022
01/10/2022 SNG & ASSOCIATES INC. 5,585.00 ON-CALL PLAN REVIEW SERVICES-CIP/PARKS
01/10/2022 SUAREZ & MUNOZ CONSTRUCTION 424,737.58 FALLON SPORTS PARK-PH 3 CONSTRUCTION
01/10/2022 T-MOBILE USA, INC. 6,066.77 EQUIPMENT-IPADS & IPHONES
01/10/2022 TPX COMMUNICATIONS 2,805.53 INTERNET & PHONE SERVICES T0 12/09/21
01/10/2022 TREASURER ALAMEDA COUNTY 4,253,730.11 POLICE SERVICES 8/22/21 - 10/30/21
01/10/2022 TRI-VALLEY COMMUNITY TV 1,257.99 RECORD/TELEVISE CITY COUNCIL/PLNG COMM MTGS
01/10/2022 TRI-VALLEY JANITORIAL INC. 22,002.75 JANITORIAL SERVICES DEC 2021 30,228.39 JANITORIAL SERVICES-CAMP PARKS DEC 2021
Check Total: 52,231.14
01/10/2022 URBAN PLANNERS PARTNERS, INC. 5,316.50 PLANNING SVCS-REGIONAL ST. AFFORDABLE HSNG
01/10/2022 W. BRADLEY ELECTRIC 15,671.20 LIGHT POLE INSTALL/FOUNDATION-SR RD TRAIL
Payments Issued 1/10/2022 Total: 5,180,569.04
01/11/2022 HEALTHEQUITY, INC. 90,287.37 HEALTHEQUITY: PE 12/31/21
Payments Issued 1/11/2022 Total: 90,287.37
01/12/2022 CALPERS 89,999.28 2022 REPLACEMENT CHARGES FOR CITY OF DUBLIN
Payments Issued 1/12/2022 Total: 89,999.28
179
Print Date: 02/01/2022 City of Dublin
Page 4 of 9 Payment Issuance Report
Payments Dated 1/1/2022 through 1/31/2022
Date Issued Payee Amount Description
01/14/2022 DELTA DENTAL OF CALIFORNIA 12,632.02 DELTA DENTAL PREMIUM - JAN 2022
01/14/2022 UNUM LIFE INS CO OF AMERICA 9,956.54 LIFE AND AD&D PREMIUM - JAN 2022
01/14/2022 VISION SERVICE PLAN - (CA) 1,867.65 VISION INSURANCE PREMIUM - JAN 2022
Payments Issued 1/14/2022 Total: 24,456.21
01/18/2022 ACCOPSA -ALAMEDA COUNTY CHIEFS 950.00 POLICE POST EXECUTIVE SEMINAR 2022-HOLMES
01/18/2022 ADVANCED MOBILITY GROUP 600.00 TASSAJARA RD ARTERIAL MGMT PROJECT 14,030.00 TASSAJARA RD ARTERIAL MGMT PROJECT 10,930.00 TRAFFIC SIGNAL SYSTEMS SUPPORT
Check Total: 25,560.00
01/18/2022 ALAMEDA CO SHERIFF'S OFFICE 93.06 CRIME PREVENTION PRINTING 150.51 POLICE LETTERHEAD STOCK 25.68 POLICE PHOTO PRINTING
Check Total: 269.25
01/18/2022 ALAMEDA COUNTY FIRE DEPARTMENT 1,239,753.25 FIRE SERVICES JAN 2022
01/18/2022 ALEX, ROSEMARY 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 ALL CITY MANAGEMENT SVCS INC 15,156.00 CROSSING GUARD SERVICES 10/31/21-11/13/21 6,971.76 CROSSING GUARD SERVICES 11/14/21-11/27/21 16,766.33 CROSSING GUARD SERVICES 11/28/21-12/11/21
Check Total: 38,894.09
01/18/2022 AMADOR VALLEY INDUSTRIES LLC 25,693.83 CAMPS PARKS SOLID WASTE SERVICES DEC 2021
01/18/2022 AMP PRINTING, INC. 79.38 BUSINESS CARDS-THE WAVE
01/18/2022 AT&T - CALNET 3 129.06 SERVICE TO 01/01/2022 49.55 SERVICE TO 01/06/2022
Check Total: 178.61
01/18/2022 BAKSA, JAY 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 BAY AREA NEWS GROUP 451.92 LEGAL NOTICES DEC 2021
01/18/2022 BHATIA, PRATYUSH 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 BIG O'TIRES #7 128.46 POLICE VEHICLE MAINT & TIRE INSTALLATION 305.88 POLICE VEHICLE MAINTENANCE
Check Total: 434.34
01/18/2022 BLAISDELL'S BUSINESS PRODUCTS 2,725.23 OFFICE SUPPLIES-DEC 2021 1,820.20 OFFICE SUPPLIES-OCT 21
Check Total: 4,545.43
01/18/2022 BLANCO, ROEL 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 BRIGGS, VERONICA 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 BRINKS, INC. 31.71 ARMORED CAR SERVICE-DEC 2021 230.75 ARMORED CAR SERVICE-JAN 2022
Check Total: 262.46
01/18/2022 CAIRES, SANDRA 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 CASS, MICHAEL 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 CENTENO, CAMILLE 6.27 MILEAGE REIMBURSEMENT DEC 2021
01/18/2022 CHANDLER ASSET MANAGEMENT 13,061.03 INVESTMENT CONSULTING SERVICES
01/18/2022 CHARGE POINT, INC. 10,437.00 ANNUAL SUBSCRIPTION FOR EV CHARGING STATIONS
01/18/2022 CHILKOTOWSKY, SHAUN 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 CHING, ERWIN 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 CLEVENGER, MARISSA 85.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 CSW/STUBER-STROEH ENGINEERING 1,175.00 STANDARDS FOR MICRO TRENCHING SERVICES
01/18/2022 DETERMAN, EMILY 89.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 DUBLIN HIGH SCHOOL BAND 3,951.00 2021 BREAKFAST WITH SANTA EVENT
180
Print Date: 02/01/2022 City of Dublin
Page 5 of 9 Payment Issuance Report
Payments Dated 1/1/2022 through 1/31/2022
Date Issued Payee Amount Description
01/18/2022 DUTCHOVER & ASSOCIATES 1,571.25 LANDSCAPE PLAN CHECK & INSPECTIONS
01/18/2022 DWYER, ANDREA 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 ECS IMAGING INC. 8,100.00 PROFESSIONAL SVCS & LASERFICHE LICENSES
01/18/2022 EMPLOYMENT DEVELOPMENT DEPT 270.00 2020 EMPLOYMENT & WAGE DATA
01/18/2022 EUROPEAN MOBILE WERKS 6,092.01 POLICE VEHICLE MAINTENANCE & REPAIR
01/18/2022 FABRIGAS, CIERRA L. 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 FOSS, JORDAN 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 FRANKLIN, RHONDA 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 GOLDEN STATE FLEET SVCS INC 375.00 POLICE VEHICLE TOW
01/18/2022 HANNA, MEAGAN C. 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 HATZIKOKOLAKIS, JACQUI 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 HISATOMI, LISA 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 IRON MOUNTAIN 341.39 POLICE RECORDS STORAGE - JAN 2022
01/18/2022 JACKMAN, SHARLENE 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 JAMMAL, LAURA 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 JOHE, JILL 75.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 KITTELSON & ASSOCIATES, INC. 8,306.00 CITYWIDE BIKE/PED MASTER PLAN UPDATE 7,620.00 DOWNTOWN PREFERRED VISION MODELING 1,583.00 ENGINEERING SVCS-LOCAL RD SAFETY PLAN 3,470.00 SB 743 VMT IMPLEMENTATION & MODEL
Check Total: 20,979.00
01/18/2022 KLOSS, DAVID A. 2,000.00 EDUCATION REIMBURSEMENT-KLOSS 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
Check Total: 2,150.00
01/18/2022 LI MARZI, JENNIFER 126.08 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 LI, CARY 79.99 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 LIVERMORE AUTO GROUP 3,506.74 POLICE VEHICLE MAINT & REPAIRS
01/18/2022 LSA ASSOCIATES INC. 633.16 CEQA DOC PREP-BRANAUGH PROP STAGE 2 DEV 455.15 CEQA DOC PREP-RIGHETTI PROPERTY STAGE 2
Check Total: 1,088.31
01/18/2022 MARRIOTT, LAUREN 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 MCE CORPORATION 571,870.94 MAINTENANCE SERVICES NOV 2021
01/18/2022 MCGUIRE, SHARON 125.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 MENDEZ, JENNIFER 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 M-GROUP 6,270.00 PLANNING SVCS-BLVD PH1-5 & TASSAJARA HILLS
01/18/2022 MIDIDIDDI, SAI 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 MOORE, MARSHA 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 MORAN, RYAN 75.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 NOVANI, LLC. 3,000.00 TRAFFIC ENGINEERING SERVICES
01/18/2022 PATEL, MAYANK 75.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 PG&E 7,985.38 SERVICE TO 12/07/2021 1,628.86 SERVICE TO 12/12/2021 26,484.29 SERVICE TO 12/15/2021 590.75 SERVICE TO 12/23/2021 119.04 SERVICE TO 12/24/2021 154.65 SERVICE TO 12/27/2021 2,901.15 SERVICE TO 12/28/2021 470.90 SERVICE TO 12/29/2021 145.91 SERVICE TO 12/31/2021
181
Print Date: 02/01/2022 City of Dublin
Page 6 of 9 Payment Issuance Report
Payments Dated 1/1/2022 through 1/31/2022
Date Issued Payee Amount Description
Check Total: 40,480.93
01/18/2022 PRO CYCLES 920.66 POLICE MOTORCYCLE MAINTENANCE - 19M73
01/18/2022 PRUDENTIAL OVERALL SUPPLY 86.12 MAT SERVICE - SENIOR CENTER
01/18/2022 QUADIENT, INC. 99.06 POLICE POSTAGE METER LEASE
01/18/2022 RAYNE OF SAN JOSE 172.90 WATER SOFTENER SERVICE-FIRE STATION 16 145.35 WATER SOFTENER SERVICE-FIRE STATION 18
Check Total: 318.25
01/18/2022 REDWOOD TOXICOLOGY LAB. INC. 632.00 FORENSIC DRUG AND ALCOHOL EXAMS
01/18/2022 SABOO INC. 131,420.62 CONSTRUCTION-HERITAGE PARK CEMETARY IMPROV
01/18/2022 SANTA RITA TOW 345.00 POLICE VEHICLE TOW
01/18/2022 SHREEVE, GREGORY 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 SIMPLER SYSTEMS, INC 1,500.00 SIMPLER SOFTWARE LICENSING SUPPORT
01/18/2022 SOLIS, LISA 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 SUCGANG, LAURIE 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 TAYLOR, YVONNE L. 100.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 TJENG, YULIANA 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 TRI-VALLEY JANITORIAL INC. 4,030.63 JANITORIAL SUPPLIES NOV 2021
01/18/2022 UNITED SITE SERVICES OF CA INC 665.57 BLDG INSP TRAILER SEPTIC TANK SERVICES
01/18/2022 UNIVERSAL BUILDING SERVICES & 566.00 CARPET CLEANING SERVICES-CIVIC CENTER DEC 2021 1,298.00 CARPET CLEANING SERVICES-SHANNAN CTR DEC 2021 828.00 CARPET CLEANING SERVICES-THE WAVE DEC 2021 700.00 WINDOW CLEANING SVCS LIBRARY DEC 2021
Check Total: 3,392.00
01/18/2022 VALES, NORMAN 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 VISION COMMUNICATIONS CO 425.00 SPLATTER FESTIVAL EQUIPMENT RENTAL
01/18/2022 WAHBEH, WILLIAM 145.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 WANZENRIED, NICOLE 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 WEBER, DANIEL 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 WELLS, CATHY 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 WETHERFORD, HAZEL 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 WHEELER, KRISTIE 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 XU, KAN 99.66 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 YIP, KA WUN 118.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
01/18/2022 YOUNG, SHANNAN 150.00 WELLNESS REIMBURSEMENT JUL-DEC 2021
Payments Issued 1/18/2022 Total: 2,181,776.07
01/21/2022 CAL PERS 80,988.92 PERS RETIREMENT PLAN: PE 1/14/22
01/21/2022 EMPLOYMENT DEVELOPMENT DEPT 18,548.75 CA STATE WITHHOLDING: PE 1/14/22
01/21/2022 HEALTHEQUITY, INC. 3,287.37 HEALTHEQUITY: PE 1/14/22
01/21/2022 I C M A 401 PLAN 979.78 DEFERRED COMP 401A: PE 1/14/22
01/21/2022 I C M A 457 PLAN 30,816.23 DEFERRED COMP 457: PE 1/14/22
01/21/2022 INTERNAL REVENUE SERVICE 60,088.50 FEDERAL WITHHOLDING: PE 1/14/22
01/21/2022 US BANK - PARS 1,745.05 PARS: PE 1/14/22
Payments Issued 1/21/2022 Total: 196,454.60
01/24/2022 AMP PRINTING, INC. 331.36 BUSINESS CARDS-POLICE SERVICES
01/24/2022 ANGEL HOUZE CLAY ART 70.00 REC CLASS INSTRUCTOR
01/24/2022 ARORA, AKSHAY 16,904.40 REC CLASS INSTRUCTOR
01/24/2022 AT&T - CALNET 3 1,207.56 SERVICE TO 01/12/2022
01/24/2022 CA DEPT. OF TAX & FEE ADMIN 2,722.00 SALES & USE TAX RETURN CAL YR 2021
182
Print Date: 02/01/2022 City of Dublin
Page 7 of 9 Payment Issuance Report
Payments Dated 1/1/2022 through 1/31/2022
Date Issued Payee Amount Description
01/24/2022 CALIFORNIA BUILDING STANDARDS 7,132.50 GREEN BUILDING FEES OCT-DEC 2021
01/24/2022 CARBONIC SERVICE 369.20 POOL CHEMICALS FOR THE WAVE
01/24/2022 CMC NEPTUNE 1,200.00 WAVE PUBLIC MUSIC & ANNOUNCEMENT SYSTEM
01/24/2022 COMMUNICATION ACADEMY 90.30 REC CLASS INSTRUCTOR
01/24/2022 CONTRACT SWEEPING SERVICES 26,539.59 STREET SWEEPING SERVICES DEC 2021
01/24/2022 DEAM, VALERIE 1,861.29 REC CLASS INSTRUCTOR
01/24/2022 DEPARTMENT OF JUSTICE 288.00 EMPLOYEE FINGERPRINTING SERVICES
01/24/2022 DEPT OF CONSERVATION 46,682.30 SEISMIC HAZARD MAPPING FEE OCT-DEC 2021
01/24/2022 DEPT OF INDUSTRIAL RELATIONS 998.75 THE WAVE SLIDE INSPECTION
01/24/2022 DISABILITY ACCESS DAC 2,650.00 ADA TRANSITION PLAN CONSULTING SVCS
01/24/2022 DUBLIN CHEVROLET 1,880.62 POLICE VEHICLE MAINT & REPAIRS
01/24/2022 ECUBE LABS CO. 24,994.30 SOLAR POWERED WASTE COMPACTORS
01/24/2022 FOLSOM CHEVROLET 149,281.58 REPLACE POLICE VEHICLES AND EQUIPMENT
01/24/2022 FRANCISCO & ASSOCIATES, INC. 13,972.50 ACQUISITION AUDIT CFD SERVICES
01/24/2022 GIRISH, VIDYA 156.00 REC CLASS INSTRUCTOR
01/24/2022 GRAFIX SHOPPE 1,905.77 POLICE VEHICLE GRAPHICS
01/24/2022 HEALTHEQUITY, INC. 590.75 FLEXIBLE SPENDING ACCOUNT FEES DEC 2021 5.25 TRANSIT SERVICE FEE JAN 2022 50.00 WAGEWORKS MONTHLY COMPLIANCE FEE JAN 2022
Check Total: 646.00
01/24/2022 IMAGE SALES, INC. 166.74 BADGE PRINTER RIBBONS
01/24/2022 JOHNSON CONTROLS SECURITY 580.00 FIRE ALARM INSTALLATION
01/24/2022 KITTELSON & ASSOCIATES, INC. 8,638.75 CITYWIDE BIKE/PED MASTER PLAN UPDATE 7,909.00 ENGINEERING SVCS-LOCAL RD SAFETY PLAN
Check Total: 16,547.75
01/24/2022 LIEBERT CASSIDY WHITMORE 2,520.00 EMPLOYMENT RELATIONS CONSORTIUM MEMBERSHIP
01/24/2022 LOCAL GOVERNMENT COMMISSION 2,636.36 CIVIC SPARK PRGM TO SUPPORT CLIMATE ACTION PLN
01/24/2022 MICHAEL BAKER INT'L, INC. 4,855.00 CONSULTING SVCS-AFFORDABLE RENTAL HOUSING
01/24/2022 MILLER STARR REGALIA A 6,655.00 LEGAL CONSULTING FEES-SOFI APARTMENTS
01/24/2022 MONKEY BEAR YOGA, INC. 210.00 PRESCHOOL IN-HOUSE FIELD TRIP
01/24/2022 NOVANI, LLC. 6,735.00 TRAFFIC HARDWARE AND SOFTWARE
01/24/2022 PARS 967.50 TRUSTEE AND ADMINISTRATIVE FEES FY 20-21
01/24/2022 PG&E 2,865.14 SERVICE TO 01/04/2022 1,516.06 SERVICE TO 01/05/2022 9,890.67 SERVICE TO 12/14/2021 2,068.87 SERVICE TO 12/29/2021 1,555.89 SERVICE TO 12/30/2021
Check Total: 17,896.63
01/24/2022 POSITIVE COACHING ALLIANCE 2,100.00 JUNIOR WARRIORS COACHING WORKSHOP
01/24/2022 PRO CYCLES 826.82 POLICE MOTORCYCLE MAINTENANCE
01/24/2022 QUADIENT FINANCE USA, INC. 250.00 POSTAGE FOR POLICE DEPT - DEC 2021
01/24/2022 REGIONAL GOVERNMENT SERVICES 2,138.52 HR ADVERTISING SERVICES 1,775.00 HR RECRUITMENT SERVICES
Check Total: 3,913.52
01/24/2022 SHIR MARTIAL ARTS 249.90 REC CLASS INSTRUCTOR
01/24/2022 SHUMS CODA ASSOCIATES INC 625.00 PLAN CHECK SERVICES AUG 2021 125.00 PLAN CHECK SERVICES DEC 2021
Check Total: 750.00
01/24/2022 SQUAD ESTATES 396.00 REC CLASS INSTRUCTOR
01/24/2022 STANFORD HEALTH -VALLEYCARE 216.76 EMPLOYEE MEDICAL SERVICES
183
Print Date: 02/01/2022 City of Dublin
Page 8 of 9 Payment Issuance Report
Payments Dated 1/1/2022 through 1/31/2022
Date Issued Payee Amount Description
01/24/2022 TERRYBERRY 1,119.05 EMPLOYEE SERVICE AWARD
01/24/2022 TIREHUB, LLC. 165.29 POLICE VEHICLE MAINTENANCE - D36
01/24/2022 TRB AND ASSOCIATES, INC. 74,450.00 BLDG INSP/PLAN CHECK & CODE ENFORCEMENT SVCS
01/24/2022 TRI-VALLEY JANITORIAL INC. 6,777.25 EXTRA JANITORIAL SERVICES NOV 2021
01/24/2022 VERIZON WIRELESS 1,748.46 POLICE SITCAM SIM CARDS TO 01/03/22 638.92 POLICE VEHICLE MODEM & CITY CELL PHONES
Check Total: 2,387.38
01/24/2022 WC3-WEST COAST CODE CONSULTANT 12,651.25 BLDG INSP/PLAN CHECK SVCS DEC 2021
01/24/2022 WESCO GRAPHICS INC 2,144.53 CITY OF RENEWABLE ENERGY POSTCARDS
Payments Issued 1/24/2022 Total: 470,051.75
01/27/2022 U S BANK ST. PAUL 2,431,899.91 SPECIAL TAX REVENUE COLLECTED CFD 2015-1
01/27/2022 U S BANK ST. PAUL 294,336.15 SPECIAL TAX REVENUE COLLECTED CFD 2015-1
Vendor Total: 2,726,236.06
Payments Issued 1/27/2022 Total: 2,726,236.06
01/31/2022 ALPHA OMEGA WIRELESS, INC 2,530.00 ANNUAL WIRELESS SUPPORT TO CORP YARD
01/31/2022 APWA-AMERICAN PUBLIC WORK ASSN 2,978.50 PUBLIC WORKS ASSN AGENGY MEMBERSHIP DUES
01/31/2022 ARORA, AKSHAY 17,612.40 REC CLASS INSTRUCTOR
01/31/2022 AT&T 2,090.50 CIVIC CENTER FIBER SERVICES 425.31 PUBLIC SAFETY COMPLEX DATA SERVICES 44.52 SERVICES FOR TOLL-FREE NUMBER TO 01/11/22
Check Total: 2,560.33
01/31/2022 AT&T - CALNET 3 623.97 SERVICE TO 01/14/2022
01/31/2022 AXIS COMMUNITY HEALTH 2,283.75 HUMAN SERVICES GRANT OCT-DEC 2021
01/31/2022 CAL-ALHFA 300.00 CAL-ALHFA MEMBERSHIP RENEWAL
01/31/2022 CDW GOVERNMENT INC 4,737.62 COMPUTER EQUIPMENT
01/31/2022 CENTRO LEGAL 2,286.17 HUMAN SERVICES GRANT DEC 2021 1,880.47 HUMAN SERVICES GRANT NOV 2021
Check Total: 4,166.64
01/31/2022 CIVICPLUS, LLC 48,366.81 SEECLICKFIX SOFTWARE SUBSCRIPTION
01/31/2022 COGENT COMMUNICATIONS, INC 4,438.00 CIVIC CENTER INTERNET SERVICE DEC 2021
01/31/2022 COMCAST 2,300.00 CIVIC CENTER & FIRE STATION INTERNET
01/31/2022 COMCAST 1,863.08 INTERNET / CABLE SVC VARIOUS CITY DEPTS
01/31/2022 CSW/STUBER-STROEH ENGINEERING 5,204.00 CONCEPT PLANS- CIVIC CENTER BACK PARKING
01/31/2022 DIV OF THE STATE ARCHITECT 406.40 DIVISION OF STATE ARCHITECT CASP OCT-DEC 2021
01/31/2022 DSRSD 1,152.46 SERVICE TO 12/31/2021
01/31/2022 EMPLOYMENT DEVELOPMENT DEPT 165.00 2019 EMPLOYMENT & WAGE DATA 538.00 2020 EMPLOYMENT & WAGE DATA
Check Total: 703.00
01/31/2022 ENGEO INC 6,790.85 FALLON VILLAGE GHAD PROFESSIONAL SVCS 3,881.10 SCHAEFER RANCH GHAD PROFESSIONAL SVCS
Check Total: 10,671.95
01/31/2022 EVERBRIDGE, INC. 5,000.00 EMERGENCY ALERT SOFTWARE
01/31/2022 HARRELL HARRIS PHOTOGRAPHY 750.00 TREE LIGHTING PHOTOGRAPHY SERVICES
01/31/2022 HUBER, JENNIFER B. 1,000.00 UTILITY BOX PAINTING
01/31/2022 KIMLEY-HORN AND ASSOC. INC. 3,627.50 TRAFFIC & ENGINEERING SERVICE
01/31/2022 LANLOGIC INC. 4,992.50 INFORMATION SYSTEMS CONSULTING SVCS 1,050.00 MALWARE PROTECTION SERVICES 425.00 NETWORK MONITORING SERVICES
184
Print Date: 02/01/2022 City of Dublin
Page 9 of 9 Payment Issuance Report
Payments Dated 1/1/2022 through 1/31/2022
Date Issued Payee Amount Description
Check Total: 6,467.50
01/31/2022 LEAGUE OF CALIFORNIA CITIES 20,859.00 LEAGE OF CA CITIES MEMBERSHIP 2022
01/31/2022 LYNX TECHNOLOGIES, INC. 4,500.00 GIS CONSULTING SERVICES FY21-22
01/31/2022 OPEN HEART KITCHEN 8,500.00 HUMAN SERVICES GRANT OCT-DEC 2021
01/31/2022 PETIT, CHRISTINE 67.20 REC CLASS INSTRUCTOR
01/31/2022 PG&E 43,120.15 SERVICE TO 01/04/2022 7,777.69 SERVICE TO 01/05/2022
Check Total: 50,897.84
01/31/2022 QUINCY ENGINEERING 7,905.00 BRIDGE & STRUCTURE ASSET INSPECTION PH1
01/31/2022 SHAMROCK OFFICE SOLUTIONS, LLC 2,107.23 COPIER CHARGES
01/31/2022 SKATESATIONAL 540.00 REC CLASS INSTRUCTOR
01/31/2022 STATE WATER RESOURCES CONTROL 26,498.00 STATE WATER RESOURCES ANNUAL PERMIT FEE
01/31/2022 TREASURER ALAMEDA COUNTY 9,500.60 ANIMAL CONTROL FIELD SERVICES FY21-22 46,326.59 EAST COUNTY ANIMAL SHELTER SVCS FY21-22
Check Total: 55,827.19
01/31/2022 U.S. POSTAL SERVICE 3,994.70 POSTAGE FOR RENEWABLE ENERGY POSTCARDS
01/31/2022 U.S. POSTAL SERVICE 4,510.24 POSTAGE FOR 2022 SPRING ACTIVITY GUIDE &
Vendor Total: 8,504.94
01/31/2022 URBAN FIELD STUDIO 2,292.25 DOWNTOWN ARCHITECTURAL DESIGN SERVICES
01/31/2022 VALES, NORMAN 12.10 MILEAGE REIMBURSEMENT AUG 2021
01/31/2022 WESCO GRAPHICS INC 8,591.27 CITY REPORT & ACTIVITY GUIDE PRINTING
01/31/2022 WESTEK SYSTEMS INC. 7,215.00 AMAG SOFTWARE MAINT & SUPPORT
01/31/2022 WILLDAN HOMELAND SOLUTIONS 1,722,044.10 ENERGY EFFICIENCY/INFRASTRUCTURE IMPROV
01/31/2022 WILLIAM AVERY & ASSOCIATES INC 5,500.00 HUMAN RESOURCES RECRUITMENT SERVICES
Payments Issued 1/31/2022 Total: 2,061,605.03
Grand Total for Payments Dated 1/1/2022 through 1/31/2022: 13,690,767.41 Total Number of Payments Issued: 269
185