Loading...
Contract - City of Round Rock - 8/11/2022 ROUND ROCK TEXAS FINANCE. QUARTERLY INVESTMENT REPORT For the Quarter Ended June 30, 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. Cbef. inancial fic Deputy Chief Financial OfAcer Con oller Trea6h Accountant 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. -2DZZ-20 Summary Holdings by Investment Category(Security Sector) June 30,2022 YTM @ Description Cost Book Value Market Value Cash 0.28% $ 26,709,867 $ 26,709,867 Certificates of Deposit 0.28% 176,250,434 176,250,434 Local Government Investment Pool 1.02% 64,601,951 64,601,951 Money Market Accounts 1.57% 1 48,915,862 48,915,862 Municipal 0.32% 18,044,191 17,822,639 US Agency 1.64% 115,925,690 114,186,567 US Treasury 1.47% 113,346,588 111,398,146 Total/Average 1.00% $ 563,794,584 $ 559,885,468 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 Average Yield Current Fiscal Year- Quarter(1) to-Date(2) Total Portfolio 1.00% 0.60% TexPool Yield 1.00% 0.40% Rolling Three Mo.Treas.Yield 1.13% 0.50% Rolling Six Mo.Treas.Yield 1.15% 0.53% Rolling 1 Yr.Treas.Yield 0.87% 0.44% Rolling 2 Yr.Treas.Yield 0.70% 0.47% Investment Income(3) Interest Income(Approximate) $ 844,968 $ 1,638,927 WAM at 6/30/2022 Policy WAM Max Total Portfolio 262 days 540 days Pooled Funds 297 days 540 days (1)Average Yield calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. (2)Fiscal Year-to-Date Average Yields calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. (3)Investment Income includes coupon interest,accrued interest,and discount and premium amortization. 1 City of Round Rock Valley View Consulting, L.L.C. Economic Overview 6/30/2022 The Federal Open Market Committee(FOMC)raised the Fed funds target range 0.75%to 1.50%-1..75%June 15th(Effective.Fed Funds are trading+/-1.60%). The FOMC began actively reducing theirbalancestieet June 1. An additional 0.75%increase is anticipated July 27. First Quarter GDP(final)was-1.6%.. June Non-Farm Payroll added 372k net new jobs while the Three Month'Average NFP'declined to 375k. Crude.oil settled in at+/-$105 per barrel. The Stock Markets continued sliding lower,,but may be stabilizing. More domestic and international economic. indicators softened, including housing data. A recession in the next 12 to 18 months is being openly discussed. Inflation remained well over the FOMC 2%target(Core PCE;+/4.7%.and CPI exceeding 8%). 3.50' Treasury Yield Curves 5,250. S&P 500 5,000 3.00 4,750 4,500 4,250 2.504,000 ® '3,750 3,500 2.00 3,250 3,000 2,750 of 1.50 . 2,500 . 2,000 1.001,750 MOP�' 500 1,250 0.50 dop 1,000 -.� 500 0.00750 z5o o� Q o R h �o �a� �e� le:11 -June 30,2021. March 31,2022 -June 30,2022 US Treasury Historical Yields-'Since 2006 US:Treasury Historical Yields-Since Nov 2015 6.00 4.00 5.50 AL 5.00 3.50' 4.50 3.00 N 4.00 2.50 3.50 3.00 2.00 ' Y 2.50 2.00 / 1.50 ♦ w , • 1.50 - 74, 1.00 + 1.00 wI 0.50,, r 0.50 0.00 +�Iww w 0.00:. ' �\ A��0.'aA�ja P Nq js)��ja���ja)o�ja J�V�a�)ja)��ja)��J°��a)���a � �o���pQ�16reQN6Feo11 J��^1paU11�a1�mO�\b ��19PJX19,a��O,J�ryOyoor�'.SOe'e"o� ,J2L Six Month T-Bill T T-Note' --Six Month T-Bill Two Year T-Note e-m- Ten Year T-Note 2 Valley View Consulting,L.L.C. Holdings by Investment Category June 30, 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 $ 26,707,618 5% $ 2,249 _ 0% $ — 0% $ — 0% $.26,709,867 '5% Certificates of Deposit 135,765,344 24% 17,831,778 3% — 0% 22,653,312 4% 176,250,434 31% Investment Pools 39,314,432 7% 6,463,936 1%. 1,898,083 0% 16,925,500 3% 64,601,951 11% Money Market Accounts 45,527,920 8% 695,078 0% 860,996 0% 1,831,869 0% 48,915,862 9% Municipal 18,044,191 3% — 0%. — 0% — 0% 18,044,191 3%, US Agency115,925,690 21% — 0% — 0% — 0% 115,925,690 21% US Treasury, 82,701,671 15% — 0% — 0% 30,644,917, 5% 113,346,588 20% Total/Average $463,986,866 82% $ 24,993,041 4% $ 2,759,078 1 0% 1 $ 72,055,598 1 13% $563,794,584 100% Portfolio Balances (Millions) Order of Liquidity $600 ®Cash $500 o Local Government Investment Pool $400 ■Money Market Account $300 ■US Treasury $200 o US Agency ❑Municipal $100 v Certificates of Deposit $0 Pooled Funds DS Funds DSR Funds CP&SP Funds Total Portfolio 6/30/2022 6/30/2022 6/30/2022 6/30/2022 6/30/2022 3 City of Round Rock Valley View Consulting, L.L.C.. Investment Holdings by Investment Category Quarterly Transactions By Investment Category June 30,2022 June 30,2022 %of Portfolio Net Cash Equivalent Description Book Value Portfolio Limitation. Description Buys Sells Maturities Calls Interest Deposit/(Withdrawal) Cash $ 26,709,867 4.71/. 100% Cash $ – $ – $ – $ – $ – $ 6,488,518 Investment Pools 64,601,951 11.4% 100% Investment Pools – – – – 108,523 39,210,821 Voney Market Accounts 48,915,862 8.7% 75% Money Markets Accounts – – – – 95,071 1,419,020 Certificates of Deposit. 176,250,434 31.3% 85% Certificates of Deposit 127,368 – 59,216,955 – 168,886 – Commercial Paper – 0.0% 10%/50o Commercial Paper – – – – –Municipal 18,044,191 3.2% 35%'/5% Municipal 500,000 – – – 89,103 – US Agency 115,925,690 20.6% Combined US Agency 40,932,915 – – 108,653 – USTreasury 113,346,588 .20.1% 75% US Treasury 42,478,502 – – – 328,125 – Total/Average $ 563,794,584 100% PASSED Totals $ 84,038,784 -$ –1 $ 59,216,955 $ – $ 898,360 S. 44,280,318 Portfolio Balances (Millions) Portfolio Composition Order of Liquidity Money Market Accounts June 30,2022/o Certificates $600 8.7 31.3% IdCash Investment Pools $500 — 11.4% ElLocal Government $400 Investment Pool 9FiY 3 r - oMoney Market Account Cash $300 4.7% — — ■US Treasury Municipal $200 3 2% ER US Agency $100 ❑Municipal 'US Treasury 20.1% US Agency $0 ■Certificates of Deposit 20.6% NO, O�ryry 43 ^,0 14b 4 City of Round Rock Valley View Consulting,L.L.C. Portfolio Balances By Fund (Millions) $600 $500 _ ■Capital Project& Special Purpose Funds $400 ©Debt Service Reserve Funds $300 m Debt Service Funds $200 - $100 ■Pooled Funds $0 �h ^h ^b ^ra �6 ^6 ,�A ,�A ,�A ,�A ,�� ,�� ,�Cb ,�� ^� ,�A ,�� ,�°' ,yo ,yo ,yo ,tio ,tip. ,��. \ryo O O \ry0 \ry0 \T \tio \,10 \ry0 O O \ry0 \eyo O \T \rto \ry0 \ry0 \TO \�O \TO \ry0 IV 1V \,yo \,yo 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 SID 1.90 1.80 1.70 1.60 VA As 1.50 1.40 1.30 IL 1.20 . 1.10 1.00 0.90 ` 0.80 0.70 0.60 0.50 % 0.40 0.30 0.20 0.10 . 0.00 0Nb 0 b 11b0 0 0 rb 0 0 0 0 0 0 0 0 0 0 0 0 0 oti oti o`L 6 Nati '• � o��' ^�`� Nati �.�`� oo � '. oo�`� 4t Nati o�`� o�`� ^�ti N\ o��' o��' ���' Nati o��' '�� 0ti,b lb\rb rot' ��b ^rb b\,b �\rb Cb\� ^tip b\- ,\� ,�� ^tip 3�� (b��, q�� �r `b�� Ib\b ,�� b bb r\b b\b 3\`b b\b 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) June 30, 2022 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 1.60% 11/29/2016 $ .41,848,912 .$ 41,848;912 100.00 $ 41,848,912 N/A 1 1.60% TexasDAILY 1.00% AAAm 6/1/2021 1,631,656 1,631,656 100.00 1,631,656 N/A 1 1.00% TexasDAILY Select 1.26% AAAm 12/3/2021 5,005,327 5,005,327 100.00 5,005,327 N/A 1 1.26% Veritex Community Bank 1.21% 9/1/2020 3,679,008 3,679,008 100.00 3,679,008 N/A 1 1.21% JPMor an.Chase 0.28% 9/30/2015 26,707,618 26,707,618 100.00 26,707,618 N/A 1 0.28% TexSTAR 0.99% AAAm 9/30/2015 200,880 200,880 100.00 200,880 N/A 1 0.99% TexPool 1.00% AAAm 9/30/2015 9,838,079 9,838,079 100.00 9,838,079 N/A 1 1:00% TexasDAILY 1.00% AAArn 9/30/2015 22,638,490 22,638,490 100.00 22,638,490 N/A 1 1.00% Bank OZK 0.50% 7/9/2020 10;096,331 10,096,331 100.00 10,096,331 7/11/2022 11 0.50% Veritex Community Bank 0.24% 2/5/2021 3,008,966 3,008,966 100.00 3,008,966 8/5/2022 36 0.24% Prosperity Bank 0.20% 2/12/2021 3,007,983 3,007,983 100.00 .3,007,983 8/12/2022 43 0.20% Bexar Co Txb Ref 0.33% Al/AA/A- 9/23/2021 560,000 560,000 99.81 558,908 8/15/2022 46 0.33% Arlington TX HGR EDU 0.50% -/AAA/- 4/28/2021 500,000 500,000 99.71 498,555 8/15/2022 46 0.50% Denton ISD 0.00% 4AAA/AAA 12/17/2020 500,000 499,710 99.79 498,925 8/15/2022 46 0.46% City of Bryan TX 0.45% -/AA/- 11/19/2020 500,000 500,000 99.86 499,285 8/15/2022 46 0.45% City of Austin GO 0.27% Aal/AAA/AA+ 10/6/2020 700,000 700,000 99.78 698,453 9/1/2022 63 0.27% Prosperity Bank 0.20% 6/1/2021 3,006,005 3,006,005 100.00 3,006,005 9/1/2022 63 0.20% Veritex Community Bank 0.18% 3/5/2021 8,018,046 8,018,046 100.00 8,018,046 9/5/2022 67 0.18% State of Texas 1.61% Aaa/AAA/- 3/19/2021 3,250,000 3,262,074 99.97 3,248,895 10/1/2022 93 0.15% State of Texas 2.52% Aaa/AAA/- 10/14/2021 5,000,000 5,030,080 100.18 5,008,950 10/1/2022 93 0.15% Prosperity Bank 0.40% 10/15/2020 6,040,091 6,040,091 100.00 6,040,091 10/17/2022 109 0.40% Veritex Community Bank 0.26% 2/5/2021 3,009,714 3,009,714 100.00 3,009,714 11/4/2022 127 0.26% Prosperity Bank 0.20% 2/12/2021 3,007,983 3,007,983 1.00.00 31007,983 11/14/2022 137 0.20% R Bank 0.48% 11/24/2021 4,009,480 4,009,480 100.00 4,009,480 11/23/2022 146 0.48% Bank OZK 0.28% 12/7/2020 5,021,098 5,021,098 100.00 5,021,098 12/7/2022 160 0.28% Prosperity Bank 0.20% 6/9/2021 10,020,018 10,020,018 100.00 10,020,018 12/9/2022 162 0.20% Veritex Community Bank 0.28% 1/6/2021 4,013,981 4,013,981 100.00 4,013,981 1/6/2023 190 0.28% R Bank 0157% 7/6/2021 1,004,303 1,004,303 100.00 1,004,303 1/6/2023 190 0.57% Treasury 0.13% Aaa/AA+/AAA 1/5/2022 5,000,000 4,991,086, 98.59 4,929,464 1/31/2023 215 0.43% San Antonio TX Elec. 2.41% Aa2/AA-/AA- 4/13/2022 500,000 500,000 99.68 498,375 2/1/2023 216 2.41% Veritex Community Bank 0.30% 2/5/2021 4,416,443 4,416,443 100.00 '4,416,443 2/6/2023 221 0.30% FFCB 0.16% Aaa/AA+/AAA 11/22/2021 5,000,000 4,996,966 98.39 4,919,492 2/10/2023 225 0.26% Eagle Pass Texas 4.00% -/AA-/- 6/7/2021 645,000 661,363 101.57 655,101 3/1/2023 244 0.20% Prosperity Bank 0.25% 3/5/2021 10,031,347 10,031,347 100.00 10,031,347 3/6/2023 249 0:25% Bank OZK 0.26% 3/8/2021 2,537,364 2,537,364 100.00 2,537,364 3/8/2023 251 0.26% FFCB 0.13% Aaa/AA+/AAA 3/26/2021 9,000,000 8,998,354 98.05 8,824,560 3/23/2023 266 0.15% Prosperity Bank 0.20% 4/12/2021 5,011,684 5,011,684 100.00 5,011,684 4/12/2023 286 0.20% FFCB 0.13% Aaa/AA+/AAA 4/13/2021 5,000,000 4,997,405 97.90 4,894,911 4/13/2023 287 0.19% FFCB 0.38% Aaa/AA+/AAA 1/28/2022 4,000,000 3,982,828 97.93 3,917,041 4/27/2023 301 0.90% Prosperity Bank 0.20% 5/19/2021 1.0,021,720 10,021,720 1.00.00 10,021,720 5/19/2023 323 0.20% FNMA 0.25% Aaa/AA+/AAA 6/23/2022 5,000,000 4,883,936 97.67 4,883,371 5/22/2023 326 2.90% Veritex CommunityBank 0.20% 6/1/2021 20,040,030 20,040,030 100.00 20,040,030 6/1/2023 336 0.20% Bank OZK 0.20% 6/9/2021 8,016,095 8,016,095 100.00 8,016,095 6/9/2023 344 0.20% R Bank 0.70% 7/6/2021 1,005,284 1,005,284 100.00 1,005,284 7/6/2023 371 0.70% Treasury 1.25% Aaa/AA+/AAA 7/7/2021 8,000,000 8,088,956 98.23 7,858,743 7/31/2023 396 0.22% Veritex Community Bank 0.25% 7/30/2021 7,013,145 7,013,145 100.00 7,013,145 7/31/2023 396 0.25% Dallas ISD - 1 4.00% Aaa/AAA/AAA 4/22/2021 4,195,000 4,370,965 101.06 4,239,635 8/15/2023 411 0.26% Arlington TX HGR EDU 0.63% -/AAA/- 1 4/28/2021 1,460,000 1 1,460,000 97.09 1 1,417,558 1 8/15/2023 411 0.63% 7 City of Round Rock Valley View Consulting;L.L.C. Holdings by Allocation and Portfolio (Fund) June 30, 2022 Coupon Settlement Face Amount/ Market Days to YTM @ Issuer Rate Credit Rating Date Shares Book Value Price Market Value Maturity Date Maturity Book Veritex Community Bank 0.25% 8/23/2021 4,408,233 4,408,233 100.00 4,408,233 8/23/2023 419 0.25% FHLMC 0.25% Aaa/AA+/AAA 1/28/2022 5,000,000 4,954,569 97.01 4,850,686 8/24/2023 420 1.05% FNMA 2.88% Aaa/AA+/AAA 3/30/2022 4,000,000 4,031,577 99.97 3,998,864 9/12/2023 439 2.20% Treasury 0.25% Aaa/AA+/AAA 9/30/2021 10,000,000 9,994,253 96.75 9,675,159 9/30/2023 457 0.30% FHLMC 2.00% Aaa/AA+/AAA 2/28/2022 5,000,000 5,029,048 98.79 4,939,565 10/17/2023 474 1.55% Treasury 2.88% Aaa/AA+/AAA 11/22/2021 10,000,000 10,319,055 99.90 9,990,234 10/31/2023 488 0.47% FHLB 0.50% Aaa/AA+/-- 11/12/2021 5,000,000 4,998,428 96.74 4,836,804 11/9/2023 497 0.52% Treasury 0.50% Aaa/AA+/AAA 6/23/2022 5,000,000 4,825,984 96.65 4,832,339 11/30/2023 518 3.03% Treasury 2.88% Aaa/AA+/AAA 11/10/2021 5,000,000 5,171,722 99.93 4,996,623 11/30/2023 518 0.44% FHLB 0.50% Aaa/AA+/-- 12/7/2021 8,000,000 7,980,642 96.66 7,733,141 12/8/2023 526 0.67% FHLB 0.63% Aaa/AA+/-- 1/5/2022 5,000,000 4,989,293 96.68 4,834,094 12/22/2023 540 0.77% FFCB 0.90% Aaa/AA+/AAA 1/28/2022 5,000,000 4,977,865 96.90 4,844,765 1/18/2024 567 1.19% Treasury 2.25% Aaa/AA+/AAA 1/5/2022 8,000,000 8,186,524 98.93 7,914,778 1/31/2024 580 0.77% Treasu 2.38% Aaa/AA+/AAA 2/14/2022 14,000,000 14,177,923 99.11 13,874,923 2/29/2024 609 1.60% FHLB 1.88% Aaa/AA+/-- 2/28/2022 15,000,000 15,065,387 98.23 14,734,104 3/8/2024 617 1.61% FAMC 2.58% 4/18/2022 10,000,000 10,000,000 99.28 9,927,763 4/18/2024 658 2.58% Treasury 2.25% Aaa/AA+/AAA 3/30/2022 10,000,000 9,966,676 98.77 9,876,563 4/30/2024 670 2.44% FAMC 2.65% 5/9/2022 3,000,000 2,995,920 99.35 2,980,515 5/2/2024 672 2.73% FFCB 2.63% Aaa/AA+/AAA 6/2/2022 3,051,000 3,048,524 99.29 3,029,475 5/3/2024 673 2.67% Treasury 2.50% Aaa/AA+/AAA 6/2/2022 7,000,000 6,979,491 99.18 6,942,478 5/31/2024 701 2.66% FHLB 3.13% Aaa/AA+/- 6/23/2022 20,000,000 19,994,949 100.19 20,037,418 6/14/2024 715 3.14% Sub Total/Average 1.12% 463,176,314 463,986,866 1 99.36 460,215,823 297 0.98% Fund 170-Interest&Sinking GO Bonds TexasDAILY 1.00% AAAm 4/30/2016 191,403 191,403 100.00 191,403 N/A 1 1.00% NexBank 1.60% 2/27/2017 695,078 695,078 100.00 695,078 N/A 1 1.60% TexPool 1.00% AAAm 9/30/2015 2,842,069 2,842,069 100.00 2,842,069 N/A 1 1.00% East West Bank 0.27% 1/10/2022 8,010,185 8,010,185 100.00 8,010,185 7/11/2022 11 0.27% East West Bank 0.48% 2/1/2022 2,805,529 2,805,529 100.00 2,805,529 8/1/2022 32 0.48% East West Bank 0.73% 2/16/2022 5,013,518 5,013,518 100.00 5,013,518 8/10/2022 41 0.73% Sub Total/Average 1 0.58% 19,557,782 19,5579782 100.00 19,557,782 20 0.58% Fund 210-Interest&.Sinking Debt Service• JPMor an Chase 0.28% 9/30/2015 2,249 2,249 100.00 2,249 N/A 1 0.28% Sub Total/Average 0.28% 2,249 2,249 100.00 2,249 1 0.28% Fund 460-Bond Fund TexPool 1.00% AAAm 9/30/2015 3,755,876 3,755,876 100.00 3,7559876 N/A 1 1.00% Sub Total/Average 1.00% 39755,876 39755,876 100.00 3,755,876 1 1.00% Fund 462-2017 Bond Fund TexPool 1.00% AAAm 5/30/2017 2,002,361 290029361 100.00 2,0029361 N/A 1 1.00% NexBank 1.60% 3/30/2020 1,616,328 1,616,328 100.00 1,616,328 N/A 1 1.60% Treasury 2.38% Aaa/AA+/AAA 6/30/2022 6,000,000 5,994,009 99.87 5,992,031 1/31/2023 215 2.55% Sub Total/Average 1.96% 9,618,689 9,612,698 99.92 9,610,720 134 2.07% Fund 465-Road CO Bond Fund TexPool 1.00% AAAm 9/1/2020 10,946,847 10,946,847 100.00 10,946,847 N/A 1 1.00% Prosperity Bank 0.20% 7/6/2021 10,018,371 10,018,371 100.00 10,018,371 7/6/2022 6 0.20% Prosperity Bank 0.20% 6/1/2021 7,014,013 7,014,013 100.00 7,014,013 9/1/2022 63 0.20% Veritex Community Bank 0.30% 2/5/2021 5,620,928 5,620,928 100.00 5,620,928 2/6/2023 221 0.30% 8 City of Round Rock Valley View Consulting,L.L.C. Holdings by Allocation and Portfolio (Fund) June 30, 2022 Coupon Settlement Face Amount/ Market Days to YTM @ Issuer Rate Credit Rating Date Shares Book Value Price Market Value Maturity Date Maturity Book Treasury 0.13% Aaa/AA+/AAA 6/2/2022 25,000,000 24,650,908 98.06 24,514,813 3/31/2023 274 2.01% Sub Total/Average 0.33% 58,600,159 58,251,067 99.17 58,114,971 147 1.13% Fund 591-ReserJes'Fund 1 ° TexPool 1.00% AAAm 9/30/2015 8,739 8,739 100.00 8,739 N/A 1 1.00% NexBank 1.60% 4/29/2019 860,996 1 860,996 100.00 860,996 N/A 11 1.60% Sub Total/Average 1.59% 869,735 869,735 100.00 869,735 11 1.59% Fund 602-Interest&Sinking Revenue Bonds TexPool 1.00% AAAm 1 9/30/2015 3,430,463 3,430,463:1 100.00 1 3,430,463 1 N/A 1 11 1.00% East West Bank 0.27% 1 1/10/2022 2;002,546 1 2,002,546 1 100.00 1 2,002,546 1 7/11/2022 1 111 0.27% Sub Total/Average 0.73% 1 5,433,010 1 5,433,010 100.00 1 5,433,010 51 0.73% Fund 605-Kalahari Debt Service Reserve TexPool 1.00% AAAm 1 8/30/2019 1,889,344 1,889,344 100.00 1,889,344 N/A 11 1.00% Sub Total/Average 1.00% 1,889,344 1,889,344 100.00 1,889,344 11 1.00% Fund 863 Drainage Utility Revenue Bond- NexBank 1.60% 8/30/2020 215,542 215,542 100.00 215,542 N/A 1 1.60% TexPool 1.00% AAAm 10/31/2015 220,416 220,416 100.00 220,416 N/A 1 1.00% Sub Total/Average 1.30% 435,957 435,957 100.00 435,957 1 1.30% Total/Average 1.03% $ 563,339,115 $ 563,794,584 99.39 $ 559,885,468 262 9 City of Round Rock Valley View Consulting,L.L.C. Book Value Comparison June 30, 2022 Coupon Settlement Maturity Beginning Book Total Buys/ Total Sells/ Ending Book Change in Book Issuer Rate Date Date Value Increases Decreases Value Value Fund 000-Pooled investments " JPMor an Chase N/A 9/30/2015 N/A $ 20,216,825 $ 6,496,258 $ 5,465 $ 26,707,618 $ 6,490,794 TexPool N/A 9/30/2015 N/A 10,742,359 12,142,395 13,046,675 9,838,079 904,280 TexSTAR N/A 9/30/2015 N/A' 200,554 326 — 200,880 326 TexasDAILY N/A 9/30/2015 N/A 798,693 43,390,132 21,550,335 22,638,490 21,839,797 TexasDAILY N/A 6/1/2021 N/A 1,799,438 173,755 341,537 1,631,656 167,782 TexasDAILY Select N/A 12/3/2021 N/A 1,000,657 4,004 670 — 5,005,327 4,004 670 NexBank N/A 11/29/2016 N/A 1 30,075,167 11773,745 — 41,848,912. 11,773,745 R Bank N/A 11/29/2021 N/A 3,502,018 2,577 3,504,595 — 3,502,018 Veritex Community Bank N/A 9/1/2020 N/A 175,996 3,503,012 — 3,679,008 3,503,012 Prosperity Bank N/A 9/14/2021 N/A 4,506,860 556 4,507,416 — 4,506 860 Prosperity Bank N/A 9/14/2021 N/A 2,001,833 247 2,002,080 — 2,001,833 Independent Bank 0.40% 1/11/2021 4/11/2022 20,080,120 — 20,080,120 — 20,080,120 Veritex Community Bank 0.20% 2/5/2021 5/5/2022 3,006,005 — 3,006,005 — 3,006,005 Prosperity Bank 0.20% 2/12/2021 5/12/2022 4,008,622 681 4,009,303 — 4,008,622 Independent Bank 0.30%0 5/19/2021 5/19/2022 6,013,621 — 6,013,621 — (6,013,621) Allegiance Bank 0.45% 6/17/2020 6/17/2022 12,094,410 — 12,094,410 — 12,094,410 Bank OZK 0.50% 7/9/2020 7/11/2022 10,083,618 12,713 — 10,096,331. 12,713 Veritex Community Bank 0.24% 2/5/2021 8/5/2022 3,007,206 1,760 — 3,008,966 1,760 Prosperity Bank 0.20% 2/12/2021 8/12/2022 3,006,467 1,516 — 3,007,983 1,516 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 499,136 — — 499,710 574 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,004;491 1,515 — 3,006,005 1,515 Veritex Community Bank 0.18% 3/5/2021 9/5/2022 8,014,410 3,636 — 8,018,046 3,636 State of Texas 2.52% 10/14/2021 10/1/2022 5,059,513 — — 5,030,080 29,433 State of Texas 1.61% 3/19/2021 10/1/2022 3,273,888 — — 3,262,074 11,814 Prosperity Bank 0.40% 10/15/2020 10/17/2022 6,034,005 6,086 — 6,040 091 6,086 Veritex Community Bank 0.26% 2/5/2021 11/4/2022 3,007,808 1,907 — 3,009,714 1,907 Prosperity Bank 0.20% 2/12/2021 11/14/2022 3,006,467 1,516 — 3,007,983 1,516 R Bank 0.48% 11/24/2021 11/23/2022 4,004,842 4,637 — 4,009,480 4,637 Bank OZK 0.28% 12/7/2020 12/7/2022 5,017,543 3,555 — 5,021,098 3,555 Prosperity Bank 0.20% 6/9/2021 12/9/2022 10,014,969 5,049 — 10,020,018 5,049 Veritex Community Bank 0.28% 1/6/2021 1/6/2023 4,011,212 2,769 — 4,013,981 2,769 R Bank 0.57% 7/6/2021 1/6/2023 1,002,888 1,415 — 1,004,303 1,415 'Treasury 0.13% 1/5/2022 1/31/2023 4,987,313 — — 4,991,086 3,773 San Antonio TX Elec. 2.41% 4/13/2022 2/1/2023 — 500,000 — 500,000 500,000 Veritex Community Bank 0.30% 2/5/2021 2/6/2023 4,413,215 3,228 — 4,416,443 3,228 FFCB 0.16% 11/22/2021 2/10/2023 4,995,739 — — 4,996,966 1,227 Eagle Pass Texas 4.00% 6/7/2021 3/1/2023 667,466 — — 661,363 6,103 Prosperity Bank 0.25% 3/5/2021 3/6/2023 10,025,029 6,318 — 10,031,347 6,318 Bank OZK. 0.26% 3/8/2021 3/8/2023 2,535,695 1,669 — 2,537,364 1,669 FFCB 0.13% 3/26/2021 3/23/2023 8,997,790 — — 8,998,354 563 Prosperity Bank 0.20% 4/12/2021 4/12/2023 5,009,158 2,526 — 5,011 684 2,526 FFCB 0.13% 4/13/2021 4/13/2023 4,996,582 — — 4,997,405 823 FFCB 0.38% 1/28/2022 4/27/2023 3,977,636 — — 3,982,828 5,192 Prosperity Bank 0.20% 5/19/2021 5/19/2023 10,016,670 5,050 — 10,021,720 5,050 FNMA 0.25% 6/23/2022 5/22/2023 — 4,882,520 — 4,883,936 4,883,936 Veritex Community Bank 0.20% 6/1/2021 6/1/2023 20,029,933 10,097 — 20,040,030 10,097 Bank OZK 0.20% 6/9/2021 6/9/2023 8,012,035 4,060 — 8,016,095 4,060 R Bank 0.70% 7/6/2021 7/6/2023 1,003,545 1,739 — 1,005,284 1,739 10 City of Round Rock Valley View Consulting, L.L.C. Book Value Comparison June 30, 2022 Coupon Settlement Maturity Beginning Book Total Buys/ Total Sells/ Ending Book Change in Book Issuer Rate Date Date Value Increases Decreases Value Value Treasury 1.25% 7/7/2021 7/31/2023 8,109,397 — — 8,088,956 20,442 Veritex Community Bank 0.25% 7/30/2021 7/31/2023 7,008,825 4,321 — 7,013,145 4,321 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 1 4,409,925 — — 4,370,965 38,961 Veritex Community Bank 0.25% 8/23/2021 8/23/2023 4,405,547 2,686 — 4,408,233 2,686 FHLMC 0.25% 1/28/2022 8/24/2023 4,944,725 — — 4,954,569 9,843 FNMA 2.88% 3/30/2022 9/12/2023 4,038,122 — — 4,031,577 6,545 Treasury 0.25% 9/30/2021 9/30/2023 9,993,109 — — 9,994,253 1,144 FHLMC 2.00% 2/28/2022 10/17/2023 5,034,625 — — 5,029,048 5,577 Treasury 2.88% 11/22/2021 10/31/2023 10,378,550 — — 10,319,055 59,496 FHLB 0.50% 11/12/2021 11/9/2023 4,998,140 — — 4,998,428 288 Treasury 2.88% 11/10/2021 11/30/2023 5,201,890 — — 5,171,722 30,167 Treasury 0.50% 6/23/2022 11/30/2023 — 4,825 204 — 4,825,984 4,825,984 FHLB 0.50% 12/7/2021 12/8/2023 7,977,293 — — 7,980,642 3,349 FHLB 0.63% 1/5/2022 12/22/2023 4,987,489 — — 4,989,293 1,804 FFCB 0.90% 1/28/2022 1/18/2024 4,974,312 — — 4,977,865 3,553 Treasury 2.25% 1/5/2022 1/31/2024 8,215,790 — — 8,186,524 29,265 Treasury 2.38% 2/14/2022 2/29/2024 14,204,509 — — 14,177,923 26,586 FHLB 1.88% 2/28/2022 3/8/2024 15,075,031 — — 15,065,387 9,644 FAMC 2.58% 4/18/2022 4/18/2024 — 10,000,000 — 10,000,000 10,000,000 Treasury 2.25% 3/30/2022 4/30/2024 9,962,150 — — 9,966,676 4,526 FAMC 2.65% 5/9/2022 5/2/2024 — 2,997,150 — 2,995,920 2,995,920 FFCB 2.63% 6/2/2022 5/3/2024 — 3,054,872 — 3,048,524 3,048,524 Treasury 2.50% 6/2/2022 5/31/2024 — 6,979,628 — 6,979,491 6,979,491 FHLB 3.13% 6/23/2022 6/14/2024 — 19,998,372 — 19,994,949 19,994,949 Sub Total/Average Fund 000-Pooled Investments 1 419,578,876 134,815,868 90,161,561 463,986,866 44,407,991 Fund 170-Interest&Sinking GO Bonds TexPool N/A 9/30/2015 N/A 2,694,797 316,721 169,449 2,842,069 147,273 TexasDAILY N/A 4/30/2016 N/A 191,088 315 — 191,403 315 NexBank N/A 2/27/2017 N/A 693,628 1,450 — 695,078 1,450 East West Bank 0.27% 1/10/2022 7/11/2022 8,004,795 5,390 — 8,010,185 5,390 East West Bank 0.48% 2/1/2022 8/1/2022 2,802,173 3,355 — 2,805,529 3,355 East West Bank 0.73% 2/16/2022 8/10/2022 5,004,402 9,116 — 5,013,518 9,116 Sub Total/Average Fund 170-Interest&Sinking GO Bonds 1 19,390,883 1 336,348 1 169,449 1 19,557,782 166,899 Fund 210-Interest&Sinking Debt Service JPMor an Chase N/A 9/30/2015 N/A 4,525 — 2,276 1 2,249 2,276 Sub Total/Average Fund 210-Interest&Sinking Debt Service 4,525 — 2,276 1 2,249 (2,276) Fund 460-Bond Fund TexPool N/A 9/30/2015 N/A — 6,242,653 1 2,486,776 3,755,876 3,755,876 Sub Total/Average Fund 460-Bond Fund — 6,242,653 2,486,776 3,755,876 3,755,876 Fund 462-2017:Bond Fund: . TexPool N/A 5/30/2017 N/A 3,331,941 4,814 1,334,394 2,002,361 1,329,580 NexBank N/A 3/30/2020 N/A 1,612,956 3,371 — 1,616,328 3,371 East West Bank 0.26% 12/28/2021 6/28/2022 6,004,019 2,609 6,006,628 — 6,004,019 Treasury 2.38% 6/30/2022 1/31/2023 — 6,053,056 — 5,994,009 5,994,009 Sub Total/Average Fund 462-2017 Bond Fund 10,948,916 6,063,851 7,341,023 9,612,698 (1,336,218 Fund 465-Road CO Bond Fund TexPool N/A 9/1/2020 N/A 32,088 1 27,528,189 16,613,430 10,946,847 10,914,759 NexBank N/A 3/30/2022 N/A 6,691,345 — 6,691,345 — 6,691,345 11 City of Round Rock Valley View Consulting,L.L.C. Book:Value Comparison June 30, 2022 Issuer Coupon Settlement Maturity Beginning Book Total Buys/ Total Sells/ Ending Book Change in Book Rate Date Date Value Increases Decreases Value Value East West Bank 0.18% 12/9/2021 6/9/2022 8004,459 2,408 8,006,868 — 8,004,459 Prosperity Bank 0.20% 7/6/2021 7/6/2022 10,013,323 5;049 — 10,018,37.1 5,049 Prosperity Bank 0.20% 6/1/2021 9/1/2022 7,010,478 3,535 — 7,014,013 3,535 Veritex Community Bank 0.30% 1 2/5/2021 2/6/202351616,819 4,109 — 5,620,928 4,109 Treasuryi 24,620,613 1 — 24,650,908 24,650,908 Sub Total/Average Fund 465-Road CO Bond Fund 37,368,513 52,163,902 31,311,64358,251,067 20,882,554 Fund 591:-Reserves:Fund TexPool N/A 9/30/2015 N/A 8,7251 14 — 8,739 14 NexBank N/A 4/29/2019 N/A 859,200 1 1,796 1 860,996 1 1,796 Sub Total/Average Fund 591 -Reserves Fund: 867,925 1,810 — 869,735 1,810 .. .. .. Fund 602-Interest&Sinking.Revenue Bonds. TexPool N/A 9/30/2015 N/A 3,574,046 5,590 149,1731 3,430,463 143,582 East West Bank 0.27% 1 1/10/2022 7/11/2022 2,001,199 1,348 1 — 2,002,546 1,348 Sub Total/Average Fund 602-Interest&Sinkin 'Revenue Bonds 5,575,244 6,938 149;173 5,433,010 142,235) Fund 605.'Kalahari Debt'Service Reserve TexPool N/A 8/30/2019 N/A 795,644TI 1,093,700 1 1,889,344 1,093,700 Sub Total/Average Fund 605-Kalahari Debt Service Reserve 795,644 1,093,700 — 1,889,3441 1,093,700 Fund 863-Drainage Utility Revenue Bond TexPool N/A 10/31/2015 N/A 221,101 438 1,123 220,416 685 NexBank N/A 8/30/2020 N/A 215,879: 450 787 215;542 337 Sub Total/Average Fund 863-Drainage Utility Revenue Bond 43.6,980 887 1,910 435,957 (1,023) Total/Average $ 494,967,505 $ 200,725,958 $ 131,623,811 $ 563,794,584 $ 68,827,079 12 City of Round Rock Valley View Consulting, L.L.C. Market Value Comparison June 30, 2022 Coupon Settlement Maturity Beginning Total Buys/ Total Sells/ Ending Market Change in Issuer Rate Date Date Market Value Increases Decreases Value Market Value Fund 000-Pooled Investments JPMor an Chase N/A 9/30/2015 'N/A $ 20,216,825 $ 6,496,258 $ 5,465 $ 26 707,618 $ — TexPool N/A 9/30/2015 N/A 10,742,359 12,142,395 13,046,675 9,838,079 — TexSTAR N/A— 9/30/2015 _ N/A 200,554 326 — 200,880 — TexasDAILY N/A 9/30/2015 N/A 798,693 43,390,132 21,550,335 22,638,490 — TexasDAILY N/A 6/1/2021 N/A 1,799,438 173,755 341,537 1,631 656 — TexasDAILY Select N/A 12/3/2021 N/A 1,000,657 4,004,670 — 5,005,327 — NexBank N/A 11/29/2016 N/A 1 30,075,167 11,773 745 — 41,848,912 — R Bank N/A 11/29/2021 N/A 3,502,018 2,577 3,504,595 — — Veritex Community Bank N/A 9/1/2020 N/A 175,996 3,503,012 — 3,679,008 Prosperity Bank N/A 9/14/2021 N/A 4,506,860 556 4,507,416 — Prosperity Bank N/A 9/14/2021 N/A 2,001,833 247 2,002,080 —Independent Bank 0.40% 1/11/2021 4/11/2022 20,080,120 — 20,080 120 — — Veritex Community Bank 0.20% 2/5/2021 5/5/2022 3,006,005 — 3,006 005 —Prosperity Bank 0.20% 2/12/2021 5/12/2022 4,008,622 681 4,009,303 —Independent Bank 0.30% 5/19/2021 5/19/2022 6,013,621 — 6,013,621 —Allegiance Bank 0.45% 6/17/2020 6/17/2022 12;094,410 — 12,094,410 — — Bank OZK 0.50% 7/9/2020 7/11/2022 10,083,618. 12,713 — 10,096,331 — Veritex Community Bank 0.24% 2/5/2021 8/5/2022 3,007,206 1,760 — 3,008,966 Prosperity Bank 0.20% 2/12/2021 8/12/2022 3,006,467 1,516 — 3,007,983 Arlington TX HGR EDU 0.50% 4/28/2021 8/15/2022 497,280 — — 498,555 1,275 Bexar Co Txb Ref 0.33% 9/23/2021 8/15/2022 558,678 — — 558,908 230 City of Bryan TX 0.45% 11/19/2020 8/15/2022 498,980 — — 499,285 305 Denton ISD 0.00% 12/17/2020 8/15/2022 498,110 — — 498,925 815 City of Austin GO 0.27% 10/6/2020 9/1/2022 698,138 — — 698,453 315 Prosperity Bank 0.20% 6/1/2021 9/1/2022 3,004,491 1,515 — 3,006,005 — Veritex Community Bank 0.18% 3/5/2021 9/5/2022 8,014,410 3,636 — 8,018,046 — State of Texas 2.52% 10/14/2021 10/1/2022 5,035,450 — — 5,008,950 26,500 State of Texas 1.61% 3/19/2021 10/1/2022 3,258,710 — — 3,248,895 9,815 Prosperity Bank 0.40% 10/15/2020 10/17/2022 6,034,005 6,086 — 6,040,091. — Veritex Community Bank 0.26% 2/5/2021 11/4/2022 3,007,808. 1,907 — 3,009,714 — Prosperity Bank 0.20% 2/12/2021 11/14/2022 3,006,467 1,516 — 3,007,983 — R Bank 0.48% 11/24/2021 11/23/2022 4,004 842 4,637 — 4,009,480 — Bank OZK 0.28% 12/7/2020 12/7/2022 5,017,543 3,555 — 5,021,098 Prosperity Bank 0.20% 6/9/2021 12/9/2022 10,014,969 5,049 — 10 020,018 — Veritex Community Bank 0.28% 1/6/2021 1/6/2023 4,011,212 2,769 — 4,013,981 — R Bank 0.57% 7/6/2021 1/6/2023 1,002,888 1,415 — 1,004,303 — 'Treasury 0.13% 1/5/2022 1/31/2023 4,940,820 — — 4,929,464 11,356 San Antonio TX Elec. 2.41% 4/13/2022 2/1/2023 — 500,000 — 498,375 1,625 Veritex Community Bank 0.30% 2/5/2021 2/6/2023 4,413,215 3,228 — 4,416,443 — FFCB 0.16% 11/22/2021 2/10/2023 4,948,121 — — 4,919,492 28,630 Eagle Pass Texas 4.00% 6/7/2021 3/1/2023 659,009 — — 655,101 3,909 Prosperity Bank 0.25% 3/5/2021 3/6/2023 10,025,029 6,318 — 10,031,347 — Bank OZK 0.26% 3/8/2021 3/8/2023 2,535,695 1,669 — 2,537,364 — FFCB 0.13% 3/26/2021 3/23/2023 8,859 337 — — 8,824,560 (34,777) Prosperity Bank 0.20% 4/12/2021 4/12/2023 5,009;158 2,526 — 5,011,684 — FFCB 0.13% 4/13/2021 4/13/2023 4,917,493 — — 4,894,911 22,582 FFCB 0.38% 1/28/2022 4/27/2023 3,938,164 — — 3,917,041 21,123 Prosperity Bank 0.20% 5/19/2021 5/19/2023 10,016,670 5,050 — 10,021,720 — FNMA 0.25% 6/23/2022 5/22/2023 — 4,882,520 — 4,883 371 1,927 Veritex Community Bank 0.20% 6/1/2021 6/1/2023 20,029,933 10,097 — 20040'030 — Bank OZK 0.20% 6/9/2021 6/9/2023 8,012,035 4,060 — 8,016,095 — R Bank 0.70% 7/6/2021 7/6/2023 1,003,545 1,739 1 — 1,005,284 — 13 City of Round Rock Valley View Consulting,L.L.C. Market Value Comparison June 30, 2022 Coupon Settlement Maturity Beginning Total Buys/ Total Sells/ Ending Market Change in Issuer Rate Date Date Market Value Increases Decreases Value Market Value Treasury 1.25% 7/7/2021 7/31/2023 7,917,187 — — 7,858,743 58,444 Veritex Community Bank 0.25% 7/30/2021 7/31/2023 7,008,825 4,321 — 7,013,145 — Arlin ton TX HGR EDU 0.63% 4/28/2021 8/15/2023 1,426,376 — — 1,417,558 8,818 Dallas ISD 4.00% 4/22/2021 8/15/2023 1 4,306,923 — — 4,239,635 67,288 Veritex Community Bank 0.25% 8/23/2021 8/23/2023 4,405,547 2,686 — 4,408,233 — FHLMC 0.25% 1/28/2022 8/24/2023 4,872,594 — — 4,850,686 21,909 FNMA 2.88% 3/30/2022 9/12/2023 4,040,575 — — 3,998,864 41,711 Treasury 0.25% 9/30/2021 9/30/2023 9,722,265 — — 9,675,159 47,106 FHLMC 2.00% 2/28/2022 10/17/2023 5,002,900 — — 4,939,565 63,336 Treasury 2.88% 11/22/2021 10/31/2023 10,106,640 — — 9,990,234 116,406 FHLB 0.50% 11/12/2021 11/9/2023 4,866,498 — — 4,836,804 29,694 Treasury 2.88% 11/10/2021 11/30/2023 5,052,344 — — 4,996,623 55,721 Treasury 0.50% 6/23/2022 11/30/2023 — 4,825,204 — 4,832,339 8,706 FHLB 0.50% 12/7/2021 12/8/2023 7,779,518 — — 7,733,141 46,377 FHLB 0.63% 1/5/2022 12/22/2023 4,860,091 — — 4,834,094 25,997 FFCB 0.90% 1/28/2022 1/18/2024 4,892,219 — — 4,844,765M((41 Treasury2.25% 1/5/2022 1/31/2024 7,991,562 — — 7,914,778 Treasury2.38% 2/14/2022 2/29/2024 14,015,312 — — 13,874,923 FHLB 1.88% 2/28/2022 3/8/2024 14,872,251 — — 14,734,104 FAMC 2.58% 4/18/2022 4/18/2024 — 10,000,000 — 9,927,763 Treasu 2.25% 3/30/2022 4/30/2024 9,973,437 — — 9,876,563 FAMC 2.65% 5/9/2022 5/2/2024 — 2,997,150 — 2,980,515 , FFCB 2.63% 6/2/2022 5/3/2024 — 3,054,872 — 3,029,475 18,946 Treasury 2.50% 6/2/2022 5/31/2024 — 6,979,628 — 6,942,478 36,194 FHLB 3.13% 6/23/2022 6/14/2024 — 19,998,372 — 20,037,418 42,518 Sub Total/Average Fund 000-Pooled Investments 416,905,735 134,815,868 90,161,561 460,215,823 (1,329,145) Fund 170-Interest&Sinking GO Bonds TexPool N/A 9/30/2015 N/A 2,694,797 316,721 169,449 2,842,069 — TexasDAILY N/A 4/30/2016 N/A 191,088 315 — 191,403 — NexBank N/A 2/27/2017 N/A 693,628 1,450 — 695,078 — East West Bank 0.27% 1/10/2022 7/11/2022 8,004,795 5,390 — 8,010,185 — East West Bank 0.48% 2/1/2022 8/1/2022 2,802,173 3,355 — 2,805,529 — East West Bank 0.73% 2/16/2022 8/10/2022 5,004,402 9,116 — 5,013,518 — Sub Total/Average Fund 170-Interest&Sinking GO Bonds 19,390,883 336,348 169,449 19,557,782 — Fund 210-:Interest&Sinking Debt Service JPMor an Chase N/A 9/30/2015 N/A 4,525 — 2,276 1 2,249 — Sub Total/Average Fund 210-Interest&Sinking Debt Service 4,525 — 2,276 2,249 — Fund 460-Bond Fund TexPool N/A 9/30/2015 N/A — 6,242,653 1 2,486,776 3,755,876 — Sub Total/Average Fund 460-Bond Fund — 6,242,653 1 2,486,776 3,755,876 — Fund 462-2017 Bond Fund TexPool N/A 5/30/2017 N/A 3,331,941 4,814 1,334,394 2,002,361 — NexBank N/A 3/30/2020 N/A 1,612,956 3,371 — 1,616,328 — East West Bank 0.26% 12/28/2021 6/28/2022 6,004,019 2,609 6,006,628 — — Treasury 2.38% 6/30/2022 1/31/2023 — 6,053,056 — 5,992,031 1978 Sub Total/Average Fund 462-2017 Bond Fund 10,948,916 6,063,851 7,341,023 9,610,720 1,978 Fund 465-Road CO Bond Fund TexPool N/A 9/1/2020 N/A 1 32,088 27,528,189 16,613,430 10,946,847 — NexBank N/A 3/30/2022 N/A 6,691,345 — 6;691,345 — — 14 City of Round Rock Valley View Consulting, L.L.C. Market Value Comparison June 30, 2022 Issuer Coupon Settlement Maturity Beginning Total Buys/ Total Sells/ Ending Market Change in Rate Date Date Market Value Increases Decreases Value Market Value East West Bank 0.18% 12/9/2021 6/9/2022 8,004,459 2,408 8,006,868 — Prosperity Bank 0.20% 7/6/2021 7/6/2022 10,013,323 5,049 — 10 018,371 Prosperity Bank 0.20% 6/1/2021 9/1/2022 7,010,478 3,535 — 7,014,013 — Veritex Community Bank 1 0.30% 1 2/5/2021 1 2/6/2023 1 5,616,819 4,109 — 5,620,928 — Treasury0.13% 6/2/2022 3/31/2023 — i 24,620,613 — 24,514,813 100,422 Sub Total/Average Fund 465-Road CO Bond Fund 37,368,513 52,163,902 31,311,643 58,114,971 (100,422) Fund 591:=Reserves;Fund TexPool N/A 9/30/2015 N/A 8,725 14 — 8,739 — NexBank N/A 4/29/2019 N/A 859,200 1,796 1 860,996 1 — Sub Total/Average Fund 591-Reserves Fund 867,925 1,'810 1 869,735 — Fund 602-Interest&Sinking.Revenue Bonds, TexPool N/A 1 9/30/2015 N/A 3,574,046 5,590 149,173 3,430,463 — East West Bank 1 0.27% 1 1/10/2022 7/11/2022 1 2,001,199 1,348 — 2,002,546 — Sub Total/Avera a Fund 602-Interest&Sinking Revenue Bonds 5,575,244 6,938 149,173 5,433,010 — Fund 605-Kalahari Debt Service Reserve TexPool N/A 8/30/2019 N/A 795,644 11093,700 — 1;889,344 — Sub Total/Average Fund 605-Kalahari Debt Service Reserve 795,644 1,093,700 — 1,889,344 — Fund 863-Drainage Utility Revenue Bond TexPool N/A 10/31/2015 N/A 221,101 438 1,123 220,416 — NexBank N/A 8/30/2020 N/A 215,879 450 787 215 542 — Sub Total/Avera a Fund 863-Draina a Utili Revenue Bond 436,980 887 1,910 435,957 — Total/Average $ 492;294,365 $ 200,725,958 $ 131,623,811 $ 559,885,468 $ 1,431,545) 15 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 to YTM @ Issuer Credit Rating Book Value Market Value Maturity Date 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% ProsperityProspeCity 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 CommunitV 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% Independent 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% ProsperitV 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 0.20% 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 0.43% 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 0.15% 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 414 0.20% Veritex Community Bank 0.20% 6/1/2021 20,029,933 20,029,933 100.00 20,029,933 6/1/2023 427 0.20% 16 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 to YTM @ Issuer Credit Rating Book Value Market Value Maturity Date Rate Date Shares Price Maturity Book Bank OZK 0.20% 6/9/2021 8,012,035 8,012,035 ' 1 bo.o0 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.88% 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 419,578,876 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 1 100.00 19,390,883 1 941 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 11 0.15% Sub Total/Average 0.15% 4,525 1 4,525 100.00 4,525 11 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/Avera2e 0.27% 1 1 1 37,368,513 1 37,368,513 1 100.00 37,368,513 1171 0.27% 17 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 to YTM @ Issuer Rate Credit Rating Date Shares Book Value price Market Value Maturity Date Maturity Book Fund 591 -Reserves Fund: TexPool 0.15% AAAm 9/30/20.15 8,725 8;725 100.00 8,725 N/A 1 0.15% NexBank. :.. 0.55% 4/29/20.19 859,200 :. 859;200 100.00 859,200. :. N/A :.. 1 ..0.55% Sub Total/Avera a 0.55% 867,925.1:. 8671925 1 100.00 ::.-867,92 5 : 0.55% Fund 6.02.=Interest`&Sinking Revenue Bonds` TexPool 0.15 AAAm 9/30/2015 3,574,046 3,574,046 100.00 3,574,046 o N/A 1 0.15% /o East West Bank. 0:27%. 1/10/2022 2;001,T99 2,001,199. ':, 100.00 2,001,199 7/11/2022 .1021 0.27%' Sub Total/Average 0.20%. 51575,244 5,575,244 ::. 100.00 1.... 5.575.2441 371 0.20% Fund 605-'Kalahari Debt Service Reserve " TexPool 0.15%- AAAm 8/30/2019 795,644 795,6441 100.00 1 795,644 1 N/A 1 0.15% Sub Total/Avera a",' .0.15% " . 795,644 795,644 .100.00 795,644 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/317201.5 221,101 1 221,101 1 100.00221,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 1 1 2821 0.49% 18 City of Round Rock Valley:View Consulting,L.L.C.