The URL can be used to link to this page

R-2023-054 - 2/9/2023 RESOLUTION NO. R-2023-054 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 December 31, 2022 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 9th day of February, 2023. _ AAz CRAIG MOGAN, yor City of Round Roc exas ATTEST: MEAGAN INKS, C' y Clerk 0112.20232:4856-7688-0973 EXHIBIT ROUND ROCK TEXAS FINANCE QUARTERLY INVESTMENT REPORT For the Quarter Ended December 31, 2022 Prepared by Valley View Consulting, L.L.C. The investment portfolio of the City of Round Rock, Texas is in compliance with the Public Funds Investment Act and the Investment Policy and Strategies. //signatures withheld for security purposes// //signatures withheld for security purposes// Chief Financial Officer Deputy Chief Financial Officer //signatures withheld for security purposes// //signatures withheld for security purposes// Controller Treasury Accountant Valley View Co sul ing, LLC Dated Disclaimer: These reports were compiled using information provided by the City. No procedures were performed to test the accuracy or completeness of this information. The market values included in these reports were obtained by Valley View Consulting, L.L.C. from sources believed to be accurate and represent proprietary valuation. Due to market fluctuations these levels are not necessarily reflective of current liquidation values. Yield calculations are not determined using standard performance formulas,are not representative of total return yields and do not account for investment advisor fees. Summary Holdings by Investment Category (Security Sector) December 31,2022 YTM @ Description Cost Book Value Market Value Cash 0.00% $ 9,919,334 $ 9,919,334 Certificates of Deposit 0.24% 83,241,323 83,241,323 Local Government Investment Pool 4.23% 69,608,173 69,608,173 Money Market Accounts 4.38% 45,956,440 45,956,440 Municipal 0.49% 6,901,211 6,749,802 US Agency 2.75% 221,166,084 217,272,607 US Treasury 1.80% 127,647,639 124,974,025 Total/Average 2.41% $ 564,440,204 $ 557,721,705 September 30,2022 YTM @ Description Cost Book Value Market Value Cash 0.40% $ 10,495,420 $ 10,495,420 Certificates of Deposit 0.26% 114,322,455 114,322,455 Local Government Investment Pool 2.44% 62,788,519 62,788,519 Money Market Accounts 3.05% 25,630,256 25,630,256 Municipal 0.30% 15,197,223 14,997,653 USAgency 2.38% 184,064,262 180,192,004 US Treasury 1.69% 122,917,363 119,875,000 Total/Average 1.71% $ 535,415,498 $ 528,301,307 Average Yield Current Fiscal Year- Quarter(1) to-Date(2) Total Portfolio 2.41% 2.41% TexPool Yield 3.98% 3.98% Rolling Three Mo.Treas.Yield 4.19% 4.19% Rolling Six Mo.Treas.Yield 3.90% 3.90% Rolling 1 Yr.Treas.Yield 2.81% 2.81% Rolling 2 Yr.Treas.Yield 1.63% 1.63% Investment Income(3) Interest Income(Approximate) $ 2,713,298 $ 2,713,298 WAM at 12/31/2022 Policy WAM Max Total Portfolio 263 days 540 days Pooled Funds 303 days 540 days (1)Average Yield calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. (2)Fiscal Year-to-Date Average Yields calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. (3)Investment Income includes coupon interest,accrued interest,and discount and premium amortization. City of Round Rock Valley View Consulting,L.L.C. 1 Economic Overview 12/31/2022 The Federal Open Market Committee(FOMC) raised the Fed Funds target range 0.50%to 4.25%-4.50%December 14th(Effective Fed Funds are trading+/-4.33%). A 0.25%increase is projected February 1st. Third Quarter GDP jumped to 3.2%in the final number. December Non-Farm Payroll added 223k new jobs with the Three Month Average declining to 247k. Crude oil continues moderating at+/-$75 per barrel. The Stock Markets drifted between+/-15%to+/-19%below the 2021 peak. The yield curve is fully negatively sloped(3 months to 10 years,with peak yield at 6 months)and continues to indicate lower future interest rates. Inflation remained well over the FOMC 2%target(Core PCE+/-5%and CPI+/-6%). International challenges add to economic uncertainty. 6.00 Treasury Yield Curves 5,250 S&P 500 5,000 4,750 5.00 4,500 4,250 _WW in 4,000 4.00 3,750 3,500 3,250 3.00 3'000 2,750 2,500 2,250 2.00 2,000 1,750 _ � � � � � � 1,500 1.00 -__ 1,250 1,050 too 0.00 250 0 0�ray�iT y�t7 y�if y �`t) 41 41 •December 31,2021 September 30,2022 December 31,2022 6.00 US Treasury Historical Yields-Since 2006 5.50 US Treasury Historical Yields-Since Nov 2015 5.50 - -- 5.00 5.00 4.50 -- 4.5016 4.00 4.00 3.50 3.50 11 rw It A 3 3.00 .00 2.50 2.50 JL j 2.00 t 2.00 Wit ff L;W 1.501.50 1.00 k 1 1.00 ' 0.50 J I 0.50 0.00 p q % �j� 0.00 �a�)PNN. ��aC)J�O'D�)J\)0)J\�a�) j0 )a)V�jan�'Dn an �an �an)' 1�;�a�J)Tn�"ja ry� �OJ 1��a�16�OJ 16�a`�1� �O�11�a�1$�0,10�a`�19�O�19�a`�ryO C10J�O�.a�ry�C1�� a�ry�.C1OJ�,ti -Sax Month T. T_ 2 Valley View Consulting,L.L.C. Holdings by Investment Category December 31,2022 Pooled Debt Service Debt Service Reserve Capital Project&Special Total Funds Funds Funds Purpose Funds Portfolio 011111111111 r t. Book Value %of Portfolio Book Value_.."/a.AfPortfolio, Book Value %of Portfolio.,_ Book Value %of Portfolio Book Value %of Portfolio Cash $ 9,914,055 2% W 5,280 0% $ - 0% $ - 0% $ 9,919,334 2% Certificates of Deposit 77,611,891 14% - 0% - 0% 5,629,432 1% 83,241,323 15% Investment Pools 46,364,468 8% 7,072,726 1% 1,920,933 0% 14,250,045 3% 1 69,608,173 12% Money Market Accounts 23,350,423 4% - 0% 875,014 0% 21,731,003 4% 45,956,440 8% Municipal 6,901,211 1% - 0% - 0% - 0% 6,901,211 1% US Agency 211,167,803 37% - 0% - 0% 9,998,280 2% 221,166,08439% US Treasu 96,763,168 17% - 0% - 0% 30,884,471 5% 127,647,639 23% $472,073,020 84"/° S 2,795,948 1 0% 1s'K $564,440,2041 100% Portfolio Balances (Millions) Order of Liquidity $600 ■Cash $500 ■Local Government Investment Pool $400 - -- ■Money Market Account $300 -- ■US Treasury $200 --- - - ■US Agency 0 Municipal $100 ■Certificates of Deposit $0 Pooled Funds DS Funds DSR Funds CPBSP Funds Total Portfolio 12/31/2022 12131/2022 12/31/2022 12/3112022 12/3112022 City of Round Rock Valley View Consulting, L.L.C. 3 Investment Holdings by Investment Category Quarterly Transactions By Investment Category December 31, 2022 December 31,2022 %of Portfolio Net Cash Equivalent Description Book Value Portfolio Limitation Description Buys Sells Maturities Calls Interest Deposit/(Withdrawal) Cash $ 9,919,334 1.8% 100% Cash $ - $ - $ - $ - $ 28,637 $ 576,086 Investment Pools 69,608,173 12.3% 100% Investment Pools - - - - 502,772 6,819,654 Money Market Accounts 45,956,440 8.1% 75% Money Markets Accounts - - - - 326,185 20,326,185 Certificates of Deposit 83,241,323 14.8% 85% Certificates of Deposit 56,501 - 31,137,633 - 68,731 - Commercial Paper -1 0.0% 10%/5% Commercial Paper - - - - - Municipal 6,901,211 1.2% 35%/5% Municipal - - 8,250,000 - 89,103 - US Agency 221,166,084 39.2% 85% US Agency 36,988,116 - - - 624,142 - US Treasury 127,647,639 22.6% 85% US Treasury 4,673,034 - - - 428,125 - Total/Average $ 564,440,204 100% PASSED Totals S 41,717,651 $ - $ 39,387,633 $ - $ 2,067,694 $ 26 569,753 Portfolio Balances (Millions) Portfolio Composition Order of Liquidity Certificatesof December 31,2022 $600 - - --- Deposit Municipal Money Market Accounts 14.8% 1.2% ■Cash 8.1% $500 ■Local Government Investment Pool Investment Pools $400 12.3% In Money Market Account $300 ■US Treasury Cash 1.8% $200 — ■US Agency $100 — -- ❑Municipal US Agency 39.2% ■Certificates of Deposit US Treasury $0 22.6% N�\,� 4 City of Round Rock Valley View Consulting,L.L.C. City of Round Rock Pooled Funds Performance 4.50 4.00 - -- - - -- - - - - - - 3.50 - - - 3.00 --- - m a� = 2.50 - - - LLt J IL 2.00 --- -- -- 1.50 - _ -- - - - ---- - -- -- �� - - - --- - ♦ - - - - 1.00 - I t ♦ 0.50 -- s-�� -- -- --- - - - — - -- - ` 0.00 \pyo ��yoNOJ \pyo \�o \�o \ �p \�o \�o \,p \�o \11Z ,o ��o \,yo \�o ��o \�o \�o \�o \pyo \�o0 \p \pyo \p \'t \�o \moo ,�� \rt \r j \,�o \o�. \�� \moo \moo \�^ \,�� \oo \,�o \o�. \, \moo \moo ��'• \�� goo \rS \ob \rt \moo \oo \o� o �ti o 0 0 �,�? m o o �ti m o o ,,ti m o o ,,ti g o o ,,ti m o o �ti o 0 0 ,,ti Round Rock TexPool Rolling 1.5 yr Treasury (Policy WAM max) Rolling 9 mo Treasury City of Round Rock Valley View Consulting, L.L.C. 5 Portfolio Balances By Fund (Millions) $600 $500 ■Capital Project& Special Purpose Funds $400 o Debt Service Reserve Funds $300 ❑Debt Service Funds $200 $100 ePooled Funds $0 �h .h 116 ^6 �`° No -A NX ,�1A .1 ko N% ^� 14% ^o 'C6 'A '9 to do^�o o o dy^ ti^ � titi titi titi titi Iti° \10 414 KP \ti° 141 IKP KP f, IKIP 4f, Kti° Kti° f, Kti° 0° �'P �'P �'O � ,� '0; �`ti° �'O '0' '\'l; oJpyo '\'l; pyo ' .,\,yo .�`?)�^ ^�\" `o\-y O\-o "P '\� 6\,yo o'oo ,�'ly� 'S�� 6�,yo\, ,,'l�� 9��^ 6\,yo o\'5 "P '��b 6\,yo o\,yo0tid'p ^�\-' 6\-i 9\, "P '3\� 6\,yo "o ^�� City of Round Rock Valley View Consulting, L.L.C. 6 Holdings by Allocation and Portfolio (Fund) December 31, 2022 Coupon Settlement Face Amount/ Market Days to YTM @ Issuer Rate Credit Rating Date Shares Book Value Price Market Value Maturity Date Maturity Book Fund 000-Pooled Investments Nexl3ank 4.40% 11/29/2016 $ 23,158,229 $ 23,158,229 100.00 $ 23,158,229 N/A 1 4.40% TexasDAILY 4.13% AAAm 6/1/2021 2,460 2,460 100.00 2,460 N/A 1 4.13% TexasDAILY Select 4.33% AAAm 12/3/2021 5,081,716 5,081,716 100.00 5,081,716 N/A 1 4.33% Veritex Community Bank 4.30% 9/1/2020 192,194 192,194 100.00 192,194 N/A 1 4.30% JPMor an Chase 0.00% 9/30/2015 9,914,055 9,914,055 100.00 9,914,055 N/A 1 0.00% TexSTAR 4.22% AAAm 9/30/2015 203,596 203,596 100.00 203,596 N/A 1 4.22% TexPool 4.22% AAAm 9/30/2015 38,778,376 38,778,376 100.00 38,778,376 N/A 1 4.22% TexasDAILY 4.13% AAAm 9/30/2015 2,298,320 2,298,320 100.00 2,298,320 N/A 1 4.13% Veritex Community Bank 0.28% 1/6/2021 4,019,618 4,019,618 100.00 4,019,618 1/6/2023 6 0.28% R Bank 0.57% 7/6/2021 1,007,187 1,007,187 100.00 1,007,187 1/6/2023 6 0.57% Treasury 0.13% Aaa/AA+/AAA 1/5/2022 5,000,000 4,998,715 99.69 4,984,461 1/31/2023 31 0.43% San Antonio TX Elec. 2.41% Aa2/AA-/AA- 4/13/2022 500,000 500,000 99.82 499,075 2/1/2023 32 2.41% Veritex CommunityBank 0.30% 2/5/2021 4,423,125 4,423,125 100.00 E4,423,125 2/6/2023 37 0.30% FFCB 0.16% Aaa/AA+/AAA 11/22/2021 5,000,000 4,999,447 99.54 07 2/10/2023 41 0.26% Ea le Pass Texas 4.00% -/AA-/- 6/7/2021 645,000 649,024 100.12 87 3/1/2023 60 0.20% Pros erit Bank 0.25% 3/5/2021 10,043,927 10,043,927 100.00 27 3/6/2023 65 0.25% Bank OZK 0.26% 3/8/2021 2,540,686 2,540,686 100.00 86 3/8/2023 67 0.26% FFCB 0.13% Aaa/AA+/AAA 3/26/2021 9,000,000 8,999,492 99.04 8,914,039 3/23/2023 82 0.15% Prosperity Bank 0.20% 4/12/2021 5,016,711 5,016,711 100.00 5,016,711 4/12/2023 102 0.20% FFCB 0.13% Aaa/AA+/AAA 4/13/2021 5,000,000 4,999,069 98.77 4,938,286 4/13/2023 103 0.19% FFCB 0.38% Aaa/AA+/AAA 1/28/2022 4,000,000 3,993,325 98.69 3,947,658 4/27/2023 117 0.90% Prosperity Bank 0.20% 5/19/2021 10,031,774 10,031,774 100.00 10,031,774 5/19/2023 139 0.20% FNMA 0.25% Aaa/AA+/AAA 6/23/2022 5,000,000 4,949,444 98.29 4,914,617 5/22/2023 142 2.90% Veritex Community Bank 0.20% 6/1/2021 20,060,130 20,060,130 100.00 20,060,130 6/1/2023 152 0.20% Bank OZK 0.20% 6/9/2021 8,024,176 8,024,176 100.00 8,024,176 6/9/2023 160 0.20% R Bank 0.70% 7/6/2021 1,008,828 1,008,828 100.00 1,008,828 7/6/2023 187 0.70% Treasury 1.25% Aaa/AA+/AAA 7/7/2021 8,000,000 8,047,623 98.04 7,843,393 7/31/2023 212 0.22% Veritex Community Bank 0.25% 7/30/2021 7,021,938 7,021,938 100.00 7,021,938 7/31/2023 212 0.25% Dallas ISD 4.00% Aaa/AAA/AAA 4/22/2021 4,195,000 4,292,187 99.71 4,182,667 8/15/2023 227 0.26% Arlington TX HGR EDU 0.63% -/AAA/- 4/28/2021 1,460,000 1,460,000 97.42 1,422,274 8/15/2023 227 0.63% Veritex Community Bank 0.25% 8/23/2021 4,413,790 4,413,790 100.00 4,413,790 8/23/2023 235 0.25% FHLMC 0.25% Aaa/AA+/AAA 1/28/2022 5,000,000 4,974,472 97.16 4,858,171 8/24/2023 236 1.05% FHLB 0.00% Aaa/AA+/-- 8/31/2022 5,000,000 4,887,667 96.90 4,844,950 8/28/2023 240 3.51% FNMA 2.88% Aaa/AA+/AAA 3/30/2022 4,000,000 4,018,342 98.68 3,947,138 9/12/2023 255 2.20% Treasury 0.25% Aaa/AA+/AAA 9/30/2021 10,000,000 9,996,567 96.74 9,674,345 9/30/2023 273 0.30% FHLMC 2.00% Aaa/AA+/AAA 2/28/2022 5,000,000 5,017,772 97.75 4,887,664 10/17/2023 290 1.55% Treasury 2.88% Aaa/AA+/AAA 11/22/2021 10,000,000 10,198,755 98.54 9,853,531 10/31/2023 304 0.47% FHLB 0.50% Aaa/AA+/-- 11/12/2021 5,000,000 4,999,010 96.37 4,818,280 11/9/2023 313 0.52% Treasury 0.50% Aaa/AA+/AAA 6/23/2022 5,000,000 4,887,797 96.22 4,810,890 11/30/2023 334 3.03% Treasury 2.88% Aaa/AA+/AAA 11/10/2021 5,000,000 5,110,724 98.37 4,918,493 11/30/2023 334 0.44% FHLB 0.50% Aaa/AA+/-- 12/7/2021 8,000,000 7,987,414 96.06 7,684,982 12/8/2023 342 0.67% FHLB 5.00% Aaa/AA+/-- 12/19/2022 10,000,000 10,000,000 100.01 10,000,666 12/19/2023 353 5.00% FHLB 0.63% Aaa/AA+/-- 1/5/2022 5,000,000 4,992,941 96.05 4,802,400 12/22/2023 356 0.77% FFCB 0.90% Aaa/AA+/AAA 1/28/2022 5,000,000 4,985,048 95.99 4,799,500 1/18/2024 383 1.19% Treasury 2.25% Aaa/AA+/AAA 1/5/2022 8,000,000 8,127,351 97.38 7,790,024 1/31/2024 396 0.77% Treasury 2.38% Aaa/AA+/AAA 2/14/2022 14,000,000 14,124,166 97.44 13,641,082 2/29/2024 425 1.60% FHLB 1.88% Aaa/AA+/-- 2/28/2022 15,000,000 15,045,887 96.60 14,490,726 3/8/2024 433 1.61% FAMC 2.58% 4/18/2022 10,000,000 10,000,000 97.07 9,706,750 1 4/18/2024 4741 2.58% 7 City of Round Rock Valley View Consulting,L.L.C. Holdings by Allocation and Portfolio (Fund) December 31, 2022 Coupon Settlement Face Amount/ Book Days to YTM @ Issuer Rate Credit Rating Date Shares Book Value price Market Value Maturity Date Maturity Book Treasury 2.25% Aaa/AA+/AAA 3/30/2022 10,000,000 9,975,828 96.86 9,685,641 4/30/2024 486 2.44% FAMC 2.65% 5/9/2022 3,000,000 2,997,037 97.27 2,918,009 5/2/2024 488 2.73% FFCB 2.63% Aaa/AA+/AAA 6/2/2022 3,051,000 3,049,201 97.27 2,967,577 5/3/2024 489 2.67% Treasury 2.50% Aaa/AA+/AAA 6/2/2022 7,000,000 6,984,874 97.03 6,792,211 5/31/2024 517 2.66% FHLB 3.13% Aaa/AA+/-- 6/23/2022 20,000,000 19,996,249 97.68 19,536,234 6/14/2024 531 3.14% FFCB 3.15% Aaa/AA+/AAA 7/15/2022 10,000,000 10,003,443 97.73 9,772,670 7/15/2024 562 3.13% Treasury 1.75% Aaa/AA+/AAA 9/29/2022 10,000,000 9,633,905 95.69 9,568,545 7/31/2024 578 4.18% FFCB 3.38% Aaa/AA+/AAA 8/31/2022 23,500,000 23,437,755 98.00 23,030,583 8/26/2024 604 3.54% FFCB 3.50% Aaa/AA+/AAA 9/16/2022 20,000,000 19,847,384 98.13 19,626,292 9/13/2024 622 3.97% FHLB 4.50% Aaa/AA+/-- 11/1/2022 3,000,000 2,992,013 100.17 3,005,112 10/3/2024 642 4.66% FHLB 4.50% Aaa/AA+/-- 11/1/2022 2,000,000 1,994,676 100.17 2,003,408 10/3/2024 642 4.66% Treasury 0.630/. Aaa/AA+/AAA 12/13/2022 5,000,000 4,676,862 93.43 4,671,617 10/15/2024 654 4.43% FFCB 4.38% Aaa/AA+/AAA 10/17/2022 7,000,000 7,000,714 99.66 6,976,108 10/17/2024 656 4.37% FHLB 4.53% Aaa/AA+/-- 12/14/2022 15,000,000 1 15,000,000 99.95 14,992,443 11/18/2024 688 4.53% Sub Total I Average 2.19% 472,591,838 1 472,073,020 98.52 465,586,141 1 1 303 2.24% Fund 170-Interest&Sinking GO Bonds TexasDAILY 4.13% AAArn 1 4/30/2016 28,059 1 28,059 1 100.00 28,059 N/A 1 4.13% TexPool 4.22% AAAm 9/30/2015 2,962,201 2,962,201 100.00 2,962,201 N/A 1 4.22% Sub Total/Average 4.22% 2,990,260 2,990,260 100.00 2,990,260 11 4.22% Fund 210-Interest&Sinking Debt Service JPMor an Chase 0.00% 9/30/2015 5,280 5,280 100.00 5,280 N/A 1 0.00% Sub Total/Average 0.00% 5,280 5,280 100.00 1 5,280 1 0.00% Fund 460-Bond Fund TexPool 4.22% AAAm 9/30/2015 353,707 353,707 100.00 1 353,707 N/A 1 4.22% Sub Total/Average 4.22% 353,707 353,707 100.00 353,707 1 4.22% Fund 462-2017 Bond Fund TexPool 4.22% AAAm 5/30/2017 2,006,782 2,006,782 100.00 2,006,782 N/A 1 4.22% NexBank 4.40% 3/30/2020 1,642,645 1,642,645 100.00 1,642,645 N/A 1 4.40% Treasury 2.38% Aaa/AA+/AAA 6/30/2022 6,000,000 5,999,136 99.87 5,992,123 1 1/31/2023 1 311 2.55% Sub Total/Average 3.10% 9,649,426 9,648,563 99.92 9,641,549 1 201 3.21% Fund 465-Road CO Bond Fund TexPool 4.22% AAAm 9/1/2020 8,993,179 8,993,179 100.00 8,993,179 N/A 1 4.22% Veritex Community Bank 0.30% 2/5/2021 5,629,432 5,629,432 100.00 5,629,432 2/6/2023 37 0.30% Treasury 0.13% Aaa/AA+/AAA 6/2/2022 25,000,000 24,885,335 98.99 24,747,670 3/31/2023 90 2.01% FHLB 3.63% Aaa/AA+/-- 9/9/2022 10,000,000 9,998,280 99.11 9,911,338 9/6/2023 249 3.65% Sub Total/Average 1.59% 49,622,611 49,506,226 99.31 49,281,619 100 2.55% Fund 591 -Reserves Fund TexPool 4.22% AAAm 9/30/2015 8,861 1 8,861 100.00 8,861 N/A 1 4.22% NexBank 4.40% 4/29/2019 875,014 875,014 100.00 875,014 N/A 1 4.40% Sub Total/Average 4.40% 883,876 883,876 100.00 883,876 11 4.40% Fund 602-Interest&Sinking Revenue Bonds TexPool 4.22% AAAm 9/30/2015 4,082,466 4,082,466 100.00 4,082,466 N/A Sub Total/Average 4.22% 4,082,466 4,082,466 100.00 4,082,466 Fund 604-2022 SIB Loan 8 City of Round Rock Valley View Consulting,L.L.C. Holdings by Allocation and Portfolio (Fund) December 31, 2022 Coupon Settlement Face Amount/ Book Days to YTM @ Issuer Rate Credit Rating Date Shares Book Value Price Market Value Maturity Date Maturity Book TexPool 422% AAAm 9/29/2022 2,896,378 2,896,378 100.00 2,896,378 N/A 1 4 22% American Nat'l Bank&Trust 4.36% 11/21/2022 20,088,358 20,088,358 10000 20,088,358 N/A 1 4.36% Sub Total/Average 4.34% 22,984,736 22,984,736 100.00 22,984,736 1 4.34% Fund 605-Kalahari Debt Service Reserve TexPool 4.22% AAAm 8/30/2019 1.912,072 1,912,072 10000 1,912,0721 N/A 11 4.22°/o Sub Total/Average 4.22% 1,912,072 1,912,072 100.00 1,912,072 1 11 4.22% Total/Average 2.28% $ 565,076,271 $ 564,440,204 98.70 $ 557,721,705 2631 2.41% 9 City of Round Rock Valley View Consulting, L.L.C. Book Value Comparison December 31, 2022 Issuer Coupon Settlement Maturity Beginning Book Total Buys/ Total Sells/ Ending Book Change in Book Rate Date Date Value Increases Decreases Value Value Fund 000-Pooled Investments JPMor an Chase N/A 9/30/2015 N/A $ 10,488,641 $ 4,245,073 $ 4,819,659 $ 9,914,055 $ 574,586 TexPool N/A 9/30/2015 N/A 14,249,176 34,003 001 9,473,801 38,778,376 24,529,200 TexSTAR N/A 9/30/2015 N/A 201,831 1,765 — 203,596 1,765 TexasDAILY N/A 9/30/2015 N/A 2,277,545 20,775 — 2,298,320 20,775 TexasDAILY N/A 6/1/2021 N/A 2,438 22 — 2,460 22 TexasDAILY Select N/A 12/3/2021 N/A 5,033 332 48,384 — 5,081 716 48,384 NexBank N/A 11/29/2016 N/A 22,945,659 212,569 — 23,158,229 212,569 Veritex Community Bank N/A 9/1/2020 N/A 190,047 2,148 — 192,194 2,148 State of Texas 2.52% 10/14/2021 10/1/2022 5,000,323 — 5,000,000 — 5,000,323 State of Texas 1.61% 3/19/2021 10/1/2022 3,250,130 — 3250,000 — 3,250,130 Prosperity Bank 0.40% 10/15/2020 10/17/2022 6046,183 — 6,046,183 — 6,046,183 Veritex Community Bank 0.26% 2/5/2021 11/4/2022 31011,687 — 3,011,687 — (3,011,687 Prosperity Bank 0.20% 2/12/2021 11/14/2022 3,009,499 495 3,009,994 — M(4,O14,333) 9 R Bank 0.48% 11/24/2021 11/23/2022 4,014 333 — 4,014.333 — Bank OZK 0.28% 12/7/2020 12/7/2022 5,024,655 2,360 5,027,015 — 5 Prosperity Bank 0.20% 6/9/2021 12/9/2022 10,025,070 3,351 10,028,422 — 0 Veritex CommunityBank 0.28% 1/6/2021 1/6/2023 4,016,783 2,835 — 4,019,6185 R Bank 0.57% 7/6/2021 1/6/2023 1,005,736 1,451 — 1,007,187 1 Treasu 0.13% 1/5/2022 1/31/2023 4,994,900 — — 4,998,7154 San Antonio TX Elec. 2.41% 4/13/2022 2/1/2023 500,000 — — 500 000 — Veritex Community Bank 0.30% 2/5/2021 2/6/2023 4,419,783 3,342 — 4,423,125 3,342 FFCB 0.16% 11/22/2021 2/10/2023 4,998,207 — — 4,999,447 1240 Eagle Pass Texas 4.00% 6/7/2021 3/1/2023 655,193 — — 649,024 6,170 Prosperity Bank 0.25% 3/5/2021 3/6/2023 10,037,670 6,258 — 10,043,927 6,258 Bank OZK 0.26% 3/8/2021 3/8/2023 2,539,034 1,653 — 2,540 686 1,653 FFCB 0.13% 3/26/2021 3/23/2023 8,998,923 — — 8,999 492 569 Prosperity Bank 0.20% 4/12/2021 4/12/2023 5,014,211 2,501 — 5,016,711 2,501 FFCB 0.13% 4/13/2021 4/13/2023 4,998,237 — — 4,999,069 832 FFCB 0.38% 1/28/2022 4/27/2023 3,988,076 — — 3,993,325 5,249 Prosperity Bank 0.20% 5/19/2021 5/19/2023 10,026,773 5,000 — 10,031,774 5,000 FNMA 0.25% 6/23/2022 5/22/2023 4,916,690 — — 4,949,444 32,754 Veritex Community Bank 0.20% 6/1/2021 6/1/2023 20,050,132 9,998 — 20 060,130 9,998 Bank OZK 0.20% 6/9/2021 6/9/2023 8,020,157 4,020 — 8,024,176 4,020 R Bank 0.70% 7/6/2021 7/6/2023 1,007,045 1,783 — 1,008,828 1 783 Treasury 1.25% 7/7/2021 7/31/2023 8,068,289 — — 8,047,623 20,666 Veritex Community Bank 0.25% 7/30/2021 7/31/2023 7,017,516 4,422 — 7,021,938 4,422 Arlington TX HGR EDU 0.63% 4/28/2021 8/15/2023 1,460,000 — — 1,460,000 — Dallas ISD 4.00% 4/22/2021 8/15/2023 4,331 576 — — 4,292,187 (39,389) Veritex Community Bank 0.25% 8/23/2021 8/23/2023 4,411,010 2,780 — 4,413,790 2,780 FHLMC 0.25% 1/28/2022 8/24/2023 4,964,520 — — 4,974,472 9 952 FHLB 0.00% 8/31/2022 8/28/2023 4,844,606 — — 4,887,667 43,061 FNMA 2.88% 3/30/2022 9/12/2023 4,024,959 — — 4,018,342 6 617 Treasury 0.25% 9/30/2021 9/30/2023 9,995,410 — — 9,996,567 1,157 FHLMC 2.00% 2/28/2022 10/17/2023 5,023,410 — — 5,017,772 5,638 Treasury 2.88% 11/22/2021 10/31/2023 10,258,905 — — 10,198,755 60,150 FHLB 0.50% 11/12/2021 11/9/2023 4,998,719 — — 4,999 010 291 Treasury 2.88% 11/10/2021 11/30/2023 5141,223 — — 5,110724 30,499 Treasury 0.50% 6/23/2022 1 11/30/2023 1 41856,891 — — 4,887,797 30,906 FHLB 0.50% 12/7/2021 12/8/2023 7,984,028 — — 7,987,414 3,386 FHLB 5.00% 12/19/2022 12/19/2023 — 10,000,OOOT 10,000,000 10 000,000 FHLB 0.63% 1/5/2022 12/22/2023 4,991,117 — — 4,992,941 1824 FFCB 0.90% 1/28/2022 1/18/2024 4 981 456 — — 4,985,048 3,592 10 City of Round Rock Valley View Consulting,L.L.C. Book Value Comparison December 31, 2022 Issuer Coupon Settlement Maturity Beginning Book Total Buys/ Total Sells/ Ending Book Change in Book Rate Date Date Value Increases Decreases Value Value Treasury 2.25% 1/5/2022 1/31/2024 8,156,938 - - 8,127,351 29,587 Treasury 2.38% 2/14/2022 2/29/2024 14,151,045 - - 14,124,166 26,878 FHLB 1.88% 2/28/2022 3/8/2024 15,055,637 - - 15,045,887 9,750 FAMC 2.58% 4/18/2022 4/18/2024 1 10,000,000 - - 10,000,000 - Treasury 2.25% 3/30/2022 4/30/2024 9,971,252 - - 9,975,828 4,576 FAMC 2.65% 5/9/2022 5/2/2024 2,996,479 - - 2,997,03 559 FFCB 2.63% 6/2/2022 5/3/2024 3,048,862 - - 3,049,201 338 Treasury 2.50% 6/2/2022 5/31/2024 6,982,183 - - 6 984,874 2.692 FHLB 3.13% 6/23/2022 6/14/2024 19,995,599 - - 19,996,249 650 FFCB 3.15% 7/15/2022 7/15/2024 10,004,007 - - 10,003,443 564 Treasury 1.75% 9/29/2022 7/31/2024 9,575,633 - - 9,633,905 58,271 FFCB 3.38% 8/31/2022 8/26/2024 23,428,274 - - 23,437,755 9,481 FFCB 3.50% 9/16/2022 9/13/2024 19,824,811 - - 19,847,384 22,573 FHLB 4.50% 11/1/2022 10/3/2024 - 1,994,928 - 1,994,676 1994,676 FHLB 4.50% 11/1/2022 10/3/2024 - 2,992,392 - 2,992,013 2,992,013 Treasury 0.63% 1 12/13/2022 10/15/2024 - 4,673,034 - 4,676,862 4,676,862 FFCB 4.38% 10/17/2022 10/17/2024 - 7,000,796 - 7,000,714 7,000,714 FHLB 4.53% 12/14/2022 11/18/2024 - 15,000,000 - 15,000,000 15,000,000 Sub Total/Average Fund 000-Pooled Investments 445,502,455 80,247,135 1 53,681,093 1 472,073,020 1 26,570,565 Fund 170-Interest&Sinking GO Bonds TexPool N/A 9/30/2015 N/A 1,338,789 1,944,806 321,394 2,962,201 1,623,412 TexasDAILY N/A 4/30/2016 N/A 27,805 1 254 1 - 28,059 254 Sub Total/Average Fund 170-Interest&Sinking GO Bonds 1,366,595 1,945,059 321,3941 2,990,260 1 1,623,666 Fund 210-Interest&Sinking Debt Service JPMor an Chase N/A 9/30/2015 N/A 6,780 - 1,500 5,280 1,500 Sub Total/Average Fund 210-Interest&Sinking Debt Service 6,780 - 1,500 5,280 1,500 Fund 460-Bond Fund TexPool N/A 9/30/2015 N/A 883,047 4,498 533,839 353,707 529,341 Sub Total/Average Fund 460-Bond Fund 883,047 4,498 533,839 353,707 529,341 Fund 462-2017 Bond Fund TexPool N/A 5/30/2017 N/A 2,016,724 18,063 28,006 2,006,782 9,942 NexBank N/A 3/30/2020 N/A 1627,567 15,078 - 1,642,645 15,078 Treasury 2.38% 6/30/2022 1/31/2023 5,996,573 - - 5,999,136 2,563 Sub Total/Average Fund 462-2017 Bond Fund 9,640,864 33,141 28,0061 9,648,563 7,699 Fund 465-Road CO Bond Fund TexPool N/A 9/1/2020 N/AE24,768,121 85,714 2,603,444 8,993,179 2517,730 Veritex CommunityBank 0.30% 2/5/2021 2/6/2023 4,254 - 5,629,432 4,254 Treasury0.13% 6/2/2022 3/31/2023 - - 24,885,335 117213FHLB 3.63% 9/9/2022 9/6/2023 - - 9,998,280 635 Sub Total/Avera a Fund 465-Road CO Bond Fund 89,968 2,603,444 49,506,226 2,395,628 Fund 591 -Reserves Fund TexPool N/A 9/30/2015 N/A 8,7841 78 - 8,861 78 NexBank N/A 4/29/2019 N/A 866,983 1 8,032 1 875,014 1 8,032 Sub Total/Average Fund 591 -Reserves Fund 875,766 1 8,110 - 883,876 8,110 Fund 602-Interest&Sinking Revenue Bonds TexPool N/A 9/30/2015 N/A 2,195,826 1,886,640 - 4,082,466 1,886,640 Sub Total/Average Fund 602-Interest&Sinking Revenue Bonds 2,195,826 1,886,640 - 4,082,466 1,886,640 11 City of Round Rock Valley View Consulting, L.L.C. Book Value Comparison December 31, 2022 Issuer Coupon Settlement Maturity Beginning Book Total Buys/ Total Sells/ Ending Book Change in Book Rate Date Date Value Increases Decreases Value Value Fund 604-2022 SIB Loan TexPool N/A 9/29/2022 N/A 22,782,359 114,018 20,000,000 2,896,378 19,885,982 American Nat'l Bank&Trust N/A 11/21/2022 N/A - 20,088,358 - 20.088,358 Sub Total/Average Fund 604-2022 SIB Loan 22,782,359 20,202,377 20,000,000 22,984,736 202,377 Fund 605-Kalahari Debt Service Reserve TexPool N/A 8/30/2019 N/A 259,953 1,652,119 - 1,912,072 1,652,119 Sub Total/Average Fund 605-Kalahari Debt Service Reserve 259,953 1,652,119 - 1,912,072 1,652,119 Total/Average $ 535,415,498 $ 106,069,047 $ 77,169,276 $ 564,440,204 $ 29,024,706 12 City of Round Rock Valley View Consulting, L.L.C. Market Value Comparison December 31, 2022 Issuer Coupon Settlement Maturity Beginning Total Buys/ Total Sells/ Ending Market Change in Rate Date Date Market Value Increases Decreases Value Market Value Fund 000-Pooled Investments JPMor an Chase N/A 9/30/2015 N/A $ 10,488,641 $ 4,245,073 $ 4.819,659 $ 9,914,055 $ — TexPool N/A 9/30/2015 N/A 14,249,176 34,003,001 9,473,801 38,778,376 — TexSTAR N/A 9/30/2015 N/A 201,831 1,765 — 203,596 — TexasDAILY N/A 9/30/2015 N/A 2,277,545 20,775 — 2,298,320 — TexasDAILY N/A 6/1/2021 N/A 2,438 22 — 2,460 — TexasDAILY Select N/A 12/3/2021 N/A 5,033,332. 48.384 — 5,081,716 — NexBank N/A 11/29/2016 N/A 22,945,659 212,569 — 23,158,229 — Veritex Community Bank N/A 9/1/2020 N/A 190,047 2,148 — 192,194 — State of Texas 2.52% 10/14/2021 10/1/2022 5,000,000 — 5,000,000 — — State of Texas 1.61% 3/19/2021 10/1/2022 3,250,000 — 3,250,000 — — Prosperity Bank 0.40% 10/15/2020 10/17/2022 6,046,183 — 6046,183 — — Veritex Community Bank 0.26% 2/5/2021 11/4/2022 3,011,687 — 3,011,687. — — Prosperity Bank 0.20% 2/12/2021 11/14/2022 3,009,499 495 3,009,994 — — R Bank 0.48% 11/24/2021 11/23/2022 4,014,333 — 4,014,333 — — Bank OZK 0.28% 12/7/2020 12/7/2022 5,024,655 2,360 5,027,015 —Prosperity Bank 0.20% 6/9/2021 12/9/2022 10,025,070 3,351 10,028,422 — — Veritex Community Bank 0.28% 1/6/2021 1/6/2023 4,016,783 2,835 — 4,019,618 — R Bank 0.57% 7/6/2021 1/6/2023 1,005,736 1,451 — 1,007,187 — Treasu 0.13% 1/5/2022 1/31/2023 4,940,430 — — 4,984,461 44,031 San Antonio TX Elec. 2.41% 4/13/2022 2/1/2023 497,275 — — 499,075 1,800 Veritex Community Bank 0.30% 2/5/2021 2/6/2023 4,419,783 3,342 — 4,423,125 — FFCB 0.16% 11/22/2021 2/10/2023 4,930,832 — — 4,977007 46,175 Eagle Pass Texas 4.00% 6/7/2021 3/1/2023 646,974 — — 645,787 1,187 Prosperity Bank 0.25% 3/5/2021 3/6/2023 10,037,670 6,258 — 10,043,927 — Bank OZK 0.26% 3/8/2021 3/8/2023 2,539,034 1,653 — 2,540,686 — FFCB 0.13% 3/26/2021 3/23/2023 8,842,386 — — 8,914,039 71,654 Prosperity Bank 0.20% 4/12/2021 4/12/2023 5,014,211 2,501 — 5,016,711 — FFCB 0.13% 4/13/2021 4/13/2023 4,897,194 — — 4,938,286 41,093 FFCB 0.38% 1/28/2022 4/27/2023 3,918,332 — — 3,947,658 29,326 Prosperity Bank 0.20% 5/19/2021 5/19/2023 10,026,773 5,000 — 10,031,774 — FNMA 0.25% 6/23/2022 5/22/2023 4,880,122 — — 4,914,617 34,495 Veritex Community Bank 0.20% 6/1/2021 6/1/2023 20,050 132 9.998 — 20,060.130 — Bank OZK 0.20% 6/9/2021 6/9/2023 8,020,157 4,020 — 8,024 176 — R Bank 0.70% 7/6/2021 7/6/2023 1 1,007,045 1,783 — 1,008,828 — Treasu 1.25% 7/7/2021 7/31/2023 7,806,875 — — 7,843,393 36,518 Veritex Community Bank 0.25% 7/30/2021 7/31/2023 7,017,516 4,422 — 7,021,938 — Arlin ton TX HGR EDU 0.63% 4/28/2021 8/15/2023 1,413,397 — — 1,422,274 8,877 Dallas ISD 4.00% 4/22/2021 8/15/2023 4,190,008 — — 41182667 7,341 Veritex Community Bank 0.25% 8/23/2021 8/23/2023 4,411,010 2,780 — 4,413,790 — FHLMC 0.25% 1/28/2022 8/24/2023 4,825 811 — — 4,858,171 32,360 FHLB 0.00% 8/31/2022 8/28/2023 4,803,950 — — 4,844,950 41,000 FNMA 2.88% 3/30/2022 9/12/2023 31943,184 — 3 947 138 3 954 Treasury 0.25% 9/30/2021 9/30/2023 9,607,422 — — 9,674,345 66,923 FHLMC 2.00% 2/28/2022 10/17/2023 4,876,889 — — 4,887,664 10 775 Treasury 2.88% 11/22/2021 10/31/2023 9,851,953 — — 9,853,531 1,578 FHLB 0.50% 11/12/2021 11/9/2023 4,800,440 — — 4,818 280 17,840 Treasury 2.88% 11/10/2021 11/30/2023 4,918,360 — — 4,918,493 134 Treasury 0.50% 6/23/2022 11/30/2023 4,786,133 — — 4,810,890 24,757 FHLB 0.50% 12/7/2021 12/8/2023 7,657,694 — — 7,684,982 27,288 FHLB 5.00% 12/19/2022 12/19/2023 — 10,000,000 — 10,000,666 666 FHLB 0.63% 1/5/2022 12/22/2023 4,785,873 — — 4,802 400 1 16,528 FFCB 0.90% 1/28/2022 1/18/2024 4,790,585 1 4,799,500 8,915 13 City of Round Rock Valley View Consulting, L.L.C. Market Value Comparison December 31, 2022 Issuer Coupon Settlement Maturity Beginning Total Buys/ Total Sells/ Ending Market Change in Rate Date Date Market Value Increases Decreases Value Market Value Treasury 2.25% 1/5/2022 1/31/2024 7,786,562 - - 7,790,024 3462 Treasury 2.38% 2/14/2022 2/29/2024 13 628,125 - - 13641'082 12 957 FHLB 1.88% 2/28/2022 3/8/2024 14,533,034 - - 14,490,726 42,308 FAMC 2.58% 4/18/2022 4/18/2024 1 9,725,270 - - 9,706 750 18,520 Treasury 2.25% 3/30/2022 4/30/2024 9,682,031 - - 9,685,641 3,610 FAMC 2.65% 5/9/2022 5/2/2024 2,924,591 - - 2,918,009 6,582 FFCB 2.63% 6/2/2022 5/3/2024 2,973,274 - - 2,967,577 (5,698) Treasury 2.50% 6/2/2022 5/31/2024 6,798,203 - - 6,792 211 (5,993) FHLB 3.13% 6/23/2022 6/14/2024 19,582,496 - - 19,536,234 46,262 FFCB 3.15% 7/15/2022 7/15/2024 9,793,950 - - 9,772,670 21,280 Treasury 1.75% 9/29/2022 7/31/2024 9,558,203 - - 9,568,545 10,342 FFCB 3.38% 8/31/2022 8/26/2024 23,098,604 - - 23,030,583 68,021 FFCB 3.50% 9/16/2022 9/13/2024 19,676,132 - - 19,626,292 49,840 FHLB 4.50% 11/1/2022 10/3/2024 - 1,994,928 - 2,003408 9,230 FHLB 4.50% 11/1/2022 10/3/2024 - 2,992,392 - 3,005,112 13,845 Treasury 0.63% 1 12/13/2022 10/15/2024 - 4,673,034 - 4,671,617 3,648 FFCB 4.38% 10/17/2022 10/17/2024 - 7,000,796 - 6,976,108 24,688 FHLB 4.53% 12/14/2022 11/18/2024 - 1 15,000,000 - 14,992,443 7,557 Sub Total/Average Fund 000-Pooled Investments 438,708,537 1 80,247,1351 53,681,093 465,586,141 318,503 Fund 170-Interest&Sinking GO Bonds TexPool N/A 9/30/2015 N/A 1,338,789 1,944,806 1 321,394 1 2,962,201 - TexasDAILY N/A 4/30/2016 N/A 27,805 254 1 - 28,059 1 - Sub Total/Average Fund 170-Interest&Sinking GO Bonds 1,366,595 1,945,059 1 321,394 2,990,260 1 - Fund 210-Interest&Sinking Debt Service JPMor an Chase N/A 9/30/2015 N/A 6,780 - 1,500 5,280 - Sub Total/Average Fund 210-Interest&Sinking Debt Service 6,780 - 1,500 5,280 - Fund 460-Bond Fund TexPool N/A 9/30/2015 N/A 883,047 4,498 533,839 353,707 - Sub Total/Average Fund 460-Bond Fund 883,047 4,498 533,839 353,707 - Fund 462-2017 Bond Fund TexPool N/A 5/30/2017 N/A 2,016,724 18,063 28,006 2,006,782 - NexBank N/A 3/30/2020 N/A 1,627 567 1 15,078 - 1,642,645 - Treasury 2.38% 6/30/2022 1/31/2023 1 5,971,640 1 - - i5,992,123 20,482 Sub Total/Average Fund 462-2017 Bond Fund 9,615,931 1 33,141 28,006 9,641,549 20,482 Fund 465-Road CO Bond Fund TexPool N/A 9/1/2020 N/A 11510,910 85,714 2,603,444 8,993179 - Veritex CommunityBank 0.30% 2/5/2021 2/6/2023 5,625,178 4,254 - 5,629,432 - Treasu 0.13% 6/2/2022 3/31/2023 24,539 063 - - 24 747,670 208,608 FHLB 3.63% 9/9/2022 9/6/2023 9,931,363 - - 91911,338 20,025 Sub Total/Average Fund 465-Road CO Bond Fund 51,606,513 89,968 2,603,444 49,281,619 188,583 Fund 591-Reserves Fund TexPool N/A 9/30/2015 N/A 8,784 1 78 - 8,861 - NexBank N/A 4/29/2019 N/A 866,983 8,032 - 875,014 - Sub Total/Average Fund 591 -Reserves Fund 875,766 8,110 - 883,876 - Fund 602-Interest&Sinking Revenue Bonds TexPool N/A 9/30/2015 N/A 2,195,826 1,886,640 - 4,082,466 - Sub Total/Average Fund 602-Interest&Sinking Revenue Bonds 2,195,826 1,886,640 - 4,082,466 - 14 City of Round Rock Valley View Consulting,L.L.C. Market Value Comparison December 31, 2022 Issuer Coupon Settlement Maturity Beginning Total Buys/ Total Sells/ Ending Market Change m Rate Date Date Market Value Increases Decreases Value Market Value Fund 604-2022 SIB Loan TexPool N/A 9/29/2022 N/A 1 22,782,359 114,018 20,000,000 2,896,3781 - American Nat'l Bank&Trust N/A 11/21/2022 N/A - 20,088,358 - 20,088,358 - Sub Total/Average Fund 604-2022 SIB Loan 22,782,359 20,202,377 20,000,000 22,984,736 - Fund 605-Kalahari Debt Service Reserve TexPool N/A 8/30/2019 N/A 259,953 1,652,119 1 - 1,912,072 - Sub Total/Average Fund 605-Kalahari Debt Service Reserve 259,953 1,652,119 - 1,912,072 Total/Average $ 528,301,307 $ 106,069,047 $ 77,169,276 $ 557,721,705 $ 527,567 15 City of Round Rock Valley View Consulting, L.L.C. Holdings by Allocation and Portfolio (Fund) September 30, 2022 Coupon Settlement Face Amount/ Market Days to YTM Issuer Rate Credit Rating Date Shares Book Value Price Market Value Maturity Date Maturity Book Fund 000-Pooled Investments NexBank 3.05% 11/29/2016 $ 22,945,659 $ 22,945,659 100.00 $ 22,945,659 N/A 1 3.05% TexasDAILY 2.43% AAAm 6/1/2021 2,438 2,438 100.00 2,438 N/A 1 2.43% TexasDAILY Select 2.72% AAAm 12/3/2021 5,033,332 5,033,332 100.00 5,033,332 N/A 1 2.72% Veritex Community Bank 3.08% 9/1/2020 190,047 190,047 100.00 190,047 N/A 1 3.08% JPMor an Chase 0.40% 9/30/2015 10,488,641 10,488,641 100.00 10,488,641 N/A 1 0.40% TexSTAR 2.29% AAAm 9/30/2015 201,831 201,831 100.00 201,831 N/A 1 2.29% TexPool 2.41% AAAm 9/30/2015 14,249,176 14,249,176 100.00 14,249,176 N/A 1 2.41% TexasDAILY 2.43% AAAm 9/30/2015 2,277,545 2,277,545 100.00 2,277,545 N/A 1 2.43% State of Texas 1.61% Aaa/AAA/- 3/19/2021 3,250,000 3,250,130 100.00 3,250,000 10/1/2022 1 0.15% State of Texas 2.52% Aaa/AAA/- 10/14/2021 5,000,000 5,000,323 100.00 5,000,000 10/1/2022 1 0.15% Prosperity Bank 0.40% 10/15/2020 6,046,183 6,046,183 100.00 6,046,183 10/17/2022 17 0.40% Veritex Community Bank 0.26% 2/5/2021 3,011,687 3,011,687 100.00 3,011,687 11/4/2022 35 0.26% Prosperity Bank 0.20% 2/12/2021 3,009,499 3,009,499 100.00 3,009,499 11/14/2022 45 0.20% R Bank 0.48% 11/24/2021 4,014,333 4,014,333 100.00 4,014,333 11/23/2022 54 0.48% Bank OZK 0.28% 12/7/2020 5,024,655 5,024,655 100.00 5,024,655 12/7/2022 68 0.28% Prosperity Bank 0.20% 6/9/2021 10,025,070 10,025,070 100.00 10,025,070 12/9/2022 70 0.20% Veritex Community Bank 0.28% 1/6/2021 4,016,783 4,016,783 100.00 4,016,783 1/6/2023 98 0.28% R Bank 0.57% 7/6/2021 1,005,736 1,005,736 100.00 1,005,736 1/6/2023 98 0.57% Treasury 0.13% Aaa/AA+/AAA 1/5/2022 5,000,000 4,994,900 98.81 4,940,430 1/31/2023 123 0.43% San Antonio TX Elec. 2.41% Aa2/AA-/AA- 4/13/2022 500,000 500,000 99.46 497,275 2/1/2023 124 2.41% Veritex Community Bank 0.30% 2/5/2021 4,419,783 4,419,783 100.00 4,419,783 2/6/2023 129 0.30% FFCB 0.16% Aaa/AA+/AAA 11/22/2021 5,000,000 4,998,207 98.62 4,930,832 2/10/2023 133 0.26% Eagle Pass Texas 4.00% -/AA-/- 6/7/2021 645,000 655,193 100.31 646,974 3/1/2023 152 0.20% Prosperity Bank 0.25% 3/5/2021 10,037,670 10,037,670 100.00 10,037,670 3/6/2023 157 0.25% Bank OZK 0.26% 3/8/2021 2,539,034 2,539,034 100.00 2,539,034 3/8/2023 159 0.26% FFCB 0.13% Aaa/AA+/AAA 3/26/2021 9,000,000 8,998,923 98.25 8,842,386 3/23/2023 174 0.15% Prosperity Bank 0.20% 4/12/2021 5,014,211 5,014,211 100.00 5,014,211 4/12/2023 194 0.20% FFCB 0.13% Aaa/AA+/AAA 4/13/2021 5,000,000 4,998,237 97.94 4,897,194 4/13/2023 195 0.19% FFCB 0.38% Aaa/AA+/AAA 1/28/2022 4,000,000 3,988,076 97.96 3,918,332 4/27/2023 209 0.90% Prosperity Bank 0.20% 5/19/2021 10,026,773 10,026,773 100.00 10,026,773 5/19/2023 231 0.20% FNMA 0.25% Aaa/AA+/AAA 6/23/2022 5,000,000 4,916,690 97.60 4,880,122 5/22/2023 234 2.90% Veritex Community Bank 0.20% 6/1/2021 20,050,132 20,050,132 100.00 20,050,132 6/1/2023 244 0.20% Bank OZK 0.20% 6/9/2021 8,020,157 8,020,157 100.00 8,020,157 6/9/2023 252 0.20% R Bank 0.70% 7/6/2021 1,007,045 1,007,045 100.00 1,007,045 7/6/2023 279 0.70% Treasury 1.25% Aaa/AA+/AAA 7/7/2021 8,000,000 8,068,289 97.59 7,806,875 7/31/2023 304 0.22% Veritex Community Bank 0.25% 7/30/2021 7,017,516 7,017,516 100.00 7,017,516 7/31/2023 304 0.25% Dallas ISD 4.00% Aaa/AAA/AAA 4/22/2021 4,195,000 4,331,576 99.88 4,190,008 8/15/2023 319 0.26% Arlington TX HGR EDU 0.63% -/AAA/- 4/28/2021 1,460,000 1,460,000 96.81 1,413,397 8/15/2023 319 0.63% Veritex Community Bank 0.25% 8/23/2021 4,411,010 4,411,010 100.00 4,411,010 8/23/2023 327 0.25% FHLMC 0.25% Aaa/AA+/AAA 1/28/2022 5,000,000 4,964,520 96.52 4,825,811 8/24/2023 328 1.05% FHLB 0.00% Aaa/AA+/-- 8/31/2022 5,000,000 4,844,606 96.08 4,803,950 8/28/2023 332 3.51% FNMA 2.88% Aaa/AA+/AAA 3/30/2022 4,000,000 4,024,959 98.58 3,943,184 9/12/2023 347 2.20% Treasury 0.25% Aaa/AA+/AAA 9/30/2021 10,000,000 9,995,410 96.07 9,607,422 9/30/2023 365 0.30% FHLMC 2.00% Aaa/AA+/AAA 2/28/2022 5,000,000 5,023,410 97.54 1 4,876,889 10/17/2023 382 1.55% Treasury 2.88% Aaa/AA+/AAA 11/22/2021 10,000,000 10,258,905 98.52 9,851,953 10/31/2023 396 0.47% FHLB 0.50% Aaa/AA+/-- 11/12/2021 5,000,000 4,998,719 96.01 4,800,440 11/9/2023 405 0.52% JTreasury 0.50% Aaa/AA+/AAA 6/23/2022 5,000,000 4,856,891 95.72 4,786,133 11/30/2023 426 3.03% Treasu 2.889/. Aaa/AA+/AAA 11/10/2021 5,000,000 5,141,223 98.37 4,918,360 11/30/2023 426 0.44% 16 City of Round Rock Valley View Consulting, L.L.C. Holdings by Allocation and Portfolio (Fund) September 30, 2022 Coupon Settlement Face Amount/ Book Days to YTM @ Issuer Rate Credit Rating Date Shares Book Value Price Market Value Maturity Date Maturity Book FHLB 0.50% Aaa/AA+/-- 12/7/2021 8,000,000 7,984,028 95.72 7,657,694 12/8/2023 434 0.67% FHLB 0.63% Aaa/AA+/-- 1/5/2022 5,000,000 4,991,117 95.72 4,785,873 12/22/2023 448 0.77% FFCB 0.90% Aaa/AA+/AAA 1/28/2022 5,000,000 4,981,456 95.81 4,790,585 1/18/2024 475 1.19% Treasury 2.25% Aaa/AA+/AAA 1/5/2022 8,000,000 8,156,938 97.33 7,786,562 1/31/2024 488 0.77% Treasury 2.38% Aaa/AA+/AAA 2/14/2022 14,000,000 14,151,045 97.34 13,628,125 2/29/2024 517 1.60% FHLB 1.88% Aaa/AA+/-- 2/28/2022 15,000,000 15,055,637 96.89 14,533,034 3/8/2024 525 1.61% FAMC 2.58% 4/18/2022 10,000,000 10,000,000 97.25 9,725,270 4/18/2024 566 2.58% Treasury 2.25% Aaa/AA+/AAA 3/30/2022 10,000,000 9,971,252 96.82 9,682,031 4/30/2024 578 2.44% FAMC 2.65% 5/9/2022 3,000,000 2,996,479 97.49 2,924,591 5/2/2024 580 2.73% FFCB 2.63% Aaa/AA+/AAA 6/2/2022 3,051,000 3,048,862 97.45 2,973,274 5/3/2024 581 2.67% Treasury 2.50% Aaa/AA+/AAA 6/2/2022 7,000,000 6,982,183 97.12 6,798,203 5/31/2024 609 2.66% FHLB 3.13% Aaa/AA+/-- 6/23/2022 20,000,000 19,995,599 97.91 19,582,496 6/14/2024 623 3.14% FFCB 3.15% Aaa/AA+/AAA 7/15/2022 10,000,000 10,004,007 97.94 9,793,950 7/15/2024 654 3.13% Treasury 1.75% Aaa/AA+/AAA 9/29/2022 10,000,000 9,575,633 95.58 1 9,558,203 7/31/2024 670 4.18% FFCB 3.38% Aaa/AA+/AAA 8/31/2022 23,500,000 23,428,274 98.29 1 23,098,604 8/26/2024 696 3.54% FFCB 3.50% Aaa/AA+/AAA 1 9/16/2022 20,000,000 19,824,811 98.38 19,676,132 9/13/2024 714 3.97% Sub Total/Average 1 1.61% 1 1 445,686,946 445,502,455 98.43 438,708,537 341 1.58% Fund 170-Interest&Sinking GO Bonds TexasDAILY 2.43% AAArn 4/30/2016 27,805 27,805 100.00 27,805 N/A 11 2.43% TexPool 2.41% AAArn 1 9/30/2015 1 1,338,789 1 1,338,789 1 100.00 1 1,338,789 1 N/A 11 2.41% Sub Total/Average 1 2.41% 1,366,595 1 1,366,595 1 100.00 1 1,366,595 11 2.41% Fund 210-Interest&Sinking Debt Service JPMor an Chase 1 0.40% 9/30/2015 6,780 1 6,780 1 100.00 6,780 N/A 1 0.40% Sub Total/Average 1 0.40% 6,780 1 6,780 1 100.00 6,780 1 0.40% Fund 460-Bond Fund TexPool 2.41% AAArn 9/30/2015 883,047 1 883,047 1 100.00 883,047 N/A Sub Total/Average 2.41% 883,047 1 883,047 1 100.00 883,047 1 2.41% Fund 462-2017 Bond Fund TexPool 2.41% AAAm 5/30/2017 2,016,724 1 2,016,724 1 100.00 I 2,016,724 N/A 1 2.41% NexBank 3.05% 3/30/2020 1,627,567 1,627,567 1 100.00 1 1,627,567 N/A 1 3.05% Treasury 2.38% Aaa/AA+/AAA 6/30/2022 6,000,000 5,996,573 99.53 5,971,640 1/31/2023 123 2.55% Sub Total/Average 2.50% 9,644,291 9,640,864 99.71 9,615,931 77 2.600/. Fund 465-Road CO Bond Fund TexPool 2.41% AAArn 9/1/2020 11,510,910 11,510,910 100.00 11,510,910 N/A 1 2.41% Veritex Community Bank 0.30% 2/5/2021 5,625,178 5,625,178 100.00 5,625,178 2/6/2023 129 0.30% Treasury 0.13% Aaa/AA+/AAA 6/2/2022 25,000,000 24,768,121 98.16 24,539,063 3/31/2023 182 2.01% FHLB 3.63% Aaa/AA+/-- 9/9/2022 10,000,000 9,997,645 99.31 9,931,363 9/6/2023 341 3.65% Sub Total/Average 1.32% 52,136,088 51,901,854 98.98 51,606,513 167 2.23% Fund 591 -Reserves Fund TexPool 2.41% AAArn 1 9/30/2015 8,784 1 8,784 1 100.00 8,784 N/A 11 2.41% NexBank 3.05% 4/29/2019 866,983 866,983 100.00 866,983 N/A 11 3.05% Sub Total/Average 3.04% 875,766 875,766 100.00 875,766 11 3.04% Fund 602-Interest&Sinking Revenue Bonds TexPool 2.41% AAArn 9/30/2015 2,195,826 2,195,826 100.00 2,195,826 N/A 17 City of Round Rock Valley View Consulting, L.L.C. Holdings by Allocation and Portfolio (Fund) September 30, 2022 Coupon Settlement Face Amount/ Book Days to YTM @ Issuer Credit Rating Book Value Market Value Maturity Date Rate Date Shares Price Maturity Book Sub Total/Average 2.41% 2,195,826 2,195,826 100.00 2,195,826 1 2.41% Fund 604-2022 SIB Loan TexPool 2.41% AAAm 1 9/29/2022 1 22,782,359 1 22,782,359 1 100.00 1 22,782,359 1 N/A 11 2.41% Sub Total/Average 2.41% 1 1 22,782,359 1 22,782,359 1 100.00 1 22,782,359 1 11 2.41% Fund 605-Kalahari Debt Service Reserve TexPool 2.41% AAAm 1 8/30/2019 1 259,953 259,953 100.00 259.953 N/A 1 2.41% Sub Total/Average 2.41% 1 1 259,953 259,953 100.00 259,953 1 2.41% Total/Average 1.64% 1 1 $ 535,837,650 $ 535,415,498 98.59 $ 528,301,307 3021 1.71% 18 City of Round Rock Valley View Consulting, L.L.C.