Loading...
HomeMy WebLinkAbout5.2 City Treasurer's Informational Report of Investments for the Quarter Ending March 31, 2024r DUBLIN CALIFORNIA STAFF REPORT CITY COUNCIL DATE: May 21, 2024 TO: Honorable Mayor and City Councilmembers FROM: Linda Smith, City Manager Agenda Item 5.2 SU B.ECT : City Treasurer's Informational Report of Investments for the Quarter Ending March 31, 2024 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 March 31, 2024 including a monthly transaction ledger. The City's investment portfolio for this period totaled $422,309,722 (market value) with an average market yield of 4.92%. As required by the City's Investment 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 City Treasurer's Informational Report of Investments for the Quarter Ending March 31, 2024. FINANCIAL IMPACT: There is no financial impact resulting from this report. Investments are made in accordance with the City's 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 $290,703,168 managed by Chandler Asset Management (Chandler), and $131,606,553 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.79% and 5.22% respectively. Page 1 of 5 1 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). Recent economic data has shown above trend growth fueled by a rise in consumer spending and a continuing healthy US job market. Inflationary trends are subsiding, but core levels remain 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 loosen monetary policy in 2024. Chandler's New Reporting Portal Chandler has implemented a new client service portal for enhanced reporting capabilities and improved security features, this new portal includes the following reporting changes that can be found in the March Quarterly report (Attachment 1): • The overall report has changed from a settlement -based report to a trade -based report. • The Cash category now will include cash on hand, payables, and receivables for income earned but not yet paid, as well as accrued interest from the Local Pool accounts. • The account category CMO (Collateralized Mortgage Obligation) has been retitled as Agency CMBA (Commercial Mortgage -Backed Security), to more accurately reflect the type of investments within the category. The impacts of these changes have been footnoted on the tables included below. 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, except for CAMP, which saw a slight decrease due to the timing of the receipt of property tax revenues in December which were subsequently spent during the March quarter. Page 2 of 5 2 US Treasury 26.4% Supranational 6.2% Money Market Fund 0.2% Chart 1: Investments by Type March 31, 2024 and December 31, 2023 March 31, 2024 Agency CMBS 2 0% Cash 0.2% Local Gov Investment Pool 24.8% Agency 9.3% LAIF 6.3% Asset Backed Security 6.6% Corporate 17.9% US Treasury 26.1% Supranational 5.5% Money Market Fund 0.3% December 31, 2023 Local Gov Investment Pool 25.7% CMO 2.0% ABS 6.1% LAIF 6.3% Agency 10.7% Corporate 17.2% The market value of the City's portfolio decreased by $4.1 million from the December 31, 2023 quarter. The quarterly change results from the normal fluctuations in the timing of incoming revenue, predominantly the receipt of property tax allocations, and sales tax revenue, and expenditures on Capital Projects as well as payments to Alameda County for Police and Fire Services. The City's portfolio increased by $34.3 million from the same quarter the prior year (see Table 1 below). Overall market yield -to -maturity has increased to 4.92%, (shown in Table 2) due to the factors discussed in the Economic Update Highlights. For detailed monthly transactions, see Attachment 2. Page 3 of 5 3 Holdings Managed by City Cash" LAI F CAMP SUBTOTAL' Accrued Interest2 Managed by Chandler ABS Agency Cash' Agency CMBS4 Money Market Supranational Corporate US Treasury SUBTOTAL Accrued Interest TOTAL PORTFOLIO March 31, 2023 Market Value Table 1: Portfolio Values and Yield to Maturity December 31, 2023 Market Value Par Value Book Value March 31, 2024 Market % of Value Subtotal % of Total Book Market Portfolio Yield Yield 274,480 274,480 274,480 0.2% 25,917,596 26,534,226 26,800,793 26,800,793 26,800,793 20.4% 80,625,562 109,660,424 104,531,281 104,531,281 104,531,281 7 9.4 % 106, 543,157 I 136,194, 650 I 131, 606, 553 131, 606, 553 131, 606, 553 I 100.00% 166,760 254,504 - 106,709,917 136,449,154 131,606,553 30,171,153 25,798,334 27,832,917 27,829,771 27,628,978 9.6% 60,517,635 45,535,489 40,300,000 40,396,046 39,102,074 13.5% 456,482 456,482 456,482 0.2% 3,874,342 8,685,518 8,879,961 8,810,805 8,630,360 3.0% 760,481 1,159,231 813,046 813,046 813,046 0.3% 16,860,396 23,370,361 27,525,000 27,157,816 26,247,930 9.1% 71,092,672 72,851,163 77,620,000 77,220,302 75,214,801 26.0% 96,639,811 110,817,325 114,250,000 113,856,008 110,896,377 38.4% 279,916,489 288,217,420 297,677,405 296,540,277 288,990,049 100.00% 1,410,760 281,327,249 388,037,166 1,782,764 290,000,184 426,449,338 1,713,120 290,703,168 429,283,959 428,146,830 Change from Prior Year Change from Prior Quarter 422,309,722 34,272,555 (4,139,616) 0.1% 6.2% 24.4% 30.66% 6.5% 9.4% 0.1% 2.1% 0.2% 6.4% 18.1% 26.6% 69.34% 0.00% 4.27% 5.48% 5.22% 4.03% 2.23% 0.00% 3.15% 4.91% 2.46% 3.13% 3.34% 3.11% 0.00% 4.27% 5.48% 5.22%I 5.51% 4.90% 0.00% 5.13% 4.91% 4.60% 5.06% 4.42% 4.79% 'Includes cash on hand, receivables, payables and accrued interest from th 2024) 2Accrued Interest from Local Pools shown in Cash. (effective March 2024) 3lncludes cash on hand, receivables and payables from accounts managed 2024) 4CM0 is retitled to Agency CMBS. (effective March 2024) 100.00% 4.92% e Local Pools. (effective March by Chandler. (effective March Table 2: Quarterly Holdings (Market Value) by Type, and YTM, 5 Quarters Holdings (Market Value) LAIF/CAM P ABS Agency Cash' Agency CMBS2 Money Market Supranational Corporate US Treasury Accrued Interest3 TOTAL YIELD TO MATURITY 3/31/23 6/30/23 9/30/23 106, 543,157 120, 768,108 108, 913, 407 30,171,153 28,186,820 28,613,814 60,517,635 53,795,750 46,770,742 3,874,342 760,481 16, 860, 396 71, 092, 672 96, 639, 811 1,577,520 388,037,166 4.39% 6,570,900 2,641,554 16, 711, 738 71,551,741 99, 278,149 1,604,620 401,109,378 4.92% 7,428, 709 859,487 23,103, 092 70,490, 952 102, 206, 540 1,746,703 390,133,446 5.19% 'Includes cash on hand, receivables, payables, from accounts managed by and accrued interest from the Local Pools. (effective March 2024) 2CM0 is retitled to Agency CMBS. (effective March 2024) 3Accrued Interest for the Local Pools is included in Cash. (effective March 2024) 12/31/23 136,194, 650 25, 798, 334 45, 535, 489 8,685,518 1,159, 231 23, 370, 361 72, 851,163 110, 817, 325 2,037,268 426,449,339 1 4.71% Chandler and the 3/31/24 131, 332, 074 27, 628, 978 39,102, 074 730,962 8,630,360 813,046 26, 247, 930 75, 214, 801 110, 896, 377 1,713,120 422,309,722 I 4.92% Local Pools, Page 4 of 5 4 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 shoes quarterly portfolio yields over the most recent eight quarters. Table 3: Quarterly Portfolio Yields, Recent 8 Quarters Market Yield LAIF CAMP Chandler 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% 12/31/23 3.95% 5.56% 4.46% 3/31/24 4.27% 5.48% 4.79% STRATEGIC PLAN INITIATIVE: None. NOTICING REQUIREMENTS/PUBLIC OUTREACH: The City Council Agenda was posted. ATTACHMENTS: 1) City of Dublin Investment Report for Period Ending March 31, 2024 2) Transaction Ledger - January through March 2024 Page 5 of 5 5 Attachment I IINVESTMENT REPORT City of Dublin Period Ending March 31, 2024 CA%CHANDLER ASSET MANAGEMENT CHANDLER ASSET MANAGEMENT, INC. 1800.317.4747 I www.chandlerasset.com �i • Table of Contents SECTION 1 Economic Update SECTION 2 Account Profile SECTION 3 Consolidated Information SECTION 4 Portfolio Holdings SECTION 5 Transactions As of March 31, 2024 1 CM 7 Section 1 I Economic Update Economic Update • Recent economic data has shown above trend growth fueled by a rise in consumer spending and a continuing healthy US job market. Inflationary trends are subsiding, but core levels remain 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 loosen monetary policy in 2024. • As expected at the March meeting, the Federal Open Market Committee voted unanimously to leave the Federal Funds rate unchanged at a target range of 5.25 - 5.50%. The March Summary of Economic Projections (SEP) showed stronger real GDP growth outlook and higher core inflation projections for 2024 on resilient labor market and consumer data. The median projection for Federal Funds rate by year-end remained the same at 4.625%, implying three 0.25% cuts. We continue to believe the FOMC will loosen monetary policy in mid-2024 as inflation and economic growth continue to moderate. • The US Treasury yield curve stabilized in March as the FOMC left the Federal Funds rate unchanged. The 2-year Treasury yield was unchanged at 4.62%, the 5-year Treasury fell 4 basis points to 4.21%, and the 10-year Treasury yield dropped 5 basis points to 4.20%. The inversion between the 2-year Treasury yield and 10-year Treasury yield widened to -42 basis points at March month -end versus -37 basis points at February month -end. The spread between the 2-year Treasury and 10-year Treasury yield one year ago was -56 basis points. The inversion between 3-month and 10-year Treasuries widened to -117 basis points in March from -113 basis points in February. 3 CMMM 9 Employment 1,000 800 0 0 c 600 3 • 400 c 200 v 00 c -c 0 u 2 0 -200 -400 Nonfarm Payroll (000's) 1 1 —Non-farm Payroll (000's) 3-month average (000's) 4 sop 4 sow 4 sop 'Lidr spa, 'Lid. sop 'Lid) t's1.9 'l9 �O `-)0�1 `),l �� �) sc).1 `),s' Est Source: US Department of Labor 25.0% 20.0% e 15.0% 10.0% 5.0% 0.0% Unemployment Rate Underemployment Rate (U6) Unemployment Rate (U3) 47 SP: 4dr Spa 47 SPA 4 Spa 4dr. SPp 4dr 19 1,9 )O `)1 �� � )o) `),1 fit! Source: US Department of Labor The U.S. economy added a better-than-expected 303,000 jobs in March, and the prior two months were revised up by 22,000. Leading sectors included healthcare and government. Job creation remains healthy, with the three-month moving average payrolls at 276,000 and the six-month moving average at 244,000. The unemployment rate edged down to 3.8% in March. The labor participation rate ticked up to 62.7% but remained below the pre -pandemic level of 63.3%. The U-6 underemployment rate, which includes those who are marginally attached to the labor force and employed part time for economic reasons was unchanged at 7.3%. Average hourly earnings rose 4.1% year over -year in March, down from 4.3% last month. Employment remains strong by historical standards. 4 10 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 s s dp1 dry Pp� d, r1 P'c) 9 9 O O ? Source: US Department of Labor sox? 1 410, 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 Fed Target 1,g Ig �O �O 60, c)1 es �1 c)� 2� 2) ?�, �Q Source: US Department of Commerce The Consumer Price Index (CPI) came in higher than expected in March, increasing 0.4% month -over -month and 3.5% year -over -year. The Core CPI, which excludes volatile food and energy components, was up 0.4% month -over -month and 3.8% year -over -year in March, unchanged from 3.8% in February. Energy costs accelerated during the month, and shelter costs remain elevated. The Personal Consumption Expenditures (PCE) Index headline inflation increased 0.3% month -over -month and rose 2.5% year -over -year in February, in line with expectations. Core PCE, the Federal Reserve's preferred inflation gauge, increased 0.3% month -over -month and rose 2.8% year - over -year. While the trend is moderating, the path to the Fed's 2% inflation target remains uneven. Federal Reserve 10,000,000 9,000,000 8,000,000 7,000,000 c 6,000,000 5,000,000 = 4,000,000 3,000,000 2,000,000 1,000,000 0 Federal Reserve Balance Sheet Assets Recession 4 47 47 47 �a 4 447 477 47 �v �6. .vcs) 1c53 ")O 6.00% 5.00% 4.00% v 3.00% 2.00% 1.00% 0.00% Effective Federal Funds Rate • Recession 4d 4 44 40 40 4d 40 47 4d 4d 4d O O ~O ~1 ~1 ~1 ~1 ~,I 4 6 cQ O � Source: Federal Reserve Source: Bloomberg As expected at the March meeting, the Federal Open Market Committee voted unanimously to leave the federal funds rate unchanged at a target range of 5.25-5.50%. The FOMC Statement and Summary of Economic Projections (SEP) was minimally changed from January. The Fed assesses the progress to achieving its employment and inflation goals are moving into better balance, yet changes to monetary policy remain data dependent. For 2024, the March SEP showed stronger real GDP growth outlook of 2.1% from 1.4% in December as labor market and consumer data have been resilient. Core inflation projections nudged up from 2.4% to 2.6%. The median projection for the Federal Funds rate by the end of the year remained the same at 4.625%, implying three 0.25% cuts in 2024, three cuts in 2025 and three cuts in 2026. We believe the FOMC will loosen monetary policy in mid-2024 as inflation and economic growth continue to moderate. Since the Fed began its Quantitative Tightening campaign in June 2022, securities holdings have declined by over $1.5T to approximately $7.5T. YOY (%) Change Consumer 60.0% 50.0% 40.0% 30.0% 20.0% 10.0% 0.0% -10.0% -20.0% -30.0% ■■■lull Retail Sales YOY % Change 111111111111Lmilli NI �dr SPb 0/. sib dr SPb dr SPb 0/. sib dr 19 'l g "o �p )1 Al c)c) ,)� �•3' A0) �Q Source: US Department of Commerce 160 140 120 100 J 80 40 20 0 0T p 08 10 1 1 16. V8 ‘-)Q • Recession 'll Consumer Confidence Source: The Conference Board All time high is 144.70 (1/31/00); All time low is 25.30 (2/28/09) March Retail Sales rose above expectations at +0.7% after a sizeable upward revision to +0.9% in February. On a year -over -year basis, Retail Sales growth increased 4.0% for March. Sales were supported by higher gas prices and higher volume sales in a busy travel period for spring break at schools, as well as strength from non -store retailers. The Conference Board's Consumer Confidence Index edged down to 104.7 in March after a sizeable downward revision to 104.8 in February. The lower reading was largely due to a deteriorating view of the labor market and future business conditions, along with concerns about the highly polarized political environment. 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. 13 ILeading Indicators of Economic Activity 15.0% 10.0% 5.0% • 0.0% .c -5.0% -10.0% s - 15.0% - 20.0% -25.0% Leading Economic Indicators (LEI) d'Q 8a 9� 96. 00 0 , Source: The Conference Board Chicago Fed National Activity Index (CFNAI) 1.00 0.75 0.50 alci" 0.25 a Cr 0.00 • 0.25 • -0.50 - 0.75 - 1.00 44 4447 4 47 47 47 47 4`9Q 8(9 9c) 96 VO 129' VcQ '7c) l6 f.$)•0 �S! Source: Federal Reserve Bank of Chicago The Conference Board's Leading Economic Index (LEI) dropped 0.3% month -over -month in March after registering the first increase in two years the prior month. The index declined 5.5% year -over -year. Primary factors for the decline include weaker business orders, lower consumer confidence and fewer building permits. The Chicago Fed National Activity Index (CFNAI) increased +0.15 in March from an upwardly revised +0.09 in February. On a 3-month moving average basis, the CFNAI improved to -0.19 in March from -0.28 in February, indicating below -trend economic growth. 8 C 14 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 47 47 470 4747 47 liar 47 47 4747 OQ 0606, 10 12 1Q 16 1� 2(9 22 2Q Source: US Department of Commerce Housing Starts plunged 14.7% month -over -month in March to 1.321 mortgage rates topped 7%. Starts for multi -family homes dropped 21 to Freddie Mac, 30-year fixed mortgage rates averaged 7.1% as of housing prices rose 6.59% year -over -year in January, accelerating fro higher mortgage rates continue to impact affordability. 24.0% 20.0% 16.0% 12.0% a 8.0% roc • 4.0 % L.) 0.0% o -4.0% r -8.0% - 12.0% - 16.0% - 20.0% S&P/Case-Shiller 20 City Composite Home Price Index ✓.4)r2✓`?,,, ✓`�rl ✓dam ✓`),) ✓`?,,, ✓`�rl `�� d� 0 06 O� 10 12 1Q '4 4 20 22 2Q Source: S&P ✓ ✓ ✓ ✓ million units, due to declining confidence among homebuilders as .7%, while single family homes fell 12.4 % for the month. According April 18th. According to the Case-Shiller 20-City Home Price Index, m a 6.15% year -over -year gain in December. Tight inventories and 9 C 15 Survey Based Measures 70 65 60 55 50 45 40 • Institute of Supply Management (ISM) Surveys ISM Manufacturing ISM Services / ✓4 So 0�, 2i ✓ So 0�, 'L ✓4 So O�, 2i ✓4 So �P ✓4 So 0�, 2i drZ9 719 a19 cZ9 drc)0 h-)0 p�0 c�0 dr2z �1 a�1 c,Z drh`2 a�� cs2 dr�i�J' ,b�3' cc) drc)4 Source: Institute for Supply Management The Institute for Supply Management (ISM) Manufacturing index unexpectedly expanded to 50.3 in March from 47.8 in February, marking the first month of expansion in factory activity above a reading of 50 since 2022. Production and new orders surged, while employment improved and prices paid increased. The ISM Services Index fell to 51.4 in March from 52.6 in February but remained in expansion territory for the 15th consecutive month. The survey reflected slower growth in new orders, a contraction in employment, faster supplier deliveries, and declining price pressures. 10 CA 16 Gross Domestic Product (GDP) Components of GDP 3 6/23 12/23 Personal Consumption Expenditures 2.5% 0.6% 2.1% 2.2% Gross Private Domestic Investment -1.7% 0.9% 1.7% 0.2% Net Exports and Imports 0.6% 0.0% 0.0% 0.3% Federal Government Expenditures 0.3% 0.1% 0.5% 0.2% State and Local (Consumption and Gross Investment) 0.5% 0.5% 0.5% 0.6% Total 2.3% 2.1% 4.9% 3.4% Source: US Department of Commerce 40.0% 30.0% 20.0% 10.0% 0.0% - 10.0% - 20.0% -30.0% - 40.0% Gross Domestic Product (GDP) 1 GDP QOQ % Change GDP YOY % Change 'lc9 'IS s9 `)0 ?O s),I c)1 c'c) c)c) c,3' c)a' Source: US Department of Commerce According to the third estimate, fourth quarter GDP increased at an annualized rate of 3.4%, revised up from the second estimate of 3.2%. The upward revision was due mainly to stronger personal consumption expenditures and nonresidential investment. GDP growth for the full year 2023 is estimated at 2.5%. The consensus projection calls for 2.0% growth in the first quarter and 2.2% growth for the full year 2024. 0 13 v Bond Yields 6.0 % 5.0 % 4.0 % 3.0 % 2.0% 1.0% 0.0 % 4i0 SPA1��'SPp 47 SPp 47 S47 S4 1y9r�p s3p c)1 )i ,),)) �SP0)drc3Q • US Treasury Note Yields 2-Year 5-Year 10-Year Source: Bloomberg 6.0 % 4.0 % 0 3.0% ai } 2.0 % 1.0 % 0.0 % Source: Bloomberg US Treasury Yield Curve • Mar-24 Dec-23 Mar-23 At the end of March, the 2-year Treasury yield was 59 basis point higher, and the 10-Year Treasury yield was 73 basis points higher, year - over -year. The inversion between the 2-year Treasury yield and 10-year Treasury yield widened to -42 basis points at March month -end versus -37 basis points at February month -end. The average historical spread (since 2003) is about +130 basis points. The inversion between 3-month and 10-year Treasuries widened to -117 basis points in March from -113 basis points in February. Section 2 I Account Profile Objectives As of March 31, 2024 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 CA 20 STATEMENT OF COMPLIANCE City of Dublin 1 Account #10198 1 As of March 31, 2024 CAN CHANDLER ASSET MANAGEMENT Rules Name Limit Actual Compliance Notes Status AGENCY MORTGAGE SECURITIES (CMOS) Max % (MV) Max % Issuer (MV) Max Maturity (Years) ASSET -BACKED SECURITIES (ABS) Max % (MV; Non Agency ABS & MBS) Max % Issuer (MV) Max Maturity (Years) Min Rating (AA- by 1) BANKERS' ACCEPTANCES 20.0 0.0 Compliant 20.0 0.0 Compliant 5.0 0.0 Compliant 20.0 9.5 Compliant 5.0 1.1 Compliant 5 4 Compliant 0.0 0.0 Compliant Max % (MV) 40.0 0.0 Compliant Max % Issuer (MV) 5.0 0.0 Compliant Max Maturity (Days) 180 0.0 Compliant Min Rating (A-1 by 1) 0.0 0.0 Compliant COMMERCIAL PAPER Max % (MV) 25.0 0.0 Compliant Max % Issuer (MV) 5.0 0.0 Compliant Max Maturity (Days) 270 0.0 Compliant Min Rating (A-1 by 1 or A- by 1) 0.0 0.0 Compliant CORPORATE MEDIUM TERM NOTES Max % (MV) 30.0 26.1 Compliant Max % Issuer (MV) 5.0 1.5 Compliant Max Maturity (Years) 5 4 Compliant Min Rating (A- by 1) 0.0 0.0 Compliant FEDERAL AGENCIES Max % (MV) 100.0 13.5 Compliant Max % Issuer (MV) 35.0 4.9 Compliant Max Callables (MV) 25.0 0.0 Compliant Max Maturity (Years) 5 4 Compliant LOCAL AGENCY INVESTMENT FUND (LAIF) Max Concentration (MV) 0.0 Compliant MONEY MARKET MUTUAL FUNDS Max % (MV; Money Market Fund & Mutual Fund) 20.0 0.3 Compliant Max % Issuer (MV) 20.0 0.3 Compliant 15 21 STATEMENT OF COMPLIANCE City of Dublin 1 Account #10198 1 As of March 31, 2024 CAN CHANDLER ASSET MANAGEMENT Rules Name Limit Actual Compliance Notes Status Min Rating (AAA by 2) MORTGAGE -BACKED SECURITIES (NON -AGENCY) Max % (MV) Max % Issuer (MV) Max Maturity (Years) Min Rating (AA- by 1) MUNICIPAL SECURITIES (ALL STATES) Max % Issuer (MV) Max Maturity (Years) Min Rating (A- by 1) MUTUAL FUNDS 0.0 20.0 5.0 5.0 0.0 5.0 5.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 Compliant Compliant Compliant Compliant Compliant Compliant Compliant Compliant Max % (MV; Money Market Fund & Mutual Fund) 20.0 0.3 Compliant Max % Issuer (MV) 10.0 0.0 Compliant Min Rating (AAA by 2) 0.0 0.0 Compliant NEGOTIABLE CERTIFICATES OF DEPOSIT (NCD) Max % (MV) 30.0 0.0 Compliant Max % Issuer (MV) 5.0 0.0 Compliant Max Maturity (Years) 5 0.0 Compliant Min Rating (A-1 by 1 or A- by 1 if > FDIC Limit) 0.0 0.0 Compliant SUPRANATIONAL OBLIGATIONS Max % (MV) 30.0 9.1 Compliant Max % Issuer (MV) 10.0 4.4 Compliant Max Maturity (Years) 5 4 Compliant Min Rating (AA- by 1) 0.0 0.0 Compliant TIME DEPOSITS Max % (MV) 10.0 0.0 Compliant Max % Issuer (MV) 5.0 0.0 Compliant Max Maturity (Years) 1.0 0.0 Compliant U.S. TREASURIES Max % (MV) 100.0 38.4 Compliant Max Maturity (Years) 5 4 Compliant 16 22 Portfolio Characteristics City of Dublin As of March 31, 2024 03/31/24 12/31/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.68 2.52 n/a 4.57% AA+ 2.90 2.50 3.12% 4.79% AA 290, 703,168 2.87 2.45 2.87% 4.46% AA/Aa 1 290,000,185 17 CM 23 Sector Distribution US Treasury 38.4% Supranational 9.1% City of Dublin March 31, 2024 December 31, 2023 Agency CMBS 3.0 Cash 0.2 WO Agency 13.5% Asset Backed Security 9.5% 111 Corporate 26.1% Money Market Fund 0.3% US Treasury 38.4% Supranational 8.1% CMO 3.0% Money Market Fund 0.4 As of March 31, 2024 ABS 8.9% Agency 15.8% Corporate 25.4% 18 CM 24 IIssuers City of Dublin - Account #10198 As of March 31, 2024 Issue Name Investment Type % Portfolio Government of the United States Federal National Mortgage Association Intl Bank Recon and Development Inter -American Dev Bank Federal Home Loan Mortgage Corp Federal Home Loan Bank Federal Home Loan Mortgage Corp Federal Farm Credit Bank JP Morgan ABS United Health Group Inc Bank of Montreal Chicago John Deere ABS Bank of America Corp Deere & Company Toronto Dominion Holdings Toyota Motor Corp Royal Bank of Canada Merck & Company JP Morgan Chase & Co Hyundai Auto Receivables Morgan Stanley Qualcomm Inc Metlife Inc Mercedes-Benz Amazon.com Inc Tennessee Valley Authority US Bancorp Northwestern Mutual Glbl Caterpillar Inc Chubb Corporation GM Financial Securitized Term Auto Trust Honeywell Corp Honda Motor Corporation Berkshire Hathaway American Express ABS Wal-Mart Stores Realty Income Corp Charles Schwab Corp/The US Treasury Agency Supranational Supranational Agency CMBS Agency Agency Agency Asset Backed Security Corporate Corporate Asset Backed Security Corporate Corporate Corporate Corporate Corporate Corporate Corporate Asset Backed Security Corporate Corporate Corporate Asset Backed Security Corporate Agency Corporate Corporate Corporate Corporate Asset Backed Security Corporate Corporate Corporate Asset Backed Security Corporate Corporate Corporate 38.37% 4.97% 4.36% 4.16% 2.98% 2.94% 2.83% 1.89% 1.73% 1.51% 1.48% 1.44% 1.42% 1.38% 1.37% 1.30% 1.21% 1.20% 1.16% 1.05% 1.04% 1.03% 0.99% 0.96% 0.94% 0.90% 0.88% 0.86% 0.86% 0.84% 0.84% 0.83% 0.81% 0.74% 0.74% 0.69% 0.66% 0.62% 19 CM 25 Issuers City of Dublin — Account #10198 As of March 31, 2024 Issue Name Investment Type % Portfolio GM Financial Automobile Leasing Trust International Finance Corp Cisco Systems Toyota Lease Owner Trust Bank of New York Honda ABS Target Corp BMW ABS Toyota ABS Dominion Resources Inc Hyundai Auto Lease Securitization First American Govt Oblig Fund Guardian Life Global Funding Salesforce.com Inc Account Receivable Payable BMW Vehicle Lease Trust TOTAL Asset Backed Security Supranational Corporate Asset Backed Security Corporate Asset Backed Security Corporate Asset Backed Security Asset Backed Security Corporate Asset Backed Security Money Market Fund Corporate Corporate Cash Asset Backed Security 0.58 % 0.56 % 0.54% 0.52 % 0.51 % 0.49% 0.43 % 0.42 % 0.34% 0.34% 0.30% 0.28% 0.25 % 0.16% 0.16% 0.10% 100.00% 20 CM 26 I Quality Distribution 70.0% 60.0 % 50.0% 40.0% 30.0% 20.0 % 10.0 % 0.0% 03/31/24 12/31/23 Source: S&P Ratings 1 AAA 18.0% 16.9% City of Dublin March 31, 2024 vs. December 31, 2023 AA ■ 03/31/24 60.5% 59.1% 1 A 21.1% 20.2% <A 12/31/23 As of March 31, 2024 IM NR 0.3% 0.0% 0.3% 3.5% 21 CM 27 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 ■ City of Dublin 1-2 2-3 3-4 4-5 5+ ICE BofA 1-5 Yr US Treasury & Agency Index As of March 31, 2024 0-0.25 0.25-0.50 0.50-1 1-2 2-3 3-4 4-5 5+ Portfolio Benchmark* 2.7% 0.0% *ICE BofA 1-5 Yr US Treasury & Agency Index 0.0% 9.0% 2.3% 26.5% 34.7% 18.9% 26.9% 31.9% 22.6% 9.9% 13.6% 0.0% 0.0% 22 cm 28 IInvestment Performance 3.50% 3.00% 2.50% 2.00% 1.50% 1.00% 0.50% 0.00% - 0.50% - 1.00% As of March 31, 2024 City of Dublin Total Rate of Return Annualized Since Inception October 31, 2013 12 months 2 years 3 years 5 years 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.24% 3.33% 1.57% -0.11% 1.31% 1.34% 1.30% ICE BofA 1-5 Yr US Treasury & Agency Index* -0.01% 2.45% 1.02% -0.58% 0.96% 1.07% 1.04% *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 c 29 Portfolio Characteristics City of Dublin Rptg Account As of March 31, 2024 03/31/24 Portfolio 12/31/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.22% 5.22% AAA 131,606,553 0.00 0.00 5.25% 5.24% AAA/N R 136,449,154 24 CM 30 Sector Distribution City of Dublin Rptg Account March 31, 2024 December 31, 2023 Cash 0.2 Local Gov Investment Pool 79.4% LAIF 20.4% Local Gov Investment Pool 80.4% As of March 31, 2024 LAIF 19.6% 25 CM 31 Issuers City of Dublin Rptg Account — Account #10219 As of March 31, 2024 Issue Name Investment Type % Portfolio CAMP Local Agency Investment Fund Account Receivable Payable TOTAL Local Gov Investment Pool LAIF Cash 79.43% 20.36% 0.21% 100.00 % 26 Q 32 Section 3 I Consolidated Information 27 Q 33 Portfolio Characteristics Average Maturity (yrs) Modified Duration Average Purchase Yield Average Market Yield Average Quality* Total Market Value * Portfolio is S&P and Moody's respectively. City of Dublin Consolidated 03/31/24 Portfolio 1.99 1.72 3.77% 4.92% AA+ 422,309,722 12/31/23 Portfolio 1.95 1.67 3.44% 4.71% AA+/Aa 1 426,449,339 As of March 31, 2024 28 Q 34 Sector Distribution US Treasury 26.4% Supranational 6.2% Money Market Fund 0.2% March 31, 2024 Agency CMBS 2 0% Cash 0.2 % Local Gov Investment Pool 24.8% Agency 9.3% LAIF 6.3% City of Dublin Consolidated Asset Backed Security 6.6% Corporate 17.9% US Treasury 26.1% Supranational 5.5% Money Market Fund 0.3% December 31, 2023 Local Gov Investment Pool 25.7% CMO 2.0% ABS 6.1% LAI F 6.3% As of March 31, 2024 Agency 10.7 % Corporate 17.2% 29 c 35 Section 4 I Portfolio Holdings HOLDINGS REPORT City of Dublin 1 Account #10198 1 As of March 31, 2024 CAN CHANDLER ASSET MANAGEMENT Cusip Security Description Par Value/ Purchase Date Cost Value Mkt Price Units Purchase Yield Book Value Mkt YTM Moody's/ Market Value % of Port. Maturity Accrued Int. Gain/Loss F& h Duration ABS 44891WAC3 89238LAC4 36265MAC9 025821.118 36266FAC3 44933LAC7 47788UAC6 05593AAC3 44934KAC8 43815GAC3 47789QAC4 44935FAD6 43815BAC4 05602RAD3 47787JAC2 362554AC1 448977AD0 HALST 2022-A A3 1.16 01/15/2025 TLOT 2022-A A3 1.96 02/20/2025 GMALT 2022-1 A3 1.9 03/20/2025 AMXCA 2022-2 A 05/17/2027 GMALT 2022-2 A3 3.42 06/20/2025 HART 2021-A A3 0.38 09/15/2025 JDOT 2021 A3 0.36 09/15/2025 BMWLT 2023-1 A3 5.16 11/25/2025 HART 2021-B A3 0.38 01/15/2026 HAROT 2021-4 A3 0.88 01/21/2026 JDOT 2021-6 A3 0.52 03/16/2026 HART 2021-C A3 0.74 05/15/2026 HAROT 2022-1 A3 1.88 05/15/2026 92,519.21 520,884.55 232,980.22 2,205,000.00 472,316.61 114,322.12 144,721.51 295,000.00 655,656.49 415,661.55 432,275.54 290,048.17 1,043,543.80 675,116.95 JDOT 2022 A3 0.36 09/15/2026 697,821.46 GMCAR 2021-4 A3 0.68 09/16/2026 341,764.76 HART 2022-A A3 2.22 10/15/2026 864,996.17 BMWOT 2022-A A3 3.21 08/25/2026 01/11/2022 92,517.16 99.81 1.16% 92,518.76 5.65% 02/23/2022 520,802.56 99.65 1.96% 520,863.27 4.48% 02/15/2022 232,978.22 99.76 1.91% 232,979.71 3.51% 05/17/2022 2,204,512.25 97.93 3.42% 2,204,739.66 5.33% 05/03/2022 472,267.35 99.65 3.45% 472,299.78 5.17% 04/20/2021 114,310.09 99.18 0.39% 114,319.30 5.26% 03/02/2021 144,693.70 98.74 0.37% 144,714.20 5.84% 02/07/2023 294,992.98 99.76 5.43% 294,995.83 5.64% 07/20/2021 655,511.79 98.47 0.60% 655,611.15 5.90% 11/16/2021 415,573.93 97.56 0.89% 415,627.77 5.98% 07/13/2021 432,236.98 97.64 0.52% 432,261.52 5.58% 11/09/2021 289,983.43 97.77 0.75% 290,022.34 6.00% 02/15/2022 1,043,386.84 97.68 1.89% 1,043,472.01 6.04% 05/10/2022 675,081.85 98.48 3.23% 675,098.72 5.71% 03/10/2022 697,667.09 97.90 2.34% 697,743.09 5.74% 10/13/2021 341,756.05 97.10 0.68% 341,761.07 6.58% 03/09/2022 864,962.87 97.85 2.23% 864,979.53 6.00% 92,346.49 47.70 519,069.63 311.95 232,413.71 135.26 2,159,446.46 3,322.20 470,674.04 493.57 113,385.27 19.31 142,903.55 23.16 294,306.43 253.70 645,610.00 110.73 405,531.75 101.61 422,094.50 99.90 283,577.63 95.39 1,019,291.63 871.94 664,881.50 361.19 683,169.02 719.53 331,865.55 96.83 846,402.30 853.46 0.03% Aaa/AAA (172.27) NA 0.18% NA/AAA (1,793.64) AAA 0.79 0.04 0.89 0.11 0.08% Aaa/NA 0.97 (566.00) AAA 0.07 0.75% NA/AAA 1.12 (45,293.19) AAA 1.60 0.16% NA/AAA 1.22 (1,625.74) AAA 0.17 0.04% NA/AAA 1.46 (934.03) AAA 0.24 0.05% Aaa/NA 1.46 (1,810.65) AAA 0.28 0.10% Aaa/AAA 1.65 (689.40) NA 0.64 0.22% NA/AAA 1.79 (10,001.14) AAA 0.46 0.14% Aaa/NA 1.81 (10,096.02) AAA 0.67 0.15% Aaa/NA 1.96 (10,167.02) AAA 0.53 0.10% NA/AAA 2.12 (6,444.70) AAA 0.66 0.35% Aaa/AAA 2.12 (24,180.38) NA 0.81 0.23% Aaa/AAA 2.40 (10,217.21) NA 0.93 0.24% Aaa/NA 2.46 (14,574.07) AAA 0.77 0.11% Aaa/AAA 2.46 (9,895.53) NA 0.85 0.29% NA/AAA 2.54 (18,577.23) AAA 0.91 31 37 HOLDINGS REPORT City of Dublin I Account #10198 I As of March 31, 2024 CAN CHANDLER ASSET MANAGEMENT Cusip Security Description Par Value/ Purchase Date Cost Value Mkt Price Units Purchase Yield Book Value Mkt YTM Market Value Accrued Int. of Port. Moody's/ Maturity Gain/Loss Fit h Duration 380146AC4 GMCAR 2022-1 A3 1.23 11/16/2026 343,311.18 01/11/2022 1.27% 343,281.34 343,296.95 97.54 6.28% 334,871.42 180.24 0.12% NA/AAA (8,425.53) AAA 2.63 0.90 362585AC5 GMCAR 2022-2 A3 3.102/16/2027 709,976.37 04/05/2022 3.13% 709,827.98 709,895.52 98.21 5.87% 697,252.95 917.05 0.24% Aaa/AAA (12,642.57) NA 2.88 1.12 47800AAC4 JDOT 2022-B A3 3.74 02/16/2027 1,045,000.00 07/12/2022 1,044,900.20 3.77% 1,044,939.60 98.54 1,029,699.32 0.36% Aaa/NA 2.88 5.73% 1,737.02 (15,240.28) AAA 1.04 448988AD7 HALST 24A A3 5.02 03/15/2027 785,000.00 01/17/2024 784,851.24 5.03% 784,860.07 99.52 781,199.34 0.27% NA/AAA 2.96 5.57% 1,751.42 (3,660.72) AAA 1.87 36269FAD8 GMALT 2024-1 A3 5.09 03/22/2027 995,000.00 02/08/2024 994,875.63 5.09% 994,880.69 99.93 994,343.60 0.34% NA/AAA 2.97 5.49% 1,547.50 (537.09) AAA 1.90 89238GAD3 TLOT 2024-A A3 5.25 04/20/2027 1,000,000.00 02/21/2024 999,957.80 100.29 1,002,869.40 0.35% NA/AAA 3.05 5.25% 999,959.05 5.59% 1,604.17 2,910.35 AAA 2.00 47800BAC2 JDOT 2022-C A3 5.09 06/15/2027 1,350,000.00 10/12/2022 1,349,895.24 99.65 5.15% 1,349,929.20 5.67% 1,345,238.82 3,054.00 58768PAC8 MBART 2022-1 A3 5.2108/16/2027 2,790,000.00 11/15/2022 2,789,448.14 5.28% 2,789,612.62 99.89 5.58% 0.47% Aaa/NA (4,690.38) AAA 2,787,041.76 6,460.40 0.96% Aaa/AAA (2,570.86) NA 3.21 1.33 3.38 1.59 362583AD8 GMCAR 2023-2 A3 4.47 02/16/2028 625,000.00 04/04/2023 624,982.81 4.51% 624,986.26 98.91 618,200.75 0.21% Aaa/AAA 3.88 5.50% 1,164.06 (6,785.51) NA 2.28 05592XAD2 BMWOT 2023-A A3 5.47 550,000.00 02/25/2028 07/11/2023 549,902.54 100.41 552,256.04 0.19% NA/AAA 3.91 5.47% 549,917.48 5.49% 501.42 2,338.56 AAA 2.26 89239FAD4 TAOT 2023-D A3 5.54 08/15/2028 980,000.00 11/07/2023 979,894.36 101.06 990,415.15 0.34% NA/AAA 4.38 6.30% 979,902.82 5.46% 2,412.98 10,512.33 AAA 2.78 161571HT4 CHAIT 2023-1 A 5.16 09/15/2028 3,090,000.00 09/07/2023 3,089,143.45 100.51 3,105,749.42 1.07% NR/AAA 4.46 5.17% 3,089,236.75 5.33% 7,086.40 16,512.67 AAA 2.26 47800RAD5 JDOT 2024 A3 4.96 11/15/2028 550,000.00 03/11/2024 549,969.20 5.12% 549,969.44 99.98 549,913.26 0.19% Aaa/NA 4.63 5.41% 909.33 (56.17) AAA 2.28 36268GAD7 GMCAR 2024-1 A3 4.85 12/18/2028 445,000.00 01/09/2024 444,910.51 4.91% 444,914.24 161571HV9 CHAIT 241 A 4.6 01/16/2029 1,910,000.00 99.72 443,774.43 0.15% Aaa/NA 4.72 5.40% 899.27 (1,139.82) AAA 3.05 01/24/2024 1,909,709.11 4.61% 1,909,718.90 448973AD9 HART 2024-A A3 4.99 02/15/2029 1,170,000.00 Total ABS 27,832,916.66 AGENCY 99.44 1,899,254.91 0.66% NR/AAA 4.80 4.86% 3,904.89 (10,463.99) AAA 2.71 03/11/2024 1,169,742.02 5.05% 1,169,743.75 27,828,526.72 4.03% 27,829,771.02 99.99 5.38% 99.28 5.51% 1,169,928.04 1,783.92 27,628,978.09 43,831.51 0.40% NA/AAA 184.30 AAA 9.56% Aaa/AAA (200,792.93) AAA 32 4.88 2.23 3.13 1.61 38 HOLDINGS REPORT City of Dublin 1 Account #10198 1 As of March 31, 2024 CAN CHANDLER ASSET MANAGEMENT Cusip Security Description Par Value/ Purchase Date Cost Value Mkt Price Units Purchase Yield Book Value Mkt YTM Market Value Accrued Int. of Port. Moody's/ Maturity Gain/Loss Fit h Duration 3133ENZ94 3135G0X24 3137EAEPO 3135G03U5 3135G04Z3 3137EAEU9 3135G05X7 3137EAEX3 3135G06G3 3130ATUC9 3130ATS57 880591EZ1 3130AWMN7 FEDERAL FARM CREDIT BANKS FUNDING CORP 4.5 11/18/2024 FEDERAL NATIONAL MORTGAGE ASSOCIATION 1.625 01/07/2025 FEDERAL HOME LOAN MORTGAGE CORP 1.5 02/12/2025 FEDERAL NATIONAL MORTGAGE ASSOCIATION 0.625 04/22/2025 FEDERAL NATIONAL MORTGAGE ASSOCIATION 0.5 06/17/2025 FEDERAL HOME LOAN MORTGAGE CORP 0.375 07/21/2025 FEDERAL NATIONAL MORTGAGE ASSOCIATION 0.375 08/25/2025 FEDERAL HOME LOAN MORTGAGE CORP 0.375 09/23/2025 FEDERAL NATIONAL MORTGAGE ASSOCIATION 0.5 11/07/2025 FEDERAL HOME LOAN BANKS 4.5 12/12/2025 FEDERAL HOME LOAN BANKS 4.5 03/10/2028 TENNESSEE VALLEY AUTHORITY 3.875 03/15/2028 FEDERAL HOME LOAN BANKS 4.375 06/09/2028 5,480,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 4,000,000.00 3,000,000.00 2,645,000.00 1,500,000.00 5,474,191.20 5,478,164.39 4,287,898.80 97.36 1.19% 4,213,986.28 5.18% 4,254,786.30 96.91 1.23% 4,209,625.18 5.20% 04/22/2020 1,821,240.50 95.48 0.67% 1,824,204.40 5.06% 06/17/2020 3,427,889.55 94.84 0.54% 3,433,276.96 4.95% 07/21/2020 1,736,309.90 94.34 0.48% 1,742,732.19 4.90% 08/25/2020 2,742,106.60 93.93 0.47% 2,751,387.87 4.91% 09/23/2020 2,647,008.45 93.67 0.44% 2,652,634.08 4.87% 11/09/2020 2,849,761.20 93.47 0.57% 2,856,710.77 4.79% 02/09/2023 4,029,238.40 99.50 4.22% 4,017,497.88 4.81% 03/21/2023 3,065,010.00 100.43 4.01% 3,051,542.36 4.38% 2,661,791.35 98.26 2,598,917.99 3.73% 2,658,594.20 4.36% 4,555.28 07/2 6/202 3 1, 506, 615.00 100.07 1, 501, 069.98 4.27% 1,505,689.12 4.35% 20,416.67 40,503,847.25 97.09 39,102,074.45 11/15/2022 4.55% 99.55 5.22% 5,455,589.18 91,105.00 4,089,134.74 15,925.00 4,070,252.30 8,575.00 1,742,530.95 5,037.76 3,257,583.62 4,961.67 1,646,208.19 1,272.40 2,587,854.15 1,033.12 2,486,935.34 221.25 2,673,323.25 5,720.00 3,979,843.52 54,500.00 3,012,831.24 7,875.00 Total Agency 40,300,000.00 2.23% 40,396,045.68 4.90% 221,198.14 AGENCY CMBS 3137BFE98 FHMS K-041 A2 3.171 10/25/2024 1,964,960.54 07/01/2021 2,113,714.19 98.68 1,938,936.21 0.66% 1,987,990.93 5.34% 5,192.41 3137BSRE5 FHMS K-059 A2 3.12 09/25/2026 2,000,000.00 02/18/2022 2,085,625.00 96.17 1,923,445.20 2.08% 2,045,822.35 5.13% 5,200.00 3137F4D41 FHMS K-074 A2 3.6 01/25/2028 1,000,000.00 07/25/2023 954,414.06 96.46 964,576.60 4.73% 961,401.27 5.04% 3,000.00 1.89% Aaa/AA+ (22,575.21) AA+ 1.41% Aaa/AA+ (124,851.54) AA+ 0.64 0.61 0.77 0.75 1.41% Aaa/AA+ 0.87 (139,372.88) AA+ 0.84 0.60% Aaa/AA+ 1.06 (81,673.45) AA+ 1.03 1.13% Aaa/AA+ 1.21 (175,693.34) AA+ 1.18 0.57% Aaa/AA+ 1.31 (96,524.00) AA+ 1.27 0.90% Aaa/AA+ 1.40 (163,533.72) AA+ 1.37 0.86% Aaa/AA+ 1.48 (165,698.74) AA+ 1.44 0.93% Aaa/AA+ 1.61 (183,387.51) AA+ 1.56 1.38% Aaa/AA+ 1.70 (37,654.36) AA+ 1.60 1.04% Aaa/AA+ 3.94 (38,711.12) AA+ 3.58 0.90% Aaa/AA+ 3.96 (59,676.21) AA+ 3.62 0.52% Aaa/AA+ 4.19 (4,619.14) AA+ 3.75 13.53% Aaa/AA+ 1.66 (1,293,971.23) AA+ 1.56 0.67% Aaa/AA+ 0.57 (49,054.72) AAA 0.49 0.67% Aaa/AAA 2.49 (122,377.15) AAA 2.25 0.33% Aaa/AA+ 3.82 3,175.33 AAA 3.42 33 39 HOLDINGS REPORT City of Dublin 1 Account #10198 1 As of March 31, 2024 CAN CHANDLER ASSET MANAGEMENT Cusip Security Description Par Value/ Purchase Date Cost Value Mkt Price Units Purchase Yield Book Value Mkt YTM Market Value Accrued Int. Moody's/ % of Port. Maturity Gain/Loss Fit h Duration 3137FG6X8 FHMS K-077 A2 3.85 05/25/2028 3137FK4M5 FHMS K-085 A2 4.06 10/25/2028 Total Agency CMBS CASH CCYUSD CCYUSD Total Cash CORPORATE Cash Receivable 2,815,000.00 1,100,000.00 8,879,960.54 12,415.95 444,066.15 456,482.10 24422ETT6 JOHN DEERE CAPITAL CORP 2.65 2,000,000.00 06/24/2024 79466LAG9 SALESFORCE INC 0.625 07/15/2024 465,000.00 90331HPL1 US BANK NA 2.05 01/21/2025 2,610,000.00 00440EAS6 CHUBB INA HOLDINGS INC 3.15 2,500,000.00 03/15/2025 14913R2V8 CATERPILLAR FINANCIAL SERVICES 1,165,000.00 CORP 3.4 05/13/2025 747525AF0 QUALCOMM INC 3.45 05/20/2025 3,000,000.00 61747YEA9 MORGAN STANLEY 0.79 05/30/2025 3,040,000.00 438516CB0 HONEYWELL INTERNATIONAL INC 2,500,000.00 1.35 06/01/2025 ROYAL BANK OF CANADA 1.15 78015K7H1 1,000,000.00 06/10/2025 66815L2J7 NORTHWESTERN MUTUAL GLOBAL 2,500,000.00 FUNDING 4.0 07/01/2025 05/24/2023 4.24% 10/30/2023 5.37% 3.15% 2,763,318.36 2,772,142.76 1,038,253.91 1,043,448.15 8,955,325.52 8,810,805.45 12,415.95 0.00% 12,415.95 444,066.15 0.00% 444,066.15 456,482.10 0.00% 456,482.10 2,093,680.00 1.35% 2,005,947.82 06/29/2021 464,762.85 0.64% 464,977.34 01/16/2020 2,604,440.70 2.09% 2,609,102.36 2,753,600.00 0.78% 2,555,918.13 05/10/2022 1,163,520.45 3.44% 1,164,450.57 3,159,848.58 1.61% 3,048,111.12 05/26/2021 3, 041, 611.70 0.77% 3,040,086.92 06/23/2020 2,559,500.00 0.85% 2,513,270.75 02/22/2021 1,012,240.00 0.86% 1,003,397.83 06/27/2022 2,499,150.00 4.01% 2,499,646.35 97.01 5.05% 97.51 5.04% 97.20 5.13% 1.00 0.00% 1.00 0.00% 1.00 0.00% 2,730,759.15 9,031.46 1,072,642.67 3,721.67 8,630,359.83 26,145.53 12,415.95 0.00 444,066.15 0.00 456,482.10 0.00 0.94% (41,383.60) 0.37% 29,194.52 2.99% (180,445.62) Aaa/AA+ MA Aaa/AA+ AA+ 4.15 3.67 4.57 4.04 Aaa/AA+ 2.99 AAA 2.66 0.00% Aaa/AAA 0.00 0.00 AAA 0.00 0.15% Aaa/AAA 0.00 0.00 AAA 0.00 0.16% Aaa/AAA 0.00 0.00 AAA 0.00 99.35 1,987,051.86 0.69% A1/A 0.23 5.45% 14,280.56 (18,895.96) A+ 0.23 98.61 458,546.97 0.16% A1/A+ 0.29 5.50% 613.54 (6,430.37) NA 0.29 97.34 2,540,479.67 0.88% A2/A+ 0.81 5.47% 10,403.75 (68,622.68) A+ 0.78 97.92 2,447,959.40 0.85% A3/A 0.96 5.41% 3,500.00 (107,958.73) A 0.93 98.08 1,142,618.17 0.40% A2/A 1.12 5.19% 15,183.83 (21,832.40) A+ 1.07 98.13 2,944,046.40 1.02% A2/A 1.14 5.16% 37,662.50 (104,064.72) NA 1.09 99.07 3,011,816.16 1.04% A1/A- 1.16 6.40% 8,072.04 (28,270.76) A+ 0.17 95.83 2,395,772.22 0.83% A2/A 1.17 5.07% 11,250.00 (117,498.53) A 1.13 95.39 953,884.97 0.33% A1/A 1.19 5.19% 3,545.83 (49,512.86) AA- 1.16 98.65 2,466,351.28 0.85% Aaa/AA+ 1.25 5.12% 25,000.00 (33,295.07) AAA 1.20 34 40 HOLDINGS REPORT City of Dublin 1 Account #10198 1 As of March 31, 2024 CAN CHANDLER ASSET MANAGEMENT Cusip Security Description Par Value/ Purchase Date Cost Value Mkt Price Units Purchase Yield Book Value Mkt YTM Moody's/ Market Value % of Port. Maturity Accrued Int. Gain/Loss Ftch Duration 02665WDL2 89114QCK2 06051GHY8 46647PBH8 808513BR5 91324PEC2 89236TJ K2 58989V2D5 06368FAC3 931142ER0 59217GER6 87612EBM7 808513BY0 084664CZ2 40139LBF9 023135CF1 46647PCB0 927804GH1 AMERICAN HONDA FINANCE CORP 1.2 07/08/2025 TORONTO-DOMINION BANK 0.75 09/11/2025 BANK OF AMERICA CORP 2.015 02/13/2026 JPMORGAN CHASE & CO 2.005 03/13/2026 CHARLES SCHWAB CORP 1.15 05/13/2026 UNITEDHEALTH GROUP INC 1.15 05/15/2026 TOYOTA MOTOR CREDIT CORP 1.125 06/18/2026 MET TOWER GLOBAL FUNDING 1.25 09/14/2026 BANK OF MONTREAL 1.25 09/15/2026 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 WALMART INC 1.05 09/17/2026 585,000.00 1,860,000.00 TARGET CORP 1.95 01/15/2027 1,340,000.00 METROPOLITAN LIFE GLOBAL FUNDING 11.875 01/11/2027 CHARLES SCHWAB CORP 2.45 03/03/2027 BERKSHIRE HATHAWAY FINANCE CORP 2.3 03/15/2027 GUARDIAN LIFE GLOBAL FUNDING 3.246 03/29/2027 585,000.00 2,295,000.00 765,000.00 AMAZON.COM INC 3.3 04/13/2027 1,750,000.00 JPMORGAN CHASE & CO 1.578 500,000.00 04/22/2027 VIRGINIA ELECTRIC AND POWER CO 3.75 05/15/2027 1,000,000.00 08/10/2021 1.00% 02/16/2021 0.81% 03/04/2021 1.15% 04/29/2021 1.21% 05/11/2021 1.20% 1,007,640.00 1,002,480.59 997,230.00 999,122.11 1,291,725.00 1,259,227.08 1,030,270.00 1,007,412.19 1,366,821.60 1,368,656.23 1,939,210.15 1.90% 1,969,350.44 06/15/2021 2,483, 906.60 1.13% 2,484,516.18 09/07/2021 1,283,817.80 1.27% 1,284,419.91 2,495,539.50 1.29% 2,497,808.84 09/08/2021 583,894.35 1.09% 584,455.65 01/03/2022 1,857,879.60 1.90% 1,858,821.35 01/19/2022 1,337,722.00 1.99% 1,338,722.47 03/01/2022 584,368.20 2.47% 584,631.16 03/07/2022 2,294,563.95 2.30% 2,294,742.57 03/24/2022 765,000.00 3.25% 765,000.00 04/25/2022 1, 746, 972.50 3.34% 1,748,150.42 08/23/2022 449,845.00 4.64% 470,983.49 999,773.40 3.75% 999,845.95 94.97 5.35% 93.92 5.17% 96.88 5.76% 96.68 5.65% 92.19 5.09% 92.49 4.92% 92.04 4.96% 91.04 5.19% 91.23 5.10% 91.68 4.67% 91.85 5.05% 92.95 4.67% 93.19 4.98% 94.16 4.43% 95.29 4.96% 96.18 4.66% 92.71 5.36% 96.47 4.98% 949,728.47 2,766.67 939,171.10 416.67 1,210,965.95 3,358.33 966,764.94 1,002.50 1,262,992.55 6,039.42 1,849,897.68 8,688.89 2,287,263.33 7,998.59 1,169,802.40 758.51 2,280,676.22 1,388.89 536,299.66 238.88 1,708,455.94 7,750.00 1,245,567.31 5,516.33 545,154.67 1,114.75 2,161,085.49 2,346.00 728,932.62 137.96 1,683,209.99 26,950.00 463,557.40 3,484.75 964,663.65 14,166.67 0.33% A3/A- (52,752.12) A 0.32% Al/A (59,951.01) AA- 0.42% Al/A- (48,261.13) AA- 0.33% Al/A- (40,647.25) AA- 0.44% A2/A- (105,663.68) A 0.64% A2/A+ (119,452.76) A 0.79% A1/A+ (197,252.84) A+ 0.40% Aa3/AA- (114,617.51) AA- 0.79% A2/A- (217,132.61) AA- 0.19% Aa2/AA (48,155.99) AA 0.59% Aa3/AA- (150,365.41) AA- 0.43% A2/A (93,155.16) A 0.19% A2/A- (39,476.49) A 0.75% Aa2/AA (133,657.08) A+ 0.25% Aa1/AA+ (36,067.38) NA 0.58% Al/AA (64,940.43) AA- 0.16% Al/A- (7,426.09) AA- 0.33% A2/BBB+ (35,182.30) A 35 1.27 1.23 1.45 1.41 1.87 0.84 1.95 0.92 2.12 2.04 2.12 2.05 2.22 2.14 2.46 2.36 2.46 2.37 2.47 2.38 2.78 2.64 2.79 2.65 2.92 2.76 2.96 2.81 2.99 2.81 3.04 2.80 3.06 1.97 3.12 2.86 41 HOLDINGS REPORT City of Dublin 1 Account #10198 1 As of March 31, 2024 CAN CHANDLER ASSET MANAGEMENT Cusip Security Description Par Value/ Purchase Date Units Purchase Yield Moody's/ Cost Value Mkt Price Market Value % of Port. Maturity Book Value Mkt YTM Accrued Int. Gain/Loss F8ch Duration 14913R3A3 CATERPILLAR FINANCIAL SERVICES CORP 3.6 08/12/2027 931142EX7 WALMART INC 3.95 09/09/2027 89236TKJ3 1,375,000.00 1,500,000.00 1,357,243.75 3.89% 1,362,865.89 96.37 4.78% 1,325,114.01 6,737.50 0.46% A2/A (37,751.88) A+ 3.37 3.11 1,498,302.30 3.97% 1,498,832.25 98.25 4.50% 1,473,760.66 3,620.83 0.51% Aa2/AA (25,071.58) AA 3.44 3.17 TOYOTA MOTOR CREDIT CORP 4.55 09/20/2027 1,500,000.00 11/22/2022 1,479,060.00 99.03 4.88% 1,484,925.58 4.86% 1,485,431.43 2,085.42 0.51% A1/A+ 505.85 A+ 3.47 3.17 023135CP9 AMAZON.COM INC 4.55 12/01/2027 1,000,000.00 01/17/2023 1,014,400.00 99.95 4.21% 1,010,789.69 4.56% 999,465.36 15,166.67 0.35% Al/AA 3.67 (11,324.33) AA- 3.30 89115A2M3 TORONTO-DOMINION BANK 5.156 01/10/2028 3,000,000.00 756109AU8 REALTY INCOME CORP 3.65 01/15/2028 960,000.00 24422EWR6 JOHN DEERE CAPITAL CORP 4.75 01/20/2028 2,000,000.00 2,984,380.00 5.28% 2,987,111.65 100.64 4.97% 3,019,227.84 34,803.00 1.04% Al/A 32,116.19 AA- 3.78 3.36 04/10/2023 910,540.80 4.87% 920,637.42 95.29 914,796.83 0.32% A3/A- 3.79 5.03% 7,397.33 (5,840.59) WR 3.45 01/23/2023 2,030,780.00 100.21 2,004,266.00 0.69% A1/A 4.40% 2,023,477.99 4.69% 18,736.11 (19,211.99) A+ 06051GGF0 BANK OF AMERICA CORP 3.824 3,000,000.00 01/20/2028 2,824,349.55 5.54% 2,871,701.67 96.32 5.25% 2,889,465.66 22,625.33 3.81 3.42 1.00% Al/A- 17,763.99 AA- 3.81 2.60 06368LGV2 BANK OF MONTREAL 5.203 2,000,000.00 02/01/2028 08/17/2023 1,972,380.00 100.74 2,014,813.76 0.70% A2/A- 3.84 5.56% 1,976,187.31 4.98% 17,343.33 38,626.45 AA- 3.35 91324PEP3 UNITEDHEALTH GROUP INC 5.25 1,500,000.00 02/15/2028 02/21/2023 1,522,890.00 101.83 1,527,496.76 0.53% A2/A+ 3.88 4.90% 1,517,727.90 4.72% 10,062.50 9,768.85 A 3.39 46647PAF3 JPMORGAN CHASE & CO 3.54 2,000,000.00 05/01/2028 08/16/2023 1,854,340.00 5.75% 1,878,796.23 95.53 1,910,625.78 0.66% A1/A- 4.08 5.12% 29,500.00 31,829.55 AA- 2.83 58933YBH7 MERCK & CO INC 4.05 05/17/2028 3,500,000.00 4.06% 3,497,960.40 3,498,317.46 98.30 3,440,544.38 1.19% A1/A+ 4.13 4.50% 52,762.50 (57,773.08) NA 3.70 06406RBG1 BANK OF NEW YORK MELLON CORP 1,500,000.00 10/26/2023 1,395,930.00 97.02 3.992 06/13/2028 6.16% 1,408,053.13 5.01% 1,455,274.59 17,964.00 0.50% Al/A 47,221.46 AA- 4.20 2.93 02665WEM9 AMERICAN HONDA FINANCE CORP 1,370,000.00 5.125 07/07/2028 10/12/2023 1,343,288.50 101.13 1,385,473.55 0.48% A3/A- 4.27 5.60% 1,345,888.46 4.83% 16,382.92 39,585.09 A 3.76 78016HZS2 ROYAL BANK OF CANADA 5.2 2,500,000.00 08/01/2028 09/07/2023 2,464,100.00 101.00 2,524,893.92 0.87% A1/A 4.34 5.54% 2,468,180.46 4.94% 21,666.67 56,713.47 AA- 3.82 756109BS2 REALTY INCOME CORP 4.7 1,000,000.00 12/15/2028 01/19/2024 994,260.00 98.49 984,912.71 0.34% A3/A- 4.71 4.83% 994,481.51 5.06% 13,838.89 (9,568.80) NA 4.11 91324PEU2 17275RBR2 UNITEDHEALTH GROUP INC4.25 01/15/2029 CISCO SYSTEMS INC 4.85 02/26/2029 1,000,000.00 1,565,000.00 01/23/2024 984,020.00 98.00 979,969.62 0.34% A2/A+ 4.79 4.61% 984,609.25 4.72% 8,972.22 (4,639.63) A 4.25 02/21/2024 1,564,452.25 100.74 1,576,551.95 0.55% A1/AA- 4.91 4.86% 1,564,462.74 4.68% 7,379.41 12,089.21 NA 4.30 36 42 HOLDINGS REPORT City of Dublin 1 Account #10198 1 As of March 31, 2024 CAN CHANDLER ASSET MANAGEMENT Cusip Security Description Par Value/ Purchase Date Cost Value Mkt Price Units Purchase Yield Book Value Mkt YTM % Moody's/ Market Valueof Port. Maturity Accrued Int. Gain/Loss F8ch Duration Total Corporate 77,620,000.00 3.13% 77,561,211.48 77,220,302.41 5.06% 530,680.48 (2,005,501.12) A+ 96.99 75,214,801.29 26.03% A1/A 2.71 2.34 MONEY MARKET FUND 31846V203 FIRST AMER:GVT OBLG Y Total Money Market Fund SUPRANATIONAL 459058JB0 4581X0DN5 459058JL8 4581X0DV7 459058KT9 45950KDD9 4581X0DC9 4581X0EN4 Total Supranational INTERNATIONAL BANK FOR RECONSTRUCTION AND DEVELOPM 0.625 04/22/2025 INTER-AMERICAN DEVELOPMENT BANK 0.625 07/15/2025 INTERNATIONAL BANK FOR RECONSTRUCTION AND DEVELOPM 0.5 10/28/2025 INTER-AMERICAN DEVELOPMENT BANK 0.875 04/20/2026 INTERNATIONAL BANK FOR RECONSTRUCTION AND DEVELOPM 3.5 07/12/2028 INTERNATIONAL FINANCE CORP 4.5 07/13/2028 INTER-AMERICAN DEVELOPMENT BANK 3.125 09/18/2028 INTER-AMERICAN DEVELOPMENT BANK 4.125 02/15/2029 813,045.93 813,045.93 1.00 813,045.93 4.91% 813,045.93 4.91% 0.00 813,045.93 4.91% 2,260,000.00 1,685,000.00 6,000,000.00 4,615,000.00 5,000,000.00 1,605,000.00 3,360,000.00 3,000,000.00 27,525,000.00 813,045.93 1.00 813,045.93 4.91% 813,045.93 0.00 0.28% Aaa/ AAAm 0.00 0.00 AAA 0.00 Aaa/ 0.28% AAAm 0.00 0.00 AAA 0.00 04/15/2020 2,251,253.80 95.58 2,160,107.05 0.75% Aaa/AAA 1.06 0.70% 2,258,151.13 4.96% 6,248.52 (98,044.08) NA 1.03 01/13/2021 1,692,329.75 94.69 1,595,588.74 0.55% Aaa/AAA 1.29 0.53% 1,687,098.04 4.92% 2,223.26 (91,509.29) NA 1.26 5,986,632.00 93.53 5,612,004.18 1.94% Aaa/AAA 1.58 0.55% 5,995,562.67 4.81% 12,750.00 (383,558.49) NA 1.53 04/13/2021 4,593,863.30 92.58 4,272,757.78 1.48% Aaa/AAA 2.05 0.97% 4,606,330.02 4.71% 18,059.39 (333,572.23) NA 1.99 4,813,059.00 96.64 4,831,811.10 1.67% Aaa/AAA 4.28 4.35% 4,837,019.94 4.37% 38,402.78 (5,208.84) NA 3.89 07/06/2023 1,603,218.45 100.54 1,613,645.35 0.56% Aaa/AAA 4.28 4.53% 1,603,474.91 4.36% 15,648.75 10,170.44 NA 3.83 -- 3,187,150.40 94.96 3,190,807.20 1.10% Aaa/AAA 4.47 4.33% 3,198,829.66 4.38% 3,791.67 (8,022.46) NA 4.10 02/15/2024 2,970,690.00 99.04 2,971,208.67 1.03% Aaa/AAA 4.88 4.34% 2,971,349.56 4.34% 20,968.75 (140.89) NA 4.34 27,098,196.70 95.42 26,247,930.08 9.08% Aaa/AAA 2.98 2.46% 27,157,815.92 4.60% 118,093.12 (909,885.85) NA 2.75 US TREASURY 37 43 HOLDINGS REPORT City of Dublin I Account #10198 I As of March 31, 2024 CAN CHANDLER ASSET MANAGEMENT Cusip Security Description Par Value/ Purchase Date Cost Value Mkt Price Units Purchase Yield Book Value Mkt YTM Market Value Accrued Int. Moody's/ of Port. Maturity Gain/Loss S&P Duration 91282CFP1 UNITED STATES TREASURY 4.25 10/15/2025 91282CBC4 UNITED STATES TREASURY 0.375 12/31/2025 91282CBH3 10,000,000.00 1,000,000.00 - - 10,002,724.61 99.18 4.24% 10,001,693.89 4.81% 9,917,578.10 196,243.17 3.43% Aaa/AA+ (84,115.79) AA+ 12/29/2020 999,921.88 92.75 0.38% 999,972.66 927,500.00 0.32% Aaa/AA+ 1.54 1.45 1.75 4.74% 947.80 (72,472.66) AA+ 1.71 UNITED STATES TREASURY 0.375 01/31/2026 4,000,000.00 02/23/2021 3,960,625.00 0.58% 3,985,360.02 91282CBQ3 UNITED STATES TREASURY 0.5 02/28/2026 91282CBT7 UNITED STATES TREASURY 0.75 03/31/2026 91282CCF6 UNITED STATES TREASURY 0.75 05/31/2026 2,500,000.00 03/26/2021 2,459,960.94 0.83% 2,484,447.82 92.46 3,698,281.24 1.28% Aaa/AA+ 1.84 4.71% 2,513.74 (287,078.78) AA+ 1.79 92.43 2,310,644.52 0.80% Aaa/AA+ 1.91 4.68% 1,086.96 (173,803.30) AA+ 1.87 5,000,000.00 2,000,000.00 -- 4,974,804.69 0.85% 4,989,907.42 92.66 4,632,812.50 1.60% Aaa/AA+ 2.00 4.64% 102.46 (357,094.92) AA+ 1.94 06/ 18/ 2 021 1, 985, 000.00 0.90% 1,993,434.90 92.13 1,842,578.12 0.64% Aaa/AA+ 2.17 4.61% 5,040.98 (150,856.78) AA+ 2.10 91282CCW9 UNITED STATES TREASURY 0.75 08/31/2026 2,000,000.00 08/30/2021 1,998,515.63 0.77% 1,999,283.02 91.41 1,828,203.12 0.63% Aaa/AA+ 2.42 4.54% 1,304.35 (171,079.90) AA+ 2.35 91282CDG3 UNITED STATES TREASURY 1.125 5,000,000.00 10/31/2026 -- 4,970,498.06 1.25% 4,984,442.72 91.84 4,592,187.50 1.59% Aaa/AA+ 2.59 4.51% 23,643.54 (392,255.22) AA+ 2.49 912828Z78 UNITED STATES TREASURY1.5 4,500,000.00 01/31/2027 91282CEN7 91282CEW7 UNITED STATES TREASURY 2.75 04/30/2027 UNITED STATES TREASURY 3.25 06/30/2027 -- 4,367,285.16 2.15% 4,421,485.69 92.22 4,149,843.75 1.44% Aaa/AA+ 2.84 4.45% 11,311.81 (271,641.94) AA+ 2.72 7,000,000.00 9,000,000.00 -- 6,761,484.38 3.55% 6,842,056.99 95.23 6,665,859.34 2.31% Aaa/AA+ 3.08 4.42% 80,913.46 (176,197.65) AA+ 2.88 -- 9,018,066.41 3.22% 9,009,106.54 96.57 8,691,328.08 3.01% Aaa/AA+ 3.25 4.44% 73,928.57 (317,778.46) AA+ 3.02 91282CFM8 UNITED STATES TREASURY 4.125 10,000,000.00 09/30/2027 91282CGC9 UNITED STATES TREASURY 3.875 10,000,000.00 12/31/2027 -- 10,074,062.50 99.22 9,922,265.60 3.43% Aaa/AA+ 3.50 3.95% 10,054,139.67 4.37% 1,127.05 (131,874.07) AA+ 3.16 3.70% 10,078,828.13 10,059,955.58 98.39 9,838,671.90 3.40% Aaa/AA+ 3.75 4.34% 97,939.56 (221,283.68) AA+ 3.42 91282CGT2 UNITED STATES TREASURY 3.625 7,000,000.00 03/31/2028 91282CHE4 UNITED STATES TREASURY 3.625 05/31/2028 91282CHQ7 UNITED STATES TREASURY 4.125 07/31/2028 91282CJA0 UNITED STATES TREASURY 4.625 09/30/2028 4,500,000.00 9,000,000.00 3,750,000.00 -- 7,014,042.96 3.58% 7,011,465.98 97.48 6,823,906.25 2.36% Aaa/AA+ 4.00 4.32% 693.31 (187,559.73) AA+ 3.61 - - 4,412,773.44 4.07% 4,425,801.42 97.46 4,385,917.98 1.52% Aaa/AA+ 4.17 4.29% 54,820.70 (39,883.44) AA+ 3.78 - - 8,848,203.13 4.51% 8,864,804.98 99.38 8,943,750.00 3.09% Aaa/AA+ 4.33 4.28% 62,214.97 78,945.02 AA+ 3.91 - - 3,702,089.84 4.92% 3,706,390.22 101.44 3,804,052.72 1.32% Aaa/AA+ 4.50 4.27% 473.87 97,662.50 AA+ 3.95 91282CJN2 UNITED STATES TREASURY4.375 5,500,000.00 11/30/2028 4.03% 5,584,941.41 5,580,322.89 100.53 5,529,003.92 1.91% Aaa/AA+ 4.67 4.25% 80,865.78 (51,318.97) AA+ 4.13 38 44 HOLDINGS REPORT City of Dublin 1 Account #10198 1 As of March 31, 2024 CAN CHANDLER ASSET MANAGEMENT Cusip Security Description Par Value/ Purchase Date Units Purchase Yield Cost Value Mkt Price Book Value Mkt YTM Market Value Accrued Int. of Port. Moody's/ Gain/Loss S&P Fitch Maturity Duration 91282CJR3 91282CKD2 UNITED STATES TREASURY 3.75 12/31/2028 Total US Treasury Total Portfolio Total Market Value + Accrued UNITED STATES TREASURY 4.25 02/28/2029 5,500,000.00 7,000,000.00 114,250,000.00 297,677,405.23 4.00% 5,438,359.38 5,440,705.98 97.87 4.25% 4.25% 3.34% 3.12% 7,001,171.88 7,001,230.06 113,653,359.43 113,856,008.47 296,869,995.13 296,540,276.99 100.13 4.22% 97.15 4.42% 5,382,695.34 52,129.12 7,009,296.84 25,869.57 110,896,376.83 773,170.77 1.86% (58,010.64) 2.43% 8,066.78 38.37% (2,959,631.64) Aaa/AA+ AA+ 4.75 4.26 Aaa/AA+ AA+ Aaa/AA+ AA+ 4.91 4.38 3.40 3.11 96.73 288,990,048.61 100.00% Aa2/AA- 2.90 4.79% 1,713,119.56 (7,550,228.38) AA 2.50 290,703,168.17 39 45 HOLDINGS REPORT City of Dublin Reporting Account I Account #10219 I As of March 31, 2024 CAN CHANDLER ASSET MANAGEMENT Cusip Security Description Par Value/ Purchase Date Cost Value Mkt Price Units Purchase Yield Book Value Mkt YTM Market Value Accrued Int. of Port. Moody's/ Maturity Gain/Loss S&P Duration CASH CCYUSD Total Cash LAIF Receivable 274,479.54 274,479.54 90LAIF$00 State Pool 26,800,793.08 26,800,793.08 Total LAIF 274,479.54 0.00% 274,479.54 274,479.54 0.00% 274,479.54 4.27% 4.27% 26,800,793.08 26,800,793.08 26,800,793.08 26,800,793.08 1.00 0.00% 1.00 0.00% 1.00 4.27% 1.00 4.27% 274,479.54 0.00 274,479.54 0.00 26,800,793.08 0.00 26,800,793.08 0.00 0.21% Aaa/AAA 0.00 AAA 0.21% Aaa/AAA 0.00 AAA 20.36% NA/NA 0.00 NA 20.36% NA/NA 0.00 NA 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 LOCAL GOV INVESTMENT POOL 90CAMP$00 CAMP 104,531,280.85 Total Local Gov Investment Pool 104,531,280.85 Total Portfolio 131,606,553.47 Total Market Value + Accrued 5.48% 5.48% 5.22% 104,531,280.85 1.00 104,531,280.85 5.48% 104,531,280.85 1.00 104,531,280.85 5.48% 131,606,553.47 1.00 131,606,553.47 5.22% 104,531,280.85 0.00 104,531,280.85 0.00 131,606,553.47 0.00 131,606,553.47 79.43% NA/AAAm 0.00 AAA NA/ 79.43% AAAm 0.00 AAA 100.00% Aaa/AAA 0.00 AAA 40 0.00 0.00 0.00 0.00 0.00 0.00 46 Section 5 I Transactions TRANSACTION LEDGER City of Dublin 1 Account #10198 1 As of March 31, 2024 CAN CHANDLER ASSET MANAGEMENT Transaction Type Settlement CUSIP Date Quantity Security Description Acq/Disp Price Yield Amount Interest Pur/Sold Total Amount Gain/Loss ACQUISITIONS Purchase Purchase Purchase Purchase Purchase Purchase Purchase Purchase Purchase Purchase Purchase Purchase Purchase Purchase Purchase Total Purchase 01/17/2024 36268GAD7 01/18/2024 91282CJR3 01/23/2024 756109BS2 01/24/2024 448988AD7 01/25/2024 91324PEU2 01/31/2024 161571HV9 01/31/2024 91282CJR3 02/15/2024 36269FAD8 02/20/2024 4581X0EN4 02/26/2024 17275RBR2 02/27/2024 89238GAD3 03/18/2024 91282CKD2 03/19/2024 47800RAD5 03/20/2024 448973AD9 03/28/2024 91282CKD2 445,000.00 GMCAR 2024-1 A3 4.85 12/18/2028 3,000,000.00 UNITED STATES TREASURY3.75 12/31/2028 1,000,000.00 REALTY INCOME CORP 4.7 12/15/2028 785,000.00 HALST 24A A3 5.02 03/15/2027 1,000,000.00 UNITEDHEALTH GROUP INC 98.402 4.25 01/15/2029 1,910,000.00 CHAIT 241 A 4.6 01/16/2029 2,500,000.00 UNITED STATES TREASURY3.75 12/31/2028 995,000.00 GMALT 2024-1 A3 5.09 03/22/2027 3,000,000.00 INTER -AM E RICAN DEVELOPMENT BANK 4.125 02/15/2029 1,565,000.00 1,000,000.00 3,000,000.00 550,000.00 1,170,000.00 CISCO SYSTEMS INC 4.85 02/26/2029 TLOT 2024-A A3 5.25 04/20/2027 UNITED STATES TREASURY 4.25 02/28/2029 JDOT 2024 A3 4.96 11/15/2028 HART 2024-A A3 4.99 02/15/2029 4,000,000.00 UNITED STATES TREASURY 4.25 02/28/2029 25,920,000.00 99.980 4.91% 98.785 4.02% 2,963,554.69 (5,563.19) (2,969,117.88) 99.426 4.83% 99.981 444,910.51 0.00 (444,910.51) 994,260.00 (4,961.11) (999,221.11) 784,851.24 0.00 (784,851.24) 984,020.00 (1,180.55) (985,200.55) 99.985 1,909,709.11 0.00 (1,909,709.11) 98.992 3.98% 2,474,804.69 (7,984.20) (2,482,788.89) 99.988 5.15% 994,875.63 0.00 (994,875.63) 99.023 4.34% 2,970,690.00 (6,875.00) (2,977,565.00) 99.965 4.86% 1,564,452.25 99.996 999,957.80 0.00 (1,564,452.25) 0.00 (999,957.80) 99.633 4.33% 2,988,984.38 (6,236.41) (2,995,220.79) 99.994 5.01% 99.978 5.05% 549,969.20 1,169,742.02 0.00 (549,969.20) 0.00 (1,169,742.02) 100.305 4.18% 4,012,187.50 (12,934.78) (4,025,122.28) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 25,806,969.02 (45,735.24) (25,852,704.26) 0.00 42 48 TRANSACTION LEDGER City of Dublin 1 Account #10198 1 As of March 31, 2024 CAN CHANDLER ASSET MANAGEMENT Transaction Type Settlement CUSIP Date Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/Sold Total Amount Gain/Loss TOTAL ACQUISITIONS 25,920,000.00 DISPOSITIONS Sale 01/18/2024 91282CDZ1 (1,500,000.00) Sale 01/22/2024 3133EKWV4 (2,500,000.00) Sale 01/25/2024 023135BW5 Sale 01/31/2024 91282CED9 Sale 02/09/2024 912828ZL7 Sale 02/16/2024 3130A2UW4 Sale 02/16/2024 912828ZL7 Sale 02/23/2024 912828ZL7 Sale 03/18/2024 3135G0W66 Sale 03/18/2024 91282CFE6 Sale 03/28/2024 91282CAM3 Total Sale TOTAL DISPOSITIONS (1,000,000.00) (2,000,000.00) (250,000.00) (2,000,000.00) (1,000,000.00) (1,500,000.00) (2,000,000.00) (3,000,000.00) (2,500,000.00) (19,250,000.00) (19,250,000.00) UNITED STATES TREASURY 1.5 02/15/2025 FEDERAL FARM CREDIT BANKS FUNDING CORP 1.85 07/26/2024 AMAZON.COM INC 0.45 05/12/2024 UNITED STATES TREASURY 1.75 03/15/2025 UNITED STATES TREASURY 0.375 04/30/2025 FEDERAL HOME LOAN BANKS 2.875 09/13/2024 UNITED STATES TREASURY 0.375 04/30/2025 UNITED STATES TREASURY 0.375 04/30/2025 FEDERAL NATIONAL MORTGAGE ASSOCIATION 1.625 10/15/2024 UNITED STATES TREASURY 3.125 08/15/2025 UNITED STATES TREASURY 0.25 09/30/2025 25,806,969.02 (45,735.24) (25,852,704.26) 96.586 4.79% (1,448,789.06) (9,538.04) 98.306 5.25% (2,457,650.00) (22,611.11) 0.00 1,458,327.10 (29,378.44) 2,480,261.11 (44,833.43) 98.533 5.46% (985,330.00) (912.50) 986,242.50 (14,526.13) 96.789 4.72% (1,935,781.25) (13,269.23) 1,949,050.48 (58,732.73) 94.863 4.75% (237,158.20) (260.13) 237,418.33 (12,819.78) 98.701 5.19% (1,974,020.00) (24,437.50) 1,998,457.50 (40,223.58) 94.824 4.85% (948,242.19) (1,112.64) 949,354.83 (51,671.10) 94.801 4.95% (1,422,011.72) (1,777.13) 1,423,788.85 (77,860.29) 97.951 5.29% (1,959,020.00) (13,812.50) 1,972,832.50 (39,033.03) 97.574 4.92% (2,927,226.56) (8,241.76) 93.488 4.78% (2,337,207.03) (3,073.77) 2,935,468.32 (24,754.56) 2,340,280.80 (160,172.52) (18,632,436.01) (99,046.31) 18,731,482.32 (554,005.59) (18,632,436.01) (99,046.31) 18,731,482.32 (554,005.59) 43 49 IImportant Disclosures 2024 Chandler Asset Management, Inc, An Independent Registered Investment Adviser. As of March 31, 2024 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. 44 CM 50 Benchmark Disclosures As of March 31, 2024 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. Attachment 2 TRANSACTION LEDGER City of Dublin 1 Account #10198 1 As of March 31, 2024 CAN CHANDLER ASSET MANAGEMENT Transaction Type Settlement CUSIP Date Quantity Security Description Acq/Disp Price Yield Amount Interest Pur/Sold Total Amount Gain/Loss ACQUISITIONS Purchase Purchase Purchase Purchase Purchase Purchase Purchase Purchase Purchase Purchase Purchase Purchase Purchase Purchase Purchase Total Purchase 01/17/2024 36268GAD7 01/18/2024 91282CJR3 01/23/2024 756109BS2 01/24/2024 448988AD7 01/25/2024 91324PEU2 01/31/2024 161571HV9 01/31/2024 91282CJR3 02/15/2024 36269FAD8 02/20/2024 4581X0EN4 02/26/2024 17275RBR2 02/27/2024 89238GAD3 03/18/2024 91282CKD2 03/19/2024 47800RAD5 03/20/2024 448973AD9 03/28/2024 91282CKD2 445,000.00 GMCAR 2024-1 A3 4.85 12/18/2028 3,000,000.00 UNITED STATES TREASURY3.75 12/31/2028 1,000,000.00 REALTY INCOME CORP 4.7 12/15/2028 785,000.00 HALST 24A A3 5.02 03/15/2027 1,000,000.00 UNITEDHEALTH GROUP INC 98.402 4.25 01/15/2029 1,910,000.00 CHAIT 241 A 4.6 01/16/2029 2,500,000.00 UNITED STATES TREASURY3.75 12/31/2028 995,000.00 GMALT 2024-1 A3 5.09 03/22/2027 3,000,000.00 INTER -AM E RICAN DEVELOPMENT BANK 4.125 02/15/2029 1,565,000.00 1,000,000.00 3,000,000.00 550,000.00 1,170,000.00 CISCO SYSTEMS INC 4.85 02/26/2029 TLOT 2024-A A3 5.25 04/20/2027 UNITED STATES TREASURY 4.25 02/28/2029 J DOT 2024 A3 4.96 11/15/2028 HART 2024-A A3 4.99 02/15/2029 4,000,000.00 UNITED STATES TREASURY 4.25 02/28/2029 25,920,000.00 99.980 4.91% 98.785 4.02% 2,963,554.69 (5,563.19) (2,969,117.88) 99.426 4.83% 99.981 444,910.51 0.00 (444,910.51) 994,260.00 (4,961.11) (999,221.11) 784,851.24 0.00 (784,851.24) 984,020.00 (1,180.55) (985,200.55) 99.985 1,909,709.11 0.00 (1,909,709.11) 98.992 3.98% 2,474,804.69 (7,984.20) (2,482,788.89) 99.988 5.15% 994,875.63 0.00 (994,875.63) 99.023 4.34% 2,970,690.00 (6,875.00) (2,977,565.00) 99.965 4.86% 1,564,452.25 99.996 999,957.80 0.00 (1,564,452.25) 0.00 (999,957.80) 99.633 4.33% 2,988,984.38 (6,236.41) (2,995,220.79) 99.994 5.01% 99.978 5.05% 549,969.20 1,169,742.02 0.00 (549,969.20) 0.00 (1,169,742.02) 100.305 4.18% 4,012,187.50 (12,934.78) (4,025,122.28) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 25,806,969.02 (45,735.24) (25,852,704.26) 0.00 42 52 TRANSACTION LEDGER City of Dublin 1 Account #10198 1 As of March 31, 2024 CAN CHANDLER ASSET MANAGEMENT Transaction Type Settlement CUSIP Date Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/Sold Total Amount Gain/Loss TOTAL ACQUISITIONS 25,920,000.00 DISPOSITIONS Sale 01/18/2024 91282CDZ1 (1,500,000.00) Sale 01/22/2024 3133EKWV4 (2,500,000.00) Sale 01/25/2024 023135BW5 Sale 01/31/2024 91282CED9 Sale 02/09/2024 912828ZL7 Sale 02/16/2024 3130A2UW4 Sale 02/16/2024 912828ZL7 Sale 02/23/2024 912828ZL7 Sale 03/18/2024 3135G0W66 Sale 03/18/2024 91282CFE6 Sale 03/28/2024 91282CAM3 Total Sale TOTAL DISPOSITIONS (1,000,000.00) (2,000,000.00) (250,000.00) (2,000,000.00) (1,000,000.00) (1,500,000.00) (2,000,000.00) (3,000,000.00) (2,500,000.00) (19,250,000.00) (19,250,000.00) UNITED STATES TREASURY 1.5 02/15/2025 FEDERAL FARM CREDIT BANKS FUNDING CORP 1.85 07/26/2024 AMAZON.COM INC 0.45 05/12/2024 UNITED STATES TREASURY 1.75 03/15/2025 UNITED STATES TREASURY 0.375 04/30/2025 FEDERAL HOME LOAN BANKS 2.875 09/13/2024 UNITED STATES TREASURY 0.375 04/30/2025 UNITED STATES TREASURY 0.375 04/30/2025 FEDERAL NATIONAL MORTGAGE ASSOCIATION 1.625 10/15/2024 UNITED STATES TREASURY 3.125 08/15/2025 UNITED STATES TREASURY 0.25 09/30/2025 25,806,969.02 (45,735.24) (25,852,704.26) 96.586 4.79% (1,448,789.06) (9,538.04) 98.306 5.25% (2,457,650.00) (22,611.11) 0.00 1,458,327.10 (29,378.44) 2,480,261.11 (44,833.43) 98.533 5.46% (985,330.00) (912.50) 986,242.50 (14,526.13) 96.789 4.72% (1,935,781.25) (13,269.23) 1,949,050.48 (58,732.73) 94.863 4.75% (237,158.20) (260.13) 237,418.33 (12,819.78) 98.701 5.19% (1,974,020.00) (24,437.50) 1,998,457.50 (40,223.58) 94.824 4.85% (948,242.19) (1,112.64) 949,354.83 (51,671.10) 94.801 4.95% (1,422,011.72) (1,777.13) 1,423,788.85 (77,860.29) 97.951 5.29% (1,959,020.00) (13,812.50) 1,972,832.50 (39,033.03) 97.574 4.92% (2,927,226.56) (8,241.76) 93.488 4.78% (2,337,207.03) (3,073.77) 2,935,468.32 (24,754.56) 2,340,280.80 (160,172.52) (18,632,436.01) (99,046.31) 18,731,482.32 (554,005.59) (18,632,436.01) (99,046.31) 18,731,482.32 (554,005.59) 43 53