Loading...
R-2025-024 - 2/13/2025 RESOLUTION NO. R-2025-024 WHEREAS, Chapter 2256, Texas Government Code, Section 2256.023 of the Public Funds Investment Act states that a written report of investments be submitted to the governing body at least quarterly; and WHEREAS, a Quarterly Investment Report for the quarter ending December 31, 2024 for the City of Round Rock has been submitted to the City Council; and WHEREAS, the City Council desires to acknowledge the receipt and acceptance of the attached Quarterly Investment Report, Now Therefore BE IT RESOLVED BY THE COUNCIL OF THE CITY OF ROUND ROCK,TEXAS, That the Quarterly Investment Report, attached hereto as Exhibit "A" and incorporated herein, is hereby received and accepted. The City Council hereby finds and declares that written notice of the date, hour, place and subject of the meeting at which this Resolution was adopted was posted and that such meeting was open to the public as required by law at all times during which this Resolution and the subject matter hereof were discussed, considered and formally acted upon, all as required by the Open Meetings Act, Chapter 551, Texas Government Code, as amended. RESOLVED this 13th day of February, 2025. CRAIGORG , Mayor City of tound Mock, Texas ATTEST: AV FRANKLIN,City Clerk 0112.20252:4896-7743-5156 P�ROaU�NID ROCK TEXAS QUARTERLY INVESTMENT REPORT For the Quarter Ended December 31, 2024 Prepared by Valley View Consulting, L.L.C. The investment portfolio of the City of Round Rock,Texas is in compliance with the Public Funds Investment Act and the Investment Policy and Strategies. Chief Financial Officer Deputy Chief Financial Officer Controller Treasury Accountant Valley Viev/ColIsulting, LLC Dated Disclaimer: These reports were compiled using information provided by the City. No procedures were performed to test the accuracy or completeness of this information. The market values included in these reports were obtained by Valley View Consulting,L.L.C.from sources believed to be accurate and represent proprietary valuation. Due to market fluctuations these levels are not necessarily reflective of current liquidation values. Yield calculations are not determined using standard performance formulas,are not representative of total return yields and do not account for investment advisor fees. Summary Holdings by Investment Category (Security Sector) December 31, 2024 YTM @ Description Cost Book Value Market Value Cash 0.09% $ 21,835,211 $ 21,835,211 Certificates of Deposit 4.50% 155,772,375 155,772,375 Local Government Investment Pool 4.58% 65,842,357 65,842,357 Money Market Accounts 4.60% 64,204,351 64,204,351 US Agency 4.72% 225,494,045 226,332,633 US Treasury 4.65% 14,695,994 14,730,919 Total/Average 4.44% $ 547,844,333 $ 548,717,845 September 30, 2024 YTM @ Description Cost Book Value Market Value Cash 0.12% $ 16,074,855 $ 16,074,855 Certificates of Deposit 4.70% 139,383,236 139,383,236 Local Government Investment Pool 5.18% 100,072,235 100,072,235 Money Market Accounts 5.06% 63,417,737 63,417,737 US Agency 4.72% 1 237,168,565 239,090,032 US Treasury4.71% 14,938,125 15,001,857 Total/Average 4.70% $ 571,054,753 $ 573,039,951 Average Yield Current Fiscal Year- Quarter(1) to-Date(2) Total Portfolio 4.44% 4.44% TexPool Yield 4.56% 4.56% Rolling Three Mo. Treas.Yield 4.56% 4.56% Rolling Six Mo.Treas.Yield 4.63% 4.63% Rolling 1 Yr.Treas.Yield 4.70% 4.70% Rolling 2 Yr. Treas. Yield 4.48% 4.48% Investment Income(3) Interest Income(Approximate) $ 6,432,228 $ 6,432,228 WAM at 12/31/2024 Policy WAM Max Total Portfolio 238 days 540 days Pooled Funds 266 days 540 days (1)Average Yield calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. (2)Fiscal Year-to-Date Average Yields calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. (3)Investment Income includes coupon interest,accrued interest,and discount and premium amortization. 1 City of Round Rock Valley View Consulting,L.L.C. Economic Overview 12/31/2024 The Federal Open Market Committee(FOMC)reduced the Fed Funds target range a third time to 4.25%-4.50%(Effective Fed Funds trade+/-4.33%). Expectations for additional rate cuts have diminished with one 0.25%cut projected in March/May. The next cut might not be until October. December Non-Farm Payroll improved to+256k new jobs,with the Three Month Rolling Average falling slightly to+170k(from the previous+173k). Third Quarter 2024 GDP final number increased to+3.1. The S&P 500 Stock Index experienced some volatility but still exceeds 6,000. The yield curve adjusted to a slight checkmark shape. Crude Oil bounced+/-$70 per barrel. Inflation remains above the FOMC 2%target(Core PCE+/-2.8%and Core CPI+/-3.3%). Declining global economic outlook and ongoing/expanding international political disruptions increases uncertainty. 6.00 Treasury Yield Curves S&P 500 5.00 AW 4.00 AV WNW7 3.00 2.00 _ - i 1:59 1.00 - 0.00 r � g g g Q o O ro 4 December 31,2023 September 30,2024 •December 31,2024 6.00 US Treasury Historical Yields-Since 2006 6.00 US Treasury Historical Yields-Since Nov 2018 5.50 - _ 5.50 r 5.00 5.00 4.50 4.50 4.00L nivu 4.00 3.50 bl ad WWI 3.50 3.00 3.00 2.502.50 2.00 -- -rte- �- - 1. 2.00 - - -- 1.50 1.50 IL so ' 1.00 --- 1.00 0.50 0.50 0.00 ILI 0.00 •Six Month Till Two Year T-Note Ten Year T-Note •Six Month T-Bill Two Year T-Note Ten Year T-Note 2 All numbers estimated and subject to change. Valley View Consulting,L.L.C. Holdings by Investment Category December 31, 2024 Pooled Debt Service Debt Service Reserve Capital Project&Special Total Funds Funds Funds Purpose Funds Portfolio Description Book Value %of Portfolio Book Value %of Portfolio Book Value %of Portfolio Book Value %of Portfolio Book Value %of Portfolio Cash $ 21,835,211 4% $ - 0% $ - 0% $ - 0°% $ 21,835,211 4% Certificates of Deposit 155,772,375 28°% - 0% - 0% - 0°% 155,772,375 28% Investment Pools 30,066,034 5% 5,692,191 1% 1,720,598 0% 28,363,534 5% 65,842,357 12% Money Market Accounts 41,866,049 8% - 0% - 0% 22,338,301 4% 64,204,351 12% Municipal - 0% - 0% - 0% - 0% - 0% US Agency 225,494,045 41% - 0% - 0% - 0°% 225,494,045 1 1% US Treasury 14,695,994 3% - 0% - 0% - 0% 14,695,994 1 3% Total/Average $489,729,709 89% $ 5,692,191 1% $ 1,720,598 0% $ 50,701,835 9% $547,844,333 100% Portfolio Balances (Millions) Order of Liquidity $600 ■Cash $500 ❑Local Government Investment Pool $400 ■Money Market Account $300 ■US Treasury $200 ❑US Agency ❑Municipal $100 ■Certificates of Deposit $0 Pooled Funds DS Funds DSR Funds CP&SP Funds Total Portfolio 12/31/2024 12/31/2024 12/31/2024 12/31/2024 12/31/2024 3 City of Round Rock Valley View Consulting,L.L.C. Investment Holdings by Investment Category Quarterly Transactions By Investment Category December 31, 2024 December 31,2024 %of Portfolio Net Cash Equivalent Description Book Value Portfolio Limitation Description Buys Sells Maturities Calls Interest Deposit/(Withdrawal) Cash $ 21,835,211 4.0% 100% Cash $ — $ — $ — $ — $ 57,817 $ 5,760,356 Investment Pools 65,842,357 12.0% 100% Investment Pools — — — — 937,134 34,229,878 Money Market Accounts 64,204,351 11.7% 75% Money Markets Accounts — — — — 786,614 786,614 Certificates of Deposit 155,772,375 28.4% 85% Certificates of Deposit 37,998,371 — 21,609,232 — 1,856,997 — Commercial Paper — 0.0% 10%/5% Commercial Paper — — — — — — Municipal — 0.0% 35%/5% Municipal — — — — — — US Agency 225,494,045 41.2% 85% US Agency 15,000,000 — 27,000,000 — 2,753,083 — US Treasury 14,695,994 2.7% 85% US Treasury 4,731,420 — 5,000,000 — 206,250 — Total/Average $ 547,844,333 100% PASSED Totals $ 57,729,791 $ — $ 53,609,232 $ — $ 6,597,895 $ 27,682,909 Portfolio Balances (Millions) Portfolio Composition Order of Liquidity December 31, 2024 Money Market Accounts $600 11.7% Certificates of ■Cash Deposit 28.4% $500 []Local Government Investment Pools ' Investment Pool 12.0% $400 ■Money Market Account $300 ■US Treasury Cash 4.0 $200 o US Agency US Treasury 2.7% $100 D Municipal $0 ■Certificates of Deposit I\,ya US Agency r�`✓ "�� 6� �� ^rye 41.2% 4 City of Round Rock Valley View Consulting,L.L.C. City of Round Rock Pooled Funds Performance 5.50 POE 't 1 5.00 4r/ 4.50 - - At 4.00 Aw I it I�r � 3.50 / cv / m 3.00 L a 2.50 2.00 1.50 1.00 0.50 - -- o 0.00 Nb� �.`o Ko111^ NN -Al � �� N(b No No �o `o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 oti o`� oti oti oti oti oti oti oti oti oti oti o`� o`� oti oti oti oti oti oti o�`�' ���' ���'o��'o�`� •�`� .��'o��'o��' ���' .��'o��'o�`� .��' .��'o��'o��' ���' .��'o��'o��' .��' .��'o��'o��' .��' .��'o��'o��' .��' .��'o��'o��' .��' .��'o��'o��' ���' Round Rock TexPool Rolling 1.5 yr Treasury (Policy WAM max) Rolling 9 mo Treasury 5 City of Round Rock Valley View Consulting,L.L.C. Portfolio Balances By Fund (Millions) $600 $500 ■Capital Project&Special Purpose Funds $400 oDebt Service Reserve Funds $300 o Debt Service Funds $200 $100 ■Pooled Funds $011111111111111111\,tio yp�,yoyp\,yoyp�tiory�,yotir.\ryoti'`�,yory`\,ytiry\,yo"\,yo,titiry y9 tih t9 ry9 tiP yb tib rya 6 City of Round Rock Valley View Consulting,L.L.C. Holdings by Allocation and Portfolio Fund December 31, 2024 Coupon Settlement Face Amount/ Market Days to YTM @ Issuer Credit Rating Book Value Market Value Maturity Date Rate Date Shares Price Maturity Book Fund 000-Pooled Investments NexBank 4.55% 11/29/2016 $ 27,955,402 $ 27,955,402 100.00 $ 27,955,402 N/A 1 4.55% TexasDAILY 4.57% AAAm 6/1/2021 2,724 2,724 100.00 2,724 N/A 1 4.57% TexasDAILY Select 4.75% AAAm 12/3/2021 5,644,402 5,644,402 100.00 5,644,402 N/A 1 4.75% Veritex Community Bank 4.56% 9/1/2020 212,744 212,744 100.00 212,744 N/A 1 4.56% JPMor an Chase 0.09% 9/30/2015 21,835,211 21,835,211 100.00 21,835,211 N/A 1 0.09% TexSTAR 4.56% AAAm 9/30/2015 225,323 225,323 100.00 225,323 N/A 1 4.56% TexPool 4.56% AAAm 9/30/2015 21,648,874 21,648,874 100.00 21,648,874 N/A 1 4.56% NexBank 4.55% 1/13/2023 13,697,902 13,697,902 100.00 13,697,902 N/A 1 4.55% TexasDAILY 4.57% AAAm 9/30/2015 2,544,710 2,544,710 100.00 2,544,710 N/A 1 4.57% Independent Financial Bank 4.50% 1/31/2023 5,402,456 5,402,456 100.00 5,402,456 1/31/2025 31 4.50% American Nat'l Bank&Trust 4.50% 2/10/2023 10,858,088 10,858,088 100.00 10,858,088 2/10/2025 41 4.50% FHLB 4.50% Aaa/AA+/-- 2/24/2023 5,000,000 4,998,004 100.01 5,000,275 2/13/2025 44 4.85% FHLB 4.69% Aaa/AA+/-- 2/15/2023 20,000,000 20,000,000 100.04 20,008,820 3/14/2025 73 4.69% Veritex Community Bank 5.12% 3/8/2024 5,196,217 5,196,217 100.00 5,196,217 4/8/2025 98 5.12% Treasury 2.63% Aaa/AA+/AA+ 2/24/2023 5,000,000 4,972,534 99.53 4,976,505 4/15/2025 105 4.65% American Nat'l Bank&Trust 4.50% 3/30/2023 10,818,076 10,818,076 100.00 10,818,076 4/28/2025 118 4.50% American Nat'l Bank&Trust 4.50% 3/30/2023 10,800,797 10,800,797 100.00 10,800,797 5/15/2025 135 4.50% American Nat'l Bank&Trust 5.00% 11/24/2023 5,284,492 5,284,492 100.00 5,284,492 5/22/2025 142 5.00% American Nat'l Bank&Trust 5.00% 11/29/2023 5,280,165 5,280,165 100.00 5,280,165 5/29/2025 149 5.00% Texas Bank 4.66% 12/12/2024 5,374,909 5,374,909 100.00 5,374,909 6/12/2025 163 4.66% Texas Bank 4.56% 6/15/2023 3,225,333 3,225,333 100.00 3,225,333 6/12/2025 163 4.56% FHLB 4.75% Aaa/AA+/-- 7/7/2023 5,000,000 4,990,571 100.15 5,007,551 6/13/2025 164 5.19% American Nat'l Bank&Trust 4.56% 6/22/2023 8,578,629 8,578,629 100.00 8,578,629 6/19/2025 170 4.56% FHLB 4.75% Aaa/AA+/-- 6/22/2023 8,000,000 8,000,000 100.20 8,015,790 6/20/2025 171 4.75% FHLB 4.81% Aaa/AA+/-- 3/7/2024 5,000,000 5,000,000 100.22 5,011,101 7/7/2025 188 4.81% American Nat'l Bank&Trust 5.10% 9/14/2023 3,197,379 3,197,379 100.00 3,197,379 7/14/2025 195 5.10% FHLB 3.60% Aaa/AA+/-- 8/28/2023 500,000 495,845 99.60 497,976 7/18/2025 199 5.227/. FHLMC 0.38% Aaa/AA+/AA+ 8/28/2023 5,000,000 4,876,831 97.84 4,891,800 7/21/2025 202 5.11% FFCB 4.88% Aaa/AA+/AA+ 8/16/2023 5,000,000 4,995,738 100.30 5,014,879 7/28/2025 209 5.03% American Nat'l Bank&Trust 5.10% 9/19/2023 5,328,965 5,328,965 100.00 5,328,965 8/19/2025 231 5.10% FAMC 5.18% 9/27/2023 10,000,000 10,000,000 100.51 10,051,439 8/27/2025 239 5.18% American Nat'l Bank&Trust 5.25% 11/9/2023 4,233,922 4,233,922 100.00 4,233,922 9/9/2025 252 5.25% Wallis Bank 5.30% 11/15/2023 6,325,282 6,325,282 100.00 6,325,282 9/15/2025 258 5.30% American Nat'l Bank&Trust 5.00% 12/7/2023 5,275,090 5,275,090 100.00 5,275,090 10/2/2025 275 5.00% American Nat'l Bank&Trust 4.90% 12/14/2023 5,264,495 5,264,495 100.00 5,264,495 10/9/2025 282 4.90% Treasury 5.00% Aaa/AA+/AA+ 4/25/2024 5,000,000 4,997,749 100.58 5,028,917 10/31/2025 304 5.06% TVA 0.00% Aaa/AA+/AA+ 1/19/2024 5,000,000 4,817,425 96.39 4,819,450 11/1/2025 305 4.61% TVA 0.00% Aaa/AA+/AA+ 1/30/2024 10,000,000 9,634,804 96.39 9,638,900 11/1/2025 305 4.61% FNMA 0.50% Aaa/AA+/AA+ 1/4/2024 10,000,000 9,680,424 96.88 9,688,451 11/7/2025 311 4.45% FHLB 4.75% Aaa/AA+/-- 2/5/2024 15,000,000 15,041,001 100.49 15,073,547 12/12/2025 346 4.44% Independent Financial Bank 3.40% 12/31/2024 10,885,619 10,885,619 100.00 10,885,619 12/31/2025 365 3.40% FHLB 4.50% Aaa/AA+/-- 2/14/2024 13,000,000 13,000,000 100.31 13,040,690 1/2/2026 367 4.50% FHLB 4.70% Aaa/AA+/-- 2/26/2024 15,000,000 15,000,000 100.54 15,080,850 2/13/2026 409 4.70% FFCB 4.63% Aaa/AA+/AA+ 3/6/2024 20,000,000 20,011,347 100.23 20,045,016 3/5/2026 429 4.57% Cornerstone Capital Bank 4.50% 9/5/2024 12,175,748 12,175,748 100.00 12,175,748 3/5/2026 429 4.50% Cornerstone Capital Bank 4.40% 9/26/2024 12,141,197 12,141,197 100.00 12,141,197 3/26/2026 450 4.40% FAMC 4.65% 4/22/2024 10,000,000 9,957,046 100.48 10,048,190 4/8/2026 4631 5.01% FFCB 4.88% Aaa/AA+/AA+ 1 4/25/2024 10,000,000 9,988,383 100.82 10,082,389 4/15/2026 476T 4.97% 7 City of Round Rock Valley View Consulting,L.L.C. Holdings by Allocation and Portfolio Fund December 31, 2024 Coupon Settlement Face Amount) Market Days to YTM @ Issuer Rate Credit Rating Date Shares Book Value Price Market Value Maturity Date Maturity Book FAMC 4.95% 5/6/2024 10,000,000 10,000,000 100.90 10,090,400 5/6/2026 491 4.95% FFCB 4.75% Aaa/AA+/AA+ 5/9/2024 2,000,000 1,997,173 100.79 2,015,700 5/8/2026 493 4.86% FFCB 4.88% Aaa/AA+/AA+ 5/16/2024 3,000,000 3,004,276 100.91 3,027,193 5/15/2026 5001 4.77% FHLB 4.88% Aaa/AA+/-- 6/6/2024 5,000,000 5,005,176 100.90 5,044,834 6/12/2026 5281 4.79% FAMC 4.75% 6/21/2024 20,000,000 20,000,000 100.69 20,137,316 6/18/2026 534 4.75% Treasury 0.63% Aaa/AA+/AA+ 12/18/2024 5,000,000 4,725,711 94.51 4,725,498 7/31/2026 577 4.25% Third Coast Bank 3.75% 10/3/2024 20,125,516 20,125,516 100.00 20,125,516 10/3/2026 641 3.75% FAMC 4.33% 11/20/2024 15,000,000 15,000,000 1 100.00 1 15,000,080 11/20/2026 689 4.33% Sub Total/Average 4.08% 491,039,670 489,729,709 1 99.91 1 490,603,222 266 4.42% Fund 170-Interest&Sinking GO Bonds TexasDAILY 4.57% AAArn 1 4/30/2016 31,067 1 31,067 1 100.00 1 31,067 1 N/A 1 4.57% TexPool 4.56% AAAm 9/30/2015 2,843,117 2,843,117 100.00 2,843,117 N/A 1 4.56% Sub Total/Average 4.56% 2,874,184 2,874,184 100.00 2,874,184 11 4.56% Fund 466&467-2024 CO TexPool 4.56% AAAm 5/17/2024 17,106,143 17,106,143 100.00 17,106,143 N/A 1 4.56% Sub Total/Average 4.56% 17,106,143 17,106,143 100.00 17,106,143 1 4.56% Fund 551 -2024 LTN TexPool 4.56% AAAm 5/17/2024 8,252,704 8,252,704 100.00 8,252,704 N/A 1 4.56% Sub Total/Average 4.56% 1 8,252,704 8,252,704 100.00 8,252,704 1 4.56% Fund 602-Interest&Sinking Revenue Bonds TexPool 4.56% AAAm 9/30/2015 2,818,007 2,818,007 100.00 2,818,007 N/A 1 4.56% Sub Total/Average 4.56% 2,818,007 2,818,007 100.00 2,818,007 1 4.56% Fund 604-2022 SIB Loan TexPool 4.56% AAAm 9/29/2022 3,004,686 3,004,686 100.00 3,004,686 N/A 1 4.56% American Nat'l Bank&Trust 0.35% 9/19/2023 679 679 100.00 679 N/A 1 0.35% American Nat'l Bank&Trust 4.69% 11/21/2022 22,337,623 22,337,623 100.00 22,337,623 N/A 1 4.69% Sub Total/Average 4.68% 25,342,987 25,342,987 100.00 25,342,987 1 4.68% Fund 605-Kalahari Debt Service Reserve TexPool 4.56% AAAm 8/30/2019 1 1,720,598 1 1,720,598 100.00 1,720,598 N/A 1 4.560/( Sub Total/Average 4.56% 1 1,720,598 1 1,720,598 1 100.00 1 1,720,598 11 4.56% Total/Average_ 4.14% 1 $ 549,154,294 $ 547,844,333 1 99.92 1 548,717,845 1 2381 4.44% 8 City of Round Rock Valley View Consulting,L.L.C. Book Value Comparison December 31, 2024 Issuer Coupon Settlement Maturity Beginning Book Total Buys/ Total Sells/ Ending Book Change in Book Rate Date Date Value Increases Decreases Value Value Fund 000-Pooled Investments JPMor an Chase N/A 9/30/2015 N/A $ 16,074,855 $ 11,478,832 $ 5,718,477 $ 21,835,211 $ 5,760,356 TexPool N/A 9/30/2015 N/A 56,070,079 409,669 34,830,874 21,648,874 34,421,204 TexSTAR N/A 9/30/2015 N/A 222,666 2,657 — 225,323 2,657 TexasDAILY N/A 9/30/2015 N/A 2,514,639 30,071 — 2,544,710 30,071 TexasDAILY N/A 6/1/2021 N/A 2,692 32 — 2,724 32 TexasDAILY Select N/A 12/3/2021 N/A 5,575,772 68,630 — 5,644,402 68,630 NexBank N/A 11/29/2016 N/A 27,615,762 339,641 — 27,955,402 339,641 Veritex Community Bank N/A 9/1/2020 N/A 210,271 2,473 — 212,744 2,473 NexBank N/A 1/13/2023 N/A 13,531,482 166,421 — 13,697,902 166,421 FHLB 4.50% 11/1/2022 10/3/2024 2,999,963 — 3,000,000 — 2,999,963 FHLB 4.50% 11/1/2022 10/3/2024 1,999,975 — 2,000,000 — 1,999,975 fr—easury 0.63% 12/13/2022 10/15/2024 4,992,589 — 5,000,000 — 4,992,589 FFCB 4.38% 10/17/2022 10/17/2024 7,000,019 — 7,000,000 — 7,000,019 FHLB 4.53% 12/14/2022 11/18/2024 15,000,000 — 15,000,000 — 15,000,000 Texas Bank 4.56% 6/15/2023 12/12/2024 5,309,852 43,474 5,353,326 — 5,309,852 Texas Capital Bank 4.71% 1/19/2023 12/13/2024 5,408,303 42,691 5,450,994 — 5,408,303 Independent Financial Bank 4.50% 1/31/2023 12/31/2024 10,684,063 120,849 10,804,912 — 10,684,063 Independent Financial Bank 4.50% 1/31/2023 1/31/2025 5,342,032 60,424 — 5,402,456 60,424 American Nat'l Bank&Trust 4.50% 2/10/2023 2/10/2025 10,737,175 120,913 — 10,858,088 120,913 FHLB 4.50% 2/24/2023 2/13/2025 4,993,830 — — 4,998,004 4,174 FHLB 4.69% 2/15/2023 3/14/2025 20,000,000 — — 20,000,000 — Veritex Community Bank 5.12% 3/8/2024 4/8/2025 5,130,448 65,769 — 5,196,217 65,769 Treasury 2.63% 2/24/2023 4/15/2025 4,948,468 — — 4,972,534 24,066 American Nat'l Bank&Trust 4.50% 3/30/2023 4/28/2025 10,697,608 120,468 — 10,818,076 120,468 American Nat'l Bank&Trust 4.50% 3/30/2023 5/15/2025 10,680,522 120,275 — 10,800,797 120,275 American Nat'l Bank&Trust 5.00% 11/24/2023 5/22/2025 5,218,315 66,177 — 5,284,492 66,177 American Nat'l Bank&Trust 5.00% 11/29/2023 5/29/2025 5,214,028 66,137 — 5,280,165 66,137 Texas Bank 4.66% 12/12/2024 6/12/2025 — 5,374,909 — 5,374,909 5,374,909 Texas Bank 4.56% 6/15/2023 6/12/2025 3,185,911 39,422 — 3,225,333 39,422 FHLB 4.75% 7/7/2023 6/13/2025 4,985,282 — — 4,990,571 5,289 American Nat'l Bank&Trust 4.56% 6/22/2023 6/19/2025 8,480,599 98,030 — 8,578,629 98,030 FHLB 4.75% 6/22/2023 6/20/2025 8,000,000 — — 8,000,000 — FHLB 4.81% 3/7/2024 7/7/2025 5,000,000 — — 5,000,000 — American Nat'l Bank&Trust 5.10% 9/14/2023 7/14/2025 3,157,067 40,313 — 3,197,379 40,313 FHLB 3.600 8/28/2023 7/18/2025 493,925 — — 495,845 1,921 FHLMC 0.38% 8/28/2023 7/21/2025 4,820,735 — — 4,876,831 56,097 FFCB 4.88% 8/16/2023 7/28/2025 4,993,862 — — 4,995,738 1,876 American Nat'l Bank&Trust 5.10% 9/19/2023 8/19/2025 5,261,778 67,188 — 5,328,965 67,188 FAMC 5.18% 9/27/2023 8/27/2025 10,000,000 — — 10,000,000 — American Nat'l Bank&Trust 5.25% 11/9/2023 9/9/2025 4,178,984 54,938 — 4,233,922 54,938 Wallis Bank 5.30°% 11/15/2023 9/15/2025 6,241,898 83,385 — 6,325,282 83,385 American Nat'l Bank&Trust 5.00% 12/7/2023 10/2/2025 5,209,032 66,059 — 5,275,090 66,059 American Nat'l Bank&Trust 4.90% 12/14/2023 10/9/2025 5,199,879 64,616 — 5,264,495 64,616 Treasury 5.00% 4/25/2024 10/31/2025 4,997,068 — — 4,997,749 681 TVA 0.00°% 1/30/2024 11/1/2025 9,524,646 — — 9,634,804 110,158 TVA 0.00°% 1/19/2024 11/1/2025 4,762,353 — — 4,817,425 55,072 FNMA 0.50°% 1/4/2024 11/7/2025 9,585,887 — — 9,680,424 94,537 FHLB 4.75°% 2/5/2024 12/12/2025 15,051,903 — — 15,041,001 10,902 Independent Financial Bank 3.40°% 12/31/2024 12/31/2025 — 10,885,619 — 10,885,619 10,885,619 FHLB 4.50°% 2/14/2024 1/2/2026 13,000,000 — — 13,000,000 — FHLB 4.70°% 2/26/2024 2/13/2026 15,000,000 — — 15,000,000 — FFCB 4.63% 3/6/2024 3/5/2026 20,013,781 — — 20,011,347 2,433 9 City of Round Rock Valley View Consulting,L.L.C. Book Value Comparison December 31, 2024 Issuer Coupon Settlement Maturity Beginning Book Total Buys/ Total Sells/ Ending Book Change in Book Rate Date Date Value Increases Decreases Value Value Cornerstone Capital Bank 4.50% 9/5/2024 3/5/2026 12,038,505 137,243 - 12,175,748 137,243 Cornerstone Capital Bank 4.40% 9/26/2024 3/26/2026 12,007,238 133,959 - 12,141,197 133,959 FAMC 4.65% 4/22/2024 4/8/2026 9,948,511 - - 9,957,046 8,535 FFCB 4.88% 4/25/2024 4/15/2026 9,986,109 - - 9,988,383 2,274 FAMC 4.95% 5/6/2024 5/6/2026 10,000,000 - - 10,000,000 - FFC13 4.75% 5/9/2024 5/8/2026 1,996,645 - - 1,997,173 528 FFCB 4.88% 5/16/2024 5/15/2026 3,005,063 - - 3,004,276 787 FHLB 4.88% 6/6/2024 6/12/2026 5,006,078 - - 5,005,176 902 FAMC 4.75% 6/21/2024 6/18/2026 20,000,000 - - 20,000,000 - Treasury 0.63% 12/18/2024 7/31/2026 - 4,731,420 - 4,725,711 4,725,711 Third Coast Bank 3.75% 10/3/2024 10/3/2026 - 20,125,516 - 20,125,516 20,125,516 FAMC 4.33% 11/20/2024 11/20/2026 - 15,000,000 - 15,000,000 Sub TotallAvera a Fund 000-Pooled Investments 513,308,144 1 70,228,218 94,158,582 489,729,709 23,578,435 Fund 170-Interest&Sinking GO Bonds TexPool N/A 9/30/2015 N/A 1 1,288,678 1 1,559,861 5,422 2,843,117 1,554,439 TexasDAILY N/A 4/30/2016 N/A 1 30,700 1 367 - 31,067 367 Sub Total/Average Fund 170-Interest&Sinking GO Bonds 1,319,378 1 1,560,228 5,422 2,874,184 1,554,806 Fund 463-2024 GO TexPool N/A 10/30/2024 N/A - 13,998 13,998 - - Sub TotallAvera a Fund 463-2024 GO - 13,998 13,998 - - Fund 465-Road CO Bond Fund TexPoolN/A 10/31/2024 N/A - 2,288 2,288 - - Sub Total/Average Fund 465-Road CO Bond Fund - 2,288 2,288 - - Fund 466&467-2024 CO TexPool N/A 5/17/2024 N/A 1 16.903,607 1 202,536 - 17,106,143 202,536 Sub Total/Average Fund 466&467-2024 CO 1 16,903,607 1 202,536 - 17,106,143 202,536 Fund 551 -2024 LTN TexPool N/A 5/17/2024 N/A 8,154,993 97,712 - 8,252,704 97,712 Sub Total/Average Fund 551 -2024 LTN 8,154,993 97,712 - 8,252,704 97,712 Fund 591 -Reserves Fund TexPool N/A 9/30/2015 N/A 9,693 102 9,795 1 - 9,693 Sub Total/Average Fund 591 -Reserves Fund 9,693 102 9,795 1 - 9,693 Fund 602-Interest&Sinking Revenue Bonds TexPool N/A 9/30/2015 N/A 2,679,548 1 138,459 - 2,818,007 138,459 Sub Total/Average Fund 602-Interest&Sinking Revenue Bonds 2,679,548 1 138,459 - 2,818,007 138,459 Fund 604-2022 SIB Loan TexPool N/A 9/29/2022 N/A 1 2,969,111 1 35,575 1 -__L 3,004,686_L 35,575 American Nat'l Bank&Trust N/A 9/19/2023 N/A 1 678 1 1 - 679 1 American Nat'l Bank&Trust N/A 11/21/2022 N/A 1 22,059,544 1 278,079 - 22,337,623 278,079 Sub Total/Average Fund 604-2022 SIB Loan 1 25,029,333 1 313,655 - 25,342,987 313,655 Fund 605-Kalahari Debt Service Reserve TexPool N/A 8/30/2019 N/A 3,650,057 1 34,296 1,963,755 1,720,598 1,929,459 Sub Total/Average Fund 605-Kalahari Debt Service Reserve 3,650,057 34,296 1,963,755 1,720,598 1,929,459 Total/Average $ 571,054,753 $ 72,591,491 $ 96,153,840 $ 547,844,333 $ 23,510,668 10 City of Round Rock Valley View Consulting,L.L.C. Market Value Comparison December 31, 2024 Issuer Coupon Settlement Maturity Beginning Total Buys/ Total Sells/ Ending Market Change in Rate Date Date Market Value Increases Decreases Value Market Value Fund 000-Pooled Investments JPMor an Chase N/A 9/30/2015 N/A $ 16,074,855 $ 11,478,832 $ 5,718,477 $ 21,835,211 $ — TexPool N/A 9/30/2015 N/A 56,070,079 409,669 34,830,874 21,648,874 — TexSTAR N/A 9/30/2015 N/A 222,666 2,657 — 225,323 — TexasDAILY N/A 9/30/2015 N/A 2,514,639 30,071 — 2,544,710 — TexasDAILY N/A 6/1/2021 N/A 2,692 32 — 2,724 — TexasDAILY Select N/A 12/3/2021 N/A 5,575,772 68,630 — 5,644,402 — NexBank N/A 11/29/2016 N/A 27,615,762 339,641 — 27,955,402 — Veritex Community Bank N/A 9/1/2020 N/A 210,271 2,473 — 212,744 — NexBank N/A 1/13/2023 N/A 13,531,482 166,421 — 13,697,902 — FHLB 4.50% 11/1/2022 10/3/2024 2,999,892 — 3,000,000 — 108 FHLB 4.50% 11/1/2022 10/3/2024 1,999,928 — 2,000,000 — 72 Treasury 0.63% 12/13/2022 10/15/2024 4,991,256 — 5,000,000 — 8,745 FFCB 4.38% 10/17/2022 10/17/2024 6,998,386 — 7,000,000 — 1,614 FHLB 4.53% 12/14/2022 11/18/2024 14,996,898 — 15,000,000 — 3,102 Texas Bank 4.56% 6/15/2023 12/12/2024 5,309,852 43,474 5,353,326 — — Texas Capital Bank 4.71% 1/19/2023 12/13/2024 5,408,303 42,691 5,450,994 — — Independent Financial Bank 4.50% 1/31/2023 12/31/2024 10,684,063 120,849 10,804,912 — — Independent Financial Bank 4.50% 1/31/2023 1/31/2025 5,342,032 60,424 — 5,402,456 — American Nat'l Bank&Trust 4.50% 2/10/2023 2/10/2025 10,737,175 120,913 — 10,858,088 — FHLB 4.50% 2/24/2023 2/13/2025 4,998,885 — — 5,000,275 1,390 FHLB 4.69% 2/15/2023 3/14/2025 20,017,232 — — 20,008,820 8,412 Veritex Community Bank 5.12% 3/8/2024 4/8/2025 5,130,448 65,769 — 5,196,217 — Treasury 2.63% 2/24/2023 4/15/2025 4,956,206 — — 4,976,505 20,299 American Nat'l Bank&Trust 4.50% 3/30/2023 4/28/2025 10,697,608 120,468 — 10,818,076 — American Nat'l Bank&Trust 4.50% 3/30/2023 5/15/2025 10,680,522 120,275 — 10,800,797 — American Nat'l Bank&Trust 5.00% 11/24/2023 5/22/2025 5,218,315 66,177 — 5,284,492 — American Nat'l Bank&Trust 5.00% 11/29/2023 5/29/2025 5,214,028 66,137 — 5,280,165 — Texas Bank 4.66% 12/12/2024 6/12/2025 — 5,374,909 — 5,374,909 — Texas Bank 4.56% 6/15/2023 6/12/2025 3,185,911 39,422 — 3,225,333 — FHLB 4.75% 7/7/2023 6/13/2025 5,017,400 — — 5,007,551 9,850 American Nat'l Bank&Trust 4.56% 6/22/2023 6/19/2025 8,480,599 98,030 — 8,578,629 — FHLB 4.75% 6/22/2023 6/20/2025 8,031,317 — — 8,015,790 15,527 FHLB 4.81% 3/7/2024 7/7/2025 5,021,964 — — 5,011,101 10,863 American Nat'l Bank&Trust 5.10% 9/14/2023 7/14/2025 3,157,067 40,313 — 3,197,379 — FHLB 3.60% 8/28/2023 7/18/2025 497,699 — — 497,976 277 FHLMC 0.38% 8/28/2023 7/21/2025 4,854,364 — — 4,891,800 37,436 FFCB 4.88% 8/16/2023 7/28/2025 5,031,659 — — 5,014,879 16,780 American Nat'l Bank&Trust 5.10% 9/19/2023 8/19/2025 5,261,778 67,188 — 5,328,965 — FAMC 5.18% 9/27/2023 8/27/2025 10,090,248 — — 10,051,439 38,809 American Nat'l Bank&Trust 5.25% 11/9/2023 9/9/2025 4,178,984 54,938 — 4,233,922 — Wallis Bank 5.30% 11/15/2023 9/15/2025 6,241,898 83,385 — 6,325,282 — American Nat'l Bank&Trust 5.00% 12/7/2023 10/2/2025 5,209,032 66,059 — 5,275,090 — American Nat'l Bank&Trust 4.90% 12/14/2023 10/9/2025 5,199,879 64,616 — 5,264,495 — Treasury 5.00% 4/25/2024 10/31/2025 5,054,396 — — 5,028,917 25,479 TVA 0.00% 1/30/2024 11/1/2025 9,570,968 — — 9,638,900 67,932 TVA 0.00% 1/19/2024 11/1/2025 4,785,484 — — 4,819,450 33,966 FNMA 0.50% 1/4/2024 11/7/2025 9,635,150 — — 9,688,451 53,301 FHLB 4.75% 2/5/2024 12/12/2025 15,127,847 — — 15,073,547 54,300 Independent Financial Bank 3.40% 12/31/2024 12/31/2025 — 10,885,619 — 10,885,619 — FHLB 4.50% 2/14/2024 1/2/2026 13,098,865 — — 13,040,690 58,175 FHLB 4.70% 2/26/2024 2/13/2026 15,167,214 — — 15,080,850 86,364 FFCB 4.63% 3/6/2024 3/5/2026 20,209,794 1 20,045,016 164,778 11 City of Round Rock Valley View Consulting,L.L.C. Market Value Comparison December 31, 2024 Coupon Settlement Maturity Beginning Total Buys/ Total Sells/ Ending Market Change in Issuer Rate Date Date Market Value Increases Decreases Value Market Value Cornerstone Capital Bank 4.50°/ 9/5/2024 3/5/2026 12,038,505 137,243 - 12,175,748 - Cornerstone Capital Bank 4.40% 9/26/2024 3/26/2026 12,007,238 133,959 - 12,141,197 - FAMC 4.65% 4/22/2024 4/8/2026 10,116,472 - - 10,048,190 68,282 FFCB 4.88% 4/25/2024 4/15/2026 10,160,018 - - 10,082,389 77,629 FAMC 4.95% 5/6/2024 5/6/2026 10,172,805 - - 10,090,400 82,405 FFCB 4.75% 5/9/2024 5/8/2026 2,031,978 - - 2,015,700 16,278 FFCB 4.88% 5/16/2024 5/15/2026 3,052,687 - - 3,027,193 25,494 FHLB 4.88% 6/6/2024 6/12/2026 5,090,168 - - 5,044,834 45,335 FAMC 4.75% 6/21/2024 6/18/2026 20,314,712 - - 20,137,316 177,396 Treasury 0.63% 12/18/2024 7/31/2026 - 4,731,420 - 4,725,498 5,966 Third Coast Bank 3.75% 10/3/2024 10/3/2026 - 20,125,516 - 20,125,516 - FAMC 4.33% 11/20/2024 11/20/2026 1 - 15,000,000 - 15,000,080 80 Sub Total/Average Fund 000-Pooled Investments 1 515,293,342 70,228,218 1 94,158,582 490,603,222 747,868 Fund 170-Interest&Sinking GO Bonds TexPool N/A 9/30/2015 N/A 1,288,678 1,559,861 1 5,422 1 2,843,117 - TexasDAILY N/A 4/30/2016 N/A 30,700 367 - 1 31,067 - Sub Total/Average Fund 170-Interest&Sinking GO Bonds 1,319,378 1 1,560,228 5,422 1 2,874,184 1 - Fund 463-2024 GO TexPool N/A 10/30/2024 N/A - 13,998 13,998 1 - Sub Total/Average Fund 463-2024 GO - 13,998 13,998 1 - - Fund 465-Road CO Bond Fund TexPool N/A 10/31/2024 N/A - 2,288 2,288 - - Sub Total/Average Fund 465-Road CO Bond Fund - 2,288 2,288 - - Fund 466&467-2024 CO TexPool N/A 5/17/2024 N/A 16,903,607 202,536 - 17,106,143 - Sub Total/Average Fund 466&467-2024 CO 16,903,607 202,536 - 17,106,143 - Fund 551 -2024 LTN TexPool N/A 5/17/2024 N/A 8,154,993 97,712 - 8,252,704 - Sub Total/Average Fund 551 -2024 LTN 8,154,993 97,712 - 8,252,704 - Fund 591 -Reserves Fund TexPool N/A 9/30/2015 N/A 9,693 102 9,795 1 - - Sub Total/Average Fund 591 -Reserves Fund 9,693 102 9,795 1 - - Fund 602-Interest&Sinking Revenue Bonds TexPool N/A 9/30/2015 N/A 2,679,548 138,459 - 2,818,007 - Sub Total/Average Fund 602-Interest&Sinking Revenue Bonds 2,679,548 138,459 - 2,818,007 - Fund 604-2022 SIB Loan TexPool N/A 9/29/2022 N/A 2,969,111 35,575 - 3,004,686 - American Nat'l Bank&Trust N/A 9/19/2023 N/A 678 1 - 679 - American Nat'l Bank&Trust N/A 11/21/2022 N/A 22,059,544 278,079 - 22,337,623 - Sub Total/Average Fund 604-2022 SIB Loan 25,029,333 313,655 - 25,342,987 - Fund 605-Kalahari Debt Service Reserve TexPool N/A 8/30/2019 N/A 3,650,057 34,296 1,963,755 1 1,720,598 - Sub Total/Average Fund 605-Kalahari Debt Service Reserve 3,650,057 34,296 1 1,963,755 1 1,720,598 - Total/Average $ 573,039,951 $ 72,591,491 $ 96,153,840 $ 548,717,845 $ 747,868 12 City of Round Rock Valley View Consulting, L.L.C. Holdings by Allocation and Portfolio Fund September 30, 2024 Coupon Settlement Face Amount/ Book Days to YTM @ Issuer Credit Rating Book Value Market Value Maturity Date Rate Date Shares Price Maturity Book Fund 000-Pooled Investments NexBank 5.00% 11/29/2016 $ 27,615,762 $ 27,615,762 100.00 $ 27,615,762 N/A 1 5.00% TexasDAILY 5.98% AAAm 6/1/2021 2,692 2,692 100.00 2,692 N/A 1 5.98% TexasDAILY Select 5.07% AAAm 12/3/2021 5,575,772 5,575,772 100.00 5,575,772 N/A 1 5.07% Veritex Community Bank 5.24% 9/1/2020 210,271 210,271 100.00 210,271 N/A 1 5.24% JPMor an Chase 0.12% 9/30/2015 16,074,855 16,074,855 100.00 16,074,855 N/A 1 0.12% TexSTAR 5.13% AAAm 9/30/2015 222,666 222,666 100.00 222,666 N/A 1 5.13% TexPool 5.16% AAAm 9/30/2015 56,070,079 56,070,079 100.00 56,070,079 N/A 1 5.16% NexBank 5.00% 1/13/2023 13,531,482 13,531,482 100.00 13,531,482 N/A 1 5.00% TexasDAILY 5.98% AAAm 9/30/2015 2,514,639 2,514,639 100.00 2,514,639 N/A 1 5.98% FHLB 4.50% Aaa/AA+/-- 11/1/2022 3,000,000 2,999,963 100.00 2,999,892 10/3/2024 3 4.66% FHLB 4.50% Aaa/AA+/-- 11/1/2022 2,000,000 1,999,975 100.00 1,999,928 10/3/2024 3 4.66% Treasury 0.63% Aaa/AA+/AA+ 12/13/2022 5,000,000 4,992,589 99.83 4,991,256 10/15/2024 15 4.43% FFCB 4.38% Aaa/AA+/AA+ 10/17/2022 7,000,000 7,000,019 99.98 6,998,386 10/17/2024 17 4.37% FHLB 4.53% Aaa/AA+/-- 12/14/2022 15,000,000 15,000,000 99.98 14,996,898 11/18/2024 49 4.53% Texas Capital Bank 4.71% 1/19/2023 5,408,303 5,408,303 100.00 5,408,303 12/13/2024 74 4.71% Independent Financial Bank 4.50% 1/31/2023 10,684,063 10,684,063 100.00 10,684,063 12/31/2024 92 4.50% independent Financial Bank 4.50% 1/31/2023 5,342,032 5,342,032 100.00 5,342,032 1/31/2025 123 4.50% American Nat'l Bank&Trust 4.50% 2/10/2023 10,737,175 10,737,175 100.00 10,737,175 2/10/2025 133 4.50% FHLB 4.50% Aaa/AA+/-- 2/24/2023 5,000,000 4,993,830 99.98 4,998,885 2/13/2025 136 4.85% FHLB 4.69% Aaa/AA+/-- 2/15/2023 20,000,000 20,000,000 100.09 20,017,232 3/14/2025 165 4.69% Veritex Community Bank 5.12% 3/8/2024 5,130,448 5,130,448 100.00 5,130,448 4/8/2025 190 5.12% Treasury 2.63% Aaa/AA+/AA+ 2/24/2023 5,000,000 4,948,468 99.12 4,956,206 4/15/2025 197 4.65% American Nat'l Bank&Trust 4.50% 3/30/2023 10,697,608 10,697,608 100.00 10,697,608 4/28/2025 2101 4.50% Texas Bank 4.56% 6/15/2023 5,309,852 5,309,852 100.00 5,309,852 5/8/2025 220 4.56% American Nat'l Bank&Trust 4.50% 3/30/2023 10,680,522 10,680,522 100.00 10,680,522 5/15/2025 227 4.50% American Nat'l Bank&Trust 5.00% 1 11/24/2023 5,218,315 5,218,315 100.00 5,218,315 5/22/2025 234 5.00% American Nat'l Bank&Trust 5.00% 11/29/2023 5,214,028 5,214,028 100.00 5,214,028 5/29/2025 241 5.00% Texas Bank 4.56% 6/15/2023 3,185,911 3,185,911 100.00 3,185,911 6/12/2025 255 4.56% FHLB 4.75% Aaa/AA+/-- 7/7/2023 5,000,000 4,985,282 100.35 5,017,400 6/13/2025 256 5.19% American Nat'l Bank&Trust 4.56% 6/22/2023 8,480,599 8,480,599 100.00 8,480,599 6/19/2025 262 4.56% FHLB 4.75% Aaa/AA+/-- 6/22/2023 8,000,000 8,000,000 100.39 8,031,317 6/20/2025 263 4.75% FHLB 4.81% Aaa/AA+/-- 3/7/2024 5,000,000 5,000,000 100.44 5,021,964 7/7/2025 280 4.81% American Nat'l Bank&Trust 5.10% 1 9/14/2023 3,157,067 3,157,067 100.00 3,157,067 7/14/2025 287 5.10% FHLB 3.60% Aaa/AA+/-- 8/28/2023 500,000 493,925 99.54 497,699 7/18/2025 291 5.22% FHLMC 0.38% Aaa/AA+/AA+ 8/28/2023 5,000,000 4,820,735 97.09 4,854,364 7/21/2025 294 5.11% FFCB 4.88% Aaa/AA+/AA+ 8/16/2023 5,000,000 4,993,862 100.63 5,031,659 7/28/2025 301 5.03% American Nat'l Bank&Trust 5.10% 9/19/2023 5,261,778 5,261,778 100.00 5,261,778 8/19/2025 323 5.10% FAMC 5.18% 9/27/2023 10,000,000 10,000,000 100.90 10,090,248 8/27/2025 331 5.18% American Nat'l Bank&Trust 5.25% 11/9/2023 4,178,984 4,178,984 100.00 4,178,984 9/9/2025 344 5.25% Wallis Bank 5.30% 11/15/2023 6,241,898 6,241,898 100.00 6,241,898 9/15/2025 350 5.30% American Nat'l Bank&Trust 5.00% 12/7/2023 5,209,032 5,209,032 100.00 5,209,032 10/2/2025 367 5.00% American Nat'l Bank&Trust 4.90% 12/14/2023 5,199,879 5,199,879 100.00 5,199,879 10/9/2025 374 4.90% Treasury 5.00% Aaa/AA+/AA+ 4/25/2024 5,000,000 4,997,068 101.09 5,054,396 10/31/2025 396 5.06% TVA 0.00% Aaa/AA+/AA+ 1/19/2024 5,000,000 4,762,353 95.71 4,785,484 11/1/2025 397 4.61% TVA 0.00% Aaa/AA+/AA+ 1/30/2024 10,000,000 9,524,646 95.71 9,570,968 11/1/2025 397 4.61% FNMA 0.50% Aaa/AA+/AA+ 1/4/2024 10,000,000 9,585,887 96.35 9,635,150 11/7/2025 403 4.45% FHLB 4.75% Aaa/AA+/-- 2/5/2024 15,000,000 15,051,903 100.85 15,127,847 12/12/2025 438 4.44% FHLB 4.50% 1 Aaa/AA+/-- 2/14/2024 13,000,000 13,000,000 100.76 13,098,865 1/2/2026 459 4.50% 13 City of Round Rock Valley View Consulting,L.L.C. Holdings by Allocation and Portfolio Fund September 30, 2024 Coupon Settlement Face Amount/ Market Days to YTM @ Issuer Rate Credit Rating Date Shares Book Value price Market Value Maturity Date Maturity Book FHLB 4.70% Aaa/AA+/-- 2/26/2024 15,000,000 15,000,000 101.11 15,167,214 2/13/2026 501 4.70% FFCB 4.63% Aaa/AA+/AA+ 3/6/2024 20,000,000 20,013,781 101.05 20,209,794 3/5/2026 521 4.57% Cornerstone Capital Bank 4.50% 9/5/2024 12,038,505 12,038,505 100.00 12,038,505 3/5/2026 521 4.5016 Cornerstone Capital Bank 4.40% 9/26/2024 12,007,238 12,007,238 100.00 12,007,238 3/26/2026 542 4.4077- FAMC .40%FAMC 4.65% 4/22/2024 10,000,000 9,948,511 101.16 10,116,472 4/8/2026 555 5.01% FFCB 4.88% Aaa/AA+/AA+ 4/25/2024 10,000,000 9,986,109 101.60 10,160,018 4/15/2026 562 4.97% FAMC 4.95% 5/6/2024 10,000,000 10,000,000 101.73 10,172,805 5/6/2026 583 4.95% FFCB 4.75% Aaa/AA+/AA+ 5/9/2024 2,000,000 1,996,645 101.60 2,031,978 5/8/2026 585 4.86% FFCB 4.88% Aaa/AA+/AA+ 5/16/2024 3,000,000 3,005,063 101.76 3,052,687 5/15/2026 1 592 4.77% FHLB 4.88% Aaa/AA+/-- 6/6/2024 5,000,000 5,006,078 101.80 5,090,168 6/12/2026 1 620 4.79% FAMC 4.75% 6/21/2024 20,000,000 20,000,000 101.57 20,314,712 6/18/2026 1 626 4.75% Sub Total/Average 1 4.33% 514,701,454 513,308,144 100.11 515,293,342 1 2601 4.65% Fund 170-Interest&Sinking GO Bonds TexasDAILY 5.98% AAAm 4/30/2016 1 30,700 30,700 100.00 30,700 N/A 1 5.98% TexPool 5.16% AAAm 9/30/2015 1,288,678 1,288,678 100.00 1,288,678 N/A 1 5.16% Sub Total/Average 5.18% 1,319,378 1,319,378 100.00 1,319,378 11 5.18% Fund 466&467-2024 CO TexPool 5.16% AAAm 5/17/2024 16,903,607 16,903,607 100.00 16,903,607 N/A 1 5.16% Sub Total/Average 5.16% 16,903,607 16,903,607 100.00 16,903,607 1 5.16% Fund 551 -2024 LTN TexPool 5.16% AAAm 5/17/2024 8,154,993 8,154,993 100.00 8,154,993 N/A 1 5.16% Sub Total/Average 5.16% 8,154,993 8,154,993 100.00 8,154,993 1 5.16% Fund 591 -Reserves Fund TexPool 5.16% AAAm 9/30/2015 1 9,693 9,693 100.00 9,693 N/A 1 5.16% Sub Total/Average 5.16% 1 9,693 9,693 100.00 9,693 1 5.16% Fund 602-Interest&Sinking Revenue Bonds TexPool 5.16% AAAm 9/30/2015 1 2,679,548 2,679,548 100.00 2,679,548 N/A 1 5.16% Sub Total/Average 5.16% 1 2,679,548 2,679,548 100.00 1 2,679,548 1 5.16% Fund 604-2022 SIB Loan TexPool 5.16% AAAm 9/29/2022 2,969,111 2,969,111 100.00 2,969,111 N/A 1 5.16% American Nat'l Bank&Trust 0.35% 9/19/2023 678 678 100.00 678 N/A 1 0.35% American Nat'l Bank&Trust 5.18% 11/21/2022 22,059,544 22,059,544 100.00 22,059,544 N/A 1 5.187/. Sub Total/Average 5.18% 25,029,333 25,029,333 100.00 25,029,333 1 5.18% Fund 605-Kalahari Debt Service Reserve TexPool /o AAAm 8/30/2019 1 3,650,057 1 3,650,057 100.00 3,650,057 N/A 1 5.16% Sub Total/Average 5.16% 3,650,057 3,650,057 100.00 3,650,057 1 5.16% Total/Avera a 4.41% $ 572,448,063 $ 571,054,753 100.10 1 $ 573,039,951 2341 4.70% 14 City of Round Rock Valley View Consulting, L.L.C. ROUND ROCK BY THE NUMBERS FY 2025 Quarter I CitywideSales Tax, NetofIncentives Property Totals through Dac.2024=$26.OM $120,000,000 $49,000,000 $no,000,000 — $40,000,000 floo.000,000 $90,000,000 $35,000,000 58010001000 $30,000,000 $70,000,000 535,000,000 $601o0o,00o $50 000 000 $20,000,000 S401o001000 $15,000,000 $3o,00o,000 $20,000,000 $10,000,000 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sept �11..FY 2025 YTD Actuals FY 2024 YTD Actuals a FY 25 Actuals •FY 24 Actuals Other General • Revenues HOTi Venue Tax, Priorto Incentives $18,000,000 $1,200,000 $16,000,000 $1,000,000 $14,000,000 $12,000,000 - $800,000 $10,000,000 $600,000 $8,000,000 56,000,000 $400,000 $4,000,000 $200.000 $2.000.000 ..___... S $- Oct Non, Dee ]an Feb Mal Apr May ]un ]W Aug Sep Other TaaNa LlcenNe, 9eMce P"— FlMea cents c-1— F—cMee Feeepe1—Fee. cha aevenue F—uree Other FYZSOth.r Hotels eFYZSKalahari a FY 24 Other Hotels FY 24 Kalahari e FY2025YTDActuais •FY2024)TOAMals Comments Sales Tax Citywide sales tax collections,net of incentives,for the first quarter decreased 9.9%.Dell,net of incentives,with adjustments factored out,also decreased 5.9%. Note:The FY 2024 sales tax includes a$3.8 million amendment from November 2023,which corrects the FY 2023 sales tax. Property Tax - Most property tax collections occur November through February each year.Property tax collections are higher than the prior year due to the 8.6%tax rate increase for FY 2025 and new properties added. Other General Fund Revenues Other Taxes&Franchise fees decreased 15.9%due to a decline in mixed drink tax and cable franchise fees. License,Permits,and Fees increased 112.5%.Due to the nature and timing of development projects,revenues can fluctuate significantly from year to year.This quarter has seen an increase in building permits and subdivision development revenues. Fines and Forfeitures have increased 28.1%due to the growth in the number of cases fled. Grants have increased 213.8%.This quarter has received many large reimbursements for LA Wildfires,Hurricane Beryl,and severe weather deployments. Contracts and Other increased 25.4%due to higher interest earnings. Hotel Occupancy&Venue Tax Revenues for the first quarter are down 11.6%. The majority of Kalahari HOT tax revenues(7%)are used to pay debt and incentives per the agreement.Venue tax revenues(2%)from Kalahari are not part of the incentive agreement and stay in the Sports Center Fund. Water,Wastewater,and Stormwater revenues are trending as follows: Water revenue is up 8.2%from last year due to the adopted retail water rate increase effective November 2024. Wastewater and Stormwater are also trending above last year's first quarter revenues,8.3%and 9.3%respectively,due to the adopted rate increases. ROUND ROCK BY THE NUMBERS FY 2025 Annual Facts FY 2024 202S . Budget Revenues = $682.2 M .103 f1a.5 MI t1e.s Source Amount(In Mibm) Use of Fund Balance S 150.5 Bond Proceeds S 115.0 s,so.s .,F Sales Tax S 110.8 fQ/.a Property Tax S 91.2 Contracts&Other $ 82.3 $a- ..;. Utility&Garbage Charges $ 69.4 insa Other Taxes&Franchise Fees $ 18.9 Hotel Occupancy/Venue Tax $ 18.1 591.3 snos Fines,Permits&Fees $ 15.5 Program Revenues $ 10.5 FY 2024 2025 . Budget Expenses = $682.2 M Sss fs.o fsw ta.s tr.s ss.e sna Amount Amount fu.s Department (in Millions) Department (in Millions) fxo.a Capital Improvement Projects $ 307.6 Transportation $ 14.5 Debt Payments $ 49.4 Sports Management $ 11.1 Support Services $ 47.6 General Services $ 9.8 5iO''6 Police S 46.3 Fleet Replacement $ 7.8 Sao.e Utilities&Environmental Svcs S 41.8 Planning&Development $ 5.9 561'8 I♦ Funding Transfers Out S 40.8 Library S 5.4 w Fire $ 37.4 Communications $ 3.0 5463 u76 General Self Financed Const. $ 31.1 Com.&Neighborhood Srv. $ 2.5 s- Parks Parks&Recreation $ 20.2 Other CORR Tax Information Taxing Entities Top 10 Property Tax Payers FY 24-25 FY 23-24 Entity Rate Assessed Value Population 136,383 134,540 City of Round Rock $ 0.3600 Business On mllllom) Property Tax Rate $ 0.36000 $ 0.34200 Williamson County&FM/RM 0,3999 Kalahari Resorts $ 547.8 M&00254602 Debt 0.105398 Round Rock ISD 0.8931 Dell Computer Holdings LP 468.5 Austin Community College 0.1013 CPG RR,LP(Round Rock outlets) 163.7 Outstanding Debt as of 10/01/24 Upper Brushy Creek WCID 0.0170 TX Essential Housing(lakeside at tl7 151.1 Amount O/5 Total Tax Rab $1,7713 CMF 15 Port,LLC(Colonial Grand Apts) 144.6 Bond On Millions) Dell Computer Corp 141.8 GO&CO Bonds $ 314.8 Taxable Values Columbia/SL Davids Healthcare 119.6 Limited Tax Notes $ 10.9 FY 24-25 FY 23-24 Oncor Electric Delivery Company 92.9 Utility/Stormwater $ 138.2/4.9 Median Home Values $ 376,169 $ 363,396 2811 La Frontera LP(District of v Frontera Apu) 89.6 HOT $ 6.0 Taxable Property Value On billions) $ 25.3 $ 24.1 TMP Parkside LLC(Parkside 0 RR) 83.5 Type B $ 64.1 City Employees Bond Ratings(Rated by S&P) Sworn FTEs Total FTS GO Bonds AAA City Wide 1,203 Utility Bonds AAA Police 210 297 Fire 175 201