Loading...
Contract - City of Round Rock - 12/1/2022 ROUND ROCK TEXAS FINANCE QUARTERLY INVESTMENT REPORT For the Quarter Ended September 30, 2022 Prepared by Valley View Consulting, L.L.C. The investment portfolio of the City of Round Rock, Texas is in compliance with the Public Funds Investment Act and the Investment Policy and Strategies. Chie—fFinancialofAwr Dep ty Chief Financial dficer 9�- �4 Controller Trea 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 tees. R- 2022--390 City of Round Rock, Texas Annual Comparison of Portfolio Performance FYE Results by Investment Category: September 30, 2021 September 30, 2022 Asset Type Ave.Yield Book Value Market Value Ave.Yield Book Value Market Value Cash 0.14% $ 20,388,226 $ 20,388,226 0.40% $ 10,495,420 $ 10,495,420 Certificates of Deposit 0.53% 295,898,976 295,898,976 0.26% 114,322,455 114,322,455 Local Government Investment Pool 0.03% 27,503,126 27,503,126 2.44% 62,788,519 62,788,519 Money Market Accounts 0.28% 75,253,290 75,253,290 3.05% 25,630,256 25,630,256 Municipal 0.32% 13,344,197 13,344,663 0.30% 15,197,223 14,997,653 US Agency 0.17% 13,991,601 13,986,417 2.38% 184,064,262 180,192,004 US Treasury 0.26% 18,141,101 18,138,748 1.69% 122,917,363 119,875,000 Totals $ 464,520,518 $ 464,513,446 $ 535,415,498 $ 528,301,307 Fourth Quarter-End Yield 0.42% 1.71% Average Quarter-End Yields-Fiscal Year(f): Round Rock-Total Portfolio 0.68% 0.88% TexPool Yield 0.04% 0.90% Rolling Three Mo.Treas. Yield 0.05% 1.06% Rolling Six Mo. Treas.Yield 0.08% 1.01% Rolling 1 Yr.Treas.Yield 0.17% 0.75% Rolling 2 Yr. Treas.Yield 0.78% 0.62% Year-to-date Interest Income $ 3,152,347 Approximate $ 3,379,251 Approximate (f) Average Quarterly Yield calculated using quarter-end report average yield and adjusted book value. City of Round Rock Valley View Consulting,L.L.C. Summary Holdings by Investment Category (Security Sector) 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 June 30, 2022 YTM @ Description Cost Book Value Market Value Cash 0.28% $ 26,709,867 $ 26,709,867 Certificates of Deposit 0.28% 176,250,434 176,250,434 Local Government Investment Pool 1.02% 64,601,951 64,601,951 Money Market Accounts 1.57% 48,915,862 48,915,862 Municipal 0.32% 18,044,191 17,822,639 USAgency 1.64% 115,925,690 114,186,567 US Treasury 1.47% 113,346,588 111,398,146 Total/Average 1.00% $ 563,794,584 $ 559,885,468 Average Yield Current Fiscal Year- Quarter(1) to-Date(2) Total Portfolio 1.71% 0.88% TexPool Yield 2.41% 0.90% Rolling Three Mo.Treas.Yield 2.76% 1.06% Rolling Six Mo.Treas.Yield 2.46% 1.01% Rolling 1 Yr.Treas.Yield 1.70% 0.75% Rolling 2 Yr.Treas.Yield 1.10% 0.62% Investment Income(3) Interest Income(Approximate) $ 1,740,324 $ 3,379,251 WAM at 9/30/2022 Policy WAM Max Total Portfolio 302 days 540 days Pooled Funds 341 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/2022 The Federal Open Market Committee(FOMC)raised the Fed Funds target range 0.75%to 3.00%-3.25%September 21 st(Effective Fed Funds are trading+/-3.10%). The FOMC continued actively reducing their balance sheet. An additional 0.50%-0.75%increase is currently anticipated November 2nd. Second Quarter GDP was confirmed at-0.6%. Domestic and international economies are slowing. September Non-Farm Payroll added 263k new jobs with a Three Month Average of 372k. Crude oil fell below$80 per barrel,but OPEC+announced a target production reduction of 2 million barrelstday. The Stock Markets continued bouncing down and are+/-20%below the 2021 peak. The negatively sloped yield curve(6 months to 10 years,with peak yield at 3 years)may indicate lower future interest rates. Inflation remained well over the FOMC 2%target(Core PCE+/-4.9%and CPI exceeding 8%). 4.50 Treasury Yield Curves 5,250 S&P 500 5,000 4.00 4,750 4,500 3.50 4,250 4,000 3.00 3,750 3,500 2.50 3,250 3,000 2,750 2.00 2,500 or 2,250 1.50 _ _ 1,750 1.00 1,500 41111110 1,000 0.50 - 1,500 00 750 0.00 �y�� �q� �q� �p� 250 0�6��1" l" -l" 1" J�P O Nb N ,113 No N\ NR> L 'S -September 30,2021 June 30,2022 -September 30,2022 6.0o US Treasury Historical Yields-Since 2006 4.50 US Treasury Historical Yields -Since Nov 2015 5.50 4.00 - - 5.00 4.50 3.50 4.00 3.00 3.50 Wd 2.50 3.00 9 IL •� 2.50 2.00 r 2.00 1.50 1.50 1.00 ~I 1.00 dP ^ 0.50 A 0.50 16 0.00 + •+� �, 0.00 , lac jaaAV�js � �A9 ja)��ja�`)�ja ja J��ja� Via)ja J�ja)�a)jaVja)��j c� � d��h 16���6 10 0��6 a�1��a�14 d��1 a��$���1�d���a��9���g o��9 a�tio�a�tio o�1Z aV L`Y�L1 e L�ai lyVIVtiti eSix Month T-Bill Two Year T-Note Ten Year T-Note 1 ��*Six Month T-Bill Two Year T-Note Ten Year T-Note Valley View Consulting,L.L.C. 3 Holdings by Investment Category September 30, 2022 Pooled Debt Service Debt Service Reserve Capital Project&Special Total Funds Funds Funds Purpose Funds Portfolio Description Book Value %of Portfolio Book Value %of Portfolio Book Value %of Portfolio Book Value %of Portfolio Book Value %of Portfolio Cash $ 10,488.641 2% $ 6,780 0% $ — 0% $ — 0% $ 10.495,420 2% Certificates of Deposit 108,697,277 20% — 0% — 0% 5,625,178 1% 114.322,455 21% Investment Pools 21,764,322 4% 3,562,421 1% 268,736 0% 37,193,040 7% 62,788,519 12% Money Market Accounts 23,135,706 4% — 0% 866,983 0% 1,627,567 0% 25,630,256 5% Municipal 15,197,223 3% — 0% — 0% — 0% 15,197,223 3% US Agency 174,066,617 33% — 0% — 0% 9,997.645 2% 184,064,262 34% US Treasury 92,152,669 17% — 0% — 0% 30,764.694 6% 122,917,363 23% Total/Average $445,502,455 83% $ 3,56H 200 1% $ 1,135,719 0% $ 85,208,124 16% $535,415,498 100% Portfolio Balances (Millions) Order of Liquidity $600 ■Cash $500 ■Local Government Investment Pool $400 ■Money Market Account $300 ■US Treasury ■US Agency ❑Municipal $100 ■Certificates of Deposit $0 Pooled Funds DS Funds DSR Funds CPBSP Funds Total Portfolio 9/30/2022 9/30/2022 9/30/2022 9/30/2022 9/30/2022 4 City of Round Rock Valley View Consulting, L.L.C. Investment Holdings by Investment Category Quarterly Transactions By Investment Category September 30,2022 September 30,2022 %of Portfolio Net Cash Equivalent Description Book Value Portfolio Limitation Description Buys Sells Maturities Calls Interest Deposit/(Withdrawal) Cash $ 10,495,420 2 0% 100% Cash $ — $ — $ — $ — $ — $ 16,214,447 Investment Pools 62,788,519 11.7% 100% Investment Pools — — — 334,573 1,81ILL Money Market Accounts 25,630,256 4.8% 75% Money Markets Accounts — — — 214,393 23,285,607 Certificates of Deposit 114,322,455 21.3% 85% Certificates of Deposit 81,612 — 62,009,591 — 97,000 — Commercial Paper —1 0.0% 1 10%/5% Commercial Paper - -I - - Municipal 15,197,223 2.8% 35%/5% Munici al 2,760,000 109,258 — US Agency 184,064,262 34.4% Combined US Agency68,098,970 — 236,500 — US Treasury122,917,363 23.0% 75% US Treasury9,603,533 — — 408,750 — Total/Avera e $ 535,416,498 100% PASSED Totals $ 77,784,115 $ — $ 64,769,591 $ — $ 1,400,474 $ 41,313.486 Portfolio Balances (Millions) Portfolio Composition Order of Liquidity Certificates of September 30,2022 $600 Deposit 21.3% Municipal ■Cash Money Market Accounts 2.8% $500 4.8% ■Local Government Investment Pool Investment Pools $400 -- 11.7% ■Money Market Account $300 ■US Treasury Cash 2.0% $200 ■US Agency $100 ❑Municipal US Agency ■Certificates of Deposit US Treasury 34.4% Ko$0 23.0% 40 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 1.70 1.60 - -- 1.50 ZA 1.40 1.30 -- ---- --- --- ww a 1.20 1.10 1.00 0.90 0.80 0.70 0.60 -- - 0.50 0.40 0.20 %av 0.10 ` 0.00 —j �o �o �o �o �o yo yo 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. Portfolio Balances By Fund (Millions) $600 $500 ■Capital Project& Special Purpose Funds 5400 a Debt Service Reserve Funds $300 a Debt Service Funds $200 $100 ■Pooled Funds $0 �h ^h ^ro pro ^CO CO �1 �1 ^1 �A �45 alb alb �% �O �O ,O �°' tO yO yO 10 O O O O O O O O O O O O O o O O O o O O O O O O O O O O O O�ry ^dry ^dry o�ry O�ry ^dry ^dry O�ry O�ry ^dry ^dry O�ry O�ry ^dry ��ry o�ry O�ry ��ry ^dry O�ry O�ry ^dry ^dry o�ry o�ry ^dry ^dry O�ry o�ry 7 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.031332 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 11 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.150% 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 3041 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 220% Treasury 0.25% Aaa/AA+/AAA 9/30/2021 10,000,000 9,995,410 96.07 9,607,422 9/30/2023 365 0.30% FHLMC 2.00% Aaa/AA+/AAA 2/28/2022 5,000,000 5,023,410 97.54 4,876,889 10/17/2023 382 1.55% 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.477/. 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% Treasury 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% Treasury 2.88% Aaa/AA+/AAA 11/10/2021 5,000,000 5,141,223 98.37 4,918,360 11/30/2023 426 0.44% 8 City of Round Rock Valley View Consulting, L.L.C. Holdings by Allocation and Portfolio (Fund) September 30, 2022 Coupon Settlement Face Amount) Book Days to YTM @ Issuer Rate Credit Rating Date Shares Book Value Price Market Value Maturity Date Maturity Book FHLB 0.50% Aaa/AA+/-- 12/7/2021 8,000,000 7,984,028 95.72 7,657,694 12/8/2023 434 0.67% FHLB 0.63% Aaa/AA+/- 1/5/2022 5,000,000 4,991,117 95.72 4,785,873 12/22/2023 448 0.77% FFCB 0.90% Aaa/AA+/AAA 1/28/2022 5,000,000 4,981,456 95.81 4,790,585 1/18/2024 475 1.19% Treasury 2.25% Aaa/AA+/AAA 1/5/2022 8,000,000 8,156,938 97.33 7,786,562 1/31/2024 488 0.77% Treasury 2.38% Aaa/AA+/AAA 2/14/2022 14,000,000 14,151,045 97.34 13,628,125 2/29/2024 517 1.60% FHLB 1.88% Aaa/AA+/- 2/28/2022 15,000,000 15,055,637 96.89 14,533,034 3/8/2024 525 1.61% FAMC 2.58% 4/18/2022 10,000,000 10,000,000 97.25 9,725,270 4/18/2024 566 2.58% Treasury 2.25% Aaa/AA+/AAA 3/30/2022 10,000,000 9,971,252 96.82 9,682,031 4/30/2024 578 2.44% FAMC 2.65% 5/9/2022 3,000,000 2,996,479 97.49 2,924,591 5/2/2024 580 2.73% FFCB 2.63% Aaa/AA+/AAA 6/2/2022 3,051,000 3,048,862 97.45 2,973,274 5/3/2024 581 2.67% Treasury 2.50% Aaa/AA+/AAA 6/2/2022 7,000,000 6,982,183 97.12 6,798,203 5/31/2024 609 2.66% FHLB 3.13% Aaa/AA+/- 6/23/2022 20,000,000 19,995,599 97.91 19,582,496 6/14/2024 623 3.14% FFCB 3.15% Aaa/AA+/AAA 7/15/2022 10,000,000 10,004,007 97.94 9,793,950 7/15/2024 654 3.13% Treasury 1.75% Aaa/AA+/AAA 9/29/2022 10,000,000 9,575,633 95.58 9,558,203 7/31/2024 670 4.18% FFCB 3.38% Aaa/AA+/AAA 8/31/2022 23,500,000 23,428,274 98.29 23,098,604 8/26/2024 696 3.54% FFCB 3.50% Aaa/AA+/AAA 9/16/2022 20,000,000 19,824,811 98.38 19,676,132 1 9/13/2024 1 7141 3.97% Sub Total/Avera a 1 1.61% 1 1 445,686 946 445,502,455 98.43 438,708,537 1 1 3411 1.58% Fund 170-Interest&Sinking GO Bonds TexasDAILY 2.43% AAAm 1 4/30/2016 27,805 27,805 100.00 27,805 N/A 11 2.43% TexPool 2.41% AAAm 9/30/2015 1,338,789 1,338,789 100.00 1,338,789 N/A 1 2.41% Sub Total/Average 2.41% 1,366,595 1,366,595 1 100.00 1 1,366,595 1 1 2.41% Fund 210-Interest&Sinking Debt Service JPMor an Chase 1 0.40% 9/30/2015 6,780 6,780 1 100.00 1 6,780 N/A 1 0.40% Sub Total/Average 1 0.40% 6,780 6,780 1 100.00 1 6,780 1 0.40% Fund 460-Bond Fund TexPool 2.41% AAAm 1 9/30/2015 883,047 883,047 1 100.00 1 883,047 N/A 1 2.41% Sub Total/Average 2.41% 1 883,047 1 883,047 1 100.00 1 883,047 1 2.41% Fund 462-2017 Bond Fund TexPool 2.41% AAAm 5/30/2017 2,016,724 2,016,724 100.00 2,016,724 N/A 1 2.41% NexBank 3.05% 3/30/2020 1,627,567 1,627,567 100.00 1,627,567 N/A 1 3.05% Treasury 2.38% Aaa/AA+/AAA 6/30/2022 6,000,000 5,996,573 99.53 5,971,640 1/31/2023 123 2.55% Sub Total/Average 2.50% 9,644,291 9,640,864 99.71 9,615,931 77 2.60% Fund 465-Road CO Bond Fund TexPool 2.41% AAAm 9/1/2020 11,510,910 11,510,910 100.00 11,510,910 N/A 1 2.41% Veritex Community Bank 0.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.010/6 FHLB 3.63% Aaa/AA+/- 9/9/2022 10,000,000 9,997,645 99.31 9,931,363 9/6/2023 341 3.65% Sub Total/Average 1.32% 52,136,088 51,901,854 98.98 51,606,513 167 2.23% Fund 591 -Reserves Fund TexPool 2.41% AAAm 1 9/30/2015 8,784 1 8,784 1 100.00 8,784 1 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% AAAm 9/30/2015 2,195,826 2,195,826 100.00 2,195,826 N/A 9 City of Round Rock Valley View Consulting,L.L.C. Holdings by Allocation and Portfolio Fund) September 30, 2022 Coupon Settlement Face AmounU Market Days to YTM @ IssuerRate Credit Rating Date Shares Book Value Price Market Value Maturity Date Maturity Book Sub Total/Average 2.41% 2,195,826 2,195,826 100.00 2,195,826 1 2.41°/ Fund 604-2022 SIB Loan TexPool 2.41% AAAm 9/29/2022 22,782,359 22,782,359 1 100.00 22,782,359 N/A 1 2.41% Sub Total/Average 2.41% 22,782,359 22,782,359 1 100.00 22,782,359 1 2.41% Fund 605-Kalahari Debt Service Reserve TexPool 2.41% AAAm 8/30/2019 259,953 259,953 100.00 259,953 N/A 1 2.41% Sub Total/Average 2.41% 259,953 259,953 100.00 259,953 1 2.41% Total/Average 1.64% $ 536,837,650 $ 535,416,498 98.59 1 $ 528,301,307 1 3021 1.71% 10 City of Round Rock Valley View Consulting, L.L.C. Book Value Comparison September 30, 2022 Issuer Coupon Settlement Maturity Beginning Book Total Buys/ Total Sells/ Ending Book Change in Book Rate Date Date Value Increases Decreases Value Value Fund 000-Pooled Investments JPMor an Chase N/A 9/30/2015 N/A $ 26,707 618 $ — $ 16,218,977 $ 10,488,641 $ 16,218,977 TexPool N/A 9/30/2015 N/A 9,838,079 16,013,341 11,602,244 14,249,176 4,411,097 TexSTAR N/A 9/30/2015 N/A 200,880 951 — 201,831 951 TexasDAILY N/A 9/3012 0 1 5 N/A 22,638,490 389,055 20,750,000 2,277.545 20360945 TexasDAILY N/A 6/1/2021 N/A 1631,656 41497 1,633,715 2,438 1,629.218 TexasDAILY Select N/A 12/3/2021 N/A 5,005,327 28,004 — 5,033,332 28,004 NexBank N/A 11/29/2016 N/A 41,848,912 400,707 19,303,959 22,945,659 18,903,253 Veritex Community Bank N/A 9/1/2020 N/A 3,679,008 11,039 3,500,000 190,047 (3,488,9611 Bank OZK 0.50% 7/9/2020 7/11/2022 10,096,331 — 10,096,331 — 10,096,331 Veritex Community Bank 0.24% 2/5/2021 8/5/2022 3,008,966 — 3,008,966 — 3,008,966 Prosperity Bank 0.20% 2/12/2021 8/12/2022 3,007,983 494 3,008,477 — 3,007,983 Arlington TX HGR EDU 0.50% 4/28/2021 8/15/2022 500,000 — 500,000 — 500,000 Bexar Co Txb Ref 0.33% 9/23/2021 8/15/2022 560,000 — 560,000 — 560,000 City of Bryan TX 0.45% 11/19/2020 8/15/2022 500,000 500,000 — 500,000 Denton ISD 0.00% 12/17/2020 8/15/2022 499,710 — 500,000 — 499,710 City of Austin GO 0.27% 10/6/2020 9/1/2022 700,000 — 700,000 — 700,000 Prosperity Bank 0.20% 6/1/2021 9/1/2022 3,006,005 1,005 3,007,010 — 3,006,005 Veritex Community Bank 0.18% 3/5/2021 9/5/2022 8,018 046 — 8,018,046 — (8,018,0461 State of Texas 2.52% 10/14/2021 10/1/2022 5,030,080 — — 5,000,323 29,756 State of Texas 1.61% 3/19/2021 10/1/2022 3,262,074 — — 3,250,130 11,944 Prosperity Bank 0.40% 10/15/2020 10/17/2022 6,040,091 6,092 — 6,046,183 6,092 Veritex Community Bank 0.26% 2/5/2021 11/4/2022 3,009,714 1,972 — 3,011,687 1,972 Prosperity Bank 0.20% 2/12/2021 11/14/2022 3,007,983 1,517 — 31009,499 1,517 R Bank 0.48% 11/24/2021 11/23/2022 4.009,480 4,854 — 4,014,333 4,854 Bank OZK 0.28% 12/7/2020 12/7/2022 5,021,098 3,557 — 5.024,655 3,557 Prosperity Bank 0.20% 6/9/2021 12/9/2022 10,020,018 5,052 — 10,025,070 5,052 Veritex Community Bank 0.28% 1/6/2021 1/6/2023 4,013,981 2,802 — 4,016,783 2,802 R Bank 0.57% 7/6/2021 1/6/2023 1,004 303 1,433 — 1,005,736 1,433 Treasury 0.13% 1/5/2022 1/31/2023 4,991,086 — — 4,994,900 3,814 San Antonio TX Elec. 2.41% 4/13/2022 2/1/2023 500,000 — — 500,000 — Veritex Community Bank 0.30% 2/5/2021 2/6/2023 4,416,443 3,340 — 4,419,783 3,340 FFCB 0.16% 11/22/2021 2/10/2023 4,996,966 — — 41998,207 1,240 Eagle Pass Texas 4.00% 6/7/2021 3/1/2023 661,363 — — 655,193 6,170 Prosperity Bank 0.25% 3/5/2021 3/6/2023 10 031,347 6 322 — 10,037,670 6,322 Bank OZK 0.26% 3/8/2021 3/8/2023 2,537,364 1,670 — 2,539.034 1,670 FFCB 0.13% 3/26/2021 3/23/2023 8,998,354 — — 8,998,923 569 Prosperity Bank 0.20% 4/12/2021 4/12/2023 5,011,684 2,527 — 5,014,211 2,527 FFCB 0.13% 4/13/2021 4/13/2023 4,997,405 — — 4,998,237 832 FFCB 0.38% 1/28/2022 4/27/2023 3,982 828 — — 3,988,076 5,249 Prosperity Bank 0.20% 5/19/2021 5/19/2023 10,021,720 5,053 — 10,026,773 5,053 FNMA 0.25% 6/23/2022 5/22/2023 4,883,936 — — 4,916,690 32,754 Veritex Community Bank 0.20% 6/1/2021 6/1/2023 20040,030 10,102 — 20,050,132 10,102 Bank OZK 020% 6/9/2021 6/9/2023 8,016,095 4,062 — 8,020,157 4,062 R Bank 0.70% 7/6/2021 7/6/2023 1,005,284 1,761 — 1,007,045 1,761 Treasury1.25% 7/7/2021 7/31/2023 8,088,956 — — 8,068,289 20,666 Veritex CommunityBank 0.25% 7/30/2021 7/31/2023 7,013,145 4,371 — 7,017.516 4,371 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,370,965 — — 4,331,576 (39,389) Veritex CommunityBank 0.25% 8/23/2021 8/23/2023 4,408,233 2,778 — 4,411,010 2,778 FHLMC 0.25% 1/28/2022 8/24/2023 4,954 569 — — 4,964,520 9,952 FHLB 0.00% 8/31/2022 8/28/2023 — 4,830,564 — 4,844.606 4.844,606 FNMA 2.88% 3/30/2022 9/12/2023 4,031,577 1 — — 4 024,959 (6,6 11 City of Round Rock Valley View Consulting,L.L.C. Book Value Comparison September 30, 2022 Issuer Coupon Settlement Maturity Beginning Book Total Buys/ Total Sells/ Ending Book Change in Book Rate Date Date Value Increases Decreases Value Value Treasury 0,25% 9/30/2021 9/30/2023 9,994.253 - - 9,995,410 1.157 FHLMC 2.00% 2/28/2022 10/17/2023 5,029,048 - - 5,023,410 5,638 Treasury 2.88% 11/22/2021 10/31/2023 10,319,055 - - 10,258,905 60,150 FHLB 0.50% 11/12/2021 11/9/2023 4,998,428 - - 4,998,719 291 Treasury 2.88% 11/10/2021 11/30/2023 5,171,722 - - 5,141,223 30,499 Treasury 0.50% 6/23/2022 11/30/2023 4,825,984 - - 4,856,891 30,906 FHLB 0.50% 12/7/2021 12/8/2023 7,980,642 - - 7,984,028 3,386 FHLB 0.63% 1/5/2022 12/22/2023 4,989,293 - - 4,991,117 1,824 FFCB 0.90% 1/28/2022 1/18/2024 4,977,865 - - 4,981,456 3,592 Treasu 2.25% 1/5/2022 1/31/2024 8,186,524 - - 8,156,938 (29,587) Treasury 2.38% 2/14/2022 2/29/2024 14,177,923 - - 14,151,045 26,878 FHLB 1.88% 2/28/2022 3/8/2024 15,065,387 - - 15,055,637 9,750 FAMC 2.58% 4/18/2022 4/18/2024 10,000,000 - - 10,000,000 - freasury 2.25% 3/30/2022 4/30/2024 9,966 676 - - 9,971,252 4,576 FAMC 2.65% 5/9/2022 5/2/2024 2,995,920 - - 2,996,479 559 FFCB 2.63% 6/2/2022 5/3/2024 3,048,524 - - 3,048,862 338 Treasury 2.50% 6/2/2022 5/31/2024 6,979,491 - - 6,982,183 2,692 FHLB 3.13% 6/23/2022 6/14/2024 19 994,949 - - 19,995 599 650 FFCB 3.15% 7/15/2022 7/15/2024 - 10,004,479 - 10,004,007 10,004,007 Treasury 1.75% 9/29/2022 7/31/20,24 - 9,603,533 - 9,575,633 9,575,633 FFCB 3.38% 8/31/2022 8/26/2024 - 23,436,198 - 23,428.274 23,428,274 FFCB 3.50% 9/16/2022 9/13/2024 - 19,827,209 - 19,824,811 19,824,811 Sub Total/Average Fund 000-Pooled Investments 463,986,866 84,620,340 102,907,727.1 445,502,455 18,484,411 Fund 170-Interest&Sinking GO Bonds TexPool N/A 9/30/2015 N/A 21842,069 8,385,786 9,889.066 1,338,789 1,503,280 TexasDAILY N/A 4/30/2016 N/A 191,403 439 164,037 27,805 163,598 NexBank N/A 2/27/2017 N/A 695,078 963 696,041 - 695,078 East West Bank 0.27% 1/10/2022 7/11/2022 8,010 185 - 8,010,185 - (8,010,185) East West Bank 0.48% 2/1/2022 8/1/2022 2,805,529 1,144 2,806,673 - 2,805.529 East West Bank 0.73% 2/16/2022 8/10/2022 5,013,518 3,109 5,016,627 - 5,013,518 Sub Total/Average Fund 170-Interest&SinkingGO Bonds 19,557,782 8,391,442 26,582,629 1,366,595 18,191,188 Fund 210-Interest&Sinking Debt Service JPMor an Chase N/A 9/30/2015 N/A 2,249 4,530 - 6,780 4,530 Sub Total/Average Fund 210-Interest&Sinking Debt Service 2,249 1 4,530 - 6,780 4,530 Fund 460-Bond Fund TexPool N/A 9/30/2015 N/A 3,755,876 15,308 2,888,137 883,047 2,872,829 Sub Total/Average Fund 460-Bond Fund 3,755,876 15,308 2,888,137 883,047 2,872,829 Fund 462-2017 Bond Fund TexPool N/A 5/30/2017 N/A 2.002,361 14,363 - 2,016,724 14,363 NexBank N/A 3/30/2020 N/A 1,616,328 11,239 - 1,627.567 11,239 Treasury 2.38% 6/30/2022 1/31/2023 5,994,009 - - 5,996,573 2,563 Sub Total/Average Fund 462-2017 Bond Fund 1 9,612,698 1 25,602 11 9,640,864 28,165 Fund 465-Road CO Bond Fund TexPool N/A 9/1/2020 N/A 10,946,847 41038,792 3,474 729 11,510,910 564,063 Prosperity Bank 0.20% 7/6/2021 7/6/2022 10,018,371 - 10,018 371 - 10,018,371 Prosperity Bank 0.20% 6/1/2021 9/1/2022 7,014 013 2,345 7,016,357 (7,014,013) Veritex Community Bank 0.30% 2/5/2021 2/6/2023 5,620,928 4,250 - 5.625,178 4.250 Treasury 0.13% 6/2/2022 3/31/2023 24,650,908 - - 24,768,121 117,213 FHLB 3.63% 9/9/2022 9/6/2023 - 10,000,521 - 9,997,645 9,997,645 12 City of Round Rock Valley View Consulting, L.L.C. Book Value Comparison September 30, 2022 Coupon Settlement Maturity Beginning Book Total Buys/ Total Sells/ Ending Book Change in Book Issuer Rate Date Date Value Increases Decreases Value Value Sub Total/Average Fund 465-Road CO Bond Fund 58,251,067 14,045,908 20,509,458 51,901,854 6,349,213) Fund 591 -Reserves Fund TexPool N/A 9/30/2015 N/A 8,739 45 - 8,784 45 NexBank N/A 4/29/2019 N/A 860,996 5,987 1 866,983 5,987 Sub Total/Average Fund 591-Reserves Fund 869,735 6,032 1 875,766 6,032 Fund 602-Interest&Sinking Revenue Bonds TexPool N/A 9/30/2015 N/A 3,430,463 109,081 1,343,719 2,195,826 1,234,637 East West Bank 0.27% 1/10/2022 7/11/2022 2,002,546 1 - 2,002,546 1 - 2,002,546 Sub Total/Average Fund 602-Interest&Sinking Revenue Bonds 5,433,010 1 109,081 3,346,265 1 2,195,826 3,237,184 Fund 604-2022 SIB Loan TexPool N/A 9/29/2022 N/A - 22,782,359 - 22.782 359 22,782,359 Sub Total/Average Fund 600-2022 SIB Loan - 22,782,359 - 22,782,359 22,782,359 Fund 605-Kalahari Debt Service Reserve TexPool N/A 8/30/2019 N/A 1,889,344 368,513 1.997,904 1 259.953 1,629,391 Sub Total/Avera a Fund 605-Kalahari Debt Service Reserve 1,889,344 368,513 1,997,904 1 259,953 1,629,391 Fund 863-Drainage Utility Revenue Bond TexPool N/A 10/31/2015 1 N/A 1 220.416 1 673 221089 1 - 220,416 NexBank N/A 8/30/2020 N/A 215.542 1,049 216,591 - 215,542 Sub Total/Average Fund 863-Drainage Utility Revenue Bond 435,957 1,723 437,680 - 435,957 Total/Average $ 663,794,684 S 130,370,838 S 158,669,801 S 535,415,498 1S 28,379,086 13 City of Round Rock Valley View Consulting,L.L.C. Market Value Comparison September 30, 2022 Coupon Settlement Maturity Beginning Total Buys/ Total Sells/ Ending Market Change in Issuer Rate Date Date Market Value Increases Decreases Value Market Value Fund 000-Pooled Investments JPMor an Chase N/A 9/30/2015 N/A $ 26,707,618 $ — $ 16,218,977 $ 10,488,641 $ — TexPool N/A 9/30/2015 N/A 9,838,079 16,013,341 11,602244 14,249,176 — TexSTAR N/A 9/30/2015 N/A 200,880 951 — 201,831 — TexasDAILY N/A 9/30/2015 N/A 22,638,490 389,055 20,750,000 2,277,545 — TexasDAILY N/A 6/1/2021 N/A 1,631,656 4,497 1,633,715 2,438 — TexasDAILY Select N/A 12/3/2021 N/A 5,005,327 28,004 — 5,033,332 — NexBank N/A 11/29/2016 N/A 41,848,912 400,707 19,303,959 22,945,659 — Veritex Community Bank N/A 9/1/2020 N/A 3,679 008 11,039 3,500,000 190,047 — Bank OZK 0.50% 7/9/2020 7/11/2022 10,096,331 — 10,096,331 — — Veritex Community Bank 0.24% 2/5/2021 8/5/2022 3,008,966 — 3,008,966 —Prosperity Bank 0.20% 2/12/2021 8/12/2022 3,007,983 494 3,008,477 —Arlington TX HGR EDU 0.50% 4/28/2021 8/15/2022 498,555 — 500,000 — 1,445 Bexar Co Txb Ref 0.33% 9/23/2021 8/15/2022 558,908 — 560,000 — 1,092 City of Bryan TX 0.45% 11/19/2020 8/15/2022 499,285 — 500,000 — 715 Denton ISD 0.00% 12/17/2020 8/15/2022 498.925 — 500,000 — 1,075 City of Austin GO 0.27% 10/6/2020 9/1/2022 698,453 — 700,000 — 1,547 Prosperity Bank 0.20% 6/1/2021 9/1/2022 3,006,005 1,005 3,007,010 — — Veritex Community Bank 0.18% 3/5/2021 9/5/2022 8,018,046 — 8,018,046 — — State of Texas 2.52% 10/14/2021 10/1/2022 5,008,950 — — 5,000,000 81950 State of Texas 1.61% 3/19/2021 10/1/2022 3,248,895 — — 3,250,000 1,105 Prosperity Bank 0.40% 10/15/2020 10/17/2022 6,040,091 6,092 — 6,046,183 — Veritex Community Bank 0.26% 2/5/2021 11/4/2022 3,009 714 1,972 — 3,011,687 — Prosperity Bank 0.20% 2/12/2021 11/14/2022 3,007,983 1,517 — 3,009,499 — R Bank 0.48% 11/24/2021 11/23/2022 4,009 480 4,854 — 4,014,333 — Bank OZK 0.28% 12/7/2020 12/7/2022 5,021,098 3,557 — 5,024,655 — Prosperity Bank 0.20% 6/9/2021 12/9/2022 10,020,018 5.052 — 10,025,070 — Veritex Community Bank 0.28% 1/6/2021 1/6/2023 4,013,981 2,802 — 4,016,783 — R Bank 0.57% 7/6/2021 1/6/2023 1,004,303 1,433 — 1,005,736 — Treasury 0.13% 1/5/2022 1/31/2023 4,929,464 — — 4,940,430 10,966 San Antonio TX Elec. 2.41% 4/13/2022 2/1/2023 498,375 — — 497,275 1,100 Veritex Community Bank 0.30% 2/5/2021 2/6/2023 4,416,443 3,340 — 4,419,783 — FFCB 0.16% 11/22/2021 2/10/2023 4,919,492 — 4,930,832 11,341 Eagle Pass Texas 4.00% 6/7/2021 3/1/2023 655,101 — — 646,974 81127 Prosperity Bank 0.25% 3/5/2021 3/6/2023 10,031 347 6,322 10,037 670 — Bank OZK 0.26% 3/8/2021 3/8/2023 2,537.364 1,670 — 21539,034 — FFCB 0.13% 3/26/2021 3/23/2023 8,824,560 — — 8,842,386 17,825 Prosperity Bank 0.20% 4/12/2021 4/12/2023 5,011.684 2,527 — 5,014,211 — FFCB 0.13% 4/13/2021 4/13/2023 4,894 911 — — 4,897,194 2,283 FFCB 0.38% 1/28/2022 4/27/2023 3,917,041 — — 3,918,332 1,291 Prosperity Bank 0.20% 5/19/2021 5/19/2023 10,021 720 5,053 — 10,026,773 — FNMA 0.25% 6/23/2022 5/22/2023 4,883,371 — — 4,880,122 3,250 Veritex Community Bank 0.20% 6/1/2021 6/1/2023 20,040 030 10,102 — 20,050,132 — Bank OZK 0.20% 6/9/2021 6/9/2023 8,016,095 4,062 — 8,020,157 — R Bank 0.70% 7/6/2021 7/6/2023 1,005,284 1,761 — 1,007,045 — Treasury 1.25% 7/7/2021 7/31/2023 7,858,743 — — 7,806,875 51,868 Veritex Community Bank 0.25% 7/30/2021 7/31/2023 7,013,145 4,371 — 7,017 516 Arlington TX HGR EDU 0.63% 4/28/2021 8/15/2023 1,417,558 — — 1,413,397 4,161 Dallas ISD 4.00% 4/22/2021 8/15/2023 4,239 635 — — 4,190,008 (49,627) Veritex CommunityBank 0.25% 8/23/2021 8/23/2023 4,408,233 2,778 — 4,411,010 — FHLMC 0.25% 1/28/2022 8/24/2023 4,850,686 — — 4,825,811 24,875 FHLB 0.00% 8/31/2022 8/28/2023 — 4,830,564 — 4,803,950 26,614 FNMA 2.88% 3/30/2022 9/12/2023 3,998,864 — — 3,943 184 55,681 14 City of Round Rock Valley View Consulting, L.L.C. Market Value Comparison September 30, 2022 Coupon Settlement Maturity Beginning Total Buys/ Total Sells/ Ending Market Change in Issuer Rate Date Date Market Value Increases Decreases Value Market Value Treasury 0.25% 9/30/2021 9/30/2023 9,675,159 — — 9.607,422 67,737 FHLMC 2.00% 2/28/2022 10/17/2023 4,939,565 — — 4,876,889 62,676 Treasury 2.88% 11/22/2021 10/31/2023 9,990,234 — — 9,851.953 138,281 FHLB 0.50% 11/12/2021 11/9/2023 4,836 804 — — 4,800,440 36,364 Treasury 2.88% 11/10/2021 11/30/2023 4,996,623 — — 4,918,360 78,264 Treasury 0.50% 6/23/2022 11/30/2023 4,832,339 — — 4,786,133 46,206 FHLB 0.50% 12/7/2021 12/8/2023 7,733,141 — — 7,657,694 75,446 FHLB 0.63% 1/5/2022 12/22/2023 4,834 094 — — 4,785,873 (48,222) FFCB 0.90% 1/28/2022 1/18/2024 4,844,765 — — 4,790,585 54,180 Treasury 2.25% 1/5/2022 1/31/2024 7,914 778 — — 7,786,562 (128,215) Treasury 2.38% 2/14/2022 2/29/2024 13,874.923 — — 13,628,125 246,798 FHLB 1.88% 2/28/2022 3/8/2024 14,734,104 — — 14,533,034 201071 FAMC 2.58% 4/18/2022 4/18/2024 9,927.763 — — 9,725.270 202,493 Treasury 2.25% 3/30/2022 4/30/2024 9,876,563 — — 9,682,031 (194,532) FAMC 2.65% 5/9/2022 5/2/2024 2,980 515 — — 2,924,591 (55,924) FFCB 2.63% 6/2/2022 5/3/2024 3,029,475 — — 2,973,274 56,200 Treasury 2.50% 6/2/2022 5/31/2024 6,942,478 — — 6,798,203 144,274 FHLB 3.13% 6/23/2022 6/14/2024 20,037,418 — — 19,582,496 454,922 FFCB 3.15% 7/15/2022 7/15/2024 — 10 004,479 — 9,793,950 210,529 Treasury 1.75% 9/29/2022 7/31/2024 — 9,603,533 — 9,558,203 16,797 FFCB 3.38% 8/31/2022 8/26/2024 — 23,436,198 — 23,098,604 326,579 FFCB 3.50% 9/16/2022 9/13/2024 — 19,827,209 — 19,676,132 145,244 Sub Total/Average Fund 000-Pooled Investments 460,215,823 84,620,340 102,907,727 438,708,537 3,174,518 Fund 170-Interest&Sinking GO Bonds TexPool N/A 9/30/2015 N/A 2,842,069 8,385,786 9,889.066 1,338,789 — TexasDAILY N/A 4/30/2016 N/A 191,403 439 164,037 27,805 — NexBank N/A 2/27/2017 N/A 695,078 963 696,041 — — East West Bank 0.27% 1/10/2022 7/11/2022 8,010 185 8,010,185 — — East West Bank 0.48% 2/1/2022 8/1/2022 2,805,529 1,144 2,806,673 — — East West Bank 0.73% 2/16/2022 8/10/2022 51013,518 3,109 5,016,627 — — Sub Total/Average Fund 170-Interest&Sinking GO Bonds 1 1 19,557,782 1 8,391,442 26,582,629 1,366,595 — Fund 210-Interest&Sinking Debt Service JPMor an Chase N/A 9/30/2015 N/A 1 2,249 4,530 — 6,780 — Sub Total/Average Fund 210-Interest&Sinking Debt Service 1 2,249 4,530 — 6,780 — Fund 460-Bond Fund TexPool N/A 9/30/2015 N/A 3,755,876 15,308 2,888,137 883,047 — Sub Total/Average Fund 460-Bond Fund 1 3,755,876 15,308 2,888,137 883,047 — Fund 462-2017 Bond Fund TexPool N/A 5/30/2017 N/A 2,002,361 14,363 — 2,016,724 — NexBank N/A 3/30/2020 N/A 1,616,328 11,239 — 1,627,567 — Treasury 2.38% 6/30/2022 1 1/31/2023 5,992,031 — — 5,971,640 20,391 Sub Total/Average Fund 462-2017 Bond Fund 9,610,720 25,602 — 9,615,931 20,391 Fund 465-Road CO Bond Fund TexPool N/A 9/1/2020 N/AM-47 4,038 792 3,474,72 11,510,910 Prosperity Bank 0.20% 7/6/2021 7/6/2022 — 10,018,371 —Prosperity Bank 0.20% 6/1/2021 9/1/2022 2,345 7,016,357 — — Ventex CommunityBank 0.30% 2/5/2021 2/6/2023 4,250 — 5,625.178 — Treasu 0.13% 6/2/2022 3/31/2023 — — 24,539,063 24,250 FHLB 3.63% 9/9/2022 9/6/202310,000,521 — 9,931,363 66,137 15 City of Round Rock Valley View Consulting,L.L.C. Market Value Comparison September 30, 2022 Issuer Coupon Settlement Maturity Beginning Total Buys/ Total Sells/ Ending Market Change in Rate Date Date Market Value Increases Decreases Value Market Value Sub Total/Average Fund 465-Road CO Bond Fund 58,114,971 14,045,908 20,509,458 51,606,513 41,887) Fund 591 -Reserves Fund TexPool N/A 1 9/30/2015 N/A 8,739 45 — 8,784 — NexBank N/A 4/29/2019 N/A 860,996 5,987 — 866.983 — Sub Total/Average Fund 591-Reserves Fund 869,735 6,032 — 875,766 — Fund 602-Interest&Sinking Revenue Bonds TexPool N/A 9/30/2015 N/A 3,430,463 109,081 1,343,719 2,195,826 — East West Bank 0.27% 1/10/2022 1 7/11/2022 1 2,002,546 1 — 2,002.546 1 — — Sub Total/Average Fund 602-Interest&Sinking Revenue Bonds 1 1 5,433,010 109,081 3,346,265 1 2,195,826 — Fund 604-2022 SIB Loan TexPool N/A 9/29/2022 N/A — 22.782,359 — 22.782,359 — Sub Total/Average Fund 600-2022 SIB Loan — 22,782,359 — 22,782,359 — Fund 605-Kalahari Debt Service Reserve TexPool N/A 8/30/2019 N/A 1 1,889,344 368,513 1,997,904 259,953 — Sub Total/Average Fund 605-Kalahari Debt Service Reserve 1 1,889,344 368,513 1,997,904 259,953 — Fund 863-Drainage Utility Revenue Bond TexPool N/A 10/31/2015 N/A 220,416 673 221.089 — — NexBank N/A 8/30/2020 N/A 215,542 1.049 216,591 — — Sub Total/Average Fund 863-Drainage Utility Revenue Bond 1 435,957 1,723 437,680 — — Total/Average 1 $ 569,885,468 $ 130,370,838 S 158,669,801 $ 528,301,307 E 3,236,796 16 City of Round Rock Valley View Consulting, L.L.C. Holdings by Allocation and Portfolio (Fund) June 30, 2022 Coupon Settlement Face Amount/ Market Days to YTM @ Issuer Rate Credit Rating Date Shares Book Value Price Market Value Maturity Date Maturity Book Fund 000-Pooled Investments NexBank 1.60% 11/29/2016 $ 41,848,912 $ 41,848,912 100.00 $ 41,848,912 N/A 1 1.60% TexasDAILY 1.00% AAAm 6/1/2021 1,631,656 1,631.656 100.00 1,631,656 N/A 1 1.00% TexasDAILY Select 1.26% AAAm 12/3/2021 5,005,327 5,005,327 100.00 5,005.327 N/A 1 1.26% Veritex Community Bank 1.21% 9/1/2020 3,679,008 3,679,008 100.00 3,679,008 N/A 1 1.21% JPMor an Chase 0.28% 9/30/2015 26,707,618 26,707,618 100.00 26,707.618 N/A 1 0.28% TexSTAR 0.99% AAAm 9/30/2015 200,880 200,880 100.00 200,880 N/A 1 0.99% TexPool 1.00% AAAm 9/30/2015 91838,079 9,838,079 100.00 9,838,079 N/A 1 1,00% TexasDAILY 1.00% AAAm 9/30/2015 22,638,490 22,638,490 100.00 22,638,490 N/A 1 1.00% Bank OZK 0.50% 7/9/2020 10,096,331 10,096,331 100.00 10,096,331 7/11/2022 11 0.50% Veritex Community Bank 0.24% 2/5/2021 3,008,966 3,008,966 100.00 3,008,966 8/5/2022 361 0.24% Prosperity Bank 0.20% 2/12/2021 3,007,983 3,007,983 100.00 3,007,983 8/12/2022 43 0.20% Bexar Co Txb Ref 0.33% Al/AA/A- 9/23/2021 560,000 560,000 99.81 558,908 8/15/2022 46 0.33% Arlington TX HGR EDU 0.50% -/AAA/- 4/28/2021 500,000 500,000 99.71 498,555 8/15/2022 46 0.50% Denton ISD 0.00% -/AAA/AAA 12/17/2020 500,000 499,710 99.79 498,925 8/15/2022 46 0.46% City of Bryan TX 0.45% -/AA/- 11/19/2020 500,000 500,000 99.86 499,285 8/15/2022 46 0.45% City of Austin GO 0.27% Aa1/AAA/AA+ 10/6/2020 700,000 700,000 99.78 698,453 9/1/2022 63 0.27% Prosperity Bank 0.20% 6/1/2021 3,006,005 3,006,005 100.00 3,006.005 9/1/2022 63 0.20% Veritex Community Bank 0.18% 3/5/2021 8,018,046 8,018,046 100.00 8.018.046 9/5/2022 67 0.18% State of Texas 1,61% Aaa/AAA/- 3/19/2021 3,250,000 3,262,074 99.97 3,248,895 10/1/2022 93 0.15% State of Texas 2.52% Aaa/AAA/- 10/14/2021 5,000,000 5,030,080 100.18 5,008,950 10/1/2022 93 0.15% Prosperity Bank 0,40% 10/15/2020 6,040,091 6,040,091 100.00 6,040,091 10/17/2022 109 0.40% Veritex Community Bank 0.26% 2/5/2021 3,009,714 3,009,714 100.00 3,009,714 11/4/2022 127 0.26% Prosperity Bank 0.20% 2/12/2021 3,007,983 3,007,983 100.00 3,007,983 11/14/2022 137 0.20% R Bank 0.48% 11/24/2021 4,009,480 4,009,480 100.00 4,009,480 11/23/2022 1461 0.48% Bank OZK 0.28% 12/7/2020 5,021,098 5,021,098 100.00 5,021,098 12/7/2022 160 0.28% Prosperity Bank 0.20% 6/9/2021 10,020,018 10,020,018 100.00 10,020,018 12/9/2022 162 0.20% Veritex Community Bank 0.28% 1/6/2021 4,013,981 4,013,981 100.00 4,013,981 1/6/2023 190 0.28% R Bank 0.57% 7/6/2021 1,004,303 1,004,303 100.00 1,004,303 1/6/2023 190 0.57% Treasury 0.13% Aaa/AA+/AAA 1/5/2022 5,000,000 4,991,086 98.59 4,929,464 1/31/2023 215 0.43% San Antonio TX Elec. 2.41% Aa2/AA-/AA- 4/13/2022 500,000 500,000 99.68 498,375 2/1/2023 216 2.41% Veritex Community Bank 0.30% 2/5/2021 4,416,443 4,416,443 100.00 4,416,443 2/6/2023 221 0.30% FFCB 0.16% Aaa/AA+/AAA 11/22/2021 5,000,000 4,996,966 98.39 4,919,492 2/10/2023 225 0.26% Eagle Pass Texas 4.00% -/AA-/- 6/7/2021 645,000 661,363 101.57 655,101 3/1/2023 244 0.20% Prosperity Bank 0.25% 3/5/2021 10,031,347 10.031.347 100.00 10,031,347 3/6/2023 249 0.25% Bank OZK 0.26% 3/8/2021 2,537.364 2.537,364 100.00 2,537.364 3/8/2023 251 0.26% FFCB 0.13% Aaa/AA+/AAA 3/26/2021 9,000,000 8,998,354 98.05 8,824,560 3/23/2023 266 0.15% Prosperity Bank 0.20% 4/12/2021 5,011.684 5.011,684 100.00 5,011,684 4/12/2023 2861 0.20% FFCB 0.13% Aaa/AA+/AAA 4/13/2021 5,000,000 4,997,405 97.90 4,894,911 4/13/2023 2871 0.19% FFCB 0.38% Aaa/AA+/AAA 1/28/2022 4,000,000 3,982,828 97.93 3,917,041 4/27/2023 3011 0.90% Prosperity Bank 0.20% 5/19/2021 10,021,720 10,021,720 100.00 10,021,720 5/19/2023 323 0.20% FNMA 0.25% Aaa/AA+/AAA 6/23/2022 5,000,000 4.883.936 97.67 4,883,371 5/22/2023 326 2.90% Veritex Community Bank 0.20% 5/1/2021 20,040,030 20,040,030 100.00 20,040,030 6/1/2023 336 0.20% Bank OZK 0.20% 6/9/2021 8,016.095 8.016,095 100.00 8,016.095 6/9/2023 344 0.20% R Bank 0.70% 7/6/2021 1.005,284 1,005,284 100.00 1.005,284 7/6/2023 371 0.70% Treasury 1.25% Aaa/AA+/AAA 7/7/2021 8,000.000 8,088,956 98.23 7,858,743 7/31/2023 396 0.22% Veritex Community Bank 0.25% 7/30/2021 7,013,145 7,013.145 100.00 7,013,145 7/31/2023 396 0.25% Dallas ISD 4.00% Aaa/AAA/AAA 4/22/2021 4,195.000 4,370,965 101.06 4.239.635 8/15/2023 411 0.26% Arlington TX HGR EDU 0.63% -/AAA/- 4/28/2021 1,460.000 1,460,000 97.09 1,417,558 8/15/2023 4111 0.63% 17 City of Round Rock Valley View Consulting. L.L.C. Holdings by Allocation and Portfolio (Fund) June 30, 2022 Coupon Settlement Face Amount/ Market Days to YTM @ Issuer Rate Credit Rating Date Shares Book Value Price Market Value Maturity Date Maturity Book Veritex Community Bank 0.25% 8/23/2021 4,408,233 4,408,233 100.00 4,408,233 8/23/2023 419 0.25% FHLMC 0.25% Aaa/AA+/AAA 1/28/2022 5,000,000 4,954,569 97.01 4,850,686 8/24/2023 420 1.05% FNMA 2.88% Aaa/AA+/AAA 3/30/2022 4,000.000 4,031,577 99.97 3,998,864 9/12/2023 439 2.20% Treasury 0.25% Aaa/AA+/AAA 9/30/2021 10,000,000 9,994,253 96.75 9,675,159 9/30/2023 457 0.30% FHLMC 2.00% Aaa/AA+/AAA 2/28/2022 5,000.000 5,029,048 98.79 4,939,565 10/17/2023 474 1.55% Treasury 2.88% Aaa/AA+/AAA 11/22/2021 10,000,000 10,319,055 99.90 9,990,234 10/31/2023 488 0.47% FHLB 0.50% Aaa/AA+/-- 11/12/2021 5,000,000 4.998,428 96.74 4,836,804 11/9/2023 497 0.52% Treasury 0.50% Aaa/AA+/AAA 6/23/2022 5000,000 4,825,984 96.65 4,832,339 11/30/2023 518 3.03% Treasury 2.88% Aaa/AA+/AAA 11/10/2021 5,000,000 5.171,722 99.93 4.996,623 11/30/2023 518 0.44% FHLB 0.50% Aaa/AA+/-- 12/7/2021 8,000,000 7,980,642 96.66 7,733,141 12/8/2023 526 0.67% FHLB 0.63% Aaa/AA+/-- 1/5/2022 5,000,000 4.989,293 96.68 4,834,094 12/22/2023 5401 0.77% FFCB 0.90% Aaa/AA+/AAA 1/28/2022 5,000,000 4,977,865 96.90 4,844,765 1/18/2024 567 1.19% Treasury 2.25% Aaa/AA+/AAA 1/5/2022 8.000.000 8.186,524 98.93 7,914,778 1/31/2024 580 0.77% Treasury 2.38% Aaa/AA+/AAA 2/14/2022 14,000,000 14,177,923 99.11 13,874,923 2/29/2024 609 1.60% FHLB 1.88% Aaa/AA+/-- 2/28/2022 15,000,000 15,065,387 98.23 14,734,104 3/8/2024 617 1.61% FAMC 2.58% 4/18/2022 10,000,000 10,000,000 99.28 9,927,763 4/18/2024 658 2.58% Treasury 2.25% Aaa/AA+/AAA 3/30/2022 10,000,000 9,966,676 98.77 9,876,563 4/30/2024 670 2.44% FAMC 2.65% 5/9/2022 3,000,000 2,995,920 99.35 2,980,515 5/2/2024 672 2.73% FFCB 2.63% Aaa/AA+/AAA 6/2/2022 3,051,000 3,048,524 99.29 3,029,475 5/3/2024 673 2.67% Treasury 2.50% Aaa/AA+/AAA 6/2/2022 7,000,000 6,979,491 99.18 6,942,478 5/31/2024 701 2.66% FHLB 3.13% Aaa/AA+/-- 6/23/2022 20,000,000 19,994,949 100.19 20,037,418 6/14/2024 715 3.14% Sub Total I Average 1.12% 1 463,176,314 463,986,866 99.36 1 460,215,823 297 0.98% Fund 170-Interest&Sinking GO Bonds Texas DAILY 1.00% AAAm 4/30/2016 191,403 191,403 100.00 191,403 N/A 1 1.00% NexBank 1.60% 2/27/2017 695,078 695,078 100.00 695,078 N/A 1 1.60% TexPool 1.00% AAAm 9/30/2015 2,842,069 2,842,069 100.00 2,842,069 N/A 1 1.00% East West Bank 0.27% 1/10/2022 8,010,185 8,010,185 100.00 8.010,185 7/11/2022 11 0.27% East West Bank 0.48% 2/1/2022 2,805,529 2,805,529 100.00 2,805,529 8/1/2022 32 0.48% East West Bank 0.73% 2/16/2022 5,013,518 5,013,518 100.00 5.013,518 8/10/2022 41 0.73% Sub Total/Average 0.58% 19,557,782 19,557,782 100.00 19,557,782 201 0.58% Fund 210-Interest&Sinking Debt Service JPMor an Chase 0.28% 9/30/2015 2,249 2.249 100.00 2,249 N/A 1 0.28% Sub Total/Average 0.28% 2,249 2,249 100.00 2,249 1 0.28% Fund 460-Bond Fund TexPool 1.00% AAAm 9/30/2015 3.755,876 3.755,876 100.00 3,755.876 N/A Sub Total/Average 1.00°% 3,755,876 3,755,876 100.00 3,755,876 Fund 462-2017 Bond Fund TexPool 1.00% AAAm 5/30/2017 2,002,361 2,002,361 100.00 2,002,361 N/A 1 1.00% NexBank 1.60% 3/30/2020 1,616,328 1,616,328 100.00 1,616,328 N/A 1 1.60% Treasury 2.38% Aaa/AA+/AAA 6/30/2022 6,000,000 5,994,009 99.87 5,992,031 1/31/2023 215 2.55% Sub Total/Average 1.96% 9,618,689 9,612,698 99.92 9,610,720 134 2.07% Fund 465-Road CO Bond Fund TexPool 1.00% AAAm 1 9/1/2020 1 10,946,847 1 10,946,847 100.00 10,946,847 1 N/A 1 1.00% Prosperity Bank 0.20% 7/6/2021 1 10,018.371 1 10,018,371 100.00 10,018,371 7/6/2022 61 0.20% Prosperity Bank 0.20% 6/1/2021 7,014.013 7,014.013 100.00 7,014,013 9/1/2022 631 0.20% Veritex Community Bank 0.30% 2/5/2021 5,620,928 5,620,928 100.00 5,620,928 2/6/2023 2211 0.30% 18 City of Round Rock Valley View Consulting, L.L.C. Holdings by Allocation and Portfolio Fund) June 30, 2022 Coupon Settlement Face Amount/ Market Days to YTM @ Issuer CouponCredit Rating Date Shares Book Value Price Market Value Maturity Date Maturity Book Treasury 0.13% Aaa/AA+/AAA 6/2/2022 25,000,000 24,650,908 98.06 24,514,813 3/31/2023 274 2.01% Sub Total/Average 0.33% 58,600,159 58,251,067 99.17 58,114,971 147 1.13% Fund 591 -Reserves Fund TexPool 1.00% AAAm 9/30/2015 8,739 8,739 1 100.00 1 8,739 N/A 1 1.00% NexBank 1.60% 4/29/2019 860,996 860,996 100.00 860,996 N/A 1 1.60% Sub Total/Average 1.59% 869,735 869,735 100.00 869,735 1 1.59% Fund 602-Interest&Sinking Revenue Bonds TexPool 1.00% AAAm 9/30/2015 3,430,463 3,430,463 100.00 3,430,463 N/A 1 1.00% East West Bank 0.27% 1/10/2022 2,002,546 2,002,546 100.00 2,002,546 7/11/2022 111 0.27% Sub Total/Average 0.73% 5,433,010 6,433,010 100.00 5,433,010 51 0.73% Fund 605-Kalahari Debt Service Reserve TexPool 1 1.00% AAAm 8/30/2019 1,889,344 1,889,344 100.00 1,889,344 N/A 11 1.00% Sub Total/Average 1 1.00% 1,889,344 1,889,344 100.00 1,889,344 11 1.00% Fund 863-Drainage Utility Revenue Bond NexBank 1.60% 8/30/2020 215,542 215,542 100.00 215,542 N/A 1 1.60% TexPool 1.00% AAAm 10/31/2015 220,416 220,416 100.00 220,416 N/A 1 1.00% Sub Total/Average 1.30% 435,957 435,957 100.00 435,957 1 1.300/, ,Total/Average 1.03% $ 563,339,115 $ 563,794,584 99.39 $ 559,885,468 262 1.00% 19 City of Round Rock Valley View Consulting,L.L.C. City of Round Rock GENERAL JOURNAL ENTRY PROOF 'Journal Summary Year Period Journal Journal Desc Ref 2 Ref 3 2022 12 1119 ACCRUAL RECEIVABLEMAR TORNADO Src Eff Date Account Ref 1 Account Description T OB Debit Credit Project String Line Description GEN 09/30/2022 10000000-1210- DSD Acounts Receivable General 496,342.45 TML REC FOR TORNADO GEN 09/30/2022 10023000-6710- DSD Tornado Clean-up 2022 496,342.45 TML REC FOR TORNADO Totals 496,342.45 496,342.45 GEN 09/30/2022 10000000-9002- DSD Expenditure Offset 496.342.45 PeriodFund Summary Year Journal Eff Date 2022 12 1119 09/30/2022 Fund Fund Description Account Account Description Debit Credit 100 General Fund 10000000-1210- Acounts Receivable General 496,342.45 100 General Fund 10000000-9002- Expenditure Offset 496,342.45 Fund Totals 496,342.45 496,342.45 Due To/Due Fund . Description DUE To DIJEFROM 0.00 0.00 Totals 0.00 0.00 End of Report-Generated by Debra Doss" Report generated: 10/31/202212:04:34 Page 1 User: Debra Doss(6455ddos) Program ID: glcjeent