Loading...
Clearwater AnalyticsCity of La Quinta, California RFP — Investment Reporting and Analytics Software Clearwater Analytics Responses er Letter Clearwater Analytics appreciates the opportunity to submit our response to your RFP in regard to your investment reporting and analytics software for the City of La Quinta. Our firm's main office is located in Boise, ID and this is where your client servicing team will be, once you are live on the Clearwater platform. For the implementation part of the project, that team sits out of our India office in New Delhi. Below we've included information on the firm's background, qualifications, and experience: a) Clearwater Analytics, LLC, registered in Delaware as a limited liability company b) Clearwater Analytics Hildings, Inc. is the parent company c) EIN:421658172 d) Clearwater has been in business since 2004 (20 years) e) Key Personnel: a. Name/Title: Shivani Rustagi, Division Lead of Global Delivery i. Background: She has been at Clearwater over 4 years leading implementations and sits out of our India office in New Delhi. ii. Responsibilities: She has been onboarding clients since she began at Clearwater and empowers her team of project managers, data migration specialist, investment reporting analyst, and subject matter experts to implement Clearwater's integrated solution for our government clients. She will assign a project manager once a contract is executed. b. Name/Title: David Mihu, Client Servicing Team Lead i. Background: He has been with Clearwater for 2 years and sits out of our Boise, ID headquarters. ii. Responsibilities: He has the ultimate responsibility for client delight and the relationship. He leads the client services team which handles the day-to-day inquiries, consisting of both Service Delivery Managers and Analyst. His client focus is on our State and local governments, foundations, endowments, pensions, education, and our custody partners. c. Name/Title: Jordan Johnson, Service Delivery Manager i. Background: He has been at Clearwater for 5+ years and sits out of our Boise, ID headquarters. ii. Responsibilities: He would be one of the people responsible for supporting your team once you are live on the platform. This would be your day-to-day contact to answer all questions and provide training d. Name/Title: Amanda Cowles i. Background: She has been at Clearwater 10+ years and sits out of our Boise, ID headquarters ii. Responsibilities: She would be one of the people responsible for supporting your team once you are live on the platform. This would be your day-to-day contact to answer all questions and provide training Clearwater Analytics was founded in 2004 and has been providing an integrated web - based investment accounting, portfolio reporting, and analytics for institutional investors for over 18 years. We currently report on over $5.0 trillion in assets spread among governments, corporations, insurance, and asset manager clients. Our SaaS product is used by clients globally to account for their investment portfolios, daily monitoring of investment policy compliance, daily portfolio performance and risk analytics, and collaborate using powerful reporting capabilities. In 2012, Clearwater launched a reporting solution in the government market. Since that time, Clearwater has become one of the largest government reporting providers in the market. More than 250 public -sector entities have converted to Clearwater from other providers like Sympro, FIS/Sungard, and Broadridge, as their provider of multi -basis accounting and portfolio analytics. Clearwater expects its business in the public sector to increase substantially in the foreseeable future. Clearwater currently has over 1,500 employees, with over half of them dedicated to software development, and the other half dedicated to client success/service, sales, marketing, and other various positions. Clearwater is headquartered in Boise, ID with offices in New York, Washington D.C., Seattle, San Jose, Edinburgh (UK), London (UK), Paris (France), Frankfurt (Germany), Singapore, and Noida (India). To date, Clearwater has roughly between 250 and 300 public sector clients with over $400 billion in AUM. Clearwater adds over 100 new clients per year and serves all sizes of organizations within the public sector segment. Clearwater's largest public sector client has approximately $27 billion in assets while the smallest client on the system has under $5 million in assets. For example, our clients includes states, counties, cities, and authorities like the City of Escondido, Government of Washington D.C., City of Chicago, City of Atlanta, City of Albuquerque, Palm Beach County (FL), Chatham County (GA), Los Angeles County Metropolitan Transportation Authority, and San Mateo County Transit District. All information included in this RFP, along with the pricing provided is valid for at least ninety (90) days, and all those individuals who will perform work for the City is free of any conflict of interest. Name of Signature: Alec Ward Signature: Date: 3/27/2024 Address: 777 W. Main St. Ste 900, Boise, ID 83702 Phone Number: 208.304.8717 Email Address: award@clearwateranalytics.com )e of Services Minimum reauirements of the investment management software solution are as follows: a) Correctly Report of all security types as permitted under California Government Code §53601 At Clearwater, we provide a comprehensive investment portfolio reporting analytics and have the capability to report on all security types as approved by California Government Code §53601. b) Produce a suite of reports necessary for monthly and/or quarterly reporting to the Financial Advisory Commission and the City Council. Reports should include, at a minimum, the following: security issuer; purchase date, maturity date, original cost/book value, PAR value, market value, and yield of each investment; portfolio weighted average yield and maturity, portfolio total return; and portfolio total earnings. Please specify if reports are customizable and if there are illustrative tables, charts or graphs included. Provide samples of such reports as part of the submittal. Yes, we at Clearwater provide a suite of customizable reports. Our reporting architecture allows users to customize dashboards and reports to view their data in their preferred way. Users can easily configure custom reports by dragging and dropping columns or right -clicking to add or remove columns. The system allows for creating charts, graphs, and customized dashboards, as well as subtotaling and grouping data. Custom reports can be saved and shared with other users. The web portal offers various customizable options such as adding and removing columns, drill down capability, sorting data, adding filters, and more. Reports can be exported to PDF and Excel, and there is also ability to configure PDF reports. Clearwater's investment accounting and reporting capabilities begin with its ability to aggregate and reconcile investment data for its clients daily. No matter where your assets are held, Clearwater aggregates all your investment data from your investment managers, custody banks, and state depository institutions. Clearwater supplements custody data by aggregating security master characteristics like credit ratings, pricing, factors, etc., from 60+ third -party data vendors and automatically integrates them into a robust, reconciled security master file that is updated daily. This allows Clearwater to virtually recreate its clients' global investment portfolios daily and independently calculate and predict accounting variables and investment metrics. Upon aggregating investment data, Clearwater automatically checks it for accuracy and reconciles the information back to your custodians and other data sources. While most other solutions stop at basic cash and position reconciliation, Clearwater takes reconciliation to a whole new level by automatically performing numerous, detailed reconciliations and checks every day to ensure the accuracy of its clients' portfolios. Please see attachment 5, called "Attachment 5 — City of La Quinta Statement Package. This is a sample of reports that you can put together inside Clearwater. This one we've downloaded into Excel, but you can also download into PDF. A statement package can be made up of any canned or configured report you've created, along with dashboards of charts and graphs. This is just one example as there are many different ways to create reports that would be meaningful for your Financial Advisory Commissions and/or City Council. c) Calculate interest accruals, premium and discount amortization as needed, interest revenue received for a specified period and revenue projections for specified period (inclusive of interest as well as maturities). At Clearwater Analytics, we have the capability to calculate interest accruals, premium and discount amortization, and interest revenue received for a specified period. We provide both straight-line and constant yield amortization for our users, using a combination of static system settings and client -defined accounting assumptions. Our Income Detail report displays each component of net income at the tax lot level, including Interest Income, Amortization/Accretion, and Realized Gain/Loss. In terms of revenue projections, our system can estimate future cash projections using both cash flow and income forecasting reports, projecting up to 5 years into the future. d) Ability to export reporting in formats readable by Microsoft Excel, text files, csv, and/or portable document formats Yes. We provide all users customizable report building capabilities on an ad -hoc basis. All reports can be downloaded in CSV, PDF, and Excel format. e) Ability to import reporting from custodial bank to include market pricing and/or interest received. Clearwater's investment accounting and reporting solution is unlike any other system in the market. While there are other investment accounting and reporting competitors, no other system provides the level of automation, transparency, and insight provided by Clearwater's processes and functionality. Our system is simply the best in class. Clearwater's solution and services stand out from the competition for numerous reasons: Data Aggregation: Clearwater is the only investment accounting system that utilizes data feeds to automatically pull transactions, positions, cash, and pricing from custodian banks. This process is a huge differentiator. Other investment systems on the market lack a similar ability to interact with the custodian/trustee. This results in public sector organizations inputting data manually for every trade, factor change, interest payment, etc. Clearwater is also the only accounting system that aggregates information from third -party data providers to allow clients to easily view investment analytics (yield, duration, convexity, WAL, etc.) side -by -side with their accounting information (book values, unrealized gains/losses, etc.). Data Reconciliation and Validation: Clearwater is the only investment accounting system that marries data received from the custodian with data received from third parties, and then validates all activity to ensure it is accurate and up to date. Prior to Clearwater, this process is typically something an organization must do manually daily, weekly, or monthly. f) Specify if software has market pricing functionality built-in, and include source of pricing, frequency of pricing updates, and whether or not the market pricing function has additional software, system, or service subscription requirements. At Clearwater, our software has built-in market pricing functionality. We are pulling in and updating market pricing on a daily basis and allow our clients to determine a market price hierarchy to follow. We will pull in custodian pricing and refinitive pricing and clients make the election which they'd prefer us to use with the hierarchy structure. There is no additional software, system, or service subscription required and is included in the service. With our reports being easily configurable, you can add both all market values provided into any report. Describe the software, it's platform and/or its delivery: a) Is software desktop/local or cloud -based? Our software is cloud -based. This model allows for secure data storage, efficient updates, and accessibility from anywhere with an internet connection. b) How frequently is the software updated? We update our software on a monthly basis. This includes system updates, new functionality and reporting, continual security upgrades, and new data points. We also release minor/bug fixes as needed. This is done at no additional cost to the City of La Quinta. c) Describe the technology or system requirements including servers/memory/storage if applicable. Clearwater offers a software -as -a -service (SaaS) application, provided entirely within a web browser. We do not provide any cloud infrastructure or platform services (laaS, PaaS). Users can connect to Clearwater's SaaS website using a compatible web browser and a broadband internet connection. Clearwater supports Firefox, Chrome, Safari, Edge and Internet Explorer 11. No additional browser plugins or extensions are necessary for connection. Data import and export into and out of our service is also possible via SFTP file transfer; this method is typically used as part of our back -office solution for integrating with other client applications (data warehouses, accounting applications, etc.) cloud-based/hosted, please list how many times over the past two years the system was _navailable to clients. Describe the back-up systems in place, including disaster recovery or business continuity plans. Describe all security measures and disclose any hosting partners if applicable. Clearwater utilizes AWS as our cloud service provider. Clearwater uses AWS US-West-2 region for primary and AWS US-East-2 as the backup for replicated database. Clearwater's historical service availability or up -time can be found at Clearwater Analytics Status (https://status.clearwateranalytics.com/). Scheduled maintenance takes place on Saturdays from 7 a.m. - 2 p.m. MST. Most often, downtime is not necessary during maintenance - if downtime is necessary, we will post a message in advance on our status website at Clearwater Analytics Status (https://status.clearwateranalytics.com/) . Clearwater performs comprehensive backups of our systems and data to ensure that we can restore our service to a working state as quickly as possible if an outage, loss of hardware or disaster event occurs, per our recovery objectives documented within our business continuity policy. This includes database replication, daily backups of production databases, redundant copies of backups sent to multiple Clearwater locations, and state -managed systems that can be restored quickly based on pre -defined configurations. Clearwater maintains a business continuity policy and disaster recovery response processes focused on our technology and personnel. We utilize AWS data centers to supply full failover redundancy for production and utilize a remote workflow for our employees to continue operations in circumstances with office unavailability. Disaster recovery tests are performed at least annually. e) Does this software assist with accounting journal entries or reconciliations? Yes, to both journal entries and reconciliations. As state previously data reconciliation and validation is performed on a daily basis through our proprietary technology. Clearwater is the only investment accounting system that marries data received from the custodian with data received from third parties, and then validates all activity to ensure it is accurate and up to date. If an error should be found, your client servicing team will get that fixed for you on your behalf, so when you do log into the platform, you have clean data to work with. Your client servicing team will also provide unlimited training and support, this is all included in the service. For your accounting journal entries, general ledger account codes are input, and journal entries are constructed based upon client need, which dramatically streamlines the period -end reporting process and provides a smooth tie -out process and control structure. General ledger entry files provided by Clearwater produce client -defined journal entries with general ledger account codes and other detail, making the report compatible with the client's ledger system. These features allow entry files to be easily tied out and imported into the client's ledger system each period -end. Clearwater offers for comprehensive accounting entries generation including, but not limited to, entries for purchases, sales, maturities, income, expense, amortization, accretion, realized and unrealized gains/losses, and more. We also provide entries for more complex scenarios such as impairment analysis, credit loss reporting, and hedge accounting. Each of these entries comes with detailed information to support comprehensive audit trail requirements. All entries are updated daily, ensuring accounting records are always accurate. f) Does the software include audit trail functionality? Yes, our software does include audit trail functionality. The system has comprehensive audit trail capabilities, including tracking of users, date/time stamps, all transactions, and revisions. We log all user activity, such as report viewing, configuration saves, and IP addresses. g) Describe the historical date the software maintains. We maintain extensive historical data. We have never removed historical data from our clients. Clients that have been with us for 12+ years can still pull a full history of their accounts within reports. We store historical data in our internally maintained, secured databases. h) Provide an estimated implementation timeline and describe how existing data will be imported. An estimated timeline for an implementation for the City of La Quinta would fall anywhere from 6-8 months, depending on all the modules you select that are needed. Here is a breakdown of the implementation process: Clearwater's implementations are designed to make the process easy for you. We take on the heavy lifting and work with your team every step of the way. Clearwater is responsible for performing the implementation and does not expect the client to be involved in reconciliation or troubleshooting. The transition process is comprised of four main stages: 1. Initial Deliverables: In this stage, Clearwater outlines the necessary information that your team will need to provide and works with you to obtain it in the most efficient manner possible. All clients are assigned an implementation team who will obtain a list of all individuals authorized to administer account settings and user access. You will select account names, accounting assumptions, and user entitlements, and provide Clearwater with authorization to access your custodian accounts. To provide accurate accounting, Clearwater also requests original cost and book value data from clients. Clearwater will work with you, custodians, and asset managers to obtain this data. The final step in the client setup stage is for Clearwater and you to review the investment compliance policy to ensure appropriate rules are set in the Clearwater system (if you elect the compliance module). All implementation work performed beyond this point will be carried out by Clearwater. 2. System Setup: Clearwater handles all the work in this step. In fact, your team can go back to business as usual while Clearwater gets all your portfolios and data set up in the background. Clearwater will come back to you once we have data successfully loaded and parallels prepared to review with you. 3. System Review and Training: During this stage, Clearwater performs Roll Forwards and accounting parallels. Clearwater also issues User Entitlements to authorized users and begins system training for these users, ensuring your team is fully comfortable navigating Clearwater's platform to hit the ground running from day one. Trainings are typically performed via the web and onsite training at your location. The Clearwater product permits trainings to utilize real data in a live environment, thereby educating users with the data they will actually use and alleviating any need for a separate training environment. In addition to real time training, you will receive access to the Client Portal, which contains numerous resources including prerecorded videos, user guides, and other training content. 4. Account Transition and Parallel Processing: At this point, Clearwater (using the Clearwater system) and you (using your current investment portfolio accounting system) will perform a parallel close, each separately closing a month of fiscal numbers. Clearwater and your team will then collaborate to compare the month through a balance sheet and tax lot comparison, with the purpose of analyzing errors and differences. The parallel close not only demonstrates the ease of use and effectiveness of the system but acts as a pivotal training mechanism for users. Clearwater will also transition you to a client servicing accounts team during this stage. You will be transitioned to one of Clearwater's Public Sector Operations Managers who oversees the dedicated Government Account Manager. The Government Account Manager will maintain the accounts, as well as continue to provide ongoing training as requested and as needed at no additional cost to you. There are several key differences that set Clearwater's implementations apart from our competitors'. First, your involvement will be limited to providing data, reviewing parallels, and approving the chart of accounts. All other transition work will be performed by Clearwater, allowing you to focus on the other important aspects of running your business. Clearwater uses a single sourced security master file for all clients, which eliminates a large portion of the traditional accounting risks faced during implementation. By contrast, other providers manually create the security master file for each client. This is a method that often requires corrections throughout the implementation process and runs the inherent risk of introducing human errors. Further, conversion to and training on the Clearwater system is free, and ongoing training is always available at no additional cost. Clearwater will work with you via web trainings and in -person meetings at your request. You will also receive access to the Client Portal, which contains numerous resources including prerecorded videos, user guides, and other training content. One final element that distinguishes Clearwater from its competitors is the system's ability to process and reconcile on -going transactions simultaneously while loading the accounting values. In other words, other systems require users to load values and sign off on that month's balances prior to moving on to the next month (e.g., users have to lock down December 31 data before moving on to January data). The Clearwater system will load all data at once. You will then have the option to lock down values at your discretion, which will save a significant amount of time during the implementation process. We are happy to provide a sample transition timeline upon request. In general, there are four main aspects of the implementation where resources would be required by the City of La Quinta: Data Connections: A team member familiar with the accounts and the various data sources (custodian, OMS, etc.) to provide custody information and deliver custody connection request letters. Accounting: A member from the accounting team with access to the previous accounting software to pull balance sheet info (lot -level), activities, trial balances, general ledger chart of accounts, etc. Compliance (if elected): A person familiar with the investment policies to provide documentation and can review completed policies on Clearwater. Performance (if elected): A person familiar with historical performance returns to supply Clearwater with "Since Inception" returns per portfolio if desired. Additional info may be required, such as assigned index benchmarks per portfolio or group of portfolios. Clearwater will host a weekly implementation call and all members actively involved should attend the 30-to-60- minute call. It is most beneficial to have one person among all the firm's resources to take the lead as the project manager to assist with coordination and follow-through. These are not strict rules for a Clearwater implementation, but rather best practices that we've refined over the years. Please review the implementation overview below. Implementation Overview Data Establish Integrations lot -level data Parallel load Testing Reconcile differences between Clearwater and current system Execute Contract 1 IImplementation Kick -Off The following is a list of high-level milestones in a client's Agile implementation, including estimated team workloads for eaclportion. Initial Client Deliverables > Send out custody access letters > Provide account list > Determine accounting assumptions R Operations Team 20% 80% _ Custody/Broker Connections > Custodians > Brokers > Manual feeds > Normalize incoming files > Map accounts to feeds > Test and verify ISData Connections Team Lot -Level Data Load > Review format for lot -level data > Run checks on provided lot -level data > Load data > Reconcile back to the custodian/ cost file 0 o Data Migration Team Reconcile Accounting Platforms > Reconcile differences between Clearwater and client's current system > Client reviews differences > Client sigrroff 0 o Data Migration Team User Training Go Live User Access / Configuration > Client to provide user list > Create user training plan > Build out user templates > Multi -basis accounting > Footnotes/disclosures > Board reporting > Compliance ,4.OMQ o o Operations/Data Migration Team _ CW Resources Client Resources i) List resources provided for customer service, technical support, and training, including business hours available and average response time for technology -related inquiries. Clearwater offers a unique client servicing approach. Our team becomes an extension of our clients' teams, and clients have direct access to their service delivery managers and analysts to provide dedicated servicing unlike any other provider in the field. We work hand -in -hand with our clients to provide data accuracy and reconciliation exceptions, ad - hoc request for reporting or system support, and ongoing training and support. The team is mentioned in the cover letter. You have direct access to your client servicing team via email or phone. Average response time is typically within the hour and resolution is typically within 24 hours. They will be available from 7am MST to 5pm MST. Clearwater maintains a comprehensive knowledge base and documentation repository that includes user guides, FAQs, troubleshooting tips, and best practices via the website. This ensures tat clients have access to relevant and up-to-date information to address common issues and maximize the utilization of the software. Clearwater offers post go -live training and education sessions to help clients optimize their usage of the software and address any questions or areas of improvement. These sessions can be tailored to meet the specific needs and requirements of the client and provide an opportunity for users to gain confidence and proficiency in utilizing the implemented software. Clearwater hosts focus groups, user groups, round tables, webinars, and annual user conferences to foster a collaborative client community. Ad -hoc user groups are created formally and informally across the Clearwater network. In many cases, Clearwater will provide contact information of peers utilizing our system for clients to discuss market issues, the Clearwater platform, or other non -Clearwater related matters. These events and groups offer a platform for users to share experiences, learn best practices, and provide feedback to help shape the future of Clearwater's solution. This commitment to ongoing dialogue and collaboration ensures that Clearwater's offerings remain responsive to user needs and aligned with industry trends. ernment Agencies (preferably cities/preferably located in California) references a) Number of clients using the software, and how many are government agencies. Clearwater has around 1300 clients and with government agencies we have around 70 direct clients. We also partner with many investment managers such as Chandler, GPA, PTA, Hilltop Securities, Meeder, and through those partnerships we work indirectly with around 200 government entities. This brings our total government clients to 250-300 today both direct and indirect. b) References: a. Reference 1: i. Client Name: San Mateo County Transit District, CA ii. Contact Person: Connie Mobley -Ritter— Director, Treasurer iii. Telephone Number: 650.508.7765 iv. Email Address: mobley-ritterc@samtrans.com b. Reference 2: i. Client Name: City of Escondido, CA ii. Contact Person: Douglas Shultz — City Treasurer iii. Telephone Number: 760.839.4619 iv. Email Address: dshultz@escondido.org c) How long have you done business with this client? San Mateo County Transit District, CA, we've done business for 6+years City of Escondido, CA, we've done business with for 1+ years d) Provide a summary of implementation process with this client For both clients, their process of implementation went as described in the scope of work section detailing the implementation process. It is our standard process. lete Pricing List of Fee schedule Clearwater is able to provide different packages based on client needs. With all of our packages, our services include daily aggregation, reconciliation, and validation of all investment data. We build and maintain hundreds of connections to custodians and data vendors. This provides a centralized system for back -off and security master data. Clearwater reconciles cash, positions, and transactions between various sources. The City of La Quinta will have a Client Servicing team dedicated to enriching and standardizing security master data for various asset classes, including accounting and performance verifications. These processes feed Clearwater's multi -asset class investment accounting and performance system which produces accruals, book values, market values, and other accounting data needed to drive both the daily trading cycle, as well as the other reporting and analysis functions. Based on your RFP, we believe that either our Core or Base Package would be sufficient for the needs of the City of La Quinta, CA. The major difference is general ledger functionality. One thing to note, is we don't charge per user, if you have 3 folks that need access or 10 folks, the cost doesn't change. You can see a cost break-out of each package on the next page in the table. We have also provided our Order Form (See attachment 1 called "Attachment 1- Clearwater Order Form) for review. We have worked with many California government entities and found that working with Clearwater paper has made the legal process much easier. Our legal team will work to negotiate commercially reasonable terms. Services Offered Annual Cost Clearwater Core Package Base fee for all assets up to $250M $15,000 Breakpoint at $250M, 0.75 bps thereafter GAAP Accounting includes Business Day 4+ Lockdowns and T+1 EOD Recon (No G/L) GASB Reporting (31, 40, and 72) Basic Risk (Exposure and Cashflow Forecast) GDT for LGIPs in CW's Format (3 included in base fee) any additional LGIPs will be $500 annually Estimated Total Annual Cost $15,000 Clearwater Base Package Base fee for all assets up to $250M $18,000 Breakpoint at $250M, 0.75 bps thereafter GAAP Accounting includes G/L. Business Day 4+ Lockdowns and T+1 EOD Recon GASB Reporting (31, 40, and 72) Core Risk GDT for LGIPs in CW's Format (3 included in base fee) any additional LGIPs will be $500 annually Estimated Total Annual Cost $18,000 Implementation: Clearwater does not charge a separate implementation fee. Clearwater begins billing accruals the month following contract signature. We will work with you to establish a timeline for going live with dates of key implementation milestones. Client Servicing and Training: Clearwater does not charge additional fees for client servicing. You will receive direct access to an account management team that operates as an extension of your staff. Training, support, and proactive accounting guidance are unlimited. Clearwater also offers complimentary webinars, educational trainings, and an annual User Conference. All fees are subject to an annual fee increase of the greater of 5% or CPI-W S. List of Complementary Services Offered by Proposer along with Corresponding Prices Additional Add-ons Post Trade Compliance Monitoring $5,000 annually Performance Tracking $5,000 annually Income Forecasting Tool $7,500 annually Single Sign On (one-time fee) $5,000 one-time Direct Feed (BoS File) from Clearwater to Tyler Munis for month -end $10,000 setup cost (one-time) and $2,500 annually After reviewing your RFP, we have included a few additional items that may be valuable to City of La Quinta, but not required based on the scope of work. We are happy to review any of these that you'd like to consider and add them. ►. Staffing and Project Organization Below is our Statement of Work. This is also included in our Order Form (See attachment called "Attachment 1— Clearwater Order Form). This will give insight into staffing and project organization in great detail. Onboarding Statement of Work and Project Plan This Statement of Work ("SOW") is a part of the Order Form between Client and Clearwater. All capitalized terms not otherwise defined below will have the same meaning as in the Order Form. 1. GENERAL. This SOW details the onboarding services ("Onboarding Services") that Clearwater will perform for Client for the deployment of the SaaS Services ("Project"). If Client wishes to secure other onboarding services to deploy additional functionality not included in the scope of this SOW, change the roles and responsibilities typically included for the deployment of the SaaS Solution, change the timeline of deployment, or otherwise initiate additional efforts outside the scope of this SOW, Clearwater will provide a proposal for such onboarding services and develop a separate statement of work or Change Order subject to the Change Order Process set forth below. 2. PROJECT ROLES AND RESPONSIBILITIES 2.1. Clearwater Activities. The activities below will be performed as part of the Project: 2.1.1. Scope review and Client orientation; 2.1.2. Supporting Client's validation efforts; 2.1.3. Loading of Client data; 2.1.4. Client training; 2.1.5. Support Client's testing efforts. 2.2. Client Activities. Among other items, Client will perform the activities below as part of the Project: 2.2.1. Review scope; 2.2.2. Attend meetings and workshops as required; 2.2.3. Provide initial load data; 2.2.4. Help correspond with any necessary third parties, including serving as an issue escalation point to get third parties to work with Clearwater on integrations; 2.2.5. Help test, identify problems, and aid in issue resolution; 2.2.6. Sign off on the end of the onboarding. 2.3. Clearwater Roles. Clearwater roles and responsibilities in this SOW are described below. The extent of each Clearwater team member's involvement will vary by task. 2.3.1. Onboarding Manager. The Onboarding Manager manages the Project and is responsible for working directly with the Client Project Coordinator. The Onboarding Manager staffs the Project and directs Project activities based on a mutually agreed upon Project Plan developed pursuant to a Statement of Work. The Onboarding Manager is responsible for resolving Project -related issues that may be outside the direct control of the Project team. The Onboarding Manager provides overall Project status to key members of Clearwater's management team and Client. 2.3.2. Onboarding Team. The Onboarding Team completes the hands-on functional and technical Project activities and provide guidance to the Client. Throughout the Project, the Onboarding Team leads meetings to help the Client understand and use the features and functions of the SaaS Solution. The Onboarding Team works with the Client to build the integrations included within the SOW scope and provides support during confirmation and testing. 2.4. Client Roles. Client will assume responsibility for the roles below and tasks: 2.4.1. Executive Sponsor. The Executive Sponsor is responsible for championing the Project, ensuring that appropriate Client resources are available for the Project, working with the Project Coordinator to resolve escalated issues promptly and sign off on nkey deliverables throughout the Project. The Executive Sponsor must be an active and visible resource on the Project and is expected to participate as needed to ensure the Project is meeting the goals/objectives and timeframes outlined in the beginning of the Project. 2.4.2. Project Coordinator. The Project Coordinator performs various tasks including (1) understanding and signing off on the Project Plan, (2) assigning responsibilities, (3) setting mutually agreed upon deadlines and evaluating milestones, (4) managing the issue and key decision log, and (5) delivering status reports to Client senior management regularly. The Project Coordinator also escalates issues that may impact the go -live date. 2.4.3. Functional Lead. Functional Leads are responsible for identifying and providing necessary data to Clearwater and testing the business processes and configuration in the SaaS Solution. They are also responsible for providing functional knowledge and expertise on Client requirements such as business processes, data mapping, organizations, and system configurations. They also escalate to the Project Coordinator issues that may impact the go -live date. 3. ESTIMATED PROJECT TIMELINE. Based on the assumptions below, the time required to complete the Project is expected to start on the Onboarding Start Date and last for the Onboarding Period. 4. GENERAL ASSUMPTIONS. The fixed fees and timeline for this Project are based on both parties agreeing to the General Assumptions set forth below. If any of these assumptions are not met, Clearwater may (i) promptly advise Client in writing, (ii) use reasonable efforts to mitigate delays and additional costs or fees, and (iii) increase its fees to reflect the other services rendered because Client failed to meet the identified assumptions. 4.1. All of Clearwater's services set forth under this SOW will be provided remotely. 4.2. In the unlikely event that travel is required for the services to be performed on -site, Client will reimburse Clearwater for all reasonable and necessary travel and living expenses incurred by Clearwater in the performance of the services under this SOW in accordance with Clearwater's Travel and Expense Policy. Upon Client's written request, Clearwater will submit supporting expense documentation and copies of receipts to Client for expenses over Twenty -Five United States Dollars ($25). 4.3. Client and Clearwater will meet all dates set forth in the mutually agreed, written project plan ("Project Plan"). 4.4. Client will assign a Project Coordinator to manage Client resources and activities for this Project. 4.5. Clearwater will assign an Onboarding Manager to direct Clearwater resources and activities. 4.6. Client will staff the Project with its resources described in the Roles and Responsibilities section promptly. 4.7. Client and Clearwater will participate in all required Project activities. 4.8. Client will lead testing and sign off before the end of the onboarding. Clearwater will support issue resolution to Client's testing efforts. 4.9. If the Project is delayed by Client for any reason, Client understands that Clearwater's ability to staff the engagement and meet the target go -live date could be at risk. As a result, Clearwater reserves the right to revisit and revise the Project go -live date and estimated fees and costs. 4.10. Clearwater will conduct work on the Project during common business hours, excluding holidays observed Clearwater, including U.S. holidays. 4.11. Once the onboarding Project starts, additional integration or functional changes to scope will impact costs and the timeline. 5. TERMINATION/SUSPENSION. 5.1. Automatic Termination. Unless extended by mutual written agreement of the parties or earlier terminated as provided in this SOW or the Terms of Use this SOW automatically terminates upon completion of the Project. 5.2. Suspension by Clearwater. Clearwater may stop providing services to Client under this SOW without liability to Client, by giving Client 15 days' prior written notice in the event: (i) Client repeatedly fails, after receiving written notice and being given a commercially reasonable amount of time to cure in each instance, to perform its obligations under this SOW which results in the inability of Clearwater to meet its obligations and time frame commitments, and in such event Clearwater will have the right to remove any Clearwater personnel and assign them to other projects, and (ii) it is determined that the information provided by Client, or lack thereof, to Clearwater during the discovery stage is materially inaccurate or inadequate, the parties may agree to enter into a new mutually agreed upon statement of work. PROCESS. During a Project in a Statement of Work, new information may surface that may require a change in business requirements resulting in a change in Project scope and so changes in the estimated level of effort, Project timeline, or Service features. Such changes, and the associated fees for additional Services to be provided, will be described in a document (a "Change Order"). A completed Change Order includes the requested change, the impact on the current engagement under the applicable Statement of Work, and the estimated resources and time to complete the Services for the work described in the Change Order. Clearwater will submit the Change Order to Client for review and approval. Proposed Change Orders will remain valid for a period of ten business days from the date of submission. If Client does not approve the Change Order within the ten business days, and Clearwater has not extended the period of validity in writing, the proposed Change Order will automatically expire. Upon Clearwater's receipt of Client's written approval, Clearwater will begin performing the services described in the Change Order according to the agreed -upon schedule under the applicable Statement of Work as may be modified by the Change Order. 7. PROJECT RISKS. 7.1. Participation of Client subject matter experts is vital to the success of the Project. Client must identify individuals from each business unit who possesses the necessary business knowledge, process knowledge, and industry knowledge to participate on the Project team 7.2. Timely decision making is critical to the progress and ultimate success of the Project. When a decision cannot be made through consensus, the Project management team must escalate the decision through Clearwater's Onboarding Manager and Client's Executive Sponsor to avoid impacts to timeline and costs. 7.3. The timely participation of third parties (including, for example, custody safekeeping locations and asset managers) is required for the Project to be on -time and successful. 8. FIXED FEES AND INVOICING. 8.1. The Onboarding Fee will be identified in the Order Form and will be invoiced monthly in advance. Client must pay all invoices in accordance with the Terms of Use. 9. PROJECT DELAYS 9.1. The parties acknowledge and agree that the avoidance of Project delays is material to the Project success and Clearwater's ability to timely complete the Project. 9.2. Client Delay. In the event the Project is delayed because the Client failed to provide certain deliverables, meet material deadlines in the Project Plan, or any other similar reason, then the parties agree Clearwater has the right to bill $210/hour billed in hour increments for Clearwater resources necessary beyond the defined onboarding project. 10. ISSUE ESCALATION. Client's Project Manager and Clearwater's Onboarding Manager shall promptly resolve all issues, if necessary, by holding a meeting. Client's Project Manager is the escalation point for all Client resources assigned to the Project. Clearwater's Onboarding Manager is the escalation point for all Clearwater resources assigned to the Project. 11. PROJECT PLAN. This Project Plan is a current estimate as of the Effective Date of the Order Form and may be amended moving forward by the parties. Some steps below may run contemporaneously. STEP 1: CLIENT DATA GATHERING AND CONNECTION INSTRUCTIONS. During Step 1 of the Project Plan, Client will provide Clearwater with the following information to establish Client's SaaS Solution Accounts: o List of Accounts and other Information. Client must complete the Clearwater -provided template with account specific information to be built in the client hierarchy and account structure. The template will require information including account names and preferred benchmarks (to be selected out of Clearwater's then -current list of available benchmarks). o User Access. Client must complete the Clearwater -provided template with requested user access. Client must designate Client Account administrators, users, and must determine the appropriate user account access permissions. o Accounting Assumptions. Client must complete the Clearwater -provided template to manage account creation, including accounting assumptions. o Multi -Basis Lot Level Original Cost Data and Book Values and Prior Cost Basis Adjustments. If Client is an insurance company loading data back to the beginning of the then -current calendar year, then Client must provide its cost, cost basis, and book value of its accounts as of 12/31 of the previous year. If not, Clearwater and Client ee on a date following the successful completion of all safekeeping location connections for which Client must such information (e.g., if all connections are made as of March 31, the parties may provide the original cost and book value information for all its accounts as of April 1). o Investments Chart of Accounts and General Ledger Requirements. Client must provide Clearwater with general ledger information including its investments chart of accounts. In addition, Client must provide Clearwater with a trial balance report to display which GL codes are actively used. Clearwater will provide Client with information on what fields are required as part of this step. o Data Contract Confirmations: Some Supplemental Data Providers may require Client to have a direct contract with the Supplemental Data Provider to obtain certain Supplemental Data points on the SaaS Solution. To the extent Client already has the necessary Supplemental Data contracts, Client should provide Clearwater with its contact at the Supplemental Data Provider to permit Clearwater to confirm the existence of the contract with the Supplemental Data Provider. If Client does not have, and does not wish to obtain, the necessary Supplemental Data contracts, the parties will discuss alternative data options (including removing SaaS Solution access to the data point). o Custody/Safekeeping Access Letter. Client must instruct its safekeeping locations to provide Clearwater with access to its accounts. Following receipt of Client's list of accounts, Clearwater will generate a template custody access letter to aid in the process. Client must email the safekeeping location with a copy to Clearwater's account access team. o Custody/Safekeeping Issue Resolution. If a safekeeping location does not respond to Client's safekeeping access letter, or otherwise does not meaningfully participate in the safekeeping connection process, then Client is responsible for issue escalation and resolution. Clearwater will provide support in the process, as needed. o Custody/Safekeeping Data Feed Format: Clearwater expects that all Safekeeping Locations are able to facilitate a file transfer protocol ("FTP") with Clearwater to provide Client data. To the extent the Safekeeping Location is unwilling or unable to provide Clearwater with an FTP, then Client and Clearwater will discuss the impact on the Project Plan, including any fees and impact to the timeline. o Component or Service Specific Requirements. Clearwater will also provide Client with any other requirements specific to components or services. By way of example: o Single Sign -On. If Client subscribes to Clearwater's Single -Sign On, Client must provide Clearwater with its technical contact to help facilitate the development. o Data Point FTP. If Client subscribes to Clearwater's Data Point FTP, Client must define the data points that it desires to include in the feed (and the parties will confirm that Client has the appropriate data licenses to receive the feed, if applicable). STEP 2: CONNECTIVITY, ACCOUNT SET UP, AND USER CREATION. After Step 1 of the Project Plan, and during Step-2 of the Project Plan, Clearwater will do the following: o Connectivity. Once Client Safekeeping Locations have responded to Client's requests to release daily access to Client's accounts (including any period of issue escalation and resolution) and Step 1 is completed, Clearwater will work with the Client Safekeeping Location to complete the connectivity to the SaaS Solution o Account Set Up. Using the data provided by Client in Step 1. 1, Clearwater will set up the account structure on the SaaS Solution. o Create Users and Entitlements: Clearwater will verify the accuracy of the information provided by Client in Section 1.2 and provide Client administrators with user login credentials. STEP 3: DATA MIGRATION AND RECONCILIATION. After Step 2 of the Project Plan, and during Step 3 of the Project Plan, Clearwater will work to set up account and user connectivity as follows: o Data Migration. Following Client's provision of the information required in Section 1.4, Clearwater will input the original cost data, book values, and cost basis details into the Clearwater SaaS Solution and will reconcile those with the information provided by the Client's custodian. o Initial Reconciliation. Once the information is loaded in Section 3. 1, Clearwater will reconcile those amounts with custody amounts provided by the Safekeeping Location. STEP 4: REPORTING AND GENERAL LEDGER CONFIGURATION. During Step 4 of the Project Plan, the parties ing: Clearwater will train the Client to configure and create reports using Clearwater's flexible report writer. o GL Configuration. Clearwater and Client will work collaboratively to configure the Client's general ledger and review the chart of accounts to determine appropriate mappings on the SaaS Solution. STEP 5: COMPLIANCE SET-UP. During Step 5 of the Project Plan, Client and Clearwater will set up the Compliance Module: o Investment Policies. Client will provide Clearwater with the investment policies for Clearwater to create corresponding compliance rules in the SaaS Solution. o Compliance Module Review and Interpretation into Matrix. Clearwater will work with Client to configure rules based on its investment policies into SaaS Solution to monitor compliance rules. This process includes the following: o Rule creation, in which Clearwater will configure the rules based on Client's investment policies and Clearwater's available rules into the SaaS Solution; and o Compliance Module Rule review and confirmation, in which Clearwater will review the compliance rule results generated by SaaS Solution and confirm with Client that the results are accurate. STEP 6: USER TRAINING. During Step 6 of the Project Plan, Clearwater will provide all necessary and reasonably requested trainings. Clearwater will provide Client with access to available documentation (including user guides, video tutorials, etc.) describing the functional and operational characteristics of the SaaS Solution. The training may include, for example, reconciliation, the error -reporting process, navigation and functionality, report creation, and other module -specific training as requested. STEP 7: PARALLEL PROCESSING AND UAT TESTING. During Step 7 of the Project Plan, Clearwater and Client will conduct the following parallel and UAT testing. o UAT Testing. In coordination with Clearwater, Client will conduct the following User Acceptance Testing steps: o UAT Definitions. Client must define the critical User Acceptance Test (UAT) items in a written plan. o UAT Testing. Client will perform the identified in the prior step, with Clearwater providing any reasonably requested assistance. o Correction. Clearwater will work to solve or correct any issues identified by the UAT testing. o UAT Sign -Off. Client provides sign -off on all UAT items. o Parallel. Clearwater and Client will conduct the following parallel processes (as applicable): o Accounting Parallel Process: Clearwater will conduct an accounting parallel of Client's financials for a mutually agreed period. This parallel will include a review of the trial balance and general ledger activity generated by Clearwater in comparison to Client's current system, as well as a comparison of portfolio holdings between systems as of a date certain. The parallel will also review transactional and income activity over that period in comparison between the two systems. o Performance Parallel Process. Clearwater will conduct a performance parallel of Client's returns for a mutually agreed upon period. This parallel will include a review of security, composite and group returns generated by Clearwater in comparison to Client's current system. PROJECT COMPLETION. Following completion of each of the foregoing steps, Client will be onboarded on the SaaS Solution and the Project will be complete. contracting Services a) Subcontracting any portion(s) of the Scope of Services is not preferable; however, if a proposer can demonstrate to the City's satisfaction that is in the best interest of the project to permit a portion of the service(s) to be subcontracted by the proposer, it may be considered. Provide details on the role of any subcontractor that will be used. Assignment is prohibited Not Applicable 8. Disclosures a) Disclosure of any alleged significant prior or ongoing agreement failure, any civil or criminal litigation or investigation pending, which involved the proposer or in which the proposer has been judged guilty or liable within the last five (5) years. If there is no information to disclose, proposer must affirmatively state there is no negative history. There is no negative history to disclose of any alleged significant prior or ongoing agreement failure, any civil or criminal litigation or investigation pending, which involved the proposer or in which the proposer has been judged guilty or liable within the last five (5) years. 9. Acknowledgement of Insurance Requirements (Attachment 2) a) Clearwater works with many other government entities in California and if we are your selected vendor of choice, we will negotiate commercially reasonable insurance and indemnification obligations, but we can't agree as is. b) We've noted this on the insurance requirements acknowledgement form, please see "Attachment 2 — Insurance Requirements Acknowledgement) c) Below is the insurance we agree to keep during the term of the contract. It is titled as Schedule 10.3.1— Insurance. SCHEDULE 10.3.1 INSURANCE 1. Commercial Automobile Liability. Insurance covering liability arising out of the ownership, maintenance or use of all owned, non -owned, and hired autos with limits of no less than One Million Dollars ($1,000,000), or the equivalent thereof in local currency, per accident for bodily injury and property damage liability to third parties. 2. Commercial General Liability. Providing coverage for liability for bodily injury or property damage to third parties arising out of Services or Clearwater's activities hereunder, including coverage for Premises and Operations, Personal/Advertising Injury, Contractual Liability, and Products/Completed Operations, with limits of no less than Two Million US Dollars ($2,000,000) per occurrence. 3. Worker's Compensation/Employer's Liability Insurance. Providing coverage to all Clearwater Personnel and its subcontractors for injuries or death arising out of or within the scope of their employment by Clearwater whether full or part-time or under contract. Workers Compensation insurance shall comply with statutory requirements as mandated under applicable workers' compensation laws, federal body or country having jurisdiction over the location of the project or operation. Employers Liability insurance shall have limits of not less than One Million US Dollars ($1,000,000) per accident, One Million US Dollars ($1,000,000) per employee by disease and One Million US Dollars ($1,000,000) aggregate by disease or the equivalent thereof in local currency. 4. Umbrella Liability (Excess Liability). Providing coverage excess of the insurance required above with limits of no less than $10,000,000 per occurrence and $10,000,000 in the aggregate or equivalent thereof in local currency. Clearwater may structure the insurance coverage required above in any manner that allows it to reach the total limits of the coverage as required herein. 5. Cybersecurity/Technology E&O. Providing coverage for claims for loss or damage resulting from errors or omissions made while rendering the Services required pursuant to this Agreement including, without limitation, coverage for unauthorized computer access or use, Internet liability, failure to protect privacy, virus transmission and denial of service, with limits of no less than $10,000,000 each claim and $8,000,000 in the aggregate or the equivalent in local currency. 6. Employee Dishonesty/Commercial Crime. Insurance providing coverage for employee dishonesty, loss of money and securities, computer fraud and depositor's forgery with limits of not less than One Million US Dollars ($1,000,000) per loss, naming Client as loss payee. Non -Collusion Affidavit (Attachment 3 a) Clearwater has executed the non -collusion affidavit form, please see at attachment 3 called "Attachment 3 — Non -Collusion Affidavit Form". 11. Acknowledgement of Addenda (Attachment 4) a) Clearwater has received the 1 addenda, please see attachment 4 title "Attachment 4 - Acknowledgement of Addenda". CLEAR1,NATER A N A L Y T I C S ORDER FORM 777 W. Main St., Suite 900 Boise, Idaho 83702 Phone:208-918-2400 Client Information CompanyQuinta, CA OrganizationState or Country of Type of Entity Notice Information ,- Email for Notices LInvoice Information (Client may change the email address at any time by giving notice to Clearwater's Accounts Receivable Department) Annual Base Fee Breakpoint PMV rbasis oint Fee Above the Breakpoint $18,000 $250M 0.750s Pricing Good Until jj June 27, 2024 LOrder FormDefinitions Annual Base Fee The annual amount client will pay during a contract year for assets up to the Breakpoint PMV. Basis Point Fee Above The basis point rate applicable to Client's PMV above the Breakpoint PMV. A basis point is equal to 1/100' of 1%. The the Breakpoint basis point fee is calculated by (i) multiplying the applicable basis point rate by the Client's PMV above the applicable Breakpoint PMV and then (ii) multiplying the result by the number of days in the applicable month divided by 365. Until Client's Data is loaded and Clearwater has reconciled Portfolio Market Values, Clearwater cannot invoice the Basis Point Fees Above the Breakpoint. As soon as Clearwater has reconciled Portfolio Market Values, Clearwater will calculate and invoice the Basis Point Fees Above the Breakpoint, if applicable, back to the earliest date of Client Data loaded on the SaaS Solution. Basis Point Fees, if any, are invoiced monthly in arrears. Breakpoint PMV The amount of Client's PMV covered by the Annual Base Fee. Fee Start Date Fees apply beginning on the Effective Date. Initial Tenn 12 months Invoicing The Annual Base Fee is invoiced annually in advance. Basis point fees if anare invoiced monthly in arrears. Portfolio Market The Client's Portfolio Market Value ("PMV") is the average daily absolute value (calculated at the tax -lot level) of the Value Client's assets loaded on the SaaS Solution. Rebalance — Base v. On each anniversary of the Effective Date, if Client's PMV has increased 10% or more from the then -current Basis Point Fees Breakpoint PMV, then the Breakpoint PMV will increase to the higher of (i) 5% above the previous Breakpoint PMV or (ii) 95% of the client's current PMV. Additionally, the Annual Base Fee will increase by the product of (i) the Basis Point Fee Above the Breakpoint and (ii) the difference between the new Breakpoint PMV and the previous Breakpoint PMV. This rebalancing is not a fee increase but instead balances the base and the basis point fees to ensure a fair and proportional fee structure in response to significant changes in the Client's assets during the Order Form's term. Clearwater SKU Table (see Clearwater SKU Description Addendum) oncnt or Scrvicc SSACW SaaS Solution Access — CW Yes BDREC Daily Reconciliation - CW Yes ACCTMOD Accounting Module — CW Yes USGAAP US GAAP Acct Basis — CW Yes DERIVREP Derivative Reporting — CW Yes In addition to applicable basis point fees, derivative holdings are $16.50/month/holding and derivative transactions are $8.00/month/transaction. BLREP Bank Loan Reporting — CW Yes Additional 0.1875 basis points on Bank Loan PMV MORTLREP I Mortgage Loan Reporting — CW Yes Additional 0.1875 basis points on Mortgage Loan PMV GLFUNCT I General Ledger Functionality — CW Yes RISKMOD Risk Module - CW Yes Annual Base includes 3 LGIP for no additional cost, thereafter, each LGIP is $500 per year. Local Government Investment Pool Reporting - LGIPREP CW This fee replaces any applicable base or basis point fee. DATBUND I Data Overrides Bundle — CW Yes CPDBUND I Client Provided Data Bundle — CW Yes Clearwater evaluates the Client's current portfolio construction to determine the suitable fees for this Order Form, including monthly trades; local currencies; the number of custodians; the number of custodial accounts; the number of tax lots; and the number of distinct securities. If these metrics undergo significant changes during the term of the Order Form, Clearwater reserves the right to discuss and revise the relevant fees with the Client. Any adjustments to the fees will be documented in a mutually agreeable amendment to the Order Form. This Order Form is governed by Clearwater's Terms of Use found at https:Hclearwateranalytics.com/terms-of-use/ with password: CWterms208. By signing below, Client understands and agrees to be bound by this Order Form and the Terms of Use. CITY OF LA QUINTA, CA M Name: Title: CLEARWATER ANALYTICS, LLC M Name: Title: Date: ("Effective Date") Date: CLEARWATER A N A L Y T I C S Clearwater SKU Description Addendum Client may use the Service or Component SKUs identified in the body of this Order Form. SaaS Solution Access — CW The SaaS Solution Access allows Client to access Clearwater's SaaS Solution and provides a rolling 3-year period of live data once on the system (data beyond the 3-year period will be archived and can be made available to the Client, in a commercially reasonable format, upon request). Daily Reconciliation — CW Clearwater's SaaS Solution will import, reconcile, and report upon Client's cash, transaction, and position data for each prior business day. If there are any data errors or inconsistencies that exceed Clearwater's standard reconciliation tolerances, the SaaS Solution will flag the relevant items as "Unreconciled." Throughout the day, Clearwater personnel will diligently investigate outstanding errors and inconsistencies. Clearwater will identify, communicate, and track exceptions until they are resolved by coordinating with the Client and any required third parties. Accounting Module — CW The Clearwater Accounting Module provides flexible accounting reports, including daily balance sheets, income statements, transaction details, income details, security details, and impairment analysis; includes income, balance sheet, roll forward, transaction, comparison, and disclosure reports; provides FIFO, LIFO, Average Cost (Weighted Average Cost), High Cost, Low Cost, Minimum Short -Term Gain (Best Tax Lot), FIFO for Futures, Top of Day for Futures, and FIFO for Money Market Funds lot inventory methods; provides constant yield, straight line, purchase credit impaired, or no amortization elections (applied per accounting basis); provides retrospective, prospective, or cumulative amortization adjustments (adjustments can be made monthly, quarterly, or annually); and provides impairment monitoring and the ability for Client to enter writedowns. Each month, a hard lock is conducted from Business Day 4 to Business Day 7, with the specific day selected by the Client during the implementation process. In all instances, Client is required to furnish Clearwater with all month -end deliverables, such as OTTI, pricing overrides, and regulatory information, at least 16 business hours before the monthly lockdown. Includes the following accounting bases: USGAAP (US GAAP Acct Basis — CW) Includes accounting for all available asset classes, including derivatives (Derivative Reporting — CW); bank loans (Bank Loan Reporting — CW); and mortgage loans (Mortgage Loan Reporting — CW). Reporting on Limited Partnerships requires Clearwater's LPx Tools. General Ledger Functionality — CW Provides Client the ability to create a general ledger or map its current general ledger accounts to the matching general ledger buckets in the SaaS Solution. Using Clearwater's GL Wizard, Client can customize its Chart of Accounts. Clearwater offers a GL Entry File containing the Client's debits and credits which is viewable on the website at any time. Client can generate an output of the Entry File in excel format, csv format, or an alternative flat text file directly from the website. The functionality includes trial balance, entry detail, entry summary, activity detail, and financials reports. Risk Module — CW The Risk Module provides portfolio risk data, including issuer, security type, duration, currency, and country concentrations across multiple asset classes; includes exposure, cash flow forecast, credit events, shock analysis, risk comparison, historical trends, historical exposure, and VaR reports, among others. Data Overrides Bundle — CW The Data Overrides Bundle permits the client to replace a Supplemental Data or calculated value with a client -provided custom value. The following overrides are available in the bundle: pricing overrides; analytics overrides; regulatory overrides; and client provided cash flow projections. Client Provided Data Bundle — CW Self -Service CPD: Allows the Client to generate custom fields and manually input data directly into the SaaS Solution for certain Clearwater reports. Self -Service CPD can be applied to various elements such as accounts, legal entities, tax lots, positions, securities, security types, or transactions. The data provided through Self -Service CPD is not processed by Clearwater's reconciliation, accounting, or analytics systems. The Client has the flexibility to update Self -Service CPD values either one at a time or in bulk. Auto CPD: Enables the Client to generate custom fields, automatically populated by data feeds from the client or a client data provider, to support CPD in reports. Auto CPD can be applied to various elements, including accounts, legal entities, tax lots, positions, securities, security types, or transactions. The Auto CPD feature can include various data types such as whole numbers, decimal numbers, accounting values, percentages, text, yes/no, dates, and credit ratings. Users can add these auto -populated fields to compatible reports on the SaaS Solution. Auto CPD data is not processed by Clearwater's reconciliation, accounting, or analytics systems. Logic -Based CPD: Logic -based CPD allows the creation of custom fields that are automatically populated based on logical formulas, using standard Clearwater data fields, auto CPD fields, manual CPD fields, or a combination of these. Users have the flexibility to add logic -based CPD fields to any report on the SaaS Solution, enhancing the depth and customization of the reports. Project Based Work The fees stated in this Order Form encompass all the necessary services for onboarding, training, and daily servicing support required to use the services identified in the Order Form. Client may request additional services from Clearwater related to new, changed, or custom projects beyond the initial onboarding. The following is a non -exhaustive list of project -based work that the Client may request from Clearwater (in each case, the parties will enter into a mutual contract outlining the provisions for the project -based work before any work commences): changed or new data connections (e.g., custody transitions or a new asset class mandates that require other data sources); general ledger rewrites (e.g., clients obtain a new GL system and rewrite its GL); compliance rewrites (e.g., substantial adjustments or additions to an investment policy); system integrations (e.g., integrating anew OMS or GL system); custom operational reporting (e.g., client requests for Clearwater to provide custom operational reporting outside of standard servicing); client specific transformational initiatives (e.g., request by client for Clearwater to map and find operational efficiencies in the client's investment lifecycle); custom report configurations (e.g., requests by a client to recreate or enhance a board package). CLEARWATER A N A L Y T I C S Onboarding Statement of Work and Project Plan Client Project Coordinator Name Phone Email t;�; Fee Estimated Onboarding Start Date Estimated Onboarding W Onboarding e' "5 pef fneffth a..^^^ the 1 July 2024; provided that if this Order Form is not — 6 months Onbeaf iag ppr-d4a executed by this date, then the Estimated Onboarding addition—te any otkef Start Date will be in the month following the Effective .,..pheable fees Fee waived Date with the specific date to be determined by the parties. This Statement of Work ("SOW") is a part of the Order Form between Client and Clearwater. All capitalized terms not otherwise defined below will have the same meaning as in the Order Form. 1. GENERAL. This SOW details the onboarding services ("Onboarding Services") that Clearwater will perform for Client for the deployment of the SaaS Services ("Project"). If Client wishes to secure other onboarding services to deploy additional functionality not included in the scope of this SOW, change the roles and responsibilities typically included for the deployment of the SaaS Solution, change the timeline of deployment, or otherwise initiate additional efforts outside the scope of this SOW, Clearwater will provide a proposal for such onboarding services and develop a separate statement of work or Change Order subject to the Change Order Process set forth below. 2. PROJECT ROLES AND RESPONSIBILITIES. 2.1. Clearwater Activities. The activities below will be performed as part of the Project: 2.1.1. Scope review and Client orientation; 2.1.2. Supporting Client's validation efforts; 2.1.3. Loading of Client data; 2.1.4. Client training; 2.1.5. Support Client's testing efforts. 2.2. Client Activities. Among other items, Client will perform the activities below as part of the Project: 2.2.1. Review scope; 2.2.2. Attend meetings and workshops as required; 2.2.3. Provide initial load data; 2.2.4. Help correspond with any necessary third parties, including serving as an issue escalation point to get third parties to work with Clearwater on integrations; 2.2.5. Help test, identify problems, and aid in issue resolution; 2.2.6. Sign off on the end of the onboarding. 2.3. Clearwater Roles. Clearwater roles and responsibilities in this SOW are described below. The extent of each Clearwater team member's involvement will vary by task. 2.3.1. Onboarding Manager. The Onboarding Manager manages the Project and is responsible for working directly with the Client Project Coordinator. The Onboarding Manager staffs the Project and directs Project activities based on a mutually agreed upon Project Plan developed pursuant to a Statement of Work. The Onboarding Manager is responsible for resolving Project -related issues that may be outside the direct control of the Project team. The Onboarding Manager provides overall Project status to key members of Clearwater's management team and Client. 2.3.2. Onboarding Team. The Onboarding Team completes the hands-on functional and technical Project activities and provide guidance to the Client. Throughout the Project, the Onboarding Team leads meetings to help the Client understand and use the features and functions of the SaaS Solution. The Onboarding Team works with the Client to build the integrations included within the SOW scope and provides support during confirmation and testing. 2.4. Client Roles. Client will assume responsibility for the roles below and tasks: 2.4.1. Executive Sponsor. The Executive Sponsor is responsible for championing the Project, ensuring that appropriate Client resources are available for the Project, working with the Project Coordinator to resolve escalated issues promptly and sign off on key deliverables throughout the Project. The Executive Sponsor must be an active and visible resource on the Project and is expected to participate as needed to ensure the Project is meeting the goals/objectives and timeframes outlined in the beginning of the Project. 2.4.2. Project Coordinator. The Project Coordinator performs various tasks including (1) understanding and signing off on the Project Plan, (2) assigning responsibilities, (3) setting mutually agreed upon deadlines and evaluating milestones, (4) managing the issue and key decision log, and (5) delivering status reports to Client senior management regularly. The Project Coordinator also escalates issues that may impact the go -live date. 2.4.3. Functional Lead. Functional Leads are responsible for identifying and providing necessary data to Clearwater and testing the business processes and configuration in the SaaS Solution. They are also responsible for providing functional knowledge and expertise on Client requirements such as business processes, data mapping, organizations, and system configurations. They also escalate to the Project Coordinator issues that may impact the go -live date. 3. ESTIMATED PROJECT TIMELINE. Based on the assumptions below, the time required to complete the Project is expected to start on the Onboarding Start Date and last for the Onboarding Period. 4. GENERAL ASSUMPTIONS. The fixed fees and timeline for this Project are based on both parties agreeing to the General Assumptions set forth below. If any of these assumptions are not met, Clearwater may (i) promptly advise Client in writing, (ii) use reasonable efforts to mitigate delays and additional costs or fees, and (iii) increase its fees to reflect the other services rendered because Client failed to meet the identified assumptions. 4.1. All of Clearwater's services set forth under this SOW will be provided remotely. 4.2. In the unlikely event that travel is required for the services to be performed on -site, Client will reimburse Clearwater for all reasonable and necessary travel and living expenses incurred by Clearwater in the performance of the services under this SOW in accordance with Clearwater's Travel and Expense Policy. Upon Client's written request, Clearwater will submit supporting expense documentation and copies of receipts to Client for expenses over Twenty -Five United States Dollars ($25). 4.3. Client and Clearwater will meet all dates set forth in the mutually agreed, written project plan ("Project Plan"). 4.4. Client will assign a Project Coordinator to manage Client resources and activities for this Project. 4.5. Clearwater will assign an Onboarding Manager to direct Clearwater resources and activities. 4.6. Client will staff the Project with its resources described in the Roles and Responsibilities section promptly. 4.7. Client and Clearwater will participate in all required Project activities. 4.8. Client will lead testing and sign off before the end of the onboarding. Clearwater will support issue resolution to Client's testing efforts. 4.9. If the Project is delayed by Client for any reason, Client understands that Clearwater's ability to staff the engagement and meet the target go -live date could be at risk. As a result, Clearwater reserves the right to revisit and revise the Project go -live date and estimated fees and costs. 4.10. Clearwater will conduct work on the Project during common business hours, excluding holidays observed Clearwater, including U.S. holidays. 4.11. Once the onboarding Project starts, additional integration or functional changes to scope will impact costs and the timeline. 5. TERMINATION/SUSPENSION. 5.1. Automatic Termination. Unless extended by mutual written agreement of the parties or earlier terminated as provided in this SOW or the Terms of Use this SOW automatically terminates upon completion of the Project. 5.2. Suspension by Clearwater. Clearwater may stop providing services to Client under this SOW without liability to Client, by giving Client 15 days' prior written notice in the event: (i) Client repeatedly fails, after receiving written notice and being given a commercially reasonable amount of time to cure in each instance, to perform its obligations under this SOW which results in the inability of Clearwater to meet its obligations and time frame commitments, and in such event Clearwater will have the right to remove any Clearwater personnel and assign them to other projects, and (ii) it is determined that the information provided by Client, or lack thereof, to Clearwater during the discovery stage is materially inaccurate or inadequate, and in such instance, the parties may agree to enter into a new mutually agreed upon statement of work. 6. CHANGE ORDER PROCESS. During a Project in a Statement of Work, new information may surface that may require a change in business requirements resulting in a change in Project scope and so changes in the estimated level of effort, Project timeline, or Service features. Such changes, and the associated fees for additional Services to be provided, will be described in a document (a "Change Order"). A completed Change Order includes the requested change, the impact on the current engagement under the applicable Statement of Work, and the estimated resources and time to complete the Services for the work described in the Change Order. Clearwater will submit the Change Order to Client for review and approval. Proposed Change Orders will remain valid for a period of ten business days from the date of submission. If Client does not approve the Change Order within the ten business days, and Clearwater has not extended the period of validity in writing, the proposed Change Order will automatically expire. Upon Clearwater's receipt of Client's written approval, Clearwater will begin performing the services described in the Change Order according to the agreed -upon schedule under the applicable Statement of Work as may be modified by the Change Order. PROJECT RISKS. 7.1. Participation of Client subject matter experts is vital to the success of the Project. Client must identify individuals from each business unit who possesses the necessary business knowledge, process knowledge, and industry knowledge to participate on the Project team 7.2. Timely decision making is critical to the progress and ultimate success of the Project. When a decision cannot be made through consensus, the Project management team must escalate the decision through Clearwater's Onboarding Manager and Client's Executive Sponsor to avoid impacts to timeline and costs. 7.3. The timely participation of third parties (including, for example, custody safekeeping locations and asset managers) is required for the Project to be on -time and successful. 8. FIXED FEES AND INVOICING. 8.1. The Onboarding Fee will be identified in the Order Form and will be invoiced monthly in advance. Client must pay all invoices in accordance with the Terms of Use. 9. PROJECT DELAYS 9.1. The parties acknowledge and agree that the avoidance of Project delays is material to the Project success and Clearwater's ability to timely complete the Project. 9.2. Client Delay. In the event the Project is delayed because the Client failed to provide certain deliverables, meet material deadlines in the Project Plan, or any other similar reason, then the parties agree Clearwater has the right to bill $210/hour billed in '/a hour increments for Clearwater resources necessary beyond the defined onboarding project. 10. ISSUE ESCALATION. Client's Project Manager and Clearwater's Onboarding Manager shall promptly resolve all issues, if necessary, by holding a meeting. Client's Project Manager is the escalation point for all Client resources assigned to the Project. Clearwater's Onboarding Manager is the escalation point for all Clearwater resources assigned to the Project. 11. PROJECT PLAN. This Project Plan is a current estimate as of the Effective Date of the Order Form and may be amended moving forward by the parties. Some steps below may run contemporaneously. STEP 1: CLIENT DATA GATHERING AND CONNECTION INSTRUCTIONS. During Step —I of the Project Plan, Client will provide Clearwater with the following information to establish Client's SaaS Solution Accounts: o List of Accounts and other Information. Client must complete the Clearwater -provided template with account specific information to be built in the client hierarchy and account structure. The template will require information including account names and preferred benchmarks (to be selected out of Clearwater's then -current list of available benchmarks). o User Access. Client must complete the Clearwater -provided template with requested user access. Client must designate Client Account administrators, users, and must determine the appropriate user account access permissions. o Accounting Assumptions. Client must complete the Clearwater -provided template to manage account creation, including accounting assumptions. o Multi -Basis Lot Level Original Cost Data and Book Values and Prior Cost Basis Adjustments. If Client is an insurance company loading data back to the beginning of the then -current calendar year, then Client must provide its original cost, cost basis, and book value of its accounts as of 12/31 of the previous year. If not, Clearwater and Client will agree on a date following the successful completion of all safekeeping location connections for which Client must provide such information (e.g., if all connections are made as of March 31, the parties may provide the original cost and book value information for all its accounts as of April 1). o Investments Chart of Accounts and General Ledger Requirements. Client must provide Clearwater with general ledger information including its investments chart of accounts. In addition, Client must provide Clearwater with a trial balance report to display which GL codes are actively used. Clearwater will provide Client with information on what fields are required as part of this step. o Data Contract Confirmations: Some Supplemental Data Providers may require Client to have a direct contract with the Supplemental Data Provider to obtain certain Supplemental Data points on the SaaS Solution. To the extent Client already has the necessary Supplemental Data contracts, Client should provide Clearwater with its contact at the Supplemental Data Provider to permit Clearwater to confirm the existence of the contract with the Supplemental Data Provider. If Client does not have, and does not wish to obtain, the necessary Supplemental Data contracts, the parties will discuss alternative data options (including removing SaaS Solution access to the data point). o Custody/Safekeeping Access Letter. Client must instruct its safekeeping locations to provide Clearwater with access to its accounts. Following receipt of Client's list of accounts, Clearwater will generate a template custody access letter to aid in the process. Client must email the safekeeping location with a copy to Clearwater's account access team. o Custody/Safekeeping Issue Resolution. If a safekeeping location does not respond to Client's safekeeping access letter, or otherwise does not meaningfully participate in the safekeeping connection process, then Client is responsible for issue escalation and resolution. Clearwater will provide support in the process, as needed. o Custody/Safekeeping Data Feed Format: Clearwater expects that all Safekeeping Locations are able to facilitate a file transfer protocol ("FTP") with Clearwater to provide Client data. To the extent the Safekeeping Location is unwilling or unable to provide Clearwater with an FTP, then Client and Clearwater will discuss the impact on the Project Plan, including any fees and impact to the timeline. Component or Service Specific Requirements. Clearwater will also provide Client with any other requirements specific to components or services. By way of example: o Single Sign -On. If Client subscribes to Clearwater's Single -Sign On, Client must provide Clearwater with its technical contact to help facilitate the development. o Data Point FTP. If Client subscribes to Clearwater's Data Point FTP, Client must define the data points that it desires to include in the feed (and the parties will confirm that Client has the appropriate data licenses to receive the feed, if applicable). STEP 2: CONNECTIVITY, ACCOUNT SET UP, AND USER CREATION. After Step 1 of the Project Plan, and during Step 2 of the Project Plan, Clearwater will do the following: o Connectivity. Once Client Safekeeping Locations have responded to Client's requests to release daily access to Client's accounts (including any period of issue escalation and resolution) and Step 1 is completed, Clearwater will work with the Client Safekeeping Location to complete the connectivity to the SaaS Solution o Account Set Up. Using the data provided by Client in Step 1.1, Clearwater will set up the account structure on the SaaS Solution. o Create Users and Entitlements: Clearwater will verify the accuracy of the information provided by Client in Section 1.2 and provide Client administrators with user login credentials. STEP 3: DATA MIGRATION AND RECONCILIATION. After Step 2 of the Project Plan, and during Sty of the Project Plan, Clearwater will work to set up account and user connectivity as follows: o Data Migration. Following Client's provision of the information required in Section 1.4, Clearwater will input the original cost data, book values, and cost basis details into the Clearwater SaaS Solution and will reconcile those with the information provided by the Client's custodian. o Initial Reconciliation. Once the information is loaded in Section 3.1, Clearwater will reconcile those amounts with custody amounts provided by the Safekeeping Location. STEP 4: REPORTING AND GENERAL LEDGER CONFIGURATION. During Step 4 of the Project Plan, the parties will do the following: o Report Training. Clearwater will train the Client to configure and create reports using Clearwater's flexible report writer. o GL Configuration. Clearwater and Client will work collaboratively to configure the Client's general ledger and review the chart of accounts to determine appropriate mappings on the SaaS Solution. STEP 5: COMPLIANCE SET-UP. During Step 5 of the Project Plan, Client and Clearwater will set up the Compliance Module: o Investment Policies. Client will provide Clearwater with the investment policies for Clearwater to create corresponding compliance rules in the SaaS Solution. o Compliance Module Review and Interpretation into Matrix. Clearwater will work with Client to configure rules based on its investment policies into SaaS Solution to monitor compliance rules. This process includes the following: o Rule creation, in which Clearwater will configure the rules based on Client's investment policies and Clearwater's available rules into the SaaS Solution; and o Compliance Module Rule review and confirmation, in which Clearwater will review the compliance rule results generated by SaaS Solution and confirm with Client that the results are accurate. STEP 6: USER TRAINING. During Step 6 of the Project Plan, Clearwater will provide all necessary and reasonably requested trainings. Clearwater will provide Client with access to available documentation (including user guides, video tutorials, etc.) describing the functional and operational characteristics of the SaaS Solution. The training may include, for example, reconciliation, the error -reporting process, navigation and functionality, report creation, and other module -specific training as requested. STEP 7: PARALLEL PROCESSING AND UAT TESTING. During Step 7 of the Project Plan, Clearwater and Client will conduct the following parallel and UAT testing. o UAT Testing. In coordination with Clearwater, Client will conduct the following User Acceptance Testing steps: o UAT Definitions. Client must define the critical User Acceptance Test (UAT) items in a written plan. o UAT Testing. Client will perform the identified in the prior step, with Clearwater providing any reasonably requested assistance. o Correction. Clearwater will work to solve or correct any issues identified by the UAT testing. 0 UAT Sign -Off. Client provides sign -off on all UAT items. o Parallel. Clearwater and Client will conduct the following parallel processes (as applicable): Accounting Parallel Process: Clearwater will conduct an accounting parallel of Client's financials for a mutually agreed period. This parallel will include a review of the trial balance and general ledger activity generated by Clearwater in comparison to Client's current system, as well as a comparison of portfolio holdings between systems as of a date certain. The parallel will also review transactional and income activity over that period in comparison between the two systems. o Performance Parallel Process. Clearwater will conduct a performance parallel of Client's returns for a mutually agreed upon period. This parallel will include a review of security, composite and group returns generated by Clearwater in comparison to Client's current system. PROJECT COMPLETION. Following completion of each of the foregoing steps, Client will be onboarded on the SaaS Solution and the Project will be complete. ta GiKra ATTACHMENT 2 INSURANCE REQUIREMENTS ACKNOWLEDGEMENT Must be executed by proposer and submitted with the proposal (name) hereby acknowledge and confirm that (name of company) has reviewed the City's indemnification and minimum insurance requirements as listed in Exhibits E and F of the City's Agreement for Contract Services (Attachment 1); and declare that insurance certificates and endorsements verifying compliance will be provided if an agreement is awarded. lam (Title) of (Company) Commercial General Liability (at least as broad as ISO CG 0001) $1,000,000 (per occurrence); $2,000,000 (general aggregate) Must include the following endorsements: General Liability Additional Insured General Liability Primary and Noncontributory Commercial Auto Liability (at least as broad as ISO CA 0001) $1,000,000 (per accident) Personal Auto Declaration Page if applicable Errors and Omissions Liability $1,000,000 (per claim and aggregate) Worker's Compensation (per statutory requirements) Must include the following endorsements: Worker's Compensation Waiver of Subrogation Worker's Compensation Declaration of Sole Proprietor if applicable Clearwater works with many other government entities in California and if we are your selected vendor, we will negotiate commercially reasonable insurance and indemnification obligations, but we can't agree as is. Page 9 of 36 �f. r CAHORNI NON -COLLUSION AFFIDAVIT FORM Must be executed by proposer and submitted with the proposal Alec Ward ATTACHMENT 3 (name) hereby declare as follows: I am the Account Executive of Clearwater Analytics (Title) (Company) the party making the foregoing proposal, that the proposal is not made in the interest of, or on behalf of, any undisclosed person, partnership, company, association, organization, or corporation; that the proposal is genuine and not collusive or sham; that the proposer has not directly or indirectly induced or solicited any other proposer to put in a false or sham proposal, and has not directly or indirectly colluded, conspired, connived, or agreed with any proposer or anyone else to put in a sham proposal, or that anyone shall refrain from proposing; that the proposer has not in any manner, directly or indirectly, sought by agreement, communication, or conference with anyone to fix the proposal price of the proposer or any other proposer, or to fix any overhead, profit, or cost element of the proposal price, or of that of any other proposer, or to secure any advantage against the public body awarding the agreement of anyone interested in the proposed agreement; that all statements contained in the proposal are true; and, further, that the proposer has not, directly or indirectly, submitted his or her proposal price or any breakdown thereof, or the contents thereof, or divulged information or data relative hereto, or paid, and will not pay, any fee to any corporation, partnership, company, association, organization, proposal depository, or to any member or agent thereof to effectuate a collusive or sham proposal. I declare under penalty of perjury under the laws of the State of California that the foregoing is true and correct. Proposer Signature: Proposer Name: Proposer Title: Company Name: Address: Alec Ward Account Executive Clearwater Analytics 777 W. Main St. Ste. 900, Boise, ID 83702 Page 10 of 36 ta GiKra ATTACHMENT 4 ACKNOWLEDGEMENT OF RECEIPT OF ADDENDA Must be executed by proposer and submitted with the proposal; If no addenda has been issued, mark "N/A" under Addendum No. indicating Not Applicable and sign ADDENDUM NO. SIGNATURE INDICATING RECEIPT Page 11 of 36 CLEARWATER ANALYTICSo City of La Quinta Statement Demo-Govt Agg (85852) Month End (M9 Y2023) 09/01 /2023 - 09/30/2023 Dated: 03/27/2024 Locked Down CLEARWATER AN►4LYTICSo Table of Contents Portfolio Snapshot (Demo-Govt Agg (85852)) City of La Quinta Holdings (Demo-Govt Agg (85852)) City of La Quinta Returns (Demo-Govt Agg (85852)) 1 5 Dated: 03/27/2024 CLEAR'•d11ATER ANALYTICSo Portfolio Snapshot 09/01 /2023 - 09/30/2023 Key Metrics Risk Metric Value Cash 56,116,465.64 MMFund 23,762,535.41 Fixed Income 307,817,782.11 Duration 1.345 Convexity 0.045 WAL 1.411 Years to Final Maturity 1.500 Years to Effective Maturity 1.429 Yield 4.545 Book Yield 1.744 Avg Credit Rating BBB+/Baa1/BBB+ Compliance Overview Status Non -Compliant As of 09/30/2023 Violations Return to Table of Contents Security Type Exposure T-BILL (5.384%) MMFUND( AGCY BOND (10.627%) CASH (14.474%, Industry Sector Exposure 6 Communications (1.448%) Cosumer, FuiYas c.l5(si298./s)� Asset Backed / 0 Securities (3.685%) Financial (11.758%) Mortgage Securities (14.832%) Other (19.419%) (23.385%) (15.613%) Chart calculated by: Base Market Value + Accrued Demo-Govt Agg (85852) Dated: 03/27/2024 Credit Rating Exposure A+ (2.372%) A-1+ Issuer Concentration Exposure Farm Credit System (1.986%) (LGIP DEMO) LGIP DEMO (2.578 % ) Federal Home Loan Government Banks (3.635%) (43.009%) BlackRock, Inc. (3.637%) (CCYUSD) UNITED/ STATES OF AMERICA (14.474%) Chart calculated by: Base Market Value + Accrued AA+ (51.265%) Chart calculated by: Base Market Value + Accru United States (28.768%) Federal Home Loan " Mortgage Corpora... (17.961 %) Chart calculated by: Base Market Value + Accru 1 CLEAR'•d11ATER ANALYTICSo Portfolio Snapshot 09/01 /2023 - 09/30/2023 Portfolio Yield 6.5 6 5.5 5 4.5 4 T 3.5 0 3 a m } 2.5 2 1.5 1 0.5 0 Return to Table of Contents s_t1ci.�A�.i.�:��e�Z■�Jamar_Iw■s_r_Ullqa� Duration 120,000,000 110,000,000 100,000,000 90,000,000 2 80,000,000 U U Q 70,000,000 t 60,000,000 m Y 50,000,000 m cn 40,000,000 m m 30,000,000 20,000,000 10,000,000 0 Demo-Govt Agg (85852) Dated: 03/27/2024 113,723,580.11 rvo u.uu - u.co - u.ou - u. r o - i .uu - O.uu - vuier Duration 0.25 0.50 0.75 1.00 2.00 4.00 2 CLEAR'•d11ATER ANALYTICSo Portfolio Snapshot Demo-Govt Agg (85852) 09/01/2023 - 09/30/2023 Return to Table of Contents Dated: 03/27/2024 Credit Duration Heat Map Rati 0-1 1-2 2-3 3-4 4-5 5-7 7-10 10-15 15-30 AAA 30.055 % 1.483 % 0.084 % 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% AA 14.766% 15.118% 0.732% 0.000% 0.000% 0.000% 0.000% 0.000% A 7.025% 4.744 % _ 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% BBB 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% BB 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% B 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% CCc 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% CC 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% C 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% NA 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% 0.000% Performance Summary - Total Return (Income and Price) 4% 2.676 % 2% 1.314 % ,6-32-°h 045% 0.291 % 0.142% 0.407 % . 0.149 % 0.563% 0117 7 a) -0.378% -0.135 o -2% 2.738 -4% 4.052% -6% Prior Month Prior Quarter Prior Year Trailing Month Trailing Quarter Trailing Year • Total Return • Income Return • Price Return Multiple Benchmarks Comparison (Prior Month) Account/Index Prior Month Total Retw Demo-Govt Agg 0.291 % ICE BofA 1-3 Year AAA -A US Corporate & Government Index 0.377% Total Weighted Benchmark 0.382 % Demo-Govt Large Cap 0.094% Demo-Govt Small Cap 0.382 % 3 CLEAR'•d11ATER ANALYTICSo Portfolio Snapshot 09/01 /2023 - 09/30/2023 Performance Sum Asset Class Fixed Income _ Cash _ MMFund - Total Return (income and Price Base Market Value + Accrued Prior Month Total Return 307,817,782.11 0.344 % 56,116,465.64 0.000 % 23,762,535.41 0.264% Return to Table of Contents Demo-Govt Agg (85852) Dated: 03/27/2024 Multiple Benchmarks Comparison Prior Qtr Prior Quarter Total Prior Year Total % of Base Market Value + Account/Index Prior 3 Months Total Return Return Accrued Return -0.028% -2.954 % 79.397% Demo-Govt Agg 0.330 % 0.000 % 0.000 % 14.474 % ICE BofA 1-3 Year AAA -A US Corporate & Government Index 0.337 % 0.725% 0.874% 6.129% Total Weighted Benchmark 0.318% Demo-Govt Large Cap -0.264 % Demo-Govt Small Cap 0.606% --- 387,696,783.16 0.291% 0.030%-2.738% 100.000% Footnotes: 1,2,3,4 1: * Grouped by: Asset Class. 2: * Groups Sorted by: Base Market Value +Accrued. 3: * Grouping details not shown. 4: * Weighted by: Base Market Value + Accrued. 4 CLEAR'•d11ATER ANALYTICSo City of La Quinta Holdings Base Currency: USD As of 09/30/2023 Account Identifier _ Demo -Gout Small Cap 023135BW5 Demo -Gout Small Cap 02582JJT8 Demo -Gout Small Cap 02665WCT6 Demo -Gout Small Cap 037833DM9 Demo -Gout Small Cap 05601XAC3 Demo -Gout Small Cap 05602RAD3 Demo -Gout Small Cap 06051 GJY6 Demo -Gout Small Cap 06367TQW3 Demo-Govt Small Cap 06406RBCO Demo -Gout Small Cap 09247XAN1 Demo-Govt Large Cap 09248U718 Demo -Gout Small Cap 09690AAC7 Demo-Govt Small Cap 14913R2LO Demo -Gout Small Cap 24422EVN6 Demo-Govt Small Cap 24422EWB1 Demo -Gout Small Cap 26442UAA2 Demo-Govt Small Cap 26442UAA2 Demo -Gout Small Cap 3130AOF70 Demo-Govt Small Cap 313OA7PH2 Demo -Gout Small Cap 313OAQF40 Demo-Govt Small Cap 3130ATUS4 Demo -Gout Small Cap 3133EKMX1 Demo-Govt Small Cap 3133ENKSB Demo -Gout Small Cap 3133ENPYO Demo-Govt Small Cap 3135GO5X7 Demo -Gout Small Cap 3135G06H1 Demo-Govt Small Cap 3137B7YY9 Demo -Gout Small Cap 3137BFE98 Demo-Govt Small Cap 3137BFXT3 Demo -Gout Small Cap 3137BKRJ1 Demo-Govt Small Cap 3137BM7C4 Demo -Gout Small Cap 3137BTUM1 Demo-Govt Small Cap 3137EAEY1 Demo -Gout Small Cap 3137EAEY1 Demo-Govt Small Cap 3137EAEZ8 Demo -Gout Small Cap 3137EAFA2 Demo-Govt Small Cap 3137F2LJ3 Demo -Gout Large Cap 3137F72BO Demo-Govt Small Cap 362554AC1 Demo -Gout Small Cap 36262XAC8 Demo-Govt Small Cap 36265MAC9 Demo -Gout Small Cap 380146AC4 Demo-Govt Small Cap 40139LBG7 Demo -Gout Small Cap 43815GAC3 Demo-Govt Small Cap 44891 WAC3 Demo -Gout Small Cap 44933LAC7 Demo-Govt Small Cap 44934KAC8 Demo -Gout Small Cap 44935FAD6 Demo-Govt Small Cap 4581XODZ8 Demo -Gout Small Cap 459058GQO Demo-Govt Small Cap 459058JM6 Return to Table of Contents Description AMAZON.COM INC AMXCA 2022-2 A AMERICAN HONDA FINANCE CORP APPLE INC BMWLT 2022-1 A3 BMWOT 2022-A A3 BANK OF AMERICA CORP BANK OF MONTREAL BANK OF NEW YORK MELLON CORP BLACKROCK INC BLKRK LQ:T-FUND INSTIL BMWLT 2021-2 A3 CATERPILLAR FINANCIAL SERVICES CORP JOHN DEERE CAPITAL CORP JOHN DEERE CAPITAL CORP DUKE ENERGY PROGRESS LLC DUKE ENERGY PROGRESS LLC FEDERAL HOME LOAN BANKS FEDERAL HOME LOAN BANKS FEDERAL HOME LOAN BANKS FEDERAL HOME LOAN BANKS FEDERAL FARM CREDIT BANKS FUNDING CORP FEDERAL FARM CREDIT BANKS FUNDING CORP FEDERAL FARM CREDIT BANKS FUNDING CORP FEDERAL NATIONAL MORTGAGE ASSOCIATION FEDERAL NATIONAL MORTGAGE ASSOCIATION FHMS K-037 A2 FHMS K-041 A2 FHMS K-042 A2 FHMS K-047 A2 FHMS K-051 A2 FHMS K-061 A2 FEDERAL HOME LOAN MORTGAGE CORP FEDERAL HOME LOAN MORTGAGE CORP FEDERAL HOME LOAN MORTGAGE CORP FEDERAL HOME LOAN MORTGAGE CORP FHMS K-066 A2 FHMS K-740 A2 GMCAR 20214 A3 GMALT 2021-3 A3 GMALT 2022-1 A3 GMCAR 2022-1 A3 GUARDIAN LIFE GLOBAL FUNDING HAROT 2021-4 A3 HALST 2022-A A3 HART 2021-A A3 HART 2021-B A3 HART 2021-C A3 INTER-AMERICAN DEVELOPMENT BANK INTERNATIONAL BANK FOR RECONSTRUCTION AND DEVELOPM INTERNATIONAL BANK FOR RECONSTRUCTION AND DEVELOPM Trade Date 05/10/2021 05/17/2022 01/13/2020 08/18/2021 01/11/2022 05/10/2022 06/10/2021 09/10/2021 04/19/2022 07/06/2022 09/08/2021 05/10/2021 03/01 /2021 03/02/2022 04/18/2022 04/28/2022 12/21/2018 03/03/2020 12/21 /2021 01 /30/2023 07/30/2019 01 /06/2022 03/03/2022 12/02/2021 11 /23/2020 11 /05/2021 04/21/2022 08/19/2021 05/19/2022 05/16/2022 10/05/2022 10/14/2020 10/19/2020 11 /03/2020 12/02/2020 10/20/2022 04/04/2022 10/13/2021 08/10/2021 02/15/2022 01/11/2022 10/25/2022 11/16/2021 01/11/2022 04/20/2021 07/20/2021 11 /09/2021 09/15/2021 01 /26/2021 01/06/2021 Final Maturity 05/12/2024 05/17/2027 01/12/2024 09/11/2024 03/25/2025 08/25/2026 06/14/2024 07/09/2024 04/25/2025 03/15/2027 09/30/2023 12/26/2024 05/17/2024 01/17/2024 03/07/2025 08/15/2025 08/15/2025 12/08/2023 03/08/2024 12/20/2024 12/10/2027 02/23/2024 01/06/2025 02/25/2025 08/25/2025 11 /27/2023 01/25/2024 10/25/2024 12/25/2024 05/25/2025 09/25/2025 11 /25/2026 10/16/2023 10/16/2023 11/06/2023 12/04/2023 06/25/2027 09/25/2027 09/16/2026 10/21 /2024 03/20/2025 11/16/2026 10/28/2027 01 /21 /2026 01/15/2025 09/15/2025 01/15/2026 05/15/2026 09/23/2024 03/19/2024 11 /24/2023 _Book Value 1,834,452.45 2,484,599.90 502,006.66 1,010,377.32 469,111.05 959,966.11 1,000,014.07 1,999,556.03 1,474,892.13 1,982,872.22 12,226,033.38 145,165.51 2,909,185.25 1,849,864.77 669,862.52 1,422,908.66 998,892.19 4,003,707.31 4,017,517.13 2,249,192.80 4,072,949.17 2,002,416.67 1,998,090.28 3,999,660.83 3,449,885.14 3,774,776.39 1,287,623.10 698,182.59 2,554,948.13 2,507,785.56 2,009,074.41 2,905,447.64 3,279,832.41 1,899,904.13 4,274,873.62 3,049,823.52 2,209,945.84 50,362,095.14 551,834.65 554,210.21 1,512,724.76 569,713.39 2,754,326.49 737,053.52 794,490.51 401,843.60 1,312,625.83 526,904.77 3,954,044.02 2,374,381.35 2,000,029.83 Demo-Govt Agg (85852) Accrued Balance 3,188.31 3,744.07 3,895.14 1,000.00 86.00 513.60 2,702.53 2,847.22 21,412.08 2,844.44 0.00 7.98 4,874.25 1,711.25 949.17 5,905.25 4,152.78 42,375.00 4,791.67 6,312.50 52,416.67 4,707.78 5,312.50 7,000.00 1,312.50 3,250.69 3,721.05 1,842.52 5,562.50 6,935.42 5,513.33 8,367.50 1,879.17 1,088.54 4,304.69 2,478.13 6,074.51 61,250.00 156.36 66.04 878.22 299.12 64,983.56 180.19 409.61 67.87 221.71 173.32 439.44 1,958.33 1,763.89 Dated: 03/27/2024 Market Value +Accrued 1,781,321.66 2,402,112.25 500,650.14 966,950.00 463,703.63 936,724.99 1,001,132.53 1,922,847.22 1,443,725.08 1,874,304.44 12,226,033.38 144,356.86 2,823,907.65 1,823,443.25 639,244.77 1,371,679.37 964,612.78 4,028,055.00 3,941,071.67 2,140,257.50 3,983,776.67 1,978,287.78 1,902,592.50 3,817,920.00 3,202,972.50 3,748,994.44 1,274,185.82 680,980.53 2,421,618.00 2,421,693.42 1,926,694.13 2,839,529.00 3,275,155.17 1,897,193.54 4,258,570.94 3,025,516.13 2,182,855.55 43,431,064.00 529,598.47 550,718.61 1,494,323.25 550,859.61 2,830,645.41 708,595.46 786,183.64 393,783.80 1,275,978.26 509,451.90 3,763,068.24 2,318,094.83 1,986,123.89 5 CLEAR'•d11ATER ANALYTICSo City of La Quinta Holdings Demo-Govt Agg (85852) Base Currency: USD As of 09/30/2023 Return to Table of Contents Dated: 03/27/2024 Account Identifier _ Description Trade Date Final Maturity Book Value Accrued Balance Market Value + Accrued Demo -Gout Small Cap 459058JM6 INTERNATIONAL BANK FOR RECONSTRUCTION AND 11/17/2020 11/24/2023 1,564,834.07 1,380.24 1,554,141.94 DEVELOPM Demo -Gout Small Cap 45950KCR9 INTERNATIONAL FINANCE CORP 07/12/2021 10/16/2024 2,521,531.30 15,755.21 2,409,805.21 Demo -Gout Small Cap 46647PAH9 JPMORGAN CHASE & CO 04/23/2021 03/01/2025 2,019,138.25 5,366.67 1,979,146.67 Demo -Gout Small Cap 46647PCH7 JPMORGAN CHASE & CO 05/26/2021 06/01/2025 1,000,480.88 2,746.67 965,416.67 Demo -Gout Small Cap 47787JAC2 JDOT 2022 A3 03/10/2022 09/15/2026 1,109,838.70 1,144.53 1,075,829.77 Demo -Gout Small Cap 47788UAC6 JDOT 2021 A3 03/02/2021 09/15/2025 330,533.82 52.89 322,783.21 Demo -Gout Small Cap 47789QAC4 JDOT 2021-B A3 07/13/2021 03/16/2026 738,278.33 170.63 713,288.80 Demo -Gout Small Cap 57636QAN4 MASTERCARD INC 10/28/2021 03/03/2025 3,037,740.98 4,666.67 2,863,966.67 Demo -Gout Small Cap 58769KAD6 MBALT 2021-B A3 06/22/2021 11/15/2024 448,600.40 79.75 444,875.44 Demo -Gout Small Cap 59217GEPO METROPOLITAN LIFE GLOBAL FUNDING 1 09/21/2021 09/27/2024 954,962.11 74.28 907,572.58 Demo -Gout Small Cap 59217GEPO METROPOLITAN LIFE GLOBAL FUNDING 1 11/18/2021 09/27/2024 597,734.02 46.67 570,202.67 Demo -Gout Small Cap 59217GEW5 METROPOLITAN LIFE GLOBAL FUNDING 1 03/14/2022 03/21/2025 969,577.01 754.44 929,704.04 Demo -Gout Small Cap 60934N104 FEDERATED HRMS GV 0 INST --- 09/30/2023 434,255.63 11,505.91 445,761.53 Demo -Gout Small Cap 60934N872 FEDERATED HRMS TRS SVC --- 09/30/2023 1,096,529.79 0.00 1,096,529.79 Demo -Gout Small Cap 61747YET8 MORGAN STANLEY 08/10/2022 07/17/2026 2,011,373.74 19,235.89 1,967,815.89 Demo -Gout Small Cap 62479LDC6 MUFG Bank, Ltd., New York Branch 08/28/2023 04/12/2024 2,909,143.33 0.00 2,905,157.79 Demo -Gout Small Cap 637432NL5 NATIONAL RURAL UTILITIES COOPERATIVE FINANCE 04/06/2022 02/07/2024 1,317,426.68 5,827.73 1,309,447.00 CORP Demo -Gout Small Cap 63743HFC1 NATIONAL RURAL UTILITIES COOPERATIVE FINANCE 03/18/2022 02/07/2025 988,576.92 2,812.50 952,742.50 CORP Demo -Gout Small Cap 64952WEK5 NEW YORK LIFE GLOBAL FUNDING 01/11/2022 01/14/2025 3,253,489.28 10,095.02 3,094,663.22 Demo -Gout Small Cap 649791PP9 NEW YORK ST 10/29/2019 02/15/2024 2,000,000.00 5,136.67 1,979,796.67 Demo -Gout Small Cap 665859AW4 NORTHERN TRUST CORP 06/27/2022 05/10/2027 2,000,648.66 31,333.33 1,922,673.33 Demo -Gout Small Cap 665859AW4 NORTHERN TRUST CORP 09/09/2022 05/10/2027 998,497.07 15,666.67 961,336.67 Demo -Gout Small Cap 66815L2K4 NORTHWESTERN MUTUAL GLOBAL FUNDING 09/08/2022 09/15/2027 1,199,620.15 2,320.00 1,152,784.00 Demo -Gout Small Cap 66815L2K4 NORTHWESTERN MUTUAL GLOBAL FUNDING 10/05/2022 09/15/2027 977,027.38 1,933.33 960,653.33 Demo -Gout Small Cap 69371 RR40 PACCAR FINANCIAL CORP 08/05/2021 08/09/2024 199,965.73 144.44 191,556.44 Demo -Gout Small Cap 69371 RR40 PACCAR FINANCIAL CORP 08/05/2021 08/09/2024 499,907.19 361.11 478,891.11 Demo -Gout Small Cap 69371RR57 PACCAR FINANCIAL CORP 11/02/2021 11/08/2024 2,119,953.11 7,579.00 2,018,123.40 Demo -Gout Small Cap 74153WCQO PRICOA GLOBAL FUNDING 1 12/01/2021 12/06/2024 1,654,326.87 6,079.83 1,572,156.68 Demo -Gout Small Cap 78015K7C2 ROYAL BANK OF CANADA 05/19/2021 11/01/2024 2,540,401.05 23,437.50 2,426,787.50 Demo -Gout Small Cap 79466LAG9 SALESFORCE INC 06/29/2021 07/15/2024 469,937.19 620.14 452,323.04 Demo -Gout Small Cap 808513BN4 CHARLES SCHWAB CORP 03/16/2021 03/18/2024 1,229,905.17 333.13 1,200,936.13 Demo -Gout Small Cap 808513BN4 CHARLES SCHWAB CORP 03/19/2021 03/18/2024 1,000,442.94 270.83 976,370.83 Demo -Gout Small Cap 857477BR3 STATE STREET CORP 02/02/2022 02/06/2026 900,000.00 2,400.75 851,730.75 Demo -Gout Small Cap 87612EBL9 TARGET CORP 03/15/2022 04/15/2025 2,987,815.84 31,125.00 2,890,185.00 Demo -Gout Small Cap 89114QCA4 TORONTO-DOMINION BANK 04/23/2021 06/12/2024 2,027,799.91 16,047.22 1,970,247.22 Demo -Gout Small Cap 89115A2H4 TORONTO-DOMINION BANK 09/08/2022 09/15/2027 1,060,000.00 2,210.92 1,021,729.52 Demo -Gout Small Cap 89236TFS9 TOYOTA MOTOR CREDIT CORP 06/14/2019 01/08/2024 1,002,407.51 7,723.61 1,002,043.61 Demo -Gout Small Cap 89236TJH9 TOYOTA MOTOR CREDIT CORP 06/15/2021 06/18/2024 889,747.79 1,273.19 859,402.29 Demo -Gout Small Cap 89238JAC9 TAOT 2021-D A3 11/09/2021 04/15/2026 691,964.85 218.36 665,896.90 Demo -Gout Small Cap 89239CAC3 TLOT 21B A3 07/27/2021 10/21/2024 317,666.42 40.77 315,904.08 Demo -Gout Small Cap 91159HHV5 US BANCORP 03/28/2019 02/05/2024 1,001,399.52 5,250.00 995,700.00 Demo -Gout Small Cap 91159HHV5 US BANCORP 06/14/2019 02/05/2024 1,002,270.04 5,250.00 995,700.00 Demo -Gout Small Cap 912796ZY8 UNITED STATES TREASURY 07/26/2023 01/25/2024 1,769,390.50 0.00 1,769,508.00 Demo -Gout Small Cap 912797FB8 UNITED STATES TREASURY 04/24/2023 10/19/2023 1,995,177.50 0.00 1,995,020.00 Demo -Gout Small Cap 912797FC6 UNITED STATES TREASURY 05/23/2023 10/26/2023 6,327,069.45 0.00 6,327,711.50 Demo -Gout Small Cap 912797GY7 UNITED STATES TREASURY 09/26/2023 03/28/2024 4,867,801.04 0.00 4,868,600.00 Demo -Gout Small Cap 912797GY7 UNITED STATES TREASURY 09/28/2023 03/28/2024 2,920,680.63 0.00 2,921,160.00 Demo -Gout Small Cap 912797HC4 UNITED STATES TREASURY 06/27/2023 10/24/2023 2,990,039.08 0.00 2,990,340.00 Demo -Gout Small Cap 91282831`5 UNITED STATES TREASURY 11/28/2022 11/15/2027 4,687,353.84 42,493.21 4,590,743.21 Demo -Gout Small Cap 9128285CO UNITED STATES TREASURY 05/05/2022 09/30/2025 5,001,147.05 409.84 4,806,859.84 1.1 CLEAR'•d11ATER ANALYTICSo City of La Quinta Holdings Base Currency: USD As of 09/30/2023 Demo-Govt Agg (85852) Return to Table of Contents Dated: 03/27/2024 Account Identifier _ Description Trade Date Demo-Govt Small Cap 9128281<74 UNITED STATES TREASURY 04/05/2022 Demo-Govt Small Cap 912828YE4 UNITED STATES TREASURY 02/24/2021 Demo-Govt Small Cap 912828YM6 UNITED STATES TREASURY 08/05/2021 Demo-Govt Small Cap 912828Z52 UNITED STATES TREASURY 02/16/2021 Demo-Govt Small Cap 912828ZC7 UNITED STATES TREASURY 01/26/2022 Demo-Govt Small Cap 912828ZFO UNITED STATES TREASURY 03/17/2021 Demo-Govt Small Cap 912828ZL7 UNITED STATES TREASURY 01/13/2021 Demo-Govt Small Cap 912828ZL7 UNITED STATES TREASURY 04/22/2021 Demo-Govt Small Cap 912828ZTO UNITED STATES TREASURY 10/05/2021 Demo-Govt Small Cap 91282CBA8 UNITED STATES TREASURY 01/08/2021 Demo-Govt Small Cap 91282CBEO UNITED STATES TREASURY 01/12/2021 Demo-Govt Small Cap 91282CBV2 UNITED STATES TREASURY 04/23/2021 Demo-Govt Small Cap 91282CCC3 UNITED STATES TREASURY 05/26/2021 Demo-Govt Small Cap 91282CCL3 UNITED STATES TREASURY 07/13/2021 Demo-Govt Small Cap 91282CCX7 UNITED STATES TREASURY 09/08/2021 Demo-Govt Small Cap 91282CDB4 UNITED STATES TREASURY 12/29/2021 Demo-Govt Small Cap 91282CDH1 UNITED STATES TREASURY 11/17/2021 Demo-Govt Small Cap 91282CEF4 UNITED STATES TREASURY 06/06/2022 Demo-Govt Small Cap 91282CEN7 UNITED STATES TREASURY 06/02/2022 Demo-Govt Small Cap 91282CET4 UNITED STATES TREASURY 07/08/2022 Demo-Govt Small Cap 91282CEW7 UNITED STATES TREASURY 08/17/2022 Demo-Govt Small Cap 91282CFH9 UNITED STATES TREASURY 09/08/2022 Demo-Govt Small Cap 91282CGC9 UNITED STATES TREASURY 01/26/2023 Demo-Govt Small Cap 91324PEB4 UNITEDHEALTH GROUP INC 11/08/2021 Demo-Govt Small Cap 931142EX7 WALMART INC 09/08/2022 Demo-Govt Small Cap 96130ASC3 Westpac Banking Corporation - New York Branch 02/22/2023 Demo-Govt Large Cap CCYUSD Cash --- Demo-Govt Large Cap CCYUSD Receivable --- Demo-Govt Small Cap CCYUSD Cash --- Demo-Govt Small Cap CCYUSD _ Receivable --- Demo-Govt Large Cap LGIP DEMO LGIP DEMO 02/01/2022 Demo-Govt Large Cap US46646RAH66 JPMDB 2016-C4 A2 05/02/2022 * Weighted by: Market Value + Accrued. * Holdings Displayed by: Lot. Final Maturity Book Value Accrued Balance Market Value + Accrued 08/15/2025 2,268,346.88 5,875.00 2,179,191.00 08/31 /2024 4,033,454.31 4,258.24 3,854,578.24 10/31/2024 4,552,236.48 28,247.28 4,344,017.28 01/31/2025 3,039,761.95 6,949.73 2,856,139.73 02/28/2025 2,689,048.08 2,586.88 2,551,143.88 03/31 /2025 2,894,114.60 39.62 2,703,158.62 04/30/2025 1,999,424.66 3,138.59 1,857,278.59 04/30/2025 2,990,511.49 4,707.88 2,785,917.88 05/31/2025 4,963,207.99 4,200.82 4,614,750.82 12/15/2023 2,299,539.42 848.36 2,276,583.36 01/15/2024 3,998,623.57 1,059.78 3,941,059.78 04/15/2024 5,001,524.88 8,657.79 4,875,857.79 05/15/2024 2,999,018.39 2,832.88 2,907,552.88 07/15/2024 3,497,557.03 2,781.93 3,366,351.93 09/15/2024 4,996,881.42 824.18 4,765,674.18 10/15/2024 1,794,210.94 5,194.67 1,718,506.67 11 /15/2024 4,994,418.32 14,164.40 4,763,564.40 03/31/2027 4,915,159.50 341.53 4,645,241.53 04/30/2027 4,970,797.40 57,540.76 4,733,690.76 05/31 /2027 2,949,930.41 26,465.16 2,815,535.16 06/30/2027 5,035,183.95 41,066.58 4,792,416.58 08/31 /2027 4,953,117.48 13,307.01 4,733,057.01 12/31/2027 3,284,280.59 31,826.60 3,182,181.60 05/15/2024 1,133,387.26 2,358.28 1,101,900.88 09/09/2027 1,001,508.57 2,413.89 967,493.89 02/16/2024 3,799,103.58 128,910.78 3,923,237.38 09/30/2023 56,133,288.66 0.00 56,133,288.66 09/30/2023 52,511.33 0.00 52,511.33 09/30/2023 -218,578.29 0.00 -218,578.29 09/30/2023 149,243.94 0.00 149,243.94 09/30/2023 10,000,000.00 0.00 9,994,210.70 12/17/2049 353,507.78 849.07 325,142.89 03/31/2025 402,750,406.27 1,060,750.61 387,696,783.16 CLEARWATER A N A L Y T I C S e City of La Quinta Returns Demo-Govt Agg (85852) Base Currency: USD As of 09/30/2023 Return to Table of Contents Dated: 03/27/2024 4% 3% 2-.676%2.61"2% 2% 1.632% 1.314% 1 % 0.291% 0.382% 0.407% 0.563% 0-746% 1.045% C u 0.149 k 0.117% ' N -0.135% _ � % -0.479% o _ -2 % 1-.64,4"/ -3% 2.738 ro -4% -4.052% -5% Prior Month Prior Quarter Prior Year Trailing Month Trailing Quarter Trailing Year • Total Return, Net of Fees • Income Return, Net of Fees • Price Return, Net of Fees Weighted Average Index Return Period Period Begin Period End Total 'Return, Net of Fees Income Return, Net of Fees Price Return, Net of Fees Prior Month 08/01/2023 08/31/2023 0.291 % 0.149% 0.142% Prior Quarter 04/01/2023 06/30/2023 0.030% 0.407% -0.378% Prior Year 01/01 /2022 12/31/2022 -2.738 % 1.314 % -4.052 % Trailing Month 09/01/2023 09/30/2023 0.014% 0.149% -0.135% Trailing Quarter 07/01 /2023 09/30/2023 0.563 % 0.446 % 0.117% Trailing Year 10/01/2022 09/30/2023 2.676% 1.632% 1.045% Account Index Index Start Date Index End Date Demo-Govt Large Cap ICE BofA 1-3 Year US Treasury Index 07/22/2002 12/31/2018 Demo-Govt Large Cap ICE BofA 1-3 Year AAA -AA US Corporate & Government Index 01/01/2019 --- Demo-Govt Small Cap ICE BofA 1-3 Year AAA -A US Corporate & Government Index 07/16/2002 --- Demo-Govt Agg ICE BofA 1-3 Year AAA -A US Corporate & Government Index 07/16/2002 --- Net of Fees (includes management and trading). Returns are actual and have not been annualized. No Tax Adjustment. Note that data will not exist prior to the performance inception date of: 11/18/2010. Reported Index Return is always Total Return. Returns for an aggregate account are based on the weighted average of its simple accounts, unless historical returns have specifically been provided for the aggregate, in which case the provided historical returns will be used for the Account Total row. The index total or total weighted benchmark returns for an aggregate account are also based on the weighted average of the index returns of its simple accounts. H.