Loading...
R-2024-192 - 8/8/2024 RESOLUTION NO. R-2024-192 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 June 30, 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 8th day of August, 2024. CRAIGIAORGW, Mayor City of Round 106ck, Texas ATTEST: At'% I J0 MEAGAN S ity Clerk 0112.20242:4861-1540-8339 EXHIBIT "A„ r' ROUND ROCK TEXA FINANCE QUARTERLY INVESTMENT REPORT For the Quarter Ended June 30, 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 Valley Vie Co suiting, 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) June 30, 2024 YTM @ Description Cost Book Value Market Value Cash 0.35% $ 8,695,963 $ 8,695,963 Certificates of Deposit 4.75% 113,959,255 113,959,255 Local Government Investment Pool 5.32% 122,773,560 122,773,560 Money Market Accounts 5.54% 62,548,929 62,548,929 US Agency 4.520/6 290,317,138 289,491,641 US Treasury 4.50% 24,848,286 24,803,552 Total/Average 4.76% $ 623,143,132 $ 622,272,900 March 31,2024 YTM @ Description Cost Book Value Market Value Cash 0.23% $ 8,187,561 $ 8,187,561 Certificates of Deposit 4.75% 123,073,507 123,073,507 Local Government Investment Pool 5.33% 82,224,084 82,224,084 Money Market Accounts 5.54% 61,691,493 61,691,493 US Agency 4.23% 266,089,242 1 265,138,982 US Treasury 3.52% 36,722,218 1 36,583,757 Total/Average 4.53% $ 577,988,105 $ 576,899,384 Average Yield Current Fiscal Year- Quarter(1) to-Date(2) Total Portfolio 4.76% 4.51% TexPool Yield 5.31% 5.33% Rolling Three Mo. Treas. Yield 5.47% 5.48% Rolling Six Mo. Treas. Yield 5.34% 5.40% Rolling 1 Yr.Treas. Yield 5.16% 5.12% Rolling 2 Yr.Treas. Yield 4.43% 4.13% Investment Income(3) Interest Income(Approximate) $ 6,865,329 $ 18,109,793 WAM at 6/30/2024 Policy WAM Max Total Portfolio 253 days 540 days Pooled Funds 312 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 6/30/2024 The Federal Open Market Committee(FOMC)maintained the Fed Funds target range 5.25%-5.50%(Effective Fed Funds are trading+/-5.33%). Expectations are for reduced future rates, but any actions will be meeting-by-meeting and"data-dependent." June Non-Farm Payroll slightly exceeded expectations at 206k new jobs, but the previous two months were revised down causing the Three Month Rolling Average to fall to 177k. Final First Quarter 2024 GDP reported+1.4%. The S&P 500 Stock Index created new highs above+/-5,500. The yield curve remains inverted but longer yields rose slightly. Crude Oil trades over$80 per barrel. Inflation declined slighted but remains above the FOMC 2%target(Core PCE+/-2.6%and Core CPI+/-3.4%). Reduced global economic outlooks and ongoing/expanding military conflicts continue increasing uncertainty. 6.00 Treasury Yield Curves S&P 500 s,000 5,750 - - 5,500 - 5.00 - 5,250 5,000 Aff 4,750 4,500 4.00 4,250 4,000 3,750 3.00 - - - - --- 3 250 3,000 -- - 2,750 2.00 2,500 - --- 2,250 2,000 1,750 1.00 1,500 1,250 1:050 0.00 500 O Q Q Q Q- Q 250 9 h �O �a1 baa jai baa �a� �a� jai baa �a� baa �a� June 30,2023 March 31,2024 ---June 30,2024 6.00 US Treasury Historical Yields -Since 2006 500 US Treasury Historical Yields -Since Nov 2016 5.50 - - 5.50 5.00JL0TPA5.00 e.� 4.50111 .2 4.50Avow 4.00 4.00 3.503.50 3.00Be 1 re - 3.00 - 2.50111f I Aft 2.50 -1 AM 2.00 Ual 2.00 1.50 41 / 1.50 1.00 • , 1.00 o - 0.50 • 0.50 0.00 0.00 Sf°S�°A�A1A�A$0°jA°'�010�`1`1 X13 S.a1A15 616�0�11�.89 ;�;y`ti`"I 'aan; 1,�0 J16 ^1 ,11 1S J16 19 J^9 yo X30 1� Jy, yL Jya y� �L' LA �c��,ao �o 1' •Sbc Month T43111 Two Year T-Note amomme, Tan Year T-Note -Six Month T-6111 Two Year T-Nota Ten Year T-Note Valley View Consulting,L.L.C. 2 Holdings by Investment Category June 30, 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 $ 8,695,963 1% $ - 0% $ - 0% $ - 0% $ 8,695,963 1% Certificates of Deposit 113,959,255 18°% - 0% - 0% - 0% 113,959,255 18% Investment Pools 28,409,217 5% 25,831,263 41/. 7,048,083 1% 61,484,998 10% 122,773,560 20°% Money Market Accounts 38,066,399 6% - 0°% 947,159 0% 23,535,370 4°% 62,548,929 10% Municipal - 0°% - 0% - 0°% - 0% - 0°% US Agency 290,317,138 47°% 0% - 0% - 0% 290,317,138 47% US Treasury 24,848,286 4% 0°% - 0% - 0% 24,848,286 4°% Total/Average $504,296,259 81% $ 25,831,263 4% $ 7,995,242 1% $ 85,020,368 14% $623,143,132 100% Portfolio Balances (Millions) Order of Liquidity $600 ■Cash $500 o Local Government Investment Pool $400 ■Money Market Account $300 ■US Treasury $200 0 U Agency ❑Municipal $100 W Certificates of Deposit Pooled Funds DS Funds DSR Funds CP&SP Funds Total Portfolio 6/30/2024 6130/2024 6/30/2024 6/30/2024 6/30/2024 3 City of Round Rock Valley View Consulting,L.L.C. Investment Holdings by Investment Category Quarterly Transactions By Investment Category June 30,2024 June 30, 2024 %of Portfolio Net Cash Equivalent Description Book Value Portfolio Limitation Description Buys Sells Maturities Calls Interest DeposiU(Withdrawal) Cash $ 8,695,963 1 A% 100% Cash $ — $ — $ — $ — $ 33,006 $ 508,402 Investment Pools 122,773,560 19.7% 100% Investment Pools — — — — 1,306,572 40,549,476 Money Market Accounts 62,548,929 10.0% 75% Money Markets Accounts — — — — 857,435 857,435 Certificates of Deposit 113,959,255 18.3% 85% Certificates of Deposit 1,340,002 — 10,454,253 — 1,383,065 — Commercial Paper — 0.0% 10%/5% Commercial Paper — — — — — Municipal — 0.0% 35%/5% Municipal — I — — — — — US Agency 290,317,138 466% 85% US Agency 59,977,656 — 36,051,000 — 1,816,669 — US Treasury24,848,286 4.0% 85% US Treasury5,117,464 — 17,000,000 — 406,250 1 — Total/Average $ 623,143,132 100% PASSED Totals S 66,435,122 1 $ — $ 63,505,253 $ — $ 5,802,997 1 $ 41,915,314 Portfolio Balances (Millions) Portfolio Composition Order of Liquidity June 30,2024 Money Market Accounts 10.0% Certificates of $600 Deposit ■Cash -- $500 $500 Investment Pools El Local Government 19.7% z Investment Pool $400 o Money Market Account / $300 — ■US Treasury Cash 1.4% $200 — 0 U Agency US Treasury 4.0% $100 o Municipal $0 sCertificates of Deposit t* b KV US Agency 46.6% 4 City of Round Rock Valley View Consulting,L.L.C. City of Round Rock Pooled Funds Performance 5.50 -- T 5.00 I 4.50 - -- - -- 4.00 - / 3.50 ca c 3.00 -- (D p L LL 2.50 - - -- - 2.00 1.50 1.00 - ` _ Ids , ` / 0.50 low - •% 0.00 h ,�h �o �.`O �6 �o ,�A ,�1 ,�A ,�A ,�b �o ,�% �� �o �o �o ,�0 0 0 0 0 �. `L ti ti 3 3 0 3 a 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0`� o`� o`f o`� o`r o`� o`� o`� o`� o`0 "fcc "o`I o`I o`� o`� o`I o`I 1\`� N' I o�`� 1�ti I\`� Z\, IZ\, I�`� 'I�`� o\`p &rV �,�`� Nati o�ti 0�� ��`� '��`� o�`� o�`� ��`� ��ti o�ti o�ti 'N\' ��� o\ti o\ti ��ti 'N�7 o�ti opo��3 0�0 0�� opo�tio opo opo opo�tio opo opo opo�tio '\o 0\3 0�3��o opo opo 0�3^tio opo opo 0�3^tio opo opo 5p opo 0�3 0�3^tio opo opo 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 i ❑Debt Service Reserve Funds $300 ❑Debt Service Funds $200 $100 ■Pooled Funds $0 O^y Ooh O^6 O^6 0�6 OHO Off^ O^^ 0�1 O^1 OHO O^O O�`O p�� O�`O O�`O p�`O OHO O`t° 01° p1° O`tO p1^ pti^ p1^ 01^ ptiry ptiry Otiry O'1� p'ti� p'�� p`1� O'ti� p'�b p'�b 6 City of Round Rock Valley View Consulting,L.L.C. Holdings by Allocation and Portfolio Fund June 30, 2024 Coupon Settlement Face Amount/ Book Days to YTM @ Issuer Rate Credit Rating Date Shares Book Value Price Market Value Maturity Date Maturity Book Fund 000-Pooled Investments NexBank 5.55% 11/29/2016 $ 23,666,714 $ 23,666,714 100.00 $ 23,666,714 N/A 1 5.55% TexasDAILY 5.31% AAAm 6/1/2021 2,657 2,657 100.00 2,657 N/A 1 5.31% TexasDAILY Select 5.44% AAAm 12/3/2021 5,501,034 5,501,034 100.00 5,501,034 N/A 1 5.44% Veritex Community Bank 5.33% 9/1/2020 207,506 207,506 100.00 207,506 N/A 1 5.33% JPMor an Chase 0.35% 9/30/2015 8,695,963 8,695,963 100.00 8,695,963 N/A 1 0.35% TexSTAR 5.31% AAAm 9/30/2015 219,747 219,747 100.00 219,747 N/A 1 5.31% TexPool 5.31% AAAm 9/30/2015 20,204,064 20,204,064 100.00 20,204,064 N/A 1 5.31% NexBank 5.55% 1/13/2023 14,192,180 14,192,180 100.00 14,192,180 N/A 1 5.55% TexasDAILY 5.31% AAAm 9/30/2015 2,481,714 2,481,714 100.00 2,481,714 N/A 1 5.31% FFCB 3.15% Aaa/AA+/AA+ 7/15/2022 10,000,000 10,000,092 99.91 9,990,640 7/15/2024 15 3.13% Treasury 1.75% Aaa/AA+/AA+ 9/29/2022 10,000,000 9,980,365 99.71 9,971,173 7/31/2024 31 4.18% FFCB 3.38% Aaa/AA+/AA+ 8/31/2022 23,500,000 23,494,126 99.67 23,422,079 8/26/2024 57 3.54% FFCB 3.50% Aaa/AA+/AA+ 9/16/2022 20,000,000 19,981,598 99.60 19,920,840 9/13/2024 75 3.97% FHLB 4.50% Aaa/AA+/-- 11/1/2022 3,000,000 2,998,818 99.74 2,992,275 10/3/2024 95 4.66% FHLB 4.50% Aaa/AA+/-- 11/1/2022 2,000,000 1,999,212 99.74 1,994,850 10/3/2024 95 4.66% Treasury 0.63% Aaa/AA+/AA+ 12/13/2022 5,000,000 4,947,132 98.63 4,931,416 10/15/2024 107 4.43% FFCB 4.38% Aaa/AA+/AA+ 10/17/2022 7,000,000 7,000,119 99.69 6,978,467 10/17/2024 109 4.37% FHLB 4.53% Aaa/AA+/-- 12/14/2022 15,000,000 15,000,000 99.68 14,951,463 11/18/2024 141 4.53% Texas Capital Bank 4.71% 1/19/2023 5,344,507 5,344,507 100.00 5,344,507 12/13/2024 166 4.71% Independent Financial Bank 4.50% 1/31/2023 10,564,239 10,564,239 100.00 10,564,239 12/31/2024 184 4.50% Independent Financial Bank 4.50% 1/31/2023 5,282,119 5,282,119 100.00 5,282,119 1/31/2025 215 4.50% American Nat'l Bank&Trust 4.50% 2/10/2023 10,616,304 10,616,304 100.00 10,616,304 2/10/2025 225 4.50% FHLB 4.50% Aaa/AA+/-- 2/24/2023 5,000,000 4,989,656 99.52 4,976,155 2/13/2025 228 4.85% FHLB 4.69% Aaa/AA+/-- 2/15/2023 20,000,000 20,000,000 99.60 19,919,002 3/14/2025 257 4.69% Veritex Community Bank 5.12% 3/8/2024 5,064,804 5,064,804 100.00 5,064,804 4/8/2025 282 5.12% Treasury 2.63% Aaa/AA+/AA+ 2/24/2023 5,000,000 4,924,402 98.02 4,901,173 4/15/2025 289 4.65% American Nat'l Bank&Trust 4.50% 3/30/2023 10,575,884 10,575,884 100.00 10,575,884 4/28/2025 302 4.50% Texas Bank 4.56% 6/15/2023 5,244,114 5,244,114 100.00 5,244,114 5/8/2025 312 4.56% American Nat'l Bank&Trust 4.50% 3/30/2023 10,560,288 10,560,288 100.00 10,560,288 5/15/2025 319 4.50% American Nat'l Bank&Trust 5.00% 11/24/2023 5,152,968 5,152,968 100.00 5,152,968 5/22/2025 326 5.00% American Nat'l Bank&Trust 5.00% 11/29/2023 5,148,693 5,148,693 100.00 5,148,693 5/29/2025 333 5.00% Texas Bank 4.56% 6/15/2023 3,146,468 3,146,468 100.00 31146,468 6/12/2025 347 4.56% FHLB 4.75% Aaa/AA+/-- 7/7/2023 5,000,000 4,979,992 99.65 4,982,590 6/13/2025 348 5.19% American Nat'l Bank&Trust 4.56% 6/22/2023 8,383,690 8,383,690 100.00 8,383,690 6/19/2025 354 4.56% FHLB 4.75% Aaa/AA+/-- 6/22/2023 8,000,000 8,000,000 99.69 7,975,013 6/20/2025 355 4.75% FHLB 4.81% Aaa/AA+/-- 3/7/2024 5,000,000 5,000,000 99.69 4,984,327 7/7/2025 372 4.81% American Nat'l Bank&Trust 5.10% 9/14/2023 3,116,828 3,116,828 100.00 3,116,828 7/14/2025 379 5.10% FHLB 3.60% Aaa/AA+/-- 8/28/2023 1 500,000 492,004 98.47 1 492,359 7/18/2025 383 5.22% FHLMC 0.38% Aaa/AA+/AA+ 8/28/2023 5,000,000 4,764,638 95.27 4,763,562 7/21/2025 386 5.11% FFCB 4.88% Aaa/AA+/AA+ 8/16/2023 5,000,000 4,991,985 99.71 4,985,312 7/28/2025 393 5.03% American Nat'l Bank&Trust 5.10% 9/19/2023 5,194,714 5,194,714 100.00 5,194,714 8/19/2025 415 5.10% FAMC 5.18% 9/27/2023 10,000,000 10,000,000 100.09 10,009,488 8/27/2025 423 5.18% American Nat'l Bank&Trust 5.25% 11/9/2023 4,124,169 4,124,169 100.00 4,124,169 9/9/2025 436 5.25% Wallis Bank 5.30% 11/15/2023 6,159,612 6,159,612 100.00 6,159,612 9/15/2025 442 5.30% American Nat'l Bank&Trust 5.00% 12/7/2023 5,143,800 5,143,800 100.00 1 5,143,800 10/2/2025 459 5.00% American Nat'l Bank&Trust 4.90% 12/14/2023 5,136,056 5,136,056 100.00 5,136,056 10/9/2025 466 4.90% Treasury 5.00% Aaa/AA+/AA+ 4/25/2024 5,000,000 4,996,387 100.00 4,999,791 10/31/2025 488 5.06% TVA 0.00% Aaa/AA+/AA+ 1/19/2024 5,000,000 4,707,281 93.61 4,680,275 11/1/2025 489 4.61% 7 City of Round Rock Valley View Consulting,L.L.C. Holdings by Allocation and Portfolio Fund June 30, 2024 Coupon Settlement Face Amount/ Book Days to YTM @ Issuer Rate Credit Rating Date Shares Book Value Price Market Value Maturity Date Maturity Book TVA 0.00% Aaa/AA+/AA+ 1/30/2024 10,000,000 9,414,489 93.61 9,360,549 11/1/2025 489 4.61% FNMA 0.50% Aaa/AA+/AA+ 1/4/2024 10,000,000 9,491,349 94.17 9,417,490 11/7/2025 495 4.45% FHLB 4.75% Aaa/AA+/-- 2/5/2024 15,000,000 15,062,805 99.69 14,953,262 12/12/2025 530 4.44% FHLB 4.50% Aaa/AA+/-- 2/14/2024 13,000,000 13,000,000 99.42 12,924,522 1/2/2026 551 4.50% FHLB 4.70% Aaa/AA+/-- 2/26/2024 15,000,000 15,000,000 99.69 14,954,169 2/13/2026 593 4.70% FFCB 4.63% Aaa/AA+/AA+ 3/6/2024 20,000,000 20,016,214 99.59 19,917,104 3/5/2026 613 4.57% FAMC 4.65% 4/22/2024 10,000,000 9,939,976 99.56 9,956,442 4/8/2026 647 5.01% FFCB 4.88% Aaa/AA+/AA+ 4/25/2024 10,000,000 9,983,835 100.06 10,005,873 4/15/2026 654 4.97% FAMC 4.95% 5/6/2024 10,000,000 10,000,000 100.12 10,011,655 5/6/2026 675 4.95% FFCB 4.75% Aaa/AA+/AA+ 5/9/2024 2,000,000 1,996,118 99.89 1,997,806 5/8/2026 677 4.86% FFCB 4.88% Aaa/AA+/AA+ 5/16/2024 1 3,000,000 3,005,850 100.15 1 3,004,412 1 5/15/2026 6841 4.77% FHLB 4.88% Aaa/AA+/-- 6/6/2024 5,000,000 5,006,980 100.15 5,0071711 6/12/2026 7121 4.79% FAMC 4.75% 6/21/2024 20,000,000 20,000,000 99.81 19,961,952 6/18/2026 718 4.75% Sub Total I Average 1 4.22% 506,130,834 504,296,259 99.47 503,426,027 312T 4.62% Fund 170-Interest&Sinking GO Bonds TexasDAILY 5.31% AAArn 4/30/2016 30,298 1 30,298 100.00 30,298 N/A 1 5.31% TexPool 5.31% AAArn 9/30/2015 21,329,566 1 21,329,566 100.00 21,329,566 N/A 1 5.31% Sub Total I Average 5.31% 21,359,864 1 21,359,864 1 100.00 21,359,864 1 1 5.31% Fund 462-2017 Bond Fund TexPool 5.31% AAArn 5/30/2017 2,274,623 1 2,274,623 100.00 2,274,623 N/A 1 5.31% NexBank 5.55% 3/30/2020 1,778,081 1 1,778,081 100.00 1,778,081 N/A 11 5.55% Sub Total/Average 5.42% 4,052,704 1 4,052,704 100.00 4,052,704 11 5.42% Fund 463-2024 GO TexPool 5.31% AAArn 5/17/2024 20,122,849 1 20,122,849 100.00 20,122,849 N/A 1 5.31% Sub Total I Average 5.31% 20,122,849 1 20,122,849 100.00 20,122,849 1 5.31% Fund 465-Road CO Bond Fund TexPool 5.31% AAArn 9/1/2020 7,986,970 7,986,970 100.00 7,986,970 N/A 1 5.31% Sub Total/Average 5.31% 7,986,970 7,986,970 100.00 1 7,986,970 1 5.31% Fund 466&467-2024 CO TexPool 5.31% AAArn 1 5/17/2024 1 20,122,659 1 20,122,659 100.00 1 20,122,659 N/A 1 5.31% Sub Total I Average 5.31% 1 1 20,122,659 1 20,122,659 100.00 1 20,122,659 1 5.31% Fund 551 -2024 LTN TexPool 5.31% AAArn 1 5/17/2024 1 8,047,810 1 8,047,810 100.00 1 8,047,810 N/A 1 5.31% Sub Total/Average 5.31% 8,047,810 1 8,047,810 100.00 1 8,047,810 1 5.31% Fund 591 -Reserves Fund TexPool 5.31% AAArn 1 9/30/2015 1 9,565 1 9,565 1 100.00 1 9,565 1 N/A 1 1 5.31% NexBank 5.55% 4/29/2019 1 947,159 947,159 1 100.00 947,159 1 N/A 1 5.55% Sub Total/Average 5.55% 1 956,725 956,725 1 100.00 956,725 11 5.55% Fund 602-Interest&Sinking Revenue Bonds TexPool 5.31% AAArn 9/30/2015 4,471,399 4,471,399 1 100.00 4,471,399 1 N/A 1 5.31% Sub Total I Average 5.31% 4,471,399 4,471,399 1 100.00 4,471,399 1 1 5.31% Fund 604-2022 SIB Loan TexPool 5.31% AAArn 1 9/29/2022 2,930,087 2,930,087 100.00 2,930,087 N/A 1 5.310/ 8 City of Round Rock Valley View Consulting,L.L.C. Holdings by Allocation and Portfolio Fund June 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 American Nat'l Bank&Trust 0.35% 9/19/2023 678 678 10000 678 N/A 1 0.35% American Nat'l Bank&Trust 5 51% 11/21/2022 21,756,611 21,756,611 10000 21,756,611 N/A 1 5.51% Sub Total/Average 5.49% 24,687,376 24,687,376 100.00 24,687,376 1 5.49% Fund 605-Kalahari Debt Service Reserve TexPool 5.31% AAAm 1 8/30/2019 1 7,038,518 7,038,518 1 100.00 7,038,518 1 N/A 11 5.31% Sub Total/Average 5.31% 1 1 7,038,518 7,038,518 100.00 7,038,518 1 11 5.31% Total/Average 4.43%/0 1 1 $ 624,977,707 $ 623,143,132 99.57 $ 622,272,900 1 2531 4.76% 9 City of Round Rock Valley View Consulting,L.L.C. Book Value Comparison June 30, 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 $ 8,187,561 $ 14,704,255 $ 14,195,853 $ 8,695,963 $ 508,402 TexPool N/A 9/30/2015 N/A 35,370,459 2,146,382 17,312,777 20,204,064 15,166,395 TexSTAR N/A 9/30/2015 N/A 216,864 2,883 - 219,747 2,883 TexasDAILY N/A 9/30/2015 N/A 2,449,279 32,435 - 2,481,714 32,435 TexasDAILY N/A 6/1/2021 N/A 2,622 35 - 2,657 35 TexasDAILY Select N/A 12/3/2021 N/A 5,427,363 73,672 - 5,501,034 73,672 NexBank N/A 11/29/2016 N/A 22,831,752 834,962 - 23,666,714 834,962 Veritex Community Bank N/A 9/1/2020 N/A 204,773 2,733 - 207,506 2,733 NexBank N/A 1/13/2023 N/A 14,506,704 197,261 511,785 14,192,180 314,525 FAMC 2.58% 4/18/2022 4/18/2024 10,000,000 - 10,000,000 - 10,000,000 Treasury 2.25% 3/30/2022 4/30/2024 9,998,508 - 10,000,000 - 9,998,508 FAMC 2.65% 5/9/2022 5/2/2024 2,999,806 - 3,000,000 - 2,999,806 FFCB 2.63% 6/2/2022 5/3/2024 3,050,879 - 3,051,000 - 3,050,879 Treasury 2.50% 6/2/2022 5/31/2024 1 6,998,215 - 7,000,000 - 6,998,215 FHLB 3.13°/ 6/23/2022 6/14/2024 19,999,470 - 20,000,000 - 19,999,470 FFCB 3.15% 7/15/2022 7/15/2024 10,000,649 - - 10,000,092 558 Treasury 1.75% 9/29/2022 7/31/2024 9,922,727 - - 9,980,365 57,638 FFCB 3.38% 8/31/2022 8/26/2024 23,484,748 - - 23,494,126 9,378 FFCB 3.50% 9/16/2022 9/13/2024 19,959,270 - - 19,981,598 22,328 FHLB 4.50% 11/1/2022 10/3/2024 1,998,457 - - 1,999,212 755 FHLB 4.50% 11/1/2022 10/3/2024 2,997,686 - 2,998,818 1,132 Treasury 0.63°% 12/13/2022 10/15/2024 4,902,169 - - 4,947,132 44,963 FFCB 4.38% 10/17/2022 10/17/2024 7,000,218 - - 7,000,119 99 FHLB 4.53% 12/14/2022 11/18/2024 15,000,000 - - 15,000,000 - Texas Capital Bank 4.71% 1/19/2023 12/13/2024 5,281,544 62,962 - 5,344,507 62,962 Independent Financial Bank 4.50% 1/31/2023 12/31/2024 10,448,619 115,620 - 10,564,239 115,620 Independent Financial Bank 4.50°% 1/31/2023 1/31/2025 1 5,224,309 57,810 - 5,282,119 57,810 American Nat'l Bank&Trust 4.50°% 2/10/2023 2/10/2025 10,496,793 119,510 - 10,616,304 119,510 FHLB 4.50% 2/24/2023 2/13/2025 4,985,527 - - 4,989,656 4,129 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,000,000 64,804 - 5,064,804 64,804 Treasury 2.63% 2/24/2023 4/15/2025 4,900,598 - - 4,924,402 23,804 American Nat'l Bank&Trust 4.50°% 3/30/2023 4/28/2025 10,458,113 117,771 - 10,575,884 117,771 Texas Bank 4.56% 6/15/2023 5/8/2025 5,184,901 59,213 - 5,244,114 59,213 American Nat'l Bank&Trust 4.50°% 3/30/2023 5/15/2025 10,441,409 118,880 - 10,560,288 118,880 American Nat'l Bank&Trust 5.00°% 11/24/2023 5/22/2025 5,089,135 63,832 - 5,152,968 63,832 American Nat'l Bank&Trust 5.00°% 11/29/2023 5/29/2025 5,084,954 63,738 - 5,148,693 63,738 Texas Bank 4.56% 6/15/2023 6/12/2025 3,110,940 35,528 - 3,146,468 35,528 FHLB 4.75°% 7/7/2023 6/13/2025 4,974,761 - - 4,979,992 5,232 American Nat'l Bank&Trust 4.56°% 6/22/2023 6/19/2025 8,288,923 94,767 - 8,383,690 94,767 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,077,103 39,725 - 3,116,828 39,725 FHLB 3.60% 8/28/2023 7/18/2025 490,104 - - 492,004 1,900 FHLMC 0.38% 8/28/2023 7/21/2025 4,709,151 - - 4,764,638 55,487 FFCB 4.88% 8/16/2023 7/28/2025 4,990,129 - - 4,991,985 1,856 American Nat'l Bank&Trust 5.10°% 9/19/2023 8/19/2025 5,128,505 66,209 - 5,194,714 66,209 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,070,072 54,097 - 4,124,169 54,097 Wallis Bank 5.30% 11/15/2023 9/15/2025 6,080,153 79,458 - 6,159,612 79,458 American Nat'l Bank&Trust 5.00% 12/7/2023 10/2/2025 5,080,081 63,719 - 5,143,800 63,719 American Nat'l Bank&Trust 4.90°% 12/14/2023 1 10/9/2025 5,073,697 62,359 - 5,136,056 62,359 10 City of Round Rock Valley View Consulting, L.L.C. Book Value Comparison June 30, 2024 Issuer Coupon Settlement Maturity Beginning Book Total Buys/ Total Sells/ Ending Book Change in Book Rate Date Date Value Increases Decreases Value Value Treasury 5.00% 4/25/2024 10/31/2025 - 5.117,464 - 4,996,387 4,996,387 TVA 0.00°% 1/30/2024 11/1/2025 9,305,529 - - 9,414,489 108,960 TVA 0.00°% 1/19/2024 11/1/2025 4,652,807 - - 4,707,281 54,473 FNMA 0.50°% 1/4/2024 11/7/2025 9,397,840 - - 9,491,349 93,509 FHLB 4.75% 2/5/2024 12/12/2025 15,073,589 - - 15,062,805 10,784 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,018,621 - - 20,016,214 2,407 FAMC 465% 4/22/2024 4/8/2026 - 9,951,658 - 9,939,976 9,939,976 FFCB 4.88% 4/25/2024 4/15/2026 - 9,995,746 - 9,983,835 9,983,835 FAMC 4.95°% 5/6/2024 5/6/2026 - 10,000,000 - 10,000,000 10,000,000 FFCB 4.75°% 5/9/2024 5/8/2026 - 1,996,083 - 1,996,118 1,996,118 FFCB 4.88°% 5/16/2024 5/15/2026 - 3,006,641 - 3,005,850 3,005,850 FHLB 4.88°% 6/6/2024 6/12/2026 - 5,027,528 - 5,006,980 5,006,980 FAMC 4.75°% 6/21/2024 6/18/2026 - 20,000,000 - 20,000,000 20,000,000 Sub Total/Average Fund 000-Pooled Investments 504,628,091 84,429,740 85,071,416 504,296,259 331,832 Fund 170-Interest&Sinking GO Bonds TexPool N/A 9/30/2015 N/A 20,740,630 588,936 - 21,329,566 588,936 TexasDAILY N/A 4/30/2016 N/A 29,902 396 30,298 396 Sub Total/Average Fund 170-Interest&Sinking GO Bonds 20,770,532 589,332 - 21,359,864 589,332 Fund 462-2017 Bond Fund TexPool N/A 5/30/2017 N/A 2,244,751 29,872 - 2,274,623 29,872 NexBank N/A 3/30/2020 N/A 1,753,801 24,280 - 1,778,081 24,280 Sub Total/Average Fund 462-2017 Bond Fund 3,998,552 54,152 - 4,052,704 54,152 Fund 463-2024 GO TexPool N/A 5/17/2024 N/A - 20,122,849 - 20,122,849 20,122,849 Sub Total/Average Fund 463-2024 GO - 20,122,849 - 20,122,849 20,122,849 Fund 465-Road CO Bond Fund TexPool N/A 9/1/2020 N/A 2,997,869 1 4,989,101 - 7,986,970 4,989,101 American Nat'l Bank&Trust 4.85% 4/10/2023 4/10/2024 10,454,253 - 10,454,253 - 10,454,253 Sub Total/Average Fund 465-Road CO Bond Fund 13,452,123 4,989,101 10,454,253 7,986,970 5,465,153 Fund 466&467-2024 CO TexPool N/A 5/17/2024 N/A - 20,122,659 - 20,122,659 20,122,659 Sub Total/Average Fund 466&467-2024 CO - 20,122,659 - 20,122,659 20,122,659 Fund 551 -2024 LTN TexPool N/A 5/17/2024 N/A - 8,047,810 - 8,047,810 8,047,810 Sub Total/Average Fund 551 -2024 LTN - 8,047,810 - 8,047,810 8,047,810 Fund 591 -Reserves Fund TexPool N/A 9/30/2015 N/A 9,440 126 - 9,565 126 NexBank N/A 4/29/2019 N/A 934,226 12,934 - 947,159 12,934 Sub Total/Average Fund 591 -Reserves Fund 943,665 13,059 - 956,725 13,059 Fund 602-Interest&Sinking Revenue Bonds TexPool N/A 9/30/2015 N/A 4,534,108 59,741 122,450 4,471,399 62,709 Sub Total/Average Fund 602-Interest&Sinking Revenue Bonds 4,534,108 59,741 1 122,450 4,471,399 62,709 Fund 604-2022 SIB Loan TexPool N/A 9/29/2022 N/A 2,891,607 38,480 1 - 2,930,087 38,480 11 City of Round Rock Valley View Consulting, L.L.C. Book Value Comparison June 30, 2024 Issuer Coupon Settlement Maturity Beginning Book Total Buys/ Total Sells/ Ending Book Change in Book Rate Date Date Value Increases Decreases Value Value American Nat'l Bank&Trust N/A 9/19/2023 N/A 677 1 678 1 American Nat'l Bank&Trust N/A 11/21/2022 N/A 21,459,561 297,051 21,756,611 297,051 Sub Total/Average Fund 604-2022 SIB Loan 24,351,845 335,531 — 24,687,376 335,531 Fund 605-Kalahari Debt Service Reserve Tex Pool N/A 8/30/2019 N/A 1 5,309,190 1,729,328 1 7,038,518 1,729,328 Sub Total/Average Fund 605-Kalahari Debt Service Reserve 5,309,190 1,729,328 — 7,038,518 1,729,328 Total/Average $ 577,988,105 $ 140,493,302 $ 95,648,119 $ 623,143,132 $ 3,138,291 12 City of Round Rock Valley View Consulting,L.L.C. Market Value Comparison June 30, 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 $ 8,187,561 $ 14,704,255 $ 14,195,853 $ 8,695,963 $ TexPool N/A 9/30/2015 N/A 35,370,459 2,146,382 17,312,777 20,204,064 - TexSTAR N/A 9/30/2015 N/A 216,864 2,883 - 219,747 - TexasDAILY N/A 9/30/2015 N/A 2,449,279 32,435 - 2,481,714 - TexasDAILY N/A 6/1/2021 N/A 2,622 35 - 2,657 - TexasDAILY Select N/A 12/3/2021 N/A 5,427,363 73,672 - 5,501,034 - NexBank N/A 11/29/2016 N/A 22,831,752 834,962 - 23,666,714 - Veritex Community Bank N/A 9/1/2020 N/A 204,773 2,733 - 207,506 - NexBank N/A 1/13/2023 N/A 14,506,704 197,261 511,785 14,192,180 - FAMC 2.58% 4/18/2022 4/18/2024 9,983,877 - 10,000,000 - 16,123 Treasury 2.25% 3/30/2022 4/30/2024 9,975,650 - 10,000,000 - 24,350 FAMC 2.65% 5/9/2022 5/2/2024 2,992,183 - 3,000,000 - 7,817 FFCB 2.63% 6/2/2022 5/3/2024 3,042,754 - 3,051,000 - 8,246 Treasury 2.50% 6/2/2022 5/31/2024 6,966,129 - 7,000,000 - 33,871 FHLB 3.13% 6/23/2022 6/14/2024 19,902,708 - 20,000,000 - 97,292 FFCB 3.15% 7/15/2022 7/15/2024 9,932,830 - - 9,990,640 57,810 Treasury 1.75% 9/29/2022 7/31/2024 9,883,495 - - 9,971,173 87,678 FFCB 3.38% 8/31/2022 8/26/2024 23,318,655 - - 23,422,079 103,424 FFCB 3.50% 9/16/2022 9/13/2024 19,840,528 - - 19,920,840 80,312 FHLB 4.50% 11/1/2022 10/3/2024 1,991,880 - - 1,994,850 2,970 FHLB 4.50% 11/1/2022 10/3/2024 2,987,820 - - 2,992,275 4,455 Treasury 0.63% 12/13/2022 10/15/2024 4,878,907 - - 4,931,416 52,509 FFCB 4.38% 10/17/2022 10/17/2024 6,964,892 - - 6,978,467 13,576 FHLB 4.53% 12/14/2022 11/18/2024 14,933,727 - - 14,951,463 17,736 Texas Capital Bank 4.71% 1/19/2023 12/13/2024 5,281,544 62,962 - 5,344,507 Independent Financial Bank 4.50% 1/31/2023 12/31/2024 10,448,619 115,620 - 10,564,239 - Independent Financial Bank 4.50% 1/31/2023 1/31/2025 5,224,309 57,810 - 5,282,119 - American Nat'l Bank&Trust 4.50% 2/10/2023 2/10/2025 10,496,793 119,510 - 10,616,304 - FHLB 4.50% 2/24/2023 2/13/2025 4,974,015 - - 4,976,155 2,140 FHLB 4.69% 2/15/2023 3/14/2025 19,925,938 - - 19,919,002 6,936 Veritex Community Bank 5.12% 3/8/2024 4/8/2025 5,000,000 64,804 - 5,064,804 - Treasury 2.63% 2/24/2023 4/15/2025 4,879,577 - - 4,901,173 21,596 American Nat'l Bank&Trust 4.50% 3/30/2023 4/28/2025 10,458,113 117,771 - 10,575,884 - Texas Bank 4.56% 6/15/2023 5/8/2025 5,184,901 59,213 - 5,244,114 - American Nat'l Bank&Trust 4.50% 3/30/2023 5/15/2025 10,441,409 118,880 - 10,560,288 - American Nat'l Bank&Trust 5.00% 11/24/2023 5/22/2025 5,089,135 63,832 - 5,152,968 - American Nat'l Bank&Trust 5.00% 11/29/2023 5/29/2025 5,084,954 63,738 - 5,148,693 - Texas Bank 4.56% 6/15/2023 6/12/2025 3,110,940 35,528 - 3,146,468 - FHLB 4.75% 7/7/2023 6/13/2025 4,989,335 - - 4,982,590 6,745 American Nat'l Bank&Trust 4.56% 6/22/2023 6/19/2025 8,288,923 94,767 - 8,383,690 - FHLB 4.75% 6/22/2023 6/20/2025 7,985,652 - - 7,975,013 10,639 FHLB 4.81% 3/7/2024 7/7/2025 4,992,008 - - 4,984,327 7,682 American Nat'l Bank&Trust 5.10% 9/14/2023 7/14/2025 3,077,103 39,725 - 3,116,828 - FHLB 3.60% 8/28/2023 7/18/2025 491,689 - - 492,359 670 FHLMC 0.38% 8/28/2023 7/21/2025 4,719,734 - - 4,763,562 43,828 FFCB 4.88% 8/16/2023 7/28/2025 4,992,798 - - 4,985,312 7,487 American Nat'l Bank&Trust 5.10% 9/19/2023 8/19/2025 5,128,505 66,209 5,194,714 - FAMC 5.18% 9/27/2023 8/27/2025 10,035,896 - - 10,009,488 26,408 American Nat'l Bank&Trust 5.25% 11/9/2023 9/9/2025 4,070,072 54,097 - 4,124,169 - Wallis Bank 5.30% 11/15/2023 9/15/2025 6,080,153 79,458 - 6,159,612 - American Nat'1 Bank&Trust 5.00% 12/7/2023 10/2/2025 5,080,081 63,719 - 5,143,800 - American Nat'l Bank&Trust 4.90% 12/14/2023 10/9/2025 5,073,697 62,359 1 5,136,056 - 13 City of Round Rock Valley View Consulting,L.L.C. Market Value Comparison June 30, 2024 Issuer Coupon Settlement Maturity Beginning Total Buys/ Total Sells/ Ending Market Change in Rate Date Date Market Value Increases Decreases Value Market Value Treasury 500% 4/25/2024 10/31/2025 - 5,117,464 4,999,791 3,892 TVA 0.00% 1/30/2024 11/1/2025 9,259,293 - - 9,360,549 101,256 TVA 0.00% 1/19/2024 11/1/2025 4,629,648 - - 4,680,275 50,627 FNMA 0.50% 1/4/2024 11/7/2025 9,340,358 - - 9,417,490 77,132 FHLB 4.75% 2/5/2024 12/12/2025 14,989,409 - - 14,953,262 36,147 FHLB 4.50% 2/14/2024 1/2/2026 12,950,548 - - 12,924,522 26,026 FHLB 4.70°% 2/26/2024 2/13/2026 14,993,576 - - 14,954,169 39,407 FFCB 4.63% 3/6/2024 3/5/2026 19,977,234 - - 19,917,104 60,130 FAMC 4.65% 4/22/2024 4/8/2026 - 9,951,658 9,956,442 22,867 FFCB 4.88% 4/25/2024 4/15/2026 - 9,995,746 - 10,005,873 23,669 FAMC 4.95°% 5/6/2024 5/6/2026 - 10,000,000 - 10,011,655 11,655 FFCB 4.75% 5/9/2024 5/8/2026 - 1,996,083 - 1,997,806 1,986 FFCB 4.88% 5/16/2024 5/15/2026 - 3,006,641 - 3,004,412 1,822 FHLB 4.88°% 6/6/2024 6/12/2026 - 5,027,528 - 5,007,711 495 FAMC 4.75% 6/21/2024 6/18/2026 - 20,000,000 - 19,961,952 38,048 Sub Total/Average Fund 000-Pooled Investments 503,539,370 84,429,740 85,071,416 503,426,027 702,506 Fund 170-Interest&Sinking GO Bonds TexPool N/A 9/30/2015 N/A 20,740,630 588,936 - 21,329,566 - TexasDAILY N/A 4/30/2016 N/A 29,902 396 - 30,298 - Sub Total/Average Fund 170-Interest&Sinking GO Bonds 20,770,532 589,332 - 21,359,864 - Fund 462-2017 Bond Fund TexPool N/A 5/30/2017 N/A 2,244,751 29,872 - 2,274,623 - NexBank N/A 3/30/2020 N/A 1,753,801 24,280 - 1,778,081 - Sub Total/Average Fund 462-2017 Bond Fund 3,998,552 54,152 - 4,052,704 - Fund 463-2024 GO TexPool N/A 5/17/2024 N/A - 20,122,849 - 20,122,849 - Sub Total/Average Fund 463-2024 GO - 20,122,849 - 20,122,849 - Fund 465-Road CO Bond Fund TexPool N/A 9/1/2020 N/A 2,997,869 4,989,101 - 7,986,970 - American Nat'l Bank&Trust 4.85% 4/10/2023 4/10/2024 10,454,253 - 1 10,454,253 - - Sub Total/Average Fund 465-Road CO Bond Fund 13,452,123 4,989,101 1 10,454,253 7,986,970 - Fund 466&467-2024 CO TexPool N/A 5/17/2024 N/A - 20,122,659 - 20,122,659 - Sub Total/Average Fund 466&467-2024 CO - 20,122,659 - 20,122,659 - Fund 551 -2024 LTN TexPool N/A 5/17/2024 N/A - 8,047,810 - 8,047,810 - Sub Total/Average Fund 551 -2024 LTN - 8,047,810 - 8,047,810 - Fund 591 -Reserves Fund TexPool N/A 9/30/2015 N/A 9,440 1 126 - 9,565 - NexBank N/A 4/29/2019 N/A 934,226 12,934 - 947,159 - Sub Total/Average Fund 591 -Reserves Fund 943,665 13,059 - 956,725 - Fund 602-Interest&Sinking Revenue Bonds TexPool N/A 9/30/2015 N/A 4,534,108 59,741 1 122,450 4,471,399 - Sub Total/Average Fund 602-Interest&Sinking Revenue Bonds 4,534,108 59,741 1 122,450 4,471,399 - Fund 604-2022 SIB Loan TexPool N/A 9/29/2022 N/A 1 2,891,607 38,480 - 2,930,087 - 14 City of Round Rock Valley View Consulting,L.L.C. Market Value Comparison June 30, 2024 Issuer Coupon Settlement Maturity Beginning Total Buys/ Total Sells/ Ending Market Change in Rate Date Date Market Value Increases Decreases Value Market Value American Nat'l Bank&Trust N/A 9/19/2023 N/A 677 1 - 678 - American Nat'l Bank&Trust N/A 11/21/2022 N/A 21,459,561 297,051 - 21,756,611 - Sub Total/Average Fund 604-2022 SIB Loan 24,351,845 335,531 - 24,687,376 - Fund 605-Kalahari Debt Service Reserve TexPool N/A 8/30/2019 N/A 5,309,190 1,729,328 11 7,038,518 1 - Sub TotallAvera a Fund 605-Kalahari Debt Service Reserve 1 5,309,190 1,729,328 - 7,038,518 - Total/Average I $ 576,899,384 $ 140,493,302 $ 95,648,119 $ 622,272,900 $ 702,506 15 City of Round Rock Valley View Consulting,L.L.C. Holdings by Allocation and Portfolio Fund March 31, 2024 Coupon Settlement Face Amount] Book Days to YTM @ Issuer Rate Credit Rating Date Shares Book Value Price Market Value Maturity Date Maturity Book Fund 000-Pooled Investments NexBank 5.55% 11/29/2016 $ 22,831,752 $ 22,831,752 100.00 $ 22,831,752 N/A 1 5.55% TexasDAILY 5.32% AAAm 6/1/2021 2,622 2,622 100.00 2,622 N/A 1 5.32% TexasDAILY Select 5.45% AAAm 12/3/2021 5,427,363 5,427,363 100.00 5,427,363 N/A 1 5.45% Veritex Community Bank 5.33% 9/1/2020 204,773 204,773 100.00 204,773 N/A 1 5.33% JPMor an Chase 0.23% 9/30/2015 8,187,561 8,187,561 100.00 8,187,561 N/A 1 0.23% TexSTAR 5.30% AAAm 9/30/2015 216,864 216,864 100.00 216,864 N/A 1 5.30% TexPool 5.32% AAAm 9/30/2015 35,370,459 35,370,459 100.00 35,370,459 N/A 1 5.32% NexBank 5.55% 1/13/2023 14,506,704 14,506,704 100.00 14,506,704 N/A 1 5.55% TexasDAILY 5.32% AAAm 9/30/2015 2,449,279 2,449,279 100.00 2,449,279 N/A 1 5.32% FAMC 2.58% 4/18/2022 10,000,000 10,000,000 99.84 9,983,877 4/18/2024 18 2.58% Treasury 2.25% Aaa/AA+/AA+ 3/30/2022 10,000,000 9,998,508 99.76 9,975,650 4/30/2024 30 2.44% FAMC 2.65% 5/9/2022 3,000,000 2,999,806 99.74 2,992,183 5/2/2024 32 2.73% FFCB 2.63% Aaa/AA+/AA+ 6/2/2022 3,051,000 3,050,879 99.73 3,042,754 5/3/2024 33 2.67% Treasury 2.50% Aaa/AA+/AA+ 6/2/2022 7,000,000 6,998,215 99.52 6,966,129 5/31/2024 61 2.66% FHLB 3.13% Aaa/AA+/-- 6/23/2022 20,000,000 19,999,470 99.51 19,902,708 6/14/2024 75 3.14% FFCB 3.15% Aaa/AA+/AA+ 7/15/2022 10,000,000 10,000,649 99.33 9,932,830 7/15/2024 106 3.13% Treasury 1.75% Aaa/AA+/AA+ 9/29/2022 10,000,000 9,922,727 98.83 9,883,495 7/31/2024 122 4.18% FFCB 3.38% Aaa/AA+/AA+ 8/31/2022 23,500,000 23,484,748 99.23 23,318,655 8/26/2024 148 3.54% FFCB 3.50% Aaa/AA+/AA+ 9/16/2022 20,000,000 19,959,270 99.20 19,840,528 9/13/2024 166 3.97% FHLB 4.50% Aaa/AA+/-- 11/1/2022 3,000,000 2,997,686 99.59 2,987,820 10/3/2024 186 4.66% FHLB 4.50% Aaa/AA+/-- 11/1/2022 2,000,000 1,998,457 99.59 1,991,880 10/3/2024 186 4.66% Treasury 0.63% Aaa/AA+/AA+ 12/13/2022 5,000,000 4,902,169 97.58 4,878,907 10/15/2024 198 4.43% FFCB 4.38% Aaa/AA+/AA+ 10/17/2022 7,000,000 7,000,218 99.50 6,964,892 10/17/2024 200 4.37% FHLB 4.53% Aaa/AA+/-- 12/14/2022 15,000,000 15,000,000 99.56 14,933,727 11/18/2024 232 4.53% Texas Capital Bank 4.71% 1/19/2023 5,281,544 5,281,544 100.00 5,281,544 12/13/2024 257 4.717/.- Independent .71%Inde endent Financial Bank 4.50% 1/31/2023 10,448,619 10,448,619 100.00 10,448,619 12/31/2024 275 4.50% Independent Financial Bank 4.50% 1/31/2023 5,224,309 5,224,309 100.00 5,224,309 1/31/2025 306 4.50% American Nat'l Bank&Trust 4.50% 2/10/2023 10,496,793 10,496,793 100.00 10,496,793 2/10/2025 316 4.50% FHLB 4.50% Aaa/AA+/-- 2/24/2023 5,000,000 4,985,527 99.48 4,974,015 2/13/2025 319 4.85% FHLB 4.69% Aaa/AA+/-- 2/15/2023 20,000,000 20,000,000 99.63 19,925,938 3/14/2025 348 4.69% Veritex Community Bank 5.12% 3/8/2024 5,000,000 5,000,000 100.00 5,000,000 4/8/2025 373 5.12% Treasury 2.63% Aaa/AA+/AA+ 2/24/2023 5,000,000 4,900,598 97.59 4,879,577 4/15/2025 380 4.65% American Nat'l Bank&Trust 4.50% 3/30/2023 10,458,113 10,458,113 100.00 10,458,113 4/28/2025 393 4.50% Texas Bank 4.56% 6/15/2023 5,184,901 5,184,901 100.00 5,184,901 5/8/2025 403 4.56% American Nat'l Bank&Trust 4.50% 3/30/2023 10,441,409 10,441,409 100.00 10,441,409 5/15/2025 4101 4.50% American Nat'l Bank&Trust 5.00% 11/24/2023 5,089,135 5,089,135 100.00 5,089,135 5/22/2025 4171 5.00% American Nat'l Bank&Trust 5.00% 11/29/2023 5,084,954 5,084,954 100.00 5,084,954 5/29/2025 424 5.00% Texas Bank 4.56% 6/15/2023 3,110,940 3,110,940 100.00 3,110,940 6/12/2025 438 4.56% FHLB 4.75% Aaa/AA+/-- 7/7/2023 5,000,000 4,974,761 99.79 4,989,335 6/13/2025 439 5.19% American Nat'l Bank&Trust 4.56% 6/22/2023 8,288,923 8,288,923 100.00 8,288,923 6/19/2025 445 4.56% FHLB 4.75% Aaa/AA+/-- 6/22/2023 8,000,000 8,000,000 99.82 7,985,652 6/20/2025 446 4.75% FHLB 4.81% Aaa/AA+/-- 3/7/2024 5,000,000 5,000,000 99.84 4,992,008 7/7/2025 463 4.81% American Nat'l Bank&Trust 5.10% 9/14/2023 3,077,103 3,077,103 100.00 3,077,103 7/14/2025 470 5.10% FHLB 3.60% Aaa/AA+/-- 8/28/2023 500,000 490,104 98.34 491,689 7/18/2025 474 5.22% FHLMC 0.38% Aaa/AA+/AA+ 8/28/2023 1 5,000,000 1 4,709,151 94.39 4,719,734 7/21/2025 477 5.11% FFCB 4.88% Aaa/AA+/AA+ 8/16/2023 1 5,000,000 4,990,129 99.86 4,992,798 7/28/2025 484 5.03% American Nat'l Bank&Trust 5.10% 9/19/2023 5,128,505 5,128,505 100.00 5,128,505 8/19/2025 506 5.10% FAMC 5.18% 9/27/2023 10,000,000 10,000,000 100.36 10,035,896 8/27/2025 514 5.18% 16 City of Round Rock Valley View Consulting, L.L.C. Holdings by Allocation and Portfolio Fund March 31, 2024 Coupon Settlement Face Amount/ Book Days to YTM @ Issuer Rate Credit Rating Date Shares Book Value Price Market Value Maturity Date Maturity Book American Nat'l Bank&Trust 5.25% 11/9/2023 4,070,072 4,070,072 100.00 4,070,072 9/9/2025 527 5.25% Wallis Bank 5.30% 11/15/2023 6,080,153 6,080,153 100.00 6,080,153 9/15/2025 533 5.30% American Nat'l Bank&Trust 5.00% 12/7/2023 5,080,081 5,080,081 100.00 5,080,081 10/2/2025 550 5.00% American Nat'l Bank&Trust 4.90% 12/14/2023 5,073,697 5,073,697 100.00 5,073,697 10/9/2025 557 4.90% TVA 0.00% Aaa/AA+/AA+ 1/19/2024 5,000,000 4,652,807 92.59 4,629,648 11/1/2025 580 4.61% TVA 0.00% Aaa/AA+/AA+ 1/30/2024 10,000,000 9,305,529 92.59 9,259,293 11/1/2025 580 4.61% FNMA 0.50% Aaa/AA+/AA+ 1/4/2024 10,000,000 9,397,840 93.40 9,340,358 11/7/2025 586 4.45% FHLB 4.75% Aaa/AA+/-- 2/5/2024 15,000,000 15,073,589 99.93 14,989,409 12/12/2025 621 4.44% FHLB 4.50% Aaa/AA+/-- 2/14/2024 13,000,000 13,000,000 99.62 12,950,548 1/2/2026 642 4.50% FHLB 4.70% Aaa/AA+/-- 1 2/26/2024 1 15,000,000 1 15,000,000 99.96 14,993,576 2/13/2026 684 4.70% FFCB 4.63% Aaa/AA+/AA+ 1 3/6/2024 1 20,000,000 20,018,621 99.89 19,977,234 3/5/2026 7041 4.57% Sub Total/Average 1 4.02% 1 1 506,867,631 504,628,091 99.34 503,539,370 2951 4.42% Fund 170-Interest&Sinking GO Bonds TexasDAILY 5.32% AAAm 4/30/2016 29,902 29,902 100.00 29,902 N/A 1 5.32% TexPool 5.32% AAAm 9/30/2015 20,740,630 20,740,630 100.00 20,740,630 N/A 11 5.32% Sub Total/Average 5.32% 20,770,532 20,770,532 1 100.00 20,770,532 1 5.32% Fund 462-2017 Bond Fund TexPool 5.32% AAAm 5/30/2017 2,244,751 2,244,751 100.00 2,244,751 N/A 1 5.32% NexBank 5.55% 3/30/2020 1,753,801 1,753,801 100.00 1,753,801 N/A 1 5.55% Sub Total/Average 5.42% 3,998,552 3,998,552 100.00 3,998,552 1 5.42% Fund 465-Road CO Bond Fund TexPool 5.32% AAAm 9/1/2020 2,997,869 2,997,869 100.00 2,997,869 1 N/A 11 5.32% American Nat'l Bank&Trust 4.85% 4/10/2023 10,454,253 10,454,253 100.00 10,454,253 4/10/2024 101 4.85% Sub Total/Average 4.95% 13,452,123 13,452,123 1 100.00 13,452,123 81 4.95% Fund 591 -Reserves Fund TexPool 5.32% AAAm 9/30/2015 9,440 9,440 100.00 9,440 N/A 1 5.32% NexBank 5.55% 4/29/2019 934,226 934,226 100.00 934,226 N/A 1 5.55% Sub Total I Average 5.55% 1 943,665 943,665 100.00 943,665 11 5.55% Fund 602-Interest&Sinking Revenue Bonds TexPool 5.32% AAAm 9/30/2015 4,534,108 4,534,108 100.00 4,534,1-0-8T- N/A 1 5.32% Sub Total/Average 5.32% 1 4,534,108 4,534,108 100.00 4,534,108 1 1 5.32% Fund 604-2022 SIB Loan TexPool 5.32% AAAm 9/29/2022 2,891,607 2,891,607 100.00 2,891,607 N/A 1 5.32% American Nat'l Bank&Trust 0.35% 9/19/2023 677 677 100.00 677 N/A 1 0.35% American Nat'l Bank&Trust 5.52% 11/21/2022 21,459,561 21,459,561 100.00 21,459,561 N/A 1 5.52% Sub Total/Average 5.50% 24,351,845 24,351,845 100.00 24,351,845 11 5.50% Fund 605-Kalahari Debt Service Reserve TexPool 5.32% AAArn 1 8/30/2019 5,309,190 1 5,309,190 1 100.00 5,309,190 1 N/A 1 5.32% Sub Total/Average 5.32% 1 5,309,190 1 5,309,190 1 100.00 5,309,190 1 1 5.32% Total/Average 4.18% 1 1 $ 580,227,645 1 $ 577,988,105 99.43 $ 576,899,384 1 2581 4.531/ 17 City of Round Rock Valley View Consulting,L.L.C. ROUND ROCK BY THE NUMBERS -W-7- ._a_ 00019 FY 2024 Quarter 3 Citywide Sales Tax, Net of Incentives Property Tax Totals through June 2024=S83.9111ill $no,ow,000 $ao,000,000 $1oo,0o0,o00 $33,000,000 $W,o00,00o $W.00o,000 $30,000,000 $70,000,000 - - f25,000,000 $60,000,000 fso,000,000 - $20,000,000 - S4o,oco,o00 $16,000,000 W,000,000 fla,0oa,000 $20,000,000 510,000,000 Ss,00a,000 $_ $- act Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sept -40-FV 2024 Actual. FY 2023 Actuals •FY 24 Actuals •FY 23 Actual. Other General Fund Pevenues HOT & Venue Tax, Prior to Incentives fla,000,000 $9,000,000 516,000,000 58,000,000 $14,Oo0,0o0 ��- $7,000,000 $lz000,0oo $6,000,000 $5,000,000 $10,000,000 "' $4,o00,000 $8,000,000 53,000,000 W000,0o0 $2.0001000 54,000,000 51,000,000 S2.000,0o0 S odw Teeea Lkeft e, sarvlea Pegram 1 a Grana t.eng.et.• . Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sap &F—hise Perntlb• Chargee Revenue Fortehuree o1Mr Fee. Far •FY 24 Other Hotels FV 24 Kalahari •FV 23 Other Hotels FV 23 Kalahari ■FV 2024 Actuals •FY 2023 Actwls Comments Sales Tax Citywide sales tax collections,net of incentives,increased 5.5%over the prior year. Year-to-date results include$3.1 million in revenues from amended returns that should have been realized in FY 2023. When adjusted for the reporting anomaly,the rolling 12-month sales tax collections,excluding Dell,show a slight increase of 1.6%. 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.1%tax rate increase for FY 2024 and new properties added. Other General Fund Revenues are trending as follows: Other Taxes&Franchise Fees are up 99.8%.This is due to the timing of Oncor's electric franchise fee.Last year,Oncor's payment was collected in the fourth quarter. License,Permits,and Fees decreased 37.6%over last year.Due to the nature and timing of projects,revenues can fluctuate widely from quarter to quarter and year to year. Service Charges increased 11.5%.This is due to the adopted rate increase that took place October 2023 for residential garbage services and late fees being waived the first quarter of FY 2023 while the City implemented its new customer payment portal.Also,there has been a significant increase in lot clearing services this fiscal year. Program Revenues increased 9.3%.This is attributed to higher program participation at CMRC,pools and RRPL. Fines and Forfeitures revenues decreased 3.0%due to fewer citations and cases filed than last year. Grants have decreased 37.2%.In FY 2023,the City received two large reimbursements due to COVID vaccination clinics and wildfire deployments.Also,a one-time ARPA reimbursement was received for CRU vehicles. Contracts and Other increased 23.3%.This is due to higher interest earnings and insurance proceeds collected from the hailstorm. Hotel Occupancy&Venue Tax Revenues through June are slightly below expected because two hotel properties are delinquent in paying these taxes. They have been turned over to the City Attorney's office for collection. 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 down 4.3%from the same period last year due to wetter,milder weather and a short-term water sale agreement with Jonah SUD that ended 12/31/23. Wastewater and Stormwater are trending in line with budget. ROUND ROCK BY THE NUMBERS FY 2024 Annual Facts Revised FY 2023 2024 $103 ft$MA �.� source Amount(in Mullions)sx e Sales Tax $ 113.9 9113.9 Use of Fund Balance S 96.6 Property Tax $ 81.9 Bond Proceeds $ 67.3 Utility&Garbage Charges S 61.4 Contracts&Other S 60.5 $96.6 - Fines,Permits&Fees $ 18.8 Other Taxes&Franchise Fees $ 17.7 Hotel Occupancy/Venue Tax $ 15.8 $81'9 Program Revenues $ 10.3 Revised IFY I2024 Total Budget Expenses $544.2M 91.6113.3 u• $4.9 $7.0 $9.2 •119 Amount Amount $Ua Department (in Millions) Department (in Millions) ms's Capital Improvement Projects $ 200.4 Transportation S 13.8 Police S 44.5 Sports Management S 11.9 $200.6 Debt Payments $ 42.9 General Services $ 9.2 Support Services $ 39.9 Planning&Development $ 7.0 ;V, Utilities&Environmental Svcs $ 38.2 Library $ 4.9 Fire S 36.1 Fleet Replacement S 4.2 Funding Transfers Out S 34.0 Communications S 3.3 f3e� General Self Financed Const. $ 31.9 Com.&Neighborhood Srv, f 1.6 9399 Lt29 � Parks&Recreation $ 20.4 Other CORR Tax Information Taxing Entities Top 10 Property Tax Payers FY 23-24 FY 22-23 Entity Rate Business Amount(in millions) Population 134,540 128,957 City of Round Rock $ 0.3420 Kalahari Resorts $ 531.8 Property Tax Rate E 0.34200 S 0.34200 Williamson County S 0.3774 Dell Computer Holdings LP 459.1 M&O 0.224400 Debt 0.117600 Round Rock ISD $ 0.9190 CMF 15 Portfolio(cdo•i•i sn,ne Apw 166.5 Austin Community College $ 0.0986 CPF,RR,LP(Round Rock Outlets) 162.8 Outstanding Debt as of 10/01/23 Upper Brushy Creek WCID $ 0.0170 TX Essential Housing(Lakeside®LF) 151.1 Bond Amount O/S(in Millioro) Total Tax Rah $ 1 7540 Dell Computer Corp 135.5 GO&CO Bonds $ 292.9 2811 La Frontera LP(the District on LF) 101.5 Capital lease/LTNs $ 5.8 Taxable Values 36 Hundred Apts(Avery Centre) 100.0 Uciaty/Stormwater $ 103.7/5.2 FY 23-24 FY 22-23 Stanmore Warner Ranch Apts 99.9 HOT S 6.7 Median Home Values S 363,396 $ 369,169 TMP Parkside LLC(Parkside a RR) 95.3 Type B S 66.0 Taxable Property Value(in billions) S 24.1 $ 21.7 Bond Ratings(Rated by saw) City Employees GO Bonds AAASworn FTEs Total FTEs Utility Bonds AAA City Wide 369 1,176.7 Police 200 287.2 Fi re 169 194.0