The URL can be used to link to this page

Home My WebLink AboutAudit Committee-Agenda Packets-11/18/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, NOVEMBER 18, 2025 - 5:00 PM 1. CALL TO ORDER 2. APPROVAL OF MINUTES 2a Audit Committee Meeting Minutes - August 19, 2025 3. REGULAR AGENDA ITEMS 3a Quarterly investment report as of September 30, 2025 4. ADJOURNMENT I hereby certify this agenda was posted on City Hall bulletin boards November 12, 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, AUGUST 19, 2025 – 4:30 P.M. 1. CALL TO ORDER City Secretary Christine Loven called the meeting to order at 4:30 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 June 17, 2025 The June 17, 2025 minutes were approved as presented. 3. REGULAR AGENDA ITEMS 3a Approval of the City of Colleyville Investment Policy annual review Finance Director Cassie Smith stated the Investment Policy is in accordance with Chapter 2256 of the Texas Government Code – Public Funds Investment Act, and is required to be reviewed annually. She noted as the policy was updated and approved last year, there are no recommended changes. 3b Quarterly investment report as of June 30, 2025 Finance Director Cassie Smith reviewed the report, and explained the portfolio performance and investment distribution. She noted the TexPool accounts are paying better in this quarter and cash is doing well. There was no discussion. 4. ADJOURNMENT The meeting adjourned at 4:35 p.m. City of Colleyville Page 2 Audit Committee Minutes August 19, 2025 PASSED ON THIS THE ____ DAY OF ____ 202X. 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 11/18/2025 Number 3a Type Regular Agenda Items Department Finance Title Quarterly investment report as of September 30, 2025 Explanation Finance Director Cassie Smith will present the Quarterly investment report as of September 30, 2025. Attachments 1. 2025-09 Investment Report 2. Quarterly Investment Report Presentation 4th Qtr FY25 Asset CategoryFace Amount/SharesMarket ValueBook Value% of PortfolioYTM @ CostDays To MaturityCD | Negotiable (Brokered) | 100%5,599,000.005,611,765.355,599,071.627.464.17298Operating Cash | TBD%14,333,057.52 14,333,057.52 14,333,057.5219.114.301TX LGIP | 75%48,210,467.63 48,210,467.63 48,210,467.6364.284.231TX LGIP Commerical Paper | 5%1,904,277.571,904,277.571,904,277.572.544.331US Agency | 75%5,013,000.004,967,552.214,957,864.166.614.10401Total / Average75,059,802.7275,027,120.2875,004,738.50100.004.2350DateDateDateKaren Hines, Accounting ManagerCassie Smith, Finance DirectorMark Wood, Assistant City ManagerCompliance | The City of Colleyville was in compliance with its investment policy and the Public Funds Investment Act. Specifically, the City only purchasessecurities from brokers who have reviewed the investment policy and signed a statement agreeing to comply with it. The maturity dates of the City’s investmentswill meet the anticipated cash flow needs of the City.City of Colleyville | TexasMONTHLY INVESTMENT REPORTSeptember 30, 2025 111/06/2025 Asset Category AllocationAsset CategoryMarket Value6/30/2025% of Portfolio6/30/2025Market Value9/30/2025% of Portfolio9/30/2025CD | Bank | 100% 760,608.52 0.94 0.00 0.00CD | Negotiable (Brokered) | 100% 4,874,613.07 6.01 5,611,765.35 7.60Operating Cash | TBD% 17,032,191.59 20.99 14,333,057.52 19.40TX LGIP | 75% 50,169,629.12 61.82 47,069,097.98 63.71TX LGIP Commerical Paper | 5% 1,883,413.92 2.32 1,904,277.57 2.58US Agency | 75% 6,435,566.99 7.93 4,967,552.21 6.72Total / Average81,156,023.21100.0073,885,750.63100.00Portfolio Holdings as of 6/30/2025Portfolio Holdings as of 9/30/2025% TBD, pending investment policy clarificationBegin Date: 6/30/2025, End Date: 9/30/2025Investment Policy ComplianceDistribution by Asset Category - Market ValueCity of Colleyville | TX2 MonthBeginning BV + Accrued InterestInterest Earned During Period-BVRealizedGain/Loss-BVInvestmentIncome-BVAverage Capital Base-BVTRR-BVAnnualized TRR-BVTreasury 1 Year4/30/2025 82,558,641.28 235,301.52 0.00 235,301.52 82,239,759.97 0.29 3.49 3.955/31/2025 82,218,832.80 236,254.25 0.00 236,254.25 80,796,981.66 0.29 3.57 4.086/30/2025 79,797,160.84 223,438.39 0.00 223,438.39 79,988,037.44 0.28 3.40 4.067/31/2025 81,212,796.52 231,842.44 0.00 231,842.44 80,836,619.17 0.29 3.50 4.088/31/2025 80,654,164.49 230,076.19 0.00 230,076.19 80,607,444.93 0.29 3.48 3.899/30/2025 81,123,727.27 217,788.08 0.00 217,788.08 79,843,073.17 0.27 3.32 3.66Annualized TRR-BVTotal/Average 82,558,641.28 1,374,700.87 0.00 1,374,700.87 80,229,885.37 1.71 3.46 3.95Begin Date: 4/30/2025, End Date: 9/30/2025All PortfoliosTotal Rate of Return - Book Value by MonthCity of Colleyville | TX3 MonthMarket ValueBook ValueUnrealized Gain/LossYTM @ CostYTM @ MarketDurationDays To Maturity4/30/2025 82,128,068.89 82,117,544.60 10,524.29 4.31 4.29 0.18 675/31/2025 79,724,096.12 79,734,324.00 -10,227.88 4.27 4.28 0.15 586/30/2025 81,156,023.21 81,156,172.35 -149.14 4.28 4.28 0.14 557/31/2025 80,564,478.16 80,575,133.84 -10,655.68 4.30 4.31 0.14 548/31/2025 81,048,386.83 81,031,686.98 16,699.85 4.29 4.27 0.13 509/30/2025 75,027,120.28 75,004,738.50 22,381.78 4.23 4.20 0.13 50Total / Average79,941,362.2579,936,600.054,762.204.284.270.1556Market Value / Book Value ComparisonBegin Date: 4/30/2025, End Date: 9/30/2025All PortfoliosPortfolio Summary by MonthCity of Colleyville | TX4 Maturity Range AllocationMaturity RangeMarket Value6/30/2025% of Portfolio6/30/2025Market Value9/30/2025% of Portfolio9/30/20250-1 Month 70,581,964.63 86.97 64,447,802.72 85.901-3 Months 1,009,511.41 1.24 741,171.93 0.993-6 Months 741,214.08 0.91 1,984,104.65 2.646-9 Months 1,984,548.57 2.45 477,384.06 0.649-12 Months 2,806,049.88 3.46 3,816,928.45 5.091-2 Years 2,427,880.29 2.99 1,949,680.26 2.602-3 Years 1,604,854.35 1.98 1,610,048.21 2.15Total / Average81,156,023.21100.0075,027,120.28100.00Portfolio Holdings as of 6/30/2025Portfolio Holdings as of 9/30/2025Begin Date: 6/30/2025, End Date: 9/30/2025All PortfoliosDistribution by Maturity Range - Market ValueCity of Colleyville | TX5 Security Type AllocationSecurity TypeMarket Value6/30/2025% of Portfolio6/30/2025Market Value9/30/2025% of Portfolio9/30/2025Cash 17,015,529.62 20.97 14,320,224.97 19.09Compound CD 760,608.52 0.94 0.00 0.00FFCB Bond 1,604,854.35 1.98 1,610,048.21 2.15FHLB Bond 3,333,982.64 4.11 3,357,504.00 4.48FHLMC Bond 1,496,730.00 1.84 0.00 0.00Local Government Investment Pool 52,053,043.04 64.14 50,114,745.20 66.80Money Market 16,661.97 0.02 12,832.55 0.02Negotiable Certificate Of Deposit 4,874,613.07 6.01 5,611,765.35 7.48Total / Average81,156,023.21100.0075,027,120.28100.00Portfolio Holdings as of 6/30/2025Portfolio Holdings as of 9/30/2025Begin Date: 6/30/2025, End Date: 9/30/2025All PortfoliosDistribution by Security Type - Market ValueCity of Colleyville | TX6 Main Fund AllocationMain FundMarket Value6/30/2025% of Portfolio6/30/2025Market Value9/30/2025% of Portfolio9/30/20251 | General Fund 20,787,904.76 25.61 16,919,427.06 22.552 | Debt Service Funds 734,542.39 0.91 349,101.37 0.473 | Capital Project Funds 29,086,287.01 35.84 28,963,699.91 38.604 | Special Revenue Funds 11,400,119.20 14.05 9,703,450.00 12.935 | Enterprise Funds 19,104,779.03 23.54 17,819,109.59 23.756 | Fiduciary Funds 38,702.49 0.05 15,757.51 0.02None 3,688.33 0.00 1,256,574.84 1.67Total / Average81,156,023.21100.0075,027,120.28100.00Portfolio Holdings as of 6/30/2025Portfolio Holdings as of 9/30/2025Begin Date: 6/30/2025, End Date: 9/30/2025All PortfoliosDistribution by Main Fund - Market ValueCity of Colleyville | TX7 83616HAG9880.03SOUND 4.3 2/2/2026 0.000.0010/1/2025880.0390355GWT9839.10UBS Bank USA 4.1 6/4/2027 0.000.0010/4/2025839.103133ERVX632,743.90FFCB 4.06 10/7/2027-25 0.000.0010/7/202532,743.9059013K7B6788.92Merrick Bank 4.05 5/8/2026 0.000.0010/9/2025788.9229367RNH5808.40Enterprise Bank 4.15 12/10/2026 0.000.0010/10/2025808.4029367SLK8859.56Enterprise Bank & Trust 4.2 12/10/2025 0.000.0010/10/2025859.5632022RYV3779.181st Financial Bank USA 4 7/10/2026 0.000.0010/10/2025779.183130ATMJ323,500.00FHLB 4.7 3/13/2026 0.000.0010/13/202523,500.0048836LCM2849.33Kemba Financial 4.15 7/24/2026 0.000.0010/24/2025849.3331944MEE1849.33First Carolina Bank 4.15 11/26/2025 0.000.0010/26/2025849.3330191MAL1818.63FFB Bank 4 11/27/2026 0.000.0010/27/2025818.6363,716.380.00October 202563,716.3883616HAG9909.36SOUND 4.3 2/2/2026 0.000.0011/1/2025909.3690355GWT9867.07UBS Bank USA 4.1 6/4/2027 0.000.0011/4/2025867.0759013K7B6815.22Merrick Bank 4.05 5/8/2026 0.000.0011/9/2025815.2229367RNH5835.34Enterprise Bank 4.15 12/10/2026 0.000.0011/10/2025835.3429367SLK8888.21Enterprise Bank & Trust 4.2 12/10/2025 0.000.0011/10/2025888.2132022RYV3805.151st Financial Bank USA 4 7/10/2026 0.000.0011/10/2025805.1501882MAK8835.34ALLIANT CR UN 3.95 10/15/2026 0.000.0011/15/2025835.3405612LCL45,002.03BMW Bank of North America 4.05 11/16/2026 0.000.0011/15/20255,002.0326879TAK52,521.43EPB Employeees Cr Un 4.05 9/21/2026 0.000.0011/21/20252,521.4348836LCM2877.64Kemba Financial 4.15 7/24/2026 0.000.0011/24/2025877.6405584CNT9249,247.43Bank of NY Mellon PA 5.1 11/24/2025 243,000.00243,000.0011/24/20256,247.4331944MEE1249,877.64First Carolina Bank 4.15 11/26/2025 249,000.00249,000.0011/26/2025877.6422282XAN02,521.43COVANTAGE 4.05 8/27/2026 0.000.0011/27/20252,521.43CUSIPTotalDescriptionPrincipal AmountFace Amount/SharesDateInterest/DividendsBegin Date: 10-2025, End Date: 03-2026All PortfoliosProjected Cash Flow by MonthCity of Colleyville | TX8 61690DB495,104.61Morgan Stanley Bank 4.15 11/27/2026 0.000.0011/27/20255,104.6130191MAL1845.92FFB Bank 4 11/27/2026 0.000.0011/27/2025845.92521,953.82492,000.00November 202529,953.8283616HAG9880.03SOUND 4.3 2/2/2026 0.000.0012/1/2025880.0390355GWT9839.10UBS Bank USA 4.1 6/4/2027 0.000.0012/4/2025839.1059013K7B6788.92Merrick Bank 4.05 5/8/2026 0.000.0012/9/2025788.9229367RNH5808.40Enterprise Bank 4.15 12/10/2026 0.000.0012/10/2025808.4029367SLK8249,859.56Enterprise Bank & Trust 4.2 12/10/2025 249,000.00249,000.0012/10/2025859.5632022RYV3779.181st Financial Bank USA 4 7/10/2026 0.000.0012/10/2025779.1868405VCV94,993.64Optum Bank, Inc 4.15 12/11/2026 0.000.0012/11/20254,993.6401882MAK8808.40ALLIANT CR UN 3.95 10/15/2026 0.000.0012/15/2025808.4048836LCM2849.33Kemba Financial 4.15 7/24/2026 0.000.0012/24/2025849.3338150VF614,813.15Goldman Sachs Bank USA 4 6/24/2026 0.000.0012/24/20254,813.1530191MAL1818.63FFB Bank 4 11/27/2026 0.000.0012/27/2025818.633130AMSS212,600.00FHLB 1.05 6/30/2026-23 0.000.0012/30/202512,600.00278,838.34249,000.00December 202529,838.3483616HAG9909.36SOUND 4.3 2/2/2026 0.000.001/1/2026909.3690355GWT9867.07UBS Bank USA 4.1 6/4/2027 0.000.001/4/2026867.0759013K7B6815.22Merrick Bank 4.05 5/8/2026 0.000.001/9/2026815.2229367RNH5835.34Enterprise Bank 4.15 12/10/2026 0.000.001/10/2026835.3432022RYV3805.151st Financial Bank USA 4 7/10/2026 0.000.001/10/2026805.1501882MAK8835.34ALLIANT CR UN 3.95 10/15/2026 0.000.001/15/2026835.3448836LCM2877.64Kemba Financial 4.15 7/24/2026 0.000.001/24/2026877.6430191MAL1845.92FFB Bank 4 11/27/2026 0.000.001/27/2026845.9277357DAL2249,277.00Rockland Fed Credit Union 4.3 1/30/2026 239,000.00239,000.001/30/202610,277.00CUSIPTotalDescriptionPrincipal AmountFace Amount/SharesDateInterest/DividendsBegin Date: 10-2025, End Date: 03-2026All PortfoliosProjected Cash Flow by MonthCity of Colleyville | TX9 256,068.04239,000.00January 202617,068.0483616HAG9909.36SOUND 4.3 2/2/2026 0.000.002/1/2026909.3683616HAG9249,029.33SOUND 4.3 2/2/2026 249,000.00249,000.002/2/202629.3390355GWT9867.07UBS Bank USA 4.1 6/4/2027 0.000.002/4/2026867.0759013K7B6815.22Merrick Bank 4.05 5/8/2026 0.000.002/9/2026815.2229367RNH5835.34Enterprise Bank 4.15 12/10/2026 0.000.002/10/2026835.3432022RYV3805.151st Financial Bank USA 4 7/10/2026 0.000.002/10/2026805.1501882MAK8835.34ALLIANT CR UN 3.95 10/15/2026 0.000.002/15/2026835.3426879TAK52,521.43EPB Employeees Cr Un 4.05 9/21/2026 0.000.002/21/20262,521.4348836LCM2877.64Kemba Financial 4.15 7/24/2026 0.000.002/24/2026877.6402589AGP15,017.91American Express 4.2 2/26/2027 0.000.002/26/20265,017.9161776NMA85,141.92Morgan Stanley Bank 4.25 2/26/2027 0.000.002/26/20265,141.9222282XAN02,521.43COVANTAGE 4.05 8/27/2026 0.000.002/27/20262,521.4330191MAL1845.92FFB Bank 4 11/27/2026 0.000.002/27/2026845.92271,023.06249,000.00February 202622,023.0690355GWT9783.16UBS Bank USA 4.1 6/4/2027 0.000.003/4/2026783.16320437AH9249,021.39First Guaranty Bank 4.15 3/6/2026 244,000.00244,000.003/6/20265,021.3959013K7B6736.32Merrick Bank 4.05 5/8/2026 0.000.003/9/2026736.3229367RNH5754.50Enterprise Bank 4.15 12/10/2026 0.000.003/10/2026754.5032022RYV3727.231st Financial Bank USA 4 7/10/2026 0.000.003/10/2026727.2360700PLY5258,540.00Mizuho Bank USA Instl 4.25 3/12/2026 248,000.00248,000.003/12/202610,540.003130ATMJ31,019,583.33FHLB 4.7 3/13/2026 1,000,000.001,000,000.003/13/202619,583.3301882MAK8754.50ALLIANT CR UN 3.95 10/15/2026 0.000.003/15/2026754.5048836LCM2792.71Kemba Financial 4.15 7/24/2026 0.000.003/24/2026792.7130191MAL1764.05FFB Bank 4 11/27/2026 0.000.003/27/2026764.05CUSIPTotalDescriptionPrincipal AmountFace Amount/SharesDateInterest/DividendsBegin Date: 10-2025, End Date: 03-2026All PortfoliosProjected Cash Flow by MonthCity of Colleyville | TX10 1,532,457.191,492,000.00March 202640,457.192,924,056.832,721,000.00TOTAL203,056.83CUSIPTotalDescriptionPrincipal AmountFace Amount/SharesDateInterest/DividendsBegin Date: 10-2025, End Date: 03-2026All PortfoliosProjected Cash Flow by MonthCity of Colleyville | TX11 CD | Negotiable (Brokered) | 100%32022RYV31st Financial Bank USA 4 7/10/2026237,000.001/10/20254.00237,000.00237,000.00 100.143.82519.45237,319.95319.950.32%FDIC InsuredFDIC Insured0.7728302589AGP1American Express 4.2 2/26/2027237,000.002/26/20254.20237,000.00237,000.00 100.603.76954.49238,412.521,412.520.32%FDIC InsuredFDIC Insured1.3751406051XZA3Bank of America 4.1 7/23/2026240,000.007/23/20254.10240,000.00240,000.00 100.203.811,860.16240,484.80484.800.32%FDIC InsuredFDIC Insured0.8129605584CNT9Bank of NY Mellon PA 5.1 11/24/2025243,000.005/24/20245.10243,000.00243,000.00 100.084.474,379.99243,196.83196.830.33%FDIC InsuredFDIC Insured0.155505612LCL4BMW Bank of North America 4.05 11/16/2026245,000.0011/15/20244.05245,000.00245,000.00 100.313.763,751.52245,757.05757.050.33%FDIC InsuredFDIC Insured1.1412219236BZ8Cornerstone Bank 4.05 7/24/2026240,000.007/25/20254.05240,000.00240,000.00 100.163.811,784.22240,393.60393.600.32%FDIC InsuredFDIC Insured0.8129722282XAN0COVANTAGE 4.05 8/27/2026247,000.008/27/20254.05247,000.00247,000.00 100.213.81931.83247,521.17521.170.33%FDIC InsuredFDIC Insured0.8933129367SLK8Enterprise Bank & Trust 4.2 12/10/2025249,000.009/10/20244.20249,000.00249,000.00 100.014.13573.04249,032.3732.370.34%FDIC InsuredFDIC Insured0.197129367RNH5Enterprise Bank 4.15 12/10/2026237,000.0012/10/20244.15237,000.00237,000.00 100.463.76538.93238,092.571,092.570.32%FDIC InsuredFDIC Insured1.1643626879TAK5EPB Employeees Cr Un 4.05 9/21/2026247,000.005/21/20254.05247,000.00247,000.00 100.243.801,096.27247,587.86587.860.33%FDIC InsuredFDIC Insured0.9635630191MAL1FFB Bank 4 11/27/2026249,000.0011/27/20244.00249,000.00249,000.00 100.093.9381.86249,211.65211.650.34%FDIC InsuredFDIC Insured1.1342331944MEE1First Carolina Bank 4.15 11/26/2025249,000.0011/26/20244.15249,000.00249,000.00 99.984.30113.24248,942.73-57.270.34%FDIC InsuredFDIC Insured0.1657CUSIPFace Amount / SharesSettlement DateDescriptionYTM @ CostCost ValueBook ValueYTM @ MarketMarket PriceMarket ValueAccrued InterestUnre. Gain/Loss% PortfolioCredit RatingCredit RatingDuration To MaturityDays To Call/MaturityDate: 9/30/2025Investment Policy CompliancePortfolio Holdings by Asset CategoryCity of Colleyville | TX12 320437AH9First Guaranty Bank 4.15 3/6/2026244,000.009/6/20244.15244,000.00244,000.00 100.083.96665.82244,190.32190.320.33%FDIC InsuredFDIC Insured0.4315738150VF61Goldman Sachs Bank USA 4 6/24/2026240,000.0012/24/20244.00240,000.00240,000.00 100.083.882,577.53240,199.20199.200.32%FDIC InsuredFDIC Insured0.7226748836LCM2Kemba Financial 4.15 7/24/2026249,000.007/24/20254.15249,000.00249,000.00 100.243.85169.87249,605.07605.070.34%FDIC InsuredFDIC Insured0.829759013K7B6Merrick Bank 4.05 5/8/2026237,000.005/9/20254.00237,071.62237,118.50 100.083.92552.24237,184.86113.240.32%FDIC InsuredFDIC Insured0.622060700PLY5Mizuho Bank USA Instl 4.25 3/12/2026248,000.003/12/20254.25248,000.00248,000.00 100.113.925,833.10248,260.40260.400.34%FDIC InsuredFDIC Insured0.4516361690DB49Morgan Stanley Bank 4.15 11/27/2026244,000.0011/27/20244.15244,000.00244,000.00 100.393.803,495.55244,951.60951.600.33%FDIC InsuredFDIC Insured1.1342361776NMA8Morgan Stanley Bank 4.25 2/26/2027240,000.002/26/20254.25240,000.00240,000.00 100.663.76978.08241,593.601,593.600.32%FDIC InsuredFDIC Insured1.3751468405VCV9Optum Bank, Inc 4.15 12/11/2026240,000.0012/11/20244.15240,000.00240,000.00 100.423.783,028.93241,010.401,010.400.32%FDIC InsuredFDIC Insured1.1743777357DAL2Rockland Fed Credit Union 4.3 1/30/2026239,000.001/30/20254.30239,000.00239,000.00 100.014.156,841.95239,021.5121.510.32%FDIC InsuredFDIC Insured0.3312283616HAG9SOUND 4.3 2/2/2026249,000.001/31/20254.30249,000.00249,000.00 100.064.13850.69249,144.42144.420.34%FDIC InsuredFDIC Insured0.3412590355GWT9UBS Bank USA 4.1 6/4/2027249,000.006/4/20254.10249,000.00249,000.00 100.663.69727.22250,650.871,650.870.34%FDIC InsuredFDIC Insured1.626122980.87.56%12,693.735,611,765.3542,305.983.915,599,118.505,599,071.624.175,599,000.00Sub Total CD | Negotiable (Brokered) | 100%Operating Cash | TBD%CUSIPFace Amount / SharesSettlement DateDescriptionYTM @ CostCost ValueBook ValueYTM @ MarketMarket PriceMarket ValueAccrued InterestUnre. Gain/Loss% PortfolioCredit RatingCredit RatingDuration To MaturityDays To Call/MaturityDate: 9/30/2025Investment Policy CompliancePortfolio Holdings by Asset CategoryCity of Colleyville | TX13 FROSTCASH1429Frost Cash | CEDC Cash2,149,298.566/30/20244.302,149,298.562,149,298.56 100.004.302,149,298.560.002.91%NRNR01FROSTCASH1402Frost Cash | Operating Cash576,520.576/30/20244.30576,520.57576,520.57 100.004.30576,520.570.000.78%NRNR01FROSTCASH1402Frost Cash | Operating Cash1,005,088.046/30/20244.301,005,088.041,005,088.04 100.004.301,005,088.040.001.36%NRNR01FROSTCASH1402Frost Cash | Operating Cash111,615.406/30/20244.30111,615.40111,615.40 100.004.30111,615.400.000.15%NRNR01FROSTCASH1402Frost Cash | Operating Cash875,627.606/30/20244.30875,627.60875,627.60 100.004.30875,627.600.001.19%NRNR01FROSTCASH1402Frost Cash | Operating Cash76,786.996/30/20244.3076,786.9976,786.99 100.004.3076,786.990.000.1%NRNR01FROSTCASH1402Frost Cash | Operating Cash-8,648.096/30/20244.30-8,648.09-8,648.09 100.004.30-8,648.090.00-0.01%NRNR01FROSTCASH1402Frost Cash | Operating Cash2,064,866.056/30/20244.302,064,866.052,064,866.05 100.004.302,064,866.050.002.8%NRNR01FROSTCASH1402Frost Cash | Operating Cash680,046.866/30/20244.30680,046.86680,046.86 100.004.30680,046.860.000.92%NRNR01FROSTCASH1402Frost Cash | Operating Cash54,290.486/30/20244.3054,290.4854,290.48 100.004.3054,290.480.000.07%NRNR01FROSTCASH1402Frost Cash | Operating Cash349,101.376/30/20244.30349,101.37349,101.37 100.004.30349,101.370.000.47%NRNR01FROSTCASH1402Frost Cash | Operating Cash15,757.516/30/20244.3015,757.5115,757.51 100.004.3015,757.510.000.02%NRNR01CUSIPFace Amount / SharesSettlement DateDescriptionYTM @ CostCost ValueBook ValueYTM @ MarketMarket PriceMarket ValueAccrued InterestUnre. Gain/Loss% PortfolioCredit RatingCredit RatingDuration To MaturityDays To Call/MaturityDate: 9/30/2025Investment Policy CompliancePortfolio Holdings by Asset CategoryCity of Colleyville | TX14 FROSTCASH1402Frost Cash | Operating Cash18,714.396/30/20244.3018,714.3918,714.39 100.004.3018,714.390.000.03%NRNR01FROSTCASH1402Frost Cash | Operating Cash35,435.256/30/20244.3035,435.2535,435.25 100.004.3035,435.250.000.05%NRNR01FROSTCASH1402Frost Cash | Operating Cash154,282.376/30/20244.30154,282.37154,282.37 100.004.30154,282.370.000.21%NRNR01FROSTCASH1402Frost Cash | Operating Cash43,780.586/30/20244.3043,780.5843,780.58 100.004.3043,780.580.000.06%NRNR01FROSTCASH1402Frost Cash | Operating Cash74,380.596/30/20244.3074,380.5974,380.59 100.004.3074,380.590.000.1%NRNR01FROSTCASH1402Frost Cash | Operating Cash148,140.766/30/20244.30148,140.76148,140.76 100.004.30148,140.760.000.2%NRNR01FROSTCASH1402Frost Cash | Operating Cash8,788.846/30/20244.308,788.848,788.84 100.004.308,788.840.000.01%NRNR01FROSTCASH1402Frost Cash | Operating Cash1,073,371.226/30/20244.301,073,371.221,073,371.22 100.004.301,073,371.220.001.45%NRNR01FROSTCASH1402Frost Cash | Operating Cash80,190.886/30/20244.3080,190.8880,190.88 100.004.3080,190.880.000.11%NRNR01FROSTCASH1402Frost Cash | Operating Cash1,803.916/30/20244.301,803.911,803.91 100.004.301,803.910.000%NRNR01FROSTCASH1402Frost Cash | Operating Cash132,215.636/30/20244.30132,215.63132,215.63 100.004.30132,215.630.000.18%NRNR01FROSTCASH1402Frost Cash | Operating Cash6,788.026/30/20244.306,788.026,788.02 100.004.306,788.020.000.01%NRNR01CUSIPFace Amount / SharesSettlement DateDescriptionYTM @ CostCost ValueBook ValueYTM @ MarketMarket PriceMarket ValueAccrued InterestUnre. Gain/Loss% PortfolioCredit RatingCredit RatingDuration To MaturityDays To Call/MaturityDate: 9/30/2025Investment Policy CompliancePortfolio Holdings by Asset CategoryCity of Colleyville | TX15 FROSTCASH1402Frost Cash | Operating Cash936,652.766/30/20244.30936,652.76936,652.76 100.004.30936,652.760.001.27%NRNR01FROSTCASH1402Frost Cash | Operating Cash513,428.066/30/20244.30513,428.06513,428.06 100.004.30513,428.060.000.7%NRNR01FROSTCASH1402Frost Cash | Operating Cash1,907,708.386/30/20244.301,907,708.381,907,708.38 100.004.301,907,708.380.002.58%NRNR01FROSTCASH1402Frost Cash | Operating Cash1,219,669.446/30/20244.301,219,669.441,219,669.44 100.004.301,219,669.440.001.65%NRNR01FROSTCASH1402Frost Cash | Operating Cash14,522.556/30/20254.3014,522.5514,522.55 100.004.3014,522.550.000.02%NRNR01MBS8852Multi-Bank Securities MM12,832.556/30/20240.1012,832.5512,832.55 100.000.1012,832.550.000.02%NRNR011019.41%0.0014,333,057.524.3014,333,057.5214,333,057.524.3014,333,057.52Sub Total Operating Cash | TBD%TX LGIP | 75%TEXASCLASS4001Texas CLASS LGIP2,156,444.316/30/20244.192,156,444.312,156,444.31 100.004.192,156,444.310.002.92%NRNR01TEXASCLASS4001Texas CLASS LGIP2,708,644.576/30/20244.192,708,644.572,708,644.57 100.004.192,708,644.570.003.67%NRNR01TEXASCLASS4001Texas CLASS LGIP4,451,670.016/30/20244.194,451,670.014,451,670.01 100.004.194,451,670.010.006.03%NRNR01TEXSTAR1110TexasStar LGIP3,034,481.226/30/20244.213,034,481.223,034,481.22 100.004.213,034,481.220.004.11%NRNR01TEXSTAR1110TexasStar LGIP1,185,199.316/30/20244.211,185,199.311,185,199.31 100.004.211,185,199.310.001.6%NRNR01CUSIPFace Amount / SharesSettlement DateDescriptionYTM @ CostCost ValueBook ValueYTM @ MarketMarket PriceMarket ValueAccrued InterestUnre. Gain/Loss% PortfolioCredit RatingCredit RatingDuration To MaturityDays To Call/MaturityDate: 9/30/2025Investment Policy CompliancePortfolio Holdings by Asset CategoryCity of Colleyville | TX16 TEXSTAR1110TexasStar LGIP10,657.166/30/20244.2110,657.1610,657.16 100.004.2110,657.160.000.01%NRNR01TEXSTAR1110TexasStar LGIP827,450.926/30/20244.21827,450.92827,450.92 100.004.21827,450.920.001.12%NRNR01TEXSTAR1110TexasStar LGIP573,934.836/30/20244.21573,934.83573,934.83 100.004.21573,934.830.000.78%NRNR01TEXSTAR1110TexasStar LGIP294,228.116/30/20244.21294,228.11294,228.11 100.004.21294,228.110.000.4%NRNR01TEXSTAR1110TexasStar LGIP1,143,933.896/30/20244.211,143,933.891,143,933.89 100.004.211,143,933.890.001.55%NRNR01TEXSTAR1110TexasStar LGIP278,678.666/30/20244.21278,678.66278,678.66 100.004.21278,678.660.000.38%NRNR01TEXSTAR1110TexasStar LGIP5,241,642.266/30/20244.215,241,642.265,241,642.26 100.004.215,241,642.260.007.1%NRNR01TEXSTAR1110TexasStar LGIP100,682.649/23/20254.21100,682.64100,682.64 100.004.21100,682.640.000.14%NRNR01TEXPOOL0001TexPool LGIP781,571.456/30/20244.25781,571.45781,571.45 100.004.25781,571.450.001.06%NRNR01TEXPOOL0001TexPool LGIP737,251.326/30/20244.25737,251.32737,251.32 100.004.25737,251.320.001%NRNR01TEXPOOL0001TexPool LGIP2,419,432.696/30/20244.252,419,432.692,419,432.69 100.004.252,419,432.690.003.28%NRNR01TEXPOOL0001TexPool LGIP588,002.636/30/20244.25588,002.63588,002.63 100.004.25588,002.630.000.8%NRNR01CUSIPFace Amount / SharesSettlement DateDescriptionYTM @ CostCost ValueBook ValueYTM @ MarketMarket PriceMarket ValueAccrued InterestUnre. Gain/Loss% PortfolioCredit RatingCredit RatingDuration To MaturityDays To Call/MaturityDate: 9/30/2025Investment Policy CompliancePortfolio Holdings by Asset CategoryCity of Colleyville | TX17 TEXPOOL0001TexPool LGIP11,273.116/30/20244.2511,273.1111,273.11 100.004.2511,273.110.000.02%NRNR01TEXPOOL0001TexPool LGIP3,918,643.136/30/20244.253,918,643.133,918,643.13 100.004.253,918,643.130.005.31%NRNR01TEXPOOL0001TexPool LGIP2,287,331.076/30/20244.252,287,331.072,287,331.07 100.004.252,287,331.070.003.1%NRNR01TEXPOOL0001TexPool LGIP2,407,499.186/30/20244.252,407,499.182,407,499.18 100.004.252,407,499.180.003.26%NRNR01TEXPOOL0001TexPool LGIP7,797,017.696/30/20244.257,797,017.697,797,017.69 100.004.257,797,017.690.0010.56%NRNR01TEXPOOL0001TexPool LGIP75,351.506/30/20244.2575,351.5075,351.50 100.004.2575,351.500.000.1%NRNR01TEXPOOL0001TexPool LGIP2,812,965.206/30/20244.252,812,965.202,812,965.20 100.004.252,812,965.200.003.81%NRNR01TEXPOOL0001TexPool LGIP1,017,628.906/30/20244.251,017,628.901,017,628.90 100.004.251,017,628.900.001.38%NRNR01TEXPOOL0001TexPool LGIP207,482.226/30/20244.25207,482.22207,482.22 100.004.25207,482.220.000.28%NRNR011063.77%0.0047,069,097.984.2347,069,097.9847,069,097.984.2347,069,097.98Sub Total TX LGIP | 75%TX LGIP Commerical Paper | 5%LOGIC8010LOGIC | CEDC LGIP536,721.096/30/20244.33536,721.09536,721.09 100.004.33536,721.090.000.73%NRNR01LOGIC4001LOGIC LGIP803,056.096/30/20244.33803,056.09803,056.09 100.004.33803,056.090.001.09%NRNR01CUSIPFace Amount / SharesSettlement DateDescriptionYTM @ CostCost ValueBook ValueYTM @ MarketMarket PriceMarket ValueAccrued InterestUnre. Gain/Loss% PortfolioCredit RatingCredit RatingDuration To MaturityDays To Call/MaturityDate: 9/30/2025Investment Policy CompliancePortfolio Holdings by Asset CategoryCity of Colleyville | TX18 LOGIC4001LOGIC LGIP39,366.136/30/20244.3339,366.1339,366.13 100.004.3339,366.130.000.05%NRNR01LOGIC4001LOGIC LGIP28,262.266/30/20244.3328,262.2628,262.26 100.004.3328,262.260.000.04%NRNR01LOGIC4001LOGIC LGIP221,217.726/30/20244.33221,217.72221,217.72 100.004.33221,217.720.000.3%NRNR01LOGIC4001LOGIC LGIP96,916.336/30/20244.3396,916.3396,916.33 100.004.3396,916.330.000.13%NRNR01LOGIC4001LOGIC LGIP177,207.766/30/20244.33177,207.76177,207.76 100.004.33177,207.760.000.24%NRNR01LOGIC4001LOGIC LGIP1,530.196/30/20244.331,530.191,530.19 100.004.331,530.190.000%NRNR01102.58%0.001,904,277.574.331,904,277.571,904,277.574.331,904,277.57Sub Total TX LGIP Commerical Paper | 5%US Agency | 75%3133ERVX6FFCB 4.06 10/7/2027-251,613,000.002/26/20254.261,606,769.121,604,935.00 99.824.1631,470.531,610,048.213,279.092.18%S&P-AA+Moodys-Aaa1.9273130AMSS2FHLB 1.05 6/30/2026-232,400,000.002/26/20254.082,347,383.472,305,680.00 98.083.666,300.002,354,016.006,632.533.18%S&P-AA+Moodys-Aaa0.75913130ATMJ3FHLB 4.7 3/13/20261,000,000.004/28/20253.861,003,711.571,007,172.67 100.353.9221,802.781,003,488.00-223.571.36%S&P-AA+Moodys-Aaa0.44164791.076.72%9,688.054,967,552.2159,573.313.874,917,787.674,957,864.164.105,013,000.00Sub Total US Agency | 75%% TBD, pending investment policy clarificationTOTAL PORTFOLIO 73,918,433.07 4.23 73,863,368.8573,823,339.244.20 101,879.2973,885,750.6322,381.78100.00%0.1329CUSIPFace Amount / SharesSettlement DateDescriptionYTM @ CostCost ValueBook ValueYTM @ MarketMarket PriceMarket ValueAccrued InterestUnre. Gain/Loss% PortfolioCredit RatingCredit RatingDuration To MaturityDays To Call/MaturityDate: 9/30/2025Investment Policy CompliancePortfolio Holdings by Asset CategoryCity of Colleyville | TX19 Quarterly Investment Report September 30, 2025 Audit Committee November 18, 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, $ 50.11 Cash, $ 14.33 CD, $ 5.61 FHLB, $ 3.36 FFCB, $ 1.61 Total Value: $14.3 Cash 60.7 Investments $75.0 Million 3 TexPool, $ 25.06 LOGIC*, $ 1.90 Texas Class, $ 9.32 TexStar, $ 12.69 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.7 months Weighted Average Yield: 4.23% FY24 4th Qtr (Sep)FY25 1st Qtr (Dec)FY25 2nd Qtr (Mar)FY25 3rd Qtr (Jun)FY25 4th Qtr (Sep) 3.50% 4.00% 4.50% 5.00% 5.50% 4.64% 4.34%4.31% 4.35% 3.95% 4.70% 4.55% 4.36%4.36% 4.30% 4.62% 4.42% 4.24%4.20%4.17% 5.15% 4.54% 4.32% 4.33%4.26% 4.74% 4.42% 4.30% 4.16%4.10% Yield Comparison 13-Week Treasury Bill Cash CD LGIP Agency Securities 6 Portfolio Performance FY24 4th Qtr (Sep)FY25 1st Qtr (Dec)FY25 2nd Qtr (Mar)FY25 3rd Qtr (Jun)FY25 4th Qtr (Sep) $ 600,000 $ 700,000 $ 800,000 $ 900,000 $ 1,000,000 $ 1,100,000 $ 1,200,000 $ 1,126,192 $ 805,664 $ 696,785 $ 816,945 $ 716,617 Investment Interest Earnings Comparison 7 Questions & Discussion colleyvillegovernment Colleyville.com colleyvilletexas