Loading...
HomeMy WebLinkAbout5.5 City Treasurer's Informational Report of Investments for the Quarter Ending September 30, 2023r DUBLIN CALIFORNIA STAFF REPORT CITY COUNCIL DATE: November 7, 2023 TO: Honorable Mayor and City Councilmembers FROM: Linda Smith, City Manager Agenda Item 5.5 SU B.ECT : City Treasurer's Informational Report of Investments for the Quarter Ending September 30, 2023 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, 2023, including a monthly transaction ledger. The City's investment portfolio for this period totaled $390,133,446 (market value) with an average market yield of 5.19%. As required by the Policy, the City Treasurer (Finance Director) affirms that the City is able to meet its expenditure requirements for the next six months. STAFF RECOMMENDATION: Receive the report. 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 $280,997,577 managed by Chandler Asset Management, and $109,135,869 invested by the City in local government pools, the Local Agency Investment Fund (LAIF) and the California Asset Management Program (CAMP). The average market yields of the Chandler portfolio and the local pools for the reporting period were 5.24% and 5.06% respectively. The total investment portfolio balance fluctuates throughout the year due to normal cash flow Page 1 of 4 1 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). Recent economic data continues to suggest positive but below -trend growth this year. Labor markets remain solid, and the U.S. consumer has demonstrated resiliency. Inflationary trends are subsiding, but core levels remain well above the Fed's target. Given the cumulative effects of restrictive monetary policy and tighter financial conditions, Chandler believes the economy will gradually soften and the Fed will remain data dependent as it treads cautiously going forward. 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 26.4% Supranational 5.9% Money Market Fund 0.2% Local Gov Investment Pool 21.2% Chart 1: Investments by Type September 30, 2023 and June 30, 2023 September 30, 2023 LA€F 6.8% ABS 7.3% Agency 12.1% CM() 1.9% Corporate 18.2% US Treasury 24.9% Supranational 4.2% Money Market Fund 0.7% Local Gov Investment Pool 23.6% June 30, 2023 LAIF 6.6% ABS 7.0% Agency 13.5% Corporate 18.0% CMO 16% The market value of the City's portfolio decreased by $10,975,932 from the June 30, 2023 quarter, resulting from normal fluctuations in the timing of incoming revenue, predominantly the receipt of property tax allocations, and sales tax revenue. Historically, the City receives property tax payments in Q2 (quarter ending December) and Q4 (quarter ending June), with the following months portfolio balance seeing slight decreases. The City also incurred expenditures on multiple capital projects during the reporting period, and made payments to Alameda County for Police and Fire Services. The City's portfolio increased by $26.7 million from the same quarter the prior year (see Table 1 below). Overall market yield -to -maturity has increased to 5.19%, (shown in Table 2) due to the factors discussed in the Economic Update Highlights. For detailed monthly transactions, see Attachment 2. Page 2 of 4 2 Holdings Managed by City LAIF CAMP SUBTOTAL' Accrued Interest Managed by Chandler ABS Agency CMO Money Market Negotiable CD Supranational Corporate US Treasury SUBTOTAL Accrued Interest TOTAL PORTFOLIO Table 1: Portfolio Values and Yield to Maturity September 30, 2022 Market Value 50,558,661 78,684,623 129,243,283 164,681 129,407,964 27,760,436 53,062,995 3,839,610 286,323 2,497,243 16,428,894 63,373,439 65,877,816 233,126,756 904,893 234,031,649 363,439,614 June 30, 2023 Market Value 26,092, 229 94, 675, 879 120,768,108 195,897 120,964,005 28,186, 820 53, 795, 750 6,570,900 2,641,554 16, 711, 738 71, 551, 741 99, 278,149 278,736,651 1,408, 723 280,145,373 401,109,378 September 30,2023 Par Value Book Value Market Value 26,297,090 82,616,317 108,913,407 29,170,598 48,900,000 7,807,180 859,487 24,845,000 74,760,000 108,000,000 294,342,265 26,297,090 82,616,317 108,913,407 29,168,002 49,055,148 7,817,252 859,487 24,643,896 74,507,915 107,471,968 293,523,668 26,297,090 82,616,317 108,913,407 222,462 109,135,869 28,613,814 46,770,742 7,428,709 859,487 23,103,092 70,490,952 102, 206, 540 279,473,336 1,524,241 280,997,577 403,255,672 402,437,075 Change from Prior Year Change from Prior Quarter 390,133,446 26,693,832 (10,975,932) % of Subtotal % of Total Book Market Portfolio Yield Yield 24.1% 75.9% 6.5% 20.5% 3.61% 3.61% 5.52% 5.52% 100.00% 27.01% 5.06% 5.06% 10.2% 16.7% 2.7% 0.3% 0.0% 8.3% 25.2% 36.6% 100.00% 7.2% 12.1% 1.9% 0.2% 0.0% 6.2% 18.5% 26.8% 72.99% 2.97% 2.12% 3.03% 4.94% 0.00% 1.64% 2.86% 2.88% 2.66% 5.82% 5.22% 5.35% 4.94% 0.00% 5.11% 5.64% 4.83% 5.24% 100.00% 5.19% Table 2: Quarterly Holdings (Market Value) by Type, and YTM, 5 Quarters Holdings (Market Value) LAI F/CAMP ABS Agency CMO Commercial Paper Money Market Negotiable CD Supranational Corporate US Treasury Accrued Interest TOTAL YIELD TO MATURITY 9/30/22 12/31/22 3/31/23 6/30/23 9/30/23 129, 243, 283 81, 925, 950 106, 543,157 120, 768,108 108, 913, 407 27,760,436 31,285,896 30,171,153 28,186,820 28,613,814 53,062,995 58,714,486 60,517,635 53,795,750 46,770,742 3,839,610 3,843,615 3,874,342 6,570,900 7,428,709 4,982,197 - - - 286,323 4,923,898 760,481 2,641,554 859,487 2,497,243 - - - - 16, 428, 894 16, 569, 068 16, 860, 396 16, 711, 738 23,103, 092 63,373,439 65,378,464 71,092,672 71,551,741 70,490,952 65,877,816 89,783,810 96,639,811 99,278,149 102,206,540 1,069,574 1,402,667 1,577,520 1,604,620 1,746,703 363,439,614 358,810,052 388,037,166 401,109,378 1 390,133,446 I 3.66% 4.39% 4.39% 4.92% 5.19% 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 shows portfolio yields over the most recent eight quarters. Page 3 of 4 3 Table 3: Quarterly Portfolio Yields, Recent 8 Quarters Market Yield LAIF CAMP Chandler 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% 12/31/22 2.23% 4.50% 4.57% 3/31/23 2.88% 4.92% 4.37% 6/30/23 3.26% 5.20% 4.98% 9/30/23 3.61% 5.52% 5.24% 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, 2023 2) Transaction Ledger - July through September 2023 Page 4 of 4 4 Attachment I INVESTMENT REPORT City of Dublin Period Ending September 30, 2023 CiitCHANDLER ASSET MANAGEMENT CHANDLER ASSET MANAGEMENT, INC. 1800.317.4747 I www.chandlerasset.com ITable of Contents SECTION 1 Economic Update SECTION 2 Account Profile SECTION 3 Consolidated Information SECTION 4 Portfolio Holdings SECTION 5 Transactions As of September 30, 2023 1 CA% 6 Section 1 I Economic Update Economic Update • Recent economic data continues to suggest positive but below trend growth this year. Labor markets remain solid, and the U.S. consumer has demonstrated resiliency. Inflationary trends are subsiding, but core levels remain well above the Fed's target. Given the cumulative effects of restrictive monetary policy and tighter financial conditions, we believe the economy will gradually soften and the Fed will remain data dependent as they tread cautiously going forward. • As anticipated at the September meeting, the Federal Open Market Committee voted unanimously to maintain the target Federal Funds at the range of 5.25 - 5.50%. The Fed's Summary of Economic Projections (SEP) also revealed expectations of higher economic growth, reduced unemployment, and a gradual easing of inflation compared to earlier forecasts. The Fed is continuing to focus on achieving price stability and bringing inflation down toward their 2% policy objective, while leaving the option open for the possibility of additional rate hikes in the future if needed. • The yield curve remained inverted in September. The 2-year Treasury yield increased 18 basis points to 5.05%, the 5-year Treasury yield rose 36 basis points to 4.61%, and the 10-year Treasury yield increased 46 basis points to 4.57%. The inversion between the 2-year Treasury yield and 10-year Treasury yield narrowed to -48 basis points at September month -end versus -76 basis points at August month - end. The spread between the 2-year Treasury and 10-year Treasury yield one year ago was -45 basis points. The inversion between 3-month and 10-year Treasuries narrowed to -88 basis points in September from -134 basis points in August. The shape of the yield curve indicates that the probability of recession persists. 3 CA% 8 Employment 1,000 800 0 0 c 600 c 400 0 c 200 v o,o co 0 2 o -200 Nonfarm Payroll (000's) Unemployment Rate 25.0% 20.0% 15.0% cc co 10.0% —Non-farm Payroll (000's) 5.0% 3 month average (000's) Underemployment Rate (U6) Unemployment Rate (U3) -400 0.0% J / sP 27 S6).0 2f s� 4 sP 4 s� s� 2� sP 4 s 4 sC 4 � � sP p IcP dr19 l9 dr�0 �0 dry �� dry p� dry �� ' d' < p'< d' b� dr�,j � 7 d' p�� a' �c>0) l 1 8 9 9 O O Source: US Department of Labor Source: US Department of Labor The U.S. economy added 336,000 jobs in September, exceeding consensus expectations of 170,000, and the last two months were revised upward by 119,000 jobs. The largest gains came from leisure and hospitality, bringing restaurant and bar employment back in -line with pre -pandemic levels. The pace of job growth has picked up recently, with the three-month moving average payrolls at 266,000 and the six- month moving average at 234,000. The unemployment rate was unchanged at 3.8%, and the labor participation rate was consistent with last month's report at 62.8%. The U-6 underemployment rate, which includes those who are marginally attached to the labor force and employed part time for economic reasons declined slightly to 7.0% from the prior month at 7.1%. Average hourly earnings declined to 4.2% year -over -year in September from 4.3% in August. Employment remains strong by historical standards. 9 IJob Openings & Labor Turnover Survey Job Openings In Thousands (000's) 14,000 12,000 10, 000 8,000 6,000 4,000 2,000 0 Recession Historical Average 14,604 "94 "94 94 94 "94 "94 94 'Toe "94 .94 94 "94 "94 -To 94 94 94 "94 "94 O 'O 6°'O 6°'O a'O 6° O 6°'O a° j e°' j j e°'1 e°V eV a°'1 6°V. 6°Vc 61 a'� 6� 6°� e°'� .�' St S 6 cQ 9 I .>' St S 6 cQ 9 O 0' Source: US Department of Labor The Labor Department's Job Openings and Labor Turnover Survey (JOLTS) unexpectedly increased to 9.61 million in August from a revised 8.92 million in July. The level significantly surpassed the survey of Bloomberg economists' expectations of 8.82 million and reflects approximately 1.5 job openings per available worker. Although JOLTS was an upside surprise, the quits rate remained at a benign 2.3% for August, well below its 3.0% peak in April 2022. Fewer quits can imply that workers are less confident in their ability to find another job in the current market. The current level of job openings remains elevated from a historical perspective. 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 YOY (%) Change Source: US Department of Labor 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 Fed Target .119 l9 19 'O es `),I 2I 2c) �� .�' co) Source: US Department of Commerce The Consumer Price Index (CPI) increased in September by 0.4% month -over -month and 3.7% year -over -year, slightly higher than expected. Gains in shelter and energy costs accounted for a large part of the monthly increase. The Core CPI, which excludes volatile food and energy components, was up 0.3% month -over -month and 4.1% year -over -year, decelerating from 4.3% last month. The Personal Consumption Expenditures (PCE) index rose 0.4% month -over -month and 3.5% year -over -year in August, up from a 3.4% year -over -year gain in July. Core PCE, the Federal Reserve's preferred inflation gauge, increased just 0.1% month -over -month and 3.9% year -over -year in August, down from a 4.3% increase in July. Personal income and spending remained relatively healthy, but the personal savings rate continued its declining trend to 3.9% in August from 4.1% in July. Inflation remains above the Fed's 2% target. 6 a 11 YOY (%) Change Consumer 60.0% 50.0% 40.0% 30.0% 20.0% 10.0% 0.0% -10.0% -20.0% -30.0% Retail Sales YOY % Change uuu_.......uI.■I11 ■�11111I1 IIII I IIIIIIII111��.�.�� .1 'To� ' 6 -q 'P6 90� �P6 'To 1�6 - ' - 1(Q 'l9 19 'p "p l �l `‘-) �� �' \_)0' a cu GJ c Consumer Confidence 140 130 120 110 100 90 80 sPp. �d. SPb. �dr .sPa �a, sPa �d� .sPa �dr, Pa 1d, j9 19 �Q )0 �1 �1 �� �) �J, ‘c)? Source: US Department of Commerce Source: The Conference Board Retail Sales rose 0.6% in August, exceeding the consensus forecast. Sales of motor vehicles and higher gasoline prices drove greater than expected gains. However, Control Group Sales, which are used to calculate gross domestic product and exclude food services, auto dealers, building materials stores and gasoline stations, rose just 0.1%, the smallest advance in five months. On a year -over -year basis, retail sales growth decelerated to a 2.5% gain in August versus a downwardly revised 2.6% gain in July. The Conference Board's Consumer Confidence Index dropped more than expected to 103.0 in September from an upwardly revised 108.7 in August, primarily due to significantly weaker future expectations for employment. While the consumer has been resilient, dwindling excess savings, rising credit card balances, and the resumption of student loan payments pose potential headwinds to future economic growth. 12 ILeading Indicators of Economic Activity 20.0% 15.0% 10.0% O 5.0% c u 0.0% -5.0% >- o -10.0% -15.0% -20.0% -25.0% Leading Economic Indicators (LEI) q4g le@ S 1,60 qGg 9<g 8S Sj 91 9,5, 99 OS Source: The Conference Board le@ 11 -94g. e@15, gGg19 3 Month Average 1.00 0.75 0.50 0.25 0.00 - 0.25 - 0.50 -0.75 - 1.00 Chicago Fed National Activity Index (CFNAI) ' T • Recession LI T I °°'S °aS °09 °0'9 �'9 a°'O 1,60 a0 a? :I" °�'1 'Toe ° 1 °o'� a' > 1 S 9 a' > S 9 a' Source: Federal Reserve Bank of Chicago The Conference Board's Leading Economic Index (LEI) remained in negative territory for the seventeenth consecutive month at -0.4% in August due to weak new orders, deteriorating consumer expectations of business conditions, high interest rates, and tight credit conditions. The index declined 7.6% year -over -year. The consistent decline month -over -month continues to signal future contraction in the economy. The Chicago Fed National Activity Index (CFNAI) surprised to the downside at -0.16 in August from downwardly revised 0.07 in July. On a 3-month moving average basis, the CFNAI remained negative at -0.14 in August, indicating a rate of growth below the historical average trend. 8 a 13 In Thousands of Units Housing 2,400 2,200 2,000 1,800 1,600 1,400 1,200 1,000 800 600 400 200 0 Annualized Housing Starts • Multi Family Housing Starts • Single Family Housing Starts YOY (%) Change q4 q4 14 q4 q4 �� q4 6"'O �'O °�O �O �1 �1 g1 g1 g1 g� �� �' S 9 1 ' S 9 l 24.0% 20.0% 16.0% 12.0% 8.0% 4.0% 0.0% - 4.0% - 8.0% -12.0% -16.0% -20.0% S&P/Case-Shiller 20 City Composite Home Price Index 4/, ✓04 ✓4/, ✓0/, ✓4/, 03) Off. 0.?O9 11 Source: US Department of Commerce Source: S&P ✓�/ ✓4/ ✓0/ ✓44 10) •Is 1) 19 Starts of new homes slowed -11.3% to 1.283 million units at a seasonally adjusted annual rate in August after a downward revision to 1.447 million units in July. The slower starts came from both a 4.3% decline in single-family home starts and 26.3% decline in multi -family homes, continuing the reversal of strong multi -family homebuilding in the second half of 2022 and early 2023. Total starts of new homes are down 14.8% year -over -year. According to Freddie Mac, average 30-year fixed rate mortgage rates increased to 7.35% as of September 28th. Rising mortgage rates are prompting homebuilders to offer incentives to attract buyers and has caused homebuilder sentiment to reach a five -month low. According to the Case-Shiller 20-City Home Price Index, housing prices rose 0.1% year -over -year in July, improving from a 1.2% decline in June. Tight inventories and higher mortgage rates continue to impact affordability. 14 Survey Based Measures 70 65 55 50 45 40 Institute of Supply Management (ISM) Surveys ISM Manufacturing ISM Services ,•: S6 �'/l/ So 6 41 ✓e/ SpQP 47 ✓</�S(,6QP /1dr� ✓(/�SPp60cd�✓<1/2P,0esd4.,)e~��d���� ���Z [D� �SjQ <9 <9 ?o O O 0 z •7 SP Source: Institute for Supply Management The Institute for Supply Management (ISM) Manufacturing index remained in contraction territory at 49.0 in September, up from 47.6 in August. This is the eleventh consecutive month of readings below 50.0, which is indicative of contraction in the manufacturing sector. However, this is the highest reading since November 2022, as both employment and new orders improved, while prices paid subsided. The ISM Services Index eased to 53.6 in September from the six-month high of 54.5 in August. The prices paid component continued to grow primarily due to high labor costs and an uptick in energy costs, but new orders reflected a significant slowdown. Gross Domestic Product (GDP) 6/23 Personal Consumption Expenditures 1.1% 0.8% 2.5% 0.6% Gross Private Domestic Investment -1.5% 0.6% -1.7% 0.9% Net Exports and Imports 2.6% 0.3% 0.6% 0.0% Federal Government Expenditures 0.1% 0.6% 0.3% 0.1% State and Local (Consumption and Gross Investment) 0.4% 0.3% 0.5% 0.5% Total 2.7% 2.6% 2.3% 2.1% Source: US Department of Commerce 40.0% 30.0% 20.0% 10.0% 0.0% - 10.0% -20.0% - 30.0% - 40.0% ■ ■EN Gross Domestic Product (GDP) GDP Q0Q % Change GDP YOY % Change vix. 1cs) 1g 1,g ‘-)p cl c1 ),3) Source: US Department of Commerce According to the third estimate, second quarter annualized GDP growth remained unchanged at 2.1%. A material decline in consumer spending was offset by improvement in business investment. Historically low unemployment, wage growth and savings built up during the pandemic has supported consumer spending at a level to keep economic growth intact, but there are signs the consumer is beginning to show signs of stress. The consensus estimate calls for 3.0% growth for the third quarter and 2.1% for the full year 2023. 11 Q 16 Federal Reserve 10,000,000 9,000,000 8,000,000 7,000,000 c 6,000,000 E 5,000,000 • 4,000,000 3,000,000 2,000,000 1,000,000 0 Federal Reserve Balance Sheet Assets Recession So S4. 6),() SP SP SP SP SP s SP So So "0 0 '60 '60 0,() 0,() �;l I p1 a1 b b� a' S 0 9 l ,�' 9 6.00% 5.00% 4.00% ✓ 3.00% 2.00% 1.00% Source: Federal Reserve Source: Bloomberg Effective Federal Funds Rate Recession At the September meeting, the Federal Open Market Committee voted unanimously to leave the Federal Funds rate unchanged at a target range of 5.25 - 5.50%. Nonetheless, the Fed conveyed a consensus view that another rate hike is possible later in the year, along with its commitment to keeping rates at their current level until inflation subsides closer to its 2% target, endorsing a data -dependent ' higher -for - longer' strategy. The Fed's Summary of Economic Projections (SEP) also revealed expectations of higher economic growth, reduced unemployment, and a gradual easing of inflation compared to earlier forecasts. We believe the resiliency of future economic data will determine if the Federal Reserve can stay on hold for or will tighten policy further to curb inflation. Since the Federal Reserve began its Quantitative Tightening campaign in June 2022, securities holdings have declined by over $1 trillion to $8.024T. Bond Yields US Treasury Note Yields 6.0% 2-Year 5.0% 5-Year 10-Yea r 4.0% -� 3.0% ry 2.0% 1.0% 0.0% /1dr SPA` �dr . 0,o �dr, S o. �dr SPA` �dr , Spa` � 9 j9 �p �� �.1 �1 � ) �� �, .3' Source: Bloomberg 6.0% 4.0% 0 3.0% 2.0% 1.0% 0.0% US Treasury Yield Curve Sep-23 Jun-23 Sep-22 10 410 Pr. yi y�` O . Syr Source: Bloomberg At the end of September, the 2-year Treasury yield was 77 basis points higher, and the 10-Year Treasury yield was about 74 basis points higher, year -over -year. The inversion between the 2-year Treasury yield and 10-year Treasury yield narrowed to -48 basis points at September month -end versus -76 basis points at August month -end. The average historical spread (since 2003) is about +130 basis points. The inversion between 3-month and 10-year Treasuries narrowed to -88 basis points in September from -134 basis points in August. The shape of the yield curve indicates that the probability of recession persists. 13 18 Section 2 I Account Profile 14 c►A 19 Objectives As of September 30, 2023 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. Compliance City of Dublin Assets managed by Chandler Asset Management are in full compliance with state law and with the City's investment policy. As of September 30, 2023 Category Standard Comment U.S. Treasury Issues Federal Agencies Municipal Securities Supranational Securities Asset -Backed Securiti es/Mortgage- Backed Securities/ Col l a tera l i zed Mortgage Obligations 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 No limitations; Full faith and credit of the U.S. are pledged for payment of principal and interest. Complies 35% max per agency issuer; 25% max caIIables 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 Complies 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; Complies "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 Complies for Reconstruction and Development ("IBRD"), the International Finance Corporation ("IFC") or the Inter -American Development Bank ("IADB") "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 - licensed branch ofa 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 core, 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 "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), Supranational securities, or Money Market Mutual Funds 5 years, unless otherwise stated in the policy Complies Complies Complies Complies Complies Complies Complies Complies Complies Complies Complies Complies 16 CM 21 Portfolio Characteristics City of Dublin As of September 30, 2023 09/30/23 06/30/23 Benchmark* Portfolio Portfolio Average Maturity (yrs) Average Modified Duration Average Purchase Yield Average Market Yield Average Quality** Total Market Value *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. 2.65 2.49 n/a 4.98% AA+ 2.89 2.46 2.66% 5.24% AA/Aa1 280,997,577 2.73 2.34 2.38% 4.98% AA/Aa 1 280,145,373 17 CM 22 I Sector Distribution US Treasury 36.6% Supranational 8.3% September 30, 2023 Money Market Fund 0.3 ABS 10.2% 4 Corporate 25.3% Agency 16.7% CMO 2.6% City of Dublin US Treasury 35.6% Supranational 6.0 Money Market Fund 0.9% June 30, 2023 Corporate 25.8% As of September 30, 2023 ABS 10.1% Agency 19.3% CMO 2.4% 18 C►" 23 Issuers City of Dublin - Account #10198 As of September 30, 2023 Issue Name Investment Type % Portfolio Government of United States Federal National Mortgage Association Federal Home Loan Bank Intl Bank Recon and Development Inter -American Dev Bank Federal Home Loan Mortgage Corp Federal Farm Credit Bank Federal Home Loan Mortgage Corp John Deere ABS Bank of Montreal Chicago Bank of America Corp Deere & Company Toronto Dominion Holdings Toyota Motor Corp Amazon.com Inc Honda Motor Corporation Merck & Company Royal Bank of Canada United Health Group Inc JP Morgan Chase & Co JP Morgan ABS Hyundai Auto Receivables Qualcomm Inc Morgan Stanley Metlife Inc Mercedes-Benz Tennessee Valley Authority US Bancorp Northwestern Mutual Glbl Caterpillar Inc Chubb Corporation GM Financial Automobile Leasing Trust Honeywell Corp GM Financial Securitized Term Auto Trust Toyota Lease Owner Trust American Express ABS Berkshire Hathaway Honda ABS US Treasury Agency Agency Supranational Supranational Agency Agency CMO ABS Corporate Corporate Corporate Corporate Corporate Corporate Corporate Corporate Corporate Corporate Corporate ABS ABS Corporate Corporate Corporate ABS Agency Corporate Corporate Corporate Corporate ABS Corporate ABS ABS ABS Corporate ABS 36.60% 5.68% 4.46% 4.40% 3.29% 2.86% 2.83% 2.65% 1.56% 1.48% 1.42% 1.41% 1.38% 1.31% 1.29% 1.22% 1.22% 1.21% 1.18% 1.16% 1.10% 1.08% 1.05% 1.04% 0.99% 0.99% 0.91% 0.89% 0.87% 0.87% 0.86% 0.85% 0.84% 0.83% 0.80% 0.76% 0.75% 0.72% 19 CM 24 Issuers City of Dublin — Account #10198 As of September 30, 2023 Issue Name Investment Type % Portfolio Wal-Mart Stores Charles Schwab Corp/The International Finance Corp BMW ABS Target Corp Dominion Resources Inc Verizon Master Trust Realty Income Corp First American Govt Oblig Fund BMW Vehicle Lease Trust Guardian Life Global Funding Hyundai Auto Lease Securitization Salesforce.com Inc Mercedes-Benz Auto Lease Trust Toyota ABS TOTAL Corporate Corporate Su pra natio na I ABS Corporate Corporate ABS Corporate Money Market Fund ABS Corporate ABS Corporate ABS ABS 0.70% 0.62% 0.57% 0.49% 0.43% 0.34% 0.32% 0.32% 0.31% 0.30% 0.25% 0.24% 0.16% 0.16% 0.01% 100.00% 20 CM 25 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, 2023 vs. June 30, 2023 AA ■ 09/30/23 II A <A ■ 06/30/23 NR As of September 30, 2023 AAA AA A <A NR 09/30/23 06/30/23 Source: S&P Ratings 17.7% 15.5% 58.2% 60.1% 20.1% 20.2% 0.3% 3.7% 0.3% 3.8% 21 CA 26 I Duration Distribution 40.0% 35.0% 30.0% 25.0% 20.0% 15.0% 10.0% 5.0% 0.0% 0 - 0.25 City of Dublin Portfolio Compared to the Benchmark 0.25 - 0.50 0.50 - 1 ■ City of Dublin 1-2 2-3 3-4 As of September 30, 2023 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* 0.0% *ICE BofA 1-5 Yr US Treasury & Agency Index 2.2% 0.0% 8.7% 1.6% 31.1% 35.9% 17.9% 27.1% 25.2% 20.7% 13.9% 14.6% 0.0% 0.0% 22 C►" 27 Investment Performance 3.00% 2.00% 1.00% 0.00% - 1.00% - 2.00% -3.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, 2023 r 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 0.30% 2.60% -1.96% -1.34% 1.17% N/A 1.02% ICE BofA 1-5 Yr US Treasury & Agency Index* 0.23% 2.14% -2.42% -1.75% 0.93% N/A 0.78% *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. 23 CM 28 Portfolio Characteristics City of Dublin Reporting Account As of September 30, 2023 09/30/23 Portfolio 06/30/23 Portfolio Average Maturity (yrs) Modified Duration Average Purchase Yield Average Market Yield Average Quality* Total Market Value *Portfolio is S&P and Moody's, respectively. 0.00 0.00 5.06% 5.06% AAA/NR 109,135,869 0.00 0.00 4.78% 4.78% AAA/NR 120,964,005 24 a 29 Sector Distribution September 30, 2023 Local Gov Investment Pool 75.7% City of Dublin Reporting Account LAI F 24.3% Local Gov Investment Pool 78.3% June 30, 2023 As of September 30, 2023 LAI F 21.7% Issuers City of Dublin Reporting Account — Account #10219 As of September 30, 2023 Issue Name Investment Type % Portfolio CAM P Local Agency Investment Fund TOTAL Local Gov Investment Pool LAI F 75.70% 24.30% 100.00% 26 Q 31 Section 3 I Consolidated Information 27 C►1 32 Portfolio Characteristics City of Dublin Consolidated As of September 30, 2023 Average Maturity (yrs) 2.08 1.91 Modified Duration 1.77 1.63 Average Purchase Yield 3.31% 3.08% Average Market Yield 5.19% 4.92% Average Quality* AA+/Aa1 AA+/Aa1 Total Market Value 390,133,446 401,109,378 * Portfolio is S&P and Moody's respectively. 28 Q 33 I Sector Distribution US Treasury 26.4% Supranational 5.9% Money Market Fund 0.2 Local Gov Investment Pool 21.2% September 30, 2023 LAI F 6.8% ABS 7.3% City of Dublin Consolidated Agency 12.1% CMO 1.9% Corporate 18.2% US Treasury 24.9% Supranational 4.2% Money Market Fund 0.7% Local Gov Investment Pool 23.6% June 30, 2023 LAI F 6.6% As of September 30, 2023 ABS 7.0 Agency 13.5% Corporate 18.0 CMO 1.6% 29 CM 34 Section 4 I Portfolio Holdings Holdings Report City of Dublin - Account #10198 As of September 30, 2023 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 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 05593AAC3 BMW Vehicle Lease Trust 2023-1 A3 5.160% Due 11/25/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 47789C!AC4 John Deere Owner Trust 2021-B A3 0.520% Due 03/16/2026 17,548.44 07/21/2020 17,547.09 0.44% 17,548.11 133,093.10 09/22/2020 133,073.55 0.38% 133,092.28 307,784.82 07/27/2021 307,780.66 0.39% 307,784.31 12,087.67 07/14/2020 12,085.83 0.52% 12,087.52 444,693.66 06/22/2021 444,660.09 0.40% 444,689.83 134,734.02 09/08/2021 134,720.12 0.33% 134,732.60 688,565.02 01/11/2022 688,549.80 1.16% 688,561.35 1,956,638.56 02/23/2022 1,956,330.59 1.98% 1,956,542.48 1,384,952.63 02/15/2022 1,384,940.72 1.91% 1,384,949.57 407,102.11 01/11/2022 407,041.25 1.00% 407,088.65 1,020,000.00 05/03/2022 1,019,893.61 3.45% 1,019,961.08 345,685.07 03/02/2021 345,618.64 0.37% 345,665.87 314,973.30 04/20/2021 314,940.16 0.20% 314,966.54 295,000.00 02/07/2023 294,992.98 4.96% 294,995.06 1,272,713.25 07/20/2021 1,272,432.37 0.15% 1,272,627.39 655,711.53 11/16/2021 655,573.31 0.89% 655,652.16 712,472.15 07/13/2021 712,408.59 0.52% 712,446.83 99.79 7.01% 99.16 6.01% 99.43 5.91% 99.78 5.99% 99.15 5.55% 99.43 5.99% 98.90 5.84% 98.72 6.07% 98.72 6.18% 98.83 6.13% 98.79 6.03% 97.63 6.07% 97.97 5.89% 99.15 6.04% 97.18 6.10% 96.10 6.44% 96.59 5.88% 17,510.72 3.43 131,979.11 17.78 306,032.90 39.50 12,061.19 2.74 440,903.09 79.06 133,969.13 7.41 680,991.50 354.99 1,931,525.10 1,171.81 1,367,268.17 804.04 402,324.77 74.64 1,007,683.50 1,065.90 337,491.64 55.31 308,582.49 53.20 292,506.66 253.70 1,236,822.74 214.95 630,147.30 160.29 688,149.78 164.66 0.01% Aaa / AAA (37.39) NR 0.05% NR / AAA (1,113.17) AAA 0.11% Aaa / NR (1,751.41) AAA 0.00% Aaa / NR (26.33) AAA 0.16% NR/AAA (3,786.74) AAA 0.05% Aaa / NR (763.47) AAA 0.24% Aaa / AAA (7,569.85) NR 0.69% NR/AAA (25,017.38) AAA 0.49% Aaa / NR (17,681.40) AAA 0.14% NR/AAA (4,763.88) AAA 0.36% NR / AAA (12,277.58) AAA 0.12% Aaa / NR (8,174.23) AAA 0.11% NR/AAA (6,384.05) AAA 0.10% Aaa / AAA (2,488.40) AAA 0.44% NR/AAA (35,804.65) AAA 0.22% Aaa / NR (25,504.86) AAA 0.24% Aaa / NR (24,297.05) AAA 1.04 0.03 1.05 0.15 1.06 0.10 1.13 0.04 1.13 0.16 1.24 0.10 1.30 0.23 1.39 0.31 1.47 0.30 1.48 0.23 1.72 0.47 1.96 0.41 1.96 0.37 2.16 1.03 2.30 0.49 2.31 0.70 2.46 0.64 31 CM 36 Holdings Report City of Dublin - Account #10198 As of September 30, 2023 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 44935FAD6 43815BAC4 05602RAD3 362554AC1 47787JAC2 448977AD0 380146AC4 362585AC5 47800AAC4 02582JJT8 47800BAC2 92348KAV5 58768PAC8 362583AD8 05592XAD2 161571HT4 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 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 American Express Credit Trust 2022-2 A 3.390% Due 05/17/2027 John Deere Owner Trust 2022-C A3 5.090% Due 06/15/2027 Verizon Master Trust 2022-5 A1A 3.720% Due 07/20/2027 Mercedes-Benz Auto Receivables 2022-1 A3 5.210% Due 08/16/2027 GM Auto Receivable Trust 2023-2 A3 4.470% Due 02/16/2028 BMW Vehicle Owner Trust 2023-A A3 5.470% Due 02/25/2028 Chase Issuance Trust 23-Al A 5.160% Due 09/15/2028 466,992.68 1,315,000.00 850,000.00 504,419.12 1,005,000.00 1,080,000.00 495,430.85 780, 000.00 1,045,000.00 2,205,000.00 1,350,000.00 915, 000.00 2,790,000.00 625,000.00 550,000.00 3,090,000.00 11/09/2021 0.75% 02/15/2022 1.89% 05/10/2022 3.09% 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% 05/17/2022 3.42% 10/12/2022 5.15% 08/02/2022 3.75% 11/15/2022 5.28% 04/04/2023 4.53% 07/11/2023 5.54% 09/07/2023 5.23% TOTAL ABS 29,170,597.98 2.97% 466,888.46 466,950.09 1,314,802.22 1,314,900.52 849,955.80 849,975.33 504,406.25 504,413.61 1,004,777.69 1,004,875.72 1,079,958.42 1,079,978.18 495,387.80 495,409.80 779,836.98 779,906.77 1,044,900.20 1,044,933.67 2,204,512.25 2,204,734.36 1,349,895.24 1,349,922.47 914,959.74 914,976.27 2,789,448.14 2,789,584.15 624,982.81 624,985.23 549,902.54 549,908.50 3,089,143.45 3,089,155.95 29,166,347.35 29,168,002.25 96.64 5.94% 96.48 5.78% 97.56 5.95% 95.94 6.21% 96.82 6.16% 96.77 5.74% 96.63 5.58% 97.21 5.72% 97.34 5.85% 96.51 5.72% 98.93 5.85% 99.36 4.97% 99.34 5.76% 97.76 5.76% 99.74 5.67% 99.63 5.35% 5.82% 451,305.93 153.59 1,268,673.88 1,098.76 829,218.35 454.75 483,931.63 142.92 972,991.76 1,036.27 1,045,078.19 1,065.60 478,737.31 260.10 758,213.04 1,007.50 1,017,232.26 1,737.02 2,127, 977.15 3,322.20 1,335,579.30 3,054.00 909,179.69 1,040.05 2,771,546.94 6,460.40 611,023.13 1,164.06 548,553.50 501.42 3,078,622.62 7,086.40 28,613,814.47 34,108.45 0.16% (15,644.16) 0.45% (46,226.64) 0.30% (20,756.98) 0.17% (20,481.98) 0.35% (31,883.96) 0.37% (34,899.99) 0.17% (16,672.49) 0.27% (21,693.73) 0.36% (27,701.41) 0.76% (76,757.21) 0.48% (14,343.17) 0.32% (5,796.58) 0.99% (18,037.21) 0.22% (13,962.10) 0.20% (1,355.00) 1.10% (10,533.33) 10.20% (554,187.78) NR/AAA AAA Aaa / AAA NR Aaa / AAA NR Aaa / AAA NR Aaa / NR AAA NR/AAA AAA NR/AAA AAA Aaa / AAA NR Aaa / NR AAA NR/AAA AAA Aaa / NR AAA NR/AAA AAA Aaa / AAA NR Aaa / AAA NR NR/AAA AAA NR/AAA AAA Aaa / AAA AAA 2.62 0.64 2.62 0.91 2.90 0.90 2.96 0.73 2.96 0.83 3.04 0.92 3.13 0.78 3.38 1.08 3.38 1.28 3.63 1.53 3.71 1.51 3.81 0.86 3.88 1.35 4.38 1.80 4.41 1.88 4.96 2.66 3.01 1.08 32 CM 37 Holdings Report City of Dublin - Account #10198 As of September 30, 2023 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 Agency 3130A1XJ2 FHLB Note 2.875% Due 06/14/2024 3133EKWV4 FFCB Note 1.850% Due 07/26/2024 3130A2UW4 FHLB Note 2.875% Due 09/13/2024 3135G0W66 FNMA Note 1.625% Due 10/15/2024 3133ENZ94 FFCB Note 4.500% Due 11/18/2024 3135G0X24 FNMA Note 1.625% Due 01/07/2025 3137EAEPO FHLMC Note 1.500% Due 02/12/2025 3135G03U5 FNMA Note 0.625% Due 04/22/2025 3135G04Z3 FNMA Note 0.500% Due 06/17/2025 3137EAEU9 FHLMC Note 0.375% Due 07/21/2025 3135G05X7 FNMA Note 0.375% Due 08/25/2025 3137EAEX3 FHLMC Note 0.375% Due 09/23/2025 3135G06G3 FNMA Note 0.500% Due 11/07/2025 3130ATUC9 FHLB Note 4.500% Due 12/12/2025 3130ATS57 FHLB Note 4.500% Due 03/10/2028 880591EZ1 Tennessee Valley Authority Note 3.875% Due 03/15/2028 2,100,000.00 Various 2,190,551.70 98.08 2,059,768.20 0.74% Aaa /AA+ 0.71 1.96% 2,112,765.67 5.68% 17,944.79 (52,997.47) NR 0.68 2,500,000.00 08/13/2019 2,524,140.00 97.11 2,427,750.00 0.87% Aaa /AA+ 0.82 1.65% 2,503,992.18 5.49% 8,350.69 (76,242.18) AA+ 0.80 2,000,000.00 10/10/2019 2,122,020.00 97.56 1,951,132.00 0.70% Aaa /AA+ 0.96 1.58% 2,023,603.65 5.54% 2,875.00 (72,471.65) NR 0.92 2,000,000.00 11/08/2019 1,983,400.00 96.15 1,922,946.00 0.69% Aaa /AA+ 1.04 1.80% 1,996,493.61 5.48% 14,986.11 (73,547.61) AA+ 1.00 5,480,000.00 11/15/2022 5,474,191.20 98.99 5,424,515.00 1.96% Aaa /AA+ 1.14 4.56% 5,476,710.20 5.43% 91,105.00 (52,195.20) AA+ 1.07 4,200,000.00 Various 4,287,898.80 95.43 4,008,165.00 1.43% Aaa /AA+ 1.27 1.18% 4,223,094.78 5.39% 15,925.00 (214,929.78) AA+ 1.22 4,200,000.00 Various 4,254,786.30 95.05 3,992,171.41 1.42% Aaa /AA+ 1.37 1.23% 4,215,181.67 5.30% 8,575.00 (223,010.26) AA+ 1.32 1,825,000.00 04/22/2020 1,821,240.50 93.06 1,698,425.30 0.61% Aaa / AA+ 1.56 0.67% 1,823,827.22 5.31% 5,037.76 (125,401.92) AA+ 1.51 3,435,000.00 06/17/2020 3,427,889.55 92.46 3,175,994.13 1.13% Aaa /AA+ 1.72 0.54% 3,432,563.58 5.15% 4,961.67 (256,569.45) AA+ 1.66 1,745,000.00 07/21/2020 1,736,309.90 91.91 1,603,834.74 0.57% Aaa/AA+ 1.81 0.48% 1,741,860.32 5.12% 1,272.40 (138,025.58) AA+ 1.76 2,755,000.00 08/25/2020 2,742,106.60 91.47 2,519,959.93 0.90% Aaa /AA+ 1.90 0.47% 2,750,094.29 5.14% 1,033.13 (230,134.36) AA+ 1.85 2,655,000.00 09/23/2020 2,647,008.45 91.18 2,420,725.46 0.86% Aaa /AA+ 1.98 0.44% 2,651,832.30 5.12% 221.25 (231,106.84) AA+ 1.93 2,860,000.00 11/09/2020 2,849,761.20 90.94 2,600,823.94 0.93% Aaa /AA+ 2.11 0.57% 2,855,681.82 5.10% 5,720.00 (254,857.88) AA+ 2.04 4,000,000.00 02/09/2023 4,029,238.40 98.72 3,948,924.00 1.42% Aaa /AA+ 2.20 4.22% 4,022,662.59 5.12% 54,500.00 (73,738.59) NR 2.04 3,000,000.00 03/21/2023 3,065,010.00 99.46 2,983,854.00 1.06% Aaa /AA+ 4.45 4.01% 3,058,097.09 4.63% 7,875.00 (74,243.09) NR 3.97 2,645,000.00 Various 2,661,791.35 96.51 2,552,819.11 0.91% Aaa /AA+ 4.46 3.73% 2,660,317.01 4.75% 4,555.28 (107,497.90) AA+ 4.03 33 CM 38 Holdings Report City of Dublin - Account #10198 As of September 30, 2023 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 3130AWMN7 FHLB Note 4.375% Due 06/09/2028 TOTAL Agency CMO 3137BFE98 3137BSRE5 3137F4D41 3137FG6X8 TOTAL CMO FHLMC K041 A2 3.171% Due 10/25/2024 FHLMC K059 A2 3.120% Due 09/25/2026 FHLMC K074 A2 3.600% Due 01/25/2028 FHLMC K077 A2 3.850% Due 05/25/2028 1,500,000.00 48,900,000.00 1,992,180.26 2,000,000.00 1,000,000.00 2,815,000.00 7,807,180.26 07/26/2023 4.27% 2.12% 07/01/2021 0.64% 02/18/2022 1.92% 07/25/2023 5.78% 05/24/2023 4.65% 3.03% 1,506,615.00 1,506,369.59 49,323,958.95 49,055,147.57 2,142,994.54 2,038,879.10 2,085,625.00 2,055,318.94 954,414.06 956,218.62 2,763,318.36 2,766,835.66 7,946,351.96 7,817,252.32 98.60 4.71% 5.22% 97.40 5.77% 94.20 5.27% 93.94 5.19% 94.67 5.16% 5.35% 1,478,934.00 14,583.33 0.53% (27,435.59) 46,770,742.22 16.74% 259,521.41 (2,284,405.35) 1,940,295.92 5,264.34 1,884,096.00 5,200.00 939,404.00 600.00 2,664,912.65 1,806.29 7,428,708.57 12,870.63 0.69% (98,583.18) 0.67% (171,222.94) 0.33% (16,814.62) 0.95% (101,923.01) 2.65% (388,543.75) Aaa / AA+ NR Aaa / AA+ AA+ Aaa / AAA AAA NR / AAA AAA NR/NR AAA NR / NR AAA Aaa / AAA AAA 4.70 4.15 1.93 1.81 1.07 0.93 2.99 2.69 4.32 3.82 4.65 4.07 3.25 2.87 Corporate 023135BW5 24422ETT6 02665WCZ2 79466LAG9 02665WEA5 90331HPL1 00440EAS6 14913R2V8 Amazon.com Inc Note 0.450% Due 05/12/2024 John Deere Capital Corp Note 2.650% Due 06/24/2024 American Honda Finance Note 2.400% Due 06/27/2024 Salesforce.com Inc Callable Note Cont 7/15/2022 0.625% Due 07/15/2024 American Honda Finance Note 1.500% Due 01/13/2025 US Bank NA Callable Note Cont 12/21/2024 2.050% Due 01/21/2025 Chubb INA Holdings Inc Note 3.150% Due 03/15/2025 Caterpillar Financial Service Note 3.400% Due 05/13/2025 1,000,000.00 2,000,000.00 1,500,000.00 465,000.00 1,075,000.00 2,610,000.00 2,500,000.00 1,165,000.00 05/10/2021 0.50% Various 1.32% 07/10/2019 2.49% 06/29/2021 0.64% 01/11/2022 1.53% 01/16/2020 2.10% Various 0.76% 05/10/2022 3.44% 998,540.00 999,701.61 2,093,680.00 2,018,905.57 1,493,742.00 1,499,067.52 464,762.85 464,937.85 1,074,150.75 1,074,635.81 2,604,440.70 2,608,545.51 2,753,600.00 2,585,323.35 1,163,520.45 1,164,203.53 96.90 5.63% 97.85 5.68% 97.52 5.86% 96.11 5.72% 94.86 5.70% 94.98 6.10% 96.39 5.76% 96.69 5.56% 969,013.00 1,737.50 1,956,968.00 14,280.56 1,462,837.50 9,400.00 446,917.55 613.54 1,019,726.73 3,493.75 2,478,985.83 10,403.75 2,409,825.00 3,500.00 1,126,401.22 15,183.83 0.35% (30,688.61) 0.70% (61,937.57) 0.52% (36,230.02) 0.16% (18,020.30) 0.36% (54,909.08) 0.89% (129,559.68) 0.86% (175,498.35) 0.41% (37,802.31) Al/AA AA- A2 / A A+ A3/A- A A2/A+ NR A3/A- A A2/A+ A+ A3 / A A A2 / A A+ 0.62 0.60 0.73 0.71 0.74 0.71 0.79 0.77 1.29 1.24 1.31 1.25 1.46 1.39 1.62 1.53 34 CM 39 Holdings Report City of Dublin - Account #10198 As of September 30, 2023 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 747525AF0 61747YEA9 438516CB0 78015K7H1 66815L2J7 02665 W D L2 89114QCK2 06051GHY8 46647PBH8 808513BR5 91324PEC2 89236TJK2 58989V2D5 06368FAC3 931142ER0 59217GER6 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 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 Wal-Mart Stores Callable Note Cont 08/17/2026 1.050% Due 09/17/2026 Metlife Note 1.875% Due 01/11/2027 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 585,000.00 1,860,000.00 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% 09/08/2021 1.09% 01/03/2022 1.90% 3,159,848.58 3,079,001.58 3, 041, 611.70 3,040,356.52 2,559,500.00 2,519,418.97 1, 012, 240.00 1,004,827.26 2,499,150.00 2,499,504.43 1, 007, 640.00 1,003,461.04 997,230.00 998,817.85 1,291,725.00 1,264,537.01 1,030,270.00 1,011,332.51 1,366,821.60 1,368,337.69 1,939,210.15 1,962,111.71 2,483,906.60 2,484,406.59 1,283,817.80 1,284,301.43 2,495,539.50 2,497,361.81 583,894.35 584,344.84 1,857,879.60 1,858,608.85 96.78 5.53% 96.05 6.35% 93.59 5.41% 92.47 5.88% 97.09 5.76% 92.63 5.63% 91.01 5.69% 94.09 6.59% 94.17 6.27% 88.57 5.92% 89.96 5.30% 89.30 5.41% 88.10 5.68% 87.90 5.76% 89.16 5.03% 88.64 5.72% 2,903,436.00 37,662.50 2,920,044.64 8,072.05 2,339,807.50 11,250.00 924,735.00 3,545.83 2,427,317.50 25,000.00 926,294.00 2,766.67 910,115.00 416.67 1,176,166.25 3,358.33 941,672.00 1,002.50 1,213,456.95 6,039.42 1,799,124.00 8,688.89 2,219,055.30 7,998.59 1,132,147.97 758.51 2,197,480.00 1,388.89 521,605.31 238.88 1, 648, 715.16 7,750.00 1.05% (175,565.58) 1.04% (120,311.88) 0.84% (179,611.47) 0.33% (80,092.26) 0.87% (72,186.93) 0.33 % (77,167.04) 0.32% (88,702.85) 0.42% (88,370.76) 0.34% (69,660.51) 0.43% (154,880.74) 0.64% (162,987.71) 0.79% (265,351.29) 0.40% (152,153.46) 0.78% (299,881.81) 0.19% (62,739.53) 0.59% (209,893.69) A2 / A NR Al/A- A+ A2 / A A Al/A AA- Aaa / AA+ AAA A3/A- A Al/A AA- A1/A- AA- A1/A- AA- A2/A- A A2/A+ A Al/A+ A+ Aa3 / AA- AA- A2/A- AA- Aa2 / AA AA Aa3 / AA- AA- 1.64 1.54 1.67 1.58 1.67 1.61 1.70 1.63 1.75 1.65 1.77 1.71 1.95 1.88 2.38 1.31 2.45 1.39 2.62 2.50 2.62 2.51 2.72 2.60 2.96 2.83 2.96 2.83 2.97 2.85 3.28 3.09 35 CM 40 Holdings Report City of Dublin - Account #10198 As of September 30, 2023 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 87612EBM7 808513BY0 084664CZ2 40139LBF9 023135CF1 46647PCB0 927804GH1 14913R3A3 931142EX7 89236TKJ3 023135CP9 89115A2 M 3 756109AU8 24422 E W R6 06051GGF0 Target Corp Callable Note Cont 12/15/2026 1.950% Due 01/15/2027 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 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 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.94% Various 3.75% 1,337,722.00 1,338,493.03 584,368.20 584,567.84 2,294,563.95 2,294,698.87 765,000.00 765,000.00 1,746,972.50 1,747,844.66 449, 845.00 461,698.21 999,773.40 999,826.17 90.31 5.19% 89.07 6.03% 91.73 4.93% 92.28 5.71% 94.09 5.15% 89.24 6.18% 94.38 5.48% 1,210,206.26 5,516.33 521,084.66 1,114.75 2,105, 281.53 2,346.00 705,936.65 137.96 1,646,576.75 26,950.00 446,216.00 3,484.75 943, 798.00 14,166.67 0.43% (128,286.77) 0.19% (63,483.18) 0.75% (189,417.34) 0.25% (59,063.35) 0.60% (101,267.91) 0.16% (15,482.21) 0.34% (56,028.17) A2 / A A A2/A- A Aa2 / AA A+ Aa 1 / AA+ NR Al/AA AA- A1/A- AA- A2 / BBB+ A 3.30 3.10 3.42 3.19 3.46 3.25 3.50 3.23 3.54 3.22 3.56 2.42 3.62 3.28 Caterpillar Financial Service Note 1,375,000.00 Various 1,357,243.75 94.35 1,297,257.50 0.46% A2 / A 3.87 3.600% Due 08/12/2027 3.89% 1,361,057.63 5.23% 6,737.50 (63,800.13) A+ 3.53 Wal-Mart Stores Callable Note Cont 09/09/2027 1,500,000.00 Various 1,498,302.30 96.50 1,447,428.00 0.52% Aa2 / AA 3.95 3.950% Due 09/09/2027 3.98% 1,498,662.11 4.94% 3,620.83 (51,234.11) AA 3.59 Toyota Motor Credit Corp Note 1,500,000.00 11/22/2022 1,479,060.00 97.28 1,459,204.50 0.52% Al / A+ 3.98 4.550% Due 09/20/2027 4.88% 1,482,748.30 5.32% 2,085.42 (23,543.80) A+ 3.57 Amazon.com Inc Callable Note Cont 11/1/2027 1,000,000.00 01/17/2023 1,014,400.00 97.93 979,309.00 0.35% Al / AA 4.17 4.550% Due 12/01/2027 4.21% 1,012,298.11 5.11% 15,166.67 (32,989.11) AA- 3.69 Toronto -Dominion Bank Note 3,000,000.00 Various 2,984,380.00 97.60 2,927,973.00 1.05% Al / A 4.28 5.156% Due 01/10/2028 5.28% 2,985,401.30 5.80% 34,803.00 (57,428.30) AA- 3.74 Realty Income Corp Callable Note Cont 10/15/2027 960,000.00 04/10/2023 910,540.80 92.12 884,314.56 0.32% A3 / A- 4.30 3.650% Due 01/15/2028 4.87% 915,432.68 5.75% 7,397.33 (31,118.12) NR 3.85 John Deere Capital Corp Note 2,000,000.00 01/23/2023 2,030,780.00 98.19 1,963,702.00 0.71% A2 / A 4.31 4.750% Due 01/20/2028 4.40% 2,026,571.20 5.22% 18,736.11 (62,869.20) A+ 3.81 Bank of America Corp Callable Note 1/20/2027 3,000,000.00 Various 2,824,349.55 92.86 2,785,920.00 1.00% Al / A- 4.31 3.824% Due 01/20/2028 5.89% 2,843,728.99 6.24% 22,625.34 (57,808.99) AA- 3.01 36 a 41 Holdings Report City of Dublin - Account #10198 As of September 30, 2023 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 06368LGV2 91324PEP3 46647PAF3 58933YBH7 78016HZS2 Bank of Montreal Callable Note Cont 1/1/2028 5.203% Due 02/01/2028 United Health Group Inc Callable Note Cont 1/15/2028 5.250% Due 02/15/2028 JP Morgan Chase & Co Callable Note 2X 5/1/2027 3.540% Due 05/01/2028 Merck & Co Callable Note Cont 4/17/2028 4.050% Due 05/17/2028 ROYAL BANK OF CANADA Note 5.200% Due 08/01/2028 TOTAL Corporate 2,000,000.00 1,500,000.00 2,000,000.00 3,500,000.00 2,500,000.00 74,760,000.00 08/17/2023 5.56% 02/21/2023 4.90% 08/16/2023 6.08% Various 4.06% 09/07/2023 5.54% 2.86% 1,972,380.00 1,973,076.87 1,522,890.00 1,520,071.98 1,854,340.00 1,858,070.52 3,497,960.40 3,498,113.35 2,464,100.00 2,464,502.02 74,845,693.48 74,507,914.68 97.61 5.83% 100.17 5.20% 91.95 6.07% 96.23 4.97% 97.33 5.84% 5.64% 1,952,168.00 17,343.33 1,502,548.50 10,062.50 1,838,990.00 29,500.00 3,367,917.00 52,762.51 2,433,272.50 25,638.89 0.70% (20,908.87) 0.54% (17,523.48) 0.66% (19,080.52) 1.22% (130,196.35) 0.88% (31,229.52) 70,490,951.82 25.26% 484,746.55 (4,016,962.86) A2 /A- AA- A2 / A+ A Al/A- AA- A1/ A+ NR Al/A AA- A1/A A+ 4.34 3.79 4.38 3.84 4.59 3.24 4.63 4.09 4.84 4.17 2.93 2.59 Money Market Fund 31846V203 First American Govt Obligation Fund Class Y TOTAL Money Market Fund 859,486.86 859,486.86 Various 4.94% 4.94% 859,486.86 859,486.86 859,486.86 859,486.86 1.00 4.94% 4.94% 859,486.86 0.00 859,486.86 0.00 0.31% 0.00 0.31% 0.00 Aaa / AAA AAA Aaa / AAA AAA 0.00 0.00 0.00 0.00 Supranational 4581XODZ8 459058JB0 4581X0DN5 459058JL8 4581X0DV7 459058KT9 Inter -American Dev Bank Note 0.500% Due 09/23/2024 Intl. Bank Recon & Development Note 0.625% Due 04/22/2025 Inter -American Dev Bank Note 0.625% Due 07/15/2025 Intl. Bank Recon & Development Note 0.500% Due 10/28/2025 Inter -American Dev Bank Note 0.875% Due 04/20/2026 Intl. Bank Recon & Development Note 3.500% Due 07/12/2028 3,680,000.00 2,260,000.00 1,685,000.00 6,000,000.00 4,615,000.00 5,000,000.00 09/15/2021 0.52% 04/15/2020 0.70% 01/13/2021 0.53% Various 0.55% 04/13/2021 0.97% Various 4.35% 3,677,276.80 3,679,110.49 2,251,253.80 2,257,274.60 1,692,329.75 1,687,914.94 5,986,632.00 5,994,150.44 4,593,863.30 4,604,211.72 4,813,059.00 4,817,937.83 95.14 5.67% 92.93 5.41% 92.23 5.23% 91.01 5.12% 90.23 4.99% 94.74 4.74% 3,501,085.76 408.89 2,100,297.10 6,238.54 1,554,011.47 2,223.26 5,460,330.00 12,750.00 4,164,239.11 18,059.39 4,737,085.01 38,402.77 1.25% (178,024.73) 0.75% (156,977.50) 0.55% (133,903.47) 1.95% (533,820.44) 1.49% (439,972.61) 1.70% (80,852.82) Aaa / AAA NR Aaa / AAA NR Aaa / AAA NR Aaa / AAA AAA Aaa / AAA AAA Aaa / AAA NR 0.98 0.95 1.56 1.51 1.79 1.74 2.08 2.01 2.56 2.46 4.79 4.30 37 CM 42 Holdings Report City of Dublin - Account #10198 As of September 30, 2023 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 45950KDD9 International Finance Corp Note 4.500% Due 07/13/2028 TOTAL Supranational US Treasury 91282CDZ1 912828ZC7 91282CED9 912828ZL7 91282CFE6 91282CAM3 91282CFP1 91282CBC4 91282CBH3 91282CBQ3 91282CBT7 91282CCF6 91282CCW9 91282CDG3 US Treasury Note 1.500% Due 02/15/2025 US Treasury Note 1.125% Due 02/28/2025 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 4.250% Due 10/15/2025 US Treasury Note 0.375% Due 12/31/2025 US Treasury Note 0.375% Due 01/31/2026 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 US Treasury Note 0.750% Due 08/31/2026 US Treasury Note 1.125% Due 10/31/2026 1,605,000.00 24,845,000.00 2,000,000.00 2,000,000.00 2,000,000.00 4,000,000.00 3,000,000.00 2,500,000.00 10,000,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 07/06/2023 4.53% 1.64% 05/06/2022 2.92% 03/24/2020 0.52% 03/15/2022 2.00% Various 0.38% Various 4.34% 10/16/2020 0.32% Various 4.24% 12/29/2020 0.38% 02/23/2021 0.58% 03/26/2021 0.83% Various 0.85% 06/18/2021 0.91% 08/30/2021 0.77% Various 1.25% 1,603,218.45 1,603,296.46 24,617,633.10 24,643,896.48 1,925,156.25 1,962,836.72 2,058,984.38 2,016,899.47 1,985,312.50 1,992,877.57 3,998,593.75 3,999,544.15 2,905,703.13 2,936,223.47 2,491,406.25 2,496,528.26 10,002,724.61 10,002,245.48 999,921.88 999,964.83 3,960,625.00 3,981,361.33 2,459,960.94 2,480,370.39 4,974,804.69 4,987,373.90 1,985,000.00 1,991,914.13 1,998,515.63 1,999,134.25 4,970,498.06 4,981,423.66 98.82 4.78% 5.11% 94.99 5.32% 94.39 5.28% 95.09 5.29% 92.71 5.23% 96.47 5.12% 91.00 5.04% 98.43 5.07% 90.40 4.93% 90.02 4.96% 90.03 4.92% 90.43 4.86% 89.81 4.87% 89.05 4.82% 89.60 4.79% 1,586,043.35 15,648.75 0.57% (17,253.11) 23,103,091.80 8.26% 93,731.60 (1,540,804.68) 1,899,844.00 3,831.52 1,887,812.00 1,916.21 1,901,876.00 1,538.46 3,708,280.00 6,277.18 2,894,181.00 11,973.51 2,275,000.00 17.08 9,843,360.00 196,243.17 904,023.00 947.69 3,600,780.00 2,527.17 2,250,782.50 1,064.56 4,521,485.00 102.46 1,796,172.00 5,040.98 1,781,016.00 1,277.47 4,480,080.00 23,539.40 0.68% (62,992.72) 0.67% (129,087.47) 0.68% (91,001.57) 1.32% (291,264.15) 1.03% (42,042.47) 0.81 % (221,528.26) 3.57% (158,885.48) 0.32% (95,941.83) 1.28% (380,581.33) 0.80% (229,587.89) 1.61% (465,888.90) 0.64% (195,742.13) 0.63% (218,118.25) 1.60% (501,343.66) Aaa / AAA NR Aaa / AAA AAA Aaa / AA+ AA+ Aaa / AA+ AA+ Aaa / AA+ AA+ Aaa / AA+ AA+ Aaa / AA+ AA+ Aaa / AA+ AA+ Aaa / AA+ AA+ Aaa / AA+ AA+ Aaa / AA+ AA+ Aaa / AA+ AA+ Aaa / AA+ AA+ Aaa / AA+ AA+ Aaa / AA+ AA+ Aaa / AA+ AA+ 4.79 4.21 2.68 2.49 1.38 1.33 1.42 1.37 1.46 1.41 1.58 1.54 1.88 1.78 2.00 1.95 2.04 1.89 2.25 2.19 2.34 2.27 2.42 2.35 2.50 2.42 2.67 2.57 2.92 2.82 3.09 2.95 38 CM 43 Holdings Report City of Dublin - Account #10198 As of September 30, 2023 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 912828Z78 91282CEN7 91282CEW7 91282CFM8 91282CGC9 91282CGT2 91282CHE4 91282CHQ7 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 US Treasury Note 4.125% Due 09/30/2027 US Treasury Note 3.875% Due 12/31/2027 US Treasury Note 3.625% Due 03/31/2028 US Treasury Note 3.625% Due 05/31/2028 US Treasury Note 4.125% Due 07/31/2028 TOTAL US Treasury TOTAL PORTFOLIO TOTAL MARKET VALUE PLUS ACCRUALS 4,500,000.00 7,000,000.00 9,000,000.00 10,000,000.00 10,000,000.00 7,000,000.00 4,500,000.00 9,000,000.00 108,000,000.00 294,342,265.10 Various 2.15% Various 3.55% Various 3.21% Various 3.95% Various 3.70% Various 3.58% Various 4.07% Various 4.51% 2.88% 4,367,285.16 4,407,603.46 6,761,484.38 6,816,342.07 9,018,066.41 9,010,512.87 10,074,062.50 10,061,898.12 10,078,828.13 10,067,970.09 7,014,042.96 7,012,903.14 4,412,773.44 4,416,874.18 8,848,203.13 8,849,166.12 107,291,953.18 107,471,967.66 294,051,424.88 2.66% 293,523,667.82 90.04 4.77% 93.51 4.74% 95.01 4.72% 97.92 4.70% 96.92 4.68% 95.87 4.65% 95.84 4.62% 97.84 4.63% 4.83% 4,051,759.50 11,372.28 6,545,819.00 80,557.06 8,551,053.00 73,919.84 9,791,800.00 1,127.04 9,691,800.00 97,927.99 6,710,704.00 693.31 4,312,971.00 54,820.69 8,805,942.00 62,547.55 102,206,540.00 639,262.62 1.45% (355,843.96) 2.36% (270,523.07) 3.07% (459,459.87) 3.49% (270,098.12) 3.48% (376,170.09) 2.39% (302,199.14) 1.55% (103,903.18) 3.16% (43,224.12) 36.60% (5,265,427.66) Aaa / AA+ AA+ Aaa / AA+ AA+ Aaa / AA+ AA+ Aaa / AA+ AA+ Aaa / AA+ AA+ Aaa / AA+ AA+ Aaa / AA+ AA+ Aaa / AA+ AA+ Aaa / AA+ AA+ 279,473,335.74 100.00% Aa1 / AA 5.24% 1,524,241.26 (14,050,332.08) AA+ 280,997,577.00 3.34 3.18 3.58 3.31 3.75 3.44 4.00 3.64 4.25 3.83 4.50 4.09 4.67 4.18 4.84 4.30 3.30 3.04 2.89 2.46 39 CM 44 Holdings Report City of Dublin Reporting Account - Account #10219 As of September 30, 2023 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 LAIF 90LAIF$00 Local Agency Investment Fund State Pool TOTAL LAIF Local Gov Investment Pool 90CAMP$00 California Asset Mgmt Program CAMP TOTAL Local Gov Investment Pool TOTAL PORTFOLIO TOTAL MARKET VALUE PLUS ACCRUALS 26,297,089.57 26,297,089.57 82,616,317.44 82,616,317.44 108,913,407.01 Various 26,297,089.57 3.61% 26,297,089.57 26,297,089.57 3.61% 26,297,089.57 Various 82,616,317.44 5.52% 82,616,317.44 82,616,317.44 5.52% 82,616,317.44 108,913,407.01 5.06% 108,913,407.01 1.00 3.61% 3.61% 1.00 5.52% 5.52% 5.06% 26,297,089.57 222,461.84 26,297,089.57 222,461.84 82,616,317.44 0.00 82,616,317.44 0.00 108,913,407.01 222,461.84 109,135,868.85 24.30% 0.00 24.30% 0.00 75.70% 0.00 75.70% 0.00 NR / NR NR NR / NR NR NR/AAA NR NR / AAA NR 100.00% NR / AAA 0.00 NR 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 40 CM 45 Section 5 I Transactions 41 Q 46 Transaction Ledger City of Dublin - Account #10198 June 30, 2023 through September 30, 2023 As of September 30, 2023 Transaction Settlement Type Date CUSIP Quantity Security Description Acq/Disp Price Yield Amount Interest Pur/Sold Total Amount Gain/Loss ACQUISITIONS Purchase 07/13/2023 45950KDD9 1,605,000.00 International Finance Corp Note 99.889 4.53% 1,603,218.45 0.00 1,603,218.45 0.00 4.5% Due: 07/13/2028 Purchase 07/18/2023 05592XAD2 550,000.00 BMW Vehicle Owner Trust 2023-A A3 99.982 5.54% 549,902.54 0.00 549,902.54 0.00 5.47% Due: 02/25/2028 Purchase 07/18/2023 459058KT9 1,300,000.00 Intl. Bank Recon & Development Note 97.148 4.14% 1,262,924.00 758.33 1,263,682.33 0.00 3.5% Due: 07/12/2028 Purchase 07/21/2023 91282CHE4 2,500,000.00 US Treasury Note 97.883 4.11% 2,447,070.31 12,628.07 2,459,698.38 0.00 3.625% Due: 05/31/2028 Purchase 07/27/2023 3130AWMN7 1,500,000.00 FHLB Note 100.441 4.27% 1,506,615.00 2,916.67 1,509,531.67 0.00 4.375% Due: 06/09/2028 Purchase 07/27/2023 459058KT9 1,625,000.00 Intl. Bank Recon & Development Note 96.313 4.33% 1,565,086.25 2,369.79 1,567,456.04 0.00 3.5% Due: 07/12/2028 Purchase 07/28/2023 3137F4D41 1,000,000.00 FHLMCK074A2 95.441 5.78% 954,414.06 2,700.00 957,114.06 0.00 3.6% Due: 01/25/2028 Purchase 08/18/2023 46647PAF3 2,000,000.00 JP Morgan Chase & Co Callable Note 2X 5/1/2027 92.717 6.08% 1,854,340.00 21,043.33 1,875,383.33 0.00 3.54% Due: 05/01/2028 Purchase 08/21/2023 06368LGV2 2,000,000.00 Bank of Montreal Callable Note Cont 1/1/2028 98.619 5.56% 1,972,380.00 5,781.11 1,978,161.11 0.00 5.203% Due: 02/01/2028 Purchase 08/31/2023 91282CHQ7 1,000,000.00 US Treasury Note 99.227 4.30% 992,265.63 3,474.86 995,740.49 0.00 4.125% Due: 07/31/2028 Purchase 09/08/2023 459058KT9 2,075,000.00 Intl. Bank Recon & Development Note 95.665 4.51% 1,985,048.75 11,297.22 1,996,345.97 0.00 3.5% Due: 07/12/2028 Purchase 09/11/2023 78016HZS2 2,500,000.00 ROYAL BANK OF CANADA Note 98.564 5.54% 2,464,100.00 18,416.67 2,482,516.67 0.00 5.2% Due: 08/01/2028 Purchase 09/12/2023 91282CHQ7 3,000,000.00 US Treasury Note 98.637 4.44% 2,959,101.56 14,459.92 2,973,561.48 0.00 4.125% Due: 07/31/2028 Purchase 09/15/2023 161571HT4 3,090,000.00 Chase Issuance Trust 23-Al A 99.972 5.23% 3,089,143.45 0.00 3,089,143.45 0.00 5.16% Due: 09/15/2028 Purchase 09/21/2023 91282CHQ7 2,000,000.00 US Treasury Note 98.176 4.55% 1,963,515.63 11,657.61 1,975,173.24 0.00 4.125% Due: 07/31/2028 42 CM 47 Transaction Ledger City of Dublin - Account #10198 June 30, 2023 through September 30, 2023 As of September 30, 2023 Transaction Type Settlement Date CUSIP Quantit Security Descrip '. . Price Acq/Disp Yield Amount Interest Total Amount Gain/Loss Pur/Sold Purchase Subtotal 09/26/2023 TOTAL ACQUISITIONS 91282CHQ7 3,000,000.00 US Treasury Note 4.125% Due: 07/31/2028 30,745,000.00 30,745,000.00 97.777 4.64% 2,933,320.31 19,167.80 2,952,488.11 30,102,445.94 126,671.38 30,229,117.32 30,102,445.94 126,671.38 30,229,117.32 0.00 0.00 0.00 DISPOSITIONS Sale Sale Sale Sale Sale Sale Sale Sale Sale Sale Subtotal 07/17/2023 3130A0F70 5,000,000.00 07/18/2023 023135BW5 865,000.00 09/07/2023 912828YH7 2,000,000.00 09/11/2023 78013XZU5 2,500,000.00 09/11/2023 9128283J7 1,500,000.00 09/11/2023 912828YH7 1,500,000.00 09/12/2023 9128283J7 1,500,000.00 09/12/2023 912828ZC7 1,500,000.00 09/21/2023 3135G0V34 2,000,000.00 09/26/2023 3130A1XJ2 1,695,000.00 20,060,000.00 FHLB Note 3.375% Due: 12/08/2023 Amazon.com Inc Note 0.45% Due: 05/12/2024 US Treasury Note 1.5% Due: 09/30/2024 Royal Bank of Canada Note 2.55% Due: 07/16/2024 US Treasury Note 2.125% Due: 11/30/2024 US Treasury Note 1.5% Due: 09/30/2024 US Treasury Note 2.125% Due: 11/30/2024 US Treasury Note 1.125% Due: 02/28/2025 FNMA Note 2.5% Due: 02/05/2024 FHLB Note 2.875% Due: 06/14/2024 99.191 2.73% 4,959,550.00 18,281.25 4,977,831.25 -52,304.30 96.003 0.50% 830,425.95 713.63 831,139.58 -34,229.52 95.988 1.65% 1,919,765.63 13,114.75 1,932,880.38 -77,088.51 97.253 2.28% 2,431,325.00 9,739.58 2,441,064.58 -74,146.69 96.242 1.76% 1,443,632.81 8,970.29 1,452,603.10 -62,726.39 96.059 1.65% 1,440,878.91 10,081.97 1,450,960.88 -56,785.94 96.234 1.76% 1,443,515.63 9,057.38 1,452,573.01 -62,829.30 94.277 0.52% 1,414,160.16 556.32 1,414,716.48 -98,981.14 98.874 2.58% 1,977,480.00 6,388.89 1,983,868.89 -21,937.96 98.123 1.96% 1,663,184.85 13,807.19 1,676,992.04 -42,319.33 19,523,918.94 90,711.25 19,614,630.19 -583,349.08 43 CM 48 Transaction Ledger City of Dublin - Account #10198 June 30, 2023 through September 30, 2023 As of September 30, 2023 Transaction Type Settlement Date CUSIP Quantity Security Description Acq/Disp Price Yield Amount Interest Pur/Sold Total Amount Gain/Loss Call 07/23/2023 46647PAU0 Subtotal Maturity 08/11/2023 06406RAJ6 Subtotal 2,500,000.00 JP Morgan Chase & Co Callable Note 1X 7/23/2023 100.000 Due: 07/23/2024 2,500,000.00 1, 200, 000.00 1,200,000.00 TOTAL DISPOSITIONS 23,760,000.00 Bank of NY Mellon Corp Note 3.45% Due: 08/11/2023 100.000 2.35% 2,500,000.00 2,500,000.00 1,200,000.00 1,200,000.00 0.00 0.00 0.00 2,500,000.00 2,500,000.00 1, 200, 000.00 0.00 1,200,000.00 0.00 0.00 0.00 0.00 23,223,918.94 90,711.25 23,314,630.19 -583,349.08 44 CM 49 Transaction Ledger City of Dublin Reporting Account - Account #10219 June 30, 2023 through September 30, 2023 As of September 30, 2023 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/2023 90LAIF$00 204,860.61 Purchase 07/31/2023 90CAMP$00 425,172.48 Purchase 08/31/2023 90CAMP$00 392,308.67 Purchase 09/29/2023 90CAMP$00 372,957.34 Local Agency Investment Fund State Pool California Asset Mgmt Program CAMP California Asset Mgmt Program CAMP California Asset Mgmt Program CAMP 1.000 3.26% 204,860.61 0.00 204,860.61 1.000 5.43% 425,172.48 0.00 425,172.48 1.000 5.54% 392,308.67 0.00 392,308.67 1.000 5.54% 372,957.34 0.00 372,957.34 Subtotal 1,395,299.10 Security 07/11/2023 90CAMP$00 4,000,000.00 California Asset Mgmt Program CAMP 1.000 Contribution Security 09/07/2023 90CAMP$00 4,500,000.00 California Asset Mgmt Program CAMP 1.000 Contribution Subtotal 8,500,000.00 TOTAL ACQUISITIONS 9,895,299.10 0.00 0.00 0.00 0.00 1,395,299.10 0.00 1,395,299.10 0.00 4,000,000.00 0.00 4,000,000.00 0.00 4,500,000.00 0.00 4,500,000.00 0.00 8,500,000.00 0.00 8,500,000.00 0.00 9,895,299.10 0.00 9,895,299.10 0.00 DISPOSITIONS Security 07/18/2023 90CAMP$00 7,000,000.00 California Asset Mgmt Program CAMP 1.000 7,000,000.00 0.00 7,000,000.00 0.00 Withdrawal Security 08/02/2023 90CAMP$00 550,000.00 California Asset Mgmt Program CAMP 1.000 550,000.00 0.00 550,000.00 0.00 Withdrawal Security 08/08/2023 90CAMP$00 5,500,000.00 California Asset Mgmt Program CAMP 1.000 5,500,000.00 0.00 5,500,000.00 0.00 Withdrawal Security 08/17/2023 90CAMP$00 6,300,000.00 California Asset Mgmt Program CAMP 1.000 6,300,000.00 0.00 6,300,000.00 0.00 Withdrawal Security 08/22/2023 90CAMP$00 1,700,000.00 California Asset Mgmt Program CAMP 1.000 1,700,000.00 0.00 1,700,000.00 0.00 Withdrawal 45 CM 50 Transaction Ledger City of Dublin Reporting Account - Account #10219 June 30, 2023 through September 30, 2023 As of September 30, 2023 Transaction Settlement Type Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Total Amount Gain/Loss Pur/Sold Security Withdrawal Subtotal TOTAL DISPOSITIONS 09/20/2023 90CAM P$00 700,000.00 California Asset Mgmt Program CAMP 21,750,000.00 21,750,000.00 1.000 700,000.00 21,750,000.00 0.00 700, 000.00 0.00 0.00 21,750,000.00 0.00 21,750,000.00 0.00 21,750,000.00 0.00 46 Q 51 Important Disclosures 2023 Chandler Asset Management, Inc, An Independent Registered Investment Adviser. As of September 30, 2023 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. Your qualified custodian bank maintains control of all assets reflected in this statement and we urge you to compare this statement to the one you receive from your qualified custodian. Chandler does not have any authority to withdraw or deposit funds from/to the custodian account. 47 CM 52 Benchmark Disclosures As of September 30, 2023 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. 48 a;. 53 Attachment 2 Transaction Ledger City of Dublin - Account #10198 June 30, 2023 through September 30, 2023 As of September 30, 2023 Transaction Settlement Type Date CUSIP Quantity Security Description Acq/Disp Price Yield Amount Interest Pur/Sold Total Amount Gain/Loss ACQUISITIONS Purchase 07/13/2023 45950KDD9 1,605,000.00 International Finance Corp Note 99.889 4.53% 1,603,218.45 0.00 1,603,218.45 0.00 4.5% Due: 07/13/2028 Purchase 07/18/2023 05592XAD2 550,000.00 BMW Vehicle Owner Trust 2023-A A3 99.982 5.54% 549,902.54 0.00 549,902.54 0.00 5.47% Due: 02/25/2028 Purchase 07/18/2023 459058KT9 1,300,000.00 Intl. Bank Recon & Development Note 97.148 4.14% 1,262,924.00 758.33 1,263,682.33 0.00 3.5% Due: 07/12/2028 Purchase 07/21/2023 91282CHE4 2,500,000.00 US Treasury Note 97.883 4.11% 2,447,070.31 12,628.07 2,459,698.38 0.00 3.625% Due: 05/31/2028 Purchase 07/27/2023 3130AWMN7 1,500,000.00 FHLB Note 100.441 4.27% 1,506,615.00 2,916.67 1,509,531.67 0.00 4.375% Due: 06/09/2028 Purchase 07/27/2023 459058KT9 1,625,000.00 Intl. Bank Recon & Development Note 96.313 4.33% 1,565,086.25 2,369.79 1,567,456.04 0.00 3.5% Due: 07/12/2028 Purchase 07/28/2023 3137F4D41 1,000,000.00 FHLMCK074A2 95.441 5.78% 954,414.06 2,700.00 957,114.06 0.00 3.6% Due: 01/25/2028 Purchase 08/18/2023 46647PAF3 2,000,000.00 JP Morgan Chase & Co Callable Note 2X 5/1/2027 92.717 6.08% 1,854,340.00 21,043.33 1,875,383.33 0.00 3.54% Due: 05/01/2028 Purchase 08/21/2023 06368LGV2 2,000,000.00 Bank of Montreal Callable Note Cont 1/1/2028 98.619 5.56% 1,972,380.00 5,781.11 1,978,161.11 0.00 5.203% Due: 02/01/2028 Purchase 08/31/2023 91282CHQ7 1,000,000.00 US Treasury Note 99.227 4.30% 992,265.63 3,474.86 995,740.49 0.00 4.125% Due: 07/31/2028 Purchase 09/08/2023 459058KT9 2,075,000.00 Intl. Bank Recon & Development Note 95.665 4.51% 1,985,048.75 11,297.22 1,996,345.97 0.00 3.5% Due: 07/12/2028 Purchase 09/11/2023 78016HZS2 2,500,000.00 ROYAL BANK OF CANADA Note 98.564 5.54% 2,464,100.00 18,416.67 2,482,516.67 0.00 5.2% Due: 08/01/2028 Purchase 09/12/2023 91282CHQ7 3,000,000.00 US Treasury Note 98.637 4.44% 2,959,101.56 14,459.92 2,973,561.48 0.00 4.125% Due: 07/31/2028 Purchase 09/15/2023 161571HT4 3,090,000.00 Chase Issuance Trust 23-Al A 99.972 5.23% 3,089,143.45 0.00 3,089,143.45 0.00 5.16% Due: 09/15/2028 Purchase 09/21/2023 91282CHQ7 2,000,000.00 US Treasury Note 98.176 4.55% 1,963,515.63 11,657.61 1,975,173.24 0.00 4.125% Due: 07/31/2028 42 CM 54 Transaction Ledger City of Dublin - Account #10198 June 30, 2023 through September 30, 2023 As of September 30, 2023 Transaction Type Settlement Date CUSIP Quantit Security Descrip '. . Price Acq/Disp Yield Amount Interest Total Amount Gain/Loss Pur/Sold Purchase Subtotal 09/26/2023 TOTAL ACQUISITIONS 91282CHQ7 3,000,000.00 US Treasury Note 4.125% Due: 07/31/2028 30,745,000.00 30,745,000.00 97.777 4.64% 2,933,320.31 19,167.80 2,952,488.11 30,102,445.94 126,671.38 30,229,117.32 30,102,445.94 126,671.38 30,229,117.32 0.00 0.00 0.00 DISPOSITIONS Sale Sale Sale Sale Sale Sale Sale Sale Sale Sale Subtotal 07/17/2023 3130A0F70 5,000,000.00 07/18/2023 023135BW5 865,000.00 09/07/2023 912828YH7 2,000,000.00 09/11/2023 78013XZU5 2,500,000.00 09/11/2023 9128283J7 1,500,000.00 09/11/2023 912828YH7 1,500,000.00 09/12/2023 9128283J7 1,500,000.00 09/12/2023 912828ZC7 1,500,000.00 09/21/2023 3135G0V34 2,000,000.00 09/26/2023 3130A1XJ2 1,695,000.00 20,060,000.00 FHLB Note 3.375% Due: 12/08/2023 Amazon.com Inc Note 0.45% Due: 05/12/2024 US Treasury Note 1.5% Due: 09/30/2024 Royal Bank of Canada Note 2.55% Due: 07/16/2024 US Treasury Note 2.125% Due: 11/30/2024 US Treasury Note 1.5% Due: 09/30/2024 US Treasury Note 2.125% Due: 11/30/2024 US Treasury Note 1.125% Due: 02/28/2025 FNMA Note 2.5% Due: 02/05/2024 FHLB Note 2.875% Due: 06/14/2024 99.191 2.73% 4,959,550.00 18,281.25 4,977,831.25 -52,304.30 96.003 0.50% 830,425.95 713.63 831,139.58 -34,229.52 95.988 1.65% 1,919,765.63 13,114.75 1,932,880.38 -77,088.51 97.253 2.28% 2,431,325.00 9,739.58 2,441,064.58 -74,146.69 96.242 1.76% 1,443,632.81 8,970.29 1,452,603.10 -62,726.39 96.059 1.65% 1,440,878.91 10,081.97 1,450,960.88 -56,785.94 96.234 1.76% 1,443,515.63 9,057.38 1,452,573.01 -62,829.30 94.277 0.52% 1,414,160.16 556.32 1,414,716.48 -98,981.14 98.874 2.58% 1,977,480.00 6,388.89 1,983,868.89 -21,937.96 98.123 1.96% 1,663,184.85 13,807.19 1,676,992.04 -42,319.33 19,523,918.94 90,711.25 19,614,630.19 -583,349.08 43 CM 55 Transaction Ledger City of Dublin - Account #10198 June 30, 2023 through September 30, 2023 As of September 30, 2023 Transaction Settlement Type Date CUSIP Quantity Security Description Acq/Disp Price Yield Amount Interest Pur/Sold Total Amount Gain/Loss Call Subtotal 07/23/2023 46647PAU0 2,500,000.00 JP Morgan Chase & Co Callable Note 1X 7/23/2023 100.000 Due: 07/23/2024 2,500,000.00 Maturity 08/11/2023 06406RAJ6 1,200,000.00 Bank of NY Mellon Corp Note 3.45% Due: 08/11/2023 Subtotal 1,200,000.00 TOTAL DISPOSITIONS 23,760,000.00 100.000 2.35% 2,500,000.00 2,500,000.00 1,200,000.00 0.00 0.00 0.00 1,200,000.00 0.00 2,500,000.00 2,500,000.00 1, 200, 000.00 0.00 0.00 0.00 1,200,000.00 0.00 23,223,918.94 90,711.25 23,314,630.19 -583,349.08 44 CA 56 Transaction Ledger City of Dublin Reporting Account - Account #10219 June 30, 2023 through September 30, 2023 As of September 30, 2023 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/2023 90LAIF$00 204,860.61 Purchase 07/31/2023 90CAMP$00 425,172.48 Purchase 08/31/2023 90CAMP$00 392,308.67 Purchase 09/29/2023 90CAMP$00 372,957.34 Local Agency Investment Fund State Pool California Asset Mgmt Program CAMP California Asset Mgmt Program CAMP California Asset Mgmt Program CAMP 1.000 3.26% 204,860.61 0.00 204,860.61 1.000 5.43% 425,172.48 0.00 425,172.48 1.000 5.54% 392,308.67 0.00 392,308.67 1.000 5.54% 372,957.34 0.00 372,957.34 Subtotal 1,395,299.10 Security 07/11/2023 90CAMP$00 4,000,000.00 California Asset Mgmt Program CAMP 1.000 Contribution Security 09/07/2023 90CAMP$00 4,500,000.00 California Asset Mgmt Program CAMP 1.000 Contribution Subtotal 8,500,000.00 TOTAL ACQUISITIONS 9,895,299.10 0.00 0.00 0.00 0.00 1,395,299.10 0.00 1,395,299.10 0.00 4,000,000.00 0.00 4,000,000.00 0.00 4,500,000.00 0.00 4,500,000.00 0.00 8,500,000.00 0.00 8,500,000.00 0.00 9,895,299.10 0.00 9,895,299.10 0.00 DISPOSITIONS Security 07/18/2023 90CAMP$00 7,000,000.00 California Asset Mgmt Program CAMP 1.000 7,000,000.00 0.00 7,000,000.00 0.00 Withdrawal Security 08/02/2023 90CAMP$00 550,000.00 California Asset Mgmt Program CAMP 1.000 550,000.00 0.00 550,000.00 0.00 Withdrawal Security 08/08/2023 90CAMP$00 5,500,000.00 California Asset Mgmt Program CAMP 1.000 5,500,000.00 0.00 5,500,000.00 0.00 Withdrawal Security 08/17/2023 90CAMP$00 6,300,000.00 California Asset Mgmt Program CAMP 1.000 6,300,000.00 0.00 6,300,000.00 0.00 Withdrawal Security 08/22/2023 90CAMP$00 1,700,000.00 California Asset Mgmt Program CAMP 1.000 1,700,000.00 0.00 1,700,000.00 0.00 Withdrawal 45 CM 57 Transaction Ledger City of Dublin Reporting Account - Account #10219 June 30, 2023 through September 30, 2023 As of September 30, 2023 Transaction Settlement Type Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Total Amount Gain/Loss Pur/Sold Security Withdrawal Subtotal TOTAL DISPOSITIONS 09/20/2023 90CAM P$00 700,000.00 California Asset Mgmt Program CAMP 21,750,000.00 21,750,000.00 1.000 700,000.00 21,750,000.00 0.00 700, 000.00 0.00 0.00 21,750,000.00 0.00 21,750,000.00 0.00 21,750,000.00 0.00 46 Q 58