Loading...
HomeMy WebLinkAboutAudit Committee-Agenda Packets-3/4/2025 City of Colleyville Page 1 CITY OF COLLEYVILLE AUDIT COMMITTEE AGENDA 100 Main Street, Colleyville, Texas, 76034 CMO Conference Room - Third Floor TUESDAY, MARCH 4, 2025 - 5:00 PM 1. CALL TO ORDER 2. APPROVAL OF MINUTES 2a August 20, 2024 3. REGULAR AGENDA ITEMS 3a Discussion of the draft FY24 Audit and SAS 114 Letter 4. REPORTS Quarterly investment report as of September 30, 2024 Quarterly investment report as of December 31, 2024 5. ADJOURNMENT I hereby certify this agenda was posted on City Hall bulletin boards by Friday, February 28, 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 20, 2024 - 4:30 PM 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 Matt Poston, Accounting Manager Karen Hines, City Manager Jerry Ducay, Assistant City Manager Mark Wood, and City Secretary Christine Loven. 2. APPROVAL OF MINUTES June 18, 2024 The June 18, 2024 minutes were approved. 3. REGULAR AGENDA ITEMS 3a Discussion of the Fiscal Year September 30, 2024, audit which will be conducted by the City’s audit firm, Weaver Finance Director Matt Poston stated Weaver is the City’s auditing firm. Weaver was on site in July for two days to perform an interim audit and there were no concerns. The firm will be back in November to begin the full audit process. 3b Presentation of the third quarter FY24 investment report Finance Director Matt Poston noted there had been updates in the financial policy since the last meeting however, the investment strategies and objects remain to preserve capital, provide liquidity, and optimize earnings. Director Poston provided an overview of the report, reiterated the investment strategies and objectives, and explained the portfolio performance and investment distribution. There was general discussion regarding maturing funds, the federal rate, and CD renewal and rate structures. City of Colleyville Page 2 Audit Committee Minutes August 20, 2024 4. ADJOURNMENT The meeting adjourned at 4:45 p.m. APPROVED THIS THE 4TH DAY OF MARCH 2025. 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 3/4/2025 Number Type Regular Agenda Items Department Finance Title Discussion of the draft FY24 Audit and SAS 114 Letter Explanation This item provides for an update of the FY24 Audit. City of Colleyville Page 1 CITY OF COLLEYVILLE AUDIT COMMITTEE BRIEFING Agenda Number Agenda Date 3/4/2025 Number Type Report Department Finance Title Quarterly investment report as of September 30, 2024 Attachments 1. September 2024 Investment Report City of Colleyville I Texas MONTHLY INVESTMENT REPORT September 30 , 2024 Compliance I The City of Colleyville was in compl iance with its investment policy and th e Public Funds Investment Act. Specifically , the City only purchases securities from brokers who have rev iewed the investment policy and signed a statement agreeing to comply with it. The maturity dates of the City 's investmen t s w ill meet the ant icipated cash flow needs of the City . Asset Category Face Amount/Shares Market Value Book Value % of Portfolio YTM@Cost Days To Maturity CD I Bank 1100% 2 ,324 ,733.3 0 2 ,324 ,733 .30 2 ,324,733 .30 3 .02 4.67 145 CD I Negot iable (Brokered) I 100 % 5 ,829 ,000 .00 5,840 ,909 .38 5 ,829 ,000 .00 7 .58 4 .99 153 Operating Cash I TBD ¾ 16 ,380,321.23 16 ,380,321.23 16,380 ,321.23 21 .29 4.70 1 TX LGIP 175% 41 ,624 ,959 .02 41 ,624 ,959.02 41 ,624 ,959.02 54 .10 5.15 1 TX LGI P Commerical Paper I 5% 1,819 ,973 .83 1,819,973.83 1,819,973 .83 2 .37 5 .23 1 US Agency I 75 % 9 ,000 ,000 .00 8,958 ,955.44 8 ,959 ,138 .27 11 .64 4.20 184 Total / Average 76 ,978 ,987 .38 76 ,949 ,852 .20 76 ,938 ,125 .65 100.00 4 .92 3 8 --L.----........,__+----':;__---=------~ ---------------- Mark Wood , Assistan t City Manager Date Matthew Poston , F inance Director Date 2/19/25 Karen Hines , Accounting Manager Date Asset Category Allocation Asset Category Market Value 6/30/2024 % of Portfolio 6/30/2024 Market Value 9/30/2024 % of Portfolio 9/30/2024 CD | Bank | 100%2,295,505.65 3.00 2,324,733.30 3.02 CD | Negotiable (Brokered) | 100%5,824,799.62 7.61 5,840,909.38 7.59 Operating Cash | TBD%16,084,841.00 21.02 16,380,321.23 21.29 TX LGIP | 75%42,060,744.46 54.96 41,624,959.02 54.09 TX LGIP Commerical Paper | 5%1,795,701.21 2.35 1,819,973.83 2.37 US Agency | 75%8,461,495.00 11.06 8,958,955.44 11.64 Total / Average 76,523,086.94 100.00 76,949,852.20 100.00 Portfolio Holdings as of 6/30/2024 Portfolio Holdings as of 9/30/2024 % TBD, pending investment policy clarification Begin Date: 6/30/2024, End Date: 9/30/2024Investment 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 7/31/2024 76,742,176.87 264,447.40 0.00 264,447.40 76,450,096.22 0.35 4.23 4.90 8/31/2024 78,222,160.90 261,265.55 0.00 261,265.55 78,109,986.67 0.33 4.09 4.43 9/30/2024 75,267,873.15 254,756.69 -116.67 254,640.02 74,943,427.33 0.34 4.15 4.03 Annualized TRR-BV Total/Average 76,742,176.87 780,469.64 -116.67 780,352.97 76,321,470.13 1.02 4.15 4.45 Begin Date: 7/31/2024, End Date: 9/30/2024All 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 7/31/2024 78,078,851.90 78,104,334.20 -25,482.30 5.13 5.23 0.10 35 8/31/2024 75,090,988.96 75,105,261.98 -14,273.02 5.15 5.24 0.11 40 9/30/2024 76,949,852.20 76,938,125.65 11,726.55 4.92 4.95 0.11 38 Total / Average 76,706,564.35 76,715,907.28 -9,342.92 5.07 5.14 0.11 38 Market Value / Book Value Comparison Begin Date: 7/31/2024, End Date: 9/30/2024All Portfolios Portfolio Summary by Month City of Colleyville | TX 4 Maturity Range Allocation Maturity Range Market Value 6/30/2024 % of Portfolio 6/30/2024 Market Value 9/30/2024 % of Portfolio 9/30/2024 0-1 Month 61,188,779.47 79.96 60,571,271.18 78.72 1-3 Months 2,791,309.73 3.65 5,248,210.02 6.82 3-6 Months 4,382,913.29 5.73 3,710,883.60 4.82 6-9 Months 3,703,973.38 4.84 3,235,120.38 4.20 9-12 Months 3,217,842.38 4.21 3,443,668.68 4.48 1-2 Years 1,238,268.69 1.62 740,698.34 0.96 Total / Average 76,523,086.94 100.00 76,949,852.20 100.00 Portfolio Holdings as of 6/30/2024 Portfolio Holdings as of 9/30/2024 Begin Date: 6/30/2024, End Date: 9/30/2024All Portfolios Distribution by Maturity Range - Market Value City of Colleyville | TX 5 Security Type Allocation Security Type Market Value 6/30/2024 % of Portfolio 6/30/2024 Market Value 9/30/2024 % of Portfolio 9/30/2024 Cash 16,084,841.00 21.02 16,377,100.29 21.28 Compound CD 2,295,505.65 3.00 737,534.29 0.96 FHLB Bond 6,714,300.00 8.77 6,252,560.44 8.13 FHLMC Bond 1,747,195.00 2.28 2,706,395.00 3.52 Local Government Investment Pool 43,856,445.67 57.31 43,444,932.85 56.46 Negotiable Certificate Of Deposit 5,824,799.62 7.61 5,840,909.38 7.59 Certificate Of Deposit 0.00 0.00 1,587,199.01 2.06 Money Market 0.00 0.00 3,220.94 0.00 Total / Average 76,523,086.94 100.00 76,949,852.20 100.00 Portfolio Holdings as of 6/30/2024 Portfolio Holdings as of 9/30/2024 Begin Date: 6/30/2024, End Date: 9/30/2024All Portfolios Distribution by Security Type - Market Value City of Colleyville | TX 6 Main Fund Allocation Main Fund Market Value 6/30/2024 % of Portfolio 6/30/2024 Market Value 9/30/2024 % of Portfolio 9/30/2024 1 | General Fund 18,406,601.06 24.05 17,230,593.47 22.39 2 | Debt Service Funds 633,607.97 0.83 245,303.55 0.32 3 | Capital Project Funds 29,574,308.73 38.65 25,091,896.91 32.61 4 | Special Revenue Funds 14,781,475.70 19.32 14,174,464.01 18.42 5 | Enterprise Funds 13,250,128.27 17.32 20,170,821.40 26.21 6 | Fiduciary Funds -123,034.79 -0.16 36,772.86 0.05 Total / Average 76,523,086.94 100.00 76,949,852.20 100.00 Portfolio Holdings as of 6/30/2024 Portfolio Holdings as of 9/30/2024 Begin Date: 6/30/2024, End Date: 9/30/2024All Portfolios Distribution by Main Fund - Market Value City of Colleyville | TX 7 87868YAU7 1,019.18Technology CU CA 5 2/10/2025 0.000.0010/1/2024 1,019.18 08756MAA8 1,070.14Bethpage Federal CU NY 5.25 5/13/2025 0.000.0010/1/2024 1,070.14 21923LAP8 1,049.75Cornerstone Community CU 5.15 3/7/2025 0.000.0010/8/2024 1,049.75 29367SLK8 859.56Enterprise Bank & Trust 4.2 12/10/2025 0.000.0010/10/2024 859.56 61773TKZ5 249,900.49Morgan Stanley Bank UT 4.4 10/11/2024 249,000.00249,000.0010/11/2024 900.49 31762FAF6 890.26Financial Partners 4.35 9/12/2025 0.000.0010/13/2024 890.26 3130B0ZQ5 26,400.00FHLB 5.4 5/15/2025-24 0.000.0010/15/2024 26,400.00 89841MAS6 249,103.43Trustone Financial CU 5.6 10/18/2024 248,000.00248,000.0010/18/2024 1,103.43 39120VTC8 249,900.49Great Southern Bank MO 4.4 10/21/2024 249,000.00249,000.0010/21/2024 900.49 3130B15Z6 38,783.33FHLB 5.2 4/25/2025 0.000.0010/25/2024 38,783.33 98138MBW9 1,049.75Workers United CU MA 5.15 11/26/2024 0.000.0010/26/2024 1,049.75 820,026.38746,000.00October 2024 74,026.38 87868YAU7 1,053.15Technology CU CA 5 2/10/2025 0.000.0011/1/2024 1,053.15 08756MAA8 1,105.81Bethpage Federal CU NY 5.25 5/13/2025 0.000.0011/1/2024 1,105.81 3130APQ81 1,507,500.00FHLB 1 11/8/2024-21 1,500,000.001,500,000.0011/8/2024 7,500.00 21923LAP8 1,084.75Cornerstone Community CU 5.15 3/7/2025 0.000.0011/8/2024 1,084.75 29367SLK8 888.21Enterprise Bank & Trust 4.2 12/10/2025 0.000.0011/10/2024 888.21 95763PRW3 246,933.15Western Allican Bank AZ 5 11/12/2024 238,000.00238,000.0011/12/2024 8,933.15 31762FAF6 919.94Financial Partners 4.35 9/12/2025 0.000.0011/13/2024 919.94 25432JDN0 249,073.97Dime Community Bank NY 5 11/18/2024 240,000.00240,000.0011/18/2024 9,073.97 69506YZM4 249,369.93Banc of California 5.2 11/19/2024 243,000.00243,000.0011/19/2024 6,369.93 CD0838-D 1,606,414.99Frost Bank 4.91 11/21/2024 1,587,199.011,587,199.0111/21/2024 19,215.98 05584CNT9 6,247.43Bank of NY Mellon PA 5.1 11/24/2025 0.000.0011/24/2024 6,247.43 98138MBW9 249,084.75Workers United CU MA 5.15 11/26/2024 248,000.00248,000.0011/26/2024 1,084.75 433411DE2 249,278.47Hinsdale Bank & Trust IL 5.15 11/29/2024 240,000.00240,000.0011/29/2024 9,278.47 CUSIP TotalDescriptionPrincipal AmountFace Amount/SharesDate Interest/Dividends Begin Date: 10-2024, End Date: 12-2024All Portfolios Projected Cash Flow by Month City of Colleyville | TX 8 509685FU2 249,278.47Lake Forest Bank & Trust IL 5.15 11/29/2024 240,000.00240,000.0011/29/2024 9,278.47 4,618,233.024,536,199.01November 2024 82,034.01 87868YAU7 1,019.18Technology CU CA 5 2/10/2025 0.000.0012/1/2024 1,019.18 08756MAA8 1,070.14Bethpage Federal CU NY 5.25 5/13/2025 0.000.0012/1/2024 1,070.14 45847PAD8 246,195.92Intercity State Bank WI 5.15 12/5/2024 237,000.00237,000.0012/5/2024 9,195.92 21923LAP8 1,049.75Cornerstone Community CU 5.15 3/7/2025 0.000.0012/8/2024 1,049.75 066519WX3 249,471.12Bank United FL 5.2 12/9/2024 240,000.00240,000.0012/9/2024 9,471.12 CD1584-D 7,612.57Simmons Bank 4.14 9/9/2025 0.000.0012/9/2024 7,612.57 29367SLK8 859.56Enterprise Bank & Trust 4.2 12/10/2025 0.000.0012/10/2024 859.56 31762FAF6 890.26Financial Partners 4.35 9/12/2025 0.000.0012/13/2024 890.26 22766APU3 249,402.74Crossfirst Bank KS 5.2 12/20/2024 240,000.00240,000.0012/20/2024 9,402.74 31944MEE1 849.33First Carolina Bank 4.15 11/26/2025 0.000.0012/26/2024 849.33 30191MAL1 818.63FFB Bank 4 11/27/2026 0.000.0012/27/2024 818.63 759,239.20717,000.00December 2024 42,239.20 6,197,498.605,999,199.01TOTAL 198,299.59 CUSIP TotalDescriptionPrincipal AmountFace Amount/SharesDate Interest/Dividends Begin Date: 10-2024, End Date: 12-2024All Portfolios Projected Cash Flow by Month City of Colleyville | TX 9 CD | Bank | 100% CD0838-D Frost Bank 4.91 11/21/2024 1,587,199.01 8/23/2024 4.91 1,587,199.01 1,587,199.01 100.00 4.91 8,113.41 1,587,199.01 0.00 2.06% NR NR 0.14 52 CD1584-D Simmons Bank 4.14 9/9/2025 737,534.29 9/9/2024 4.14 737,534.29 737,534.29 100.00 4.14 1,756.75 737,534.29 0.00 0.96% NR NR 0.93 344 145 0.39 3.02% 0.00 2,324,733.30 9,870.164.67 2,324,733.30 2,324,733.304.672,324,733.30Sub Total CD | Bank | 100% CD | Negotiable (Brokered) | 100% 69506YZM4 Banc of California 5.2 11/19/2024 243,000.00 5/19/2023 5.20 243,000.00 243,000.00 100.00 5.07 4,638.97 243,009.72 9.72 0.32% FDIC Insured FDIC Insured 0.14 50 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.41 4.37 4,815.32 237,969.33 969.33 0.31% FDIC Insured FDIC Insured 0.61 221 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 101.25 3.98 4,379.99 246,030.21 3,030.21 0.32% FDIC Insured FDIC Insured 1.11 420 066519WX3 Bank United FL 5.2 12/9/2024 240,000.00 3/7/2024 5.20 240,000.00 240,000.00 100.07 4.72 7,077.70 240,156.00 156.00 0.31% FDIC Insured FDIC Insured 0.19 70 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.48 4.46 1,034.47 249,200.32 1,200.32 0.32% NCUA Insured NCUA Insured 0.61 225 21923LAP8 Cornerstone Community CU 5.15 3/7/2025 248,000.00 3/8/2024 5.15 248,000.00 248,000.00 100.20 4.68 769.82 248,503.44 503.44 0.32% NCUA Insured NCUA Insured 0.43 158 22766APU3 Crossfirst Bank KS 5.2 12/20/2024 240,000.00 3/20/2024 5.20 240,000.00 240,000.00 100.08 4.73 6,633.21 240,180.00 180.00 0.31% FDIC Insured FDIC Insured 0.22 81 25432JDN0 Dime Community Bank NY 5 11/18/2024 240,000.00 2/16/2024 5.00 240,000.00 240,000.00 100.02 4.70 7,463.01 240,048.00 48.00 0.31% FDIC Insured FDIC Insured 0.13 49 29367SLK8 Enterprise Bank & Trust 4.2 12/10/2025 249,000.00 9/10/2024 4.20 249,000.00 249,000.00 100.33 3.92 573.04 249,809.25 809.25 0.32% FDIC Insured FDIC Insured 1.16 436 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: 9/30/2024Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 10 31762FAF6 Financial Partners 4.35 9/12/2025 249,000.00 9/13/2024 4.35 249,000.00 249,000.00 100.31 4.04 504.48 249,774.39 774.39 0.32% FDIC Insured FDIC Insured 0.93 347 320437AH9 First Guaranty Bank 4.15 3/6/2026 244,000.00 9/6/2024 4.15 244,000.00 244,000.00 100.35 3.89 665.82 244,858.88 858.88 0.32% FDIC Insured FDIC Insured 1.4 522 39120VTC8 Great Southern Bank MO 4.4 10/21/2024 249,000.00 10/21/2022 4.40 249,000.00 249,000.00 99.98 4.69 270.15 248,957.67 -42.33 0.32% FDIC Insured FDIC Insured 0.06 21 433411DE2 Hinsdale Bank & Trust IL 5.15 11/29/2024 240,000.00 2/29/2024 5.15 240,000.00 240,000.00 100.05 4.71 7,246.68 240,117.60 117.60 0.31% FDIC Insured FDIC Insured 0.16 60 45847PAD8 Intercity State Bank WI 5.15 12/5/2024 237,000.00 3/5/2024 5.15 237,000.00 237,000.00 100.05 4.72 6,988.90 237,125.61 125.61 0.31% FDIC Insured FDIC Insured 0.18 66 509685FU2 Lake Forest Bank & Trust IL 5.15 11/29/2024 240,000.00 2/29/2024 5.15 240,000.00 240,000.00 100.05 4.71 7,246.68 240,117.60 117.60 0.31% FDIC Insured FDIC Insured 0.16 60 61773TKZ5 Morgan Stanley Bank UT 4.4 10/11/2024 249,000.00 10/14/2022 4.40 249,000.00 249,000.00 99.99 4.68 570.31 248,977.59 -22.41 0.32% FDIC Insured FDIC Insured 0.03 11 80280JXP1 Santander Bank DE 5.25 2/18/2025 237,000.00 5/17/2024 5.25 237,000.00 237,000.00 100.22 4.59 4,636.11 237,516.66 516.66 0.31% FDIC Insured FDIC Insured 0.39 141 806344AN7 Schaumburg Bank & Trust CT 5.3 2/24/2025 240,000.00 5/24/2024 5.30 240,000.00 240,000.00 100.26 4.57 4,495.56 240,614.40 614.40 0.31% FDIC Insured FDIC Insured 0.4 147 87868YAU7 Technology CU CA 5 2/10/2025 248,000.00 2/9/2024 5.00 248,000.00 248,000.00 100.09 4.76 985.21 248,210.80 210.80 0.32% NCUA Insured NCUA Insured 0.36 133 89841MAS6 Trustone Financial CU 5.6 10/18/2024 248,000.00 10/19/2023 5.60 248,000.00 248,000.00 100.03 4.93 418.54 248,081.84 81.84 0.32% NCUA Insured NCUA Insured 0.05 18 919853LD1 Valley National Bank NJ 5.15 1/9/2025 237,000.00 4/9/2024 5.15 237,000.00 237,000.00 100.09 4.71 5,818.51 237,213.30 213.30 0.31% FDIC Insured FDIC Insured 0.28 101 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: 9/30/2024Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 11 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.52 4.34 4,499.75 238,225.29 1,225.29 0.31% FDIC Insured FDIC Insured 0.64 233 95763PRW3 Western Allican Bank AZ 5 11/12/2024 238,000.00 2/12/2024 5.00 238,000.00 238,000.00 100.02 4.70 7,531.23 238,042.84 42.84 0.31% FDIC Insured FDIC Insured 0.12 43 98138MBW9 Workers United CU MA 5.15 11/26/2024 248,000.00 5/26/2023 5.15 248,000.00 248,000.00 100.07 4.71 139.97 248,168.64 168.64 0.32% NCUA Insured NCUA Insured 0.16 57 153 0.41 7.56% 11,909.38 5,840,909.38 89,403.434.56 5,829,000.00 5,829,000.004.995,829,000.00Sub Total CD | Negotiable (Brokered) | 100% Operating Cash | TBD% FROSTCASH1429 Frost Cash | CEDC Cash 1,880,301.61 6/30/2024 4.70 1,880,301.61 1,880,301.61 100.00 4.70 1,880,301.61 0.00 2.44% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 13,413.46 6/30/2024 4.70 13,413.46 13,413.46 100.00 4.70 13,413.46 0.00 0.02% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 19,672.50 6/30/2024 4.70 19,672.50 19,672.50 100.00 4.70 19,672.50 0.00 0.03% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 1,145.36 6/30/2024 4.70 1,145.36 1,145.36 100.00 4.70 1,145.36 0.00 0% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 408.63 6/30/2024 4.70 408.63 408.63 100.00 4.70 408.63 0.00 0% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 5,820.31 6/30/2024 4.70 5,820.31 5,820.31 100.00 4.70 5,820.31 0.00 0.01% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 504,194.60 6/30/2024 4.70 504,194.60 504,194.60 100.00 4.70 504,194.60 0.00 0.66% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 10,173.25 6/30/2024 4.70 10,173.25 10,173.25 100.00 4.70 10,173.25 0.00 0.01% NR NR 0 1 CUSIP Face Amount / Shares Settlement DateDescription YTM @ Cost Cost Value Book Value YTM @ Market Market Price Market Value Accrued Interest Unre. Gain/Loss % Portfolio Credit Rating Credit Rating Duration To Maturity Days To Call/Maturity Date: 9/30/2024Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 12 FROSTCASH1402 Frost Cash | Operating Cash 73,582.02 6/30/2024 4.70 73,582.02 73,582.02 100.00 4.70 73,582.02 0.00 0.1% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 77,768.32 6/30/2024 4.70 77,768.32 77,768.32 100.00 4.70 77,768.32 0.00 0.1% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 68,289.79 6/30/2024 4.70 68,289.79 68,289.79 100.00 4.70 68,289.79 0.00 0.09% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 3,483,487.58 6/30/2024 4.70 3,483,487.58 3,483,487.58 100.00 4.70 3,483,487.58 0.00 4.53% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 131,505.43 6/30/2024 4.70 131,505.43 131,505.43 100.00 4.70 131,505.43 0.00 0.17% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 43,481.56 6/30/2024 4.70 43,481.56 43,481.56 100.00 4.70 43,481.56 0.00 0.06% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 2,032.68 6/30/2024 4.70 2,032.68 2,032.68 100.00 4.70 2,032.68 0.00 0% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 70,308.80 6/30/2024 4.70 70,308.80 70,308.80 100.00 4.70 70,308.80 0.00 0.09% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 612,764.28 6/30/2024 4.70 612,764.28 612,764.28 100.00 4.70 612,764.28 0.00 0.8% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 20,489.37 6/30/2024 4.70 20,489.37 20,489.37 100.00 4.70 20,489.37 0.00 0.03% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash -16,480.71 6/30/2024 4.70 -16,480.71 -16,480.71 100.00 4.70 -16,480.71 0.00 -0.02% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 62,829.05 6/30/2024 4.70 62,829.05 62,829.05 100.00 4.70 62,829.05 0.00 0.08% 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: 9/30/2024Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 13 FROSTCASH1402 Frost Cash | Operating Cash 42,879.80 6/30/2024 4.70 42,879.80 42,879.80 100.00 4.70 42,879.80 0.00 0.06% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 954,841.65 6/30/2024 4.70 954,841.65 954,841.65 100.00 4.70 954,841.65 0.00 1.24% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 213,039.71 6/30/2024 4.70 213,039.71 213,039.71 100.00 4.70 213,039.71 0.00 0.28% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 702,048.75 6/30/2024 4.70 702,048.75 702,048.75 100.00 4.70 702,048.75 0.00 0.91% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 520,128.61 6/30/2024 4.70 520,128.61 520,128.61 100.00 4.70 520,128.61 0.00 0.68% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 568,108.89 6/30/2024 4.70 568,108.89 568,108.89 100.00 4.70 568,108.89 0.00 0.74% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 19,707.99 6/30/2024 4.70 19,707.99 19,707.99 100.00 4.70 19,707.99 0.00 0.03% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 2,505,847.45 6/30/2024 4.70 2,505,847.45 2,505,847.45 100.00 4.70 2,505,847.45 0.00 3.26% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 146,550.26 6/30/2024 4.70 146,550.26 146,550.26 100.00 4.70 146,550.26 0.00 0.19% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 857,569.74 6/30/2024 4.70 857,569.74 857,569.74 100.00 4.70 857,569.74 0.00 1.11% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 2,535,886.00 6/30/2024 4.70 2,535,886.00 2,535,886.00 100.00 4.70 2,535,886.00 0.00 3.3% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 245,303.55 6/30/2024 4.70 245,303.55 245,303.55 100.00 4.70 245,303.55 0.00 0.32% 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: 9/30/2024Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 14 MBS8852 Multi-Bank Securities MM 3,220.94 6/30/2024 1.00 3,220.94 3,220.94 100.00 1.00 3,220.94 0.00 0% NR NR 0 1 1 0 21.32% 0.00 16,380,321.23 4.70 16,380,321.23 16,380,321.234.7016,380,321.23Sub Total Operating Cash | TBD% TX LGIP | 75% TEXASCLASS4001 Texas CLASS LGIP 3,273,527.02 6/30/2024 5.11 3,273,527.02 3,273,527.02 100.00 5.11 3,273,527.02 0.00 4.25% NR NR 0 1 TEXASCLASS4001 Texas CLASS LGIP 2,099,408.26 6/30/2024 5.11 2,099,408.26 2,099,408.26 100.00 5.11 2,099,408.26 0.00 2.73% NR NR 0 1 TEXASCLASS4001 Texas CLASS LGIP 1,570,270.97 6/30/2024 5.11 1,570,270.97 1,570,270.97 100.00 5.11 1,570,270.97 0.00 2.04% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 3,686.90 6/30/2024 5.13 3,686.90 3,686.90 100.00 5.13 3,686.90 0.00 0% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 281,620.12 6/30/2024 5.13 281,620.12 281,620.12 100.00 5.13 281,620.12 0.00 0.37% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 549,341.11 6/30/2024 5.13 549,341.11 549,341.11 100.00 5.13 549,341.11 0.00 0.71% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 1,092,460.75 6/30/2024 5.13 1,092,460.75 1,092,460.75 100.00 5.13 1,092,460.75 0.00 1.42% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 6,756.63 6/30/2024 5.13 6,756.63 6,756.63 100.00 5.13 6,756.63 0.00 0.01% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 1,134,412.25 6/30/2024 5.13 1,134,412.25 1,134,412.25 100.00 5.13 1,134,412.25 0.00 1.47% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 10,200.49 6/30/2024 5.13 10,200.49 10,200.49 100.00 5.13 10,200.49 0.00 0.01% NR NR 0 1 CUSIP Face Amount / Shares Settlement DateDescription YTM @ Cost Cost Value Book Value YTM @ Market Market Price Market Value Accrued Interest Unre. Gain/Loss % Portfolio Credit Rating Credit Rating Duration To Maturity Days To Call/Maturity Date: 9/30/2024Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 15 TEXSTAR1110 TexasStar LGIP 266,736.99 6/30/2024 5.13 266,736.99 266,736.99 100.00 5.13 266,736.99 0.00 0.35% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 1,094,915.09 6/30/2024 5.13 1,094,915.09 1,094,915.09 100.00 5.13 1,094,915.09 0.00 1.42% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 887,708.66 6/30/2024 5.13 887,708.66 887,708.66 100.00 5.13 887,708.66 0.00 1.15% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 2,904,450.46 6/30/2024 5.13 2,904,450.46 2,904,450.46 100.00 5.13 2,904,450.46 0.00 3.78% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 3,037,513.96 6/30/2024 5.13 3,037,513.96 3,037,513.96 100.00 5.13 3,037,513.96 0.00 3.95% NR NR 0 1 TEXPOOL0001 TexPool LGIP 2,314,658.97 6/30/2024 5.16 2,314,658.97 2,314,658.97 100.00 5.16 2,314,658.97 0.00 3.01% NR NR 0 1 TEXPOOL0001 TexPool LGIP 10,784.92 6/30/2024 5.16 10,784.92 10,784.92 100.00 5.16 10,784.92 0.00 0.01% NR NR 0 1 TEXPOOL0001 TexPool LGIP 198,497.19 6/30/2024 5.16 198,497.19 198,497.19 100.00 5.16 198,497.19 0.00 0.26% NR NR 0 1 TEXPOOL0001 TexPool LGIP 795,741.37 6/30/2024 5.16 795,741.37 795,741.37 100.00 5.16 795,741.37 0.00 1.03% NR NR 0 1 TEXPOOL0001 TexPool LGIP 3,941,009.65 6/30/2024 5.16 3,941,009.65 3,941,009.65 100.00 5.16 3,941,009.65 0.00 5.12% NR NR 0 1 TEXPOOL0001 TexPool LGIP 2,188,278.02 6/30/2024 5.16 2,188,278.02 2,188,278.02 100.00 5.16 2,188,278.02 0.00 2.84% NR NR 0 1 TEXPOOL0001 TexPool LGIP 72,088.41 6/30/2024 5.16 72,088.41 72,088.41 100.00 5.16 72,088.41 0.00 0.09% 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: 9/30/2024Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 16 TEXPOOL0001 TexPool LGIP 973,560.38 6/30/2024 5.16 973,560.38 973,560.38 100.00 5.16 973,560.38 0.00 1.27% NR NR 0 1 TEXPOOL0001 TexPool LGIP 1,996,872.38 6/30/2024 5.16 1,996,872.38 1,996,872.38 100.00 5.16 1,996,872.38 0.00 2.6% NR NR 0 1 TEXPOOL0001 TexPool LGIP 562,539.11 6/30/2024 5.16 562,539.11 562,539.11 100.00 5.16 562,539.11 0.00 0.73% NR NR 0 1 TEXPOOL0001 TexPool LGIP 705,324.59 6/30/2024 5.16 705,324.59 705,324.59 100.00 5.16 705,324.59 0.00 0.92% NR NR 0 1 TEXPOOL0001 TexPool LGIP 2,691,149.53 6/30/2024 5.16 2,691,149.53 2,691,149.53 100.00 5.16 2,691,149.53 0.00 3.5% NR NR 0 1 TEXPOOL0001 TexPool LGIP 6,961,444.84 6/30/2024 5.16 6,961,444.84 6,961,444.84 100.00 5.16 6,961,444.84 0.00 9.05% NR NR 0 1 1 0 54.09% 0.00 41,624,959.02 5.15 41,624,959.02 41,624,959.025.1541,624,959.02Sub Total TX LGIP | 75% TX LGIP Commerical Paper | 5% LOGIC8010 LOGIC | CEDC LGIP 512,960.05 6/30/2024 5.23 512,960.05 512,960.05 100.00 5.23 512,960.05 0.00 0.67% NR NR 0 1 LOGIC4001 LOGIC LGIP 37,623.34 6/30/2024 5.23 37,623.34 37,623.34 100.00 5.23 37,623.34 0.00 0.05% NR NR 0 1 LOGIC4001 LOGIC LGIP 169,362.65 6/30/2024 5.23 169,362.65 169,362.65 100.00 5.23 169,362.65 0.00 0.22% NR NR 0 1 LOGIC4001 LOGIC LGIP 1,462.43 6/30/2024 5.23 1,462.43 1,462.43 100.00 5.23 1,462.43 0.00 0% NR NR 0 1 LOGIC4001 LOGIC LGIP 211,424.26 6/30/2024 5.23 211,424.26 211,424.26 100.00 5.23 211,424.26 0.00 0.27% 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: 9/30/2024Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 17 LOGIC4001 LOGIC LGIP 92,625.78 6/30/2024 5.23 92,625.78 92,625.78 100.00 5.23 92,625.78 0.00 0.12% NR NR 0 1 LOGIC4001 LOGIC LGIP 767,504.26 6/30/2024 5.23 767,504.26 767,504.26 100.00 5.23 767,504.26 0.00 1% NR NR 0 1 LOGIC4001 LOGIC LGIP 27,011.06 6/30/2024 5.23 27,011.06 27,011.06 100.00 5.23 27,011.06 0.00 0.04% NR NR 0 1 1 0 2.37% 0.00 1,819,973.83 5.23 1,819,973.83 1,819,973.835.231,819,973.83Sub Total TX LGIP Commerical Paper | 5% US Agency | 75% 3130APQ81 FHLB 1 11/8/2024-21 1,500,000.00 4/3/2024 1.00 1,500,000.00 1,500,000.00 99.60 4.76 5,916.67 1,494,045.00 -5,955.00 1.95% S&P-AA+ Moodys-Aaa 0.11 39 3130AYPP5 FHLB 5 7/29/2025-24 1,000,000.00 1/29/2024 5.00 1,000,000.00 1,000,000.00 99.94 5.06 8,472.22 999,440.00 -560.00 1.3% S&P-AA+ Moodys-Aaa 0.82 29 3130AYML7 FHLB 5.015 2/19/2025-24 1,250,000.00 2/15/2024 5.02 1,250,000.00 1,250,000.00 99.95 5.14 11,840.97 1,249,350.00 -650.00 1.62% S&P-AA+ Moodys-Aaa 0.38 22 3130B15Z6 FHLB 5.2 4/25/2025 1,500,000.00 8/29/2024 4.48 1,505,915.41 1,506,809.94 100.63 4.06 33,366.67 1,509,495.44 3,580.03 1.96% S&P-AA+ Moodys-Aaa 0.56 207 3130B0ZQ5 FHLB 5.4 5/15/2025-24 1,000,000.00 4/19/2024 5.40 1,000,000.00 1,000,000.00 100.02 5.37 24,150.00 1,000,230.00 230.00 1.3% S&P-AA+ Moodys-Aaa 1 15 3137EAEU9 FHLMC 0.375 7/21/2025 1,500,000.00 8/29/2024 4.35 1,453,222.86 1,448,239.73 97.13 4.02 1,078.12 1,456,920.00 3,697.14 1.89% S&P-AA+ Moodys-Aaa 0.81 294 3134GYFG2 FHLMC 5.125 1/27/2025-23 1,250,000.00 2/28/2024 5.13 1,250,000.00 1,250,000.00 99.96 5.21 11,210.94 1,249,475.00 -525.00 1.62% S&P-AA+ Moodys-Aaa 0.33 27 101 0.55 11.64% -182.83 8,958,955.44 96,035.594.74 8,955,049.67 8,959,138.274.209,000,000.00Sub Total 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: 9/30/2024Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 18 % TBD, pending investment policy clarification TOTAL PORTFOLIO 76,978,987.38 4.92 76,938,125.65 76,934,037.05 4.95 195,309.18 76,949,852.20 11,726.55 100.00% 0.11 29 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: 9/30/2024Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 19 City of Colleyville Page 1 CITY OF COLLEYVILLE AUDIT COMMITTEE BRIEFING Agenda Number Agenda Date 3/4/2025 Number - Type Report Department Finance Title Quarterly investment report as of December 31, 2024 Attachments 1. December 2024 Investment Report City of Colleyville I Texas MONTHLY INVESTMENT REPORT December 31, 2024 Compliance I 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. Asset Category Face Amount/Shares Market Value Book Value % of Portfolio YTM@Cost Days To Maturity CD I Bank\ 100% 2,351,561.85 2,351,561.85 2,351,561.85 3.12 4.20 CD I Negotiable (Brokered) 1100% 4,621,000.00 4,626,372.11 4,621,000.00 6.13 4.63 Operating Cash I TBD% 18,436,047.39 18,436,047.39 18,436,047.39 24.47 4.55 TX LGIP \ 75% 45,128,075.28 45,128,075.28 45,128,075.28 59.89 4.54 TX LGIP Commerical Paper I 5% 1,842,255.65 1,842,255.65 1,842,255.65 2.44 4.69 US Agency I 75% 3,000,000.00 2,971,375.79 2,971,140.31 3.94 4.42 Total/ Average 75,378,940.17 75,355,688.07 75,350,080.48 100.00 4 .54 Mark Wood, Assistant City Manager Date Cassie Smith, Finance Director Date 2/19/25 Karen Hines, Accounting Manager Date 114 334 1 1 1 158 31 1 Asset Category Allocation Asset Category Market Value 9/30/2024 % of Portfolio 9/30/2024 Market Value 12/31/2024 % of Portfolio 12/31/2024 CD | Bank | 100%2,324,733.30 3.02 2,351,561.85 3.12 CD | Negotiable (Brokered) | 100%5,840,909.38 7.59 4,626,372.11 6.14 Operating Cash | TBD%16,380,321.23 21.29 18,436,047.39 24.47 TX LGIP | 75%41,624,959.02 54.09 45,128,075.28 59.89 TX LGIP Commerical Paper | 5%1,819,973.83 2.37 1,842,255.65 2.44 US Agency | 75%8,958,955.44 11.64 2,971,375.79 3.94 Total / Average 76,949,852.20 100.00 75,355,688.07 100.00 Portfolio Holdings as of 9/30/2024 Portfolio Holdings as of 12/31/2024 % TBD, pending investment policy clarification Begin Date: 9/30/2024, End Date: 12/31/2024Investment 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 7/31/2024 76,742,176.87 264,447.40 0.00 264,447.40 76,450,096.22 0.35 4.23 4.90 8/31/2024 78,222,160.90 261,265.55 0.00 261,265.55 78,109,986.67 0.33 4.09 4.43 9/30/2024 75,267,873.15 254,756.69 -116.67 254,640.02 74,943,427.33 0.34 4.15 4.03 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 Annualized TRR-BV Total/Average 76,742,176.87 1,443,315.51 -116.67 1,443,198.84 74,131,848.23 1.95 3.93 4.36 Begin Date: 7/31/2024, End Date: 12/31/2024All 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 7/31/2024 78,078,851.90 78,104,334.20 -25,482.30 5.13 5.23 0.10 35 8/31/2024 75,090,988.96 75,105,261.98 -14,273.02 5.15 5.24 0.11 40 9/30/2024 76,949,852.20 76,938,125.65 11,726.55 4.92 4.95 0.11 38 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 Total / Average 74,707,734.22 74,710,164.95 -2,430.73 4.87 4.90 0.09 33 Market Value / Book Value Comparison Begin Date: 7/31/2024, End Date: 12/31/2024All Portfolios Portfolio Summary by Month City of Colleyville | TX 4 Maturity Range Allocation Maturity Range Market Value 9/30/2024 % of Portfolio 9/30/2024 Market Value 12/31/2024 % of Portfolio 12/31/2024 0-1 Month 60,571,271.18 78.72 65,643,418.61 87.11 1-3 Months 5,248,210.02 6.82 2,580,429.16 3.42 3-6 Months 3,710,883.60 4.82 2,227,990.17 2.96 6-9 Months 3,235,120.38 4.20 2,462,033.27 3.27 9-12 Months 3,443,668.68 4.48 743,213.19 0.99 1-2 Years 740,698.34 0.96 1,698,603.67 2.25 Total / Average 76,949,852.20 100.00 75,355,688.07 100.00 Portfolio Holdings as of 9/30/2024 Portfolio Holdings as of 12/31/2024 Begin Date: 9/30/2024, End Date: 12/31/2024All Portfolios Distribution by Maturity Range - Market Value City of Colleyville | TX 5 Security Type Allocation Security Type Market Value 9/30/2024 % of Portfolio 9/30/2024 Market Value 12/31/2024 % of Portfolio 12/31/2024 Cash 16,377,100.29 21.28 18,401,406.90 24.42 Certificate Of Deposit 1,587,199.01 2.06 1,606,414.99 2.13 Compound CD 737,534.29 0.96 745,146.86 0.99 FHLB Bond 6,252,560.44 8.13 1,503,760.79 2.00 FHLMC Bond 2,706,395.00 3.52 1,467,615.00 1.95 Local Government Investment Pool 43,444,932.85 56.46 46,970,330.93 62.33 Money Market 3,220.94 0.00 34,640.49 0.05 Negotiable Certificate Of Deposit 5,840,909.38 7.59 4,626,372.11 6.14 Total / Average 76,949,852.20 100.00 75,355,688.07 100.00 Portfolio Holdings as of 9/30/2024 Portfolio Holdings as of 12/31/2024 Begin Date: 9/30/2024, End Date: 12/31/2024All Portfolios Distribution by Security Type - Market Value City of Colleyville | TX 6 Main Fund Allocation Main Fund Market Value 9/30/2024 % of Portfolio 9/30/2024 Market Value 12/31/2024 % of Portfolio 12/31/2024 1 | General Fund 17,230,593.47 22.39 12,662,181.94 16.80 2 | Debt Service Funds 245,303.55 0.32 605,998.10 0.80 3 | Capital Project Funds 25,091,896.91 32.61 30,858,925.70 40.95 4 | Special Revenue Funds 14,174,464.01 18.42 11,412,612.52 15.14 5 | Enterprise Funds 20,170,821.40 26.21 19,779,620.08 26.25 6 | Fiduciary Funds 36,772.86 0.05 36,349.73 0.05 Total / Average 76,949,852.20 100.00 75,355,688.07 100.00 Portfolio Holdings as of 9/30/2024 Portfolio Holdings as of 12/31/2024 Begin Date: 9/30/2024, End Date: 12/31/2024All Portfolios Distribution by Main Fund - Market Value City of Colleyville | TX 7 87868YAU7 1,053.15Technology CU CA 5 2/10/2025 0.000.001/1/2025 1,053.15 08756MAA8 1,105.81Bethpage Federal CU NY 5.25 5/13/2025 0.000.001/1/2025 1,105.81 21923LAP8 1,084.75Cornerstone Community CU 5.15 3/7/2025 0.000.001/8/2025 1,084.75 919853LD1 246,195.92Valley National Bank NJ 5.15 1/9/2025 237,000.00237,000.001/9/2025 9,195.92 29367RNH5 835.34Enterprise Bank 4.15 12/10/2026 0.000.001/10/2025 835.34 29367SLK8 888.21Enterprise Bank & Trust 4.2 12/10/2025 0.000.001/10/2025 888.21 31762FAF6 919.94Financial Partners 4.35 9/12/2025 0.000.001/13/2025 919.94 3137EAEU9 2,812.50FHLMC 0.375 7/21/2025 0.000.001/21/2025 2,812.50 31944MEE1 877.64First Carolina Bank 4.15 11/26/2025 0.000.001/26/2025 877.64 30191MAL1 845.92FFB Bank 4 11/27/2026 0.000.001/27/2025 845.92 256,619.18237,000.00January 2025 19,619.18 87868YAU7 1,053.15Technology CU CA 5 2/10/2025 0.000.002/1/2025 1,053.15 08756MAA8 1,105.81Bethpage Federal CU NY 5.25 5/13/2025 0.000.002/1/2025 1,105.81 21923LAP8 1,084.75Cornerstone Community CU 5.15 3/7/2025 0.000.002/8/2025 1,084.75 87868YAU7 248,305.75Technology CU CA 5 2/10/2025 248,000.00248,000.002/10/2025 305.75 29367RNH5 835.34Enterprise Bank 4.15 12/10/2026 0.000.002/10/2025 835.34 29367SLK8 888.21Enterprise Bank & Trust 4.2 12/10/2025 0.000.002/10/2025 888.21 32022RYV3 805.151ST FINANCIAL BANK USA 4 7/10/2026 0.000.002/10/2025 805.15 31762FAF6 919.94Financial Partners 4.35 9/12/2025 0.000.002/13/2025 919.94 80280JXP1 246,442.66Santander Bank DE 5.25 2/18/2025 237,000.00237,000.002/18/2025 9,442.66 CD0838-E 1,623,170.12Frost Bank 4.23 2/19/2025 1,606,414.991,606,414.992/19/2025 16,755.13 806344AN7 249,618.41Schaumburg Bank & Trust CT 5.3 2/24/2025 240,000.00240,000.002/24/2025 9,618.41 31944MEE1 877.64First Carolina Bank 4.15 11/26/2025 0.000.002/26/2025 877.64 30191MAL1 845.92FFB Bank 4 11/27/2026 0.000.002/27/2025 845.92 2,375,952.852,331,414.99February 2025 44,537.86 CUSIP TotalDescriptionPrincipal AmountFace Amount/SharesDate Interest/Dividends Begin Date: 01-2025, End Date: 06-2025All Portfolios Projected Cash Flow by Month City of Colleyville | TX 8 83616HAG9 850.69SOUND 4.3 2/2/2026 0.000.003/1/2025 850.69 08756MAA8 998.79Bethpage Federal CU NY 5.25 5/13/2025 0.000.003/1/2025 998.79 320437AH9 5,021.39First Guaranty Bank 4.15 3/6/2026 0.000.003/6/2025 5,021.39 21923LAP8 248,944.78Cornerstone Community CU 5.15 3/7/2025 248,000.00248,000.003/7/2025 944.78 CD1584-D 7,606.62Simmons Bank 4.14 9/9/2025 0.000.003/9/2025 7,606.62 29367RNH5 754.50Enterprise Bank 4.15 12/10/2026 0.000.003/10/2025 754.50 29367SLK8 802.26Enterprise Bank & Trust 4.2 12/10/2025 0.000.003/10/2025 802.26 32022RYV3 727.231ST FINANCIAL BANK USA 4 7/10/2026 0.000.003/10/2025 727.23 31762FAF6 830.91Financial Partners 4.35 9/12/2025 0.000.003/13/2025 830.91 31944MEE1 792.71First Carolina Bank 4.15 11/26/2025 0.000.003/26/2025 792.71 30191MAL1 764.05FFB Bank 4 11/27/2026 0.000.003/27/2025 764.05 268,093.93248,000.00March 2025 20,093.93 83616HAG9 909.36SOUND 4.3 2/2/2026 0.000.004/1/2025 909.36 08756MAA8 1,105.81Bethpage Federal CU NY 5.25 5/13/2025 0.000.004/1/2025 1,105.81 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,546,187.371,500,000.00April 2025 46,187.37 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 CUSIP TotalDescriptionPrincipal AmountFace Amount/SharesDate Interest/Dividends Begin Date: 01-2025, End Date: 06-2025All Portfolios Projected Cash Flow by Month City of Colleyville | TX 9 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 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 30191MAL1 818.63FFB Bank 4 11/27/2026 0.000.005/27/2025 818.63 770,119.01722,000.00May 2025 48,119.01 83616HAG9 909.36SOUND 4.3 2/2/2026 0.000.006/1/2025 909.36 CD1584-D 7,775.66Simmons Bank 4.14 9/9/2025 0.000.006/9/2025 7,775.66 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 23,610.430.00June 2025 23,610.43 5,240,582.775,038,414.99TOTAL 202,167.78 CUSIP TotalDescriptionPrincipal AmountFace Amount/SharesDate Interest/Dividends Begin Date: 01-2025, End Date: 06-2025All Portfolios Projected Cash Flow by Month City of Colleyville | TX 10 CD | Bank | 100% CD0838-E Frost Bank 4.23 2/19/2025 1,606,414.99 11/21/2024 4.23 1,606,414.99 1,606,414.99 100.00 4.23 7,446.72 1,606,414.99 0.00 2.13% NR NR 0.14 50 CD1584-D Simmons Bank 4.14 9/9/2025 745,146.86 9/9/2024 4.14 745,146.86 745,146.86 100.00 4.14 1,859.40 745,146.86 0.00 0.99% NR NR 0.68 252 114 0.31 3.12% 0.00 2,351,561.85 9,306.124.20 2,351,561.85 2,351,561.854.202,351,561.85Sub Total CD | Bank | 100% CD | Negotiable (Brokered) | 100% 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.27 4.24 7,891.78 237,637.53 637.53 0.31% FDIC Insured FDIC Insured 0.35 129 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.84 4.14 1,256.28 245,033.91 2,033.91 0.32% FDIC Insured FDIC Insured 0.89 328 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.32 4.38 1,070.14 248,783.68 783.68 0.33% NCUA Insured NCUA Insured 0.36 133 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.07 4.02 1,250.51 245,171.50 171.50 0.33% FDIC Insured FDIC Insured 1.82 685 21923LAP8 Cornerstone Community CU 5.15 3/7/2025 248,000.00 3/8/2024 5.15 248,000.00 248,000.00 100.12 4.49 804.81 248,300.08 300.08 0.33% NCUA Insured NCUA Insured 0.18 66 29367SLK8 Enterprise Bank & Trust 4.2 12/10/2025 249,000.00 9/10/2024 4.20 249,000.00 249,000.00 100.06 4.13 601.69 249,154.38 154.38 0.33% FDIC Insured FDIC Insured 0.92 344 29367RNH5 Enterprise Bank 4.15 12/10/2026 237,000.00 12/10/2024 4.15 237,000.00 237,000.00 100.23 4.03 565.88 237,552.21 552.21 0.31% FDIC Insured FDIC Insured 1.87 709 30191MAL1 FFB Bank 4 11/27/2026 249,000.00 11/27/2024 4.00 249,000.00 249,000.00 99.20 4.44 109.15 247,008.00 -1,992.00 0.33% FDIC Insured FDIC Insured 1.84 696 31762FAF6 Financial Partners 4.35 9/12/2025 249,000.00 9/13/2024 4.35 249,000.00 249,000.00 100.11 4.19 534.16 249,271.41 271.41 0.33% FDIC Insured FDIC Insured 0.69 255 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: 12/31/2024Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 11 31944MEE1 First Carolina Bank 4.15 11/26/2025 249,000.00 11/26/2024 4.15 249,000.00 249,000.00 100.01 4.14 141.55 249,024.90 24.90 0.33% FDIC Insured FDIC Insured 0.89 330 320437AH9 First Guaranty Bank 4.15 3/6/2026 244,000.00 9/6/2024 4.15 244,000.00 244,000.00 100.04 4.11 3,218.13 244,102.48 102.48 0.32% FDIC Insured FDIC Insured 1.15 430 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.08 184.11 239,714.40 -285.60 0.32% FDIC Insured FDIC Insured 1.45 540 61690DB49 Morgan Stanley Bank 4.15 11/27/2026 244,000.00 11/27/2024 4.15 244,000.00 244,000.00 100.22 4.03 943.24 244,529.48 529.48 0.32% FDIC Insured FDIC Insured 1.85 696 68405VCV9 Optum Bank, Inc 4.15 12/11/2026 240,000.00 12/11/2024 4.15 240,000.00 240,000.00 100.22 4.03 545.75 240,525.60 525.60 0.32% FDIC Insured FDIC Insured 1.88 710 80280JXP1 Santander Bank DE 5.25 2/18/2025 237,000.00 5/17/2024 5.25 237,000.00 237,000.00 100.11 4.29 7,772.30 237,258.33 258.33 0.31% FDIC Insured FDIC Insured 0.13 49 806344AN7 Schaumburg Bank & Trust CT 5.3 2/24/2025 240,000.00 5/24/2024 5.30 240,000.00 240,000.00 100.13 4.29 7,701.70 240,314.40 314.40 0.32% FDIC Insured FDIC Insured 0.15 55 87868YAU7 Technology CU CA 5 2/10/2025 248,000.00 2/9/2024 5.00 248,000.00 248,000.00 100.06 4.49 1,019.18 248,141.36 141.36 0.33% NCUA Insured NCUA Insured 0.11 41 919853LD1 Valley National Bank NJ 5.15 1/9/2025 237,000.00 4/9/2024 5.15 237,000.00 237,000.00 100.02 4.30 8,894.97 237,040.29 40.29 0.31% FDIC Insured FDIC Insured 0.02 9 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.34 4.22 7,635.95 237,808.17 808.17 0.31% FDIC Insured FDIC Insured 0.39 141 334 0.89 6.11% 5,372.11 4,626,372.11 52,141.284.21 4,621,000.00 4,621,000.004.634,621,000.00Sub Total CD | Negotiable (Brokered) | 100% Operating Cash | TBD% FROSTCASH1429 Frost Cash | CEDC Cash 1,966,347.16 6/30/2024 4.56 1,966,347.16 1,966,347.16 100.00 4.56 1,966,347.16 0.00 2.61% 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: 12/31/2024Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 12 FROSTCASH1402 Frost Cash | Operating Cash 12,889.55 6/30/2024 4.56 12,889.55 12,889.55 100.00 4.56 12,889.55 0.00 0.02% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 19,729.28 6/30/2024 4.56 19,729.28 19,729.28 100.00 4.56 19,729.28 0.00 0.03% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 1,145.36 6/30/2024 4.56 1,145.36 1,145.36 100.00 4.56 1,145.36 0.00 0% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 3,103.83 6/30/2024 4.56 3,103.83 3,103.83 100.00 4.56 3,103.83 0.00 0% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 8,322.39 6/30/2024 4.56 8,322.39 8,322.39 100.00 4.56 8,322.39 0.00 0.01% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 12,937.71 6/30/2024 4.56 12,937.71 12,937.71 100.00 4.56 12,937.71 0.00 0.02% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 236,401.40 6/30/2024 4.56 236,401.40 236,401.40 100.00 4.56 236,401.40 0.00 0.31% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 63,101.09 6/30/2024 4.56 63,101.09 63,101.09 100.00 4.56 63,101.09 0.00 0.08% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 73,582.02 6/30/2024 4.56 73,582.02 73,582.02 100.00 4.56 73,582.02 0.00 0.1% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 43,560.36 6/30/2024 4.56 43,560.36 43,560.36 100.00 4.56 43,560.36 0.00 0.06% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 44,100.26 6/30/2024 4.56 44,100.26 44,100.26 100.00 4.56 44,100.26 0.00 0.06% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 2,695,816.01 6/30/2024 4.56 2,695,816.01 2,695,816.01 100.00 4.56 2,695,816.01 0.00 3.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: 12/31/2024Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 13 FROSTCASH1402 Frost Cash | Operating Cash 134,990.74 6/30/2024 4.56 134,990.74 134,990.74 100.00 4.56 134,990.74 0.00 0.18% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 40,358.39 6/30/2024 4.56 40,358.39 40,358.39 100.00 4.56 40,358.39 0.00 0.05% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 2,032.68 6/30/2024 4.56 2,032.68 2,032.68 100.00 4.56 2,032.68 0.00 0% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 55,121.41 6/30/2024 4.56 55,121.41 55,121.41 100.00 4.56 55,121.41 0.00 0.07% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 737,231.57 6/30/2024 4.56 737,231.57 737,231.57 100.00 4.56 737,231.57 0.00 0.98% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 20,489.37 6/30/2024 4.56 20,489.37 20,489.37 100.00 4.56 20,489.37 0.00 0.03% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash -190,595.01 6/30/2024 4.56 -190,595.01 -190,595.01 100.00 4.56 -190,595.01 0.00 -0.25% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 35,054.80 6/30/2024 4.56 35,054.80 35,054.80 100.00 4.56 35,054.80 0.00 0.05% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 911,593.93 6/30/2024 4.56 911,593.93 911,593.93 100.00 4.56 911,593.93 0.00 1.21% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 715,573.24 6/30/2024 4.56 715,573.24 715,573.24 100.00 4.56 715,573.24 0.00 0.95% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 1,384,671.77 6/30/2024 4.56 1,384,671.77 1,384,671.77 100.00 4.56 1,384,671.77 0.00 1.84% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 3,441,697.23 6/30/2024 4.56 3,441,697.23 3,441,697.23 100.00 4.56 3,441,697.23 0.00 4.57% 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: 12/31/2024Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 14 FROSTCASH1402 Frost Cash | Operating Cash 19,707.99 6/30/2024 4.56 19,707.99 19,707.99 100.00 4.56 19,707.99 0.00 0.03% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 520,128.61 6/30/2024 4.56 520,128.61 520,128.61 100.00 4.56 520,128.61 0.00 0.69% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 2,770,110.64 6/30/2024 4.56 2,770,110.64 2,770,110.64 100.00 4.56 2,770,110.64 0.00 3.68% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 146,550.26 6/30/2024 4.56 146,550.26 146,550.26 100.00 4.56 146,550.26 0.00 0.19% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 255,673.63 6/30/2024 4.56 255,673.63 255,673.63 100.00 4.56 255,673.63 0.00 0.34% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 1,613,981.13 6/30/2024 4.56 1,613,981.13 1,613,981.13 100.00 4.56 1,613,981.13 0.00 2.14% NR NR 0 1 FROSTCASH1402 Frost Cash | Operating Cash 605,998.10 6/30/2024 4.56 605,998.10 605,998.10 100.00 4.56 605,998.10 0.00 0.8% NR NR 0 1 MBS8852 Multi-Bank Securities MM 34,640.49 6/30/2024 0.10 34,640.49 34,640.49 100.00 0.10 34,640.49 0.00 0.05% NR NR 0 1 1 0 24.48% 0.00 18,436,047.39 4.55 18,436,047.39 18,436,047.394.5518,436,047.39Sub Total Operating Cash | TBD% TX LGIP | 75% TEXASCLASS4001 Texas CLASS LGIP 2,624,084.58 6/30/2024 4.45 2,624,084.58 2,624,084.58 100.00 4.45 2,624,084.58 0.00 3.48% NR NR 0 1 TEXASCLASS4001 Texas CLASS LGIP 4,312,695.27 6/30/2024 4.45 4,312,695.27 4,312,695.27 100.00 4.45 4,312,695.27 0.00 5.72% NR NR 0 1 TEXASCLASS4001 Texas CLASS LGIP 2,089,123.23 6/30/2024 4.45 2,089,123.23 2,089,123.23 100.00 4.45 2,089,123.23 0.00 2.77% 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: 12/31/2024Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 15 TEXSTAR1110 TexasStar LGIP 3,730.90 6/30/2024 4.56 3,730.90 3,730.90 100.00 4.56 3,730.90 0.00 0% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 284,980.78 6/30/2024 4.56 284,980.78 284,980.78 100.00 4.56 284,980.78 0.00 0.38% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 555,896.57 6/30/2024 4.56 555,896.57 555,896.57 100.00 4.56 555,896.57 0.00 0.74% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 1,105,497.43 6/30/2024 4.56 1,105,497.43 1,105,497.43 100.00 4.56 1,105,497.43 0.00 1.47% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 6,837.26 6/30/2024 4.56 6,837.26 6,837.26 100.00 4.56 6,837.26 0.00 0.01% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 1,147,949.55 6/30/2024 4.56 1,147,949.55 1,147,949.55 100.00 4.56 1,147,949.55 0.00 1.52% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 10,322.21 6/30/2024 4.56 10,322.21 10,322.21 100.00 4.56 10,322.21 0.00 0.01% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 269,920.05 6/30/2024 4.56 269,920.05 269,920.05 100.00 4.56 269,920.05 0.00 0.36% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 1,107,981.06 6/30/2024 4.56 1,107,981.06 1,107,981.06 100.00 4.56 1,107,981.06 0.00 1.47% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 898,301.96 6/30/2024 4.56 898,301.96 898,301.96 100.00 4.56 898,301.96 0.00 1.19% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 2,939,110.17 6/30/2024 4.56 2,939,110.17 2,939,110.17 100.00 4.56 2,939,110.17 0.00 3.9% NR NR 0 1 TEXSTAR1110 TexasStar LGIP 3,073,761.59 6/30/2024 4.56 3,073,761.59 3,073,761.59 100.00 4.56 3,073,761.59 0.00 4.08% 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: 12/31/2024Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 16 TEXPOOL0001 TexPool LGIP 2,342,168.88 6/30/2024 4.56 2,342,168.88 2,342,168.88 100.00 4.56 2,342,168.88 0.00 3.11% NR NR 0 1 TEXPOOL0001 TexPool LGIP 10,913.10 6/30/2024 4.56 10,913.10 10,913.10 100.00 4.56 10,913.10 0.00 0.01% NR NR 0 1 TEXPOOL0001 TexPool LGIP 200,856.34 6/30/2024 4.56 200,856.34 200,856.34 100.00 4.56 200,856.34 0.00 0.27% NR NR 0 1 TEXPOOL0001 TexPool LGIP 805,198.82 6/30/2024 4.56 805,198.82 805,198.82 100.00 4.56 805,198.82 0.00 1.07% NR NR 0 1 TEXPOOL0001 TexPool LGIP 3,987,848.88 6/30/2024 4.56 3,987,848.88 3,987,848.88 100.00 4.56 3,987,848.88 0.00 5.29% NR NR 0 1 TEXPOOL0001 TexPool LGIP 2,214,285.89 6/30/2024 4.56 2,214,285.89 2,214,285.89 100.00 4.56 2,214,285.89 0.00 2.94% NR NR 0 1 TEXPOOL0001 TexPool LGIP 72,945.18 6/30/2024 4.56 72,945.18 72,945.18 100.00 4.56 72,945.18 0.00 0.1% NR NR 0 1 TEXPOOL0001 TexPool LGIP 985,131.23 6/30/2024 4.56 985,131.23 985,131.23 100.00 4.56 985,131.23 0.00 1.31% NR NR 0 1 TEXPOOL0001 TexPool LGIP 2,524,445.54 6/30/2024 4.56 2,524,445.54 2,524,445.54 100.00 4.56 2,524,445.54 0.00 3.35% NR NR 0 1 TEXPOOL0001 TexPool LGIP 569,224.94 6/30/2024 4.56 569,224.94 569,224.94 100.00 4.56 569,224.94 0.00 0.76% NR NR 0 1 TEXPOOL0001 TexPool LGIP 713,707.43 6/30/2024 4.56 713,707.43 713,707.43 100.00 4.56 713,707.43 0.00 0.95% NR NR 0 1 TEXPOOL0001 TexPool LGIP 2,723,134.06 6/30/2024 4.56 2,723,134.06 2,723,134.06 100.00 4.56 2,723,134.06 0.00 3.61% 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: 12/31/2024Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 17 TEXPOOL0001 TexPool LGIP 7,548,022.38 6/30/2024 4.56 7,548,022.38 7,548,022.38 100.00 4.56 7,548,022.38 0.00 10.02% NR NR 0 1 1 0 59.89% 0.00 45,128,075.28 4.54 45,128,075.28 45,128,075.284.5445,128,075.28Sub Total TX LGIP | 75% TX LGIP Commerical Paper | 5% LOGIC8010 LOGIC | CEDC LGIP 519,240.18 6/30/2024 4.69 519,240.18 519,240.18 100.00 4.69 519,240.18 0.00 0.69% NR NR 0 1 LOGIC4001 LOGIC LGIP 38,083.97 6/30/2024 4.69 38,083.97 38,083.97 100.00 4.69 38,083.97 0.00 0.05% NR NR 0 1 LOGIC4001 LOGIC LGIP 171,436.14 6/30/2024 4.69 171,436.14 171,436.14 100.00 4.69 171,436.14 0.00 0.23% NR NR 0 1 LOGIC4001 LOGIC LGIP 1,480.34 6/30/2024 4.69 1,480.34 1,480.34 100.00 4.69 1,480.34 0.00 0% NR NR 0 1 LOGIC4001 LOGIC LGIP 214,012.71 6/30/2024 4.69 214,012.71 214,012.71 100.00 4.69 214,012.71 0.00 0.28% NR NR 0 1 LOGIC4001 LOGIC LGIP 93,759.79 6/30/2024 4.69 93,759.79 93,759.79 100.00 4.69 93,759.79 0.00 0.12% NR NR 0 1 LOGIC4001 LOGIC LGIP 776,900.76 6/30/2024 4.69 776,900.76 776,900.76 100.00 4.69 776,900.76 0.00 1.03% NR NR 0 1 LOGIC4001 LOGIC LGIP 27,341.76 6/30/2024 4.69 27,341.76 27,341.76 100.00 4.69 27,341.76 0.00 0.04% NR NR 0 1 1 0 2.44% 0.00 1,842,255.65 4.69 1,842,255.65 1,842,255.654.691,842,255.65Sub Total TX LGIP Commerical Paper | 5% US Agency | 75% 3130B15Z6 FHLB 5.2 4/25/2025 1,500,000.00 8/29/2024 4.48 1,503,289.55 1,506,809.94 100.25 4.36 14,300.00 1,503,760.79 471.24 2% S&P-AA+ Moodys-Aaa 0.32 115 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: 12/31/2024Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 18 3137EAEU9 FHLMC 0.375 7/21/2025 1,500,000.00 8/29/2024 4.35 1,467,850.76 1,448,239.73 97.84 4.35 2,500.00 1,467,615.00 -235.76 1.95% S&P-AA+ Moodys-Aaa 0.55 202 158 0.43 3.95% 235.48 2,971,375.79 16,800.004.35 2,955,049.67 2,971,140.314.423,000,000.00Sub Total US Agency | 75% % TBD, pending investment policy clarification TOTAL PORTFOLIO 75,378,940.17 4.54 75,350,080.48 75,333,989.84 4.51 78,247.40 75,355,688.07 5,607.59 100.00% 0.08 31 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: 12/31/2024Investment Policy Compliance Portfolio Holdings by Asset Category City of Colleyville | TX 19