Loading...
HomeMy WebLinkAboutAudit Committee-Agenda Packets-6/17/2025 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, JUNE 17, 2025 - 4:45 PM 1. CALL TO ORDER 2. APPROVAL OF MINUTES March 4, 2025 3. REPORTS Quarterly investment report as of March 31, 2025 4. ADJOURNMENT I hereby certify this agenda was posted on City Hall bulletin boards Friday, June 13, 2025 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, MARCH 4, 2025 - 5:00 PM 1. CALL TO ORDER City Secretary Christine Loven called the meeting to order at 5:00 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, Assistant City Manager Mark Wood, and City Secretary Christine Loven. 2. APPROVAL OF MINUTES August 20, 2024 The August 20, 2024 minutes were approved. 3. REGULAR AGENDA ITEMS 3a Discussion of the draft FY24 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, the new GASB Statement 100, 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 Karen Hines for her assistance and said Weaver looks forward to working with Cassie. With there being no questions regarding the audit, Ms. Gillen advised it will be become final and be presented at the March 11, 2024 City Council meeting for approval. 4. REPORTS Quarterly investment report as of September 30, 2024 Quarterly investment report as of December 31, 2024 City of Colleyville Page 2 Audit Committee Minutes March 4, 2025 Finance Director Cassie reviewed both investment reports. She highlighted the City’s portfolio composition and performance. Mrs. Smith stated she is still learning City’s processes and will continue 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:17 p.m. APPROVED THIS THE ___ DAY OF _____ 2025. 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 6/17/2025 Number - Type Report Department Finance Title Quarterly investment report as of March 31, 2025 Explanation Finance Director Cassie Smith will present the quarterly investment report. Attachments 1. Quarterly Investment Report Presentation - March 2025 2. Quarterly Investment Report - March 2025 Quarterly Investment Report March 31, 2025 Audit Committee June 17, 2025 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, $51.50 Cash, $15.79 CD, $7.24 FHLB, $4.81 FHLMC, $1.48 FFCB, $1.61 Total Value: $15.8 Cash 66.6 Investments $82.4 Million 3 Texas Class, $9.12 TexStar, $13.54 TexPool, $26.98 LOGIC*, $1.86 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 Performance Weighted Average Maturity: 2.23 months Weighted Average Yield: 4.33% 5.38%5.38% 4.64% 4.34%4.31% 5.39%5.40% 4.70%4.55% 4.36% 4.88% 5.13% 4.62% 4.42%4.24% 5.33%5.31%5.15% 4.54% 4.32%4.29% 4.64% 4.74% 4.42%4.30% 3.50% 4.00% 4.50% 5.00% 5.50% FY24 2nd Qtr (Mar)FY24 3rd Qtr (Jun)FY24 4th Qtr (Sep)FY25 1st Qtr (Dec)FY25 2nd Qtr (Mar) Yield Comparison 13-Week Treasury Bill Cash CD LGIP Agency Securities 5 Portfolio Performance $724,289 $755,427 $780,470 $662,846 $658,575 $600,000 $620,000 $640,000 $660,000 $680,000 $700,000 $720,000 $740,000 $760,000 $780,000 $800,000 FY24 2nd Qtr (Mar)FY24 3rd Qtr (Jun)FY24 4th Qtr (Sep)FY25 1st Qtr (Dec)FY25 2nd Qtr (Mar) Investment Interest Earnings Comparison 6 Questions & Discussion colleyvillegovernment Colleyville.com colleyvilletexas City of Colleyville I Texas MONTHLY INVESTMENT REPORT March 31, 2025 Comp liance I The City of Colleyville was in compliance with its investment pol icy 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 C ity . Asse t Category Face A mounUShares Mar ket Va lue Boo k Value % of Portfolio YTM@Cost Days To Maturity CD I Bank 11 00% 2,375,923.60 2 ,375 ,923 .60 2 ,375,9 23.60 2 .88 4 .11 8 5 CD I Negotiab le (Br okered) I 10 0% 4,861 ,000 .00 4,863,188 .88 4 ,861,000 .00 5 .90 4 .37 383 Operating Cas h I TB D¾ 15 ,786 ,235 .27 15,786 ,235 .27 15 ,786 ,235 .27 19 .15 4 .36 1 TX LG IP 175% 49 ,6 36 ,112 .54 49 ,636,112 .54 49 ,636 ,112 .54 60 .22 4 .32 1 TX LG IP Commerical Pape r I 5% 1,862 ,774 .62 1,862,774 .62 1,862 ,774 .62 2.26 4 .4 6 1 US Age ncy I 75 % 8 ,0 13 ,000.00 7,900 ,66 0.66 7,9 00 ,746 .09 9 .59 4 .30 433 Total / Average 82 ,5 35,046 .03 82 ,424 ,895.57 82 ,422 ,792 .12 100 .00 4 .33 67 -"--~--=--~..a....c;...---=;..__...;==-""-----UYL s-05/22/2025 Mark Wood , Assistant City Manager Date Cass ie Smith, Finance Director Date 5/22/2025 Karen Hines , Accounting Manager Date Asset Category Allocation Asset Category Market Value 12/31/2024 % of Portfolio 12/31/2024 Market Value 3/31/2025 % of Portfolio 3/31/2025 CD | Bank | 100%2,351,561.85 3.12 2,375,923.60 2.88 CD | Negotiable (Brokered) | 100%4,626,372.11 6.14 4,863,188.88 5.90 Operating Cash | TBD%18,436,047.39 24.47 15,786,235.27 19.15 TX LGIP | 75%45,128,075.28 59.89 49,636,112.54 60.22 TX LGIP Commerical Paper | 5%1,842,255.65 2.44 1,862,774.62 2.26 US Agency | 75%2,971,375.79 3.94 7,900,660.66 9.59 Total / Average 75,355,688.07 100.00 82,424,895.57 100.00 Portfolio Holdings as of 12/31/2024 Portfolio Holdings as of 3/31/2025 % TBD, pending investment policy clarification Begin Date: 12/31/2024, End Date: 3/31/2025Investment 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/2024 77,133,434.83 240,091.86 0.00 240,091.86 75,479,233.22 0.32 3.88 4.20 11/30/2024 71,727,647.50 210,076.79 0.00 210,076.79 70,940,826.60 0.30 3.61 4.34 12/31/2024 71,255,363.85 212,677.22 0.00 212,677.22 71,669,780.29 0.30 3.62 4.23 1/31/2025 75,428,327.88 211,928.55 0.00 211,928.55 75,482,211.85 0.28 3.42 4.18 2/28/2025 81,172,643.50 200,716.47 0.00 200,716.47 83,396,549.38 0.24 2.93 4.20 3/31/2025 83,751,828.11 245,930.31 0.00 245,930.31 83,561,537.02 0.29 3.59 4.06 Annualized TRR-BV Total/Average 77,133,434.83 1,321,421.20 0.00 1,321,421.20 76,233,595.91 1.73 3.50 4.20 Begin Date: 10/31/2024, End Date: 3/31/2025All 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/2024 71,603,416.54 71,594,613.22 8,803.32 4.79 4.82 0.06 24 11/30/2024 71,167,607.62 71,168,574.16 -966.54 4.67 4.65 0.08 31 12/31/2024 75,355,688.07 75,350,080.48 5,607.59 4.54 4.51 0.08 31 1/31/2025 81,077,223.24 81,080,662.93 -3,439.69 4.41 4.40 0.08 29 2/28/2025 83,635,909.10 83,642,159.09 -6,249.99 4.34 4.34 0.19 71 3/31/2025 82,424,895.57 82,422,792.12 2,103.45 4.33 4.31 0.18 68 Total / Average 77,544,123.36 77,543,147.00 976.36 4.50 4.49 0.11 43 Market Value / Book Value Comparison Begin Date: 10/31/2024, End Date: 3/31/2025All Portfolios Portfolio Summary by Month City of Colleyville | TX 4 Maturity Range Allocation Maturity Range Market Value 12/31/2024 % of Portfolio 12/31/2024 Market Value 3/31/2025 % of Portfolio 3/31/2025 0-1 Month 65,643,418.61 87.11 68,785,791.94 83.45 1-3 Months 2,580,429.16 3.42 2,345,807.96 2.85 3-6 Months 2,227,990.17 2.96 2,484,070.85 3.01 6-9 Months 2,462,033.27 3.27 742,201.44 0.90 9-12 Months 743,213.19 0.99 980,564.63 1.19 1-2 Years 1,698,603.67 2.25 5,480,636.60 6.65 2-3 Years 0.00 0.00 1,605,822.15 1.95 Total / Average 75,355,688.07 100.00 82,424,895.57 100.00 Portfolio Holdings as of 12/31/2024 Portfolio Holdings as of 3/31/2025 Begin Date: 12/31/2024, End Date: 3/31/2025All Portfolios Distribution by Maturity Range - Market Value City of Colleyville | TX 5 Security Type Allocation Security Type Market Value 12/31/2024 % of Portfolio 12/31/2024 Market Value 3/31/2025 % of Portfolio 3/31/2025 Cash 18,401,406.90 24.42 15,773,738.17 19.14 Certificate Of Deposit 1,606,414.99 2.13 1,623,170.12 1.97 Compound CD 745,146.86 0.99 752,753.48 0.91 FHLB Bond 1,503,760.79 2.00 4,812,553.51 5.84 FHLMC Bond 1,467,615.00 1.95 1,482,285.00 1.80 Local Government Investment Pool 46,970,330.93 62.33 51,498,887.16 62.48 Money Market 34,640.49 0.05 12,497.10 0.02 Negotiable Certificate Of Deposit 4,626,372.11 6.14 4,863,188.88 5.90 FFCB Bond 0.00 0.00 1,605,822.15 1.95 Total / Average 75,355,688.07 100.00 82,424,895.57 100.00 Portfolio Holdings as of 12/31/2024 Portfolio Holdings as of 3/31/2025 Begin Date: 12/31/2024, End Date: 3/31/2025All Portfolios Distribution by Security Type - Market Value City of Colleyville | TX 6 Main Fund Allocation Main Fund Market Value 12/31/2024 % of Portfolio 12/31/2024 Market Value 3/31/2025 % of Portfolio 3/31/2025 1 | General Fund 12,662,181.94 16.80 24,877,334.67 30.18 2 | Debt Service Funds 605,998.10 0.80 270,614.06 0.33 3 | Capital Project Funds 30,858,925.70 40.95 29,395,259.17 35.66 4 | Special Revenue Funds 11,412,612.52 15.14 8,691,811.07 10.55 5 | Enterprise Funds 19,779,620.08 26.25 19,153,514.71 23.24 6 | Fiduciary Funds 36,349.73 0.05 36,361.89 0.04 Total / Average 75,355,688.07 100.00 82,424,895.57 100.00 Portfolio Holdings as of 12/31/2024 Portfolio Holdings as of 3/31/2025 Begin Date: 12/31/2024, End Date: 3/31/2025All Portfolios Distribution by Main Fund - Market Value City of Colleyville | TX 7 08756MAA8 1,105.81Bethpage Federal CU NY 5.25 5/13/2025 0.000.004/1/2025 1,105.81 83616HAG9 909.36SOUND 4.3 2/2/2026 0.000.004/1/2025 909.36 3133ERVX6 32,743.90FFCB 4.06 10/7/2027-25 0.000.004/7/2025 32,743.90 29367RNH5 835.34Enterprise Bank 4.15 12/10/2026 0.000.004/10/2025 835.34 29367SLK8 888.21Enterprise Bank & Trust 4.2 12/10/2025 0.000.004/10/2025 888.21 32022RYV3 805.151ST FINANCIAL BANK USA 4 7/10/2026 0.000.004/10/2025 805.15 31762FAF6 919.94Financial Partners 4.35 9/12/2025 0.000.004/13/2025 919.94 3130B15Z6 1,539,000.00FHLB 5.2 4/25/2025 1,500,000.001,500,000.004/25/2025 39,000.00 31944MEE1 877.64First Carolina Bank 4.15 11/26/2025 0.000.004/26/2025 877.64 30191MAL1 845.92FFB Bank 4 11/27/2026 0.000.004/27/2025 845.92 1,578,931.271,500,000.00April 2025 78,931.27 83616HAG9 880.03SOUND 4.3 2/2/2026 0.000.005/1/2025 880.03 08756MAA8 1,070.14Bethpage Federal CU NY 5.25 5/13/2025 0.000.005/1/2025 1,070.14 06051XDJ8 249,205.50Bank of America NC 5.15 5/9/2025 237,000.00237,000.005/9/2025 12,205.50 29367RNH5 808.40Enterprise Bank 4.15 12/10/2026 0.000.005/10/2025 808.40 29367SLK8 859.56Enterprise Bank & Trust 4.2 12/10/2025 0.000.005/10/2025 859.56 32022RYV3 779.181ST FINANCIAL BANK USA 4 7/10/2026 0.000.005/10/2025 779.18 31762FAF6 890.26Financial Partners 4.35 9/12/2025 0.000.005/13/2025 890.26 08756MAA8 248,428.05Bethpage Federal CU NY 5.25 5/13/2025 248,000.00248,000.005/13/2025 428.05 05612LCL4 4,920.47BMW Bank of North America 4.05 11/16/2026 0.000.005/15/2025 4,920.47 CD0838-F 1,639,539.68Frost Bank 4.09 5/20/2025 1,623,170.121,623,170.125/20/2025 16,369.56 949764NQ3 249,442.50Wells Fargo Bank SD 5.25 5/21/2025 237,000.00237,000.005/21/2025 12,442.50 05584CNT9 6,145.57Bank of NY Mellon PA 5.1 11/24/2025 0.000.005/24/2025 6,145.57 31944MEE1 849.33First Carolina Bank 4.15 11/26/2025 0.000.005/26/2025 849.33 61690DB49 5,021.39Morgan Stanley Bank 4.15 11/27/2026 0.000.005/27/2025 5,021.39 CUSIP TotalDescriptionPrincipal AmountFace Amount/SharesDate Interest/Dividends Begin Date: 04-2025, End Date: 09-2025All Portfolios Projected Cash Flow by Month City of Colleyville | TX 8 30191MAL1 818.63FFB Bank 4 11/27/2026 0.000.005/27/2025 818.63 2,409,658.692,345,170.12May 2025 64,488.57 83616HAG9 909.36SOUND 4.3 2/2/2026 0.000.006/1/2025 909.36 CD1584-D 7,855.04Simmons Bank 4.14 9/9/2025 0.000.006/9/2025 7,855.04 29367RNH5 835.34Enterprise Bank 4.15 12/10/2026 0.000.006/10/2025 835.34 29367SLK8 888.21Enterprise Bank & Trust 4.2 12/10/2025 0.000.006/10/2025 888.21 32022RYV3 805.151ST FINANCIAL BANK USA 4 7/10/2026 0.000.006/10/2025 805.15 68405VCV9 4,966.36Optum Bank, Inc 4.15 12/11/2026 0.000.006/11/2025 4,966.36 31762FAF6 919.94Financial Partners 4.35 9/12/2025 0.000.006/13/2025 919.94 38150VF61 4,786.85Goldman Sachs Bank USA 4 6/24/2026 0.000.006/24/2025 4,786.85 31944MEE1 877.64First Carolina Bank 4.15 11/26/2025 0.000.006/26/2025 877.64 30191MAL1 845.92FFB Bank 4 11/27/2026 0.000.006/27/2025 845.92 3130AMSS2 12,600.00FHLB 1.05 6/30/2026-23 0.000.006/30/2025 12,600.00 36,289.810.00June 2025 36,289.81 83616HAG9 880.03SOUND 4.3 2/2/2026 0.000.007/1/2025 880.03 29367RNH5 808.40Enterprise Bank 4.15 12/10/2026 0.000.007/10/2025 808.40 29367SLK8 859.56Enterprise Bank & Trust 4.2 12/10/2025 0.000.007/10/2025 859.56 32022RYV3 779.181ST FINANCIAL BANK USA 4 7/10/2026 0.000.007/10/2025 779.18 31762FAF6 890.26Financial Partners 4.35 9/12/2025 0.000.007/13/2025 890.26 3137EAEU9 1,502,812.50FHLMC 0.375 7/21/2025 1,500,000.001,500,000.007/21/2025 2,812.50 31944MEE1 849.33First Carolina Bank 4.15 11/26/2025 0.000.007/26/2025 849.33 30191MAL1 818.63FFB Bank 4 11/27/2026 0.000.007/27/2025 818.63 1,508,697.891,500,000.00July 2025 8,697.89 83616HAG9 909.36SOUND 4.3 2/2/2026 0.000.008/1/2025 909.36 29367RNH5 835.34Enterprise Bank 4.15 12/10/2026 0.000.008/10/2025 835.34 CUSIP TotalDescriptionPrincipal AmountFace Amount/SharesDate Interest/Dividends Begin Date: 04-2025, End Date: 09-2025All Portfolios Projected Cash Flow by Month City of Colleyville | TX 9 29367SLK8 888.21Enterprise Bank & Trust 4.2 12/10/2025 0.000.008/10/2025 888.21 32022RYV3 805.151ST FINANCIAL BANK USA 4 7/10/2026 0.000.008/10/2025 805.15 3130B54H8 22,524.17FHLB 4.53 2/12/2027-25 0.000.008/12/2025 22,524.17 31762FAF6 919.94Financial Partners 4.35 9/12/2025 0.000.008/13/2025 919.94 31944MEE1 877.64First Carolina Bank 4.15 11/26/2025 0.000.008/26/2025 877.64 02589AGP1 4,936.09American Express 4.2 2/26/2027 0.000.008/26/2025 4,936.09 61776NMA8 5,058.08Morgan Stanley Bank 4.25 2/26/2027 0.000.008/26/2025 5,058.08 30191MAL1 845.92FFB Bank 4 11/27/2026 0.000.008/27/2025 845.92 38,599.900.00August 2025 38,599.90 83616HAG9 909.36SOUND 4.3 2/2/2026 0.000.009/1/2025 909.36 320437AH9 5,104.61First Guaranty Bank 4.15 3/6/2026 0.000.009/6/2025 5,104.61 CD1584-D 760,608.52Simmons Bank 4.14 9/9/2025 752,753.48752,753.489/9/2025 7,855.04 29367RNH5 835.34Enterprise Bank 4.15 12/10/2026 0.000.009/10/2025 835.34 29367SLK8 888.21Enterprise Bank & Trust 4.2 12/10/2025 0.000.009/10/2025 888.21 32022RYV3 805.151ST FINANCIAL BANK USA 4 7/10/2026 0.000.009/10/2025 805.15 31762FAF6 249,890.26Financial Partners 4.35 9/12/2025 249,000.00249,000.009/12/2025 890.26 31944MEE1 877.64First Carolina Bank 4.15 11/26/2025 0.000.009/26/2025 877.64 30191MAL1 845.92FFB Bank 4 11/27/2026 0.000.009/27/2025 845.92 1,020,765.011,001,753.48September 2025 19,011.53 6,592,942.576,346,923.60TOTAL 246,018.97 CUSIP TotalDescriptionPrincipal AmountFace Amount/SharesDate Interest/Dividends Begin Date: 04-2025, End Date: 09-2025All Portfolios Projected Cash Flow by Month City of Colleyville | TX 10 CD | Bank | 100% CD0838-F Frost Bank 4.09 5/20/2025 1,623,170.12 2/19/2025 4.09 1,623,170.12 1,623,170.12 100.00 4.09 7,275.36 1,623,170.12 0.00 1.97% NR NR 0.14 50 CD1584-D Simmons Bank 4.14 9/9/2025 752,753.48 9/9/2024 4.14 752,753.48 752,753.48 100.00 4.14 1,878.38 752,753.48 0.00 0.91% NR NR 0.44 162 85 0.24 2.88% 0.00 2,375,923.60 9,153.744.11 2,375,923.60 2,375,923.604.112,375,923.60Sub Total CD | Bank | 100% 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 99.89 4.09 545.42 236,736.93 -263.07 0.29% FDIC Insured FDIC Insured 1.24 466 02589AGP1 American Express 4.2 2/26/2027 237,000.00 2/26/2025 4.20 237,000.00 237,000.00 100.20 4.09 899.95 237,483.48 483.48 0.29% FDIC Insured FDIC Insured 1.85 697 06051XDJ8 Bank of America NC 5.15 5/9/2025 237,000.00 5/9/2024 5.15 237,000.00 237,000.00 100.07 4.29 10,901.35 237,165.90 165.90 0.29% FDIC Insured FDIC Insured 0.11 39 05584CNT9 Bank of NY Mellon PA 5.1 11/24/2025 243,000.00 5/24/2024 5.10 243,000.00 243,000.00 100.56 4.21 4,312.08 244,360.80 1,360.80 0.29% FDIC Insured FDIC Insured 0.64 238 08756MAA8 Bethpage Federal CU NY 5.25 5/13/2025 248,000.00 5/13/2024 5.25 248,000.00 248,000.00 100.09 4.50 1,070.14 248,220.72 220.72 0.3% NCUA Insured NCUA Insured 0.12 43 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 99.98 4.06 3,697.15 244,951.00 -49.00 0.3% FDIC Insured FDIC Insured 1.57 595 29367SLK8 Enterprise Bank & Trust 4.2 12/10/2025 249,000.00 9/10/2024 4.20 249,000.00 249,000.00 100.00 4.20 601.69 248,997.51 -2.49 0.3% FDIC Insured FDIC Insured 0.68 254 29367RNH5 Enterprise Bank 4.15 12/10/2026 237,000.00 12/10/2024 4.15 237,000.00 237,000.00 100.10 4.09 565.88 237,244.11 244.11 0.29% FDIC Insured FDIC Insured 1.63 619 30191MAL1 FFB Bank 4 11/27/2026 249,000.00 11/27/2024 4.00 249,000.00 249,000.00 99.39 4.38 109.15 247,486.08 -1,513.92 0.3% FDIC Insured FDIC Insured 1.6 606 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/2025Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 11 31762FAF6 Financial Partners 4.35 9/12/2025 249,000.00 9/13/2024 4.35 249,000.00 249,000.00 100.01 4.32 534.16 249,032.37 32.37 0.3% FDIC Insured FDIC Insured 0.44 165 31944MEE1 First Carolina Bank 4.15 11/26/2025 249,000.00 11/26/2024 4.15 249,000.00 249,000.00 99.94 4.25 141.55 248,843.13 -156.87 0.3% FDIC Insured FDIC Insured 0.65 240 320437AH9 First Guaranty Bank 4.15 3/6/2026 244,000.00 9/6/2024 4.15 244,000.00 244,000.00 99.99 4.16 693.56 243,980.48 -19.52 0.3% FDIC Insured FDIC Insured 0.92 340 38150VF61 Goldman Sachs Bank USA 4 6/24/2026 240,000.00 12/24/2024 4.00 240,000.00 240,000.00 99.88 4.10 2,551.23 239,704.80 -295.20 0.29% FDIC Insured FDIC Insured 1.2 450 60700PLY5 Mizuho Bank USA Instl 4.25 3/12/2026 248,000.00 3/12/2025 4.25 248,000.00 248,000.00 100.13 4.10 548.66 248,322.40 322.40 0.3% FDIC Insured FDIC Insured 0.95 346 61690DB49 Morgan Stanley Bank 4.15 11/27/2026 244,000.00 11/27/2024 4.15 244,000.00 244,000.00 100.10 4.09 3,440.07 244,231.80 231.80 0.3% FDIC Insured FDIC Insured 1.6 606 61776NMA8 Morgan Stanley Bank 4.25 2/26/2027 240,000.00 2/26/2025 4.25 240,000.00 240,000.00 100.30 4.09 922.19 240,708.00 708.00 0.29% FDIC Insured FDIC Insured 1.85 697 68405VCV9 Optum Bank, Inc 4.15 12/11/2026 240,000.00 12/11/2024 4.15 240,000.00 240,000.00 100.09 4.09 3,001.64 240,206.40 206.40 0.29% FDIC Insured FDIC Insured 1.64 620 77357DAL2 Rockland Fed Credit Union 4.3 1/30/2026 239,000.00 1/30/2025 4.30 239,000.00 239,000.00 100.00 4.27 1,689.37 238,992.83 -7.17 0.29% FDIC Insured FDIC Insured 0.84 305 83616HAG9 SOUND 4.3 2/2/2026 249,000.00 1/31/2025 4.30 249,000.00 249,000.00 100.11 4.17 880.03 249,268.92 268.92 0.3% FDIC Insured FDIC Insured 0.82 308 949764NQ3 Wells Fargo Bank SD 5.25 5/21/2025 237,000.00 5/21/2024 5.25 237,000.00 237,000.00 100.11 4.29 10,703.96 237,251.22 251.22 0.29% FDIC Insured FDIC Insured 0.14 51 383 1.02 5.9% 2,188.88 4,863,188.88 47,809.234.19 4,861,000.00 4,861,000.004.374,861,000.00Sub Total CD | Negotiable (Brokered) | 100% Operating Cash | TBD% 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/2025Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 12 FROSTCASH1429 Frost Cash | CEDC Cash 2,018,516.05 6/30/2024 4.36 2,018,516.05 2,018,516.05 100.00 4.36 2,018,516.05 0.00 2.45% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 380,552.37 6/30/2024 4.36 380,552.37 380,552.37 100.00 4.36 380,552.37 0.00 0.46% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 892,865.75 6/30/2024 4.36 892,865.75 892,865.75 100.00 4.36 892,865.75 0.00 1.08% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash -14,720.49 6/30/2024 4.36 -14,720.49 -14,720.49 100.00 4.36 -14,720.49 0.00 -0.02% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 5,253,293.23 6/30/2024 4.36 5,253,293.23 5,253,293.23 100.00 4.36 5,253,293.23 0.00 6.37% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 48,394.39 6/30/2024 4.36 48,394.39 48,394.39 100.00 4.36 48,394.39 0.00 0.06% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 35,136.71 6/30/2024 4.36 35,136.71 35,136.71 100.00 4.36 35,136.71 0.00 0.04% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 1,072,804.57 6/30/2024 4.36 1,072,804.57 1,072,804.57 100.00 4.36 1,072,804.57 0.00 1.3% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 18,152.37 6/30/2024 4.36 18,152.37 18,152.37 100.00 4.36 18,152.37 0.00 0.02% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 646,900.14 6/30/2024 4.36 646,900.14 646,900.14 100.00 4.36 646,900.14 0.00 0.78% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 62,966.57 6/30/2024 4.36 62,966.57 62,966.57 100.00 4.36 62,966.57 0.00 0.08% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 270,614.06 6/30/2024 4.36 270,614.06 270,614.06 100.00 4.36 270,614.06 0.00 0.33% 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/2025Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 13 FROSTCASH1402 Frost Cash | Operating Cash 12,816.87 6/30/2024 4.36 12,816.87 12,816.87 100.00 4.36 12,816.87 0.00 0.02% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 2,032.68 6/30/2024 4.36 2,032.68 2,032.68 100.00 4.36 2,032.68 0.00 0% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 72,131.46 6/30/2024 4.36 72,131.46 72,131.46 100.00 4.36 72,131.46 0.00 0.09% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 467,762.04 6/30/2024 4.36 467,762.04 467,762.04 100.00 4.36 467,762.04 0.00 0.57% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash -415,136.37 6/30/2024 4.36 -415,136.37 -415,136.37 100.00 4.36 -415,136.37 0.00 -0.5% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 15,057.56 6/30/2024 4.36 15,057.56 15,057.56 100.00 4.36 15,057.56 0.00 0.02% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 35,054.80 6/30/2024 4.36 35,054.80 35,054.80 100.00 4.36 35,054.80 0.00 0.04% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 21,368.12 6/30/2024 4.36 21,368.12 21,368.12 100.00 4.36 21,368.12 0.00 0.03% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 9,382.01 6/30/2024 4.36 9,382.01 9,382.01 100.00 4.36 9,382.01 0.00 0.01% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 73,582.02 6/30/2024 4.36 73,582.02 73,582.02 100.00 4.36 73,582.02 0.00 0.09% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 141,597.65 6/30/2024 4.36 141,597.65 141,597.65 100.00 4.36 141,597.65 0.00 0.17% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 517,935.53 6/30/2024 4.36 517,935.53 517,935.53 100.00 4.36 517,935.53 0.00 0.63% 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/2025Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 14 FROSTCASH1402 Frost Cash | Operating Cash 520,128.61 6/30/2024 4.36 520,128.61 520,128.61 100.00 4.36 520,128.61 0.00 0.63% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 2,752,138.92 6/30/2024 4.36 2,752,138.92 2,752,138.92 100.00 4.36 2,752,138.92 0.00 3.34% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 146,550.26 6/30/2024 4.36 146,550.26 146,550.26 100.00 4.36 146,550.26 0.00 0.18% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 630,185.44 6/30/2024 4.36 630,185.44 630,185.44 100.00 4.36 630,185.44 0.00 0.76% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 19,774.57 6/30/2024 4.36 19,774.57 19,774.57 100.00 4.36 19,774.57 0.00 0.02% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 40,335.46 6/30/2024 4.36 40,335.46 40,335.46 100.00 4.36 40,335.46 0.00 0.05% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 12,856.83 6/30/2024 4.36 12,856.83 12,856.83 100.00 4.36 12,856.83 0.00 0.02% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 12,707.99 6/30/2024 4.36 12,707.99 12,707.99 100.00 4.36 12,707.99 0.00 0.02% NR NR 0 1 MBS8852 Multi-Bank Securities MM 12,497.10 6/30/2024 0.10 12,497.10 12,497.10 100.00 0.10 12,497.10 0.00 0.02% NR NR 0 1 1 0 19.16% 0.00 15,786,235.27 4.36 15,786,235.27 15,786,235.274.3615,786,235.27Sub Total Operating Cash | TBD% TX LGIP | 75% TEXASCLASS4001 Texas CLASS LGIP 2,651,854.21 6/30/2024 4.25 2,651,854.21 2,651,854.21 100.00 4.25 2,651,854.21 0.00 3.22% NR NR 0 1 TEXASCLASS4001 Texas CLASS LGIP 4,358,334.79 6/30/2024 4.25 4,358,334.79 4,358,334.79 100.00 4.25 4,358,334.79 0.00 5.29% 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/2025Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 15 TEXASCLASS4001 Texas CLASS LGIP 2,111,231.57 6/30/2024 4.25 2,111,231.57 2,111,231.57 100.00 4.25 2,111,231.57 0.00 2.56% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 6,909.74 6/30/2024 4.34 6,909.74 6,909.74 100.00 4.34 6,909.74 0.00 0.01% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 2,970,263.18 6/30/2024 4.34 2,970,263.18 2,970,263.18 100.00 4.34 2,970,263.18 0.00 3.6% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 1,117,215.11 6/30/2024 4.34 1,117,215.11 1,117,215.11 100.00 4.34 1,117,215.11 0.00 1.36% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 1,160,117.20 6/30/2024 4.34 1,160,117.20 1,160,117.20 100.00 4.34 1,160,117.20 0.00 1.41% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 3,770.45 6/30/2024 4.34 3,770.45 3,770.45 100.00 4.34 3,770.45 0.00 0% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 1,119,725.07 6/30/2024 4.34 1,119,725.07 1,119,725.07 100.00 4.34 1,119,725.07 0.00 1.36% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 907,823.49 6/30/2024 4.34 907,823.49 907,823.49 100.00 4.34 907,823.49 0.00 1.1% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 561,788.77 6/30/2024 4.34 561,788.77 561,788.77 100.00 4.34 561,788.77 0.00 0.68% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 272,781.05 6/30/2024 4.34 272,781.05 272,781.05 100.00 4.34 272,781.05 0.00 0.33% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 10,431.63 6/30/2024 4.34 10,431.63 10,431.63 100.00 4.34 10,431.63 0.00 0.01% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 5,120,034.37 6/30/2024 4.34 5,120,034.37 5,120,034.37 100.00 4.34 5,120,034.37 0.00 6.21% 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/2025Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 16 TEXSTAR1110 TexasStar LGIP 288,001.43 6/30/2024 4.34 288,001.43 288,001.43 100.00 4.34 288,001.43 0.00 0.35% NR NR 0 1 TEXPOOL0001 TexPool LGIP 813,808.18 6/30/2024 4.34 813,808.18 813,808.18 100.00 4.34 813,808.18 0.00 0.99% NR NR 0 1 TEXPOOL0001 TexPool LGIP 721,338.55 6/30/2024 4.34 721,338.55 721,338.55 100.00 4.34 721,338.55 0.00 0.88% NR NR 0 1 TEXPOOL0001 TexPool LGIP 2,367,211.87 6/30/2024 4.34 2,367,211.87 2,367,211.87 100.00 4.34 2,367,211.87 0.00 2.87% NR NR 0 1 TEXPOOL0001 TexPool LGIP 575,311.22 6/30/2024 4.34 575,311.22 575,311.22 100.00 4.34 575,311.22 0.00 0.7% NR NR 0 1 TEXPOOL0001 TexPool LGIP 11,029.79 6/30/2024 4.34 11,029.79 11,029.79 100.00 4.34 11,029.79 0.00 0.01% NR NR 0 1 TEXPOOL0001 TexPool LGIP 4,030,487.85 6/30/2024 4.34 4,030,487.85 4,030,487.85 100.00 4.34 4,030,487.85 0.00 4.89% NR NR 0 1 TEXPOOL0001 TexPool LGIP 2,237,961.52 6/30/2024 4.34 2,237,961.52 2,237,961.52 100.00 4.34 2,237,961.52 0.00 2.72% NR NR 0 1 TEXPOOL0001 TexPool LGIP 7,628,727.53 6/30/2024 4.34 7,628,727.53 7,628,727.53 100.00 4.34 7,628,727.53 0.00 9.26% NR NR 0 1 TEXPOOL0001 TexPool LGIP 995,664.48 6/30/2024 4.34 995,664.48 995,664.48 100.00 4.34 995,664.48 0.00 1.21% NR NR 0 1 TEXPOOL0001 TexPool LGIP 73,725.12 6/30/2024 4.34 73,725.12 73,725.12 100.00 4.34 73,725.12 0.00 0.09% NR NR 0 1 TEXPOOL0001 TexPool LGIP 4,565,310.02 6/30/2024 4.34 4,565,310.02 4,565,310.02 100.00 4.34 4,565,310.02 0.00 5.54% 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/2025Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 17 TEXPOOL0001 TexPool LGIP 2,752,250.41 6/30/2024 4.34 2,752,250.41 2,752,250.41 100.00 4.34 2,752,250.41 0.00 3.34% NR NR 0 1 TEXPOOL0001 TexPool LGIP 203,003.94 6/30/2024 4.34 203,003.94 203,003.94 100.00 4.34 203,003.94 0.00 0.25% NR NR 0 1 1 0 60.24% 0.00 49,636,112.54 4.32 49,636,112.54 49,636,112.544.3249,636,112.54Sub Total TX LGIP | 75% TX LGIP Commerical Paper | 5% LOGIC8010 LOGIC | CEDC LGIP 525,023.45 6/30/2024 4.46 525,023.45 525,023.45 100.00 4.46 525,023.45 0.00 0.64% NR NR 0 1 LOGIC4001 LOGIC LGIP 785,553.83 6/30/2024 4.46 785,553.83 785,553.83 100.00 4.46 785,553.83 0.00 0.95% NR NR 0 1 LOGIC4001 LOGIC LGIP 38,508.16 6/30/2024 4.46 38,508.16 38,508.16 100.00 4.46 38,508.16 0.00 0.05% NR NR 0 1 LOGIC4001 LOGIC LGIP 94,804.08 6/30/2024 4.46 94,804.08 94,804.08 100.00 4.46 94,804.08 0.00 0.12% NR NR 0 1 LOGIC4001 LOGIC LGIP 173,345.60 6/30/2024 4.46 173,345.60 173,345.60 100.00 4.46 173,345.60 0.00 0.21% NR NR 0 1 LOGIC4001 LOGIC LGIP 216,396.38 6/30/2024 4.46 216,396.38 216,396.38 100.00 4.46 216,396.38 0.00 0.26% NR NR 0 1 LOGIC4001 LOGIC LGIP 1,496.83 6/30/2024 4.46 1,496.83 1,496.83 100.00 4.46 1,496.83 0.00 0% NR NR 0 1 LOGIC4001 LOGIC LGIP 27,646.29 6/30/2024 4.46 27,646.29 27,646.29 100.00 4.46 27,646.29 0.00 0.03% NR NR 0 1 1 0 2.26% 0.00 1,862,774.62 4.46 1,862,774.62 1,862,774.624.461,862,774.62Sub Total TX LGIP Commerical Paper | 5% US Agency | 75% 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/2025Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 18 3133ERVX6 FFCB 4.06 10/7/2027-25 1,613,000.00 2/26/2025 4.26 1,605,234.97 1,604,935.00 99.56 4.25 31,652.44 1,605,822.15 587.18 1.95% S&P-AA+ Moodys-Aaa 2.37 190 3130AMSS2 FHLB 1.05 6/30/2026-23 2,400,000.00 2/26/2025 4.08 2,312,500.66 2,305,680.00 96.36 4.06 6,300.00 2,312,664.00 163.34 2.81% S&P-AA+ Moodys-Aaa 1.24 91 3130B54H8 FHLB 4.53 2/12/2027-25 1,000,000.00 2/26/2025 4.53 1,000,000.00 1,000,000.00 99.92 4.57 6,040.00 999,220.00 -780.00 1.21% None Moodys-Aaa 1.8 42 3130B15Z6 FHLB 5.2 4/25/2025 1,500,000.00 8/29/2024 4.48 1,500,692.54 1,506,809.94 100.04 4.43 33,800.00 1,500,669.51 -23.03 1.82% S&P-AA+ Moodys-Aaa 0.07 25 3137EAEU9 FHLMC 0.375 7/21/2025 1,500,000.00 8/29/2024 4.35 1,482,317.92 1,448,239.73 98.82 4.29 1,093.75 1,482,285.00 -32.92 1.8% S&P-AA+ Moodys-Aaa 0.31 112 96 1.14 9.59% -85.43 7,900,660.66 78,886.194.28 7,865,664.67 7,900,746.094.308,013,000.00Sub Total US Agency | 75% % TBD, pending investment policy clarification TOTAL PORTFOLIO 82,535,046.03 4.33 82,422,792.12 82,387,710.70 4.31 135,849.16 82,424,895.57 2,103.45 100.00% 0.18 35 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/2025Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 19