The URL can be used to link to this page

Contract - Round Rock - 5/12/2022 jp�R09�UND ROCK TEXAS QUARTERLY INVESTMENT REPORT For the Quarter Ended March 31, 2022 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. "y - thie Einai I Oficer DFinancial O er Cf /� — SA-.Z/ Controller Treas ccountant -2,7 Valley View Consulting, 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,2022 YTM @ Description Cost Book Value Market Value Cash 0.15% $ 20,221,350 $ 20,221,350 Certificates of Deposit 0.29% 235,340,021 235,340,021 Local Government Investment Pool 0.16% 25,391.130 25.391.130 Money Market Accounts 0.48% 50,334.882 50,334,882 Municipal 0.26% 17,629,928 17,437,655 US Agency 0.95% 74.997,485 73,849,760 US Treasury 0.95% 71.052,709 69.719.567 Total/Average 0.49% $ 494,967,505 $ 492,294,365 December 31, 2021 YTM @ Description Cost Book Value Market Value Cash 0.15% $ 19.860,508 $ 19.860.508 Certificates of Deposit 0.39% 259.151,943 259.151.943 Local Government Investment Pool 0.03% 53,116,022 53.116,022 Money Market Accounts 0.30% 70,306,749 70,306,749 Municipal 0.27% 18,368,702 18,318,866 US Agency 0.36% 31,959,364 31,845,175 US Treasury 0.35% 33,790.710 33.608.148 Total/Average 0.32% $ 486,553,998 $ 486,207,412 Average Yield Current Fiscal Year- Quarter(1) to-Date(2) Total Portfolio 0.49% 0.40% TexPool Yield 0.15% 0.10% Rolling Three Mo. Treas. Yield 0.31% 0.18% Rolling Six Mo. Treas. Yield 0.36% 0.22% Rolling 1 Yr. Treas. Yield 0.33% 0.22% Rolling 2 Yr. Treas. Yield 0.38% 0.35% Investment Income(3) Interest Income(Approximate) $ 446.363 $ 793.960 WAM at 3/31/2022 Policy WAM Max Total Portfolio 282 days 540 days Pooled Funds 316 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/2022 The Federal Open Market Committee(FOMC)raised the Fed Funds target range to 0.25%to 0.50%(Effective Fed Funds are trading+/-0.30%). The FOMC ended monthly security purchases and may begin reducing their balance sheet. The market projects 4 to 6 more increases this calendar year. Final Fourth Quarter GDP recorded+6.9%. March Non-Farm Payroll missed estimates adding 431 k net new jobs,decreasing the Three Month Average NFP to 562k. Crude oil declined to+/-$100 per barrel. The Stock Markets have recovered from the"correction"and slowly regained some lost ground. Some domestic economic indicators, including housing, softened. Inflation remained well over the FOMC 2%target(Core PCE+/-5.4%). The FOMC Fed Funds target projections pushed the yield curve to a Three Year Maturity peak. 3.00 Treasury Yield Curves 5,250 S&P 500 5,000 4,750 2.50 4,500 4,250 2.00 4,0003,750 3,500 do 3,250 1.50 do 3,000 2,750 _ �-!� 2,500 or - 1.00 250 2,000 �' , 0.50 - 15001,250 � do ar 1750 0.00 500 250 � -March 31,2021 December 31,2021 March 31,2022 6.00 US Treasury Historical Yields-Since 2006 3.50 US Treasury Historical Yields-Since Nov 2015 5.50 5.00 3.00 - -- A 4.50 I 4.00 2.50 ''r 3.50 IV 2.00 3.00 TJk M M 16 + 2.50Af 1.50 - 2.00 �►�� r 1.50 1.00 1.00 r� y 0.50 0.50 w 0.00 0.00 ' vpp 111�a�A)1�a A16 $ja A��o�� a J��J9� �Ja)Ja J°�J2° Ja J°CJs j J��J9)Ja J�ja J��j�� O," X16 V16 0e1� V, eVKI 1� 9��06 ��9 0 a°�� ,%; L� iti1 �ti° 0'°;l� e� P� 5e F O ts` � P J J tjO P� � F Six Month T-13111_ -- _ Two Year T-Note Ten Year T_Note___] I ---Six Month T-Bill Two Year Z Note -- Ten Year T-Note__ Valley View Consulting,L.L.C. 2 Holdings by Investment Category March 31, 2022 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 $ 20,216,825 4% $ 4,525 0% $ - 0% $ - 0% $ 20,221,350 4% Certificates of Deposit 180,878,354 37% 17,812,569 4% - 0% 36,649,098 7% 235,340,021 48% Investment Pools 14,541,701 3% 6,459,931 1% 804,369 0% 3,585,130 1% 1 25,391,130 5% Money Market Accounts 40,261,874 8% 693,628 0% 859,200 0% 8,520,181 2% 50,334,882 10% Municipal 17,629,928 4% - 00 - 0% - 0% 17,629,928 4% US Agency 74,997,485 15% - 00 - 0% - 0% 74,997,485 15% US Treasury 71,052,709 14% - 0% - 0% - 0% 71,052,709 14% Total/Average $419,578,876 85% $ 24,970,652 5% $ 1,663,568 0% $ 48,754,409 10% $494,967,505 100% Portfolio Balances (Millions) Order of Liquidity $500 - - --- ---- - $450 - ■Cash $400 -- --- --- --- _ ®Local Government $350 -- — - -- - Investment Pool $300 -- - --- — ------ __ ■Money Market Account $250 -- ---- ---- -- - -- - ■US Treasury $200 -- -— -- -- - - -- aUS Agency $150 -- --— $100 -__- - -- ❑Municipal 5 ---- -- - -- ■Certificates of Deposit $0 ® - Pooled Funds DS Funds DSR Funds CP&SP Funds Total Portfolio 3/31/2022 3/31/2022 3/31/2022 3/31/2022 3/31/2022 3 City of Round Rock Valley View Consulting,L.L.C. Investment Holdings by Investment Category Quarterly Transactions By Investment Category March 31,2022 March 31, 2022 %of Portfolio Net Cash Equivalent Description Book Value Portfolio Limitation Description Buys Sells Maturities Calls Interest DeposiV(Withdrawal) Cash $ 20,221,350 4.1% 100% Cash $ - $ - $ - $ - $ $ 360,841 Investment Pools 25,391,130 5.1% 100% Investment Pools - - - 6,008 27,724,892 Mioney Market Accounts 50,334,882 10.2% 75% Money Markets Accounts - - - - 50,417 19,971,867 Certificates of Deposit 235,340,021 47.5% 85% Certificates of Deposit 17,971,649 - 41,783,571 - 226,945 - Commercial Paper I -1 0.0% 10%/5% 1 Commercial Paper I - - -I - Municipal 17,629,928 3.6% 35%15% Municipal - 650,000 - 125,171 - US Agency 74,997,485 15.1% Combined US Agency 43,209,316 - - - 154,500 - US Treasury 71,052,709 14.4% 75% US Treasury 37,733,260 - - - 321,875 - Total/Average $ 494,967,505 100% PASSED Totals $ 98,914,225 $ -1$ 42,433,571 $ - $ 884,916 1 S 47,335,917 Portfolio Balances (Millions) Portfolio Composition Order of Liquidity March 31,2022 $500 - - - -- Certificates of Money Market Accounts Deposit $450 -- ■Cash 10.2% 47.5/0 $400 ■Local Government Investment Pools $350 - - - Investment Pool 5.1% $300 - - - - ■Money Market Account Cash $250 -- 41% ■US Treasury $200 - $150 -- - ■US Agency $100 US Treasury 13Municipal 14.4% $50 - Municipal $0 ■Certificates of Deposit 3.6% US Agency N\tib \�^\tib U15.1% 4 City of Round Rock Valley View Consulting, L.L.C. Portfolio Balances By Fund (Millions) $500 $450 $400 ■Capital Project& $350 Special Purpose Funds $300 ❑Debt Service Reserve Funds $250 $200 ❑Debt Service Funds $150 $100 ■Pooled Funds $50 $0 �h �h ,eco �Co pro �0 ^^ �1 ,�A ^A ,�0 �O �0 ,alb Cb 0J�0 �0 ,�0 O O O O ^ � 1 tiO ryO tiO tiO tiO tiO tiO tiO tiO tiO tiO tiO tiO tiO tiO tiO tiO tiO �Oti ryOti ryZT ,yo1' ryOti �Oti ryOti ryOti tiO~ry O\ r,\ 41 O\ 41 41 r�\ O\ O\ '.\ 41 O\ 4 r�\ -SI O\ O\ NK r,\ O\ O\ N\ NKI O\ O\ O\'h "\'t '��^� '0 0�� ^`LA'S '�� O�� '0 ,�'L�� 'S� '0 OZ'S ^rye '0' 'S' 0\0 '-'P -'P 6\1 AC'S '41 '5P OZ'S ':6P ,`I 5 City of Round Rock Valley View Consulting, L.L.C. City of Round Rock Pooled Funds Performance 2.60 2.50 --- - 2.40 - - - - - - - - 2.30 2.20 2.10 2.00 1.90 1.80 1.70 1.60 ;? 1.50 1.40 L 1.30 a 1.20 1.10 1.00 0.90 0.80 0.70 � 0.6000,do 0.50 ,map 0.40 0.30 0.20 - Gmbh - 0.10 moo Nb 0.00 .� �3 N'O �`O N'O �6 N\ �1 �1 N% N� �� NO N( �c c �o do do do �'� �o ,�o �o �o �o� �.� �.� ,�o� �o� ,�.� �.� �o� �o� �.� �.� oo� �o� ,�.� �.� �o� �o� ,�•� ,�,�� o� �o� oN� �N� � oo& �o� o� ^� �� \ Round Rock TexPool Rolling 1.5 yr Treasury (Policy WAM max) Rolling 9 mo Treasury 6 City of Round Rock Valley View Consulting, L.L.C. Holdings by Allocation and Portfolio (Fund) March 31, 2022 Issuer Coupon Credit Rating Settlement Face Amount/ Book Value Market Market Value Maturity Date Days to YTM @ Rate Date Shares Price Maturity Book Fund 000-Pooled Investments NexBank 0.55% 11/29/2016 $ 30,075,167 $ 30,075,167 100.00 $ 30,075,167 N/A 1 0.55°/ TexasDAILY 0.14% AAAm 6/1/2021 1,799,438 1.799,438 100.00 1,799,438 N/A 1 0.14% TexasDAILY Select 0.32% AAAm 12/3/2021 1.000.657 1.000,657 100.00 1,000,657 N/A 1 0.32% Veritex Community Bank 0.27% 9/1/2020 175,996 175,996 100.00 175,996 N/A 1 0.27% R Bank 0.25% 11/29/2021 3,502,018 3.502,018 100.00 3,502,018 N/A 1 0.25% JPMor an Chase 0.15% 9/30/2015 20,216,825 20,216,825 100.00 20,216,825 N/A 1 0.15% TexSTAR 0.11% AAAm 9/30/2015 200,554 200,554 100.00 200,554 N/A 1 0.11% TexPool 0.15% AAAm 9/30/2015 10,742,359 10,742,359 100.00 10,742,359 N/A 1 0.15% Prosperity Bank 0.15% 9/14/2021 4,506,860 4,506,860 100.00 4,506,860 N/A 1 0.15% TexasDAILY 0.14% AAAm 9/30/2015 798,693 798,693 100.00 798,693 N/A 1 0.14% Prosperity Bank 0.15% 9/14/2021 2,001,833 2,001,833 100.00 2,001,833 N/A 1 0.15% Independent Bank 0.40% 1/11/2021 20.080.120 20,080,120 100.00 20,080.120 4/11/2022 11 0.40% Veritex Community Bank 0.20% 2/5/2021 3,006.005 3,006,005 100.00 3,006,005 5/5/2022 35 0.20% Prosperity Bank 0.20% 2/12/2021 4,008,622 4,008,622 100.00 4,008,622 5/12/2022 42 0.20% Inde endent Bank 0.30% 5/19/2021 6.013.621 6,013,621 100.00 6.013.621 5/19/2022 49 0.30% Allegiance Bank 0.45% 6/17/2020 12.094.410 12,094,410 100.00 12,094,410 6/17/2022 78 0.45% Bank OZK 0.50% 7/9/2020 10.083,618 10.083,618 100.00 10.083,618 7/11/2022 102 0.50% Veritex Community Bank 0.24% 2/5/2021 3,007,206 3,007,206 100.00 3.007,206 8/5/2022 127 0.24% Prosperity Bank 0.20% 2/12/2021 3,006,467 3,006,467 100.00 3,006,467 8/12/2022 134 0.20% Bexar Co Txb Ref 0.33% A2/AA/A- 9/23/2021 560,000 560.000 99.76 558.678 8/15/2022 137 0.33% Arlington TX HGR EDU 0.50% -/AAA/- 4/28/2021 500.000 500.000 99.46 497.280 8/15/2022 137 0.50% Denton ISD 0.00% -/AAA/AAA 12/17/2020 500.000 499,136 99.62 498,110 8/15/2022 137 0.46% City of Bryan TX 0.45% -/AA/- 11/19/2020 500.000 500,000 99.80 498,980 8/15/2022 137 0.45% City of Austin GO 0.27% Aa1/AAA/AA+ 10/6/2020 700,000 700.000 99.73 698.138 9/1/2022 154 0.27% Prosperity Bank 0.20% 6/1/2021 3.004,491 3.004,491 100.00 3.004,491 9/1/2022 154 020% Veritex Community Bank 0.18% 3/5/2021 8,014.410 8,014,410 100.00 8,014,410 9/5/2022 158 0.18% State of Texas 1.61% Aaa/AAA/- 3/19/2021 3,250,000 3,273,888 100.27 3,258,710 10/1/2022 184 0.15% State of Texas 2.52% Aaa/AAA/- 10/14/2021 5,000,000 5,059,513 100.71 5,035,450 10/1/2022 184 0.15% Prosperity Bank 0.40% 10/15/2020 6.034,005 6,034,005 100.00 6.034,005 10/17/2022 200 0.40% Veritex Community Bank 0.26% 2/5/2021 3,007,808 3,007,808 100.00 3,007,808 11/4/2022 218 0.26% Prosperity Bank 0.20% 2/12/2021 3,006,467 3,006,467 100.00 3,006,467 11/14/2022 228 0.20% R Bank 0.48% 11/24/2021 4,004,842 4,004,842 100.00 4,004.842 11/23/2022 237 0.48% Bank OZK 0.28% 12/7/2020 5,017,543 5.017,543 100.00 5.017,543 12/7/2022 251 0.28% Prosperity Bank 0.20% 6/9/2021 10,014,969 10.014.969 100.00 10.014.969 12/9/2022 253 0.20% Veritex Community Bank 0.28% 1/6/2021 4,011,212 4,011,212 100.00 4,011,212 1/6/2023 281 0.28% R Bank 0.57% 7/6/2021 1,002,888 1.002,888 100.00 1,002,888 1/6/2023 281 0.57% .Treasury 0.13% Aaa/AAA/AAA 1/5/2022 5,000.000 4,987,313 98.82 4,940,820 1/31/2023 306 043% Veritex Community Bank 0.30% 2/5/2021 4.413,215 4.413,215 100.00 4,413,215 2/6/2023 312 0.30% FFCB 0.16% Aaa/AA+/AAA 11/22/2021 5,000,000 4,995,739 98.96 4,948,121 2/10/2023 316 0.26% Eagle Pass Texas 4.00% -/AA-/- 6/7/2021 645,000 667,466 102.17 659,009 3/1/2023 335 0.20% Prosperity Bank 0.25% 3/5/2021 10,025.029 10,025,029 100.00 10,025.029 3/6/2023 340 0.25% Bank OZK 0.26% 3/8/2021 2.535.695 2.535,695 100.00 2,535,695 3/8/2023 342 0.26% FFCB 0.13% Aaa/AA+/AAA 3/26/2021 9,000.000 8,997,790 98.44 8,859,337 3/23/2023 357 015% Prosperity Bank 0.20% 4/12/2021 5,009,158 5,009,158 100.00 5,009,158 4/12/2023 377 0.20% FFCB 0.13% Aaa/AA+/AAA 4/13/2021 5,000,000 4,996,582 98.35 4,917,493 4/13/2023 378 0.19% FFCB 0.38% Aaa/AA+/AAA 1/28/2022 4,000,000 3,977,636 98.45 3,938,164 4/27/2023 392 0.90% Prosperity Bank 0.20% 5/19/2021 10,016,670 10.016.670 100.00 10,016.670 5/19/2023 4141 0.20% Veritex Community Bank 0.20% 6/1/2021 20,029,933 20,029,933 100.00 20,029,933 6/1/2023 4271 0.20% 7 City of Round Rock Valley View Consulting, L.L.C. Holdings by Allocation and Portfolio (Fund) March 31, 2022 Coupon Credit Rating Settlement Face Amount/ Book Value Market Value Maturity Date Market Days to YTM Issuer Rate Date Shares Price Maturity Book Bank OZK 0.20% 6/9/2021 8,012,035 8,012,035 100.00 8,012,035 6/9/2023 435 0.20% R Bank 0.70% 7/6/2021 1,003,545 1,003,545 100.00 1,003,545 7/6/2023 462 0.70% Treasury 1.25% Aaa/AAA/AAA 7/7/2021 8,000,000 8,109,397 98.96 7,917,187 7/31/2023 487 0.22% Veritex Community Bank 0.25% 7/30/2021 7,008,825 7,008,825 100.00 7,008,825 7/31/2023 487 0.25% Dallas ISD 4.00% Aaa/AAA/AAA 4/22/2021 4,195,000 4,409,925 102.67 4,306,923 8/15/2023 502 0.26% Arlington TX HGR EDU 0.63% -/AAA/- 4/28/2021 1,460,000 1,460,000 97.70 1,426,376 8/15/2023 502 0.63% Veritex Community Bank 0.25% 8/23/2021 4,405,547 4,405,547 100.00 4,405,547 8/23/2023 510 0.25% FHLMC 0.25% Aaa/AA+/AAA 1/28/2022 5.000,000 4,944,725 97.45 4,872,594 8/24/2023 511 1.05% FNMA 2.880/6 Aaa/AA+/AAA 3/30/2022 4,000,000 4,038,122 101.01 4,040,575 9/12/2023 530 2.20% Treasury 0.25% Aaa/AAA/AAA 9/30/2021 10,000,000 9,993,109 97.22 9,722,265 9/30/2023 548 0.30% FHLMC 2.00% Aaa/AA+/AAA 2/28/2022 5,000,000 5,034,625 100.06 5,002,900 10/17/2023 565 1.55% Treasury 2.88% Aaa/AAA/AAA 11/22/2021 10,000,000 10,378,550 101.07 10,106,640 10/31/2023 579 0.47% FHLB 0.50% Aaa/AA+/- 11/12/2021 5,000,000 4,998,140 97.33 4,866,498 11/9/2023 588 0.52% Treasury 2.88% Aaa/AAA/AAA 11/10/2021 5,000,000 5,201,890 101.05 5,052,344 11/30/2023 609 0.44% FHLB 0.50% Aaa/AA+/- 12/7/2021 8,000,000 7,977,293 97.24 7,779,518 12/8/2023 617 0.67% FHLB 0.63% Aaa/AA+/- 1/5/2022 5,000,000 4,987,489 97.20 4,860,091 12/22/2023 631 0.77% FFCB 0.90% Aaa/AA+/AAA 1/28/2022 5,000,000 4,974,312 97.84 4,892,219 1/18/2024 658 1.19% Treasury 2.25% Aaa/AAA/AAA 1/5/2022 8,000,000 8,215,790 99.89 7,991,562 1/31/2024 671 0.77% Treasury 2.38% Aaa/AAA/AAA 2/14/2022 14,000,000 14,204,509 100.11 14,015,312 2/29/2024 700 1.60% FHLB 1.88% Aaa/AA+/- 2/28/2022 15,000,000 15,075,031 99.15 14,872,251 3/8/2024 708 1.61% Treasury 2.25% Aaa/AAA/AAA 3/30/2022 10,000,000 9,962,150 99.73 9,973,437 4/30/2024 761 2.44% Sub Total/Average 0.75% 418,208,754 1 419,578,876 1 99.69 416,905,735 316 0.52% Fund 170-Interest&Sinking GO Bonds TexasDAILY 0.14% AAAm 4/30/2016 191,088 191,088 100.00 191,088 N/A 1 0.14% NexBank 0.55% 2/27/2017 693,628 693,628 100.00 693,628 N/A 1 0.55% TexPool 0.15% AAAm 9/30/2015 2,694,797 2,694,797 100.00 2,694,797 N/A 1 0.15% East West Bank 0.27% 1/10/2022 8,004,795 8,004,795 100.00 8,004,795 7/11/2022 102 0.27% East West Bank 0.48% 2/1/2022 2,802,173 2,802,173 100.00 2,802,173 8/1/2022 123 0.48% East West Bank 0.73% 2/16/2022 5,004,402 5,004,402 100.00 5,004,402 8/10/2022 132 0.73% Sub Total/Average 1 0.41% 19,390,883 19,390,883 100.00 19,390,883 94 0.41% Fund 210-Interest&Sinking Debt Service JPMor an Chase 0.15% 9/30/2015 4,525 4,525 100.00 4,525 N/A 1 0.15% Sub Total/Average 0.15% 4,525 4,525 100.00 4,525 1 0.15% Fund 462-2017 Bond Fund TexPool 0.15% AAAm 5/30/2017 3,331,941 3,331,941 100.00 3,331,941 N/A 1 0.15% NexBank 0.55% 3/30/2020 1,612,956 1,612,956 100.00 1,612,956 N/A 1 0.55% East West Bank 0.26% 12/28/2021 6,004,019 6,004,019 100.00 6,004,019 6/28/2022 89 0.26% Sub Total/Average 0.27% 10,948,916 10,948,916 100.00 10,948,916 49 0.27% Fund 465-Road CO Bond Fund NexBank 0.55% 3/30/2022 6,691,345 6,691,345 100.00 6,691,345 N/A 1 0.55% TexPool 0.15% AAAm 9/1/2020 32,088 32,088 100.00 32,088 N/A 1 0.15% East West Bank 0.18% 12/9/2021 8,004,459 8,004,459 100.00 8,004,459 6/9/2022 70 0.18% Prosperity Bank 0.20% 7/6/2021 10,013,323 10,013,323 100.00 10,013,323 7/6/2022 97 0.20% Prosperity Bank 0.20% 6/1/2021 7,010,478 7,010,478 100.00 7,010,478 9/1/2022 154 0.20% Veritex Community Bank 0.30% 2/5/2021 5,616,819 5,616,819 100.00 5,616,819 2/6/2023 312 0.30% Sub Total/Average 0.27% 37,368,513 37,368,513 1 100.00 1 37,368,513 1 1171 0.27% 8 City of Round Rock Valley View Consulting,L.L.C. Holdings by Allocation and Portfolio (Fund) March 31, 2022 Coupon Settlement Face Amount/ Market Days torB000k_ Issuer Rate Credit Rating Date Shares Book Value price Market Value Maturity Date Maturity Fund 591 -Reserves Fund TexPool 0.15% AAAm 9/30/2015 8,725 8,725 100.00 8,725 N/A 11 0.15% NexBank 0.55% 4/29/2019 859,200 859,200 100.00 1 859,200 1 N/A 1 11 0.55% Sub Total/Average 0.55% 867,925 867,925 100.00 867,925 1 0.55% Fund 602-Interest&Sinking Revenue Bonds TexPool 0.15% AAAm 9/30/2015 3,574,046 3,574,046 100.00 3,574,046 1 N/A 1 0.15% East West Bank 0.27% 1/10/2022 2,001,199 2,001,199 100.00 2,001,199 1 7/11/2022 1 1021 0.27% Sub Total/Average 0.20% 5,575,244 5,575,244 100.00 5,575,244 1 371 0.20% Fund 605-Kalahari Debt Service Reserve TexPool 0.15% AAAm 8/30/2019 795,644 795,644 100.00 795,644 N/A 1 0.15% Sub Total/Average 0.15% 795,644 795,644 100.00 795,644 1 1 0.15% Fund 863-Drainage Utility Revenue Bond NexBank 0.55% 8/30/2020 215,879 215,879 100.00 215,879 N/A 1 0.55% TexPool 0.15% AAAm 10/31/2015 221,101 221,101 100.00 221,101 N/A 1 0.15% Sub Total/Average 0.35% 436,980 436,980 100.00 436,980 1 0.35% Total/Average 0.68% $ 493,597,384 $ 494,967,505 99.74 $ 492,294,365 282 9 City of Round Rock Valley View Consulting,L.L.C. Book Value Comparison March 31, 2022 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 $ 19,852,167 $ 15,264,435 $ 14,899,777 $ 20,216 825 $ 364,658 TexPool N/A 9/30/2015 N/A 38,192,515 2,237,606 29,687,762 10,742,359 27,450,156 TexSTAR N/A 9/30/2015 N/A 200,533 21 - 200,554 21 TexasDAILY N/A 9/30/2015 N/A 798,578 115 - 798,693 115 TexasDAILY N/A 6/1/2021 N/A 1,799,178 259 - 1,799438 259 TexasDAILY Select N/A 12/3/2021 N/A 1,000,194 463 - 1,000657 463 NexBank N/A 11/29/2016 N/A 36 128,965 635,000 6,688,798 30,075,167 6,053,798 R Bank N/A 11/29/2021 N/A 2,000,301 1,501,716 - 3,502,018 1,501,716 Veritex Community Bank N/A 9/1/2020 N/A 175,945 51 - 175,996 51 Texas Capital Bank N/A 7/1/2021 N/A 9,978,074 3,355,412 13,333,486 - 9,978 074 Prosperity Bank N/A 9/14/2021 N/A 6,005,078 1,782 1,500,000 4,506,860 1,498,218 Prosperity Bank N/A 9/14/2021 N/A 2,001,042 791 - 2,001 833 791 Bank OZK 1.70% 1/28/2020 1/24/2022 8,265,088 - 8,265,088 - (8,265,088) R Bank 1.75% 1/27/2020 1/27/2022 2,062,221 - 2,062,221 - (2,062,221) Allegiance Bank 1.59% 2/10/2020 2/10/2022 5,140,652 - 5,140,652 - 5,140,652 Goose Creek ISD 5.00% 11/17/2020 2/15/2022 402,341 - 400,000 - 402,341 East West Bank 1.54% 2/18/2020 2/18/2022 5,146,178 6,735 5,152,913 - 5,146,178 East West Bank 0.17% 2/19/2021 2/21/2022 11,101,109 1,603 11 102,712 - (11,101,109 FORT BEND COUNTY-REF 5.00% 6/17/2020 3/1/2022 251,638 - 250,000 - 251,638 Allegiance Bank 0.40% 6/17/2020 3/18/2022 10,059,985 - 10 059,985 - 10 059,985 Independent Bank 0.40% 1/11/2021 4/11/2022 20,059,895 20,225 - 20,080,120 20,225 Veritex Community Bank 0.20% 2/5/2021 5/5/2022 3,004,490 1,515 - 3,006,005 1,515 Prosperity Bank 0.20% 2/12/2021 5/12/2022 4,006,646 1,976 - 4,008,622 1,976 Independent Bank 0.30% 5/19/2021 5/19/2022 6,009,077 4,544 - 6,013 621 4,544 Allegiance Bank 0.45% 6/17/2020 6/17/2022 12,081,005 13,405 - 12,094,410 13,405 Bank OZK 0.50% 7/9/2020 7/11/2022 10,071,196 12,422 - 10,083618 12,422 Veritex Community Bank 0.24% 2/5/2021 8/5/2022 3,005,388 1,818 - 3,007,206 1,818 Prosperity Bank 0.20% 2/12/2021 8/12/2022 3,004,985 1,482 - 3,006,467 1,482 Arlington TX HGR EDU 0.50% 4/28/2021 8/15/2022 500,000 - - 500 000 - Bexar Co Txb Ref 0.33% 9/23/2021 8/15/2022 560,000 - - 560,000 - City of Bryan TX 0.45% 11/19/2020 8/15/2022 500,000 - - 500,000 - Denton ISD 0.00% 12/17/2020 8/15/2022 498,569 - - 499,136 567 City of Austin GO 0.27% 10/6/2020 9/1/2022 700,000 - - 700,000 - Prosperity Bank 0.20% 6/1/2021 9/1/2022 3,003,009 1,481 - 3,004,491 1,481 Veritex Community Bank 0.18% 3/5/2021 9/5/2022 8,010,854 3,556 - 8,014,410 3,556 State of Texas 2.52% 10/14/2021 10/1/2022 5,088,622 - - 5,059,513 29,109 State of Texas 1.61% 3/19/2021 10/1/2022 3,285,572 - - 3,273,888 11,684 Prosperity Bank 0.40% 10/15/2020 10/17/2022 6,028,058 5,947 - 6,034,005 5,947 Veritex Community Bank 0.26% 2/5/2021 11/4/2022 3,005,838 1,970 - 3,007,808 1,970 Prosperity Bank 0.20% 2/12/2021 11/14/2022 3,004,985 1 482 - 31006,467 1 482 R Bank 0.48% 11/24/2021 11/23/2022 4,000,000 4,842 - 4,004 842 4,842 Bank OZK 0.28% 12/7/2020 12/7/2022 5,014,068 3,475 - 5,017,543 3,475 Prosperity Bank 0.20% 6/9/2021 12/9/2022 10,010,032 4,937 - 10,014 969 4 937 Veritex Community Bank 0.28% 1/6/2021 1/6/2023 4,008,383 2,829 - 4,011,212 2,829 R Bank 0.57% 7/6/2021 1/6/2023 1,001,443 1,445 - 1,002,888 1,445 Treasury 0.13% 1/5/2022 1/31/2023 - 4,986 472 - 4,987 313 4198713,13 Veritex Community Bank 0.30% 2/5/2021 2/6/2023 4,409,880 3,335 - 4,413 215 3 335 FFCB 0.16% 11/22/2021 2/10/2023 4,994,526 - - 4,995 739 1!213 Eagle Pass Texas 4.00% 6/7/2021 3/1/2023 673,501 - - 667,466 6,036 Prosperity Bank 0.25% 3/5/2021 3/6/2023 10,018,8516,177 - 10,025,029 6,177 Bank OZK 0.26% 3/8/2021 3/8/2023 2,534,064 1,631 - 2,535,695 1,631 FFCB 0.13% 1 3/26/2021 3/23/2023 8,997,233 - - 8,997,790 557 10 City of Round Rock Valley View Consulting,L.L.C. Book Value Comparison March 31, 2022 Issuer Coupon Settlement Maturity Beginning Book Total Buys/ Total Sells/ Ending Book Change in Book Rate Date Date Value Increases Decreases Value Value Prosperity Bank 0.20% 4/12/2021 4/12/2023 5,006,689 2,469 - 5,009,158 2,469 FFCB 0.13% 4/13/2021 4/13/2023 4,995 769 - - 4,996,582 814 FFCB 0.38% 1/28/2022 4/27/2023 - 3,977,890 - 3,977,636 3,977,636 Prosperity Bank 0.20% 5/19/2021 5/19/2023 10,011,732 4,938 - 10,016,670 4,938 Veritex Community Bank 0.20% 6/1/2021 6/1/2023 20,020,060 9,873 - 20,029,933 9,873 Bank OZK 0.20% 6/9/2021 6/9/2023 8,008,065 3,970 - 8,012,035 3,970 R Bank 0.70% 7/6/2021 7/6/2023 1,001,771 1,774 - 1,003,545 1,774 Treasury 1.25% 7/7/2021 7/31/2023 8,129 615 - - 81109,397 20 217 Veritex Community Bank 0.25% 7/30/2021 7/31/2023 7,004,411 4,414 - 7,008,825 4,414 Arlington TX HGR EDU 0.63% 4/28/2021 8/15/2023 1,460,000 - - 1,460,000 - Dallas ISD 4.00% 4/22/2021 8/15/2023 4,448,458 - - 4,409,925 38,532 Veritex Community Bank 0.25% 8/23/2021 8/23/2023 4,402,773 2,774 - 4,405,547 2,774 FHLMC 0.25% 1/28/2022 8/24/2023 - 4,943,366 - 4,944,725 4,944,725 FNMA 2.88% 3/30/2022 9/12/2023 - 4,043,944 - 4,038,122 4,038,122 Treasury 0.25% 9/30/2021 9/30/2023 9,991,977 - - 9,993,109 1,132 FHLMC 2.00% 2/28/2022 10/17/2023 - 5,072,914 - 5,034,625 5,034,625 Treasury 2.88% 11/22/2021 10/31/2023 10,437 392 - - 10 378,550 58,842 FHLB 0.50% 11/12/2021 11/9/2023 4,997,855 - - 4998,140 285 Treasury 2.88% 11/10/2021 11/30/2023 5,231,726 - - 5,201,890 29,836 FHLB 0.50% 12/7/2021 12/8/2023 7,973,981 - - 7,977,293 3,312 FHLB 0.63% 1/5/2022 12/22/2023 - 4,986,932 - 4,987,489 4,987,489 FFCB 0.90% 1/28/2022 1/18/2024 - 4,973,141 - 4,974,312 4 974 312 Treasury 2.25% 1/5/2022 1/31/2024 - 8,320,408 - 8,215,790 8,215,790 Treasury 2.38% 2/14/2022 2/29/2024 - 14 371,047 - 14 204,509 14,204,509 FHLB 1.88% 2/28/2022 3/8/2024 - 15,211,128 - 15,075,031 15,075,031 Treasury 2.25% 3/30/2022 4/30/2024 - 10,055,332 - 9,962,150 9,962,150 Sub Total/Average Fund 000-Pooled Investments 424,774,228 104,079,271 108,543,394 419,578,876 5,195,352 Fund 170-Interest&Sinking GO Bonds TexPool N/A 9/30/2015 N/A 3,159,185 7,887,851 8,352,239 2,694,797 464,388 TexasDAILY N/A 4/30/2016 N/A 191,061 28 - 191,088 28 NexBank N/A 2/27/2017 N/A 1,292,712 916 600,000 693,628 599,084 East West Bank 0.27% 1/10/2022 7/11/2022 - 8,004,795 - 8,004,795 8,004,795 East West Bank 0.48% 2/1/2022 8/1/2022 - 2,802,173 - 2,802,173 2,802,173 East West Bank 0.73% 2/16/2022 8/10/2022 - 5,004,402 - 5,004,402 5,004,402 Sub Total/Average Fund 170-Interest&Sinking GO Bonds 1 1 4,642,957 1 23,700,164 1 8,952,239 1 19,390,883 14,747,925 Fund 210-Interest&Sinking Debt Service JPMor an Chase N/A 9/30/2015 N/A 8,342 796,183 800,000 1 4,525 3,817 Sub Total/Average Fund 210-Interest&Sinking Debt Service 8,342 796,183 800,000 4,525 3,817 Fund 462-2017 Bond Fund TexPool N/A 5/30/2017 N/A 3,331,238 703 - 3,331,941 703 NexBank N/A 3/30/2020 N/A 1,611,300 1,656 - 1,612,956 1,656 East West Bank 0.26% 12/28/2021 6/28/2022 6,000,171 3,848 1 6,004,019 1 3,848 Sub Total/Average Fund 462-2017 Bond Fund 10,942,710 6,207 - 10,948,916 6,207 Fund 465-Road CO Bond Fund TexPool N/A 9/1/2020 N/A 32,081 7 - 32,088 7 NexBank N/A 3/30/2022 N/A - 6,691 345 - 6,691,345 61691,345 Texas Capital Bank N/A 6/1/2021 N/A 10,039,357 2,048 10,041,405 - 10,039,357 East West Bank 0.18% 12/9/2021 6/9/2022 8,000,907 3,552 - 8,004,459 3,552 Prosperity Bank 0.20% 7/6/2021 7/6/2022 10,008,386 4,936 - 10,013,323 4,936 Prosperity Bank 0.20% 6/1/2021 9/1/2022 7,007,022 3,456 - 7,010 478 3,456 11 City of Round Rock Valley View Consulting, L.L.C. Book Value Comparison March 31, 2022 Issuer Coupon Settlement Maturity Beginning Book Total Buys/ Total Sells/ Ending Book Change in Book Rate Date Date Value Increases Decreases Value Value Veritex Community Bank 0.30% 2/5/2021 2/6/2023 5,612,575 4,244 - 5,616,819 4,244 Sub Total/Average Fund 465-Road CO Bond Fund 40,700,329 6,709,589 10,041,405 37,368,513 3,331,816 Fund 591 -Reserves Fund TexPool N/A 9/30/2015 N/A 8,723 2 - 8,725 2 NexBank N/A 4/29/2019 N/A 858,318 882 - 859,200 882 Sub Total/Average Fund 591 -Reserves Fund 867,041 884 - 867,925 1 884 Fund 602-Interest&Sinking Revenue Bonds TexPool N/A 9/30/2015 N/A 3,927,536 734 354,224 3,574,046 353,490 East West Bank 0.27% 1/10/2022 7/11/2022 - 1 2,001,199 1 - 2,001,199 1 2,001,199 Sub Total/Average Fund 602-Interest&Sinking Revenue Bonds 3,927,536 2,001,932 354,224 5,575,244 1,647,709 Fund 605-Kalahari Debt Service Reserve TexPool N/A 8/30/2019 N/A 253,068 1,455,593 913,017 795,644 542,576 Sub Total/Average Fund 605-Kalahari Debt Service Reserve 253,068 1,455,593 913,017 795,644 542,576 Fund 863-Drainage Utility Revenue Bond TexPool N/A 10/31/2015 N/A 222,132 47 1,078 221,101 (1,031) NexBank N/A 8/30/2020 N/A 215,657 222 - 215,879 222 Sub Total/Average Fund 863-Drainage Utility Revenue Bond 437,789 268 1,078 436,980 (809 Total/Average $ 486,553,998 $ 138,750,093 $ 129,605,356 $ 494,967,505 $ 8,413,507 12 City of Round Rock Valley View Consulting, L.L.C. Market Value Comparison March 31, 2022 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 $ 19,852,167 $ 15,264,435 $ 14,899,777 $ 20,216 825 $ — TexPool N/A 9/30/2015 N/A 38,192,515 2,237,606 29,687,762 10,742 359 — TexSTAR N/A 9/30/2015 N/A 200,533 21 — 200,554 — TexasDAILY N/A 9/30/2015 N/A 798,578 115 — 798,693 — TexasDAILY N/A 6/1/2021 N/A 1,799,178 259 — 1,799,438 — TexasDAILY Select N/A 12/3/2021 N/A 1,000 194 463 — 1.000,657 — NexBank N/A 11/29/2016 N/A 36,128,965 635,000 6,688,798 30,075,167 — R Bank N/A 11/29/2021 N/A 2,000,301 1,501,716 — 3,502 018 — Veritex Community Bank N/A 9/1/2020 N/A 175,945 51 — 175,996 — Texas Capital Bank N/A 7/1/2021 N/A 9,978,074 3,355,412 13,333,486 — — Prosperity Bank N/A 9/14/2021 N/A 6,005,078 1,782 1,500,000 4,506,860 — Trosperity Bank N/A 9/14/2021 N/A 2,001042 791 — 2,001833 — Bank OZK 1.70% 1/28/2020 1/24/2022 8,265,088 — 8,265,088 — — R Bank 1.75% 1/27/2020 1/27/2022 2,062,221 — 2,062,221 — — Allegiance Bank 1.59% 2/10/2020 2/10/2022 5,140,652 — 5,140,652 — — Goose Creek ISD 5.00% 11/17/2020 2/15/2022 402,048 — 400,000 — 2,048 East West Bank 1.54% 2/18/2020 2/18/2022 5,146,178 6,735 5,152,913 — — East West Bank 0.17% 2/19/2021 2/21/2022 11,101 109 1,603 11,102,712 — — FORT BEND COUNTY-REF 5.00% 6/17/2020 3/1/2022 251,898 — 250,000 — 1,898 Allegiance Bank 0.40% 6/17/2020 3/18/2022 10,059,985 — 10,059,985 — — Inde endent Bank 0.40% 1/11/2021 4/11/2022 20,059,895 20,225 — 20,080,120 — Veritex Community Bank 0.20% 2/5/2021 5/5/2022 3,004,490 1,515 — 3,006,005 — Prosperity Bank 0.20% 2/12/2021 5/12/2022 4,006,646 1,976 — 4,008,622 — Independent Bank 0.30% 5/19/2021 5/19/2022 6,009,077 4,544 — 6,013,621 — Allegiance Bank 0.45% 6/17/2020 6/17/2022 12,081,005 13,405 — 12,094,410 — Bank OZK 0.50% 7/9/2020 7/11/2022 10,071,196 12,422 — 10 083,618 — Veritex Community Bank 0.24% 2/5/2021 8/5/2022 3,005,388 1,818 — 3 007 206 Prosperity Bank 0.20% 2/12/2021 8/12/2022 3,004,985 1,482 — 31006,467 Arlington TX HGR EDU 0.50% 4/28/2021 8/15/2022 499,830 — — 497,280 2,550 Bexar Co Txb Ref 0.33% 9/23/2021 8/15/2022 559,054 — — 558,678 375 Zity of Bryan TX 0.45% 11/19/2020 8/15/2022 499,945 — — 498,980 965 Denton ISD 0.00% 12/17/2020 8/15/2022 498,845 — — 498 110 735 Cit of Austin GO 0.27% 10/6/2020 9/1/2022 699,832 — — 698,138 1,694 Prosperity Bank 0.20% 6/1/2021 9/1/2022 3,003,009 1 481 — 3 004 491 — Veritex CommunityBank 0.18% 3/5/2021 9/5/2022 8,010,854 3,556 — 8,014,410 — State of Texas 2.52% 10/14/2021 10/1/2022 5,079,400 — — 5,035 450 43,950 State of Texas 1.61% 3/19/2021 10/1/2022 3,279,965 — — 3,258,710 21,255 Prosperity Bank 0.40% 10/15/2020 10/17/2022 6,028 058 5,947 — 6,034,005 — Veritex Community Bank 0.26% 2/5/2021 11/4/2022 3,005,838 1,970 — 3,007,808 Prosperity Bank 0.20% 2/12/2021 11/14/2022 3,004,985 1,482 — 3,006,467 — R Bank 0.48% 11/24/2021 11/23/2022 4,000,000 4,842 — 4,004,842 — Bank OZK 0.28% 12/7/2020 12/7/2022 5,014,068 3,475 — 5,017,543 Prosperity Bank 0.20% 6/9/2021 12/9/2022 10,010,032 4,937 — 10,014,969 — Veritex Community Bank 0.28% 1/6/2021 1/6/2023 4,008,383 2,829 — 4,011 212 — R Bank 0.57% 7/6/2021 1/6/2023 1,001 443 1,445 — 1,002 888 — Treasury 0.13% 1/5/2022 1/31/2023 — 4,986 472 — 4 940 820 (42,969) Veritex Community Bank 0.30% 2/5/2021 2/6/2023 4,409,880 3,335 — 41413,215 — FFCB 0.16% 11/22/2021 2/10/2023 4,979,927 — — 4,948,121 (31,806) 'Eagle Pass Texas 4.00% 6/7/2021 3/1/2023 672,709 — — 659,009 13,700 Prosperity Bank 0.25% 3/5/2021 3/6/2023 10,018,851 6,177 — 10,025,029 — Bank OZK 0.26% 3/8/2021 3/8/2023 2,534,064 1,631 — 2,535,695 — FFCB 0.13% 3/26/2021 3/23/2023 8,957,428 — — 8,859,337 98,091 13 City of Round Rock Valley View Consulting, L.L.C. Market Value Comparison March 31, 2022 Issuer Coupon Settlement Maturity Beginning Total Buys/ Total Sells/ Ending Market Change in Rate Date Date Market Value Increases Decreases Value Market Value Prosperity Bank 0.20% 4/12/2021 4/12/2023 5,006,689 2,469 - 5,009,158 - FFCB 0.13% 4/13/2021 4/13/2023 4,973,246 - - 4,917,493 55,754 FFCB 0.38% 1/28/2022 4/27/2023 - 3,977,890 - 3,938,164. 35,935 Prosperity Bank 0.20% 5/19/2021 5/19/2023 10,011,732 4,938 - 10,016,670 - Veritex Community Bank 0.20% 6/1/2021 6/1/2023 20,020,060 9,873 - 20,029,933 - Bank OZK 0.20% 6/9/2021 6/9/2023 8,008,065 3,970 - 8,012,035 - R Bank 0.70% 7/6/2021 7/6/2023 1,001,771 1,774, - 1,003,545 - Treasury 1.25% 7/7/2021 7/31/2023 8,080,304 - - 7,917,187 (163,117) Veritex Community Bank 0.25% 7/30/2021 7/31/2023 7,004,411 4,414 - 7,008,825 - Artin ton TX HGR EDU 0.63% 4/28/2021 8/15/2023 1,453,182 - - 1,426,376 26,806 Dallas ISD 4.00% 4/22/2021 8/15/2023 4,422,159 - - 4,306,923 115,237 Veritex Community Bank 0.25% 8/23/2021 8/23/2023 4,402,773 2,774 - 4,405,547 - FHLMC 0.25% 1/28/2022 8/24/2023 - 4,943,366 - 4,872,594 65,425 FNMA 2.88% 3/30/2022 9/12/2023 - 4,043,944 - 4,040,575 2 381 Treasury 0.25% 9/30/2021 9/30/2023 9,929,865 - - 9,722,265 207,600 FHLMC 2.00% 2/28/2022 10/17/2023 - 5,072,914 - 5,002,900 33,625 Treasury 2.88% 11/22/2021 10/31/2023 10,393,286 - - 10,106,640 286,646 FHLB 0.50% 11/12/2021 11/9/2023 4,977,639 - - 4,866,498 111,141 Treasury 2.88% 11/10/2021 11/30/2023 5,204,693 - - 5,052,344 152,350 FHLB 0.50% 12/7/2021 12/8/2023 7,956 935 - - 7,779,518 177,418 FHLB 0.63% 1/5/2022 12/22/2023 - 4,986,932 - 4,860,091 125,712 FFCB 0.90% 1/28/2022 1/18/2024 - 4,973 141 - 4,892,219 79 673 Treasury 2.25% 1/5/2022 1/31/2024 - 8,320,408 - 7,991,562 251,563 Treasury 2.38% 2/14/2022 2/29/2024 - 14,371 047 - 14,015.312 202,344 FHLB 1.88% 2/28/2022 3/8/2024 - 15,211,128 - 14,872,251 206,065 Treasury 2.25% 3/30/2022 4/30/2024 - 10,055 332 - 9,973,437 11,337 Sub Total/Average Fund 000-Pooled Investments 424,427,641 104,079,271 108,543,394 416,905,735 2,544,726 Fund 170-Interest&Sinking GO Bonds TexPool N/A 9/30/2015 N/A 3,159,185 7,887,851 8,352,239 2,694,797 - TexasDAILY N/A 4/30/2016 N/A 191,061 28 - 191,088 - NexBank N/A 2/27/2017 N/A 1,292,712 916 600,000 693,628 - East West Bank 0.27% 1/10/2022 7/11/2022 - 8,004,795 - 8,004,795 - East West Bank 0.48% 2/1/2022 8/1/2022 - 2,802,173 - 2,802,173 - East West Bank 0.73% 2/16/2022 8/10/2022 - 5,004,402 - 5,004,402 - Sub Total/Average Fund 170-Interest&Sinking GO Bonds 4,642,957 23,700,164 8,952,239 1 19,390,883 1 - Fund 210-Interest&Sinking Debt Service JPMor an Chase N/A 9/30/2015 N/A 8,342 796,183 800,000 1 4,525 1 - Sub Total/Average Fund 210-Interest&Sinking Debt Service 8,342 796,183 800,000 1 4,525 1 - Fund 462-2017 Bond Fund TexPool N/A 5/30/2017 N/A 3,331,238 703 - 3,331,941 - NexBank N/A 3/30/2020 N/A 1,611,300 1,656 - 1,612,956 - East West Bank 0.26% 12/28/2021 6/28/2022 6,000,171 3,848 - 6,004,019 - Sub Total/Average Fund 462-2017 Bond Fund 10,942,710 6,207 - 10,948,916 - Fund 465-Road CO Bond Fund TexPool N/A 9/1/2020 N/A 32,081 7 - 32,088 - NexBank N/A 3/30/2022 N/A - 6,691345 - 6,691345 - Texas Capital Bank N/A 6/1/2021 N/A 10,039,357 2,048 10,041,405 - - East West Bank 0.18% 12/9/2021 6/9/2022 8,000,907 3,552 - 8,004 459 Prosperity Bank 0.20% 7/6/2021 7/6/2022 10,008,386 4,936 - 10 013,323 Prosperity Bank 0.20% 6/1/2021 9/1/2022 7,007,022 3,456 - 7,010,478 - 14 City of Round Rock Valley View Consulting, L.L.C. Market Value Comparison March 31, 2022 Issuer Coupon Settlement Maturity Beginning Total Buys/ Total Sells/ Ending Market Change in Rate Date Date Market Value Increases Decreases Value Market Value Veritex Community Bank 0.30% 2/5/2021 2/6/2023 5,612,575 4,244 - 5,616,819 - Sub Total/Average Fund 465-Road CO Bond Fund 40,700,329 6,709,589 10,041,405 37,368,513 - Fund 591 -Reserves Fund TexPool N/A 9/30/2015 N/A 8,723 2 - 8,725 - NexBank N/A 4/29/2019 N/A 858,318 882 - 859,200 - Sub Total/Average Fund 591-Reserves Fund 1 867,041 1 884 - 1 867,925 1 - Fund 602-Interest&Sinking Revenue Bonds TexPool N/A 9/30/2015 N/A 3,927,536 734 354,224 3,574,046 - East West Bank 0.27% 1/10/2022 7/11/2022 - 1 2,001,199 - 2,001,199 - Sub Total/Average Fund 602-Interest&Sinking Revenue Bonds 3,927,536 1 2,001,932 1 354,2241 5,575,244 1 - Fund 605-Kalahari Debt Service Reserve TexPool N/A 8/30/2019 N/A 253,068 1 1,455 593 1 913,017 795,644 - Sub Total/Average Fund 605-Kalahari Debt Service Reserve 253,068 1 1,455,593 1 913,017 1 795,644 Fund 863-Drainage Utility Revenue Bond TexPool N/A 10/31/2015 N/A 222,132 47 1,078 221,101 - NexBank N/A 8/30/2020 N/A 215,657 222 - 215,879 - Sub Total/Average Fund 863-Drainage Utility Revenue Bond 437,789 1 268 1,078 436,980 - Total/Average $ 486,207,412 $ 138,750,093 $ 129,605,356 $ 492,294,365 $ 2,544,726 15 City of Round Rock Valley View Consulting, L.L.C. Holdings by Allocation and Portfolio (Fund) December 31, 2021 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 0.40% 11/29/2016 $ 36,128,965 $ 36,128,965 100.00 $ 36,128,965 N/A 1 0.40% TexasDAILY 0.02% AAAm 6/1/2021 1,799,178 1,799,178 100.00 1,799.178 N/A 1 0.02% Texas Capital Bank 0.15% 7/1/2021 9,978,074 9,978,074 100.00 9,978,074 N/A 1 0.15% TexasDAILY Select 0.11% AAAm 12/3/2021 1,000.194 1,000,194 100.00 1,000.194 N/A 1 0.11% Veritex Community Bank 0.10% 9/1/2020 175.945 175,945 100.00 175.945 N/A 1 0.10% R Bank 0.25% 11/29/2021 2.000.301 2,000,301 100.00 2,000,301 N/A 1 0.25% JPMor an Chase 0.15% 9/30/2015 19.852.167 19.852,167 100.00 19,852.167 N/A 1 015% TexSTAR 0.03% AAAm 9/30/2015 200,533 200,533 100.00 200,533 N/A 1 0.03% TexPool 0.03% AAAm 9/30/2015 38.192.515 38.192,515 100.00 38.192.515 N/A 1 0.03% Prosperity Bank 0.15% 9/14/2021 6,005,078 6,005.078 100.00 6,005,078 N/A 1 0.15% TexasDAILY 0.02% AAAm 9/30/2015 798,578 798.578 100.00 798,578 N/A 1 002% Prosperity Bank 0.15% 9/14/2021 2,001,042 2,001,042 100.00 2,001,042 N/A 1 0.15% Bank OZK 1.70% 1/28/2020 8.265,088 8.265.088 100.00 8,265.088 1/24/2022 24 1.70% R Bank 1.75% 1/27/2020 2,062,221 2,062,221 100.00 2,062,221 1/27/2022 27 1.75% Allegiance Bank 1.59% 2/10/2020 5.140,652 5.140,652 100.00 5.140.652 2/10/2022 41 1.59% Goose Creek ISD 5.00% Aaa/-/AAA 11/17/2020 400,000 402,341 100.51 402.048 2/15/2022 46 0.33% East West Bank 1.54% 2/18/2020 5,146,178 5.146.178 100.00 5,146,178 2/18/2022 49 1.54% East West Bank 0.17% 2/19/2021 11,101,109 11,101,109 100.00 11,101,109 2/21/2022 52 0.17% FORT BEND COUNTY-REF 5.00% Aa1/-/AA+ 6/17/2020 250,000 251,638 100.76 251,898 3/1/2022 60 0.98% Allegiance Bank 0.40% 6/17/2020 10,059.985 10.059,985 100.00 10,059.985 3/18/2022 77 0.40% Independent Bank 0.40% 1/11/2021 20,059,895 20.059.895 100.00 20,059,895 4/11/2022 101 0.40% Veritex Community Bank 0.20% 2/5/2021 3,004,490 3.004,490 100.00 3,004.490 5/5/2022 125 0.2077- Prosperity .20%Pros erit Bank 0.20% 2/12/2021 4,006,646 4,006,646 100.00 4,006.646 5/12/2022 132 0.20% Independent Bank 0.30% 5/19/2021 6,009.077 6,009,077 100.00 6,009,077 5/19/2022 139 0.30% Allegiance Bank 0.45% 6/17/2020 12,081,005 12,081,005 100.00 12,081,005 6/17/2022 168 0.45% Bank OZK 0.50% 7/9/2020 10.071.196 10.071,196 100.00 10,071,196 7/11/2022 192 0.50% Veritex Community Bank 0.24% 2/5/2021 3.005,388 3,005,388 100.00 3,005,388 8/5/2022 217 0.24% Prosperity Bank 0.20% 2/12/2021 3,004.985 3.004,985 100.00 3,004.985 8/12/2022 224 0.20% Bexar Co Txb Ref 0.33% A2/AA/A- 9/23/2021 560,000 560,000 99.83 559.054 8/15/2022 227 0.33% Arlington TX HGR EDU 0.50% -/AAA/- 4/28/2021 500,000 500,000 99.97 499,830 8/15/2022 227 0.50% Denton ISD 0.00% -/AAA/AAA 12/17/2020 500,000 498,569 99.77 498.845 8/15/2022 227 0.46% City of Bryan TX 0.45% -/AA/- 11/19/2020 500,000 500,000 99.99 499.945 8/15/2022 227 0.45% City of Austin GO 0.27% Aa1/AAA/AA+ 10/6/2020 700,000 700,000 99.98 699,832 9/1/2022 244 0.27% Prosperity Bank 0.20% 6/1/2021 3,003,009 3,003,009 100.00 3,003,009 9/1/2022 244 0.20% Veritex Community Bank 0.18% 3/5/2021 8,010.854 8,010,854 100.00 8,010.854 9/5/2022 248 0.18% State of Texas 1.61% Aaa/AAA/- 3/19/2021 3,250,000 3,285,572 100.92 3,279.965 10/1/2022 274 0.15% State of Texas 2.52% Aaa/AAA/- 10/14/2021 5.000,000 5.088.622 101.59 5,079,400 10/1/2022 274 0 15% Prosperity Bank 0.40% 10/15/2020 6,028,058 6,028,058 100.00 6,028,058 10/17/2022 290 0.40% Veritex Community Bank 0.26% 2/5/2021 3,005,838 3.005.838 100.00 3.005,838 11/4/2022 308 0.26% Prosperity Bank 0.20% 2/12/2021 3,004,985 3.004,985 100.00 3,004,985 11/14/2022 318 0.20% R Bank 0.48% 11/24/2021 4,000,000 4.000.000 100.00 4,000.000 11/23/2022 327 0.48% Bank OZK 0.28% 12/7/2020 5,014,068 5,014,068 100.00 5,014,068 12/7/2022 341 0.28% Prosperity Bank 0.20% 6/9/2021 10,010,032 10.010,032 100.00 10,010,032 12/9/2022 343 0.20% Veritex Community Bank 0.28% 1/6/2021 4,008,383 4.008,383 100.00 4,008,383 1/6/2023 371 0.28% R Bank 0.57% 7/6/2021 1,001,443 1.001,443 100.00 1,001,443 1/6/2023 371 0.57% Veritex Community Bank 0.30% 2/5/2021 4.409,880 4,409.880 100.00 4,409,880 2/6/2023 402 0.30% FFCB 0.16% Aaa/AA+/AAA 11/22/2021 5,000.000 4,994,526 99.60 4,979,927 2/10/2023 406 0.26% .Eagle Pass Texas 4.00% -/AA-/- 6/7/2021 645.000 673,501 104.30 672,709 3/1/2023 4251 0.20% 16 City of Round Rock Valley View Consulting, L.L.C. Holdings by Allocation and Portfolio (Fund) December 31, 2021 Coupon Settlement Face AmounU Market Days to YTM @ Issuer Credit Rating Book Value Market Value Maturity Date Rate Date Shares Price Maturity Book Prosperity Bank 0.25% 3/5/2021 10,018,851 10,018,851 100.00 10,018,851 3/6/2023 430 0.25% Bank OZK 0.26% 3/8/2021 2,534,064 2,534,064 100.00 2,534,064 3/8/2023 432 0.26% FFCB 0.13% Aaa/AA+/AAA 3/26/2021 9,000,000 8,997,233 99.53 8,957,428 3/23/2023 447 0.15% Prosperity Bank 0.20% 4/12/2021 5,006,689 5,006,689 100.00 5,006,689 4/12/2023 467 0.20% FFCB 0.13% Aaa/AA+/AAA 4/13/2021 5,000,000 4,995,769 99.46 4,973,246 4/13/2023 468 0.19% Prosperity Bank 0.20% 5/19/2021 10,011,732 10,011,732 100.00 10,011,732 5/19/2023 504 0.20% Veritex Community Bank 0.20% 6/1/2021 20,020,060 20,020,060 100.00 20,020,060 6/1/2023 517 0.20% Bank OZK 0.20% 6/9/2021 8,008,065 8,008,065 100.00 8,008,065 6/9/2023 525 0.20% R Bank 0.70% 7/6/2021 1,001,771 1,001,771 100.00 1,001,771 7/6/2023 552 0.70% Treasury 1.25% Aaa/AAA/AAA 7/7/2021 8,000,000 8,129,615 101.00 8,080,304 7/31/2023 577 0.22% Veritex Community Bank 0.25% 7/30/2021 7,004,411 7,004,411 100.00 7,004,411 7/31/2023 577 0.25% Dallas ISD 4.00% Aaa/AAA/AAA 4/22/2021 4,195,000 4,448,458 105.42 4,422,159 8/15/2023 592 0.26% Arlington TX HGR EDU 0.63% -/AAA/- 4/28/2021 1,460,000 1,460,000 99.53 1,453,182 8/15/2023 592 0.63% Veritex Community Bank 0.25% 8/23/2021 4,402,773 4,402,773 100.00 4,402,773 8/23/2023 600 0.25% Treasury 0.25% Aaa/AAA/AAA 9/30/2021 10,000,000 9,991,977 99.30 9,929,865 9/30/2023 638 0.30% Treasury 2.88% Aaa/AAA/AAA 11/22/2021 10,000,000 10,437,392 103.93 10,393,286 10/31/2023 669 0.47% FHLB 0.50% Aaa/AA+/- 11/12/2021 5,000,000 4,997,855 99.55 4,977,639 11/9/2023 6781 0.52% Treasury 2.88% Aaa/AAA/AAA 11/10/2021 5,000,000 5,231,726 104.09 5,204,693 11/30/2023 6991 0.44% FHLB 0.50% Aaa/AA+/- 12/7/2021 8,000,000 7,973,981 99.46 7,956,935 12/8/2023 7071 0.67% Sub Total/Average 0.52% 423,615,452 424,774,228 100.19 424,427,641 2541 0.34% Fund 170-Interest&Sinking GO Bonds TexasDAILY 0.02% AAAm 4/30/2016 191,061 191,061 100.00 191,061 N/A 1 0.02% NexBank 0.40% 2/27/2017 1,292,712 1,292,712 100.00 1,292,712 N/A 1 0.40% TexPool 0.03% AAAm 9/30/2015 3,159,185 3,159,185 100.00 3,159,185 N/A 1 0.03% Sub Total/Average 0.13% 4,642,957 4,642,957 100.00 4,642,957 Fund 210-Interest&Sinking Debt Service JPMor an Chase 0.15% 9/30/2015 8,342 8,342 1 100.00 8,342 N/A 1 0.15% Sub Total/Average 0.15% 8,342 8,342 1 100.00 8,342 1 0.15% Fund 462-2017 Bond Fund TexPool 0.03% AAAm 5/30/2017 3,331,238 3,331,238 100.00 3,331,238 N/A 1 0.03% NexBank 0.40% 3/30/2020 1,611,300 1,611,300 100.00 1,611,300 N/A 1 0.40% East West Bank 0.26% 12/28/2021 6,000,171 6,000,171 100.00 6,000,171 6/28/2022 179 0.26% Sub Total/Average 0.21% 10,942,710 10,942,710 100.00 10,942,710 99 0.21% Fund 465-Road CO Bond Fund Texas Capital Bank 0.15% 6/1/2021 10,039,357 10,039,357 100.00 10,039,357 N/A 1 0.15% TexPool 0.03% AAAm 9/1/2020 32,081 32,081 100.00 32,081 N/A 1 0.03% East West Bank 0.18% 12/9/2021 8,000,907 8,000,907 100.00 8,000,907 6/9/2022 160 0.18% .Prosperity Bank 0.20% 7/6/2021 10,008,386 10,008,386 100.00 10,008,386 7/6/2022 187 0.20% Prosperity Bank 0.20% 6/1/2021 7,007,022 7,007,022 100.00 7,007,022 9/1/2022 244 0.20% Veritex Community Bank 0.30% 2/5/2021 5,612,575 5,612,575 100.00 5,612,575 2/6/2023 402 0.30% Sub Total/Average 0.20% 40,700,329 40,700,329 100.00 40,700,329 1 1751 0.20% Fund 591 -Reserves Fund TexPool 0.03% AAAm 9/30/2015 8,723 8,723 100.00 8,723 N/A 11 0.03% NexBank 0.40% 4/29/2019 858,318 1 858,318 1 100.00 1 858,318 1 N/A 1 11 0.40% Sub Total/Average 0.40% 867,041 1 867,041 1 100.00 1 867,041 1 11 0.40% 17 City of Round Rock Valley View Consulting, L.L.C. Holdings by Allocation and Portfolio (Fund) December 31, 2021 Coupon Settlement Face Amount/ Market Days to YTM @ Issuer Credit Rating Book Value Market Value Maturity Date Rate Date Shares Price Maturity Book Fund 602-Interest&Sinking Revenue Bonds TexPool 1 0.03% AAArn 1 9/30/2015 3,927,536 1 3,927,536 1 100.00 3.927,536 1 N/A 1 0.03% Sub Total/Average 1 0.03% 1 3,927,536 1 3,927,536 1 100.00 3,927,536 1 1 0.03% Fund 605-Kalahari Debt Service Reserve TexPool 1 0.03°/ AAAm 8/30/2019 253,068 1 253.068 100.00 253.068 1 N/A 1 0 03% Sub Total/Average 1 0.03% 253,068 1 253,068 100.00 253,068 1 1 0.03% Fund 863-Drainage Utility Revenue Bond NexBank 0.400/. 8/30/2020 215,657 215,657 100.00 215.657 1 N/A 1 1 0.40% TexPool 0.03% AAAm 10/31/2015 222,132 222,132 100.00 222,132 N/A 1 0.03% Sub Total/Avera a 0.21% 1 437,789 437,789 100.00 437,789 1 0.21% Total/Average 0.48% 1 1 $ 485,395,222 $ 486,553,998 100.17 $ 486,207,412 238 0.32% 18 City of Round Rock Valley View Consulting, L.L.C.