Loading...
R-2024-108 - 5/9/2024 RESOLUTION NO. R-2024-108 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 March 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 9th day of May, 2024. CRA1('/M0"RG4A, Mayor City of Round ock,Texas ATTEST: AGAN S KS, ity Clerk 0112.20242:4855-0429-6121 0' EXHIBIT ' "A» ROUND ROCK TEXAS FINANCE QUARTERLY INVESTMENT REPORT For the Quarter Ended March 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. signatures withheld for security purposes signatures withheld for security purposes Chief Financial Officer Deputy Chief Financial Officer signatures withheld for security purposes signatures withheld for security purposes Controller Treasury Accountant Valley View on ulting, 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) 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% 1 266,089,242 265,138,982 US Treasury 3.52% 36,722,218 36,583,757 Total/Average 4.53% $ 577,988,105 $ 576,899,384 December 31, 2023 YTM @ Description Cost Book Value Market Value Cash 0.31% $ 11,922,479 $ 11,922,479 Certificates of Deposit 4.74% 116,686,927 116,686,927 Local Government Investment Pool 5.38% 91,004,288 91,004,288 Money Market Accounts 5.58% 50,959,844 50,959,844 US Agency 3.78% 194,544,641 193,743,960 US Treasury 2.69% 58,616,124 58,249,297 Total/Average 4.25% $ 523,734,302 1 $ 522,566,794 Average Yield Current Fiscal Year- Quarter(1) to-Date(2) Total Portfolio 4.53% 4.39% TexPool Yield 5.32% 5.34% Rolling Three Mo. Treas.Yield 5.46% 5.49% Rolling Six Mo.Treas.Yield 5.37% 5.43% Rolling 1 Yr.Treas.Yield 5.12% 5.10% Rolling 2 Yr.Treas.Yield 4.17% 3.98% Investment Income (3) Interest Income(Approximate) $ 6,185,690 $ 11,244,465 WAM at 3/31/2024 Policy WAM Max Total Portfolio 258 days 540 days Pooled Funds 295 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 3/31/2024 The Federal Open Market Committee(FOMC)maintained the Fed Funds target range 5.25%-5.50%(Effective Fed Funds are trading+/-5.33%). All expectations are for reduced future rates,but any actions will be meeting-by-meeting and"data-dependent." Fourth Quarter 2023 GDP recorded a stronger than expected 3.4%. The S&P 500 Stock Index reached another new high closing over 5,200. The yield curve remains inverted but longer yields rose slightly. Crude Oil traded over$87 per barrel. Inflation stubbornly remained above the FOMC 2%target(Core PCE+/-2.8%and Core CPI+/-3.8%). Reduced global economic outlooks and ongoing/expanding military conflicts continue increasing uncertainty. 6.00 - Treasury Yield Curves s7so S&P 500 , - -- -- 5,500 5,250 - --- 5,000 -- -- -- -- - ` 4,750 4,500 4W 4,250 JET M 4.00 4,000 3,750 3,500 3.00 3,250 3,000 2,750 2,500 2.00 2,250 2,000 1,750 - - - 1,500 -- - -- - - 1.00 1,250 1,000 750 0.00 Q 250 611 *-v y� Jv y�i7 yt� ODM h �0 �1 �6 �9 10 5. titi by yP March 31,2023 December 31,2023 ---March 31,2024 6.00 US Treasury Historical Yields -Since 2006 6.00 US Treasury Historical Yields -Since Nov 2016 5.50 5.50 5.00 5.00 • 4.50 If 40 F0 PTIA. 4.50 4.00 -- - - 4.00 - - - - 3.50 W 3.50 46fi 3.00 - - - 3.00 2.50 2.50 r 2.00 is 2.00 ale 1.50 - - - 1.50 J 1.00 1.00 ='r+- - - -- -- - 0.50 0.50 0.00 'b 0.00 a�j'�ac�)O,a�j'� '�aK�"�a�j0, 0,ac�j�a?O�a�ti �o� �a1 1o`1 10 1104 1,0 X04 �a� X04 fat \4�o �a� �o� 100 X10 -Six Month T$111 Two Year T-Note Ten Year T-Note -Six Month T-8111 Two Year T-Note Ten Year T-Note Valley View Consulting,L.L.C. 2 Holdings by Investment Category March 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 $ 8,187,561 1% $ - 0% $ - 0% $ - 0% $ 8,187,561 1% Certificates of Deposit 112,619,253 19% - 0% - 0% 10,454,253 2% 123,073,507 21% Investment Pools 43,466,587 8% 25,304,640 4% 5,318,630 1% 8,134,227 1% 1 82,224,084 14% Money Market Accounts 37,543,229 6% - 0% 934,226 0% 23,214,039 4% 61,691,493 11% Municipal - 0% - 0% - 0% - 0% - 0% US Agency 266,089,242 46% - 0% - 0% - 0% 266,089,242 46% US Treasury 36,722,218 1 6% - 0% - 0% - 0% 36,722,218 6% Total/Average $504,628,091 87% $ 25,304,640 4% $ 6,252,855 1% $ 41,802,519 7% $577,988,105 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 50 � 1 Pooled Funds DS Funds DSR Funds CP&SP Funds Total Portfolio 3/31/2024 3/31/2024 3/31/2024 3/31/2024 3/31/2024 3 City of Round Rock Valley View Consulting,L.L.C. Investment Holdings by Investment Category Quarterly Transactions By Investment Category March 31, 2024 March 31, 2024 %of Portfolio Net Cash Equivalent Description Book Value Portfolio Limitation Description Buys Sells Maturities Calls Interest Deposit/(Withdrawal) Cash $ 8,187,561 1.4% 100°% Cash $ — $ — $ — $ — $ 26,657 $ 3,734,918 Investment Pools 82,224,084 14.2% 100°% Investment Pools — — — — 1,297,678 8,780,204 Mone Market Accounts 61,691,493 10.7% 75°% Mone Markets Accounts — — — — 741,430 10,731,649 Certificates of Deposit 123,073,507 21.3°% 85°% Certificates of Deposit 6,386,580 — — — 1,386,580 — Commercial Paper — 0.0°% 10%/5% Commercial Paper — — — — — — Municipal — 0.0% 35%/5% Municipal — — — — — — US Agency 266,089,242 46.0% 85°% US Agency 91,365,409 — 20,000,000 — 2,004,271 — US Treasury 36,722,218 6.4% 85% US Treasury — — 22,000,000 — 343,750 — Total/Average $ 577,988,105 100% PASSED Totals $ 97,751,989 $ — $ 42,000,000 $ — $ 5,800,365 $ 1,783,472 Portfolio Balances (Millions) Portfolio Composition Order of Liquidity March 31, 2024 $600 Money Market Accounts Certificates of 10.7% Deposit ■Cash 21.3% $500 []Local Government Investment Pools $400 Investment Pool 14.2% / ■Money Market Account $300 ■US Treasury Cash 1.4% $200 ❑US Agency US Treasury 6.4% $100 ❑Municipal $0 o Certificates of Deposit b USA enc 413 46.0% y 4 City of Round Rock Valley View Consulting, L.L.C. City of Round Rock Pooled Funds Performance 5.50 — -- -- -- 5.00 4.50 _ -- I 4.00 SF 3.50 AMD a - o� � is c 3.00 - - a) a 2.50 2.00 - - 1.50 ` ♦ It 1.00 � �� �_ ♦ - 0.50 0.00 ,pro SIO NIB �o NA ,�1 ^'1 N\ ,�� NIb NIb Nb �o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o`ti oti o`ti o`L oti o`L o`ti oti otic o`L�o`L�o`ti�o`tio o`ti�o`L�otic o`L o�ti ��ti �ti o\ti " ��ti ��ti o�ti o\ti Nati Nati o�ti o\ti Nati '\ti o&ti o&ti Nati ��ti o�ti o�ti ��ti .4 ,\ti o\, Opti ��ti o�ti o�ti ��ti ,�\ti sp o�ti r\. o\5 o\5�Vb b\b o\j o\S",b ,\b'0\5 o\j PrP 'b\b o�5 o�5�P 'b o\S o����� rte o\� o\j�P ',\r o�5 o���4b 'b 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 ❑Debt Service Reserve Funds $300 ❑Debt Service Funds $200 $100 Pooled Funds $0 111 0�1 e lz Ip Ip Ip o^e 1 o^0 0^9 0'9 0p atio olo 110 oto oti^ 1ti1 ati^ otiI 41 41 41 'IV' 11�1 0119 11P oto old 6 City of Round Rock Valley View Consulting,L.L.C. Holdings by Allocation and Portfolio Fund March 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 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.230/. 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 1 9/30/2015 1 2,449,279 2,449,279 100.00 2,449,279 NiA 1 5.321/6 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 751 3.14% FFCB 3.15% Aaa/AA+/AA+ 7/15/2022 1 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.377/.--- FHLB .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.71% Independent 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 3161 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 410 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 417 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 4461 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 5,000,000 4,709,151 94.39 4,719,734 7/21/2025 477 5.11% FFCB 4.88% Aaa/AA+/AA+ 8/16/2023 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 1 506 5.10% FAMC 5.18% 9/27/2023 10,000,000 10,000,000 1 100.36 1 10,035,896 8/27/2025 1 5141 5.18% 7 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+/-- 2/26/2024 15,000,000 15,000,000 99.96 14,993,576 2/13/2026 684 4.70% FFCB 4.63% Aaa/AA+/AA+ 3/6/2024 20,000,000 20,018,621 99.89 19,977,234 3/5/2026 7041 4.57% Sub Total/Average 1 4.02% 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 1 100.00 29,902 N/A 11 5.32% TexPool 5.32% AAAm 9/30/2015 20,740,630 20,740,630 100.00 20,740,630 N/A 1 5.32% Sub Total/Average 5.32% 20,770,532 20,770,532 100.00 20,770,532 1 5.32% Fund 462-2017 Bond Fund TexPool 5.32% AAA. 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 N/A 1 5.32% American Nat'l Bank&Trust 4.85% 4/10/2023 10,454,253 10,454,253 100.00 10,454,253 1 4/10/2024 1 101 4.85% Sub Total/Average 4.95% 13,452,123 13,452,123 100.00 1 13,452,123 1 1 81 4.95% Fund 591 -Reserves Fund TexPool 5.32% AAAm 9/30/2015 9,440 9,440 1 100.00 1 9,440 1 N/A 11 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% 943,665 943,665 100.00 943,665 1 5.55% Fund 602-Interest&Sinking Revenue Bonds TexPool 5.32% AAArn 1 9/30/2015 1 4,534,108 4,534,108 100.00 4,534,108 N/A 1 5.32% Sub Total/Average 5.32% 1 1 4,534,108 1 4,534,108 100.00 4,534,108 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 1 5.50% Fund 605-Kalahari Debt Service Reserve TexPool 5.32% AAA. 8/30/2019 5,309,190 5,309,190 100.00 5,309,190 N/A 1 5.32% Sub Total/Avera a 5.32% 1 1 5,309,190 1 5,309,190 1 100.00 1 5,309,190 1 1 5.32% Total/Average 4.18% $ 580,227,645 $ 577,988,105 99.43 $ 576,899,384 258 8 City of Round Rock Valley View Consulting, L.L.C. Book Value Comparison March 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 $ 11,922,479 $ 4,602,630 $ 8,337,548 $ 8,187,561 $ 3,734,918 TexPool N/A 9/30/2015 N/A 52,898,952 23,577,998 41,106,490 35,370,459 17,528,493 TexSTAR N/A 9/30/2015 N/A 214,020 2,844 - 216,864 2,844 TexasDAILY N/A 9/30/2015 N/A 2,417,087 32,192 - 2,449,279 32,192 TexasDAILY N/A 6/1/2021 N/A 2,587 301 267 2,622 34 TexasDAILY Select N/A 12/3/2021 N/A 5,354,049 73,314 - 5,427,363 73,314 NexBank N/A 11/29/2016 N/A 12,308,944 10,522,808 - 22,831,752 10,522,808 Veritex Community Bank N/A 9/1/2020 N/A 202,075 2,697 - 204,773 2,697 NexBank N/A 1/13/2023 N/A 14,628,873 202,212 324,380 14,506,704 122,169 FFCB 0.90°'0 1/28/2022 1/18/2024 4,999,327 - 5,000,000 - 4,999,327 Treasury 2.25% 1/5/2022 1/31/2024 8,009,969 - 8,000,000 - 8,009,969 Treasury 2.38% 2/14/2022 2/29/2024 14,017,529 - 14,000,000 - 14,017,529 FHLB 1.88% 2/28/2022 3/8/2024 15,007,315 - 15,000,000 - 15,007,315 FAMC 2.58% 4/18/2022 4/18/2024 10,000,000 - - 10,000,000 - Treasury 2.25% 3/30/2022 4/30/2024 9,993,982 - - 9,998,508 4,526 FAMC 2.65% 5/9/2022 5/2/2024 2,999,254 - - 2,999,806 552 FFCB 2.63% 6/2/2022 5/3/2024 3,050,545 - - 3,050,879 334 Treasury 2.50% 6/2/2022 5/31/2024 6,995,553 - - 6,998,215 2,662 FHLB 3.13% 6/23/2022 6/14/2024 19,998,831 - - 19,999,470 639 FFCB 3.15% 7/15/2022 7/15/2024 10,001,207 - - 10,000,649 557 Treasury 1.75% 9/29/2022 7/31/2024 9,865,089 - - 9,922,727 57,638 FFCB 3.38% 8/31/2022 8/26/2024 23,475,339 - - 23,484,748 9,409 FFCB 3.50% 9/16/2022 9/13/2024 19,937,220 - - 19,959,270 22,050 FHLB 4.50% 11/1/2022 10/3/2024 2,996,567 - - 2,997,686 1,119 FHLB 4.50% 11/1/2022 10/3/2024 1,997,712 - - 1,998,457 746 Treasury 0.63% 12/13/2022 10/15/2024 4,857,207 - - 4,902,169 44,963 FFCB 4.38% 10/17/2022 10/17/2024 7,000,316 - - 7,000,218 98 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,219,956 61,588 - 5,281,544 61,588 Independent Financial Bank 4.50% 1/31/2023 12/31/2024 10,331,538 117,081 - 10,448,619 117,081 Independent Financial Bank 4.50% 1/31/2023 1/31/2025 5,165,769 58,540 - 5,224,309 58,540 American Nat'l Bank&Trust 4.50% 2/10/2023 2/10/2025 10,379,904 116,890 - 10,496,793 116,890 FHLB 4.50% 2/24/2023 2/13/2025 4,981,479 - - 4,985,527 4,049 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 - 5,000,000 5,000,000 Treasury 2.63% 2/24/2023 4/15/2025 4,876,794 - - 4,900,598 23,804 American Nat'l Bank&Trust 4.50% 3/30/2023 4/28/2025 10,341,654 116,459 - 10,458,113 116,459 Texas Bank 4.56% 6/15/2023 5/8/2025 5,126,356 58,544 - 5,184,901 58,544 American Nat'l Bank&Trust 4.50% 3/30/2023 5/15/2025 10,325,136 116,273 - 10,441,409 116,273 American Nat'l Bank&Trust 5.00% 11/24/2023 5/22/2025 5,026,093 63,042 - 5,089,135 63,042 American Nat'l Bank&Trust 5.00% 11/29/2023 5/29/2025 5,021,964 62,990 - 5,084,954 62,990 Texas Bank 4.56% 6/15/2023 6/12/2025 3,075,814 35,127 - 3,110,940 35,127 FHLB 4.75% 7/7/2023 6/13/2025 4,969,514 - - 4,974,761 5,246 American Nat'l Bank&Trust 4.56% 6/22/2023 6/19/2025 8,195,227 93,696 - 8,288,923 93,696 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 5,000,000 American Nat'l Bank&Trust 5.10% 9/14/2023 7/14/2025 3,038,307 38,796 - 3,077,103 38,796 FHLB 3.60% 8/28/2023 7/18/2025 488,200 - i - 490,104 1,904 FHLMC 0.38% 8/28/2023 7/21/2025 4,653,543 - - 4,709,151 55,608 FFCB 4.88% 8/16/2023 7/28/2025 4,988,272 - - 4,990,129 1,857 American Nat'l Bank&Trust 5.10% 9/19/2023 8/19/2025 5,063,845 64,660 - 5,128,505 64,660 FAMC 5.18% 9/27/2023 8/27/2025 10,000,000 - - 10,000,000 - 9 City of Round Rock Valley View Consulting,L.L.C. Book Value Comparison March 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 American Nat'l Bank&Trust 5.25% 11/9/2023 9/9/2025 4,017,260 52,812 4,070,072 52,812 Wallis Bank 5.30% 11/15/2023 9/15/2025 6,000,000 80,153 6,080,153 80,153 American Nat'l Bank&Trust 5.00% 12/7/2023 10/2/2025 5,017,151 62,929 - 5,080,081 62,929 American Nat'l Bank&Trust 4.90% 12/14/2023 10/9/2025 5,012,096 61,601 - 5,073,697 61,601 TVA 0.00% 1/30/2024 11/1/2025 - 9,232,490 - 9,305,529 9,305,529 TVA 0.00% 1/19/2024 11/1/2025 - 4,609,708 - 4,652,807 4,652,807 FNMA 0.50% 1/4/2024 11/7/2025 - 9,316,357 - 9,397,840 9,397,840 FHLB 4.75% 2/5/2024 12/12/2025 - 15,185,002 - 15,073,589 15,073,589 FHLB 4.50% 2/14/2024 1/2/2026 - 13,000,000 - 13,000,000 13,000,000 FHLB 4.70% 2/26/2024 2/13/2026 - 15,000,000 - 15,000,000 15,000,000 FFCB 4.63% 3/6/2024 3/5/2026 - 20,021,852 - 20,018,621 20,018,621 Sub Total/Average Fund 000-Pooled Investments 459,467,904 136,643,586 91,768,686 1 504,628,091 45,160,187 Fund 170-Interest&Sinking GO Bonds TexPool N/A 9/30/2015 N/A 1,678,735 1 19,061,895 - 20,740,630 19,061,895 TexasDAILY N/A 4/30/2016 N/A 29,509 393 - 29,902 393 Sub Total/Average Fund 170-Interest&Sinking GO Bonds 1,708,244 19,062,288 - 20,770,532 19,062,288 Fund 462-2017 Bond Fund TexPool N/A 5/30/2017 N/A 2,215,190 29,561 - 2,244,751 29,561 NexBank N/A 3/30/2020 N/A 1,731,400 22,401 - 1,753,801 22,401 Sub Total/Average Fund 462-2017 Bond Fund 3,946,590 51,962 - 3,998,552 51,962 Fund 465-Road CO Bond Fund TexPool N/A 9/1/2020 N/A 18,610,278 110,538 1 15,722,947 2,997,869 15,612,409 American Nat'l Bank&Trust 4.85% 4/10/2023 4/10/2024 10,328,855 125,398 - 10,454,253 125,398 Sub Total/Average Fund 465-Road CO Bond Fund 28,939,133 235,936 15,722,947 13,452,123 15,487,011 Fund 591 -Reserves Fund TexPool N/A 9/30/2015 N/A 9,316 124 - 9,440 124 NexBank N/A 4/29/2019 N/A 922,293 11,933 - 934,226 11,933 Sub Total/Average Fund 591 -Reserves Fund 931,608 1 12,057 - 943,665 12,057 Fund 602-Interest&Sinking Revenue Bonds TexPool N/A 9/30/2015 N/A 2,629,810 1,904,298 - 4,534,108 1,904,298 Sub Total/Average Fund 602-Interest&Sinking Revenue Bonds 2,629,810 1,904,298 - 4,534,108 1,904,298 Fund 604-2022 SIB Loan TexPool N/A 9/29/2022 N/A 2,931,202 38,603 78,198 2,891,607 39,595 American Nat'l Bank&Trust N/A 9/19/2023 N/A 671 6 - 677 6 American Nat'l Bank&Trust N/A 11/21/2022 N/A 21,165,587 293,974 - 21,459,561 293,974 Sub Total/Average Fund 604-2022 SIB Loan 24,097,461 332,582 78,198 24,351,845 254,384 Fund 605-Kalahari Debt Service Reserve TexPool N/A 8/30/2019 N/A 2,013,552 3,674,546 1 378,908 5,309,190 3,295,638 Sub TotallAvera a Fund 605-Kalahari Debt Service Reserve 2,013,552 3,674,546 378,908 5,309,190 3,295,638 Total/Average $ 523,734,302 $ 161,917,255 $ 107,948,739 $ 577,988,105 $ 54,253,803 10 City of Round Rock Valley View Consulting,L.L.C. Market Value Comparison March 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 $ 11,922,479 $ 4,602,630 $ 8,337,548 $ 8,187,561 $ - TexPool N/A 9/30/2015 N/A 52,898,952 23,577,998 41,106,490 35,370,459 TexSTAR N/A 9/30/2015 N/A 214,020 2,844 - 216,864 - TexasDAILY N/A 9/30/2015 N/A 2,417,087 32,192 - 2,449,279 - TexasDAILY N/A 6/1/2021 N/A 2,587 301 267 2,622 - TexasDAILY Select N/A 12/3/2021 N/A 5,354,049 73,314 - 5,427,363 - NexBank N/A 11/29/2016 N/A 12,308,944 10,522,808 - 22,831,752 - Veritex CommunityBank N/A 9/1/2020 N/A 202,075 2,697 - 204,773 - NexBank N/A 1/13/2023 N/A 14,628,873 202,212 324,380 14,506,704 - FFCB 0.90% 1/28/2022 1/18/2024 4,990,000 - 5,000,000 - 10,000 Treasury 2.25% 1/5/2022 1/31/2024 7,978,438 - 8,000,000 - 21,562 Treasury 2.38% 2/14/2022 2/29/2024 13,931,093 - 14,000,000 - 68,907 FHLB 1.88°% 2/28/2022 3/8/2024 14,900,978 - 15,000,000 - 99,023 FAMC 2.58°% 4/18/2022 4/18/2024 9,913,097 - - 9,983,877 70,780 Treasury 2.25°% 3/30/2022 4/30/2024 9,899,219 - - 9,975,650 76,431 FAMC 2.65% 5/9/2022 5/2/2024 2,972,758 - - 2,992,183 19,425 FFCB 2.63% 6/2/2022 5/3/2024 3,022,949 - - 3,042,754 19,805 Treasury 2.50% 6/2/2022 5/31/2024 6,920,430 - - 6,966,129 45,700 FHLB 3.13% 6/23/2022 6/14/2024 19,798,630 - - 19,902,708 104,078 FFCB 3.15°% 7/15/2022 7/15/2024 9,887,025 - - 9,932,830 45,805 Treasury 1.75% 9/29/2022 7/31/2024 9,808,594 - - 9,883,495 74,901 FFCB 3.38°% 8/31/2022 8/26/2024 23,222,007 - - 23,318,655 96,648 FFCB 3.50% 9/16/2022 9/13/2024 1 19,747,616 - - 19,840,528 92,912 FHLB 4.50°% 11/1/2022 10/3/2024 2,988,912 - - 2,987,820 1,092 FHLB 4.50% 11/1/2022 10/3/2024 1,992,608 - - 1,991,880 728 Treasury 0.63% 12/13/2022 10/15/2024 4,834,961 - - 4,878,907 43,946 FFCB 4.38°% 10/17/2022 10/17/2024 6,964,044 - - 6,964,892 848 FHLB 4.53% 12/14/2022 11/18/2024 14,950,895 - - 14,933,727 17,168 Texas Capital Bank 4.71% 1/19/2023 12/13/2024 5,219,956 61,588 - 5,281,544 - Independent Financial Bank 4.50% 1/31/2023 12/31/2024 10,331,538 117,081 - 10,448,619 Independent Financial Bank 4.50°% 1/31/2023 1/31/2025 5,165,769 58,540 - 5,224,309 - American Nat'l Bank&Trust 4.50% 2/10/2023 2/10/2025 10,379,904 116,890 - 10,496,793 - FHLB 4.50% 2/24/2023 2/13/2025 4,989,325 - - 4,974,015 15,310 FHLB 4.69% 2/15/2023 3/14/2025 20,006,400 - - 19,925,938 80,462 Veritex Community Bank 5.12°% 3/8/2024 4/8/2025 - 5,000,000 - 5,000,000 - Treasury 2.63% 2/24/2023 4/15/2025 4,876,563 - - 4,879,577 3,014 American Nat'l Bank&Trust 4.50°% 3/30/2023 4/28/2025 10,341,654 116,459 - 10,458,113 - Texas Bank 4.56% 6/15/2023 5/8/2025 5,126,356 58,544 - 5,184,901 - American Nat'l Bank&Trust 4.50% 3/30/2023 5/15/2025 10,325,136 116,273 - 10,441,409 - American Nat'l Bank&Trust 5.00% 11/24/2023 5/22/2025 5,026,093 63,042 - 5,089,135 - American Nat'l Bank&Trust 5.00% 11/29/2023 5/29/2025 5,021,964 62,990 - 5,084,954 - Texas Bank 4.56% 6/15/2023 6/12/2025 3,075,814 35,127 - 3,110,940 - FHLB 4.75% 7/7/2023 6/13/2025 5,019,156 - - 4,989,335 29,821 American Nat'l Bank&Trust 4.56°% 6/22/2023 6/19/2025 8,195,227 93,696 - 8,288,923 - FHLB 4.75% 6/22/2023 6/20/2025 8,034,758 - - 7,985,652 49,106 FHLB 4.81°% 3/7/2024 7/7/2025 - 5,000,000 - 4,992,008 7,992 American Nat'l Bank&Trust 5.10% 9/14/2023 7/14/2025 3,038,307 38,796 - 3,077,103 - FHLB 3.60% 8/28/2023 7/18/2025 493,565 - - 491,689 1,876 FHLMC 0.38% 8/28/2023 7/21/2025 4,698,760 - - 4,719,734 20,974 FFCB 4.88% 8/16/2023 7/28/2025 5,038,244 - - 4,992,798 45,446 American Nat'l Bank&Trust 5.10°% 9/19/2023 8/19/2025 5,063,845 64,660 - 5,128,505 - FAMC 5.18°% 9/27/2023 8/27/2025 10,112,236 - - 10,035,896 76,340 11 City of Round Rock Valley View Consulting, L.L.C. Market Value Comparison March 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 American Nat'l Bank&Trust 5.25% 11/9/2023 9/9/2025 4,017,260 52,812 - 4,070,072 Wallis Bank 5.30% 11/15/2023 9/15/2025 6,000,000 80,153 - 6,080,153 - American Nat'l Bank&Trust 5.00% 12/7/2023 10/2/2025 5,017,151 62,929 - 5,080,081 - American Nat'l Bank-&Trust 4.90% 12/14/2023 10/9/2025 5,012,096 61,601 - 5,073,697 - TVA 0.00% 1/30/2024 11/1/2025 - 9,232,490 - 9,259,293 26,803 NA 0.00% 1/19/2024 11/1/2025 - 4,609,708 - 4,629,648 19,940 FNMA 0.50% 1/4/2024 11/7/2025 - 9,316,357 - 9,340,358 31,917 FHLB 4.75% 2/5/2024 12/12/2025 - 15,185,002 - 14,989,409 90,698 FHLB 4.50% 2/14/2024 1/2/2026 - 13,000,000 - 12,950,548 49,452 FHLB 4.70% 2/26/2024 2/13/2026 - 15,000,000 - 14,993,576 6,425 FFCB 4.63% 3/6/2024 3/5/2026 - 20,021,852 - 19,977,234 42,048 Sub Total/Average Fund 000-Pooled Investments 458,300,396 136,643,586 91,768,686 1 503,539,370 479,455 Fund 170-Interest&Sinking GO Bonds TexPool N/A 9/30/2015 N/A 1,678,735 1 19,061,895 - 20,740,630 - TexasDAILY N/A 4/30/2016 N/A 29,509 393 29,902 - Sub Total/Average Fund 170-Interest&Sinking GO Bonds 1,708,244 19,062,288 - 20,770,532 - Fund 462-2017 Bond Fund TexPool N/A 5/30/2017 N/A 2,215,190 29,561 - 2,244,751 - NexBank N/A 3/30/2020 N/A 1,731,400 22,401 0 1,753,801 - Sub TotallAvera a Fund 462-2017 Bond Fund 3,946,590 51,962 0 3,998,552 - Fund 465-Road CO Bond Fund TexPool N/A 9/1/2020 N/A 1 18,610,278 110,538 15,722,947 2,997,869 - American Nat'l Bank&Trust 4.85% 4/10/2023 4/10/2024 10,328,855 125,398 - 10,454,253 - Sub Total/Average Fund 465-Road CO Bond Fund 28,939,133 235,936 15,722,947 1 13,452,123 - Fund 591 -Reserves Fund TexPool N/A 9/30/2015 N/A 9,316 124 - 9,440 - NexBank N/A 4/29/2019 N/A 922,293 11,933 - 934,226 - Sub Total/Average Fund 591 -Reserves Fund 931,608 1 12,057 - 943,665 - Fund 602-Interest&Sinking Revenue Bonds TexPool N/A 9/30/2015 N/A 2,629,810 1 1,904,298 - 4,534,108 - Sub Total/Average Fund 602-Interest&Sinking Revenue Bonds 2,629,810 1 1,904,298 - 4,534,108 - Fund 604-2022 SIB Loan TexPool N/A 9/29/2022 N/A 2,931,202 1 38,603 1 78,198 1 2,891,607 - American Nat'l Bank&Trust N/A 9/19/2023 N/A 671 1 6 1 - 677 - American Nat'l Bank&Trust N/A 11/21/2022 N/A 21,165,587 293,974 - 21,459,561 - Sub Total/Average Fund 604-2022 SIB Loan 24,097,461 332,582 78,198 24,351,845 - Fund 605-Kalahari Debt Service Reserve TexPool N/A 8/30/2019 N/A 2,013,552 3,674,546 378,908 5,309,190 - Sub Total/Average Fund 605-Kalahari Debt Service Reserve 2,013,552 3,674,546 378,908 5,309,190 - Total/Average $ 522,566,794 $ 161,917,255 $ 107,948,739 $ 576,899,384 $ 479,455 12 City of Round Rock Valley View Consulting,L.L.C. Holdings by Allocation and Portfolio Fund December 31, 2023 Coupon Settlement Face Amount/ Market Days to YTM @ Issuer Rate Credit Rating Date Shares Book Value Price Market Value Maturity Date Maturity Book Fund 000-Pooled Investments NexBank 5.60% 11/29/2016 $ 12,308,944 $ 12,308,944 100.00 $ 12,308,944 N/A 1 5.60% TexasDAILY 5.38% AAAm 6/1/2021 2,587 2,587 100.00 2,587 N/A 1 5.38% TexasDAILY Select 5.55% AAAm 12/3/2021 5,354,049 5,354,049 100.00 5,354,049 N/A 1 5.55% Veritex Community Bank 5.33% 9/1/2020 202,075 202,075 100.00 202,075 N/A 1 5.33% JPMor an Chase 0.31% 9/30/2015 11,922,479 11,922,479 100.00 11,922,479 N/A 1 0.31% TexSTAR 5.34% AAAm 9/30/2015 214,020 214,020 100.00 214,020 N/A 1 5.34% TexPool 5.37% AAAm 9/30/2015 52,898,952 52,898,952 100.00 52,898,952 N/A 1 5.37% NexBank 5.60% 1/13/2023 14,628,873 14,628,873 100.00 14,628,873 N/A 1 5.60% TexasDAILY 5.38% AAAm 9/30/2015 2,417,087 1 2,417,087 100.00 2,417,087 N/A 1 5.38% FFCB 0.90% Aaa/AA+/AA+ 1/28/2022 5,000,000 4,999,327 99.80 4,990,000 1/18/2024 18 1.19% Treasury 2.25% Aaa/AA+/AA+ 1/5/2022 8,000,000 8,009,969 99.73 7,978,438 1/31/2024 31 0.77% Treasury 2.38% Aaa/AA+/AA+ 2/14/2022 14,000,000 14,017,529 99.51 13,931,093 2/29/2024 60 1.60% FHLB 1.88% Aaa/AA+/-- 2/28/2022 15,000,000 15,007,315 99.34 14,900,978 3/8/2024 681 1.61% FAMC 2.58% 4/18/2022 10,000,000 10,000,000 99.13 9,913,097 4/18/2024 1091 2.58% Treasury 2.25% Aaa/AA+/AA+ 3/30/2022 10,000,000 9,993,982 98.99 9,899,219 4/30/2024 121 2.44% FAMC 2.65% 5/9/2022 3,000,000 2,999,254 99.09 2,972,758 5/2/2024 123 2.73% FFCB 2.63% Aaa/AA+/AA+ 6/2/2022 3,051,000 3,050,545 99.08 3,022,949 5/3/2024 124 2.67% Treasury 2.50% Aaa/AA+/AA+ 6/2/2022 7,000,000 6,995,553 98.86 6,920,430 5/31/2024 152 2.66% FHLB 3.13% Aaa/AA+/-- 6/23/2022 20,000,000 19,998,831 98.99 19,798,630 6/14/2024 166 3.14% FFCB 3.15% Aaa/AA+/AA+ 7/15/2022 10,000,000 10,001,207 98.87 9,887,025 7/15/2024 197 3.13% Treasury 1.75% Aaa/AA+/AA+ 9/29/2022 10,000,000 9,865,089 98.09 9,808,594 7/31/2024 2131 4.18% FFCB 3.38% Aaa/AA+/AA+ 8/31/2022 23,500,000 23,475,339 98.82 23,222,007 8/26/2024 2391 3.54% FFCB 3.50% Aaa/AA+/AA+ 9/16/2022 20,000,000 19,937,220 98.74 19,747,616 9/13/2024 257 3.97% FHLB 4.50% Aaa/AA+/-- 11/1/2022 2,000,000 1,997,712 99.63 1,992,608 10/3/2024 277 4.66% FHLB 4.50% Aaa/AA+/-- 11/1/2022 3,000,000 2,996,567 99.63 2,988,912 10/3/2024 277 4.66% Treasury 0.63% Aaa/AA+/AA+ 12/13/2022 5,000,000 4,857,207 96.70 4,834,961 10/15/2024 289 4.43% FFCB 4.38% Aaa/AA+/AA+ 10/17/2022 7,000,000 7,000,316 99.49 6,964,044 10/17/2024 291 4.37% FHLB 4.53% Aaa/AA+/-- 12/14/2022 15,000,000 15,000,000 99.67 14,950,895 11/18/2024 323 4.53% Texas Capital Bank 4.71% 1/19/2023 5,219,956 5,219,956 100.00 5,219,956 12/13/2024 348 4.71% Independent Financial Bank 4.50% 1/31/2023 10,331,538 10,331,538 100.00 10,331,538 12/31/2024 366 4.50% Independent Financial Bank 4.50% 1/31/2023 5,165,769 5,165,769 100.00 5,165,769 1/31/2025 397 4.50% American Nat'l Bank&Trust 4.50% 2/10/2023 10,379,904 10,379,904 100.00 10,379,904 2/10/2025 407 4.50% FHLB 4.50% Aaa/AA+/-- 2/24/2023 5,000,000 4,981,479 99.79 4,989,325 2/13/2025 410 4.85% FHLB 4.69% Aaa/AA+/-- 2/15/2023 20,000,000 20,000,000 100.03 20,006,400 3/14/2025 439 4.69% Treasury 2.63% Aaa/AA+/AA+ 2/24/2023 5,000,000 4,876,794 97.53 4,876,563 4/15/2025 4711 4.65% American Nat'l Bank&Trust 4.50% 3/30/2023 10,341,654 10,341,654 100.00 10,341,654 4/28/2025 484 4.50% Texas Bank 4.56% 6/15/2023 5,126,356 5,126,356 100.00 5,126,356 5/8/2025 494 4.56% American Nat'l Bank&Trust 4.50% 3/30/2023 10,325,136 10,325,136 100.00 10,325,136 5/15/2025 501 4.50% American Nat'l Bank&Trust 5.00% 11/24/2023 5,026,093 5,026,093 100.00 5,026,093 5/22/2025 508 5.00% American Nat'l Bank&Trust 5.00% 11/29/2023 5,021,964 5,021,964 100.00 5,021,964 5/29/2025 515 5.00% Texas Bank 4.56% 6/15/2023 3,075,814 3,075,814 100.00 3,075,814 6/12/2025 529 4.56% FHLB 4.75% Aaa/AA+/-- 7/7/2023 5,000,000 4,969,514 100.38 5,019,156 6/13/2025 530 5.19% American Nat'l Bank&Trust 4.56% 6/22/2023 8,195,227 8,195,227 100.00 8,195,227 6/19/2025 536 4.56% FHLB 4.75% Aaa/AA+/-- 6/22/2023 8,000,000 8,000,000 100.43 8,034,758 6/20/2025 537 4.75% American Nat'l Bank&Trust 5.10% 9/14/2023 3,038,307 3,038,307 100.00 3,038,307 7/14/2025 561 5.10% FHLB 3.60% Aaa/AA+/-- 8/28/2023 500,000 1 488,200 98.71 493,565 7/18/2025 565 5.22% FHLMC 0.38% Aaa/AA+/AA+ 8/28/2023 5,000,000 4,653,543 93.98 4,698,760 7/21/2025 568 5.11% FFCB 4.88% Aaa/AA+/AA+ 8/16/2023 5,000,000 4,988,272 100.76 5,038,244 7/28/2025 575 5.03% 13 City of Round Rock Valley View Consulting,L.L.C. Holdings by Allocation and Portfolio Fund December 31, 2023 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.10% 9/19/2023 5,063,845 5,063,845 100.00 5,063,845 8/19/2025 597 5.10% FAMC 5.18% 9/27/2023 10,000,000 10,000,000 101.12 10,112,236 8/27/2025 605 5.18% American Nat'l Bank&Trust 5.25% 11/9/2023 4,017,260 4,017,260 100.00 4,017,260 9/9/2025 618 5.25% Wallis Bank 5.30% 11/15/2023 6,000,000 6,000,000 100.00 6,000,000 9/15/2025 624 5.30% American Nat'l Bank&Trust 5.00% 12/7/2023 5,017,151 5,017,151 100.00 5,017,151 10/2/2025 641 5.00% American Nat'l Bank&Trust 4.90% 12/14/2023 5,012,096 5,012,096 100.00 5,012,096 10/9/2025 648 4.90% Sub Total/Average 3.93% 460,358,139 459,467,904 99.55 458,300,396 260 4.09% Fund 170-Interest&Sinking GO Bonds TexasDAILY 5.38% AAArn 1 4/30/2016 1 29,509 1 29,509 1 100.00 1 29,509 1 N/A 1 5.38% TexPool 5.37% AAArn 9/30/2015 1,678,735 1,678,735 100.00 1,678,735 N/A 1 5.37% Sub Total/Average 5.37% 1,708,244 1,708,244 100.00 1,708,244 1 5.37% Fund 462-2017 Bond Fund TexPool 5.37% AAArn 5/30/2017 2,215,190 2,215,190 100.00 2,215,190 N/A 1 5.37% NexBank 5.60% 3/30/2020 1,731,400 1,731,400 100.00 1,731,400 N/A 1 5.60% Sub Total/Average 5.47% 1 3,946,590 3,946,590 100.00 3,946,590 1 5.47% Fund 465-Road CO Bond Fund TexPool 5.37% AAArn 9/1/2020 1 18,610,278 1 18,610,278 100.00 1 18,610,278 N/A 1 5.37% American Nat'l Bank&Trust 4.85% 4/10/2023 10,328,855 10,328,855 100.00 10,328,855 4/10/2024 1011 4.85% Sub Total/Average 5.18% 28,939,133 28,939,133 100.00 28,939,133 1 371 5.18% Fund 591 -Reserves Fund TexPool 5.37% AAArn 9/30/2015 9,316 9,316 100.00 9,316 N/A 11 5.37% NexBank 5.60% 4/29/2019 922,293 922,293 100.00 922,293 N/A 1 5.60% Sub Total I Average 5.60% 931,608 931,608 100.00 931,608 1 5.60% Fund 602-Interest&Sinking Revenue Bonds TexPool 5.37% AAArn 9/30/2015 2,629,810 2,629,810 100.00 2,629,810 N/A 1 5.37% Sub Total/Average 5.37% 2,629,810 2,629,810 100.00 2,629,810 1 1 5.37% Fund 604-2022 SIB Loan TexPool 5.37% AAArn 9/29/2022 2,931,202 2,931,202 100.00 2,931,202 N/A 1 5.37% American Nat'l Bank&Trust 0.35% 9/19/2023 671 671 100.00 671 N/A 1 0.35% American Nat'l Bank&Trust 5.56% 11/21/2022 21,165,587 21,165,587 100.00 21,165,587 N/A 1 5.56% Sub Total/Average 5.54% 24,097,461 24,097,461 100.00 24,097,461 1 5.54% Fund 605-Kalahari Debt Service Reserve TexPool 537% AAArn 1 8/30/2019 1 2,013,552 2,013,552 100.00 2,013,552 N/A 1 5.37% Sub Total/Average 5.37% 1 1 2,013,552 1 2,013,552 100.00 2,013,552 1 5.37% Total/Average 4.10% 1 1 $ 524,624,538 $ 523,734,302 99.61 1 $ 522,566,794 2301 4.25% 14 City of Round Rock Valley View Consulting,L.L.C. doom ROUND ROCK BY THE NUMBERS FY 2024 Quarter 2 Citywide Sales Tax, Net of Incentives Property Tax Totals through March 2024=$573M fno,000,oao $40,000,000 $w0,000,000 fJs000,000 $90,000,000 fao,000,000 $x0,000,000 $70,000,000 $25,000,000 $410,000,000 SK000,000 -... $20,000,000 $40,000,000 - fto000.0011 $20,000,000 - --- - - $10,000,000 $ s Oet Mov 0- Jan Fab Mar Apr May Jun Jul Aug Sap Oct Nov Dec Jan Fab Mar Apr May Jun Jul Aug Sept e♦FY 2024 Actuals FY 2023 Actuals ■FY 24 Actuale R FY 23 Actuals GeneralOther • Revenues — Prior to Incentives $4,000,000 - ---—- $16,000,000 - $3.500,000 $14,000,000 f3,0o0,000 $1z,000,000 -- $21500,000 - $10,000,000 $2,0001000 fa,000,000 $7400,000 $6.000,000 -- - - $1A00,000 $4.000,000 $500,000 $2,00,000 ---- s s oth.Tassea licensee. S-Ace progrern Fl—A 0rarrta corWactsa Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep FranehW Marmite& Chargee Revenue Ferrkurse Other Fees Fee' ■FY 24 Other Motels s FY 24 Kalahari ■FY 23 Other Notal FY 23 Kalahari a FY 2024 Actuals ■FY 2023 Actuals Comments Sales Tax Citywide total sales tax collections,net of all incentives,increased 5.7%over the prior year.However,FY 2024 first quarter sales tax includes$3.1M for amended returns from FY 2023.When adjusted out,the citywide collections increased 1.9%.Dell receipts,net of incentives and adjustments factored out,decreased 13.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 81%tax rate increase for FY 2024 and new properties added. Other General Fund Revenues are trending as follows: License,Permits,and Fees decreased 42.5%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 16%.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,FY 24 has seen a significant increase in lot clearing services, including one large lien payoff. Program Revenues increased 5.7%.This is attributed to higher participation in City programs at CMRC and the Library. Fines and Forfeitures revenues decreased 6.5%due to fewer citations and cases filed than last year. Grants have decreased 62.7%.In FY 2023,the City received two large reimbursements due to COVID vaccination clinics and wildfire deployments.Also,a one-time APPA reimbursement was received for CRU vehicles. Contracts and Other increased 41.5%.This is due to higher interest earnings and insurance proceeds collected from the hailstorm. Hotel Occupancy&Venue Tax revenues for FY 2024 have increased 5.4%over prior year.This is due to an additional hotel opening adding 119 rooms along with higher average daily room rates. 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 in line with budget. ,;. ROUND ROCK BY THE NUMBERS FY 2024 Annual Facts FY 2023 2024 . Budget Revenues = $S43.9M 59.9 �S15.a 517.7 Source Amount(in Mallem) flea Sales Tax $ 113.9 51as Use of Fund Balance $ 96.7 Property Tax $ 81.9 Bond Proceeds $ 67.3 Utility&Garbage Charges $ 61.4 SW Contracts&Other $ 60.5 Fines,Permits&Fees $ 18.8 Other Taxes&Franchise Fees $ 17.7 l� Hotel occupancy/venue Tax $ 15.8 Program Revenues $ 9.9 FY 2023 2024 $1.7 $33 ta2 $ae $7.0 5n'e Deperbnemt Amount On Mlabns) Deponment Amount(7n Mlaioru) fDe Capital Improvement Projects $ 200.4 0 Transportation S 13.8 $20.1 Police S 445 0 Sports Management $ 11.8 Debt Payments $ 429 0 General Services $ 9.2 $2ao a Support Services $ 39.9 0 Planning&Development $ 7.0 sa4.o Utilities&Environmental Svcs $ 38.2 Library $ 4.9 Fire $ 36.1 � Fleet Replacement $ 42 ■ Funding Transfers Out $ 34.0 Communications $ 33 '2 General Self Financed Const. $ 31.9 Com.&Neighborhood Srv. $ 1.7 S4..s $41.9 Sas.. Parks&Recreation $ 20.1 Other Information CORR Tax Information Taxing Entities Top 10 Property Tax Payers FY 23-24 FY 22-23 Entity Rate Business Amount(In rrmf•orma) Population 134,540 128,957 City of Round Rock $ 03420 Kalahari Resorts $ 531.8 Property Tax Rate $ 0.34200 $034200 Williamson County $ 0.3774 Dell Computer Holdings LP 459.1 M&00.224400 Debt 0.117600 Round Pock ISD $ 0.9190 CMF 15 Porftlio(coboialGrndAp.) 1665 Outstanding Debt as of 10/01/23 Austin Community College $ 0.0986 CPF,RR,LP(Round Rock outlets) 162.8 Upper Brushy Creek $ 0.0170 TX Essential Housing(Lakeside @ LF) 151.1 Bond Amount O/5(in millions) Total Tax Rate $ 1.7540 Dell Computer Corp 1355 GO&CO Bonds $ 292.9 Capital Lease/LTNs $ 5.8 Taxable Values 2811 La Frontera LP(The District on LF) 1015 FY 23-24 FY 22-23 36 Hundred Apts(Avery centre) 100.0 Utility/Stormwater $ 103.7/5.2 HOT $ 6.7 Median Home Values $ 363,396 $ 369,169 Stanmore Warner Ranch Apts 99.9 Taxable Property Value(n billions) $ 24.1 $ 21.7 TMP Parkside LLC(Parkside @ PR) 953 Type B $ 66.0 City Employees Bond Ratings(Rated by S&P) Swom FTEs Total FTEs GO Bonds AAA City Wide 369 1,174.85 Utility Bonds AAA Police 200 287.2 Fire 169 194.0