The URL can be used to link to this page

Contract - Quarterly Investment Report - 2/8/2024 y ROUND ROCK TEXAS FINANCE 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 complianc; ith the Public Funds Investment Act and the Investment Policy and Strategies. Chi�,f Financial Officer 4Deput� Chief ncial Office Controller ury Accountant I I X Valley VieZ 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. �- 2o2� - SLS Summary Holdings by Investment Category (Security Sector) December 31, 2023 YTM @ Description Cost Book Value Market Value Cash 031% $ 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 558% 50.959.844 50.959,844 US Aclency 1 3.78% 194,544.641 193,743,960 US Treasury 2.69% 58.616.124 58.249,297 Total/Average 4.25% 1 $ 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 1 3.54% 227,442,977 1 224,918,422 US Treasury 2.06% 88,557,526 1 87,610,724 Total/Average 3.78% $ 523,451,146 1 $ 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% 379% 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. City of Round Rock Valley View Consulting, L.L.C. 1 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 5,250 S&P 500 5,000 4 5.00 ,750_- 4,50 4,000 ! 4.00 - 3,750 3,500 3,250 3.00 3,000 2,750 2,500 2,250 2.00 2,000 1,750 1,500 1.00 1,250 1,000 750 0.00 . 250 0�OHO-lam' 1�tJ 47 1�7 O.�A h Ifo .119 _o bac -14c .14, •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 • 4.50 4.50 -- 4.00 4.00 3.50 3.50 3.00 3.00 2.502.50 • 2.00 07 2.00 w .111 110411111111 1.50 - 1.50 , 1.00 1.00 w � 0.50 E�u0.50 , 0.00 0.00 6 1 1 0 0 0 1 L j A A Ib 1 0 0 9 9 0 0 `L �6 11 K1 N% Na Nq 10 ,y0 ,y0 til 21 titi titi IS 1b $J6 O O O A O S�' 1 1 1 1 1 1 1 1 1 1 1 \,b41?1 1 1 1 1 1 �, �.,1. �,, `l, \xc�`��X35 `��Set`*1 kp, �s� �) �� N ��\a°§,� ��)�s�4- etc+' tis, t11dr 'Or 10' tsar' <Jc� �0r �,p+' �i �_c_�' ao�' 101 0' `,a+' •Six Month T-8111 Two Year T-Note Ten Year T-Note ---Six Month T-Bill 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 S 11,922,479 2% $ - 0% $ - 0% S - 0% S 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% 41338,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/Average $459,467,904 88% 1 $ 4,338,054 1 1% $ 2,945,160 1% $ 56,983,184 11% $523,734,302 1001% Portfolio Balances (Millions) Order of Liquidity 5600 m Cash 5500 ❑Local Government Investment Pool S400 e Money Market Account $300 ■US Treasury $200 ❑US Agency []Municipal $100 o Certificates of Deposit $O Pooled Funds DS Funds DSR Funds CP&SP Funds Total Portfolio 12/3112023 12/31/2023 12131/2023 12/31/2023 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 Limitation 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 97% 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 371% 85% US Agency - - 33,000,000 - 1,789,350 - US Treasury 58,616,124 1 t2% 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 9 7% Certificates of ❑Cash i Deposit $500 Investment Pools 22.3% ❑Local Government 17.4% $400 Investment Pool ®Money Market Account $300 — ■US Treasury Cash 2.3% $200 ❑US Agency $100 oMunicipal US Treasury 11.2/0 $0 0 Certificates of Deposit US Agency 371% 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 c� c 3.00 W L a 2.50 - - 2.00 - 1.50 1.00 dM WOi 0.50 - --- ` GIIIIIIIIIIIIIIIII 0.00 r �•s -- N'D N(O �O �O �O �O �1 ,�1 Nk 1 N� ,�� N� ,�� °' Nco NO No, 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o`L N\`L o�`L N\`L o�`L ��ti ��ti Nati o�`l' o�`L I\`L N\'L �� o��' 0�3�rL� �� co�� 0��3 �� 0�� rb co�� 0 '�� no�� 3�r1�3 ��^) 6�5 ��5�rL� �� 'rt'� ��^�^�3 �� b�^� ��^' Round Rock TexPool Rolling 1.5 yr Treasury (Policy WAM max) Rolling 9 mo Treasury City of Round Rock Valley View Consulting, L.L.C. Portfolio Balances By Fund (Millions) $600 $500 ■Capital Protect& Special Purpose Funds $400 ❑Debt Service Reserve Funds $300 o Debt Service Funds $200 $100 ■Pooled Funds $0 O^h O^y O^6 ON6 ON O^O Off^ O^1 O^A ON O^O ONO ONO ONO 0N9 ONO O^9 O^O OHO o1O OHO OHO 01^ Off^ Off^ off^ O1ry o�ry o�ry O1ry O� O�� 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 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 538% 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.6077- FHLB .60%FHLB 1.88% Aaa/AA+/-- 2/28/2022 15,000,000 15.007,315 99.34 14,900,978 3/8/2024 68 161% 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 9899 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 9874 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 289 4.43% FFCB 4.38% Aaa/AA+/AA+ 10/17/2022 7,000,000 7,000,316 9949 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 10000 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 469% 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 471 465% 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 10000 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 519% 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 1 5611 5.10% FHLB 3.60% Aaa/AA+/-- 8/28/2023 500.000 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 15.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 a@ 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% 1 1 12/14/2023 1 5,012,096 5,012,096 100.00 5,012,096 10/9/2025 648 4.90% Sub Total/Average 3.93% 1 1 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 29,509 29,509 1 100.00 29,509 N/A 1 5.38% TexPool 5.37% AAAm 1 9/30/2015 1,678,735 1,678,735 1 100.00 1,678,735 N/A 1 5.37% Sub Total/Average 5.37% 1 1,708,244 1,708,244 1 100.00 1,708,244 11 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 15.60% Sub Total/Average 5.47% 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 18,610,278 1 18,610,278 100.00 18,610,278 N/A 1 5.37% American Nat'l Bank&Trust 4.85% 4/10/2023 10,328,855 1 10,328,855 100.00 10,328,855 1 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 1 9,316 N/A 11 5.37% NexBank 5.60% 4/29/2019 922,293 922,293 100.00 1 922,293 N/A 11 5.60% Sub Total/Average 5.60% 931,608 931,608 100.00 1 931,608 __11 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 11 5.37% Sub Total/Average 5.37% 2,629,810 2,629,810 100.00 2,629,810 1 5.37% Fund 604-2022 SIB Loan TexPool 5.37% AAArn 9/29/2022 1 2,931,202 1 2,931,202 1 100.00 1 2,931,202 1 N/A 1 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 5.37% AAArn 8/30/2019 2,013,552 2,013,552 100.00 2,013,552 N/A 1 5.37% Sub Total/Avera a 5.37% 2,013,552 2,013,552 100.00 2,013,552 1 5.37% Total/Average 4.10% $ 524,624,538 $ 523,734,302 99.61 $ 522,566,794 230 A_- 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/ I Ending Book I 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 $ 12 613,359 $ 7,091,097 $ 7,781 977 $ 11.922,479 $ 690,880 TexPool N/A 9/30/2015 N/A 16,721,929 46,540 551 10,363,528 52,898 952 36 177 023 TexSTAR N/A 9/30/2015 N/A 211,170 2,850 - 214,020 2,850 TexasDAILY N/A 9/30/2015 N/A 2,384 687 32,400 - 2,417 087 32,400 TexasDAILY N/A 6/1/2021 N/A 2,553 35 - 2,587 35 TexasDAILY Select N/A 12/3/2021 N/A 5,279 435 74,614 - 51354,049 74,614 NexBank N/A 11/29/2016 N/A 11,690 412 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,001058 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 - 5,000 000 (5,020,222 Treasury 0.50% 6/23/2022 11/30/2023 4,979,508 51000 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 41998,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,044408 - - 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 - Treasu 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,050 545 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.567 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 41852,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% 1 11/29/2023 5/29/2025 - 5,021 964 - 5,021,964 5,021,964 Texas Bank 4.56% 6/15/2023 6/12/2025 3104017 04 35,109 - 3 075,814 35.109 FHLB 4.75% 7/7/2023 6/13/2025 4,964 200 - - 4 969,514 5 315 American Nat'l Bank&Trust 456% 6/22/2023 6/19/2025 8,101 578 1 93,649 - 8,195,227 93,649 City of Round Rock Valley View Consulting, L.L.C. 9 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 360% 8/28/2023 7/18/2025 486,273 - - 488,200 1,928 FHLMC 038% 8/28/2023 7/21/2025 4.597,243 - - 4,653,543 56,299 FFCB 488% 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 - 4,017,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,017,151 - 5,017,151 5,017,151 American Nat'l Bank&Trust 4 90% 12/14/2023 10/9/2025 - 5,012.096 - 5,012.096 5,012,096 Sub Total/Average Fund 000-Pooled Investments i 455,367,363 85,533,682 81,593,404 459,467,904 1 4,100,541 Fund 170-Interest&Sinking GO Bonds TexPool N/A 9/30/2015 N/A 1 413,284 1,267,306 1.855 1,678,735 1,265,451 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,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 I N/A 3/30/2020 N/A 1,707 194 1 24,206 - 1.731.400 24,206 Sub Total/Average Fund 462-2017 Bond Fund 3,892,686 1 53,903 - 3,946,590 53,903 Fund 465-Road CO Bond Fund TexPool N/A 9/1/2020 N/A 26,029,311 1 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 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 13,019 1 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 2,476,687 1 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 8/30/2019 N/A 356.018 1 1.657.534 - 2,013,552 1.657.534 Sub Total/Average Fund 605-Kalahari Debt Service Reserve 356,018 1,657,534 1 - 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/ I Total Sells/ I 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 51279,435 74 614 - 5,354,049 - NexBank N/A 11/29/2016 N/A 11,690412 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% 9/30/2021 10/2/2023 10,000,000 - 10,000,000 - - FHLMC 2.00% 2/28/2022 10/17/2023 41992,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,974,465 - 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 41961,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,000 - 11,766 FHLB 0.63% 1/5/2022 12/22/2023 4,946,095 - 5,000.000 - 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 14762 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 9,815,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 2,996,535 - - 3,022 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 9697,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 - - 21988,912 18 624 Treasury 0.63% 12/13/2022 10/15/2024 4,758 655 - - 41834,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,315 - - 98,580 Texas Capital Bank 4.71% 1/19/2023 12/13/2024 5,159 087 60,870 - E14,95O,895 Inde endent Financial Bank 4.50% 1/31/2023 12/31/2024 10,215667 115,871 - - inde ndent Financial Bank 4.50% 1/31/2023 1/31/2025 5,107834 57935 -American Nat'l Bank&Trust 4.50% 2/10/2023 2/10/2025 10264,315 115 588 - - FHLB 4.50% 2/24/2023 2/13/2025 4944355 - 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 4.50% 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 - TexasBank 4.56% 6/15/2023 6/12/2025 3,040 704 35,109 - 3,075,814 - FHLB 4.75% 7/7/2023 6/13/2025 4,955,52 5,019,156 63.632 American Nat'l Bank&Trust 4.56% 6/22/2023 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 Coupon Settlement Maturity Beginning Total Buys/ Total Sells/ Ending Market Change in Issuer Rate Date Date Market Value Increases Decreases Value Market Value FHLB 4.75% 6/22/2023 6/20/2025 7.945,821 - 8.034.758 88.937 American Nat'l Bank&Trust 5.10% 9/14/2023 7/14/2025 3,000.000 38.30. - 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 1 4,595,187 - - 4,698,760 103,573 FFCB 488% 8/16/2023 7/28/2025 1 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.1 % 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 - Walhs Bank 530% 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 90% 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 458,300,396 2,464,111 Fund 170-Interest&Sinking GO Bonds TexPool N/A 9/30/2015 N/A 1 413,284 1 1,267,306 1,855 1,678,735 - TexasDAILY N/A 4/30/2016 N/A 29,114 1 396 1 - 29,509 - Sub Total/Average Fund 170-Interest&Sinking GO Bonds 442,398 1 1,267,701 1 1,855 1,708,244 - Fund 462-2017 Bond Fund TexPool N/A 5/30/2017 N/A 2,185,492 29,698 1 - 2,215 190 - NexBank N/A 3/30/2020 N/A 1,707,194 24.206 - 1,731.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 1 26,029,311 290,038 1 7.709.071 18.610,278 - American Nat'l Bank&Trust 4 85% 4/10/2023 4/10/2024 10,204.961 123,894 - 10.328,855 - Sub Total/Average Fund 465-Road CO Bond Fund 36,234,273 413,932 7,709,071 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 - 21931,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 1.657,534 11 2,013.552 - Sub Total/Average Fund 605-Kalahari Debt Service Reserve 356,018 1,657,534 11 2,013,552 - Total/Average $ 519,979,790 $ 89,427,234 $ 89,304,340 1 $ 522,566,794 $ 2,464,111 11 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% Ventex 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 16.721,929 N/A 1 532% 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 40 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 61 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 067% FHLB 5.00% Aaa/AA+/-- 12/19/2022 10.000.000 10.000.000 99.88 9.988,234 12/19/2023 80 500% 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 9865 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 1231 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 1521 1.60% FHLB 1.88% Aaa/AA+/-- 2/28/2022 15,000.000 15,016,997 98.42 14.762,805 3/8/2024 160 1.61% FAMC 2.58% 4/18/2022 10,000.000 10.000,000 98.29 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 9813 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 418% FFCB 3.38% Aaa/AA+/AA+ 8/31/2022 23.500,000 23,465,935 98.14 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 349 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.500% Aaa/AA+/-- 11/1/2022 2,000,000 1,996,946 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 471% 1/19/2023 5,159,087 5,159,087 100.00 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 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 469% Treasury 2.63% Aaa/AA+/AA+ 2/24/2023 5,000,000 4.852,728 96.16 4.808,207 4/15/2025 563 4.65% American Nat'l Bank&Trust 4.500% 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 100.00 5,067,841 5/8/2025 1 257 4.56% American Nat'l Bank&Trust 4.50%, 3/30/2023 10,210,157 10,210,157 10000 10.210.157 5/15/2025 5931 4.50% Texas Bank 456% 6/15/2023 3.040,704 3,040.704 10000 3,040 704 6/12/2025 2571 4.56% 13 City of Round Rock Valley View Consulting, L.L.C. Holdings by Allocation and Portfolio (Fund) September 30, 2023 Coupon Settlement Face Amount/ Book Days to YTM @ Issuer Rate Credit Rating Date Shares Book Value Price Market Value Maturity Date Maturity Book FHLB 4.75% Aaa/AA+/-- 7/7/2023 5,000.000 4,964.200 9911 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 264 4.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 522% 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 9941 4.970.542 7/28/2025 667 503% 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 1 283 3.55% Fund 170-Interest&Sinking GO Bonds TexasDAILY 5.35% AAArn 1 4/30/2016 1 29.114 1 29,114 1 100.00 1 29.114 1 N/A 1 5.35% TexPool 5 32% AAArn 1 9/30/2015 413.284 1 413.284 1 10000 1 413.284 1 N/A 1 5.32% Sub Total/Average 5.32% 442,398 1 442,398 1 100.00 1 442,398 1 1 5.32% Fund 462-2017 Bond Fund TexPool 5.32% AAAm 1 5/30/2017 2.185.492 1 2.185.492 1 100.00 2,185,492 N/A 1 5.32% NexBank 5.55% 1 3/30/2020 1.707,194 1 1.707.194 100.00 1.707.194 N/A 1 5.55% Sub Total/Average 5.42% 1 3,892,686 1 3,892,686 100.00 3,892,686 1 5.42% Fund 465-Road CO Bond Fund TexPool 5.32% AAAm 9/1/2020 1 26,029.311 1 26,029,311 100.00 26,029.311 N/A 1 5.32% American Nat'l Bank&Trust 485% 1 4/10/2023 1 10.204.961 1 10.204.961 100.00 10.204.961 1 4/10/2024 1 1931 485% Sub Total I Average 5.19% 1 1 36,234,273 1 36,234,273 100.00 36,234,273 1 1 551 5.19% Fund 591 -Reserves Fund TexPool 5.32% AAAm 9/30/2015 1 9.191 1 9,191 100.00 9.191 N/A 1 5.32% NexBank 555% 4/29/2019 909.399 1 909.399 100.00 909.399 N/A 11 5 55% Sub Total/Average 5.55% 918,590 1 918,590 100.00 918,590 11 5.55% Fund 602-Interest&Sinking Revenue Bonds TexPool 5 32-% AAAm 9/30/2015 2.476.687 1 2,476.687 10000 2,476.687 N/A 11 5.32% Sub Total/Average 5.32% 2,476,687 1 2,476,687 100.00 1 2,476,687 11 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 10000 20.870.791 N/A 1 553% 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% AAArn 1 8/30/2019 1 356,018 1 356,018 100.00 356.018 N/A 11 5.32% Sub Total/Avera a 5.32% 1 1 356,018 1 356,018 100.00 356,018 11 5.32% Total/Average 3.68% 1 1 $ 524,501,644 $ 523,451,146 99.14 1 $ 519,979,790 1 2501 3.78% 14 City of Round Rock Valley View Consulting, L.L.C.