Loading...
R-2021-210 - 8/12/2021RESOLUTION NO. R-2021-210 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 June 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 5 51, Texas Government Code, as amended. RESOLVED this 12th day of August, 2021. /\4ayor City of kound Ro ,Texas ATTEST: SARA L. WHITE, City Clerk 0112.20212, 004781 15 EXHIBIT ` ` A'P'p X TEXAS QUARTERLY INVESTMENT REPORT For the Quarter Ended June 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 Investment Policy and Strategies. Signatures withheld for security purposes Signatures withheld for security purposes Chief Financial Officer Controller Signatures withheld for security purposes Treasury 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. Summary Holdings by Investment Category (Security Sector) June 30, 2021 Description YTM @ Cost Book Value Market Value Cash 0.15% $ 24,803,357 $ 2418031357 Certificates of Deposit 0.66% 31416111546 31416111546 Local Government Investment Pool 0.02% 52,699,346 5216991346 Money Market Accounts 0.35% 60,204,332 60,204,332 Municipal 0.26% 2416011625 241600,288 USAgency 0.17% 1319901199 13,970,355 Total I Average Os49% $ 4909910,406 1 $ 490,889g2261 March 31, 2021 Description nM � Cost Book Value Market Value Cash 0.15% $ 191839,745 $ 1918391745 Certificates of Deposit 0.89% 3051751,947 30517517947 Local Government Investment Pool 0.04% 13,621,334 13,621,334 Money Market Accounts 0.45% 4011571116 4011571116 Municipal 0.35% 2114881713 211502,579 USAgency 0.15% 81995,531 819841873 Total I Average 014% $ 40918541387 $ 409,8579594 Total Portfolio TexPool Yield Rolling Three Mo. Treas. Yield Rolling Six Mo. Treas. Yield Rolling 1 Yr. Treas. Yield Rolling 2 Yr. Treas. Yield Interest Income (Approximate) Total Portfolio Pooled Funds Average Yield Current Fiscal Year - .Quarter (1) to -Date (2) Om49% 016% 0.01% 0.04% 0.03% 0.06% 0.06% 0.08% 0.10% 0.20% 0.64% 0.89% Investment Income (3) 667,955 $ 216241346 WAM at 6/30/2021 252 days 289 days Policy WAM Max 540 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/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. First Quarter GDP posted +6.4% (Final). In June, Payrolls added 850k and Unemployment (U2) rose slightly to 5.9%. Crude oil traded up to +/-$75 per barrel. The Stock Markets reached new highs. Housing, Industrial Production, Durable Goods, Consumer Spending, and other indicators moderated and showed signs of strain. The Biden administration and Congress continue to negotiate an infrastructure package. Inflation surged over the FOMC 2+% target, but is considered to be temporary. The Yield Curve "humped" slightly in the two -to -three year maturity sector while the long end fell. 2.00 Treasury Yield Curves S&P 500 4, 750 4,500 1.80 - 4,250 4,000 1.60 3,750 1.40 3,500 3,250 1.20 3,000 1.00 2,750 - - - - -- - 2,500 2,250 0.80 2,000 1,750 0.60 dw do 1,500 0.40 1,250 0.20 W 1,000 -- - 750 0.00 _ 500 0 Q- � Q- 250 AV _kW 4W AV AV • June 30, 2020 March 31, 2021 ® June 30, 2021 6.00 5.50 - 5.00 - 4.50 - - --- -- - - 4.00 3.50 W- 3.00 2.50 1.50 1.00 : r w \_ AA 0.00 NO ,�'�\ NN ,,K \,�� ,� \,�'3 �D� NN N5 N5 N6 \,b KA KA ,"\, 9 g • ix Month T-Bill - Two Year T-Note Ten Year T-Note J. UU 3.00 2.50 2.00 1.50 1.00 0.50 0 00 VW r /610040 • • Six Month T-Bill -- Two Year T-Note � Ten Year T-Note Valley View Consulting, L.L.C. 2 Holdings by Investment Category June 30, 2021 Pooled Funds Debt Service Funds Debt Service Reserve Funds Capital Project & Special Purpose Funds Total Portfolio Description Book Value % of Portfolio Book Value % of Portfolio Book Value % of Portfolio Book Value % of Portfolio Book Value % of Portfolio Cash $ 24, 799, 782 5% $ 3,575 0% $ - 0% $ - 0% $ 24, 803, 357 5% Certificates of Deposit 273, 371, 058 56% 13, 509, 586 3% - 0% 27, 730, 903 6% 314, 611, 546 64% Investment Pools 25, 603,157 5% 13,426,155 3% 367,678 0% 13, 302, 356 3% 52, 699, 346 11 % Money Market Accounts 36,035,231 7% 1,290,108 0% 856,589 0% 22,022,405 4% 60,204,332 12% Municipal 22,401,625 5% - 0% - 0% 2,200,000 0% 24,601,625 5% US Agency 13, 990,199 3% - 0% - 0% 1 - 0% 13, 990,199 3% Total / Average $ 396,201,052 81% $ 28,229,423 6% $ 1,224,267 0% 1 $ 65,255,664 13% $ 490,910,406 100% $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $0 Portfolio Balances (Millions) Order of Liquidity Pooled Funds DS Funds DSR Funds 6/30/2021 6/30/2021 6/30/2021 id CP&SP Funds 6/30/2021 Total Portfolio 6/30/2021 ❑Cash o Local Government Investment Pool Es Money Market Account ❑ US Agency ❑ Municipal ®Certificates of Deposit 3 City of Round Rock Valley View Consulting, L.L.C. Investment Holdings by Investment Category June 30, 2021 Description Book Value % of Portfolio Portfolio Limitation Cash $ 24,803,357 5.1 % 100% Investment Pools 52,699,346 10.7% 100% Money Market Accounts 60,204,332 12.3% 75% Certificates of Deposit 314,611,546 64.1 % 85% Commercial Paper - 0.0% 10% / 5% Municipal 24,601,625 5.0% 35% / 5% US Agency 13,990,199 2.8% Combined 75% US Treasury - 0.0% Total / Average $ 490,910,406 1 100% PASSED $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $0 Portfolio Balances (Millions) Order of Liquidity OKVO O��O ^��O ��11-^ 0ft � Quarterly Transactions By Investment Category June 30, 2021 Description Buys Sells Maturities Calls Interest Net Cash Equivalent Deposit/(Withdrawal) Cash $ - $ - $ - $ - $ - $ 4,963,612 Investment Pools - - - - 1,652 39,078,012 Money Markets Accounts - - - - 47,216 20,047,216 Certificates of Deposit 69,492,283 - 60,632,683 - 668,974 - Commercial Paper - - - - - - Municipal 7,211,040 - 3,930,000 - 114,093 - US Agency 41993,400 - - - - - US Treasury - - - - - - Totals $ 81,696,722 $ - $ 64,562,683 $ - $ 831,935 $ 64,088,840 • Cash Investment Poo 10.7% o Local Government Investment Pool o Money Market Account Cash ■ US Treasury US Agency o US Agency 2.8% ❑ Municipal Mur 5. ■ Certificates of Deposit Portfolio Composition Money Market Accounts June 30 2021 % 11°�n es of Deposit 64.1% 4 City of Round Rock Valley View Consulting, L.L.C. $500 $450 $400 $350 $300 $250 $200 $150 $100 $50 $0 Portfolio Balances By Fund (Millions) 00 \,y0 \'O \\�O \1� \`tip \�O \,y0 K%V \r�O \``O \,y0 \,y0 %KV ■ Capital Project & Special Purpose Funds o Debt Service Reserve Funds o Debt Service Funds ■ Pooled Funds 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 Ar- 2.10 2.00 1.90 1.80 IV I &f—w" 10 1.70 � 1.60 -- 1.50Is OL C 1.40 L 1.301.20 � 1.10 1.00 0.90 0.80 _ _ _ • OW 0.50 0.40 Gum goo 0.30 � 0.20 0.10 � 0.00 Nb ��o ��o ��yo ��o ��o ��o ��yo ��yo ��o ��0 ��o 4\p ��o ��o ��o �o`� p o`� ��yo`� 0`� `� `� (b r r 5 C '(�\ b r�\b q;\-5 Cb Sp rb� 41 b\5 45 0 45 45 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. Holdinas by Allocation and Portfolio (Fund) June 30, 2021 Issuer Coupon Rate Credit Rating Settlement Date Face Amount/ Shares Book Value Market price Market Value Maturity Date Days to Maturity YTM @ 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 0.01 % 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 1 0.03% BBVA 1.77% 10/3/2019 5,149,180 5,149,180 100.00 5,149,180 7/5/2021 5 1.77% Independent Bank 2.15% 7/22/2019 5,191,262 5,191,262 100.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 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 75 2.09% Veritex Community Bank 1.71 % 10/3/2019 10,259,496 10,259,496 100.00 10,259,496 10/4/2021 96 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% Independent 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 225 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,0011756 100.00 3,001,756 8/5/2022 401 0.24% Prosperity Bank 0.20% 2/12/2021 3,001,973 3,001,973 100.00 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 411 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 5021 0.20% City of Round Rock Valley View Consulting, L.L.C. Issuer Coupon Rate Credit Rating Settlement Date Face Amount/ Shares Book Value Market Price Market Value Maturity Date Days to Maturity YTM @ Book Bank OZK 0.28% 12/7/2020 5,007,010 5,007,010 100.00 5,007,010 12/7/2022 525 0.28% 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 41403,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,5301751 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 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,527,235 107.78 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,7099228 396,2019052 100.12 396,1799563 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 100.00 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 43 0.15% Sub Total / Average 0.15% 20,115,578 209115,578 100.00 209115,578 161 0.15% Fund 210 - Interest & Sinking Debt Service JPMor an Chase 0.15% 9/30/2015 3,575 3,575 100.00 3,575 N/A 1 0.15% Sub Total / Average 0.15% 3,575 39575 100.00 3,575 1 0.15% Fund 450 - Kalahari Project Bonds TexPool 0.01 % AAAm 5/30/2021 4,254 4,254 100.00 4,254 N/A 1 0.01 % Sub Total / Average 0.01% 47254 4,254 1 100.00 4,254 1 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 1101 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 967537 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% 2/5/2021 5,604,096 5,6041096 100.00 5,604,096 2/6/2023 586 0.30% Sub Total / Average 0.18% 53,528,855 53,5213,855 100.00 53,528,855 142 0.18% City of Round Rock Valley View Consulting, L.L.C. Issuer Coupon Rate Credit Rating Settlement Date Face Amount/ Shares Book Value Market price Market Value Maturity Date Days to Maturity YTM @ Book Fund 591 - Reserves Fund TexPool 0.01 % AAAm 9/30/2015 8,722 8,722 100.00 8,722 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 0.45% 8659310 865,310 100.00 865,310 1 0.45% Fund 602 - Interest & Sinking Revenue Bonds TexPool 0.01 % AAAm 9/30/2015 8,110,270 8,110,270 100.00 8,1101270 N/A 1 0.01 % Sub Total / Average 0.01 % 8,110,270 8,110, 270 100.00 8,110, 270 1 0.01 % Fund 605 - Kalahari Debt Service Reserve TexPool 0.01 % 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 100.00 215,965 N/A 1 0.45% TexPool 0.01 % AAAm 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 % $ 490,418,582 $ 490,910,406 100.10 $ 4909889,226 2521 0.49% City of Round Rock Valley View Consulting, L.L.C. Book Value Comparison June 30, 2021 Issuer Coupon Rate Settlement Date Maturity Date Beginning Book Value Total Buys/ Increases Total Sells/ Decreases Ending Book Value Change in Book Value Fund 000 - Pooled Investments JPMor an Chase N/A 9/30/2015 N/A $ 19,797,400 $ 5,440,310 $ 437,928 $ 24,799,782 $ 5,002,381 TexPool N/A 9/30/2015 N/A 1,120, 605 35, 941, 983 32, 906, 986 4,155, 603 3,034,998 TexSTAR N/A 9/30/2015 N/A 200,517 5 — 200,522 5 TexasDAl LY N/A 9/30/2015 N/A 6,593,924 14,173, 087 7,718,773 13, 048, 238 6,454, 314 TexasDAl LY N/A 6/1 /2021 N/A — 8,198, 794 — 8,198, 794 8,198, 794 NexBank N/A 11 /29/2016 N/A 35, 863, 988 91,913 — 35, 955, 901 91,913 Veritex Community Bank N/A 9/1/2020 N/A 79,313 17 — 79,329 17 Independent Bank 1.80% 10/11/2019 4/12/2021 9,204,670 — 9,204,670 — 9,204,670 Independent Bank 2.15% 7/22/2019 4/22/2021 5,163, 886 — 5,163, 886 — 5,163, 886 Allegiance Bank 1.70% 2/10/2020 5/10/2021 5,085,569 — 5,085,569 — (5,085,569 Houston Utl Sys 2.92% 3/18/2021 5/15/2021 1,003,212 — 1,000,000 — 1,003,212 Independent Bank 0.65% 5/16/2020 5/17/2021 5,225,414 — 5,225,414 — 5,225,414 BBVA 1.94% 8/27/2019 5/27/2021 5,155, 710 8,502 5,164,211 — 5,155, 710 Bexar County Flood GO Ref 5.00% 4/7/2020 6/15/2021 2,953,561 — 2,930,000 — 2,953,561 Veritex Community Bank 1.67% 12/20/2019 6/21 /2021 5,105,192 — 5,105,192 — 5,105,192 BOKF, NA 2.00% 6/27/2019 6/24/2021 2,000,000 — 2,000,000 — (2,000,000 Veritex Community Bank 1.74% 9/30/2019 6/30/2021 5,131,806 — 5,131,806 — 5,131,806 BBVA 1.77% 10/3/2019 7/5/2021 5,126, 324 22,856 — 5,149,180 22,856 Independent Bank 2.15% 7/22/2019 7/22/2021 5,163, 886 27,376 — 5,191, 262 27,376 R Bank 1.80% 1/27/2020 7/27/2021 2,036,425 9,058 — 2,045,484 9,058 Denton ISD 0.00% 12/17/2020 8/15/2021 499,414 — — 499,803 389 East West Bank 1.64% 11 /22/2019 8/23/2021 5,112,679 20,947 — 5,133, 625 20,947 State of TX Transportation 4.00% 9/2/2020 8/26/2021 9,138, 930 — — 9,053,507 85,423 BBVA 1.87% 8/27/2019 8/27/2021 3,090,005 14,599 — 3,104,603 14,599 Security State Bank & Trust 2.09% 9/5/2019 9/13/2021 7,221,571 381018 — 7,259,589 38,018 Veritex Community Bank 1.71% 10/3/2019 10/4/2021 10,216,419 43,077 — 10,259,496 43,077 East West Bank 1.65% 1 /27/2020 10/27/2021 6,117, 768 25,218 — 6,142, 986 25,218 East West Bank 1.54% 2/18/2020 11/19/2021 6,104,177 23,481 — 6,127,659 23,481 East West Bank 1.64% 11 /22/2019 11 /22/2021 5,112, 679 20,947 — 5,133, 625 20,947 Independent Bank 0.40% 12/7/2020 12/7/2021 8,007,890 8,074 — 8,015,964 8,074 Veritex Community Bank 1.67% 12/20/2019 12/20/2021 5,105,192 21,489 — 5,126,681 21,489 Bank OZK 1.70% 1/28/2020 1/24/2022 8,159,915 35,035 — 8,194,950 35,035 R Bank 1.75% 1 /27/2020 1 /27/2022 2,035,405 8,802 — 2,044,206 8,802 Allegiance Bank 1.59% 2/10/2020 2/10/2022 5,079,999 19,695 — 5,099,694 19,695 Goose Creek ISD 5.00% 11/17/2020 2/15/2022 416,339 — — 411,707 4,632 East West Bank 1.54% 2/18/2020 2/18/2022 5,086,815 19,568 — 5,106, 382 19,568 East West Bank 0.17% 2/19/2021 2/21 /2022 11, 086, 900 4,700 — 11, 091, 600 4,700 FORT BEND COUNTY -REF 5.00% 6/17/2020 3/1/2022 259,147 — — 256,662 2,485 Allegiance Bank 0.40% 6/17/2020 3/18/2022 10,029,728 10,112 — 10,039,840 10,112 Independent Bank 0.40% 1 /11 /2021 4/11 /2022 20, 000, 000 19,726 — 20, 019, 726 19,726 Veritex Community Bank 0.20% 2/5/2021 5/5/2022 3,000,000 1,463 — 3,001,463 1,463 Prosperity Bank 0.20% 2/12/2021 5/12/2022 4,000,614 2,017 — 4,002,631 2,017 Independent Bank 0.30% 5/19/2021 5/19/2022 — 6,000,000 — 67000,000 6,000,000 Allegiance Bank 0.45% 6/17/2020 6/17/2022 12,040,138 13,656 — 12,053,794 13,656 Bank OZK 0.50% 7/9/2020 7/11 /2022 10, 033, 336 12,650 — 10, 045, 986 12,650 Veritex Community Bank 0.24% 2/5/2021 8/5/2022 3,000,000 1,756 — 3,001,756 1,756 Prosperity Bank 0.20% 2/12/2021 8/12/2022 3,000,460 1,513 — 3,001,973 1,513 Arlington TX HGR EDU 0.50% 4/28/2021 8/15/2022 — 500,000 — 500,000 500,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 496,836 — — 497,409 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,000,000 — 3,000,000 3,000,000 City of Round Rock Valley View Consulting, L.L.C. Book Value Comaarison June 30, 2021 Issuer Coupon Rate Settlement Date Maturity Date Beginning Book Value Total Buys/ Increases Total Sells/ Decreases Ending Book Value Change in Book Value Veritex Community Bank 0.18% 3/5/2021 9/5/2022 8,000,000 3,630 - 8,003,630 3,630 State of Texas 1.61 % 3/19/2021 10/1 /2022 3,321,275 - - 3,309,460 (11,814) Prosperity Bank 0.40% 10/15/2020 10/17/2022 6,009,921 6,061 - 6,015,983 6,061 Veritex Community Bank 0.26% 2/5/2021 11 /4/2022 3,0007000 11902 - 3,001,902 1,902 Prosperity Bank 0.20% 2/12/2021 11 /14/2022 3,000,460 1,513 - 3,001,973 1,513 Bank OZK 0.28% 12/7/2020 12/7/2022 5,003,465 3,545 - 5,007,010 3,545 Prosperity Bank 0.20% 6/9/2021 12/9/2022 - 10, 000, 000 - 10, 000, 000 10, 000, 000 Veritex Community Bank 0.28% 1 /6/2021 1 /6/2023 4,000,000 2,762 - 4,002,762 2,762 Veritex Community Bank 0.30% 2/5/2021 2/6/2023 4,400,000 3,219 - 4,403,219 3,219 Eagle Pass Texas 4.00% 6/7/2021 3/1 /2023 - 694,263 - 685,841 685,841 Prosperity Bank 0.25% 3/5/2021 3/6/2023 10,000,000 6,303 - 10,006,303 6,303 Bank OZK 0.26% 3/8/2021 3/8/2023 2,529,087 1,664 - 2,530,751 1,664 Federal Farm Credit Bank 0.13% 3/26/2021 3/23/2023 8,995,531 - - 8,996,094 563 Prosperity Bank 0.20% 4/12/2021 4/12/2023 - 5,001,671 - 5,001,671 5,001,671 FFCB 0.13% 4/13/2021 4/13/2023 - 4,993,400 - 4,994,105 4,994,105 Prosperity Bank 0.20% 5/19/2021 5/19/2023 - 10, 001, 699 - 10, 001, 699 10, 001, 699 Veritex Community Bank 0.20% 6/1 /2021 6/1 /2023 - 20, 000, 000 - 20, 000, 000 20, 000, 000 Bank OZK 0.20% 6/9/2021 6/9/2023 - 8,000,000 - 8,000,000 8,000,000 Arlington TX HGR EDU 0.63% 4/28/2021 8/15/2023 - 1,460,000 - 1,460,000 1,460,000 Dallas I SD 4.00% 4/22/2021 8/ 15/2023 - 4,556,777 - 4,527,235 41527,235 Sub Total/Average Fund 000 - Pooled Investments 344,923,496 138,518,850 87,0745435 396,201,052 519277,556 Fund 170 - Interest & Sinking GO Bonds TexPool N/A 9/30/2015 N/A 848,925 1,2997216 588,121 1,560,020 711,095 TexasDAI LY N/A 4/30/2016 N/A 1,254,801 2,501,064 - 3,755,865 2,501,064 NexBank N/A 2/27/2017 N/A 1,2881661 1,447 - 1,290,108 1,447 Southside Bank 0.14% 3/4/2021 6/4/2021 2,500,000 - 2,500,000 - 2,500,000 East West Bank 0.19% 1 /7/2021 7/7/2021 7,003,062 3,318 - 7,006,380 3,318 Prosperity Bank 0.15% 2/5/2021 8/5/2021 2,500,288 945 - 2,501,233 945 Prosperity Bank 0.15% 2/12/2021 8/12/2021 4,000,460 17513 - 4,001,973 1,513 Sub Total/Average Fund 170 - Interest & Sinking GO Bonds 19,396,197 3,807,502 3,088,121 20,115,578 719,382 Fund 210 - Interest & Sinking Debt Service J PMor an Chase N/A 9/30/2015 N/A 42,345 - 38,770 3,575 (38,770) Sub Total/Average Fund 210 - Interest & Sinking Debt Service 42,345 - 38,770 3,575 (38,770) Fund 450 - Kalahari Project Bonds TexPool N/A 5/30/2021 N/A - 41254 - 4,254 4,254 Sub Total/Average Fund 450 - Kalahari Project Bonds - 4,254 - 43254 4,254 Fund 462 - 2017 Bond Fund TexPool N/A 5/30/2017 N/A 10,558 2 - 10,560 2 NexBank N/A 3/30/2020 N/A 1,606,252 1,803 - 1,608,055 1,803 East West Bank 0.33% 10/13/2020 7/13/2021 1,101,692 907 - 1,102, 599 907 City of Austin GO 0.17% 10/6/2020 9/1 /2021 2,200,000 - - 2,200,000 - East West Bank 0.26% 12/21 /2020 12/21 /2021 6,004,318 3,893 - 6,008,212 3,893 Sub Total/Average Fund 462 - 2017 Bond Fund 10,922,820 6,605 - 10,929,425 6,605 Fund 465 - Road CO Bond Fund TexPool N/A 9/1 /2020 N/A 250,649 29, 399, 263 16, 939, 535 12, 710, 378 12, 459, 729 NexBank N/A 6/28/2019 N/A 99,436 112 - 99,548 112 Veritex Community Bank N/A 6/19/2020 N/A 96,517 20 - 96,537 20 Texas Capital Bank N/A 6/1 /2021 N/A - 20, 002, 301 - 20, 002, 301 20, 002, 301 Independent Bank 0.60% 6/19/2020 1 6/21 /2021 10, 045, 274 - 10, 045, 274 1 - 10, 045, 274 City of Round Rock Valley View Consulting, L.L.C. Book Value Comparison June 30, 2021 Issuer Coupon Rate Settlement Date Maturity Date Beginning Book Value Total Buys/ Increases Total Sells/ Decreases Ending Book Value Change in Book Value Independent Bank 0.40% 12/7/2020 12/7/2021 8,007,922 8,074 - 8,015,996 8,074 Prosperity Bank 0.20% 6/1/2021 9/1/2022 - 7,000,000 - 7,000,000 7,000,000 Veritex Community Bank 0.30% 2/5/2021 2/6/2023 5,600,000 4,096 - 5,604,096 4,096 Sub Total/Average Fund 465 - Road CO Bond Fund 1 24,099,797 56,413,866 1 26,984,808 53,528,855 29,429,058 Fund 591 - Reserves Fund TexPool N/A 9/30/2015 N/A 8,722 8,722 8,722 8,722 0 NexBank N/A 4/29/2019 N/A 8557628 960 - 856,589 960 Sub Total/Average Fund 591 - Reserves Fund 864,350 9,682 8,722 865,310 960 Fund 592 - Convention Center Debt Service East West Bank 0.25% 1 11 /20/2020 5/20/2021 1,000,905 206 1,001,110 - (1,000,905 Sub Total/Avera a Fund 592 - Convention Center Debt Service 1,000,905 206 1,001,110 - (1,000,905) Fund 602 - Interest & Sinking Revenue Bonds TexPool N/A 9/30/2015 N/A 2,744,172 5,367,598 1,500 8,110, 270 5,366,098 East West Bank 0.25% 11 /20/2020 5/20/2021 5,004,523 1,028 5,005,551 - (5,004,523 Sub Total/Average Fund 602 - Interest & Sinking Revenue Bonds 7,748,695 5,368,626 5,007,051 8,110,270 361,575 Fund 605 - Kalahari Debt Service Reserve TexPool N/A 8/30/2019 N/A 11,410 3581957 11,410 358,957 347,546 Sub Total/Average Fund 605 - Kalahari Debt Service Reserve 11,410 358,957 11,410 358,957 347,546 Fund 863 - Drainage Utility Revenue Bond TexPool N/A 10/31 /2015 N/A 577,050 114 - 577,164 114 NexBank N/A 8/30/2020 N/A 267,322 281 51,637 215,965 (51,356) Sub Total/Average Fund 863 - Drainage Utility Revenue Bond 844,372 395 51,637 793,130 (51,242) Total / Average $ 409,854,387 $ 204,488,943 $ 123,266,064 $ 490,910,406 $ 81,056,019 City of Round Rock Valley View Consulting, L.L.C. Market Value Comnarison June 30, 2021 Issuer Coupon Rate Settlement Date Maturity Date Beginning Market Value Total Buys/ Increases Total Sells/ Decreases Ending Market Value Change in Market Value Fund 000 - Pooled Investments JPMor an Chase N/A 9/30/2015 N/A $ 19,797,400 $ 5,440,310 $ 437,928 $ 24,799,782 $ — TexPool N/A 9/30/2015 N/A 1,120, 605 35, 941, 983 32, 906, 986 4,155, 603 — TexSTAR N/A 9/30/2015 N/A 200,517 5 — 200,522 — TexasDAl LY N/A 9/30/2015 N/A 6,593,924 14,173, 087 7,718,773 13, 048, 238 — TexasDAl LY N/A 6/1 /2021 N/A — 8,198, 794 — 8,198, 794 — NexBank N/A 11 /29/2016 N/A 35, 863, 988 91,913 — 35, 955, 901 — Veritex Community Bank N/A 9/1/2020 N/A 79,313 17 — 79,329 Independent Bank 1.80% 10/11/2019 4/12/2021 9,204,670 — 9,204,670 — Independent Bank 2.15% 7/22/2019 4/22/2021 5,163,886 — 5,163,886 — Allegiance Bank 1.70% 2/10/2020 5/10/2021 5,085,569 — 5,085,569 — — Houston Utl Sys 2.92% 3/18/2021 5/15/2021 1,002,870 — 1,000,000 — (2,870) Independent Bank 0.65% 5/16/2020 5/17/2021 5,225,414 — 5,225,414 — — BBVA 1.94% 8/27/2019 5/27/2021 5,155, 710 8,502 5,164, 211 — — Bexar County Flood GO Ref 5.00% 4/7/2020 6/15/2021 2,957,835 — 2,930,000 — 27,835 Veritex Community Bank 1.67% 12/20/2019 6/21 /2021 5,105,192 — 5,105,192 — — BO KF, NA 2.00% 6/27/2019 6/24/2021 2,000,000 — 2,000,000 — — Veritex Community Bank 1.74% 9/30/2019 6/30/2021 5,131,806 — 5,131,806 — — BBVA 1.77% 10/3/2019 7/5/2021 5,126, 324 22,856 — 5,149,180 — Independent Bank 2.15% 7/22/2019 7/22/2021 5,163, 886 27,376 — 5,191, 262 — R Bank 1.80% 1 /27/2020 7/27/2021 2,036,425 9,058 — 2,045,484 — Denton ISD 0.00% 12/17/2020 8/15/2021 499,740 — — 499,820 80 East West Bank 1.64% 11/22/2019 8/23/2021 5,112,679 20,947 — 5,133,625 — State of TX Transportation 4.00% 9/2/2020 8/26/2021 9,141,660 — — 9,054,000 87,660 BBVA 1.87% 8/27/2019 8/27/2021 3,090,005 14,599 — 3,104, 603 — Security State Bank & Trust 2.09% 9/5/2019 9/13/2021 7,221,571 38,018 — 7,259,589 — Veritex Community Bank 1.71% 10/3/2019 10/4/2021 10,216,419 43,077 — 10,259,496 — East West Bank 1.65% 1 /27/2020 10/27/2021 6,117, 768 25,218 — 6,142, 986 — East West Bank 1.54% 2/18/2020 11/19/2021 6,104,177 23,481 — 6,127,659 — East West Bank 1.64% 11 /22/2019 11 /22/2021 5,112, 679 20,947 — 5,133, 625 — Independent Bank 0.40% 12/7/2020 12/7/2021 8,007,890 8,074 — 8,015,964 — Veritex Community Bank 1.67% 12/20/2019 12/20/2021 5,105,192 21,489 — 5,126,681 — Bank OZK 1.70% 1 /28/2020 1 /24/2022 8,159, 915 35,035 — 8,194, 950 — R Bank 1.75% 1 /27/2020 1 /27/2022 2,035,405 8,802 — 2,044,206 — Allegiance Bank 1.59% 2/10/2020 2/10/2022 5,079,999 19,695 — 5,099,694 — Goose Creek ISD 5.00% 11/17/2020 2/15/2022 416,756 — — 412,040 4,716 East West Bank 1.54% 2/18/2020 2/18/2022 5,086,815 19,568 — 5,106, 382 — East West Bank 0.17% 2/ 19/2021 2/21 /2022 11, 086, 900 4,700 — 11, 091, 600 — FORT BEND COUNTY -REF 5.00% 6/17/2020 3/1/2022 260,915 — — 258,083 2,833 Allegiance Bank 0.40% 6/17/2020 3/18/2022 10,029,728 10,112 — 10,039,840 — Independent Bank 0.40% 1 /11 /2021 4/11 /2022 20, 000, 000 19,726 — 20, 019, 726 — Veritex Community Bank 0.20% 2/5/2021 5/5/2022 3,000,000 1,463 — 3,001,463 — Prosperity Bank 0.20% 2/12/2021 5/12/2022 4,000,614 2,017 — 4,002,631 — Independent Bank 0.30% 5/19/2021 5/19/2022 — 6,000,000 — 6,000,000 — Allegiance Bank 0.45% 6/17/2020 6/17/2022 12,040,138 13,656 — 12,053,794 — Ban k OZK 0.50% 7/9/2020 7/ 11 /2022 10, 033, 336 12,650 — 10, 045, 986 — Veritex Community Bank 0.24% 2/5/2021 8/5/2022 3,000,000 1,756 — 3,001,756 — Prosperity Bank 0.20% 2/12/2021 8/12/2022 3,000,460 1,513 — 3,001,973 — Arlin ton TX HGR EDU 0.50% 4/28/2021 8/15/2022 — 500,000 — 500,615 615 City of Bryan TX 0.45% 11 /19/2020 8/15/2022 500,935 — — 500,775 160 Denton ISD 0.00% 12/17/2020 8/15/2022 498,500 — — 497,935 565 City of Austin GO 0.27% 1 10/6/2020 9/1/2022 701,323 — — 701,092 231 Prosperity Bank 0.20% 1 6/1 /2021 9/1 /2022 — 3,000,000 — 3,000,000 — City of Round Rock Valley View Consulting, L.L.C. Market Value Comparison June 30, 2021 Issuer Coupon Rate Settlement Date Maturity Date Beginning Market Value Total Buys/ Increases Total Sells/ Decreases Ending Market Value Change in Market Value Veritex Community Bank 0.18% 3/5/2021 9/5/2022 8,000,000 3,630 — 8,003,630 — State of Texas 1.61 % 3/19/2021 10/1 /2022 3,321,143 — — 3,307,428 13,715 Prosperity Bank 0.40% 10/15/2020 10/17/2022 6,009,921 6,061 — 6,015,983 — Veritex Community Bank 0.26% 2/5/2021 11 /4/2022 3,000,000 1,902 — 3,001,902 — Prosperity Bank 0.20% 2/12/2021 11 /14/2022 3,000,460 1,513 — 3,001,973 — Bank OZK 0.28% 12/7/2020 12/7/2022 5,003,465 3,545 — 5,007,010 — Prosperity Bank 0.20% 6/9/2021 12/9/2022 — 10, 000, 000 — 10, 000, 000 — Ventex Community Bank 0.28% 1/6/2021 1/6/2023 4,000,000 2,762 — 4,002,762 — Veritex Community Bank 0.30% 2/5/2021 2/6/2023 4,400,000 3,219 — 4,403,219 — Ea le Pass Texas 4.00% 6/7/2021 3/1 /2023 — 694,263 — 685,293 (2,090 Prosperity Bank 0.25% 3/5/2021 3/6/2023 10,000,000 6,303 — 10,006,303 — Bank OZK 0.26% 3/8/2021 3/8/2023 2,529,087 1,664 — 2,530,751 — Federal Farm Credit Bank 0.13% 3/26/2021 3/23/2023 8,984t873 — — 8,984,139 734 Prosperity Bank 0.20% 4/12/2021 4/12/2023 — 5,001,671 — 5,001,671 — FFCB 0.13% 4/13/2021 4/13/2023 — 4,993,400 — 4,986,216 7,184 Prosperity Bank 0.20% 5/19/2021 5/19/2023 — 10,001,699 — 10,001,699 — Veritex Community Bank 0.20% 6/1/2021 6/1/2023 — 20,000,000 — 20,000,000 — Bank OZK 0.20% 6/9/2021 6/9/2023 — 8,000,000 — 8,000,000 — Arlin ton TX HGR EDU 0.63% 4/28/2021 8/15/2023 — 1,460,000 — 1,461,445 1,445 Dallas I SD 4.00% 4/22/2021 8/15/2023 — 4, 556, 777 — 4,521,455 (35,322) Sub Total/Average Fund 000 - Pooled Investments 344,925,801 138,518,850 1 87,074,435 396,179,563 (183,773) Fund 170 - Interest & Sinking GO Bonds TexPool N/A 9/30/2015 N/A 848,925 1,299,216 588,121 1,560,020 — TexasDAl LY N/A 4/30/2016 N/A 1,254,801 2,501,064 — 3,755,865 — NexBank N/A 2/27/2017 N/A 1,288,661 1,447 — 1,290,108 — Southside Bank 0.14% 3/4/2021 6/4/2021 21500,000 — 2,500,000 — — East West Bank 0.19% 1 /7/2021 7/7/2021 7,003,062 3,318 — 7,006,380 — Prosperity Bank 0.15% 2/5/2021 8/5/2021 2,500,288 945 — 2,501,233 — Prosperity Bank 0.15% 1 2/12/2021 8/12/2021 4,000,460 1,513 1 — 4,001,973 — Sub Total/Average Fund 170 - Interest & Sinking GO Bonds 19,396.197 3,807,502 - 3,088,121 20,115,578 — Fund 210 - Interest & Sinking Debt Service J PMor an Chase N/A 9/30/2015 N/A 42, 345 — 38,770 3,575 — Sub Total/Average Fund 210 - Interest & Sinking Debt Service 42,345 — 38,770 3,575 — Fund 450 - Kalahari Project Bonds TexPool N/A 5/30/2021 N/A — 41254 — 4,254 — Sub Total/Average Fund 450 - Kalahari Project Bonds — 4,254 — 49254 — Fund 462 - 2017 Bond Fund TexPool N/A 5/30/2017 N/A 10,558 2 — 10,560 — NexBank N/A 3/30/2020 N/A 1,606,252 1,803 — 1,608,055 — East West Bank 0.33% 10/13/2020 7/13/2021 1,101,692 907 — 1,102, 599 — City of Austin GO 0.17% 10/6/2020 9/1/2021 2,200,902 — — 2,200,308 (594 East West Bank 0.26% 12/21 /2020 12/21 /2021 6,004,318 3,893 — 6,008,212 — Sub Total/Average Fund 462 - 2017 Bond Fund 10,923,722 1 6,605 — 10,929,733 (594) Fund 465 - Road CO Bond Fund TexPool N/A 9/1 /2020 N/A 250,649 29, 399, 263 16, 939, 535 12, 710, 378 — NexBank N/A 6/28/2019 N/A 99,436 112 — 99,548 — Veritex Community Bank N/A 6/19/2020 N/A 96,517 20 — 96,537 — Texas Capital Bank N/A 6/1/2021 N/A — 20,002,301 — 20,002 Independent Bank 0.60% 6/19/2020 6/21 /2021 10, 045, 274 — 10, 045, 274 — — City of Round Rock Valley View Consulting, L.L.C. Market Value Comparison June 30, 2021 Issuer Coupon Rate Settlement Date Maturity Date Beginning Market Value Total Buys/ Increases Total Sells/ Decreases Ending Market Value Change in Market Value Independent Bank 0.40% 12/7/2020 12/7/2021 8,007,922 8,074 — 8,015,996 Prosperity Bank 0.20% 6/1/2021 9/1/2022 — 7,000,000 — 7,000,000 — Veritex Community Bank 0.30% 2/5/2021 2/6/2023 5,600,000 4,096 — 5,604,096 — Sub Total/Average Fund 465 - Road CO Bond Fund 24,099,797 56,413,866 26,984,808 53,528,855 — Fund 591 - Reserves Fund TexPool N/A 9/30/2015 N/A 8,722 8,722 8,722 8,722 — NexBank N/A 4/29/2019 N/A 8551628 960 — 856,589 — Sub Total/Average Fund 591 - Reserves Fund 8641350 1 9,682 1 8,722 1 865,310 — Fund 592 - Convention Center Debt Service East West Bank 0.25% 11 /20/2020 1 5/20/2021 1, 000, 905 206 1,001,110 — — Sub Total/Average Fund 592 - Convention Center Debt Service 11000,905 206 1,001,110 — — Fund 602 - Interest & Sinking Revenue Bonds TexPool N/A 9/30/2015 N/A 2,744,172 5,367,598 1,500 8,110, 270 — East West Bank 0.25% 11 /20/2020 5/20/2021 5,004,523 1,028 5,005,551 — — Sub Total/Average Fund 602 - Interest & Sinking Revenue Bonds 71748,695 5,368,626 5,007,051 8,110,270 — Fund 605 - Kalahari Debt Service Reserve TexPool N/A 8/30/2019 N/A 11,410 358,957 11,410 358,957 — Sub Total/Average Fund 605 - Kalahari Debt Service Reserve 111410 358,957 11,410 358,957 — Fund 863 - Drainage Utility Revenue Bond TexPool N/A 10/31/2015 N/A 577,050 114 — 577,164 — NexBank N/A 8/30/2020 N/A 267,322 281 51,637 215,965 — Sub Total/Average Fund 863 - Drainage Utility Revenue Bond 844,372 395 51,637 793,130 — Total / Average $ 409,857,594 $ 204,488,943 $ 123,266,064 $ 490,889,226 $ (184,367) City of Round Rock Valley View Consulting, L.L.C. Holdinas by Allocation and Portfolio (Fund) March 31, 2021 Issuer Coupon Rate Credit Rating Settlement Date Face Amount/ Shares Book Value Market price Market Value Maturity Date Days to Maturity YTM @ Book Fund 000 - Pooled Investments NexBank 0.45% 11/29/2016 $ 35,863,988 $ 35,863,988 100.00 $ 35,863,988 N/A 1 0.45% Veritex Community Bank 0.10% 9/1/2020 79,313 79,313 100.00 79,313 N/A 1 0.10% JPMor an Chase 0.15% 9/30/2015 19,797,400 19,797,400 100.00 19,797,400 N/A 1 0.15% TexSTAR 0.02% AAAm 9/30/2015 200,517 200,517 100.00 200,517 N/A 1 0.02% TexPool 0.02% AAAm 9/30/2015 1,120,605 1,120,605 100.00 1,120,605 N/A 1 0.02% TexasDAILY 0.05% AAAm 9/30/2015 6,593,924 6,593,924 100.00 6,593,924 N/A 1 0.05% Independent Bank 1.80% 10/11/2019 9,204,670 9,204,670 100.00 9,204,670 4/12/2021 12 1.80% Independent Bank 2.15% 7/22/2019 5,163,886 5,163,886 100.00 5,163,886 4/22/2021 22 2.15% Allegiance Bank 1.70% 2/10/2020 5,085,569 5,085,569 100.00 5,085,569 5/10/2021 40 1.70% Houston Utl Sys 2.92% Aa2/AA/AA 3/18/2021 1,000,000 1,003,212 100.29 1,002,870 5/15/2021 45 0.30% Independent Bank 0.65% 5/16/2020 5,225,414 5,225,414 100.00 5,225,414 5/17/2021 47 0.65% BBVA 1.94% 8/27/2019 5,155,710 5,155710 100.00 5,155,710 5/27/2021 57 1.94% Bexar County Flood GO Ref 5.00% Aaa/AAA/AAA 4/7/2020 2,930,000 2,953,561 100.95 2,957,835 6/15/2021 76 1.10% Veritex Community Bank 1.67% 12/20/2019 5,105,192 5,105,192 100.00 5,105,192 6/21 /2021 82 1.67% BOKF, NA 2.00% 6/27/2019 2,000,000 2,000,000 100.00 2,000,000 6/24/2021 85 2.00% Veritex Community Bank 1.74% 9/30/2019 5,131,806 5,131,806 100.00 5,131,806 6/30/2021 91 1.74% BBVA 1.77% 10/3/2019 5,126,324 5,126,324 100.00 5,126,324 7/5/2021 96 1.77% Independent Bank 2.15% 7/22/2019 5,163,886 5,163,886 100.00 5,163,886 7/22/2021 113 2.1570 R Bank 1.80% 1/27/2020 2,036,425 2,036,425 100.00 2,036,425 7/27/2021 118 1.80% Denton ISD 0.00% -/AAA/AAA 12/17/2020 500,000 499,414 99.95 499,740 8/15/2021 137 0.31 % East West Bank 1.64% 11 /22/2019 5,112,679 5,112,679 100.00 5,112,679 8/23/2021 145 1.64% State of TX Transportation 4.00% MIG1/SP1+/F1+ 9/2/2020 9,000,000 9,138,930 101.57 9,141,660 8/26/2021 148 0.20% BBVA 1.87% 8/27/2019 3,090,005 3,090,005 100.00 3,090,005 8/27/2021 149 1.87% Security State Bank & Trust 2.09% 9/5/2019 7,221,571 7,221,571 100.00 7,221,571 9/13/2021 166 2.09% Veritex Community Bank 1.71 % 10/3/2019 10,216,419 10,216,419 100.00 10,216,419 10/4/2021 187 1.71 % East West Bank 1.65% 1/27/2020 6,117,768 6,117,768 100.00 6,117,768 10/27/2021 210 1.65% East West Bank 1.54% 2/18/2020 6,104,177 6,1041177 100.00 6,104,177 11 /19/2021 233 1.54% East West Bank 1.64% 11 /22/2019 5,112,679 5,112,679 100.00 5,112,679 11 /22/2021 236 1.64% Independent Bank 0.40% 12/7/2020 8,007,890 8,007,890 100.00 8,007,890 12/7/2021 251 0.40% Veritex Community Bank 1.67% 12/20/2019 5,105,192 5,1051192 100.00 5,105,192 12/20/2021 264 1.67% Bank OZK 1.70% 1 /28/2020 8,159,915 8,159,915 100.00 8,159,915 1 /24/2022 299 1.70% R Bank 1.75% 1/27/2020 2,035,405 2,035,405 100.00 2,035,405 1/27/2022 302 1.75% Allegiance Bank 1.59% 2/10/2020 5,079,999 5,079,999 100.00 5,079,999 2/10/2022 316 1.59% Goose Creek ISD 5.00% Aaa/-/AAA 11/17/2020 400,000 416,339 104.19 416,756 2/15/2022 321 0.33% East West Bank 1.54% 2/18/2020 5,086,815 5,086,815 100.00 5,086,815 2/18/2022 324 1.54% East West Bank 0.17% 2/19/2021 11,086,900 11,086,900 100.00 11,086,900 2/21 /2022 327 0.17% FORT BEND COUNTY -REF 5.00% Aa1/-/AA+ 6/17/2020 250,000 259,147 104.37 260,915 3/1/2022 335 0.98% Allegiance Bank 0.40% 6/17/2020 10,029,728 10,029,728 100.00 10,029,728 3/18/2022 352 0.40% Independent Bank 0.40% 1/11/2021 20,000,000 20,000,000 100.00 20,000,000 4/11/2022 376 0.40% Veritex Community Bank 0.20% 2/5/2021 3,000,000 3,000,000 100.00 3,000,000 5/5/2022 400 0.20% Prosperity Bank 0.20% 2/12/2021 4,000,614 4,000,614 100.00 4,000,614 5/12/2022 407 0.20% Allegiance Bank 0.45% 6/17/2020 12,040,138 12,040,138 100.00 12,040,138 6/17/2022 443 0.45% Bank OZK 0.50% 7/9/2020 10,033,336 10,033,336 100.00 10,033,336 7/11/2022 467 0.50% Veritex Community Bank 0.24% 2/5/2021 3,000,000 3,000,000 100.00 3,000,000 8/5/2022 492 0.24% Prosperity Bank 0.20% 2/12/2021 3,000,460 3,000,460 100.00 3,000,460 8/12/2022 499 0.20% Denton ISD 0.00% -/AAA/AAA 12/17/2020 500,000 496,836 99.70 498,500 8/15/2022 502 0.46% City of Bryan TX 0.45% -/AA/- 11 /19/2020 500,000 500,000 100.19 500,935 8/15/2022 502 0.45% City of Austin GO 0.27% Aal/AAA/AAA 1 10/6/2020 1 700,000 700,000 100.19 1 701,323 9/1/2022 5191 0.27% 16 City of Round Rock Valley View Consulting, L.L.C. Holdinas by Allocation and Portfolio (Fund) March 31, 2021 Issuer Coupon Rate Credit Rating Settlement Date Face Amount/ Shares Book Value Market price Market Value Maturity Date Days to Maturity YTM @ Book Veritex Community Bank 0.18% 3/5/2021 8,000,000 8,000,000 100.00 8,000,000 9/5/2022 523 0.18% State of Texas 1.61 % Aaa/AAA/- 3/19/2021 3,250,000 3,321,275 102.19 3,321,143 10/1 /2022 549 0.15% Prosperity Bank 0.40% 10/15/2020 6,009,921 6,009,921 100.00 6,009,921 10/17/2022 565 0.40% Veritex Community Bank 0.26% 2/5/2021 3,000,000 3,0001000 100.00 3,000,000 11/4/2022 583 0.26% Prosperity Bank 0.20% 2/12/2021 3,000,460 3,000,460 100.00 3,000,460 11 /14/2022 593 0.20% Bank OZK 0.28% 12/7/2020 5,003,465 5,003,465 100.00 5,003,465 12/7/2022 616 0.28% Veritex Community Bank 0.28% 1/6/2021 4,000,000 4,000,000 100.00 4,000,000 1/6/2023 646 0.28% Veritex Community Bank 0.30% 2/5/2021 4,400,000 4,400,000 100.00 4,400,000 2/6/2023 677 0.30% Prosperity Bank 0.25% 3/5/2021 10,000,000 10,000,000 100.00 10,000,000 3/6/2023 705 0.25% Bank OZK 0.26% 3/8/2021 2,529,087 2,529,087 100.00 2,529,087 3/8/2023 707 0.26% Federal Farm Credit Bank 0.13% Aaa/AA+/AAA 3/26/2021 9,000,000 8,995,531 99.83 8,984,873 3/23/2023 722 0.15% Sub Total / Average 0.98% 344,66%252 3447923,496 100.07 344,925,801 265 0.82% Fund 170 - Interest & Sinking GO Bonds TexasDAI LY 0. 05% AAAm 4/30/2016 1,254,801 1,254,801 100.00 1,254,801 N/A 1 0.05% NexBank 0.45% 2/27/2017 1,288,661 1,288,661 100.00 1,288,661 N/A 1 0.45% TexPool 0.02% AAAm 9/30/2015 848,925 8483925 100.00 848,925 N/A 1 0.02% Southside Bank 0.14% 3/4/2021 2,500,000 2,500,000 100.00 2,500,000 6/4/2021 65 0.14% East West Bank 0.19% 1/7/2021 7,003,062 7,003,062 100.00 7,003,062 7/7/2021 98 0.19% Prosperity Bank 0.15% 2/5/2021 2,5001288 2,500,288 100.00 2,500,288 8/5/2021 127 0.15% Prosperity Bank 0.15% 2/12/2021 4,000,460 4,000,460 100.00 4.000,460 8/12/2021 134 0.15% Sub Total / Average 0.17% 19,396,197 191396,197 100.00 19,396,197 88 0.17% Fund 210 - Interest & Sinking Debt Service JPMor an Chase 0.15% 1 9/30/2015 1 42,345 42,345 100.00 42,345 N/A 1 0.15% Sub Total / Average 0.15% 42,345 427345 100.00 42,345 1 0.15% Fund 462 - 2017 Bond Fund TexPool 0.02% AAAm 5/30/2017 10,558 10,558 100.00 10,558 N/A 1 0.02% NexBank 0.45% 3/30/2020 1,606,252 1,606,252 100.00 1,606,252 N/A 1 0.45% East West Bank 0.33% 10/13/2020 1,101,692 1,1017692 100.00 1,101,692 7/13/2021 104 0.33% City of Austin GO 0.17% 10/6/2020 2,200,000 2,200,000 100.04 2,200,902 9/1/2021 154 0.17% East West Bank 0.26% 12/21/2020 6,004,318 6,004,318 100.00 6,004,318 12/21/2021 265 0.26% Sub Total / Average 0.28% 107922,820 10,9229820 100.01 10,923,722 1871 0.28% Fund 465 - 2019 CO Bond Fund NexBank 0.45% 6/28/2019 99,436 99,436 100.00 99,436 N/A 1 0.45% TexPool 0.02% AAAm 9/1/2020 250,649 250,649 100.00 250,649 N/A 1 0.02% Veritex Community Bank 0.10% 6/19/2020 96,517 96,517 100.00 96,517 N/A 1 0.10% Independent Bank 0.60% 6/19/2020 10,045,274 10,0457274 100.00 10,045,274 6/21/2021 82 0.60% Independent Bank 0.40% 12/7/2020 8,007,922 8,007,922 100.00 8,007,922 12/7/2021 251 0.40% Veritex Community Bank 0.30% 2/5/2021 5,600,000 5,600,000 100.00 5,600,000 2/6/2023 677 0.30% Sub Total / Average 0.46% 24,0993797 241099,797 100.00 1 24,099,797 2751 0.46% Fund 591 - Reserves Fund TexPool 0.02% AAAm 9/30/2015 8,722 8,722 100.00 8,722 N/A 1 0.02% NexBank 0.45% 4/29/2019 855,628 855,628 100.00 855,628 N/A 1 0.45% Sub Total / Average 0.45% 864,350 864,350 100.00 864,350 1 0.45% Fund 592 - Convention Center Debt Service East West Bank 0.25% 11 /20/2020 1,000,905 1,000,905 100.00T 1,000,905 5/20/2021 501 0.25% 17 City of Round Rock Valley View Consulting, L.L.C. HnIrlinaS by Allocation and Portfolio (Fund) March 31, 2021 Issuer Coupon Rate Credit Rating Settlement Date Face Amount) Shares Book Value Market price Market Value Maturity Date Days to Maturity YTM @ Book Sub Total / Average 0.25% 1,000,905 1,000,905 100.00T 1,000,905 50 0.25% Fund 602 - Interest & Sinking Revenue Bonds TexPool 0.02% AAArn 9/30/2015 2,744,172 2,744,172 100.00 2,744,172 N/A 1 0.02% East West Bank 0.25% 11/20/2020 5,004,523 5,004,523 100.00 5,004,523 5/20/2021 50 0.25% Sub Total / Average 0.17% 7,748,695 7,748,695 100.00 7,748,695 33 0.17% Fund 605 - Kalahari Debt Service Reserve TexPool 0.02% AAArn 8/30/2019 11,410 11,410 100.00 1 11,410 N/A 1 0.02% Sub Total / Average 0.02% 117410 11,410 100.00 11,410 1 0.02% Fund 863 - Drainage Utility Revenue Bond NexBank 0.45% 8/30/2020 267,322 267,322 100.00 267,322 N/A 1 0.45% TexPool 0.02% AAArn 10/31/2015 577,050 577,050 100.00 577,050 N/A 1 0.02% Sub Total / Average 0.16% 844,372 844,372 100.00 844,372 1 0.16% Total / Average 0.87% $ 409,600,142 $ 409,854,387 100.06 $ 409,857,594 2491 0.74% 18 City of Round Rock Valley View Consulting, L.L.C.