Loading...
HomeMy WebLinkAboutAudit Committee-Agenda Packets-07/21/2026 City of Colleyville Page 1 CITY OF COLLEYVILLE AUDIT COMMITTEE AGENDA 100 Main Street, Colleyville, Texas, 76034 City Manager's Conference Room Third Floor - City Hall TUESDAY, JULY 21, 2026 - 4:30 PM 1. CALL TO ORDER 2. APPROVAL OF MINUTES 2a May 12, 2026 3. REGULAR AGENDA ITEMS 3a Approval of the City of Colleyville Investment Policy Annual Review 3b Quarterly Investment report as of June 30, 2026 4. ADJOURNMENT I hereby certify this agenda was posted on City Hall bulletin boards Wednesday, July 15, 2026, by 5:00 p.m. Christine Loven, TRMC City Secretary A quorum of any Colleyville board, commission, or committee may be present at this meeting. Any matter on this agenda may be opened for public comment and discussion at the discretion of the governing body. If you plan to attend this public meeting and have a disability that requires special accommodations, please advise the City Secretary at least 48 hours in advance at 817.503.1130, and reasonable accommodations will be made to assist you. City of Colleyville Page 1 CITY OF COLLEYVILLE AUDIT COMMITTEE MINUTES 100 Main Street, Colleyville, Texas, 76034 City Manager's Conference Room - Third Floor TUESDAY, MAY 12, 2026 - 5:15 PM 1. CALL TO ORDER City Secretary Christine Loven called the meeting to order at 5:15 p.m. and called the roll. PRESENT: Committee members Brandi Elder, Scotty Richardson, and Mark Alphonso. ALSO PRESENT: Mayor Bobby Lindamood, Accounting Manager Karen Hines, City Manager Jerry Ducay, Assistant City Manager Mark Wood, and City Secretary Christine Loven. 2. APPROVAL OF MINUTES February 17, 2026 The February 17, 2026 minutes were approved as presented. 3. REPORTS Quarterly investment report as of March 31, 2026 Assistant City Manager Mark Wood stated Finance Director Cassie Smith is out and he will provide the report overview. Manager Wood reviewed the composition of the City’s portfolio, to include the investment pools and noted as projected, the returns are down. He stated the City will continue to monitor investments and optimize earnings. There was general discussion regarding the rates of return. 4. ADJOURNMENT The meeting adjourned at 5:23 p.m. Minutes taken and prepared by: Christine Loven, TRMC City Secretary City of Colleyville Page 1 CITY OF COLLEYVILLE AUDIT COMMITTEE BRIEFING Agenda Number 3a Agenda Date 7/21/2026 Number 3a Type Regular Agenda Items Department Finance Title Approval of the City of Colleyville Investment Policy Annual Review Explanation Finance Director Cassie Smith will review the City's Investment Policy and discuss any recommendations. Attachments 1. City of Colleyville Investment Policy-2026 CITY OF COLLEYVILLE INVESTMENT POLICY AND STRATEGY Reviewed July 21, 2026 1 FORMAL ADOPTION This Investment Policy is authorized by the City Council of the City of Colleyville (the “City”) in accordance with Chapter 2256, Texas Government Code (the Public Funds Investment Act or “PFIA”), as amended. SCOPE This Policy applies to all of the investment activities of the City, excluding the deferred compensation plan, the City’s participation in the Texas Municipal Retirement System, or investments donated to the City for a particular purpose or donated according to terms specified by the donor. Except for cash in certain restricted and special funds, the City will combine cash balances from all funds to maximize investment earnings. This Policy establishes guidelines for those who can invest City funds, for how City funds will be invested, and for when and how a periodic review of investments will be made. The Investment Policy is divided into two sections: General Investment Policy and Investment Strategy. GENERAL INVESTMENT POLICY The following are general requirements of the City Investment Policy. The general requirements address issues and requirements common to all funds separately invested by the City. Following the general requirements are specific requirements that relate to either specific fund types or funds managed by the City. INVESTMENT OBJECTIVES The City investment objectives are as follows: 1) To preserve capital; the most important investment objective. 2) To provide liquidity. 3) To optimize earnings within the constraints of Numbers 1 and 2 above. TO PRESERVE CAPITAL 1) To preserve capital, the City will only invest in the following: a. Time Deposits, Certificates of Deposit, and other interest bearing accounts at an authorized depository of the City. Investments are limited by the amount of the combination of federal depository insurance, pledged collateral and any surety bond or letter of credit of the depository. Deposits issued: i. by a depository institution that has its main office or a branch office in this state that are: 1. Guaranteed or insured by the Federal Deposit Insurance Corporation, or its successor; or 2. Secured in compliance with COLLATERAL; or 3. Secured in any other manner and amount provided by law for deposits of the investing entity. CITY OF COLLEYVILLE INVESTMENT POLICY AND STRATEGY (CONTINUED) Reviewed July 21, 2026 2 ii. In addition to the authority to invest funds in deposits under Section 1 a., an investment in deposits made in accordance with the following conditions is an authorized investment: 1. The funds are invested through a depository institution or broker that has its main office or a branch office in the state of Texas. Additionally, a broker is required to be selected from a list of approved broker dealers adopted by the City; 2. The depository institution or broker arranges for the deposit of the funds in certificates of deposit in one or more federally insured depository institutions, wherever located, for the account of the City; 3. The full amount of the principal and accrued interest of each of the certificates of deposit is insured by the United States or an instrumentality of the United States; and 4. If appointed by the City, the depository institution or broker may act as custodian for the City with respect to the deposits issued for the account of the City. The investment in Certificates of Deposit is limited to seventy-five percent (75%) of the Portfolio b. Direct obligations of the United States including Treasury Bills, Treasury Notes, Treasury Bonds, Treasury Strips, and instruments guaranteed by the Full Faith and Credit of the United States; for reporting purposes, these securities will be defined as Government Securities. c. Obligations of agencies and instrumentalities of the United States. For reporting purposes, the investment in agency and instrumentality securities will be categorized as Agency Securities. The investment in agencies and instrumentalities is limited to seventy-five percent (75%) of the Portfolio. Investments in agencies or instrumentalities will be diversified among the agencies and instrumentalities. d. A Texas local government investment pool, as authorized by PFIA, which is continuously rated AAA. Participation in any pool must be authorized by resolution of the City Council. Pools investing in commercial paper are permissible up to five percent (5%) of total pool investments. The investment in pools is limited to seventy-five percent (75%) of the Portfolio. Investments in pools will be diversified among the City’s authorized pools. e. A no-load money market mutual fund that is continuously rated AAA or AAAm by at least one nationally recognized rating agency; is regulated by the Securities and Exchange Commission; complies with the requirements of a money market mutual fund; and includes in its investment objectives the maintenance of a stable net asset value of $1.0000 per share. The investment in money market mutual funds is limited to ten percent (10%) of the Portfolio. f. Obligations of states, agencies, counties, cities, and other political subdivisions of any state rated AA- or above or its equivalent by a nationally recognized rating agency. Total investment in these securities would be limited to ten percent (10%) of the portfolio. g. Bond proceeds may be invested in fully collateralized flexible repurchase agreements (“flex repos”), or similar structured investment, with a defined maturity date not to exceed the final scheduled construction expenditure date. Flexible repurchase agreements must only be entered into with a primary government securities dealer as defined by the Federal Reserve or a financial institution doing business in the State of Texas. They must be secured by a combination of cash and obligations of the United States or its agencies and instrumentalities, which are pledged to the City and deposited with a third party custodian approved by the City. The collateralization percentage shall be maintained at or above one hundred two percent (102%) of the outstanding flex repo balance along with any interest accrued but not yet paid. All repurchase agreement transactions shall be governed by a signed repurchase agreement, which requires that the securities being purchased by the City or cash held by the City to be pledged to the City, held in an account in the City’s name and deposited at the time the investment is made with the City or with a third party selected and approved by the City. CITY OF COLLEYVILLE INVESTMENT POLICY AND STRATEGY (CONTINUED) Reviewed July 21, 2026 3 2) To preserve capital, the City will not employ any investment strategy that is inherently risky. a. The City will not borrow funds using investment securities as collateral and reinvest the proceeds in other investment securities. Approved no-load money market mutual funds in 1(g) above are allowed to use Reverse Repurchase Agreements. b. The City will not take a position in a security for speculation or only for anticipated capital appreciation. c. While a designated Investment Officer will be empowered to buy and sell securities on behalf of the City, the City will use a buy and hold strategy for most investments. d. The City will diversify investments. 3) To preserve capital, the City will not invest in any securities that are inherently risky: a. Obligations whose payment represents the coupon payments on the outstanding principal balance of the underlying mortgage-backed security collateral and pays no principal. b. Obligations whose payment represents the principal stream of cash flow from underlying mortgage-backed security collateral and bears no interest. c. Obligations the interest rate of which is determined by an index that adjusts opposite to the changes in a market index. d. Collateralized mortgage obligations that have a stated final maturity date of greater than 10 years. e. Any other obligations similar to items 3(a) through 3(d) above where small changes in market interest rates can produce potentially large changes in the value of a security or substantially extend the life of the security. TO PROVIDE LIQUIDITY 1) The Investment Portfolio will remain sufficiently liquid to meet the cash flow requirements that might be reasonably anticipated. Liquidity shall be achieved by matching investment maturities with forecasted cash flow requirements; investing in securities with active secondary markets; maintaining appropriate Portfolio diversification; and investing with overnight liquidity. Since projected cash flows are estimates, it is the stated goal to invest in a manner that provides excess funds for reinvestment and additional liquidity each month. 2) In conjunction with (1) above, the City will ladder investment maturities. That is, the Portfolio will be structured so that investments mature all along the yield curve and generally target anticipated outflows. However, it will not be necessary to completely cover all outflows for a month before investing further out on the yield curve. By not fully investing every month, the City will be better able to utilize all investment options (especially more short-term securities) available in the Investment Policy. With the laddered Portfolio structure, there would be a steady stream of funds to the Portfolio and high quality short-term securities available if securities needed to be sold before maturity. In conjunction with the above ladder approach, maturities beyond ninety (90) days will be diversified along the yield curve to avoid a concentration of maturities in one or more months. 3) Additional liquidity will be provided through attractive cash equivalent investment options. The combined cash equivalent investment should be a minimum of fifteen percent (15%) of the overall Portfolio. CITY OF COLLEYVILLE INVESTMENT POLICY AND STRATEGY (CONTINUED) Reviewed July 21, 2026 4 TO OPTIMIZE EARNINGS 1) Within the constraints of preservation, safety, and liquidity, it is the City’s goal to optimize earnings. 2) City funds will be deposited daily to optimize funds available for investment. 3) Idle cash will be invested until needed to pay obligations. 4) The Portfolio will be structured to provide excess funds for reinvestment so that in periods of rising interest rates, funds are available for reinvestment. In periods of falling rates maturities have been laddered to lock in higher returns. PORTFOLIO COMPOSITION All investments purchased on behalf of the City will have a maturity date that does not exceed five (5) years. At all times at least 80% of the Portfolio must be in investments with maturities of two years or less. No more than 20% of the Portfolio can be held in maturities ranging from two to five years. The maximum dollar weighted average maturity of the Portfolio cannot exceed one year. Individual fund-types may have more restrictive parameters. DESIGNATED INVESTMENT OFFICER The Finance Director and the Accounting Manager are the designated Investment Officers. After the investment transaction is completed, an authorization of investment form will be executed for all City investments. The Finance Director or the Accounting Manager must sign the form approving investments. Also, the City Manager or an Assistant City Manager must co-sign the form acknowledging the investments. INVESTMENT COMMITTEE The Investment Officers of the City along with one other member of the management team will be members of the Investment Committee. The role of the committee will be to review and monitor quarterly reports, make recommendations on changes in the Investment Policy, approve training sources, and approve brokers/dealers. AUDIT COMMITTEE The quarterly investment report and any changes in the Investment Policy will be taken through the Audit Committee before being taken, sent, or presented to the City Council. PERCENTAGE TESTS This Policy contains several percentage tests. Because of daily changes in cash, the Portfolio can be in compliance one day and not in compliance the next day. The Portfolio limits should be adhered to as investments are purchased; however, investments would not have to be sold to comply with Portfolio limits. MARKET PRICE VALUATION Investment reports will include market price valuations of the Portfolio from a third-party pricing agency or through a source independent of the transaction. CITY OF COLLEYVILLE INVESTMENT POLICY AND STRATEGY (CONTINUED) Reviewed July 21, 2026 5 PERFORMANCE STANDARD The performance standard of the Portfolio will be calculated based on the weighted average yield to maturity. MONITORING Not less than quarterly, the Investment Officers or designee will monitor the credit rating for each held investment that has a Public Fund Investment Act required minimum rating. Prudent measures will be taken to liquidate an investment that is downgraded to less than the required minimum rating. Except as stated above, the City is not required to liquidate investments that were authorized investments at the time of purchase. SETTLEMENT OF SECURITIES All settlements of security transactions will be by “delivery versus payment.” INTERFUND TRANSFERS From time to time some City funds (for example: General Fund, Drainage Fund, and Utilities Fund) will become over/under invested while the overall Portfolio is compliant with the City’s Investment Policy. Investment transfers can be made to correct funds being over/under invested; however, any transfer would have to be suitable for the fund. Investment transfers will be made between funds at book value plus accrued interest. However, transfers involving tax-exempt bond proceeds shall comply with applicable IRS regulations. COLLATERAL 1) All bank deposits not insured by federal depository insurance will be collateralized in compliance with the Public Funds Collateral Act and this Policy. Any pledged securities held by an independent third party under a custody arrangement must give the City unconditional rights and claims to the collateral. In lieu of the above collateral requirement the depository may provide a surety bond or letter of credit issued by an agency or instrumentality in compliance with the Public Funds Investment Act. Deposits secured with pledged marketable securities shall have a market value equal to or greater than 102% of the principal plus accrued interest of the deposit, less any amount insured by the FDIC. Deposits secured with letters of credit shall have 100% of principal plus anticipated interest of the deposit, less any amount insured by the FDIC. 2) The City will accept as collateral any securities eligible under the Public Funds Collateral Act reserving the right to accept or reject any individual securities. 3) The City will routinely compare deposit collateral to deposit levels. 4) Authorized depositories will be required to sign a depository agreement with the City. The collateralized deposit portion of the agreement shall define the City’s rights to the collateral in case of default, bankruptcy or closing and shall establish a perfected security interest in compliance with Federal and State regulations, including: a. The agreement must be in writing; CITY OF COLLEYVILLE INVESTMENT POLICY AND STRATEGY (CONTINUED) Reviewed July 21, 2026 6 b. The agreement must be executed by the depository and the City contemporaneously with the acquisition of the asset; c. The agreement must be approved by the Board of Directors or designated committee of the depository and a copy of the meeting minutes must be delivered to the City; and d. The agreement must be part of the depository’s “Official Record” continuously since its execution. SAFEKEEPING Securities owned by the City should be held in a manner that the safekeeping method will be categorized as “Least Risk” for Governmental Accounting Standards Board (GASB) purposes: 1) All securities will be held by the City’s third-party safekeeping agent in an account in the City’s name as evidenced by safekeeping receipts of the institution with which the securities are deposited. 2) All non-physical securities will be safekept at the Federal Reserve or at the City’s third-party safekeeping agent. COMPETITIVE BIDDING The City will practice competitive bidding orally, by telephone, electronically, or in any combination of these methods when purchasing an investment to help strengthen the investment process. All investments, other than the placement of funds in local government investment pools, money market accounts, and securities which are deemed to be made at prevailing market rates, will be competitively bid, with at least three bids, and placed with providers offering the best value to the City. The City reserves the right to reject the most financially favorable bid if it is potentially disruptive to its investment strategy. INTERNAL CONTROLS The Finance Director is responsible for establishing and maintaining an internal control structure designed to ensure that the assets of the City are protected from loss, theft or misuse. The internal control structure shall be designed to provide reasonable assurance that these objectives are met. The concept of reasonable assurance recognizes that (1) the cost of a control should not exceed the benefits likely to be derived; and (2) the valuation of costs and benefits requires estimates and judgments by management. The internal controls shall address the following points: 1) Avoidance of collusion, 2) Separation of transactions authority from accounting and record keeping, 3) Third-party safekeeping and custody, 4) Clear delegation of authority of subordinate staff members, and 5) Written confirmation for transactions for investments and wire transfers. CITY OF COLLEYVILLE INVESTMENT POLICY AND STRATEGY (CONTINUED) Reviewed July 21, 2026 7 STANDARD OF CARE The standard of care used by the City shall be the “prudent person rule” and shall be applied in the context of managing the overall Portfolio within the applicable legal constraints. The Public Funds Investment Act states: “Investments shall be made with judgment and care, under prevailing circumstances, that a person of prudence, discretion, and intelligence would exercise in the management of the person’s own affairs, not for speculation, but for investment, considering the probable safety of capital and the probably income to be derived.” STANDARDS OF ETHICS All Investment Officers shall file with the Texas Ethics Commission and the City Council a statement disclosing any personal business relationship with an entity seeking to sell investments to the City or any relationship within the second degree by affinity or consanguinity to an individual seeking to sell investments to the City. REPORTING Investment performance will be monitored and evaluated by the Investment Officers. The Investment Committee will provide a quarterly comprehensive report signed by all Investment Officers to the Audit Committee and then forward it on to the City Council. This investment report shall be in compliance with the Public Funds Investment Act. AUDITS The City, in conjunction with its annual financial audit, shall perform a compliance audit of management controls on investments and adherence to the City’s Investment Policy and strategies. The quarterly investment reports must also be reviewed annually by the independent auditor, as part of the City’s annual audit, and the result of the review shall be reported to the City Council by that auditor. REVIEW AND AMENDMENT The City Council shall review and adopt this Policy at least annually. Amendments must be approved by the Investment Committee and adopted by the City Council. Investment Officers will review the Policy for any necessary changes as a result of each Texas Legislative session and include such changes in the annual review and update to the Policy for City Council approval. The timing of amendments and approval of legislative changes to the Policy must align with the required effective dates assigned by the Legislation. TRAINING In order to have qualified and capable Investment Officers, officers will attend investment training and receive not less than ten (10) hours of instruction relating to investment responsibilities and that is in compliance with the Public Funds Investment Act within 12 months of taking office or assuming investment duties. After the initial training, Investment Officers are required to take eight (8) hours of training every two years aligned with the City’s fiscal year. The Investment Committee will approve all investment training sources. CITY OF COLLEYVILLE INVESTMENT POLICY AND STRATEGY (CONTINUED) Reviewed July 21, 2026 8 PRUDENT INVESTMENT MANAGEMENT The designated Investment Officers shall perform their duties in accordance with the adopted Investment Policy and internal procedures. Investment Officers acting in good faith and in accordance with these policies and procedures shall be relieved of personal liability. PRIMARY DEPOSITORY In Compliance with Local Government Code, Chapter 105 – Depositories for Municipal Funds, a Primary Depository shall be selected through the City’s banking services procurement process, which shall include a formal request for application (RFA). The selection of a primary depository will be determined by evaluation of the “most advantageous” criteria during the RFA process, and may include the following selection criteria: 1) The ability to qualify as a depository for public funds in accordance with state law, 2) The ability to provide requested information or financial statements for the periods specified, 3) The ability to meet the minimum required items in the banking RFA, 4) Complete response to all required items on the RFA form, and 5) Competitive net banking service cost, consistent with the ability to provide an appropriate level of service. BROKER/DEALERS Investment Broker/Dealers shall adhere to the spirit, philosophy and specific term of the Policy and shall avoid recommending or suggesting transactions outside the “Standard of Care.” The Investment Committee will perform selection of Broker/Dealers at least annually. The Investment Committee will establish criteria to evaluate Broker/Dealers, including: 1) Adherence to the City’s policies and strategies. 2) Transaction pricing. 3) Responsiveness to request for services, information and open communication. 4) Understanding of the inherent fiduciary responsibility of investing public funds. 5) Similarity in philosophy and strategy with the City’s investment objectives. Selected Broker/Dealers shall provide timely transaction confirmations. The approved Broker/Dealers are authorized to engage in investment transactions with the City and can be revised periodically by the Investment Committee. It may become necessary to revise Broker/Dealers during the year to ensure competition and quality service to the City. Therefore, the Investment Committee can add or subtract Broker/Dealers during the year. INVESTMENT POLICY CERTIFICATION All business organizations (local government investment pools and discretionary investment management firms) must sign a certification acknowledging that the organization has received and reviewed the City’s CITY OF COLLEYVILLE INVESTMENT POLICY AND STRATEGY (CONTINUED) Reviewed July 21, 2026 9 Investment Policy and that reasonable procedures and controls have been implemented to preclude investment transactions that are not authorized by the City’s Policy and in accordance with the PFIA. The City shall not transact with a business organization prior to receiving the certification above. WIRE/ACH PROCEDURES The City is allowed to initiate wires/ACH through a City authorized depository. The individuals authorized to perform wires/ACH transactions include the Finance Director, the Accounting Manager, the accountant, and the accounting specialist. Transactions may be done as repetitive or non-repetitive transactions. Repetitive wires/ACH can be set up at a City depository bank with approval of two of the authorized individuals. Thereafter, repetitive wires may be completed with approval of one of the authorized individuals. Non-repetitive wires/ACH will require approval from two of the authorized individuals. INVESTMENT STRATEGY OPERATING FUND The operating funds include the General Fund and other Special Revenue Funds of the City. The primary objective in investing available funds is the preservation and safety of principal. All of the allowable investments mentioned in the Investment Policy would be suitable for the operating funds. The investments should be structured so that investments mature to meet cash needs and have excess funds for additional liquidity. In the investment of funds decision, the security with the best return within a three to six month range will be selected with the intention of investing in the other maturities at a later date. This strategy allows the City to take full advantage of the yield curve and all investments securities allowed in the Investment Policy. Short-term securities such as discount notes can be used for shorter maturities, while treasury notes and other agency securities can be used for longer-term maturities. At least some of the purchases will be in U.S. Treasuries or Agency securities, which are both liquid and marketable. Investments in Agency securities should be diversified among different Government Agencies. Investments will be laddered along the yield curve to optimize earnings. DEBT SERVICE AND DEBT SERVICE RESERVE FUNDS All Debt Service Reserve funds will be kept in local government investment pools, money market mutual funds/accounts, or certificates of deposits in the unlikely event the funds would be needed for a shortfall in making debt service payments. Debt Service funds will be accumulated in local government investment pools or money market funds/accounts until needed for scheduled debt service payments. The primary objective in investing available funds is the preservation and safety of principal. Yield will be dictated by short-term rates. PROPRIETARY FUNDS Proprietary funds include both Enterprise Funds and Internal Service Funds. These funds provide for the operations, capital replacement, and future claims of each functional area. Specifically, the City maintains only two proprietary funds, the Utilities Fund and the Drainage Fund. All of the allowable investment securities would be suitable for the proprietary funds. The primary objective in investing available funds is the preservation and safety of principal. The investments should be structured so that maturities are scheduled to meet cash needs and have excess funds for additional liquidity. In the investment of funds decision, the security with the best return within a three to six month range will be selected with the intention of investing in the other maturities at a later date. This strategy allows the City to take full advantage of the yield curve and all investments securities allowed in the Investment Policy. Short-term securities such as discount notes can be used for shorter maturities, while treasury notes and other agency securities can be CITY OF COLLEYVILLE INVESTMENT POLICY AND STRATEGY (CONTINUED) Reviewed July 21, 2026 10 used for longer-term maturities. Most of the purchases will be in U.S. Treasuries or Agency securities, which are both liquid and marketable. Investments in Agency securities should be diversified among different Government Agencies. Investments will be laddered along the yield curve to optimize earnings. CAPITAL PROJECT FUNDS Capital Project funds are used to account for the construction of various City improvements including General Construction and other capital improvement funds. All allowable City investments would be suitable for the capital projects funds. The cash should be invested to correspond to the estimated aggregate cash draws on the various projects. At least some of the purchases will be in U.S. Treasuries and Agency securities, which provide both liquidity and marketability. Investments in Agency securities should be diversified among the various Government Agencies. TRUST FUNDS Trust funds will be invested in accordance with provisions of the applicable trust agreement. If there are not specific investment requirements, trust funds will be invested in a similar manner as operating funds. In the investment of funds decision, the security with the best return within a three to six month range will be selected with the intention of investing in the other maturities at a later date. This strategy allows the City to take full advantage of the yield curve and all investments securities allowed in the Investment Policy. Short-term securities such as discount notes can be used for shorter maturities, while treasury notes and other agency securities can be used for longer-term maturities. The primary objective in investing available funds is the preservation and safety of principal. BOND PROCEEDS The investment of bond proceeds (excluding reserve and debt service funds) shall generally be limited to the anticipated cash flow requirement or the “temporary period,” as defined by Federal tax law. During the temporary period bond proceeds may be invested at an unrestricted yield. After the expiration of the temporary period, bond proceeds subject to yield restriction shall be invested considering the anticipated cash flow requirements of the funds and market conditions to achieve compliance with the applicable regulations. Bond proceeds may be invested in a single flexible repurchase agreement if the Investment Officers determine that such an investment has advantage to comply with Federal arbitrage restrictions or to facilitate arbitrage record keeping and calculation. A flexible repurchase agreement provides that disbursements are allowed in the amount necessary to satisfy reasonable expenditure requests and the defined termination date of the investment does not exceed the estimated expenditure date of the bond proceeds. CITY OF COLLEYVILLE INVESTMENT POLICY AND STRATEGY APPENDIX 2 – APPROVED TRAINING PROVIDERS i AGENCIES – Federal agency securities and/or Government-sponsored entities. BENCHMARK – A comparative base for measuring the performance or risk tolerance of the investment portfolio. A benchmark should represent a close correlation to the level of risk and the average duration of the portfolio’s investments. BROKER – A broker brings buyers and sellers together for a commission. CERTIFICATE OF DEPOSIT – A time deposit with a specific maturity evidenced by a certificate. CDAR – A time deposit (certificate of deposit) that breaks up large deposits over the FDIC limit and places them across a network of over 3,000 banks and savings associations across the US. COLLATERAL – Securities, evidence of deposit, or other property which a borrower pledges to secure repayment of a loan. Also refers to securities pledged by a bank to secure deposits of public monies. DEALER – A dealer, as opposed to a broker, acts as a principal in all transactions, buying and selling for his own account. DELIVERY VERSUS PAYMENT – Delivery verses payment is the delivery of a security and there is an exchange of money after the delivery of the security. DISCOUNT SECURITIES – Non-interest bearing money market instruments that are being issued at a discount and redeemed at maturity for full face value, e.g. Treasury Bills. DIVERSIFICATION – Dividing instruments among securities offering independent returns. FEDERAL CREDIT AGENCIES – Agencies of the Federal government set up to supply credit to various classes of institutions and individuals e.g. savings and loans, small business firms, students, farmers, farm cooperatives, and exporters. FEDERAL DEPOSIT INSURANCE CORPORATION (FDIC) – A federal agency that insures bank deposits, currently up to $250,000 per deposit. FEDERAL HOME LOAN BANKS (FHLB) – Government sponsored regional wholesale banks which lend funds and provide correspondent banking services to member commercial banks, thrift institutions, credit unions and insurance companies. The mission of the FHLB is to liquefy the housing related assets of its members who must purchase stock in their district bank. FEDERAL NATIONAL MORTGAGE ASSOCIATION (FNMA) – FNMA, like GNMA was chartered under the Federal National Mortgage Association Act in 1938. It is a federal corporation and the largest single provider of residential mortgage funds in the United States. FNMA’s securities are highly liquid and widely accepted. FNMA assumes and guarantees that all security holders will receive timely payment of principal and interest. GOVERNMENT NATIONAL MORTGAGE ASSOCIATION (GNMA) – Securities influencing the volume of bank credit guaranteed by GNMA and issued by mortgage bankers, commercial banks, savings and loan associations. Security holder is backed by the full faith and credit of the US Government. LIQUIDITY – An asset that can be converted quickly and easily to cash. LOCAL GOVERNMENT INVESTMENT POOL – An investment by local governments in which their money is pooled as a method for managing local funds. MARKET VALUE – The price at which a security is trading and could presumably be purchased or sold. CITY OF COLLEYVILLE INVESTMENT POLICY AND STRATEGY APPENDIX 2 – APPROVED TRAINING PROVIDERS ii MASTER REPURCHASE AGREEMENT – A written contract that establishes each party’s rights in the transactions. A master agreement will specify, among other things, the right of the buyer-lender to liquidate the underlying securities in the event of default by the seller-borrower. MATURITY – The date upon which the principal or stated value of an investment becomes due and payable. MUTUAL FUND – An investment company that pools money and can invest in a variety of securities, including fixed-income securities and money market instruments. Mutual funds are regulated by the Investment Company Act of 1940 and must abide by Securities and Exchange disclosure guidelines. PORTFOLIO – Collection of securities held by an investor. PRIMARY DEALER – A group of government securities dealers who submit daily reports of market activity and positions and monthly financial statements to the Federal Reserve Bank of New York and are subject to informal oversight. PRUDENT PERSON RULE – An investment standard outlining fiduciary responsibilities of public funds investors relating to investment practices. RATE OF RETURN – The yield obtainable on a security based on its purchase price or its current market price. REPURCHASE AGREEMENT – An agreement of one party to sell securities at a specified price to a second party and a simultaneous agreement of the first party to repurchase the securities at a specified price or at a specified later date. REVERSE REPURCHASE AGREEMENT – An agreement of one party to sell securities at a specified price to a second party and a simultaneous agreement by the first party to resell the securities at a specified price to the second party on demand or at a specified date. SAFEKEEPING – Holding of assets (e.g. securities) by a financial institution. TREASURY BILLS – A non-interest bearing discount security issued by the US Treasury to finance the national debt. Most bills are issued to mature in three months, six months, or one year. The yields on these bills are monitored closely for interest rate trends. TREASURY BONDS – Long term US government debt securities with maturities of ten to thirty years. TREASURY NOTES – Intermediate term US government debt securities with maturities of one to ten years. YIELD – The current rate of return on an investment security generally expressed as a percentage of the securities current price. CITY OF COLLEYVILLE INVESTMENT POLICY AND STRATEGY APPENDIX 2 – APPROVED TRAINING PROVIDERS iii Current Approved Broker Dealers 1) Duncan-Williams, Inc. 2) Raymond James 3) Multi-Bank Securities, Inc. (MBS) 4) Wells Fargo 5) Hilltop Securities CITY OF COLLEYVILLE INVESTMENT POLICY AND STRATEGY APPENDIX 2 – APPROVED TRAINING PROVIDERS iv Current Approved Training Providers 1) North Central Texas Council of Governments (NCTCOG) 2) Government Treasurers’ Organization of Texas (GTOT) 3) Government Finance Officers Association of Texas (GFOAT) 4) Texas Municipal League (TML) 5) University of North Texas Center for Professional Development (UNT) City of Colleyville Page 1 CITY OF COLLEYVILLE AUDIT COMMITTEE BRIEFING Agenda Number 3b Agenda Date 7/21/2026 Number 3b Type Regular Agenda Items Department Finance Title Quarterly Investment report as of June 30, 2026 Explanation Finance Director Cassie Smith will review the quarterly investment report. Attachments 1. 2026-06 Investment Report 2. Quarterly Investment Report Presentation 3rd Qtr FY26 Asset Category Face Amount/Shares Market Value Book Value % of Portfolio YTM @ Cost Days To Maturity CD | Negotiable (Brokered) | 100%7,087,000.00 7,077,049.20 7,087,000.00 9.47 3.99 289 Money Market - Mutual Fund | 10%2,184,433.54 2,184,433.54 2,184,433.54 2.92 0.00 1 Operating Cash | TBD%8,653,024.72 8,653,024.72 8,653,024.72 11.56 3.13 1 TX LGIP | 75%51,338,423.90 51,338,423.90 51,338,423.90 68.60 3.62 1 TX LGIP Commerical Paper | 5%1,960,436.56 1,960,436.56 1,960,436.56 2.62 3.75 1 US Agency | 75%3,613,000.00 3,601,976.76 3,613,000.00 4.83 3.72 402 Total / Average 74,836,318.72 74,815,344.68 74,836,318.72 100.00 3.50 48 DateDateKaren Hines, Accounting ManagerCassie Smith, Finance Director Compliance | The City of Colleyville was in compliance with its investment policy and the Public Funds Investment Act. Specifically, the City only purchases securities from brokers who have reviewed the investment policy and signed a statement agreeing to comply with it. The maturity dates of the City’s investments will meet the anticipated cash flow needs of the City. City of Colleyville | Texas MONTHLY INVESTMENT REPORT June 30, 2026 1 7/8/267/8/2026 Asset Category Allocation Asset Category Market Value 3/31/2026 % of Portfolio 3/31/2026 Market Value 6/30/2026 % of Portfolio 6/30/2026 CD | Negotiable (Brokered) | 100%5,836,362.90 7.63 7,077,049.20 9.55 Money Market - Mutual Fund | 10%271,505.26 0.35 2,184,433.54 2.95 Operating Cash | TBD%13,268,798.73 17.34 8,653,024.72 11.67 TX LGIP | 75%50,218,210.01 65.62 50,661,105.24 68.33 TX LGIP Commerical Paper | 5%1,942,172.90 2.54 1,960,436.56 2.64 US Agency | 75%4,991,534.07 6.52 3,601,976.76 4.86 Total / Average 76,528,583.87 100.00 74,138,026.02 100.00 Portfolio Holdings as of 3/31/2026 Portfolio Holdings as of 6/30/2026 % TBD, pending investment policy clarification Begin Date: 3/31/2026, End Date: 6/30/2026Investment Policy Compliance Distribution by Asset Category - Market Value City of Colleyville | TX 2 Month Beginning BV + Accrued Interest Interest Earned During Period-BV Realized Gain/Loss-BV Investment Income-BV Average Capital Base-BV TRR-BV Annualized TRR-BV Treasury 1 Year 1/31/2026 74,709,097.52 189,508.21 5,348.10 194,856.31 75,104,829.34 0.26 3.16 3.51 2/28/2026 75,886,641.64 176,360.15 0.00 176,360.15 77,561,862.33 0.23 2.76 3.48 3/31/2026 79,279,410.18 198,826.59 0.00 198,826.59 78,503,416.29 0.25 3.08 3.67 4/30/2026 77,248,118.22 193,431.07 0.00 193,431.07 77,528,089.10 0.25 3.04 3.69 5/31/2026 77,912,075.49 225,547.80 0.00 225,547.80 78,261,700.33 0.29 3.51 3.79 6/30/2026 79,115,431.39 198,942.95 0.00 198,942.95 79,096,464.82 0.25 3.06 3.91 Annualized TRR-BV Total/Average 74,709,097.52 1,182,616.77 5,348.10 1,187,964.87 77,266,728.80 1.54 3.10 3.68 Begin Date: 1/31/2026, End Date: 6/30/2026All Portfolios Total Rate of Return - Book Value by Month City of Colleyville | TX 3 Month Market Value Book Value Unrealized Gain/Loss YTM @ Cost YTM @ Market Duration Days To Maturity 1/31/2026 75,828,210.35 75,819,578.16 8,632.19 3.63 3.60 0.09 32 2/28/2026 79,216,872.70 79,208,310.86 8,561.84 3.60 3.58 0.08 30 3/31/2026 77,188,966.20 77,190,737.63 -1,771.43 3.59 3.58 0.10 39 4/30/2026 77,830,447.59 77,833,734.18 -3,286.59 4,675.08 4,675.07 0.11 40 5/31/2026 79,017,237.27 79,028,295.95 -11,058.68 3.58 3.57 0.12 44 6/30/2026 74,815,344.68 74,836,318.72 -20,974.04 3.50 3.53 0.13 48 Total / Average 77,316,179.80 77,319,495.92 -3,316.12 787.34 787.33 0.10 39 Market Value / Book Value Comparison Begin Date: 1/31/2026, End Date: 6/30/2026All Portfolios Portfolio Summary by Month City of Colleyville | TX 4 Maturity Range Allocation Maturity Range Market Value 3/31/2026 % of Portfolio 3/31/2026 Market Value 6/30/2026 % of Portfolio 6/30/2026 0-1 Month 66,361,069.23 85.97 65,102,292.32 87.02 1-3 Months 477,011.88 0.62 493,955.54 0.66 3-6 Months 3,844,713.52 4.98 1,952,591.43 2.61 6-9 Months 1,954,546.47 2.53 2,581,964.69 3.45 9-12 Months 2,584,661.39 3.35 248,995.02 0.33 1-2 Years 1,966,963.71 2.55 4,435,545.68 5.93 Total / Average 77,188,966.20 100.00 74,815,344.68 100.00 Portfolio Holdings as of 3/31/2026 Portfolio Holdings as of 6/30/2026 Begin Date: 3/31/2026, End Date: 6/30/2026All Portfolios Distribution by Maturity Range - Market Value City of Colleyville | TX 5 Security Type Allocation Security Type Market Value 3/31/2026 % of Portfolio 3/31/2026 Market Value 6/30/2026 % of Portfolio 6/30/2026 Cash 13,268,798.73 17.19 8,653,024.72 11.57 FFCB Bond 1,608,790.07 2.08 1,607,386.76 2.15 FHLB Bond 3,382,744.00 4.38 1,994,590.00 2.67 Local Government Investment Pool 52,820,765.24 68.43 53,298,860.46 71.24 Money Market 271,505.26 0.35 2,184,433.54 2.92 Negotiable Certificate Of Deposit 5,836,362.90 7.56 7,077,049.20 9.46 Total / Average 77,188,966.20 100.00 74,815,344.68 100.00 Portfolio Holdings as of 3/31/2026 Portfolio Holdings as of 6/30/2026 Begin Date: 3/31/2026, End Date: 6/30/2026All Portfolios Distribution by Security Type - Market Value City of Colleyville | TX 6 Main Fund Allocation Main Fund Market Value 3/31/2026 % of Portfolio 3/31/2026 Market Value 6/30/2026 % of Portfolio 6/30/2026 1 | General Fund 24,284,126.28 31.46 21,140,777.40 28.26 2 | Debt Service Funds 860,654.77 1.11 900,050.89 1.20 3 | Capital Project Funds 30,615,208.64 39.66 29,324,443.59 39.20 4 | Special Revenue Funds 7,071,351.30 9.16 7,441,696.01 9.95 5 | Enterprise Funds 13,541,091.85 17.54 15,083,281.96 20.16 6 | Fiduciary Funds 16,166.55 0.02 125,951.56 0.17 None 800,366.81 1.04 799,143.27 1.07 Total / Average 77,188,966.20 100.00 74,815,344.68 100.00 Portfolio Holdings as of 3/31/2026 Portfolio Holdings as of 6/30/2026 Begin Date: 3/31/2026, End Date: 6/30/2026All Portfolios Distribution by Main Fund - Market Value City of Colleyville | TX 7 538037CP5 1,436.70Live Oak Bkg Co 3.9 11/8/2027 0.000.007/1/2026 1,436.70 90355GWT9 839.10UBS Bank USA 4.1 6/4/2027 0.000.007/4/2026 839.10 843383EA4 757.23SOUTHERN BK POPLAR 3.7 2/5/2027 0.000.007/6/2026 757.23 949764VJ0 794.96Wells Fargo Bk N A 3.9 10/7/2027 0.000.007/7/2026 794.96 29367RNH5 808.40Enterprise Bank 4.15 12/10/2026 0.000.007/10/2026 808.40 65504UAM9 839.10Noble Fed Cr Un 4.1 6/12/2028 0.000.007/10/2026 839.10 32022RYV3 237,779.181st Financial Bank USA 4 7/10/2026 237,000.00237,000.007/10/2026 779.18 06426KEQ7 777.70Bank New Eng Salem N 3.8 2/12/2027 0.000.007/13/2026 777.70 3133ET7H4 27,219.38FFCB 3.375 1/13/2027 0.000.007/13/2026 27,219.38 89841MCT2 777.70TRUSTONEE FINANCIAL 3.8 11/13/2026 0.000.007/14/2026 777.70 01882MAK8 808.40ALLIANT CR UN 3.95 10/15/2026 0.000.007/15/2026 808.40 06051XZA3 249,840.00Bank of America 4.1 7/23/2026 240,000.00240,000.007/23/2026 9,840.00 83542MBG6 777.70Sonata Bk Brentwood Tenn 3.8 4/24/2028 0.000.007/24/2026 777.70 219236BZ8 249,693.37Cornerstone Bank 4.05 7/24/2026 240,000.00240,000.007/24/2026 9,693.37 48836LCM2 249,849.33Kemba Financial 4.15 7/24/2026 249,000.00249,000.007/24/2026 849.33 56824JCA0 828.49Marine Fed Cr Un 4.2 6/26/2028 0.000.007/26/2026 828.49 30191MAL1 818.63FFB Bank 4 11/27/2026 0.000.007/27/2026 818.63 56065GDM7 842.47Mainstreet Bank Fairfax, VA 4.1 12/30/2027 0.000.007/30/2026 842.47 20786AKY0 771.35CONNECTONE BANK 3.8 7/30/2027 0.000.007/31/2026 771.35 1,026,259.19966,000.00July 2026 60,259.19 538037CP5 824.77Live Oak Bkg Co 3.9 11/8/2027 0.000.008/1/2026 824.77 90355GWT9 867.07UBS Bank USA 4.1 6/4/2027 0.000.008/4/2026 867.07 843383EA4 782.47SOUTHERN BK POPLAR 3.7 2/5/2027 0.000.008/6/2026 782.47 949764VJ0 821.46Wells Fargo Bk N A 3.9 10/7/2027 0.000.008/7/2026 821.46 29367RNH5 835.34Enterprise Bank 4.15 12/10/2026 0.000.008/10/2026 835.34 CUSIP TotalDescriptionPrincipal AmountFace Amount/SharesDate Interest/Dividends Begin Date: 07-2026, End Date: 12-2026All Portfolios Projected Cash Flow by Month City of Colleyville | TX 8 65504UAM9 867.07Noble Fed Cr Un 4.1 6/12/2028 0.000.008/10/2026 867.07 06426KEQ7 803.62Bank New Eng Salem N 3.8 2/12/2027 0.000.008/13/2026 803.62 89841MCT2 803.62TRUSTONEE FINANCIAL 3.8 11/13/2026 0.000.008/14/2026 803.62 01882MAK8 835.34ALLIANT CR UN 3.95 10/15/2026 0.000.008/15/2026 835.34 26879TAK5 2,521.43EPB Employeees Cr Un 4.05 9/21/2026 0.000.008/21/2026 2,521.43 83542MBG6 803.62Sonata Bk Brentwood Tenn 3.8 4/24/2028 0.000.008/24/2026 803.62 02589AGP1 4,936.09American Express 4.2 2/26/2027 0.000.008/26/2026 4,936.09 61776NMA8 5,058.08Morgan Stanley Bank 4.25 2/26/2027 0.000.008/26/2026 5,058.08 56824JCA0 856.11Marine Fed Cr Un 4.2 6/26/2028 0.000.008/26/2026 856.11 22282XAN0 249,521.43COVANTAGE 4.05 8/27/2026 247,000.00247,000.008/27/2026 2,521.43 30191MAL1 845.92FFB Bank 4 11/27/2026 0.000.008/27/2026 845.92 56065GDM7 870.55Mainstreet Bank Fairfax, VA 4.1 12/30/2027 0.000.008/30/2026 870.55 20786AKY0 771.35CONNECTONE BANK 3.8 7/30/2027 0.000.008/31/2026 771.35 273,625.34247,000.00August 2026 26,625.34 538037CP5 824.77Live Oak Bkg Co 3.9 11/8/2027 0.000.009/1/2026 824.77 90355GWT9 867.07UBS Bank USA 4.1 6/4/2027 0.000.009/4/2026 867.07 843383EA4 782.47SOUTHERN BK POPLAR 3.7 2/5/2027 0.000.009/6/2026 782.47 949764VJ0 821.46Wells Fargo Bk N A 3.9 10/7/2027 0.000.009/7/2026 821.46 29367RNH5 835.34Enterprise Bank 4.15 12/10/2026 0.000.009/10/2026 835.34 65504UAM9 867.07Noble Fed Cr Un 4.1 6/12/2028 0.000.009/10/2026 867.07 73317AFC1 2,284.88POPULAR BK NEW YORK 3.7 3/10/2028 0.000.009/11/2026 2,284.88 06426KEQ7 803.62Bank New Eng Salem N 3.8 2/12/2027 0.000.009/13/2026 803.62 89841MCT2 803.62TRUSTONEE FINANCIAL 3.8 11/13/2026 0.000.009/14/2026 803.62 01882MAK8 835.34ALLIANT CR UN 3.95 10/15/2026 0.000.009/15/2026 835.34 26879TAK5 247,849.61EPB Employeees Cr Un 4.05 9/21/2026 247,000.00247,000.009/21/2026 849.61 CUSIP TotalDescriptionPrincipal AmountFace Amount/SharesDate Interest/Dividends Begin Date: 07-2026, End Date: 12-2026All Portfolios Projected Cash Flow by Month City of Colleyville | TX 9 3130B9YL8 19,333.33FHLB 4 3/21/2028-26 0.000.009/21/2026 19,333.33 83542MBG6 803.62Sonata Bk Brentwood Tenn 3.8 4/24/2028 0.000.009/24/2026 803.62 56824JCA0 856.11Marine Fed Cr Un 4.2 6/26/2028 0.000.009/26/2026 856.11 30191MAL1 845.92FFB Bank 4 11/27/2026 0.000.009/27/2026 845.92 56065GDM7 870.55Mainstreet Bank Fairfax, VA 4.1 12/30/2027 0.000.009/30/2026 870.55 20786AKY0 746.47CONNECTONE BANK 3.8 7/30/2027 0.000.009/30/2026 746.47 281,031.25247,000.00September 2026 34,031.25 538037CP5 798.16Live Oak Bkg Co 3.9 11/8/2027 0.000.0010/1/2026 798.16 90355GWT9 839.10UBS Bank USA 4.1 6/4/2027 0.000.0010/4/2026 839.10 843383EA4 757.23SOUTHERN BK POPLAR 3.7 2/5/2027 0.000.0010/6/2026 757.23 949764VJ0 794.96Wells Fargo Bk N A 3.9 10/7/2027 0.000.0010/7/2026 794.96 29367RNH5 808.40Enterprise Bank 4.15 12/10/2026 0.000.0010/10/2026 808.40 65504UAM9 839.10Noble Fed Cr Un 4.1 6/12/2028 0.000.0010/10/2026 839.10 06426KEQ7 777.70Bank New Eng Salem N 3.8 2/12/2027 0.000.0010/13/2026 777.70 89841MCT2 777.70TRUSTONEE FINANCIAL 3.8 11/13/2026 0.000.0010/14/2026 777.70 01882MAK8 249,808.40ALLIANT CR UN 3.95 10/15/2026 249,000.00249,000.0010/15/2026 808.40 72345SMJ7 4,913.42Pinnacle Bank 4 4/17/2028 0.000.0010/17/2026 4,913.42 83542MBG6 777.70Sonata Bk Brentwood Tenn 3.8 4/24/2028 0.000.0010/24/2026 777.70 56824JCA0 828.49Marine Fed Cr Un 4.2 6/26/2028 0.000.0010/26/2026 828.49 30191MAL1 818.63FFB Bank 4 11/27/2026 0.000.0010/27/2026 818.63 56065GDM7 842.47Mainstreet Bank Fairfax, VA 4.1 12/30/2027 0.000.0010/30/2026 842.47 20786AKY0 771.35CONNECTONE BANK 3.8 7/30/2027 0.000.0010/31/2026 771.35 265,152.81249,000.00October 2026 16,152.81 538037CP5 824.77Live Oak Bkg Co 3.9 11/8/2027 0.000.0011/1/2026 824.77 90355GWT9 867.07UBS Bank USA 4.1 6/4/2027 0.000.0011/4/2026 867.07 CUSIP TotalDescriptionPrincipal AmountFace Amount/SharesDate Interest/Dividends Begin Date: 07-2026, End Date: 12-2026All Portfolios Projected Cash Flow by Month City of Colleyville | TX 10 843383EA4 782.47SOUTHERN BK POPLAR 3.7 2/5/2027 0.000.0011/6/2026 782.47 949764VJ0 821.46Wells Fargo Bk N A 3.9 10/7/2027 0.000.0011/7/2026 821.46 29367RNH5 835.34Enterprise Bank 4.15 12/10/2026 0.000.0011/10/2026 835.34 65504UAM9 867.07Noble Fed Cr Un 4.1 6/12/2028 0.000.0011/10/2026 867.07 06426KEQ7 803.62Bank New Eng Salem N 3.8 2/12/2027 0.000.0011/13/2026 803.62 89841MCT2 249,777.70TRUSTONEE FINANCIAL 3.8 11/13/2026 249,000.00249,000.0011/13/2026 777.70 05612LCL4 5,002.03BMW Bank of North America 4.05 11/16/2026 0.000.0011/15/2026 5,002.03 05612LCL4 245,027.18BMW Bank of North America 4.05 11/16/2026 245,000.00245,000.0011/16/2026 27.18 3130BAQV2 20,000.00FHLB 4 11/18/2027-26 0.000.0011/18/2026 20,000.00 83542MBG6 803.62Sonata Bk Brentwood Tenn 3.8 4/24/2028 0.000.0011/24/2026 803.62 56824JCA0 856.11Marine Fed Cr Un 4.2 6/26/2028 0.000.0011/26/2026 856.11 61690DB49 249,104.61Morgan Stanley Bank 4.15 11/27/2026 244,000.00244,000.0011/27/2026 5,104.61 30191MAL1 249,845.92FFB Bank 4 11/27/2026 249,000.00249,000.0011/27/2026 845.92 56065GDM7 870.55Mainstreet Bank Fairfax, VA 4.1 12/30/2027 0.000.0011/30/2026 870.55 20786AKY0 746.47CONNECTONE BANK 3.8 7/30/2027 0.000.0011/30/2026 746.47 1,027,835.99987,000.00November 2026 40,835.99 538037CP5 798.16Live Oak Bkg Co 3.9 11/8/2027 0.000.0012/1/2026 798.16 90355GWT9 839.10UBS Bank USA 4.1 6/4/2027 0.000.0012/4/2026 839.10 843383EA4 757.23SOUTHERN BK POPLAR 3.7 2/5/2027 0.000.0012/6/2026 757.23 949764VJ0 794.96Wells Fargo Bk N A 3.9 10/7/2027 0.000.0012/7/2026 794.96 29367RNH5 237,808.40Enterprise Bank 4.15 12/10/2026 237,000.00237,000.0012/10/2026 808.40 65504UAM9 839.10Noble Fed Cr Un 4.1 6/12/2028 0.000.0012/10/2026 839.10 73317AFC1 2,260.04POPULAR BK NEW YORK 3.7 3/10/2028 0.000.0012/11/2026 2,260.04 68405VCV9 244,993.64Optum Bank, Inc 4.15 12/11/2026 240,000.00240,000.0012/11/2026 4,993.64 06426KEQ7 777.70Bank New Eng Salem N 3.8 2/12/2027 0.000.0012/13/2026 777.70 CUSIP TotalDescriptionPrincipal AmountFace Amount/SharesDate Interest/Dividends Begin Date: 07-2026, End Date: 12-2026All Portfolios Projected Cash Flow by Month City of Colleyville | TX 11 34061LAE8 249,120.00Florida CR UN 3.8 12/15/2026 240,000.00240,000.0012/15/2026 9,120.00 83542MBG6 777.70Sonata Bk Brentwood Tenn 3.8 4/24/2028 0.000.0012/24/2026 777.70 56824JCA0 828.49Marine Fed Cr Un 4.2 6/26/2028 0.000.0012/26/2026 828.49 56065GDM7 842.47Mainstreet Bank Fairfax, VA 4.1 12/30/2027 0.000.0012/30/2026 842.47 20786AKY0 771.35CONNECTONE BANK 3.8 7/30/2027 0.000.0012/31/2026 771.35 742,208.34717,000.00December 2026 25,208.34 3,616,112.923,413,000.00TOTAL 203,112.92 CUSIP TotalDescriptionPrincipal AmountFace Amount/SharesDate Interest/Dividends Begin Date: 07-2026, End Date: 12-2026All Portfolios Projected Cash Flow by Month City of Colleyville | TX 12 CD | Negotiable (Brokered) | 100% 32022RYV3 1st Financial Bank USA 4 7/10/2026 237,000.00 1/10/2025 4.00 237,000.00 237,000.00 100.00 3.99 519.45 237,000.00 0.00 0.32% FDIC Insured FDIC Insured 0.03 10 01882MAK8 ALLIANT CR UN 3.95 10/15/2026 249,000.00 10/15/2025 3.95 249,000.00 249,000.00 99.95 4.12 404.20 248,880.48 -119.52 0.34% FDIC Insured FDIC Insured 0.29 107 02589AGP1 American Express 4.2 2/26/2027 237,000.00 2/26/2025 4.20 237,000.00 237,000.00 100.10 4.04 3,381.63 237,234.63 234.63 0.32% FDIC Insured FDIC Insured 0.65 241 06426KEQ7 Bank New Eng Salem N 3.8 2/12/2027 249,000.00 2/13/2026 3.80 249,000.00 249,000.00 99.83 4.08 440.70 248,581.68 -418.32 0.34% FDIC Insured FDIC Insured 0.61 227 06051XZA3 Bank of America 4.1 7/23/2026 240,000.00 7/23/2025 4.10 240,000.00 240,000.00 100.00 4.01 9,219.95 239,990.40 -9.60 0.32% FDIC Insured FDIC Insured 0.06 23 05612LCL4 BMW Bank of North America 4.05 11/16/2026 245,000.00 11/15/2024 4.05 245,000.00 245,000.00 100.02 4.00 1,250.51 245,036.75 36.75 0.33% FDIC Insured FDIC Insured 0.38 139 178180HK4 City Natl Bk Los 3.852 8/13/2027 236,000.00 2/13/2026 3.85 236,000.00 236,000.00 99.67 4.10 3,412.13 235,218.84 -781.16 0.32% FDIC Insured FDIC Insured 1.12 409 20786AKY0 CONNECTONE BANK 3.8 7/30/2027 239,000.00 1/30/2026 3.80 239,000.00 239,000.00 99.65 4.13 0.00 238,170.67 -829.33 0.32% FDIC Insured FDIC Insured 1.06 395 219236BZ8 Cornerstone Bank 4.05 7/24/2026 240,000.00 7/25/2025 4.05 240,000.00 240,000.00 99.99 4.01 9,054.25 239,983.20 -16.80 0.32% FDIC Insured FDIC Insured 0.07 24 22282XAN0 COVANTAGE 4.05 8/27/2026 247,000.00 8/27/2025 4.05 247,000.00 247,000.00 99.99 4.12 931.83 246,965.42 -34.58 0.33% FDIC Insured FDIC Insured 0.16 58 29367RNH5 Enterprise Bank 4.15 12/10/2026 237,000.00 12/10/2024 4.15 237,000.00 237,000.00 100.07 4.00 538.93 237,156.42 156.42 0.32% FDIC Insured FDIC Insured 0.44 163 26879TAK5 EPB Employeees Cr Un 4.05 9/21/2026 247,000.00 5/21/2025 4.05 247,000.00 247,000.00 100.00 4.07 1,096.27 246,990.12 -9.88 0.33% FDIC Insured FDIC Insured 0.22 83 CUSIP Face Amount / Shares Settlement DateDescription YTM @ Cost Cost Value Book Value YTM @ Market Market Price Market Value Accrued Interest Unre. Gain/Loss % Portfolio Credit Rating Credit Rating Duration To Maturity Days To Call/Maturity Date: 6/30/2026Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 13 30191MAL1 FFB Bank 4 11/27/2026 249,000.00 11/27/2024 4.00 249,000.00 249,000.00 100.00 4.00 81.86 249,000.00 0.00 0.34% FDIC Insured FDIC Insured 0.41 150 34061LAE8 Florida CR UN 3.8 12/15/2026 240,000.00 12/15/2025 3.80 240,000.00 240,000.00 99.87 4.01 4,922.30 239,688.00 -312.00 0.32% FDIC Insured FDIC Insured 0.46 168 48836LCM2 Kemba Financial 4.15 7/24/2026 249,000.00 7/24/2025 4.15 249,000.00 249,000.00 100.00 4.15 169.87 249,000.00 0.00 0.34% FDIC Insured FDIC Insured 0.07 24 538037CP5 Live Oak Bkg Co 3.9 11/8/2027 249,000.00 5/8/2026 3.90 249,000.00 249,000.00 99.65 4.15 1,410.09 248,128.50 -871.50 0.34% FDIC Insured FDIC Insured 1.38 496 56065GDM7 Mainstreet Bank Fairfax, VA 4.1 12/30/2027 250,000.00 6/30/2026 4.10 250,000.00 250,000.00 99.88 4.18 0.00 249,710.00 -290.00 0.34% FDIC Insured FDIC Insured 1.46 548 56824JCA0 Marine Fed Cr Un 4.2 6/26/2028 240,000.00 6/26/2026 4.20 240,000.00 240,000.00 99.94 4.23 110.47 239,865.60 -134.40 0.32% FDIC Insured FDIC Insured 1.91 727 61690DB49 Morgan Stanley Bank 4.15 11/27/2026 244,000.00 11/27/2024 4.15 244,000.00 244,000.00 100.01 4.10 943.24 244,029.28 29.28 0.33% FDIC Insured FDIC Insured 0.41 150 61776NMA8 Morgan Stanley Bank 4.25 2/26/2027 240,000.00 2/26/2025 4.25 240,000.00 240,000.00 100.13 4.04 3,465.21 240,314.40 314.40 0.32% FDIC Insured FDIC Insured 0.65 241 65504UAM9 Noble Fed Cr Un 4.1 6/12/2028 249,000.00 6/10/2026 4.10 249,000.00 249,000.00 99.78 4.22 559.40 248,442.24 -557.76 0.34% FDIC Insured FDIC Insured 1.87 713 68405VCV9 Optum Bank, Inc 4.15 12/11/2026 240,000.00 12/11/2024 4.15 240,000.00 240,000.00 100.03 4.07 518.47 240,074.40 74.40 0.32% FDIC Insured FDIC Insured 0.45 164 72345SMJ7 Pinnacle Bank 4 4/17/2028 245,000.00 4/17/2026 4.00 245,000.00 245,000.00 99.60 4.23 1,986.85 244,022.45 -977.55 0.33% FDIC Insured FDIC Insured 1.74 657 73317AFC1 POPULAR BK NEW YORK 3.7 3/10/2028 245,000.00 3/11/2026 3.70 245,000.00 245,000.00 99.17 4.21 471.88 242,973.85 -2,026.15 0.33% FDIC Insured FDIC Insured 1.65 619 CUSIP Face Amount / Shares Settlement DateDescription YTM @ Cost Cost Value Book Value YTM @ Market Market Price Market Value Accrued Interest Unre. Gain/Loss % Portfolio Credit Rating Credit Rating Duration To Maturity Days To Call/Maturity Date: 6/30/2026Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 14 83542MBG6 Sonata Bk Brentwood Tenn 3.8 4/24/2028 249,000.00 4/24/2026 3.80 249,000.00 249,000.00 99.28 4.21 155.54 247,209.69 -1,790.31 0.34% FDIC Insured FDIC Insured 1.76 664 843383EA4 SOUTHERN BK POPLAR 3.7 2/5/2027 249,000.00 2/6/2026 3.70 249,000.00 249,000.00 99.78 4.08 605.79 248,447.22 -552.78 0.34% FDIC Insured FDIC Insured 0.59 220 89841MCT2 TRUSTONEE FINANCIAL 3.8 11/13/2026 249,000.00 11/14/2025 3.80 249,000.00 249,000.00 99.89 4.10 414.77 248,726.10 -273.90 0.34% FDIC Insured FDIC Insured 0.37 136 90355GWT9 UBS Bank USA 4.1 6/4/2027 249,000.00 6/4/2025 4.10 249,000.00 249,000.00 100.00 4.10 727.22 248,995.02 -4.98 0.34% FDIC Insured FDIC Insured 0.91 339 949764VJ0 Wells Fargo Bk N A 3.9 10/7/2027 248,000.00 4/7/2026 3.90 248,000.00 248,000.00 99.68 4.16 609.47 247,213.84 -786.16 0.33% FDIC Insured FDIC Insured 1.24 464 289 0.78 9.57% -9,950.80 7,077,049.20 47,402.284.10 7,087,000.00 7,087,000.003.997,087,000.00Sub Total CD | Negotiable (Brokered) | 100% Money Market - Mutual Fund | 10% MBS8852 Multi-Bank Securities MM 21,833.54 6/30/2024 0.05 21,833.54 21,833.54 100.00 0.05 21,833.54 0.00 0.03% NR NR 0 1 RJ0967 Raymond James MM 2,162,600.00 7/30/2024 0.00 2,162,600.00 2,162,600.00 100.00 0.00 2,162,600.00 0.00 2.92% NR NR 0 1 1 0 2.95% 0.00 2,184,433.54 0.00 2,184,433.54 2,184,433.540.002,184,433.54Sub Total Money Market - Mutual Fund | 10% Operating Cash | TBD% OPERATINGCASH Cash | Operating Cash 641,255.91 6/30/2024 3.13 641,255.91 641,255.91 100.00 3.13 641,255.91 0.00 0.86% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 1,202,773.57 6/30/2024 3.13 1,202,773.57 1,202,773.57 100.00 3.13 1,202,773.57 0.00 1.62% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 2,829.35 6/30/2024 3.13 2,829.35 2,829.35 100.00 3.13 2,829.35 0.00 0% NR NR 0 1 CUSIP Face Amount / Shares Settlement DateDescription YTM @ Cost Cost Value Book Value YTM @ Market Market Price Market Value Accrued Interest Unre. Gain/Loss % Portfolio Credit Rating Credit Rating Duration To Maturity Days To Call/Maturity Date: 6/30/2026Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 15 OPERATINGCASH Cash | Operating Cash 127,444.74 6/30/2024 3.13 127,444.74 127,444.74 100.00 3.13 127,444.74 0.00 0.17% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 89,762.56 6/30/2024 3.13 89,762.56 89,762.56 100.00 3.13 89,762.56 0.00 0.12% NR NR 0 1 OPERATINGCASH Cash | Operating Cash -66,970.38 6/30/2024 3.13 -66,970.38 -66,970.38 100.00 3.13 -66,970.38 0.00 -0.09% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 1,780,013.71 6/30/2024 3.13 1,780,013.71 1,780,013.71 100.00 3.13 1,780,013.71 0.00 2.4% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 371,071.33 6/30/2024 3.13 371,071.33 371,071.33 100.00 3.13 371,071.33 0.00 0.5% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 81,538.95 6/30/2024 3.13 81,538.95 81,538.95 100.00 3.13 81,538.95 0.00 0.11% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 900,050.89 6/30/2024 3.13 900,050.89 900,050.89 100.00 3.13 900,050.89 0.00 1.21% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 18,220.56 6/30/2024 3.13 18,220.56 18,220.56 100.00 3.13 18,220.56 0.00 0.02% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 21,506.18 6/30/2024 3.13 21,506.18 21,506.18 100.00 3.13 21,506.18 0.00 0.03% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 1,062,172.88 6/30/2024 3.13 1,062,172.88 1,062,172.88 100.00 3.13 1,062,172.88 0.00 1.43% NR NR 0 1 OPERATINGCASH Cash | Operating Cash -3,114,847.59 6/30/2024 3.13 -3,114,847.59 -3,114,847.59 100.00 3.13 -3,114,847.59 0.00 -4.2% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 107,731.00 6/30/2024 3.13 107,731.00 107,731.00 100.00 3.13 107,731.00 0.00 0.15% NR NR 0 1 CUSIP Face Amount / Shares Settlement DateDescription YTM @ Cost Cost Value Book Value YTM @ Market Market Price Market Value Accrued Interest Unre. Gain/Loss % Portfolio Credit Rating Credit Rating Duration To Maturity Days To Call/Maturity Date: 6/30/2026Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 16 OPERATINGCASH Cash | Operating Cash 36,104.55 6/30/2024 3.13 36,104.55 36,104.55 100.00 3.13 36,104.55 0.00 0.05% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 133,001.30 6/30/2024 3.13 133,001.30 133,001.30 100.00 3.13 133,001.30 0.00 0.18% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 10,334.71 6/30/2024 3.13 10,334.71 10,334.71 100.00 3.13 10,334.71 0.00 0.01% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 83,383.81 6/30/2024 3.13 83,383.81 83,383.81 100.00 3.13 83,383.81 0.00 0.11% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 174,008.91 6/30/2024 3.13 174,008.91 174,008.91 100.00 3.13 174,008.91 0.00 0.23% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 996,287.80 6/30/2024 3.13 996,287.80 996,287.80 100.00 3.13 996,287.80 0.00 1.34% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 1,108,259.87 6/30/2024 3.13 1,108,259.87 1,108,259.87 100.00 3.13 1,108,259.87 0.00 1.49% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 150,938.86 6/30/2024 3.13 150,938.86 150,938.86 100.00 3.13 150,938.86 0.00 0.2% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 1,350,596.76 6/30/2024 3.13 1,350,596.76 1,350,596.76 100.00 3.13 1,350,596.76 0.00 1.82% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 49,393.90 6/30/2024 3.13 49,393.90 49,393.90 100.00 3.13 49,393.90 0.00 0.07% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 21,703.37 6/30/2024 3.13 21,703.37 21,703.37 100.00 3.13 21,703.37 0.00 0.03% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 10,819.44 6/30/2024 3.13 10,819.44 10,819.44 100.00 3.13 10,819.44 0.00 0.01% NR NR 0 1 CUSIP Face Amount / Shares Settlement DateDescription YTM @ Cost Cost Value Book Value YTM @ Market Market Price Market Value Accrued Interest Unre. Gain/Loss % Portfolio Credit Rating Credit Rating Duration To Maturity Days To Call/Maturity Date: 6/30/2026Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 17 OPERATINGCASH Cash | Operating Cash 18,277.32 6/30/2025 3.13 18,277.32 18,277.32 100.00 3.13 18,277.32 0.00 0.02% NR NR 0 1 CEDCCASH CASH CEDC Cash 1,285,360.46 6/30/2024 3.13 1,285,360.46 1,285,360.46 100.00 3.13 1,285,360.46 0.00 1.73% NR NR 0 1 1 0 11.62% 0.00 8,653,024.72 3.13 8,653,024.72 8,653,024.723.138,653,024.72Sub Total Operating Cash | TBD% TX LGIP | 75% TEXASCLASS4001 Texas CLASS LGIP 2,783,639.56 6/30/2024 3.54 2,783,639.56 2,783,639.56 100.00 3.54 2,783,639.56 0.00 3.75% NR NR 0 1 TEXASCLASS4001 Texas CLASS LGIP 5,335,836.21 6/30/2024 3.54 5,335,836.21 5,335,836.21 100.00 3.54 5,335,836.21 0.00 7.2% NR NR 0 1 TEXASCLASS4001 Texas CLASS LGIP 2,216,150.38 6/30/2024 3.54 2,216,150.38 2,216,150.38 100.00 3.54 2,216,150.38 0.00 2.99% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 1,778,528.08 6/30/2024 3.62 1,778,528.08 1,778,528.08 100.00 3.62 1,778,528.08 0.00 2.4% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 1,218,920.86 6/30/2024 3.62 1,218,920.86 1,218,920.86 100.00 3.62 1,218,920.86 0.00 1.64% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 1,176,481.33 6/30/2024 3.62 1,176,481.33 1,176,481.33 100.00 3.62 1,176,481.33 0.00 1.59% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 850,993.72 6/30/2024 3.62 850,993.72 850,993.72 100.00 3.62 850,993.72 0.00 1.15% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 590,264.55 6/30/2024 3.62 590,264.55 590,264.55 100.00 3.62 590,264.55 0.00 0.8% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 286,607.67 6/30/2024 3.62 286,607.67 286,607.67 100.00 3.62 286,607.67 0.00 0.39% NR NR 0 1 CUSIP Face Amount / Shares Settlement DateDescription YTM @ Cost Cost Value Book Value YTM @ Market Market Price Market Value Accrued Interest Unre. Gain/Loss % Portfolio Credit Rating Credit Rating Duration To Maturity Days To Call/Maturity Date: 6/30/2026Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 18 TEXSTAR1110 TexasStar LGIP 8,248,714.53 6/30/2024 3.62 8,248,714.53 8,248,714.53 100.00 3.62 8,248,714.53 0.00 11.12% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 302,599.55 6/30/2024 3.62 302,599.55 302,599.55 100.00 3.62 302,599.55 0.00 0.41% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 103,547.29 9/23/2025 3.62 103,547.29 103,547.29 100.00 3.62 103,547.29 0.00 0.14% NR NR 0 1 TEXPOOL0001 TexPool LGIP 803,941.95 6/30/2024 3.65 803,941.95 803,941.95 100.00 3.65 803,941.95 0.00 1.08% NR NR 0 1 TEXPOOL0001 TexPool LGIP 451,880.66 6/30/2024 3.65 451,880.66 451,880.66 100.00 3.65 451,880.66 0.00 0.61% NR NR 0 1 TEXPOOL0001 TexPool LGIP 5,287,772.82 6/30/2024 3.65 5,287,772.82 5,287,772.82 100.00 3.65 5,287,772.82 0.00 7.13% NR NR 0 1 TEXPOOL0001 TexPool LGIP 604,832.71 6/30/2024 3.65 604,832.71 604,832.71 100.00 3.65 604,832.71 0.00 0.82% NR NR 0 1 TEXPOOL0001 TexPool LGIP 11,595.77 6/30/2024 3.65 11,595.77 11,595.77 100.00 3.65 11,595.77 0.00 0.02% NR NR 0 1 TEXPOOL0001 TexPool LGIP 4,030,804.41 6/30/2024 3.65 4,030,804.41 4,030,804.41 100.00 3.65 4,030,804.41 0.00 5.44% NR NR 0 1 TEXPOOL0001 TexPool LGIP 2,352,800.15 6/30/2024 3.65 2,352,800.15 2,352,800.15 100.00 3.65 2,352,800.15 0.00 3.17% NR NR 0 1 TEXPOOL0001 TexPool LGIP 5,221,097.71 6/30/2024 3.65 5,221,097.71 5,221,097.71 100.00 3.65 5,221,097.71 0.00 7.04% NR NR 0 1 TEXPOOL0001 TexPool LGIP 996,143.09 6/30/2024 3.65 996,143.09 996,143.09 100.00 3.65 996,143.09 0.00 1.34% NR NR 0 1 CUSIP Face Amount / Shares Settlement DateDescription YTM @ Cost Cost Value Book Value YTM @ Market Market Price Market Value Accrued Interest Unre. Gain/Loss % Portfolio Credit Rating Credit Rating Duration To Maturity Days To Call/Maturity Date: 6/30/2026Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 19 TEXPOOL0001 TexPool LGIP 77,508.25 6/30/2024 3.65 77,508.25 77,508.25 100.00 3.65 77,508.25 0.00 0.1% NR NR 0 1 TEXPOOL0001 TexPool LGIP 2,567,684.14 6/30/2024 3.65 2,567,684.14 2,567,684.14 100.00 3.65 2,567,684.14 0.00 3.46% NR NR 0 1 TEXPOOL0001 TexPool LGIP 3,149,338.99 6/30/2024 3.65 3,149,338.99 3,149,338.99 100.00 3.65 3,149,338.99 0.00 4.25% NR NR 0 1 TEXPOOL0001 TexPool LGIP 213,420.86 6/30/2024 3.65 213,420.86 213,420.86 100.00 3.65 213,420.86 0.00 0.29% NR NR 0 1 1 0 68.33% 0.00 50,661,105.24 3.62 50,661,105.24 50,661,105.243.6250,661,105.24Sub Total TX LGIP | 75% TX LGIP Commerical Paper | 5% LOGIC8010 LOGIC | CEDC LGIP 552,549.55 6/30/2024 3.75 552,549.55 552,549.55 100.00 3.75 552,549.55 0.00 0.75% NR NR 0 1 LOGIC4001 LOGIC LGIP 826,738.97 6/30/2024 3.75 826,738.97 826,738.97 100.00 3.75 826,738.97 0.00 1.11% NR NR 0 1 LOGIC4001 LOGIC LGIP 40,527.07 6/30/2024 3.75 40,527.07 40,527.07 100.00 3.75 40,527.07 0.00 0.05% NR NR 0 1 LOGIC4001 LOGIC LGIP 99,774.49 6/30/2024 3.75 99,774.49 99,774.49 100.00 3.75 99,774.49 0.00 0.13% NR NR 0 1 LOGIC4001 LOGIC LGIP 182,433.79 6/30/2024 3.75 182,433.79 182,433.79 100.00 3.75 182,433.79 0.00 0.25% NR NR 0 1 LOGIC4001 LOGIC LGIP 227,741.64 6/30/2024 3.75 227,741.64 227,741.64 100.00 3.75 227,741.64 0.00 0.31% NR NR 0 1 LOGIC4001 LOGIC LGIP 1,575.30 6/30/2024 3.75 1,575.30 1,575.30 100.00 3.75 1,575.30 0.00 0% NR NR 0 1 CUSIP Face Amount / Shares Settlement DateDescription YTM @ Cost Cost Value Book Value YTM @ Market Market Price Market Value Accrued Interest Unre. Gain/Loss % Portfolio Credit Rating Credit Rating Duration To Maturity Days To Call/Maturity Date: 6/30/2026Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 20 LOGIC4001 LOGIC LGIP 29,095.75 6/30/2024 3.75 29,095.75 29,095.75 100.00 3.75 29,095.75 0.00 0.04% NR NR 0 1 1 0 2.64% 0.00 1,960,436.56 3.75 1,960,436.56 1,960,436.563.751,960,436.56Sub Total TX LGIP Commerical Paper | 5% US Agency | 75% 3133ET7H4 FFCB 3.375 1/13/2027 1,613,000.00 1/14/2026 3.38 1,613,000.00 1,613,000.00 99.65 4.04 25,253.53 1,607,386.76 -5,613.24 2.18% S&P-AA+ Moodys-Aaa 0.53 197 3130BAQV2 FHLB 4 11/18/2027-26 1,000,000.00 5/18/2026 4.00 1,000,000.00 1,000,000.00 99.79 4.16 4,666.67 997,870.00 -2,130.00 1.35% S&P-AA+ Moodys-Aa1 1.35 141 3130B9YL8 FHLB 4 3/21/2028-26 1,000,000.00 3/27/2026 4.00 1,000,000.00 1,000,000.00 99.67 4.20 10,333.33 996,720.00 -3,280.00 1.35% S&P-AA Moodys-Aa1 1.67 83 150 1.07 4.88% -11,023.24 3,601,976.76 40,253.534.11 3,613,000.00 3,613,000.003.723,613,000.00Sub Total US Agency | 75% % TBD, pending investment policy clarification TOTAL PORTFOLIO 74,159,000.06 3.50 74,159,000.06 74,159,000.06 3.53 87,655.81 74,138,026.02 -20,974.04 100.00% 0.13 36 CUSIP Face Amount / Shares Settlement DateDescription YTM @ Cost Cost Value Book Value YTM @ Market Market Price Market Value Accrued Interest Unre. Gain/Loss % Portfolio Credit Rating Credit Rating Duration To Maturity Days To Call/Maturity Date: 6/30/2026Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 21 Quarterly Investment Report June 30, 2026 Audit Committee July 21, 2026 1 2 Portfolio Composition Legend: •LGIP – Local Government Investment Pool •CD – Certificate of Deposit •FHLB – Federal Home Loan Bank •FHLMC – Federal Home Loan Mortgage Corporation LGIP, $ 53.30 Cash, $ 8.65 MMMF, $ 2.18 CD, $ 7.09 FHLB, $ 1.99 FFCB, $ 1.61 Total Value: $10.8 Cash 64.0 Investments $74.8 Million 3 TexPool, $ 25.77 LOGIC*, $ 1.96 Texas Class, $ 10.34 TexStar, $ 14.56 Local Government Investment Pools (LGIP) *- Logic is the only approved pool that invests in commercial paper, limited per policy to 5% of total LGIP investment 4 Portfolio Composition Comparison LGIP Cash CD US Agency 5 Portfolio Performance Weighted Average Maturity: 1.6 months Weighted Average Yield: 3.50% FY25 3rd Qtr (Jun)FY25 4th Qtr (Sep)FY26 1st Qtr (Dec)FY26 2nd Qtr (Mar)FY26 3rd Qtr (Jun) 3.00% 3.20% 3.40% 3.60% 3.80% 4.00% 4.20% 4.40%4.35% 3.95% 3.65% 3.69% 3.98% 4.36% 4.30% 3.47% 3.10%3.13% 4.20%4.17% 4.09%3.99%3.99% 4.33%4.26% 3.81% 3.65%3.63% 4.16% 4.10%4.10% 3.84% 3.72% Yield Comparison 13-Week Treasury Bill Cash CD LGIP Agency Securities 6 Portfolio Performance FY25 3rd Qtr (Jun)FY25 4th Qtr (Sep)FY26 1st Qtr (Dec)FY26 2nd Qtr (Mar)FY26 3rd Qtr (Jun) $ 600,000 $ 650,000 $ 700,000 $ 750,000 $ 800,000 $ 850,000 $ 816,945 $ 716,617 $ 627,601 $ 622,428 $ 616,419 Investment Interest Earnings Comparison 7 Questions & Discussion colleyvillegovernment Colleyville.com colleyvilletexas