Loading...
HomeMy WebLinkAbout4.6 City Treasurer's Informational Report of Investments for the Quarter Ending September 30, 2022CELEBRATING STAFF REPORT CITY COUNCIL DUBLIN CALIFORNIA Agenda Item 4.6 DATE: November 15, 2022 TO: Honorable Mayor and City Councilmembers FROM: Linda Smith, City Manager SU B.ECT : City Treasurer's Informational Report of Investments for the Quarter Ending September 30, 2022 Prepared by: Chris Rhoades, Financial Analyst EXECUTIVE SUMMARY: The City Council will receive an informational report of the City's investments through the quarter ending September 30, 2022 including a monthly transaction ledger. The City's investment portfolio for this period totaled $363,439,614 (market value) with an average market yield of 3.66%. As required by the Policy, the City Treasurer (Administrative Services Director) affirms that the City is able to meet its expenditure requirements for the next six months. STAFF RECOMMENDATION: Receive the City Treasurer's Informational Report of Investments for the Quarter Ending September 30, 2022. FINANCIAL IMPACT: There is no financial impact resulting from this report. Investments are made in accordance with the City Investment Policy and State Law. Interest earned is apportioned between funds (i.e., General Fund, Gas Tax Fund, etc.) based upon their proportionate share of the total cash balance. Based on the financial needs of the City including the timing of revenues and expenditures, the quarterly cash balance can vary from quarter to quarter. DESCRIPTION: The total investment portfolio (market value) consists of $234,031,649 managed by Chandler Asset Management (Chandler), and $129,407,965 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 4.47% and 2.21% respectively. Page 1 of 4 52 The total investment portfolio balance fluctuates throughout the year due to normal cash flow needs and includes both discretionary and restricted funds. Economic Update Highlights The following are some highlights from the Economic Update included in the Investment Report prepared by Chandler (Attachment 1). Market volatility has intensified as financial conditions tighten and global central banks pursue monetary policies to combat persistently high inflation and maintain financial market stability. Labor markets and consumer balance sheets remain strong; however, inflation is weighing heavily on consumer sentiment and beginning to impact discretionary spending. Corporate earnings have generally performed better than expected, but warnings are growing along with wider credit spreads. While evidence of slower economic conditions has begun to mount, Chandler expects the Federal Reserve to continue to raise rates until a sustainable improvement in inflationary conditions has been achieved. City of Dublin Portfolio The City's aggregate portfolio has maintained a healthy balance of investment types with minimal change from the prior quarter as shown below in Chart 1. US Treasury 18.2% Supranational 4.5% Chart 1: Investments by Type September 30, 2022 and June 30, 2022 September 30, 2022 ABS 7.6% Agency 14.7% Negotiable CD CMO 0.7% 1.1% Money Market Fund 0.1% Local Gov Investment Pool 21.6% LAIF 14.0% Corporate 17.5% Supranational 5.1% Negotiable CD 0.7% Money Market Fund 0.8% Local Gov Investment Pool 23.6% US Treasury 16.6% lune 30, 2022 LA!F 13.4% ABS 7.1% Agency 15.0% CMO Corporate 16.7% The market value of the City's portfolio decreased by $14,869,240 from the June 30, 2022 quarter. The quarterly change results from the normal fluctuations in the timing of incoming revenue, predominantly property tax allocations 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 $35.3 million from the same quarter the prior year due to the excess of revenues over Page 2 of 4 53 expenditures trending on an annual basis (see Table 1 below). Overall market yield to maturity (YTM) has increased to 3.66% over the prior quarter's 2.48% (shown in Table 2). For detailed monthly transactions, see Attachment 2. Table 1: Portfolio Values and YTM Holdings September 30, 2021 Market Value June 30, 2022 Market Value September 30, 2022 Par Value Book Value Market Value % of Subtotal % of Total Portfolio Book Yield Market Yield Managed by City LAIF 50,364,764 50,464,181 50,558,661 50,558,661 50,558,661 39.1% 13.4% 1.60% 1.60% CAMP 43,129,270 89,240,308 78,684,623 78,684,623 78,684,623 60.9% 20.8% 2.61% 2.61% SUBTOTAL 93,494,034 139,704,489 129,243,283 129,243,283 129,243,283 100.00% 34.2036r 2.21% 2.21% Accrued Interest 27,810 86,800 164,681 93,521,844 139,791,289 129,407,964 Managed by Chandler ABS 13,665,558 26,693,153 28,778,391 28,775,854 27,760,436 11.9% 7.6% 1.62% 4.73% Agency 65,306,279 56,641,842 55,820,000 56,021,008 53,062,995 22.8% 14.8% 1.56% 4.30% CMO 2,138,464 3,966,300 4,000,000 4,167,896 3,839,610 1.6% 1.1% 1.35% 4.58% Money Market 809,873 3,039,481 286,323 286,323 286,323 0.1% 0.1% 2.45% 2.45% Negotiable CD 2,500,588 2,486,275 2,500,000 2,500,005 2,497,243 1.1% 0.7% 0.25% 3.09% Supranational 22,656,506 19,403,787 18,240,000 18,214,595 16,428,894 7.0% 4.8% 0.67% 4.34% Corporate 57,831,563 62,892,216 67,775,000 68,097,532 63,373,439 27.2% 17.9% 2.06% 4.85% US Treasury 68,951,352 62,468,441 71,250,000 70,819,660 65,877,816 28.3% 18.9% 1.75% 4.20% SUBTOTAL 233,860,181 237,591,496 248,649,714 248,882,873 233,126,756 100.00% 65.80% 1.68% 4.47% Accrued Interest 746,077 926,068 904,893 234,606,258 238,517,564 234,031,649 TOTAL PORTFOLIO 328,128,102 378,308,853 377,892,997 378,126,157 363,439,614 100.00% 3.66% Change from Prior Year 35,311,511 Change from Prior Quarter (14,869,240) Table 2: Quarterly Holdings (Market Value) by Type, and YTM, 5 Quarters Holdings (Market Value) LAI F/CAMP ABS Agency CMO Money Market Negotiable CD Supranational Corporate US Treasury Accrued Interest TOTAL YIELD TO MATURITY 9/30/21 12/31/21 3/31/22 6/30/22 93, 494, 034 149,433,475 130,086, 317 139, 704, 489 13,665,558 14,715,444 22,814,841 26,693,153 65, 306, 279 64, 567,126 57, 293, 846 56, 641, 842 2,138,464 2,102, 544 4,052, 552 3,966,300 809,873 287,150 632,736 3,039,481 2,500,588 4,996,560 4,978,673 2,486,275 22, 656, 506 22, 424, 573 19, 609, 525 19, 403, 787 57,831,563 56,130,717 66,644,264 62,892,216 68,951,352 66,952,848 63,976,891 62,468,441 773,887 912,441 816,458 1,012,868 328,128,102 382,522,878 370,906,101 378,308,853 0.44% 0.60% 1.62% 2.48% 9/30/22 129, 243, 283 27, 760, 436 53, 062, 995 3,839,610 286,323 2,497,243 16, 428, 894 63, 373, 439 65, 877, 816 1,069,574 363,439,614 3.66% 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 table below presents the most recent quarterly portfolio Page 3 of 4 54 yields. Table 3: Quarterly Portfolio Yields, Recent 8 Quarters Market Yield LAIF CAMP Chandler 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% 3/31/22 0.42% 0.07% 2.38% 6/30/22 0.94% 1.40% 3.20% 9/30/22 1.60% 2.61% 4.47% STRATEGIC PLAN INITIATIVE: None. NOTICING REQUIREMENTS/PUBLIC OUTREACH: The City Council Agenda was posted. ATTACHMENTS: 1) City of Dublin Investment Report for Period Ending September 30, 2022 2) Transaction Ledger - July through September 2022 Page 4 of 4 55 Attachment I INVESTMENT REPORT City of Dublin Period Ending September 30, 2022 CMCHANDER ASSET MANAGEMENT CHANDLER ASSET MANAGEMENT, INC. 1800.317.4747 I www.chandlerasset.com 56 _ i ITable of Contents SECTION 1 SECTION 2 SECTION 3 SECTION 4 SECTION 5 Economic Update Account Profile Consolidated Information Portfolio Holdings Transactions As of September 30, 2022 1 CA% 57 Section 1 I Economic Update Economic Update • Market volatility has intensified as financial conditions tighten and global central banks pursue monetary policies to combat persistently high inflation and maintain financial market stability. Labor markets and consumer balance sheets remain strong; however, inflation is weighing heavily on consumer sentiment and beginning to impact discretionary spending. Corporate earnings have generally performed better than expected, but warnings are growing along with wider credit spreads. While evidence of slower economic conditions has begun to mount, we expect the Federal Reserve to continue to raise rates until a sustainable improvement in inflationary conditions has been achieved. Over the near -term, we expect financial market volatility to remain intensified and conditions tighter with persistent inflation, geopolitical risk, and the Fed's hawkish monetary policy. • At the September meeting, the Federal Open Market Committee (FOMC) delivered the third 75-basis point increase to the Fed Funds Rate, increasing the range to 3.00% to 3.25%. The FOMC acknowledged spending and production are experiencing modest growth, offset by a robust labor market and elevated inflation metrics. We expect the Fed to continue to increase the federal funds rate in the near term until inflationary pressures weaken. • In September, yields rose significantly across the curve. The 2-year Treasury yield increased 79 basis points to 4.28%, the 5- year Treasury yield rose 74 basis points to 4.09%, and the 10-year Treasury yield gained 64 basis points to 3.83%. The spread between the 2-year Treasury yield and 10-year Treasury yield became more inverted at -45 basis points at September month -end versus -30 basis points at August month -end. The spread was a positive 121 basis points one year ago. The spread between 3-month and 10-year treasuries widened to 56 basis points in September compared to just 27 basis points in August. The shape of the curve does not necessarily indicate an imminent recession but bears watching as a better predictor of recession over the medium -term. MOM Change In (000's) Employment 1,400 1,200 1,000 800 600 400 200 0 -200 Nonfarm Payroll (000's) —Non-farm Payroll (000's) 3 month average (000's) O O ,l 1 •1 1 Source: US Department of Labor 16.0% — 12.0% 4.0% 0.0% Unemployment Rate Underemployment Rate (U6) Unemployment Rate (U3) s%, OPc� li o ✓4� i,s % 'c ✓4h, SPp� O O ,l ,Z 1 1 ,) Source: US Department of Labor The U.S. economy added 263,000 jobs in September, surpassing market expectations of 255,000, and gains were revised upward by 11,000for the prior two months. Trends in employment remain strong, with the three-month moving average payrolls at 372,000 and the six-month moving average at 360,000. Hiring was widespread, with solid increases in education and health services, leisure and hospitality, and professional and business services. The unemployment rate fell to 3.5% from 3.7%, as the labor participation rate edged down to 62.3% in September from 62.4% in August. The U-6 underemployment rate, which includes those who are marginally attached to the labor force and employed part time for economic reasons dropped to 6.7% from 7.0% last month. Average hourly earnings rose 5.0% year -over -year in September compared to 5.2% year -over -year in August, a constructive development for the inflation outlook. The strong September labor report bolsters the case for the Fed to continue raising the federal funds rate. 4 CM 60 YOY( %) Change Inflation 10.0% 9.0% 8.0% 7.0% 6.0% 5.0% 4.0% 3.0% 2.0% 1.0% 0.0% Consumer Price Index (CPI) CPI YOY % Change Core CPI YOY % Change Pp` ooe /J�dr ✓4•` SPA O�°�, �ar, ✓4).SPp c)p �p �1 �1 �1 �1 �� Source: US Department of Labor YOY( %) Change 10.0% 9.0% 8.0% 7.0% 6.0% 5.0% 4.0% 3.0% 2.0% 1.0% 0.0% Personal Consumption Expenditures (PCE) PCE Price Deflator YOY % Change PCE Core Deflator YOY % Change l4g�0 �oG�O ' 6. �OA 9�g�1 �oG�1 �Pb�� fop gc)) Source: US Department of Commerce The Consumer Price Index (CPI) increased more than expected in September, up 8.2% year -over -year versus consensus expectations for8.1%, but down slightly from 8.3% in August. The Core CPI, which excludes volatile food and energy components, jumped to 6.6% year -over -year, up from 6.3% in August and the highest level since 1982. The report included widespread increases, particularly in food, shelter, and medical care services. Owners' equivalent rent, which is a major contributor to CPI and tends to lag, was up 6.7% year -over -year. The Personal Consumption Expenditures (PCE) index rose 6.2% in August, higher than consensus estimates of up 6.0%, but down from a 6.4% increase last month. Core PCE was up 4.9% year -over -year in August, versus up 4.7% year -over -year in July. Persistently elevated inflation is likely to keep the Federal Reserve on the path of tightening monetary policy as long as it continues to run well above the Fed's longer -run target of around 2.0%. 5 CM 61 YOY (%) Change Consumer 60.0% 50.0% 40.0% 30.0% 20.0% 10.0% 0.0% Retail Sales YOY % Change nail 1111111111111ll s)O c)O c)l `'1 `)1 `)1 �s) ` or /4)c) s)c) 140 130 120 au J 110 x QJ c 100 90 80 Consumer Confidence ,)O ,b ,31 �1 c'1 �1 �c �� �,.) Source: US Department of Commerce Source: The Conference Board Advance retail sales were flat for the month but up 8.2% year -over -year in September, slowing from August's 9.4% year -over -year gain that surprised to the upside. Retail sales growth is starting to reflect the headwinds from higher prices as consumers dip into savings and assume more debt. The Conference Board's Consumer Confidence Index rose for the second month in a row to 108.0 in September, with gains in both the present situation and future expectations components. The strength was tied directly to the consumer's assessment of the labor market, which continues to reflect the demand for labor outstripping supply. 6 CA% 62 MOM (%) Change Economic Activity 1.2% 1.0% 0.8% 0.6% 0.4% 0.2% 0.0% - 0.2% -0.4% - 0.6% -0.8% Leading Economic Indicators (LEI) �4g ti0G �o �o Source: The Conference Board �d` -Toe c31 c1 0,4 3 Month Average 4.00 3.00 2.00 1.00 0.00 - 1.00 - 2.00 Chicago Fed National Activity Index (CFNAI) Source: Federal Reserve Bank of Chicago The Conference Board's Leading Economic Index (LEI) remained in negative territory at -0.3% in August, following a decline to -0.5% in July. This is the sixth straight month -over -month decline for the index. With the year -over -year index now at -1.0% in August and average workweek in manufacturing having contracted for four of the last six months, the Conference Board stated that US economic activity is expected to continue to slow more broadly and is likely to contract. The Chicago Fed National Activity Index (CFNAI) fell to zero in August from +0.29 in July indicating a moderation in economic growth over the month. On a 3-month moving average basis, the CFNAI increased to 0.01 in August from -.08 in each of the last two months. MOM Change (In Thousands of Units) Housing 2000 1800 1600 1400 1200 1000 800 600 400 200 0 1,6, 4' i) c'O Housing Starts is ob-,) 1 Source: US Department of Commerce Multi Family Housing Starts • Single Family Housing Starts I�_ 4'd` �, �b ,1 c.)1 �1 is 06 YOY( %) Change 24.0% 21.0% 18.0% 15.0% 12.0% 9.0% 6.0% 3.0% 0.0% S&P/Case-Shiller 20 City Composite Home Price Index ✓4/�O Occ� ✓a�� - ✓�/�1 OCR( ✓a�� 9pr� O 1 1 1 ,, Source: S&P Total housing starts increased 12.2% to an annual rate of 1,575,000 in August, from a revised 1,404,000 units in July. Single-family home starts increased 3.4% and multi -family homes increased 28% month -over -month. On a year -over -year basis, total housing starts decreased 0.1% reflecting a shift from single-family units to more affordable multi -family units as homebuyers struggle with a combination of elevated prices and higher mortgage rates. Mortgage rates for a 30-year fixed-rate loan are higher than they have been since 2007 at 6.7%. According to the Case-Shiller 20-City Home Price Index, the year -over -year increase receded from 18.7% in June to 16.1% in July, clearly displaying the impact of higher mortgage rates which have reduced demand for homebuying as affordability has declined. 8 CM 64 66 64 62 60 58 56 54 52 50 48 46 44 42 40 Manufacturing Institute of Supply Management Purchasing Manager Index EXPAN DING CONTRACTING S O OPc�O 2fd�� ✓4 s . 1 Source: Institute for Supply Management 0,0 c) 20.0% 15.0% -5.0% -10.0% Source: Federal Reserve Industrial Production The Institute for Supply Management (ISM) manufacturing index plunged nearly two points to 50.9 in September, the lowest since May 2020 and disappointing relative to consensus expectations of 52.0. Readings above 50.0 are indicative of expansion in the manufacturing sector. New orders declined significantly, reflecting lower demand for goods as consumers shift to spending on services. Total industrial production declined by -0.2% in August, following a downwardly revised increase of 0.5% in July. Capacity utilization fell to 80.0% in August from 80.2% in July, a rate that is 0.4 percentage points above its long -run (1972-2021) average. 9 CM 65 Gross Domestic Product (GDP) Components of GDP 9/21 12/21 3/22 6/22 Personal Consumption Expenditures 2.0% 2.1% 0.9% 1.4% Gross Private Domestic Investment 1.8% 5.1% 1.0% -2.8% Net Exports and Imports -1.1% -0.2% -3.1% 1.2% Federal Government Expenditures -0.5% 0.0% -0.4% -0.2% State and Local (Consumption and Gross Investment) 0.5% -0.2% 0.0% -0.1% 40.0% 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 Q0Q % Change -GDP YOY % Change . - Total 2.7% 7.0% -1.6% -0.6% `92, �°c, ✓'1/), �°c, "''). �°c, ✓�''�. �°c, "''/. ��°c, ✓`'/1, 1j dj 1) 1s'79 79 cDO c3p �7 c, j c) Source: US Department of Commerce Source: US Department of Commerce According to the third estimate, U.S. GDP was unrevised at -0.6% annualized in the second quarter. Personal consumption expenditures rose, primarily due to spending on services. The largest negative contribution was from a drop in gross residential investment as the housing sector diminished sharply. The second quarter decline followed a first quarter contraction of -1.6%. Although many market participants link two quarters in a row of negative GDP growth with a recession, an official declaration by the National Bureau of Economic Research is unlikely given the mosaic of data and the strength of the labor market. The consensus estimate calls for 1.9% growth in the third quarter and 1.7% growth for the full year 2022. 10 CM 66 Federal Reserve 10,000,000 9,000,000 8,000,000 7,000,000 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 Federal Reserve Balance Sheet Assets O'9 Ot9 O� O� 0 0 O� Ot O� O� 0 0 O_ c0 c1 c1 c1 c1 c1 c1 c1 c1 c1 c1 cc c„ 9 O 1 � .�' 9 •S 6 •� 8 9 O Source: Federal Reserve 3.50% 3.00% 2.50% 2.00% w 1.50% 1.00% 0.50% 0.00% Effective Federal Funds Rate t 'Loy t +o1 tio� 4/o� ik) �'o1 ti0 . t 4/oze 10 11 1� 1� 1Q 1s 16. 1> 1� �1 Source: Bloomberg At the September meeting, the Federal Open Market Committee (FOMC) delivered the third 75-basis point increase to the Fed Funds Rate, increasing the range to 3.00% to 3.25%. The FOMC acknowledged spending and production are experiencing modest growth, offset by robust labor market and elevated inflation metrics. The FOMC remains data dependent to meet its long-term 2% inflation objective. The Fed also released new economic projections showing a significant slowdown in the economy later in 2022 and 2023. The Fed has reduced its $9 trillion balance sheet holdings by $87.1 billion since the start of the program and will increase the rate of decrease to $95 billion a month in September. As inflation metrics begin to moderate, we believe the Federal Reserve will decelerate their pace of tightening, but a material decline in inflation in the short-term is unlikely. 11 CM 67 13 v Bond Yields 4.5% 4.0% 3.5% 3.0% 2.5% 2.0% 1.5% 1.0% 0.5% 0.0% • US Treasury Note Yields 2-Year 5-Year 10-Year S0�✓S0°�d1. ✓SPA°4�P c, p �'� Pp c)O �,7 `1 �,I N1 c)� c),) Source: Bloomberg 0 v 4.5% 4.0 % 3.5% 3.0% 2.5% 2.0% 1.5% 1.0% 0.5% 0.0 % US Treasury Yield Curve `))/1 �o �1r Syr Source: Bloomberg ,y~ 10 Sep-22 Jun-22 Sep-21 •loy At the end of September, the 2-year Treasury yield was 400 basis points higher, and the 10-Year Treasury yield was about 234 basis points higher, year -over -year. The spread between the 2-year Treasury yield and 10-year Treasury yield became more inverted at -45 basis points at September month -end versus -30 basis points at August month -end. The average historical spread (since 2003) is about 130 basis points. The spread between 3-month and 10-year treasuries widened to 56 basis points in September compared to just 27 basis points in August. The shape of the yield curve does not indicate an imminent recession but bears watching as a better predictor of recession over the medium -term. 12 CM 68 Section 2 I Account Profile Objectives As of September 30, 2022 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. 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 BofA 1-5 Year Treasury and Agency Index. 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. 14 a 70 Compliance Category U.S. Treasury Issues Federal Agencies Municipal Securities Supra national Securities Asset -Backed Securities/Mortgage- Backed Securities/ Collateralized Mortgage Obligations As of September 30, 2022 City of Dublin Assets managed by Chandler Asset Management are in full compliance with state law and with the City's investment policy. Standard No limitations; Full faith and credit of the U.S. are pledged for payment of principal and interest. 35% max per agency issuer; 25% max cal lables 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. "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; "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 ("I BRD"), the International Finance Corporation ("I FC") or the Inter -American Development Bank ("IADB") Corporate Medium Term Notes Negotiable Certificates of Deposit Time Deposits/ Certificates of Deposit Commercial Paper Banker's Acceptances Money Market Mutual Funds and Mutual Funds Local Agency Investment Fund (LAIF) California Asset Management Program (CAMP) Prohibited Securities Max Per Issuer Maximum Maturity "AA" rated or higher by a NRSRO; 20% maximum (combined); 5% max per issuer "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. "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- Iicensed branch of a foreign bank. 10% maximum; Collateralized/FDIC Insured; 1 year max maturity "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 collateral ization, LOC, or surety bond, (3) "A-1" rated or higher by a NRSRO "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 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 Maximum permitted by LAIF; Not used by investment adviser Issued by joint powers authority organized pursuant to California Government Code; Not used by investment adviser 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. 5% max per issuer, except US Government, its Agencies and instrumentalities (including agency backed -mortgage pools), Supra national securities, or Money Market Mutual Funds 5 years, unless otherwise stated in the policy Comment Complies Complies Complies Complies Complies Complies Complies Complies Complies Complies Complies Complies Complies Complies Complies Complies 15 CM 71 Portfolio Characteristics City of Dublin As of September 30, 2022 09/30/22 06/30/22 Benchmark* Portfolio Portfolio Average Maturity (yrs) Average Modified Duration Average Purchase Yield Average Market Yield Average Quality** Total Market Value 2.60 2.48 n/a 4.26% AAA 2.73 2.39 1.68% 4.47% AA/Aa1 234,031,649 2.69 2.39 1.57% 3.20% AA/Aa 1 238,517,564 *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. 16 CM 72 I Sector Distribution US Treasury 28.3% Supranational 7.0 % Negotiable CD 1.1% Money Market Fund 0.1% September 30, 2022 Corporate 27.2% ABS 11.9% CMO 1.6% Agency 22.8% City of Dublin US Treasury 26.3% Supranational 8.2% Negotiable CD 1.0% Money Market Fund 1.3% June 30, 2022 Corporate 26.5% As of September 30, 2022 ABS 11.2% CMO 1.7% Agency 23.9% 17 CM 73 Issuers City of Dublin - Account #10198 As of September 30, 2022 Issue Name Investment Type % Portfolio Government of United States Federal National Mortgage Association Federal Home Loan Bank Federal Home Loan Mortgage Corp Inter -American Dev Bank Intl Bank Recon and Development Federal Farm Credit Bank Hyundai Auto Receivables John Deere ABS Federal Home Loan Mortgage Corp JP Morgan Chase & Co Bank of America Corp Amazon.com Inc Honda Motor Corporation Royal Bank of Canada Toronto Dominion Holdings Toyota Lease Owner Trust Apple Inc Qualcomm Inc Morgan Stanley Metlife Inc Honda ABS GM Financial Automobile Leasing Trust Svenska Handelsbanken NY US Bancorp Northwestern Mutual Glbl Caterpillar Inc Chubb Corporation Honeywell Corp Hyundai Auto Lease Securitization Toyota Motor Corp Bank of Montreal Chicago American Express ABS Berkshire Hathaway Wal-Mart Stores Deere & Company GM Financial Securitized Term Auto Trust United Health Group Inc US Treasury Agency Agency Agency Supranational Supranational Agency ABS ABS CMO Corporate Corporate Corporate Corporate Corporate Corporate ABS Corporate Corporate Corporate Corporate ABS ABS Negotiable CD Corporate Corporate Corporate Corporate Corporate ABS Corporate Corporate ABS Corporate Corporate Corporate ABS Corporate 28.27% 8.52% 7.33% 4.22% 3.87% 3.17% 2.70% 1.80% 1.67% 1.65% 1.64% 1.51% 1.47% 1.44% 1.42% 1.34% 1.29% 1.26% 1.26% 1.20% 1.17% 1.15% 1.12% 1.07% 1.05% 1.05% 1.05% 1.03% 0.99% 0.97% 0.93% 0.91% 0.91% 0.89% 0.84% 0.83% 0.76% 0.76% 18 CM 74 Issuers City of Dublin — Account #10198 As of September 30, 2022 Issue Name Investment Type % Portfolio Charles Schwab Corp/The BMW Vehicle Lease Trust PNC Financial Services Group Target Corp Bank of New York Mercedes-Benz Auto Lease Trust Dominion Resources Inc Verizon Master Trust BMW ABS Guardian Life Global Funding Toyota ABS Salesforce.com Inc Nissan ABS First American Govt Oblig Fund Corporate ABS Corporate Corporate Corporate ABS Corporate ABS ABS Corporate ABS Corporate ABS Money Market Fund 0.74% 0.61% 0.52% 0.52% 0.51% 0.47% 0.41% 0.39% 0.35% 0.30% 0.22% 0.19% 0.15% 0.12% TOTAL 100.00% 19 CM 75 Quality Distribution 70.0% 60.0% 50.0% 40.0% 30.0% 20.0% 10.0% 0.0% 1 AAA City of Dublin September 30, 2022 vs. June 30, 2022 AA ■ 09/30/22 1 <A 06/30/22 NR As of September 30, 2022 AAA AA A <A NR 09/30/22 06/30/22 18.3% 20.4% 59.1% 56.6% 18.8% 19.7% 0.4% 0.4% 3.4% 3.0% Source: S&P Ratings 20 CM 76 I Duration Distribution 40.0% 35.0% 30.0% 25.0% 20.0% 15.0% 10.0% 5.0% 0.0% 0-0.25 0.25-0.50 City of Dublin Portfolio Compared to the Benchmark 0.50-1 1-2 ■ City of Dublin 2-3 3-4 As of September 30, 2022 4-5 5+ ICE BofA 1-5 Yr US Treasury & Agency Index 0-0.25 0.25-0.50 0.50-1 1-2 2-3 3-4 4-5 5+ Portfolio Benchmark* 1.3% 0.0% 0.3% 0.0% 10.0% 1.8% 29.6% 37.2% 29.1% 26.6% 17.2% 20.9% 12.3% 13.5% 0.0% 0.0% *ICE BofA 1-5 Yr US Treasury & Agency Index 21 CM 77 Investment Performance 2.00% 1.00% 0.00% -1.00% - 2.00% - 3.00% -4.00% -5.00% - 6.00% - 7.00% -8.00% City of Dublin Total Rate of Return Annualized Since Inception October 31, 2013 12 months 2 years 3 years 5 years As of September 30, 2022 Em 10 years Since Inception • City of Dublin ICE BofA 1-5 Yr US Treasury & Agency Index* Annualized TOTAL RATE OF RETURN 3 months 12 months 2 years 3 years 5 years 10 years Since Inception City of Dublin -1.89% -6.32% -3.25% -0.69% 0.62% N/A 0.84% ICE BofA 1-5 Yr US Treasury & Agency Index* -2.27% -6.78% -3.63% -0.97% 0.39% N/A 0.63% *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. 22 CM 78 Portfolio Characteristics City of Dublin Reporting Account As of September 30, 2022 09/30/22 Portfolio 06/30/22 Portfolio Average Maturity (yrs) 0.00 Modified Duration 0.00 Average Purchase Yield 2.21% Average Market Yield 2.21% Average Quality* AAA/NR Total Market Value 129,407,964 0.00 0.00 1.23% 1.23% AAA/N R 139,791,289 *Portfolio is S&P and Moody's, respectively. 23 CM 79 Sector Distribution City of Dublin Reporting Account September 30, 2022 June 30, 2022 LAIF 39.2% Local Gov Investment Pool 60.8% Local Gov Investment Pool 63.8% As of September 30, 2022 LAIF 36.2% Issuers City of Dublin Reporting Account — Account #10219 As of September 30, 2022 Issue Name Investment Type % Portfolio CAM P Local Agency Investment Fund Local Gov Investment Pool LAIF 60.80% 39.20% TOTAL 100.00% 25 CM 81 Section 3 I Consolidated Information 26 a 82 Portfolio Characteristics City of Dublin Consolidated As of September 30, 2022 g• Average Maturity (yrs) 1.76 1.70 Modified Duration 1.54 1.51 Average Purchase Yield 1.86% 1.45% Average Market Yield 3.66% 2.48% Average Quality* AA+/Aa1 AA+/Aa1 Total Market Value 363,439,614 378,308,853 * Portfolio is S&P and Moody's respectively. 27 C►" 83 I Sector Distribution US Treasury 18.2% Supranational 4.5% Negotiable CD 0.7% Money Market Fund 0.1% Local Gov Investment Pool 21.6% September 30, 2022 LAI F 14.0% ABS 7.6% City of Dublin Consolidated Agency 14.7% CMO Corporate 17.5% Supranational 5.1% Negotiable CD 0.7% Money Market Fund 0.8% Local Gov Investment Pool 23.6% US Treasury 16.6% June 30, 2022 LAIF 13.4% As of September 30, 2022 ABS 7.1% Agency 15.0% CMO Corporate 16.7% 28 C►" 84 Section 4 I Portfolio Holdings Holdings Report City of Dublin - Account #10198 As of September 30, 2022 CUSIP Security Description Par Value/Units Purchase Date Cost Value Mkt Price Market Value % of Port. Moody/S&P Maturity Book Yield Book Value Mkt YTM Accrued Int. Gain/Loss Fitch Duration ABS 44891VAC5 Hyundai Auto Lease Trust 2021-B A3 0.330% Due 06/17/2024 65479JAD5 Nissan Auto Receivables Owner 2019-C A3 1.930% Due 07/15/2024 89237VAB5 Toyota Auto Receivables Trust 2020-C A3 0.440% Due 10/15/2024 43813KAC6 Honda Auto Receivables Trust 2020-3A3 0.370% Due 10/18/2024 89239CAC3 Toyota Lease Owner Trust 2021-B A3 0.420% Due 10/21/2024 47787NAC3 John Deere Owner Trust 2020-B A3 0.510% Due 11/15/2024 58769KAD6 Mercedes-Benz Auto Lease Trust 2021-B A3 0.400% Due 11/15/2024 09690AAC7 BMW Vehicle Lease Trust 2021-2 A3 0.330% Due 12/26/2024 44891WAC3 Hyundai Auto Lease Trust 2022-AA3 1.160% Due 01/15/2025 89238LAC4 Toyota Lease Owner Trust 2022-AA3 1.960% Due 02/20/2025 36265MAC9 GM Financial Auto Lease Trust 2022-1 A3 1.900% Due 03/20/2025 05601XAC3 BMW Vehicle Lease Trust 2022-1 A3 1.100% Due 03/25/2025 36266FAC3 GM Financial Auto Lease Trust 2022-2 A3 3.420% Due 06/20/2025 47788UAC6 John Deere Owner Trust 2021-AA3 0.360% Due 09/15/2025 44933LAC7 Hyundai Auto Receivables Trust 2021-AA3 0.380% Due 09/15/2025 44934KAC8 Hyundai Auto Receivables Trust 2021-B A3 0.380% Due 01/15/2026 43815GAC3 Honda Auto Receivables Trust 2021-4A3 0.880% Due 01/21/2026 1,420,000.00 06/08/2021 1,419,787.00 0.34% 1,419,909.46 350,328.13 10/16/2019 350,309.64 1.94% 350,321.14 523,487.59 07/21/2020 523,447.29 0.44% 523,468.11 738,593.19 09/22/2020 738,484.69 0.38% 738,554.05 1,090,000.00 07/27/2021 1,089,985.28 0.40% 1,089,992.22 255,981.63 07/14/2020 255,942.62 0.52% 255,967.19 1,135,000.00 06/22/2021 1,134,914.31 0.40% 1,134,956.60 710,000.00 09/08/2021 709,926.73 0.34% 709,960.32 910,000.00 01/11/2022 909,979.89 1.16% 909,986.17 2,045,000.00 02/23/2022 2,044,678.12 1.98% 2,044,760.21 1,680,000.00 02/15/2022 1,679,985.55 1.91% 1,679,989.59 755,000.00 01/11/2022 754,887.13 1.05% 754,923.29 1,020,000.00 05/03/2022 1,019,893.61 3.45% 1,019,912.60 800,000.00 03/02/2021 799,846.24 0.37% 799,912.89 725,000.00 04/20/2021 724,923.73 0.20% 724,959.43 2,065,000.00 07/20/2021 2,064,544.25 0.39% 2,064,715.41 765,000.00 11/16/2021 764,838.74 0.89% 764,881.06 97.56 4.63% 99.62 3.76% 98.35 4.45% 97.82 4.54% 96.29 4.78% 98.05 4.85% 96.54 4.75% 97.15 4.51% 96.28 4.51% 96.40 4.67% 96.55 4.71% 96.29 4.76% 98.09 4.76% 96.11 4.92% 96.68 4.59% 95.32 4.99% 94.61 4.70% 1,385,380.40 208.27 349,002.14 300.50 514,871.44 102.37 722,502.20 98.68 1,049,562.09 139.88 250,993.83 58.02 1,095,750.57 201.78 689,754.36 39.05 876,141.63 469.16 1,971,384.09 1,224.73 1,622,068.56 975.33 726,963.08 138.42 1,000,540.44 1,065.90 768,848.00 128.00 700,905.35 122.44 1,968,362.13 348.76 723,776.45 187.00 0.59% Aaa / AAA (34,529.06) NR 0.15% Aaa/AAA (1,319.00) NR 0.22% Aaa / AAA (8,596.67) NR 0.31% NR/AAA (16,051.85) AAA 0.45% Aaa / NR (40,430.13) AM 0.11% Aaa / NR (4,973.36) AAA 0.47% NR/AAA (39,206.03) AAA 0.29% Aaa / NR (20,205.96) AAA 0.37% Aaa / AAA (33,844.54) NR 0.84% NR/AAA (73,376.12) AAA 0.69% Aaa / NR (57,921.03) AAA 0.31% NR/AAA (27,960.21) AAA 0.43% NR/AAA (19,372.16) AAA 0.33% Aaa / NR (31,064.89) AAA 0.30% NR / AAA (24,054.08) AAA 0.84% NR/AAA (96,353.28) AAA 0.31% Aaa / NR (41,104.61) AAA 1.72 0.57 1.79 0.21 2.04 0.41 2.05 0.52 2.06 0.86 2.13 0.45 2.13 0.80 2.24 0.68 2.30 1.12 2.39 1.35 2.47 1.24 2.48 1.02 2.72 1.46 2.96 0.86 2.96 0.79 3.30 1.02 3.31 1.43 30 CM 86 Holdings Report City of Dublin - Account #10198 As of September 30, 2022 CUSIP Security Description Par Value/Units Purchase Date Book Yield Cost Value Book Value Mkt Price Mkt YTM Market Value Accrued Int. % of Port. Moody/S&P Maturity Gain/Loss Fitch Duration 477890AC4 44935FAD6 43815BAC4 John Deere Owner Trust 2021-B A3 0.520% Due 03/16/2026 Hyundai Auto Receivables Trust 2021-CA3 0.740% Due 05/15/2026 Honda Auto Receivables Trust 2022-1 A3 1.880% Due 05/15/2026 05602RAD3 362554AC1 47787JAC2 448977AD0 380146AC4 362585AC5 47800AAC4 BMW Vehicle Owner Trust 2022-A A3 3.210% Due 08/25/2026 GM Financial Securitized Term 2021-4A3 0.680% Due 09/16/2026 John Deere Owner Trust 2022-AA3 2.320% Due 09/16/2026 Hyundai Auto Receivables Trust 2022-AA3 2.220% Due 10/15/2026 GM Financial Auto Receivables 2022-1 A3 1.260% Due 11/16/2026 GM Financial Securitized ART 2022-2 A3 3.100% Due 02/16/2027 John Deere Owner Trust 2022-B A3 3.740% Due 02/16/2027 965,000.00 545,000.00 1,315,000.00 850,000.00 585,000.00 1,005,000.00 1,080,000.00 500,000.00 780,000.00 1,045,000.00 07/13/2021 0.52% 11/09/2021 0.75% 02/15/2022 1.89% 05/10/2022 3.23% 10/13/2021 0.66% 03/10/2022 2.34% 03/09/2022 2.23% 01/11/2022 1.23% 04/05/2022 3.13% 07/12/2022 3.77% 964,913.92 964,942.14 544,878.36 544,911.85 1,314,802.22 1,314,839.19 849,955.80 849,961.10 584,985.08 584,989.22 1,004,777.69 1,004,812.28 1,079,958.42 1,079,965.39 499,956.55 499,965.68 779,836.98 779,859.25 1,044,900.20 1,044,905.78 94.50 4.71% 94.36 4.93% 95.03 4.81% 97.34 4.81% 94.24 5.04% 95.59 5.00% 95.93 4.62% 95.13 4.79% 96.93 4.92% 97.65 4.86% 911,950.09 223.02 514,284.35 179.24 1,249,652.39 1,098.76 827,404.45 454.75 551,311.61 165.75 960,727.74 1,036.27 1,036,028.88 1,065.60 475,668.51 262.50 756,064.14 1,007.50 1,020,487.44 1,737.02 0.39% (52,992.05) 0.22% (30,627.50) 0.53% (65,186.80) 0.35% (22,556.65) 0.24% (33,677.61) 0.41% (44,084.54) 0.44% (43,936.51) 0.20% (24,297.17) 0.32% (23,795.11) 0.44% (24,418.34) Aaa / NR AAA NR / MA AM Aaa / AAA NR Aaa / AAA NR Aaa / AAA NR Aaa / NR AM NR / MA AM NR / MA AM Aaa / AAA NR Aaa / NR AAA 3.46 1.33 3.62 1.37 3.62 1.73 3.90 1.70 3.96 1.34 3.96 1.67 4.04 1.72 4.13 1.40 4.38 1.72 4.38 2.16 02582JJT8 American Express Credit Trust 2022-2 A 3.390% Due 05/17/2027 92348KAV5 Verizon Master Trust 2022-5 A1A 3.720% Due 07/20/2027 TOTAL ABS Agency 313383QR5 3137EAEN5 3135G05G4 FHLB Note 3.250% Due 06/09/2023 FHLMC Note 2.750% Due 06/19/2023 FNMA Note 0.250% Due 07/10/2023 2,205,000.00 915,000.00 28,778,390.54 1,500,000.00 2,000,000.00 2,350,000.00 05/17/2022 3.42% 08/02/2022 3.75% 1.62% 2,204,512.25 2,204,570.58 914,959.74 914,961.77 28,774,812.03 28,775,853.97 96.77 2,133,778.50 0.91% 4.75% 3,322.20 (70,792.08) 99.05 906,270.90 0.39% 4.51% 1,040.05 (8,690.87) 27,760,435.76 11.87% 4.73% 17,400.95 (1,015,418.21) NR/AAA AM NR / MA AAA Aaa / AAA Aaa 08/28/2018 1,525,005.00 2.87% 1,503,596.71 07/16/2018 1,988, 360.00 2.88% 1,998,310.32 07/08/2020 2,344,947.50 0.32% 2,348,698.81 99.38 1,490,719.50 0.64% Aaa / AA+ 4.16% 15,166.67 (12,877.21) NR 98.93 1,978,596.00 0.85% Aaa / AA+ 4.27% 15,583.33 (19,714.32) AAA 97.13 2,282,498.60 0.98% Aaa /AA+ 4.04% 1,321.88 (66,200.21) AAA 4.63 2.44 4.81 1.79 3.15 1.32 0.69 0.67 0.72 0.70 0.78 0.76 31 CM 87 Holdings Report City of Dublin - Account #10198 As of September 30, 2022 CUSIP Security Description Par Value/Units Purchase Date Book Yield Cost Value Book Value Mkt Price Mkt YTM Market Value Accrued Int. % of Port. Moody/S&P Maturity Gain/Loss Fitch Duration 3133EKZK5 FFCB Note 1.600% Due 08/14/2023 4,000,000.00 08/26/2019 1.54% 4,009,000.00 4,001,970.30 97.68 4.33% 3,907,328.00 8,355.56 1.67% Aaa/AA+ (94,642.30) AAA 0.87 0.85 313383YJ4 FHLB Note 3.375% Due 09/08/2023 3130A0F70 FHLB Note 3.375% Due 12/08/2023 3135G0V34 3130A1XJ2 3133EKWV4 FNMA Note 2.500% Due 02/05/2024 FHLB Note 2.875% Due 06/14/2024 FFCB Note 1.850% Due 07/26/2024 5,000,000.00 5,000,000.00 2,000,000.00 3,795,000.00 2,500,000.00 3130A2UW4 3135G0W66 3135G0X24 3137EAEPO 3135G03U5 3135G04Z3 3137EAEU9 3135G05X7 3137EAEX3 3135G06G3 FHLB Note 2.875% Due 09/13/2024 FNMA Note 1.625% Due 10/15/2024 FNMA Note 1.625% Due 01/07/2025 FHLMC Note 1.500% Due 02/12/2025 FNMA Note 0.625% Due 04/22/2025 FNMA Note 0.500% Due 06/17/2025 FHLMC Note 0.375% Due 07/21/2025 FNMA Note 0.375% Due 08/25/2025 FHLMC Note 0.375% Due 09/23/2025 FNMA Note 0.500% Due 11/07/2025 2,000,000.00 2,000,000.00 4,200,000.00 4,200,000.00 1,825,000.00 3,435,000.00 1,745,000.00 2,755,000.00 2,655,000.00 2,860,000.00 Various 2.90% Various 2.73% 02/27/2019 2.58% Various 1.96% 08/13/2019 1.65% 10/10/2019 1.58% 11/08/2019 1.80% Various 1.18% Various 1.23% 04/22/2020 0.67% 06/17/2020 0.54% 07/21/2020 0.48% 08/25/2020 0.47% 09/23/2020 0.44% 11/09/2020 0.57% TOTAL Agency 55,820,000.00 1.56% 5,102,615.00 5,020,452.36 5,147,870.00 5,035,645.22 1,992,340.00 1,997,909.75 3,958,639.85 3,850,833.29 2,524,140.00 2,508,865.58 2,122,020.00 2,048,360.34 1,983,400.00 1,993,125.63 4,287,898.80 4,241,262.02 4,254,786.30 4,226,264.29 1,821,240.50 1,823,074.91 3,427,889.55 3,431,140.71 1,736,309.90 1,740,121.35 2,742,106.60 2,747,514.19 2,647,008.45 2,650,233.11 2,849,761.20 2,853,629.57 56,465,338.65 56,021,008.46 99.10 4.36% 98.80 4.42% 97.59 4.36% 97.52 4.40% 95.59 4.40% 97.26 4.35% 94.91 4.25% 94.36 4.26% 93.94 4.22% 91.14 4.32% 90.39 4.29% 89.73 4.30% 89.43 4.29% 89.25 4.25% 89.07 4.30% 4.30% 4,955,135.00 10,781.25 4,939,765.00 52,968.75 1,951,882.00 7,777.78 3,700,713.23 32,428.80 2,389,677.50 8,350.69 1,945,150.00 2,875.00 1,898,244.00 14,986.11 3,963,023.40 15,925.00 3,945,324.61 8,575.00 1,663,315.95 5,037.76 3,105,044.21 4,961.67 1,565,776.29 1,272.40 2,463,785.48 1,033.13 2,369,643.26 221.25 2,547,373.40 5,720.00 53,062,995.43 213,342.03 2.12% (65,317.36) 2.13% (95,880.22) 0.84% (46,027.75) 1.60% (150,120.06) 1.02% (119,188.08) 0.83% (103,210.34) 0.82% (94,881.63) 1.70% (278,238.62) 1.69% (280,939.68) 0.71% (159,758.96) 1.33% (326,096.50) 0.67% (174,345.06) 1.05% (283,728.71) 1.01% (280,589.85) 1.09% (306,256.17) 22.76% (2,958,013.03) Aaa / AA+ NR Aaa / AA+ AAA Aaa / AA+ AAA Aaa / AA+ NR Aaa / AA+ AAA Aaa / AA+ AAA Aaa / AA+ AAA Aaa / AA+ AAA Aaa / AA+ AAA Aaa / AA+ AAA Aaa / AA+ AAA Aaa / AA+ AAA Aaa / AA+ AAA Aaa / AA+ AAA Aaa / AA+ AM Aaa / AA+ Aaa 0.94 0.91 1.19 1.14 1.35 1.30 1.71 1.63 1.82 1.76 1.96 1.87 2.04 1.96 2.27 2.18 2.37 2.28 2.56 2.48 2.72 2.64 2.81 2.73 2.90 2.83 2.98 2.90 3.11 3.01 1.82 1.76 32 CM 88 Holdings Report City of Dublin - Account #10198 As of September 30, 2022 CUSIP Security Description Par Value/Units Purchase Date Cost Value Mkt Price Market Value % of Port. Moody/S&P Maturity Book Yield Book Value Mkt YTM Accrued Int. Gain/Loss Fitch Duration CMO 3137BFE98 FHLMC K041 A2 3.171% Due 10/25/2024 3137BSRE5 FHLMC K059 A2 3.120% Due 09/25/2026 TOTAL CMO 2,000,000.00 07/01/2021 2,151,406.25 0.72% 2,093,636.18 2,000,000.00 02/18/2022 2,085,625.00 1.98% 2,074,260.23 97.23 4.58% 94.75 4.58% 1,944,576.00 5,285.00 1,895,034.00 5,200.00 0.83% (149,060.18) 0.81% (179,226.23) Aaa / AAA AAA NR/AAA AAA 2.07 1.87 3.99 3.57 4,000,000.00 1.35% 4,237,031.25 4,167,896.41 4.58% 3,839,610.00 10,485.00 1.65% Aaa / AAA 3.02 (328,286.41) Aaa 2.71 Corporate 69353RFL7 PNC Bank Callable Note Cont 5/9/2023 1,210,000.00 Various 1,208,333.27 99.43 1,203,100.58 0.52% A2 / A 0.69 3.500% Due 06/08/2023 3.53% 1,209,771.40 4.34% 13,293.20 (6,670.82) A+ 0.67 06406RAJ6 Bank of NY Mellon Corp Note 1,200,000.00 08/24/2018 1,201,836.00 99.24 1,190,824.80 0.51% Al / A 0.86 3.450% Due 08/11/2023 3.42% 1,200,318.69 4.36% 5,750.00 (9,493.89) AA- 0.84 06051GHF9 Bank of America Corp Callable Note 1X 3/5/2023 2,400,000.00 Various 2,434,650.00 99.22 2,381,265.60 1.02% A2 / A- 1.43 3.550% Due 03/05/2024 3.15% 2,403,758.90 4.90% 6,153.33 (22,493.30) AA- 1.36 89114QCB2 Toronto Dominion Bank Note 2,300,000.00 03/26/2019 2,331,234.00 97.56 2,243,765.00 0.96% Al / A 1.45 3.250% Due 03/11/2024 2.95% 2,309,094.10 5.02% 4,152.78 (65,329.10) AA- 1.39 037833CU2 Apple Inc Callable Note Cont 3/11/2024 3,000,000.00 Various 3,038,334.00 97.56 2,926,743.00 1.26% Aaa / AA+ 1.61 2.850% Due 05/11/2024 2.56% 3,011,937.17 4.43% 33,250.00 (85,194.17) NR 1.54 023135BW5 Amazon.com Inc Note 1,865,000.00 05/10/2021 1,862,277.10 93.77 1,748,717.25 0.75% Al / AA 1.62 0.450% Due 05/12/2024 0.50% 1,863,536.69 4.49% 3,240.44 (114,819.44) AA- 1.57 24422ETT6 John Deere Capital Corp Note 2,000,000.00 Various 2,093,680.00 96.77 1,935,400.00 0.83% A2 / A 1.73 2.650% Due 06/24/2024 1.32% 2,044,750.27 4.61% 14,280.56 (109,350.27) A 1.66 02665WCZ2 American Honda Finance Note 1,500,000.00 07/10/2019 1,493,742.00 96.07 1,441,062.00 0.62% A3 / A- 1.74 2.400% Due 06/27/2024 2.49% 1,497,806.94 4.78% 9,400.00 (56,744.94) A 1.67 79466LAG9 Salesforce.com Inc Callable Note Cont 7/15/2022 465,000.00 06/29/2021 464,762.85 93.24 433,543.68 0.19% A2 / A+ 1.79 0.625% Due 07/15/2024 0.64% 464,859.09 4.60% 613.54 (31,315.41) NR 1.74 78013XZU5 Royal Bank of Canada Note 2,500,000.00 09/10/2019 2,531,325.00 95.92 2,397,910.00 1.03% Al / A 1.79 2.550% Due 07/16/2024 2.28% 2,511,580.86 4.95% 13,281.25 (113,670.86) AA- 1.71 46647PAU0 JP Morgan Chase & Co Callable Note 1X 7/23/2023 2,500,000.00 09/12/2019 2,632,175.00 98.64 2,466,117.50 1.06% Al / A- 1.81 3.797% Due 07/23/2024 2.35% 2,527,732.31 5.01% 17,930.28 (61,614.81) AA- 1.71 02665WEA5 American Honda Finance Note 1,075,000.00 01/11/2022 1,074,150.75 92.81 997,680.63 0.43% A3/A- 2.29 1.500% Due 01/13/2025 1.53% 1,074,352.99 4.86% 3,493.75 (76,672.36) A 2.19 90331HPL1 US Bank NA Callable Note Cont 12/21/2024 2,610,000.00 01/16/2020 2,604,440.70 94.06 2,455,007.76 1.05% Al / AA- 2.31 2.050% Due 01/21/2025 2.10% 2,607,434.87 4.80% 10,403.75 (152,427.11) AA- 2.20 33 CM 89 Holdings Report City of Dublin - Account #10198 As of September 30, 2022 CUSIP Security Description Par Value/Units Purchase Date Book Yield Cost Value Book Value Mkt Price Mkt YTM Market Value Accrued Int. % of Port. Moody/S&P Maturity Gain/Loss Fitch Duration 00440EAS6 14913R2V8 747525AF0 61747YEA9 438516CB0 78015K7H1 Chubb INA Holdings Inc Note 3.150% Due 03/15/2025 Caterpillar Financial Service Note 3.400% Due 05/13/2025 Qualcomm Inc Callable Note Cont 2/20/2025 3.450% Due 05/20/2025 Morgan Stanley Callable Note Cont 5/30/2024 0.790% Due 05/30/2025 Honeywell Intl Callable Note Cont 5/1/2025 1.350% Due 06/01/2025 Royal Bank of Canada Note 1.150% Due 06/10/2025 66815L2J7 02665WDL2 89114QCK2 06051GHY8 46647PBH8 808513BR5 91324PEC2 89236TJK2 58989V2D5 06368FAC3 Northwestern Mutual Gib! Note 4.000% Due 07/01/2025 American Honda Finance Note 1.200% Due 07/08/2025 Toronto Dominion Bank Note 0.750% Due 09/11/2025 Bank of America Corp Callable Note Cont 2/13/2025 2.015% Due 02/13/2026 JP Morgan Chase & Co Callable Note Mthly 3/13/2025 2.005% Due 03/13/2026 Charles Schwab Corp Callable Note Cont 4/13/2026 1.150% Due 05/13/2026 United Health Group Inc Callable Note Cont 4/15/2026 1.150% Due 05/15/2026 Toyota Motor Credit Corp Note 1.125% Due 06/18/2026 Met Tower Global Funding Note 1.250% Due 09/14/2026 Bank of Montreal Note 1.250% Due 09/15/2026 2,500,000.00 1,165,000.00 3,000,000.00 3,040,000.00 2,500,000.00 1,000,000.00 2,500,000.00 1,000,000.00 1,000,000.00 1,250,000.00 1,000,000.00 1,370,000.00 2,000,000.00 2,485,000.00 1,285,000.00 2,500,000.00 Various 0.76% 05/10/2022 3.44% Various 1.78% 05/26/2021 0.77% 06/23/2020 0.85% 02/22/2021 0.86% 06/27/2022 4.01% 08/10/2021 1.00% 02/16/2021 0.81% 03/04/2021 1.14% 04/29/2021 1.20% 05/11/2021 1.20% Various 1.90% 06/15/2021 1.13% 09/07/2021 1.27% Various 1.29% 2,753,600.00 2,643,973.11 1,163,520.45 1,163,710.79 3,159,848.58 3,127,302.37 3,041,611.70 3,040,894.24 2,559,500.00 2,531,681.82 1,012,240.00 1,007,678.32 2,499,150.00 2,499,221.35 1,007,640.00 1,005,416.58 997,230.00 998,210.97 1,291,725.00 1,275,127.85 1,030,270.00 1,019,151.72 1,366,821.60 1,367,702.36 1,939,210.15 1,947,673.81 2,483,906.60 2,484,188.03 1,283,817.80 1,284,065.12 2,495,539.50 2,496,470.20 95.95 4.92% 96.71 4.75% 96.81 4.75% 92.06 5.01% 92.05 4.54% 90.25 5.07% 97.42 5.01% 90.49 4.91% 88.18 5.12% 91.68 5.41% 91.59 5.43% 87.51 4.96% 88.53 4.62% 87.51 4.84% 86.05 5.20% 85.53 5.35% 2,398,747.50 3,500.00 1,126,726.25 15,183.83 2,904,267.00 37,662.50 2,798,703.04 8,072.05 2,301,282.50 11,250.00 902,515.00 3,545.83 2,435,407.50 25,000.00 904,930.00 2,766.67 881,825.00 416.67 1,146,005.00 3,358.33 915,919.00 1,002.50 1,198,906.18 6,039.42 1,770,628.00 8,688.89 2,174,583.74 7,998.59 1,105,687.25 758.51 2,138,342.50 1,388.89 1.03% (245,225.61) 0.49% (36,984.54) 1.26% (223,035.37) 1.20% (242,191.20) 0.99% (230,399.32) 0.39% (105,163.32) 1.05% (63,813.85) 0.39% (100,486.58) 0.38% (116,385.97) 0.49% (129,122.85) 0.39% (103,232.72) 0.51% (168,796.18) 0.76% (177,045.81) 0.93% (309,604.29) 0.47% (178,377.87) 0.91% (358,127.70) A3 / A A A2 / A A A2 / A NR Al/A- A A2 / A A Al/A AA- Aaa / AA+ AAA A3 / A- A Al/A AA- A2/A- AA- A1/A- AA- A2 / A A A3 / A+ A Al/A+ A+ Aa3 / AA- AA- A2 /A- AA- 2.46 2.32 2.62 2.44 2.64 2.45 2.67 2.56 2.67 2.56 2.70 2.58 2.75 2.54 2.77 2.66 2.95 2.84 3.38 3.17 3.45 3.25 3.62 3.45 3.62 3.46 3.72 3.55 3.96 3.76 3.96 3.76 34 CM 90 Holdings Report City of Dublin - Account #10198 As of September 30, 2022 CUSIP Security Description Par Value/Units Purchase Date Book Yield Cost Value Book Value Mkt Price Mkt YTM Market Value Accrued Int. % of Port. Moody/S&P Maturity Gain/Loss Fitch Duration 931142ER0 59217GER6 87612EBM7 Wal-Mart Stores Callable Note Cont 08/17/2026 1.050% Due 09/17/2026 Metlife Note 1.875% Due 01/11/2027 Target Corp Callable Note Cont 12/15/2026 1.950% Due 01/15/2027 808513BY0 084664CZ2 40139LBF9 023135CF1 46647PCB0 927804GH1 Charles Schwab Corp Callable Note Cont 2/3/2027 2.450% Due 03/03/2027 Berkshire Hathaway Callable Note Cont 2/15/2027 2.300% Due 03/15/2027 Guardian Life Glob Fun Note 3.246% Due 03/29/2027 Amazon.com Inc Callable Note Cont 3/13/2027 3.300% Due 04/13/2027 JP Morgan Chase & Co Callable Note Cont 4/22/2026 1.578% Due 04/22/2027 Virginia Electric Power Corp Callable Note Cont. 4/15/2027 3.750% Due 05/15/2027 585,000.00 1,860,000.00 1,340,000.00 585,000.00 2,295,000.00 765,000.00 1,750,000.00 500,000.00 1,000,000.00 09/08/2021 1.09% 01/03/2022 1.90% 01/19/2022 1.99% 03/01/2022 2.47% 03/07/2022 2.30% 03/24/2022 3.25% 04/25/2022 3.34% 08/23/2022 4.45% Various 3.75% 583,894.35 584,123.84 1,857,879.60 1,858,185.00 1,337,722.00 1,338,035.43 584,368.20 584,441.55 2,294,563.95 2,294,611.71 765,000.00 765,000.00 1,746,972.50 1,747,234.82 449,845.00 450,935.97 999,773.40 999,786.70 87.29 4.59% 87.50 5.17% 89.69 4.62% 89.78 5.06% 91.05 4.54% 92.98 5.01% 94.43 4.68% 86.40 5.46% 94.44 5.11% 510,652.35 238.88 1,627,462.80 7,750.00 1,201,887.54 5,516.33 525,214.17 1,114.75 2,089,659.47 2,346.00 711,290.88 137.96 1,652,472.50 26,950.00 432,020.50 3,484.75 944,419.00 12,604.17 0.22% (73,471.49) 0.70% (230,722.20) 0.52% (136,147.89) 0.22% (59,227.38) 0.89% (204,952.24) 0.30% (53,709.12) 0.72% (94,762.32) 0.19% (18,915.47) 0.41% (55,367.70) Aa2 / AA AA Aa3 / AA- AA- A2 / A A A2 / A A Aa2/AA A+ Aa1 / AA+ NR Al/AA AA- A1/A- AA- A2 / BBB+ A 3.97 3.80 4.28 4.00 4.30 4.02 4.42 4.09 4.46 4.15 4.50 4.10 4.54 4.08 4.56 4.25 4.62 4.12 14913R3A3 Caterpillar Financial Service Note 3.600% Due 08/12/2027 931142EX7 Wal-Mart Stores Callable Note Cont 09/09/2027 3.950% Due 09/09/2027 TOTAL Corporate Money Market Fund 31846V203 First American Govt Obligation Fund Class Y 1,375,000.00 1,500,000.00 67,775,000.00 286,323.37 TOTAL Money Market Fund 286,323.37 Various 1,357,243.75 3.89% 1,357,450.99 Various 1,498,302.30 3.98% 1,498,322.76 68,532,137.10 2.06% 68,097,531.69 94.46 1,298,822.25 0.56% 4.89% 6,737.50 (58,628.74) 96.93 1,453, 924.51 0.62% 4.65% 3,620.83 (44,398.25) 63,373,439.23 27.23% 4.85% 342,376.73 (4,724,092.46) A2 / A A Aa2/AA AA Al / A+ A+ 4.87 4.37 4.95 4.42 2.82 2.65 Various 2.45% 2.45% 286,323.37 286,323.37 286,323.37 286,323.37 1.00 2.45% 2.45% 286,323.37 0.00 286,323.37 0.00 0.12% Aaa / AAA 0.00 AAA 0.12% Aaa / AAA 0.00 Aaa 0.00 0.00 0.00 0.00 35 CM 91 Holdings Report City of Dublin - Account #10198 As of September 30, 2022 Security Description Par Value/Units Purchase Date Cost Value Mkt Price Market Value % of Port. Moody/S&P Maturity Book Yield Book Value Mkt YTM Accrued Int. Gain/Loss Fitch Duration Negotiable CD 86959RTW0 Svenska Handelsbanken NY Yankee CD 0.255% Due 10/14/2022 2, 500, 000.00 10/15/2021 2,500,126.08 0.25% 2,500,004.50 TOTAL Negotiable CD 99.89 3.09% 2,497,242.50 6,215.63 1.07% P-1 / A-1+ (2,762.00) F-1+ 0.04 0.04 2,500,000.00 0.25% 2,500,126.08 2,500,004.50 3.09% 2,497,242.50 6,215.63 1.07% Aaa / AAA 0.04 (2,762.00) Aaa 0.04 Supranational 4581X0DZ8 Inter -American Dev Bank Note 3,680,000.00 09/15/2021 3,677,276.80 92.88 3,418,131.20 1.46% Aaa / AAA 1.98 0.500% Due 09/23/2024 0.52% 3,678,203.58 4.29% 408.89 (260,072.38) NR 1.93 459058JB0 Intl. Bank Recon & Development Note 2,260,000.00 04/15/2020 2,251,253.80 91.04 2,057,540.16 0.88% Aaa / AAA 2.56 0.625% Due 04/22/2025 0.70% 2,255,526.31 4.36% 6,238.54 (197,986.15) NR 2.48 4581X0DN5 Inter -American Dev Bank Note 1,685,000.00 01/13/2021 1,692,329.75 90.23 1,520,335.06 0.65% Aaa / AAA 2.79 0.625% Due 07/15/2025 0.53% 1,689,544.27 4.38% 2,223.26 (169,209.21) NR 2.71 459058JL8 Intl. Bank Recon & Development Note 6,000,000.00 Various 5,986,632.00 88.98 5,338,506.00 2.29% Aaa / AAA 3.08 0.500% Due 10/28/2025 0.55% 5,991,333.70 4.37% 12,750.00 (652,827.70) AAA 2.98 4581X0DV7 Inter -American Dev Bank Note 4,615,000.00 04/13/2021 4,593,863.30 88.72 4,094,381.85 1.76% Aaa / AAA 3.56 0.875% Due 04/20/2026 0.97% 4,599,986.69 4.33% 18,059.39 (505,604.84) AAA 3.42 18,201,355.65 16,428,894.27 7.04% Aaa / AAA 2.88 TOTAL Supranational 18,240,000.00 0.67% 18,214,594.55 4.34% 39,680.08 (1,785,700.28) Aaa 2.78 US Treasury 912828V80 US Treasury Note 5,000,000.00 Various 4,983,691.41 97.36 4,867,775.00 2.09% Aaa / AA+ 1.34 2.250% Due 01/31/2024 2.32% 4,995,483.53 4.31% 18,953.80 (127,708.53) AAA 1.29 912828WJ5 US Treasury Note 1,750,000.00 06/10/2019 1,798,261.72 97.16 1,700,233.50 0.73% Aaa /AA+ 1.62 2.500% Due 05/15/2024 1.91% 1,765,872.74 4.33% 16,525.14 (65,639.24) AAA 1.55 9128282N9 US Treasury Note 2,000,000.00 08/30/2019 2,064,531.25 96.23 1,924,610.00 0.83% Aaa /AA+ 1.84 2.125% Due 07/31/2024 1.44% 2,024,024.15 4.28% 7,160.33 (99,414.15) AAA 1.76 912828YH7 US Treasury Note 3,500,000.00 Various 3,474,941.41 94.83 3,318,983.50 1.42% Aaa /AA+ 2.00 1.500% Due 09/30/2024 1.65% 3,489,668.77 4.22% 144.23 (170,685.27) AAA 1.94 9128283J7 US Treasury Note 3,000,000.00 Various 3,051,650.40 95.62 2,868,516.00 1.23% Aaa /AA+ 2.17 2.125% Due 11/30/2024 1.76% 3,022,556.60 4.26% 21,424.19 (154,040.60) AAA 2.07 91282CDZ1 US Treasury Note 2,000,000.00 05/06/2022 1,925,156.25 93.75 1,875,000.00 0.80% Aaa /AA+ 2.38 1.500% Due 02/15/2025 2.92% 1,935,869.32 4.30% 3,831.52 (60,869.32) AAA 2.29 912828ZC7 US Treasury Note 3,500,000.00 03/24/2020 3,603,222.66 92.89 3,251,307.50 1.39% Aaa /AA+ 2.42 1.125% Due 02/28/2025 0.52% 3,550,493.71 4.25% 3,371.89 (299,186.21) AAA 2.34 36 CM 92 Holdings Report City of Dublin - Account #10198 As of September 30, 2022 CUSIP Security Description Par Value/Units Purchase Date Book Yield Cost Value Book Value Mkt Price Mkt YTM Market Value Accrued Int. % of Port. Moody/S&P Maturity Gain/Loss Fitch Duration 91282CED9 912828ZL7 91282CFE6 91282CAM3 91282CBC4 91282CBH3 US Treasury Note 1.750% Due 03/15/2025 US Treasury Note 0.375% Due 04/30/2025 US Treasury Note 3.125% Due 08/15/2025 US Treasury Note 0.250% Due 09/30/2025 US Treasury Note 0.375% Due 12/31/2025 US Treasury Note 0.375% Due 01/31/2026 91282CBQ3 91282CBT7 91282CCF6 US Treasury Note 0.500% Due 02/28/2026 US Treasury Note 0.750% Due 03/31/2026 US Treasury Note 0.750% Due 05/31/2026 91282CCW9 91282CDG3 912828Z78 91282CEN7 91282CEW7 US Treasury Note 0.750% Due 08/31/2026 US Treasury Note 1.125% Due 10/31/2026 US Treasury Note 1.500% Due 01/31/2027 US Treasury Note 2.750% Due 04/30/2027 US Treasury Note 3.250% Due 06/30/2027 TOTAL US Treasury 2,000,000.00 4,000,000.00 1,000,000.00 2,500,000.00 1,000,000.00 4,000,000.00 2,500,000.00 5,000,000.00 2,000,000.00 2,000,000.00 5,000,000.00 4,500,000.00 7,000,000.00 8,000,000.00 71,250,000.00 03/15/2022 2.00% Various 0.38% 09/27/2022 4.42% 10/16/2020 0.32% 12/29/2020 0.38% 02/23/2021 0.58% 1,985,312.50 1,987,981.74 3,998,593.75 3,999,255.79 965,234.38 965,333.52 2,491,406.25 2,494,792.39 999,921.88 999,949.22 3,960,625.00 3,973,385.82 03/26/2021 0.83% Various 0.85% 06/18/2021 0.91% 2,459,960.94 2,472,237.80 4,974,804.69 4,982,320.69 1,985,000.00 1,988,880.89 08/30/2021 0.77% Various 1.25% Various 2.15% Various 3.54% Various 3.10% TOTAL PORTFOLIO 1.75% 1,998,515.63 1,998,837.54 4,970,498.06 4,975,402.01 4,367,285.16 4,379,914.83 6,761,484.38 6,765,052.74 8,053,964.85 8,052,346.69 70,874,062.57 70,819,660.49 248,649,713.91 94.18 4.27% 90.60 4.25% 96.95 4.26% 88.89 4.23% 88.44 4.22% 88.09 4.24% 88.25 4.23% 88.81 4.22% 88.34 4.22% 87.73 4.18% 88.71 4.16% 89.68 4.12% 94.43 4.09% 96.43 4.08% 4.20% 1,883,594.00 1,546.96 3,624,064.00 6,277.18 969,531.00 3,991.17 2,222,167.50 17.17 884,414.00 947.69 3,523,752.00 2,527.17 0.81% (104,387.74) 1.55% (375,191.79) 0.42% 4,197.48 0.95% (272,624.89) 0.38% (115,535.22) 1.51% (449,633.82) Aaa / AA+ AAA Aaa / AA+ AM Aaa / AA+ AM Aaa / AA+ AAA Aaa / AA+ AM Aaa / AA+ AM 2,206,347.50 1,070.44 4,440,430.00 103.02 1,766,796.00 5,040.98 0.94% (265,890.30) 1.90% (541,890.69) 0.76% (222,084.89) Aaa / AA+ AM Aaa / AA+ AM Aaa / AA+ AM 1,754,688.00 1,284.53 4,435,350.00 23,539.40 4,035,762.00 11,372.28 6,609,806.00 80,557.06 7,714,688.00 65,706.52 65,877,815.50 275,392.67 0.75% (244,149.54) 1.91% (540,052.01) 1.73% (344,152.83) 2.86% (155,246.74) 3.32% (337,658.69) 28.27% (4,941,844.99) 249,871,186.70 1.68% 248,882,873.44 4.47% 233,126, 756.06 100.00 (15,756,117.38 904,893.09 Aaa / AA+ AM Aaa / AA+ AM Aaa / AA+ AM Aaa / AA+ AM Aaa / AA+ AM Aaa / AA+ Aaa 2.46 2.36 2.58 2.52 2.88 2.70 3.00 2.93 3.25 3.16 3.34 3.24 3.42 3.32 3.50 3.39 3.67 3.54 3.92 3.78 4.09 3.90 4.34 4.11 4.58 4.20 4.75 4.31 3.27 3.09 Aa1 / AA Aaa 2.73 2.39 TOTAL MARKET VALUE PLUS ACCRUALS 234,031,649.15 37 CM 93 Holdings Report City of Dublin Reporting Account - Account #10219 As of September 30, 2022 CUSIP Security Description Par Value/Units Purchase Date Cost Value Mkt Price Market Value % of Port. Moody/S&P Maturity Book Yield Book Value Mkt YTM Accrued Int. Gain/Loss Fitch Duration LAIF 90LAIF$00 Local Agency Investment Fund State Pool 50,558,660.53 Various 50,558,660.53 1.60% 50,558,660.53 1.00 1.60% 50,558,660.53 164,680.89 39.20% NR/NR 0.00 0.00 NR 0.00 TOTAL LAIF 50,558,660.53 1.60% 50,558,660.53 50,558,660.53 1.60% 50,558,660.53 164,680.89 39.20% NR / NR 0.00 0.00 NR 0.00 Local Gov Investment Pool Nom r 90CAMP$00 California Asset Mgmt Program CAMP 78,684,622.93 Various 78,684,622.93 2.61% 78,684,622.93 1.00 78,684,622.93 60.80% NR / AAA 0.00 2.61% 0.00 0.00 NR 0.00 TOTAL Local Gov Investment Pool 78,684,622.93 2.61% 78,684,622.93 78,684,622.93 78,684,622.93 60.80% NR / AAA 0.00 2.61% 0.00 0.00 NR 0.00 TOTAL PORTFOLIO 129,243,283.46 129,243,283.46 2.21% 129,243,283.46 2.21% 129,243,283.46 164,680.89 TOTAL MARKET VALUE PLUS ACCRUALS 129,407,964.35 100.00% NR / AAA 0.00 NR 0.00 0.00 38 CM 94 Section 5 I Transactions Transaction Ledger City of Dublin - Account #10198 June 30, 2022 through September 30, 2022 As of September 30, 2022 Transaction Settlement Type Date CUSIP Quantity Security Description c Price Aq/Disp Yield Amount Interest Pur/Sold Total Amount Gain/Loss ACQUISITIONS Purchase 07/01/2022 66815L2J7 2,500,000.00 Northwestern Mutual Glbl Note 4% Due: 07/01/2025 Purchase 07/20/2022 47800AAC4 1,045,000.00 John Deere Owner Trust 2022-B A3 3.74% Due: 02/16/2027 Purchase 08/08/2022 91282CEW7 2,000,000.00 US Treasury Note 3.25% Due: 06/30/2027 Purchase 08/10/2022 91282CEW7 2,500,000.00 US Treasury Note 3.25% Due: 06/30/2027 Purchase 08/11/2022 92348KAV5 915,000.00 Verizon Master Trust 2022-5 A1A 3.72% Due: 07/20/2027 Purchase 08/19/2022 14913R3A3 750,000.00 Caterpillar Financial Service Note 3.6% Due: 08/12/2027 Purchase 08/25/2022 46647PCB0 500,000.00 JP Morgan Chase & Co Callable Note Cont 4/22/2026 1.578% Due: 04/22/2027 99.966 4.01% 2,499,150.00 0.00 2,499,150.00 0.00 99.990 3.77% 1,044,900.20 0.00 1,044,900.20 0.00 101.242 2.97% 2,024,843.75 6,888.59 2,031,732.34 0.00 101.184 2.99% 2,529,589.84 9,052.31 2,538,642.15 0.00 99.996 3.75% 914,959.74 0.00 914,959.74 0.00 99.715 3.66% 747,862.50 525.00 748,387.50 0.00 89.969 4.45% 449,845.00 2,695.75 452,540.75 0.00 Purchase 08/26/2022 91282CEW7 2,000,000.00 US Treasury Note 100.246 3.19% 2,004,921.88 10,067.93 2,014,989.81 0.00 3.25% Due: 06/30/2027 Purchase 08/31/2022 91282CEW7 1,500,000.00 US Treasury Note 99.641 3.33% 1,494,609.38 8,213.32 1,502,822.70 0.00 3.25% Due: 06/30/2027 Purchase 09/09/2022 931142EX7 705,000.00 Wal-Mart Stores Callable Note Cont 09/09/2027 99.784 4.00% 703,477.20 0.00 703,477.20 0.00 3.95% Due: 09/09/2027 Purchase 09/09/2022 931142EX7 795,000.00 Wal-Mart Stores Callable Note Cont 09/09/2027 99.978 3.95% 794,825.10 0.00 794,825.10 0.00 3.95% Due: 09/09/2027 Purchase 09/13/2022 14913R3A3 625,000.00 Caterpillar Financial Service Note 97.501 4.17% 609,381.25 1,937.50 611,318.75 0.00 3.6% Due: 08/12/2027 Purchase 09/27/2022 91282CEN7 3,000,000.00 US Treasury Note 93.844 4.23% 2,815,312.50 33,627.72 2,848,940.22 0.00 2.75% Due: 04/30/2027 40 CM 96 Transaction Ledger City of Dublin - Account #10198 June 30, 2022 through September 30, 2022 As of September 30, 2022 Transaction Settlement Type Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Total Amount Gain/Loss Pur/Sold Purchase 09/28/2022 91282CFE6 1,000,000.00 US Treasury Note 3.125% Due: 08/15/2025 96.523 4.42% 965,234.38 3,736.41 968,970.79 0.00 Subtotal 19,835,000.00 19,598,912.72 76,744.53 19,675,657.25 0.00 TOTAL ACQUISITIONS 19,835,000.00 19,598,912.72 76,744.53 19,675,657.25 0.00 DISPOSITIONS Sale Sale Sale Sale Sale Sale Sale Sale Sale Sale 07/18/2022 3135G0T94 2,500,000.00 FNMA Note 99.734 2.70% 2,493,350.00 29,522.57 2,522,872.57 -2,825.23 2.375% Due: 01/19/2023 08/08/2022 912828R69 500,000.00 US Treasury Note 98.750 2.67% 493,750.00 1,531.76 495,281.76 -2,314.57 1.625% Due: 05/31/2023 08/10/2022 912828R69 1,000,000.00 US Treasury Note 98.742 2.67% 987,421.88 3,152.32 990,574.20 -4,760.44 1.625% Due: 05/31/2023 08/10/2022 912828U57 1,500,000.00 US Treasury Note 98.543 2.54% 1,478,144.53 6,183.40 1,484,327.93 -14,430.29 2.125% Due: 11/30/2023 08/18/2022 58933YAF2 360,000.00 Merck & Co Note 99.604 3.41% 358,574.40 2,520.00 361,094.40 93.86 2.8% Due: 05/18/2023 08/19/2022 58933YAF2 380,000.00 Merck & Co Note 99.576 3.41% 378,388.80 2,689.56 381,078.36 -13.20 2.8% Due: 05/18/2023 08/25/2022 46625HRL6 260,000.00 JP Morgan Chase Callable Note Cont 3/18/2023 99.604 3.74% 258,970.40 1,891.50 260,861.90 774.33 2.7% Due: 05/18/2023 08/26/2022 912828U57 2,000,000.00 US Treasury Note 98.508 2.54% 1,970,156.25 10,102.46 1,980,258.71 -20,275.59 2.125% Due: 11/30/2023 08/31/2022 46625HRL6 110,000.00 JP Morgan Chase Callable Note Cont 3/18/2023 99.445 3.74% 109,389.50 849.75 110,239.25 135.49 2.7% Due: 05/18/2023 08/31/2022 46625HRL6 130,000.00 JP Morgan Chase Callable Note Cont 3/18/2023 99.480 3.74% 129,324.00 1,004.25 130,328.25 205.62 2.7% Due: 05/18/2023 41 CM 97 Transaction Ledger City of Dublin - Account #10198 June 30, 2022 through September 30, 2022 As of September 30, 2022 Transaction Type Settlement Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Total Amount Gain/Loss Pur/Sold Sale Sale Sale Sale 08/31/2022 09/09/2022 09/09/2022 09/13/2022 912828U57 02665WCJ8 747525AF0 69353RFL7 1,500,000.00 1,000,000.00 500,000.00 1,000,000.00 US Treasury Note 2.125% Due: 11/30/2023 American Honda Finance Note 3.45% Due: 07/14/2023 Qualcomm Inc Callable Note Cont 2/20/2025 3.45% Due: 05/20/2025 PNC Bank Callable Note Cont 5/9/2023 3.5% Due: 06/08/2023 98.379 99.648 98.852 99.810 2.54% 1,475,683.59 3.52% 996,480.00 1.82% 494,260.00 3.53% 998,100.00 8,012.30 5,270.83 1,001,750.83 -2,840.36 5,222.92 499,482.92 -27,442.27 9,236.11 1,007,336.11 -1,697.47 1,483,695.89 -17,218.12 Subtotal 12,740,000.00 12,621,993.35 87,189.73 12,709,183.08 -92,608.24 Maturity 09/14/2022 4581X0CZ9 2,500,000.00 Inter -American Dev Bank Note 1.75% Due: 09/14/2022 100.000 2,500,000.00 0.00 2,500,000.00 0.00 Subtotal 2,500,000.00 2,500,000.00 0.00 2,500,000.00 0.00 TOTAL DISPOSITIONS 15,240,000.00 15,121,993.35 87,189.73 15,209,183.08 -92,608.24 42 CM 98 Transaction Ledger City of Dublin Reporting Account - Account #10219 June 30, 2022 through September 30, 2022 As of September 30, 2022 Transaction Settlement Type Date CUSIP Quantity Security Description c Price Aq/Disp Yield Amount Interest Pur/Sold Total Amount Gain/Loss ACQUISITIONS Purchase 07/15/2022 90LAIF$00 94,479.51 Local Agency Investment Fund State Pool Purchase 07/29/2022 90CAMP$00 119,875.32 California Asset Mgmt Program CAMP Purchase 08/31/2022 90CAMP$00 155,773.78 California Asset Mgmt Program CAMP Purchase 09/30/2022 90CAMP$00 168,665.89 California Asset Mgmt Program CAMP 1.000 0.94% 1.000 1.40% 1.000 2.37% 1.000 2.61% 94,479.51 119,875.32 155,773.78 168,665.89 0.00 0.00 0.00 0.00 94,479.51 119,875.32 155,773.78 168,665.89 0.00 0.00 0.00 0.00 Subtotal 538,794.50 538,794.50 0.00 538,794.50 0.00 TOTAL ACQUISITIONS 538,794.50 538,794.50 0.00 538,794.50 0.00 DISPOSITIONS Security 07/12/2022 90CAMP$00 4,000,000.00 California Asset Mgmt Program CAMP 1.000 4,000,000.00 0.00 4,000,000.00 0.00 Withdrawal Security 07/18/2022 90CAMP$00 1,000,000.00 California Asset Mgmt Program CAMP 1.000 1,000,000.00 0.00 1,000,000.00 0.00 Withdrawal Security 08/09/2022 90CAMP$00 6,000,000.00 California Asset Mgmt Program CAMP 1.000 6,000,000.00 0.00 6,000,000.00 0.00 Withdrawal Subtotal 11,000,000.00 11,000,000.00 0.00 11,000,000.00 0.00 TOTAL DISPOSITIONS 11,000,000.00 11,000,000.00 0.00 11,000,000.00 0.00 43 CM 99 Important Disclosures 2022 Chandler Asset Management, Inc, An Independent Registered Investment Adviser. As of September 30, 2022 Information contained herein is confidential. Prices are provided by ICE Data Services Inc ("IDS"), an independent pricing source. In the event IDS 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. 44 CM 100 Benchmark Disclosures As of September 30, 2022 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. 45 CA;:,. 101 Attachment 2 Transaction Ledger City of Dublin - Account #10198 June 30, 2022 through September 30, 2022 As of September 30, 2022 Transaction Settlement Type Date CUSIP Quantity Security Description c Price Aq/Disp Yield Amount Interest Pur/Sold Total Amount Gain/Loss ACQUISITIONS Purchase 07/01/2022 66815L2J7 2,500,000.00 Northwestern Mutual Glbl Note 4% Due: 07/01/2025 Purchase 07/20/2022 47800AAC4 1,045,000.00 John Deere Owner Trust 2022-B A3 3.74% Due: 02/16/2027 Purchase 08/08/2022 91282CEW7 2,000,000.00 US Treasury Note 3.25% Due: 06/30/2027 Purchase 08/10/2022 91282CEW7 2,500,000.00 US Treasury Note 3.25% Due: 06/30/2027 Purchase 08/11/2022 92348KAV5 915,000.00 Verizon Master Trust 2022-5 A1A 3.72% Due: 07/20/2027 Purchase 08/19/2022 14913R3A3 750,000.00 Caterpillar Financial Service Note 3.6% Due: 08/12/2027 Purchase 08/25/2022 46647PCB0 500,000.00 JP Morgan Chase & Co Callable Note Cont 4/22/2026 1.578% Due: 04/22/2027 99.966 4.01% 2,499,150.00 0.00 2,499,150.00 0.00 99.990 3.77% 1,044,900.20 0.00 1,044,900.20 0.00 101.242 2.97% 2,024,843.75 6,888.59 2,031,732.34 0.00 101.184 2.99% 2,529,589.84 9,052.31 2,538,642.15 0.00 99.996 3.75% 914,959.74 0.00 914,959.74 0.00 99.715 3.66% 747,862.50 525.00 748,387.50 0.00 89.969 4.45% 449,845.00 2,695.75 452,540.75 0.00 Purchase 08/26/2022 91282CEW7 2,000,000.00 US Treasury Note 100.246 3.19% 2,004,921.88 10,067.93 2,014,989.81 0.00 3.25% Due: 06/30/2027 Purchase 08/31/2022 91282CEW7 1,500,000.00 US Treasury Note 99.641 3.33% 1,494,609.38 8,213.32 1,502,822.70 0.00 3.25% Due: 06/30/2027 Purchase 09/09/2022 931142EX7 705,000.00 Wal-Mart Stores Callable Note Cont 09/09/2027 99.784 4.00% 703,477.20 0.00 703,477.20 0.00 3.95% Due: 09/09/2027 Purchase 09/09/2022 931142EX7 795,000.00 Wal-Mart Stores Callable Note Cont 09/09/2027 99.978 3.95% 794,825.10 0.00 794,825.10 0.00 3.95% Due: 09/09/2027 Purchase 09/13/2022 14913R3A3 625,000.00 Caterpillar Financial Service Note 97.501 4.17% 609,381.25 1,937.50 611,318.75 0.00 3.6% Due: 08/12/2027 Purchase 09/27/2022 91282CEN7 3,000,000.00 US Treasury Note 93.844 4.23% 2,815,312.50 33,627.72 2,848,940.22 0.00 2.75% Due: 04/30/2027 40 CM 102 Transaction Ledger City of Dublin - Account #10198 June 30, 2022 through September 30, 2022 As of September 30, 2022 Transaction Settlement Type Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Total Amount Gain/Loss Pur/Sold Purchase 09/28/2022 91282CFE6 1,000,000.00 US Treasury Note 3.125% Due: 08/15/2025 96.523 4.42% 965,234.38 3,736.41 968,970.79 0.00 Subtotal 19,835,000.00 19,598,912.72 76,744.53 19,675,657.25 0.00 TOTAL ACQUISITIONS 19,835,000.00 19,598,912.72 76,744.53 19,675,657.25 0.00 DISPOSITIONS Sale Sale Sale Sale Sale Sale Sale Sale Sale Sale 07/18/2022 3135G0T94 2,500,000.00 FNMA Note 99.734 2.70% 2,493,350.00 29,522.57 2,522,872.57 -2,825.23 2.375% Due: 01/19/2023 08/08/2022 912828R69 500,000.00 US Treasury Note 98.750 2.67% 493,750.00 1,531.76 495,281.76 -2,314.57 1.625% Due: 05/31/2023 08/10/2022 912828R69 1,000,000.00 US Treasury Note 98.742 2.67% 987,421.88 3,152.32 990,574.20 -4,760.44 1.625% Due: 05/31/2023 08/10/2022 912828U57 1,500,000.00 US Treasury Note 98.543 2.54% 1,478,144.53 6,183.40 1,484,327.93 -14,430.29 2.125% Due: 11/30/2023 08/18/2022 58933YAF2 360,000.00 Merck & Co Note 99.604 3.41% 358,574.40 2,520.00 361,094.40 93.86 2.8% Due: 05/18/2023 08/19/2022 58933YAF2 380,000.00 Merck & Co Note 99.576 3.41% 378,388.80 2,689.56 381,078.36 -13.20 2.8% Due: 05/18/2023 08/25/2022 46625HRL6 260,000.00 JP Morgan Chase Callable Note Cont 3/18/2023 99.604 3.74% 258,970.40 1,891.50 260,861.90 774.33 2.7% Due: 05/18/2023 08/26/2022 912828U57 2,000,000.00 US Treasury Note 98.508 2.54% 1,970,156.25 10,102.46 1,980,258.71 -20,275.59 2.125% Due: 11/30/2023 08/31/2022 46625HRL6 110,000.00 JP Morgan Chase Callable Note Cont 3/18/2023 99.445 3.74% 109,389.50 849.75 110,239.25 135.49 2.7% Due: 05/18/2023 08/31/2022 46625HRL6 130,000.00 JP Morgan Chase Callable Note Cont 3/18/2023 99.480 3.74% 129,324.00 1,004.25 130,328.25 205.62 2.7% Due: 05/18/2023 41 CM 103 Transaction Ledger City of Dublin - Account #10198 June 30, 2022 through September 30, 2022 As of September 30, 2022 Transaction Type Settlement Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Total Amount Gain/Loss Pur/Sold Sale Sale Sale Sale 08/31/2022 09/09/2022 09/09/2022 09/13/2022 912828U57 02665WCJ8 747525AF0 69353RFL7 1,500,000.00 1,000,000.00 500,000.00 1,000,000.00 US Treasury Note 2.125% Due: 11/30/2023 American Honda Finance Note 3.45% Due: 07/14/2023 Qualcomm Inc Callable Note Cont 2/20/2025 3.45% Due: 05/20/2025 PNC Bank Callable Note Cont 5/9/2023 3.5% Due: 06/08/2023 98.379 99.648 98.852 99.810 2.54% 1,475,683.59 3.52% 996,480.00 1.82% 494,260.00 3.53% 998,100.00 8,012.30 5,270.83 1,001,750.83 -2,840.36 5,222.92 499,482.92 -27,442.27 9,236.11 1,007,336.11 -1,697.47 1,483,695.89 -17,218.12 Subtotal 12,740,000.00 12,621,993.35 87,189.73 12,709,183.08 -92,608.24 Maturity 09/14/2022 4581X0CZ9 2,500,000.00 Inter -American Dev Bank Note 1.75% Due: 09/14/2022 100.000 2,500,000.00 0.00 2,500,000.00 0.00 Subtotal 2,500,000.00 2,500,000.00 0.00 2,500,000.00 0.00 TOTAL DISPOSITIONS 15,240,000.00 15,121,993.35 87,189.73 15,209,183.08 -92,608.24 42 CM 104 Transaction Ledger City of Dublin Reporting Account - Account #10219 June 30, 2022 through September 30, 2022 As of September 30, 2022 Transaction Settlement Type Date CUSIP Quantity Security Description c Price Aq/Disp Yield Amount Interest Pur/Sold Total Amount Gain/Loss ACQUISITIONS Purchase 07/15/2022 90LAIF$00 94,479.51 Local Agency Investment Fund State Pool Purchase 07/29/2022 90CAMP$00 119,875.32 California Asset Mgmt Program CAMP Purchase 08/31/2022 90CAMP$00 155,773.78 California Asset Mgmt Program CAMP Purchase 09/30/2022 90CAMP$00 168,665.89 California Asset Mgmt Program CAMP 1.000 0.94% 1.000 1.40% 1.000 2.37% 1.000 2.61% 94,479.51 119,875.32 155,773.78 168,665.89 0.00 0.00 0.00 0.00 94,479.51 119,875.32 155,773.78 168,665.89 0.00 0.00 0.00 0.00 Subtotal 538,794.50 538,794.50 0.00 538,794.50 0.00 TOTAL ACQUISITIONS 538,794.50 538,794.50 0.00 538,794.50 0.00 DISPOSITIONS Security 07/12/2022 90CAMP$00 4,000,000.00 California Asset Mgmt Program CAMP 1.000 4,000,000.00 0.00 4,000,000.00 0.00 Withdrawal Security 07/18/2022 90CAMP$00 1,000,000.00 California Asset Mgmt Program CAMP 1.000 1,000,000.00 0.00 1,000,000.00 0.00 Withdrawal Security 08/09/2022 90CAMP$00 6,000,000.00 California Asset Mgmt Program CAMP 1.000 6,000,000.00 0.00 6,000,000.00 0.00 Withdrawal Subtotal 11,000,000.00 11,000,000.00 0.00 11,000,000.00 0.00 TOTAL DISPOSITIONS 11,000,000.00 11,000,000.00 0.00 11,000,000.00 0.00 43 CM 105