Loading...
R-2021-322 - 12/2/2021 RESOLUTION NO. R-2021-322 WHEREAS, Chapter 2256, Texas Government Code, Section 2256.023 of the Public Funds Investment Act states that a written report of investments be submitted to the governing body at least quarterly; and WHEREAS, a Quarterly Investment Report for the quarter ending September 30, 2021 for the City of Round Rock has been submitted to the City Council; and WHEREAS, the City Council desires to acknowledge the receipt and acceptance of the attached Quarterly Investment Report,Now Therefore BE IT RESOLVED BY THE COUNCIL OF THE CITY OF ROUND ROCK,TEXAS, That the Quarterly Investment Report, attached hereto as Exhibit "A" and incorporated herein, is hereby received and accepted. The City Council hereby finds and declares that written notice of the date, hour, place and subject of the meeting at which this Resolution was adopted was posted and that such meeting was open to the public as required by law at all times during which this Resolution and the subject matter hereof were discussed, considered and formally acted upon, all as required by the Open Meetings Act, Chapter 551, Texas Government Code, as amended. RESOLVED this 2nd day of December,2021. CRAIG RG ayor City of R and R , Texas ATTEST: MEAGAN TKS, City Clerk 0112.20212;4994-9180-8516 M EXHIB IT P�ROaU�ND ROCK TEXAS QUARTERLY INVESTMENT REPORT For the Quarter Ended September 30, 2021 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 Invest ent Policy and Strategies. r Chi inancial bfficer Controller Treasu 6fccountant )'/ Ion- -7-7 �02-1 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. City of Round Rock, Texas Annual Comparison of Portfolio Performance FYE Results by Investment Category: September 30,2020 September 30, 2021 Asset Type Ave.Yield Book Value Market Value Ave.Yield Book Value Market Value Cash 0.17% $ 5,805,957 $ 5,805,957 0.14% $ 20,388,226 $ 20,388,226 Certificates of Deposit 1.77% 251,459,497 251,459,497 0.53% 295,898,976 295,898,976 Local Government Investment Pool 0.15% 19,222,939 19,222,939 0.03% 27,503,126 27,503,126 Money Market Accounts 0.37% 57,904,552 57,904,552 0.28% 75,253,290 75,253,290 Municipal 0.58% 16,308,884 16,339,160 0.32% 13,344,197 13,344,663 US Agency 2.87% 5,9999985 6,006,319 0.17% 13,991,601 13,986,417 US Treasury - - 0.26% 18,141,101 18,138,748 Totals 356,7019813 356,738,424 464,620,518 464,513,446 Fourth Quarter-End Yield 1.39% 0.42% Average Quarter-End Yields -Fiscal Year(1): Round Rock-Total Portfolio 1.77% 0.68% TexPool Yield 0.75% 0.04% Rolling Three Mo. Treas.Yield 0.76% 0.05% Rolling Six Mo. Treas.Yield 0.99% 0.08% Rolling 1 Yr. Treas.Yield 1.42% 0.17% Rolling 2 Yr. Treas.Yield 1.93% 0.78% Year-to-date Interest Income $ 6,489,142 Approximate $ 3,152,347 Approximate (1) Average Quarterly Yield calculated using quarter-end report average yield and adjusted book value. 1 City of Round Rock Valley View Consulting,L.L.C. Summary Holdings by Investment Category (Security Sector) September 30, 2021 YTM @ Description Cost Book Value Market Value Cash 0.14% $ 20,388,226 $ 20,388,226 Certificates of Deposit 0.53% 295,898,976 295,898,976 Local Government Investment Pool 0.03% 27,503,126 27,503,126 Money Market Accounts 0.28% 75,253,290 75,253,290 Municipal 0.32% 13,344,197 13,344,663 US Agency 0,17% 13,991,601 13,986,417 US Treasury 0.26% 18,141,101 18,138,748 Total/Average 0.42% $ 464,520,518 $ 464,513,446 June 30, 2021 YTM @ Description Cost Book Value Market Value Cash 0.15% $ 24,803,357 $ 24,803,357 Certificates of Deposit 0.66% 314.611,546 314,611,546 Local Government Investment Pool 0.02% 52,699,346 52,699,346 Money Market Accounts 0.35% 60,204,332 60,204,332 Municipal 0.26% 24,601,625 24,600.288 US Agency 0.17% 13,990,199 13,970.355 Total/Average 0.49% $ 490,910,406 $ 490,889,226 Average Yield Current Fiscal Year- Quarter(1) to-Date(2) Total Portfolio 0.42% 0.68% TexPool Yield 0.03% 0.04% Rolling Three Mo. Treas. Yield 0.05% 0.05% Rolling Six Mo. Treas. Yield 0.05% 0.08% Rolling 1 Yr. Treas. Yield 0.08% 0.17% Rolling 2 Yr. Treas. Yield 0.46% 0.78% Investment Income (3) Interest Income(Approximate) $ 528,001 $ 3,152,347 WAM at 9/30/2021 Policy WAM Max Total Portfolio 255 days 540 days Pooled Funds 271 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. 2 City of Round Rock Valley View Consulting, L.L.C. Economic Overview 9/30/2021 The Federal Open Market Committee(FOMC)maintained the Fed Funds target range at 0.00%to 0.25%(Effective Fed Funds are trading<0.10%),and projects that reduced rates could remain into 2023. Monthly government security purchases may begin tapering as early as Nov 2021. Second Quarter GDP posted+6.7%(Final). Employment recovery/growth has moderated, but job openings remain high. August Non-Farm Payroll only added 194k net new jobs. Crude oil bounced up to+/-$77 per barrel,with fuel shortages in England and other countries. The Stock Markets reached new highs, but have retrenched slightly. Housing, Industrial Production, Durable Goods,Consumer Spending,and other indicators remain positive but constrained. The Biden administration and Congress continue to negotiate infrastructure,fiscal and debt limit packages. Inflation remained over the FOMC 2+%target and may not be as temporary as initially projected. The Yield Curve rose slightly from two years to ten years. 1.60 Treasury Yield Curves a,�so S&P 500 4,500 1.40 4,250 a,000 1.20 3,750 3,500 1.00 3,250 3,000 0.80 2,250 2,500 2, 00 0.60 - - 2,000 0.40 - 1,500 411111111111111, 1,250 0.20 1,0500 0.00 25o •September 30,2020 June 30,2021 -September 30,2021 6.00 US Treasury Historical Yields-Since 2006 3.50 US Treasury Historical Yields-Since Nov 2015 5.50 AL L 5.00 3.00 -ri7� 4.50 2.50 4.00 'A A74 III, r 3.50 2.00 3.00 2.50 Ir 1.50 - 2.00 ♦�� 1.50 1.00 -- � 1.00 0.00 fo 0.00 ��` �js�A)�j9 °\J�` ��j�`o��`���)s°)j�`��VJ )°\)at` V9)JV)2�` j�`J��))�� `)JVry^ t'O°1 �10 16�J"N t'.4 1��ib 1� �Jv^��a�,1� N% \"N 1 �^9 °v1�p,1 02,o)J\ 1.1ry ~1 SJ`�1 --Six -Six Month T-13111 Two Year T-Note - Ten Year T-Note 3 Valley View Consulting,L.L.C. Holdings by Investment Category September 30, 2021 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.145,855 4% $ 242,371 0% $ - 0% $ - 0% $ 20,388,226 4% Certificates of Deposit 259,247,487 56% - 0% - 0% 36,651,489 8% 295,898.976 64% Investment Pools 20,397,338 4% 3,064,890 1% 261,766 0% 3,779,132 1% 27,503,126 6% Money Market Accounts 58,992,977 13% 1,291,409 0% 857,453 0% 14,111,451 3% 75,253,290 16% Municipal 13,344,197 3% - 0% - 0% - 0% 13,344,197 3% US Agency 13,991,601 3% - 00 - 0% - 0% 13,991,601 3% US Treasury 18,141,101 4% - 0% - 0% - 0% 18,141,101 4% Total IA $404,260,556 87% it 4,5N,6701 1% $ 1,119,219 00/0 1 $ 54,542.072 12% $464,520,518 100% Portfolio Balances (Millions) Order of Liquidity $500 - - - --- $450 — — — --------— ■Cash $400 ---- ■Local Government $350 - - ---- — Investment Pool $300 ■Money Market Account $250 ■US Treasury $200 ■US Agency $150 - ----... --- -- — $100 ---- ❑Municipal $50 ■Certificates of Deposit $0 Pooled Funds DS Funds DSR Funds CPBSP Funds Total Portfolio 9/30/2021 9/30/2021 9/30/2021 9/30/2021 9/30/2021 4 City of Round Rock Valley View Consulting,L.L.C. Investment Holdings by Investment Category Quarterly Transactions By Investment Category September 30, 2021 September 30,2021 %of Portfolio Net Cash Equivalent Description Book Value Portfolio Limitation Description Buys Sells Maturities Calls Interest DeposW(Withdrawal) Cash $ 20,388,226 4.4% 100% Cash $ — $ — $ — $ — $ — $ (4,415,131) Investment Pools 27,503,126 5.9% 100% Investment Pools — — — — 1,921 (25,196,221) Money Market Accounts 75,253,290 16.2% 75% Money Markets Accounts — — — — 48,958 15,048,958 Certificates of Deposit 295,898,976 63.7% 85% Certificates of Deposit 23,821,408 — 42,533,978 — 490,501 — Commercial Paper — 0.0% 10%/5% Commercial Paper — — — — —Municipal 13,344,197 2.90 35%/5% Municipal 560,000 — 11,700,000 — 433,400 — US Agency 13,991,601 3.0% Combined US Agency i — — — — 5,625 — US Treasury 18,141,101 3.9% 75% US Treasury 1 18,203,565 —I — — 50,000 — Total/Average $ 464.520.518 100% 1 PASSED Totals Is 42,584,973 S —1$ 54,233-978 S — $ 1,030,405 1$ 14,562,393 Portfolio Balances (Millions) Portfolio Composition Order of Liquidity Money Market Accounts September 30,2021 $500 16.2% $450 ■Cash $400 Investment Pools ■Local Government 5.9% $350 Investment Pool $300 - •Money Market Account Cash 4.4% $250 ■US Treasury $200 US Treasury 3.9% $150 ■US Agency US $100 []Municipal 3 Agency 0g� N Certificates of $50 Municipal Deposit $0 ■Certificates of Deposit 2.9% 63.7% >, 5 City of Round Rock Valley View Consulting, L.L.C. Portfolio Balances By Fund (Millions) $500 $450 $400 ■Capital Project& Special Purpose Funds $350 $300 ■Debt Service Reserve Funds $250 $200 ■Debt Service Funds $150 $100 ■Pooled Funds $50 $0 O^h O^h O�6 C^6 O^6 O�� O^•, Off` ^•` 0^1 0^� ��� 0^� &b &I, &% ^��^\ry ����\ry 6 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 AV f 1.70 a) 1.60 ;g 1.50 IL 1.40 L 1.30 a 1.20 1.10 1.00 0.90 0.80 0.70 0.60 0.50 0.40doo �.. 0.30 0.20 0.10 - 0.00 0 0 0 o O o o O o o O o 0 o O o 0 o Off' O`1' O`l 0`1 O`1' ��ti ��ti ��1, O�ti O�ti ��ti ��ti O�� o�ti ��ti ��ti o�`L O�`L N\ ^�ti O�`L O�ti oho ��o ��3 b\o OHO o\O \3 ,\O Oho off- \o \'5 OHO oho �\o Oho Oho OHO ��o O\O Oho C, Round Rock TexPool -� Rolling 1.5 yr Treasury (Policy WAM max) Rolling 9 mo Treasury 7 City of Round Rock Valley View Consulting, L.L.C. Holdings by Allocation and Portfolio Fund September 30, 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,091,817 $ 36,091,817 100.00 $ 36,091,817 N/A 1 0.40% TexasDAILY 0.02% AAAm 6/1/2021 1,799,103 1,799,103 100.00 1,799,103 N/A 1 0,02% Texas Capital Bank 0.15% 7/1/2021 7,724,273 7,724,273 100.00 7,724,273 N/A 1 0.15% Veritex Community Bank 0.08% 9/1/2020 175,902 175,902 100.00 175,902 N/A 1 0.08% JPMor an Chase 0.14% 9/30/2015 20,145,855 20,145,855 100.00 20,145,855 N/A 1 0.14% TexSTAR 0.01% AAAm 9/30/2015 200,527 200,527 100.00 200,527 N/A 1 0.01% TexPool 0.04% AAAm 9/30/2015 13,349,268 13,349,268 100.00 13,349,268 N/A 1 0.04% Prosperity Bank 0.15% 9/14/2021 13,000,855 13,000,855 100.00 13,000,855 N/A 1 0.15% TexasDAILY 0.02% AAAm 9/30/2015 5,048.440 5,048,440 100.00 5,048,440 N/A 1 0.02% Prosperity Bank 0.15% 9/14/2021 2,000,132 2,000,132 100.00 2,000,132 N/A 1 0.15% Veritex Community Bank 1.71% 10/3/2019 10,303,235 10,303,235 100.00 10,303,235 10/4/2021 4 1.71% East West Bank 1.65% 1/27/2020 6,168,587 6,168,587 100.00 6,168,587 10/27/2021 27 1.65% East West Bank 1.54% 2/18/2020 6,151,490 6,151,490 100.00 6.151,490 11/19/2021 50 1.54% East West Bank 1.64% 11/22/2019 5,154,890 5,154,890 100.00 5,154,890 11/22/2021 53 1.64% Independent Bank 0.40% 12/7/2020 8,024,046 8,024,046 100.00 8,024,046 12/7/2021 68 0,40% Veritex Community Bank 1.67% 12/20/2019 5,148,261 5,148,261 100.00 5.148,261 12/20/2021 81 1,67% Bank OZK 1 70% 1/28/2020 8,230,136 8,230.136 100.00 8,230,136 1/24/2022 116 1.70% R Bank 1.75% 1/27/2020 2,053,145 2,053,145 100.00 2,053,145 1/27/2022 119 1.75% Allegiance Bank 1_59% 2/10/2020 5,120,132 5,120.132 100.00 5,120,132 2/10/2022 1331 1.59% Goose Creek ISD 5.00% Aaa/-/AAA 11/17/2020 400,000 407,024 101.78 407,100 2/15/2022 138 0.33% East West Bank t54% 2/18/2020 5,126,242 5,126,242 100.00 5,126,242 2/18/2022 141 1_54% East West Bank 0.17% 2/19/2021 11.096,354 11,096,354 100.00 11,096,354 2/21/2022 144 0.17% FORT BEND COUNTY-REF 5.00% Aa1/-/AA+ 6/17/2020 250,000 254,150 101.99 254,978 3/1/2022 152 0.98% Allegiance Bank 0,40% 6/17/2020 10,049,963 10,049,963 100.00 10,049,963 3/18/2022 169 0.40% Independent Bank 0.40% 1/11/2021 20.039,691 20,039,691 100.00 20,039,691 4/11/2022 193 0.40% Veritex Community Bank 0.20% 2/5/2021 3,002,976 3,002,976 100.00 3,002,976 5/5/2022 217 0.20% Prosperity Bank 0.20% 2/12/2021 4.004.649 4,004,649 100.00 4,004,649 5/12/2022 224 0.20% Independent Bank 0.30% 5/19/2021 6,004,537 6,004,537 100.00 6,004,537 5/19/2022 231 0.30% Allegiance Bank 0.45% 6/17/2020 12.067.466 12,067,466 100.00 12,067,466 6/17/2022 260 0.45% Bank OZK 0.50% 7/9/2020 10,058,652 10,058,652 100.00 10.058,652 7/11/2022 284 0.50% Veritex Community Bank 0,24% 2/5/2021 3,003.571 3.003,571 100.00 3,003,571 8/5/2022 309 0.24% Prosperity Bank 0.20% 2/12/2021 3,003,487 3,003,487 100.00 3.003,487 8/12/2022 316 0.20% Bexar Co Txb Ref 0.33% A2/AA/A- 9/23/2021 560.000 560,000 99.94 559,636 8/15/2022 319 0.33% Arlington TX HGR EDU 0.50% -/AAA/- 4/28/2021 500,000 500,000 100.11 500,535 8/15/2022 319 0.50% Denton ISD 0.00% -/AAA/AAA 12/17/2020 500,000 497,989 99.69 498,465 8/15/2022 319 0.46% City of Bryan TX 0.45% -/AA/- 11/19/2020 500,000 500,000 100.13 500,660 8/15/2022 319 0.45% City of Austin GO 0.27% Aa1/AAA/AA+ 10/6/2020 700,000 70UT 100.15 701,078 9/1/2022 336 0.27% Prosperity Bank 0.20% 6/1/2021 3,001,513 3,001,513 100.00 3,001,513 9/1/2022 336 0.20% Veritex Community Bank 0.18% 3/5/2021 8,007,261 8,007,261 100.00 8,007.261 9/5/2022 340 0.18% State of Texas 1.61% Aaa/AAA/- 3/19/2021 3,250,000 3,297,516 101.47 3,297,873 10/1/2022 366 0.15% Prosperity Bank 0.40% 10/15/2020 6,022,050 6,022,050 100.00 6,022,050 10/17/2022 382 0,40% Veritex Community Bank 0.26% 2/5/2021 3,003,869 3,003,869 100.00 3.003,869 11/4/2022 400 0.26% Prosperity Bank 0.20% 2/12/2021 3,003,487 3,003,487 100.00 3,003,487 11/14/2022 410 0.20% Bank OZK 0.28% 12/7/2020 5,010,557 5,010,557 100.00 5,010,557 12/7/2022 4331 0.28% Prosperity Bank 0.20% 6/9/2021 10,005,042 10,005,042 100.00 10,005,042 12/9/2022 435 0.20% Veritex Community Bank 0,28% 1/6/2021 4,005,556 4,005.556 100.00 4,005,556 1/6/2023 463 0.28% R Bank 0.57% 7/6/2021 1.000,000 1,000,000 100.00 1,000,000 1/6/2023 463 0.57% Veritex Community Bank 0.30% 2/5/2021 4,406,548 4,406,548 100.00 4,406,548 2/6/2023 494 0.30% 8 City of Round Rock Valley View Consulting, L.L.C. Holdings by Allocation and Portfolio Fund September 30, 2021 Coupon Settlement Face Amount/ Market Days to YTM @ Issuer Rate Credit Rating Date Shares Book Value price Market Value Maturity Date Maturity Book Fa le Pass Texas 4.00% -/AA-/- 6/7/2021 645,000 679,671 105.25 1 678,830 3/1/2023 517 0.20% Prosperity Bank 0.25% 3/5/2021 10,012,609 10,012,609 100.00 10,012,609 3/6/2023 522 0.25% Bank OZK 0.26% 3/8/2021 2,532,416 2,532.416 100.00 2,532,416 3/8/2023 524 0.26% Federal Farm Credit Bank 0,13% Aaa/AA+/AAA 3/26/2021 9,000,000 8,996,664 99.92 8,992,829 3/23/2023 539 0.15% Prosperity Bank 0.20% 4/12/2021 5,004,193 5,004,193 100.00 5,004,193 4/12/2023 559 0.20% FFCB 0.13% Aaa/AA+/AAA 4/13/2021 5,000,000 4,994,937 99.87 4,993,589 4/13/2023 560 0.19% Prosperity Bank 0.20% 5/19/2021 10,006,741 10,006,741 100.00 10,006,741 5/19/2023 596 0.20% Veritex Community Bank 0.20% 6/1/2021 20,010,082 20,010,082 100.00 20,010,082 6/1/2023 609 0.20% Bank OZK 0.20% 6/9/2021 8,004,054 8,004,054 100.00 8,004.054 6/9/2023 617 0.20% R Bank 0.70% 7/6/2021 1,000,000 1,000,000 100.00 1,000,000 7/6/2023 644 0.70% Treasury 1.25% Aaa/AAA/AAA 7/7/2021 8,000,000 8,150,281 101,83 8.146,560 7/31/2023 669 0.22% Veritex Community Bank 0.25% 7/30/2021 7,000,000 7,000,000 100.00 7,000,000 7/31/2023 669 0.25% Dallas ISD 4.00% Aaa/AAA/AAA 4/22/2021 4,195,000 4,487,847 106.88 4,483,742 8/15/2023 684 0.26% Arlington TX HGR EDU 0.63% -/AAA/- 4/28/2021 1,460,000 1,460,000 100.12 1,461,767 8/15/2023 684 0.63% Veritex Community Bank 0,25% 8/23/2021 4,400,000 4,400,000 100.00 4,400.000 8/23/2023 692 0.25% Treasury0.25% Aaa/AAA/AAA 9/30/2021 10,000,000 9,990,820 99.92 9,992,188 9/30/2023 730 0.30% Sub Total I Average 0.53% 403,743,657 404,260,556 100.13 404,253,485 271 0.45% Fund 170-Interest&Sinking GO Bonds TexasDAILY 0.02% AAAm 4/30/2016 505,089 505,089 100.00 505,089 N/A 11 0.02% NexBank 040% 2/27/2017 1,291,409 1,291,409 100.00 1,291,409 N/A 1 0A0% TexPool 0.04% AAAm 9/30/2015 216,196 216,196 100.00 216,196 N/A 1 0.04% Sub Total/Average 0.27% 21012,694 21012,694 100.00 2,012,694 1 0.27% Fund 210-Interest&Sinking Debt Service JPMor an Chase 0.14% 1 9/30/2015 1 242,371 1 242,371 100.00 1 242,371 N/A 1 1 0.14% Sub Total/Average 0.14% 242,371 1 242,371 100.00 1 242,371 1 0.14% Fund 462-2017 Bond Fund TexPool 0.04% AAAm 5/30/2017 3,315,247 3,315,247 100.00 3,315,247 N/A 1 0.04% NexBank 0.40% 3/30/2020 1,609,677 1,609,677 100.00 1,609,677 N/A 1 0.40% East West Bank 0.26% 12/21/2020 6,012.150 6,012,150 100.00 6,012,150 12/21/2021 82 0.26% Sub Total/Average 0.21% 10,937,074 10,937,074 100.00 10,937 074 46 0.21% Fund 465-Road CO Bond Fund Texas Capital Bank 0.15% 6/1/2021 12,285,592 12,285,592 100.00 12,285,592 N/A 1 0.15% TexPool 0.04% AAAm 9/1/2020 439 439 100.00 439 N/A 1 0.04% Independent Bank 0.40% 12/7/2020 8,024,078 8,024,078 100.00 8,024,078 12/7/2021 68 0.40% Prosperity Bank 0.20% 7/6/2021 10,003,398 10,003,398 100.00 10,003,398 7/6/2022 279 0.20% Prosperity Bank 0.20% 6/1/2021 7,003,529 7,003,529 100.00 7,003,529 9/1/2022 336 0.20% Veritex Community Bank 0.30% 2/5/2021 5,608,334 1 5,608,334 100.00 5,608,334 2/6/2023 494 0.30% Sub Total/Average 0.24% 42,925,369 42 925,369 100.00 42,925,369 1971 0.24% Fund 591 -Reserves Fund TexPool 0.04% AAAm 9/30/2015 8,722 8,722 100.00 8,722 N/A 1 0.04% NexBank 0.40% 4/29/2019 857,453 857,453 100.00 857,453 N/A 1 0.40% Sub Total/Average 0.40% 866,175 866,175 100.00 866,175 1 0.40% Fund 602-Interest&Sinking Revenue Bonds TexPool 0.04% AAAm 9/30/2015 2,341605 2,343,605 100.00 2,343,605 N/A 1 0.04% Sub Total/Average 0.04% 2,343,605 2,343,605 100.00 2,343,605 1 0.04% 9 City of Round Rock Valley View Consulting,L.L.C. Holdings by Allocation and Portfolio Fund September 30, 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 605-Kalahari Debt Service Reserve TexPool 1 0.04% AAArn 1 8/30/2019 253,044 1 253,044 100.00 1 253,044 N/A 1 0.04% Sub Total/Average 1 0.04% 1 253,044 1 253,044 100.00 1 253,044 1 0.04% Fund 863-Drainage Utility Revenue Bond NexBank 1 0.40% 8/30/2020 216,183 216,183 100.00 216.183 N/A 1 0.40% TexPool 0.04% AAAm 10/31/2015 463,446 463,446 100.00 463,446 N/A 1 0.04% Sub Total/Avera a 0.15% 679,629 679,629 100.00 679,629 1 0.15% Total/Average 0.49% $ 464.003.618 $ 464.520,518 100.11 $ 464,513,446 255 0.42% 10 City of Round Rock Valley View Consulting,L.L.C. Book Value Comparison September 30, 2021 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 $ 24,799,782 $ 1,555,416 $ 6,209,343 $ 20,145,855 $ 4,653,927 TexPool N/A 9/30/2015 N/A 4,155,603 13,975,160 4,781,495 13,349,268 9,193,665 TexSTAR N/A 9/30/2015 N/A 200,522 5 - 200,527 5 TexasDAILY N/A 9/30/2015 N/A 13,048,238 5,000,201 13,000,000 5,048,440 7,999,799 TexasDAILY N/A 6/1/2021 N/A 8,198,794 310 6,400,000 1,799,103 61399,690 NexBank N/A 11/29/2016 N/A 35,955,901 135,915 - 36,091,817 135,915 Veritex Community Bank N/A 9/1/2020 N/A 79,329 96,572 - 175,902 96,572 Texas Capital Bank N/A 7/1/2021 N/A - 71724,273 - 7,724,273 7,724,273 Prosperity Bank N/A 9/14/2021 N/A - 13,000,855 - 13,000,855 13,000,855 Prosperity Bank N/A 9/14/2021 N/A - 2,000,132 - 2,000,132 2,000,132 BBVA 1_77% 10/3/2019 7/5/2021 5,149,180 - 5,149.180 - 5,149,180 Independent Bank 2.15% 7/22/2019 7/22/2021 5,191,262 - 5,191,262 - 5,191,262 R Bank 1.80% 1/27/2020 7/27/2021 2,045,484 - 2,045,484 - 2,045,484 Denton ISD 0.00% 12/17/2020 8/15/2021 499,803 - 500,000 - 499,803 East West Bank 1.64% 11/22/2019 8/23/2021 5,133,625 7,155 5,140,781 - 51133,625 State of TX Transportation 4,00% 9/2/2020 8/26/2021 9,053,507 - 9,000,000 - 9,053,507 BBVA 1,87% 8/27/2019 8/27/2021 3,104,603 4,775 3,109,379 - 3,104,603 Security State Bank&Trust 2,09% 9/5/2019 9/13/2021 7,259,589 25,318 7,284,907 - 7,259,589 Veritex Community Bank 1.71% 10/3/2019 10/4/2021 10,259,496 43,739 - 10,303,235 43,739 East West Bank 1.65% 1/27/2020 1 10/27/2021 6,142,986 25,601 - 6,168,587 25,601 East West Bank 1.54% 2/18/2020 11/19/2021 6,127,659 23,831 - 6,151,490 23,831 East West Bank 1,64% 11/22/2019 11/22/2021 5,133,625 21,264 - 5,154,890 21,264 Independent Bank 0 40% 12/7/2020 12/7/2021 8,015,964 8,082 - 8,024,046 81082 Veritex Community Bank 1.67% 12/20/2019 12/20/2021 5,126,681 21,580 - 5,148,261 21,580 Bank OZK 1.70% 1/28/2020 1/24/2022 8,194,950 35,186 - 8,230,136 35,186 R Bank 1.75% 1/27/2020 1/27/2022 2,044,206 8,938 - 2,053,145 8,938 Allegiance Bank 1 59% 2/10/2020 2/10/2022 5,099,694 20,438 - 5,120,132 20,438 Goose Creek ISD 5,00% 11/17/2020 2/15/2022 411,707 - - 407,024 4,683 East West Bank 1.54% 2/18/2020 2/18/2022 5,106,382 19,859 - 5,126,242 19,859 East West Bank 0,17% 2/19/2021 2/21/2022 11,091,600 4,754 - 11,096,354 4,754 FORT BEND COUNTY-REF 5.00% 6/17/2020 3/1/2022 256,662 - - 254,150 2,512 AIle iance Bank 0.40% 6/17/2020 3/18/2022 10,039,840 10,122 - 10,049,963 10,122 Independent Bank 0 40% 1/11/2021 4/11/2022 20,019,726 19,965 - 20,039,691 19,965 Veritex Community Bank 0,20% 2/5/2021 5/5/2022 3,001,463 1,513 - 3,002,976 1,513 Prosperity Bank 0 20% 2/12/2021 5/12/2022 4,002,631 2,018 - 4,004,649 2,018 Independent Bank 0 30% 5/19/2021 5/19/2022 6,000,000 4,537 - 6,004,537 4,537 Atle iance Bank 0 45% 6/17/2020 6/17/2022 12,053,794 13,672 - 12,067,466 13,672 Bank OZK 0,50% 7/9/2020 7/11/2022 10,045,986 12,666 - 10,058,652 12,666 Veritex Community Bank 0.24% 2/5/2021 8/5/2022 3,001,756 1,816 - 3,003,571 11816 Prosperity Bank 0.20% 2/12/2021 8/12/2022 3,001,973 1,514 - 3,003,487 1,514 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 560,000 Cityof Bryan TX 0.45% 11/19/2020 8/15/2022 500,000 - - 500,000 - Denton ISD 0.00% 12/17/2020 8/15/2022 497,409 - - 497,989 580 Cityof 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,000,000 1,513 - 31001,513 1,513 Veritex CommunityBank 0,18% 3/5/2021 9/5/2022 8,003,630 3,631 - 8,007,261 3,631 State of Texas 1.61% 3/19/2021 10/1/2022 3,309,460 - - 3,297,516 11,944 Prosperity Bank 0,40% 10/15/2020 10/17/2022 6,015,983 6,067 - 6,022,050 6,067 Veritex Community Bank 0.26% 2/5/2021 11/4/2022 3,001,902 1,967 - 3,003,869 1,967 Prosperity Bank 0,20% 1 2/12/2021 11/14/2022 3,001,973 1,514 - 3,003,487 1,514 Bank OZK 0 28% 1 12/7/2020 12/7/2022 1 5.007.010 3,547 - 5,010,557 3,547 11 City of Round Rock Valley View Consulting, L.L.C. Book Value Comparison September 30, 2021 Coupon Settlement Maturity Beginning Book Total Buys/ Total Sells/ Ending Book Change in Book Issuer Rate Date Date Value Increases Decreases Value Value Prosperity Bank 0 20% 6/9/2021 12/9/2022 10,000,000 51042 - 10,005.042 5,042 Veritex Community Bank 0,28% 1/6/2021 1/6/2023 4,002,762 2,794 - 4,005,556 2,794 R Bank 0 57% 7/6/2021 1/6/2023 - 1.000,000 - 1,000,000 1,000.000 Veritex Community Bank 0.30% 2/5/2021 2/6/2023 4,403,219 31330 - 4,406,548 3,330 Eagle Pass Texas 4.00% 6/7/2021 3/1/2023 685,841 - - 679,671 6,170 Prosperity Trosperity Bank 0,25% 3/5/2021 3/6/2023 10,006,303 6,307 - 10,012,609 6,307 Bank OZK 0 26% 3/8/2021 3/8/2023 2,530,751 1,665 - 2,532,416 1,665 Federal Farm Credit Bank 0.13% 3/26/2021 3/23/2023 8,996,094 - - 8,996,664 569 Prosperity Bank 0,20% 4/12/2021 4/12/2023 5,001,671 2,522 - 5.004,193 2,522 FFCB 0,13% 4/13/2021 4/13/2023 4,994,105 - - 4,994,937 832 Prosperity Bank 0 200% 5/19/2021 5/19/2023 10,001,699 5,043 - 10,006,741 5,043 Veritex Community Bank 0.20% 6/1/2021 6/1/2023 1 20,000,000 10,082 - 20,010,082 10,082 Bank OZK 0,20% 6/9/2021 6/9/2023 8,000,000 4,054 - 81004,054 4,054 R Bank 0.70% 7/6/2021 7/6/2023 - 1,000,000 - 1,000,000 1,000,000 Treasury 1.25% 7/7/2021 7/31/2023 - 8,212,745 - 81150,281 8,150,281 Vertex Community Bank 0,25% 7/30/2021 7/31/2023 - 7,000,000 - 71000,000 7,000,000 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,527,235 - - 4,487,847 39,389 Veritex Community Bank 0,25% 8/23/2021 8/23/2023 - 4,400,000 - 4,400,000 4,400,000 Treasury 0,25% 9/30/2021 1 9/30/2023 1 - 82 9,990,820 - 9,990,820 9,990, 0 Sub Total/Average Fund 000-Pooled Investments 1 1 396,201,052 76,049,825 67,811,830 404,260,556 8,059,505 Fund 170-Interest&Sinking GO Bonds TexPool N/A 9/30/2015 N/A 1,560,020 50 1,343,874 216,196 1,343,824 TexasDAILY N/A 4/30/2016 N/A 3,755,865 71006,844 10,257,620 505,089 3,250,776 NexBank N/A 2/27/2017 N/A 1,290,108 11301 - 1,291,409 1,301 East West Bank 0,19% 1/7/2021 7/7/2021 7,006,380 - 7,006,380 - 7,006,380 Prosperity Trosperity Bank 0.159% 2/5/2021 8/5/2021 2,501,233 308 2,501.541 - 2,501,233 Prosperity Bank 0.15% 2/12/2021 8/12/2021 4,001,973 493 4,002.466 - 4,001,973 Sub Total/Average Fund 170-Interest&Sinking GO Bonds 20,115,578 7,008,997 1 25,111,881 2,012,694 18,102,884 Fund 210-Interest&Sinking Debt Service JPMor an Chase N/A 9/30/2015 N/A 1 3.575 455 993 1 217.197 242.371 1 238,796 Sub Total/Average Fund 210-Interest&Sinking Debt Service 1 3,575 455,993 217,197 242,371 1 238,796 Fund 450-Kalahari Project Bonds TexPool N/A 5/30/2021 N/A 4,254 - 4.254 - 4,254 Sub Total/Average Fund 450-Kalahari Project Bonds 4,254 - 4,254 - 4,254 Fund 462-2017 Bond Fund TexPool N/A 5/30/2017 N/A 10,560 3.304,687 - 3,315,247 31304,687 NexBank N/A 3/30/2020 N/A 1,608,055 1,622 - 1,609,677 1,622 East West Bank 0 33% 10/13/2020 7/13/2021 11102,599 - 1,102,599 - 1,102,599 Tity of Austin GO 0.17% 10/6/2020 9/1/2021 2,200,000 - 2,200,000 - 2,200,000 East West Bank 0.26% 12/21/2020 12/21/2021 6,008,212 3,939 - 6,012 150 3,939 Sub Total/Average Fund 462-2017 Bond Fund 10,929,425 3,310,248 3,302,599 10,937,074 7,649 Fund 465-Road CO Bond Fund TexPool N/A 9/1/2020 N/A 12,710,378 61 12,710,000 439 12,709,939 NexBank N/A 6/28/2019 N/A 99,548 - 99,548 - 99,548 Veritex Community Bank N/A 6/19/2020 N/A 96,537 - 96,537 - 96,537 Texas Capital Bank N/A 6/1/2021 N/A 20,002,301 6,164 7,722,873 12,285,592 7,716,709 Independent Bank 0 40% 12/7/2020 12/7/2021 8,015,996 8,082 - 8,024,078 8,082 Prosperity Bank 0.20% 7/6/2021 7/6/2022 - 101003,398 - 10,003,398 10,003,398 Pros erit Bank 1 020% 1 6/1/2021 1 9/1/2022 1 7,000,000 1 3,529 1 7,003,529 3,529 12 City of Round Rock Valley View Consulting, L.L.C. Book Value Comparison September 30, 2021 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,604,096 4.238 — 5,608,334 4,238 Sub Total/Average Fund 465-Road CO Bond Fund 53,528,855 10,025,471 20,628,957 42,925,369 10,603,486 Fund 591 -Reserves Fund TexPool N/A 9/30/2015 N/A 8,722 1 8,722 1 8,722 1 8 722 1 1 NexBank N/A 4/29/2019 N/A 856,589 864 - 1 857,453 864 Sub Total/Average Fund 591 -Reserves Fund 865,310 9,586 8,722 1 866,175 865 Fund 602-Interest&Sinking Revenue Bonds TexPool N/A 9/30/2015 N/A 8,110,270 297 5,766,962 2,343,605 5.766,665 Sub Total/Average Fund 602-Interest&Sinking Revenue Bonds 8,110,270 297 5,766,962 1 2,343,605 5,766,665 Fund 605-Kalahari Debt Service Reserve TexPool N/A 8/30/2019 N/A 358,957 17 105,930 1 253.044 105,913 Sub Total/Average Fund 605-Kalahari Debt Service Reserve 358,957 17 105,930 253,044 105,913 Fund 863-Drainage Utility Revenue Bond TexPool N/A 10/31/2015 N/A 577,164 28 113.747 j 463,446 113,719 NexBank N/A 8/30/2020 N/A 215,965 218 — 216,183 218 Sub Total/Avera a Fund 863-Draina a Utilit Revenue Bond 793,130 246 113,747 679,629 113,501 Total/Average $ 490,910,406 $ 96,860,680 $ 123,072,078 $ 464,520,518 $ 26,389,889 13 City of Round Rock Valley View Consulting, L.L.C. Market Value Comparison September 30, 2021 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 $ 24,799,782 $ 1,555,416 $ 6,209,343 $ 20,145,855 $ - TexPool N/A 9/30/2015 N/A 4,155,603 13,975,160 4,781,495 13,349,268 - TexSTAR N/A 9/30/2015 N/A 200,522 5 - 200,527 - TexasDAILY N/A 9/30/2015 N/A 13,048,238 5,000,201 13,000,000 5,048,440 - TexasDAILY N/A 6/1/2021 N/A 8,198,794 310 6,400,000 1,799,103 - NexBank N/A 11/29/2016 N/A 35,955,901 135,915 - 36,091,817 - Ventex Community Bank N/A 9/1/2020 N/A 79,329 96,572 - 175,902 - Texas Capital Bank N/A 7/1/2021 N/A - 7,724,273 - 7,724,273 - Prosperity Bank N/A 9/14/2021 N/A - 13,000,855 - 13,000,855 - Prosperity Bank N/A 9/14/2021 N/A - 2,000,132 - 2,000,132 - BBVA 1,77% 10/3/2019 7/5/2021 5,149,180 - 5,149,180 - - Inde endent Bank 2,15% 7/22/2019 7/22/2021 5,191,262 - 5,191,262 - - R Bank 1 80% 1/27/2020 7/27/2021 2,045,484 - 2,045,484 - - Denton ISD 0.00% 12/17/2020 8/15/2021 499,820 - 500,000 - 180 East West Bank 1.64% 11/22/2019 8/23/2021 5,133,625 7,155 5,140,781 - - State of TX Transportation 4.00% 9/2/2020 8/26/2021 9,054,000 - 9,000,000 - 541000 BBVA 1.87% 8/27/2019 8/27/2021 3,104,603 4,775 3,109,379 - - Security State Bank&Trust 2.09% 9/5/2019 9/13/2021 7,259,589 25,318 7,284,907 - - Ventex Community Bank 1,71% 10/3/2019 10/4/2021 10,259,496 43,739 - 10.303,235 - East West Bank 1.65% 1/27/2020 10/27/2021 6,142,986 25,601 - 6,168,587 - East West Bank 1.54% 2/18/2020 11/19/2021 6,127,659 23,831 - 6.151,490 - East West Bank 1.64% 11/22/2019 11/22/2021 5,133,625 21,264 - 5,154,890 - Independent Bank 0.40% 12/7/2020 12/7/2021 8,015,964 8,082 - 8,024,046 - Veritex Community Bank 1.67% 12/20/2019 12/20/2021 5,126,681 21,580 - 5,148,261 - Bank OZK 1.70% 1/28/2020 1/24/2022 81194,950 35,186 - 8,230,136 - R Bank 1,75% 1/27/2020 1/27/2022 2,044,206 8,938 - 2,053,145 - Allegiance Bank 159% 2/10/2020 2/10/2022 5,099,694 20,438 - 5,120,132 - Goose Creek ISD 5 00% 11/17/2020 2/15/2022 412,040 - - 407,100 41940 East West Bank 1 54% 2/18/2020 2/18/2022 51106,382 19,859 - 51126,242 - East West Bank 0.17% 2/19/2021 2/21/2022 11,091,600 4,754 - 11,096,354 - FORT BEND COUNTY-REF 5 00% 6/17/2020 3/1/2022 258,083 - - 254,978 31105 Allegiance Bank 040% 6/17/2020 3/18/2022 10,039,840 10,122 - 10,049,963 - Independent Bank 0 40% 1/11/2021 4/11/2022 20,019,726 19,965 - 20,039,691 - Veritex Communit Bank 0 20% 2/5/2021 5/5/2022 3,001,463 1,513 - 3,002,976 - Prosperity Bank 0,20% 2/12/2021 5/12/2022 41002,631 2,018 - 4,004,649 - Independent Bank 0,30% 5/19/2021 5/19/2022 6,000,000 4,537 - 6,004,537 - Allegiance Bank 0 45% 6/17/2020 6/17/2022 12,053,794 13,672 - 12,067,466 - Bank OZK 0.50% 7/9/2020 7/11/2022 10,045,986 12,666 - 10,058,652 - Veritex Community Bank 0.241/. 2/5/2021 8/5/2022 3,001,756 1,816 - 3,003,571 - Prosperity Bank 0.20% 2/12/2021 8/12/2022 31001,973 1,514 - 3,003,487 - Arlin ton TX HGR EDU 0.50% 4/28/2021 8/15/2022 1 500,615 - - 500,535 80 Bexar Co Txb Ref 0.33% 9/23/2021 8/15/2022 - 560,000 - 559,636 364 City of Bryan TX 0 45% 11/19/2020 8/15/2022 500,775 - - 500,660 115 Denton ISD 0.00% 12/17/2020 8/15/2022 497,935 - - 498,465 530 Tity of Austin GO 0 270% 10/6/2020 9/1/2022 701,092 - - 701,078 14 Prosperity Bank 0 20% 6/1/2021 9/1/2022 3,000,000 1,513 - 3,001,513 - Ventex Community Bank 0.18% 3/5/2021 9/5/2022 81003,630 3,631 - 8,007,261 - State of Texas 1.61% 3/19/2021 10/1/2022 31307,428 - - 3,297,873 9,555 Prosperity Bank 0 40% 10/15/2020 10/17/2022 6,015,983 6,067 - 6,022,050 - Veritex Community Bank 0.26% 2/5/2021 11/4/2022 3,001,902 1,967 - 3,003,869 - Trosperity Bank 0.20% 2/12/2021 11/14/2022 1 3,001,973 1,514 - 3,003,487 - Bank OZK 0.28% 12/7/2020 12/7/2022 5,007,010 3,547 - 5,010,557 - 14 City of Round Rock Valley View Consulting, L.L.C. Market Value Comparison September 30, 2021 Coupon Settlement Maturity Beginning Total Buys/ Total Sells/ Ending Market Change in Issuer Rate Date Date Market Value Increases Decreases Value Market Value Prosperity Bank 0,20% 6/9/2021 12/9/2022 10,000.000 5,042 - 10,005,042 - Ventex Community Bank 0 28% 1/6/2021 1/6/2023 4,002,762 2,794 - 4,005,556 - R Bank 0,57% 7/6/2021 1/6/2023 - 1,000,000 - 1,000,000 - Veritex Community Bank 0,30% 2/5/2021 2/6/2023 1 4,403,219 3,330 - 4,406,548 - Ea le Pass Texas 4,00% 6/7/2021 3/1/2023 1 685,293 - - 678,830 6,463 Prosperity Bank 0.25% 3/5/2021 3/6/2023 1 10,006,303 6,307 - 10,012,609 - Bank OZK 0,26% 3/8/2021 3/8/2023 1 2,530,751 1,665 - 2,532,416 - Federal Farm Credit Bank 0,13% 3/26/2021 3/23/2023 1 8,984,139 - - 8,992,829 8,690 Prosperity Bank 0 20% 4/12/2021 4/12/2023 5,001,671 2,522 - 5,004.193 - FFCB 0,13% 4/13/2021 4/13/2023 4,986,216 - - 4,993,589 7,373 Pros erit Bank 0,20% 5/19/2021 5/19/2023 10,001,699 51043 - 10,006,741 - Ventex Community Bank 0,20% 6/1/2021 6/1/2023 20,000,000 10,082 - 201010,082 - Bank OZK 0,20% 6/9/2021 6/9/2023 8,000,000 4,054 - 8,004,054 - R Bank 0.70% 7/6/2021 7/6/2023 - 1,000,000 - 1,000,000 - Treasury 1.25% 7/7/2021 7/31/2023 - 8,212,745 - 8,146,560 22,815 Veritex Community Bank 0.25% 7/30/2021 7/31/2023 - 7,000,000 - 7,000,000 - Arlington TX HGR EDU 0.63% 4/28/2021 8/15/2023 1,461,445 - - 1,461,767 321 Dallas ISD 4,00% 4/22/2021 8/15/2023 4,521,455 - - 4,483,742 37,713 Veritex CommunityBank 0 25% 8/23/2021 8/23/2023 - 4.400,000 - 4,400,000 - Treasury0.25% 9/30/2021 9/30/2023 - 9,990,820 - 91992,188 1,368 Sub Total/Average Fund 000-Pooled Investments 396,179,563 76,049,825 67,811,830 404,253,485 120,703 Fund 170-Interest&Sinking GO Bonds TexPool N/A 9/30/2015 N/A 1 1,560,020 50 1,343,874 216,196 - TexasDAILY N/A 4/30/2016 N/A 1 3,755,865 7,006,844 10,257,620 505,089 - NexBank N/A 2/27/2017 N/A 1,290,108 1,301 - 11291,409 - East West Bank 0 19% 1/7/2021 7/7/2021 7,006,380 - 7,006,380 -Prosperity Bank 015% 2/5/2021 8/5/2021 2,501,233 308 2,501,541 - - Trospenty Bank 0,15% 2/12/2021 8/12/2021 4,001,973 493 4,002,466 - - Sub Total/Average Fund 170-Interest&Sinking GO Bonds 20,115,578 7,008,997 25,111,881 2,012,694 - Fund 210-Interest&Sinking Debt Service JPMor an Chase N/A 9/30/2015 N/A 1 3.575 1 455.993 217 197 242 371 - Sub Total/Average Fund 210-Interest&Sinking Debt Service 1 3,575 1 455,993 217,197 242,371 - Fund 450-Kalahari Project Bonds TexPool N/A 5/30/2021 N/A 4,254 - 4,254 - - Sub TotallAvera a Fund 450-Kalahari Project Bonds 4,254 - 4,254 - - Fund 462-2017 Bond Fund TexPool N/A 5/30/2017 N/A 10,560 31304,687 - 3,315,247 - NexBank N/A 3/30/2020 N/A 1,608,055 1,622 - 1,609,677 - East West Bank 0 33% 10/13/2020 7/13/2021 1,102,599 - 1,102,599 - - City of Austin GO 0.17% 10/6/2020 9/1/2021 2,200,308 - 2,200,000 - 308 East West Bank 0.26% 12/21/2020 12/21/2021 6,008,212 3,939 - 6.012.150 - Sub Total/Average Fund 462-2017 Bond Fund 10,929,733 3,310,248 3,302,599 10,937,074 308 Fund 465-Road CO Bond Fund TexPool N/A 9/1/2020 N/A 12,710,378 61 12,710,000 439 - NexBank N/A 6/28/2019 N/A 99,548 - 99,548 - - Ventex Community Bank N/A 6/19/2020 N/A 96,537 - 96,537 - - Texas Capital Bank N/A 6/1/2021 N/A 20,002,301 6,164 7,722,873 12,285,592 Independent Bank 0,40% 12/7/2020 12/7/2021 8,015,996 8,082 - 8,024,078'Prosperity Bank 0 20% 7/6/2021 7/6/2022 - 10,003,398 - 10,003,398 Prosperity Bank 1 0.20% 1 6/1/2021 1 9/1/2022 7,000,000 1 3,529 - 7,003,529 - 15 City of Round Rock Valley View Consulting, L.L.C. Market Value Comparison September 30, 2021 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,604,096 4,238 - 5.608,334 - Sub Total/Average Fund 465-Road CO Bond Fund 53,528,855 10,025,471 20,628,957 42,925,369 - Fund 591 -Reserves Fund TexPool N/A 9/30/2015 N/A---7 8,722 1 8,722 1 8.722 8,722 - NexBank N/A 4/29/2019 N/A 856,589 864 - 1 857 453 - Sub Total/Average Fund 591 -Reserves Fund 865,310 9,586 8,722 866,175 - Fund 602-Interest&Sinking Revenue Bonds TexPool N/A 9/30/2015 N/A 8,110,270 297 5,766,962 2,343,605 - Sub Total/Average Fund 602-Interest&Sinking Revenue Bonds 8,110,270 297 5,766,962 2,343,605 1 - Fund 605-Kalahari Debt Service Reserve TexPool N/A 8/30/2019 N/A 358,957 17 105.930 253,044 1 - Sub Total/Average Fund 605-Kalahari Debt Service Reserve 1 358,957 17 105,930 253,044 - Fund 863-Drainage Utility Revenue Bond TexPool N/A 10/31/2015 N/A 577,164 28 113,747 463.446 - NexBank N/A 8/30/2020 N/A 215,965 218 - 216.183 - Sub Total/Average Fund 863-Drainage Utility Revenue Bond 793,130 246 113,747 679,629 - Total/Average $ 490,889,226 $ 96,860,680 $ 123,072,078 $ 464,513,446 $ 121,011 16 City of Round Rock Valley View Consulting, L.L.C. Holdings by Allocation and Portfolio Fund June 30, 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.45% 11/29/2016 $ 35,955,901 $ 35,955,901 100.00 $ 35,955,901 N/A 1 0.45% TexasDAILY 0.03% AAAm 6/1/2021 8,198,794 8,198,794 100.00 8,198,794 N/A 1 0.03% Veritex Community Bank 0,08% 9/1/2020 79,329 79,329 100.00 79.329 N/A 1 0.08% JPMor an Chase 0.15% 9/30/2015 24,799,782 24,799,782 100.00 24,799,782 N/A 1 0.15% TexSTAR 0.01% AAAm 9/30/2015 200,522 200,522 100,00 200,522 N/A 1 001% TexPool 0.01% AAAm 9/30/2015 4,155,603 4,155,603 100.00 4,155,603 N/A 1 0.01% TexasDAILY 0.03% AAAm 9/30/2015 13,048,238 13,048,238 100.00 13,048,238 N/A 11 0.03% BBVA 1.77% 10/3/2019 5,149,180 5,149,180 100.00 5,149,180 7/5/2021 51 1.77% Independent Bank 2.15% 7/22/2019 5,191,262 5,191,262 10&00 5,191,262 7/22/2021 22 2.15% R Bank 1.80% 1/27/2020 2.045,484 2,045,484 100.00 2,045,484 7/27/2021 27 1.80% Denton ISD 0.00% -/AAA/AAA 12/17/2020 500,000 499,803 99.96 499,820 8/15/2021 46 0.31% East West Bank 1.64% 11/22/2019 5,133,625 5,133,625 100.00 5,133,625 8/23/2021 54 1.64% State of TX Transportation 4.00% MIG1/SP1+/F1+ 9/2/2020 9,000,000 9,053,507 100.60 1 9,054,000 8/26/2021 57 0.20% BBVA 1.87% 8/27/2019 3,104,603 3,104,603 100.00 3,104,603 8/27/2021 58 1.87% Security State Bank&Trust 2.09% 9/5/2019 7,259,589 7,259,589 100.00 7,259,589 9/13/2021 751 2.09% Veritex Community Bank 1.71% 10/3/2019 10,259,496 10,259,496 100.00 10,259,496 10/4/2021 961 1.71% East West Bank 1.65% 1/27/2020 6,142,986 6,142,986 100.00 6,142,986 10/27/2021 119 1.65% East West Bank 1.54% 2/18/2020 6,127,659 6,127,659 100.00 6,127,659 11/19/2021 142 1.54% East West Bank 1.64% 11/22/2019 5,133,625 5,133,625 100,00 5,133,625 11/22/2021 145 1.64% Inde endent Bank 0.40% 12/7/2020 8,015.964 8,015,964 100.00 8,015,964 12/7/2021 160 0.40% Veritex Community Bank 1.67% 12/20/2019 5,126,681 5,126,681 100.00 5,126,681 12/20/2021 173 1_67% Bank OZK 1.70% 1/28/2020 8,194,950 8,194,950 100.00 8,194,950 1/24/2022 208 1.70% R Bank 1.75% 1/27/2020 2,044.206 2,044,206 100.00 2.044,206 1/27/2022 211 1.75% Allegiance Bank 1.59% 2/10/2020 5,099,694 5,099,694 100.00 5,099,694 2/10/2022 2251 1.59% Goose Creek ISD 5.00% Aaa/-/AAA 11/17/2020 400,000 411,707 103.01 412,040 2/15/2022 230 0.33% East West Bank 1_54% 2/18/2020 5,106,382 5,106,382 100.00 5,106,382 2/18/2022 233 1_54% East West Bank 0.17% 2/19/2021 11,091,600 11,091.600 100.00 11,091,600 2/21/2022 236 0.17% FORT BEND COUNTY-REF 5.00% Aa1/-/AA+ 6/17/2020 250,000 256,662 103.23 258,083 3/1/2022 244 0.98% Allegiance Bank 0.40% 6/17/2020 10,039,840 10,039,840 100.00 10,039,840 3/18/2022 261 0.40% Independent Bank 0.40% 1/11/2021 20,019,726 20,019,726 100.00 20,019,726 4/11/2022 285 0.40% Veritex Community Bank 0.20% 2/5/2021 3,001,463 3,001,463 100.00 3,001,463 5/5/2022 309 0.20% Prosperity Bank 0,20% 2/12/2021 4,002,631 4,002,631 100.00 4,002,631 5/12/2022 316 0.20% Independent Bank 0.30% 5/19/2021 6,000,000 6,000,000 100.00 6,000,000 5/19/2022 323 0.30% Allegiance Bank 0.45% 6/17/2020 12,053,794 12,053,794 100.00 12,053,794 6/17/2022 352 0.45% Bank OZK 0.50% 7/9/2020 10,045,986 10,045,986 100.00 10,045,986 7/11/2022 376 0.50% Veritex Community Bank 0.24% 2/5/2021 3,001,756 3,001,756 100.00 3,001,756 8/5/2022 401 0.24% Prosperity Bank 0.20% 2/12/2021 3,001,973 3,001,973 10000 3,001,973 8/12/2022 408 0.20% Arlington TX HGR EDU 0.50% -/AAA/- 4/28/2021 500,000 500,000 100.12 500,615 8/15/2022 4111 0.50% Denton ISD 0.00% -/AAA/AAA 12/17/2020 500,000 497,409 99.59 497,935 8/15/2022 411 0,46% City of Bryan TX 0.45% -/AA/- 11/19/2020 500,000 500,000 100.16 500,775 8/15/2022 411 0.45% City of Austin GO 0.27% Aa1/AAA/AAA 10/6/2020 700,000 700,000 100.16 701,092 9/1/2022 428 0.27% Prosperity Bank 0.20% 6/1/2021 3,000,000 3,000,000 100.00 3,000,000 9/1/2022 428 0.20% Veritex Community Bank 0.18% 3/5/2021 8,003,630 8,003,630 100.00 8,003,630 9/5/2022 432 0.18% State of Texas 1.61% Aaa/AAA/- 3/19/2021 3,250,000 3,309,460 101.77 3,307,428 10/1/2022 458 0.15% Prosperity Bank 0.40% 10/15/2020 6,015,983 6,015,983 100.00 6,015,983 10/17/2022 474 0.40% Veritex Community Bank 0.26% 2/5/2021 3,001,902 3,001,902 100.00 3,001,902 11/4/2022 492 0.26% Prosperity Bank 0.20% 2/12/2021 3,001,973 3,001,973 100.00 3,001,973 11/14/2022 502 0.20% Bank OZK 0.28% 12/7/2020 5,007,010 5,007,010 100,00 5,007,010 12/7/2022 525 0.28% 17 City of Round Rock Valley View Consulting, L.L.C. Holdings by Allocation and Portfolio Fund June 30, 2021 Coupon Settlement Face Amount/ Market Days to YTM @ Issuer Rate Credit Rating Date Shares Book Value Price Market Value Maturity Date Maturity Book Prosperity Bank 0.20% 6/9/2021 10,000,000 10,000,000 100.00 10,000,000 12/9/2022 527 0.20% Veritex Community Bank 0.28% 1/6/2021 4,002,762 4,002,762 100.00 4,002,762 1/6/2023 555 0.28% Veritex Community Bank 0.30% 2/5/2021 4,403,219 4,403,219 100.00 4,403,219 2/6/2023 586 0.30% Eagle Pass Texas 4.00% -/AA-/- 6/7/2021 645,000 685,841 106.25 685,293 3/1/2023 609 0.20% Prosperity Bank 0.25% 3/5/2021 10,006,303 10,006,303 100.00 10,006,303 3/6/2023 614 0.25% Bank OZK 0.26% 3/8/2021 2,530,751 2,530,751 100.00 2,530,751 3/8/2023 616 0.26% Federal Farm Credit Bank 0.13% Aaa/AA+/AAA 3/26/2021 9,000,000 8,996,094 99.82 8,984,139 3/23/2023 631 0.15% Prosperity Bank 0.20% 4/12/2021 5,001,671 5,001,671 100.00 5,001,671 4/12/2023 651 0.20% FFCB 0.13% Aaa/AA+/AAA 4/13/2021 1 5,000,000 4,994,105 99.72 4,986,216 4/13/2023 652 0.19% Prosperity Bank 0.20% 5/19/2021 10,001,699 10,001,699 100.00 10,001,699 5/19/2023 688 0.20% Veritex Community Bank 0.20% 6/1/2021 20,000,000 20,000,000 100.00 20,000,000 6/1/2023 701 0.20% Bank OZK 0.20% 6/9/2021 8,000,000 8,000,000 100.00 8,000,000 6/9/2023 709 0.20% Dallas ISD 4.00% Aaa/AAA/AAA 4/22/2021 4,195,000 4,527135 10778 4,521,455 8/15/2023 776 0.26% Arlington TX HGR EDU 0.63% -/AAA/- 4/28/2021 1,460,000 1,460.000 100.10 1,461,445 8/15/2023 776 0.63% Sub Total/Average 0.72% 395,709,228 i96,201,052 1 100.12 396,179,563 2891 0.57% Fund 170-Interest&Sinking GO Bonds TexasDAILY 0.03% AAAm 4/30/2016 3,755,865 3,755,865 100.00 3,755,865 N/A 1 0.03% NexBank 0.45% 2/27/2017 1,290,108 1,290,108 100.00 1,290,108 N/A 1 0.45% TexPool 0.01% AAAm 9/30/2015 1,560,020 1,560,020 10000 1,560,020 N/A 1 0,01% East West Bank 0.19% 1/7/2021 7,006,380 7,006,380 100.00 7,006,380 7/7/2021 7 0.19% Prosperity Bank 0.15% 2/5/2021 2,501,233 2.501.233 100.00 2,501,233 8/5/2021 36 0.15% Prosperity Bank 0.15% 2/12/2021 4,001,973 4,001,973 100.00 4,001,973 8/12/2021 431 0.15% Sub Total/Avera a 10.15% 1 1 20,115,578 20,115 578 100.00 20,115,578 161 0.15% Fund 210-Interest&Sinking Debt Service JPMor an Chase 1 0 15% 1 9/30/2015 1 3,575 3,575 100.00 3,575 N/A 11 0.15% Sub Total/Average 1 0.15% 1 3,575 3,575 100.00 3,575 1 11 0.15% Fund 450-Kalahari Project Bonds TexPool 0,01% AAAm 5/30/2021 1 4,254 4,254 100.00 4,254 1 N/A 11 0.01% Sub Total/Average 0.01% 1 4,254 4,254 100.00 4,254 1 11 0.01% Fund 462-2017 Bond Fund TexPool 0.01% AAAm 5/30/2017 10,560 10.560 100.00 10,560 N/A 1 0.01% NexBank 0.45% 3/30/2020 1,608,055 1,608,055 100.00 1,608,055 N/A 1 0.45% East West Bank 0.33% 10/13/2020 1,102,599 1,102,599 100.00 1,102,599 7/13/2021 13 0.33% City of Austin GO 0.17% Aa1/AAA/AAA 10/6/2020 2,200,000 2,200,000 100.01 2,200,308 9/1/2021 63 0.17% East West Bank 0.26% 12/21/2020 6,008,212 6,008,212 100,00 6,008,212 12/21/2021 174 0.26% Sub Total/Average 0.28% 10,929,425 10,929 425 100.00 10,929,733 110 0.28% Fund 465-Road CO Bond Fund NexBank 0.45% 6/28/2019 99,548 99,548 100.00 99,548 N/A 1 0.45% Texas Capital Bank 0.15% 6/1/2021 20,002,301 20,002,301 100.00 20,002,301 N/A 1 0.15% TexPool 0.01% AAAm 9/1/2020 12,710,378 12,710,378 100.00 12,710,378 N/A 1 0.01% Veritex Community Bank 0,08% 6/19/2020 96,537 96,537 100.00 96,537 N/A 1 0.08% Independent Bank 0.40% 12/7/2020 8,015,996 8,015,996 100.00 8,015,996 12/7/2021 160 0.40% Prosperity Bank 0.20% 6/1/2021 7,000,000 7,000,000 100.00 7,000.000 9/1/2022 428 0.20% Veritex Community Bank 0.30% 1 1 2/5/2021 1 5,604,096 5,604,096 1 100.00 5,604,096 2/6/2023 5861 0.30% Sub Total/Average 0.18% 1 1 53,528,855 53 528,855 1 100.00 53,528,855 1 1421 0.18% 18 City of Round Rock Valley View Consulting, L.L.C. Holdings by Allocation and Portfolio Fund June 30, 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 591 -Reserves Fund TexPool a01% AAArn 1 9/30/2015 1 8,722 1 8,722 1 10000 1 8,722 1 N/A 1 0.01% NexBank 0.45% 4/29/2019 856,589 856,589 100.00 856,589 N/A 1 0.45% Sub Total/Average 1 0.45% 865,310 865,310 100.00 865,310 1 0.45% Fund 602-Interest&Sinking Revenue Bonds TexPool 1 0.01% AAAm 9/30/2015 8,110.270 8,110,270 10000 8.110,270 N/A 1 0 01% Sub Total/Average 1 0.01% 8,110,270 8,110 270 100.00 8,110 270 1 0.01% Fund 605-Kalahari Debt Service Reserve TexPool a01% AAAm 8/30/2019 358,957 358,957 100.00 358,957 N/A 1 0.01% Sub Total/Average 0.01% 358,957 358,957 100.00 358,957 1 0.01% Fund 863-Drainage Utility Revenue Bond NexBank 0.45% 8/30/2020 215,965 215,965 1 100.00 1 215,965 N/A 1 0.45% TexPool 0.01% AAArn 1 10/31/2015 577,164 577,164 100 00 577,164 N/A 1 0.01% Sub Total/Average 0.13% 793,130 793,130 100.00 793,130 1 0.13% Total/Average 0.61% 1 $ 490,418,582 $ 490,910,406 100.10 $ 490,889,226 252 0.49% City of Round Rock Valley View Consulting, L.L.C.