Loading...
HomeMy WebLinkAboutAudit Committee-Agenda Packets-05/12/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 TUESDAY, MAY 12, 2026 - 5:15 PM 1. CALL TO ORDER 2. APPROVAL OF MINUTES February 17, 2026 3. REPORTS Quarterly investment report as of March 31, 2026 4. ADJOURNMENT I hereby certify this agenda was posted on City Hall bulletin boards Wednesday, May 6, 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, FEBRUARY 17, 2026 - 5:00 PM 1. CALL TO ORDER City Secretary Christine Loven called the meeting to order at 5:01 p.m. and called the roll. PRESENT: Committee members Brandi Elder, Scotty Richardson, and Mark Alphonso. ALSO PRESENT: Finance Director Cassie Smith, Accounting Manager Karen Hines, City Manager Jerry Ducay, Assistant City Manager Mark Wood, and City Secretary Christine Loven. 2. APPROVAL OF MINUTES November 18, 2025 The November 18, 2025 minutes were approved. 3. REGULAR AGENDA ITEMS 3a Discussion of the FY25 Audit and SAS 114 Letter Finance Director Cassie Smith introduced Michelle Gilley, with Weaver, the City’s auditing firm. Ms. Gilley reviewed the audit process, significant changes, work results, the audit reports, risks, communications, and the financial highlights. Ms. Gilley stated the City received an unmodified report, which is the highest report, which can be given. She noted there were no material weaknesses, no significant deficiencies, and no noted noncompliance material to the financial statements. Ms. Gilley thanked Cassie Smith and Karen Hines for their assistance and said Weaver looks forward to continuing to work with both. With there being no questions regarding the audit, Ms. Gillen advised the audit will go before City Council tonight, February 17, 2026, for approval. 4. REPORTS Quarterly investment report as of December 31, 2025 Finance Director Cassie reviewed the investment reports. She highlighted the City’s portfolio composition and performance. Director Smith stated the City Audit Committee February 17, 2026 City of Colleyville Page 2 continues to monitor investments to ensure the strategies and objectives to preserve capital, provide liquidity, and optimize earnings are being met. 4. ADJOURNMENT The meeting adjourned at 5:16 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 Agenda Date 5/12/2026 Number - Type Report Department Finance Title Quarterly investment report as of March 31, 2026 Explanation Quarterly investment report as of March 31, 2026. Attachments 1.Quarterly Investment Report Presentation - March 2026 2.Quarterly Investment Report - March 2026 Quarterly Investment Report March 31, 2026 Audit Committee May 12, 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, $ 52.82 Cash, $ 13.54 CD, $ 5.83 FHLB, $ 3.38 FFCB, $ 1.61 Total Value: $13.5 Cash 63.7 Investments $77.2 Million 3 TexPool, $ 25.54 LOGIC*, $ 1.94 Texas Class, $ 10.25 TexStar, $ 14.44 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.1 months Weighted Average Yield: 3.59% FY25 2nd Qtr (Mar)FY25 3rd Qtr (Jun)FY25 4th Qtr (Sep)FY26 1st Qtr (Dec)FY26 2nd Qtr (Mar) 3.00% 3.20% 3.40% 3.60% 3.80% 4.00% 4.20% 4.40% 4.31% 4.35% 3.95% 3.65% 3.69% 4.36%4.36% 4.30% 3.47% 3.10% 4.24%4.20% 4.17%4.09% 3.99% 4.32% 4.33%4.26% 3.81% 3.65% 4.30% 4.16%4.10% 4.10% 3.84% Yield Comparison 13-Week Treasury Bill Cash CD LGIP Agency Securities 6 Portfolio Performance FY25 2nd Qtr (Mar)FY25 3rd Qtr (Jun)FY25 4th Qtr (Sep)FY26 1st Qtr (Dec)FY26 2nd Qtr (Mar) $ 600,000 $ 650,000 $ 700,000 $ 750,000 $ 800,000 $ 850,000 $ 696,785 $ 816,945 $ 716,617 $ 627,601 $ 622,428 Investment Interest Earnings Comparison 7 Questions & Discussion colleyvillegovernment Colleyville.com colleyvilletexas Asset Category Face Amount/Shares Market Value Book Value % of Portfolio YTM @ Cost Days To Maturity CD | Negotiable (Brokered) | 100%5,834,000.00 5,836,362.90 5,834,012.37 7.56 3.99 259 Operating Cash | TBD%13,540,303.99 13,540,303.99 13,540,303.99 17.54 3.10 1 TX LGIP | 75%50,878,592.34 50,878,592.34 50,878,592.34 65.91 3.64 1 TX LGIP Commerical Paper | 5%1,942,172.90 1,942,172.90 1,942,172.90 2.52 3.79 1 US Agency | 75%5,013,000.00 4,991,534.07 4,995,656.03 6.47 3.84 281 Total / Average 77,208,069.23 77,188,966.20 77,190,737.63 100.00 3.59 39 Date Date Date Karen Hines, Accounting Manager Cassie Smith, Finance DirectorMark Wood, Assistant City Manager 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 March 31, 2026 1 04/08/2026 4/8/2026 Asset Category Allocation Asset Category Market Value 12/31/2025 % of Portfolio 12/31/2025 Market Value 3/31/2026 % of Portfolio 3/31/2026 CD | Negotiable (Brokered) | 100%5,612,321.95 7.63 5,836,362.90 7.63 Operating Cash | TBD%15,457,207.24 21.03 13,540,303.99 17.69 TX LGIP | 75%45,532,474.31 61.94 50,218,210.01 65.62 TX LGIP Commerical Paper | 5%1,923,997.10 2.62 1,942,172.90 2.54 US Agency | 75%4,983,845.66 6.78 4,991,534.07 6.52 Total / Average 73,509,846.26 100.00 76,528,583.87 100.00 Portfolio Holdings as of 12/31/2025 Portfolio Holdings as of 3/31/2026 % TBD, pending investment policy clarification Begin Date: 12/31/2025, End Date: 3/31/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 10/31/2025 75,106,617.79 213,416.15 0.00 213,416.15 75,133,081.72 0.28 3.46 3.61 11/30/2025 75,499,957.49 198,492.81 0.00 198,492.81 74,781,250.42 0.27 3.23 3.66 12/31/2025 73,440,850.93 193,711.38 0.00 193,711.38 73,360,453.66 0.26 3.22 3.54 1/31/2026 74,709,097.52 189,508.20 5,348.10 194,856.30 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 Annualized TRR-BV Total/Average 75,106,617.79 1,170,315.28 5,348.10 1,175,663.38 75,297,042.13 1.56 3.15 3.58 Begin Date: 10/31/2025, End Date: 3/31/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 10/31/2025 75,453,859.04 75,429,738.60 24,120.44 4.03 3.99 0.12 46 11/30/2025 73,388,464.03 73,369,319.75 19,144.28 3.89 3.86 0.12 44 12/31/2025 74,662,870.94 74,637,050.71 25,820.23 3.78 3.73 0.11 40 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 Total / Average 75,956,540.54 75,942,455.95 14,084.59 3.75 3.72 0.10 38 Market Value / Book Value Comparison Begin Date: 10/31/2025, End Date: 3/31/2026All Portfolios Portfolio Summary by Month City of Colleyville | TX 4 Maturity Range Allocation Maturity Range Market Value 12/31/2025 % of Portfolio 12/31/2025 Market Value 3/31/2026 % of Portfolio 3/31/2026 0-1 Month 64,305,746.35 86.13 66,361,069.23 85.97 1-3 Months 1,743,403.89 2.34 477,011.88 0.62 3-6 Months 477,544.86 0.64 3,844,713.52 4.98 6-9 Months 3,832,963.37 5.13 1,954,546.47 2.53 9-12 Months 1,960,065.40 2.63 2,584,661.39 3.35 1-2 Years 2,343,147.07 3.14 1,966,963.71 2.55 Total / Average 74,662,870.94 100.00 77,188,966.20 100.00 Portfolio Holdings as of 12/31/2025 Portfolio Holdings as of 3/31/2026 Begin Date: 12/31/2025, End Date: 3/31/2026All Portfolios Distribution by Maturity Range - Market Value City of Colleyville | TX 5 Security Type Allocation Security Type Market Value 12/31/2025 % of Portfolio 12/31/2025 Market Value 3/31/2026 % of Portfolio 3/31/2026 Cash 15,457,207.24 20.70 13,268,798.73 17.19 FFCB Bond 1,612,435.45 2.16 1,608,790.07 2.08 FHLB Bond 3,371,410.21 4.52 3,382,744.00 4.38 Local Government Investment Pool 48,609,496.09 65.11 52,820,765.24 68.43 Negotiable Certificate Of Deposit 5,612,321.95 7.52 5,836,362.90 7.56 Money Market 0.00 0.00 271,505.26 0.35 Total / Average 74,662,870.94 100.00 77,188,966.20 100.00 Portfolio Holdings as of 12/31/2025 Portfolio Holdings as of 3/31/2026 Begin Date: 12/31/2025, End Date: 3/31/2026All Portfolios Distribution by Security Type - Market Value City of Colleyville | TX 6 Main Fund Allocation Main Fund Market Value 12/31/2025 % of Portfolio 12/31/2025 Market Value 3/31/2026 % of Portfolio 3/31/2026 1 | General Fund 18,033,823.82 24.15 24,284,126.28 31.46 2 | Debt Service Funds 570,573.43 0.76 860,654.77 1.11 3 | Capital Project Funds 33,213,701.30 44.48 30,615,208.64 39.66 4 | Special Revenue Funds 7,479,186.81 10.02 7,071,351.30 9.16 5 | Enterprise Funds 14,071,647.88 18.85 13,541,091.85 17.54 6 | Fiduciary Funds 16,958.09 0.02 16,166.55 0.02 None 1,276,979.61 1.71 800,366.81 1.04 Total / Average 74,662,870.94 100.00 77,188,966.20 100.00 Portfolio Holdings as of 12/31/2025 Portfolio Holdings as of 3/31/2026 Begin Date: 12/31/2025, End Date: 3/31/2026All Portfolios Distribution by Main Fund - Market Value City of Colleyville | TX 7 90355GWT9 867.07UBS Bank USA 4.1 6/4/2027 0.000.004/4/2026 867.07 843383EA4 782.47SOUTHERN BK POPLAR 3.7 2/5/2027 0.000.004/6/2026 782.47 59013K7B6 815.22Merrick Bank 4.05 5/8/2026 0.000.004/9/2026 815.22 32022RYV3 805.151st Financial Bank USA 4 7/10/2026 0.000.004/10/2026 805.15 29367RNH5 835.34Enterprise Bank 4.15 12/10/2026 0.000.004/10/2026 835.34 06426KEQ7 803.62Bank New Eng Salem N 3.8 2/12/2027 0.000.004/13/2026 803.62 89841MCT2 803.62TRUSTONEE FINANCIAL 3.8 11/13/2026 0.000.004/14/2026 803.62 01882MAK8 835.34ALLIANT CR UN 3.95 10/15/2026 0.000.004/15/2026 835.34 48836LCM2 877.64Kemba Financial 4.15 7/24/2026 0.000.004/24/2026 877.64 30191MAL1 845.92FFB Bank 4 11/27/2026 0.000.004/27/2026 845.92 20786AKY0 746.47CONNECTONE BANK 3.8 7/30/2027 0.000.004/30/2026 746.47 9,017.860.00April 2026 9,017.86 90355GWT9 839.10UBS Bank USA 4.1 6/4/2027 0.000.005/4/2026 839.10 843383EA4 757.23SOUTHERN BK POPLAR 3.7 2/5/2027 0.000.005/6/2026 757.23 949764VJ0 794.96Wells Fargo Bk N A 3.9 10/7/2027 0.000.005/7/2026 794.96 59013K7B6 237,762.62Merrick Bank 4.05 5/8/2026 237,000.00237,000.005/8/2026 762.62 32022RYV3 779.181st Financial Bank USA 4 7/10/2026 0.000.005/10/2026 779.18 29367RNH5 808.40Enterprise Bank 4.15 12/10/2026 0.000.005/10/2026 808.40 06426KEQ7 777.70Bank New Eng Salem N 3.8 2/12/2027 0.000.005/13/2026 777.70 89841MCT2 777.70TRUSTONEE FINANCIAL 3.8 11/13/2026 0.000.005/14/2026 777.70 05612LCL4 4,920.47BMW Bank of North America 4.05 11/16/2026 0.000.005/15/2026 4,920.47 01882MAK8 808.40ALLIANT CR UN 3.95 10/15/2026 0.000.005/15/2026 808.40 26879TAK5 2,439.21EPB Employeees Cr Un 4.05 9/21/2026 0.000.005/21/2026 2,439.21 48836LCM2 849.33Kemba Financial 4.15 7/24/2026 0.000.005/24/2026 849.33 22282XAN0 2,439.21COVANTAGE 4.05 8/27/2026 0.000.005/27/2026 2,439.21 CUSIP TotalDescriptionPrincipal AmountFace Amount/SharesDate Interest/Dividends Begin Date: 04-2026, End Date: 09-2026All Portfolios Projected Cash Flow by Month City of Colleyville | TX 8 61690DB49 5,021.39Morgan Stanley Bank 4.15 11/27/2026 0.000.005/27/2026 5,021.39 30191MAL1 818.63FFB Bank 4 11/27/2026 0.000.005/27/2026 818.63 20786AKY0 771.35CONNECTONE BANK 3.8 7/30/2027 0.000.005/31/2026 771.35 261,364.88237,000.00May 2026 24,364.88 90355GWT9 867.07UBS Bank USA 4.1 6/4/2027 0.000.006/4/2026 867.07 843383EA4 782.47SOUTHERN BK POPLAR 3.7 2/5/2027 0.000.006/6/2026 782.47 949764VJ0 821.46Wells Fargo Bk N A 3.9 10/7/2027 0.000.006/7/2026 821.46 32022RYV3 805.151st Financial Bank USA 4 7/10/2026 0.000.006/10/2026 805.15 29367RNH5 835.34Enterprise Bank 4.15 12/10/2026 0.000.006/10/2026 835.34 73317AFC1 2,284.88POPULAR BK NEW YORK 3.7 3/10/2028 0.000.006/11/2026 2,284.88 68405VCV9 4,966.36Optum Bank, Inc 4.15 12/11/2026 0.000.006/11/2026 4,966.36 06426KEQ7 803.62Bank New Eng Salem N 3.8 2/12/2027 0.000.006/13/2026 803.62 89841MCT2 803.62TRUSTONEE FINANCIAL 3.8 11/13/2026 0.000.006/14/2026 803.62 01882MAK8 835.34ALLIANT CR UN 3.95 10/15/2026 0.000.006/15/2026 835.34 48836LCM2 877.64Kemba Financial 4.15 7/24/2026 0.000.006/24/2026 877.64 38150VF61 244,786.85Goldman Sachs Bank USA 4 6/24/2026 240,000.00240,000.006/24/2026 4,786.85 30191MAL1 845.92FFB Bank 4 11/27/2026 0.000.006/27/2026 845.92 3130AMSS2 2,412,600.00FHLB 1.05 6/30/2026-23 2,400,000.002,400,000.006/30/2026 12,600.00 20786AKY0 746.47CONNECTONE BANK 3.8 7/30/2027 0.000.006/30/2026 746.47 2,673,662.192,640,000.00June 2026 33,662.19 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 32022RYV3 237,779.181st Financial Bank USA 4 7/10/2026 237,000.00237,000.007/10/2026 779.18 29367RNH5 808.40Enterprise Bank 4.15 12/10/2026 0.000.007/10/2026 808.40 CUSIP TotalDescriptionPrincipal AmountFace Amount/SharesDate Interest/Dividends Begin Date: 04-2026, End Date: 09-2026All Portfolios Projected Cash Flow by Month City of Colleyville | TX 9 3133ET7H4 27,219.38FFCB 3.375 1/13/2027 0.000.007/13/2026 27,219.38 06426KEQ7 777.70Bank New Eng Salem N 3.8 2/12/2027 0.000.007/13/2026 777.70 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 48836LCM2 249,849.33Kemba Financial 4.15 7/24/2026 249,000.00249,000.007/24/2026 849.33 219236BZ8 249,693.37Cornerstone Bank 4.05 7/24/2026 240,000.00240,000.007/24/2026 9,693.37 30191MAL1 818.63FFB Bank 4 11/27/2026 0.000.007/27/2026 818.63 20786AKY0 771.35CONNECTONE BANK 3.8 7/30/2027 0.000.007/31/2026 771.35 1,021,534.73966,000.00July 2026 55,534.73 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 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 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 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 20786AKY0 771.35CONNECTONE BANK 3.8 7/30/2027 0.000.008/31/2026 771.35 269,403.22247,000.00August 2026 22,403.22 90355GWT9 867.07UBS Bank USA 4.1 6/4/2027 0.000.009/4/2026 867.07 CUSIP TotalDescriptionPrincipal AmountFace Amount/SharesDate Interest/Dividends Begin Date: 04-2026, End Date: 09-2026All Portfolios Projected Cash Flow by Month City of Colleyville | TX 10 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 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 3130B9YL8 19,333.33FHLB 4 3/21/2028-26 0.000.009/21/2026 19,333.33 26879TAK5 247,849.61EPB Employeees Cr Un 4.05 9/21/2026 247,000.00247,000.009/21/2026 849.61 30191MAL1 845.92FFB Bank 4 11/27/2026 0.000.009/27/2026 845.92 20786AKY0 746.47CONNECTONE BANK 3.8 7/30/2027 0.000.009/30/2026 746.47 276,809.13247,000.00September 2026 29,809.13 4,511,792.014,337,000.00TOTAL 174,792.01 CUSIP TotalDescriptionPrincipal AmountFace Amount/SharesDate Interest/Dividends Begin Date: 04-2026, End Date: 09-2026All Portfolios Projected Cash Flow by Month City of Colleyville | TX 11 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.02 3.92 545.42 237,052.14 52.14 0.31% FDIC Insured FDIC Insured 0.28 101 01882MAK8 ALLIANT CR UN 3.95 10/15/2026 249,000.00 10/15/2025 3.95 249,000.00 249,000.00 100.01 3.94 431.15 249,017.43 17.43 0.33% FDIC Insured FDIC Insured 0.53 198 02589AGP1 American Express 4.2 2/26/2027 237,000.00 2/26/2025 4.20 237,000.00 237,000.00 100.28 3.88 899.95 237,658.86 658.86 0.31% FDIC Insured FDIC Insured 0.9 332 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.93 3.89 466.62 248,820.72 -179.28 0.33% FDIC Insured FDIC Insured 0.85 318 06051XZA3 Bank of America 4.1 7/23/2026 240,000.00 7/23/2025 4.10 240,000.00 240,000.00 100.04 3.88 6,766.68 240,084.00 84.00 0.31% FDIC Insured FDIC Insured 0.31 114 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.15 3.81 3,697.15 245,357.70 357.70 0.32% FDIC Insured FDIC Insured 0.62 230 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.94 3.88 1,145.68 235,853.68 -146.32 0.31% FDIC Insured FDIC Insured 1.37 500 20786AKY0 CONNECTONE BANK 3.8 7/30/2027 239,000.00 1/30/2026 3.80 239,000.00 239,000.00 99.90 3.88 0.00 238,758.61 -241.39 0.31% FDIC Insured FDIC Insured 1.3 486 219236BZ8 Cornerstone Bank 4.05 7/24/2026 240,000.00 7/25/2025 4.05 240,000.00 240,000.00 100.02 3.88 6,630.90 240,048.00 48.00 0.31% FDIC Insured FDIC Insured 0.32 115 22282XAN0 COVANTAGE 4.05 8/27/2026 247,000.00 8/27/2025 4.05 247,000.00 247,000.00 100.03 3.96 877.02 247,083.98 83.98 0.32% FDIC Insured FDIC Insured 0.41 149 29367RNH5 Enterprise Bank 4.15 12/10/2026 237,000.00 12/10/2024 4.15 237,000.00 237,000.00 100.19 3.87 565.88 237,452.67 452.67 0.31% FDIC Insured FDIC Insured 0.68 254 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.10 3.83 1,041.46 247,254.41 254.41 0.32% FDIC Insured FDIC Insured 0.47 174 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: 3/31/2026Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 12 30191MAL1 FFB Bank 4 11/27/2026 249,000.00 11/27/2024 4.00 249,000.00 249,000.00 100.09 3.87 109.15 249,214.14 214.14 0.33% FDIC Insured FDIC Insured 0.65 241 34061LAE8 Florida CR UN 3.8 12/15/2026 240,000.00 12/15/2025 3.80 240,000.00 240,000.00 99.93 3.85 2,648.55 239,839.20 -160.80 0.31% FDIC Insured FDIC Insured 0.71 259 38150VF61 Goldman Sachs Bank USA 4 6/24/2026 240,000.00 12/24/2024 4.00 240,000.00 240,000.00 100.00 3.95 2,551.23 240,002.40 2.40 0.31% FDIC Insured FDIC Insured 0.23 85 48836LCM2 Kemba Financial 4.15 7/24/2026 249,000.00 7/24/2025 4.15 249,000.00 249,000.00 100.05 3.99 198.18 249,126.99 126.99 0.33% FDIC Insured FDIC Insured 0.31 115 59013K7B6 Merrick Bank 4.05 5/8/2026 237,000.00 5/9/2025 4.00 237,012.37 237,118.50 100.00 4.01 578.54 237,009.48 -2.89 0.31% FDIC Insured FDIC Insured 0.1 38 61690DB49 Morgan Stanley Bank 4.15 11/27/2026 244,000.00 11/27/2024 4.15 244,000.00 244,000.00 100.17 3.88 3,440.07 244,422.12 422.12 0.32% FDIC Insured FDIC Insured 0.65 241 61776NMA8 Morgan Stanley Bank 4.25 2/26/2027 240,000.00 2/26/2025 4.25 240,000.00 240,000.00 100.32 3.88 922.19 240,775.20 775.20 0.31% FDIC Insured FDIC Insured 0.9 332 68405VCV9 Optum Bank, Inc 4.15 12/11/2026 240,000.00 12/11/2024 4.15 240,000.00 240,000.00 100.18 3.89 3,001.64 240,420.00 420.00 0.31% FDIC Insured FDIC Insured 0.69 255 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.62 3.88 496.71 244,078.80 -921.20 0.32% FDIC Insured FDIC Insured 1.88 710 843383EA4 SOUTHERN BK POPLAR 3.7 2/5/2027 249,000.00 2/6/2026 3.70 249,000.00 249,000.00 99.85 3.89 631.03 248,616.54 -383.46 0.33% FDIC Insured FDIC Insured 0.83 311 89841MCT2 TRUSTONEE FINANCIAL 3.8 11/13/2026 249,000.00 11/14/2025 3.80 249,000.00 249,000.00 99.93 3.92 440.70 248,823.21 -176.79 0.33% FDIC Insured FDIC Insured 0.61 227 90355GWT9 UBS Bank USA 4.1 6/4/2027 249,000.00 6/4/2025 4.10 249,000.00 249,000.00 100.24 3.89 755.19 249,592.62 592.62 0.33% FDIC Insured FDIC Insured 1.15 430 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: 3/31/2026Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 13 259 0.7 7.63% 2,350.53 5,836,362.90 38,841.093.90 5,834,118.50 5,834,012.373.995,834,000.00Sub Total CD | Negotiable (Brokered) | 100% Operating Cash | TBD% OPERATINGCASH Cash | Operating Cash 56,728.27 6/30/2024 3.16 56,728.27 56,728.27 100.00 3.16 56,728.27 0.00 0.07% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 1,118,885.29 6/30/2024 3.16 1,118,885.29 1,118,885.29 100.00 3.16 1,118,885.29 0.00 1.46% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 2,829.34 6/30/2024 3.16 2,829.34 2,829.34 100.00 3.16 2,829.34 0.00 0% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 4,645,818.32 6/30/2024 3.16 4,645,818.32 4,645,818.32 100.00 3.16 4,645,818.32 0.00 6.07% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 57,327.81 6/30/2024 3.16 57,327.81 57,327.81 100.00 3.16 57,327.81 0.00 0.07% NR NR 0 1 OPERATINGCASH Cash | Operating Cash -36,589.67 6/30/2024 3.16 -36,589.67 -36,589.67 100.00 3.16 -36,589.67 0.00 -0.05% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 884,033.53 6/30/2024 3.16 884,033.53 884,033.53 100.00 3.16 884,033.53 0.00 1.16% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 560,588.94 6/30/2024 3.16 560,588.94 560,588.94 100.00 3.16 560,588.94 0.00 0.73% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 55,237.97 6/30/2024 3.16 55,237.97 55,237.97 100.00 3.16 55,237.97 0.00 0.07% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 860,654.77 6/30/2024 3.16 860,654.77 860,654.77 100.00 3.16 860,654.77 0.00 1.12% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 16,166.55 6/30/2024 3.16 16,166.55 16,166.55 100.00 3.16 16,166.55 0.00 0.02% 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: 3/31/2026Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 14 OPERATINGCASH Cash | Operating Cash 73,301.05 6/30/2024 3.16 73,301.05 73,301.05 100.00 3.16 73,301.05 0.00 0.1% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 1,194,755.55 6/30/2024 3.16 1,194,755.55 1,194,755.55 100.00 3.16 1,194,755.55 0.00 1.56% NR NR 0 1 OPERATINGCASH Cash | Operating Cash -3,108,165.46 6/30/2024 3.16 -3,108,165.46 -3,108,165.46 100.00 3.16 -3,108,165.46 0.00 -4.06% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 35,895.26 6/30/2024 3.16 35,895.26 35,895.26 100.00 3.16 35,895.26 0.00 0.05% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 134,888.01 6/30/2024 3.16 134,888.01 134,888.01 100.00 3.16 134,888.01 0.00 0.18% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 10,324.80 6/30/2024 3.16 10,324.80 10,324.80 100.00 3.16 10,324.80 0.00 0.01% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 82,850.53 6/30/2024 3.16 82,850.53 82,850.53 100.00 3.16 82,850.53 0.00 0.11% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 167,808.26 6/30/2024 3.16 167,808.26 167,808.26 100.00 3.16 167,808.26 0.00 0.22% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 681,290.19 6/30/2024 3.16 681,290.19 681,290.19 100.00 3.16 681,290.19 0.00 0.89% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 1,787,820.63 6/30/2024 3.16 1,787,820.63 1,787,820.63 100.00 3.16 1,787,820.63 0.00 2.34% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 150,063.88 6/30/2024 3.16 150,063.88 150,063.88 100.00 3.16 150,063.88 0.00 0.2% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 2,103,815.61 6/30/2024 3.16 2,103,815.61 2,103,815.61 100.00 3.16 2,103,815.61 0.00 2.75% 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: 3/31/2026Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 15 OPERATINGCASH Cash | Operating Cash 46,717.23 6/30/2024 3.16 46,717.23 46,717.23 100.00 3.16 46,717.23 0.00 0.06% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 12,178.97 6/30/2024 3.16 12,178.97 12,178.97 100.00 3.16 12,178.97 0.00 0.02% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 36,117.42 6/30/2024 3.16 36,117.42 36,117.42 100.00 3.16 36,117.42 0.00 0.05% NR NR 0 1 OPERATINGCASH Cash | Operating Cash 37,365.81 6/30/2025 3.16 37,365.81 37,365.81 100.00 3.16 37,365.81 0.00 0.05% NR NR 0 1 CEDCCASH CASH CEDC Cash 1,600,089.87 6/30/2024 3.16 1,600,089.87 1,600,089.87 100.00 3.16 1,600,089.87 0.00 2.09% NR NR 0 1 MBS8852 Multi-Bank Securities MM 271,505.26 6/30/2024 0.05 271,505.26 271,505.26 100.00 0.05 271,505.26 0.00 0.35% NR NR 0 1 1 0 17.69% 0.00 13,540,303.99 3.10 13,540,303.99 13,540,303.993.1013,540,303.99Sub Total Operating Cash | TBD% TX LGIP | 75% TEXASCLASS4001 Texas CLASS LGIP 2,759,245.03 6/30/2024 3.54 2,759,245.03 2,759,245.03 100.00 3.54 2,759,245.03 0.00 3.61% NR NR 0 1 TEXASCLASS4001 Texas CLASS LGIP 5,289,075.40 6/30/2024 3.54 5,289,075.40 5,289,075.40 100.00 3.54 5,289,075.40 0.00 6.91% NR NR 0 1 TEXASCLASS4001 Texas CLASS LGIP 2,196,729.06 6/30/2024 3.54 2,196,729.06 2,196,729.06 100.00 3.54 2,196,729.06 0.00 2.87% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 1,762,578.14 6/30/2024 3.65 1,762,578.14 1,762,578.14 100.00 3.65 1,762,578.14 0.00 2.3% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 1,207,989.50 6/30/2024 3.65 1,207,989.50 1,207,989.50 100.00 3.65 1,207,989.50 0.00 1.58% 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: 3/31/2026Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 16 TEXSTAR1110 TexasStar LGIP 1,165,930.57 6/30/2024 3.65 1,165,930.57 1,165,930.57 100.00 3.65 1,165,930.57 0.00 1.52% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 843,361.96 6/30/2024 3.65 843,361.96 843,361.96 100.00 3.65 843,361.96 0.00 1.1% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 584,971.01 6/30/2024 3.65 584,971.01 584,971.01 100.00 3.65 584,971.01 0.00 0.76% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 284,037.36 6/30/2024 3.65 284,037.36 284,037.36 100.00 3.65 284,037.36 0.00 0.37% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 10,862.09 6/30/2024 3.65 10,862.09 10,862.09 100.00 3.65 10,862.09 0.00 0.01% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 8,174,739.57 6/30/2024 3.65 8,174,739.57 8,174,739.57 100.00 3.65 8,174,739.57 0.00 10.68% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 299,885.82 6/30/2024 3.65 299,885.82 299,885.82 100.00 3.65 299,885.82 0.00 0.39% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 102,618.67 9/23/2025 3.65 102,618.67 102,618.67 100.00 3.65 102,618.67 0.00 0.13% NR NR 0 1 TEXPOOL0001 TexPool LGIP 796,684.13 6/30/2024 3.67 796,684.13 796,684.13 100.00 3.67 796,684.13 0.00 1.04% NR NR 0 1 TEXPOOL0001 TexPool LGIP 447,801.17 6/30/2024 3.67 447,801.17 447,801.17 100.00 3.67 447,801.17 0.00 0.59% NR NR 0 1 TEXPOOL0001 TexPool LGIP 5,240,035.87 6/30/2024 3.67 5,240,035.87 5,240,035.87 100.00 3.67 5,240,035.87 0.00 6.85% NR NR 0 1 TEXPOOL0001 TexPool LGIP 599,372.41 6/30/2024 3.67 599,372.41 599,372.41 100.00 3.67 599,372.41 0.00 0.78% 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: 3/31/2026Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 17 TEXPOOL0001 TexPool LGIP 11,491.09 6/30/2024 3.67 11,491.09 11,491.09 100.00 3.67 11,491.09 0.00 0.02% NR NR 0 1 TEXPOOL0001 TexPool LGIP 3,994,415.12 6/30/2024 3.67 3,994,415.12 3,994,415.12 100.00 3.67 3,994,415.12 0.00 5.22% NR NR 0 1 TEXPOOL0001 TexPool LGIP 2,331,559.55 6/30/2024 3.67 2,331,559.55 2,331,559.55 100.00 3.67 2,331,559.55 0.00 3.05% NR NR 0 1 TEXPOOL0001 TexPool LGIP 5,173,962.70 6/30/2024 3.67 5,173,962.70 5,173,962.70 100.00 3.67 5,173,962.70 0.00 6.76% NR NR 0 1 TEXPOOL0001 TexPool LGIP 987,150.12 6/30/2024 3.67 987,150.12 987,150.12 100.00 3.67 987,150.12 0.00 1.29% NR NR 0 1 TEXPOOL0001 TexPool LGIP 76,808.51 6/30/2024 3.67 76,808.51 76,808.51 100.00 3.67 76,808.51 0.00 0.1% NR NR 0 1 TEXPOOL0001 TexPool LGIP 2,544,503.61 6/30/2024 3.67 2,544,503.61 2,544,503.61 100.00 3.67 2,544,503.61 0.00 3.32% NR NR 0 1 TEXPOOL0001 TexPool LGIP 3,120,907.40 6/30/2024 3.67 3,120,907.40 3,120,907.40 100.00 3.67 3,120,907.40 0.00 4.08% NR NR 0 1 TEXPOOL0001 TexPool LGIP 211,494.15 6/30/2024 3.67 211,494.15 211,494.15 100.00 3.67 211,494.15 0.00 0.28% NR NR 0 1 1 0 65.61% 0.00 50,218,210.01 3.64 50,218,210.01 50,218,210.013.6450,218,210.01Sub Total TX LGIP | 75% TX LGIP Commerical Paper | 5% LOGIC8010 LOGIC | CEDC LGIP 547,401.92 6/30/2024 3.79 547,401.92 547,401.92 100.00 3.79 547,401.92 0.00 0.72% NR NR 0 1 LOGIC4001 LOGIC LGIP 819,036.97 6/30/2024 3.79 819,036.97 819,036.97 100.00 3.79 819,036.97 0.00 1.07% 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: 3/31/2026Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 18 LOGIC4001 LOGIC LGIP 40,149.52 6/30/2024 3.79 40,149.52 40,149.52 100.00 3.79 40,149.52 0.00 0.05% NR NR 0 1 LOGIC4001 LOGIC LGIP 98,844.98 6/30/2024 3.79 98,844.98 98,844.98 100.00 3.79 98,844.98 0.00 0.13% NR NR 0 1 LOGIC4001 LOGIC LGIP 180,734.21 6/30/2024 3.79 180,734.21 180,734.21 100.00 3.79 180,734.21 0.00 0.24% NR NR 0 1 LOGIC4001 LOGIC LGIP 225,619.98 6/30/2024 3.79 225,619.98 225,619.98 100.00 3.79 225,619.98 0.00 0.29% NR NR 0 1 LOGIC4001 LOGIC LGIP 1,560.63 6/30/2024 3.79 1,560.63 1,560.63 100.00 3.79 1,560.63 0.00 0% NR NR 0 1 LOGIC4001 LOGIC LGIP 28,824.69 6/30/2024 3.79 28,824.69 28,824.69 100.00 3.79 28,824.69 0.00 0.04% NR NR 0 1 1 0 2.54% 0.00 1,942,172.90 3.79 1,942,172.90 1,942,172.903.791,942,172.90Sub 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.74 3.71 11,795.06 1,608,790.07 -4,209.93 2.11% S&P-AA+ Moodys-Aaa 0.78 288 3130AMSS2 FHLB 1.05 6/30/2026-23 2,400,000.00 2/26/2025 4.08 2,382,656.03 2,305,680.00 99.34 3.72 6,300.00 2,384,064.00 1,407.97 3.11% S&P-AA+ Moodys-Aaa 0.25 91 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.87 4.07 444.44 998,680.00 -1,320.00 1.31% S&P-AA Moodys-Aa1 1.92 174 171 0.76 6.53% -4,121.96 4,991,534.07 18,539.503.79 4,918,680.00 4,995,656.033.845,013,000.00Sub Total US Agency | 75% % TBD, pending investment policy clarification TOTAL PORTFOLIO 76,547,686.90 3.59 76,530,355.30 76,453,485.40 3.58 57,380.59 76,528,583.87 -1,771.43 100.00% 0.1 32 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: 3/31/2026Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 19