Loading...
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