Loading...
R-2024-025 - 2/8/2024 RESOLUTION NO. R-2024-025 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, 2023 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 February, 2024. CRMOR , Mayor City f Roun ock,Texas ATTEST: QaAZU, SOMLm,� MEAGAN SPPiK-8, City Clerk Dave)kk &awards 0112.20242;4878-81268640 EXHIBIT A„ 00 jp�MaU�ND ROCK TEXAS QUARTERLY INVESTMENT REPORT For the Quarter Ended December 31, 2023 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 not included for security purposes signatures not included for security purposes Chief Financial Officer Deputy Chief Financial Officer signatures not included for security purposes signatures not included for security purposes Controller Treasury Accountant CnA'dO4✓✓ Valley Vie4 C nsulting, 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,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 Mone 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 $ 522,566,794 September 30, 2023 YTM Description Cost Book Value Market Value Cash 0.29% $ 12,613,359 $ 12,613,359 Certificates of Deposit 4.62% 85,598,636 85,598,636 Local Government Investment Pool 5.35% 58,990,778 58,990,778 Money Market Accounts 5.54% 50,247,872 50,247,872 US Agency 3.54% 227,442,977 224,918,422 US Treasury 2.06% 88,557,526 87,610,724 Total/Average 3.78% $ 523,451,146 $ 519,979,790 Average Yield Current Fiscal Year- Quarter(1) to-Date(2) Total Portfolio 4.25% 4.25% TexPool Yield 5.37% 5.37% Rolling Three Mo.Treas. Yield 5.53% 5.53% Rolling Six Mo.Treas.Yield 5.49% 5.49% Rolling 1 Yr.Treas. Yield 5.08% 5.08% Rolling 2 Yr.Treas. Yield 3.79% 3.79% Investment Income(3) Interest Income(Approximate) $ 5,058,775 $ 5,058,775 WAM at 12/31/2023 Policy WAM Max Total Portfolio 230 days 540 days Pooled Funds 260 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/2023 The Federal Open Market Committee(FOMC)maintained the Fed Funds target range 5.25%-5.50%(Effective Fed Funds are trading+/-5.33%). Any additional actions, up or down,will be data- dependent. Final Third Quarter 2023 GDP revised downward to 4.9%,but still robust growth. December Non-Farm Payroll posted 216k new jobs(above the estimated 170k). The Three Month Rolling Average declined to 165k. The S&P 500 Stock Index reached a new peak trading over 4,770(exceeding 4,766 in Dec 2021). The yield curve shifted lower anticipating future FOMC target reductions. Crude Oil stabilized at+/-$73 per barrel. Inflation continued to decline but still remained above the FOMC 2%target(Core PCE+/-3.2%and Core CPI+/4.0%). Reduced global economic outlooks and ongoing/expanding military conflicts increase uncertainty. 6.00 Treasury Yield Curves 5250 S&P 500 5:000 4,750 5.00 4,500 - 4,250 4,000 4.00 3,750 3,500 3,250 3.00 3,000 2,750 2,500 2,250 2.00 - 2,000 WoMeME 1,750 1,500 1.00 1,250 1,000 750 0.00 250 F' ��Q' o C ra y`�J ti'l� �!! yy" ,gyp ,�h 1,.�6 ,�1 N'b coN �O 11a11 , �f •December 31,2023 September 30,2023 December 31,2022 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 JJW 4.50 4.50 4.00 - - 4.00 -- -- - WA 3.50 3.50 - 3.00 3.00 2,50 A. 2.50 ILA I 2.002.00 1.50 1.50 1.00 1.00 r 0.500.50 •v.. 0.00 0.00lbsft �`) e�l`j �`) a�) �`) 1 � ) 1sr) )� ) 1ti3�) 1�]J,�) 1�`) , ��ryes`)�ry2�) �j 'V ��' �1e9 . � '00A 1 100 1 40ry 1�0 L 10 l terry to 1 L L l •Six Month T-8111 Two Year T-Note Ten Year T-Note •Sb[Month Till Two Year T-Note - Ten Year T-Note Valley View Consulting,L.L.C. 2 Holdings by Investment Category December 31,2023 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 $ 11,922,479 2% $ - 0% $ - 0% $ - 0% $ 11,922,479 2% Certificates of Deposit 106,358,071 20% - 0% - 0% 10,328,855 2% 116,686,927 22% Investment Pools 60,886,696 12% 4,338,054 1% 2,022,867 0% 23,756,670 5% 91,004,288 17% Money Market Accounts 27,139,893 5% - 0% 922,293 0% 22,897,658 4% 50,959,844 10 Municipal - 0% - 0% - 0% - 0% - 0% US Agency 194,544,641 37% - 0% - 0% 0% 194,544,641 37% US Treasury 58,616,124 11% - 0% - 0% - 0% 58,616,124 11% Total/A S 459,467,904 88% $ 4,338,054 1 1% 1 $ 2,945,160 1 1% 1 $ 56,983,184 11% $523,734,302 100% Portfolio Balances (Millions) Order of Liquidity $600 - - ■Cash $500 -- o Local Government Investment Pool $400 - a 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/2023 12/31/2023 1213112023 12/3112023 12131/2023 City of Round Rock Valley View Consulting,L.L.C. 3 Investment Holdings by Investment Category Quarterly Transactions By Investment Category December 31, 2023 December 31, 2023 %of Portfolio Net Cash Equivalent Description Book value Portfolio Limttatlon Description Buys Sells Maturities Calls Interest Deposit/(Withdrawal) Cash $ 11,922,479 2.3% 100% Cash $ - $ - $ - $ - $ - $ 690,880 Investment Pools 91,004,288 17.4% 100% Investment Pools - - - - 777,947 32,013,510 Money Market Accounts 50,959,844 9.7% 75% Money Markets Accounts - - - - 711,982 711,972 Certificates of Deposit 116,686,927 22.3% 85% Certificates of Deposit 31,088,291 - - - 1,088,291 - Commercial Paper - 0.0% 10%/5% Commercial Paper - - - - - Municipal - 0.0% 35%/5% Municipal - - - - - US Agency 194,544,641 37.1% 85% USA en - - 33,000,000 - 1,789,350 - US Treasury 58,616,124 11.2%, 85% US Treasury - - 30,000,000 - 509,512 - Total/Average 1 $ 523,734,302 100% PASSED Totals $ 31,088,291 $ - $ 63,000,000 $ - $ 4,877,082 $ 32,034,603 Portfolio Balances(Millions) Portfolio Composition Order of Liquidity Money Market Accounts December 31,2023 $600 - 97% Certificates of r Cash $500 �- Deposit Investment Pools 22.3 ❑Local Government 17.4% $400 Investment Pool ■Money Market Account $300 ■US Treasury Cash 2.3°/ $200 D US Agency $100 D Municipal US Treasury 11.2/ $0 ■Certificates of Deposit Ktiti \rye \ry9 \rye \rye „�� ,y0 ,y0 _\'� US Agency 411 ^b\ (p� 0� 4.V 37.1% City of Round Rock Valley View Consulting,L.L.C. 4 City of Round Rock Pooled Funds Performance 5.50 - __ -- 5.00 - 4.50 -_ - 4.00 3.50 / M c 3.00 (D a 2.50 2.00 --- - -- 1.50 1.00 - 0.50 0.00 �g �� �O �O �O q �O �O ,�O �O �.°' �°' O O o O �. �. �. `L `L `L 'L 3 O o O O O O O O O O O O O O O O O O o O O O`1' o`t Off' Off' Off' Off' O� O`l O� & O & O`l' O`l' Off' O`1' N�� O�� O\ti '��� '� o�� Opti '` '`�� O�� o�� �`�� �`�� O�� O�� ��� `\T O\ry O&T '\ry 0�3�rL3 OHO o\3 `� ^��`� O\^� °�\`b `� �`� O\"b O\O `5 "t�`� O\"� °b\`5 y0 "b\O �°\O 0\� O �O 0\3 OHO O �O 0�0 O�"� O O�^� 'b 6j Round Rock TexPool Rolling 1.5 yr Treasury (Policy WAM max) i Rolling 9 mo Treasury City of Round Rock Valley View Consulting,L.L.C. 5 Portfolio Balances By Fund (Millions) $600 $500 ■Capital Project& Special Purpose Funds $400 0 Debt Service Reserve $300 Funds $200 o Debt Service Funds $100 ■Pooled Funds $0 osh o^5 0^6 0,�6 0^6 0.�6 0�1 0,�1 0,�� 0,�1 0,�0 0,�0 o,e o,�0 o,A o,�A o,�a o,�A oryo oryo oryo oryo ory�. Drys ory�. Drys o,�. o,�. o,�. oryry ory� ory� ory� ory� 0\��\��^�'\fir`\�'\gyp\�'\gyp\��r�\�'\fir`\�'\gyp\�'\��\��r��'\�r�\M1'\gyp\`l'\��\��r�\�'\��\�'\��\�'\��\��r�\�'�\fir`\�'\gyp\�'\gyp\��^\`L\�^\,L\��\'l•\��\��^\`11\�^\`Y\��\`I•\��\��^\`Lg\�^ \'l•\��\'l•\��\^��^\`L City of Round Rock Valley View Consulting,L.L.C. e 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 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 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 68 1.61% FAMC 2.58% 4/18/2022 10,000,000 10,000,000 99.13 9,913,097 4/18/2024 109 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 213 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 239 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.6677- FHLB .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 2891 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 2911 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 51219,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 165769 100.00 1 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 4391 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 471 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 4841 4.50% Texas Bank 4.56% 6/15/2023 5,126,356 5,126,356 100.00 5,126,356 5/8/2025 4941 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 5371 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 488,200 1 98.71 1 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% 7 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 Credit Rating Book Value Market Value Maturity Date Rate Date Shares Price 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.300/6 1 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% AAAm 4/30/2016 29,509 29,509 1 100.00 29,509 N/A 1 5.38% TexPool 5.37% AAAm 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% AAAm 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% 3,946,590 3,946,590 1 100.00 3,946,590 11 5.47% Fund 465-Road CO Bond Fund TexPool 5.37% AAAm 9/1/2020 18,610,278 18,610,278 100.00 18 610,278 N/A 1 I 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 10ii 4.85% Sub Total/Average 5.18% 1 28,939,133 28,939,133 100.00 1 28 939,133 1 1 371 5.18% Fund 591 -Reserves Fund TexPool 5.37% AAAm 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/A1 5.60% Sub Total/Average 5.60% 931,608 931,608 100.00 931,608 1 11 5.60% Fund 602-Interest&Sinking Revenue Bonds TexPool 5.37% AAAm 1 9/30/2015 2,629,810 2,629,810 1 100.00 2,629,810 N/A 1 5.37% Sub Total/Average 5.37% 2,629,810 1 2,629,810 1 100.00 2,629,810 1 5.37% Fund 604-2022 SIB Loan TexPool 5.37% AAArn 1 9/29/2022 1 2,931,202 1 2,931,202 100.00 2,931,202 N/A 1 5.37% American Nat'l Bank&Trust 0.35% 1 9/19/2023 1 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% 1 24,097,461 24,097,461 100.00 24,097,461 11 5.54% Fund 605-Kalahari Debt Service Reserve TexPool 5.37% AAAm 8/30/2019 2,013,552 2 013,552 100.00 2,013,552 N/A 1 5.37% Sub Total/Average 5.37% 2,013,552 2,013,552 100.00 2,013,552 1 5.37% Total/Average 4.10% 1 $ 524,624,538 $ 523,734,302 99.61 $ 522,566,794 230 4.25% 8 City of Round Rock Valley View Consulting,L.L.C. Book Value Comparison December 31, 2023 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 M12613359 $ 7091097 $ 7781977 $ 11922479 $ 690880 TexPool N/A 9/30/2015 N/A 46,540,551 10,363,528 52,898,952 36,177,023 TexSTAR N/A 9/30/2015 N/A 2,850 — 214,020 2,850 TexasDAILY N/A 9/30/2015 N/A 32400 — 2417087 32400 TexasDAILY N/A 6/1/2021 N/A 35 — 2587 35 TexasDAILY Select N/A 12/3/2021 N/A5 74,614 — 5,354,049 74,614 NexBank N/A 11/29/2016 N/A , 2 618,532 — 12,308,944 618,532 Veritex Community Bank N/A 9/1/2020 N/A 199,414 2 662 — 202,075 2 662 NexBank N/A 1/13/2023 N/A 14,870,227 206,545 447,898 14,628,873 (241,354 Treasury 0.25% 9/30/2021 10/2/2023 10,000,000 — 10,000,000 — 10,000,000 FHLMC 2.00% 2/28/2022 10/17/2023 5,001,058 — 5,000,000 — 5,001,058 Treasury 2.88% 11/22/2021 10/31/2023 10.020,268 — 10,000,000 — (10,020,268 FHLB 0.50% 11/12/2021 11/9/2023 4,999,875 — 5,000,000 — (4,999,875 Treasury 2.88% 11/10/2021 11/30/2023 5,020,222 — 5000 000 — (5,020,222) Treasury0.50% 6/23/2022 11/30/2023 4,979,508 — 5:000!000 — (4,979,508 FHLB 0.50% 12/7/2021 12/8/2023 7,997,463 — 8,000,000 — (7,997,463 FHLB 5.00% 12/19/2022 12/19/2023 10,000,000 — 10 000,000 — 10,000 000 FHLB 0.63% 1/5/2022 12/22/2023 4,998,353 — 5,000,000 — (4,998,353 FFCB 0.90% 1/28/2022 1/18/2024 4,995,724 — — 4,999,327 3,603 Treasury 2.25% 1/5/2022 1/31/2024 8,039,556 — — 8,009,969 29 587 Treasury 2.38% 2/14/2022 2/29/2024 14,044,408 — — 14,017,529 26,878 FHLB 1.88% 2/28/2022 3/8/2024 15,016,997 — — 15 007,315 9,682 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,989,406 — — 91993,982 4 576 FAMC 2.65% 5/9/2022 5/2/2024 2,998,693 — — 2,999,254 561 FFCB 2.63% 6/2/2022 5/3/2024 3,050,205 — — 3,050545 340 Treasury 2.50% 6/2/2022 5/31/2024 6,992,861 — — 6,995,553 2,692 FHLB 3.13% 6/23/2022 6/14/2024 19 998,178 — — 19,998,831 653 FFCB 3.15% 7/15/2022 7/15/2024 10,001,773 — — 10,001,207 566 Treasury 1.75% 9/29/2022 7/31/2024 9,806,818 — — 9,865,089 58 271 FFCB 3.38% 8/31/2022 8/26/2024 23,465,935 — — 23,475,339 9,404 FFCB 3.50% 9/16/2022 9/13/2024 19,914,549 — — 19,937,220 22,671 FHLB 4.50% 11/1/2022 10/3/2024 1,996,946 — — 1,997,712 766 FHLB 4.50% 11/1/2022 10/3/2024 2,995,419 — — 2,996,56 1,148 Treasury 0.63% 12/13/2022 10/15/2024 4,811,750 — — 4,857,207 45,457 FFCB 4.38% 10/17/2022 10/17/2024 7,000,417 — — 7 000 316 101 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,159,087 60 870 — 5,219,956 60,870 Independent Financial Bank 4.50% 1/31/2023 12/31/2024 10,215,667 115,871 — 10,331,538 115,871 Independent Financial Bank 4.50% 1/31/2023 1/31/2025 5,107,834 57,935 — 5,165,769 57,935 American Nat'l Bank&Trust 4.50% 2/10/2023 2/10/2025 10,264.315 115,588 — 10,379,904 115,588 FHLB 4.50% 2/24/2023 2/13/2025 4,977,286 — — 4,981,479 4,193 FHLB 4.69% 2/15/2023 3/14/2025 20,000,000 — — 20 000,000 — Treasury 2.63% 2/24/2023 4/15/2025 4,852,728 — — 4,876,794 24,066 American Nat'l Bank&Trust 4.50% 3/30/2023 4/28/2025 10,226,491 115,162 — 10 341,654 115,162 Texas Bank 4.56% 6/15/2023 5/8/2025 5,067,841. 58 516 — 5,126,356 58 516 American Nat'l Bank&Trust 4.50% 3/30/2023 5/15/2025 10,210,157 114,978 — 10 325,136 114,978 American Nat'l Bank&Trust 5.00% 11/24/2023 5/22/2025 — 5,026,093 — 5,026,093 5,026,093 American Nat'l Bank&Trust 5.00% 11/29/2023 5/29/2025 — 5021,9 — 5,021,964 5,021,964 Texas Bank 4.56% 6/15/2023 6/12/2025 3,040,704 35,109 — 3,075,814 35,109 FHLB 4.75% 7/7/2023 6/13/2025 1 4,964 200 — — 4,969,514 5 315 American Nat'l Bank&Trust 4.56% 6/22/2023 1 6/19/2025 8,101,578 93,649 — 8,195,227 93,649 9 City of Round Rock Valley View Consulting,L.L.C. Book Value Comparison December 31, 2023 Issuer Coupon Settlement Maturity Beginning Book Total Buys/ Total Sells/ Ending Book Change In Book Rate Date Date Value Increases Decreases Value Value FHLB 4.75% 6/22/2023 6/20/2025 8,000 000 - - 8,000,000 - American Nat'l Bank&Trust 5.10% 9/14/2023 7/14/2025 3,000,000 38 307 - 3,038,307 38 307 FHLB 3.60% 8/28/2023 7/18/2025 486,273 - - 488,200 1,928 FHLMC 0.38% 8/28/2023 7/21/2025 4,597,243 - - 4,653,543 56,299 FFCB 4.88% 8/16/2023 7/28/2025 4,986,390 - - 4,988,272 1,882 American Nat'l Bank&Trust 5.10% 9/19/2023 8/19/2025 5,000,000 63 845 - 5,063,845 63 845 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,017 260 - 41017,260 4,017,260 Wallis Bank 5.30% 11/15/2023 9/15/2025 - 6,000 000 - 6,000,000 6,000,000 American Nat'l Bank&Trust 5.00% 12/7/2023 10/2/2025 - 5 01151 - 5 017,151 5,017 151 American Nat'l Bank&Trust 4.90% 12/14/2023 10/9/2025 - 1!0112596 - 5,012 096 5,012,096 Sub Total/Average Fund 000-Pooled Investments 455,367,363 85,533,682 81,593,404 459,467,904 4,100,541 Fund 170-Interest&Sinking GO Bonds TexPool N/A 9/30/2015 N/A 413,284 1,267,306 1,855 1,678,735 1265451 TexasDAILY N/A 4/30/2016 N/A 29,114 396 - 29,509 396 Sub Total/Average Fund 170-Interest&Sinking GO Bonds 442,398 1,267,701 1,855 1,708,244 1 1,265,846 Fund 462-2017 Bond Fund TexPool N/A 5/30/2017 N/A 2,185,492 29,698 - 2.215,190 29,698 NexBank N/A 3/30/2020 N/A 1,707,194 24,206 1 1,731,400 24 206 Sub Total/Average Fund 462-2017 Bond Fund 3,892,686 53,903 1 - 3,946 590 53,903 Fund 465-Road CO Bond Fund TexPool N/A 9/1/2020 N/A 26,029,311 290,038 7,709 071 18 610,278 7,419,033 American Nat'l Bank&Trust 4.85% 4/10/2023 4/10/2024 10,204,961 123,894 - 10,328,855 123,894 Sub Total/Average Fund 465-Road CO Bond Fund 36,234,273 413,932 1 7,709,071 28,939,133 7,295,139 Fund 591 -Reserves Fund TexPool N/A 9/30/2015 N/A 9,191 125 - 9,316 125 NexBank N/A 4/29/2019 N/A 909,399 12,894 - 922,293 12,894 Sub Total/Average Fund 591 -Reserves Fund 918,590 1 13,019 - 931,608 13,019 Fund 602-Interest&Sinking Revenue Bonds TexPool N/A 9/30/2015 N/A 2,476,687 153 123 - 2,629 810 153,123 Sub Total/Average Fund 602-Interest&Sinking Revenue Bonds 1 2,476,687 153,123 - 2,629,810 153,123 Fund 604-2022 SIB Loan TexPool N/A 9/29/2022 N/A 2,891,906 39,297 - 2,931,202 39,297 American Nat'l Bank&Trust N/A 9/19/2023 N/A 434 247 10 671 American Nat'l Bank&Trust N/A 11/21/2022 N/A 20,870,791 294,795 - 21,165,587 294,795 Sub Total/Average Fund 604-2022 SIB Loan 23,763,131 334,339 10 24,097,461 334,329 Fund 605-Kalahari Debt Service Reserve TexPool N/A 1 8/30/2019 N/A 356,018 1,657,534 1 2,013,552 1657534 Sub Total/Average Fund 605-Kalahari Debt Service Reserve 1 356,018 1,657,534 - 2,013,552 1,657,534 Total/Average $ 523,451,146 $ 89,427,234 $ 89,304,340 $ 523,734,302 $ 283,156 10 City of Round Rock Valley View Consulting,L.L.C. Market Value Comparison December 31, 2023 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 $ 12,613,359 $ 7,091,097 $ 7,781 977 $ 11,922,479 $ - TexPool N/A 9/30/2015 N/A 16,721,929 46,540,551 10,363,528 52,898,952 - TexSTAR N/A 9/30/2015 N/A 211,170 2,850 - 214,020 - TexasDAILY N/A 9/30/2015 N/A 2,384,687 32 400 - 2,417,087 - TexasDAILY N/A 6/1/2021 N/A 2,553 35 - 2,587 - TexasDAILY Select N/A 12/3/2021 N/A 5,279,435 74,614 - 5,354,049 - NexBank N/A 11/29/2016 N/A 11,690,412 618,532 - 12 308,944 - Veritex Community Bank N/A 9/1/2020 N/A 199,414 2,662 - 202,075 - NexBank N/A 1/13/2023 N/A 14,870,227 206,545 447 898 14,628 873 - Treasury 0.25% 9130/2021 10/2/2023 10,000,000 - 10,000,000 - - FHLMC 2.00% 2/28/2022 10/17/2023 4,992,717 - 5,000,000 - 7,284 Treasury 2.88% 11/22/2021 10/31/2023 9,982,726 - 10,000,000 - 17,274 FHLB 0.50% 11/12/2021 11/9/2023 4,974465 - 5,000,000 - 25,536 Treasury 2.88% 11/10/2021 11/30/2023 4,979,573 - 5,000 000 - 20,427 Treasury 0.50% 6/23/2022 11/30/2023 4,961,010 - 5,000,000 - 38,990 FHLB 0.50% 12/7/2021 12/8/2023 7,924,958 - 8,000 000 - 75,042 FHLB 5.00% 12/19/2022 12/19/2023 9,988,234 - 10,000,00 11,76 FHLB 0.63% 1/5/2022 12/22/2023 4,946,095 - 5,000,00 - 53,906 FFCB 0.90% 1/28/2022 1/18/2024 4,932,665 - - 4,990,000 57,335 Treasury 2.25% 1/5/2022 1/31/2024 7,918,073 - - 7,978,438 60 365 Treasury 2.38% 2/14/2022 2/29/2024 13,827,073 - - 13,931,093 104,020 FHLB 1.88% 2/28/2022 3/8/2024 14,762,805 - - 14,900,978 138,173 FAMC 2.58% 4/18/2022 4/18/2024 9,829,257 - - 9,913,097 83,840 Treasury 2.25% 3/30/2022 4/30/2024 91815,181 - - 9 899 219 84,038 FAMC 2.65% 5/9/2022 5/2/2024 2,948,698 - - 2,972,758 24 060 FFCB 2.63% 6/2/2022 5/3/2024 21996,535 - - 31022,949 26 414 Treasury 2.50% 6/2/2022 5/31/2024 6,862,955 - - 6,920,430 57,475 FHLB 3.13% 6/23/2022 6/14/2024 19,663,960 - - 19,798,630 134,670 FFCB 3.15% 7/15/2022 7/15/2024 9,813,375 - - 9,887,025 73,650 Treasury 1.75% 9/29/2022 7/31/2024 9,697,271 - - 9,808,594 111 323 FFCB 3.38% 8/31/2022 8/26/2024 23,063,934 - - 23,222,007 158,073 FFCB 3.50% 9/16/2022 9/13/2024 19 632,696 - - 19,747,616 114,920 FHLB 4.50% 11/1/2022 10/3/2024 1,980,192 - - 1,992 608 12,416 FHLB 4.50% 11/1/2022 10/3/2024 2,970,288 - - 2 988,912 18 624 Treasury 0.63% 12/13/2022 10/15/2024 4,758,655 - - 4,834,961 76,306 FFCB 4.38% 10/17/2022 10/17/2024 6,927,500 - - 61964,044 36,544 FHLB 4.53% 12/14/2022 11/18/2024 14,852,3 5 - - 14,950,895 98,580 Texas Capital Bank 4.71% 1/19/2023 12/13/2024 5,159,087 60 870 - 5,219,956 - Independent Financial Bank 4.50% 1/31/2023 12/31/2024 10,215,667 115,871 - 10,331,538 - Independent Financial Bank 4.50% 1/31/2023 1/31/2025 5,107,834 57,935 - 5,165,769 - American Nat'l Bank&Trust 4.50% 2/10/2023 2/10/2025 10,264,315 115,588 - 10,379,904 - FHLB 4.50% 2/24/2023 2/13/2025 4,944,355 - - 41989,325 44 970 FHLB 4.69% 2/15/2023 3/14/2025 19,820,170 - - 20,006,400 186,230 Treasury 2.63% 2/24/2023 4/15/2025 4,808,207 - - 4,876,563 68,356 American Nat'l Bank&Trust 4.50% 3/30/2023 4/28/2025 10,226,491 115,162 - 10,341,654 - Texas Bank 4.56% 6/15/2023 5/8/2025 5,067,841 58 516 - 5,126,356 - American Nat'l Bank&Trust 450% 3/30/2023 5/15/2025 10,210,157 114,978 - 10,325,136 - American Nat'l Bank&Trust 5.00% 11/24/2023 5/22/2025 - 5,026,093 - 5,026,093 - American Nat'l Bank&Trust 5.00% 11/29/2023 5/29/2025 - 5,021,964 - 5,021,964 - Texas Bank 4.56% 6/15/2023 6/12/2025 31040,704 35,109 - 31075,814 - FHLB 4.75% 7/7/2023 6/13/2025 4,955,524 - - 5 019 156 63,632 American Nat'l Bank&Trust 4.56% 6/22/2023 1 6/19/2025 8,101,578 93,649 - 8,195,227 - 11 City of Round Rock Valley View Consulting,L.L.C. Market Value Comparison December 31, 2023 Issuer Coupon Settlement Maturity Beginning Total Buys/ Total Sells/ Ending Market Change in Rate Date Date Market Value Increases Decreases Value Market Value FHLB 4.75% 6/22/2023 6/20/2025 71945,821 - - 81034,758 88 937 American Nat'l Bank&Trust 5.10% 9/14/2023 7/14/2025 3,000,000 38 307 - 3,038,307 - FHLB 3.60% 8/28/2023 7/18/2025 486,472 - - 493,565 7 093 FHLMC 0.38% 8/28/2023 7/21/2025 4,595,187 - - 4,698,760 103,573 FFCB 4.88% 8/16/2023 7/28/2025 4,970,542 - - 5,038,244 67,703 American Nat'l Bank&Trust 5.10% 9/19/2023 8/19/2025 5,000,000 63 845 - 5,063,845 - FAMC 5.18% 9/27/2023 8/27/2025 9,999,666 - - 10 112 236 112,570 American Nat'l Bank&Trust 5.25% 11/9/2023 9/9/2025 - 4,017,260 - 4 017,260 - Wallis Bank 5.30% 11/15/2023 9/15/2025 - 6,000,000 - 6,000,000 - American Nat'l Bank&Trust 5.00% 12/7/2023 10/2/2025 - 5 017,151 - 5 017 151 - American Nat'l Bank&Trust 4.907 12/14/2023 10/9/2025 - 5 012 096 - 5,012,096 - Sub Total/Average Fund 000-Pooled Investments 451,896,007 85,533,682 81,593,404 1 458,300,396 1 2,464,111 Fund 170-Interest&Sinking GO Bonds TexPool N/A 9/30/2015 N/A 413,284 1,267 306 1,855 1 1,678 735 - TexasDAILY N/A 4/30/2016 N/A 29,114 396 - 1 29,509 - Sub Total/Average Fund 170-Interest&Sinking GO Bonds 442,398 1,267,701 1,855 1 1,708,244 - Fund 462-2017 Bond Fund TexPool N/A 5/30/2017 N/A 2,185,492 29,698 - 2,215,190 - NexBank N/A 3/30/2020 N/A 1,707,194 24,206 - 1731,400 - Sub Total/Average Fund 462-2017 Bond Fund 3,892,686 53,903 - 3,946,590 - Fund 465-Road CO Bond Fund TexPool N/A 9/1/2020 N/A 26 029,311 290,038 7,709,071 1 18,610,278 - American Nat'l Bank&Trust 4.85% 4/10/2023 4/10/2024 10,204,961 123,894 - 1 10,328,855 - Sub Total/Average Fund 465-Road CO Bond Fund 36,234,273 413,932 7,709,071 1 28,939,133 - Fund 591 -Reserves Fund TexPool N/A 9/30/2015 N/A 9,191 125 - 9,316 - NexBank N/A 4/29/2019 N/A 909,399 12,894 - 922,293 - Sub Total/Average Fund 591 -Reserves Fund 918,590 13,019 - 931,608 - Fund 602-Interest&Sinking Revenue Bonds TexPool N/A 9/30/2015 N/A 2,476,687 153,123 - 2,629,810 Sub Total/Average Fund 602-Interest&Sinking Revenue Bonds 2,476,687 153,123 - 2,629,810 - Fund 604-2022 SIB Loan TexPool N/A 9/29/2022 N/A 2,891,906 39,297 - 2,931,202 - American Nat'l Bank&Trust N/A 9/19/2023 N/A 434 247 10 671 - American Nat'l Bank&Trust N/A 11/21/2022 N/A 20,870,791 294,795 - 21,165,587 - Sub Total/Average Fund 604-2022 SIB Loan 23,763,131 334,339 10 24,097,461 - Fund 605-Kalahari Debt Service Reserve TexPool N/A 8/30/2019 N/A 356,018 1,657,534 - 2,013,552 - Sub Total/Average Fund 605-Kalahari Debt Service Reserve 356,018 1,657,534 - 2,013,552 - Total/Average $ 519,979,790 E 89,427,234 5 89,304,340 $ 522,566,794 b 2,464,111 12 City of Round Rock Valley View Consulting,L.L.C. Holdings by Allocation and Portfolio Fund September 30, 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.55% 11/29/2016 $ 11,690,412 $ 11,690,412 100.00 $ 11,690,412 N/A 1 5.55% TexasDAILY 5.35% AAAm 6/1/2021 2,553 2,553 100.00 2,553 N/A 1 5.35% TexasDAILY Select 5.58% AAAm 12/3/2021 5,279,435 5,279,435 100.00 5,279,435 N/A 1 5.58% Veritex Community Bank 5.33% 9/1/2020 199,414 199,414 100.00 199,414 N/A 1 5.33% JPMor an Chase 0.29% 9/30/2015 12,613,359 12,613,359 100.00 12,613,359 N/A 1 0.29% TexSTAR 5.31% AAAm 9/30/2015 211,170 211,170 100.00 211,170 N/A 1 5.31% TexPool 5.32% AAAm 9/30/2015 16,721,929 16,721,929 100.00 1 16,721,929 N/A 1 5.32% NexBank 5.55% 1/13/2023 14,870,227 14,870,227 100.00 14,870,227 N/A 1 5.55% TexasDAILY 5.35% AAAm 9/30/2015 2,384,687 2,384,687 100.00 2,384,687 N/A 1 5.35% Treasury 0.25% Aaa/AA+/AA+ 9/30/2021 10,000,000 10,000,000 100.00 10,000,000 10/2/2023 2 0.29% FHLMC 2.00% Aaa/AA+/AA+ 2/28/2022 5,000,000 5,001,058 99.85 4,992,717 10/17/2023 17 1.55% Treasury 2.88% Aaa/AA+/AA+ 11/22/2021 10,000,000 10,020,268 99.83 9,982,726 10/31/2023 31 0.47% FHLB 0.50% Aaa/AA+/- 11/12/2021 5,000,000 4,999,875 99.49 4,974,465 11/9/2023 401 0.52% Treasury 0.50% Aaa/AA+/AA+ 6/23/2022 5,000,000 4,979,508 99.22 4,961,010 11/30/2023 611 3.03% Treasury 2.88% Aaa/AA+/AA+ 11/10/2021 5,000,000 5,020,222 99.59 4,979,573 11/30/2023 61 0.44% FHLB 0.50% Aaa/AA+/- 12/7/2021 8,000,000 7,997,463 99.06 7,924,958 12/8/2023 69 0.67% FHLB 5.00% Aaa/AA+/-- 12/19/2022 10,000,000 10,000,000 99.88 9,988,234 12/19/2023 80 5.00% FHLB 0.63% Aaa/AA+/-- 1/5/2022 5,000,000 4,998,353 98.92 4,946,095 12/22/2023 83 0.77% FFCB 0.90% Aaa/AA+/AA+ 1/28/2022 5,000,000 4,995,724 98.65 4,932,665 1/18/2024 110 1.19% Treasury 2.25% Aaa/AA+/AA+ 1/5/2022 8,000,000 8,039,556 98.98 7,918,073 1/31/2024 123 0.77% Treasury 2.38% Aaa/AA+/AA+ 2/14/2022 14,000,000 14,044,408 98.76 13,827,073 2/29/2024 152 1.60% FHLB 1.88% Aaa/AA+/-- 2/28/2022 15,000,000 15 016,997 98.42 1 14,762 805 3/8/2024 160 1.61% FAMC 2.58% 4/18/2022 10,000,000 10,000,000 98.29 1 9,829,257 4/18/2024 201 2.58% Treasury 2.25% Aaa/AA+/AA+ 3/30/2022 10,000,000 9,989,406 98.15 9,815,181 4/30/2024 213 2.44% FAMC 2.65% 5/9/2022 3,000,000 2,998,693 98.29 2,948,698 5/2/2024 215 2.73% FFCB 2.63% Aaa/AA+/AA+ 6/2/2022 3,051,000 3,050,205 98.21 2,996,535 5/3/2024 216 2.67% Treasury 2.50% Aaa/AA+/AA+ 6/2/2022 7,000,000 6,992,861 98.04 6,862,955 5/31/2024 244 2.66% FHLB 3.13% Aaa/AA+/-- 6/23/2022 20 000,000 19,998 178 98.32 19 663,960 6/14/2024 258 3.14% FFCB 3.15% Aaa/AA+/AA+ 7/15/2022 10,000,000 10,001,773 98.13 9,813,375 7/15/2024 289 3.13% Treasury 1.75% Aaa/AA+/AA+ 9/29/2022 10,000,000 9,806 818 96.97 9,697,271 7/31/2024 305 4.18% FFCB 3.38% Aaa/AA+/AA+ 8/31/2022 23,500 000 23,465,935 98.14 1 23,063,934 8/26/2024 331 3.54% FFCB 3.50% Aaa/AA+/AA+ 9/16/2022 20,000,000 19 914,549 98.16 19,632,696 9/13/2024 3491 3.97% FHLB 4.50% Aaa/AA+/- 11/1/2022 3,000,000 2,995,419 99.01 2,970,288 10/3/2024 369 4.66% FHLB 4.50% Aaa/AA+/-- 11/1/2022 2,000,000 1996946 99.01 1,980,192 10/3/2024 369 4.66% Treasury 0.63% Aaa/AA+/AA+ 12/13/2022 5,000 000 4,811,750 95.17 4,758,655 10/15/2024 381 4.43% FFCB 4.38% Aaa/AA+/AA+ 10/17/2022 7,000,000 7,000,417 98.96 6,927,500 10/17/2024 383 4.37% FHLB 4.53% Aaa/AA+/-- 12/14/2022 15,000,000 15,000,000 99.02 14,852,315 11/18/2024 415 4.53% Texas Capital Bank 4.71% 1/19/2023 5,159,087 5,159,087 100.00 1 5,159,087 12/13/2024 440 4.71% Independent Financial Bank 4.50% 1/31/2023 10,215,667 10,215,667 100.00 1 10,215,667 12/31/2024 458 4.50% Independent Financial Bank 4.50% 1/31/2023 5,107,834 5,107,834 100.00 5,107,834 1/31/2025 489 4.50% American Nat'l Bank&Trust 4.50% 2/10/2023 10,264,315 10,264,315 100.00 10,264,315 2/10/2025 499 4.50% FHLB 4.50% Aaa/AA+/-- 2/24/2023 5,000 000 4,977 286 98.89 4,944,355 2/13/2025 502 4.85% FHLB 4.69% Aaa/AA+/-- 2/15/2023 20,000 000 20,000,000 99.10 19 820,170 3/14/2025 531 4.69% Treasury 2.63% 1 Aaa/AA+/AA+ 2/24/2023 5,000 000 41852,728 96.16 4,808,207 4/15/2025 1 563 4.65% American Nat'l Bank&Trust 4.50% 3/30/2023 10 226,491 10,226,491 100.00 10,226 491 4/28/2025 576 4.50% Texas Bank 4.56% 6/15/2023 5,067,841 5,067,841 1 100.00 1 5,067 841 5/8/2025 257 American Nat'l Bank&Trust 4.50% 3/30/2023 10,210 157 10,210,157 100.00 10,210,157 5/15/2025 593 Texas Bank 4.56% 6/15/2023 3,040,704 3,040,704 100.00 3,040,704 6/12/2025 257 13 City of Round Rock Valley View Consulting,L.L.C. Holdings by Allocation and Portfolio Fund September 30, 2023 Coupon Settlement Face Amount/ Market Days to YTM @ Issuer Credit Rating Book Value Market Value Maturity Date Rate Date Shares Price Maturity Book FHLB 4.75% Aaa/AA+/-- 7/7/2023 5,000,000 4,964,200 99.11 4,955,524 6/13/2025 622 5.19% American Nat'l Bank&Trust 4.56% 6/22/2023 8,101,578 8,101,578 100.00 8,101,578 6/19/2025 2644.56% FHLB 4.75% Aaa/AA+/-- 6/22/2023 8,000,000 8,000,000 99.32 7,945,821 6/20/2025 629 4.75% American Nat'l Bank&Trust 5.10% 9/14/2023 3,000,000 3,000,000 100.00 3,000,000 7/14/2025 653 5.10% FHLB 3.60% Aaa/AA+/-- 8/28/2023 500,000 486,273 97.29 486,472 7/18/2025 657 5.22% FHLMC 0.38% Aaa/AA+/AA+ 8/28/2023 5,000,000 4,597,243 91.90 4,595,187 7/21/2025 660 5.11% FFCB 4.88% Aaa/AA+/AA+ 8/16/2023 5,000,000 4,986,390 99.41 4,970,542 7/28/2025 667 5.03% American Nat'l Bank&Trust 5.10% 9/19/2023 5,000,000 5,000,000 100.00 5,000,000 8/19/2025 689 5.10% FAMC 5.18% 9/27/2023 10,000,000 10,000,000 100.00 9,999,666 8/27/2025 697 5.18% Sub Total/Average 3.44% 456,417,861 455,367,363 99.01 451,896,007 283 3.55% Fund 170-Interest&Sinking GO Bonds TexasDAILY 5.35% AAArn 1 4/30/2016 29,114 29,114 1 100.00 29,114 N/A 1 5.35% TexPool 5.32% AAAm 9/30/2015 413,284 413,284 100.00 413,284 N/A 1 5.32% Sub Total/Average 5.32% 442,398 442,398 100.00 442,398 1 5.32% Fund 462-2017 Bond Fund TexPool 5.32% AAAm 5/30/2017 2,185,492 2,185,492 100.00 2,185,492 N/A 1 5.32% NexBank 5.55% 3/30/2020 1,707,194 1,707,194 100.00 1,707,194 N/A 1 5.55% Sub Total/Average 5.42% 3,892,686 3,892,686 100.00 3,892,686 1 5.42% Fund 465-Road CO Bond Fund TexPool 5.32% AAAm 9/1/2020 26,029,311 26,029,311 100.00 26,029,311 N/A 1 5.32% American Nat'l Bank&Trust 4.85% 4/10/2023 10,204,961 10,204,961 100.00 10,204,961 1 4/10/2024 1 1931 4.85% Sub Total/Average 5.19% 36,234,273 36,234,273 100.00 1 36,234,273 1 1 551 5.19% Fund 591 -Reserves Fund TexPool 5.320/. AAAm 9/30/2015 9,191 9,191 100.00 9,191 N/A 11 5.32% NexBank 5.55% 4/29/2019 909,399 909,399 100.00 909,399 N/A 1 5.55% Sub Total I Average 5.55% 918,590 918,590 100.00 918,590 1 5.55% Fund 602-Interest&Sinking Revenue Bonds TexPool 5.32% AAAm 9/30/2015 2,476,687 2,476,687 1 100.00 2,476,687 N/A 1 5.32% Sub Total/Average 5.32% 2,476,687 2,476,687 1 100.00 2,476,687 1 1 5.32% Fund 604-2022 SIB Loan TexPool 5.32% AAAm 9/29/2022 2,891,906 2,891,906 100.00 2,891,906 N/A 1 5.32% American Nat'l Bank&Trust 0.35% 9/19/2023 434 434 100.00 434 N/A 1 0.35% American Nat'l Bank&Trust 5.53% 11/21/2022 20,870,791 20,870,791 100.00 20,870,791 N/A 1 5.53% Sub Total/Average 5.51% 23,763,131 23,763,131 100.00 23,763,131 1 5.51% Fund 605-Kalahari Debt Service Reserve TexPool 5.32% AAAm 8/30/2019 1 356,018 1 356,018 1 100.00 1 356,018 N/A 1 1 5.32% Sub Total/Average 5.32% 1 356,018 1 356,018 1 100.00 356,018 1 11 5.32% Total/Average 3.68% 1 $ 524,501,644 $ 523,451,146 99.14 $ 519,979,790 1 2501 3.78% 14 City of Round Rock Valley View Consulting,L.L.C. 9 OF ROUND ROCK BY THE NUMBERS e. FY 2024 Quarter I Citywideof Incentives Property Totals through December 2023=$28.8M fno,000,000 sco,ogo,000 fw0000,000 sss,000.o00 f9o,00g000 fio,000,000 $3"00,000 sM000 M Fso,000,000 - - - $20,000,000 S"'000,000 - -• $54100000 f2000 $1041004100 uo,w,000,w,00a fR000.000 -- s s Oct Nov Dac Jan Feb Mar Apr May Jun Jul Aug Sap Oct Now D_ bn Fab Mar Apr May Tun 2ul Aug Sept -40-FY 2024 Actuab FV 2023 Actual, ■FY24ACDMS aFY23Act"S Other General • Pevenues HOT : Venue Tax, Priorto Incentives ricoo,oao fw,000,000 sW041o0 tls,000,000 $1,2004100 512,0004100 $1,wo.00o $10,000,000 $,00,000 $841oo,o00 55001000 5400,00o 54,000,0,0 swo,wo U0001ow $- f 0"—Taari Moan,,,, Mtvin sell Fhwi G.— Contra t,i ot't Nw Dec An Feb Mr Apr My Sun Jul Aug Sap FranMlaa eannlb i Charge, Navanw Fort kurw Othw F_ Fee, F FY 2024 Actwla •FY 2023 At-k •FY24 Other Hotels .FY 24 KalahOtherari F FY 22 Oar HotelsFY 73 Kalahari 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 0.9%.Dell receipts,net of incentives,decreased 16.9% 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 and Franchise Fees increased 13.9%.This is due to higher collections in mixed drink tax. License,Permits,and Fees decreased 34.4%.This is largely due to timing of new developments in the City.Last year,first quarter had multiple large developments starting. Service Charges increased 15.1%.This is due to the adopted rate increase that took place October 2023 for residential garbage services and late fees were waived in the first quarter of FY 2023 while the City implemented its new customer payment portal. Program Revenues increased 21.3%.This is attributed to higher participation in City programs including CMRC,BACA,Recreation Programs,and an increase in Parks&Pec Facility Rentals. Fines and Forfeitures revenues decreased 11.1%due to fewer citations and cases filed than first quarter last year. Grants increased 87.9%.This is due to reimbursements from the 2023 Ice Storm Mara and the Round Rock Rides program. Contracts and Other decreased 55.5%.This is due to the timing of the payment from ESD 9 to the City. Hotel Occupancy&Venue Tax revenues for FY 2024 increased 8.5%over prior year's first quarter 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 Total Budget Revenues = $S43.9M �A 515A m•7 Soume Amount(in Mii--) 51sA Sales Tax $ 113.9 fit Use of Fund Balance $ 96.7 ;-; Property Tax $ 81.9 Bond Proceeds $ 673 Utility&Garbage Charges $ 61.4 f96.7 Contracts&Other $ 60S Fines,Permits&Fees $ 18.8 fa„ Other Taxes&Franchise Fees $ 17.7 Hotel Occupancy/Venue Tax E 15.8 Program Revenues $ 9.9 FY 2023 2024 Total Budget Expenses = $S43.9M p.7 W S" $7.0 $102 PUR Dopsrtmwmt Amount On Millions) Department Amount(in MIMaw Ina Capital Improvement Projects $ 200.4 ■ Transportation $ 13.8 $20.1 Police $ 44,5 0 sports Management $ 11.8 Debt Payments $ 429 0 General services $ 92 $100 Support services $ 39.9 0 Planning&Development f 7.0 Utilities&Environmental Svcs $ 382 0 Library $ 49 Fire $ 36.1 0 Fleet Replacement $ 42 Funding Transfers Out $ 34.0 0 Communications $ 33 General Self Financed Const $ 31.9 0 Com.&Neighborhood Srv. $ 1.7 fu s f39.9 Paris&Recreation $ 20.1 fc29 Other Information CORR Tax Information Taxing Entities Top 10 Property Tax Payers FY 23-24 FY 22-23 Entity Rate Business Amount on millions) Population 134,540 128,957 City of Round Rock $ 0.3420 Kalahari Resorts $ S31.8 Property Tax Rate $0.34200 $0.34200 Williamson County $ 03774 Dell Computer Holdings LP 459.1 M&O 0.224400 Debt 0.117600 Round Pock ISD $ 0.9190 CMF 15 Portfolio lcaloni.IGr.r Apt.) 166.5 Outstanding Debt as of 10/01/23 Austin Community College $ 0.0986 CPF,PP,LP(Pound Pock Outlets) 162.8 Upper Brushy Creek $ 0.0170 TX Essential Housing(Lakeside @ LF) 151.1 Bond Amount O/S(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 FV 22-23 36 Hundred Apts(Avery Centre) 100.0 Utility/Stormwater $ 103.7/5.2 Median Home Values $ 363,396 $ 369,169 Stanmore Warner Ranch Apts 99.9 HOT $ 6.7 Taxable Property Value(in billions) $ 24.1 $ 21.7 TMP Parkside LLC(Parkside 0 RRI 953 Type B $ 66.0 City Employees Bond Ratings(Rated by S&P) Sworn FTEs Total FTEs GO Bonds AAA City Wide 369 1,174.85 Utility Bonds AAA Police 200 287.2 Fire 169 194.0