The URL can be used to link to this page

Contract - Finance - 12/31/2022 ROUND ROCK TEXAS FINANCE QUARTERLY INVESTMENT REPORT For the Quarter Ended December 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. 0-t) C'hn� Financial Officer Depu Chief Fvaqncial Off(er Controller easury Accountant 4��)dol-j 0 o-h Valley View Co sul ing, 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. j�- 2,025 n5�4 Summary Holdings by Investment Category (Security Sector) December 31,2022 YTM @ Description Cost Book Value Market Value Cash 0.00% $ 9,919,334 $ 9,919,334 Certificates of Deposit 0.24% 83,241,323 83,241,323 Local Government Investment Pool 4.23% 69,608,173 69,608,173 Money Market Accounts 4.38% 45,956,440 45,956,440 Municipal 0.49% 6,901,211 6,749,802 US Agency 2.75% 221,166,084 217,272,607 US Treasury 1.80% 127,647,639 124,974,025 Total/Average 2.41% $ 564,440,204 $ 557,721,705 September 30,2022 YTM @ Description Cost Book Value Market Value Cash 0.40% $ 10,495,420 $ 10,495,420 Certificates of Deposit 0.26% 114,322,455 114,322,455 Local Government Investment Pool 2.44% 62,788,519 62,788,519 Money Market Accounts 3.05% 25,630,256 25,630,256 Municipal 0.30% 15,197,223 14,997,653 US Agency 2.38% 184,064,262 180,192,004 US Treasury 1.69% 122,917,363 119,875,000 Total/Average 1.71% $ 535,415,498 $ 528,301,307 Average Yield Current Fiscal Year- Quarter(1) to-Date(2) Total Portfolio 2.41% 2.41% TexPool Yield 3.98% 3.98% Rolling Three Mo.Treas.Yield 4.19% 4.19% Rolling Six Mo.Treas.Yield 3.90% 3.90% Rolling 1 Yr.Treas.Yield 2.81% 2.81% Rolling 2 Yr.Treas.Yield 1.63% 1.63% Investment Income(3) Interest Income(Approximate) $ 2,713,298 $ 2,713,298 WAM at 12/31/2022 Policy WAM Max Total Portfolio 263 days 540 days Pooled Funds 303 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/2022 The Federal Open Market Committee(FOMC)raised the Fed Funds target range 0.50%to 4.25%-4.50%December 14th(Effective Fed Funds are trading+/-4.33%). A 0.25%increase is projected February 1st. Third Quarter GDP jumped to 3.2%in the final number. December Non-Farm Payroll added 223k new jobs with the Three Month Average declining to 247k. Crude oil continues moderating at+/-$75 per barrel. The Stock Markets drifted between+/-15%to+/-19%below the 2021 peak. The yield curve is fully negatively sloped(3 months to 10 years,with peak yield at 6 months)and continues to indicate lower future interest rates. Inflation remained well over the FOMC 2%target(Core PCE+/-5%and CPI+/-6%). International challenges add to economic uncertainty. 6.00 Treasury5,250 Yield Curves S&P 500 5,000 4,750 5.00 4,500 4,250 4,000 4.00 3,750 3,500 3,250 3,000 3.00 2,750 2,500 2,250 2.00 2,000 1,750 1,500 1.00 -- -- _ _. 1,250 1,000 50 0.00 250 011'��O �! 1v 1v Opp �b ,,o pct �� fit( �cj �0Q �cj �Q �cf 41 lied - December 31,2021 September 30,2022 -December 31,2022 6.00 US Treasury Historical Yields-Since 2006 5.50 US Treasury Historical Yields-Since Nov 2015 5.50 5.00 5.00 - 4.50 4.50 4.00 - 4.00 3.50 3.50 3.00 3.00 2.50 2.50 2.00lei 2.00 - - - - j - -- r 1.50 1.50 ' 1.001.00 0.50 -- f 0.50 �� -- 0.00 •-� 0.00 I NIq �oa� )J�ja �NaJ� 101.11y 00 N6�0' 11101 1 100 N, �9 �a��$10410 140 �0, 0-1 XV-4,��e�ry��ao�ry1�,atryry�o�ryry . T_ T_ ---Six T it 2 Valley View Consulting,L.L.C. Holdings by Investment Category December 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 $ 9,914,055 2% $ 5,280 0% $ - 0% $ - 0% $ 9,919,334 2% Certificates of Deposit 77,611,891 14% - 0% - 0% 5,629,432 1% 83,241,323 15% Investment Pools 46,364,468 8% 7,072,726 1% 1,920,933 0% 14,250,045 3% 69,608,173 12% Money Market Accounts 23,350,423 4% - 0% 875,014 0% 21,731,003 4% 45,956,440 1 8% Municipal 6,901,211 1% - 0% - 0% - 0% 6,901,211 1% US Agency 211,167,803 37% - 0% - 0% 9,998,280 2% 221,166,084 39% US Treasury 96,763,168 17% - 0% - 0% 30,884.471 5% 127,647.639 23% Total/Average $472,073,020 84% 1 $ 7,078,006 1 1% $ 2,795,948 0% $ 82,493,231 15'/0 $564,440,204 100% Portfolio Balances (Millions) Order of Liquidity $600 ■Cash $500 ■Local Government Investment Pool $400 -- -- - - - - - - - ■Money Market Account $300 - ■US Treasury $200 --- ------ - -- - ---- s US Agency ❑Municipal $100 ® ■Certificates of Deposit Pooled Funds DS Funds DSR Funds CP&SP Funds Total Portfolio 12/31/2022 12/3112022 12/31/2022 12/31/2022 12131/2022 City of Round Rock Valley View Consulting, L.L.C. 3 Investment Holdings by Investment Category Quarterly Transactions By Investment Category December 31, 2022 December 31,2022 %of Portfolio Net Cash Equivalent Description Book Value Portfolio Limitation Description Buys Sells Maturities Calls Interest Deposit/(Withdrawal) Cash $ 9,919,334 1.8% 100% Cash $ — $ — $ — $ — $ 28,637 $ 576,086 Investment Pools 69,608,173 12.3% 100% Investment Pools — — — — 502,772 6,819,654 Woney Market Accounts 45,956,440 8.1% 75% Money Markets Accounts — — — — 326,185 20,326,185 Certificates of Deposit 83,241,323 14.8% 85% Certificates of Deposit 56,501 — 31,137,633 — 68,731 — Commercial Paper 0.0% 10%/5% Commercial Paper —I —I —I —I —I — Municipal 6,901,211 1.2% 35%/5% Municipal — — 8,250,000 — 89,103 — US Agency 221,166,084 39.2% 85% US Agency 36,988,116 — — — 624,142 — US Treasury 127,647,639 22.6% 85% US Treasu 4,673,034 — — — 428,125 — Total/Average $ 564,440,204 100% PASSED Totals $ 41,717,651 S — $ 39,387,633 S — S 2,067 694 S 26,569,753 Portfolio Balances (Millions) Portfolio Composition Order of Liquidity Certificates of December 31,2022 $600 -- —- - -- Deposit Municipal Money Market Accounts 14.8% 1.2% ■Cash 8.1% $500 •Local Government Investment Pool Investment Pools $400 12.3% ■Money Market Account $300 ■US Treasury Cash 1.8% $200 - ■US Agency $100 - - OMunicipal US Agency 39.2% ■Certificates of Deposit US Treasury $0 22.6% zoj�\titi bio\titi 9�o\titi��\,y� 4 City of Round Rock Valley View Consulting,L.L.C. City of Round Rock Pooled Funds Performance 4.50 4.00 - - -- -- 3.50 - -- - -- 3.00 --- --- -- - m as � 2.50 - --- - - -- - - _ pL (D Lf I CL 2.00 - — - -- ♦ 1.50 - - --- - -- - -- - - - MA -- 1.00 - Ov 0.50 dw�- 0.00 ND N6 No Nb No NA Nk N\ N\ �g ^Ob N(b NOO ^o, �o No N°' §p �o �O ,tio ti� �� tip ti^ ti� ti� "p, �ti 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0 I 4 Nati 4 4 4 4 6 6 4 4 4 6 4 4 4 6 '•\�' o��' '•��' •��' 'Ov 0�0 �ti� � o�� o �ti� ��o opo o �ti� � o�� opo �� o�� opo o�� ti� ��o opo o�� 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. 5 Portfolio Balances By Fund (Millions) 5600 5500 ■Capital Project& Special Purpose Funds $400 ❑Debt Service Reserve Funds $300 ❑Debt Service Funds $200 $100 0Pooled Funds $0 City of Round Rock Valley View Consulting, L.L.C. 6 Holdings by Allocation and Portfolio (Fund) December 31, 2022 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 4.40% 11/29/2016 $ 23,158,229 $ 23,158,229 100.00 $ 23.158,229 N/A 1 4.40% TexasDAILY 4.13% AAAm 6/1/2021 2,460 2,460 100.00 2,460 N/A 1 4.13% TexasDAILY Select 4.33% AAAm 12/3/2021 5,081,716 5,081,716 100.00 5,081,716 N/A 1 433% Veritex Community Bank 4.30% 9/1/2020 192,194 192,194 100.00 192,194 N/A 1 4.30% JPMor an Chase 0.00% 9/30/2015 9,914,055 9,914,055 100.00 9,914,055 N/A 1 000% TexSTAR 4.22% AAAm 9/30/2015 203,596 203,596 100.00 203,596 N/A 1 4.22% TexPool 4.22% AAAm 9/30/2015 38,778,376 38,778,376 100.00 38,778,376 N/A 1 4.22% TexasDAILY 4.13% AAAm 9/30/2015 2,298,320 2,298,320 100.00 2,298,320 N/A 1 4.13% Veritex Community Bank 0.28% 1/6/2021 4,019,618 4,019,618 100.00 4,019,618 1/6/2023 6 0.28% R Bank 0.57% 7/6/2021 1,007,187 1,007,187 100.00 1,007,187 1/6/2023 6 0.57% Treasury 0.13% Aaa/AA+/AAA 1/5/2022 5,000,000 4,998,715 99.69 4,984,461 1/31/2023 31 0.43% San Antonio TX Elec. 2.41% Aa2/AA-/AA- 4/13/2022 500,000 500,000 99.82 499,075 2/1/2023 32 2.41% Veritex Community Bank 0.30% 2/5/2021 4,423,125 4,421125 100.00 4,423.125 2/6/2023 37 0.30% FFCB 0.16% Aaa/AA+/AAA 11/22/2021 5,000,000 4,999,447 99.54 4,977,007 2/10/2023 41 0.26% Eagle Pass Texas 4.00% -/AA-/- 6/7/2021 645,000 649.024 100.12 645,787 3/1/2023 60 0.20% Prosperity Bank 0.25% 3/5/2021 10,043,927 10,043,927 100.00 10,043,927 3/6/2023 65 0.25% Bank OZK 0.26% 3/8/2021 2,540,686 2,540,686 100.00 2,540,686 3/8/2023 67 0.26% FFCB 0.13% Aaa/AA+/AAA 3/26/2021 9,000,000 8,999,492 99.04 8,914,039 3/23/2023 82 0.15% Prosperity Bank 0.20% 4/12/2021 5,016,711 5,016,711 100.00 5,016,711 4/12/2023 102 0.20% FFCB 0.13% Aaa/AA+/AAA 4/13/2021 5,000,000 4,999,069 98.77 4,938,286 4/13/2023 1031 0.19% FFCB 0.38% Aaa/AA+/AAA 1/28/2022 4,000,000 3,993,325 98.69 3,947,658 4/27/2023 117 0.90% Prosperity Bank 0.20% 5/19/2021 10,031,774 10,031,774 100.00 10,031,774 5/19/2023 139 0.20% FNMA 0.25% Aaa/AA+/AAA 6/23/2022 5,000,000 4,949,444 98.29 4,914,617 5/22/2023 142 2.90% Veritex Community Bank 0.20% 6/1/2021 20,060,130 20,060,130 100.00 20,060,130 6/1/2023 152 0.20% Bank OZK 0.20% 6/9/2021 8,024,176 8,024,176 100.00 8,024,176 6/9/2023 160 0.20% R Bank 0.70% 7/6/2021 1,008,828 1,008,828 100.00 1,008,828 7/6/2023 187 0.70% Treasury 1.25% Aaa/AA+/AAA 7/7/2021 8,000,000 8,047,623 98.04 7,843,393 7/31/2023 212 0.22% Veritex Community Bank 0.25% 7/30/2021 7,021,938 7,021,938 100.00 7,021,938 7/31/2023 212 0.25% Dallas ISD 4.00% Aaa/AAA/AAA 4/22/2021 4,195,000 4,292,187 99.71 4,182,667 8/15/2023 227 0.26% Arlington TX HGR EDU 0.63% -/AAA/- 4/28/2021 1,460,000 1,460,000 97.42 1,422,274 8/15/2023 227 0.63% Veritex Community Bank 0.25% 8/23/2021 4,413,790 4,413,790 100.00 4,413,790 8/23/2023 235 0.25% FHLMC 0.25% Aaa/AA+/AAA 1/28/2022 5,000,000 4,974,472 97.16 4,858,171 8/24/2023 236 1.05% FHLB 0.00% Aaa/AA+/-- 8/31/2022 5,000,000 4,887,667 96.90 4,844,950 8/28/2023 2401 3.51% FNMA 2.88% Aaa/AA+/AAA 3/30/2022 4,000,000 4,018,342 98.68 3,947,138 9/12/2023 2551 2.20% Treasury 0.25% Aaa/AA+/AAA 9/30/2021 10,000,000 9,996,567 96.74 9,674,345 9/30/2023 273 0.30% FHLMC 2.00% Aaa/AA+/AAA 2/28/2022 5,000,000 5,017,772 97.75 4,887,664 10/17/2023 290 1.55% Treasury 2.88% Aaa/AA+/AAA 11/22/2021 10,000,000 10,198,755 98.54 9,853,531 10/31/2023 304 0.47% FHLB 0.50% Aaa/AA+/-- 11/12/2021 5,000,000 4,999,010 96.37 4,818,280 11/9/2023 313 0.52% Treasury 0.50% Aaa/AA+/AAA 6/23/2022 5,000,000 4,887,797 96.22 4,810,890 11/30/2023 334 3.03% Treasury 2.88% Aaa/AA+/AAA 11/10/2021 5,000,000 5,110,724 98.37 4,918,493 11/30/2023 334 0.44% FHLB 0.50% Aaa/AA+/-- 12/7/2021 8,000,000 7,987,414 96.06 7,684,982 12/8/2023 342 0.67% FHLB 5.00% Aaa/AA+/-- 12/19/2022 10,000,000 10,000,000 100.01 10,000,666 12/19/2023 353 5.00% FHLB 0.63% Aaa/AA+/-- 1/5/2022 5,000,000 4,992,941 96.05 4,802,400 12/22/2023 356 0.77% FFCB 0.90% Aaa/AA+/AAA 1/28/2022 5,000,000 4,985,048 95.99 4,799,500 1/18/2024 383 1.19% Treasury 2.25% Aaa/AA+/AAA 1/5/2022 8,000,000 8,127,351 97.38 7,790,024 1/31/2024 396 0.77% Treasury 2.38% Aaa/AA+/AAA 2/14/2022 14,000,000 14,124,166 97.44 13,641,082 2/29/2024 425 1.60% FHLB 1.88% Aaa/AA+/-- 2/28/2022 15,000,000 15,045,887 96.60 14,490,726 3/8/2024 4331 1.61% FAMC 2.58% 4/18/2022 10,000,000 10,000,000 97.07 9,706,750 4/18/2024 1 4741 2.58% 7 City of Round Rock Valley View Consulting, L.L.C. Holdings by Allocation and Portfolio (Fund) December 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 Treasury 2.25% Aaa/AA+/AAA 3/30/2022 10.000,000 9,975,828 96.86 9.685,641 4/30/2024 486 2.44% FAMC 2.65% 5/9/2022 3,000,000 2,997,037 97.27 2,918,009 5/2/2024 488 2.73% FFCB 2.63% Aaa/AA+/AAA 6/2/2022 3,051,000 3,049,201 97.27 2,967,577 5/3/2024 489 2.67% Treasury 2.50% Aaa/AA+/AAA 6/2/2022 7,000,000 6,984,874 97.03 6,792,211 5/31/2024 5171 2.66% FHLB 3.13% Aaa/AA+/-- 6/23/2022 20,000,000 19,996,249 97.68 19,536,234 6/14/2024 5311 3.14% FFCB 3.15% Aaa/AA+/AAA 7/15/2022 10,000,000 10,003,443 97.73 9,772,670 7/15/2024 562 3.13% Treasury 1.75% Aaa/AA+/AAA 9/29/2022 10.000,000 9,633,905 95.69 9.568,545 7/31/2024 578 4.187/. FFCB 3.38% Aaa/AA+/AAA 8/31/2022 23,500,000 23,437,755 98.00 23,030,583 8/26/2024 604 3.54% FFCB 3.50% Aaa/AA+/AAA 9/16/2022 20,000,000 19,847,384 98.13 19,626,292 9/13/2024 622 3.97% FHLB 4.50% Aaa/AA+/-- 11/1/2022 3,000,000 2,992,013 100.17 3,005,112 10/3/2024 642 4.66% FHLB 4.50% Aaa/AA+/-- 11/1/2022 2,000,000 1,994,676 100.17 2,003,408 10/3/2024 642 466% Treasury 0.63% Aaa/AA+/AAA 12/13/2022 5,000,000 4,676,862 93.43 4,671,617 10/15/2024 654 4.43% FFCB 4.38% Aaa/AA+/AAA 10/17/2022 7,000,000 7,000,714 99.66 6.976,108 10/17/2024 656 4.37% FHLB 453% Aaa/AA+/-- 12/14/2022 15.000,000 15,000,000 99.95 14,992,443 11/18/2024 688 4.53% Sub Total/Average 2.19% 1 472,591,838 1 472,073,020 1 98.52 465,586,141 303 2.24% Fund 170-Interest&Sinking GO Bonds TexasDAILY 4.13% AAAm 4/30/2016 1 28,059 28,059 1 100.00 1 28,059 1 N/A 1 4.13% TexPool 4.22% AAAm 9/30/2015 2,962.201 2,962101 100.00 1 2,962,201 N/A 1 4.22% Sub Total/Average 4.22% 2,990,260 2,990,260 100.00 1 2,990,260 1 4.22% Fund 210-Interest&Sinking Debt Service JPMor an Chase 0.00% 9/30/2015 5,280 5,280 100.00 1 5.280 N/A 1 0.00% Sub Total/Average 0.00% 5,280 1 5,280 100.00 1 5,280 1 1 0.00% Fund 460-Bond Fund TexPool 4.22% AAAm 9/30/2015 353,707 353.707 100.00 1 353,707 1 N/A 1 422% Sub Total/Average 4.22% 353,707 353,707 100.00 1 353,707 1 1 4.22% Fund 462-2017 Bond Fund TexPool 4.22% AAAm 5/30/2017 2,006,782 2,006,782 100.00 2,006,782 N/A 1 4.22% NexBank 4.40% 3/30/2020 1,642,645 1,642,645 100.00 1,642,645 N/A 1 4.40% Treasury 2.38% Aaa/AA+/AAA 6/30/2022 6,000.000 5,999,136 99.87 5,992,123 1/31/2023 31 2.55% Sub Total/Average 3.10% 9,649,426 9,648,563 99.92 9,641,549 20 3.21% Fund 465-Road CO Bond Fund TexPool 4.22% AAAm 9/1/2020 8,993,179 8,993,179 100.00 8,993,179 N/A 1 4.22% Veritex Community Bank 0.30% 2/5/2021 5,629,432 5,629,432 100.00 5,629,432 2/6/2023 37 0.30% Treasury 0.13% Aaa/AA+/AAA 6/2/2022 25,000,000 24,885,335 98.99 24,747,670 3/31/2023 90 2.01% FHLB 3.63% Aaa/AA+/-- 9/9/2022 10,000,000 9,998,280 99.11 9,911,338 9/6/2023 249 3.65% Sub Total I Average 1.59% 49,622,611 49,506,226 99.31 49,281,619 100 2.55% Fund 591 -Reserves Fund TexPool 4.22% AAAm 9/30/2015 1 8,861 1 8,861 1 10x00 8,861 N/A 1 1 4.22% NexBank 4.40% 4/29/2019 875,014 875.014 1 100.00 875,014 N/A 1 4.40% Sub Total/Average 4.40% 883,876 883,876 100.00 883,876 11 4.40% Fund 602-Interest&Sinking Revenue Bonds TexPool 4.22% AAAm 9/30/2015 4,082.466 41082,466 100.00 4,082,466 N/A 1T 4.22% Sub Total/Average 4.22% 4,082,466 4,082,466 100.00 4,082,466 11 4.22% Fund 604-2022 SIB Loan 8 City of Round Rock Valley View Consulting, L.L.0 Holdings by Allocation and Portfolio (Fund) December 31, 2022 Coupon Settlement Face Amount/ Book Days to YTM @ Issuer Credit Rating Book Value Market Value Maturity Date Rate Date Shares Price Maturity Book TexPool 4.22% AAAm 9/29/2022 2,896,378 2,896,378 100.00 2,896,378 N/A 1 4.22% American Nat'l Bank&Trust 4.36% 11/21/2022 20,088,358 20,088,358 100.00 20,088,358 N/A 1 4 36% Sub Total/Average 4.34% 22,984,736 22,984,736 100.00 22,984,736 11 4.34% Fund 605-Kalahari Debt Service Reserve TexPool 4.22% AAAm 8/30/2019 1,912,072 1,912,072 100.00 1,912,072 N/A1 4.22% Sub Total/Average 4.22% 1,912,072 1,912,072 100.00 1,912,072 11 4.22% Total/Average 2.28% $ 565,076,271 $ 564,440,204 98.70 $ 557,721,705 2631 2.41% 9 City of Round Rock Valley View Consulting, L.L.C. Book Value Comparison December 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 $ 10,488,641 $ 4,245,073 $ 4,819,659 $ 9,914,055 $ 574,586 TexPool N/A 9/30/2015 N/A 14,249,176 34,003,001 9,473,801 38,778,376 24,529,200 TexSTAR N/A 9/30/2015 N/A 201,831 1,765 — 203,596 1,765 TexasDAILY N/A 9/30/2015 N/A 2,277,545 20,775 — 2,298,320 20,775 TexasDAILY N/A 6/1/2021 N/A 2,438 22 — 2,460, 22 TexasDAILY Select N/A 12/3/2021 N/A 5,033,332 48 384 — 5,081,716 48,384 NexBank N/A 11/29/2016 N/A 22,945,659 212,569 — 23,158,229 212,569 VeritexCommunit Bank N/A 9/1/2020 N/A 190,047 2,148 — 192,194 2,148 State of Texas 2.52% 10/14/2021 10/1/2022 5,000,323 — 5,000,000 — 5,000,323 State of Texas 1.61% 3/19/2021 10/1/2022 3,250,130 — 3,250,000 — 3,250,130 Prosperity Bank 0.40% 10/15/2020 10/17/2022 6,046,183 — 6,046,183 — 6,046,183 Veritex Community Bank 0.26% 2/5/2021 11/4/2022 3,011,687 — 3,011,687 — (3011,687 ProsperityTrosperity Bank 0.20% 2/12/2021 11/14/2022 3,009,499 495 3,009,994 — 3,009,499 R Bank 0.48% 11/24/2021 11/23/2022 4,014 333 — 4,014,333 — (4,014,333 Bank OZK 0.28% 12/7/2020 12/7/2022 5,024,655 2,360 5,027,015 — 5,024,655 Prosperity Bank 0.20% 6/9/2021 12/9/2022 10,025,070 3,351 10,028,422 — 10,025,070 Veritex Community Bank 0.28% 1/6/2021 1/6/2023 4,016,783 2,835 — 4,019,618 2,835 R Bank 0.57% 7/6/2021 1/6/2023 1,005,736 1,451 — 1,007,187 1,451 Treasury 0.13% 1/5/2022 1/31/2023 4,994,900 — — 4,998 715 3,814 San Antonio TX Elec. 2.41% 4/13/2022 2/1/2023 500,000 — — 500,000 — Veritex Community Bank 0.30% 2/5/2021 2/6/2023 4,419,783 3,342 — 4,423,125 3,342 FFCB 0.16% 11/22/2021 2/10/2023 4,998,207 — — 4,999,447 1,240 Eagle Pass Texas 4.00% 6/7/2021 3/1/2023 655,193 — — 649,024 6,170 Prosperity Bank 0.25% 3/5/2021 3/6/2023 10,037,670 6,258 — 10,043,927 6,258 Bank OZK 0.26% 3/8/2021 3/8/2023 2,539,034 1,653 — 2,540,686 1,653 FFCB 0.13% 3/26/2021 3/23/2023 8,998,923 — — 8,999 492 569 Prosperity Bank 0.20% 4/12/2021 4/12/2023 5,014,211 2,501 — 5,016,711 2,501 FFCB 0.13% 4/13/2021 4/13/2023 4,998,237 — — 4,999,069 832 FFCB 0.38% 1/28/2022 4/27/2023 3,988,076 — — 3,993,325 5,249 Prosperity Bank 0.20% 5/19/2021 5/19/2023 10,026,773 5,000 — 10,031,774 5,000 FNMA 0.25% 6/23/2022 5/22/2023 4,916,690 — — 4,949,444 32,754 Ventex Community Bank 0.20% 6/1/2021 6/1/2023 20,050132 9,998 — 20,060,130 9,998 Bank OZK 0.20% 6/9/2021 6/9/2023 8,020,157 4,020 — 8,024,176 4,020 R Bank 0.70% 7/6/2021 7/6/2023 1 1,007,045 1,783 — 1,008,828 1 783 Treasury 1.25% 7/7/2021 7/31/2023 8,068,289 — — 8,047,623 20,666 Veritex Community Bank 0.25% 7/30/2021 7/31/2023 7,017,516 4,422 — 7,021,938 4,422 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,331,576 — — 4,292,187 39,389 Ventex Community Bank 0.25% 8/23/2021 8/23/2023 4,411,010 2,780 — 4,413,790 2,780 FHLMC 0.25% 1/28/2022 8/24/2023 41964.520 — — 4,974,472 9 952 FHLB 0.00% 8/31/2022 8/28/2023 4,844,606 — — 4,887,667 43,061 FNMA 2.88% 3/30/2022 9/12/2023 4,024,959 — — 4,018,342 6 617 Treasury 0.25% 9/30/2021 9/30/2023 9,995,410 — — 9,996,567 1,157 FHLMC 2.00% 2/28/2022 10/17/2023 5,023,410 — — 5,017,772 5,638 Treasury 2.88% 11/22/2021 10/31/2023 10,258,905 — — 10,198,755 60,150 FHLB 0.50% 11/12/2021 11/9/2023 4,998,719 — — 4,999,010 291 Treasury 2.88% 11/10/2021 11/30/2023 5141,223 — — 5110,724 30,499 Treasury 0.50% 6/23/2022 11/30/2023 4,856,891 — — 4,887,797 30,906 FHLB 0.50% 12/7/2021 12/8/2023 7,984,028 — — 7,987,414 3,386 FHLB 5.00% 12/19/2022 12/19/2023 — 10,000,000 — 10,000,000 10,000,000 FHLB 0.63% 1/5/2022 12/22/2023 4,991,117 — — 4,992,941 1,824 FFCB 0.90% 1/28/2022 1/18/2024 4,981,456 — — 4,985 048 3.592 10 City of Round Rock Valley View Consulting, L.L.C. Book Value Comparison December 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 Treasury 2.25% 1/5/2022 1/31/2024 8,156,938 - - 8,127,351 (29,587) Treasury 2.38% 2/14/2022 2/29/2024 14,151,045 - - 14,124,166 26,878 FHLB 1.88% 2/28/2022 3/8/2024 15,055,637 - - 15,045,887 9,750 FAMC 2.58% 4/18/2022 4/18/2024 10,000,000 - - 10,000,000 - - Treasury 2.25% 3/30/2022 4/30/2024 9,971,252 - - 9,975,828 4,576 FAMC 2.65% 5/9/2022 5/2/2024 2,996,479 - - 2,997,037 559 FFCB 2.63% 6/2/2022 5/3/2024 3,048,862 - - 3,049,201 338 Treasury 2.50% 6/2/2022 5/31/2024 6,982,183 - - 6,984,874 2,692 FHLB 3.13% 6/23/2022 6/14/2024 19,995,599 - - 19,996,249 650 FFCB 3.15% 7/15/2022 7/15/2024 10,004,007 - - 10,003,443 564 Treasury 1.75% 9/29/2022 7/31/2024 9,575,633 - - 9,633,905 58,271 FFCB 3.38% 8/31/2022 8/26/2024 23,428,274 - - 23,437,755 9,481 FFCB 3.50% 9/16/2022 9/13/2024 19,824,811 - - 19,847,384 22,573 FHLB 4.50% 11/1/2022 10/3/2024 - 1,994,928 - 1994,676 1994,676 FHLB 4.50% 11/1/2022 10/3/2024 - 2,992,392 - 2,992,013 2,992 013 Treasury 0.63% 12/13/2022 10/15/2024 - 4,673,034 - 4,676,862 4,676,862 FFCB 4.38% 10/17/2022 10/17/2024 - 7,000,796 - 7,000,714 7,000,714 FHLB 4.53% 12/14/2022 11/18/2024 - 15,000,000 - 15,000,000 15,000,000 Sub Total/Average Fund 000-Pooled Investments 445,502,455 80,247,135 1 53,681,093 472,073,020 26,570,565 Fund 170-Interest&Sinking GO Bonds TexPool N/A 9/30/2015 N/A 1,338,789 1,944,806 321,394 2,962,201 1,623 412 TexasDAILY N/A 4/30/2016 N/A 1 27,805 1 254 1 - 28,059 1 254 Sub Total/Average Fund 170-Interest&Sinking GO Bonds 1,366,595 1,945,059 321,394 2,990,260 1 1,623,666 Fund 210-Interest&Sinking Debt Service JPMor an Chase N/A 9/30/2015 N/A 6,780 - 1,500 5,280 1,500 Sub Total/Average Fund 210-Interest&Sinking Debt Service 6,780 - 1,500 5,280 1,500 Fund 460-Bond Fund TexPool N/A 9/30/2015 N/A 883,047 4,498 533,839 353,707 529,341 Sub Total/Average Fund 460-Bond Fund 883,047 4,498 533,839 1 353,707 529,341 Fund 462-2017 Bond Fund TexPool N/A 5/30/2017 N/A 2,016,72418 063 28,006 2,006,782 9,942 NexBank N/A 3/30/2020 N/A 1,627,567 15,078 - 1,642,645 15,078 Treasury 2.38% 6/30/2022 1/31/2023 5,996,573 - - 1 5,999,136 2,563 Sub Total/Average Fund 462-2017 Bond Fund 9,640,864 33,141 28,006 9,648,563 1 7,699 Fund 465-Road CO Bond Fund TexPool N/A 9/1/2020 N/A 11,510,910 85,714 2,603,444 8,993,179 2,517,730 Veritex Community Bank 0.30% 2/5/2021 2/6/2023 5,625 178 4,254 - 5,629 432 4,25 Treasury 0.13% 6/2/2022 3/31/2023 24,768,121 - - 24,885,335 117,213 FHLB 3.63% 9/9/2022 9/6/2023 9,997,645 - - 9,998,280 635 Sub Total/Average Fund 465-Road CO Bond Fund 51,901,854 89,968 2,603,444 49,506,226 2,395,628 Fund 591 -Reserves Fund TexPool N/A 9/30/2015 N/A 8,784 78 - 8,861 78 NexBank N/A 4/29/2019 N/A 866,983 8,032 - 875,014 8,032 Sub Total/Average Fund 591-Reserves Fund 875,766 8,110 - 883,876 8,110 Fund 602-Interest&Sinking Revenue Bonds TexPool N/A 9/30/2015 N/A 2,195,826 1,886,640 - 4,082,466 1,886,640 Sub Total/Average Fund 602-Interest&Sinking Revenue Bonds 2,195,826 1,886,640 - 4,082,466 1,886,640 11 City of Round Rock Valley View Consulting, L.L.C. Book Value Comparison December 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 604-2022 SIB Loan TexPool N/A 9/29/2022 N/A 22,782,359 114,018 20,000 000 2,896,378 19,885,982 American Nat'l Bank&Trust N/A 11/21/2022 N/A - 20,088,358 - 20,088,358 Sub Total/Average Fund 604-2022 SIB Loan 22,782,359 20,202,377 20,000,000 22,984,736 202,377 Fund 605-Kalahari Debt Service Reserve TexPool N/A 8/30/2019 N/A 259,953 1,652,119 - 1,912,072 1652,119 Sub Total/Average Fund 605-Kalahari Debt Service Reserve 259,953 1,652,119 - 1,912,072 1,652,119 Total/Average $ 535,415,498 $ 106,069,047 $ 77,169,276 $ 564,440,204 $ 29,024,706 12 City of Round Rock Valley View Consulting,L.L.C. Market Value Comparison December 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 $ 10488,641 $ 4,245,073 $ 4,819,659 $ 9,914,055 $ — TexPool N/A 9/30/2015 N/A 14,249,176 34,003,001 9,473 801 38,778,376 — TexSTAR N/A 9/30/2015 N/A 201,831 1,765 — 203,596 — TexasDAILY N/A 9/30/2015 N/A 2,277 545 20,775 — 2,298,320 — TexasDAILY N/A 6/1/2021 N/A 2,438 22 — 2,460 — TexasDAILY Select N/A 12/3/2021 N/A 5,033,332 48,384 — 5,081,716 — NexBank N/A 11/29/2016 N/A 22,945,659 212,569 — 23158,229 — Veritex Community Bank N/A 9/1/2020 N/A 190,047 2,148 — 192,194 — State of Texas 2.52% 10/14/2021 10/1/2022 5,000,000 — 5,000,000 — — State ofTexas 1.61% 3/19/2021 10/1/2022 3,250,000 — 3,250,000 —Prosperity Bank 0.40% 10/15/2020 10/17/2022 6,046,183 — 6,046,183 — — Veritex Community Bank 0.26% 2/5/2021 11/4/2022 3,011,687 — 3,011,687 — — Prosperity Bank 0.20% 2/12/2021 11/14/2022 3,009,499 495 3,009 994 — — R Bank 0.48% 11/24/2021 11/23/2022 4,014,333 — 4,014,333 — — Bank OZK 0.28% 12/7/2020 12/7/2022 5,024,655 2,360 5,027,015 — — Prosperity Bank 0.20% 6/9/2021 12/9/2022 10,025,070 3,351 10,028,422 — — Veritex Community Bank 0.28% 1/6/2021 1/6/2023 4,016,783 2,835 — 4,019,618 — R Bank 0.57% 7/6/2021 1/6/2023 1,005 736 1,451 — 1,007,187 — Treasury 0.13% 1/5/2022 1/31/2023 4,940,430 — — 4,984,461 44,031 San Antonio TX Elec. 2.41% 4/13/2022 2/1/2023 497,275 — — 499,075 1,800 Veritex Community Bank 0.30% 2/5/2021 2/6/2023 4,419,783 3,342 — 4,423,125 — FFCB 0.16% 11/22/2021 2/10/2023 4,930,832 — — 4,977,007 46,175 Eagle Pass Texas 4.00% 6/7/2021 3/1/2023 646,974 — — 645,787 1,187 Prosperity Bank 0.25% 3/5/2021 3/6/2023 10,037,670 6,258 — 10 043,927 — Bank OZK 0.26% 3/8/2021 3/8/2023 2,539,034 1,653 — 2,540,686 — FFCB 0.13% 3/26/2021 3/23/2023 8,842 386 — — 8,914,039 71 654 Prosperity Bank 0.20% 4/12/2021 4/12/2023 5,014,211 2,501 — 5,016,711 — FFCB 0.13% 4/13/2021 4/13/2023 4,897,194 — — 4,938,286 41,093 FFCB 0.38% 1/28/2022 4/27/2023 3,918,332 — — 3,947,658 29,326 Prosperity Bank 0.20% 5/19/2021 5/19/2023 10,026,773 5,000 — 10,031,774 — FNMA 0.25% 6/23/2022 5/22/2023 4,880,122 — — 4,914,617 34,495 Veritex Community Bank 0.20% 6/1/2021 6/1/2023 20,050,132 9,998 — 20,060,130 — Bank OZK 0.20% 6/9/2021 6/9/2023 1 8,020,157 4,020 — 8,024 176 — R Bank 0.70% 7/6/2021 7/6/2023 1,007,045 1,783 — 1,008,828 — Treasu 1.25% 7/7/2021 7/31/2023 7,806,875 — — 7,843,393 36,518 Veritex Community Bank 0.25% 7/30/2021 7/31/2023 7,017,516 4,422 — 7,021 938 — Arlin ton TX HGR EDU 0.63% 4/28/2021 8/15/2023 1,413,397 — — 1,422,274 8,877 Dallas ISD 4.00% 4/22/2021 8/15/2023 4,190,008 — — 4,182,667 7,341 Veritex Community Bank 0.25% 8/23/2021 8/23/2023 4,411,010 2,780 — 4,413,790 — FHLMC 0.25% 1/28/2022 8/24/2023 4,825,811 — — 41858,171 32 360 FHLB 0.00% 8/31/2022 8/28/2023 4,803,950 — — 4,844,950 41,000 FNMA 2.88% 3/30/2022 9/12/2023 3,943,184 — 3,947,138 3 954 Treasury 0.25% 9/30/2021 9/30/2023 9,607,422 — — 9,674,345 66,923 FHLMC 2.00% 2/28/2022 10/17/2023 4,876,889 — — 4,887 664 10,775 Treasury 2.88% 11/22/2021 10/31/2023 9,851,953 — — 9,853,531 1,578 FHLB 0.50% 11/12/2021 11/9/2023 4,800,440 — — 4,818 280 17,840 Treasury 2.88% 11/10/2021 11/30/2023 4,918,360 — — 4,918,493 134 Treasury 0.50% 6/23/2022 11/30/2023 4,786,133 — — 4,810,890 24,757 FHLB 0.50% 12/7/2021 12/8/2023 7,657,694 — — 7,684,982 27,288 FHLB 5.00% 12/19/2022 12/19/2023 — 10,000,000 — 10,000,666 666 FHLB 0.63% 1/5/2022 12/22/2023 4,785,873 — — 4,802,400 16,528 FFCB 0.90% 1/28/2022 1/18/2024 4 790,585 — I — 4,799,500 8,915 13 City of Round Rock Valley View Consulting,L.L.C. Market Value Comparison December 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 Treasury 2.25% 1/5/2022 1/31/2024 7,786,562 - - 7,790,024 3,462 Treasury 2.38% 2/14/2022 2/29/2024 13,628,125 - - 13,641,082 12,957 FHLB 1.88% 2/28/2022 3/8/2024 14,533,034 - - 14,490,726 42,308 FAMC 2.58% 4/18/2022 4/18/2024 1 9,725,270 - - 9,706,750 18,520 Treasury 2.25% 3/30/2022 4/30/2024 9,682,031 - - 9,685,641 3,610 FAMC 2.65% 5/9/2022 5/2/2024 2,924,591 - - 2,918,009 (6,582) FFCB 2.63% 6/2/2022 5/3/2024 2,973,274 - - 2,967,577 5,698 Treasury 2.50% 6/2/2022 5/31/2024 6,798,203 - - 6,792,211 (5,993) FHLB 3.13% 6/23/2022 6/14/2024 19,582,496 - - 19,536,234 46,262 FFCB 3.15% 7/15/2022 7/15/2024 9,793,950 - - 9,772,670 21280 Treasury 1.75% 9/29/2022 7/31/2024 9,558,203 - - 9,568,545 10,342 FFCB 3.38% 8/31/2022 8/26/2024 23,098,604 - - 23,030,583 68,021 FFCB 3.50% 9/16/2022 9/13/2024 19,676,132 - - 19,626,292 49,840 FHLB 4.50% 11/1/2022 10/3/2024 - 1,994,928 - 2,003,408 9 230 FHLB 4.50% 11/1/2022 10/3/2024 - 2,992,392 - 3,005112 13,845 Treasury 0.63% 12/13/2022 10/15/2024 - 4,673,034 - 4,671617 3,648 FFCB 4.38% 10/17/2022 10/17/2024 - 7,000,796 - 6,976,108 24,688 FHLB 4.53% 12/14/2022 11/18/2024 - 15,000,000 - 14,992,443 7,557 Sub Total/Average Fund 000-Pooled Investments 438,708,537 1 80,247,135 53,681,093 1 465,586,141 318,503 Fund 170-Interest&Sinking GO Bonds TexPool N/A 9/30/2015 N/A 1,338,789 1,944,806 321394 1 2,962,201 - TexasDAILY N/A 1 4/30/2016 N/A 27,805 254 - 1 28,059 1 - Sub Total/Average Fund 170-Interest&Sinking GO Bonds 1,366,595 1,945,059 321,394 1 2,990,260 - Fund 210-Interest&Sinking Debt Service JPMor an Chase N/A 9/30/2015 N/A 6,780 - 1,500 1 5,280 - Sub Total/Average Fund 210-Interest&Sinking Debt Service 6,780 - 1,500 5,280 - Fund 460-Bond Fund TexPool N/A 9/30/2015 N/A 883,047 4,498 533,839 353,707 - Sub Total/Average Fund 460-Bond Fund 883,047 4,498 533,839 353,707 - Fund 462-2017 Bond Fund TexPool N/A 5/30/2017 N/A 2,016,724 18,063 28,006 2,006,782 - NexBank N/A 3/30/2020 N/A 1,627,567 15,078 - 1,642,645 - Treasury 2.38% 6/30/2022 1/31/2023 5,971,640 - - 5,992,123 20,482 Sub Total/Average Fund 462-2017 Bond Fund 9,615,931 33,141 28,006 9,641,549 20,482 Fund 465-Road CO Bond Fund TexPool N/A 9/1/2020 N/A 11,510,910 1 85,714 2,603,444 8,993179 - Veritex Community Bank 0.30% 2/5/2021 2/6/2023 5,625,178 4,254 - 51629,432 - Treasury 0.13% 6/2/2022 3/31/2023 24,539,063 - - 24 747,670 208,608 FHLB 3.63% 9/9/2022 9/6/2023 9,931,363 - - 9,911,338 20,025 Sub Total/Average Fund 465-Road CO Bond Fund 51,606,513 89,968 2,603,444 49,281,619 188,583 Fund 591 -Reserves Fund TexPool N/A 9/30/2015 N/A 8,784 78 1 - 8,861 - NexBank N/A 4/29/2019 N/A 866,983 8,032 - 875,014 - Sub Total/Average Fund 591-Reserves Fund 875,766 1 8,110 - 883,876 - Fund 602-Interest&Sinking Revenue Bonds TexPool N/A 9/30/2015 N/A 2,195,826 1,886,640 - 4,082,466 - Sub Total/Average Fund 602-Interest&Sinking Revenue Bonds 2,195,826 1,886,640 - 4,082,466 - 14 City of Round Rock Valley View Consulting, L.L.C. Market Value Comparison December 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 604-2022 SIB Loan TexPool N/A 9/29/2022 N/A 22,782,359 114,018 1 20,000,000 1 2,896,378 1 - American Nat'l Bank&Trust N/A 11/21/2022 N/A - 20,088,358 1 - 20,088,358 1 - Sub Total/Average Fund 604-2022 SIB Loan 22,782,359 20,202,377 20,000,000 22,984,736 - Fund 605-Kalahari Debt Service Reserve TexPool N/A 8/30/2019 N/A 259,953 1 1,652,119 - 1,912,072 - Sub Total/Average Fund 605-Kalahari Debt Service Reserve 259,953 1,652,119 - 1,912,072 - Total/Average $ 528,301,307 $ 106,069,047 $ 77,169,276 $ 557,721,705 $ 527,567 15 City of Round Rock Valley View Consulting, L.L.C. Holdings by Allocation and Portfolio (Fund) September 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 3.05% 11/29/2016 $ 22,945,659 $ 22,945,659 100.00 $ 22,945,659 N/A 1 3.05% TexasDAILY 2.43% AAAm 6/1/2021 2,438 2,438 100.00 2,438 N/A 1 2.43% TexasDAILY Select 2.72% AAAm 12/3/2021 5,033,332 5,033,332 100.00 5,033,332 N/A 1 2.72% Veritex Community Bank 3.08% 9/1/2020 190,047 190,047 100.00 190,047 N/A 1 3.08% JPMor an Chase 0.40% 9/30/2015 10,488.641 10,488.641 100.00 10.488,641 N/A 1 0.40% TexSTAR 2.29% AAAm 9/30/2015 201,831 201,831 100.00 201,831 N/A 1 2.29% TexPool 2.41% AAAm 9/30/2015 14,249,176 14,249,176 100.00 14,249,176 N/A 1 2.41% TexasDAILY 2.43% AAAm 9/30/2015 2,277,545 2,277,545 100.00 2,277,545 N/A 1 2.43% State of Texas 1.61% Aaa/AAA/- 3/19/2021 3,250,000 3,250.130 100.00 3,250,000 10/1/2022 1 0.15% State of Texas 2.52% Aaa/AAA/- 10/14/2021 5,000,000 5,000.323 100.00 5,000,000 10/1/2022 1 0.15% Prosperity Bank 0.40% 10/15/2020 6,046.183 6,046,183 100.00 6,046,183 10/17/2022 17 0.40% Veritex Community Bank 0.26% 2/5/2021 3,011,687 3,011,687 100.00 3,011,687 11/4/2022 35 0.26% Prosperity Bank 0.20% 2/12/2021 3,009,499 3,009,499 100.00 3,009,499 11/14/2022 45 0.20% R Bank 0.48% 11/24/2021 4,014,333 4,014,333 100.00 4,014,333 11/23/2022 54 0.48% Bank OZK 0.28% 12/7/2020 5,024,655 5,024,655 100.00 5,024,655 12/7/2022 68 0.28% Prosperity Bank 0.20% 6/9/2021 10,025,070 10,025,070 100.00 10,025,070 12/9/2022 70 0.20% Veritex Community Bank 0.28% 1/6/2021 4,016,783 4,016,783 100.00 4,016,783 1/6/2023 98 0.28% R Bank 0.57% 7/6/2021 1,005,736 1,005,736 100.00 1,005,736 1/6/2023 98 0.57% Treasury 0.13% Aaa/AA+/AAA 1/5/2022 5,000,000 4,994,900 98.81 4,940,430 1/31/2023 123 0.43% San Antonio TX Elec. 2.41% Aa2/AA-/AA- 4/13/2022 500,000 500,000 99.46 497,275 2/1/2023 124 2.41% Veritex Community Bank 0.30% 2/5/2021 4,419.783 4,419,783 100.00 4,419.783 2/6/2023 129 0.30% FFCB 0.16% Aaa/AA+/AAA 11/22/2021 5,000,000 4,998,207 98.62 4,930,832 2/10/2023 133 0.26% Eagle Pass Texas 4.00% -/AA-/- 6/7/2021 645.000 655,193 100.31 646,974 3/1/2023 152 0.20% Prosperity Bank 0.25% 3/5/2021 10,037,670 10,037,670 100.00 10,037,670 3/6/2023 157 0.25% Bank OZK 0.26% 3/8/2021 2,539,034 2,539,034 100.00 2,539,034 3/8/2023 159 0.26% FFCB 0.13% Aaa/AA+/AAA 3/26/2021 9,000,000 8,998,923 98.25 8,842,386 3/23/2023 174 0.15% Prosperity Bank 0.20% 4/12/2021 5.014,211 5,014,211 100.00 5.014,211 4/12/2023 194 0.20% FFCB 0.13% Aaa/AA+/AAA 4/13/2021 5,000,000 4,998,237 97.94 4,897,194 4/13/2023 195 0.19% FFCB 0.38% Aaa/AA+/AAA 1/28/2022 4,000,000 3,988.076 97.96 3,918,332 4/27/2023 209 0.90% Prosperity Bank 0.20% 5/19/2021 10,026,773 10.026,773 100.00 1 10,026,773 5/19/2023 231 0.20% FNMA 0.25% Aaa/AA+/AAA 6/23/2022 5,000,000 4,916,690 97.60 4,880,122 5/22/2023 234 2.90% Veritex Community Bank 0.20% 6/1/2021 20,050,132 20,050,132 100.00 20,050,132 6/1/2023 244 0.20% Bank OZK 0.20% 6/9/2021 8,020,157 8,020,157 100.00 8,020,157 6/9/2023 2521 0.20% R Bank 0.70% 7/6/2021 1,007,045 1,007,045 100.00 1,007,045 7/6/2023 2791 0.70% Treasury 1.25% Aaa/AA+/AAA 7/7/2021 8,000.000 8,068,289 97.59 7,806,875 7/31/2023 304 0.22% Veritex Community Bank 0.25% 7/30/2021 7,017,516 7,017,516 100.00 7,017,516 7/31/2023 304 0.255/. Dallas ISD 4.00% Aaa/AAA/AAA 4/22/2021 1 4,195.000 4,331,576 99.88 1 4,190,008 8/15/2023 319 0.26% Arlington TX HGR EDU 0.63% -/AAA/- 4/28/2021 1,460,000 1,460,000 96.81 1,413,397 8/15/2023 319 0.63% Veritex Community Bank 0.25% 8/23/2021 41411,010 4,411,010 100.00 4,411,010 8/23/2023 327 0.25% FHLMC 0.25% Aaa/AA+/AAA 1/28/2022 5,000,000 4,964,520 96.52 4,825,811 8/24/2023 328 1.05% FHLB 0.00% Aaa/AA+/-- 8/31/2022 5,000,000 4,844,606 96.08 4,803,950 8/28/2023 332 3.51% FNMA 2.88% Aaa/AA+/AAA 3/30/2022 4.000,000 4,024,959 98.58 3,943,184 9/12/2023 347 2.20% Treasury 0.25% Aaa/AA+/AAA 9/30/2021 10,000,000 9,995,410 96.07 9,607,422 9/30/2023 365 0.30% FHLMC 2.00% Aaa/AA+/AAA 2/28/2022 5.000,000 5,023,410 97.54 4,876,889 10/17/2023 382 1.55% Treasu 2.88% 1 Aaa/AA+/AAA 11/22/2021 10,000,000 10,258,905 98.52 9,851,953 10/31/2023 396 0.47% FHLB 0.50% 1 Aaa/AA+/-- 11/12/2021 5,000,000 4,998,719 96.01 4,800,440 11/9/2023 405 0.52% JTreasury 0.50% 1 Aaa/AA+/AAA 6/23/2022 5.000,000 4,856,891 95.72 4,786,133 11/30/2023 426 3.03% ITreasury 2.88% 1 Aaa/AA+/AAA 11/10/2021 5,000,000 5,141,223 98.37 4,918,360 11/30/2023 426 0.44% 16 City of Round Rock Valley View Consulting, L.L.C. Holdings by Allocation and Portfolio (Fund) September 30, 2022 Coupon Settlement Face Amount/ Book Days to YTM @ Issuer Rate Credit Rating Date Shares Book Value Price Market Value Maturity Date Maturity Book FHLB 0.50% Aaa/AA+/-- 12/7/2021 8,000,000 7,984,028 95.72 7,657,694 12/8/2023 434 0.67% FHLB 0.63% Aaa/AA+/-- 1/5/2022 5,000,000 4,991,117 95.72 4,785,873 12/22/2023 448 0.77% FFCB 0.90% Aaa/AA+/AAA 1/28/2022 5,000,000 4,981,456 95.81 4,790,585 1/18/2024 475 1.19% Treasury 2.25% Aaa/AA+/AAA 1/5/2022 8,000,000 8,156,938 97.33 7,786,562 1/31/2024 488 0.77% Treasury 2.38% Aaa/AA+/AAA 2/14/2022 14,000,000 14,151,045 97.34 13,628,125 2/29/2024 517 1.60% FHLB 1.88% Aaa/AA+/-- 2/28/2022 15,000,000 15,055,637 96.89 14,533,034 3/8/2024 525 1.61% FAMC 2.58% 4/18/2022 10,000,000 10,000,000 97.25 9,725,270 4/18/2024 566 2.58% Treasury 2.25% Aaa/AA+/AAA 3/30/2022 10,000,000 9,971,252 96.82 9,682,031 4/30/2024 578 2.44% FAMC 2.65% 5/9/2022 3,000,000 2,996,479 97.49 2,924,591 5/2/2024 580 2.73% FFCB 2.63% Aaa/AA+/AAA 6/2/2022 3,051,000 3,048,862 97.45 2,973,274 5/3/2024 581 2.67% Treasury 2.50% Aaa/AA+/AAA 6/2/2022 7,000,000 6,982,183 97.12 6,798,203 5/31/2024 609 2.66% FHLB 3.13% Aaa/AA+/-- 6/23/2022 20,000,000 19,995,599 97.91 19,582,496 6/14/2024 623 3.14% FFCB 3.15% Aaa/AA+/AAA 7/15/2022 10,000,000 10,004,007 97.94 9,793,950 7/15/2024 654 3.13% Treasury 1.75% Aaa/AA+/AAA 9/29/2022 10,000,000 9,575,633 95.58 9,558,203 1 7/31/2024 670 4.18% FFCB 3.38% Aaa/AA+/AAA 8/31/2022 23,500,000 23,428,274 98.29 23,098,604 8/26/2024 1 96 3.54% FFCB 3.50% Aaa/AA+/AAA 9/16/2022 20,000,000 19,824,811 98.38 19,676,132 9/13/2024 714 3.97% Sub Total/Average 1 1.61% 445,686,946 1 445,502,455 98.43 1 438,708,537 1 341 1.58% Fund 170-Interest&Sinking GO Bonds TexasDAILY 2.43% AAAm 4/30/2016 27,805 27,805 100.00 27,805 N/A 1 2.43% TexPool 2.41% AAAm 9/30/2015 1,338,789 1,338,789 100.00 1,338,789 N/A 1 2.41% Sub Total/Average 2.41% 1,366,595 1,366,595 100.00 1,366,595 1 Fund 210-Interest&Sinking Debt Service JPMor an Chase 1 0.40% 9/30/2015 6,780 6,780 100.00 6,780 N/A 11 0.40% Sub Total/Average 1 0.40% 6,780 6,780 100.00 6,780 1 0.40% Fund 460-Bond Fund TexPool 2.41% AAAm 9/30/2015 883,047 883,047 100.00 883,047 N/A 1 2.41% Sub Total/Average 2.41% 883,047 883,047 100.00 1 883,047 1 2.41% Fund 462-2017 Bond Fund TexPool 2.41% AAAm 5/30/2017 2,016,724 2,016,724 100.00 2,016,724 N/A 1 2.41% NexBank 3.05% 3/30/2020 1,627,567 1,627,567 100.00 1,627,567 N/A 1 3.05% Treasury 2.38% Aaa/AA+/AAA 6/30/2022 6,000,000 5,996,573 99.53 5,971,640 1/31/2023 123 2.55% Sub Total/Average 2.50% 9,644,291 9,640,864 99.71 9,615,931 77 2.60% Fund 465-Road CO Bond Fund TexPool 2.41% AAAm 9/1/2020 11,510,910 11,510,910 100.00 11,510,910 N/A 1 2.41% Veritex Community Bank 0.300/6 2/5/2021 5,625,178 5,625,178 100.00 5,625,178 2/6/2023 129 0.30% Treasury 0.13% Aaa/AA+/AAA 6/2/2022 25,000,000 24,768,121 98.16 24,539,063 3/31/2023 182 2.01% FHLB 3.63% Aaa/AA+/-- 9/9/2022 10,000,000 9,997,645 99.31 9,931,363 9/6/2023 341 3.65% Sub Total/Average 1.32% 52,136,088 51,901,854 98.98 51,606,513 167 2.23% Fund 591 -Reserves Fund TexPool 2.41% AAAm 1 9/30/2015 1 8,784 8,784 1 100.00 8,784 N/A 1 2.41% NexBank 3.05% 4/29/2019 866,983 866,983 100.00 866,983 N/A 1 3.05% Sub Total/Average 3.04% 875,766 875,766 100.00 875,766 11 3.04% Fund 602-Interest&Sinking Revenue Bonds TexPool 2.41% AAAm 9/30/2015 2,195,826 2,195,826 100.00 2,195,826 N/A 17 City of Round Rock Valley View Consulting, L.L.C. Holdings by Allocation and Portfolio (Fund) September 30, 2022 Coupon Settlement Face Amount/ Book Days to YTM @ Issuer Rate Credit Rating Date Shares Book Value Price Market Value Maturity Date Maturity Book Sub Total/Average 2.41% 2,195,826 2,195,826 100.00 2,195,826 1 2.41% Fund 604-2022 SIB Loan TexPool 2.41% AAAm 1 9/29/2022 1 22,782,359 1 22,782,359 1 100.00 1 22,782,359 1 N/A 1 2.41% Sub Total/Average 2.41% 1 1 22,782,359 1 22,782,359 1 100.00 1 22,782,359 1 1 2.41% Fund 605-Kalahari Debt Service Reserve TexPool 2.41% AAAm 8/30/2019 259,953 259,953 100.00 259,953 N/A 1 2.41 Sub Total/Average 2.41% 259,953 259,953 100.00 1 259,953 1 1 2.41% Total/Average 1.64% $ 535,837,650 $ 535,415,498 98.59 1 $ 528,301,307 1 3021 1.71% 18 City of Round Rock Valley View Consulting, L.L.C.